Commodore 64 Creating sprites using Excel

[@CyberhugTechnologies]

That is so cool and smart! I remember myself using tons of papers as a kid, drawing by hand to make something out of it! Great video and idea, thanks for sharing!

[@martinvolker2912]

Great video. I did the exact same thing about 15 years ago as I noticed that you can simply copy the text output to paste into my emulator back then. I’m also pretty sure the first sprite I drew was this particular space invader! Well done! 👾

[@mickehog76]

Really great idea :). Next step will be how you run ms Excel on C64 😛.

[@bengelman2600]

This is a great idea

[@KamiraXIV]

Tip: In cell AC7, instead of writing out that manual formula, you could instead use this easier one: =IFERROR(BIN2DEC(CONCAT(C3:J3)),0)

[@justforthefunofit]

Thank you, nice alternative 😁

[@OTuit]

Excel 2016 or later

[@igork3522]

Nice and useful video! Thank you.

[@jesusmmuguruza5837]

Just wanted to express how helpful your videos are!! you are extrely good at explaining tNice tutorialngs in-depth but still at a basic level for

[@TheUtuber999]

Cool idea, but my go-to sprite editor is SPRDEF using Vice in C-128 mode. Make your edits to sprite #1 and then use the following two lines to output the numbers for data statements. Requires a bit of editing, but doesn't take much time for 63 bytes of data... 10 forx=0to62:a$=str$(peek(3584+x)) 20 printright$(a$,len(a$)-1)",";:next

[@justforthefunofit]

Thank you for this info, will certainly have a look at that.

[@OTuit]

If you want a clickable option for changing cells, copy this into the Worksheet code page and save as a macro enabled file. Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) 'Sprite Range D7:AA21 If Not Application.Intersect(Range("D7:AA21"), Target) Is Nothing Then Select Case Target Case 0 Target = 1 Case 1 Target = 0 End Select Cancel = True End If End Sub

[@justforthefunofit]

That's a nice addition and makes it even easier.

[@transistorbaluba]

lovely work. im just curious, is it possible to lay, say a, bmp drawing in the bg as a template for 1 and 0?

[@justforthefunofit]

Hi, What you can do is place an image over the cells in Excel. Not as a background, but just above the cells. You can then move with the cursor keys in the cells and set the "0" and "1" in the cells to 'copy' the above image. See a quick example here kzbin.info/www/bejne/eabEnYycarp9kMk

[@FunnyHaHa420]

Graph paper colored pencils and a lot of typing. That's how I did it.

[@justforthefunofit]

True, thats all we had, and lots of time 😆

[@smittiesprojects1631]

I like the video, thanks. I tried to download the Excel sheet, but the link doesn't work for me.

[@justforthefunofit]

Hi, try this direct link, maybe that works for you. (or check if a pop-up blocker is preventing to start the download). justforthefunofit.nl/files/Commodore-64-Sprite-Excel-Template.zip

[@smittiesprojects1631]

@@justforthefunofit Thank you, that worked!

[@byronkstout]

@@justforthefunofit Is this still available? I'm not able to get to the file.

[@justforthefunofit]

@@byronkstout Thank you for bringing this to my attention. I created a new site and the file was therefore also removed from it’s original location. Forgot to change the link here. You can now find it here github.com/justforthefunofit/create-sprites-using-excel

[@deepace]

lol look at tNice tutorials dude

[@martinvolker2912]

Great video. I did the exact same thing about 15 years ago as I noticed that you can simply copy the text output to paste into my emulator back then. I’m also pretty sure the first sprite I drew was this particular space invader! Well done! 👾

[@justforthefunofit]

Thank you. It's nice to work in Basic on a Commodore every now and then, just like when I was a teenager, but with the knowledge of today. What if we knew then what we know now 😀