I’m keeping most of my documents on my google drive. Any clever tricks for keeping track of clocks in a way that can be saved to the drive? Google’s drawing function is horrendously limited in this regard
I’m keeping most of my documents on my google drive.
I’m keeping most of my documents on my google drive.
You could just list it like “Dimmers Know It Was You: 4/6”
I use a Google Sheet with color coded clocks. Each cell is a tick, faded colors for empty, bright color for filled. If I need to record an opposing clock, it’s easy to set that up the same way. It’s not perfect and it doesn’t look like a clock, but it works.
Yeah, if you’re prepared to lose the clock look it’s no problem. Alternatives? How about tally marks, and strike through when they’re done? Hard to show unfilled sections. Use of windings to show open and filled segments?
I love how Andrew just hinted at a full-fledged mystic-horror plot-line by answering a technical question.
Want to make a character sheet out of wingdings now…
You can use the REPT function to turn a number into a repeated string; I’ve used this in the past to create a sort of lame, horizontal bar chart for a column of numbers.
Excel, pie chart linked to a pair of columns with current and total ticks? As you increase the integer in the current column, the linked pie chart will be proportionally more filled with that color. Effectively, a ticking clock.
I don’t know if google tables has the same functionality.
There are online tools to display pie charts, just use 1 colour –https://www.meta-chart.com/pie
meta-chart.com – Create a Pie Chart, Free . Customize, download and easily share. Just enter the amounts, pick some colors/fonts, and we’ll take it from there!
Cunning. Also:
“Open Google Docs and open your spreadsheet. Select the cells containing the pie chart data. 2. Click the “Insert” menu and then click “Chart…” to open the Chart Editor window.”
Hey, there’s one to make gauges. Neat! Although the use of labels on the gauges is iffy, it does work to make a neat clock that you can update by changing the number.
Yet another alternative: find or make some groovy steampunk clocks with the right number of numbers, give them clear filenames and just stick them in a folder.