{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["RESOLUTIONS","FIELDS","Property","List "],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":21,"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":"RESOLUTIONS","index":0,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["RELATED LAW - RESOLUTION"]
[]
["#","RESOLUTION","ARTICLE","TEXT"]
[1,"L 27/2017","37.B","Every real estate brokerage licensee shall maintain a register in which all details of real estate brokerage transactions it has done shall be entered, as well as the commissions and amounts charged by it, the value of the transaction, the date of executing the transaction, the personal details of the contracting parties, the earnest money paid to complete the transaction and such other information or particulars as may be stipulated by a resolution to be issued by the Board of Directors.\nA licensee shall submit the register to the Authority to annotate at the end of every financial year or during the timeframe specified by a resolution of the Board of Directors. The Authority may maintain a copy of the register."]
[2,"R 1/2018",19,"The licensee shall maintain and maintain the records of its financial transactions, invoices, accounts, lists, statements and other papers related to the license, for a period not less than (5) years."]

{"sheet":"FIELDS","index":1,"n_rows":31,"n_cols":4,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
["BROKERS TRANSACTION REGISTER"]
[]
["#","FIELD","RECORD","NOTE"]
[1,"BROKER / SALES AGENT","LICENSE #"]
[2,"TRANSACTION DATE"]
[3,"TRANSACTION TYPE","SALE, RENTAL","One selection / Radio Button"]
[4,"ADDRESS","Building no, Street no, Block no","Detailed Address"]
[5,"POSTAL CODE","Is there a district code?"]
[6,"GOOGLE COORDINATES",null,"Difficult to request it without proper UI (mobile or web app)"]
[7,"UNIT TYPE","APPARTMENT, VILLA, HOUSE, BUILDING, LAND, etc.","Need more exchaustive list and agreed taxonomy"]
[8,"USE","COMMERCIAL / RESIDENTIAL / INDUSTRIAL"]
[9,"CONSTRUCTION COMPLETION YEAR",null,"Is this easy to find?"]
[10,"LAND REGISTRY / CADASTRAL CODE","Can they get this from notary or sales contract?","How easy is it to find in Rental transactions?"]
[11,"SALE PRICE (BD)",null,"Any chance we have transactions in other currencies?"]
[12,"SIZE (2 fields maybe - appts, villas)",null,"Size of appartment, house."]
[13,"OWNER SELLER"]
[14,"OWNER BUYER",null,"In case of sale"]
[15,"MORTGAGE VALUE","Maybe we do not need them","In case of sale and use of mortgage"]
[16,"AMORTISATION PERIOD"]
[17,"BANK"]
[18,"BROKER COMMISSION CHARGED","BD"]
[19,"TENURE (IN CASE OF RENT)","MONTHS","Months or Years"]
[20,"BEDROOMS / ROOMS","NO of BEDROOMS (1 - 20)"]
[21,"BATHROOMS / TOILETS","No of BATHROOMS/TOILETS"]
[22,"FURNISHED","YES / NO"]
[23,"AMENITIES","GYM / BALCONY / POOL / SAUNA / ..","Multiple selection of various amenities offered for statistical purposes."]
[24,"PARKING INCLUDED","NO OF SPOTS (O, 1, 2 - 5)"]
[25,"PRIVILAGED VIEW","SEA / CITY / NO VIEW"]
[26,"WAS IT ADVERTISED ? WHERE ?","NO / WEB / NEWSPAPER / SOCIAL MEDIA","Multiple selection for statistical purposes"]
[27,"MONTHS IT WAS EMPTY?",null,"Again nice to know"]
[null,"SIGNATURE"]

{"sheet":"Property","index":2,"n_rows":207,"n_cols":20,"rows_kept":207,"cut":false,"hidden":false,"merged":[[0,0,0,5],[0,7,0,11],[3,4,3,5],[2,4,2,5],[1,0,1,1],[1,2,1,8],[1,10,1,19]]}
["BROKERS TRANSACTION REGISTER ",null,null,null,null,null,null,"سجل معاملات الوسطاء العقارين"]
["Broker Name أسم الوسيط العقاري / company ",null,null,null,null,null,null,null,null,"License No: رقم الرخصة"]
["#","فترة المعاملة ","نوع العقار ","عمر العقار (ان وجد)","الغرض من الاستخدام",null,"رقم المجمع ","رقم العقار ","سعر القدم المربع (د.ب)","سعر البيع (د.ب)","       مساحة البناء        (متر مربع)","   مساحة العقار  (متر مربع)","رقم الإتصال ","الجنسية","عنوان العميل ","رقم بطاقة الهوية /جواز السفر ","إٍسم العميل ","طريقة الدفع","عمولة الوسيط العقاري (د.ب) ","رقم رخصة وكيل المبيعات "]
["#","Transaction Period","Property  Type","Property age","Zone Category/ use",null," Block Number","Plot Number","Price Sqft (BD)","Sales Price (BD)","Built-up (Sqm)","Land Size (Sqm)","Contact No","Nationality","Client Address ","ID No/Passport No","Client Name","Methods of Payment ","Broker Commission (BD)","Sales Agent Lic. No. "]
[null,"Completion month ","Select the Property type from Drop Down.","What date was the building completed or is expected.","Select the Use from Drop Down.",null,null,"Please Refer the code from the contract.",null,null,null,null,null,null,null,null,null,"Cash - Mortgage ",null,"Corporate only "]
[null,"شهر انهاء المعاملة","اختار من القائمة ","تاريخ الانتهاء من البناء أو المتوقع الانتهاء منه","اختار من القائمة ",null,null,"الرمز متوفر في وثيقة الملكية",null,null,null,null,null,null,null,null,null,"نقدا - قرض ",null,"للشركات فقط "]
["#","Transaction Period","Property Type","Property  Year","Zone ","Zone Category"," Block Number","Plot Number","Price Sqft (BD)","Sales Price (BD)","Built-up (Sqm)","Land Size (Sqm)","Contact No","Nationality","Client Address ","ID No/Passport No","Client Name","Methods of Payment ","Broker Commission (BD)","Sales Agent Lic. No. "]
[1,"Apr-2024"]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75]
[76]
[77]
[78]
[79]
[80]
[81]
[82]
[83]
[84]
[85]
[86]
[87]
[88]
[89]
[90]
[91]
[92]
[93]
[94]
[95]
[96]
[97]
[98]
[99]
[100]
[101]
[102]
[103]
[104]
[105]
[106]
[107]
[108]
[109]
[110]
[111]
[112]
[113]
[114]
[115]
[116]
[117]
[118]
[119]
[120]
[121]
[122]
[123]
[124]
[125]
[126]
[127]
[128]
[129]
[130]
[131]
[132]
[133]
[134]
[135]
[136]
[137]
[138]
[139]
[140]
[141]
[142]
[143]
[144]
[145]
[146]
[147]
[148]
[149]
[150]
[151]
[152]
[153]
[154]
[155]
[156]
[157]
[158]
[159]
[160]
[161]
[162]
[163]
[164]
[165]
[166]
[167]
[168]
[169]
[170]
[171]
[172]
[173]
[174]
[175]
[176]
[177]
[178]
[179]
[180]
[181]
[182]
[183]
[184]
[185]
[186]
[187]
[188]
[189]
[190]
[191]
[192]
[193]
[194]
[195]
[196]
[197]
[198]
[199]
[200]

{"sheet":"List ","index":3,"n_rows":43,"n_cols":21,"rows_kept":43,"cut":false,"hidden":true,"merged":[]}
["TYPE"]
["Apartment   شقة"]
["Villa  فيلا "]
["Townhouse  منزل "]
["Compound   مجمع سكني "]
["Building  مبنى  ","2021-01-01"]
["Retail  محل تجاري ","2021-02-01",null,null,null,null,null,null,"less the 3 years"]
["Office  مكتب ","2021-03-01",null,null,"Execlusive  كامل",null,null,null,{"$f":"+I60","v":0}]
["Land   ارض ","2021-04-01",null,null,"Split  نصف"]
["Land   ارض ","2021-05-01",null,null,"Multiple   شراكة"]
[null,"2021-06-01"]
[null,"2021-07-01"]
["USE","2021-08-01"]
["Residential   سكني ","2021-09-01",null,null,null,null,null,null,"Individual شخص ",null,null,null,1,null,null,"Off-Plan sale البيع على الخريطة"]
["Commercial   تجاري ","2021-10-01",null,null,null,null,null,null,"More than one individual أكثر من شخص",null,null,null,2,null,null,"NEW جديد "]
["Industrial   صناعي ","2021-11-01",null,null,"unit    الوحده",null,null,null,"Corporate  شركة",null,null,null,3,null,null,"1-5 years "]
["Leisure  رفاهية","2021-12-01",null,null,"total unit جميع الوحدات",null,null,null,null,null,null,null,4,null,null,"6-10 years "]
["Residential/Commercial سكني/تجاري","2019-01-01",null,null,null,null,null,null,null,null,null,null,5,null,null,"11-15 years "]
[null,"2019-02-01",null,null,null,null,null,null,"Unit الوحدة ",null,null,null,"More than 5 أكثر من ",null,null,"16-20 years ",null,null,null,null,"2019-01-01"]
["AMENITIES","2019-03-01",null,null,"Buyer ",null,null,null," المبنى Building ",null,null,null,null,null,null,"More than 20 years أكثر من ",null,null,null,null,"2019-02-01"]
["Gym   نادي صحي ","2019-04-01",null,null,"Seller ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-03-01"]
["Parking   مواقف للسيارات","2019-05-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-04-01"]
["Balcony  بلكونة","2019-06-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-05-01"]
["Pool  حمام سباحة ","2019-07-01","RA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-06-01"]
["Garden   حديقة ","2019-08-01","RB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-07-01"]
["Spa سبا ","2019-09-01","RHA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-08-01"]
[null,"2019-10-01","RHB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-09-01"]
[null,"2019-11-01","BR5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-10-01"]
[null,"2019-12-01","RG",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-11-01"]
[null,null,"MOH",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-12-01"]
[null,null,"BA"]
[null,null,"BB"]
[null,null,"BC"]
[null,null,"BD"]
[null,null,"B4"]
[null,null,"B3"]
[null,null,"COM"]
[null,null,"DA"]
[null,null,"DB"]
[null,null,"LD"]
[null,null,"WS"]
[null,null,"S"]
[null,null,"AG"]