|
|
|
|
 |
|
October 12th, 2005, 12:49 PM
|
 |
Shrapnel Fanatic
|
|
Join Date: Jul 2001
Location: Southern CA, USA
Posts: 18,394
Thanks: 0
Thanked 12 Times in 10 Posts
|
|
Re: OT: Spreadsheet Fun!
You can overwrite the /4 formula with a 0 for that month.
|
October 12th, 2005, 12:56 PM
|
 |
Captain
|
|
Join Date: Apr 2003
Location: Burnaby
Posts: 995
Thanks: 0
Thanked 3 Times in 2 Posts
|
|
Re: OT: Spreadsheet Fun!
Well, that was Plan B.  Since I won't always be the one using the sheet I was hoping to protect all the formula cells to prevent less computer literate people from fudging the whole thing up.
Any other options?
__________________
Suction feet are not to be trifled with!
|
October 12th, 2005, 01:00 PM
|
|
Shrapnel Fanatic
|
|
Join Date: Jul 2001
Location: Southern CA, USA
Posts: 18,394
Thanks: 0
Thanked 12 Times in 10 Posts
|
|
Re: OT: Spreadsheet Fun!
Hide a backup of the SS somewhere! |
October 12th, 2005, 01:17 PM
|
 |
Sergeant
|
|
Join Date: Sep 2005
Location: Colorado, USA
Posts: 214
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Re: OT: Spreadsheet Fun!
What version of Excel?
As the spreadsheet owner, you can lock cells, columns, and rows with a password. Go to "format cell" then make go to the "protection" tab. Then go to Tools/Protection and protect the doc and it will protect cells that are marked locked. You can even protect the whole doc (the default) and then select a group of cells and unprotect, securing the whole document, but still allowing others to update the cells you specify.
I knew that official MS certification for MS Excel course that I paid $70 USD for would come in handy someday.
|
October 12th, 2005, 01:35 PM
|
|
Captain
|
|
Join Date: Apr 2003
Location: Burnaby
Posts: 995
Thanks: 0
Thanked 3 Times in 2 Posts
|
|
Re: OT: Spreadsheet Fun!
Actually it's Open Office program which is a lot like MS Office only better and free. I'm really looking for a way to exempt certain cells if need be so I can protect the cells I don't want fiddled with but still have them not apply in certain cases. Dunno how possible that is though....
__________________
Suction feet are not to be trifled with!
|
October 12th, 2005, 02:16 PM
|
 |
Shrapnel Fanatic
|
|
Join Date: Feb 2001
Location: Waterloo, Ontario, Canada
Posts: 11,451
Thanks: 1
Thanked 4 Times in 4 Posts
|
|
Re: OT: Spreadsheet Fun!
Quote:
Imperator Fyron said:
You can overwrite the /4 formula with a 0 for that month.
|
That would leave you with only 3/4ths of your bills paid.
Why not make a row in which you fill in the number of days (or weeks) that month the person was present.
The the divide by 4 becomes:
divide by sum(Presence row), times presence cell for that person.
If the person was there for 2 weeks, while the other three were there for 4 weeks, then the 2-weeker pays 2/14ths of the bill.
If you don't want to measure weeks, and only months, that works too. As long as you ALL don't leave, resulting in a division by zero-people-to-pay-up
__________________
Things you want:
|
October 12th, 2005, 02:20 PM
|
 |
Shrapnel Fanatic
|
|
Join Date: Mar 2003
Location: CHEESE!
Posts: 10,009
Thanks: 0
Thanked 7 Times in 1 Post
|
|
Re: OT: Spreadsheet Fun!
Happy birthday.
Now, what are you doing doing math on your birthday when you don't have to? 
__________________
If I only could remember half the things I'd forgot, that would be a lot of stuff, I think - I don't know; I forgot!
A* E* Se! Gd! $-- C-^- Ai** M-- S? Ss---- RA Pw? Fq Bb++@ Tcp? L++++
Some of my webcomics. I've got 400+ webcomics at Last count, some dead.
Sig updated to remove non-working links.
|
October 12th, 2005, 02:32 PM
|
|
Captain
|
|
Join Date: Apr 2003
Location: Burnaby
Posts: 995
Thanks: 0
Thanked 3 Times in 2 Posts
|
|
Re: OT: Spreadsheet Fun!
I was trying to avoid math. That's why I made the spreadsheet. 
__________________
Suction feet are not to be trifled with!
|
October 12th, 2005, 07:10 PM
|
 |
Shrapnel Fanatic
|
|
Join Date: Dec 2000
Location: USA
Posts: 15,630
Thanks: 0
Thanked 31 Times in 19 Posts
|
|
Re: OT: Spreadsheet Fun!
Happy birthday AgentZero....
__________________
Creator of the Star Trek Mod - AST Mod - 78 Ship Sets - Conquest Mod - Atrocities Star Wars Mod - Galaxy Reborn Mod - and Subterfuge Mod.
|
October 13th, 2005, 01:08 AM
|
 |
Lieutenant General
|
|
Join Date: Nov 2002
Posts: 2,903
Thanks: 1
Thanked 0 Times in 0 Posts
|
|
Re: OT: Spreadsheet Fun!
Happy Birthday!!  |
| Thread Tools |
|
|
| Display Modes |
 Hybrid Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is On
|
|
|
|
|
Asteroids Champion!
