25:["$","title",null,{"children":"Arcade | BMT Teams | Observable"}] 49:[{"id":"e7315930771b00435c832993a425835d4840940cda13fe89d3d5cc7a6e5a51cd7ecf3568a3f083eb3dc4259f6c052eb806b98a28ad77ef7417009f39581e7d11","href":"https://static.observableusercontent.com/files/e7315930771b00435c832993a425835d4840940cda13fe89d3d5cc7a6e5a51cd7ecf3568a3f083eb3dc4259f6c052eb806b98a28ad77ef7417009f39581e7d11","name":"transaction_export_Arcade_2024-09-05-02-08-55.json","type":"application/json","lastModified":1725503606822.845,"size":122304}] 29:{"id":"4442f7ef1f09e0d3","slug":null,"title":"Arcade","thumbnail":"49e3b8e7b5c25c76853ac31b4ed41e895e2facb91573182f4e68e995d0ccb899","access_level":"public","create_time":"$D2024-09-05T02:32:18.849Z","update_time":"$D2024-09-05T09:55:34.825Z","view_time":null,"first_public_time":"$D2024-09-05T09:06:57.999Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"1c59379b4307da21","login":"bmt","name":"BMT Teams","avatar_url":null,"tier":"pro_2024","bio":"","followed_by_you":false,"follows_you":false},"version":103,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"9faaf2168ef63076","login":"soma","name":"Soma Maroju","avatar_url":null,"tier":null,"bio":"","followed_by_you":false,"follows_you":false}],"members":[{"type":"team","id":"1c59379b4307da21","login":"bmt","name":"BMT Teams","avatar_url":null,"tier":"pro_2024","role":"editor"},{"type":"individual","id":"9faaf2168ef63076","login":"soma","name":"Soma Maroju","avatar_url":null,"tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Arcade","cells":[{"id":0,"value":"# Arcade","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":53,"value":"Trying to find unique days in the data","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":9,"value":"transactionsDates = Array.from(d3.rollup(transactions, v => v[0], d => d.date).keys())\n .map(date => new Date(date))\n .sort((a, b) => a - b)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":55,"value":"Finding unique memos in the dataset.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":16,"value":"transactionsMemo = Array.from(d3.rollup(transactions, v => v[0], d => d.memo).keys())","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":57,"value":"Table of date, memo, amount in cents. Note that the comments and tags are empty.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":64,"value":"viewof search_transaction= Inputs.search(transactions_usd)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":22,"value":"search_transaction","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":79,"value":"grouped_transactions = d3.rollups(\n search_transaction,\n v => ({\n sum_usd: d3.sum(v, leaf => leaf.amount_usd),\n sum_cents: d3.sum(v, leaf => leaf.amount_cents)\n }),\n d => d.date,\n d => d.memo\n);","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":102,"value":"html`\n \n \n \n \n \n \n \n \n \n ${grouped_transactions.map(([date, memo, { sum_usd, sum_cents }]) => html`\n \n \n \n \n \n \n `)}\n \n

Date	Memo	Sum (USD)	Sum (Cents)
${date}	${memo}	${sum_usd}	${sum_cents}

`","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":59,"value":"Created a new column - amount in usd","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":35,"value":"transactions_usd = transactions.map((d) => ({\n ...d,\n amount_usd: Math.abs(d.amount_cents) / 100\n}))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":61,"value":"The chart can be improved. It can be broken down by category by cleaning the memo. For example, There are several amazon related memos. Maybe they can be consolidated.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":29,"value":"Plot.plot({\n marks: [\n Plot.cell(\n transactions_usd,\n Plot.group(\n {\n fill: \"sum\"\n },\n {\n fill: \"amount_usd\",\n y: \"memo\",\n x: (d) => new Date(d.date)\n }\n )\n )\n ],\n marginLeft: 300,\n width: 1040,\n height: 5000\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5,"value":"transactions = FileAttachment(\n \"transaction_export_Arcade_2024-09-05-02-08-55.json\"\n).json()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W49","stdlib":"1"}} 24:null