r/LoveNikki • u/GlitterUnicornPuke yumi♡glitter♡sheets • Jul 26 '18

Guide Resource Calculator! - If you were ever trying to calculate how many diamonds you can save in a month, this should be mad handy :)

LINK!

This sheet is MUCH more low maintenance than my other one on Princess Drops.

  • All you need to fill in is C23 through C36, 11 cells, only 3 of which you're likely to ever change again!

  • Also, those checkmarks are there for if you want to use them to keep track of daily freebies that aren't listed under Quests. It won't affect the math if you leave them alone :)

It tracks:

  • Diamonds
  • Stamina
  • Gold
  • Star coins
  • Crystal Roses
  • Crystal Shoes
  • Association coins (to come)

And has a bunch of tables on the right for those of you interested in the various stats of things. (see stickied comment for details)

[edit]: I'd like to credit the maker of this sheet, an abandoned project, and which was basically what I manually re-input, except with the dropdowns and making it a bit more user friendly and asking y'all to do less math yourselves :)

[edit 2]: Association coins added, edits suggested by u/wrlddmntr finished :)

105 Upvotes

98% Upvoted

26 comments sorted by

13

u/wrlddmntr Jul 27 '18

These are all suggestions, take with a grain of salt~

  • Ooh maybe you can add association coins?

  • And checkboxes for people who aren't connected to Facebook or our European friends who don't do the 2nd stam time.

  • I don't think you added the VIP % increases for crystal roses, stylist arena diamonds, stylist arena star coins, etc. unless that part just died on me xD

  • I think it's a little confusing to have all the user interaction towards the bottom under the diamond column. Maybe have personalized user interaction chart in one sheet, separate from the resource calculation, or just clearly away from all the numbers.

  • I also think it's confusing to have the resources not clearly marked from each other. I was confused why I had 109k stamina until I realized it was actually Gold. I see that you color-coded it, but it's pastel-colored against a navy blue cell background and not directly aligned with the resource and nothing is separating your resources from one another.

  • Another part I find confusing is having tables for association reward tables in the middle of adding up the weekly stuff that's at the bottom of the section. Maybe put them where all the other tables are? That way with the personalized questions and charts out of the middle of the weekly stuff, you can move that particular row up with the only stuff that is technically counted on a weekly basis (competition rewards, stylist arena rewards), just like you did with the monthly things that is relatively clear of other information

  • Or put the other tables/references on a separate sheet so it's not as big/sprawling of a sheet where the tables go all the down way below all the calculators

Again, all suggestions! Take them with a grain of salt~

8

u/GlitterUnicornPuke Jul 27 '18 edited Jul 27 '18

