[H]Need help divising a database/spreadsheet

Diamond

United States10796 Posts

November 26 2009 06:37 GMT

Hello again TL!

I am wanting to restart an old website I made awhile ago, and want to actually spend more than a cpl hrs on it!

My siteis a fighter rating system for the UFC. When I was working on it is was producing accurate lists which was cool.

But hand compiling this data blows and takes alot of time. I haven't really used excel or access much l8ly and am having a problem figuring out a good way to set this up.

Here's the numbers I need it to add up. How should i go about this?

Thanks everyone!

Not_Computer

Canada2277 Posts

November 26 2009 07:36 GMT

edit: oh, I guess I'm not quite sure how to do what I think you're trying to do in excel.

However, this would be pretty easy to program. Just a bunch of if statements. Perhaps someone bored could write one real quick.

original post:
+ Show Spoiler +

=SUM(A1:An)
where A1+A2+...+An represents all the cells in row A
and so forth

click on the fx button beside the input bar, it'll give you a list of functions you can use along with a short description of what they do.

also google is your friend for all microsoft office tricks

meeple

Canada10211 Posts

November 26 2009 07:59 GMT

Well... the first thing to do would be to transfer all the stats into excel, then once you have that I'm sure someone would help you with writing cells that add up what you want. As it stands that website doesn't give us anything to work with yet, since you haven't specified what numbers on that website that need to be added...

Badjas

Netherlands2038 Posts

November 26 2009 08:47 GMT

You could put something up on google docs spreadsheet and multiple people can muck around in the same spreadsheet at the same time. it'd be fun at least.

Please or register to reply.

[H]Need help divising a database/spreadsheet

Completed

Ongoing

Upcoming