{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Financial Report","Financial Data Input","Key Metric Settings","Calculations"],"not_rendered":{"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"Financial Report","index":0,"n_rows":40,"n_cols":11,"rows_kept":40,"merged":[[1,10,1,11],[6,9,6,11],[7,9,7,11],[8,9,8,11],[9,9,9,11],[14,8,14,11],[15,8,15,11],[16,8,16,11],[17,8,17,11],[18,8,18,11],[19,8,19,11],[20,8,20,11],[21,8,21,11],[22,8,22,11],[23,8,23,11],[24,8,24,11],[25,8,25,11],[26,8,26,11],[27,8,27,11],[28,8,28,11],[29,8,29,11],[30,8,30,11],[31,8,31,11],[32,8,32,11],[33,8,33,11],[34,8,34,11],[35,8,35,11],[36,8,36,11],[37,8,37,11],[38,8,38,11],[39,8,39,11]]}
[]
[null,"ANNUAL FINANCIAL REPORT",{"$nulls":8},2012]
[null,"YOUR COMPANY NAME"]
[]
[null,"KEY METRICS"]
[]
[null,{"$f":"Calculations!B8","v":"REVENUES"},null,{"$f":"Calculations!B9","v":"OPERATING PROFIT"},null,{"$f":"Calculations!B10","v":"INTEREST"},null,{"$f":"Calculations!B11","v":"DEPRECIATION"},null,{"$f":"Calculations!B12","v":"NET PROFIT"}]
[null,{"$f":"IFERROR(Calculations!G8,\"\")","v":{"v":180583.88479646543,"d":"$180,584"}},null,{"$f":"IFERROR(Calculations!G9,\"\")","v":{"v":73425.9959797783,"d":"$73,426"}},null,{"$f":"IFERROR(Calculations!G10,\"\")","v":{"v":3789.4733908108906,"d":"$3,789"}},null,{"$f":"IFERROR(Calculations!G11,\"\")","v":{"v":5546.885548091393,"d":"$5,547"}},null,{"$f":"IFERROR(Calculations!G12,\"\")","v":{"v":67474.85858092597,"d":"$67,475"}}]
[null,{"$f":"Calculations!H8","v":{"v":3.0953514310549934E-3,"d":"0%"}},null,{"$f":"Calculations!H9","v":{"v":-0.050335610544087306,"d":"-5%"}},null,{"$f":"Calculations!H10","v":{"v":0.1351481162845234,"d":"14%"}},null,{"$f":"Calculations!H11","v":{"v":0.0944005691982619,"d":"9%"}},null,{"$f":"Calculations!H12","v":{"v":0.018148764080201163,"d":"2%"}}]
[]
[]
[]
[null,"ALL METRICS"]
[]
[null,"METRIC",null,{"$f":"\"THIS YEAR (\"&SelectedYear&\")\"","v":"THIS YEAR (2012)"},null,{"$f":"\"LAST YEAR (\"&SelectedYear-1&\")\"","v":"LAST YEAR (2011)"},null,"% CHANGE","5 YEAR TREND"]
[null,{"$f":"Calculations!B15","v":"REVENUES"},null,{"$f":"IF($B16=\"\",\"\",Calculations!G15)","v":{"v":180583.88479646543,"d":"$180,583.88"}},null,{"$f":"IF($B16=\"\",\"\",Calculations!F15)","v":{"v":180026.63908155632,"d":"$180,026.64"}},null,{"$f":"IFERROR(D16/F16-1,\"\")","v":{"v":3.0953514310549934E-3,"d":"0%"}}]
[null,{"$f":"Calculations!B16","v":"OPERATING EXPENSES"},null,{"$f":"IF($B17=\"\",\"\",Calculations!G16)","v":{"v":94419.45802509892,"d":"$94,419.46"}},null,{"$f":"IF($B17=\"\",\"\",Calculations!F16)","v":{"v":80883.3309479549,"d":"$80,883.33"}},null,{"v":0.1673537293593157,"d":"17%"}]
[null,{"$f":"Calculations!B17","v":"OPERATING PROFIT"},null,{"$f":"IF($B18=\"\",\"\",Calculations!G17)","v":{"v":73425.9959797783,"d":"$73,426.00"}},null,{"$f":"IF($B18=\"\",\"\",Calculations!F17)","v":{"v":77317.8364852092,"d":"$77,317.84"}},null,{"v":-0.050335610544087306,"d":"-5%"}]
[null,{"$f":"Calculations!B18","v":"DEPRECIATION"},null,{"$f":"IF($B19=\"\",\"\",Calculations!G18)","v":{"v":5546.885548091393,"d":"$5,546.89"}},null,{"$f":"IF($B19=\"\",\"\",Calculations!F18)","v":{"v":5068.423486068671,"d":"$5,068.42"}},null,{"v":0.0944005691982619,"d":"9%"}]
[null,{"$f":"Calculations!B19","v":"INTEREST"},null,{"$f":"IF($B20=\"\",\"\",Calculations!G19)","v":{"v":3789.4733908108906,"d":"$3,789.47"}},null,{"$f":"IF($B20=\"\",\"\",Calculations!F19)","v":{"v":3338.3074300596945,"d":"$3,338.31"}},null,{"v":0.1351481162845234,"d":"14%"}]
[null,{"$f":"Calculations!B20","v":"NET PROFIT"},null,{"$f":"IF($B21=\"\",\"\",Calculations!G20)","v":{"v":67474.85858092597,"d":"$67,474.86"}},null,{"$f":"IF($B21=\"\",\"\",Calculations!F20)","v":{"v":66272.10183954106,"d":"$66,272.10"}},null,{"v":0.018148764080201163,"d":"2%"}]
[null,{"$f":"Calculations!B21","v":"TAX"},null,{"$f":"IF($B22=\"\",\"\",Calculations!G21)","v":{"v":31408.25563943774,"d":"$31,408.26"}},null,{"$f":"IF($B22=\"\",\"\",Calculations!F21)","v":{"v":29424.531926280673,"d":"$29,424.53"}},null,{"v":0.0674173413574437,"d":"7%"}]
[null,{"$f":"Calculations!B22","v":"PROFIT AFTER TAX"},null,{"$f":"IF($B23=\"\",\"\",Calculations!G22)","v":{"v":50247.68426868668,"d":"$50,247.68"}},null,{"$f":"IF($B23=\"\",\"\",Calculations!F22)","v":{"v":42438.204209783944,"d":"$42,438.20"}},null,{"v":0.1840200405346628,"d":"18%"}]
[null,{"$f":"Calculations!B23","v":"METRIC 1"},null,{"$f":"IF($B24=\"\",\"\",Calculations!G23)","v":{"v":19.964456213989912,"d":"$19.96"}},null,{"$f":"IF($B24=\"\",\"\",Calculations!F23)","v":{"v":16.78665780324392,"d":"$16.79"}},null,{"v":0.1893050092515678,"d":"19%"}]
[null,{"$f":"Calculations!B24","v":"METRIC 2"},null,{"$f":"IF($B25=\"\",\"\",Calculations!G24)","v":{"v":26.0197642065095,"d":"$26.02"}},null,{"$f":"IF($B25=\"\",\"\",Calculations!F24)","v":{"v":21.84410933880771,"d":"$21.84"}},null,{"v":0.19115702100444198,"d":"19%"}]
[null,{"$f":"Calculations!B25","v":"METRIC 3"},null,{"$f":"IF($B26=\"\",\"\",Calculations!G25)","v":{"v":31.086507537181795,"d":"$31.09"}},null,{"$f":"IF($B26=\"\",\"\",Calculations!F25)","v":{"v":26.395902516700666,"d":"$26.40"}},null,{"v":0.17770201331488433,"d":"18%"}]
[null,{"$f":"Calculations!B26","v":"METRIC 4"},null,{"$f":"IF($B27=\"\",\"\",Calculations!G26)","v":{"v":14.924556664330456,"d":"$14.92"}},null,{"$f":"IF($B27=\"\",\"\",Calculations!F26)","v":{"v":14.590312329610818,"d":"$14.59"}},null,{"v":0.022908648366717577,"d":"2%"}]
[null,{"$f":"Calculations!B27","v":"METRIC 5"},null,{"$f":"IF($B28=\"\",\"\",Calculations!G27)","v":{"v":1.0365471137530806,"d":"$1.04"}},null,{"$f":"IF($B28=\"\",\"\",Calculations!F27)","v":{"v":1.0026426573298342,"d":"$1.00"}},null,{"v":0.033815094715337946,"d":"3%"}]
[null,{"$f":"Calculations!B28","v":"METRIC 6"},null,{"$f":"IF($B29=\"\",\"\",Calculations!G28)","v":{"v":0.34477763556381397,"d":"$0.34"}},null,{"$f":"IF($B29=\"\",\"\",Calculations!F28)","v":{"v":0.3086432107399634,"d":"$0.31"}},null,{"v":0.11707506780148913,"d":"12%"}]
[null,{"$f":"Calculations!B29","v":""},null,{"$f":"IF($B30=\"\",\"\",Calculations!G29)","v":""},{"$f":"IF($B30=\"\",\"\",Calculations!F29)","v":""},null,null,{"$f":"IFERROR(D30/E30-1,\"\")","v":""}]
[null,{"$f":"Calculations!B30","v":""},null,{"$f":"IF($B31=\"\",\"\",Calculations!G30)","v":""},{"$f":"IF($B31=\"\",\"\",Calculations!F30)","v":""},null,null,""]
[null,{"$f":"Calculations!B31","v":""},null,{"$f":"IF($B32=\"\",\"\",Calculations!G31)","v":""},{"$f":"IF($B32=\"\",\"\",Calculations!F31)","v":""},null,null,""]
[null,{"$f":"Calculations!B32","v":""},null,{"$f":"IF($B33=\"\",\"\",Calculations!G32)","v":""},{"$f":"IF($B33=\"\",\"\",Calculations!F32)","v":""},null,null,""]
[null,{"$f":"Calculations!B33","v":""},null,{"$f":"IF($B34=\"\",\"\",Calculations!G33)","v":""},{"$f":"IF($B34=\"\",\"\",Calculations!F33)","v":""},null,null,""]
[null,{"$f":"Calculations!B34","v":""},null,{"$f":"IF($B35=\"\",\"\",Calculations!G34)","v":""},{"$f":"IF($B35=\"\",\"\",Calculations!F34)","v":""},null,null,""]
[null,{"$f":"Calculations!B35","v":""},null,{"$f":"IF($B36=\"\",\"\",Calculations!G35)","v":""},{"$f":"IF($B36=\"\",\"\",Calculations!F35)","v":""},null,null,""]
[null,{"$f":"Calculations!B36","v":""},null,{"$f":"IF($B37=\"\",\"\",Calculations!G36)","v":""},{"$f":"IF($B37=\"\",\"\",Calculations!F36)","v":""},null,null,""]
[null,{"$f":"Calculations!B37","v":""},null,{"$f":"IF($B38=\"\",\"\",Calculations!G37)","v":""},{"$f":"IF($B38=\"\",\"\",Calculations!F37)","v":""},null,null,""]
[null,{"$f":"Calculations!B38","v":""},null,{"$f":"IF($B39=\"\",\"\",Calculations!G38)","v":""},{"$f":"IF($B39=\"\",\"\",Calculations!F38)","v":""},null,null,""]
[null,{"$f":"Calculations!B39","v":""},null,{"$f":"IF($B40=\"\",\"\",Calculations!G39)","v":""},{"$f":"IF($B40=\"\",\"\",Calculations!F39)","v":""},null,null,""]

