Book Art - DIY Tutorial to create your pattern with any image for photo strip book art
Рет қаралды 51,769
2 жыл бұрын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: kzfaq.infomzTsjR_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
@sheilapoole7557 Жыл бұрын
Thank you for an amazing video, such a clever technique and described very clearly.
@bridgetrivard8884 3 ай бұрын
You are an excellent teacher! Thank you!
@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 Жыл бұрын
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 :)
@danad9879 2 жыл бұрын
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.
@CraftedSweetly 2 жыл бұрын
Thank you very much!
@leonaklassen6230 4 ай бұрын
I just discovered this art, and your instructions are excellent, thank you! Beautiful version of book folding.
@CraftedSweetly 4 ай бұрын
Thank you so much!
@bluka 4 ай бұрын
Thanks a lot for your process description, Is so useful and simple. GBU🙏❤️
@lenamccoy1294 9 ай бұрын
Great tutorial! Thank you!
@CraftedSweetly 9 ай бұрын
Glad it was helpful! Thank you
@craftingbysharon9869 Жыл бұрын
Thank you!
@greetjenijdam 2 жыл бұрын
Thanks. Greetz from Holland.
@CraftedSweetly 2 жыл бұрын
Awesome! Thank you!
@SP-vj8or 7 ай бұрын
Ich falte schon lange Bücher aber auf die Idee bin ich nicht gekommen .Super schön
@suzichoclatcrafts 2 жыл бұрын
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 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 2 жыл бұрын
@@CraftedSweetly oh lovely will have a look tomorrow. I will do my best and let you know how I get on 💖
@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 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 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 2 жыл бұрын
I don't really make them to sell. I can help out with one at no charge when I have time
@junedavis4631 2 жыл бұрын
@@CraftedSweetly please make me one so I can give it a try please
@annepot9707 Жыл бұрын
@@CraftedSweetlybjr serait il possible d avoir un modèle pour pouvoir tester? très beau merci à vous
@crazydiva4131 2 жыл бұрын
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.
@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 2 жыл бұрын
Thank you Laura. The scoring board is called Scor-pal - here is the link: amzn.to/35QjGCk.
@crazydiva4131 2 жыл бұрын
The program you are using is Libre office. Can you please tell me what version. :)
@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 Жыл бұрын
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
@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 2 жыл бұрын
Happy to share! :) I've never actually timed it because I never finish them in one sitting. Guessing around 4-5 hours.
@gerrypetocz6212 2 жыл бұрын
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 2 жыл бұрын
I'm trying to figure it out. As soon as I do, I'll be sure to post a video
@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 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 Жыл бұрын
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 Жыл бұрын
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!
@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 3 ай бұрын
It can. If the image is not high resolution, that’s how the final book will look too. Should be sharp
@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 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 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
@FoldedWords Жыл бұрын
which paper cutter are you using? does the cutter have a light? thank you than you
@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
@usyungs 2 жыл бұрын
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 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 Ай бұрын
@@CraftedSweetly Can this part be done in excel as well as the program you used?
@kevinfoster2934 2 жыл бұрын
What gsm paper is best to use? Photo paper cracks if you fold it.
@CraftedSweetly 2 жыл бұрын
I use 75-90 gsm glossy paper or just regular copy paper.
@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 Жыл бұрын
With a Mac you can use Google sheets. Or, I know have an app that will create the pattern for you. Fotobookart.com
@borntoblag Жыл бұрын
Hi, do you only use the double sided tape on one side of the page? not the other side too?
@CraftedSweetly Жыл бұрын
Yes. I just put tape on one side.
@shelleyhozalski9437 23 күн бұрын
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 KZfaq. 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 23 күн бұрын
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!
@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 Жыл бұрын
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
@susanmeany9002 Жыл бұрын
@craftedsweetly You mention that you have a video showing have you wrap a book. Could you post which video that is please?
@CraftedSweetly Жыл бұрын
Sure. Here it is: kzfaq.info/get/bejne/qt2UqJR70MmXeKM.html
@susanmeany9002 Жыл бұрын
@@CraftedSweetly thank you
@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 Жыл бұрын
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 Жыл бұрын
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.
@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 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 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.
@lillianpoppa7609 8 ай бұрын
What is the best paper to use? I have ab ink jet hp printer.❤
@CraftedSweetly 8 ай бұрын
I use 28# copy paper. It's a little heavier and find it easier to fold. amzn.to/3FTlJ70
@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 2 жыл бұрын
Not yet. I know the kind you're talking about. I'll have to figure it out. :)
@lauratoma 2 жыл бұрын
I have but it is rather complicated and takes multiple programs.
@CraftedSweetly 2 жыл бұрын
@@lauratoma If you don't mind me asking, which programs were you using?
@lauratoma 2 жыл бұрын
@@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 2 жыл бұрын
Yes i supposed It Is really complicate
@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 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 2 жыл бұрын
@@CraftedSweetly Thank you so much!
@CraftedSweetly 2 жыл бұрын
My pleasure
@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 9 ай бұрын
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.
@crazydiva4131 2 жыл бұрын
what was the other program you had said? I can't make it out.
@CraftedSweetly 2 жыл бұрын
I use Libre Office. It's very similar to Excel.
@crazydiva4131 2 жыл бұрын
@@CraftedSweetly which version is it, plz
@DawnAdams-wc1mb Жыл бұрын
where can you purchase the book stand
@CraftedSweetly Жыл бұрын
It's in my etsy shop Crafted Sweetly. Link is in the description box of the video.
@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 Жыл бұрын
Thank you so much. Certainly. Here's one that's about 7cm. kzfaq.info/get/bejne/p5qjprxhq52-nJc.html
@mostajohn 2 жыл бұрын
How did you come up with the measurement 71.5inch, I cant figure it out. Can you please help me thanks in advance
@CraftedSweetly 2 жыл бұрын
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 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 2 жыл бұрын
@@mostajohn Correct. I just said multiply by 0.5" so that you know why I was "dividing by 2 again.
@mostajohn 2 жыл бұрын
@@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 2 жыл бұрын
@@mostajohn That's awesome! Thank you so much! Happy Folding!
@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"
@CraftedSweetly 2 жыл бұрын
See FB post
@sins_disaster293 Ай бұрын
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 Ай бұрын
The image is stretched and you don’t lose any of it. Turns out perfect
@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
@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?
@CraftedSweetly Жыл бұрын
You likely have "keep ratio" box checked.
@annadipace9635 2 жыл бұрын
ciao grazie per il video volevo chiederti ma la carta delle strisce e un foglio da A4 grazie
@CraftedSweetly 2 жыл бұрын
I'm not sure I understand the question. I printed the image on a regular sized piece of paper 8.5"x11"
@teresa-ux8db 4 ай бұрын
So, the other side of the page strip is not taped?
@CraftedSweetly 4 ай бұрын
Correct
@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 4 ай бұрын
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 4 ай бұрын
Btw, this video is going my viral over the last couple of days. How did you hear about my video?
@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 4 ай бұрын
@CraftedSweetly You know... I think it popped up as a project in a new group I just joined, or as I was watching KZfaq 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!🎉🎉🎉❤💯🎯🏆😃
@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 4 ай бұрын
sure - it's fotobookart.com - it's a web based app. If you have any questions using it, please let me know.
@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 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.
@emilyforever831026 2 ай бұрын
Hi, is there a minimum number of pages a book needs to be to be used?
@CraftedSweetly 2 ай бұрын
Depends on the image. I’ve done some books with 150 pages, but most images require over 300 and 400 pages
@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 Жыл бұрын
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 Жыл бұрын
I’m scoring on backside not on image didn’t know if my printer was the issue
@CraftedSweetly Жыл бұрын
I would try another type of paper
@michelemazzolino5040 2 жыл бұрын
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 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.
@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 Жыл бұрын
If you have 286 pages in your book, the image width should be 71.5 inches
@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 Жыл бұрын
@@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 Жыл бұрын
@@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 Жыл бұрын
My pleasure! Happy to help
@imtiazhemani 2 жыл бұрын
I am just little confused how much pages book would be good to get pic that has 4 pic
@CraftedSweetly 2 жыл бұрын
It's the same as if it's one photo. The 4 photos are smaller. Mine was 345 pages I think.
@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 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.
@janetcampbell3243 Жыл бұрын
i cant get my numbers to follow across. i am using Excel and Libre but nothing is working for me
@CraftedSweetly Жыл бұрын
What do you mean to follow across?
@bubuz1976 Жыл бұрын
could you explain how to do a lenticular pattern?
@CraftedSweetly Жыл бұрын
I'm working on a tutorial - hopefully in the near future. Thank you.
@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 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.
@bhavana1953 4 ай бұрын
What kind of paper you use to print?
@CraftedSweetly 4 ай бұрын
28# paper amzn.to/43cRH96
@buddysmith7080 Ай бұрын
Is it better to use new books opposed to old books?
@CraftedSweetly Ай бұрын
It doesn't matter as long as the used books are in good condition and not falling apart
@yvettereynolds5945 2 жыл бұрын
I’m thinking of so many possibilities for gifts, How much you charge for a book
@CraftedSweetly 2 жыл бұрын
I haven't made any for sale yet, but probably around $50-$75 depending on number of pages.
@stephierobeson5451 2 жыл бұрын
Hi, if Crafted Sweetly is unable to create one for you, let me know. I can help.
@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 2 жыл бұрын
The 0.25 are the margins. Go to page layout and set page margins to 0.25 on all sides
@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 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 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 2 жыл бұрын
@@kpopstan5 Is your book 9.5" high? You would need to use paper that's 11x14.
@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 2 жыл бұрын
You have to enter =A1+2. Then copy that cell and paste in as many columns as you need. Hope that makes sense.
@theresakelly6658 10 ай бұрын
I am still having issues getting the lines on the columns to show up.
@CraftedSweetly 10 ай бұрын
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.
@jillmiller7864 Жыл бұрын
Are you only glueing on one side?
@CraftedSweetly Жыл бұрын
Yes. Haven't had any issues
@dianescaroni5935 21 күн бұрын
Can you show how you get the borders please
@CraftedSweetly 18 күн бұрын
In the toolbar, there's a button that is for borders. Click on that and it will put a border around the cell.
@crazydiva4131 2 жыл бұрын
Ok, every time I highlight it to make it 0.5 , half an inch, the top numbers disappear. Help plz
@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 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 :(
@monicabarbarotta1169 2 жыл бұрын
Ma il programma originale per questi schemi come si chiama?
@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.
@carolpurdue8706 2 жыл бұрын
What paper is best to use for this process
@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 2 жыл бұрын
@@CraftedSweetly thank you Looking forward to trying this method
@crazydiva4131 2 жыл бұрын
for some reason in the program ur using is what i got and it doesnt pull the picture either
@CraftedSweetly 2 жыл бұрын
What do you mean it doesn't pull the picture
@crazydiva4131 2 жыл бұрын
@@CraftedSweetly no i dont see the picture. I get the image/
@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 Жыл бұрын
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 Жыл бұрын
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
@user-sl9sj8jm7r Жыл бұрын
Bonjour j'ai pas compris votre tuto avec Exel sera-t-il possible de me ré expliqué svp ? merci beaucoup
@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.
@nancylemiesz3742 2 жыл бұрын
Can this be done in Google sheets?
@CraftedSweetly 2 жыл бұрын
Yes! Would you like me to put together a video for it?
@nancylemiesz3742 2 жыл бұрын
@@CraftedSweetly yes that would be so kind of you!
@bhavana1953 4 ай бұрын
I use Excel, but when i print, I can get numbers on top, but not on the bottom
@CraftedSweetly 4 ай бұрын
Copy the top row and paste at the bottom.
@dianescaroni5935 Ай бұрын
Hi I am trying to follow you but I am useing excel can you help me please
@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.
@bba.by.marilyn 4 ай бұрын
Do you still use double sided tape ? This video is from 2 years ago.
@CraftedSweetly 4 ай бұрын
Yes
@dianescaroni5935 26 күн бұрын
Sorry I can’t see what you do to make the borders please
@CraftedSweetly 26 күн бұрын
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.
@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 Жыл бұрын
Same process. Just rotate the image 90 degrees before you insert into the spreadsheet.
@crazydiva4131 2 жыл бұрын
OK I got your program. Now my new question is lol...... how do I get my height 9 inches please
@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!
@bhavana1953 4 ай бұрын
Why do you have an odd number on Stripe?
@CraftedSweetly 4 ай бұрын
Because that's the page number on the right side.
@nancygibson1905 4 ай бұрын
Why is only one side of page taped
@CraftedSweetly 4 ай бұрын
It's not necessary to tape the other side.
@crazydiva4131 2 жыл бұрын
I need help :(
@CraftedSweetly 2 жыл бұрын
With?
@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
@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 2 ай бұрын
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 2 ай бұрын
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 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 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 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 2 жыл бұрын
im about to stop trying to figure it out and just do another craft
@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 2 жыл бұрын
@@CraftedSweetly What fb group is that. yes still having both of the issues
@girlie4826 2 жыл бұрын
This is beautiful! Question? Do you not tape both sides of the page?
@CraftedSweetly 2 жыл бұрын
Thank you! No, just top and bottom on one side
@girlie4826 2 жыл бұрын
@@CraftedSweetly thank you
Crafted Sweetly
Рет қаралды 1,9 М.
Crafted Sweetly
Рет қаралды 15 М.
Crafted Sweetly
Рет қаралды 3,4 М.
BrightSide Studio
Рет қаралды 1,5 М.
Crafted Sweetly
Рет қаралды 6 М.
Amazing Children Toys
Рет қаралды 11 МЛН
Ăn Vặt Tuổi Thơ 2024
Рет қаралды 4,2 МЛН