{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Cover Page","Egg Tool v1","Pork Tool "],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":0,"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":"Cover Page","index":0,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[7,3,7,10],[9,4,9,10],[11,4,11,10]]}
[]
[]
[]
[]
[]
[]
[null,null,null,"Australian Pork Solar PV and Thermal Tool "]
[null,null,null,"© All Energy Pty Ltd, 2022"]
[]
[null,null,null,null,"Dramatically rising costs of grid power mean that pork agribusinesses need innovative energy solutions. All Energy Pty Ltd has created this tool to assess the feasibility of solar photovoltaic (PV) arrays at your business, reducing costs and ensuring your future energy supply security."]
[]
[null,null,null,null,"Before using this tool, you will need a copy of a current power bill showing volume [$/kWh] charges and a gas bill showing volume [$/MJ, $/L etc] charges"]

{"sheet":"Egg Tool v1","index":1,"n_rows":39,"n_cols":20,"rows_kept":39,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"$/kWh","$/kVA","kWh/kW/day","Array kW","STC value"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Adelaide",0.19,0,4.2,{"$f":"$P$17/R3","v":200},{"$f":"1.3753*$K$27*$P$20*P19","v":112554.55200000001}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alice Springs",0.2,0,5,{"$f":"$P$17/R4","v":168},{"$f":"1.6143*$K$27*$P$20*P19","v":132114.31200000001}]
[null,null,null,null,null,null,null,null,null,"Australian Eggs Solar PV Tool",null,null,null,null,"Brisbane",0.11,0.27,4.2,200,{"$f":"1.3753*$K$27*$P$20*P19","v":112554.55200000001}]
[null,null,null,null,null,null,null,null,null,"© All Energy Pty Ltd, 2019",null,null,null,null,"Cairns",0.14000000000000001,0.99,4.2,200,{"$f":"1.3753*$K$27*$P$20*P19","v":112554.55200000001}]
[null,null,null,null,null,null,null,null,null,"Input Farm Information",null,null,null,null,"Canberra",0.21,0.14000000000000001,4.3,195.34883720930233,{"$f":"1.3753*$K$27*$P$20*P19","v":112554.55200000001}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Darwin",0.2,0,4.4000000000000004,190.90909090909091,{"$f":"1.5288*$K$27*$P$20*P19","v":125116.992}]
[null,null,null,null,null,null,null,null,null,"Number of Sheds at My Farm",8,null,null,null,"Hobart",0.16,0.42,3.5,240,{"$f":"1.1769*$K$27*$P$20*P19","v":96317.496000000014}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Melbourne",0.04,0.3,3.6,233.33333333333331,{"$f":"1.1769*$K$27*$P$20*P19","v":96317.496000000014}]
[null,null,null,null,null,null,null,null,null,"Shed Length [m]",120,null,null,null,"Perth ",0.21,1.45,4.4000000000000004,190.90909090909091,{"$f":"1.3753*$K$27*$P$20*P19","v":112554.55200000001}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sydney",0.05,0.34,3.9,215.38461538461539,{"$f":"1.3753*$K$27*$P$20*P19","v":112554.55200000001}]
[null,null,null,null,null,null,null,null,null,"Shed Width [m]",30]
[]
[null,null,null,null,null,null,null,null,null,"I Want to Offset What % of My kWh with Solar PV",0.3,null,null,null,"Intermediate Calculations"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Daily kWh",{"$f":"350*K9","v":2800}]
[null,null,null,null,null,null,null,null,null,"Interest in Batteries","No Battery",null,null,null,"Array kWh",{"$f":"P16*K15","v":840}]
[]
[null,null,null,null,null,null,null,null,null,"My Farm is Closest to","Brisbane",null,null,null,"STC Value",34.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Deeming Period",12]
[null,null,null,null,null,null,null,null,null,"Power Volume Price [$/kWh]",{"$f":"VLOOKUP(K19,O3:T12,2,FALSE)","v":0.11}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LGC Value",46.075000000000003]
[null,null,null,null,null,null,null,null,null,"Power Demand Price [$/kVA/day or $/kW/day]",{"$f":"VLOOKUP(K19,O3:T12,3,FALSE)","v":0.27}]
[]
[null,null,null,null,null,null,null,null,null,"System Design"]
[]
[null,null,null,null,null,null,null,null,null,"Solar Array Rating [kW]",{"$f":"VLOOKUP(K19,O3:S12,5,FALSE)","v":200}]
[]
[null,null,null,null,null,null,null,null,null,"Battery Rating [kWh]",{"$f":"IF(K17=\"Peak Shaving\",K9/8*50*2,0)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Roof Area Covered by Solar Array [% of 1 Shed]",{"$f":"(K27*1.712976/0.33)/(K11*K13)","v":0.28837979797979801}]
[]
[null,null,null,null,null,null,null,null,null,"Cost Benefit Analysis"]
[]
[null,null,null,null,null,null,null,null,null,"Capital Cost",{"$f":"IF(K27<100,2139.6*K27^0.9409+2055.4*K29^0.7763-VLOOKUP(K19,O3:T12,6,FALSE),2139.6*K27^0.9409+2055.4*K29^0.7763)","v":312875.61201790988}]
[]
[null,null,null,null,null,null,null,null,null,"Savings per Annum",{"$f":"P17*365*K21*0.85+K29*365*0.85*K21+K9/8*50*K23*365*0.85+IF(K27>=100,P17/1000*365*P22,0)","v":46982.07}]
[]
[null,null,null,null,null,null,null,null,null,"Simple Payback [years]",{"$f":"K35/K37","v":6.6594684316359389}]

{"sheet":"Pork Tool ","index":2,"n_rows":70,"n_cols":16,"rows_kept":70,"cut":false,"hidden":false,"merged":[[35,3,35,4],[29,3,29,4],[14,10,16,10],[7,3,7,4],[44,3,44,4],[32,3,32,4],[38,3,38,4],[41,3,41,4]]}
[]
[null,null,null,null,null,null,null,null,null,"$/kWh","$/kVA/day","kWh/kW/day","Array kW","STC value",null,"$/GJ"]
[null,null,null,null,null,null,null,null,"Adelaide",0.19,0,4.2,{"$f":"$J$22/L3","v":17.31898238747554},{"$f":"1.3753*$E$49*$J$24*J23","v":9289.3306262230926},0.93,15]
[null,null,null,null,null,null,null,null,"Alice Springs",0.2,0,5,{"$f":"$J$22/L4","v":14.547945205479454},{"$f":"1.6143*$E$49*$J$24*J23","v":10903.632974559689},0.78,30]
[null,null,null,"Australian Pork Solar PV and Solar Thermal Tool",null,null,null,null,"Brisbane",0.11,0.27,4.2,17.31898238747554,{"$f":"1.3753*$E$49*$J$24*J23","v":9289.3306262230926},0.93,20]
[null,null,null,"© All Energy Pty Ltd, 2021",null,null,null,null,"Cairns",0.14000000000000001,0.99,4.2,17.31898238747554,{"$f":"1.3753*$E$49*$J$24*J23","v":9289.3306262230926},0.93,25]
[null,null,null,null,null,null,null,null,"Canberra",0.21,0.14000000000000001,4.3,16.916215355208667,{"$f":"1.3753*$E$49*$J$24*J23","v":9289.3306262230926},0.91,15]
[null,null,null,"PRODUCT DISCLAIMER: While all possible care has gone into ensuring that the below techincal and cost figures are as accurate as possible, the below calculator and accompanying checklist should be used as a guidance tool only and not relied on as a sole source of information for making a business decision. ",null,null,null,null,"Darwin",0.2,0,4.4000000000000004,16.531755915317561,{"$f":"1.5288*$E$49*$J$24*J23","v":10326.131506849315},0.89,20]
[null,null,null,null,null,null,null,null,"Hobart",0.16,0.42,3.5,20.782778864970648,{"$f":"1.1769*$E$49*$J$24*J23","v":7949.2570450097865},1.1100000000000001,20]
[null,null,null,"My Farm Information",null,null,null,null,"Melbourne",0.04,0.3,3.6,20.205479452054796,{"$f":"1.1769*$E$49*$J$24*J23","v":7949.2570450097865},1.08,15]
[null,null,null,null,null,null,null,null,"Perth ",0.21,1.45,4.4000000000000004,16.531755915317561,{"$f":"1.3753*$E$49*$J$24*J23","v":9289.3306262230926},0.89,20]
[null,null,null,"Farrow to Wean or Finish","Wean to Finish",null,null,null,"Sydney",0.05,0.34,3.9,18.651211801896736,{"$f":"1.3753*$E$49*$J$24*J23","v":9289.3306262230926},1,15]
[]
[null,null,null,"Pigs Raised per Year",15000,null,null,null,"Intermediate Calculations",null,null,"Elec kWh","Heating"]
[null,null,null,null,null,null,null,null,"Farrow to Finish",20.399999999999999,"kWh/pig/yr total",{"$f":"J15*$E$14/365*0.51+J15*$E$19*$E$14*0.49/365","v":838.35616438356169},{"$f":"M21*E14/365","v":410.79452054794513}]
[null,null,null,"My Farm is Closest to ","Brisbane",null,null,null,"Farrow to Wean",14.5,null,{"$f":"J16*$E$14/365*0.31+J16*$E$19*$E$14*0.69/365","v":595.89041095890411},{"$f":"M15","v":410.79452054794513}]
[null,null,null,null,null,null,null,null,"Wean to Finish",{"$f":"J15-J16","v":5.8999999999999986},null,{"$f":"L15-L16","v":242.46575342465758},0]
[null,null,null,"Heating Done By",null,null,null,null,"Pigs per litter",12]
[null,null,null,"Electricity",1,null,null,null,"Breed+Gestation+Raising",10,"months"]
[null,null,null,"Gas",0.1,null,null,null,"Litters per year",{"$f":"12/J19","v":1.2}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"J15*0.49","v":9.9959999999999987},"for heating"]
[null,null,null,"Electricity Currently Supplied By",null,null,null,null,"Array kWh",{"$f":"E29*E35","v":72.739726027397268}]
[null,null,null,"Grid",1,null,null,null,"STC Value",39]
[null,null,null,"Solar",0.2,null,null,null,"Deeming Period",10]
[null,null,null,"Diesel Generator",0.1,null,null,null,"LGC Value -5% handling",{"$f":"40.4*0.95","v":38.379999999999995},null,null,"https://www.demandmanager.com.au/certificate-prices/","Accessed 17/11/2021"]
[]
[null,null,null,"Energy Calculations",null,null,null,null,"Equivalent power price",{"$f":"E23*E38+E24*0.04+E25*E44/36*1000/277.78/0.3","v":0.15133306666879998},"$/kWh"]
[null,null,null,null,null,null,null,null,"Equivalent heating price",{"$f":"E19*J27*277.78+E20*E41","v":44.23729925925926},"$/GJ"]
[null,null,null,"Daily kWh Consumption - Electrical",{"$f":"VLOOKUP(E12,I15:L17,4,0)","v":242.46575342465758}]
[null,null,null,"Note that this number is likely to vary +/- 25% between Winter and Summer. The above is an average figure for the whole year"]
[]
[null,null,null,"Daily kWh Consumption - Heating",3]
[null,null,null,"Note that if heating is done by heat lamps, the above number is a part of the daily electrical kWh consumption i.e. the two above numbers are not added together"]
[]
[null,null,null,"I Want to Offset Electricity Usage [kWh] at My Farm by: ",0.3," "]
[null,null,null,"Note that without a battery, the offsettable kWh will be limited by % of usage during the day (i.e. pumping, ventilation, lighting, and daytime heating) - typically ~30%"]
[]
[null,null,null,"Power Volume Price [$/kWh]",{"$f":"VLOOKUP(E16,I3:P12,2,FALSE)","v":0.11}]
[null,null,null,"Above number is assumed based on your location and can be overwritten - refer to your power bill (use peak $/kWh if charged a time-of-use tariff)"]
[]
[null,null,null,"Gas Price [$/GJ]",22]
[null,null,null,"Above number is assumed and can be overwritten - refer to your gas bill (you may need to convert units, if so, multiply by 40.98 for LPG charged $/L or 1000 for natural gas charged $/MJ)"]
[null,null,null,null,null,null,null,null," "]
[null,null,null,"Diesel Price [$/L]",{"$f":"IF(E25>0,1,0)","v":1}]
[null,null,null,"This is the price you pay per litre minus the ATO off road rebate of 43.3 c/L"]
[]
[null,null,null,"PV Solar System Design"]
[]
[null,null,null,"Solar Array Rating [kWp]",{"$f":"VLOOKUP(E16,I3:M12,5,FALSE)","v":17.31898238747554}]
[null,null,null," "]
[null,null,null,"Solar Thermal System Design"]
[]
[null,null,null,"Solar Thermal Array [kWt]",{"$f":"(E32*365/277.78)/6.57*1.2*VLOOKUP(E16,I3:O12,7,FALSE)","v":0.66959464324285412}]
[]
[null,null,null,"Cost Benefit Analysis"]
[]
[null,null,null,"Ground Mounted Solar"]
[null,null,null,"Capital Cost ",{"$f":"IF(E49<100,1660*E49^0.95+220*E49,1660*E49^0.95+220*E49)","v":28739.146418877321}]
[null,null,null,"Savings per Annum",{"$f":"J22*365*J27+IF(E49>=100,J22*J25/1000*365,0)","v":4017.8929200566399}]
[null,null,null,"Simple Payback [years]",{"$f":"E58/E59","v":7.152790527446955}]
[]
[null,null,null,"Roof Mounted Solar"]
[null,null,null,"Capital Cost ",{"$f":"IF(E49<100,960*E49^0.95+220*E49,960*E49^0.95+220*E49)","v":18226.93002999606}]
[null,null,null,"Savings per Annum",{"$f":"E59","v":4017.8929200566399}]
[null,null,null,"Simple Payback [years]",{"$f":"E63/E64","v":4.5364399680763805}]
[]
[null,null,null,"Solar Thermal"]
[null,null,null,"Capital Cost ",{"$f":"(E53/800)^0.7*249007","v":1746.2923221395404}]
[null,null,null,"Savings per Annum",{"$f":"IF(E18=\"Gas\",E32*365/277.78*J28,E32*365*J27)","v":165.70970800233599}]
[null,null,null,"Simple Payback [years]",{"$f":"E68/E69","v":10.538262019717777}]