Skip to content

Implementation_Guide.md

Latest commit

 

History

History
134 lines (109 loc) · 5.17 KB

Implementation_Guide.md

File metadata and controls

134 lines (109 loc) · 5.17 KB
Raw

Manufacturing Workflow Scheduler - Implementation Guide

Overview

This document provides detailed instructions for setting up and using the Manufacturing Workflow Scheduler. This Excel-based solution automates the scheduling of complex manufacturing workflows with divergent and convergent steps.

Setup Instructions

Step 1: Create a New Excel Workbook

  1. Open Microsoft Excel
  2. Create a new workbook
  3. Save it as "Manufacturing_Workflow_Scheduler.xlsm" (be sure to select Excel Macro-Enabled Workbook)

Step 2: Import VBA Modules

  1. Press Alt+F11 to open the VBA editor
  2. Right-click on the project in the Project Explorer
  3. Select Import File
  4. Import each of the following files:
    • MainModule.bas
    • UserFormModule.bas
    • UtilityModule.bas

Step 3: Create Required Worksheets

The following worksheets will be automatically created when the workbook opens:

  • Dashboard
  • ImportedData
  • WorkflowSetup
  • Parameters
  • Schedule
  • Reports

If you need to create them manually:

  1. Right-click on any worksheet tab
  2. Select Insert
  3. Choose Worksheet
  4. Rename to match the required sheet names

Step 4: Enable Macros

  1. Save and close the workbook
  2. Reopen the workbook
  3. If prompted, click "Enable Macros"
  4. The workbook will automatically create the required sheets and set up the dashboard

Using the Workflow Scheduler

Importing Data

  1. Click the "Import Data from CSV" button on the Dashboard
  2. Select your ERP data export file (it should match the format of the provided sample_data.csv)
  3. The data will be imported into the ImportedData sheet

Setting Up the Workflow

You can set up the workflow in two ways:

Option 1: Import from CSV

  1. Click the "Import Workflow from CSV" button on the Dashboard
  2. Select your workflow definition file (it should match the format of the provided workflow_template.csv)

Option 2: Manual Setup

  1. Go to the WorkflowSetup sheet
  2. Enter your workflow steps with the following columns:
    • StepID: Unique identifier for each step
    • StepName: Descriptive name for the step
    • Department: Department responsible for the step
    • Duration: Time required to complete the step (in days)
    • Prerequisites: Comma-separated list of StepIDs that must be completed before this step
    • ResourceRequired: Resource needed for this step
    • SetupTime: Additional setup time required before the step (in days)

Configuring Parameters

  1. Go to the Parameters sheet
  2. Adjust the following settings:
    • Start Date: The default start date for scheduling
    • Working Hours Per Day: Used to convert durations to calendar time
    • Use Calendar Days: Set to "Yes" to use calendar days, "No" to use working days (excluding weekends)
    • Max Resource Utilization %: Maximum allowed resource utilization percentage

Generating the Schedule

  1. Click the "Generate Schedule" button on the Dashboard
  2. The system will calculate optimal start and end dates for each step based on:
    • Work order priority
    • Step dependencies (prerequisites)
    • Resource availability
    • Working days/hours configuration
  3. The completed schedule will appear in the Schedule sheet

Viewing and Analyzing Results

  1. Go to the Schedule sheet to see the complete detailed schedule
  2. Use the Reports sheet to view summary information and analytics
  3. To generate a resource utilization chart, run the UpdateResourceChart macro

Exporting the Schedule

  1. Click the "Export Schedule to CSV" button on the Dashboard
  2. Choose a location to save the exported schedule
  3. The schedule will be exported in CSV format for use in other systems

Customizing the Solution

Modifying the Workflow

  1. Edit the WorkflowSetup sheet to add, remove, or modify steps
  2. Change prerequisites to alter the workflow relationships
  3. Adjust durations and resource requirements as needed

Adjusting Scheduling Logic

For advanced customization of the scheduling algorithm, you can modify:

  1. The GenerateSchedule procedure in MainModule
  2. The BuildWorkOrderSchedule function in MainModule
  3. The CalculateCriticalPath function in UtilityModule

Adding Custom Reports

  1. Create a new macro in UserFormModule or MainModule
  2. Use the existing data in the Schedule sheet to generate custom analytics
  3. Add a button to the Dashboard that calls your new macro

Troubleshooting

Common Issues

  • Macros Disabled: Ensure macros are enabled in Excel security settings
  • Missing References: If you get "Missing Reference" errors, you may need to add references to:
    • Microsoft Scripting Runtime
    • Microsoft Forms 2.0 Object Library
  • Import Errors: Ensure CSV files match the expected format (see sample files)
  • Scheduling Errors: Check for circular dependencies in your workflow definition

Error Logging

The system logs errors to an ErrorLog.txt file in the same directory as the workbook. Check this file if you encounter issues.

Future Enhancements

The solution is designed to be extensible. Consider these potential enhancements:

  • Integration with project management tools
  • Gantt chart visualization
  • Resource leveling algorithms
  • Real-time progress tracking

Support

For questions or support with implementation, refer to the README file or contact the developer.