how would you bill this (simplyfied?)

ok lets say on particular job

rate is .25 per ton per loaded mile

example of a what would be billed off a daily haul ticket
invoice 11234
class 5 25.94 tn x .25 x 41.8 mi = $271.07
class 5 25.51 tn x .25 x 42.7 mi= $272.32
class 3 22.54 tn x .25 x 43.0 mi= $242.30
class 3 22.51 tn x .25 x 44.2 mi= $248.73

total for invoice =$1033.42


most jobs would be aether say 10.75 per ton so its a lot simpler say

invoice 11234
class 5 25.94 tons
class 5 25.51 tons
class 3 22.54 tons
class 3 22.51 tons

total 96.5 tons x 10.75 per ton $1037.37

basically just looking for any idea's on how to simplify my weekly billing on this tons x rate x miles formula.

daily haul sheets are sent with billing for whats on the daily haul sheets

 

well mods can delete this if they want i came up with a solution,

made a exel spread sheet that auto calculates everything all i have to do is punch in the the info and it auto calculates everything for me including the weekly total.

this will speed up the billing process whenever im on this job and also remove the chance for calculating errors.

the excel formula is basically

for the fields tons and mile
=SUM(B5*0.25* C5)

for daily totals
=SUM(D5+D6+D7+D8+D9+D10)

and for the weekly total
=SUM(D11+I11+N11+D22+I22+N22)

 

im not the best with this stuff. so ill try to describe it the best that i can i posted the formula's i used the b5 c5 ect are the cells used in the calculation so

when you put in the formula =SUM(B5*0.25* C5) enter the two figured you need calculated into cells b5 and c5 and the cell that you entered this formula into will show the calculated amount.

what makes this job particularly frustrating to bill is each load has to be calculated individually so at 4-6 loads per day you have to calculate all loads with the tons x .25 x miles then add up all the totals for the daily total.

using the formula =SUM(B5*0.25* C5) tons entered into cell b5 miles entered into c5 then the cell with the formula shows the total then i made 6 spots for each load for each day and then a cell that automatically adds together all the totals. using the =sum(cells+cells) formula then i used a cell that added together all the cells used for the daily totals

so now i just have to enter tons and miles for each load then it does everything else for me

the reason i was getting frustrated with this job is i was used to being able to bill a week in less than an hour being as most jobs are ether x amount per ton so add tons x rate = total less than 5 mins to calculate an entire day. or amount per hour x total hours for the day. 5-6 days and done, scan haul sheets bada boom bada bang done.

so only having 10-12 calculations to do to bill a week is normal. 40-50 calculations not so normal. let alone the haul sheets require odo reading load and dump millage. to show loaded miles but iv been calculating that as i go on each load.

the link that mark posted has a lot of use full information. im not the best with some of these programs still learning as i go.