Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Counting capacity based on technician schedule
Hopefully someone can help me
The formula I'm trying to figure out is to be able to count how many jobs a tech can do based on his schedule. Below is listed an example of how techs can be scheduled. Each letter means he can do 2 orders for that time interval. A = am orders, P= pm orders, & E = eve orders. So on day 1 the first tech scheduled AP can do 2am orders and 2pm orders, the second tech can do only 2 pm orders..and so on. I want a formula that based on a range of technicians schedules can say in a cell or cells...that for Day 1...we have the ability to do 2 am orders and 4 pm orders. U##### AP AP P E AE APE AP U1#### P A A AP APE P P i hope this is clear enough |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
counting cells (COUNTIF) based on two or more criteria | Excel Worksheet Functions | |||
counting based on criteria | Excel Worksheet Functions | |||
Counting an Array based on a calculation | Excel Discussion (Misc queries) | |||
counting based on 2 conditions | Excel Discussion (Misc queries) | |||
Counting rows based on criteria in multiple cells | Excel Discussion (Misc queries) |