{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Request Form","Transfer Receipt - BOL","Transfer Receipt - PDF","Trip Cost","Invoice","Approved Invoice PDF","Vehicle Cost Table","Miles-Hrs Conversion Values"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":1,"defined_names":8,"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":"Request Form","index":0,"n_rows":59,"n_cols":13,"rows_kept":59,"cut":false,"hidden":false,"merged":[[64,1,64,10],[62,1,62,10],[3,1,3,10],[8,1,8,10],[2,1,2,10],[14,3,14,5],[28,1,28,2],[29,1,29,2],[26,1,27,2],[26,3,26,4],[26,5,27,6],[28,5,28,6],[29,5,29,6],[32,7,32,10],[63,1,63,10],[35,1,35,2],[0,1,0,10],[1,1,1,10],[4,1,4,10],[5,2,5,7],[6,2,6,7],[36,7,36,10],[37,7,37,10],[32,1,32,2],[33,1,33,2],[35,7,35,10],[34,1,34,2],[33,7,33,10],[34,7,34,10],[26,7,27,10],[28,7,28,10],[29,7,29,10],[30,7,30,10],[31,7,31,10],[53,5,53,6],[42,5,42,6],[52,2,52,6],[34,5,34,6],[35,5,35,6],[36,5,36,6],[37,1,37,2],[41,2,41,6],[37,5,37,6],[36,1,36,2],[30,5,30,6],[31,5,31,6],[32,5,32,6],[33,5,33,6],[30,1,30,2],[31,1,31,2]]}
[null,"Department of General Services / Warehouse and Distribution Division"]
[null,"TRANSPORTATION REQUEST",null,null,null,null,null,null,null,null,null,null,"Y"]
[null,"REV:05312232    PLEASE REVIEW the INSTRUCTIONS AND REQUIREMENTS BEFORE COMPLETING THIS FORM",null,null,null,null,null,null,null,null,null,null,"N"]
[null,"MACRO SECURITY MUST BE SET TO MEDIUM and MACRO's ENABLED TO USE THIS FORM"]
[null,"Double Click the Instructions and Requirements Icon to find out how"]
[null,null,"Please complete all the fields in the form below and click the \"Send Request\" button"]
[null,null,"You will get a window asking you to allow this program to access outlook…please answer 'Yes'"]
[]
[null,"If you experience any difficulties with this form, or have questions about scheduling, please contact customer service at 717-525-5812."]
[]
[null,"Requestor Information:"]
[]
[null,"Agency Name -",null,null,null,"Pick Up Date -"]
[null,"Division Name -"]
[null,"Requestor -",null,"Requestor Phone -"]
[]
[null,"Accounting information:"]
[null,null,null,null,"Plant","% Charge","Fund","Cost Ctr","GL Account","Int Ord Y/N","Internal Order Number"]
[null,"Invoice Approval E-Mail -",null,null,null,1,null,null,null,"N"]
[]
[]
[]
[]
[]
[null,"Shipment Information:"]
[]
[null,"Description of Pallet(s) Contents",null,"Number and Description of Packages",null,"Code",null,"Pallet #'s / LPN's"]
[null,null,null,"Number","Size"]
[null,null,null,null,"PALLET"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Origin Pick-Up Information:"]
[]
[null,"Shipping Agency / Bureau -",{"$f":"CONCATENATE($C$13,\" / \",$C$14)","v":" / "},{"$f":"CONCATENATE($C$13,\" / \",$C$14)","v":" / "}," / "," / "," / "," / "]
[null,"Contact Name -",null,null,"Contact Phone -"]
[]
[null,"Building Name -"]
[null,"Street Address -"]
[null,"Addl Address Info -"]
[null,"City -",null,"State -",null,"Zip -"]
[]
[]
[null,"Destination Delivery Information:"]
[]
[null,"Receiving Agency / Bureau -",{"$f":"CONCATENATE($C$13,\" / \",$C$14)","v":" / "},{"$f":"CONCATENATE($C$13,\" / \",$C$14)","v":" / "}," / "," / "," / "," / "]
[null,"Contact Name -",null,null,"Contact Phone -"]
[]
[null,"Building Name -"]
[null,"Street Address -"]
[null,"Addl Address Info -"]
[null,"City -",null,"State -",null,"Zip -"]

{"sheet":"Transfer Receipt - BOL","index":1,"n_rows":52,"n_cols":15,"rows_kept":52,"cut":false,"hidden":true,"merged":[[46,1,47,7],[45,9,45,12],[46,11,46,14],[47,8,48,15],[25,9,26,12],[37,1,41,7],[40,9,40,13],[34,13,34,14],[35,13,35,14],[36,13,36,14],[27,9,27,12],[28,9,28,12],[29,9,29,12],[30,9,30,12],[45,2,45,4],[42,8,43,15],[0,1,0,15],[1,1,1,15],[29,13,29,14],[25,13,26,15],[25,8,26,8],[4,4,5,11],[27,13,27,14],[28,13,28,14],[20,13,20,15],[12,2,12,10],[13,2,13,10],[18,7,18,11],[17,1,17,5],[17,13,17,15],[3,12,3,15],[4,12,4,15],[32,13,32,14],[33,13,33,14],[41,9,41,13],[30,13,30,14],[32,9,32,12],[33,9,33,12],[31,13,31,14],[42,1,43,7],[19,7,19,11],[24,1,24,3],[24,4,24,5],[21,1,21,5],[23,1,23,3],[23,7,23,9],[23,10,23,11],[32,1,32,5],[20,7,20,11],[20,1,20,5],[23,4,23,5],[31,9,31,12],[21,7,21,11],[33,1,33,5],[25,6,25,7],[2,5,2,11],[7,11,7,12],[22,1,22,3],[17,7,17,11],[9,1,9,9],[7,1,7,9],[2,12,2,15],[5,12,5,15],[25,1,26,5],[7,13,7,15],[19,1,19,5],[18,1,18,5],[18,13,18,15],[19,13,19,15],[27,1,27,5],[28,1,28,5],[29,1,29,5],[30,1,30,5],[31,1,31,5],[34,1,34,5],[35,1,35,5],[36,1,36,5],[34,9,34,12],[35,9,35,12],[36,9,36,12]]}
[null,"THIS RECEIPT IS BASED ON THE INITIAL REQUEST "]
[null,"THE HARD COPY FOUND ON \"TRANSFER RECEIPT - PDF\" THAT CONTAINS ALL SIGNATURES"]
[null,null,null,null,null,"SHOULD BE USED TO CALCULATE THE INVOICE"]
[]
[null,"COMMONWEALTH OF PENNSYLVANIA",null,null,"BILL OF LADING",null,null,null,null,null,null,null,{"$f":"ROUND(TODAY()+(NOW()*1000),0)","v":44757262}]
[null,null,null,null,null,null,null,null,null,null,null,null,"(FREIGHT BILL #)"]
[null,"RECEIVED FROM (INSERT CONSIGNORS NAME)",null,null,null,null,null,null,null,null,null,"NAME OF STATION",null,"DATE"]
[null,{"$f":"CONCATENATE('Request Form'!C13,\" / \",'Request Form'!C14)","v":" / "},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Request Form'!G13","v":"00:00:00"}]
[null,"NAME OF TRANSPORTATION COMPANY",null,null,null,null,null,null,null,null,"at"]
[null,{"$f":"CONCATENATE(Invoice!E8,\" / \",Invoice!E9)","v":"Department of General Services / Warehouse and Distribution Division"}]
[]
[null,"The Public property described below in apparent good condition (contents and value unknown) to be forwarded"]
[null,"from",{"$f":"CONCATENATE('Request Form'!C43,\" of \",'Request Form'!C42:G42,,,\",  \",'Request Form'!E48,\".  \",'Request Form'!G48)","v":" of  / ,  .  "}]
[null,"to",{"$f":"CONCATENATE('Request Form'!C54,\"of \",'Request Form'!C53:G53)","v":"of  / "}]
[null,"by said company and its connections, there to be delivered in like good order and condition."]
[]
[null,"(INSERT NAME AND ADDRESS OF CONSIGNOR)",null,null,null,null,null,"(INSERT NAME AND ADDRESS OF CONSIGNEE)",null,null,null,null,null,"VIA (CARRIER IDENTIFICATION)"]
[null,{"$f":"'Request Form'!C42","v":" / "},null,null,null,null,null,{"$f":"'Request Form'!C53","v":" / "},null,null,null,null,null,"DGS/BSSO/W&DD"]
[null,{"$f":"'Request Form'!C45","v":0},null,null,null,null,null,{"$f":"'Request Form'!C56","v":0}]
[null,{"$f":"'Request Form'!C47","v":0},null,null,null,null,null,{"$f":"'Request Form'!C58","v":0}]
[null,{"$f":"'Request Form'!C46","v":0},null,null,null,null,null,{"$f":"'Request Form'!C57","v":0}]
[]
[null,{"$f":"'Request Form'!C48","v":0},null,null,{"$f":"'Request Form'!E48","v":0},{"$f":"'Request Form'!G48","v":0},null,{"$f":"'Request Form'!C59","v":0},null,null,{"$f":"'Request Form'!E59","v":0},{"$f":"'Request Form'!G59","v":0}]
[null,{"$f":"'Request Form'!C43","v":0},null,null,{"$f":"'Request Form'!F43","v":0},null,null,{"$f":"'Request Form'!C54","v":0},null,null,{"$f":"'Request Form'!F54","v":0}]
[null,"CONTACT NAME",null,null,"CONTACT PHONE"]
[null,"MARKS OR NUMBERS",null,null,null,null,"Number and Description of Packages",null,"Code","Contents",null,null,null,"Charges"]
[null,null,null,null,null,null,"Number","Size"]
[null,{"$f":"'Request Form'!H29","v":0},null,null,null,null,{"$f":"'Request Form'!D29","v":0},{"$f":"'Request Form'!E29","v":"PALLET"},{"$f":"'Request Form'!F29","v":0},{"$f":"'Request Form'!B29","v":0}]
[null,{"$f":"'Request Form'!H30","v":0},null,null,null,null,{"$f":"'Request Form'!D30","v":0},{"$f":"'Request Form'!E30","v":0},{"$f":"'Request Form'!F30","v":0},{"$f":"'Request Form'!B30","v":0}]
[null,{"$f":"'Request Form'!H31","v":0},null,null,null,null,{"$f":"'Request Form'!D31","v":0},{"$f":"'Request Form'!E31","v":0},{"$f":"'Request Form'!F31","v":0},{"$f":"'Request Form'!B31","v":0}]
[null,{"$f":"'Request Form'!H32","v":0},null,null,null,null,{"$f":"'Request Form'!D32","v":0},{"$f":"'Request Form'!E32","v":0},{"$f":"'Request Form'!F32","v":0},{"$f":"'Request Form'!B32","v":0}]
[null,{"$f":"'Request Form'!H33","v":0},null,null,null,null,{"$f":"'Request Form'!D33","v":0},{"$f":"'Request Form'!E33","v":0},{"$f":"'Request Form'!F33","v":0},{"$f":"'Request Form'!B33","v":0}]
[null,{"$f":"'Request Form'!H34","v":0},null,null,null,null,{"$f":"'Request Form'!D34","v":0},{"$f":"'Request Form'!E34","v":0},{"$f":"'Request Form'!F34","v":0},{"$f":"'Request Form'!B34","v":0}]
[null,{"$f":"'Request Form'!H35","v":0},null,null,null,null,{"$f":"'Request Form'!D35","v":0},{"$f":"'Request Form'!E35","v":0},{"$f":"'Request Form'!F35","v":0},{"$f":"'Request Form'!B35","v":0}]
[null,{"$f":"'Request Form'!H36","v":0},null,null,null,null,{"$f":"'Request Form'!D36","v":0},{"$f":"'Request Form'!E36","v":0},{"$f":"'Request Form'!F36","v":0},{"$f":"'Request Form'!B36","v":0}]
[null,{"$f":"'Request Form'!H37","v":0},null,null,null,null,{"$f":"'Request Form'!D37","v":0},{"$f":"'Request Form'!E37","v":0},{"$f":"'Request Form'!F37","v":0},{"$f":"'Request Form'!B37","v":0}]
[null,{"$f":"'Request Form'!H38","v":0},null,null,null,null,{"$f":"'Request Form'!D38","v":0},{"$f":"'Request Form'!E38","v":0},{"$f":"'Request Form'!F38","v":0},{"$f":"'Request Form'!B38","v":0}]
[null,"The fibre  boxes used in this shipment conform to the specifications set forth in the box makers certificate thereon and all other requirements of Rule 41 of the consolidated Freight Classification."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Agent"]
[]
[null,null,null,null,null,null,null,null,null,"DGS / Warehouse and Distribution Division"]
[null,null,null,null,null,null,null,null,null,"(TRANSPORTATION COMPANY)"]
[null,"CONSIGNORS CERTIFICATE OF SHIPMENT                           (Executed at Point of Origin by Consignor)",null,null,null,null,null,null,"CONSIGNEES CERTIFICATE OF RECEIPT                                                  (Executed at the Destination by Consignee)"]
[]
[]
[null,"Place",{"$f":"$B$21","v":0},null,null,"Date",null,null,"Place",{"$f":"$H$21","v":0},null,null,null,"Date"]
[null,"I have this day shipped in accordance with this Bill of Laiding the public proprty enumerated above.",null,null,null,null,null,null,"I have this day received from",null,null,{"$f":"B8","v":" / "}]
[null,null,null,null,null,null,null,null,"the public property enumerated above in apparent good order and condition except as noted above."]
[]
[]
[]
[null,null,null,null,null,null,"(CONSIGNOR)",null,null,null,null,null,null,null,"(CONSIGNEE)"]

{"sheet":"Transfer Receipt - PDF","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Trip Cost","index":3,"n_rows":26,"n_cols":32,"rows_kept":26,"cut":false,"hidden":true,"merged":[[14,3,14,4],[8,3,8,4],[5,24,5,31],[11,3,11,4],[12,3,12,4],[13,3,13,4],[5,7,5,12],[10,3,10,4],[9,3,9,4],[4,2,5,6],[4,24,4,31],[4,7,4,12],[19,3,19,4],[15,3,15,4],[16,3,16,4],[17,3,17,4],[18,3,18,4]]}
["Date","Agency","Address","Contact","Phone","BOL","Invoice #","Pallets",null,"# Emp","Veh #",null,"Miles","Fuel Cost Alloc","Maint Alloc","Veh cost per trip",null,"Mi/Hr","Calc Hrs/Trip","Min/Trip","Rate Per Pallet","Pallet Surcharge","Markup",null,"Enter Hrs/Trip","Unload time (hrs)","Labor Cost per hour fully burdened","Lobor cost per trip",null,"Sub Cost Per Trip cost per trip",null,"Total Cost Per Trip"]
[{"$f":"'Request Form'!G13","v":"00:00:00"},{"$f":"'Request Form'!C13","v":0},{"$f":"'Request Form'!C46","v":0},{"$f":"'Request Form'!C15","v":0},{"$f":"'Request Form'!G15","v":0},{"$f":"'Transfer Receipt - BOL'!M5","v":44757262},{"$f":"Invoice!K6","v":0},{"$f":"SUM('Transfer Receipt - BOL'!G28:'Transfer Receipt - BOL'!G37)","v":0},null,1,3,null,0,{"$f":"IF(K2>0,SUMIF('Vehicle Cost Table'!$B:$B,K2,'Vehicle Cost Table'!$L:$L),0)","v":1.0276134122287968},{"$f":"SUMIF('Vehicle Cost Table'!$B:$B,K2,'Vehicle Cost Table'!$M:$M)","v":0.18497534516765285},{"$f":"IF(M2>0,IF(K2>0,(N2+O2)*M2,\"Veh # Req\"),\"\")","v":""},null,{"$f":"IF(M2>0,IF(M2>0,VLOOKUP(M2,'Miles-Hrs Conversion Values'!B:F,2),0),\"\")","v":""},{"$f":"IF(M2>0,IF(M2>0,VLOOKUP(M2,'Miles-Hrs Conversion Values'!B:F,3),0),\"\")","v":""},{"$f":"IF(M2>0,VLOOKUP(M2,'Miles-Hrs Conversion Values'!B:F,4),0)","v":0},15,{"$f":"H2*U2","v":0},0.2,null,{"$f":"IF(S2>0,S2,0)","v":""},null,22.62,{"$f":"IF(Y2>0,IF(Y2>8,((((Y2)-8)*J2)*(AA2*1.5))+((8*J2)*AA2),((Y2)*J2)*AA2),\"\")","v":{"$error":"#VALUE!"}},null,{"$f":"IF(AB2>0,P2+AB2+V2,\"\")","v":{"$error":"#VALUE!"}},null,{"$f":"AD2+(AD2*W2)","v":{"$error":"#VALUE!"}}]
[]
[]
[null,null,"Verify Number of Actual Pallets                                              Change here if necessary",null,null,null,null,"Enter Mapquest Miles",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Check This Against MapQuest"]
[null,null,null,null,null,null,null,"MAPQUEST",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"and OVERTYPE If needed"]
[]
[null,null,null,null,null,null,null,"BEFORE Transfer is Completed"]
[null,null,"Address","Miles",null,"Hrs/Trip",null,"1-","Click [Save] … Click [Close]"]
[null,null,"400 North Street",9,null,0.43,null,"2-","Don’t Forget to Click [Save and Close] on the Appointment"]
[null,null,"Kline Plaza",10,null,0.48]
[null,null,"18th and Herr",11,null,0.35,null,"AFTER the Transfer is Complete and Form is signed"]
[null,null,"333 Market Street",12,null,0.42,null,"1-","Put the signed form in this workbook"]
[null,null,"2221 Forster Street",13,null,0.38,null,null,"a.","Scan the Form to PDF and send to yourself"]
[null,null,"ROC",10,null,0.47,null,null,"b.","Open the PDF"]
[null,null,null,null,null,null,null,null,"c.","Click [edit] > [copy to file]"]
[null,null,null,null,null,null,null,null,"d.","Close the PDF"]
[null,null,null,null,null,null,null,null,"e.","Click the [Transfer Receipt - PDF] tab and Click [Paste]"]
[null,null,null,null,null,null,null,"2-","Verify Pallets and Cartons from Transfer receipt (change if needed)"]
[null,null,null,null,null,null,null,"3-","Enter Mapquest Miles and Hours (hours+{[Minutes]/60})"]
[null,null,null,null,null,null,null,"4-","Check the cost values to make sure they look OK"]
[null,null,null,null,null,null,null,"5-","Click Copy To Log Button"]
[null,null,null,null,null,null,null,"6-","WAIT for [Copy Record To Log] button is grey"]
[null,null,null,null,null,null,null,"7-","Click [Send Invoice To Resource Account]"]
[null,null,null,null,null,null,null,"8-","Click [Save] … Click [Close]"]
[null,null,null,null,null,null,null,"9-","Don’t Forget to Click [Save and Close] on the Appointment"]

{"sheet":"Invoice","index":4,"n_rows":43,"n_cols":13,"rows_kept":43,"cut":false,"hidden":true,"merged":[[4,10,4,12],[5,10,5,13],[6,10,6,12],[7,10,7,13],[13,10,13,13],[8,10,8,12],[9,10,9,13],[10,10,10,12],[11,10,11,13],[12,10,12,12],[14,12,14,13],[28,8,28,10],[26,8,26,10],[29,8,29,10],[27,8,27,10],[29,6,29,7],[16,12,16,13],[26,6,26,7],[27,6,27,7],[42,1,42,5],[42,6,42,13],[34,6,34,7],[36,1,36,5],[37,1,37,5],[38,1,38,5],[39,1,39,5],[41,1,41,5],[36,6,36,13],[38,6,38,13],[28,6,28,7],[30,8,30,10],[0,1,0,13],[1,1,1,13],[3,1,3,13],[2,3,2,4],[2,5,2,8],[33,3,33,4],[39,6,39,13],[41,6,41,13],[30,6,30,7],[31,6,31,7],[32,6,32,7],[33,6,33,7],[33,12,33,13],[34,8,34,11],[33,8,33,11],[32,8,32,11],[37,6,37,13],[31,8,31,10]]}
[null,"PLEASE PRINT THIS INVOICE AND SIGN INDICATING APPROVAL"]
[null,"SCAN THE SIGNED COPY INTO A PDF FILE"]
[null,null,null,"AND EMAIL TO : ",null,"GS, WhsDist"]
[]
[null,null,null,null,null,null,null,null,null,null,"INVOICE NO."]
[null,"GENERAL  INVOICE"]
[null,"PAYOR (NAME AND ADDRESS)",null,null,"PAYEE  (NAME AND ADDRESS)",null,null,null,null,null,"DATE"]
[null,{"$f":"IF('Request Form'!$C$13=\"\",\"\",'Request Form'!$C$13)","v":""},null,null,"Department of General Services"]
[null,{"$f":"IF('Request Form'!$C$14=\"\",\"\",'Request Form'!$C$14)","v":""},null,null,"Warehouse and Distribution Division",null,null,null,null,null,"ORDER NO."]
[null,{"$f":"IF('Request Form'!$C$45=\"\",\"\",'Request Form'!$C$45)","v":""},null,null,"905 Elmerton Avenue"]
[null,{"$f":"IF('Request Form'!$C$46=\"\",\"\",'Request Form'!$C$46)","v":""},null,null,"Harrisburg, PA  17110",null,null,null,null,null,"VT OR ADVANCEMENT ACCOUNT NO."]
[null,{"$f":"IF('Request Form'!$C$47=\"\",\"\",'Request Form'!$C$47)","v":""}]
[null,{"$f":"IF('Request Form'!$C$48=\"\",\"\",'Request Form'!$C$48)","v":""},{"$f":"'Request Form'!$E$48","v":0},{"$f":"'Request Form'!$G$48","v":0},"VENDOR NO.",null,null,null,null,null,"TERMS"]
[null,"kclemence@pa.gov","INVOICE E-MAIL",null," ","691147-001"]
[null,"DATE OF TRANSACTION",null,"ITEM AND DESCRIPTION",null,null,null,null,"QUANTITY","UNIT","PALLETS","CARTONS","AMOUNT"]
[]
[null,{"$f":"'Request Form'!$G$13","v":"00:00:00"},"Transportation Services rendered as itemized in ",null,null,null,null,null,1,"Ea.",{"$f":"'Trip Cost'!H2","v":0},null,{"$f":"'Trip Cost'!$AF$2","v":{"$error":"#VALUE!"}}]
[null,null,"Bill of Lading #",null,{"$f":"'Transfer Receipt - BOL'!M5","v":44757262}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"%","FUND","COST CENTER","GL","Int Ord Y/N",null,"Internal Order Number"]
[null,"EXPENDITURE CODING",{"$f":"'Request Form'!F19","v":1},{"$f":"'Request Form'!$G19","v":0},{"$f":"'Request Form'!$H19","v":0},{"$f":"'Request Form'!$I19","v":0},{"$f":"'Request Form'!J19","v":"N"},null,{"$f":"'Request Form'!K19","v":0}]
[null,null,{"$f":"'Request Form'!F20","v":0},{"$f":"'Request Form'!$G20","v":0},{"$f":"'Request Form'!$H20","v":0},{"$f":"'Request Form'!$I20","v":0},{"$f":"'Request Form'!K20","v":0},null,{"$f":"'Request Form'!K20","v":0}]
[null,null,{"$f":"'Request Form'!F21","v":0},{"$f":"'Request Form'!$G21","v":0},{"$f":"'Request Form'!$H21","v":0},{"$f":"'Request Form'!$I21","v":0},{"$f":"'Request Form'!K21","v":0},null,{"$f":"'Request Form'!K21","v":0}]
[null,null,{"$f":"'Request Form'!F22","v":0},{"$f":"'Request Form'!$G22","v":0},{"$f":"'Request Form'!$H22","v":0},{"$f":"'Request Form'!$I22","v":0},{"$f":"'Request Form'!K22","v":0},null,{"$f":"'Request Form'!K22","v":0}]
[null,null,{"$f":"'Request Form'!F23","v":0},{"$f":"'Request Form'!$G23","v":0},{"$f":"'Request Form'!$H23","v":0},{"$f":"'Request Form'!$I23","v":0},{"$f":"'Request Form'!K23","v":0},null,{"$f":"'Request Form'!K23","v":0}]
[null,"REVENUE CODING",1,5000900001,1577330731,4201508]
[null,null,null,"Secondary Cost Element = ",null,9115005,null,null,"TOTAL   ",null,null,null,{"$f":"SUM(M16:M26)","v":{"$error":"#VALUE!"}}]
[]
[]
[null,"I CERTIFY THAT THE ABOVE EXPENSES, SERVICES, MATERIALS OR",null,null,null,null,"ACKNOWLEDGMENT OF THE FOLLOWING IS REQUIRED IF PAYMENT IS"]
[null,"PRODUCTS WERE ACTUALLY INCURRED, RENDERED OR FURNISHED",null,null,null,null,"MADE FROM ADVANCED REQUISITION MONEYS."]
[null,"FOR THE USE OF THE COMMONWEALTH OF PENNSYLVANIA, AND THAT",null,null,null,null,"I HEREBY ACKNOWLEDGE RECEIPT IN FULL AS SET FORTH IN THIS"]
[null,"THE ABOVE PRICES CHARGED WERE FAIR AND REASONABLE.",null,null,null,null,"INVOICE IN THE AMOUNT OF $______________________"]
[]
[null,"____________________________________________________________________",null,null,null,null,"                   _____________________________________________________________"]
[null,"SIGNATURE",null,null,null,null,"SIGNATURE"]

{"sheet":"Approved Invoice PDF","index":5,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
[" "]

{"sheet":"Vehicle Cost Table","index":6,"n_rows":29,"n_cols":15,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
[]
[null,"VEH #","Whse","ORG","Year","Make","Model","Equip No","VIN#","Title # ","License",{"$f":"'[1]Vehicle Cost Table'!I2","v":"Maint Alloc (2007 Actual)"},{"$f":"'[1]Vehicle Cost Table'!H2","v":"Fuel Cost Alloc (Cost/Mi)"},null,"2016-08-10"]
[null,1,"Elmerton",7330,2002,"FORD / Blue","WINDSTAR CARGO","057-00-5281","2FTZA54452BA75132","57009884402","PA91276",0.30751981248656779,0.14978539551096065]
[null,2,"Elmerton",7330,1996,"Ford / Green","F700","057-03-3961","1FDNF70J1TVA18354","49255459201","PA75957",1.0909153993185408,0.49652995564644781]
[null,3,"Elmerton",7330,2015,"Hino","268A-16 Box Truck","085-03-0015","5PVNJ8JT8G4S56934",75719046800,"PA9861A",1.0276134122287968,0.18497534516765285]
[null,4,"Elmerton",7330,2003,"GMC / Blue","SAVANA 3500","059-01-1116","1GTHG35U531140099","58391119101","PA91223",0.20306630163075823,0.18155882094975587]
[null,5,"Elmerton",7330,1995,"Mack","CH613","068-04-0127","1M1AA13YOSW050762","48118694001","PA74576",1.7687885586090857,0.69081550748414844]
[null,6,"Elmerton",7330,2002,"Sterling","M8500 Acterra Truck","077-04-0006","2FZAANCSX2AK17965","57125590801","PA86972",0.34771711711711711,0.34629902569421478]
[null,7,"Federal",7320,2005,"Dodge","Caravan","006-05-6164","1D4GP24R35B320006","72253573300","35391PA",0.11849334466156895,0.1040750392356124]
[null,8,"Federal",7320,2001,"International","box truck","065-02-2663","1HTSCABM21H366697","70891113600","PA4041A",0.11539179954441914,0.29715774487471525]
[null,9,"Federal",7320,1995,"Mack","CH613","068-04-0128","1M1AA13Y2SW050763","48118694001","PA74577",0.28344685039370082,0.9556751901634668]
[null,10,"Federal",7320,2010,"Mack","Tractor","068-04-0161","1M1AW07Y6ANO11684","67669430000","PA98622",0.1872198309546125,0.52262113608153227]
[null,11,"Forster",7330,2001,"Chevy","Box Truck","053-02-6868","1GBG6HIESIJ511641",56647192101,"PA86833",0.80295840961186926,0.46118778715883224]
[null,12,"Forster",7330,2015,"Hino","268A-16 Box Truck","085-03-0016","5PVNJ8JT1G4S56936",75719047000,"PA9862A",1.0280470914127424,0.19107340720221608]
[null,13,"Forster",7330,2003,"Ford Blue","E350 passenger van","057-10-6328","1FBSS31L93HBO5319",68677769601,"31520PA",0.15054442344045368,0.2147865438402542]
[null,14,"Recycle",7340,2004,"Sterling","box truck","077-04-0010","2FZACHC574AM51673",59488583301,"PA88954",0.20436984770798444,0.26046590166607841]
[null,15,"Recycle",7340,2000,"Sterling","Compactor","086-04-0009","2FZHAJBB4YAG51349",54606980001,"PA86805",0.88780524858834875,0.58147711376902944]
[null,16,"Recycle",7340,2007,"Sterling","Compactor","077-04-0026","2FZHCHDJ17AX82578",64761263201,"PA96981",0.71574273657112208,0.65495456270141406]
[null,17,"State",7310,2003,"Daimler","Sterling","077-04-0007","LEASED",58175567001,"87654PA",0.42217567710755427,0.34404250207503073]
[null,18,"State",7310,2013,"Ford","E-350","057-01-6572","1FTSE2EL7DDA10568",71354356801,"PA5849A",2.0760380190095049E-2,0.13124678217023464]
[null,19]
[null,20]
[]
[null,null,null,null,"CY2007 Actual"]
[null,null,null,null,"Cost","Location","Miles",null,null,null,null,null,"CPM"]
[null,null,null,null,3353.58,"Elmerton",20362,null,null,null,null,null,0.16469796680090365]
[null,null,null,null,6630.74,"Bobali",11230,null,null,null,null,null,0.5904487978628673]
[null,null,null,null,1644.02,"Forster",13604,null,null,null,null,null,0.12084827991767128]
[null,null,null,"Total",11628.34,null,45196,null,null,null,null,null,0.25728692804672981]

{"sheet":"Miles-Hrs Conversion Values","index":7,"n_rows":232,"n_cols":7,"rows_kept":232,"cut":false,"hidden":true,"merged":[]}
[null,"Miles","MPH","Hrs","Min"]
[null,1,4,0.25,15,null,0.32659861234108267]
[null,2,23.939185610743277,8.3545030834401179E-2,5.0127018500640705,null,0.33807317101190304]
[null,3,24.277258781755179,0.12357243570903305,7.4143461425419828,null,0.34954772968272341]
[null,4,24.626806511437902,0.16242463261089915,9.7454779566539482,null,0.36102228835354377]
[null,5,24.987828799791444,0.20009741702895498,12.005845021737299,null,0.37249684702436414]
[null,6,25.360325646815809,0.23659002189324599,14.195401313594759,null,0.38397140569518451]
[null,7,25.744297052510994,0.27190487997097007,16.314292798258204,null,0.39544596436600488]
[null,8,26.139743016876999,0.30604738519559427,18.362843111735657,null,0.40692052303682524]
[null,9,26.546663539913823,0.33902565520025485,20.341539312015293,null,0.41839508170764561]
[null,10,26.96505862162147,0.37085029705745465,22.251017823447278,null,0.42986964037846598]
[null,11,27.394928261999937,0.4015341779616311,24.092050677697866,null,0.44134419904928635]
[null,12,27.836272461049223,0.43109220233389284,25.865532140033569,null,0.45281875772010671]
[null,13,28.289091218769329,0.45954109658265452,27.572465794959271,null,0.46429331639092708]
[null,14,28.753384535160254,0.48689920252276736,29.213952151366041,null,0.47576787506174745]
[null,15,29.229152410222003,0.51318628024103119,30.79117681446187,null,0.48724243373256781]
[null,16,29.716394843954571,0.53842332099901413,32.305399259940849,null,0.49871699240338818]
[null,17,30.215111836357959,0.56263237058562976,33.757942235137783,null,0.51019155107420855]
[null,18,30.725303387432167,0.58583636337217404,35.150181802330444,null,0.52166610974502892]
[null,19,31.246969497177197,0.60805896718132713,36.483538030879629,null,0.53314066841584928]
[null,20,31.780110165593047,0.62932443895846324,37.759466337507796,null,0.54461522708666965]
[null,21,32.324725392679717,0.649657491127695,38.979449467661702,null,0.55608978575749002]
[null,22,32.88081517843721,0.66908316842543791,40.144990105526276,null,0.56756434442831039]
[null,23,33.448379522865523,0.68762673492977611,41.257604095786569,null,0.57903890309913075]
[null,24,34.027418425964655,0.70531357094333014,42.318814256599808,null,0.59051346176995112]
[null,25,34.617931887734606,0.72216907933941854,43.330144760365116,null,0.60198802044077149]
[null,26,35.219919908175378,0.73821860094476777,44.293116056686067,null,0.61346257911159185]
[null,27,35.833382487286968,0.75348733850562688,45.209240310337613,null,0.62493713778241222]
[null,28,36.458319625069379,0.76800028876664705,46.080017325998824,null,0.63641169645323259]
[null,29,37.094731321522609,0.78178218218213669,46.906930930928198,null,0.64788625512405296]
[null,30,37.742617576646659,0.7948574297762161,47.691445786572963,null,0.65936081379487332]
[null,31,38.401978390441535,0.8072500766709475,48.435004600256853,null,0.67083537246569369]
[null,32,39.072813762907231,0.81898376180878929,49.139025708527356,null,0.68230993113651406]
[null,33,39.755123694043746,0.8300816834068655,49.804901004411931,null,0.69378448980733443]
[null,34,40.448908183851081,0.84056656969480925,50.433994181688554,null,0.70525904847815479]
[null,35,41.154167232329236,0.85046065450463681,51.027639270278208,null,0.71673360714897516]
[null,36,41.87090083947821,0.85978565729966816,51.587139437980092,null,0.72820816581979553]
[null,37,42.599109005298004,0.86856276724938897,52.113766034963341,null,0.73968272449061589]
[null,38,43.338791729788618,0.87681263097791817,52.608757858675091,null,0.75115728316143626]
[null,39,44.089949012950051,0.88455534363500765,53.07332061810046,null,0.76263184183225663]
[null,40,44.85258085478231,0.89181044295994139,53.50862657759648,null,0.774106400503077]
[null,41,45.62668725528539,0.89859690603004638,53.915814361802781,null,0.78558095917389736]
[null,42,46.412268214459289,0.90493314840655237,54.295988904393141,null,0.79705551784471773]
[null,43,47.209323732304007,0.9108370254110697,54.650221524664182,null,0.8085300765155381]
[null,44,48.017853808819545,0.91632583528584155,54.979550117150495,null,0.82000463518635847]
[null,45,48.837858444005903,0.92141632401006845,55.284979440604104,null,0.83147919385717883]
[null,46,49.66933763786308,0.92612469156291033,55.567481493774622,null,0.8429537525279992]
[null,47,50.512291390391077,0.93046659944119625,55.827995966471775,null,0.85442831119881957]
[null,48,51.366719701589894,0.93445717925636418,56.067430755381849,null,0.86590286986963994]
[null,49,52.232622571459537,0.93811104225071251,56.286662535042751,null,0.8773774285404603]
[null,50,53.11,0.94144228958764831,56.486537375258898,null,0.88885198721128067]
[null,51,53.5,0.95327102803738317,57.196261682242991]
[null,52,54,0.98113207547169812,58.867924528301884]
[null,53,54,1,60]
[null,54,54,1.0188679245283019,61.132075471698116]
[null,55,54,1.1020753366729557,66.124520200377333]
[null,56,54,1.0566037735849056,63.39622641509434]
[null,57,54,1.0754716981132075,64.528301886792448]
[null,58,54,1.0943396226415094,65.660377358490564]
[null,59,54,1.1132075471698113,66.79245283018868]
[null,60,54,1.1320754716981132,67.924528301886795]
[null,61,54.5,{"$f":"B62/C62","v":1.1192660550458715},{"$f":"D62*60","v":67.155963302752298}]
[null,62,54.5,1.1376146788990826,68.256880733944953]
[null,63,54.5,1.1559633027522935,69.357798165137609]
[null,64,54.5,1.1743119266055047,70.458715596330279]
[null,65,54.5,1.1926605504587156,71.559633027522935]
[null,66,54.5,1.2110091743119267,72.660550458715605]
[null,67,54.5,1.2293577981651376,73.761467889908261]
[null,68,54.5,1.2477064220183487,74.862385321100916]
[null,69,54.5,1.2660550458715596,75.963302752293572]
[null,70,55,1.2727272727272727,76.36363636363636]
[null,71,55,1.290909090909091,77.454545454545467]
[null,72,55,1.3090909090909091,78.545454545454547]
[null,73,55,1.3272727272727274,79.63636363636364]
[null,74,55,1.3454545454545455,80.727272727272734]
[null,75,55,1.3636363636363635,81.818181818181813]
[null,76,55,1.3818181818181818,82.909090909090907]
[null,77,55,1.4,84]
[null,78,55,1.4181818181818182,85.090909090909093]
[null,79,55,1.4363636363636363,86.181818181818173]
[null,80,55.5,1.4414414414414414,86.486486486486484]
[null,81,55.5,1.4594594594594594,87.567567567567565]
[null,82,55.5,1.4774774774774775,88.648648648648646]
[null,83,55.5,1.4954954954954955,89.729729729729726]
[null,84,55.5,1.5135135135135136,90.810810810810821]
[null,85,55.5,1.5315315315315314,91.891891891891888]
[null,86,55.5,1.5495495495495495,92.972972972972968]
[null,87,55.5,1.5675675675675675,94.054054054054049]
[null,88,55.5,1.5855855855855856,95.13513513513513]
[null,89,55.5,1.6036036036036037,96.216216216216225]
[null,90,56,1.6071428571428572,96.428571428571431]
[null,91,56,1.625,97.5]
[null,92,56,1.6428571428571428,98.571428571428569]
[null,93,56,{"$f":"B94/C94","v":1.6607142857142858},{"$f":"D94*60","v":99.642857142857153}]
[null,94,56,1.6785714285714286,100.71428571428572]
[null,95,56,1.6964285714285714,101.78571428571428]
[null,96,56,1.7142857142857142,102.85714285714285]
[null,97,56,1.7321428571428572,103.92857142857143]
[null,98,56,1.75,105]
[null,99,56,1.7678571428571428,106.07142857142857]
[null,100,56.5,1.7699115044247788,106.19469026548673]
[null,101,56.5,1.7876106194690264,107.25663716814158]
[null,102,56.5,1.8053097345132743,108.31858407079646]
[null,103,56.5,1.8230088495575221,109.38053097345133]
[null,104,56.5,1.8407079646017699,110.4424778761062]
[null,105,56.5,1.8584070796460177,111.50442477876106]
[null,106,56.5,1.8761061946902655,112.56637168141593]
[null,107,56.5,1.8938053097345133,113.6283185840708]
[null,108,56.5,1.9115044247787611,114.69026548672566]
[null,109,56.5,1.9292035398230087,115.75221238938053]
[null,110,57,1.9298245614035088,115.78947368421052]
[null,111,57,1.9473684210526316,116.8421052631579]
[null,112,57,1.9649122807017543,117.89473684210526]
[null,113,57,1.9824561403508771,118.94736842105263]
[null,114,57,2,120]
[null,115,57,2.0175438596491229,121.05263157894737]
[null,116,57,2.0350877192982457,122.10526315789474]
[null,117,57,2.0526315789473686,123.15789473684211]
[null,118,57,2.0701754385964914,124.21052631578948]
[null,119,57,2.0877192982456139,125.26315789473684]
[null,120,57.5,2.0869565217391304,125.21739130434783]
[null,121,57.5,2.1043478260869564,126.26086956521738]
[null,122,57.5,2.1217391304347828,127.30434782608697]
[null,123,57.5,2.1391304347826088,128.34782608695653]
[null,124,57.5,2.1565217391304348,129.39130434782609]
[null,125,57.5,{"$f":"B126/C126","v":2.1739130434782608},{"$f":"D126*60","v":130.43478260869566}]
[null,126,57.5,2.1913043478260867,131.47826086956519]
[null,127,57.5,2.2086956521739132,132.52173913043478]
[null,128,57.5,2.2260869565217392,133.56521739130434]
[null,129,57.5,2.2434782608695651,134.60869565217391]
[null,130,58,2.2413793103448274,134.48275862068965]
[null,131,58,2.2586206896551726,135.51724137931035]
[null,132,58,2.2758620689655173,136.55172413793105]
[null,133,58,2.2931034482758621,137.58620689655172]
[null,134,58,2.3103448275862069,138.62068965517241]
[null,135,58,2.3275862068965516,139.65517241379308]
[null,136,58,2.3448275862068964,140.68965517241378]
[null,137,58,2.3620689655172415,141.72413793103451]
[null,138,58,2.3793103448275863,142.75862068965517]
[null,139,58,2.396551724137931,143.79310344827587]
[null,140,58,2.4137931034482758,144.82758620689654]
[null,141,58,2.4310344827586206,145.86206896551724]
[null,142,58,2.4482758620689653,146.89655172413791]
[null,143,58,2.4655172413793105,147.93103448275863]
[null,144,58,2.4827586206896552,148.9655172413793]
[null,145,58,2.5,150]
[null,146,58,2.5172413793103448,151.0344827586207]
[null,147,58,2.5344827586206895,152.06896551724137]
[null,148,58,2.5517241379310347,153.10344827586209]
[null,149,58,2.5689655172413794,154.13793103448276]
[null,150,58,2.5862068965517242,155.17241379310346]
[null,151,58,2.603448275862069,156.20689655172413]
[null,152,58,2.6206896551724137,157.24137931034483]
[null,153,58,2.6379310344827585,158.27586206896549]
[null,154,58,2.6551724137931036,159.31034482758622]
[null,155,58,2.6724137931034484,160.34482758620692]
[null,156,58,2.6896551724137931,161.37931034482759]
[null,157,58,{"$f":"B158/C158","v":2.7068965517241379},{"$f":"D158*60","v":162.41379310344828}]
[null,158,58,2.7241379310344827,163.44827586206895]
[null,159,58,2.7413793103448274,164.48275862068965]
[null,160,58,2.7586206896551726,165.51724137931035]
[null,161,58,2.7758620689655173,166.55172413793105]
[null,162,58,2.7931034482758621,167.58620689655172]
[null,163,58,2.8103448275862069,168.62068965517241]
[null,164,58,2.8275862068965516,169.65517241379308]
[null,165,58,2.8448275862068964,170.68965517241378]
[null,166,58,2.8620689655172415,171.72413793103451]
[null,167,58,2.8793103448275863,172.75862068965517]
[null,168,58,2.896551724137931,173.79310344827587]
[null,169,58,2.9137931034482758,174.82758620689654]
[null,170,58,2.9310344827586206,175.86206896551724]
[null,171,58,2.9482758620689653,176.89655172413791]
[null,172,58,2.9655172413793105,177.93103448275863]
[null,173,58,2.9827586206896552,178.9655172413793]
[null,174,58,3,180]
[null,175,58,3.0172413793103448,181.0344827586207]
[null,176,58,3.0344827586206895,182.06896551724137]
[null,177,58,3.0517241379310347,183.10344827586209]
[null,178,58,3.0689655172413794,184.13793103448276]
[null,179,58,3.0862068965517242,185.17241379310346]
[null,180,58,3.103448275862069,186.20689655172413]
[null,181,58,3.1206896551724137,187.24137931034483]
[null,182,58,3.1379310344827585,188.27586206896549]
[null,183,58,3.1551724137931036,189.31034482758622]
[null,184,58,3.1724137931034484,190.34482758620692]
[null,185,58,3.1896551724137931,191.37931034482759]
[null,186,58,3.2068965517241379,192.41379310344828]
[null,187,58,3.2241379310344827,193.44827586206895]
[null,188,58,3.2413793103448274,194.48275862068965]
[null,189,58,{"$f":"B190/C190","v":3.2586206896551726},{"$f":"D190*60","v":195.51724137931035}]
[null,190,58,3.2758620689655173,196.55172413793105]
[null,191,58,3.2931034482758621,197.58620689655172]
[null,192,58,3.3103448275862069,198.62068965517241]
[null,193,58,3.3275862068965516,199.65517241379308]
[null,194,58,3.3448275862068964,200.68965517241378]
[null,195,58,3.3620689655172415,201.72413793103451]
[null,196,58,3.3793103448275863,202.75862068965517]
[null,197,58,3.396551724137931,203.79310344827587]
[null,198,58,3.4137931034482758,204.82758620689654]
[null,199,58,3.4310344827586206,205.86206896551724]
[null,200,58,3.4482758620689653,206.89655172413791]
[null,201,58,3.4655172413793105,207.93103448275863]
[null,202,58,3.4827586206896552,208.9655172413793]
[null,203,58,3.5,210]
[null,204,58,3.5172413793103448,211.0344827586207]
[null,205,58,3.5344827586206895,212.06896551724137]
[null,206,58,3.5517241379310347,213.10344827586209]
[null,207,58,3.5689655172413794,214.13793103448276]
[null,208,58,3.5862068965517242,215.17241379310346]
[null,209,58,3.603448275862069,216.20689655172413]
[null,210,58,3.6206896551724137,217.24137931034483]
[null,211,58,3.6379310344827585,218.27586206896549]
[null,212,58,3.6551724137931036,219.31034482758622]
[null,213,58,3.6724137931034484,220.34482758620692]
[null,214,58,3.6896551724137931,221.37931034482759]
[null,215,58,3.7068965517241379,222.41379310344828]
[null,216,58,3.7241379310344827,223.44827586206895]
[null,217,58,3.7413793103448274,224.48275862068965]
[null,218,58,3.7586206896551726,225.51724137931035]
[null,219,58,3.7758620689655173,226.55172413793105]
[null,220,58,3.7931034482758621,227.58620689655172]
[null,221,58,{"$f":"B222/C222","v":3.8103448275862069},{"$f":"D222*60","v":228.62068965517241}]
[null,222,58,3.8275862068965516,229.65517241379308]
[null,223,58,3.8448275862068964,230.68965517241378]
[null,224,58,3.8620689655172415,231.72413793103451]
[null,225,58,3.8793103448275863,232.75862068965517]
[null,226,58,3.896551724137931,233.79310344827587]
[null,227,58,3.9137931034482758,234.82758620689654]
[null,228,58,3.9310344827586206,235.86206896551724]
[null,229,58,3.9482758620689653,236.89655172413791]
[null,230,58,3.9655172413793105,237.93103448275863]
[null,231,58,3.9827586206896552,238.9655172413793]