2c:null 2d:["$","title",null,{"children":"Simulation des frais kilométriques pour un véhicule automobile | Thomas Parisot | Observable"}] 32:T4c5,viewof entretiens_html = { add_entretien; mutable entretiens_data; const rows = entretiens_data.map((item, i) => { const inputDate = Text({ label: 'Date', type: 'date', value: item.date }) const inputPrice = Text({ label: 'Prix (€ TTC)', type: 'number', value: item.prix }) const inputComment = Textarea({ label: 'Commentaire (facultatif)', value: item.description }) const fields = [['date', inputDate], ['prix', inputPrice], ['description', inputComment]] fields.forEach(([key, input]) => { input.oninput = () => { mutable entretiens_data[i][key] = guessValue(input.value) output.value = `${i}${key}${input.value}` output.dispatchEvent(new Event("input")) } }) return html.fragment`

${inputDate} ${inputPrice} ${inputComment}

` }) const output = html`

${rows}` return output }33:[] 30:{"id":"2ca18c65566802bd","slug":"frais-kilometriques-autopartage","title":"Simulation des frais kilométriques pour un véhicule automobile","thumbnail":"408251f32ec3ecb58fced6b6e9911c3ad6e60bc8258c78e1e4e861379b8d1f24","access_level":"public","create_time":"$D2021-03-14T10:39:25.425Z","update_time":"$D2022-03-05T18:14:47.697Z","view_time":null,"first_public_time":"$D2021-03-14T11:36:40.010Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"2e47ffb87e7621ba","login":"thom4","name":"Thomas Parisot","avatar_url":"https://avatars-next.observableusercontent.com/20af6aecdac86e856fff9682815248802780c6d963ad6a7e70fe16aa6b8be2c3","tier":"starter_2024","bio":"I design web software, facilitate team work and bake sourdough bread • I believe in autonomy and kindness • @bbcrd alumnus"},"version":1114,"publish_version":1114,"role":null,"authored":false,"authors":[{"type":"individual","id":"b5360110032f691c","login":"thom4","name":"Thomas Parisot","avatar_url":"https://avatars-next.observableusercontent.com/20af6aecdac86e856fff9682815248802780c6d963ad6a7e70fe16aa6b8be2c3","tier":null,"bio":"I design web software, facilitate team work and bake sourdough bread • I believe in autonomy and kindness • @bbcrd alumnus"}],"members":[{"type":"individual","id":"b5360110032f691c","login":"thom4","name":"Thomas Parisot","avatar_url":"https://avatars-next.observableusercontent.com/20af6aecdac86e856fff9682815248802780c6d963ad6a7e70fe16aa6b8be2c3","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Simulation des frais kilométriques pour un véhicule automobile","cells":[{"id":0,"value":"md`# Simulation des frais kilométriques pour un véhicule automobile`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":931,"value":"md`Cet outil a été créé par l'association d'[auto-partage entre particuliers](https://www.autosbus.org/autopartage) (p2p, pour _Peer to Peer_) _Crest Auto Partage_, sur la [base de ce tableur](https://acloud9.zaclys.com/index.php/s/wDZSdjXsR7Tw3y4) créé par Marie-Laetitia Melliand.\n\nL'intention de ce simulateur est d'évaluer les coûts kilométriques des véhicules proposés par les adhérent·es. La moyenne de ces coûts pourrait devenir le montant payé entre adhérent·es.\n\nÀ Crest, par exemple, le montant est 0,26€/km par défaut, et 0,32€/km pour les véhicules utilitaires/vans.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":7,"value":"md`## Votre véhicule\n\nPerte de valeur au fil du temps.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":231,"value":"viewof vehicule_year = Text({ label: \"Année d'achat\", type: 'text', pattern: '[0-9]{4}', required: true })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":241,"value":"viewof vehicule_initial_price = Text({ label: \"Prix d'achat (en €)\", type: \"number\", min: 0, required: true })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":246,"value":"html`

💡 Les informations suivantes sont à remplir avec la cote de votre véhicule.

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":257,"value":"viewof vehicule_cote_year = Text({ label: \"Année de simulation de la cote\", type: 'text', pattern: '[0-9]{4}', value: dateNow.getFullYear(), required: true })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":278,"value":"viewof vehicule_cote_price = Text({ label: \"Prix actuel (en €)\", type: \"number\", min: 0, required: true })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":285,"value":"md`**Montant de la décote** : ${vehicule_decote ? `${vehicule_decote}€` : \"N/C\"}.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":310,"value":"md`**Nombre d'années depuis l'achat** : ${vehicule_decote_annees ? `${vehicule_decote_annees} ans` : \"N/C\"}.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":249,"value":"md`**Décote lissée annuelle** : ${vehicule_moyenne_decote ? `${vehicule_moyenne_decote}€` : \"N/C\"}.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4,"value":"md`## Entretien, réparation, pièces et accessoires\n\nEntre ${dateMin.toLocaleString('fr', {\n month: \"long\",\n year: \"numeric\"\n})} et aujourd'hui.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":24,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":69,"value":"viewof add_entretien = html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":728,"value":"md`**Total des dépenses** : ${vehicule_depenses_entretien ? `${vehicule_depenses_entretien}€` : \"N/C\"}.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":11,"value":"md`## Carburant et lubrifiants`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":337,"value":"viewof vehicule_initial_kilometers = Text({ label: `Kilomètres au compteur (${vehicule_year ? vehicule_year : 'lors de l\\'achat'})`, type: 'number', step: 10000, min: 0, required: true })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":342,"value":"viewof vehicule_kilometers = Text({ label: `Kilomètres au compteur (${vehicule_cote_year})`, type: 'number', min: 0, step: 10000, required: true })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":373,"value":"viewof vehicule_consommation = Range([0, 20], { label: \"Consommation de carburant (en litres pour 100km)\", step: 0.5, min: 0, required: true, value: 5 })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":408,"value":"viewof vehicule_motorisation = Select([\"essence\", \"diésel\", \"GPLc\"], { label: \"Motorisation du véhicule\", required: true })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":357,"value":"md`**Kilomètres parcourus** : ${vehicule_kilometres_parcourus ? `${vehicule_kilometres_parcourus}km en ${vehicule_decote_annees} ans, soit ${vehicule_moyenne_kilometres}km par an, en moyenne` : \"N/C\"}.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":377,"value":"md`**Coût annuel** : ${vehicule_moyenne_carburant ? `${vehicule_moyenne_carburant}€ de carburant par an, en moyenne` : \"N/C\"}.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":13,"value":"md`## Assurance`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":486,"value":"viewof assurance_n3 = Text({ label: `Assurance en ${y3.getFullYear()}`, type: \"number\", min: 0, step: 100, required: true })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":516,"value":"viewof assurance_n2 = Text({ label: `Assurance en ${y2.getFullYear()}`, type: \"number\", min: 0, step: 100, required: true })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":520,"value":"viewof assurance_n1 = Text({ label: `Assurance en ${y1.getFullYear()}`, type: \"number\", min: 0, step: 100, required: true })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":543,"value":"md`**Coût annuel** : ${vehicule_moyenne_assurance ? `${vehicule_moyenne_assurance}€ par an, en moyenne` : \"N/C\"}.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":15,"value":"md`# Synthèse du coût kilométrique`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":552,"value":"md`\n- **Décote** : ${vehicule_moyenne_decote}€/an\n- **Assurance** : ${vehicule_moyenne_assurance}€/an\n- **Carburant** : ${vehicule_moyenne_carburant}€/an\n- **Entretien** : ${vehicule_moyenne_entretien}€/an\n\nL'utilisation de votre véhicule vous coûte **${vehicule_moyenne_annuelle}€ par an**, soit **${prix_par_kilometre}€ par kilomètre**.\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":630,"value":"vegalite({\n data: { values: [\n { label: \"Entretien\", value: vehicule_moyenne_entretien },\n { label: \"Assurance\", value: vehicule_moyenne_assurance },\n { label: \"Décote\", value: vehicule_moyenne_decote },\n { label: \"Carburant\", value: vehicule_moyenne_carburant }\n ] },\n mark: {\n type: \"arc\",\n radius: 70,\n radius2: 90,\n padAngle: 0.03\n },\n autosize: \"fit\",\n width: width * 0.6,\n encoding: {\n theta: { field: \"value\", type: \"quantitative\"},\n color: { field: \"label\", type: \"nominal\", title: \"Postes de dépenses\" }\n }\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":191,"value":"md`# Annexes`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1012,"value":"// TTC, vus sur https://www.ecologie.gouv.fr/prix-des-produits-petroliers#scroll-nav__5\nmoyenne_carburants = {\n return {\n 'essence': {\n 2011: 1.500,\n 2012: 1.566,\n 2013: 1.537,\n 2014: 1.485,\n 2015: 1.353,\n 2016: 1.304,\n 2017: 1.377,\n 2018: 1.505,\n 2019: 1.507,\n 2020: 1.355,\n 2021: 1.441,\n },\n 'diésel': {\n 2011: 1.335,\n 2012: 1.396,\n 2013: 1.350,\n 2014: 1.286,\n 2015: 1.149,\n 2016: 1.105,\n 2017: 1.233,\n 2018: 1.437,\n 2019: 1.440,\n 2020: 1.260,\n 2021: 1.333,\n },\n 'GPLc': {\n 2011: 0.854,\n 2012: 0.882,\n 2013: 0.873,\n 2014: 0.856,\n 2015: 0.787,\n 2016: 0.709,\n 2017: 0.742,\n 2018: 0.821,\n 2019: 0.856,\n 2020: 0.845,\n 2021: 0.836,\n }\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":193,"value":"dateMin = {\n const date = new Date()\n date.setFullYear(date.getFullYear() - 3)\n date.setMonth(0)\n date.setDate(1)\n date.setHours(0)\n date.setMinutes(0)\n date.setSeconds(0)\n\n return date\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":269,"value":"dateNow = new Date()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":490,"value":"y3 = {\n const date = new Date(dateNow)\n date.setFullYear(dateNow.getFullYear() - 3)\n return date\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":502,"value":"y2 = {\n const date = new Date(dateNow)\n date.setFullYear(dateNow.getFullYear() - 2)\n return date\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":506,"value":"y1 = {\n const date = new Date(dateNow)\n date.setFullYear(dateNow.getFullYear() - 1)\n return date\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":23,"value":"mutable entretiens_data = []","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":730,"value":"vehicule_depenses_entretien = {\n entretiens_html;\n \n return entretiens_data.reduce((sum, d) => sum + d.prix, 0)\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":302,"value":"vehicule_decote = Math.round(parseFloat(vehicule_initial_price) - parseFloat(vehicule_cote_price))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":304,"value":"vehicule_decote_annees = Math.ceil(parseInt(vehicule_cote_year, 10) - parseInt(vehicule_year, 10))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":562,"value":"vehicule_moyenne_decote = Math.ceil(vehicule_decote / vehicule_decote_annees)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":353,"value":"vehicule_kilometres_parcourus = Math.ceil(parseInt(vehicule_kilometers, 10) - parseInt(vehicule_initial_kilometers, 10))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":471,"value":"vehicule_moyenne_kilometres = Math.ceil(vehicule_kilometres_parcourus / vehicule_decote_annees)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1070,"value":"carburant_moyenne = {\n vehicule_decote_annees;\n vehicule_moyenne_kilometres;\n \n const YEARS_ROLLBACK = 5\n \n return Object.entries(moyenne_carburants[vehicule_motorisation]).slice(YEARS_ROLLBACK * -1).map(([year, price]) => price).reduce((total, price) => total + price, 0) / YEARS_ROLLBACK\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":461,"value":"vehicule_moyenne_carburant = Math.ceil(vehicule_moyenne_kilometres / 100 * vehicule_consommation * carburant_moyenne)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":526,"value":"vehicule_moyenne_assurance = Math.ceil([assurance_n1, assurance_n2, assurance_n3].reduce((sum, n) => sum + (parseFloat(n) ?? 0), 0) / 3)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":573,"value":"vehicule_moyenne_annuelle = vehicule_moyenne_kilometres + vehicule_moyenne_carburant + vehicule_moyenne_assurance + vehicule_moyenne_entretien","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":733,"value":"vehicule_moyenne_entretien = Math.ceil(vehicule_depenses_entretien / vehicule_decote_annees)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":578,"value":"prix_par_kilometre = (vehicule_moyenne_annuelle / vehicule_moyenne_kilometres).toFixed(2)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":26,"value":"import {Button, Range, Select, Text, Textarea, html} from \"@observablehq/inputs\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":610,"value":"vegalite = require('@observablehq/vega-lite@0.3')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":668,"value":"function guessValue(val) {\n let newValue = val\n \n if (!isNaN(val)) {\n newValue = parseFloat(val)\n }\n \n return newValue\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":852,"value":"html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W33","stdlib":"1"}} 31:"$30:body"