I use two different computers in my work, one of which has MS Office 2000 on a Windows Vista platform & the other using MS Office 2002 on a Windows XP platform. Here is what I would like to do on both computers:
I have several sub-contractors I must pay and I pay them according to the zip code they work. Most all of those contractors work in counties outside the county they reside in and I pay them a different rate for that. The company I am contracted to sends me a batch report that indicates the rate that I get paid, along with its zip code. I, in turn, have to pay my sub-contractors a different rate based upon zip code. In fact, one contractor has to go so far out of his way that I pay him double for the work in that area & I take a loss on that, but that's a different story. I would like to create a spreadsheet that will allow me to take the batch report & utilize a formula to automatically create the pay for the sub-contractor based upon the zip code he/she works in.
Heres is an example of the statement I receive:
Type of Work My Rate Sub-Cont Zip
Delinquent Interview $9.00 1486-10 76827
Loss Draft $13.00 1486-10 76856
Delinquent Interview $9.00 1486-10 76856
Delinquent Interview $9.00 1486-10 76859
Property Condition $15.00 1486-10 76861
Delinquent Interview $9.00 1486-10 76901
Property Condition $15.00 1486-10 76901
Bankruptcy $11.00 1486-10 76903
From this example I pay my sub-contractor less than these figures based upon the zip code. How can I create a spreadsheet that will automatically calculate my sub-contractor's pay. For instance, my $9.00 rate might be $7.00 for the sub & the $15.00 might be $12.00 etc. It is not necessarily $2.00 or $1.00 less than what I am paid. In fact, the difference could even be more, in the case of the double I have to pay one sub. Given this information, can you give me an idea about how to take this example & perhaps copy & paste it into a spreadsheet already containing the formulas for the examples mentioned, keeping in mind the two different platforms of Excel?
Thanking you in advance,
Bob
I have several sub-contractors I must pay and I pay them according to the zip code they work. Most all of those contractors work in counties outside the county they reside in and I pay them a different rate for that. The company I am contracted to sends me a batch report that indicates the rate that I get paid, along with its zip code. I, in turn, have to pay my sub-contractors a different rate based upon zip code. In fact, one contractor has to go so far out of his way that I pay him double for the work in that area & I take a loss on that, but that's a different story. I would like to create a spreadsheet that will allow me to take the batch report & utilize a formula to automatically create the pay for the sub-contractor based upon the zip code he/she works in.
Heres is an example of the statement I receive:
Type of Work My Rate Sub-Cont Zip
Delinquent Interview $9.00 1486-10 76827
Loss Draft $13.00 1486-10 76856
Delinquent Interview $9.00 1486-10 76856
Delinquent Interview $9.00 1486-10 76859
Property Condition $15.00 1486-10 76861
Delinquent Interview $9.00 1486-10 76901
Property Condition $15.00 1486-10 76901
Bankruptcy $11.00 1486-10 76903
From this example I pay my sub-contractor less than these figures based upon the zip code. How can I create a spreadsheet that will automatically calculate my sub-contractor's pay. For instance, my $9.00 rate might be $7.00 for the sub & the $15.00 might be $12.00 etc. It is not necessarily $2.00 or $1.00 less than what I am paid. In fact, the difference could even be more, in the case of the double I have to pay one sub. Given this information, can you give me an idea about how to take this example & perhaps copy & paste it into a spreadsheet already containing the formulas for the examples mentioned, keeping in mind the two different platforms of Excel?
Thanking you in advance,
Bob
![[glasses]](/data/assets/smilies/glasses.gif "[glasses] [glasses]")
Don't let the Diatribe...![[tongue]](/data/assets/smilies/tongue.gif "[tongue] [tongue]")
