The quota on how much data can be stored in a spreadsheet was more of a problem than I expected so I've done some things to work around it. Originally, every hour minute update would add at least 7 new cells, now it takes 15000 hour for the same operations to use up a cell. The cell limit per spreadsheet is 2m and I'm trying to delay building up to that as much as I can in each group of data.
Automatic name change detection is working fine, I've just been working on some of the lowest level functions to make it possible to manually make changes to the data through a UI.
I've also got something working that gets the membership status of every member in the clan based on the clan list info pages.
Handling name changes is at the core of everything, so I need to get a few low level lookup functions working first, and these are a bit of a headache.
I've got the foundation stuff done that handles data storage/lookup/editing but it's kinda messy to deal with. I found some things out about another data storage option and another method to look up externdal data recently that I'm experimenting with that could be very helpful. I'm back in uni so that'll take more of my time but my compsci courses might teach me something that will make the stuff I've done so far less messy.
I could try to be less ambitious and complete just what tools admins are after rather than make an ultimate all-in-one tool I originally sought out to do. That would get the highly requested features done faster and leave more complicated and resource intensive stuff for another time. This would mean not storing entire clan hiscores data which should be fine since runeclan already does that.
Still experimenting for now. Later, I'll sort out requested features by complexity and usefulness and see what direction it'll take after that.
