Bid Close Form - Revision history

Siyuan wei: /* Bid Recap Automation Feature */

2023-08-01T21:20:22Z

Bid Recap Automation Feature

Siyuan wei at 16:49, 11 July 2023

2023-07-11T16:49:07Z

Siyuan wei at 16:48, 11 July 2023

2023-07-11T16:48:12Z

Siyuan wei at 16:47, 11 July 2023

2023-07-11T16:47:13Z

Siyuan wei at 16:46, 11 July 2023

2023-07-11T16:46:14Z

ASamoil: Created page with "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 File:BidCloseFormGIF.gi..."

2022-02-01T21:43:11Z

Created page with "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 File:BidCloseFormGIF.gi..."

New page

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

[[File:BidCloseFormGIF.gif|center]]

@@ Line 16: / Line 16: @@
 ==== 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.
+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. The slavebook will only be generated for the lines selected for Bid Close.
-''PLACEHOLDER FOR GIF 3: Creating Workbooks from Template''
+The Comments under the selected bid close line will also be exported to the bid close sheet.
-==== Saving Workbooks ====
+[[File:Est2 BidClose ReviewtheBidCloseBook.gif|center|frame|Review the Bid Close Workbook]]
-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.
 === 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.

← Older revision		Revision as of 16:49, 11 July 2023
Line 1:		Line 1:
		+	== '''Overview of the 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		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

@@ Line 1: / Line 1: @@
 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
+[[File:BidCloseFormGIF.gif|center|alt=|thumb|600x600px]]
 == '''Bid Recap Automation Feature''' ==

@@ Line 5: / Line 5: @@
 [[File:BidCloseFormGIF.gif|center]]
-'''Bid Recap Automation Feature'''
+== '''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 ==
+=== 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.
@@ Line 15: / Line 14: @@
 '''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 ==
+=== How It Works ===
-=== Generating Slave Books ===
+==== 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 ===
+==== 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 ===
+==== 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 ===
+==== 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 ==
+=== Operation ===
 To use the Bid Recap Automation feature:
@@ Line 41: / Line 40: @@
 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 ==
+=== 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.

← Older revision		Revision as of 16:46, 11 July 2023
Line 4:		Line 4:

	[[File:BidCloseFormGIF.gif\|center]]		[[File:BidCloseFormGIF.gif\|center]]
		+
		+	'''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.