Thanks! Perhaps some day you will find it useful. I know I have converted many saved recipes to my way of mixing 
Simple calculator - feedback
- Thread starter Switched
- Start date
- th_trl_thread_readers 0
- Status
Have not had a chance to use the new one, just been testing new flavor combinations in 2ml batches with no-nic lately. Sounds like it will be great though, and I'll probably be using it a lot in the future.
Cool,
What's with the lack of edit function in this forum. I can't edit my own threads to update them???
What's with the lack of edit function in this forum. I can't edit my own threads to update them???
Can't edit posts after 2 days, to avoid people abusing it. I updated the links for you, I have very basic moderator abilities (within the DIY subforum only) so I can keep my guide updated.
Thanks PV are they permanent or will the privilege expire in 2 days. I would like to be able to edit the posts with new versions as they develop, rather that creating new posts or bumping them.
Tried the calculator, is it me or does it only computer the % to drops and not really tell you the full recipe?
i.e. if you put 100% of everything it won't tell you that you went over, it just moved it to drops/ml or vice versa?
Maybe that was the point of it, I just thought it wouldn't let me go over the max %'s.
i.e. if you put 100% of everything it won't tell you that you went over, it just moved it to drops/ml or vice versa?
Maybe that was the point of it, I just thought it wouldn't let me go over the max %'s.
I do not understand your question, can you please clarify.
No there is no built in default to prevent the calculator from going over 100%. When you see that happening, most people will either cut on the PG (when using the PG page) or VG, when using the other.
No there is no built in default to prevent the calculator from going over 100%. When you see that happening, most people will either cut on the PG (when using the PG page) or VG, when using the other.
Looking forward to trying this but my download seems delayed. Spreadsheets rule though and just reading the thread it sounds like just what the dr ordered for experimenting with flavors! Thanks. I'll bring feedback after I've used it and have a bunch of mixing coming up this weekend.
Cool. I received you pm and even that wasn't clear. During feedback, if you could spell out for me where you ran into problems and what would be needed in the instructions so folks don't get confused.
Took a quick look and I like it. Being able to enter pct or ml or drops is a real advantage, particularly when mixing small amounts. It took me a while to figure that out because I didn't read the directions at first. But I got it figured out and when I read the directions had a kind of duh moment.
One thing you could do is to protect the sheet and just enable entry in the appropriate cells (B2, E2, B6:E8, C10:E13 and C15:E20). Upside, that would prevent anyone inadvertently breaking a calculation; downside is some folks might jump when it tells them they can't do that.
If you're interested in formatting suggestions, one thing I did in the version for personal use was to narrow the column with asterisks in it, and add another narrow column to its left. That put all the text and calc on one screen (at my resolution). I let the column headings wrap and narrowed the input columns, again to fit it all on my screen better. I turned off gridlines too.
Anyway, this works fine for me. Nice job, thanks.
One thing you could do is to protect the sheet and just enable entry in the appropriate cells (B2, E2, B6:E8, C10:E13 and C15:E20). Upside, that would prevent anyone inadvertently breaking a calculation; downside is some folks might jump when it tells them they can't do that.
If you're interested in formatting suggestions, one thing I did in the version for personal use was to narrow the column with asterisks in it, and add another narrow column to its left. That put all the text and calc on one screen (at my resolution). I let the column headings wrap and narrowed the input columns, again to fit it all on my screen better. I turned off gridlines too.
Anyway, this works fine for me. Nice job, thanks.
Thanks Dave. You had me there for a while (column with asterixs).
If someone can point me in the right direction wrt protecing cells vs sheet, it would be much appreciated. It has been a while. I use to do it, now for some reason it won't allow it. Mind you I am using open office.
If someone can point me in the right direction wrt protecing cells vs sheet, it would be much appreciated. It has been a while. I use to do it, now for some reason it won't allow it. Mind you I am using open office.
Hi Switched. In Excel 07, select all the cells that are to be left open (or you can repeat for as many cells as you wish). Then in the Home tab, you'd click Format (off to the right), then Format Cells... There, select the Protection tab and check the Locked checkbox and OK out.
Then, under Format again, select Protect Sheet... I usually check only "Select unlocked cells". That will prevent selecting any cell that is locked, and position the cursor in the first data entry cell. I hope this makes sense. [Edit: I don't usually password protect the sheet, but that's always an option.]
Under Excel 03 - it's been a long time! - I think you'd find it under the Format menu, then Format Cells... and it'd look pretty much the same. I think! Haven't used 03 for a couple months and memory does not serve me well.
Hope this helps.
Then, under Format again, select Protect Sheet... I usually check only "Select unlocked cells". That will prevent selecting any cell that is locked, and position the cursor in the first data entry cell. I hope this makes sense. [Edit: I don't usually password protect the sheet, but that's always an option.]
Under Excel 03 - it's been a long time! - I think you'd find it under the Format menu, then Format Cells... and it'd look pretty much the same. I think! Haven't used 03 for a couple months and memory does not serve me well.
Hope this helps.
Last edited:
I really apologize I was trying to play while my supplies are being shipped so I could give feedback, I'm just still behind on learning mixing in general, I plan to use it when I start experimenting and hopefully I will be of more help then
I tried downloading the file several times and at least on dial-up it went thru all the ads, I registered, and see the file in My Files on the web but no file to use on my computer.
Perhaps I need excel opened first?????
Other downloads give me the option where to download to and then are available w/o being online.
Perhaps I need excel opened first?????
Other downloads give me the option where to download to and then are available w/o being online.
Send me a pm with your e-mail addy, I'll shoot you a copy direct. Something is wonkie because it will download where ever you want to, unless your 'puter defaults are set to open vice save. It is not a problem from "my file" or the file itself, I am sorry to say.
Thanks, yup that sounds about right.Hi Switched. In Excel 07, select all the cells that are to be left open (or you can repeat for as many cells as you wish). Then in the Home tab, you'd click Format (off to the right), then Format Cells... There, select the Protection tab and check the Locked checkbox and OK out.
Then, under Format again, select Protect Sheet... I usually check only "Select unlocked cells". That will prevent selecting any cell that is locked, and position the cursor in the first data entry cell. I hope this makes sense. [Edit: I don't usually password protect the sheet, but that's always an option.]
Under Excel 03 - it's been a long time! - I think you'd find it under the Format menu, then Format Cells... and it'd look pretty much the same. I think! Haven't used 03 for a couple months and memory does not serve me well.
Hope this helps.
- Status
