{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Setting","Summary","January","February","March"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":5,"comments":1,"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":"Setting","index":0,"n_rows":16,"n_cols":47,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
[]
["Memo Travel Company","Answer Safari","Aqua Dight","Fire SeaScope","Follow Aqua Boda","Apolly Divers","Lottery Diving Club",null,"Luba Center","Panorama Kabeer",null,null,null,null,null,"Nourse Safary"]
["Transfer (AirPort)",null,"Private Boat Fishing","Rusalka ","Utopia Island","Private Boat Fishing","Intro Diving-Diving",null,"Scuba Trip","Rusalka ",null,null,null,null,null,"Mega Safari",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer Safari"]
["Transfer (Excursion)",null,"Port Ghaleb",null,"Royal Utopia","Port Ghaleb","Intro Diving-Snorkeling",null,"Super Scuba",null,null,null,null,null,null,"Moto 3 Hours",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Aqua Dight"]
["Flight Crew",null,"Intro Diving-Diving",null,"El Gouna Deluxe","Pirates 3 X1","Open Water Course HRG",null,"Private Boat Fishing",null,null,null,null,null,null,"Moto 5 Hours",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fire SeaScope"]
["Tips",null,"Intro Diving-Snorkeling",null,"Sunset Boat","Intro Diving-Diving","Advanced Course HRG",null,"Individual Super Scuba",null,null,null,null,null,null,"Super Safari",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Follow Aqua Boda"]
[null,null,null,null,"Snorkeling (Coral Reef)","Intro Diving-Snorkeling","Private Boat Fishing",null,"Extra Cost",null,null,null,null,null,null,"Individual Moto 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Apolly Divers"]
[null,null,null,null,"All In One",null,"Extra Cost",null,"National Park Fees",null,null,null,null,null,null,"Individual Moto 5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lottery Diving Club"]
[null,null,null,null,"Fishing Trip",null,null,null,null,null,null,null,null,null,null,"Individual Super Safari",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Luba Center"]
[null,null,null,null,"Fishing Deluxe",null,null,null,null,null,null,null,null,null,null,"Safari Fees",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Panorama Kabeer"]
[null,null,null,null,"Scuba Trip",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nourse Safary"]
[null,null,null,null,"Super Scuba",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Memo Travel Company"]
[null,null,null,null,"Private Boat Fishing"]
[null,null,null,null,"Individual  Royal Utopia"]
[null,null,null,null,"Private Sunset Boat"]
[null,null,null,null,"National Park Fees"]

{"sheet":"Summary","index":1,"n_rows":212,"n_cols":13,"rows_kept":212,"cut":false,"hidden":false,"merged":[[0,3,0,4],[209,0,209,2]]}
[null,null,null,"Total",null,null,null,null,null,null,null,"Total L.E","Total $"]
["SER.","Supplier Name","Trip Name","L.E","$","Transfer","Discount","Kick Back","Vat 14%","Tax Discount 3%","Grand Total"]
[{"$f":"IF($B3=\"\",\"\",SUBTOTAL(3,$B$3:B3))","v":1},"Answer Safari",null,5000,null,null,null,null,700.00000000000011,-150,5550]
[{"$f":"IF($B4=\"\",\"\",SUBTOTAL(3,$B$3:B4))","v":2},"Aqua Dight","Intro Diving-Snorkeling",5650,null,null,282.5,null,0,-161.02500000000001,5206.4750000000004]
[{"$f":"IF($B5=\"\",\"\",SUBTOTAL(3,$B$3:B5))","v":3},"Fire SeaScope","Rusalka ",{"$f":"6120+450+450","v":7020},null,1155,null,490.5,1075.83,230.54,8529.7999999999993]
[{"$f":"IF($B6=\"\",\"\",SUBTOTAL(3,$B$3:B6))","v":4},"Follow Aqua Boda","Snorkeling (Coral Reef)",6650,null,2520,917,null,0,-247.59,8005.41]
[{"$f":"IF($B7=\"\",\"\",SUBTOTAL(3,$B$3:B7))","v":5},"Follow Aqua Boda","National Park Fees",null,180,null,null,null,null,null,180]
[{"$f":"IF($B8=\"\",\"\",SUBTOTAL(3,$B$3:B8))","v":""}]
[{"$f":"IF($B9=\"\",\"\",SUBTOTAL(3,$B$3:B9))","v":""}]
[{"$f":"IF($B10=\"\",\"\",SUBTOTAL(3,$B$3:B10))","v":""}]
[{"$f":"IF($B11=\"\",\"\",SUBTOTAL(3,$B$3:B11))","v":""}]
[{"$f":"IF($B12=\"\",\"\",SUBTOTAL(3,$B$3:B12))","v":""}]
[{"$f":"IF($B13=\"\",\"\",SUBTOTAL(3,$B$3:B13))","v":""}]
[{"$f":"IF($B14=\"\",\"\",SUBTOTAL(3,$B$3:B14))","v":""}]
[{"$f":"IF($B15=\"\",\"\",SUBTOTAL(3,$B$3:B15))","v":""}]
[{"$f":"IF($B16=\"\",\"\",SUBTOTAL(3,$B$3:B16))","v":""}]
[{"$f":"IF($B17=\"\",\"\",SUBTOTAL(3,$B$3:B17))","v":""}]
[{"$f":"IF($B18=\"\",\"\",SUBTOTAL(3,$B$3:B18))","v":""}]
[{"$f":"IF($B19=\"\",\"\",SUBTOTAL(3,$B$3:B19))","v":""}]
[{"$f":"IF($B20=\"\",\"\",SUBTOTAL(3,$B$3:B20))","v":""}]
[{"$f":"IF($B21=\"\",\"\",SUBTOTAL(3,$B$3:B21))","v":""}]
[{"$f":"IF($B22=\"\",\"\",SUBTOTAL(3,$B$3:B22))","v":""}]
[{"$f":"IF($B23=\"\",\"\",SUBTOTAL(3,$B$3:B23))","v":""}]
[{"$f":"IF($B24=\"\",\"\",SUBTOTAL(3,$B$3:B24))","v":""}]
[{"$f":"IF($B25=\"\",\"\",SUBTOTAL(3,$B$3:B25))","v":""}]
[{"$f":"IF($B26=\"\",\"\",SUBTOTAL(3,$B$3:B26))","v":""}]
[{"$f":"IF($B27=\"\",\"\",SUBTOTAL(3,$B$3:B27))","v":""}]
[{"$f":"IF($B28=\"\",\"\",SUBTOTAL(3,$B$3:B28))","v":""}]
[{"$f":"IF($B29=\"\",\"\",SUBTOTAL(3,$B$3:B29))","v":""}]
[{"$f":"IF($B30=\"\",\"\",SUBTOTAL(3,$B$3:B30))","v":""}]
[{"$f":"IF($B31=\"\",\"\",SUBTOTAL(3,$B$3:B31))","v":""}]
[{"$f":"IF($B32=\"\",\"\",SUBTOTAL(3,$B$3:B32))","v":""}]
[{"$f":"IF($B33=\"\",\"\",SUBTOTAL(3,$B$3:B33))","v":""}]
[{"$f":"IF($B34=\"\",\"\",SUBTOTAL(3,$B$3:B34))","v":""}]
[{"$f":"IF($B35=\"\",\"\",SUBTOTAL(3,$B$3:B35))","v":""}]
[{"$f":"IF($B36=\"\",\"\",SUBTOTAL(3,$B$3:B36))","v":""}]
[{"$f":"IF($B37=\"\",\"\",SUBTOTAL(3,$B$3:B37))","v":""}]
[{"$f":"IF($B38=\"\",\"\",SUBTOTAL(3,$B$3:B38))","v":""}]
[{"$f":"IF($B39=\"\",\"\",SUBTOTAL(3,$B$3:B39))","v":""}]
[{"$f":"IF($B40=\"\",\"\",SUBTOTAL(3,$B$3:B40))","v":""}]
[{"$f":"IF($B41=\"\",\"\",SUBTOTAL(3,$B$3:B41))","v":""}]
[{"$f":"IF($B42=\"\",\"\",SUBTOTAL(3,$B$3:B42))","v":""}]
[{"$f":"IF($B43=\"\",\"\",SUBTOTAL(3,$B$3:B43))","v":""}]
[{"$f":"IF($B44=\"\",\"\",SUBTOTAL(3,$B$3:B44))","v":""}]
[{"$f":"IF($B45=\"\",\"\",SUBTOTAL(3,$B$3:B45))","v":""}]
[{"$f":"IF($B46=\"\",\"\",SUBTOTAL(3,$B$3:B46))","v":""}]
[{"$f":"IF($B47=\"\",\"\",SUBTOTAL(3,$B$3:B47))","v":""}]
[{"$f":"IF($B48=\"\",\"\",SUBTOTAL(3,$B$3:B48))","v":""}]
[{"$f":"IF($B49=\"\",\"\",SUBTOTAL(3,$B$3:B49))","v":""}]
[{"$f":"IF($B50=\"\",\"\",SUBTOTAL(3,$B$3:B50))","v":""}]
[{"$f":"IF($B51=\"\",\"\",SUBTOTAL(3,$B$3:B51))","v":""}]
[{"$f":"IF($B52=\"\",\"\",SUBTOTAL(3,$B$3:B52))","v":""}]
[{"$f":"IF($B53=\"\",\"\",SUBTOTAL(3,$B$3:B53))","v":""}]
[{"$f":"IF($B54=\"\",\"\",SUBTOTAL(3,$B$3:B54))","v":""}]
[{"$f":"IF($B55=\"\",\"\",SUBTOTAL(3,$B$3:B55))","v":""}]
[{"$f":"IF($B56=\"\",\"\",SUBTOTAL(3,$B$3:B56))","v":""}]
[{"$f":"IF($B57=\"\",\"\",SUBTOTAL(3,$B$3:B57))","v":""}]
[{"$f":"IF($B58=\"\",\"\",SUBTOTAL(3,$B$3:B58))","v":""}]
[{"$f":"IF($B59=\"\",\"\",SUBTOTAL(3,$B$3:B59))","v":""}]
[{"$f":"IF($B60=\"\",\"\",SUBTOTAL(3,$B$3:B60))","v":""}]
[{"$f":"IF($B61=\"\",\"\",SUBTOTAL(3,$B$3:B61))","v":""}]
[{"$f":"IF($B62=\"\",\"\",SUBTOTAL(3,$B$3:B62))","v":""}]
[{"$f":"IF($B63=\"\",\"\",SUBTOTAL(3,$B$3:B63))","v":""}]
[{"$f":"IF($B64=\"\",\"\",SUBTOTAL(3,$B$3:B64))","v":""}]
[{"$f":"IF($B65=\"\",\"\",SUBTOTAL(3,$B$3:B65))","v":""}]
[{"$f":"IF($B66=\"\",\"\",SUBTOTAL(3,$B$3:B66))","v":""}]
[{"$f":"IF($B67=\"\",\"\",SUBTOTAL(3,$B$3:B67))","v":""}]
[{"$f":"IF($B68=\"\",\"\",SUBTOTAL(3,$B$3:B68))","v":""}]
[{"$f":"IF($B69=\"\",\"\",SUBTOTAL(3,$B$3:B69))","v":""}]
[{"$f":"IF($B70=\"\",\"\",SUBTOTAL(3,$B$3:B70))","v":""}]
[{"$f":"IF($B71=\"\",\"\",SUBTOTAL(3,$B$3:B71))","v":""}]
[{"$f":"IF($B72=\"\",\"\",SUBTOTAL(3,$B$3:B72))","v":""}]
[{"$f":"IF($B73=\"\",\"\",SUBTOTAL(3,$B$3:B73))","v":""}]
[{"$f":"IF($B74=\"\",\"\",SUBTOTAL(3,$B$3:B74))","v":""}]
[{"$f":"IF($B75=\"\",\"\",SUBTOTAL(3,$B$3:B75))","v":""}]
[{"$f":"IF($B76=\"\",\"\",SUBTOTAL(3,$B$3:B76))","v":""}]
[{"$f":"IF($B77=\"\",\"\",SUBTOTAL(3,$B$3:B77))","v":""}]
[{"$f":"IF($B78=\"\",\"\",SUBTOTAL(3,$B$3:B78))","v":""}]
[{"$f":"IF($B79=\"\",\"\",SUBTOTAL(3,$B$3:B79))","v":""}]
[{"$f":"IF($B80=\"\",\"\",SUBTOTAL(3,$B$3:B80))","v":""}]
[{"$f":"IF($B81=\"\",\"\",SUBTOTAL(3,$B$3:B81))","v":""}]
[{"$f":"IF($B82=\"\",\"\",SUBTOTAL(3,$B$3:B82))","v":""}]
[{"$f":"IF($B83=\"\",\"\",SUBTOTAL(3,$B$3:B83))","v":""}]
[{"$f":"IF($B84=\"\",\"\",SUBTOTAL(3,$B$3:B84))","v":""}]
[{"$f":"IF($B85=\"\",\"\",SUBTOTAL(3,$B$3:B85))","v":""}]
[{"$f":"IF($B86=\"\",\"\",SUBTOTAL(3,$B$3:B86))","v":""}]
[{"$f":"IF($B87=\"\",\"\",SUBTOTAL(3,$B$3:B87))","v":""}]
[{"$f":"IF($B88=\"\",\"\",SUBTOTAL(3,$B$3:B88))","v":""}]
[{"$f":"IF($B89=\"\",\"\",SUBTOTAL(3,$B$3:B89))","v":""}]
[{"$f":"IF($B90=\"\",\"\",SUBTOTAL(3,$B$3:B90))","v":""}]
[{"$f":"IF($B91=\"\",\"\",SUBTOTAL(3,$B$3:B91))","v":""}]
[{"$f":"IF($B92=\"\",\"\",SUBTOTAL(3,$B$3:B92))","v":""}]
[{"$f":"IF($B93=\"\",\"\",SUBTOTAL(3,$B$3:B93))","v":""}]
[{"$f":"IF($B94=\"\",\"\",SUBTOTAL(3,$B$3:B94))","v":""}]
[{"$f":"IF($B95=\"\",\"\",SUBTOTAL(3,$B$3:B95))","v":""}]
[{"$f":"IF($B96=\"\",\"\",SUBTOTAL(3,$B$3:B96))","v":""}]
[{"$f":"IF($B97=\"\",\"\",SUBTOTAL(3,$B$3:B97))","v":""}]
[{"$f":"IF($B98=\"\",\"\",SUBTOTAL(3,$B$3:B98))","v":""}]
[{"$f":"IF($B99=\"\",\"\",SUBTOTAL(3,$B$3:B99))","v":""}]
[{"$f":"IF($B100=\"\",\"\",SUBTOTAL(3,$B$3:B100))","v":""}]
[{"$f":"IF($B101=\"\",\"\",SUBTOTAL(3,$B$3:B101))","v":""}]
[{"$f":"IF($B102=\"\",\"\",SUBTOTAL(3,$B$3:B102))","v":""}]
[{"$f":"IF($B103=\"\",\"\",SUBTOTAL(3,$B$3:B103))","v":""}]
[{"$f":"IF($B104=\"\",\"\",SUBTOTAL(3,$B$3:B104))","v":""}]
[{"$f":"IF($B105=\"\",\"\",SUBTOTAL(3,$B$3:B105))","v":""}]
[{"$f":"IF($B106=\"\",\"\",SUBTOTAL(3,$B$3:B106))","v":""}]
[{"$f":"IF($B107=\"\",\"\",SUBTOTAL(3,$B$3:B107))","v":""}]
[{"$f":"IF($B108=\"\",\"\",SUBTOTAL(3,$B$3:B108))","v":""}]
[{"$f":"IF($B109=\"\",\"\",SUBTOTAL(3,$B$3:B109))","v":""}]
[{"$f":"IF($B110=\"\",\"\",SUBTOTAL(3,$B$3:B110))","v":""}]
[{"$f":"IF($B111=\"\",\"\",SUBTOTAL(3,$B$3:B111))","v":""}]
[{"$f":"IF($B112=\"\",\"\",SUBTOTAL(3,$B$3:B112))","v":""}]
[{"$f":"IF($B113=\"\",\"\",SUBTOTAL(3,$B$3:B113))","v":""}]
[{"$f":"IF($B114=\"\",\"\",SUBTOTAL(3,$B$3:B114))","v":""}]
[{"$f":"IF($B115=\"\",\"\",SUBTOTAL(3,$B$3:B115))","v":""}]
[{"$f":"IF($B116=\"\",\"\",SUBTOTAL(3,$B$3:B116))","v":""}]
[{"$f":"IF($B117=\"\",\"\",SUBTOTAL(3,$B$3:B117))","v":""}]
[{"$f":"IF($B118=\"\",\"\",SUBTOTAL(3,$B$3:B118))","v":""}]
[{"$f":"IF($B119=\"\",\"\",SUBTOTAL(3,$B$3:B119))","v":""}]
[{"$f":"IF($B120=\"\",\"\",SUBTOTAL(3,$B$3:B120))","v":""}]
[{"$f":"IF($B121=\"\",\"\",SUBTOTAL(3,$B$3:B121))","v":""}]
[{"$f":"IF($B122=\"\",\"\",SUBTOTAL(3,$B$3:B122))","v":""}]
[{"$f":"IF($B123=\"\",\"\",SUBTOTAL(3,$B$3:B123))","v":""}]
[{"$f":"IF($B124=\"\",\"\",SUBTOTAL(3,$B$3:B124))","v":""}]
[{"$f":"IF($B125=\"\",\"\",SUBTOTAL(3,$B$3:B125))","v":""}]
[{"$f":"IF($B126=\"\",\"\",SUBTOTAL(3,$B$3:B126))","v":""}]
[{"$f":"IF($B127=\"\",\"\",SUBTOTAL(3,$B$3:B127))","v":""}]
[{"$f":"IF($B128=\"\",\"\",SUBTOTAL(3,$B$3:B128))","v":""}]
[{"$f":"IF($B129=\"\",\"\",SUBTOTAL(3,$B$3:B129))","v":""}]
[{"$f":"IF($B130=\"\",\"\",SUBTOTAL(3,$B$3:B130))","v":""}]
[{"$f":"IF($B131=\"\",\"\",SUBTOTAL(3,$B$3:B131))","v":""}]
[{"$f":"IF($B132=\"\",\"\",SUBTOTAL(3,$B$3:B132))","v":""}]
[{"$f":"IF($B133=\"\",\"\",SUBTOTAL(3,$B$3:B133))","v":""}]
[{"$f":"IF($B134=\"\",\"\",SUBTOTAL(3,$B$3:B134))","v":""}]
[{"$f":"IF($B135=\"\",\"\",SUBTOTAL(3,$B$3:B135))","v":""}]
[{"$f":"IF($B136=\"\",\"\",SUBTOTAL(3,$B$3:B136))","v":""}]
[{"$f":"IF($B137=\"\",\"\",SUBTOTAL(3,$B$3:B137))","v":""}]
[{"$f":"IF($B138=\"\",\"\",SUBTOTAL(3,$B$3:B138))","v":""}]
[{"$f":"IF($B139=\"\",\"\",SUBTOTAL(3,$B$3:B139))","v":""}]
[{"$f":"IF($B140=\"\",\"\",SUBTOTAL(3,$B$3:B140))","v":""}]
[{"$f":"IF($B141=\"\",\"\",SUBTOTAL(3,$B$3:B141))","v":""}]
[{"$f":"IF($B142=\"\",\"\",SUBTOTAL(3,$B$3:B142))","v":""}]
[{"$f":"IF($B143=\"\",\"\",SUBTOTAL(3,$B$3:B143))","v":""}]
[{"$f":"IF($B144=\"\",\"\",SUBTOTAL(3,$B$3:B144))","v":""}]
[{"$f":"IF($B145=\"\",\"\",SUBTOTAL(3,$B$3:B145))","v":""}]
[{"$f":"IF($B146=\"\",\"\",SUBTOTAL(3,$B$3:B146))","v":""}]
[{"$f":"IF($B147=\"\",\"\",SUBTOTAL(3,$B$3:B147))","v":""}]
[{"$f":"IF($B148=\"\",\"\",SUBTOTAL(3,$B$3:B148))","v":""}]
[{"$f":"IF($B149=\"\",\"\",SUBTOTAL(3,$B$3:B149))","v":""}]
[{"$f":"IF($B150=\"\",\"\",SUBTOTAL(3,$B$3:B150))","v":""}]
[{"$f":"IF($B151=\"\",\"\",SUBTOTAL(3,$B$3:B151))","v":""}]
[{"$f":"IF($B152=\"\",\"\",SUBTOTAL(3,$B$3:B152))","v":""}]
[{"$f":"IF($B153=\"\",\"\",SUBTOTAL(3,$B$3:B153))","v":""}]
[{"$f":"IF($B154=\"\",\"\",SUBTOTAL(3,$B$3:B154))","v":""}]
[{"$f":"IF($B155=\"\",\"\",SUBTOTAL(3,$B$3:B155))","v":""}]
[{"$f":"IF($B156=\"\",\"\",SUBTOTAL(3,$B$3:B156))","v":""}]
[{"$f":"IF($B157=\"\",\"\",SUBTOTAL(3,$B$3:B157))","v":""}]
[{"$f":"IF($B158=\"\",\"\",SUBTOTAL(3,$B$3:B158))","v":""}]
[{"$f":"IF($B159=\"\",\"\",SUBTOTAL(3,$B$3:B159))","v":""}]
[{"$f":"IF($B160=\"\",\"\",SUBTOTAL(3,$B$3:B160))","v":""}]
[{"$f":"IF($B161=\"\",\"\",SUBTOTAL(3,$B$3:B161))","v":""}]
[{"$f":"IF($B162=\"\",\"\",SUBTOTAL(3,$B$3:B162))","v":""}]
[{"$f":"IF($B163=\"\",\"\",SUBTOTAL(3,$B$3:B163))","v":""}]
[{"$f":"IF($B164=\"\",\"\",SUBTOTAL(3,$B$3:B164))","v":""}]
[{"$f":"IF($B165=\"\",\"\",SUBTOTAL(3,$B$3:B165))","v":""}]
[{"$f":"IF($B166=\"\",\"\",SUBTOTAL(3,$B$3:B166))","v":""}]
[{"$f":"IF($B167=\"\",\"\",SUBTOTAL(3,$B$3:B167))","v":""}]
[{"$f":"IF($B168=\"\",\"\",SUBTOTAL(3,$B$3:B168))","v":""}]
[{"$f":"IF($B169=\"\",\"\",SUBTOTAL(3,$B$3:B169))","v":""}]
[{"$f":"IF($B170=\"\",\"\",SUBTOTAL(3,$B$3:B170))","v":""}]
[{"$f":"IF($B171=\"\",\"\",SUBTOTAL(3,$B$3:B171))","v":""}]
[{"$f":"IF($B172=\"\",\"\",SUBTOTAL(3,$B$3:B172))","v":""}]
[{"$f":"IF($B173=\"\",\"\",SUBTOTAL(3,$B$3:B173))","v":""}]
[{"$f":"IF($B174=\"\",\"\",SUBTOTAL(3,$B$3:B174))","v":""}]
[{"$f":"IF($B175=\"\",\"\",SUBTOTAL(3,$B$3:B175))","v":""}]
[{"$f":"IF($B176=\"\",\"\",SUBTOTAL(3,$B$3:B176))","v":""}]
[{"$f":"IF($B177=\"\",\"\",SUBTOTAL(3,$B$3:B177))","v":""}]
[{"$f":"IF($B178=\"\",\"\",SUBTOTAL(3,$B$3:B178))","v":""}]
[{"$f":"IF($B179=\"\",\"\",SUBTOTAL(3,$B$3:B179))","v":""}]
[{"$f":"IF($B180=\"\",\"\",SUBTOTAL(3,$B$3:B180))","v":""}]
[{"$f":"IF($B181=\"\",\"\",SUBTOTAL(3,$B$3:B181))","v":""}]
[{"$f":"IF($B182=\"\",\"\",SUBTOTAL(3,$B$3:B182))","v":""}]
[{"$f":"IF($B183=\"\",\"\",SUBTOTAL(3,$B$3:B183))","v":""}]
[{"$f":"IF($B184=\"\",\"\",SUBTOTAL(3,$B$3:B184))","v":""}]
[{"$f":"IF($B185=\"\",\"\",SUBTOTAL(3,$B$3:B185))","v":""}]
[{"$f":"IF($B186=\"\",\"\",SUBTOTAL(3,$B$3:B186))","v":""}]
[{"$f":"IF($B187=\"\",\"\",SUBTOTAL(3,$B$3:B187))","v":""}]
[{"$f":"IF($B188=\"\",\"\",SUBTOTAL(3,$B$3:B188))","v":""}]
[{"$f":"IF($B189=\"\",\"\",SUBTOTAL(3,$B$3:B189))","v":""}]
[{"$f":"IF($B190=\"\",\"\",SUBTOTAL(3,$B$3:B190))","v":""}]
[{"$f":"IF($B191=\"\",\"\",SUBTOTAL(3,$B$3:B191))","v":""}]
[{"$f":"IF($B192=\"\",\"\",SUBTOTAL(3,$B$3:B192))","v":""}]
[{"$f":"IF($B193=\"\",\"\",SUBTOTAL(3,$B$3:B193))","v":""}]
[{"$f":"IF($B194=\"\",\"\",SUBTOTAL(3,$B$3:B194))","v":""}]
[{"$f":"IF($B195=\"\",\"\",SUBTOTAL(3,$B$3:B195))","v":""}]
[{"$f":"IF($B196=\"\",\"\",SUBTOTAL(3,$B$3:B196))","v":""}]
[{"$f":"IF($B197=\"\",\"\",SUBTOTAL(3,$B$3:B197))","v":""}]
[{"$f":"IF($B198=\"\",\"\",SUBTOTAL(3,$B$3:B198))","v":""}]
[{"$f":"IF($B199=\"\",\"\",SUBTOTAL(3,$B$3:B199))","v":""}]
[{"$f":"IF($B200=\"\",\"\",SUBTOTAL(3,$B$3:B200))","v":""}]
[{"$f":"IF($B201=\"\",\"\",SUBTOTAL(3,$B$3:B201))","v":""}]
[{"$f":"IF($B202=\"\",\"\",SUBTOTAL(3,$B$3:B202))","v":""}]
[{"$f":"IF($B203=\"\",\"\",SUBTOTAL(3,$B$3:B203))","v":""}]
[{"$f":"IF($B204=\"\",\"\",SUBTOTAL(3,$B$3:B204))","v":""}]
[{"$f":"IF($B205=\"\",\"\",SUBTOTAL(3,$B$3:B205))","v":""}]
[{"$f":"IF($B206=\"\",\"\",SUBTOTAL(3,$B$3:B206))","v":""}]
[{"$f":"IF($B207=\"\",\"\",SUBTOTAL(3,$B$3:B207))","v":""}]
[{"$f":"IF($B208=\"\",\"\",SUBTOTAL(3,$B$3:B208))","v":""}]
[{"$f":"IF($B209=\"\",\"\",SUBTOTAL(3,$B$3:B209))","v":""}]
["Total",null,null,{"$f":"SUM(D3:D209)","v":24320},{"$f":"SUM(E3:E209)","v":180},3675,1199.5,490.5,1775.83,-328.07499999999999,27471.685000000001]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"MID(A210,6,1)","v":""}]

{"sheet":"January","index":2,"n_rows":40,"n_cols":17,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,6,0,7],[39,0,39,5]]}
[null,null,null,null,null,null,"Total",null,null,null,null,null,null,null,null,"Total L.E","Total $"]
["SER.","Supplier Name","Trip Name","From ","To","Invoice NO.","L.E","$","Transfer","Discount","Kick Back","Vat 14%","Tax Discount 3%","Grand Total","Currency Type",{"$f":"SUMIF($O:$O,\"L.E\",$N:$N)","v":1691621.9124999999},{"$f":"SUMIF($O:$O,\"$\",$N:$N)","v":4692.5}]
[{"$f":"IF($B3=\"\",\"\",SUBTOTAL(3,$B$3:B3))","v":1},"Answer Safari",null,"2022-01-01","2022-01-15",3699,5000,null,null,null,null,{"$f":"IF(OR($C3=\"National Park Fees\",$C3=\"Extra Cost\",$C3=\"Safari Fees\",$C3=\"Tips\"),0,(($G3+$H3+$I3)-($J3+$K3))*14%)","v":700.00000000000011},{"$f":"IF(OR($C3=\"National Park Fees\",$C3=\"Extra Cost\",$C3=\"Safari Fees\",$C3=\"Tips\"),0,(($G3+$H3+$I3)-($J3+$K3))*-3%)","v":-150},{"$f":"IF($B3=\"\",\"\",(($G3+$H3+$I3)-($J3+$K3))+L3+M3)","v":5550},{"$f":"IF($B3=\"\",\"\",IF($G3=\"\",$H$2,$G$2))","v":"L.E"}]
[{"$f":"IF($B4=\"\",\"\",SUBTOTAL(3,$B$3:B4))","v":2},"Fire SeaScope","Rusalka ","2022-01-01","2022-01-15",2505,5400,null,615,null,360.9,791.57400000000018,-169.62299999999999,6276.0510000000013,"L.E"]
[{"$f":"IF($B5=\"\",\"\",SUBTOTAL(3,$B$3:B5))","v":3},"Aqua Dight","Intro Diving-Snorkeling","2022-01-01","2022-01-15",4,5650,null,null,282.5,null,0,-161.02500000000001,5206.4750000000004,"L.E"]
[{"$f":"IF($B6=\"\",\"\",SUBTOTAL(3,$B$3:B6))","v":4},"Nourse Safary","Moto 3 Hours","2022-01-01","2022-01-15",280,11900,null,2305,{"$f":"1190+230.5","v":1420.5},null,{"$f":"IF(OR($C6=\"National Park Fees\",$C6=\"Extra Cost\",$C6=\"Safari Fees\",$C6=\"Tips\"),0,(($G6+$H6+$I6)-($J6+$K6))*14%)","v":1789.8300000000002},-383.53499999999997,14190.795,"L.E"]
[{"$f":"IF($B7=\"\",\"\",SUBTOTAL(3,$B$3:B7))","v":5},"Nourse Safary","Moto 5 Hours","2022-01-01","2022-01-15",281,16065,null,2225,{"$f":"222.5+1606.5","v":1829},null,2304.5400000000004,-493.83,18271.71,"L.E"]
[{"$f":"IF($B8=\"\",\"\",SUBTOTAL(3,$B$3:B8))","v":6},"Nourse Safary","Super Safari","2022-01-01","2022-01-15",278,131950,null,null,13195,null,16625.7,-3562.65,131818.05000000002,"L.E"]
[{"$f":"IF($B9=\"\",\"\",SUBTOTAL(3,$B$3:B9))","v":7},"Nourse Safary","Mega Safari","2022-01-01","2022-01-15",279,21375,null,null,2137.5,null,2693.2500000000005,-577.125,21353.625,"L.E"]
[{"$f":"IF($B10=\"\",\"\",SUBTOTAL(3,$B$3:B10))","v":8},"Nourse Safary","Safari Fees","2022-01-01","2022-01-15",1004,13100,null,null,null,null,0,0,13100,"L.E"]
[{"$f":"IF($B11=\"\",\"\",SUBTOTAL(3,$B$3:B11))","v":9},"Luba Center","Super Scuba","2022-01-01","2022-01-15",33,198660,null,475,{"$f":"47.5+19866","v":19913.5},null,25091.010000000002,-5376.6449999999995,198935.86500000002,"L.E"]
[{"$f":"IF($B12=\"\",\"\",SUBTOTAL(3,$B$3:B12))","v":10},"Luba Center","National Park Fees","2022-01-01","2022-01-15",33,null,2840,null,null,null,0,0,2840,"$"]
[{"$f":"IF($B13=\"\",\"\",SUBTOTAL(3,$B$3:B13))","v":11},"Luba Center","Private Boat Fishing","2022-01-01","2022-01-15",34,25880,null,null,2588,null,3260.88,-698.76,25854.120000000003,"L.E"]
[{"$f":"IF($B14=\"\",\"\",SUBTOTAL(3,$B$3:B14))","v":12},"Luba Center","National Park Fees","2022-01-01","2022-01-15",34,null,190,null,null,null,0,0,190,"$"]
[{"$f":"IF($B15=\"\",\"\",SUBTOTAL(3,$B$3:B15))","v":13},"Luba Center","Extra Cost","2022-01-01","2022-01-15",12,1320,null,null,null,null,0,0,1320,"L.E"]
[{"$f":"IF($B16=\"\",\"\",SUBTOTAL(3,$B$3:B16))","v":14},"Lottery Diving Club","Intro Diving-Snorkeling","2022-01-01","2022-01-15",19,25430,null,170,{"$f":"17+2543","v":2560},null,3225.6000000000004,{"$f":"IF(OR($C16=\"National Park Fees\",$C16=\"Extra Cost\",$C16=\"Safari Fees\",$C16=\"Tips\"),0,(($G16+$H16+$I16)-($J16+$K16))*-3%)","v":-691.19999999999993},25574.399999999998,"L.E"]
[{"$f":"IF($B17=\"\",\"\",SUBTOTAL(3,$B$3:B17))","v":15},"Follow Aqua Boda","Snorkeling (Coral Reef)","2022-01-01","2022-01-15",34,3610,null,1400,{"$f":"140+361","v":501},null,0,-135.26999999999998,4373.7299999999996,"L.E"]
[{"$f":"IF($B18=\"\",\"\",SUBTOTAL(3,$B$3:B18))","v":16},"Follow Aqua Boda","National Park Fees","2022-01-01","2022-01-15","34 F",null,100,null,null,null,0,0,100,"$"]
[{"$f":"IF($B19=\"\",\"\",SUBTOTAL(3,$B$3:B19))","v":17},"Memo Travel Company","Transfer (Excursion)","2022-01-01","2022-01-15",23224,376455,null,null,37645.5,null,{"$f":"IF(OR($C19=\"National Park Fees\",$C19=\"Extra Cost\",$C19=\"Safari Fees\",$C19=\"Tips\"),0,(($G19+$H19+$I19)-($J19+$K19))*14%)","v":47433.33},-10164.285,376078.54500000004,"L.E"]
[{"$f":"IF($B20=\"\",\"\",SUBTOTAL(3,$B$3:B20))","v":18},"Memo Travel Company","Tips","2022-01-01","2022-01-15",23224,37160,null,null,null,null,0,0,37160,"L.E"]
[{"$f":"IF($B21=\"\",\"\",SUBTOTAL(3,$B$3:B21))","v":19},"Memo Travel Company","Transfer (AirPort)","2022-01-01","2022-01-15",23225,275340,null,null,27534,null,34692.840000000004,-7434.1799999999994,275064.66000000003,"L.E"]
[{"$f":"IF($B22=\"\",\"\",SUBTOTAL(3,$B$3:B22))","v":20},"Memo Travel Company","Tips","2022-01-01","2022-01-15",23225,29540,null,null,null,null,0,0,29540,"L.E"]
[{"$f":"IF($B23=\"\",\"\",SUBTOTAL(3,$B$3:B23))","v":21},"Fire SeaScope","Rusalka ","2022-01-16","2022-01-31",2438,720,null,240,null,{"$f":"14.4+43.2","v":57.6},126.33600000000001,{"$f":"IF(OR($C23=\"National Park Fees\",$C23=\"Extra Cost\",$C23=\"Safari Fees\",$C23=\"Tips\"),0,(($G23+$H23+$I23)-($J23+$K23))*-3%)","v":-27.071999999999999},1001.6639999999999,"L.E"]
[{"$f":"IF($B24=\"\",\"\",SUBTOTAL(3,$B$3:B24))","v":22},"Luba Center","Super Scuba","2022-01-16","2022-01-31",35,108762.5,null,135,{"$f":"13.5+10876.25","v":10889.75},null,{"$f":"IF(OR($C24=\"National Park Fees\",$C24=\"Extra Cost\",$C24=\"Safari Fees\",$C24=\"Tips\"),0,(($G24+$H24+$I24)-($J24+$K24))*14%)","v":13721.085000000001},-2940.2325000000001,{"$f":"IF($B24=\"\",\"\",(($G24+$H24+$I24)-($J24+$K24))+L24+M24)","v":108788.60250000001},{"$f":"IF($B24=\"\",\"\",IF($G24=\"\",$H$2,$G$2))","v":"L.E"}]
[{"$f":"IF($B25=\"\",\"\",SUBTOTAL(3,$B$3:B25))","v":23},"Luba Center","National Park Fees","2022-01-16","2022-01-31",35,null,1562.5,null,null,null,0,0,1562.5,"$"]
[{"$f":"IF($B26=\"\",\"\",SUBTOTAL(3,$B$3:B26))","v":24},"Luba Center","Extra Cost","2022-01-16","2022-01-31",13,990,null,null,null,null,0,0,990,"L.E"]
[{"$f":"IF($B27=\"\",\"\",SUBTOTAL(3,$B$3:B27))","v":25},"Lottery Diving Club","Intro Diving-Snorkeling","2022-01-16","2022-01-31",20,4815,null,850,{"$f":"85+481.5","v":566.5},null,713.79000000000008,-152.95499999999998,5659.335,"L.E"]
[{"$f":"IF($B28=\"\",\"\",SUBTOTAL(3,$B$3:B28))","v":26},"Nourse Safary","Moto 5 Hours","2022-01-16","2022-01-31",286,9990,null,1330,{"$f":"133+999","v":1132},null,1426.3200000000002,-305.64,11308.68,"L.E"]
[{"$f":"IF($B29=\"\",\"\",SUBTOTAL(3,$B$3:B29))","v":27},"Nourse Safary","Individual Moto 3","2022-01-16","2022-01-31",285,800,null,300,110,null,138.60000000000002,-29.7,1098.8999999999999,"L.E"]
[{"$f":"IF($B30=\"\",\"\",SUBTOTAL(3,$B$3:B30))","v":28},"Nourse Safary","Moto 3 Hours","2022-01-16","2022-01-31",284,11000,null,1980,{"$f":"198+1100","v":1298},null,1635.4800000000002,-350.46,12967.02,"L.E"]
[{"$f":"IF($B31=\"\",\"\",SUBTOTAL(3,$B$3:B31))","v":29},"Nourse Safary","Mega Safari","2022-01-16","2022-01-31",283,3250,null,null,325,null,409.50000000000006,-87.75,3246.75,"L.E"]
[{"$f":"IF($B32=\"\",\"\",SUBTOTAL(3,$B$3:B32))","v":30},"Nourse Safary","Super Safari","2022-01-16","2022-01-31",282,28350,null,null,2835,null,3572.1000000000004,-765.44999999999993,28321.649999999998,"L.E"]
[{"$f":"IF($B33=\"\",\"\",SUBTOTAL(3,$B$3:B33))","v":31},"Nourse Safary","Safari Fees","2022-01-16","2022-01-31",1005,4080,null,null,null,null,0,0,4080,"L.E"]
[{"$f":"IF($B34=\"\",\"\",SUBTOTAL(3,$B$3:B34))","v":32},"Memo Travel Company","Transfer (AirPort)","2022-01-16","2022-01-31",23230,140830,null,null,14083,null,{"$f":"IF(OR($C34=\"National Park Fees\",$C34=\"Extra Cost\",$C34=\"Safari Fees\",$C34=\"Tips\"),0,(($G34+$H34+$I34)-($J34+$K34))*14%)","v":17744.580000000002},-3802.41,140689.17000000001,"L.E"]
[{"$f":"IF($B35=\"\",\"\",SUBTOTAL(3,$B$3:B35))","v":33},"Memo Travel Company","Tips","2022-01-16","2022-01-31",23230,15655,null,null,null,null,0,0,15655,"L.E"]
[{"$f":"IF($B36=\"\",\"\",SUBTOTAL(3,$B$3:B36))","v":34},"Memo Travel Company","Flight Crew","2022-01-16","2022-01-31",23232,6545,null,null,654.5,null,824.67000000000007,-176.715,6538.4549999999999,"L.E"]
[{"$f":"IF($B37=\"\",\"\",SUBTOTAL(3,$B$3:B37))","v":35},"Memo Travel Company","Tips","2022-01-16","2022-01-31",23232,1040,null,null,null,null,0,0,1040,"L.E"]
[{"$f":"IF($B38=\"\",\"\",SUBTOTAL(3,$B$3:B38))","v":36},"Memo Travel Company","Transfer (Excursion)","2022-01-16","2022-01-31",23231,146340,null,null,14634,null,18438.84,-3951.18,146193.66,"L.E"]
[{"$f":"IF($B39=\"\",\"\",SUBTOTAL(3,$B$3:B39))","v":37},"Memo Travel Company","Tips","2022-01-16","2022-01-31",23231,14375,null,null,null,null,0,0,14375,"L.E"]
["Total",null,null,null,null,null,{"$f":"SUM(G3:G39)","v":1681377.5},4692.5,12025,156134.25,418.5,197359.85500000004,-42587.692499999997,1696314.4124999999]

{"sheet":"February","index":3,"n_rows":40,"n_cols":17,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,6,0,7],[39,0,39,5]]}
[null,null,null,null,null,null,"Total",null,null,null,null,null,null,null,null,"Total L.E","Total $"]
["SER.","Supplier Name","Trip Name","From ","To","Invoice NO.","L.E","$","Transfer","Discount","Kick Back","Vat 14%","Tax Discount 3%","Grand Total","Currency Type",{"$f":"SUMIF($O:$O,\"L.E\",$N:$N)","v":1142507.0474999999},{"$f":"SUMIF($O:$O,\"$\",$N:$N)","v":4710}]
[{"$f":"IF($B3=\"\",\"\",SUBTOTAL(3,$B$3:B3))","v":1},"Luba Center","Super Scuba","2022-02-01","2022-02-15",36,128590,null,860,{"$f":"12859+86","v":12945},null,{"$f":"IF(OR($C3=\"National Park Fees\",$C3=\"Extra Cost\",$C3=\"Safari Fees\",$C3=\"Tips\"),0,(($G3+$H3+$I3)-($J3+$K3))*14%)","v":16310.7},{"$f":"IF(OR($C3=\"National Park Fees\",$C3=\"Extra Cost\",$C3=\"Safari Fees\",$C3=\"Tips\"),0,(($G3+$H3+$I3)-($J3+$K3))*-3%)","v":-3495.15},{"$f":"IF($B3=\"\",\"\",(($G3+$H3+$I3)-($J3+$K3))+L3+M3)","v":129320.55000000002},{"$f":"IF($B3=\"\",\"\",IF($G3=\"\",$H$2,$G$2))","v":"L.E"}]
[{"$f":"IF($B4=\"\",\"\",SUBTOTAL(3,$B$3:B4))","v":2},"Luba Center","National Park Fees","2022-02-01","2022-02-15",36,null,1840,null,null,null,0,0,1840,"$"]
[{"$f":"IF($B5=\"\",\"\",SUBTOTAL(3,$B$3:B5))","v":3},"Luba Center","Extra Cost","2022-02-01","2022-02-15",14,660,null,null,null,null,0,0,660,"L.E"]
[{"$f":"IF($B6=\"\",\"\",SUBTOTAL(3,$B$3:B6))","v":4},"Panorama Kabeer","Rusalka ","2022-02-01","2022-02-15",244,1050,null,245,null,null,181.3,-38.85,1437.45,"L.E"]
[{"$f":"IF($B7=\"\",\"\",SUBTOTAL(3,$B$3:B7))","v":5},"Follow Aqua Boda","Snorkeling (Coral Reef)","2022-02-01","2022-02-15",35,760,null,280,{"$f":"28+76","v":104},null,0,-28.08,907.92,"L.E"]
[{"$f":"IF($B8=\"\",\"\",SUBTOTAL(3,$B$3:B8))","v":6},"Follow Aqua Boda","National Park Fees","2022-02-01","2022-02-15","35 F",null,20,null,null,null,0,0,20,"$"]
[{"$f":"IF($B9=\"\",\"\",SUBTOTAL(3,$B$3:B9))","v":7},"Nourse Safary","Super Safari","2022-02-01","2022-02-15",294,29925,null,null,2992.5,null,3770.55,-807.97500000000002,29895.075000000001,"L.E"]
[{"$f":"IF($B10=\"\",\"\",SUBTOTAL(3,$B$3:B10))","v":8},"Nourse Safary","Mega Safari","2022-02-01","2022-02-15",295,7250,null,null,725,null,913.50000000000011,-195.75,7242.75,"L.E"]
[{"$f":"IF($B11=\"\",\"\",SUBTOTAL(3,$B$3:B11))","v":9},"Nourse Safary","Moto 3 Hours","2022-02-01","2022-02-15",296,8900,null,1425,{"$f":"142.5+890","v":1032.5},null,1300.95,-278.77499999999998,10314.675000000001,"L.E"]
[{"$f":"IF($B12=\"\",\"\",SUBTOTAL(3,$B$3:B12))","v":10},"Nourse Safary","Individual Moto 3","2022-02-01","2022-02-15",297,1500,null,600,{"$f":"150+60","v":210},null,264.60000000000002,-56.699999999999996,2097.9,"L.E"]
[{"$f":"IF($B13=\"\",\"\",SUBTOTAL(3,$B$3:B13))","v":11},"Nourse Safary","Moto 5 Hours","2022-02-01","2022-02-15",298,9180,null,1200,{"$f":"918+120","v":1038},null,1307.8800000000001,-280.26,10369.620000000001,"L.E"]
[{"$f":"IF($B14=\"\",\"\",SUBTOTAL(3,$B$3:B14))","v":12},"Nourse Safary","Safari Fees","2022-02-01","2022-02-15",1006,4340,null,null,null,null,0,0,4340,"L.E"]
[{"$f":"IF($B15=\"\",\"\",SUBTOTAL(3,$B$3:B15))","v":13},"Memo Travel Company","Transfer (Excursion)","2022-02-01","2022-02-15",23237,113785,null,null,11378.5,null,14336.910000000002,-3072.1949999999997,113671.215,"L.E"]
[{"$f":"IF($B16=\"\",\"\",SUBTOTAL(3,$B$3:B16))","v":14},"Memo Travel Company","Tips","2022-02-01","2022-02-15",23237,11540,null,null,null,null,0,0,11540,"L.E"]
[{"$f":"IF($B17=\"\",\"\",SUBTOTAL(3,$B$3:B17))","v":15},"Memo Travel Company","Transfer (AirPort)","2022-02-01","2022-02-15",23236,109955,null,null,10995.5,null,13854.330000000002,-2968.7849999999999,109845.045,"L.E"]
[{"$f":"IF($B18=\"\",\"\",SUBTOTAL(3,$B$3:B18))","v":16},"Memo Travel Company","Tips","2022-02-01","2022-02-15",23236,12655,null,null,null,null,0,0,12655,"L.E"]
[{"$f":"IF($B19=\"\",\"\",SUBTOTAL(3,$B$3:B19))","v":17},"Lottery Diving Club","Intro Diving-Snorkeling","2022-02-01","2022-02-15",21,3555,null,340,{"$f":"34+355.5","v":389.5},null,490.77000000000004,-105.16499999999999,3891.105,"L.E"]
[{"$f":"IF($B20=\"\",\"\",SUBTOTAL(3,$B$3:B20))","v":18},"Lottery Diving Club","Extra Cost","2022-02-01","2022-02-15",1,300,null,null,null,null,0,0,300,"L.E"]
[{"$f":"IF($B21=\"\",\"\",SUBTOTAL(3,$B$3:B21))","v":19},"Fire SeaScope","Rusalka ","2022-02-16","2022-02-28",2450,450,null,150,null,36,78.960000000000008,-16.919999999999998,626.04000000000008,"L.E"]
[{"$f":"IF($B22=\"\",\"\",SUBTOTAL(3,$B$3:B22))","v":20},"Lottery Diving Club","Intro Diving-Snorkeling","2022-02-16","2022-02-28",22,12972.5,null,1445,{"$f":"144.5+1297.25","v":1441.75},null,1816.6050000000002,-389.27249999999998,14403.0825,"L.E"]
[{"$f":"IF($B23=\"\",\"\",SUBTOTAL(3,$B$3:B23))","v":21},"Follow Aqua Boda","Snorkeling (Coral Reef)","2022-02-16","2022-02-28",36,1520,null,560,{"$f":"56+152","v":208},null,0,-56.16,1815.84,"L.E"]
[{"$f":"IF($B24=\"\",\"\",SUBTOTAL(3,$B$3:B24))","v":22},"Follow Aqua Boda","National Park Fees","2022-02-16","2022-02-28","36 F",null,40,null,null,null,0,0,40,"$"]
[{"$f":"IF($B25=\"\",\"\",SUBTOTAL(3,$B$3:B25))","v":23},"Panorama Kabeer","Rusalka ","2022-02-16","2022-02-28",260,1600,null,1120,null,null,380.8,-81.599999999999994,3019.2000000000003,"L.E"]
[{"$f":"IF($B26=\"\",\"\",SUBTOTAL(3,$B$3:B26))","v":24},"Nourse Safary","Super Safari","2022-02-16","2022-02-28",301,52675,null,null,5267.5,null,6637.05,-1422.2249999999999,52622.325000000004,"L.E"]
[{"$f":"IF($B27=\"\",\"\",SUBTOTAL(3,$B$3:B27))","v":25},"Nourse Safary","Mega Safari","2022-02-16","2022-02-28",302,17750,null,null,1775,null,2236.5,-479.25,17732.25,"L.E"]
[{"$f":"IF($B28=\"\",\"\",SUBTOTAL(3,$B$3:B28))","v":26},"Nourse Safary","Moto 3 Hours","2022-02-16","2022-02-28",303,6900,null,1295,{"$f":"690+129.5","v":819.5},null,1032.5700000000002,-221.26499999999999,8186.8049999999994,"L.E"]
[{"$f":"IF($B29=\"\",\"\",SUBTOTAL(3,$B$3:B29))","v":27},"Nourse Safary","Moto 5 Hours","2022-02-16","2022-02-28",304,8100,null,960,{"$f":"810+96","v":906},null,1141.5600000000002,-244.62,9050.9399999999987,"L.E"]
[{"$f":"IF($B30=\"\",\"\",SUBTOTAL(3,$B$3:B30))","v":28},"Nourse Safary","Safari Fees","2022-02-16","2022-02-28",1007,6440,null,null,null,null,0,0,6440,"L.E"]
[{"$f":"IF($B31=\"\",\"\",SUBTOTAL(3,$B$3:B31))","v":29},"Luba Center","Super Scuba","2022-02-16","2022-02-28",37,196735,null,215,{"$f":"21.5+19673.5","v":19695},null,{"$f":"IF(OR($C31=\"National Park Fees\",$C31=\"Extra Cost\",$C31=\"Safari Fees\",$C31=\"Tips\"),0,(($G31+$H31+$I31)-($J31+$K31))*14%)","v":24815.7},{"$f":"IF(OR($C31=\"National Park Fees\",$C31=\"Extra Cost\",$C31=\"Safari Fees\",$C31=\"Tips\"),0,(($G31+$H31+$I31)-($J31+$K31))*-3%)","v":-5317.65},{"$f":"IF($B31=\"\",\"\",(($G31+$H31+$I31)-($J31+$K31))+L31+M31)","v":196753.05000000002},{"$f":"IF($B31=\"\",\"\",IF($G31=\"\",$H$2,$G$2))","v":"L.E"}]
[{"$f":"IF($B32=\"\",\"\",SUBTOTAL(3,$B$3:B32))","v":30},"Luba Center","National Park Fees","2022-02-16","2022-02-28",37,null,2810,null,null,null,0,0,2810,"$"]
[{"$f":"IF($B33=\"\",\"\",SUBTOTAL(3,$B$3:B33))","v":31},"Luba Center","Extra Cost","2022-02-16","2022-02-28",15,2000,null,null,null,null,0,0,2000,"L.E"]
[{"$f":"IF($B34=\"\",\"\",SUBTOTAL(3,$B$3:B34))","v":32},"Memo Travel Company","Transfer (Excursion)","2022-02-16","2022-02-28",23248,179210,null,null,17921,null,22580.460000000003,-4838.67,179030.78999999998,"L.E"]
[{"$f":"IF($B35=\"\",\"\",SUBTOTAL(3,$B$3:B35))","v":33},"Memo Travel Company","Tips","2022-02-16","2022-02-28",23248,18010,null,null,null,null,0,0,18010,"L.E"]
[{"$f":"IF($B36=\"\",\"\",SUBTOTAL(3,$B$3:B36))","v":34},"Memo Travel Company","Flight Crew","2022-02-16","2022-02-28",23252,3770,null,null,377,null,475.02000000000004,-101.78999999999999,3766.23,"L.E"]
[{"$f":"IF($B37=\"\",\"\",SUBTOTAL(3,$B$3:B37))","v":35},"Memo Travel Company","Tips","2022-02-16","2022-02-28",23252,685,null,null,null,null,0,0,685,"L.E"]
[{"$f":"IF($B38=\"\",\"\",SUBTOTAL(3,$B$3:B38))","v":36},"Memo Travel Company","Transfer (AirPort)","2022-02-16","2022-02-28",23247,162810,null,null,16281,null,20514.060000000001,-4395.87,162647.19,"L.E"]
[{"$f":"IF($B39=\"\",\"\",SUBTOTAL(3,$B$3:B39))","v":37},"Memo Travel Company","Tips","2022-02-16","2022-02-28",23247,17230,null,null,null,null,0,0,17230,"L.E"]
["Total",null,null,null,null,null,{"$f":"SUM(G3:G39)","v":1132802.5},4710,10695,106502.25,36,134440.77500000002,-28892.977499999997,1147217.0474999999]

{"sheet":"March","index":4,"n_rows":22,"n_cols":17,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,6,0,7],[21,0,21,5]]}
[null,null,null,null,null,null,"Total",null,null,null,null,null,null,null,null,"Total L.E","Total $"]
["SER.","Supplier Name","Trip Name","From ","To","Invoice NO.","L.E","$","Transfer","Discount","Kick Back","Vat 14%","Tax Discount 3%","Grand Total","Currency Type",{"$f":"SUMIF($O:$O,\"L.E\",$N:$N)","v":312218.21500000003},{"$f":"SUMIF($O:$O,\"$\",$N:$N)","v":1175}]
[{"$f":"IF($B3=\"\",\"\",SUBTOTAL(3,$B$3:B3))","v":1},"Lottery Diving Club","Intro Diving-Diving","2022-03-01","2022-03-15",23,3520,null,340,{"$f":"34+352","v":386},null,{"$f":"IF(OR($C3=\"National Park Fees\",$C3=\"Extra Cost\",$C3=\"Safari Fees\",$C3=\"Tips\"),0,(($G3+$H3+$I3)-($J3+$K3))*14%)","v":486.36000000000007},{"$f":"IF(OR($C3=\"National Park Fees\",$C3=\"Extra Cost\",$C3=\"Safari Fees\",$C3=\"Tips\"),0,(($G3+$H3+$I3)-($J3+$K3))*-3%)","v":-104.22},{"$f":"IF($B3=\"\",\"\",(($G3+$H3+$I3)-($J3+$K3))+L3+M3)","v":3856.1400000000003},{"$f":"IF($B3=\"\",\"\",IF($G3=\"\",$H$2,$G$2))","v":"L.E"}]
[{"$f":"IF($B4=\"\",\"\",SUBTOTAL(3,$B$3:B4))","v":2},"Panorama Kabeer","Rusalka ","2022-03-01","2022-03-15",264,500,null,350,null,null,119.00000000000001,-25.5,943.5,"L.E"]
[{"$f":"IF($B5=\"\",\"\",SUBTOTAL(3,$B$3:B5))","v":3},"Fire SeaScope","Rusalka ","2022-03-01","2022-03-15",2459,450,null,150,null,{"$f":"9+27","v":36},78.960000000000008,-16.919999999999998,626.04000000000008,"L.E"]
[{"$f":"IF($B6=\"\",\"\",SUBTOTAL(3,$B$3:B6))","v":4},"Luba Center","Super Scuba","2022-03-01","2022-03-15",38,80850,null,null,8085,null,10187.1,-2182.9499999999998,{"$f":"IF($B6=\"\",\"\",(($G6+$H6+$I6)-($J6+$K6))+L6+M6)","v":80769.150000000009},"L.E"]
[{"$f":"IF($B7=\"\",\"\",SUBTOTAL(3,$B$3:B7))","v":5},"Luba Center","National Park Fees","2022-03-01","2022-03-15",38,null,1155,null,null,null,0,0,1155,"$"]
[{"$f":"IF($B8=\"\",\"\",SUBTOTAL(3,$B$3:B8))","v":6},"Luba Center","Extra Cost","2022-03-01","2022-03-15",38,800,null,null,null,null,0,0,800,"L.E"]
[{"$f":"IF($B9=\"\",\"\",SUBTOTAL(3,$B$3:B9))","v":7},"Nourse Safary","Super Safari","2022-03-01","2022-03-15",313,19425,null,null,1942.5,null,2447.5500000000002,-524.47500000000002,19405.575000000001,"L.E"]
[{"$f":"IF($B10=\"\",\"\",SUBTOTAL(3,$B$3:B10))","v":8},"Nourse Safary","Moto 3 Hours","2022-03-01","2022-03-15",315,5000,null,980,598,null,753.48,-161.46,5974.0199999999995,"L.E"]
[{"$f":"IF($B11=\"\",\"\",SUBTOTAL(3,$B$3:B11))","v":9},"Nourse Safary","Mega Safari","2022-03-01","2022-03-15",314,5875,null,null,587.5,null,740.25000000000011,-158.625,5869.125,"L.E"]
[{"$f":"IF($B12=\"\",\"\",SUBTOTAL(3,$B$3:B12))","v":10},"Nourse Safary","Moto 5 Hours","2022-03-01","2022-03-15",316,1080,null,120,{"$f":"12+108","v":120},null,151.20000000000002,-32.4,1198.8,"L.E"]
[{"$f":"IF($B13=\"\",\"\",SUBTOTAL(3,$B$3:B13))","v":11},"Nourse Safary","Safari Fees","2022-03-01","2022-03-15",1008,2360,null,null,null,null,0,0,2360,"L.E"]
[{"$f":"IF($B14=\"\",\"\",SUBTOTAL(3,$B$3:B14))","v":12},"Follow Aqua Boda","Snorkeling (Coral Reef)","2022-03-01","2022-03-15",37,760,null,280,{"$f":"28+76","v":104},null,null,-28.08,907.92,"L.E"]
[{"$f":"IF($B15=\"\",\"\",SUBTOTAL(3,$B$3:B15))","v":13},"Follow Aqua Boda","National Park Fees","2022-03-01","2022-03-15","37 F",null,20,null,null,null,0,0,20,"$"]
[{"$f":"IF($B16=\"\",\"\",SUBTOTAL(3,$B$3:B16))","v":14},"Memo Travel Company","Transfer (AirPort)","2022-03-01","2022-03-15",23256,93875,null,null,9387.5,null,11828.250000000002,-2534.625,93781.125,"L.E"]
[{"$f":"IF($B17=\"\",\"\",SUBTOTAL(3,$B$3:B17))","v":15},"Memo Travel Company","Tips","2022-03-01","2022-03-15",23256,9750,null,null,null,null,0,0,9750,"L.E"]
[{"$f":"IF($B18=\"\",\"\",SUBTOTAL(3,$B$3:B18))","v":16},"Memo Travel Company","Transfer (Excursion)","2022-03-01","2022-03-15",23257,75090,null,null,7509,null,9461.34,-2027.4299999999998,75014.91,"L.E"]
[{"$f":"IF($B19=\"\",\"\",SUBTOTAL(3,$B$3:B19))","v":17},"Memo Travel Company","Tips","2022-03-01","2022-03-15",23257,7430,null,null,null,null,0,0,7430,"L.E"]
[{"$f":"IF($B20=\"\",\"\",SUBTOTAL(3,$B$3:B20))","v":18},"Memo Travel Company","Flight Crew","2022-03-01","2022-03-15",23255,3090,null,null,309,null,389.34000000000003,-83.429999999999993,3086.9100000000003,"L.E"]
[{"$f":"IF($B21=\"\",\"\",SUBTOTAL(3,$B$3:B21))","v":19},"Memo Travel Company","Tips","2022-03-01","2022-03-15",23255,445,null,null,null,null,0,0,445,"L.E"]
["Total",null,null,null,null,null,{"$f":"SUM(G3:G21)","v":310300},{"$f":"SUM(H3:H21)","v":1175},2220,29028.5,36,36642.83,-7880.1149999999998,313393.21500000003]