Twitter | Search | |
Six Colors Jul 18
Chart party: Using automation to eliminate image drudgery
Reply Retweet Like
Matthew Cassinelli Jul 20
Replying to @bleedsixcolors @jsnell
Hey do you have the original photo to share? I think this can be done in Shortcuts
Reply Retweet Like
Jason Snell Jul 20
Replying to @mattcassinelli
sure, here’s the raw output from numbers on Mac:
Reply Retweet Like
Federico Viticci Jul 20
Yeah I’m afraid the Shortcuts actions can’t set high DPIs 😔 That said, this is the approach I’d use. Jason’s image appears to be using variable distances between charts (as exposed in the script), so I replicated the setup like this. Fun challenge. This is based on ‘theRows’.
Reply Retweet Like
Jason Snell Jul 20
so Numbers will export a PDF to iCloud Drive… I think from there I may be able to convert it all?
Reply Retweet Like
Federico Viticci Jul 20
So, basically: the logic to split the image in 32 charts is easy, but you have two main issues: converting from PDF and uploading to your server.
Reply Retweet Like
Jason Snell Jul 20
I think I’ve got it working! 🎉
Reply Retweet Like
Jason Snell Jul 20
Reply Retweet Like
Federico Viticci Jul 20
Yesssss well done 🎉
Reply Retweet Like
Matthew Cassinelli Jul 20
Replying to @juanisosa @jsnell and 3 others
I have a series of pieces coming for that will put the list of actions and descriptions on the web properly though
Reply Retweet Like
Jason Snell Jul 20
That's great, I look forward to that. A comprehensive document with every action and what it can do is something I've always wanted.
Reply Retweet Like
Mark Crump Jul 20
I assume the Repeat Item, and Repeat item 2 are the two list of numbers ahead of it, and each of those are the x & y coordinates?
Reply Retweet Like
Jason Snell Jul 20
The first list is x and the second list is y, and yes, it's a loop within a loop
Reply Retweet Like
Marc Bertrand Jul 21
Replying to @jsnell @viticci and 2 others
Fascinating exercise. Thanks for sharing! Would it have been easier if charts were on separate sheets? ie no need for manual x-y coordinates
Reply Retweet Like
Jason Snell Jul 21
Replying to @fourmind @viticci and 2 others
No, because the maintenance required in Numbers every time I updated the sheet would not be acceptable.
Reply Retweet Like