How to Understand the Brightwork Explorer File Formats

What This Article Covers

  • The Forecast Error and MRP Calculation File Formats
  • The Forecast Error Only Calculation File Formats
  • Using the Spreadsheet to Populate Data for Upload to the Brightwork Explorer.

Introduction

The Brightwork Explorer uses two file formats. One is when you want to use the Brightwork Explorer forecast error and monetized forecast error functionality along with the MRP parameter calculator.

The Brightwork Explorer Forecast Error and MRP Parameter Calculator

This multi-tabbed Google Sheet file contains the formats you need to run this option. It can be downloaded at this link.

The Brightwork Explorer Forecast Error “Only”

This multi-tabbed Google Sheet file contains the formats you need to run this option. It can be downloaded at this link.

The only difference between the two files is that while the formats are the Forecast Error “Only” file has blank fields which are not used if the MRP and inventory parameter calculations are not desired to be used.

These two file formats must be shared with you, so the administrator for Brightwork Explorer must add you to the shared membership for each file on Google Sheets.

Monthly Bucket Only For Data

Something to know, the Brightwork Explorer will only accept the date format of MONTH/YEAR. The reason is that even if one produces a forecasting weekly it will not be used in the Bightwork Explorer for the following reasons:

  1. It makes little sense to feed a weekly forecast to a supply planning system.
  2. A weekly forecast error cannot be used for supply planning.
  3. A weekly forecast error is not useful for forecast measurement and forecast improvement.
  4. A weekly forecast error is not useful for setting MRP parameters.

For this reason, the Brightwork Exploer file format is in a monthly bucket.

Using the Spreadsheet to Populate Data for Upload to the Brightwork Explorer.

The Google Sheet should be populated with data in Google Sheets or downloaded to Excel, then populated with data. Once all of the data has been populated, then you must save each individual file as a .csv extension. This can be easily done by saving “as” and selecting .csv as the option. This must be done for each of the tabs — each tab corresponding or eventually becoming a .csv file. Then these files are uploaded to the Brightwork Explorer.

  • Need an Easy to Use Way to Tune Forecasting and MRP Systems?

    We are close to releasing Brightwork Explorer, a new SaaS application which makes forecasting and MRP systems. Highlights include the following:

    • It contains our customized dynamic safety stock calculation, tuned after finding the limitations of the standard calulators.
    • It provides multi constraint visibility.
    • Has an amazing ease of use combined with sophistication.
    • It can provide visibility to tradeoffs related to service level and inventory in the most direct way we have ever seen in any application....and much more
    • It is free to use until it receives "serious usage" and is free to academics, students.

    Just fill in your contact details in the form below to be informed when the Brightwork Explorer becomes generally available.

    100% Privacy Guarantee: We don't share your contact details with anyone.