Candle Making Calculator Spreadsheet...

[Spencer101]

Hi all,

I've mentioned in another thread on here that I'm pulling together a spreadsheet to help budding candle makers work out the weights and measures necessary for their projects. I'm sure you all have your own methods for doing this already, but I love the simplicity of having a computer do all the working out for you and who needs to be doing mental sums whilst watching wax melt??

So far It will easily show:

• The amount of wax needed for any given container being turned into a candle.
• The amount of wax needed for pillar candles (square based and round based pillar moulds).
• The suggested weight in grams of FO, based on total wax weight (from 1-10%).
• An easy to use form for recording your own wax blends that will show, based on a percentage used, the amount in grams of wax and each additive needed for a single candle along with a batch of the same candles.
• Basic info on wicks and the size of candles they are suitable for (work in progress at present).

If anyone is interested in a copy of the final product then PM me an email address.
Also, if anyone can think of anything else they think would be useful in it, let me know either here or by PM.

If no takers, then I shall keep it all to myself!!

[Spencer101]

Hi,

For those of you that PM'd me your email address for a copy of the calc, I'm happy to say Version 1.1 should be in your inbox (or perhaps spam folder depending on your setup!) now.

For anyone else that would like a copy and future updates, PM me your email address and I'll wing a copy your way too.

Hope it's of some use... Comments and suggestions welcome (be nice!)

[pcbob]

Are you planning on adding a timeline for burning candles? I know it is not easy but some sort of guideline maybe.
I'm sure newcomers will ask ...... how long will that last

[Spencer101]

Working on that right now, Bob. Hopefully should have something sorted before too long

[pcbob]

Great news (request submitted) and as that was my 25th post I can now display my pics of my candles.

[Spencer101]

I shall look forward to seeing them

Happy 25th post!

[fireworkmaster]

nice one many thanks looks good will have a proper fiddle with it tomorrow when im alive

[fireworkmaster]

have tested in open office and works well small spelling error page 3:P
all in all very well done

for those that do not have microsoft excel there is a very good free program called open office has word/excel equivalents and this will work ok with it
well done spencer

[pcbob]

Very impressive
One of my problems was with the amount of FO , but now that is in the past.

Well done Spencer, your efforts are appreciated

[Spencer101]

Thank you Bob.

Glad to be of help!!

And thanks to several people for spotting the "deliberate(?)" typo.... Nice to know you're all paying attention

[SilverGems]

Blimey! That was fast Spencer, having fun playing about with it now

[Spencer101]

I aim to please, Gems


Nearly finished with the "candle burn time calculator" now. Just ironing out a few wrinkles like making it show time as 10hrs45mins rather than 10.75. So expect version 1.2 in your inboxes soon.

Open to any more suggestions from anyone...

[Spencer101]

Version 1.2 now in the inboxes of those that have requested it.

Now includes a tab for calculating the approximate burn time of your candles.

If anyone else would like a copy, just PM me your email address.

S.

[BurningDesires]

Thanks Spencer, should come in handy for the other half

[Spencer101]

Thanks Spencer, should come in handy for the other half

Pleasure is all mine mate