{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Bridge CA YTD (2)"],"not_rendered":{"charts":10,"images":1,"macros":1,"external_links":1,"defined_names":5},"read":"whole","date_system":"1900"}

{"sheet":"Bridge CA YTD (2)","index":0,"n_rows":98,"n_cols":37,"rows_kept":98,"merged":[[5,2,5,18],[5,20,5,36],[7,2,7,4],[7,6,7,8],[7,10,7,12],[7,14,7,15],[7,17,7,18],[7,20,7,22],[7,24,7,26],[7,28,7,30],[7,32,7,33],[7,35,7,36],[16,27,16,28],[16,29,16,30],[16,31,16,32]]}
["Société"]
["RO"]
["Période",{"$f":"+[1]Feuil10!D7","v":2}]
["Mois",{"$f":"+[1]Feuil10!C7","v":"Octobre"}]
[]
[null,null,"Mth",{"$nulls":17},"YTD"]
[null,null,"CA TOTAL","RESULTAT BRUT D'EXPLOITATION",null,null,{"$f":"+C7","v":"CA TOTAL"},{"$f":"+D7","v":"RESULTAT BRUT D'EXPLOITATION"},null,null,{"$f":"+G7","v":"CA TOTAL"},{"$f":"+H7","v":"RESULTAT BRUT D'EXPLOITATION"},{"$nulls":8},"CA TOTAL","RESULTAT BRUT D'EXPLOITATION",null,null,{"$f":"+U7","v":"CA TOTAL"},{"$f":"+V7","v":"RESULTAT BRUT D'EXPLOITATION"},null,null,{"$f":"+Y7","v":"CA TOTAL"},{"$f":"+Z7","v":"RESULTAT BRUT D'EXPLOITATION"}]
[null,null,"N-1",{"$nulls":3},"B21",{"$nulls":3},"Actual",{"$nulls":3},"Actual vs B21",null,null,"Actual vs N-1",null,null,"N-1",{"$nulls":3},"B21",{"$nulls":3},"Actual",{"$nulls":3},"Actual vs B21",null,null,"Actual vs N-1"]
[null,null,"CA","RBE","% RBE",null,"CA","RBE","% RBE",null,"CA","RBE","% RBE",null,"CA","RBE",null,"CA","RBE",null,"CA","RBE","% RBE",null,"CA","RBE","% RBE",null,"CA","RBE","% RBE",null,"CA","RBE",null,"CA","RBE"]
[null,"DA FS",{"v":218.795,"d":"219 "},{"v":40.699,"d":"41 "},{"$f":"+D10/C10","v":{"v":0.18601430562855642,"d":"19%"}},null,{"v":194.517,"d":"195 "},{"v":29.085,"d":"29 "},{"$f":"+H10/G10","v":{"v":0.14952420611051992,"d":"15%"}},null,{"v":202.118,"d":"202 "},{"v":31.04,"d":"31 "},{"$f":"+L10/K10","v":{"v":0.15357365499361758,"d":"15%"}},null,{"$f":"+K10-G10","v":{"v":7.600999999999999,"d":"8 "}},{"v":1.9549999999999983,"d":"2 "},null,{"$f":"+K10-C10","v":{"v":-16.676999999999992,"d":"-17 "}},{"v":-9.658999999999999,"d":"-10 "},null,{"v":218.795,"d":"219 "},{"v":40.699,"d":"41 "},{"$f":"+V10/U10","v":{"v":0.18601430562855642,"d":"19%"}},null,{"v":194.517,"d":"195 "},{"v":29.085,"d":"29 "},{"$f":"+Z10/Y10","v":{"v":0.14952420611051992,"d":"15%"}},null,{"v":202.118,"d":"202 "},{"v":31.04,"d":"31 "},{"$f":"+AD10/AC10","v":{"v":0.15357365499361758,"d":"15%"}},null,{"$f":"+AC10-Y10","v":{"v":7.600999999999999,"d":"8 "}},{"v":1.9549999999999983,"d":"2 "},null,{"$f":"+AC10-U10","v":{"v":-16.676999999999992,"d":"-17 "}},{"v":-9.658999999999999,"d":"-10 "}]
[null,"- Distri auto",{"v":100,"d":"100 "},{"v":20,"d":"20 "},{"v":0.2,"d":"20%"},null,{"v":150,"d":"150 "},{"v":30,"d":"30 "},{"v":0.2,"d":"20%"},null,{"v":200,"d":"200 "},{"v":35,"d":"35 "},{"v":0.175,"d":"18%"},null,{"v":50,"d":"50 "},{"v":5,"d":"5 "},null,{"v":100,"d":"100 "},{"v":15,"d":"15 "},null,{"$f":"+C11*2","v":{"v":200,"d":"200 "}},{"$f":"+D11*2","v":{"v":40,"d":"40 "}},{"v":0.2,"d":"20%"},null,{"$f":"+G11*2","v":{"v":300,"d":"300 "}},{"$f":"+H11*2","v":{"v":60,"d":"60 "}},{"v":0.2,"d":"20%"},null,{"$f":"+K11*2","v":{"v":400,"d":"400 "}},{"$f":"+L11*2","v":{"v":70,"d":"70 "}},{"v":0.175,"d":"18%"},null,{"v":100,"d":"100 "},{"v":10,"d":"10 "},null,{"v":200,"d":"200 "},{"v":30,"d":"30 "}]
[null,"- Fourn & Serv",{"v":150,"d":"150 "},{"v":25,"d":"25 "},{"v":0.16666666666666666,"d":"17%"},null,{"v":100,"d":"100 "},{"v":25,"d":"25 "},{"v":0.25,"d":"25%"},null,{"v":140,"d":"140 "},{"v":30,"d":"30 "},{"v":0.21428571428571427,"d":"21%"},null,{"v":40,"d":"40 "},{"v":5,"d":"5 "},null,{"v":-10,"d":"-10 "},{"v":5,"d":"5 "},null,{"$f":"+C12*2","v":{"v":300,"d":"300 "}},{"v":50,"d":"50 "},{"v":0.16666666666666666,"d":"17%"},null,{"v":200,"d":"200 "},{"v":50,"d":"50 "},{"v":0.25,"d":"25%"},null,{"v":280,"d":"280 "},{"v":60,"d":"60 "},{"v":0.21428571428571427,"d":"21%"},null,{"v":80,"d":"80 "},{"v":10,"d":"10 "},null,{"v":-20,"d":"-20 "},{"v":10,"d":"10 "}]
[]
[]
[]
[]
[]
[]
[{"$nulls":17},"Analyse %"]
[null,null,"Y Label","X","Y","Ends","NegBlank","NegLoss","NegGain","PosBlank","PosLoss","PosGain","Y Label",{"$nulls":4},"Exceptionnel",{"$f":"+'[1]LLA détail'!U108","v":-2}]
["B21",{"$f":"+H10","v":{"v":29.085,"d":"29"}},{"$f":"IF(ISBLANK(B21),F21,B21)","v":{"v":29.085,"d":"29"}},{"v":1.5,"d":"2"},{"$f":"SUM(B$21:B21)","v":{"v":29.085,"d":"29"}},{"$f":"E21","v":{"v":29.085,"d":"29"}},{"$nulls":6},{"$f":"MAX(0,F21)","v":{"v":29.085,"d":"29"}},{"$nulls":4},"CA sup",{"$f":"+'[1]LLA détail'!U100","v":0.4679905298237299}]
[{"$f":"+R22","v":"% conso"},{"$f":"+S22","v":{"v":-7.618314271240269,"d":"-8"}},{"v":-7.618314271240269,"d":"-8"},{"$f":"D21+1","v":{"v":2.5,"d":"3"}},{"$f":"SUM(B$21:B22)","v":{"v":21.46668572875973,"d":"21"}},null,{"$f":"IF(AND(E22<0,E21<0,F22=0),MAX(E21:E22),0)","v":0},{"$f":"IF(AND(E22<0,B22<0),MAX(B22,E22),0)","v":0},{"$f":"IF(AND(E21<0,B22>0),MAX(-B22,E21),0)","v":0},{"$f":"IF(AND(E22>0,E21>0,F22=0),MIN(E21:E22),0)","v":{"v":21.46668572875973,"d":"21"}},{"$f":"IF(AND(E21>0,B22<0),MIN(-B22,E21),0)","v":{"v":7.618314271240269,"d":"8"}},{"$f":"IF(AND(E22>0,B22>0),MIN(B22,E22),0)","v":0},{"$f":"MAX(IF(F22>0,0,E21),E22)","v":{"v":29.085,"d":"29"}},{"$nulls":4},"% conso",{"$f":"+'[1]LLA détail'!U101","v":-7.618314271240269}]
[{"$f":"+R23","v":"% FP"},{"v":13.9360802037212,"d":"14"},{"v":13.9360802037212,"d":"14"},{"v":3.5,"d":"4"},{"$f":"SUM(B$21:B23)","v":{"v":35.40276593248093,"d":"35"}},null,0,0,0,{"v":21.46668572875973,"d":"21"},0,{"v":13.9360802037212,"d":"14"},{"v":35.40276593248093,"d":"35"},{"$nulls":4},"% FP",{"$f":"+'[1]LLA détail'!U102","v":13.9360802037212}]
["% AC",{"v":-3.751044613982546,"d":"-4"},{"v":-3.751044613982546,"d":"-4"},{"v":4.5,"d":"5"},{"$f":"SUM(B$21:B24)","v":{"v":31.651721318498385,"d":"32"}},null,0,0,0,{"v":31.651721318498385,"d":"32"},{"v":3.751044613982546,"d":"4"},0,{"v":35.40276593248093,"d":"35"},{"$nulls":4},"% AC",{"$f":"+'[1]LLA détail'!U104","v":-3.751044613982546},null,null,"% amort",{"$f":"+'[1]LLA détail'!U103","v":0.9153088739258921}]
[0,0,0,{"v":5.5,"d":"6"},{"$f":"SUM(B$21:B25)","v":{"v":31.651721318498385,"d":"32"}},null,0,0,0,{"v":31.651721318498385,"d":"32"},0,0,{"v":31.651721318498385,"d":"32"},{"$nulls":8},"% créance",{"$f":"+'[1]LLA détail'!U105","v":0.004117570000000043}]
[0,0,0,{"v":6.5,"d":"7"},{"$f":"SUM(B$21:B26)","v":{"v":31.651721318498385,"d":"32"}},null,0,0,0,{"v":31.651721318498385,"d":"32"},0,0,{"v":31.651721318498385,"d":"32"}]
[{"$f":"+R25","v":0},{"$f":"+W25","v":{"v":0.004117570000000043,"d":"0"}},{"v":0.004117570000000043,"d":"0"},{"v":7.5,"d":"8"},{"$f":"SUM(B$21:B27)","v":{"v":31.655838888498387,"d":"32"}},null,0,0,0,{"v":31.651721318498385,"d":"32"},0,{"v":0.004117570000000043,"d":"0"},{"v":31.655838888498387,"d":"32"}]
[0,0,0,{"v":8.5,"d":"9"},{"$f":"SUM(B$21:B28)","v":{"v":31.655838888498387,"d":"32"}},null,0,0,0,{"v":31.655838888498387,"d":"32"},0,0,{"v":31.655838888498387,"d":"32"}]
[{"$f":"+R27","v":0},0,0,{"v":9.5,"d":"10"},{"$f":"SUM(B$21:B29)","v":{"v":31.655838888498387,"d":"32"}},null,0,0,0,{"v":31.655838888498387,"d":"32"},0,0,{"v":31.655838888498387,"d":"32"}]
["(+) Autres",{"$f":"ROUND(B36-SUM(B21:B29),1)","v":{"v":-0.6,"d":"-1"}},{"v":-0.6,"d":"-1"},{"v":10.5,"d":"11"},{"$f":"SUM(B$21:B30)","v":{"v":31.055838888498386,"d":"31"}},null,0,0,0,{"v":31.055838888498386,"d":"31"},{"v":0.6,"d":"1"},0,{"v":31.655838888498387,"d":"32"}]
["Réel",null,{"v":31.055838888498386,"d":"31"},{"$f":"D30","v":{"v":10.5,"d":"11"}},{"$f":"SUM(B$21:B31)","v":{"v":31.055838888498386,"d":"31"}},{"$f":"E30","v":{"v":31.055838888498386,"d":"31"}},0,0,0,0,0,0,{"v":31.055838888498386,"d":"31"}]
[]
[]
[]
[]
["Réel",{"$f":"+L10","v":{"v":31.04,"d":"31"}}]
[]
[null,{"$f":"B36-SUM(B21:B30)","v":{"v":-0.01583888849838644,"d":"-0.0"}}]
{"$rows_empty":41}
[null,null,"Y Label","X","Y","Ends","NegBlank","NegLoss","NegGain","PosBlank","PosLoss","PosGain","Y Label"]
["B21",{"$f":"+S29","v":0},{"$f":"IF(ISBLANK(B81),F81,B81)","v":0},{"v":1.5,"d":"2"},{"$f":"SUM(B$21:B81)","v":{"v":62.08,"d":"62"}},{"$f":"E81","v":{"v":62.08,"d":"62"}},{"$nulls":6},{"$f":"MAX(0,F81)","v":{"v":62.08,"d":"62"}}]
[{"$f":"+R80","v":0},{"$f":"+W80","v":0},0,{"$f":"D81+1","v":{"v":2.5,"d":"3"}},{"$f":"SUM(B$21:B82)","v":{"v":62.08,"d":"62"}},null,{"$f":"IF(AND(E82<0,E81<0,F82=0),MAX(E81:E82),0)","v":0},{"$f":"IF(AND(E82<0,B82<0),MAX(B82,E82),0)","v":0},{"$f":"IF(AND(E81<0,B82>0),MAX(-B82,E81),0)","v":0},{"$f":"IF(AND(E82>0,E81>0,F82=0),MIN(E81:E82),0)","v":{"v":62.08,"d":"62"}},{"$f":"IF(AND(E81>0,B82<0),MIN(-B82,E81),0)","v":0},{"$f":"IF(AND(E82>0,B82>0),MIN(B82,E82),0)","v":0},{"$f":"MAX(IF(F82>0,0,E81),E82)","v":{"v":62.08,"d":"62"}}]
[{"$f":"+R81","v":0},{"$f":"+W81","v":0},0,{"v":3.5,"d":"4"},{"$f":"SUM(B$21:B83)","v":{"v":62.08,"d":"62"}},null,0,0,0,{"v":62.08,"d":"62"},0,0,{"v":62.08,"d":"62"}]
[0,0,0,{"v":4.5,"d":"5"},{"$f":"SUM(B$21:B84)","v":{"v":62.08,"d":"62"}},null,0,0,0,{"v":62.08,"d":"62"},0,0,{"v":62.08,"d":"62"}]
[0,0,0,{"v":5.5,"d":"6"},{"$f":"SUM(B$21:B85)","v":{"v":62.08,"d":"62"}},null,0,0,0,{"v":62.08,"d":"62"},0,0,{"v":62.08,"d":"62"}]
[0,0,0,{"v":6.5,"d":"7"},{"$f":"SUM(B$21:B86)","v":{"v":62.08,"d":"62"}},null,0,0,0,{"v":62.08,"d":"62"},0,0,{"v":62.08,"d":"62"}]
[0,0,0,{"v":7.5,"d":"8"},{"$f":"SUM(B$21:B87)","v":{"v":62.08,"d":"62"}},null,0,0,0,{"v":62.08,"d":"62"},0,0,{"v":62.08,"d":"62"}]
[0,0,0,{"v":8.5,"d":"9"},{"$f":"SUM(B$21:B88)","v":{"v":62.08,"d":"62"}},null,0,0,0,{"v":62.08,"d":"62"},0,0,{"v":62.08,"d":"62"}]
[{"$f":"+R87","v":0},0,0,{"v":9.5,"d":"10"},{"$f":"SUM(B$21:B89)","v":{"v":62.08,"d":"62"}},null,0,0,0,{"v":62.08,"d":"62"},0,0,{"v":62.08,"d":"62"}]
["(+) Autres",{"$f":"ROUND(B96-SUM(B81:B89),1)","v":0},0,{"v":10.5,"d":"11"},{"$f":"SUM(B$21:B90)","v":{"v":62.08,"d":"62"}},null,0,0,0,{"v":62.08,"d":"62"},0,0,{"v":62.08,"d":"62"}]
["Réel",null,{"v":62.08,"d":"62"},{"$f":"D90","v":{"v":10.5,"d":"11"}},{"$f":"SUM(B$21:B91)","v":{"v":62.08,"d":"62"}},{"$f":"E90","v":{"v":62.08,"d":"62"}},0,0,0,0,0,0,{"v":62.08,"d":"62"}]
[]
[]
[]
[]
["Réel",{"$f":"+U29","v":0}]
[]
[null,{"$f":"B96-SUM(B81:B90)","v":{"v":0,"d":"0.0"}}]