#then i realized i made the crop size on the portraits too small because dickson for some reason has a wider portrait than any other chara

[kadoodles-on-ao3]

This is truly turning out to be The Project Ever huh.

I've been working on it nearly every day for (checks document edit history) almost 2 months now and it's still not done somehow! But it's SO CLOSE to being done!!! I've finished testing all the voice lines and organizing them in the sheets and doing data entry and all that, I just need to finish renaming the copies of the audio files to the transcriptions of the dialogue, clean up my notes, and put in all the links to cells where they need to go (which is a step that has to be put last because of the crappy way putting links to cells work in google sheets I haaaate it so much why does it not support references of any kind) but then I'll be done!!

I swear this project (and an update to the collab fic too!!!!! I'm so sorry!!!!) will come out in this lifetime!

#aside #also after i did the day calculations and saw it has been only 54 days i legit just stared at my screen in silence for several full seconds #it feels like i've been working on this thing for my entire life dude #so much work... so many times i've had to redo giant swaths of cells... #the formatting would get messed up in so many ways for so many things (in fact here's a list: originally i only used two rows for the #header and not three but eventually certain sections required three rows to fit all the criteria so i had to not only edit my template #sheet but also go to all the sheets i had already worked on and redo all the cell merging all over again to accommodate #next i had to redo the way i duplicated the tables in the sheets that have branch links a few times because of silly small details i'm #100% sure no one would have noticed except me but that's enough to make me feel the need to change it all #and then after i finished a section including the branch links and all the links in the table of contents i'd sometimes have forgotten #something (like in the case of the voice lines that totally threw me for a loop and i asked for help with!) or i wanted to rearrange stuff #so i had to redo allllll of the cell links over and over because again google sheets' lack of cell references in links makes me so upset #like if i ever have to update this thing it is going to be a total nightmare even with me taking notes on the links ahead of time why on #earth can't cell links support references it is twenty-twenty-goddamned-two but anyway that's not even the end of the list #then i realized i made the crop size on the portraits too small because dickson for some reason has a wider portrait than any other chara #so then i had to resize all the other ones to compensate and THEN i did the boss portraits and thought i was done but ONLY THEN #i realized the new ones being wider made a bit of white empty space show up on the border and it looked so bad to me it was just a #one-pixel-wide strip but it ruined everything and so i spent like a whole day trying to fix it which involved me having to resize #nearly every single column on every single sheet and EVEN AFTER ALL THAT IT STILL!!!! STILLLLLLL WASN'T RIGHT BECAUSE GOOGLE SHEETS #DESPISES ME AND I DESPISE IT BACK so okay what happened was i was zooming into the sheet more than i ever had #so i could more easily quickly read the text for renaming the audio and i realized that when zoomed to either a range of 90%-99% or to #120%-129% THE WHITE BORDER THING STILL HAPPENED (BUT ONLY SOMETIMES ON SOME SHEETS EVEN THOUGH I COPY-PASTED THE CELLS THAT #DIDN'T HAVE THE STRIP ONTO CELLS THAT DID BUT THAT DIDN'T FIX IT AND I DOUBLE-CHECKED THE COLUMNS ON BOTH WERE THE SAME SIZE WTF IS #THIS SEVENTH LAYER OF HELL OF A PROGRAM) so anyway my solution was to change the background fill to black because i put black cell borders #around the portraits so it would kind of hide the white strip via turning it into the same color as the border that was supposed to be #there but by doing this it made the border appear thicker at those zoom ranges and i decided to go to every single portrait #cell and make the borders 2 px thick instead of 1 to make it less noticeable when changing zooms but EVEN THAT #didn't work so then i spent the day reverting all my changes back to 1 px because i am an insane person #i made SO much extra work for myself by not planning ahead why am i like this i'm sorry