'How many spreadsheets and graphs do you have?' blog discussion.

MSE_Martin

What a load of geeks you are

I love it! Its fab.

Though for those who just have spreadsheets and no graphs - you need to try it - the more detailed the better. Then when you update your sheet you can click over and see it in a visual form - its very sexy!

Gemmzie

MSE_Martin wrote: »

What a load of geeks you are

I love it! Its fab.

Though for those who just have spreadsheets and no graphs - you need to try it - the more detailed the better. Then when you update your sheet you can click over and see it in a visual form - its very sexy!

:rotfl: Sexy graphs

I love my spreadsheets, I'd be scared to count them all up

I have three at work too - all self created and they are so useful, we wouldn't get anything done without them!

camaj

Oh good, it's not just me then! One of the things I love about my Nokia E71 (won on Ebay of course!) is that I can create and edit spreadsheets (and probably upload them to the PC). I even had a google doc SS open when I spotted this post.

I've had loads of sheets down the years, I don't do graphs though.

I did one for MPG of various cars, their costs and payback times
I have one for football results for Spurs vs the equivilent results from previous seasons
I have one recording my 5-a-side footie results, including the score and how many I personally scored
I keep meaing to start one for cash payments
I should have one for ebay too

Gorgeous_George

I think that I'll create a spreadsheet to record the number of spreadsheets that MSEers admit to having.

I'll call it SAD (Spreadsheet Accumulation Database).

GG

earthmother

I don't tend to create graphs, but I have spreadsheets;
* tracking 2 current accounts and 6 savers between me and DH, all projected forward at least 2 years (I used to do month-end P&Ls too, but have slipped on those).
* Historical and future SOAs, and repayment date trackers for our DMP.
* About 2 years of grocery challenges - with breakdowns of what was bought each month and where from.
* Energy trackers for units and cost (my 'recommended monthly payment' calculations are often more accurate than the suppliers).

Then there are birthday and christmas spreadsheets for about 5 years gone, so I can see who got what, and for how much - with a large family, it helps to make sure I don't duplicate gifts (or re-gift to the wrong household).

There's one recording all the books I've read/bought, how much they were bought for, and where they've gone (some get passed around, others go straight into a resell pile), and what titles I want to read next (which helps DH when it comes to presents for me).

I have holiday trackers for the last few years - projected and actual spends - which help with budgeting for trips etc the next time around.

There's a weightloss one for me and DH - that's not doing great, lol

And one tracking the kids clothes and shoe sizes - when they change (to get an idea of when I should be next budgeting), and what I have packed away from older siblings (to save me buying stuff in sales I don't need).


According to mum, I was always a list maker

tgroom57

I'm glad it's not just me !
The spreadsheets I can think of at the moment are:

1. Track and record who I send xmas cards to, and who gets what.
2. Electricity usage monthly including an estimate of the quarterly bill, compared to the company estimates of what I might use. (Big help when deciding how much I should pay monthly.) Originally had weekly graphs for this. http://www.flickr.com/photos/tgroom57/5275072702/

3. Track competitions I can enter more than once. (So much easier to just click the link)
4. I set up one for yahoo Fantasy Trader a while back and at one point was in the top 20 - that spreadsheet used a live refresh of data from the web.
5. My own special- the contents of my wardrobe ! incs year bought, size & replacement cost. Graphs for yearly spend on this one. :-) (you would be appalled how much to replace everything if there was a fire- and it is only clothes /shoes /bags)

6. Plus, obviously, I keep my job search records in Excel. I hope to monitor where recruiters most often find my cv.

glider3560

MSE_Martin wrote: »

Though for those who just have spreadsheets and no graphs - you need to try it - the more detailed the better. Then when you update your sheet you can click over and see it in a visual form - its very sexy!

You've just tempted me...

This graph shows where I spend money (as a percentage of the total spent). The large spend in M&S is due to the fact I have a huge wad of gift vouchers (from various promotions).

Gorgeous_George

Hmmm...

I have spreadsheets for all sorts of things including one that allows you to enter 6 lottery numbers and it tells you how often you would have won if you had taken those numbers from the first lottery draw. It also tells you how many numbers that you would have matched.

However, one thing I see is that people refer to lists as spreadsheets. Sure, a spreadsheet might include a list but a list created in a spreadsheet programme is not a spreadsheet - it's just a list.

Some spreadsheets are databases.

GG

glider3560

Gorgeous_George wrote: »

However, one thing I see is that people refer to lists as spreadsheets. Sure, a spreadsheet might include a list but a list created in a spreadsheet programme is not a spreadsheet - it's just a list.

True, but mine are a bit geekier than just lists. Where I put "List of countries I've visited and approximate dates (very sad, I know)", the spreadsheet actually summarises how many times I've been to each country :rotfl:

camaj

If you have more than two sets of data then it's not a list. Admittedly some of mine are simpler than others and are more database tables than spreadsheets if you're defining one as one that has some sort of formula computations.