Schedule 1 Optimization Calculator

[kushman257]

I just created a spreadsheet for assigning customers to dealers and giving them product just for funsies. I don't know how useful it really is but let me know what you think of it:
Schedule I Optimization Calculator [docs.google.com]

[WhisperFire26]

https://schedule1-calculator.com/

[kushman257]

Postat inițial de WhisperFire26:

https://schedule1-calculator.com/

I'm ready to end it all ;-;

[BolasDToroLoco]

sigma

[Villager]

You can't count up front costs like growth tent with recurring costs like a baggie or soil to calculate the cost of a weed bud. It doesn't work like that.

One is dividable by the number of buds the other is not, because it allows for production of an infinite amount. Only thing you can do with start up costs is check how long till they pay for themselves if they have a return on investment, and that would be 3.15buds of OG kush for a growth tent
Up front cost / Profit = x
UPC / (Suggested price-(seed cost/ number of buds+soil/number of buds+container))=
100/(38-(30/8+10/8+1))= 3.15

[kushman257]

Postat inițial de Villager:

You can't count up front costs like growth tent with recurring costs like a baggie or soil to calculate the cost of a weed bud. It doesn't work like that.

One is dividable by the number of buds the other is not, because it allows for production of an infinite amount. Only thing you can do with start up costs is check how long till they pay for themselves if they have a return on investment, and that would be 3.15buds of OG kush for a growth tent
Up front cost / Profit = x
UPC / (Suggested price-(seed cost/ number of buds+soil/number of buds+container))=
100/(38-(30/8+10/8+1))= 3.15

Oh I don't account for the tent as part of the costs. I use it as a flag for calculating the unit cost. To be more precise, I use it for calculating the yield rate from each plant via the yield table and then divide the total costs by the units produced to give the actual unit cost.

[Villager]

so how did you get into 5.13$ for og kush instead of 5$

[kushman257]

Postat inițial de Villager:

so how did you get into 5.13$ for og kush instead of 5$

So this is my formula:
=(T1:Y3
IFNA(VLOOKUP(T2, O:P, 2, FALSE), 0) +
IFNA(VLOOKUP(U2, O:P, 2, FALSE), 0) +
IFNA(VLOOKUP(V2, O:P, 2, FALSE), 0) +
IFNA(VLOOKUP(W2, O:P, 2, FALSE), 0) +
IFNA(VLOOKUP(X2, O:P, 2, FALSE), 0) +
IFNA(VLOOKUP(Y2, O:P, 2, FALSE), 0)
)
/
INDEX(
FILTER($O$24:$O$27, $M$24:$M$27=Z2, $N$24:$N$27=IF(COUNTIF(U2:W2, "PGR") + IF(X2="PGR", 1, 0), "Yes", "No")),
1
)

Columns T thru Y is all the costs dealing with manufacturing. So for example, OG Kush seeds grown in extra long life soil with fertiliser and PGR in a tent and then packed in baggies will lead to (30+ 20 + 30 + 30 + 1) / number of buds.

But I see where I went wrong, the seed price and soil price is not right and the yield rate should influence these prices too. I'll rework the formula and let you know.

[Orbnotacus]

https://docs.google.com/spreadsheets/d/1EB784yLUxSXSlnILkazZ66zBckVLE7qr66Fnyffy5VU/edit?gid=0#gid=0

Much better spreadsheet, no offense.

https://maps.tcno.co/s1 - Interactive map

https://schedule1-calculator.com/howitworks - Rules to mixing

https://www.s1sim.com/reverse
https://schedule1-calculator.com/calc - Two different Calculators