F
fd2119
I'm trying to assign a value to each entry on an Excel spreadsheet.
Since I'm grasping at straws for a way to phrase my question, perhaps
it would be better to explain my intended use. I'm trying to designing
an incident command spreadsheet for fire department use, and want to
have each unit, such as an engine or ambulance, assigned a default
value (used for staffing). For example, an ambulance needs to have at
least 2 people to be used properly. Thus, I would like to have the
default value for an ambulance be 2. I'm also calculating the total
number of people (minimum staffing) due on each assignment, which is
where these staffing numbers would come into play. Ideally, if an
assignment calls for, say, 2 engines (4 people each), a truck (4
people), a chief (1 person), and an ambulance (2 people), for example,
it would autosum the number of people (15).
Sorry for the long post. Is this possible to do? Thanks in advance!
Doug
Since I'm grasping at straws for a way to phrase my question, perhaps
it would be better to explain my intended use. I'm trying to designing
an incident command spreadsheet for fire department use, and want to
have each unit, such as an engine or ambulance, assigned a default
value (used for staffing). For example, an ambulance needs to have at
least 2 people to be used properly. Thus, I would like to have the
default value for an ambulance be 2. I'm also calculating the total
number of people (minimum staffing) due on each assignment, which is
where these staffing numbers would come into play. Ideally, if an
assignment calls for, say, 2 engines (4 people each), a truck (4
people), a chief (1 person), and an ambulance (2 people), for example,
it would autosum the number of people (15).
Sorry for the long post. Is this possible to do? Thanks in advance!
Doug