Book Art - DIY Tutorial to create your pattern with any image for photo strip book art

Поділитися
Вставка
  • Опубліковано 11 бер 2022
  • Book Art - DIY Tutorial to create your pattern with any image for photo strip book art
    In this tutorial I explain the process to create your pattern using Libre Office and then I show the process (with tips) in applying the image to the book pages. I use Libre Office, but the process is the same with Excel.
    👉👉👉👉NEW!!
    CREATE PATTERNS WITH MY NEW APP - FOTOBOOKART.COM
    TUTORIAL: ua-cam.com/users/livemzTsjR_FQdE?...
    Links to:
    👉 Crafted Sweetly FB Group: / 252806676060201
    👉 FB Page: / craftedsweetly
    *Some of the links below may be affiliate links. If you use these links to buy something I may earn a commission at no additional cost to you. I have purchased all supplies and no product below was donated to me for the making of this video*
    Supplies/links mentioned in this video:
    👉 Cutterpillar: amzn.to/3DM62Mk
    👉 Scor-pal: amzn.to/35QjGCk
    👉 1/4" Double Sided Tape: amzn.to/3MEfGp8
    👉 Book Stand: www.etsy.com/listing/96109896...
    Equipment used in the production of this video:
    *Canon M50: amzn.to/38OV0I7
    *Microphone: amzn.to/3rM6d4W
    *Tripod: amzn.to/3pBqW9y
    *Ring Light: amzn.to/2X1CQx3
    *Canva: www.canva.com/join/tjv-skm-pbq
  • Навчання та стиль

