{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Tarifs","Majoration de prix ","ClientsPart","ClientsPro","Devis","DevisValidé","DevisValidé(non accepté)","Facturation","FactureValidée","Etude CAHT"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":3,"defined_names":31,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Tarifs","index":0,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
[]
["modèles","tarif de base ","les 100 supplémentaires"]
[null,"(pour les 100 premères cartes)"]
["1/2 format (9,9*21cm)",29,25]
["américain (9,3*21cm)",25,21]
["carte bleue (5,4*8,6cm)",27,23]
["correspondance (8,2*12,8cm)",23,19]
[]
["Acceptation du devis"]
["Accepté"]
["Non accepté"]

{"sheet":"Majoration de prix ","index":1,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
[]
["référence article","nom","coefficient multiplicateur"]
["BLM","blanc mat",1]
["BLG","blanc glacé",1.1000000000000001]
["COR","couleur",1.5]
[]
[]
[]
["Taux de T.V.A","Remise","Escompte"]
[5.5E-2,0.01,0.01]
[0.2,0.02,0.02]
[null,0.03,0.03]
[null,0.04,0.04]
[null,0.05,0.05]

{"sheet":"ClientsPart","index":2,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
[]
[null,"NOM PRENOM","ADRESSE","COMPLEMENT D'ADRESSE","VILLE ET CP"]
[null,"ASUAR Hugo","Le Charet","BP 5","26100 Romans-Sur-Isère"]
[null,"BERRUYER Maxime","Rue de Gaule",26,"26200 Valence"]
[null,"BILLOTET Paul","Camargue","14 rue jauret","13100 Aix-En-Provence"]
[null,"CARAT Tiphanie","Avenue du pain","BP 12","13000 Marseille"]
[null,"DE MARIO Rosé","Port vieux","12 rue du chevalier","84000 Avignon"]
[null,"DUPUIS Mathilde","Avenue Jacques Mart",13,"84100 Avignon"]
[null,"GARCIA Loic","Charolay","BP 3","13100 Aix-En-Provence"]
[null,"GUILLERET Charles","Grand Lieu","12 rue du cordelier","26100 Romans"]
[null,"HAUGUEL Caroline","Prieuré","16 rue du marathon","30900 Nimes"]
[null,"LAGIEUX Jean","L' Etang","29 rue des belges","04100 Mnosque"]
[null,"LEJEAN Pierre","Avenue du Marché","BP 22","83200 Toulon"]
[null,"LEROY Marine","La Chatelet","BP 7","34070 Montpellier"]
[null,"MAZET Laurent","Avenue de la fraternité",15,"34080 Montpellier"]
[null,"MORINEAU Celine","La Grande Place","26 rue Clovis","06400 Cannes"]
[null,"PERRET Yann","La Planque","12 rue Jean","34200 Sète"]
[null,"POULIN Joseph","Avenue de la republique","BP 42","84000 Avignon"]
[null,"ROBERT Luc","Avenue du Tiers","BP 23","06400 Cannes"]
[null,"TEVENAT Célia","Avenue de la France","BP 20","30900 Nimes"]
[null,"ZIVA Shanone","Avenue des militants","BP 42","34200 Sète"]

{"sheet":"ClientsPro","index":3,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
[]
[null,"RAISON SOCIALE","ADRESSE","COMPLEMENT D'ADRESSE","VILLET ET CP","TELEPHONE","MODE DE PAIEMENT","N° d'identification intracom "]
[null,"ARTEIS","Le Colombier ","BP 15","13100 Aix-En-Provence","04-75-85-95-52","Règlement: virement 30 jours fin de mois","FR1986592-952"]
[null,"CHEZ CHLOE","ZI de plan","Avenue du Mandailles","84000 Avignon","07-78-85-12-21","Règlement: Chèque 30 jours fin de mois","FR1986592-953"]
[null,"DREAM CARD","Avenue Jean Jaures","BP 3","13000 Marseille","07-64-64-52-53","Règlement: Traite 30 jours fin de mois","FR1986592-954"]
[null,"FASHION CARD","La Grande Route","BP 8","13000 Marseille","07-15-21-32-56","Règlement: Chèque 30 jours fin de mois","FR1986592-955"]
[null,"LA MODE","Route de romans","16 rue de La Monnaie ","26100 Romans-Sur-Isère","04-65-92-34-03","Règlement: virement 30 jours fin de mois","FR1986592-957"]
[null,"L'OPTIQUE MARKET","Avenue du Camps","BP 62","06400 Cannes","04-65-82-32-10","Règlement: virement 30 jours fin de mois","FR1986592-958"]
[null,"MAGIC FEET","Avenue des Fleurs","BP 13","83200 Toulon","04-75-96-32-45","Règlement: Chèque 30 jours fin de mois","FR1986592-959"]
[null,"NETWORK NET","L' Auberge","15 rue des Belges","30900 Nimes","04-83-95-95-63","Règlement: Chèque 30 jours fin de mois","FR1986592-960"]
[null,"RONGEAT","Le Fleuve Vert","35 rue du Fils","34070 Montpellier","04-96-94-26-31","Règlement: Traite 30 jours fin de mois","FR1986592-961"]
[null,"TRAVEL VOYAGE","Templier","14 rue du colonel Delaye","26200 Valence","04-05-32-45-89","Règlement: virement 30 jours fin de mois","FR1986592-956"]

{"sheet":"Devis","index":4,"n_rows":38,"n_cols":9,"rows_kept":38,"cut":false,"hidden":false,"merged":[[5,15,7,15]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(G5,TableClientsPro,2,0),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(G5,TableClientsPro,3,0),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(G5,TableClientsPro,4,0),\"\")","v":""}]
[]
[]
[null,null,null,null,null,"N°",{"$f":"\"DEV\"&\"-\"&UPPER(LEFT(G5,3))&\"-\"&DAY(I9)&\"-\"&MONTH(I9)&\"-\"&YEAR(I9)&\"-\"&TEXT(MAX(DevisValidé!A:A)+1,\"000\")","v":"DEV--0-1-1900-018"}]
[]
[]
[null,null,null,"format de la carte","référence papier","nombre de lignes","quantité","Prix Unitaire","total H.T"]
[null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I15/ROUNDUP(G15/100,0)),\"\",(I15/ROUNDUP(G15/100,0)))","v":""},{"$f":"IF(ISERROR((((F15-3)*4.5+(IF(ISERROR(VLOOKUP(D15,Tarifs,2,0)),\"\",VLOOKUP(D15,Tarifs,2,0))))+(((F15-3)*4.5+(VLOOKUP(D15,Tarifs,3,0)))*((ROUNDUP(G15/100,0))-1)))*(VLOOKUP(E15,MajDesPrix,3,0))),\"\",(((F15-3)*4.5+(IF(ISERROR(VLOOKUP(D15,Tarifs,2,0)),\"\",VLOOKUP(D15,Tarifs,2,0))))+(((F15-3)*4.5+(VLOOKUP(D15,Tarifs,3,0)))*((ROUNDUP(G15/100,0))-1)))*(VLOOKUP(E15,MajDesPrix,3,0)))","v":""}]
[null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,"Montant HT",{"$f":"(SUM(I15:I25))","v":0}]
[null,null,null,null,null,null,"Remise",null,{"$f":"I26*H27","v":0}]
[null,null,null,null,null,null,null,"Net Commercial",{"$f":"I26-I27","v":0}]
[null,null,null,null,null,null,"Escompte",null,{"$f":"I28*H29","v":0}]
[null,null,null,null,null,null,null,"Net Financier",{"$f":"I28-I29","v":0}]
[null,null,"Mode de paiement:",{"$f":"IFERROR((VLOOKUP(G5,TableClientsPro,6,0)),\"\")","v":""},null,null,"T.V.A",0.2,{"$f":"I30*H31","v":0}]
[null,null,"Num intracom :",{"$f":"IFERROR(VLOOKUP(G5,TableClientsPro,7,0),\"\")","v":""},null,null,null,"T.T.C",{"$f":"I30+I31","v":0}]
[]
[]
[null,null,null,"Bon pour accord."]
[null,null,null,"Signature du client"]
[]
[null,null,"Etat du devis:"]

{"sheet":"DevisValidé","index":5,"n_rows":196,"n_cols":16,"rows_kept":196,"cut":false,"hidden":false,"merged":[]}
["Numéro","Numéro Devis","Date","Clients","Format carte","Référence papier","Nombre de lignes","Quantité","Montant H.T","Remise","Net Commercial","Escompte","Net Financier","T.V.A","T.T.C","Etat Devis"]
[]
[{"$f":"VALUE(RIGHT(B3,3))","v":17},"DEV-FAS-23-10-2016-017","2016-10-23","FASHION CARD","1/2 format (9,9*21cm)","COR",150,100,3089.25,61.785000000000004,3027.4650000000001,121.0986,2906.3664000000003,581.27328000000011,3487.6396800000002,"Accepté"]
[null,null,null,null,"américain (9,3*21cm)","COR",150,150]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"VALUE(RIGHT(B15,3))","v":16},"DEV-FAS-28-2-2013-016","2013-02-28","FASHION CARD","carte bleue (5,4*8,6cm)","BLG",10,150,124.30000000000001,0,124.30000000000001,0,124.30000000000001,24.362800000000004,148.6628,"Accepté"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"VALUE(RIGHT(B27,3))","v":15},"DEV-RON-28-2-2013-015","2013-02-28","RONGEAT","américain (9,3*21cm)","BLM",25,100,205.75,0,205.75,0,205.75,40.326999999999998,246.077,"Accepté"]
[null,null,null,null,"correspondance (8,2*12,8cm)","COR",10,75]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"VALUE(RIGHT(B39,3))","v":14},"DEV-TRA-27-2-2013-014","2013-02-27","TRAVEL VOYAGE","américain (9,3*21cm)","BLM",15,100,303.2,0,303.2,0,303.2,59.427199999999999,362.62720000000002,"Accepté"]
[null,null,null,null,"correspondance (8,2*12,8cm)","BLG",5,100]
[null,null,null,null,"carte bleue (5,4*8,6cm)","COR",25,25]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"VALUE(RIGHT(B51,3))","v":13},"DEV-ART-26-2-2013-013","2013-02-26","ARTEIS","1/2 format (9,9*21cm)","BLG",15,150,447.85,0,447.85,0,447.85,87.778600000000012,535.62860000000001,"Accepté"]
[null,null,null,null,"carte bleue (5,4*8,6cm)","COR",10,50]
[null,null,null,null,"correspondance (8,2*12,8cm)","BLM",10,50]
[null,null,null,null,"américain (9,3*21cm)","BLG",5,150]
[null,null,null,null,"1/2 format (9,9*21cm)","COR",5,100]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"VALUE(RIGHT(B63,3))","v":12},"DEV-DRE-23-2-2013-012","2013-02-23","DREAM CARD","carte bleue (5,4*8,6cm)","BLG",15,100,246.10000000000002,0,246.10000000000002,0,246.10000000000002,48.235600000000005,294.3356,"Accepté"]
[null,null,null,null,"correspondance (8,2*12,8cm)","COR",5,25]
[null,null,null,null,"américain (9,3*21cm)","BLM",10,150]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"VALUE(RIGHT(B75,3))","v":11},"DEV-NET-22-2-2013-011","2013-02-22","NETWORK NET","carte bleue (5,4*8,6cm)","BLM",15,50,268.45,0,268.45,0,268.45,52.616199999999999,321.06619999999998,"Accepté"]
[null,null,null,null,"correspondance (8,2*12,8cm)","BLG",5,100]
[null,null,null,null,"américain (9,3*21cm)","COR",20,25]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"VALUE(RIGHT(B87,3))","v":10},"DEV-MAG-20-2-2013-010","2013-02-20","MAGIC FEET","1/2 format (9,9*21cm)","BLM",15,100,134,0,134,0,134,26.263999999999999,160.26400000000001,"Accepté"]
[null,null,null,null,"américain (9,3*21cm)","COR",5,25]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"VALUE(RIGHT(B99,3))","v":9},"DEV-ART-18-2-2013-009","2013-02-18","ARTEIS","1/2 format (9,9*21cm)","BLG",15,15,299.05,0,299.05,0,299.05,58.613800000000005,357.66380000000004,"Accepté"]
[null,null,null,null,"carte bleue (5,4*8,6cm)","BLM",10,50]
[null,null,null,null,"correspondance (8,2*12,8cm)","COR",20,25]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"VALUE(RIGHT(B111,3))","v":8},"DEV-DRE-16-2-2013-008","2013-02-16","DREAM CARD","américain (9,3*21cm)","BLM",15,25,300.2,0,300.2,0,300.2,58.839199999999998,359.03919999999999,"Accepté"]
[null,null,null,null,"correspondance (8,2*12,8cm)","BLG",5,100]
[null,null,null,null,"américain (9,3*21cm)","COR",25,10]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"VALUE(RIGHT(B123,3))","v":7},"DEV-LA -15-2-2013-007","2013-02-15","LA MODE","1/2 format (9,9*21cm)","BLG",15,50,459.8,0,459.8,0,459.8,90.120800000000003,549.92079999999999,"Accepté"]
[null,null,null,null,"correspondance (8,2*12,8cm)","COR",25,10]
[null,null,null,null,"américain (9,3*21cm)","BLM",5,150]
[null,null,null,null,"carte bleue (5,4*8,6cm)","COR",15,25]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"VALUE(RIGHT(B135,3))","v":6},"DEV-ART-13-2-2013-006","2013-02-13","ARTEIS","américain (9,3*21cm)","BLM",15,50,361.55,0,361.55,0,361.55,70.863800000000012,432.41380000000004,"Accepté"]
[null,null,null,null,"correspondance (8,2*12,8cm)","BLG",15,50]
[null,null,null,null,"1/2 format (9,9*21cm)","COR",20,50]
[null,null,null,null,"carte bleue (5,4*8,6cm)","BLG",5,25]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"VALUE(RIGHT(B147,3))","v":5},"DEV-CHE-11-2-2013-005","2013-02-11","CHEZ CHLOE","carte bleue (5,4*8,6cm)","BLM",10,50,224.05,0,224.05,0,224.05,43.913800000000002,267.96379999999999,"Accepté"]
[null,null,null,null,"1/2 format (9,9*21cm)","BLG",10,50]
[null,null,null,null,"correspondance (8,2*12,8cm)","COR",5,100]
[null,null,null,null,"américain (9,3*21cm)","COR",5,100]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"VALUE(RIGHT(B159,3))","v":4},"DEV-DRE-9-2-2013-004","2013-02-09","DREAM CARD","correspondance (8,2*12,8cm)","BLM",5,50,176.25,0,176.25,0,176.25,34.545000000000002,210.79500000000002,"Accepté"]
[null,null,null,null,"américain (9,3*21cm)","BLM",10,25]
[null,null,null,null,"carte bleue (5,4*8,6cm)","COR",10,25]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"VALUE(RIGHT(B171,3))","v":3},"DEV-LA -7-2-2013-003","2013-02-07","LA MODE","carte bleue (5,4*8,6cm)","BLG",15,150,465.95000000000005,0,465.95000000000005,0,465.95000000000005,91.326200000000014,557.27620000000002,"Accepté"]
[null,null,null,null,"américain (9,3*21cm)","BLG",15,200]
[null,null,null,null,"1/2 format (9,9*21cm)","COR",10,100]
[null,null,null,null,"correspondance (8,2*12,8cm)","BLM",5,50]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"VALUE(RIGHT(B183,3))","v":2},"DEV-ART-5-2-2013-002","2013-02-05","ARTEIS","carte bleue (5,4*8,6cm)","BLG",5,150,602.79999999999995,0,602.79999999999995,0,602.79999999999995,118.14879999999999,720.94879999999989,"Accepté"]
[null,null,null,null,"correspondance (8,2*12,8cm)","BLM",15,125]
[null,null,null,null,"1/2 format (9,9*21cm)","COR",25,120]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"VALUE(RIGHT(B195,3))","v":1},"DEV-L'O-1-2-2013-001","2013-02-01","L'OPTIQUE MARKET","1/2 format (9,9*21cm)","BLM",15,100,245,0,245,0,245,48.02,293.02,"Accepté"]
[null,null,null,null,"1/2 format (9,9*21cm)","BLM",15,200]

{"sheet":"DevisValidé(non accepté)","index":6,"n_rows":1,"n_cols":14,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Date","Clients","Format carte","Référence papier","Nombre de lignes","Quantité","Montant H.T","Remise","Net Commercial","Escompte","Net Financier","T.V.A","T.T.C","Etat Devis"]

{"sheet":"Facturation","index":7,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":false,"merged":[[8,1,18,12],[19,1,19,12],[2,1,4,7]]}
[]
[]
[null,"Si tu veux voir une vidéo de cette situation professionnelle complète sur you tube clique"]
[null,null,null,null,null,null,null,null,"ICI"]
[]
[]
[]
[]
[null,"La partie découverte s'arrête ici. Si tu veux allez plus loin tu peux télécharger 3 situations professionnelles E5 (avec les 3 fiches correspondantes + des fiches résumées du cours utilisé pour chaque situation) + une vidéo présentation orale en situation d'examen sur chaque situations professionnelles + des tuto sur Excel"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"CLIQUER ICI POUR OBTENIR LES 3 SITUATIONS PROFESSIONNELLES E5"]

{"sheet":"FactureValidée","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Etude CAHT","index":9,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}