{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Macro Example"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":6,"defined_names":1677,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Macro Example","index":0,"n_rows":27,"n_cols":9,"rows_kept":27,"cut":false,"hidden":false,"merged":[[15,1,15,8],[2,1,2,6],[4,1,4,6],[9,3,9,4],[13,1,13,6],[11,1,11,6]]}
[]
[]
[null,"Real Estate Financial Modeling"]
[]
[null,"Sample Macro"]
[]
[]
[]
[]
[]
[]
[null,"Input Cells are in Bold Blue Type"]
[]
[null,"Calculations are set to \"Automatic Except for Data Tables\""]
[]
[null,"EXAMPLE"]
[null,null,null,null,null,0.2,0.3,0.3,0.2]
[null,"Total Hard Costs",null,null,5000000,{"$f":"$E$18*F17","v":1000000},{"$f":"$E$18*G17","v":1500000},{"$f":"$E$18*H17","v":1500000},{"$f":"$E$18*I17","v":1000000}]
[null,"Total Soft Costs",null,null,2000000,{"$f":"F17*$E$19","v":400000},{"$f":"G17*$E$19","v":600000},600000,400000]
[null,"Total Development Costs",null,null,{"$f":"SUM(E18:E19)","v":7000000},{"$f":"SUM(F18:F19)","v":1400000},{"$f":"SUM(G18:G19)","v":2100000},2100000,1400000]
[]
[null,"Total Equity",null,null,5000000]
[null,"Total Debt ",null,null,4000000]
[null,"Total Sources of Funds ",null,null,{"$f":"SUM(E22:E23)","v":9000000}]
[]
[null,null,null,null,"CHECK "]
[null,null,null,null,{"$f":"E20-E24","v":-2000000}]