{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Requirement calculator","Cost calculator"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":27,"comments":1,"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":"Requirement calculator","index":0,"n_rows":47,"n_cols":11,"rows_kept":47,"cut":false,"hidden":false,"merged":[[46,2,46,14],[7,2,7,8],[7,10,7,11],[30,2,30,8],[30,10,30,11]]}
[]
[]
[null,null,"How much plastic mulch do you need per acre?"]
[null,null,"System of units shown:",null,null,"ENGLISH UNITS"]
[]
[null,null,"This information is used to calculate the number of rolls of mulch that would be needed per acre based on roll length."]
[]
[null,null,"In the box on the right, enter the spacing based on the distance between bed centers then click the \"Calculate\" button:",null,null,null,null,null,null,null,"ft (bed center \nto bed center)"]
[]
[null,null,"You will need:"]
[]
[null,null,null,"500 ft roll, or"]
[]
[null,null,null,"750 ft roll, or"]
[]
[null,null,null,"1,000 ft roll, or"]
[]
[null,null,null,"3,000 ft roll, or"]
[]
[null,null,null,"4,000 ft roll, or"]
[]
[null,null,null,"6,000 ft roll, or"]
[]
[]
[]
[null,null,"How much plastic mulch do you need per hectare?"]
[null,null,"System of units shown:",null,null,"METRIC SYSTEM UNITS"]
[]
[null,null,"This information is used to calculate the number of rolls of mulch that would be needed per hectare based on roll length."]
[]
[null,null,"In the box on the right, enter the spacing based on the distance between bed centers then click the \"Calculate\" button:",null,null,null,null,null,null,null,"m (bed center \nto bed center)"]
[]
[null,null,"You will need:"]
[]
[null,null,null,"152.4 m roll, or"]
[]
[null,null,null,"228.6 m roll, or"]
[]
[null,null,null,"304.8 m roll, or"]
[]
[null,null,null,"914.4 m roll, or"]
[]
[null,null,null,"1,219.2 m roll, or"]
[]
[null,null,null,"1,828.8 m roll, or"]
[]
[null,null,"The length of roll shown here is equivalent to the length of roll that is revealed in the box in the previous section; for instance, 152.4 m = 500 ft. "]

