{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Input","Tables","Charts","Disclaimer"],"not_rendered":{"charts":4,"images":8,"macros":1,"external_links":0,"defined_names":1,"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":"Input","index":0,"n_rows":29,"n_cols":5,"rows_kept":29,"cut":false,"hidden":false,"merged":[[4,1,4,2]]}
["c","Outil Parker HFDE"]
[null,"Calculateur de Rentabilité ",null,null,"version 1.0     "]
[]
[]
[null,"Connaissez-vous le montant des bénéfices et des pertes potentielles de votre entreprise liés au remplacement et à la gestion inappropriée et inefficace de vos filtres hydrauliques de rechange ou de nouvelles installations ? Ce calculateur du marché des pièces de rechange est un outil Parker, simple mais efficace, conçue pour vous permettre de déterminer, en quelques questions, le degré de rentabilité de l'achat et de l'utilisation de votre filtre pour votre entreprise."]
[]
[null,"Nouvelles Machines & Équipements"]
[]
[null,"Combien de systèmes hydrauliques ou de véhicules vendez-vous par an?",500,"pcs"]
[]
[null,"Quel est votre prix d'achat du filtre concurrent (complet)?",50,"€"]
[]
[null,"Quel est votre prix d'achat du filtre complet Parker?",60,"€"]
[]
[null,"Marché des Pièces de Rechange"]
[]
[null,"Combien de fois, généralement, l'élément filtrant est t'il remplacé sur une",1,"x"]
[null,"période de 12 mois?"]
[null,"Quelle est votre part de marché pour un élément de rechange non breveté?",30,"%"]
[]
[null,"Quel est votre prix d'achat d'un élément de rechange non-breveté?",20,"€"]
[]
[null,"Quel est votre prix net de vente d'un élément de rechange non-breveté?",50,"€"]
[]
[null,"Quelle est votre part de marché pour un élément de rechange breveté?",90,"%"]
[]
[null,"Quel est votre prix d'achat d'un élément de rechange breveté?",22,"€"]
[]
[null,"Quel est votre prix net de vente d'un élément de rechange breveté?",52,"€"]

{"sheet":"Tables","index":1,"n_rows":35,"n_cols":19,"rows_kept":35,"cut":false,"hidden":false,"merged":[[21,3,21,5],[21,8,21,9],[21,10,21,11],[3,3,3,5],[3,8,3,11],[20,3,20,5],[20,8,20,9],[20,10,20,11],[4,3,4,5],[4,8,4,11]]}
[]
[null,"   Calculateur de Rentabilité"]
[]
[null,null,"Tableau I","Quantité de ventes",null,null,null,"Tableau II","Coûts d'achat"]
[]
[null,null,null,"Filtre de","Éléments de rechange","Éléments de rechange",null,null,"Filtres de concurrent","Filtres de Parker","Éléments de rechange","Éléments de rechange"]
[null,null,"Année","premier ajustement","non breveté","breveté",null,"Année","premier ajustement","premier ajustement","non breveté","breveté",null,null,"Filtres conc. & Éléments non breveté","Filters Parker & Éléments breveté"]
[null,null,1,{"$f":"Input!$C$9","v":500},{"$f":"((SUM($D$8:D8)-$D$8)+(0.5*D8))*Input!$C$17*Input!$C$19/100","v":75},{"$f":"((SUM($D$8:D8)-$D$8)+(0.5*D8))*Input!$C$17*Input!$C$25/100","v":225},null,1,{"$f":"ROUND((D8*Input!$C$11),0)","v":25000},{"$f":"ROUND((D8*Input!$C$13),0)","v":30000},{"$f":"ROUND((E8*Input!$C$21),0)","v":1500},{"$f":"ROUND((F8*Input!$C$27),0)","v":4950},null,null,{"$f":"I8+K8","v":26500},{"$f":"J8+L8","v":34950}]
[null,null,2,{"$f":"Input!$C$9","v":500},{"$f":"((SUM($D$8:D9)-$D$8)+(0.5*D9))*Input!$C$17*Input!$C$19/100","v":225},{"$f":"((SUM($D$8:D9)-$D$8)+(0.5*D9))*Input!$C$17*Input!$C$25/100","v":675},null,2,{"$f":"ROUND((D9*Input!$C$11),0)","v":25000},{"$f":"ROUND((D9*Input!$C$13),0)","v":30000},{"$f":"ROUND((E9*Input!$C$21),0)","v":4500},{"$f":"ROUND((F9*Input!$C$27),0)","v":14850},null,null,{"$f":"I9+K9","v":29500},{"$f":"J9+L9","v":44850}]
[null,null,3,{"$f":"Input!$C$9","v":500},{"$f":"((SUM($D$8:D10)-$D$8)+(0.5*D10))*Input!$C$17*Input!$C$19/100","v":375},{"$f":"((SUM($D$8:D10)-$D$8)+(0.5*D10))*Input!$C$17*Input!$C$25/100","v":1125},null,3,{"$f":"ROUND((D10*Input!$C$11),0)","v":25000},{"$f":"ROUND((D10*Input!$C$13),0)","v":30000},{"$f":"ROUND((E10*Input!$C$21),0)","v":7500},{"$f":"ROUND((F10*Input!$C$27),0)","v":24750},null,null,32500,54750]
[null,null,4,{"$f":"Input!$C$9","v":500},{"$f":"((SUM($D$8:D11)-$D$8)+(0.5*D11))*Input!$C$17*Input!$C$19/100","v":525},{"$f":"((SUM($D$8:D11)-$D$8)+(0.5*D11))*Input!$C$17*Input!$C$25/100","v":1575},null,4,{"$f":"ROUND((D11*Input!$C$11),0)","v":25000},{"$f":"ROUND((D11*Input!$C$13),0)","v":30000},{"$f":"ROUND((E11*Input!$C$21),0)","v":10500},{"$f":"ROUND((F11*Input!$C$27),0)","v":34650},null,null,35500,64650]
[null,null,5,{"$f":"Input!$C$9","v":500},{"$f":"((SUM($D$8:D12)-$D$8)+(0.5*D12))*Input!$C$17*Input!$C$19/100","v":675},{"$f":"((SUM($D$8:D12)-$D$8)+(0.5*D12))*Input!$C$17*Input!$C$25/100","v":2025},null,5,{"$f":"ROUND((D12*Input!$C$11),0)","v":25000},{"$f":"ROUND((D12*Input!$C$13),0)","v":30000},{"$f":"ROUND((E12*Input!$C$21),0)","v":13500},{"$f":"ROUND((F12*Input!$C$27),0)","v":44550},null,null,38500,74550]
[null,null,6,{"$f":"Input!$C$9","v":500},{"$f":"((SUM($D$8:D13)-$D$8)+(0.5*D13))*Input!$C$17*Input!$C$19/100","v":825},{"$f":"((SUM($D$8:D13)-$D$8)+(0.5*D13))*Input!$C$17*Input!$C$25/100","v":2475},null,6,{"$f":"ROUND((D13*Input!$C$11),0)","v":25000},{"$f":"ROUND((D13*Input!$C$13),0)","v":30000},{"$f":"ROUND((E13*Input!$C$21),0)","v":16500},{"$f":"ROUND((F13*Input!$C$27),0)","v":54450},null,null,41500,84450]
[null,null,7,{"$f":"Input!$C$9","v":500},{"$f":"((SUM($D$8:D14)-$D$8)+(0.5*D14))*Input!$C$17*Input!$C$19/100","v":975},{"$f":"((SUM($D$8:D14)-$D$8)+(0.5*D14))*Input!$C$17*Input!$C$25/100","v":2925},null,7,{"$f":"ROUND((D14*Input!$C$11),0)","v":25000},{"$f":"ROUND((D14*Input!$C$13),0)","v":30000},{"$f":"ROUND((E14*Input!$C$21),0)","v":19500},{"$f":"ROUND((F14*Input!$C$27),0)","v":64350},null,null,44500,94350]
[null,null,8,{"$f":"Input!$C$9","v":500},{"$f":"((SUM($D$8:D15)-$D$8)+(0.5*D15))*Input!$C$17*Input!$C$19/100","v":1125},{"$f":"((SUM($D$8:D15)-$D$8)+(0.5*D15))*Input!$C$17*Input!$C$25/100","v":3375},null,8,{"$f":"ROUND((D15*Input!$C$11),0)","v":25000},{"$f":"ROUND((D15*Input!$C$13),0)","v":30000},{"$f":"ROUND((E15*Input!$C$21),0)","v":22500},{"$f":"ROUND((F15*Input!$C$27),0)","v":74250},null,null,47500,104250]
[null,null,9,{"$f":"Input!$C$9","v":500},{"$f":"((SUM($D$8:D16)-$D$8)+(0.5*D16))*Input!$C$17*Input!$C$19/100","v":1275},{"$f":"((SUM($D$8:D16)-$D$8)+(0.5*D16))*Input!$C$17*Input!$C$25/100","v":3825},null,9,{"$f":"ROUND((D16*Input!$C$11),0)","v":25000},{"$f":"ROUND((D16*Input!$C$13),0)","v":30000},{"$f":"ROUND((E16*Input!$C$21),0)","v":25500},{"$f":"ROUND((F16*Input!$C$27),0)","v":84150},null,null,50500,114150]
[null,null,10,{"$f":"Input!$C$9","v":500},{"$f":"((SUM($D$8:D17)-$D$8)+(0.5*D17))*Input!$C$17*Input!$C$19/100","v":1425},{"$f":"((SUM($D$8:D17)-$D$8)+(0.5*D17))*Input!$C$17*Input!$C$25/100","v":4275},null,10,{"$f":"ROUND((D17*Input!$C$11),0)","v":25000},{"$f":"ROUND((D17*Input!$C$13),0)","v":30000},{"$f":"ROUND((E17*Input!$C$21),0)","v":28500},{"$f":"ROUND((F17*Input!$C$27),0)","v":94050},null,null,53500,124050]
[null,null,"Totaux",{"$f":"SUM(D8:D17)","v":5000},{"$f":"SUM(E8:E17)","v":7500},{"$f":"SUM(F8:F17)","v":22500},null,"Totaux",{"$f":"SUM(I8:I17)","v":250000},{"$f":"SUM(J8:J17)","v":300000},{"$f":"SUM(K8:K17)","v":150000},{"$f":"SUM(L8:L17)","v":495000}]
[]
[]
[null,null,"Tableau III","Revenus commerciaux",null,null,null,"Tableau IV","Développement des bénéfices",null,"Développement des marges"]
[]
[null,null,null,null,"Éléments de rechange","Éléments de rechange",null,null,"Filtres de conc. prem. aj.","Filtres de Parker prem. aj.","Filtres de conc. prem. aj.","Filtres de Parker prem. aj."]
[null,null,"Année",null,"non breveté","breveté",null,"Année","& Éléments non breveté","& Éléments breveté","& Éléments non breveté","& Éléments breveté",null,null,"Filtres conc. & Éléments non breveté","Filters Parker & Éléments breveté",null,"Filtres conc. & Éléments non breveté","Filters Parker & Éléments breveté"]
[null,null,1,null,{"$f":"ROUND((E8*Input!$C$23),0)","v":3750},{"$f":"ROUND((F8*Input!$C$29),0)","v":11700},null,1,{"$f":"E25-(I8+K8)","v":-22750},{"$f":"F25-(J8+L8)","v":-23250},{"$f":"(E25-(I8+K8))/(I8+K8)","v":-0.85849056603773588},{"$f":"(F25-(J8+L8))/(J8+L8)","v":-0.66523605150214593},null,null,{"$f":"E25-(I8+K8)","v":-22750},{"$f":"F25-(J8+L8)","v":-23250},null,{"$f":"(E25-(I8+K8))/(I8+K8)","v":-0.85849056603773588},{"$f":"(F25-(J8+L8))/(J8+L8)","v":-0.66523605150214593}]
[null,null,2,null,{"$f":"ROUND((E9*Input!$C$23),0)","v":11250},{"$f":"ROUND((F9*Input!$C$29),0)","v":35100},null,2,{"$f":"E26-(I9+K9)","v":-18250},{"$f":"F26-(J9+L9)","v":-9750},{"$f":"(E26-(I9+K9))/(I9+K9)","v":-0.61864406779661019},{"$f":"(F26-(J9+L9))/(J9+L9)","v":-0.21739130434782608},null,null,{"$f":"E26-(I9+K9)","v":-18250},{"$f":"F26-(J9+L9)","v":-9750},null,{"$f":"(E26-(I9+K9))/(I9+K9)","v":-0.61864406779661019},{"$f":"(F26-(J9+L9))/(J9+L9)","v":-0.21739130434782608}]
[null,null,3,null,{"$f":"ROUND((E10*Input!$C$23),0)","v":18750},{"$f":"ROUND((F10*Input!$C$29),0)","v":58500},null,3,-13750,3750,-0.42307692307692307,6.8493150684931503E-2,null,null,-13750,3750,null,-0.42307692307692307,6.8493150684931503E-2]
[null,null,4,null,{"$f":"ROUND((E11*Input!$C$23),0)","v":26250},{"$f":"ROUND((F11*Input!$C$29),0)","v":81900},null,4,-9250,17250,-0.26056338028169013,0.26682134570765659,null,null,-9250,17250,null,-0.26056338028169013,0.26682134570765659]
[null,null,5,null,{"$f":"ROUND((E12*Input!$C$23),0)","v":33750},{"$f":"ROUND((F12*Input!$C$29),0)","v":105300},null,5,-4750,30750,-0.12337662337662338,0.41247484909456739,null,null,-4750,30750,null,-0.12337662337662338,0.41247484909456739]
[null,null,6,null,{"$f":"ROUND((E13*Input!$C$23),0)","v":41250},{"$f":"ROUND((F13*Input!$C$29),0)","v":128700},null,6,-250,44250,-6.024096385542169E-3,0.5239786856127886,null,null,-250,44250,null,-6.024096385542169E-3,0.5239786856127886]
[null,null,7,null,{"$f":"ROUND((E14*Input!$C$23),0)","v":48750},{"$f":"ROUND((F14*Input!$C$29),0)","v":152100},null,7,4250,57750,9.5505617977528087E-2,0.61208267090620028,null,null,4250,57750,null,9.5505617977528087E-2,0.61208267090620028]
[null,null,8,null,{"$f":"ROUND((E15*Input!$C$23),0)","v":56250},{"$f":"ROUND((F15*Input!$C$29),0)","v":175500},null,8,8750,71250,0.18421052631578946,0.68345323741007191,null,null,8750,71250,null,0.18421052631578946,0.68345323741007191]
[null,null,9,null,{"$f":"ROUND((E16*Input!$C$23),0)","v":63750},{"$f":"ROUND((F16*Input!$C$29),0)","v":198900},null,9,13250,84750,0.26237623762376239,0.74244415243101181,null,null,13250,84750,null,0.26237623762376239,0.74244415243101181]
[null,null,10,null,{"$f":"ROUND((E17*Input!$C$23),0)","v":71250},{"$f":"ROUND((F17*Input!$C$29),0)","v":222300},null,10,17750,98250,0.33177570093457942,0.79201934703748489,null,null,17750,98250,null,0.33177570093457942,0.79201934703748489]
[null,null,"Totaux",null,{"$f":"SUM(E25:E34)","v":375000},{"$f":"SUM(F25:F34)","v":1170000},null,"Totaux",-25000,375000,{"$f":"(E35-(I18+K18))/(I18+K18)","v":-6.25E-2},0.47169811320754718]

{"sheet":"Charts","index":2,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,"   Calculateur de Rentabilité"]

{"sheet":"Disclaimer","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}