3f:null 40:["$","title",null,{"children":"KalibreringQuick3 | Christer Nilsson | Observable"}] 46:T588,{ // Javascript ass(24.5, anomaly(24.5)) ass("24.0", anomaly(24)) ass(21,myMod(-99, 60)) ass(-39,-99 % 60) ass(5,2+3) ass(true, 3 in {2:4, 3:5}) ass(true, 3 in [12,13,14,15]) ass(true, [12,13,14,15].includes(13)) ass([1,4,9], [1,2,3].map(x => x * x)) ass([1,3], [1,2,3].filter(x => x % 2 == 1)) ass(["2","3"], _.keys({2:4, 3:5})) ass(["0","1","2"], _.keys([11,12,13])) // Lodash ass(true, _.includes([12,13,14,15], 13)) ass([4,5], _.values({2:4, 3:5})) ass([0,1,2], _.range(3)) ass([10,11,12], _.range(10,13)) ass([13,12,11], _.range(13,10)) ass([1,3,5,7,9], _.range(1,11,2)) // Funktioner skapade i detta projekt ass( 90,ConvertToMinutes( 130)) ass(600,ConvertToMinutes(1000)) ass('koll', ModeHierarchy(['tåg','bil'])) ass('bil', ModeHierarchy(['bil','pass'])) ass('cykel',ModeHierarchy(['cykel','gång'])) ass('koll', ModeRecoded('tåg')) ass('koll', ModeRecoded('tbana')) ass('cykel',ModeRecoded('cykel')) ass('gång', ModeRecoded('gång')) const actual0 = makeMonoton([{A_KL:1930, B_KL:2000}, {A_KL:2030, B_KL:2330}]) const expect0 = [{A_KL:1930, B_KL:2000}, {A_KL:2030, B_KL:2330}] ass(expect0, actual0) const actual1 = makeMonoton([{A_KL:1930, B_KL:2000}, {A_KL:2030, B_KL:200}]) const expect1 = [{A_KL:1930, B_KL:2000}] //ass(expect1, actual1) return ready('Alla tester ok!') }47:T63a,function CreateDiary(trip_list) { if (trip_list.length == 0) return [] let idx = 1 let tour = 1 let day_type = trip_list[0].a_p + '->' + _.last(trip_list).b_p //log(day_type) // create a morning activity, wherever the person starts their morning (usually at home, sometimes somewhere else) const at_home_morning = { A_SAMS: trip_list[0].A_SAMS, B_SAMS: trip_list[0].B_SAMS, frd: 'aktivitet', are: trip_list[0].a_p, tour, act: idx, day_type: day_type, A_KL: trip_list[0].A_KL, B_KL: trip_list[0].B_KL, end_tour: '', } const activities = [] activities.push(at_home_morning) for (const row of trip_list) { const trip_start = row.A_KL const trip_end = row.B_KL const act_start = trip_end activities[idx - 1].B_KL = trip_start // Identify trips that end up at home let are = row.are let end_tour = false if (row.b_p == 'bostad') { are = 'bostad' end_tour = true } // Add the trip to the diary const trip = { A_SAMS: row.A_SAMS, B_SAMS: row.B_SAMS, frd: row.frd, are, tour, act: idx + 1, day_type: day_type, A_KL: trip_start, B_KL: trip_end, end_tour, } activities.push(trip) idx += 1 // Add the next activity to the diary const act = { A_SAMS: row.A_SAMS, B_SAMS: row.B_SAMS, frd: 'aktivitet', are, tour, act: idx + 1, day_type, A_KL: act_start, B_KL: act_start, end_tour, } activities.push(act) idx += 1 if (end_tour) tour += 1 } for (const a of activities) a.dur = ConvertToMinutes(a.B_KL) - ConvertToMinutes(a.A_KL) return activities }48:Taf1,function TourProperties(UENR,DAG,weight,tour_diary) { //const all_activities = _.filter(tour_diary, r => r.frd == 'aktivitet') const activities = _.filter(tour_diary, r => r.frd == 'aktivitet' && r.are != 'bostad') const trips = _.filter(tour_diary, r => r.frd != 'aktivitet') let {tour, A_SAMS, B_SAMS} = trips[0] const result = _.map(trips, r => r.frd) const frd = ModeHierarchy(result) for (const trip of trips) trip.frd = ModeRecoded(trip.frd) const mainmode_trips = _.filter(trips, r => r.frd == frd) const main_zone = _.filter(tour_diary, r => r.are != 'bostad') let zone = 0 if (main_zone.length != 0) { zone = _.maxBy(main_zone, item => item.dur) } else { zone = _.maxBy(tour_diary, item => item.dur) } //log('xTourProps',UENR,trips[0]) if (zone) B_SAMS = zone.B_SAMS // Turer som inte har någon aktivitet definieras som rundturer. if (activities.length == 0) { const dur = _.sumBy(trips, trip => trip.dur) return { UENR, DAG, tour, purpose:trips[0].are + "_rundtur", mode:frd, weight:anomaly(weight), Adur:dur, Mdur:dur, zoneA:trips[0].A_SAMS, zoneB:trips[0].B_SAMS, parts:2 } // Annars är det en tur med ett ärende } else { // let act = _.find(activities, a => a.are == 'Arbete') // if (!act) act = _.find(activities, a => a.are == 'Tjänste') // if (!act) act = _.maxBy(activities, item => item.dur) // if (!act) log('act',act) // const are = act.are // B_SAMS = act.B_SAMS let are = 0 const actList = _.map(activities, a => a.are) if (_.includes(actList,'Arbete')) { // Ifall det finns ett arbete-ärende i turen sätts ärendet till det are = 'Arbete' B_SAMS = _.filter(activities, a => a.are == 'Arbete')[0].B_SAMS } else if (_.includes(actList, 'Tjänste') ) { // Ifall det finns ett tjänste-ärende i turen sätts ärendet till det are = 'Tjänste' B_SAMS = _.filter(activities, a => a.are == 'Tjänste')[0].B_SAMS } else { // Annars välj den längsta aktiviteten som ärende //log('activities',UENR,activities) const main_activity = _.maxBy(activities, item => item.dur) //log('main_activity',main_activity) are = main_activity.are } // När vi bestämt huvudärende så använder vi alla de aktiviteterna const acts = _.filter(activities, a => a.are == are) const Adur = _.sumBy(acts, a => a.dur) const Mdur = _.sumBy(mainmode_trips, t => t.dur) //const split_act = acts.length > 1 const parts = _.last(tour_diary)['end_tour'] ? 2 : 1 return { UENR, DAG, tour, purpose:are, mode:frd, weight:anomaly(weight), Adur, Mdur, zoneA:A_SAMS, zoneB:B_SAMS, parts } } } 49:T444,xxx_datastruktur = (rvu) => { // infogar indata, diary och utdata i UENR-gruppen // for (const uenr in rvu) { // const group = rvu[uenr] // const x = group[0] // rvu[uenr] = {UENR: uenr, BOSAMS:x.BOSAMS,DAG: x.DAG, VIKT:x.VIKT, LAN:x.LAN, region:x.region, indata:[]} // const indata = [] // for (const r of group) { // indata.push({A_SAMS:r.A_SAMS, B_SAMS:r.B_SAMS, FRD:r.FRD, frd:r.frd,ARE:r.ARE, are:r.are, A_P:r.A_P, B_P:r.B_P, a_p:r.a_p, b_p:r.b_p, A_KL:r.A_KL,B_KL:r.B_KL }) // } // rvu[uenr].indata = makeMonoton(indata) // rvu[uenr].diary = CreateDiary(rvu[uenr].indata) // const lista = ['bostad->bostad', 'bostad->annat', 'bostad->bostad_ovr','bostad->bostad_fri'] // const J = _.filter(rvu[uenr].diary, r => _.includes(lista,r.day_type)) // homebased_diaries // const result = [] // if (J.length > 0) { // const rvuK = _.groupBy(J, 'tour') // const keys = _.keys(rvuK) // for (const key of keys) { // result.push(TourProperties(uenr,rvuK[key])) // } // } // rvu[uenr].utdata = result // } // return rvu }4a:[{"id":"4fb82bcdaf09f6d01b2a36cd1efc41ec1ece0df2a20c6368ad7abf4d53be357af1789630c28b9a4ef7881ab471cdbbde5b27615498aa2199707d1a94970a3119","href":"https://static.observableusercontent.com/files/4fb82bcdaf09f6d01b2a36cd1efc41ec1ece0df2a20c6368ad7abf4d53be357af1789630c28b9a4ef7881ab471cdbbde5b27615498aa2199707d1a94970a3119","name":"arbete_kod@1.txt","type":"text/plain","lastModified":1632644459164.697,"size":397},{"id":"6a373f5a964aec9ac1eb85b16eda4d4359980bcd857a01dbc565cdfc7ebf1f87dcb3a513d1cac0f7dc5f640cca35d4f5eddabe5d08b56768d9202bde8e1d40e1","href":"https://static.observableusercontent.com/files/6a373f5a964aec9ac1eb85b16eda4d4359980bcd857a01dbc565cdfc7ebf1f87dcb3a513d1cac0f7dc5f640cca35d4f5eddabe5d08b56768d9202bde8e1d40e1","name":"plats_kod.txt","type":"text/plain","lastModified":1632847648015.735,"size":745},{"id":"f24882deecf61c12b0180181ba9a412149aa8729b4c4bd8bf4bb03d76aeeced0df2a81ba2a73809f843cbb4a7d2ec670efdf5e7f10e8d15cc7ff0ee6653a61c0","href":"https://static.observableusercontent.com/files/f24882deecf61c12b0180181ba9a412149aa8729b4c4bd8bf4bb03d76aeeced0df2a81ba2a73809f843cbb4a7d2ec670efdf5e7f10e8d15cc7ff0ee6653a61c0","name":"region_kod@1.txt","type":"text/plain","lastModified":1632644459164.697,"size":550},{"id":"6849104fd8797f18095326c80ddf4e54e0c88488fd3c43ba6f8cc5f51e35c12d2055425f3b0433ecb19ad1ef86c829668a552af9ffaa25816f725441ed019420","href":"https://static.observableusercontent.com/files/6849104fd8797f18095326c80ddf4e54e0c88488fd3c43ba6f8cc5f51e35c12d2055425f3b0433ecb19ad1ef86c829668a552af9ffaa25816f725441ed019420","name":"ärende_kod_gen.txt","type":"text/plain","lastModified":1632644459164.697,"size":1487},{"id":"9979eedb9df3633c261a5f9c708b49b157b4036bd23a9720f2c9f8c574a4f8c3f6902861f43fb381d22c089fab5748119a10d6c288a444ca379fe37d91e7e1e7","href":"https://static.observableusercontent.com/files/9979eedb9df3633c261a5f9c708b49b157b4036bd23a9720f2c9f8c574a4f8c3f6902861f43fb381d22c089fab5748119a10d6c288a444ca379fe37d91e7e1e7","name":"fm_kod.txt","type":"text/plain","lastModified":1632644459164.697,"size":1991}] 44:{"id":"2b4da5daa6fa220c","slug":"kalibreringquick3","title":"KalibreringQuick3","thumbnail":"82fdbe81c6854f9cdd5ef30c00bdc7049dd2b8c605885ea3ab6a321a9b2d5c8a","access_level":"public","create_time":"$D2021-09-26T08:20:59.164Z","update_time":"$D2021-10-09T10:13:24.876Z","view_time":null,"first_public_time":"$D2021-10-11T08:44:12.582Z","has_unpublished_edits":null,"fork":true,"stars":0,"starred":false,"owner":{"type":"team","id":"659fd7f611013617","login":"christer","name":"Christer Nilsson","avatar_url":"https://avatars-next.observableusercontent.com/c3fd5a76e5501992696ee13260dad974a88ce0d5a3ac8fe0c2d86f37aad3ffe7","tier":"starter_2024","bio":"","following":false},"version":4953,"publish_version":4953,"role":null,"authored":false,"authors":[{"type":"individual","id":"30a88464ee755d2f","login":"christer","name":"Christer Nilsson","avatar_url":"https://avatars-next.observableusercontent.com/c3fd5a76e5501992696ee13260dad974a88ce0d5a3ac8fe0c2d86f37aad3ffe7","tier":null,"bio":"","following":false}],"members":[{"type":"individual","id":"30a88464ee755d2f","login":"christer","name":"Christer Nilsson","avatar_url":"https://avatars-next.observableusercontent.com/c3fd5a76e5501992696ee13260dad974a88ce0d5a3ac8fe0c2d86f37aad3ffe7","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":null,"type":"notebook","body":{"titling":"auto","title":"KalibreringQuick3","cells":[{"id":0,"value":"md`# KalibreringQuick3\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2187,"value":"$46","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3624,"value":"md`## 1 Välj fil`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1233,"value":"md`\nVälj t ex en fil med namnet rvu_121400_15.csv. 121400 rader, 15 kolumner\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":6,"value":"viewof mddr = html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4643,"value":"md`## 2 Välj en eller flera veckodagar`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3923,"value":"viewof day1 = Inputs.select([1,2,3,4,5,6,7], {value:1, multiple: false, label: \"Första dag\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3928,"value":"viewof day2 = Inputs.select([1,2,3,4,5,6,7], {value:7, multiple: false, label: \"Sista dag\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4646,"value":"md`## 3 Välj Sverige eller ett län`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3941,"value":"viewof lan = Inputs.select([0,1,3,4,5,6,7,8,9,10,12,13,14,17,18,19,20,21,22,23,24,25], {multiple: false, label: \"Län\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4648,"value":"md`## 4 Inspektera några UENR`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3813,"value":"viewof index = Inputs.range([0, UEnumbers.length-1], {value: 0, step: 1, label: \"UENR\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4650,"value":"md`## 5 Ladda ner utdatafil`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3437,"value":"to_csv = {\n let utdata = _.flatten(_.map(UEnumbers,uenr => tour[uenr]))\n //utdata = Z.dropCol(\"parent\",utdata)\n return DOM.download(serialize(d3.csvFormat(utdata) + \"\\n\"), `rvu_${_.size(utdata)}_${_.size(utdata[0])}.csv`, \"Download\")\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3877,"value":"md`### UENR ${uenr}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3886,"value":"Inputs.table([common[uenr]],format)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3857,"value":"md`### indata ${_.size(indata[uenr])}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3763,"value":"Inputs.table(indata[uenr], format)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4910,"value":"md`### diary`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4907,"value":"Inputs.table(diary[uenr], format)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3860,"value":"md`### diary (activities)`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3774,"value":"//Inputs.table(diary[uenr], format)\nInputs.table(_.filter(diary[uenr], r => r.are != 'bostad' && r.frd == 'aktivitet'), format)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4844,"value":"md`### diary (trips)`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4840,"value":"Inputs.table(_.filter(diary[uenr], r => r.frd != 'aktivitet'), format)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3863,"value":"md`### utdata ${_.size(tour[uenr])}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3758,"value":"Inputs.table(tour[uenr], format)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4797,"value":"cleanNaN = (rvu) => {\n for (const row of rvu) {\n //log(row.UENR)\n for (const key in row) {\n if (['VIKT'].includes(key))\n row[key] = _.round(row[key], 3)\n else\n row[key] = _.isNaN(row[key]) ? UNKNOWN : _.round(row[key])\n }\n }\n return rvu\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2945,"value":"rvuA = {\n log('')\n\n const names = \"UENR,UEDAG,VIKT_DAG,BOST_S,D_A_S,D_B_S,D_FORD,D_ARE,D_A_PKT,D_B_PKT,D_A_KL,D_B_KL,BOST_LAN,D_A_SVE,D_B_SVE\".split(',')\n const COLS0 = 'UENR,UEDAG,VIKT_DAG,BOST_S,D_A_S,D_B_S,D_FORD,D_ARE,D_A_PKT,D_B_PKT,D_A_KL,D_B_KL,BOST_LAN,D_A_SVE,D_B_SVE'.split(',')\n const COLS1 = 'UENR,DAG,VIKT,BOSAMS,A_SAMS,B_SAMS,FRD,ARE,A_P,B_P,A_KL,B_KL,LAN,A_SVE,B_SVE'.split(',')\n \n const trans = {}\n for (const i in _.range(COLS1.length)) {\n const name0 = COLS0[i]\n const name1 = COLS1[i]\n trans[name1] = names.indexOf(name0)\n }\n //log(trans)\n \n const start = Date.now()\n const buffer = await Files.text(mddr)\n const lines = buffer.split('\\n')\n const result = []\n for (const line of lines.slice(1)) {\n if (line.length < 10) continue\n let r = line.split(',')\n const obj1 = {}\n for (const key in trans) obj1[key] = +r[trans[key]]\n obj1.VIKT = _.round(+obj1.VIKT,3)\n result.push(obj1)\n }\n \n log('rvuA',Date.now()-start)\n return result\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4224,"value":"rvuA2 = {\n const start = Date.now()\n let result = _.filter(rvuA, (r) => r.A_SVE == 1 && r.B_SVE == 1 && day1 <= r.DAG && r.DAG <= day2)\n result = cleanNaN(result)\n if (lan > 0) result = _.filter(result, (r) => lan == r.LAN)\n result = _.filter(result, r => ! (r.A_P==1 && r.B_P==1 || r.A_P==2 && r.B_P==2 || r.A_P==3 && r.B_P==3))\n result = fixLookups(result)\n log('rvuA2',Date.now() - start)\n return result\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3729,"value":"UEnumbers = _.keys(common)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3817,"value":"uenr = UEnumbers[index]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4235,"value":"common = {\n const start = Date.now()\n const result = {}\n\n for (const r of rvuA2) {\n if (result[r.UENR]) continue\n result[r.UENR] = {BOSAMS:r.BOSAMS, DAG:r.DAG, LAN:r.LAN, region:r.region, VIKT:r.VIKT}\n }\n\n log('common', Date.now()-start)\n return result\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4232,"value":"indata = {\n const start = Date.now()\n const result = {}\n for (const r of rvuA2) {\n result[r.UENR] = result[r.UENR] || []\n result[r.UENR].push({A_SAMS:r.A_SAMS, B_SAMS:r.B_SAMS, FRD:r.FRD, frd:r.frd, ARE:r.ARE, are:r.are, A_P:r.A_P, a_p:r.a_p, B_P:r.B_P, b_p:r.b_p, A_KL:r.A_KL, B_KL:r.B_KL})\n }\n log('indata',Date.now()-start) \n return result\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4283,"value":"diary = {\n const start = Date.now()\n const result = {}\n for (const uenr in indata) {\n result[uenr] = makeMonoton(indata[uenr])\n result[uenr] = CreateDiary(result[uenr])\n }\n log('diary',Date.now()-start) \n return result\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4299,"value":"tour = {\n const start = new Date()\n const result = {}\n for (const uenr in diary) {\n \t\tconst lista = ['bostad->bostad', 'bostad->annat', 'bostad->bostad_ovr','bostad->bostad_fri']\n\t\tconst J = _.filter(diary[uenr], r => _.includes(lista,r.day_type)) \n result[uenr] = []\n if (J.length == 0) continue\n const groups = _.groupBy(J, 'tour')\n const {DAG,VIKT} = common[uenr]\n result[uenr] = _.map(groups, group => TourProperties(uenr, DAG, VIKT, group))\n }\n log('tour',Date.now()-start) \n return result\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4824,"value":"_.size(diary)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4812,"value":"nop = (x) => x","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4556,"value":"format = ({rows:25, layout:'auto', format: {UENR:nop, BOSAMS:nop, A_SAMS:nop, B_SAMS:nop, A_KL:nop, B_KL:nop, zoneA:nop, zoneB:nop, dur:nop, Adur:nop, Mdur:nop}})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3062,"value":"UNKNOWN = -99","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3300,"value":"md`### Koder`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2981,"value":"mode_codes = FileAttachment(\"fm_kod.txt\").tsv()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2988,"value":"place_codes = FileAttachment(\"plats_kod.txt\").tsv()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2984,"value":"purpose_codes = FileAttachment(\"ärende_kod_gen.txt\").tsv()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2992,"value":"region_codes = FileAttachment(\"region_kod@1.txt\").csv()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2995,"value":"work_codes = FileAttachment(\"arbete_kod@1.txt\").tsv()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3002,"value":"mode_lookup = _.zipObject(_.map(mode_codes,\"id\"), _.map(mode_codes,\"grp\"))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3012,"value":"place_lookup = _.zipObject(_.map(place_codes,\"id\"), _.map(place_codes,\"plats\"))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3009,"value":"purpose_lookup = _.zipObject(_.map(purpose_codes,\"id\"), _.map(purpose_codes,\"grp\"))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3017,"value":"region_lookup = _.zipObject(_.map(region_codes,\"lkod\"), _.map(region_codes,\"region\"))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3020,"value":"work_lookup = _.zipObject(_.map(work_codes,\"kod\"), _.map(work_codes,\"status\"))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":144,"value":"md`## Funktioner`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4926,"value":"anomaly = (x) => Math.floor(x) == x ? x + \".0\" : x // pga python 24 => 24.0 ","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4536,"value":"// function ConvertToMinutes(t) { \n// \tif (t == UNKNOWN) return UNKNOWN\n// \tconst hour = Math.floor(t / 100)\n// \tconst minute = t % 100\n// \treturn 60 * hour + minute\n// }\n\nfunction ConvertToMinutes(t) {\n\tif ((t < 2400) && (t != 99)) {\n const hour = Math.floor(t / 100)\n const minute = myMod(t, 100)\n return 60 * hour + minute\n } else {\n return -99\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4547,"value":"$47","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4553,"value":"fixLookups = (dr) => {\n for (const uenr in dr) {\n const row = dr[uenr]\n row.frd = mode_lookup[row.FRD]\n row.are = purpose_lookup[row.ARE]\n row.a_p = place_lookup[row.A_P]\n row.b_p = place_lookup[row.B_P]\n let lan = row.LAN\n if (lan<10) lan = \"0\" + lan\n row.region = region_lookup[lan]\n }\n return dr\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1496,"value":"log = console.log","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4532,"value":"function makeMonoton(group) { // Ser till att klockslagen stiger monotont. Klipper efter 24 timmar\n return group\n \n\tlet klock = 0\n\tconst result = []\n\tfor (const row of group) {\n\t\twhile (row.A_KL < klock) row.A_KL += 2400\n\t\twhile (row.B_KL < row.A_KL) row.B_KL += 2400\n\t\tif (row.A_KL <= 2400 && row.B_KL <= 2400) result.push(row)\n\t\tklock = row.B_KL\n }\n\treturn result\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4540,"value":"function ModeHierarchy(modes) {\n\tif (modes.includes('tåg')) return 'koll'\n\telse if (modes.includes('tbana')) return 'koll'\n\telse if (modes.includes('spv')) return 'koll'\n\telse if (modes.includes('buss')) return 'koll'\n\telse if (modes.includes('bil')) return 'bil'\n\telse if (modes.includes('pass')) return 'pass'\n\telse if (modes.includes('cykel')) return 'cykel'\n\telse if (modes.includes('gång')) return 'gång'\n\telse return 'övrigt'\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4544,"value":"function ModeRecoded(mode) {\n\tif (mode == 'tåg') return 'koll'\n\telse if (mode == 'tbana')\treturn 'koll'\n\telse if (mode == 'spv')\treturn 'koll'\n\telse if (mode == 'buss') return 'koll'\n\telse if (mode == 'bil')\treturn 'bil'\n\telse if (mode == 'pass') return 'pass'\n\telse if (mode == 'cykel')\treturn 'cykel'\n\telse if (mode == 'gång') return 'gång'\n\telse return 'övrigt'\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4948,"value":"myMod = (x,y) => x % y < 0 ? x % y + y : x % y","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":234,"value":"serialize = (data) => new Blob([data], {type: \"text\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4550,"value":"$48","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4592,"value":"md`### Funktioner ur funktion`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1115,"value":"xxx_fetchCol = 0 //R.curry((nameIn, nameOut, rvu, rvuNew) => Z.addCol(nameOut,NA2NegOne(Z.getCol(nameIn,rvu)),rvuNew))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4449,"value":"xxx_fetchColumns = (dr) => {\n// const res = new Array(dr.length)\n// res.fill({})\n// return Z.pipe([\n// fetchCol('UENR','UENR',dr),\n// fetchCol('UEDAG','DAG',dr),\n// fetchCol('VIKT_DAG','VIKT',dr),\n// fetchCol('BOST_S','BOSAMS',dr),\n \n// fetchCol('D_A_S','A_SAMS',dr),\n// fetchCol('D_B_S','B_SAMS',dr),\n// fetchCol('D_FORD','FRD',dr),\n// fetchCol('D_ARE','ARE',dr),\n \n// fetchCol('D_A_PKT','A_P',dr),\n// fetchCol('D_B_PKT','B_P',dr),\n// fetchCol('D_A_KL','A_KL',dr),\n// fetchCol('D_B_KL','B_KL',dr),\n \n// fetchCol('BOST_LAN','LAN',dr),\n// fetchCol('D_A_SVE','A_SVE',dr),\n// fetchCol('D_B_SVE','B_SVE',dr),\n// ])(res) \n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2112,"value":"xxx_fixedCol = R.curry((value, nameOut, n, rvuNew) => Z.addCol(nameOut,new Array(n).fill(value),rvuNew))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1356,"value":"xxx_minutes = (hhmm) => 60 * Math.floor(hhmm/100) + hhmm % 100 ","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1117,"value":"xxx_NA2NegOne = (col) => col.map(x => x=='NA' ? -1 : x)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2752,"value":"xxx_roundTrip = (r) => r.SP == 1 && r.MP == 1 && r.S_SAMS == r.M_SAMS","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4573,"value":"xxx_renameCols = R.curry((mapper, df) => {// 5548 ms\n return df.map((row) => {\n R.keys(mapper).forEach(key => {\n row[mapper[key]] = row[key]\n row = R.dissoc(key, row)\n });\n return row\n });\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4577,"value":"xxx_removeBadGroups = (groups) => {\n// \tconst result = {}\n// \tfor (const uenr in groups) {\n// \t\tconst group = groups[uenr]\n// \t\tconst bad1 = _.filter(group, r => r.A_KL < 0 || r.B_KL < 0)\n// \t\tconst bad2 = _.filter(group, r => r.A_SAMS < 0 || r.B_SAMS < 0 || r.A_SAMS == 'NA' || r.B_SAMS == 'NA')\n// \t\tconst bad3 = _.filter(group, r => r.ARE == 'NA' || r.ARE < 0)\n \n// \t\tif (bad1.length == 0 && bad2.length == 0 && bad3.length == 0) result[uenr] = group\n// }\n// \treturn result\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4581,"value":"$49","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":141,"value":"md`## Externa funktioner`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4,"value":"d3 = require('d3@5')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1105,"value":"R = require('ramda')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":170,"value":"Z = require('zebras')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1996,"value":"import {addCols, ass, clone, diff,digits, extract, group, ready, setCol, setColi} from \"@christer/utils\" ","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W4a","stdlib":"1"}} 45:"$44:body"