Results 1 to 8 of 8

Thread: Value Drinks Spreadsheet

  1. #1
    Fashion Designer
    Join Date
    Mar 2011
    Location
    Earth
    Posts
    891

    Question Value Drinks Spreadsheet

    Has anyone create the spreadsheet yet?
    sophiacml

  2. #2
    Rhino Keeper
    Join Date
    Apr 2011
    Location
    on my iPhone 4
    Posts
    221
    If no one has, I'll create one when I get home today. lol

  3. #3
    Fashion Designer
    Join Date
    Mar 2011
    Location
    Earth
    Posts
    891
    Thank you so much of the hard work. I always wonder how to create them. I'm bad with spreadsheet.
    Quote Originally Posted by RageofMars View Post
    If no one has, I'll create one when I get home today. lol
    sophiacml

  4. #4
    Rhino Keeper
    Join Date
    Apr 2011
    Location
    on my iPhone 4
    Posts
    221
    Here it is, I created a spreadsheet with the calculation for XP/hr and Profit/hr, both with the assumption that 1 day drinks are 22 hours, and 2 day drinks are 46 hours. (If anyone can confirm if 2 day drinks are either 46 hours or 44 hours, please let me know!)

    Google Docs: Nightclub Story Drinks Spreadsheet


    The spreadsheet is split into 4 tabs:
    Alphabetical
    Prep Time
    XP per Hour
    Profit per Hour

    Naturally the calculations at the shorter-timed drinks are going to be slightly off due to time spent tapping to make and serve the drinks. So take the dramatically larger number with a reasonable margin of error.

    Please correct me if you find any typo or miscalculation!
    Last edited by RageofMars; 05-04-11 at 09:56 PM. Reason: Add comment about the 4 tabs, just in case people miss it ;P

  5. #5
    Fashion Designer
    Join Date
    Apr 2011
    Posts
    992
    Do you know what is the most valuable gift to give in this game? Thanks!

  6. #6
    Fashion Designer
    Join Date
    Mar 2011
    Location
    Earth
    Posts
    891
    War & Peace, dear.
    Quote Originally Posted by laurelsail View Post
    Do you know what is the most valuable gift to give in this game? Thanks!
    sophiacml

  7. #7
    Fashion Designer
    Join Date
    Mar 2011
    Location
    Earth
    Posts
    891
    Thank you. I don't quite get it though to be honest, the drinks indeed hhas their own profits but it sells in 2/5 coins & the thing is the sales are real slow & is according to the 2/5 coins instead the real profit as stated on the spreadsheet. Any ideas?
    Quote Originally Posted by RageofMars View Post
    Here it is, I created a spreadsheet with the calculation for XP/hr and Profit/hr, both with the assumption that 1 day drinks are 22 hours, and 2 day drinks are 46 hours. (If anyone can confirm if 2 day drinks are either 46 hours or 44 hours, please let me know!)

    Google Docs: Nightclub Story Drinks Spreadsheet


    The spreadsheet is split into 4 tabs:
    Alphabetical
    Prep Time
    XP per Hour
    Profit per Hour

    Naturally the calculations at the shorter-timed drinks are going to be slightly off due to time spent tapping to make and serve the drinks. So take the dramatically larger number with a reasonable margin of error.

    Please correct me if you find any typo or miscalculation!
    sophiacml

  8. #8
    Rhino Keeper
    Join Date
    Apr 2011
    Location
    on my iPhone 4
    Posts
    221
    Thanks for the feedback, sophiacml. The drink sell price was something I had overlooked.

    I have updated the spreadsheet to show a new tab, "Profit per Drink" (the 3rd tab).

    Google Docs: Nightclub Story Drinks Spreadsheet

    On this page two new columns are added -
    "Sell per Drink", which shows either the drink sells for 2 coins or 5 coins, and
    "Profit per Drink", which shows how much you actually earn.

    Profit per Drink = Total revenue - Initial cost

    After looking at the math, it seems that not all 5 coin drinks are going to earn the same amount at the end.

    (I am keeping the XP/Hr tab in case people want to grind XP instead of money, and I'm keeping Profit/Hr in hopes that TL may one day make drinks deplete faster.)

    Hope this helps!
    Last edited by RageofMars; 05-12-11 at 08:03 AM. Reason: typo

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •