•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Personal life tracker : data structure and essential functions
Our take
Are you ready to transform your personal life into an engaging data journey? By creating a comprehensive workbook in Excel, you can gamify your daily routines and track various aspects of your life. From monitoring personal finances and budgeting to cataloging books read and movies watched, this approach can enhance your productivity and insights. Consider whether to consolidate everything into one extensive file or use separate ones, and explore essential functions that can elevate your dashboard.
This might be silly… but I want to get better at Excel and I figured the best way to do that is to "gamify" my life.
I’m planning to build one massive workbook to track everything:
-Personal Finances: Budgeting vs. actual spend.
-Media Tracker: Books read, movies watched, and ratings.
-Health/Habits: Gym days, water intake, or sleep.
Has anyone else done this? I’d love to hear your tips on structure. Specifically:
-Do you keep everything in one giant file or separate ones?
- What are some "must-have" functions for a dashboard like this?
- Any screenshots or templates you’re proud of and willing to share?
I’m not new to excel, I use it for work and school already, but trying to get better
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- I built an Excel personal net worth trackerI built a Excel spreadsheet template (get it here) to track my net worth in detail, across all my bank accounts, brokerage accounts, and alt assets too. It's got formulas and some spend categorization automations built into it, so hopefully it's helpful to you! Def a little annoying to manually re-add bank/transaction data to keep it updated, but that's solvable. Enjoy! LMK if anything is broken and I'll fix. submitted by /u/UofA4161 [link] [comments]
- Looking for project tracking ideasHi, As the title suggests I’m trying to create an Excel sheet that tracks the progress of various projects. Essentially, I was given a messy excel document to look after. I don’t have particularly advanced skills and nor do I want to spend too much time on this. So… One sheet lists projects as rows and they all have a reference code. There is a column designated for “action updates” where people overwrite progress each month. Other columns exist for project status, dates etc. My idea was to create another sheet which also lists the projects but acts as an action/change history log. I attempted to have a drop down through grouped cells that would act as a historic list of all changes and action updates around each project. The row with the corresponding project number would act as a “live view”, so using an X look up to display this data on the original sheet. Is there a better way to create something like this? There must be loads of ways to do something like this, but I just can’t think which way to do it!! Thank you for any help!!! submitted by /u/Formal_Disk_3760 [link] [comments]
- I'm sharing my professional expense tracker and the web app I created to automate it. Both are free to use.I’ve been using a really powerful spreadsheet for years. It’s a pretty solid tool for getting an annual view of your cost of living and savings rate, and I’ve spent a lot of time refining it. Recently, I decided to take that same logic and turn it into a web app as an alternative. Most apps I tried didn't really fit what I wanted, so I made something that keeps that "large screen" feel of a spreadsheet but with a faster workflow. I'm sharing both for free because it could be helpful for someone and I'm curious to see which approach people actually prefer. Here 2 snapshots of both spreadsheet and app dashboard comparison. In case you want the links, see my profile or ask by DM https://preview.redd.it/3kfxb8nof7sg1.png?width=784&format=png&auto=webp&s=d87c0e9605006bb7dd14d0bc4810b2d6afcc797e https://preview.redd.it/pj769h9bf7sg1.png?width=1311&format=png&auto=webp&s=35484a9625a901e585f41cbbebe707316b8f1673 submitted by /u/dabu_dbs [link] [comments]
- I want to have the ability to track my workouts by recording results in a spreadsheet.I want to be able to graph (pivotchart) my progress over time. An example of a workout may be: Bench Press - 3 sets of 10 reps each. Squat - 3 sets of 12 reps each Barbell row - 5 sets of 6 each That's just an example for the sake of illustrating my problem. How should I go about tracking the sets and reps and then what I did? Maybe I'm supposed to do 135 pounds on the bench press but I only end up being able to do 7 reps on the third set. What I want to track would be the sets, reps, the weight I used, the actual number of sets and reps I did and the date so I know when I did them. I would then like to be able to have a table that shows what I did last time so I can decide what I should try to do next time. How should I design these rows and columns to be able to capture that data and then use it for reporting? submitted by /u/ChrisF79 [link] [comments]
Tagged with
#Excel alternatives for data analysis#Excel compatibility#Excel alternatives#generative AI for data analysis#natural language processing for spreadsheets#rows.com#big data management in spreadsheets#conversational data analysis#real-time data collaboration#intelligent data visualization#data visualization tools#enterprise data management#big data performance#data analysis tools#data cleaning solutions#Excel#personal life tracker#data structure#budgeting#personal finances