{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["About this workbook","Disclaimer","Textbook","Output graph","Discounted cash flow","Cost of Manuf COMd modified","CEPCI","CAPEX via paper Malmali et al"," CAPEX Grundt et al 6 10 rule","H-B Capex from Ammoniaenergy.or","CAPEX by DOE for electrolysis","Reverse Osmosis CAPEX","Renewable H2 Tax Credit","CAPEX Haber Bosch","CAPEX NH3 storage","CAPEX Instrument. and control","Ammonia price history"],"not_rendered":{"charts":2,"images":11,"macros":1,"external_links":0,"defined_names":0,"comments":2,"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":"About this workbook","index":0,"n_rows":25,"n_cols":6,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Purpose: calculate NPV for 10tpd ammonia plant"]
[]
[]
[null,"2022-11-18","v.1.3","Pfromm",null,"Pick CAPEX financed via loan paid back at fixed interest rate, or equity financing"]
[null,null,null,null,null,"CAPEX from Malmali et al scaled to 10tpd corrected for 2022.  CAPEX scaled linearly for electrolysis. Other CAPEX sheets for info/reference only"]
[null,null,null,null,null,"Enter  input in yellow highlight fields"]
[null,null,null,null,null,"Cost of manufacturing modified from Turton"]
[null,null,null,null,null,"Loan payments subtracted from revenue R, PRE TAX, if loan option is selected"]
[]
[null,"2022-11-21",null,"Pfromm",null,"Added Sheet H B Capex from Ammoniaenergy, which confirms the 12MM for 10 tpd plant"]
[null,null,null,null,null,"No interactions with other sheets."]
[]
[null,"2023-02-06",null,"Pfromm",null,"Implemented daily production as input, use goal/seek to determine NPV=0, to determine IRR"]
[null,null,null,null,null,"Number of full time positions now according to Turton et al."]
[]
[]
[null,"2023-02-14",null,"Pfromm",null,"Posted version 1.1 to INFEWS folder INFEWS 2-14-23"]
[null,null,null,null,null,"New version 1.2 started"]
[]
[null,"2023-10-18",null,"Pfromm",null,"removed loan option, renamed file \"What NH3 production pays off no loan version 1.0\", added sheet with overview of historic NH3 prices \"Ammonia price history\""]
[]
[null,"2023-10-25",null,"Pfromm",null,"added some comments in \"Discounted cash flow\" sheet, renamed workbook to \"What NH3 Production pays off 2.0\", added disclaimer sheet  \"Disclaimer\""]
[]
[null,"2024-02-08",null,"Pfromm",null,"start adding userform for data input"]

{"sheet":"Disclaimer","index":1,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"2023-10-25",null,"Pfromm",null,"All calculations in this workbook may contain errors, although the overall results were verified and benchmarked vs. literature data (from actual plant data for 1000 tpd plus scale,  paper studies for small scale) particularly for CAPEX."]
[null,null,null,null,null,"It is highly recommended to work through the appropriate chapters in the generally accepted and widely refrenced Textbook on which this is based."]
[null,null,null,null,null,"Note that very important  parameters such as ammonia price, and energy price are static in this workbook (see Textbook).  These parameters may be highly (ammonia price) or slowly (energy price) variable, and unpredictably so, with time."]
[null,null,null,null,null,"Even a Monte Carlo analysis of economics (easily performed, see Textbook) can never encompass disruptive changes such as wars, politically motivated pressures on markets, precipitous climate change impacts,  etc."]
[null,null,null,null,null,"Therefore Monte Carlo  is not done here."]

{"sheet":"Textbook","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Output graph","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Discounted cash flow","index":4,"n_rows":58,"n_cols":15,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
[null,null,"Ammonia Plant producing  selected  tonnes per day (user input) of anhydrous ammonia"]
[null,null,"INFLATION NOT TAKEN IN ACCOUNT (reasoning see Textbook).  TIME VALUE OF MONEY IS TAKEN IN ACCOUNT."]
[]
["Manual INPUTS:",null,"Tax credit per kg NH3 (for 10 years only)",{"$f":"'Renewable H2 Tax Credit'!C9","v":0.10559999999999999},"$/kg NH3 (converted from H2 tax credit)"]
["Yellow Highlights",null,"Desired production rate","10","Tonnes NH3 per day (metric tons)"]
[null,null,"Cap. Cost calculated",{"$f":"(12000000*0.4)*(D5/10)^0.6+(12000000*0.6)*(D5/10)^0.7","v":12000000}]
[null,null,"Ammonia sells for U.S.$",1100,"per tonne"]
[null,null,"Tax rate",0.3,{"$f":"D8*100","v":30},"%"]
[null,null,"Discount rate",0.05,{"$f":"D9*100","v":5},"%p.a."]
[]
[null,null,"Name Plate production",{"$f":"D5","v":"10"},"tpd ammonia"]
[null,null,"Days per year at Name Plate capacity",360,{"$f":"D12*24","v":8640},"hrs/yr"]
[null,null,"Cost of Land",25000]
[null,null,"Cost of Electrical Energy","0.02","/kWh",null,null,null,null,null,null,"For comparison: simple investment, constant annual interest, no inflation"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"D6","v":12000000},"invested at fixed",4,"%interest per year:"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"-FV((N15/100), N16,0,L15,1)","v":38920770.120330505},"after",{"$f":"C58","v":30},"years"]
[null,null,null,null,null,null,null,null,null,null,null,"(compound interest, no inflation)"]
[null,null,"Additional parameters for review",null,null,null,null,null,null,null,null,"verified via ","https://www.calculator.net/future-value-calculator.html"]
[null,null,"Annual Income",{"$f":"D12*D11*D7","v":3960000}]
[null,null," MACRS depreciation was used, 9.5 year class life, 5 year recovery"]
[null,null,"Number of full time positions",{"$f":"'Cost of Manuf COMd modified'!F26","v":3},"either per Textbook, or manual"]
[null,null,"Cost per Position per year","80000"]
[null,"Results","NPV",{"$f":"M58","v":1486740.160343389}]
[null,null,"at",{"$f":"LOOKUP(2,1/(NOT(ISBLANK(C:C))),C:C)","v":30},"years"]
[null,null,"Present Value Ratio PVR",{"$f":"(SUM(L31:L58)/(-SUM(L28:L30)))","v":1.1389212871554557}]
[]
[null,null,"End of Year","Investment","dK Depreciation","FCIL-sum dK","Revenue R per yr from sale of NH3","Cost of Manufacturing COMd","((R-COM-dK)*(1-t)+dK)+H2credit","Cash Flow","Cumul Cash Flow non-discounted","Discounted Cash Flow","Cumul Disc Cash Flow"]
[null,null,0,{"$f":"D13*-1","v":-25000},null,{"$f":"$D$6","v":12000000},null,null,{"$f":"((G28-H28-E28)*(1-$D$8)+E28)+$D$5*$D$12*'Renewable H2 Tax Credit'!C6*1000","v":0},{"$f":"D28","v":-25000},{"$f":"J28","v":-25000},{"$f":"D28","v":-25000},{"$f":"L28","v":-25000}]
[null,null,1,{"$f":"-0.6*$D$6*(1-$D$16)","v":-7200000},null,{"$f":"$D$6","v":12000000},{"$f":"$D$15*$D$16","v":0},null,0,{"$f":"D29+$D$16*G29","v":-7200000},{"$f":"K28+J29","v":-7225000},{"$f":"J29/((1+$D$9)^(ROW()-27))","v":-6530612.2448979588},{"$f":"M28+L29","v":-6555612.2448979588}]
[null,null,2,{"$f":"-0.4*$D$6*(1-$D$16)","v":-4800000},null,{"$f":"$D$6","v":12000000},{"$f":"$D$15*$D$16","v":0},null,{"$f":"((G30-H30-E30)*(1-$D$8)+E30)+$D$5*$D$12*'Renewable H2 Tax Credit'!C8*1000","v":0},{"$f":"D30+$D$16*G30","v":-4800000},{"$f":"K29+J30","v":-12025000},{"$f":"J30/((1+$D$9)^(ROW()-27))","v":-4146420.4729510848},{"$f":"M29+L30","v":-10702032.717849044}]
[null,"Startup beginning of year:",3,null,{"$f":"$D$6*0.2","v":2400000},{"$f":"D6-E31","v":9600000},{"$f":"(($D$19+$D$15*$D$16)-$D$16*$D$15)","v":3960000},{"$f":"'Cost of Manuf COMd modified'!$J$16","v":3168016.3200000003},{"$f":"((G31-H31-E31)*(1-$D$8)+E31)+$D$5*$D$12*'Renewable H2 Tax Credit'!$C$9*1000","v":1654548.5759999999},{"$f":"I31","v":1654548.5759999999},-10370451.424000001,1361201.2081385842,-9340831.5097104609]
[null,null,4,null,{"$f":"$D$6*0.32","v":3840000},{"$f":"D6-E31-E32","v":5760000},{"$f":"($D$19+$D$15*$D$16)-$D$16*$D$15","v":3960000},{"$f":"'Cost of Manuf COMd modified'!$J$16","v":3168016.3200000003},{"$f":"((G32-H32-E32)*(1-$D$8)+E32)+$D$5*$D$12*'Renewable H2 Tax Credit'!$C$9*1000","v":2086548.5759999999},{"$f":"I32","v":2086548.5759999999},-8283902.8480000012,1634865.4069035018,-7705966.1028069593]
[null,null,5,null,{"$f":"$D$6*0.192","v":2304000},{"$f":"D6-E31-E32-E33","v":3456000},3960000,{"$f":"'Cost of Manuf COMd modified'!$J$16","v":3168016.3200000003},{"$f":"((G33-H33-E33)*(1-$D$8)+E33)+$D$5*$D$12*'Renewable H2 Tax Credit'!$C$9*1000","v":1625748.5759999999},1625748.5759999999,-6658154.2720000017,1213158.6184712725,-6492807.484335687]
[null,null,6,null,{"$f":"$D$6*0.1152","v":1382400},{"$f":"D6-E31-E32-E33-E34","v":2073600},3960000,{"$f":"'Cost of Manuf COMd modified'!$J$16","v":3168016.3200000003},{"$f":"((G34-H34-E34)*(1-$D$8)+E34)+$D$5*$D$12*'Renewable H2 Tax Credit'!$C$9*1000","v":1349268.5759999999},1349268.5759999999,-5308885.6960000023,958899.98629445478,-5533907.4980412321]
[null,null,7,null,{"$f":"$D$6*0.1152","v":1382400},{"$f":"D6-E31-E32-E33-E34-E35","v":691200},3960000,{"$f":"'Cost of Manuf COMd modified'!$J$16","v":3168016.3200000003},{"$f":"((G35-H35-E35)*(1-$D$8)+E35)+$D$5*$D$12*'Renewable H2 Tax Credit'!$C$9*1000","v":1349268.5759999999},1349268.5759999999,-3959617.1200000024,913238.08218519518,-4620669.4158560373]
[null,null,8,null,{"$f":"$D$6*0.0576","v":691200},{"$f":"D6-E31-E32-E33-E34-E35-E36","v":0},3960000,{"$f":"'Cost of Manuf COMd modified'!$J$16","v":3168016.3200000003},{"$f":"((G36-H36-E36)*(1-$D$8)+E36)+$D$5*$D$12*'Renewable H2 Tax Credit'!$C$9*1000","v":1141908.5759999997},1141908.5759999997,-2817708.5440000026,736084.449595168,-3884584.9662608691]
[null,null,9,null,null,null,3960000,{"$f":"'Cost of Manuf COMd modified'!$J$16","v":3168016.3200000003},{"$f":"((G37-H37-E37)*(1-$D$8)+E37)+$D$5*$D$12*'Renewable H2 Tax Credit'!$C$9*1000","v":934548.57599999965},934548.57599999965,-1883159.9680000029,573731.75688404334,-3310853.209376826]
[null,null,10,null,null,null,3960000,{"$f":"'Cost of Manuf COMd modified'!$J$16","v":3168016.3200000003},{"$f":"((G38-H38-E38)*(1-$D$8)+E38)+$D$5*$D$12*'Renewable H2 Tax Credit'!$C$9*1000","v":934548.57599999965},934548.57599999965,-948611.39200000325,546411.19703242218,-2764442.0123444037]
[null,null,11,null,null,null,3960000,{"$f":"'Cost of Manuf COMd modified'!$J$16","v":3168016.3200000003},{"$f":"((G39-H39-E39)*(1-$D$8)+E39)+$D$5*$D$12*'Renewable H2 Tax Credit'!$C$9*1000","v":934548.57599999965},934548.57599999965,{"$f":"K38+J39","v":-14062.8160000036},520391.61622135458,-2244050.3961230488]
[null,null,12,null,null,null,3960000,{"$f":"'Cost of Manuf COMd modified'!$J$16","v":3168016.3200000003},{"$f":"((G40-H40-E40)*(1-$D$8)+E40)","v":554388.57599999977},554388.57599999977,540325.75999999617,294004.09840664145,-1950046.2977164073]
[null,null,13,null,null,null,3960000,{"$f":"'Cost of Manuf COMd modified'!$J$16","v":3168016.3200000003},{"$f":"((G41-H41-E41)*(1-$D$8)+E41)","v":554388.57599999977},554388.57599999977,1094714.3359999959,280003.90324442054,-1670042.3944719867]
[null,null,14,null,null,null,3960000,{"$f":"'Cost of Manuf COMd modified'!$J$16","v":3168016.3200000003},554388.57599999977,554388.57599999977,1649102.9119999958,266670.38404230517,-1403372.0104296815]
[null,null,15,null,null,null,3960000,{"$f":"'Cost of Manuf COMd modified'!$J$16","v":3168016.3200000003},554388.57599999977,554388.57599999977,2203491.4879999957,253971.79432600495,-1149400.2161036765]
[null,null,16,null,null,null,3960000,{"$f":"'Cost of Manuf COMd modified'!$J$16","v":3168016.3200000003},554388.57599999977,554388.57599999977,2757880.0639999956,241877.89935809991,-907522.31674557657]
[null,null,17,null,null,null,3960000,{"$f":"'Cost of Manuf COMd modified'!$J$16","v":3168016.3200000003},554388.57599999977,554388.57599999977,3312268.6399999955,230359.90415057135,-677162.41259500524]
[null,null,18,null,null,null,3960000,{"$f":"'Cost of Manuf COMd modified'!$J$16","v":3168016.3200000003},554388.57599999977,554388.57599999977,3866657.2159999954,219390.38490530604,-457772.0276896992]
[null,null,19,null,null,null,3960000,{"$f":"'Cost of Manuf COMd modified'!$J$16","v":3168016.3200000003},554388.57599999977,554388.57599999977,4421045.7919999948,208943.22371933909,-248828.80397036011]
[null,null,20,null,null,null,3960000,{"$f":"'Cost of Manuf COMd modified'!$J$16","v":3168016.3200000003},554388.57599999977,554388.57599999977,4975434.3679999942,198993.54639937059,-49835.257570989517]
[null,null,21,null,null,null,3960000,{"$f":"'Cost of Manuf COMd modified'!$J$16","v":3168016.3200000003},554388.57599999977,554388.57599999977,{"$f":"K48+J49","v":5529822.9439999936},189517.66323749581,{"$f":"M48+L49","v":139682.4056665063}]
[null,null,22,null,null,null,3960000,{"$f":"'Cost of Manuf COMd modified'!$J$16","v":3168016.3200000003},554388.57599999977,554388.57599999977,6084211.519999993,180493.01260713881,320175.4182736451]
[null,null,23,null,null,null,3960000,{"$f":"'Cost of Manuf COMd modified'!$J$16","v":3168016.3200000003},554388.57599999977,554388.57599999977,6638600.0959999925,171898.10724489414,492073.52551853925]
[null,null,24,null,null,null,3960000,{"$f":"'Cost of Manuf COMd modified'!$J$16","v":3168016.3200000003},554388.57599999977,554388.57599999977,7192988.6719999919,163712.48309037538,655786.00860891468]
[null,null,25,null,null,null,3960000,{"$f":"'Cost of Manuf COMd modified'!$J$16","v":3168016.3200000003},554388.57599999977,554388.57599999977,7747377.2479999913,155916.65056226225,811702.65917117696]
[null,null,26,null,null,null,3960000,{"$f":"'Cost of Manuf COMd modified'!$J$16","v":3168016.3200000003},554388.57599999977,554388.57599999977,8301765.8239999907,148492.04815453547,960194.70732571243]
[null,null,27,null,null,null,3960000,{"$f":"'Cost of Manuf COMd modified'!$J$16","v":3168016.3200000003},554388.57599999977,554388.57599999977,8856154.3999999911,141420.99824241473,1101615.7055681271]
[null,null,28,null,null,null,3960000,{"$f":"'Cost of Manuf COMd modified'!$J$16","v":3168016.3200000003},554388.57599999977,554388.57599999977,9410542.9759999905,134686.66499277591,1236302.3705609031]
[null,null,29,null,null,null,3960000,{"$f":"'Cost of Manuf COMd modified'!$J$16","v":3168016.3200000003},554388.57599999977,554388.57599999977,9964931.5519999899,128273.01427883425,1364575.3848397373]
[null,null,30,{"$f":"D13","v":25000},null,null,3960000,{"$f":"'Cost of Manuf COMd modified'!$J$16","v":3168016.3200000003},554388.57599999977,{"$f":"I58","v":554388.57599999977},10519320.127999989,122164.77550365163,1486740.160343389]

{"sheet":"Cost of Manuf COMd modified","index":5,"n_rows":30,"n_cols":14,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Cost of Manufacturing, no discount  COMd"]
[]
[null,null,"Fixed Capital Investment FCI",null,null,{"$f":"'Discounted cash flow'!D6","v":12000000}]
[null,null,"Raw Materials",null,null,10000,"per year","estimate"]
[null,null,"Waste Treatment",null,null,10000,"per year","estimate"]
[null,null,"Utilities (electricity only)",null,null,{"$f":"M8*1000*H8","v":691200},"per year",{"$f":"'Discounted cash flow'!D14","v":"0.02"},"per kWh",0.4,"MW/ton, for  ton per day:",{"$f":"'Discounted cash flow'!D5","v":"10"},{"$f":"'Discounted cash flow'!D12*L8*J8*24","v":34560},"MWh per year"]
[null,null,"Direct Labor COL",null,null,{"$f":"F30","v":240000},"per year",{"$f":"F28","v":3},"Operators hired full time"]
[null,null,"Fixed Costs",null,null,"neglected"]
[]
[null,null,"COMd components",0.18,"*fixed cap =",{"$f":"D12*F5","v":2160000},null,"Modified",{"$f":"D12-0.016","v":0.16399999999999998},{"$f":"F5*I12","v":1967999.9999999998},null,"0.02 FCI instead of 0.036 FCI for Overhead costs; "]
[null,null,null,2.73,"*dir labor=",{"$f":"D13*F9","v":655200},null,null,{"$f":"D13-0.15-0.077","v":2.5030000000000001},{"$f":"I13*F9","v":600720},null,"0.15 COL eliminated (Laboratory), lowered admin from 0.177 COL to 0.1 COL"]
[null,null,null,1.23,"*(Raw mat +Waste Treat+Util).=",{"$f":"D14*(F6+F7+F8)","v":874776},null,null,{"$f":"D14","v":1.23},{"$f":"I14*SUM(F6:F8)","v":874776}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J12:J14)","v":3443496},null,"No R&D omit 0.05 COM, no Patents&Royalties omit 0.03 COM"]
[null,null,"COMd ","Textbook factors",null,{"$f":"SUM(F12:F14)","v":3689976},null,null,"COMd MODIFIED",{"$f":"J15-0.05*J15-0.03*J15","v":3168016.3200000003}]
[]
[]
[]
[]
[]
[]
[null,null,"Direct Labor ",null,"NOL=",{"$f":"(6.29+0.23*5)^0.5","v":2.7276363393971712},"operators per shift (no solids, 5 processing steps), see Turton et al."]
[]
[null,null,4.5,"operators hired per NOL ="]
[null,null,null,null,null,3,"Operators hired per textbook, can override and enter manually, for Textbook  formula is F23*C25"]
[]
[null,null,null,null,"set to",{"$f":"'Discounted cash flow'!D21","v":3},"Operators"]
[null,null,null,null,null,{"$f":"'Discounted cash flow'!D22","v":"80000"},"per operator per year"]
[null,null,null,null,null,{"$f":"F28*F29","v":240000},"per year"]

{"sheet":"CEPCI","index":6,"n_rows":3,"n_cols":3,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Chemical Engineering Plant Cost Index CEPCI via \"Chemical Engineering\", behind paywall"]

{"sheet":"CAPEX via paper Malmali et al","index":7,"n_rows":39,"n_cols":12,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Table 6",null,34260000,"Capex for ",20000,"metric tons NH3 per year"]
[null,null,null,null,"or",{"$f":"F9/360","v":55.555555555555557},"metric tons per day, 360 days"]
[]
[]
[]
[null,null,null,null,"Scale down to",10,"tons per day"]
[null,null,null,null,null,360,"days"]
[null,null,null,null,null,{"$f":"F15*F14","v":3600},"metric tons NH3 per year"]
[null,null,null,null,null,{"$f":"F9/F16","v":5.5555555555555554},"fold less production"]
[]
[null,"Textbook 6/10th downscaling"]
[null,"Scale down  to 10 tpd, use straight forward six-tenths rule for entire Capex:"]
[null,"Cost A/ Cost B = (Capacity A/Capacity B)^0.6"]
[null,"(Capac A/Capac B)^0.6=",{"$f":"(F9/F16)^0.6","v":2.7979277582846254}]
[]
[null,"solve for Cost B:"]
[null,"Cost B, 10 tpd:",{"$f":"D9/C22","v":12244776.477361366},"Capex 10tpd via 6/10 rule"]
[]
[null,"BUT: ","Per Paper, about 60% of Capex  is electrolysis, where electrolysis Capex scales linearly with H2 production. "]
[null,null,"For example,  electrolysis only: half the hydrogen production, half the electrolysis CAPEX"]
[null,"So electrolysis Capex",{"$f":"0.6*D9","v":20556000},"divide electrolysis Capex by",{"$f":"F17","v":5.5555555555555554},"times less production:",null,{"$f":"C29/F17","v":3700080},"Capex Electrolysis 10 ton per day"]
[null,"remainder Capex",{"$f":"D9-C29","v":13704000},"use 6/10 rule:",{"$f":"C22","v":2.7979277582846254},"factor:",null,{"$f":"C30/E30","v":4897910.5909445463},"Capex remainder 10 ton per day"]
[null,"Total Capex 56 tons/day",{"$f":"SUM(C29:C30)","v":34260000},null,null,null,"Tot",{"$f":"H29+H30","v":8597990.5909445472},"Total Capex, down scaled, from 56 tons per day to 10 tons per day, 360 days"]
[null,null,null,null,null,null,null,null,"correction for time below"]
[null,"adjust for 2022 cost index:"]
[null,"CEPCI 2020:",580,"I1 2020"]
[null,"CEPCI March 2022::",812,"I2"]
[null,null,null,null,"https://www.nxtbook.com/accessintelligence/ChemicalEngineering/chemical-engineering-june-intl-2022/index.php?startid=48#/p/48"]
[null,"C2=C1(I2/I1)"]
[]
[null,null,null,null,null,"Tot, corrected for 2022",null,{"$f":"H31*(C35/C34)","v":12037186.827322366},"Capex scaled from",null,{"$f":"F10","v":55.555555555555557},"tons per day to 10 tons per day"]

{"sheet":" CAPEX Grundt et al 6 10 rule","index":8,"n_rows":30,"n_cols":11,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,"Grundt et al, 1981"]
[]
[null,null,null,"From graph:"]
[]
[null,"500 tpd 2022:",null,500,"metric tons NH3 per day"]
[null,{"$f":"D12*E24/E23","v":328080808.0808081},null,120000000,"  in 1981, electrolysis based NH3"]
[null,"using CEPCI"]
[null,null,null,"scale down  to 10 tpd, use six-tenths rule:"]
[null,null,null,"Cost A/ Cost B = (Capacity A/Capacity B)^0.6=120,000,000/Cost B = (500/10)^0.6"]
[]
[null,null,null,"50^0.6=",{"$f":"50^0.6","v":10.456395525912733}]
[]
[null,null,null,"solve for Cost B:"]
[null,null,null,"Cost B, 10 tpd:",{"$f":"D12/E17","v":11476229.997480443}]
[]
[null,null,null,"adjust for 2021 cost index:"]
[null,null,null,"CEPCI 1981:",297,"I1"]
[null,null,null,"CEPCI March 2022::",812,"I2"]
[null,null,null,null,null,null,"https://www.nxtbook.com/accessintelligence/ChemicalEngineering/chemical-engineering-june-intl-2022/index.php?startid=48#/p/48"]
[null,null,null,"C2=C1(I2/I1)"]
[]
[]
[null,null,null,null,{"$f":"E20*(E24/E23)","v":31376090.094121613},"10 metric tons per day, 2022",null,null,null,null,"Including:"]
[null,null,null,null,null,"Capcost, direct + indirect see Table 3 from paper"]

{"sheet":"H-B Capex from Ammoniaenergy.or","index":9,"n_rows":34,"n_cols":18,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,null,"https://www.ammoniaenergy.org/articles/the-capital-intensity-of-small-scale-ammonia-plants/"]
[]
[null,null,null,"Example"]
[null,null,null,"Simplot $350MM 500 short ton per day, Rock Springs  Wyoming, Casale tech  and Linde, commissioned 2017, ",null,null,null,null,null,null,null,null,null,500,"short tons per day"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,454,"metric tons per day",null,{"$f":"365*0.9*N9","v":149139},"metric tons per year"]
[null,null,null,null,null,null,null,null,null,null,null,null,"CAPEX",350,"MM"]
[null,null,null,null,null,null,null,null,null,null,"Scale to 10tpd",null,null,"CostA/CostB=(Cap A/Cap B)^0.6"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Cap A =",10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"CapB=",{"$f":"N9","v":454}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"(CapA/Capb)^0.6",{"$f":"(O13/O14)^0.6","v":0.10133663717970962}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O16*N10","v":35.467823012898364},"MM","for 10 metric tons per day, conventional technology with steam reforming (?)"]
[]
[]
[null,null,null,"Conventional NH3"]
[null,null,null,"Upshot, small scale conventional) CAPEX 1900 to $2250 per ton per year"]
[null,null,null,"Use ",2000,"$ per ton NH3 produced per year",null,null,null,"$/(ton NH3/year)"]
[null,null,null,null,3600,"ton NH3 per year produced "]
[]
[null,null,null,null,{"$f":"E22*E23","v":7200000},"for",{"$f":"E23/360","v":10},"ton per day at",null,360,"days per year"]
[]
[null,null,null,"This is 2017 data"]
[]
[]
[null,null,null,"CEPCI",2017,568]
[null,null,null,null,2022,812]
[]
[null,null,null,null,{"$f":"(F31/F30)*E25","v":10292957.746478874},null,{"$f":"G25","v":10},"ton per day at",null,360,"days per year"]
[null,null,null,null,"Conventional H-B plant, 2022"]

{"sheet":"CAPEX by DOE for electrolysis","index":10,"n_rows":19,"n_cols":8,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,"https://www.hydrogen.energy.gov/pdfs/20004-cost-electrolytic-hydrogen-production.pdf"]
[]
[null,null,2020]
[]
[null,null,"Capcost PEM electrolyzer ",null,null,1000,"$/kW"]
[]
[null,null,"need ",null,null,4,"MW, 10tpd","Pfromm paper 2017"]
[null,null,null,null,"or",{"$f":"F10*1000","v":4000},"kW"]
[]
[null,null,null,null,null,{"$f":"F11*F8","v":4000000},"2020 CAPEX for ten ton per day ammonia, electrolysis only"]
[]
[null,null,"Adjust for time"]
[null,null,"CEPCI March 2022::",null,null,812]
[null,null,"CEPCI 2020",null,null,596.20000000000005,null,"https://www.toweringskills.com/financial-analysis/cost-indices/"]
[]
[null,null,null,null,null,{"$f":"(F16/F17)*F13","v":5447836.2965447828},"2022 CAPEX for ten ton per day ammonia, PEM electrolysis \"System Capex\""]

{"sheet":"Reverse Osmosis CAPEX","index":11,"n_rows":8,"n_cols":7,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,"CAPEX"]
[null,null,"860 gallons per day for about $1500, https://www.globalindustrial.com/p/commercial-reverse-osmosis-system-for-boilerless-steamers-and-combi-ovens?infoParam.campaignId=T9F&gclid=EAIaIQobChMIyv7Amf2e-wIVcHtvBB2KLgrZEAQYBCABEgJFWfD_BwE"]
[null,null,"so about $7500 CAPEX  to cover the nominal need for the ten ton ammonia per day plant."]
[]
[null,null,"Price of equipment",null,null,7500,2022]

{"sheet":"Renewable H2 Tax Credit","index":12,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"https://news.bloombergtax.com/daily-tax-report/the-new-clean-hydrogen-production-tax-credit-explained"]
[]
[]
[null,null,"0.6","per kg H2 guaranteed for 10 year"]
[]
[null,null,{"$f":"176/1000","v":0.17599999999999999},"kgH2 per kg NH3"]
[]
[null,null,{"$f":"C7*C5","v":0.10559999999999999},"per kg NH3"]

{"sheet":"CAPEX Haber Bosch","index":13,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,null,"Compressor, Reactor, NH3 condensation/recovery, circulation of unreacted syngas, heating/cooling/heat exchangers, valves and piping"]
[]
[null,null,null,"In progress"]

{"sheet":"CAPEX NH3 storage","index":14,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,null,"In progress"]

{"sheet":"CAPEX Instrument. and control","index":15,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,null,"In progress"]

{"sheet":"Ammonia price history","index":16,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"updates see https://farmdocdaily.illinois.edu"]