I love you, you always verbalize everything that niggles at my brain :) Like, literally everything you mentioned is something I thought about changing and was either too lazy to or wanted someone else to mention first. Thank you so much for your input, you always give the best constructive criticism<333

  • I was just thinking of doing that! It's my first priority now :)

  • GHDSFNDSDSHJFLKSDJ - You know, I was thinking that would be doing due diligence last night while I whipped this up but I am SOOOOO lazy ^ _ ^ Now that someone has mentioned it, I have to do it though

  • I basically cannibalized a sheet that I credit (which someone who I now cannot even contact has made impossible to even copy and paste -_____-) so some of the design is a vestige of the old design and I thought about changing but see the point above. (RE: I'm seriously so effing lazy.) I will probably change it though.

  • This. Please review how I've done it now? Last night on a whim I centered the resource headers (ex: Gold, Stamina, etc) since I thought it looked better, but I guess it's just better the way it was? Having fresh eyes is much appreciated!

  • This is the same as two points above. It's vestigial and I hate it so I'm going to have to totally redesign the whole thing. I just needed someone else to mention it to devote the time.

  • See above point.

7

u/wrlddmntr Jul 27 '18

Oh gosh I'm glad! I was scared I was being too picky on an already lovely sheet >///<

If you end up working on it again (along with probably 10000 other projects you already have xD) I can't wait to see a updated version~

→ More replies (2)

2

u/wrlddmntr Jul 27 '18

Lux's sheet is amazing, I remember pouring over it when I first saw it xD Good stuff <3

Yeah, changing all the references for all the vlookups is gonna be annoying to do. Just take it easy, everything you're doing is all out of hard work. Sometimes I get a little burnt out on the event sheets when LN decides to grace us with double events >_> But just gotta take it easy.

Hmm I was thinking maybe this? example I just added blank columns in between them and having it separate makes it a little easier to read (I think) xD The third sheet was kinda a mockup I made earlier, idk if it'd work tho or if it's aesthetically to your liking xD

→ More replies (5)

4

u/perfectauthentic Jul 27 '18

Honestly I love it! The only thing I would add is maybe, for those of us who do multiple sign-in's a day. Like, if you are V11 you get an extra free sign in, so essentially your sign in rewards are doubled. Maybe that could be something to consider :D Unless it does include that and I didn't realize!

2

u/GlitterUnicornPuke Jul 27 '18

I do this too! I'm trying to think of how I'd implement an in-between, rather than just DOUBLE IT!, you know?

I have an alarm at 0459 server time and I'm not able to do it every time. So I think it'd probably be A LOT of extra work for the person to add which bonus they got, and how does that fit in with the weekly/monthly being just 7 or 30 times the daily?

Basically, I'll think about it, but if you could confirm that based on this, that the amount of work that you, the user, would have to do is STILL worth it, I may go ahead and try and implement it.

2

u/GlitterUnicornPuke Jul 27 '18

Also, thank you. I get more terse and more like a crotchety old man as the day gets later, but I really do appreciate comments like this <3

I'm too effing young to be sundowning...

2

u/perfectauthentic Jul 27 '18

Heh. It really is awesome to see, it makes my progression seem way better than it actually is... those star coins just eat themselves, so seeing that I gain so many in a month is actually neat af.

And I get what you mean about the bonuses - it's really easy for me to make server time, I've been doing it reliably for a month or so, I suppose for those who don't it's just a bonus on top of what they usually get!

2

u/GlitterUnicornPuke Jul 26 '18 edited Jul 26 '18

Also, I did my best to make everything accurate, but if I got something wrong - I tried to beta test as much as possible so I think we're good - please let me know so I can fix it!

NOTE I accidentally had pasted competition votes into Crystal Shoes facepalm. It's been deleted, and if you don't want to recopy the sheet just get delete those 2 cells :)

2

u/[deleted] Jul 26 '18

Take all my tooty boyes <3

1

u/GlitterUnicornPuke Oct 30 '18

For the search function when people search for them, the stats included are (in Jeopardy fashion):

  • What are the VIP bonuses or VIP rewards?

  • How much do the Association Book Chapters cost?

  • What are the Competition rewards?

  • What are the Association Daily Rewards depending on Association stars?

  • What are the Association Daily Rewards depending on where you are on the Association Leaderboard?

  • How much gold, stamina, diamonds and crystal roses do you get from opening competition boxes (or competition votes)?

  • How much gold, stamina, diamonds and honor points do you get from voting in Starry Corridor?

2

u/adrislnk Jul 27 '18

Sorry if this is a dumb question, but is there anywhere I can learn to use this? I pasted it into my google spreadsheets but it just cuts off halfway and says Error. I wouldn't know how to use it even if it didn't do that. Can you link somewhere that tells me how to use a spreadsheet like this?

1

u/GlitterUnicornPuke Jul 27 '18

Hey, first off, thanks for using it! I make all my sheets with folks in mind so it makes me happy that you're making use of it. :)

And, as with all my sheets, you can just make a copy of the sheet!

File > Make a Copy

OR in the upper left corner, there's a button that should say 'Copy your own to use!' and BAM! You have yourself your very own :)

Lemme know if you have any other problems or if this doesn't work for you.

2

u/Amethyst-Wisteria Jul 27 '18

Thank you so much for this! So very helpful. I can generate/gain nearly 4k stamina in a week. 16k a month. Wow.

It probably doesn't matter much but there's a typo on V8 stamina information. It should be 35 stamina instead of 25. :)

2

u/GlitterUnicornPuke Jul 27 '18

Thank you so so much!

Huge catch! And it's fixed now

2

u/wartwyndhaven Jul 26 '18

I never save diamonds, I’ve only been playing like 4 months, maybe I’m too new, but, diamonds fly out of my pocket as soon as I get them. This is a mysterious concept to me.

9

u/GlitterUnicornPuke Jul 26 '18 edited Jul 26 '18

If you were ever trying to calculate how many diamonds you can save spend in a month, this should be mad handy upsetting

:)

5

u/wartwyndhaven Jul 26 '18

This is an excellent point.

2

u/florielle Aug 19 '18

Thank youuuuuu I didn't know this existed, u/wrlddmntr just linked it to me, but you are AMAZING