КОМЕНТАРІ • 224

  • @sheilapoole7557
    @sheilapoole7557 Рік тому

    Thank you for an amazing video, such a clever technique and described very clearly.

  • @ruthrich
    @ruthrich Рік тому

    WOW!! Can't wait to give this a try. Very well explained, Thank you. I haven't done a 'fold' in a while so this is really calling my name as a new craft and an extension of book crafts.

    • @CraftedSweetly
      @CraftedSweetly  Рік тому

      Thank you for the wonderful feedback! I have a few different project I've done with the strip photos. Videos are in my channel. Have fun and post in my FB group :)

  • @bridgetrivard8884
    @bridgetrivard8884 3 місяці тому

    You are an excellent teacher! Thank you!

  • @leonaklassen6230
    @leonaklassen6230 4 місяці тому

    I just discovered this art, and your instructions are excellent, thank you! Beautiful version of book folding.

  • @danad9879
    @danad9879 2 роки тому +1

    Wow! What an amazing feat of patience and attention to detail! It was fascinating to watch the process unfold and arrive at the finished product - a beautiful picture! I could never do this myself - I don't have the patience or the dexterity to produce something so refined - but I sure enjoyed seeing it.

  • @bluka
    @bluka 4 місяці тому

    Thanks a lot for your process description, Is so useful and simple. GBU🙏❤️

  • @lenamccoy1294
    @lenamccoy1294 9 місяців тому

    Great tutorial! Thank you!

  • @craftingbysharon9869
    @craftingbysharon9869 Рік тому +1

    Thank you!

  • @SP-vj8or
    @SP-vj8or 7 місяців тому

    Ich falte schon lange Bücher aber auf die Idee bin ich nicht gekommen .Super schön

  • @greetjenijdam
    @greetjenijdam 2 роки тому

    Thanks. Greetz from Holland.

  • @lovelearnin5012
    @lovelearnin5012 2 роки тому

    That was a great tutorial I am not computer Savvy as far as using programs but maybe one day I will give it a shot. For now I will stick to my book folding. Thanks for your time and expertise

    • @CraftedSweetly
      @CraftedSweetly  2 роки тому

      Thank you so much. If you need assistance or would like me to make you a pattern just so you can try it out, let me know.

    • @lovelearnin5012
      @lovelearnin5012 2 роки тому

      @@CraftedSweetly someone made me a pattern already I am going to give it a shot I didn't know you make patterns to sell

    • @CraftedSweetly
      @CraftedSweetly  2 роки тому

      I don't really make them to sell. I can help out with one at no charge when I have time

    • @junedavis4631
      @junedavis4631 2 роки тому

      @@CraftedSweetly please make me one so I can give it a try please

    • @annepot9707
      @annepot9707 Рік тому

      ​@@CraftedSweetlybjr serait il possible d avoir un modèle pour pouvoir tester? très beau merci à vous

  • @suzichoclatcrafts
    @suzichoclatcrafts 2 роки тому +1

    Totally amazing video crafted sweetly, really love this idea. Thank you so very much for showing all the stuff in excel. I am a paper crafter on CraftWorld and just seen you got chosen in the crafter of the week line up with your Border Collie picture book. Congratulations, it’s awesome🥳 I’ve never done anything with books like this. Just had a shoulder replacement a week ago and cannot move my arm enough in the sling to make cards yet but maybe able to do this! 😍
    Am I correct in thinking you only put the double sided tape on the top and bottom corners of the page you showed and none on the backside of the page? Thank you so much again for such a fabulous explanatory video 💖💖 xxx

    • @CraftedSweetly
      @CraftedSweetly  2 роки тому

      Thank you so much Suzi! I love craftworld and all the creativity in that community! I hope you're able to do the fold! Yes, tape only on front top and bottom. I didn't have any problem with the strips staying put. If you're on FB, you're welcome to join my group there!

    • @suzichoclatcrafts
      @suzichoclatcrafts 2 роки тому

      @@CraftedSweetly oh lovely will have a look tomorrow. I will do my best and let you know how I get on 💖

  • @laurasgenius333
    @laurasgenius333 2 роки тому

    Excellent video - can't wait to try making my own photos! Can you say the name again of that scoring tool - that really looks like it would make it easier and that it would lay flatter. Love this!!!!

    • @CraftedSweetly
      @CraftedSweetly  2 роки тому +1

      Thank you Laura. The scoring board is called Scor-pal - here is the link: amzn.to/35QjGCk.

  • @kristineoliver278
    @kristineoliver278 Рік тому

    A while back you were trying to figure out how to make this but in an ink-saver version. Did you figure out how to do that? Thank you so much for everything you share with all of us!

    • @CraftedSweetly
      @CraftedSweetly  Рік тому +1

      Thank you so much for watching! I haven't been able to create it myself in a spreadsheet, however I had an app developed where you upload the image, enter height in inches, and total number of pages and the program does it all. You can choose ink saver option. You can find the app at fotobookart.com

  • @crazydiva4131
    @crazydiva4131 2 роки тому +1

    Thank you for answering me, I firgured that out but now I need to know how to make my height 9 inch. Do you know? I'm using excel.

  • @kensymanski820
    @kensymanski820 2 роки тому

    Thank you for such a fantastic and clear tutorial. You're very generous in showing how you do this. May I ask how long it typically takes you to complete a 300 page (or so) book once you've got the picture printed? ie. cutting / scoring / taping process

    • @CraftedSweetly
      @CraftedSweetly  2 роки тому +1

      Happy to share! :) I've never actually timed it because I never finish them in one sitting. Guessing around 4-5 hours.

  • @crazydiva4131
    @crazydiva4131 2 роки тому

    The program you are using is Libre office. Can you please tell me what version. :)

  • @michellemajorel9962
    @michellemajorel9962 8 місяців тому

    Good morning ,
    I discovered your channel and I love it
    could you tell me the formula for the page break please?
    I also use libre office
    you have a new subscriber

    • @CraftedSweetly
      @CraftedSweetly  8 місяців тому

      Hi - page break? You don't really need to add a page break. When you print the pages will print without having to add them.

  • @kittyhutto1350
    @kittyhutto1350 Рік тому +1

    I found your video quite interesting. However there were lots of glitches putting it into the excel as for the column width in excel. It is 6.0 To get the half inch wide columns. It definitely took me a while to figure that out once I did. I was able to get my picture installed and it printed out perfectly with the number of pages in my book. Your video is very instructive and i'm sure will help others.

    • @CraftedSweetly
      @CraftedSweetly  Рік тому

      Thank you! I may have referred to program as Excel in one place in the video. I used LibreOffice where you can set the columns in inches. Excel is a little different. I'm glad you were able to figure out the width in Excel!

  • @margievanhandel259
    @margievanhandel259 9 місяців тому

    Great tutorial and extremely appreciated. Would like to know how you go in and set it up to save on ink. Also, is there a preferred photo size to use for best results? Thanks

    • @CraftedSweetly
      @CraftedSweetly  9 місяців тому

      No preferred size. Lot of trial and error. Depends on photo, book height, etc. For the ink saver, I have not been able to figure out the process. I had an app developed where you can create images with ink saver option. fotobookart.com

    • @margievanhandel259
      @margievanhandel259 9 місяців тому

      @@CraftedSweetly Oh, I thought that in your other video you said one of your FB folks was able to do the ink saving, so I assumed that was something you had taught that individual to do. Maybe she could share. We don't do social media in our home so I can't check this out. Thank You

  • @gerrypetocz6212
    @gerrypetocz6212 2 роки тому +1

    Do you know how to do the current format where the print is only in the middle of the strips? I think its under picture format but Im having trouble figuring it out.

    • @CraftedSweetly
      @CraftedSweetly  2 роки тому

      I'm trying to figure it out. As soon as I do, I'll be sure to post a video

  • @natalieallen1311
    @natalieallen1311 3 місяці тому

    I've have Microsoft Excel and Libre Cal. When i made patterns and printed, the pics look kinda pixelated. Will this affect the look at the foto edge?

    • @CraftedSweetly
      @CraftedSweetly  3 місяці тому

      It can. If the image is not high resolution, that’s how the final book will look too. Should be sharp

  • @shelleyhozalski9437
    @shelleyhozalski9437 25 днів тому

    I’m a crafter that likes to try all new things. I heard about this craft while going to garage sales. One of the homeowners was selling some crafting supplies & we got to talking & this is how I started searching for this on UA-cam. I also have a Cricut & read your comments and saw someone had asked you about it. Have you figured out how to make it work using a Cricut? Also, when using your Fotobookart website it asks for the last odd page. What about the extra pages in the front & back of the book; do we include those pages? Do you also have where you can also do the top of the pages in your website program? Looking to do a book for an 85th birthday celebration coming up mid July so wanting to get this going. I found a book at one of the garage sales titled Happy Birthday by Danielle Steel in mint condition and going to put a pic of her family on it!
    Thank you!

    • @CraftedSweetly
      @CraftedSweetly  25 днів тому

      That's awesome! Glad you found my videos! I thought about it some more after that viewer suggested it, and I think it would take longer for the Cricut to cut it than me cutting it with my Cutterpillar. Plus, I would be concerned about lifting the strips off the sticky mat as they could curl, tear, etc. It's just faster by hand overall. Additional pages at the front or back, can be added to the total count, which is what I do because I like to use up all the pages. For the top of the book, it's the same program; the top would just be another pattern - I have a video for front/top design. I have videos on about every topic. Let me know if you have any questions. Thank you!

  • @tarawest13
    @tarawest13 6 місяців тому

    I’m confused as Google Sheets show 143 strips but excel says 286 which doesn’t make sense. When I followed the excel sheet it wanted to print out 28 pages yet on Google Sheets it was 14 sheets

  • @FoldedWords
    @FoldedWords Рік тому

    which paper cutter are you using? does the cutter have a light? thank you than you

    • @CraftedSweetly
      @CraftedSweetly  Рік тому

      I use the cutterpillar pro, but don't see it currently available on Amazon. The next one is this and it does have a light (which I LOVE!). amzn.to/428TxHd

  • @furryfluff
    @furryfluff Рік тому

    Could you tell me how you sized the picture again. I have a mac and it is a bit different than what you are showing here in the video

    • @CraftedSweetly
      @CraftedSweetly  Рік тому

      With a Mac you can use Google sheets. Or, I know have an app that will create the pattern for you. Fotobookart.com

  • @susanmeany9002
    @susanmeany9002 Рік тому

    @craftedsweetly
    You mention that you have a video showing have you wrap a book. Could you post which video that is please?

  • @borntoblag
    @borntoblag Рік тому

    Hi, do you only use the double sided tape on one side of the page? not the other side too?

  • @garymurphy5133
    @garymurphy5133 Рік тому

    if you put the doulble sided tape in the same place all the time does this not make the book thicker in that area?

    • @CraftedSweetly
      @CraftedSweetly  Рік тому

      It's so thin that it doesn't make a difference. Since this video, I've switched to this type of double sided tape and the process is much faster. amzn.to/3Kuh6DD

  • @kevinfoster2934
    @kevinfoster2934 2 роки тому

    What gsm paper is best to use? Photo paper cracks if you fold it.

    • @CraftedSweetly
      @CraftedSweetly  2 роки тому

      I use 75-90 gsm glossy paper or just regular copy paper.

  • @teresa-ux8db
    @teresa-ux8db 4 місяці тому +1

    So, the other side of the page strip is not taped?

  • @Purpleshade50
    @Purpleshade50 2 місяці тому

    Excellent explanation, but is it really necessary to use a spread sheet? it seems the only reason is to get even strips cut, or am I missing something

    • @CraftedSweetly
      @CraftedSweetly  2 місяці тому

      Thank you! It's to get even strips, but with a spreadsheet you can also easily number the strips using formulas and also create the tick marks to help know where to cut.

  • @janetcampbell3243
    @janetcampbell3243 Рік тому

    i cant get my numbers to follow across. i am using Excel and Libre but nothing is working for me

  • @lillianpoppa7609
    @lillianpoppa7609 8 місяців тому

    What is the best paper to use? I have ab ink jet hp printer.❤

    • @CraftedSweetly
      @CraftedSweetly  8 місяців тому

      I use 28# copy paper. It's a little heavier and find it easier to fold. amzn.to/3FTlJ70

  • @jillmiller7864
    @jillmiller7864 Рік тому

    When determining the height and width of a photo on excel, should either the "lock aspect ratio" or "Relative to original picture size" be checked. My height is 9 inches, my width is 129. What should i write for scale height and scale width? Thanks!

    • @CraftedSweetly
      @CraftedSweetly  Рік тому

      No - neither should be checked. You want to be able to enter the height and width yourself. The height will be height of the book and the width, the number of pages in the book divided by 4. Hope that helps.

    • @CraftedSweetly
      @CraftedSweetly  Рік тому

      Technically by 4. You're using 1 strip per leaf (page 1 and 2 use the same strip) so you divide by 2 and then each strip is 0.5" wide, so you divide by 2 again. Not sure if you're aware, I now have an app that creates the patterns for you...fotobookart.com. all you have to do is upload image, enter # of pages and height of book in INCHES. It's $2.99 and it creates the pattern for you, regular or inksaver.

  • @usyungs
    @usyungs 2 роки тому +1

    I'm just a little lost on how to make the height of the book. Also, how do I know if my column width is in inches? I can't see where that's listed.

    • @CraftedSweetly
      @CraftedSweetly  2 роки тому

      For the inches, just enter " after the number. To enter the height, go to format, page size and position and there you can enter the height. Not sure why the pop-up window didn't record. I wrote it on the screen in the hopes that it would help

    • @buddysmith7080
      @buddysmith7080 Місяць тому

      @@CraftedSweetly Can this part be done in excel as well as the program you used?

  • @nancygreer2263
    @nancygreer2263 4 місяці тому

    Wow! I just found out about this type of art and your video. Have you considered using a Cricut machine to do the cutting & scoring for you? I would think you might be able to just set up your pages to print, and line up on a cutting mat, and use a template mimicking your cut and score lines and let the machine do the work. I just might try this out one day!

    • @CraftedSweetly
      @CraftedSweetly  4 місяці тому +2

      Wow! You’ve given me a new project to experiment with! I have a Cricut so this might be new frontiers to explore! Thank you!!!

    • @CraftedSweetly
      @CraftedSweetly  4 місяці тому +1

      Btw, this video is going my viral over the last couple of days. How did you hear about my video?

    • @nancygreer2263
      @nancygreer2263 4 місяці тому

      ​@CraftedSweetly I'm a retired IT professional, and logic and efficiency were my Forte! I run my own crafting and embroidery business, and I've always thought out of the box with all the self-taught knowledge I've acquired. I learn something new EVERY day! And THIS was that new thing 🎉. So, as I watched your video, and having experience in 3D papercrafting, it was natural for me to watch you using familiar tools... the scoring board... and since I own 5 cutting machines, and have the scoring tool for my Cricut, watching your Excel process (which is genius) my brain just blended all these skills together for a potentially automated, efficient, consistent process. 😁 Of course I had to mention it, you're the expert of the current process, and would be able to advise if you thought it might work. If your sharing knowledge with us, only fair to reciprocate.😊 😊😊 I would love to know if you test it out!❤

    • @nancygreer2263
      @nancygreer2263 4 місяці тому

      ​​@CraftedSweetly You know... I think it popped up as a project in a new group I just joined, or as I was watching UA-cam where they have preview videos... Not sure, I'll have to check my screenshots and video history. All I know was it was part of my "learn something new" daily journey, and I was fascinated. I will try to figure how I found it and update if I figure it out. In any case, bravo for the traffic on it!🎉🎉🎉❤💯🎯🏆😃

  • @debbieragsdale2785
    @debbieragsdale2785 2 роки тому

    I am finally trying to get my spreadsheet set up to give this a try. I can't figure out how to put the lines in between each column all at one time. I am using excel. Any suggestions?

    • @CraftedSweetly
      @CraftedSweetly  2 роки тому

      Highlight all the cells and click on borders. Choose that is a square with: a vertical and horizontal line through the square. Hope that makes sense

    • @debbieragsdale2785
      @debbieragsdale2785 2 роки тому

      @@CraftedSweetly I did exactly that but it didn't work for some reason. I manually added the lines and saved it as a template. That way I will have it to work with for each book I create if I do more than one.

  • @giusyghelfi4290
    @giusyghelfi4290 9 місяців тому

    Great work, I only have two questions: How many minimum pages must the book have? What are the prices of these works? Thanks from Italy and good work

    • @CraftedSweetly
      @CraftedSweetly  9 місяців тому +1

      Thank you so much.I probably wouldn't do a book with fewer than 150-180 pages. The number of pages depends on the image too. Pricing varies by geographic area, number pages, etc. You can check etsy for completed books.

  • @emilyforever831026
    @emilyforever831026 2 місяці тому

    Hi, is there a minimum number of pages a book needs to be to be used?

    • @CraftedSweetly
      @CraftedSweetly  2 місяці тому

      Depends on the image. I’ve done some books with 150 pages, but most images require over 300 and 400 pages

  • @user-yl7jf4bo7x
    @user-yl7jf4bo7x 4 місяці тому

    Could you please tell me the name of the app that is available for this? I can’t understand how to spell it when I hear you say the name . Ty!

    • @CraftedSweetly
      @CraftedSweetly  4 місяці тому

      sure - it's fotobookart.com - it's a web based app. If you have any questions using it, please let me know.

  • @antoniabonomo6019
    @antoniabonomo6019 3 місяці тому

    Complimenti sei bravissima ti posso chiedere un informazione io non so usare il compiuter se prendo una foto e la ritaglio tutta a mano dividendo la foto in cm in base alle pagine del libro si può fare lo stesso perché mi piacerebbe imparare se mi puoi rispondere grazie

    • @CraftedSweetly
      @CraftedSweetly  3 місяці тому

      Unfortunately it wouldn't work that way. The photo has to be stretched out based the on the number of pages you have. If you can receive emails on your phone, I have patterns in my Etsy shop that I can email you and then you can take to a print shop to print the file.

  • @debbieragsdale2785
    @debbieragsdale2785 2 роки тому

    How do you determine the number of pages needed? I have done many folded books with patterns so am experienced but not sure if there is a special way to determine this.

    • @CraftedSweetly
      @CraftedSweetly  2 роки тому +2

      For this, you can use any book - there isn't an exact number of pages you need because you base the "pattern" on the number of pages in the book - so you're working backwards in a sense. Having said that, too skinny and the image will look skinny, too thick, and the image will be distorted and wide. I would stay stick to books in the 275-400 page range. But you can do it with less and also with more.

    • @debbieragsdale2785
      @debbieragsdale2785 2 роки тому

      @@CraftedSweetly Thank you so much!

    • @CraftedSweetly
      @CraftedSweetly  2 роки тому

      My pleasure

  • @kensymanski820
    @kensymanski820 2 роки тому

    Diana - I wonder if you, or anyone else reading this, could help me solve a frustrating problem that I can't seem to fix? When I set up my picture in Libre Calc. I place it in Row 2, which in the case of the current book I'm working on, should be 9". When I check the height of Row 2 it shows that it's 9", but when I print it, Row 2 ends up being 8 5/8" or 8.625". I thought it might be a problem in my printer settings, but this happens on any printer I've used. I've played with the margins and I make sure that I'm not scaling down before printing, and this still happens.
    The only way that I seem to work around this is by adding the difference of 0.375" to the row and resizing the picture to fit. Then it prints at 9"

  • @faroukhpoacha1
    @faroukhpoacha1 Рік тому

    I am spell bound with your work... I had 1 question though... Can i do it with a book half the size in height... Say a mini hand book... Thanks for ur reply... God bless

    • @CraftedSweetly
      @CraftedSweetly  Рік тому

      Thank you so much. Certainly. Here's one that's about 7cm. ua-cam.com/video/q4ssY0F7Zlc/v-deo.html

  • @buddysmith7080
    @buddysmith7080 Місяць тому

    Is it better to use new books opposed to old books?

    • @CraftedSweetly
      @CraftedSweetly  Місяць тому

      It doesn't matter as long as the used books are in good condition and not falling apart

  • @crazydiva4131
    @crazydiva4131 2 роки тому

    what was the other program you had said? I can't make it out.

    • @CraftedSweetly
      @CraftedSweetly  2 роки тому +1

      I use Libre Office. It's very similar to Excel.

    • @crazydiva4131
      @crazydiva4131 2 роки тому

      @@CraftedSweetly which version is it, plz

  • @kalihiemier4195
    @kalihiemier4195 Рік тому

    My excel keeps adjusting the height and width everytime I try and enter the dimensions I need. It won’t keep what I enter, did you experience this?

  • @annadipace9635
    @annadipace9635 2 роки тому

    ciao grazie per il video volevo chiederti ma la carta delle strisce e un foglio da A4 grazie

    • @CraftedSweetly
      @CraftedSweetly  2 роки тому

      I'm not sure I understand the question. I printed the image on a regular sized piece of paper 8.5"x11"

  • @me-rycrea8558
    @me-rycrea8558 2 роки тому

    Did you try to do Whit 2 photos in the same pattern? I'd like to do the Imagine who change when i rotate the book...

    • @CraftedSweetly
      @CraftedSweetly  2 роки тому +1

      Not yet. I know the kind you're talking about. I'll have to figure it out. :)

    • @lauratoma
      @lauratoma 2 роки тому +1

      I have but it is rather complicated and takes multiple programs.

    • @CraftedSweetly
      @CraftedSweetly  2 роки тому

      @@lauratoma If you don't mind me asking, which programs were you using?

    • @lauratoma
      @lauratoma 2 роки тому +1

      @@CraftedSweetly Sure... I am on a Mac and used LibreOffice, Adobe, Preview, and Paint S. Since spreadsheet are meant for numbers not photos, it's a bit tricky to make them play together. ;)

    • @me-rycrea8558
      @me-rycrea8558 2 роки тому +1

      Yes i supposed It Is really complicate

  • @DawnAdams-wc1mb
    @DawnAdams-wc1mb Рік тому +1

    where can you purchase the book stand

    • @CraftedSweetly
      @CraftedSweetly  Рік тому

      It's in my etsy shop Crafted Sweetly. Link is in the description box of the video.

  • @sins_disaster293
    @sins_disaster293 2 місяці тому

    This is so cool. I might sound silly by asking this, but you don’t lose part of the picture? Say if you cut 1 inch strip, and only a millimetre of the picture on that strip shows on the edge of the book and the rest of the image is folder and tucked in between the pages, don’t you lose the inch of the strip minus the tiny bit that is sitting along the very edge of the page? If that makes sense….

    • @CraftedSweetly
      @CraftedSweetly  2 місяці тому

      The image is stretched and you don’t lose any of it. Turns out perfect

  • @karenkillips9115
    @karenkillips9115 Рік тому

    I am having issue with the scoring, it’s seems to take the color off the paper. Is it because I am using an ink jet printer? What would you recommend for a printer please any help would be appreciated

    • @CraftedSweetly
      @CraftedSweetly  Рік тому

      Are you scoring the backside of the pattern? Not where the image is. I use a laser printer, but a lot of people use an inkjet printer with no issues. It could be the paper

    • @karenkillips9115
      @karenkillips9115 Рік тому

      I’m scoring on backside not on image didn’t know if my printer was the issue

    • @CraftedSweetly
      @CraftedSweetly  Рік тому

      I would try another type of paper

  • @dianescaroni5935
    @dianescaroni5935 23 дні тому

    Can you show how you get the borders please

    • @CraftedSweetly
      @CraftedSweetly  20 днів тому

      In the toolbar, there's a button that is for borders. Click on that and it will put a border around the cell.

  • @bubuz1976
    @bubuz1976 Рік тому

    could you explain how to do a lenticular pattern?

    • @CraftedSweetly
      @CraftedSweetly  Рік тому +1

      I'm working on a tutorial - hopefully in the near future. Thank you.

  • @imtiazhemani
    @imtiazhemani 2 роки тому

    I am just little confused how much pages book would be good to get pic that has 4 pic

    • @CraftedSweetly
      @CraftedSweetly  2 роки тому

      It's the same as if it's one photo. The 4 photos are smaller. Mine was 345 pages I think.

  • @raffaellaferrari8954
    @raffaellaferrari8954 2 роки тому

    buongiorno, ho provato con excell ma la mia foto, sul libro, e' troppo schiacciata. come fai a regolarti con le pagine e l'altezza del libro? grazie

    • @CraftedSweetly
      @CraftedSweetly  2 роки тому

      How many pages does your book have? I have found that books that are 280-400 pages work great. Fewer pages and the image is too stretched and skinny, more and it's too squashed looking because it's stretched out horizontally. Hope that helps.

  • @bhavana1953
    @bhavana1953 4 місяці тому

    What kind of paper you use to print?

  • @karenkillips9115
    @karenkillips9115 Рік тому

    Crafted sweetly I became lost somewhere of adding the photo and put it in accourding to the size you said but when it streatched out it went past the number of 286 pages when I added the number of pages that was needed the actural photo went bigger than the aloted pages

    • @CraftedSweetly
      @CraftedSweetly  Рік тому

      If you have 286 pages in your book, the image width should be 71.5 inches

    • @karenkillips9115
      @karenkillips9115 Рік тому

      @@CraftedSweetly that is what I put in 71.5 inches and it set the picture 30 more past the 285 mark I am doing this in excel just cant figure out why its doing that any help is very welcome. I can grab the corner of the picture and drag it back but then I dont know if it will print out correctly and the other thing I am thinking is the collum space correct because I put in .5 it makes the spacing so tiny you cant make it out so if I put collum space at 5 it at least looks close to what you show in the video

    • @CraftedSweetly
      @CraftedSweetly  Рік тому

      @@karenkillips9115 I was actually using Libre Office not Excel. I do have that corrected in the description box of the video, but not in the video itself (where I said Excel). Excel, does not have the option of inches for column width unfortunately. I believe it's points or pixels - can't remember. There is a way to modify the column with to inches, but it's a little more involved in explaining. You should try Google Sheets if you want to make your own pattern, or I have launched a web based app that would create the pattern for you ($2.99/pattern). All you have to enter is the book height, number of pages and photo and the pattern is created. It also has the ink saver feature, so you can save on ink when printing.

    • @karenkillips9115
      @karenkillips9115 Рік тому

      @@CraftedSweetly thank you for all your help I will try and do the google sheets and if that doesent work for me I will be using your app thank you so much for all your help

    • @CraftedSweetly
      @CraftedSweetly  Рік тому

      My pleasure! Happy to help

  • @theresakelly6658
    @theresakelly6658 11 місяців тому

    I am still having issues getting the lines on the columns to show up.

    • @CraftedSweetly
      @CraftedSweetly  11 місяців тому

      It's only going to have a tick mark at the top and bottom, not line across the pattern. For lines across the pattern, I use my fotobookart.com.

  • @michelemazzolino5040
    @michelemazzolino5040 2 роки тому +1

    Ciao, sto provando a creare un pattern per mia madre ma non capisco le dimensioni delle colonne e delle righe. Grazie mille! Complimenti per il video!

    • @CraftedSweetly
      @CraftedSweetly  2 роки тому

      Thank you so much! I don't have much time to create custom patterns, but there is someone in my FB group who can create a custom pattern for you. Join my FB group and post that you are interested in a custom pattern and I'll tag Jacqui for you.

  • @mostajohn
    @mostajohn 2 роки тому +3

    How did you come up with the measurement 71.5inch, I cant figure it out. Can you please help me thanks in advance

    • @CraftedSweetly
      @CraftedSweetly  2 роки тому +1

      Happy to help! You take the number of pages in the book and divide by 2. That gives you the number of leaves in the book that you need strips for. Take the number of leaves and multiply by 0.5" (width of each strip) and that gives you the length of the picture. Example: book has 400 pages. Divide by 2 gives you 200 leaves. Multiply by 0.5" gives you 100" length for picture. Hope that helps!

    • @mostajohn
      @mostajohn 2 роки тому

      @@CraftedSweetly Thanks a lot for your reply,that was very helpful,so if i have a 400 page book,i divide by 2,which it will be 200,and then again divide by 2 which it gives me 100 in length..Thanks again.

    • @CraftedSweetly
      @CraftedSweetly  2 роки тому +1

      @@mostajohn Correct. I just said multiply by 0.5" so that you know why I was "dividing by 2 again.

    • @mostajohn
      @mostajohn 2 роки тому +1

      @@CraftedSweetly Thanks a lot,i am really happy to start my new hobby,thanks to you and your great videos you do.Greetings from Malta.

    • @CraftedSweetly
      @CraftedSweetly  2 роки тому

      @@mostajohn That's awesome! Thank you so much! Happy Folding!

  • @user-sl9sj8jm7r
    @user-sl9sj8jm7r Рік тому

    Bonjour j'ai pas compris votre tuto avec Exel sera-t-il possible de me ré expliqué svp ? merci beaucoup

    • @CraftedSweetly
      @CraftedSweetly  Рік тому

      Hi - I'm sorry, I'm not sure I can explain it differently. I do have an app called fotobookart.com and you create the pattern there without having to do all the spreadsheet work. Hope that helps.

  • @yvettereynolds5945
    @yvettereynolds5945 2 роки тому +1

    I’m thinking of so many possibilities for gifts, How much you charge for a book

    • @CraftedSweetly
      @CraftedSweetly  2 роки тому

      I haven't made any for sale yet, but probably around $50-$75 depending on number of pages.

    • @stephierobeson5451
      @stephierobeson5451 2 роки тому +1

      Hi, if Crafted Sweetly is unable to create one for you, let me know. I can help.

  • @ericbirocheau8265
    @ericbirocheau8265 Рік тому

    bonjour,
    je voudrai le faire avec un livre de 20cm de hauteur et de 206 feuille comment dois je faire pour la hauteur de la photo
    meci

    • @CraftedSweetly
      @CraftedSweetly  Рік тому

      The height of the photo will be 20cm. I also have a web app where you can just enter the specifications for the book, upload the pattern, and it will create the pattern for you. If you use the app, the height has to be entered in inches. The 20cm would be 7.874 inches. The app is at fotobookart.com.

    • @ericbirocheau8265
      @ericbirocheau8265 Рік тому

      bonjour,
      Je reviens vers vous car je ne comprend pas comment vous faite pour définir la hauteur des lignes ainsi que leur nombre mon livre mesure 23 cm , sur libre office c'est en cm.
      cordialement

  • @jillmiller7864
    @jillmiller7864 Рік тому

    Are you only glueing on one side?

  • @bhavana1953
    @bhavana1953 4 місяці тому

    I use Excel, but when i print, I can get numbers on top, but not on the bottom

    • @CraftedSweetly
      @CraftedSweetly  4 місяці тому

      Copy the top row and paste at the bottom.

  • @kpopstan5
    @kpopstan5 2 роки тому

    I am so excited to try this but as i am following along ... I am lost on the margin part..is there any chance of a better explanation like where are you putting .25 in?

    • @CraftedSweetly
      @CraftedSweetly  2 роки тому +1

      The 0.25 are the margins. Go to page layout and set page margins to 0.25 on all sides

    • @kpopstan5
      @kpopstan5 2 роки тому

      @@CraftedSweetly thank you and now idk what i am doing wrong...do you know why i am getting every other page just a 2in section of my photo at the top? I am so not excel savvy

    • @CraftedSweetly
      @CraftedSweetly  2 роки тому

      Yes...the image doesn't fit on one page. How tall is your book? Is your image right below row 1? Have you adjusted the page margins to 0.25" on all sides?

    • @kpopstan5
      @kpopstan5 2 роки тому

      @@CraftedSweetly 9.5 INCHES AND 317 PAGES yes the image is below the line so i can see the number of pages and i think i set the margins.. i dont see the same steps you did... wanna ho9ld my hand through the whole process? lol I really appreciate the help!

    • @CraftedSweetly
      @CraftedSweetly  2 роки тому

      @@kpopstan5 Is your book 9.5" high? You would need to use paper that's 11x14.

  • @crazydiva4131
    @crazydiva4131 2 роки тому

    for some reason in the program ur using is what i got and it doesnt pull the picture either

    • @CraftedSweetly
      @CraftedSweetly  2 роки тому

      What do you mean it doesn't pull the picture

    • @crazydiva4131
      @crazydiva4131 2 роки тому

      @@CraftedSweetly no i dont see the picture. I get the image/

  • @dianescaroni5935
    @dianescaroni5935 28 днів тому

    Sorry I can’t see what you do to make the borders please

    • @CraftedSweetly
      @CraftedSweetly  27 днів тому

      There is a button for borders in the tool bar. Also, wanted to let you know that now you can create patterns in less than 30 seconds using my web app at www.fotobookart.com. Monthly subscription is $4.99 and you can create as many patterns as you would like. It has the option of ink saver too.

  • @carolpurdue8706
    @carolpurdue8706 2 роки тому

    What paper is best to use for this process

    • @CraftedSweetly
      @CraftedSweetly  2 роки тому

      I used copy paper for a couple of them and it looked fine, but it made it a little harder to work with. The last one I did I used glossy brochure paper (thickness about 50-60lb). Much sharper and easier to work with - definitely prefer that one.

    • @carolpurdue8706
      @carolpurdue8706 2 роки тому

      @@CraftedSweetly thank you Looking forward to trying this method

  • @crazydiva4131
    @crazydiva4131 2 роки тому

    Ok, every time I highlight it to make it 0.5 , half an inch, the top numbers disappear. Help plz

    • @CraftedSweetly
      @CraftedSweetly  2 роки тому

      I'm not sure which numbers disappear? You have to highlight the columns (A,B,C, etc) and right click, then change column width. The numbers in the first row should remain. You're just changing the width of the column. Hope that helps.

    • @debbiepowers8197
      @debbiepowers8197 2 роки тому

      mine is doing the same thing, I mean the numbers and such are there but it compresses it so bad that you cannot see what is what. Her screen stayed the same :(

  • @danynava2133
    @danynava2133 2 роки тому

    ciao tutorial bellissimo, una domanda,non riesco a mettere i numeri 1-3 5 7 9, , metto*A1+2 ma non mi risulta il 3 , poi come fai a evidenziare tutti i numeri grazie

    • @CraftedSweetly
      @CraftedSweetly  2 роки тому

      You have to enter =A1+2. Then copy that cell and paste in as many columns as you need. Hope that makes sense.

  • @dianescaroni5935
    @dianescaroni5935 Місяць тому

    Hi I am trying to follow you but I am useing excel can you help me please

    • @CraftedSweetly
      @CraftedSweetly  Місяць тому

      I haven't done a tutorial for excel so I'm not sure of process, thought I think it might be similar. I now have an app fotobookart.com where you can create patterns in less than 30 seconds. Unlimited patterns a month for $4.99.

  • @monicabarbarotta1169
    @monicabarbarotta1169 2 роки тому

    Ma il programma originale per questi schemi come si chiama?

    • @CraftedSweetly
      @CraftedSweetly  2 роки тому

      I'm not sure what the Original program is called. I know you can also use Orimoto to print the patterns for the photo book art.

  • @nathaliebelledent6198
    @nathaliebelledent6198 Рік тому

    Bonjour . Pourriez vous m expliquer comment créer un tuto avec un livre dans l horizontal pour une photo prise à l horizontale? Merci d avance

    • @CraftedSweetly
      @CraftedSweetly  Рік тому +1

      Same process. Just rotate the image 90 degrees before you insert into the spreadsheet.

  • @bhavana1953
    @bhavana1953 4 місяці тому

    Why do you have an odd number on Stripe?

    • @CraftedSweetly
      @CraftedSweetly  4 місяці тому

      Because that's the page number on the right side.

  • @bba.by.marilyn
    @bba.by.marilyn 4 місяці тому

    Do you still use double sided tape ? This video is from 2 years ago.

  • @nancylemiesz3742
    @nancylemiesz3742 2 роки тому

    Can this be done in Google sheets?

    • @CraftedSweetly
      @CraftedSweetly  2 роки тому +1

      Yes! Would you like me to put together a video for it?

    • @nancylemiesz3742
      @nancylemiesz3742 2 роки тому

      @@CraftedSweetly yes that would be so kind of you!

  • @crazydiva4131
    @crazydiva4131 2 роки тому

    OK I got your program. Now my new question is lol...... how do I get my height 9 inches please

    • @CraftedSweetly
      @CraftedSweetly  2 роки тому

      Glad you figure out the other things - sorry I missed your other questions. To make it 9" edit the photo size by right clicking on the photo and set height to 9". You'll have to make sure the margins to the page are set to 0.25" for top and bottom otherwise it won't fit. As is it might be tight. you might need to print on an 11x14" page. Alternately, you can print it 8 or 8.5" and add a ribbon at the bottom or some type of border. Hope that helps!

  • @nancygibson1905
    @nancygibson1905 4 місяці тому

    Why is only one side of page taped

    • @CraftedSweetly
      @CraftedSweetly  4 місяці тому +1

      It's not necessary to tape the other side.

  • @karenobrn96
    @karenobrn96 2 місяці тому

    My confusion is.... If you have 143 leaves and only need 143 "strips", why do you have 286 columns? isn't each column a strip?

    • @CraftedSweetly
      @CraftedSweetly  2 місяці тому +1

      Each strip is 1 column and I have 143 columns. They''re numbered with odd numbers only, so it's looks like 286 columns, but it's actually just 143, since even numbers are skipped.

    • @laurasanchez2389
      @laurasanchez2389 2 місяці тому +1

      I think she does that to know exactly in what page she is going to apply each strip. She inputs a formula which adds 1 to previous number. Then she only uses 143 columns, not 286. The number at the top of the column is a mark to apply the strip, not a consecutive number.

    • @karenobrn96
      @karenobrn96 2 місяці тому

      @@CraftedSweetly Yes, I can see that the columns are only numbered with odd numbers (skipping the evens-which make total sense.) Your video shows 286 columns with only odd numbers... which to me means 286 columns vs 143, one for each for each leaf/page. Thanks for all your video and answering my silly question. I'm going to give it a shot. 😊

    • @CraftedSweetly
      @CraftedSweetly  2 місяці тому +2

      @@karenobrn96 I now have an app - fotobookart.com where you can create the pattern in less than 30 seconds. It's $1.99 for a patter and you get the option to print as an ink saver version.

    • @karenobrn96
      @karenobrn96 2 місяці тому

      @@CraftedSweetly Thank you! I'll check it out. It all makes sense now that I'm 1/2 way through my 1st trial. Thank you for all your help

  • @crazydiva4131
    @crazydiva4131 2 роки тому

    I need help :(

    • @CraftedSweetly
      @CraftedSweetly  2 роки тому

      With?

    • @crazydiva4131
      @crazydiva4131 2 роки тому

      @@CraftedSweetly when iput the height to 9". It looks way to long . It was saying i was going to piint 300 and something page lol

  • @crazydiva4131
    @crazydiva4131 2 роки тому

    im about to stop trying to figure it out and just do another craft

    • @CraftedSweetly
      @CraftedSweetly  2 роки тому

      Have you joined my FB group? There are a lot of members who can help and answer questions when I'm not available. . What is still the issue?

    • @crazydiva4131
      @crazydiva4131 2 роки тому

      @@CraftedSweetly What fb group is that. yes still having both of the issues

    • @girlie4826
      @girlie4826 2 роки тому

      This is beautiful! Question? Do you not tape both sides of the page?

    • @CraftedSweetly
      @CraftedSweetly  2 роки тому

      Thank you! No, just top and bottom on one side

    • @girlie4826
      @girlie4826 2 роки тому +1

      @@CraftedSweetly thank you