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.
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.
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 :)
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.
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!
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!
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
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 TH-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!
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!
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
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
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
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
@@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
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!
@@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.
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!!!!
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.
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
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
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 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!❤
@CraftedSweetly You know... I think it popped up as a project in a new group I just joined, or as I was watching TH-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!🎉🎉🎉❤💯🎯🏆😃
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.
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
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
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
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.
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
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!
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 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
@@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.
@@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
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.
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….
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 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.
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!
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.
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.
@@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. ;)
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
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
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
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"
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 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
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?
@@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!
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
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.
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.
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.
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.
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.
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.
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
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.
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.
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.
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 :(
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.
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
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!
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.
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.
@@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. 😊
@@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.
![เป็นไปได้ไหม - WanMai [Teaser] | 05-12-24](http://i.ytimg.com/vi/P5Uto6e453w/mqdefault.jpg)
I just discovered this art, and your instructions are excellent, thank you! Beautiful version of book folding.
Thank you so much!
You are an excellent teacher! Thank you!
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.
Thank you very much!
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.
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 :)
Wow your amazing
Thank you for an amazing video, such a clever technique and described very clearly.
Ich falte schon lange Bücher aber auf die Idee bin ich nicht gekommen .Super schön
Thanks a lot for your process description, Is so useful and simple. GBU🙏❤️
Thank you!
Great tutorial! Thank you!
Glad it was helpful! Thank you
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.
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.
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!
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!
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
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 TH-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!
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!
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
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.
@@CraftedSweetly someone made me a pattern already I am going to give it a shot I didn't know you make patterns to sell
I don't really make them to sell. I can help out with one at no charge when I have time
@@CraftedSweetly please make me one so I can give it a try please
@@CraftedSweetlybjr serait il possible d avoir un modèle pour pouvoir tester? très beau merci à vous
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
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.
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
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
@@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
Thanks. Greetz from Holland.
Awesome! Thank you!
How did you come up with the measurement 71.5inch, I cant figure it out. Can you please help me thanks in advance
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!
@@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.
@@mostajohn Correct. I just said multiply by 0.5" so that you know why I was "dividing by 2 again.
@@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.
@@mostajohn That's awesome! Thank you so much! Happy Folding!
The program you are using is Libre office. Can you please tell me what version. :)
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!!!!
Thank you Laura. The scoring board is called Scor-pal - here is the link: amzn.to/35QjGCk.
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.
I'm trying to figure it out. As soon as I do, I'll be sure to post a video
@craftedsweetly
You mention that you have a video showing have you wrap a book. Could you post which video that is please?
Sure. Here it is: th-cam.com/video/twdu1Jkc3Ho/w-d-xo.html
@@CraftedSweetly thank you
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
Happy to share! :) I've never actually timed it because I never finish them in one sitting. Guessing around 4-5 hours.
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.
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
@@CraftedSweetly Can this part be done in excel as well as the program you used?
where can you purchase the book stand
It's in my etsy shop Crafted Sweetly. Link is in the description box of the video.
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!
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!!!
Btw, this video is going my viral over the last couple of days. How did you hear about my video?
@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!❤
@CraftedSweetly You know... I think it popped up as a project in a new group I just joined, or as I was watching TH-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!🎉🎉🎉❤💯🎯🏆😃
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
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.
which paper cutter are you using? does the cutter have a light? thank you than you
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
Can you show how you get the borders please
In the toolbar, there's a button that is for borders. Click on that and it will put a border around the cell.
So, the other side of the page strip is not taped?
Correct
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
Thank you so much. Certainly. Here's one that's about 7cm. th-cam.com/video/q4ssY0F7Zlc/w-d-xo.html
if you put the doulble sided tape in the same place all the time does this not make the book thicker in that area?
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
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
With a Mac you can use Google sheets. Or, I know have an app that will create the pattern for you. Fotobookart.com
Is it better to use new books opposed to old books?
It doesn't matter as long as the used books are in good condition and not falling apart
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
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.
I’m thinking of so many possibilities for gifts, How much you charge for a book
I haven't made any for sale yet, but probably around $50-$75 depending on number of pages.
Hi, if Crafted Sweetly is unable to create one for you, let me know. I can help.
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
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!
@@CraftedSweetly oh lovely will have a look tomorrow. I will do my best and let you know how I get on 💖
What gsm paper is best to use? Photo paper cracks if you fold it.
I use 75-90 gsm glossy paper or just regular copy paper.
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
If you have 286 pages in your book, the image width should be 71.5 inches
@@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
@@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.
@@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
My pleasure! Happy to help
Hi, is there a minimum number of pages a book needs to be to be used?
Depends on the image. I’ve done some books with 150 pages, but most images require over 300 and 400 pages
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!
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.
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?
It can. If the image is not high resolution, that’s how the final book will look too. Should be sharp
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….
The image is stretched and you don’t lose any of it. Turns out perfect
could you explain how to do a lenticular pattern?
I'm working on a tutorial - hopefully in the near future. Thank you.
Hi, do you only use the double sided tape on one side of the page? not the other side too?
Yes. I just put tape on one side.
What kind of paper you use to print?
28# paper amzn.to/43cRH96
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?
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
@@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.
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!
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.
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.
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...
Not yet. I know the kind you're talking about. I'll have to figure it out. :)
I have but it is rather complicated and takes multiple programs.
@@lauratoma If you don't mind me asking, which programs were you using?
@@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. ;)
Yes i supposed It Is really complicate
What is the best paper to use? I have ab ink jet hp printer.❤
I use 28# copy paper. It's a little heavier and find it easier to fold. amzn.to/3FTlJ70
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
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
I’m scoring on backside not on image didn’t know if my printer was the issue
I would try another type of paper
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!
sure - it's fotobookart.com - it's a web based app. If you have any questions using it, please let me know.
I am still having issues getting the lines on the columns to show up.
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.
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
i cant get my numbers to follow across. i am using Excel and Libre but nothing is working for me
What do you mean to follow across?
what was the other program you had said? I can't make it out.
I use Libre Office. It's very similar to Excel.
@@CraftedSweetly which version is it, plz
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"
See FB post
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?
The 0.25 are the margins. Go to page layout and set page margins to 0.25 on all sides
@@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
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?
@@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!
@@kpopstan5 Is your book 9.5" high? You would need to use paper that's 11x14.
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
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.
Are you only glueing on one side?
Yes. Haven't had any issues
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?
You likely have "keep ratio" box checked.
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.
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.
@@CraftedSweetly Thank you so much!
My pleasure
What paper is best to use for this process
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.
@@CraftedSweetly thank you Looking forward to trying this method
Bonjour j'ai pas compris votre tuto avec Exel sera-t-il possible de me ré expliqué svp ? merci beaucoup
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.
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
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.
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
ciao grazie per il video volevo chiederti ma la carta delle strisce e un foglio da A4 grazie
I'm not sure I understand the question. I printed the image on a regular sized piece of paper 8.5"x11"
I am just little confused how much pages book would be good to get pic that has 4 pic
It's the same as if it's one photo. The 4 photos are smaller. Mine was 345 pages I think.
Hi I am trying to follow you but I am useing excel can you help me please
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.
Sorry I can’t see what you do to make the borders please
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.
I use Excel, but when i print, I can get numbers on top, but not on the bottom
Copy the top row and paste at the bottom.
Can this be done in Google sheets?
Yes! Would you like me to put together a video for it?
@@CraftedSweetly yes that would be so kind of you!
Can I have a link please
Do you still use double sided tape ? This video is from 2 years ago.
Yes
for some reason in the program ur using is what i got and it doesnt pull the picture either
What do you mean it doesn't pull the picture
@@CraftedSweetly no i dont see the picture. I get the image/
Ok, every time I highlight it to make it 0.5 , half an inch, the top numbers disappear. Help plz
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.
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 :(
Why do you have an odd number on Stripe?
Because that's the page number on the right side.
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
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.
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
Same process. Just rotate the image 90 degrees before you insert into the spreadsheet.
Ma il programma originale per questi schemi come si chiama?
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.
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
You have to enter =A1+2. Then copy that cell and paste in as many columns as you need. Hope that makes sense.
OK I got your program. Now my new question is lol...... how do I get my height 9 inches please
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!
Why is only one side of page taped
It's not necessary to tape the other side.
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?
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.
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.
@@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. 😊
@@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.
@@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
I need help :(
With?
@@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
im about to stop trying to figure it out and just do another craft
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?
@@CraftedSweetly What fb group is that. yes still having both of the issues
This is beautiful! Question? Do you not tape both sides of the page?
Thank you! No, just top and bottom on one side
@@CraftedSweetly thank you