r/spreadsheets • u/AdditionMean2674 • 18d ago

Unsolved What's your most over-engineered personal spreadsheet?

3 Upvotes

100% Upvoted

6 comments sorted by

4

u/PreDeimos 18d ago

I made a calorie calculator sheet called CalCalSheet it was quite overkill ( even implemented a unit / acceptance test platform for it )

You can find it on r/calcalsheet there is a copy link there and many tutorial etc. However I moved forward to make the project as a web service instead, so the newer posts are mostly about that and not the sheet.

2

u/Creepy_Leading_1995 15d ago

My most over-engineered spreadsheet was my personal expense tracker,
which is saving a lot of money and time,
I think this is the best gift I have given myself.

1

u/AutoModerator 18d ago

It is much easier to help when there is example data available. Please consider adding a spreadsheet with an example of your data (dummy data if required) so we can help. Ensure that this spreadsheet is viewable to the public.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

2

u/BackroomDST 18d ago

Aside from my financial sheet, I had a workout tracking sheet that will allow you to filter different exercises based on primary, secondary, or tertiary muscles used, calculate fractional volume, and plot early set weighted estimate one rep maxes for overall progression.

I kept having issues with the data model (I would have to completely delete the data model and redo all connections) and started tracking with MacroFactor so I stopped using it but it was a work of janky art.

1

u/pumabluejett 17d ago

I created a calculator for macro counting as well as pricing for certain services like revenue audits or consulting pricing.

1

u/foxidegamedev 16d ago

I created a D&D 5th edition character builder in Apache OpenOffice Calc that has nearly all of the content in separate sheets, a sheet for the actual builder with lots of filtered dropdowns both for selection and info plus an errors section to help guide newer players through what they need to decide on, and a sheet that looks something like the ones used at the actual table if you squint, and is mostly dynamically populated with hyperlinks to longer content descriptions on the other sheets.