{"sheet":"Financial Data Input","index":1,"n_rows":19,"n_cols":9,"rows_kept":19}
[]
[null,"INPUT YOUR FINANCIAL DATA"]
[null," YOU CAN DEFINE UP TO 25 KEY METRICS"]
[]
[null,"METRIC NAME",2006,2007,2008,2009,2010,2011,2012]
[null,"REVENUES",{"v":125000,"d":"$125,000.00"},{"v":134137.45482766724,"d":"$134,137.45"},{"v":142728.38430660142,"d":"$142,728.38"},{"v":150687.465060636,"d":"$150,687.47"},{"v":165044.56114573785,"d":"$165,044.56"},{"v":180026.63908155632,"d":"$180,026.64"},{"v":180583.88479646543,"d":"$180,583.88"}]
[null,"OPERATING EXPENSES",{"v":65000,"d":"$65,000.00"},{"v":70962.31248353251,"d":"$70,962.31"},{"v":75924.86559784267,"d":"$75,924.87"},{"v":78901.27843996584,"d":"$78,901.28"},{"v":81674.37146726911,"d":"$81,674.37"},{"v":80883.3309479549,"d":"$80,883.33"},{"v":94419.45802509892,"d":"$94,419.46"}]
[null,"OPERATING PROFIT",{"v":60000,"d":"$60,000.00"},{"v":64207.303876430284,"d":"$64,207.30"},{"v":68857.69054342684,"d":"$68,857.69"},{"v":75643.2552108195,"d":"$75,643.26"},{"v":76755.26152886634,"d":"$76,755.26"},{"v":77317.8364852092,"d":"$77,317.84"},{"v":73425.9959797783,"d":"$73,426.00"}]
[null,"DEPRECIATION",{"v":4500,"d":"$4,500.00"},{"v":4517.773061592387,"d":"$4,517.77"},{"v":4656.924613542916,"d":"$4,656.92"},{"v":4974.2116368359975,"d":"$4,974.21"},{"v":5024.111162299069,"d":"$5,024.11"},{"v":5068.423486068671,"d":"$5,068.42"},{"v":5546.885548091393,"d":"$5,546.89"}]
[null,"INTEREST",{"v":2500,"d":"$2,500.00"},{"v":2745.8210188620947,"d":"$2,745.82"},{"v":2893.112497282722,"d":"$2,893.11"},{"v":3136.1282291672965,"d":"$3,136.13"},{"v":3148.5301372295735,"d":"$3,148.53"},{"v":3338.3074300596945,"d":"$3,338.31"},{"v":3789.4733908108906,"d":"$3,789.47"}]
[null,"NET PROFIT",{"v":54000,"d":"$54,000.00"},{"v":54761.075913184526,"d":"$54,761.08"},{"v":55860.8161858705,"d":"$55,860.82"},{"v":59747.95829384081,"d":"$59,747.96"},{"v":61483.593541849004,"d":"$61,483.59"},{"v":66272.10183954106,"d":"$66,272.10"},{"v":67474.85858092597,"d":"$67,474.86"}]
[null,"TAX",{"v":22000,"d":"$22,000.00"},{"v":23920.545558764275,"d":"$23,920.55"},{"v":25576.741264835484,"d":"$25,576.74"},{"v":27498.86192261478,"d":"$27,498.86"},{"v":28335.67577515124,"d":"$28,335.68"},{"v":29424.531926280673,"d":"$29,424.53"},{"v":31408.25563943774,"d":"$31,408.26"}]
[null,"PROFIT AFTER TAX",{"v":32000,"d":"$32,000.00"},{"v":34943.4915856598,"d":"$34,943.49"},{"v":38418.532268713716,"d":"$38,418.53"},{"v":39895.053057716366,"d":"$39,895.05"},{"v":40607.73962966755,"d":"$40,607.74"},{"v":42438.204209783944,"d":"$42,438.20"},{"v":50247.68426868668,"d":"$50,247.68"}]
[null,"METRIC 1",{"v":12.8,"d":"$12.80"},{"v":12.81242625438803,"d":"$12.81"},{"v":13.784416456043646,"d":"$13.78"},{"v":14.292893230717713,"d":"$14.29"},{"v":15.57801620970704,"d":"$15.58"},{"v":16.78665780324392,"d":"$16.79"},{"v":19.964456213989912,"d":"$19.96"}]
[null,"METRIC 2",{"v":18.2,"d":"$18.20"},{"v":18.59252210009098,"d":"$18.59"},{"v":19.220660937603707,"d":"$19.22"},{"v":20.172419365352766,"d":"$20.17"},{"v":20.48417465833084,"d":"$20.48"},{"v":21.84410933880771,"d":"$21.84"},{"v":26.0197642065095,"d":"$26.02"}]
[null,"METRIC 3",{"v":19.1,"d":"$19.10"},{"v":20.556151890338352,"d":"$20.56"},{"v":21.87460134031757,"d":"$21.87"},{"v":23.19302954817104,"d":"$23.19"},{"v":24.676402313128037,"d":"$24.68"},{"v":26.395902516700666,"d":"$26.40"},{"v":31.086507537181795,"d":"$31.09"}]
[null,"METRIC 4",{"v":12.1,"d":"$12.10"},{"v":12.218121082988416,"d":"$12.22"},{"v":12.59253323064809,"d":"$12.59"},{"v":13.705566638410549,"d":"$13.71"},{"v":13.762117100061495,"d":"$13.76"},{"v":14.590312329610818,"d":"$14.59"},{"v":14.924556664330456,"d":"$14.92"}]
[null,"METRIC 5",{"v":0.75,"d":"$0.75"},{"v":0.794374414854603,"d":"$0.79"},{"v":0.8528964777490574,"d":"$0.85"},{"v":0.8918172064689517,"d":"$0.89"},{"v":0.9151184649381309,"d":"$0.92"},{"v":1.0026426573298342,"d":"$1.00"},{"v":1.0365471137530806,"d":"$1.04"}]
[null,"METRIC 6",{"v":0.23,"d":"$0.23"},{"v":0.2529878964799475,"d":"$0.25"},{"v":0.27306339198662744,"d":"$0.27"},{"v":0.2805922957857658,"d":"$0.28"},{"v":0.29660907186605134,"d":"$0.30"},{"v":0.3086432107399634,"d":"$0.31"},{"v":0.34477763556381397,"d":"$0.34"}]

