{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Sheet1","Setting"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Sheet1","index":0,"n_rows":129,"n_cols":11,"rows_kept":129,"cut":false,"hidden":false,"merged":[[4,10,12,18]]}
["Adl","Chd","Baby","Tour Name","Trans Region Name","Transfer"]
[1,1,0,"Utopia Island","Sahl Hasheesh",4.88]
[1,0,0,"City Tour With Aquarium","Safaga",8]
[2,0,0,"City Tour With Aquarium","Hurghada",6.5]
[1,0,0,"City Tour With Aquarium","Hurghada",3.25,null,null,null,null,"أريد اختصار هذه المعادلة الى معادلة قصيرة وتقوم بنفس \nالمهام فهذه المعادلة طويلة بعض الشيء\nومهمتها هو جلب قيمة النقل لكل رحلة على مستوى \nالمناطق المختلفة\nوذلك من صفحة Setting بناءا على اسم الرحلة ومنطقة التنفيذ"]
[2,0,0,"City Tour With Aquarium","Sahl Hasheesh",6.5]
[3,0,0,"City Tour With Aquarium","Hurghada",9.75]
[4,0,0,"City Tour With Aquarium","Hurghada",13]
[2,0,0,"City Tour With Aquarium","Makadi",10]
[1,1,0,"City Tour With Aquarium","Makadi",7.5]
[2,0,0,"City Tour With Aquarium","Hurghada",6.5]
[2,0,0,"City Tour With Aquarium","Hurghada",6.5]
[2,0,0,"City Tour With Aquarium","Hurghada",6.5]
[2,1,0,"City Tour With Aquarium","Hurghada",8.129999999999999]
[2,0,0,"City Tour With Aquarium","Makadi",10]
[2,0,0,"City Tour With Aquarium","Hurghada",6.5]
[2,0,0,"City Tour With Aquarium","Soma Bay",16]
[2,1,0,"City Tour With Aquarium","Hurghada",8.129999999999999]
[2,0,0,"City Tour With Aquarium","Hurghada",6.5]
[2,0,0,"City Tour With Aquarium","Hurghada",6.5]
[3,0,0,"City Tour With Aquarium","Hurghada",9.75]
[2,0,0,"City Tour With Aquarium","Hurghada",6.5]
[2,0,0,"City Tour With Aquarium","Hurghada",6.5]
[2,0,0,"City Tour With Aquarium","Hurghada",6.5]
[2,0,0,"City Tour With Aquarium","Hurghada",6.5]
[2,0,0,"Dolphin House","Hurghada",6.5]
[1,1,0,"Empier Scope","Hurghada",4.88]
[2,1,0,"Grand Aquarium","Hurghada",8.129999999999999]
[2,0,0,"Grand Aquarium","Hurghada",6.5]
[3,0,0,"Intro Diving","Sahl Hasheesh",0]
[2,0,0,"Intro Diving","Safaga",0]
[0,2,0,"Intro Diving","Safaga",0]
[2,0,0,"Intro Diving","Hurghada",0]
[1,0,0,"Intro Diving","Hurghada",0]
[3,0,0,"Intro Diving","Hurghada",0]
[2,0,0,"Intro Diving","Hurghada",0]
[2,0,0,"Moto 3 Hours","Sahl Hasheesh",6.5]
[2,0,0,"Moto 3 Hours","Hurghada",6.5]
[2,0,0,"Moto 3 Hours","Hurghada",6.5]
[3,1,1,"Moto 3 Hours","Hurghada",11.379999999999999]
[2,0,0,"Moto 3 Hours","Hurghada",6.5]
[2,0,0,"Moto 3 Hours","Hurghada",6.5]
[2,0,0,"Moto 3 Hours","Hurghada",6.5]
[1,0,0,"Moto 3 Hours","Hurghada",3.25]
[2,0,0,"Moto 3 Hours","Hurghada",6.5]
[1,0,0,"Moto 3 Hours","Hurghada",3.25]
[3,0,0,"Moto 3 Hours","Hurghada",9.75]
[2,1,0,"Over Day LuxorQueen Vally","Sahl Hasheesh",8.129999999999999]
[1,0,0,"Over Day LuxorQueen Vally","Sahl Hasheesh",3.25]
[2,1,0,"Over Day LuxorQueen Vally","Sahl Hasheesh",8.129999999999999]
[2,0,0,"Over Day LuxorQueen Vally","Makadi",10]
[1,1,0,"Over Day LuxorQueen Vally","Makadi",7.5]
[4,0,0,"Over Day LuxorQueen Vally","Makadi",20]
[2,2,0,"Over Day LuxorQueen Vally","Sahl Hasheesh",9.76]
[2,0,0,"Over Day LuxorQueen Vally","Sahl Hasheesh",6.5]
[1,0,0,"Over Day LuxorQueen Vally","Soma Bay",8]
[2,0,0,"Over Day LuxorQueen Vally","Soma Bay",16]
[2,0,0,"Over Day LuxorQueen Vally","Hurghada",6.5]
[2,0,1,"Over Day LuxorQueen Vally","Hurghada",6.5]
[2,0,0,"Over Day LuxorQueen Vally","Hurghada",6.5]
[6,1,0,"Over Day LuxorQueen Vally","Hurghada",21.13]
[2,0,0,"Over Day LuxorQueen Vally","Hurghada",6.5]
[1,1,0,"Rusalka (Mermaid)","Hurghada",4.88]
[2,1,0,"Rusalka (Mermaid)","Hurghada",8.129999999999999]
[2,0,0,"Rusalka (Mermaid)","Hurghada",6.5]
[3,1,0,"Rusalka (Mermaid)","Makadi",17.5]
[4,0,1,"Rusalka (Mermaid)","Hurghada",13]
[2,0,0,"Rusalka (Mermaid)","Hurghada",6.5]
[1,0,2,"Rusalka (Mermaid)","Hurghada",3.25]
[1,1,0,"Rusalka (Mermaid)","Hurghada",4.88]
[1,1,0,"Rusalka (Mermaid)","Makadi",7.5]
[2,1,0,"Rusalka (Mermaid)","Hurghada",8.129999999999999]
[2,0,0,"Rusalka (Mermaid)","Hurghada",6.5]
[2,0,2,"Rusalka (Mermaid)","Safaga",16]
[2,0,0,"Rusalka (Mermaid)","Hurghada",6.5]
[2,0,1,"Rusalka (Mermaid)","Hurghada",6.5]
[2,0,0,"Rusalka (Mermaid)","Hurghada",6.5]
[3,0,0,"Rusalka (Mermaid)","Makadi",15]
[2,0,0,"Scuba Trip","Sahl Hasheesh",6.5]
[2,0,0,"Scuba Trip","Hurghada",6.5]
[3,1,0,"Scuba Trip","Makadi",17.5]
[2,1,0,"Scuba Trip","Makadi",12.5]
[2,0,1,"Scuba Trip","Makadi",10]
[2,0,0,"Scuba Trip","Safaga",16]
[3,0,0,"Scuba Trip","Sahl Hasheesh",9.75]
[2,1,1,"Scuba Trip","Makadi",12.5]
[2,0,0,"Scuba Trip","Makadi",10]
[3,0,1,"Scuba Trip","Safaga",24]
[2,0,0,"Scuba Trip","Hurghada",6.5]
[2,0,0,"Scuba Trip","Hurghada",6.5]
[2,0,1,"Scuba Trip","Hurghada",6.5]
[1,1,0,"Scuba Trip","Makadi",7.5]
[3,0,0,"Scuba Trip","Makadi",15]
[2,0,1,"Scuba Trip","Hurghada",6.5]
[2,0,0,"Scuba Trip","Hurghada",6.5]
[1,1,0,"Scuba Trip","Hurghada",4.88]
[2,0,1,"Scuba Trip","Hurghada",6.5]
[4,0,0,"Scuba Trip","Makadi",20]
[2,0,0,"Scuba Trip","Sahl Hasheesh",6.5]
[6,1,0,"Scuba Trip","Hurghada",21.13]
[1,0,0,"Scuba Trip","Soma Bay",8]
[1,0,1,"Scuba Trip","Hurghada",3.25]
[2,0,0,"Scuba Trip","Hurghada",6.5]
[2,0,0,"Scuba Trip","Hurghada",6.5]
[3,0,1,"Scuba Trip","Hurghada",9.75]
[3,0,1,"Scuba Trip","Hurghada",9.75]
[2,0,1,"Scuba Trip","Hurghada",6.5]
[2,0,0,"Scuba Trip","Hurghada",6.5]
[3,0,0,"Scuba Trip","Makadi",15]
[1,0,0,"Scuba Trip","Makadi",5]
[6,1,1,"Scuba Trip","Sahl Hasheesh",21.13]
[2,1,0,"Scuba Trip","Hurghada",8.129999999999999]
[2,0,0,"Scuba Trip","Hurghada",6.5]
[7,1,0,"Scuba Trip","Hurghada",24.38]
[2,0,0,"Scuba Trip","Hurghada",6.5]
[1,0,0,"Scuba Trip","Hurghada",3.25]
[3,0,0,"Scuba Trip","Hurghada",9.75]
[2,0,0,"Super Safari","Hurghada",6.5]
[3,0,0,"Super Safari","Hurghada",9.75]
[2,0,1,"Super Safari","Hurghada",6.5]
[2,0,1,"Super Safari","Hurghada",6.5]
[4,0,0,"Super Safari","Makadi",20]
[1,0,0,"Super Safari","Hurghada",3.25]
[2,0,0,"Super Safari","Hurghada",6.5]
[2,0,0,"Super Safari","Hurghada",6.5]
[2,0,0,"Super Safari","Hurghada",6.5]
[2,2,0,"Super Safari","Hurghada",9.76]
[2,0,0,"Super Safari","Hurghada",6.5]
[1,0,0,"Super Safari","Hurghada",3.25]

