Search results

Interesting. What’s “airbase”?

Hi Shannon, good to hear you worked out how to download the tool. If you have any trouble setting it up please feel free to let me know.

Hi Folks, I've not received any feedback on whether sharing this with iCloud is an effective way to do things. So, I'll share it again/also with Dropbox and perhaps that will be better? Let me know if either is better for you. Dropbox LINK Cheers, Grant

Hi @Jpozzato just letting you know that I fixed a couple of things in the latest version.

I haven't tried sharing this file this way before (through iCloud) so I'm not certain how it works for Windows users. Hopefully it will be plain sailing but I'd be grateful for feedback if anyone has trouble. I have some other options (Dropbox, OneDrive or even Google Drive) if iCloud isn't...

Hi @AwkwardAlpha, I've updated to v1.5 and (hopefully) I've unlocked all the necessary cells. Enjoy. Cheers, Grant PS. FWIW, the tool is Excel based and so will run on Windows and Mac - as long as you enable macros. Always good to hear from another Mac user though. :)

Oops! It's not meant to be protected. I'll have a look at that as soon as I can. Sorry. (I'm just heading out to a funeral).

Here’s what might be a fun project for those amongst us with functioning imaginations; come up with a better name for this tool. “Soap Designer, Candle, Melts and Bombs Spreadsheet Tool” might be descriptive but it’s a bit unwieldy.

Hi @Vicki C, We are an Apple centric house - although I was a Windows user at work. The office had IT staff available for when things, inevitably, went wrong. Having to do my own support at home led me to using Macs and other Apple products. Mostly, it just works.:) Microsoft’s Office products...

@SoapyBenjamin This sounds awesome! I look forward to playing with it. 👍🏻

Hi Everyone, Over on another thread I got sidetracked and started thinking about the problem of tracking materials inventory and stock for sales inventory. My ideal software would allow me to enter my materials stock as I purchase it and deplete it automagically as I make batches depending on...

Hi Becky1024, I have given this some thought in the past. My ideal program would allow me to enter my materials stock as I purchase it and deplete it automagically as I make batches depending on the recipe/batch size I choose. It would then add the resulting stock (e.g. Soaps) to my inventory...

Hi @Becky1024, I’m not familiar with Wix but there may be a way to access it as a database from Excel using Power Query. If you’re using Excel anyway it might be worth looking into? I’m curious about your stock issue. When you say “stock” are you referring to inventory, materials or both? I use...

Hi Folks, I'm finally going to close this thread and move any further discussion to this new one: LINK Cheers, Grant

Greetings from Australia, Ages ago I uploaded an early version of a spreadsheet I use for designing and making soaps. I've continued to refine it and have added other features. Specifically, I've integrated other spreadsheets I use for making Candles, Soy Melts, Bath Bombs and Shower Steamers...

I have given inventory control some thought but a flat file database, like Excel, isn’t really the best tool for that job. That would be a relational database and that’s a level of complexity beyond my interest. There’s also the cost/complexity of creating runtime versions so users can use it...

Hi @Vicki C , FWIW, I too am a Mac user. Excel is largely platform agnostic (at least for Windows and Mac) but does require a subscription. In Australia it’s about $AU179 to buy outright or about $AU11/month for an Office 365 subscription. For me it’s worthwhile subscribing to get the entire...

Hi @SoapyBenjamin, Just a word of thanks for the CSV file. I have integrated it into my Soap Designer spreadsheet as it was so comprehensive. Let me know if I can contribute to your Google Sheets efforts. FWIW, none of the sheets in my spreadsheet are locked in any way so feel free to use any...

Hi Folks, I've been thinking about doing this for a while but finally found some time. I've integrated a variety of spreadsheets that help me make soaps, wax melts, bath bombs, shower steamers and candles. As with the soaps designer that I shared before, this requires Microsoft Excel and that...

Hi SoapyBenjamin, Anything I can do to help I’ll be happy to do. Just let me know. Doing this in Google sheets is a great way to provide something for free. Mine will always be free too but does require access to MS Excel. I choose that program because I like the automation that I can use with...