~*~ SMF November 2017 Challenge - 1920's Themed Soap! ~*~
~ November 2017 Challenge Photo Entry Thread~



Help Support Soapmaking Forum by donating using the link above or becoming a Supporting Member.
Soap Making Forum > Announcements and Site News > SoapMakingForum Announcements, Comments, Help & Rules > FO Review spreadsheet -- pls help -- NancyRogers Honor435 Kharmon320 KristaY Newbie
Reply
 
Thread Tools
Old 07-06-2017, 02:48 PM   #1
DeeAnna
SOAP_SUPPORTER.png
 
DeeAnna's Avatar
 
Join Date: Feb 2013
Location: Iowa USA
Posts: 8,332
Liked 11222 Times on 5082 Posts
Likes Given: 5019

Default FO Review spreadsheet -- pls help -- NancyRogers Honor435 Kharmon320 KristaY Newbie

Would the following people please lend a hand to fix problems on the FO Review spreadsheet?

NancyRogers
Honor435
Kharmon320
KristaY
Newbie

There are several FO reviews in the PEAK worksheet that have been altered. The FO names are missing for all and, in KristaY's review, there are several other cells that someone has also erased.

I've reproduced the reviews below so you can see what I'm talking about. (SMF doesn't format a table very well, so my apologies for the jumbled appearance.)

Would you take a moment to fix this? Either reply in this thread with the corrections and I'll fix the spreadsheet. Or you can fix the spreadsheet yourself -- please see: https://docs.google.com/spreadsheets...gid=1231634072

. ... CP ... Slight ... Slight ... ... Gels very hot and sweats lots of FO. I won't try to soap it again. Don't love the smell. It's just okay. ... NancyRogers ...

. ... cp ... Yes-dark brown ... no ... masculine? ... really powdery scent, turned soap a dark reddish brown (but it was milk soap) ... kharmon320 ...

. ... hp ... no ... ... unisex ... nice holiday smell, pine and spicy ... honor435 ...

. ... ... ... ... ... ... KristaY ... 1st batch used at 1 oz ppo, 2nd used at 0.5 oz ppo.

` ... cp ... no ... no ... ... Scent took a long time to come through. Now there, a touch sweet but pleasant ... newbie ...

Thank you!


DeeAnna is offline  
 
Reply With Quote
Old 07-06-2017, 03:44 PM   #2
shunt2011
Administrator
SOAP_ADMIN.png
 
shunt2011's Avatar
 
Join Date: Apr 2012
Location: Michigan
Posts: 8,898
Liked 4581 Times on 3061 Posts
Likes Given: 3847

Default

NancyRogers and honor435 havent visited the site since 2015. Hopefully they will respond to your callout for help.


__________________
www.sharishandcraftedsoap.com
Official Member of the Hoity-Toity Snickerdoodle League.
shunt2011 is offline  
 
Reply With Quote
Old 07-06-2017, 03:51 PM   #3
DeeAnna
SOAP_SUPPORTER.png
 
DeeAnna's Avatar
 
Join Date: Feb 2013
Location: Iowa USA
Posts: 8,332
Liked 11222 Times on 5082 Posts
Likes Given: 5019

Default

Thanks for the update, Shari! I'll keep that in mind.
DeeAnna is offline  
shunt2011 Likes This 
Reply With Quote
Old 07-08-2017, 03:38 AM   #4
KristaY
Supporting Member
SOAP_SUPPORTER.png
 
Join Date: Mar 2014
Location: Arizona, USA
Posts: 2,235
Liked 1642 Times on 903 Posts
Likes Given: 2443

Default

How odd! Thanks for the head's up DeeAnna. I'll head over there now and see if I can remember what I wrote for what scents....

ETA: DeeAnna, do you think it's safe to assume the scent names start with "A"? I always add my cells in alphabetical order but since there's no name I wonder if they just ended up at the top of the list.
__________________
How old would you be if you didn't know how old you were?
~Satchel Paige~
KristaY is offline  
 
Reply With Quote
Old 07-08-2017, 04:32 AM   #5
KristaY
Supporting Member
SOAP_SUPPORTER.png
 
Join Date: Mar 2014
Location: Arizona, USA
Posts: 2,235
Liked 1642 Times on 903 Posts
Likes Given: 2443

Default

Sorry DeeAnna, I failed in my task. I looked through all my Peak scents and the few that were possibles, I already had a proper review. So I decided to just delete that line since it's of no value whatsoever. If I ever come across the right FO and find my notes, I'll add it back in.

I think this situation would be a good learning tool. For those that want to add a review but are unsure how to work the spreadsheet, please ask. If you accidentally erase someone's work, you can "undo". Lots of members would be happy to enter the data for you if you're hesitant to do so. Those darn spreadsheet docs can be intimidating if you aren't used to working in them!
__________________
How old would you be if you didn't know how old you were?
~Satchel Paige~
KristaY is offline  
 
Reply With Quote
Old 07-08-2017, 06:03 AM   #6
newbie
Lifetime Supporting Member
SOAP_LIFETIMESUPPORTER.png
 
Join Date: Nov 2010
Posts: 5,802
Liked 4915 Times on 2043 Posts
Likes Given: 381

Default

Here's a screen shot of one of my saved copies of the FO's sheet.

Mine was for Apple Blossom and Krista's was for Asian Sandalwood.

THe review for Amish Harvest is in this one but gone now so that should be replaced.

Does it have everything you need, DeeAnna? It's easier to read if you hit the bar to show it in its original size.
Attached Thumbnails
Screen Shot 2017-07-08 at 1.02.42 AM.jpg  

Last edited by newbie; 07-08-2017 at 06:25 AM.
newbie is offline  
KristaY Likes This 
Reply With Quote
Old 07-08-2017, 06:05 AM   #7
newbie
Lifetime Supporting Member
SOAP_LIFETIMESUPPORTER.png
 
Join Date: Nov 2010
Posts: 5,802
Liked 4915 Times on 2043 Posts
Likes Given: 381

Default

It may be time to implement some of the strategies discussed to protect the sheet.
newbie is offline  
 
Reply With Quote
Old 07-08-2017, 06:08 AM   #8
newbie
Lifetime Supporting Member
SOAP_LIFETIMESUPPORTER.png
 
Join Date: Nov 2010
Posts: 5,802
Liked 4915 Times on 2043 Posts
Likes Given: 381

Default

Here is Nancy's for Blackberry Sage.

Kharmon's review that turned brown came under Plumeria in my copy. I think it turned brown because of the milk.

Honor's piney and spicy one came under Winter Wonderland. I think those reviews were added as a second line for the FO that came before it. People were doing that for a while.

DeeAnna, let me know if you want me to send you any of the copies I have. The oldest one is from January 7, 2016.
Attached Thumbnails
Screen Shot 2017-07-08 at 1.07.44 AM.jpg  

Last edited by newbie; 07-08-2017 at 06:26 AM.
newbie is offline  
 
Reply With Quote
Old 07-08-2017, 12:39 PM   #9
DeeAnna
SOAP_SUPPORTER.png
 
DeeAnna's Avatar
 
Join Date: Feb 2013
Location: Iowa USA
Posts: 8,332
Liked 11222 Times on 5082 Posts
Likes Given: 5019

Default

Hi, Newbie and Krista -- THANK YOU for responding and doing what you can to help. I really appreciate that.

I'll make the updates per your notes, Newbie -- superb work!

The admins asked me to moderate the spreadsheet, but that's turning out to be more of a challenge than I thought. To have full control, one needs to be the owner of the doc and I'm not it. The admins are trying to contact the original doc owner -- he hasn't been on SMF for over 5 years -- and hopefully he will respond.

If he doesn't, one possibility I may have to consider is to re-create the spreadsheet as a new doc and go from there. I hate to do that because all of people's links and bookmarks to the FO Review will then no longer work.

But at the moment, that idea is moot -- I cannot delete the old doc due to someone protecting a row of cells in the Mad Oils sheet, and I can't unprotect the cells without being the owner. Grrr. At least this prevents someone from deleting the entire spreadsheet, so maybe that's an unintended blessing.

Edit -- All problems are now fixed, so no further action is needed. Again, my thanks!

Krista -- I recreated your entry for Asian Sandalwood per Newbie's backup info.

Last edited by DeeAnna; 07-08-2017 at 12:56 PM.
DeeAnna is offline  
KristaY Likes This 
Reply With Quote
Old 07-08-2017, 04:32 PM   #10
newbie
Lifetime Supporting Member
SOAP_LIFETIMESUPPORTER.png
 
Join Date: Nov 2010
Posts: 5,802
Liked 4915 Times on 2043 Posts
Likes Given: 381

Default

Did the owner respond? What are the plans for protecting the spreadsheet? Will you be locking down the existing info and then leaving open spots for people to contribute?

These and other burning questions.......


newbie is offline  
 
Reply With Quote
Reply


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Access policy for the SMF Fragrance Oil Review spreadsheet DeeAnna SoapMakingForum Announcements, Comments, Help & Rules 25 07-29-2017 05:22 PM
Fragrance Review Spreadsheet?? CraftyRedhead Fragrance Oils/Fragrance reviews 2 05-20-2014 04:24 AM
Newbie - Can you review my proposed recipe? SudsyKat Lye-Based Soap Forum 37 09-16-2010 10:38 PM
Thanks to honor435 and agriffin Hazel Lye-Based Soap Forum 13 05-18-2010 11:17 PM



Newest Threads