How to Understand the Brightwork Explorer File Formats

Executive Summary

  • Brightwork Explorer uses straightforward files with simple file formats.
  • This article will cover the Brightwork Explorer files.

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 forecast weekly, it will not be used in the Brightwork 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 Explorer 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 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?

    Highlights of the Brightwork Explore 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

    Just fill in your contact details in the form below and we will be in contact.

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