{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Weight & Volume Calculator"],"not_rendered":{"images":5,"macros":1,"defined_names":43},"read":"whole","date_system":"1900"}

{"sheet":"Weight & Volume Calculator","index":0,"n_rows":86,"n_cols":13,"rows_kept":86,"merged":[[0,1,0,10],[1,1,1,10],[2,1,2,2],[2,3,2,5],[2,6,2,7],[2,8,2,10],[3,1,3,2],[3,3,3,5],[3,6,3,7],[3,8,3,10],[4,1,4,7],[5,6,5,7],[6,6,6,7],[7,6,7,7],[8,6,9,7],[8,8,9,8],[8,9,9,9],[8,10,9,10],[10,1,10,7],[11,1,11,10],[12,1,12,3],[13,1,13,3],[14,1,14,3],[15,1,15,3],[16,1,16,3],[17,1,17,3],[18,1,18,3],[19,1,19,3],[20,1,20,3],[21,1,21,3],[22,1,22,7],[24,1,24,10],[25,1,25,3],[26,1,26,3],[27,1,27,3],[28,1,28,3],[29,1,29,3],[30,1,30,3],[31,1,31,3],[32,1,32,3],[33,1,33,3],[34,1,34,3],[35,1,35,3],[36,1,36,3],[37,1,37,3],[38,1,38,3],[39,1,39,3],[40,1,40,3],[41,1,41,3],[42,1,42,3],[43,1,43,7],[45,1,46,7],[48,1,48,10],[49,4,49,5],[50,4,50,5],[51,2,51,4],[51,6,51,7],[51,9,51,10],[52,2,52,4],[52,6,52,7],[52,9,52,10]]}
[null,"Catholic Relief Services - USCCB"]
[null,"COMMODITY WEIGHT, VOLUME AND TRANSPORT ASSET CALCULATOR"]
[null,"Country Program:",{"$nulls":4},"Date:"]
[null,"Whse / Field Office:",{"$nulls":4},"Delivery Point:"]
[]
[{"$nulls":6},"Est. avg. persons per household:",null,5.6,null,"  (A)"]
[{"$nulls":6},"Number of households targeted:",null,{"v":1000,"d":"1,000 "},"(household rations)","  (B)",null,{"$f":"I8","v":{"v":5600,"d":"5,600 "}}]
[{"$nulls":6},"Total estimated beneficiaries:",null,{"$f":"ROUNDUP(I6*I7,0)","v":{"v":5600,"d":"5,600 "}},"(individual rations)","  (C = B * A)"]
[{"$nulls":6},"Ration period coverage:",null,{"v":30,"d":"30 "},"days","  (D)"]
[]
[]
[null,"BULK FOOD COMMODITIES"]
[null,"DESCRIPTION",null,null,"PACKAGING / UNIT MEASURE","UNIT WEIGHT\n(KG)\n(E)","UNIT VOLUME\n(Cubic M)\n(F)","DAILY RATION\nIN GRAMS\n(G)","TOTAL RATION\nWEIGHT (KG)\n(H = C * D * G / 1,000)","TOTAL UNITS REQ'D\n(I = H / E)","TOTAL VOLUME \n(Cubic M)\n(I * F)"]
[null,"Sorghum (50 KG sacks)",null,null,"Sack",{"$f":"IF(B14=\"\",0,VLOOKUP($B14,$B$57:$E$86,4))","v":{"v":50,"d":"50.00"}},{"$f":"IF(B14=\"\",0,VLOOKUP($B14,$B$57:$E$86,3))","v":{"v":0.08,"d":"0.080"}},{"v":400,"d":"400.0"},{"$f":"(I$8*I$9*H14)/1000","v":{"v":67200,"d":"67,200.0"}},{"$f":"ROUNDUP(IF(F14=0,0,I14/F14),0)","v":{"v":1344,"d":"1,344"}},{"$f":"IF(H14=0,0,J14*G14)","v":{"v":107.52,"d":"107.5"}}]
[null,"Peas (50 KG sacks)",null,null,"Sack",{"$f":"IF(B15=\"\",0,VLOOKUP($B15,$B$57:$E$86,4))","v":{"v":50,"d":"50.00"}},{"$f":"IF(B15=\"\",0,VLOOKUP($B15,$B$57:$E$86,3))","v":{"v":0.08,"d":"0.080"}},{"v":80,"d":"80.0"},{"$f":"(I$8*I$9*H15)/1000","v":{"v":13440,"d":"13,440.0"}},269,{"v":21.52,"d":"21.5"}]
[null,"Veg oil, 5L  Jugs",null,null,"Carton",{"v":23.183999999999997,"d":"23.18"},{"v":0.0264,"d":"0.026"},33.3,{"v":5594.399999999999,"d":"5,594.4"},242,{"v":6.3888,"d":"6.4"}]
[null,"Salt, Iodized (25 KG sacks)",null,null,"Sack",{"v":25,"d":"25.00"},0.035,{"v":5,"d":"5.0"},{"v":840,"d":"840.0"},34,{"v":1.1900000000000002,"d":"1.2"}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"v":0,"d":"0.000"},null,{"v":0,"d":"0.0"},0,{"v":0,"d":"0.0"}]
[{"$nulls":5},{"v":0,"d":"0.00"},{"v":0,"d":"0.000"},null,{"v":0,"d":"0.0"},0,{"v":0,"d":"0.0"}]
[{"$nulls":8},{"v":0,"d":"0.0"},0,{"v":0,"d":"0.0"}]
[{"$nulls":8},{"v":0,"d":"0.0"},0,{"v":0,"d":"0.0"}]
[{"$nulls":8},{"v":0,"d":"0.0"},0,{"v":0,"d":"0.0"}]
[null,"BULK FOOD -- COLUMN TOTALS:",{"$nulls":6},{"$f":"ROUNDUP(SUM(I$14:I22),0)","v":{"v":87075,"d":"87,075.0"}},{"$f":"ROUNDUP(SUM(J$14:J22),2)","v":{"v":1889,"d":"1,889"}},{"$f":"ROUNDUP(SUM(K$14:K22),2)","v":{"v":136.62,"d":"136.6"}}]
[]
[null,"NON-FOOD ITEMS: KITS AND / OR UNITS"]
[null,"DESCRIPTION",null,null,"PACKAGING / UNIT MEASURE","UNIT WEIGHT\n(KG)\n(e)","UNIT VOLUME\n(Cubic M)\n(f)","UNITS PER HOUSEHOLD\n(g)","TOTAL WEIGHT\n(KG)\n(e * h)","TOTAL UNITS REQ'D\n(h = B * g)","TOTAL VOLUME \n(Cubic M)\n(f * h)"]
[null,"Blanket, 50% wool, 1.5m x 2m",null,null,"Each",{"v":1.4,"d":"1.40"},0.005,{"v":3,"d":"3.00"},{"$f":"IF(H27=0,0,(F27*J27))","v":{"v":4200,"d":"4,200.0"}},{"$f":"ROUNDUP(IF(H27=0,0,$I$7*H27),0)","v":{"v":3000,"d":"3,000"}},{"$f":"IF(G27=0,0,J27*G27)","v":{"v":15,"d":"15.0"}}]
[null,"Plastic Sheet, 4m x 6m",null,null,"Each",{"v":5.4,"d":"5.40"},0.011,{"v":1,"d":"1.00"},{"v":5400,"d":"5,400.0"},{"v":1000,"d":"1,000"},{"v":11,"d":"11.0"}]
[null,"Kitchen Set",null,null,"Carton",{"v":5,"d":"5.00"},{"v":0.04,"d":"0.040"},{"v":1,"d":"1.00"},{"v":5000,"d":"5,000.0"},{"v":1000,"d":"1,000"},{"v":40,"d":"40.0"}]
[{"$nulls":8},{"v":0,"d":"0.0"},0,{"v":0,"d":"0.0"}]
[{"$nulls":8},{"$f":"IF(H31=0,0,(F31*J31))","v":{"v":0,"d":"0.0"}},{"$f":"ROUNDUP(IF(H31=0,0,$I$7*H31),0)","v":0},{"$f":"IF(G31=0,0,J31*G31)","v":{"v":0,"d":"0.0"}}]
[{"$nulls":8},{"v":0,"d":"0.0"},0,{"v":0,"d":"0.0"}]
[{"$nulls":8},{"v":0,"d":"0.0"},0,{"v":0,"d":"0.0"}]
[{"$nulls":8},{"v":0,"d":"0.0"},0,{"v":0,"d":"0.0"}]
[{"$nulls":8},{"v":0,"d":"0.0"},0,{"v":0,"d":"0.0"}]
[{"$nulls":8},{"v":0,"d":"0.0"},0,{"v":0,"d":"0.0"}]
[{"$nulls":8},{"$f":"IF(H37=0,0,(F37*J37))","v":{"v":0,"d":"0.0"}},{"$f":"ROUNDUP(IF(H37=0,0,$I$7*H37),0)","v":0},{"$f":"IF(G37=0,0,J37*G37)","v":{"v":0,"d":"0.0"}}]
[{"$nulls":8},{"v":0,"d":"0.0"},0,{"v":0,"d":"0.0"}]
[{"$nulls":8},{"v":0,"d":"0.0"},0,{"v":0,"d":"0.0"}]
[{"$nulls":8},{"v":0,"d":"0.0"},0,{"v":0,"d":"0.0"}]
[{"$nulls":8},{"v":0,"d":"0.0"},0,{"v":0,"d":"0.0"}]
[{"$nulls":8},{"v":0,"d":"0.0"},0,{"v":0,"d":"0.0"}]
[{"$nulls":8},{"v":0,"d":"0.0"},0,{"v":0,"d":"0.0"}]
[null,"KITS AND UNITS -- COLUMN TOTALS:",{"$nulls":6},{"$f":"ROUNDUP(SUM(I$27:I43),0)","v":{"v":14600,"d":"14,600.0"}},{"$f":"SUM(J27:J43)","v":{"v":5000,"d":"5,000"}},{"$f":"ROUNDUP(SUM(K$27:K43),2)","v":{"v":66,"d":"66.0"}}]
[]
[null,"TOTAL COMMODITY WEIGHT AND VOLUME TO DELIVER TO SITE:",{"$nulls":6},"TOTAL KG\nof Commodities","TOTAL MT\nof Commodities","TOTAL VOLUME\nM3 of Commodities"]
[{"$nulls":8},{"$f":"FoodWeight+NFIWeight","v":{"v":101675,"d":"101,675"}},{"$f":"TotalKG/1000","v":{"v":101.675,"d":"101.7"}},{"$f":"FoodVolume+NFIVolume","v":{"v":202.62,"d":"202.6"}}]
[]
[null,"TRANSPORT REQUIREMENTS"]
[null,"DELIVERY TIME (DAYS)\n(Q)","ROUND TRIP TIME (HOURS)\n(R)","EXCESS CAPACITY\n(S)","POSSIBLE TRIPS PER \nTRANSPORT ASSET\n(T = (Q  / (R / 24))",null,"AVG. TRANSPORT\nCAPACITY (MT)\n(U)","AVG. TRANSPORT\nCAPACITY (M3)\n(V)","No. OF FULL LOADS BY WEIGHT\n(TOTAL MT / U)","No. OF FULL LOADS BY VOLUME\n(TOTAL M3 / V)","NO. OF TRANSPORT ASSETS REQ'D"]
[null,4,24,{"v":0.2,"d":"20%"},{"$f":"IF(RoundTripTime=0,0,ROUNDDOWN(DeliveryTime/(RoundTripTime/24),0))","v":4},null,{"v":8,"d":"8.0"},{"v":20,"d":"20.0"},{"$f":"IF(AvgCapacity=0,0,ROUNDUP(TotalMT/AvgCapacity,0))","v":{"v":13,"d":"13 "}},{"$f":"IF(AvgCapacityM3=0,0,ROUNDUP(TotalVolume/AvgCapacityM3,0))","v":{"v":11,"d":"11 "}},{"$f":"IF(FullLoadsWeight=0,0,IF(FullLoadsWeight>=FullLoadsVolume,(ROUNDUP((FullLoadsWeight/Possibletrips)*(1+ExcessCapacity),0)),(ROUNDUP((FullLoadsVolume/Possibletrips)*(1+ExcessCapacity),0))))","v":{"v":4,"d":"4 "}}]
[]
[null,null,"PREPARED AND SUBMITTED BY",{"$nulls":3},"REVIEWED AND APPROVED",null,null,"DATE"]
[]
[]
[null,"Commodity","Column1","Volume","Weight","Package"]
[null,"Beans (100 KG sacks)",null,{"v":0.16,"d":"0.160"},{"v":100,"d":"100.00"},"Sack","Bale"]
[null,"Beans (50 KG sacks)",null,{"v":0.08,"d":"0.080"},{"v":50,"d":"50.00"},"Sack","Barrel"]
[null,"Bulgur - SFB (50 KG sacks)",null,{"v":0.08,"d":"0.080"},{"v":50,"d":"50.00"},"Sack","Bottle"]
[null,"Bulgur Wheat",null,{"v":0.08,"d":"0.080"},{"v":50,"d":"50.00"},"Sack","Box"]
[null,"Corn, grain (100 KG sacks)",null,{"v":0.16,"d":"0.160"},{"v":100,"d":"100.00"},"Sack","Can"]
[null,"Corn, grain (50 KG sacks)",null,{"v":0.08,"d":"0.080"},{"v":50,"d":"50.00"},"Sack","Carton"]
[null,"Cornmeal ",null,{"v":0.04,"d":"0.040"},{"v":25,"d":"25.00"},"Sack","Each"]
[null,"Cornmeal - SF ",null,{"v":0.04,"d":"0.040"},{"v":25,"d":"25.00"},"Sack","KG"]
[null,"CSB",null,{"v":0.04,"d":"0.040"},{"v":25,"d":"25.00"},"Sack","Liter"]
[null,"CSM",null,{"v":0.04,"d":"0.040"},{"v":25,"d":"25.00"},"Sack","Meter"]
[null,"CSMF",null,{"v":0.04,"d":"0.040"},{"v":25,"d":"25.00"},"Sack","MT"]
[null,"Lentils (25 KG sacks)",null,{"v":0.04,"d":"0.040"},{"v":25,"d":"25.00"},"Sack","Roll"]
[null,"Lentils (50 KG sacks)",null,{"v":0.08,"d":"0.080"},{"v":50,"d":"50.00"},"Sack","Sack"]
[null,"Peas (100 KG sacks)",null,{"v":0.16,"d":"0.160"},{"v":100,"d":"100.00"},"Sack","Tin"]
[null,"Peas (50 KG sacks)",null,{"v":0.08,"d":"0.080"},{"v":50,"d":"50.00"},"Sack"]
[null,"Rice (100 KG sacks)",null,{"v":0.16,"d":"0.160"},{"v":100,"d":"100.00"},"Sack"]
[null,"Rice (50 KG sacks)",null,{"v":0.08,"d":"0.080"},{"v":50,"d":"50.00"},"Sack"]
[null,"Salt, Iodized (25 KG sacks)",null,{"$f":"0.035","v":0.035},{"v":25,"d":"25.00"},"Sack"]
[null,"Salt, Iodized (50 KG sacks)",null,{"v":0.07,"d":"0.070"},{"v":50,"d":"50.00"},"Sack"]
[null,"Sorghum (100 KG sacks)",null,{"v":0.16,"d":"0.160"},{"v":100,"d":"100.00"},"Sack"]
[null,"Sorghum (50 KG sacks)",null,{"v":0.08,"d":"0.080"},{"v":50,"d":"50.00"},"Sack"]
[null,"UNIMIX",null,{"v":0.04,"d":"0.040"},{"v":25,"d":"25.00"},"Sack"]
[null,"Veg oil, 200 L Drums",null,{"$f":"210/1000","v":{"v":0.21,"d":"0.210"}},{"$f":"(4.6/5)*208","v":{"v":191.35999999999999,"d":"191.36"}},"Drum"]
[null,"Veg oil, 4L Tins",null,{"$f":"1.1*0.004*6","v":{"v":0.0264,"d":"0.026"}},{"$f":"1.05*((4.6/5)*4)*6","v":{"v":23.183999999999997,"d":"23.18"}},"Carton of 6"]
[null,"Veg oil, 5L Jugs",null,{"$f":"1.1*0.005*4","v":{"v":0.022000000000000002,"d":"0.022"}},{"$f":"1.05*((4.6/5)*5)*4","v":19.32},"Carton of 4"]
[null,"Veg, 20L Drums",null,{"$f":"1.1*(20/1000)","v":{"v":0.022000000000000002,"d":"0.022"}},{"$f":"1.05*((4.6/5)*20)","v":19.32},"Drum"]
[null,"Wheat Flour, AP",null,{"v":0.08,"d":"0.080"},{"v":50,"d":"50.00"},"Sack"]
[null,"Wheat Flour, bread ",null,{"v":0.08,"d":"0.080"},{"v":50,"d":"50.00"},"Sack"]
[null,"Wheat Soy Blend (WSB)",null,{"v":0.04,"d":"0.040"},{"v":25,"d":"25.00"},"Sack"]
[null,"Wheat Soy Milk (WSM)",null,{"v":0.04,"d":"0.040"},{"v":25,"d":"25.00"},"Sack"]