Create Account

Username
Password
Remember me
Email
 
1

Excel 2010 help

5 comments, 210 views, posted 7:13 pm 22/02/2012 in Geek by z0phi3l
z0phi3l has 8092 posts, 218 threads, 77 points, location: Waterbury CT
God

I'm trying to create a spreadsheet to keep track of a point total

Here's where it gets tricky, it needs to be simple, and it needs a cell that has a value of say 10, IF it's checked, then that sum sent to a cell for a total, the cell then resets to unchecked, so that every time it's opened the cells appear unchecked, but the total cell still keeps track and adds to the total as necessary, unless someone messes up, there should be no reason to subtract from the total unless manually cleared, each check box can only be checked once per session

Might almost be easier to do in VB, but I haven't touched it in a decade

Here's a rough draft:

Name Event1 Event2 ... Total
Joesnuffy + + 20


Any ideas suggestions, guidance? I have the whole 2010 Office suite but it will then be imported into Google Docs to be embedded into a website

Comments

2
8:17 pm 22/02/2012

jLuv

Jim|x| |x|20
=(IF($B2="x",10,0)+IF($C2="x",10,0)+IF($D2="x",10,0)) where "x" is your plus-signs
add columns as needed
then you can auto-fill down for however many names you have

0
7:47 pm 05/03/2012

z0phi3l

Gonna have to bring this back up, got a new issue

The function above doesn't take into consideration that you can do a run more than once so it's not adding correctly

Essentially every cell can have 1 or more X in it to represent multiple instances at a time

0
1:57 pm 06/03/2012

Edorph

You can really only declaratively define cell's values with formulas. If you need anything procedural, you have to stuff some VB (or similar) into the mix. Of course, that will presumably not work very well with Google docs, so my bet would be to look at something like Google doc forms: http://www.google.com/google-d-s/forms/.

Alternatively (and more fun to boot!) you could brush up on something like Python (for example with Google's app engine!) and slap together an app yourself. More robust + valuable knowledge!

0
2:24 pm 06/03/2012

Edorph

Quote by z0phi3l:
Essentially every cell can have 1 or more X in it to represent multiple instances at a time


Wait, I didn't notice this. You can count the number of 'X's in each event column with something like:

Code:
=LEN(CONCATENATE(B2;C2;D2)) - LEN(SUBSTITUTE(CONCATENATE(B2;C2;D2);"X";""))


Of course, one of your users will mess this up and erase everyone else's Xs

0
3:19 pm 12/03/2012

z0phi3l

Need that to work on a per row basis, not column, each person can do X event many times

Putting a , between the x didn't work either

don't need to worry about it getting messed up, I am the only one that can make edits to it

Add Comment

Log in via teoti, or register to add a comment!