{"text_format":"1","workbook":"xlsx","n_sheets":43,"sheets":["Index","Compte-épargne-SI-simple","Appels","Commande","Bonus-avec-a.r.","Audit-fonction-OU","Allocations-OU","Audit-fonction-ET","Liste-SI-divers","SI-Imbriqués","Articles-SI-imbriqués","Prix-SI-imbriqués","Liste - salaires","Liste-salaires-RECHERCHEV","Liste-ventes","Liste-ventes-RECHERCHEV","Conversion-monnaie","Valeur proche 1","Valeur proche 2","Exact ou proche 1","Exact ou proche 2","RECHERCHEH","RECHERCHE","Devises - SI imbriqués","Recherchev avec astérisques","FONCTIONS ERREUR et INFORMATION","RECHERCHEV - SIERREUR 1","RECHERCHEV - SIERREUR 2","Echéancier - SIERREUR 3","Arrondis-et-multiples","Prix-arrondi.au.multiple","Banque-arrondi.au.multiple","Devis avec remise","SPECIAL","EST.PAIR-EST.IMPAIR et MOD","ENT","Fonctions-texte","Concaténer","Scinder colonnes","Extraction-texte","Extraction + Recherchev","Dates-et-texte","Ecartype"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":8,"defined_names":120,"comments":5,"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":"Index","index":0,"n_rows":51,"n_cols":2,"rows_kept":51,"cut":false,"hidden":false,"merged":[[28,0,28,1],[29,0,29,1]]}
["Contenu"]
[]
["La fonction SI - simple"]
["La fonction SI - avec ET / OU"]
["La fonction SI - imbriquée"]
[null,"Compte-épargne-si-simple"]
[null,"Appels-si-simple"]
[null,"Commande-si-simple"]
[null,"Bonus-avec-a.r."]
[null,"Audit-fonction-OU"]
[null,"Allocations-OU"]
[null,"Audit-fonction-ET"]
[null,"Liste-si-divers"]
[null,"Si imbriqués"]
[null,"Articles-si-imbriqués"]
[null,"Prix-si-imbriqués"]
["RECHERCHEV et RECHERCHEH !!!"]
[null,"Liste - salaires"]
[null,"Liste-salaires-RECHERCHEV"]
[null,"Liste-ventes"]
[null,"Liste-ventes-RECHERCHEV"]
[null,"Conversion-monnaie"]
[null,"Valeur proche 1"]
[null,"Valeur proche 2"]
[null,"Exact ou proche 1 ?"]
[null,"Exact ou proche 2 ?"]
[null,"RECHERCHEH"]
[null,"RECHERCHE"]
["Montants en devises (SI imbriqués + RECHERCHEV + SOMME.SI)"]
["RECHERCHEV avec des astérisques"]
["Fonctions d'erreur et d'information"]
[null,"Exo simple avec ESTVIDE"]
[null,"RECHERCHEV - SIERREUR 1"]
[null,"RECHERCHEV - SIERREUR 2"]
[null,"RECHERCHEV - SIERREUR 3"]
["Si le temps le permet :"]
[null,"Arrondis-et-multiples"]
[null,"Prix-arrondi.au.multiple"]
[null,"Banque-arrondi.au.multiple"]
[null,"Devis avec remise"]
["Spécial"]
[null,"Fonction math : MOD et EST.PAIR/IMPAIR"]
[null,"Fonction math : ENT"]
[null,"Fonctions-texte"]
[null,"Concaténer"]
[null,"Inverse de concaténer (Assistant)"]
[null,"Extraction-texte"]
[null,"Extraction + Recherchev"]
[null,"Date-et-texte"]
["Pour info : écart type"]
[null,"Exemple bancaire"]

{"sheet":"Compte-épargne-SI-simple","index":1,"n_rows":34,"n_cols":3,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,0,0,2],[23,0,23,2]]}
["Compte d'épargne"]
["Année","Dépenses","A payer"]
[2011,650]
[2012,8850]
[2013,10740]
[2014,9990]
[2015,10000]
[2016,10420]
[2017,6780]
[2018,1200]
[2019,19350]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Compte d'épargne"]
[{"$f":"A2","v":"Année"},"Dépenses",{"$f":"C2","v":"A payer"}]
[2011,650,{"$f":"IF(B26<=10000,50,\"\")","v":50}]
[2012,8850,{"$f":"IF(B27<=10000,50,\"\")","v":50}]
[2013,10740,""]
[2014,9990,50]
[2015,10000,50]
[2016,10420,""]
[2017,6780,50]
[2018,1200,50]
[2019,19350,""]

{"sheet":"Appels","index":2,"n_rows":44,"n_cols":7,"rows_kept":44,"cut":false,"hidden":false,"merged":[[8,1,8,4],[31,1,31,4]]}
[]
[]
[null,"ORDI-HELP SA"]
[null,"Nous répondons toujours présents !"]
[]
[]
["Appels clients"]
[]
[null,"2020-08-01"]
["Collaborateur","Semaine 1","Semaine 2","Semaine 3","Semaine 4","Total appels","Commentaire"]
["Marc Donzel",186,165,196,189,{"$f":"SUM(B11:E11)","v":736}]
["Tom Smith",132,163,145,158,598]
["Paul Dupont",164,178,184,163,689]
["Serena Durant",169,152,143,197,661]
["Julie Aubert",195,171,164,169,699]
["Charles Auberson",191,175,201,176,743]
["Cathy Wilson",214,212,218,197,841]
["Laurent Blumberg",218,203,194,186,801]
["Totaux",{"$f":"SUM(B11:B18)","v":1469},{"$f":"SUM(C11:C18)","v":1419},{"$f":"SUM(D11:D18)","v":1445},{"$f":"SUM(E11:E18)","v":1435},{"$f":"SUM(F11:F18)","v":5768}]
[]
["Moyenne",{"$f":"AVERAGE(F11:F18)","v":721}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"B9","v":"2020-08-01"}]
["Collaborateur","Semaine 1","Semaine 2","Semaine 3","Semaine 4","Total appels",{"$f":"G10","v":"Commentaire"}]
["Marc Donzel",186,165,196,189,736,{"$f":"IF(F34>=$B$44,\"au-dessus de la moyenne\",\"\")","v":"au-dessus de la moyenne"}]
["Tom Smith",132,163,145,158,598,{"$f":"IF(F35>=$B$44,\"au-dessus de la moyenne\",\"\")","v":""}]
["Paul Dupont",164,178,184,163,689,""]
["Serena Durant",169,152,143,197,661,""]
["Julie Aubert",195,171,164,169,699,""]
["Charles Auberson",191,175,201,176,743,"au-dessus de la moyenne"]
["Cathy Wilson",214,212,218,197,841,"au-dessus de la moyenne"]
["Laurent Blumberg",218,203,194,186,801,"au-dessus de la moyenne"]
["Totaux",1469,1419,1445,1435,5768]
[]
["Moyenne",721]

{"sheet":"Commande","index":3,"n_rows":29,"n_cols":5,"rows_kept":29,"cut":false,"hidden":false,"merged":[[8,0,8,2],[25,0,25,2]]}
[null,"Commande"]
[]
["Pièces","Quantité Commandée","Quantité Disponible","Quantité Livrée","Reste à livrer"]
["Stylo",50,45]
["Gomme",37,51]
["Crayon couleur",12,15]
["Crayon papier",75,47]
["Effaceur",8,10]
["Total",null,null,{"$f":"SUM(D4:D8)","v":0},{"$f":"SUM(E4:E8)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"A3","v":"Pièces"},"Quantité Commandée","Quantité Disponible","Quantité Livrée","Reste à livrer"]
["Stylo",50,45,{"$f":"IF(B21>C21,C21,B21)","v":45},{"$f":"IF(B21>C21,B21-C21,0)","v":5}]
["Gomme",37,51,{"$f":"IF(B22>C22,C22,B22)","v":37},{"$f":"IF(B22>C22,B22-C22,0)","v":0}]
["Crayon couleur",12,15,{"$f":"IF(B23>C23,C23,B23)","v":12},{"$f":"IF(B23>C23,B23-C23,0)","v":0}]
["Crayon papier",75,47,{"$f":"IF(B24>C24,C24,B24)","v":47},{"$f":"IF(B24>C24,B24-C24,0)","v":28}]
["Effaceur",8,10,{"$f":"IF(B25>C25,C25,B25)","v":8},{"$f":"IF(B25>C25,B25-C25,0)","v":0}]
["Total",null,null,{"$f":"SUM(D21:D25)","v":149},{"$f":"SUM(E21:E25)","v":33}]
[]
[null,null,"D21","=SI(B21>C21;C21;B21)"]
[null,null,"E21","=SI(B21>C21;B21-C21;0)"]

{"sheet":"Bonus-avec-a.r.","index":4,"n_rows":42,"n_cols":6,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[]
[null,"DUPONT","DURAND","MARTIN","DUVAL","AUBRY"]
[null,"Juin","Juin","Juin","Juin","Juin"]
["Salaire de base",5000,5000,5000,5000,5000]
[]
["Ventes",10000,7896.5,11500,10000,8036]
["Divers",456,875,750,541,796]
["Ventes totales",{"$f":"SUM(B6:B7)","v":10456},{"$f":"SUM(C6:C7)","v":8771.5},{"$f":"SUM(D6:D7)","v":12250},{"$f":"SUM(E6:E7)","v":10541},{"$f":"SUM(F6:F7)","v":8832}]
["Pourcentage de prime"]
[]
["Salaire avec prime",{"$f":"B4+(B8*B9)","v":5000},{"$f":"C4+(C8*C9)","v":5000},{"$f":"D4+(D8*D9)","v":5000},{"$f":"E4+(E8*E9)","v":5000},{"$f":"F4+(F8*F9)","v":5000}]
[]
["objectif spécial",10500]
["prime spéciale",0.03]
["prime normale",0.02]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"B2","v":"DUPONT"},"DURAND","MARTIN","DUVAL","AUBRY"]
[null,"Juin","Juin","Juin","Juin","Juin"]
["Salaire de base",5000,5000,5000,5000,5000]
[]
["Ventes",10000,7896.5,11500,10000,8036]
["Divers",456,875,750,541,796]
["Ventes totales",10456,8771.5,12250,10541,8832]
["Pourcentage de prime",{"$f":"IF(B35>=$B$40,$B$41,$B$42)","v":0.02},{"$f":"IF(C35>=$B$40,$B$41,$B$42)","v":0.02},{"$f":"IF(D35>=$B$40,$B$41,$B$42)","v":0.03},{"$f":"IF(E35>=$B$40,$B$41,$B$42)","v":0.03},{"$f":"IF(F35>=$B$40,$B$41,$B$42)","v":0.02}]
[]
[{"$f":"A11","v":"Salaire avec prime"},{"$f":"B31+(B35*B36)","v":5209.12},{"$f":"C31+(C35*C36)","v":5175.43},{"$f":"D31+(D35*D36)","v":5367.5},{"$f":"E31+(E35*E36)","v":5316.23},{"$f":"F31+(F35*F36)","v":5176.6400000000003}]
[]
[{"$f":"A13","v":"objectif spécial"},10500]
["prime spéciale",0.03]
["prime normale",0.02]

{"sheet":"Audit-fonction-OU","index":5,"n_rows":28,"n_cols":3,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Dépenses","Résultat"]
["Janvier",25000]
["Février",24800]
["Mars",30000]
["Avril",32000]
["Mai",33000]
["Juin",27000]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"B2","v":"Dépenses"},"Résultat"]
["Janvier",25000,{"$f":"IF(OR(B23>30000,B23<25000),\"problème\",\"\")","v":""}]
["Février",24800,"problème"]
["Mars",30000,""]
["Avril",32000,"problème"]
["Mai",33000,"problème"]
["Juin",27000,""]

{"sheet":"Allocations-OU","index":6,"n_rows":21,"n_cols":8,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,1,0,6],[18,0,20,0]]}
[null,"Vous êtes chargé de distribuer une allocation spéciale selon les critères suivants : Sfr. 1'000.00 aux personnes ayant un revenu inférieur à 40'000 OU à ceux ayant plus de 2 enfants. \nLes autres reçoivent Sfr. 500.00 d'allocations.",null,null,null,null,null,"© Corinne Leuba"]
[]
[]
["Nom","Revenu annuel","Nombre d'enfants","Allocation","Réponse macro",null,"Alloc. Max",1000]
["Dupond",45000,2,null,null,null,"Alloc. Normale",500]
["Dupont",55000,2]
["Durand",28000,3]
["Grand",121000,4]
["Grosjean",98000,5]
["Martin",18900,3]
["Michel",51500,1]
["Muller",66000,2]
["Petit",55000,1]
["Petitjean",57000,1]
["Rossi",29500,0]
["Sanchez",31000,5]
["Sancho",30000,4]
[]
["Nombre d'allocations",10000]
[null,500]
[null,"Total :",{"$f":"SUM(C19:C20)","v":0},{"$f":"SUM(D19:D20)","v":0}]

{"sheet":"Audit-fonction-ET","index":7,"n_rows":39,"n_cols":4,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Dépenses","Nombre d'employés","Audit"]
["Janvier",25000,45]
["Février",24800,44]
["Mars",30000,50]
["Avril",32000,55]
["Mai",33000,58]
["Juin",27000,49]
["Juillet",50500,80]
["Août",60000,90]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"B2","v":"Dépenses"},"Nombre d'employés","Audit"]
["Janvier",25000,45,{"$f":"IF(AND(B27<=50000,C27<=70),\"\",\"travailleurs saisonniers\")","v":""}]
["Février",24800,44,{"$f":"IF(AND(B28<=50000,C28<=70),\"\",\"travailleurs saisonniers\")","v":""}]
["Mars",30000,50,""]
["Avril",32000,55,""]
["Mai",33000,58,""]
["Juin",27000,49,""]
["Juillet",50500,80,"travailleurs saisonniers"]
["Août",60000,90,"travailleurs saisonniers"]
[null,50000,71,"travailleurs saisonniers"]
[]
["* Ceci est vraiment un exercice juste pour pratiquer la combinaison d'un SI avec un OU extra simple"]
["car 1 possibilité échappe au OU et donne une réponse très \"discutable\" ! : "]
["dépenses = 50'000 et employés > 70"]

{"sheet":"Liste-SI-divers","index":8,"n_rows":35,"n_cols":9,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,0,0,7]]}
["Si simple ou en imbrication avec ET"]
[]
["Nom","Prénom","Age","Ville","Salaire","Test 1\nGE ou Confédéré ?","Test 2\nRetraité ou non ?","Test 3\nSalaire moyen ?","Test 4\nCadre GE actif ?"]
["Appolinaire","Guillaume",45,"Genève",5400]
["Baudelaire","Charles",21,"Lausanne",6300]
["Camus","Albert",68,"Genève",8000]
["De Balzac","Honoré",52,"Genève",6100]
["De Chateaubriand","François-René",38,"Neuchatel",6100]
["Freud","Sigmund",65,"Lausanne",5800]
["Hugo","Victor",71,"Genève",7200]
["Kant","Emmanuel",35,"Neuchatel",3800]
["Nietzche","Friedrich",45,"Fribourg",8500]
["Racine","Pierre",56,"Genève",4300]
["Rousseau","Jean-Jacques",52,"Fribourg",6800]
["Sade","Donatien",34,"Genève",6700]
["Sarte","Jean-Paul",55,"Fribourg",4200]
["Zola","Emile",80,"Lausanne",6400]
[]
["Test 1","Si la personne habite Genève, alors inscrire \"Genevois\", sinon inscrire \"Confédéré\""]
["Test 2","Si la personne est agée de plus de 65 ans, inscrire \"Retraité\", sinon afficher le nombre d'années lui restant avant la retraite"]
["Test 3","Si la personne gagne entre Frs 5'000 et 6'000, inscrire \"Salaire cadre moyen\", sinon ne rien inscrire"]
["Test 4","Si la personne est agée de moins de 65 ans, habite Genève et gagne plus de 6'000 francs :inscrire \"cadre GE actif\", sinon rien"]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"A3","v":"Nom"},{"$f":"B3","v":"Prénom"},"Age","Ville","Salaire","Test 1\nGE ou Confédéré ?","Test 2\nRetraité ou non ?","Test 3\nSalaire moyen ?","Test 4\nCadre GE actif ?"]
[{"$f":"A4","v":"Appolinaire"},{"$f":"B4","v":"Guillaume"},45,"Genève",5400,{"$f":"IF(D32=\"Genève\",\"Genevois\",\"Confédéré\")","v":"Genevois"},{"$f":"IF(C32>65,\"Retraité\",65-C32)","v":20},{"$f":"IF(AND(E32>5000,E32<6000),\"Salaire cadre moyen\",\"\")","v":"Salaire cadre moyen"},{"$f":"IF(AND(C32<65,D32=\"Genève\",E32>6000),\"cadre GE actif\",\"\")","v":""}]
[{"$f":"A5","v":"Baudelaire"},"Charles",21,"Lausanne",6300,{"$f":"IF(D33=\"Genève\",\"Genevois\",\"Confédéré\")","v":"Confédéré"},{"$f":"IF(C33>65,\"Retraité\",65-C33)","v":44},{"$f":"IF(AND(E33>5000,E33<6000),\"Salaire cadre moyen\",\"\")","v":""},{"$f":"IF(AND(C33<65,D33=\"Genève\",E33>6000),\"cadre GE actif\",\"\")","v":""}]
[{"$f":"A6","v":"Camus"},"Albert",68,"Genève",8000,{"$f":"IF(D34=\"Genève\",\"Genevois\",\"Confédéré\")","v":"Genevois"},{"$f":"IF(C34>65,\"Retraité\",65-C34)","v":"Retraité"},{"$f":"IF(AND(E34>5000,E34<6000),\"Salaire cadre moyen\",\"\")","v":""},{"$f":"IF(AND(C34<65,D34=\"Genève\",E34>6000),\"cadre GE actif\",\"\")","v":""}]
[{"$f":"A7","v":"De Balzac"},"Honoré",52,"Genève",6100,{"$f":"IF(D35=\"Genève\",\"Genevois\",\"Confédéré\")","v":"Genevois"},{"$f":"IF(C35>65,\"Retraité\",65-C35)","v":13},{"$f":"IF(AND(E35>5000,E35<6000),\"Salaire cadre moyen\",\"\")","v":""},{"$f":"IF(AND(C35<65,D35=\"Genève\",E35>6000),\"cadre GE actif\",\"\")","v":"cadre GE actif"}]

{"sheet":"SI-Imbriqués","index":9,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
["On veut trois possibilités : erreur comptable - à réduire absolument - normal"]
[]
[null,"Dépenses","Audit","Réponse"]
["Janvier",25000]
["Février",24800]
["Mars",30000]
["Avril",32000]
["Mai",33000]
["Juin",27000]

{"sheet":"Articles-SI-imbriqués","index":10,"n_rows":32,"n_cols":5,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Commande"]
["Article ","Mode","Relais colis","Ville","Livraison - à transmettre au dpt concerné"]
[5623.23,"Jupe-femme","Oui","Genève"]
[9643.25,"Couette","Non","Genève"]
[5632.85,"Pantalon-homme","Oui","Lausanne"]
[9653.24,"Drap housse","Non","Lausanne"]
[5523.58,"Parure de lit","Oui","Genève"]
[9325.23,"Robe-femme","Non","Genève"]
[5624.25,"Veste-homme","Oui","Lausanne"]
[9826.36,"Drap housse","inconnu","Lausanne"]
[]
["Si la commande concerne Jupe-femme : Rupture de stock momentanée"]
["Si la livraison est en Relais colis (Oui) : Livraison à votre adresse relais habituelle"]
["Si la livraison n'est pas en Relais colis (Non) : Livraison par courrier postal"]
["Autre cas : Infos non utilisables"]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"A2","v":"Article "},{"$f":"B2","v":"Mode"},"Relais colis","Ville",{"$f":"E2","v":"Livraison - à transmettre au dpt concerné"}]
[{"$f":"A3","v":5623.23},{"$f":"B3","v":"Jupe-femme"},"Oui","Genève",{"$f":"IF(B25=\"Jupe-femme\",\"Rupture de stock momentanée\",IF(C25=\"Oui\",\"Livraison à votre adresse relais habituelle\",IF(C3=\"Non\",\"Livraison par courrier postal\",\"Infos non utilisables\")))","v":"Rupture de stock momentanée"}]
[{"$f":"A4","v":9643.25},"Couette","Non","Genève",{"$f":"IF(B26=\"Jupe-femme\",\"Rupture de stock momentanée\",IF(C26=\"Oui\",\"Livraison à votre adresse relais habituelle\",IF(C4=\"Non\",\"Livraison par courrier postal\",\"Infos non utilisables\")))","v":"Livraison par courrier postal"}]
[{"$f":"A5","v":5632.85},"Pantalon-homme","Oui","Lausanne","Livraison à votre adresse relais habituelle"]
[{"$f":"A6","v":9653.24},"Drap housse","Non","Lausanne","Livraison par courrier postal"]
[{"$f":"A7","v":5523.58},"Parure de lit","Oui","Genève","Livraison à votre adresse relais habituelle"]
[{"$f":"A8","v":9325.23},"Robe-femme","Non","Genève","Livraison par courrier postal"]
[{"$f":"A9","v":5624.25},"Veste-homme","Oui","Lausanne","Livraison à votre adresse relais habituelle"]
[{"$f":"A10","v":9826.36},"Drap housse","inconnu","Lausanne","Infos non utilisables"]

