General Hemp Processing Equipment Spreadsheet

Did you go with the Selekt Unit? I’m waiting on a quote back. How often do you replace the SFÄR?

We haven’t put the crystallization reactor on the website yet. Its basically the lifting reactor but is explosion proof and has a filter

2 Likes

thank you brother.

1 Like

thank you so much. you are really the man and leader for this page.

Thank you for putting this together man, this will help a lot when dealing with the suits.

1 Like

This is all based on running dried product, correct? It has been my experience that a lot of hemp cultivators/processors are primarily interested in running it right off the vine. The price of production skyrockets as soon drying, trimming, storage, etc… enters the equation.
Any thoughts?

Dry. The logistics of running fresh flower are just as expensive as dry, just less forgiving.

4 Likes

dry biomass can be metered to the extractor over the course of 12 months in a manner that seems impractical with frozen.

3 Likes

What are thoughts on decarbing first, before extraction and prior to grinding? Some of the local processors in my area do it that way when extracting CBD.

1 Like

Great spreadsheet, the equipment suggestions are very valuable.

Suggestion: Since Flower Mass, Crude Yield and Crude Potency are known, one could use Flower CBD% to derive Extraction Efficiency. Without using units, I the formula should be:
Extraction Efficiency = Crude Potency * Crude Yield (mass) / (Flower CBD% * Flower Mass)

edit: Had the fraction flipped…

Or, assuming Extraction Efficiency is something like 95%, then you could derive Crude Yield with:

Crude Yield = Extraction Efficiency * Flower CBD% * Flower Mass / Crude Potency

As long as you know 4/5 of these variables, you can find the unknown one using algebra.

3 Likes

How do they Decarb oven i imagine ?

I went ahead and edited one of the tables in your hemp processing spreadsheet.

I back calculated the Hemp CBD % that would fit your model, which turned out to be 7.578888%.
There’s two tabs with different unknown variables, but they work out the same because they use the same assumptions.

Oh, and if you’re bothered by my formula for the crude yield %, it’s just a simplification of: Crude Yield = Extraction Efficiency * Flower CBD% * Flower Mass / Crude Potency.
Divide both sides by Flower Mass and the left side becomes Yield %, on the right, Flower Mass cancels.

Which one to use depends on which piece of information is “less known.” For most purposes, imo it is more useful to assume a 95% efficiency and then calculate the expected crude yield, as users of the spreadsheet probably don’t have any data on yields yet.

(not a pdf, just had to get around the attachment filetype limits :smile:
Remove that .pdf extension to get to a readable excel file.
Hemp Processing Equipment Selection Guide v1.1 Table Edit.xlsx.pdf (12.7 KB)

6 Likes

Thank you very much.

1 Like

Wow, every day I find something new on this site that I can’t believe I missed previously. There’s just so much info here, I love it! A couple of questions:
@goldleaf_scientific Is the crystallization reactor up yet? I was also wondering if that price included the chiller.
@Future In regards to the spreadsheet, was there a specific reactor system that you were basing this on or is the $30,000 a rough estimate?

Rough estimate, reactor + ancillary. However, that may be for 2x setups. Id have to look

In looking at the V2 table, some questions came up:

  • Crude Oil Volume calculation looks like it only includes CBD. Wouldn’t we need to account for everything else pulled by dividing the current equation by the crude oil potency?
  • Is the DeCarb Loss volume assumed to be water weight? If so, it shouldn’t be included in the formula for calculating Total CBD for Refined Crude Oil, right? I’m also confused as to why the Total Volume and Total CBD for Refined Crude Oil is also switched (not that it matters).
  • Total CBD in grams increases from Refined Crude Oil to Distillate, which is not possible. The reasoning for this error is the assumption that one can achieve 85% Distillate potency while yielding as high as 95% volume. By changing the yield of the volume to 75% for 80% potency, the numbers make sense.
  • How can we calculate the amount of Total Cannabinoids as CBD from Distillate minus CBD from Isolate? I’m confused.

Thank you again for all that you do!

2 Likes

For the sheet, pretend that 10% is all CBD

Decarb loss is accounting for the mass loss from cooking off the acidic group

I see the error in the increase, I think if we change cell F14 to =F12 * D14 * D13 it solves the problem

1 Like

Shouldn’t say total cannabinoids if we are only counting the initial % as CBD only. Should add a row up top so we can account for total CBD as well as total other cannabinoids

2 Likes

And I should be more clear about the fact that we are starting with CBDa and decarbing to CBD

2 Likes