{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Step 1","Step 2"],"not_rendered":{"images":1,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Step 1","index":0,"n_rows":18,"n_cols":8,"rows_kept":18,"merged":[[7,3,7,9],[9,0,9,3],[9,4,9,9],[10,0,10,3],[11,0,11,3],[11,5,11,9],[12,0,12,3],[14,0,14,3],[14,6,14,7],[15,0,15,3],[17,0,17,9]]}
[]
[]
[]
[]
[{"$nulls":3},"Emergency Loan Fund"]
[{"$nulls":3},"Cash Flow Projection"]
[]
[{"$nulls":3},"Please provide the following information, and it will be automatically entered into the cashflow projection on the next sheet."]
[]
["What is the name of your organization?",{"$nulls":3},"type your organization name here…"]
["How much are you applying for?",{"$nulls":3},0,{"$f":"IF(E11>50000,\"The maximum amount you can request is $50,000\",\"\")","v":""}]
["What is the date you expect to get this loan?",{"$nulls":3},"2012-10-18","[mm/dd/yy]"]
["What is the date you expect to pay it back?",{"$nulls":4},"[mm/dd/yy]",null,{"$f":"IF(E13-E12>182.5,\"Please enter a date within six months of receiving this loan.\",\"\")","v":""}]
[]
["What is the organization's beginning balance on",{"$nulls":3},{"$f":"IF(E12=\"\",\"\",E12-60)","v":"2012-08-19"},"?",0]
["Please project your cash flow for three months\nbeyond  the proposed repayment date:",{"$nulls":3},{"$f":"IF(E13=\"\",\"\",E13+90)","v":""}]
[]
["Please click the \"Step Two\" tab below when finished."]

{"sheet":"Step 2","index":1,"n_rows":31,"n_cols":14,"rows_kept":31,"merged":[[32,0,32,12]]}
[{"$f":"'Step 1'!E10","v":"type your organization name here…"},{"$nulls":12},"Cashflow Projection"]
[null,{"$f":"'Step 1'!E12-60","v":"2012-08-19"},{"$f":"DATE(YEAR(B2),MONTH(B2)+1,DAY(B2))","v":"2012-09-19"},{"$f":"DATE(YEAR(C2),MONTH(C2)+1,DAY(C2))","v":"2012-10-19"},"2012-11-19","2012-12-19","2013-01-19","2013-02-19","2013-03-19","2013-04-19","2013-05-19","2013-06-19","2013-07-19","Notes"]
["CASH IN"]
["1.  Federal Government Contracts/Grants",0,0,0,0,0,0,0,0,0,0,0,0]
["2. State Government Contracts/Grants",0,0,0,0,0,0,0,0,0,0,0,0]
["3.  County Contracts/Grants",null,0,0,0,0,0,0,0,0,0,0,0]
["4.  Other Government Contracts",0,0,0,0,0,0,0,0,0,0,0,0]
["5.  Foundation/Corporate Contributions",0,0,0,0,0,0,0,0,0,0,0,0]
["6.  Individual Donations",0,0,0,0,0,0,0,0,0,0,0,0]
["7.  Loans",0,0,{"$f":"'Step 1'!E11","v":0},0,0,0,0,0,0,0,0,0]
["8. Ticket Sales/Tuition"]
["9.  Other Earned Income",0,0,0,0,0,0,0,0,0,0,0,0]
["10. Other/Misc",0,0,0,0,0,0,0,0,0,0,0,0]
["Subtotal",{"$f":"SUM(B4:B13)","v":0},0,0,0,0,0,0,0,0,0,0,0]
["CASH OUT"]
["1.  Salaries",null,0,0,0,0,0,0,0,0,0,0,0]
["2.  Payroll Taxes and Fringe Benefits",0,0,0,0,0,0,0,0,0,0,0,0]
["3.  Rent ",0,0,0,0,0,0,0,0,0,0,0,0]
["4.  Supplies & Instructional Materials",0,0,0,0,0,0,0,0,0,0,0,0]
["5.  Telephone",0,0,0,0,0,0,0,0,0,0,0,0]
["6.  Consultant & Contract Services",null,0,0,0,0,0,0,0,0,0,0,0]
["7.  Insurance",0,0,0,0,0,0,0,0,0,0,0,0]
["8.  Client Services (Food, housing)",0,0,0,0,0,0,0,0,0,0,0,0]
["9.  Other Operating Expenses",0,0,0,0,0,0,0,0,0,0,0,0]
["10. Loan Repayments",0,0,0,0,0,0,0,0,0,0,0,0]
["TOTAL CASH OUT:",{"$f":"SUM(B16:B25)","v":0},0,0,0,0,0,0,0,0,0,0,0]
["SUMMARY"]
["A. BEGINNING BALANCE:",{"$f":"'Step 1'!G15","v":0},{"$f":"SUM(B31)","v":0},0,0,0,0,0,0,0,0,0,0]
["B. CASH IN:",{"$f":"SUM(B14)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[" C. CASH OUT:",{"$f":"B26","v":0},0,0,0,0,0,0,0,0,0,0,0]
["D. BALANCE FORWARD:",{"$f":"SUM(B28,B29-B30)","v":0},0,0,0,0,0,0,0,0,0,0,0]