{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Production plan","France","Espagne","Allemagne","Italie"],"not_rendered":{"images":4,"macros":1,"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Production plan","index":0,"n_rows":2,"n_cols":2,"rows_kept":2}
[]
[null,"ok"]

{"sheet":"France","index":1,"n_rows":20,"n_cols":20,"rows_kept":20}
[]
[null,"France"]
[{"$nulls":6},"POO1",{"$nulls":3},"POO2",{"$nulls":3},"POO3"]
[{"$nulls":5},"1A","1B","1C","1D","1E","2A","2B","2C","2D","3A","3B","3C","3D","3E","TOTAL"]
[null,"December 2014","Ligne A",{"$f":"CONCATENATE(C5,B5)","v":"Ligne ADecember 2014"},"Ressource",{"$f":"6+3","v":9},{"$f":"F5+6","v":15},{"$f":"G5+6","v":21},27,33,39,45,51,57,63,69,75,81,87,{"$f":"SUM(F5:S5)","v":672}]
[null,"January","Ligne A","Ligne AJanuary","Ressource",0,{"$f":"F6+6","v":6},12,18,24,30,36,42,48,54,60,66,72,78,546]
[null,"February","Ligne A","Ligne AFebruary","Ressource",0,{"$f":"F7+6","v":6},12,18,24,30,36,42,48,54,60,66,72,78,546]
[null,"March","Ligne A","Ligne AMarch","Ressource",0,{"$f":"F8+6","v":6},12,18,24,30,36,42,48,54,60,66,72,78,546]
[null,"April","Ligne A","Ligne AApril","Ressource",0,{"$f":"F9+6","v":6},12,18,24,30,36,42,48,54,60,66,72,78,546]
[null,"May","Ligne A","Ligne AMay","Ressource",0,{"$f":"F10+6","v":6},12,18,24,30,36,42,48,54,60,66,72,78,546]
[null,"June","Ligne A","Ligne AJune","Ressource",0,{"$f":"F11+6","v":6},12,18,24,30,36,42,48,54,60,66,72,78,546]
[null,"July","Ligne A","Ligne AJuly","Ressource",0,{"$f":"F12+6","v":6},12,18,24,30,36,42,48,54,60,66,72,78,546]
[null,"August","Ligne A","Ligne AAugust","Ressource",0,{"$f":"F13+6","v":6},12,18,24,30,36,42,48,54,60,66,72,78,546]
[null,"September","Ligne A","Ligne ASeptember","Ressource",0,{"$f":"F14+6","v":6},12,18,24,30,36,42,48,54,60,66,72,78,546]
[null,"October","Ligne A","Ligne AOctober","Ressource",0,{"$f":"F15+6","v":6},12,18,24,30,36,42,48,54,60,66,72,78,546]
[null,"November","Ligne A","Ligne ANovember","Ressource",0,{"$f":"F16+6","v":6},12,18,24,30,36,42,48,54,60,66,72,78,546]
[null,"December","Ligne A","Ligne ADecember","Ressource",0,{"$f":"F17+6","v":6},12,18,24,30,36,42,48,54,60,66,72,78,546]
[null,"January 2016","Ligne A","Ligne AJanuary 2016","Ressource",0,{"$f":"F18+6","v":6},12,18,24,30,36,42,48,54,60,66,72,78,546]
[]
[null,"Production plan adherence",{"$nulls":3},{"$f":"F7/F5","v":{"v":0,"d":"0%"}},{"$f":"G7/G5","v":{"v":0.4,"d":"40%"}},{"$f":"H7/H5","v":{"v":0.5714285714285714,"d":"57%"}},{"v":0.6666666666666666,"d":"67%"},{"$f":"J7/J5","v":{"v":0.7272727272727273,"d":"73%"}},{"$f":"K8/K6","v":{"v":1,"d":"100%"}},{"$f":"L8/L6","v":{"v":1,"d":"100%"}},{"v":1,"d":"100%"},{"$f":"N8/N6","v":{"v":1,"d":"100%"}},{"$f":"O9/O7","v":{"v":1,"d":"100%"}},{"$f":"P9/P7","v":{"v":1,"d":"100%"}},{"v":1,"d":"100%"},{"$f":"R9/R7","v":{"v":1,"d":"100%"}},{"$f":"S10/S8","v":{"v":1,"d":"100%"}}]

{"sheet":"Espagne","index":2,"n_rows":20,"n_cols":20,"rows_kept":20,"merged":[[20,5,20,9],[20,10,20,13],[20,14,20,18]]}
[]
[null,"France"]
[{"$nulls":6},"POO1",{"$nulls":3},"POO2",{"$nulls":3},"POO3"]
[{"$nulls":5},"1A","1B","1C","1D","1E","2A","2B","2C","2D","3A","3B","3C","3D","3E","TOTAL"]
[null,"December 2014","Ligne A",{"$f":"CONCATENATE(C5,B5)","v":"Ligne ADecember 2014"},"Ressource",6,21,18,18,19,17,17,17,18,17,16,17,13,14,{"$f":"SUM(F5:S5)","v":228}]
[null,"January","Ligne A","Ligne AJanuary","Ressource",0,12,17,12,15,22,18,18,18,18,18,18,18,18,222]
[null,"February","Ligne A","Ligne AFebruary","Ressource",0,12,17,12,15,9,16,14,16,28,18,19,18,16,210]
[null,"March","Ligne A","Ligne AMarch","Ressource",0,12,17,12,15,9,16,14,16,17,16,15,15,22,196]
[null,"April","Ligne A","Ligne AApril","Ressource",0,12,17,12,15,9,16,14,16,17,16,15,15,11,185]
[null,"May","Ligne A","Ligne AMay","Ressource",0,12,17,12,15,9,16,14,16,17,16,15,15,11,185]
[null,"June","Ligne A","Ligne AJune","Ressource",0,12,17,12,15,9,16,14,16,17,16,15,15,11,185]
[null,"July","Ligne A","Ligne AJuly","Ressource",0,12,17,12,15,9,16,14,16,17,16,15,15,11,185]
[null,"August","Ligne A","Ligne AAugust","Ressource",0,12,17,12,15,9,16,14,16,17,16,15,15,11,185]
[null,"September","Ligne A","Ligne ASeptember","Ressource",0,12,17,12,15,9,16,14,16,17,16,15,15,11,185]
[null,"October","Ligne A","Ligne AOctober","Ressource",0,12,17,12,15,9,16,14,16,17,16,15,15,11,185]
[null,"November","Ligne A","Ligne ANovember","Ressource",0,12,17,12,15,9,16,14,16,17,16,15,15,11,185]
[null,"December","Ligne A","Ligne ADecember","Ressource",0,12,17,12,15,9,16,14,16,17,16,15,15,11,185]
[null,"January 2016","Ligne A","Ligne AJanuary 2016","Ressource",0,12,17,12,15,9,16,14,16,17,16,15,15,11,185]
[]
[null,"Production plan adherence",{"$nulls":3},{"$f":"F7/F5","v":{"v":0,"d":"0%"}},{"$f":"G7/G5","v":{"v":0.5714285714285714,"d":"57%"}},{"$f":"H7/H5","v":{"v":0.9444444444444444,"d":"94%"}},{"v":0.6666666666666666,"d":"67%"},{"$f":"J7/J5","v":{"v":0.7894736842105263,"d":"79%"}},{"$f":"K8/K6","v":{"v":0.4090909090909091,"d":"41%"}},{"$f":"L8/L6","v":{"v":0.8888888888888888,"d":"89%"}},{"v":0.7777777777777778,"d":"78%"},{"$f":"N8/N6","v":{"v":0.8888888888888888,"d":"89%"}},{"$f":"O9/O7","v":{"v":0.6071428571428571,"d":"61%"}},{"$f":"P9/P7","v":{"v":0.8888888888888888,"d":"89%"}},{"v":0.7894736842105263,"d":"79%"},{"$f":"R9/R7","v":{"v":0.8333333333333334,"d":"83%"}},{"$f":"S10/S8","v":{"v":0.5,"d":"50%"}}]

{"sheet":"Allemagne","index":3,"n_rows":20,"n_cols":20,"rows_kept":20,"merged":[[2,6,2,9],[2,10,2,13],[2,14,2,17],[20,5,20,9],[20,10,20,13],[20,14,20,18]]}
[]
[null,"France"]
[{"$nulls":6},"POO1",{"$nulls":3},"POO2",{"$nulls":3},"POO3"]
[{"$nulls":5},"1A","1B","1C","1D","1E","2A","2B","2C","2D","3A","3B","3C","3D","3E","TOTAL"]
[null,"December 2014","Ligne A",{"$f":"CONCATENATE(C5,B5)","v":"Ligne ADecember 2014"},"Ressource",18,{"$f":"21+F5","v":39},{"$f":"21+G5","v":60},81,102,123,144,165,186,207,228,249,270,291,{"$f":"SUM(F5:S5)","v":{"v":2163,"d":"2,163"}}]
[null,"January","Ligne A","Ligne AJanuary","Ressource",1,{"$f":"21+F6","v":22},43,64,85,106,127,148,169,190,211,232,253,274,{"v":1925,"d":"1,925"}]
[null,"February","Ligne A","Ligne AFebruary","Ressource",3,24,45,66,87,108,129,150,171,192,213,234,255,276,{"v":1953,"d":"1,953"}]
[null,"March","Ligne A","Ligne AMarch","Ressource",5,26,47,68,89,110,131,152,173,194,215,236,257,278,{"v":1981,"d":"1,981"}]
[null,"April","Ligne A","Ligne AApril","Ressource",7,28,49,70,91,112,133,154,175,196,217,238,259,280,{"v":2009,"d":"2,009"}]
[null,"May","Ligne A","Ligne AMay","Ressource",8,29,50,71,92,113,134,155,176,197,218,239,260,281,{"v":2023,"d":"2,023"}]
[null,"June","Ligne A","Ligne AJune","Ressource",9,30,51,72,93,114,135,156,177,198,219,240,261,282,{"v":2037,"d":"2,037"}]
[null,"July","Ligne A","Ligne AJuly","Ressource",10,31,52,73,94,115,136,157,178,199,220,241,262,283,{"v":2051,"d":"2,051"}]
[null,"August","Ligne A","Ligne AAugust","Ressource",24,45,66,87,108,129,150,171,192,213,234,255,276,297,{"v":2247,"d":"2,247"}]
[null,"September","Ligne A","Ligne ASeptember","Ressource",20,41,62,83,104,125,146,167,188,209,230,251,272,293,{"v":2191,"d":"2,191"}]
[null,"October","Ligne A","Ligne AOctober","Ressource",5,26,47,68,89,110,131,152,173,194,215,236,257,278,{"v":1981,"d":"1,981"}]
[null,"November","Ligne A","Ligne ANovember","Ressource",2,23,44,65,86,107,128,149,170,191,212,233,254,275,{"v":1939,"d":"1,939"}]
[null,"December","Ligne A","Ligne ADecember","Ressource",8,29,50,71,92,113,134,155,176,197,218,239,260,281,{"v":2023,"d":"2,023"}]
[null,"January 2016","Ligne A","Ligne AJanuary 2016","Ressource",7,28,49,70,91,112,133,154,175,196,217,238,259,280,{"v":2009,"d":"2,009"}]
[]
[null,"Production plan adherence",{"$nulls":3},{"$f":"F7/F5","v":{"v":0.16666666666666666,"d":"17%"}},{"$f":"G7/G5","v":{"v":0.6153846153846154,"d":"62%"}},{"$f":"H7/H5","v":{"v":0.75,"d":"75%"}},{"v":0.8148148148148148,"d":"81%"},{"$f":"J7/J5","v":{"v":0.8529411764705882,"d":"85%"}},{"$f":"K8/K6","v":{"v":1.0377358490566038,"d":"104%"}},{"$f":"L8/L6","v":{"v":1.031496062992126,"d":"103%"}},{"v":1.027027027027027,"d":"103%"},{"$f":"N8/N6","v":{"v":1.0236686390532543,"d":"102%"}},{"$f":"O9/O7","v":{"v":1.0208333333333333,"d":"102%"}},{"$f":"P9/P7","v":{"v":1.0187793427230047,"d":"102%"}},{"v":1.017094017094017,"d":"102%"},{"$f":"R9/R7","v":{"v":1.0156862745098039,"d":"102%"}},{"$f":"S10/S8","v":{"v":1.0107913669064748,"d":"101%"}}]

{"sheet":"Italie","index":4,"n_rows":20,"n_cols":20,"rows_kept":20,"merged":[[2,6,2,9],[2,10,2,13],[2,14,2,17],[20,5,20,9],[20,10,20,13],[20,14,20,18]]}
[]
[null,"France"]
[{"$nulls":6},"POO1",{"$nulls":3},"POO2",{"$nulls":3},"POO3"]
[{"$nulls":5},"1A","1B","1C","1D","1E","2A","2B","2C","2D","3A","3B","3C","3D","3E","TOTAL"]
[null,"December 2014","Ligne A",{"$f":"CONCATENATE(C5,B5)","v":"Ligne ADecember 2014"},"Ressource",2,{"$f":"3+F5","v":5},{"$f":"3+G5","v":8},11,14,17,20,23,26,29,32,35,38,41,{"$f":"SUM(F5:S5)","v":301}]
[null,"January","Ligne A","Ligne AJanuary","Ressource",2,{"$f":"3+F6","v":5},{"$f":"3+G6","v":8},11,14,17,20,23,26,29,32,35,38,41,301]
[null,"February","Ligne A","Ligne AFebruary","Ressource",4,7,10,13,16,19,22,25,28,31,34,37,40,43,329]
[null,"March","Ligne A","Ligne AMarch","Ressource",5,8,11,14,17,20,23,26,29,32,35,38,41,44,343]
[null,"April","Ligne A","Ligne AApril","Ressource",3,6,9,12,15,18,21,24,27,30,33,36,39,42,315]
[null,"May","Ligne A","Ligne AMay","Ressource",7,10,13,16,19,22,25,28,31,34,37,40,43,46,371]
[null,"June","Ligne A","Ligne AJune","Ressource",8,11,14,17,20,23,26,29,32,35,38,41,44,47,385]
[null,"July","Ligne A","Ligne AJuly","Ressource",9,12,15,18,21,24,27,30,33,36,39,42,45,48,399]
[null,"August","Ligne A","Ligne AAugust","Ressource",10,13,16,19,22,25,28,31,34,37,40,43,46,49,413]
[null,"September","Ligne A","Ligne ASeptember","Ressource",22,25,28,31,34,37,40,43,46,49,52,55,58,61,581]
[null,"October","Ligne A","Ligne AOctober","Ressource",1,4,7,10,13,16,19,22,25,28,31,34,37,40,287]
[null,"November","Ligne A","Ligne ANovember","Ressource",5,8,11,14,17,20,23,26,29,32,35,38,41,44,343]
[null,"December","Ligne A","Ligne ADecember","Ressource",8,11,14,17,20,23,26,29,32,35,38,41,44,47,385]
[null,"January 2016","Ligne A","Ligne AJanuary 2016","Ressource",9,12,15,18,21,24,27,30,33,36,39,42,45,48,399]
[]
[null,"Production plan adherence",{"$nulls":3},{"$f":"F7/F5","v":{"v":2,"d":"200%"}},{"$f":"G7/G5","v":{"v":1.4,"d":"140%"}},{"$f":"H7/H5","v":{"v":1.25,"d":"125%"}},{"v":1.1818181818181819,"d":"118%"},{"$f":"J7/J5","v":{"v":1.1428571428571428,"d":"114%"}},{"$f":"K8/K6","v":{"v":1.1764705882352942,"d":"118%"}},{"$f":"L8/L6","v":{"v":1.15,"d":"115%"}},{"v":1.1304347826086956,"d":"113%"},{"$f":"N8/N6","v":{"v":1.1153846153846154,"d":"112%"}},{"$f":"O9/O7","v":{"v":0.967741935483871,"d":"97%"}},{"$f":"P9/P7","v":{"v":0.9705882352941176,"d":"97%"}},{"v":0.972972972972973,"d":"97%"},{"$f":"R9/R7","v":{"v":0.975,"d":"98%"}},{"$f":"S10/S8","v":{"v":1.0454545454545454,"d":"105%"}}]