{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["nueva db","Deposit"],"not_rendered":{"charts":0,"images":5,"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":"nueva db","index":0,"n_rows":47,"n_cols":18,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["TIPO GRUPO","DEPOSITO / CANCELACION","PARTECIPANTES","BU Italy","BU Spain","BU Germany","BU Benelux","CONDITIONS","firma contrato / % de not refoundable","FECHA MINIMA PAGO 2","FECHA MAXIMA PAGO 2","PAGO 2%","FECHA MINIMA PAGO 3","FECHA MAXIMA PAGO 3","PAGO 3%","FECHA MINIMA PAGO 4","FECHA MAXIMA PAGO 4","PAGO 4%"]
["BGR","DEPOSITO","10 - 29",null,"x",null,"x","Once the contract is signed: 10% as deposit is required \nBetween 1 month & 14 days: 40% of the total amount  as deposit is required \nBetween 13 & 7 days: 30% of the total amount  as deposit is required \n7 days Before arrival: 20% of the total amount  as deposit is required \nNO SHOW: No free release applicable",0.1,30,14,0.4,13,7,0.3,7,7,0.2]
["BGR","DEPOSITO","10 - 29",null,null,"x",null,"Once the contract is signed: 10%  as deposit is required \nBetween 1 month & 14 days: 40% of the total amount  as deposit is required \nBetween 13 & 7 days: 30% of the total amount  as deposit is required \n7 days Before arrival: 20% of the total amount  as deposit is required \nNo Show: In the event of no-show, the customer will, in all cases, be required to pay 90% of the reservation value (including VAT). In the event of no-show we charge 70% on half-board and full-board arrangements",0.1,30,14,0.4,13,7,0.3,7,7,0.2]
["BGR","DEPOSITO","10 - 20","x",null,null,null,"Once the contract is signed: 10%  as deposit is required \nBetween 1 month & 14 days: 40% of the total amount  as deposit is required \nBetween 13 & 7 days: 30% of the total amount  as deposit is required \n7 days Before arrival: 20% of the total amount  as deposit is required \nNO SHOW: No free release applicable",0.1,30,14,0.4,13,7,0.3,7,7,0.2]
["BGR","CANCELACION","10 - 29",null,"x",null,"x","Up to 1 month prior to arrival: Booking can be cancelled free of charge\nBetween 1 month & 14 days: 50% of the total booking value can be cancelled free of charge\nBetween 13 & 7 days:  20% of the total current booking value can be cancelled free of charge\nCancellation less than 7 days:  No free cancellation applicable\nNO SHOW: In the event of no-show, the customer will, in all cases, be required to pay 100% of the reservation value (including VAT).\n",0,30,null,0.5,14,null,0.2,7,null,0]
["BGR","CANCELACION","10 - 20","x",null,null,null,"Up to 1 month prior to arrival: Booking can be cancelled free of charge\nBetween 1 month & 14 days: 50% of the total booking value can be cancelled free of charge\nBetween 13 & 7 days:  20% of the total current booking value can be cancelled free of charge\nCancellation less than 7 days:  No free cancellation applicable\nNO SHOW: In the event of no-show, the customer will, in all cases, be required to pay 100% of the reservation value (including VAT).\n",0,30,null,0.5,14,null,0.2,7,null,0]
["BGR","CANCELACION","10 - 29",null,null,"x",null,"Up to 1 month prior to arrival: Booking can be cancelled free of charge\nBetween 1 month & 14 days: 50% of the total booking value can be cancelled free of charge\nBetween 13 & 7 days:  20% of the total current booking value can be cancelled free of charge\nCancellation less than 7 days:  No free cancellation applicable \n------------------\nIn case of a total cancellation or a reduction greater than the above mentioned, we will charge the exceeding elements to its contracted value.\n ------------------\nNo Show: In the event of no-show, the customer will, in all cases, be required to pay 90% of the reservation value (including VAT). In the event of no-show we charge 70% on half-board and full-board arrangements.",0,30,null,0.5,14,null,0.2,7,null,0]
["BGR","DEPOSITO","30 - 74",null,"x",null,"x","Once the contract is signed: 15% once the contract is signed as deposit is required\nBetween 49 days & 30 days:35% of the total amount as deposit is required\nBetween 29 & 7 days:30% of the total amount as deposit is required\n7 days Before arrival: 20% of the total amount as deposit is required\nNO SHOW: No free release applicable",0.15,49,30,0.35,29,7,0.3,7,7,0.2]
["BGR","DEPOSITO","30 - 74",null,null,"x",null,"Once the contract is signed: 15% once the contract is signed  as deposit is required\nBetween 49 days & 30 days:35% of the total amount as deposit is required\nBetween 29 & 7 days:30% of the total amount as deposit is required\n7 days Before arrival: 20% of the total amount as deposit is required\nNo Show: In the event of no-show, the customer will, in all cases, be required to pay 90% of the reservation value (including VAT). In the event of no-show we charge 70% on half-board and full-board arrangements",0.15,49,30,0.35,29,7,0.3,7,7,0.2]
["BGR","DEPOSITO","21 - 40","x",null,null,null,"Once the contract is signed: 15% once the contract is signed as deposit is required\nBetween 49 days & 30 days: 35% of the total amount as deposit is required\nBetween 29 & 7 days: 30% of the total amount as deposit is required\n7 days Before arrival: 20% of the total amount as deposit is required\nNO SHOW: No free release applicable",0.15,49,30,0.35,29,7,0.3,7,7,0.2]
["BGR","CANCELACION","30 - 74",null,null,"x",null,"Up to 50 days prior to arrival: Booking can be cancelled free of charge\nBetween 49 days & 30 days: 50% of the total booking value can be cancelled free of charge\nBetween 29 & 7 days: 20% of the total current booking value can be cancelled free of charge\nCancellation less than 7 days: No free cancellation applicable\nNo Show: In the event of no-show, the customer will, in all cases, be required to pay 90% of the reservation value (including VAT). In the event of no-show we charge 70% on half-board and full-board arrangements",0,50,null,0.5,30,null,0.2,7,null,0]
["BGR","CANCELACION","30 - 74",null,"x",null,"x","Up to 50 days prior to arrival: Booking can be cancelled free of charge\nBetween 49 days & 30 days: 50% of the total booking value can be cancelled free of charge\nBetween 29 & 7 days: 20% of the total current booking value can be cancelled free of charge\nCancellation less than 7 days: No free cancellation applicable\nNo Show: In the event of no-show, the customer will, in all cases, be required to pay 100% of the reservation value (including VAT).",0,50,null,0.5,30,null,0.2,7,null,0]
["BGR","CANCELACION","21 - 40","x",null,null,null,"Up to 50 days prior to arrival: Free release for client can be cancelled free of charge\nBetween 49 days & 30 days: 50% of the total amount: free release for client can be cancelled free of charge\nBetween 29 & 7 days: 20% of the total amount: free release for client can be cancelled free of charge\nCancellation less than 7 days: No free release applicable\nNO SHOW: No free release applicable",0,50,null,0.5,30,null,0.2,7,null,0]
["BGR","DEPOSITO","75-149",null,"x",null,"x","Once the contract is signed 20% once the contract is signed as Deposit is required\nBetween 59 days & 35 days:30% of the total amount as Deposit is required\nBetween 34 & 7 days: 35% of the total amount as Deposit is required\n7 days Before arrival 15% of the total amount as Deposit is required\nNO SHOW: No free release applicable",0.2,59,34,0.3,34,7,0.35,7,7,0.15]
["BGR","DEPOSITO","75-149",null,null,"x",null,"Once the contract is signed 20% once the contract is signed as Deposit is required\nBetween 59 days & 35 days:30% of the total amount as Deposit is required\nBetween 34 & 7 days: 35% of the total amount as Deposit is required\n7 days Before arrival 15% of the total amount as Deposit is required\nNo Show: In the event of no-show, the customer will, in all cases, be required to pay 90% of the reservation value (including VAT). In the event of no-show we charge 70% on half-board and full-board arrangements",0.2,59,34,0.3,34,7,0.35,7,7,0.15]
["BGR","DEPOSITO","41-70","x",null,null,null,"Once the contract is signed 20% once the contract is signed as deposit is required \nBetween 59 days & 35 days:30% of the total amount as deposit is required\nBetween 34 & 7 days: 35% of the total amount as deposit is required\n7 days Before arrival 15% of the total amount as deposit is required\nNO SHOW: No free release applicable",0.2,59,34,0.3,34,7,0.35,7,7,0.15]
["BGR","DEPOSITO","151 - 199",null,"x",null,"x","Once the contract is signed 25% once the contract is signed as deposit is required \nBetween 89 & 42 days: 35% of the total amount as deposit is required\nBetween 41 & 7 days:30% of the total amount as deposit is required\n7 days Before arrival  10% of the total amount as deposit is required\nNO SHOW: No free release applicable",0.25,89,41,0.35,40,7,0.3,7,7,0.1]
["BGR","DEPOSITO","151 - 199",null,null,"x",null,"Once the contract is signed 25% once the contract is signed as deposit is required\nBetween 89 & 42 days: 35% of the total amount as deposit is required\nBetween 41 & 7 days:30% of the total amount as deposit is required \n7 days Before arrival  10% of the total amount as deposit is required\nNo Show: In the event of no-show, the customer will, in all cases, be required to pay 90% of the reservation value (including VAT). In the event of no-show we charge 70% on half-board and full-board arrangements",0.25,89,41,0.35,40,7,0.3,7]
["BGR","DEPOSITO","71-90","x",null,null,null,"Once the contract is signed 25% as Deposit is required\nBetween 89 & 42 days: 35% of the total amount as Deposit is required\nBetween 41 & 7 days:30% of the total amount as Deposit is required\n7 days Before arrival  10% of the total amount as Deposit is required\nNO SHOW: No free release applicable",0.25,89,41,0.35,40,7,0.3,7,7,0.1]
["BGR","DEPOSITO",">200",null,"x",null,"x","Up to 120 days prior to arrival:30% once the contract is signed as Deposit is required\nBetween 119 days & 56 days: 35% of the total amount as Deposit is required\nBetween 55 & 28 days: 25% of the total amount as Deposit is required\n28 days Before arrival 10% of the total amount as Deposit is required\nNO SHOW: No free release applicable",0.3,119,55,0.35,55,27,0.25,27,27,0.1]
["BGR","DEPOSITO",">200",null,null,"x",null,"Up to 120 days prior to arrival:30% once the contract is signed as deposit is required\nBetween 119 days & 56 days: 35% of the total amount as deposit is required \nBetween 55 & 28 days: 25% of the total amount as deposit is required\n28 days Before arrival 10% of the total amount as deposit is required \nNo Show: In the event of no-show, the customer will, in all cases, be required to pay 90% of the reservation value (including VAT). In the event of no-show we charge 70% on half-board and full-board arrangements",0.3,119,55,0.35,55,27,0.25,27,27,0.1]
["BGR","DEPOSITO",">91","x",null,null,null,"Up to 120 days prior to arrival:30% once the contract is signed as deposit is required\nBetween 119 days & 56 days: 35% of the total amount as deposit is required\nBetween 55 & 28 days: 25% of the total amount as deposit is required\n28 days Before arrival 10% of the total amount as deposit is required\nNO SHOW: No free release applicable",0.3,119,55,0.35,55,27,0.25,27,27,0.1]
["BGR","CANCELACION","75-149",null,null,"x",null,"Up to 60 days prior to arrival: Free release for client can be cancelled free of charge\nBetween 59 days & 35 days: 50% of the total amount: free release for client can be cancelled free of charge\nBetween 34 & 7 days:20% of the total amount: free release for client can be cancelled free of charge\nCancellation less than 7 days:No free release applicable\nNo Show: In the event of no-show, the customer will, in all cases, be required to pay 90% of the reservation value (including VAT). In the event of no-show we charge 70% on half-board and full-board arrangements",0,60,null,0.5,35,null,0.2,7,null,0]
["BGR","CANCELACION","75-149",null,"x",null,"x","Up to 60 days prior to arrival:Booking can be cancelled free of charge\nBetween 59 and 35 days prior to arrival:50% of the total booking value can be cancelled free of charge\nBetween 34 & 7 days prior to arrival 20% of the total current booking value can be cancelled free of charge\nLess than 7 days prior to arrival: No free cancellation applicable\nNO SHOW: No free release applicable",0,60,null,0.5,35,null,0.2,7,null,0]
["BGR","CANCELACION","41-70","x",null,null,null,"Up to 60 days prior to arrival: Free release for client can be cancelled free of charge\nBetween 59 days & 35 days: 50% of the total amount: free release for client can be cancelled free of charge\nBetween 34 & 7 days:20% of the total amount: free release for client can be cancelled free of charge\nCancellation less than 7 days:No free release applicable\nNO SHOW: No free release applicable",0,60,null,0.5,35,null,0.2,7,null,0]
["BGR","CANCELACION","151 - 199",null,null,"x",null,"Up to 90 days prior to arrival:Free release for client can be cancelled free of charge\nBetween 89 & 42 days:50% of the total amount: free release for client can be cancelled free of charge\nBetween 41 & 7 days:20% of the total amount: free release for client can be cancelled free of charge\nCancellation less than 7 days: No free release applicable\nNo Show: In the event of no-show, the customer will, in all cases, be required to pay 90% of the reservation value (including VAT). In the event of no-show we charge 70% on half-board and full-board arrangements",0,90,null,0.5,42,null,0.2,7,null,0]
["BGR","CANCELACION","151 - 199",null,"x",null,"x","Up to 90 days prior to arrival:Booking can be cancelled free of charge\nBetween 89 and 42 days prior to arrival:50% of the total booking value can be cancelled free of charge\nBetween 41 & 7 days prior to arrival: 20% of the total current booking value can be cancelled free of charge\nLess than 7 days prior to arrival: No free cancellation applicable\n No Show In the event of no-show, the customer will, in all cases, be required to pay 100% of the reservation value (including VAT).\n",0,90,null,0.5,42,null,0.2,7,null,0]
["BGR","CANCELACION","71-90","x",null,null,null,"Up to 90 days prior to arrival:Free release for client can be cancelled free of charge\nBetween 89 & 42 days:50% of the total amount: free release for client can be cancelled free of charge\nBetween 41 & 7 days:20% of the total amount: free release for client can be cancelled free of charge \nCancellation less than 7 days: No free release applicable\nNO SHOW: No free release applicable",0,90,null,0.5,42,null,0.2,7,null,0]
["BGR","CANCELACION",">200",null,null,"x",null,"Up to 120 days prior to arrival:Free release for client can be cancelled free of charge\nBetween 119 days & 56 days:50% of the total amount: free release for client can be cancelled free of charge\nBetween 55 & 28 days: 20% of the total amount: free release for client can be cancelled free of charge\nCancellation less than 28 days:No free release applicable\nNo Show: In the event of no-show, the customer will, in all cases, be required to pay 90% of the reservation value (including VAT). In the event of no-show we charge 70% on half-board and full-board arrangements",0,120,null,0.5,56,null,0.2,28,null,0]
["BGR","CANCELACION",">200",null,"x",null,"x","Up to 120 days prior to arrival:Booking can be cancelled free of charge\nBetween 119 and 56 days prior to arrival: 50% of the total booking value can be cancelled free of charge\nBetween 55 & 28 days prior to arrival:20% of the total current booking value can be cancelled free of charge\nLess than 28 days prior to arrival:No free cancellation applicable\n No Show In the event of no-show, the customer will, in all cases, be required to pay 100% of the reservation value (including VAT).\n",0,120,null,0.5,56,null,0.2,28,null,0]
["BGR","CANCELACION",">91","x",null,null,null,"Up to 120 days prior to arrival:Free release for client can be cancelled free of charge\nBetween 119 days & 56 days:50% of the total amount: free release for client can be cancelled free of charge\nBetween 55 & 28 days: 20% of the total amount: free release for client can be cancelled free of charge\nCancellation less than 28 days:No free release applicable\nNO SHOW: No free release applicable",0,120,null,0.5,56,null,0.2,28,null,0]
["LGR","CANCELACION","N/A",null,null,"X",null,"Up to 1 month prior to arrival:   No cancellation fee\nBetween 27 &22 days: 10% of the total amount\nBetween 21 & 15 days: 50% of the total amount\nBetween 14 & 7 days: 80% of the total amount\nCancellation less than 7 days:  90% of the total amount\nNO SHOW:  In the event of no-show, the customer will, in all cases, be required to pay 90% of the reservation value (including VAT). In the event of no-show we charge 70% on half-board and full-board arrangements\n---\nPartial cancellation of rooms and services is only possible upon prior agreement with the hotel.\nAll cancellations or amendments must be made in writing to the reservations department. Prior to the release date of each group allotment, the above mentioned company will send a booking report, reconfirming dates and the names of the groups reserved. Any unsold accommodation will be released at that time.",0,30,null,0.1,22,null,0.5,15,7,0.8]
["LGR","DEPOSITO","N/A",null,null,"X",null,"Should your company have a credit line approved with NH Hoteles, invoices will be paid within 30 days after the date mentioned on the invoice. In case of disputable invoices, the client will inform the hotel about the details within 7 days. Under no circumstances can a disputable invoice be the cause of paying invoices later than 30 days or of non payment. A payment is received when the full amount is posted on the bank account of the hotel.\nIn some cases and due to high demand dates, NH reserves the right to request a deposit in order to guarantee the space. Deposit need to be settled before the cancellation policy becomes effective. \n--\nShould your company not have a credit line approved with NH Hoteles, hotel will request full pre payment prior to the groups arrival and before the cancellation policy becomes effective.. Should payment not be received by hotel within indicated period ,hotel reserved the right to cancel the reservation. Should payment not be received by hotel within given period, even after one reminder, hotel is obliged to charge the legal interest.",0.1,30,30,0.9]
["LGR","CANCELACION","N/A","X","X",null,"X","Up to 1 month prior to arrival:   No cancellation fee\nBetween 27 &22 days: 10% of the total amount\nBetween 21 & 15 days: 50% of the total amount\nBetween 14 & 7 days: 80% of the total amount\nCancellation less than 7 days:  100% of the total amount\nNO SHOW:  100% of the total amount\n-----\nPartial cancellation of rooms and services is only possible upon prior agreement with the hotel.\nAll cancellations or amendments must be made in writing to the reservations department. Prior to the release date of each group allotment, the above mentioned company will send a booking report, reconfirming dates and the names of the groups reserved. Any unsold accommodation will be released at that time.",0,30,null,0.1,22,null,0.5,15,7,0.8]
["LGR","DEPOSITO","N/A","X","X",null,"X","Should your company have a credit line approved with NH Hoteles, invoices will be paid within 30 days after the date mentioned on the invoice. In case of disputable invoices, the client will inform the hotel about the details within 7 days. Under no circumstances can a disputable invoice be the cause of paying invoices later than 30 days or of non payment. A payment is received when the full amount is posted on the bank account of the hotel.\nIn some cases and due to high demand dates, NH reserves the right to request a deposit in order to guarantee the space. Deposit need to be settled before the cancellation policy becomes effective. \n--\nShould your company not have a credit line approved with NH Hoteles, hotel will request full pre payment prior to the groups arrival and before the cancellation policy becomes effective.. Should payment not be received by hotel within indicated period ,hotel reserved the right to cancel the reservation. Should payment not be received by hotel within given period, even after one reminder, hotel is obliged to charge the legal interest.",0.1,30,30,0.9]
["FAIR","DEPOSITO","A","X","X","X","X","Once the contract is signed: 10% of total amount *\n365-185 days prior to arrival date: 40% of the total amount as Deposit is required.\n183-92 days before the congress date:  40% of the total amount  as Deposit is required.\n91 days before the congress date: 10% of the total amount  as Deposit is required.\n---\n* Once contract is signed a 10% Deposit is Non refundable ",0.1,365,185,0.4,183,92,0.4,91,91,0.1]
["FAIR","DEPOSITO","B","X","X","X","X","Once the contract is signed: 20% of total amount*\n183 -  122 days before the congress date:  25% of the total amount as Deposit is required.\n121 - 92 days before the congress date:  30% of the total amount as Deposit is required.\n91 - 0 days before the congress date: 25% of the total amount as Deposit is required.\n---\n* Once contract is signed a 10% Deposit is Non refundable ",0.2,183,122,0.25,121,92,0.3,91,91,0.25]
["FAIR","DEPOSITO","C","X","X","X","X","Once the contract is signed: 25% of total amount*\n122 - 92 days before the congress date: 20% of the total amount as Deposit is required.\n91 - 61 days before the congress date: 30% of the total amount as Deposit is required.\n60 - 0 days before the congress date: 25% of the total amount as Deposit is required.\n---\n* Once contract is signed a 10% Deposit is Non refundable ",0.25,null,null,0.2,null,null,0.3,null,null,0.25]
["FAIR","DEPOSITO","D","X","X","X","X","Once the contract is signed: 30% of total amount*\n91 - 61 days days before the congress date: 20% of the total amount as Deposit is required.\n60 - 31 days before the congress date: 25% of the total amount as Deposit is required.\n30 - 0 days before the congress date: 25% of the total amount as Deposit is required.\n---\n* Once contract is signed a 10% Deposit is Non refundable ",0.3,null,null,0.2,null,null,0.25,null,null,0.25]
["FAIR","CANCELACION","A","X","X",null,"X","Cancellation up to 366 days prior to arrival date:  Booking can be cancelled free of charge\n365 - 184 days prior to arrival date: 50% of the total booking value can be cancelled free of charge\n183 - 92 days prior to arrival date: 10% of the total current booking value can be cancelled free of charge\n91 - 0 days prior to arrival date:    No free cancellation applicable\nNo Show In the event of no-show, the customer will, in all cases, be required to pay 100% of the reservation value (including VAT). \n",0,365,null,0.5,184,null,0.1,92,null,0]
["FAIR","CANCELACION","B","x","x",null,"x","Cancellation up to 184 days prior to arrival date:  Booking can be cancelled free of charge\n183 - 122 days prior to arrival date:50% of the total booking value can be cancelled free of charge\n121 - 92 days prior to arrival date: 25% of the total current booking value can be cancelled free of charge\n91 - 0 days prior to arrival date: No free cancellation applicable\n No Show In the event of no-show, the customer will, in all cases, be required to pay 100% of the reservation value (including VAT).\n",0,183,null,0.5,122,null,0.25,92,null,0]
["FAIR","CANCELACION","C","x","x",null,"x","Cancellation up to 123 days prior to arrival date:  Booking can be cancelled free of charge\n122 - 92 days prior to arrival date: 50% of the total booking value can be cancelled free of charge\n91 - 61 days prior to arrival date: 25% of the total current booking value can be cancelled free of charge\n60 - 0 days prior to arrival date: No free cancellation applicable\n No Show In the event of no-show, the customer will, in all cases, be required to pay 100% of the reservation value (including VAT).\n",0,122,null,0.5,92,null,0.25,61,null,0]
["FAIR","CANCELACION","D","x","x",null,"x","Cancellation up to 92 days prior to arrival date:  Booking can be cancelled free of charge\n91 - 61 days prior to arrival date: 70% of the total booking value can be cancelled free of charge\n60 - 31 days prior to arrival date: 25% of the total current booking value can be cancelled free of charge\n30 - 0 days prior to arrival date:    No free cancellation applicable\n No Show In the event of no-show, the customer will, in all cases, be required to pay 100% of the reservation value (including VAT). \n",0,92,null,0.5,61,null,0.25,31,null,0]
["FAIR","CANCELACION","A",null,null,"X",null,"\n366 days from the congress date:100% of the contracted elements can be cancelled free of charge \n 365 - 184 days from the congress date: 50% of the remaining elements can be cancelled free of charge \n183 - 92 days from the congress date: 10% of the remaining elements can be cancelled free of charge \n91- 0 days from the congress date:No free cancellation applicable \nIn case of a total cancellation or a reduction greater than the above mentioned attrition, we will charge the exceeding elements to its contracted value.\n No Show In the event of no-show, the customer will, in all cases, be required to pay 90% of the reservation value (including VAT). In the event of no-show we charge 70% on half-board and full-board arrangements.\n\n",0,365,null,0.5,184,null,0.1,92,null,0]
["FAIR","CANCELACION","B",null,null,"X",null,"184 days from the congress date 100% of the contracted elements can be cancelled free of charge \n183 - 122 days from the congress date: 50% of the remaining elements can be cancelled free of charge \n121 - 92 days from the congress date: 25% of the remaining elements can be cancelled free of charge \n91- 0 days from the congress date: No free cancellation applicable \nIn case of a total cancellation or a reduction greater than the above mentioned attrition, we will charge the exceeding elements to its contracted value.\nNo Show In the event of no-show, the customer will, in all cases, be required to pay 90% of the reservation value (including VAT). In the event of no-show we charge 70% on half-board and full-board arrangements.\n",0,183,null,0.5,122,null,0.25,92,null,0]
["FAIR","CANCELACION","C",null,null,"X",null,"123 days from the congress date 100% of the contracted elements can be cancelled free of charge \n122 - 92 days from the congress date: 50% of the remaining elements can be cancelled free of charge \n91 - 61 days from the congress date: 25% of the remaining elements can be cancelled free of charge \n60- 0 days from the congress date: No free cancellation applicable \nIn case of a total cancellation or a reduction greater than the above mentioned attrition, we will charge the exceeding elements to its contracted value.\n No Show In the event of no-show, the customer will, in all cases, be required to pay 90% of the reservation value (including VAT). In the event of no-show we charge 70% on half-board and full-board arrangements.\n",0,122,null,0.5,92,null,0.25,61,null,0]
["FAIR","CANCELACION","D",null,null,"X",null,"92 days from the congress date 100% of the contracted elements can be cancelled free of charge \n92 - 61 days from the congress date: 70% of the remaining elements can be cancelled free of charge \n60 - 31 days from the congress date: 25% of the remaining elements can be cancelled free of charge \n30 - 0 days from the congress date: No free cancellation applicable \nIn case of a total cancellation or a reduction greater than the above mentioned attrition, we will charge the exceeding elements to its contracted value.\n No Show In the event of no-show, the customer will, in all cases, be required to pay 90% of the reservation value (including VAT). In the event of no-show we charge 70% on half-board and full-board arrangements.\n",0,92,null,0.5,61,null,0.25,31,null,0]

{"sheet":"Deposit","index":1,"n_rows":37,"n_cols":31,"rows_kept":37,"cut":false,"hidden":false,"merged":[[1,13,5,27],[16,19,16,21],[3,9,4,11],[1,9,2,11],[13,9,13,11],[12,9,12,11],[6,9,6,11],[5,9,5,11],[7,9,9,11],[10,9,11,11],[16,25,17,26],[16,23,17,24],[18,23,18,24],[19,23,19,24],[18,19,18,21],[7,13,14,27],[18,25,18,26],[18,13,18,17],[19,13,19,17],[20,13,20,17],[21,13,21,17],[19,25,19,26],[20,23,20,24],[20,25,20,26],[21,23,21,24],[21,25,21,26],[19,19,19,21],[20,19,20,21],[21,19,21,21],[25,13,25,17],[23,19,23,21],[25,19,25,21],[25,25,25,26],[24,25,24,26],[23,25,23,26],[28,25,28,26],[27,25,27,26],[26,25,26,26],[26,13,26,17],[27,13,27,17],[28,13,28,17],[26,19,26,21],[27,19,27,21],[28,19,28,21],[30,19,30,21],[30,25,30,26],[31,25,31,26],[32,13,32,17],[32,19,32,21],[32,25,32,26],[33,13,33,17],[33,19,33,21],[33,25,33,26],[35,13,35,17],[35,19,35,21],[35,25,35,26],[36,13,36,17],[36,19,36,21],[36,25,36,26],[34,13,34,17],[34,19,34,21],[34,25,34,26]]}
["BU Spain","BGR",null,"10 - 29",2,5,1,null,null,null,null,null,null,"Deposit Conditions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BGR",null,"1 - 2 Nights"]
["BU Italy","LGR",null,"30 - 74",8,12,2,null,null,"Booking file Revenue",null,null,null,"Up to 120 days prior to arrival:30% once the contract is signed as Deposit is required\nBetween 119 days & 56 days: 35% of the total amount as Deposit is required\nBetween 55 & 28 days: 25% of the total amount as Deposit is required\n28 days Before arrival 10% of the total amount as Deposit is required\nNO SHOW: No free release applicable",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BU Spain",null,"3 Nights"]
["BU CE - Germany","FAIR",null,"75-149",14,24,3,"Please choose a BU",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4 Nights"]
["BU CE - Rest Of Countries","otro??",null,"151 - 199",17,27,4,null,null,20000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,">4 Nights"]
["BU Benelux",null,null,">200",20,30,">4","Please Select the type of congress"]
["BU Mexico & Mercosur",null,null,null,null,null,null,null,null,"Contract Date\n(dd/mm/yyyy)"]
["dias para el inicio",{"$f":"J11-J7","v":-1073},{"$f":"IF(B7>B9,1,IF(B7>C9,2,IF(B7>D9,3,4)))","v":4},null,null,null,null,"Group Size / Fair Type:",null,{"$f":"TODAY()","v":"2020-01-09"},null,null,null,"Cancelation Policy"]
[0.3,0.35,0.25,0.1,null,null,null,null,null,"Event Date\n(dd/mm/yyyy)",null,null,null,"Up to 120 days prior to arrival:Booking can be cancelled free of charge\nBetween 119 and 56 days prior to arrival: 50% of the total booking value can be cancelled free of charge\nBetween 55 & 28 days prior to arrival:20% of the total current booking value can be cancelled free of charge\nLess than 28 days prior to arrival:No free cancellation applicable\n No Show In the event of no-show, the customer will, in all cases, be required to pay 100% of the reservation value (including VAT).\n"]
[null,119,55,27]
[null,55,27,27]
[0,0.5,0.2,0,null,null,null,null,null,"2017-01-31"]
[null,120,56,28]
[null,null,null,null,null,null,null,null,null,"Lenght of Stay:"]
[null,null,null,null,null,null,null,null,null,"1 - 2 Nights"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Due date Deposit Payment"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Days before the beginning at signing the contract:",null,null,null,null,null,{"$f":"IFERROR(J11-J7,\" - \")","v":-1073},null,null,null,"Comunication to customer",null,"Max. Negotiation Margin"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Payment at Signing the contract",null,null,null,null,{"$f":"IFERROR(IF(C7=1,A8,IF(C7=2,B8+A8,IF(C7=3,C8+B8+A8,1))),\" - \")","v":1},{"$f":"IFERROR(S19*$J$4,\" - \")","v":20000},null,null,null,{"$f":"J7","v":"2020-01-09"},null,{"$f":"J7","v":"2020-01-09"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"1st Payment",null,null,null,null,{"$f":"IFERROR(IF(C7=1,B8,IF(C7=2,C8,IF(C7=3,D8,\" - \"))),\" - \")","v":" - "},{"$f":"IFERROR(S20*$J$4,\" - \")","v":" - "},null,null,null,{"$f":"IFERROR(IF(C7=1,J11-B9,IF(C7=2,J11-C9,IF(C7=3,J11-D9,\" - \"))),\" - \")","v":" - "},null,{"$f":"IFERROR(IF(C7=1,J11-B10,IF(C7=2,J11-C10,IF(C7=3,J11-D10,\" - \"))),\" - \")","v":" - "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2nd Payment",null,null,null,null,{"$f":"IFERROR(IF(C7=1,C8,IF(C7=2,D8,\" - \")),\" - \")","v":" - "},{"$f":"IFERROR(S21*$J$4,\" - \")","v":" - "},null,null,null,{"$f":"IF(S21=0,\" - \",IFERROR(IF(C7=1,J11-C9,IF(C7=2,J11-D9,\" - \")),\" - \"))","v":" - "},null,{"$f":"IF(T21=0,\" - \",IFERROR(IF(C7=1,J11-C10,IF(C7=2,J11-D10,\" - \")),\" - \"))","v":" - "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"3rd Payment",null,null,null,null,{"$f":"IFERROR(IF(C7=1,D8,\" - \"),\" - \")","v":" - "},{"$f":"IFERROR(S22*$J$4,\" - \")","v":" - "},null,null,null,{"$f":"IF(T22=0,\" - \",IFERROR(IF(C7=1,J11-D9,\" - \"),\" - \"))","v":" - "},null,{"$f":"IF(T22=0,\" - \",IFERROR(IF(C7=1,J11-D10,\" - \"),\" - \"))","v":" - "}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Cancellation Dates - \",IF(AC1=\"BGR\",\"Business Group Policy\",IF(AC1=\"FAIR\",\"Fair & Congress policy\",AC1)))","v":"Cancellation Dates - Business Group Policy"},null,null,null,null,null,"Maximum Cancellation % of BF",null,null,null,"Revenue That can Be cancelled without penals",null,"Time Limit"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Cancellation Before \",B12,\" days: \",)","v":"Cancellation Before 120 days: "},null,null,null,null,null,{"$f":"IF(A11=0,100%,A11)","v":1},null,null,null,{"$f":"IFERROR(T26*$J$4,\" - \")","v":20000},null,{"$f":"IF($J$7>($J$11-B12),J7,IFERROR($J$11-B12,\" - \"))","v":"2020-01-09"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Cancellation Before \",C12,\" days: \",)","v":"Cancellation Before 56 days: "},null,null,null,null,null,{"$f":"B11","v":0.5},null,null,null,{"$f":"IFERROR(T27*$J$4,\" - \")","v":10000},null,{"$f":"IF($J$7>($J$11-C12),$J$7,IFERROR($J$11-C12,\" - \"))","v":"2020-01-09"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Cancellation Before \",D12,\" days: \",)","v":"Cancellation Before 28 days: "},null,null,null,null,null,{"$f":"C11","v":0.2},null,null,null,{"$f":"IFERROR(T28*$J$4,\" - \")","v":4000},null,{"$f":"IF($J$7>($J$11-D12),J7,IFERROR($J$11-D12,\" - \"))","v":"2020-01-09"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"No Show:",null,null,null,null,null,{"$f":"D11","v":0},null,null,null,{"$f":"IFERROR(T29*$J$4,\" - \")","v":0},null,{"$f":"IF($J$7>($J$11-E12),J7,IFERROR($J$11-E12,\" - \"))","v":"2020-01-09"}]
[]
["Germany",null,null,null,null,null,null,null,null,null,null,null,null,"Cancellation -  Leisure Group Policy",null,null,null,null,null,"Penal %",null,null,null,"Penal Revenue",null,"Time Limit"]
[null,"Austria","Switzerland","Others"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Cancellation Before \",B12,\" days: \",)","v":"Cancellation Before 120 days: "},null,null,null,null,null,{"$f":"A11","v":0},null,null,null,0,null,{"$f":"IFERROR(J11-B12,\" - \")","v":"2016-10-03"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Cancellation Before \",C12,\" days: \",)","v":"Cancellation Before 56 days: "},null,null,null,null,null,{"$f":"B11","v":0.5},null,null,null,{"$f":"IFERROR(T34*$J$4,\" - \")","v":10000},null,{"$f":"IFERROR(J11-C12,\" - \")","v":"2016-12-06"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Cancellation Before \",D12,\" days: \",)","v":"Cancellation Before 28 days: "},null,null,null,null,null,{"$f":"C11","v":0.2},null,null,null,{"$f":"IFERROR(T35*$J$4,\" - \")","v":4000},null,{"$f":"IFERROR(J11-D12,\" - \")","v":"2017-01-03"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Cancellation Before \",D13,\" days: \",)","v":"Cancellation Before  days: "},null,null,null,null,null,{"$f":"D11","v":0},null,null,null,{"$f":"IFERROR(T36*$J$4,\" - \")","v":0},null,{"$f":"IFERROR(J11-E12,\" - \")","v":"2017-01-31"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"No Show:",null,null,null,null,null,{"$f":"IF(AC2=\"BU Germany\",0.9,1)","v":1},null,null,null,{"$f":"IFERROR(T37*$J$4,\" - \")","v":20000},null,{"$f":"IFERROR(J11,\" - \")","v":"2017-01-31"}]