{"sheet":"Prix-SI-imbriqués","index":11,"n_rows":27,"n_cols":6,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,0,0,5],[20,0,20,5]]}
["Prix"]
[]
["Désignation","Prix","Origine\nE = Europe","Poids \nen gr.","Taxe","Total"]
["Produit 1",100,"E",4000,null,{"$f":"B4+E4","v":100}]
["Produit 2",200,"E",6000,null,{"$f":"B5+E5","v":200}]
["Produit 3",500,"NON E",3000,null,{"$f":"B6+E6","v":500}]
["Produit 4",300,"NON E",8000,null,{"$f":"B7+E7","v":300}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Prix"]
[]
[{"$f":"A3","v":"Désignation"},"Prix","Origine\nE = Europe","Poids \nen gr.","Taxe","Total"]
["Produit 1",100,"E",4000,{"$f":"IF(AND(C24=\"E\",D24<=5000),B24*10%,IF(AND(C24=\"E\",D24>5000),B24*15%,B24*25%))","v":10},{"$f":"B24+E24","v":110}]
["Produit 2",200,"E",6000,{"$f":"IF(AND(C25=\"E\",D25<=5000),B25*10%,IF(AND(C25=\"E\",D25>5000),B25*15%,B25*25%))","v":30},{"$f":"B25+E25","v":230}]
["Produit 3",500,"NON E",3000,{"$f":"IF(AND(C26=\"E\",D26<=5000),B26*10%,IF(AND(C26=\"E\",D26>5000),B26*15%,B26*25%))","v":125},{"$f":"B26+E26","v":625}]
["Produit 4",300,"NON E",8000,{"$f":"IF(AND(C27=\"E\",D27<=5000),B27*10%,IF(AND(C27=\"E\",D27>5000),B27*15%,B27*25%))","v":75},{"$f":"B27+E27","v":375}]

{"sheet":"Liste - salaires","index":12,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
["NO AVS","NOM","PRENOM","DATE ENTREE","SALAIRE BRUT"]
["123.25.563.588","FERNAL","Alain","2013-01-23",25000]
["123.52.123.698","MAGNE","Charles","2009-05-14",15000]
["125.23.587.458","TRANSEN","Jean","2017-02-12",15000]
["146.96.256.546","DE PAUL","Vincent","2012-11-15",9000]
["156.98.569.231","HAULIT","Amélie","2019-08-25",8000]
["263.12.258.147","LESBAINS","Amélie","2009-08-25",6000]
["281.65.259.515","DRAK","Ulla","2013-01-23",10000]
["281.96.145.119","LEDEB-HOCHET","Raphaël","2017-02-12",8000]
["598.56.458.952","PASBON","Vincent","2010-11-15",8000]
["963.56.231.258","HIBULAIRE","Pat","2008-03-16",10000]
["987.56.231.247","HACHOU","Pat","2008-03-16",7000]

{"sheet":"Liste-salaires-RECHERCHEV","index":13,"n_rows":40,"n_cols":4,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[]
[]
["No AVS","Qui ?"]
["281.65.259.515",null,null,"Attention lors de la sélection de la table ! Avec la ligne des libellés (nom) ou sans ?"]
["156.98.569.231"]
["123.25.563.588"]
["598.56.458.953"]
[]
[]
["No AVS","En valeur exacte"]
["281.65.259.515",{"$f":"VLOOKUP(A11,'Liste - salaires'!$A$2:$E$13,2,FALSE)","v":"DRAK"}]
["156.98.569.231",{"$f":"VLOOKUP(A12,'Liste - salaires'!$A$2:$E$13,2,FALSE)","v":"HAULIT"}]
["123.25.563.588",{"$f":"VLOOKUP(A13,'Liste - salaires'!$A$2:$E$13,2,FALSE)","v":"FERNAL"}]
["598.56.458.953",{"$f":"VLOOKUP(A14,'Liste - salaires'!$A$2:$E$13,2,FALSE)","v":{"$error":"#N/A"}}]
[]
[]
["No AVS","En valeur approximative ou proche"]
["281.65.259.515",{"$f":"VLOOKUP(A18,'Liste - salaires'!$A$2:$E$13,2)","v":"DRAK"}]
["156.98.569.231",{"$f":"VLOOKUP(A19,'Liste - salaires'!$A$2:$E$13,2)","v":"HAULIT"}]
["123.25.563.588",{"$f":"VLOOKUP(A20,'Liste - salaires'!$A$2:$E$13,2)","v":{"$error":"#N/A"}}]
["598.56.458.953",{"$f":"VLOOKUP(A21,'Liste - salaires'!$A$2:$E$13,2)","v":"PASBON"}]
[]
[]
["No AVS","Avec une liste nommée"]
[]
[]
[]
[]
[]
[]
[]
["Caractéristiques de la fonction RECHERCHEV : "]
[null,"- la colonne \"index\" doit toujours être la première du tableau sélectionné (pas nécessairement la 1ère col. de la liste)"]
[null,"- la fonction ne sait pas reconnaître la colonne B, I, J, L .. elle sait juste COMPTER les colonnes"]
[null,"- la fonction ne peut pas chercher en \"reculant\" - elle va toujours depuis la colonne \"index\" vers la droite"]
[null,"- si la fonction travaille en valeur exacte : l'ordre de la colonne \"index\" est indifférent - si elle travaille en valeur proche : elle doit être triée par ordre ascendant"]
[]
[]
["info suppl.","- si la fonction travaille sur une liste qui est régulièrement mise à jour et à laquelle des lignes sont souvent ajoutées, alors il serait judicieux de nommer cette liste"]
[null," comme cela, il suffira de modifier les références associées à la zone nommée 1 seule fois ! et non dans chaque utilisation de la fonction !!!!"]

{"sheet":"Liste-ventes","index":14,"n_rows":25,"n_cols":8,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
["Facture no","Code Client","Date Fact","Qte","Prix/unité","Montant","Vendeur","Produit"]
[100,23,"2019-12-15",1,100.5,{"$f":"D3*E3","v":100.5},"BRUNO","EAO"]
[101,1,"2019-12-19",3,120.6,361.79999999999995,"FRANCOIS","EAO"]
[102,5,"2020-01-12",2,111,222,"MICHEL","Bureautique"]
[103,5,"2020-02-04",4,111.95,447.8,"BRUNO","EAO"]
[104,23,"2020-02-25",1,88.5,88.5,"ARNAUD","Langages"]
[105,58,"2020-03-05",2,77.3,154.6,"BRUNO","EAO"]
[106,47,"2020-04-06",3,68.25,204.75,"ARNAUD","Langages"]
[107,95,"2020-04-10",7,89.5,626.5,"MICHEL","Langages"]
[108,23,"2020-04-13",4,95,380,"FRANCOIS","EAO"]
[109,58,"2020-04-16",3,73.25,219.75,"BRUNO","EAO"]
[110,1,"2020-04-19",6,84.75,508.5,"FRANCOIS","Langages"]
[111,47,"2020-05-01",12,99.9,1198.8000000000002,"BRUNO","Langages"]
[112,62,"2020-05-02",13,100.3,1303.8999999999999,"BRUNO","Bureautique"]
[113,58,"2020-06-08",8,110,880,"MICHEL","Jeux"]
[114,19,"2020-06-18",1,130.6,130.6,"ARNAUD","Bureautique"]
[115,1,"2020-07-22",1,56.3,56.3,"FRANCOIS","Bureautique"]
[116,85,"2020-07-25",9,25.9,233.1,"ARNAUD","Bureautique"]
[117,85,"2020-08-01",6,25,150,"MICHEL","Langages"]
[118,1,"2020-08-10",4,3,12,"BRUNO","Bureautique"]
[119,23,"2020-09-13",3,49.5,148.5,"FRANCOIS","Bureautique"]
[120,58,"2020-10-17",8,29.9,239.2,"ARNAUD","EAO"]
[121,8,"2020-11-02",2,18.600000000000001,37.200000000000003,"MICHEL","Bureautique"]
[122,8,"2020-12-30",7,88.9,622.30000000000007,"BRUNO","Langages"]

{"sheet":"Liste-ventes-RECHERCHEV","index":15,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Quelle vente (montant total) a été réalisée pour la facture  :"]
[null,null,"Réponse macro"]
[106]
[112]
[120]
[125]
[]
[]
["Quel est le montant de la première vente faite pour le client no : "]
[null,null,"Réponse macro"]
[1]
[58]
[73]
[43]
[8]
[95]
[88]

{"sheet":"Conversion-monnaie","index":16,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
["Monnaie","Montant en monnaie étrangère","Montant en Frs","Réponse macro"]
["$ Mexique",1000,null,null,null,"Taux de change fictif"]
["Kr Suède",1000,null,null,null,"$ Etats-Unis",2]
["$ Etats-Unis",1000,null,null,null,"$ Mexique",3]
["Kr Suède",1000,null,null,null,"£ Angleterre",4]
["£ Angleterre",2000,null,null,null,"Kr Suède",5]
["$ Mexique",5000]
["Kr Suède",4000]
["$ Etats-Unis",1000]
["£ Angleterre",2000]
["$ Mexique",8000]
["EURO",1000]

{"sheet":"Valeur proche 1","index":17,"n_rows":19,"n_cols":8,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
["Lorsqu'il est nécessaire de laisser la fonction CHERCHER LA VALEUR LA PLUS PROCHE !"]
[]
["M  DANS CE CAS IL EST OBLIGATOIRE QUE LA COLONNE \"INDEX\" "]
["DE LA TABLE DE RECHERCHE SOIT TRIEE PAR ORDRE ASCENDANT !!!!!"]
[]
[]
[null,null,null,null,null,null,"Table de recherche"]
["Date","Prix","Code","Réponse macro",null,null,"Critère","Code"]
["2020-06-10",150,null,null,null,null,0,1]
["2020-06-11",352,null,null,null,null,50,2]
["2020-06-12",12,null,null,null,null,100,3]
["2020-06-13",99,null,null,null,null,150,4]
["2020-06-14",101,null,null,null,null,200,5]
["2020-06-15",151,null,null,null,null,250,6]
["2020-06-16",487,null,null,null,null,300,7]
["2020-06-17",403,null,null,null,null,350,8]
[null,null,null,null,null,null,400,9]
[null,null,null,null,null,null,450,10]

{"sheet":"Valeur proche 2","index":18,"n_rows":20,"n_cols":7,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,0,1,3]]}
[]
["Le nom de la banque dépend du taux d'intérêt !!!",null,null,null,null,"Taux","Nom"]
[null,null,null,null,null,0,"Impossible ! Vous divaguez …"]
["Montant (hypothèque en France)",400000,null,null,null,8.0000000000000002E-3,"Banque du petit chançeux !"]
["Intérêt",0.03,null,null,null,0.01,"Banque normale"]
["Nombre d'années",20,null,null,null,1.4999999999999999E-2,"Banque des ogres"]
[null,null,null,null,null,0.02,"Gang de requins"]
["Echéancier de remboursement",null,null,null,null,0.03,"Stop arnaque !!"]
["Année","Intérêt","Amortissement","Annuité"]
[1,{"$f":"-IPMT($B$5,A10,$B$6,$B$4)","v":12000},{"$f":"-PPMT($B$5,A10,$B$6,$B$4)","v":14886.283038743653},{"$f":"-PMT($B$5,B6,$B$4)","v":26886.283038743648}]
[3,11093.42536294051,15792.857675803141]
[5,10131.640330484099,16754.642708259551]
[7,9111.2825895510923,17775.000449192557]
[9,8028.7850621952657,18857.497976548384]
[11,6880.3634354234682,20005.919603320184,null,null,"* Correspond au paysage bancaire France pour hypothèque "]
[13,5662.0029315812699,21224.28010716238,null,null,"ou Suisse pour crédit à la consommation"]
[15,4369.4442730550809,22516.838765688568]
[17,2998.1687922246469,23888.114246519002]
[19,1543.3826346116396,25342.900404132008]
[20,783.09562248767918,26103.187416255972]

{"sheet":"Exact ou proche 1","index":19,"n_rows":24,"n_cols":5,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,1,0,5]]}
[null,"Frais bancaires. Retrouvez les frais pour les mois indiqués. EXACT ou PROCHE ?"]
[]
["Mois","Dépenses","Recettes","Solde à nouveau","Frais"]
["Janvier",65000,75000,55000,{"$f":"IF(D4>=0,D4*0.001,-D4*0.00045)","v":55}]
["Février",85000,13000,{"$f":"D4+(C5-B5)-E4","v":-17055},7.6747499999999995]
["Mars",74000,36000,-55062.674749999998,24.778203637499999]
["Avril",11000,18000,-48087.452953637498,21.639353829136873]
["Mai",15500,19000,-44609.092307466635,20.074091538359987]
["Juin",14200,26000,-32829.166399004993,14.773124879552247]
["Juillet",8400,95000,53756.060476115454,53.756060476115458]
["Août",12000,22000,63702.304415639337,63.70230441563934]
["Septembre",13500,26000,76138.602111223707,76.138602111223705]
["Octobre",26000,55000,105062.46350911248,105.06246350911248]
["Novembre",8700,42000,138257.40104560336,138.25740104560336]
["Décembre",25000,78000,191119.14364455774,191.11914364455774]
[]
[]
[]
[]
["Quels sont nos frais pour : "]
[null,null,"Réponse macro"]
["Février"]
["Juin"]
["Décembre"]

{"sheet":"Exact ou proche 2","index":20,"n_rows":20,"n_cols":7,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
[null,"Les gens sont classés selon leur grandeur. Indiquez leur catégorie : EXACT ou PROCHE ?"]
[]
["Nom","Taille","Catégorie","Réponse macro",null,"Taille","Catégorie"]
["Dupond",1.52,null,null,null,0,"petit"]
["Dupont",1.73,null,null,null,1.6,"moyen"]
["Durand",1.69,null,null,null,1.8,"grand"]
["Grand",1.9]
["Grosjean",1.63]
["Martin",1.79]
["Michel",1.77]
["Muller",1.81]
["Petit",1.85]
["Petitjean",1.59]
["Rossi",1.71]
["Sanchez",1.63]
["Sancho",1.79]
[]
["Nombre de :","petit"]
["Nombre de :","moyen"]
["Nombre de :","grand"]

{"sheet":"RECHERCHEH","index":21,"n_rows":19,"n_cols":12,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[null,"FONCTION RECHERCHEH"]
["Mois","Ventes","Code","Réponse macro"]
["Janvier",3542]
["Février",4563]
["Mars",4123]
["Avril",4236]
["Mai",5412]
["Juin",3256]
["Juillet",4593]
["Août",2356]
["Septembre",1236]
["Octobre",3524]
["Novembre",3625]
["Décembre",1452]
[]
[]
["Table"]
["Ventes",1000,1500,2000,2500,3000,3500,4000,4500,5000,5500,6000]
["Code",100,200,300,400,500,600,700,800,900,1000,1100]

{"sheet":"RECHERCHE","index":22,"n_rows":32,"n_cols":6,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,0,1,3]]}
["FONCTION RECHERCHE"]
["Dans le second tableau affichez le nom et la catégorie des participant selon le n° de dossard avec les données du 1er tableau."]
[]
["Participants","N° dossard","Catégorie"]
["Catherine",125,"Junior"]
["Claire",126,"Cadet A"]
["Isabelle",127,"Cadet B"]
["Philippe",128,"Senior"]
["Jean",129,"Cadet B"]
["Kevin",130,"Junior"]
["Paul",131,"Senior"]
["Marie",132,"Cadet A"]
["Paola",133,"Junior"]
[]
["Temps","N° dossard","Participants","Catégorie","Réponse","Réponse"]
["22:33:00",130]
["20:00:00",132]
["21:44:00",133]
["22:22:00",131]
["19:44:00",127]
[]
[]
[]
["Syntaxe"]
["Syntaxe : =RECHERCHE(valeur_cherchée;vecteur_recherche;vecteur_résultat)",null,null,null,"soit en plus \"clair\" ! :"]
["Syntaxe : =RECHERCHE(valeur_cherchée;colonne_\"index\";colonne-\"retour\")"]
["La syntaxe \"matrice\" - ne nous concerne pas ici"]
[]
["Caractéristiques de la fonction"]
["La fonction cherche en valeur proche - pas de valeur exacte possible - ce qui implique donc que la colonne \"index\" DOIT être triée par ordre ascendant (sinon augmentation risque de #N/A)"]
["Si la valeur cherchée est plus petite que la première et donc plus petite valeur de la colonne \"index\" du tableau : la fonction retourne #N/A."]
["Au lieu d'indiquer le numéro de la colonne, on utilise une plage de cellules pour indiquer la colonne \"retour\""]

{"sheet":"Devises - SI imbriqués","index":23,"n_rows":27,"n_cols":10,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[null,null,"Ceci correspond à un helpdesk fin 2019"]
[]
["Quel était le but final visé ?"]
["La dame devait pouvoir additionner les montants en CHF / USD / EURO"]
["Dans sa colonne, les montants en CHF / USD / EURO devaient rester tels quels"]
["Les montants dans toutes les autres devises devaient être converties en CHF"]
[]
["Montant","Devise","RCHERCHEV pour le montant final","Etiquette de la devise",null,"SOMME.SI"]
[1000,"CHF",{"$f":"$A9*VLOOKUP(B9,$H$11:$I$19,2,FALSE)","v":1000},{"$f":"IF(B9=\"USD\",\"USD\",IF(B9=\"EURO\",\"EURO\",\"CHF\"))","v":"CHF"},"CHF",{"$f":"SUMIF($D$9:$D$19,E9,$C$9:$C$19)","v":84500},"=SOMME.SI($D$9:$D$19;E9;$C$9:$C$19)"]
[2000,"USD",2000,{"$f":"IF(B10=\"USD\",\"USD\",IF(B10=\"EURO\",\"EURO\",\"CHF\"))","v":"USD"},"USD",{"$f":"SUMIF($D$9:$D$19,E10,$C$9:$C$19)","v":12000}]
[3000,"EURO",3000,"EURO","EURO",14000,null,"Devise","Change (fictif)"]
[4000,"GBP",2000,"CHF",null,null,null,"CHF",1,"1 ==> pour les laisser tels quels"]
[5000,"NOK",7500,"CHF",null,null,null,"USD",1]
[6000,"SEK",12000,"CHF",null,null,null,"EURO",1]
[7000,"JPY",21000,"CHF",null,null,null,"GBP",0.5]
[8000,"SGD",32000,"CHF",null,null,null,"NOK",1.5]
[9000,"CHF",9000,"CHF",null,null,null,"SEK",2]
[10000,"USD",10000,"USD",null,null,null,"JPY",3]
[11000,"EURO",11000,"EURO",null,null,null,"SGD",4]
[]
[null,"Pour obtenir le montant","=$A9*RECHERCHEV(B9;$H$11:$I$19;2;FAUX)"]
[]
[null,null,"Pour obtenir le libellé correct de la devise","=SI(B9=\"USD\";\"USD\";SI(B9=\"EURO\";\"EURO\";\"CHF\"))"]
[]
[null,null,null,"Quel raisonnement pour choisir le type de SI ?"]
[null,null,null,"Si c'est CHF ou USD ou EURO ==> CHF",null,null,null,"Le hic il y a 3 conditions pour 1 resultat possible and ce n'est pas ce que l'on veut"]
[null,null,null,"Si c'est USD ==> USD; si c'est EURO ==> EURO et pour tous les autres cas ==> CHF (donc y compris le CHF d'origine)"]

{"sheet":"Recherchev avec astérisques","index":24,"n_rows":41,"n_cols":11,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["FONCTION RECHERCHEV avec astérisques"]
[]
["Voici une liste de fournisseurs que JULES gère régulièrement"]
[null,null,null,null,null,null,"Noms partiels","Saisir le départ sur 2","Remplissage inst.","RECHERCHEV"]
["Fournisseurs",null,null,null,null,null,"ACTIVE TECH","*ACTIVE TECH*","*ACTIVE TECH*",{"$f":"VLOOKUP(I5,$A$6:$A$39,1,0)","v":"ACTIVE TECH SA"}]
["AB AGATHES SA",null,null,null,null,null,"ALTMANN","*ALTMANN*","*ALTMANN*",{"$f":"VLOOKUP(I6,$A$6:$A$39,1,0)","v":"ALTMANN  AG                  "}]
["ACTIVE TECH SA",null,null,null,null,null,"DECOS SA",null,"*DECOS SA*",{"$error":"#N/A"},"Pas trouvé …. C'est que la différence de saisie"]
["AFFOLAM SA",null,null,null,null,null,"ARTIME ",null,"*ARTIME*","ARTIME AND EPOCH SA","n'est pas limitiée à AVANT / APRES mais entre-deux"]
["AIGUILLES ROSES SA",null,null,null,null,null,"ARTISTIC",null,"*ARTISTIC*","ARTISTIC SETTING SA","Limite !!!!!"]
["ALPHATER SWISS GMBH                 ",null,null,null,null,null,"ANNE GOUJON SA",null,"*ANNE GOUJON SA*","ATELIER D'EMAIL ANNE GOUJON SA    "]
["ALTMANN  AG                  ",null,null,null,null,null,"HOPE AND BELIEF",null,"*HOPE AND BELIEF*","ATELIER HOPE AND BELIEF SA"]
["APEPO SA",null,null,null,null,null,"LAURENT DUPONT",null,"*LAURENT DUPONT*","ATELIER LAURENT DUPONT             "]
["ATOSPARTS AG                        "]
["ARQUOPAM SA"]
["ARSSOR HEROS SA",null,"\u008c","Ajouter un astérisque devant la donnée et après"]
["ARNANONI",null,null,"Le faire pour les deux premiers (sinon le remplissage instantané est \"perdu\")"]
["ARTS DECOS + D SA",null,null,"Clic sur le 2ème"]
["ARTISTIC SETTING SA",null,null,"Passer le REMPLISSAGE INSTANTANE"]
["ARTIME AND EPOCH SA"]
["ATELIER ANDRE PERREIRA SA",null,"\u008d","Faire une RECHERCHEV classique avec VALEUR EXACTE"]
["ATELIER D'EMAIL ANNE GOUJON SA    ",null,null,"C'est miraculeux : la recherche comprend la valeur \"caractères possibles avant / après\" (ce sont les vieux \"joker DOS\")"]
["ATELIER D'HORLOGERIE 23 SARL        ",null,null,"Mais çà marche !!!!!"]
["ATELIER JULES SIMAONO SARL"]
["ATELIER HOPE AND BELIEF SA"]
["ATELIER LAURENT DUPONT             "]
["ATELIER VAURILLONNET                   "]
["ATOKAPPA"]
["AUBRY A.G.- PLASTIC AND GLASS"]
["AZURETTE TECHNOLOGIES SA"]
["BALON FRERES S.A."]
["BAUMGARTNER MICROTECHNIK AG"]
["BAUDET INDUSTRIES SUISSE SA"]
["BELFONTAINE SA"]
["BERNESSA PRECISION SA"]
["BIBUSSEP METALS AG"]
["BIWITON SA"]
["BLANCCHOCOLATS SA"]
["BLOC'HORRIBLE SA"]
["BLOSCHETTE SA"]
[]
["ETC … il y en a des centaines !"]

{"sheet":"FONCTIONS ERREUR et INFORMATION","index":25,"n_rows":48,"n_cols":7,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Explications"]
["Les fonctions d'erreur permettent de déterminer si un calcul ou une fonction génère un résultat \"en erreur\". La plupart du temps, ce résultat ne provient pas d'une erreur mais simplement d'une information momentanément manquante"]
["Mais le message d'erreur (souvent #N/A ou #DIV/0!) est très moche et un utilisateur débutant peut fort bien faire un DELETE pour qu'il ne soit plus affiché … Dangereux !"]
[]
["Dans les fonctions dites d'erreur se trouvent aussi des fonctions de \"test\" ou d'information comme ESTVIDE, ESTPAIR, ESTIMPAIR … fort pratiques"]
["Les fonctions d'erreur se retrouvent souvent combinées avec des fonctions de recherche. "]
[]
["Exemple simple avec un ESTVIDE : (un formulaire à remplir)"]
[]
["Le contrôle qualité sera à la charge du collaborateur suivant : "]
[]
[null,"[…]"]
[]
["Au fond du formulaire : "]
[{"$f":"IF(ISBLANK(E12),\"Vous avez oublié d'indiquer le collaborateur choisi\",\"Merci d'avoir remplir ce formulaire\")","v":"Vous avez oublié d'indiquer le collaborateur choisi"}]
[]
["A votre tour :"]
[]
[]
[]
["A faire"]
[]
["On divise le montant par le diviseur. Lorsque le diviseur manque : ce n'est pas un oubli, c'est comme çà"]
[]
["Montant",100,200,300,400,500,600]
["Diviseur",5,4,null,null,4,6]
["Résultat",{"$f":"B27/B28","v":20},{"$f":"C27/C28","v":50},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},125,100]
[]
[]
["Refaire le calcul pour que la cellule n'affiche pas la valeur d'erreur …"]
[]
["Montant",100,200,300,400,500,600]
["Diviseur",5,4,null,null,4,6]
["Résultat"]
["Résultat macro",{"$f":"IF(ISERROR(B34/B35),\"\",B34/B35)","v":20},{"$f":"IF(ISERROR(C34/C35),\"\",C34/C35)","v":50},"","",125,100]
[]
["Autres fonctions d'erreur"]
["=ESTVIDE(valeur)","renvoie VRAI si la cellule est vide"]
["=ESTERR(valeur)","renvoie VRAI si la fonction de la cellule retourne une valeur d'erreur comme #NUM!, #DIV/0! … mais pas #N/A"]
["=ESTNA(valeur)","renvoie VRAI si la fonction de la cellule retourne la valeur d'erreur #N/A"]
["=ESTERREUR(valeur)","renvoie VRAI si la fonction de la cellule retourne une valeur d'erreur (toutes y compris #N/A)"]
[]
["=SIERREUR(valeur;valeur_si_erreur)",null,"     ==>","est-ce que la valeur testée est en erreur (fonction, calcul ….) ? Si oui alors définir la valeur à insérer (texte, rien …)"]
[null,null,"exemple dans la feuille suivante"]
[]
["voir liste complète …"]

{"sheet":"RECHERCHEV - SIERREUR 1","index":26,"n_rows":26,"n_cols":10,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,"AVS/AI/APG"]
[null,null,null,null,null,null,null,8500,5.1159999999999997E-2,"Revenu annuel "]
["Recherchev simple",null,null,null,null,null,null,15000,5.237E-2,"compris entre"]
[null,null,null,"%","Total","%","Total",19200,5.3589999999999999E-2,"8'500 et 50'700"]
["AVS Jean",null,"à",null,{"$f":"B6*D6","v":0},{"$f":"VLOOKUP(B6,$H$3:$I$20,2)","v":{"$error":"#N/A"}},{"$f":"B6*F6","v":{"$error":"#N/A"}},21300,5.4809999999999998E-2]
["AVS Pierre",null,null,null,{"$f":"B7*D7","v":0},{"$f":"VLOOKUP(B7,$H$3:$I$20,2)","v":{"$error":"#N/A"}},{"$f":"B7*F7","v":{"$error":"#N/A"}},23400,5.6030000000000003E-2]
["AVS Marcel",58684,null,null,0,9.5000000000000001E-2,5574.9800000000005,25500,5.7250000000000002E-2]
[null,null,null,null,null,null,null,27600,5.9670000000000001E-2]
[null,null,null,null,null,null,null,29700,6.2109999999999999E-2]
["Sans le #N/A",null,null,null,null,null,null,31800,6.4549999999999996E-2]
[null,null,null,"%","Total","%","Total",33900,6.6989999999999994E-2]
["AVS Jean",null,"à",null,{"$f":"B13*D13","v":0},{"$f":"IFERROR(VLOOKUP(B13,$H$3:$I$20,2),\"\")","v":""},{"$f":"IFERROR(B13*F13,\"\")","v":""},36000,6.9419999999999996E-2]
["AVS Pierre",34067,null,null,{"$f":"B14*D14","v":0},{"$f":"IFERROR(VLOOKUP(B14,$H$3:$I$20,2),\"\")","v":6.6989999999999994E-2},{"$f":"IFERROR(B14*F14,\"\")","v":2282.14833},38100,7.1859999999999993E-2]
["AVS Marcel",58684,null,null,0,9.5000000000000001E-2,5574.9800000000005,40200,7.5509999999999994E-2]
[null,null,null,null,null,null,null,42300,7.9170000000000004E-2]
[null,null,null,null,null,null,null,44400,8.2830000000000001E-2]
[null,null,null,null,null,null,null,46500,8.6470000000000005E-2]
[null,null,null,null,null,null,null,48600,9.0130000000000002E-2]
[null,null,null,null,null,null,null,50700,9.5000000000000001E-2]
[]
[]
[]
["Note : on peut aussi utiliser ESTVIDE",null,null,{"$f":"IF(ISBLANK(B6),\"\",VLOOKUP(B6,$H$3:$I$20,2,1))","v":""}]
[]
["Note : on peut aussi utiliser un SI - plus lourd mais juste",null,null,null,{"$f":"IF(ISERROR(VLOOKUP(B13,$H$3:$I$20,2,TRUE)),\"\",VLOOKUP(B13,$H$3:$I$20,2,TRUE))","v":""}]

{"sheet":"RECHERCHEV - SIERREUR 2","index":27,"n_rows":32,"n_cols":4,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
["Liste 1\nNos PC aux USA","Liste 2\nNos PC - Europe","=RECHERCHEV(….)\nspécial : table de recherche : colonne 1\nnuméro de la colonne : 1 !","Avec un SIERREUR …. pour obtenir autre chose que des #N/A !)"]
[null,null,"La fonction analyse le numéro du PC dans la liste 2\net indique si elle l'a trouvé dans la colonne 1.\nElle retourne le numéro du PC dans la liste 1","La fonction RECHERCHEV retourne le no du PC mais si elle génère une erreur, la cellule n'affiche rien"]
["XL45","AB89",{"$f":"VLOOKUP(B10,$A$10:$B$33,1,FALSE)","v":{"$error":"#N/A"}},{"$f":"IFERROR(VLOOKUP(B10,$A$10:$A$32,1,FALSE),\"\")","v":""}]
["PC56","VN91",{"$f":"VLOOKUP(B11,$A$10:$B$33,1,FALSE)","v":{"$error":"#N/A"}},{"$f":"IFERROR(VLOOKUP(B11,$A$10:$A$32,1,FALSE),\"\")","v":""}]
["TS67","GZ67",{"$error":"#N/A"},""]
["XL45","XL45","XL45","XL45"]
["PC56","PC56","PC56","PC56"]
["XO59","XL45","XL45","XL45"]
["XL47","PC56","PC56","PC56"]
["PC56","UT34","UT34","UT34"]
["TS67","AB89",{"$error":"#N/A"},""]
["UX45","VX87",{"$error":"#N/A"},""]
["UT34","XL47","XL47","XL47"]
["PC67","AB88",{"$error":"#N/A"},""]
["PC89","VN91",{"$error":"#N/A"},""]
["TS67","GZ67",{"$error":"#N/A"},""]
["XO60","XL45","XL45","XL45"]
["XL48","TO45",{"$error":"#N/A"},""]
["PC57","PC56","PC56","PC56"]
["TS68","PQ89",{"$error":"#N/A"},""]
["UX46","RT87",{"$error":"#N/A"},""]
[345,456,456,456]
[456,345,345,345]
[345,852,{"$error":"#N/A"},""]
[213,213,213,213]

{"sheet":"Echéancier - SIERREUR 3","index":28,"n_rows":50,"n_cols":12,"rows_kept":50,"cut":false,"hidden":false,"merged":[[1,0,1,3]]}
[]
[{"$f":"VLOOKUP(B5,$K$2:$L$6,2)","v":"Banque SuperAffaire"},null,null,null,null,null,null,null,null,null,"Taux","Nom"]
[null,null,null,null,null,null,null,null,null,null,0,"En plein délire !"]
["Montant",200000,null,null,null,null,null,null,null,null,0.01,"En plein délire !"]
["Intérêt",0.04,null,null,null,null,null,null,null,null,0.02,"Faut pas rêver - aucune banque ne prête à ce taux là !"]
["Nombre d'années",15,null,null,null,null,null,null,null,null,0.03,"Banque SuperAffaire"]
[null,null,null,null,null,null,null,null,null,null,0.05,"Banque Des Ogres"]
["Echéancier de remboursement",null,null,null,null,"Echéancier de remboursement",null,null,null,null,0.06,"Gang de Requins"]
["Année","Intérêt","Amortissement","Annuité",null,"Année","Intérêt","Amortissement","Annuité",null,7.0000000000000007E-2,"Stop Arnaque !!"]
[1,{"$f":"IFERROR(-IPMT($B$5,A10,$B$6,$B$4),\"\")","v":8000},{"$f":"IFERROR(-PPMT($B$5,A10,$B$6,$B$4),\"\")","v":9988.2200741946417},{"$f":"-PMT(B5,B6,B4)","v":17988.22007419464},null,1,{"$f":"-IPMT($B$5,F10,$B$6,$B$4)","v":8000},{"$f":"-PPMT($B$5,F10,$B$6,$B$4)","v":9988.2200741946417},{"$f":"-PMT(B5,B6,B4)","v":17988.22007419464}]
[2,{"$f":"IFERROR(-IPMT($B$5,A11,$B$6,$B$4),\"\")","v":7600.4711970322141},10387.748877162427,null,null,2,{"$f":"-IPMT($B$5,F11,$B$6,$B$4)","v":7600.4711970322141},{"$f":"-PPMT($B$5,F11,$B$6,$B$4)","v":10387.748877162427}]
[3,7184.9612419457189,10803.258832248923,null,null,3,7184.9612419457189,10803.258832248923]
[4,6752.8308886557606,11235.389185538881,null,null,4,6752.8308886557606,11235.389185538881]
[5,6303.4153212342053,11684.804752960434,null,null,5,6303.4153212342053,11684.804752960434]
[6,5836.0231311157868,12152.196943078852,null,null,6,5836.0231311157868,12152.196943078852]
[7,5349.935253392634,12638.284820802004,null,null,7,5349.935253392634,12638.284820802004]
[8,4844.4038605605529,13143.816213634083,null,null,8,4844.4038605605529,13143.816213634083]
[9,4318.6512120151901,13669.568862179451,null,null,9,4318.6512120151901,13669.568862179451]
[10,3771.8684575280122,14216.351616666627,null,null,10,3771.8684575280122,14216.351616666627]
[11,3203.2143928613468,14785.005681333292,null,null,11,3203.2143928613468,14785.005681333292]
[12,2611.8141656080156,15376.405908586623,null,null,12,2611.8141656080156,15376.405908586623]
[13,1996.7579292645507,15991.462144930088,null,null,13,1996.7579292645507,15991.462144930088]
[14,1357.0994434673471,16631.120630727291,null,null,14,1357.0994434673471,16631.120630727291]
[15,691.8546182382554,17296.365455956384,null,null,15,691.8546182382554,17296.365455956384]
[{"$f":"IF(ISERROR(IF(A24-$B$6=0,\"\",IF(A24-$B$6<0,A24+1))),\"\",IF(A24-$B$6=0,\"\",IF(A24-$B$6<0,A24+1)))","v":""},{"$f":"IFERROR(-IPMT($B$5,A25,$B$6,$B$4),\"\")","v":""},{"$f":"IFERROR(-PPMT($B$5,A25,$B$6,$B$4),\"\")","v":""},null,null,16,{"$error":"#NUM!"},{"$error":"#NUM!"}]
["",{"$f":"IFERROR(-IPMT($B$5,A26,$B$6,$B$4),\"\")","v":""},{"$f":"IFERROR(-PPMT($B$5,A26,$B$6,$B$4),\"\")","v":""},null,null,17,{"$error":"#NUM!"},{"$error":"#NUM!"}]
["","","",null,null,18,{"$error":"#NUM!"},{"$f":"-PPMT($B$5,F27,$B$6,$B$4)","v":{"$error":"#NUM!"}}]
["","","",null,null,19,{"$error":"#NUM!"},{"$error":"#NUM!"}]
["","","",null,null,20,{"$error":"#NUM!"},{"$error":"#NUM!"}]
["","","",null,null,21,{"$error":"#NUM!"},{"$error":"#NUM!"}]
["","","",null,null,22,{"$error":"#NUM!"},{"$error":"#NUM!"}]
["","","",null,null,23,{"$error":"#NUM!"},{"$error":"#NUM!"}]
["","","",null,null,24,{"$error":"#NUM!"},{"$error":"#NUM!"}]
["","","",null,null,25,{"$error":"#NUM!"},{"$error":"#NUM!"}]
["","","",null,null,26,{"$error":"#NUM!"},{"$error":"#NUM!"}]
["","","",null,null,27,{"$error":"#NUM!"},{"$error":"#NUM!"}]
["","","",null,null,28,{"$error":"#NUM!"},{"$error":"#NUM!"}]
["","","",null,null,29,{"$error":"#NUM!"},{"$error":"#NUM!"}]
["","","",null,null,30,{"$error":"#NUM!"},{"$error":"#NUM!"}]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]
["","",""]

{"sheet":"Arrondis-et-multiples","index":29,"n_rows":38,"n_cols":11,"rows_kept":38,"cut":false,"hidden":false,"merged":[[2,7,2,10],[22,7,22,10]]}
[]
[]
[null,null,null,null,null,null,null,"multiple choisi = 3"]
["nombre","=ARRONDI","=ARRONDI.INF","=ARRONDI.SUP",null,"=TRONQUE",null,"nombre","=ARRONDI.AU.MULTIPLE","=PLANCHER","=PLAFOND"]
[52.121000000000002,null,null,null,null,null,null,3]
[52.122,null,null,null,null,null,null,4]
[52.122999999999998,null,null,null,null,null,null,5]
[52.124000000000002,null,null,null,null,null,null,6]
[52.125,null,null,null,null,null,null,7]
[52.125999999999998,null,null,null,null,null,null,8]
[52.127000000000002,null,null,null,null,null,null,9]
[52.128,null,null,null,null,null,null,10]
[52.128999999999998,null,null,null,null,null,null,11]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"multiple choisi = 3"]
[{"$f":"A4","v":"nombre"},"=ARRONDI","=ARRONDI.INF","=ARRONDI.SUP",null,"=TRONQUE",null,{"$f":"H4","v":"nombre"},"=ARRONDI.AU.MULTIPLE","=PLANCHER","=PLAFOND"]
[52.121000000000002,{"$f":"ROUND(A25,2)","v":52.12},{"$f":"ROUNDDOWN(A25,2)","v":52.12},{"$f":"ROUNDUP(A25,2)","v":52.129999999999995},null,{"$f":"TRUNC(A25,2)","v":52.12},null,3,{"$f":"MROUND(H25,3)","v":3},{"$f":"FLOOR(H25,3)","v":3},{"$f":"CEILING(H25,3)","v":3}]
[52.122,52.12,52.12,52.129999999999995,null,52.12,null,4,3,3,6]
[52.122999999999998,52.12,52.12,52.129999999999995,null,52.12,null,5,6,3,6]
[52.124000000000002,52.12,52.12,52.129999999999995,null,52.12,null,6,6,6,6]
[52.125,52.13,52.12,52.129999999999995,null,52.12,null,7,6,6,9]
[52.125999999999998,52.13,52.12,52.129999999999995,null,52.12,null,8,9,6,9]
[52.127000000000002,52.13,52.12,52.129999999999995,null,52.12,null,9,9,9,9]
[52.128,52.13,52.12,52.129999999999995,null,52.12,null,10,9,9,12]
[52.128999999999998,52.13,52.12,52.129999999999995,null,52.12,null,11,12,9,12]
[]
["* ARRONDI.INF et TRONQUE semblent être identiques. Pour utilisation courante en "]
["bureautique : tout à fait interchangeables ! apparemment la différence se situerait quelque"]
["part côté maths très, très avancé ! Pas plus d'info - sorry !"]
[" "]

{"sheet":"Prix-arrondi.au.multiple","index":30,"n_rows":25,"n_cols":8,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,"Windows ","Word  Base 1","Word  Base 2","Excel \nBase 1","Excel \nBase 2","PowerPoint ","Outlook "]
["Prix d'achat",13.5,21.5,42.7,21.7,18.5,15.3,20.7]
["Marge de bénéfice : 33%",{"$f":"B7*33%","v":4.4550000000000001},{"$f":"C7*33%","v":7.0950000000000006},14.091000000000001,7.1610000000000005,6.1050000000000004,5.0490000000000004,6.8310000000000004]
["Prix de vente clientèle",{"$f":"SUM(B7:B8)","v":17.954999999999998},28.594999999999999,56.791000000000004,28.861000000000001,24.605,20.349,27.530999999999999]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"B6","v":"Windows "},"Word  Base 1","Word  Base 2","Excel \nBase 1","Excel \nBase 2","PowerPoint ","Outlook "]
[{"$f":"A7","v":"Prix d'achat"},{"$f":"B7","v":13.5},21.5,42.7,21.7,18.5,15.3,20.7]
["Marge de bénéfice : 33%",4.4550000000000001,7.0950000000000006,14.091000000000001,7.1610000000000005,6.1050000000000004,5.0490000000000004,6.8310000000000004]
["Prix de vente clientèle",{"$f":"MROUND(SUM(B23:B24),0.05)","v":17.95},28.6,56.800000000000004,28.85,24.6,20.350000000000001,27.55]

{"sheet":"Banque-arrondi.au.multiple","index":31,"n_rows":33,"n_cols":9,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,1,0,5]]}
[null,"Si solde positif : les frais sont de 1 pour mille\nSi solde négatif: les frais sont de 0.45 pour mille\nLes frais sont arrondis à 5ct",null,null,null,null,null,null,"© Corinne Leuba"]
[]
["Mois","Dépenses","Recettes","Solde à nouveau","Frais"]
["Janvier",65000,75000,55000,null,null,"Rappel : la fonction ARRONDI.AU.MULTIPLE ne peut pas travailler sur des "]
["Février",85000,13000,{"$f":"D4+(C5-B5)-E4","v":-17000},null,null,"valeurs tantôt positives, tantôt négatives ….. Elles doivent être TOUTES positives ou TOUTES négatives"]
["Mars",74000,36000,{"$f":"D5+(C6-B6)-E5","v":-55000}]
["Avril",11000,18000,-48000]
["Mai",15500,19000,-44500]
["Juin",14200,26000,-32700]
["Juillet",8400,95000,53900]
["Août",12000,22000,63900]
["Septembre",13500,26000,76400]
["Octobre",26000,55000,105400]
["Novembre",8700,42000,138700]
["Décembre",25000,78000,191700]
[]
[]
[]
[]
[]
[{"$f":"A3","v":"Mois"},"Dépenses","Recettes","Solde à nouveau","Frais"]
["Janvier",65000,75000,55000,{"$f":"MROUND(IF(D22>=0,D22*0.001,-D22*0.00045),0.05)","v":55},null,"=ARRONDI.AU.MULTIPLE(SI(D22>=0;D22*0.001;-D22*0.00045);0.05)"]
["Février",85000,13000,{"$f":"D22+(C23-B23)-E22","v":-17055},7.65]
["Mars",74000,36000,{"$f":"D23+(C24-B24)-E23","v":-55062.65},24.8]
["Avril",11000,18000,-48087.450000000004,21.650000000000002]
["Mai",15500,19000,-44609.100000000006,20.05]
["Juin",14200,26000,-32829.150000000009,14.75]
["Juillet",8400,95000,53756.099999999991,53.75]
["Août",12000,22000,63702.349999999991,63.7]
["Septembre",13500,26000,76138.649999999994,76.150000000000006]
["Octobre",26000,55000,105062.5,105.05000000000001]
["Novembre",8700,42000,138257.45000000001,138.25]
["Décembre",25000,78000,191119.2,191.10000000000002]

