Bid Close Form

This Form allows the user to tag certain lines in Div Worksheet pages and allows the user to edit them in real time without being on the same page

Bid Recap Automation Feature

The Bid Recap Automation feature is a powerful tool designed to streamline the process of creating and managing bid recaps in Excel. This feature creates and updates a set of Excel workbooks (referred to as "slave books") based on a main Excel workbook (the "master book"). The feature includes bid recap tiles and data updates in real-time across the network.

Feature Overview

Master Book: This is the main Excel workbook that controls all the slave books. Changes made in this workbook are reflected in the slave books. Slave Books: These are the Excel workbooks generated from the master book. They are automatically updated when changes are made in the master book. Bid Recap Tiles: These tiles display key information about each bid. Clicking on a tile updates the details pane with more specific information about the selected bid. Real-time Updates: The bid recap data is updated in real-time across the network, ensuring all users have the most current and accurate information.

How It Works

Generating Slave Books

The process begins by generating an MD5 hash based on the book name, date, and user. If the "BidRecapBookKey" does not exist in the active workbook's custom properties, a new one is created. The hash, together with the book key, is used to uniquely identify each slave book.

PLACEHOLDER FOR GIF 1: Generating the Slave Books

Updating Bid Recap Data

Bid recap data is updated by searching for line items in the DataGridView. If an existing item is found in the bid recap data list, it is updated; if not, a new item is added. The tiles are also updated with the new data.

PLACEHOLDER FOR GIF 2: Updating the Bid Recap Data

Creating Workbooks from Template

Each workbook is created from a template. The template is copied and filled with data from the master book for each division ID and description pair.

PLACEHOLDER FOR GIF 3: Creating Workbooks from Template

Saving Workbooks

Each workbook is saved as an individual Excel file in the selected folder. If a file with the same name already exists, it is deleted before the new file is saved.

PLACEHOLDER FOR GIF 4: Saving Workbooks

Operation

To use the Bid Recap Automation feature:

Click the "Generate Slaves" button. This will initiate the process of creating the slave books. View and manage the slave books. Changes made in the master book will automatically update the corresponding slave books. View the bid recap tiles for a quick overview of each bid. Click a tile to see more detailed information in the details pane. Save your changes. Each workbook will be saved as an individual Excel file in the selected folder. PLACEHOLDER FOR GIF 5: Operation of the Bid Recap Automation feature

Conclusion

The Bid Recap Automation feature simplifies the management of bid recaps by automatically creating and updating slave books based on a master book. With real-time data updates and easy-to-view bid recap tiles, this feature is a significant productivity booster for managing bids.