Excel question

[Daddles]

Doncha luv these :D

I've got a humungous spread sheet on which I record all my cycling data - yes, a bit geeky I know but it's fun and humours that wee voice inside that would love a job in a cubicle somewhere.

I've got four bikes and keep a running tally of the distance done on each bike. This is done by a formula, not an input (it identifies the bike and adds the ride's tally to the total for that bike). So running down my spreadsheet, I've got a long line of numbers. This all works very well and is not the problem.

The problem is one of tidyness :oo:
The columns of numbers extend way down past the last entry - it was easier to copy the formula down the column for months ahead than to do it each time I make an entry. Trouble is, it's unsightly (so am I on the bike but not even Billy Gates can fix that).

Is there some way of making the content of those cells invisible UNTIL I make an entry - eg, the bike totals cells appear blank until I put a figure in the 'ride time' column?

I've attached a screen shot of the spreadsheet for your amusement - quite a few columns have been hidden and the zoom adjusted to fit it on the screen, but it gives you an idea. The columns in question are Z through to AD (E could get the same treatment for the same reason). What I'd like is for those columns to appear blank until I put a figure in column C.

Any thoughts?

Richard

[Gra]

=if(or(c###="",c###=0),"",{insert your formula here})

[Daddles]

=if(or(c###="",c###=0),"",{insert your formula here})

Works a treat. Thanks mate :2tsup:

Richard

[Gra]

Glad I got one answer right today:U :U

[Wongo]

Funny bastard. :D See I like you.

[silentC]

Bit hilly around where you live is it Daddles? :U

[Wongo]

Why would anyone own 4 bikes is beyond me. I mean they all have 2 round wheels right? Don’t tell me you have one with rectangular wheels. You know that 25cm length, longer than 20cm width (or longer than anything shorter than 25cm:? ), kind of wheels?


:D

[silentC]

I've got two. :)

[Wongo]

2 wheels or 2 bikes? Its got to be clear mate.:D

[Gra]

beat me to it wongo, I was going to say two what??? and leave it at that:D :D

[Wongo]

I've got two. :)


Me too. :D :D :D :D :D

[silentC]

Why would anyone own 4 bikes is beyond me.


I've got two.

What did you get in your HSC again? :p

[Wongo]

I've got four bikes and keep a running tally.......

Read the question Silent.:D

[Daddles]

Why would anyone own 4 bikes is beyond me. I mean they all have 2 round wheels right? Don’t tell me you have one with rectangular wheels. You know that 25cm length, longer than 20cm width (or longer than anything shorter than 25cm:? ), kind of wheels?


:D

It's all explained on me website (http://www.users.bigpond.com/richardspurling/cycling.htm).

There's the Black Beast - the main brute of burden.
The Europa - bought her in the eighties and she now serves as a fixed gear bike
The Sow's Ear - the horrible hybrid that proves you can't make a silk purse out of a sow's ear but does do stirling work towing my daughter around on her tag-along.
and the Diamondback moutain bike that is in grave danger of donating her 'bits' to a home made recumbent.

So yeah, I don't need 4 bikes, but a couple more should see my needs filled :D

As for hilly, I can tell when I'm in my driveway, the road's suddenly flat :oo:

Most mornings I ride with my son to his school. The whole ride is a 25 km loop. There's about 5km of steep ups and downs to get to this hill (see attachment), we ride down it (topping 60km/hr), I leave him at school, turn around and have to ride up the sodding thing again:C. Then the 5kms of ups and downs before the final run along the ridge top to home.

Richard

[SPIRIT]

Read the question Silent.:Dhay that can be a new saying around here READ THE QUESTION

[Gra]

is it friday yet

[Daddles]

hay that can be a new saying around here READ THE QUESTION

What? Change the whole culture of the place? :oo:

Richard

[Daddles]

is it friday yet

This is about bikes, it's serious :U

Richard
bit like talking about scary sharp :C

[Wongo]

We should all expect a warning from the mod.:D

[Wongo]

Daddles, how did you climb 20m in the first 0km. I am on fire today. :D

http://www.woodworkforums.com/attachment.php?attachmentid=46227

[Gra]

Daddles, how did you climb 20m in the first 0km. I

Baked beans for breakfast:D :D

[Daddles]

Sheer strength and ability my good man :D

Richard
and baked beans for breakfast

[ozwinner]

Daddles, you need a hobby, try woodwork. :doh:

Al :U

[Daddles]

Did you see the piccies of the wooden bikes I posted last year? Now there's a challenge :D

Richard

[AlexS]

I've got four bikes and keep a running tally

Perhaps you should be keeping a cycling tally?:rolleyes:

Oops, sorry, didn't read the question.

[MikeT]

I'll ignore the cycling discussion here to avoid my guilt at stopping cycling a couple of months back (one day I'll fix the bike) and go back to the original question...

Have you thought about using a database - I think MS Access comes free with office. If you're just entering data it's pretty easy to use. It takes a bit more of a learning curve to work out performing formulas on lots of data but not too hard. And if you want it to look pretty there's wizards to help you make forms that make it look like a (semi) professional application.

cheers,
mike.

[sea dragon]

Daddles,
Why do you ride the/a bike to school?
I reckon your son would prefer the MG with the hood down, the burble of the engine and not having to worry about how his father will cope getting up the big hill to get back home.