{"sheet":"Key Metric Settings","index":2,"n_rows":9,"n_cols":4,"rows_kept":9}
[]
[null,"DEFINE KEY METRICS HERE"]
[null," YOU CAN SHOW UP TO 5 KEY METRICS AT THE TOP OF THE REPORT"]
[]
[null,1,"REVENUES",{"$f":"IF(ISBLANK(C5),\"← Please select a value from drop-down\",IF(COUNTIF($C$5:C5,C5)>1,\"You have selected \"&C5&\" twice.\",\"\"))","v":""}]
[null,2,"OPERATING PROFIT",{"$f":"IF(ISBLANK(C6),\"← Please select a value from drop-down\",IF(COUNTIF($C$5:C6,C6)>1,\"You have selected \"&C6&\" twice.\",\"\"))","v":""}]
[null,3,"INTEREST",{"$f":"IF(ISBLANK(C7),\"← Please select a value from drop-down\",IF(COUNTIF($C$5:C7,C7)>1,\"You have selected \"&C7&\" twice.\",\"\"))","v":""}]
[null,4,"DEPRECIATION",{"$f":"IF(ISBLANK(C8),\"← Please select a value from drop-down\",IF(COUNTIF($C$5:C8,C8)>1,\"You have selected \"&C8&\" twice.\",\"\"))","v":""}]
[null,5,"NET PROFIT",{"$f":"IF(ISBLANK(C9),\"← Please select a value from drop-down\",IF(COUNTIF($C$5:C9,C9)>1,\"You have selected \"&C9&\" twice.\",\"\"))","v":""}]

