Uploads by William.taylor
Jump to navigation
Jump to search
This special page shows all uploaded files.
| Date | Name | Thumbnail | Size | Description | Versions |
|---|---|---|---|---|---|
| 13:35, 31 March 2020 | 20200303 165606.jpg (file) |  |
2.61 MB | 1 | |
| 15:16, 30 March 2020 | PublicationPlanning3.xlsm (file) |  |
869 KB | 1 | |
| 15:15, 30 March 2020 | Travel.xlsm (file) | |
110 KB | 1 | |
| 14:44, 30 March 2020 | UserStoryReport.PNG (file) |  |
12 KB | 2 | |
| 14:33, 30 March 2020 | Artifacts.xlsx (file) | |
14 KB | 1 | |
| 14:32, 30 March 2020 | Form Processing.pptx (file) | |
39 KB | 1 | |
| 14:31, 30 March 2020 | UXForm2.xlsm (file) | |
55 KB | 1 | |
| 14:31, 30 March 2020 | Findings.pptx (file) | |
2.06 MB | 1 | |
| 08:45, 30 March 2020 | PPMG Repository.pptx (file) | |
1.5 MB | The repository contains a number of data bases created in response to expressed needs, to address gaps in data management, to carryout experiments in time savings, email volume reduction, demonstrate including disparate elements in PMR reporting and a... | 1 |
| 14:08, 26 March 2020 | Report flows.pptx (file) | |
316 KB | The data modeling of the reports around us was important from a data point of view. Looking at data flows gives insights to the reporting process and how well it is interfaced. We look for "ping-ponging", "bounces", waiting, existence of a feedback lo... | 1 |
| 14:02, 26 March 2020 | Data Input Method.pptx (file) | |
938 KB | The first presentation exploring the options available to PPMG and CCDIC. This theme matured as time went on an those improvements are in later presentations. | 1 |
| 13:59, 26 March 2020 | PPMG CCDIC planning tool.pptx (file) | |
1.24 MB | Common Planning Dbs to demonstrate what the common tool would look like and how it would work in an effort to acquaint folks with relational database strategies which can save significant time and prevent repeating tasks (rated #1 source of pain). My... | 1 |
| 13:48, 26 March 2020 | HL PMRRequirements.pptx (file) | |
677 KB | Lean effort to define the high level requirements for the PMR | 1 |
| 13:38, 26 March 2020 | PMRwithForm2.xlsm (file) | |
6 MB | The second of a series of forms intended to deliver the missing higher quality User Experience to the spreadsheet environment at PHAC. | 1 |
| 13:08, 26 March 2020 | The PPMG Data Landscape.pptx (file) | |
45 KB | This presentation was used to shape the discussion of local data, data repositories and data usage in PPMG. | 1 |
| 13:05, 26 March 2020 | Survey2.jpg (file) |  |
115 KB | an example of the type of form I was attempting to embed in an email body as a watermark. Sadly, the alignment of the form and the users input can be thrown out of whack by too many uncontrollable influences like the size of the receiver's signature or... | 1 |
| 13:02, 26 March 2020 | PMT Reponses.txt (file) |  |
592 KB | This is an example we studied in order to determine if it was possible for this group to achieve the technical standing required with this survey system to be able to do the back-office processing for this very demanding PMT reporting. While we do have... | 1 |
| 12:57, 26 March 2020 | New Work Plan.xlsx (file) | |
51 KB | A BA operates under a commitment not to impact the time staff requires for operational deliverables. This team was very busy. Just before the new year, I proposed an alternated set of deliverables as an example of goals we could pursue given that it... | 1 |
| 12:49, 26 March 2020 | MVR PMR BoP.pptx (file) | |
221 KB | A study of PMR BOP and MVR data models used to deflect attention from any strategy of combining these data to solve MVR aggregation issues. The solution lies in preserving local financial system records not in the data of existing reports. Now, it is... | 1 |
| 12:45, 26 March 2020 | MVRAntG&C.docx (file) | |
12 KB | Data Modeling for this report. How does local data fit with this aggregated report? Where is the data given by PPMG to the financial reporting system each year as financial commitments?, Surely, preserving that data will be the source data to unders... | 1 |
| 12:44, 26 March 2020 | MVR CCDIC Rollup.docx (file) | |
12 KB | Data Modeling for this report. How does local data fit with this aggregated report? Where is the data given by PPMG to the financial reporting system each year as financial commitments?, Surely, preserving that data will be the source data to unders... | 1 |
| 12:44, 26 March 2020 | MVR Anticipated Salary.docx (file) | |
12 KB | Data Modeling for this report. How does local data fit with this aggregated report? Where is the data given by PPMG to the financial reporting system each year as financial commitments?, Surely, preserving that data will be the source data to unders... | 1 |
| 12:43, 26 March 2020 | MVR Anticipated O.docx (file) | |
12 KB | Data Modeling for this report. How does local data fit with this aggregated report? Where is the data given by PPMG to the financial reporting system each year as financial commitments?, Surely, preserving that data will be the source data to unders... | 1 |
| 12:39, 26 March 2020 | ImportMail.docx (file) | |
12 KB | VBA routine to auto-import the contents of the body of email into excel or access | 1 |
| 12:34, 26 March 2020 | DRRDataModel.docx (file) | |
24 KB | The DRR report data model. If the report content were to be treated like a data base record, what would the individual data elements and their labels be? We need these data models in order to assess whether or not these data might be of value in our... | 1 |
| 12:16, 26 March 2020 | PMRwithForm5.xlsm (file) | |
6 MB | This is a working example of using an improved UX Form on one tab to gather data and save one record per row to another tab with the traditional spreadsheet entry form. The Form will save all the data entered as a workbook to a network drive automatic... | 1 |
| 10:33, 26 March 2020 | CCDIC Sprints.pptx (file) | |
710 KB | Improvement ideas and early discussions from our sprint meetings. | 1 |
| 10:31, 26 March 2020 | PIP model.docx (file) | |
12 KB | PIP Data Model | 1 |
| 10:28, 26 March 2020 | PMTerms.pptx (file) | |
39 KB | Intended for discussion during the team's deliberations of a data model solution required for adding PMR planning records to the BOP. There was a clash of nomenclature, I felt the standard usage would be an aid to the discussion. | 1 |
| 10:26, 26 March 2020 | PHAC Org Chart.pptx (file) | |
41 KB | Made my own org chart while waiting for the official one. | 1 |
| 10:24, 26 March 2020 | Integration.pptx (file) | |
39 KB | High Level conceptual view of the data mindset we need to change. This enables change | 1 |
| 10:15, 26 March 2020 | CCDIC publications flow- Pilot.xlsx (file) | |
19 KB | Dta from which I built the Publications Planning RBM data input form, the spreadsheet repository and the trial database | 1 |
| 10:11, 26 March 2020 | Setup Workbook Connections.pptx (file) | |
33 KB | Results of the Lean experiment: Can we use connects to gather data? | 1 |
| 10:08, 26 March 2020 | SurveyAssessment.pptx (file) | |
150 KB | Last version | 4 |
| 09:52, 26 March 2020 | Our First Step.pptx (file) | |
3.45 MB | Presentation intended to help those who were having difficulty "starting" their RBM data gathering and reporting in the RBM Community of Practice. | 1 |
| 09:46, 26 March 2020 | Telephone Data Initiative.pptx (file) | |
37 KB | This was our first sprint or Lean experiment. | 1 |
| 09:33, 26 March 2020 | Section Planning Input Requirements.pptx (file) | |
531 KB | A presentation for discussion of which data elements might form a planning record which would serve PPMG going forward. Breaking the mindset of data model per report to "data we need". | 1 |
| 09:27, 26 March 2020 | Report Modeling2.pptx (file) | |
325 KB | A presentation for a discussion about the potential for a local repository of data from and useful to PPMG activities. | 1 |
| 09:25, 26 March 2020 | Publications SOP.pptx (file) | |
42 KB | This is a process diagram of the Publications SOP | 1 |
| 22:41, 25 March 2020 | RBM platform scenarios.docx (file) | |
12 KB | The list of scenarios considered for Centralized RBM | 1 |
| 22:37, 25 March 2020 | Auto Import the Attachments of Incoming Emails to Excel.docx (file) | |
228 KB | VB for auto import | 1 |
| 22:21, 25 March 2020 | PMR BOP Integration savings.xlsx (file) | |
67 KB | A comparative study of the possible savings of integration of PMR planning, PMR-BOP data and data gathering methods. A side-by-side comparison of As-Is vs. To-Be scenarios | 1 |
| 22:16, 25 March 2020 | Data Modeling.xlsx (file) | |
518 KB | the Lean data modeling of all the local data sources and some quick analysis. There is a companion ppt | 1 |
| 22:13, 25 March 2020 | CCDIC HR Database.xlsx (file) | |
12 KB | Suggestion from staff. It needs a nice record viewing form, a centralized collection and a method of sharing data. | 1 |
| 21:58, 25 March 2020 | DP Approval Process.pptx (file) | |
37 KB | When PPMG was left out of a step of the Departmental Plan, I gathered process info and created a process chart. The chart clearly demonstrated a disconnect which was corrected with the chart aiding discussion | 1 |
| 21:33, 25 March 2020 | Decoupling Benefits.pptx (file) | |
939 KB | An overview of the concepts, benefits and configuration examples of decoupling data creation from data gathering/reporting. | 1 |
