{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Preambule"," Formules + mise en forme","Créer un modèle","Taux_TVA"],"not_rendered":{"defined_names":17},"read":"whole","date_system":"1900"}

{"sheet":"Preambule","index":0,"n_rows":9,"n_cols":9,"rows_kept":9}
[]
[null,"Achat de matériel informatique service de pédiatrie",{"$nulls":6},"Saisie texte"]
[{"$nulls":8},"Saisie nombre"]
[null,"Matériel","Nombre","Prix unitaire","Prix HT","TVA","TTC",null,"Saisie formule"]
[null,"Ordinateur portable",3,500,{"$f":"D5*C5","v":{"v":1500,"d":"1500.00"}},{"$f":"E5*0.2","v":{"v":300,"d":"300.00"}},{"$f":"E5+F5","v":{"v":1800,"d":"1800.00"}}]
[null,"Souris",5,21,{"$f":"D6*C6","v":{"v":105,"d":"105.00"}},{"$f":"D6*0.2","v":{"v":4.2,"d":"4.20"}},{"$f":"E6+F6","v":{"v":109.2,"d":"109.20"}}]
[null,"Imprimante laser",2,219,{"v":438,"d":"438.00"},{"v":43.800000000000004,"d":"43.80"},{"v":481.8,"d":"481.80"}]
[]
[{"$nulls":5},"A payer",{"$f":"SUM(G5:G7)","v":{"v":2391,"d":"2391.00"}}]

{"sheet":" Formules + mise en forme","index":1,"n_rows":15,"n_cols":9,"rows_kept":15}
[]
[null,"Achat de matériel informatique service de pédiatrie",{"$nulls":6},"Taper la formule"]
[{"$nulls":8},"E5 : = E5*C5"]
[null,"Matériel","Nombre","Prix Unitaire","Prix HT","TVA","TTC"]
[null,"Ordinateur portable",3,500,{"$nulls":4},"TVA à 20%"]
[null,"Souris",5,21,{"$nulls":4},"C'est le prix HT multiplié par la TVA"]
[null,"Imprimante laser",1,219]
[{"$nulls":8},"TTC : c'est la PRIX HT + TVA"]
[{"$nulls":5},"A payer"]
[null,"Saisie texte",{"$nulls":6},"A payer : les 3 cellules TTC"]
[null,"Saisie nombre"]
[null,"Saisie formules",{"$nulls":6},"Appliquer les styles"]
[{"$nulls":8},"Sélectionner les cellules"]
[{"$nulls":8},"Cliquer Styles de cellules"]
[{"$nulls":8},"Cliquer sur les styles personnalisés"]

{"sheet":"Créer un modèle","index":2,"n_rows":14,"n_cols":9,"rows_kept":14,"merged":[[5,8,7,8],[8,2,8,3],[9,2,9,3]]}
[]
[null,"Achat…"]
[]
[null,"Matériel","Nombre","Prix Unitaire","Prix HT","TVA","TTC",null,"Mot de passe de la feuille : \"anfh\""]
[{"$nulls":4},{"$f":"Nombre*Prix_Unitaire","v":{"v":0,"d":"0.00"}},{"$f":"PRIX_HT*Taux_TVA","v":{"v":0,"d":"0.00"}},{"$f":"PRIX_HT+TVA","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},{"$f":"Nombre*Prix_Unitaire","v":{"v":0,"d":"0.00"}},{"$f":"PRIX_HT*Taux_TVA","v":{"v":0,"d":"0.00"}},{"$f":"PRIX_HT+TVA","v":{"v":0,"d":"0.00"}},null,"Pour réaliser le modèle, il faut supprimer les contenus inutiles, protéger les cellules de calcul (verrouillées)."]
[{"$nulls":4},{"$f":"Nombre*Prix_Unitaire","v":{"v":0,"d":"0.00"}},{"$f":"PRIX_HT*Taux_TVA","v":{"v":0,"d":"0.00"}},{"$f":"PRIX_HT+TVA","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},{"$f":"Nombre*Prix_Unitaire","v":{"v":0,"d":"0.00"}},{"$f":"PRIX_HT*Taux_TVA","v":{"v":0,"d":"0.00"}},{"$f":"PRIX_HT+TVA","v":{"v":0,"d":"0.00"}}]
[{"$nulls":8},"Enregistrer le document au format XLTX (modèle de document)."]
[{"$nulls":5},"A payer",{"$f":"SUM(TTC)","v":{"v":0,"d":"0.00"}},null,"Lorsque que l'on utilise le modèle, un document nouveau est affiché à l'écran basé sur le modèle."]
[]
[{"$nulls":5},{"$f":"IF(Remise=\"\",\"\",\"Remise\")","v":""},{"$f":"IF(A_payer>2000,A_payer*0.1,\"\")","v":""}]
[]
[{"$nulls":5},"Total à payer",{"$f":"IF(Remise=\"\",A_payer,A_payer-Remise)","v":{"v":0,"d":"0.00"}}]

{"sheet":"Taux_TVA","index":3,"n_rows":3,"n_cols":2,"rows_kept":3}
[]
[null,"Taux TVA"]
[null,0.2]