The latest ZXDB update will be applied this evening at 1800 BST. The update takes around 30 minutes, and the site goes down whilst this happens.

Excel sprite editor

Share graphical tips, notes and queries related to our favourite screen layout and its editors.
Post Reply
User avatar
Turtle_Quality
Manic Miner
Posts: 508
Joined: Fri Dec 07, 2018 10:19 pm

Excel sprite editor

Post by Turtle_Quality »

Hello, I'd been using this Excel spreadsheet for a while to edit graphics as zeros and 1s and create DEFB commands I could copy into an assembler. I quite like that Excel allows you easily to drag a row of values across columns, or columns across rows to quickly paint a graphic

Today I worked out how to use iterative formulas to allow animation of the graphics designed here, there some brief instructions on the Animate Tests sheet. Each time a cell is updated, the counter in A1 increases by 500 and the animation skips forward to the next frame. It's not very polished but easily adapted for further use

https://drive.google.com/file/d/1jDILmC ... sp=sharing
Definition of loop : see loop
User avatar
Turtle_Quality
Manic Miner
Posts: 508
Joined: Fri Dec 07, 2018 10:19 pm

Re: Excel sprite editor

Post by Turtle_Quality »

https://drive.google.com/file/d/1jDILmC ... sp=sharing

Maybe adding a link will work better
Definition of loop : see loop
User avatar
Einar Saukas
Bugaboo
Posts: 3190
Joined: Wed Nov 15, 2017 2:48 pm

Re: Excel sprite editor

Post by Einar Saukas »

You are not using the proper sharing options. Try setting it to "anyone with the link can view this spreadsheet".
User avatar
Turtle_Quality
Manic Miner
Posts: 508
Joined: Fri Dec 07, 2018 10:19 pm

Re: Excel sprite editor

Post by Turtle_Quality »

Thanks, done.

Probably stating the obvious, but you need to download it and open with Excel, it's not going to work in Google Drive
Definition of loop : see loop
Post Reply