{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["réf","entrees pcs","bdd entrées","bdd e","e tcd pcs","synthèse"],"not_rendered":{"charts":2,"images":2,"macros":1,"external_links":3,"defined_names":6,"pivot_tables":1},"read":"whole","date_system":"1900"}

{"sheet":"réf","index":0,"n_rows":8,"n_cols":6,"rows_kept":8}
["Produits ","qté pcs par produit:",null,"Produits ","Notif 2015 Entrées pcs","Réel 2014 Entrées pcs"]
["maison",2,null,"maison",6591.915,6558]
["voiture",4,null,"voiture",20067.648,18824]
["jardin ",3,null,"jardin ",5203.268,3722]
["roue",1,null,"roue",19562.00400000001,17546]
["bracelet",5,null,"bracelet",9646.32,8635]
[{"$nulls":3},"crayons",11912.813999999993,11957]
[{"$nulls":3},"livre",1950,1825]

{"sheet":"entrees pcs","index":1,"n_rows":18,"n_cols":22,"rows_kept":18}
[]
[null,"Produits","Réel 2014","Notif 2015","Notif 2015 Cumul","janv","Février\nS06 à S09","Mars \nS10 à S13","Avril \nS14 à S18","Mai\n S19 à S22","Juin\n S23 à S26","Juillet\n S27 à S31","Aout\n S32 à S35","Septembre\n S36 à S39","Octobre\n S40 à S44","Novembre\n S45 à S48","Décembre \nS49 à S52","Réel 2015 Cumul","Ecart réel vs CG","Colonne2"]
[null,"maison",345,456,{"$f":"D3/52*$C$13","v":{"v":412.1538461538462,"d":"412"}},null,12,null,{"v":27.3214285714286,"d":"27"},null,{"v":39.9642857142857,"d":"40"},null,{"v":52.6071428571429,"d":"53"},{"$nulls":3},{"$f":"VLOOKUP($B3,'[1]BDD entrées'!$B$15:$N$22,13,FALSE)","v":0},{"$f":"SUM(F3:Q3)","v":{"v":131.8928571428572,"d":"132"}},{"$f":"R3-E3","v":{"v":-280.26098901098896,"d":"-280"}},{"$f":"S3/E3","v":{"v":-0.6799912014077746,"d":"-68%"}}]
[null,"voiture",456,457,{"v":413.0576923076923,"d":"413"},null,14,null,{"v":29.4285714285714,"d":"29"},null,{"v":42.0714285714286,"d":"42"},null,null,{"v":54.7142857142857,"d":"55"},null,null,{"$f":"VLOOKUP($B4,'[1]BDD entrées'!$B$15:$N$22,13,FALSE)","v":0},{"$f":"SUM(F4:Q4)","v":{"v":140.2142857142857,"d":"140"}},{"$f":"R4-E4","v":{"v":-272.8434065934066,"d":"-273"}},{"$f":"S4/E4","v":{"v":-0.6605455162184991,"d":"-66%"}},null,{"$f":"IF(SUM(F10:Q10)=R10,\"OK\",\"Faux\")","v":"OK"}]
[null,"jardin ",123,234,{"v":211.5,"d":"212"},3,null,{"v":23.1071428571429,"d":"23"},null,{"v":35.75,"d":"36"},null,{"v":48.3928571428571,"d":"48"},null,null,{"v":61.0357142857143,"d":"61"},null,{"$f":"VLOOKUP($B5,'[1]BDD entrées'!$B$15:$N$22,13,FALSE)","v":0},{"v":171.2857142857143,"d":"171"},{"v":-40.214285714285694,"d":"-40"},{"v":-0.1901384667342113,"d":"-19%"},null,{"$f":"IF(#REF!=R16,\"OK\",\"Faux\")","v":{"$error":"#REF!"}}]
[null,"roue",321,356,{"v":321.7692307692308,"d":"322"},null,15,null,{"v":31.5357142857143,"d":"32"},null,null,{"v":44.1785714285714,"d":"44"},null,null,{"v":56.8214285714286,"d":"57"},null,{"$f":"VLOOKUP($B6,'[1]BDD entrées'!$B$15:$N$22,13,FALSE)","v":0},{"v":147.53571428571428,"d":"148"},{"v":-174.2335164835165,"d":"-174"},{"v":-0.54148594651822,"d":"-54%"},null,"Vérifier moyenne"]
[null,"bracelet",543,567,{"v":512.4807692307692,"d":"512"},1,{"$nulls":10},{"$f":"VLOOKUP($B7,'[1]BDD entrées'!$B$15:$N$22,13,FALSE)","v":0},1,{"$f":"R7-E7","v":{"v":-511.48076923076917,"d":"-511"}},{"v":-0.9980487072685654,"d":"-100%"}]
[null,"crayons",678,680,{"v":614.6153846153846,"d":"615"},45,null,null,{"v":25.2142857142857,"d":"25"},{"v":37.8571428571429,"d":"38"},null,null,{"v":50.5,"d":"51"},null,null,{"v":63.1428571428571,"d":"63"},{"$f":"VLOOKUP($B8,'[1]BDD entrées'!$B$15:$N$22,13,FALSE)","v":0},{"v":221.7142857142857,"d":"222"},{"v":-392.901098901099,"d":"-393"},{"v":-0.6392633649204363,"d":"-64%"}]
[null,"livre",500,500,{"v":451.9230769230769,"d":"452"},2,null,17,{"v":33.6428571428571,"d":"34"},null,null,{"v":46.2857142857143,"d":"46"},null,null,{"v":58.9285714285714,"d":"59"},null,{"$f":"VLOOKUP($B9,'[1]BDD entrées'!$B$15:$N$22,13,FALSE)","v":0},{"v":157.8571428571428,"d":"158"},{"v":-294.06593406593413,"d":"-294"},{"v":-0.6506990881458968,"d":"-65%"}]
[null,"Total 1",{"$f":"SUM(C3:C9)","v":{"v":2966,"d":"2,966"}},{"v":3250,"d":"3,250"},{"v":2937.5,"d":"2,938"},51,41,{"v":40.107142857142904,"d":"40"},{"v":147.1428571428571,"d":"147"},{"v":73.60714285714289,"d":"74"},{"v":82.0357142857143,"d":"82"},{"v":138.8571428571428,"d":"139"},{"v":103.10714285714289,"d":"103"},{"v":54.7142857142857,"d":"55"},{"v":176.78571428571428,"d":"177"},{"v":63.1428571428571,"d":"63"},0,{"$f":"SUM(F10:Q10)","v":{"v":971.5,"d":"972"}},{"$f":"R10-E10","v":{"v":-1966,"d":"-1,966"}},{"v":-0.6692765957446809,"d":"-67%"}]
[]
[]
[null,"NB semaine",{"$f":"D13-1","v":47},48]
[null,null,"Attention -1 non prise en compte de la semaine 1"]
[{"$nulls":3},"Moy \n2014","Moy\n 2015","janv","févr.","mars","avr.","mai","juin","juil.","août","sept.","oct.","nov.","déc.","Cumul"]
[null,"Réel 2015",null,{"$f":"C10/12","v":{"v":247.16666666666666,"d":"247"}},{"$f":"AVERAGE(F16:P16)","v":{"v":88.31818181818181,"d":"88"}},{"$f":"F10","v":51},{"$f":"G10","v":41},{"v":40.107142857142904,"d":"40"},{"v":147.1428571428571,"d":"147"},{"v":73.60714285714289,"d":"74"},{"v":82.0357142857143,"d":"82"},{"v":138.8571428571428,"d":"139"},{"v":103.10714285714289,"d":"103"},{"v":54.7142857142857,"d":"55"},{"v":176.78571428571428,"d":"177"},{"v":63.1428571428571,"d":"63"},0,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Notif 2015",{"$nulls":3},{"$f":"$D$10/12","v":{"v":270.8333333333333,"d":"271"}},{"$f":"$D$10/12","v":{"v":270.8333333333333,"d":"271"}},{"v":270.8333333333333,"d":"271"},{"v":270.8333333333333,"d":"271"},{"v":270.8333333333333,"d":"271"},{"v":270.8333333333333,"d":"271"},{"v":270.8333333333333,"d":"271"},{"v":270.8333333333333,"d":"271"},{"v":270.8333333333333,"d":"271"},{"v":270.8333333333333,"d":"271"},{"v":270.8333333333333,"d":"271"},{"v":270.8333333333333,"d":"271"}]
[null,"Réel 2014",null,0,0,200,300,156,253,345,324,287,189,301,298,123,234]

{"sheet":"bdd entrées","index":2,"n_rows":22,"n_cols":53,"rows_kept":22,"merged":[[12,1,13,1],[12,2,13,2],[12,3,13,3],[12,4,13,4],[12,5,13,5],[12,6,13,6],[12,7,13,7],[12,8,13,8],[12,9,13,9],[12,10,13,10],[12,11,13,11],[12,12,13,12]]}
[null,"S1","S2","S3","S4","S5","S6","S7","S8","S9","S10","S11","S12","S13","S14","S15","S16","S17","S18","S19","S20","S21","S22","S23","S24","S25","S26","S27","S28","S29","S30","S31","S32","S33","S34","S35","S36","S37","S38","S39","S40","S41","S42","S43","S44","S45","S46","S47","S48","S49","S50","S51","S52"]
["maison",0]
["voiture",0]
["jardin ",0]
["roue",0]
["bracelet",0]
["crayons",0]
["livre"]
["Total général",{"$f":"SUM(B2:B8)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AH2:AH8)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
[null,"Quantité S01 à S05","Quantité S06 à S09","Quantité S10 à S13","Quantité S14 à S18","Quantité S19 à S22","Quantité S23 à S26","Quantité S27 à S31","Quantité S32 à S35","Quantité S36 à S39","Quantité S40 à S44","Quantité S45 à S48","Quantité S49 à S52"]
[null,"Février",2,3,4,5,6,7,8,9,0,0,0]
[{"$f":"A2","v":"maison"},{"$f":"SUM(B2:F2)","v":0},{"$f":"SUM(G2:J2)","v":0},{"$f":"SUM(K2:N2)","v":0},{"$f":"SUM(O2:S2)","v":0},{"$f":"SUM(T2:W2)","v":0},{"$f":"SUM(X2:AA2)","v":0},{"$f":"SUM(AB2:AF2)","v":0},{"$f":"SUM(AG2:AJ2)","v":0},{"$f":"SUM(AK2:AN2)","v":0},{"$f":"SUM(AO2:AS2)","v":0},{"$f":"SUM(AT2:AW2)","v":0},{"$f":"SUM(AX2:BA2)","v":0}]
["voiture",0,0,0,0,0,0,0,0,0,0,0,0]
["jardin ",0,0,0,0,0,0,0,0,0,0,0,0]
["roue",0,0,0,0,0,0,0,0,0,0,0,0]
["bracelet",0,0,0,0,0,0,0,0,0,0,0,0]
["crayons",0,0,0,0,0,0,0,0,0,0,0,0]
["livre",0,0,0,0,0,0,0,0,0,0,0,0]
["Total général",{"$f":"SUM(B15:B21)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(K15:K21)","v":0},{"$f":"SUM(L15:L21)","v":0},{"$f":"SUM(M15:M21)","v":0}]

{"sheet":"bdd e","index":3,"n_rows":32,"n_cols":12,"rows_kept":32}
["Année","Mois","N° SEM reçue","date","Date reçue","N°PRODUIT","Client","produit ","Qty","CDE","S/T","F/G/H"]
["2015","2015-01-05",{"$f":"WEEKNUM(BDD_entrees_2015[[#This Row],[Date reçue]],1)","v":2},"2015-01-05","2015-01-05",null,"CLIENT 1","maison",{"v":1,"d":"1.0"},123,"OUI ","R"]
["2015","2015-01-05",{"$f":"WEEKNUM(BDD_entrees_2015[[#This Row],[Date reçue]],1)","v":2},"2015-01-05","2015-01-05",null,"CLIENT 2","voiture",{"v":2,"d":"2.0"},456,"NON","F"]
["2015","2015-01-05",{"$f":"WEEKNUM(BDD_entrees_2015[[#This Row],[Date reçue]],1)","v":2},"2015-01-05","2015-01-05",null,"CLIENT 3","jardin ",{"v":3,"d":"3.0"},789,"OUI "]
["2015","2015-01-05",{"$f":"WEEKNUM(BDD_entrees_2015[[#This Row],[Date reçue]],1)","v":2},"2015-01-05","2015-01-05",null,"CLIENT 4","roue",{"v":45,"d":"45.0"},1122,"NON","G"]
["2015","2015-02-03",{"$f":"WEEKNUM(BDD_entrees_2015[[#This Row],[Date reçue]],1)","v":6},"2015-02-03","2015-02-03",null,"CLIENT 5","bracelet",{"v":12,"d":"12.0"},1455,"OUI ","R"]
["2015","2015-02-15",{"$f":"WEEKNUM(BDD_entrees_2015[[#This Row],[Date reçue]],1)","v":8},"2015-02-15","2015-02-15",null,"CLIENT 6","crayons",{"v":14,"d":"14.0"},1788,"NON","G"]
["2015","2015-02-28",{"$f":"WEEKNUM(BDD_entrees_2015[[#This Row],[Date reçue]],1)","v":9},"2015-02-28","2015-02-28",null,"CLIENT 7","livre",{"v":15,"d":"15.0"},2121,"OUI "]
["2015","2015-03-03",{"$f":"WEEKNUM(BDD_entrees_2015[[#This Row],[Date reçue]],1)","v":10},"2015-03-03","2015-03-03",null,"CLIENT 1","voiture",{"v":17,"d":"17.0"},2454,"NON","H"]
["2015","2015-03-14",{"$f":"WEEKNUM(BDD_entrees_2015[[#This Row],[Date reçue]],1)","v":11},"2015-03-14","2015-03-14",null,"CLIENT 2","jardin ",{"v":23.1071428571429,"d":"23.1"},2787,"OUI ","R"]
["2015","2015-03-29",{"$f":"WEEKNUM(BDD_entrees_2015[[#This Row],[Date reçue]],1)","v":14},"2015-03-29","2015-03-29",null,"CLIENT 3","roue",{"v":25.2142857142857,"d":"25.2"},3120,"NON","F"]
["2015","2015-04-04",{"$f":"WEEKNUM(BDD_entrees_2015[[#This Row],[Date reçue]],1)","v":14},"2015-04-04","2015-04-04",null,"CLIENT 4","bracelet",{"v":27.3214285714286,"d":"27.3"},3453,"OUI "]
["2015","2015-04-05",{"$f":"WEEKNUM(BDD_entrees_2015[[#This Row],[Date reçue]],1)","v":15},"2015-04-05","2015-04-05",null,"CLIENT 5","crayons",{"v":29.4285714285714,"d":"29.4"},3786,"NON","G"]
["2015","2015-05-02",{"$f":"WEEKNUM(BDD_entrees_2015[[#This Row],[Date reçue]],1)","v":18},"2015-05-02","2015-05-02",null,"CLIENT 6","livre",{"v":31.5357142857143,"d":"31.5"},4119,"OUI ","R"]
["2015","2015-04-30",{"$f":"WEEKNUM(BDD_entrees_2015[[#This Row],[Date reçue]],1)","v":18},"2015-04-30","2015-04-30",null,"CLIENT 7","voiture",{"v":33.6428571428571,"d":"33.6"},4452,"NON","H"]
["2015","2015-05-10",{"$f":"WEEKNUM(BDD_entrees_2015[[#This Row],[Date reçue]],1)","v":20},"2015-05-10","2015-05-10",null,"CLIENT 15","jardin ",{"v":35.75,"d":"35.8"},4785,"OUI "]
["2015","2015-05-20",{"$f":"WEEKNUM(BDD_entrees_2015[[#This Row],[Date reçue]],1)","v":21},"2015-05-20","2015-05-20",null,"CLIENT 16","roue",{"v":37.8571428571429,"d":"37.9"},5118,"NON","F"]
["2015","2015-06-03",{"$f":"WEEKNUM(BDD_entrees_2015[[#This Row],[Date reçue]],1)","v":23},"2015-06-03","2015-06-03",null,"CLIENT 17","bracelet",{"v":39.9642857142857,"d":"40.0"},5451,"OUI "]
["2015","2015-06-06",{"$f":"WEEKNUM(BDD_entrees_2015[[#This Row],[Date reçue]],1)","v":23},"2015-06-06","2015-06-06",null,"CLIENT 18","crayons",{"v":42.0714285714286,"d":"42.1"},5784,"NON","G"]
["2015","2015-07-03",{"$f":"WEEKNUM(BDD_entrees_2015[[#This Row],[Date reçue]],1)","v":27},"2015-07-03","2015-07-03",null,"CLIENT 19","livre",{"v":44.1785714285714,"d":"44.2"},6117,"OUI ","R"]
["2015","2015-07-16",{"$f":"WEEKNUM(BDD_entrees_2015[[#This Row],[Date reçue]],1)","v":29},"2015-07-16","2015-07-16",null,"CLIENT 20","voiture",{"v":46.2857142857143,"d":"46.3"},6450,"NON","H"]
["2015","2015-07-30",{"$f":"WEEKNUM(BDD_entrees_2015[[#This Row],[Date reçue]],1)","v":31},"2015-07-30","2015-07-30",null,"CLIENT 21","jardin ",{"v":48.3928571428571,"d":"48.4"},6783,"OUI "]
["2015","2015-08-05",{"$f":"WEEKNUM(BDD_entrees_2015[[#This Row],[Date reçue]],1)","v":32},"2015-08-05","2015-08-05",null,"CLIENT 22","roue",50.5,7116,"NON","F"]
["2015","2015-08-28",{"$f":"WEEKNUM(BDD_entrees_2015[[#This Row],[Date reçue]],1)","v":35},"2015-08-28","2015-08-28",null,"CLIENT 23","bracelet",{"v":52.6071428571429,"d":"52.6"},7449,"OUI "]
["2015","2015-09-09",{"$f":"WEEKNUM(BDD_entrees_2015[[#This Row],[Date reçue]],1)","v":37},"2015-09-09","2015-09-09",null,"CLIENT 24","crayons",{"v":54.7142857142857,"d":"54.7"},7782,"NON","G"]
["2015","2015-09-30",{"$f":"WEEKNUM(BDD_entrees_2015[[#This Row],[Date reçue]],1)","v":40},"2015-09-30","2015-09-30",null,"CLIENT 25","livre",{"v":56.8214285714286,"d":"56.8"},8115,"OUI "]
["2015","2015-10-10",{"$f":"WEEKNUM(BDD_entrees_2015[[#This Row],[Date reçue]],1)","v":41},"2015-10-10","2015-10-10",null,"CLIENT 26","voiture",{"v":58.9285714285714,"d":"58.9"},8448,"NON","H"]
["2015","2015-10-30",{"$f":"WEEKNUM(BDD_entrees_2015[[#This Row],[Date reçue]],1)","v":44},"2015-10-30","2015-10-30",null,"CLIENT 27","jardin ",{"v":61.0357142857143,"d":"61.0"},8781,"OUI ","R"]
["2015","2015-11-11",{"$f":"WEEKNUM(BDD_entrees_2015[[#This Row],[Date reçue]],1)","v":46},"2015-11-11","2015-11-11",null,"CLIENT 28","roue",{"v":63.1428571428571,"d":"63.1"},9114,"NON","F"]
["2015","2015-11-30",{"$f":"WEEKNUM(BDD_entrees_2015[[#This Row],[Date reçue]],1)","v":49},"2015-11-30","2015-11-30",null,"CLIENT 29","bracelet",{"v":65.25,"d":"65.3"},9447,"OUI "]
["2015","2015-12-18",{"$f":"WEEKNUM(BDD_entrees_2015[[#This Row],[Date reçue]],1)","v":51},"2015-12-18","2015-12-18",null,"CLIENT 30","crayons",{"v":67.3571428571429,"d":"67.4"},9780,"NON","H"]
["2015","2015-12-30",{"$f":"WEEKNUM(BDD_entrees_2015[[#This Row],[Date reçue]],1)","v":53},"2015-12-30","2015-12-30",null,"CLIENT 31","livre",{"v":69.4642857142857,"d":"69.5"},10113,"OUI ","R"]

{"sheet":"e tcd pcs","index":4,"n_rows":28,"n_cols":19,"rows_kept":28}
["material","Réel 2014","Notif 2015","Notif 2015 Cumul","janv","févr.","mars","avr.","mai","juin","juil.","août","sept.","oct.","nov.","déc.","Réel 2015 Cumul","Ecart réel vs NOTIF","TX"]
[{"$nulls":4},{"$f":"SUMIFS(BDD_entrees_2015[Qty],BDD_entrees_2015[[produit ]],entrees_pcs_cle[[#This Row],[material]],BDD_entrees_2015[date],entrees_pcs_cle[[#Headers],[janv]])","v":0}]
["bracelet",345,456,{"v":412.1538461538462,"d":"412"},{"$f":"SUMIFS(BDD_entrees_2015[Qty],BDD_entrees_2015[[produit ]],entrees_pcs_cle[[#This Row],[material]],BDD_entrees_2015[date],entrees_pcs_cle[[#Headers],[janv]])","v":0},12,null,{"v":27.3214285714286,"d":"27"},null,{"v":39.9642857142857,"d":"40"},null,{"v":52.6071428571429,"d":"53"},{"$nulls":4},132,{"v":-280.1538461538462,"d":"-280"},{"v":-0.6797312430011199,"d":"-68%"}]
["crayons",456,457,{"v":413.0576923076923,"d":"413"},{"$f":"SUMIFS(BDD_entrees_2015[Qty],BDD_entrees_2015[[produit ]],entrees_pcs_cle[[#This Row],[material]],BDD_entrees_2015[date],entrees_pcs_cle[[#Headers],[janv]])","v":0},14,null,{"v":29.4285714285714,"d":"29"},null,{"v":42.0714285714286,"d":"42"},null,null,{"v":54.7142857142857,"d":"55"},{"$nulls":3},140,{"v":-273.0576923076923,"d":"-273"},{"v":-0.661064295358257,"d":"-66%"}]
["jardin ",123,234,{"v":211.5,"d":"212"},{"$f":"SUMIFS(BDD_entrees_2015[Qty],BDD_entrees_2015[[produit ]],entrees_pcs_cle[[#This Row],[material]],BDD_entrees_2015[date],entrees_pcs_cle[[#Headers],[janv]])","v":0},null,{"v":23.1071428571429,"d":"23"},null,{"v":35.75,"d":"36"},null,{"v":48.3928571428571,"d":"48"},null,null,{"v":61.0357142857143,"d":"61"},null,null,168,{"v":-43.5,"d":"-44"},{"v":-0.20567375886524822,"d":"-21%"}]
["livre",321,356,{"v":321.7692307692308,"d":"322"},{"$f":"SUMIFS(BDD_entrees_2015[Qty],BDD_entrees_2015[[produit ]],entrees_pcs_cle[[#This Row],[material]],BDD_entrees_2015[date],entrees_pcs_cle[[#Headers],[janv]])","v":0},15,null,{"v":31.5357142857143,"d":"32"},null,null,{"v":44.1785714285714,"d":"44"},null,null,{"v":56.8214285714286,"d":"57"},null,null,148,{"v":-173.76923076923077,"d":"-174"},{"v":-0.5400430313172364,"d":"-54%"}]
["maison",543,567,{"v":512.4807692307692,"d":"512"},{"$f":"SUMIFS(BDD_entrees_2015[Qty],BDD_entrees_2015[[produit ]],entrees_pcs_cle[[#This Row],[material]],BDD_entrees_2015[date],entrees_pcs_cle[[#Headers],[janv]])","v":0},{"$nulls":11},0,{"v":-512.4807692307692,"d":"-512"},{"v":-1,"d":"-100%"}]
["roue",678,680,{"v":614.6153846153846,"d":"615"},{"$f":"SUMIFS(BDD_entrees_2015[Qty],BDD_entrees_2015[[produit ]],entrees_pcs_cle[[#This Row],[material]],BDD_entrees_2015[date],entrees_pcs_cle[[#Headers],[janv]])","v":0},null,null,{"v":25.2142857142857,"d":"25"},{"v":37.8571428571429,"d":"38"},null,null,{"v":50.5,"d":"51"},null,null,{"v":63.1428571428571,"d":"63"},null,177,{"v":-437.61538461538464,"d":"-438"},{"v":-0.7120150187734668,"d":"-71%"}]
["voiture",500,500,{"v":451.9230769230769,"d":"452"},{"$f":"SUMIFS(BDD_entrees_2015[Qty],BDD_entrees_2015[[produit ]],entrees_pcs_cle[[#This Row],[material]],BDD_entrees_2015[date],entrees_pcs_cle[[#Headers],[janv]])","v":0},null,17,{"v":33.6428571428571,"d":"34"},null,null,{"v":46.2857142857143,"d":"46"},null,null,{"v":58.9285714285714,"d":"59"},null,null,156,{"v":-295.9230769230769,"d":"-296"},{"v":-0.6548085106382978,"d":"-65%"}]
["Total 1",{"$f":"SUM(B3:B9)","v":{"v":2966,"d":"2,966"}},{"v":3250,"d":"3,250"},null,{"$f":"SUMIFS(BDD_entrees_2015[Qty],BDD_entrees_2015[[produit ]],entrees_pcs_cle[[#This Row],[material]],BDD_entrees_2015[date],entrees_pcs_cle[[#Headers],[janv]])","v":0},8,8,8,8,8,8,8,8,8,8,{"$nulls":3},{"v":1.1062819114565403,"d":"111%"}]
{"$rows_empty":7}
["Somme de Qty","Semaines"]
[null,"Janvier","Février","Mars","Avril","Mai","Juin","Juillet","Août","Septembre","Octobre ","Novembre","Réel cumul 2015"]
["Étiquettes de lignes"]
["bracelet",null,12,null,{"v":27.3214285714286,"d":"27"},null,{"v":39.9642857142857,"d":"40"},null,{"v":52.6071428571429,"d":"53"},{"$nulls":3},{"v":131.8928571428572,"d":"132"}]
["crayons",null,14,null,{"v":29.4285714285714,"d":"29"},null,{"v":42.0714285714286,"d":"42"},null,null,{"v":54.7142857142857,"d":"55"},null,null,{"v":140.2142857142857,"d":"140"}]
["jardin ",3,null,{"v":23.1071428571429,"d":"23"},null,{"v":35.75,"d":"36"},null,{"v":48.3928571428571,"d":"48"},null,null,{"v":61.0357142857143,"d":"61"},null,{"v":171.2857142857143,"d":"171"}]
["livre",null,15,null,{"v":31.5357142857143,"d":"32"},null,null,{"v":44.1785714285714,"d":"44"},null,null,{"v":56.8214285714286,"d":"57"},null,{"v":147.53571428571428,"d":"148"}]
["maison",1,{"$nulls":10},1]
["roue",45,null,null,{"v":25.2142857142857,"d":"25"},{"v":37.8571428571429,"d":"38"},null,null,{"v":50.5,"d":"51"},null,null,{"v":63.1428571428571,"d":"63"},{"v":221.7142857142857,"d":"222"}]
["voiture",2,null,17,{"v":33.6428571428571,"d":"34"},null,null,{"v":46.2857142857143,"d":"46"},null,null,{"v":58.9285714285714,"d":"59"},null,{"v":157.8571428571428,"d":"158"}]
["Réel cumul 2015",51,41,{"v":40.107142857142904,"d":"40"},{"v":147.1428571428571,"d":"147"},{"v":73.60714285714289,"d":"74"},{"v":82.0357142857143,"d":"82"},{"v":138.8571428571428,"d":"139"},{"v":103.10714285714289,"d":"103"},{"v":54.7142857142857,"d":"55"},{"v":176.78571428571428,"d":"177"},{"v":63.1428571428571,"d":"63"},{"v":971.5,"d":"972"}]

{"sheet":"synthèse","index":5,"n_rows":10,"n_cols":19,"rows_kept":10}
[]
["Produits","Réel 2014","Notif 2015","Notif 2015 Cumul","janv","Février\nS06 à S09","Mars \nS10 à S13","Avril \nS14 à S18","Mai\n S19 à S22","Juin\n S23 à S26","Juillet\n S27 à S31","Aout\n S32 à S35","Septembre\n S36 à S39","Octobre\n S40 à S44","Novembre\n S45 à S48","Décembre \nS49 à S52","Réel 2015 Cumul","Ecart réel vs CG","Colonne2"]
["maison",345,456,{"v":412.1538461538462,"d":"412"},null,12,null,{"v":27.3214285714286,"d":"27"},null,{"v":39.9642857142857,"d":"40"},null,{"v":52.6071428571429,"d":"53"},{"$nulls":3},0,{"v":131.8928571428572,"d":"132"},{"v":-280.26098901098896,"d":"-280"},{"v":-0.6799912014077746,"d":"-68%"}]
["voiture",456,457,{"v":413.0576923076923,"d":"413"},null,14,null,{"v":29.4285714285714,"d":"29"},null,{"v":42.0714285714286,"d":"42"},null,null,{"v":54.7142857142857,"d":"55"},null,null,0,{"v":140.2142857142857,"d":"140"},{"v":-272.8434065934066,"d":"-273"},{"v":-0.6605455162184991,"d":"-66%"}]
["jardin ",123,234,{"v":211.5,"d":"212"},3,null,{"v":23.1071428571429,"d":"23"},null,{"v":35.75,"d":"36"},null,{"v":48.3928571428571,"d":"48"},null,null,{"v":61.0357142857143,"d":"61"},null,0,{"v":171.2857142857143,"d":"171"},{"v":-40.214285714285694,"d":"-40"},{"v":-0.1901384667342113,"d":"-19%"}]
["roue",321,356,{"v":321.7692307692308,"d":"322"},null,15,null,{"v":31.5357142857143,"d":"32"},null,null,{"v":44.1785714285714,"d":"44"},null,null,{"v":56.8214285714286,"d":"57"},null,0,{"v":147.53571428571428,"d":"148"},{"v":-174.2335164835165,"d":"-174"},{"v":-0.54148594651822,"d":"-54%"}]
["bracelet",543,567,{"v":512.4807692307692,"d":"512"},1,{"$nulls":10},0,1,{"v":-511.48076923076917,"d":"-511"},{"v":-0.9980487072685654,"d":"-100%"}]
["crayons",678,680,{"v":614.6153846153846,"d":"615"},45,null,null,{"v":25.2142857142857,"d":"25"},{"v":37.8571428571429,"d":"38"},null,null,{"v":50.5,"d":"51"},null,null,{"v":63.1428571428571,"d":"63"},0,{"v":221.7142857142857,"d":"222"},{"v":-392.901098901099,"d":"-393"},{"v":-0.6392633649204363,"d":"-64%"}]
["livre",500,500,{"v":451.9230769230769,"d":"452"},2,null,17,{"v":33.6428571428571,"d":"34"},null,null,{"v":46.2857142857143,"d":"46"},null,null,{"v":58.9285714285714,"d":"59"},null,0,{"v":157.8571428571428,"d":"158"},{"v":-294.06593406593413,"d":"-294"},{"v":-0.6506990881458968,"d":"-65%"}]
["Total 1",{"v":2966,"d":"2,966"},{"v":3250,"d":"3,250"},{"v":2937.5,"d":"2,938"},51,41,{"v":40.107142857142904,"d":"40"},{"v":147.1428571428571,"d":"147"},{"v":73.60714285714289,"d":"74"},{"v":82.0357142857143,"d":"82"},{"v":138.8571428571428,"d":"139"},{"v":103.10714285714289,"d":"103"},{"v":54.7142857142857,"d":"55"},{"v":176.78571428571428,"d":"177"},{"v":63.1428571428571,"d":"63"},0,{"v":971.5,"d":"972"},{"v":-1966,"d":"-1,966"},{"v":-0.6692765957446809,"d":"-67%"}]