https://lug.mtu.edu/w/index.php?action=history&feed=atom&title=Minutes_2026-04-02 2026-04-04T01:09:07Z Revision history for this page on the wiki MediaWiki 1.39.10 https://lug.mtu.edu/w/index.php?title=Minutes_2026-04-02&diff=8092&oldid=prev 2026-04-03T00:03:07Z

<p>Created page with &quot;Casey presenting an STL viewer in Google Sheets *Not made for any particular reason *Works pretty well *Only uses &quot;vanilla&quot; Google Sheets *Can set resolution of points, rotations *Why It Was Made: **Casey did not know any languages outside of Gcode, Mcode, R, and Google Sheets **Came out of several experiments with Sheets in high school (barcode generator, data matrix generator, Animal Crossing flower breeding model) **Saw a video of a cube projection in Minecraft redsto...&quot;</p> <p><b>New page</b></p><div>Casey presenting an STL viewer in Google Sheets<br /> *Not made for any particular reason<br /> *Works pretty well<br /> *Only uses &quot;vanilla&quot; Google Sheets<br /> *Can set resolution of points, rotations<br /> *Why It Was Made:<br /> **Casey did not know any languages outside of Gcode, Mcode, R, and Google Sheets<br /> **Came out of several experiments with Sheets in high school (barcode generator, data matrix generator, Animal Crossing flower breeding model)<br /> **Saw a video of a cube projection in Minecraft redstone<br /> *How It&#039;s Made:<br /> **Initial version: rendered through layers of conditional formatting<br /> **Subsequent versions went towards using line graphs to load faster<br /> **Development went through phases, going through a lot of work and then being dropped for a while.<br /> **Switched to STL files for importing<br /> ***Older versions calculated normals, but it turns out those are provided in STL format<br /> **Limit of 100 series in Google Sheets for plots<br /> ***This means that for an 8000+ vertex model, it requires hundreds of plots, with backgrounds transparent, to render a whole model.<br /> ***Various versions of this type of spreadsheet are done<br /> ***Eventually Google came out with iterative calculations, allowing everything to be done in one series.<br /> ****Allowed smaller size functions using lambda expressions, as spreadsheet size was becoming a constraint<br /> *****This performed worse<br /> ***Switched to scatterplots<br /> ****Eliminates series limitations as there are no series<br /> ****Did hit cell limit, requiring a separate page<br /> ****Can adjust resolution of line rendering<br /> ****Renders considerably faster<br /> ****Calculates vertices and midpoints in separate sheets<br /> **Reinvented hashing accidentally to get a unique index for each vertex, to do indices<br /> **Modern version uses two layered scatterplots, uses the STL format</div>

Freya