{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["1","2"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":"1","index":0,"n_rows":178,"n_cols":2,"rows_kept":178,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[{"$f":"LEFT(B8,22)","v":"               4010101"},"               4010101-Revenue - Membership Subscription - Berths Rental"]
[{"$f":"LEFT(B9,22)","v":"               4010102"},"               4010102-Revenue - Membership Subscription - Land Park Rental"]
["               4010103","               4010103-Revenue - Membership Subscription"]
["               4020101","               4020101-Revenue - Entry Tickets"]
["               4020201","               4020201-Revenue - Games Tickets"]
["               4020202","               4020202-Revenue - Video Games"]
["               4020203","               4020203-Revenue - Billiard Games Tickets"]
["               4020204","               4020204-Revenue - Tickets Bowling Tickets"]
["               4030101","               4030101-Revenue - Foodstuff / Cafeteria"]
["               4030102","               4030102-Revenue - Foodstuff / Restaurant"]
["               4030103","               4030103-Revenue - Foodstuff / Coffee Shop"]
["               4030201","               4030201-Revenue - Beverages / Cafeteria"]
["               4030202","               4030202-Revenue - Beverages / Restaurant"]
["               4030203","               4030203-Revenue - Beverages / Coffee Shop"]
["               4040101","               4040101-Revenue - Sale of Petrol"]
["               4040102","               4040102-Revenue - Sale of Diesel"]
["               4050101","               4050101-Interest Income"]
["               4060101","               4060101-Revenue - Rental of Facility"]
[4060102,"               4060102-Revenue - Rental of Rooms"]
["               4060103","               4060103-Revenue - Rental of Restaurants"]
["               4060104","               4060104-Revenue - Rental of Shops"]
["               4060105","               4060105-Revenue - Rental of Spaces"]
["               4060109","               4060109-Revenue - Extra Beds"]
["               4060201","               4060201-Revenue - Share of Profit of Games"]
["               4060202","               4060202-Revenue - Sharing Boats Insurance Fee - Income"]
["               4070101","               4070101-Reversal of Provision of End of Service Benefit No Longer Required"]
["               4070102","               4070102-Reversal of Provision No Longer Required"]
["               4070201","               4070201-Gain / Loss on Disposal / Retirement of Fixed Assets"]
["               4070302","               4070302-Revenue - Tendering"]
["               4070305","               4070305-Revenue - Rental of Lockers"]
["               4070311","               4070311-Revenue - Overnight Use of Berth (for Boats)"]
["               4070312","               4070312-Revenue from Previous Years"]
["               4070313","               4070313-Revenue - Magnetic Cards"]
["               4070315","               4070315-Revenue - Health Club"]
["               4070316","               4070316-Revenue - Salon"]
["               4070317","               4070317-Revenue - Tickets for Cars Entry"]
["               4070318","               4070318-Miscellaneous Income"]
[{"$f":"LEFT(B45,7)","v":"5010101"},"5010101-Basic Salary"]
[{"$f":"LEFT(B46,7)","v":"5010102"},"5010102-Transportation Allowances"]
["5010103","5010103-Overtime"]
["5010104","5010104-Bonuses"]
["5010105","5010105-Social Allowances"]
["5010106","5010106-Children Allowances"]
["5010107","5010107-Encouragement Allowances"]
["5010108","5010108-Cost of Living Allowances"]
["5010109","5010109-Financial Support Allowances"]
["5010110","5010110-Job Related Allowances"]
["5010111","5010111-Special Allowances"]
["5010112","5010112-Supervision Allowances"]
["5010113","5010113-Food Allowances"]
["5010114","5010114-Mobile Allowances"]
["5010115","5010115-Payout Labor Cost"]
["5010201","5010201-Social Security Expenses"]
["5010202","5010202-Life Insurance"]
["5010203","5010203-Health Insurance Personnel Expenses"]
["5010204","5010204-Health Insurance"]
["5010205","5010205-Social Security Expenses / GCC"]
["5010301","5010301-End of Service Benefits Expense"]
["5010302","5010302-Employees Leave Salary"]
["5010303","5010303-Other Benefits"]
["5010401","5010401-Travelling Expenses - Tickets"]
["5010402","5010402-Employees Clothing Expenses"]
["5010403","5010403-Employees Food Expenses"]
["5010404","5010404-Housing for Employees"]
["5020101","5020101-Office Expenses"]
["5020102","5020102-Printing Expenses"]
["5020103","5020103-Office Stationary Expenses"]
["5020104","5020104-Newspapers and Magazines Subscription Expenses"]
["5020105","5020105-Office Miscellaneous Expenses"]
["5020201","5020201-Official Business Assignments Expenses"]
["5020202","5020202-Staff Training Expenses"]
["5020203","5020203-Committees Compensation Expenses"]
["5020301","5020301-Miscellaneous Consumables"]
["5020302","5020302-Kitchen Tools Consumables"]
["5020303","5020303-Fuel, Oils and Greases Expenses"]
["5020304","5020304-Agricultural Materials and Pesticides Expenses"]
["5020305","5020305-Extinguishing Materials and Safety Equipment"]
["5020306","5020306-Blankets, Linens and Furnishing Costs"]
["5020307","5020307-Decoration Material Expenses"]
["5020308","5020308-Gaming Fishes Expenses"]
["5020309","5020309-Chemicals and Cleaning Material Expenses"]
["5020310","5020310-Magnetic Cards Expenses"]
["5020311","5020311-Purchases Gifts"]
["5020312","5020312-Guest Supplies"]
["5020313","5020313-Recreation Supply"]
["5020314","5020314-Other Supplies"]
["5020315","5020315-Cost of Fuel, Oils and Greases Sale"]
["5020401","5020401-Provision for Bad Debts Expenses"]
["5020402","5020402-Provision for Legal Expenses"]
["5020403","5020403-Provision for Emergency Expense"]
["5020404","5020404-Damaged Assets Expense"]
["5020405","5020405-Obsolete Inventory Expenses"]
["5020406","5020406-Impairment of Inventory"]
["5020407","5020407-Provision for Impairment of assets"]
["5020501","5020501-Discount for Staff"]
["5020502","5020502-Discount for Clients"]
["5020503","5020503-Discount Taken from Suppliers"]
["5020601","5020601-Commissions, Expenses and Bank Charges"]
["5020602","5020602-Foreign Currency Exchange Gain/ Loss"]
["5020603","5020603-Portfolio Management Expenses"]
["5020604","5020604-Impairment of Investments"]
["5020605","5020605-Expenses of Previous Years"]
[{"$f":"LEFT(B110,7)","v":"5020606"},"5020606-Board of Directors Remuneration Expenses"]
["5020607","5020607-Investment Losses"]
["5020608","5020608-Share of Results of Subsidiaries (expenses)"]
["5020609","5020609-VAT Expense - Input VAT Non-recoverable - Goods"]
["5020610","5020610-VAT Expense - Input VAT Non-recoverable - Services"]
["5020611","5020611-VAT Expense - Input VAT on Non Recoverable under RCM - Import of Goods"]
["5020612","5020612-VAT Expense - Input VAT Non-Recoverable under RCM - Import of Services"]
["5020613","5020613-Finance Cost of Lease Liability"]
["5030101","5030101-Electricity Expenses"]
["5030102","5030102-Water Charges"]
["5030201","5030201-Mail and Phone Expenses"]
["5030301","5030301-Cleaner and Waste Transportation Expenses"]
["5030302","5030302-Security Expenses"]
["5030303","5030303-Consultancy Fees"]
["5030304","5030304-Lawyer Fees"]
["5030305","5030305-Auditing Expenses"]
["5030306","5030306-Rental Expenses"]
["5030307","5030307-Rent of Devices and Machines Expenses"]
["5030308","5030308-Transportation and Car Rental Expenses"]
["5030309","5030309-Concerts and Festivals Expenses"]
["5030310","5030310-Safe box Rental Expenses"]
["5030311","5030311-Swimming Coaching / Rescue Team"]
["5030312","5030312-Labour Cost"]
["5030401","5030401-Arcade Game Expenses"]
["5030402","5030402-Cultural and Entertainment Expenses"]
["5030501","5030501-Computer Software Expenses"]
["5030502","5030502-Transaction Fee"]
["5030503","5030503-Legal Fees"]
["5030504","5030504-Hospitality Expenses"]
["5030505","5030505-Snow Purchases"]
["5030506","5030506-Miscellaneous Expenses"]
["5030507","5030507-Laundry and Dry Cleaning"]
["5030508","5030508-Staff House Expenses"]
["5030509","5030509-Staff Cafeteria Expenses"]
["5030510","5030510-Transfer to Department"]
["5040101","5040101-Evaporation of Fuel Expense - Variation"]
["5040102","5040102-Purchases of Petrol"]
["5040103","5040103-Purchases of Diesel"]
["5050101","5050101-Insurance Expenses"]
["5060101","5060101-Advertising and Publicity Expenses"]
["5060102","5060102-Other Marketing expenses"]
["5070101","5070101-Foodstuffs Expenses"]
["5070102","5070102-Beverage Expenses"]
["5080101","5080101-Maintenance of Facilities"]
["5080102","5080102-Garden Maintenance"]
["5080103","5080103-Maintenance of Berths"]
["5080104","5080104-Boats Maintenance"]
["5080105","5080105-Car Maintenance"]
["5080106","5080106-Maintenance of Furniture, Fixture and Decoration"]
["5080107","5080107-Maintenance of Machinery, Tools and Equipment"]
["5080108","5080108-Maintenance of Games"]
["5080109","5080109-Maintenance of IT Systems and Services"]
["5090101","5090101-Depreciation Expense - Land and Building - Building"]
["5090201","5090201-Depreciation Expense - Furniture, Fixture and Decoration - Furniture"]
["5090202","5090202-Depreciation Expense - Furniture, Fixture and Decoration - Fixture"]
["5090203","5090203-Depreciation Expense - Furniture, Fixture and Decoration - Decoration"]
["5090301","5090301-Depreciation Expense - Machinery, Tools and Equipment's - Machinery"]
["5090302","5090302-Depreciation Expense - Machinery, Tools and Equipment's - Equipment's"]
["5090303","5090303-Depreciation Expense - Machinery, Tools and Equipment's - Recreational E"]
["5090401","5090401-Depreciation Expense - Vehicles - Mechanical"]
["5090402","5090402-Depreciation Expense - Vehicles - Electrical"]
["5090403","5090403-Depreciation Expense - Vehicles - Boats"]
["5090501","5090501-Depreciation Expense - Games - Main Games"]
["5090502","5090502-Depreciation Expense - Games - Electrical games"]
[{"$f":"LEFT(B174,7)","v":"5090503"},"5090503-Depreciation Expense - Games - Miscellaneous games"]
["5090601","5090601-Depreciation Expense - Information Technology - Hardware"]
["5090602","5090602-Depreciation Expense - Information Technology - Software"]
["5100101","5100101-Amortisation Expense - Intangible assets - Right of Use"]
["5100102","5100102-Amortisation Expense - Intangible assets - Franchise"]

{"sheet":"2","index":1,"n_rows":12,"n_cols":16,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"BUDGET 2020",null,null,null,null,null,"ROOMS DEPARTMENT BUDGET 2019"]
[null,null,"ACCT NAME","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC","BUDGET 2020"]
[null,null,"Revenue"]
["00131001",4060102,"Rooms",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D5:O5)","v":0}]
["00131123",4060102,"Studios Ground",{"$f":"IFERROR(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(VLOOKUP(B6,'1'!$A$8:$B$200,2,0),0,\"\"),1,\"\"),2,\"\"),3,\"\"),4,\"\"),5,\"\"),6,\"\"),7,\"\"),8,\"\"),9,\"\"),\"\")","v":"               -Revenue - Rental of Rooms"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D6:O6)","v":0}]
["00131124",4060102,"Studios Upper",{"$f":"IFERROR(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(VLOOKUP(B7,'1'!$A$8:$B$200,2,0),0,\"\"),1,\"\"),2,\"\"),3,\"\"),4,\"\"),5,\"\"),6,\"\"),7,\"\"),8,\"\"),9,\"\"),\"\")","v":"               -Revenue - Rental of Rooms"},null,null,null,null,null,null,null,null,null,null,null,0]
["00131125",4060102,"Chalets",{"$f":"IFERROR(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(VLOOKUP(B8,'1'!$A$8:$B$200,2,0),0,\"\"),1,\"\"),2,\"\"),3,\"\"),4,\"\"),5,\"\"),6,\"\"),7,\"\"),8,\"\"),9,\"\"),\"\")","v":"               -Revenue - Rental of Rooms"},null,null,null,null,null,null,null,null,null,null,null,0]
["00131126",4060102,"Villas",{"$f":"IFERROR(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(VLOOKUP(B9,'1'!$A$8:$B$200,2,0),0,\"\"),1,\"\"),2,\"\"),3,\"\"),4,\"\"),5,\"\"),6,\"\"),7,\"\"),8,\"\"),9,\"\"),\"\")","v":"               -Revenue - Rental of Rooms"},null,null,null,null,null,null,null,null,null,null,null,0]
["00131002",4060109,"Extra Bed",{"$f":"IFERROR(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(VLOOKUP(B10,'1'!$A$8:$B$200,2,0),0,\"\"),1,\"\"),2,\"\"),3,\"\"),4,\"\"),5,\"\"),6,\"\"),7,\"\"),8,\"\"),9,\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,0]
[null,0,"Tent Rental",{"$f":"IFERROR(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(VLOOKUP(B11,'1'!$A$8:$B$200,2,0),0,\"\"),1,\"\"),2,\"\"),3,\"\"),4,\"\"),5,\"\"),6,\"\"),7,\"\"),8,\"\"),9,\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,0]
["00131007",4070318,"Other Income",{"$f":"IFERROR(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(VLOOKUP(B12,'1'!$A$8:$B$200,2,0),0,\"\"),1,\"\"),2,\"\"),3,\"\"),4,\"\"),5,\"\"),6,\"\"),7,\"\"),8,\"\"),9,\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,0]