PK ! FÇMHÍ Í docProps/app.xmlMicrosoft Excel Compatible / Openpyxl 3.1.53.1PK ! ¥(¢5+ + docProps/core.xmlopenpyxl2026-11-16T21:28:21Z2026-11-16T21:28:21ZPK ! ™\œ#œ' œ' xl/theme/theme1.xml
PK ! Œ oÏË
Ë
xl/worksheets/sheet1.xmlOwner-Operator Load & Settlement Tracker
Part of the AIToolKit Pro Owner-Operator AI Paperwork Kit
|
HOW TO USE
1. Loads tab: add one row per load. Fill in the cream-colored cells only. Everything in white calculates itself.
2. Expenses tab: log every expense (fuel, repairs, insurance, tolls, factoring fees...). Pick a category from the dropdown.
3. Monthly Summary tab: type the year in the cream cell at the top. It totals revenue, miles, costs and profit per mile for each month.
4. Broker Scorecard tab: type each broker's name once (exactly as you spell it on the Loads tab). It shows how much you hauled for them, their average rate per mile, how long they take to pay and what they still owe you.
5. Invoice tab: fill in your company info once, then type a Load # in the cream cell. The invoice fills itself in from the Loads tab. Print or save as PDF.
|
COLOR KEY
Cream cell with blue text = you type here. White cell with black text = formula, don't overwrite. Green row = example row, delete or overwrite it.
|
TIPS
- Enter dates as dates (e.g. 11/14/2026), not text, or the monthly totals and days-to-pay won't work.
- Leave 'Date Paid' blank until the money actually hits your account. Status flips from Invoiced to Paid on its own.
- RPM incl. deadhead is the number that tells you what a load really paid. A load that looks good on loaded miles can look bad once you count the empty miles to get to it.
- Rows are pre-built for 300 loads and 300 expenses. To go past that, copy the last row down.
|
This tracker is a recordkeeping tool, not tax or accounting advice. Check with your accountant on how to categorize expenses for your return.
PK ! ÌI²Ýpô pô xl/worksheets/sheet2.xmlDate DeliveredBroker / CustomerLoad #OriginDestinationLoaded MilesDeadhead MilesLinehaul Rate ($)Fuel Surcharge ($)Detention ($)Lumper / Other Reimb. ($)Total Revenue ($)RPM (Loaded)RPM incl. DeadheadInvoice SentDate PaidDays to PayStatusNotes
46329Example Logistics LLCEX-10442Portland, ORBoise, ID4303514500750IF(COUNT(H2:K2)=0,"",SUM(H2:K2))IF(OR(L2="",N(F2)=0),"",L2/F2)IF(OR(L2="",N(F2)+N(G2)=0),"",L2/(N(F2)+N(G2)))4632946354IF(OR(O2="",P2=""),"",P2-O2)IF(C2="","",IF(P2<>"","Paid",IF(O2<>"","Invoiced","Not invoiced")))Example row - overwrite or delete
IF(COUNT(H3:K3)=0,"",SUM(H3:K3))IF(OR(L3="",N(F3)=0),"",L3/F3)IF(OR(L3="",N(F3)+N(G3)=0),"",L3/(N(F3)+N(G3)))IF(OR(O3="",P3=""),"",P3-O3)IF(C3="","",IF(P3<>"","Paid",IF(O3<>"","Invoiced","Not invoiced")))
IF(COUNT(H4:K4)=0,"",SUM(H4:K4))IF(OR(L4="",N(F4)=0),"",L4/F4)IF(OR(L4="",N(F4)+N(G4)=0),"",L4/(N(F4)+N(G4)))IF(OR(O4="",P4=""),"",P4-O4)IF(C4="","",IF(P4<>"","Paid",IF(O4<>"","Invoiced","Not invoiced")))
IF(COUNT(H5:K5)=0,"",SUM(H5:K5))IF(OR(L5="",N(F5)=0),"",L5/F5)IF(OR(L5="",N(F5)+N(G5)=0),"",L5/(N(F5)+N(G5)))IF(OR(O5="",P5=""),"",P5-O5)IF(C5="","",IF(P5<>"","Paid",IF(O5<>"","Invoiced","Not invoiced")))
IF(COUNT(H6:K6)=0,"",SUM(H6:K6))IF(OR(L6="",N(F6)=0),"",L6/F6)IF(OR(L6="",N(F6)+N(G6)=0),"",L6/(N(F6)+N(G6)))IF(OR(O6="",P6=""),"",P6-O6)IF(C6="","",IF(P6<>"","Paid",IF(O6<>"","Invoiced","Not invoiced")))
IF(COUNT(H7:K7)=0,"",SUM(H7:K7))IF(OR(L7="",N(F7)=0),"",L7/F7)IF(OR(L7="",N(F7)+N(G7)=0),"",L7/(N(F7)+N(G7)))IF(OR(O7="",P7=""),"",P7-O7)IF(C7="","",IF(P7<>"","Paid",IF(O7<>"","Invoiced","Not invoiced")))
IF(COUNT(H8:K8)=0,"",SUM(H8:K8))IF(OR(L8="",N(F8)=0),"",L8/F8)IF(OR(L8="",N(F8)+N(G8)=0),"",L8/(N(F8)+N(G8)))IF(OR(O8="",P8=""),"",P8-O8)IF(C8="","",IF(P8<>"","Paid",IF(O8<>"","Invoiced","Not invoiced")))
IF(COUNT(H9:K9)=0,"",SUM(H9:K9))IF(OR(L9="",N(F9)=0),"",L9/F9)IF(OR(L9="",N(F9)+N(G9)=0),"",L9/(N(F9)+N(G9)))IF(OR(O9="",P9=""),"",P9-O9)IF(C9="","",IF(P9<>"","Paid",IF(O9<>"","Invoiced","Not invoiced")))
IF(COUNT(H10:K10)=0,"",SUM(H10:K10))IF(OR(L10="",N(F10)=0),"",L10/F10)IF(OR(L10="",N(F10)+N(G10)=0),"",L10/(N(F10)+N(G10)))IF(OR(O10="",P10=""),"",P10-O10)IF(C10="","",IF(P10<>"","Paid",IF(O10<>"","Invoiced","Not invoiced")))
IF(COUNT(H11:K11)=0,"",SUM(H11:K11))IF(OR(L11="",N(F11)=0),"",L11/F11)IF(OR(L11="",N(F11)+N(G11)=0),"",L11/(N(F11)+N(G11)))IF(OR(O11="",P11=""),"",P11-O11)IF(C11="","",IF(P11<>"","Paid",IF(O11<>"","Invoiced","Not invoiced")))
IF(COUNT(H12:K12)=0,"",SUM(H12:K12))IF(OR(L12="",N(F12)=0),"",L12/F12)IF(OR(L12="",N(F12)+N(G12)=0),"",L12/(N(F12)+N(G12)))IF(OR(O12="",P12=""),"",P12-O12)IF(C12="","",IF(P12<>"","Paid",IF(O12<>"","Invoiced","Not invoiced")))
IF(COUNT(H13:K13)=0,"",SUM(H13:K13))IF(OR(L13="",N(F13)=0),"",L13/F13)IF(OR(L13="",N(F13)+N(G13)=0),"",L13/(N(F13)+N(G13)))IF(OR(O13="",P13=""),"",P13-O13)IF(C13="","",IF(P13<>"","Paid",IF(O13<>"","Invoiced","Not invoiced")))
IF(COUNT(H14:K14)=0,"",SUM(H14:K14))IF(OR(L14="",N(F14)=0),"",L14/F14)IF(OR(L14="",N(F14)+N(G14)=0),"",L14/(N(F14)+N(G14)))IF(OR(O14="",P14=""),"",P14-O14)IF(C14="","",IF(P14<>"","Paid",IF(O14<>"","Invoiced","Not invoiced")))
IF(COUNT(H15:K15)=0,"",SUM(H15:K15))IF(OR(L15="",N(F15)=0),"",L15/F15)IF(OR(L15="",N(F15)+N(G15)=0),"",L15/(N(F15)+N(G15)))IF(OR(O15="",P15=""),"",P15-O15)IF(C15="","",IF(P15<>"","Paid",IF(O15<>"","Invoiced","Not invoiced")))
IF(COUNT(H16:K16)=0,"",SUM(H16:K16))IF(OR(L16="",N(F16)=0),"",L16/F16)IF(OR(L16="",N(F16)+N(G16)=0),"",L16/(N(F16)+N(G16)))IF(OR(O16="",P16=""),"",P16-O16)IF(C16="","",IF(P16<>"","Paid",IF(O16<>"","Invoiced","Not invoiced")))
IF(COUNT(H17:K17)=0,"",SUM(H17:K17))IF(OR(L17="",N(F17)=0),"",L17/F17)IF(OR(L17="",N(F17)+N(G17)=0),"",L17/(N(F17)+N(G17)))IF(OR(O17="",P17=""),"",P17-O17)IF(C17="","",IF(P17<>"","Paid",IF(O17<>"","Invoiced","Not invoiced")))
IF(COUNT(H18:K18)=0,"",SUM(H18:K18))IF(OR(L18="",N(F18)=0),"",L18/F18)IF(OR(L18="",N(F18)+N(G18)=0),"",L18/(N(F18)+N(G18)))IF(OR(O18="",P18=""),"",P18-O18)IF(C18="","",IF(P18<>"","Paid",IF(O18<>"","Invoiced","Not invoiced")))
IF(COUNT(H19:K19)=0,"",SUM(H19:K19))IF(OR(L19="",N(F19)=0),"",L19/F19)IF(OR(L19="",N(F19)+N(G19)=0),"",L19/(N(F19)+N(G19)))IF(OR(O19="",P19=""),"",P19-O19)IF(C19="","",IF(P19<>"","Paid",IF(O19<>"","Invoiced","Not invoiced")))
IF(COUNT(H20:K20)=0,"",SUM(H20:K20))IF(OR(L20="",N(F20)=0),"",L20/F20)IF(OR(L20="",N(F20)+N(G20)=0),"",L20/(N(F20)+N(G20)))IF(OR(O20="",P20=""),"",P20-O20)IF(C20="","",IF(P20<>"","Paid",IF(O20<>"","Invoiced","Not invoiced")))
IF(COUNT(H21:K21)=0,"",SUM(H21:K21))IF(OR(L21="",N(F21)=0),"",L21/F21)IF(OR(L21="",N(F21)+N(G21)=0),"",L21/(N(F21)+N(G21)))IF(OR(O21="",P21=""),"",P21-O21)IF(C21="","",IF(P21<>"","Paid",IF(O21<>"","Invoiced","Not invoiced")))
IF(COUNT(H22:K22)=0,"",SUM(H22:K22))IF(OR(L22="",N(F22)=0),"",L22/F22)IF(OR(L22="",N(F22)+N(G22)=0),"",L22/(N(F22)+N(G22)))IF(OR(O22="",P22=""),"",P22-O22)IF(C22="","",IF(P22<>"","Paid",IF(O22<>"","Invoiced","Not invoiced")))
IF(COUNT(H23:K23)=0,"",SUM(H23:K23))IF(OR(L23="",N(F23)=0),"",L23/F23)IF(OR(L23="",N(F23)+N(G23)=0),"",L23/(N(F23)+N(G23)))IF(OR(O23="",P23=""),"",P23-O23)IF(C23="","",IF(P23<>"","Paid",IF(O23<>"","Invoiced","Not invoiced")))
IF(COUNT(H24:K24)=0,"",SUM(H24:K24))IF(OR(L24="",N(F24)=0),"",L24/F24)IF(OR(L24="",N(F24)+N(G24)=0),"",L24/(N(F24)+N(G24)))IF(OR(O24="",P24=""),"",P24-O24)IF(C24="","",IF(P24<>"","Paid",IF(O24<>"","Invoiced","Not invoiced")))
IF(COUNT(H25:K25)=0,"",SUM(H25:K25))IF(OR(L25="",N(F25)=0),"",L25/F25)IF(OR(L25="",N(F25)+N(G25)=0),"",L25/(N(F25)+N(G25)))IF(OR(O25="",P25=""),"",P25-O25)IF(C25="","",IF(P25<>"","Paid",IF(O25<>"","Invoiced","Not invoiced")))
IF(COUNT(H26:K26)=0,"",SUM(H26:K26))IF(OR(L26="",N(F26)=0),"",L26/F26)IF(OR(L26="",N(F26)+N(G26)=0),"",L26/(N(F26)+N(G26)))IF(OR(O26="",P26=""),"",P26-O26)IF(C26="","",IF(P26<>"","Paid",IF(O26<>"","Invoiced","Not invoiced")))
IF(COUNT(H27:K27)=0,"",SUM(H27:K27))IF(OR(L27="",N(F27)=0),"",L27/F27)IF(OR(L27="",N(F27)+N(G27)=0),"",L27/(N(F27)+N(G27)))IF(OR(O27="",P27=""),"",P27-O27)IF(C27="","",IF(P27<>"","Paid",IF(O27<>"","Invoiced","Not invoiced")))
IF(COUNT(H28:K28)=0,"",SUM(H28:K28))IF(OR(L28="",N(F28)=0),"",L28/F28)IF(OR(L28="",N(F28)+N(G28)=0),"",L28/(N(F28)+N(G28)))IF(OR(O28="",P28=""),"",P28-O28)IF(C28="","",IF(P28<>"","Paid",IF(O28<>"","Invoiced","Not invoiced")))
IF(COUNT(H29:K29)=0,"",SUM(H29:K29))IF(OR(L29="",N(F29)=0),"",L29/F29)IF(OR(L29="",N(F29)+N(G29)=0),"",L29/(N(F29)+N(G29)))IF(OR(O29="",P29=""),"",P29-O29)IF(C29="","",IF(P29<>"","Paid",IF(O29<>"","Invoiced","Not invoiced")))
IF(COUNT(H30:K30)=0,"",SUM(H30:K30))IF(OR(L30="",N(F30)=0),"",L30/F30)IF(OR(L30="",N(F30)+N(G30)=0),"",L30/(N(F30)+N(G30)))IF(OR(O30="",P30=""),"",P30-O30)IF(C30="","",IF(P30<>"","Paid",IF(O30<>"","Invoiced","Not invoiced")))
IF(COUNT(H31:K31)=0,"",SUM(H31:K31))IF(OR(L31="",N(F31)=0),"",L31/F31)IF(OR(L31="",N(F31)+N(G31)=0),"",L31/(N(F31)+N(G31)))IF(OR(O31="",P31=""),"",P31-O31)IF(C31="","",IF(P31<>"","Paid",IF(O31<>"","Invoiced","Not invoiced")))
IF(COUNT(H32:K32)=0,"",SUM(H32:K32))IF(OR(L32="",N(F32)=0),"",L32/F32)IF(OR(L32="",N(F32)+N(G32)=0),"",L32/(N(F32)+N(G32)))IF(OR(O32="",P32=""),"",P32-O32)IF(C32="","",IF(P32<>"","Paid",IF(O32<>"","Invoiced","Not invoiced")))
IF(COUNT(H33:K33)=0,"",SUM(H33:K33))IF(OR(L33="",N(F33)=0),"",L33/F33)IF(OR(L33="",N(F33)+N(G33)=0),"",L33/(N(F33)+N(G33)))IF(OR(O33="",P33=""),"",P33-O33)IF(C33="","",IF(P33<>"","Paid",IF(O33<>"","Invoiced","Not invoiced")))
IF(COUNT(H34:K34)=0,"",SUM(H34:K34))IF(OR(L34="",N(F34)=0),"",L34/F34)IF(OR(L34="",N(F34)+N(G34)=0),"",L34/(N(F34)+N(G34)))IF(OR(O34="",P34=""),"",P34-O34)IF(C34="","",IF(P34<>"","Paid",IF(O34<>"","Invoiced","Not invoiced")))
IF(COUNT(H35:K35)=0,"",SUM(H35:K35))IF(OR(L35="",N(F35)=0),"",L35/F35)IF(OR(L35="",N(F35)+N(G35)=0),"",L35/(N(F35)+N(G35)))IF(OR(O35="",P35=""),"",P35-O35)IF(C35="","",IF(P35<>"","Paid",IF(O35<>"","Invoiced","Not invoiced")))
IF(COUNT(H36:K36)=0,"",SUM(H36:K36))IF(OR(L36="",N(F36)=0),"",L36/F36)IF(OR(L36="",N(F36)+N(G36)=0),"",L36/(N(F36)+N(G36)))IF(OR(O36="",P36=""),"",P36-O36)IF(C36="","",IF(P36<>"","Paid",IF(O36<>"","Invoiced","Not invoiced")))
IF(COUNT(H37:K37)=0,"",SUM(H37:K37))IF(OR(L37="",N(F37)=0),"",L37/F37)IF(OR(L37="",N(F37)+N(G37)=0),"",L37/(N(F37)+N(G37)))IF(OR(O37="",P37=""),"",P37-O37)IF(C37="","",IF(P37<>"","Paid",IF(O37<>"","Invoiced","Not invoiced")))
IF(COUNT(H38:K38)=0,"",SUM(H38:K38))IF(OR(L38="",N(F38)=0),"",L38/F38)IF(OR(L38="",N(F38)+N(G38)=0),"",L38/(N(F38)+N(G38)))IF(OR(O38="",P38=""),"",P38-O38)IF(C38="","",IF(P38<>"","Paid",IF(O38<>"","Invoiced","Not invoiced")))
IF(COUNT(H39:K39)=0,"",SUM(H39:K39))IF(OR(L39="",N(F39)=0),"",L39/F39)IF(OR(L39="",N(F39)+N(G39)=0),"",L39/(N(F39)+N(G39)))IF(OR(O39="",P39=""),"",P39-O39)IF(C39="","",IF(P39<>"","Paid",IF(O39<>"","Invoiced","Not invoiced")))
IF(COUNT(H40:K40)=0,"",SUM(H40:K40))IF(OR(L40="",N(F40)=0),"",L40/F40)IF(OR(L40="",N(F40)+N(G40)=0),"",L40/(N(F40)+N(G40)))IF(OR(O40="",P40=""),"",P40-O40)IF(C40="","",IF(P40<>"","Paid",IF(O40<>"","Invoiced","Not invoiced")))
IF(COUNT(H41:K41)=0,"",SUM(H41:K41))IF(OR(L41="",N(F41)=0),"",L41/F41)IF(OR(L41="",N(F41)+N(G41)=0),"",L41/(N(F41)+N(G41)))IF(OR(O41="",P41=""),"",P41-O41)IF(C41="","",IF(P41<>"","Paid",IF(O41<>"","Invoiced","Not invoiced")))
IF(COUNT(H42:K42)=0,"",SUM(H42:K42))IF(OR(L42="",N(F42)=0),"",L42/F42)IF(OR(L42="",N(F42)+N(G42)=0),"",L42/(N(F42)+N(G42)))IF(OR(O42="",P42=""),"",P42-O42)IF(C42="","",IF(P42<>"","Paid",IF(O42<>"","Invoiced","Not invoiced")))
IF(COUNT(H43:K43)=0,"",SUM(H43:K43))IF(OR(L43="",N(F43)=0),"",L43/F43)IF(OR(L43="",N(F43)+N(G43)=0),"",L43/(N(F43)+N(G43)))IF(OR(O43="",P43=""),"",P43-O43)IF(C43="","",IF(P43<>"","Paid",IF(O43<>"","Invoiced","Not invoiced")))
IF(COUNT(H44:K44)=0,"",SUM(H44:K44))IF(OR(L44="",N(F44)=0),"",L44/F44)IF(OR(L44="",N(F44)+N(G44)=0),"",L44/(N(F44)+N(G44)))IF(OR(O44="",P44=""),"",P44-O44)IF(C44="","",IF(P44<>"","Paid",IF(O44<>"","Invoiced","Not invoiced")))
IF(COUNT(H45:K45)=0,"",SUM(H45:K45))IF(OR(L45="",N(F45)=0),"",L45/F45)IF(OR(L45="",N(F45)+N(G45)=0),"",L45/(N(F45)+N(G45)))IF(OR(O45="",P45=""),"",P45-O45)IF(C45="","",IF(P45<>"","Paid",IF(O45<>"","Invoiced","Not invoiced")))
IF(COUNT(H46:K46)=0,"",SUM(H46:K46))IF(OR(L46="",N(F46)=0),"",L46/F46)IF(OR(L46="",N(F46)+N(G46)=0),"",L46/(N(F46)+N(G46)))IF(OR(O46="",P46=""),"",P46-O46)IF(C46="","",IF(P46<>"","Paid",IF(O46<>"","Invoiced","Not invoiced")))
IF(COUNT(H47:K47)=0,"",SUM(H47:K47))IF(OR(L47="",N(F47)=0),"",L47/F47)IF(OR(L47="",N(F47)+N(G47)=0),"",L47/(N(F47)+N(G47)))IF(OR(O47="",P47=""),"",P47-O47)IF(C47="","",IF(P47<>"","Paid",IF(O47<>"","Invoiced","Not invoiced")))
IF(COUNT(H48:K48)=0,"",SUM(H48:K48))IF(OR(L48="",N(F48)=0),"",L48/F48)IF(OR(L48="",N(F48)+N(G48)=0),"",L48/(N(F48)+N(G48)))IF(OR(O48="",P48=""),"",P48-O48)IF(C48="","",IF(P48<>"","Paid",IF(O48<>"","Invoiced","Not invoiced")))
IF(COUNT(H49:K49)=0,"",SUM(H49:K49))IF(OR(L49="",N(F49)=0),"",L49/F49)IF(OR(L49="",N(F49)+N(G49)=0),"",L49/(N(F49)+N(G49)))IF(OR(O49="",P49=""),"",P49-O49)IF(C49="","",IF(P49<>"","Paid",IF(O49<>"","Invoiced","Not invoiced")))
IF(COUNT(H50:K50)=0,"",SUM(H50:K50))IF(OR(L50="",N(F50)=0),"",L50/F50)IF(OR(L50="",N(F50)+N(G50)=0),"",L50/(N(F50)+N(G50)))IF(OR(O50="",P50=""),"",P50-O50)IF(C50="","",IF(P50<>"","Paid",IF(O50<>"","Invoiced","Not invoiced")))
IF(COUNT(H51:K51)=0,"",SUM(H51:K51))IF(OR(L51="",N(F51)=0),"",L51/F51)IF(OR(L51="",N(F51)+N(G51)=0),"",L51/(N(F51)+N(G51)))IF(OR(O51="",P51=""),"",P51-O51)IF(C51="","",IF(P51<>"","Paid",IF(O51<>"","Invoiced","Not invoiced")))
IF(COUNT(H52:K52)=0,"",SUM(H52:K52))IF(OR(L52="",N(F52)=0),"",L52/F52)IF(OR(L52="",N(F52)+N(G52)=0),"",L52/(N(F52)+N(G52)))IF(OR(O52="",P52=""),"",P52-O52)IF(C52="","",IF(P52<>"","Paid",IF(O52<>"","Invoiced","Not invoiced")))
IF(COUNT(H53:K53)=0,"",SUM(H53:K53))IF(OR(L53="",N(F53)=0),"",L53/F53)IF(OR(L53="",N(F53)+N(G53)=0),"",L53/(N(F53)+N(G53)))IF(OR(O53="",P53=""),"",P53-O53)IF(C53="","",IF(P53<>"","Paid",IF(O53<>"","Invoiced","Not invoiced")))
IF(COUNT(H54:K54)=0,"",SUM(H54:K54))IF(OR(L54="",N(F54)=0),"",L54/F54)IF(OR(L54="",N(F54)+N(G54)=0),"",L54/(N(F54)+N(G54)))IF(OR(O54="",P54=""),"",P54-O54)IF(C54="","",IF(P54<>"","Paid",IF(O54<>"","Invoiced","Not invoiced")))
IF(COUNT(H55:K55)=0,"",SUM(H55:K55))IF(OR(L55="",N(F55)=0),"",L55/F55)IF(OR(L55="",N(F55)+N(G55)=0),"",L55/(N(F55)+N(G55)))IF(OR(O55="",P55=""),"",P55-O55)IF(C55="","",IF(P55<>"","Paid",IF(O55<>"","Invoiced","Not invoiced")))
IF(COUNT(H56:K56)=0,"",SUM(H56:K56))IF(OR(L56="",N(F56)=0),"",L56/F56)IF(OR(L56="",N(F56)+N(G56)=0),"",L56/(N(F56)+N(G56)))IF(OR(O56="",P56=""),"",P56-O56)IF(C56="","",IF(P56<>"","Paid",IF(O56<>"","Invoiced","Not invoiced")))
IF(COUNT(H57:K57)=0,"",SUM(H57:K57))IF(OR(L57="",N(F57)=0),"",L57/F57)IF(OR(L57="",N(F57)+N(G57)=0),"",L57/(N(F57)+N(G57)))IF(OR(O57="",P57=""),"",P57-O57)IF(C57="","",IF(P57<>"","Paid",IF(O57<>"","Invoiced","Not invoiced")))
IF(COUNT(H58:K58)=0,"",SUM(H58:K58))IF(OR(L58="",N(F58)=0),"",L58/F58)IF(OR(L58="",N(F58)+N(G58)=0),"",L58/(N(F58)+N(G58)))IF(OR(O58="",P58=""),"",P58-O58)IF(C58="","",IF(P58<>"","Paid",IF(O58<>"","Invoiced","Not invoiced")))
IF(COUNT(H59:K59)=0,"",SUM(H59:K59))IF(OR(L59="",N(F59)=0),"",L59/F59)IF(OR(L59="",N(F59)+N(G59)=0),"",L59/(N(F59)+N(G59)))IF(OR(O59="",P59=""),"",P59-O59)IF(C59="","",IF(P59<>"","Paid",IF(O59<>"","Invoiced","Not invoiced")))
IF(COUNT(H60:K60)=0,"",SUM(H60:K60))IF(OR(L60="",N(F60)=0),"",L60/F60)IF(OR(L60="",N(F60)+N(G60)=0),"",L60/(N(F60)+N(G60)))IF(OR(O60="",P60=""),"",P60-O60)IF(C60="","",IF(P60<>"","Paid",IF(O60<>"","Invoiced","Not invoiced")))
IF(COUNT(H61:K61)=0,"",SUM(H61:K61))IF(OR(L61="",N(F61)=0),"",L61/F61)IF(OR(L61="",N(F61)+N(G61)=0),"",L61/(N(F61)+N(G61)))IF(OR(O61="",P61=""),"",P61-O61)IF(C61="","",IF(P61<>"","Paid",IF(O61<>"","Invoiced","Not invoiced")))
IF(COUNT(H62:K62)=0,"",SUM(H62:K62))IF(OR(L62="",N(F62)=0),"",L62/F62)IF(OR(L62="",N(F62)+N(G62)=0),"",L62/(N(F62)+N(G62)))IF(OR(O62="",P62=""),"",P62-O62)IF(C62="","",IF(P62<>"","Paid",IF(O62<>"","Invoiced","Not invoiced")))
IF(COUNT(H63:K63)=0,"",SUM(H63:K63))IF(OR(L63="",N(F63)=0),"",L63/F63)IF(OR(L63="",N(F63)+N(G63)=0),"",L63/(N(F63)+N(G63)))IF(OR(O63="",P63=""),"",P63-O63)IF(C63="","",IF(P63<>"","Paid",IF(O63<>"","Invoiced","Not invoiced")))
IF(COUNT(H64:K64)=0,"",SUM(H64:K64))IF(OR(L64="",N(F64)=0),"",L64/F64)IF(OR(L64="",N(F64)+N(G64)=0),"",L64/(N(F64)+N(G64)))IF(OR(O64="",P64=""),"",P64-O64)IF(C64="","",IF(P64<>"","Paid",IF(O64<>"","Invoiced","Not invoiced")))
IF(COUNT(H65:K65)=0,"",SUM(H65:K65))IF(OR(L65="",N(F65)=0),"",L65/F65)IF(OR(L65="",N(F65)+N(G65)=0),"",L65/(N(F65)+N(G65)))IF(OR(O65="",P65=""),"",P65-O65)IF(C65="","",IF(P65<>"","Paid",IF(O65<>"","Invoiced","Not invoiced")))
IF(COUNT(H66:K66)=0,"",SUM(H66:K66))IF(OR(L66="",N(F66)=0),"",L66/F66)IF(OR(L66="",N(F66)+N(G66)=0),"",L66/(N(F66)+N(G66)))IF(OR(O66="",P66=""),"",P66-O66)IF(C66="","",IF(P66<>"","Paid",IF(O66<>"","Invoiced","Not invoiced")))
IF(COUNT(H67:K67)=0,"",SUM(H67:K67))IF(OR(L67="",N(F67)=0),"",L67/F67)IF(OR(L67="",N(F67)+N(G67)=0),"",L67/(N(F67)+N(G67)))IF(OR(O67="",P67=""),"",P67-O67)IF(C67="","",IF(P67<>"","Paid",IF(O67<>"","Invoiced","Not invoiced")))
IF(COUNT(H68:K68)=0,"",SUM(H68:K68))IF(OR(L68="",N(F68)=0),"",L68/F68)IF(OR(L68="",N(F68)+N(G68)=0),"",L68/(N(F68)+N(G68)))IF(OR(O68="",P68=""),"",P68-O68)IF(C68="","",IF(P68<>"","Paid",IF(O68<>"","Invoiced","Not invoiced")))
IF(COUNT(H69:K69)=0,"",SUM(H69:K69))IF(OR(L69="",N(F69)=0),"",L69/F69)IF(OR(L69="",N(F69)+N(G69)=0),"",L69/(N(F69)+N(G69)))IF(OR(O69="",P69=""),"",P69-O69)IF(C69="","",IF(P69<>"","Paid",IF(O69<>"","Invoiced","Not invoiced")))
IF(COUNT(H70:K70)=0,"",SUM(H70:K70))IF(OR(L70="",N(F70)=0),"",L70/F70)IF(OR(L70="",N(F70)+N(G70)=0),"",L70/(N(F70)+N(G70)))IF(OR(O70="",P70=""),"",P70-O70)IF(C70="","",IF(P70<>"","Paid",IF(O70<>"","Invoiced","Not invoiced")))
IF(COUNT(H71:K71)=0,"",SUM(H71:K71))IF(OR(L71="",N(F71)=0),"",L71/F71)IF(OR(L71="",N(F71)+N(G71)=0),"",L71/(N(F71)+N(G71)))IF(OR(O71="",P71=""),"",P71-O71)IF(C71="","",IF(P71<>"","Paid",IF(O71<>"","Invoiced","Not invoiced")))
IF(COUNT(H72:K72)=0,"",SUM(H72:K72))IF(OR(L72="",N(F72)=0),"",L72/F72)IF(OR(L72="",N(F72)+N(G72)=0),"",L72/(N(F72)+N(G72)))IF(OR(O72="",P72=""),"",P72-O72)IF(C72="","",IF(P72<>"","Paid",IF(O72<>"","Invoiced","Not invoiced")))
IF(COUNT(H73:K73)=0,"",SUM(H73:K73))IF(OR(L73="",N(F73)=0),"",L73/F73)IF(OR(L73="",N(F73)+N(G73)=0),"",L73/(N(F73)+N(G73)))IF(OR(O73="",P73=""),"",P73-O73)IF(C73="","",IF(P73<>"","Paid",IF(O73<>"","Invoiced","Not invoiced")))
IF(COUNT(H74:K74)=0,"",SUM(H74:K74))IF(OR(L74="",N(F74)=0),"",L74/F74)IF(OR(L74="",N(F74)+N(G74)=0),"",L74/(N(F74)+N(G74)))IF(OR(O74="",P74=""),"",P74-O74)IF(C74="","",IF(P74<>"","Paid",IF(O74<>"","Invoiced","Not invoiced")))
IF(COUNT(H75:K75)=0,"",SUM(H75:K75))IF(OR(L75="",N(F75)=0),"",L75/F75)IF(OR(L75="",N(F75)+N(G75)=0),"",L75/(N(F75)+N(G75)))IF(OR(O75="",P75=""),"",P75-O75)IF(C75="","",IF(P75<>"","Paid",IF(O75<>"","Invoiced","Not invoiced")))
IF(COUNT(H76:K76)=0,"",SUM(H76:K76))IF(OR(L76="",N(F76)=0),"",L76/F76)IF(OR(L76="",N(F76)+N(G76)=0),"",L76/(N(F76)+N(G76)))IF(OR(O76="",P76=""),"",P76-O76)IF(C76="","",IF(P76<>"","Paid",IF(O76<>"","Invoiced","Not invoiced")))
IF(COUNT(H77:K77)=0,"",SUM(H77:K77))IF(OR(L77="",N(F77)=0),"",L77/F77)IF(OR(L77="",N(F77)+N(G77)=0),"",L77/(N(F77)+N(G77)))IF(OR(O77="",P77=""),"",P77-O77)IF(C77="","",IF(P77<>"","Paid",IF(O77<>"","Invoiced","Not invoiced")))
IF(COUNT(H78:K78)=0,"",SUM(H78:K78))IF(OR(L78="",N(F78)=0),"",L78/F78)IF(OR(L78="",N(F78)+N(G78)=0),"",L78/(N(F78)+N(G78)))IF(OR(O78="",P78=""),"",P78-O78)IF(C78="","",IF(P78<>"","Paid",IF(O78<>"","Invoiced","Not invoiced")))
IF(COUNT(H79:K79)=0,"",SUM(H79:K79))IF(OR(L79="",N(F79)=0),"",L79/F79)IF(OR(L79="",N(F79)+N(G79)=0),"",L79/(N(F79)+N(G79)))IF(OR(O79="",P79=""),"",P79-O79)IF(C79="","",IF(P79<>"","Paid",IF(O79<>"","Invoiced","Not invoiced")))
IF(COUNT(H80:K80)=0,"",SUM(H80:K80))IF(OR(L80="",N(F80)=0),"",L80/F80)IF(OR(L80="",N(F80)+N(G80)=0),"",L80/(N(F80)+N(G80)))IF(OR(O80="",P80=""),"",P80-O80)IF(C80="","",IF(P80<>"","Paid",IF(O80<>"","Invoiced","Not invoiced")))
IF(COUNT(H81:K81)=0,"",SUM(H81:K81))IF(OR(L81="",N(F81)=0),"",L81/F81)IF(OR(L81="",N(F81)+N(G81)=0),"",L81/(N(F81)+N(G81)))IF(OR(O81="",P81=""),"",P81-O81)IF(C81="","",IF(P81<>"","Paid",IF(O81<>"","Invoiced","Not invoiced")))
IF(COUNT(H82:K82)=0,"",SUM(H82:K82))IF(OR(L82="",N(F82)=0),"",L82/F82)IF(OR(L82="",N(F82)+N(G82)=0),"",L82/(N(F82)+N(G82)))IF(OR(O82="",P82=""),"",P82-O82)IF(C82="","",IF(P82<>"","Paid",IF(O82<>"","Invoiced","Not invoiced")))
IF(COUNT(H83:K83)=0,"",SUM(H83:K83))IF(OR(L83="",N(F83)=0),"",L83/F83)IF(OR(L83="",N(F83)+N(G83)=0),"",L83/(N(F83)+N(G83)))IF(OR(O83="",P83=""),"",P83-O83)IF(C83="","",IF(P83<>"","Paid",IF(O83<>"","Invoiced","Not invoiced")))
IF(COUNT(H84:K84)=0,"",SUM(H84:K84))IF(OR(L84="",N(F84)=0),"",L84/F84)IF(OR(L84="",N(F84)+N(G84)=0),"",L84/(N(F84)+N(G84)))IF(OR(O84="",P84=""),"",P84-O84)IF(C84="","",IF(P84<>"","Paid",IF(O84<>"","Invoiced","Not invoiced")))
IF(COUNT(H85:K85)=0,"",SUM(H85:K85))IF(OR(L85="",N(F85)=0),"",L85/F85)IF(OR(L85="",N(F85)+N(G85)=0),"",L85/(N(F85)+N(G85)))IF(OR(O85="",P85=""),"",P85-O85)IF(C85="","",IF(P85<>"","Paid",IF(O85<>"","Invoiced","Not invoiced")))
IF(COUNT(H86:K86)=0,"",SUM(H86:K86))IF(OR(L86="",N(F86)=0),"",L86/F86)IF(OR(L86="",N(F86)+N(G86)=0),"",L86/(N(F86)+N(G86)))IF(OR(O86="",P86=""),"",P86-O86)IF(C86="","",IF(P86<>"","Paid",IF(O86<>"","Invoiced","Not invoiced")))
IF(COUNT(H87:K87)=0,"",SUM(H87:K87))IF(OR(L87="",N(F87)=0),"",L87/F87)IF(OR(L87="",N(F87)+N(G87)=0),"",L87/(N(F87)+N(G87)))IF(OR(O87="",P87=""),"",P87-O87)IF(C87="","",IF(P87<>"","Paid",IF(O87<>"","Invoiced","Not invoiced")))
IF(COUNT(H88:K88)=0,"",SUM(H88:K88))IF(OR(L88="",N(F88)=0),"",L88/F88)IF(OR(L88="",N(F88)+N(G88)=0),"",L88/(N(F88)+N(G88)))IF(OR(O88="",P88=""),"",P88-O88)IF(C88="","",IF(P88<>"","Paid",IF(O88<>"","Invoiced","Not invoiced")))
IF(COUNT(H89:K89)=0,"",SUM(H89:K89))IF(OR(L89="",N(F89)=0),"",L89/F89)IF(OR(L89="",N(F89)+N(G89)=0),"",L89/(N(F89)+N(G89)))IF(OR(O89="",P89=""),"",P89-O89)IF(C89="","",IF(P89<>"","Paid",IF(O89<>"","Invoiced","Not invoiced")))
IF(COUNT(H90:K90)=0,"",SUM(H90:K90))IF(OR(L90="",N(F90)=0),"",L90/F90)IF(OR(L90="",N(F90)+N(G90)=0),"",L90/(N(F90)+N(G90)))IF(OR(O90="",P90=""),"",P90-O90)IF(C90="","",IF(P90<>"","Paid",IF(O90<>"","Invoiced","Not invoiced")))
IF(COUNT(H91:K91)=0,"",SUM(H91:K91))IF(OR(L91="",N(F91)=0),"",L91/F91)IF(OR(L91="",N(F91)+N(G91)=0),"",L91/(N(F91)+N(G91)))IF(OR(O91="",P91=""),"",P91-O91)IF(C91="","",IF(P91<>"","Paid",IF(O91<>"","Invoiced","Not invoiced")))
IF(COUNT(H92:K92)=0,"",SUM(H92:K92))IF(OR(L92="",N(F92)=0),"",L92/F92)IF(OR(L92="",N(F92)+N(G92)=0),"",L92/(N(F92)+N(G92)))IF(OR(O92="",P92=""),"",P92-O92)IF(C92="","",IF(P92<>"","Paid",IF(O92<>"","Invoiced","Not invoiced")))
IF(COUNT(H93:K93)=0,"",SUM(H93:K93))IF(OR(L93="",N(F93)=0),"",L93/F93)IF(OR(L93="",N(F93)+N(G93)=0),"",L93/(N(F93)+N(G93)))IF(OR(O93="",P93=""),"",P93-O93)IF(C93="","",IF(P93<>"","Paid",IF(O93<>"","Invoiced","Not invoiced")))
IF(COUNT(H94:K94)=0,"",SUM(H94:K94))IF(OR(L94="",N(F94)=0),"",L94/F94)IF(OR(L94="",N(F94)+N(G94)=0),"",L94/(N(F94)+N(G94)))IF(OR(O94="",P94=""),"",P94-O94)IF(C94="","",IF(P94<>"","Paid",IF(O94<>"","Invoiced","Not invoiced")))
IF(COUNT(H95:K95)=0,"",SUM(H95:K95))IF(OR(L95="",N(F95)=0),"",L95/F95)IF(OR(L95="",N(F95)+N(G95)=0),"",L95/(N(F95)+N(G95)))IF(OR(O95="",P95=""),"",P95-O95)IF(C95="","",IF(P95<>"","Paid",IF(O95<>"","Invoiced","Not invoiced")))
IF(COUNT(H96:K96)=0,"",SUM(H96:K96))IF(OR(L96="",N(F96)=0),"",L96/F96)IF(OR(L96="",N(F96)+N(G96)=0),"",L96/(N(F96)+N(G96)))IF(OR(O96="",P96=""),"",P96-O96)IF(C96="","",IF(P96<>"","Paid",IF(O96<>"","Invoiced","Not invoiced")))
IF(COUNT(H97:K97)=0,"",SUM(H97:K97))IF(OR(L97="",N(F97)=0),"",L97/F97)IF(OR(L97="",N(F97)+N(G97)=0),"",L97/(N(F97)+N(G97)))IF(OR(O97="",P97=""),"",P97-O97)IF(C97="","",IF(P97<>"","Paid",IF(O97<>"","Invoiced","Not invoiced")))
IF(COUNT(H98:K98)=0,"",SUM(H98:K98))IF(OR(L98="",N(F98)=0),"",L98/F98)IF(OR(L98="",N(F98)+N(G98)=0),"",L98/(N(F98)+N(G98)))IF(OR(O98="",P98=""),"",P98-O98)IF(C98="","",IF(P98<>"","Paid",IF(O98<>"","Invoiced","Not invoiced")))
IF(COUNT(H99:K99)=0,"",SUM(H99:K99))IF(OR(L99="",N(F99)=0),"",L99/F99)IF(OR(L99="",N(F99)+N(G99)=0),"",L99/(N(F99)+N(G99)))IF(OR(O99="",P99=""),"",P99-O99)IF(C99="","",IF(P99<>"","Paid",IF(O99<>"","Invoiced","Not invoiced")))
IF(COUNT(H100:K100)=0,"",SUM(H100:K100))IF(OR(L100="",N(F100)=0),"",L100/F100)IF(OR(L100="",N(F100)+N(G100)=0),"",L100/(N(F100)+N(G100)))IF(OR(O100="",P100=""),"",P100-O100)IF(C100="","",IF(P100<>"","Paid",IF(O100<>"","Invoiced","Not invoiced")))
IF(COUNT(H101:K101)=0,"",SUM(H101:K101))IF(OR(L101="",N(F101)=0),"",L101/F101)IF(OR(L101="",N(F101)+N(G101)=0),"",L101/(N(F101)+N(G101)))IF(OR(O101="",P101=""),"",P101-O101)IF(C101="","",IF(P101<>"","Paid",IF(O101<>"","Invoiced","Not invoiced")))
IF(COUNT(H102:K102)=0,"",SUM(H102:K102))IF(OR(L102="",N(F102)=0),"",L102/F102)IF(OR(L102="",N(F102)+N(G102)=0),"",L102/(N(F102)+N(G102)))IF(OR(O102="",P102=""),"",P102-O102)IF(C102="","",IF(P102<>"","Paid",IF(O102<>"","Invoiced","Not invoiced")))
IF(COUNT(H103:K103)=0,"",SUM(H103:K103))IF(OR(L103="",N(F103)=0),"",L103/F103)IF(OR(L103="",N(F103)+N(G103)=0),"",L103/(N(F103)+N(G103)))IF(OR(O103="",P103=""),"",P103-O103)IF(C103="","",IF(P103<>"","Paid",IF(O103<>"","Invoiced","Not invoiced")))
IF(COUNT(H104:K104)=0,"",SUM(H104:K104))IF(OR(L104="",N(F104)=0),"",L104/F104)IF(OR(L104="",N(F104)+N(G104)=0),"",L104/(N(F104)+N(G104)))IF(OR(O104="",P104=""),"",P104-O104)IF(C104="","",IF(P104<>"","Paid",IF(O104<>"","Invoiced","Not invoiced")))
IF(COUNT(H105:K105)=0,"",SUM(H105:K105))IF(OR(L105="",N(F105)=0),"",L105/F105)IF(OR(L105="",N(F105)+N(G105)=0),"",L105/(N(F105)+N(G105)))IF(OR(O105="",P105=""),"",P105-O105)IF(C105="","",IF(P105<>"","Paid",IF(O105<>"","Invoiced","Not invoiced")))
IF(COUNT(H106:K106)=0,"",SUM(H106:K106))IF(OR(L106="",N(F106)=0),"",L106/F106)IF(OR(L106="",N(F106)+N(G106)=0),"",L106/(N(F106)+N(G106)))IF(OR(O106="",P106=""),"",P106-O106)IF(C106="","",IF(P106<>"","Paid",IF(O106<>"","Invoiced","Not invoiced")))
IF(COUNT(H107:K107)=0,"",SUM(H107:K107))IF(OR(L107="",N(F107)=0),"",L107/F107)IF(OR(L107="",N(F107)+N(G107)=0),"",L107/(N(F107)+N(G107)))IF(OR(O107="",P107=""),"",P107-O107)IF(C107="","",IF(P107<>"","Paid",IF(O107<>"","Invoiced","Not invoiced")))
IF(COUNT(H108:K108)=0,"",SUM(H108:K108))IF(OR(L108="",N(F108)=0),"",L108/F108)IF(OR(L108="",N(F108)+N(G108)=0),"",L108/(N(F108)+N(G108)))IF(OR(O108="",P108=""),"",P108-O108)IF(C108="","",IF(P108<>"","Paid",IF(O108<>"","Invoiced","Not invoiced")))
IF(COUNT(H109:K109)=0,"",SUM(H109:K109))IF(OR(L109="",N(F109)=0),"",L109/F109)IF(OR(L109="",N(F109)+N(G109)=0),"",L109/(N(F109)+N(G109)))IF(OR(O109="",P109=""),"",P109-O109)IF(C109="","",IF(P109<>"","Paid",IF(O109<>"","Invoiced","Not invoiced")))
IF(COUNT(H110:K110)=0,"",SUM(H110:K110))IF(OR(L110="",N(F110)=0),"",L110/F110)IF(OR(L110="",N(F110)+N(G110)=0),"",L110/(N(F110)+N(G110)))IF(OR(O110="",P110=""),"",P110-O110)IF(C110="","",IF(P110<>"","Paid",IF(O110<>"","Invoiced","Not invoiced")))
IF(COUNT(H111:K111)=0,"",SUM(H111:K111))IF(OR(L111="",N(F111)=0),"",L111/F111)IF(OR(L111="",N(F111)+N(G111)=0),"",L111/(N(F111)+N(G111)))IF(OR(O111="",P111=""),"",P111-O111)IF(C111="","",IF(P111<>"","Paid",IF(O111<>"","Invoiced","Not invoiced")))
IF(COUNT(H112:K112)=0,"",SUM(H112:K112))IF(OR(L112="",N(F112)=0),"",L112/F112)IF(OR(L112="",N(F112)+N(G112)=0),"",L112/(N(F112)+N(G112)))IF(OR(O112="",P112=""),"",P112-O112)IF(C112="","",IF(P112<>"","Paid",IF(O112<>"","Invoiced","Not invoiced")))
IF(COUNT(H113:K113)=0,"",SUM(H113:K113))IF(OR(L113="",N(F113)=0),"",L113/F113)IF(OR(L113="",N(F113)+N(G113)=0),"",L113/(N(F113)+N(G113)))IF(OR(O113="",P113=""),"",P113-O113)IF(C113="","",IF(P113<>"","Paid",IF(O113<>"","Invoiced","Not invoiced")))
IF(COUNT(H114:K114)=0,"",SUM(H114:K114))IF(OR(L114="",N(F114)=0),"",L114/F114)IF(OR(L114="",N(F114)+N(G114)=0),"",L114/(N(F114)+N(G114)))IF(OR(O114="",P114=""),"",P114-O114)IF(C114="","",IF(P114<>"","Paid",IF(O114<>"","Invoiced","Not invoiced")))
IF(COUNT(H115:K115)=0,"",SUM(H115:K115))IF(OR(L115="",N(F115)=0),"",L115/F115)IF(OR(L115="",N(F115)+N(G115)=0),"",L115/(N(F115)+N(G115)))IF(OR(O115="",P115=""),"",P115-O115)IF(C115="","",IF(P115<>"","Paid",IF(O115<>"","Invoiced","Not invoiced")))
IF(COUNT(H116:K116)=0,"",SUM(H116:K116))IF(OR(L116="",N(F116)=0),"",L116/F116)IF(OR(L116="",N(F116)+N(G116)=0),"",L116/(N(F116)+N(G116)))IF(OR(O116="",P116=""),"",P116-O116)IF(C116="","",IF(P116<>"","Paid",IF(O116<>"","Invoiced","Not invoiced")))
IF(COUNT(H117:K117)=0,"",SUM(H117:K117))IF(OR(L117="",N(F117)=0),"",L117/F117)IF(OR(L117="",N(F117)+N(G117)=0),"",L117/(N(F117)+N(G117)))IF(OR(O117="",P117=""),"",P117-O117)IF(C117="","",IF(P117<>"","Paid",IF(O117<>"","Invoiced","Not invoiced")))
IF(COUNT(H118:K118)=0,"",SUM(H118:K118))IF(OR(L118="",N(F118)=0),"",L118/F118)IF(OR(L118="",N(F118)+N(G118)=0),"",L118/(N(F118)+N(G118)))IF(OR(O118="",P118=""),"",P118-O118)IF(C118="","",IF(P118<>"","Paid",IF(O118<>"","Invoiced","Not invoiced")))
IF(COUNT(H119:K119)=0,"",SUM(H119:K119))IF(OR(L119="",N(F119)=0),"",L119/F119)IF(OR(L119="",N(F119)+N(G119)=0),"",L119/(N(F119)+N(G119)))IF(OR(O119="",P119=""),"",P119-O119)IF(C119="","",IF(P119<>"","Paid",IF(O119<>"","Invoiced","Not invoiced")))
IF(COUNT(H120:K120)=0,"",SUM(H120:K120))IF(OR(L120="",N(F120)=0),"",L120/F120)IF(OR(L120="",N(F120)+N(G120)=0),"",L120/(N(F120)+N(G120)))IF(OR(O120="",P120=""),"",P120-O120)IF(C120="","",IF(P120<>"","Paid",IF(O120<>"","Invoiced","Not invoiced")))
IF(COUNT(H121:K121)=0,"",SUM(H121:K121))IF(OR(L121="",N(F121)=0),"",L121/F121)IF(OR(L121="",N(F121)+N(G121)=0),"",L121/(N(F121)+N(G121)))IF(OR(O121="",P121=""),"",P121-O121)IF(C121="","",IF(P121<>"","Paid",IF(O121<>"","Invoiced","Not invoiced")))
IF(COUNT(H122:K122)=0,"",SUM(H122:K122))IF(OR(L122="",N(F122)=0),"",L122/F122)IF(OR(L122="",N(F122)+N(G122)=0),"",L122/(N(F122)+N(G122)))IF(OR(O122="",P122=""),"",P122-O122)IF(C122="","",IF(P122<>"","Paid",IF(O122<>"","Invoiced","Not invoiced")))
IF(COUNT(H123:K123)=0,"",SUM(H123:K123))IF(OR(L123="",N(F123)=0),"",L123/F123)IF(OR(L123="",N(F123)+N(G123)=0),"",L123/(N(F123)+N(G123)))IF(OR(O123="",P123=""),"",P123-O123)IF(C123="","",IF(P123<>"","Paid",IF(O123<>"","Invoiced","Not invoiced")))
IF(COUNT(H124:K124)=0,"",SUM(H124:K124))IF(OR(L124="",N(F124)=0),"",L124/F124)IF(OR(L124="",N(F124)+N(G124)=0),"",L124/(N(F124)+N(G124)))IF(OR(O124="",P124=""),"",P124-O124)IF(C124="","",IF(P124<>"","Paid",IF(O124<>"","Invoiced","Not invoiced")))
IF(COUNT(H125:K125)=0,"",SUM(H125:K125))IF(OR(L125="",N(F125)=0),"",L125/F125)IF(OR(L125="",N(F125)+N(G125)=0),"",L125/(N(F125)+N(G125)))IF(OR(O125="",P125=""),"",P125-O125)IF(C125="","",IF(P125<>"","Paid",IF(O125<>"","Invoiced","Not invoiced")))
IF(COUNT(H126:K126)=0,"",SUM(H126:K126))IF(OR(L126="",N(F126)=0),"",L126/F126)IF(OR(L126="",N(F126)+N(G126)=0),"",L126/(N(F126)+N(G126)))IF(OR(O126="",P126=""),"",P126-O126)IF(C126="","",IF(P126<>"","Paid",IF(O126<>"","Invoiced","Not invoiced")))
IF(COUNT(H127:K127)=0,"",SUM(H127:K127))IF(OR(L127="",N(F127)=0),"",L127/F127)IF(OR(L127="",N(F127)+N(G127)=0),"",L127/(N(F127)+N(G127)))IF(OR(O127="",P127=""),"",P127-O127)IF(C127="","",IF(P127<>"","Paid",IF(O127<>"","Invoiced","Not invoiced")))
IF(COUNT(H128:K128)=0,"",SUM(H128:K128))IF(OR(L128="",N(F128)=0),"",L128/F128)IF(OR(L128="",N(F128)+N(G128)=0),"",L128/(N(F128)+N(G128)))IF(OR(O128="",P128=""),"",P128-O128)IF(C128="","",IF(P128<>"","Paid",IF(O128<>"","Invoiced","Not invoiced")))
IF(COUNT(H129:K129)=0,"",SUM(H129:K129))IF(OR(L129="",N(F129)=0),"",L129/F129)IF(OR(L129="",N(F129)+N(G129)=0),"",L129/(N(F129)+N(G129)))IF(OR(O129="",P129=""),"",P129-O129)IF(C129="","",IF(P129<>"","Paid",IF(O129<>"","Invoiced","Not invoiced")))
IF(COUNT(H130:K130)=0,"",SUM(H130:K130))IF(OR(L130="",N(F130)=0),"",L130/F130)IF(OR(L130="",N(F130)+N(G130)=0),"",L130/(N(F130)+N(G130)))IF(OR(O130="",P130=""),"",P130-O130)IF(C130="","",IF(P130<>"","Paid",IF(O130<>"","Invoiced","Not invoiced")))
IF(COUNT(H131:K131)=0,"",SUM(H131:K131))IF(OR(L131="",N(F131)=0),"",L131/F131)IF(OR(L131="",N(F131)+N(G131)=0),"",L131/(N(F131)+N(G131)))IF(OR(O131="",P131=""),"",P131-O131)IF(C131="","",IF(P131<>"","Paid",IF(O131<>"","Invoiced","Not invoiced")))
IF(COUNT(H132:K132)=0,"",SUM(H132:K132))IF(OR(L132="",N(F132)=0),"",L132/F132)IF(OR(L132="",N(F132)+N(G132)=0),"",L132/(N(F132)+N(G132)))IF(OR(O132="",P132=""),"",P132-O132)IF(C132="","",IF(P132<>"","Paid",IF(O132<>"","Invoiced","Not invoiced")))
IF(COUNT(H133:K133)=0,"",SUM(H133:K133))IF(OR(L133="",N(F133)=0),"",L133/F133)IF(OR(L133="",N(F133)+N(G133)=0),"",L133/(N(F133)+N(G133)))IF(OR(O133="",P133=""),"",P133-O133)IF(C133="","",IF(P133<>"","Paid",IF(O133<>"","Invoiced","Not invoiced")))
IF(COUNT(H134:K134)=0,"",SUM(H134:K134))IF(OR(L134="",N(F134)=0),"",L134/F134)IF(OR(L134="",N(F134)+N(G134)=0),"",L134/(N(F134)+N(G134)))IF(OR(O134="",P134=""),"",P134-O134)IF(C134="","",IF(P134<>"","Paid",IF(O134<>"","Invoiced","Not invoiced")))
IF(COUNT(H135:K135)=0,"",SUM(H135:K135))IF(OR(L135="",N(F135)=0),"",L135/F135)IF(OR(L135="",N(F135)+N(G135)=0),"",L135/(N(F135)+N(G135)))IF(OR(O135="",P135=""),"",P135-O135)IF(C135="","",IF(P135<>"","Paid",IF(O135<>"","Invoiced","Not invoiced")))
IF(COUNT(H136:K136)=0,"",SUM(H136:K136))IF(OR(L136="",N(F136)=0),"",L136/F136)IF(OR(L136="",N(F136)+N(G136)=0),"",L136/(N(F136)+N(G136)))IF(OR(O136="",P136=""),"",P136-O136)IF(C136="","",IF(P136<>"","Paid",IF(O136<>"","Invoiced","Not invoiced")))
IF(COUNT(H137:K137)=0,"",SUM(H137:K137))IF(OR(L137="",N(F137)=0),"",L137/F137)IF(OR(L137="",N(F137)+N(G137)=0),"",L137/(N(F137)+N(G137)))IF(OR(O137="",P137=""),"",P137-O137)IF(C137="","",IF(P137<>"","Paid",IF(O137<>"","Invoiced","Not invoiced")))
IF(COUNT(H138:K138)=0,"",SUM(H138:K138))IF(OR(L138="",N(F138)=0),"",L138/F138)IF(OR(L138="",N(F138)+N(G138)=0),"",L138/(N(F138)+N(G138)))IF(OR(O138="",P138=""),"",P138-O138)IF(C138="","",IF(P138<>"","Paid",IF(O138<>"","Invoiced","Not invoiced")))
IF(COUNT(H139:K139)=0,"",SUM(H139:K139))IF(OR(L139="",N(F139)=0),"",L139/F139)IF(OR(L139="",N(F139)+N(G139)=0),"",L139/(N(F139)+N(G139)))IF(OR(O139="",P139=""),"",P139-O139)IF(C139="","",IF(P139<>"","Paid",IF(O139<>"","Invoiced","Not invoiced")))
IF(COUNT(H140:K140)=0,"",SUM(H140:K140))IF(OR(L140="",N(F140)=0),"",L140/F140)IF(OR(L140="",N(F140)+N(G140)=0),"",L140/(N(F140)+N(G140)))IF(OR(O140="",P140=""),"",P140-O140)IF(C140="","",IF(P140<>"","Paid",IF(O140<>"","Invoiced","Not invoiced")))
IF(COUNT(H141:K141)=0,"",SUM(H141:K141))IF(OR(L141="",N(F141)=0),"",L141/F141)IF(OR(L141="",N(F141)+N(G141)=0),"",L141/(N(F141)+N(G141)))IF(OR(O141="",P141=""),"",P141-O141)IF(C141="","",IF(P141<>"","Paid",IF(O141<>"","Invoiced","Not invoiced")))
IF(COUNT(H142:K142)=0,"",SUM(H142:K142))IF(OR(L142="",N(F142)=0),"",L142/F142)IF(OR(L142="",N(F142)+N(G142)=0),"",L142/(N(F142)+N(G142)))IF(OR(O142="",P142=""),"",P142-O142)IF(C142="","",IF(P142<>"","Paid",IF(O142<>"","Invoiced","Not invoiced")))
IF(COUNT(H143:K143)=0,"",SUM(H143:K143))IF(OR(L143="",N(F143)=0),"",L143/F143)IF(OR(L143="",N(F143)+N(G143)=0),"",L143/(N(F143)+N(G143)))IF(OR(O143="",P143=""),"",P143-O143)IF(C143="","",IF(P143<>"","Paid",IF(O143<>"","Invoiced","Not invoiced")))
IF(COUNT(H144:K144)=0,"",SUM(H144:K144))IF(OR(L144="",N(F144)=0),"",L144/F144)IF(OR(L144="",N(F144)+N(G144)=0),"",L144/(N(F144)+N(G144)))IF(OR(O144="",P144=""),"",P144-O144)IF(C144="","",IF(P144<>"","Paid",IF(O144<>"","Invoiced","Not invoiced")))
IF(COUNT(H145:K145)=0,"",SUM(H145:K145))IF(OR(L145="",N(F145)=0),"",L145/F145)IF(OR(L145="",N(F145)+N(G145)=0),"",L145/(N(F145)+N(G145)))IF(OR(O145="",P145=""),"",P145-O145)IF(C145="","",IF(P145<>"","Paid",IF(O145<>"","Invoiced","Not invoiced")))
IF(COUNT(H146:K146)=0,"",SUM(H146:K146))IF(OR(L146="",N(F146)=0),"",L146/F146)IF(OR(L146="",N(F146)+N(G146)=0),"",L146/(N(F146)+N(G146)))IF(OR(O146="",P146=""),"",P146-O146)IF(C146="","",IF(P146<>"","Paid",IF(O146<>"","Invoiced","Not invoiced")))
IF(COUNT(H147:K147)=0,"",SUM(H147:K147))IF(OR(L147="",N(F147)=0),"",L147/F147)IF(OR(L147="",N(F147)+N(G147)=0),"",L147/(N(F147)+N(G147)))IF(OR(O147="",P147=""),"",P147-O147)IF(C147="","",IF(P147<>"","Paid",IF(O147<>"","Invoiced","Not invoiced")))
IF(COUNT(H148:K148)=0,"",SUM(H148:K148))IF(OR(L148="",N(F148)=0),"",L148/F148)IF(OR(L148="",N(F148)+N(G148)=0),"",L148/(N(F148)+N(G148)))IF(OR(O148="",P148=""),"",P148-O148)IF(C148="","",IF(P148<>"","Paid",IF(O148<>"","Invoiced","Not invoiced")))
IF(COUNT(H149:K149)=0,"",SUM(H149:K149))IF(OR(L149="",N(F149)=0),"",L149/F149)IF(OR(L149="",N(F149)+N(G149)=0),"",L149/(N(F149)+N(G149)))IF(OR(O149="",P149=""),"",P149-O149)IF(C149="","",IF(P149<>"","Paid",IF(O149<>"","Invoiced","Not invoiced")))
IF(COUNT(H150:K150)=0,"",SUM(H150:K150))IF(OR(L150="",N(F150)=0),"",L150/F150)IF(OR(L150="",N(F150)+N(G150)=0),"",L150/(N(F150)+N(G150)))IF(OR(O150="",P150=""),"",P150-O150)IF(C150="","",IF(P150<>"","Paid",IF(O150<>"","Invoiced","Not invoiced")))
IF(COUNT(H151:K151)=0,"",SUM(H151:K151))IF(OR(L151="",N(F151)=0),"",L151/F151)IF(OR(L151="",N(F151)+N(G151)=0),"",L151/(N(F151)+N(G151)))IF(OR(O151="",P151=""),"",P151-O151)IF(C151="","",IF(P151<>"","Paid",IF(O151<>"","Invoiced","Not invoiced")))
IF(COUNT(H152:K152)=0,"",SUM(H152:K152))IF(OR(L152="",N(F152)=0),"",L152/F152)IF(OR(L152="",N(F152)+N(G152)=0),"",L152/(N(F152)+N(G152)))IF(OR(O152="",P152=""),"",P152-O152)IF(C152="","",IF(P152<>"","Paid",IF(O152<>"","Invoiced","Not invoiced")))
IF(COUNT(H153:K153)=0,"",SUM(H153:K153))IF(OR(L153="",N(F153)=0),"",L153/F153)IF(OR(L153="",N(F153)+N(G153)=0),"",L153/(N(F153)+N(G153)))IF(OR(O153="",P153=""),"",P153-O153)IF(C153="","",IF(P153<>"","Paid",IF(O153<>"","Invoiced","Not invoiced")))
IF(COUNT(H154:K154)=0,"",SUM(H154:K154))IF(OR(L154="",N(F154)=0),"",L154/F154)IF(OR(L154="",N(F154)+N(G154)=0),"",L154/(N(F154)+N(G154)))IF(OR(O154="",P154=""),"",P154-O154)IF(C154="","",IF(P154<>"","Paid",IF(O154<>"","Invoiced","Not invoiced")))
IF(COUNT(H155:K155)=0,"",SUM(H155:K155))IF(OR(L155="",N(F155)=0),"",L155/F155)IF(OR(L155="",N(F155)+N(G155)=0),"",L155/(N(F155)+N(G155)))IF(OR(O155="",P155=""),"",P155-O155)IF(C155="","",IF(P155<>"","Paid",IF(O155<>"","Invoiced","Not invoiced")))
IF(COUNT(H156:K156)=0,"",SUM(H156:K156))IF(OR(L156="",N(F156)=0),"",L156/F156)IF(OR(L156="",N(F156)+N(G156)=0),"",L156/(N(F156)+N(G156)))IF(OR(O156="",P156=""),"",P156-O156)IF(C156="","",IF(P156<>"","Paid",IF(O156<>"","Invoiced","Not invoiced")))
IF(COUNT(H157:K157)=0,"",SUM(H157:K157))IF(OR(L157="",N(F157)=0),"",L157/F157)IF(OR(L157="",N(F157)+N(G157)=0),"",L157/(N(F157)+N(G157)))IF(OR(O157="",P157=""),"",P157-O157)IF(C157="","",IF(P157<>"","Paid",IF(O157<>"","Invoiced","Not invoiced")))
IF(COUNT(H158:K158)=0,"",SUM(H158:K158))IF(OR(L158="",N(F158)=0),"",L158/F158)IF(OR(L158="",N(F158)+N(G158)=0),"",L158/(N(F158)+N(G158)))IF(OR(O158="",P158=""),"",P158-O158)IF(C158="","",IF(P158<>"","Paid",IF(O158<>"","Invoiced","Not invoiced")))
IF(COUNT(H159:K159)=0,"",SUM(H159:K159))IF(OR(L159="",N(F159)=0),"",L159/F159)IF(OR(L159="",N(F159)+N(G159)=0),"",L159/(N(F159)+N(G159)))IF(OR(O159="",P159=""),"",P159-O159)IF(C159="","",IF(P159<>"","Paid",IF(O159<>"","Invoiced","Not invoiced")))
IF(COUNT(H160:K160)=0,"",SUM(H160:K160))IF(OR(L160="",N(F160)=0),"",L160/F160)IF(OR(L160="",N(F160)+N(G160)=0),"",L160/(N(F160)+N(G160)))IF(OR(O160="",P160=""),"",P160-O160)IF(C160="","",IF(P160<>"","Paid",IF(O160<>"","Invoiced","Not invoiced")))
IF(COUNT(H161:K161)=0,"",SUM(H161:K161))IF(OR(L161="",N(F161)=0),"",L161/F161)IF(OR(L161="",N(F161)+N(G161)=0),"",L161/(N(F161)+N(G161)))IF(OR(O161="",P161=""),"",P161-O161)IF(C161="","",IF(P161<>"","Paid",IF(O161<>"","Invoiced","Not invoiced")))
IF(COUNT(H162:K162)=0,"",SUM(H162:K162))IF(OR(L162="",N(F162)=0),"",L162/F162)IF(OR(L162="",N(F162)+N(G162)=0),"",L162/(N(F162)+N(G162)))IF(OR(O162="",P162=""),"",P162-O162)IF(C162="","",IF(P162<>"","Paid",IF(O162<>"","Invoiced","Not invoiced")))
IF(COUNT(H163:K163)=0,"",SUM(H163:K163))IF(OR(L163="",N(F163)=0),"",L163/F163)IF(OR(L163="",N(F163)+N(G163)=0),"",L163/(N(F163)+N(G163)))IF(OR(O163="",P163=""),"",P163-O163)IF(C163="","",IF(P163<>"","Paid",IF(O163<>"","Invoiced","Not invoiced")))
IF(COUNT(H164:K164)=0,"",SUM(H164:K164))IF(OR(L164="",N(F164)=0),"",L164/F164)IF(OR(L164="",N(F164)+N(G164)=0),"",L164/(N(F164)+N(G164)))IF(OR(O164="",P164=""),"",P164-O164)IF(C164="","",IF(P164<>"","Paid",IF(O164<>"","Invoiced","Not invoiced")))
IF(COUNT(H165:K165)=0,"",SUM(H165:K165))IF(OR(L165="",N(F165)=0),"",L165/F165)IF(OR(L165="",N(F165)+N(G165)=0),"",L165/(N(F165)+N(G165)))IF(OR(O165="",P165=""),"",P165-O165)IF(C165="","",IF(P165<>"","Paid",IF(O165<>"","Invoiced","Not invoiced")))
IF(COUNT(H166:K166)=0,"",SUM(H166:K166))IF(OR(L166="",N(F166)=0),"",L166/F166)IF(OR(L166="",N(F166)+N(G166)=0),"",L166/(N(F166)+N(G166)))IF(OR(O166="",P166=""),"",P166-O166)IF(C166="","",IF(P166<>"","Paid",IF(O166<>"","Invoiced","Not invoiced")))
IF(COUNT(H167:K167)=0,"",SUM(H167:K167))IF(OR(L167="",N(F167)=0),"",L167/F167)IF(OR(L167="",N(F167)+N(G167)=0),"",L167/(N(F167)+N(G167)))IF(OR(O167="",P167=""),"",P167-O167)IF(C167="","",IF(P167<>"","Paid",IF(O167<>"","Invoiced","Not invoiced")))
IF(COUNT(H168:K168)=0,"",SUM(H168:K168))IF(OR(L168="",N(F168)=0),"",L168/F168)IF(OR(L168="",N(F168)+N(G168)=0),"",L168/(N(F168)+N(G168)))IF(OR(O168="",P168=""),"",P168-O168)IF(C168="","",IF(P168<>"","Paid",IF(O168<>"","Invoiced","Not invoiced")))
IF(COUNT(H169:K169)=0,"",SUM(H169:K169))IF(OR(L169="",N(F169)=0),"",L169/F169)IF(OR(L169="",N(F169)+N(G169)=0),"",L169/(N(F169)+N(G169)))IF(OR(O169="",P169=""),"",P169-O169)IF(C169="","",IF(P169<>"","Paid",IF(O169<>"","Invoiced","Not invoiced")))
IF(COUNT(H170:K170)=0,"",SUM(H170:K170))IF(OR(L170="",N(F170)=0),"",L170/F170)IF(OR(L170="",N(F170)+N(G170)=0),"",L170/(N(F170)+N(G170)))IF(OR(O170="",P170=""),"",P170-O170)IF(C170="","",IF(P170<>"","Paid",IF(O170<>"","Invoiced","Not invoiced")))
IF(COUNT(H171:K171)=0,"",SUM(H171:K171))IF(OR(L171="",N(F171)=0),"",L171/F171)IF(OR(L171="",N(F171)+N(G171)=0),"",L171/(N(F171)+N(G171)))IF(OR(O171="",P171=""),"",P171-O171)IF(C171="","",IF(P171<>"","Paid",IF(O171<>"","Invoiced","Not invoiced")))
IF(COUNT(H172:K172)=0,"",SUM(H172:K172))IF(OR(L172="",N(F172)=0),"",L172/F172)IF(OR(L172="",N(F172)+N(G172)=0),"",L172/(N(F172)+N(G172)))IF(OR(O172="",P172=""),"",P172-O172)IF(C172="","",IF(P172<>"","Paid",IF(O172<>"","Invoiced","Not invoiced")))
IF(COUNT(H173:K173)=0,"",SUM(H173:K173))IF(OR(L173="",N(F173)=0),"",L173/F173)IF(OR(L173="",N(F173)+N(G173)=0),"",L173/(N(F173)+N(G173)))IF(OR(O173="",P173=""),"",P173-O173)IF(C173="","",IF(P173<>"","Paid",IF(O173<>"","Invoiced","Not invoiced")))
IF(COUNT(H174:K174)=0,"",SUM(H174:K174))IF(OR(L174="",N(F174)=0),"",L174/F174)IF(OR(L174="",N(F174)+N(G174)=0),"",L174/(N(F174)+N(G174)))IF(OR(O174="",P174=""),"",P174-O174)IF(C174="","",IF(P174<>"","Paid",IF(O174<>"","Invoiced","Not invoiced")))
IF(COUNT(H175:K175)=0,"",SUM(H175:K175))IF(OR(L175="",N(F175)=0),"",L175/F175)IF(OR(L175="",N(F175)+N(G175)=0),"",L175/(N(F175)+N(G175)))IF(OR(O175="",P175=""),"",P175-O175)IF(C175="","",IF(P175<>"","Paid",IF(O175<>"","Invoiced","Not invoiced")))
IF(COUNT(H176:K176)=0,"",SUM(H176:K176))IF(OR(L176="",N(F176)=0),"",L176/F176)IF(OR(L176="",N(F176)+N(G176)=0),"",L176/(N(F176)+N(G176)))IF(OR(O176="",P176=""),"",P176-O176)IF(C176="","",IF(P176<>"","Paid",IF(O176<>"","Invoiced","Not invoiced")))
IF(COUNT(H177:K177)=0,"",SUM(H177:K177))IF(OR(L177="",N(F177)=0),"",L177/F177)IF(OR(L177="",N(F177)+N(G177)=0),"",L177/(N(F177)+N(G177)))IF(OR(O177="",P177=""),"",P177-O177)IF(C177="","",IF(P177<>"","Paid",IF(O177<>"","Invoiced","Not invoiced")))
IF(COUNT(H178:K178)=0,"",SUM(H178:K178))IF(OR(L178="",N(F178)=0),"",L178/F178)IF(OR(L178="",N(F178)+N(G178)=0),"",L178/(N(F178)+N(G178)))IF(OR(O178="",P178=""),"",P178-O178)IF(C178="","",IF(P178<>"","Paid",IF(O178<>"","Invoiced","Not invoiced")))
IF(COUNT(H179:K179)=0,"",SUM(H179:K179))IF(OR(L179="",N(F179)=0),"",L179/F179)IF(OR(L179="",N(F179)+N(G179)=0),"",L179/(N(F179)+N(G179)))IF(OR(O179="",P179=""),"",P179-O179)IF(C179="","",IF(P179<>"","Paid",IF(O179<>"","Invoiced","Not invoiced")))
IF(COUNT(H180:K180)=0,"",SUM(H180:K180))IF(OR(L180="",N(F180)=0),"",L180/F180)IF(OR(L180="",N(F180)+N(G180)=0),"",L180/(N(F180)+N(G180)))IF(OR(O180="",P180=""),"",P180-O180)IF(C180="","",IF(P180<>"","Paid",IF(O180<>"","Invoiced","Not invoiced")))
IF(COUNT(H181:K181)=0,"",SUM(H181:K181))IF(OR(L181="",N(F181)=0),"",L181/F181)IF(OR(L181="",N(F181)+N(G181)=0),"",L181/(N(F181)+N(G181)))IF(OR(O181="",P181=""),"",P181-O181)IF(C181="","",IF(P181<>"","Paid",IF(O181<>"","Invoiced","Not invoiced")))
IF(COUNT(H182:K182)=0,"",SUM(H182:K182))IF(OR(L182="",N(F182)=0),"",L182/F182)IF(OR(L182="",N(F182)+N(G182)=0),"",L182/(N(F182)+N(G182)))IF(OR(O182="",P182=""),"",P182-O182)IF(C182="","",IF(P182<>"","Paid",IF(O182<>"","Invoiced","Not invoiced")))
IF(COUNT(H183:K183)=0,"",SUM(H183:K183))IF(OR(L183="",N(F183)=0),"",L183/F183)IF(OR(L183="",N(F183)+N(G183)=0),"",L183/(N(F183)+N(G183)))IF(OR(O183="",P183=""),"",P183-O183)IF(C183="","",IF(P183<>"","Paid",IF(O183<>"","Invoiced","Not invoiced")))
IF(COUNT(H184:K184)=0,"",SUM(H184:K184))IF(OR(L184="",N(F184)=0),"",L184/F184)IF(OR(L184="",N(F184)+N(G184)=0),"",L184/(N(F184)+N(G184)))IF(OR(O184="",P184=""),"",P184-O184)IF(C184="","",IF(P184<>"","Paid",IF(O184<>"","Invoiced","Not invoiced")))
IF(COUNT(H185:K185)=0,"",SUM(H185:K185))IF(OR(L185="",N(F185)=0),"",L185/F185)IF(OR(L185="",N(F185)+N(G185)=0),"",L185/(N(F185)+N(G185)))IF(OR(O185="",P185=""),"",P185-O185)IF(C185="","",IF(P185<>"","Paid",IF(O185<>"","Invoiced","Not invoiced")))
IF(COUNT(H186:K186)=0,"",SUM(H186:K186))IF(OR(L186="",N(F186)=0),"",L186/F186)IF(OR(L186="",N(F186)+N(G186)=0),"",L186/(N(F186)+N(G186)))IF(OR(O186="",P186=""),"",P186-O186)IF(C186="","",IF(P186<>"","Paid",IF(O186<>"","Invoiced","Not invoiced")))
IF(COUNT(H187:K187)=0,"",SUM(H187:K187))IF(OR(L187="",N(F187)=0),"",L187/F187)IF(OR(L187="",N(F187)+N(G187)=0),"",L187/(N(F187)+N(G187)))IF(OR(O187="",P187=""),"",P187-O187)IF(C187="","",IF(P187<>"","Paid",IF(O187<>"","Invoiced","Not invoiced")))
IF(COUNT(H188:K188)=0,"",SUM(H188:K188))IF(OR(L188="",N(F188)=0),"",L188/F188)IF(OR(L188="",N(F188)+N(G188)=0),"",L188/(N(F188)+N(G188)))IF(OR(O188="",P188=""),"",P188-O188)IF(C188="","",IF(P188<>"","Paid",IF(O188<>"","Invoiced","Not invoiced")))
IF(COUNT(H189:K189)=0,"",SUM(H189:K189))IF(OR(L189="",N(F189)=0),"",L189/F189)IF(OR(L189="",N(F189)+N(G189)=0),"",L189/(N(F189)+N(G189)))IF(OR(O189="",P189=""),"",P189-O189)IF(C189="","",IF(P189<>"","Paid",IF(O189<>"","Invoiced","Not invoiced")))
IF(COUNT(H190:K190)=0,"",SUM(H190:K190))IF(OR(L190="",N(F190)=0),"",L190/F190)IF(OR(L190="",N(F190)+N(G190)=0),"",L190/(N(F190)+N(G190)))IF(OR(O190="",P190=""),"",P190-O190)IF(C190="","",IF(P190<>"","Paid",IF(O190<>"","Invoiced","Not invoiced")))
IF(COUNT(H191:K191)=0,"",SUM(H191:K191))IF(OR(L191="",N(F191)=0),"",L191/F191)IF(OR(L191="",N(F191)+N(G191)=0),"",L191/(N(F191)+N(G191)))IF(OR(O191="",P191=""),"",P191-O191)IF(C191="","",IF(P191<>"","Paid",IF(O191<>"","Invoiced","Not invoiced")))
IF(COUNT(H192:K192)=0,"",SUM(H192:K192))IF(OR(L192="",N(F192)=0),"",L192/F192)IF(OR(L192="",N(F192)+N(G192)=0),"",L192/(N(F192)+N(G192)))IF(OR(O192="",P192=""),"",P192-O192)IF(C192="","",IF(P192<>"","Paid",IF(O192<>"","Invoiced","Not invoiced")))
IF(COUNT(H193:K193)=0,"",SUM(H193:K193))IF(OR(L193="",N(F193)=0),"",L193/F193)IF(OR(L193="",N(F193)+N(G193)=0),"",L193/(N(F193)+N(G193)))IF(OR(O193="",P193=""),"",P193-O193)IF(C193="","",IF(P193<>"","Paid",IF(O193<>"","Invoiced","Not invoiced")))
IF(COUNT(H194:K194)=0,"",SUM(H194:K194))IF(OR(L194="",N(F194)=0),"",L194/F194)IF(OR(L194="",N(F194)+N(G194)=0),"",L194/(N(F194)+N(G194)))IF(OR(O194="",P194=""),"",P194-O194)IF(C194="","",IF(P194<>"","Paid",IF(O194<>"","Invoiced","Not invoiced")))
IF(COUNT(H195:K195)=0,"",SUM(H195:K195))IF(OR(L195="",N(F195)=0),"",L195/F195)IF(OR(L195="",N(F195)+N(G195)=0),"",L195/(N(F195)+N(G195)))IF(OR(O195="",P195=""),"",P195-O195)IF(C195="","",IF(P195<>"","Paid",IF(O195<>"","Invoiced","Not invoiced")))
IF(COUNT(H196:K196)=0,"",SUM(H196:K196))IF(OR(L196="",N(F196)=0),"",L196/F196)IF(OR(L196="",N(F196)+N(G196)=0),"",L196/(N(F196)+N(G196)))IF(OR(O196="",P196=""),"",P196-O196)IF(C196="","",IF(P196<>"","Paid",IF(O196<>"","Invoiced","Not invoiced")))
IF(COUNT(H197:K197)=0,"",SUM(H197:K197))IF(OR(L197="",N(F197)=0),"",L197/F197)IF(OR(L197="",N(F197)+N(G197)=0),"",L197/(N(F197)+N(G197)))IF(OR(O197="",P197=""),"",P197-O197)IF(C197="","",IF(P197<>"","Paid",IF(O197<>"","Invoiced","Not invoiced")))
IF(COUNT(H198:K198)=0,"",SUM(H198:K198))IF(OR(L198="",N(F198)=0),"",L198/F198)IF(OR(L198="",N(F198)+N(G198)=0),"",L198/(N(F198)+N(G198)))IF(OR(O198="",P198=""),"",P198-O198)IF(C198="","",IF(P198<>"","Paid",IF(O198<>"","Invoiced","Not invoiced")))
IF(COUNT(H199:K199)=0,"",SUM(H199:K199))IF(OR(L199="",N(F199)=0),"",L199/F199)IF(OR(L199="",N(F199)+N(G199)=0),"",L199/(N(F199)+N(G199)))IF(OR(O199="",P199=""),"",P199-O199)IF(C199="","",IF(P199<>"","Paid",IF(O199<>"","Invoiced","Not invoiced")))
IF(COUNT(H200:K200)=0,"",SUM(H200:K200))IF(OR(L200="",N(F200)=0),"",L200/F200)IF(OR(L200="",N(F200)+N(G200)=0),"",L200/(N(F200)+N(G200)))IF(OR(O200="",P200=""),"",P200-O200)IF(C200="","",IF(P200<>"","Paid",IF(O200<>"","Invoiced","Not invoiced")))
IF(COUNT(H201:K201)=0,"",SUM(H201:K201))IF(OR(L201="",N(F201)=0),"",L201/F201)IF(OR(L201="",N(F201)+N(G201)=0),"",L201/(N(F201)+N(G201)))IF(OR(O201="",P201=""),"",P201-O201)IF(C201="","",IF(P201<>"","Paid",IF(O201<>"","Invoiced","Not invoiced")))
IF(COUNT(H202:K202)=0,"",SUM(H202:K202))IF(OR(L202="",N(F202)=0),"",L202/F202)IF(OR(L202="",N(F202)+N(G202)=0),"",L202/(N(F202)+N(G202)))IF(OR(O202="",P202=""),"",P202-O202)IF(C202="","",IF(P202<>"","Paid",IF(O202<>"","Invoiced","Not invoiced")))
IF(COUNT(H203:K203)=0,"",SUM(H203:K203))IF(OR(L203="",N(F203)=0),"",L203/F203)IF(OR(L203="",N(F203)+N(G203)=0),"",L203/(N(F203)+N(G203)))IF(OR(O203="",P203=""),"",P203-O203)IF(C203="","",IF(P203<>"","Paid",IF(O203<>"","Invoiced","Not invoiced")))
IF(COUNT(H204:K204)=0,"",SUM(H204:K204))IF(OR(L204="",N(F204)=0),"",L204/F204)IF(OR(L204="",N(F204)+N(G204)=0),"",L204/(N(F204)+N(G204)))IF(OR(O204="",P204=""),"",P204-O204)IF(C204="","",IF(P204<>"","Paid",IF(O204<>"","Invoiced","Not invoiced")))
IF(COUNT(H205:K205)=0,"",SUM(H205:K205))IF(OR(L205="",N(F205)=0),"",L205/F205)IF(OR(L205="",N(F205)+N(G205)=0),"",L205/(N(F205)+N(G205)))IF(OR(O205="",P205=""),"",P205-O205)IF(C205="","",IF(P205<>"","Paid",IF(O205<>"","Invoiced","Not invoiced")))
IF(COUNT(H206:K206)=0,"",SUM(H206:K206))IF(OR(L206="",N(F206)=0),"",L206/F206)IF(OR(L206="",N(F206)+N(G206)=0),"",L206/(N(F206)+N(G206)))IF(OR(O206="",P206=""),"",P206-O206)IF(C206="","",IF(P206<>"","Paid",IF(O206<>"","Invoiced","Not invoiced")))
IF(COUNT(H207:K207)=0,"",SUM(H207:K207))IF(OR(L207="",N(F207)=0),"",L207/F207)IF(OR(L207="",N(F207)+N(G207)=0),"",L207/(N(F207)+N(G207)))IF(OR(O207="",P207=""),"",P207-O207)IF(C207="","",IF(P207<>"","Paid",IF(O207<>"","Invoiced","Not invoiced")))
IF(COUNT(H208:K208)=0,"",SUM(H208:K208))IF(OR(L208="",N(F208)=0),"",L208/F208)IF(OR(L208="",N(F208)+N(G208)=0),"",L208/(N(F208)+N(G208)))IF(OR(O208="",P208=""),"",P208-O208)IF(C208="","",IF(P208<>"","Paid",IF(O208<>"","Invoiced","Not invoiced")))
IF(COUNT(H209:K209)=0,"",SUM(H209:K209))IF(OR(L209="",N(F209)=0),"",L209/F209)IF(OR(L209="",N(F209)+N(G209)=0),"",L209/(N(F209)+N(G209)))IF(OR(O209="",P209=""),"",P209-O209)IF(C209="","",IF(P209<>"","Paid",IF(O209<>"","Invoiced","Not invoiced")))
IF(COUNT(H210:K210)=0,"",SUM(H210:K210))IF(OR(L210="",N(F210)=0),"",L210/F210)IF(OR(L210="",N(F210)+N(G210)=0),"",L210/(N(F210)+N(G210)))IF(OR(O210="",P210=""),"",P210-O210)IF(C210="","",IF(P210<>"","Paid",IF(O210<>"","Invoiced","Not invoiced")))
IF(COUNT(H211:K211)=0,"",SUM(H211:K211))IF(OR(L211="",N(F211)=0),"",L211/F211)IF(OR(L211="",N(F211)+N(G211)=0),"",L211/(N(F211)+N(G211)))IF(OR(O211="",P211=""),"",P211-O211)IF(C211="","",IF(P211<>"","Paid",IF(O211<>"","Invoiced","Not invoiced")))
IF(COUNT(H212:K212)=0,"",SUM(H212:K212))IF(OR(L212="",N(F212)=0),"",L212/F212)IF(OR(L212="",N(F212)+N(G212)=0),"",L212/(N(F212)+N(G212)))IF(OR(O212="",P212=""),"",P212-O212)IF(C212="","",IF(P212<>"","Paid",IF(O212<>"","Invoiced","Not invoiced")))
IF(COUNT(H213:K213)=0,"",SUM(H213:K213))IF(OR(L213="",N(F213)=0),"",L213/F213)IF(OR(L213="",N(F213)+N(G213)=0),"",L213/(N(F213)+N(G213)))IF(OR(O213="",P213=""),"",P213-O213)IF(C213="","",IF(P213<>"","Paid",IF(O213<>"","Invoiced","Not invoiced")))
IF(COUNT(H214:K214)=0,"",SUM(H214:K214))IF(OR(L214="",N(F214)=0),"",L214/F214)IF(OR(L214="",N(F214)+N(G214)=0),"",L214/(N(F214)+N(G214)))IF(OR(O214="",P214=""),"",P214-O214)IF(C214="","",IF(P214<>"","Paid",IF(O214<>"","Invoiced","Not invoiced")))
IF(COUNT(H215:K215)=0,"",SUM(H215:K215))IF(OR(L215="",N(F215)=0),"",L215/F215)IF(OR(L215="",N(F215)+N(G215)=0),"",L215/(N(F215)+N(G215)))IF(OR(O215="",P215=""),"",P215-O215)IF(C215="","",IF(P215<>"","Paid",IF(O215<>"","Invoiced","Not invoiced")))
IF(COUNT(H216:K216)=0,"",SUM(H216:K216))IF(OR(L216="",N(F216)=0),"",L216/F216)IF(OR(L216="",N(F216)+N(G216)=0),"",L216/(N(F216)+N(G216)))IF(OR(O216="",P216=""),"",P216-O216)IF(C216="","",IF(P216<>"","Paid",IF(O216<>"","Invoiced","Not invoiced")))
IF(COUNT(H217:K217)=0,"",SUM(H217:K217))IF(OR(L217="",N(F217)=0),"",L217/F217)IF(OR(L217="",N(F217)+N(G217)=0),"",L217/(N(F217)+N(G217)))IF(OR(O217="",P217=""),"",P217-O217)IF(C217="","",IF(P217<>"","Paid",IF(O217<>"","Invoiced","Not invoiced")))
IF(COUNT(H218:K218)=0,"",SUM(H218:K218))IF(OR(L218="",N(F218)=0),"",L218/F218)IF(OR(L218="",N(F218)+N(G218)=0),"",L218/(N(F218)+N(G218)))IF(OR(O218="",P218=""),"",P218-O218)IF(C218="","",IF(P218<>"","Paid",IF(O218<>"","Invoiced","Not invoiced")))
IF(COUNT(H219:K219)=0,"",SUM(H219:K219))IF(OR(L219="",N(F219)=0),"",L219/F219)IF(OR(L219="",N(F219)+N(G219)=0),"",L219/(N(F219)+N(G219)))IF(OR(O219="",P219=""),"",P219-O219)IF(C219="","",IF(P219<>"","Paid",IF(O219<>"","Invoiced","Not invoiced")))
IF(COUNT(H220:K220)=0,"",SUM(H220:K220))IF(OR(L220="",N(F220)=0),"",L220/F220)IF(OR(L220="",N(F220)+N(G220)=0),"",L220/(N(F220)+N(G220)))IF(OR(O220="",P220=""),"",P220-O220)IF(C220="","",IF(P220<>"","Paid",IF(O220<>"","Invoiced","Not invoiced")))
IF(COUNT(H221:K221)=0,"",SUM(H221:K221))IF(OR(L221="",N(F221)=0),"",L221/F221)IF(OR(L221="",N(F221)+N(G221)=0),"",L221/(N(F221)+N(G221)))IF(OR(O221="",P221=""),"",P221-O221)IF(C221="","",IF(P221<>"","Paid",IF(O221<>"","Invoiced","Not invoiced")))
IF(COUNT(H222:K222)=0,"",SUM(H222:K222))IF(OR(L222="",N(F222)=0),"",L222/F222)IF(OR(L222="",N(F222)+N(G222)=0),"",L222/(N(F222)+N(G222)))IF(OR(O222="",P222=""),"",P222-O222)IF(C222="","",IF(P222<>"","Paid",IF(O222<>"","Invoiced","Not invoiced")))
IF(COUNT(H223:K223)=0,"",SUM(H223:K223))IF(OR(L223="",N(F223)=0),"",L223/F223)IF(OR(L223="",N(F223)+N(G223)=0),"",L223/(N(F223)+N(G223)))IF(OR(O223="",P223=""),"",P223-O223)IF(C223="","",IF(P223<>"","Paid",IF(O223<>"","Invoiced","Not invoiced")))
IF(COUNT(H224:K224)=0,"",SUM(H224:K224))IF(OR(L224="",N(F224)=0),"",L224/F224)IF(OR(L224="",N(F224)+N(G224)=0),"",L224/(N(F224)+N(G224)))IF(OR(O224="",P224=""),"",P224-O224)IF(C224="","",IF(P224<>"","Paid",IF(O224<>"","Invoiced","Not invoiced")))
IF(COUNT(H225:K225)=0,"",SUM(H225:K225))IF(OR(L225="",N(F225)=0),"",L225/F225)IF(OR(L225="",N(F225)+N(G225)=0),"",L225/(N(F225)+N(G225)))IF(OR(O225="",P225=""),"",P225-O225)IF(C225="","",IF(P225<>"","Paid",IF(O225<>"","Invoiced","Not invoiced")))
IF(COUNT(H226:K226)=0,"",SUM(H226:K226))IF(OR(L226="",N(F226)=0),"",L226/F226)IF(OR(L226="",N(F226)+N(G226)=0),"",L226/(N(F226)+N(G226)))IF(OR(O226="",P226=""),"",P226-O226)IF(C226="","",IF(P226<>"","Paid",IF(O226<>"","Invoiced","Not invoiced")))
IF(COUNT(H227:K227)=0,"",SUM(H227:K227))IF(OR(L227="",N(F227)=0),"",L227/F227)IF(OR(L227="",N(F227)+N(G227)=0),"",L227/(N(F227)+N(G227)))IF(OR(O227="",P227=""),"",P227-O227)IF(C227="","",IF(P227<>"","Paid",IF(O227<>"","Invoiced","Not invoiced")))
IF(COUNT(H228:K228)=0,"",SUM(H228:K228))IF(OR(L228="",N(F228)=0),"",L228/F228)IF(OR(L228="",N(F228)+N(G228)=0),"",L228/(N(F228)+N(G228)))IF(OR(O228="",P228=""),"",P228-O228)IF(C228="","",IF(P228<>"","Paid",IF(O228<>"","Invoiced","Not invoiced")))
IF(COUNT(H229:K229)=0,"",SUM(H229:K229))IF(OR(L229="",N(F229)=0),"",L229/F229)IF(OR(L229="",N(F229)+N(G229)=0),"",L229/(N(F229)+N(G229)))IF(OR(O229="",P229=""),"",P229-O229)IF(C229="","",IF(P229<>"","Paid",IF(O229<>"","Invoiced","Not invoiced")))
IF(COUNT(H230:K230)=0,"",SUM(H230:K230))IF(OR(L230="",N(F230)=0),"",L230/F230)IF(OR(L230="",N(F230)+N(G230)=0),"",L230/(N(F230)+N(G230)))IF(OR(O230="",P230=""),"",P230-O230)IF(C230="","",IF(P230<>"","Paid",IF(O230<>"","Invoiced","Not invoiced")))
IF(COUNT(H231:K231)=0,"",SUM(H231:K231))IF(OR(L231="",N(F231)=0),"",L231/F231)IF(OR(L231="",N(F231)+N(G231)=0),"",L231/(N(F231)+N(G231)))IF(OR(O231="",P231=""),"",P231-O231)IF(C231="","",IF(P231<>"","Paid",IF(O231<>"","Invoiced","Not invoiced")))
IF(COUNT(H232:K232)=0,"",SUM(H232:K232))IF(OR(L232="",N(F232)=0),"",L232/F232)IF(OR(L232="",N(F232)+N(G232)=0),"",L232/(N(F232)+N(G232)))IF(OR(O232="",P232=""),"",P232-O232)IF(C232="","",IF(P232<>"","Paid",IF(O232<>"","Invoiced","Not invoiced")))
IF(COUNT(H233:K233)=0,"",SUM(H233:K233))IF(OR(L233="",N(F233)=0),"",L233/F233)IF(OR(L233="",N(F233)+N(G233)=0),"",L233/(N(F233)+N(G233)))IF(OR(O233="",P233=""),"",P233-O233)IF(C233="","",IF(P233<>"","Paid",IF(O233<>"","Invoiced","Not invoiced")))
IF(COUNT(H234:K234)=0,"",SUM(H234:K234))IF(OR(L234="",N(F234)=0),"",L234/F234)IF(OR(L234="",N(F234)+N(G234)=0),"",L234/(N(F234)+N(G234)))IF(OR(O234="",P234=""),"",P234-O234)IF(C234="","",IF(P234<>"","Paid",IF(O234<>"","Invoiced","Not invoiced")))
IF(COUNT(H235:K235)=0,"",SUM(H235:K235))IF(OR(L235="",N(F235)=0),"",L235/F235)IF(OR(L235="",N(F235)+N(G235)=0),"",L235/(N(F235)+N(G235)))IF(OR(O235="",P235=""),"",P235-O235)IF(C235="","",IF(P235<>"","Paid",IF(O235<>"","Invoiced","Not invoiced")))
IF(COUNT(H236:K236)=0,"",SUM(H236:K236))IF(OR(L236="",N(F236)=0),"",L236/F236)IF(OR(L236="",N(F236)+N(G236)=0),"",L236/(N(F236)+N(G236)))IF(OR(O236="",P236=""),"",P236-O236)IF(C236="","",IF(P236<>"","Paid",IF(O236<>"","Invoiced","Not invoiced")))
IF(COUNT(H237:K237)=0,"",SUM(H237:K237))IF(OR(L237="",N(F237)=0),"",L237/F237)IF(OR(L237="",N(F237)+N(G237)=0),"",L237/(N(F237)+N(G237)))IF(OR(O237="",P237=""),"",P237-O237)IF(C237="","",IF(P237<>"","Paid",IF(O237<>"","Invoiced","Not invoiced")))
IF(COUNT(H238:K238)=0,"",SUM(H238:K238))IF(OR(L238="",N(F238)=0),"",L238/F238)IF(OR(L238="",N(F238)+N(G238)=0),"",L238/(N(F238)+N(G238)))IF(OR(O238="",P238=""),"",P238-O238)IF(C238="","",IF(P238<>"","Paid",IF(O238<>"","Invoiced","Not invoiced")))
IF(COUNT(H239:K239)=0,"",SUM(H239:K239))IF(OR(L239="",N(F239)=0),"",L239/F239)IF(OR(L239="",N(F239)+N(G239)=0),"",L239/(N(F239)+N(G239)))IF(OR(O239="",P239=""),"",P239-O239)IF(C239="","",IF(P239<>"","Paid",IF(O239<>"","Invoiced","Not invoiced")))
IF(COUNT(H240:K240)=0,"",SUM(H240:K240))IF(OR(L240="",N(F240)=0),"",L240/F240)IF(OR(L240="",N(F240)+N(G240)=0),"",L240/(N(F240)+N(G240)))IF(OR(O240="",P240=""),"",P240-O240)IF(C240="","",IF(P240<>"","Paid",IF(O240<>"","Invoiced","Not invoiced")))
IF(COUNT(H241:K241)=0,"",SUM(H241:K241))IF(OR(L241="",N(F241)=0),"",L241/F241)IF(OR(L241="",N(F241)+N(G241)=0),"",L241/(N(F241)+N(G241)))IF(OR(O241="",P241=""),"",P241-O241)IF(C241="","",IF(P241<>"","Paid",IF(O241<>"","Invoiced","Not invoiced")))
IF(COUNT(H242:K242)=0,"",SUM(H242:K242))IF(OR(L242="",N(F242)=0),"",L242/F242)IF(OR(L242="",N(F242)+N(G242)=0),"",L242/(N(F242)+N(G242)))IF(OR(O242="",P242=""),"",P242-O242)IF(C242="","",IF(P242<>"","Paid",IF(O242<>"","Invoiced","Not invoiced")))
IF(COUNT(H243:K243)=0,"",SUM(H243:K243))IF(OR(L243="",N(F243)=0),"",L243/F243)IF(OR(L243="",N(F243)+N(G243)=0),"",L243/(N(F243)+N(G243)))IF(OR(O243="",P243=""),"",P243-O243)IF(C243="","",IF(P243<>"","Paid",IF(O243<>"","Invoiced","Not invoiced")))
IF(COUNT(H244:K244)=0,"",SUM(H244:K244))IF(OR(L244="",N(F244)=0),"",L244/F244)IF(OR(L244="",N(F244)+N(G244)=0),"",L244/(N(F244)+N(G244)))IF(OR(O244="",P244=""),"",P244-O244)IF(C244="","",IF(P244<>"","Paid",IF(O244<>"","Invoiced","Not invoiced")))
IF(COUNT(H245:K245)=0,"",SUM(H245:K245))IF(OR(L245="",N(F245)=0),"",L245/F245)IF(OR(L245="",N(F245)+N(G245)=0),"",L245/(N(F245)+N(G245)))IF(OR(O245="",P245=""),"",P245-O245)IF(C245="","",IF(P245<>"","Paid",IF(O245<>"","Invoiced","Not invoiced")))
IF(COUNT(H246:K246)=0,"",SUM(H246:K246))IF(OR(L246="",N(F246)=0),"",L246/F246)IF(OR(L246="",N(F246)+N(G246)=0),"",L246/(N(F246)+N(G246)))IF(OR(O246="",P246=""),"",P246-O246)IF(C246="","",IF(P246<>"","Paid",IF(O246<>"","Invoiced","Not invoiced")))
IF(COUNT(H247:K247)=0,"",SUM(H247:K247))IF(OR(L247="",N(F247)=0),"",L247/F247)IF(OR(L247="",N(F247)+N(G247)=0),"",L247/(N(F247)+N(G247)))IF(OR(O247="",P247=""),"",P247-O247)IF(C247="","",IF(P247<>"","Paid",IF(O247<>"","Invoiced","Not invoiced")))
IF(COUNT(H248:K248)=0,"",SUM(H248:K248))IF(OR(L248="",N(F248)=0),"",L248/F248)IF(OR(L248="",N(F248)+N(G248)=0),"",L248/(N(F248)+N(G248)))IF(OR(O248="",P248=""),"",P248-O248)IF(C248="","",IF(P248<>"","Paid",IF(O248<>"","Invoiced","Not invoiced")))
IF(COUNT(H249:K249)=0,"",SUM(H249:K249))IF(OR(L249="",N(F249)=0),"",L249/F249)IF(OR(L249="",N(F249)+N(G249)=0),"",L249/(N(F249)+N(G249)))IF(OR(O249="",P249=""),"",P249-O249)IF(C249="","",IF(P249<>"","Paid",IF(O249<>"","Invoiced","Not invoiced")))
IF(COUNT(H250:K250)=0,"",SUM(H250:K250))IF(OR(L250="",N(F250)=0),"",L250/F250)IF(OR(L250="",N(F250)+N(G250)=0),"",L250/(N(F250)+N(G250)))IF(OR(O250="",P250=""),"",P250-O250)IF(C250="","",IF(P250<>"","Paid",IF(O250<>"","Invoiced","Not invoiced")))
IF(COUNT(H251:K251)=0,"",SUM(H251:K251))IF(OR(L251="",N(F251)=0),"",L251/F251)IF(OR(L251="",N(F251)+N(G251)=0),"",L251/(N(F251)+N(G251)))IF(OR(O251="",P251=""),"",P251-O251)IF(C251="","",IF(P251<>"","Paid",IF(O251<>"","Invoiced","Not invoiced")))
IF(COUNT(H252:K252)=0,"",SUM(H252:K252))IF(OR(L252="",N(F252)=0),"",L252/F252)IF(OR(L252="",N(F252)+N(G252)=0),"",L252/(N(F252)+N(G252)))IF(OR(O252="",P252=""),"",P252-O252)IF(C252="","",IF(P252<>"","Paid",IF(O252<>"","Invoiced","Not invoiced")))
IF(COUNT(H253:K253)=0,"",SUM(H253:K253))IF(OR(L253="",N(F253)=0),"",L253/F253)IF(OR(L253="",N(F253)+N(G253)=0),"",L253/(N(F253)+N(G253)))IF(OR(O253="",P253=""),"",P253-O253)IF(C253="","",IF(P253<>"","Paid",IF(O253<>"","Invoiced","Not invoiced")))
IF(COUNT(H254:K254)=0,"",SUM(H254:K254))IF(OR(L254="",N(F254)=0),"",L254/F254)IF(OR(L254="",N(F254)+N(G254)=0),"",L254/(N(F254)+N(G254)))IF(OR(O254="",P254=""),"",P254-O254)IF(C254="","",IF(P254<>"","Paid",IF(O254<>"","Invoiced","Not invoiced")))
IF(COUNT(H255:K255)=0,"",SUM(H255:K255))IF(OR(L255="",N(F255)=0),"",L255/F255)IF(OR(L255="",N(F255)+N(G255)=0),"",L255/(N(F255)+N(G255)))IF(OR(O255="",P255=""),"",P255-O255)IF(C255="","",IF(P255<>"","Paid",IF(O255<>"","Invoiced","Not invoiced")))
IF(COUNT(H256:K256)=0,"",SUM(H256:K256))IF(OR(L256="",N(F256)=0),"",L256/F256)IF(OR(L256="",N(F256)+N(G256)=0),"",L256/(N(F256)+N(G256)))IF(OR(O256="",P256=""),"",P256-O256)IF(C256="","",IF(P256<>"","Paid",IF(O256<>"","Invoiced","Not invoiced")))
IF(COUNT(H257:K257)=0,"",SUM(H257:K257))IF(OR(L257="",N(F257)=0),"",L257/F257)IF(OR(L257="",N(F257)+N(G257)=0),"",L257/(N(F257)+N(G257)))IF(OR(O257="",P257=""),"",P257-O257)IF(C257="","",IF(P257<>"","Paid",IF(O257<>"","Invoiced","Not invoiced")))
IF(COUNT(H258:K258)=0,"",SUM(H258:K258))IF(OR(L258="",N(F258)=0),"",L258/F258)IF(OR(L258="",N(F258)+N(G258)=0),"",L258/(N(F258)+N(G258)))IF(OR(O258="",P258=""),"",P258-O258)IF(C258="","",IF(P258<>"","Paid",IF(O258<>"","Invoiced","Not invoiced")))
IF(COUNT(H259:K259)=0,"",SUM(H259:K259))IF(OR(L259="",N(F259)=0),"",L259/F259)IF(OR(L259="",N(F259)+N(G259)=0),"",L259/(N(F259)+N(G259)))IF(OR(O259="",P259=""),"",P259-O259)IF(C259="","",IF(P259<>"","Paid",IF(O259<>"","Invoiced","Not invoiced")))
IF(COUNT(H260:K260)=0,"",SUM(H260:K260))IF(OR(L260="",N(F260)=0),"",L260/F260)IF(OR(L260="",N(F260)+N(G260)=0),"",L260/(N(F260)+N(G260)))IF(OR(O260="",P260=""),"",P260-O260)IF(C260="","",IF(P260<>"","Paid",IF(O260<>"","Invoiced","Not invoiced")))
IF(COUNT(H261:K261)=0,"",SUM(H261:K261))IF(OR(L261="",N(F261)=0),"",L261/F261)IF(OR(L261="",N(F261)+N(G261)=0),"",L261/(N(F261)+N(G261)))IF(OR(O261="",P261=""),"",P261-O261)IF(C261="","",IF(P261<>"","Paid",IF(O261<>"","Invoiced","Not invoiced")))
IF(COUNT(H262:K262)=0,"",SUM(H262:K262))IF(OR(L262="",N(F262)=0),"",L262/F262)IF(OR(L262="",N(F262)+N(G262)=0),"",L262/(N(F262)+N(G262)))IF(OR(O262="",P262=""),"",P262-O262)IF(C262="","",IF(P262<>"","Paid",IF(O262<>"","Invoiced","Not invoiced")))
IF(COUNT(H263:K263)=0,"",SUM(H263:K263))IF(OR(L263="",N(F263)=0),"",L263/F263)IF(OR(L263="",N(F263)+N(G263)=0),"",L263/(N(F263)+N(G263)))IF(OR(O263="",P263=""),"",P263-O263)IF(C263="","",IF(P263<>"","Paid",IF(O263<>"","Invoiced","Not invoiced")))
IF(COUNT(H264:K264)=0,"",SUM(H264:K264))IF(OR(L264="",N(F264)=0),"",L264/F264)IF(OR(L264="",N(F264)+N(G264)=0),"",L264/(N(F264)+N(G264)))IF(OR(O264="",P264=""),"",P264-O264)IF(C264="","",IF(P264<>"","Paid",IF(O264<>"","Invoiced","Not invoiced")))
IF(COUNT(H265:K265)=0,"",SUM(H265:K265))IF(OR(L265="",N(F265)=0),"",L265/F265)IF(OR(L265="",N(F265)+N(G265)=0),"",L265/(N(F265)+N(G265)))IF(OR(O265="",P265=""),"",P265-O265)IF(C265="","",IF(P265<>"","Paid",IF(O265<>"","Invoiced","Not invoiced")))
IF(COUNT(H266:K266)=0,"",SUM(H266:K266))IF(OR(L266="",N(F266)=0),"",L266/F266)IF(OR(L266="",N(F266)+N(G266)=0),"",L266/(N(F266)+N(G266)))IF(OR(O266="",P266=""),"",P266-O266)IF(C266="","",IF(P266<>"","Paid",IF(O266<>"","Invoiced","Not invoiced")))
IF(COUNT(H267:K267)=0,"",SUM(H267:K267))IF(OR(L267="",N(F267)=0),"",L267/F267)IF(OR(L267="",N(F267)+N(G267)=0),"",L267/(N(F267)+N(G267)))IF(OR(O267="",P267=""),"",P267-O267)IF(C267="","",IF(P267<>"","Paid",IF(O267<>"","Invoiced","Not invoiced")))
IF(COUNT(H268:K268)=0,"",SUM(H268:K268))IF(OR(L268="",N(F268)=0),"",L268/F268)IF(OR(L268="",N(F268)+N(G268)=0),"",L268/(N(F268)+N(G268)))IF(OR(O268="",P268=""),"",P268-O268)IF(C268="","",IF(P268<>"","Paid",IF(O268<>"","Invoiced","Not invoiced")))
IF(COUNT(H269:K269)=0,"",SUM(H269:K269))IF(OR(L269="",N(F269)=0),"",L269/F269)IF(OR(L269="",N(F269)+N(G269)=0),"",L269/(N(F269)+N(G269)))IF(OR(O269="",P269=""),"",P269-O269)IF(C269="","",IF(P269<>"","Paid",IF(O269<>"","Invoiced","Not invoiced")))
IF(COUNT(H270:K270)=0,"",SUM(H270:K270))IF(OR(L270="",N(F270)=0),"",L270/F270)IF(OR(L270="",N(F270)+N(G270)=0),"",L270/(N(F270)+N(G270)))IF(OR(O270="",P270=""),"",P270-O270)IF(C270="","",IF(P270<>"","Paid",IF(O270<>"","Invoiced","Not invoiced")))
IF(COUNT(H271:K271)=0,"",SUM(H271:K271))IF(OR(L271="",N(F271)=0),"",L271/F271)IF(OR(L271="",N(F271)+N(G271)=0),"",L271/(N(F271)+N(G271)))IF(OR(O271="",P271=""),"",P271-O271)IF(C271="","",IF(P271<>"","Paid",IF(O271<>"","Invoiced","Not invoiced")))
IF(COUNT(H272:K272)=0,"",SUM(H272:K272))IF(OR(L272="",N(F272)=0),"",L272/F272)IF(OR(L272="",N(F272)+N(G272)=0),"",L272/(N(F272)+N(G272)))IF(OR(O272="",P272=""),"",P272-O272)IF(C272="","",IF(P272<>"","Paid",IF(O272<>"","Invoiced","Not invoiced")))
IF(COUNT(H273:K273)=0,"",SUM(H273:K273))IF(OR(L273="",N(F273)=0),"",L273/F273)IF(OR(L273="",N(F273)+N(G273)=0),"",L273/(N(F273)+N(G273)))IF(OR(O273="",P273=""),"",P273-O273)IF(C273="","",IF(P273<>"","Paid",IF(O273<>"","Invoiced","Not invoiced")))
IF(COUNT(H274:K274)=0,"",SUM(H274:K274))IF(OR(L274="",N(F274)=0),"",L274/F274)IF(OR(L274="",N(F274)+N(G274)=0),"",L274/(N(F274)+N(G274)))IF(OR(O274="",P274=""),"",P274-O274)IF(C274="","",IF(P274<>"","Paid",IF(O274<>"","Invoiced","Not invoiced")))
IF(COUNT(H275:K275)=0,"",SUM(H275:K275))IF(OR(L275="",N(F275)=0),"",L275/F275)IF(OR(L275="",N(F275)+N(G275)=0),"",L275/(N(F275)+N(G275)))IF(OR(O275="",P275=""),"",P275-O275)IF(C275="","",IF(P275<>"","Paid",IF(O275<>"","Invoiced","Not invoiced")))
IF(COUNT(H276:K276)=0,"",SUM(H276:K276))IF(OR(L276="",N(F276)=0),"",L276/F276)IF(OR(L276="",N(F276)+N(G276)=0),"",L276/(N(F276)+N(G276)))IF(OR(O276="",P276=""),"",P276-O276)IF(C276="","",IF(P276<>"","Paid",IF(O276<>"","Invoiced","Not invoiced")))
IF(COUNT(H277:K277)=0,"",SUM(H277:K277))IF(OR(L277="",N(F277)=0),"",L277/F277)IF(OR(L277="",N(F277)+N(G277)=0),"",L277/(N(F277)+N(G277)))IF(OR(O277="",P277=""),"",P277-O277)IF(C277="","",IF(P277<>"","Paid",IF(O277<>"","Invoiced","Not invoiced")))
IF(COUNT(H278:K278)=0,"",SUM(H278:K278))IF(OR(L278="",N(F278)=0),"",L278/F278)IF(OR(L278="",N(F278)+N(G278)=0),"",L278/(N(F278)+N(G278)))IF(OR(O278="",P278=""),"",P278-O278)IF(C278="","",IF(P278<>"","Paid",IF(O278<>"","Invoiced","Not invoiced")))
IF(COUNT(H279:K279)=0,"",SUM(H279:K279))IF(OR(L279="",N(F279)=0),"",L279/F279)IF(OR(L279="",N(F279)+N(G279)=0),"",L279/(N(F279)+N(G279)))IF(OR(O279="",P279=""),"",P279-O279)IF(C279="","",IF(P279<>"","Paid",IF(O279<>"","Invoiced","Not invoiced")))
IF(COUNT(H280:K280)=0,"",SUM(H280:K280))IF(OR(L280="",N(F280)=0),"",L280/F280)IF(OR(L280="",N(F280)+N(G280)=0),"",L280/(N(F280)+N(G280)))IF(OR(O280="",P280=""),"",P280-O280)IF(C280="","",IF(P280<>"","Paid",IF(O280<>"","Invoiced","Not invoiced")))
IF(COUNT(H281:K281)=0,"",SUM(H281:K281))IF(OR(L281="",N(F281)=0),"",L281/F281)IF(OR(L281="",N(F281)+N(G281)=0),"",L281/(N(F281)+N(G281)))IF(OR(O281="",P281=""),"",P281-O281)IF(C281="","",IF(P281<>"","Paid",IF(O281<>"","Invoiced","Not invoiced")))
IF(COUNT(H282:K282)=0,"",SUM(H282:K282))IF(OR(L282="",N(F282)=0),"",L282/F282)IF(OR(L282="",N(F282)+N(G282)=0),"",L282/(N(F282)+N(G282)))IF(OR(O282="",P282=""),"",P282-O282)IF(C282="","",IF(P282<>"","Paid",IF(O282<>"","Invoiced","Not invoiced")))
IF(COUNT(H283:K283)=0,"",SUM(H283:K283))IF(OR(L283="",N(F283)=0),"",L283/F283)IF(OR(L283="",N(F283)+N(G283)=0),"",L283/(N(F283)+N(G283)))IF(OR(O283="",P283=""),"",P283-O283)IF(C283="","",IF(P283<>"","Paid",IF(O283<>"","Invoiced","Not invoiced")))
IF(COUNT(H284:K284)=0,"",SUM(H284:K284))IF(OR(L284="",N(F284)=0),"",L284/F284)IF(OR(L284="",N(F284)+N(G284)=0),"",L284/(N(F284)+N(G284)))IF(OR(O284="",P284=""),"",P284-O284)IF(C284="","",IF(P284<>"","Paid",IF(O284<>"","Invoiced","Not invoiced")))
IF(COUNT(H285:K285)=0,"",SUM(H285:K285))IF(OR(L285="",N(F285)=0),"",L285/F285)IF(OR(L285="",N(F285)+N(G285)=0),"",L285/(N(F285)+N(G285)))IF(OR(O285="",P285=""),"",P285-O285)IF(C285="","",IF(P285<>"","Paid",IF(O285<>"","Invoiced","Not invoiced")))
IF(COUNT(H286:K286)=0,"",SUM(H286:K286))IF(OR(L286="",N(F286)=0),"",L286/F286)IF(OR(L286="",N(F286)+N(G286)=0),"",L286/(N(F286)+N(G286)))IF(OR(O286="",P286=""),"",P286-O286)IF(C286="","",IF(P286<>"","Paid",IF(O286<>"","Invoiced","Not invoiced")))
IF(COUNT(H287:K287)=0,"",SUM(H287:K287))IF(OR(L287="",N(F287)=0),"",L287/F287)IF(OR(L287="",N(F287)+N(G287)=0),"",L287/(N(F287)+N(G287)))IF(OR(O287="",P287=""),"",P287-O287)IF(C287="","",IF(P287<>"","Paid",IF(O287<>"","Invoiced","Not invoiced")))
IF(COUNT(H288:K288)=0,"",SUM(H288:K288))IF(OR(L288="",N(F288)=0),"",L288/F288)IF(OR(L288="",N(F288)+N(G288)=0),"",L288/(N(F288)+N(G288)))IF(OR(O288="",P288=""),"",P288-O288)IF(C288="","",IF(P288<>"","Paid",IF(O288<>"","Invoiced","Not invoiced")))
IF(COUNT(H289:K289)=0,"",SUM(H289:K289))IF(OR(L289="",N(F289)=0),"",L289/F289)IF(OR(L289="",N(F289)+N(G289)=0),"",L289/(N(F289)+N(G289)))IF(OR(O289="",P289=""),"",P289-O289)IF(C289="","",IF(P289<>"","Paid",IF(O289<>"","Invoiced","Not invoiced")))
IF(COUNT(H290:K290)=0,"",SUM(H290:K290))IF(OR(L290="",N(F290)=0),"",L290/F290)IF(OR(L290="",N(F290)+N(G290)=0),"",L290/(N(F290)+N(G290)))IF(OR(O290="",P290=""),"",P290-O290)IF(C290="","",IF(P290<>"","Paid",IF(O290<>"","Invoiced","Not invoiced")))
IF(COUNT(H291:K291)=0,"",SUM(H291:K291))IF(OR(L291="",N(F291)=0),"",L291/F291)IF(OR(L291="",N(F291)+N(G291)=0),"",L291/(N(F291)+N(G291)))IF(OR(O291="",P291=""),"",P291-O291)IF(C291="","",IF(P291<>"","Paid",IF(O291<>"","Invoiced","Not invoiced")))
IF(COUNT(H292:K292)=0,"",SUM(H292:K292))IF(OR(L292="",N(F292)=0),"",L292/F292)IF(OR(L292="",N(F292)+N(G292)=0),"",L292/(N(F292)+N(G292)))IF(OR(O292="",P292=""),"",P292-O292)IF(C292="","",IF(P292<>"","Paid",IF(O292<>"","Invoiced","Not invoiced")))
IF(COUNT(H293:K293)=0,"",SUM(H293:K293))IF(OR(L293="",N(F293)=0),"",L293/F293)IF(OR(L293="",N(F293)+N(G293)=0),"",L293/(N(F293)+N(G293)))IF(OR(O293="",P293=""),"",P293-O293)IF(C293="","",IF(P293<>"","Paid",IF(O293<>"","Invoiced","Not invoiced")))
IF(COUNT(H294:K294)=0,"",SUM(H294:K294))IF(OR(L294="",N(F294)=0),"",L294/F294)IF(OR(L294="",N(F294)+N(G294)=0),"",L294/(N(F294)+N(G294)))IF(OR(O294="",P294=""),"",P294-O294)IF(C294="","",IF(P294<>"","Paid",IF(O294<>"","Invoiced","Not invoiced")))
IF(COUNT(H295:K295)=0,"",SUM(H295:K295))IF(OR(L295="",N(F295)=0),"",L295/F295)IF(OR(L295="",N(F295)+N(G295)=0),"",L295/(N(F295)+N(G295)))IF(OR(O295="",P295=""),"",P295-O295)IF(C295="","",IF(P295<>"","Paid",IF(O295<>"","Invoiced","Not invoiced")))
IF(COUNT(H296:K296)=0,"",SUM(H296:K296))IF(OR(L296="",N(F296)=0),"",L296/F296)IF(OR(L296="",N(F296)+N(G296)=0),"",L296/(N(F296)+N(G296)))IF(OR(O296="",P296=""),"",P296-O296)IF(C296="","",IF(P296<>"","Paid",IF(O296<>"","Invoiced","Not invoiced")))
IF(COUNT(H297:K297)=0,"",SUM(H297:K297))IF(OR(L297="",N(F297)=0),"",L297/F297)IF(OR(L297="",N(F297)+N(G297)=0),"",L297/(N(F297)+N(G297)))IF(OR(O297="",P297=""),"",P297-O297)IF(C297="","",IF(P297<>"","Paid",IF(O297<>"","Invoiced","Not invoiced")))
IF(COUNT(H298:K298)=0,"",SUM(H298:K298))IF(OR(L298="",N(F298)=0),"",L298/F298)IF(OR(L298="",N(F298)+N(G298)=0),"",L298/(N(F298)+N(G298)))IF(OR(O298="",P298=""),"",P298-O298)IF(C298="","",IF(P298<>"","Paid",IF(O298<>"","Invoiced","Not invoiced")))
IF(COUNT(H299:K299)=0,"",SUM(H299:K299))IF(OR(L299="",N(F299)=0),"",L299/F299)IF(OR(L299="",N(F299)+N(G299)=0),"",L299/(N(F299)+N(G299)))IF(OR(O299="",P299=""),"",P299-O299)IF(C299="","",IF(P299<>"","Paid",IF(O299<>"","Invoiced","Not invoiced")))
IF(COUNT(H300:K300)=0,"",SUM(H300:K300))IF(OR(L300="",N(F300)=0),"",L300/F300)IF(OR(L300="",N(F300)+N(G300)=0),"",L300/(N(F300)+N(G300)))IF(OR(O300="",P300=""),"",P300-O300)IF(C300="","",IF(P300<>"","Paid",IF(O300<>"","Invoiced","Not invoiced")))
IF(COUNT(H301:K301)=0,"",SUM(H301:K301))IF(OR(L301="",N(F301)=0),"",L301/F301)IF(OR(L301="",N(F301)+N(G301)=0),"",L301/(N(F301)+N(G301)))IF(OR(O301="",P301=""),"",P301-O301)IF(C301="","",IF(P301<>"","Paid",IF(O301<>"","Invoiced","Not invoiced")))
PK ! z¿«< < xl/worksheets/sheet3.xmlDateCategoryDescription / VendorAmount ($)Gallons (fuel only)Price per GallonLoad # (optional)
46328FuelExample truck stop - Biggs Junction612.4150.5IF(OR(D2="",N(E2)=0),"",D2/E2)EX-10442
IF(OR(D3="",N(E3)=0),"",D3/E3)
IF(OR(D4="",N(E4)=0),"",D4/E4)
IF(OR(D5="",N(E5)=0),"",D5/E5)
IF(OR(D6="",N(E6)=0),"",D6/E6)
IF(OR(D7="",N(E7)=0),"",D7/E7)
IF(OR(D8="",N(E8)=0),"",D8/E8)
IF(OR(D9="",N(E9)=0),"",D9/E9)
IF(OR(D10="",N(E10)=0),"",D10/E10)
IF(OR(D11="",N(E11)=0),"",D11/E11)
IF(OR(D12="",N(E12)=0),"",D12/E12)
IF(OR(D13="",N(E13)=0),"",D13/E13)
IF(OR(D14="",N(E14)=0),"",D14/E14)
IF(OR(D15="",N(E15)=0),"",D15/E15)
IF(OR(D16="",N(E16)=0),"",D16/E16)
IF(OR(D17="",N(E17)=0),"",D17/E17)
IF(OR(D18="",N(E18)=0),"",D18/E18)
IF(OR(D19="",N(E19)=0),"",D19/E19)
IF(OR(D20="",N(E20)=0),"",D20/E20)
IF(OR(D21="",N(E21)=0),"",D21/E21)
IF(OR(D22="",N(E22)=0),"",D22/E22)
IF(OR(D23="",N(E23)=0),"",D23/E23)
IF(OR(D24="",N(E24)=0),"",D24/E24)
IF(OR(D25="",N(E25)=0),"",D25/E25)
IF(OR(D26="",N(E26)=0),"",D26/E26)
IF(OR(D27="",N(E27)=0),"",D27/E27)
IF(OR(D28="",N(E28)=0),"",D28/E28)
IF(OR(D29="",N(E29)=0),"",D29/E29)
IF(OR(D30="",N(E30)=0),"",D30/E30)
IF(OR(D31="",N(E31)=0),"",D31/E31)
IF(OR(D32="",N(E32)=0),"",D32/E32)
IF(OR(D33="",N(E33)=0),"",D33/E33)
IF(OR(D34="",N(E34)=0),"",D34/E34)
IF(OR(D35="",N(E35)=0),"",D35/E35)
IF(OR(D36="",N(E36)=0),"",D36/E36)
IF(OR(D37="",N(E37)=0),"",D37/E37)
IF(OR(D38="",N(E38)=0),"",D38/E38)
IF(OR(D39="",N(E39)=0),"",D39/E39)
IF(OR(D40="",N(E40)=0),"",D40/E40)
IF(OR(D41="",N(E41)=0),"",D41/E41)
IF(OR(D42="",N(E42)=0),"",D42/E42)
IF(OR(D43="",N(E43)=0),"",D43/E43)
IF(OR(D44="",N(E44)=0),"",D44/E44)
IF(OR(D45="",N(E45)=0),"",D45/E45)
IF(OR(D46="",N(E46)=0),"",D46/E46)
IF(OR(D47="",N(E47)=0),"",D47/E47)
IF(OR(D48="",N(E48)=0),"",D48/E48)
IF(OR(D49="",N(E49)=0),"",D49/E49)
IF(OR(D50="",N(E50)=0),"",D50/E50)
IF(OR(D51="",N(E51)=0),"",D51/E51)
IF(OR(D52="",N(E52)=0),"",D52/E52)
IF(OR(D53="",N(E53)=0),"",D53/E53)
IF(OR(D54="",N(E54)=0),"",D54/E54)
IF(OR(D55="",N(E55)=0),"",D55/E55)
IF(OR(D56="",N(E56)=0),"",D56/E56)
IF(OR(D57="",N(E57)=0),"",D57/E57)
IF(OR(D58="",N(E58)=0),"",D58/E58)
IF(OR(D59="",N(E59)=0),"",D59/E59)
IF(OR(D60="",N(E60)=0),"",D60/E60)
IF(OR(D61="",N(E61)=0),"",D61/E61)
IF(OR(D62="",N(E62)=0),"",D62/E62)
IF(OR(D63="",N(E63)=0),"",D63/E63)
IF(OR(D64="",N(E64)=0),"",D64/E64)
IF(OR(D65="",N(E65)=0),"",D65/E65)
IF(OR(D66="",N(E66)=0),"",D66/E66)
IF(OR(D67="",N(E67)=0),"",D67/E67)
IF(OR(D68="",N(E68)=0),"",D68/E68)
IF(OR(D69="",N(E69)=0),"",D69/E69)
IF(OR(D70="",N(E70)=0),"",D70/E70)
IF(OR(D71="",N(E71)=0),"",D71/E71)
IF(OR(D72="",N(E72)=0),"",D72/E72)
IF(OR(D73="",N(E73)=0),"",D73/E73)
IF(OR(D74="",N(E74)=0),"",D74/E74)
IF(OR(D75="",N(E75)=0),"",D75/E75)
IF(OR(D76="",N(E76)=0),"",D76/E76)
IF(OR(D77="",N(E77)=0),"",D77/E77)
IF(OR(D78="",N(E78)=0),"",D78/E78)
IF(OR(D79="",N(E79)=0),"",D79/E79)
IF(OR(D80="",N(E80)=0),"",D80/E80)
IF(OR(D81="",N(E81)=0),"",D81/E81)
IF(OR(D82="",N(E82)=0),"",D82/E82)
IF(OR(D83="",N(E83)=0),"",D83/E83)
IF(OR(D84="",N(E84)=0),"",D84/E84)
IF(OR(D85="",N(E85)=0),"",D85/E85)
IF(OR(D86="",N(E86)=0),"",D86/E86)
IF(OR(D87="",N(E87)=0),"",D87/E87)
IF(OR(D88="",N(E88)=0),"",D88/E88)
IF(OR(D89="",N(E89)=0),"",D89/E89)
IF(OR(D90="",N(E90)=0),"",D90/E90)
IF(OR(D91="",N(E91)=0),"",D91/E91)
IF(OR(D92="",N(E92)=0),"",D92/E92)
IF(OR(D93="",N(E93)=0),"",D93/E93)
IF(OR(D94="",N(E94)=0),"",D94/E94)
IF(OR(D95="",N(E95)=0),"",D95/E95)
IF(OR(D96="",N(E96)=0),"",D96/E96)
IF(OR(D97="",N(E97)=0),"",D97/E97)
IF(OR(D98="",N(E98)=0),"",D98/E98)
IF(OR(D99="",N(E99)=0),"",D99/E99)
IF(OR(D100="",N(E100)=0),"",D100/E100)
IF(OR(D101="",N(E101)=0),"",D101/E101)
IF(OR(D102="",N(E102)=0),"",D102/E102)
IF(OR(D103="",N(E103)=0),"",D103/E103)
IF(OR(D104="",N(E104)=0),"",D104/E104)
IF(OR(D105="",N(E105)=0),"",D105/E105)
IF(OR(D106="",N(E106)=0),"",D106/E106)
IF(OR(D107="",N(E107)=0),"",D107/E107)
IF(OR(D108="",N(E108)=0),"",D108/E108)
IF(OR(D109="",N(E109)=0),"",D109/E109)
IF(OR(D110="",N(E110)=0),"",D110/E110)
IF(OR(D111="",N(E111)=0),"",D111/E111)
IF(OR(D112="",N(E112)=0),"",D112/E112)
IF(OR(D113="",N(E113)=0),"",D113/E113)
IF(OR(D114="",N(E114)=0),"",D114/E114)
IF(OR(D115="",N(E115)=0),"",D115/E115)
IF(OR(D116="",N(E116)=0),"",D116/E116)
IF(OR(D117="",N(E117)=0),"",D117/E117)
IF(OR(D118="",N(E118)=0),"",D118/E118)
IF(OR(D119="",N(E119)=0),"",D119/E119)
IF(OR(D120="",N(E120)=0),"",D120/E120)
IF(OR(D121="",N(E121)=0),"",D121/E121)
IF(OR(D122="",N(E122)=0),"",D122/E122)
IF(OR(D123="",N(E123)=0),"",D123/E123)
IF(OR(D124="",N(E124)=0),"",D124/E124)
IF(OR(D125="",N(E125)=0),"",D125/E125)
IF(OR(D126="",N(E126)=0),"",D126/E126)
IF(OR(D127="",N(E127)=0),"",D127/E127)
IF(OR(D128="",N(E128)=0),"",D128/E128)
IF(OR(D129="",N(E129)=0),"",D129/E129)
IF(OR(D130="",N(E130)=0),"",D130/E130)
IF(OR(D131="",N(E131)=0),"",D131/E131)
IF(OR(D132="",N(E132)=0),"",D132/E132)
IF(OR(D133="",N(E133)=0),"",D133/E133)
IF(OR(D134="",N(E134)=0),"",D134/E134)
IF(OR(D135="",N(E135)=0),"",D135/E135)
IF(OR(D136="",N(E136)=0),"",D136/E136)
IF(OR(D137="",N(E137)=0),"",D137/E137)
IF(OR(D138="",N(E138)=0),"",D138/E138)
IF(OR(D139="",N(E139)=0),"",D139/E139)
IF(OR(D140="",N(E140)=0),"",D140/E140)
IF(OR(D141="",N(E141)=0),"",D141/E141)
IF(OR(D142="",N(E142)=0),"",D142/E142)
IF(OR(D143="",N(E143)=0),"",D143/E143)
IF(OR(D144="",N(E144)=0),"",D144/E144)
IF(OR(D145="",N(E145)=0),"",D145/E145)
IF(OR(D146="",N(E146)=0),"",D146/E146)
IF(OR(D147="",N(E147)=0),"",D147/E147)
IF(OR(D148="",N(E148)=0),"",D148/E148)
IF(OR(D149="",N(E149)=0),"",D149/E149)
IF(OR(D150="",N(E150)=0),"",D150/E150)
IF(OR(D151="",N(E151)=0),"",D151/E151)
IF(OR(D152="",N(E152)=0),"",D152/E152)
IF(OR(D153="",N(E153)=0),"",D153/E153)
IF(OR(D154="",N(E154)=0),"",D154/E154)
IF(OR(D155="",N(E155)=0),"",D155/E155)
IF(OR(D156="",N(E156)=0),"",D156/E156)
IF(OR(D157="",N(E157)=0),"",D157/E157)
IF(OR(D158="",N(E158)=0),"",D158/E158)
IF(OR(D159="",N(E159)=0),"",D159/E159)
IF(OR(D160="",N(E160)=0),"",D160/E160)
IF(OR(D161="",N(E161)=0),"",D161/E161)
IF(OR(D162="",N(E162)=0),"",D162/E162)
IF(OR(D163="",N(E163)=0),"",D163/E163)
IF(OR(D164="",N(E164)=0),"",D164/E164)
IF(OR(D165="",N(E165)=0),"",D165/E165)
IF(OR(D166="",N(E166)=0),"",D166/E166)
IF(OR(D167="",N(E167)=0),"",D167/E167)
IF(OR(D168="",N(E168)=0),"",D168/E168)
IF(OR(D169="",N(E169)=0),"",D169/E169)
IF(OR(D170="",N(E170)=0),"",D170/E170)
IF(OR(D171="",N(E171)=0),"",D171/E171)
IF(OR(D172="",N(E172)=0),"",D172/E172)
IF(OR(D173="",N(E173)=0),"",D173/E173)
IF(OR(D174="",N(E174)=0),"",D174/E174)
IF(OR(D175="",N(E175)=0),"",D175/E175)
IF(OR(D176="",N(E176)=0),"",D176/E176)
IF(OR(D177="",N(E177)=0),"",D177/E177)
IF(OR(D178="",N(E178)=0),"",D178/E178)
IF(OR(D179="",N(E179)=0),"",D179/E179)
IF(OR(D180="",N(E180)=0),"",D180/E180)
IF(OR(D181="",N(E181)=0),"",D181/E181)
IF(OR(D182="",N(E182)=0),"",D182/E182)
IF(OR(D183="",N(E183)=0),"",D183/E183)
IF(OR(D184="",N(E184)=0),"",D184/E184)
IF(OR(D185="",N(E185)=0),"",D185/E185)
IF(OR(D186="",N(E186)=0),"",D186/E186)
IF(OR(D187="",N(E187)=0),"",D187/E187)
IF(OR(D188="",N(E188)=0),"",D188/E188)
IF(OR(D189="",N(E189)=0),"",D189/E189)
IF(OR(D190="",N(E190)=0),"",D190/E190)
IF(OR(D191="",N(E191)=0),"",D191/E191)
IF(OR(D192="",N(E192)=0),"",D192/E192)
IF(OR(D193="",N(E193)=0),"",D193/E193)
IF(OR(D194="",N(E194)=0),"",D194/E194)
IF(OR(D195="",N(E195)=0),"",D195/E195)
IF(OR(D196="",N(E196)=0),"",D196/E196)
IF(OR(D197="",N(E197)=0),"",D197/E197)
IF(OR(D198="",N(E198)=0),"",D198/E198)
IF(OR(D199="",N(E199)=0),"",D199/E199)
IF(OR(D200="",N(E200)=0),"",D200/E200)
IF(OR(D201="",N(E201)=0),"",D201/E201)
IF(OR(D202="",N(E202)=0),"",D202/E202)
IF(OR(D203="",N(E203)=0),"",D203/E203)
IF(OR(D204="",N(E204)=0),"",D204/E204)
IF(OR(D205="",N(E205)=0),"",D205/E205)
IF(OR(D206="",N(E206)=0),"",D206/E206)
IF(OR(D207="",N(E207)=0),"",D207/E207)
IF(OR(D208="",N(E208)=0),"",D208/E208)
IF(OR(D209="",N(E209)=0),"",D209/E209)
IF(OR(D210="",N(E210)=0),"",D210/E210)
IF(OR(D211="",N(E211)=0),"",D211/E211)
IF(OR(D212="",N(E212)=0),"",D212/E212)
IF(OR(D213="",N(E213)=0),"",D213/E213)
IF(OR(D214="",N(E214)=0),"",D214/E214)
IF(OR(D215="",N(E215)=0),"",D215/E215)
IF(OR(D216="",N(E216)=0),"",D216/E216)
IF(OR(D217="",N(E217)=0),"",D217/E217)
IF(OR(D218="",N(E218)=0),"",D218/E218)
IF(OR(D219="",N(E219)=0),"",D219/E219)
IF(OR(D220="",N(E220)=0),"",D220/E220)
IF(OR(D221="",N(E221)=0),"",D221/E221)
IF(OR(D222="",N(E222)=0),"",D222/E222)
IF(OR(D223="",N(E223)=0),"",D223/E223)
IF(OR(D224="",N(E224)=0),"",D224/E224)
IF(OR(D225="",N(E225)=0),"",D225/E225)
IF(OR(D226="",N(E226)=0),"",D226/E226)
IF(OR(D227="",N(E227)=0),"",D227/E227)
IF(OR(D228="",N(E228)=0),"",D228/E228)
IF(OR(D229="",N(E229)=0),"",D229/E229)
IF(OR(D230="",N(E230)=0),"",D230/E230)
IF(OR(D231="",N(E231)=0),"",D231/E231)
IF(OR(D232="",N(E232)=0),"",D232/E232)
IF(OR(D233="",N(E233)=0),"",D233/E233)
IF(OR(D234="",N(E234)=0),"",D234/E234)
IF(OR(D235="",N(E235)=0),"",D235/E235)
IF(OR(D236="",N(E236)=0),"",D236/E236)
IF(OR(D237="",N(E237)=0),"",D237/E237)
IF(OR(D238="",N(E238)=0),"",D238/E238)
IF(OR(D239="",N(E239)=0),"",D239/E239)
IF(OR(D240="",N(E240)=0),"",D240/E240)
IF(OR(D241="",N(E241)=0),"",D241/E241)
IF(OR(D242="",N(E242)=0),"",D242/E242)
IF(OR(D243="",N(E243)=0),"",D243/E243)
IF(OR(D244="",N(E244)=0),"",D244/E244)
IF(OR(D245="",N(E245)=0),"",D245/E245)
IF(OR(D246="",N(E246)=0),"",D246/E246)
IF(OR(D247="",N(E247)=0),"",D247/E247)
IF(OR(D248="",N(E248)=0),"",D248/E248)
IF(OR(D249="",N(E249)=0),"",D249/E249)
IF(OR(D250="",N(E250)=0),"",D250/E250)
IF(OR(D251="",N(E251)=0),"",D251/E251)
IF(OR(D252="",N(E252)=0),"",D252/E252)
IF(OR(D253="",N(E253)=0),"",D253/E253)
IF(OR(D254="",N(E254)=0),"",D254/E254)
IF(OR(D255="",N(E255)=0),"",D255/E255)
IF(OR(D256="",N(E256)=0),"",D256/E256)
IF(OR(D257="",N(E257)=0),"",D257/E257)
IF(OR(D258="",N(E258)=0),"",D258/E258)
IF(OR(D259="",N(E259)=0),"",D259/E259)
IF(OR(D260="",N(E260)=0),"",D260/E260)
IF(OR(D261="",N(E261)=0),"",D261/E261)
IF(OR(D262="",N(E262)=0),"",D262/E262)
IF(OR(D263="",N(E263)=0),"",D263/E263)
IF(OR(D264="",N(E264)=0),"",D264/E264)
IF(OR(D265="",N(E265)=0),"",D265/E265)
IF(OR(D266="",N(E266)=0),"",D266/E266)
IF(OR(D267="",N(E267)=0),"",D267/E267)
IF(OR(D268="",N(E268)=0),"",D268/E268)
IF(OR(D269="",N(E269)=0),"",D269/E269)
IF(OR(D270="",N(E270)=0),"",D270/E270)
IF(OR(D271="",N(E271)=0),"",D271/E271)
IF(OR(D272="",N(E272)=0),"",D272/E272)
IF(OR(D273="",N(E273)=0),"",D273/E273)
IF(OR(D274="",N(E274)=0),"",D274/E274)
IF(OR(D275="",N(E275)=0),"",D275/E275)
IF(OR(D276="",N(E276)=0),"",D276/E276)
IF(OR(D277="",N(E277)=0),"",D277/E277)
IF(OR(D278="",N(E278)=0),"",D278/E278)
IF(OR(D279="",N(E279)=0),"",D279/E279)
IF(OR(D280="",N(E280)=0),"",D280/E280)
IF(OR(D281="",N(E281)=0),"",D281/E281)
IF(OR(D282="",N(E282)=0),"",D282/E282)
IF(OR(D283="",N(E283)=0),"",D283/E283)
IF(OR(D284="",N(E284)=0),"",D284/E284)
IF(OR(D285="",N(E285)=0),"",D285/E285)
IF(OR(D286="",N(E286)=0),"",D286/E286)
IF(OR(D287="",N(E287)=0),"",D287/E287)
IF(OR(D288="",N(E288)=0),"",D288/E288)
IF(OR(D289="",N(E289)=0),"",D289/E289)
IF(OR(D290="",N(E290)=0),"",D290/E290)
IF(OR(D291="",N(E291)=0),"",D291/E291)
IF(OR(D292="",N(E292)=0),"",D292/E292)
IF(OR(D293="",N(E293)=0),"",D293/E293)
IF(OR(D294="",N(E294)=0),"",D294/E294)
IF(OR(D295="",N(E295)=0),"",D295/E295)
IF(OR(D296="",N(E296)=0),"",D296/E296)
IF(OR(D297="",N(E297)=0),"",D297/E297)
IF(OR(D298="",N(E298)=0),"",D298/E298)
IF(OR(D299="",N(E299)=0),"",D299/E299)
IF(OR(D300="",N(E300)=0),"",D300/E300)
IF(OR(D301="",N(E301)=0),"",D301/E301)
=Lists!$A$2:$A$16PK ! HÄÊ9T 9T xl/worksheets/sheet4.xmlMonthly Summary
Year:2026<- type the year you want to see
MonthLoadsRevenue ($)Loaded MilesDeadhead MilesDeadhead %Expenses ($)Net Profit ($)Revenue / Total MileCost / Total MileProfit / Total MileFuel ($)Fuel GallonsAvg Fuel $/gal
DATE($B$2,1,1)COUNTIFS(Loads!$A$2:$A$301,">="&DATE($B$2,1,1),Loads!$A$2:$A$301,"<"&DATE($B$2,2,1))SUMIFS(Loads!$L$2:$L$301,Loads!$A$2:$A$301,">="&DATE($B$2,1,1),Loads!$A$2:$A$301,"<"&DATE($B$2,2,1))SUMIFS(Loads!$F$2:$F$301,Loads!$A$2:$A$301,">="&DATE($B$2,1,1),Loads!$A$2:$A$301,"<"&DATE($B$2,2,1))SUMIFS(Loads!$G$2:$G$301,Loads!$A$2:$A$301,">="&DATE($B$2,1,1),Loads!$A$2:$A$301,"<"&DATE($B$2,2,1))IF(D5+E5=0,0,E5/(D5+E5))SUMIFS(Expenses!$D$2:$D$301,Expenses!$A$2:$A$301,">="&DATE($B$2,1,1),Expenses!$A$2:$A$301,"<"&DATE($B$2,2,1))C5-G5IF(D5+E5=0,0,C5/(D5+E5))IF(D5+E5=0,0,G5/(D5+E5))I5-J5SUMIFS(Expenses!$D$2:$D$301,Expenses!$A$2:$A$301,">="&DATE($B$2,1,1),Expenses!$A$2:$A$301,"<"&DATE($B$2,2,1),Expenses!$B$2:$B$301,"Fuel")SUMIFS(Expenses!$E$2:$E$301,Expenses!$A$2:$A$301,">="&DATE($B$2,1,1),Expenses!$A$2:$A$301,"<"&DATE($B$2,2,1),Expenses!$B$2:$B$301,"Fuel")IF(M5=0,0,L5/M5)
DATE($B$2,2,1)COUNTIFS(Loads!$A$2:$A$301,">="&DATE($B$2,2,1),Loads!$A$2:$A$301,"<"&DATE($B$2,3,1))SUMIFS(Loads!$L$2:$L$301,Loads!$A$2:$A$301,">="&DATE($B$2,2,1),Loads!$A$2:$A$301,"<"&DATE($B$2,3,1))SUMIFS(Loads!$F$2:$F$301,Loads!$A$2:$A$301,">="&DATE($B$2,2,1),Loads!$A$2:$A$301,"<"&DATE($B$2,3,1))SUMIFS(Loads!$G$2:$G$301,Loads!$A$2:$A$301,">="&DATE($B$2,2,1),Loads!$A$2:$A$301,"<"&DATE($B$2,3,1))IF(D6+E6=0,0,E6/(D6+E6))SUMIFS(Expenses!$D$2:$D$301,Expenses!$A$2:$A$301,">="&DATE($B$2,2,1),Expenses!$A$2:$A$301,"<"&DATE($B$2,3,1))C6-G6IF(D6+E6=0,0,C6/(D6+E6))IF(D6+E6=0,0,G6/(D6+E6))I6-J6SUMIFS(Expenses!$D$2:$D$301,Expenses!$A$2:$A$301,">="&DATE($B$2,2,1),Expenses!$A$2:$A$301,"<"&DATE($B$2,3,1),Expenses!$B$2:$B$301,"Fuel")SUMIFS(Expenses!$E$2:$E$301,Expenses!$A$2:$A$301,">="&DATE($B$2,2,1),Expenses!$A$2:$A$301,"<"&DATE($B$2,3,1),Expenses!$B$2:$B$301,"Fuel")IF(M6=0,0,L6/M6)
DATE($B$2,3,1)COUNTIFS(Loads!$A$2:$A$301,">="&DATE($B$2,3,1),Loads!$A$2:$A$301,"<"&DATE($B$2,4,1))SUMIFS(Loads!$L$2:$L$301,Loads!$A$2:$A$301,">="&DATE($B$2,3,1),Loads!$A$2:$A$301,"<"&DATE($B$2,4,1))SUMIFS(Loads!$F$2:$F$301,Loads!$A$2:$A$301,">="&DATE($B$2,3,1),Loads!$A$2:$A$301,"<"&DATE($B$2,4,1))SUMIFS(Loads!$G$2:$G$301,Loads!$A$2:$A$301,">="&DATE($B$2,3,1),Loads!$A$2:$A$301,"<"&DATE($B$2,4,1))IF(D7+E7=0,0,E7/(D7+E7))SUMIFS(Expenses!$D$2:$D$301,Expenses!$A$2:$A$301,">="&DATE($B$2,3,1),Expenses!$A$2:$A$301,"<"&DATE($B$2,4,1))C7-G7IF(D7+E7=0,0,C7/(D7+E7))IF(D7+E7=0,0,G7/(D7+E7))I7-J7SUMIFS(Expenses!$D$2:$D$301,Expenses!$A$2:$A$301,">="&DATE($B$2,3,1),Expenses!$A$2:$A$301,"<"&DATE($B$2,4,1),Expenses!$B$2:$B$301,"Fuel")SUMIFS(Expenses!$E$2:$E$301,Expenses!$A$2:$A$301,">="&DATE($B$2,3,1),Expenses!$A$2:$A$301,"<"&DATE($B$2,4,1),Expenses!$B$2:$B$301,"Fuel")IF(M7=0,0,L7/M7)
DATE($B$2,4,1)COUNTIFS(Loads!$A$2:$A$301,">="&DATE($B$2,4,1),Loads!$A$2:$A$301,"<"&DATE($B$2,5,1))SUMIFS(Loads!$L$2:$L$301,Loads!$A$2:$A$301,">="&DATE($B$2,4,1),Loads!$A$2:$A$301,"<"&DATE($B$2,5,1))SUMIFS(Loads!$F$2:$F$301,Loads!$A$2:$A$301,">="&DATE($B$2,4,1),Loads!$A$2:$A$301,"<"&DATE($B$2,5,1))SUMIFS(Loads!$G$2:$G$301,Loads!$A$2:$A$301,">="&DATE($B$2,4,1),Loads!$A$2:$A$301,"<"&DATE($B$2,5,1))IF(D8+E8=0,0,E8/(D8+E8))SUMIFS(Expenses!$D$2:$D$301,Expenses!$A$2:$A$301,">="&DATE($B$2,4,1),Expenses!$A$2:$A$301,"<"&DATE($B$2,5,1))C8-G8IF(D8+E8=0,0,C8/(D8+E8))IF(D8+E8=0,0,G8/(D8+E8))I8-J8SUMIFS(Expenses!$D$2:$D$301,Expenses!$A$2:$A$301,">="&DATE($B$2,4,1),Expenses!$A$2:$A$301,"<"&DATE($B$2,5,1),Expenses!$B$2:$B$301,"Fuel")SUMIFS(Expenses!$E$2:$E$301,Expenses!$A$2:$A$301,">="&DATE($B$2,4,1),Expenses!$A$2:$A$301,"<"&DATE($B$2,5,1),Expenses!$B$2:$B$301,"Fuel")IF(M8=0,0,L8/M8)
DATE($B$2,5,1)COUNTIFS(Loads!$A$2:$A$301,">="&DATE($B$2,5,1),Loads!$A$2:$A$301,"<"&DATE($B$2,6,1))SUMIFS(Loads!$L$2:$L$301,Loads!$A$2:$A$301,">="&DATE($B$2,5,1),Loads!$A$2:$A$301,"<"&DATE($B$2,6,1))SUMIFS(Loads!$F$2:$F$301,Loads!$A$2:$A$301,">="&DATE($B$2,5,1),Loads!$A$2:$A$301,"<"&DATE($B$2,6,1))SUMIFS(Loads!$G$2:$G$301,Loads!$A$2:$A$301,">="&DATE($B$2,5,1),Loads!$A$2:$A$301,"<"&DATE($B$2,6,1))IF(D9+E9=0,0,E9/(D9+E9))SUMIFS(Expenses!$D$2:$D$301,Expenses!$A$2:$A$301,">="&DATE($B$2,5,1),Expenses!$A$2:$A$301,"<"&DATE($B$2,6,1))C9-G9IF(D9+E9=0,0,C9/(D9+E9))IF(D9+E9=0,0,G9/(D9+E9))I9-J9SUMIFS(Expenses!$D$2:$D$301,Expenses!$A$2:$A$301,">="&DATE($B$2,5,1),Expenses!$A$2:$A$301,"<"&DATE($B$2,6,1),Expenses!$B$2:$B$301,"Fuel")SUMIFS(Expenses!$E$2:$E$301,Expenses!$A$2:$A$301,">="&DATE($B$2,5,1),Expenses!$A$2:$A$301,"<"&DATE($B$2,6,1),Expenses!$B$2:$B$301,"Fuel")IF(M9=0,0,L9/M9)
DATE($B$2,6,1)COUNTIFS(Loads!$A$2:$A$301,">="&DATE($B$2,6,1),Loads!$A$2:$A$301,"<"&DATE($B$2,7,1))SUMIFS(Loads!$L$2:$L$301,Loads!$A$2:$A$301,">="&DATE($B$2,6,1),Loads!$A$2:$A$301,"<"&DATE($B$2,7,1))SUMIFS(Loads!$F$2:$F$301,Loads!$A$2:$A$301,">="&DATE($B$2,6,1),Loads!$A$2:$A$301,"<"&DATE($B$2,7,1))SUMIFS(Loads!$G$2:$G$301,Loads!$A$2:$A$301,">="&DATE($B$2,6,1),Loads!$A$2:$A$301,"<"&DATE($B$2,7,1))IF(D10+E10=0,0,E10/(D10+E10))SUMIFS(Expenses!$D$2:$D$301,Expenses!$A$2:$A$301,">="&DATE($B$2,6,1),Expenses!$A$2:$A$301,"<"&DATE($B$2,7,1))C10-G10IF(D10+E10=0,0,C10/(D10+E10))IF(D10+E10=0,0,G10/(D10+E10))I10-J10SUMIFS(Expenses!$D$2:$D$301,Expenses!$A$2:$A$301,">="&DATE($B$2,6,1),Expenses!$A$2:$A$301,"<"&DATE($B$2,7,1),Expenses!$B$2:$B$301,"Fuel")SUMIFS(Expenses!$E$2:$E$301,Expenses!$A$2:$A$301,">="&DATE($B$2,6,1),Expenses!$A$2:$A$301,"<"&DATE($B$2,7,1),Expenses!$B$2:$B$301,"Fuel")IF(M10=0,0,L10/M10)
DATE($B$2,7,1)COUNTIFS(Loads!$A$2:$A$301,">="&DATE($B$2,7,1),Loads!$A$2:$A$301,"<"&DATE($B$2,8,1))SUMIFS(Loads!$L$2:$L$301,Loads!$A$2:$A$301,">="&DATE($B$2,7,1),Loads!$A$2:$A$301,"<"&DATE($B$2,8,1))SUMIFS(Loads!$F$2:$F$301,Loads!$A$2:$A$301,">="&DATE($B$2,7,1),Loads!$A$2:$A$301,"<"&DATE($B$2,8,1))SUMIFS(Loads!$G$2:$G$301,Loads!$A$2:$A$301,">="&DATE($B$2,7,1),Loads!$A$2:$A$301,"<"&DATE($B$2,8,1))IF(D11+E11=0,0,E11/(D11+E11))SUMIFS(Expenses!$D$2:$D$301,Expenses!$A$2:$A$301,">="&DATE($B$2,7,1),Expenses!$A$2:$A$301,"<"&DATE($B$2,8,1))C11-G11IF(D11+E11=0,0,C11/(D11+E11))IF(D11+E11=0,0,G11/(D11+E11))I11-J11SUMIFS(Expenses!$D$2:$D$301,Expenses!$A$2:$A$301,">="&DATE($B$2,7,1),Expenses!$A$2:$A$301,"<"&DATE($B$2,8,1),Expenses!$B$2:$B$301,"Fuel")SUMIFS(Expenses!$E$2:$E$301,Expenses!$A$2:$A$301,">="&DATE($B$2,7,1),Expenses!$A$2:$A$301,"<"&DATE($B$2,8,1),Expenses!$B$2:$B$301,"Fuel")IF(M11=0,0,L11/M11)
DATE($B$2,8,1)COUNTIFS(Loads!$A$2:$A$301,">="&DATE($B$2,8,1),Loads!$A$2:$A$301,"<"&DATE($B$2,9,1))SUMIFS(Loads!$L$2:$L$301,Loads!$A$2:$A$301,">="&DATE($B$2,8,1),Loads!$A$2:$A$301,"<"&DATE($B$2,9,1))SUMIFS(Loads!$F$2:$F$301,Loads!$A$2:$A$301,">="&DATE($B$2,8,1),Loads!$A$2:$A$301,"<"&DATE($B$2,9,1))SUMIFS(Loads!$G$2:$G$301,Loads!$A$2:$A$301,">="&DATE($B$2,8,1),Loads!$A$2:$A$301,"<"&DATE($B$2,9,1))IF(D12+E12=0,0,E12/(D12+E12))SUMIFS(Expenses!$D$2:$D$301,Expenses!$A$2:$A$301,">="&DATE($B$2,8,1),Expenses!$A$2:$A$301,"<"&DATE($B$2,9,1))C12-G12IF(D12+E12=0,0,C12/(D12+E12))IF(D12+E12=0,0,G12/(D12+E12))I12-J12SUMIFS(Expenses!$D$2:$D$301,Expenses!$A$2:$A$301,">="&DATE($B$2,8,1),Expenses!$A$2:$A$301,"<"&DATE($B$2,9,1),Expenses!$B$2:$B$301,"Fuel")SUMIFS(Expenses!$E$2:$E$301,Expenses!$A$2:$A$301,">="&DATE($B$2,8,1),Expenses!$A$2:$A$301,"<"&DATE($B$2,9,1),Expenses!$B$2:$B$301,"Fuel")IF(M12=0,0,L12/M12)
DATE($B$2,9,1)COUNTIFS(Loads!$A$2:$A$301,">="&DATE($B$2,9,1),Loads!$A$2:$A$301,"<"&DATE($B$2,10,1))SUMIFS(Loads!$L$2:$L$301,Loads!$A$2:$A$301,">="&DATE($B$2,9,1),Loads!$A$2:$A$301,"<"&DATE($B$2,10,1))SUMIFS(Loads!$F$2:$F$301,Loads!$A$2:$A$301,">="&DATE($B$2,9,1),Loads!$A$2:$A$301,"<"&DATE($B$2,10,1))SUMIFS(Loads!$G$2:$G$301,Loads!$A$2:$A$301,">="&DATE($B$2,9,1),Loads!$A$2:$A$301,"<"&DATE($B$2,10,1))IF(D13+E13=0,0,E13/(D13+E13))SUMIFS(Expenses!$D$2:$D$301,Expenses!$A$2:$A$301,">="&DATE($B$2,9,1),Expenses!$A$2:$A$301,"<"&DATE($B$2,10,1))C13-G13IF(D13+E13=0,0,C13/(D13+E13))IF(D13+E13=0,0,G13/(D13+E13))I13-J13SUMIFS(Expenses!$D$2:$D$301,Expenses!$A$2:$A$301,">="&DATE($B$2,9,1),Expenses!$A$2:$A$301,"<"&DATE($B$2,10,1),Expenses!$B$2:$B$301,"Fuel")SUMIFS(Expenses!$E$2:$E$301,Expenses!$A$2:$A$301,">="&DATE($B$2,9,1),Expenses!$A$2:$A$301,"<"&DATE($B$2,10,1),Expenses!$B$2:$B$301,"Fuel")IF(M13=0,0,L13/M13)
DATE($B$2,10,1)COUNTIFS(Loads!$A$2:$A$301,">="&DATE($B$2,10,1),Loads!$A$2:$A$301,"<"&DATE($B$2,11,1))SUMIFS(Loads!$L$2:$L$301,Loads!$A$2:$A$301,">="&DATE($B$2,10,1),Loads!$A$2:$A$301,"<"&DATE($B$2,11,1))SUMIFS(Loads!$F$2:$F$301,Loads!$A$2:$A$301,">="&DATE($B$2,10,1),Loads!$A$2:$A$301,"<"&DATE($B$2,11,1))SUMIFS(Loads!$G$2:$G$301,Loads!$A$2:$A$301,">="&DATE($B$2,10,1),Loads!$A$2:$A$301,"<"&DATE($B$2,11,1))IF(D14+E14=0,0,E14/(D14+E14))SUMIFS(Expenses!$D$2:$D$301,Expenses!$A$2:$A$301,">="&DATE($B$2,10,1),Expenses!$A$2:$A$301,"<"&DATE($B$2,11,1))C14-G14IF(D14+E14=0,0,C14/(D14+E14))IF(D14+E14=0,0,G14/(D14+E14))I14-J14SUMIFS(Expenses!$D$2:$D$301,Expenses!$A$2:$A$301,">="&DATE($B$2,10,1),Expenses!$A$2:$A$301,"<"&DATE($B$2,11,1),Expenses!$B$2:$B$301,"Fuel")SUMIFS(Expenses!$E$2:$E$301,Expenses!$A$2:$A$301,">="&DATE($B$2,10,1),Expenses!$A$2:$A$301,"<"&DATE($B$2,11,1),Expenses!$B$2:$B$301,"Fuel")IF(M14=0,0,L14/M14)
DATE($B$2,11,1)COUNTIFS(Loads!$A$2:$A$301,">="&DATE($B$2,11,1),Loads!$A$2:$A$301,"<"&DATE($B$2,12,1))SUMIFS(Loads!$L$2:$L$301,Loads!$A$2:$A$301,">="&DATE($B$2,11,1),Loads!$A$2:$A$301,"<"&DATE($B$2,12,1))SUMIFS(Loads!$F$2:$F$301,Loads!$A$2:$A$301,">="&DATE($B$2,11,1),Loads!$A$2:$A$301,"<"&DATE($B$2,12,1))SUMIFS(Loads!$G$2:$G$301,Loads!$A$2:$A$301,">="&DATE($B$2,11,1),Loads!$A$2:$A$301,"<"&DATE($B$2,12,1))IF(D15+E15=0,0,E15/(D15+E15))SUMIFS(Expenses!$D$2:$D$301,Expenses!$A$2:$A$301,">="&DATE($B$2,11,1),Expenses!$A$2:$A$301,"<"&DATE($B$2,12,1))C15-G15IF(D15+E15=0,0,C15/(D15+E15))IF(D15+E15=0,0,G15/(D15+E15))I15-J15SUMIFS(Expenses!$D$2:$D$301,Expenses!$A$2:$A$301,">="&DATE($B$2,11,1),Expenses!$A$2:$A$301,"<"&DATE($B$2,12,1),Expenses!$B$2:$B$301,"Fuel")SUMIFS(Expenses!$E$2:$E$301,Expenses!$A$2:$A$301,">="&DATE($B$2,11,1),Expenses!$A$2:$A$301,"<"&DATE($B$2,12,1),Expenses!$B$2:$B$301,"Fuel")IF(M15=0,0,L15/M15)
DATE($B$2,12,1)COUNTIFS(Loads!$A$2:$A$301,">="&DATE($B$2,12,1),Loads!$A$2:$A$301,"<"&DATE($B$2+1,1,1))SUMIFS(Loads!$L$2:$L$301,Loads!$A$2:$A$301,">="&DATE($B$2,12,1),Loads!$A$2:$A$301,"<"&DATE($B$2+1,1,1))SUMIFS(Loads!$F$2:$F$301,Loads!$A$2:$A$301,">="&DATE($B$2,12,1),Loads!$A$2:$A$301,"<"&DATE($B$2+1,1,1))SUMIFS(Loads!$G$2:$G$301,Loads!$A$2:$A$301,">="&DATE($B$2,12,1),Loads!$A$2:$A$301,"<"&DATE($B$2+1,1,1))IF(D16+E16=0,0,E16/(D16+E16))SUMIFS(Expenses!$D$2:$D$301,Expenses!$A$2:$A$301,">="&DATE($B$2,12,1),Expenses!$A$2:$A$301,"<"&DATE($B$2+1,1,1))C16-G16IF(D16+E16=0,0,C16/(D16+E16))IF(D16+E16=0,0,G16/(D16+E16))I16-J16SUMIFS(Expenses!$D$2:$D$301,Expenses!$A$2:$A$301,">="&DATE($B$2,12,1),Expenses!$A$2:$A$301,"<"&DATE($B$2+1,1,1),Expenses!$B$2:$B$301,"Fuel")SUMIFS(Expenses!$E$2:$E$301,Expenses!$A$2:$A$301,">="&DATE($B$2,12,1),Expenses!$A$2:$A$301,"<"&DATE($B$2+1,1,1),Expenses!$B$2:$B$301,"Fuel")IF(M16=0,0,L16/M16)
Year TotalSUM(B5:B16)SUM(C5:C16)SUM(D5:D16)SUM(E5:E16)IF(D17+E17=0,0,E17/(D17+E17))SUM(G5:G16)SUM(H5:H16)IF(D17+E17=0,0,C17/(D17+E17))IF(D17+E17=0,0,G17/(D17+E17))I17-J17SUM(L5:L16)SUM(M5:M16)IF(M17=0,0,L17/M17)
Revenue is counted in the month of the 'Date Delivered'. Total miles = loaded + deadhead.
PK ! ÕÑéÖ éÖ xl/worksheets/sheet5.xmlBroker Scorecard
Type each broker name once, spelled exactly like on the Loads tab.
Broker / CustomerLoadsRevenue ($)Loaded MilesAvg RPM (Loaded)Paid LoadsAvg Days to PayUnpaid LoadsUnpaid Balance ($)
Example Logistics LLCIF($A5="","",COUNTIFS(Loads!$B$2:$B$301,$A5))IF($A5="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A5))IF($A5="","",SUMIFS(Loads!$F$2:$F$301,Loads!$B$2:$B$301,$A5))IF(OR($A5="",N(D5)=0),"",C5/D5)IF($A5="","",COUNTIFS(Loads!$B$2:$B$301,$A5,Loads!$R$2:$R$301,"Paid"))IF(OR($A5="",N(F5)=0),"",SUMIFS(Loads!$Q$2:$Q$301,Loads!$B$2:$B$301,$A5,Loads!$R$2:$R$301,"Paid")/F5)IF($A5="","",COUNTIFS(Loads!$B$2:$B$301,$A5,Loads!$R$2:$R$301,"Invoiced"))IF($A5="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A5,Loads!$R$2:$R$301,"Invoiced"))
IF($A6="","",COUNTIFS(Loads!$B$2:$B$301,$A6))IF($A6="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A6))IF($A6="","",SUMIFS(Loads!$F$2:$F$301,Loads!$B$2:$B$301,$A6))IF(OR($A6="",N(D6)=0),"",C6/D6)IF($A6="","",COUNTIFS(Loads!$B$2:$B$301,$A6,Loads!$R$2:$R$301,"Paid"))IF(OR($A6="",N(F6)=0),"",SUMIFS(Loads!$Q$2:$Q$301,Loads!$B$2:$B$301,$A6,Loads!$R$2:$R$301,"Paid")/F6)IF($A6="","",COUNTIFS(Loads!$B$2:$B$301,$A6,Loads!$R$2:$R$301,"Invoiced"))IF($A6="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A6,Loads!$R$2:$R$301,"Invoiced"))
IF($A7="","",COUNTIFS(Loads!$B$2:$B$301,$A7))IF($A7="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A7))IF($A7="","",SUMIFS(Loads!$F$2:$F$301,Loads!$B$2:$B$301,$A7))IF(OR($A7="",N(D7)=0),"",C7/D7)IF($A7="","",COUNTIFS(Loads!$B$2:$B$301,$A7,Loads!$R$2:$R$301,"Paid"))IF(OR($A7="",N(F7)=0),"",SUMIFS(Loads!$Q$2:$Q$301,Loads!$B$2:$B$301,$A7,Loads!$R$2:$R$301,"Paid")/F7)IF($A7="","",COUNTIFS(Loads!$B$2:$B$301,$A7,Loads!$R$2:$R$301,"Invoiced"))IF($A7="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A7,Loads!$R$2:$R$301,"Invoiced"))
IF($A8="","",COUNTIFS(Loads!$B$2:$B$301,$A8))IF($A8="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A8))IF($A8="","",SUMIFS(Loads!$F$2:$F$301,Loads!$B$2:$B$301,$A8))IF(OR($A8="",N(D8)=0),"",C8/D8)IF($A8="","",COUNTIFS(Loads!$B$2:$B$301,$A8,Loads!$R$2:$R$301,"Paid"))IF(OR($A8="",N(F8)=0),"",SUMIFS(Loads!$Q$2:$Q$301,Loads!$B$2:$B$301,$A8,Loads!$R$2:$R$301,"Paid")/F8)IF($A8="","",COUNTIFS(Loads!$B$2:$B$301,$A8,Loads!$R$2:$R$301,"Invoiced"))IF($A8="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A8,Loads!$R$2:$R$301,"Invoiced"))
IF($A9="","",COUNTIFS(Loads!$B$2:$B$301,$A9))IF($A9="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A9))IF($A9="","",SUMIFS(Loads!$F$2:$F$301,Loads!$B$2:$B$301,$A9))IF(OR($A9="",N(D9)=0),"",C9/D9)IF($A9="","",COUNTIFS(Loads!$B$2:$B$301,$A9,Loads!$R$2:$R$301,"Paid"))IF(OR($A9="",N(F9)=0),"",SUMIFS(Loads!$Q$2:$Q$301,Loads!$B$2:$B$301,$A9,Loads!$R$2:$R$301,"Paid")/F9)IF($A9="","",COUNTIFS(Loads!$B$2:$B$301,$A9,Loads!$R$2:$R$301,"Invoiced"))IF($A9="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A9,Loads!$R$2:$R$301,"Invoiced"))
IF($A10="","",COUNTIFS(Loads!$B$2:$B$301,$A10))IF($A10="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A10))IF($A10="","",SUMIFS(Loads!$F$2:$F$301,Loads!$B$2:$B$301,$A10))IF(OR($A10="",N(D10)=0),"",C10/D10)IF($A10="","",COUNTIFS(Loads!$B$2:$B$301,$A10,Loads!$R$2:$R$301,"Paid"))IF(OR($A10="",N(F10)=0),"",SUMIFS(Loads!$Q$2:$Q$301,Loads!$B$2:$B$301,$A10,Loads!$R$2:$R$301,"Paid")/F10)IF($A10="","",COUNTIFS(Loads!$B$2:$B$301,$A10,Loads!$R$2:$R$301,"Invoiced"))IF($A10="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A10,Loads!$R$2:$R$301,"Invoiced"))
IF($A11="","",COUNTIFS(Loads!$B$2:$B$301,$A11))IF($A11="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A11))IF($A11="","",SUMIFS(Loads!$F$2:$F$301,Loads!$B$2:$B$301,$A11))IF(OR($A11="",N(D11)=0),"",C11/D11)IF($A11="","",COUNTIFS(Loads!$B$2:$B$301,$A11,Loads!$R$2:$R$301,"Paid"))IF(OR($A11="",N(F11)=0),"",SUMIFS(Loads!$Q$2:$Q$301,Loads!$B$2:$B$301,$A11,Loads!$R$2:$R$301,"Paid")/F11)IF($A11="","",COUNTIFS(Loads!$B$2:$B$301,$A11,Loads!$R$2:$R$301,"Invoiced"))IF($A11="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A11,Loads!$R$2:$R$301,"Invoiced"))
IF($A12="","",COUNTIFS(Loads!$B$2:$B$301,$A12))IF($A12="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A12))IF($A12="","",SUMIFS(Loads!$F$2:$F$301,Loads!$B$2:$B$301,$A12))IF(OR($A12="",N(D12)=0),"",C12/D12)IF($A12="","",COUNTIFS(Loads!$B$2:$B$301,$A12,Loads!$R$2:$R$301,"Paid"))IF(OR($A12="",N(F12)=0),"",SUMIFS(Loads!$Q$2:$Q$301,Loads!$B$2:$B$301,$A12,Loads!$R$2:$R$301,"Paid")/F12)IF($A12="","",COUNTIFS(Loads!$B$2:$B$301,$A12,Loads!$R$2:$R$301,"Invoiced"))IF($A12="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A12,Loads!$R$2:$R$301,"Invoiced"))
IF($A13="","",COUNTIFS(Loads!$B$2:$B$301,$A13))IF($A13="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A13))IF($A13="","",SUMIFS(Loads!$F$2:$F$301,Loads!$B$2:$B$301,$A13))IF(OR($A13="",N(D13)=0),"",C13/D13)IF($A13="","",COUNTIFS(Loads!$B$2:$B$301,$A13,Loads!$R$2:$R$301,"Paid"))IF(OR($A13="",N(F13)=0),"",SUMIFS(Loads!$Q$2:$Q$301,Loads!$B$2:$B$301,$A13,Loads!$R$2:$R$301,"Paid")/F13)IF($A13="","",COUNTIFS(Loads!$B$2:$B$301,$A13,Loads!$R$2:$R$301,"Invoiced"))IF($A13="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A13,Loads!$R$2:$R$301,"Invoiced"))
IF($A14="","",COUNTIFS(Loads!$B$2:$B$301,$A14))IF($A14="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A14))IF($A14="","",SUMIFS(Loads!$F$2:$F$301,Loads!$B$2:$B$301,$A14))IF(OR($A14="",N(D14)=0),"",C14/D14)IF($A14="","",COUNTIFS(Loads!$B$2:$B$301,$A14,Loads!$R$2:$R$301,"Paid"))IF(OR($A14="",N(F14)=0),"",SUMIFS(Loads!$Q$2:$Q$301,Loads!$B$2:$B$301,$A14,Loads!$R$2:$R$301,"Paid")/F14)IF($A14="","",COUNTIFS(Loads!$B$2:$B$301,$A14,Loads!$R$2:$R$301,"Invoiced"))IF($A14="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A14,Loads!$R$2:$R$301,"Invoiced"))
IF($A15="","",COUNTIFS(Loads!$B$2:$B$301,$A15))IF($A15="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A15))IF($A15="","",SUMIFS(Loads!$F$2:$F$301,Loads!$B$2:$B$301,$A15))IF(OR($A15="",N(D15)=0),"",C15/D15)IF($A15="","",COUNTIFS(Loads!$B$2:$B$301,$A15,Loads!$R$2:$R$301,"Paid"))IF(OR($A15="",N(F15)=0),"",SUMIFS(Loads!$Q$2:$Q$301,Loads!$B$2:$B$301,$A15,Loads!$R$2:$R$301,"Paid")/F15)IF($A15="","",COUNTIFS(Loads!$B$2:$B$301,$A15,Loads!$R$2:$R$301,"Invoiced"))IF($A15="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A15,Loads!$R$2:$R$301,"Invoiced"))
IF($A16="","",COUNTIFS(Loads!$B$2:$B$301,$A16))IF($A16="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A16))IF($A16="","",SUMIFS(Loads!$F$2:$F$301,Loads!$B$2:$B$301,$A16))IF(OR($A16="",N(D16)=0),"",C16/D16)IF($A16="","",COUNTIFS(Loads!$B$2:$B$301,$A16,Loads!$R$2:$R$301,"Paid"))IF(OR($A16="",N(F16)=0),"",SUMIFS(Loads!$Q$2:$Q$301,Loads!$B$2:$B$301,$A16,Loads!$R$2:$R$301,"Paid")/F16)IF($A16="","",COUNTIFS(Loads!$B$2:$B$301,$A16,Loads!$R$2:$R$301,"Invoiced"))IF($A16="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A16,Loads!$R$2:$R$301,"Invoiced"))
IF($A17="","",COUNTIFS(Loads!$B$2:$B$301,$A17))IF($A17="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A17))IF($A17="","",SUMIFS(Loads!$F$2:$F$301,Loads!$B$2:$B$301,$A17))IF(OR($A17="",N(D17)=0),"",C17/D17)IF($A17="","",COUNTIFS(Loads!$B$2:$B$301,$A17,Loads!$R$2:$R$301,"Paid"))IF(OR($A17="",N(F17)=0),"",SUMIFS(Loads!$Q$2:$Q$301,Loads!$B$2:$B$301,$A17,Loads!$R$2:$R$301,"Paid")/F17)IF($A17="","",COUNTIFS(Loads!$B$2:$B$301,$A17,Loads!$R$2:$R$301,"Invoiced"))IF($A17="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A17,Loads!$R$2:$R$301,"Invoiced"))
IF($A18="","",COUNTIFS(Loads!$B$2:$B$301,$A18))IF($A18="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A18))IF($A18="","",SUMIFS(Loads!$F$2:$F$301,Loads!$B$2:$B$301,$A18))IF(OR($A18="",N(D18)=0),"",C18/D18)IF($A18="","",COUNTIFS(Loads!$B$2:$B$301,$A18,Loads!$R$2:$R$301,"Paid"))IF(OR($A18="",N(F18)=0),"",SUMIFS(Loads!$Q$2:$Q$301,Loads!$B$2:$B$301,$A18,Loads!$R$2:$R$301,"Paid")/F18)IF($A18="","",COUNTIFS(Loads!$B$2:$B$301,$A18,Loads!$R$2:$R$301,"Invoiced"))IF($A18="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A18,Loads!$R$2:$R$301,"Invoiced"))
IF($A19="","",COUNTIFS(Loads!$B$2:$B$301,$A19))IF($A19="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A19))IF($A19="","",SUMIFS(Loads!$F$2:$F$301,Loads!$B$2:$B$301,$A19))IF(OR($A19="",N(D19)=0),"",C19/D19)IF($A19="","",COUNTIFS(Loads!$B$2:$B$301,$A19,Loads!$R$2:$R$301,"Paid"))IF(OR($A19="",N(F19)=0),"",SUMIFS(Loads!$Q$2:$Q$301,Loads!$B$2:$B$301,$A19,Loads!$R$2:$R$301,"Paid")/F19)IF($A19="","",COUNTIFS(Loads!$B$2:$B$301,$A19,Loads!$R$2:$R$301,"Invoiced"))IF($A19="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A19,Loads!$R$2:$R$301,"Invoiced"))
IF($A20="","",COUNTIFS(Loads!$B$2:$B$301,$A20))IF($A20="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A20))IF($A20="","",SUMIFS(Loads!$F$2:$F$301,Loads!$B$2:$B$301,$A20))IF(OR($A20="",N(D20)=0),"",C20/D20)IF($A20="","",COUNTIFS(Loads!$B$2:$B$301,$A20,Loads!$R$2:$R$301,"Paid"))IF(OR($A20="",N(F20)=0),"",SUMIFS(Loads!$Q$2:$Q$301,Loads!$B$2:$B$301,$A20,Loads!$R$2:$R$301,"Paid")/F20)IF($A20="","",COUNTIFS(Loads!$B$2:$B$301,$A20,Loads!$R$2:$R$301,"Invoiced"))IF($A20="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A20,Loads!$R$2:$R$301,"Invoiced"))
IF($A21="","",COUNTIFS(Loads!$B$2:$B$301,$A21))IF($A21="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A21))IF($A21="","",SUMIFS(Loads!$F$2:$F$301,Loads!$B$2:$B$301,$A21))IF(OR($A21="",N(D21)=0),"",C21/D21)IF($A21="","",COUNTIFS(Loads!$B$2:$B$301,$A21,Loads!$R$2:$R$301,"Paid"))IF(OR($A21="",N(F21)=0),"",SUMIFS(Loads!$Q$2:$Q$301,Loads!$B$2:$B$301,$A21,Loads!$R$2:$R$301,"Paid")/F21)IF($A21="","",COUNTIFS(Loads!$B$2:$B$301,$A21,Loads!$R$2:$R$301,"Invoiced"))IF($A21="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A21,Loads!$R$2:$R$301,"Invoiced"))
IF($A22="","",COUNTIFS(Loads!$B$2:$B$301,$A22))IF($A22="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A22))IF($A22="","",SUMIFS(Loads!$F$2:$F$301,Loads!$B$2:$B$301,$A22))IF(OR($A22="",N(D22)=0),"",C22/D22)IF($A22="","",COUNTIFS(Loads!$B$2:$B$301,$A22,Loads!$R$2:$R$301,"Paid"))IF(OR($A22="",N(F22)=0),"",SUMIFS(Loads!$Q$2:$Q$301,Loads!$B$2:$B$301,$A22,Loads!$R$2:$R$301,"Paid")/F22)IF($A22="","",COUNTIFS(Loads!$B$2:$B$301,$A22,Loads!$R$2:$R$301,"Invoiced"))IF($A22="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A22,Loads!$R$2:$R$301,"Invoiced"))
IF($A23="","",COUNTIFS(Loads!$B$2:$B$301,$A23))IF($A23="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A23))IF($A23="","",SUMIFS(Loads!$F$2:$F$301,Loads!$B$2:$B$301,$A23))IF(OR($A23="",N(D23)=0),"",C23/D23)IF($A23="","",COUNTIFS(Loads!$B$2:$B$301,$A23,Loads!$R$2:$R$301,"Paid"))IF(OR($A23="",N(F23)=0),"",SUMIFS(Loads!$Q$2:$Q$301,Loads!$B$2:$B$301,$A23,Loads!$R$2:$R$301,"Paid")/F23)IF($A23="","",COUNTIFS(Loads!$B$2:$B$301,$A23,Loads!$R$2:$R$301,"Invoiced"))IF($A23="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A23,Loads!$R$2:$R$301,"Invoiced"))
IF($A24="","",COUNTIFS(Loads!$B$2:$B$301,$A24))IF($A24="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A24))IF($A24="","",SUMIFS(Loads!$F$2:$F$301,Loads!$B$2:$B$301,$A24))IF(OR($A24="",N(D24)=0),"",C24/D24)IF($A24="","",COUNTIFS(Loads!$B$2:$B$301,$A24,Loads!$R$2:$R$301,"Paid"))IF(OR($A24="",N(F24)=0),"",SUMIFS(Loads!$Q$2:$Q$301,Loads!$B$2:$B$301,$A24,Loads!$R$2:$R$301,"Paid")/F24)IF($A24="","",COUNTIFS(Loads!$B$2:$B$301,$A24,Loads!$R$2:$R$301,"Invoiced"))IF($A24="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A24,Loads!$R$2:$R$301,"Invoiced"))
IF($A25="","",COUNTIFS(Loads!$B$2:$B$301,$A25))IF($A25="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A25))IF($A25="","",SUMIFS(Loads!$F$2:$F$301,Loads!$B$2:$B$301,$A25))IF(OR($A25="",N(D25)=0),"",C25/D25)IF($A25="","",COUNTIFS(Loads!$B$2:$B$301,$A25,Loads!$R$2:$R$301,"Paid"))IF(OR($A25="",N(F25)=0),"",SUMIFS(Loads!$Q$2:$Q$301,Loads!$B$2:$B$301,$A25,Loads!$R$2:$R$301,"Paid")/F25)IF($A25="","",COUNTIFS(Loads!$B$2:$B$301,$A25,Loads!$R$2:$R$301,"Invoiced"))IF($A25="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A25,Loads!$R$2:$R$301,"Invoiced"))
IF($A26="","",COUNTIFS(Loads!$B$2:$B$301,$A26))IF($A26="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A26))IF($A26="","",SUMIFS(Loads!$F$2:$F$301,Loads!$B$2:$B$301,$A26))IF(OR($A26="",N(D26)=0),"",C26/D26)IF($A26="","",COUNTIFS(Loads!$B$2:$B$301,$A26,Loads!$R$2:$R$301,"Paid"))IF(OR($A26="",N(F26)=0),"",SUMIFS(Loads!$Q$2:$Q$301,Loads!$B$2:$B$301,$A26,Loads!$R$2:$R$301,"Paid")/F26)IF($A26="","",COUNTIFS(Loads!$B$2:$B$301,$A26,Loads!$R$2:$R$301,"Invoiced"))IF($A26="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A26,Loads!$R$2:$R$301,"Invoiced"))
IF($A27="","",COUNTIFS(Loads!$B$2:$B$301,$A27))IF($A27="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A27))IF($A27="","",SUMIFS(Loads!$F$2:$F$301,Loads!$B$2:$B$301,$A27))IF(OR($A27="",N(D27)=0),"",C27/D27)IF($A27="","",COUNTIFS(Loads!$B$2:$B$301,$A27,Loads!$R$2:$R$301,"Paid"))IF(OR($A27="",N(F27)=0),"",SUMIFS(Loads!$Q$2:$Q$301,Loads!$B$2:$B$301,$A27,Loads!$R$2:$R$301,"Paid")/F27)IF($A27="","",COUNTIFS(Loads!$B$2:$B$301,$A27,Loads!$R$2:$R$301,"Invoiced"))IF($A27="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A27,Loads!$R$2:$R$301,"Invoiced"))
IF($A28="","",COUNTIFS(Loads!$B$2:$B$301,$A28))IF($A28="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A28))IF($A28="","",SUMIFS(Loads!$F$2:$F$301,Loads!$B$2:$B$301,$A28))IF(OR($A28="",N(D28)=0),"",C28/D28)IF($A28="","",COUNTIFS(Loads!$B$2:$B$301,$A28,Loads!$R$2:$R$301,"Paid"))IF(OR($A28="",N(F28)=0),"",SUMIFS(Loads!$Q$2:$Q$301,Loads!$B$2:$B$301,$A28,Loads!$R$2:$R$301,"Paid")/F28)IF($A28="","",COUNTIFS(Loads!$B$2:$B$301,$A28,Loads!$R$2:$R$301,"Invoiced"))IF($A28="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A28,Loads!$R$2:$R$301,"Invoiced"))
IF($A29="","",COUNTIFS(Loads!$B$2:$B$301,$A29))IF($A29="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A29))IF($A29="","",SUMIFS(Loads!$F$2:$F$301,Loads!$B$2:$B$301,$A29))IF(OR($A29="",N(D29)=0),"",C29/D29)IF($A29="","",COUNTIFS(Loads!$B$2:$B$301,$A29,Loads!$R$2:$R$301,"Paid"))IF(OR($A29="",N(F29)=0),"",SUMIFS(Loads!$Q$2:$Q$301,Loads!$B$2:$B$301,$A29,Loads!$R$2:$R$301,"Paid")/F29)IF($A29="","",COUNTIFS(Loads!$B$2:$B$301,$A29,Loads!$R$2:$R$301,"Invoiced"))IF($A29="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A29,Loads!$R$2:$R$301,"Invoiced"))
IF($A30="","",COUNTIFS(Loads!$B$2:$B$301,$A30))IF($A30="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A30))IF($A30="","",SUMIFS(Loads!$F$2:$F$301,Loads!$B$2:$B$301,$A30))IF(OR($A30="",N(D30)=0),"",C30/D30)IF($A30="","",COUNTIFS(Loads!$B$2:$B$301,$A30,Loads!$R$2:$R$301,"Paid"))IF(OR($A30="",N(F30)=0),"",SUMIFS(Loads!$Q$2:$Q$301,Loads!$B$2:$B$301,$A30,Loads!$R$2:$R$301,"Paid")/F30)IF($A30="","",COUNTIFS(Loads!$B$2:$B$301,$A30,Loads!$R$2:$R$301,"Invoiced"))IF($A30="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A30,Loads!$R$2:$R$301,"Invoiced"))
IF($A31="","",COUNTIFS(Loads!$B$2:$B$301,$A31))IF($A31="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A31))IF($A31="","",SUMIFS(Loads!$F$2:$F$301,Loads!$B$2:$B$301,$A31))IF(OR($A31="",N(D31)=0),"",C31/D31)IF($A31="","",COUNTIFS(Loads!$B$2:$B$301,$A31,Loads!$R$2:$R$301,"Paid"))IF(OR($A31="",N(F31)=0),"",SUMIFS(Loads!$Q$2:$Q$301,Loads!$B$2:$B$301,$A31,Loads!$R$2:$R$301,"Paid")/F31)IF($A31="","",COUNTIFS(Loads!$B$2:$B$301,$A31,Loads!$R$2:$R$301,"Invoiced"))IF($A31="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A31,Loads!$R$2:$R$301,"Invoiced"))
IF($A32="","",COUNTIFS(Loads!$B$2:$B$301,$A32))IF($A32="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A32))IF($A32="","",SUMIFS(Loads!$F$2:$F$301,Loads!$B$2:$B$301,$A32))IF(OR($A32="",N(D32)=0),"",C32/D32)IF($A32="","",COUNTIFS(Loads!$B$2:$B$301,$A32,Loads!$R$2:$R$301,"Paid"))IF(OR($A32="",N(F32)=0),"",SUMIFS(Loads!$Q$2:$Q$301,Loads!$B$2:$B$301,$A32,Loads!$R$2:$R$301,"Paid")/F32)IF($A32="","",COUNTIFS(Loads!$B$2:$B$301,$A32,Loads!$R$2:$R$301,"Invoiced"))IF($A32="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A32,Loads!$R$2:$R$301,"Invoiced"))
IF($A33="","",COUNTIFS(Loads!$B$2:$B$301,$A33))IF($A33="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A33))IF($A33="","",SUMIFS(Loads!$F$2:$F$301,Loads!$B$2:$B$301,$A33))IF(OR($A33="",N(D33)=0),"",C33/D33)IF($A33="","",COUNTIFS(Loads!$B$2:$B$301,$A33,Loads!$R$2:$R$301,"Paid"))IF(OR($A33="",N(F33)=0),"",SUMIFS(Loads!$Q$2:$Q$301,Loads!$B$2:$B$301,$A33,Loads!$R$2:$R$301,"Paid")/F33)IF($A33="","",COUNTIFS(Loads!$B$2:$B$301,$A33,Loads!$R$2:$R$301,"Invoiced"))IF($A33="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A33,Loads!$R$2:$R$301,"Invoiced"))
IF($A34="","",COUNTIFS(Loads!$B$2:$B$301,$A34))IF($A34="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A34))IF($A34="","",SUMIFS(Loads!$F$2:$F$301,Loads!$B$2:$B$301,$A34))IF(OR($A34="",N(D34)=0),"",C34/D34)IF($A34="","",COUNTIFS(Loads!$B$2:$B$301,$A34,Loads!$R$2:$R$301,"Paid"))IF(OR($A34="",N(F34)=0),"",SUMIFS(Loads!$Q$2:$Q$301,Loads!$B$2:$B$301,$A34,Loads!$R$2:$R$301,"Paid")/F34)IF($A34="","",COUNTIFS(Loads!$B$2:$B$301,$A34,Loads!$R$2:$R$301,"Invoiced"))IF($A34="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A34,Loads!$R$2:$R$301,"Invoiced"))
IF($A35="","",COUNTIFS(Loads!$B$2:$B$301,$A35))IF($A35="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A35))IF($A35="","",SUMIFS(Loads!$F$2:$F$301,Loads!$B$2:$B$301,$A35))IF(OR($A35="",N(D35)=0),"",C35/D35)IF($A35="","",COUNTIFS(Loads!$B$2:$B$301,$A35,Loads!$R$2:$R$301,"Paid"))IF(OR($A35="",N(F35)=0),"",SUMIFS(Loads!$Q$2:$Q$301,Loads!$B$2:$B$301,$A35,Loads!$R$2:$R$301,"Paid")/F35)IF($A35="","",COUNTIFS(Loads!$B$2:$B$301,$A35,Loads!$R$2:$R$301,"Invoiced"))IF($A35="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A35,Loads!$R$2:$R$301,"Invoiced"))
IF($A36="","",COUNTIFS(Loads!$B$2:$B$301,$A36))IF($A36="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A36))IF($A36="","",SUMIFS(Loads!$F$2:$F$301,Loads!$B$2:$B$301,$A36))IF(OR($A36="",N(D36)=0),"",C36/D36)IF($A36="","",COUNTIFS(Loads!$B$2:$B$301,$A36,Loads!$R$2:$R$301,"Paid"))IF(OR($A36="",N(F36)=0),"",SUMIFS(Loads!$Q$2:$Q$301,Loads!$B$2:$B$301,$A36,Loads!$R$2:$R$301,"Paid")/F36)IF($A36="","",COUNTIFS(Loads!$B$2:$B$301,$A36,Loads!$R$2:$R$301,"Invoiced"))IF($A36="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A36,Loads!$R$2:$R$301,"Invoiced"))
IF($A37="","",COUNTIFS(Loads!$B$2:$B$301,$A37))IF($A37="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A37))IF($A37="","",SUMIFS(Loads!$F$2:$F$301,Loads!$B$2:$B$301,$A37))IF(OR($A37="",N(D37)=0),"",C37/D37)IF($A37="","",COUNTIFS(Loads!$B$2:$B$301,$A37,Loads!$R$2:$R$301,"Paid"))IF(OR($A37="",N(F37)=0),"",SUMIFS(Loads!$Q$2:$Q$301,Loads!$B$2:$B$301,$A37,Loads!$R$2:$R$301,"Paid")/F37)IF($A37="","",COUNTIFS(Loads!$B$2:$B$301,$A37,Loads!$R$2:$R$301,"Invoiced"))IF($A37="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A37,Loads!$R$2:$R$301,"Invoiced"))
IF($A38="","",COUNTIFS(Loads!$B$2:$B$301,$A38))IF($A38="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A38))IF($A38="","",SUMIFS(Loads!$F$2:$F$301,Loads!$B$2:$B$301,$A38))IF(OR($A38="",N(D38)=0),"",C38/D38)IF($A38="","",COUNTIFS(Loads!$B$2:$B$301,$A38,Loads!$R$2:$R$301,"Paid"))IF(OR($A38="",N(F38)=0),"",SUMIFS(Loads!$Q$2:$Q$301,Loads!$B$2:$B$301,$A38,Loads!$R$2:$R$301,"Paid")/F38)IF($A38="","",COUNTIFS(Loads!$B$2:$B$301,$A38,Loads!$R$2:$R$301,"Invoiced"))IF($A38="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A38,Loads!$R$2:$R$301,"Invoiced"))
IF($A39="","",COUNTIFS(Loads!$B$2:$B$301,$A39))IF($A39="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A39))IF($A39="","",SUMIFS(Loads!$F$2:$F$301,Loads!$B$2:$B$301,$A39))IF(OR($A39="",N(D39)=0),"",C39/D39)IF($A39="","",COUNTIFS(Loads!$B$2:$B$301,$A39,Loads!$R$2:$R$301,"Paid"))IF(OR($A39="",N(F39)=0),"",SUMIFS(Loads!$Q$2:$Q$301,Loads!$B$2:$B$301,$A39,Loads!$R$2:$R$301,"Paid")/F39)IF($A39="","",COUNTIFS(Loads!$B$2:$B$301,$A39,Loads!$R$2:$R$301,"Invoiced"))IF($A39="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A39,Loads!$R$2:$R$301,"Invoiced"))
IF($A40="","",COUNTIFS(Loads!$B$2:$B$301,$A40))IF($A40="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A40))IF($A40="","",SUMIFS(Loads!$F$2:$F$301,Loads!$B$2:$B$301,$A40))IF(OR($A40="",N(D40)=0),"",C40/D40)IF($A40="","",COUNTIFS(Loads!$B$2:$B$301,$A40,Loads!$R$2:$R$301,"Paid"))IF(OR($A40="",N(F40)=0),"",SUMIFS(Loads!$Q$2:$Q$301,Loads!$B$2:$B$301,$A40,Loads!$R$2:$R$301,"Paid")/F40)IF($A40="","",COUNTIFS(Loads!$B$2:$B$301,$A40,Loads!$R$2:$R$301,"Invoiced"))IF($A40="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A40,Loads!$R$2:$R$301,"Invoiced"))
IF($A41="","",COUNTIFS(Loads!$B$2:$B$301,$A41))IF($A41="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A41))IF($A41="","",SUMIFS(Loads!$F$2:$F$301,Loads!$B$2:$B$301,$A41))IF(OR($A41="",N(D41)=0),"",C41/D41)IF($A41="","",COUNTIFS(Loads!$B$2:$B$301,$A41,Loads!$R$2:$R$301,"Paid"))IF(OR($A41="",N(F41)=0),"",SUMIFS(Loads!$Q$2:$Q$301,Loads!$B$2:$B$301,$A41,Loads!$R$2:$R$301,"Paid")/F41)IF($A41="","",COUNTIFS(Loads!$B$2:$B$301,$A41,Loads!$R$2:$R$301,"Invoiced"))IF($A41="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A41,Loads!$R$2:$R$301,"Invoiced"))
IF($A42="","",COUNTIFS(Loads!$B$2:$B$301,$A42))IF($A42="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A42))IF($A42="","",SUMIFS(Loads!$F$2:$F$301,Loads!$B$2:$B$301,$A42))IF(OR($A42="",N(D42)=0),"",C42/D42)IF($A42="","",COUNTIFS(Loads!$B$2:$B$301,$A42,Loads!$R$2:$R$301,"Paid"))IF(OR($A42="",N(F42)=0),"",SUMIFS(Loads!$Q$2:$Q$301,Loads!$B$2:$B$301,$A42,Loads!$R$2:$R$301,"Paid")/F42)IF($A42="","",COUNTIFS(Loads!$B$2:$B$301,$A42,Loads!$R$2:$R$301,"Invoiced"))IF($A42="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A42,Loads!$R$2:$R$301,"Invoiced"))
IF($A43="","",COUNTIFS(Loads!$B$2:$B$301,$A43))IF($A43="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A43))IF($A43="","",SUMIFS(Loads!$F$2:$F$301,Loads!$B$2:$B$301,$A43))IF(OR($A43="",N(D43)=0),"",C43/D43)IF($A43="","",COUNTIFS(Loads!$B$2:$B$301,$A43,Loads!$R$2:$R$301,"Paid"))IF(OR($A43="",N(F43)=0),"",SUMIFS(Loads!$Q$2:$Q$301,Loads!$B$2:$B$301,$A43,Loads!$R$2:$R$301,"Paid")/F43)IF($A43="","",COUNTIFS(Loads!$B$2:$B$301,$A43,Loads!$R$2:$R$301,"Invoiced"))IF($A43="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A43,Loads!$R$2:$R$301,"Invoiced"))
IF($A44="","",COUNTIFS(Loads!$B$2:$B$301,$A44))IF($A44="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A44))IF($A44="","",SUMIFS(Loads!$F$2:$F$301,Loads!$B$2:$B$301,$A44))IF(OR($A44="",N(D44)=0),"",C44/D44)IF($A44="","",COUNTIFS(Loads!$B$2:$B$301,$A44,Loads!$R$2:$R$301,"Paid"))IF(OR($A44="",N(F44)=0),"",SUMIFS(Loads!$Q$2:$Q$301,Loads!$B$2:$B$301,$A44,Loads!$R$2:$R$301,"Paid")/F44)IF($A44="","",COUNTIFS(Loads!$B$2:$B$301,$A44,Loads!$R$2:$R$301,"Invoiced"))IF($A44="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A44,Loads!$R$2:$R$301,"Invoiced"))
IF($A45="","",COUNTIFS(Loads!$B$2:$B$301,$A45))IF($A45="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A45))IF($A45="","",SUMIFS(Loads!$F$2:$F$301,Loads!$B$2:$B$301,$A45))IF(OR($A45="",N(D45)=0),"",C45/D45)IF($A45="","",COUNTIFS(Loads!$B$2:$B$301,$A45,Loads!$R$2:$R$301,"Paid"))IF(OR($A45="",N(F45)=0),"",SUMIFS(Loads!$Q$2:$Q$301,Loads!$B$2:$B$301,$A45,Loads!$R$2:$R$301,"Paid")/F45)IF($A45="","",COUNTIFS(Loads!$B$2:$B$301,$A45,Loads!$R$2:$R$301,"Invoiced"))IF($A45="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A45,Loads!$R$2:$R$301,"Invoiced"))
IF($A46="","",COUNTIFS(Loads!$B$2:$B$301,$A46))IF($A46="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A46))IF($A46="","",SUMIFS(Loads!$F$2:$F$301,Loads!$B$2:$B$301,$A46))IF(OR($A46="",N(D46)=0),"",C46/D46)IF($A46="","",COUNTIFS(Loads!$B$2:$B$301,$A46,Loads!$R$2:$R$301,"Paid"))IF(OR($A46="",N(F46)=0),"",SUMIFS(Loads!$Q$2:$Q$301,Loads!$B$2:$B$301,$A46,Loads!$R$2:$R$301,"Paid")/F46)IF($A46="","",COUNTIFS(Loads!$B$2:$B$301,$A46,Loads!$R$2:$R$301,"Invoiced"))IF($A46="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A46,Loads!$R$2:$R$301,"Invoiced"))
IF($A47="","",COUNTIFS(Loads!$B$2:$B$301,$A47))IF($A47="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A47))IF($A47="","",SUMIFS(Loads!$F$2:$F$301,Loads!$B$2:$B$301,$A47))IF(OR($A47="",N(D47)=0),"",C47/D47)IF($A47="","",COUNTIFS(Loads!$B$2:$B$301,$A47,Loads!$R$2:$R$301,"Paid"))IF(OR($A47="",N(F47)=0),"",SUMIFS(Loads!$Q$2:$Q$301,Loads!$B$2:$B$301,$A47,Loads!$R$2:$R$301,"Paid")/F47)IF($A47="","",COUNTIFS(Loads!$B$2:$B$301,$A47,Loads!$R$2:$R$301,"Invoiced"))IF($A47="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A47,Loads!$R$2:$R$301,"Invoiced"))
IF($A48="","",COUNTIFS(Loads!$B$2:$B$301,$A48))IF($A48="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A48))IF($A48="","",SUMIFS(Loads!$F$2:$F$301,Loads!$B$2:$B$301,$A48))IF(OR($A48="",N(D48)=0),"",C48/D48)IF($A48="","",COUNTIFS(Loads!$B$2:$B$301,$A48,Loads!$R$2:$R$301,"Paid"))IF(OR($A48="",N(F48)=0),"",SUMIFS(Loads!$Q$2:$Q$301,Loads!$B$2:$B$301,$A48,Loads!$R$2:$R$301,"Paid")/F48)IF($A48="","",COUNTIFS(Loads!$B$2:$B$301,$A48,Loads!$R$2:$R$301,"Invoiced"))IF($A48="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A48,Loads!$R$2:$R$301,"Invoiced"))
IF($A49="","",COUNTIFS(Loads!$B$2:$B$301,$A49))IF($A49="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A49))IF($A49="","",SUMIFS(Loads!$F$2:$F$301,Loads!$B$2:$B$301,$A49))IF(OR($A49="",N(D49)=0),"",C49/D49)IF($A49="","",COUNTIFS(Loads!$B$2:$B$301,$A49,Loads!$R$2:$R$301,"Paid"))IF(OR($A49="",N(F49)=0),"",SUMIFS(Loads!$Q$2:$Q$301,Loads!$B$2:$B$301,$A49,Loads!$R$2:$R$301,"Paid")/F49)IF($A49="","",COUNTIFS(Loads!$B$2:$B$301,$A49,Loads!$R$2:$R$301,"Invoiced"))IF($A49="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A49,Loads!$R$2:$R$301,"Invoiced"))
IF($A50="","",COUNTIFS(Loads!$B$2:$B$301,$A50))IF($A50="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A50))IF($A50="","",SUMIFS(Loads!$F$2:$F$301,Loads!$B$2:$B$301,$A50))IF(OR($A50="",N(D50)=0),"",C50/D50)IF($A50="","",COUNTIFS(Loads!$B$2:$B$301,$A50,Loads!$R$2:$R$301,"Paid"))IF(OR($A50="",N(F50)=0),"",SUMIFS(Loads!$Q$2:$Q$301,Loads!$B$2:$B$301,$A50,Loads!$R$2:$R$301,"Paid")/F50)IF($A50="","",COUNTIFS(Loads!$B$2:$B$301,$A50,Loads!$R$2:$R$301,"Invoiced"))IF($A50="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A50,Loads!$R$2:$R$301,"Invoiced"))
IF($A51="","",COUNTIFS(Loads!$B$2:$B$301,$A51))IF($A51="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A51))IF($A51="","",SUMIFS(Loads!$F$2:$F$301,Loads!$B$2:$B$301,$A51))IF(OR($A51="",N(D51)=0),"",C51/D51)IF($A51="","",COUNTIFS(Loads!$B$2:$B$301,$A51,Loads!$R$2:$R$301,"Paid"))IF(OR($A51="",N(F51)=0),"",SUMIFS(Loads!$Q$2:$Q$301,Loads!$B$2:$B$301,$A51,Loads!$R$2:$R$301,"Paid")/F51)IF($A51="","",COUNTIFS(Loads!$B$2:$B$301,$A51,Loads!$R$2:$R$301,"Invoiced"))IF($A51="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A51,Loads!$R$2:$R$301,"Invoiced"))
IF($A52="","",COUNTIFS(Loads!$B$2:$B$301,$A52))IF($A52="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A52))IF($A52="","",SUMIFS(Loads!$F$2:$F$301,Loads!$B$2:$B$301,$A52))IF(OR($A52="",N(D52)=0),"",C52/D52)IF($A52="","",COUNTIFS(Loads!$B$2:$B$301,$A52,Loads!$R$2:$R$301,"Paid"))IF(OR($A52="",N(F52)=0),"",SUMIFS(Loads!$Q$2:$Q$301,Loads!$B$2:$B$301,$A52,Loads!$R$2:$R$301,"Paid")/F52)IF($A52="","",COUNTIFS(Loads!$B$2:$B$301,$A52,Loads!$R$2:$R$301,"Invoiced"))IF($A52="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A52,Loads!$R$2:$R$301,"Invoiced"))
IF($A53="","",COUNTIFS(Loads!$B$2:$B$301,$A53))IF($A53="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A53))IF($A53="","",SUMIFS(Loads!$F$2:$F$301,Loads!$B$2:$B$301,$A53))IF(OR($A53="",N(D53)=0),"",C53/D53)IF($A53="","",COUNTIFS(Loads!$B$2:$B$301,$A53,Loads!$R$2:$R$301,"Paid"))IF(OR($A53="",N(F53)=0),"",SUMIFS(Loads!$Q$2:$Q$301,Loads!$B$2:$B$301,$A53,Loads!$R$2:$R$301,"Paid")/F53)IF($A53="","",COUNTIFS(Loads!$B$2:$B$301,$A53,Loads!$R$2:$R$301,"Invoiced"))IF($A53="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A53,Loads!$R$2:$R$301,"Invoiced"))
IF($A54="","",COUNTIFS(Loads!$B$2:$B$301,$A54))IF($A54="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A54))IF($A54="","",SUMIFS(Loads!$F$2:$F$301,Loads!$B$2:$B$301,$A54))IF(OR($A54="",N(D54)=0),"",C54/D54)IF($A54="","",COUNTIFS(Loads!$B$2:$B$301,$A54,Loads!$R$2:$R$301,"Paid"))IF(OR($A54="",N(F54)=0),"",SUMIFS(Loads!$Q$2:$Q$301,Loads!$B$2:$B$301,$A54,Loads!$R$2:$R$301,"Paid")/F54)IF($A54="","",COUNTIFS(Loads!$B$2:$B$301,$A54,Loads!$R$2:$R$301,"Invoiced"))IF($A54="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A54,Loads!$R$2:$R$301,"Invoiced"))
IF($A55="","",COUNTIFS(Loads!$B$2:$B$301,$A55))IF($A55="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A55))IF($A55="","",SUMIFS(Loads!$F$2:$F$301,Loads!$B$2:$B$301,$A55))IF(OR($A55="",N(D55)=0),"",C55/D55)IF($A55="","",COUNTIFS(Loads!$B$2:$B$301,$A55,Loads!$R$2:$R$301,"Paid"))IF(OR($A55="",N(F55)=0),"",SUMIFS(Loads!$Q$2:$Q$301,Loads!$B$2:$B$301,$A55,Loads!$R$2:$R$301,"Paid")/F55)IF($A55="","",COUNTIFS(Loads!$B$2:$B$301,$A55,Loads!$R$2:$R$301,"Invoiced"))IF($A55="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A55,Loads!$R$2:$R$301,"Invoiced"))
IF($A56="","",COUNTIFS(Loads!$B$2:$B$301,$A56))IF($A56="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A56))IF($A56="","",SUMIFS(Loads!$F$2:$F$301,Loads!$B$2:$B$301,$A56))IF(OR($A56="",N(D56)=0),"",C56/D56)IF($A56="","",COUNTIFS(Loads!$B$2:$B$301,$A56,Loads!$R$2:$R$301,"Paid"))IF(OR($A56="",N(F56)=0),"",SUMIFS(Loads!$Q$2:$Q$301,Loads!$B$2:$B$301,$A56,Loads!$R$2:$R$301,"Paid")/F56)IF($A56="","",COUNTIFS(Loads!$B$2:$B$301,$A56,Loads!$R$2:$R$301,"Invoiced"))IF($A56="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A56,Loads!$R$2:$R$301,"Invoiced"))
IF($A57="","",COUNTIFS(Loads!$B$2:$B$301,$A57))IF($A57="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A57))IF($A57="","",SUMIFS(Loads!$F$2:$F$301,Loads!$B$2:$B$301,$A57))IF(OR($A57="",N(D57)=0),"",C57/D57)IF($A57="","",COUNTIFS(Loads!$B$2:$B$301,$A57,Loads!$R$2:$R$301,"Paid"))IF(OR($A57="",N(F57)=0),"",SUMIFS(Loads!$Q$2:$Q$301,Loads!$B$2:$B$301,$A57,Loads!$R$2:$R$301,"Paid")/F57)IF($A57="","",COUNTIFS(Loads!$B$2:$B$301,$A57,Loads!$R$2:$R$301,"Invoiced"))IF($A57="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A57,Loads!$R$2:$R$301,"Invoiced"))
IF($A58="","",COUNTIFS(Loads!$B$2:$B$301,$A58))IF($A58="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A58))IF($A58="","",SUMIFS(Loads!$F$2:$F$301,Loads!$B$2:$B$301,$A58))IF(OR($A58="",N(D58)=0),"",C58/D58)IF($A58="","",COUNTIFS(Loads!$B$2:$B$301,$A58,Loads!$R$2:$R$301,"Paid"))IF(OR($A58="",N(F58)=0),"",SUMIFS(Loads!$Q$2:$Q$301,Loads!$B$2:$B$301,$A58,Loads!$R$2:$R$301,"Paid")/F58)IF($A58="","",COUNTIFS(Loads!$B$2:$B$301,$A58,Loads!$R$2:$R$301,"Invoiced"))IF($A58="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A58,Loads!$R$2:$R$301,"Invoiced"))
IF($A59="","",COUNTIFS(Loads!$B$2:$B$301,$A59))IF($A59="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A59))IF($A59="","",SUMIFS(Loads!$F$2:$F$301,Loads!$B$2:$B$301,$A59))IF(OR($A59="",N(D59)=0),"",C59/D59)IF($A59="","",COUNTIFS(Loads!$B$2:$B$301,$A59,Loads!$R$2:$R$301,"Paid"))IF(OR($A59="",N(F59)=0),"",SUMIFS(Loads!$Q$2:$Q$301,Loads!$B$2:$B$301,$A59,Loads!$R$2:$R$301,"Paid")/F59)IF($A59="","",COUNTIFS(Loads!$B$2:$B$301,$A59,Loads!$R$2:$R$301,"Invoiced"))IF($A59="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A59,Loads!$R$2:$R$301,"Invoiced"))
IF($A60="","",COUNTIFS(Loads!$B$2:$B$301,$A60))IF($A60="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A60))IF($A60="","",SUMIFS(Loads!$F$2:$F$301,Loads!$B$2:$B$301,$A60))IF(OR($A60="",N(D60)=0),"",C60/D60)IF($A60="","",COUNTIFS(Loads!$B$2:$B$301,$A60,Loads!$R$2:$R$301,"Paid"))IF(OR($A60="",N(F60)=0),"",SUMIFS(Loads!$Q$2:$Q$301,Loads!$B$2:$B$301,$A60,Loads!$R$2:$R$301,"Paid")/F60)IF($A60="","",COUNTIFS(Loads!$B$2:$B$301,$A60,Loads!$R$2:$R$301,"Invoiced"))IF($A60="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A60,Loads!$R$2:$R$301,"Invoiced"))
IF($A61="","",COUNTIFS(Loads!$B$2:$B$301,$A61))IF($A61="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A61))IF($A61="","",SUMIFS(Loads!$F$2:$F$301,Loads!$B$2:$B$301,$A61))IF(OR($A61="",N(D61)=0),"",C61/D61)IF($A61="","",COUNTIFS(Loads!$B$2:$B$301,$A61,Loads!$R$2:$R$301,"Paid"))IF(OR($A61="",N(F61)=0),"",SUMIFS(Loads!$Q$2:$Q$301,Loads!$B$2:$B$301,$A61,Loads!$R$2:$R$301,"Paid")/F61)IF($A61="","",COUNTIFS(Loads!$B$2:$B$301,$A61,Loads!$R$2:$R$301,"Invoiced"))IF($A61="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A61,Loads!$R$2:$R$301,"Invoiced"))
IF($A62="","",COUNTIFS(Loads!$B$2:$B$301,$A62))IF($A62="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A62))IF($A62="","",SUMIFS(Loads!$F$2:$F$301,Loads!$B$2:$B$301,$A62))IF(OR($A62="",N(D62)=0),"",C62/D62)IF($A62="","",COUNTIFS(Loads!$B$2:$B$301,$A62,Loads!$R$2:$R$301,"Paid"))IF(OR($A62="",N(F62)=0),"",SUMIFS(Loads!$Q$2:$Q$301,Loads!$B$2:$B$301,$A62,Loads!$R$2:$R$301,"Paid")/F62)IF($A62="","",COUNTIFS(Loads!$B$2:$B$301,$A62,Loads!$R$2:$R$301,"Invoiced"))IF($A62="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A62,Loads!$R$2:$R$301,"Invoiced"))
IF($A63="","",COUNTIFS(Loads!$B$2:$B$301,$A63))IF($A63="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A63))IF($A63="","",SUMIFS(Loads!$F$2:$F$301,Loads!$B$2:$B$301,$A63))IF(OR($A63="",N(D63)=0),"",C63/D63)IF($A63="","",COUNTIFS(Loads!$B$2:$B$301,$A63,Loads!$R$2:$R$301,"Paid"))IF(OR($A63="",N(F63)=0),"",SUMIFS(Loads!$Q$2:$Q$301,Loads!$B$2:$B$301,$A63,Loads!$R$2:$R$301,"Paid")/F63)IF($A63="","",COUNTIFS(Loads!$B$2:$B$301,$A63,Loads!$R$2:$R$301,"Invoiced"))IF($A63="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A63,Loads!$R$2:$R$301,"Invoiced"))
IF($A64="","",COUNTIFS(Loads!$B$2:$B$301,$A64))IF($A64="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A64))IF($A64="","",SUMIFS(Loads!$F$2:$F$301,Loads!$B$2:$B$301,$A64))IF(OR($A64="",N(D64)=0),"",C64/D64)IF($A64="","",COUNTIFS(Loads!$B$2:$B$301,$A64,Loads!$R$2:$R$301,"Paid"))IF(OR($A64="",N(F64)=0),"",SUMIFS(Loads!$Q$2:$Q$301,Loads!$B$2:$B$301,$A64,Loads!$R$2:$R$301,"Paid")/F64)IF($A64="","",COUNTIFS(Loads!$B$2:$B$301,$A64,Loads!$R$2:$R$301,"Invoiced"))IF($A64="","",SUMIFS(Loads!$L$2:$L$301,Loads!$B$2:$B$301,$A64,Loads!$R$2:$R$301,"Invoiced"))
PK ! ù“Ìo xl/worksheets/sheet6.xmlINVOICE
Your Company NameInvoice #INV-0001
Street AddressInvoice Date46330
City, State ZIPLoad #EX-10442
MC # / DOT #Payment TermsNet 30
Phone / EmailDue DateIF(E5="","",E5+IF(ISNUMBER(SEARCH("15",E7)),15,IF(ISNUMBER(SEARCH("7",E7)),7,30)))
BILL TO
IFERROR(INDEX(Loads!$B$2:$B$301,MATCH($E$6,Loads!$C$2:$C$301,0)),"")
Broker billing email / address
LOAD DETAILS
Pickup / OriginIFERROR(INDEX(Loads!$D$2:$D$301,MATCH($E$6,Loads!$C$2:$C$301,0)),"")
Delivery / DestinationIFERROR(INDEX(Loads!$E$2:$E$301,MATCH($E$6,Loads!$C$2:$C$301,0)),"")
Delivered OnIFERROR(INDEX(Loads!$A$2:$A$301,MATCH($E$6,Loads!$C$2:$C$301,0)),"")
Loaded MilesIFERROR(INDEX(Loads!$F$2:$F$301,MATCH($E$6,Loads!$C$2:$C$301,0)),"")
DescriptionAmount
LinehaulIFERROR(N(INDEX(Loads!$H$2:$H$301,MATCH($E$6,Loads!$C$2:$C$301,0))),0)
Fuel SurchargeIFERROR(N(INDEX(Loads!$I$2:$I$301,MATCH($E$6,Loads!$C$2:$C$301,0))),0)
DetentionIFERROR(N(INDEX(Loads!$J$2:$J$301,MATCH($E$6,Loads!$C$2:$C$301,0))),0)
Lumper / Other ReimbursementIFERROR(N(INDEX(Loads!$K$2:$K$301,MATCH($E$6,Loads!$C$2:$C$301,0))),0)
TOTAL DUESUM(E21:E24)
Attached: signed rate confirmation and signed BOL / POD.
Remit to: (your payment details or factoring company remit-to address)
IF(B11="","Load # not found on the Loads tab - check the spelling in cell E6.","")
PK ! ±NïÝS S xl/comments/comment1.xmlKitReads 15 or 7 from the Payment Terms text; otherwise assumes 30 days. Overwrite with a date if your terms differ.PK ! yû†f½ ½ xl/drawings/commentsDrawing1.vmlFalse74PK ! ó$È«• • # xl/worksheets/_rels/sheet6.xml.relsPK ! 5O*P P xl/worksheets/sheet7.xmlExpense Categories
Fuel
DEF
Maintenance & Repair
Tires
Truck Payment / Lease
Insurance
Permits, Licenses & IFTA
Tolls & Scales
Factoring Fees
Lumper (not reimbursed)
ELD, Phone & Software
Load Board Subscription
Meals & Per Diem
Parking
Other
PK !
�õµu( u(
xl/styles.xmlPK ! —Š» _rels/.relsPK ! ¦[}¹ ¹ xl/workbook.xml'Loads'!$A$1:$S$301'Expenses'!$A$1:$G$301'Invoice'!$A$1:$E$31PK ! ¿ª n^ ^ xl/_rels/workbook.xml.relsPK ! Y¨ëç ç [Content_Types].xmlPK ! FÇMHÍ Í docProps/app.xmlPK ! ¥(¢5+ + û docProps/core.xmlPK ! ™\œ#œ' œ' U xl/theme/theme1.xmlPK ! Œ oÏË
Ë
"+ xl/worksheets/sheet1.xmlPK ! ÌI²Ýpô pô #9 xl/worksheets/sheet2.xmlPK ! z¿«< < É- xl/worksheets/sheet3.xmlPK ! HÄÊ9T 9T j xl/worksheets/sheet4.xmlPK ! ÕÑéÖ éÖ …¾ xl/worksheets/sheet5.xmlPK ! ù“Ìo ¤• xl/worksheets/sheet6.xmlPK ! ±NïÝS S ã§ xl/comments/comment1.xmlPK ! yû†f½ ½ l© xl/drawings/commentsDrawing1.vmlPK ! ó$È«• • # g® xl/worksheets/_rels/sheet6.xml.relsPK ! 5O*P P =° xl/worksheets/sheet7.xmlPK !
�õµu( u(
÷ xl/styles.xmlPK ! —Š» cà _rels/.relsPK ! ¦[}¹ ¹ Ÿâ xl/workbook.xmlPK ! ¿ª n^ ^ …é xl/_rels/workbook.xml.relsPK ! Y¨ëç ç ï [Content_Types].xmlPK Ç 3÷