Forecast Overview Export
- Introduction
- Report Sections
- Scenario Specification
- RTSM extract
- Key mapping
- Forecast configuration
- Iteration configuration
- Depot configuration
- Site Group configuration
- Site Activation
- Patient Enrollment
- Patient Net Demand
- Trial Supply Projection
- Production Plan
- Forecasted Network Supply
- Forecasted Network Demand
- Forecasted Inventory
- Risk Index
- RTSM Supply Settings
- RTSM Initial Shipments
- Resupply Thresholds
- Forecasted Study Cost
- Forecasted Depot Shipments
- Forecasted Site Shipments
- Shipments
Introduction
4C Supply® forecast reports can be exported in Excel and JSON formats from the Forecast Overview page. Exported forecast reports contain the context (specification, RTSM extract, key mapping), configuration and forecast calculation results.
Note: All of the forecast calculation results data are in flat display and are intended to be analyzed in pivot tables.
Report Sections
Scenario Specification
Contains the scenario specification in HTML format.
Shown as contents of a single cell (A1)
Excel limitations to characters per cell (32'767 characters) can cause trimming of large specifications.
Note: Specifications can be formatted for better readability in Excel-format exports by copying the contents of cell A1 and pasting into another cell.
RTSM extract
Contains the RTSM extract details (id, date, description, etc.) and contents used in the forecast calculation.
‘Data’ column contains RTSM Extract data in JSON format.
Excel limitations to characters per cell (32'767 characters) can cause trimming of large specifications.
Note: RTSM extract is empty if no RTSM extract was used in the forecast calculation.
Key mapping
Contains the key mapping used in the forecast as table.
Includes Fields: ID, study, Site groups, Patient visits, Depots, Regions, Kit types, Treatment arms, Cohorts, Titration levels, Patient statuses, Kit statuses, Custom logic for action mapping
Note: Key Mapping is empty if no RTSM extract was used in the forecast calculation.
Forecast configuration
Details the forecast configuration used in the forecast.
Includes Fields: Study code, Study description, Scenario ID, Scenario description, RTSM extract description, RTSM extract date, Report interval, Confidence used for site buffers, Manual overage, Depot long window days, Site Group long window days before LPI, Site Group long window days after LPI.
Iteration configuration
Details the iteration (i.e., scenario) configuration used in the forecast.
Includes Fields: Dispensing unit, Minimal safety stock, Additional safety stock.
Depot configuration
Details the depot configuration used in the forecast.
Includes Fields: Dispensing unit, Depot, Supplier, Shipment Type, Lead days by supplier, Minimal Safety Stock, Additional Safety Stock.
Site Group configuration
Details the site group configuration used in the forecast.
Includes Fields: Dispensing unit, Site group, Region, Supplier, Shipment Type, Region lead days by supplier, Minimal Safety Stock, Additional Safety Stock.
Site Activation
Contains site activations data as stored in the RTSM extract and as computed in the forecast calculation.
Includes Fields: Time, Depot, Region, Site Group, Measure, Count.
Aligned with corresponding fields in the Site Activation report.
Patient Enrollment
Contains patient enrollment data as stored in the RTSM extract and as computed in the forecast calculation.
Includes Fields: Time, Event, Depot, Region, Site Group, Actual Site, Cohort, Measure, Count.
Aligned with corresponding fields in the Patient Enrollment report.
Patient Net Demand
Contains combined patient net demand data as stored in the RTSM extract and as computed in the forecast calculation.
Includes Fields: Time, Dispensing Unit, Depot, Region, Site Group, Actual Site, Measure, Quantity.
Aligned with fields in the Patient Net Demand report.
Trial Supply Projection
Contains combined trial supply data as stored in the RTSM extract and as computed in the forecast calculation.
Includes Fields: Time, Type, Depot, Region, Site Group, Label Group, Dispensing Unit, Quantity, Actual Site, Average Site.
Aligned with fields in the Trial Supply Projection report.
Production Plan
Contains production data as computed in the forecast calculation.
Includes Fields: Time, Label Group, Dispensing Unit, Quantity, # of Packs.
Aligned with fields in the Production Plan report.
Forecasted Network Supply
Contains network supply data as computed in the forecast calculation.
Includes Fields: Time, Dispensing Unit, Depot, Region, Site Group, Actual Site, Average Site, Measure, Quantity, Pack Number.
Aligned with fields in the Forecasted Network Supply report.
Forecasted Network Demand
Contains network demand data as computed in the forecast calculation.
Includes Fields: Time, Dispensing Unit, Depot, Region, Site Group, Actual Site, Average Site, Measure, Quantity, Pack Number.
Aligned with fields in the Forecasted Network Demand report.
Forecasted Inventory
Contains inventory data as computed in the forecast calculation.
Includes Fields: Time, Dispensing Unit, Depot, Region, Site Group, Actual Site, Average Site, Measure, Quantity, Pack Number.
Aligned with fields in the Forecasted Inventory report.
Risk Index
Contains risk data as computed in the forecast calculation.
Includes Fields: Time, Dispensing Unit, Depot, Region, Site Group, Site, Quantity, Label Group.
Aligned with fields in the Risk Index report.
RTSM Supply Settings
Contains RTSM supply settings as entered or computed (i.e., recommended) in the forecast calculation.
Includes Fields: Period Start Date, Type, Site Group, Dispensing Unit, RTSM Settings
Aligned with fields in the RTSM Resupply Settings report.
RTSM Initial Shipments
Contains RTSM initial shipment settings as entered or computed (i.e., recommended) in the forecast calculation.
Includes Fields: Type, Site Group, Dispensing Unit, Recommended Initial Shipments.
Aligned with fields in the RTSM Resupply Settings report.
Resupply Thresholds
Contains resupply thresholds as entered or computed (i.e., recommended) in the forecast calculation.
Includes Fields: Time, Type, Dispensing Unit, Quantity, Actual Site, Average Site, Depot.
Aligned with fields in the Resupply Thresholds report.
Forecasted Study Cost
Contains forecasted study cost data as computed in the forecast calculation.
Includes Fields: Time, Type, Dispensing Unit, Category, Cost.
Aligned with fields in the Forecasted Study Cost report.
Forecasted Depot Shipments
Contains forecasted depot shipment data as computed in the forecast calculation.
Includes Fields: Time, Type, Dispensing Unit, Category, Cost.
Aligned with fields in the Forecasted Depot Shipments report.
Forecasted Site Shipments
Contains forecasted site shipment data as computed in the forecast calculation.
Includes Fields: Time, Source, Destination, Shipment Type, Count.
Aligned with fields in the Forecasted Site Shipments report.
Shipments
Contains combined shipment data as stored in the RTSM extract and as computed in the forecast calculation.
Includes Fields: Supplier, Receiver, Departure Date, Arrival Date, Dispensing Unit, Quantity, # of Packs.
Aligned with fields in the Shipment Details report.