{"sheet":"Calculations","index":3,"n_rows":39,"n_cols":8,"rows_kept":39,"hidden":true}
["This worksheet is used for the Financial Report calculations and should remain hidden."]
[{"$nulls":3},"Position"]
[null,"This year",{"$f":"SelectedYear","v":2012},{"$f":"MATCH(C3,lstYears,0)+1","v":8}]
[null,"Previous Year",{"$f":"C3-1","v":2011},{"$f":"MATCH(C4,lstYears,0)+1","v":7}]
[]
[null,"Position",{"$f":"MATCH(C7,lstYears,0)+1","v":4},{"$f":"MATCH(D7,lstYears,0)+1","v":5},{"$f":"MATCH(E7,lstYears,0)+1","v":6},{"$f":"MATCH(F7,lstYears,0)+1","v":7},{"$f":"MATCH(G7,lstYears,0)+1","v":8}]
[null,"Key Metrics",{"$f":"D7-1","v":2008},{"$f":"E7-1","v":2009},{"$f":"F7-1","v":2010},{"$f":"G7-1","v":2011},{"$f":"C3","v":2012}]
[{"$f":"MATCH(B8,'Financial Data Input'!$B$6:$B$20,0)","v":1},{"$f":"IF('Key Metric Settings'!C5=\"\",\"\",'Key Metric Settings'!C5)","v":"REVENUES"},{"$f":"IFERROR(INDEX('Financial Data Input'!$B$6:$I$20,$A8,C$6),NA())","v":142728.38430660142},{"$f":"IFERROR(INDEX('Financial Data Input'!$B$6:$I$20,$A8,D$6),NA())","v":150687.465060636},{"$f":"IFERROR(INDEX('Financial Data Input'!$B$6:$I$20,$A8,E$6),NA())","v":165044.56114573785},{"$f":"IFERROR(INDEX('Financial Data Input'!$B$6:$I$20,$A8,F$6),NA())","v":180026.63908155632},{"$f":"IFERROR(INDEX('Financial Data Input'!$B$6:$I$20,$A8,G$6),NA())","v":180583.88479646543},{"$f":"IFERROR(G8/F8-1,\"\")","v":{"v":3.0953514310549934E-3,"d":"0%"}}]
[{"$f":"MATCH(B9,'Financial Data Input'!$B$6:$B$20,0)","v":3},{"$f":"IF('Key Metric Settings'!C6=\"\",\"\",'Key Metric Settings'!C6)","v":"OPERATING PROFIT"},{"$f":"IFERROR(INDEX('Financial Data Input'!$B$6:$I$20,$A9,C$6),NA())","v":68857.69054342684},{"$f":"IFERROR(INDEX('Financial Data Input'!$B$6:$I$20,$A9,D$6),NA())","v":75643.2552108195},{"$f":"IFERROR(INDEX('Financial Data Input'!$B$6:$I$20,$A9,E$6),NA())","v":76755.26152886634},{"$f":"IFERROR(INDEX('Financial Data Input'!$B$6:$I$20,$A9,F$6),NA())","v":77317.8364852092},{"$f":"IFERROR(INDEX('Financial Data Input'!$B$6:$I$20,$A9,G$6),NA())","v":73425.9959797783},{"$f":"IFERROR(G9/F9-1,\"\")","v":{"v":-0.050335610544087306,"d":"-5%"}}]
[{"$f":"MATCH(B10,'Financial Data Input'!$B$6:$B$20,0)","v":5},{"$f":"IF('Key Metric Settings'!C7=\"\",\"\",'Key Metric Settings'!C7)","v":"INTEREST"},{"$f":"IFERROR(INDEX('Financial Data Input'!$B$6:$I$20,$A10,C$6),NA())","v":2893.112497282722},{"$f":"IFERROR(INDEX('Financial Data Input'!$B$6:$I$20,$A10,D$6),NA())","v":3136.1282291672965},{"$f":"IFERROR(INDEX('Financial Data Input'!$B$6:$I$20,$A10,E$6),NA())","v":3148.5301372295735},{"$f":"IFERROR(INDEX('Financial Data Input'!$B$6:$I$20,$A10,F$6),NA())","v":3338.3074300596945},{"$f":"IFERROR(INDEX('Financial Data Input'!$B$6:$I$20,$A10,G$6),NA())","v":3789.4733908108906},{"v":0.1351481162845234,"d":"14%"}]
[{"$f":"MATCH(B11,'Financial Data Input'!$B$6:$B$20,0)","v":4},{"$f":"IF('Key Metric Settings'!C8=\"\",\"\",'Key Metric Settings'!C8)","v":"DEPRECIATION"},{"$f":"IFERROR(INDEX('Financial Data Input'!$B$6:$I$20,$A11,C$6),NA())","v":4656.924613542916},{"$f":"IFERROR(INDEX('Financial Data Input'!$B$6:$I$20,$A11,D$6),NA())","v":4974.2116368359975},{"$f":"IFERROR(INDEX('Financial Data Input'!$B$6:$I$20,$A11,E$6),NA())","v":5024.111162299069},{"$f":"IFERROR(INDEX('Financial Data Input'!$B$6:$I$20,$A11,F$6),NA())","v":5068.423486068671},{"$f":"IFERROR(INDEX('Financial Data Input'!$B$6:$I$20,$A11,G$6),NA())","v":5546.885548091393},{"v":0.0944005691982619,"d":"9%"}]
[{"$f":"MATCH(B12,'Financial Data Input'!$B$6:$B$20,0)","v":6},{"$f":"IF('Key Metric Settings'!C9=\"\",\"\",'Key Metric Settings'!C9)","v":"NET PROFIT"},{"$f":"IFERROR(INDEX('Financial Data Input'!$B$6:$I$20,$A12,C$6),NA())","v":55860.8161858705},{"$f":"IFERROR(INDEX('Financial Data Input'!$B$6:$I$20,$A12,D$6),NA())","v":59747.95829384081},{"$f":"IFERROR(INDEX('Financial Data Input'!$B$6:$I$20,$A12,E$6),NA())","v":61483.593541849004},{"$f":"IFERROR(INDEX('Financial Data Input'!$B$6:$I$20,$A12,F$6),NA())","v":66272.10183954106},{"$f":"IFERROR(INDEX('Financial Data Input'!$B$6:$I$20,$A12,G$6),NA())","v":67474.85858092597},{"v":0.018148764080201163,"d":"2%"}]
[]
[null,"All Metrics (works up to 25 metrics)"]
[{"$f":"ROWS($B$15:B15)","v":1},{"$f":"IF('Financial Data Input'!B6=0,\"\",'Financial Data Input'!B6)","v":"REVENUES"},{"$f":"IF(B15=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A15,C$6),NA()))","v":142728.38430660142},{"$f":"IF(B15=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A15,D$6),NA()))","v":150687.465060636},{"$f":"IF(B15=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A15,E$6),NA()))","v":165044.56114573785},{"$f":"IF(B15=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A15,F$6),NA()))","v":180026.63908155632},{"$f":"IF(B15=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A15,G$6),NA()))","v":180583.88479646543}]
[{"$f":"ROWS($B$15:B16)","v":2},{"$f":"IF('Financial Data Input'!B7=0,\"\",'Financial Data Input'!B7)","v":"OPERATING EXPENSES"},{"$f":"IF(B16=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A16,C$6),NA()))","v":75924.86559784267},{"$f":"IF(B16=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A16,D$6),NA()))","v":78901.27843996584},{"$f":"IF(B16=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A16,E$6),NA()))","v":81674.37146726911},{"$f":"IF(B16=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A16,F$6),NA()))","v":80883.3309479549},{"$f":"IF(B16=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A16,G$6),NA()))","v":94419.45802509892}]
[{"$f":"ROWS($B$15:B17)","v":3},{"$f":"IF('Financial Data Input'!B8=0,\"\",'Financial Data Input'!B8)","v":"OPERATING PROFIT"},{"$f":"IF(B17=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A17,C$6),NA()))","v":68857.69054342684},{"$f":"IF(B17=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A17,D$6),NA()))","v":75643.2552108195},{"$f":"IF(B17=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A17,E$6),NA()))","v":76755.26152886634},{"$f":"IF(B17=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A17,F$6),NA()))","v":77317.8364852092},{"$f":"IF(B17=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A17,G$6),NA()))","v":73425.9959797783}]
[{"$f":"ROWS($B$15:B18)","v":4},{"$f":"IF('Financial Data Input'!B9=0,\"\",'Financial Data Input'!B9)","v":"DEPRECIATION"},{"$f":"IF(B18=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A18,C$6),NA()))","v":4656.924613542916},{"$f":"IF(B18=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A18,D$6),NA()))","v":4974.2116368359975},{"$f":"IF(B18=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A18,E$6),NA()))","v":5024.111162299069},{"$f":"IF(B18=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A18,F$6),NA()))","v":5068.423486068671},{"$f":"IF(B18=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A18,G$6),NA()))","v":5546.885548091393}]
[{"$f":"ROWS($B$15:B19)","v":5},{"$f":"IF('Financial Data Input'!B10=0,\"\",'Financial Data Input'!B10)","v":"INTEREST"},{"$f":"IF(B19=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A19,C$6),NA()))","v":2893.112497282722},{"$f":"IF(B19=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A19,D$6),NA()))","v":3136.1282291672965},{"$f":"IF(B19=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A19,E$6),NA()))","v":3148.5301372295735},{"$f":"IF(B19=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A19,F$6),NA()))","v":3338.3074300596945},{"$f":"IF(B19=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A19,G$6),NA()))","v":3789.4733908108906}]
[{"$f":"ROWS($B$15:B20)","v":6},{"$f":"IF('Financial Data Input'!B11=0,\"\",'Financial Data Input'!B11)","v":"NET PROFIT"},{"$f":"IF(B20=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A20,C$6),NA()))","v":55860.8161858705},{"$f":"IF(B20=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A20,D$6),NA()))","v":59747.95829384081},{"$f":"IF(B20=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A20,E$6),NA()))","v":61483.593541849004},{"$f":"IF(B20=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A20,F$6),NA()))","v":66272.10183954106},{"$f":"IF(B20=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A20,G$6),NA()))","v":67474.85858092597}]
[{"$f":"ROWS($B$15:B21)","v":7},{"$f":"IF('Financial Data Input'!B12=0,\"\",'Financial Data Input'!B12)","v":"TAX"},{"$f":"IF(B21=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A21,C$6),NA()))","v":25576.741264835484},{"$f":"IF(B21=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A21,D$6),NA()))","v":27498.86192261478},{"$f":"IF(B21=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A21,E$6),NA()))","v":28335.67577515124},{"$f":"IF(B21=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A21,F$6),NA()))","v":29424.531926280673},{"$f":"IF(B21=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A21,G$6),NA()))","v":31408.25563943774}]
[{"$f":"ROWS($B$15:B22)","v":8},{"$f":"IF('Financial Data Input'!B13=0,\"\",'Financial Data Input'!B13)","v":"PROFIT AFTER TAX"},{"$f":"IF(B22=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A22,C$6),NA()))","v":38418.532268713716},{"$f":"IF(B22=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A22,D$6),NA()))","v":39895.053057716366},{"$f":"IF(B22=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A22,E$6),NA()))","v":40607.73962966755},{"$f":"IF(B22=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A22,F$6),NA()))","v":42438.204209783944},{"$f":"IF(B22=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A22,G$6),NA()))","v":50247.68426868668}]
[{"$f":"ROWS($B$15:B23)","v":9},{"$f":"IF('Financial Data Input'!B14=0,\"\",'Financial Data Input'!B14)","v":"METRIC 1"},{"$f":"IF(B23=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A23,C$6),NA()))","v":13.784416456043646},{"$f":"IF(B23=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A23,D$6),NA()))","v":14.292893230717713},{"$f":"IF(B23=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A23,E$6),NA()))","v":15.57801620970704},{"$f":"IF(B23=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A23,F$6),NA()))","v":16.78665780324392},{"$f":"IF(B23=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A23,G$6),NA()))","v":19.964456213989912}]
[{"$f":"ROWS($B$15:B24)","v":10},{"$f":"IF('Financial Data Input'!B15=0,\"\",'Financial Data Input'!B15)","v":"METRIC 2"},{"$f":"IF(B24=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A24,C$6),NA()))","v":19.220660937603707},{"$f":"IF(B24=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A24,D$6),NA()))","v":20.172419365352766},{"$f":"IF(B24=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A24,E$6),NA()))","v":20.48417465833084},{"$f":"IF(B24=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A24,F$6),NA()))","v":21.84410933880771},{"$f":"IF(B24=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A24,G$6),NA()))","v":26.0197642065095}]
[{"$f":"ROWS($B$15:B25)","v":11},{"$f":"IF('Financial Data Input'!B16=0,\"\",'Financial Data Input'!B16)","v":"METRIC 3"},{"$f":"IF(B25=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A25,C$6),NA()))","v":21.87460134031757},{"$f":"IF(B25=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A25,D$6),NA()))","v":23.19302954817104},{"$f":"IF(B25=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A25,E$6),NA()))","v":24.676402313128037},{"$f":"IF(B25=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A25,F$6),NA()))","v":26.395902516700666},{"$f":"IF(B25=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A25,G$6),NA()))","v":31.086507537181795}]
[{"$f":"ROWS($B$15:B26)","v":12},{"$f":"IF('Financial Data Input'!B17=0,\"\",'Financial Data Input'!B17)","v":"METRIC 4"},{"$f":"IF(B26=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A26,C$6),NA()))","v":12.59253323064809},{"$f":"IF(B26=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A26,D$6),NA()))","v":13.705566638410549},{"$f":"IF(B26=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A26,E$6),NA()))","v":13.762117100061495},{"$f":"IF(B26=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A26,F$6),NA()))","v":14.590312329610818},{"$f":"IF(B26=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A26,G$6),NA()))","v":14.924556664330456}]
[{"$f":"ROWS($B$15:B27)","v":13},{"$f":"IF('Financial Data Input'!B18=0,\"\",'Financial Data Input'!B18)","v":"METRIC 5"},{"$f":"IF(B27=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A27,C$6),NA()))","v":0.8528964777490574},{"$f":"IF(B27=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A27,D$6),NA()))","v":0.8918172064689517},{"$f":"IF(B27=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A27,E$6),NA()))","v":0.9151184649381309},{"$f":"IF(B27=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A27,F$6),NA()))","v":1.0026426573298342},{"$f":"IF(B27=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A27,G$6),NA()))","v":1.0365471137530806}]
[{"$f":"ROWS($B$15:B28)","v":14},{"$f":"IF('Financial Data Input'!B19=0,\"\",'Financial Data Input'!B19)","v":"METRIC 6"},{"$f":"IF(B28=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A28,C$6),NA()))","v":0.27306339198662744},{"$f":"IF(B28=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A28,D$6),NA()))","v":0.2805922957857658},{"$f":"IF(B28=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A28,E$6),NA()))","v":0.29660907186605134},{"$f":"IF(B28=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A28,F$6),NA()))","v":0.3086432107399634},{"$f":"IF(B28=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A28,G$6),NA()))","v":0.34477763556381397}]
[{"$f":"ROWS($B$15:B29)","v":15},{"$f":"IF('Financial Data Input'!B20=0,\"\",'Financial Data Input'!B20)","v":""},{"$f":"IF(B29=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A29,C$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B29=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A29,D$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B29=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A29,E$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B29=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A29,F$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B29=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A29,G$6),NA()))","v":{"$error":"#N/A"}}]
[{"$f":"ROWS($B$15:B30)","v":16},{"$f":"IF('Financial Data Input'!B21=0,\"\",'Financial Data Input'!B21)","v":""},{"$f":"IF(B30=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A30,C$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B30=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A30,D$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B30=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A30,E$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B30=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A30,F$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B30=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A30,G$6),NA()))","v":{"$error":"#N/A"}}]
[{"$f":"ROWS($B$15:B31)","v":17},{"$f":"IF('Financial Data Input'!B22=0,\"\",'Financial Data Input'!B22)","v":""},{"$f":"IF(B31=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A31,C$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B31=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A31,D$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B31=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A31,E$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B31=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A31,F$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B31=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A31,G$6),NA()))","v":{"$error":"#N/A"}}]
[{"$f":"ROWS($B$15:B32)","v":18},{"$f":"IF('Financial Data Input'!B23=0,\"\",'Financial Data Input'!B23)","v":""},{"$f":"IF(B32=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A32,C$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B32=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A32,D$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B32=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A32,E$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B32=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A32,F$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B32=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A32,G$6),NA()))","v":{"$error":"#N/A"}}]
[{"$f":"ROWS($B$15:B33)","v":19},{"$f":"IF('Financial Data Input'!B24=0,\"\",'Financial Data Input'!B24)","v":""},{"$f":"IF(B33=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A33,C$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B33=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A33,D$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B33=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A33,E$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B33=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A33,F$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B33=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A33,G$6),NA()))","v":{"$error":"#N/A"}}]
[{"$f":"ROWS($B$15:B34)","v":20},{"$f":"IF('Financial Data Input'!B25=0,\"\",'Financial Data Input'!B25)","v":""},{"$f":"IF(B34=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A34,C$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B34=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A34,D$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B34=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A34,E$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B34=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A34,F$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B34=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A34,G$6),NA()))","v":{"$error":"#N/A"}}]
[{"$f":"ROWS($B$15:B35)","v":21},{"$f":"IF('Financial Data Input'!B26=0,\"\",'Financial Data Input'!B26)","v":""},{"$f":"IF(B35=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A35,C$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B35=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A35,D$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B35=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A35,E$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B35=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A35,F$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B35=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A35,G$6),NA()))","v":{"$error":"#N/A"}}]
[{"$f":"ROWS($B$15:B36)","v":22},{"$f":"IF('Financial Data Input'!B27=0,\"\",'Financial Data Input'!B27)","v":""},{"$f":"IF(B36=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A36,C$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B36=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A36,D$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B36=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A36,E$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B36=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A36,F$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B36=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A36,G$6),NA()))","v":{"$error":"#N/A"}}]
[{"$f":"ROWS($B$15:B37)","v":23},{"$f":"IF('Financial Data Input'!B28=0,\"\",'Financial Data Input'!B28)","v":""},{"$f":"IF(B37=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A37,C$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B37=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A37,D$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B37=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A37,E$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B37=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A37,F$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B37=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A37,G$6),NA()))","v":{"$error":"#N/A"}}]
[{"$f":"ROWS($B$15:B38)","v":24},{"$f":"IF('Financial Data Input'!B29=0,\"\",'Financial Data Input'!B29)","v":""},{"$f":"IF(B38=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A38,C$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B38=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A38,D$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B38=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A38,E$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B38=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A38,F$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B38=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A38,G$6),NA()))","v":{"$error":"#N/A"}}]
[{"$f":"ROWS($B$15:B39)","v":25},{"$f":"IF('Financial Data Input'!B30=0,\"\",'Financial Data Input'!B30)","v":""},{"$f":"IF(B39=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A39,C$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B39=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A39,D$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B39=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A39,E$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B39=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A39,F$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B39=\"\",NA(),IFERROR(INDEX('Financial Data Input'!$B$6:$I$30,$A39,G$6),NA()))","v":{"$error":"#N/A"}}]