PDA

View Full Version : [GUIDE] How To Use The Plushie Tycoon Tracker



Unown
06-04-2020, 06:54 AM
Hey guys!

This is to be used in conjunction with my other guide Plushie Tycoon Easy Gold Trophy + Avatar ([Only registered and activated users can see links]).

You may download the file here: Plushie Tycoon Tracker ([Only registered and activated users can see links])

I understand it's kinda hard to fully understand the guide because there's just so much information to take in and understand all in one go. So I've decided to share the Excel Spreadsheet that I've made specifically for PT (which I have used myself). I've tried to simplify it as much as possible and in this guide I'll tell you what you have to do to help you calculate and track your progress in the game.

The main point of this tracker is to ENSURE YOU NEVER GO BANKRUPT.

It helps you to calculate the costs of your raw materials, how much you'll spend making certain jobs, how much you'll spend upgrading your shop/factory/warehouse etc.

When you first open the file you'll see the image as per below:

35269

Legend:


Yellow Cells = FILL THEM IN YOURSELF
Blue Cells = SELECT FROM THE DROP-DOWN LIST
Green Cells = DO NOT EDIT


On to the Yellow/Blue Cells


Date = Fill in the date of the day you're playing
Time = Select the time of update you're playing
Cloth = Price of the cloth (whatever color) you're buying
NeoCotton = Price of NeoCotton
Rare Gems = Price of Rare Gems
Velvet Bags = Price of Velvet Bags
Total Rolls = Total number of rolls of cloth you are buying
Sets Bought = Number of sets of NeoCotton, Rare Gems and Velvet Bags you are buying
Shop = Price paid for any expansion or rent in shops
Factory = Price paid for any upgrades or rent in factory
Warehouse = Price paid for any upgrades or rent in warehouse
Completed Jobs? = Amount of jobs completed during update
Workforce = Price paid for your workforce (this should be a default of 82 nps if you didn't hire anymore workers)
Price = Price of plushies sold that update
Amount = Amount of plushies sold that update
Shop Upgrade = Select the upgrade level done to your shop (auto deduct from Cash On Hand)
Shop Level = Select level of your shop to see rent needed to be paid on rent day*
Factory Level = Select level of your factory to see rent needed to be paid on rent day*
Warehouse Level = Select level of your shop to see rent needed to be paid on rent day*


*You will need to fill in the respective rents yourself on the day you make rent payments.

On to the Profit Calculator
Do not change anything here. When you fill in your prices of your raw materials, the amount of rolls and sets you're buying, the cost of your workforce and the price of your plushies to be sold, it'll calculate the profit for you so you will know whether you're making a loss or a profit whenever you wish to produce plushies.

Once you pass the first part of the game where you no longer have to worry about Cash On Hand, you will need to know whether what you're producing makes profit.

I hope this helps all of you trying to get the Gold Trophy or the Avatar!

Good luck. Let me know if there's anything else I can do to make the spreadsheet tracker better!

Mario2302
09-10-2020, 04:20 AM
So haven't used the spreadsheet myself just yet (need to have actual time to play this which isn't the case when i have to work both at work and at home so will have to wait still a bit) but am planning on using it when i get around to playing this game for gold.

Still, one improvement i immediately think of when reading your post above is that you could protect the cells people aren't allowed/shouldn't change. That way they can't accidentally change something either that could mess up the file and potentially their game if they haven't noticed and it's still calculating.
It shouldn't be too hard and you could just use a simple password you list here to still give people the option to unlock those cells if they wanted too themselves.

Unown
09-10-2020, 08:16 PM
So haven't used the spreadsheet myself just yet (need to have actual time to play this which isn't the case when i have to work both at work and at home so will have to wait still a bit) but am planning on using it when i get around to playing this game for gold.

Still, one improvement i immediately think of when reading your post above is that you could protect the cells people aren't allowed/shouldn't change. That way they can't accidentally change something either that could mess up the file and potentially their game if they haven't noticed and it's still calculating.
It shouldn't be too hard and you could just use a simple password you list here to still give people the option to unlock those cells if they wanted too themselves.

Oooh that's right. I'll lock it when I get home and re-upload the file!

Let me know how that works out :D

Mario2302
09-11-2020, 12:11 PM
Oooh that's right. I'll lock it when I get home and re-upload the file!

Let me know how that works out :D

i'll let you know once i get around to actually using it :P ;)

Meercat
02-21-2023, 09:47 PM
hey Unown, sorry to gravedig but I have just started following your guide for Plushie Tycoon!

In the spreadsheet, column U for the "Sales", howcome it is Price x Amount x 0.01?
There is a possibility that I am missing something here, but last update I sold 200 plushies at 105NP each, so gained 21,000NP.
To get 21000 to be the number that appears in my sales column (and have my cash on hand be correct), I have to put 20000 in "sales" when I have only sold 200.

Am I misunderstanding or could someone please explain? Thank you :)

Unown
02-22-2023, 07:00 AM
hey Unown, sorry to gravedig but I have just started following your guide for Plushie Tycoon!

In the spreadsheet, column U for the "Sales", howcome it is Price x Amount x 0.01?
There is a possibility that I am missing something here, but last update I sold 200 plushies at 105NP each, so gained 21,000NP.
To get 21000 to be the number that appears in my sales column (and have my cash on hand be correct), I have to put 20000 in "sales" when I have only sold 200.

Am I misunderstanding or could someone please explain? Thank you :)

Oh weird. I think maybe the 0.01 was a mistake.

I'll check it again when I'm back from my trip.

The Total Sales should be price x amount!

Thanks for highlighting :D

Meercat
02-22-2023, 05:36 PM
Otherwise I love using your spreadsheet rather than forgetting what numbers I've typed into my calculator - thank you!