Soapmaking Spreadsheet Recipe Tool

[Grantxw8]

This might be my last chance to post for a little while. So, I thought I'd push this out before I take a break. I bought Carrie Seibert's excellent book 'How to make Shaving Soap, Charting Your Course to the Land of Lather'. Having read it I decided to make some shaving soap. Of course, this requires the use of dual lye recipes and so I've added the facility to use both NaOH and KOH in a recipe to this tool.

Hopefully, I haven't stuffed anything up in the process. I did it in a bit of a rush. I also took the opportunity to improve the accuracy of some of the calculations. Consequently, I'd recommend using the latest version and deleting the old versions.

Happy soaping.

Latest version HERE.

 

[Whillow]

This might be my last chance to post for a little while. So, I thought I'd push this out before I take a break.

Sorry to see you go. Will you still check in to see if people "me in particular" have any questions regarding your programme?

 

[Grantxw8]

Sorry to see you go. Will you still check in to see if people "me in particular" have any questions regarding your programme?

Absolutely. Just having a holiday. might not have internet access.

 

[Grantxw8]

Sorry, I had a technical issue at my end that stopped the file uploading correctly - or that's how it looked at this end of my not-so-good connection. I thought it safer to take the file down again in case of a problem. I think all is well at my end now so I'll try uploading again before heading to bed.

I streamlined some things in the back end and found a minor gremlin or two (mostly caused by my rushing the last version out). These should all be addressed now. I also managed to significantly improve the accuracy of the automatic batch resizing. That alone is worth upgrading to this version - after all it's free.

This should be the last change for a while. so hopefully, you'll have a chance to play with it. Any feedback is gratefully received.

Happy soaping.

 

[Grantxw8]

Hey,

It must be Sunday night (it is in Australia) as I'm uploading another tweaked version of the Soap Designer tool. I've improved the batch size calculator and one or 2 other little things that weren't as good as they could have been. There will come a day when I don't find things to improve but that day isn't this day.

I know I say this every time I upload but, this should be the last change for a while. so hopefully, you'll have a chance to play with it. Any feedback is gratefully received.

Happy soaping.

[I've made so many changes to this tool - some of them at the suggestion of this forum - but some of them because I just thought I should. I confess though that I definitely made some because I made mistakes in the calculations. I apologise for that. I'm glad to say that I'm pretty sure none of them would have caused any injuries or even spoiled a batch. They were not what I would have wanted them to be. That, of course, is one reason I ask for feedback. If there is a mistake in there then I want to know about it so I can fix it. I'm pretty sure I've caught the vast majority and that this version should be reliable. However, if you use the tool and find it useful I'd be delighted to hear about it. Any issues you find I'd be grateful to hear about those too.]

As always this is a free tool and is offered without warranty.

@Whillow I hope you are a bit less stressed and can relax doing a little soaping.

 

[Whillow]

@Whillow I hope you are a bit less stressed and can relax doing a little soaping.

Thank you @Grantxw8 Things are calming down a bit for me here. No more people trying to get into my house LOL I have security up the wazoo now. When I had my Neapolitan Mastiff he was enough of a deterrent but now I have a Golden Retriever and a Cocker Spaniel that welcome people with open arms.

I will down load this program on my computer at home and let you know. Thank you very much.

 

[Whillow]

I have tried to get this program to work on my computer. I even purchased Microsoft 365 but it is still a no go. No macros are able to be enabled. Thank you for your work on it @Grantxw8.

 

[Grantxw8]

Hey Whillow, could you send me screenshots of what you see when you open the spreadsheet? I have others using it without issue once they allow macros to be used. It may be something simple like a security setting that's been missed.

 

[Whillow]

Hi @Grantxw8 I will once I get home. Thank you

 

[Grantxw8]

Hi Whillow, The more info you can give me the better I'll be able to help. If you can tell me what operating system you're using (Windows 10 or 11, Mac, Unix) and what you see when you open the file that's a great start. If you could also tell me what you've tried already regarding enabling macros that would be great.

On another note, do you make anything other than soap? I've started making candles recently and will be turning my hand to melts soon. I have, of course , made spreadsheets to facilitate each of these. It's a bit clunky having separate spreadsheets so I'm working on combining them all. It'll be a job and a half but I enjoy it almost as much as making smelly things.

 

[Whillow]

On another note, do you make anything other than soap? I've started making candles recently and will be turning my hand to melts soon. I have, of course , made spreadsheets to facilitate each of these. It's a bit clunky having separate spreadsheets so I'm working on combining them all. It'll be a job and a half but I enjoy it almost as much as making smelly things.

Hi @Grantxw8,

No I do not make candles. I have a parrot that would croak if I ever burned a scented candle, so I don't bother. I love them though.

 

[Harry Potter]

guys what about the herbal ones i cant see any discussing about it

 

[Grantxw8]

guys what about the herbal ones i cant see any discussing about it

Hi Harry Potter, I’m not sure what you mean? This thread is regarding a spreadsheet (Excel) that can be used for designing recipes for CP soap among other things. I have other spreadsheets I use for making candles, melts, bath bombs and shower steamers. My last post was about this and whether it would be of any interest to others if I were to combine them into one tool. Not a great deal of interest from anyone so it’s very much a side project for the time being. I hope this helps.

 

[Iveta Pelá]

Thanks for this great tool, very good job. I appreciate you sharing this with the rest of us. I haven't used it yet, but I think this will save me a lot of time. I can see it being simple enough to be motivated to use it. I am alone with a small child and have very little time left for my soap making hobby, so I either keep my records simple or I don't do it because of lack of time when it takes too much time and is complicated.

Many thanks for your work!
@Grantxw8 I wish you happy retirement days