2c:null 2d:["$","title",null,{"children":"Process raw SPARK data into reportable information | Jose Jimenez | Observable"}] 32:Tf99,observation_processed = { let processed = [] let ferpa_regex = new RegExp("FERPA Training",'gi') let hipaa_regex = new RegExp("HIPAA Privacy Trai",'gi') let security_regex = new RegExp("Security Awareness",'gi') observation_raw_json.forEach(row => { let initiator = parse_person(row['Initiator']) let participant = parse_person(row['Participant Name']) let [host_department_name, host_department_code] = row['Host Department'] ? row['Host Department'].split('\n') : ["",""] let host_contact = parse_person(row['Host Contact']) let ferpa = row['Fulfilled Compliances'].match(ferpa_regex) ? 'yes' : 'no' let hipaa = row['Fulfilled Compliances'].match(hipaa_regex) ? 'yes' : 'no' let security = row['Fulfilled Compliances'].match(security_regex) ? 'yes' : 'no' let reasons = row['What do you hope to gain from this observation? (Select no more than three)'].split('\n') let new_observation = { submission_date: new Date(Date.parse(row['Submission Date'])), initiator_display_name: initiator.display_name, initiator_university_id: initiator.university_id, initiator_title: initiator.title, initiator_job_code: initiator.job_code, initiator_staff_type: initiator.staff_type, initiator_department: initiator.department, initiator_email: initiator.email, initiator_address: initiator.address, initiator_phone: initiator.phone, participant_display_name: participant.display_name, participant_university_id: participant.university_id, participant_title: participant.title, participant_job_code: participant.job_code, participant_staff_type: participant.staff_type, participant_department: participant.department, participant_email: participant.email, participant_address: participant.address, participant_phone: participant.phone, host_department_name: host_department_name, host_department_code: host_department_code, host_display_name: host_contact.display_name, host_university_id: host_contact.university_id, host_title: host_contact.title, host_job_code: host_contact.job_code, host_staff_type: host_contact.staff_type, host_department: host_contact.department, host_email: host_contact.email, host_address: host_contact.address, host_phone: host_contact.phone, ferpa_completed: ferpa, hipaa_completed: hipaa, security_completed: security, supervisor_permission: row['I have obtained permission from my supervisor to pursue this experience'].match(/yes/i) ? 'yes' : 'no', multiple_days: row['The observation will span multiple days'].match(/yes/i) ? 'yes' : 'no', date_of_observation: row['Date of Observation'] ? new Date(Date.parse(row['Date of Observation'])) : null, start_date: row['Start Date'] ? new Date(Date.parse(row['Start Date'])) : null, end_date: row['End Date'] ? new Date(Date.parse(row['End Date'])) : null, effectiveness: reasons.some(row => row.match(/more effective/i)) ? 'yes' : 'no', skill_attainment: reasons.some(row => row.match(/Gain skills/i)) ? 'yes' : 'no', career_advancement: reasons.some(row => row.match(/Advance in my career/i)) ? 'yes' : 'no', build_network: reasons.some(row => row.match(/Build relationships/i)) ? 'yes' : 'no', managment_and_culture: reasons.some(row => row.match(/different management style/i)) ? 'yes' : 'no', new_perspective: reasons.some(row => row.match(/new and different perspective/i)) ? 'yes' : 'no', observe_future: reasons.some(row => row.match(/ole I see myself in/i)) ? 'yes' : 'no', share_specialty: reasons.some(row => row.match(/my own specialty/i)) ? 'yes' : 'no', personal_interest: reasons.some(row => row.match(/personal interest/i)) ? 'yes' : 'no', other: reasons.some(row => row.match(/Other/i)) ? 'yes' : 'no', } processed.push(new_observation) }) return processed }33:T514,reason_summary = { let summary = { effectiveness: 0, skill_attainment: 0, career_advancement: 0, build_network: 0, managment_and_culture: 0, new_perspective: 0, observe_future: 0, share_specialty: 0, personal_interest: 0, other: 0, } observation_processed.forEach(row => { summary.effectiveness += (row.effectiveness === 'yes' ? 1 : 0) summary.skill_attainment += (row.skill_attainment === 'yes' ? 1 : 0) summary.career_advancement += (row.career_advancement === 'yes' ? 1 : 0) summary.build_network += (row.build_network === 'yes' ? 1 : 0) summary.managment_and_culture += (row.managment_and_culture === 'yes' ? 1 : 0) summary.new_perspective += (row.new_perspective === 'yes' ? 1 : 0) summary.observe_future += (row.observe_future === 'yes' ? 1 : 0) summary.share_specialty += (row.share_specialty === 'yes' ? 1 : 0) summary.personal_interest += (row.personal_interest === 'yes' ? 1 : 0) summary.other += (row.other === 'yes' ? 1 : 0) }) let transpose = []; Object.keys(summary).forEach(reason => transpose.push({reason: reasons_mapped[reason], count: summary[reason]})) return transpose.sort((a,b) => (b.count > a.count ? 1 : -1)) }34:T80c,open_house_processed = { let open_houses = [] open_house_json.forEach(row => { let initiator = parse_person(row['Initiator']) let host_contact = parse_person(row['Name of Host (facilitator)']) let reasons = row['Are there other goals you are hoping to meet with this open house?'].split('\n') open_houses.push({ submission_date: new Date(Date.parse(row['Submission Date'])), initiator_display_name: initiator.display_name, initiator_university_id: initiator.university_id, initiator_title: initiator.title, initiator_job_code: initiator.job_code, initiator_staff_type: initiator.staff_type, initiator_department: initiator.department, initiator_email: initiator.email, initiator_address: initiator.address, initiator_phone: initiator.phone, host_display_name: host_contact.display_name, host_university_id: host_contact.university_id, host_title: host_contact.title, host_job_code: host_contact.job_code, host_staff_type: host_contact.staff_type, host_department: host_contact.department, host_email: host_contact.email, host_address: host_contact.address, host_phone: host_contact.phone, open_position: row['Do you currently have an open position that you are hoping to build interest in during this open house?'].match(/yes/i) ? 'yes' : 'no', many_requests: reasons.some(row => row.match(/many requests for information /i)) ? 'yes' : 'no', gaps_in_community: reasons.some(row => row.match(/gaps in the community/i)) ? 'yes' : 'no', remote_location: reasons.some(row => row.match(/remote physical location/i)) ? 'yes' : 'no', unique_job: reasons.some(row => row.match(/unique job functions/i)) ? 'yes' : 'no', best_practices: reasons.some(row => row.match(/best practices/i)) ? 'yes' : 'no', new_service: reasons.some(row => row.match(/new service or product/i)) ? 'yes' : 'no', other: reasons.some(row => row.match(/Other/i)) ? 'yes' : 'no', }) }) return open_houses }35:[] 30:{"id":"b5a9a18e3f2540c8","slug":"process-raw-spark-data-into-reportable-information","title":"Process raw SPARK data into reportable information","thumbnail":"38a048e42b5bd5fa11b2f70e39543e5247f05de3a8485712b903cbae11e70cc2","access_level":"public","create_time":"$D2020-02-27T22:53:23.617Z","update_time":"$D2022-06-01T15:11:50.496Z","view_time":null,"first_public_time":"$D2020-03-02T22:48:23.108Z","fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"11eff763c21b0530","login":"jjimenez","name":"Jose Jimenez","avatar_url":"https://avatars-next.observableusercontent.com/5d28ac3054c420a200dcd8a0bd3367e2263d2f168c4aa5eaa0c89640622d6088","tier":"starter_2024"},"version":697,"publish_version":697,"role":null,"authored":false,"authors":[{"type":"individual","id":"214adfe1a708eb31","login":"jjimenez","name":"Jose Jimenez","avatar_url":"https://avatars-next.observableusercontent.com/5d28ac3054c420a200dcd8a0bd3367e2263d2f168c4aa5eaa0c89640622d6088","tier":null}],"members":[{"type":"individual","id":"214adfe1a708eb31","login":"jjimenez","name":"Jose Jimenez","avatar_url":"https://avatars-next.observableusercontent.com/5d28ac3054c420a200dcd8a0bd3367e2263d2f168c4aa5eaa0c89640622d6088","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"title":"Process raw SPARK data into reportable information","cells":[{"id":0,"value":"md`# Process raw SPARK data into reportable information`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":12,"value":"md `## Raw Observation data`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":13,"value":"viewof observation_text = textarea({\n title: \"Copy all the contents of the exported data spreadsheet for Observations here\", \n placeholder: \"Just a copy and paste\", \n spellcheck: false,\n width: \"100%\",\n rows: 10,\n submit: \"Process\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":145,"value":"viewof open_house_text = textarea({\n title: \"Copy all the contents of the exported data spreadsheet for Open Houses here\", \n placeholder: \"Just a copy and paste\", \n spellcheck: false,\n width: \"100%\",\n rows: 10,\n submit: \"Process\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":307,"value":"viewof immersion_text = textarea({\n title: \"Copy all the contents of the spreadsheet for Immersions here\", \n placeholder: \"Just a copy and paste\", \n spellcheck: false,\n width: \"100%\",\n rows: 10,\n submit: \"Process\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":73,"value":"md `## Observation Metrics`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":100,"value":"md `### Observation ITS Units Represented: ${its_units.length}\n\n${its_units.join(', ')}\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":96,"value":"md `### Observation non-ITS Units Represented: ${non_its_units.length}\n\n${non_its_units.join(', ')}\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":117,"value":"md`### Number of OneIT Units participating in Observations: ${one_it_observation_units}\n\nwhich represents ${one_it_observation_units_percent}% of all OneIT units\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":123,"value":"md`### Total number of Observations: ${observation_processed.length}\n\n${unique_participant_names.length} unique participants\n\n${unique_host_names.length} unique host coordinators\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":110,"value":"md`### Observation Healthcare units Represented: ${healthcare_units.length}\n\n${healthcare_units.join(', ')}\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":191,"value":"md`### Reasons for participating in Observations`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":184,"value":"table(reason_summary)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":565,"value":"DOM.download(new Blob([d3.csvFormat(reason_summary)], {type: \"text/csv\"}), \"SPARK_Reasons.csv\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":603,"value":"md`### Narrative\n\n__${one_it_observation_units_percent}%__ of ${oneIT_units.length } OneIT units have participated in Observations through the SPARK program. This includes __${its_units.length}__ ITS units and __${non_its_units.length}__ non-ITS units. __${unique_participant_names.length}__ individuals have taken advantage of the program and been hosted by __${unique_host_names.length}__ individuals. The main reason selected for participating in SPARK observations has been _\"${reason_summary[0].reason}\"_ with __${reason_summary[0].count}__ individuals selecting that option followed by _\"${reason_summary[1].reason}\"_ with __${reason_summary[1].count}__ individuals selecting that reason.\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":221,"value":"md`## Open House Metrics`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":260,"value":"md `### Open House ITS Units Represented: ${open_its_units.length}\n\n${open_its_units.join(', ')}\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":262,"value":"md `### Open House non-ITS Units Represented: ${open_non_its_units.length}\n\n${open_non_its_units.join(', ')}\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":266,"value":"md`### Number of OneIT Units participating in Open Houses: ${open_oneit_units}\n\nwhich represents ${open_oneit_units_percent}% of all OneIT units\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":269,"value":"md`### Total number of Open Houses: ${open_house_processed.length}\n\n${open_unique_host_names.length} unique host coordinators\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":272,"value":"md`### Open House Healthcare units Represented: ${open_healthcare_units.length}\n\n${open_healthcare_units.join(', ')}\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":229,"value":"md`### Reasons for hosting an open house`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":226,"value":"table(open_reason_summary)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":570,"value":"DOM.download(new Blob([d3.csvFormat(open_reason_summary)], {type: \"text/csv\"}), \"SPARK_OpenHouse_Reasons.csv\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":611,"value":"md`### Narrative\n\n__${open_oneit_units_percent}%__ of ${oneIT_units.length } OneIT units have hosted in Open Houses through the SPARK program. This includes __${open_its_units.length}__ ITS units and __${open_non_its_units.length}__ non-ITS units. The main reason selected for hosting SPARK Open Houses has been _\"${open_reason_summary[0].reason}\"_ with __${open_reason_summary[0].count}__ individuals selecting that option followed by _\"${open_reason_summary[1].reason}\"_ with __${open_reason_summary[1].count}__ individuals selecting that reason.\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":614,"value":"md`## Immersion Metrics`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":624,"value":"md `### Immersion ITS Units Represented: ${immersion_its_units.length}\n\n${immersion_its_units.join(', ')}\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":627,"value":"md `### Immersion non-ITS Units Represented: ${immersion_non_its_units.length}\n\n${immersion_non_its_units.join(', ')}\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":630,"value":"md`### Number of OneIT Units participating in Immersions: ${immersion_oneit_units}\n\nwhich represents ${immersion_oneit_units_percent}% of all OneIT units\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":633,"value":"md`### Total number of Immersions: ${immersion_json.length}\n\n${immersion_unique_participants.length} unique participants\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":661,"value":"md`### Immersions with an MOU: ${immersions_with_mou}\n\n${immersion_mou_percent}% of ${immersion_json.length} immersions\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":665,"value":"md`### Immersions converted to permanent hire: ${immersions_with_perm_hire}\n\n${immersions_with_perm_hire_percent}% of ${immersion_json.length} immersions.\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":670,"value":"md`### Narrative\n\n__${immersion_oneit_units_percent}%__ of ${oneIT_units.length } OneIT units have participated in immersions through the SPARK program. This includes __${immersion_its_units.length}__ ITS units and __${immersion_non_its_units.length}__ non-ITS units. Some of these immersions have taken place without an MOU in place for the employees. __${immersion_mou_percent}%__ (${immersions_with_mou}) of the ${immersion_json.length} immersions have had an MOU in place. While the immersion program through SPARK is not intended to be a path to a permanent job within the hosting unit, this can be one of the outcomes. __${immersions_with_perm_hire_percent}%__ (${immersions_with_perm_hire}) of the ${immersion_json.lenght} immersions have resulted in a permanent hire in the hosting unit. \n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":289,"value":"md`## Combined Summary`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":294,"value":"md `### ITS Units Represented: ${all_its_units.length}\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":338,"value":"table(all_its_units.map(unit => ({name: unit})))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":296,"value":"md `### non-ITS Units Represented: ${all_non_its_units.length}\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":347,"value":"table(all_non_its_units.map(unit => ({name: unit})))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":300,"value":"md`### Number of OneIT Units participating: ${combined_oneit_units}\n\nwhich represents ${combined_oneit_units_percent}% of all OneIT units\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":463,"value":"md`### All OneIT Units (including without participation)`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":458,"value":"table(oneIT_units)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":409,"value":"md`### Observations (including open houses): ${observation_processed.length + open_house_processed.length}\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":430,"value":"md`### Immersions: ${immersion_json.length}\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":303,"value":"md`### Healthcare units Represented: ${all_healthcare_units.length}\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":529,"value":"table(all_healthcare_units.map(unit => ({name: unit})))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":479,"value":"metrics = svg`\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":537,"value":"DOM.download(() => rasterize(metrics), undefined, \"Save as PNG\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":684,"value":"md`### Narrative\n\n__${combined_oneit_units_percent}%__ of ${oneIT_units.length } OneIT units have participated in Observations, Immersions, or Open Houses through the SPARK program. This includes __${all_its_units.length}__ ITS units and __${all_non_its_units.length}__ non-ITS units. SPARK has enabled __${observations_with_open_houses}__ observations (including open houses) and __${immersion_json.length}__ immersions. While HCIS has a separate goal for their metrics, __${all_healthcare_units.length}__ HCIS Departments have participated in OneIT Observations as either the host or the participant department.\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":71,"value":"md`## Data processing `","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":149,"value":"md`### Observation Data`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":18,"value":"observation_raw_json = d3.tsvParse(observation_text)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":20,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":75,"value":"unique_units = {\n let participant_units = new Set(observation_processed.map(row => fix_unit_name(row.participant_department)))\n let host_units = new Set(observation_processed.map(row => fix_unit_name(row.host_department)))\n \n return [...(new Set([...participant_units, ...host_units]))].filter(row => !row.match(/@/)).sort()\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":85,"value":"its_units = unique_units.filter(row => row.match(/^ITS /))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":90,"value":"non_its_units = unique_units.filter(row => !row.match(/^ITS /) && !(row.match(/^hcis /i) || row.match(/^uihc /i)))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":580,"value":"one_it_observation_units = its_units.length + non_its_units.length","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":583,"value":"one_it_observation_units_percent = Math.round((its_units.length + non_its_units.length) / 25 * 100, 0)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":104,"value":"healthcare_units = unique_units.filter(row => row.match(/^hcis /i) || row.match(/^uihc /i))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":127,"value":"unique_participant_names = [...(new Set(observation_processed.map(row => row.participant_display_name)))].sort()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":136,"value":"unique_host_names = [...(new Set(observation_processed.map(row => row.host_display_name)))].sort()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":187,"value":"reasons_mapped = {\n let reason_map = []\n reason_map['effectiveness'] = 'Be more effective at my job'\n reason_map['skill_attainment'] = 'Gain skills I can use in my current position'\n reason_map['career_advancement'] = 'Advance in my career'\n reason_map['build_network'] = 'Build relationships and expand my professional network'\n reason_map['managment_and_culture'] = 'Experience a different management style and workgroup culture'\n reason_map['new_perspective'] = 'Gain a new and different perspective on IT'\n reason_map['observe_future'] = 'Observe people working in a role I see myself in in the future'\n reason_map['share_specialty'] = 'Increase awareness/interest in my own specialty/workgroup'\n reason_map['personal_interest'] = 'Spend time in an area that is of personal interest'\n reason_map['other'] = 'Other'\n return reason_map\n}\n ","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":167,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":160,"value":"md`### Open House Data`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":162,"value":"open_house_json = d3.tsvParse(open_house_text)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":196,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":241,"value":"open_unique_units = {\n let host_units = new Set(open_house_processed.map(row => fix_unit_name(row.host_department)))\n return [...(new Set([...host_units]))].filter(row => !row.match(/@/)).sort()\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":247,"value":"open_its_units = open_unique_units.filter(row => row.match(/^ITS /))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":249,"value":"open_non_its_units = open_unique_units.filter(row => !row.match(/^ITS /) && !(row.match(/^hcis /i) || row.match(/^uihc /i)))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":588,"value":"open_oneit_units = open_its_units.length + open_non_its_units.length","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":592,"value":"open_oneit_units_percent = Math.round((open_its_units.length + open_non_its_units.length) / 25 * 100, 0)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":251,"value":"open_healthcare_units = open_unique_units.filter(row => row.match(/^hcis /i) || row.match(/^uihc /i))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":257,"value":"open_unique_host_names = [...(new Set(open_house_processed.map(row => row.host_display_name)))].sort()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":205,"value":"open_reasons_mapped = {\n let reason_map = []\n reason_map['open_position'] = 'We have an open position we are hoping to build interest in'\n reason_map['many_requests'] = 'We have received many requests for information about our unit'\n reason_map['gaps_in_community'] = 'We feel like there are gaps in the community in terms of understanding what we do'\n reason_map['remote_location'] = 'Due to our remote physical location, we would like to increase visibility to the IT community.'\n reason_map['unique_job'] = 'Due to our unique job functions, we would like to increase visibility to the IT community.'\n reason_map['best_practices'] = 'We are hoping to get more information about best practices'\n reason_map['new_service'] = 'We have a new service or product that we want to introduce to the community'\n reason_map['other'] = 'Other'\n return reason_map\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":215,"value":"open_reason_summary = {\n let summary = {\n many_requests: 0,\n gaps_in_community: 0,\n remote_location: 0,\n unique_job: 0,\n best_practices: 0,\n new_service: 0,\n other: 0,\n }\n open_house_processed.forEach(row => {\n summary.many_requests += (row.many_requests === 'yes' ? 1 : 0)\n summary.gaps_in_community += (row.gaps_in_community === 'yes' ? 1 : 0)\n summary.remote_location += (row.remote_location === 'yes' ? 1 : 0)\n summary.unique_job += (row.unique_job === 'yes' ? 1 : 0)\n summary.best_practices += (row.best_practices === 'yes' ? 1 : 0)\n summary.new_service += (row.new_service === 'yes' ? 1 : 0)\n summary.other += (row.other === 'yes' ? 1 : 0)\n })\n let transpose = [];\n Object.keys(summary).forEach(reason => transpose.push({reason: open_reasons_mapped[reason], count: summary[reason]}))\n return transpose.sort((a,b) => (b.count > a.count ? 1 : -1))\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":309,"value":"md`### Immersion Data`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":311,"value":"immersion_json = d3.tsvParse(immersion_text)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":314,"value":"unique_immersion_units = [...(new Set([...(immersion_json.map(row => fix_unit_name(row['Participant Dept.']))), ...(immersion_json.map(row => fix_unit_name(row['Host Dept.'])))]))].sort()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":320,"value":"immersion_its_units = unique_immersion_units.filter(row => row.match(/^ITS /))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":324,"value":"immersion_non_its_units = unique_immersion_units.filter(row => !row.match(/^ITS /) && !(row.match(/^hcis /i) || row.match(/^uihc /i)))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":329,"value":"immersion_healthcare_units = unique_immersion_units.filter(row => row.match(/^hcis /i) || row.match(/^uihc /i))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":617,"value":"immersion_oneit_units = immersion_its_units.length + immersion_non_its_units.length","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":620,"value":"immersion_oneit_units_percent = Math.round(immersion_oneit_units / 25 * 100, 0)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":635,"value":"immersion_unique_participants = [...(new Set(immersion_json.map(row => row['Particpant Name'])))].sort()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":642,"value":"immersions_with_mou = immersion_json.filter(row => row['MOU'] === 'Y').length","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":650,"value":"immersion_mou_percent = Math.round(immersions_with_mou / immersion_json.length * 100, 0)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":647,"value":"immersions_with_perm_hire = immersion_json.filter(row => row['Perm Hire'] === 'Y').length","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":654,"value":"immersions_with_perm_hire_percent = Math.round(immersions_with_perm_hire / immersion_json.length * 100, 0)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":275,"value":"md`### Combined data`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":278,"value":"all_unique_units = [...(new Set([...unique_units,...open_unique_units,...unique_immersion_units]))].sort()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":281,"value":"all_its_units = all_unique_units.filter(row => row.match(/^ITS /)).sort()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":284,"value":"all_non_its_units = all_unique_units.filter(row => !row.match(/^ITS /) && !(row.match(/^hcis /i) || row.match(/^uihc /i)))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":595,"value":"combined_oneit_units = all_its_units.length + all_non_its_units.length","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":599,"value":"combined_oneit_units_percent = Math.round((all_its_units.length + all_non_its_units.length) / 25 * 100, 0)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":687,"value":"observations_with_open_houses = observation_processed.length + open_house_processed.length","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":286,"value":"all_healthcare_units = all_unique_units.filter(row => row.match(/^hcis /i) || row.match(/^uihc /i))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":466,"value":"unit_map = {\n let map = []\n map['ITS AIS'] = 'ITS Admin Information Systems'\n map['ITS Administrative Information Systems'] = 'ITS Admin Information Systems'\n map['ITS Information Security & Policy Office'] = 'ITS Security Office'\n map['Cend Engineering Computer Netw'] = 'College of Engineering'\n map['Cpub Public Health Admin'] = 'College of Public Health'\n map['ITS Office of Teaching, Learning, & Technology'] = 'ITS Teach, Learn, & Technolog'\n return map\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":455,"value":"oneIT_units = d3.tsvParse(`Org\tDepartment Code\tName\n02\t0140\tProvost Informatics\n05\t0333\tBusiness Services Admin MBSB\n08\t0425\tAthletics\n11\t1900\tLiberal Arts and Sciences\n12\t2115\tCollege of Business\n13\t2270\tCollege of Dentistry\n14\t2520\tCollege of Education\n15\t2760\tCollege of Engineering\n17\t3000\tCollege of Medicine\n18\t4000\tCollege of Nursing\n19\t4100\tCollege of Pharmacy\n20\t5200\tCollege of Public Health\n21\t5305\tICTS - Biomedical Informatics\n29\t4200\tGraduate College\n33\t4300\tLibrary\n35\t0195\tUniversity College\n43\t5064\tITS - Admin Information Systems\n43\t5065\tITS - CIO Office\n43\t5072\tITS - Enterprise Infrastructure\n43\t5073\tITS - Enterprise Services\n43\t5075\tITS - Teach & Learn Technology\n43\t5076\tITS - Research Services\n43\t5077\tITS - Security Office\n49\t4780\tUniversity Housing\n90\t9160\tHyg Lab Computer\n`)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":157,"value":"md`### Utility Functions`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":153,"value":"fix_unit_name = (unit_name) => {\n let name = unit_name.replace(' - ',' ').replace('-',' ')\n if (unit_map[name]) { name = unit_map[name] }\n return name\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":21,"value":"parse_person = (person) => \n{ let [display_name, university_id, title, job_code,staff_type, department, email, address, phone] = person ? person.split('\\n') : [,,,,,,,,]\n return {\n display_name: display_name,\n university_id: university_id,\n title: title,\n job_code: job_code,\n staff_type: staff_type,\n department: department,\n email: email,\n address: address,\n phone: phone\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":474,"value":"make_stat = (top_text, bottom_text, bottom_class, offsetx, offsety) => {\n return `\n \n \n ${top_text}\n ${bottom_text}\n \n`\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":5,"value":"md`## Imports`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":8,"value":"import {textarea} from \"@jashkenas/inputs\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":180,"value":"import {table} from \"@tmcw/tables@513\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":538,"value":"import {rasterize} from \"@mbostock/saving-svg\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":16,"value":"d3 = require('d3')","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"}],"files":"$W35","stdlib":"1","titling":"auto"}} 31:"$30:body"