{"sheet":"Setting","index":1,"n_rows":109,"n_cols":9,"rows_kept":109,"cut":false,"hidden":false,"merged":[[1,0,2,0],[1,7,1,8],[0,1,0,8],[1,3,1,4]]}
[null,"Transfer Fees"]
["Name","Hurghada","Sahl Hasheesh","Makadi",null,"Safaga","Soma Bay","El Gouna"]
[null,"Adl","Chd","Adl","Chd","Adl","Chd","Adl","Chd"]
["Utopia Island",3.25,{"$f":"ROUND((B4/2),2)","v":1.63},5,2.5,8,4,6,3]
["Super Scuba",3.25,{"$f":"ROUND((B5/2),2)","v":1.63},5,2.5,8,4,6,3]
["Super Safari",3.25,1.63,5,2.5,8,4,6,3]
["Super Moto",3.25,1.63,5,2.5,8,4,6,3]
["SunSet Sailing",3.25,1.63,5,2.5,8,4,6,3]
["Submarine & Sindbad Aqua Park",3.25,1.63,5,2.5,8,4,6,3]
["Submarine",3.25,1.63,5,2.5,8,4,6,3]
["St.Poul &St.Antony",3.25,1.63,5,2.5,8,4,6,3]
["Snorkeling On Diving Boat",3.25,1.63,5,2.5,8,4,6,3]
["Sindbad Aqua Park",3.25,1.63,5,2.5,8,4,6,3]
["Sharm El Loly Half Day",3.25,1.63,5,2.5,8,4,6,3]
["Sharm El Loly Full Day",3.25,1.63,5,2.5,8,4,6,3]
["Sea Wolf",3.25,1.63,5,2.5,8,4,6,3]
["Sea Trip",3.25,1.63,5,2.5,8,4,6,3]
["Sea Scope",3.25,1.63,5,2.5,8,4,6,3]
["Sea & City",3.25,1.63,5,2.5,8,4,6,3]
["Scuba Trip",3.25,1.63,5,2.5,8,4,6,3]
["Satayh Daily Snorkeling Trip",3.25,1.63,5,2.5,8,4,6,3]
["Sand City & Dolphin Show",3.25,1.63,5,2.5,8,4,6,3]
["Rusalka (Mermaid)",3.25,1.63,5,2.5,8,4,6,3]
["Royal Utopia",3.25,1.63,5,2.5,8,4,6,3]
["Red Sea Dolphin",3.25,1.63,5,2.5,8,4,6,3]
["Professional Fishing",3.25,1.63,5,2.5,8,4,6,3]
["Private Boat Fishing",3.25,1.63,5,2.5,8,4,6,3]
["Private Boat Diving",3.25,1.63,5,2.5,8,4,6,3]
["Pirates SunSet",3.25,1.63,5,2.5,8,4,6,3]
["Pirates",3.25,1.63,5,2.5,8,4,6,3]
["Parasaling Trip"]
["SGL",3.25,{"$f":"ROUND((B32/2),2)","v":1.63},5,2.5,8,4,6,3]
["DBL",3.25,1.63,5,2.5,8,4,6,3]
["TPL",3.25,1.63,5,2.5,8,4,6,3]
["Companion",3.25,1.63,5,2.5,8,4,6,3]
["Paradise Deluxe",3.25,1.63,5,2.5,8,4,6,3]
["Over Day LuxorQueen Vally",3.25,1.63,5,2.5,8,4,6,3]
["Over Day Luxor",3.25,1.63,5,2.5,8,4,6,3]
["Orange Bay By Glass Boat",3.25,1.63,5,2.5,8,4,6,3]
["Open Water Course HRG",3.25,1.63,5,2.5,8,4,6,3]
["Nile Cruise",0,0,0,0,0,0,0,0]
["Natalius",3.25,1.63,5,2.5,8,4,6,3]
["Moto SunSet",3.25,1.63,5,2.5,8,4,6,3]
["Moto 5 Hours",3.25,1.63,5,2.5,8,4,6,3]
["Moto 3 Hours",3.25,1.63,5,2.5,8,4,6,3]
["Mega Safari",3.25,1.63,5,2.5,8,4,6,3]
["Luxor / Aswan-Abu Simple O/N 4 ****"]
["Single",3.25,{"$f":"ROUND((B48/2),2)","v":1.63},5,2.5,8,4,6,3]
["Double",3.25,1.63,5,2.5,8,4,6,3]
["Triple",3.25,1.63,5,2.5,8,4,6,3]
["Little Buddah Disco",3.25,1.63,5,2.5,8,4,6,3]
["Jerusalem",3.25,1.63,5,2.5,8,4,6,3]
["Intro Diving"]
["Diving",3.25,{"$f":"ROUND((B54/2),2)","v":1.63},5,2.5,8,4,6,3]
["Snorkeling",3.25,1.63,5,2.5,8,4,6,3]
["Individual Transfer",3.25,1.63,5,2.5,8,4,6,3]
["Individual Super Safari",3.25,1.63,5,2.5,8,4,6,3]
["Individual St.Poul & Antony",3.25,1.63,5,2.5,8,4,6,3]
["Individual Moto 5",3.25,1.63,5,2.5,8,4,6,3]
["Individual Moto 3",3.25,1.63,5,2.5,8,4,6,3]
["Individual Luxor",3.25,1.63,5,2.5,8,4,6,3]
["Individual Dandara",3.25,1.63,5,2.5,8,4,6,3]
["Individual Cairo Over Day",3.25,1.63,5,2.5,8,4,6,3]
["Individual Cairo By Plane",3.25,1.63,5,2.5,8,4,6,3]
["Individual  Royal Utopia",3.25,1.63,5,2.5,8,4,6,3]
["Hamata Sea Trip",3.25,1.63,5,2.5,8,4,6,3]
["Half Day Jungle Aquapark",3.25,1.63,5,2.5,8,4,6,3]
["Grand Aquarium+Jungle 1/2 Day",3.25,1.63,5,2.5,8,4,6,3]
["Grand Aquarium",3.25,1.63,5,2.5,8,4,6,3]
["Full Day Jungle AquaPark",3.25,1.63,5,2.5,8,4,6,3]
["Fishing Trip",3.25,1.63,5,2.5,8,4,6,3]
["Fast Track HRG",3.25,1.63,5,2.5,8,4,6,3]
["Empier Scope",3.25,1.63,5,2.5,8,4,6,3]
["Elite Vip Sea Trip",3.25,1.63,5,2.5,8,4,6,3]
["El Gouna Trip",3.25,1.63,5,2.5,8,4,6,3]
["Dolphin World Show-Makadi",3.25,1.63,5,2.5,8,4,6,3]
["Dolphin Therapy",3.25,1.63,5,2.5,8,4,6,3]
["Dolphin Swimming -Dolphina"]
["Swimming 5 Mins"]
["Swimming 10 Mins"]
["Swimming 15 Mins"]
["Swimming 20 Mins"]
["Accompany"]
["Dolphin Show-Dolphina"]
["Dolphin House",3.25,{"$f":"ROUND((B85/2),2)","v":1.63},5,2.5,8,4,6,3]
["Diving With Sharks",3.25,1.63,5,2.5,8,4,6,3]
["Diving From The Beach",3.25,1.63,5,2.5,8,4,6,3]
["Dandara Abydos",3.25,1.63,5,2.5,8,4,6,3]
["Dandara",3.25,1.63,5,2.5,8,4,6,3]
["Coral Garden",3.25,1.63,5,2.5,8,4,6,3]
["City Tour With Aquarium",3.25,1.63,5,2.5,8,4,6,3]
["City Tour (Half Day)",3.25,1.63,5,2.5,8,4,6,3]
["Cairo/Alex 2 Night"]
["Single"]
["Double"]
["Triple"]
["Cairo Overday HRG"]
["Cairo By Plane HRG"]
["Aswan Over Day"]
["Aspendos Turkish Bath"]
["Turkish Hamam"]
["Turkish +Oil Massage"]
["Cleopatra"]
["Cleopatra Plus"]
["All In One",3.25,1.63,5,2.5,8,4,6,3]
["Advanced Course HRG",3.25,1.63,5,2.5,8,4,6,3]
["Abu Dabab Half Day",3.25,1.63,5,2.5,8,4,6,3]
["Abu Dabab Full Day",3.25,1.63,5,2.5,8,4,6,3]
["1001 Show",3.25,1.63,5,2.5,8,4,6,3]