Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Equipment checkout calendar
I'm trying to set up a spreadsheet that tracks equipment being checked out,
and how much is left on a given day. I was planning to do a sheet with a calendar - months across the top, dates 1-31 down the side. On the second sheet, I have a info about who is checking out what on what date. I thought I could reference the date on this list, and have it show up in the proper cell on the calendar page. The person in charge of the equipment would just enter the info about when stuff is being checked out, and then could look at the calendar to see which dates still have equipment available. I don't know how to do this - use julian dates? I have barely begun this project, so if anyone knows of a better layout idea, I"m open to that, too. Thanks, joAnne |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Equipment checkout calendar
Conditional formating may help. You can use a fomula that checks total items
checked out on sheet 2. If the total is not zero highlight the calendar in red indicating items are still checked out. Set the color green is the total is zero. "joannelj" wrote: I'm trying to set up a spreadsheet that tracks equipment being checked out, and how much is left on a given day. I was planning to do a sheet with a calendar - months across the top, dates 1-31 down the side. On the second sheet, I have a info about who is checking out what on what date. I thought I could reference the date on this list, and have it show up in the proper cell on the calendar page. The person in charge of the equipment would just enter the info about when stuff is being checked out, and then could look at the calendar to see which dates still have equipment available. I don't know how to do this - use julian dates? I have barely begun this project, so if anyone knows of a better layout idea, I"m open to that, too. Thanks, joAnne |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Equipment checkout calendar
I think I see how conditional formatting works - but how do I link the dates?
I think I may have been unclear. Instead of saying people are checking out equipment, let me say they are reserving equipment. ie Chantel wants to reserve 4 mannequins on 6/23/07. How do I take that, and have it show up on the calendar sheet, that 4 mannequins are reserved, and x are left available? Thanks, joAnne "Joel" wrote: Conditional formating may help. You can use a fomula that checks total items checked out on sheet 2. If the total is not zero highlight the calendar in red indicating items are still checked out. Set the color green is the total is zero. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Equipment checkout calendar
You could use a =if(countif(sheet2!$B$1:$B$100,"=B1") 0,,) as the
conditional formating Your calendar could contain the actual dates A B C 1 3/1/07 3/3/07 3/4/07 2 3/8/07 3/9/07 3/10/07 3 3/15/07 3/16/07 3/17/07 "joannelj" wrote: I think I see how conditional formatting works - but how do I link the dates? I think I may have been unclear. Instead of saying people are checking out equipment, let me say they are reserving equipment. ie Chantel wants to reserve 4 mannequins on 6/23/07. How do I take that, and have it show up on the calendar sheet, that 4 mannequins are reserved, and x are left available? Thanks, joAnne "Joel" wrote: Conditional formating may help. You can use a fomula that checks total items checked out on sheet 2. If the total is not zero highlight the calendar in red indicating items are still checked out. Set the color green is the total is zero. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
looking for equipment maintainance log | Excel Discussion (Misc queries) | |||
How do I use a template to keep records for equipment? | Excel Worksheet Functions | |||
Equipment Losses for American occupier | Excel Discussion (Misc queries) | |||
Please I need a good Equipment Inventory template | Excel Discussion (Misc queries) | |||
How do I set up a equipment replacement reserve schedule | Excel Worksheet Functions |