{"sheet":"Devis avec remise","index":32,"n_rows":55,"n_cols":9,"rows_kept":55,"cut":false,"hidden":false,"merged":[[54,0,54,5],[5,3,5,5],[6,3,6,5],[7,3,7,5],[49,3,49,4],[50,3,50,4],[51,3,51,4]]}
[{"$f":"MROUND((XFA1*XFB1)*(1-XFC1),1)","v":0}]
[]
[]
[]
[]
["Devis N° :",1,"Client :","M. Dupont"]
["Date :","2020-01-31",null,"Avenue Clément Ader"]
["Validité :",{"$f":"B7+90","v":"2020-04-30"},null,"34170 Castelnau le Lez"]
[]
[]
["Titre :","Prestation de service",null,null,"TVA",0.08]
[]
["Référence","Libellé","Prix unitaire HT","Quantité","Remise ","Total HT","Réponse - ne rien écrire dans la colonne (macro)",null,"Astuce pour simplifier la fonction : "]
[null,"Exemple de prestation",25,2,2.5000000000000001E-2,null,{"$f":"MROUND((C14*D14)*(1-E14),1)","v":49},null,"Au lieu de soustraire 3% du résultat"]
[null,null,80,2,0.03,null,{"$f":"MROUND((C15*D15)*(1-E15),1)","v":155},null,"je multiplie par 1-le pourcentage, cela "]
[null,null,null,null,null,{"$f":"ROUND((C16*D16)*(100-E16)/100,2)","v":0},0,null,"me donne directement Total - Remise"]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[]
[]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,"Total HT :",null,{"$f":"SUM(F14:F49)","v":0},{"$f":"SUM(G14:G49)","v":204}]
[null,null,null,"TVA:",null,{"$f":"F50*TAUXTVA","v":0},{"$f":"G50*TAUXTVA","v":16.32}]
[null,null,null,"Total TTC :",null,{"$f":"F50+F51","v":0},{"$f":"G50+G51","v":220.32}]
[]
[]
["Mon entreprise - Tel 04 99 13 32 00 - Fax 04 99 13 13 00 - info@batappli.ch"]

