2c:null 2d:["$","title",null,{"children":"Late Appointment % Calculator | Grad Div Research | Observable"}] 32:T435,function validateDates(s, e) { var valid = "false"; // translate into seconds since UNIX epoch for date comparisons var startdate = +doe( new Date(s.slice(0, 4), +s.slice(5, 7) - 1, s.slice(8, 10)) ); var enddate = +doe( new Date(e.slice(0, 4), +e.slice(5, 7) - 1, e.slice(8, 10)) ); var startterm = +doe( new Date( termstart_str.slice(0, 4), +termstart_str.slice(5, 7) - 1, termstart_str.slice(8, 10) ) ); var endterm = +doe( new Date( termend_str.slice(0, 4), +termend_str.slice(5, 7) - 1, termend_str.slice(8, 10) ) ); // business logic if (startdate >= enddate) { valid = "The start date must be earlier than the end date."; } else if (startdate > endterm && enddate > endterm) { valid = "The start and end dates must overlap the term start and term end dates."; } else if (enddate < startterm && startdate < startterm) { valid = "The start and end dates must overlap the term start and term end dates."; } else { valid = "true"; } return valid; }33:[] 30:{"id":"2324954ef1d60d21","slug":"late-appointment-calculator","title":"Late Appointment % Calculator","thumbnail":"84aa1ca3cfd7ba8ab14139e0202ea2f9fb26aa8041b81c2d458b4b76e5523369","access_level":"public","create_time":"$D2021-03-19T15:20:02.843Z","update_time":"$D2022-10-07T20:23:54.246Z","view_time":null,"first_public_time":"$D2021-03-19T21:20:45.062Z","has_unpublished_edits":null,"fork":true,"stars":0,"starred":false,"owner":{"type":"team","id":"57cec13df17cda62","login":"gradresearch","name":"Grad Div Research","avatar_url":"https://avatars-next.observableusercontent.com/648da64820b7b40a7ad33bdc825f4481fe5086724d98bbb941369de6bfad3e1e","tier":"education_2026","bio":"We are Institutional Research Analysts in the Graduate Division at UC Berkeley"},"version":816,"publish_version":816,"role":null,"authored":false,"authors":[{"type":"individual","id":"211f24df88ae4cd6","login":"saraquigley","name":"Sara Quigley","avatar_url":"https://avatars-next.observableusercontent.com/3bf6bb250428d139d5d072eaa766e992a5fb59c5f12a436ff6ece80fdaa5f395","tier":null,"bio":"UC Berkeley"}],"members":[{"type":"individual","id":"211f24df88ae4cd6","login":"saraquigley","name":"Sara Quigley","avatar_url":"https://avatars-next.observableusercontent.com/3bf6bb250428d139d5d072eaa766e992a5fb59c5f12a436ff6ece80fdaa5f395","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Late Appointment % Calculator","cells":[{"id":0,"value":"bannerTitleTwoLineq(\n \"Late Appointment %\",\n \"Calculator\",\n \"#2d637f\",\n \"#fcd57a\"\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":501,"value":"header = html`Late Appointment % Calculator`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":8,"value":"viewof term = Select(terms, {\n label: html`Choose a term `,\n format: (x) => x.name,\n value: terms.find((t) => t.name === \"Fall 2022\"),\n width: 110\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":380,"value":"viewof hint = html`Change the Start Date to reflect the actual hire date.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":72,"value":"viewof sem_eq_pct = Text({\n type: \"number\",\n label: html`Semester Equivalent % `,\n placeholder: \"e.g. 25\",\n width: 80\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":19,"value":"viewof d_start = Text({\n type: \"date\",\n label: html`Start Date `,\n value: terms.find(d => d.name === term.name).start_date,\n description: html`Change the start date to reflect the actual hire date.`,\n width: 150\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":21,"value":"viewof d_end = Text({\n type: \"date\",\n label: html`End Date `,\n value: terms.find(d => d.name === term.name).end_date,\n width: 150\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":82,"value":"viewof late_appt_result = html`Late Appointment % ${\n customRound == '0.00%'\n ? ''\n : helptext === \"true\"\n ? customRound +\n ' ← This is the percentage at which to hire.'\n : '' +\n helptext +\n ''\n} `","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":384,"value":"space = html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":166,"value":"html`(The actual calculation result is ${lateapptpct})`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":742,"value":"html`Documentation:

Update the cell called terms so that it contains relevant terms and start/end dates
The lateapptpct cell calculates the % based on the data entered.
The customRoundcell rounds up to the nearest ten-thousandth place e.g. 0.25284 rounds to 0.2529
Republish and changes, and choose Embed Cells to get the iframe code to embed in the Appointments Handbook page.

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":511,"value":"// embed code\n// html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":265,"value":"lateapptpct = sem_eq_pct * (termdays / apptdays) * 0.01","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":191,"value":"customRound = d3.format(\".2%\")(\n +d3.format(\".5\")(lateapptpct) > +d3.format(\".4\")(lateapptpct)\n ? +d3.format(\".4\")(lateapptpct) + 0.0001\n : +d3.format(\".4\")(lateapptpct)\n)\n// if x ? y : z","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":160,"value":"termdays = getWeekdayCount(termstart_str, termend_str)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":155,"value":"apptdays = {\n // if the appointment end date is later than the term end date, use the term end date\n return getWeekdayCount(\n apptstart < termstart ? termstart_str : d_start,\n apptend > termend ? termend_str : d_end\n );\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":644,"value":"apptstart = new Date(\n d_start.slice(0, 4),\n +d_start.slice(5, 7) - 1,\n d_start.slice(8, 10)\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":646,"value":"apptend = new Date(\n d_end.slice(0, 4),\n +d_end.slice(5, 7) - 1,\n d_end.slice(8, 10)\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":121,"value":"function getWeekdayCount(s, e) {\n var count = 0;\n\n var startdate = new Date(s.slice(0, 4), +s.slice(5, 7) - 1, s.slice(8, 10));\n var enddate = new Date(e.slice(0, 4), +e.slice(5, 7) - 1, e.slice(8, 10));\n var curDate = startdate;\n\n while (curDate <= enddate) {\n var dayOfWeek = +dow(curDate);\n if (!(dayOfWeek == 6 || dayOfWeek == 0)) {\n count++;\n }\n curDate.setDate(curDate.getDate() + 1);\n }\n return count;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":441,"value":"termstart = new Date(\n termstart_str.slice(0, 4),\n +termstart_str.slice(5, 7) - 1,\n termstart_str.slice(8, 10)\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":443,"value":"termend = new Date(\n termend_str.slice(0, 4),\n +termend_str.slice(5, 7) - 1,\n termend_str.slice(8, 10)\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":424,"value":"helptext = validateDates(d_start, d_end)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":420,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":41,"value":"term","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":128,"value":"// zero-based day of week see: https://github.com/d3/d3-time-format#locale_format\ndow = d3.timeFormat(\"%w\")\n// 0 = Sunday\n// 1 = Monday\n// 2 = Tuesday","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":539,"value":"// seconds since UNIX epoch\ndoe = d3.timeFormat(\"%s\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":710,"value":"termstart_str = terms.find(d => d.name === term.name).start_date","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":611,"value":"termend_str = terms.find(d => d.name === term.name).end_date","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":9,"value":"terms = [\n { name: \"Fall 2019\", start_date: \"2019-08-21\", end_date: \"2019-12-20\" },\n { name: \"Spring 2020\", start_date: \"2020-01-14\", end_date: \"2020-05-15\" },\n { name: \"Fall 2020\", start_date: \"2020-08-19\", end_date: \"2020-12-18\" },\n { name: \"Spring 2021\", start_date: \"2021-01-12\", end_date: \"2021-05-14\" },\n { name: \"Fall 2021\", start_date: \"2021-08-18\", end_date: \"2021-12-17\" },\n { name: \"Spring 2022\", start_date: \"2022-01-11\", end_date: \"2022-05-13\" },\n { name: \"Fall 2022\", start_date: \"2022-08-17\", end_date: \"2022-12-16\" },\n { name: \"Spring 2023\", start_date: \"2023-01-10\", end_date: \"2023-05-12\" },\n { name: \"Fall 2023\", start_date: \"2023-08-16\", end_date: \"2023-12-15\" },\n { name: \"Spring 2024\", start_date: \"2024-01-09\", end_date: \"2024-05-10\" },\n { name: \"Fall 2024\", start_date: \"2024-08-21\", end_date: \"2024-12-20\" },\n { name: \"Spring 2025\", start_date: \"2025-01-14\", end_date: \"2025-05-16\" }\n]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":211,"value":"bannerTitleTwoLineq = (\n title1,\n title2,\n backgroundColor = \"#c8d9dd\",\n textColor = \"#282b2c\",\n pageTitle = title1 + \" \" + title2\n) => {\n const { id, href } = DOM.uid(\"banner\");\n return html`\n

${pageTitle}

\n \n \n `;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":206,"value":"import { bannerTitleTwoLine } from \"@observablehq/banner\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5,"value":"import { Select } from \"@observablehq/inputs\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":69,"value":"import { Text } from \"@observablehq/inputs\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":17,"value":"// import { date } from \"@jashkenas/inputs\"\nimport { date } from \"@observablehq/legacy-inputs\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":93,"value":"d3 = require(\"d3@5\", \"d3-array@^2.2\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W33","stdlib":"1"}} 31:"$30:body"