All public logs
Jump to navigation
Jump to search
Combined display of all available logs of wiki. You can narrow down the view by selecting a log type, the username (case-sensitive), or the affected page (also case-sensitive).
(newest | oldest) View (newer 50 | older 50) (20 | 50 | 100 | 250 | 500)- 13:35, 31 March 2020 William.taylor talk contribs uploaded File:20200303 165606.jpg
- 15:16, 30 March 2020 William.taylor talk contribs uploaded File:PublicationPlanning3.xlsm
- 15:15, 30 March 2020 William.taylor talk contribs uploaded File:Travel.xlsm
- 14:44, 30 March 2020 William.taylor talk contribs uploaded a new version of File:UserStoryReport.PNG
- 14:39, 30 March 2020 William.taylor talk contribs uploaded File:UserStoryReport.PNG
- 14:33, 30 March 2020 William.taylor talk contribs uploaded File:Artifacts.xlsx
- 14:32, 30 March 2020 William.taylor talk contribs uploaded File:Form Processing.pptx
- 14:31, 30 March 2020 William.taylor talk contribs uploaded File:UXForm2.xlsm
- 14:31, 30 March 2020 William.taylor talk contribs uploaded File:Findings.pptx
- 08:45, 30 March 2020 William.taylor talk contribs uploaded File:PPMG Repository.pptx (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...)
- 14:08, 26 March 2020 William.taylor talk contribs uploaded File:Report flows.pptx (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...)
- 14:02, 26 March 2020 William.taylor talk contribs uploaded File:Data Input Method.pptx (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.)
- 13:59, 26 March 2020 William.taylor talk contribs uploaded File:PPMG CCDIC planning tool.pptx (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...)
- 13:48, 26 March 2020 William.taylor talk contribs uploaded File:HL PMRRequirements.pptx (Lean effort to define the high level requirements for the PMR)
- 13:38, 26 March 2020 William.taylor talk contribs uploaded File:PMRwithForm2.xlsm (The second of a series of forms intended to deliver the missing higher quality User Experience to the spreadsheet environment at PHAC.)
- 13:08, 26 March 2020 William.taylor talk contribs uploaded File:The PPMG Data Landscape.pptx (This presentation was used to shape the discussion of local data, data repositories and data usage in PPMG.)
- 13:05, 26 March 2020 William.taylor talk contribs uploaded File:Survey2.jpg (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...)
- 13:02, 26 March 2020 William.taylor talk contribs uploaded File:PMT Reponses.txt (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...)
- 12:57, 26 March 2020 William.taylor talk contribs uploaded File:New Work Plan.xlsx (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...)
- 12:49, 26 March 2020 William.taylor talk contribs uploaded File:MVR PMR BoP.pptx (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...)
- 12:45, 26 March 2020 William.taylor talk contribs uploaded File:MVRAntG&C.docx (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...)
- 12:44, 26 March 2020 William.taylor talk contribs uploaded File:MVR CCDIC Rollup.docx (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...)
- 12:44, 26 March 2020 William.taylor talk contribs uploaded File:MVR Anticipated Salary.docx (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...)
- 12:43, 26 March 2020 William.taylor talk contribs uploaded File:MVR Anticipated O.docx (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...)
- 12:39, 26 March 2020 William.taylor talk contribs uploaded File:ImportMail.docx (VBA routine to auto-import the contents of the body of email into excel or access)
- 12:34, 26 March 2020 William.taylor talk contribs uploaded File:DRRDataModel.docx (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...)
- 12:16, 26 March 2020 William.taylor talk contribs uploaded File:PMRwithForm5.xlsm (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...)
- 10:33, 26 March 2020 William.taylor talk contribs uploaded File:CCDIC Sprints.pptx (Improvement ideas and early discussions from our sprint meetings.)
- 10:31, 26 March 2020 William.taylor talk contribs uploaded File:PIP model.docx (PIP Data Model)
- 10:28, 26 March 2020 William.taylor talk contribs uploaded File:PMTerms.pptx (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.)
- 10:26, 26 March 2020 William.taylor talk contribs uploaded File:PHAC Org Chart.pptx (Made my own org chart while waiting for the official one.)
- 10:24, 26 March 2020 William.taylor talk contribs uploaded File:Integration.pptx (High Level conceptual view of the data mindset we need to change. This enables change)
- 10:15, 26 March 2020 William.taylor talk contribs uploaded File:CCDIC publications flow- Pilot.xlsx (Dta from which I built the Publications Planning RBM data input form, the spreadsheet repository and the trial database)
- 10:11, 26 March 2020 William.taylor talk contribs uploaded File:Setup Workbook Connections.pptx (Results of the Lean experiment: Can we use connects to gather data?)
- 10:08, 26 March 2020 William.taylor talk contribs uploaded a new version of File:SurveyAssessment.pptx (Last version)
- 09:52, 26 March 2020 William.taylor talk contribs uploaded File:Our First Step.pptx (Presentation intended to help those who were having difficulty "starting" their RBM data gathering and reporting in the RBM Community of Practice.)
- 09:46, 26 March 2020 William.taylor talk contribs uploaded File:Telephone Data Initiative.pptx (This was our first sprint or Lean experiment.)
- 09:33, 26 March 2020 William.taylor talk contribs uploaded File:Section Planning Input Requirements.pptx (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".)
- 09:27, 26 March 2020 William.taylor talk contribs uploaded File:Report Modeling2.pptx (A presentation for a discussion about the potential for a local repository of data from and useful to PPMG activities.)
- 09:25, 26 March 2020 William.taylor talk contribs uploaded File:Publications SOP.pptx (This is a process diagram of the Publications SOP)
- 22:41, 25 March 2020 William.taylor talk contribs uploaded File:RBM platform scenarios.docx (The list of scenarios considered for Centralized RBM)
- 22:37, 25 March 2020 William.taylor talk contribs uploaded File:Auto Import the Attachments of Incoming Emails to Excel.docx (VB for auto import)
- 22:34, 25 March 2020 William.taylor talk contribs uploaded a new version of File:SurveyAssessment.pptx (Final View)
- 22:27, 25 March 2020 William.taylor talk contribs uploaded a new version of File:SurveyAssessment.pptx (A Lean assessment of the PPMG's Survey strategy to gather PM data.)
- 22:21, 25 March 2020 William.taylor talk contribs uploaded File:PMR BOP Integration savings.xlsx (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)
- 22:16, 25 March 2020 William.taylor talk contribs uploaded File:Data Modeling.xlsx (the Lean data modeling of all the local data sources and some quick analysis. There is a companion ppt)
- 22:13, 25 March 2020 William.taylor talk contribs uploaded File:CCDIC HR Database.xlsx (Suggestion from staff. It needs a nice record viewing form, a centralized collection and a method of sharing data.)
- 21:58, 25 March 2020 William.taylor talk contribs uploaded File:DP Approval Process.pptx (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)
- 21:48, 25 March 2020 William.taylor talk contribs uploaded File:SurveyAssessment.pptx (A quick ppt for a discussion on the merits of surveys vs. spreadsheets and what requirements should be considered for a data gathering system.)
- 21:33, 25 March 2020 William.taylor talk contribs uploaded File:Decoupling Benefits.pptx (An overview of the concepts, benefits and configuration examples of decoupling data creation from data gathering/reporting.)