Design Techniques Spreadsheet

Discussion in 'Soap Making Recipes & Tutorials' started by CaraBou, Jan 22, 2017.

  1. Feb 1, 2017 #21

    earlene

    earlene

    earlene

    Grandmother & Soaper Lifetime Supporter

    Joined:
    Apr 30, 2016
    Messages:
    3,392
    Likes Received:
    3,112
    Location:
    Western Illinois, USA
    I added the pointillism technique.

    Problems I find and the best solution of which I am aware: Adding multiple links in a cell is difficult, but if you unlink the first link, then you can add the others. But you end up with URLs that aren't really links anymore. If you try to relink them all, they don't work as separate links. You get a message that multiple links in a cell is not possible. So just leave them unlinked. The person who wants to use the link will have to copy and paste into their browser it seems.

    However, I can't quite figure out how Carabou got the space inserted between the two URLs listed in the cell for the Pipe Divider Technique. If I figure that out, I will add it in the cell for Pointillism URLs and post here how it's done.


    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    ETA: I found it with a simple Google search:

    Now you need to add carriage return or hard return manually in cells.
    Step 1: Double clicking the cell you will work with, and get to edit it.
    Step 2: Put the cursor at the specific position that you want the long sentence wrapped.
    Step 3: Press the Alt key and Enter key together.
     
    Last edited: Feb 1, 2017
    CaraBou likes this.
  2. Feb 2, 2017 #22

    artemis

    artemis

    artemis

    Mostly Harmless

    Joined:
    Feb 27, 2016
    Messages:
    955
    Likes Received:
    1,401
    Location:
    Sol system, Sector ZZ9 Plural Z Alpha
    I saw "dragonfly" on the list and that intrigues me-- I love dragonflies. But, when I google I can't find an example. Is this a thing and I've just never heard of it?
     
    CaraBou likes this.
  3. Feb 2, 2017 #23

    ngian

    ngian

    ngian

    Well-Known Member

    Joined:
    Dec 9, 2014
    Messages:
    565
    Likes Received:
    444
    Location:
    Athens, Greece (Very Hard Water)
    CaraBou likes this.
  4. Feb 2, 2017 #24

    CaraBou

    CaraBou

    CaraBou

    Lifetime Supporter

    Joined:
    Dec 26, 2012
    Messages:
    2,785
    Likes Received:
    2,674
    Way to go Earlene, you defined a limitation and the less than perfect solution (Alt-Enter to paste more than one web address, none of which would have an active hyperlink). That was my exact workaround.

    Because >1 tutorials are often desirable, should I create multiple columns and place them as the end columns? They won't be up front but they'd have more room and could each contain a live link so that cut and paste isn't needed.

    Another idea is to create a database rather than a spreadsheet, but I have not explored whether this is possible in google docs. A data base can accommodate more complex data and be set up in a different format than simple rows and columns.

    I won't be in a position to explore these ideas until I am home again. I fly back tomorrow but we're leaving to ice fish this weekend. So for now I'd say dump the links into a shared cell without active hyperlinks using Earlene's instructions, and we can sort out the rest later. Or if anyone wants to take a crack and creating more tutorial columns at the end, feel free. Or any other promising idea, for that matter.

    Artemis - the dragonfly should probably be considered an alternate name to the butterfly. You get them with a similar technique but different motions. I listed them separately because I wasn't sure whether I'd find a tutorial specific to the dragonfly. I have seen some neat dragonflies so wanted to recognize them as separate if that was realistic.

    I really wish we could do thumbnails for a quick easy glance but I'm hitting a wall on that one. It seems way more involved than a collaborative sheet should ask. This shouldn't be frustrating, it should be fun!

    You found a jackpot ngian! Feel free to patch in the tutorial links and other tidbits you've learned from your own experience. Ethically, it can get gray very quickly if we're simply copying what others have reported. The tutorials seem fair game to me since they're open on youtube for tutorial purposes, but I'm hoping we fill in the other columns from our collective experiences or extensions of logic from other projects. Speak up with thoughts on this approach.
     
  5. Feb 2, 2017 #25

    artemis

    artemis

    artemis

    Mostly Harmless

    Joined:
    Feb 27, 2016
    Messages:
    955
    Likes Received:
    1,401
    Location:
    Sol system, Sector ZZ9 Plural Z Alpha
    Does that gray area go away if there is also a column that properly cites the source material?
     
    CaraBou likes this.
  6. Feb 2, 2017 #26

    earlene

    earlene

    earlene

    Grandmother & Soaper Lifetime Supporter

    Joined:
    Apr 30, 2016
    Messages:
    3,392
    Likes Received:
    3,112
    Location:
    Western Illinois, USA

    There are 2 ways to do that, but the best way is to use the 'Function' code, as described in the video at the end of this post.

    It is the best way because it keeps the image within the cell and does not interfere with adding or deleting columns or rows, whereas the other way does.

    It is a bit more detailed, but not at all difficult. I went ahead and inserted a column and titled it Thumbnails and put in an image to test it out. The instructions are:

    1. Select or highlight the cell where you want to insert the image.
    2. In the Formula Bar (where you see the grey 'fx') type:
    =("url")
    where url is the actual url of the image you wish to insert
    3. Enter

    You will now see the image inside the cell.

    The = sign, the parentheses and the quotation marks surrounding the url are required for this formula to work in a spreadsheet.

    Issues of concern: The url will need to be for non-copyrighted material or material for which we obtain permission. The one I chose is a 1887 Vincent Van Gogh painting done in the pointillism style (Self Portrait) obtained from a site stating it is in the Public Domain. But to choose a picture of actual soap done in this style, I think finding a Public Domain link would be very difficult, so I would suggest we use our own photos if we are willing, or leave them blank.

    Video:

    [ame="https://www.youtube.com/watch?v=bCNfRC3-K-E"]here[/ame]
     
    Last edited: Feb 2, 2017
    CaraBou likes this.
  7. Feb 3, 2017 #27

    CaraBou

    CaraBou

    CaraBou

    Lifetime Supporter

    Joined:
    Dec 26, 2012
    Messages:
    2,785
    Likes Received:
    2,674
    That's awesome earlene -- you are the spreadsheet queen! Thanks for taking the initiative and please keep that up! Do you know how to use a pic from a hard drive or google drive instead of a URL? Sorry I couldn't figure it out myself yet - just got home tonight and haven't had much time to poke around.

    I would think so, since we have a lot of that type of reference here. But I'd still prefer that we speak from our own experiences as much as possible -- it just seems like a better way to go.


    I don't think we're going ice fishing this weekend, so hopefully I can play around with spreadsheet some more. I'd like to get kinks worked out as quickly as possible, so keep posting troubles and ideas.
     
  8. Feb 3, 2017 #28

    earlene

    earlene

    earlene

    Grandmother & Soaper Lifetime Supporter

    Joined:
    Apr 30, 2016
    Messages:
    3,392
    Likes Received:
    3,112
    Location:
    Western Illinois, USA
    You can used to be able to obtain the url from your Google Drive image* and insert it the same as previously explained. But I am having trouble finding how to do it now. They seem to have made some changes. I'll keep trying, as I am pretty sure it can still be done. Okay, got it. It's kind of complex. Instructions below.

    But since the image on your computer has no url, you can't really insert it into the cell using the function menu bar. If you use insert from the drop down menu, it sits on top of the spreadsheet and not inside the cell, so it just won't work in the way we would want within the spreadsheet. When ever new rows or columns are added it would mess up the looks of the spreadsheet.

    So I recommend using an image hosting site for photos that should go into the thumbnails. That way you can get a url.


    * How to insert a Google Drive image into a cell:

    1. open Google Drive and find your desired image (make sure it has the image icon to the left of the name)
    2. right click on the image name (not the image, but the name itself)
    3. choose Get shareable link
    4. copy the link
    5. paste link
    6. withing the link CHANGE only the word open to uc
    7. proceed as previously instructed

    Example: my link from my Google Drive:
    https://drive.google.com/open?id=1YfnHB-I9RRAETiXqciu0jfM05IrXNENx5w
    (It isn't showing completely above, but the last part is: 1YfnHB-I9RRAETiXqciu0jfM05IrXNENx5w)

    within the url, find the word 'open' and change it to uc

    https://drive.google.com/open?id=1YfnHB-I9RRAETiXqciu0jfM05IrXNENx5w

    becomes:

    https://drive.google.com/uc?id=1YfnHB-I9RRAETiXqciu0jfM05IrXNENx5w

    This is what is pasted into the function menu bar as:

    =image("https://drive.google.com/uc?id=1YfnHB-I9RRAETiXqciu0jfM05IrXNENx5w")

    I inserted it into the last row that I added to test this out. It is an image of a glacier in Alaska, not a soap. It was for testing purposes only.
     
    Last edited: Feb 3, 2017
    CaraBou likes this.
  9. Feb 5, 2017 #29

    CaraBou

    CaraBou

    CaraBou

    Lifetime Supporter

    Joined:
    Dec 26, 2012
    Messages:
    2,785
    Likes Received:
    2,674
    Thanks for investigating that Earlene, you have way more patience than I do! Who knew it would be such a big deal to add thumbnails, or be so restrictive. I wouldn't mind a few funky results but I'm afraid it would frustrate contributors & users, and possibly turn some away.

    A few options I see (though there could be more):
    1. Let the Tutorial Links provide the pics (whether they be videos or text & pics)​
    2. Change the column header to "Pic Links" so it directs people to provide a hyperlink rather than encouraging them to embed thumbnails​
    3. Move that column toward the end of the spreadsheet and let people try to figure out how to embed thumbnails (realizing we may get floaters)​

    I am tending toward #1 but I am certainly open to different opinions and additional options. What do you all think?

    P.S. I forgot to say I love the AK glacier pic! Which glacier is it?
     
    Last edited: Feb 5, 2017
  10. Feb 5, 2017 #30

    earlene

    earlene

    earlene

    Grandmother & Soaper Lifetime Supporter

    Joined:
    Apr 30, 2016
    Messages:
    3,392
    Likes Received:
    3,112
    Location:
    Western Illinois, USA
    It was Holgate Glacier. We took a boat tour out of Seward. The shades of blue in the glaciers are incredible.

    Re: the thumbnails in the spreadsheet: I lean towards #1 as well. Although being able to have them is cool, it is rather problematic, especially if someone isn't comfortable with the technical challenge. And the are pretty small anyway, making them a little hard to see.
     
  11. Jun 14, 2017 #31

    aphro1

    aphro1

    aphro1

    New Member

    Joined:
    Jun 14, 2017
    Messages:
    1
    Likes Received:
    0
    Great! I just sent a doc request.
     
  12. Jun 14, 2017 #32

    Jena

    Jena

    Jena

    Active Member

    Joined:
    May 16, 2017
    Messages:
    30
    Likes Received:
    17
    There is a gorgeous confetti soap on youtube that is really more of an abstract painting. That may be the one you mentioned.
     
  13. Jun 16, 2017 #33

    CaraBou

    CaraBou

    CaraBou

    Lifetime Supporter

    Joined:
    Dec 26, 2012
    Messages:
    2,785
    Likes Received:
    2,674
    Sorry guys - I had it down, and have been getting lots of access requests, so I put it back up. You won't get an email notice I don't think. Please add to the sheet!
     
  14. Jun 16, 2017 #34

    Dahila

    Dahila

    Dahila

    Supporting Member

    Joined:
    Dec 29, 2013
    Messages:
    2,277
    Likes Received:
    1,520
    Location:
    Canada, Ontario
    Thank you Carbou it is accessible now :)
     
  15. Aug 26, 2017 #35

    keelsoaper

    keelsoaper

    keelsoaper

    Member

    Joined:
    Jun 11, 2017
    Messages:
    15
    Likes Received:
    14
    Location:
    PA, USA
    Great Idea! I have been looking for a listing and instructions on all of the swirling techniques. If anyone knows of any other resources I'd really appreciate it. How do you access the most current sheet? Thanks.
     
  16. Nov 27, 2017 #36

    jmbuffy

    jmbuffy

    jmbuffy

    New Member

    Joined:
    Nov 25, 2017
    Messages:
    2
    Likes Received:
    0
    CaraBou- This will be such a great resource for information and inspiration. If I understand correctly, the Top Design tab calls-out entries from the Soap Designs tab. If this file is similar to an Excel file, Top Designs can be set up as links to rows on the Soap Designs tab instead of separate entries. That way there’s no need to re-enter the info, and all edits made to the associated row in Soap Designs will come through automatically. I hope that’s helpful. Thank you for your initiative, it’s a great example of the supportive nature of the soaping community.
     
  17. Nov 27, 2017 #37

    shunt2011

    shunt2011

    shunt2011

    Staff Member Admin  

    Joined:
    Apr 3, 2012
    Messages:
    9,730
    Likes Received:
    5,188
    Location:
    Michigan
    If you go back a few pages you will find the link to the file

    https://docs.google.com/spreadsheets..._-g/edit#gid=0
     
  18. Nov 27, 2017 #38

    jmbuffy

    jmbuffy

    jmbuffy

    New Member

    Joined:
    Nov 25, 2017
    Messages:
    2
    Likes Received:
    0
    Thanks - shunt2011. I saw the link to the file. My misunderstanding was thinking the Top Designs tab was a subset of the Soap Designs tab - as in what is currently popular. Now I see it means designs for on top of the soap. (Douh!)
     
  19. Dec 23, 2017 #39

    Ema

    Ema

    Ema

    Member

    Joined:
    Nov 23, 2017
    Messages:
    9
    Likes Received:
    7
    Cool! As a newbie, I’m excited to learn as much as I can and now I really want to learn some of these techniques!
     

Share This Page