{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Application","Addendum","Sublet Agreement","Payment Schedule","Tenants","Execution","Lease Upload","Charge Upload","Tenant Information"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":12,"comments":3,"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":"Application","index":0,"n_rows":36,"n_cols":11,"rows_kept":36,"cut":false,"hidden":false,"merged":[[1,7,1,9],[3,7,3,9],[35,0,37,10],[20,9,20,10]]}
["Instructions",null,null,null,null,null,"Property Information"]
["1.) For each tenant, fill out all of the information highlighted in yellow",null,null,null,null,null,"Address:",null,null,null,"<-- Drop down menu"]
["2.) Fill out property information highlighted in yellow (use the drop down menu)"]
["3.) E-mail this file (Microsoft Excel file only) to justin@jandjip.com ",null,null,null,null,null,"Unit #:",null,null,null,"<-- Drop down menu"]
[]
["Floor # 1 / Tenant # 1",null,null,"Floor # 1 / Tenant # 2",null,null,"Floor # 1 / Tenant # 3",null,null,"Floor # 1 / Tenant # 4"]
["First Name:",null,null,"First Name:",null,null,"First Name:",null,null,"First Name:"]
["Last Name:",null,null,"Last Name:",null,null,"Last Name:",null,null,"Last Name:"]
["Date of Birth:",null,null,"Date of Birth:",null,null,"Date of Birth:",null,null,"Date of Birth:"]
["Tenant Cell:",null,null,"Tenant Cell:",null,null,"Tenant Cell:",null,null,"Tenant Cell:"]
["Tenant E-mail:",null,null,"Tenant E-mail:",null,null,"Tenant E-mail:",null,null,"Tenant E-mail:"]
["Social Security:",null,null,"Social Security:",null,null,"Social Security:",null,null,"Social Security:"]
["Mailing Address:",null,null,"Mailing Address:",null,null,"Mailing Address:",null,null,"Mailing Address:"]
["City:",null,null,"City:",null,null,"City:",null,null,"City:"]
["State:",null,null,"State:",null,null,"State:",null,null,"State:"]
["Zip Code:",null,null,"Zip Code:",null,null,"Zip Code:",null,null,"Zip Code:"]
["Parent Name:",null,null,"Parent Name:",null,null,"Parent Name:",null,null,"Parent Name:"]
["Parent Cell:",null,null,"Parent Cell:",null,null,"Parent Cell:",null,null,"Parent Cell:"]
["Parent E-Mail:",null,null,"Parent E-Mail:",null,null,"Parent E-Mail:",null,null,"Parent E-Mail:"]
[]
["Floor # 2 / Tenant # 1",null,null,"Floor # 2 / Tenant # 2",null,null,"Floor # 2 / Tenant # 3",null,null,"Floor # 2 / Tenant # 4"]
["First Name:",null,null,"First Name:",null,null,"First Name:",null,null,"First Name:"]
["Last Name:",null,null,"Last Name:",null,null,"Last Name:",null,null,"Last Name:"]
["Date of Birth:",null,null,"Date of Birth:",null,null,"Date of Birth:",null,null,"Date of Birth:"]
["Tenant Cell:",null,null,"Tenant Cell:",null,null,"Tenant Cell:",null,null,"Tenant Cell:"]
["Tenant E-mail:",null,null,"Tenant E-mail:",null,null,"Tenant E-mail:",null,null,"Tenant E-mail:"]
["Social Security:",null,null,"Social Security:",null,null,"Social Security:",null,null,"Social Security:"]
["Mailing Address:",null,null,"Mailing Address:",null,null,"Mailing Address:",null,null,"Mailing Address:"]
["City:",null,null,"City:",null,null,"City:",null,null,"City:"]
["State:",null,null,"State:",null,null,"State:",null,null,"State:"]
["Zip Code:",null,null,"Zip Code:",null,null,"Zip Code:",null,null,"Zip Code:"]
["Parent Name:",null,null,"Parent Name:",null,null,"Parent Name:",null,null,"Parent Name:"]
["Parent Cell:",null,null,"Parent Cell:",null,null,"Parent Cell:",null,null,"Parent Cell:"]
["Parent E-Mail:",null,null,"Parent E-Mail:",null,null,"Parent E-Mail:",null,null,"Parent E-Mail:"]
[]
["Note - Please ensure all contact information is correct, including e-mail addresses, phone numbers and names. The Tenant's social security number must be included.  All information recieved will remain secure and protected.  Please contact Justin at (516) 672-8754 with any questions."]