{"sheet":"Cost calculator","index":1,"n_rows":135,"n_cols":18,"rows_kept":135,"cut":false,"hidden":false,"merged":[[2,1,2,11],[6,15,6,17],[12,15,12,17],[129,7,130,7],[4,1,5,11],[63,1,63,11],[83,1,83,11],[104,1,104,11]]}
[]
[null,"Please choose the units you prefer:"]
[null,"Your choice will only reflect the units below following English units (acre, foot, mil, pound) or the metric system (meter, hectare, kilogram). It will not do conversions of actual numbers from one system of units to another."]
[]
[null,"Please enter your numbers and other information in the blue colored boxes. These are needed to calculate  the per acre cost comparisons between the two types of mulches (see gray box on the right).  Details in the blue colored boxes you see below are examples only. Please modify them as applicable to your own operation. Numbers in white and gray boxes cannot be changed because the boxes contain the formulas for the calculations. Estimated total costs for installation and clean-up of the two types of mulches are shown and compared in the gray box. Activities listed under Polyethylene Plastic Mulch and Biodegradable Mulch can also be changed as necessary to reflect your own operation."]
[]
[null,"A. Information about the Field that Uses Mulch"]
[]
[null,"Production area ",null,null,null,4,null,"acre/s"]
[]
[null,"Crop/s grown",null,null,null,"pumpkin and other vegetables"]
[]
[null,"B. Mulch Required - Description, Quantity and Cost",null,null,null,null,null,null,null,null,null,null,null,null,null,"Per Acre Cost Comparison"]
[]
[null,"1. Polyethylene (PE) Plastic Mulch",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PE Plastic Mulch","Biodegradable Mulch"]
[]
[null,"Name of product",null,null,null,"PE",null,null,null,null,null,null,null,null,null,"Mulch Installation"]
[]
[null,"Color",null,null,null,"black",null,null,null,null,null,null,null,null,null,"Machinery ",{"$f":"$N$57+$N$59","v":108.75},{"$f":"$N$57+$N$59","v":108.75}]
[]
[null,"Thickness",null,null,null,1,null,"mil",null,null,null,null,null,null,null,"Material",{"$f":"$F$27*$F$29","v":405},{"$f":"$F$47*$F$49","v":1050}]
[]
[null,"Roll lengthA",null,null,null,3000,null,"ft",null,null,null,null,null,null,null,"Installation labor",{"$f":"$L$71","v":240},{"$f":"L71","v":240}]
[]
[null,"Number of rolls neededA",null,null,null,2.9,null,"rolls per acre",null,null,null,null,null,null,null,"End-of season"]
[]
[null,"Actual number of rolls purchased",null,null,null,3,null,"rolls per acre",null,null,null,null,null,null,null,"Mulch removal",{"$f":"SUM($N$77,$N$79,$L$89,$L$91,$L$93,$L$95,$L$97,$L$99,$L$101,$L$103)","v":682.5},0]
[]
[null,"Cost of mulch per roll",null,null,null,135,null,"$ per roll",null,null,null,null,null,null,null,"Mulch disposal",{"$f":"$F$115*$F$117","v":15.587500000000002},0]
[]
[null,"Weight of mulch",null,null,null,86,null,"pounds per roll",null,null,null,null,null,null,null,"Mulch tilled into the soil",0,{"$f":"$F$124+$F$126+$L$133+L135","v":244.5}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Cost",{"$f":"SUM(Q19:Q31)","v":1451.8375000000001},{"$f":"SUM(R19:R31)","v":1643.25}]
[]
[null,"2. Biodegradable Mulch (BDM)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Difference in Using Biodegradable Mulch",null,{"$f":"R33-Q33","v":191.41249999999991}]
[]
[null,"Name of product",null,null,null,"BDM"]
[]
[null,"Color",null,null,null,"black"]
[]
[null,"Thickness",null,null,null,1,null,"mil"]
[]
[null,"Roll lengthA",null,null,null,3000,null,"ft"]
[]
[null,"Number of rolls neededA",null,null,null,2.9,null,"rolls per acre"]
[]
[null,"Actual number of rolls purchased",null,null,null,3,null,"rolls per acre"]
[]
[null,"Cost of mulch per roll",null,null,null,350,null,"$ per roll"]
[]
[null,"AInformation obtained from \"Requirement calculator\"."]
[]
[null,"C. Mulch Installation (same for PE Mulch and BDM)"]
[null,"1. Machinery Cost"]
[null,"Machine",null,"Purchase cost",null,"Expected useful life (number of years)",null,"Salvage valueB",null,"Interest costC",null,"Depreciation costD",null,"Cost ($/acre)"]
[]
[null,"Mulch layer",null,6000,null,20,null,600,null,{"$f":"IF(ISBLANK(D57), \"0\", (((D57+H57)/2)*$F$62))","v":165},null,{"$f":"IF(ISBLANK(D57), \"0\", IF(ISBLANK(F57), \"0\", IF(ISBLANK(H57), \"0\", ((D57-H57)/F57))))","v":270},null,{"$f":"(J57+L57)/$F$9","v":108.75}]
[]
[null,"Other:",null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(D59), \"0\", (((D59+H59)/2)*$F$62))","v":"0"},null,{"$f":"IF(ISBLANK(D59), \"0\", IF(ISBLANK(F59), \"0\", IF(ISBLANK(H59), \"0\", ((D59-H59)/F59))))","v":"0"},null,{"$f":"(J59+L59)/$F$9","v":0}]
[]
[]
[null,"Interest rate (%)",null,null,null,0.05]
[]
[null,"B Enter your estimate for the salvage value. Salvage Value refers to the value of an asset at the end of its useful life. In general, a salvage value will be a positive value. However, it may be zero if the asset will be used until it is completely worn out and will have no scrap value at the end of its useful life."]
[null,"C Interest Cost is calculated as: (Total Purchase Price + Salvage Value)/2 x Interest Rate."]
[null,"D Depreciation cost is calculated as straight line depreciation: (Total Purchase Price - Salvage Value)/Years of Expected Useful Life."]
[]
[null,"2. Labor Cost"]
[null,"Activity",null,"Machine",null,"Time spent (hour/acre)",null,"No. of workers",null,"Wage rate ($/hour)",null,"Total cost ($/acre)"]
[]
[null,"Installation",null,"Using mulch layer",null,8,null,2,null,15,null,{"$f":"F71*H71*J71","v":240}]
[]
[null,"D. PE Mulch - Removal"]
[null,"1. Machinery CostE"]
[null,"Machine",null,"Purchase cost",null,"Time spent (hour/acre)",null,"Salvage value",null,"Interest cost",null,"Total cost ($/acre)",null,"Cost ($/acre)"]
[]
[null,"Machine 1",null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(D77), \"0\", (((D77+H77)/2)*$F$82))","v":"0"},null,{"$f":"IF(ISBLANK(D77), \"0\", IF(ISBLANK(F77), \"0\", IF(ISBLANK(H77), \"0\", ((D77-H77)/F77))))","v":"0"},null,{"$f":"(J77+L77)/$F$9","v":0}]
[]
[null,"Other:",null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(D79), \"0\", (((D79+H79)/2)*$F$62))","v":"0"},null,{"$f":"IF(ISBLANK(D79), \"0\", IF(ISBLANK(F79), \"0\", IF(ISBLANK(H79), \"0\", ((D79-H79)/F79))))","v":"0"},null,{"$f":"(J79+L79)/$F$9","v":0}]
[]
[]
[null,"Interest rate (%)",null,null,null,0.05]
[]
[null,"E Please list the machine purchased to remove plastic mulch, if any (for example, plastic mulch lifter). Salvage value, interest cost and depreciation cost are calculated the same as in Section C above."]
[]
[null,"2. Labor CostF"]
[null,"Activity",null,"Method usedG",null,"Time spent (hour/acre)",null,"No. of workers",null,"Wage rate ($/hour)",null,"Total cost ($/acre)"]
[]
[null,"Loosening shoulders",null,"Manual",null,10,null,1,null,13,null,{"$f":"F89*H89*J89","v":130}]
[null,null,null,"Manual"]
[null,"Removing plants",null,"Manual",null,1.5,1,2,null,13,null,{"$f":"F91*H91*J91","v":39}]
[]
[null,"Pulling plasticH",null,"Manual",null,8,null,3,null,13,null,{"$f":"F93*H93*J93","v":312}]
[]
[null,"Rolling up plastic",null,"Manual",null,3,null,3,null,13,null,{"$f":"F95*H95*J95","v":117}]
[]
[null,"Cleaning up remnants",null,"Manual",null,6,null,1,null,13,null,{"$f":"F97*H97*J97","v":78}]
[]
[null,"Disposing plastic",null,"Manual",null,0.5,null,1,null,13,null,{"$f":"F99*H99*J99","v":6.5}]
[]
[null,"Other:",null,null,null,null,null,null,null,null,null,{"$f":"F101*H101*J101","v":0}]
[]
[null,"Other:",null,null,null,null,null,null,null,null,null,{"$f":"F103*H103*J103","v":0}]
[]
[null,"FIf it is difficult to list a breakdown of activities and only a lump sum or total cost is available, you can leave the cells blank in columns F, H, and J and enter the lump sum value under \"Total Cost\". For instance, if you can only provide the lump sum cost for disposal, you can simply enter \"Disposing Plastic\" in row 89-column B, leave the other rows 91-103 blank, and enter the corresponding cost in row 89-column L . "]
[null,"GIndicate if an activity is done manually or if a machine used (e.g., tractor with roller, end of bed roller, etc.)."]
[null,"HIf there is drip tape, the tape is traditionally removed simultaneously with the plastic mulch."]
[]
[null,"2. Dumping Fee"]
[null,"Initial mulch weight",null,null,null,{"$f":"F25*F31","v":249.4},null,"pounds per acre"]
[]
[null,"Estimated increase in weight of"]
[null,"mulch due to dirt and other debris",null,null,null,0.25,null,"percent"]
[]
[null,"Weight of plastic to be disposed",null,null,{"$f":"((E110 * (1 + E113)) * 0.0005) *(0.907185/0.404686)","v":0},{"$f":"((F110 * (1 + F113)) * 0.0005)","v":0.15587500000000001},null,"ton per acre"]
[]
[null,"Dumping fee",null,null,null,100,null,"$ per ton"]
[]
[]
[null,"E. BDM - Tillage"]
[null,"1. Machinery Cost for Tillage"]
[null,"Machine",null,"Description",null,"Total cost ($/acre)"]
[]
[null,"Tractor + rototiller",null,"Fuel",null,10]
[]
[null,"Other:",null,"Maintenance",null,5]
[]
[]
[null,"2. Labor Cost"]
[null,"Activity",null,"Method used",null,"Time spent ",null,"No. of workers",null,"Wage rate ",null,"Total cost "]
[null,null,null,null,null,"(hour/acre)",null,null,null,"($/hour)",null,"($/acre)"]
[]
[null,"Pulling drip tape",null,"Manual",null,1.5,null,1,null,13,null,{"$f":"F133*H133*J133","v":19.5}]
[]
[null,"Tilling mulch into the soil",null,"Tractor with rototiller",null,7,null,2,null,15,null,{"$f":"F135*H135*J135","v":210}]