Spreadsheets: The life of a capitalist in eRep
DragoonXRyu
I just finished my nth revision on my eRep spreadsheet.
Here's how it looks like:
That's just one of the tabs (though my most active tab).
At any given day, here's what I do when I log in:
1 ) Work for my employer
2 ) Train
3 ) Check market conditions
3.1 ) Check Philippines Food/Weapons/FRM/WRM
3.2 ) Check Supplier country Food/Weapons/FRM
4 ) Plug in market prices to my Market spreadsheet
5 ) Check ROI and Production Table to see, based on prevailing market prices, which companies are profitable to work in
6 ) For each kind of product factory, record work tax/salary cost, Total RM used, price of RM per unit, output
7 ) Record inventory levels and total sold based on previous inventory
8 ) Record new product costs based on existing, newly acquired from market, produced as manager, produced from workers
9 ) Log out
If I ever log in again later in the day, I update my market prices and re-check ROI and Production Tables.
It lets me keep track how much I've earned on a daily basis and of course, from there, extrapolate to weekly/monthly.
It's hard work and probably takes me an hour or so at my first log in for the day.
Hope this helps would-be capitalists. 🙂
Comments
that's awesome dedication keep it up 😃
wow! supply chain management at its best, keep it up bro
wow,,,,, its too serious for a game,,,,, no doubt if you success here.