{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["FORM_B - MODELE","Tables"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":6,"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":"FORM_B - MODELE","index":0,"n_rows":32,"n_cols":17,"rows_kept":32,"cut":false,"hidden":false,"merged":[[1,4,1,7],[2,4,2,7],[15,1,15,3],[15,4,15,6],[16,1,16,3],[14,1,14,4],[3,4,3,5],[4,4,4,5],[5,4,5,5],[10,1,11,3],[10,4,10,7],[11,4,11,7],[12,1,12,3],[12,4,12,7],[13,1,13,4],[16,4,16,6],[16,7,16,11],[10,9,11,11],[10,12,10,14],[11,12,11,14],[12,12,12,14],[12,9,12,11],[17,1,17,3],[17,4,17,6],[17,8,17,9],[18,1,18,3],[18,4,18,6],[18,7,18,11],[35,1,35,16],[24,15,25,15],[24,9,25,9],[24,8,25,8],[24,3,25,3],[24,2,25,2],[24,1,25,1],[19,1,19,3],[23,4,23,5],[32,1,32,16],[33,1,33,16],[34,1,34,16]]}
[]
[null,"Complété par","Société"]
[null,null,"Personne de contact"]
[null,null,"Téléphone"]
[null,null,"Adresse email",null,null,55]
[null,null,"Date"]
[]
[null,null,"Ruling du",null,null,"Canton"]
[]
[]
[null,"Nom du groupe ou de la société \ndont proviennent les participations",null,null,null,null,null,null,null,"Nom de l'employeur (ou ex-employeur)"]
[]
[null,"Nom de l'action + code boursier",null,null,null,null,null,null,52,"Type de d'opération"]
[null,null,null,null,null,1,"Monnaie","",29]
[null,null,null,null,null,50]
[null,"No AVS"]
[null,"Nom et prénom"]
[null,"Rue",null,null,null,null,null,null,"CALCULS AUTOMATIQUES"]
[null,"Localité"]
[null,"Période fiscale, du …",null,null,null,"au …"]
[null,null,null,null,31,32]
[null,"Calcul du revenu imposable ou des frais d'acquisition du revenu pour cette période",null,null,null,null,null,null,"(les frais d'acquisition du revenu ne concernent que les cas de restitution d'actions)"]
[]
[null,2,19,27,"ou",null,33,35,13,16,20,17,34,36,37,30]
[null,"Désignation du plan de participations","Date du déblocage anticipé / de la restitution","Nombre d'actions débloquées / restituées","Valeur vénale de l'action lors du déblocage / de la restitution","Valeur de l'action non cotée établie selon une formule","Formule de calcul","Prix de restitution","Date d'acquisition de l'action","Date originelle de l'échéance du délai de blocage","Durée du délai de blocage restant","Abattement pour délai de blocage","Valeur vénale réduite selon la durée du délai de blocage restant","Avantage appréciable en argent par titre","Avantage appréciable en argent total","Cours de change","Déduction fiscale ou revenu imposable"]
[null,null,null,null,{"$f":"\"(\" & IF($H$14=\"\",\"Monnaie\", $H$14) & \")\"","v":"(Monnaie)"},{"$f":"\"(\" & IF($H$14=\"\",\"Monnaie\", $H$14) & \")\"","v":"(Monnaie)"},"(Texte)",{"$f":"\"(\" & IF($H$14=\"\",\"Monnaie\", $H$14) & \")\"","v":"(Monnaie)"},null,null,"(En années)","(%)",{"$f":"\"(\" & IF($H$14=\"\",\"Monnaie\", $H$14) & \")\"","v":"(Monnaie)"},{"$f":"\"(\" & IF($H$14=\"\",\"Monnaie\", $H$14) & \")\"","v":"(Monnaie)"},{"$f":"\"(\" & IF($H$14=\"\",\"Monnaie\", $H$14) & \")\"","v":"(Monnaie)"},null,"(CHF)"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"(J27-C27)/365","v":0},{"$f":"1-POWER(1+0.06,-K27)","v":0},{"$f":"IF(AND(E27>0,F27>0),\"Erreur\",IF(NOT(ISBLANK(E27)),E27*(1-L27),F27*(1-L27)))","v":0},{"$f":"IF(NOT(ISBLANK(H27)),H27-M27,E27-M27)","v":0},{"$f":"N27*D27","v":0},1,{"$f":"O27*P27","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"(J28-C28)/365","v":0},{"$f":"1-POWER(1+0.06,-K28)","v":0},{"$f":"IF(AND(E28>0,F28>0),\"Erreur\",IF(NOT(ISBLANK(E28)),E28*(1-L28),F28*(1-L28)))","v":0},{"$f":"IF(NOT(ISBLANK(H28)),H28-M28,E28-M28)","v":0},{"$f":"N28*D28","v":0},1,{"$f":"O28*P28","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DEDUCTION FISCALE (chiffre 15 du certificat de salaire)",null,{"$f":"SUMIF(Q27:Q29,\"<0\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"REVENU imposable, déclaré au chiffre 5 du certificat de salaire",null,{"$f":"SUMIF(Q27:Q29,\">0\")","v":0}]
[null," Remarques :",56]

{"sheet":"Tables","index":1,"n_rows":173,"n_cols":7,"rows_kept":173,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Tab_Monnaie",null,null,"Tab_Canton",null,"Tab_Type_operation"]
[null,"Monnaie",null,null,"Canton",null,"Type d'opération"]
[null,"CHF","Swiss Franc",null,"AG",null,"Actions débloquées de manière anticipée"]
[null,"EUR","Euro",null,"AI",null,"Actions restituées"]
[null,"USD","US Dollar",null,"AR"]
[null,"JPY","Yen",null,"BE"]
[null,"AFN","Afghani",null,"BL"]
[null,"DZD","Algerian Dinar",null,"BS"]
[null,"ARS","Argentine Peso",null,"FR"]
[null,"AMD","Armenian Dram",null,"GE"]
[null,"AWG","Aruban Florin",null,"GL"]
[null,"AUD","Australian Dollar",null,"GR"]
[null,"AZN","Azerbaijanian Manat",null,"JU"]
[null,"BSD","Bahamian Dollar",null,"LU"]
[null,"BHD","Bahraini Dinar",null,"NE"]
[null,"THB","Baht",null,"NW"]
[null,"PAB","Balboa",null,"OW"]
[null,"BBD","Barbados Dollar",null,"SG"]
[null,"BYR","Belarussian Ruble",null,"SH"]
[null,"BZD","Belize Dollar",null,"SO"]
[null,"BMD","Bermudian Dollar",null,"SZ"]
[null,"VEF","Bolivar",null,"TG"]
[null,"BOB","Boliviano",null,"TI"]
[null,"BRL","Brazilian Real",null,"UR"]
[null,"BND","Brunei Dollar",null,"VD"]
[null,"BGN","Bulgarian Lev",null,"VS"]
[null,"BIF","Burundi Franc",null,"ZG"]
[null,"CVE","Cabo Verde Escudo",null,"ZH"]
[null,"CAD","Canadian Dollar"]
[null,"KYD","Cayman Islands Dollar"]
[null,"XOF","CFA Franc BCEAO"]
[null,"XAF","CFA Franc BEAC"]
[null,"XPF","CFP Franc"]
[null,"CLP","Chilean Peso"]
[null,"COP","Colombian Peso"]
[null,"KMF","Comoro Franc"]
[null,"CDF","Congolese Franc"]
[null,"BAM","Convertible Mark"]
[null,"NIO","Cordoba Oro"]
[null,"CRC","Costa Rican Colon"]
[null,"HRK","Croatian Kuna"]
[null,"CUP","Cuban Peso"]
[null,"CZK","Czech Koruna"]
[null,"GMD","Dalasi"]
[null,"DKK","Danish Krone"]
[null,"MKD","Denar"]
[null,"DJF","Djibouti Franc"]
[null,"STD","Dobra"]
[null,"DOP","Dominican Peso"]
[null,"VND","Dong"]
[null,"XCD","East Caribbean Dollar"]
[null,"EGP","Egyptian Pound"]
[null,"SVC","El Salvador Colon"]
[null,"ETB","Ethiopian Birr"]
[null,"EUR","Euro"]
[null,"FKP","Falkland Islands Pound"]
[null,"FJD","Fiji Dollar"]
[null,"HUF","Forint"]
[null,"GHS","Ghana Cedi"]
[null,"GIP","Gibraltar Pound"]
[null,"HTG","Gourde"]
[null,"PYG","Guarani"]
[null,"GNF","Guinea Franc"]
[null,"GYD","Guyana Dollar"]
[null,"HKD","Hong Kong Dollar"]
[null,"UAH","Hryvnia"]
[null,"ISK","Iceland Krona"]
[null,"INR","Indian Rupee"]
[null,"IRR","Iranian Rial"]
[null,"IQD","Iraqi Dinar"]
[null,"JMD","Jamaican Dollar"]
[null,"JOD","Jordanian Dinar"]
[null,"KES","Kenyan Shilling"]
[null,"PGK","Kina"]
[null,"LAK","Kip"]
[null,"KWD","Kuwaiti Dinar"]
[null,"MWK","Kwacha"]
[null,"AOA","Kwanza"]
[null,"MMK","Kyat"]
[null,"GEL","Lari"]
[null,"LBP","Lebanese Pound"]
[null,"ALL","Lek"]
[null,"HNL","Lempira"]
[null,"SLL","Leone"]
[null,"LRD","Liberian Dollar"]
[null,"LYD","Libyan Dinar"]
[null,"SZL","Lilangeni"]
[null,"LTL","Lithuanian Litas"]
[null,"LSL","Loti"]
[null,"MGA","Malagasy Ariary"]
[null,"MYR","Malaysian Ringgit"]
[null,"MUR","Mauritius Rupee"]
[null,"MXN","Mexican Peso"]
[null,"MXV","Mexican Unidad de Inversion (UDI)"]
[null,"MDL","Moldovan Leu"]
[null,"MAD","Moroccan Dirham"]
[null,"MZN","Mozambique Metical"]
[null,"BOV","Mvdol"]
[null,"NGN","Naira"]
[null,"ERN","Nakfa"]
[null,"NAD","Namibia Dollar"]
[null,"NPR","Nepalese Rupee"]
[null,"ANG","Netherlands Antillean Guilder"]
[null,"ILS","New Israeli Sheqel"]
[null,"RON","New Romanian Leu"]
[null,"TWD","New Taiwan Dollar"]
[null,"NZD","New Zealand Dollar"]
[null,"BTN","Ngultrum"]
[null,"KPW","North Korean Won"]
[null,"NOK","Norwegian Krone"]
[null,"PEN","Nuevo Sol"]
[null,"MRO","Ouguiya"]
[null,"TOP","Pa’anga"]
[null,"PKR","Pakistan Rupee"]
[null,"MOP","Pataca"]
[null,"CUC","Peso Convertible"]
[null,"UYU","Peso Uruguayo"]
[null,"PHP","Philippine Peso"]
[null,"GBP","Pound Sterling"]
[null,"BWP","Pula"]
[null,"QAR","Qatari Rial"]
[null,"GTQ","Quetzal"]
[null,"ZAR","Rand"]
[null,"OMR","Rial Omani"]
[null,"KHR","Riel"]
[null,"MVR","Rufiyaa"]
[null,"IDR","Rupiah"]
[null,"RUB","Russian Ruble"]
[null,"RWF","Rwanda Franc"]
[null,"SHP","Saint Helena Pound"]
[null,"SAR","Saudi Riyal"]
[null,"RSD","Serbian Dinar"]
[null,"SCR","Seychelles Rupee"]
[null,"SGD","Singapore Dollar"]
[null,"SBD","Solomon Islands Dollar"]
[null,"KGS","Som"]
[null,"SOS","Somali Shilling"]
[null,"TJS","Somoni"]
[null,"SSP","South Sudanese Pound"]
[null,"LKR","Sri Lanka Rupee"]
[null,"SDG","Sudanese Pound"]
[null,"SRD","Surinam Dollar"]
[null,"SEK","Swedish Krona"]
[null,"CHF","Swiss Franc"]
[null,"SYP","Syrian Pound"]
[null,"BDT","Taka"]
[null,"WST","Tala"]
[null,"TZS","Tanzanian Shilling"]
[null,"KZT","Tenge"]
[null,"TTD","Trinidad and Tobago Dollar"]
[null,"MNT","Tugrik"]
[null,"TND","Tunisian Dinar"]
[null,"TRY","Turkish Lira"]
[null,"TMT","Turkmenistan New Manat"]
[null,"AED","UAE Dirham"]
[null,"UGX","Uganda Shilling"]
[null,"CLF","Unidad de Fomento"]
[null,"COU","Unidad de Valor Real"]
[null,"UYI","Uruguay Peso en Unidades Indexadas"]
[null,"USD","US Dollar"]
[null,"USN","US Dollar (Next day)"]
[null,"UZS","Uzbekistan Sum"]
[null,"VUV","Vatu"]
[null,"CHE","WIR Euro"]
[null,"CHW","WIR Franc"]
[null,"KRW","Won"]
[null,"YER","Yemeni Rial"]
[null,"JPY","Yen"]
[null,"CNY","Yuan Renminbi"]
[null,"ZMW","Zambian Kwacha"]
[null,"ZWL","Zimbabwe Dollar"]
[null,"PLN","Zloty"]