{"text_format":"3","workbook":"xlsx","n_sheets":8,"sheets":["Draw Schedule","Draw 1","Draw 2","Draw 3","Draw 4","Draw 5","Draw 6","Draw 7"],"not_rendered":{"defined_names":11},"read":"whole","date_system":"1900"}

{"sheet":"Draw Schedule","index":0,"n_rows":60,"n_cols":8,"rows_kept":60,"merged":[[1,1,1,7],[3,1,3,7],[4,1,4,2],[4,3,4,4],[5,1,5,2],[5,3,5,4],[5,9,5,10],[5,11,5,12],[6,1,6,2],[6,9,6,10],[6,11,6,12],[8,5,8,7],[8,11,8,12],[8,14,8,15],[10,5,10,7],[11,5,11,7],[12,5,12,7],[13,5,13,7],[14,5,14,7],[15,5,15,7],[16,5,16,7],[17,5,17,7],[18,5,18,7],[19,5,19,7],[20,5,20,7],[21,5,21,7],[22,5,22,7],[23,5,23,7],[24,5,24,7],[25,5,25,7],[26,5,26,7],[27,5,27,7],[28,5,28,7],[30,5,30,7],[31,5,31,7],[32,5,32,7],[33,5,33,7],[34,5,34,7],[35,5,35,7],[36,5,36,7],[37,5,37,7],[38,5,38,7],[39,5,39,7],[40,5,40,7],[41,5,41,7],[42,5,42,7],[43,5,43,7],[44,5,44,7],[45,5,45,7],[46,5,46,7],[47,5,47,7],[48,5,48,7],[49,5,49,7],[50,5,50,7],[51,5,51,7],[52,5,52,7],[53,5,53,7],[54,5,54,7],[55,5,55,7],[56,5,56,7],[57,5,57,7],[58,5,58,7],[59,5,59,7]]}
[]
[null,"EDIT ONLY THE YELLOW FIELDS"]
[]
[null,"Novak Financial Draw Schedule"]
[null,"Property Address:",{"$nulls":4},"Advance:",{"v":15000,"d":"$15,000.00"}]
[null,"Borrower Name:",{"$nulls":4},"Rehab Total:",{"$f":"E60","v":{"v":0,"d":"$0.00"}}]
[null,"Borrower Contact Info:",{"$nulls":4},"Funds Taken:",{"$f":"SUMIF(B11:B59, \"Done\", E11:E59)","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":6},"Funds Remaining:",{"$f":"SUM(H6-H7)","v":{"v":0,"d":"$0.00"}}]
[null,"STATUS"," ITEM","DRAW #","AMOUNT","DESCRIPTION"]
[null,null,"Exterior"]
[null,null,"Demolition / Tear Out"]
[null,null,"Masonry/Brickwork"]
[null,null,"New Roof / Roof Repair"]
[null,null,"Doors - Front, Back, Garage"]
[null,null,"Windows"]
[null,null,"Siding"]
[null,null,"Flashing"]
[null,null,"Exterior - Lighting"]
[null,null,"Exterior - Painting"]
[null,null,"Patio / Decking"]
[null,null,"Fencing / Gates"]
[null,null,"Parking"]
[null,null,"Landscaping"]
[]
[]
[]
[]
[]
[]
[null,null,"Interior"]
[null,null,"Demolition / Tear Out"]
[null,null,"Rough - Plumbing"]
[null,null,"Rough - Electrical"]
[null,null,"Rough - HVAC"]
[null,null,"Framing"]
[null,null,"Insulation"]
[null,null,"Drywall and Finish"]
[null,null,"Doors (BDRM, BR, Closet)"]
[null,null,"Painting"]
[null,null,"Trim"]
[null,null,"Lighting"]
[null,null,"Kitchen Cabinets & Countertops"]
[null,null,"Kitchen Appliances"]
[null,null,"Bathroom Vanities / Fixtures"]
[null,null,"Carpet"]
[null,null,"Tile / Tile Work"]
[null,null,"Other Flooring"]
[null,null,"Finish - Plumbing"]
[null,null,"Finish - Electrical"]
[null,null,"Finish - HVAC"]
[null,null,"Clean-up"]
[null,null,"Staging"]
{"$rows_empty":7}
[null,null,"TOTAL:",null,{"$f":"SUM(E10:E59)","v":{"v":0,"d":"$0.00"}}]

{"sheet":"Draw 1","index":1,"n_rows":22,"n_cols":5,"rows_kept":22,"merged":[[21,1,21,2]]}
[]
[1,{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"QUERY(headers)\"),\" ITEM\")","v":" ITEM"},{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"\"\"COMPUTED_VALUE\"\"\"),\"DRAW #\")","v":"DRAW #"},"AMOUNT",{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"\"\"COMPUTED_VALUE\"\"\"),\" DESCRIPTION / COMMENTS\")","v":" DESCRIPTION / COMMENTS"}]
[null,{"$f":"_xlfn._xlws.FILTER(data,dep=A2)","v":{"$error":"#VALUE!"}}]
{"$rows_empty":18}
[null,"DRAW TOTAL: ",null,{"$f":"SUM(D3:D18)","v":{"v":0,"d":"$0.00"}}]