{"sheet":"SPECIAL","index":33,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"EST.PAIR-EST.IMPAIR et MOD","index":34,"n_rows":45,"n_cols":9,"rows_kept":45,"cut":false,"hidden":false,"merged":[[2,1,2,2],[27,1,27,2]]}
[null,"Comment faire analyser les nombres pairs ou impairs ?"]
[]
["Nom","Plaques",null,"Peut rouler\navec EST.IMPAIR","Peut rouler\navec MOD",null,null,"EST.IMPAIR ?"]
["Dupond","GE",12001,null,null,null,67,{"$f":"ISODD(G4)","v":true},"=EST.IMPAIR(G4)"]
["Dupont","GE",92222,null,null,null,68,{"$f":"ISODD(G5)","v":false}]
["Durand","GE",372854]
["Grand","GE",22666,null,null,null,null,"Attention : ne pas confondre avec les fonctions PAIR et IMPAIR"]
["Grosjean","GE",444445,null,null,null,null,"qui arrondissent au nombre pair ou impair le plus proche"]
["Martin","GE",71451]
["Michel","GE",410658,null,null,null,null,"MOD ?"]
["Muller","GE",333555,null,null,null,67,{"$f":"MOD(G11,2)","v":1},"=MOD(G8;2)"]
["Petit","GE",78909,null,null,null,68,{"$f":"MOD(G12,2)","v":0}]
["Petitjean","VD",12121]
["Rossi","GE",10000,null,null,null,null,"Un nombre impair divisé par 2 donne toujours 1 comme reste !"]
["Sanchez","GE",402338,null,null,null,null,"Un nombre pair divisé par 2 donne toujours 0 comme reste !"]
["Sancho","GE",651224]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"A3","v":"Nom"},{"$f":"B3","v":"Plaques"},null,{"$f":"D3","v":"Peut rouler\navec EST.IMPAIR"},{"$f":"E3","v":"Peut rouler\navec MOD"}]
[{"$f":"A4","v":"Dupond"},"GE",12001,{"$f":"IF(ISODD(C29),\"peut rouler\",\"non\")","v":"peut rouler"},{"$f":"IF(MOD(C29,2)=1,\"peut rouler\",\"non\")","v":"peut rouler"}]
["Dupont","GE",92222,"non",{"$f":"IF(MOD(C30,2)=1,\"peut rouler\",\"non\")","v":"non"}]
["Durand","GE",372854,"non","non"]
["Grand","GE",22666,"non","non"]
["Grosjean","GE",444445,"peut rouler","peut rouler"]
["Martin","GE",71451,"peut rouler","peut rouler"]
["Michel","GE",410658,"non","non"]
[]
[]
["Une utilisation TRES, TRES intéressante de la fonction MOD : la soustration d'heures \"négatives\""]
[]
["Arrivée","Départ","Temps de travail"]
["08:00:00","12:00:00",{"$f":"B41-A41","v":"04:00:00"},"soustraction normale : OK"]
["23:00:00","05:00:00",{"$f":"B42-A42","v":-0.75},"soustraction normale : la catastrophe !!!!"]
["23:00:00","05:00:00",{"$f":"MOD(B43-A43,1)","v":"06:00:00"},"la même soustraction avec MOD : =MOD(B42-A42;1)"]
[]
["Pourquoi ? Heu …… y-a-t-il un génie mathématicien dans cette salle ? Qu'importe CA MARCHE !!!!!"]

