Quantification tool

Hi Gustavo,

It's better if you give a feedback about this issue (if it'll be done or rejected for this version, and if so, what is the layout of the excel file).

My suggestion is, if this is to be implemented now, the excel layout must follow the layout of the forecasting:

1. One sheet for each tab of the forecasting (parameters, summary, medicine details, case details, etc);
2. Each sheet will follow the same layout and structure of the tabs;

The existing Summary table in Excel is adequate.

Should still be implemented:

- The other tabs Parameters, Medicines Report, Cases Report and Detailed Report;

- Name of the forecasting at the first row on the top (name it was saved by the user);

- The new fields (at the second and third rows): Name of Country/Region/Facility and Name of person performing the forecasting.

See figure attached and instructions below:

Include the name used to save the forecasting as the first row on the top, with the label "Forecasting Name";

Move the saving date as the second row;

Include the name of country and person with labels, in two separate rows (see Bug #532)and displayed below the saving date;

Please find below order of sheets and labels (as agreed during the conf call on April 3rd):

Sheet 1 – ‘Parameters’
Sheet 2 – ‘Summary’
Sheet 3 – ‘ Medicines Report’
Sheet 4 – ‘ Case Report – Treatment Regimen’
Sheet 5 – ‘ Case Report – Medicine’
Sheet 6 – ‘<Medicine name>’ (Sheet 6 and those after will have the medicine name as the label and will be the detailed report for the medicine selected.)
Sheet 7 – ‘<Medicine name>’

Adequate.