{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["RESOLUTIONS","FIELDS","Report","List "],"not_rendered":{"external_links":1,"defined_names":21},"read":"whole","date_system":"1900"}

{"sheet":"RESOLUTIONS","index":0,"n_rows":5,"n_cols":4,"rows_kept":5,"hidden":true}
["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,"hidden":true}
["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":"Report","index":2,"n_rows":208,"n_cols":19,"rows_kept":208,"merged":[[0,11,0,14],[1,0,1,18],[2,0,2,1],[2,7,2,9],[2,11,2,13],[2,15,2,18]]}
["VALUATION TRANSACTIONS REPORT",{"$nulls":10},"تقرير معاملات التثمين العقاري "]
[" Property  العقارات  "]
["Valuer  Name أسم المثمن / company ",{"$nulls":9},"License No: رقم الرخصة",{"$nulls":3},"License Type (classification)نوع الرخصة (التصنيف)"]
["#","فترة المعاملة ","إسم العميل ","رقم بطاقة الهوية/جواز السفر","عنوان العميل ","الجنسية ","رقم الإتصال ","نوع العقار ","عمر العقار (ان وجد)","الغرض من الاستخدام","رقم المجمع ","رقم العقار ","سعر القدم المربع (د.ب)","مبلغ التثمين (د.ب)","مساحة العقار (د.ب)","الغرض من التثمين","عمولة المثمن (د.ب)","Notes ملاحظات"]
["#","TRANSACTION period /dates ","Client Name","ID No /Passport No","Cleint Address ","Nationality ","Contact No ","Property  Type","Property age","Zone category/ use","Block Number","Plot Number","Price per sq ft","Value (per valuation report) BD","Land Size (Sqm)","Valuation Method","Valuer Fee for Valuation Report BD","Others ","Comments "]
[null,"date as per Valuation Report",{"$nulls":5},"Select the Property type from Drop Down.","What date was the building completed or is expected.","Select the Use from Drop Down.",null,"Please Refer the code from the contract."]
[null,"شهر انهاء المعاملة",{"$nulls":5},"اختار من القائمة ","تاريخ الانتهاء من البناء أو المتوقع الانتهاء منه","اختار من القائمة ",null,"الرمز متوفر في وثيقة الملكية"]
["#","TRANSACTION period / dates","Client Name","ID No /Passport No","Cleint Address ","Nationality ","Contact No ","Property Type","Property  YEAR","Zone ","Block Number","Plot Number","Price per sq ft","Value (per Valuation report) BD","Land Size (Sqm)","Valuation Method","Valuer Fee for Valuation Report BD","Others ","Comments "]
[1]
[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":16,"rows_kept":43,"hidden":true}
["TYPE"]
["Apartment   شقة"]
["Villa  فيلا "]
["Townhouse  منزل "]
["Compound   مجمع سكني "]
["Building  مبنى  ","Q1-2021"]
["Retail  محل تجاري ","Q2-2021",{"$nulls":6},"less the 3 years"]
["Office  مكتب ","Q3-2021",null,null,"Execlusive  كامل",{"$nulls":3},{"$f":"+I60","v":0}]
["Land   ارض ","Q4-2021",null,null,"Split  نصف"]
[{"$nulls":4},"Multiple   شراكة"]
[]
[]
["USE"]
["Residential   سكني ",{"$nulls":7},"Individual شخص ",{"$nulls":3},1,null,null,"Off-Plan sale البيع على الخريطة"]
["Commercial   تجاري ",{"$nulls":7},"More than one individual أكثر من شخص",{"$nulls":3},2,null,null,"NEW جديد "]
["Industrial   صناعي ",{"$nulls":3},"unit    الوحده",{"$nulls":3},"Corporate  شركة",{"$nulls":3},3,null,null,"1-5 years "]
["Leisure  رفاهية",{"$nulls":3},"total unit جميع الوحدات",{"$nulls":7},4,null,null,"6-10 years "]
["Residential/Commercial سكني/تجاري",{"$nulls":11},5,null,null,"11-15 years "]
[{"$nulls":8},"Unit الوحدة ",{"$nulls":3},"More than 5 أكثر من ",null,null,"16-20 years "]
["AMENITIES",{"$nulls":3},"Buyer ",{"$nulls":3}," المبنى Building ",{"$nulls":6},"More than 20 years أكثر من "]
["Gym   نادي صحي ",{"$nulls":3},"Seller "]
["Parking   مواقف للسيارات"]
["Balcony  بلكونة"]
["Pool  حمام سباحة ",null,"RA"]
["Garden   حديقة ",null,"RB"]
["Spa سبا ",null,"RHA"]
[null,null,"RHB"]
[null,null,"BR5"]
[null,null,"RG"]
[null,null,"MOH"]
[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"]