{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["OCTemplate1","OCTemplate2","Template","OC Setup","Lot Entitlement & Liability","Worksheet","About"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":0,"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":"OCTemplate1","index":0,"n_rows":74,"n_cols":15,"rows_kept":74,"cut":false,"hidden":true,"merged":[[8,12,8,14],[10,12,11,12],[10,13,11,13],[10,14,11,14],[12,12,13,12],[12,13,13,13],[12,14,13,14],[14,12,15,12],[14,13,15,13],[14,14,15,14],[15,0,15,11],[16,0,16,11],[10,0,10,11],[11,0,11,11],[12,0,12,11],[13,0,13,11],[14,0,14,11],[71,13,72,14],[1,12,1,14],[4,0,4,4],[69,0,69,14],[72,9,72,12],[72,5,72,8],[70,0,73,4],[71,5,71,8],[73,5,73,9],[73,10,73,14],[71,9,71,12],[70,5,70,12],[17,0,17,14],[8,0,8,11],[9,0,9,11],[3,7,3,14],[7,0,7,11],[2,0,2,2],[0,10,0,14],[0,0,0,9],[1,0,1,4],[1,6,1,9],[1,10,1,11],[4,5,4,14],[2,6,2,14]]}
["OWNERS CORPORATION SCHEDULE"]
["Owners Corporation No.",null,null,null,null,null,null,null,null,null,"Plan No.",null,{"$f":"IF(K1=\"\",\"\",LEFT(K1,9))","v":""}]
["Land affected by Owners Corporation",null,null,null,null,"Lots:"]
[null,null,null,null,null,"Common Property No.:"]
["Limitations of Owners Corporation:"]
[null,"All of the lots in the table below",{"$f":"\"All existing lots in Owners Corporation \"&D6&\" not affected by this plan and all of the lots in the table below\"","v":"All existing lots in Owners Corporation X not affected by this plan and all of the lots in the table below"},{"$f":"IF(ISBLANK(F2),\"X\",F2)","v":"X"},"Unlimited","Limited","Limited to Common Property",null,null,null,{"$f":"\"Only the members of Owners Corporation No. \"&D6&\" are entitled to use Common Property No. X\"","v":"Only the members of Owners Corporation No. X are entitled to use Common Property No. X"},"Folio of the Register for Common Property No. X is in the name of Owners Corporation No. 1",{"$f":"\"Members of Owners Corporation No. \"&D6&\" are also affected by Owners Corporation No. 1\"","v":"Members of Owners Corporation No. X are also affected by Owners Corporation No. 1"},{"$f":"\"The purpose of Owners Corporation No. \"&D6&\" is to …\"","v":"The purpose of Owners Corporation No. X is to …"},"Nil"]
["Notations"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Totals"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Entitlement","Liability"]
[null,null,null,null,null,null,null,null,null,null,null,null,"This schedule",{"$f":"SUM(B20:B69,F20:F69,J20:J69,N20:N69)","v":0},{"$f":"SUM(C20:C69,G20:G69,K20:K69,O20:O69)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Balance of existing OC",0,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Overall Total",{"$f":"N11+N13","v":0},{"$f":"O11+O13","v":0}]
[]
[]
["Lot Entitlement and Lot Liability"]
["Lot","Entitlement","Liability",null,"Lot","Entitlement","Liability",null,"Lot","Entitlement","Liability",null,"Lot","Entitlement","Liability"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"SHEET"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ORIGINAL SHEET \nSIZE: A3"]
[]
[null,null,null,null,null,"< SURVEYORS NAME / VERSION NO >"]

{"sheet":"OCTemplate2","index":1,"n_rows":74,"n_cols":15,"rows_kept":74,"cut":false,"hidden":true,"merged":[[1,12,1,14],[0,10,0,14],[2,0,2,14],[73,5,73,9],[70,0,73,4],[70,5,70,12],[71,5,71,8],[71,9,71,12],[71,13,72,14],[72,5,72,8],[72,9,72,12],[0,0,0,9],[1,0,1,4],[1,6,1,9],[1,10,1,11],[73,10,73,14]]}
["OWNERS CORPORATION SCHEDULE"]
["Owners Corporation No.",null,null,null,null,null,null,null,null,null,"Plan No."]
["Lot Entitlement and Lot Liability"]
["Lot","Entitlement","Liability",null,"Lot","Entitlement","Liability",null,"Lot","Entitlement","Liability",null,"Lot","Entitlement","Liability"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"IF(OCTemplate1!F71=\"\",\"\",OCTemplate1!F71)","v":""},null,null,null,null,null,null,null,"SHEET"]
[null,null,null,null,null,{"$f":"IF(OCTemplate1!F72=\"\",\"\",OCTemplate1!F72)","v":""},null,null,null,{"$f":"IF(OCTemplate1!J72=0,\"\",OCTemplate1!J72)","v":""},null,null,null,"ORIGINAL SHEET \nSIZE: A3"]
[null,null,null,null,null,{"$f":"IF(OCTemplate1!F73=\"\",\"\",OCTemplate1!F73)","v":""},null,null,null,{"$f":"IF(OCTemplate1!J73=\"\",\"\",OCTemplate1!J73)","v":""}]
[null,null,null,null,null,{"$f":"IF(OCTemplate1!F74=\"\",\"\",OCTemplate1!F74)","v":"< SURVEYORS NAME / VERSION NO >"}]

{"sheet":"Template","index":2,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
["OC Number",null,null,{"$f":"\"OWNERS CORPORATION NO. \"&B1","v":"OWNERS CORPORATION NO. "}]
["Common Property",null,null,"Entitlement","Liability"]
["Limitations"]
["Existing OC balance - entitlement"]
["Existing OC balance - liability"]
["Notation 1"]
["Notation 2"]
["Notation 3"]
["Notation 4"]
["Notation 5"]
["Notation 6"]
["Notation 7"]
["Notation 8"]
["Notation 9"]
["Notation 10"]
[]
[null,null,"LIMITED TO COMMON PROPERTY"]

{"sheet":"OC Setup","index":3,"n_rows":23,"n_cols":3,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Plan Number",null,1]
["Surveyors File Reference",null,"Unlimited"]
["Reference 2",null,"Limited"]
["Reference 3",null,"Limited to Common Property"]
["Reference 4"]
["Reference 5"]
["Surveyor Name"]
["Plan Version"]
["OC Number",null,1]
["Common Property"]
["Limitations",null,{"$f":"\"Only the members of Owners Corporation No. \"&$C$9&\" are entitled to use Common Property No. X\"","v":"Only the members of Owners Corporation No. 1 are entitled to use Common Property No. X"}]
["Existing OC balance - entitlement",null,"Folio of the Register for Common Property No. X is in the name of Owners Corporation No. 1"]
["Existing OC balance - liability",null,{"$f":"\"Members of Owners Corporation No. \"&$C$9&\" are also affected by Owners Corporation No. 1\"","v":"Members of Owners Corporation No. 1 are also affected by Owners Corporation No. 1"}]
["Notation 1",null,{"$f":"\"The purpose of Owners Corporation No. \"&$C$9&\" is to ...\"","v":"The purpose of Owners Corporation No. 1 is to ..."}]
["Notation 2",null,"Nil"]
["Notation 3"]
["Notation 4"]
["Notation 5"]
["Notation 6"]
["Notation 7"]
["Notation 8"]
["Notation 9"]
["Notation 10"]

{"sheet":"Lot Entitlement & Liability","index":4,"n_rows":2,"n_cols":4,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"\"OWNERS CORPORATION NO. \"&'OC Setup'!B9","v":"OWNERS CORPORATION NO. "}]
["Comments","Lot","Entitlement","Liability"]

{"sheet":"Worksheet","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"About","index":6,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
["Introduction","This OC macro spreadsheet can be used by surveyors wishing to manage data for large or multiple OC plans in a single file. When ready to add your OC details to SPEAR, click the button to export the data to the format accepted by SPEAR. You can also export to PDF to provide to your clients, if required.\n\nNote: Use of this OC macro spreadsheet is optional. Surveyors can instead choose to use the existing OC spreadsheet templates in SPEAR. \n"]
["Sheet: OC Setup","The 'OC Setup' sheet allows you to add or remove OCs, and add the administrative information about each Owners Corporation. You can also update your logo from this sheet and enable various settings explained below.\n\nNote: To modify a preset notation, select it from the drop-down list and press F2.\n"]
["Sheet: Lot Entitlement & Liability","The 'Lot Entitlement & Liability' sheet allows you to list all of your lot entitlement and liability data, including any comments you wish to add. The comments are for your reference only and won't appear on the exported OC schedules. \n\nNote: A blank value for lot entitlement and liability means that the lot is not part of that particular Owners Corporation.\n\nWhere possible, the spreadsheet will place defined lot groupings together. Leave a blank row to indicate the end of one group and the start of another. \n"]
["Button: Generate OC Schedule(s)","Once all of the data is populated, click 'Generate OC Schedule(s)' to have the OC spreadsheet files created for you, ready to be loaded into SPEAR.\n "]
["Sheet: Worksheet","This is a blank sheet which can be used for any additional calculations, if required. This sheet won't form part of the exported OC schedules.\n"]
["Settings","The following settings are located on the 'OC Setup' sheet.\n\nExport to Excel/PDF/both\nAllows you to select the file format(s) in which you want the schedules to be generated.\n\nMerge all PDF schedules on export\nWhen this option is ticked and you are exporting to PDF, only one merged PDF file will be produced.\n\nSave output in same location as this file\nWhen this option is ticked, any exported files will be saved in the same folder as this file. Otherwise, you will be asked where you want to save the files each time. Note: If you are accessing this file from a read-only server and experiencing issues, you may need to untick this option.\n\nInclude Surveyors File Reference in file name\nThe default file name format for exported files is: Plan Number - OC & Version number - Timestamp. \nExample: PS654321A - OC1 Version A - 2017-01-01 120000.xls\nWhen this option is ticked, the Surveyors File Reference (cell B2) will be included before the Plan Number.\nExample: 123 - PS654321 - OC1 Version A - 2017-01-01 120000.xls\n\nEnable custom scale\nIf you are using a Windows display scale greater than 100% and are experiencing PDF print issues, enable this checkbox to compensate for the non-standard display scale."]
["Help","This spreadsheet is macro-enabled and may be blocked by your IT system. Please ensure you click 'Enable Content' in Excel to allow the macro to function.\n\nIf you need any assistance using this spreadsheet or SPEAR, please contact the SPEAR Service Desk\n"]
["Contact Information",{"$f":"HYPERLINK(\"https://www.spear.land.vic.gov.au/spear/pages/about/contact-us/service-desk.shtml\",\"SPEAR Service Desk\")","v":"SPEAR Service Desk"}]
["Copyright",{"$f":"HYPERLINK(\"https://www.spear.land.vic.gov.au/spear/pages/disclaimer.shtml\",\"Copyright © 2017 State Government of Victoria\")","v":"Copyright © 2017 State Government of Victoria"}]