{"text_format":"2","workbook":"xlsx","n_sheets":4,"sheets":["Fonctions .SI","La fonction Si","Si Imbriqués 1","Si Imbriqués 2"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Fonctions .SI","index":0,"n_rows":17,"n_cols":15,"rows_kept":17,"cut":false,"hidden":false,"merged":[[11,10,12,11],[11,13,12,14],[0,0,0,5],[0,10,0,11],[0,13,0,14],[2,7,2,8],[16,7,16,8],[0,7,1,8],[6,7,8,8],[9,7,9,8],[13,7,15,8]]}
["VENTES OCTOBRE",{"$nulls":6},"Nombre d'articles \nvendus dont la quantité \ndépasse 500",null,null,"Total des ventes \npar article",null,null,"Total des quantités \npar date"]
["Date","Vendeur","Article","Q","PU","Total",{"$nulls":4},"Article","Total",null,"Dates","Total"]
["2001-10-03","Martin","écrous",1534,0.25,{"$f":"D3*E3","v":383.5},{"$nulls":4},"clous",null,null,"2001-10-03"]
["2001-10-03","Dupont","clous",1987,0.25,496.75,{"$nulls":4},"écrous",null,null,"2001-10-08"]
["2001-10-03","Martin","écrous",2054,0.25,513.5,{"$nulls":4},"pieux",null,null,"2001-10-14"]
["2001-10-08","Lambert","pieux",654,0.35,228.89999999999998,{"$nulls":7},"2001-10-23"]
["2001-10-08","Martin","écrous",951,0.25,237.75,null,"Nombre d'articles \nvendus dont le prix est \ninférieur à 0,30€",{"$nulls":5},"2001-10-27"]
["2001-10-08","Martin","écrous",1002,0.25,250.5]
["2001-10-14","Lambert","pieux",396,0.35,138.6]
["2001-10-14","Dupont","clous",542,0.35,189.7]
["2001-10-14","Lambert","pieux",547,0.35,191.45]
["2001-10-23","Martin","clous",187,3.72,695.64,{"$nulls":4},"Moyenne des ventes \npar article",null,null,"Moyenne des quantités\npar vendeur"]
["2001-10-23","Dupont","clous",322,0.35,112.69999999999999]
["2001-10-23","Lambert","clous",322,3.72,1197.8400000000001,null,"Nombre d'articles vendus \nà partir du 15 octobre 2001",null,null,"Article","Moyenne",null,"Vendeur","Moyenne"]
["2001-10-27","Dupont","pieux",123,3.72,457.56,{"$nulls":4},"clous",null,null,"Martin"]
["2001-10-27","Lambert","écrous",134,3.72,498.48,{"$nulls":4},"écrous",null,null,"Dupont"]
["2001-10-27","Dupont","pieux",145,3.72,539.4,{"$nulls":4},"pieux",null,null,"Lambert"]

{"sheet":"La fonction Si","index":1,"n_rows":43,"n_cols":5,"rows_kept":43,"cut":false,"hidden":false,"merged":[[7,0,7,1],[8,0,8,6],[9,0,9,6],[22,0,22,8],[42,0,42,8]]}
["Exemple 1"]
["Prévisions","Résultats","Objectifs 1","Objectifs 2"]
[1500,1531]
[2000,2984]
[2500,2499]
[3000,3000]
[]
["Afficher ATTEINT ou MANQUE"]
["Objectif 1 - Si les résultats dépassent les prévisions l'objectif sera atteint sinon il sera manqué"]
["Objectif 2 - Si les résultats sont au moins équivalents aux prévisions l'objectif sera atteint sinon il sera manqué"]
[]
["Exemple 2"]
["NOMS","NOMBRE D'ENFANTS","PRIME"]
["JENNIFER",5]
["JONATHAN",1]
["BONNIE",2]
["CLYDE",1]
["LOIS",5]
["CLARK",3]
["BERNADETT",2]
["JACQUES",2]
[]
["Calculer une prime de 50€ par enfant si le nombre d'enfants est inférieur à 3 et une prime de 70€ par enfant pour les autres"]
[]
["Exemple 3"]
["Article","Quantité Achetée","Quantité Vendue","Quantité Restante","A commander"]
["Mars",40,22,{"$f":"B27-C27","v":18}]
["Léo",50,21,{"$f":"B28-C28","v":29}]
["Twix",25,12,13]
["Cha-cha",35,28,7]
["Kinder",70,38,32]
["Snickers",100,47,53]
["Bounty",55,25,30]
["Lion",20,2,18]
["Krups",80,38,42]
["Smarties",60,33,27]
["Coca",100,62,38]
["Fanta",100,49,51]
["Sprite",100,42,58]
["Ice tea",100,50,50]
["Cécémel",100,33,67]
[]
["Si la Quantité Restante est inférieure ou égale à la moitié de la Quantité Achetée, il faut indiquer OUI sinon la cellule reste vide"]

{"sheet":"Si Imbriqués 1","index":2,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":false,"merged":[[18,1,18,8],[19,1,19,8]]}
[]
[null,"Nom","Prénom","Excel/20","Word/20","Powerpoint/20","Pourcentage","Conclusion 1"]
[null,"Laure","AMBART",8,17,19,{"$f":"SUM(D3:F3)/60","v":0.73333333333333328}]
[null,"Larry","BAMBELLE",0,16,4,{"$f":"SUM(D4:F4)/60","v":0.33333333333333331}]
[null,"Agathe","DEBLOUSE",9,9,11,0.48333333333333334]
[null,"Sarah","FRÉCHIS",8,12,14,0.56666666666666665]
[null,"Sam","GRATH",12,8,10,0.5]
[null,"Jacques","HOUZI",19,7,12,0.6333333333333333]
[null,"Guy","LIGUILI",6,12,5,0.38333333333333336]
[null,"Justine","MISOPOUIN",0,14,15,0.48333333333333334]
[null,"Alain","PROVIST",11,11,11,0.55000000000000004]
[null,"Jean","TAMBIEN",14,13,13,0.66666666666666663]
[null,"Maguy","TARE",17,15,6,0.6333333333333333]
[null,"Lara","TATOUILLE",18,18,13,0.81666666666666665]
[null,"Klaus","TOUMI",11,16,15,0.7]
[null,"Sarah","VIGOTE",15,11,12,0.6333333333333333]
[null,"Sacha","VIRE",19,18,14,0.85]
[]
[null,"Calculer le pourcentage de chaque élève et afficher la conclusion correspondant à ses résultats"]
[null,"CCL 1 :Si l'élève à moins de 50 % Echec, s'il a entre 50 et 75 % Bon Travail, s'il a plus de 75% Réussite"]

{"sheet":"Si Imbriqués 2","index":3,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[10,7,10,11],[11,7,11,11],[12,7,12,11],[13,7,13,11],[10,0,10,3],[11,0,11,3],[12,0,12,3],[13,0,13,3]]}
["Nom","Montant \nhors taxe","Taux de remise","Montant valeur","Montant final",null,null,"Nom","Montant \nhors taxe","Taux de remise"]
["CHRISJAN",10759,{"$nulls":5},"CHRISJAN",10759]
["VISIRIE",23299,{"$nulls":5},"VISIRIE",23299]
["GUENOLA",9664,{"$nulls":5},"GUENOLA",9664]
["CASIQUE",9879,{"$nulls":5},"CASIQUE",9879]
["GENODI",26000,{"$nulls":5},"GENODI",18034]
["AGMIR",14058,{"$nulls":5},"AGMIR",14058]
["FERZIT",8985,{"$nulls":5},"FERZIT",8985]
["VALEZI",12294,{"$nulls":5},"VALEZI",12294]
[]
["Pas de remise en-dessous de 10000 €",{"$nulls":6},"Pas de remise en-dessous de 10000 €"]
["Le taux de remise est de 7,5% à partir de 10000 €",{"$nulls":6},"Le taux de remise est de 7,5% en dessous de 15000 €"]
["Le taux de remise est de 12,5% à partir de 15000 €",{"$nulls":6},"Le taux de remise est de 12,5% en dessous de 25000 €"]
["Le taux de remise est de 15% à partir de 25000 €",{"$nulls":6},"Le taux de remise est de 15% à partir de 25000 €"]