Shows daily profit minus workforce cost.
Shows daily cost that consist of production cost and workforce cost, to be used to estimate cost of refilling at commodity exchange.
Shows revenue before going to the exchange, divide by daily cost to estimate plan expansion & maintainance of base.
Shows how long to sustain base on day of exchange.
Shows how long to sustain base on future day of exchange.
Shows how long until needs to replenish supplies for base
Shows daily which Smeltor's recipe shows the highest ROI.
Shows which Metalist Studio's recipe shows the highest ROI
Shows the daily cost of Workforce.
Shows daily Smeltor's recipe cost, to be used to estimate cost of refilling at commodity exchange.
Shows ticker AL (Aluminium) todays's high with previous 1st, 3rd, 6th, 9th, 12th, entire period
Shows ticker ALO (Aluminium Ore) todays's high with previous 1st, 3rd, 6th, 9th, 12th, entire period
Shows the selling price of your base inventory
Shows the total buying price of 2 HB2 and 1 FS
How to bucket data guide: https://edferrero.com/index.php/en/blog
Resource to learn more: https://link.springer.com/book/10.1007/978-3-031-70584-7
*** Important fact, you need to consult GBT if formula will apply on reference table that is filtered *** ^ The best way is to filter the data and just put the data into a new sheet, then formula on that new sheet.
Excel Sheet: stg_cxpc_al_ai1
First Iteration of Bucket open price
Second Iteration of Bucket open price
I decided to bucket (20 bucket) the chart data for AL.A1 , so because Seller Price now is 1470, and it's position is tail end of the buckets, does this mean the Seller Price will go higher / trending up?
Question: How do know which date do I want to filter the data? So that the chart make sense, it will not be entire data because 500 to 1000 range is too low, I think I have to find the new floor. I guess you can create a ranking for the lowest open prices, and their dates