{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["NOTES","Summary - 480","Materials 480A","Labor - 480B","Labor Overtime 480B","Labor Summary 480B ","Labor Additives 480B","Travel 480B Method A","Travel 480B Method B ","Travel Summary 480B  ","Equipment - 480C","Equip Ownerop -480C"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":10,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"NOTES","index":0,"n_rows":119,"n_cols":1,"rows_kept":119,"cut":false,"hidden":false,"merged":[]}
["Notes"]
["Form 480 Summary"]
["The heading information entered on the Summary - 480 sheet fills the 480A,480B, and 480C sheets."]
["Be sure to designate whether or not this work is for a Subcontractor (top of the Summary Sheet)"]
["Process is to fill in the header of the Summary sheet then complete the blue fields on Sheets 480 A, B, & C. The information from them will AutoFill onto the Summary sheet."]
["The Summary Sheet will calculate from the information that is filled in the blue fields."]
["Transportation costs associated with equipment needed for the force account work will need to be "]
["added to the appropriate section on the Summary 480 sheet. "]
[]
["Form 480A Materials"]
["Fill out blue fields on this sheet with all corresponding information. In the remarks section please  "]
["include invoice number for the corresponding invoice that the material is being paid from.  All  "]
["appropriate Sales tax paid will need to be shown on the invoice and transferred into cell I24.  "]
["Additionally any transportation cost associated with the material that is needed as apart of the force"]
["account will be need to be added into cell I25. Take note if invoice state's \"Take xx% discount off "]
["invoice if paid within 15 days\" or some type of discount provision, a copy of canceled check or other "]
["documentation may be needed to verify actual cost paid for the material."]
[]
["Form 480B Labor"]
["Each employee that has been approved and is performing the Force Account work should be Listed "]
["by Name and Last 4 digits of social security number.  The classification should be consistent with "]
["any previous payrolls submitted by the contractor.  Hours of work performed or held in standby/idled"]
["should be calculated to the nearest 0.1 hour and is limited to 8 hours per day and 40 hours per week"]
["unless authorized by the Resident Engineer.  "]
[]
[]
["Form 480B Labor Overtime"]
["No additive allowance as per specifications, so total overtime will be carried forth to summary"]
["page and not Labor Summary sheet. Any overtime work must be approved by the Resident Engineer"]
[]
["Form 480B Labor Summary"]
["The total amount of \"labor\" and \"standby or idle\" labor will be brought forth automatically from 480B,"]
["labor summary sheet solely for the purpose of transferring total amount of labor to the additive sheet "]
["for labor burden calculation."]
[]
["Form 480B Labor Additive"]
["Input the Labor Additive will be calculated at rates verified from contractor up to the "]
["allowable 60% maximum, or if nothing was submitted for verification the specified 35% additive will"]
["be computed as the labor burden."]
[]
["Form 480B Travel and Subsistence"]
["Input current maximum amount in cells P12, P13, P14, and P15 of Travel 480B Method A/B sheet."]
["Current allowable state rates can be found on the office of state budget and management website listed below. "]
["https://www.osbm.nc.gov/budget/state-budget-manual/5-travel-policies-and-regulations#TP5_1"]
["It should be noted that the same employee cannot be listed on both Reimbursement methods."]
[]
["Reimbursement Method \"A\""]
["Contractor reimbursement for which employee is accountable for actual expenses on daily basis."]
["Input information will be required to be entered on daily basis per employee. "]
["Input values needed are as follows:"]
["Column \"A\"  Employee name and last four digits of social security number"]
["Column \"F\" Meals in blue the actual cost of meals per day"]
["Column \"G\" Lodging in green, the actual cost of one days lodging"]
[]
["The calculations figured and maximum allowance will be made without any further input."]
[]
["Reimbursement Method \"B\""]
["Contractor reimbursement for which employee is given daily allowance and is not accountable for actual expenses."]
["Input information can be entered for a weekly basis. "]
["Input values needed are as follows:"]
["Column \"A\"  Employee name and last four digits of social security number"]
["Column \"G\" Reimbursement amount verified from contractor"]
["Column \"H\" Number of days of reimbursement"]
[]
["Calculations of allowable reimbursement according to state rates limit will be posted in column J"]
[]
["Travel Summary 480B"]
["No input needed on this sheet it is solely to calculate the total travel allowances as calculated from "]
["Method A and Method B  and then transferred to the Summary - 480 sheet. "]
[]
["Equipment 480C"]
["Contractor will be reimbursed for every piece of equipment used and needed for the Force Account "]
["work"]
["Contractor's Equipment"]
["Column \"A\" Input equipment description: name, model, type, kind, and features of approved equipment"]
["Column \"C\" Input equipment model year this may require the equipment's serial number"]
["Column \"D\" Input \"Electronic Blue Book\" if using the website and then attach a pdf printout for the  "]
["equipment being used for records and verification. "]
["Column \"E\" Input the dollar amount included for the monthly rental of the piece of equipment from the "]
["blue book. "]
["Column \"F\" Input the Age Adjustment Factor fond from the blue book for each piece of equipment. "]
["Column \"G\" Input the Regional Adjustment Factor this is a multiplication factor adjusted for area in "]
["which the work is located. "]
["Column \"H\" Input the dollar amount that it costs to operate the piece of equipment for one hour. This "]
["can be found from the blue book."]
["Column \"J through P\" Input the actual number of hours each day the equipment was in-use. This is "]
["recorded to the nearest 0.1 hour. The total hours are limited to eight hours per day and 40 hours"]
["per week unless authorized by the Resident Engineer. "]
["Column \" S\" Input any clarifying information about the equipment."]
[]
["Rental Equipment"]
["Column \"A\" Input equipment description: name, model, type, kind, and features of approved equipment"]
["Column \"D\" Input rental period that equipment is being rented such as daily, weekly, or monthly"]
["Column \"E\" Input the rate charged for the rental period such as $70/day, $325/week, $2,000/month"]
["Column \"G\" Input number of rental periods equipment authorized and in use. "]
["Column \"J through P\" Input the actual number of hours each day the equipment was in-use. This is "]
["recorded to the nearest 0.1 hour.  No time is given for rental equipment that is idle or not in-use."]
["Column \"Q\" This is automatically calculated at the weekly rental rate should that be what is put in "]
["column D and E.  However, should a different rate be needed the formula would need to be adjusted "]
["such that the contractor gets compensated 15% of the hourly rental rate for the equipment while in use.  "]
["Therefore, if it is daily rate it would be (total hours operated each day/8)*rental rate*0.15"]
["if it is a monthly rental it would be calculated by (total hours operated/176)* rental rate* 0.15"]
["***Rental agreement and invoice should be attached with force account documentation for verification."]
[]
["Standby or Idle Equipment "]
["Column \"A\" Input equipment description: name, model, type, kind, and features of approved equipment"]
["Column \"C\" Input equipment model year this may require the equipment's serial number"]
["Column \"D\" Input \"Electronic Blue Book\" if using the website and then attach a pdf printout for the  "]
["equipment being used for records and verification. "]
["Column \"E\" Input the dollar amount included for the monthly rental of the piece of equipment from the "]
["blue book. "]
["Column \"F\" Input the Age Adjustment Factor fond from the blue book for each piece of equipment. "]
["Column \"G\" Input the Regional Adjustment Factor this is a multiplication factor adjusted for area in "]
["which the work is located for each piece of equipment. "]
["Column \"J through P\" Input the actual number of hours each day the equipment was idle or standby. "]
["This is recorded to the nearest 0.1 hour. The total hours are limited to eight hours per day and 40 "]
["hours per week unless authorized by the Resident Engineer. "]
["Column \" S\" Input any clarifying information about the equipment."]
["***No time for Standby/Idle Equipment if the equipment is in-use for 40 hours or more for that week"]

{"sheet":"Summary - 480","index":1,"n_rows":57,"n_cols":10,"rows_kept":57,"cut":false,"hidden":false,"merged":[[52,6,52,8],[29,0,29,1],[12,7,12,8],[28,7,28,8],[12,0,12,1],[13,0,13,1],[27,0,27,1],[28,0,28,1],[43,0,43,1],[44,0,44,1],[45,0,45,1],[45,3,45,4],[30,7,30,8],[14,7,14,8],[15,7,15,8],[16,7,16,8],[4,2,4,6],[5,2,5,6],[6,2,6,6],[11,0,11,1],[44,3,44,4],[43,3,43,4],[9,1,9,3],[17,7,17,8],[18,7,18,8],[19,7,19,8],[20,7,20,8],[21,7,21,8],[22,7,22,8],[23,7,23,8],[24,7,24,8],[40,7,40,8],[35,7,35,8],[36,7,36,8],[37,7,37,8],[38,7,38,8],[31,7,31,8],[32,7,32,8],[33,7,33,8],[34,7,34,8],[39,7,39,8]]}
[]
[null,null,null,null,null,null,"        IS THIS FORCE ACCOUNT FOR A SUBCONTRACTOR(N=0& Y=1)"]
["Max. Travel Allownace",{"$f":"'Travel 480B Method A'!P16","v":114.5}]
[]
[null,null,"NORTH CAROLINA DEPARTMENT OF TRANSPORTATION",null,null,null,null,"Contract Number:"]
[null,null,"DETAILED STATEMENT OF FORCE ACCOUNT WORK "]
[null,null,"SUMMARY"]
[null,null,null,null,null,"AUTHORIZED BY LETTER DATED: "]
["WBS ELEMENT: ",null,"F. A. No.: ",null,"COUNTY: ",null,"CONTRACTOR: "]
["SUBCONTRACTOR :                                                                         ",null,null,null,null,null,"Week Ending: "]
[" ",null," "]
["SUBCONTRACTOR",null,null,"ADDITIVE","ADDITIVE","TRANSPORTATION"]
["SUMMARY",null,"AMOUNT","AMOUNT","AMOUNT","COSTS","SUBTOTAL","REMARKS"]
["ITEM",null,"(A)","(B)","(A)x(B)=(C) ","(D)"]
["MATERIALS",null,{"$f":"IF(H$2=0,0,'Materials 480A'!I27)","v":0},0.15,{"$f":"ROUND(C15*D15,2)","v":0},null,{"$f":"C15+E15+F15","v":0}]
["LABOR ADDITIVES",null,{"$f":"IF(H$2=0,0,IF(H$2=1,'Labor Additives 480B'!$I$24))","v":0},null,null,null,{"$f":"C16+E16","v":0}]
["LABOR",null,{"$f":"IF(H$2=0,0,'Labor - 480B'!P23)","v":0},null,null,null,{"$f":"C17+E17","v":0}]
["LABOR OVERTIME",null,{"$f":"IF(H$2=0,0,'Labor Overtime 480B'!$P$23+'Labor Overtime 480B'!P38)","v":0},null,null,null,{"$f":"C18+E18","v":0}]
["TRAVEL ALLOWNACES",null,{"$f":"IF(H$2=0,0,'Travel Summary 480B  '!I25)","v":0},null,null,null,{"$f":"C19+E19","v":0}]
["STANDBY OR IDLE LABOR",null,{"$f":"IF(H$2=0,0,'Labor - 480B'!P38)","v":0},null,null,null,{"$f":"C20+E20","v":0}]
["EQUIPMENT",null,{"$f":"IF(H$2=0,0,IF(H$2=1,'Equipment - 480C'!R22))","v":0}," ",null,0,{"$f":"C21+F21","v":0}]
["STANDBY OR IDLE EQUIPMENT",null,{"$f":"IF(H$2=0,0,IF(H$2=1,'Equipment - 480C'!R48))","v":0}," "," ",0,{"$f":"C22+F22","v":0}]
["OWNER-OPERATED EQUIPMENT",null,{"$f":"'Equip Ownerop -480C'!R15+'Equip Ownerop -480C'!R26","v":0},null,null,0,{"$f":"C23+F23","v":0}]
["RENTAL EQUIPMENT",null,{"$f":"IF(H$2=0,0,'Equipment - 480C'!H30)","v":0},{"$f":"IF(H$2=0,0,'Equipment - 480C'!R30)","v":0},{"$f":"C24*D24","v":0},0,{"$f":"C24+D24+F24","v":0}]
["OVERHEAD AND PROFIT",null,{"$f":"(C16+C17+C18+C19+C20+C21+C22+C24)*0.1","v":0},{"$f":"C25*0.1","v":0},null,null,{"$f":"C25","v":0}]
[" ",null," ",null,null,"SUB-CONTRACTOR TOTAL: ",{"$f":"SUM(G15:G25)","v":0}]
[" ",null," "]
["CONTRACTOR ",null,null,null,"ADDITIVE","TRANSPORTATION"]
["SUMMARY",null,"AMOUNT","ADDITIVE","AMOUNT","COSTS","SUBTOTAL","REMARKS"]
["ITEM",null,"(A)","(B)","(A)x(B)=(C) ","(D)","(A)+(C) OR (A)+(D)"]
["MATERIALS",null,{"$f":"IF(H2=1,0,'Materials 480A'!I27)","v":0},0.15,{"$f":"ROUND(C31*D31,2)","v":0},null,{"$f":"C31+E31+F31","v":0}]
["LABOR ADDITIVES",null,{"$f":"IF(H2=1,0,'Labor Additives 480B'!I24)","v":0},null,null,null,0]
["LABOR",null,{"$f":"IF(H2=1,0,'Labor - 480B'!P23)","v":0},null,null,null,0]
["LABOR OVERTIME",null,{"$f":"IF(H2=1,0,'Labor Overtime 480B'!P23+'Labor Overtime 480B'!P38)","v":0},null,null,null,0]
["TRAVEL ALLOWANCES",null,{"$f":"IF(H2=1,0,'Travel Summary 480B  '!I25)","v":0},null,null,null,0]
["STANDBY OR IDLE LABOR",null,{"$f":"IF(H2=1,0,'Labor - 480B'!P38)","v":0},0.35,null,null,0]
["EQUIPMENT",null,{"$f":"IF(H2=1,0,'Equipment - 480C'!R22)","v":0},0,0,0,{"$f":"C37+E37","v":0},null,null," "]
["STANDBY OR IDLE EQUIPMENT",null,{"$f":"IF(H2=1,0,'Equipment - 480C'!R48)","v":0}," "," ",0,{"$f":"C38+F38","v":0}]
["RENTAL EQUIPMENT",null,{"$f":"IF(H$2=1,0,'Equipment - 480C'!H30)","v":0},{"$f":"IF(H$2=1,0,'Equipment - 480C'!R30)","v":0},{"$f":"C39*D39","v":0},0,{"$f":"C39+D39+F39","v":0}]
["SUBCONTRACTORS TOTAL",null,{"$f":"G26","v":0},"See Below",{"$f":"IF(C40<=10000,C40*0.1,(1000+((C40-10000)*0.05)))","v":0},null,{"$f":"E40","v":0}]
["OVERHEAD AND PROFIT",null,{"$f":"SUM(C32:C39)*0.1","v":0},null,null,null,{"$f":"C41","v":0}]
[" ",null," ",null,null,"FORCE ACCOUNT TOTAL: ",{"$f":"SUM(G31:G41)+G26","v":0}]
["*SUBCONTRACTING ADMINISTRATIVE COSTS",null,null,null,null,null," "]
["Total Subcontracting Cost",null,null,"Rate  Schedule        ",null," "," "]
["$0.00 to $10,000.00",null,null,0.1]
["Above $10,000.00",null,null,"$1000.00 + 5% above $10,000.00"]
[]
["CERTIFICATION:"]
["I hereby certify that the quantities and amounts herein shown were compiled by  me and are correct to the best of my knowledge and belief, and that the work has been performed and the materials "]
["used in accordance with the Plans and Specifications heretofore approved for same."]
[]
[null,null,"(23)",null,null,"APPROVED:",null,"(24)"]
[null,null,"RESIDENT ENGINEER",null,null,null,"DIVISION ENGINEER"]
[]
[]
[]
["Max travel allowance is per person per day"]

{"sheet":"Materials 480A","index":2,"n_rows":39,"n_cols":10,"rows_kept":39,"cut":false,"hidden":false,"merged":[[33,8,33,9],[33,1,33,5],[11,0,11,4],[10,0,10,4],[12,0,12,4],[26,6,26,7],[18,0,18,4],[19,0,19,4],[20,0,20,4],[21,0,21,4],[15,0,15,4],[24,5,24,7],[23,6,23,7],[22,6,22,7],[13,0,13,4],[16,0,16,4],[17,0,17,4],[5,1,5,2],[7,1,7,2],[8,1,8,2],[7,4,7,5],[14,0,14,4]]}
[null,null,null,null,null,null," "]
[]
["NORTH CAROLINA DEPARTMENT OF TRANSPORTATION"]
["DETAILED STATEMENT OF FORCE ACCOUNT WORK"]
["MATERIALS "]
["CONTRACT NO.",{"$f":"'Summary - 480'!I5","v":0},null,null,null,null,"AUTHORIZED BY LETTER DATED: ",{"$f":"'Summary - 480'!G8","v":0}]
[]
["WBS ELEMENT:      ",{"$f":"'Summary - 480'!B9","v":0},null,"F.A. NO. :",{"$f":"'Summary - 480'!D9","v":0},null,"COUNTY:",{"$f":"'Summary - 480'!F9","v":0},"CONTRACTOR:  ",{"$f":"'Summary - 480'!H9","v":0}]
["SUBCONTRACTOR :                                                                         ",{"$f":"'Summary - 480'!B10:D10","v":0},null,null,null,null," ",null,"WEEK ENDING:  ",{"$f":"'Summary - 480'!H10","v":0}]
[]
["MATERIALS (Including Transportation Costs)",null,null,null,null,null,"COST PER"]
["MATERIAL DESCRIPTION",null,null,null,null,"UNIT","UNIT","QUANTITY","AMOUNT","REMARKS"]
[null,null,null,null,null,null,null,null,{"$f":"G13*H13","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"G14*H14","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"G15*H15","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[" ",null,null,null,null,null,"MATERIAL SUBTOTAL:",null,{"$f":"SUM(I13:I22)","v":0}]
[null,null,null,null,null,null,"SALES TAX:"]
[null,null,null,null,null,"TRANSPORTATION COST:"]
[]
[null,null,null,null,null,null,"MATERIAL TOTAL:",null,{"$f":"IF(SUM(I23:I25)=0,0,SUM(I23:I25))","v":0}]
[]
["CERTIFICATION:"]
["I hereby certify that the quantities and amounts herein shown were compiled by  me and are correct to the best of my knowledge and belief, and that the work has been performed and the materials "]
["used in accordance with the Plans and Specifications heretofore approved for same."]
[" "]
[]
[null,null,null,null,null,null,"APPROVED: "]
[null,null,null,"RESIDENT ENGINEER",null,null,null,null,"DIVISION ENGINEER"]
[null,null,null,null,null,null," "]
[" ",null,null,null,null,null,null,null," "]
[]
[null,"* what about including sales tax and the transportation charges paid by the contractor?"]

{"sheet":"Labor - 480B","index":3,"n_rows":44,"n_cols":18,"rows_kept":44,"cut":false,"hidden":false,"merged":[[33,3,33,5],[34,3,34,5],[35,3,35,5],[28,3,28,5],[29,3,29,5],[30,3,30,5],[31,3,31,5],[31,0,31,2],[32,0,32,2],[27,0,27,2],[27,3,27,5],[32,3,32,5],[36,3,36,5],[20,0,20,2],[21,0,21,2],[10,0,10,2],[10,3,10,5],[20,3,20,5],[21,3,21,5],[12,0,12,2],[13,0,13,2],[14,0,14,2],[33,0,33,2],[34,0,34,2],[35,0,35,2],[36,0,36,2],[29,0,29,2],[30,0,30,2],[15,0,15,2],[19,3,19,5],[16,0,16,2],[17,0,17,2],[18,0,18,2],[19,0,19,2],[18,3,18,5],[43,1,43,7],[43,11,43,15],[9,3,9,5],[8,0,8,2],[9,0,9,2],[25,0,25,2],[26,0,26,2],[28,0,28,2],[11,3,11,5],[12,3,12,5],[11,0,11,2],[13,3,13,5],[14,3,14,5],[15,3,15,5],[16,3,16,5],[17,3,17,5],[4,1,4,2],[5,1,5,2],[5,6,5,7],[5,14,5,15],[6,14,6,15],[4,10,4,11],[5,10,5,11]]}
[]
["NORTH CAROLINA DEPARTMENT OF TRANSPORTATION"]
["DETAILED STATEMENT OF FORCE ACCOUNT WORK"]
["LABOR / STANDBY OR IDLE LABOR"]
["CONTRACT NO.",{"$f":"'Summary - 480'!I5","v":0},null,null,null,null,null,null,null,"AUTHORIZED BY LETTER DATED:  ",{"$f":"'Summary - 480'!G8","v":0}]
["WBS ELEMENT: ",{"$f":"'Summary - 480'!B9","v":0},null,null,null,"FA#:",{"$f":"'Summary - 480'!D9","v":0},null,null,"COUNTY: ",{"$f":"'Summary - 480'!F9","v":0},null,null,"CONTRACTOR:",{"$f":"'Summary - 480'!H9","v":0}]
["SUBCONTRACTOR :                                                                         ",{"$f":"'Summary - 480'!B10:D10","v":0},null,null,null,null,null,null,null,null," "," ",null,"WEEK ENDING: ",{"$f":"'Summary - 480'!H10","v":0}]
[null,null,null,null,null,null,null," "]
["LABOR",null,null,null,null,null,null,null,null,null,null,null,null,null,"BASE"]
["NAME",null,null,"CLASSIFICATION",null,null," "," ",null,null,null,null,null,"TOTAL","WAGE"]
[null,null,null,null,null,null,"S","M","T","W","T","F","S","HOURS","RATE","AMOUNT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G12:M12)","v":0},null,{"$f":"N12*O12","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G13:M13)","v":0},null,{"$f":"N13*O13","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G22:M22)","v":0},null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LABOR SUBTOTAL:",{"$f":"SUM(P12:P22)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[]
["STANDBY  OR IDLE LABOR",null,null,null,null,null,{"$f":"G9","v":0},{"$f":"H9","v":0},0,0,0,0,0,null,"BASE"]
["NAME",null,null,null,"CLASSIFICATION",null," "," ",null,null,null,null,null,"TOTAL","WAGE"]
[null,null,null,null,null,null,"S","M","T","W","T","F","S","HOURS","RATE","AMOUNT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G29:M29)","v":0},null,{"$f":"N29*O29","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G30:M30)","v":0},null,{"$f":"N30*O30","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G31:M31)","v":0},null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G35:M35)","v":0},null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G36:M36)","v":0},null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STANDBY OR IDLE LABOR SUB-TOTAL: ",{"$f":"SUM(P29:P37)","v":0}]
["CERTIFICATION:"]
["I hereby certify that the quantities and amounts herein shown were compiled by me and are correct to the best of my knowledge and belief, and that the work has been performed and the materials "]
["used in accordance with the Plans and Specifications heretofore approved for same."]
[]
[null,null,null,null,null,null,null,null,null,"APPROVED:"]
[null,"RESIDENT ENGINEER",null,null,null,null,null,null,null,null,null,"DIVISION ENGINEER"]

{"sheet":"Labor Overtime 480B","index":4,"n_rows":44,"n_cols":18,"rows_kept":44,"cut":false,"hidden":false,"merged":[[31,0,31,2],[32,0,32,2],[35,3,35,5],[35,0,35,2],[36,3,36,5],[32,3,32,5],[33,3,33,5],[34,3,34,5],[36,0,36,2],[19,0,19,2],[19,3,19,5],[31,3,31,5],[33,0,33,2],[34,0,34,2],[27,3,27,5],[27,0,27,2],[28,3,28,5],[30,3,30,5],[29,3,29,5],[28,0,28,2],[20,0,20,2],[20,3,20,5],[21,0,21,2],[29,0,29,2],[30,0,30,2],[4,10,4,11],[4,1,4,2],[5,1,5,4],[6,1,6,4],[16,0,16,2],[16,3,16,5],[11,3,11,5],[12,0,12,2],[12,3,12,5],[13,0,13,2],[13,3,13,5],[43,1,43,7],[43,11,43,15],[9,3,9,5],[8,0,8,2],[9,0,9,2],[25,0,25,2],[26,0,26,2],[14,0,14,2],[14,3,14,5],[15,0,15,2],[15,3,15,5],[17,0,17,2],[17,3,17,5],[18,0,18,2],[18,3,18,5],[21,3,21,5],[5,14,5,15],[6,14,6,15],[11,0,11,2],[5,6,5,7],[5,10,5,11]]}
[]
["NORTH CAROLINA DEPARTMENT OF TRANSPORTATION"]
["DETAILED STATEMENT OF FORCE ACCOUNT WORK"]
["LABOR OVERTIME"]
["CONTRACT NO.",{"$f":"'Summary - 480'!I5","v":0},null,null,null,null,null,null,null,"AUTHORIZED BY LETTER DATED:  ",{"$f":"'Summary - 480'!G8","v":0}]
["WBS ELELMENT: ",{"$f":"'Summary - 480'!B9","v":0},null,null,null,"FA#:",{"$f":"'Summary - 480'!D9","v":0},null,null,"COUNTY: ",{"$f":"'Summary - 480'!F9","v":0},null,null,"CONTRACTOR:",{"$f":"'Summary - 480'!H9","v":0}]
["SUBCONTRACTOR :                                                                         ",{"$f":"'Summary - 480'!B10:D10","v":0},null,null,null,null,null,null,null,null," "," ",null,"WEEK ENDING: ",{"$f":"'Summary - 480'!H10","v":0}]
[null,null,null,null,null,null,null," "]
["LABOR",null,null,null,null,null,null,null,null,null,null,null,null,null,"BASE"]
["NAME",null,null,"CLASSIFICATION",null,null," "," ",null,null,null,null,null,"TOTAL","WAGE",null,null," "]
[null,null,null,null,null,null,"S","M","T","W","T","F","S","HOURS","RATE","AMOUNT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G12:M12)","v":0},null,{"$f":"N12*1.5*O12","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G13:M13)","v":0},null,{"$f":"N13*1.5*O13","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LABOR SUBTOTAL:",{"$f":"SUM(P12:P22)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[]
["STANDBY  OR IDLE LABOR",null,null,null,null,null,{"$f":"G9","v":0},0,0,0,0,0,0,null,"BASE"]
["NAME",null,null,null,"CLASSIFICATION",null," "," ",null,null,null,null,null,"TOTAL","WAGE"]
[null,null,null,null,null,null,"S","M","T","W","T","F","S","HOURS","RATE","AMOUNT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G29:M29)","v":0},null,{"$f":"N29*1.5*O29","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G30:M30)","v":0},null,{"$f":"N30*1.5*O30","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STANDBY OR IDLE LABOR SUB-TOTAL: ",{"$f":"SUM(P29:P37)","v":0}]
["CERTIFICATION:"]
["I hereby certify that the quantities and amounts herein shown were compiled by me and are correct to the best of my knowledge and belief, and that the work has been performed and the materials "]
["used in accordance with the Plans and Specifications heretofore approved for same."]
[]
[null,null,null,null,null,null,null,null,null,"APPROVED:"]
[null,"RESIDENT ENGINEER",null,null,null,null,null,null,null,null,null,"DIVISION ENGINEER"]

{"sheet":"Labor Summary 480B ","index":5,"n_rows":35,"n_cols":14,"rows_kept":35,"cut":false,"hidden":false,"merged":[[12,1,12,5],[6,1,6,2],[7,1,7,2],[8,1,8,2],[23,1,23,7],[19,1,19,7],[20,1,20,7],[21,1,21,7],[22,1,22,7],[15,1,15,7],[16,1,16,7],[17,1,17,7],[18,1,18,7],[13,1,13,5]]}
[null,null,null,null,null,null," "]
[]
["NORTH CAROLINA DEPARTMENT OF TRANSPORTATION"]
["DETAILED STATEMENT OF FORCE ACCOUNT WORK",null,null,null,null,null,null,null,null,null,null,null,"* Notes=","This is to calculate the Labor burdon which is only applied to the base wage rate for a maximum "]
["PAYROLL ADDITIVES",null,null,null,null,null,null,null,null,null,null,null,null,"40 hours per week to those actually performing the Force Account work."]
[null,null,null,null,null,null,"AUTHORIZED BY LETTER DATED: ",{"$f":"'Summary - 480'!G8","v":0}]
["CONTRACT NO.",{"$f":"'Summary - 480'!I5","v":0}]
["WBS ELEMENT:      ",{"$f":"'Summary - 480'!B9","v":0},null,"F.A. NO. :",{"$f":"'Summary - 480'!D9","v":0},null,"COUNTY:",{"$f":"'Summary - 480'!F9","v":0},"CONTRACTOR:  ",{"$f":"'Summary - 480'!H9","v":0}]
["SUBCONTRACTOR :                                                                         ",{"$f":"'Summary - 480'!B10:D10","v":0},null,null,null,null," ",null,"WEEK ENDING:  ",{"$f":"'Summary - 480'!H10","v":0}]
[]
[]
[]
[null,"LABOR SUMMARY"]
[null,"ITEM",null,null,null,null,null,null,"AMOUNT"]
[]
[null,"Labor ",null,null,null,null,null,null,{"$f":"'Labor - 480B'!P23","v":0}]
[null,"Stand-by Labor",null,null,null,null,null,null,{"$f":"'Labor - 480B'!P38","v":0}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I16:I24)","v":0}]
[]
["CERTIFICATION:"]
["I hereby certify that the quantities and amounts herein shown were compiled by  me and are correct to the best of my knowledge and belief, and that the work has been performed and the materials "]
["used in accordance with the Plans and Specifications heretofore approved for same."]
[" "]
[]
[null,null,null,null,null,null,"APPROVED: "]
[null,null,null,"RESIDENT ENGINEER",null,null,null,null,"DIVISION ENGINEER"]
[null,null,null,null,null,null," "]
[" ",null,null,null,null,null,null,null," "]

{"sheet":"Labor Additives 480B","index":6,"n_rows":41,"n_cols":11,"rows_kept":41,"cut":false,"hidden":false,"merged":[[20,5,20,6],[19,0,19,4],[20,0,20,4],[21,5,21,6],[22,5,22,6],[21,0,21,4],[22,0,22,4],[11,0,11,4],[12,0,12,4],[14,0,14,4],[14,5,14,6],[19,5,19,6],[15,5,15,6],[16,5,16,6],[17,5,17,6],[18,5,18,6],[15,0,15,4],[16,0,16,4],[17,0,17,4],[18,0,18,4]]}
[null,null,null,null,null,null," "]
[]
["NORTH CAROLINA DEPARTMENT OF TRANSPORTATION"]
["DETAILED STATEMENT OF FORCE ACCOUNT WORK"]
["PAYROLL ADDITIVES"]
[null,null,null,null,null,null,"AUTHORIZED BY LETTER DATED: ",{"$f":"'Summary - 480'!G8","v":0}]
["CONTRACT NO.",{"$f":"'Summary - 480'!I5","v":0}]
["WBS ELEMENT:      ",{"$f":"'Summary - 480'!B9","v":0},null,"F.A. NO. :",{"$f":"'Summary - 480'!D9","v":0},null,"COUNTY:",{"$f":"'Summary - 480'!F9","v":0},"CONTRACTOR:  ",{"$f":"'Summary - 480'!H9","v":0}]
["SUBCONTRACTOR :                                                                         ",{"$f":"'Summary - 480'!B10","v":0},null,null,null,null," ",null,"WEEK ENDING:  ",{"$f":"'Summary - 480'!H10","v":0}]
[]
[]
["BOND, INSURANCE AND TAXES",null,null,null,null,"RATE"]
["ITEM",null,null,null,null,"(PROVIDED BY ",null,"APPLICABLE"]
[null,null,null,null,null,"CONTRACTOR)",null,"QUANTITY","AMOUNT","REMARKS"]
["Labor Summary",null,null,null,null,null,null,{"$f":"'Labor Summary 480B '!I25","v":0},{"$f":"H15*F15","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"H16*F16","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
["SUBTOTAL OF SUBMIITED PAYROLL ADDITIVES",null,null,null,null,null,null,null,{"$f":"SUM(I15:I23)","v":0}," "]
[]
["SECTION 109-3A ALLOWS 35% ADDITIVE IF ACTUAL LABOR BURDEN"]
["RATES CANNOT BE VERIFIED. (Labor Summary * 35% )",null,null,null,null,null,null,null,null,null,{"$f":"+J22*0.35","v":0}]
[]
["ALLOWABLE PAYROLL ADDITIVE "]
[]
[]
[]
["CERTIFICATION:"]
["I hereby certify that the quantities and amounts herein shown were compiled by  me and are correct to the best of my knowledge and belief, and that the work has been performed and the materials "]
["used in accordance with the Plans and Specifications heretofore approved for same."]
[" "]
[]
[null,null,null,null,null,null,"APPROVED: "]
[null,null,null,"RESIDENT ENGINEER",null,null,null,null,"DIVISION ENGINEER"]
[null,null,null,null,null,null," "]
[" ",null,null,null,null,null,null,null," "]

{"sheet":"Travel 480B Method A","index":7,"n_rows":39,"n_cols":16,"rows_kept":39,"cut":false,"hidden":false,"merged":[[13,0,13,4],[14,0,14,4],[15,0,15,4],[16,0,16,4],[21,0,21,4],[17,0,17,4],[18,0,18,4],[19,0,19,4],[20,0,20,4],[10,0,10,4],[11,0,11,4],[12,0,12,4],[5,1,5,2],[7,1,7,2],[8,1,8,2],[7,4,7,5]]}
[null,null,null,null,null,null," "]
[]
["NORTH CAROLINA DEPARTMENT OF TRANSPORTATION"]
["DETAILED STATEMENT OF FORCE ACCOUNT WORK"]
["TRAVEL AND SUBSISTENCE"]
["CONTRACT NO.",{"$f":"'Summary - 480'!I5","v":0},null,null,null,null,"AUTHORIZED BY LETTER DATED: ",{"$f":"'Summary - 480'!G8","v":0}]
[null,null,null,null,null,"METHOD \"A\""]
["WBS ELEMENT:      ",{"$f":"'Summary - 480'!B9","v":0},null,"F.A. NO. :",{"$f":"'Summary - 480'!D9","v":0},null,"COUNTY:",{"$f":"'Summary - 480'!F9","v":0},"CONTRACTOR:  ",{"$f":"'Summary - 480'!H9","v":0},null,null,null,null,"*Notes =","visit link below to verify current state rates"]
["SUBCONTRACTOR :                                                                         ",{"$f":"'Summary - 480'!B10:D10","v":0},null,null,null,null," ",null,"WEEK ENDING:  ",{"$f":"'Summary - 480'!H10","v":0},null,null,null,null,null,"https://www.osbm.nc.gov/budget/state-budget-manual/5-travel-policies-and-regulations#TP5_1"]
[]
["Employees Name & Dates of Travel",null,null,null,null,"COST OF","Lodging ","AMOUNT","ALLOWABLE","REMARKS"]
[null,null,null,null,null,"MEALS","Per Day","SUBMITTED","AMOUNT","AMOUNT",null,null,null,null,"breakfast",8.6]
[null,null,null,null,null,null,null,{"$f":"F13+G13","v":0},{"$f":"IF(H13<'Summary - 480'!$B$3,H13,'Summary - 480'!$B$3)","v":0},null,null,null,null,null,"lunch",11.3]
[null,null,null,null,null,null,null,{"$f":"F14+G14","v":0},{"$f":"IF(H14<'Summary - 480'!$B$3,H14,'Summary - 480'!$B$3)","v":0},null,null,null,null,null,"dinner",19.5]
[null,null,null,null,null,null,null,{"$f":"F15+G15","v":0},{"$f":"IF(H15<'Summary - 480'!$B$3,H15,'Summary - 480'!$B$3)","v":0},null,null,null,null,null,"lodgeing",75.099999999999994]
[null,null,null,null,null,null,null,0,{"$f":"IF(H16<'Summary - 480'!$B$3,H16,'Summary - 480'!$B$3)","v":0},null,null,null,null,null,null,{"$f":"SUM(P12:P15)","v":114.5}]
[null,null,null,null,null,null,null,0,{"$f":"IF(H17<'Summary - 480'!$B$3,H17,'Summary - 480'!$B$3)","v":0}]
[null,null,null,null,null,null,null,0,{"$f":"IF(H18<'Summary - 480'!$B$3,H18,'Summary - 480'!$B$3)","v":0}]
[null,null,null,null,null,null,null,0,{"$f":"IF(H19<'Summary - 480'!$B$3,H19,'Summary - 480'!$B$3)","v":0}]
[null,null,null,null,null,null,null,0,{"$f":"IF(H20<'Summary - 480'!$B$3,H20,'Summary - 480'!$B$3)","v":0}]
[null,null,null,null,null,null,null,0,{"$f":"IF(H21<'Summary - 480'!$B$3,H21,'Summary - 480'!$B$3)","v":0}]
[null,null,null,null,null,null,null,0,{"$f":"IF(H22<'Summary - 480'!$B$3,H22,'Summary - 480'!$B$3)","v":0}]
[" ",null,null,null,null,null,null,"TRAVEL AND SUBSITENCE  SUBTOTAL: ",{"$f":"SUM(I13:I22)","v":0}]
[]
["ARTICLE 109-3B ALLOWS FOR COMPENSATION AT THE CURRENT IN-STATE"]
["RATE FOR STATE EMPLOYEES.   RATE AS OF JULY 1,       IS  "]
["MEAL ALLOWANCE PER DAY IS =",null,null,{"$f":"SUM(P12:P14)","v":39.4}]
["ROOM RATE IS =",null,null,{"$f":"P15","v":75.099999999999994}]
[]
[]
["CERTIFICATION:"]
["I hereby certify that the quantities and amounts herein shown were compiled by  me and are correct to the best of my knowledge and belief, and that the work has been performed and the materials "]
["used in accordance with the Plans and Specifications heretofore approved for same."]
[" "]
[]
[null,null,null,null,null,null,"APPROVED: "]
[null,null,null,"RESIDENT ENGINEER",null,null,null,null,"DIVISION ENGINEER"]
[null,null,null,null,null,null," "]
[" ",null,null,null,null,null,null,null," "]

{"sheet":"Travel 480B Method B ","index":8,"n_rows":66,"n_cols":16,"rows_kept":66,"cut":false,"hidden":false,"merged":[[22,5,22,6],[14,0,14,4],[15,0,15,4],[16,0,16,4],[17,0,17,4],[18,0,18,4],[19,0,19,4],[20,0,20,4],[21,0,21,4],[22,0,22,4],[18,5,18,6],[19,5,19,6],[20,5,20,6],[21,5,21,6],[14,5,14,6],[15,5,15,6],[16,5,16,6],[17,5,17,6],[12,0,12,4],[13,0,13,4],[11,5,11,6],[12,5,12,6],[13,5,13,6],[7,1,7,2],[8,1,8,2],[9,1,9,2],[8,4,8,5],[11,0,11,4]]}
[null,null,null,null,null,null," "]
[]
["NORTH CAROLINA DEPARTMENT OF TRANSPORTATION"]
["DETAILED STATEMENT OF FORCE ACCOUNT WORK"]
["TRAVEL AND SUBSISTENCE"]
[null,null,null,null,null,null,"AUTHORIZED BY LETTER DATED: ",{"$f":"'Summary - 480'!G8","v":0}]
[null,null,null,null,null,"Method B"]
["CONTRACT NO.:",{"$f":"'Summary - 480'!I5","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"*Notes =","visit link below to verify current state rates"]
["WBS ELEMENT  :  ",{"$f":"'Summary - 480'!B9","v":0},null,"F.A. NO. :",{"$f":"'Summary - 480'!D9","v":0},null,"COUNTY:",{"$f":"'Summary - 480'!F9","v":0},"CONTRACTOR:  ",{"$f":"'Summary - 480'!H9","v":0},null,null,null,null,null,"https://www.osbm.nc.gov/budget/state-budget-manual/5-travel-policies-and-regulations#TP5_1"]
["SUBCONTRACTOR :                                                                         ",{"$f":"'Summary - 480'!B10:D10","v":0},null,null,null,null," ",null,"WEEK ENDING:  ",{"$f":"'Summary - 480'!H10","v":0}]
[]
["Employees Name & Date of Travel",null,null,null,null,"CONTRACTOR PER DIEM",null,"LENGTH","AMOUNT","ALLOWABLE",null,null,null,null,"breakfast",8.6]
[null,null,null,null,null,"NONE ACCOUNTABLE",null,"OF STAY","SUBMITTED","AMOUNT",null,null,null,null,"lunch",11.3]
[null,null,null,null,null,null,null,null,{"$f":"F14*H14","v":0},{"$f":"IF(I14<'Summary - 480'!$B$3*H14,I14,'Summary - 480'!$B$3*H14)","v":0},null,null,null,null,"dinner",19.5]
[null,null,null,null,null,null,null,null,{"$f":"F15*H15","v":0},{"$f":"IF(I15<'Summary - 480'!$B$3*H15,I15,'Summary - 480'!$B$3*H15)","v":0},null,null,null,null,"lodgeing",75.099999999999994]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(I16<'Summary - 480'!$B$3*H16,I16,'Summary - 480'!$B$3*H16)","v":0},null,null,null,null,null,{"$f":"SUM(P12:P15)","v":114.5}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(I17<'Summary - 480'!$B$3*H17,I17,'Summary - 480'!$B$3*H17)","v":0}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(I18<'Summary - 480'!$B$3*H18,I18,'Summary - 480'!$B$3*H18)","v":0}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(I19<'Summary - 480'!$B$3*H19,I19,'Summary - 480'!$B$3*H19)","v":0}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(I20<'Summary - 480'!$B$3*H20,I20,'Summary - 480'!$B$3*H20)","v":0}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(I21<'Summary - 480'!$B$3*H21,I21,'Summary - 480'!$B$3*H21)","v":0}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(I22<'Summary - 480'!$B$3*H22,I22,'Summary - 480'!$B$3*H22)","v":0}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(I23<'Summary - 480'!$B$3*H23,I23,'Summary - 480'!$B$3*H23)","v":0}]
[" ",null,null,null,null,null,null,"TRAVEL AND SUBSITENCE  SUBTOTAL: ",null,{"$f":"SUM(J14:J23)","v":0}]
[]
["ARTICLE 109-3B ALLOWS FOR COMPENSATION AT THE CURRENT IN-STATE"]
["RATE FOR STATE EMPLOYEES.  RATE AS OF JULY 1,     IS      ",null,null,null,null,{"$f":"'Summary - 480'!$A$4","v":0}]
["MEAL ALLOWANCE PER DAY IS =",null,null,{"$f":"SUM(P12:P14)","v":39.4}]
["ROOM RATE IS =",null,null,{"$f":"P15","v":75.099999999999994}]
[]
["CERTIFICATION:"]
["I hereby certify that the quantities and amounts herein shown were compiled by  me and are correct to the best of my knowledge and belief, and that the work has been performed and the materials "]
["used in accordance with the Plans and Specifications heretofore approved for same."]
[" "]
[]
[null,null,null,null,null,null,"APPROVED: "]
[null,null,null,"RESIDENT ENGINEER",null,null,null,null,"DIVISION ENGINEER"]
[null,null,null,null,null,null," "]
[" ",null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Max. State Rate","Days","Max. Allowed"]
[]
[null,null,null,{"$f":"$F$27","v":0},1,{"$f":"+D57*E57","v":0}]
[null,null,null,0,1,{"$f":"+D58*E58","v":0}]
[null,null,null,0,1,0]
[null,null,null,0,{"$f":"+H17","v":0},0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]

{"sheet":"Travel Summary 480B  ","index":9,"n_rows":35,"n_cols":10,"rows_kept":35,"cut":false,"hidden":false,"merged":[[14,1,14,8],[20,1,20,7],[21,1,21,7],[22,1,22,7],[23,1,23,7],[15,1,15,7],[16,1,16,7],[17,1,17,7],[19,1,19,7],[18,1,18,7],[13,1,13,5],[12,1,12,5],[5,1,5,2],[7,1,7,2],[8,1,8,2],[7,4,7,5]]}
[null,null,null,null,null,null," "]
[]
["NORTH CAROLINA DEPARTMENT OF TRANSPORTATION"]
["DETAILED STATEMENT OF FORCE ACCOUNT WORK"]
["TRAVEL SUMMARY"]
["CONTRACT NO.",{"$f":"'Summary - 480'!I5","v":0},null,null,null,null,"AUTHORIZED BY LETTER DATED: ",{"$f":"'Summary - 480'!G8","v":0}]
[]
["WBS ELEMENTT:      ",{"$f":"'Summary - 480'!B9","v":0},null,"F.A. NO. :",{"$f":"'Summary - 480'!D9","v":0},null,"COUNTY:",{"$f":"'Summary - 480'!F9","v":0},"CONTRACTOR:  ",{"$f":"'Summary - 480'!H9","v":0}]
["SUBCONTRACTOR :                                                                         ",{"$f":"'Summary - 480'!B10:D10","v":0},null,null,null,null," ",null,"WEEK ENDING:  ",{"$f":"'Summary - 480'!H10","v":0}]
[]
[]
[]
[null,"LABOR SUMMARY"]
[null,"ITEM",null,null,null,null,null,null,"AMOUNT"]
[]
[null,"Travel Method A",null,null,null,null,null,null,{"$f":"'Travel 480B Method A'!I23","v":0}]
[null,"Travel Method B",null,null,null,null,null,null,{"$f":"'Travel 480B Method B '!J24","v":0}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I16:I24)","v":0}]
[]
["CERTIFICATION:"]
["I hereby certify that the quantities and amounts herein shown were compiled by  me and are correct to the best of my knowledge and belief, and that the work has been performed and the materials "]
["used in accordance with the Plans and Specifications heretofore approved for same."]
[" "]
[]
[null,null,null,null,null,null,"APPROVED: "]
[null,null,null,"RESIDENT ENGINEER",null,null,null,null,"DIVISION ENGINEER"]
[null,null,null,null,null,null," "]
[" ",null,null,null,null,null,null,null," "]

{"sheet":"Equipment - 480C","index":10,"n_rows":63,"n_cols":27,"rows_kept":63,"cut":false,"hidden":false,"merged":[[0,0,0,18],[53,1,53,6],[53,9,53,17],[34,0,34,1],[35,0,35,1],[36,0,36,1],[9,0,9,1],[10,0,10,1],[5,9,5,11],[11,0,11,1],[28,0,28,2],[27,4,27,5],[28,4,28,5],[26,4,26,5],[26,0,26,2],[18,0,18,1],[5,16,5,18],[6,16,6,18],[12,0,12,1],[13,0,13,1],[14,0,14,1],[39,0,39,1],[27,7,27,8],[26,7,26,8],[28,7,28,8],[29,7,29,8],[37,7,37,8],[37,0,37,1],[27,0,27,2],[4,1,4,2],[5,1,5,2],[6,1,6,4],[5,6,5,7],[38,0,38,1],[15,0,15,1],[16,0,16,1],[17,0,17,1],[19,0,19,1],[20,0,20,1],[46,0,46,1],[38,7,38,8],[39,7,39,8],[40,7,40,8],[41,7,41,8],[42,7,42,8],[43,7,43,8],[44,7,44,8],[45,7,45,8],[46,7,46,8],[40,0,40,1],[41,0,41,1],[42,0,42,1],[43,0,43,1],[44,0,44,1],[45,0,45,1]]}
["NORTH CAROLINA DEPARTMENT OF TRANSPORTATION"]
["DETAILED STATEMENT OF FORCE ACCOUNT WORK"]
["EQUIPMENT / RENTAL EQUIPMENT / STANDBY OR IDLE EQUIPMENT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  "]
[null,null,null,null,null,null,null,"AUTHORIZED BY LETTER DATED:",{"$f":"'Summary - 480'!G8","v":0}]
["CONTRACT NO.",{"$f":"'Summary - 480'!I5","v":0}]
["WBS ELEMENT:  ",{"$f":"'Summary - 480'!B9","v":0},null,null,null,"F. A.  NO.:",{"$f":"'Summary - 480'!D9","v":0},null,"COUNTY:",{"$f":"'Summary - 480'!F9","v":0},null,null,null,null,null,"CONTRACTOR:  ",{"$f":"'Summary - 480'!H9","v":0}]
["SUBCONTRACTOR :                                                                         ",{"$f":"'Summary - 480'!B10:D10","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"WEEK ENDING:",{"$f":"'Summary - 480'!H10","v":0}]
[" ",null,null,null,null,null,null,null," "]
[null,null,"YEAR","BLUE  BOOK","BASE","AGE ADJ","REGION","OPER","ADJ",null,null,null,null,null,null,null,"TOTAL"," "]
["EQUIPMENT",null,"OF","CHAPTER","MONTHLY","FACTOR","ADJUST","COST per","HRLY",null,null,null,null,null,null,null,"HOURS","AMOUNT","REMARKS"]
["DESCRIPTION",null,"MODEL","AND PAGE","RATE (A)","(B)","FACTOR (C)","HR (D)","RATE*","S","M","T","W","T","F","S"]
[null,null,null,null,null,null,null,null,{"$f":"(E12*F12*G12/176)+(1*H12)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(J12:P12)","v":0},{"$f":"I12*Q12","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"(E13*F13*G13/176)+(1*H13)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(J13:P13)","v":0},{"$f":"I13*Q13","v":0}]
[null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,"* ADJUSTMENT HOURLY RATE = (A*B*C/176) + 1.0*D",null,null,null,null,null,null,null,"EQUIPMENT SUBTOTAL: ",{"$f":"SUM(R12:R21)","v":0}]
[]
["RENTAL",null,null,"MINIMUM",null,null,"ACT. NO."," ",null,{"$f":"J9","v":0},{"$f":"K9","v":0},0,0,0,0,0,"TOTAL","RENTAL"]
["EQUIPMENT",null,null,"RENTAL ","RENTAL",null,"of RENTAL","RENTAL",null,null,null,null,null,null,null,null,"HOURS","ADDITIVE","REMARKS"]
["DESCRIPTION",null,null,"PERIOD","RATE",null,"PERIODS","AMOUNT",null,"S","M","T","W","T","F","S","OPER","AMOUNT **"]
[null,null,null,null,null,null,null,{"$f":"G27*E27","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(J27:P27)","v":0},{"$f":"E27*(Q27/40)*0.15","v":0}]
[null,null,null,null,null,null,null,{"$f":"G28*E28","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(J28:P28)","v":0},{"$f":"E28*(Q28/40)*0.15","v":0}]
[null,null,null,null,null,null,null,{"$f":"G29*E29","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(J29:P29)","v":0},0]
[null,null,null,null,null,null,"RENTAL EQUIPMENT SUBTOTAL: ",{"$f":"SUM(H27:I29)","v":0},null,null,null,null,null,null,null,null,"RENTAL EQUIP. ADDITIVE SUBTOTAL: ",{"$f":"SUM(R27:R29)","v":0}]
[null,null,"** RENTAL ADDITIVE (WEEKLY RATES) = ((RENTAL RATE TIMES TOTAL HOURS OPERATED) DIVIDED BY 40) X .15"]
[null,null,"RENTAL ADDITIVE  (DAILY RATES) = ((RENTAL RATES TIMES TOTAL HOURS OPERATED) DIVIDED BY 8) X .15"]
[]
[]
["STANDBY OR IDLE",null,"YEAR","BLUE  BOOK","BASE","AGE","REGION","ADJUSTMENT",null,{"$f":"J9","v":0},{"$f":"K9","v":0},0,0,0,0,0,"TOTAL"," "]
["EQUIPMENT",null,"OF","CHAPTER","MONTHLY","ADJUST","ADJUST","HOURLY RATE",null,null,null,null,null,null,null,null,"HOURS","AMOUNT","REMARKS"]
["DESCRIPTION",null,"MODEL","AND PAGE","RATE","FACTOR","FACTOR","(A*B*C/176)*0.5",null,"S","M","T","W","T","F","S"]
[null,null,null,null,null,null,null,{"$f":"(E38*F38*G38)/176*(0.5)","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(J38:P38)","v":0},{"$f":"H38*Q38","v":0}]
[null,null,null,null,null,null,null,{"$f":"(E39*F39*G39)/176*(0.5)","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(J39:P39)","v":0},{"$f":"H39*Q39","v":0}]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STANDBY OR IDLE EQUIP. SUBTOTAL: ",{"$f":"SUM(R38:R47)","v":0}]
["CERTIFICATION:"]
["I hereby certify that the quantities and amounts herein shown were compiled by me and are correct to the best of my knowledge and belief, and that the work has been performed and "]
["the materials used in accordance with the Plans and Specifications heretofore approved for same."]
[]
[null,null,null,null,null,null,null,null,"APPROVED:"]
[null,"RESIDENT ENGINEER",null,null,null,null,null,null,null,"DIVISION ENGINEER"]
[]
[]
[]
["What about transportation of the equipment Section 109 part (D):"]
[null,"The contractor will be reimbursed for the actual transportation costs for the equipment which the contractor is direct to furnish.  "]
[null,"Such payment will be limited to transportation costs from the nearest source of available equipment."]
[null,"If equipment is not returned to the point of origin, but is transported to another location, transportation cost will not exceed the "]
[null,"cost of return to the point of origin.  Rental for such equipment will not be paid when the equipment is being transported."]
[null,"The contractor will furnsih records to the Engineer to verify the actual transportation costs for equipment."]

{"sheet":"Equip Ownerop -480C","index":11,"n_rows":57,"n_cols":28,"rows_kept":57,"cut":false,"hidden":false,"merged":[[52,10,53,26],[38,19,38,27],[25,17,25,18],[38,11,38,16],[11,17,11,18],[11,10,11,12],[24,10,24,12],[23,17,23,18],[24,17,24,18],[23,14,23,15],[22,17,22,18],[24,14,24,15],[23,10,23,12],[22,14,22,15],[22,10,22,12],[0,10,0,28],[14,17,14,18],[5,26,5,27],[6,26,6,27],[4,11,4,13],[5,19,5,21],[5,16,5,17],[12,17,12,18],[13,17,13,18],[11,14,11,15],[13,10,13,12],[5,11,5,13],[6,11,6,14],[13,14,13,15],[12,10,12,12],[12,14,12,15]]}
[null,null,null,null,null,null,null,null,null,null,"NORTH CAROLINA DEPARTMENT OF TRANSPORTATION"]
[null,null,null,null,null,null,null,null,null,null,"DETAILED STATEMENT OF FORCE ACCOUNT WORK"]
[null,null,null,null,null,null,null,null,null,null,"OWNER-OPERATED EQUIPMENT / FULLY MAINTAINED & OWNER OPERATED TRUCKS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AUTHORIZED BY LETTER DATED:",{"$f":"'Summary - 480'!G8","v":0}]
[null,null,null,null,null,null,null,null,null,null,"CONTRACT NO.",{"$f":"'Summary - 480'!I5","v":0}]
[null,null,null,null,null,null,null,null,null,null,"WBS ELEMENT  NO:  ",{"$f":"'Summary - 480'!B9","v":0},null,null,null,"F. A.  NO.:",{"$f":"'Summary - 480'!D9","v":0},null,"COUNTY:",{"$f":"'Summary - 480'!F9","v":0},null,null,null,null,null,"CONTRACTOR:  ",{"$f":"'Summary - 480'!H9","v":0}]
[null,null,null,null,null,null,null,null,null,null,"SUBCONTRACTOR :                                                                         ",{"$f":"'Summary - 480'!B10:D10","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,"WEEK ENDING:",{"$f":"'Summary - 480'!H10","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,"OWNER/OPERATED",null,null,"MINIMUM",null,null,"ACT. NO."," ",null,{"$f":"IF(U9=0,0,U9-1)","v":0},0,0,0,0,0,{"$f":"AA7","v":0},"TOTAL"]
[null,null,null,null,null,null,null,null,null,null,"EQUIPMENT",null,null,"RENTAL ","RENTAL",null,"of RENTAL","RENTAL",null,null,null,null,null,null,null,null,"HOURS","REMARKS"]
[null,null,null,null,null,null,null,null,null,null,"DESCRIPTION",null,null,"PERIOD","RATE",null,"PERIODS","AMOUNT",null,"S","M","T","W","T","F","S","OPER"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O12*Q12","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(T12:Z12)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,{"$f":"O13*Q13","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(T13:Z13)","v":0}]
[null,null,null,null,null,null,null,null,null,null," ",null,null," ",null,null,null,{"$f":"O14*Q14","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(T14:Z14)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RENTAL EQUIPMENT SUBTOTAL: ",{"$f":"SUM(R12:S14)","v":0}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"FULLY MAINTAINED",null,null,"MINIMUM",null,null,"ACT. NO."," ",null,{"$f":"IF(U20=0,0,U20-1)","v":0},0,0,0,0,0,{"$f":"AA7","v":0},"TOTAL"]
[null,null,null,null,null,null,null,null,null,null,"OWNER OPERATED",null,null,"RENTAL ","RENTAL",null,"of RENTAL","RENTAL",null,null,null,null,null,null,null,null,"HOURS"]
[null,null,null,null,null,null,null,null,null,null,"TRUCKS",null,null,"PERIOD","RATE",null,"PERIODS","AMOUNT",null,"S","M","T","W","T","F","S","OPER","REMARKS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O23*Q23","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(T23:Z23)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,{"$f":"O24*Q24","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(T24:Z24)","v":0}]
[null,null,null,null,null,null,null,null,null,null," ",null,null," ",null,null,null,{"$f":"O25*Q25","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(T25:Z25)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RENTAL EQUIPMENT SUBTOTAL: ",{"$f":"SUM(R23:S25)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"CERTIFICATION:"]
[null,null,null,null,null,null,null,null,null,null,"I hereby certify that the quantities and amounts herein shown were compiled by me and are correct to the best of my knowledge and belief, and that the work has been performed and "]
[null,null,null,null,null,null,null,null,null,null,"the materials used in accordance with the Plans and Specifications heretofore approved for same."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(67)",null,null,null,"APPROVED:",null,null,null,null,"(68)"]
[null,null,null,null,null,null,null,null,null,null,null,"RESIDENT ENGINEER",null,null,null,null,null,null,null,"DIVISION ENGINEER"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Section 109 Part (E) "]
[null,null,null,null,null,null,null,null,null,null,"For all owner operated equipment authorized by the Engineer to be used on the specific force account work, the contractor will receive rental \npayment equal to the exisitng contract rates with no additive as provided in subarticles 109-3A, 109-3B, 109-3D, 109-3H."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"For Fully maintained and operated trucks"]
[null,null,null,null,null,null,null,null,null,null,null,"the contractor will receive rental payment equal to the existing contract rates with no additive as proivded in subarticals 109-3A, 109-3B, 109-3D, 109-3H."]