{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["INSTRUCTIONS","1-100"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"INSTRUCTIONS","index":0,"n_rows":16,"n_cols":15,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[null,"INSTRUCTIONS"]
[null,null,"Fill out each column, as it applies to each property. "]
[null,null,"     - Referrals to HRRA members must be deducted from the GCI or Units. GCI requires a monentary amount and units will be a portion of the unit. "]
[null,null,null,"Example: The referal fee is 25%. GCI would be $250 of a $1000 GCI. Units would be .25 of 1 unit. "]
[null,null,"     - If you are submitting by GCI you do not need to fill out the Units columns (column K and M) "]
[null,null,"     - Provide Info Referrals and other income = Name of agent for referal or other property details "]
[]
[]
[null,null,"MLS #","Property Address   ","Closed Date","Final            Sales Price","TOTAL GCI","LESS GCI Referral Amount","PLUS Prop. Mgt. Income    ","PLUS Other Misc. Inc.","Adj. GCI","Units ","O/G Ref. Units (.25)","Are they a HRRA member? (Y/N)","Team Member Associated with Transaction"]
[null,null,"EXAMPLE","101 Home Address Lane, Chesapeake ","2022-01-31",100000,3000,200,100,100,{"$f":"SUM(G11-H11+I11+J11)","v":3000},1,0.25]
[]
[]
[null,null,"GCI completes the grey and blue columns "]
[null,null,"Units completes the grey and green columns "]
[null,null,"TEAMS also completes the green column "]

{"sheet":"1-100","index":1,"n_rows":108,"n_cols":15,"rows_kept":108,"cut":false,"hidden":false,"merged":[[107,0,107,3],[1,0,3,8],[1,9,3,13],[1,14,3,14],[4,1,4,4],[4,5,4,8],[4,10,4,11]]}
[]
["Property Data Form - Circle of Excellencesm ",{"$nulls":8},"NAME OF APPLICANT",{"$nulls":4},"2023 Awards Period"]
[]
[]
[{"$nulls":5},"Fill out if submitting by GCI",{"$nulls":4},"Fill out if submitting by UNITS ",null,null,null,"Fill out if Team Application"]
[null,"MLS #","Property Address   ","Closed Date","Final            Sales Price","TOTAL GCI","LESS GCI Referral Amount","PLUS Prop. Mgt. Income    ","PLUS Other Misc. Inc.","Adj. GCI","Units ","O/G Ref. Units (.25)","REFERRAL      Are they a HRRA member? (Y/N)","Name of Referral ","Team Member Associated with Transaction"]
[null,"Example - MLS # ","101 Home address Lane, Chesapeake","2022-01-31",300000,3000,200,100,150,{"$f":"F7-G7+H7+I7","v":3050},1,0.25,"Y"]
[1,{"$nulls":8},{"$f":"SUM(F8-G8+H8+I8)","v":0}]
[{"$f":"A8+1","v":2},{"$nulls":8},{"$f":"SUM(F9-G9+H9+I9)","v":0}]
[{"$f":"A9+1","v":3},{"$nulls":8},0]
[4,{"$nulls":8},0]
[5,{"$nulls":8},0]
[6,{"$nulls":8},0]
[7,{"$nulls":8},0]
[8,{"$nulls":8},0]
[9,{"$nulls":8},0]
[10,{"$nulls":8},0]
[11,{"$nulls":8},0]
[12,{"$nulls":8},0]
[13,{"$nulls":8},0]
[14,{"$nulls":8},0]
[15,{"$nulls":8},0]
[16,{"$nulls":8},0]
[17,{"$nulls":8},0]
[18,{"$nulls":8},0]
[19,{"$nulls":8},0]
[20,{"$nulls":8},0]
[21,{"$nulls":8},0]
[22,{"$nulls":8},0]
[23,{"$nulls":8},0]
[24,{"$nulls":8},0]
[25,{"$nulls":8},0]
[26,{"$nulls":8},0]
[27,{"$nulls":8},0]
[28,{"$nulls":8},0]
[29,{"$nulls":8},0]
[30,{"$nulls":8},0]
[31,{"$nulls":8},0]
[32,{"$nulls":8},0]
[33,{"$nulls":8},0]
[34,{"$nulls":8},0]
[35,{"$nulls":8},0]
[36,{"$nulls":8},0]
[37,{"$nulls":8},0]
[38,{"$nulls":8},0]
[39,{"$nulls":8},0]
[40,{"$nulls":8},0]
[41,{"$nulls":8},0]
[42,{"$nulls":8},0]
[43,{"$nulls":8},0]
[44,{"$nulls":8},0]
[45,{"$nulls":8},0]
[46,{"$nulls":8},0]
[47,{"$nulls":8},0]
[48,{"$nulls":8},0]
[49,{"$nulls":8},0]
[50,{"$nulls":8},0]
[51,{"$nulls":8},0]
[52,{"$nulls":8},0]
[53,{"$nulls":8},0]
[54,{"$nulls":8},0]
[55,{"$nulls":8},0]
[56,{"$nulls":8},0]
[57,{"$nulls":8},0]
[58,{"$nulls":8},0]
[59,{"$nulls":8},0]
[60,{"$nulls":8},0]
[61,{"$nulls":8},0]
[62,{"$nulls":8},0]
[63,{"$nulls":8},0]
[64,{"$nulls":8},0]
[65,{"$nulls":8},0]
[66,{"$nulls":8},{"$f":"SUM(F73-G73+H73+I73)","v":0}]
[{"$f":"A73+1","v":67},{"$nulls":8},0]
[68,{"$nulls":8},0]
[69,{"$nulls":8},0]
[70,{"$nulls":8},0]
[71,{"$nulls":8},0]
[72,{"$nulls":8},0]
[73,{"$nulls":8},0]
[74,{"$nulls":8},0]
[75,{"$nulls":8},0]
[76,{"$nulls":8},0]
[77,{"$nulls":8},0]
[78,{"$nulls":8},0]
[79,{"$nulls":8},0]
[80,{"$nulls":8},0]
[81,{"$nulls":8},0]
[82,{"$nulls":8},0]
[83,{"$nulls":8},0]
[84,{"$nulls":8},0]
[85,{"$nulls":8},0]
[86,{"$nulls":8},0]
[87,{"$nulls":8},0]
[88,{"$nulls":8},0]
[89,{"$nulls":8},0]
[90,{"$nulls":8},0]
[91,{"$nulls":8},0]
[92,{"$nulls":8},0]
[93,{"$nulls":8},0]
[94,{"$nulls":8},0]
[95,{"$nulls":8},0]
[96,{"$nulls":8},0]
[97,{"$nulls":8},0]
[98,{"$nulls":8},0]
[99,{"$nulls":8},0]
[100,{"$nulls":8},0]
["TOTALS:",null,null,null,{"$f":"SUM(E8:E107)","v":0},0,0,0,0,0,0,0]