{"sheet":"Addendum","index":1,"n_rows":72,"n_cols":18,"rows_kept":72,"cut":false,"hidden":true,"merged":[[5,20,13,28],[7,0,8,12],[13,0,13,2],[13,7,13,9],[0,0,0,12],[1,0,1,12],[2,0,2,12],[3,0,3,12],[4,0,5,12],[32,0,33,12],[39,0,43,12],[17,0,17,2],[17,7,17,9],[21,0,21,2],[21,7,21,9],[25,0,25,2],[25,7,25,9]]}
["J&J Investment Properties LLC",null,null,null,null,null,null,null,null,null,null,null,null,null,"Inputs"]
["600 Franklin Avenue, PO Box 293, Garden City, NY 11530",null,null,null,null,null,null,null,null,null,null,null,null,null,"Monthly Rent Per Person:",null,null,{"$f":"'Payment Schedule'!H2","v":650}]
["E-mail: jandjip@jandjip.com",null,null,null,null,null,null,null,null,null,null,null,null,null,"Security Deposit Per Person",null,null,{"$f":"'Payment Schedule'!H3","v":650}]
["Web: www.jandjip.com ",null,null,null,null,null,null,null,null,null,null,null,null,null,"Tenants Per Unit:",null,null,{"$f":"'Payment Schedule'!H4","v":8}]
["Sublet Agreement",null,null,null,null,null,null,null,null,null,null,null,null,null,"First Payment Date",null,null,{"$f":"'Payment Schedule'!H5","v":"2021-06-01"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cash payment plan?",null,null,{"$f":"'Payment Schedule'!H6","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lease Year",null,null,{"$f":"'Payment Schedule'!H7","v":2022}]
[{"$f":"\"This document, known as the \"\"Sublet Agreement\"\", is made and effective this day, \"&TEXT(TODAY(),\"M/D/YY\")&\", by and between Landlord, Tenant(s) and Subtenant as described below:\"","v":"This document, known as the \"Sublet Agreement\", is made and effective this day, 1/25/21, by and between Landlord, Tenant(s) and Subtenant as described below:"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Multi-Floor Lease?",null,null,{"$f":"'Payment Schedule'!H8","v":"Yes"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Is this a Lease re-sign?",null,null,{"$f":"'Payment Schedule'!H9","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Security Deposit Per Unit:",null,null,{"$f":"'Payment Schedule'!H10","v":5200}]
[null,null,"Landlord / Lessor:","J&J Investment Properties LLC",null,null,null,null,null,null,null,null,null,null,"Monthly Rent Per Unit:",null,null,{"$f":"'Payment Schedule'!H11","v":5200}]
[null,null,"Property Owner:",{"$f":"IF(OR($D$32=\"238 Quail Street, Albany, NY 12203\",$D$32=\"484 Hamilton Street, Albany, NY 12203\"),\"Jason Schneider\",\"J&J Investment Properties LLC and/or John Corallo and/or Justin Schmiemann\")","v":"J&J Investment Properties LLC and/or John Corallo and/or Justin Schmiemann"},null,null,null,null,null,null,null,null,null,null,"Water Per Unit:",null,null,{"$f":"'Payment Schedule'!H12","v":800}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Lease Payments",null,null,{"$f":"'Payment Schedule'!H13","v":63200}]
["Tenant #1:",null,null,{"$f":"Application!#REF!","v":{"$error":"#REF!"}},null,null,null,"Tenant #2:","Tenant #2:",null,{"$f":"Application!#REF!","v":{"$error":"#REF!"}},null,null,null,"Lease Name:",null,null,{"$f":"R7&\" - \"&LEFT(D32,3)&\" - \"&VLOOKUP(Application!$H$4,'Tenant Information'!$B$52:$C$55,2,FALSE)&\"-\"&\"Addendum\"","v":{"$error":"#N/A"}}]
[null,null,"Mailing Address:",{"$f":"Application!B13","v":0},null,null,null,null,null,"Mailing Address:",{"$f":"Application!E13","v":0},null,null,null,"Effective Date:",null,null,{"$f":"'Payment Schedule'!H15","v":"2021-06-01"}]
[null,null,null,{"$f":"Application!B14&\", \"&Application!B15&\" \"&Application!B16","v":",  "},null,null,null,null,null,null,{"$f":"Application!E14&\", \"&Application!E15&\" \"&Application!E16","v":",  "}]
[]
["Tenant #3:",null,null,{"$f":"Application!#REF!","v":{"$error":"#REF!"}},null,null,null,"Tenant #4:","Tenant #4:",null,{"$f":"Application!#REF!","v":{"$error":"#REF!"}}]
[null,null,"Mailing Address:",{"$f":"Application!H13","v":0},null,null,null,null,null,"Mailing Address:",{"$f":"Application!K13","v":0}]
[null,null,null,{"$f":"Application!H14&\", \"&Application!H15&\" \"&Application!H16","v":",  "},null,null,null,null,null,null,{"$f":"Application!K14&\", \"&Application!K15&\" \"&Application!K16","v":",  "}]
[]
["Tenant #5:",null,null,{"$f":"Application!#REF!","v":{"$error":"#REF!"}},null,null,null,"Tenant #6:","Tenant #6:",null,{"$f":"Application!#REF!","v":{"$error":"#REF!"}}]
[null,null,"Mailing Address:",{"$f":"Application!B28","v":0},null,null,null,null,null,"Mailing Address:",{"$f":"Application!E28","v":0}]
[null,null,null,{"$f":"Application!B29&\", \"&Application!B30&\" \"&Application!B31","v":",  "},null,null,null,null,null,null,{"$f":"Application!E29&\", \"&Application!E30&\" \"&Application!E31","v":",  "}]
[]
["Tenant #7:",null,null,{"$f":"Application!#REF!","v":{"$error":"#REF!"}},null,null,null,"Tenant #8:","Tenant #8:",null,{"$f":"Application!#REF!","v":{"$error":"#REF!"}}]
[null,null,"Mailing Address:",{"$f":"Application!H28","v":0},null,null,null,null,null,"Mailing Address:",{"$f":"Application!#REF!","v":{"$error":"#REF!"}}]
[null,null,null,{"$f":"Application!H29&\", \"&Application!H30&\" \"&Application!H31","v":",  "},null,null,null,null,null,null,{"$f":"Application!#REF!&\", \"&Application!#REF!&\" \"&Application!#REF!","v":{"$error":"#REF!"}}]
[]
[{"$f":"\"With respect to the initial \"\"Lease Agreement\"\" dated \"&TEXT($R$15,\"M/D/YYYY\")&\" for the premises located at:\"","v":"With respect to the initial \"Lease Agreement\" dated 6/1/2021 for the premises located at:"}]
[]
[null,null,"Property Address:",{"$f":"Application!H2","v":0},null,null,null,null,null,"Unit / Floor:",{"$f":"Application!H4","v":0}]
["With the Lease Term Beginning and Ending dates as described below:"]
[]
[]
["Lease Term Beginning: June 8th, 2019",null,null,null,null,null,null,"Lease Term Ending (Expiration Date): May 23rd, 2020"]
[]
["The aforementioned Lease Agreement is hereby amended as follows:"]
[]
["Tenants agree to monthly rent in the amount of $1,350/month. Landlord shall install a 65\" HD Smart TV in the Unit in consideration for the rent increase."]
[]
[]
[]
[]
[]
["Tenant and Landlord hereby agree to the aforementioned amendments to the Lease Agreement."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Yes"]
[null,null,null,null,"No"]

{"sheet":"Sublet Agreement","index":2,"n_rows":76,"n_cols":18,"rows_kept":76,"cut":false,"hidden":true,"merged":[[5,20,13,28],[7,0,8,12],[13,0,13,2],[13,7,13,9],[0,0,0,12],[1,0,1,12],[2,0,2,12],[3,0,3,12],[4,0,5,12],[43,0,47,12],[36,0,37,12],[17,0,17,2],[17,7,17,9],[21,0,21,2],[21,7,21,9],[25,0,25,2],[25,7,25,9],[29,0,29,2]]}
["J&J Investment Properties LLC",null,null,null,null,null,null,null,null,null,null,null,null,null,"Inputs"]
["600 Franklin Avenue, PO Box 293, Garden City, NY 11530",null,null,null,null,null,null,null,null,null,null,null,null,null,"Monthly Rent Per Person:",null,null,{"$f":"'Payment Schedule'!H2","v":650}]
["E-mail: jandjip@jandjip.com",null,null,null,null,null,null,null,null,null,null,null,null,null,"Security Deposit Per Person",null,null,{"$f":"'Payment Schedule'!H3","v":650}]
["Web: www.jandjip.com ",null,null,null,null,null,null,null,null,null,null,null,null,null,"Tenants Per Unit:",null,null,{"$f":"'Payment Schedule'!H4","v":8}]
["Lease Addendum",null,null,null,null,null,null,null,null,null,null,null,null,null,"First Payment Date",null,null,{"$f":"'Payment Schedule'!H5","v":"2021-06-01"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cash payment plan?",null,null,{"$f":"'Payment Schedule'!H6","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lease Year",null,null,{"$f":"'Payment Schedule'!H7","v":2022}]
[{"$f":"\"This document, known as the \"\"Lease Addendum\"\", is made and effective this day, \"&TEXT(TODAY(),\"M/D/YY\")&\", by and between Landlord and Tenant(s) as described below:\"","v":"This document, known as the \"Lease Addendum\", is made and effective this day, 1/25/21, by and between Landlord and Tenant(s) as described below:"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Multi-Floor Lease?",null,null,{"$f":"'Payment Schedule'!H8","v":"Yes"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Is this a Lease re-sign?",null,null,{"$f":"'Payment Schedule'!H9","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Security Deposit Per Unit:",null,null,{"$f":"'Payment Schedule'!H10","v":5200}]
[null,null,"Landlord / Lessor:","J&J Investment Properties LLC",null,null,null,null,null,null,null,null,null,null,"Monthly Rent Per Unit:",null,null,{"$f":"'Payment Schedule'!H11","v":5200}]
[null,null,"Property Owner:",{"$f":"IF(OR($D$36=\"238 Quail Street, Albany, NY 12203\",$D$36=\"484 Hamilton Street, Albany, NY 12203\"),\"Jason Schneider\",\"J&J Investment Properties LLC and/or John Corallo and/or Justin Schmiemann\")","v":"J&J Investment Properties LLC and/or John Corallo and/or Justin Schmiemann"},null,null,null,null,null,null,null,null,null,null,"Water Per Unit:",null,null,{"$f":"'Payment Schedule'!H12","v":800}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Lease Payments",null,null,{"$f":"'Payment Schedule'!H13","v":63200}]
["Tenant #1:",null,null,{"$f":"Application!#REF!","v":{"$error":"#REF!"}},null,null,null,"Tenant #2:","Tenant #2:",null,{"$f":"Application!#REF!","v":{"$error":"#REF!"}},null,null,null,"Lease Name:",null,null,{"$f":"R7&\" - \"&LEFT(D36,3)&\" - \"&VLOOKUP(Application!$H$4,'Tenant Information'!$B$52:$C$55,2,FALSE)&\"-\"&\"Sublet\"","v":{"$error":"#N/A"}}]
[null,null,"Mailing Address:",{"$f":"Application!B13","v":0},null,null,null,null,null,"Mailing Address:",{"$f":"Application!E13","v":0},null,null,null,"Effective Date:",null,null,{"$f":"'Payment Schedule'!H15","v":"2021-06-01"}]
[null,null,null,{"$f":"Application!B14&\", \"&Application!B15&\" \"&Application!B16","v":",  "},null,null,null,null,null,null,{"$f":"Application!E14&\", \"&Application!E15&\" \"&Application!E16","v":",  "}]
[]
["Tenant #3:",null,null,{"$f":"Application!#REF!","v":{"$error":"#REF!"}},null,null,null,"Tenant #4:","Tenant #4:",null,{"$f":"Application!#REF!","v":{"$error":"#REF!"}}]
[null,null,"Mailing Address:",{"$f":"Application!H13","v":0},null,null,null,null,null,"Mailing Address:",{"$f":"Application!K13","v":0}]
[null,null,null,{"$f":"Application!H14&\", \"&Application!H15&\" \"&Application!H16","v":",  "},null,null,null,null,null,null,{"$f":"Application!K14&\", \"&Application!K15&\" \"&Application!K16","v":",  "}]
[]
["Tenant #5:",null,null,{"$f":"Application!#REF!","v":{"$error":"#REF!"}},null,null,null,"Tenant #6:","Tenant #6:",null,{"$f":"Application!#REF!","v":{"$error":"#REF!"}}]
[null,null,"Mailing Address:",{"$f":"Application!B28","v":0},null,null,null,null,null,"Mailing Address:",{"$f":"Application!E28","v":0}]
[null,null,null,{"$f":"Application!B29&\", \"&Application!B30&\" \"&Application!B31","v":",  "},null,null,null,null,null,null,{"$f":"Application!E29&\", \"&Application!E30&\" \"&Application!E31","v":",  "}]
[]
["Tenant #7:",null,null,{"$f":"Application!#REF!","v":{"$error":"#REF!"}},null,null,null,"Tenant #8:","Tenant #8:",null,{"$f":"Application!#REF!","v":{"$error":"#REF!"}}]
[null,null,"Mailing Address:",{"$f":"Application!H28","v":0},null,null,null,null,null,"Mailing Address:",{"$f":"Application!#REF!","v":{"$error":"#REF!"}}]
[null,null,null,{"$f":"Application!H29&\", \"&Application!H30&\" \"&Application!H31","v":",  "},null,null,null,null,null,null,{"$f":"Application!#REF!&\", \"&Application!#REF!&\" \"&Application!#REF!","v":{"$error":"#REF!"}}]
[]
["Subtenant:",null,null,"Name here"]
[null,null,"Mailing Address:","Address here"]
[null,null,null,"Address here"]
[]
[{"$f":"\"With respect to the initial \"\"Lease Agreement\"\" dated \"&TEXT($R$15,\"M/D/YYYY\")&\" for the premises located at:\"","v":"With respect to the initial \"Lease Agreement\" dated 6/1/2021 for the premises located at:"}]
[]
[null,null,"Property Address:",{"$f":"Application!H2","v":0},null,null,null,null,null,"Unit / Floor:",{"$f":"Application!H4","v":0}]
["With the Lease Term Beginning and Ending dates as described below:"]
[]
[]
["Lease Term Beginning: June 8th, 2019",null,null,null,null,null,null,"Lease Term Ending (Expiration Date): May 23rd, 2020"]
[]
["The aforementioned Lease Agreement is hereby amended as follows:"]
[]
["The Subtenant hereby agrees to equally assume all obligations of the Tenants on the Lease Agreement. Under no circumstances are any of the Tenants on the Lease Agreement released from the obligations set forth under the Lease Agreement. The Subtenant shall hereby have the right to occupy the premises. If the Subtenant fails to perform any obligation under the Lease Agreement, the Tenants and Subtenant will be held jointly responsible."]
[]
[]
[]
[]
[]
["Landlord, Tenant and Subtenant hereby agree to the aforementioned amendments to the Lease Agreement."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Yes"]
[null,null,null,null,"No"]

{"sheet":"Payment Schedule","index":3,"n_rows":48,"n_cols":8,"rows_kept":48,"cut":false,"hidden":true,"merged":[]}
["Due Date","Payment Type","Amount ($)",null,"Inputs"]
["Immediately",{"$f":"IF('Payment Schedule'!H9=\"Yes\",\"June \"&'Payment Schedule'!H7-1&\" Rent\",\"Security Deposit\")","v":"Security Deposit"},{"$f":"IF('Payment Schedule'!$H$9=\"Yes\",'Payment Schedule'!H11,'Payment Schedule'!H10)","v":5200},null,"Monthly Rent Per Person:",null,null,650]
[{"$f":"'Payment Schedule'!$H$5","v":"2021-06-01"},{"$f":"IF('Payment Schedule'!$H$6=\"Yes\",\"Rent\",IF('Payment Schedule'!$H$9=\"Yes\",\"May \"&'Payment Schedule'!$H$7&\" Rent\",\"June \"&'Payment Schedule'!H7-1&\" & May \"&'Payment Schedule'!$H$7&\" Rent\"))","v":"June 2021 & May 2022 Rent"},{"$f":"IF('Payment Schedule'!$H$9=\"Yes\",IF('Payment Schedule'!$H$6=\"Yes\",'Payment Schedule'!$H$11*2,'Payment Schedule'!$H$11),IF('Payment Schedule'!$H$6=\"Yes\",'Payment Schedule'!$H$11*3,'Payment Schedule'!$H$11*2))","v":10400},null,"Security Deposit Per Person",null,null,{"$f":"H2","v":650}]
[{"$f":"'Payment Schedule'!$H$5","v":"2021-06-01"},"1x Water Payment",{"$f":"100*'Payment Schedule'!H4","v":800},null,"Tenants Per Unit:",null,null,8]
[{"$f":"DATE(YEAR(A4),MONTH(A4)+1,1)","v":"2021-07-01"},{"$f":"IF('Payment Schedule'!$H$6=\"NO\",\"Rent\",\"\")","v":"Rent"},{"$f":"IF('Payment Schedule'!$H$6=\"Yes\",\"\",'Payment Schedule'!$H$11)","v":5200},null,"First Payment Date",null,null,"2021-06-01"]
["2021-08-01",{"$f":"IF('Payment Schedule'!$H$6=\"NO\",\"Rent\",\"\")","v":"Rent"},{"$f":"IF('Payment Schedule'!$H$6=\"Yes\",\"\",'Payment Schedule'!$H$11)","v":5200},null,"Cash payment plan?",null,null,"No"]
["2021-09-01",{"$f":"IF('Payment Schedule'!$H$6=\"NO\",\"Rent\",\"Rent\")","v":"Rent"},{"$f":"IF('Payment Schedule'!$H$6=\"Yes\",'Payment Schedule'!$H$11*3,'Payment Schedule'!$H$11)","v":5200},null,"Lease Year",null,null,2022]
["2021-10-01",{"$f":"IF('Payment Schedule'!$H$6=\"NO\",\"Rent\",\"\")","v":"Rent"},{"$f":"IF('Payment Schedule'!$H$6=\"Yes\",\"\",'Payment Schedule'!$H$11)","v":5200},null,"Multi-Floor Lease?",null,null,{"$f":"IF(H4>4,\"Yes\",\"No\")","v":"Yes"}]
["2021-11-01",{"$f":"IF('Payment Schedule'!$H$6=\"NO\",\"Rent\",\"\")","v":"Rent"},{"$f":"IF('Payment Schedule'!$H$6=\"Yes\",\"\",'Payment Schedule'!$H$11)","v":5200},null,"Is this a Lease re-sign?",null,null,"No"]
["2021-12-01",{"$f":"IF('Payment Schedule'!$H$6=\"NO\",\"Rent\",\"Rent\")","v":"Rent"},{"$f":"IF('Payment Schedule'!$H$6=\"Yes\",'Payment Schedule'!$H$11*3,'Payment Schedule'!$H$11)","v":5200},null,"Security Deposit Per Unit:",null,null,{"$f":"H3*H4","v":5200}]
["2022-01-01",{"$f":"IF('Payment Schedule'!$H$6=\"NO\",\"Rent\",\"\")","v":"Rent"},{"$f":"IF('Payment Schedule'!$H$6=\"Yes\",\"\",'Payment Schedule'!$H$11)","v":5200},null,"Monthly Rent Per Unit:",null,null,{"$f":"H2*H4","v":5200}]
["2022-02-01",{"$f":"IF('Payment Schedule'!$H$6=\"NO\",\"Rent\",\"\")","v":"Rent"},{"$f":"IF('Payment Schedule'!$H$6=\"Yes\",\"\",'Payment Schedule'!$H$11)","v":5200},null,"Water Per Unit:",null,null,{"$f":"H4*100","v":800}]
["2022-03-01",{"$f":"IF('Payment Schedule'!$H$6=\"NO\",\"Rent\",\"Rent\")","v":"Rent"},{"$f":"IF('Payment Schedule'!$H$6=\"Yes\",'Payment Schedule'!$H$11*3,'Payment Schedule'!$H$11)","v":5200},null,"Total Lease Payments",null,null,{"$f":"(H11*12)+H12","v":63200}]
["2022-04-01",{"$f":"IF('Payment Schedule'!$H$6=\"NO\",\"Rent\",\"\")","v":"Rent"},{"$f":"IF('Payment Schedule'!$H$6=\"Yes\",\"\",'Payment Schedule'!$H$11)","v":5200}]
["2022-05-01",{"$f":"IF('Payment Schedule'!$H$6=\"NO\",\"Prepaid\",\"\")","v":"Prepaid"},0,null,"Date of First Payment",null,null,{"$f":"H5","v":"2021-06-01"}]
["Total Payments",null,{"$f":"SUM(C2:C15)","v":68400},null,"Lease Start Date",null,null,"June 7, 2021"]
[null,null,null,null,"Lease End Date",null,null,"May 21, 2022"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,"Page # 9"]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,{"$f":"TODAY()","v":"2021-01-25"}]

{"sheet":"Tenants","index":4,"n_rows":42,"n_cols":5,"rows_kept":42,"cut":false,"hidden":true,"merged":[]}
[{"$f":"Application!A6","v":"Floor # 1 / Tenant # 1"},null,null,{"$f":"Application!D6","v":"Floor # 1 / Tenant # 2"}]
["Tenant Name:",{"$f":"Application!B7&\" \"&Application!B8","v":" "},null,"Tenant Name:",{"$f":"Application!E7&\" \"&Application!E8","v":" "}]
["Tenant Cell:",{"$f":"Application!B10","v":0},null,"Tenant Cell:",{"$f":"Application!E10","v":0}]
["Tenant E-mail:",{"$f":"Application!B11","v":0},null,"Tenant E-mail:",{"$f":"Application!E11","v":0}]
["Mailing Address:",{"$f":"Application!B13","v":0},null,"Mailing Address:",{"$f":"Application!E13","v":0}]
["City:",{"$f":"Application!B14","v":0},null,"City:",{"$f":"Application!E14","v":0}]
["State:",{"$f":"Application!B15","v":0},null,"State:",{"$f":"Application!E15","v":0}]
["Zip Code:",{"$f":"Application!B16","v":0},null,"Zip Code:",{"$f":"Application!E16","v":0}]
["Social Security:",{"$f":"\"** - *** - \"&RIGHT(Application!B12,4)","v":"** - *** - "},null,"Social Security:",{"$f":"\"** - *** - \"&RIGHT(Application!E12,4)","v":"** - *** - "}]
[]
[]
[{"$f":"Application!G6","v":"Floor # 1 / Tenant # 3"},null,null,{"$f":"Application!J6","v":"Floor # 1 / Tenant # 4"}]
["Tenant Name:",{"$f":"Application!H7&\" \"&Application!H8","v":" "},null,"Tenant Name:",{"$f":"Application!K7&\" \"&Application!K8","v":" "}]
["Tenant Cell:",{"$f":"Application!H10","v":0},null,"Tenant Cell:",{"$f":"Application!K10","v":0}]
["Tenant E-mail:",{"$f":"Application!H11","v":0},null,"Tenant E-mail:",{"$f":"Application!K11","v":0}]
["Mailing Address:",{"$f":"Application!H13","v":0},null,"Mailing Address:",{"$f":"Application!K13","v":0}]
["City:",{"$f":"Application!H14","v":0},null,"City:",{"$f":"Application!K14","v":0}]
["State:",{"$f":"Application!H15","v":0},null,"State:",{"$f":"Application!K15","v":0}]
["Zip Code:",{"$f":"Application!H16","v":0},null,"Zip Code:",{"$f":"Application!K16","v":0}]
["Social Security:",{"$f":"\"** - *** - \"&RIGHT(Application!H12,4)","v":"** - *** - "},null,"Social Security:",{"$f":"\"** - *** - \"&RIGHT(Application!K12,4)","v":"** - *** - "}]
[]
[]
[{"$f":"Application!A21","v":"Floor # 2 / Tenant # 1"},null,null,{"$f":"Application!D21","v":"Floor # 2 / Tenant # 2"}]
["Tenant Name:",{"$f":"Application!B22&\" \"&Application!B23","v":" "},null,"Tenant Name:",{"$f":"Application!E22&\" \"&Application!E23","v":" "}]
["Tenant Cell:",{"$f":"Application!B25","v":0},null,"Tenant Cell:",{"$f":"Application!E25","v":0}]
["Tenant E-mail:",{"$f":"Application!B26","v":0},null,"Tenant E-mail:",{"$f":"Application!E26","v":0}]
["Mailing Address:",{"$f":"Application!B28","v":0},null,"Mailing Address:",{"$f":"Application!E28","v":0}]
["City:",{"$f":"Application!B29","v":0},null,"City:",{"$f":"Application!E29","v":0}]
["State:",{"$f":"Application!B30","v":0},null,"State:",{"$f":"Application!E30","v":0}]
["Zip Code:",{"$f":"Application!B31","v":0},null,"Zip Code:",{"$f":"Application!E31","v":0}]
["Social Security:",{"$f":"\"** - *** - \"&RIGHT(Application!B27,4)","v":"** - *** - "},null,"Social Security:",{"$f":"\"** - *** - \"&RIGHT(Application!E27,4)","v":"** - *** - "}]
[]
[]
[{"$f":"Application!G21","v":"Floor # 2 / Tenant # 3"},null,null,{"$f":"Application!J21","v":"Floor # 2 / Tenant # 4"}]
["Tenant Name:",{"$f":"Application!H22&\" \"&Application!H23","v":" "},null,"Tenant Name:",{"$f":"Application!K22&\" \"&Application!K23","v":" "}]
["Tenant Cell:",{"$f":"Application!H25","v":0},null,"Tenant Cell:",{"$f":"Application!K25","v":0}]
["Tenant E-mail:",{"$f":"Application!H26","v":0},null,"Tenant E-mail:",{"$f":"Application!K26","v":0}]
["Mailing Address:",{"$f":"Application!H28","v":0},null,"Mailing Address:",{"$f":"Application!K28","v":0}]
["City:",{"$f":"Application!H29","v":0},null,"City:",{"$f":"Application!K29","v":0}]
["State:",{"$f":"Application!H30","v":0},null,"State:",{"$f":"Application!K30","v":0}]
["Zip Code:",{"$f":"Application!H31","v":0},null,"Zip Code:",{"$f":"Application!K31","v":0}]
["Social Security:",{"$f":"\"** - *** - \"&RIGHT(Application!H27,4)","v":"** - *** - "},null,"Social Security:",{"$f":"\"** - *** - \"&RIGHT(Application!K27,4)","v":"** - *** - "}]

{"sheet":"Execution","index":5,"n_rows":42,"n_cols":5,"rows_kept":42,"cut":false,"hidden":true,"merged":[]}
[{"$f":"Application!A6","v":"Floor # 1 / Tenant # 1"},null,null,{"$f":"Application!D6","v":"Floor # 1 / Tenant # 2"}]
["Tenant Name:",{"$f":"Tenants!B2","v":" "},null,"Tenant Name:",{"$f":"Tenants!E2","v":" "}]
["Tenant E-mail:",{"$f":"Application!B11","v":0},null,"Tenant E-mail:",{"$f":"Application!E11","v":0}]
[]
[]
[]
[]
[]
[]
[{"$f":"Application!G6","v":"Floor # 1 / Tenant # 3"},null,null,{"$f":"Application!J6","v":"Floor # 1 / Tenant # 4"}]
["Tenant Name:",{"$f":"Tenants!B13","v":" "},null,"Tenant Name:",{"$f":"Tenants!E13","v":" "}]
["Tenant E-mail:",{"$f":"Application!H11","v":0},null,"Tenant E-mail:",{"$f":"Application!K11","v":0}]
[]
[]
[]
[]
[]
[]
[{"$f":"Application!A21","v":"Floor # 2 / Tenant # 1"},null,null,{"$f":"Application!D21","v":"Floor # 2 / Tenant # 2"}]
["Tenant Name:",{"$f":"Tenants!B24","v":" "},null,"Tenant Name:",{"$f":"Tenants!E24","v":" "}]
["Tenant E-mail:",{"$f":"Application!B26","v":0},null,"Tenant E-mail:",{"$f":"Application!E26","v":0}]
[]
[]
[]
[]
[]
[]
[{"$f":"Application!G21","v":"Floor # 2 / Tenant # 3"},null,null,{"$f":"Application!J21","v":"Floor # 2 / Tenant # 4"}]
["Tenant Name:",{"$f":"Tenants!B35","v":" "},null,"Tenant Name:",{"$f":"Tenants!E35","v":" "}]
["Tenant E-mail:",{"$f":"Application!H26","v":0},null,"Tenant E-mail:",{"$f":"Application!K26","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["X"]
["J&J Investment Properties LLC"]
["Property Manager"]

{"sheet":"Lease Upload","index":6,"n_rows":12,"n_cols":41,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
["Property Name *","Unit Number *","First Name *","Last Name *","Lease Start Date (optional)","Lease End Date (optional)","Rent Cycle (optional if columns H-S are empty)","Rent 1 Amount","Rent 1 Account","Rent 1 Next Due Date","Rent 1 Memo","Rent 2 Amount","Rent 2 Account","Rent 2 Next Due Date","Rent 2 Memo","Rent 3 Amount","Rent 3 Account","Rent 3 Next Due Date","Rent 3 Memo","Street Address Line 1 (optional)","Street Address Line 2 (optional)","Street Address Line 3 (optional)","City/Locality (optional)","State/Province/Territory (optional)","Postal Code (optional)","Alternate Address Line 1 (optional)","Alternate Address Line 2 (optional)","Alternate Address Line 3 (optional)","Alternate City/Locality (optional)","Alternate State/Province/Territory (optional)","Alternate Postal Code (optional)","Login email (optional)","Alternate email (optional)","Home Phone (optional)","Work Phone (optional)","Mobile (optional)","Fax (optional)","Emergency Contact Name (optional)","Emergency Contact Phone (optional)","Date Of Birth (optional)","Comments (optional)"]
[{"$f":"VLOOKUP(Application!$H$2,'Tenant Information'!$B$17:$D$40,3,FALSE)","v":{"$error":"#N/A"}},"1-A",{"$f":"Application!B7","v":0},{"$f":"Application!B8","v":0},{"$f":"DATE('Payment Schedule'!$H$7-1,6,1)","v":"2021-06-01"},{"$f":"DATE('Payment Schedule'!$H$7,5,23)","v":"2022-05-23"},{"$f":"IF('Payment Schedule'!$H$6=\"YES\",\"Quarterly\",\"Monthly\")","v":"Monthly"},{"$f":"IF('Payment Schedule'!$H$6=\"YES\",'Payment Schedule'!$H$2*3,'Payment Schedule'!$H$2)","v":650},"Rent Income",{"$f":"E2","v":"2021-06-01"},"Rent","","","","","","","","",{"$f":"Application!B13","v":0},null,null,{"$f":"Application!B14","v":0},{"$f":"Application!B15","v":0},{"$f":"Application!B16","v":0},"",null,null,"",null,null,{"$f":"'Tenant Information'!C7","v":0},null,null,null,{"$f":"'Tenant Information'!D7","v":0},null,{"$f":"'Tenant Information'!E7","v":0},{"$f":"'Tenant Information'!G7","v":0},{"$f":"Application!B9","v":"00:00:00"},{"$f":"LEFT(A2,3)&\"-\"&B2","v":{"$error":"#N/A"}}]
[{"$f":"VLOOKUP(Application!$H$2,'Tenant Information'!$B$17:$D$40,3,FALSE)","v":{"$error":"#N/A"}},"1-B",{"$f":"Application!E7","v":0},{"$f":"Application!E8","v":0},{"$f":"DATE('Payment Schedule'!$H$7-1,6,1)","v":"2021-06-01"},{"$f":"DATE('Payment Schedule'!$H$7,5,23)","v":"2022-05-23"},{"$f":"IF('Payment Schedule'!$H$6=\"YES\",\"Quarterly\",\"Monthly\")","v":"Monthly"},{"$f":"IF('Payment Schedule'!$H$6=\"YES\",'Payment Schedule'!$H$2*3,'Payment Schedule'!$H$2)","v":650},"Rent Income",{"$f":"'Payment Schedule'!$H$5","v":"2021-06-01"},"Rent","","","","","","","","",{"$f":"Application!E13","v":0},null,null,{"$f":"Application!E14","v":0},{"$f":"Application!E15","v":0},{"$f":"Application!E16","v":0},"",null,null,"",null,null,{"$f":"'Tenant Information'!C8","v":0},null,null,null,{"$f":"'Tenant Information'!D8","v":0},null,{"$f":"'Tenant Information'!E8","v":0},{"$f":"'Tenant Information'!G8","v":0},{"$f":"Application!E9","v":"00:00:00"},{"$error":"#N/A"}]
[{"$f":"VLOOKUP(Application!$H$2,'Tenant Information'!$B$17:$D$40,3,FALSE)","v":{"$error":"#N/A"}},"1-C",{"$f":"Application!H7","v":0},{"$f":"Application!H8","v":0},{"$f":"DATE('Payment Schedule'!$H$7-1,6,1)","v":"2021-06-01"},{"$f":"DATE('Payment Schedule'!$H$7,5,23)","v":"2022-05-23"},{"$f":"IF('Payment Schedule'!$H$6=\"YES\",\"Quarterly\",\"Monthly\")","v":"Monthly"},{"$f":"IF('Payment Schedule'!$H$6=\"YES\",'Payment Schedule'!$H$2*3,'Payment Schedule'!$H$2)","v":650},"Rent Income",{"$f":"'Payment Schedule'!$H$5","v":"2021-06-01"},"Rent","","","","","","","","",{"$f":"Application!H13","v":0},null,null,{"$f":"Application!H14","v":0},{"$f":"Application!H15","v":0},{"$f":"Application!H16","v":0},"",null,null,"",null,null,{"$f":"'Tenant Information'!C9","v":0},null,null,null,{"$f":"'Tenant Information'!D9","v":0},null,{"$f":"'Tenant Information'!E9","v":0},{"$f":"'Tenant Information'!G9","v":0},{"$f":"Application!H9","v":"00:00:00"},{"$error":"#N/A"}]
[{"$f":"VLOOKUP(Application!$H$2,'Tenant Information'!$B$17:$D$40,3,FALSE)","v":{"$error":"#N/A"}},"1-D",{"$f":"Application!K7","v":0},{"$f":"Application!K8","v":0},{"$f":"DATE('Payment Schedule'!$H$7-1,6,1)","v":"2021-06-01"},{"$f":"DATE('Payment Schedule'!$H$7,5,23)","v":"2022-05-23"},{"$f":"IF('Payment Schedule'!$H$6=\"YES\",\"Quarterly\",\"Monthly\")","v":"Monthly"},{"$f":"IF('Payment Schedule'!$H$6=\"YES\",'Payment Schedule'!$H$2*3,'Payment Schedule'!$H$2)","v":650},"Rent Income",{"$f":"'Payment Schedule'!$H$5","v":"2021-06-01"},"Rent","","","","","","","","",{"$f":"Application!K13","v":0},null,null,{"$f":"Application!K14","v":0},{"$f":"Application!K15","v":0},{"$f":"Application!K16","v":0},"",null,null,"",null,null,{"$f":"'Tenant Information'!C10","v":0},null,null,null,{"$f":"'Tenant Information'!D10","v":0},null,{"$f":"'Tenant Information'!E10","v":0},{"$f":"'Tenant Information'!G10","v":0},{"$f":"Application!K9","v":"00:00:00"},{"$error":"#N/A"}]
[{"$f":"VLOOKUP(Application!$H$2,'Tenant Information'!$B$17:$D$40,3,FALSE)","v":{"$error":"#N/A"}},"2-A",{"$f":"Application!B22","v":0},{"$f":"Application!B23","v":0},{"$f":"DATE('Payment Schedule'!$H$7-1,6,1)","v":"2021-06-01"},{"$f":"DATE('Payment Schedule'!$H$7,5,23)","v":"2022-05-23"},{"$f":"IF('Payment Schedule'!$H$6=\"YES\",\"Quarterly\",\"Monthly\")","v":"Monthly"},{"$f":"IF('Payment Schedule'!$H$6=\"YES\",'Payment Schedule'!$H$2*3,'Payment Schedule'!$H$2)","v":650},"Rent Income",{"$f":"'Payment Schedule'!$H$5","v":"2021-06-01"},"Rent","","","","","","","","",{"$f":"Application!B28","v":0},null,null,{"$f":"Application!B29","v":0},{"$f":"Application!B30","v":0},{"$f":"Application!B31","v":0},"",null,null,"",null,null,{"$f":"'Tenant Information'!C11","v":0},null,null,null,{"$f":"'Tenant Information'!D11","v":0},null,{"$f":"'Tenant Information'!E11","v":0},{"$f":"'Tenant Information'!G11","v":0},{"$f":"Application!B24","v":"00:00:00"},{"$error":"#N/A"}]
[{"$f":"VLOOKUP(Application!$H$2,'Tenant Information'!$B$17:$D$40,3,FALSE)","v":{"$error":"#N/A"}},"2-B",{"$f":"Application!E22","v":0},{"$f":"Application!E23","v":0},{"$f":"DATE('Payment Schedule'!$H$7-1,6,1)","v":"2021-06-01"},{"$f":"DATE('Payment Schedule'!$H$7,5,23)","v":"2022-05-23"},{"$f":"IF('Payment Schedule'!$H$6=\"YES\",\"Quarterly\",\"Monthly\")","v":"Monthly"},{"$f":"IF('Payment Schedule'!$H$6=\"YES\",'Payment Schedule'!$H$2*3,'Payment Schedule'!$H$2)","v":650},"Rent Income",{"$f":"'Payment Schedule'!$H$5","v":"2021-06-01"},"Rent","","","","","","","","",{"$f":"Application!E28","v":0},null,null,{"$f":"Application!E29","v":0},{"$f":"Application!E30","v":0},{"$f":"Application!E31","v":0},"",null,null,"",null,null,{"$f":"'Tenant Information'!C12","v":0},null,null,null,{"$f":"'Tenant Information'!D12","v":0},null,{"$f":"'Tenant Information'!E12","v":0},{"$f":"'Tenant Information'!G12","v":0},{"$f":"Application!E24","v":"00:00:00"},{"$error":"#N/A"}]
[{"$f":"VLOOKUP(Application!$H$2,'Tenant Information'!$B$17:$D$40,3,FALSE)","v":{"$error":"#N/A"}},"2-C",{"$f":"Application!H22","v":0},{"$f":"Application!H23","v":0},{"$f":"DATE('Payment Schedule'!$H$7-1,6,1)","v":"2021-06-01"},{"$f":"DATE('Payment Schedule'!$H$7,5,23)","v":"2022-05-23"},{"$f":"IF('Payment Schedule'!$H$6=\"YES\",\"Quarterly\",\"Monthly\")","v":"Monthly"},{"$f":"IF('Payment Schedule'!$H$6=\"YES\",'Payment Schedule'!$H$2*3,'Payment Schedule'!$H$2)","v":650},"Rent Income",{"$f":"'Payment Schedule'!$H$5","v":"2021-06-01"},"Rent","","","","","","","","",{"$f":"Application!H28","v":0},null,null,{"$f":"Application!H29","v":0},{"$f":"Application!H30","v":0},{"$f":"Application!H31","v":0},"",null,null,"",null,null,{"$f":"'Tenant Information'!C13","v":0},null,null,null,{"$f":"'Tenant Information'!D13","v":0},null,{"$f":"'Tenant Information'!E13","v":0},{"$f":"'Tenant Information'!G13","v":0},{"$f":"Application!H24","v":"00:00:00"},{"$error":"#N/A"}]
[{"$f":"VLOOKUP(Application!$H$2,'Tenant Information'!$B$17:$D$40,3,FALSE)","v":{"$error":"#N/A"}},"2-D",{"$f":"Application!K22","v":0},{"$f":"Application!K23","v":0},{"$f":"DATE('Payment Schedule'!$H$7-1,6,1)","v":"2021-06-01"},{"$f":"DATE('Payment Schedule'!$H$7,5,23)","v":"2022-05-23"},{"$f":"IF('Payment Schedule'!$H$6=\"YES\",\"Quarterly\",\"Monthly\")","v":"Monthly"},{"$f":"IF('Payment Schedule'!$H$6=\"YES\",'Payment Schedule'!$H$2*3,'Payment Schedule'!$H$2)","v":650},"Rent Income",{"$f":"'Payment Schedule'!$H$5","v":"2021-06-01"},"Rent","","","","","","","","",{"$f":"Application!K28","v":0},null,null,{"$f":"Application!K29","v":0},{"$f":"Application!K30","v":0},{"$f":"Application!K31","v":0},"",null,null,"",null,null,{"$f":"'Tenant Information'!C14","v":0},null,null,null,{"$f":"'Tenant Information'!D14","v":0},null,{"$f":"'Tenant Information'!E14","v":0},{"$f":"'Tenant Information'!G14","v":0},{"$f":"Application!K24","v":"00:00:00"},{"$error":"#N/A"}]
[]
[{"$f":"'Payment Schedule'!H14","v":0}]
["C:\\Users\\Justin Schmiemann\\Dropbox\\Buildium\\Lease Upload"]

{"sheet":"Charge Upload","index":7,"n_rows":13,"n_cols":23,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
["Date","Transaction Type","Account Number","Property Name","Unit Number","Payment Method","Paid By","Check Number","Check Memo","Amount 1","GL Account Allocation 1","Amount 2","GL Account Allocation 2","Amount 3","GL Account Allocation 3","Amount 4","GL Account Allocation 4","Amount 5","GL Account Allocation 5","Amount 6","GL Account Allocation 6","Amount 7","GL Account Allocation 7"]
["(Required)","(Required)","(Optional)","(Required)","(Required)","Payment Only (Required)","Payment Only (Recommended)","Payment Only (Optional)","Payment Only (Optional - Customizable up to 40 Characters)","(Required)","(Required)","(Optional)","(Optional)","(Optional)","(Optional)","(Optional)","(Optional)","(Optional)","(Optional)","(Optional)","(Optional)","(Optional)","(Optional)"]
[{"$f":"TODAY()","v":"2021-01-25"},"Charge",null,{"$f":"'Lease Upload'!A2","v":{"$error":"#N/A"}},"1-A",null,null,null,null,{"$f":"'Payment Schedule'!H3","v":650},"Security Deposit Liability"]
[{"$f":"TODAY()","v":"2021-01-25"},"Charge",null,{"$f":"'Lease Upload'!A3","v":{"$error":"#N/A"}},"1-B",null,null,null,null,{"$f":"J3","v":650},"Security Deposit Liability"]
["2021-01-25","Charge",null,{"$f":"'Lease Upload'!A4","v":{"$error":"#N/A"}},"1-C",null,null,null,null,{"$f":"J4","v":650},"Security Deposit Liability"]
["2021-01-25","Charge",null,{"$f":"'Lease Upload'!A5","v":{"$error":"#N/A"}},"1-D",null,null,null,null,650,"Security Deposit Liability"]
["2021-01-25","Charge",null,{"$f":"'Lease Upload'!A6","v":{"$error":"#N/A"}},"2-A",null,null,null,null,650,"Security Deposit Liability"]
["2021-01-25","Charge",null,{"$f":"'Lease Upload'!A7","v":{"$error":"#N/A"}},"2-B",null,null,null,null,650,"Security Deposit Liability"]
["2021-01-25","Charge",null,{"$f":"'Lease Upload'!A8","v":{"$error":"#N/A"}},"2-C",null,null,null,null,650,"Security Deposit Liability"]
["2021-01-25","Charge",null,{"$f":"'Lease Upload'!A9","v":{"$error":"#N/A"}},"2-D",null,null,null,null,650,"Security Deposit Liability"]
[]
[{"$f":"'Payment Schedule'!H14","v":0}]
["C:\\Users\\Justi\\Dropbox\\Buildium\\Charge Upload\\"]

{"sheet":"Tenant Information","index":8,"n_rows":108,"n_cols":10,"rows_kept":108,"cut":false,"hidden":true,"merged":[]}
[null,"J&J Investment Properties LLC"]
[null,{"$f":"Application!H2","v":0}]
[null,{"$f":"Application!H4","v":0}]
[]
[null,"Contact List Information",null,null,null,null,null,null,null," "]
[null,"Tenant Name","Tenant E-mail","Tenant Phone","Parent Name","Parent Email","Parent Phone"]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"Application!B11","v":0},{"$f":"Application!B10","v":0},{"$f":"Application!B17","v":0},{"$f":"Application!B19","v":0},{"$f":"Application!B18","v":0}]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"Application!E11","v":0},{"$f":"Application!E10","v":0},{"$f":"Application!E17","v":0},{"$f":"Application!E19","v":0},{"$f":"Application!E18","v":0}]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"Application!H11","v":0},{"$f":"Application!H10","v":0},{"$f":"Application!H17","v":0},{"$f":"Application!H19","v":0},{"$f":"Application!H18","v":0}]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"Application!K11","v":0},{"$f":"Application!K10","v":0},{"$f":"Application!K17","v":0},{"$f":"Application!K19","v":0},{"$f":"Application!K18","v":0}]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"Application!B26","v":0},{"$f":"Application!B25","v":0},{"$f":"Application!B32","v":0},{"$f":"Application!B34","v":0},{"$f":"Application!B33","v":0}]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"Application!E26","v":0},{"$f":"Application!E25","v":0},{"$f":"Application!E32","v":0},{"$f":"Application!E34","v":0},{"$f":"Application!E33","v":0}]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"Application!H26","v":0},{"$f":"Application!H25","v":0},{"$f":"Application!H32","v":0},{"$f":"Application!H34","v":0},{"$f":"Application!H33","v":0}]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"Application!K26","v":0},{"$f":"Application!K25","v":0},{"$f":"Application!K32","v":0},{"$f":"Application!K34","v":0},{"$f":"Application!K33","v":0}]
[]
[null,"Property Address","Vlookup Value","Street Lookup","Property Owner","Landlord / Lessor"]
[null,"198 Ontario St., Albany, NY 12203",198,"198 Ontario Street","J&J 198 Ontario Street LLC","J&J Investment Properties"]
[null,"215-217 Quail St., Albany, NY 12203",215,"215 Quail Street","J&J 215 Quail Street LLC","J&J Investment Properties"]
[null,"238 Quail St., Albany, NY 12203",238,"238 Quail Street","J&J 238 Quail Street LLC","J&J Investment Properties"]
[null,"182 Quail St., Albany, NY 12203",182,"182 Quail Street","Quail Street One LLC","Fairbank Properties"]
[null,"199 Quail St., Albany, NY 12203","199","199 Quail Street","Quail Street One LLC","Fairbank Properties"]
[null,"207 Quail St., Albany, NY 12203","207","207 Quail Street","Quail Street One LLC","Fairbank Properties"]
[null,"242-244 Quail St., Albany, NY 12203",242,"242 Quail Street","J&J 242 Quail Street LLC","J&J Investment Properties"]
[null,"258 Ontario St., Albany, NY 12203",258,"258 Ontario Street","J&J 258 Ontario Street LLC","J&J Investment Properties"]
[null,"260 Ontario St., Albany, NY 12203",260,"260 Ontario Street","J&J 260 Ontario Street LLC","J&J Investment Properties"]
[null,"275 Ontario St., Albany, NY 12203",275,"275 Ontario Street","J&J 275 Ontario Street LLC","J&J Investment Properties"]
[null,"379 Morris St., Albany, NY 12208",379,"379 Morris Street","J&J 379 Morris Street LLC","J&J Investment Properties"]
[null,"433 Morris St., Albany, NY 12208",433,"433 Morris Street","J&J 433 Morris Street LLC","J&J Investment Properties"]
[null,"465 Hudson Ave., Albany, NY 12203",465,"465 Hudson Avenue","J&J 465 Hudson Avenue LLC","J&J Investment Properties"]
[null,"470 Hamilton St., Albany, NY 12203",470,"470 Hamilton Street","J&J 470 Hamilton Street LLC","J&J Investment Properties"]
[null,"473 Hamilton St., Albany, NY 12203",473,"473 Hamilton Street","Justin Schmiemann","J&J Investment Properties"]
[null,"483 Hamilton St., Albany, NY 12203",483,"483 Hamilton Street","J&J 483 Hamilton Street LLC","J&J Investment Properties"]
[null,"484 Hamilton St., Albany, NY 12203",484,"484 Hamilton Street","J&J 484 Hamilton Street LLC","J&J Investment Properties"]
[null,"491 Hamilton St., Albany, NY 12203",491,"491 Hamilton Street","J&J 491 Hamilton Street LLC","J&J Investment Properties"]
[null,"501 Hamilton St., Albany, NY 12203",501,"501 Hamilton Street","Justin Schmiemann","J&J Investment Properties"]
[null,"508 Hamilton St., Albany, NY 12203",508,"508 Hamilton Street","J&J 508 Hamilton Street LLC","J&J Investment Properties"]
[null,"511 Hamilton St., Albany, NY 12203",511,"511 Hamilton Street","J&J 511 Hamilton Street LLC","J&J Investment Properties"]
[null,"519 Hamilton St., Albany, NY 12203",519,"519 Hamilton Street","J&J 519 Hamilton Street LLC","J&J Investment Properties"]
[null,"702 State St., Albany, NY 12203",702,"702 State Street","J&J 702 State Street LLC","J&J Investment Properties"]
[null,"716 State St., Albany, NY 12203",716,"716 State Street","J&J 716 State Street LLC","J&J Investment Properties"]
[null,"236 Western Ave., Albany, NY 12203","236","236 Western Avenue","Western Avenue One LLC","Fairbank Properties"]
[null,"258 Western Ave., Albany, NY 12203","258","258 Western Avenue","Western Avenue Two LLC","Fairbank Properties"]
[null,"272 Western Ave., Albany, NY 12203","272","272 Western Avenue","Western Avenue Three LLC","Fairbank Properties"]
[null,"228 Western Ave., Albany, NY 12203","228","228 Western Avenue","Western Avenue One LLC","Fairbank Properties"]
[null,"240 Western Ave., Albany, NY 12203","240","240 Western Avenue","Western Avenue One LLC","Fairbank Properties"]
[null,"248 Western Ave., Albany, NY 12203","248","248 Western Avenue","Western Avenue Two LLC","Fairbank Properties"]
[null,"268 Western Ave., Albany, NY 12203","268","268 Western Avenue","Western Avenue Three LLC","Fairbank Properties"]
[null,"274 Western Ave., Albany, NY 12203","274","274 Western Avenue","Western Avenue Three LLC","Fairbank Properties"]
[null,"252 Western Ave., Albany, NY 12203","252","252 Western Avenue","Western Avenue Two LLC","Fairbank Properties"]
[]
[null,"Unit #","Vlookup Value"]
[null,1,1]
[null,2,2]
[null,3,3]
[null,"1 & 2","1&2"]
[null,"1, 2 & 3","1, 2 & 3"]
[]
[null,"State List"]
[null,"AK"]
[null,"AL"]
[null,"AZ"]
[null,"AR"]
[null,"CA"]
[null,"CO"]
[null,"CT"]
[null,"DE"]
[null,"FL"]
[null,"GA"]
[null,"HI"]
[null,"ID"]
[null,"IL"]
[null,"IN"]
[null,"IA"]
[null,"KS"]
[null,"KY"]
[null,"LA"]
[null,"ME"]
[null,"MD"]
[null,"MA"]
[null,"MI"]
[null,"MN"]
[null,"MS"]
[null,"MO"]
[null,"MT"]
[null,"NE"]
[null,"NV"]
[null,"NH"]
[null,"NJ"]
[null,"NM"]
[null,"NY"]
[null,"NC"]
[null,"ND"]
[null,"OH"]
[null,"OK"]
[null,"OR"]
[null,"PA"]
[null,"RI"]
[null,"SC"]
[null,"SD"]
[null,"TN"]
[null,"TX"]
[null,"UT"]
[null,"VT"]
[null,"VA"]
[null,"WA"]
[null,"WV"]
[null,"WI"]
[null,"WY"]