{"sheet":"Draw 2","index":2,"n_rows":22,"n_cols":5,"rows_kept":22,"merged":[[21,1,21,2]]}
[]
[2,{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"QUERY(headers)\"),\" ITEM\")","v":" ITEM"},{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"\"\"COMPUTED_VALUE\"\"\"),\"DRAW #\")","v":"DRAW #"},"AMOUNT",{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"\"\"COMPUTED_VALUE\"\"\"),\" DESCRIPTION / COMMENTS\")","v":" DESCRIPTION / COMMENTS"}]
[null,{"$f":"_xlfn._xlws.FILTER(data,dep=A2)","v":{"$error":"#VALUE!"}}]
{"$rows_empty":18}
[null,"DRAW TOTAL: ",null,{"$f":"SUM(D3:D18)","v":{"v":0,"d":"$0.00"}}]

{"sheet":"Draw 3","index":3,"n_rows":22,"n_cols":5,"rows_kept":22,"merged":[[21,1,21,2]]}
[]
[3,{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"QUERY(headers)\"),\" ITEM\")","v":" ITEM"},{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"\"\"COMPUTED_VALUE\"\"\"),\"DRAW #\")","v":"DRAW #"},"AMOUNT",{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"\"\"COMPUTED_VALUE\"\"\"),\" DESCRIPTION / COMMENTS\")","v":" DESCRIPTION / COMMENTS"}]
[null,{"$f":"_xlfn._xlws.FILTER(data,dep=A2)","v":{"$error":"#VALUE!"}}]
{"$rows_empty":18}
[null,"DRAW TOTAL: ",null,{"$f":"SUM(D3:D18)","v":{"v":0,"d":"$0.00"}}]

{"sheet":"Draw 4","index":4,"n_rows":22,"n_cols":5,"rows_kept":22,"merged":[[21,1,21,2]]}
[]
[4,{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"QUERY(headers)\"),\" ITEM\")","v":" ITEM"},{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"\"\"COMPUTED_VALUE\"\"\"),\"DRAW #\")","v":"DRAW #"},"AMOUNT",{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"\"\"COMPUTED_VALUE\"\"\"),\" DESCRIPTION / COMMENTS\")","v":" DESCRIPTION / COMMENTS"}]
[null,{"$f":"_xlfn._xlws.FILTER(data,dep=A2)","v":{"$error":"#VALUE!"}}]
{"$rows_empty":18}
[null,"DRAW TOTAL: ",null,{"$f":"SUM(D3:D18)","v":{"v":0,"d":"$0.00"}}]

{"sheet":"Draw 5","index":5,"n_rows":22,"n_cols":5,"rows_kept":22,"merged":[[21,1,21,2]]}
[]
[5,{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"QUERY(headers)\"),\" ITEM\")","v":" ITEM"},{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"\"\"COMPUTED_VALUE\"\"\"),\"DRAW #\")","v":"DRAW #"},"AMOUNT",{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"\"\"COMPUTED_VALUE\"\"\"),\" DESCRIPTION / COMMENTS\")","v":" DESCRIPTION / COMMENTS"}]
[null,{"$f":"_xlfn._xlws.FILTER(data,dep=A2)","v":{"$error":"#VALUE!"}}]
{"$rows_empty":18}
[null,"DRAW TOTAL: ",null,{"$f":"SUM(D3:D18)","v":{"v":0,"d":"$0.00"}}]

{"sheet":"Draw 6","index":6,"n_rows":22,"n_cols":5,"rows_kept":22,"merged":[[21,1,21,2]]}
[]
[6,{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"QUERY(headers)\"),\" ITEM\")","v":" ITEM"},{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"\"\"COMPUTED_VALUE\"\"\"),\"DRAW #\")","v":"DRAW #"},"AMOUNT",{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"\"\"COMPUTED_VALUE\"\"\"),\" DESCRIPTION / COMMENTS\")","v":" DESCRIPTION / COMMENTS"}]
[null,{"$f":"_xlfn._xlws.FILTER(data,dep=A2)","v":{"$error":"#VALUE!"}}]
{"$rows_empty":18}
[null,"DRAW TOTAL: ",null,{"$f":"SUM(D3:D18)","v":{"v":0,"d":"$0.00"}}]

{"sheet":"Draw 7","index":7,"n_rows":22,"n_cols":5,"rows_kept":22,"merged":[[21,1,21,2]]}
[]
[7,{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"QUERY(headers)\"),\" ITEM\")","v":" ITEM"},{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"\"\"COMPUTED_VALUE\"\"\"),\"DRAW #\")","v":"DRAW #"},"AMOUNT",{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"\"\"COMPUTED_VALUE\"\"\"),\" DESCRIPTION / COMMENTS\")","v":" DESCRIPTION / COMMENTS"}]
[null,{"$f":"_xlfn._xlws.FILTER(data,dep=A2)","v":{"$error":"#VALUE!"}}]
{"$rows_empty":18}
[null,"DRAW TOTAL: ",null,{"$f":"SUM(D3:D18)","v":{"v":0,"d":"$0.00"}}]