{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Intro","Cap.Goods","BUDGET","Income","Bayes","Staff","Bayes5","Expenses"],"not_rendered":{"charts":2,"images":89,"macros":1,"external_links":3,"defined_names":60,"comments":5,"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":"Intro","index":0,"n_rows":99,"n_cols":27,"rows_kept":99,"cut":false,"hidden":false,"merged":[[2,23,3,23],[1,2,1,4],[11,6,11,7],[12,6,12,7],[11,13,12,15],[3,16,5,16],[4,5,4,6],[5,5,5,6],[8,12,8,15],[10,6,10,7],[6,15,7,17],[1,19,1,21],[7,20,7,21],[2,15,2,17],[49,8,49,9],[56,15,56,16],[45,0,46,0],[47,15,47,17],[47,7,47,9],[45,1,45,4],[32,21,33,21],[20,14,20,15],[14,7,15,8],[15,10,15,11],[16,17,16,18],[15,16,19,16],[16,10,16,11],[11,0,11,1],[13,2,14,3],[96,5,96,6],[81,5,81,6],[66,1,66,2],[48,6,62,6],[65,5,65,6],[91,2,92,2],[43,2,43,3],[61,8,61,9],[62,8,62,9],[50,7,50,9],[57,7,57,9],[60,8,60,9],[54,7,54,9],[52,8,53,8],[55,8,56,8]]}
[0]
[null,null,"Alternative Evaluation",null,null,null,null,null,null,null,null,null,null,null,null,"STARTING DAY",null,"Do you need free browsing the program file?",null,"Exchange Rates",null,null,null,"CAPITAL EXPENCES",null,"Single Prs","Total"]
[null,null,null,"EXPECTED FINAL RESULT OF PRE DESIGN ",null,null,null,null,null,null,null,null,null,null,null,"Click down",null,null,null,1,1.6250000000000001E-2,{"$f":"V4/T4","v":1.2195121951219512},1,"TS 110/20 kV with 2 ETR Documentation with state institutions, preparation and revision of basic design, building permit","Nr","€","€"]
[null,null,"            SALES, Loan Life",{"$f":"SUM(D5:D8)","v":{"$error":"#VALUE!"}},{"$f":"SUM(E5:E8)","v":{"$error":"#VALUE!"}},null,null,null,null,"Skopje, N. Macedonia",null,null,null,null,null,null,null,null,null,0.82,null,1,null,null,1,150000,{"$f":"Y4*Z4","v":150000}]
[null,null,"          Tomatoes (T )",{"$f":"ROUND(U23,-2)","v":{"$error":"#VALUE!"}},{"$f":"D5*$U$3","v":{"$error":"#VALUE!"}},"    BROWSING",null,null,null,"    Represented by local outsourcing east electric company Ltd., Bulgaria with courtesy of",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"W3+1","v":2},"Постројка ТС 110/20kV со 2 ДВ + 2 ТР полиња и 2 ЕТР"]
[null,null,"          Cucumbers (C )",{"$f":"ROUND(U25,-2)","v":{"$error":"#VALUE!"}},{"$f":"D6*$U$3","v":{"$error":"#VALUE!"}},"    OPERATIONS ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2.1.","Градежни работи парче  ",1,814000,{"$f":"Y6*Z6","v":814000}]
[null,null,"            By/3th products",{"$f":"L27+N27+P27+R27+T27+#REF!","v":{"$error":"#REF!"}},{"$f":"D7*$U$3","v":{"$error":"#REF!"}},null,null,null,null,"Washington, DC, U.S.A.",null,null,null,null,null,{"$f":"TODAY()","v":"2019-07-15"},null,null,null,null,null,null,"2.2.","110 kV построение парче  ",2,300000,{"$f":"Y7*Z7","v":600000}]
[null,null,"         Market Products",{"$f":"U29","v":0},{"$f":"D8*$U$3","v":0},null,"    ←Level 5    →",null,"Zoom↓","Risk assessment and management: go to Bayes Theorem",null,null,null,null,null,null,null,null,null,null,null,null,"2.3.","20 kV построение парче",1,200000,{"$f":"Y8*Z8","v":200000}]
[" Click the picture \u0093 to increase it",null,"           COSTS, Total",{"$f":"SUM(D10:D11)","v":{"$error":"#VALUE!"}},{"$f":"SUM(E10:E11)","v":{"$error":"#VALUE!"}},null,"        ←Level 4   →",null,null,"Sensitivity analysis",null,null,"              ←Zoom 100  PC screen resolution: 1920 x 1080",null,null,null,null,null,null,null,null,null,"2.4.","НН инсталација, управување и релејна заштиа парче",1,350000,{"$f":"Y9*Z9","v":350000}]
[null,null,"        Variable costs",{"$f":"BUDGET!C23","v":{"$error":"#VALUE!"}},{"$f":"D10*$U$3","v":{"$error":"#VALUE!"}},null,"           ←Level 3",null,null," Resolution 1680 x 1050. For lower PC screen resolution try this → ",null,null,null,null,null,null,null,null,null,null,null,null,"2.5.","Eнергетски трансформатори 40 МВА ",2,700000,{"$f":"Y10*Z10","v":1400000}]
["  T","           C","         Fixed costs",{"$f":"BUDGET!C24","v":{"$error":"#REF!"}},{"$f":"D11*$U$3","v":{"$error":"#REF!"}},null," ←Level 2",null,"Zoom 143","Cash-flow Pro-forma Budgeting ",null,null,null," 1920 x 1080",null,null,null,null,null,null,null,null,null,"SubTotal:",null,null,{"$f":"SUM(AA6:AA10)","v":3364000}]
["    By-products",null,"         Revenues /Costs",{"$f":"ROUND(D4-D9,-3)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(E4-E9,-3)","v":{"$error":"#VALUE!"}},null,"        ←Level 1",null,"→","Capital Goods and Services         ",null,null,null,"Select Zoom 100 if Resolution of your display is lesser than 1600 x 900.",null,null,null,null,null,null,null,null,3,"Разводни постројки"]
[null,null,"         Marketing / RM",{"$f":"BUDGET!C25","v":{"$error":"#VALUE!"}},{"$f":"D13*$U$3","v":{"$error":"#VALUE!"}},null,"              ←Level 0",null,"Basic data, invariant for this Project",null,null,null,null,null,null,null,null,null,null,null,null,null,"3.1.","20kV Разводна постројка Алумина",1,200000,{"$f":"Y13*Z13","v":200000}]
[null,null,"From market Bad,  is selected over underground water resource Increase / Decrease ",null,{"$f":"E6*(1-E16)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3.2.","20kV Разводна постројка Лимак",1,200000,{"$f":"Y14*Z14","v":200000}]
["Efficiency of selling own products",null,null,null,{"$f":"E14*(1+E17)","v":{"$error":"#VALUE!"}},null,null,"   Level        Go dowm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3.3.","20kV Разводна постројка Избегово",1,200000,{"$f":"Y15*Z15","v":200000}]
["Increased sale of final products",null,109,92,{"$f":"(D16-C16)/C16","v":-0.15596330275229359},null,null,null,null,null,"Electric",null,null,null,"t p.a./ 1 ha","relative yield","Demand increases",null,null,null,null,null,"3.4.","Документација ,одобренија ,испитувања…",1,150000,{"$f":"Y16*Z16","v":150000}]
["       Increased the sale price, €",null,3.2,4.3,{"$f":"(D17-C17)/C17","v":0.34374999999999989}," \u0085 Click the image  to reveal the final results",null,null,null,null,"Power ",null,"100 kVA",null,"t p.a. Project",null,null,"    Business Plan",null,null,null,null,null,"SubTotal:",null,null,{"$f":"SUM(AA13:AA16)","v":750000}]
[null,null,"PRICING - ELECTRICITY",null,"MKD/kWh","€/kWh",null,null,null,null,"1st Stage:",0.7,{"$f":"M17*L18","v":{"$error":"#VALUE!"}},{"$f":"U37/M18","v":{"$error":"#VALUE!"}},"t p.a./ 1 ha","Max size:",null,null,null,null,null,null,4,"Планирани 20 kV кабловски врски"]
["A. EVN MAKEDONIJA AD, Average supply. Prc. for tariff consumers:",null,null,null,4.7309999999999999,{"$f":"$U$3*E19","v":7.6878749999999996E-2},null,null,"Loans A + B - D Investment, TOTAL:",{"$f":"Bayes!P21/100","v":2.0999999999999998E-2},"2nd Stage:",{"$f":"100%-L18","v":0.30000000000000004},{"$f":"M17*L19","v":{"$error":"#VALUE!"}},{"$f":"U38/M19","v":{"$error":"#VALUE!"}},"t p.a./ 1 ha",13.2384,null,null,null,null,null,null,"4.1.","20kV кабловски врски до Алумина",2,200000,{"$f":"Y19*Z19","v":400000}]
["    AD ELEM - Skopje Production price",null,null,null,2.3704000000000001,{"$f":"$U$3*E20","v":3.8519000000000005E-2},null,null,null,"FINAL PRODUCTS FOR SALE","Other≈",{"$f":"100%-L18-L19","v":0},{"$f":"M17*L20","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,"4.2.","20kV кабловски врски од Алумина / Избегово",2,275000,{"$f":"Y20*Z20","v":550000}]
["    AD MEPSO - Skopje Transmission tariff",null,null,null,0.2722,{"$f":"$U$3*E21","v":4.4232500000000001E-3},null,null,null,"Sales  Nr of Yrs:",null,null,null,{"$f":"BUDGET!G41","v":1},"  2,              3,",null,null,{"$f":"BUDGET!M41","v":4},null,{"$f":"BUDGET!O41","v":5},null,null,"4.3.","20kV кабловски врски до Алумина / Лимак",2,275000,{"$f":"Y21*Z21","v":550000}]
["    T.O.M. - Skopje Tariff for marketing, organization and management",null,null,null,1.8700000000000001E-2,{"$f":"$U$3*E22","v":3.0387500000000005E-4},null,null,null,"Products","kWh/Yr","Total, €","kWh/Yr","Total, €",null,null,"kWh/Yr","Total, €","kWh/Yr","Total, €","Check",null,"4.4.","Документација ,одобренија ,испитувања…",1,150000,{"$f":"Y22*Z22","v":150000}]
["B. Price of electric energy: ",null,null,"ELEM + MEPSO + T.O.M. = Prc. of 110 kV:",{"$f":"SUM(E20:E22)","v":2.6612999999999998},{"$f":"SUM(F20:F22)","v":4.3246125000000003E-2},null,null,null,null,{"$f":"U37","v":{"$error":"#VALUE!"}},{"$f":"U40","v":{"$error":"#VALUE!"}},{"$f":"U37","v":{"$error":"#VALUE!"}},{"$f":"U40","v":{"$error":"#VALUE!"}},". . . . . .",null,{"$f":"U37","v":{"$error":"#VALUE!"}},{"$f":"U40","v":{"$error":"#VALUE!"}},{"$f":"U37","v":{"$error":"#VALUE!"}},{"$f":"U40","v":{"$error":"#VALUE!"}},{"$f":"T23*T21","v":{"$error":"#VALUE!"}},null,null,"SubTotal:",null,null,{"$f":"SUM(AA19:AA22)","v":1650000}]
[null,null,null,"Middle value of payment (A - B): ",{"$f":"E19-E23","v":2.0697000000000001},{"$f":"F19-F23","v":3.3632624999999992E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"20/04 kV трансформаторски станици"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"U38","v":{"$error":"#VALUE!"}},{"$f":"U41","v":{"$error":"#VALUE!"}},{"$f":"U38","v":{"$error":"#VALUE!"}},{"$f":"U41","v":{"$error":"#VALUE!"}},". . . . . .",null,{"$f":"U38","v":{"$error":"#VALUE!"}},{"$f":"U41","v":{"$error":"#VALUE!"}},{"$f":"U38","v":{"$error":"#VALUE!"}},{"$f":"U41","v":{"$error":"#VALUE!"}},{"$f":"T25*T21","v":{"$error":"#VALUE!"}},null,"5.1.","Документација парче",1,80000,{"$f":"Y25*Z25","v":80000}]
[null,null,null,"€ p.h","€ p.h","€ p.h",null,null,null,"Outcome:",null,null,null,null,null,null,null,null,null,null,null,null,"5.2.","комплет 1000 кVА (апроксимирано) ",40,40000,{"$f":"Y26*Z26","v":1600000}]
[null,null,"1 MW",10,40,80,null,null,null,null,null,null,null,null,". . . . . .",null,null,null,null,null,{"$f":"T27*T21","v":0},null,null,"SubTotal:",null,null,{"$f":"SUM(AA25:AA26)","v":1680000}]
[null,null,{"$f":"F24","v":3.3632624999999992E-2},{"$f":"$C$28*D27*1000","v":336.32624999999996},{"$f":"$C$28*E27*1000","v":1345.3049999999998},{"$f":"$C$28*F27*1000","v":2690.6099999999997},null,null,null,"2ndstage of project",null,null,null,null,null,null,null,null,null,null,null,null,6,"Откуп на земјиште за ТС",1,300000,{"$f":"Y28*Z28","v":300000}]
[null,null,"p.Yr →",{"$f":"D28*24*365","v":2946217.9499999997},{"$f":"E28*24*365","v":11784871.799999999},23569743.599999998,null,null,null,null,null,{"$f":"BUDGET!G49+BUDGET!H49","v":0.5},null,{"$f":"BUDGET!I49+BUDGET!J49","v":800},". . . . . .",null,null,{"$f":"BUDGET!N49+BUDGET!O49","v":0},null,{"$f":"BUDGET!P49+BUDGET!Q49","v":0},{"$f":"S29*T21","v":0},null,{"$f":"W28+1","v":7},"Постројка ТС 110/20kV со 2 ДВ + 2 ТР+ Спојно полиња"]
[null,null,null,null,null,null,null,null,null,"Outcome:",null,null,null,null,null,null,null,null,null,null,null,null,"7.1.","Градежни работи парче",1,814000,{"$f":"Y30*Z30","v":814000}]
[null,null,null,null,null,null,null,null,null,"Budget, TOTAL",{"$f":"L23+L25+L27+L29","v":{"$error":"#VALUE!"}},null,{"$f":"N23+N25+N27+N29","v":{"$error":"#VALUE!"}},null,". . . . . .",null,{"$f":"R23+R25+R27+R29","v":{"$error":"#VALUE!"}},null,{"$f":"T23+T25+T27+S29","v":{"$error":"#VALUE!"}},null,{"$f":"U23+U25+U27+U29","v":{"$error":"#VALUE!"}},null,"7.2.","110 kV построение парче",5,400000,{"$f":"Y31*Z31","v":2000000}]
[null,null,null,null,null,null,null,null,null,"Outcome, TOTAL",{"$f":"L24+L26+L28+L30","v":0},null,{"$f":"N24+N26+N28+N30","v":0},null,{"$f":"P24+P26+P28+P30","v":0},null,{"$f":"R24+R26+R28+R30","v":0},null,{"$f":"T24+T26+T28+T30","v":0},null,null,null,"7.3.","20 kV построение парче",1,200000,{"$f":"Y32*Z32","v":200000}]
["The applied color and image visualizations in all worksheets are designed for faster and easier perception of the figures and formulas, as well as for their long term remembering for project financing success.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"¯ Basic unchangeable values for transfer to upper level Ö","Average","7.4.","НН инсталација, управување и релејна заштиа парче",1,550000,{"$f":"Y33*Z33","v":550000}]
[null,null,null,null,null,null,null,"Sales    Mo:",1,{"$f":"I34+1","v":2},{"$f":"J34+1","v":3},4,5,6,7,8,9,10,11,12,"Total/Average",null,"7.5.","Eнергетски трансформатори 12,7 МVА (сервисирани)",2,50000,{"$f":"Y34*Z34","v":100000}]
[null,null,null,null,null,null,null,"Single €kWh",{"$f":"C51","v":1.6442999999999999},{"$f":"C52","v":2.6892},{"$f":"C53","v":2.0898000000000003},{"$f":"C54","v":1.5066000000000002},{"$f":"C55","v":1.1421000000000001},{"$f":"C56","v":0.7128000000000001},{"$f":"C57","v":0.59887350000000017},{"$f":"C58","v":0.54270000000000007},{"$f":"C59","v":0.7128000000000001},{"$f":"C60","v":1.4256000000000002},{"$f":"C61","v":1.0935000000000001},{"$f":"C62","v":1.4256000000000002},{"$f":"SUM(I35:T35)/12","v":1.2986561249999999},"/kg",null,"SubTotal:",null,null,{"$f":"SUM(AA30:AA34)","v":3664000}]
[null,null,null,null,null,null,null,"Single    kWh",{"$f":"F51","v":1.3440000000000001},{"$f":"F52","v":1.1927999999999999},{"$f":"F53","v":1.3524},{"$f":"F54","v":1.4531999999999998},{"$f":"F55","v":1.0247999999999999},{"$f":"F56","v":0.66359999999999997},{"$f":"F57","v":0.51239999999999997},{"$f":"F58","v":0.64680000000000004},{"$f":"F59","v":1.2431999999999999},{"$f":"F60","v":0.84},{"$f":"F61","v":1.8480000000000001},{"$f":"F62","v":0.74759999999999993},{"$f":"SUM(I36:T36)/12","v":1.0724},"/kg",8,"Закупуване на подстанцията",1,500000,{"$f":"Y36*Z36","v":500000}]
[null,null,null,null,null,null,null,"This case   kWh ",{"$f":"A51*$M$18*10000","v":{"$error":"#VALUE!"}},{"$f":"A52*$M$18*10000","v":{"$error":"#VALUE!"}},{"$f":"A53*10000*$M$18","v":{"$error":"#VALUE!"}},{"$f":"A54*$M$18*10000","v":{"$error":"#VALUE!"}},{"$f":"A55*$M$18*10000","v":{"$error":"#VALUE!"}},{"$f":"A56*$M$18*10000","v":{"$error":"#VALUE!"}},{"$f":"A57*$M$18*10000","v":{"$error":"#VALUE!"}},{"$f":"A58*$M$18*10000","v":{"$error":"#VALUE!"}},{"$f":"A59*$M$18*10000","v":{"$error":"#VALUE!"}},{"$f":"A60*$M$18*10000","v":{"$error":"#VALUE!"}},{"$f":"A61*$M$18*10000","v":{"$error":"#VALUE!"}},{"$f":"A62*$M$18*10000","v":{"$error":"#VALUE!"}},{"$f":"SUM(I37:T37)/1000","v":{"$error":"#VALUE!"}},"/ha",9,"Първо частично зплащане на разходи за опазване поддръжка на обекта през последните 20 години",1,200000,{"$f":"Y37*Z37","v":200000}]
[null,null,null,null,null,null,null,"This case kWh ",{"$f":"D51*M19*10000","v":{"$error":"#VALUE!"}},{"$f":"D52*$M$19*10000","v":{"$error":"#VALUE!"}},{"$f":"D53*10000*$M$19","v":{"$error":"#VALUE!"}},{"$f":"D54*$M$19*10000","v":{"$error":"#VALUE!"}},{"$f":"D55*$M$19*10000","v":{"$error":"#VALUE!"}},{"$f":"D56*$M$19*10000","v":{"$error":"#VALUE!"}},{"$f":"D57*$M$19*10000","v":{"$error":"#VALUE!"}},{"$f":"D58*$M$19*10000","v":{"$error":"#VALUE!"}},{"$f":"D59*$M$19*10000","v":{"$error":"#VALUE!"}},{"$f":"D60*$M$19*10000","v":{"$error":"#VALUE!"}},{"$f":"D61*$M$19*10000","v":{"$error":"#VALUE!"}},{"$f":"D62*$M$19*10000","v":{"$error":"#VALUE!"}},{"$f":"SUM(I38:T38)/1000","v":{"$error":"#VALUE!"}},"/ha",10,"Фин. модел за проектно финансиране",1,350000,{"$f":"Y38*Z38","v":350000}]
[null,null,null,null,null,null,null,"This case TOTAL ",{"$f":"I37+I38","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"K37+K38","v":{"$error":"#VALUE!"}},{"$f":"L37+L38","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"N37+N38","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"SUM(U37:U38)","v":{"$error":"#VALUE!"}},{"$f":"IF(SUM(I39:T39)/1000=U39,TRUE,FALSE)","v":{"$error":"#VALUE!"}},null,"ТОТАL:",null,null,{"$f":"AA4+AA11+AA17+AA23+AA27+AA28+AA35+AA36+AA37+AA38","v":12608000}]
[null,null,null,null,null,null,null,"This caseTsales, €\u0081",{"$f":"I37*I35","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"K37*K35","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"O37*O35","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"SUM(I40:T40)","v":{"$error":"#VALUE!"}},"/ann"]
[null,null,null,null,null,null,null,"This caseC sales, €\u0081",{"$f":"I38*I36","v":{"$error":"#VALUE!"}},{"$f":"J38*J36","v":{"$error":"#VALUE!"}},{"$f":"K38*K36","v":{"$error":"#VALUE!"}},{"$f":"L38*L36","v":{"$error":"#VALUE!"}},{"$f":"M38*M36","v":{"$error":"#VALUE!"}},{"$f":"N38*N36","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"SUM(I41:T41)","v":{"$error":"#VALUE!"}},"/ann"]
[null,null,null,null,null,null,null,"Costs     ↓",null,null,null,null,null,null,null,null,null,null,null,"Sales:",{"$f":"SUM(U40:U41)","v":{"$error":"#VALUE!"}},"/ann"]
[null,null,null,null,null,null,null,"Pell+Trans.Heating",{"$f":"N67","v":{"$error":"#VALUE!"}},{"$f":"N68","v":{"$error":"#VALUE!"}},{"$f":"N69","v":{"$error":"#VALUE!"}},{"$f":"N70","v":{"$error":"#VALUE!"}},{"$f":"N71","v":{"$error":"#VALUE!"}},{"$f":"N72","v":{"$error":"#VALUE!"}},{"$f":"N73","v":{"$error":"#VALUE!"}},{"$f":"N74","v":{"$error":"#VALUE!"}},{"$f":"N75","v":{"$error":"#VALUE!"}},{"$f":"N76","v":{"$error":"#VALUE!"}},{"$f":"N77","v":{"$error":"#VALUE!"}},{"$f":"N78","v":{"$error":"#VALUE!"}},{"$f":"SUM(I43:T43)","v":{"$error":"#VALUE!"}},"/ann"]
[null,null,"     For Developer's use only",null,null,null,null,"This ",{"$f":"I37*$G$69+I38*$G$72","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"SUM(I44:T44)","v":{"$error":"#VALUE!"}},"/ann"]
[null,null,null,null,null,null,null,"This Running cost",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(I45:T45)","v":0},"/ann"]
["Alumina","                 I N F L O W   D A T A   W O R K I N G   P A N E L ",null,null,null,null,null,"Others fromarket",null,null,null,null,null,null,null,null,null,null,null,null,null,"/ann"]
[null,null,"DATA ENTRY PANEL FOR THE BASE Level 0",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"     I  N  C  R  E  A  S  E  :","Æ  VAT","Æ Own Funds",null,"Prc OwnFunds"]
["↑ Increase","C %+4%","          Potential YIELD and\n","SALES",null,null,null,"COSTS of fertilizer, seeding and substrate",null,null,"Water p.a.","Consumption","Electricity","This","Project","Budgeted values + VAT revivable",null,null,{"$f":"S49+S57","v":{"$error":"#VALUE!"}},{"$f":"M17","v":"100 kVA"},{"$f":"U49+U57","v":{"$error":"#VALUE!"}},{"$f":"V49+V57","v":{"$error":"#VALUE!"}},null,{"$f":"V48*T58","v":{"$error":"#VALUE!"}}]
["price option"," Price",{"$f":"-IF(D50=0,0,(D50+3)/100)","v":-0.19}," Yield C  kg/m2","Price    ↑",{"$f":"-D50/100","v":-0.16},"These data are based on the EU FSS ",13.4,"←Total area as base",null,5,"liter p.m2",6,"Water +","Electricity","Local Costs","     ↓",1,{"$f":"SUM(S51:S56)+S65","v":{"$error":"#VALUE!"}},"VAT",{"$f":"SUM(U50:U56)","v":{"$error":"#VALUE!"}},{"$f":"SUM(V50:V56)","v":{"$error":"#VALUE!"}},null,{"$f":"SUM(X50:X56)","v":{"$error":"#VALUE!"}}]
[" Yield T  kg/m2","   ↑   € /kg","€ /kg ",16,"€ /kg ",null,null,"  This project   ↓","               €/ Yr/ ha",null,0.3," € p. liter",0.06,null,"↓","Permits & Construction, F26",null,null,50000,0,{"$f":"S51*(1+$T$50)","v":302000},{"$f":"U50*(1+T$61)","v":302000},null,{"$f":"V50*(1-$T$58)","v":302000}]
[0,2.0299999999999998,{"$f":"B51*(1+$C$49)","v":1.6442999999999999},0,1.6,{"$f":"E51*(1+$F$49)","v":1.3440000000000001},null,"↓           ↓               .",null,null,0.218,{"$f":"$K$49*$K$50*$T$48*K51*10000","v":{"$error":"#VALUE!"}},{"$f":"K51*$M$49*$M$50*$T$48*10000","v":{"$error":"#VALUE!"}},null,null,"Terrain, infrastructure, F27",null,4.4999999999999998E-2,{"$f":"ROUNDUP(R51*S58,-3)","v":302000},"TOTAL",{"$f":"S51*(1+$T$50)","v":302000},{"$f":"U51*(1+T$61)","v":302000},null,{"$f":"V51*(1-$T$58)","v":302000}]
[0,3.32,{"$f":"B52*(1+$C$49)","v":2.6892},{"$f":"34944/10000","v":3.4944000000000002},1.42,{"$f":"E52*(1+$F$49)","v":1.1927999999999999},null,{"$f":"I84","v":113440},-0.05,{"$f":"I53/$H$49","v":8042.3880597014922},0.17499999999999999,{"$f":"$K$49*$K$50*$T$48*K52*10000","v":{"$error":"#VALUE!"}},{"$f":"$M$49*$M$50*$T$48*10000*K52","v":{"$error":"#VALUE!"}},null,null,"Others unforeseen exp. F29",null,9000,{"$f":"R52*$T$48","v":{"$error":"#VALUE!"}},{"$f":"U48-S48","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"U52*(1+T$61)","v":{"$error":"#VALUE!"}},null,{"$f":"V52*(1-$T$58)","v":{"$error":"#VALUE!"}}]
[4.4000000000000004,2.58,{"$f":"B53*(1+$C$49)","v":2.0898000000000003},{"$f":"62918/10000","v":6.2918000000000003},1.61,{"$f":"E53*(1+$F$49)","v":1.3524},null,{"$f":"$J$52*M18","v":{"$error":"#VALUE!"}},{"$f":"H52*(1+I52)","v":107768},null,0.14099999999999999,{"$f":"$K$49*$K$50*$T$48*K53*10000","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,null,"Truck transport, F31",null,{"$f":"IF($T$48>10,A94,IF($T$48<=5,25000,35000))","v":180000},0,"Local cost",0,0,null,{"$f":"V53*(1-$T$58)","v":0}]
[8.6,1.86,{"$f":"B54*(1+$C$49)","v":1.5066000000000002},{"$f":"74051/10000","v":7.4051},1.73,{"$f":"E54*(1+$F$49)","v":1.4531999999999998},null,{"$f":"J52*M19","v":{"$error":"#VALUE!"}},null,null,6.4000000000000001E-2,{"$f":"$K$49*$K$50*$T$48*10000*K54","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,null,"BizPlan, Fin. modeling, F33",null,{"$f":"IF($T$48>10,300000,IF($T$48<=5,80000,240000))","v":300000},{"$f":"R54","v":300000},"Exp-Imp",300000,300000,null,{"$f":"V64*(1-$T$58)","v":240000}]
[9.6999999999999993,1.41,{"$f":"B55*(1+$C$49)","v":1.1421000000000001},{"$f":"24102/10000","v":2.4102000000000001},1.22,1.0247999999999999,null,"↓               ↓             .",null,null,0.01,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"6 Mo","SubTOTAL","Risk Assessment, F34",null,{"$f":"IF($T$48>10,60000,IF($T$48<=5,20000,28000))","v":60000},{"$f":"R55","v":60000},59572.800000000003,60000,60000,null,{"$f":"V54*(1-$T$58)","v":300000}]
[10.3,0.88,0.7128000000000001,{"$f":"107055/10000","v":10.705500000000001},0.79,0.66359999999999997,null,{"$f":"I85","v":275200},{"$f":"H56*(1+I52)","v":261440},{"$f":"I56/$H$49","v":19510.447761194031},0.01,{"$f":"$K$49*$K$50*$T$48*10000*K56","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},"1 →",{"$f":"SUM(L51:L56)+SUM(M51:M56)","v":{"$error":"#VALUE!"}},"Plants' mater's, seeding, F30",null,{"$f":"J52+J56+J59","v":42640.820895522389},{"$f":"R56*C84","v":248885.94340298508},null,248885.94340298508,248885.94340298508,null,{"$f":"V55*(1-$T$58)","v":60000}]
[10.9,0.73935000000000017,0.59887350000000017,{"$f":"113898/10000","v":11.389799999999999},0.61,0.51239999999999997,null,{"$f":"J56*$T$48","v":{"$error":"#VALUE!"}},null,null,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null," Greenhouse Import ↓",null,null,{"$f":"SUM(S58:S64)","v":7670876},"OwnFunds",{"$f":"SUM(U58:U64)","v":7170876},{"$f":"SUM(V58:V64)","v":{"$error":"#REF!"}},null,{"$f":"SUM(X59:X63)","v":{"$error":"#REF!"}}]
[9.8000000000000007,0.67,0.54270000000000007,{"$f":"100297/10000","v":10.0297},0.77,0.64680000000000004,null,"Biennially    ↓        ↓  Biennially",null,null,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,"Greenhouse compl. set, F8",null,{"$f":"ROUNDUP(A96,-3)","v":1096000},{"$f":"A90+S64","v":6702076},0,{"$f":"S58*(1+$T$50)","v":6702076},{"$f":"U58*(1+T$61)","v":6702076},null,{"$f":"V57*(1-$T$58)","v":{"$error":"#REF!"}}]
[7.5,0.88,{"$f":"B59*(1+$C$49)","v":0.7128000000000001},{"$f":"12106/10000","v":1.2105999999999999},1.48,1.2431999999999999,null,{"$f":"I86","v":212820},{"$f":"H59*(1+I52)","v":202179},{"$f":"I59/$H$49","v":15087.985074626866},8.9999999999999993E-3,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,"Construction+installation, F9",null,null,500000,"+",null,{"$f":"U60*(1+T$61)","v":180000},null,{"$f":"V58*(1-$T$58)","v":6702076}]
[4.7,1.76,{"$f":"B60*(1+$C$49)","v":1.4256000000000002},{"$f":"50224/10000","v":5.0224000000000002},1,0.84,null,{"$f":"J59*$T$48/2","v":{"$error":"#VALUE!"}},null,null,6.2E-2,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,"Truck transport, F",null,{"$f":"A94/T48","v":{"$error":"#VALUE!"}},180000,{"$f":"T61-T58","v":0},{"$f":"S60*(1+$T$50)","v":180000},{"$f":"U61*(1+T$61)","v":42000}]
[2.7,1.35,1.0935000000000001,{"$f":"29835/10000","v":2.9834999999999998},2.2000000000000002,1.8480000000000001,null,"q   Biennially   s","s   Biennially   q",null,0.12,{"$f":"$K$49*$K$50*$T$48*10000*K61","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},"6 Mo","SubTOTAL","1 Yr Supervision, F10","F10→ 2 ",1,{"$f":"A93*R61","v":42000},{"$f":"((100/(100-T58*100)*100-100)/100)","v":0},{"$f":"S61*(1+$T$50)","v":42000},{"$f":"#REF!*(1+T$61)","v":{"$error":"#REF!"}},null,{"$f":"V59*(1-$T$58)","v":180000}]
[1.6,1.76,1.4256000000000002,{"$f":"15665/10000","v":1.5665},0.89,0.74759999999999993,null,"TOTAL","TOTAL",null,0.191,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"2 →",{"$f":"SUM(L57:L62)+SUM(M57:M62)","v":{"$error":"#VALUE!"}},"Management.&Training, F10",null,"\u0092",{"$f":"A92","v":6800},"Σ over↓",{"$f":"S62*(1+$T$50)","v":6800},{"$f":"U62*(1+T$61)","v":6800},null,{"$f":"V61*(1-$T$58)","v":{"$error":"#REF!"}}]
[{"$f":"SUM(A51:A62)","v":70.2},{"$f":"SUM(B51:B62)/12","v":1.603279166666667},{"$f":"SUM(C51:C62)/12","v":1.2986561249999999},{"$f":"SUM(D51:D62)","v":62.509499999999996},{"$f":"SUM(E51:E62)/12","v":1.2766666666666666},{"$f":"SUM(F51:F62)/12","v":1.0724},null,{"$f":"H53+H54+H57+H60","v":{"$error":"#VALUE!"}},{"$f":"H53+H54+H57","v":{"$error":"#VALUE!"}},null,{"$f":"SUM(K51:K62)","v":1},{"$f":"SUM(L51:L62)","v":{"$error":"#VALUE!"}},{"$f":"SUM(M51:M62)","v":{"$error":"#VALUE!"}},null,"←Change↓",null,null,null,null,null,null,null,null,{"$f":"V62*(1-$T$58)","v":6800}]
["TOTAL","Average",{"$f":"B64","v":"Average"},"TOTAL","Average",{"$f":"E64","v":"Average"},null,null,null,"Pellets  →","Conventional","HEATING","Consumption",0,"Location↑","Risk Assessment software",null,null,240000,null,{"$f":"S64*(1+$T$50)","v":240000},{"$f":"U64*(1+T$61)","v":240000},null,{"$f":"V60*(1-$T$58)","v":42000}]
[null,"min. Price exWarehouse, LondonÒ",1.2,null,"m",null,null,155,"Tansport →",20,350,{"$f":"K65/J65/1000","v":1.7500000000000002E-2},".+ Transport","This project",null,"Exclusive, F29",{"$f":"IF(N64>0,5.7,0)","v":0},0,{"$f":"Q65*R65","v":0}]
[null,"Ý  Resource:  Nov. 2016",1.35,"Other product","Price in €",null,null,"           Pellets  →","kg p.Mo↓","kg p.1ha",{"$f":"H65/1000","v":0.155},"Transp. p.ha","€/Mo/ha","€ p.↓Mo"]
["Spain yiels T + C:","Average price ↓ in Holland",null," Yield ↓  kg/m2","€ /kg ",null,"T",null,575463,{"$f":"I67/13.2","v":43595.681818181823},{"$f":"J67*$K$66*(1+$N$64)","v":6757.3306818181827},{"$f":"K67*$L$65","v":118.25328693181821},{"$f":"K67+L67","v":6875.5839687500011},{"$f":"M67*$T$48","v":{"$error":"#VALUE!"}}]
["Kg","Kg/m2","€ /kg ",null,null,10,0.65,null,523149,{"$f":"I68/13.2","v":39632.5},{"$f":"J68*$K$66*(1+$N$64)","v":6143.0375000000004},{"$f":"K68*$L$65","v":107.50315625000002},{"$f":"K68+L68","v":6250.5406562500002},{"$f":"M68*$T$48","v":{"$error":"#VALUE!"}}]
[264768,{"$f":"A69/$C$83","v":4.5361842105263159},1.21,null,null,1,{"$f":"G68/F68","v":6.5000000000000002E-2},null,444513,{"$f":"I69/13.2","v":33675.227272727272},{"$f":"J69*$K$66*(1+$N$64)","v":5219.6602272727268},{"$f":"K69*$L$65","v":91.344053977272722},{"$f":"K69+L69","v":5311.0042812499996},{"$f":"M69*$T$48","v":{"$error":"#VALUE!"}}]
[728112,12.474506578947368,2.83,"Here ↗","Image of new product",null,"C",null,340047,25761.136363636364,{"$f":"J70*$K$66","v":3992.9761363636362},69.877082386363639,{"$f":"K70+L70","v":4062.85321875},{"$f":"M70*$T$48","v":{"$error":"#VALUE!"}}]
[1125264,19.278782894736842,1.85,null,null,10,0.45,null,156019,11819.621212121212,{"$f":"J71*$K$66*(1+$N$64/1.5)","v":1832.0412878787879},32.060722537878789,{"$f":"K71+L71","v":1864.1020104166666},{"$error":"#VALUE!"},null,null,null,null,null,null,null,"iGo to Level"]
[1191456,20.412828947368421,1.33,null,null,1,{"$f":"G71/F71","v":4.4999999999999998E-2},null,0,0,{"$f":"J72*$K$66*(1+$N$64)","v":0},0,{"$f":"K72+L72","v":0},{"$error":"#VALUE!"}]
[1059072,18.144736842105264,1.01,null,null,null,null,null,0,0,{"$f":"J73*$K$66*(1+$N$64)","v":0},0,0,{"$error":"#VALUE!"}]
[0,0,0.63,null,null,null,null,null,0,0,{"$f":"J74*$K$66*(1+$N$64)","v":0},0,0,{"$error":"#VALUE!"}]
[369152,6.3245614035087723,0.53,null,null,null,null,null,0,0,{"$f":"J75*$K$66*(1+$N$64)","v":0},0,0,{"$error":"#VALUE!"}]
[595728,10.206414473684211,0.51,null,null,null,null,null,261574,19816.212121212124,{"$f":"J76*$K$66*(1+$N$64/3)","v":3071.5128787878793},53.751475378787894,3125.2643541666671,{"$error":"#VALUE!"}]
[728112,12.474506578947368,0.63,null,null,null,null,null,392361,29724.318181818184,{"$f":"J77*$K$66*(1+$N$64)","v":4607.2693181818186},80.627213068181831,{"$f":"K77+L77","v":4687.8965312500004},{"$error":"#VALUE!"}]
[369152,6.3245614035087723,1.01,null,null,null,null,null,444676,33687.57575757576,{"$f":"J78*$K$66*(1+$N$64)","v":5221.5742424242426},91.377549242424251,5312.9517916666664,{"$error":"#VALUE!"}]
[132384,2.268092105263158,0.95,null,null,null,null,null,{"$f":"SUM(I67:I78)/10000","v":313.78019999999998},{"$f":"SUM(J67:J78)","v":237712.27272727271},{"$f":"SUM(K67:K78)","v":36845.402272727275},{"$f":"SUM(L67:L78)","v":644.79453977272738},{"$f":"SUM(M67:M78)","v":37490.196812499998},{"$f":"SUM(N67:N78)","v":{"$error":"#VALUE!"}}]
[264768,4.5361842105263159,1.26,null,null,null,null,null,null,null,null,null,null,"ha"]
[{"$f":"SUM(A69:A80)","v":6827968},{"$f":"SUM(B69:B80)","v":116.98135964912279},"   ↙        OFFERS        ↘",{"$f":"SUM(D69:D80)","v":0},{"$f":"SUM(E69:E80)/12","v":0}]
["① Spain","Polycarbonate","Production + Nursery","②"," Canada          ③","           Netherland–Poland",null,null,"VEGETABLE MATERIALS for",{"$f":"H49","v":13.4}]
[{"$f":"13810*2","v":27620},"Product zones 1+3",58368,"Sector 1",{"$f":"158.15*351","v":55510.65},null,null,"Year",1,{"$f":"I83+1","v":2},{"$f":"J83+1","v":3},4,5,6,7,8]
[{"$f":"14330*2","v":28660},"Product zones 2+4",{"$f":"C83/10000","v":5.8368000000000002},"Sector 2",{"$f":"158.15*351","v":55510.65},null,null,"Fertilizers:",113440,113440,113440,113440,113440,113440,113440,113440]
[2700,"Cenrtral warehouse",null,null,null,null,null,"Seeding:",275200,275200,275200,275200,275200,275200,275200,275200]
[{"$f":"SUM(A83:A85)","v":58980},"Ç   TOTAL surface greenhouse+nursery",null,"Service area",{"$f":"ROUND(28.8*42.25,-1)","v":1220},null,null,"Substrate:",212820,0,212820,0,212820,0,212820,0]
[2246,"Nursery ↑ included",null,"Central coridor",{"$f":"ROUND((3.25*351),-1)","v":1140},null,null,"TOTAL:",{"$f":"SUM(I84:I86)","v":601460},{"$f":"SUM(J84:J86)","v":388640},601460,388640,601460,388640,601460,388640]
[{"$f":"A86/10000","v":5.8979999999999997},"Ç      Surface    È",null,"Surface È",{"$f":"SUM(E83:E84)/10000","v":11.102130000000001}]
[null,null,null,"p. 1 ha"]
[{"$f":"A99","v":6462076},"GREENHOUSE","CIF & Auxiliary Facilities ","Construction",{"$f":"1678165","v":1678165}]
[0,"Constr. & commiss."]
[6800,"Training 4 x €1700",{"$f":"A92+A93","v":48800},"Equipment",{"$f":"837750","v":837750}]
[42000,"Supervision p.Yr",null,"Supervision ",159600]
[180000,"Trucking","140 trucks","Shipping+Trucking",{"$f":"189500+A94","v":369500}]
[{"$f":"ROUND((SUM(A90:A94)),-1)","v":6690880},"Price",null,"Price",{"$f":"ROUND((SUM(E90:E94)*T4),-1)","v":2496910}]
[{"$f":"A90/A88","v":1095638.521532723},"←  =  1 ha  =  →"]
[{"$f":"A96","v":1095638.521532723}]
[]
[6462076]

{"sheet":"Cap.Goods","index":1,"n_rows":50,"n_cols":31,"rows_kept":50,"cut":false,"hidden":false,"merged":[[45,27,46,27],[45,30,46,30],[13,27,14,27],[13,28,14,28],[13,29,14,29],[13,30,14,30],[15,27,16,27],[15,28,16,28],[15,29,16,29],[15,30,16,30],[34,30,35,30],[0,30,1,30],[5,18,19,18],[8,20,9,20],[12,20,13,20],[12,21,13,25],[0,27,1,27],[0,29,1,29],[0,28,1,28],[0,26,1,26],[13,26,14,26],[15,26,16,26],[11,3,11,4],[6,17,12,17],[9,3,9,4],[13,7,14,7],[13,8,14,8],[13,9,14,9],[6,10,12,10],[13,13,14,13],[13,14,14,14],[13,15,14,15],[13,12,14,12],[13,10,14,10],[13,11,14,11],[10,3,10,4],[12,3,12,4],[1,0,2,0],[2,4,2,9],[2,10,2,11],[4,14,4,15],[20,14,20,15],[4,12,4,13],[16,12,16,13],[6,1,12,1],[6,9,12,9],[13,5,14,5],[13,6,14,6],[6,11,12,11],[6,3,6,4],[7,3,7,4],[13,1,14,4],[8,3,8,4],[38,1,45,1],[20,12,20,13],[17,10,19,10],[18,1,28,1],[31,1,33,1],[22,11,32,11],[31,3,31,4],[19,3,19,4],[29,1,30,1],[18,3,18,4],[44,22,46,23],[14,21,15,25],[35,17,35,18],[23,17,33,17],[27,3,27,4],[20,3,20,4],[38,2,38,3],[35,14,35,15],[21,18,33,18],[15,17,19,17],[13,16,14,16],[18,5,21,5],[18,6,21,6],[18,7,21,7],[18,8,21,8],[47,9,47,10],[47,11,47,12],[38,9,44,9],[47,15,47,18],[15,20,16,20],[31,9,33,9],[21,10,30,10],[16,9,29,9],[16,11,19,11],[31,10,33,10]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1ва","Част                ЧУЖДЕСТРАННИ АКТИВИ","Бр.","€","СЕ ВКУПНО"]
[]
[null,null,null," Level ①","Zoom 150        Capital Goods and Services - First Part",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"Intro!V3","v":1.2195121951219512},"1\u0086","Закупуване на трансформаторната  подстанция",1,500000,{"$f":"AC3*AD3","v":500000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BUDGET!D13","v":"2019-06-30"},null,null,null,null,null,null,null,null,null,null,"2\u0086","Трансформаторска Станица TS 110 / 20 kV",1,100000,{"$f":"AC4*AD4","v":100000}]
[null,"A","Adv.%","INVETMENT IN FOREIGN ACTIVITES\u0086 (Loan section \"A\") ",null,null,0.18,null,"FOREIGN ACTIVITES",null,"D","→","OWN FUNDS Loan \"D\"",null,"Loan \"A\" + VAT + \"D\"",null,"TOTAL",null,null,"Check",null,null,null,null,null,null,null,"градежна дозвола, итн. државни документи"]
["Ø",null,null,null,null,"Net Price"," + VAT incl.","Advance","Balance",null,null,null,{"$f":"N6","v":0},0,"Advance","Balance","Value",null,"→","↓",null,null,null,null,null,null,"3\u0086","Софтуери за фин. модел за проектно финансиране и",1,360000,{"$f":"AC6*AD6","v":360000}]
["Ø",null,null,"1. Purchase the transformer substation",null,{"$f":"AE3","v":500000},{"$f":"$G$5*F7","v":90000},{"$f":"C7*F7*(1-$N$6)","v":0},{"$f":"F7-H7","v":500000},null,null,null,0,0,{"$f":"H7+M7","v":0},null,{"$f":"O7+P7","v":0},null,null,{"$f":"IF(SUM(O8:P8)=(Intro!S58*#REF!),\"True\",\"False\")","v":{"$error":"#REF!"}},"Loan \"A\"","Purchase, exported cap. goods and services; delivery DDP*",null,null,null,null,null,"управление на паричните пототви и оценка на риска"]
[null,null,0.25,"2. Station TS 110 / 20 kV building permit -",null,{"$f":"AE4","v":100000},{"$f":"$G$5*F8","v":18000},{"$f":"C8*F8*(1-$N$6)","v":25000},{"$f":"F8-H8","v":75000},null,null,null,{"$f":"C7*F8*$N$6","v":0},{"$f":"(100%-C7)*F8*$N$6","v":0},{"$f":"H8+M8","v":25000},{"$f":"I8+N8","v":75000},{"$f":"O8+P8","v":100000},null,null,{"$f":"IF(SUM(O9:P9)=Intro!S60,\"True\",\"False\")","v":"False"},"Conditional ",null,null,null,null,null,"4\u0086\u0086","Моторни возила со опрема",2,40000,{"$f":"AC8*AD8","v":80000}]
[null,null,null,"     documentation with state institutions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(O10:P10)=Intro!S61,\"True\",\"False\")","v":"False"},"Loan \"B\"","Could be up to 30% of original part of the export paid by ",null,null,null,null,null,"Вкупно :",null,null,{"$f":"SUM(AE3:AE8)","v":1040000}]
["Ø",null,0,"3. Cash-flows, profitability & sensitivity ",null,{"$f":"AE6","v":360000},{"$f":"$G$5*F10","v":64800},{"$f":"C10*F10*(1-$N$6)","v":0},{"$f":"F10-H10","v":360000},null,null,null,{"$f":"C10*F10*$N$6","v":0},{"$f":"(100%-C10)*F10*$N$6","v":0},{"$f":"H10+M10","v":0},{"$f":"I10+N10","v":360000},{"$f":"O10+P10","v":360000},null,null,null,null,"Loan \"A\" Greenhouse base, assembling, infrastructure and ",null,null,null,null,null,"ИНВЕСТИЦИЈА НА ЛОКАЛНИТЕ ЗЕМЈИТЕ НА КАПИТАЛОТ"]
[null,null,null,"     analysis + Financial Risk Asessment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(#REF!)=Intro!S62,\"True\",\"False\")","v":{"$error":"#REF!"}},null,"other LTAssets - all one-off local country costs (up to 30%",null,null,null,null," 5\u0086\u0086","Постројка TC 110/20 kV со 2 ТР + 2 ТР полиња и 2 ЕТР\nна основен проект",1,150000,{"$f":"AC11*AD11","v":150000}]
[null,null,null,"4. Motor cars with equipment",null,{"$f":"AE8","v":80000},{"$f":"$G$5*F12","v":14400},0,{"$f":"F12-H12","v":80000},null,null,null,0,0,0,{"$f":"I12+N12","v":80000},{"$f":"O12+P12","v":80000},null,null,null,null,"of original part of export value)",null,null,null,null,"5.1.","Градежни работи",1,814000,{"$f":"AC12*AD12","v":814000}]
[null,null,null,"Other Secont Part",null,null,null,null,null,null,null,null,{"$f":"SUM(M7:M12)","v":0},{"$f":"SUM(N7:N12)","v":0},{"$f":"SUM(O7:O12)","v":25000},{"$f":"SUM(P7:P12)","v":515000},{"$f":"SUM(Q7:Q12)","v":540000},null,null,{"$f":"IF(SUM(O13:P13)=Intro!S68,\"True\",\"False\")","v":"False"},"Loan \"C\"","Permanent purchase of production materials and seasonal trade (conditionally - the start-up working materials)",null,null,null,null,"5.2.","110 kV построение",2,300000,{"$f":"AC13*AD13","v":600000}]
[null," ↑ Кликни за повеќе информации        SubTOTAL:",null,null,null,{"$f":"SUM(F7:F12)","v":1040000},{"$f":"SUM(G7:G12)","v":187200},{"$f":"SUM(H7:H12)","v":25000},{"$f":"SUM(I7:I12)","v":1015000},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F14=Q13,\"True\",\"False\")","v":"False"},null,null,null,null,null,null,"5.3.","20 kV построение",1,200000,{"$f":"AC14*AD14","v":200000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Own funds (Loan \"C\"). Credit percentage down payment, "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Loan \"D\"",null,null,null,null,null,"5.4.","НН инсталација, управување и релејна заштиа ",1,350000,{"$f":"AC16*AD16","v":350000}]
[null,"B",null,"LOCAL COUNTRY CAPITAL INVESTMENT (Loan section \"B\")",null,null,0.18,null,null,null,null,null,"OWN FUNDS Loan \"D\"",null,null,null,null,null,null,{"$f":"IF(SUM(O17:P17)=Intro!S58*#REF!,\"True\",\"False\")","v":{"$error":"#REF!"}},null,"when required (as ECA's practice)"]
[null,null,"Advance, %",null,null,"Net Price","VAT incl.","Advance","Balance",null,null,null,{"$f":"N18","v":0},{"$f":"N6","v":0},null,null,null,null,null,null,"Involve percentage of own funds, if required, in Cell N6 and click",null,null,null,null,null,"5.5.","Eнергетски трансформатори 40 МВА парче",2,700000,{"$f":"AC18*AD18","v":1400000}]
[null,null,"5․","Plant TRansform.Station 110/20 kV with",null,{"$f":"AE19","v":3514000},{"$f":"$G$17*F19","v":632520},0,{"$f":"F19-H22","v":3514000},null,null,null,null,null,null,null,null,null,null,null,"\u0085 \u0085% button left",null,null,null,null,null,null,"Вкупно :",null,null,{"$f":"SUM(AE11:AE18)","v":3514000}]
[null,null,null,"2 TR + 2 TR fields and 2 ETR .Docs with ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"* DDP - Delivered duty paid",null,null,null,null,null,"6\u0086","Разводни постројки"]
[null,null,null,"state institutions, preparation and permit",null,null,null,null,null,null,"D","→",null,null,"Loan \"A\" + VAT + \"D\"",null,"TOTAL",null,null,{"$f":"IF((O20+P20)=Intro!S57,\"True\",\"False\")","v":"False"},null,null,null,null,null,null,"3.1.","20kV Разводна постројка Алумина",1,200000,{"$f":"AC21*AD21","v":200000}]
[null,null,null,"Building TS 110/20 kV with + 2 TS fields …",null,null,null,null,null,null,null,null,null,null,"Advance","Balance","Value",null,"→",null,null,null,null,null,null,null,"3.2.","20kV Разводна постројка Лимак",1,200000,{"$f":"AC22*AD22","v":200000}]
[null,null,"6․","Distribution facilities",null,{"$f":"AE25","v":750000},{"$f":"$G$17*F23","v":135000},{"$f":"C33*F19-C33*F19*$N$6","v":0},{"$f":"F23-H23","v":750000},null,null,null,{"$f":"SUM(M24:M30)","v":{"$error":"#REF!"}},0,null,null,null,null,null,null,null,null,null,null,null,null,"3.3.","20kV Разводна постројка Избегово",1,200000,{"$f":"AC23*AD23","v":200000}]
[null,null,"7․","Planned 20 kV cable connections",null,{"$f":"AE31","v":1650000},{"$f":"$G$17*F23","v":135000},{"$f":"E33*F23-E33*F23*$N$6","v":0},{"$f":"F24-H24","v":1650000},null,null,null,null,null,{"$f":"SUM(O26:O30)","v":{"$error":"#REF!"}},{"$f":"SUM(P26:P30)","v":{"$error":"#REF!"}},{"$f":"SUM(Q26:Q30)","v":{"$error":"#REF!"}},null,null,{"$f":"IF((O24+P24)=Q24,\"True\",\"False\")","v":{"$error":"#REF!"}},null,null,null,null,null,null,"3.4.","Документација, одобренија ,испитувања…",1,150000,{"$f":"AC24*AD24","v":150000}]
[null,null,"8․","20/04 kV transformer stations",null,{"$f":"AE35","v":1680000},{"$f":"$G$17*F25","v":302400},{"$f":"C23*F25-C23*F25*$N$6","v":0},{"$f":"F25-H25","v":1680000},null,null,null,{"$f":"#REF!*$M$18","v":{"$error":"#REF!"}},{"$f":"#REF!*$M$18","v":{"$error":"#REF!"}},{"$f":"#REF!-M25","v":{"$error":"#REF!"}},{"$f":"#REF!-N25","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,"\u0086 \u0086",null,"Вкупно :",null,null,{"$f":"SUM(AE21:AE24)","v":750000}]
["Ø",null,"9․","Land acquisition for transformer stations",null,{"$f":"AE37","v":300000},{"$f":"$G$17*F26","v":54000},{"$f":"C24*F26-C24*F26*$N$6","v":0},{"$f":"F26-H26","v":300000},null,null,null,{"$f":"D33*#REF!*$N$18","v":{"$error":"#REF!"}},{"$f":"(100%-D33)*#REF!*$N$6","v":{"$error":"#REF!"}},{"$f":"H22+M26","v":{"$error":"#REF!"}},{"$f":"#REF!+N26","v":{"$error":"#REF!"}},{"$f":"O26+P26","v":{"$error":"#REF!"}},null,null,{"$f":"IF(SUM(O26:P26)=Intro!S51,\"True\",\"False\")","v":{"$error":"#REF!"}},null,null,null,null,null,null,"7\u0086\u0086","Планирани 20 kV кабловски врски"]
["Ø",null,"10․","IZBEGOVO. Plant TR.Station 110/20 kV",null,{"$f":"AE46","v":3664000},{"$f":"$G$17*F27","v":659520},{"$f":"C26*F27-C25*F28*$N$6","v":0},{"$f":"F27-H27","v":3664000},null,null,null,{"$f":"C33*F19*$N$18","v":0},{"$f":"(100%-C33)*F19*$N$6","v":0},{"$f":"H23+M27","v":0},{"$f":"I23+N27","v":750000},{"$f":"O27+P27","v":750000},null,null,{"$f":"IF(SUM(O27:P27)=Intro!#REF!,\"True\",\"False\")","v":{"$error":"#REF!"}},null,null,null,null,null,null,"4.1.","20 kV кабловски врски до Алумина",2,200000,{"$f":"AC27*AD27","v":400000}]
[null,null,null,"with 2 transormators 110/20 kV + 12.7 MVA",null,null,null,null,null,null,null,null,{"$f":"E33*F23*$N$18","v":0},{"$f":"(100%-E33)*F23*$N$6","v":0},{"$f":"H24+M28","v":0},{"$f":"I24+N28","v":1650000},{"$f":"O28+P28","v":1650000},null,null,{"$f":"IF(SUM(O28:P28)=Intro!S52,\"True\",\"False\")","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,"4.2.","20 kV кабловски врски од Алумина / Избегово",2,275000,{"$f":"AC28*AD28","v":550000}]
["Ø",null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!*F25*$N$18","v":{"$error":"#REF!"}},{"$f":"(100%-#REF!)*F25*$N$6","v":{"$error":"#REF!"}},{"$f":"H25+M29","v":{"$error":"#REF!"}},{"$f":"I25+N29","v":{"$error":"#REF!"}},{"$f":"O29+P29","v":{"$error":"#REF!"}},null,null,{"$f":"IF(SUM(O29:P29)=Intro!S53,\"True\",\"False\")","v":{"$error":"#REF!"}},null,null,null,null,null,null,"4.3.","20 kV кабловски врски од Алумина / Лимак",2,275000,{"$f":"AC29*AD29","v":550000}]
[null,{"$f":"IF(C31<=30%,\"C\",\"N\")","v":"C"},"  ↑ Кликни за повеќе информации",null,null,null,null,null,null,null,null,null,null,{"$f":"(100%-#REF!)*F26*$N$18","v":{"$error":"#REF!"}},0,{"$f":"I26+N30","v":{"$error":"#REF!"}},{"$f":"O30+P30","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,"4.4.","Документација, одобренија, испитувања…",1,150000,{"$f":"AC30*AD30","v":150000}]
[null,null,{"$f":"F14/F31","v":8.9980965564976645E-2},null,"SubTOTAL:",{"$f":"SUM(F19:F28)","v":11558000},{"$f":"SUM(G19:G28)","v":1918440},{"$f":"SUM(H19:H29)","v":0},{"$f":"SUM(I19:I28)","v":11558000},null,null,null,{"$f":"SUM(M32:M33)","v":{"$error":"#REF!"}},{"$f":"SUM(N32:N33)","v":{"$error":"#REF!"}},{"$f":"SUM(O32:O33)","v":{"$error":"#REF!"}},{"$f":"SUM(P32:P33)","v":{"$error":"#REF!"}},{"$f":"SUM(Q32:Q33)","v":{"$error":"#REF!"}},null,null,{"$f":"IF((O31+P31)=Q31,\"True\",\"False\")","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,"Вкупно :",null,null,{"$f":"SUM(AE27:AE30)","v":1650000}]
[null,null,null,"SECOND PART",null,null,null,null,null,null,null,null,{"$f":"#REF!*#REF!*$N$6","v":{"$error":"#REF!"}},{"$f":"(100%-#REF!)*#REF!*$N$6","v":{"$error":"#REF!"}},{"$f":"#REF!+M32","v":{"$error":"#REF!"}},{"$f":"#REF!+N32","v":{"$error":"#REF!"}},{"$f":"O32+P32","v":{"$error":"#REF!"}},null,null,{"$f":"IF(SUM(O32:P32)=Intro!S54,\"True\",\"False\")","v":{"$error":"#REF!"}},null,null,null,null,null,null,"8\u0086","20/04 kV трансформаторски станици"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!*#REF!*$N$6","v":{"$error":"#REF!"}},{"$f":"(100%-#REF!)*#REF!*$N$6","v":{"$error":"#REF!"}},{"$f":"#REF!+M33","v":{"$error":"#REF!"}},{"$f":"#REF!+N33","v":{"$error":"#REF!"}},{"$f":"O33+P33","v":{"$error":"#REF!"}},null,null,{"$f":"IF(SUM(O33:P33)=Intro!S55,\"True\",\"False\")","v":{"$error":"#REF!"}},null,null,null,null,null,null,"5.1.","Документација",1,80000,{"$f":"AC33*AD33","v":80000}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M23+M31","v":{"$error":"#REF!"}},{"$f":"N23+N31","v":{"$error":"#REF!"}},{"$f":"O24+O31","v":{"$error":"#REF!"}},{"$f":"P24+P31","v":{"$error":"#REF!"}},{"$f":"Q24+Q31","v":{"$error":"#REF!"}},null,null,{"$f":"IF(SUM(O34:P34)=Q34,\"True\",\"False\")","v":{"$error":"#REF!"}},null,null,null,null,null,null,"5.2.","Комплет 1000 кVА (апроксимирано) ",40,40000,{"$f":"AC34*AD34","v":1600000}]
[null,null,null,null,null,null,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":"SUM(AE33:AE34)","v":1680000}]
[null,null,null,null,"TOTAL:",{"$f":"F14+F31","v":12598000},{"$f":"G14+G31","v":2105640},{"$f":"H14+H31","v":25000},{"$f":"I14+I31","v":12573000},null,"D","→",{"$f":"M20+M34","v":{"$error":"#REF!"}},{"$f":"N20+N34","v":{"$error":"#REF!"}},"WORKING CAPITAL ↓",null,{"$f":"#REF!+Q34","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,"Вкупно :"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Loan \"D\"",{"$f":"M36+N36","v":{"$error":"#REF!"}},null,"Optional:",20000,null,null,null,null,null,null,null,null,null,"9\u0086","Откуп на земјиште за Трансформаторска Станица",1,300000,{"$f":"AC37*AD37","v":300000}]
[null,null,1E-3,null,"Ann. Interests:",null,0.04,{"$f":"G38","v":0.04},null,null,null,null,5.5E-2,null,null,null,{"$f":"SUM(Q36:Q37)","v":{"$error":"#REF!"}}]
["Ø",null,"INSURANCE",null,"  DEPRECIATION OF ASSETS",null,"Price",{"$f":"SUM(H40:H45)","v":{"$error":"#REF!"}},null,null,null," KEY NOTES:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Трансформаторска Станица ИЗБЕГОВО"]
[null,null,1E-3,{"$f":"C40*G40","v":{"$error":"#REF!"}},"    up to; for industry equipment",0.16,{"$f":"F8+#REF!+#REF!","v":{"$error":"#REF!"}},{"$f":"G40*F40","v":{"$error":"#REF!"}},null,null,1,null,"*Gradients "," in      Cells","temporary put an approximate value in it without document background and",null,null,null,null,null,null,null,null,"    ",null,null,"\u008610\u0086\u0086\u0086","Постројка ТС 110/20 kV со 2 ДВ + 2 ТР+ Спојно полиња"]
["Ø",null,null,null,"    Building ",0.04,0,{"$f":"G41*F41","v":0},null,null,null,null,"supported                      "," in      Cells","values with document. Icon      - for URL to data resource.  ",null,null,null,null,null,null,null,null,null,null,null,"10.1.","Градежни работи",1,814000,{"$f":"AC41*AD41","v":814000}]
["Ø",null,null,null,null,null,null,null,null,null,2,null,"The icons     or     ride at Internet sources.",null,null,null,null,null,null,null,null,null,null,null,null,null,"10.2.","110 kV построение",5,400000,{"$f":"AC42*AD42","v":2000000}]
["Ø",null,0.02,{"$f":"C43*G43","v":{"$error":"#REF!"}},"    Motor car",0.25,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"F43*G43","v":{"$error":"#REF!"}},null,null,3,null,"Info icons","   provides link to author's information sources.",null,null,null,null,null,null,null,null,null,null,null,null,"10.3.","20 kV построение",1,200000,{"$f":"AC43*AD43","v":200000}]
["Ø",null,0.02,{"$f":"C44*G44","v":6000},"    Truck",0.25,{"$f":"F26","v":300000},{"$f":"F44*G44","v":75000},null,null,4,null,"Various fonts and background colors represent similar group data resources.",null,null,null,null,null,null,null,null,null,null,null,null,null,"10.4.","НН инсталација, управување и релејна заштиа парче",1,550000,{"$f":"AC44*AD44","v":550000}]
["Ø",null,null,{"$f":"SUM(D40:D44)","v":{"$error":"#REF!"}},"    Intangible assets (Fin. modeling)",null,null,null,null,null,5,null,"It's recommendable to follow these indications in order to facilitate the structure identification.",null,null,null,null,null,null,null,null,null,"        Go to BUDGET        and   Financial analyzes",null,null,null,"10.5.","Eнергетски трансформатори 12,7 МVА (сервисирани)",2,50000,{"$f":"AC45*AD45","v":100000}]
[null,null,null,null,null,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":"SUM(AE41:AE45)","v":3664000}]
[]
[]
[null,null,null,null,null,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":"AE11+AE19+AE25+AE31+AE37+AE46+AE3+AE35+AE4+AE6","v":12668000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TS 110 / 20kV plant with 2 DW + 2 TR fields and 2 ETC"]

{"sheet":"BUDGET","index":2,"n_rows":136,"n_cols":22,"rows_kept":136,"cut":false,"hidden":false,"merged":[[75,13,75,14],[75,10,75,11],[74,3,74,5],[70,2,70,4],[72,13,72,14],[72,10,72,11],[70,9,71,9],[70,10,70,14],[71,6,71,8],[71,2,71,4],[72,6,72,8],[70,6,70,8],[93,0,93,1],[75,0,75,1],[74,0,74,1],[73,0,73,1],[70,0,70,1],[71,0,71,1],[72,0,72,1],[88,0,88,1],[7,11,7,12],[13,9,15,10],[7,13,7,14],[7,7,7,8],[40,8,41,8],[40,3,41,3],[40,4,41,4],[7,3,7,4],[40,6,41,6],[40,7,41,7],[40,5,41,5],[75,15,75,17],[40,18,41,18],[42,0,42,1],[68,0,69,0],[10,0,11,1],[40,15,41,15],[40,16,41,16],[40,17,41,17],[40,11,41,11],[40,10,41,10],[40,12,41,12],[40,14,41,14],[40,9,41,9],[48,0,48,1],[19,1,20,1],[40,13,41,13]]}
["[ Level①","PRE-DESIGN BACKGROUND.","Sales","Jan","Feb","2016-03-31","2016-04-30","2016-05-31","2015-06-30","2015-07-31","2015-08-31","2015-09-30","2015-10-31","2015-11-30","2015-12-31","i TOTAL p.a.i",{"$f":"($Q$2/Intro!U40+$Q$3/Intro!U41)/2","v":{"$error":"#VALUE!"}},{"$f":"($R$2/Intro!U40+$R$3/Intro!U41)/2","v":{"$error":"#VALUE!"}}]
["   Back","Value of production","IncomeTx Mo",{"$f":"Intro!I40","v":{"$error":"#VALUE!"}},{"$f":"Intro!J40","v":{"$error":"#VALUE!"}},{"$f":"Intro!K40","v":{"$error":"#VALUE!"}},{"$f":"Intro!L40","v":{"$error":"#VALUE!"}},{"$f":"Intro!M40","v":{"$error":"#VALUE!"}},{"$f":"Intro!N40","v":{"$error":"#VALUE!"}},{"$f":"Intro!O40","v":{"$error":"#VALUE!"}},{"$f":"Intro!P40","v":{"$error":"#VALUE!"}},{"$f":"Intro!Q40","v":{"$error":"#VALUE!"}},{"$f":"Intro!R40","v":{"$error":"#VALUE!"}},{"$f":"Intro!S40","v":{"$error":"#VALUE!"}},{"$f":"Intro!T40","v":{"$error":"#VALUE!"}},{"$f":"SUM(D2:O2)","v":{"$error":"#VALUE!"}},{"$f":"SUM(D2:I2)","v":{"$error":"#VALUE!"}},{"$f":"SUM(J2:O2)","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"Q2+R2","v":{"$error":"#VALUE!"}}]
["From Level 0","Business Plan","IncomeCx Mo",{"$f":"Intro!I41","v":{"$error":"#VALUE!"}},{"$f":"Intro!J41","v":{"$error":"#VALUE!"}},{"$f":"Intro!K41","v":{"$error":"#VALUE!"}},{"$f":"Intro!L41","v":{"$error":"#VALUE!"}},{"$f":"Intro!M41","v":{"$error":"#VALUE!"}},{"$f":"Intro!N41","v":{"$error":"#VALUE!"}},{"$f":"Intro!O41","v":{"$error":"#VALUE!"}},{"$f":"Intro!P41","v":{"$error":"#VALUE!"}},{"$f":"Intro!Q41","v":{"$error":"#VALUE!"}},{"$f":"Intro!R41","v":{"$error":"#VALUE!"}},{"$f":"Intro!S41","v":{"$error":"#VALUE!"}},{"$f":"Intro!T41","v":{"$error":"#VALUE!"}},{"$f":"SUM(D3:O3)","v":{"$error":"#VALUE!"}},{"$f":"SUM(D3:I3)","v":{"$error":"#VALUE!"}},{"$f":"SUM(J3:O3)","v":{"$error":"#VALUE!"}}]
[{"$f":"Intro!U48","v":{"$error":"#VALUE!"}},"\u0086  Lender/Insurer   (Loan \"A\")","Var. Costs",1,{"$f":"D4+1","v":2},{"$f":"E4+1","v":3},4,5,6,7,8,9,10,11,12,null,{"$f":"(Q5/P5+Q6/P6)/2","v":{"$error":"#VALUE!"}},{"$f":"(R5/P5+R6/P6)/2","v":{"$error":"#VALUE!"}}]
[{"$f":"Intro!V49","v":{"$error":"#VALUE!"}},"\u0086  Local Country Costs +VAT","Heating",{"$f":"Intro!I43","v":{"$error":"#VALUE!"}},{"$f":"Intro!J43","v":{"$error":"#VALUE!"}},{"$f":"Intro!K43","v":{"$error":"#VALUE!"}},{"$f":"Intro!L43","v":{"$error":"#VALUE!"}},{"$f":"Intro!M43","v":{"$error":"#VALUE!"}},{"$f":"Intro!N43","v":{"$error":"#VALUE!"}},{"$f":"Intro!O43","v":{"$error":"#VALUE!"}},{"$f":"Intro!P43","v":{"$error":"#VALUE!"}},{"$f":"Intro!Q43","v":{"$error":"#VALUE!"}},{"$f":"Intro!R43","v":{"$error":"#VALUE!"}},{"$f":"Intro!S43","v":{"$error":"#VALUE!"}},{"$f":"Intro!T43","v":{"$error":"#VALUE!"}},{"$f":"SUM(D5:O5)","v":{"$error":"#VALUE!"}},{"$f":"SUM(D5:I5)","v":{"$error":"#VALUE!"}},{"$f":"SUM(J5:O5)","v":{"$error":"#VALUE!"}}]
[{"$f":"Intro!V48","v":{"$error":"#VALUE!"}},null,"Packing",{"$f":"Intro!I44","v":{"$error":"#VALUE!"}},{"$f":"Intro!J44","v":{"$error":"#VALUE!"}},{"$f":"Intro!K44","v":{"$error":"#VALUE!"}},{"$f":"Intro!L44","v":{"$error":"#VALUE!"}},{"$f":"Intro!M44","v":{"$error":"#VALUE!"}},{"$f":"Intro!N44","v":{"$error":"#VALUE!"}},{"$f":"Intro!O44","v":{"$error":"#VALUE!"}},{"$f":"Intro!P44","v":{"$error":"#VALUE!"}},{"$f":"Intro!Q44","v":{"$error":"#VALUE!"}},{"$f":"Intro!R44","v":{"$error":"#VALUE!"}},{"$f":"Intro!S44","v":{"$error":"#VALUE!"}},{"$f":"Intro!T44","v":{"$error":"#VALUE!"}},{"$f":"SUM(D6:O6)","v":{"$error":"#VALUE!"}},{"$f":"SUM(D6:I6)","v":{"$error":"#VALUE!"}},{"$f":"SUM(J6:O6)","v":{"$error":"#VALUE!"}}]
[null,null,"Running costs",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D7:O7)","v":0},{"$f":"SUM(D7:I7)","v":0},{"$f":"SUM(J7:O7)","v":0}]
[null,null,"1 Yr Oper. Costs","T  Fertilizers  C ",null,"T+C Seeds","Substrate","1-6  Water+Electricity  7-12",null,"1-6   SubTotal","7-12  SubTotal","ß  1-Yr  biennially  2 Yr à",null,"1-6 Mo     All Costs    7-12 Mo",null,{"$f":"SUM(P5:P7)","v":{"$error":"#VALUE!"}},{"$f":"SUM(Q5:Q7)","v":{"$error":"#VALUE!"}},{"$f":"SUM(R5:R7)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"Intro!M17","v":"100 kVA"},{"$f":"Intro!H53","v":{"$error":"#VALUE!"}},{"$f":"Intro!H54","v":{"$error":"#VALUE!"}},{"$f":"Intro!H57","v":{"$error":"#VALUE!"}},{"$f":"Intro!H60","v":{"$error":"#VALUE!"}},{"$f":"Intro!O56","v":{"$error":"#VALUE!"}},{"$f":"Intro!O62","v":{"$error":"#VALUE!"}},{"$f":"SUM(D9:G9)/2+H9","v":{"$error":"#VALUE!"}},{"$f":"SUM(D9:G9)/2+I9","v":{"$error":"#VALUE!"}},"←WITH","WITHOUT→",{"$f":"SUM(D9:F9)/2+H9","v":{"$error":"#VALUE!"}},{"$f":"SUM(D9:F9)/2+I9","v":{"$error":"#VALUE!"}},null,"❶    30 Jun","31 Dec     ❷    "]
[null,null,"Market products",0,0,0,20000,30000,40000,50000,40000,30000,30000,0,0,{"$f":"SUM(D10:O10)","v":240000},{"$f":"SUM(D10:I10)","v":90000},{"$f":"SUM(J10:O10)","v":150000}]
["From [ Level①",null,"Nr of Periods",1,{"$f":"D11+1","v":2},3,4,5,6,7,8,9,10,11,12,13,14,{"$f":"Q11+1","v":15},{"$f":"R11+1","v":16}]
[null,null,"Nr of Monts",6,{"$f":"D12+6","v":12},18,24,30,36,42,{"$f":"J12+6","v":48},54,60,66,72,78,84,90,{"$f":"R12+6","v":96}]
[null,"  Repayment periods","Date:","2019-06-30","2019-12-31","2020-06-30","2020-12-31","2021-06-30","2021-12-31","2022-06-30","2022-12-31","2023-06-30","2023-12-31","2024-06-30","2024-12-31","2025-06-30","2025-12-31","2026-06-30","2026-12-31"]
[{"$f":"'Cap.Goods'!N37","v":{"$error":"#REF!"}},"\u0086  Own Funds Loan \"D\"",null,null,null,null,null,null,null,"Level ②"]
[{"$f":"Intro!T52","v":{"$error":"#VALUE!"}},"\u0086  VAT of Loans \"A\"+\"B\"    Return↔",null,{"$f":"Intro!$T$52","v":{"$error":"#VALUE!"}},{"$f":"-A15","v":{"$error":"#VALUE!"}}]
[{"$f":"'Cap.Goods'!#REF!","v":{"$error":"#REF!"}}," Export of cap. goods ",{"$f":"SUM(D16:F16)","v":0},{"$f":"'Cap.Goods'!O20","v":0},{"$f":"'Cap.Goods'!P20","v":0}]
[{"$f":"'Cap.Goods'!Q34","v":{"$error":"#REF!"}},"Local country costs",{"$f":"SUM(D17:F17)","v":{"$error":"#REF!"}},{"$f":"'Cap.Goods'!O34","v":{"$error":"#REF!"}},{"$f":"'Cap.Goods'!P34","v":{"$error":"#REF!"}}]
[{"$f":"'Cap.Goods'!Q36","v":{"$error":"#REF!"}}," Capital Investment",{"$f":"SUM(D18:F18)","v":{"$error":"#VALUE!"}},{"$f":"SUM(D15:D17)","v":{"$error":"#VALUE!"}},{"$f":"SUM(E15:E17)","v":{"$error":"#VALUE!"}}]
[null,"\u0086  Working Capital  (Loan\"C\")",{"$f":"SUM(F19:Q19)","v":1440000},null,null,{"$f":"Q10","v":90000},{"$f":"$R$10","v":150000},{"$f":"$Q$10","v":90000},{"$f":"$R$10","v":150000},{"$f":"$Q$10","v":90000},{"$f":"$R$10","v":150000},{"$f":"$Q$10","v":90000},{"$f":"$R$10","v":150000},{"$f":"$Q$10","v":90000},{"$f":"$R$10","v":150000},{"$f":"$Q$10","v":90000},{"$f":"$R$10","v":150000},{"$f":"$Q$10","v":90000},{"$f":"$R$10","v":150000}]
[" Sales,","Revenue Pro-forma Budget",{"$f":"SUM(F20:Q20)","v":{"$error":"#VALUE!"}},{"$f":"D44","v":0},0,{"$f":"F44","v":{"$error":"#VALUE!"}},{"$f":"G44","v":{"$error":"#VALUE!"}},{"$f":"H44","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"K44","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"Q44","v":{"$error":"#VALUE!"}},{"$f":"R44","v":{"$error":"#VALUE!"}},{"$f":"S44","v":{"$error":"#VALUE!"}}]
["Less:",null,"Date:",{"$f":"D13","v":"2019-06-30"},{"$f":"E13","v":"2019-12-31"},"2020-06-30","2020-12-31","2021-06-30","2021-12-31","2022-06-30","2022-12-31","2023-06-30","2023-12-31","2024-06-30","2024-12-31","2025-06-30","2025-12-31","2026-06-30","2026-12-31"]
["Costs,","TOTAL (in €)",{"$f":"SUM(D22:S22)","v":{"$error":"#REF!"}},{"$f":"SUM(D23:D26)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"Variable costs",{"$f":"SUM(D23:Q23)","v":{"$error":"#VALUE!"}},{"$f":"D55","v":0},{"$f":"E55","v":0},{"$f":"F55","v":{"$error":"#VALUE!"}},{"$f":"G55","v":{"$error":"#VALUE!"}},{"$f":"H55","v":{"$error":"#VALUE!"}},{"$f":"I55","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"R55","v":{"$error":"#VALUE!"}},{"$f":"S55","v":{"$error":"#VALUE!"}}]
[null,"Fixed costs",{"$f":"SUM(D24:Q24)","v":{"$error":"#REF!"}},{"$f":"D59","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Marketing & Risk Mngmt",{"$f":"SUM(D25:Q25)","v":{"$error":"#VALUE!"}},{"$f":"D65","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$f":"'Cap.Goods'!H39","v":{"$error":"#REF!"}},"Depreciations",null,null,null,null,{"$f":"'Cap.Goods'!$H$40+'Cap.Goods'!H43+'Cap.Goods'!H44","v":{"$error":"#REF!"}},null,{"$f":"G26","v":{"$error":"#REF!"}},null,{"$f":"G26","v":{"$error":"#REF!"}},null,{"$f":"G26","v":{"$error":"#REF!"}},null,{"$f":"M26-'Cap.Goods'!H43-'Cap.Goods'!H44","v":{"$error":"#REF!"}},null,{"$f":"O26","v":{"$error":"#REF!"}},null,{"$f":"'Cap.Goods'!H43+'Cap.Goods'!H44","v":{"$error":"#REF!"}}]
[null,"Cash Flows (EBIT)",null,{"$f":"D20-D22","v":{"$error":"#REF!"}},{"$f":"E20-E22","v":{"$error":"#REF!"}},{"$f":"F20-F22","v":{"$error":"#VALUE!"}},{"$f":"G20-G22","v":{"$error":"#VALUE!"}},{"$f":"H20-H22","v":{"$error":"#VALUE!"}},{"$f":"I20-I22","v":{"$error":"#VALUE!"}},{"$f":"J20-J22","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"P20-P22","v":{"$error":"#VALUE!"}},{"$f":"Q20-Q22","v":{"$error":"#VALUE!"}},{"$f":"R20-R22","v":{"$error":"#VALUE!"}},{"$f":"S20-S22","v":{"$error":"#VALUE!"}},null,{"$f":"SUM(D27:Q27)","v":{"$error":"#REF!"}}]
["Less:","Interests Loans \"A\" + \"B\"",null,{"$f":"D86+D91+D96","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"J86+J91+J96","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"Q86+Q91+Q96","v":{"$error":"#REF!"}},{"$f":"R86+R91+R96","v":{"$error":"#REF!"}},{"$f":"S86+S91+S96","v":{"$error":"#REF!"}},null,{"$f":"SUM(D28:Q28)","v":{"$error":"#REF!"}}]
[null,"EBT",null,{"$f":"D27-D28","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$f":"G27-G28","v":{"$error":"#VALUE!"}},{"$f":"H27-H28","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"P27-P28","v":{"$error":"#VALUE!"}},{"$f":"Q27-Q28","v":{"$error":"#VALUE!"}},{"$f":"R27-R28","v":{"$error":"#VALUE!"}},{"$f":"S27-S28","v":{"$error":"#VALUE!"}},null,{"$f":"SUM(D29:Q29)","v":{"$error":"#REF!"}},{"$f":"U29/$Q$12","v":{"$error":"#REF!"}}]
["Less:","Income tax",0.1,null,null,null,{"$f":"(D29+E29+F29)*C30","v":{"$error":"#REF!"}},null,{"$f":"(G29+H29)*$C$30-H31","v":{"$error":"#VALUE!"}},null,{"$f":"(I29+J29)*$C$30-J31","v":{"$error":"#VALUE!"}},null,{"$f":"(K29+L29)*$C$30-L31","v":{"$error":"#VALUE!"}},null,{"$f":"(M29+N29)*$C$30-N31","v":{"$error":"#VALUE!"}},null,{"$f":"(O29+P29)*$C$30-P31","v":{"$error":"#VALUE!"}},null,{"$f":"(Q29+R29)*$C$30-R31","v":{"$error":"#VALUE!"}},null,{"$f":"SUM(D26:Q26)","v":{"$error":"#REF!"}}]
[null,"Advance deposit",null,null,null,null,null,{"$f":"G30/2","v":{"$error":"#REF!"}},null,{"$f":"I30/2","v":{"$error":"#VALUE!"}},null,{"$f":"K30/2","v":{"$error":"#VALUE!"}},null,{"$f":"M30/2","v":{"$error":"#VALUE!"}},null,{"$f":"O30/2","v":{"$error":"#VALUE!"}},null,{"$f":"Q30/2","v":{"$error":"#VALUE!"}},null,null,{"$f":"SUM(U29:U30)","v":{"$error":"#REF!"}}]
[null,"EAT",{"$f":"SUM(D32:Q32)","v":{"$error":"#REF!"}},{"$f":"D29-D30-D31","v":{"$error":"#REF!"}},{"$f":"E29-E30-E31","v":{"$error":"#REF!"}},{"$f":"F29-F30-F31","v":{"$error":"#VALUE!"}},{"$f":"G29-G30-G31","v":{"$error":"#VALUE!"}},{"$f":"H29-H30-H31","v":{"$error":"#VALUE!"}},{"$f":"I29-I30-I31","v":{"$error":"#VALUE!"}},{"$f":"J29-J30-J31","v":{"$error":"#VALUE!"}},{"$f":"K29-K30-K31","v":{"$error":"#VALUE!"}},{"$f":"L29-L30-L31","v":{"$error":"#VALUE!"}},{"$f":"M29-M30-M31","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$f":"SUM(D32:Q32)","v":{"$error":"#REF!"}},{"$f":"U32/$Q$12","v":{"$error":"#REF!"}}]
["Add:","Total depreciations",null,null,{"$f":"E26","v":0},null,{"$f":"G26","v":{"$error":"#REF!"}},{"$f":"H26","v":0},{"$error":"#REF!"},0,{"$error":"#REF!"},0,{"$error":"#REF!"},0,{"$error":"#REF!"},0,{"$error":"#REF!"}]
["Add:","Tax advance deposited"]
["►"," Operating Cash Flows",{"$f":"SUM(D35:S35)","v":{"$error":"#REF!"}},{"$f":"SUM(D32:D34)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"SUM(L32:L34)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"SUM(R32:R34)","v":{"$error":"#VALUE!"}},{"$f":"SUM(S32:S34)","v":{"$error":"#VALUE!"}}]
["Less:",null,null,{"$f":"-D18","v":{"$error":"#VALUE!"}},{"$f":"-E18","v":{"$error":"#VALUE!"}},{"$f":"-F18","v":0}]
["►    (NCFs)","Project's Net Cash Flows",{"$f":"SUM(D37:S37)","v":{"$error":"#REF!"}},{"$f":"D35+D36","v":{"$error":"#REF!"}},{"$f":"E35+E36","v":{"$error":"#REF!"}},{"$f":"F35+F36","v":{"$error":"#VALUE!"}},{"$f":"G35+G36","v":{"$error":"#VALUE!"}},{"$f":"H35+H36","v":{"$error":"#VALUE!"}},{"$f":"I35+I36","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"P35+P36","v":{"$error":"#VALUE!"}},{"$f":"Q35+Q36","v":{"$error":"#VALUE!"}},{"$f":"R35+R36","v":{"$error":"#VALUE!"}},{"$f":"S35+S36","v":{"$error":"#VALUE!"}}]
["Less: Loans—","Installments (principal + interest)",null,{"$f":"-(D88+D93+D98-D28)","v":0},{"$f":"-(E88+E93+E98-E28)","v":{"$error":"#REF!"}},{"$f":"-(F88+F93+F98-F28)","v":{"$error":"#REF!"}},{"$f":"-(G88+G93+G98-G28)","v":{"$error":"#REF!"}},{"$f":"-(H88+H93+H98-H28)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$f":"SUM(D38:Q38)","v":{"$error":"#REF!"}}]
[null,"Cash",null,{"$f":"D37+D38","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"J37+J38","v":{"$error":"#VALUE!"}},{"$f":"K37+K38","v":{"$error":"#VALUE!"}},{"$f":"L37+L38","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Cumulative NCFs (loan pay-off incl.)",null,"→",{"$f":"D39","v":{"$error":"#REF!"}},{"$f":"D40+E39","v":{"$error":"#REF!"}},{"$f":"E40+F39","v":{"$error":"#REF!"}},{"$f":"F40+G39","v":{"$error":"#REF!"}},{"$f":"G40+H39","v":{"$error":"#REF!"}},{"$f":"H40+I39","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"N40+O39","v":{"$error":"#REF!"}},{"$f":"O40+P39","v":{"$error":"#REF!"}},{"$f":"P40+Q39","v":{"$error":"#REF!"}},{"$f":"Q40+R39","v":{"$error":"#REF!"}},{"$f":"R40+S39","v":{"$error":"#REF!"}}]
[null,"Years :",null,"→",null,-0.03,{"$f":"E41+1","v":1},0,{"$f":"G41+1","v":2},{"$f":"H41+5%","v":0.05},{"$f":"I41+1","v":3},{"$f":"J41+5%","v":0.1},{"$f":"K41+1","v":4},{"$f":"L41+5%","v":0.15000000000000002},{"$f":"M41+1","v":5},{"$f":"N41+3%","v":0.18000000000000002},{"$f":"O41+1","v":6},{"$f":"P41+2%","v":0.2},{"$f":"Q41+1","v":7}]
[]
["Income data. Selected year <+>:",null,"Calendar year",{"$f":"D13","v":"2019-06-30"},{"$f":"E13","v":"2019-12-31"},"2020-06-30","2020-12-31","2021-06-30","2021-12-31","2022-06-30","2022-12-31","2023-06-30","2023-12-31","2024-06-30","2024-12-31","2025-06-30","2025-12-31","2026-06-30","2026-12-31"]
[{"$f":"SUM(F44:Q44)","v":{"$error":"#VALUE!"}},"      Sales         ",null,null,null,{"$f":"F45","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"R45","v":{"$error":"#VALUE!"}},{"$f":"S45","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,{"$f":"SUM(F46:F47)","v":{"$error":"#VALUE!"}},{"$f":"SUM(G46:G47)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"SUM(R46:R48)","v":{"$error":"#VALUE!"}},{"$f":"SUM(S46:S48)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,{"$f":"Q2*(1+$F$41)","v":{"$error":"#VALUE!"}},{"$f":"R2*(1+$F$41)","v":{"$error":"#VALUE!"}},{"$f":"$Q$2","v":{"$error":"#VALUE!"}},{"$f":"$R$2","v":{"$error":"#VALUE!"}},{"$f":"$Q$2*(1+J41)","v":{"$error":"#VALUE!"}},{"$f":"$R$2*(1+J41)","v":{"$error":"#VALUE!"}},{"$f":"$Q$2*(1+L41)","v":{"$error":"#VALUE!"}},{"$f":"$R$2*(1+L41)","v":{"$error":"#VALUE!"}},{"$f":"$Q$2*(1+N41)","v":{"$error":"#VALUE!"}},{"$f":"$R$2*(1+N41)","v":{"$error":"#VALUE!"}},{"$f":"$Q$2*(1+P41)","v":{"$error":"#VALUE!"}},{"$f":"$R$2*(1+P41)","v":{"$error":"#VALUE!"}},{"$f":"$Q$2","v":{"$error":"#VALUE!"}},{"$f":"$R$2*(1+R41)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,{"$f":"Q3*(1+$F$41)","v":{"$error":"#VALUE!"}},{"$f":"R3*(1+$F$41)","v":{"$error":"#VALUE!"}},{"$f":"$Q$3","v":{"$error":"#VALUE!"}},{"$f":"$R$3","v":{"$error":"#VALUE!"}},{"$f":"$Q$3*(1+J41)","v":{"$error":"#VALUE!"}},{"$f":"$R$3*(1+J41)","v":{"$error":"#VALUE!"}},{"$f":"$Q$3*(1+L41)","v":{"$error":"#VALUE!"}},{"$f":"$R$3*(1+L41)","v":{"$error":"#VALUE!"}},{"$f":"$Q$3*(1+N41)","v":{"$error":"#VALUE!"}},{"$f":"$R$3*(1+N41)","v":{"$error":"#VALUE!"}},{"$f":"$Q$3*(1+P41)","v":{"$error":"#VALUE!"}},{"$f":"$R$3*(1+P41)","v":{"$error":"#VALUE!"}},{"$f":"$Q$3","v":{"$error":"#VALUE!"}},{"$f":"$R$3*(1+R41)","v":{"$error":"#VALUE!"}}]
[]
["OPERATIONAL AND RISK MANAGEMENT",null,"Option: Funding",null,1000,0.5,0.3,0.2,{"$f":"$E$49*F49","v":500},{"$f":"$E$49*G49","v":300},{"$f":"$E$49*H49","v":200},0]
[null,"Dynamic structure of new loan with",0.06,"Select and","↑ ENTER ↑",null,null,"New debt to add to the Costs→",0,{"$f":"I49*(1+$C$50/2)","v":515},{"$f":"J49*(1+$C$50/2)","v":309},{"$f":"K49*(1+$C$50/2)","v":206}]
[" Sales,","Current accounting reports"]
["Costs,","TOTAL accounting reports"]
["OCFCS","Cash Flow Statements       ‒","Аccounting"]
[null,"Income data (in €), EU Zone   Periods:",{"$f":"C13","v":"Date:"},{"$f":"D13","v":"2019-06-30"},{"$f":"E13","v":"2019-12-31"},"2020-06-30","2020-12-31","2021-06-30","2021-12-31","2022-06-30","2022-12-31","2023-06-30","2023-12-31","2024-06-30","2024-12-31","2025-06-30","2025-12-31",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"T13","v":"00:00:00"}]
[null,"      Variable costs ",{"$f":"SUM(D55:S55)","v":{"$error":"#VALUE!"}},{"$f":"SUM(D56:D58)","v":0},{"$f":"SUM(E56:E58)","v":0},{"$f":"SUM(F56:F58)-F57","v":{"$error":"#VALUE!"}},{"$f":"SUM(G56:G58)-G57","v":{"$error":"#VALUE!"}},{"$f":"SUM(H56:H58)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$f":"Q8","v":{"$error":"#VALUE!"}},"1st Heating, packing, running costs 2nd",{"$f":"R8","v":{"$error":"#VALUE!"}},0,0,{"$f":"$A$56","v":{"$error":"#VALUE!"}},{"$f":"$C$56","v":{"$error":"#VALUE!"}},{"$f":"$A$56","v":{"$error":"#VALUE!"}},{"$f":"$C$56","v":{"$error":"#VALUE!"}},{"$f":"$A$56","v":{"$error":"#VALUE!"}},{"$f":"$C$56","v":{"$error":"#VALUE!"}},{"$f":"$A$56","v":{"$error":"#VALUE!"}},{"$f":"$C$56","v":{"$error":"#VALUE!"}},{"$f":"$A$56","v":{"$error":"#VALUE!"}},{"$f":"$C$56","v":{"$error":"#VALUE!"}},{"$f":"$A$56","v":{"$error":"#VALUE!"}},{"$f":"$C$56","v":{"$error":"#VALUE!"}},{"$f":"$A$56","v":{"$error":"#VALUE!"}},{"$f":"$C$56","v":{"$error":"#VALUE!"}}]
[null,"Operat. costs ̶ fertilizers, substrate, etc.",null,0,0,{"$f":"H9","v":{"$error":"#VALUE!"}},{"$f":"I9","v":{"$error":"#VALUE!"}},{"$f":"$N$9","v":{"$error":"#VALUE!"}},{"$f":"$O$9","v":{"$error":"#VALUE!"}},{"$f":"$J$9","v":{"$error":"#VALUE!"}},{"$f":"$K$9","v":{"$error":"#VALUE!"}},{"$f":"$N$9","v":{"$error":"#VALUE!"}},{"$f":"$O$9","v":{"$error":"#VALUE!"}},{"$f":"$J$9","v":{"$error":"#VALUE!"}},{"$f":"$K$9","v":{"$error":"#VALUE!"}},{"$f":"$N$9","v":{"$error":"#VALUE!"}},{"$f":"$O$9","v":{"$error":"#VALUE!"}},{"$f":"$J$9","v":{"$error":"#VALUE!"}},{"$f":"$K$9","v":{"$error":"#VALUE!"}}]
[2000,"p.ann./ha.  Other materials and services ",null,null,null,{"$f":"$A$58/2*$C$9*$Q$4","v":{"$error":"#VALUE!"}},{"$f":"$A$58/2*$C$9*$R$4","v":{"$error":"#VALUE!"}},{"$f":"$A$58/2*$C$9*$Q$4","v":{"$error":"#VALUE!"}},{"$f":"$A$58/2*$C$9*$R$4","v":{"$error":"#VALUE!"}},{"$f":"$A$58/2*$C$9*$Q$4","v":{"$error":"#VALUE!"}},{"$f":"$A$58/2*$C$9*$R$4","v":{"$error":"#VALUE!"}},{"$f":"$A$58/2*$C$9*$Q$4","v":{"$error":"#VALUE!"}},{"$f":"$A$58/2*$C$9*$R$4","v":{"$error":"#VALUE!"}},{"$f":"$A$58/2*$C$9*$Q$4","v":{"$error":"#VALUE!"}},{"$f":"$A$58/2*$C$9*$R$4","v":{"$error":"#VALUE!"}},{"$f":"$A$58/2*$C$9*$Q$4","v":{"$error":"#VALUE!"}},{"$f":"$A$58/2*$C$9*$R$4","v":{"$error":"#VALUE!"}},{"$f":"$A$58*$Q$4","v":{"$error":"#VALUE!"}},{"$f":"$A$58*$R$4","v":{"$error":"#VALUE!"}}]
[{"$f":"IF(C9>=2.5,3600,IF(AND(C9>=1,C9<3),3000,IF(AND(C9>0.5,C9<=1),1000,0)))","v":3600},"      Fixed costs",{"$f":"SUM(D59:S59)","v":{"$error":"#REF!"}},{"$f":"SUM(D60:D65)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM(G60:G65)","v":{"$error":"#REF!"}},{"$f":"SUM(H60:H65)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM(R60:R64)","v":{"$error":"#REF!"}},{"$f":"SUM(S60:S64)","v":{"$error":"#REF!"}}]
[1200,"Office - phones, internet, rent, power",null,100,200,240,{"$f":"$A$60/2","v":600},600,600,600,600,600,600,600,600,600,600,600,600]
[0,"Cars - fuel and maintenance ",null,0,0,0,{"$f":"$A$61/2","v":0},{"$f":"$A$61/2","v":0},0,0,0,0,0,0,0,0,0,0,0]
[25200,"Fin. reporting, Online Cash-Flow Control System",null,0,1000,{"$f":"$A$62/2","v":12600},12600,12600,12600,12600,12600,12600,12600,12600,12600,12600,12600,12600,12600]
[2.7E-2,"Payroll, administration, p. ann.",{"$f":"Staff!G12+Staff!G26+Staff!G31","v":339000},{"$f":"(Staff!G19+Staff!G20+Staff!G21+Staff!G22)/3","v":15600},{"$f":"C63/3","v":113000},{"$f":"$C$63/2","v":169500},{"$f":"$C$63/2","v":169500},{"$f":"F63*(1+$A$63)","v":174076.49999999997},174076.49999999997,178776.56549999997,178776.56549999997,183603.53276849995,183603.53276849995,188560.82815324943,188560.82815324943,193651.97051338715,193651.97051338715,198880.5737172486,198880.5737172486]
[{"$f":"'Cap.Goods'!D45","v":{"$error":"#REF!"}},"Insurance of building, products, cars",null,{"$f":"'Cap.Goods'!D43","v":{"$error":"#REF!"}},{"$f":"A64-$D$64","v":{"$error":"#REF!"}},{"$f":"'Cap.Goods'!$D$43","v":{"$error":"#REF!"}},{"$f":"$A$64-$F$64","v":{"$error":"#REF!"}},{"$f":"'Cap.Goods'!$D$43","v":{"$error":"#REF!"}},{"$f":"$A$64-$F$64","v":{"$error":"#REF!"}},{"$f":"'Cap.Goods'!$D$43","v":{"$error":"#REF!"}},{"$f":"$A$64-$F$64","v":{"$error":"#REF!"}},{"$f":"'Cap.Goods'!$D$43","v":{"$error":"#REF!"}},{"$f":"$A$64-$F$64","v":{"$error":"#REF!"}},{"$f":"'Cap.Goods'!$D$43","v":{"$error":"#REF!"}},{"$f":"$A$64-$F$64","v":{"$error":"#REF!"}},{"$f":"'Cap.Goods'!$D$43","v":{"$error":"#REF!"}},{"$f":"$A$64-$F$64","v":{"$error":"#REF!"}},{"$f":"'Cap.Goods'!$D$43","v":{"$error":"#REF!"}},{"$f":"$A$64-$F$64","v":{"$error":"#REF!"}}]
[{"$f":"0.13%*M78","v":2.7299999999999994E-3},"of sales - marketing, exhibitions",{"$f":"Intro!U42","v":{"$error":"#VALUE!"}},null,{"$f":"$A$65*$C$65","v":{"$error":"#VALUE!"}},{"$f":"IF(AND($M$76>$A$67,F54>E54),$A$65*$C$65,E65)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF(AND($M$76>$A$67,L54>K54)*$C$65,K65)","v":{"$error":"#VALUE!"}},{"$f":"IF(AND($M$76>$A$67,M54>L54),$A$65*$C$65,L65)","v":{"$error":"#VALUE!"}},{"$f":"IF(AND($M$76>$A$67,N54>M54),$A$65*$C$65,M65)","v":{"$error":"#VALUE!"}},{"$f":"IF(AND($M$76>$A$67,O54>N54),$A$65*$C$65,N65)","v":{"$error":"#VALUE!"}},{"$f":"IF(AND($M$76>$A$67,P54>O54),$A$65*$C$65,O65)","v":{"$error":"#VALUE!"}},{"$f":"IF(AND($M$76>$A$67,Q54>P54),$A$65*$C$65,P65)","v":{"$error":"#VALUE!"}},{"$f":"$A$65*$C$65","v":{"$error":"#VALUE!"}},{"$f":"$A$65*$C$65","v":{"$error":"#VALUE!"}}]
[]
["2018-03-22","Turnkey - start date of operation\nRestarted for corrections\n"]
["3039-02-02T16:00:00",null,null,null,"Years:",1,{"$f":"F68+1","v":2},3,4,5,6,7,null,null,null,null,null,null,null,"up"]
["Level ❸","PROFITABILITY ANALYSIS",null,"Up front investment:",{"$f":"-C18","v":{"$error":"#VALUE!"}},{"$f":"F39+G39","v":{"$error":"#VALUE!"}},{"$f":"H39+I39","v":{"$error":"#VALUE!"}},{"$f":"J39+K39","v":{"$error":"#VALUE!"}},{"$f":"L39+M39","v":{"$error":"#VALUE!"}},{"$f":"N39+O39","v":{"$error":"#VALUE!"}},{"$f":"P39+Q39","v":{"$error":"#VALUE!"}},{"$f":"R39+S39","v":{"$error":"#VALUE!"}}]
[null,"1-Yr period Operating Cash Flows",null,null,"Debt-Service Coverage Ratio = EBIT/Costs",{"$f":"SUM(G70:M70)/T70","v":{"$error":"#VALUE!"}},{"$f":"(G29+G26)/G88","v":{"$error":"#VALUE!"}},{"$f":"(I29+I26)/I88","v":{"$error":"#VALUE!"}},{"$f":"(J29+J26)/J88","v":{"$error":"#VALUE!"}},{"$f":"(K29+K26)/K88","v":{"$error":"#VALUE!"}},{"$f":"(M29+M26)/M88","v":{"$error":"#VALUE!"}},{"$f":"(O29+O26)/O88","v":{"$error":"#VALUE!"}},{"$f":"(Q29+Q26)/Q88","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,{"$f":"MATCH(50,G70:S70)","v":{"$error":"#N/A"}}]
["Discounted Cash Flow Models",null,"The Investor can make enough in operating ",null,null,{"$f":"IF(F70>=1.2,\"Good\",\"Bad\")","v":{"$error":"#VALUE!"}},"Default Risk Management ",null,null,null,"Operational Risk Management"]
["Section MEASURING PROFITABILITY",null,"profits to pay its current debt service costs. It is subject of fiscal year-end monitoring.",null,null,"DSCR","Section",null,null,null,null,null,"Section \"SENSITIVITY ANALYSIS\""]
[null,null,null,null,null,"Level④","PAYBACK PERIOD",null,null,null,"Simulation of Good Market",null,"Enter A1 share","Simulation of Bad Market"]
["Discount (hurdle) rate :",null,6.5000000000000002E-2,"Loan Life Coverage Ratio",null,null,"Period:",{"$f":"D132","v":0},{"$f":"E132","v":{"$error":"#N/A"}},null,{"$f":"IF(Bayes!C7>Bayes!C9,\"A1\",\"A2\")","v":"A1"},"Salesman",67,{"$f":"IF(Bayes!C7<Bayes!C9,\"A1 \",\"A2\")","v":"A2"},"Salesman"]
["Net Present Value (NPV for CADS) :",null,{"$f":"NPV(C74,E69:L69)","v":{"$error":"#VALUE!"}},"Unlike period-on-period measures such as the above DSCR, it provides the Lender with a measure of the number of times the cash flow over the scheduled loan life can repay the outstanding debt balance.",null,null,"Date:","2022-06-30","earliness",null,null,79,{"$f":"M74/100","v":0.67},{"$f":"100-L75","v":21}]
["IRR :",null,{"$f":"IRR(E69:L69)","v":{"$error":"#VALUE!"}},6.5000000000000002E-2,"LLCR =",{"$f":"C75/A87","v":{"$error":"#VALUE!"}},null,"Accelerated amortization of loans",null,null,"  Good sales",null,"2018-06-17","      Bad sales         Select→",null,"distribution of sales."]
[1,"Commercial bank, Own funds (Loan \"D\")",{"$f":"SUM(D77+E77)","v":{"$error":"#REF!"}},{"$f":"'Cap.Goods'!M36","v":{"$error":"#REF!"}},{"$f":"'Cap.Goods'!N36","v":{"$error":"#REF!"}},0,null,"Update £  it now.",null,null,null,null," . Correction factor for Area of critical announcement"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(L75>90,N75>60),\" STOP! Calm down. You've just entered a field of dreams!\",Bayes!P21)","v":2.0999999999999996}]
[null,"Loan \"C\" Local market vegetables",null,null,0,{"$f":"Q10","v":90000},{"$f":"$R$10","v":150000},{"$f":"$Q$10","v":90000},{"$f":"$R$10","v":150000},{"$f":"$Q$10","v":90000},{"$f":"$R$10","v":150000},{"$f":"$Q$10","v":90000},{"$f":"$R$10","v":150000},{"$f":"$Q$10","v":90000},{"$f":"$R$10","v":150000},{"$f":"$Q$10","v":90000},{"$f":"$R$10","v":150000},{"$f":"$Q$10","v":90000},{"$f":"$R$10","v":150000}]
[null,{"$f":"O16","v":0},{"$f":"C13","v":"Date:"},"2019-06-30","2019-12-31","2020-06-30","2020-12-31","2021-06-30","2021-12-31","2022-06-30","2022-12-31","2023-06-30","2023-12-31","2024-06-30","2024-12-31","2025-06-30","2025-12-31","2026-06-30","2026-12-31"]
[null,"LOANS              Number of Periods",{"$f":"C12","v":"Nr of Monts"},null,null,{"$f":"E12","v":12},18,24,30,36,42,48,54,60,66,72,78,{"$f":"P12","v":78},{"$f":"Q12","v":84}]
[null," Nr. of periods",{"$f":"MATCH(50,E82:S82)","v":15},null,1,{"$f":"E82+1","v":2},{"$f":"F82+1","v":3},{"$f":"G82+1","v":4},5,6,7,8,9,10,11,12,13,14,{"$f":"R82+1","v":15}]
[null," Nr. of principal period repayments",{"$f":"MATCH(50,F83:S83)","v":14},null,null,{"$f":"D11","v":1},2,3,4,5,6,7,8,9,10,11,12,13,14]
[]
["TOTAL:"," Loan \"A\", Balance liabilities",{"$f":"C16","v":0},{"$f":"C85","v":0},{"$f":"D85","v":0},{"$f":"E85","v":0},{"$f":"F85-F87","v":0},{"$f":"G85-G87","v":0},{"$f":"H85-H87","v":0},0,0,{"$f":"K85-K87","v":0},{"$f":"L85-L87","v":0},{"$f":"M85-M87","v":0},{"$f":"N85-N87","v":0},0,{"$f":"P85-P87","v":0},{"$f":"Q85-Q87","v":0},{"$f":"R85-R87","v":0}]
[{"$f":"SUM(G86:S86)","v":0},"\u0085  Interest payments",{"$f":"'Cap.Goods'!G38","v":0.04},null,null,null,{"$f":"-ROUND(IPMT($C$86/2,F83,$C$83,F85),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(G86:R86)","v":"00:00:00"}]
[{"$f":"SUM(G87:S87)","v":0},"\u0085 Principal installments",null,null,null,null,{"$f":"-ROUND(PPMT($C$86/2,F83,$C$83,$C$85),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(G87:R87)","v":"00:00:00"}]
[{"$f":"SUM(A86:A87)","v":0},"Installments, TOTAL:",{"$f":"SUM(D88:Q88)","v":0},{"$f":"SUM(D86:D87)","v":0},0,0,0,0,0,0,{"$f":"SUM(K86:K87)","v":0},0,0,0,0,0,0,0,0]
[]
["TOTAL:"," Loan \"B\", Balance liabilities",{"$f":"C17","v":{"$error":"#REF!"}},{"$f":"D17","v":{"$error":"#REF!"}},{"$f":"D90+E17","v":{"$error":"#REF!"}},{"$f":"E90+F17","v":{"$error":"#REF!"}},{"$f":"F90-F92","v":{"$error":"#REF!"}},{"$f":"G90-G92","v":{"$error":"#REF!"}},{"$f":"H90-H92","v":{"$error":"#REF!"}},{"$f":"I90-I92","v":{"$error":"#REF!"}},{"$f":"J90-J92","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"Q90-Q92","v":{"$error":"#REF!"}},{"$f":"R90-R92","v":{"$error":"#REF!"}}]
[{"$f":"SUM(D91:S91)","v":{"$error":"#REF!"}},"\u0085  Interest payments",{"$f":"'Cap.Goods'!H38","v":0.04},null,{"$f":"-ROUND(IPMT($C$91/2,E82,$C$82,D90),0)","v":{"$error":"#REF!"}},{"$f":"-ROUND(IPMT($C$91/2,F82,$C$82,E90),0)","v":{"$error":"#REF!"}},{"$f":"-ROUND(IPMT($C$91/2,G82,$C$82,F90),0)","v":{"$error":"#REF!"}},{"$f":"-ROUND(IPMT($C$91/2,H82,$C$82,G90),0)","v":{"$error":"#REF!"}},{"$f":"-ROUND(IPMT($C$91/2,I82,$C$82,H90),0)","v":{"$error":"#REF!"}},{"$f":"-ROUND(IPMT($C$91/2,J82,$C$82,I90),0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"-ROUND(IPMT($C$91/2,P82,$C$82,O90),0)","v":{"$error":"#REF!"}},{"$f":"-ROUND(IPMT($C$91/2,Q82,$C$82,P90),0)","v":{"$error":"#REF!"}},{"$f":"-ROUND(IPMT($C$91/2,R82,$C$82,Q90),0)","v":{"$error":"#REF!"}},{"$f":"-ROUND(IPMT($C$91/2,S82,$C$82,R90),0)","v":{"$error":"#REF!"}},{"$f":"SUM(G91:R91)","v":{"$error":"#REF!"}}]
[{"$f":"SUM(D92:Q92)","v":{"$error":"#REF!"}},"\u0085 Principal installments",{"$f":"ROUND(SUM(D92:S92),-1)","v":{"$error":"#REF!"}},null,null,null,{"$f":"-ROUND(PPMT($C$91/2,F83,$C$83,$C$90),0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"SUM(D93:S93)","v":{"$error":"#REF!"}},"Installments, TOTAL:",{"$f":"SUM(D93:Q93)","v":{"$error":"#REF!"}},{"$f":"SUM(D91:D92)","v":0},{"$f":"SUM(E91:E92)","v":{"$error":"#REF!"}},{"$f":"SUM(F91:F92)","v":{"$error":"#REF!"}},{"$f":"SUM(G91:G92)","v":{"$error":"#REF!"}},{"$f":"SUM(H91:H92)","v":{"$error":"#REF!"}},{"$f":"SUM(I91:I92)","v":{"$error":"#REF!"}},{"$f":"SUM(J91:J92)","v":{"$error":"#REF!"}},{"$f":"SUM(K91:K92)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM(P91:P92)","v":{"$error":"#REF!"}},{"$f":"SUM(Q91:Q92)","v":{"$error":"#REF!"}},{"$f":"SUM(R91:R92)","v":{"$error":"#REF!"}},{"$f":"SUM(S91:S92)","v":{"$error":"#REF!"}}]
["Diversification following from Risk Assessment"]
["OPERATIONAL TEST }  Balance liabilities",null,{"$f":"C77","v":{"$error":"#REF!"}},{"$f":"D77","v":{"$error":"#REF!"}},{"$f":"D95+E77","v":{"$error":"#REF!"}},{"$f":"E95+F77","v":{"$error":"#REF!"}},{"$f":"F95-F97","v":{"$error":"#REF!"}},{"$f":"G95-G97","v":{"$error":"#REF!"}},{"$f":"H95-H97","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"Q95-Q97","v":{"$error":"#REF!"}},{"$f":"R95-R97","v":{"$error":"#REF!"}}]
[{"$f":"ROUND(SUM(D96:Q96),-1)","v":{"$error":"#REF!"}},"\u0085  Interest payments",{"$f":"'Cap.Goods'!M38","v":5.5E-2},null,{"$f":"-ROUND(IPMT($C$96/2,E82,$C$82,D95),0)","v":{"$error":"#REF!"}},{"$f":"-ROUND(IPMT($C$96/2,F82,$C$82,E95),0)","v":{"$error":"#REF!"}},{"$f":"-ROUND(IPMT($C$96/2,G82,$C$82,F95),0)","v":{"$error":"#REF!"}},{"$f":"-ROUND(IPMT($C$96/2,G83,$C$83,G95),0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM(G96:R96)","v":{"$error":"#REF!"}}]
[null," Principal deferred payments",{"$f":"C77","v":{"$error":"#REF!"}},null,null,null,{"$f":"-ROUND(PPMT($C$96/2,F83,$C$83,$C$95),0)","v":{"$error":"#REF!"}},{"$f":"-ROUND(PPMT($C$96/2,H82,$C$82,$C$95),0)","v":{"$error":"#REF!"}},{"$f":"-ROUND(PPMT($C$96/2,I82,$C$82,$C$95),0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"-ROUND(PPMT($C$96/2,Q82,$C$82,$C$95),0)","v":{"$error":"#REF!"}},{"$f":"-ROUND(PPMT($C$96/2,R82,$C$82,$C$95),0)","v":{"$error":"#REF!"}},{"$f":"-ROUND(PPMT($C$96/2,S82,$C$82,$C$95),0)","v":{"$error":"#REF!"}}]
[null,"Installments, TOTAL:",null,null,{"$f":"SUM(E96:E97)","v":{"$error":"#REF!"}},{"$f":"SUM(F96:F97)","v":{"$error":"#REF!"}},{"$f":"SUM(G96:G97)","v":{"$error":"#REF!"}},{"$f":"SUM(H96:H97)","v":{"$error":"#REF!"}},{"$f":"SUM(I96:I97)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM(R96:R97)","v":{"$error":"#REF!"}},{"$f":"SUM(S96:S97)","v":{"$error":"#REF!"}}]
[]
[{"$f":"A86+A91+A96","v":{"$error":"#REF!"}},"GRAPHS",null,1,{"$f":"D100+1","v":2},{"$f":"E100+1","v":3},4,5,6,7,8,9,10,11,12,{"$f":"O100+1","v":13},{"$f":"P100+1","v":14},{"$f":"Q100+1","v":15},{"$f":"R100+1","v":16}]
[null,"Total balance liabilities,  Loan \"A\"",null,{"$f":"D85","v":0},0,{"$f":"F85","v":0},0,0,{"$f":"I85","v":0},0,0,0,0,0,0,0,0,{"$f":"R85","v":0},{"$f":"S85","v":0}]
[null,"OPERATING PERIOD } Total balance liabilities \"A\"","IN OPERATION",{"$f":"D85","v":0},{"$f":"E85","v":0},{"$f":"F85","v":0},{"$f":"G85","v":0},{"$f":"H85","v":0},{"$f":"I85","v":0},0,0,0,0,0,0,0,0,{"$f":"R85","v":0},{"$f":"S85","v":0}]
[{"$f":"IF(SUM(G86:Q86)=C85,\"True\",\"False\")","v":"True"},"Cash",null,{"$f":"D39","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"Cash Cumulative",null,{"$f":"D40","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Operating cash cumulative",null,{"$f":"D35","v":{"$error":"#REF!"}},{"$f":"D35+E35","v":{"$error":"#REF!"}},{"$f":"E35+F35","v":{"$error":"#REF!"}},{"$f":"F35+G35","v":{"$error":"#VALUE!"}},{"$f":"H125","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"up"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Debt Rate",{"$f":"D102/$C$18","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,"Start date"]
[null,"Auxiliary rows: Crossing point of cash and debt",{"$f":"D80","v":"2019-06-30"},1,{"$f":"D124+1","v":2},{"$f":"E124+1","v":3},4,5,6,7,8,9,10,{"$f":"M124+1","v":11},12,13,14,15,16]
[null,"Payback   >   cumulate OCFs",{"$f":"MATCH(A128,D105:Q105)","v":{"$error":"#N/A"}},{"$f":"$D$35","v":{"$error":"#REF!"}},{"$f":"D125+$E$35","v":{"$error":"#REF!"}},{"$f":"E125+$F$35","v":{"$error":"#REF!"}},{"$f":"F125+$G$35","v":{"$error":"#REF!"}},{"$f":"G125+$H$35","v":{"$error":"#REF!"}},{"$f":"H125+$I$35","v":{"$error":"#REF!"}},{"$f":"I125+$J$35","v":{"$error":"#REF!"}},{"$f":"J125+$K$35","v":{"$error":"#REF!"}},{"$f":"K125+$L$35","v":{"$error":"#REF!"}},{"$f":"L125+$M$35","v":{"$error":"#REF!"}},{"$f":"M125+$N$35","v":{"$error":"#REF!"}},{"$f":"N125+$O$35","v":{"$error":"#REF!"}},{"$f":"O125+$P$35","v":{"$error":"#REF!"}},{"$f":"P125+$Q$35","v":{"$error":"#REF!"}},{"$f":"Q125+$Q$35","v":{"$error":"#REF!"}},{"$f":"R125+$Q$35","v":{"$error":"#REF!"}}]
[null,"repayment estimatior row",{"$f":"DATE(YEAR(C124)+C125,MONTH(C124)+2,DAY(C124+7))","v":{"$error":"#N/A"}},{"$f":"CHOOSE(C125,E80,F80,G80,H80,I80,J80,K80,L80,M80,N80,O80,P80,Q80)","v":{"$error":"#N/A"}},{"$f":"C125*6","v":{"$error":"#N/A"}},{"$f":"E126/12","v":{"$error":"#N/A"}},{"$f":"ROUNDUP(F126,0)","v":{"$error":"#N/A"}},{"$f":"G126-F126","v":{"$error":"#N/A"}},{"$f":"H126*12","v":{"$error":"#N/A"}}]
[null,"auxiliary row","Payback date",null,{"$f":"(D126-E80)/12","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(E127,0)","v":{"$error":"#N/A"}},{"$f":"E127-F127","v":{"$error":"#N/A"}},{"$f":"G127*12","v":{"$error":"#N/A"}},{"$f":"IF(H127=12,F127+1,F127)","v":{"$error":"#N/A"}},{"$f":"IF(H127=12,0,H127)","v":{"$error":"#N/A"}}]
[{"$f":"C86","v":0.04},"Base forecast"]
[{"$f":"D132*365+1+E132*30+4","v":{"$error":"#N/A"}},"Yr:",null,1,2,3,4,5,6,7,8]
[{"$f":"A129/(365+1)","v":{"$error":"#N/A"}},"AnnNCinF",null,{"$f":"D39+E39","v":{"$error":"#REF!"}},{"$f":"F39+G39","v":{"$error":"#VALUE!"}},{"$f":"H39+I39","v":{"$error":"#VALUE!"}},{"$f":"J39+K39","v":{"$error":"#VALUE!"}},{"$f":"L39+M39","v":{"$error":"#VALUE!"}},{"$f":"N39+O39","v":{"$error":"#VALUE!"}},{"$f":"P39+Q39","v":{"$error":"#VALUE!"}}]
[{"$f":"D21","v":"2019-06-30"},"Comulative",null,{"$f":"D130","v":{"$error":"#REF!"}},{"$f":"D131+E130","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"A131+A129","v":{"$error":"#N/A"}},"Period",null,{"$f":"COUNTIF(D131:J131,\"<\"&A128)","v":0},{"$f":"F132*12/10","v":{"$error":"#N/A"}},{"$f":"(A128-HLOOKUP(COUNTIF(D131:J131,\"<\"&A128),D129:J131, 3,0))/(HLOOKUP(COUNTIF(D131:J131,\"<\"&A128)+1,D129:J131,2,0))*12","v":{"$error":"#N/A"}}]
[null,null,null,null," Ê   "," Indicates the fraction of the year"]
[]
[]
[null,null,null,0.22900000000000001,0.1787,0.14219999999999999,6.5500000000000003E-2,1.9900000000000001E-2,1.9E-3,0,0,1.2E-2,6.4399999999999999E-2,0.08,0.2064,{"$f":"SUM(D136:O136)","v":1}]

{"sheet":"Income","index":3,"n_rows":44,"n_cols":5,"rows_kept":44,"cut":false,"hidden":false,"merged":[[7,1,7,2],[0,2,0,3],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2],[31,1,31,2],[13,1,14,2],[15,1,15,2],[16,1,16,2],[18,1,19,2],[21,1,22,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[29,1,29,2],[30,1,30,2],[40,1,40,2],[41,1,42,2],[41,3,42,3],[43,1,43,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[37,1,37,2],[38,1,38,2],[39,1,39,2]]}
[null,"INCOME","Exchange Rate",null,"Price"]
[null,"PRICING - ELECTRICITY",1.6250000000000001E-2,"MKD/kWh","€/kWh"]
["A.","EVN MAKEDONIJA AD, Average supply. PRICE for the tariff consumers:",null,4.7309999999999999,{"$f":"$C$2*D3","v":7.6878749999999996E-2}]
[null,"AD ELEM - Skopje Production price",null,2.3704000000000001,{"$f":"$C$2*D4","v":3.8519000000000005E-2}]
[null,"AD MEPSO - Skopje Transmission tariff",null,0.2722,{"$f":"$C$2*D5","v":4.4232500000000001E-3}]
[null,"T.O.M. - Skopje Tariff for marketing, organization and management",null,1.8700000000000001E-2,{"$f":"$C$2*D6","v":3.0387500000000005E-4}]
["B.","Price of electric energy: ELEM + MEPSO + T.O.M. = Price of 110 kV:",null,{"$f":"SUM(D4:D6)","v":2.6612999999999998},{"$f":"SUM(E4:E6)","v":4.3246125000000003E-2}]
[null,"Middle value of payment (A. - B.): ",null,{"$f":"D3-D7","v":2.0697000000000001},{"$f":"(E3-E7)","v":3.3632624999999992E-2}]
[null,null,"€ p.h","€ p.h","€ p.h"]
[null,1,10,40,80]
[null,{"$f":"E8","v":3.3632624999999992E-2},{"$f":"$E$8*C10*1000","v":336.32624999999996},{"$f":"$E$8*D10*1000","v":1345.3049999999998},{"$f":"$E$8*E10*1000","v":2690.6099999999997}]
[null," p.Yr →",{"$f":"C11*24*365","v":2946217.9499999997},{"$f":"D11*24*365","v":11784871.799999999},{"$f":"E11*24*365","v":23569743.599999998}]
["Stages:"]
["u","Profit from 100% usage of the power from one standard transformer of→ multiplied by difference between the prices A.― B. herein above p.Yr→",null,12.7]
[null,null,null,{"$f":"D8*$D$14*1000","v":26285.19},{"$f":"E8*$D$14*1000","v":427.1343374999999}]
[null,"( x 24 h x 365 ) p.Yr→",null,{"$f":"D15*24*365","v":230258264.39999998},{"$f":"E15*24*365","v":3741696.7964999992}]
["v","Increasing the power up to 80 MW with replacement of the two trans-formers of 12.7 MW with 2 x 40 MW = 80 MW and with 50% usage,  p.Yr → ",null,{"$f":"D10","v":40},{"$f":"D12","v":11784871.799999999}]
[]
["w","Adding a new Transformer Field 3 with ETR 3 and with power 120 MW from 3 x 40 MW with space of 40 MW for reduce the risk, so usage p.Yr → "]
[null,null,null,{"$f":"E10","v":80},{"$f":"E12","v":23569743.599999998}]
[]
["x","Adding a new Transformer Field 4 with ETR 4 and with power 160 MW from 4 x 40 MW with space of 40 MW for reduce the risk, so usage p.Yr → "]
[null,null,null,120,{"$f":"E8*1000*D23*24*365","v":35354615.399999991}]
[]
[null,"PRICING - ELECTRICITY"]
[1,"Households subject to SINGLE-TARIFF metering",null,4.45,{"$f":"$C$2*D26","v":7.2312500000000002E-2}]
[{"$f":"A26+1","v":2},"Households subject to TWO-TARIFF metering peak tariff",null,5.54,9.0025000000000008E-2]
[{"$f":"A27+1","v":3},"Households subject to TWO-TARIFF metering off-peak tariff",null,2.78,4.5175E-2]
[4,"Consumers subject to I degree tariff (power)",null,746.5,12.130625]
[5,"Consumers subject to I degree tariff (energy) peak tariff",null,3.57,5.8012500000000002E-2]
[6,"Consumers subject to I degree tariff (energy)",null,1.76,2.86E-2]
[7,"Consumers subject to I degree tariff (energy) peak tariff",null,0.88,1.43E-2]
[8,"Consumers subject to I degree tariff (energy) off-peak tariff",null,0.45,7.3125000000000004E-3]
[9,"Consumers subject to II degree tariff(energy) single tariff",null,8.64,0.14040000000000002]
[10,"Consumers subject to II degree tariff (energy) single tariff",null,5.56,9.035E-2]
[null,"http://www.erc.org.mk/Default_en.aspx"]
[]
[null,"EVN MAKEDONIJA AD - Skopje Distribution tariff",null,1.7098]
[null,"AD ELEM ENERGETIKA Distribution tariff",null,0.1176]
[null,"AD ELEM ENERGETIKA Average supply price for the tariff consumers",null,2.9437000000000002]
[null,"Consumers connected to the distribution system 35 kV",null,4.12]
[null,"Consumers connected to the distribution system 35 kV by way of direct connection",null,4.8600000000000003]
[]
[null,"Consumers connected to the distribution system 10 (20) kV",null,4.72]

{"sheet":"Bayes","index":4,"n_rows":48,"n_cols":16,"rows_kept":48,"cut":false,"hidden":false,"merged":[[0,1,0,4],[1,1,1,4],[10,5,12,15],[6,9,6,15],[7,9,7,15],[8,9,8,15],[8,5,8,8],[9,5,9,15],[10,0,10,1],[12,0,12,1],[1,0,2,0],[6,0,6,1],[8,0,8,1],[27,16,28,16],[29,16,30,16],[30,1,31,15],[33,10,35,15],[14,2,14,3],[14,6,14,8],[14,10,14,14],[15,13,15,14],[20,11,21,11],[22,16,23,16],[23,1,24,15],[24,16,25,16],[25,0,26,15],[47,0,49,0],[43,1,43,2],[43,3,43,4],[43,5,43,6],[15,6,15,8],[27,1,29,15],[43,7,44,15],[44,1,44,2],[44,5,44,6],[45,1,45,2],[39,1,41,15]]}
["CHAPTER 1 ","DECISION ANALYSIS",null,null,null,null,null,null,null,null,null,"Name of Project"]
["Level④","POSTERIOR PROBABILITIES OF TWO EVENTS",null,null,null,null,null,null,null,null,null,{"$f":"Intro!H6","v":0}]
[]
["Background:","You are producer and supplier of high quality vegetables to two salesmen on large nets of European wholesale markets. Let A1 and A2 denoted two events of interest—different quantiies for sales."]
["Historical Info: ","Enter new data below. If except these two events of interest there are more probabilities indicated by the Online Cash-Flow Control System, go to the next Sheet\u0086 \"Bayes5\" ."]
[]
[" Event A1: part of QUANTITY for Salesman A1 →",null,{"$f":"BUDGET!M75","v":0.67}," Percentage of prior probability for sale on the market.",null,null,null,null,null,"The mutually exclusive events for which posterior probabilities are desired."]
[null,null,null,null,null,null,null,null,null,"My events of interest:"]
[" Event A2: part of QUANTITY for Salesman A2 →",null,{"$f":"100%-C7","v":0.32999999999999996}," Percentage supplied to A2   I ",null,"→ low quality of commercial service - term → of deferred payment and lower income.",null,null,null,"Which of both market distributors sells our products             on the better prices and pays us faster?"]
[null,null,null,null,null,"In analyzing of conditional prior probability for specific events of interest here are indicated probabilities giving new information for their revision"]
[" Event A1:  QUALITY Good services for Salesman A1 →",null,{"$f":"BUDGET!L75/100","v":0.79}," Percentage Good sаlеs and payments (G)",null,"Based on pre-design marketing the values of prior conditional probabilities of professional ratings of the two salesmen and their markets are shown in the Table. This prior probability will be revised in light of new operational information Income streams when appear problems, what is the probability and what part is due to each Sales-man? The Joint Bad Probabilities are found by multiplying the prior probabilities by the Conditional Probabilities = equal to Overall probability of finding the Bad part of commercial outsourcing, and for further improvement."]
[]
[" Event A2:  QUALITY  Bad services for Salesman A2 →",null,{"$f":"BUDGET!N75/100","v":0.21}," Percentage Bad sаlеs and payment (B)"]
[]
["Safe Event",null,"SALES REVENUE EVENTS",null,"PRIOR PROBABILITY",null,"POSTERIOR",null,null,null,"TABULAR APPROACH"]
["Restore Model","When Yu pay - cry"," Percentage of total  Sаlеs","Percentage Bad QUALITY Sаlеs","QUANTITY % from A1∩A2 Sаlеs",null,"      PROBABILITIES         that Bad part of sales is:",null,null,null,"A1U A2 Prior Probabilities","B Conditional Probabilities","Joint  Bad A1, 2 ∩ B","Posterior Probabilities",null,"Others cry"]
[]
["Clean Model","Salesman A1",{"$f":"C7","v":0.67},{"$f":"1-C11","v":0.20999999999999996},{"$f":"C7","v":0.67},null,"From Salesman A1:",null,{"$f":"D18*E18/(D18*E18+D20*E20)","v":0.67},null,{"$f":"C18","v":0.67},{"$f":"D18","v":0.20999999999999996},{"$f":"K18*L18","v":0.14069999999999999},{"$f":"M18/M21","v":0.67}]
[]
[null,"Salesman A2",{"$f":"C9","v":0.32999999999999996},{"$f":"C13","v":0.21},{"$f":"1-E18","v":0.32999999999999996},null,"From Salesman A2:",null,{"$f":"D20*E20/(D18*E18+D20*E20)","v":0.33},null,{"$f":"C20","v":0.32999999999999996},{"$f":"D20","v":0.21},{"$f":"K20*L20","v":6.9299999999999987E-2},{"$f":"M20/M21","v":0.33}]
["ANALYSIS:","On relative basis: the probability of the Bad event, coming from Salesman А2 [",null,null,null,{"$f":"N20","v":0.33},"] compared [",{"$f":"N18","v":0.67},"] from Good A1.",null,{"$f":"K18+K20","v":1},"To the new  info given each event",{"$f":"SUM(M18:M20)","v":0.20999999999999996},{"$f":"N18+N20","v":1},null,{"$f":"M21*10+O21*1","v":2.0999999999999996}]
[null,"There is a greater likelihood Bad event to be observed because outcome as [ ",null,null,null,{"$f":"M20","v":6.9299999999999987E-2},"] following  [",{"$f":"N20","v":0.33},"] A2 Bad event could be a crash.",null,null,null,"Overall <probability of Bad event="]
[]
["CLOSING:"]
[]
["       Constructed using \"Quantitative Methods for Business\" (Fifth edition); David R. Anderson, University of Cincinnati, Dennis J. Sweeney, University of Cincinnati, Thomas A. Williams, Rochester Institute of Technology; Library of Congress Cataloging-in-Publication Data."]
[]
["COMMENTS:","It is well known and certainly recommendable that to start an investment project, the investor (and his team making inside risk assessment) must be convinced, must believe in the good outcome, and he must act decisively, without any hesitation. Very often, this is reflected in a low assessment of the Default Risk Ratio (d--Factor) that is raising its real impact. In such cases we approach the above probability estimation, often called “what-if” analysis. It follows the High Qualified Audit, in this Risk Assessment program recognized as \"Group D\"."]
[]
[]
[null,"Excerpts from the comments of our clients of this model: \". . . default risk assessment is the starting point which most frequently cause disputes with the lenders, very often ending with denial of funding, no matter what the finally stated reason was.\" Look at the picture below, which is the most popular example of visible illusion.\n\n\n"]
[]
[]
[null,null," We are looking out to the market and don’t see a big risk to become unable to pay back our debt.",null,null,null,null,null,null,null,"Who is right, when the lengths of the lines are equal? . . . \""]
[]
[null,null,"        The lenders are only looking within themselves, see plenty of big risks, and talk only about it."]
[]
[null,"In making a decision for new investments never believe and rely solely on: ① your intuition, based on long-term experience; ② suggestions of high level experts; and ③ good chance."]
[null,"Rely only on risk assessment and computing of prior and posterior probability of specific events of interest. Once you have them, return to the above approaches for the final decision."]
[null,"The assessment of Default Risk (d ) to an acceptable level is a key factor for the positive resolution of a loan application. The system, called OCFCS for short, which we recommend is an instrument that serves post factum an investment throughout the project providing permanent online information to the lender, insurer and to the investor."]
[]
[]
[]
["RECORD:","PROJECT NAME",null,"QUALITY",null,"QUANTITY",null,"The event . . . "]
[null,"(or Investor Name)",null,"AGENT A1","AGENT A2","AGENT A1"]
[null,{"$f":"L2","v":0},null,0.98,0.95,null,0.65,"Agents distribute in their countries these percentages of KEM's products."]
[]
["Keep  these h cells free for longer project name extension"]

{"sheet":"Staff","index":5,"n_rows":43,"n_cols":12,"rows_kept":43,"cut":false,"hidden":false,"merged":[[6,4,7,5],[16,9,17,9],[0,9,1,9],[0,8,1,8],[15,7,15,8],[5,7,5,8],[6,9,7,9],[7,7,7,8],[17,7,17,8]]}
[null,null,null,"лв./$ exchange rate:",1,1.52,null,null,{"$f":"Intro!C84","v":5.8368000000000002},"Area "]
[null,null,null,"USD/EUR exchange rate:",1,1.05]
[null,null,null,"EUR/лв. exchange rate:",1,1.96,null,null,null,null,null,"Supporting Column"]
[]
[null,null,"OCFCS & Trading Consulting Company",null,null,"STAFF - Start Salaries"]
[null,null,null,"PERSONNEL, Position","%","€ p.Мо","p.ann","€ p.Mo",null,0]
[null,null,null,null,"Remuneration",null,null,"₊Bonus"]
[null,null,null,"WORKING ТЕАМ",null,null,null,"(conditional)"]
[null,null,1,"Manager",0.5,1000,{"$f":"E9*F9*$J$16","v":6000},100,{"$f":"E9*(F9+G9)","v":3500},{"$f":"E9*I9*$J$6","v":0}]
[null,null,{"$f":"C9+1","v":2},"Expert risk management",0.5,600,{"$f":"E10*F10*$J$16","v":3600},75,0,{"$f":"I10*$J$6","v":0}]
[null,null,{"$f":"C10+1","v":3},"Expert financial control",0.5,600,{"$f":"E11*F11*$J$16","v":3600},50,0,{"$f":"I11*$J$6","v":0}]
[null,null,null,"TOTAL:",{"$f":"E8","v":0},null,{"$f":"SUM(G9:G11)","v":13200},null,null,{"$f":"SUM(J9:J11)","v":0}]
[]
[]
[null,null,"Project Company TomCuC, Ltd.",null,null,"STAFF - Start Salaries"]
[null,null,null,"PERSONNEL, Position","Nr","€ p.Мо","p.ann","€ p.Mo",null,12]
[null,null,null,null,null,"Base salary","Fixed","₊Bonus","TOTAL"]
[null,null,null,"ASMINISTRATION",{"$f":"SUM(E19:E22)","v":6},"salary","salary","(conditional)"]
[null,null,1,"CEO - Manager",1,1000,{"$f":"E19*F19*$J$16","v":12000},300,{"$f":"F19+H19","v":1300},{"$f":"E19*I19*$J$16","v":15600}]
[null,null,{"$f":"C19+1","v":2},"Senior level technicans",2,800,{"$f":"E20*F20*$J$16","v":19200},200,{"$f":"F20+H20","v":1000},{"$f":"E20*I20*$J$16","v":24000}]
[null,null,{"$f":"C20+1","v":3},"Mid-level tehnicans",2,400,{"$f":"E21*F21*$J$16","v":9600},100,{"$f":"F21+H21","v":500},{"$f":"E21*I21*$J$16","v":12000}]
[null,null,{"$f":"C21+1","v":4},"Accountant",1,500,{"$f":"E22*F22*$J$16","v":6000},50,{"$f":"F22+H22","v":550},{"$f":"E22*I22*$J$16","v":6600}]
[null,null,null,"SERVICE STAFF",{"$f":"SUM(E24:E25)","v":5}]
[null,null,{"$f":"C22+1","v":5},"Truckers",1,500,{"$f":"E24*F24*$J$16","v":6000},50,{"$f":"F24+H24","v":550},{"$f":"E24*I24*$J$16","v":6600}]
[null,null,{"$f":"C24+1","v":6},"Security",4,400,{"$f":"E25*F25*$J$16","v":19200},0,{"$f":"F25+H25","v":400},{"$f":"E25*I25*$J$16","v":19200}]
[null,null,null,"SubTOTAL:",{"$f":"E18+E23","v":11},null,{"$f":"SUM(G19:G25)","v":72000},null,null,{"$f":"SUM(J19:J25)","v":84000}]
[]
[null,null,90,"PRODUCTION STAFF",{"$f":"E29","v":45}]
[null,null,7,"Payroll staff, p Mo",{"$f":"IF(AND($I$1>=10,C28>0),C28,IF(OR($I$1>=3,$I$1<=6),C28*1/2,IF(OR($I$1>=1,$I$1<3),30,0)))","v":45},400,{"$f":"E29*F29*$J$16","v":216000},100,{"$f":"F29+H29","v":500},{"$f":"E29*I29*$J$16","v":270000}]
[null,null,null,"Social Security (averaged)",null,null,{"$f":"G29*I30","v":37800},null,{"$f":"I37","v":0.17499999999999999},{"$f":"I30*J29","v":47250}]
[null,null,null,"SubTOTAL:",null,null,{"$f":"G29+G30","v":253800},null,null,{"$f":"SUM(J29:J30)","v":317250}]
[]
[null,null,null,"TomCuC HH, Ltd., TOTAL:",{"$f":"E26+E28","v":56},null,null,null,null,{"$f":"J26+J29","v":354000}]
[]
[]
[]
[null,null,null,"Social Security (averaged)",null,null,null,null,0.17499999999999999,{"$f":"I37*(J12+J26)","v":14699.999999999998}]
[null,null,null,"TOTAL:",null,null,null,null,null,{"$f":"J12+J33+J37","v":368700}]
[]
[]
[null,null,"*","Consequence of the need of Effective System of Internal Control during the repayment period."]
[null,null,null,"It must have to this position special Assignment of Responsibilities combining virtual treasurer and controller."]
[null,null,null,"He should have Limited Proper Authorization during the loan repayment period only."]

{"sheet":"Bayes5","index":6,"n_rows":20,"n_cols":16,"rows_kept":20,"cut":false,"hidden":false,"merged":[[17,14,17,17],[11,14,11,17],[12,14,12,17],[13,14,13,17],[14,14,14,17],[15,14,15,17],[16,14,16,17],[10,14,10,17],[1,1,1,8],[6,14,6,17],[7,14,7,17],[8,14,8,17],[9,14,9,17]]}
["CHAPTER 1 ",null,null,null,null,"DECEISION ANALYSES",null,null,null,null,null,null,null,null,null,"Name of Project"]
["       Budget","POSTERIOR PROBABILITIES OF FIVE EVENTS",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Cap.Goods'!E3","v":"Zoom 150        Capital Goods and Services - First Part"}]
[]
["Background:","Five mutually exclusive events following delivery of goods or services by Suppliers  where one of the events must occur when new information"]
["Clean and Start","from a sample, a special report, a product test, and so on, about it is received. Henceforth, you have to revise or update the prior probability values."]
["Historical Info: ","Good quality event \u0088  ENTER",null,null,null,null,null,"Complete here\u0088  the here Bad parts or services received from each supplier . "]
[null,null,"QUALITY",null,null,null,"QUANTITY",null,"POSTERIOR PROBABILITY",null,"CONDITIONAL",null,"FINAL",null,"NOTES"]
[null,null,"% Good",null,"% Bad",null,"% from",null,"that Bad event is:",null,"Joint  Bad A1,2 ∩B",null,"for Ai"]
[" Event A1 from:","Supplier A1 (Subcontractor)",null,null,{"$f":"1-C9","v":1},null,null,null,{"$f":"100*E9*G9/($E$9*$G$9+$E$11*$G$11+$E$13*$G$13+$E$15*$G$15+$E$17*$G$17)","v":0},null,{"$f":"100*G9*E9","v":0},null,{"$f":"K9/$K$19","v":0}]
[]
[" Event A2 from:","Supplier A2 (Subcontractor)",null,null,{"$f":"1-C11","v":1},null,null,null,{"$f":"100*E11*G11/($E$9*$G$9+$E$11*$G$11+$E$13*$G$13+$E$15*$G$15+$E$17*$G$17)","v":0},null,{"$f":"100*G11*E11","v":0},null,{"$f":"K11/$K$19","v":0}]
[]
[" Event A3 from:","Supplier A3  (Subcontractor)",null,null,{"$f":"1-C13","v":1},null,null,null,{"$f":"100*E13*G13/($E$9*$G$9+$E$11*$G$11+$E$13*$G$13+$E$15*$G$15+$E$17*$G$17)","v":0},null,{"$f":"100*G13*E13","v":0},null,{"$f":"K13/$K$19","v":0}]
[]
[" Event A4 from:","Supplier A4 (Subcontractor)",null,null,{"$f":"1-C15","v":1},null,null,null,{"$f":"100*E15*G15/($E$9*$G$9+$E$11*$G$11+$E$13*$G$13+$E$15*$G$15+$E$17*$G$17)","v":0},null,{"$f":"100*G15*E15","v":0},null,{"$f":"K15/$K$19","v":0}]
[]
[" Event A5 from:","Supplier A5  (Subcontractor)",null,null,{"$f":"1-C17","v":1},null,{"$f":"1-SUM(G9:G15)","v":1},null,{"$f":"100*E17*G17/($E$9*$G$9+$E$11*$G$11+$E$13*$G$13+$E$15*$G$15+$E$17*$G$17)","v":100},null,{"$f":"100*G17*E17","v":100},null,{"$f":"K17/$K$19","v":1}]
[]
["See Comments",null,null,null,null,null,null,null,null,null,{"$f":"SUM(K9:K18)","v":100},null,{"$f":"SUM(M9:M18)","v":1}]
[null,null,null,null,null,null,null,null,null,null,"Overall<probability of happen Bad event"]

{"sheet":"Expenses","index":7,"n_rows":39,"n_cols":10,"rows_kept":39,"cut":false,"hidden":false,"merged":[[0,1,1,1],[0,5,1,5],[0,6,1,6]]}
[null,"КАПИТАЛНИ ТРОШОЦИ",null,"Single Prs","СЕ ВКУПНО",null,"CAPITAL EXPENSES",null,"Single Prs","Total"]
[null,null,null,"€",null,null,null,"Nr","€","€"]
[1,"Постројка ТС 110/20kV со 2 ЕТР Документација со државни институции, изработка и ревизија на основен проект, градежна дозвола",1,150000,{"$f":"C3*D3","v":150000},1,"Station TS 110 / 20kV with 2 ETR documentation with state institutions, preparation and revision of basic project, building permit",1,150000,{"$f":"H3*I3","v":150000}]
[{"$f":"A3+1","v":2},"Постројка ТС 110/20kV со 2 ДВ + 2 ТР полиња и 2 ЕТР",null,null,null,{"$f":"F3+1","v":2},"Station TS 110 / 20kV with 2 TR fields and 2 ETC"]
["2.1.","Градежни работи парче  ",1,814000,{"$f":"C5*D5","v":814000},"2.1.","Building works sincle",1,814000,{"$f":"H5*I5","v":814000}]
["2.2.","110 kV построение парче  ",2,300000,{"$f":"C6*D6","v":600000},"2.2.","118 kv building sincle",2,300000,{"$f":"H6*I6","v":600000}]
["2.3.","20 kV построение парче",1,200000,{"$f":"C7*D7","v":200000},"2.3.","20 kv building sincle",1,200000,{"$f":"H7*I7","v":200000}]
["2.4.","НН инсталација, управување и релејна заштиа парче",1,350000,{"$f":"C8*D8","v":350000},"2.4.","NN installation, management and relay protection sincle",1,350000,{"$f":"H8*I8","v":350000}]
["2.5.","Eнергетски трансформатори 40 МВА ",2,700000,{"$f":"C9*D9","v":1400000},"2.5.","Energy Transformers 40 MW",2,700000,{"$f":"H9*I9","v":1400000}]
[null,"Вкупно:",null,null,{"$f":"SUM(E5:E9)","v":3364000},null,"SubTotal:",null,null,{"$f":"SUM(J5:J9)","v":3364000}]
[3,"Разводни постројки",null,null,null,3,"Distribution plants"]
["3.1.","20 kV Разводна постројка Алумина",1,200000,{"$f":"C12*D12","v":200000},"3.1.","20 kV building sincle Alumina",1,200000,{"$f":"H12*I12","v":200000}]
["3.2.","20 kV Разводна постројка Лимак",1,200000,{"$f":"C13*D13","v":200000},"3.2.","20 kV building sincle Limak",0,200000,{"$f":"H13*I13","v":0}]
[3.3,"20 kV Разводна постројка Визбегово",1,200000,{"$f":"C14*D14","v":200000},3.3,"20 kV building sincle Vizbegovo",0,200000,{"$f":"H14*I14","v":0}]
["3.4.","Документација ,одобренија ,испитувања…",1,150000,{"$f":"C15*D15","v":150000},"3.4.","Documentation, approvals, surveys ...",1,150000,{"$f":"H15*I15","v":150000}]
[null,"Вкупно:",null,null,{"$f":"SUM(E12:E15)","v":750000},null,"SubTotal:",null,null,{"$f":"SUM(J12:J15)","v":350000}]
[4,"Планирани 20 kV кабловски врски",null,null,null,4,"Planned 20 kV cable connections"]
["4.1.","20 kV кабловски врски до Алумина",2,200000,{"$f":"C18*D18","v":400000},"4.1.","20 kV cable connections to Alumina",2,200000,{"$f":"H18*I18","v":400000}]
["4.2.","20 kV кабловски врски од Алумина / Визбегово",2,275000,{"$f":"C19*D19","v":550000},"4.2.","20 kV cable connections from Alumina to→q Vizbegovo  ",0,275000,{"$f":"H19*I19","v":0}]
[4.3,"20 kV кабловски врски до Алумина / Лимак",2,275000,{"$f":"C20*D20","v":550000},4.3,"20 kV cable connections from Alumina to→q Limak  ",0,275000,{"$f":"H20*I20","v":0}]
[4.4000000000000004,"Документација, одобренија, испитувања …",1,150000,{"$f":"C21*D21","v":150000},4.4000000000000004,"Documentation, approved, surveyed ...",1,150000,{"$f":"H21*I21","v":150000}]
[null,"Вкупно:",null,null,{"$f":"SUM(E18:E21)","v":1650000},null,"SubTotal:",null,null,{"$f":"SUM(J18:J21)","v":550000}]
[5,"20/04 kV трансформаторски станици",null,null,null,5,"20/40 kV transformer stations"]
["5.1.","Документација парче",1,80000,{"$f":"C24*D24","v":80000},"5.1.","Documentation single",1,80000,{"$f":"H24*I24","v":80000}]
[5.2,"комплет 1000 кVА (апроксимирано) ",40,40000,{"$f":"C25*D25","v":1600000},5.2,"Set 1000 kVA",40,40000,{"$f":"H25*I25","v":1600000}]
[null,"Вкупно:",null,null,{"$f":"SUM(E24:E25)","v":1680000},null,null,null,null,{"$f":"SUM(J24:J25)","v":1680000}]
[6,"Откуп на земјиште за ТС",1,300000,{"$f":"C27*D27","v":300000},6,"Land Acquisition for TS",1,300000,{"$f":"H27*I27","v":300000}]
[{"$f":"A27+1","v":7},"Постројка ТС 110/20 kV со 2 ДВ + 2 ТР+ Спојно полиња",null,null,null,{"$f":"F27+1","v":7},"Plant TS 110/20 kV with 2 DW + 2 TR + connection fields"]
["7.1.","Градежни работи парче",1,814000,{"$f":"C29*D29","v":814000},"7.1.","Construction - single",1,814000,{"$f":"H29*I29","v":814000}]
["7.2.","110 kV построение парче",5,400000,{"$f":"C30*D30","v":2000000},"7.2.","110 kV construction,  single",5,400000,{"$f":"H30*I30","v":2000000}]
["7.3.","20 kV построение парче",1,200000,{"$f":"C31*D31","v":200000},"7.3.","20 kV construction,  single",1,200000,{"$f":"H31*I31","v":200000}]
["7.4.","НН инсталација, управување и релејна заштиа парче",1,550000,{"$f":"C32*D32","v":550000},"7.4.","NN installation, management and relay protection, single",1,550000,{"$f":"H32*I32","v":550000}]
["7.5.","Eнергетски трансформатори 12,7 МVА (сервисирани)",2,50000,{"$f":"C33*D33","v":100000},"7.5.","Power transformers 12.7 MW (serviced)",2,50000,{"$f":"H33*I33","v":100000}]
[null,"Вкупно:",null,null,{"$f":"SUM(E29:E33)","v":3664000},null,null,null,null,{"$f":"SUM(J29:J33)","v":3664000}]
[null,null,null,null,{"$f":"E3+E10+E16+E22+E26+E27+E34","v":11558000},null,"TOTAL:",null,null,{"$f":"J3+J10+J16+J22+J26+J27+J34","v":10058000}]
[]
[1,"Закупуване на подстанцията",1,500000,{"$f":"C37*D37","v":500000},1,"Purchase of the substation",1,500000,{"$f":"H37*I37","v":500000}]
[2,"Фин. модел за проектно финансиране",1,350000,{"$f":"C38*D38","v":350000},2,"Fin. Modeling for project finance",1,360000,{"$f":"H38*I38","v":360000}]
[null,"ВСЕ ВКУПНО:",null,{"$f":"SUM(D37:D38)","v":850000},{"$f":"E3+E10+E16+E22+E26+E27+E34+E37+E38","v":12408000},null,"TOTAL:",null,null,{"$f":"J3+J10+J16+J22+J26+J27+J34+J37+J38","v":10918000}]