K
krcowen
I calculate the labor costs for a list of job based on a list of 32
trades each of which has its own rate, using mmult(row of hours for
each trade,row of rates for each trade). This is done for a list of 10
to 100 different jobs and is working fine.
The problem that has me stuck is that I now have a requirement to price
a certain % of the hours for each trade at a different rate. Basically
a certain percentage of the hours is to be assigned to temps, and they
have different rates. I know I can readily replicate the 32 columns of
trades, populate the new set of columns with the % of the original
columns that get priced at the temp rate and use my mmult formula to
calculate the temp labor costs from the 32 new columns. Of course I
would also need a new set of 32 columns for the in-house % to multiply
by the in-house labor rates. That is an extra 64 columns that I would
like to avoid with a formula like
=mmult(row of 32 trades, (column of 32 rates * parallel column of 32
%'s) )
I really need to get this to work because I also have a requirement to
calculate the straight time and overtime, which is based on multiplying
each row by a % unique to that row. I could do that with another 64
columns as well, but, I want to avoid that as well. I am pretty sure
if I can solve the issue above, I can rotate the solution to handle
=mmult( (row of 32 trades * parallel row of 32 %'s),column of 32 rates)
and then the ultimate goal of
=mmult((row of 32 trades * parallel row of 32 %'s) , (column of 32
rates * parallel column of 32 %'s))
Although I have never posted to this group before, I have been fairly
active in the programming group and I see many familiar names here. I
hope someone can get me going in the right direction.
Thanks
Ken
trades each of which has its own rate, using mmult(row of hours for
each trade,row of rates for each trade). This is done for a list of 10
to 100 different jobs and is working fine.
The problem that has me stuck is that I now have a requirement to price
a certain % of the hours for each trade at a different rate. Basically
a certain percentage of the hours is to be assigned to temps, and they
have different rates. I know I can readily replicate the 32 columns of
trades, populate the new set of columns with the % of the original
columns that get priced at the temp rate and use my mmult formula to
calculate the temp labor costs from the 32 new columns. Of course I
would also need a new set of 32 columns for the in-house % to multiply
by the in-house labor rates. That is an extra 64 columns that I would
like to avoid with a formula like
=mmult(row of 32 trades, (column of 32 rates * parallel column of 32
%'s) )
I really need to get this to work because I also have a requirement to
calculate the straight time and overtime, which is based on multiplying
each row by a % unique to that row. I could do that with another 64
columns as well, but, I want to avoid that as well. I am pretty sure
if I can solve the issue above, I can rotate the solution to handle
=mmult( (row of 32 trades * parallel row of 32 %'s),column of 32 rates)
and then the ultimate goal of
=mmult((row of 32 trades * parallel row of 32 %'s) , (column of 32
rates * parallel column of 32 %'s))
Although I have never posted to this group before, I have been fairly
active in the programming group and I see many familiar names here. I
hope someone can get me going in the right direction.
Thanks
Ken