Arbitrary plurality resources post for the year
I noticed that a lot of the 'system tracking' resources out there focus heavily on "who's fronting and for how long in a day" rather than "who's generally active in a day". It's seriously been bugging me, especially since non-fronting and rarely-fronting system members are an established plurality experience! So after looking at other people's recommendations of the former for the umpteenth time, in my frustration, I just started looking through clerical apps on my phone for something, anything that could potentially be repurposed for system tracking.
Low and behold, ICloud Numbers has a handy-dandy auto-graphing feature, as well as an easy-to-use checkbox feature. Salvation at last! So in case anyone else might be in similar straits, I decided to make this post about it to show the set-up I drafted up.
Theoretically, other spreadsheet software could do something similar, or one could finagle it via a mishmash of methods. There might even be dedicated graphing software out there too, for all I know. (I didn't really research it. This one worked for me, after all. xP) So feel free to use whatever works best for you, if you make your own.
Also, a quick note: I'm unsure of how well this would work for a larger system. If any folks interested in this for larger systems are reading, this is your fair warning that this might not be best suited to you. But please, feel free to read through anyways and see if I'm wrong, or if you can find a way to adapt anything here to your needs!
Anyways, that said, screenshots and explanations of things:
The blank template version of the spreadsheet, because it's so much easier to just copy and paste this than create a whole new spreadsheet page every time.
Going in order of the features...
First off, the color scheme and layout. You can change the colors of the cell backgrounds, all of the text, any shapes you add (like lines), and the page background to any color you like. You can also position elements pretty much anywhere on the sheet that you like. (Personally, I like to keep the spreadsheet in the upper-left because it's faster to access when it's the default loading position of a page.)
Next, the title text elements. Honestly? You don't really need to put anything there if you don't want to. It was just kind of there already with the basic 'school attendance sheet' template I started this from, so I kept it.
If you intend to set it up like I have it, though: “SysName” is for your system (or subsystem, or group of system members') name, though you could use your body name or a specific member's name or whatever-have-you, too.
“Any& can tick boxes at day's end” is a reminder or regulation thing, I guess? I intended it to remind headmates that the job didn't have to fall to just a specific person, and also to invite them to mark their own activity down if they'd like. If other systems have rules on who can and can't do what, though, then maybe it could be helpful to note that here?
The 'one asterisk for P.M.S., two asterisks for period' thing I added because it seemed like it might be useful to the systems that experience it, given hormones can affect mood, dealing with blood or pain can incur various negative reactions, it can involve sensory issues for those with sensory differences, people who don't track days passing very well might be helped by a record of their cycle, etc. For plurals who don't experience it, or who have other things that might be helpful to track like this, you could probably modulate or remove it from your own version?
“Attendance Sheet — Month 20[blank]” is a title to denote the purpose, as well as what month it's specifically for. If you create a different spreadsheet file (not page) for each year, though, you might not need to label the year on the sheets themselves? The file title could suffice in that case.
“Important life context” is to help give future-you context on what was going on in that month, as life happenings can affect who in your collective is active and when. You can pretty much put whatever you find useful here, but make sure to only limit it to what goes on within that month. (Happenings can still span over multiple months, though; just make sure to note it down on all months that it's applicable to.) Also, if you needed more than 3 bullet points for this, you could change the location of the text element to somewhere with more space.
The “Date” column is for every day in the month. I personally keep all 31 rows for dates on the spreadsheet, even in months with less than 31 days, as it's easier to just change the absent days to “N/A” than it is to adjust the spreadsheet template every month. As for the blank cell in the date column... I believe I had to separate it from the “Total” row beneath it due to it messing with something to do with the auto-graphing? But I honestly don't remember, so maybe try to combine that with the row below it in your version.
The “Total Active Per Day” column adds up the total number of checkmarks in the row that each cell inhabits. Thus, basically tallying how many people in the collective are active each day. I added this metric because I was curious about how many of the total member count were active at a given time, and if that fluctuated at different times of the year, or in different circumstances. It can also be a useful insight to how active the system is when life changes occur, like if your physical health is greater or lesser, if you're starting a new medication, etc., so you can see concrete information that doesn't rely on your own internal memory of time or events.
All the columns labeled “Headmate A” and “HM B through S” are for you to put headmate names, monikers, emojis, etc. in. If you don't know who someone is yet, but have evidence or a feeling that someone is there, you can also use temporary monikers such as “Unknown chores-person” or “Rando 1” or whatever works for you. Just make sure you keep their spot in the spreadsheet if you ever update their column header; that way your data stays more consistent and easier to track!
Also, just in general, I don't recommend messing with the places you put system members' columns, as that can make it more difficult to find who is where at a glance. If you need to add someone in the middle of the sheet, make sure to apply that change to your template sheet and your yearly summary!
As for why the headmate names recur in the middle of the spreadsheet's rows... I have trouble visually tracking what column is which when I can't see the headers, so splicing them into the middle of the month fixed that for me. If you don't need such a thing, you can feel free to remove it! It's not necessary for any of the cell coding.
Also related to the headmate columns is the “Max Days Integer” column. This is here specifically for graphing purposes, as things like the bar graphs like to auto-adjust to the highest number input into them, which can make them harder to read. This will have every day in that month checkmarked as to create a benchmark integer.
Lastly, the “Total” row is for tallying-up how many days out of the month that a single system member was active for. The cells are coded to add +1 for each checkmark in the column they inhabit – so make sure you don't accidentally check-off more boxes than there are days in that month!
This is a filled example of the monthly template! I tried to emulate believable patterns of activity, but I have no clue if I hit the mark, haha. Anyways, this should give you an example of how one of these looks like when used.
Also included in this example are example graphs! You can graph things however you find most useful, but I'll go over the ones I've used here. (Also, note that ICloud Numbers can't currently copy and paste graph templates, so you'll have to set them up anew every time you create a sheet. However, you can open the spreadsheet in two browser tabs at once and just copy and paste the various data-settings onto your new graphs, so long as you remember what cells you specifically linked them to, so that can help preserve uniformity at least.)
First off, the “Days Active” graph. This uses the data from the “Total” row to visually show you what each system member's activity was for that month. To create it, I selected only the cells in the columns labeled with headmates' names, not the whole row, as the blank space from the “Total Active Per Day” row might mess up the graph. (I don't remember specifically.) I also set the “major steps” to be “8”, a multiple of 40, so the data would be easier to read in relation to the days of the month. You can mess around with it and see what's easiest for you to comprehend, though!
Next, the “Total Active Per Day” graph. As you might be able to see by the empty “Date” and “N/A” entries, this reads the entire “Total Active Per Day” column from the spreadsheet and not just specific cells. This graph compares the numbers of total activity across all of the days in the month, and contrasts them against the total number of members in your collective (which you'd input in the cell that intersects the “HM-Total” row and “Total Active Per Day” column).
The T.A.P.D. graph has a major steps number of “10” and a minor steps number of “1”. I'd try to adjust the major steps number to be a multiple of your system's member count, as that way it should be easier to read.
Lastly, the “Activity Frequency” graph. This one also uses the “Total” row for set-up the same way the “Days Active” graph does, but for this one you exclude the Max Days Integer, as this graph is supposed to show you what percentage of the month one headmate was active for compared to the rest of the system. This one admittedly gets harder to read at smaller formatting sizes, as the thinner wedges lose and displace labels, but is also a pain if you make it too big on the page, especially when viewing from smaller screens.
As for the placement of the graphs, you can put them wherever you want on the sheet. I just put them below the spreadsheet, as I find it easier to scroll directly down than the full horizontal length of the spreadsheet.
(Also quick note regarding ICloud Numbers: as far as I know, graphs can only pull data from one spreadsheet at a time, and only from spreadsheets on the same page. So all of your system members will have to be put on the same sheet if you want them all to be on the same graph.)
Yearly Summary, Filled Example
And for our final page, we have the spreadsheet and graphs where you input all the data from the monthly spreadsheets to create a comprehensive, easy-to-review overview of the year. The formatting is pretty much the same as the monthly templates; you just reduce the date rows to '12' for labeling the 12 months in the year and fill the “Max Days Integer” column with the total number of days in each month for that calendar year. (Which means that you'll need to make sure to account for leap years!) Also, the guideline changes to 'adding numbers at the start of each month', and the title of the sheet changes to “Total Number of Active Days — 20[blank]”.
Basically, you update this spreadsheet every time you fill a full monthly spreadsheet. I find that doing it at the start of every new month is the easiest, since the idea of filling out the entire year at once seems too daunting, and this way I get to see the graphs update incrementally instead of having to wait a whole year. But you can do it in whatever way works best for you!
Also, you may notice that there's no “important life context” text element on this sheet. Personally, I think that reviewing that in each individual month would be more informative for me, but if you'd find it useful to have that here, then go for it!
The “Total Days Active” is set up the same as the “Days Active” from the monthly spreadsheets, just with 16 major steps instead of 8. It functions the same too; you're just seeing all of the single-month versions of this graph combined into one!
Again, the “Total Activity Frequency (Days)” graph is set up the same as the monthly version, and shows the combination of all of the single-month versions in its data. Pretty cool to see who was around the most and least in a year, in my opinion!
The “Monthly Activity (Individuals)” is specifically an “interactive graph”. This lets you flip through multiple data-sets while using a smaller amount of page space! To set it up like this, you want to create a cell-selection spanning your first headmate's “January” cell all the way to your last headmate's “December” cell, leaving out the “Max Days Integer” cells. The major steps is still set to 8 in this graph, as this graph compares one headmate's number of active days for each month in the year.
The “Total Active Per Month” graph is set up the same as it's monthly counterpart. The only thing is that you now have to do “the total number of members in your system” multiplied by “31” (that being the highest possible number of days in the month) in order to get the benchmark integer for “if every single member of your system was active every single day in a single month”.
This is probably something that would reach ridiculously high numbers for those with higher system counts – after all, it's already at “589” with this example count of “19”. So while it gives an interesting view of the data... it probably could be done in a less clunky way, lol.
And finally, this behemoth of a graph, another thing that probably doesn't work great at larger system counts, haha. You create this the same way as the “Monthly Activity (Individuals)” graph, but including the “Total Active Per Day” and “Max Days Integer” columns as well. Also, the major steps for this graph are 20, not 8. This graph basically lets you see the same data as the 'Individuals' version, but all at once, and with the ability to compare a single headmate's activity against the collective headmate activity for each month.
You could probably get away with using the 'Individuals' version alone if you wanted to; I just personally find it fun to be able to see them all at once.
...Also, evidently there's a column header typo of “Total Active Per Day” rather than “Total Active Per Month” on this spreadsheet that affects its entry on this graph. Oops!
And that's a wrap! A very... lengthy... wrap... Lol.
Anyways, for 5 quick additional notes:
1: In hindsight, there should probably be a checkbox column for “Too unclear to tell” or “Bad communication”, as that in and of itself would be valuable data to track. So that could be appended to the start or end of the spreadsheet, perhaps?
2: You can put comments on individual cells in the spreadsheet. So if you want to put more nuanced detail on why or what system members were doing in a day, or note down on a 'date' cell what events were transpiring that day, then that's a thing you could do! Or if you wanted to use it to track plans you have for the month, you could also do that, in theory, though I'm not sure how useful that'd be given that comments aren't immediately visible like the cells' data is.
3: You can password-protect spreadsheet files in ICloud Numbers. It gives you the option to set unique passwords for each file, doesn't stop you from using the same password on multiple files, and has the option to set password hints if you need them. So if you'd find that helpful and not a hindrance, then that's an option!
4: I also drafted a version of this set-up to have two spreadsheets in a single month: one for 'active'-presence and one for 'passive'-presence. I did this while I was trying to combine a fronting-tracker with an activity-tracker, as fronting-trackers do still have their merits.
If you want to set something like that up, you basically have to duplicate everything on the monthly sheets to another section of a single month's sheet (or make a separate page for the same month if you want), and then either duplicate the contents of the yearly summary on the same page (not recommended; it gets long) or split the data up into 2 separate pages.
5: Aside from that, writers and character-creators who want to make super-intricate histories for their plural characters could probably adapt this to their purposes too. You'd just have to adjust the calendar to whatever calendar your setting uses, and anything else to whatever would be more useful for fictional purposes.
And that's it! Happy spreadsheeting, y'all!