{"sheet":"ENT","index":35,"n_rows":28,"n_cols":11,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[]
["Date d'aujourd'hui",":",{"$f":"TODAY()","v":"2022-07-08"},null,"rappel : =AUJOURDHUI()"]
[]
["Ma date de naissance",":","1961-04-05"]
[]
["C'était un",":"]
[]
["Nombre de jours",":"]
[]
[]
["Nombre d'années complètes",":",null,null,"Attention : une année compte en fait 365.25 jours si on tient compte des années bisextiles etc …"]
[null,null,null,null,"La fonction qui renvoie le nombre entier résultant d'une division (ENT)"]
[]
[]
[]
[]
["Date d'aujourd'hui",":",{"$f":"TODAY()","v":"2022-07-08"},null,"Rappel : =AUJOURDHUI()"]
[]
["Ma date de naissance",":",{"$f":"C4","v":"1961-04-05"}]
[]
["C'était un",":",{"$f":"C6","v":"00:00:00"},null,"Pas de fonction - un simple format de cellule ! - jjjj"]
[]
["Nombre de jours",":",{"$f":"C17-C19","v":22374},null,"Soustraction : comment obtenir un nombre de jours plutôt qu'une date ?"]
[null,null,null,null,"Astuce : ôter le format date (passer en \"Standard\"): on récupère le nombre de jours !"]
[]
["Nombre d'années complètes",":",{"$f":"INT(C23/365.25)","v":61},null,"Fonction Integer  =ENT((C26/365.25)",null,null,null,null,"=C26/365.25",{"$f":"C23/365.25","v":61.256673511293634}]
[null,null,null,null,"Arrondi traditionnel ? Dangereux car ARRONDI(43.25;0)=43 mais ARRONDI(43.79;0)=44. "]
[null,null,null,null,"Un ARRONDI.INF à 0 décimal serait mieux"]

{"sheet":"Fonctions-texte","index":36,"n_rows":61,"n_cols":7,"rows_kept":61,"cut":false,"hidden":false,"merged":[[23,0,23,1]]}
[]
[null,null,"En anglais"]
["=GAUCHE(nombre_ou_texte;nombre_de_caractères)","Retourne le nombre de caractères spécifié depuis la gauche de la chaîne de texte","LEFT"]
["Dupont Charles",{"$f":"LEFT(A4,6)","v":"Dupont"}]
[1000.56,{"$f":"LEFT(A5,4)","v":"1000"}]
[]
["=DROITE(nombre_ou_texte;nombre_de_caractères)","Retourne le nombre de caractères spécifié depuis la droite de la chaîne de texte","RIGHT"]
["Dupont Charles",{"$f":"RIGHT(A8,7)","v":"Charles"}]
[1000.56,{"$f":"RIGHT(A9,2)","v":"56"}]
[]
["=MAJUSCULE(texte)","Affiche le contenu de la cellule en lettre MAJ","UPPER"]
["=MINUSCULE(texte)","Affiche le contenu de la cellule en lettre MIN","LOWER"]
["=NOMPROPRE(texte)","Affiche le contenu de la cellule 1ère lettre de chaque mot en MAJ","PROPER"]
["paul",{"$f":"UPPER(A14)","v":"PAUL"},null,null,null,"évite l'édition de la cellule et la correction manuelle"]
["PAUL",{"$f":"LOWER(A15)","v":"paul"}]
["paul dupont - avenue aubert 43",{"$f":"PROPER(A16)","v":"Paul Dupont - Avenue Aubert 43"}]
[]
["=NBCAR(nombre_ou_texte)","Indique le nombre de caractères de la cellule","LEN"]
["Dupont",{"$f":"LEN(A19)","v":6},null,null,null,"pas utilisée seule mais en combinaison avec d'autres fonctions"]
[1000,{"$f":"LEN(A20)","v":4}]
[]
["=TROUVE(caractère_cherché;chaîn_texte)","Indique la position du caractère recherché dans la chaîne textuelle considérée","FIND"]
["Charles Dupont",{"$f":"FIND(\"C\",A23)","v":1},null,null,null,"pas utiliséE seule mais en combinaison avec d'autres fonctions"]
["La fonction est sensible à la casse des lettres. Si vous cherchez la lettre c et non C : la fonction retournera une erreur\nCHERCHE fonctionne de façon identique mais n'est pas sensible à la casse."]
["=CHERCHE(caractère_cherché;chaîn_texte)","Indique la position du caractère recherché dans la chaîne textuelle considérée","SEARCH"]
["Charles Dupont",{"$f":"SEARCH(\"c\",A26)","v":1}]
[]
["=STXT(text;no_départ;no_car)","Renvoie le texte selon le départ choisi et le nombre de car. Définis","MID"]
["Charles Dupont",{"$f":"MID(A29,1,7)","v":"Charles"}]
[]
["=SUPPRESPACE(texte)","Òte tous les espaces en trop mais en laissant toujours un espace entre les mots","TRIM"]
["     Charles Dupont de Neuilly sur      Seine",{"$f":"TRIM(A32)","v":"Charles Dupont de Neuilly sur Seine"},null,null,null,"très utile dans les listes provenant d'exportations …"]
[]
["=FRANC(nombre;nbre_de_décimales)","Convertit un nombre en texte en lui ajoutant le format monétaire par défaut","DOLLAR"]
[1000,{"$f":"DOLLAR(A35,2)","v":"1'000.00 CHF"},null,null,null,"évite d'éditer chaque cellule pour y rajouter l'apostrophe !"]
[]
["=CNUM(chaîne_textuelle)","convertit un texte en nombre","VALUE"]
["1000",{"$f":"VALUE(B35)","v":1000},null,null,null,"lorsque l'on récupère des nombres d'une base de données externes et que ceux-ci "]
[]
["=CTXT(nombre;nombre_décimales;avec ou \n    sans virgules)","Arrondit le nombre indiqué au nombre de décimales spécifié avec ou sans virgules","FIXED"]
["=CTXT(1235.569;2;FAUX)",{"$f":"FIXED(1235.569,2,FALSE)","v":"1'235.57"},null,null,null,"when you retrieve number from an external source and"]
[]
["=EXACT(valeur_texte1;valeur_ou_texte2)","Compare deux nombres ou textes et retourne VRAI ou FAUX ","EXACT"]
[null,null,null,null,"Liste 1","Liste 2","Exact ?"]
[null,null,null,null,"XL45","AB89",{"$f":"EXACT(E45,F45)","v":false}]
[null,null,null,null,"PC56","VN91",false]
[null,null,null,null,"TS67","GZ67",false]
[null,null,null,null,"XL45","XL45",true]
[null,null,null,null,"PC56","PC56",true]
[null,null,null,null,"XO59","XL45",false]
[null,null,null,null,"XL45","PC56",false]
[null,null,null,null,"PC56","UT34",false]
[]
["=TEXTE(valeur;format texte)\nle format = ceux d'Excel avec # et 0)","Convertit un nombre en texte en lui appliquant le format défini"]
["7560000002032",{"$f":"TEXT(A55,\"### #### #### ##\")","v":"756 0000 0020 32"}]
[null,"=TEXTE(A55;\"### #### #### ##\")"]
[]
[null,"Note : espace, tiret, apostrophe …. OK\nPoint : pas comme çà … il faut mettre une barre oblique inversée devant"]
[]
["7560000002032",{"$f":"TEXT(A60,\"###\\.####\\.####\\.##\")","v":"756.0000.0020.32"}]
[null,"=TEXTE(A55;\"###\\.####\\.####\\.##\")"]

{"sheet":"Concaténer","index":37,"n_rows":33,"n_cols":4,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[]
["Prénom","Nom","Age","Prénom et Nom"]
["John","Bonnet",36]
["Laurent","De Nardo",35]
["Pierre","Dudan",31]
["François","Dufour",29]
["Charles ","Dupont",37]
["Kentin","Duval",38]
["Mike","Olaf",40]
["Jean","Rochefort",42]
[]
[]
[]
[]
[]
[]
[]
[]
["Une fois le CONCATENER fait, il est évident que je souhaiterais me débarrasser"]
["si possible de la colonne A et B. Je n'ai pas envie de les masquer … "]
["Solution : il faut copier-coller la zone (on a l'impression de n'avoir rien fait !) "]
["But : voir le bouton des options de collage - choisir VALEUR avec ou sans format"]
[]
[]
["Prénom et Nom"]
[{"$f":"A3&\" \"&B3","v":"John Bonnet"}]
[{"$f":"A4&\" \"&B4","v":"Laurent De Nardo"}]
["Pierre Dudan"]
["François Dufour"]
["Charles  Dupont"]
["Kentin Duval"]
["Mike Olaf"]
["Jean Rochefort"]

{"sheet":"Scinder colonnes","index":38,"n_rows":49,"n_cols":11,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[]
["Booking Reference","RTA Date & Time","Booking Type","Card Number","Passenger","Pick-up Address","Destination Address","Internet","Driver Call Sign","Journey Distance","Wait Time (Mins)"]
["QF9577/1","2013-09-09T08:57:00","ASAP",555467978,"Keith Evans","Paddington, Prebooked Taxi Rank, Paddington Station, W2, ,, ,, PADDINGTON","Rimbello & Co Ltd, 3 Burlington Gardens, London, W1S 3EP","Y","H88",3.1,8]
["QG4382/1","2013-09-09T17:42:00","AB",555467978,"Daniel Rimmel","ABC Computers, 3 Burlington Gardens, London, W1S 3EP","The R S A, 8 John Adam Street, London, WC2N 6EZ",null,"PA45",1.6,2]
["QG6415/1","2013-09-10T08:39:00","ASAP",555467978,"Giuseppe Ferraro","Paddington, Prebooked Taxi Rank, Paddington Station, W2, ,, ,, PADDINGTON","Rimbello & Co Ltd, 3 Burlington Gardens, London, W1S 3EP","Y","PQ39",2.6,13]
["QG8617/1","2013-09-10T13:20:00","AB",555467978,"Donald Kein","ABC Computers, 3 Burlington Gardens, London, W1S 3EP","New AgeArchitecture, Harella House, 90-98 Goswell Road, London, EC1V 7DF",null,"Y03",4.0999999999999996,6]
["QG6658/1","2013-09-11T05:30:00","AB",555467978,"Keith Evans","Connaught Hotel, 16 Carlos Place, London, W1K 2AL","Lap, Terminal 1, Taxi Information Desk, HOUNSLOW, Middx, ,, ,, LAP","Y","K30",20.41,0]
["QH3169/1","2013-09-11T07:10:00","AB",555467978,"Giuseppe Ferraro","Browns Hotel, 33 Albemarle Street, London, W1S 4BP","Heathrow, Terminal One, Taxi Information Desk, London Heathrow Airport, Hounslow, Middlesex, TW6 1NJ",null,"PU48",30.01,22]
["QH4532/1","2013-09-11T11:00:00","AB",555467978,"Amel Benton","ABC Computers, 3 Burlington Gardens, London, W1S 3","Paddington Station, PreBooked Taxi Rank, Paddingto",null,"S46",3.54,0]
["QK9883/1","2013-09-16T09:11:00","ASAP",555467978,"Keith Evans","Paddington, Prebooked Taxi Rank, Paddington Station, W2, ,, ,, PADDINGTON","Rimbello & Co Ltd, 3 Burlington Gardens, London, W1S 3EP","Y","R67",2.6,6]
["QL2128/1","2013-09-16T11:37:00","ASAP",555467978,"Sally Nodilo","ABC Computers, 3 Burlington Gardens, London, W1S 3EP","Tertio, Unit 3, 2 More London Place, London, SE1 2DA",null,"PA21",4,6]
["QL1607/1","2013-09-17T11:00:00","AB",555467978,"Keith Evans","Rimbello & Co Ltd, 3 Burlington Gardens, London, W1S 3EP","Thomson Reuters, 3 Dorset Rise, London, EC4Y 8EN","Y","PB91",3,5]
["QN1538/1","2013-09-18T08:15:00","AB",555467978,"Keith Evans","Connaught Hotel, 16 Carlos Place, London, W1K 2AL","The Berkeley, Wilton Place, London, SW1X 7RL","Y","PM04",1.6,0]
["QN4519/1","2013-09-18T08:52:00","ASAP",555467978,"Giuseppe Ferraro","Paddington, Prebooked Taxi Rank, Paddington Station, W2, ,, ,, PADDINGTON","The Berkeley, Wilton Place, London, SW1X 7RL","Y","R12",5.7,8]
["QL9322/1","2013-09-18T11:00:00","AB",555467978,"Keith Evans","The Berkeley, Wilton Place, London, SW1X 7RL","Paddington, Prebooked Taxi Rank, Paddington Station, W2, ,, ,, PADDINGTON","Y","U54",3.2,5]
["QN4800/1","2013-09-18T15:45:00","AB",555467978,"Virginie Korrean","The Berkeley, Wilton Place, London, SW1X 7RL","Heathrow, Terminal One, Arrivals, London Heathrow",null,"AS96",2.58,0]
["QN7142/1","2013-09-19T07:50:00","AB",555467978,"Giuseppe Ferraro","Connaught Hotel, 16 Carlos Place, London, W1K 2AL","The Berkeley, Wilton Place, London, SW1X 7RL",null,"S34",1.4000000000000001,11]
["QN7048/1","2013-09-19T12:00:00","AB",555467978,"Giuseppe Ferraro","ABC Computers, 3 Burlington Gardens, London, W1S 3EP","Paddington Station, PreBooked Taxi Rank, Paddington Station, London, W2 1FG",null,"O28",3,18]
["QT6370/1","2013-09-25T14:50:00","AB",555467978,"Philippe Weber","Funding Circle, 3 Dorset Rise, London, EC4Y 8EN","Paddington Station, PreBooked Taxi Rank, Paddington Station, London, W2 1FG",null,"PE71",5.8,8]
["QT8325/1","2013-09-25T15:07:00","ASAP",555467978,"Keith Evans","The White Circle Organisation Ltd, 60-62 Commercial Street, London, E1 6LT","Paddington, Prebooked Taxi Rank, Paddington Station, W2, ,, ,, PADDINGTON","Y","B14",15.81,1]
["QU1491/1","2013-09-25T23:29:00","ASAP",555467978,"Philippe Weber","Dean town house, 69-71 Dean Street, London, W1D 3SE","As Directed",null,"C96",9.8000000000000007,4]
["QU3516/1","2013-09-26T12:00:00","AB",555467978,"Virginie Korrean","ABC Computers, 3 Burlington Gardens, London, W1S 3EP","Paddington Station, PreBooked Taxi Rank, Paddington Station, London, W2 1FG",null,"PM04",2.8000000000000003,7]
["QU7945/1","2013-09-27T00:12:00","ASAP",555467978,"Philippe Weber","The Shed, 22 Dean Street, London, W1D 3RX","174 Coombe Lane West, Kingston Upon Thames, Surrey, KT2 7DE",null,"PV45",12.1,0]
["QW3456/1","2013-09-30T14:00:00","AB",555467978,"Philippe Weber","ABC Computers, 3 Burlington Gardens, London, W1S 3EP","Paddington Station, PreBooked Taxi Rank, Paddington Station, London, W2 1FG",null,"U32",6,6]
["QC6740/1","2013-09-03T07:30:00","AB",555361645,"Nadia Bonnet","40 Chesilton Road, London, SW6 5AB","Flat 2, 16 St James's Street, London, SW1A 1ER","Y","S50",10.6,3]
["QD3252/1","2013-09-04T05:10:00","AB",555361645,"Nadia Bonnet","40 Chesilton Road, London, SW6 5AB","Lap, Terminal 5, at Costa Coffee opp arrivals with n/board, HOUNSLOW, Middx, ,, ,, LAP","Y","H03",16.809999999999999,2]
["QE6771/1","2013-09-06T07:30:00","AB",555361645,"Nadia Bonnet","40 Chesilton Road, London, SW6 5AB","Chiccoza, 5A Burlington Gardens, London, W1S 3EP","Y","S50",11.700000000000001,5]
["QH5420/1","2013-09-11T12:45:00","AB",555361645,"Nadia Bonnet","ABC Computers, 3 Burlington Gardens, London, W1S 3EP","Fleet Place House, 2 Fleet Place, London, EC4M 7RF",null,"PJ16",3.1,6]
["QN9842/1","2013-09-19T07:25:00","AB",555361645,"Nadia Bonnet","40 Chesilton Road, London, SW6 5AB","Chiccoza, 5A Burlington Gardens, London, W1S 3EP","Y","K53",21.21,2]
["QT4077/1","2013-09-25T07:50:00","AB",555361645,"Nadia Bonnet","40 Chesilton Road, London, SW6 5AB","Chiccoza, 5A Burlington Gardens, London, W1S 3EP","Y","B91",4.6399999999999997,1]
["QT5261/1","2013-09-25T17:10:00","AB",555361645,"Philippe Weber","ABC Computers, 3 Burlington Gardens, London, W1S 3EP","69 Wilson Street, London, EC2A 2BB",null,"PR91",4.6000000000000005,1]
["QU1494/1","2013-09-26T07:25:00","AB",555361645,"Keith Evans","40 Chesilton Road, London, SW6 5AB","Chiccoza, 5A Burlington Gardens, London, W1S 3EP","Y","T84",5,5]
["QR9063/1","2013-09-22T17:10:00","AB",555361637,"Philippe Weber","Paddington Station, PreBooked Taxi Rank, Paddington Station, London, W2 1FG","Half Moon Street, London, W1J 7AY",null,"S18",3.9,3]
["QT1401/1","2013-09-24T17:00:00","AB",555361637,"Virginie Korrean","ABC Computers, 3 Burlington Gardens, London, W1S 3EP","Paddington Station, PreBooked Taxi Rank, Paddington Station, London, W2 1FG",null,"C35",2.9,7]
["QN7797/1","2013-09-18T15:17:00","ASAP",555995236,"Philippe Weber","The Berkeley, Wilton Place, London, SW1X 7RL","Heathrow, Terminal One, Arrivals, London Heathrow Airport, Hounslow, Middlesex, TW6 1NJ",null,"PA01",15.71,3]
["QE1901/1","2013-09-05T09:46:00","ASAP",556052321,"François de Rouperton","Kensington Lighting Co, 59 Kensington Church Street, London, W8 4BA","3-5 Burlington Gardens, London, W1S 3AZ",null,"R47",4.3,1]
["QE3088/1","2013-09-05T14:10:00","AB",556052321,"François de Rouperton","ABC Computers, 3 Burlington Gardens, London, W1S 3EP","Heathrow, Terminal Five, Arrivals, London Heathrow Airport, Hounslow, Middlesex, TW6 2PZ",null,"PD86",18.91,5]
["QE8116/1","2013-09-06T10:01:00","ASAP",556052321,"François de Rouperton","Bullingham Mansions, Flat 42, Kensington Church Street, London, W8 4BE","3-5 Burlington Gardens, London, W1S 3AZ",null,"AS76",3.6,3]
["QF9779/1","2013-09-09T09:28:00","ASAP",556052321,"Virginie Korrean","Kensington Lighting Co, 59 Kensington Church Street, London, W8 4BA","3-5 Burlington Gardens, London, W1S 3AZ",null,"PX53",3.8000000000000003,0]
["QG6190/1","2013-09-10T07:54:00","ASAP",556052321,"Virginie Korrean","Bullingham Mansions, Flat 42, Kensington Church Street, London, W8 4BE","3-5 Burlington Gardens, London, W1S 3AZ",null,"PZ14",4.6000000000000005,0]
["QH4432/1","2013-09-11T09:50:00","ASAP",556052321,"Virginie Korrean","Bullingham Mansions, Flat 42, Kensington Church St","Heathrow, Terminal Five, Arrivals, London Heathrow",null,"20076",20,0]
["QK9247/1","2013-09-16T07:50:00","AB",556052321,"Virginie Korrean","Bullingham Mansions, Flat 42, Kensington Church Street, London, W8 4BE","3-5 Burlington Gardens, London, W1S 3AZ",null,"PD31",4.6000000000000005,12]
["QL6652/1","2013-09-17T09:35:00","AB",556052321,"Virginie Korrean","Virgin Active Health Club, 17A Old Court Place, London, W8 4PL","3-5 Burlington Gardens, London, W1S 3AZ",null,"AQ39",3.1,2]
["QL7306/1","2013-09-17T10:30:00","AB",556052321,"Virginie Korrean","ABC Computers, 3 Burlington Gardens, London, W1S 3EP","Heathrow, Terminal Five, Arrivals, London Heathrow Airport, Hounslow, Middlesex, TW6 2PZ",null,"PX83",23.61,0]
["QN4356/1","2013-09-18T09:15:00","AB",556052321,"Virginie Korrean","Bullingham Mansions, Flat 42, Kensington Church Street, London, W8 4BE","ABC Computers, 3 Burlington Gardens, London, W1S 3EP",null,"PQ98",5.3,4]
["QQ6609/1","2013-09-19T19:42:00","ASAP",556052321,"Virginie Korrean","Heathrow, Terminal Five, Arrivals, London Heathrow Airport, Hounslow, Middlesex, TW6 2PZ","Bullingham Mansions, Flat 42, Kensington Church Street, London, W8 4BE",null,"PE45",28.61,7]
["QQ7521/1","2013-09-20T05:10:00","AB",556052321,"Virginie Korrean","Bullingham Mansions, Flat 42, Kensington Church Street, London, W8 4BE","Heathrow, Terminal Five, Arrivals, London Heathrow Airport, Hounslow, Middlesex, TW6 2PZ",null,"O87",16.61,6]
["QS1076/1","2013-09-23T07:30:00","AB",556052321,"Virginie Korrean","Bullingham Mansions, Flat 42, Kensington Church Street, London, W8 4BE","As Directed",null,"C68",2.8000000000000003,9]
["QS7943/1","2013-09-24T09:37:00","ASAP",556052321,"Keith Evans","Paddington Station, PreBooked Taxi Rank, Paddington Station, London, W2 1FG","ABC Computers, 3 Burlington Gardens, London, W1S 3EP",null,"AQ33",2.5,11]

{"sheet":"Extraction-texte","index":39,"n_rows":44,"n_cols":3,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[]
["Prénom et Nom","Age"]
["John Bonnet",36]
["Johanna Dupont",35]
["Pierre Dudan",31]
["François Dufour",29]
["Charles Dupont",37]
["Kentin Duval",38]
["Mike Olaf",40]
[]
[]
["Prénom","Nom"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Idéal et sans appel à des fonctions particulières : Sélectionner la colonne et lancer l'Assistant de conversion par DONNEES - CONVERTIR !"]
["Rapide, facile, confortable ….."]
[]
["Mais enfin, si un jour vous ne pouvez pas utiliser DONNEES - CONVERTIR …. Vous pourrez toujours vous frotter à la solution ci-dessous : "]
[]
["Prénom"]
[{"$f":"LEFT(A3,FIND(\" \",A3))","v":"John "},"Il faut sortir \"par la gauche\" les caractères correspondants au prénom"]
["Johanna ","=GAUCHE(A3;nombre de car. pour récupérer le prénom quelle que soit sa longueur)"]
["Pierre ","Nombre de caractères : jusqu'à l'espace donc : TROUVE(\" \";A3)"]
["François "]
["Charles ","Final : =GAUCHE(A3;TROUVE(\" \";A3))"]
["Kentin "]
["Mike "]
[]
["Nom",null,"  "]
[{"$f":"RIGHT(A3,LEN(A3)-FIND(\" \",A3))","v":"Bonnet"},"Le problème est un peu plus compliqué. Il faut sortir \"par la droite\" les caractères correspondants au nom"]
["Dupont","=DROITE(A3;nombre de car. pour récupérer le nom quelle que soit sa longueur)"]
["Dudan","=DROITE(A3;jusqu'au premier espace pour qu'un nom en 2 parties soit toujours récupéré : donc un TROUVE espace)"]
["Dufour","Mais DROITE \"recule depuis la droite\" et TROUVE cherche toujours depuis la gauche !"]
["Dupont","Donc il faut en fait reculer du nombre total de caractères - le nombre de caractères jusqu'à l'espace"]
["Duval"]
["Olaf","Final : =DROITE(A3;NBCAR(A3)-TROUVE(\" \";A3))"]

{"sheet":"Extraction + Recherchev","index":40,"n_rows":47,"n_cols":9,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
[]
["Le problème","la personne a un fichier de base - le fichier 1. Il est tenu à jour régulièrement mais MANUELLEMENT"]
[null,"Chaque semaine, elle reçoit une extraction d'une base de données - le fichier 2 -  contenant les mêmes noms (parfois orthographiés autrement)"]
[null,"+ des autres noms qui devront pour certains être ajoutés au fichier 1"]
[null,"dans ce fichier le nom n'est pas séparé du prénom"]
["Comment comparer les deux colonnes ?"]
[]
["Fichier 1 - de base",null,null,null,null,"Copie de la colonne du fichier hebdomadaire","Sortir le nom - sans laisser l'espace à la fin (-1 sert à cela)","RECHERCHEV"]
["Nom","Prénom","Fils de","Epouse de",null,"Nom"]
["Alban","Fabienne","Pierre","prénom1",null,"Bessèges Sandra",{"$f":"LEFT(F10,FIND(\" \",F10)-1)","v":"Bessèges"},{"$f":"VLOOKUP(G10,$A$10:$A$31,1,0)","v":"Bessèges"},"==> dans la colonne "]
["Allanches","Jean-Pierre","Paul","prénom2",null,"Aubert Alain",{"$f":"LEFT(F11,FIND(\" \",F11)-1)","v":"Aubert"},{"$f":"VLOOKUP(G11,$A$10:$A$31,1,0)","v":"Aubert"}]
["Alvère","Véronique","Jean","prénom3",null,"De Nardo Jael","De",{"$error":"#N/A"},"==> pas dans la colonne - NEUF"]
["Alzon","Catherine","Jacques","prénom4",null,"Bugues Sam","Bugues",{"$error":"#N/A"},"==> en fait dans la colonne mais ortho différente"]
["Ambert","Jaques","Jules","prénom5",null,"Folch Martine","Folch",{"$error":"#N/A"}]
["Astier","Pascal","Ahmed","prénom6",null,"Brioux Michael","Brioux","Brioux"]
["Aubert","Alain","Stéphane","prénom7",null,"Boisseron Jean-Pierre","Boisseron","Boisseron"]
["Auberterre","Patricia","Luc","prénom8",null,"Perillat Jean-Pierre","Perillat",{"$error":"#N/A"}]
["Auterine","Luc","Xavier","prénom9",null,"Allanches Jean-Pierre","Allanches","Allanches"]
["Auvillard","Daniel","Kevin","prénom10",null,"Auberterre Patricia","Auberterre","Auberterre"]
["Bangol","Maria","Michael","prénom11",null,"Lo Conte Virginia","Lo",{"$error":"#N/A"}]
["Barbazan","Daniel","John","prénom12",null,"Auvillard Daniel","Auvillard","Auvillard"]
["Beauville","David","Jules","prénom13"]
["Bessèges","Sandra","Pierre","prénom14"]
["Biron","Rose-Marie","Raphaël","prénom15"]
["Blanzac","Raphaël","Luca","prénom16"]
["Boisseron","Jean-Pierre","Loredano","prénom17"]
["Bourdeilles","Martin","Laurent","prénom18"]
["Branne","Lauren","Keith","prénom19"]
["Brioux","Michael","David","prénom20"]
["Brossac","Helène","Nathan","prénom21"]
["Bugue","Sam","Mahel","prénom22"]
[]
[]
["Fichier 2 - reçu chaque semaine"]
["Nom","Prénom","Fils de","Epouse de"]
["Bessèges Sandra"]
["Aubert Alain"]
["De Nardo Jael"]
["Bugue Sam"]
["Folch Martine"]
["Brioux Michael"]
["Boisseron Jean-Pierre"]
["Perillat Jean-Pierre"]
["Allanches Jean-Pierre"]
["Auberterre Patricia"]
["Lo Conte Virginia"]
["Auvillard Daniel"]

{"sheet":"Dates-et-texte","index":41,"n_rows":29,"n_cols":3,"rows_kept":29,"cut":false,"hidden":false,"merged":[[25,1,25,5],[7,1,7,2]]}
[]
[]
[]
[]
[]
[]
[]
["Voici ce que l'on veut : ","Imprimé le \"date du jour automatique\" dans la même cellule !"]
[]
[null,"A VOUS !!!!!"]
[]
[]
[]
[]
["imprimé le 21.10.2013","saisie et CTRL ;","La saisie et le raccourci dans la même cellule ne pose aucun problème"]
[null,null,"le seul hic : pas de mise à jour automatique !!!"]
[]
["imprimé le AUJOURDHUI()","saisie et AUJOURDHUI()","La fonction est ignorée !"]
[]
[]
[{"$f":"CONCATENATE(\"imprimé le \",TODAY())","v":"imprimé le 44750"},"concatener : \n=CONCATENER(\"imprimé le \";AUJOURDHUI()) ","Fonctionne mais le résultat est un numéro de série ! Et formater la cellule en date ne sert à rien !!!"]
[]
[]
[{"$f":"CONCATENATE(\"imprimé le \",DAY(TODAY()),\".\",MONTH(TODAY()),\".\",YEAR(TODAY()))","v":"imprimé le 8.7.2022"},"concatener et extraction des éléments de la date, ajout des points de séparation ....."]
[]
[null,"=CONCATENER(\"imprimé le \";JOUR(AUJOURDHUI());\".\";MOIS(AUJOURDHUI());\".\";ANNEE(AUJOURDHUI()))"]
[]
["On peut aussi plus simplement saisir la fonction =AUJOURDHUI() puis appliquer un format perso comme \"imprimé le \" dd.mm.aaaa"]
["Mais c'était le plaisir d'utiliser les fonctions CONCATENER, JOUR, MOI, ANNEE …. !!!"]

{"sheet":"Ecartype","index":42,"n_rows":1000,"n_cols":5,"rows_kept":1000,"cut":false,"hidden":false,"merged":[[54,2,54,3]]}
[]
["Ecartype","Additionne les écarts (haut - bas) par rapport à la moyenne des valeurs spécifiées puis prend la "]
[null,"racine carrée de cette somme. L'indice obtenu permet d'analyser l'évolution de \"l'écart\" par rapport à la moyenne"]
[null,"Exemple type : variations d'une valeur sur les marchés boursiers - volatile ou stable ?"]
[]
["La variance :","C'est la somme de tous les écarts par rapport à la moyenne"]
[]
["Variations des actions Nestlé - Novartis - UBS et Serono "]
["Date","NESTLE (NOM) - CHF","NOVARTIS (NOM) - CHF","UBS (NOM) - CHF","SERONO B - CHF"]
["2006-09-29",436,73,74.8,1080]
["2006-09-28",436.75,73.25,73.599999999999994,1080]
["2006-09-27",435.75,72.8,73.5,1080]
["2006-09-26",436.75,72.400000000000006,73.75,1079]
["2006-09-25",430,71.75,72.75,1080]
["2006-09-22",430.75,72,72.95,1076]
["2006-09-21",434,72.400000000000006,73.7,1076]
["2006-09-20",434.5,72.5,72.7,915]
["2006-09-19",429,71.25,71.599999999999994,906]
["2006-09-18",429.25,71.650000000000006,72.2,915]
["2006-09-15",428.5,71.75,71.900000000000006,883.5]
["2006-09-14",428,71.349999999999994,70.849999999999994,871.5]
["2006-09-13",429.25,71.400000000000006,71.150000000000006,879.5]
["2006-09-12",430.5,71.099999999999994,70.7,872.5]
["2006-09-11",428,70.2,69.849999999999994,863.5]
["2006-09-08",429.5,69.849999999999994,70.2,862.5]
["2006-09-07",425.75,69.5,70.099999999999994,856]
["2006-09-06",423.25,69.599999999999994,70.5,855]
["2006-09-05",423.5,70.25,71.3,862.5]
["2006-09-04",426.25,70.75,70.8,865]
["2006-09-01",425.25,70.3,70.400000000000006,863.5]
["2006-08-31",423.25,70.25,69.650000000000006,858]
["2006-08-30",423.75,70.650000000000006,69.900000000000006,851]
["2006-08-29",423.5,70.5,69.7,848]
["2006-08-28",421,70.099999999999994,69.7,850]
["2006-08-25",420,70.2,69.099999999999994,841]
["2006-08-24",418.75,70.599999999999994,68.849999999999994,843]
["2006-08-23",417.75,70.3,69.25,843]
["2006-08-22",408.5,70.099999999999994,70.05,839]
["2006-08-21",402.75,69.95,70.05,839]
["2006-08-18",404.75,70.150000000000006,70.349999999999994,842]
["2006-08-17",407.25,70.3,71,836]
["2006-08-16",409.75,70.099999999999994,69.7,837]
["2006-08-15",411,69.95,68.3,837]
["2006-08-14",408,69.25,66.05,839.5]
["2006-08-11",408,68.8,65.7,830.5]
["2006-08-10",406.75,68.3,65.3,823]
["2006-08-09",405.75,68.75,65.650000000000006,824.5]
["2006-08-08",401.75,67.8,64.95,811]
["2006-08-07",398,68,65.45,810]
["2006-08-04",405.5,68.75,66.3,820]
["2006-08-03",402.75,68,66.25,814]
["2006-08-02",407.25,68.599999999999994,66.75,830]
["2006-08-01",403.25,69.900000000000006,66.95,832.5]
["Total",{"$f":"SUBTOTAL(107,B10:B53)","v":11.763161177504509},{"$f":"SUBTOTAL(107,C10:C53)","v":1.3835387380721591},{"$f":"SUBTOTAL(107,D10:D53)","v":2.6023517072128866},{"$f":"SUBTOTAL(107,E10:E53)","v":87.731737828508486}]
[null,null,"Novartis plus stable que UBS"]
[]
[]
["Plus fiable si les valeurs analysées sont prises sur un laps de temps plus long : ici de 2003 à 2006"]
[]
["Date","NESTLE (NOM) - CHF","NOVARTIS (NOM) - CHF","UBS (NOM) - CHF","SERONO B - CHF"]
["2006-07-31",403.25,69.900000000000006,66.95,832.5]
["2006-07-28",403,69.599999999999994,67.2,830]
["2006-07-27",399.25,69.150000000000006,66.3,820]
["2006-07-26",397.5,69.5,64.8,840]
["2006-07-25",397,69.150000000000006,64.650000000000006,825]
["2006-07-24",398.5,69.55,64.75,819]
["2006-07-21",392,68.2,63.4,808.5]
["2006-07-20",391.5,67.900000000000006,64,807.5]
["2006-07-19",391.25,68,63.4,814.5]
["2006-07-18",387,67.599999999999994,60.95,803.5]
["2006-07-17",391.25,67.55,61.05,801.5]
["2006-07-14",386,67.150000000000006,62.1,804.5]
["2006-07-13",383.5,68.099999999999994,63.1,813.5]
["2006-07-12",385,68.75,64.900000000000006,835.5]
["2006-07-11",382.75,68.3,65.3,824]
["2006-07-10",381.75,67.650000000000006,66.599999999999994,821.5]
["2006-07-07",382.75,66.8,66.3,827]
["2006-07-06",381,67.2,67.45,838]
["2006-07-05",381.75,66.599999999999994,67.2,841.5]
["2006-07-04",382,67.349999999999994,67.900000000000006,848]
["2006-07-03",383.25,66.75,67.95,848.5]
["2006-06-30",384,66.2,67,844.5]
["2006-06-29",378.5,65.75,65.95,844]
["2006-06-28",376,64.7,65.3,830.5]
["2006-06-27",372.75,64.599999999999994,65.349999999999994,820]
["2006-06-26",374.75,65.599999999999994,65.45,812]
["2006-06-23",375,65.599999999999994,65.7,796.5]
["2006-06-22",375,65.099999999999994,65.95,788.5]
["2006-06-21",373,64.650000000000006,65.25,788.5]
["2006-06-20",370.5,64.75,64.75,794.5]
["2006-06-19",371.25,64.45,64.2,791.5]
["2006-06-16",368.75,64.2,63.1,799]
["2006-06-15",368,64.3,63.85,796.5]
["2006-06-14",360.25,64.3,62.05,779]
["2006-06-13",359,64.7,61.9,778.5]
["2006-06-12",365.5,65.7,64.3,791.5]
["2006-06-09",366.25,66.400000000000006,66.05,802]
["2006-06-08",362.25,66,65.2,799]
["2006-06-07",366.75,67.25,67.75,807]
["2006-06-06",360,66.900000000000006,67.400000000000006,796]
["2006-06-05",365.5,68,69.7,785.5]
["2006-06-02",365.5,68,69.7,785.5]
["2006-06-01",363.75,67.599999999999994,69.75,772.5]
["2006-05-31",363.5,67.55,68.900000000000006,772.5]
["2006-05-30",362.25,67.349999999999994,67.8,781]
["2006-05-29",367,68.45,69.75,790]
["2006-05-26",367.75,68.900000000000006,70,787.5]
["2006-05-25",361.5,67.349999999999994,67.45,780]
["2006-05-24",361.5,67.349999999999994,67.45,780]
["2006-05-23",365.25,68.400000000000006,68.099999999999994,787.5]
["2006-05-22",359.75,67.75,66.7,780]
["2006-05-19",358.5,68.099999999999994,69.599999999999994,800]
["2006-05-18",360.5,68.900000000000006,68.099999999999994,803.5]
["2006-05-17",364,67.900000000000006,68.849999999999994,807]
["2006-05-16",369.75,69.5,71.75,809.5]
["2006-05-15",366.75,68,72.099999999999994,817.5]
["2006-05-12",370.25,68.75,72.8,809]
["2006-05-11",374.75,69,74.5,829]
["2006-05-10",378.75,69.45,74.349999999999994,827.5]
["2006-05-09",377.75,70.05,74.75,836]
["2006-05-08",378.5,70.25,75.3,829.5]
["2006-05-05",377.5,69.95,74.5,828]
["2006-05-04",375,70.099999999999994,72.25,823]
["2006-05-03",374.75,69.95,72.25,826.5]
["2006-05-02",380.75,71.45,72.599999999999994,825.5]
["2006-05-01",378.25,71.150000000000006,73.5,814]
["2006-04-28",378.25,71.150000000000006,73.5,814]
["2006-04-27",381.5,71.55,73.2,823]
["2006-04-26",382.5,71.349999999999994,73.25,831]
["2006-04-25",381.25,71.55,72.7,829.5]
["2006-04-24",384,72.400000000000006,72.75,840]
["2006-04-21",384.5,73.400000000000006,72.599999999999994,838.5]
["2006-04-20",384.25,72.5,72.5,835]
["2006-04-19",385.5,72.05,73.7,826.5]
["2006-04-18",382,71.5,72.7,811]
["2006-04-17",382.25,72.3,72.5,820]
["2006-04-14",382.25,72.3,72.5,820]
["2006-04-13",382.25,72.3,72.5,820]
["2006-04-12",380.25,72.349999999999994,72.150000000000006,823]
["2006-04-11",387.75,72.95,72.05,828]
["2006-04-10",385.25,74,73.3,845]
["2006-04-07",381.5,74.150000000000006,73.25,922]
["2006-04-06",383.25,73.8,73.099999999999994,920]
["2006-04-05",383.75,72.7,72.849999999999994,915.5]
["2006-04-04",385.5,72.45,72.05,916]
["2006-04-03",386.75,72.900000000000006,72.150000000000006,917.5]
["2006-03-31",387,72.5,71.599999999999994,908.5]
["2006-03-30",385,72.8,71.2,962.5]
["2006-03-29",381.75,72.400000000000006,70.650000000000006,966]
["2006-03-28",382,72.650000000000006,70.849999999999994,933]
["2006-03-27",382.75,72.349999999999994,71.2,914.5]
["2006-03-24",387,73.150000000000006,71.900000000000006,926]
["2006-03-23",385.25,73,71.8,932]
["2006-03-22",386.25,73.349999999999994,71.5,935]
["2006-03-21",385.75,72.5,71.599999999999994,926]
["2006-03-20",384.75,72.5,71.599999999999994,937]
["2006-03-17",387.5,73.150000000000006,70.599999999999994,941]
["2006-03-16",388.25,72.2,71,939]
["2006-03-15",387,72.400000000000006,70.8,939.5]
["2006-03-14",390.5,72.7,70.900000000000006,943]
["2006-03-13",392.5,73.45,70.5,928]
["2006-03-10",390.75,72.5,69.900000000000006,919.5]
["2006-03-09",383.5,71.5,68.3,926]
["2006-03-08",378.25,71.349999999999994,68.5,907]
["2006-03-07",378,70.55,69.5,936]
["2006-03-06",379.25,70.2,70.400000000000006,952]
["2006-03-03",380,70.5,70.400000000000006,929.5]
["2006-03-02",381.25,71.3,70.3,935.5]
["2006-03-01",385,71.55,70.849999999999994,950]
["2006-02-28",385.75,70.599999999999994,69.650000000000006,925]
["2006-02-27",384,72,71.150000000000006,943]
["2006-02-24",381.25,71.349999999999994,71.55,950]
["2006-02-23",386.5,71.150000000000006,71.7,949]
["2006-02-22",399.5,71.05,72.05,958]
["2006-02-21",398,71.25,71.5,952.5]
["2006-02-20",390,71.5,71.150000000000006,959]
["2006-02-17",390,71.45,70.099999999999994,981]
["2006-02-16",389,71,70,945]
["2006-02-15",382.75,70.900000000000006,68.75,939.5]
["2006-02-14",378.75,71.45,69.45,948.5]
["2006-02-13",380,71.400000000000006,70.2,959]
["2006-02-10",380.5,70.400000000000006,69.900000000000006,970]
["2006-02-09",379.5,70.8,69.75,979]
["2006-02-08",378.5,71.05,69.099999999999994,947.5]
["2006-02-07",377.75,71.05,69.650000000000006,946.5]
["2006-02-06",377,71.3,69.95,958.5]
["2006-02-03",377.5,72.25,69.099999999999994,959.5]
["2006-02-02",371.75,70.900000000000006,68.95,958]
["2006-02-01",375,71.5,69.5,970.5]
["2006-01-31",375,70.2,69.5,967.5]
["2006-01-30",377.5,70,68.75,976.5]
["2006-01-27",376,70.45,68.900000000000006,973]
["2006-01-26",380,70.25,68.05,975]
["2006-01-25",373.25,70.7,66.7,967.5]
["2006-01-24",376.75,70.8,66.849999999999994,975]
["2006-01-23",379.25,70.5,67,1075]
["2006-01-20",380,70.599999999999994,66.25,1085]
["2006-01-19",390,70.599999999999994,67.099999999999994,1070]
["2006-01-18",387.5,72.45,65.55,1075]
["2006-01-17",390.75,71.45,66.599999999999994,1067]
["2006-01-16",395.5,71.3,67.25,1077]
["2006-01-13",395,70.400000000000006,67,1081]
["2006-01-12",396.5,69.650000000000006,67.3,1075]
["2006-01-11",398,68.95,66.849999999999994,1088]
["2006-01-10",395.25,68.3,65,1075]
["2006-01-09",393.5,69.3,65.3,1044]
["2006-01-06",395.75,69.55,64.95,1032]
["2006-01-05",398,69.2,64.45,1031]
["2006-01-04",399.75,69.5,64.45,1039]
["2006-01-03",395.75,68.650000000000006,63.3,1050]
["2006-01-02",393,69.05,62.55,1047]
["2005-12-30",393,69.05,62.55,1047]
["2005-12-29",393.25,69.099999999999994,63.15,1050]
["2005-12-28",389.5,68.400000000000006,62.8,1048]
["2005-12-27",388.5,68.45,62.75,1040]
["2005-12-26",386.5,67.8,62.7,1040]
["2005-12-23",386.5,67.8,62.7,1040]
["2005-12-22",388,67.900000000000006,62.75,1041]
["2005-12-21",388.75,67.7,63.35,1029]
["2005-12-20",387.5,68.099999999999994,62.95,1025]
["2005-12-19",390.5,68.349999999999994,63.5,1040]
["2005-12-16",393,66.650000000000006,62.85,1043]
["2005-12-15",389,67.45,61.6,1021]
["2005-12-14",391.25,68.3,62.25,1005]
["2005-12-13",395.5,68.75,63,1002]
["2005-12-12",394.5,68.599999999999994,63,998]
["2005-12-09",393.5,69,62.95,1002]
["2005-12-08",393.75,68,63.2,1009]
["2005-12-07",392.75,68.55,63.3,1009]
["2005-12-06",396,69,63.45,1007]
["2005-12-05",395.75,69.099999999999994,62.6,1004]
["2005-12-02",397,70.05,63,977.5]
["2005-12-01",393.25,69.900000000000006,62.5,983]
["2005-11-30",390,68.849999999999994,60.65,964]
["2005-11-29",391.75,69.3,61.1,955]
["2005-11-28",391.5,69.349999999999994,61.4,950]
["2005-11-25",396.75,70.150000000000006,61.95,967]
["2005-11-24",394.75,70.05,62.15,972]
["2005-11-23",396.25,70.95,61.75,990]
["2005-11-22",395.5,71.25,61.35,965]
["2005-11-21",398.25,71.5,61.35,967.5]
["2005-11-18",399.75,71.3,60.85,947]
["2005-11-17",396.5,70.8,59.9,946.5]
["2005-11-16",391.25,70.150000000000006,59.1,942]
["2005-11-15",392.75,70.8,59.55,943]
["2005-11-14",391,70.599999999999994,59.7,941.5]
["2005-11-11",392,71.2,59.6,953]
["2005-11-10",387,70.3,58.85,941]
["2005-11-09",388.5,70.5,58.7,950.5]
["2005-11-08",385.75,71.3,58.55,928.5]
["2005-11-07",390,71.05,58.5,859.5]
["2005-11-04",388,70.45,58.3,846]
["2005-11-03",390,70,58.9,851]
["2005-11-02",383.75,69.3,57.7,841.5]
["2005-11-01",385,69.650000000000006,56.5,838]
["2005-10-31",384,69.349999999999994,54.75,834]
["2005-10-28",377.5,67.849999999999994,52.9,823.5]
["2005-10-27",381.75,68.400000000000006,53.3,817]
["2005-10-26",383.5,68.5,53.95,822]
["2005-10-25",382.75,68.75,54,822]
["2005-10-24",382.5,68.75,53.75,821]
["2005-10-21",383,68.099999999999994,53.25,819]
["2005-10-20",379,68.900000000000006,53.55,818.5]
["2005-10-19",365.5,68.900000000000006,52.75,822]
["2005-10-18",375.75,68.45,53.8,825]
["2005-10-17",375.25,65.650000000000006,54.5,833]
["2005-10-14",375,66,54.65,843]
["2005-10-13",374,66.3,54.6,837]
["2005-10-12",372,66.150000000000006,55.4,844.5]
["2005-10-11",376,66.400000000000006,55.85,860]
["2005-10-10",377,66.75,55.9,869]
["2005-10-07",381.75,66.3,55.85,863]
["2005-10-06",378,65.7,55.45,856]
["2005-10-05",387,66.599999999999994,55.75,857.5]
["2005-10-04",388,66.599999999999994,56.45,853]
["2005-10-03",386,66.849999999999994,56,859]
["2005-09-30",379,65.650000000000006,55,851]
["2005-09-29",376,64.849999999999994,55.55,835]
["2005-09-28",380.75,65.25,56.15,835.5]
["2005-09-27",377,64.55,55.25,829.5]
["2005-09-26",373.25,64.599999999999994,55.25,832.5]
["2005-09-23",367.75,64.150000000000006,54.35,830]
["2005-09-22",362.75,62.7,54.2,821.5]
["2005-09-21",364,62.65,54.55,829.5]
["2005-09-20",368,63.25,55,836]
["2005-09-19",370.75,62.45,54.4,839]
["2005-09-16",367.75,62.9,54.4,837]
["2005-09-15",365,62.55,53.9,839]
["2005-09-14",363,62.2,53.75,840.5]
["2005-09-13",360,61.8,53.35,839.5]
["2005-09-12",359.75,62.1,53.65,846.5]
["2005-09-09",357.25,61.5,53.75,841.5]
["2005-09-08",357.5,61.1,53.5,838]
["2005-09-07",357.5,61.3,53.45,849.5]
["2005-09-06",354,60.95,52.55,847]
["2005-09-05",350.5,60.5,51.9,836]
["2005-09-02",350,60.45,51.6,836]
["2005-09-01",354,61,51.5,834.5]
["2005-08-31",352,60.8,51.3,831]
["2005-08-30",345.25,60.55,51,832]
["2005-08-29",346.25,60.45,51.4,828.5]
["2005-08-26",343.75,59.9,51.4,826]
["2005-08-25",347.25,60.7,51.55,826]
["2005-08-24",350.5,61.2,52.2,832.5]
["2005-08-23",349.75,61.65,52.5,838]
["2005-08-22",352.25,62.35,52.85,841]
["2005-08-19",354.75,63,52.6,841]
["2005-08-18",351,62.4,52.2,840.5]
["2005-08-17",353.75,62.7,52.35,836.5]
["2005-08-16",358,62.1,52.4,839.5]
["2005-08-15",359,61.85,52.35,839]
["2005-08-12",356.75,62.4,52.3,843]
["2005-08-11",359.75,62.95,52.35,846]
["2005-08-10",360.25,63.15,52.3,847.5]
["2005-08-09",356.25,62.95,52.15,844.5]
["2005-08-08",356,62.65,52.95,855.5]
["2005-08-05",354.75,62.4,52.45,856.5]
["2005-08-04",353.25,62.7,52.4,860]
["2005-08-03",354,63.25,53.1,855.5]
["2005-08-02",357.25,63.35,52.6,862.5]
["2005-08-01",353,62.95,52.55,870.5]
["2005-07-29",353.5,62.7,52.95,865.5]
["2005-07-28",353.25,62.6,52.85,863.5]
["2005-07-27",348,62.6,52.4,864.5]
["2005-07-26",339,63,52.35,860]
["2005-07-25",338.25,63.15,52.15,858]
["2005-07-22",335.75,63,52.2,854.5]
["2005-07-21",336,63.15,52.2,861]
["2005-07-20",337.25,63.5,52.05,867]
["2005-07-19",338.75,63.45,52.3,842.5]
["2005-07-18",339.5,63.3,51.95,845.5]
["2005-07-15",340,62.6,52.1,847.5]
["2005-07-14",340.25,62,52.4,845]
["2005-07-13",338.25,61.05,51.9,837]
["2005-07-12",334.25,60.95,51.25,828]
["2005-07-11",334.5,61.25,51.6,840]
["2005-07-08",331.75,61.2,51.05,837.5]
["2005-07-07",328.75,60.65,50.45,831]
["2005-07-06",331.5,61.25,50.8,841.5]
["2005-07-05",331,61.4,50.65,826]
["2005-07-04",330.75,61.15,50.55,822]
["2005-07-01",329.5,61.4,50.4,823]
["2005-06-30",328,61.05,50,819]
["2005-06-29",329.5,60.8,50.1,822]
["2005-06-28",329.25,60.35,49.524999999999999,823.5]
["2005-06-27",328.5,60.55,49.125,811]
["2005-06-24",328.5,61.05,49.424999999999997,797]
["2005-06-23",331.25,61.35,49.75,802]
["2005-06-22",332.5,61.4,49.625,789.5]
["2005-06-21",330.75,61.7,49.975000000000001,782]
["2005-06-20",329,60.7,49.75,771]
["2005-06-17",331.75,60.9,49.8,765]
["2005-06-16",333,60.9,49.6,772]
["2005-06-15",334,61.4,49.45,772.5]
["2005-06-14",336.5,61.7,49.274999999999999,777.5]
["2005-06-13",336,61.9,49.35,769.5]
["2005-06-10",335.75,61.5,49.35,764]
["2005-06-09",336,61.9,49.35,768]
["2005-06-08",336,61.9,49.25,767.5]
["2005-06-07",337.5,61.75,49.274999999999999,760]
["2005-06-06",334.75,61.3,48.975000000000001,758]
["2005-06-03",336,61.6,49,757]
["2005-06-02",337.25,61.6,49.174999999999997,770]
["2005-06-01",333.5,61.45,49.05,767]
["2005-05-31",328.5,60.95,48.125,761.5]
["2005-05-30",332.5,61.1,48.625,776]
["2005-05-27",332,61.4,48.575000000000003,774.5]
["2005-05-26",332.25,61.3,48.3,778.5]
["2005-05-25",329,60.9,48.274999999999999,775]
["2005-05-24",327.5,60.05,48.45,780]
["2005-05-23",325.75,59.45,48.5,770]
["2005-05-20",325,59.15,48.1,776.5]
["2005-05-19",324.75,59,48.325000000000003,775.5]
["2005-05-18",324.25,59.2,48.075000000000003,773]
["2005-05-17",322.75,59,47.225000000000001,769]
["2005-05-16",322,59.2,47.524999999999999,779]
["2005-05-13",322,59.2,47.524999999999999,779]
["2005-05-12",322.75,59.05,47.674999999999997,777]
["2005-05-11",322,58.85,47.375,777]
["2005-05-10",321.5,58.9,47.274999999999999,780]
["2005-05-09",322.5,59.55,48.25,788]
["2005-05-06",324.75,59.7,48.55,789]
["2005-05-05",323.25,59.2,48.075000000000003,776]
["2005-05-04",323.25,59.2,48.075000000000003,776]
["2005-05-03",320.25,58.85,47.424999999999997,766.5]
["2005-05-02",317.75,58.4,48.15,763]
["2005-04-29",313,57.9,47.6,761.5]
["2005-04-28",311.5,57,47.325000000000003,780]
["2005-04-27",312.5,56.65,47.375,782.5]
["2005-04-26",316.75,57,48.35,782]
["2005-04-25",317.75,57.3,48.2,787]
["2005-04-22",317.75,57.6,48.274999999999999,794.5]
["2005-04-21",317,57.5,48.95,839.5]
["2005-04-20",318.75,57.15,48.975000000000001,835]
["2005-04-19",328,57.15,49.35,837]
["2005-04-18",324.5,55.95,49.5,839.5]
["2005-04-15",327.5,56.95,50.25,860.5]
["2005-04-14",329.5,56.95,51.1,846]
["2005-04-13",328.5,56.15,51.15,840.5]
["2005-04-12",326.75,56.3,50.9,851]
["2005-04-11",327.75,56.35,51.35,844.5]
["2005-04-08",328.5,56.65,51.25,846]
["2005-04-07",329.25,56.55,51.4,857.5]
["2005-04-06",326.75,56.85,50.85,864]
["2005-04-05",326,56.1,50.55,867]
["2005-04-04",324.25,55.35,50.5,861]
["2005-04-01",326.25,56,50.95,859]
["2005-03-31",327.25,55.8,50.5,868]
["2005-03-30",326.75,56.05,50.25,841]
["2005-03-29",326.25,56.35,50.6,840.5]
["2005-03-28",324.5,56.2,50.25,844]
["2005-03-25",324.5,56.2,50.25,844]
["2005-03-24",324.5,56.2,50.25,844]
["2005-03-23",322.75,55.8,50.35,849]
["2005-03-22",319.5,55.55,50.75,848]
["2005-03-21",321.25,55.75,50.3,857]
["2005-03-18",323.25,56.25,50.55,855]
["2005-03-17",325,56.7,50.8,854.5]
["2005-03-16",327,56.05,51.05,858]
["2005-03-15",329,56.65,51.7,870]
["2005-03-14",329,56.35,51.45,857.5]
["2005-03-11",327.5,56.65,51.55,868]
["2005-03-10",325.5,56.5,51.45,843]
["2005-03-09",326.5,56.8,51.7,858]
["2005-03-08",325,57.2,51.7,870]
["2005-03-07",326,57.65,51.65,880.5]
["2005-03-04",325.75,58,51.25,892]
["2005-03-03",325.75,58.6,51.1,869]
["2005-03-02",326,59.1,50.95,864.5]
["2005-03-01",326.5,58.6,50.45,862.5]
["2005-02-28",322.5,58.25,50.45,855]
["2005-02-25",322.25,58.2,50.75,718.5]
["2005-02-24",316.75,57.95,50.95,715.5]
["2005-02-23",313.75,58.1,50.5,723]
["2005-02-22",317.75,58.9,50.3,723]
["2005-02-21",317.25,58.85,50.65,730]
["2005-02-18",314.75,57.3,51.25,733]
["2005-02-17",314.75,57.15,51.25,716]
["2005-02-16",315,57.65,51.15,715]
["2005-02-15",317.25,57.75,51.85,716]
["2005-02-14",317.25,57.7,52.15,718]
["2005-02-11",317.75,57.8,52.3,723]
["2005-02-10",317,57.7,51.35,721]
["2005-02-09",315.25,58.15,50.95,726.5]
["2005-02-08",317.5,57.8,51.05,726]
["2005-02-07",318.75,57.95,49.825000000000003,725]
["2005-02-04",317.5,57.45,49.774999999999999,720]
["2005-02-03",317.5,57.55,49.1,715]
["2005-02-02",315.75,57.25,49.2,727]
["2005-02-01",314.75,57,48.575000000000003,731.5]
["2005-01-31",312,57,48.225000000000001,735.5]
["2005-01-28",313,56.85,48.1,731.5]
["2005-01-27",312.75,57.25,48.35,730.5]
["2005-01-26",312.25,57.65,48.375,734.5]
["2005-01-25",310.75,57.6,48.5,736]
["2005-01-24",308.75,57.3,48.225000000000001,731.5]
["2005-01-21",305.5,57,48.274999999999999,734.5]
["2005-01-20",304.5,56.8,48.25,735.5]
["2005-01-19",306,57.1,48.325000000000003,739]
["2005-01-18",306.25,57.25,47.85,751.5]
["2005-01-17",308.75,57.45,47.85,758]
["2005-01-14",308.5,57.05,47.2,763]
["2005-01-13",308.5,56.3,46.75,760.5]
["2005-01-12",308,55.8,46.975000000000001,752]
["2005-01-11",302.75,56.65,47.625,751]
["2005-01-10",300.75,56.6,47.924999999999997,750]
["2005-01-07",301,56.8,47.875,747.5]
["2005-01-06",300.5,57.15,48.174999999999997,749]
["2005-01-05",299,57.05,48.024999999999999,733.5]
["2005-01-04",301.25,57.75,48.6,748]
["2005-01-03",301,58,48.55,748]
["2004-12-31",297.5,57.3,47.674999999999997,749]
["2004-12-30",297.5,57.3,47.674999999999997,749]
["2004-12-29",298,57.25,47.8,744.5]
["2004-12-28",297.25,57.15,47.85,745]
["2004-12-27",297.25,56.85,47.875,747]
["2004-12-24",296.5,56.7,48.125,749]
["2004-12-23",296.5,56.7,48.125,749]
["2004-12-22",296.25,56.7,48.174999999999997,743.5]
["2004-12-21",294.5,56.55,47.5,743]
["2004-12-20",295.5,56.55,48.05,735]
["2004-12-17",293.5,56.05,47.6,726]
["2004-12-16",295.5,57.25,48.05,726.5]
["2004-12-15",299,57.1,47.95,715]
["2004-12-14",299.25,57.2,48.05,720]
["2004-12-13",300.5,56.75,47.825000000000003,714.5]
["2004-12-10",297,56.45,47.174999999999997,718.5]
["2004-12-09",296,56.4,46.625,728]
["2004-12-08",295.5,56.4,46.75,729]
["2004-12-07",295,56.2,46.825000000000003,734.5]
["2004-12-06",295.75,55.8,46.75,732]
["2004-12-03",298,56.2,47.024999999999999,734.5]
["2004-12-02",297.75,56.05,47.25,732]
["2004-12-01",294,55.6,46.7,727]
["2004-11-30",292.5,54.6,46.05,733]
["2004-11-29",297,55.85,46.524999999999999,736.5]
["2004-11-26",300.5,55.8,46.524999999999999,738.5]
["2004-11-25",297.5,56.05,46.55,735]
["2004-11-24",295.25,55.45,46.35,744]
["2004-11-23",298.25,55.85,46.524999999999999,739]
["2004-11-22",298.75,56.45,46.774999999999999,739]
["2004-11-19",302.5,57,46.8,740.5]
["2004-11-18",305.5,58.45,47.225000000000001,749]
["2004-11-17",306.75,58.5,47.2,754]
["2004-11-16",305.5,58.55,46.774999999999999,754]
["2004-11-15",307.75,58.7,46.95,754]
["2004-11-12",307.75,59,46.9,757]
["2004-11-11",306.75,58.75,46.2,755]
["2004-11-10",303.25,58.8,45.95,748]
["2004-11-09",299.75,58.15,45.75,745.5]
["2004-11-08",301.75,58.95,45.975000000000001,740]
["2004-11-05",301.25,59.35,46.05,758.5]
["2004-11-04",298.5,58.85,45.25,753.5]
["2004-11-03",294.5,59,45.6,748]
["2004-11-02",295,58.05,44.975000000000001,744]
["2004-11-01",288,57.8,43.75,744]
["2004-10-29",283.25,57.1,43.15,744.5]
["2004-10-28",286.5,57.65,43.625,747]
["2004-10-27",284.25,57.15,42.725000000000001,746]
["2004-10-26",285,56.5,42.5,744.5]
["2004-10-25",285,56.35,42,747]
["2004-10-22",286.5,57.35,43.024999999999999,761.5]
["2004-10-21",290.75,57.5,43.15,753]
["2004-10-20",287,57.1,42.95,742.5]
["2004-10-19",286,57.75,43.8,739.5]
["2004-10-18",281,56.9,43.65,734]
["2004-10-15",279.75,56.6,43.75,727]
["2004-10-14",280,57,43.9,738]
["2004-10-13",281,57.3,44.325000000000003,746]
["2004-10-12",280.25,57.25,44.3,747.5]
["2004-10-11",283.25,57.25,44.575000000000003,759]
["2004-10-08",285.5,57.4,44.575000000000003,772.5]
["2004-10-07",285.5,57.55,44.95,762]
["2004-10-06",290,58.8,44.9,770]
["2004-10-05",291.5,59.15,44.95,776.5]
["2004-10-04",293,59.35,45.075000000000003,775]
["2004-10-01",287.5,58.8,44.774999999999999,758]
["2004-09-30",286,58.2,43.95,771]
["2004-09-29",290.5,59.2,44.6,777]
["2004-09-28",289.5,58.9,44.3,769]
["2004-09-27",285.5,58.5,44.1,763]
["2004-09-24",284.5,59.1,44.6,775]
["2004-09-23",286.5,59.2,44.325000000000003,780]
["2004-09-22",290,59.5,45.05,788]
["2004-09-21",294.5,59.75,45.5,798]
["2004-09-20",293.5,59.3,44.55,793]
["2004-09-17",293.5,59.4,44.9,798]
["2004-09-16",292.5,59.15,44.375,796]
["2004-09-15",295.5,59.35,44.424999999999997,799]
["2004-09-14",299,59.05,44.5,805]
["2004-09-13",301.5,59.6,44.7,807]
["2004-09-10",300.5,59.55,44.424999999999997,815]
["2004-09-09",299,59.6,44.375,806]
["2004-09-08",301,59.95,44.674999999999997,810]
["2004-09-07",303,59.65,44.75,817]
["2004-09-06",303,59.8,44.375,815]
["2004-09-03",302,59.5,43.95,810]
["2004-09-02",297.5,59.15,43.45,806]
["2004-09-01",302.5,59.25,43.1,812]
["2004-08-31",299.5,58.55,42.45,808]
["2004-08-30",299.5,58.4,43.45,812]
["2004-08-27",300,58.5,43.625,820]
["2004-08-26",297.5,58.1,43.45,818]
["2004-08-25",298.5,57.65,42.575000000000003,806]
["2004-08-24",297,57.55,43.075000000000003,798]
["2004-08-23",300.5,57.8,43.05,802]
["2004-08-20",300,57.55,42.45,786]
["2004-08-19",299.5,57.6,42.625,786]
["2004-08-18",298,57.3,42.325000000000003,783]
["2004-08-17",314,57.5,42.3,779]
["2004-08-16",314,57.2,42.15,771]
["2004-08-13",313,56.9,41.325000000000003,775]
["2004-08-12",316,57.2,41.325000000000003,780]
["2004-08-11",316.5,56.85,41.35,770]
["2004-08-10",321,56.5,40.875,767]
["2004-08-09",318.5,56.5,40.799999999999997,751]
["2004-08-06",323,56.8,41.1,756]
["2004-08-05",326.5,57.85,42.375,777]
["2004-08-04",327,57.9,41.875,774]
["2004-08-03",329.5,57.95,43.1,793]
["2004-08-02",325,57.5,42.875,780]
["2004-07-30",327,57.25,42.8,792]
["2004-07-29",328,56.9,43.125,774]
["2004-07-28",326.5,56.7,42.95,773]
["2004-07-27",328.5,56.9,42.575000000000003,776]
["2004-07-26",325,56.45,42.15,759]
["2004-07-23",329,56.8,42.35,753]
["2004-07-22",327,56.6,42.075000000000003,734]
["2004-07-21",331,57.15,42.9,769]
["2004-07-20",332,55.7,42.2,750]
["2004-07-19",332.5,53.25,41.85,745]
["2004-07-16",336.5,53.65,41.524999999999999,745]
["2004-07-15",337,54.6,41.424999999999997,745]
["2004-07-14",337.5,55,42.625,751]
["2004-07-13",334,54.65,42.8,754]
["2004-07-12",332.5,54.7,42.85,755]
["2004-07-09",332,54.6,43.05,754]
["2004-07-08",335,54.85,43.225000000000001,762]
["2004-07-07",332,54.3,43.2,762]
["2004-07-06",332.5,54.4,43.325000000000003,774]
["2004-07-05",331.5,54.8,43.774999999999999,786]
["2004-07-02",333,55.2,43.7,777]
["2004-07-01",335.5,55.45,43.825000000000003,774]
["2004-06-30",334,55.25,44.125,789]
["2004-06-29",338,56.25,44.8,796]
["2004-06-28",339,56.35,44.9,802]
["2004-06-25",337.5,56.5,44.674999999999997,813]
["2004-06-24",337.5,56.5,44.575000000000003,803]
["2004-06-23",335.5,56.75,44.6,788]
["2004-06-22",334.5,56.8,44.85,790]
["2004-06-21",333.5,57.5,45.85,805]
["2004-06-18",331.5,57.15,45.774999999999999,795]
["2004-06-17",332,57.15,45.95,795]
["2004-06-16",331,57.25,46.15,789]
["2004-06-15",329.5,57.2,45.625,780]
["2004-06-14",328,56.75,45.475000000000001,784]
["2004-06-11",330,57.3,46,793]
["2004-06-10",331,57.3,45.85,791]
["2004-06-09",332,57.7,46,794]
["2004-06-08",331.5,57.75,45.924999999999997,795]
["2004-06-07",333,57.4,46.024999999999999,790]
["2004-06-04",330,56.9,45.55,786]
["2004-06-03",330.5,56.75,45.274999999999999,780]
["2004-06-02",326,56.6,45,772]
["2004-06-01",323.5,56.1,44.725000000000001,770]
["2004-05-31",326,56.2,44.95,778]
["2004-05-28",326,56.2,44.95,778]
["2004-05-27",329.5,56.95,45.975000000000001,793]
["2004-05-26",326.5,56.95,45.75,789]
["2004-05-25",324.5,56.75,45.575000000000003,782]
["2004-05-24",325.5,56.9,45.875,787]
["2004-05-21",324.5,56.55,45.325000000000003,782]
["2004-05-20",330,57.6,45.825000000000003,781]
["2004-05-19",330,57.6,45.825000000000003,781]
["2004-05-18",330,57.5,44.774999999999999,765]
["2004-05-17",328.5,57.2,44.774999999999999,772]
["2004-05-14",330.5,57.5,45.4,774]
["2004-05-13",331.5,57.85,45.8,780]
["2004-05-12",329,57.25,44.75,762]
["2004-05-11",331,57.9,45.075000000000003,783]
["2004-05-10",327,57.1,44.45,768]
["2004-05-07",337,58.6,46.524999999999999,791]
["2004-05-06",337,58.25,46.9,786]
["2004-05-05",339,58.6,47.674999999999997,790]
["2004-05-04",335,58.35,46.674999999999997,789]
["2004-05-03",332,58.2,46.85,795]
["2004-04-30",328,57.8,46.075000000000003,777]
["2004-04-29",333,57.35,45.625,785]
["2004-04-28",331.5,56.6,45.95,803]
["2004-04-27",339.5,57.3,46.1,804]
["2004-04-26",341,58.05,46.524999999999999,798]
["2004-04-23",340.5,56.1,47.05,793]
["2004-04-22",340.5,56.2,46.475000000000001,794]
["2004-04-21",338,57.35,46.125,798]
["2004-04-20",334,57.5,46.924999999999997,803]
["2004-04-19",332,57.1,46.75,800]
["2004-04-16",329.5,56.65,46.5,804]
["2004-04-15",332,56.25,47.25,785]
["2004-04-14",331,54.85,48.174999999999997,762]
["2004-04-13",330.5,55,49.174999999999997,778]
["2004-04-12",327.5,55.5,48.625,804]
["2004-04-09",327.5,55.5,48.625,804]
["2004-04-08",327.5,55.5,48.625,804]
["2004-04-07",326.5,55.3,48.5,800]
["2004-04-06",325,55.1,48.7,796]
["2004-04-05",328,55.8,48.75,803]
["2004-04-02",328.5,54.75,48.6,798]
["2004-04-01",325.5,54.5,48.024999999999999,789]
["2004-03-31",323,53.8,47.05,782]
["2004-03-30",324,54.2,47.274999999999999,792]
["2004-03-29",323.5,54.35,47.375,807]
["2004-03-26",319,54.25,46.9,801]
["2004-03-25",319,54.75,46.35,805]
["2004-03-24",317.5,53,46.174999999999997,782]
["2004-03-23",318.5,53.1,46.3,785]
["2004-03-22",317,52.1,45.825000000000003,781]
["2004-03-19",324.5,54,47.3,812]
["2004-03-18",322,53.6,46.85,806]
["2004-03-17",327.5,54.3,47.475000000000001,812]
["2004-03-16",328.5,53.95,46.875,813]
["2004-03-15",329.5,53.75,46.25,820]
["2004-03-12",333.5,54.25,46.8,822]
["2004-03-11",334.5,54.3,46.674999999999997,829]
["2004-03-10",336.5,56.75,48.174999999999997,844]
["2004-03-09",333.5,56.15,47.95,841]
["2004-03-08",331.5,56,48.524999999999999,847]
["2004-03-05",332,56,48.325000000000003,848]
["2004-03-04",334,57,48.475000000000001,851]
["2004-03-03",333,56.7,47.875,848]
["2004-03-02",334,57.1,48.1,863]
["2004-03-01",333.5,56.5,46.725000000000001,852]
["2004-02-27",335,55.95,46.65,847]
["2004-02-26",335,56.65,47.2,837]
["2004-02-25",346,56.85,47.125,847]
["2004-02-24",342.5,56.6,47.2,830]
["2004-02-23",343.5,56.75,48.05,850]
["2004-02-20",342.5,56.5,47.85,862]
["2004-02-19",342,56.8,47.95,875]
["2004-02-18",340,57,48.05,880]
["2004-02-17",343,57.55,48.45,928]
["2004-02-16",342,58.15,48.1,930]
["2004-02-13",340,58.25,48.424999999999997,927]
["2004-02-12",337.5,58,48,927]
["2004-02-11",338,58.45,47.424999999999997,922]
["2004-02-10",339,58.45,47.575000000000003,921]
["2004-02-09",342,58.5,46.45,923]
["2004-02-06",341.5,58.3,45.274999999999999,929]
["2004-02-05",339,57.5,44.825000000000003,930]
["2004-02-04",338,57.45,45.424999999999997,933]
["2004-02-03",331.5,56.5,45.35,926]
["2004-02-02",332.5,57.25,45.674999999999997,951]
["2004-01-30",332,56.65,45.125,967]
["2004-01-29",330,58.5,45.05,956]
["2004-01-28",331,58.4,45.625,968]
["2004-01-27",330,58.5,45.5,942]
["2004-01-26",329.5,58.35,45.325000000000003,928]
["2004-01-23",332.5,58.5,45.3,915]
["2004-01-22",330.5,58.2,45.024999999999999,914]
["2004-01-21",328,57.55,44.8,906]
["2004-01-20",324,57.8,44.575000000000003,911]
["2004-01-19",323.5,57.8,44.975000000000001,909]
["2004-01-16",323,57.85,45.225000000000001,912]
["2004-01-15",319.5,57.55,44.6,888]
["2004-01-14",321.5,57.85,44.4,894]
["2004-01-13",319.5,57.3,44.075000000000003,888]
["2004-01-12",315.5,56.95,43.9,876]
["2004-01-09",320,57.15,44.075000000000003,881]
["2004-01-08",321,57.3,44.024999999999999,891]
["2004-01-07",319,57.75,43.55,882]
["2004-01-06",319,57.75,43.325000000000003,891]
["2004-01-05",317,57.55,42.85,905]
["2004-01-02",309,56.15,42.35,882]
["2004-01-01",309,56.15,42.35,882]
["2003-12-31",309,56.15,42.35,882]
["2003-12-30",309,56.15,42.35,882]
["2003-12-29",306,55.6,42.15,866]
["2003-12-26",304,55.15,42.1,855]
["2003-12-25",304,55.15,42.1,855]
["2003-12-24",304,55.15,42.1,855]
["2003-12-23",304,55.15,42.1,855]
["2003-12-22",304,54.75,42,848]
["2003-12-19",307,55,42.524999999999999,851]
["2003-12-18",305.5,55.3,42.424999999999997,852]
["2003-12-17",303,54.55,42.024999999999999,841]
["2003-12-16",301.5,55.1,42.05,857]
["2003-12-15",302,55.7,42.225000000000001,866]
["2003-12-12",300.5,55.45,42.15,870]
["2003-12-11",302.5,55.75,42.1,875]
["2003-12-10",300.5,55.4,41.55,874]
["2003-12-09",302,55.7,42.075000000000003,874]
["2003-12-08",297.5,54.8,42,880]
["2003-12-05",297,54.9,41.825000000000003,883]
["2003-12-04",301,55.6,42.375,886]
["2003-12-03",303.5,55.6,42.7,899]
["2003-12-02",301.5,54.85,42.075000000000003,889]
["2003-12-01",303,54.8,42.2,893]
["2003-11-28",300.5,54.6,41.625,890]
["2003-11-27",298.5,54.4,41.625,895]
["2003-11-26",296.5,54.4,41.475000000000001,897]
["2003-11-25",297,54.4,41.274999999999999,895]
["2003-11-24",295.5,54.95,41.05,896]
["2003-11-21",292,53.7,40.1,900]
["2003-11-20",291.5,53.7,40.200000000000003,895]
["2003-11-19",291.5,53.1,40.450000000000003,892]
["2003-11-18",291,53.65,41.274999999999999,896]
["2003-11-17",294,53.9,41.375,896]
["2003-11-14",297.5,54.25,42.1,908]
["2003-11-13",299.5,52.3,42.1,903]
["2003-11-12",299.5,51.45,42.125,900]
["2003-11-11",299.5,51.4,42.174999999999997,906]
["2003-11-10",301,51,40.950000000000003,913]
["2003-11-07",303,51.3,41.55,945]
["2003-11-06",300,51.15,40.799999999999997,923]
["2003-11-05",296.5,50.75,40.475000000000001,915]
["2003-11-04",297.5,51.35,41.25,917]
["2003-11-03",299.5,51.95,41.65,925]
["2003-10-31",294,50.9,41,922]
["2003-10-30",297.5,50.75,40.825000000000003,933]
["2003-10-29",297,50.55,40.225000000000001,915]
["2003-10-28",298,51.4,40.25,905]
["2003-10-27",298.5,51.4,39.950000000000003,903]
["2003-10-24",297,51.15,39.6,887]
["2003-10-23",297.5,50.9,39.549999999999997,892]
["2003-10-22",300,51.35,39.950000000000003,903]
["2003-10-21",304.5,52.35,40.35,912]
["2003-10-20",303.5,53.25,40.475000000000001,895]
["2003-10-17",306,52.8,39.975000000000001,895]
["2003-10-16",305.5,52.7,40.049999999999997,888]
["2003-10-15",303,52.85,39.975000000000001,905]
["2003-10-14",304,53.05,39.9,886]
["2003-10-13",305,53.75,39.75,888]
["2003-10-10",303.5,52.8,39.35,874]
["2003-10-09",304.5,52.65,39.450000000000003,875]
["2003-10-08",304.5,51.4,39,868]
["2003-10-07",305.5,51.25,38.975000000000001,870]
["2003-10-06",306.5,51.7,38.799999999999997,890]
["2003-10-03",310,52.25,38.924999999999997,893]
["2003-10-02",305,51.6,37.825000000000003,883]
["2003-10-01",304.5,51.3,37.424999999999997,863]
["2003-09-30",304.5,51.1,37.049999999999997,864]
["2003-09-29",307,51.15,38.15,878]
["2003-09-26",309,51.55,38.325000000000003,897]
["2003-09-25",308.5,52,38.299999999999997,898]
["2003-09-24",309.5,52.6,38.725000000000001,925]
["2003-09-23",302,53.85,38.6,916]
["2003-09-22",306,53.6,38.975000000000001,922]
["2003-09-19",313.5,54.95,39.75,938]
["2003-09-18",312.5,55.5,39.799999999999997,950]
["2003-09-17",313,55.5,39.5,935]
["2003-09-16",311.5,55.7,38.799999999999997,925]
["2003-09-15",311,54.85,38.524999999999999,921]
["2003-09-12",308,54.9,38.475000000000001,919]
["2003-09-11",310,55.15,38.4,918]
["2003-09-10",308,55.25,38.65,927]
["2003-09-09",302,54.8,39,936]
["2003-09-08",306.5,54.85,39.274999999999999,934]
["2003-09-05",305.5,54.4,39.274999999999999,928]
["2003-09-04",305.5,53.65,39.450000000000003,932]
["2003-09-03",306,53.15,39.375,936]
["2003-09-02",305.5,52,38.200000000000003,907]
["2003-09-01",309.5,52.5,38.5,911]
["2003-08-29",305,51.5,37.774999999999999,887]
["2003-08-28",309,52.15,38.75,882]
["2003-08-27",308.5,52.4,38.524999999999999,876]
["2003-08-26",306.5,52.15,38.35,870]
["2003-08-25",304,52.55,38.475000000000001,872]
["2003-08-22",307.5,53.15,39.075000000000003,868]
["2003-08-21",302,52.5,39.35,858]
["2003-08-20",293.5,52.3,39.700000000000003,855]
["2003-08-19",287.5,52.7,39.875,879]
["2003-08-18",288,52.85,39.9,872]
["2003-08-15",289,52.3,39.524999999999999,868]
["2003-08-14",286,51.4,39.125,856]
["2003-08-13",281,51.05,39.549999999999997,859]
["2003-08-12",279,51.75,40.25,859]
["2003-08-11",275.5,51.4,39.75,852]
["2003-08-08",274.5,51.5,39.825000000000003,848]
["2003-08-07",273.5,51.75,39.4,846]
["2003-08-06",273,51.85,39.35,846]
["2003-08-05",275,51.9,39.674999999999997,868]
["2003-08-04",271.5,51.55,39.1,875]
["2003-08-01",273.5,52.1,39.774999999999999,875]
["2003-07-31",274,52.95,40.200000000000003,890]
["2003-07-30",276,53.2,39.924999999999997,881]
["2003-07-29",274,52.5,39.575000000000003,871]
["2003-07-28",274.5,53.2,39.625,870]
["2003-07-25",273.5,53.05,39.225000000000001,876]
["2003-07-24",278,53.15,39.375,885]
["2003-07-23",274.5,52.45,39.075000000000003,806]
["2003-07-22",270,52,39.35,805]
["2003-07-21",269,51.9,39.375,807]
["2003-07-18",271.5,52,39.375,821]
["2003-07-17",270.5,52.6,39.075000000000003,812]
["2003-07-16",273,52.25,39.475000000000001,814]
["2003-07-15",273.5,52.6,39.325000000000003,806]
["2003-07-14",277.5,53.25,39.049999999999997,810]
["2003-07-11",275.5,53.05,38.274999999999999,807]
["2003-07-10",274.5,52.4,37.774999999999999,800]
["2003-07-09",275,52.4,37.774999999999999,800]
["2003-07-08",278,52.8,38.024999999999999,800]
["2003-07-07",283,53,38,796]
["2003-07-04",276,52.6,37.4,786]
["2003-07-03",275.5,52.65,37.5,781]
["2003-07-02",277,52.4,37.024999999999999,775]
["2003-07-01",273.5,52,36.75,776]
["2003-06-30",279.5,53.6,37.674999999999997,796]
["2003-06-27",278,54.6,37.75,816]
["2003-06-26",284,54.75,37.325000000000003,817]
["2003-06-25",282,54.25,37.024999999999999,798]
["2003-06-24",286.5,54.15,36.774999999999999,777]
["2003-06-23",285.5,53.95,36.825000000000003,805]
["2003-06-20",294,54.9,37.5,825]
["2003-06-19",291,55,37.174999999999997,815]
["2003-06-18",292,55.3,37.774999999999999,834]
["2003-06-17",285,54.1,37.75,832]
["2003-06-16",280.5,53.15,37.65,831]
["2003-06-13",273.5,52,37.225000000000001,834]
["2003-06-12",275.5,52.9,37.85,845]
["2003-06-11",270,53.2,37.875,834]
["2003-06-10",263.5,53.35,37.424999999999997,814]
["2003-06-09",264.5,53.2,37.4,827]
["2003-06-06",264.5,53.2,37.4,827]
["2003-06-05",266,51.8,36.799999999999997,802]
["2003-06-04",267.5,52.7,37,792]
["2003-06-03",271,52.9,36.375,767]
["2003-06-02",273,52.95,36.5,779]
["2003-05-30",273,51.05,35.1,765]
["2003-05-29",270.5,53,35.700000000000003,757]
["2003-05-28",270.5,53,35.700000000000003,757]
["2003-05-27",272,51.7,34.924999999999997,720]
["2003-05-26",265,51.4,34.774999999999999,710]
["2003-05-23",265.5,52,34.950000000000003,713]
["2003-05-22",266,52,34.85,712]
["2003-05-21",267,50.4,33.9,703]
["2003-05-20",270.5,51.35,34.6,711]
["2003-05-19",267,51.6,34.549999999999997,708]
["2003-05-16",268.5,53.25,35.5,725]
["2003-05-15",270,52.8,34.75,708]
["2003-05-14",272,52.8,34.075000000000003,704]
["2003-05-13",273.5,53,33.9,692]
["2003-05-12",272.5,52.95,32.524999999999999,696]
["2003-05-09",275.5,53.35,32.424999999999997,700]
["2003-05-08",274.5,53.2,32.674999999999997,710]
["2003-05-07",277.5,54.4,33.450000000000003,724]
["2003-05-06",279,54.6,33.85,739]
["2003-05-05",277,54.3,32.875,753]
["2003-05-02",270.5,53.5,32.299999999999997,752]
["2003-05-01",276.5,53.5,32.174999999999997,736]
["2003-04-30",276.5,53.5,32.174999999999997,736]
["2003-04-29",275,53.4,32.450000000000003,726]
["2003-04-28",279.5,54.25,32.65,720]
["2003-04-25",275,53.4,32.15,701]
["2003-04-24",276.5,53.95,33,697]
["2003-04-23",275.5,54.5,33.524999999999999,735]
["2003-04-22",277.5,53.9,33.274999999999999,710]
["2003-04-21",283,53.65,33.075000000000003,699]
["2003-04-18",283,53.65,33.075000000000003,699]
["2003-04-17",283,53.65,33.075000000000003,699]
["2003-04-16",285.5,53.75,33.5,720]
["2003-04-15",287,54.4,33.875,727]
["2003-04-14",283,53.05,33.125,713]
["2003-04-11",280,53.05,32.575000000000003,713]
["2003-04-10",276.5,52.85,32.024999999999999,704]
["2003-04-09",279.5,54.25,32.424999999999997,708]
["2003-04-08",284,54.15,32.5,703]
["2003-04-07",281,54.15,32.575000000000003,716]
["2003-04-04",281,53.45,31.625,685]
["2003-04-03",279,52.35,31.05,683]
["2003-04-02",278,51.4,30.625,660]
["2003-04-01",274.5,49.75,29.45,649]
["2003-03-31",267.5,50.05,28.75,646]
["2003-03-28",271.5,51.6,29.725000000000001,650]
["2003-03-27",272.5,51.5,29.25,642]
["2003-03-26",276,51.8,30,650]
["2003-03-25",271.5,52.25,30.05,654]
["2003-03-24",265.5,52.1,30.25,650]
["2003-03-21",280.5,54.8,31.6,672]
["2003-03-20",272.5,52.75,29.925000000000001,664]
["2003-03-19",264.5,51.6,30.75,663]
["2003-03-18",259,50,30.65,660]
["2003-03-17",259.5,49.3,30.225000000000001,637]
["2003-03-14",258,48.25,29.5,611]
["2003-03-13",252.5,46.05,26.774999999999999,584]
["2003-03-12",245,46.1,24.9,567]
["2003-03-11",237,46.4,26,574]
["2003-03-10",239.5,46.65,25.925000000000001,577]
["2003-03-07",245.25,47.8,27.15,602]
["2003-03-06",250.5,48.4,27.65,612]
["2003-03-05",254,48.6,26.774999999999999,609]
["2003-03-04",260,49,27.425000000000001,621]
["2003-03-03",268.5,50.25,28.8,629]
["2003-02-28",273,49.8,28.45,602]
["2003-02-27",263,49.2,28.125,592]
["2003-02-26",268,48.55,27.774999999999999,597]
["2003-02-25",276,47.8,28.125,613]
["2003-02-24",275,48,29,619]
["2003-02-21",272,48.2,29.824999999999999,621]
["2003-02-20",268.5,47.95,30,628]
["2003-02-19",264.5,48.15,29.425000000000001,638]
["2003-02-18",275,49.25,30.6,648]
["2003-02-17",273.5,49.6,32.25,621]
["2003-02-14",268.5,49.3,30.75,620]
["2003-02-13",261,48.25,29.425000000000001,634]
["2003-02-12",258.5,48.6,29,643]
["2003-02-11",267.5,50.05,29.425000000000001,628]
["2003-02-10",264,48.35,28.4,628]
["2003-02-07",266,48.4,28.9,638]
["2003-02-06",268.5,48,29.2,635]
["2003-02-05",279,49.2,30.1,646]
["2003-02-04",279,48.85,29.25,670]
["2003-02-03",284,50.15,30.25,659]
["2003-01-31",284,50,29.524999999999999,670]
["2003-01-30",271.5,50.3,30.175000000000001,670]
["2003-01-29",272,48.9,29.6,670]
["2003-01-28",277,46.2,29.65,675]
["2003-01-27",274,46.8,29.625,684]
["2003-01-24",277.5,49.6,30.25,698]
["2003-01-23",274.5,50.4,30.725000000000001,700]
["2003-01-22",280,49.9,30.7,725]
["2003-01-21",286,50.8,32.15,745]
["2003-01-20",289,50.85,32.924999999999997,758]
["2003-01-17",292.5,51.75,33.6,749]
["2003-01-16",295,52.35,34.5,792]
["2003-01-15",298.5,52.6,35.174999999999997,764]
["2003-01-14",306,53.65,35.674999999999997,785]
["2003-01-13",302,53,35.25,775]
["2003-01-10",299.5,53.65,35.049999999999997,752]
["2003-01-09",304,53.5,34.950000000000003,750]
["2003-01-08",305.5,54,35.049999999999997,764]
["2003-01-07",303.5,53.95,35.6,775]
["2003-01-06",305,54,36.049999999999997,775]
["2003-01-03",306,53.8,35.700000000000003,763]
["2003-01-02",293,50.45,33.6,741]
["2003-01-01",293,50.45,33.6,741]
["2002-12-31",293,50.45,33.6,741]
[]
[]
["Ecartype",{"$f":"STDEV(B61:B995)","v":38.673747965945218},{"$f":"STDEV(C61:C995)","v":6.578825060622381},{"$f":"STDEV(D61:D995)","v":11.412327748178813},{"$f":"STDEV(E61:E995)","v":89.256150596019495}]
[]
["* pas de ligne total - car la fonction SOUS.TOTAL ne calculera l'écartype que sur les lignes affichées !"]