HCI
05-26-2010, 09:33 AM
im gonna do my best to explain this.
i am an estimator for a construction company. we get several bids from many different trades for each job we bid. (electrical, framing, drywall, etc.)
alot of times these bids are broken out in detail.
lights - $35,000.00
Wire - $5,000.00
Conduit - $3,500.00
sort of like that. but we will get several bids from electricians broken out the same way. eventually after entering in all the electricians you can see a trend in the prices for that job example ( lights will range from $25,000.00 to $35,000.00)
well the other day i made a typo and didnt catch it.
Electric company 1 | Electric Company 2 | Electric Company 3
Lights - $25,000.00 | $ 32,000.00 | $3,500.00 < Typo
Wire - $5,000.00 | $ 4,500.00 | $ 6,000.00
i hope you get the idea now.
my question is:
is there some kind of conditional formating code that will look at the range of numbers for a particular line item and determine if one just doesnt fit the trend of those numbers and then highlight that number to be double checked? like the $3,500.00 typo in the lights catagory.
thanks for any help.
i am an estimator for a construction company. we get several bids from many different trades for each job we bid. (electrical, framing, drywall, etc.)
alot of times these bids are broken out in detail.
lights - $35,000.00
Wire - $5,000.00
Conduit - $3,500.00
sort of like that. but we will get several bids from electricians broken out the same way. eventually after entering in all the electricians you can see a trend in the prices for that job example ( lights will range from $25,000.00 to $35,000.00)
well the other day i made a typo and didnt catch it.
Electric company 1 | Electric Company 2 | Electric Company 3
Lights - $25,000.00 | $ 32,000.00 | $3,500.00 < Typo
Wire - $5,000.00 | $ 4,500.00 | $ 6,000.00
i hope you get the idea now.
my question is:
is there some kind of conditional formating code that will look at the range of numbers for a particular line item and determine if one just doesnt fit the trend of those numbers and then highlight that number to be double checked? like the $3,500.00 typo in the lights catagory.
thanks for any help.