{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Input","Processing","Output"],"not_rendered":{"charts":0,"images":13,"macros":1,"external_links":0,"defined_names":2,"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":"Input","index":0,"n_rows":25,"n_cols":91,"rows_kept":25,"cut":false,"hidden":false,"merged":[[6,59,6,66],[2,14,2,76],[4,69,4,87],[6,70,6,86],[2,77,2,87],[4,2,4,20],[4,22,4,67],[4,90,4,100],[16,70,16,86],[15,14,15,19],[16,23,16,30],[7,14,7,19],[16,32,16,39],[16,41,16,48],[16,59,16,66],[8,59,8,66],[8,70,8,86],[10,70,10,86],[12,70,12,86],[14,70,14,86],[8,23,8,30],[8,32,8,39],[8,41,8,48],[10,23,10,30],[5,14,5,19],[8,3,8,12],[10,3,10,12],[12,3,12,12],[14,3,14,12],[6,3,6,12],[2,2,2,12],[17,44,17,53],[9,14,9,19],[16,3,16,8],[12,41,12,48],[14,23,14,30],[14,32,14,39],[14,41,14,48],[8,14,8,19],[10,14,10,19],[12,14,12,19],[14,14,14,19],[10,32,10,39],[10,41,10,48],[12,23,12,30],[12,32,12,39],[6,50,6,57],[8,50,8,57],[20,2,20,7],[21,2,21,7],[22,2,22,7],[20,8,20,16],[21,8,21,16],[22,8,22,16],[19,2,19,7],[6,14,6,19],[11,14,11,19],[13,14,13,19],[16,10,16,19],[32,2,32,7],[43,2,43,7],[44,2,44,7],[45,2,45,7],[46,2,46,7],[47,2,47,7],[38,2,38,7],[39,2,39,7],[40,2,40,7],[41,2,41,7],[42,2,42,7],[23,2,23,7],[24,2,24,7],[25,2,25,7],[24,8,24,16],[25,8,25,16],[26,8,26,16],[27,8,27,16],[28,8,28,16],[48,2,48,7],[29,8,29,16],[30,8,30,16],[31,8,31,16],[32,8,32,16],[33,8,33,16],[23,8,23,16],[33,2,33,7],[34,2,34,7],[35,2,35,7],[36,2,36,7],[37,2,37,7],[28,2,28,7],[29,2,29,7],[30,2,30,7],[31,2,31,7],[49,2,49,7],[50,2,50,7],[51,2,51,7],[26,2,26,7],[27,2,27,7],[19,8,19,16],[20,17,20,29],[21,17,21,29],[22,17,22,29],[19,17,19,29],[23,17,23,29],[24,17,24,29],[44,8,44,16],[45,8,45,16],[39,8,39,16],[40,8,40,16],[41,8,41,16],[42,8,42,16],[43,8,43,16],[34,8,34,16],[35,8,35,16],[36,8,36,16],[37,8,37,16],[38,8,38,16],[25,17,25,29],[26,17,26,29],[27,17,27,29],[28,17,28,29],[29,17,29,29],[49,8,49,16],[50,8,50,16],[51,8,51,16],[46,8,46,16],[47,8,47,16],[48,8,48,16],[50,17,50,29],[51,17,51,29],[45,17,45,29],[46,17,46,29],[47,17,47,29],[48,17,48,29],[49,17,49,29],[40,17,40,29],[41,17,41,29],[42,17,42,29],[43,17,43,29],[44,17,44,29],[35,17,35,29],[36,17,36,29],[37,17,37,29],[38,17,38,29],[39,17,39,29],[30,17,30,29],[31,17,31,29],[32,17,32,29],[33,17,33,29],[34,17,34,29],[19,30,19,57],[20,30,20,57],[21,30,21,57],[31,30,31,57],[32,30,32,57],[33,30,33,57],[34,30,34,57],[35,30,35,57],[36,30,36,57],[22,30,22,57],[23,30,23,57],[24,30,24,57],[25,30,25,57],[26,30,26,57],[27,30,27,57],[28,30,28,57],[29,30,29,57],[30,30,30,57],[46,30,46,57],[47,30,47,57],[48,30,48,57],[49,30,49,57],[50,30,50,57],[51,30,51,57],[24,58,24,67],[25,58,25,67],[26,58,26,67],[27,58,27,67],[28,58,28,67],[49,58,49,67],[50,58,50,67],[51,58,51,67],[37,30,37,57],[38,30,38,57],[39,30,39,57],[40,30,40,57],[41,30,41,57],[42,30,42,57],[43,30,43,57],[44,30,44,57],[45,30,45,57],[44,58,44,67],[20,58,20,67],[19,58,19,67],[21,58,21,67],[22,58,22,67],[23,58,23,67],[42,58,42,67],[43,58,43,67],[34,58,34,67],[35,58,35,67],[36,58,36,67],[37,58,37,67],[38,58,38,67],[29,58,29,67],[30,58,30,67],[31,58,31,67],[32,58,32,67],[33,58,33,67],[19,68,19,77],[20,68,20,77],[21,68,21,77],[22,68,22,77],[23,68,23,77],[24,68,24,77],[25,68,25,77],[26,68,26,77],[27,68,27,77],[28,68,28,77],[29,68,29,77],[30,68,30,77],[31,68,31,77],[49,78,49,87],[50,78,50,87],[45,58,45,67],[46,58,46,67],[47,58,47,67],[48,58,48,67],[39,58,39,67],[40,58,40,67],[41,58,41,67],[32,68,32,77],[33,68,33,77],[34,68,34,77],[35,68,35,77],[36,68,36,77],[43,78,43,87],[34,78,34,87],[35,78,35,87],[36,78,36,87],[51,68,51,77],[42,68,42,77],[43,68,43,77],[44,68,44,77],[45,68,45,77],[46,68,46,77],[37,68,37,77],[38,68,38,77],[39,68,39,77],[40,68,40,77],[41,68,41,77],[49,68,49,77],[50,68,50,77],[47,68,47,77],[48,68,48,77],[21,78,21,87],[22,78,22,87],[23,78,23,87],[29,78,29,87],[30,78,30,87],[31,78,31,87],[24,78,24,87],[25,78,25,87],[26,78,26,87],[27,78,27,87],[28,78,28,87],[10,50,10,57],[12,50,12,57],[16,50,16,57],[14,50,14,57],[51,78,51,87],[6,23,6,30],[6,32,6,39],[6,41,6,48],[14,59,14,66],[44,78,44,87],[45,78,45,87],[46,78,46,87],[47,78,47,87],[48,78,48,87],[39,78,39,87],[40,78,40,87],[41,78,41,87],[42,78,42,87],[37,78,37,87],[38,78,38,87],[32,78,32,87],[33,78,33,87],[19,78,19,87],[20,78,20,87]]}
[]
[]
[null,null,"Form TD-21",null,null,null,null,null,null,null,null,null,null,null,"NC Public School Transportation - Inventory Receipt Report",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,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,"Revised 09-12-19 csw"]
[]
[null,null,"Invoice Detail:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Computation Detail",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BSIP Detail",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Functions"]
[]
[null,null,null,"Invoice #",null,null,null,null,null,null,null,null,null,null,"Date",null,null,null,null,null,null,null,null,"Tax",null,null,null,null,null,null,null,null,"Freight",null,null,null,null,null,null,null,null,"Addl Costs",null,null,null,null,null,null,null,null,"Invoice Total",null,null,null,null,null,null,null,null,"Distribute Freight",null,null,null,null,null,null,null,null,null,null,"Purchase Order #"]
[]
[null,null,null,1530990865,null,null,null,null,null,null,null,null,null,null,"2019-03-26",null,null,null,null,null,null,null,null,7.71,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,121.88,null,null,null,null,null,null,null,null,"by % of",null,null,null,null,null,null,null,null,null,null,4500801832]
[]
[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,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,null,null,null,null,null,null,"Material Doc.  #"]
[]
[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,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,null,null,null,null,null,null,5005531931]
[]
[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,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,"Total Items",null,null,null,null,null,null,null,null,null,null,"Posting Date:"]
[]
[null,null,null,"Vendor:",null,null,null,null,null,null,"Parts City",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(X9,X11,X13,X15)","v":7.71},null,null,null,null,null,null,null,null,{"$f":"SUM(AG9,AG11,AG13,AG15)","v":1},null,null,null,null,null,null,null,null,{"$f":"SUM(AP9,AP11,AP13,AP15)","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(AY9,AY11,AY13,AY15)","v":121.88},null,null,null,null,null,null,null,null,{"$f":"SUM(C21:H52)","v":7},null,null,null,null,null,null,null,null,null,null,"2019-08-25"]
[]
[]
[null,null,"Qty",null,null,null,null,null,"DOT\nNumber",null,null,null,null,null,null,null,null,"Mfg. Part #",null,null,null,null,null,null,null,null,null,null,null,null,"Description",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,"Storage Bin Local",null,null,null,null,null,null,null,null,null,"Unit Price",null,null,null,null,null,null,null,null,null,"Total"]
[null,null,2,null,null,null,null,null,"EEA022069",null,null,null,null,null,null,null,null,"Wix 57182",null,null,null,null,null,null,null,null,null,null,null,null,"Oil Filter",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,"Filter Bin A-1",null,null,null,null,null,null,null,null,null,9.52]
[null,null,2,null,null,null,null,null,"EEA044406",null,null,null,null,null,null,null,null,"Wix 33630",null,null,null,null,null,null,null,null,null,null,null,null,"Fuel Filter",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,"Filter Bin A-2",null,null,null,null,null,null,null,null,null,24.96]
[null,null,1,null,null,null,null,null,"EEA015953",null,null,null,null,null,null,null,null,"Wix 57701",null,null,null,null,null,null,null,null,null,null,null,null,"Trans Filer",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,"Filter Bin A-3",null,null,null,null,null,null,null,null,null,14.01]
[null,null,1,null,null,null,null,null,"EEA012607",null,null,null,null,null,null,null,null,"Wix 57191",null,null,null,null,null,null,null,null,null,null,null,null,"P/S Filter",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,"Filter Bin A-4",null,null,null,null,null,null,null,null,null,15.29]
[null,null,1,null,null,null,null,null,"EEA015300",null,null,null,null,null,null,null,null,"Wix 33966",null,null,null,null,null,null,null,null,null,null,null,null,"Fuel Filter",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,"Filter Bin A-5",null,null,null,null,null,null,null,null,null,15.91]

{"sheet":"Processing","index":1,"n_rows":38,"n_cols":12,"rows_kept":38,"cut":false,"hidden":true,"merged":[[1,4,2,4],[1,5,2,5],[1,9,1,10],[36,4,36,5],[37,4,37,5]]}
[null,"                 THIS FORM WILL BE THE SOURCE TO KEY INVENTORY RECEIPTS USING FUNCTION ME21N"]
[null,null,null,null,"Assigned Freight and Other Costs [By %Cost]","Assigned Freight and Other Costs [By %Quantity]",null,null,null,"Extra Penny Check"]
["Quantity","Unit Price","Total","Assigned Taxes",null,null,"New Line Item Total","Unit Price Check","Total Check","Added Fraction","Round","Final Line Item Price"]
[{"$f":"IF(Input!C21=0,0,Input!C21)","v":2},{"$f":"IF(Input!C21+Input!BQ21+Input!CA21>0,IF(Input!BQ21=0,Input!CA21/Input!C21,Input!BQ21),\"\")","v":9.52},{"$f":"IF(Input!C21+Input!BQ21+Input!CA21>0,IF(Input!CA21=0,Input!BQ21*Input!C21,Input!CA21),\"\")","v":19.04},{"$f":"IF(Input!C21=0,\"\",Input!$X$17*C4/SUM($C$4:$C$35))","v":1.2857878602084607},{"$f":"IF($E$38<2,IF(Input!C21=0,\"\",(Input!$AG$17+Input!$AP$17)*(C4/SUM($C$4:$C$35))),\"\")","v":0.16676885346413239},{"$f":"IF($E$38=2,IF(Input!C21=0,\"\",Input!$AG$17*A4/SUM($A$4:$A$35)),\"\")","v":""},{"$f":"IF(Input!C21=0,\"\",SUM(C4:F4))","v":20.492556713672592},{"$f":"IF(Input!C21=0,\"\",ROUND(G4/A4,2))","v":10.25},{"$f":"IF(Input!C21=0,\"\",H4*A4)","v":20.5},null,{"$f":"ROUND(J4,2)","v":0},{"$f":"IF(Input!C21=0,\"\",(H4+K4)*A4)","v":20.5}]
[{"$f":"IF(Input!C22=0,0,Input!C22)","v":2},{"$f":"IF(Input!C22+Input!BQ22+Input!CA22>0,IF(Input!BQ22=0,Input!CA22/Input!C22,Input!BQ22),\"\")","v":24.96},{"$f":"IF(Input!C22+Input!BQ22+Input!CA22>0,IF(Input!CA22=0,Input!BQ22*Input!C22,Input!CA22),\"\")","v":49.92},{"$f":"IF(Input!C22=0,\"\",Input!$X$17*C5/SUM($C$4:$C$35))","v":3.3711412805465528},{"$f":"IF($E$38<2,IF(Input!C22=0,\"\",(Input!$AG$17+Input!$AP$17)*(C5/SUM($C$4:$C$35))),\"\")","v":0.4372427082420951},{"$f":"IF($E$38=2,IF(Input!C22=0,\"\",Input!$AG$17*A5/SUM($A$4:$A$35)),\"\")","v":""},{"$f":"IF(Input!C22=0,\"\",SUM(C5:F5))","v":53.72838398878865},{"$f":"IF(Input!C22=0,\"\",ROUND(G5/A5,2))","v":26.86},{"$f":"IF(Input!C22=0,\"\",H5*A5)","v":53.72},null,{"$f":"ROUND(J5,2)","v":0},{"$f":"IF(Input!C22=0,\"\",(H5+K5)*A5)","v":53.72}]
[{"$f":"IF(Input!C23=0,0,Input!C23)","v":1},{"$f":"IF(Input!C23+Input!BQ23+Input!CA23>0,IF(Input!BQ23=0,Input!CA23/Input!C23,Input!BQ23),\"\")","v":14.01},{"$f":"IF(Input!C23+Input!BQ23+Input!CA23>0,IF(Input!CA23=0,Input!BQ23*Input!C23,Input!CA23),\"\")","v":14.01},{"$f":"IF(Input!C23=0,\"\",Input!$X$17*C6/SUM($C$4:$C$35))","v":0.94610755890338949},{"$f":"IF($E$38<2,IF(Input!C23=0,\"\",(Input!$AG$17+Input!$AP$17)*(C6/SUM($C$4:$C$35))),\"\")","v":0.12271174564246297},{"$f":"IF($E$38=2,IF(Input!C23=0,\"\",Input!$AG$17*A6/SUM($A$4:$A$35)),\"\")","v":""},{"$f":"IF(Input!C23=0,\"\",SUM(C6:F6))","v":15.078819304545851},{"$f":"IF(Input!C23=0,\"\",ROUND(G6/A6,2))","v":15.08},{"$f":"IF(Input!C23=0,\"\",H6*A6)","v":15.08},null,0,{"$f":"IF(Input!C23=0,\"\",(H6+K6)*A6)","v":15.08}]
[{"$f":"IF(Input!C24=0,0,Input!C24)","v":1},{"$f":"IF(Input!C24+Input!BQ24+Input!CA24>0,IF(Input!BQ24=0,Input!CA24/Input!C24,Input!BQ24),\"\")","v":15.29},{"$f":"IF(Input!C24+Input!BQ24+Input!CA24>0,IF(Input!CA24=0,Input!BQ24*Input!C24,Input!CA24),\"\")","v":15.29},{"$f":"IF(Input!C24=0,\"\",Input!$X$17*C7/SUM($C$4:$C$35))","v":1.0325470789174036},{"$f":"IF($E$38<2,IF(Input!C24=0,\"\",(Input!$AG$17+Input!$AP$17)*(C7/SUM($C$4:$C$35))),\"\")","v":0.13392309713585002},{"$f":"IF($E$38=2,IF(Input!C24=0,\"\",Input!$AG$17*A7/SUM($A$4:$A$35)),\"\")","v":""},{"$f":"IF(Input!C24=0,\"\",SUM(C7:F7))","v":16.456470176053251},{"$f":"IF(Input!C24=0,\"\",ROUND(G7/A7,2))","v":16.46},{"$f":"IF(Input!C24=0,\"\",H7*A7)","v":16.46},null,0,{"$f":"IF(Input!C24=0,\"\",(H7+K7)*A7)","v":16.46}]
[{"$f":"IF(Input!C25=0,0,Input!C25)","v":1},{"$f":"IF(Input!C25+Input!BQ25+Input!CA25>0,IF(Input!BQ25=0,Input!CA25/Input!C25,Input!BQ25),\"\")","v":15.91},{"$f":"IF(Input!C25+Input!BQ25+Input!CA25>0,IF(Input!CA25=0,Input!BQ25*Input!C25,Input!CA25),\"\")","v":15.91},{"$f":"IF(Input!C25=0,\"\",Input!$X$17*C8/SUM($C$4:$C$35))","v":1.0744162214241919},{"$f":"IF($E$38<2,IF(Input!C25=0,\"\",(Input!$AG$17+Input!$AP$17)*(C8/SUM($C$4:$C$35))),\"\")","v":0.13935359551545939},{"$f":"IF($E$38=2,IF(Input!C25=0,\"\",Input!$AG$17*A8/SUM($A$4:$A$35)),\"\")","v":""},{"$f":"IF(Input!C25=0,\"\",SUM(C8:F8))","v":17.12376981693965},{"$f":"IF(Input!C25=0,\"\",ROUND(G8/A8,2))","v":17.12},{"$f":"IF(Input!C25=0,\"\",H8*A8)","v":17.12},null,0,{"$f":"IF(Input!C25=0,\"\",(H8+K8)*A8)","v":17.12}]
[{"$f":"IF(Input!C26=0,0,Input!C26)","v":0},{"$f":"IF(Input!C26+Input!BQ26+Input!CA26>0,IF(Input!BQ26=0,Input!CA26/Input!C26,Input!BQ26),\"\")","v":""},{"$f":"IF(Input!C26+Input!BQ26+Input!CA26>0,IF(Input!CA26=0,Input!BQ26*Input!C26,Input!CA26),\"\")","v":""},{"$f":"IF(Input!C26=0,\"\",Input!$X$17*C9/SUM($C$4:$C$35))","v":""},{"$f":"IF($E$38<2,IF(Input!C26=0,\"\",(Input!$AG$17+Input!$AP$17)*(C9/SUM($C$4:$C$35))),\"\")","v":""},{"$f":"IF($E$38=2,IF(Input!C26=0,\"\",Input!$AG$17*A9/SUM($A$4:$A$35)),\"\")","v":""},{"$f":"IF(Input!C26=0,\"\",SUM(C9:F9))","v":""},{"$f":"IF(Input!C26=0,\"\",ROUND(G9/A9,2))","v":""},{"$f":"IF(Input!C26=0,\"\",H9*A9)","v":""},null,0,{"$f":"IF(Input!C26=0,\"\",(H9+K9)*A9)","v":""}]
[{"$f":"IF(Input!C27=0,0,Input!C27)","v":0},{"$f":"IF(Input!C27+Input!BQ27+Input!CA27>0,IF(Input!BQ27=0,Input!CA27/Input!C27,Input!BQ27),\"\")","v":""},{"$f":"IF(Input!C27+Input!BQ27+Input!CA27>0,IF(Input!CA27=0,Input!BQ27*Input!C27,Input!CA27),\"\")","v":""},{"$f":"IF(Input!C27=0,\"\",Input!$X$17*C10/SUM($C$4:$C$35))","v":""},{"$f":"IF($E$38<2,IF(Input!C27=0,\"\",(Input!$AG$17+Input!$AP$17)*(C10/SUM($C$4:$C$35))),\"\")","v":""},{"$f":"IF($E$38=2,IF(Input!C27=0,\"\",Input!$AG$17*A10/SUM($A$4:$A$35)),\"\")","v":""},{"$f":"IF(Input!C27=0,\"\",SUM(C10:F10))","v":""},{"$f":"IF(Input!C27=0,\"\",ROUND(G10/A10,2))","v":""},{"$f":"IF(Input!C27=0,\"\",H10*A10)","v":""},null,0,{"$f":"IF(Input!C27=0,\"\",(H10+K10)*A10)","v":""}]
[{"$f":"IF(Input!C28=0,0,Input!C28)","v":0},{"$f":"IF(Input!C28+Input!BQ28+Input!CA28>0,IF(Input!BQ28=0,Input!CA28/Input!C28,Input!BQ28),\"\")","v":""},{"$f":"IF(Input!C28+Input!BQ28+Input!CA28>0,IF(Input!CA28=0,Input!BQ28*Input!C28,Input!CA28),\"\")","v":""},{"$f":"IF(Input!C28=0,\"\",Input!$X$17*C11/SUM($C$4:$C$35))","v":""},{"$f":"IF($E$38<2,IF(Input!C28=0,\"\",(Input!$AG$17+Input!$AP$17)*(C11/SUM($C$4:$C$35))),\"\")","v":""},{"$f":"IF($E$38=2,IF(Input!C28=0,\"\",Input!$AG$17*A11/SUM($A$4:$A$35)),\"\")","v":""},{"$f":"IF(Input!C28=0,\"\",SUM(C11:F11))","v":""},{"$f":"IF(Input!C28=0,\"\",ROUND(G11/A11,2))","v":""},{"$f":"IF(Input!C28=0,\"\",H11*A11)","v":""},null,0,{"$f":"IF(Input!C28=0,\"\",(H11+K11)*A11)","v":""}]
[{"$f":"IF(Input!C29=0,0,Input!C29)","v":0},{"$f":"IF(Input!C29+Input!BQ29+Input!CA29>0,IF(Input!BQ29=0,Input!CA29/Input!C29,Input!BQ29),\"\")","v":""},{"$f":"IF(Input!C29+Input!BQ29+Input!CA29>0,IF(Input!CA29=0,Input!BQ29*Input!C29,Input!CA29),\"\")","v":""},{"$f":"IF(Input!C29=0,\"\",Input!$X$17*C12/SUM($C$4:$C$35))","v":""},{"$f":"IF($E$38<2,IF(Input!C29=0,\"\",(Input!$AG$17+Input!$AP$17)*(C12/SUM($C$4:$C$35))),\"\")","v":""},{"$f":"IF($E$38=2,IF(Input!C29=0,\"\",Input!$AG$17*A12/SUM($A$4:$A$35)),\"\")","v":""},{"$f":"IF(Input!C29=0,\"\",SUM(C12:F12))","v":""},{"$f":"IF(Input!C29=0,\"\",ROUND(G12/A12,2))","v":""},{"$f":"IF(Input!C29=0,\"\",H12*A12)","v":""},null,0,{"$f":"IF(Input!C29=0,\"\",(H12+K12)*A12)","v":""}]
[{"$f":"IF(Input!C30=0,0,Input!C30)","v":0},{"$f":"IF(Input!C30+Input!BQ30+Input!CA30>0,IF(Input!BQ30=0,Input!CA30/Input!C30,Input!BQ30),\"\")","v":""},{"$f":"IF(Input!C30+Input!BQ30+Input!CA30>0,IF(Input!CA30=0,Input!BQ30*Input!C30,Input!CA30),\"\")","v":""},{"$f":"IF(Input!C30=0,\"\",Input!$X$17*C13/SUM($C$4:$C$35))","v":""},{"$f":"IF($E$38<2,IF(Input!C30=0,\"\",(Input!$AG$17+Input!$AP$17)*(C13/SUM($C$4:$C$35))),\"\")","v":""},{"$f":"IF($E$38=2,IF(Input!C30=0,\"\",Input!$AG$17*A13/SUM($A$4:$A$35)),\"\")","v":""},{"$f":"IF(Input!C30=0,\"\",SUM(C13:F13))","v":""},{"$f":"IF(Input!C30=0,\"\",ROUND(G13/A13,2))","v":""},{"$f":"IF(Input!C30=0,\"\",H13*A13)","v":""},null,0,{"$f":"IF(Input!C30=0,\"\",(H13+K13)*A13)","v":""}]
[{"$f":"IF(Input!C31=0,0,Input!C31)","v":0},{"$f":"IF(Input!C31+Input!BQ31+Input!CA31>0,IF(Input!BQ31=0,Input!CA31/Input!C31,Input!BQ31),\"\")","v":""},{"$f":"IF(Input!C31+Input!BQ31+Input!CA31>0,IF(Input!CA31=0,Input!BQ31*Input!C31,Input!CA31),\"\")","v":""},{"$f":"IF(Input!C31=0,\"\",Input!$X$17*C14/SUM($C$4:$C$35))","v":""},{"$f":"IF($E$38<2,IF(Input!C31=0,\"\",(Input!$AG$17+Input!$AP$17)*(C14/SUM($C$4:$C$35))),\"\")","v":""},{"$f":"IF($E$38=2,IF(Input!C31=0,\"\",Input!$AG$17*A14/SUM($A$4:$A$35)),\"\")","v":""},{"$f":"IF(Input!C31=0,\"\",SUM(C14:F14))","v":""},{"$f":"IF(Input!C31=0,\"\",ROUND(G14/A14,2))","v":""},{"$f":"IF(Input!C31=0,\"\",H14*A14)","v":""},null,0,{"$f":"IF(Input!C31=0,\"\",(H14+K14)*A14)","v":""}]
[{"$f":"IF(Input!C32=0,0,Input!C32)","v":0},{"$f":"IF(Input!C32+Input!BQ32+Input!CA32>0,IF(Input!BQ32=0,Input!CA32/Input!C32,Input!BQ32),\"\")","v":""},{"$f":"IF(Input!C32+Input!BQ32+Input!CA32>0,IF(Input!CA32=0,Input!BQ32*Input!C32,Input!CA32),\"\")","v":""},{"$f":"IF(Input!C32=0,\"\",Input!$X$17*C15/SUM($C$4:$C$35))","v":""},{"$f":"IF($E$38<2,IF(Input!C32=0,\"\",(Input!$AG$17+Input!$AP$17)*(C15/SUM($C$4:$C$35))),\"\")","v":""},{"$f":"IF($E$38=2,IF(Input!C32=0,\"\",Input!$AG$17*A15/SUM($A$4:$A$35)),\"\")","v":""},{"$f":"IF(Input!C32=0,\"\",SUM(C15:F15))","v":""},{"$f":"IF(Input!C32=0,\"\",ROUND(G15/A15,2))","v":""},{"$f":"IF(Input!C32=0,\"\",H15*A15)","v":""},null,0,{"$f":"IF(Input!C32=0,\"\",(H15+K15)*A15)","v":""}]
[{"$f":"IF(Input!C33=0,0,Input!C33)","v":0},{"$f":"IF(Input!C33+Input!BQ33+Input!CA33>0,IF(Input!BQ33=0,Input!CA33/Input!C33,Input!BQ33),\"\")","v":""},{"$f":"IF(Input!C33+Input!BQ33+Input!CA33>0,IF(Input!CA33=0,Input!BQ33*Input!C33,Input!CA33),\"\")","v":""},{"$f":"IF(Input!C33=0,\"\",Input!$X$17*C16/SUM($C$4:$C$35))","v":""},{"$f":"IF($E$38<2,IF(Input!C33=0,\"\",(Input!$AG$17+Input!$AP$17)*(C16/SUM($C$4:$C$35))),\"\")","v":""},{"$f":"IF($E$38=2,IF(Input!C33=0,\"\",Input!$AG$17*A16/SUM($A$4:$A$35)),\"\")","v":""},{"$f":"IF(Input!C33=0,\"\",SUM(C16:F16))","v":""},{"$f":"IF(Input!C33=0,\"\",ROUND(G16/A16,2))","v":""},{"$f":"IF(Input!C33=0,\"\",H16*A16)","v":""},null,0,{"$f":"IF(Input!C33=0,\"\",(H16+K16)*A16)","v":""}]
[{"$f":"IF(Input!C34=0,0,Input!C34)","v":0},{"$f":"IF(Input!C34+Input!BQ34+Input!CA34>0,IF(Input!BQ34=0,Input!CA34/Input!C34,Input!BQ34),\"\")","v":""},{"$f":"IF(Input!C34+Input!BQ34+Input!CA34>0,IF(Input!CA34=0,Input!BQ34*Input!C34,Input!CA34),\"\")","v":""},{"$f":"IF(Input!C34=0,\"\",Input!$X$17*C17/SUM($C$4:$C$35))","v":""},{"$f":"IF($E$38<2,IF(Input!C34=0,\"\",(Input!$AG$17+Input!$AP$17)*(C17/SUM($C$4:$C$35))),\"\")","v":""},{"$f":"IF($E$38=2,IF(Input!C34=0,\"\",Input!$AG$17*A17/SUM($A$4:$A$35)),\"\")","v":""},{"$f":"IF(Input!C34=0,\"\",SUM(C17:F17))","v":""},{"$f":"IF(Input!C34=0,\"\",ROUND(G17/A17,2))","v":""},{"$f":"IF(Input!C34=0,\"\",H17*A17)","v":""},null,0,{"$f":"IF(Input!C34=0,\"\",(H17+K17)*A17)","v":""}]
[{"$f":"IF(Input!C35=0,0,Input!C35)","v":0},{"$f":"IF(Input!C35+Input!BQ35+Input!CA35>0,IF(Input!BQ35=0,Input!CA35/Input!C35,Input!BQ35),\"\")","v":""},{"$f":"IF(Input!C35+Input!BQ35+Input!CA35>0,IF(Input!CA35=0,Input!BQ35*Input!C35,Input!CA35),\"\")","v":""},{"$f":"IF(Input!C35=0,\"\",Input!$X$17*C18/SUM($C$4:$C$35))","v":""},{"$f":"IF($E$38<2,IF(Input!C35=0,\"\",(Input!$AG$17+Input!$AP$17)*(C18/SUM($C$4:$C$35))),\"\")","v":""},{"$f":"IF($E$38=2,IF(Input!C35=0,\"\",Input!$AG$17*A18/SUM($A$4:$A$35)),\"\")","v":""},{"$f":"IF(Input!C35=0,\"\",SUM(C18:F18))","v":""},{"$f":"IF(Input!C35=0,\"\",ROUND(G18/A18,2))","v":""},{"$f":"IF(Input!C35=0,\"\",H18*A18)","v":""},null,0,{"$f":"IF(Input!C35=0,\"\",(H18+K18)*A18)","v":""}]
[{"$f":"IF(Input!C36=0,0,Input!C36)","v":0},{"$f":"IF(Input!C36+Input!BQ36+Input!CA36>0,IF(Input!BQ36=0,Input!CA36/Input!C36,Input!BQ36),\"\")","v":""},{"$f":"IF(Input!C36+Input!BQ36+Input!CA36>0,IF(Input!CA36=0,Input!BQ36*Input!C36,Input!CA36),\"\")","v":""},{"$f":"IF(Input!C36=0,\"\",Input!$X$17*C19/SUM($C$4:$C$35))","v":""},{"$f":"IF($E$38<2,IF(Input!C36=0,\"\",(Input!$AG$17+Input!$AP$17)*(C19/SUM($C$4:$C$35))),\"\")","v":""},{"$f":"IF($E$38=2,IF(Input!C36=0,\"\",Input!$AG$17*A19/SUM($A$4:$A$35)),\"\")","v":""},{"$f":"IF(Input!C36=0,\"\",SUM(C19:F19))","v":""},{"$f":"IF(Input!C36=0,\"\",ROUND(G19/A19,2))","v":""},{"$f":"IF(Input!C36=0,\"\",H19*A19)","v":""},null,0,{"$f":"IF(Input!C36=0,\"\",(H19+K19)*A19)","v":""}]
[{"$f":"IF(Input!C37=0,0,Input!C37)","v":0},{"$f":"IF(Input!C37+Input!BQ37+Input!CA37>0,IF(Input!BQ37=0,Input!CA37/Input!C37,Input!BQ37),\"\")","v":""},{"$f":"IF(Input!C37+Input!BQ37+Input!CA37>0,IF(Input!CA37=0,Input!BQ37*Input!C37,Input!CA37),\"\")","v":""},{"$f":"IF(Input!C37=0,\"\",Input!$X$17*C20/SUM($C$4:$C$35))","v":""},{"$f":"IF($E$38<2,IF(Input!C37=0,\"\",(Input!$AG$17+Input!$AP$17)*(C20/SUM($C$4:$C$35))),\"\")","v":""},{"$f":"IF($E$38=2,IF(Input!C37=0,\"\",Input!$AG$17*A20/SUM($A$4:$A$35)),\"\")","v":""},{"$f":"IF(Input!C37=0,\"\",SUM(C20:F20))","v":""},{"$f":"IF(Input!C37=0,\"\",ROUND(G20/A20,2))","v":""},{"$f":"IF(Input!C37=0,\"\",H20*A20)","v":""},null,0,{"$f":"IF(Input!C37=0,\"\",(H20+K20)*A20)","v":""}]
[{"$f":"IF(Input!C38=0,0,Input!C38)","v":0},{"$f":"IF(Input!C38+Input!BQ38+Input!CA38>0,IF(Input!BQ38=0,Input!CA38/Input!C38,Input!BQ38),\"\")","v":""},{"$f":"IF(Input!C38+Input!BQ38+Input!CA38>0,IF(Input!CA38=0,Input!BQ38*Input!C38,Input!CA38),\"\")","v":""},{"$f":"IF(Input!C38=0,\"\",Input!$X$17*C21/SUM($C$4:$C$35))","v":""},{"$f":"IF($E$38<2,IF(Input!C38=0,\"\",(Input!$AG$17+Input!$AP$17)*(C21/SUM($C$4:$C$35))),\"\")","v":""},{"$f":"IF($E$38=2,IF(Input!C38=0,\"\",Input!$AG$17*A21/SUM($A$4:$A$35)),\"\")","v":""},{"$f":"IF(Input!C38=0,\"\",SUM(C21:F21))","v":""},{"$f":"IF(Input!C38=0,\"\",ROUND(G21/A21,2))","v":""},{"$f":"IF(Input!C38=0,\"\",H21*A21)","v":""},null,0,{"$f":"IF(Input!C38=0,\"\",(H21+K21)*A21)","v":""}]
[{"$f":"IF(Input!C39=0,0,Input!C39)","v":0},{"$f":"IF(Input!C39+Input!BQ39+Input!CA39>0,IF(Input!BQ39=0,Input!CA39/Input!C39,Input!BQ39),\"\")","v":""},{"$f":"IF(Input!C39+Input!BQ39+Input!CA39>0,IF(Input!CA39=0,Input!BQ39*Input!C39,Input!CA39),\"\")","v":""},{"$f":"IF(Input!C39=0,\"\",Input!$X$17*C22/SUM($C$4:$C$35))","v":""},{"$f":"IF($E$38<2,IF(Input!C39=0,\"\",(Input!$AG$17+Input!$AP$17)*(C22/SUM($C$4:$C$35))),\"\")","v":""},{"$f":"IF($E$38=2,IF(Input!C39=0,\"\",Input!$AG$17*A22/SUM($A$4:$A$35)),\"\")","v":""},{"$f":"IF(Input!C39=0,\"\",SUM(C22:F22))","v":""},{"$f":"IF(Input!C39=0,\"\",ROUND(G22/A22,2))","v":""},{"$f":"IF(Input!C39=0,\"\",H22*A22)","v":""},null,0,{"$f":"IF(Input!C39=0,\"\",(H22+K22)*A22)","v":""}]
[{"$f":"IF(Input!C40=0,0,Input!C40)","v":0},{"$f":"IF(Input!C40+Input!BQ40+Input!CA40>0,IF(Input!BQ40=0,Input!CA40/Input!C40,Input!BQ40),\"\")","v":""},{"$f":"IF(Input!C40+Input!BQ40+Input!CA40>0,IF(Input!CA40=0,Input!BQ40*Input!C40,Input!CA40),\"\")","v":""},{"$f":"IF(Input!C40=0,\"\",Input!$X$17*C23/SUM($C$4:$C$35))","v":""},{"$f":"IF($E$38<2,IF(Input!C40=0,\"\",(Input!$AG$17+Input!$AP$17)*(C23/SUM($C$4:$C$35))),\"\")","v":""},{"$f":"IF($E$38=2,IF(Input!C40=0,\"\",Input!$AG$17*A23/SUM($A$4:$A$35)),\"\")","v":""},{"$f":"IF(Input!C40=0,\"\",SUM(C23:F23))","v":""},{"$f":"IF(Input!C40=0,\"\",ROUND(G23/A23,2))","v":""},{"$f":"IF(Input!C40=0,\"\",H23*A23)","v":""},null,0,{"$f":"IF(Input!C40=0,\"\",(H23+K23)*A23)","v":""}]
[{"$f":"IF(Input!C41=0,0,Input!C41)","v":0},{"$f":"IF(Input!C41+Input!BQ41+Input!CA41>0,IF(Input!BQ41=0,Input!CA41/Input!C41,Input!BQ41),\"\")","v":""},{"$f":"IF(Input!C41+Input!BQ41+Input!CA41>0,IF(Input!CA41=0,Input!BQ41*Input!C41,Input!CA41),\"\")","v":""},{"$f":"IF(Input!C41=0,\"\",Input!$X$17*C24/SUM($C$4:$C$35))","v":""},{"$f":"IF($E$38<2,IF(Input!C41=0,\"\",(Input!$AG$17+Input!$AP$17)*(C24/SUM($C$4:$C$35))),\"\")","v":""},{"$f":"IF($E$38=2,IF(Input!C41=0,\"\",Input!$AG$17*A24/SUM($A$4:$A$35)),\"\")","v":""},{"$f":"IF(Input!C41=0,\"\",SUM(C24:F24))","v":""},{"$f":"IF(Input!C41=0,\"\",ROUND(G24/A24,2))","v":""},{"$f":"IF(Input!C41=0,\"\",H24*A24)","v":""},null,0,{"$f":"IF(Input!C41=0,\"\",(H24+K24)*A24)","v":""}]
[{"$f":"IF(Input!C42=0,0,Input!C42)","v":0},{"$f":"IF(Input!C42+Input!BQ42+Input!CA42>0,IF(Input!BQ42=0,Input!CA42/Input!C42,Input!BQ42),\"\")","v":""},{"$f":"IF(Input!C42+Input!BQ42+Input!CA42>0,IF(Input!CA42=0,Input!BQ42*Input!C42,Input!CA42),\"\")","v":""},{"$f":"IF(Input!C42=0,\"\",Input!$X$17*C25/SUM($C$4:$C$35))","v":""},{"$f":"IF($E$38<2,IF(Input!C42=0,\"\",(Input!$AG$17+Input!$AP$17)*(C25/SUM($C$4:$C$35))),\"\")","v":""},{"$f":"IF($E$38=2,IF(Input!C42=0,\"\",Input!$AG$17*A25/SUM($A$4:$A$35)),\"\")","v":""},{"$f":"IF(Input!C42=0,\"\",SUM(C25:F25))","v":""},{"$f":"IF(Input!C42=0,\"\",ROUND(G25/A25,2))","v":""},{"$f":"IF(Input!C42=0,\"\",H25*A25)","v":""},null,0,{"$f":"IF(Input!C42=0,\"\",(H25+K25)*A25)","v":""}]
[{"$f":"IF(Input!C43=0,0,Input!C43)","v":0},{"$f":"IF(Input!C43+Input!BQ43+Input!CA43>0,IF(Input!BQ43=0,Input!CA43/Input!C43,Input!BQ43),\"\")","v":""},{"$f":"IF(Input!C43+Input!BQ43+Input!CA43>0,IF(Input!CA43=0,Input!BQ43*Input!C43,Input!CA43),\"\")","v":""},{"$f":"IF(Input!C43=0,\"\",Input!$X$17*C26/SUM($C$4:$C$35))","v":""},{"$f":"IF($E$38<2,IF(Input!C43=0,\"\",(Input!$AG$17+Input!$AP$17)*(C26/SUM($C$4:$C$35))),\"\")","v":""},{"$f":"IF($E$38=2,IF(Input!C43=0,\"\",Input!$AG$17*A26/SUM($A$4:$A$35)),\"\")","v":""},{"$f":"IF(Input!C43=0,\"\",SUM(C26:F26))","v":""},{"$f":"IF(Input!C43=0,\"\",ROUND(G26/A26,2))","v":""},{"$f":"IF(Input!C43=0,\"\",H26*A26)","v":""},null,0,{"$f":"IF(Input!C43=0,\"\",(H26+K26)*A26)","v":""}]
[{"$f":"IF(Input!C44=0,0,Input!C44)","v":0},{"$f":"IF(Input!C44+Input!BQ44+Input!CA44>0,IF(Input!BQ44=0,Input!CA44/Input!C44,Input!BQ44),\"\")","v":""},{"$f":"IF(Input!C44+Input!BQ44+Input!CA44>0,IF(Input!CA44=0,Input!BQ44*Input!C44,Input!CA44),\"\")","v":""},{"$f":"IF(Input!C44=0,\"\",Input!$X$17*C27/SUM($C$4:$C$35))","v":""},{"$f":"IF($E$38<2,IF(Input!C44=0,\"\",(Input!$AG$17+Input!$AP$17)*(C27/SUM($C$4:$C$35))),\"\")","v":""},{"$f":"IF($E$38=2,IF(Input!C44=0,\"\",Input!$AG$17*A27/SUM($A$4:$A$35)),\"\")","v":""},{"$f":"IF(Input!C44=0,\"\",SUM(C27:F27))","v":""},{"$f":"IF(Input!C44=0,\"\",ROUND(G27/A27,2))","v":""},{"$f":"IF(Input!C44=0,\"\",H27*A27)","v":""},null,0,{"$f":"IF(Input!C44=0,\"\",(H27+K27)*A27)","v":""}]
[{"$f":"IF(Input!C45=0,0,Input!C45)","v":0},{"$f":"IF(Input!C45+Input!BQ45+Input!CA45>0,IF(Input!BQ45=0,Input!CA45/Input!C45,Input!BQ45),\"\")","v":""},{"$f":"IF(Input!C45+Input!BQ45+Input!CA45>0,IF(Input!CA45=0,Input!BQ45*Input!C45,Input!CA45),\"\")","v":""},{"$f":"IF(Input!C45=0,\"\",Input!$X$17*C28/SUM($C$4:$C$35))","v":""},{"$f":"IF($E$38<2,IF(Input!C45=0,\"\",(Input!$AG$17+Input!$AP$17)*(C28/SUM($C$4:$C$35))),\"\")","v":""},{"$f":"IF($E$38=2,IF(Input!C45=0,\"\",Input!$AG$17*A28/SUM($A$4:$A$35)),\"\")","v":""},{"$f":"IF(Input!C45=0,\"\",SUM(C28:F28))","v":""},{"$f":"IF(Input!C45=0,\"\",ROUND(G28/A28,2))","v":""},{"$f":"IF(Input!C45=0,\"\",H28*A28)","v":""},null,0,{"$f":"IF(Input!C45=0,\"\",(H28+K28)*A28)","v":""}]
[{"$f":"IF(Input!C46=0,0,Input!C46)","v":0},{"$f":"IF(Input!C46+Input!BQ46+Input!CA46>0,IF(Input!BQ46=0,Input!CA46/Input!C46,Input!BQ46),\"\")","v":""},{"$f":"IF(Input!C46+Input!BQ46+Input!CA46>0,IF(Input!CA46=0,Input!BQ46*Input!C46,Input!CA46),\"\")","v":""},{"$f":"IF(Input!C46=0,\"\",Input!$X$17*C29/SUM($C$4:$C$35))","v":""},{"$f":"IF($E$38<2,IF(Input!C46=0,\"\",(Input!$AG$17+Input!$AP$17)*(C29/SUM($C$4:$C$35))),\"\")","v":""},{"$f":"IF($E$38=2,IF(Input!C46=0,\"\",Input!$AG$17*A29/SUM($A$4:$A$35)),\"\")","v":""},{"$f":"IF(Input!C46=0,\"\",SUM(C29:F29))","v":""},{"$f":"IF(Input!C46=0,\"\",ROUND(G29/A29,2))","v":""},{"$f":"IF(Input!C46=0,\"\",H29*A29)","v":""},null,0,{"$f":"IF(Input!C46=0,\"\",(H29+K29)*A29)","v":""}]
[{"$f":"IF(Input!C47=0,0,Input!C47)","v":0},{"$f":"IF(Input!C47+Input!BQ47+Input!CA47>0,IF(Input!BQ47=0,Input!CA47/Input!C47,Input!BQ47),\"\")","v":""},{"$f":"IF(Input!C47+Input!BQ47+Input!CA47>0,IF(Input!CA47=0,Input!BQ47*Input!C47,Input!CA47),\"\")","v":""},{"$f":"IF(Input!C47=0,\"\",Input!$X$17*C30/SUM($C$4:$C$35))","v":""},{"$f":"IF($E$38<2,IF(Input!C47=0,\"\",(Input!$AG$17+Input!$AP$17)*(C30/SUM($C$4:$C$35))),\"\")","v":""},{"$f":"IF($E$38=2,IF(Input!C47=0,\"\",Input!$AG$17*A30/SUM($A$4:$A$35)),\"\")","v":""},{"$f":"IF(Input!C47=0,\"\",SUM(C30:F30))","v":""},{"$f":"IF(Input!C47=0,\"\",ROUND(G30/A30,2))","v":""},{"$f":"IF(Input!C47=0,\"\",H30*A30)","v":""},null,0,{"$f":"IF(Input!C47=0,\"\",(H30+K30)*A30)","v":""}]
[{"$f":"IF(Input!C48=0,0,Input!C48)","v":0},{"$f":"IF(Input!C48+Input!BQ48+Input!CA48>0,IF(Input!BQ48=0,Input!CA48/Input!C48,Input!BQ48),\"\")","v":""},{"$f":"IF(Input!C48+Input!BQ48+Input!CA48>0,IF(Input!CA48=0,Input!BQ48*Input!C48,Input!CA48),\"\")","v":""},{"$f":"IF(Input!C48=0,\"\",Input!$X$17*C31/SUM($C$4:$C$35))","v":""},{"$f":"IF($E$38<2,IF(Input!C48=0,\"\",(Input!$AG$17+Input!$AP$17)*(C31/SUM($C$4:$C$35))),\"\")","v":""},{"$f":"IF($E$38=2,IF(Input!C48=0,\"\",Input!$AG$17*A31/SUM($A$4:$A$35)),\"\")","v":""},{"$f":"IF(Input!C48=0,\"\",SUM(C31:F31))","v":""},{"$f":"IF(Input!C48=0,\"\",ROUND(G31/A31,2))","v":""},{"$f":"IF(Input!C48=0,\"\",H31*A31)","v":""},null,0,{"$f":"IF(Input!C48=0,\"\",(H31+K31)*A31)","v":""}]
[{"$f":"IF(Input!C49=0,0,Input!C49)","v":0},{"$f":"IF(Input!C49+Input!BQ49+Input!CA49>0,IF(Input!BQ49=0,Input!CA49/Input!C49,Input!BQ49),\"\")","v":""},{"$f":"IF(Input!C49+Input!BQ49+Input!CA49>0,IF(Input!CA49=0,Input!BQ49*Input!C49,Input!CA49),\"\")","v":""},{"$f":"IF(Input!C49=0,\"\",Input!$X$17*C32/SUM($C$4:$C$35))","v":""},{"$f":"IF($E$38<2,IF(Input!C49=0,\"\",(Input!$AG$17+Input!$AP$17)*(C32/SUM($C$4:$C$35))),\"\")","v":""},{"$f":"IF($E$38=2,IF(Input!C49=0,\"\",Input!$AG$17*A32/SUM($A$4:$A$35)),\"\")","v":""},{"$f":"IF(Input!C49=0,\"\",SUM(C32:F32))","v":""},{"$f":"IF(Input!C49=0,\"\",ROUND(G32/A32,2))","v":""},{"$f":"IF(Input!C49=0,\"\",H32*A32)","v":""},null,0,{"$f":"IF(Input!C49=0,\"\",(H32+K32)*A32)","v":""}]
[{"$f":"IF(Input!C50=0,0,Input!C50)","v":0},{"$f":"IF(Input!C50+Input!BQ50+Input!CA50>0,IF(Input!BQ50=0,Input!CA50/Input!C50,Input!BQ50),\"\")","v":""},{"$f":"IF(Input!C50+Input!BQ50+Input!CA50>0,IF(Input!CA50=0,Input!BQ50*Input!C50,Input!CA50),\"\")","v":""},{"$f":"IF(Input!C50=0,\"\",Input!$X$17*C33/SUM($C$4:$C$35))","v":""},{"$f":"IF($E$38<2,IF(Input!C50=0,\"\",(Input!$AG$17+Input!$AP$17)*(C33/SUM($C$4:$C$35))),\"\")","v":""},{"$f":"IF($E$38=2,IF(Input!C50=0,\"\",Input!$AG$17*A33/SUM($A$4:$A$35)),\"\")","v":""},{"$f":"IF(Input!C50=0,\"\",SUM(C33:F33))","v":""},{"$f":"IF(Input!C50=0,\"\",ROUND(G33/A33,2))","v":""},{"$f":"IF(Input!C50=0,\"\",H33*A33)","v":""},null,0,{"$f":"IF(Input!C50=0,\"\",(H33+K33)*A33)","v":""}]
[{"$f":"IF(Input!C51=0,0,Input!C51)","v":0},{"$f":"IF(Input!C51+Input!BQ51+Input!CA51>0,IF(Input!BQ51=0,Input!CA51/Input!C51,Input!BQ51),\"\")","v":""},{"$f":"IF(Input!C51+Input!BQ51+Input!CA51>0,IF(Input!CA51=0,Input!BQ51*Input!C51,Input!CA51),\"\")","v":""},{"$f":"IF(Input!C51=0,\"\",Input!$X$17*C34/SUM($C$4:$C$35))","v":""},{"$f":"IF($E$38<2,IF(Input!C51=0,\"\",(Input!$AG$17+Input!$AP$17)*(C34/SUM($C$4:$C$35))),\"\")","v":""},{"$f":"IF($E$38=2,IF(Input!C51=0,\"\",Input!$AG$17*A34/SUM($A$4:$A$35)),\"\")","v":""},{"$f":"IF(Input!C51=0,\"\",SUM(C34:F34))","v":""},{"$f":"IF(Input!C51=0,\"\",ROUND(G34/A34,2))","v":""},{"$f":"IF(Input!C51=0,\"\",H34*A34)","v":""},null,0,{"$f":"IF(Input!C51=0,\"\",(H34+K34)*A34)","v":""}]
[{"$f":"IF(Input!C52=0,0,Input!C52)","v":0},{"$f":"IF(Input!C52+Input!BQ52+Input!CA52>0,IF(Input!BQ52=0,Input!CA52/Input!C52,Input!BQ52),\"\")","v":""},{"$f":"IF(Input!C52+Input!BQ52+Input!CA52>0,IF(Input!CA52=0,Input!BQ52*Input!C52,Input!CA52),\"\")","v":""},{"$f":"IF(Input!C52=0,\"\",Input!$X$17*C35/SUM($C$4:$C$35))","v":""},{"$f":"IF($E$38<2,IF(Input!C52=0,\"\",(Input!$AG$17+Input!$AP$17)*(C35/SUM($C$4:$C$35))),\"\")","v":""},{"$f":"IF($E$38=2,IF(Input!C52=0,\"\",Input!$AG$17*A35/SUM($A$4:$A$35)),\"\")","v":""},{"$f":"IF(Input!C52=0,\"\",SUM(C35:F35))","v":""},{"$f":"IF(Input!C52=0,\"\",ROUND(G35/A35,2))","v":""},{"$f":"IF(Input!C52=0,\"\",H35*A35)","v":""},null,0,{"$f":"IF(Input!C52=0,\"\",(H35+K35)*A35)","v":""}]
[{"$f":"SUM(A4:A35)","v":7},null,{"$f":"SUM(C4:C35)","v":114.17000000000002},7.7099999999999991,1,0,{"$f":"SUM(G4:G35)","v":122.87999999999997},null,122.88,{"$f":"SUM(J4:J35)","v":0},null,{"$f":"SUM(L4:L35)","v":122.88}]
[null,null,null,null,"Freight and Other Cost Assignments"]
[null,null,null,null,1]

{"sheet":"Output","index":2,"n_rows":80,"n_cols":103,"rows_kept":80,"cut":false,"hidden":false,"merged":[[23,78,23,87],[25,78,25,87],[27,78,27,87],[29,78,29,87],[65,58,65,77],[65,78,65,87],[54,78,54,87],[57,78,57,87],[58,78,58,87],[60,78,60,87],[59,78,59,87],[63,78,63,87],[64,78,64,87],[57,58,57,77],[58,58,58,77],[59,58,59,77],[60,58,60,77],[26,78,26,87],[24,78,24,87],[30,78,30,87],[28,78,28,87],[31,78,31,87],[33,78,33,87],[35,78,35,87],[4,89,4,95],[14,91,14,92],[7,14,7,19],[8,14,8,19],[8,23,8,30],[8,32,8,39],[8,41,8,48],[8,70,8,86],[9,14,9,19],[14,23,14,30],[14,32,14,39],[14,41,14,48],[14,70,14,86],[10,70,10,86],[10,59,10,66],[10,14,10,19],[10,23,10,30],[10,32,10,39],[19,2,19,7],[19,8,19,16],[19,17,19,29],[19,30,19,57],[2,2,2,12],[2,14,2,76],[2,78,2,87],[5,14,5,19],[6,14,6,19],[6,23,6,30],[6,32,6,39],[6,41,6,48],[6,59,6,66],[6,70,6,86],[4,69,4,87],[4,2,4,20],[4,22,4,67],[22,78,22,87],[21,2,21,7],[21,8,21,16],[21,17,21,29],[21,30,21,57],[21,58,21,67],[21,68,21,77],[20,2,20,7],[20,8,20,16],[20,17,20,29],[20,30,20,57],[20,58,20,67],[20,68,20,77],[20,78,20,87],[21,78,21,87],[23,2,23,7],[23,8,23,16],[23,17,23,29],[23,30,23,57],[23,58,23,67],[23,68,23,77],[22,2,22,7],[22,8,22,16],[22,17,22,29],[22,30,22,57],[22,58,22,67],[22,68,22,77],[25,2,25,7],[25,8,25,16],[25,17,25,29],[25,30,25,57],[25,58,25,67],[25,68,25,77],[24,2,24,7],[24,8,24,16],[24,17,24,29],[24,30,24,57],[24,58,24,67],[24,68,24,77],[27,17,27,29],[27,30,27,57],[27,58,27,67],[27,68,27,77],[26,2,26,7],[26,8,26,16],[26,17,26,29],[26,30,26,57],[26,58,26,67],[26,68,26,77],[29,2,29,7],[29,8,29,16],[29,17,29,29],[29,30,29,57],[29,58,29,67],[29,68,29,77],[28,2,28,7],[28,8,28,16],[28,17,28,29],[28,30,28,57],[28,58,28,67],[28,68,28,77],[32,2,32,7],[32,8,32,16],[32,17,32,29],[32,30,32,57],[32,58,32,67],[32,68,32,77],[32,78,32,87],[31,2,31,7],[31,8,31,16],[31,17,31,29],[31,30,31,57],[31,58,31,67],[31,68,31,77],[34,2,34,7],[34,8,34,16],[34,17,34,29],[34,30,34,57],[34,58,34,67],[34,68,34,77],[34,78,34,87],[33,2,33,7],[33,8,33,16],[33,17,33,29],[33,30,33,57],[33,58,33,67],[33,68,33,77],[36,2,36,7],[36,8,36,16],[36,17,36,29],[36,30,36,57],[36,58,36,67],[36,68,36,77],[36,78,36,87],[35,2,35,7],[35,8,35,16],[35,17,35,29],[35,30,35,57],[35,58,35,67],[35,68,35,77],[37,78,37,87],[38,2,38,7],[38,8,38,16],[38,17,38,29],[38,30,38,57],[38,58,38,67],[38,68,38,77],[38,78,38,87],[37,2,37,7],[37,8,37,16],[37,17,37,29],[37,30,37,57],[37,58,37,67],[37,68,37,77],[39,78,39,87],[40,2,40,7],[40,8,40,16],[40,17,40,29],[40,30,40,57],[40,58,40,67],[40,68,40,77],[40,78,40,87],[39,2,39,7],[39,8,39,16],[39,17,39,29],[39,30,39,57],[39,58,39,67],[39,68,39,77],[41,78,41,87],[42,2,42,7],[42,8,42,16],[42,17,42,29],[42,30,42,57],[42,58,42,67],[42,68,42,77],[42,78,42,87],[41,2,41,7],[41,8,41,16],[41,17,41,29],[41,30,41,57],[41,58,41,67],[41,68,41,77],[43,78,43,87],[44,2,44,7],[44,8,44,16],[44,17,44,29],[44,30,44,57],[44,58,44,67],[44,68,44,77],[44,78,44,87],[43,2,43,7],[43,8,43,16],[43,17,43,29],[43,30,43,57],[43,58,43,67],[43,68,43,77],[48,78,48,87],[47,2,47,7],[47,8,47,16],[47,17,47,29],[47,30,47,57],[47,58,47,67],[47,68,47,77],[47,78,47,87],[45,78,45,87],[46,2,46,7],[46,8,46,16],[46,17,46,29],[46,30,46,57],[46,58,46,67],[46,68,46,77],[46,78,46,87],[45,2,45,7],[45,8,45,16],[45,17,45,29],[45,30,45,57],[45,58,45,67],[45,68,45,77],[51,78,51,87],[51,2,51,7],[51,8,51,16],[51,17,51,29],[51,30,51,57],[51,58,51,67],[51,68,51,77],[49,78,49,87],[50,2,50,7],[50,8,50,16],[50,17,50,29],[50,30,50,57],[50,58,50,67],[50,68,50,77],[50,78,50,87],[49,2,49,7],[49,8,49,16],[49,17,49,29],[49,30,49,57],[49,58,49,67],[49,68,49,77],[16,97,19,102],[12,70,12,86],[17,35,17,44],[12,59,12,66],[8,59,8,66],[15,14,15,19],[16,3,16,8],[16,23,16,30],[16,32,16,39],[16,41,16,48],[16,59,16,66],[11,14,11,19],[12,14,12,19],[12,23,12,30],[12,32,12,39],[12,41,12,48],[16,70,16,86],[13,14,13,19],[14,14,14,19],[19,58,19,67],[19,68,19,77],[19,78,19,87],[10,41,10,48],[8,3,8,12],[15,91,18,95],[6,50,6,57],[8,50,8,57],[10,50,10,57],[12,50,12,57],[14,50,14,57],[16,50,16,57],[6,3,6,12],[13,59,15,66],[10,3,10,12],[53,30,54,57],[63,58,63,77],[64,58,64,77],[66,58,66,77],[54,58,54,77],[67,58,67,77],[69,58,69,77],[12,3,12,12],[14,3,14,12],[16,10,16,19],[48,2,48,7],[48,8,48,16],[48,17,48,29],[48,30,48,57],[48,58,48,67],[48,68,48,77],[30,2,30,7],[30,8,30,16],[30,17,30,29],[30,30,30,57],[30,58,30,67],[30,68,30,77],[27,2,27,7],[27,8,27,16],[58,91,58,93],[71,91,71,92],[72,91,72,92],[73,91,73,92],[76,91,76,92],[78,91,78,92],[53,91,56,95],[69,78,69,87],[67,78,67,87],[66,78,66,87]]}
[]
[]
[null,null,"Form TD-21",null,null,null,null,null,null,null,null,null,null,null,"NC Public School Transportation - Inventory Receipt Report",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,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,"Revised 09-12-19 csw"]
[]
[null,null,"Invoice Detail:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Computation Detail",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BSIP Detail",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Functions"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,"Invoice #",null,null,null,null,null,null,null,null,null,null,"Date",null,null,null,null,null,null,null,null,"Tax",null,null,null,null,null,null,null,null,"Freight",null,null,null,null,null,null,null,null,"Addl Costs",null,null,null,null,null,null,null,null,"Invoice Total",null,null,null,null,null,null,null,null,"Freight & Addl",null,null,null,null,null,null,null,null,null,null,"Purchase Order #"]
[]
[null,null,null,{"$f":"IF(Input!D9<>\"\",Input!D9,\"\")","v":1530990865},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!O9<>\"\",Input!O9,\"\")","v":"2019-03-26"},null,null,null,null,null,null,null,null,{"$f":"IF(Input!X9>0,Input!X9,\"\")","v":7.71},null,null,null,null,null,null,null,null,{"$f":"IF(Input!AG9>0,Input!AG9,\"\")","v":1},null,null,null,null,null,null,null,null,{"$f":"IF(Input!AP9>0,Input!AP9,\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(Input!AY9>0,Input!AY9,\"\")","v":121.88},null,null,null,null,null,null,null,null,"Cost Distributed",null,null,null,null,null,null,null,null,null,null,4500801832]
[]
[null,null,null,{"$f":"IF(Input!D11<>\"\",Input!D11,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!O11<>\"\",Input!O11,\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(Input!X11>0,Input!X11,\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(Input!AG11>0,Input!AG11,\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(Input!AP11>0,Input!AP11,\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(Input!AY11>0,Input!AY11,\"\")","v":""},null,null,null,null,null,null,null,null,"by % of",null,null,null,null,null,null,null,null,null,null,"Material Doc.  #"]
[]
[null,null,null,{"$f":"IF(Input!D13<>\"\",Input!D13,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!O13<>\"\",Input!O13,\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(Input!X13>0,Input!X13,\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(Input!AG13>0,Input!AG13,\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(Input!AP13>0,Input!AP13,\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(Input!AY13>0,Input!AY13,\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(Processing!E38=2,\"Quantity\",\"Total Cost\")","v":"Total Cost"},null,null,null,null,null,null,null,null,null,null,5005531931]
[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,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,"Computed\nTotal"]
[null,null,null,{"$f":"IF(Input!D15<>\"\",Input!D15,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!O15<>\"\",Input!O15,\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(Input!X15>0,Input!X15,\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(Input!AG15>0,Input!AG15,\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(Input!AP15>0,Input!AP15,\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(Input!AY15>0,Input!AY15,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Posting Date:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRIM(K17) & \" \" & TEXT(BS17,\"mm-dd-yy\")","v":"Parts City 08-25-19"}]
[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,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,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,"ME21N Contents"]
[null,null,null,"Vendor:",null,null,null,null,null,null,{"$f":"IF(Input!K17<>\"\",Input!K17,\"\")","v":"Parts City"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!X17","v":7.71},null,null,null,null,null,null,null,null,{"$f":"Input!AG17","v":1},null,null,null,null,null,null,null,null,{"$f":"Input!AP17","v":0},null,null,null,null,null,null,null,null,{"$f":"Input!AY17","v":121.88},null,null,null,null,null,null,null,null,{"$f":"SUM(Processing!L36)","v":122.88},null,null,null,null,null,null,null,null,null,null,"2019-08-25",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,"DPI Use\nInformation being copied"]
[]
[]
[null,null,"Qty",null,null,null,null,null,"DOT\nNumber",null,null,null,null,null,null,null,null,"Mfg. Part #",null,null,null,null,null,null,null,null,null,null,null,null,"Description",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,"Storage Bin Local",null,null,null,null,null,null,null,null,null,"Unit Price",null,null,null,null,null,null,null,null,null,"Total",null,null,null,null,null,null,null,null,null,null,null,null,"Non-Stock Part\nDo Not Copy","Qty","DOT\nNumber","Unit of Measure","Unit Price"]
[null,null,{"$f":"IF(Input!C21=0,\"\",Input!C21)","v":2},null,null,null,null,null,{"$f":"IF(Input!I21=0,\"\",Input!I21)","v":"EEA022069"},null,null,null,null,null,null,null,null,{"$f":"IF(Input!R21=0,\"\",Input!R21)","v":"Wix 57182"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!AE21=\"\",\"\",Input!AE21)","v":"Oil Filter"},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,{"$f":"IF(Input!BG21=\"\",\"\",Input!BG21)","v":"Filter Bin A-1"},null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!C21=0,\"\",Processing!H4+Processing!J4)","v":10.25},null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!C21=0,\"\",C21*BQ21)","v":20.5},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C21","v":2},{"$f":"I21","v":"EEA022069"},null,{"$f":"BQ21","v":10.25},null,false,null,2,"EEA022069",null,10.16]
[null,null,{"$f":"IF(Input!C22=0,\"\",Input!C22)","v":2},null,null,null,null,null,{"$f":"IF(Input!I22=0,\"\",Input!I22)","v":"EEA044406"},null,null,null,null,null,null,null,null,{"$f":"IF(Input!R22=0,\"\",Input!R22)","v":"Wix 33630"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!AE22=\"\",\"\",Input!AE22)","v":"Fuel Filter"},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,{"$f":"IF(Input!BG22=\"\",\"\",Input!BG22)","v":"Filter Bin A-2"},null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!C22=0,\"\",Processing!H5+Processing!J5)","v":26.86},null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!C22=0,\"\",C22*BQ22)","v":53.72},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C22","v":2},{"$f":"I22","v":"EEA044406"},null,{"$f":"BQ22","v":26.86},null,false,null,2,"EEA044406",null,26.65]
[null,null,{"$f":"IF(Input!C23=0,\"\",Input!C23)","v":1},null,null,null,null,null,{"$f":"IF(Input!I23=0,\"\",Input!I23)","v":"EEA015953"},null,null,null,null,null,null,null,null,{"$f":"IF(Input!R23=0,\"\",Input!R23)","v":"Wix 57701"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!AE23=\"\",\"\",Input!AE23)","v":"Trans Filer"},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,{"$f":"IF(Input!BG23=\"\",\"\",Input!BG23)","v":"Filter Bin A-3"},null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!C23=0,\"\",Processing!H6+Processing!J6)","v":15.08},null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!C23=0,\"\",C23*BQ23)","v":15.08},null,null,null,null,null,null,null,null,null,null,null,null,null,1,"EEA015953",null,15.08,null,false,null,1,"EEA015953",null,14.96]
[null,null,{"$f":"IF(Input!C24=0,\"\",Input!C24)","v":1},null,null,null,null,null,{"$f":"IF(Input!I24=0,\"\",Input!I24)","v":"EEA012607"},null,null,null,null,null,null,null,null,{"$f":"IF(Input!R24=0,\"\",Input!R24)","v":"Wix 57191"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!AE24=\"\",\"\",Input!AE24)","v":"P/S Filter"},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,{"$f":"IF(Input!BG24=\"\",\"\",Input!BG24)","v":"Filter Bin A-4"},null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!C24=0,\"\",Processing!H7+Processing!J7)","v":16.46},null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!C24=0,\"\",C24*BQ24)","v":16.46},null,null,null,null,null,null,null,null,null,null,null,null,null,1,"EEA012607",null,16.46,null,false,null,1,"EEA012607",null,16.32]
[null,null,{"$f":"IF(Input!C25=0,\"\",Input!C25)","v":1},null,null,null,null,null,{"$f":"IF(Input!I25=0,\"\",Input!I25)","v":"EEA015300"},null,null,null,null,null,null,null,null,{"$f":"IF(Input!R25=0,\"\",Input!R25)","v":"Wix 33966"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!AE25=\"\",\"\",Input!AE25)","v":"Fuel Filter"},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,{"$f":"IF(Input!BG25=\"\",\"\",Input!BG25)","v":"Filter Bin A-5"},null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!C25=0,\"\",Processing!H8+Processing!J8)","v":17.12},null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!C25=0,\"\",C25*BQ25)","v":17.12},null,null,null,null,null,null,null,null,null,null,null,null,null,1,"EEA015300",null,17.12,null,false,null,1,"EEA015300",null,16.98]
[null,null,{"$f":"IF(Input!C26=0,\"\",Input!C26)","v":""},null,null,null,null,null,{"$f":"IF(Input!I26=0,\"\",Input!I26)","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(Input!R26=0,\"\",Input!R26)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!AE26=\"\",\"\",Input!AE26)","v":""},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,{"$f":"IF(Input!BG26=\"\",\"\",Input!BG26)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!C26=0,\"\",Processing!H9+Processing!J9)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!C26=0,\"\",C26*BQ26)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,"",null,false]
[null,null,{"$f":"IF(Input!C27=0,\"\",Input!C27)","v":""},null,null,null,null,null,{"$f":"IF(Input!I27=0,\"\",Input!I27)","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(Input!R27=0,\"\",Input!R27)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!AE27=\"\",\"\",Input!AE27)","v":""},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,{"$f":"IF(Input!BG27=\"\",\"\",Input!BG27)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!C27=0,\"\",Processing!H10+Processing!J10)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!C27=0,\"\",C27*BQ27)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,"",null,false]
[null,null,{"$f":"IF(Input!C28=0,\"\",Input!C28)","v":""},null,null,null,null,null,{"$f":"IF(Input!I28=0,\"\",Input!I28)","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(Input!R28=0,\"\",Input!R28)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!AE28=\"\",\"\",Input!AE28)","v":""},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,{"$f":"IF(Input!BG28=\"\",\"\",Input!BG28)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!C28=0,\"\",Processing!H11+Processing!J11)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!C28=0,\"\",C28*BQ28)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,"",null,false]
[null,null,{"$f":"IF(Input!C29=0,\"\",Input!C29)","v":""},null,null,null,null,null,{"$f":"IF(Input!I29=0,\"\",Input!I29)","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(Input!R29=0,\"\",Input!R29)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!AE29=\"\",\"\",Input!AE29)","v":""},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,{"$f":"IF(Input!BG29=\"\",\"\",Input!BG29)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!C29=0,\"\",Processing!H12+Processing!J12)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!C29=0,\"\",C29*BQ29)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,"",null,false]
[null,null,{"$f":"IF(Input!C30=0,\"\",Input!C30)","v":""},null,null,null,null,null,{"$f":"IF(Input!I30=0,\"\",Input!I30)","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(Input!R30=0,\"\",Input!R30)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!AE30=\"\",\"\",Input!AE30)","v":""},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,{"$f":"IF(Input!BG30=\"\",\"\",Input!BG30)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!C30=0,\"\",Processing!H13+Processing!J13)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!C30=0,\"\",C30*BQ30)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,"",null,false]
[null,null,{"$f":"IF(Input!C31=0,\"\",Input!C31)","v":""},null,null,null,null,null,{"$f":"IF(Input!I31=0,\"\",Input!I31)","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(Input!R31=0,\"\",Input!R31)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!AE31=\"\",\"\",Input!AE31)","v":""},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,{"$f":"IF(Input!BG31=\"\",\"\",Input!BG31)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!C31=0,\"\",Processing!H14+Processing!J14)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!C31=0,\"\",C31*BQ31)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,"",null,false]
[null,null,{"$f":"IF(Input!C32=0,\"\",Input!C32)","v":""},null,null,null,null,null,{"$f":"IF(Input!I32=0,\"\",Input!I32)","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(Input!R32=0,\"\",Input!R32)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!AE32=\"\",\"\",Input!AE32)","v":""},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,{"$f":"IF(Input!BG32=\"\",\"\",Input!BG32)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!C32=0,\"\",Processing!H15+Processing!J15)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!C32=0,\"\",C32*BQ32)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,"",null,false]
[null,null,{"$f":"IF(Input!C33=0,\"\",Input!C33)","v":""},null,null,null,null,null,{"$f":"IF(Input!I33=0,\"\",Input!I33)","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(Input!R33=0,\"\",Input!R33)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!AE33=\"\",\"\",Input!AE33)","v":""},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,{"$f":"IF(Input!BG33=\"\",\"\",Input!BG33)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!C33=0,\"\",Processing!H16+Processing!J16)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!C33=0,\"\",C33*BQ33)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,"",null,false]
[null,null,{"$f":"IF(Input!C34=0,\"\",Input!C34)","v":""},null,null,null,null,null,{"$f":"IF(Input!I34=0,\"\",Input!I34)","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(Input!R34=0,\"\",Input!R34)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!AE34=\"\",\"\",Input!AE34)","v":""},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,{"$f":"IF(Input!BG34=\"\",\"\",Input!BG34)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!C34=0,\"\",Processing!H17+Processing!J17)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!C34=0,\"\",C34*BQ34)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,"",null,false]
[null,null,{"$f":"IF(Input!C35=0,\"\",Input!C35)","v":""},null,null,null,null,null,{"$f":"IF(Input!I35=0,\"\",Input!I35)","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(Input!R35=0,\"\",Input!R35)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!AE35=\"\",\"\",Input!AE35)","v":""},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,{"$f":"IF(Input!BG35=\"\",\"\",Input!BG35)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!C35=0,\"\",Processing!H18+Processing!J18)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!C35=0,\"\",C35*BQ35)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,"",null,false]
[null,null,{"$f":"IF(Input!C36=0,\"\",Input!C36)","v":""},null,null,null,null,null,{"$f":"IF(Input!I36=0,\"\",Input!I36)","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(Input!R36=0,\"\",Input!R36)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!AE36=\"\",\"\",Input!AE36)","v":""},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,{"$f":"IF(Input!BG36=\"\",\"\",Input!BG36)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!C36=0,\"\",Processing!H19+Processing!J19)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!C36=0,\"\",C36*BQ36)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,"",null,false]
[null,null,{"$f":"IF(Input!C37=0,\"\",Input!C37)","v":""},null,null,null,null,null,{"$f":"IF(Input!I37=0,\"\",Input!I37)","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(Input!R37=0,\"\",Input!R37)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!AE37=\"\",\"\",Input!AE37)","v":""},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,{"$f":"IF(Input!BG37=\"\",\"\",Input!BG37)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!C37=0,\"\",Processing!H20+Processing!J20)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!C37=0,\"\",C37*BQ37)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,"",null,false]
[null,null,{"$f":"IF(Input!C38=0,\"\",Input!C38)","v":""},null,null,null,null,null,{"$f":"IF(Input!I38=0,\"\",Input!I38)","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(Input!R38=0,\"\",Input!R38)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!AE38=\"\",\"\",Input!AE38)","v":""},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,{"$f":"IF(Input!BG38=\"\",\"\",Input!BG38)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!C38=0,\"\",Processing!H21+Processing!J21)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!C38=0,\"\",C38*BQ38)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,"",null,false]
[null,null,{"$f":"IF(Input!C39=0,\"\",Input!C39)","v":""},null,null,null,null,null,{"$f":"IF(Input!I39=0,\"\",Input!I39)","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(Input!R39=0,\"\",Input!R39)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!AE39=\"\",\"\",Input!AE39)","v":""},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,{"$f":"IF(Input!BG39=\"\",\"\",Input!BG39)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!C39=0,\"\",Processing!H22+Processing!J22)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!C39=0,\"\",C39*BQ39)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,"",null,false]
[null,null,{"$f":"IF(Input!C40=0,\"\",Input!C40)","v":""},null,null,null,null,null,{"$f":"IF(Input!I40=0,\"\",Input!I40)","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(Input!R40=0,\"\",Input!R40)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!AE40=\"\",\"\",Input!AE40)","v":""},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,{"$f":"IF(Input!BG40=\"\",\"\",Input!BG40)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!C40=0,\"\",Processing!H23+Processing!J23)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!C40=0,\"\",C40*BQ40)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,"",null,false]
[null,null,{"$f":"IF(Input!C41=0,\"\",Input!C41)","v":""},null,null,null,null,null,{"$f":"IF(Input!I41=0,\"\",Input!I41)","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(Input!R41=0,\"\",Input!R41)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!AE41=\"\",\"\",Input!AE41)","v":""},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,{"$f":"IF(Input!BG41=\"\",\"\",Input!BG41)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!C41=0,\"\",Processing!H24+Processing!J24)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!C41=0,\"\",C41*BQ41)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,"",null,false]
[null,null,{"$f":"IF(Input!C42=0,\"\",Input!C42)","v":""},null,null,null,null,null,{"$f":"IF(Input!I42=0,\"\",Input!I42)","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(Input!R42=0,\"\",Input!R42)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!AE42=\"\",\"\",Input!AE42)","v":""},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,{"$f":"IF(Input!BG42=\"\",\"\",Input!BG42)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!C42=0,\"\",Processing!H25+Processing!J25)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!C42=0,\"\",C42*BQ42)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,"",null,false]
[null,null,{"$f":"IF(Input!C43=0,\"\",Input!C43)","v":""},null,null,null,null,null,{"$f":"IF(Input!I43=0,\"\",Input!I43)","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(Input!R43=0,\"\",Input!R43)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!AE43=\"\",\"\",Input!AE43)","v":""},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,{"$f":"IF(Input!BG43=\"\",\"\",Input!BG43)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!C43=0,\"\",Processing!H26+Processing!J26)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!C43=0,\"\",C43*BQ43)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,"",null,false]
[null,null,{"$f":"IF(Input!C44=0,\"\",Input!C44)","v":""},null,null,null,null,null,{"$f":"IF(Input!I44=0,\"\",Input!I44)","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(Input!R44=0,\"\",Input!R44)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!AE44=\"\",\"\",Input!AE44)","v":""},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,{"$f":"IF(Input!BG44=\"\",\"\",Input!BG44)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!C44=0,\"\",Processing!H27+Processing!J27)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!C44=0,\"\",C44*BQ44)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,"",null,false]
[null,null,{"$f":"IF(Input!C45=0,\"\",Input!C45)","v":""},null,null,null,null,null,{"$f":"IF(Input!I45=0,\"\",Input!I45)","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(Input!R45=0,\"\",Input!R45)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!AE45=\"\",\"\",Input!AE45)","v":""},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,{"$f":"IF(Input!BG45=\"\",\"\",Input!BG45)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!C45=0,\"\",Processing!H28+Processing!J28)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!C45=0,\"\",C45*BQ45)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,"",null,false]
[null,null,{"$f":"IF(Input!C46=0,\"\",Input!C46)","v":""},null,null,null,null,null,{"$f":"IF(Input!I46=0,\"\",Input!I46)","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(Input!R46=0,\"\",Input!R46)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!AE46=\"\",\"\",Input!AE46)","v":""},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,{"$f":"IF(Input!BG46=\"\",\"\",Input!BG46)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!C46=0,\"\",Processing!H29+Processing!J29)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!C46=0,\"\",C46*BQ46)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,"",null,false]
[null,null,{"$f":"IF(Input!C47=0,\"\",Input!C47)","v":""},null,null,null,null,null,{"$f":"IF(Input!I47=0,\"\",Input!I47)","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(Input!R47=0,\"\",Input!R47)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!AE47=\"\",\"\",Input!AE47)","v":""},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,{"$f":"IF(Input!BG47=\"\",\"\",Input!BG47)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!C47=0,\"\",Processing!H30+Processing!J30)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!C47=0,\"\",C47*BQ47)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,"",null,false]
[null,null,{"$f":"IF(Input!C48=0,\"\",Input!C48)","v":""},null,null,null,null,null,{"$f":"IF(Input!I48=0,\"\",Input!I48)","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(Input!R48=0,\"\",Input!R48)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!AE48=\"\",\"\",Input!AE48)","v":""},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,{"$f":"IF(Input!BG48=\"\",\"\",Input!BG48)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!C48=0,\"\",Processing!H31+Processing!J31)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!C48=0,\"\",C48*BQ48)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,"",null,false]
[null,null,{"$f":"IF(Input!C49=0,\"\",Input!C49)","v":""},null,null,null,null,null,{"$f":"IF(Input!I49=0,\"\",Input!I49)","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(Input!R49=0,\"\",Input!R49)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!AE49=\"\",\"\",Input!AE49)","v":""},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,{"$f":"IF(Input!BG49=\"\",\"\",Input!BG49)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!C49=0,\"\",Processing!H32+Processing!J32)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!C49=0,\"\",C49*BQ49)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,"",null,false]
[null,null,{"$f":"IF(Input!C50=0,\"\",Input!C50)","v":""},null,null,null,null,null,{"$f":"IF(Input!I50=0,\"\",Input!I50)","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(Input!R50=0,\"\",Input!R50)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!AE50=\"\",\"\",Input!AE50)","v":""},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,{"$f":"IF(Input!BG50=\"\",\"\",Input!BG50)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!C50=0,\"\",Processing!H33+Processing!J33)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!C50=0,\"\",C50*BQ50)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,"",null,false]
[null,null,{"$f":"IF(Input!C51=0,\"\",Input!C51)","v":""},null,null,null,null,null,{"$f":"IF(Input!I51=0,\"\",Input!I51)","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(Input!R51=0,\"\",Input!R51)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!AE51=\"\",\"\",Input!AE51)","v":""},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,{"$f":"IF(Input!BG51=\"\",\"\",Input!BG51)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!C51=0,\"\",Processing!H34+Processing!J34)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!C51=0,\"\",C51*BQ51)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,"",null,false]
[null,null,{"$f":"IF(Input!C52=0,\"\",Input!C52)","v":""},null,null,null,null,null,{"$f":"IF(Input!I52=0,\"\",Input!I52)","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(Input!R52=0,\"\",Input!R52)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!AE52=\"\",\"\",Input!AE52)","v":""},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,{"$f":"IF(Input!BG52=\"\",\"\",Input!BG52)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!C52=0,\"\",Processing!H35+Processing!J35)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!C52=0,\"\",C52*BQ52)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,"",null,false]
[]
[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,"Summary:",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,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,{"$f":"IF(CA70<>\"\",IF(CA61-CA70>0,CQ59&DOLLAR(CA70,2),CQ60&DOLLAR(CA70,2)),\"\")","v":"Total of Computed Invoice exceeds the Total of invoices keyed by a variance of:  $1.00"}]
[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,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,"Items:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Processing!A36)","v":7}]
[]
[]
[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,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,"Sub-Total:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Processing!C36)","v":114.17000000000002}]
[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,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,"Taxes:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Processing!D36)","v":7.7099999999999991},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CA70<>\"\",\"Steps to Correct Variance:\",\"\")","v":"Steps to Correct Variance:"},null,null,"Total of Computed Invoice exceeds the Total of invoices keyed by a variance of:  "]
[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,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,"Freight & Additional Costs:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Processing!E36)","v":1},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CA70<>\"\",\"1.  Return to Input Worksheet\",\"\")","v":"1.  Return to Input Worksheet"},null,null,"Total of Invoice(s) Input exceeds the Total of Computed Invoice(s) by a variance of:  "]
[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,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,"Computed Invoice Total:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Processing!L36)","v":122.88},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CA70<>\"\",\"2.  Review Invoice total(s) input\",\"\")","v":"2.  Review Invoice total(s) input"},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,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,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,{"$f":"IF(CA70<>\"\",\"3.  Review Quantities input\",\"\")","v":"3.  Review Quantities input"}]
[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,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,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,{"$f":"IF(CA70<>\"\",\"4.  Change invalid entries\",\"\")","v":"4.  Change invalid entries"}]
[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,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,"Keyed Invoice Total #1:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!AY9","v":121.88},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CA70<>\"\",\"5.  Click <Submit> to recompute\",\"\")","v":"5.  Click <Submit> to recompute"}]
[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,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,"Keyed Invoice Total #2:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!AY11","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CA70<>\"\",\"6.  Re-review output\",\"\")","v":"6.  Re-review output"}]
[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,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,"Keyed Invoice Total #3:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!AY13","v":0}]
[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,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,"Keyed Invoice Total #4:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!AY15","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CA70<>\"\",\"How to correct  - Single line invoice\",\"\")","v":"How to correct  - Single line invoice"}]
[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,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,"Total:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Input!AY17","v":121.88},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CA70<>\"\",\"1.  Split transaction based upon variance.\",\"\")","v":"1.  Split transaction based upon variance."}]
[]
[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,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,{"$f":"IF(CA70<>\"\",\"Variance:\",\"\")","v":"Variance:"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ROUND(SUM(CA61-CA68),2)<>0,SUM(CA61-CA68),\"\")","v":1}]
[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,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,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,{"$f":"IF(CA70<>\"\",\"Example\",\"\")","v":"Example"}]
[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,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,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,{"$f":"IF(CA70<>\"\",\"Variance of:\",\"\")","v":"Variance of:"},null,{"$f":"IF(CA70<>\"\",\"$1.27\",\"\")","v":"$1.27"}]
[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,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,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,{"$f":"IF(CA70<>\"\",\"Original Unit Price:\",\"\")","v":"Original Unit Price:"},null,{"$f":"IF(CA70<>\"\",\"$3.83\",\"\")","v":"$3.83"}]
[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,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,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,{"$f":"IF(CA70<>\"\",\"Quanity:\",\"\")","v":"Quanity:"},null,{"$f":"IF(CA70<>\"\",\"800\",\"\")","v":"800"}]
[]
[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,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,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,{"$f":"IF(CA70<>\"\",\"Qty\",\"\")","v":"Qty"},{"$f":"IF(CA70<>\"\",\"Unit Price\",\"\")","v":"Unit Price"}]
[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,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,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,{"$f":"IF(CA70<>\"\",\"Original - 1 Transaction:\",\"\")","v":"Original - 1 Transaction:"},null,{"$f":"IF(CA70<>\"\",\"800\",\"\")","v":"800"},{"$f":"IF(CA70<>\"\",\"3.83\",\"\")","v":"3.83"}]
[]
[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,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,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,{"$f":"IF(CA70<>\"\",\"New -  2 Transactions:\",\"\")","v":"New -  2 Transactions:"},null,{"$f":"IF(CA70<>\"\",\"673\",\"\")","v":"673"},{"$f":"IF(CA70<>\"\",\"3.83\",\"\")","v":"3.83"}]
[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,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,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,{"$f":"IF(CA70<>\"\",\"127\",\"\")","v":"127"},{"$f":"IF(CA70<>\"\",\"3.82\",\"\")","v":"3.82"}]