Writing a small simple excel program and store the data on the cloud
We need to track the staff hours in a more coherent way than currently. There needs to be data available such as current monthly hours scheduled by department staff by entering a monthly work schedule. Data Analysis needs are both for planning and monitoring the present. We get a feed from the Healthcare ERP when clinical needs are at risk, and there is a business rule, the substance is, more clinicians needed means more support staff needed. This information can be of a feed nature or an api call. We would want to have both passages, when we are low and when we need more staff scheduling and augmentation. So we start with a simple excel sheet. How simple can we make it? I will create 2 solutions. This often happens in certain of the real world. First get a simple edition up and then work on the enhancements. I wrote a solution in Access. That allows for entry of data with multi view, by calendar; monthly and weekly views. Let's see what the Customer wants shall we?

0 Comments:
Post a Comment
Subscribe to Post Comments [Atom]
<< Home