{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["T. de b. d'indicateurs produits","Données liées aux produits"],"not_rendered":{"charts":4,"images":1,"macros":0,"external_links":0,"defined_names":0,"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":"T. de b. d'indicateurs produits","index":0,"n_rows":75,"n_cols":9,"rows_kept":75,"cut":false,"hidden":false,"merged":[[74,0,79,14],[0,0,0,8],[1,0,1,13],[27,0,27,5],[27,8,27,13],[47,0,47,13]]}
["TABLEAU DE BORD D'INDICATEURS DE PRODUITS"]
["RECETTES DES PRODUITS"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["VENTILATION DES RECETTES",null,null,null,null,null,null,null,"DÉLAIS DE MISE SUR LE MARCHÉ"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["GAIN / PERTE"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["En savoir plus sur les tableaux de bord dans Smartsheet"]

{"sheet":"Données liées aux produits","index":1,"n_rows":21,"n_cols":14,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,0,9],[4,0,4,1],[17,0,17,9],[9,0,9,1],[10,0,10,1],[1,0,1,13],[2,0,2,1],[3,0,3,1],[12,11,12,13],[12,0,12,9],[5,0,5,1],[6,0,6,1],[7,0,7,1],[8,0,8,1]]}
["DONNÉES LIÉES AUX PRODUITS"]
["RECETTES DES PRODUITS"]
["NOM DU PRODUIT",null,"JANV.","FÉV.","MARS","AVR.","MAI","JUIN","JUIL.","AOÛT","SEPT.","OCT.","NOV.","DÉC."]
["PRODUIT 1",null,47216,244714,246549,235062,162881,96528,29235,25934,233397,78479,184799,248215]
["PRODUIT 2",null,19193,32086,93117,45862,62853,55513,22945,15084,45347,57736,20142,45284]
["PRODUIT 3",null,222006,180009,99998,215030,195262,272260,128123,163950,213914,180191,111890,260495]
["PRODUIT 4",null,39469,58661,60612,99456,39062,42689,53197,23026,33165,88342,8492,34798]
["PRODUIT 5",null,234770,46607,232313,255979,282279,83677,254593,50461,239685,106425,229535,200682]
["PRODUIT 6",null,201494,186911,203515,234445,181894,160175,266340,175055,94469,209779,275541,268761]
["PRODUIT 7",null,274110,149012,260774,107794,35721,225425,62085,130874,194695,19447,31889,31930]
["PRODUIT 8",null,82171,204047,44710,100217,115395,145751,15786,37944,38415,70395,25040,67508]
[]
["VENTILATION DES RECETTES",null,null,null,null,null,null,null,null,null,null,"DÉLAIS DE MISE SUR LE MARCHÉ"]
[null,"PRODUIT 1","PRODUIT 2","PRODUIT 3","PRODUIT 4","PRODUIT 5","PRODUIT 6","PRODUIT 7","PRODUIT 8","TOUS",null,null,"NOUVEAU PRODUIT","PRODUIT EXISTANT"]
["REC. ANNUELLES",{"$f":"SUM(C4:N4)","v":1833009},{"$f":"SUM(C5:N5)","v":515162},{"$f":"SUM(C6:N6)","v":2243128},{"$f":"SUM(C7:N7)","v":580969},{"$f":"SUM(C8:N8)","v":2217006},{"$f":"SUM(C9:N9)","v":2458379},{"$f":"SUM(C10:N10)","v":1523756},{"$f":"SUM(C11:N11)","v":947379},{"$f":"SUM(B15:I15)","v":12318788},null,"JOURS",57.6,22.4]
["POURCENTAGE",{"$f":"B15/J15","v":0.14879783628064708},{"$f":"C15/J15","v":4.1819211435410689E-2},{"$f":"D15/J15","v":0.18208999132057471},{"$f":"E15/J15","v":4.716121423633559E-2},{"$f":"F15/J15","v":0.17996949050507241},{"$f":"G15/J15","v":0.19956338237170734},{"$f":"H15/J15","v":0.12369366207130117},{"$f":"I15/J15","v":7.6905211778950988E-2},{"$f":"SUM(B16:I16)","v":1},null,"OBJECTIF",55,20]
[]
["GAIN / PERTE"]
[null,"PRODUIT 1","PRODUIT 2","PRODUIT 3","PRODUIT 4","PRODUIT 5","PRODUIT 6","PRODUIT 7","PRODUIT 8","TOUS"]
["GAIN",0.73,0.75,0.91,0.85,0.89,0.82,0.28000000000000003,0.84,{"$f":"SUM(B20:I20)/8","v":0.75875000000000004}]
["PERTE",{"$f":"1-B20","v":0.27},{"$f":"1-C20","v":0.25},8.9999999999999969E-2,0.15000000000000002,0.10999999999999999,0.18000000000000005,0.72,0.16000000000000003,{"$f":"SUM(B21:I21)/8","v":0.24125000000000002}]