https://thewiki.builtplainly.com/api.php?action=feedcontributions&feedformat=atom&user=ASamoilSynWiki - User contributions [en]2026-11-05T03:40:29ZUser contributionsMediaWiki 1.35.6https://thewiki.builtplainly.com/index.php?title=Report_and_Others&diff=1085Report and Others2022-07-11T21:58:22Z<p>ASamoil: /* Breakdown */</p>
<hr />
<div>[[File:ReportAndReview1.3.0.6.png|frame|center|link=]]<br />
<br />
= Report and Review =<br />
== General Settings ==<br />
<br />
=== [[Show LBR]] ===<br />
Shows or Hides HD's on the Summary Page<br />
<br />
=== [[Show IND]] ===<br />
Shows or Hides HD's on the Summary Page<br />
<br />
=== [[Freeze Top]] ===<br />
Freezes the Top few lines so they stay with you as you scroll<br />
<br />
=== [[Change Theme]] ===<br />
Changes the Current Workbook Theme<br />
<br />
=== [[Set Page Breaks]] ===<br />
Sets the Page Breaks for the Workbook<br />
<br />
=== [[Set Page Breaks|Set Page]] ===<br />
Sets the Page Break for the Current Worksheet<br />
<br />
== Summary Settings ==<br />
<br />
=== [[Show SD]] ===<br />
Shows or Hides SD's on the Summary Page<br />
<br />
=== [[Show HD]] ===<br />
Shows or Hides HD's on the Summary Page<br />
<br />
=== [[Show Zeros]] ===<br />
Show or Hides Zeros on the Summary Page<br />
<br />
<br />
<br />
=== [[Extra Summary Data]] ===<br />
Adds extra lines to the bottom of the Summary Page<br />
<br />
=== [[Extra Summary CM]] ===<br />
Adds extra comments to the bottom of the Summary Page<br />
<br />
=== [[Scratch Sheet]] ===<br />
Will create a blank worksheet that can be used for anything<br />
<br />
== Worksheet Settings ==<br />
<br />
=== [[Show Bond]] ===<br />
Enables or Disables the Bond Column<br />
<br />
=== [[Add End Line]] ===<br />
Adds a line at the end of a Div sheet to show that its the end<br />
<br />
=== [[Approve WS]] ===<br />
Changes the Tab Color of the Worksheet to Green/Approved<br />
<br />
== Breakdown ==<br />
<br />
=== [[Enable B.D.]] ===<br />
Hides and Unhides the Breakdown (Alpha Label) Column on Div's<br />
<br />
=== [[Make B.D.]] ===<br />
Creates a Breakdown Sheet if One does not already exist<br />
* Must have Enable B.D. Enabled<br />
<br />
=== [[Add User Item]] ===<br />
Adds a New User Added Item<br />
* Only on Summary, Recoverable and BreakDown Pages<br />
<br />
=== [[Show Dis. Total]] ===<br />
Hides and Unhides the Breakdown (Alpha Label) Distributed Total<br />
<br />
=== [[SPL Comments]] ===<br />
Hides and Unhides the SPL Comments within the Workbook<br />
<br />
=== [[Insert Sub Total]] ===<br />
Inserts a subtotal line on a breakdown sheet<br />
<br />
== More ==<br />
<br />
=== [[Re-Calc WB]] ===<br />
Re-Calculates the entire Workbook<br />
<br />
=== [[PrintToPDF]] ===<br />
Prints the Workbook to a Pdf<br />
<br />
=== [[Reformat]] ===<br />
Reformats the Page to its Intended State<br />
* Only works for Div's<br />
<br />
==== Reformat Workbook ====<br />
Reformats the Entire Workbook<br />
<br />
== Recap ==<br />
<br />
=== [[Select Material]] ===<br />
Sets the selected material value from the recap section into the Div<br />
<br />
=== [[Select Subtrade]] ===<br />
Sets the selected subtrade value from the recap section into the Div<br />
<br />
=== [[Full Recap]] ===<br />
Hides Div Cols and Shows Recap Section simutanously<br />
<br />
=== [[Hide Div Cols]] ===<br />
Hides all unnecessary Div Cols for Recap <br />
<br />
=== [[Show Recap]] ===<br />
Shows/Hides the Recap Section<br />
<br />
== Budget Summary Options ==<br />
<br />
=== [[Budget Sheet]] ===<br />
Creates a budget sheet between two different workbooks (the current one and another one)<br />
<br />
=== [[Show SD Budget]] ===<br />
Shows or hides all SD lines on the Budget Sheet<br />
<br />
=== [[Show Zeros Budget]] ===<br />
Shows or hides all Zeros lines on the Budget Sheet<br />
<br />
=== [[Show HD Budget]] ===<br />
Shows or hides all HD lines on the Budget Sheet</div>ASamoilhttps://thewiki.builtplainly.com/index.php?title=Report_and_Others&diff=1084Report and Others2022-07-11T21:56:52Z<p>ASamoil: /* Breakdown */</p>
<hr />
<div>[[File:ReportAndReview1.3.0.6.png|frame|center|link=]]<br />
<br />
= Report and Review =<br />
== General Settings ==<br />
<br />
=== [[Show LBR]] ===<br />
Shows or Hides HD's on the Summary Page<br />
<br />
=== [[Show IND]] ===<br />
Shows or Hides HD's on the Summary Page<br />
<br />
=== [[Freeze Top]] ===<br />
Freezes the Top few lines so they stay with you as you scroll<br />
<br />
=== [[Change Theme]] ===<br />
Changes the Current Workbook Theme<br />
<br />
=== [[Set Page Breaks]] ===<br />
Sets the Page Breaks for the Workbook<br />
<br />
=== [[Set Page Breaks|Set Page]] ===<br />
Sets the Page Break for the Current Worksheet<br />
<br />
== Summary Settings ==<br />
<br />
=== [[Show SD]] ===<br />
Shows or Hides SD's on the Summary Page<br />
<br />
=== [[Show HD]] ===<br />
Shows or Hides HD's on the Summary Page<br />
<br />
=== [[Show Zeros]] ===<br />
Show or Hides Zeros on the Summary Page<br />
<br />
<br />
<br />
=== [[Extra Summary Data]] ===<br />
Adds extra lines to the bottom of the Summary Page<br />
<br />
=== [[Extra Summary CM]] ===<br />
Adds extra comments to the bottom of the Summary Page<br />
<br />
=== [[Scratch Sheet]] ===<br />
Will create a blank worksheet that can be used for anything<br />
<br />
== Worksheet Settings ==<br />
<br />
=== [[Show Bond]] ===<br />
Enables or Disables the Bond Column<br />
<br />
=== [[Add End Line]] ===<br />
Adds a line at the end of a Div sheet to show that its the end<br />
<br />
=== [[Approve WS]] ===<br />
Changes the Tab Color of the Worksheet to Green/Approved<br />
<br />
== Breakdown ==<br />
<br />
=== [[Enable B.D.]] ===<br />
Hides and Unhides the Breakdown (Alpha Label) Column on Div's<br />
<br />
=== [[Make B.D.]] ===<br />
Creates a Breakdown Sheet if One does not already exist<br />
* Must have Enable B.D. Enabled<br />
<br />
=== [[Add User Item]] ===<br />
Adds a New User Added Item<br />
* Only on Summary, Recoverable and BreakDown Pages<br />
<br />
== More ==<br />
<br />
=== [[Re-Calc WB]] ===<br />
Re-Calculates the entire Workbook<br />
<br />
=== [[PrintToPDF]] ===<br />
Prints the Workbook to a Pdf<br />
<br />
=== [[Reformat]] ===<br />
Reformats the Page to its Intended State<br />
* Only works for Div's<br />
<br />
==== Reformat Workbook ====<br />
Reformats the Entire Workbook<br />
<br />
== Recap ==<br />
<br />
=== [[Select Material]] ===<br />
Sets the selected material value from the recap section into the Div<br />
<br />
=== [[Select Subtrade]] ===<br />
Sets the selected subtrade value from the recap section into the Div<br />
<br />
=== [[Full Recap]] ===<br />
Hides Div Cols and Shows Recap Section simutanously<br />
<br />
=== [[Hide Div Cols]] ===<br />
Hides all unnecessary Div Cols for Recap <br />
<br />
=== [[Show Recap]] ===<br />
Shows/Hides the Recap Section<br />
<br />
== Budget Summary Options ==<br />
<br />
=== [[Budget Sheet]] ===<br />
Creates a budget sheet between two different workbooks (the current one and another one)<br />
<br />
=== [[Show SD Budget]] ===<br />
Shows or hides all SD lines on the Budget Sheet<br />
<br />
=== [[Show Zeros Budget]] ===<br />
Shows or hides all Zeros lines on the Budget Sheet<br />
<br />
=== [[Show HD Budget]] ===<br />
Shows or hides all HD lines on the Budget Sheet</div>ASamoilhttps://thewiki.builtplainly.com/index.php?title=Est_Tool_Tab&diff=1083Est Tool Tab2022-07-11T21:56:44Z<p>ASamoil: /* Breakdown */</p>
<hr />
<div>[[File:EstToolTabRibbon1.2.0.6.png|center|frame|EstToolTab Ribbon|link=]]<br />
<br />
<br />
__TOC__<br />
<br />
<br />
[[File:EstToolTabRibbon1.2.0.6.png|center|frame|EstToolTab Ribbon|link=]]<br />
<br />
<br />
== Insert / Convert ==<br />
[[File:InsertConvertRibbon.png|right]]<br />
=== [[Insert Cost Line]] ===<br />
Inserts an Empty CostLine below the Line in which the user has currently selected<br />
<br />
=== [[Insert Cost Detail]] ===<br />
Inserts an Empty CostDetail below the Line in which the user has currently selected<br />
<br />
=== [[Insert Comment x3]] ===<br />
Inserts 3 Empty Comments below the Line in which the user has currently selected<br />
<br />
=== [[Insert Staff]] ===<br />
Inserts an Empty Staff Line below the Line in which the user has currently selected<br />
<br />
=== [[Insert Space Line]] ===<br />
Inserts an Empty Space below the Line in which the user has currently selected<br />
<br />
=== [[Insert Header]] ===<br />
Inserts an Header Line below the Line in which the user has currently selected<br />
<br />
=== [[Insert SubDivision]] ===<br />
Inserts an SubDivision Line below the Line in which the user has currently selected<br />
<br />
=== Convert To Comment ===<br />
==== [[Convert To Comment]] ====<br />
Converts all CostDetail Lines within the range to Comments and Re-Calculates the Page<br />
<br />
==== [[Resurrect]] ====<br />
Brings Commented out CD's back to life!<br />
<br />
==== [[Convert CL To ST]] ====<br />
If a CostLine has no CostDetails related to it, this will convert all CostLines within the rage to ST<br />
<br />
=== [[Comments]] ===<br />
Hides & UnHides all Comments<br />
* You Can only Add Comments if Comments are Unhidden<br />
<br />
=== [[Zeros]] ===<br />
Hides & UnHides all Lines with 0 Total Value<br />
* You Can only Add Lines if Zeros are Unhidden<br />
<br />
=== [[CM Rate]] ===<br />
Swaps the Class Rates between CM & LS<br />
<br />
=== [[Plug]] ===<br />
Changes Cells in the selected range to the Plug Colour<br />
<br />
=== [[Quote]] ===<br />
Changes Cells in the selected range to the Quote Colour<br />
<br />
=== [[Clear]] ===<br />
Removes the background colour of Cells in the selected range<br />
<br />
== Unit / Labour ==<br />
=== [[Unit]] ===<br />
Drop Down Menu that allows the user to change the current Unit on the Line Selected<br />
<br />
=== [[Class]] ===<br />
Drop Down Menu that allows the user to change the current Class on the Line(s) Selected<br />
<br />
=== [[Change Rates]] ===<br />
Pop-Up Window that allows the user to change the current Rates being used in the current workbook<br />
<br />
See [[Rate Table Guide]] for more information on usage<br />
<br />
== Financials ==<br />
<br />
=== [[Tender Eval]] ===<br />
Displays a Pop-Up window in which you can change the Tender Eval info<br />
<br />
=== [[Project Info]] ===<br />
Displays a Pop-Up window in which you can change the Project Info<br />
<br />
See [[Project Info Guide]] for more information on usage<br />
<br />
=== [[Calculate Recoverable]] ===<br />
Sheet Selector Pop-Up Appears and the User Selects Pages to be recoverabled upon. <br />
Creates a Recoverable Sheet based on the pages selected<br />
<br />
=== [[Project Total]] ===<br />
Dynamic Sum of the Project Total<br />
<br />
=== [[Project Total|Fee]] ===<br />
Dynamic Sum of the Fee Total<br />
<br />
=== [[Project Total|Insurance]] ===<br />
Dynamic Sum of the Insurance Costs<br />
<br />
== Bid Close ==<br />
=== [[Tag Line]] ===<br />
Tag's a line so that it can be used in the BidClose Form<br />
<br />
=== [[Un-Tag Line]] ===<br />
Un-Tag's a line and removes it from the BidClose Form<br />
<br />
==== [[Un-Tag All]] ====<br />
Un-Tag's every single line in the Workbook<br />
<br />
=== [[Bid Close Form]] ===<br />
Displays a Pop-up window inwhich the user can change tagged lines without being on the worksheet<br />
<br />
== Copy / Paste ==<br />
<br />
=== [[Copy Section]] ===<br />
Copies the Section of the row selected<br />
<br />
=== [[Copy Section|Paste Section]] ===<br />
Pastes the Copied Section below the row selected<br />
<br />
=== [[Copy Div]] ===<br />
Creates a Copy of the Current Div based on the Name given by the User<br />
<br />
== Redemption ==<br />
<br />
=== [[Undo]] ===<br />
Undo's the Last Action<br />
* Only works on Div's<br />
* Once you leave a page, you can no longer Undo<br />
<br />
=== [[Rearrange Worksheets]] ===<br />
Allows User to Rearrange Worksheets via a Pop-Up Menu<br />
<br />
=== [[Delete Sheet]] ===<br />
Delete's a Sheet from the workbook<br />
<br />
=== [[Delete Line]] ===<br />
Delete's a Line/Section from the worksheet<br />
* Only works on Div's<br />
<br />
==== [[Delete Section]] ====<br />
Delete's an entire section from the Div<br />
<br />
== Extras ==<br />
=== [[Extras]] ===<br />
Debug Features<br />
<br />
=== [[Help]] ===<br />
Re-directs the user to the Synwiki Website<br />
<br />
=== [[Updates And Info]] ===<br />
Displays a Form giving the latest updates/info/Dev Team<br />
<br />
=== [[Show/Hide Hiddens]] ===<br />
Shows or Hides the Hidden Worksheets<br />
<br />
=== Pro/UnPro ===<br />
Protects or Unprotects the Workbook<br />
<br />
=== [[EnableDebug]] ===<br />
Enables or Disables Sheet Change or Sheet Activate</div>ASamoilhttps://thewiki.builtplainly.com/index.php?title=Report_and_Others&diff=1082Report and Others2022-07-11T21:36:16Z<p>ASamoil: /* Worksheet Settings */</p>
<hr />
<div>[[File:ReportAndReview1.3.0.6.png|frame|center|link=]]<br />
<br />
= Report and Review =<br />
== General Settings ==<br />
<br />
=== [[Show LBR]] ===<br />
Shows or Hides HD's on the Summary Page<br />
<br />
=== [[Show IND]] ===<br />
Shows or Hides HD's on the Summary Page<br />
<br />
=== [[Freeze Top]] ===<br />
Freezes the Top few lines so they stay with you as you scroll<br />
<br />
=== [[Change Theme]] ===<br />
Changes the Current Workbook Theme<br />
<br />
=== [[Set Page Breaks]] ===<br />
Sets the Page Breaks for the Workbook<br />
<br />
=== [[Set Page Breaks|Set Page]] ===<br />
Sets the Page Break for the Current Worksheet<br />
<br />
== Summary Settings ==<br />
<br />
=== [[Show SD]] ===<br />
Shows or Hides SD's on the Summary Page<br />
<br />
=== [[Show HD]] ===<br />
Shows or Hides HD's on the Summary Page<br />
<br />
=== [[Show Zeros]] ===<br />
Show or Hides Zeros on the Summary Page<br />
<br />
<br />
<br />
=== [[Extra Summary Data]] ===<br />
Adds extra lines to the bottom of the Summary Page<br />
<br />
=== [[Extra Summary CM]] ===<br />
Adds extra comments to the bottom of the Summary Page<br />
<br />
=== [[Scratch Sheet]] ===<br />
Will create a blank worksheet that can be used for anything<br />
<br />
== Worksheet Settings ==<br />
<br />
=== [[Show Bond]] ===<br />
Enables or Disables the Bond Column<br />
<br />
=== [[Add End Line]] ===<br />
Adds a line at the end of a Div sheet to show that its the end<br />
<br />
=== [[Approve WS]] ===<br />
Changes the Tab Color of the Worksheet to Green/Approved<br />
<br />
== Breakdown ==<br />
<br />
== More ==<br />
<br />
=== [[Re-Calc WB]] ===<br />
Re-Calculates the entire Workbook<br />
<br />
=== [[PrintToPDF]] ===<br />
Prints the Workbook to a Pdf<br />
<br />
=== [[Reformat]] ===<br />
Reformats the Page to its Intended State<br />
* Only works for Div's<br />
<br />
==== Reformat Workbook ====<br />
Reformats the Entire Workbook<br />
<br />
== Recap ==<br />
<br />
=== [[Select Material]] ===<br />
Sets the selected material value from the recap section into the Div<br />
<br />
=== [[Select Subtrade]] ===<br />
Sets the selected subtrade value from the recap section into the Div<br />
<br />
=== [[Full Recap]] ===<br />
Hides Div Cols and Shows Recap Section simutanously<br />
<br />
=== [[Hide Div Cols]] ===<br />
Hides all unnecessary Div Cols for Recap <br />
<br />
=== [[Show Recap]] ===<br />
Shows/Hides the Recap Section<br />
<br />
== Budget Summary Options ==<br />
<br />
=== [[Budget Sheet]] ===<br />
Creates a budget sheet between two different workbooks (the current one and another one)<br />
<br />
=== [[Show SD Budget]] ===<br />
Shows or hides all SD lines on the Budget Sheet<br />
<br />
=== [[Show Zeros Budget]] ===<br />
Shows or hides all Zeros lines on the Budget Sheet<br />
<br />
=== [[Show HD Budget]] ===<br />
Shows or hides all HD lines on the Budget Sheet</div>ASamoilhttps://thewiki.builtplainly.com/index.php?title=Report_and_Others&diff=1081Report and Others2022-07-11T21:30:25Z<p>ASamoil: /* Summary Settings */</p>
<hr />
<div>[[File:ReportAndReview1.3.0.6.png|frame|center|link=]]<br />
<br />
= Report and Review =<br />
== General Settings ==<br />
<br />
=== [[Show LBR]] ===<br />
Shows or Hides HD's on the Summary Page<br />
<br />
=== [[Show IND]] ===<br />
Shows or Hides HD's on the Summary Page<br />
<br />
=== [[Freeze Top]] ===<br />
Freezes the Top few lines so they stay with you as you scroll<br />
<br />
=== [[Change Theme]] ===<br />
Changes the Current Workbook Theme<br />
<br />
=== [[Set Page Breaks]] ===<br />
Sets the Page Breaks for the Workbook<br />
<br />
=== [[Set Page Breaks|Set Page]] ===<br />
Sets the Page Break for the Current Worksheet<br />
<br />
== Summary Settings ==<br />
<br />
=== [[Show SD]] ===<br />
Shows or Hides SD's on the Summary Page<br />
<br />
=== [[Show HD]] ===<br />
Shows or Hides HD's on the Summary Page<br />
<br />
=== [[Show Zeros]] ===<br />
Show or Hides Zeros on the Summary Page<br />
<br />
<br />
<br />
=== [[Extra Summary Data]] ===<br />
Adds extra lines to the bottom of the Summary Page<br />
<br />
=== [[Extra Summary CM]] ===<br />
Adds extra comments to the bottom of the Summary Page<br />
<br />
=== [[Scratch Sheet]] ===<br />
Will create a blank worksheet that can be used for anything<br />
<br />
== Worksheet Settings ==<br />
<br />
=== [[Show Bond]] ===<br />
Enables or Disables the Bond Column<br />
<br />
=== [[Approve WS]] ===<br />
Changes the Tab Color of the Worksheet to Green/Approved<br />
<br />
== Breakdown ==<br />
<br />
== More ==<br />
<br />
=== [[Re-Calc WB]] ===<br />
Re-Calculates the entire Workbook<br />
<br />
=== [[PrintToPDF]] ===<br />
Prints the Workbook to a Pdf<br />
<br />
=== [[Reformat]] ===<br />
Reformats the Page to its Intended State<br />
* Only works for Div's<br />
<br />
==== Reformat Workbook ====<br />
Reformats the Entire Workbook<br />
<br />
== Recap ==<br />
<br />
=== [[Select Material]] ===<br />
Sets the selected material value from the recap section into the Div<br />
<br />
=== [[Select Subtrade]] ===<br />
Sets the selected subtrade value from the recap section into the Div<br />
<br />
=== [[Full Recap]] ===<br />
Hides Div Cols and Shows Recap Section simutanously<br />
<br />
=== [[Hide Div Cols]] ===<br />
Hides all unnecessary Div Cols for Recap <br />
<br />
=== [[Show Recap]] ===<br />
Shows/Hides the Recap Section<br />
<br />
== Budget Summary Options ==<br />
<br />
=== [[Budget Sheet]] ===<br />
Creates a budget sheet between two different workbooks (the current one and another one)<br />
<br />
=== [[Show SD Budget]] ===<br />
Shows or hides all SD lines on the Budget Sheet<br />
<br />
=== [[Show Zeros Budget]] ===<br />
Shows or hides all Zeros lines on the Budget Sheet<br />
<br />
=== [[Show HD Budget]] ===<br />
Shows or hides all HD lines on the Budget Sheet</div>ASamoilhttps://thewiki.builtplainly.com/index.php?title=Report_and_Others&diff=1080Report and Others2022-07-11T21:29:37Z<p>ASamoil: /* Worksheet Settings */</p>
<hr />
<div>[[File:ReportAndReview1.3.0.6.png|frame|center|link=]]<br />
<br />
= Report and Review =<br />
== General Settings ==<br />
<br />
=== [[Show LBR]] ===<br />
Shows or Hides HD's on the Summary Page<br />
<br />
=== [[Show IND]] ===<br />
Shows or Hides HD's on the Summary Page<br />
<br />
=== [[Freeze Top]] ===<br />
Freezes the Top few lines so they stay with you as you scroll<br />
<br />
=== [[Change Theme]] ===<br />
Changes the Current Workbook Theme<br />
<br />
=== [[Set Page Breaks]] ===<br />
Sets the Page Breaks for the Workbook<br />
<br />
=== [[Set Page Breaks|Set Page]] ===<br />
Sets the Page Break for the Current Worksheet<br />
<br />
== Summary Settings ==<br />
<br />
=== [[Show SD]] ===<br />
Shows or Hides SD's on the Summary Page<br />
<br />
=== [[Show HD]] ===<br />
Shows or Hides HD's on the Summary Page<br />
<br />
=== [[Show Zeros]] ===<br />
Show or Hides Zeros on the Summary Page<br />
<br />
== Worksheet Settings ==<br />
<br />
=== [[Show Bond]] ===<br />
Enables or Disables the Bond Column<br />
<br />
=== [[Approve WS]] ===<br />
Changes the Tab Color of the Worksheet to Green/Approved<br />
<br />
== Breakdown ==<br />
<br />
== More ==<br />
<br />
=== [[Re-Calc WB]] ===<br />
Re-Calculates the entire Workbook<br />
<br />
=== [[PrintToPDF]] ===<br />
Prints the Workbook to a Pdf<br />
<br />
=== [[Reformat]] ===<br />
Reformats the Page to its Intended State<br />
* Only works for Div's<br />
<br />
==== Reformat Workbook ====<br />
Reformats the Entire Workbook<br />
<br />
== Recap ==<br />
<br />
=== [[Select Material]] ===<br />
Sets the selected material value from the recap section into the Div<br />
<br />
=== [[Select Subtrade]] ===<br />
Sets the selected subtrade value from the recap section into the Div<br />
<br />
=== [[Full Recap]] ===<br />
Hides Div Cols and Shows Recap Section simutanously<br />
<br />
=== [[Hide Div Cols]] ===<br />
Hides all unnecessary Div Cols for Recap <br />
<br />
=== [[Show Recap]] ===<br />
Shows/Hides the Recap Section<br />
<br />
== Budget Summary Options ==<br />
<br />
=== [[Budget Sheet]] ===<br />
Creates a budget sheet between two different workbooks (the current one and another one)<br />
<br />
=== [[Show SD Budget]] ===<br />
Shows or hides all SD lines on the Budget Sheet<br />
<br />
=== [[Show Zeros Budget]] ===<br />
Shows or hides all Zeros lines on the Budget Sheet<br />
<br />
=== [[Show HD Budget]] ===<br />
Shows or hides all HD lines on the Budget Sheet</div>ASamoilhttps://thewiki.builtplainly.com/index.php?title=Report_and_Others&diff=1079Report and Others2022-07-11T21:29:02Z<p>ASamoil: /* More */</p>
<hr />
<div>[[File:ReportAndReview1.3.0.6.png|frame|center|link=]]<br />
<br />
= Report and Review =<br />
== General Settings ==<br />
<br />
=== [[Show LBR]] ===<br />
Shows or Hides HD's on the Summary Page<br />
<br />
=== [[Show IND]] ===<br />
Shows or Hides HD's on the Summary Page<br />
<br />
=== [[Freeze Top]] ===<br />
Freezes the Top few lines so they stay with you as you scroll<br />
<br />
=== [[Change Theme]] ===<br />
Changes the Current Workbook Theme<br />
<br />
=== [[Set Page Breaks]] ===<br />
Sets the Page Breaks for the Workbook<br />
<br />
=== [[Set Page Breaks|Set Page]] ===<br />
Sets the Page Break for the Current Worksheet<br />
<br />
== Summary Settings ==<br />
<br />
=== [[Show SD]] ===<br />
Shows or Hides SD's on the Summary Page<br />
<br />
=== [[Show HD]] ===<br />
Shows or Hides HD's on the Summary Page<br />
<br />
=== [[Show Zeros]] ===<br />
Show or Hides Zeros on the Summary Page<br />
<br />
== Worksheet Settings ==<br />
<br />
=== [[Show Bond]] ===<br />
Enables or Disables the Bond Column<br />
<br />
== Breakdown ==<br />
<br />
== More ==<br />
<br />
=== [[Re-Calc WB]] ===<br />
Re-Calculates the entire Workbook<br />
<br />
=== [[PrintToPDF]] ===<br />
Prints the Workbook to a Pdf<br />
<br />
=== [[Reformat]] ===<br />
Reformats the Page to its Intended State<br />
* Only works for Div's<br />
<br />
==== Reformat Workbook ====<br />
Reformats the Entire Workbook<br />
<br />
== Recap ==<br />
<br />
=== [[Select Material]] ===<br />
Sets the selected material value from the recap section into the Div<br />
<br />
=== [[Select Subtrade]] ===<br />
Sets the selected subtrade value from the recap section into the Div<br />
<br />
=== [[Full Recap]] ===<br />
Hides Div Cols and Shows Recap Section simutanously<br />
<br />
=== [[Hide Div Cols]] ===<br />
Hides all unnecessary Div Cols for Recap <br />
<br />
=== [[Show Recap]] ===<br />
Shows/Hides the Recap Section<br />
<br />
== Budget Summary Options ==<br />
<br />
=== [[Budget Sheet]] ===<br />
Creates a budget sheet between two different workbooks (the current one and another one)<br />
<br />
=== [[Show SD Budget]] ===<br />
Shows or hides all SD lines on the Budget Sheet<br />
<br />
=== [[Show Zeros Budget]] ===<br />
Shows or hides all Zeros lines on the Budget Sheet<br />
<br />
=== [[Show HD Budget]] ===<br />
Shows or hides all HD lines on the Budget Sheet</div>ASamoilhttps://thewiki.builtplainly.com/index.php?title=Report_and_Others&diff=1078Report and Others2022-07-11T21:28:14Z<p>ASamoil: /* More */</p>
<hr />
<div>[[File:ReportAndReview1.3.0.6.png|frame|center|link=]]<br />
<br />
= Report and Review =<br />
== General Settings ==<br />
<br />
=== [[Show LBR]] ===<br />
Shows or Hides HD's on the Summary Page<br />
<br />
=== [[Show IND]] ===<br />
Shows or Hides HD's on the Summary Page<br />
<br />
=== [[Freeze Top]] ===<br />
Freezes the Top few lines so they stay with you as you scroll<br />
<br />
=== [[Change Theme]] ===<br />
Changes the Current Workbook Theme<br />
<br />
=== [[Set Page Breaks]] ===<br />
Sets the Page Breaks for the Workbook<br />
<br />
=== [[Set Page Breaks|Set Page]] ===<br />
Sets the Page Break for the Current Worksheet<br />
<br />
== Summary Settings ==<br />
<br />
=== [[Show SD]] ===<br />
Shows or Hides SD's on the Summary Page<br />
<br />
=== [[Show HD]] ===<br />
Shows or Hides HD's on the Summary Page<br />
<br />
=== [[Show Zeros]] ===<br />
Show or Hides Zeros on the Summary Page<br />
<br />
== Worksheet Settings ==<br />
<br />
=== [[Show Bond]] ===<br />
Enables or Disables the Bond Column<br />
<br />
== Breakdown ==<br />
<br />
== More ==<br />
<br />
=== [[Scratch Sheet]] ===<br />
Will create a blank worksheet that can be used for anything<br />
<br />
=== [[Approve WS]] ===<br />
Changes the Tab Color of the Worksheet to Green/Approved<br />
<br />
=== [[Extra Summary Data]] ===<br />
Adds extra lines to the bottom of the Summary Page<br />
<br />
=== [[Re-Calc WB]] ===<br />
Re-Calculates the entire Workbook<br />
<br />
=== [[PrintToPDF]] ===<br />
Prints the Workbook to a Pdf<br />
<br />
=== [[Reformat]] ===<br />
Reformats the Page to its Intended State<br />
* Only works for Div's<br />
<br />
==== Reformat Workbook ====<br />
Reformats the Entire Workbook<br />
<br />
== Recap ==<br />
<br />
=== [[Select Material]] ===<br />
Sets the selected material value from the recap section into the Div<br />
<br />
=== [[Select Subtrade]] ===<br />
Sets the selected subtrade value from the recap section into the Div<br />
<br />
=== [[Full Recap]] ===<br />
Hides Div Cols and Shows Recap Section simutanously<br />
<br />
=== [[Hide Div Cols]] ===<br />
Hides all unnecessary Div Cols for Recap <br />
<br />
=== [[Show Recap]] ===<br />
Shows/Hides the Recap Section<br />
<br />
== Budget Summary Options ==<br />
<br />
=== [[Budget Sheet]] ===<br />
Creates a budget sheet between two different workbooks (the current one and another one)<br />
<br />
=== [[Show SD Budget]] ===<br />
Shows or hides all SD lines on the Budget Sheet<br />
<br />
=== [[Show Zeros Budget]] ===<br />
Shows or hides all Zeros lines on the Budget Sheet<br />
<br />
=== [[Show HD Budget]] ===<br />
Shows or hides all HD lines on the Budget Sheet</div>ASamoilhttps://thewiki.builtplainly.com/index.php?title=Est_Tool_Tab&diff=1077Est Tool Tab2022-07-11T21:27:52Z<p>ASamoil: /* Redemption */</p>
<hr />
<div>[[File:EstToolTabRibbon1.2.0.6.png|center|frame|EstToolTab Ribbon|link=]]<br />
<br />
<br />
__TOC__<br />
<br />
<br />
[[File:EstToolTabRibbon1.2.0.6.png|center|frame|EstToolTab Ribbon|link=]]<br />
<br />
<br />
== Insert / Convert ==<br />
[[File:InsertConvertRibbon.png|right]]<br />
=== [[Insert Cost Line]] ===<br />
Inserts an Empty CostLine below the Line in which the user has currently selected<br />
<br />
=== [[Insert Cost Detail]] ===<br />
Inserts an Empty CostDetail below the Line in which the user has currently selected<br />
<br />
=== [[Insert Comment x3]] ===<br />
Inserts 3 Empty Comments below the Line in which the user has currently selected<br />
<br />
=== [[Insert Staff]] ===<br />
Inserts an Empty Staff Line below the Line in which the user has currently selected<br />
<br />
=== [[Insert Space Line]] ===<br />
Inserts an Empty Space below the Line in which the user has currently selected<br />
<br />
=== [[Insert Header]] ===<br />
Inserts an Header Line below the Line in which the user has currently selected<br />
<br />
=== [[Insert SubDivision]] ===<br />
Inserts an SubDivision Line below the Line in which the user has currently selected<br />
<br />
=== Convert To Comment ===<br />
==== [[Convert To Comment]] ====<br />
Converts all CostDetail Lines within the range to Comments and Re-Calculates the Page<br />
<br />
==== [[Resurrect]] ====<br />
Brings Commented out CD's back to life!<br />
<br />
==== [[Convert CL To ST]] ====<br />
If a CostLine has no CostDetails related to it, this will convert all CostLines within the rage to ST<br />
<br />
=== [[Comments]] ===<br />
Hides & UnHides all Comments<br />
* You Can only Add Comments if Comments are Unhidden<br />
<br />
=== [[Zeros]] ===<br />
Hides & UnHides all Lines with 0 Total Value<br />
* You Can only Add Lines if Zeros are Unhidden<br />
<br />
=== [[CM Rate]] ===<br />
Swaps the Class Rates between CM & LS<br />
<br />
=== [[Plug]] ===<br />
Changes Cells in the selected range to the Plug Colour<br />
<br />
=== [[Quote]] ===<br />
Changes Cells in the selected range to the Quote Colour<br />
<br />
=== [[Clear]] ===<br />
Removes the background colour of Cells in the selected range<br />
<br />
== Unit / Labour ==<br />
=== [[Unit]] ===<br />
Drop Down Menu that allows the user to change the current Unit on the Line Selected<br />
<br />
=== [[Class]] ===<br />
Drop Down Menu that allows the user to change the current Class on the Line(s) Selected<br />
<br />
=== [[Change Rates]] ===<br />
Pop-Up Window that allows the user to change the current Rates being used in the current workbook<br />
<br />
See [[Rate Table Guide]] for more information on usage<br />
<br />
== Financials ==<br />
<br />
=== [[Tender Eval]] ===<br />
Displays a Pop-Up window in which you can change the Tender Eval info<br />
<br />
=== [[Project Info]] ===<br />
Displays a Pop-Up window in which you can change the Project Info<br />
<br />
See [[Project Info Guide]] for more information on usage<br />
<br />
=== [[Calculate Recoverable]] ===<br />
Sheet Selector Pop-Up Appears and the User Selects Pages to be recoverabled upon. <br />
Creates a Recoverable Sheet based on the pages selected<br />
<br />
=== [[Project Total]] ===<br />
Dynamic Sum of the Project Total<br />
<br />
=== [[Project Total|Fee]] ===<br />
Dynamic Sum of the Fee Total<br />
<br />
=== [[Project Total|Insurance]] ===<br />
Dynamic Sum of the Insurance Costs<br />
<br />
== Bid Close ==<br />
=== [[Tag Line]] ===<br />
Tag's a line so that it can be used in the BidClose Form<br />
<br />
=== [[Un-Tag Line]] ===<br />
Un-Tag's a line and removes it from the BidClose Form<br />
<br />
==== [[Un-Tag All]] ====<br />
Un-Tag's every single line in the Workbook<br />
<br />
=== [[Bid Close Form]] ===<br />
Displays a Pop-up window inwhich the user can change tagged lines without being on the worksheet<br />
<br />
== Copy / Paste ==<br />
<br />
=== [[Copy Section]] ===<br />
Copies the Section of the row selected<br />
<br />
=== [[Copy Section|Paste Section]] ===<br />
Pastes the Copied Section below the row selected<br />
<br />
=== [[Copy Div]] ===<br />
Creates a Copy of the Current Div based on the Name given by the User<br />
<br />
== Breakdown ==<br />
<br />
=== [[Enable B.D.]] ===<br />
Hides and Unhides the Breakdown (Alpha Label) Column on Div's<br />
<br />
=== [[Make B.D.]] ===<br />
Creates a Breakdown Sheet if One does not already exist<br />
* Must have Enable B.D. Enabled<br />
<br />
=== [[Add User Item]] ===<br />
Adds a New User Added Item<br />
* Only on Summary, Recoverable and BreakDown Pages<br />
<br />
== Redemption ==<br />
<br />
=== [[Undo]] ===<br />
Undo's the Last Action<br />
* Only works on Div's<br />
* Once you leave a page, you can no longer Undo<br />
<br />
=== [[Rearrange Worksheets]] ===<br />
Allows User to Rearrange Worksheets via a Pop-Up Menu<br />
<br />
=== [[Delete Sheet]] ===<br />
Delete's a Sheet from the workbook<br />
<br />
=== [[Delete Line]] ===<br />
Delete's a Line/Section from the worksheet<br />
* Only works on Div's<br />
<br />
==== [[Delete Section]] ====<br />
Delete's an entire section from the Div<br />
<br />
== Extras ==<br />
=== [[Extras]] ===<br />
Debug Features<br />
<br />
=== [[Help]] ===<br />
Re-directs the user to the Synwiki Website<br />
<br />
=== [[Updates And Info]] ===<br />
Displays a Form giving the latest updates/info/Dev Team<br />
<br />
=== [[Show/Hide Hiddens]] ===<br />
Shows or Hides the Hidden Worksheets<br />
<br />
=== Pro/UnPro ===<br />
Protects or Unprotects the Workbook<br />
<br />
=== [[EnableDebug]] ===<br />
Enables or Disables Sheet Change or Sheet Activate</div>ASamoilhttps://thewiki.builtplainly.com/index.php?title=Report_and_Others&diff=1076Report and Others2022-07-11T21:11:37Z<p>ASamoil: /* More */</p>
<hr />
<div>[[File:ReportAndReview1.3.0.6.png|frame|center|link=]]<br />
<br />
= Report and Review =<br />
== General Settings ==<br />
<br />
=== [[Show LBR]] ===<br />
Shows or Hides HD's on the Summary Page<br />
<br />
=== [[Show IND]] ===<br />
Shows or Hides HD's on the Summary Page<br />
<br />
=== [[Freeze Top]] ===<br />
Freezes the Top few lines so they stay with you as you scroll<br />
<br />
=== [[Change Theme]] ===<br />
Changes the Current Workbook Theme<br />
<br />
=== [[Set Page Breaks]] ===<br />
Sets the Page Breaks for the Workbook<br />
<br />
=== [[Set Page Breaks|Set Page]] ===<br />
Sets the Page Break for the Current Worksheet<br />
<br />
== Summary Settings ==<br />
<br />
=== [[Show SD]] ===<br />
Shows or Hides SD's on the Summary Page<br />
<br />
=== [[Show HD]] ===<br />
Shows or Hides HD's on the Summary Page<br />
<br />
=== [[Show Zeros]] ===<br />
Show or Hides Zeros on the Summary Page<br />
<br />
== Worksheet Settings ==<br />
<br />
=== [[Show Bond]] ===<br />
Enables or Disables the Bond Column<br />
<br />
== Breakdown ==<br />
<br />
== More ==<br />
<br />
=== [[Scratch Sheet]] ===<br />
Will create a blank worksheet that can be used for anything<br />
<br />
=== [[Approve WS]] ===<br />
Changes the Tab Color of the Worksheet to Green/Approved<br />
<br />
=== [[Extra Summary Data]] ===<br />
Adds extra lines to the bottom of the Summary Page<br />
<br />
=== [[Re-Calc WB]] ===<br />
Re-Calculates the entire Workbook<br />
<br />
=== [[PrintToPDF]] ===<br />
Prints the Workbook to a Pdf<br />
<br />
== Recap ==<br />
<br />
=== [[Select Material]] ===<br />
Sets the selected material value from the recap section into the Div<br />
<br />
=== [[Select Subtrade]] ===<br />
Sets the selected subtrade value from the recap section into the Div<br />
<br />
=== [[Full Recap]] ===<br />
Hides Div Cols and Shows Recap Section simutanously<br />
<br />
=== [[Hide Div Cols]] ===<br />
Hides all unnecessary Div Cols for Recap <br />
<br />
=== [[Show Recap]] ===<br />
Shows/Hides the Recap Section<br />
<br />
== Budget Summary Options ==<br />
<br />
=== [[Budget Sheet]] ===<br />
Creates a budget sheet between two different workbooks (the current one and another one)<br />
<br />
=== [[Show SD Budget]] ===<br />
Shows or hides all SD lines on the Budget Sheet<br />
<br />
=== [[Show Zeros Budget]] ===<br />
Shows or hides all Zeros lines on the Budget Sheet<br />
<br />
=== [[Show HD Budget]] ===<br />
Shows or hides all HD lines on the Budget Sheet</div>ASamoilhttps://thewiki.builtplainly.com/index.php?title=Report_and_Others&diff=1075Report and Others2022-07-11T21:03:53Z<p>ASamoil: </p>
<hr />
<div>[[File:ReportAndReview1.3.0.6.png|frame|center|link=]]<br />
<br />
= Report and Review =<br />
== General Settings ==<br />
<br />
=== [[Show LBR]] ===<br />
Shows or Hides HD's on the Summary Page<br />
<br />
=== [[Show IND]] ===<br />
Shows or Hides HD's on the Summary Page<br />
<br />
=== [[Freeze Top]] ===<br />
Freezes the Top few lines so they stay with you as you scroll<br />
<br />
=== [[Change Theme]] ===<br />
Changes the Current Workbook Theme<br />
<br />
=== [[Set Page Breaks]] ===<br />
Sets the Page Breaks for the Workbook<br />
<br />
=== [[Set Page Breaks|Set Page]] ===<br />
Sets the Page Break for the Current Worksheet<br />
<br />
== Summary Settings ==<br />
<br />
=== [[Show SD]] ===<br />
Shows or Hides SD's on the Summary Page<br />
<br />
=== [[Show HD]] ===<br />
Shows or Hides HD's on the Summary Page<br />
<br />
=== [[Show Zeros]] ===<br />
Show or Hides Zeros on the Summary Page<br />
<br />
== Worksheet Settings ==<br />
<br />
=== [[Show Bond]] ===<br />
Enables or Disables the Bond Column<br />
<br />
== Breakdown ==<br />
<br />
== More ==<br />
<br />
=== [[Scratch Sheet]] ===<br />
Will create a blank worksheet that can be used for anything<br />
<br />
=== [[Approve WS]] ===<br />
Changes the Tab Color of the Worksheet to Green/Approved<br />
<br />
<br />
=== [[Extra Summary Data]] ===<br />
Adds extra lines to the bottom of the Summary Page<br />
<br />
=== [[Re-Calc WB]] ===<br />
Re-Calculates the entire Workbook<br />
<br />
=== [[PrintToPDF]] ===<br />
Prints the Workbook to a Pdf<br />
<br />
== Recap ==<br />
<br />
=== [[Select Material]] ===<br />
Sets the selected material value from the recap section into the Div<br />
<br />
=== [[Select Subtrade]] ===<br />
Sets the selected subtrade value from the recap section into the Div<br />
<br />
=== [[Full Recap]] ===<br />
Hides Div Cols and Shows Recap Section simutanously<br />
<br />
=== [[Hide Div Cols]] ===<br />
Hides all unnecessary Div Cols for Recap <br />
<br />
=== [[Show Recap]] ===<br />
Shows/Hides the Recap Section<br />
<br />
== Budget Summary Options ==<br />
<br />
=== [[Budget Sheet]] ===<br />
Creates a budget sheet between two different workbooks (the current one and another one)<br />
<br />
=== [[Show SD Budget]] ===<br />
Shows or hides all SD lines on the Budget Sheet<br />
<br />
=== [[Show Zeros Budget]] ===<br />
Shows or hides all Zeros lines on the Budget Sheet<br />
<br />
=== [[Show HD Budget]] ===<br />
Shows or hides all HD lines on the Budget Sheet</div>ASamoilhttps://thewiki.builtplainly.com/index.php?title=Budget_Upload&diff=1006Budget Upload2022-06-10T15:54:22Z<p>ASamoil: /* Step 3: Pull All Estimate Data To One Page */</p>
<hr />
<div>== Introduction ==<br />
=== Objective: ===<br />
Establish a basic understanding and procedure for uploading budget from Estimate Template to Viewpoint.<br />
=== Agenda ===<br />
* Process diagram<br />
* Step by Step Tutorial<br />
* Buyout and adjust detail estimate<br />
* Consolidate detail estimate, fine tune code, units, descriptions<br />
* Export CSV file<br />
* Import CSV file to Viewpoint<br />
* Set up Billing<br />
== Tutorial ==<br />
=== What happens after a win? ===<br />
From operation standpoint we focus on the Estimate Review<br />
* Cost Code Clean Up<br />
* Consolidate Units<br />
* Review Cost and Bid<br />
* Buyout scopes<br />
* Identify contingency vs cash allowance<br />
* Any special agreement or alignment of trades<br />
* Etc.<br />
<br />
<sequencediagram style="modern-blue"><br />
Customer->Estimator: Award Project\nto Synergy<br />
Note over Estimator, Estimate\nTemplate : Reconcile Bids\nOrganize Bid Binder<br />
Estimator->Operation Team: Control Estimate (the Book)<br />
Estimator->Operation Team: Bid Binder<br />
Note over Estimator, Operation Team: Review Bid Strategy, Bids, Schedule\n(Turn Over Meeting)<br />
Note over Estimate\nTemplate, Operation Team:Review Estimate\nClean up Cost Code\nConsolidate Units\nReview Cost<br />
Estimate\nTemplate->Operation Team:Budget .CSV file<br />
Operation Team-> Viewpoint: Upload Budget <br />
</sequencediagram><br />
<br />
Then,<br />
# The entire estimate data after cleanup get poured into Viewpoint using a '''[https://en.wikipedia.org/wiki/Comma-separated_values .CSV file]'''.<br />
# The CSV file is structured specifically in a format Viewpoint can read using Import Estimate Module.<br />
=== Step-by-Step ===<br />
==== Within Estimate Work Book, you will need to do the following ====<br />
===== Step 1: Locate the "Tab" =====<br />
[[File:LocateTheTab.png|thumb|center|sample estimate workbook]]<br />
<br />
# Open the Estimate File received from Estimate Turn Over Meeting<br />
# Locate “Summary” and Division pages, drag and position those sheets to the front of all other sheets.<br />
# Locate “Est To VP” Tab, there are 6 buttons on this tab, each have their own corresponded functions. We will go through them in later pages.<br />
<br />
===== Step 2: Buy Out, Estimate Adjustment =====<br />
# Do your contract buy out.<br />
# During the buy out, modify the estimate file to match the scope that was bought into the trade’s scope.<br />
[[File:Budget Upload - Sample Buyout.png|thumb|sample buyout process]]<br />
# For the example that was shown here, the access panel and a few other scopes were estimated with own forces. During buy out, the drywaller agreed to take on those scopes for an additional cost. The number has been adjusted and moved to Subcontract Cost accordingly.<br />
# During buy out, if agreement were made for trades to take on certain additional scope for no or any cost, modify the estimate file to match the agreements.<br />
# Repeat this for all scopes pertains to the project.<br />
# In case any offsets from original contract value, we can add those after all the buy out to contingency, or book fee – pending on each project case.<br />
<br />
===== Step 3: Pull All Estimate Data To One Page =====<br />
# Locate the button called “Consolidate”. Click on it, will open a dialog allow you to select which page to include on pulling the Estimate Data Over.<br />
[[File:Consolidatebutton.png|thumb|consolidation button]]<br />
# In most cases, all pages from 1 to 16 will be selected.<br />
# However, if only a portion of the budget is getting uploaded, such as a change order, select only the page you want to upload.<br />
<br />
In the "Consolidation" worksheet, we can fine tune the cost codes, units, descriptions.<br />
An example is shown here. This page allows you to <br />
[[File:Sampleconsolidationpage.png|thumb|sample consolidation page]]<br />
<br />
* view which lines share the same cost code<br />
* Group or ungroup the cost lines by cost code<br />
* Adjusting unit of measure, quantities as needed.<br />
* This page does not allow modification to costs per se.<br />
'''Do''' <br />
* A quick check on each Division line and make sure the cost matches.<br />
* Remind yourself that any additional cost located on the summary page will not shown here – such as Insurance and Fee.<br />
'''Don’t'''<br />
* Try to change the format<br />
* Try to change the cost<br />
You can modify the description, unit of measure, quantity of the first line of the duplicated code so that the description make sense in your future forecast. In the example that’s shown, I have changed the description from “Orientation and Labour” to “Safety Equipment, Orientation and Labour” as this code contains both costlines. <br />
[[File:Budget Upload - Consolidation Description Change.png|frame|center]]<br />
The upload result of this example will be<br />
* Quantity of 20 with units of weeks<br />
* 140 hours of labour, $2,720+$5,600 for labour cost<br />
* $7,800 for material cost.<br />
* Repeat this for all cost lines.<br />
You can also combine or separate cost code for costlines. in this example, I have separated the cost code for flooring protection from the flooring subtrade. Doing so allows me to forecast easier during project execution phase. Do this as needed for all cost lines.<br />
<br />
Once you have gone thru all the cost lines, review with CM or OM if required. If you are comfortable with the consolidation and the PM has completed the above checks, you can begin to export to Viewpoint phase<br />
* Locate the “CSV Export” button, a dialog will show to let you save the CSV file generated for this estimate.<br />
* Modify the file name as needed, click “Save”.<br />
* It is recommended saving this file to the project folder, under “4 – Estimating”<br />
<br />
=== Est 2.0 CSV Creation method ===<br />
1. [[Consolidate]]<br />
<br />
yes zero no lead spaces<br />
2. [[CSV Export]]<br />
<br />
<br />
==== Import Estimate ====<br />
===== Do this using Viewpoint Import Estimate Program. =====<br />
Log into Viewpoint, Locate Module “PM Import Estimate” in Project Management – Program folder. Double Click to open the module.<br />
[[File:Budget Upload - Viewpoint Import Estimate Location.png|thumb|Locate Import Estimate Module]]<br />
<br />
This module contains a few different buttons.<br />
* Template Master lists all template that can be used to read the CSV file. We will not be touching this button.<br />
* Import Data lets you import the CSB file that was exported<br />
* Edit Work Tables lets you edit any imported budget table.<br />
* Upload into PM lets you pour the data into PM module, either as Original Estimate or as a Change Order to Existing Estimate.<br />
<br />
Click the Import Data, a window will pop open as the example shows.<br />
[[File:Budget Upload - Import Estimate Button.png|thumb|Import Estimate Button]]<br />
* For template, use SYN, this is the template made for Synergy to read a specific CSV format.<br />
* For “Import File 1:” field, click “Browse” button to the right, and select the CSV file that was exported.<br />
* For “Import ID” field, make a new Import ID, for example, you can use your initial + a number.<br />
* For Default Holdback Percentage, use 10%. <br />
* Click “Import” Button<br />
<br />
Viewpoint will be doing some work, if the project is big, in regards to amount of cost codes, it may take a minute or two. Once the file is imported, Viewpoint will prompt you a Message Box, sometimes it will say there are some errors. These errors are caused by non-standard cost code, or unit of measures that was used during estimating stage, or during consolidation stage.<br />
<br />
Click on the “Edit Work Tables” button, Viewpoint will open up a window, by default it will open the most recent import made by you. We will only be using the “Items”, “Phase”, “Cost Types” tabs.<br />
<br />
Some of the tab name is probably not familiar to you, translation:<br />
* Items – Contract Items, these are the items shows up on your billing. <br />
* Phases – Cost Codes, this tab allows you to adjust how the codes are linked with Contract Items. (you don’t have to change the links, the contract items and their amount are much easier to adjust in Job Cost – JC Contract Master module). <br />
* Cost Types – Cost Types of each cost code. This tab shows, for example the cost allocated in each cost type for each cost code.<br />
<br />
On the contract items tab, you can edit the contract Item descriptions here. I recommend to do it in JC – Contract Master module once the import is completed however.<br />
[[File:Budget Upload - Review Data Table.png|thumb|Review Data Table]]<br />
On the cost code tab, any error will be high lighted with red. Error on this tab typically is caused by the Cost Code does not existing in Master Cost Code list. Select the line with Error, double click the phase field to edit. Click F4 key on your keyboard to call out the cost code look up list, pick an appropriate code from the list. Once the code is picked, you can also add .xx.xx to it to make it more customized. For example, 12010.01. Click “Save” button, or Ctrl+S to save the change. Viewpoint will prompt you a dialog ask if it should create a phase cross reference record, '''make sure to select “NO”'''. If you accidentally clicked yes, let Siyuan know, the cross reference can be deleted from the template.<br />
<br />
Similar procedure for Cost Types tab. Viewpoint has a bug that even if you changed cost code on Phase tab, the Cost Types tab will still show the error (although the cost code is correct). To clear up the error, you will need to double click the cost code and type in the same code again. Similar procedure for Unit of Measure Error as well. Annoying I know, hopefully they fix that in the future. <br />
<br />
Once all errors are cleared up, you can click the “Upload into PM” button. Viewpoint will open a window for this. Defaulted to the most recent Data Table that you edited. In the Project field, put in the project number that this budget is going into. The Start Month – this is the effective month of your budget, not your project schedule start. For example, if you set the start month to 02/21, the budget you upload today will not shown in forecast till the February batch in 2021. Doesn’t matter if you interfaced to December 2020. The red text here is a warning, telling me there are existing cost code and cost ($0 count as well) in the project already. Uploading will have the budget accumulated. If this is the first time budget uploading to this project, it typically because some codes were opened up by accounting for insurance purposes.<br />
<br />
'''Always a good habit to check!!''' Locate in Job Cost – Programs, the JC Original Estimate module. Open it, you will see what's existing in your project, for both cost code, and budget. '''If you already have budget in the project, uploading will accumulate, instead of overwrite.'''<br />
<br />
Another Option is to upload the budget as COQ (Change Order). This is useful for project that budget get approved in phases. PCO type is always COQ. The PCO field, is correspond to Pending Change Order module, pick one that you intent to use. Make a good (consistent) name for your COQ. Starting PCO item field, correspond to the PCO item in Pending Change Order. Typically you want this to start with 1, unless you are adding to an existing PCO. Increment by: '''Typically you want set this to 1'''. I can’t think of anything that would make you to change this to anything else. Note that the each Contract Item will be a new PCO item, when you are adding the budget as a change order.<br />
[[File:Budget Upload - Upload to PM.png|thumb|Import Estimate – Upload to PM]]<br />
Then hit the Upload button. Once the budget uploaded, it will prompt you that the budget is uploaded, and if you want to delete the data table. You can go ahead and delete it. If the data table have errors that’s not cleared up. You will not be able to upload the budget, instead, Viewpoint will prompt you a message box and tell you this. Since I have already uploaded my budget, I will not try to upload again. Just pretend the picture on the left is what you see once clicked the upload button.<br />
<br />
Locate the “Interface” module in Project Management – Program Folder. Double Click to open this program. Hit Validate, then Interface.<br />
[[File:Budget Upload - Add Bond Insurance Fee.png|thumb|Add Bond Insurance Fee]]<br />
Now go back to the Job Cost – Program, open module JC Original Estimate program. Remember that the items entered on the Summary sheet in Estimate Template will not be pulled? This is where we enter those a few items. Bond, Insurance, Fee. <br />
<br />
'''Once all these item added, your project total should matches up the contract amount.'''<br />
<br />
==== Import Estimate – Billing Schedule ====<br />
Locate in Job Cost – Program folder, JC Contract Master module. Double click to open.<br />
[[File:Budget Upload - Billing Schedule.png|thumb|Editing Billing Schedule]]<br />
# Go to your project, then select “Items” tab.<br />
# Adjust the description, add/delete the lines as needed.<br />
# Adjust the $ value in the Orig Amount. <br />
# The total amount should match the contract value.<br />
# Essentially this is the billing structure that accounting will get you to complete every month.<br />
Do:<br />
* Review tender documents and see if certain billing structure is required.<br />
* Check with CM or OM see if there are certain billing structure should be used<br />
* Check with Client and see if they want any particular item broken out<br />
* Double check the total mount of Billing, matches total amount of Estimate, Matches total amount of Contract Value.</div>ASamoilhttps://thewiki.builtplainly.com/index.php?title=File:Sampleconsolidationpage.png&diff=1005File:Sampleconsolidationpage.png2022-06-10T15:54:18Z<p>ASamoil: </p>
<hr />
<div>Sampleconsolidationpage</div>ASamoilhttps://thewiki.builtplainly.com/index.php?title=Budget_Upload&diff=1004Budget Upload2022-06-10T15:53:19Z<p>ASamoil: /* Step 3: Pull All Estimate Data To One Page */</p>
<hr />
<div>== Introduction ==<br />
=== Objective: ===<br />
Establish a basic understanding and procedure for uploading budget from Estimate Template to Viewpoint.<br />
=== Agenda ===<br />
* Process diagram<br />
* Step by Step Tutorial<br />
* Buyout and adjust detail estimate<br />
* Consolidate detail estimate, fine tune code, units, descriptions<br />
* Export CSV file<br />
* Import CSV file to Viewpoint<br />
* Set up Billing<br />
== Tutorial ==<br />
=== What happens after a win? ===<br />
From operation standpoint we focus on the Estimate Review<br />
* Cost Code Clean Up<br />
* Consolidate Units<br />
* Review Cost and Bid<br />
* Buyout scopes<br />
* Identify contingency vs cash allowance<br />
* Any special agreement or alignment of trades<br />
* Etc.<br />
<br />
<sequencediagram style="modern-blue"><br />
Customer->Estimator: Award Project\nto Synergy<br />
Note over Estimator, Estimate\nTemplate : Reconcile Bids\nOrganize Bid Binder<br />
Estimator->Operation Team: Control Estimate (the Book)<br />
Estimator->Operation Team: Bid Binder<br />
Note over Estimator, Operation Team: Review Bid Strategy, Bids, Schedule\n(Turn Over Meeting)<br />
Note over Estimate\nTemplate, Operation Team:Review Estimate\nClean up Cost Code\nConsolidate Units\nReview Cost<br />
Estimate\nTemplate->Operation Team:Budget .CSV file<br />
Operation Team-> Viewpoint: Upload Budget <br />
</sequencediagram><br />
<br />
Then,<br />
# The entire estimate data after cleanup get poured into Viewpoint using a '''[https://en.wikipedia.org/wiki/Comma-separated_values .CSV file]'''.<br />
# The CSV file is structured specifically in a format Viewpoint can read using Import Estimate Module.<br />
=== Step-by-Step ===<br />
==== Within Estimate Work Book, you will need to do the following ====<br />
===== Step 1: Locate the "Tab" =====<br />
[[File:LocateTheTab.png|thumb|center|sample estimate workbook]]<br />
<br />
# Open the Estimate File received from Estimate Turn Over Meeting<br />
# Locate “Summary” and Division pages, drag and position those sheets to the front of all other sheets.<br />
# Locate “Est To VP” Tab, there are 6 buttons on this tab, each have their own corresponded functions. We will go through them in later pages.<br />
<br />
===== Step 2: Buy Out, Estimate Adjustment =====<br />
# Do your contract buy out.<br />
# During the buy out, modify the estimate file to match the scope that was bought into the trade’s scope.<br />
[[File:Budget Upload - Sample Buyout.png|thumb|sample buyout process]]<br />
# For the example that was shown here, the access panel and a few other scopes were estimated with own forces. During buy out, the drywaller agreed to take on those scopes for an additional cost. The number has been adjusted and moved to Subcontract Cost accordingly.<br />
# During buy out, if agreement were made for trades to take on certain additional scope for no or any cost, modify the estimate file to match the agreements.<br />
# Repeat this for all scopes pertains to the project.<br />
# In case any offsets from original contract value, we can add those after all the buy out to contingency, or book fee – pending on each project case.<br />
<br />
===== Step 3: Pull All Estimate Data To One Page =====<br />
# Locate the button called “Consolidate”. Click on it, will open a dialog allow you to select which page to include on pulling the Estimate Data Over.<br />
[[File:Budget Upload - Consolidation Button.png|thumb|consolidation button]]<br />
# In most cases, all pages from 1 to 16 will be selected.<br />
# However, if only a portion of the budget is getting uploaded, such as a change order, select only the page you want to upload.<br />
<br />
In the "Consolidation" worksheet, we can fine tune the cost codes, units, descriptions.<br />
An example is shown here. This page allows you to <br />
[[File:Consolidatebutton.png|thumb|sample consolidation page]]<br />
* view which lines share the same cost code<br />
* Group or ungroup the cost lines by cost code<br />
* Adjusting unit of measure, quantities as needed.<br />
* This page does not allow modification to costs per se.<br />
'''Do''' <br />
* A quick check on each Division line and make sure the cost matches.<br />
* Remind yourself that any additional cost located on the summary page will not shown here – such as Insurance and Fee.<br />
'''Don’t'''<br />
* Try to change the format<br />
* Try to change the cost<br />
You can modify the description, unit of measure, quantity of the first line of the duplicated code so that the description make sense in your future forecast. In the example that’s shown, I have changed the description from “Orientation and Labour” to “Safety Equipment, Orientation and Labour” as this code contains both costlines. <br />
[[File:Budget Upload - Consolidation Description Change.png|frame|center]]<br />
The upload result of this example will be<br />
* Quantity of 20 with units of weeks<br />
* 140 hours of labour, $2,720+$5,600 for labour cost<br />
* $7,800 for material cost.<br />
* Repeat this for all cost lines.<br />
You can also combine or separate cost code for costlines. in this example, I have separated the cost code for flooring protection from the flooring subtrade. Doing so allows me to forecast easier during project execution phase. Do this as needed for all cost lines.<br />
<br />
Once you have gone thru all the cost lines, review with CM or OM if required. If you are comfortable with the consolidation and the PM has completed the above checks, you can begin to export to Viewpoint phase<br />
* Locate the “CSV Export” button, a dialog will show to let you save the CSV file generated for this estimate.<br />
* Modify the file name as needed, click “Save”.<br />
* It is recommended saving this file to the project folder, under “4 – Estimating”<br />
<br />
=== Est 2.0 CSV Creation method ===<br />
1. [[Consolidate]]<br />
<br />
yes zero no lead spaces<br />
2. [[CSV Export]]<br />
<br />
<br />
==== Import Estimate ====<br />
===== Do this using Viewpoint Import Estimate Program. =====<br />
Log into Viewpoint, Locate Module “PM Import Estimate” in Project Management – Program folder. Double Click to open the module.<br />
[[File:Budget Upload - Viewpoint Import Estimate Location.png|thumb|Locate Import Estimate Module]]<br />
<br />
This module contains a few different buttons.<br />
* Template Master lists all template that can be used to read the CSV file. We will not be touching this button.<br />
* Import Data lets you import the CSB file that was exported<br />
* Edit Work Tables lets you edit any imported budget table.<br />
* Upload into PM lets you pour the data into PM module, either as Original Estimate or as a Change Order to Existing Estimate.<br />
<br />
Click the Import Data, a window will pop open as the example shows.<br />
[[File:Budget Upload - Import Estimate Button.png|thumb|Import Estimate Button]]<br />
* For template, use SYN, this is the template made for Synergy to read a specific CSV format.<br />
* For “Import File 1:” field, click “Browse” button to the right, and select the CSV file that was exported.<br />
* For “Import ID” field, make a new Import ID, for example, you can use your initial + a number.<br />
* For Default Holdback Percentage, use 10%. <br />
* Click “Import” Button<br />
<br />
Viewpoint will be doing some work, if the project is big, in regards to amount of cost codes, it may take a minute or two. Once the file is imported, Viewpoint will prompt you a Message Box, sometimes it will say there are some errors. These errors are caused by non-standard cost code, or unit of measures that was used during estimating stage, or during consolidation stage.<br />
<br />
Click on the “Edit Work Tables” button, Viewpoint will open up a window, by default it will open the most recent import made by you. We will only be using the “Items”, “Phase”, “Cost Types” tabs.<br />
<br />
Some of the tab name is probably not familiar to you, translation:<br />
* Items – Contract Items, these are the items shows up on your billing. <br />
* Phases – Cost Codes, this tab allows you to adjust how the codes are linked with Contract Items. (you don’t have to change the links, the contract items and their amount are much easier to adjust in Job Cost – JC Contract Master module). <br />
* Cost Types – Cost Types of each cost code. This tab shows, for example the cost allocated in each cost type for each cost code.<br />
<br />
On the contract items tab, you can edit the contract Item descriptions here. I recommend to do it in JC – Contract Master module once the import is completed however.<br />
[[File:Budget Upload - Review Data Table.png|thumb|Review Data Table]]<br />
On the cost code tab, any error will be high lighted with red. Error on this tab typically is caused by the Cost Code does not existing in Master Cost Code list. Select the line with Error, double click the phase field to edit. Click F4 key on your keyboard to call out the cost code look up list, pick an appropriate code from the list. Once the code is picked, you can also add .xx.xx to it to make it more customized. For example, 12010.01. Click “Save” button, or Ctrl+S to save the change. Viewpoint will prompt you a dialog ask if it should create a phase cross reference record, '''make sure to select “NO”'''. If you accidentally clicked yes, let Siyuan know, the cross reference can be deleted from the template.<br />
<br />
Similar procedure for Cost Types tab. Viewpoint has a bug that even if you changed cost code on Phase tab, the Cost Types tab will still show the error (although the cost code is correct). To clear up the error, you will need to double click the cost code and type in the same code again. Similar procedure for Unit of Measure Error as well. Annoying I know, hopefully they fix that in the future. <br />
<br />
Once all errors are cleared up, you can click the “Upload into PM” button. Viewpoint will open a window for this. Defaulted to the most recent Data Table that you edited. In the Project field, put in the project number that this budget is going into. The Start Month – this is the effective month of your budget, not your project schedule start. For example, if you set the start month to 02/21, the budget you upload today will not shown in forecast till the February batch in 2021. Doesn’t matter if you interfaced to December 2020. The red text here is a warning, telling me there are existing cost code and cost ($0 count as well) in the project already. Uploading will have the budget accumulated. If this is the first time budget uploading to this project, it typically because some codes were opened up by accounting for insurance purposes.<br />
<br />
'''Always a good habit to check!!''' Locate in Job Cost – Programs, the JC Original Estimate module. Open it, you will see what's existing in your project, for both cost code, and budget. '''If you already have budget in the project, uploading will accumulate, instead of overwrite.'''<br />
<br />
Another Option is to upload the budget as COQ (Change Order). This is useful for project that budget get approved in phases. PCO type is always COQ. The PCO field, is correspond to Pending Change Order module, pick one that you intent to use. Make a good (consistent) name for your COQ. Starting PCO item field, correspond to the PCO item in Pending Change Order. Typically you want this to start with 1, unless you are adding to an existing PCO. Increment by: '''Typically you want set this to 1'''. I can’t think of anything that would make you to change this to anything else. Note that the each Contract Item will be a new PCO item, when you are adding the budget as a change order.<br />
[[File:Budget Upload - Upload to PM.png|thumb|Import Estimate – Upload to PM]]<br />
Then hit the Upload button. Once the budget uploaded, it will prompt you that the budget is uploaded, and if you want to delete the data table. You can go ahead and delete it. If the data table have errors that’s not cleared up. You will not be able to upload the budget, instead, Viewpoint will prompt you a message box and tell you this. Since I have already uploaded my budget, I will not try to upload again. Just pretend the picture on the left is what you see once clicked the upload button.<br />
<br />
Locate the “Interface” module in Project Management – Program Folder. Double Click to open this program. Hit Validate, then Interface.<br />
[[File:Budget Upload - Add Bond Insurance Fee.png|thumb|Add Bond Insurance Fee]]<br />
Now go back to the Job Cost – Program, open module JC Original Estimate program. Remember that the items entered on the Summary sheet in Estimate Template will not be pulled? This is where we enter those a few items. Bond, Insurance, Fee. <br />
<br />
'''Once all these item added, your project total should matches up the contract amount.'''<br />
<br />
==== Import Estimate – Billing Schedule ====<br />
Locate in Job Cost – Program folder, JC Contract Master module. Double click to open.<br />
[[File:Budget Upload - Billing Schedule.png|thumb|Editing Billing Schedule]]<br />
# Go to your project, then select “Items” tab.<br />
# Adjust the description, add/delete the lines as needed.<br />
# Adjust the $ value in the Orig Amount. <br />
# The total amount should match the contract value.<br />
# Essentially this is the billing structure that accounting will get you to complete every month.<br />
Do:<br />
* Review tender documents and see if certain billing structure is required.<br />
* Check with CM or OM see if there are certain billing structure should be used<br />
* Check with Client and see if they want any particular item broken out<br />
* Double check the total mount of Billing, matches total amount of Estimate, Matches total amount of Contract Value.</div>ASamoilhttps://thewiki.builtplainly.com/index.php?title=File:Consolidatebutton.png&diff=1003File:Consolidatebutton.png2022-06-10T15:53:14Z<p>ASamoil: </p>
<hr />
<div>Consolidatebutton</div>ASamoilhttps://thewiki.builtplainly.com/index.php?title=Budget_Upload&diff=1002Budget Upload2022-06-10T15:52:08Z<p>ASamoil: /* Step 1: Locate the "Tab" */</p>
<hr />
<div>== Introduction ==<br />
=== Objective: ===<br />
Establish a basic understanding and procedure for uploading budget from Estimate Template to Viewpoint.<br />
=== Agenda ===<br />
* Process diagram<br />
* Step by Step Tutorial<br />
* Buyout and adjust detail estimate<br />
* Consolidate detail estimate, fine tune code, units, descriptions<br />
* Export CSV file<br />
* Import CSV file to Viewpoint<br />
* Set up Billing<br />
== Tutorial ==<br />
=== What happens after a win? ===<br />
From operation standpoint we focus on the Estimate Review<br />
* Cost Code Clean Up<br />
* Consolidate Units<br />
* Review Cost and Bid<br />
* Buyout scopes<br />
* Identify contingency vs cash allowance<br />
* Any special agreement or alignment of trades<br />
* Etc.<br />
<br />
<sequencediagram style="modern-blue"><br />
Customer->Estimator: Award Project\nto Synergy<br />
Note over Estimator, Estimate\nTemplate : Reconcile Bids\nOrganize Bid Binder<br />
Estimator->Operation Team: Control Estimate (the Book)<br />
Estimator->Operation Team: Bid Binder<br />
Note over Estimator, Operation Team: Review Bid Strategy, Bids, Schedule\n(Turn Over Meeting)<br />
Note over Estimate\nTemplate, Operation Team:Review Estimate\nClean up Cost Code\nConsolidate Units\nReview Cost<br />
Estimate\nTemplate->Operation Team:Budget .CSV file<br />
Operation Team-> Viewpoint: Upload Budget <br />
</sequencediagram><br />
<br />
Then,<br />
# The entire estimate data after cleanup get poured into Viewpoint using a '''[https://en.wikipedia.org/wiki/Comma-separated_values .CSV file]'''.<br />
# The CSV file is structured specifically in a format Viewpoint can read using Import Estimate Module.<br />
=== Step-by-Step ===<br />
==== Within Estimate Work Book, you will need to do the following ====<br />
===== Step 1: Locate the "Tab" =====<br />
[[File:LocateTheTab.png|thumb|center|sample estimate workbook]]<br />
<br />
# Open the Estimate File received from Estimate Turn Over Meeting<br />
# Locate “Summary” and Division pages, drag and position those sheets to the front of all other sheets.<br />
# Locate “Est To VP” Tab, there are 6 buttons on this tab, each have their own corresponded functions. We will go through them in later pages.<br />
<br />
===== Step 2: Buy Out, Estimate Adjustment =====<br />
# Do your contract buy out.<br />
# During the buy out, modify the estimate file to match the scope that was bought into the trade’s scope.<br />
[[File:Budget Upload - Sample Buyout.png|thumb|sample buyout process]]<br />
# For the example that was shown here, the access panel and a few other scopes were estimated with own forces. During buy out, the drywaller agreed to take on those scopes for an additional cost. The number has been adjusted and moved to Subcontract Cost accordingly.<br />
# During buy out, if agreement were made for trades to take on certain additional scope for no or any cost, modify the estimate file to match the agreements.<br />
# Repeat this for all scopes pertains to the project.<br />
# In case any offsets from original contract value, we can add those after all the buy out to contingency, or book fee – pending on each project case.<br />
<br />
===== Step 3: Pull All Estimate Data To One Page =====<br />
# Locate the button called “Consolidate”. Click on it, will open a dialog allow you to select which page to include on pulling the Estimate Data Over.<br />
[[File:Budget Upload - Consolidation Button.png|thumb|consolidation button]]<br />
# In most cases, all pages from 1 to 16 will be selected.<br />
# However, if only a portion of the budget is getting uploaded, such as a change order, select only the page you want to upload.<br />
<br />
In the "Consolidation" worksheet, we can fine tune the cost codes, units, descriptions.<br />
An example is shown here. This page allows you to [[File:Budget Update - Consolidation.PNG|thumb|sample consolidation page]]<br />
* view which lines share the same cost code<br />
* Group or ungroup the cost lines by cost code<br />
* Adjusting unit of measure, quantities as needed.<br />
* This page does not allow modification to costs per se.<br />
'''Do''' <br />
* A quick check on each Division line and make sure the cost matches.<br />
* Remind yourself that any additional cost located on the summary page will not shown here – such as Insurance and Fee.<br />
'''Don’t'''<br />
* Try to change the format<br />
* Try to change the cost<br />
You can modify the description, unit of measure, quantity of the first line of the duplicated code so that the description make sense in your future forecast. In the example that’s shown, I have changed the description from “Orientation and Labour” to “Safety Equipment, Orientation and Labour” as this code contains both costlines. <br />
[[File:Budget Upload - Consolidation Description Change.png|frame|center]]<br />
The upload result of this example will be<br />
* Quantity of 20 with units of weeks<br />
* 140 hours of labour, $2,720+$5,600 for labour cost<br />
* $7,800 for material cost.<br />
* Repeat this for all cost lines.<br />
You can also combine or separate cost code for costlines. in this example, I have separated the cost code for flooring protection from the flooring subtrade. Doing so allows me to forecast easier during project execution phase. Do this as needed for all cost lines.<br />
<br />
Once you have gone thru all the cost lines, review with CM or OM if required. If you are comfortable with the consolidation and the PM has completed the above checks, you can begin to export to Viewpoint phase<br />
* Locate the “CSV Export” button, a dialog will show to let you save the CSV file generated for this estimate.<br />
* Modify the file name as needed, click “Save”.<br />
* It is recommended saving this file to the project folder, under “4 – Estimating”<br />
<br />
=== Est 2.0 CSV Creation method ===<br />
1. [[Consolidate]]<br />
<br />
yes zero no lead spaces<br />
2. [[CSV Export]]<br />
<br />
<br />
==== Import Estimate ====<br />
===== Do this using Viewpoint Import Estimate Program. =====<br />
Log into Viewpoint, Locate Module “PM Import Estimate” in Project Management – Program folder. Double Click to open the module.<br />
[[File:Budget Upload - Viewpoint Import Estimate Location.png|thumb|Locate Import Estimate Module]]<br />
<br />
This module contains a few different buttons.<br />
* Template Master lists all template that can be used to read the CSV file. We will not be touching this button.<br />
* Import Data lets you import the CSB file that was exported<br />
* Edit Work Tables lets you edit any imported budget table.<br />
* Upload into PM lets you pour the data into PM module, either as Original Estimate or as a Change Order to Existing Estimate.<br />
<br />
Click the Import Data, a window will pop open as the example shows.<br />
[[File:Budget Upload - Import Estimate Button.png|thumb|Import Estimate Button]]<br />
* For template, use SYN, this is the template made for Synergy to read a specific CSV format.<br />
* For “Import File 1:” field, click “Browse” button to the right, and select the CSV file that was exported.<br />
* For “Import ID” field, make a new Import ID, for example, you can use your initial + a number.<br />
* For Default Holdback Percentage, use 10%. <br />
* Click “Import” Button<br />
<br />
Viewpoint will be doing some work, if the project is big, in regards to amount of cost codes, it may take a minute or two. Once the file is imported, Viewpoint will prompt you a Message Box, sometimes it will say there are some errors. These errors are caused by non-standard cost code, or unit of measures that was used during estimating stage, or during consolidation stage.<br />
<br />
Click on the “Edit Work Tables” button, Viewpoint will open up a window, by default it will open the most recent import made by you. We will only be using the “Items”, “Phase”, “Cost Types” tabs.<br />
<br />
Some of the tab name is probably not familiar to you, translation:<br />
* Items – Contract Items, these are the items shows up on your billing. <br />
* Phases – Cost Codes, this tab allows you to adjust how the codes are linked with Contract Items. (you don’t have to change the links, the contract items and their amount are much easier to adjust in Job Cost – JC Contract Master module). <br />
* Cost Types – Cost Types of each cost code. This tab shows, for example the cost allocated in each cost type for each cost code.<br />
<br />
On the contract items tab, you can edit the contract Item descriptions here. I recommend to do it in JC – Contract Master module once the import is completed however.<br />
[[File:Budget Upload - Review Data Table.png|thumb|Review Data Table]]<br />
On the cost code tab, any error will be high lighted with red. Error on this tab typically is caused by the Cost Code does not existing in Master Cost Code list. Select the line with Error, double click the phase field to edit. Click F4 key on your keyboard to call out the cost code look up list, pick an appropriate code from the list. Once the code is picked, you can also add .xx.xx to it to make it more customized. For example, 12010.01. Click “Save” button, or Ctrl+S to save the change. Viewpoint will prompt you a dialog ask if it should create a phase cross reference record, '''make sure to select “NO”'''. If you accidentally clicked yes, let Siyuan know, the cross reference can be deleted from the template.<br />
<br />
Similar procedure for Cost Types tab. Viewpoint has a bug that even if you changed cost code on Phase tab, the Cost Types tab will still show the error (although the cost code is correct). To clear up the error, you will need to double click the cost code and type in the same code again. Similar procedure for Unit of Measure Error as well. Annoying I know, hopefully they fix that in the future. <br />
<br />
Once all errors are cleared up, you can click the “Upload into PM” button. Viewpoint will open a window for this. Defaulted to the most recent Data Table that you edited. In the Project field, put in the project number that this budget is going into. The Start Month – this is the effective month of your budget, not your project schedule start. For example, if you set the start month to 02/21, the budget you upload today will not shown in forecast till the February batch in 2021. Doesn’t matter if you interfaced to December 2020. The red text here is a warning, telling me there are existing cost code and cost ($0 count as well) in the project already. Uploading will have the budget accumulated. If this is the first time budget uploading to this project, it typically because some codes were opened up by accounting for insurance purposes.<br />
<br />
'''Always a good habit to check!!''' Locate in Job Cost – Programs, the JC Original Estimate module. Open it, you will see what's existing in your project, for both cost code, and budget. '''If you already have budget in the project, uploading will accumulate, instead of overwrite.'''<br />
<br />
Another Option is to upload the budget as COQ (Change Order). This is useful for project that budget get approved in phases. PCO type is always COQ. The PCO field, is correspond to Pending Change Order module, pick one that you intent to use. Make a good (consistent) name for your COQ. Starting PCO item field, correspond to the PCO item in Pending Change Order. Typically you want this to start with 1, unless you are adding to an existing PCO. Increment by: '''Typically you want set this to 1'''. I can’t think of anything that would make you to change this to anything else. Note that the each Contract Item will be a new PCO item, when you are adding the budget as a change order.<br />
[[File:Budget Upload - Upload to PM.png|thumb|Import Estimate – Upload to PM]]<br />
Then hit the Upload button. Once the budget uploaded, it will prompt you that the budget is uploaded, and if you want to delete the data table. You can go ahead and delete it. If the data table have errors that’s not cleared up. You will not be able to upload the budget, instead, Viewpoint will prompt you a message box and tell you this. Since I have already uploaded my budget, I will not try to upload again. Just pretend the picture on the left is what you see once clicked the upload button.<br />
<br />
Locate the “Interface” module in Project Management – Program Folder. Double Click to open this program. Hit Validate, then Interface.<br />
[[File:Budget Upload - Add Bond Insurance Fee.png|thumb|Add Bond Insurance Fee]]<br />
Now go back to the Job Cost – Program, open module JC Original Estimate program. Remember that the items entered on the Summary sheet in Estimate Template will not be pulled? This is where we enter those a few items. Bond, Insurance, Fee. <br />
<br />
'''Once all these item added, your project total should matches up the contract amount.'''<br />
<br />
==== Import Estimate – Billing Schedule ====<br />
Locate in Job Cost – Program folder, JC Contract Master module. Double click to open.<br />
[[File:Budget Upload - Billing Schedule.png|thumb|Editing Billing Schedule]]<br />
# Go to your project, then select “Items” tab.<br />
# Adjust the description, add/delete the lines as needed.<br />
# Adjust the $ value in the Orig Amount. <br />
# The total amount should match the contract value.<br />
# Essentially this is the billing structure that accounting will get you to complete every month.<br />
Do:<br />
* Review tender documents and see if certain billing structure is required.<br />
* Check with CM or OM see if there are certain billing structure should be used<br />
* Check with Client and see if they want any particular item broken out<br />
* Double check the total mount of Billing, matches total amount of Estimate, Matches total amount of Contract Value.</div>ASamoilhttps://thewiki.builtplainly.com/index.php?title=Budget_Upload&diff=1001Budget Upload2022-06-10T15:51:47Z<p>ASamoil: /* Step 1: Locate the "Tab" */</p>
<hr />
<div>== Introduction ==<br />
=== Objective: ===<br />
Establish a basic understanding and procedure for uploading budget from Estimate Template to Viewpoint.<br />
=== Agenda ===<br />
* Process diagram<br />
* Step by Step Tutorial<br />
* Buyout and adjust detail estimate<br />
* Consolidate detail estimate, fine tune code, units, descriptions<br />
* Export CSV file<br />
* Import CSV file to Viewpoint<br />
* Set up Billing<br />
== Tutorial ==<br />
=== What happens after a win? ===<br />
From operation standpoint we focus on the Estimate Review<br />
* Cost Code Clean Up<br />
* Consolidate Units<br />
* Review Cost and Bid<br />
* Buyout scopes<br />
* Identify contingency vs cash allowance<br />
* Any special agreement or alignment of trades<br />
* Etc.<br />
<br />
<sequencediagram style="modern-blue"><br />
Customer->Estimator: Award Project\nto Synergy<br />
Note over Estimator, Estimate\nTemplate : Reconcile Bids\nOrganize Bid Binder<br />
Estimator->Operation Team: Control Estimate (the Book)<br />
Estimator->Operation Team: Bid Binder<br />
Note over Estimator, Operation Team: Review Bid Strategy, Bids, Schedule\n(Turn Over Meeting)<br />
Note over Estimate\nTemplate, Operation Team:Review Estimate\nClean up Cost Code\nConsolidate Units\nReview Cost<br />
Estimate\nTemplate->Operation Team:Budget .CSV file<br />
Operation Team-> Viewpoint: Upload Budget <br />
</sequencediagram><br />
<br />
Then,<br />
# The entire estimate data after cleanup get poured into Viewpoint using a '''[https://en.wikipedia.org/wiki/Comma-separated_values .CSV file]'''.<br />
# The CSV file is structured specifically in a format Viewpoint can read using Import Estimate Module.<br />
=== Step-by-Step ===<br />
==== Within Estimate Work Book, you will need to do the following ====<br />
===== Step 1: Locate the "Tab" =====<br />
[[File:LocateTheTab.png|frame|center|sample estimate workbook]]<br />
<br />
# Open the Estimate File received from Estimate Turn Over Meeting<br />
# Locate “Summary” and Division pages, drag and position those sheets to the front of all other sheets.<br />
# Locate “Est To VP” Tab, there are 6 buttons on this tab, each have their own corresponded functions. We will go through them in later pages.<br />
<br />
===== Step 2: Buy Out, Estimate Adjustment =====<br />
# Do your contract buy out.<br />
# During the buy out, modify the estimate file to match the scope that was bought into the trade’s scope.<br />
[[File:Budget Upload - Sample Buyout.png|thumb|sample buyout process]]<br />
# For the example that was shown here, the access panel and a few other scopes were estimated with own forces. During buy out, the drywaller agreed to take on those scopes for an additional cost. The number has been adjusted and moved to Subcontract Cost accordingly.<br />
# During buy out, if agreement were made for trades to take on certain additional scope for no or any cost, modify the estimate file to match the agreements.<br />
# Repeat this for all scopes pertains to the project.<br />
# In case any offsets from original contract value, we can add those after all the buy out to contingency, or book fee – pending on each project case.<br />
<br />
===== Step 3: Pull All Estimate Data To One Page =====<br />
# Locate the button called “Consolidate”. Click on it, will open a dialog allow you to select which page to include on pulling the Estimate Data Over.<br />
[[File:Budget Upload - Consolidation Button.png|thumb|consolidation button]]<br />
# In most cases, all pages from 1 to 16 will be selected.<br />
# However, if only a portion of the budget is getting uploaded, such as a change order, select only the page you want to upload.<br />
<br />
In the "Consolidation" worksheet, we can fine tune the cost codes, units, descriptions.<br />
An example is shown here. This page allows you to [[File:Budget Update - Consolidation.PNG|thumb|sample consolidation page]]<br />
* view which lines share the same cost code<br />
* Group or ungroup the cost lines by cost code<br />
* Adjusting unit of measure, quantities as needed.<br />
* This page does not allow modification to costs per se.<br />
'''Do''' <br />
* A quick check on each Division line and make sure the cost matches.<br />
* Remind yourself that any additional cost located on the summary page will not shown here – such as Insurance and Fee.<br />
'''Don’t'''<br />
* Try to change the format<br />
* Try to change the cost<br />
You can modify the description, unit of measure, quantity of the first line of the duplicated code so that the description make sense in your future forecast. In the example that’s shown, I have changed the description from “Orientation and Labour” to “Safety Equipment, Orientation and Labour” as this code contains both costlines. <br />
[[File:Budget Upload - Consolidation Description Change.png|frame|center]]<br />
The upload result of this example will be<br />
* Quantity of 20 with units of weeks<br />
* 140 hours of labour, $2,720+$5,600 for labour cost<br />
* $7,800 for material cost.<br />
* Repeat this for all cost lines.<br />
You can also combine or separate cost code for costlines. in this example, I have separated the cost code for flooring protection from the flooring subtrade. Doing so allows me to forecast easier during project execution phase. Do this as needed for all cost lines.<br />
<br />
Once you have gone thru all the cost lines, review with CM or OM if required. If you are comfortable with the consolidation and the PM has completed the above checks, you can begin to export to Viewpoint phase<br />
* Locate the “CSV Export” button, a dialog will show to let you save the CSV file generated for this estimate.<br />
* Modify the file name as needed, click “Save”.<br />
* It is recommended saving this file to the project folder, under “4 – Estimating”<br />
<br />
=== Est 2.0 CSV Creation method ===<br />
1. [[Consolidate]]<br />
<br />
yes zero no lead spaces<br />
2. [[CSV Export]]<br />
<br />
<br />
==== Import Estimate ====<br />
===== Do this using Viewpoint Import Estimate Program. =====<br />
Log into Viewpoint, Locate Module “PM Import Estimate” in Project Management – Program folder. Double Click to open the module.<br />
[[File:Budget Upload - Viewpoint Import Estimate Location.png|thumb|Locate Import Estimate Module]]<br />
<br />
This module contains a few different buttons.<br />
* Template Master lists all template that can be used to read the CSV file. We will not be touching this button.<br />
* Import Data lets you import the CSB file that was exported<br />
* Edit Work Tables lets you edit any imported budget table.<br />
* Upload into PM lets you pour the data into PM module, either as Original Estimate or as a Change Order to Existing Estimate.<br />
<br />
Click the Import Data, a window will pop open as the example shows.<br />
[[File:Budget Upload - Import Estimate Button.png|thumb|Import Estimate Button]]<br />
* For template, use SYN, this is the template made for Synergy to read a specific CSV format.<br />
* For “Import File 1:” field, click “Browse” button to the right, and select the CSV file that was exported.<br />
* For “Import ID” field, make a new Import ID, for example, you can use your initial + a number.<br />
* For Default Holdback Percentage, use 10%. <br />
* Click “Import” Button<br />
<br />
Viewpoint will be doing some work, if the project is big, in regards to amount of cost codes, it may take a minute or two. Once the file is imported, Viewpoint will prompt you a Message Box, sometimes it will say there are some errors. These errors are caused by non-standard cost code, or unit of measures that was used during estimating stage, or during consolidation stage.<br />
<br />
Click on the “Edit Work Tables” button, Viewpoint will open up a window, by default it will open the most recent import made by you. We will only be using the “Items”, “Phase”, “Cost Types” tabs.<br />
<br />
Some of the tab name is probably not familiar to you, translation:<br />
* Items – Contract Items, these are the items shows up on your billing. <br />
* Phases – Cost Codes, this tab allows you to adjust how the codes are linked with Contract Items. (you don’t have to change the links, the contract items and their amount are much easier to adjust in Job Cost – JC Contract Master module). <br />
* Cost Types – Cost Types of each cost code. This tab shows, for example the cost allocated in each cost type for each cost code.<br />
<br />
On the contract items tab, you can edit the contract Item descriptions here. I recommend to do it in JC – Contract Master module once the import is completed however.<br />
[[File:Budget Upload - Review Data Table.png|thumb|Review Data Table]]<br />
On the cost code tab, any error will be high lighted with red. Error on this tab typically is caused by the Cost Code does not existing in Master Cost Code list. Select the line with Error, double click the phase field to edit. Click F4 key on your keyboard to call out the cost code look up list, pick an appropriate code from the list. Once the code is picked, you can also add .xx.xx to it to make it more customized. For example, 12010.01. Click “Save” button, or Ctrl+S to save the change. Viewpoint will prompt you a dialog ask if it should create a phase cross reference record, '''make sure to select “NO”'''. If you accidentally clicked yes, let Siyuan know, the cross reference can be deleted from the template.<br />
<br />
Similar procedure for Cost Types tab. Viewpoint has a bug that even if you changed cost code on Phase tab, the Cost Types tab will still show the error (although the cost code is correct). To clear up the error, you will need to double click the cost code and type in the same code again. Similar procedure for Unit of Measure Error as well. Annoying I know, hopefully they fix that in the future. <br />
<br />
Once all errors are cleared up, you can click the “Upload into PM” button. Viewpoint will open a window for this. Defaulted to the most recent Data Table that you edited. In the Project field, put in the project number that this budget is going into. The Start Month – this is the effective month of your budget, not your project schedule start. For example, if you set the start month to 02/21, the budget you upload today will not shown in forecast till the February batch in 2021. Doesn’t matter if you interfaced to December 2020. The red text here is a warning, telling me there are existing cost code and cost ($0 count as well) in the project already. Uploading will have the budget accumulated. If this is the first time budget uploading to this project, it typically because some codes were opened up by accounting for insurance purposes.<br />
<br />
'''Always a good habit to check!!''' Locate in Job Cost – Programs, the JC Original Estimate module. Open it, you will see what's existing in your project, for both cost code, and budget. '''If you already have budget in the project, uploading will accumulate, instead of overwrite.'''<br />
<br />
Another Option is to upload the budget as COQ (Change Order). This is useful for project that budget get approved in phases. PCO type is always COQ. The PCO field, is correspond to Pending Change Order module, pick one that you intent to use. Make a good (consistent) name for your COQ. Starting PCO item field, correspond to the PCO item in Pending Change Order. Typically you want this to start with 1, unless you are adding to an existing PCO. Increment by: '''Typically you want set this to 1'''. I can’t think of anything that would make you to change this to anything else. Note that the each Contract Item will be a new PCO item, when you are adding the budget as a change order.<br />
[[File:Budget Upload - Upload to PM.png|thumb|Import Estimate – Upload to PM]]<br />
Then hit the Upload button. Once the budget uploaded, it will prompt you that the budget is uploaded, and if you want to delete the data table. You can go ahead and delete it. If the data table have errors that’s not cleared up. You will not be able to upload the budget, instead, Viewpoint will prompt you a message box and tell you this. Since I have already uploaded my budget, I will not try to upload again. Just pretend the picture on the left is what you see once clicked the upload button.<br />
<br />
Locate the “Interface” module in Project Management – Program Folder. Double Click to open this program. Hit Validate, then Interface.<br />
[[File:Budget Upload - Add Bond Insurance Fee.png|thumb|Add Bond Insurance Fee]]<br />
Now go back to the Job Cost – Program, open module JC Original Estimate program. Remember that the items entered on the Summary sheet in Estimate Template will not be pulled? This is where we enter those a few items. Bond, Insurance, Fee. <br />
<br />
'''Once all these item added, your project total should matches up the contract amount.'''<br />
<br />
==== Import Estimate – Billing Schedule ====<br />
Locate in Job Cost – Program folder, JC Contract Master module. Double click to open.<br />
[[File:Budget Upload - Billing Schedule.png|thumb|Editing Billing Schedule]]<br />
# Go to your project, then select “Items” tab.<br />
# Adjust the description, add/delete the lines as needed.<br />
# Adjust the $ value in the Orig Amount. <br />
# The total amount should match the contract value.<br />
# Essentially this is the billing structure that accounting will get you to complete every month.<br />
Do:<br />
* Review tender documents and see if certain billing structure is required.<br />
* Check with CM or OM see if there are certain billing structure should be used<br />
* Check with Client and see if they want any particular item broken out<br />
* Double check the total mount of Billing, matches total amount of Estimate, Matches total amount of Contract Value.</div>ASamoilhttps://thewiki.builtplainly.com/index.php?title=File:LocateTheTab.png&diff=1000File:LocateTheTab.png2022-06-10T15:51:44Z<p>ASamoil: </p>
<hr />
<div>LocateTheTab</div>ASamoilhttps://thewiki.builtplainly.com/index.php?title=Budget_Upload&diff=999Budget Upload2022-06-10T15:01:36Z<p>ASamoil: /* Est 2.0 CSV Creation method */</p>
<hr />
<div>== Introduction ==<br />
=== Objective: ===<br />
Establish a basic understanding and procedure for uploading budget from Estimate Template to Viewpoint.<br />
=== Agenda ===<br />
* Process diagram<br />
* Step by Step Tutorial<br />
* Buyout and adjust detail estimate<br />
* Consolidate detail estimate, fine tune code, units, descriptions<br />
* Export CSV file<br />
* Import CSV file to Viewpoint<br />
* Set up Billing<br />
== Tutorial ==<br />
=== What happens after a win? ===<br />
From operation standpoint we focus on the Estimate Review<br />
* Cost Code Clean Up<br />
* Consolidate Units<br />
* Review Cost and Bid<br />
* Buyout scopes<br />
* Identify contingency vs cash allowance<br />
* Any special agreement or alignment of trades<br />
* Etc.<br />
<br />
<sequencediagram style="modern-blue"><br />
Customer->Estimator: Award Project\nto Synergy<br />
Note over Estimator, Estimate\nTemplate : Reconcile Bids\nOrganize Bid Binder<br />
Estimator->Operation Team: Control Estimate (the Book)<br />
Estimator->Operation Team: Bid Binder<br />
Note over Estimator, Operation Team: Review Bid Strategy, Bids, Schedule\n(Turn Over Meeting)<br />
Note over Estimate\nTemplate, Operation Team:Review Estimate\nClean up Cost Code\nConsolidate Units\nReview Cost<br />
Estimate\nTemplate->Operation Team:Budget .CSV file<br />
Operation Team-> Viewpoint: Upload Budget <br />
</sequencediagram><br />
<br />
Then,<br />
# The entire estimate data after cleanup get poured into Viewpoint using a '''[https://en.wikipedia.org/wiki/Comma-separated_values .CSV file]'''.<br />
# The CSV file is structured specifically in a format Viewpoint can read using Import Estimate Module.<br />
=== Step-by-Step ===<br />
==== Within Estimate Work Book, you will need to do the following ====<br />
===== Step 1: Locate the "Tab" =====<br />
[[File:Budget Upload - Worksheets.png|frame|center|sample estimate workbook]]<br />
# Open the Estimate File received from Estimate Turn Over Meeting<br />
# Locate “Summary” and Division pages, drag and position those sheets to the front of all other sheets.<br />
# Locate “Est To VP” Tab, there are 6 buttons on this tab, each have their own corresponded functions. We will go through them in later pages.<br />
<br />
===== Step 2: Buy Out, Estimate Adjustment =====<br />
# Do your contract buy out.<br />
# During the buy out, modify the estimate file to match the scope that was bought into the trade’s scope.<br />
[[File:Budget Upload - Sample Buyout.png|thumb|sample buyout process]]<br />
# For the example that was shown here, the access panel and a few other scopes were estimated with own forces. During buy out, the drywaller agreed to take on those scopes for an additional cost. The number has been adjusted and moved to Subcontract Cost accordingly.<br />
# During buy out, if agreement were made for trades to take on certain additional scope for no or any cost, modify the estimate file to match the agreements.<br />
# Repeat this for all scopes pertains to the project.<br />
# In case any offsets from original contract value, we can add those after all the buy out to contingency, or book fee – pending on each project case.<br />
<br />
===== Step 3: Pull All Estimate Data To One Page =====<br />
# Locate the button called “Consolidate”. Click on it, will open a dialog allow you to select which page to include on pulling the Estimate Data Over.<br />
[[File:Budget Upload - Consolidation Button.png|thumb|consolidation button]]<br />
# In most cases, all pages from 1 to 16 will be selected.<br />
# However, if only a portion of the budget is getting uploaded, such as a change order, select only the page you want to upload.<br />
<br />
In the "Consolidation" worksheet, we can fine tune the cost codes, units, descriptions.<br />
An example is shown here. This page allows you to [[File:Budget Update - Consolidation.PNG|thumb|sample consolidation page]]<br />
* view which lines share the same cost code<br />
* Group or ungroup the cost lines by cost code<br />
* Adjusting unit of measure, quantities as needed.<br />
* This page does not allow modification to costs per se.<br />
'''Do''' <br />
* A quick check on each Division line and make sure the cost matches.<br />
* Remind yourself that any additional cost located on the summary page will not shown here – such as Insurance and Fee.<br />
'''Don’t'''<br />
* Try to change the format<br />
* Try to change the cost<br />
You can modify the description, unit of measure, quantity of the first line of the duplicated code so that the description make sense in your future forecast. In the example that’s shown, I have changed the description from “Orientation and Labour” to “Safety Equipment, Orientation and Labour” as this code contains both costlines. <br />
[[File:Budget Upload - Consolidation Description Change.png|frame|center]]<br />
The upload result of this example will be<br />
* Quantity of 20 with units of weeks<br />
* 140 hours of labour, $2,720+$5,600 for labour cost<br />
* $7,800 for material cost.<br />
* Repeat this for all cost lines.<br />
You can also combine or separate cost code for costlines. in this example, I have separated the cost code for flooring protection from the flooring subtrade. Doing so allows me to forecast easier during project execution phase. Do this as needed for all cost lines.<br />
<br />
Once you have gone thru all the cost lines, review with CM or OM if required. If you are comfortable with the consolidation and the PM has completed the above checks, you can begin to export to Viewpoint phase<br />
* Locate the “CSV Export” button, a dialog will show to let you save the CSV file generated for this estimate.<br />
* Modify the file name as needed, click “Save”.<br />
* It is recommended saving this file to the project folder, under “4 – Estimating”<br />
<br />
=== Est 2.0 CSV Creation method ===<br />
1. [[Consolidate]]<br />
<br />
yes zero no lead spaces<br />
2. [[CSV Export]]<br />
<br />
<br />
==== Import Estimate ====<br />
===== Do this using Viewpoint Import Estimate Program. =====<br />
Log into Viewpoint, Locate Module “PM Import Estimate” in Project Management – Program folder. Double Click to open the module.<br />
[[File:Budget Upload - Viewpoint Import Estimate Location.png|thumb|Locate Import Estimate Module]]<br />
<br />
This module contains a few different buttons.<br />
* Template Master lists all template that can be used to read the CSV file. We will not be touching this button.<br />
* Import Data lets you import the CSB file that was exported<br />
* Edit Work Tables lets you edit any imported budget table.<br />
* Upload into PM lets you pour the data into PM module, either as Original Estimate or as a Change Order to Existing Estimate.<br />
<br />
Click the Import Data, a window will pop open as the example shows.<br />
[[File:Budget Upload - Import Estimate Button.png|thumb|Import Estimate Button]]<br />
* For template, use SYN, this is the template made for Synergy to read a specific CSV format.<br />
* For “Import File 1:” field, click “Browse” button to the right, and select the CSV file that was exported.<br />
* For “Import ID” field, make a new Import ID, for example, you can use your initial + a number.<br />
* For Default Holdback Percentage, use 10%. <br />
* Click “Import” Button<br />
<br />
Viewpoint will be doing some work, if the project is big, in regards to amount of cost codes, it may take a minute or two. Once the file is imported, Viewpoint will prompt you a Message Box, sometimes it will say there are some errors. These errors are caused by non-standard cost code, or unit of measures that was used during estimating stage, or during consolidation stage.<br />
<br />
Click on the “Edit Work Tables” button, Viewpoint will open up a window, by default it will open the most recent import made by you. We will only be using the “Items”, “Phase”, “Cost Types” tabs.<br />
<br />
Some of the tab name is probably not familiar to you, translation:<br />
* Items – Contract Items, these are the items shows up on your billing. <br />
* Phases – Cost Codes, this tab allows you to adjust how the codes are linked with Contract Items. (you don’t have to change the links, the contract items and their amount are much easier to adjust in Job Cost – JC Contract Master module). <br />
* Cost Types – Cost Types of each cost code. This tab shows, for example the cost allocated in each cost type for each cost code.<br />
<br />
On the contract items tab, you can edit the contract Item descriptions here. I recommend to do it in JC – Contract Master module once the import is completed however.<br />
[[File:Budget Upload - Review Data Table.png|thumb|Review Data Table]]<br />
On the cost code tab, any error will be high lighted with red. Error on this tab typically is caused by the Cost Code does not existing in Master Cost Code list. Select the line with Error, double click the phase field to edit. Click F4 key on your keyboard to call out the cost code look up list, pick an appropriate code from the list. Once the code is picked, you can also add .xx.xx to it to make it more customized. For example, 12010.01. Click “Save” button, or Ctrl+S to save the change. Viewpoint will prompt you a dialog ask if it should create a phase cross reference record, '''make sure to select “NO”'''. If you accidentally clicked yes, let Siyuan know, the cross reference can be deleted from the template.<br />
<br />
Similar procedure for Cost Types tab. Viewpoint has a bug that even if you changed cost code on Phase tab, the Cost Types tab will still show the error (although the cost code is correct). To clear up the error, you will need to double click the cost code and type in the same code again. Similar procedure for Unit of Measure Error as well. Annoying I know, hopefully they fix that in the future. <br />
<br />
Once all errors are cleared up, you can click the “Upload into PM” button. Viewpoint will open a window for this. Defaulted to the most recent Data Table that you edited. In the Project field, put in the project number that this budget is going into. The Start Month – this is the effective month of your budget, not your project schedule start. For example, if you set the start month to 02/21, the budget you upload today will not shown in forecast till the February batch in 2021. Doesn’t matter if you interfaced to December 2020. The red text here is a warning, telling me there are existing cost code and cost ($0 count as well) in the project already. Uploading will have the budget accumulated. If this is the first time budget uploading to this project, it typically because some codes were opened up by accounting for insurance purposes.<br />
<br />
'''Always a good habit to check!!''' Locate in Job Cost – Programs, the JC Original Estimate module. Open it, you will see what's existing in your project, for both cost code, and budget. '''If you already have budget in the project, uploading will accumulate, instead of overwrite.'''<br />
<br />
Another Option is to upload the budget as COQ (Change Order). This is useful for project that budget get approved in phases. PCO type is always COQ. The PCO field, is correspond to Pending Change Order module, pick one that you intent to use. Make a good (consistent) name for your COQ. Starting PCO item field, correspond to the PCO item in Pending Change Order. Typically you want this to start with 1, unless you are adding to an existing PCO. Increment by: '''Typically you want set this to 1'''. I can’t think of anything that would make you to change this to anything else. Note that the each Contract Item will be a new PCO item, when you are adding the budget as a change order.<br />
[[File:Budget Upload - Upload to PM.png|thumb|Import Estimate – Upload to PM]]<br />
Then hit the Upload button. Once the budget uploaded, it will prompt you that the budget is uploaded, and if you want to delete the data table. You can go ahead and delete it. If the data table have errors that’s not cleared up. You will not be able to upload the budget, instead, Viewpoint will prompt you a message box and tell you this. Since I have already uploaded my budget, I will not try to upload again. Just pretend the picture on the left is what you see once clicked the upload button.<br />
<br />
Locate the “Interface” module in Project Management – Program Folder. Double Click to open this program. Hit Validate, then Interface.<br />
[[File:Budget Upload - Add Bond Insurance Fee.png|thumb|Add Bond Insurance Fee]]<br />
Now go back to the Job Cost – Program, open module JC Original Estimate program. Remember that the items entered on the Summary sheet in Estimate Template will not be pulled? This is where we enter those a few items. Bond, Insurance, Fee. <br />
<br />
'''Once all these item added, your project total should matches up the contract amount.'''<br />
<br />
==== Import Estimate – Billing Schedule ====<br />
Locate in Job Cost – Program folder, JC Contract Master module. Double click to open.<br />
[[File:Budget Upload - Billing Schedule.png|thumb|Editing Billing Schedule]]<br />
# Go to your project, then select “Items” tab.<br />
# Adjust the description, add/delete the lines as needed.<br />
# Adjust the $ value in the Orig Amount. <br />
# The total amount should match the contract value.<br />
# Essentially this is the billing structure that accounting will get you to complete every month.<br />
Do:<br />
* Review tender documents and see if certain billing structure is required.<br />
* Check with CM or OM see if there are certain billing structure should be used<br />
* Check with Client and see if they want any particular item broken out<br />
* Double check the total mount of Billing, matches total amount of Estimate, Matches total amount of Contract Value.</div>ASamoilhttps://thewiki.builtplainly.com/index.php?title=Budget_Upload&diff=998Budget Upload2022-06-10T14:53:39Z<p>ASamoil: /* Est 2.0 CSV Creation method */</p>
<hr />
<div>== Introduction ==<br />
=== Objective: ===<br />
Establish a basic understanding and procedure for uploading budget from Estimate Template to Viewpoint.<br />
=== Agenda ===<br />
* Process diagram<br />
* Step by Step Tutorial<br />
* Buyout and adjust detail estimate<br />
* Consolidate detail estimate, fine tune code, units, descriptions<br />
* Export CSV file<br />
* Import CSV file to Viewpoint<br />
* Set up Billing<br />
== Tutorial ==<br />
=== What happens after a win? ===<br />
From operation standpoint we focus on the Estimate Review<br />
* Cost Code Clean Up<br />
* Consolidate Units<br />
* Review Cost and Bid<br />
* Buyout scopes<br />
* Identify contingency vs cash allowance<br />
* Any special agreement or alignment of trades<br />
* Etc.<br />
<br />
<sequencediagram style="modern-blue"><br />
Customer->Estimator: Award Project\nto Synergy<br />
Note over Estimator, Estimate\nTemplate : Reconcile Bids\nOrganize Bid Binder<br />
Estimator->Operation Team: Control Estimate (the Book)<br />
Estimator->Operation Team: Bid Binder<br />
Note over Estimator, Operation Team: Review Bid Strategy, Bids, Schedule\n(Turn Over Meeting)<br />
Note over Estimate\nTemplate, Operation Team:Review Estimate\nClean up Cost Code\nConsolidate Units\nReview Cost<br />
Estimate\nTemplate->Operation Team:Budget .CSV file<br />
Operation Team-> Viewpoint: Upload Budget <br />
</sequencediagram><br />
<br />
Then,<br />
# The entire estimate data after cleanup get poured into Viewpoint using a '''[https://en.wikipedia.org/wiki/Comma-separated_values .CSV file]'''.<br />
# The CSV file is structured specifically in a format Viewpoint can read using Import Estimate Module.<br />
=== Step-by-Step ===<br />
==== Within Estimate Work Book, you will need to do the following ====<br />
===== Step 1: Locate the "Tab" =====<br />
[[File:Budget Upload - Worksheets.png|frame|center|sample estimate workbook]]<br />
# Open the Estimate File received from Estimate Turn Over Meeting<br />
# Locate “Summary” and Division pages, drag and position those sheets to the front of all other sheets.<br />
# Locate “Est To VP” Tab, there are 6 buttons on this tab, each have their own corresponded functions. We will go through them in later pages.<br />
<br />
===== Step 2: Buy Out, Estimate Adjustment =====<br />
# Do your contract buy out.<br />
# During the buy out, modify the estimate file to match the scope that was bought into the trade’s scope.<br />
[[File:Budget Upload - Sample Buyout.png|thumb|sample buyout process]]<br />
# For the example that was shown here, the access panel and a few other scopes were estimated with own forces. During buy out, the drywaller agreed to take on those scopes for an additional cost. The number has been adjusted and moved to Subcontract Cost accordingly.<br />
# During buy out, if agreement were made for trades to take on certain additional scope for no or any cost, modify the estimate file to match the agreements.<br />
# Repeat this for all scopes pertains to the project.<br />
# In case any offsets from original contract value, we can add those after all the buy out to contingency, or book fee – pending on each project case.<br />
<br />
===== Step 3: Pull All Estimate Data To One Page =====<br />
# Locate the button called “Consolidate”. Click on it, will open a dialog allow you to select which page to include on pulling the Estimate Data Over.<br />
[[File:Budget Upload - Consolidation Button.png|thumb|consolidation button]]<br />
# In most cases, all pages from 1 to 16 will be selected.<br />
# However, if only a portion of the budget is getting uploaded, such as a change order, select only the page you want to upload.<br />
<br />
In the "Consolidation" worksheet, we can fine tune the cost codes, units, descriptions.<br />
An example is shown here. This page allows you to [[File:Budget Update - Consolidation.PNG|thumb|sample consolidation page]]<br />
* view which lines share the same cost code<br />
* Group or ungroup the cost lines by cost code<br />
* Adjusting unit of measure, quantities as needed.<br />
* This page does not allow modification to costs per se.<br />
'''Do''' <br />
* A quick check on each Division line and make sure the cost matches.<br />
* Remind yourself that any additional cost located on the summary page will not shown here – such as Insurance and Fee.<br />
'''Don’t'''<br />
* Try to change the format<br />
* Try to change the cost<br />
You can modify the description, unit of measure, quantity of the first line of the duplicated code so that the description make sense in your future forecast. In the example that’s shown, I have changed the description from “Orientation and Labour” to “Safety Equipment, Orientation and Labour” as this code contains both costlines. <br />
[[File:Budget Upload - Consolidation Description Change.png|frame|center]]<br />
The upload result of this example will be<br />
* Quantity of 20 with units of weeks<br />
* 140 hours of labour, $2,720+$5,600 for labour cost<br />
* $7,800 for material cost.<br />
* Repeat this for all cost lines.<br />
You can also combine or separate cost code for costlines. in this example, I have separated the cost code for flooring protection from the flooring subtrade. Doing so allows me to forecast easier during project execution phase. Do this as needed for all cost lines.<br />
<br />
Once you have gone thru all the cost lines, review with CM or OM if required. If you are comfortable with the consolidation and the PM has completed the above checks, you can begin to export to Viewpoint phase<br />
* Locate the “CSV Export” button, a dialog will show to let you save the CSV file generated for this estimate.<br />
* Modify the file name as needed, click “Save”.<br />
* It is recommended saving this file to the project folder, under “4 – Estimating”<br />
<br />
=== Est 2.0 CSV Creation method ===<br />
1. [[Consolidate]]<br />
<br />
2. [[CSV Export]]<br />
<br />
<br />
==== Import Estimate ====<br />
===== Do this using Viewpoint Import Estimate Program. =====<br />
Log into Viewpoint, Locate Module “PM Import Estimate” in Project Management – Program folder. Double Click to open the module.<br />
[[File:Budget Upload - Viewpoint Import Estimate Location.png|thumb|Locate Import Estimate Module]]<br />
<br />
This module contains a few different buttons.<br />
* Template Master lists all template that can be used to read the CSV file. We will not be touching this button.<br />
* Import Data lets you import the CSB file that was exported<br />
* Edit Work Tables lets you edit any imported budget table.<br />
* Upload into PM lets you pour the data into PM module, either as Original Estimate or as a Change Order to Existing Estimate.<br />
<br />
Click the Import Data, a window will pop open as the example shows.<br />
[[File:Budget Upload - Import Estimate Button.png|thumb|Import Estimate Button]]<br />
* For template, use SYN, this is the template made for Synergy to read a specific CSV format.<br />
* For “Import File 1:” field, click “Browse” button to the right, and select the CSV file that was exported.<br />
* For “Import ID” field, make a new Import ID, for example, you can use your initial + a number.<br />
* For Default Holdback Percentage, use 10%. <br />
* Click “Import” Button<br />
<br />
Viewpoint will be doing some work, if the project is big, in regards to amount of cost codes, it may take a minute or two. Once the file is imported, Viewpoint will prompt you a Message Box, sometimes it will say there are some errors. These errors are caused by non-standard cost code, or unit of measures that was used during estimating stage, or during consolidation stage.<br />
<br />
Click on the “Edit Work Tables” button, Viewpoint will open up a window, by default it will open the most recent import made by you. We will only be using the “Items”, “Phase”, “Cost Types” tabs.<br />
<br />
Some of the tab name is probably not familiar to you, translation:<br />
* Items – Contract Items, these are the items shows up on your billing. <br />
* Phases – Cost Codes, this tab allows you to adjust how the codes are linked with Contract Items. (you don’t have to change the links, the contract items and their amount are much easier to adjust in Job Cost – JC Contract Master module). <br />
* Cost Types – Cost Types of each cost code. This tab shows, for example the cost allocated in each cost type for each cost code.<br />
<br />
On the contract items tab, you can edit the contract Item descriptions here. I recommend to do it in JC – Contract Master module once the import is completed however.<br />
[[File:Budget Upload - Review Data Table.png|thumb|Review Data Table]]<br />
On the cost code tab, any error will be high lighted with red. Error on this tab typically is caused by the Cost Code does not existing in Master Cost Code list. Select the line with Error, double click the phase field to edit. Click F4 key on your keyboard to call out the cost code look up list, pick an appropriate code from the list. Once the code is picked, you can also add .xx.xx to it to make it more customized. For example, 12010.01. Click “Save” button, or Ctrl+S to save the change. Viewpoint will prompt you a dialog ask if it should create a phase cross reference record, '''make sure to select “NO”'''. If you accidentally clicked yes, let Siyuan know, the cross reference can be deleted from the template.<br />
<br />
Similar procedure for Cost Types tab. Viewpoint has a bug that even if you changed cost code on Phase tab, the Cost Types tab will still show the error (although the cost code is correct). To clear up the error, you will need to double click the cost code and type in the same code again. Similar procedure for Unit of Measure Error as well. Annoying I know, hopefully they fix that in the future. <br />
<br />
Once all errors are cleared up, you can click the “Upload into PM” button. Viewpoint will open a window for this. Defaulted to the most recent Data Table that you edited. In the Project field, put in the project number that this budget is going into. The Start Month – this is the effective month of your budget, not your project schedule start. For example, if you set the start month to 02/21, the budget you upload today will not shown in forecast till the February batch in 2021. Doesn’t matter if you interfaced to December 2020. The red text here is a warning, telling me there are existing cost code and cost ($0 count as well) in the project already. Uploading will have the budget accumulated. If this is the first time budget uploading to this project, it typically because some codes were opened up by accounting for insurance purposes.<br />
<br />
'''Always a good habit to check!!''' Locate in Job Cost – Programs, the JC Original Estimate module. Open it, you will see what's existing in your project, for both cost code, and budget. '''If you already have budget in the project, uploading will accumulate, instead of overwrite.'''<br />
<br />
Another Option is to upload the budget as COQ (Change Order). This is useful for project that budget get approved in phases. PCO type is always COQ. The PCO field, is correspond to Pending Change Order module, pick one that you intent to use. Make a good (consistent) name for your COQ. Starting PCO item field, correspond to the PCO item in Pending Change Order. Typically you want this to start with 1, unless you are adding to an existing PCO. Increment by: '''Typically you want set this to 1'''. I can’t think of anything that would make you to change this to anything else. Note that the each Contract Item will be a new PCO item, when you are adding the budget as a change order.<br />
[[File:Budget Upload - Upload to PM.png|thumb|Import Estimate – Upload to PM]]<br />
Then hit the Upload button. Once the budget uploaded, it will prompt you that the budget is uploaded, and if you want to delete the data table. You can go ahead and delete it. If the data table have errors that’s not cleared up. You will not be able to upload the budget, instead, Viewpoint will prompt you a message box and tell you this. Since I have already uploaded my budget, I will not try to upload again. Just pretend the picture on the left is what you see once clicked the upload button.<br />
<br />
Locate the “Interface” module in Project Management – Program Folder. Double Click to open this program. Hit Validate, then Interface.<br />
[[File:Budget Upload - Add Bond Insurance Fee.png|thumb|Add Bond Insurance Fee]]<br />
Now go back to the Job Cost – Program, open module JC Original Estimate program. Remember that the items entered on the Summary sheet in Estimate Template will not be pulled? This is where we enter those a few items. Bond, Insurance, Fee. <br />
<br />
'''Once all these item added, your project total should matches up the contract amount.'''<br />
<br />
==== Import Estimate – Billing Schedule ====<br />
Locate in Job Cost – Program folder, JC Contract Master module. Double click to open.<br />
[[File:Budget Upload - Billing Schedule.png|thumb|Editing Billing Schedule]]<br />
# Go to your project, then select “Items” tab.<br />
# Adjust the description, add/delete the lines as needed.<br />
# Adjust the $ value in the Orig Amount. <br />
# The total amount should match the contract value.<br />
# Essentially this is the billing structure that accounting will get you to complete every month.<br />
Do:<br />
* Review tender documents and see if certain billing structure is required.<br />
* Check with CM or OM see if there are certain billing structure should be used<br />
* Check with Client and see if they want any particular item broken out<br />
* Double check the total mount of Billing, matches total amount of Estimate, Matches total amount of Contract Value.</div>ASamoilhttps://thewiki.builtplainly.com/index.php?title=Budget_Upload&diff=997Budget Upload2022-06-10T14:53:34Z<p>ASamoil: /* Est 2.0 CSV Creation method */</p>
<hr />
<div>== Introduction ==<br />
=== Objective: ===<br />
Establish a basic understanding and procedure for uploading budget from Estimate Template to Viewpoint.<br />
=== Agenda ===<br />
* Process diagram<br />
* Step by Step Tutorial<br />
* Buyout and adjust detail estimate<br />
* Consolidate detail estimate, fine tune code, units, descriptions<br />
* Export CSV file<br />
* Import CSV file to Viewpoint<br />
* Set up Billing<br />
== Tutorial ==<br />
=== What happens after a win? ===<br />
From operation standpoint we focus on the Estimate Review<br />
* Cost Code Clean Up<br />
* Consolidate Units<br />
* Review Cost and Bid<br />
* Buyout scopes<br />
* Identify contingency vs cash allowance<br />
* Any special agreement or alignment of trades<br />
* Etc.<br />
<br />
<sequencediagram style="modern-blue"><br />
Customer->Estimator: Award Project\nto Synergy<br />
Note over Estimator, Estimate\nTemplate : Reconcile Bids\nOrganize Bid Binder<br />
Estimator->Operation Team: Control Estimate (the Book)<br />
Estimator->Operation Team: Bid Binder<br />
Note over Estimator, Operation Team: Review Bid Strategy, Bids, Schedule\n(Turn Over Meeting)<br />
Note over Estimate\nTemplate, Operation Team:Review Estimate\nClean up Cost Code\nConsolidate Units\nReview Cost<br />
Estimate\nTemplate->Operation Team:Budget .CSV file<br />
Operation Team-> Viewpoint: Upload Budget <br />
</sequencediagram><br />
<br />
Then,<br />
# The entire estimate data after cleanup get poured into Viewpoint using a '''[https://en.wikipedia.org/wiki/Comma-separated_values .CSV file]'''.<br />
# The CSV file is structured specifically in a format Viewpoint can read using Import Estimate Module.<br />
=== Step-by-Step ===<br />
==== Within Estimate Work Book, you will need to do the following ====<br />
===== Step 1: Locate the "Tab" =====<br />
[[File:Budget Upload - Worksheets.png|frame|center|sample estimate workbook]]<br />
# Open the Estimate File received from Estimate Turn Over Meeting<br />
# Locate “Summary” and Division pages, drag and position those sheets to the front of all other sheets.<br />
# Locate “Est To VP” Tab, there are 6 buttons on this tab, each have their own corresponded functions. We will go through them in later pages.<br />
<br />
===== Step 2: Buy Out, Estimate Adjustment =====<br />
# Do your contract buy out.<br />
# During the buy out, modify the estimate file to match the scope that was bought into the trade’s scope.<br />
[[File:Budget Upload - Sample Buyout.png|thumb|sample buyout process]]<br />
# For the example that was shown here, the access panel and a few other scopes were estimated with own forces. During buy out, the drywaller agreed to take on those scopes for an additional cost. The number has been adjusted and moved to Subcontract Cost accordingly.<br />
# During buy out, if agreement were made for trades to take on certain additional scope for no or any cost, modify the estimate file to match the agreements.<br />
# Repeat this for all scopes pertains to the project.<br />
# In case any offsets from original contract value, we can add those after all the buy out to contingency, or book fee – pending on each project case.<br />
<br />
===== Step 3: Pull All Estimate Data To One Page =====<br />
# Locate the button called “Consolidate”. Click on it, will open a dialog allow you to select which page to include on pulling the Estimate Data Over.<br />
[[File:Budget Upload - Consolidation Button.png|thumb|consolidation button]]<br />
# In most cases, all pages from 1 to 16 will be selected.<br />
# However, if only a portion of the budget is getting uploaded, such as a change order, select only the page you want to upload.<br />
<br />
In the "Consolidation" worksheet, we can fine tune the cost codes, units, descriptions.<br />
An example is shown here. This page allows you to [[File:Budget Update - Consolidation.PNG|thumb|sample consolidation page]]<br />
* view which lines share the same cost code<br />
* Group or ungroup the cost lines by cost code<br />
* Adjusting unit of measure, quantities as needed.<br />
* This page does not allow modification to costs per se.<br />
'''Do''' <br />
* A quick check on each Division line and make sure the cost matches.<br />
* Remind yourself that any additional cost located on the summary page will not shown here – such as Insurance and Fee.<br />
'''Don’t'''<br />
* Try to change the format<br />
* Try to change the cost<br />
You can modify the description, unit of measure, quantity of the first line of the duplicated code so that the description make sense in your future forecast. In the example that’s shown, I have changed the description from “Orientation and Labour” to “Safety Equipment, Orientation and Labour” as this code contains both costlines. <br />
[[File:Budget Upload - Consolidation Description Change.png|frame|center]]<br />
The upload result of this example will be<br />
* Quantity of 20 with units of weeks<br />
* 140 hours of labour, $2,720+$5,600 for labour cost<br />
* $7,800 for material cost.<br />
* Repeat this for all cost lines.<br />
You can also combine or separate cost code for costlines. in this example, I have separated the cost code for flooring protection from the flooring subtrade. Doing so allows me to forecast easier during project execution phase. Do this as needed for all cost lines.<br />
<br />
Once you have gone thru all the cost lines, review with CM or OM if required. If you are comfortable with the consolidation and the PM has completed the above checks, you can begin to export to Viewpoint phase<br />
* Locate the “CSV Export” button, a dialog will show to let you save the CSV file generated for this estimate.<br />
* Modify the file name as needed, click “Save”.<br />
* It is recommended saving this file to the project folder, under “4 – Estimating”<br />
<br />
=== Est 2.0 CSV Creation method ===<br />
1. [[Consolidate]]<br />
<br />
2. [[CSV Export]]<br />
<br />
<br />
<br />
<br />
==== Import Estimate ====<br />
===== Do this using Viewpoint Import Estimate Program. =====<br />
Log into Viewpoint, Locate Module “PM Import Estimate” in Project Management – Program folder. Double Click to open the module.<br />
[[File:Budget Upload - Viewpoint Import Estimate Location.png|thumb|Locate Import Estimate Module]]<br />
<br />
This module contains a few different buttons.<br />
* Template Master lists all template that can be used to read the CSV file. We will not be touching this button.<br />
* Import Data lets you import the CSB file that was exported<br />
* Edit Work Tables lets you edit any imported budget table.<br />
* Upload into PM lets you pour the data into PM module, either as Original Estimate or as a Change Order to Existing Estimate.<br />
<br />
Click the Import Data, a window will pop open as the example shows.<br />
[[File:Budget Upload - Import Estimate Button.png|thumb|Import Estimate Button]]<br />
* For template, use SYN, this is the template made for Synergy to read a specific CSV format.<br />
* For “Import File 1:” field, click “Browse” button to the right, and select the CSV file that was exported.<br />
* For “Import ID” field, make a new Import ID, for example, you can use your initial + a number.<br />
* For Default Holdback Percentage, use 10%. <br />
* Click “Import” Button<br />
<br />
Viewpoint will be doing some work, if the project is big, in regards to amount of cost codes, it may take a minute or two. Once the file is imported, Viewpoint will prompt you a Message Box, sometimes it will say there are some errors. These errors are caused by non-standard cost code, or unit of measures that was used during estimating stage, or during consolidation stage.<br />
<br />
Click on the “Edit Work Tables” button, Viewpoint will open up a window, by default it will open the most recent import made by you. We will only be using the “Items”, “Phase”, “Cost Types” tabs.<br />
<br />
Some of the tab name is probably not familiar to you, translation:<br />
* Items – Contract Items, these are the items shows up on your billing. <br />
* Phases – Cost Codes, this tab allows you to adjust how the codes are linked with Contract Items. (you don’t have to change the links, the contract items and their amount are much easier to adjust in Job Cost – JC Contract Master module). <br />
* Cost Types – Cost Types of each cost code. This tab shows, for example the cost allocated in each cost type for each cost code.<br />
<br />
On the contract items tab, you can edit the contract Item descriptions here. I recommend to do it in JC – Contract Master module once the import is completed however.<br />
[[File:Budget Upload - Review Data Table.png|thumb|Review Data Table]]<br />
On the cost code tab, any error will be high lighted with red. Error on this tab typically is caused by the Cost Code does not existing in Master Cost Code list. Select the line with Error, double click the phase field to edit. Click F4 key on your keyboard to call out the cost code look up list, pick an appropriate code from the list. Once the code is picked, you can also add .xx.xx to it to make it more customized. For example, 12010.01. Click “Save” button, or Ctrl+S to save the change. Viewpoint will prompt you a dialog ask if it should create a phase cross reference record, '''make sure to select “NO”'''. If you accidentally clicked yes, let Siyuan know, the cross reference can be deleted from the template.<br />
<br />
Similar procedure for Cost Types tab. Viewpoint has a bug that even if you changed cost code on Phase tab, the Cost Types tab will still show the error (although the cost code is correct). To clear up the error, you will need to double click the cost code and type in the same code again. Similar procedure for Unit of Measure Error as well. Annoying I know, hopefully they fix that in the future. <br />
<br />
Once all errors are cleared up, you can click the “Upload into PM” button. Viewpoint will open a window for this. Defaulted to the most recent Data Table that you edited. In the Project field, put in the project number that this budget is going into. The Start Month – this is the effective month of your budget, not your project schedule start. For example, if you set the start month to 02/21, the budget you upload today will not shown in forecast till the February batch in 2021. Doesn’t matter if you interfaced to December 2020. The red text here is a warning, telling me there are existing cost code and cost ($0 count as well) in the project already. Uploading will have the budget accumulated. If this is the first time budget uploading to this project, it typically because some codes were opened up by accounting for insurance purposes.<br />
<br />
'''Always a good habit to check!!''' Locate in Job Cost – Programs, the JC Original Estimate module. Open it, you will see what's existing in your project, for both cost code, and budget. '''If you already have budget in the project, uploading will accumulate, instead of overwrite.'''<br />
<br />
Another Option is to upload the budget as COQ (Change Order). This is useful for project that budget get approved in phases. PCO type is always COQ. The PCO field, is correspond to Pending Change Order module, pick one that you intent to use. Make a good (consistent) name for your COQ. Starting PCO item field, correspond to the PCO item in Pending Change Order. Typically you want this to start with 1, unless you are adding to an existing PCO. Increment by: '''Typically you want set this to 1'''. I can’t think of anything that would make you to change this to anything else. Note that the each Contract Item will be a new PCO item, when you are adding the budget as a change order.<br />
[[File:Budget Upload - Upload to PM.png|thumb|Import Estimate – Upload to PM]]<br />
Then hit the Upload button. Once the budget uploaded, it will prompt you that the budget is uploaded, and if you want to delete the data table. You can go ahead and delete it. If the data table have errors that’s not cleared up. You will not be able to upload the budget, instead, Viewpoint will prompt you a message box and tell you this. Since I have already uploaded my budget, I will not try to upload again. Just pretend the picture on the left is what you see once clicked the upload button.<br />
<br />
Locate the “Interface” module in Project Management – Program Folder. Double Click to open this program. Hit Validate, then Interface.<br />
[[File:Budget Upload - Add Bond Insurance Fee.png|thumb|Add Bond Insurance Fee]]<br />
Now go back to the Job Cost – Program, open module JC Original Estimate program. Remember that the items entered on the Summary sheet in Estimate Template will not be pulled? This is where we enter those a few items. Bond, Insurance, Fee. <br />
<br />
'''Once all these item added, your project total should matches up the contract amount.'''<br />
<br />
==== Import Estimate – Billing Schedule ====<br />
Locate in Job Cost – Program folder, JC Contract Master module. Double click to open.<br />
[[File:Budget Upload - Billing Schedule.png|thumb|Editing Billing Schedule]]<br />
# Go to your project, then select “Items” tab.<br />
# Adjust the description, add/delete the lines as needed.<br />
# Adjust the $ value in the Orig Amount. <br />
# The total amount should match the contract value.<br />
# Essentially this is the billing structure that accounting will get you to complete every month.<br />
Do:<br />
* Review tender documents and see if certain billing structure is required.<br />
* Check with CM or OM see if there are certain billing structure should be used<br />
* Check with Client and see if they want any particular item broken out<br />
* Double check the total mount of Billing, matches total amount of Estimate, Matches total amount of Contract Value.</div>ASamoilhttps://thewiki.builtplainly.com/index.php?title=Budget_Upload&diff=996Budget Upload2022-06-10T14:53:11Z<p>ASamoil: /* Est 2.0 CSV Creation method */</p>
<hr />
<div>== Introduction ==<br />
=== Objective: ===<br />
Establish a basic understanding and procedure for uploading budget from Estimate Template to Viewpoint.<br />
=== Agenda ===<br />
* Process diagram<br />
* Step by Step Tutorial<br />
* Buyout and adjust detail estimate<br />
* Consolidate detail estimate, fine tune code, units, descriptions<br />
* Export CSV file<br />
* Import CSV file to Viewpoint<br />
* Set up Billing<br />
== Tutorial ==<br />
=== What happens after a win? ===<br />
From operation standpoint we focus on the Estimate Review<br />
* Cost Code Clean Up<br />
* Consolidate Units<br />
* Review Cost and Bid<br />
* Buyout scopes<br />
* Identify contingency vs cash allowance<br />
* Any special agreement or alignment of trades<br />
* Etc.<br />
<br />
<sequencediagram style="modern-blue"><br />
Customer->Estimator: Award Project\nto Synergy<br />
Note over Estimator, Estimate\nTemplate : Reconcile Bids\nOrganize Bid Binder<br />
Estimator->Operation Team: Control Estimate (the Book)<br />
Estimator->Operation Team: Bid Binder<br />
Note over Estimator, Operation Team: Review Bid Strategy, Bids, Schedule\n(Turn Over Meeting)<br />
Note over Estimate\nTemplate, Operation Team:Review Estimate\nClean up Cost Code\nConsolidate Units\nReview Cost<br />
Estimate\nTemplate->Operation Team:Budget .CSV file<br />
Operation Team-> Viewpoint: Upload Budget <br />
</sequencediagram><br />
<br />
Then,<br />
# The entire estimate data after cleanup get poured into Viewpoint using a '''[https://en.wikipedia.org/wiki/Comma-separated_values .CSV file]'''.<br />
# The CSV file is structured specifically in a format Viewpoint can read using Import Estimate Module.<br />
=== Step-by-Step ===<br />
==== Within Estimate Work Book, you will need to do the following ====<br />
===== Step 1: Locate the "Tab" =====<br />
[[File:Budget Upload - Worksheets.png|frame|center|sample estimate workbook]]<br />
# Open the Estimate File received from Estimate Turn Over Meeting<br />
# Locate “Summary” and Division pages, drag and position those sheets to the front of all other sheets.<br />
# Locate “Est To VP” Tab, there are 6 buttons on this tab, each have their own corresponded functions. We will go through them in later pages.<br />
<br />
===== Step 2: Buy Out, Estimate Adjustment =====<br />
# Do your contract buy out.<br />
# During the buy out, modify the estimate file to match the scope that was bought into the trade’s scope.<br />
[[File:Budget Upload - Sample Buyout.png|thumb|sample buyout process]]<br />
# For the example that was shown here, the access panel and a few other scopes were estimated with own forces. During buy out, the drywaller agreed to take on those scopes for an additional cost. The number has been adjusted and moved to Subcontract Cost accordingly.<br />
# During buy out, if agreement were made for trades to take on certain additional scope for no or any cost, modify the estimate file to match the agreements.<br />
# Repeat this for all scopes pertains to the project.<br />
# In case any offsets from original contract value, we can add those after all the buy out to contingency, or book fee – pending on each project case.<br />
<br />
===== Step 3: Pull All Estimate Data To One Page =====<br />
# Locate the button called “Consolidate”. Click on it, will open a dialog allow you to select which page to include on pulling the Estimate Data Over.<br />
[[File:Budget Upload - Consolidation Button.png|thumb|consolidation button]]<br />
# In most cases, all pages from 1 to 16 will be selected.<br />
# However, if only a portion of the budget is getting uploaded, such as a change order, select only the page you want to upload.<br />
<br />
In the "Consolidation" worksheet, we can fine tune the cost codes, units, descriptions.<br />
An example is shown here. This page allows you to [[File:Budget Update - Consolidation.PNG|thumb|sample consolidation page]]<br />
* view which lines share the same cost code<br />
* Group or ungroup the cost lines by cost code<br />
* Adjusting unit of measure, quantities as needed.<br />
* This page does not allow modification to costs per se.<br />
'''Do''' <br />
* A quick check on each Division line and make sure the cost matches.<br />
* Remind yourself that any additional cost located on the summary page will not shown here – such as Insurance and Fee.<br />
'''Don’t'''<br />
* Try to change the format<br />
* Try to change the cost<br />
You can modify the description, unit of measure, quantity of the first line of the duplicated code so that the description make sense in your future forecast. In the example that’s shown, I have changed the description from “Orientation and Labour” to “Safety Equipment, Orientation and Labour” as this code contains both costlines. <br />
[[File:Budget Upload - Consolidation Description Change.png|frame|center]]<br />
The upload result of this example will be<br />
* Quantity of 20 with units of weeks<br />
* 140 hours of labour, $2,720+$5,600 for labour cost<br />
* $7,800 for material cost.<br />
* Repeat this for all cost lines.<br />
You can also combine or separate cost code for costlines. in this example, I have separated the cost code for flooring protection from the flooring subtrade. Doing so allows me to forecast easier during project execution phase. Do this as needed for all cost lines.<br />
<br />
Once you have gone thru all the cost lines, review with CM or OM if required. If you are comfortable with the consolidation and the PM has completed the above checks, you can begin to export to Viewpoint phase<br />
* Locate the “CSV Export” button, a dialog will show to let you save the CSV file generated for this estimate.<br />
* Modify the file name as needed, click “Save”.<br />
* It is recommended saving this file to the project folder, under “4 – Estimating”<br />
<br />
=== Est 2.0 CSV Creation method ===<br />
1.<br />
==== [[Consolidate]] ====<br />
<br />
2.<br />
3. ==== [[CSV Export]] ====<br />
<br />
<br />
<br />
<br />
==== Import Estimate ====<br />
===== Do this using Viewpoint Import Estimate Program. =====<br />
Log into Viewpoint, Locate Module “PM Import Estimate” in Project Management – Program folder. Double Click to open the module.<br />
[[File:Budget Upload - Viewpoint Import Estimate Location.png|thumb|Locate Import Estimate Module]]<br />
<br />
This module contains a few different buttons.<br />
* Template Master lists all template that can be used to read the CSV file. We will not be touching this button.<br />
* Import Data lets you import the CSB file that was exported<br />
* Edit Work Tables lets you edit any imported budget table.<br />
* Upload into PM lets you pour the data into PM module, either as Original Estimate or as a Change Order to Existing Estimate.<br />
<br />
Click the Import Data, a window will pop open as the example shows.<br />
[[File:Budget Upload - Import Estimate Button.png|thumb|Import Estimate Button]]<br />
* For template, use SYN, this is the template made for Synergy to read a specific CSV format.<br />
* For “Import File 1:” field, click “Browse” button to the right, and select the CSV file that was exported.<br />
* For “Import ID” field, make a new Import ID, for example, you can use your initial + a number.<br />
* For Default Holdback Percentage, use 10%. <br />
* Click “Import” Button<br />
<br />
Viewpoint will be doing some work, if the project is big, in regards to amount of cost codes, it may take a minute or two. Once the file is imported, Viewpoint will prompt you a Message Box, sometimes it will say there are some errors. These errors are caused by non-standard cost code, or unit of measures that was used during estimating stage, or during consolidation stage.<br />
<br />
Click on the “Edit Work Tables” button, Viewpoint will open up a window, by default it will open the most recent import made by you. We will only be using the “Items”, “Phase”, “Cost Types” tabs.<br />
<br />
Some of the tab name is probably not familiar to you, translation:<br />
* Items – Contract Items, these are the items shows up on your billing. <br />
* Phases – Cost Codes, this tab allows you to adjust how the codes are linked with Contract Items. (you don’t have to change the links, the contract items and their amount are much easier to adjust in Job Cost – JC Contract Master module). <br />
* Cost Types – Cost Types of each cost code. This tab shows, for example the cost allocated in each cost type for each cost code.<br />
<br />
On the contract items tab, you can edit the contract Item descriptions here. I recommend to do it in JC – Contract Master module once the import is completed however.<br />
[[File:Budget Upload - Review Data Table.png|thumb|Review Data Table]]<br />
On the cost code tab, any error will be high lighted with red. Error on this tab typically is caused by the Cost Code does not existing in Master Cost Code list. Select the line with Error, double click the phase field to edit. Click F4 key on your keyboard to call out the cost code look up list, pick an appropriate code from the list. Once the code is picked, you can also add .xx.xx to it to make it more customized. For example, 12010.01. Click “Save” button, or Ctrl+S to save the change. Viewpoint will prompt you a dialog ask if it should create a phase cross reference record, '''make sure to select “NO”'''. If you accidentally clicked yes, let Siyuan know, the cross reference can be deleted from the template.<br />
<br />
Similar procedure for Cost Types tab. Viewpoint has a bug that even if you changed cost code on Phase tab, the Cost Types tab will still show the error (although the cost code is correct). To clear up the error, you will need to double click the cost code and type in the same code again. Similar procedure for Unit of Measure Error as well. Annoying I know, hopefully they fix that in the future. <br />
<br />
Once all errors are cleared up, you can click the “Upload into PM” button. Viewpoint will open a window for this. Defaulted to the most recent Data Table that you edited. In the Project field, put in the project number that this budget is going into. The Start Month – this is the effective month of your budget, not your project schedule start. For example, if you set the start month to 02/21, the budget you upload today will not shown in forecast till the February batch in 2021. Doesn’t matter if you interfaced to December 2020. The red text here is a warning, telling me there are existing cost code and cost ($0 count as well) in the project already. Uploading will have the budget accumulated. If this is the first time budget uploading to this project, it typically because some codes were opened up by accounting for insurance purposes.<br />
<br />
'''Always a good habit to check!!''' Locate in Job Cost – Programs, the JC Original Estimate module. Open it, you will see what's existing in your project, for both cost code, and budget. '''If you already have budget in the project, uploading will accumulate, instead of overwrite.'''<br />
<br />
Another Option is to upload the budget as COQ (Change Order). This is useful for project that budget get approved in phases. PCO type is always COQ. The PCO field, is correspond to Pending Change Order module, pick one that you intent to use. Make a good (consistent) name for your COQ. Starting PCO item field, correspond to the PCO item in Pending Change Order. Typically you want this to start with 1, unless you are adding to an existing PCO. Increment by: '''Typically you want set this to 1'''. I can’t think of anything that would make you to change this to anything else. Note that the each Contract Item will be a new PCO item, when you are adding the budget as a change order.<br />
[[File:Budget Upload - Upload to PM.png|thumb|Import Estimate – Upload to PM]]<br />
Then hit the Upload button. Once the budget uploaded, it will prompt you that the budget is uploaded, and if you want to delete the data table. You can go ahead and delete it. If the data table have errors that’s not cleared up. You will not be able to upload the budget, instead, Viewpoint will prompt you a message box and tell you this. Since I have already uploaded my budget, I will not try to upload again. Just pretend the picture on the left is what you see once clicked the upload button.<br />
<br />
Locate the “Interface” module in Project Management – Program Folder. Double Click to open this program. Hit Validate, then Interface.<br />
[[File:Budget Upload - Add Bond Insurance Fee.png|thumb|Add Bond Insurance Fee]]<br />
Now go back to the Job Cost – Program, open module JC Original Estimate program. Remember that the items entered on the Summary sheet in Estimate Template will not be pulled? This is where we enter those a few items. Bond, Insurance, Fee. <br />
<br />
'''Once all these item added, your project total should matches up the contract amount.'''<br />
<br />
==== Import Estimate – Billing Schedule ====<br />
Locate in Job Cost – Program folder, JC Contract Master module. Double click to open.<br />
[[File:Budget Upload - Billing Schedule.png|thumb|Editing Billing Schedule]]<br />
# Go to your project, then select “Items” tab.<br />
# Adjust the description, add/delete the lines as needed.<br />
# Adjust the $ value in the Orig Amount. <br />
# The total amount should match the contract value.<br />
# Essentially this is the billing structure that accounting will get you to complete every month.<br />
Do:<br />
* Review tender documents and see if certain billing structure is required.<br />
* Check with CM or OM see if there are certain billing structure should be used<br />
* Check with Client and see if they want any particular item broken out<br />
* Double check the total mount of Billing, matches total amount of Estimate, Matches total amount of Contract Value.</div>ASamoilhttps://thewiki.builtplainly.com/index.php?title=Budget_Upload&diff=995Budget Upload2022-06-10T14:53:00Z<p>ASamoil: /* Est 2.0 CSV Creation method */</p>
<hr />
<div>== Introduction ==<br />
=== Objective: ===<br />
Establish a basic understanding and procedure for uploading budget from Estimate Template to Viewpoint.<br />
=== Agenda ===<br />
* Process diagram<br />
* Step by Step Tutorial<br />
* Buyout and adjust detail estimate<br />
* Consolidate detail estimate, fine tune code, units, descriptions<br />
* Export CSV file<br />
* Import CSV file to Viewpoint<br />
* Set up Billing<br />
== Tutorial ==<br />
=== What happens after a win? ===<br />
From operation standpoint we focus on the Estimate Review<br />
* Cost Code Clean Up<br />
* Consolidate Units<br />
* Review Cost and Bid<br />
* Buyout scopes<br />
* Identify contingency vs cash allowance<br />
* Any special agreement or alignment of trades<br />
* Etc.<br />
<br />
<sequencediagram style="modern-blue"><br />
Customer->Estimator: Award Project\nto Synergy<br />
Note over Estimator, Estimate\nTemplate : Reconcile Bids\nOrganize Bid Binder<br />
Estimator->Operation Team: Control Estimate (the Book)<br />
Estimator->Operation Team: Bid Binder<br />
Note over Estimator, Operation Team: Review Bid Strategy, Bids, Schedule\n(Turn Over Meeting)<br />
Note over Estimate\nTemplate, Operation Team:Review Estimate\nClean up Cost Code\nConsolidate Units\nReview Cost<br />
Estimate\nTemplate->Operation Team:Budget .CSV file<br />
Operation Team-> Viewpoint: Upload Budget <br />
</sequencediagram><br />
<br />
Then,<br />
# The entire estimate data after cleanup get poured into Viewpoint using a '''[https://en.wikipedia.org/wiki/Comma-separated_values .CSV file]'''.<br />
# The CSV file is structured specifically in a format Viewpoint can read using Import Estimate Module.<br />
=== Step-by-Step ===<br />
==== Within Estimate Work Book, you will need to do the following ====<br />
===== Step 1: Locate the "Tab" =====<br />
[[File:Budget Upload - Worksheets.png|frame|center|sample estimate workbook]]<br />
# Open the Estimate File received from Estimate Turn Over Meeting<br />
# Locate “Summary” and Division pages, drag and position those sheets to the front of all other sheets.<br />
# Locate “Est To VP” Tab, there are 6 buttons on this tab, each have their own corresponded functions. We will go through them in later pages.<br />
<br />
===== Step 2: Buy Out, Estimate Adjustment =====<br />
# Do your contract buy out.<br />
# During the buy out, modify the estimate file to match the scope that was bought into the trade’s scope.<br />
[[File:Budget Upload - Sample Buyout.png|thumb|sample buyout process]]<br />
# For the example that was shown here, the access panel and a few other scopes were estimated with own forces. During buy out, the drywaller agreed to take on those scopes for an additional cost. The number has been adjusted and moved to Subcontract Cost accordingly.<br />
# During buy out, if agreement were made for trades to take on certain additional scope for no or any cost, modify the estimate file to match the agreements.<br />
# Repeat this for all scopes pertains to the project.<br />
# In case any offsets from original contract value, we can add those after all the buy out to contingency, or book fee – pending on each project case.<br />
<br />
===== Step 3: Pull All Estimate Data To One Page =====<br />
# Locate the button called “Consolidate”. Click on it, will open a dialog allow you to select which page to include on pulling the Estimate Data Over.<br />
[[File:Budget Upload - Consolidation Button.png|thumb|consolidation button]]<br />
# In most cases, all pages from 1 to 16 will be selected.<br />
# However, if only a portion of the budget is getting uploaded, such as a change order, select only the page you want to upload.<br />
<br />
In the "Consolidation" worksheet, we can fine tune the cost codes, units, descriptions.<br />
An example is shown here. This page allows you to [[File:Budget Update - Consolidation.PNG|thumb|sample consolidation page]]<br />
* view which lines share the same cost code<br />
* Group or ungroup the cost lines by cost code<br />
* Adjusting unit of measure, quantities as needed.<br />
* This page does not allow modification to costs per se.<br />
'''Do''' <br />
* A quick check on each Division line and make sure the cost matches.<br />
* Remind yourself that any additional cost located on the summary page will not shown here – such as Insurance and Fee.<br />
'''Don’t'''<br />
* Try to change the format<br />
* Try to change the cost<br />
You can modify the description, unit of measure, quantity of the first line of the duplicated code so that the description make sense in your future forecast. In the example that’s shown, I have changed the description from “Orientation and Labour” to “Safety Equipment, Orientation and Labour” as this code contains both costlines. <br />
[[File:Budget Upload - Consolidation Description Change.png|frame|center]]<br />
The upload result of this example will be<br />
* Quantity of 20 with units of weeks<br />
* 140 hours of labour, $2,720+$5,600 for labour cost<br />
* $7,800 for material cost.<br />
* Repeat this for all cost lines.<br />
You can also combine or separate cost code for costlines. in this example, I have separated the cost code for flooring protection from the flooring subtrade. Doing so allows me to forecast easier during project execution phase. Do this as needed for all cost lines.<br />
<br />
Once you have gone thru all the cost lines, review with CM or OM if required. If you are comfortable with the consolidation and the PM has completed the above checks, you can begin to export to Viewpoint phase<br />
* Locate the “CSV Export” button, a dialog will show to let you save the CSV file generated for this estimate.<br />
* Modify the file name as needed, click “Save”.<br />
* It is recommended saving this file to the project folder, under “4 – Estimating”<br />
<br />
=== Est 2.0 CSV Creation method ===<br />
1.<br />
==== [[Consolidate]] ====<br />
<br />
2.<br />
==== [[CSV Export]] ====<br />
<br />
<br />
<br />
<br />
==== Import Estimate ====<br />
===== Do this using Viewpoint Import Estimate Program. =====<br />
Log into Viewpoint, Locate Module “PM Import Estimate” in Project Management – Program folder. Double Click to open the module.<br />
[[File:Budget Upload - Viewpoint Import Estimate Location.png|thumb|Locate Import Estimate Module]]<br />
<br />
This module contains a few different buttons.<br />
* Template Master lists all template that can be used to read the CSV file. We will not be touching this button.<br />
* Import Data lets you import the CSB file that was exported<br />
* Edit Work Tables lets you edit any imported budget table.<br />
* Upload into PM lets you pour the data into PM module, either as Original Estimate or as a Change Order to Existing Estimate.<br />
<br />
Click the Import Data, a window will pop open as the example shows.<br />
[[File:Budget Upload - Import Estimate Button.png|thumb|Import Estimate Button]]<br />
* For template, use SYN, this is the template made for Synergy to read a specific CSV format.<br />
* For “Import File 1:” field, click “Browse” button to the right, and select the CSV file that was exported.<br />
* For “Import ID” field, make a new Import ID, for example, you can use your initial + a number.<br />
* For Default Holdback Percentage, use 10%. <br />
* Click “Import” Button<br />
<br />
Viewpoint will be doing some work, if the project is big, in regards to amount of cost codes, it may take a minute or two. Once the file is imported, Viewpoint will prompt you a Message Box, sometimes it will say there are some errors. These errors are caused by non-standard cost code, or unit of measures that was used during estimating stage, or during consolidation stage.<br />
<br />
Click on the “Edit Work Tables” button, Viewpoint will open up a window, by default it will open the most recent import made by you. We will only be using the “Items”, “Phase”, “Cost Types” tabs.<br />
<br />
Some of the tab name is probably not familiar to you, translation:<br />
* Items – Contract Items, these are the items shows up on your billing. <br />
* Phases – Cost Codes, this tab allows you to adjust how the codes are linked with Contract Items. (you don’t have to change the links, the contract items and their amount are much easier to adjust in Job Cost – JC Contract Master module). <br />
* Cost Types – Cost Types of each cost code. This tab shows, for example the cost allocated in each cost type for each cost code.<br />
<br />
On the contract items tab, you can edit the contract Item descriptions here. I recommend to do it in JC – Contract Master module once the import is completed however.<br />
[[File:Budget Upload - Review Data Table.png|thumb|Review Data Table]]<br />
On the cost code tab, any error will be high lighted with red. Error on this tab typically is caused by the Cost Code does not existing in Master Cost Code list. Select the line with Error, double click the phase field to edit. Click F4 key on your keyboard to call out the cost code look up list, pick an appropriate code from the list. Once the code is picked, you can also add .xx.xx to it to make it more customized. For example, 12010.01. Click “Save” button, or Ctrl+S to save the change. Viewpoint will prompt you a dialog ask if it should create a phase cross reference record, '''make sure to select “NO”'''. If you accidentally clicked yes, let Siyuan know, the cross reference can be deleted from the template.<br />
<br />
Similar procedure for Cost Types tab. Viewpoint has a bug that even if you changed cost code on Phase tab, the Cost Types tab will still show the error (although the cost code is correct). To clear up the error, you will need to double click the cost code and type in the same code again. Similar procedure for Unit of Measure Error as well. Annoying I know, hopefully they fix that in the future. <br />
<br />
Once all errors are cleared up, you can click the “Upload into PM” button. Viewpoint will open a window for this. Defaulted to the most recent Data Table that you edited. In the Project field, put in the project number that this budget is going into. The Start Month – this is the effective month of your budget, not your project schedule start. For example, if you set the start month to 02/21, the budget you upload today will not shown in forecast till the February batch in 2021. Doesn’t matter if you interfaced to December 2020. The red text here is a warning, telling me there are existing cost code and cost ($0 count as well) in the project already. Uploading will have the budget accumulated. If this is the first time budget uploading to this project, it typically because some codes were opened up by accounting for insurance purposes.<br />
<br />
'''Always a good habit to check!!''' Locate in Job Cost – Programs, the JC Original Estimate module. Open it, you will see what's existing in your project, for both cost code, and budget. '''If you already have budget in the project, uploading will accumulate, instead of overwrite.'''<br />
<br />
Another Option is to upload the budget as COQ (Change Order). This is useful for project that budget get approved in phases. PCO type is always COQ. The PCO field, is correspond to Pending Change Order module, pick one that you intent to use. Make a good (consistent) name for your COQ. Starting PCO item field, correspond to the PCO item in Pending Change Order. Typically you want this to start with 1, unless you are adding to an existing PCO. Increment by: '''Typically you want set this to 1'''. I can’t think of anything that would make you to change this to anything else. Note that the each Contract Item will be a new PCO item, when you are adding the budget as a change order.<br />
[[File:Budget Upload - Upload to PM.png|thumb|Import Estimate – Upload to PM]]<br />
Then hit the Upload button. Once the budget uploaded, it will prompt you that the budget is uploaded, and if you want to delete the data table. You can go ahead and delete it. If the data table have errors that’s not cleared up. You will not be able to upload the budget, instead, Viewpoint will prompt you a message box and tell you this. Since I have already uploaded my budget, I will not try to upload again. Just pretend the picture on the left is what you see once clicked the upload button.<br />
<br />
Locate the “Interface” module in Project Management – Program Folder. Double Click to open this program. Hit Validate, then Interface.<br />
[[File:Budget Upload - Add Bond Insurance Fee.png|thumb|Add Bond Insurance Fee]]<br />
Now go back to the Job Cost – Program, open module JC Original Estimate program. Remember that the items entered on the Summary sheet in Estimate Template will not be pulled? This is where we enter those a few items. Bond, Insurance, Fee. <br />
<br />
'''Once all these item added, your project total should matches up the contract amount.'''<br />
<br />
==== Import Estimate – Billing Schedule ====<br />
Locate in Job Cost – Program folder, JC Contract Master module. Double click to open.<br />
[[File:Budget Upload - Billing Schedule.png|thumb|Editing Billing Schedule]]<br />
# Go to your project, then select “Items” tab.<br />
# Adjust the description, add/delete the lines as needed.<br />
# Adjust the $ value in the Orig Amount. <br />
# The total amount should match the contract value.<br />
# Essentially this is the billing structure that accounting will get you to complete every month.<br />
Do:<br />
* Review tender documents and see if certain billing structure is required.<br />
* Check with CM or OM see if there are certain billing structure should be used<br />
* Check with Client and see if they want any particular item broken out<br />
* Double check the total mount of Billing, matches total amount of Estimate, Matches total amount of Contract Value.</div>ASamoilhttps://thewiki.builtplainly.com/index.php?title=Budget_Upload&diff=994Budget Upload2022-06-10T14:52:54Z<p>ASamoil: /* Est 2.0 CSV Creation method */</p>
<hr />
<div>== Introduction ==<br />
=== Objective: ===<br />
Establish a basic understanding and procedure for uploading budget from Estimate Template to Viewpoint.<br />
=== Agenda ===<br />
* Process diagram<br />
* Step by Step Tutorial<br />
* Buyout and adjust detail estimate<br />
* Consolidate detail estimate, fine tune code, units, descriptions<br />
* Export CSV file<br />
* Import CSV file to Viewpoint<br />
* Set up Billing<br />
== Tutorial ==<br />
=== What happens after a win? ===<br />
From operation standpoint we focus on the Estimate Review<br />
* Cost Code Clean Up<br />
* Consolidate Units<br />
* Review Cost and Bid<br />
* Buyout scopes<br />
* Identify contingency vs cash allowance<br />
* Any special agreement or alignment of trades<br />
* Etc.<br />
<br />
<sequencediagram style="modern-blue"><br />
Customer->Estimator: Award Project\nto Synergy<br />
Note over Estimator, Estimate\nTemplate : Reconcile Bids\nOrganize Bid Binder<br />
Estimator->Operation Team: Control Estimate (the Book)<br />
Estimator->Operation Team: Bid Binder<br />
Note over Estimator, Operation Team: Review Bid Strategy, Bids, Schedule\n(Turn Over Meeting)<br />
Note over Estimate\nTemplate, Operation Team:Review Estimate\nClean up Cost Code\nConsolidate Units\nReview Cost<br />
Estimate\nTemplate->Operation Team:Budget .CSV file<br />
Operation Team-> Viewpoint: Upload Budget <br />
</sequencediagram><br />
<br />
Then,<br />
# The entire estimate data after cleanup get poured into Viewpoint using a '''[https://en.wikipedia.org/wiki/Comma-separated_values .CSV file]'''.<br />
# The CSV file is structured specifically in a format Viewpoint can read using Import Estimate Module.<br />
=== Step-by-Step ===<br />
==== Within Estimate Work Book, you will need to do the following ====<br />
===== Step 1: Locate the "Tab" =====<br />
[[File:Budget Upload - Worksheets.png|frame|center|sample estimate workbook]]<br />
# Open the Estimate File received from Estimate Turn Over Meeting<br />
# Locate “Summary” and Division pages, drag and position those sheets to the front of all other sheets.<br />
# Locate “Est To VP” Tab, there are 6 buttons on this tab, each have their own corresponded functions. We will go through them in later pages.<br />
<br />
===== Step 2: Buy Out, Estimate Adjustment =====<br />
# Do your contract buy out.<br />
# During the buy out, modify the estimate file to match the scope that was bought into the trade’s scope.<br />
[[File:Budget Upload - Sample Buyout.png|thumb|sample buyout process]]<br />
# For the example that was shown here, the access panel and a few other scopes were estimated with own forces. During buy out, the drywaller agreed to take on those scopes for an additional cost. The number has been adjusted and moved to Subcontract Cost accordingly.<br />
# During buy out, if agreement were made for trades to take on certain additional scope for no or any cost, modify the estimate file to match the agreements.<br />
# Repeat this for all scopes pertains to the project.<br />
# In case any offsets from original contract value, we can add those after all the buy out to contingency, or book fee – pending on each project case.<br />
<br />
===== Step 3: Pull All Estimate Data To One Page =====<br />
# Locate the button called “Consolidate”. Click on it, will open a dialog allow you to select which page to include on pulling the Estimate Data Over.<br />
[[File:Budget Upload - Consolidation Button.png|thumb|consolidation button]]<br />
# In most cases, all pages from 1 to 16 will be selected.<br />
# However, if only a portion of the budget is getting uploaded, such as a change order, select only the page you want to upload.<br />
<br />
In the "Consolidation" worksheet, we can fine tune the cost codes, units, descriptions.<br />
An example is shown here. This page allows you to [[File:Budget Update - Consolidation.PNG|thumb|sample consolidation page]]<br />
* view which lines share the same cost code<br />
* Group or ungroup the cost lines by cost code<br />
* Adjusting unit of measure, quantities as needed.<br />
* This page does not allow modification to costs per se.<br />
'''Do''' <br />
* A quick check on each Division line and make sure the cost matches.<br />
* Remind yourself that any additional cost located on the summary page will not shown here – such as Insurance and Fee.<br />
'''Don’t'''<br />
* Try to change the format<br />
* Try to change the cost<br />
You can modify the description, unit of measure, quantity of the first line of the duplicated code so that the description make sense in your future forecast. In the example that’s shown, I have changed the description from “Orientation and Labour” to “Safety Equipment, Orientation and Labour” as this code contains both costlines. <br />
[[File:Budget Upload - Consolidation Description Change.png|frame|center]]<br />
The upload result of this example will be<br />
* Quantity of 20 with units of weeks<br />
* 140 hours of labour, $2,720+$5,600 for labour cost<br />
* $7,800 for material cost.<br />
* Repeat this for all cost lines.<br />
You can also combine or separate cost code for costlines. in this example, I have separated the cost code for flooring protection from the flooring subtrade. Doing so allows me to forecast easier during project execution phase. Do this as needed for all cost lines.<br />
<br />
Once you have gone thru all the cost lines, review with CM or OM if required. If you are comfortable with the consolidation and the PM has completed the above checks, you can begin to export to Viewpoint phase<br />
* Locate the “CSV Export” button, a dialog will show to let you save the CSV file generated for this estimate.<br />
* Modify the file name as needed, click “Save”.<br />
* It is recommended saving this file to the project folder, under “4 – Estimating”<br />
<br />
=== Est 2.0 CSV Creation method ===<br />
1.<br />
==== [[Consolidate]] ====<br />
<br />
2.<br />
==== [[CSV Export]] ====<br />
<br />
<br />
<br />
==== Import Estimate ====<br />
===== Do this using Viewpoint Import Estimate Program. =====<br />
Log into Viewpoint, Locate Module “PM Import Estimate” in Project Management – Program folder. Double Click to open the module.<br />
[[File:Budget Upload - Viewpoint Import Estimate Location.png|thumb|Locate Import Estimate Module]]<br />
<br />
This module contains a few different buttons.<br />
* Template Master lists all template that can be used to read the CSV file. We will not be touching this button.<br />
* Import Data lets you import the CSB file that was exported<br />
* Edit Work Tables lets you edit any imported budget table.<br />
* Upload into PM lets you pour the data into PM module, either as Original Estimate or as a Change Order to Existing Estimate.<br />
<br />
Click the Import Data, a window will pop open as the example shows.<br />
[[File:Budget Upload - Import Estimate Button.png|thumb|Import Estimate Button]]<br />
* For template, use SYN, this is the template made for Synergy to read a specific CSV format.<br />
* For “Import File 1:” field, click “Browse” button to the right, and select the CSV file that was exported.<br />
* For “Import ID” field, make a new Import ID, for example, you can use your initial + a number.<br />
* For Default Holdback Percentage, use 10%. <br />
* Click “Import” Button<br />
<br />
Viewpoint will be doing some work, if the project is big, in regards to amount of cost codes, it may take a minute or two. Once the file is imported, Viewpoint will prompt you a Message Box, sometimes it will say there are some errors. These errors are caused by non-standard cost code, or unit of measures that was used during estimating stage, or during consolidation stage.<br />
<br />
Click on the “Edit Work Tables” button, Viewpoint will open up a window, by default it will open the most recent import made by you. We will only be using the “Items”, “Phase”, “Cost Types” tabs.<br />
<br />
Some of the tab name is probably not familiar to you, translation:<br />
* Items – Contract Items, these are the items shows up on your billing. <br />
* Phases – Cost Codes, this tab allows you to adjust how the codes are linked with Contract Items. (you don’t have to change the links, the contract items and their amount are much easier to adjust in Job Cost – JC Contract Master module). <br />
* Cost Types – Cost Types of each cost code. This tab shows, for example the cost allocated in each cost type for each cost code.<br />
<br />
On the contract items tab, you can edit the contract Item descriptions here. I recommend to do it in JC – Contract Master module once the import is completed however.<br />
[[File:Budget Upload - Review Data Table.png|thumb|Review Data Table]]<br />
On the cost code tab, any error will be high lighted with red. Error on this tab typically is caused by the Cost Code does not existing in Master Cost Code list. Select the line with Error, double click the phase field to edit. Click F4 key on your keyboard to call out the cost code look up list, pick an appropriate code from the list. Once the code is picked, you can also add .xx.xx to it to make it more customized. For example, 12010.01. Click “Save” button, or Ctrl+S to save the change. Viewpoint will prompt you a dialog ask if it should create a phase cross reference record, '''make sure to select “NO”'''. If you accidentally clicked yes, let Siyuan know, the cross reference can be deleted from the template.<br />
<br />
Similar procedure for Cost Types tab. Viewpoint has a bug that even if you changed cost code on Phase tab, the Cost Types tab will still show the error (although the cost code is correct). To clear up the error, you will need to double click the cost code and type in the same code again. Similar procedure for Unit of Measure Error as well. Annoying I know, hopefully they fix that in the future. <br />
<br />
Once all errors are cleared up, you can click the “Upload into PM” button. Viewpoint will open a window for this. Defaulted to the most recent Data Table that you edited. In the Project field, put in the project number that this budget is going into. The Start Month – this is the effective month of your budget, not your project schedule start. For example, if you set the start month to 02/21, the budget you upload today will not shown in forecast till the February batch in 2021. Doesn’t matter if you interfaced to December 2020. The red text here is a warning, telling me there are existing cost code and cost ($0 count as well) in the project already. Uploading will have the budget accumulated. If this is the first time budget uploading to this project, it typically because some codes were opened up by accounting for insurance purposes.<br />
<br />
'''Always a good habit to check!!''' Locate in Job Cost – Programs, the JC Original Estimate module. Open it, you will see what's existing in your project, for both cost code, and budget. '''If you already have budget in the project, uploading will accumulate, instead of overwrite.'''<br />
<br />
Another Option is to upload the budget as COQ (Change Order). This is useful for project that budget get approved in phases. PCO type is always COQ. The PCO field, is correspond to Pending Change Order module, pick one that you intent to use. Make a good (consistent) name for your COQ. Starting PCO item field, correspond to the PCO item in Pending Change Order. Typically you want this to start with 1, unless you are adding to an existing PCO. Increment by: '''Typically you want set this to 1'''. I can’t think of anything that would make you to change this to anything else. Note that the each Contract Item will be a new PCO item, when you are adding the budget as a change order.<br />
[[File:Budget Upload - Upload to PM.png|thumb|Import Estimate – Upload to PM]]<br />
Then hit the Upload button. Once the budget uploaded, it will prompt you that the budget is uploaded, and if you want to delete the data table. You can go ahead and delete it. If the data table have errors that’s not cleared up. You will not be able to upload the budget, instead, Viewpoint will prompt you a message box and tell you this. Since I have already uploaded my budget, I will not try to upload again. Just pretend the picture on the left is what you see once clicked the upload button.<br />
<br />
Locate the “Interface” module in Project Management – Program Folder. Double Click to open this program. Hit Validate, then Interface.<br />
[[File:Budget Upload - Add Bond Insurance Fee.png|thumb|Add Bond Insurance Fee]]<br />
Now go back to the Job Cost – Program, open module JC Original Estimate program. Remember that the items entered on the Summary sheet in Estimate Template will not be pulled? This is where we enter those a few items. Bond, Insurance, Fee. <br />
<br />
'''Once all these item added, your project total should matches up the contract amount.'''<br />
<br />
==== Import Estimate – Billing Schedule ====<br />
Locate in Job Cost – Program folder, JC Contract Master module. Double click to open.<br />
[[File:Budget Upload - Billing Schedule.png|thumb|Editing Billing Schedule]]<br />
# Go to your project, then select “Items” tab.<br />
# Adjust the description, add/delete the lines as needed.<br />
# Adjust the $ value in the Orig Amount. <br />
# The total amount should match the contract value.<br />
# Essentially this is the billing structure that accounting will get you to complete every month.<br />
Do:<br />
* Review tender documents and see if certain billing structure is required.<br />
* Check with CM or OM see if there are certain billing structure should be used<br />
* Check with Client and see if they want any particular item broken out<br />
* Double check the total mount of Billing, matches total amount of Estimate, Matches total amount of Contract Value.</div>ASamoilhttps://thewiki.builtplainly.com/index.php?title=Budget_Upload&diff=993Budget Upload2022-06-10T14:52:41Z<p>ASamoil: /* CSV Export */</p>
<hr />
<div>== Introduction ==<br />
=== Objective: ===<br />
Establish a basic understanding and procedure for uploading budget from Estimate Template to Viewpoint.<br />
=== Agenda ===<br />
* Process diagram<br />
* Step by Step Tutorial<br />
* Buyout and adjust detail estimate<br />
* Consolidate detail estimate, fine tune code, units, descriptions<br />
* Export CSV file<br />
* Import CSV file to Viewpoint<br />
* Set up Billing<br />
== Tutorial ==<br />
=== What happens after a win? ===<br />
From operation standpoint we focus on the Estimate Review<br />
* Cost Code Clean Up<br />
* Consolidate Units<br />
* Review Cost and Bid<br />
* Buyout scopes<br />
* Identify contingency vs cash allowance<br />
* Any special agreement or alignment of trades<br />
* Etc.<br />
<br />
<sequencediagram style="modern-blue"><br />
Customer->Estimator: Award Project\nto Synergy<br />
Note over Estimator, Estimate\nTemplate : Reconcile Bids\nOrganize Bid Binder<br />
Estimator->Operation Team: Control Estimate (the Book)<br />
Estimator->Operation Team: Bid Binder<br />
Note over Estimator, Operation Team: Review Bid Strategy, Bids, Schedule\n(Turn Over Meeting)<br />
Note over Estimate\nTemplate, Operation Team:Review Estimate\nClean up Cost Code\nConsolidate Units\nReview Cost<br />
Estimate\nTemplate->Operation Team:Budget .CSV file<br />
Operation Team-> Viewpoint: Upload Budget <br />
</sequencediagram><br />
<br />
Then,<br />
# The entire estimate data after cleanup get poured into Viewpoint using a '''[https://en.wikipedia.org/wiki/Comma-separated_values .CSV file]'''.<br />
# The CSV file is structured specifically in a format Viewpoint can read using Import Estimate Module.<br />
=== Step-by-Step ===<br />
==== Within Estimate Work Book, you will need to do the following ====<br />
===== Step 1: Locate the "Tab" =====<br />
[[File:Budget Upload - Worksheets.png|frame|center|sample estimate workbook]]<br />
# Open the Estimate File received from Estimate Turn Over Meeting<br />
# Locate “Summary” and Division pages, drag and position those sheets to the front of all other sheets.<br />
# Locate “Est To VP” Tab, there are 6 buttons on this tab, each have their own corresponded functions. We will go through them in later pages.<br />
<br />
===== Step 2: Buy Out, Estimate Adjustment =====<br />
# Do your contract buy out.<br />
# During the buy out, modify the estimate file to match the scope that was bought into the trade’s scope.<br />
[[File:Budget Upload - Sample Buyout.png|thumb|sample buyout process]]<br />
# For the example that was shown here, the access panel and a few other scopes were estimated with own forces. During buy out, the drywaller agreed to take on those scopes for an additional cost. The number has been adjusted and moved to Subcontract Cost accordingly.<br />
# During buy out, if agreement were made for trades to take on certain additional scope for no or any cost, modify the estimate file to match the agreements.<br />
# Repeat this for all scopes pertains to the project.<br />
# In case any offsets from original contract value, we can add those after all the buy out to contingency, or book fee – pending on each project case.<br />
<br />
===== Step 3: Pull All Estimate Data To One Page =====<br />
# Locate the button called “Consolidate”. Click on it, will open a dialog allow you to select which page to include on pulling the Estimate Data Over.<br />
[[File:Budget Upload - Consolidation Button.png|thumb|consolidation button]]<br />
# In most cases, all pages from 1 to 16 will be selected.<br />
# However, if only a portion of the budget is getting uploaded, such as a change order, select only the page you want to upload.<br />
<br />
In the "Consolidation" worksheet, we can fine tune the cost codes, units, descriptions.<br />
An example is shown here. This page allows you to [[File:Budget Update - Consolidation.PNG|thumb|sample consolidation page]]<br />
* view which lines share the same cost code<br />
* Group or ungroup the cost lines by cost code<br />
* Adjusting unit of measure, quantities as needed.<br />
* This page does not allow modification to costs per se.<br />
'''Do''' <br />
* A quick check on each Division line and make sure the cost matches.<br />
* Remind yourself that any additional cost located on the summary page will not shown here – such as Insurance and Fee.<br />
'''Don’t'''<br />
* Try to change the format<br />
* Try to change the cost<br />
You can modify the description, unit of measure, quantity of the first line of the duplicated code so that the description make sense in your future forecast. In the example that’s shown, I have changed the description from “Orientation and Labour” to “Safety Equipment, Orientation and Labour” as this code contains both costlines. <br />
[[File:Budget Upload - Consolidation Description Change.png|frame|center]]<br />
The upload result of this example will be<br />
* Quantity of 20 with units of weeks<br />
* 140 hours of labour, $2,720+$5,600 for labour cost<br />
* $7,800 for material cost.<br />
* Repeat this for all cost lines.<br />
You can also combine or separate cost code for costlines. in this example, I have separated the cost code for flooring protection from the flooring subtrade. Doing so allows me to forecast easier during project execution phase. Do this as needed for all cost lines.<br />
<br />
Once you have gone thru all the cost lines, review with CM or OM if required. If you are comfortable with the consolidation and the PM has completed the above checks, you can begin to export to Viewpoint phase<br />
* Locate the “CSV Export” button, a dialog will show to let you save the CSV file generated for this estimate.<br />
* Modify the file name as needed, click “Save”.<br />
* It is recommended saving this file to the project folder, under “4 – Estimating”<br />
<br />
=== Est 2.0 CSV Creation method ===<br />
==== [[Consolidate]] ====<br />
<br />
==== [[CSV Export]] ====<br />
<br />
<br />
<br />
==== Import Estimate ====<br />
===== Do this using Viewpoint Import Estimate Program. =====<br />
Log into Viewpoint, Locate Module “PM Import Estimate” in Project Management – Program folder. Double Click to open the module.<br />
[[File:Budget Upload - Viewpoint Import Estimate Location.png|thumb|Locate Import Estimate Module]]<br />
<br />
This module contains a few different buttons.<br />
* Template Master lists all template that can be used to read the CSV file. We will not be touching this button.<br />
* Import Data lets you import the CSB file that was exported<br />
* Edit Work Tables lets you edit any imported budget table.<br />
* Upload into PM lets you pour the data into PM module, either as Original Estimate or as a Change Order to Existing Estimate.<br />
<br />
Click the Import Data, a window will pop open as the example shows.<br />
[[File:Budget Upload - Import Estimate Button.png|thumb|Import Estimate Button]]<br />
* For template, use SYN, this is the template made for Synergy to read a specific CSV format.<br />
* For “Import File 1:” field, click “Browse” button to the right, and select the CSV file that was exported.<br />
* For “Import ID” field, make a new Import ID, for example, you can use your initial + a number.<br />
* For Default Holdback Percentage, use 10%. <br />
* Click “Import” Button<br />
<br />
Viewpoint will be doing some work, if the project is big, in regards to amount of cost codes, it may take a minute or two. Once the file is imported, Viewpoint will prompt you a Message Box, sometimes it will say there are some errors. These errors are caused by non-standard cost code, or unit of measures that was used during estimating stage, or during consolidation stage.<br />
<br />
Click on the “Edit Work Tables” button, Viewpoint will open up a window, by default it will open the most recent import made by you. We will only be using the “Items”, “Phase”, “Cost Types” tabs.<br />
<br />
Some of the tab name is probably not familiar to you, translation:<br />
* Items – Contract Items, these are the items shows up on your billing. <br />
* Phases – Cost Codes, this tab allows you to adjust how the codes are linked with Contract Items. (you don’t have to change the links, the contract items and their amount are much easier to adjust in Job Cost – JC Contract Master module). <br />
* Cost Types – Cost Types of each cost code. This tab shows, for example the cost allocated in each cost type for each cost code.<br />
<br />
On the contract items tab, you can edit the contract Item descriptions here. I recommend to do it in JC – Contract Master module once the import is completed however.<br />
[[File:Budget Upload - Review Data Table.png|thumb|Review Data Table]]<br />
On the cost code tab, any error will be high lighted with red. Error on this tab typically is caused by the Cost Code does not existing in Master Cost Code list. Select the line with Error, double click the phase field to edit. Click F4 key on your keyboard to call out the cost code look up list, pick an appropriate code from the list. Once the code is picked, you can also add .xx.xx to it to make it more customized. For example, 12010.01. Click “Save” button, or Ctrl+S to save the change. Viewpoint will prompt you a dialog ask if it should create a phase cross reference record, '''make sure to select “NO”'''. If you accidentally clicked yes, let Siyuan know, the cross reference can be deleted from the template.<br />
<br />
Similar procedure for Cost Types tab. Viewpoint has a bug that even if you changed cost code on Phase tab, the Cost Types tab will still show the error (although the cost code is correct). To clear up the error, you will need to double click the cost code and type in the same code again. Similar procedure for Unit of Measure Error as well. Annoying I know, hopefully they fix that in the future. <br />
<br />
Once all errors are cleared up, you can click the “Upload into PM” button. Viewpoint will open a window for this. Defaulted to the most recent Data Table that you edited. In the Project field, put in the project number that this budget is going into. The Start Month – this is the effective month of your budget, not your project schedule start. For example, if you set the start month to 02/21, the budget you upload today will not shown in forecast till the February batch in 2021. Doesn’t matter if you interfaced to December 2020. The red text here is a warning, telling me there are existing cost code and cost ($0 count as well) in the project already. Uploading will have the budget accumulated. If this is the first time budget uploading to this project, it typically because some codes were opened up by accounting for insurance purposes.<br />
<br />
'''Always a good habit to check!!''' Locate in Job Cost – Programs, the JC Original Estimate module. Open it, you will see what's existing in your project, for both cost code, and budget. '''If you already have budget in the project, uploading will accumulate, instead of overwrite.'''<br />
<br />
Another Option is to upload the budget as COQ (Change Order). This is useful for project that budget get approved in phases. PCO type is always COQ. The PCO field, is correspond to Pending Change Order module, pick one that you intent to use. Make a good (consistent) name for your COQ. Starting PCO item field, correspond to the PCO item in Pending Change Order. Typically you want this to start with 1, unless you are adding to an existing PCO. Increment by: '''Typically you want set this to 1'''. I can’t think of anything that would make you to change this to anything else. Note that the each Contract Item will be a new PCO item, when you are adding the budget as a change order.<br />
[[File:Budget Upload - Upload to PM.png|thumb|Import Estimate – Upload to PM]]<br />
Then hit the Upload button. Once the budget uploaded, it will prompt you that the budget is uploaded, and if you want to delete the data table. You can go ahead and delete it. If the data table have errors that’s not cleared up. You will not be able to upload the budget, instead, Viewpoint will prompt you a message box and tell you this. Since I have already uploaded my budget, I will not try to upload again. Just pretend the picture on the left is what you see once clicked the upload button.<br />
<br />
Locate the “Interface” module in Project Management – Program Folder. Double Click to open this program. Hit Validate, then Interface.<br />
[[File:Budget Upload - Add Bond Insurance Fee.png|thumb|Add Bond Insurance Fee]]<br />
Now go back to the Job Cost – Program, open module JC Original Estimate program. Remember that the items entered on the Summary sheet in Estimate Template will not be pulled? This is where we enter those a few items. Bond, Insurance, Fee. <br />
<br />
'''Once all these item added, your project total should matches up the contract amount.'''<br />
<br />
==== Import Estimate – Billing Schedule ====<br />
Locate in Job Cost – Program folder, JC Contract Master module. Double click to open.<br />
[[File:Budget Upload - Billing Schedule.png|thumb|Editing Billing Schedule]]<br />
# Go to your project, then select “Items” tab.<br />
# Adjust the description, add/delete the lines as needed.<br />
# Adjust the $ value in the Orig Amount. <br />
# The total amount should match the contract value.<br />
# Essentially this is the billing structure that accounting will get you to complete every month.<br />
Do:<br />
* Review tender documents and see if certain billing structure is required.<br />
* Check with CM or OM see if there are certain billing structure should be used<br />
* Check with Client and see if they want any particular item broken out<br />
* Double check the total mount of Billing, matches total amount of Estimate, Matches total amount of Contract Value.</div>ASamoilhttps://thewiki.builtplainly.com/index.php?title=Budget_Upload&diff=992Budget Upload2022-06-10T14:52:30Z<p>ASamoil: /* Consolidate */</p>
<hr />
<div>== Introduction ==<br />
=== Objective: ===<br />
Establish a basic understanding and procedure for uploading budget from Estimate Template to Viewpoint.<br />
=== Agenda ===<br />
* Process diagram<br />
* Step by Step Tutorial<br />
* Buyout and adjust detail estimate<br />
* Consolidate detail estimate, fine tune code, units, descriptions<br />
* Export CSV file<br />
* Import CSV file to Viewpoint<br />
* Set up Billing<br />
== Tutorial ==<br />
=== What happens after a win? ===<br />
From operation standpoint we focus on the Estimate Review<br />
* Cost Code Clean Up<br />
* Consolidate Units<br />
* Review Cost and Bid<br />
* Buyout scopes<br />
* Identify contingency vs cash allowance<br />
* Any special agreement or alignment of trades<br />
* Etc.<br />
<br />
<sequencediagram style="modern-blue"><br />
Customer->Estimator: Award Project\nto Synergy<br />
Note over Estimator, Estimate\nTemplate : Reconcile Bids\nOrganize Bid Binder<br />
Estimator->Operation Team: Control Estimate (the Book)<br />
Estimator->Operation Team: Bid Binder<br />
Note over Estimator, Operation Team: Review Bid Strategy, Bids, Schedule\n(Turn Over Meeting)<br />
Note over Estimate\nTemplate, Operation Team:Review Estimate\nClean up Cost Code\nConsolidate Units\nReview Cost<br />
Estimate\nTemplate->Operation Team:Budget .CSV file<br />
Operation Team-> Viewpoint: Upload Budget <br />
</sequencediagram><br />
<br />
Then,<br />
# The entire estimate data after cleanup get poured into Viewpoint using a '''[https://en.wikipedia.org/wiki/Comma-separated_values .CSV file]'''.<br />
# The CSV file is structured specifically in a format Viewpoint can read using Import Estimate Module.<br />
=== Step-by-Step ===<br />
==== Within Estimate Work Book, you will need to do the following ====<br />
===== Step 1: Locate the "Tab" =====<br />
[[File:Budget Upload - Worksheets.png|frame|center|sample estimate workbook]]<br />
# Open the Estimate File received from Estimate Turn Over Meeting<br />
# Locate “Summary” and Division pages, drag and position those sheets to the front of all other sheets.<br />
# Locate “Est To VP” Tab, there are 6 buttons on this tab, each have their own corresponded functions. We will go through them in later pages.<br />
<br />
===== Step 2: Buy Out, Estimate Adjustment =====<br />
# Do your contract buy out.<br />
# During the buy out, modify the estimate file to match the scope that was bought into the trade’s scope.<br />
[[File:Budget Upload - Sample Buyout.png|thumb|sample buyout process]]<br />
# For the example that was shown here, the access panel and a few other scopes were estimated with own forces. During buy out, the drywaller agreed to take on those scopes for an additional cost. The number has been adjusted and moved to Subcontract Cost accordingly.<br />
# During buy out, if agreement were made for trades to take on certain additional scope for no or any cost, modify the estimate file to match the agreements.<br />
# Repeat this for all scopes pertains to the project.<br />
# In case any offsets from original contract value, we can add those after all the buy out to contingency, or book fee – pending on each project case.<br />
<br />
===== Step 3: Pull All Estimate Data To One Page =====<br />
# Locate the button called “Consolidate”. Click on it, will open a dialog allow you to select which page to include on pulling the Estimate Data Over.<br />
[[File:Budget Upload - Consolidation Button.png|thumb|consolidation button]]<br />
# In most cases, all pages from 1 to 16 will be selected.<br />
# However, if only a portion of the budget is getting uploaded, such as a change order, select only the page you want to upload.<br />
<br />
In the "Consolidation" worksheet, we can fine tune the cost codes, units, descriptions.<br />
An example is shown here. This page allows you to [[File:Budget Update - Consolidation.PNG|thumb|sample consolidation page]]<br />
* view which lines share the same cost code<br />
* Group or ungroup the cost lines by cost code<br />
* Adjusting unit of measure, quantities as needed.<br />
* This page does not allow modification to costs per se.<br />
'''Do''' <br />
* A quick check on each Division line and make sure the cost matches.<br />
* Remind yourself that any additional cost located on the summary page will not shown here – such as Insurance and Fee.<br />
'''Don’t'''<br />
* Try to change the format<br />
* Try to change the cost<br />
You can modify the description, unit of measure, quantity of the first line of the duplicated code so that the description make sense in your future forecast. In the example that’s shown, I have changed the description from “Orientation and Labour” to “Safety Equipment, Orientation and Labour” as this code contains both costlines. <br />
[[File:Budget Upload - Consolidation Description Change.png|frame|center]]<br />
The upload result of this example will be<br />
* Quantity of 20 with units of weeks<br />
* 140 hours of labour, $2,720+$5,600 for labour cost<br />
* $7,800 for material cost.<br />
* Repeat this for all cost lines.<br />
You can also combine or separate cost code for costlines. in this example, I have separated the cost code for flooring protection from the flooring subtrade. Doing so allows me to forecast easier during project execution phase. Do this as needed for all cost lines.<br />
<br />
Once you have gone thru all the cost lines, review with CM or OM if required. If you are comfortable with the consolidation and the PM has completed the above checks, you can begin to export to Viewpoint phase<br />
* Locate the “CSV Export” button, a dialog will show to let you save the CSV file generated for this estimate.<br />
* Modify the file name as needed, click “Save”.<br />
* It is recommended saving this file to the project folder, under “4 – Estimating”<br />
<br />
=== Est 2.0 CSV Creation method ===<br />
==== [[Consolidate]] ====<br />
<br />
=== [[CSV Export]] ===<br />
<br />
<br />
<br />
==== Import Estimate ====<br />
===== Do this using Viewpoint Import Estimate Program. =====<br />
Log into Viewpoint, Locate Module “PM Import Estimate” in Project Management – Program folder. Double Click to open the module.<br />
[[File:Budget Upload - Viewpoint Import Estimate Location.png|thumb|Locate Import Estimate Module]]<br />
<br />
This module contains a few different buttons.<br />
* Template Master lists all template that can be used to read the CSV file. We will not be touching this button.<br />
* Import Data lets you import the CSB file that was exported<br />
* Edit Work Tables lets you edit any imported budget table.<br />
* Upload into PM lets you pour the data into PM module, either as Original Estimate or as a Change Order to Existing Estimate.<br />
<br />
Click the Import Data, a window will pop open as the example shows.<br />
[[File:Budget Upload - Import Estimate Button.png|thumb|Import Estimate Button]]<br />
* For template, use SYN, this is the template made for Synergy to read a specific CSV format.<br />
* For “Import File 1:” field, click “Browse” button to the right, and select the CSV file that was exported.<br />
* For “Import ID” field, make a new Import ID, for example, you can use your initial + a number.<br />
* For Default Holdback Percentage, use 10%. <br />
* Click “Import” Button<br />
<br />
Viewpoint will be doing some work, if the project is big, in regards to amount of cost codes, it may take a minute or two. Once the file is imported, Viewpoint will prompt you a Message Box, sometimes it will say there are some errors. These errors are caused by non-standard cost code, or unit of measures that was used during estimating stage, or during consolidation stage.<br />
<br />
Click on the “Edit Work Tables” button, Viewpoint will open up a window, by default it will open the most recent import made by you. We will only be using the “Items”, “Phase”, “Cost Types” tabs.<br />
<br />
Some of the tab name is probably not familiar to you, translation:<br />
* Items – Contract Items, these are the items shows up on your billing. <br />
* Phases – Cost Codes, this tab allows you to adjust how the codes are linked with Contract Items. (you don’t have to change the links, the contract items and their amount are much easier to adjust in Job Cost – JC Contract Master module). <br />
* Cost Types – Cost Types of each cost code. This tab shows, for example the cost allocated in each cost type for each cost code.<br />
<br />
On the contract items tab, you can edit the contract Item descriptions here. I recommend to do it in JC – Contract Master module once the import is completed however.<br />
[[File:Budget Upload - Review Data Table.png|thumb|Review Data Table]]<br />
On the cost code tab, any error will be high lighted with red. Error on this tab typically is caused by the Cost Code does not existing in Master Cost Code list. Select the line with Error, double click the phase field to edit. Click F4 key on your keyboard to call out the cost code look up list, pick an appropriate code from the list. Once the code is picked, you can also add .xx.xx to it to make it more customized. For example, 12010.01. Click “Save” button, or Ctrl+S to save the change. Viewpoint will prompt you a dialog ask if it should create a phase cross reference record, '''make sure to select “NO”'''. If you accidentally clicked yes, let Siyuan know, the cross reference can be deleted from the template.<br />
<br />
Similar procedure for Cost Types tab. Viewpoint has a bug that even if you changed cost code on Phase tab, the Cost Types tab will still show the error (although the cost code is correct). To clear up the error, you will need to double click the cost code and type in the same code again. Similar procedure for Unit of Measure Error as well. Annoying I know, hopefully they fix that in the future. <br />
<br />
Once all errors are cleared up, you can click the “Upload into PM” button. Viewpoint will open a window for this. Defaulted to the most recent Data Table that you edited. In the Project field, put in the project number that this budget is going into. The Start Month – this is the effective month of your budget, not your project schedule start. For example, if you set the start month to 02/21, the budget you upload today will not shown in forecast till the February batch in 2021. Doesn’t matter if you interfaced to December 2020. The red text here is a warning, telling me there are existing cost code and cost ($0 count as well) in the project already. Uploading will have the budget accumulated. If this is the first time budget uploading to this project, it typically because some codes were opened up by accounting for insurance purposes.<br />
<br />
'''Always a good habit to check!!''' Locate in Job Cost – Programs, the JC Original Estimate module. Open it, you will see what's existing in your project, for both cost code, and budget. '''If you already have budget in the project, uploading will accumulate, instead of overwrite.'''<br />
<br />
Another Option is to upload the budget as COQ (Change Order). This is useful for project that budget get approved in phases. PCO type is always COQ. The PCO field, is correspond to Pending Change Order module, pick one that you intent to use. Make a good (consistent) name for your COQ. Starting PCO item field, correspond to the PCO item in Pending Change Order. Typically you want this to start with 1, unless you are adding to an existing PCO. Increment by: '''Typically you want set this to 1'''. I can’t think of anything that would make you to change this to anything else. Note that the each Contract Item will be a new PCO item, when you are adding the budget as a change order.<br />
[[File:Budget Upload - Upload to PM.png|thumb|Import Estimate – Upload to PM]]<br />
Then hit the Upload button. Once the budget uploaded, it will prompt you that the budget is uploaded, and if you want to delete the data table. You can go ahead and delete it. If the data table have errors that’s not cleared up. You will not be able to upload the budget, instead, Viewpoint will prompt you a message box and tell you this. Since I have already uploaded my budget, I will not try to upload again. Just pretend the picture on the left is what you see once clicked the upload button.<br />
<br />
Locate the “Interface” module in Project Management – Program Folder. Double Click to open this program. Hit Validate, then Interface.<br />
[[File:Budget Upload - Add Bond Insurance Fee.png|thumb|Add Bond Insurance Fee]]<br />
Now go back to the Job Cost – Program, open module JC Original Estimate program. Remember that the items entered on the Summary sheet in Estimate Template will not be pulled? This is where we enter those a few items. Bond, Insurance, Fee. <br />
<br />
'''Once all these item added, your project total should matches up the contract amount.'''<br />
<br />
==== Import Estimate – Billing Schedule ====<br />
Locate in Job Cost – Program folder, JC Contract Master module. Double click to open.<br />
[[File:Budget Upload - Billing Schedule.png|thumb|Editing Billing Schedule]]<br />
# Go to your project, then select “Items” tab.<br />
# Adjust the description, add/delete the lines as needed.<br />
# Adjust the $ value in the Orig Amount. <br />
# The total amount should match the contract value.<br />
# Essentially this is the billing structure that accounting will get you to complete every month.<br />
Do:<br />
* Review tender documents and see if certain billing structure is required.<br />
* Check with CM or OM see if there are certain billing structure should be used<br />
* Check with Client and see if they want any particular item broken out<br />
* Double check the total mount of Billing, matches total amount of Estimate, Matches total amount of Contract Value.</div>ASamoilhttps://thewiki.builtplainly.com/index.php?title=Budget_Upload&diff=991Budget Upload2022-06-10T14:52:13Z<p>ASamoil: /* Est 2.0 CSV Creation method */</p>
<hr />
<div>== Introduction ==<br />
=== Objective: ===<br />
Establish a basic understanding and procedure for uploading budget from Estimate Template to Viewpoint.<br />
=== Agenda ===<br />
* Process diagram<br />
* Step by Step Tutorial<br />
* Buyout and adjust detail estimate<br />
* Consolidate detail estimate, fine tune code, units, descriptions<br />
* Export CSV file<br />
* Import CSV file to Viewpoint<br />
* Set up Billing<br />
== Tutorial ==<br />
=== What happens after a win? ===<br />
From operation standpoint we focus on the Estimate Review<br />
* Cost Code Clean Up<br />
* Consolidate Units<br />
* Review Cost and Bid<br />
* Buyout scopes<br />
* Identify contingency vs cash allowance<br />
* Any special agreement or alignment of trades<br />
* Etc.<br />
<br />
<sequencediagram style="modern-blue"><br />
Customer->Estimator: Award Project\nto Synergy<br />
Note over Estimator, Estimate\nTemplate : Reconcile Bids\nOrganize Bid Binder<br />
Estimator->Operation Team: Control Estimate (the Book)<br />
Estimator->Operation Team: Bid Binder<br />
Note over Estimator, Operation Team: Review Bid Strategy, Bids, Schedule\n(Turn Over Meeting)<br />
Note over Estimate\nTemplate, Operation Team:Review Estimate\nClean up Cost Code\nConsolidate Units\nReview Cost<br />
Estimate\nTemplate->Operation Team:Budget .CSV file<br />
Operation Team-> Viewpoint: Upload Budget <br />
</sequencediagram><br />
<br />
Then,<br />
# The entire estimate data after cleanup get poured into Viewpoint using a '''[https://en.wikipedia.org/wiki/Comma-separated_values .CSV file]'''.<br />
# The CSV file is structured specifically in a format Viewpoint can read using Import Estimate Module.<br />
=== Step-by-Step ===<br />
==== Within Estimate Work Book, you will need to do the following ====<br />
===== Step 1: Locate the "Tab" =====<br />
[[File:Budget Upload - Worksheets.png|frame|center|sample estimate workbook]]<br />
# Open the Estimate File received from Estimate Turn Over Meeting<br />
# Locate “Summary” and Division pages, drag and position those sheets to the front of all other sheets.<br />
# Locate “Est To VP” Tab, there are 6 buttons on this tab, each have their own corresponded functions. We will go through them in later pages.<br />
<br />
===== Step 2: Buy Out, Estimate Adjustment =====<br />
# Do your contract buy out.<br />
# During the buy out, modify the estimate file to match the scope that was bought into the trade’s scope.<br />
[[File:Budget Upload - Sample Buyout.png|thumb|sample buyout process]]<br />
# For the example that was shown here, the access panel and a few other scopes were estimated with own forces. During buy out, the drywaller agreed to take on those scopes for an additional cost. The number has been adjusted and moved to Subcontract Cost accordingly.<br />
# During buy out, if agreement were made for trades to take on certain additional scope for no or any cost, modify the estimate file to match the agreements.<br />
# Repeat this for all scopes pertains to the project.<br />
# In case any offsets from original contract value, we can add those after all the buy out to contingency, or book fee – pending on each project case.<br />
<br />
===== Step 3: Pull All Estimate Data To One Page =====<br />
# Locate the button called “Consolidate”. Click on it, will open a dialog allow you to select which page to include on pulling the Estimate Data Over.<br />
[[File:Budget Upload - Consolidation Button.png|thumb|consolidation button]]<br />
# In most cases, all pages from 1 to 16 will be selected.<br />
# However, if only a portion of the budget is getting uploaded, such as a change order, select only the page you want to upload.<br />
<br />
In the "Consolidation" worksheet, we can fine tune the cost codes, units, descriptions.<br />
An example is shown here. This page allows you to [[File:Budget Update - Consolidation.PNG|thumb|sample consolidation page]]<br />
* view which lines share the same cost code<br />
* Group or ungroup the cost lines by cost code<br />
* Adjusting unit of measure, quantities as needed.<br />
* This page does not allow modification to costs per se.<br />
'''Do''' <br />
* A quick check on each Division line and make sure the cost matches.<br />
* Remind yourself that any additional cost located on the summary page will not shown here – such as Insurance and Fee.<br />
'''Don’t'''<br />
* Try to change the format<br />
* Try to change the cost<br />
You can modify the description, unit of measure, quantity of the first line of the duplicated code so that the description make sense in your future forecast. In the example that’s shown, I have changed the description from “Orientation and Labour” to “Safety Equipment, Orientation and Labour” as this code contains both costlines. <br />
[[File:Budget Upload - Consolidation Description Change.png|frame|center]]<br />
The upload result of this example will be<br />
* Quantity of 20 with units of weeks<br />
* 140 hours of labour, $2,720+$5,600 for labour cost<br />
* $7,800 for material cost.<br />
* Repeat this for all cost lines.<br />
You can also combine or separate cost code for costlines. in this example, I have separated the cost code for flooring protection from the flooring subtrade. Doing so allows me to forecast easier during project execution phase. Do this as needed for all cost lines.<br />
<br />
Once you have gone thru all the cost lines, review with CM or OM if required. If you are comfortable with the consolidation and the PM has completed the above checks, you can begin to export to Viewpoint phase<br />
* Locate the “CSV Export” button, a dialog will show to let you save the CSV file generated for this estimate.<br />
* Modify the file name as needed, click “Save”.<br />
* It is recommended saving this file to the project folder, under “4 – Estimating”<br />
<br />
=== Est 2.0 CSV Creation method ===<br />
=== [[Consolidate]] ===<br />
=== [[CSV Export]] ===<br />
<br />
<br />
<br />
==== Import Estimate ====<br />
===== Do this using Viewpoint Import Estimate Program. =====<br />
Log into Viewpoint, Locate Module “PM Import Estimate” in Project Management – Program folder. Double Click to open the module.<br />
[[File:Budget Upload - Viewpoint Import Estimate Location.png|thumb|Locate Import Estimate Module]]<br />
<br />
This module contains a few different buttons.<br />
* Template Master lists all template that can be used to read the CSV file. We will not be touching this button.<br />
* Import Data lets you import the CSB file that was exported<br />
* Edit Work Tables lets you edit any imported budget table.<br />
* Upload into PM lets you pour the data into PM module, either as Original Estimate or as a Change Order to Existing Estimate.<br />
<br />
Click the Import Data, a window will pop open as the example shows.<br />
[[File:Budget Upload - Import Estimate Button.png|thumb|Import Estimate Button]]<br />
* For template, use SYN, this is the template made for Synergy to read a specific CSV format.<br />
* For “Import File 1:” field, click “Browse” button to the right, and select the CSV file that was exported.<br />
* For “Import ID” field, make a new Import ID, for example, you can use your initial + a number.<br />
* For Default Holdback Percentage, use 10%. <br />
* Click “Import” Button<br />
<br />
Viewpoint will be doing some work, if the project is big, in regards to amount of cost codes, it may take a minute or two. Once the file is imported, Viewpoint will prompt you a Message Box, sometimes it will say there are some errors. These errors are caused by non-standard cost code, or unit of measures that was used during estimating stage, or during consolidation stage.<br />
<br />
Click on the “Edit Work Tables” button, Viewpoint will open up a window, by default it will open the most recent import made by you. We will only be using the “Items”, “Phase”, “Cost Types” tabs.<br />
<br />
Some of the tab name is probably not familiar to you, translation:<br />
* Items – Contract Items, these are the items shows up on your billing. <br />
* Phases – Cost Codes, this tab allows you to adjust how the codes are linked with Contract Items. (you don’t have to change the links, the contract items and their amount are much easier to adjust in Job Cost – JC Contract Master module). <br />
* Cost Types – Cost Types of each cost code. This tab shows, for example the cost allocated in each cost type for each cost code.<br />
<br />
On the contract items tab, you can edit the contract Item descriptions here. I recommend to do it in JC – Contract Master module once the import is completed however.<br />
[[File:Budget Upload - Review Data Table.png|thumb|Review Data Table]]<br />
On the cost code tab, any error will be high lighted with red. Error on this tab typically is caused by the Cost Code does not existing in Master Cost Code list. Select the line with Error, double click the phase field to edit. Click F4 key on your keyboard to call out the cost code look up list, pick an appropriate code from the list. Once the code is picked, you can also add .xx.xx to it to make it more customized. For example, 12010.01. Click “Save” button, or Ctrl+S to save the change. Viewpoint will prompt you a dialog ask if it should create a phase cross reference record, '''make sure to select “NO”'''. If you accidentally clicked yes, let Siyuan know, the cross reference can be deleted from the template.<br />
<br />
Similar procedure for Cost Types tab. Viewpoint has a bug that even if you changed cost code on Phase tab, the Cost Types tab will still show the error (although the cost code is correct). To clear up the error, you will need to double click the cost code and type in the same code again. Similar procedure for Unit of Measure Error as well. Annoying I know, hopefully they fix that in the future. <br />
<br />
Once all errors are cleared up, you can click the “Upload into PM” button. Viewpoint will open a window for this. Defaulted to the most recent Data Table that you edited. In the Project field, put in the project number that this budget is going into. The Start Month – this is the effective month of your budget, not your project schedule start. For example, if you set the start month to 02/21, the budget you upload today will not shown in forecast till the February batch in 2021. Doesn’t matter if you interfaced to December 2020. The red text here is a warning, telling me there are existing cost code and cost ($0 count as well) in the project already. Uploading will have the budget accumulated. If this is the first time budget uploading to this project, it typically because some codes were opened up by accounting for insurance purposes.<br />
<br />
'''Always a good habit to check!!''' Locate in Job Cost – Programs, the JC Original Estimate module. Open it, you will see what's existing in your project, for both cost code, and budget. '''If you already have budget in the project, uploading will accumulate, instead of overwrite.'''<br />
<br />
Another Option is to upload the budget as COQ (Change Order). This is useful for project that budget get approved in phases. PCO type is always COQ. The PCO field, is correspond to Pending Change Order module, pick one that you intent to use. Make a good (consistent) name for your COQ. Starting PCO item field, correspond to the PCO item in Pending Change Order. Typically you want this to start with 1, unless you are adding to an existing PCO. Increment by: '''Typically you want set this to 1'''. I can’t think of anything that would make you to change this to anything else. Note that the each Contract Item will be a new PCO item, when you are adding the budget as a change order.<br />
[[File:Budget Upload - Upload to PM.png|thumb|Import Estimate – Upload to PM]]<br />
Then hit the Upload button. Once the budget uploaded, it will prompt you that the budget is uploaded, and if you want to delete the data table. You can go ahead and delete it. If the data table have errors that’s not cleared up. You will not be able to upload the budget, instead, Viewpoint will prompt you a message box and tell you this. Since I have already uploaded my budget, I will not try to upload again. Just pretend the picture on the left is what you see once clicked the upload button.<br />
<br />
Locate the “Interface” module in Project Management – Program Folder. Double Click to open this program. Hit Validate, then Interface.<br />
[[File:Budget Upload - Add Bond Insurance Fee.png|thumb|Add Bond Insurance Fee]]<br />
Now go back to the Job Cost – Program, open module JC Original Estimate program. Remember that the items entered on the Summary sheet in Estimate Template will not be pulled? This is where we enter those a few items. Bond, Insurance, Fee. <br />
<br />
'''Once all these item added, your project total should matches up the contract amount.'''<br />
<br />
==== Import Estimate – Billing Schedule ====<br />
Locate in Job Cost – Program folder, JC Contract Master module. Double click to open.<br />
[[File:Budget Upload - Billing Schedule.png|thumb|Editing Billing Schedule]]<br />
# Go to your project, then select “Items” tab.<br />
# Adjust the description, add/delete the lines as needed.<br />
# Adjust the $ value in the Orig Amount. <br />
# The total amount should match the contract value.<br />
# Essentially this is the billing structure that accounting will get you to complete every month.<br />
Do:<br />
* Review tender documents and see if certain billing structure is required.<br />
* Check with CM or OM see if there are certain billing structure should be used<br />
* Check with Client and see if they want any particular item broken out<br />
* Double check the total mount of Billing, matches total amount of Estimate, Matches total amount of Contract Value.</div>ASamoilhttps://thewiki.builtplainly.com/index.php?title=Budget_Upload&diff=990Budget Upload2022-06-10T14:51:59Z<p>ASamoil: /* Est 2.0 CSV Creation method */</p>
<hr />
<div>== Introduction ==<br />
=== Objective: ===<br />
Establish a basic understanding and procedure for uploading budget from Estimate Template to Viewpoint.<br />
=== Agenda ===<br />
* Process diagram<br />
* Step by Step Tutorial<br />
* Buyout and adjust detail estimate<br />
* Consolidate detail estimate, fine tune code, units, descriptions<br />
* Export CSV file<br />
* Import CSV file to Viewpoint<br />
* Set up Billing<br />
== Tutorial ==<br />
=== What happens after a win? ===<br />
From operation standpoint we focus on the Estimate Review<br />
* Cost Code Clean Up<br />
* Consolidate Units<br />
* Review Cost and Bid<br />
* Buyout scopes<br />
* Identify contingency vs cash allowance<br />
* Any special agreement or alignment of trades<br />
* Etc.<br />
<br />
<sequencediagram style="modern-blue"><br />
Customer->Estimator: Award Project\nto Synergy<br />
Note over Estimator, Estimate\nTemplate : Reconcile Bids\nOrganize Bid Binder<br />
Estimator->Operation Team: Control Estimate (the Book)<br />
Estimator->Operation Team: Bid Binder<br />
Note over Estimator, Operation Team: Review Bid Strategy, Bids, Schedule\n(Turn Over Meeting)<br />
Note over Estimate\nTemplate, Operation Team:Review Estimate\nClean up Cost Code\nConsolidate Units\nReview Cost<br />
Estimate\nTemplate->Operation Team:Budget .CSV file<br />
Operation Team-> Viewpoint: Upload Budget <br />
</sequencediagram><br />
<br />
Then,<br />
# The entire estimate data after cleanup get poured into Viewpoint using a '''[https://en.wikipedia.org/wiki/Comma-separated_values .CSV file]'''.<br />
# The CSV file is structured specifically in a format Viewpoint can read using Import Estimate Module.<br />
=== Step-by-Step ===<br />
==== Within Estimate Work Book, you will need to do the following ====<br />
===== Step 1: Locate the "Tab" =====<br />
[[File:Budget Upload - Worksheets.png|frame|center|sample estimate workbook]]<br />
# Open the Estimate File received from Estimate Turn Over Meeting<br />
# Locate “Summary” and Division pages, drag and position those sheets to the front of all other sheets.<br />
# Locate “Est To VP” Tab, there are 6 buttons on this tab, each have their own corresponded functions. We will go through them in later pages.<br />
<br />
===== Step 2: Buy Out, Estimate Adjustment =====<br />
# Do your contract buy out.<br />
# During the buy out, modify the estimate file to match the scope that was bought into the trade’s scope.<br />
[[File:Budget Upload - Sample Buyout.png|thumb|sample buyout process]]<br />
# For the example that was shown here, the access panel and a few other scopes were estimated with own forces. During buy out, the drywaller agreed to take on those scopes for an additional cost. The number has been adjusted and moved to Subcontract Cost accordingly.<br />
# During buy out, if agreement were made for trades to take on certain additional scope for no or any cost, modify the estimate file to match the agreements.<br />
# Repeat this for all scopes pertains to the project.<br />
# In case any offsets from original contract value, we can add those after all the buy out to contingency, or book fee – pending on each project case.<br />
<br />
===== Step 3: Pull All Estimate Data To One Page =====<br />
# Locate the button called “Consolidate”. Click on it, will open a dialog allow you to select which page to include on pulling the Estimate Data Over.<br />
[[File:Budget Upload - Consolidation Button.png|thumb|consolidation button]]<br />
# In most cases, all pages from 1 to 16 will be selected.<br />
# However, if only a portion of the budget is getting uploaded, such as a change order, select only the page you want to upload.<br />
<br />
In the "Consolidation" worksheet, we can fine tune the cost codes, units, descriptions.<br />
An example is shown here. This page allows you to [[File:Budget Update - Consolidation.PNG|thumb|sample consolidation page]]<br />
* view which lines share the same cost code<br />
* Group or ungroup the cost lines by cost code<br />
* Adjusting unit of measure, quantities as needed.<br />
* This page does not allow modification to costs per se.<br />
'''Do''' <br />
* A quick check on each Division line and make sure the cost matches.<br />
* Remind yourself that any additional cost located on the summary page will not shown here – such as Insurance and Fee.<br />
'''Don’t'''<br />
* Try to change the format<br />
* Try to change the cost<br />
You can modify the description, unit of measure, quantity of the first line of the duplicated code so that the description make sense in your future forecast. In the example that’s shown, I have changed the description from “Orientation and Labour” to “Safety Equipment, Orientation and Labour” as this code contains both costlines. <br />
[[File:Budget Upload - Consolidation Description Change.png|frame|center]]<br />
The upload result of this example will be<br />
* Quantity of 20 with units of weeks<br />
* 140 hours of labour, $2,720+$5,600 for labour cost<br />
* $7,800 for material cost.<br />
* Repeat this for all cost lines.<br />
You can also combine or separate cost code for costlines. in this example, I have separated the cost code for flooring protection from the flooring subtrade. Doing so allows me to forecast easier during project execution phase. Do this as needed for all cost lines.<br />
<br />
Once you have gone thru all the cost lines, review with CM or OM if required. If you are comfortable with the consolidation and the PM has completed the above checks, you can begin to export to Viewpoint phase<br />
* Locate the “CSV Export” button, a dialog will show to let you save the CSV file generated for this estimate.<br />
* Modify the file name as needed, click “Save”.<br />
* It is recommended saving this file to the project folder, under “4 – Estimating”<br />
<br />
=== Est 2.0 CSV Creation method ===<br />
1. === [[Consolidate]] ===<br />
2. === [[CSV Export]] ===<br />
<br />
<br />
<br />
==== Import Estimate ====<br />
===== Do this using Viewpoint Import Estimate Program. =====<br />
Log into Viewpoint, Locate Module “PM Import Estimate” in Project Management – Program folder. Double Click to open the module.<br />
[[File:Budget Upload - Viewpoint Import Estimate Location.png|thumb|Locate Import Estimate Module]]<br />
<br />
This module contains a few different buttons.<br />
* Template Master lists all template that can be used to read the CSV file. We will not be touching this button.<br />
* Import Data lets you import the CSB file that was exported<br />
* Edit Work Tables lets you edit any imported budget table.<br />
* Upload into PM lets you pour the data into PM module, either as Original Estimate or as a Change Order to Existing Estimate.<br />
<br />
Click the Import Data, a window will pop open as the example shows.<br />
[[File:Budget Upload - Import Estimate Button.png|thumb|Import Estimate Button]]<br />
* For template, use SYN, this is the template made for Synergy to read a specific CSV format.<br />
* For “Import File 1:” field, click “Browse” button to the right, and select the CSV file that was exported.<br />
* For “Import ID” field, make a new Import ID, for example, you can use your initial + a number.<br />
* For Default Holdback Percentage, use 10%. <br />
* Click “Import” Button<br />
<br />
Viewpoint will be doing some work, if the project is big, in regards to amount of cost codes, it may take a minute or two. Once the file is imported, Viewpoint will prompt you a Message Box, sometimes it will say there are some errors. These errors are caused by non-standard cost code, or unit of measures that was used during estimating stage, or during consolidation stage.<br />
<br />
Click on the “Edit Work Tables” button, Viewpoint will open up a window, by default it will open the most recent import made by you. We will only be using the “Items”, “Phase”, “Cost Types” tabs.<br />
<br />
Some of the tab name is probably not familiar to you, translation:<br />
* Items – Contract Items, these are the items shows up on your billing. <br />
* Phases – Cost Codes, this tab allows you to adjust how the codes are linked with Contract Items. (you don’t have to change the links, the contract items and their amount are much easier to adjust in Job Cost – JC Contract Master module). <br />
* Cost Types – Cost Types of each cost code. This tab shows, for example the cost allocated in each cost type for each cost code.<br />
<br />
On the contract items tab, you can edit the contract Item descriptions here. I recommend to do it in JC – Contract Master module once the import is completed however.<br />
[[File:Budget Upload - Review Data Table.png|thumb|Review Data Table]]<br />
On the cost code tab, any error will be high lighted with red. Error on this tab typically is caused by the Cost Code does not existing in Master Cost Code list. Select the line with Error, double click the phase field to edit. Click F4 key on your keyboard to call out the cost code look up list, pick an appropriate code from the list. Once the code is picked, you can also add .xx.xx to it to make it more customized. For example, 12010.01. Click “Save” button, or Ctrl+S to save the change. Viewpoint will prompt you a dialog ask if it should create a phase cross reference record, '''make sure to select “NO”'''. If you accidentally clicked yes, let Siyuan know, the cross reference can be deleted from the template.<br />
<br />
Similar procedure for Cost Types tab. Viewpoint has a bug that even if you changed cost code on Phase tab, the Cost Types tab will still show the error (although the cost code is correct). To clear up the error, you will need to double click the cost code and type in the same code again. Similar procedure for Unit of Measure Error as well. Annoying I know, hopefully they fix that in the future. <br />
<br />
Once all errors are cleared up, you can click the “Upload into PM” button. Viewpoint will open a window for this. Defaulted to the most recent Data Table that you edited. In the Project field, put in the project number that this budget is going into. The Start Month – this is the effective month of your budget, not your project schedule start. For example, if you set the start month to 02/21, the budget you upload today will not shown in forecast till the February batch in 2021. Doesn’t matter if you interfaced to December 2020. The red text here is a warning, telling me there are existing cost code and cost ($0 count as well) in the project already. Uploading will have the budget accumulated. If this is the first time budget uploading to this project, it typically because some codes were opened up by accounting for insurance purposes.<br />
<br />
'''Always a good habit to check!!''' Locate in Job Cost – Programs, the JC Original Estimate module. Open it, you will see what's existing in your project, for both cost code, and budget. '''If you already have budget in the project, uploading will accumulate, instead of overwrite.'''<br />
<br />
Another Option is to upload the budget as COQ (Change Order). This is useful for project that budget get approved in phases. PCO type is always COQ. The PCO field, is correspond to Pending Change Order module, pick one that you intent to use. Make a good (consistent) name for your COQ. Starting PCO item field, correspond to the PCO item in Pending Change Order. Typically you want this to start with 1, unless you are adding to an existing PCO. Increment by: '''Typically you want set this to 1'''. I can’t think of anything that would make you to change this to anything else. Note that the each Contract Item will be a new PCO item, when you are adding the budget as a change order.<br />
[[File:Budget Upload - Upload to PM.png|thumb|Import Estimate – Upload to PM]]<br />
Then hit the Upload button. Once the budget uploaded, it will prompt you that the budget is uploaded, and if you want to delete the data table. You can go ahead and delete it. If the data table have errors that’s not cleared up. You will not be able to upload the budget, instead, Viewpoint will prompt you a message box and tell you this. Since I have already uploaded my budget, I will not try to upload again. Just pretend the picture on the left is what you see once clicked the upload button.<br />
<br />
Locate the “Interface” module in Project Management – Program Folder. Double Click to open this program. Hit Validate, then Interface.<br />
[[File:Budget Upload - Add Bond Insurance Fee.png|thumb|Add Bond Insurance Fee]]<br />
Now go back to the Job Cost – Program, open module JC Original Estimate program. Remember that the items entered on the Summary sheet in Estimate Template will not be pulled? This is where we enter those a few items. Bond, Insurance, Fee. <br />
<br />
'''Once all these item added, your project total should matches up the contract amount.'''<br />
<br />
==== Import Estimate – Billing Schedule ====<br />
Locate in Job Cost – Program folder, JC Contract Master module. Double click to open.<br />
[[File:Budget Upload - Billing Schedule.png|thumb|Editing Billing Schedule]]<br />
# Go to your project, then select “Items” tab.<br />
# Adjust the description, add/delete the lines as needed.<br />
# Adjust the $ value in the Orig Amount. <br />
# The total amount should match the contract value.<br />
# Essentially this is the billing structure that accounting will get you to complete every month.<br />
Do:<br />
* Review tender documents and see if certain billing structure is required.<br />
* Check with CM or OM see if there are certain billing structure should be used<br />
* Check with Client and see if they want any particular item broken out<br />
* Double check the total mount of Billing, matches total amount of Estimate, Matches total amount of Contract Value.</div>ASamoilhttps://thewiki.builtplainly.com/index.php?title=Budget_Upload&diff=989Budget Upload2022-06-10T14:51:02Z<p>ASamoil: /* Est 2.0 CSV Creation method */</p>
<hr />
<div>== Introduction ==<br />
=== Objective: ===<br />
Establish a basic understanding and procedure for uploading budget from Estimate Template to Viewpoint.<br />
=== Agenda ===<br />
* Process diagram<br />
* Step by Step Tutorial<br />
* Buyout and adjust detail estimate<br />
* Consolidate detail estimate, fine tune code, units, descriptions<br />
* Export CSV file<br />
* Import CSV file to Viewpoint<br />
* Set up Billing<br />
== Tutorial ==<br />
=== What happens after a win? ===<br />
From operation standpoint we focus on the Estimate Review<br />
* Cost Code Clean Up<br />
* Consolidate Units<br />
* Review Cost and Bid<br />
* Buyout scopes<br />
* Identify contingency vs cash allowance<br />
* Any special agreement or alignment of trades<br />
* Etc.<br />
<br />
<sequencediagram style="modern-blue"><br />
Customer->Estimator: Award Project\nto Synergy<br />
Note over Estimator, Estimate\nTemplate : Reconcile Bids\nOrganize Bid Binder<br />
Estimator->Operation Team: Control Estimate (the Book)<br />
Estimator->Operation Team: Bid Binder<br />
Note over Estimator, Operation Team: Review Bid Strategy, Bids, Schedule\n(Turn Over Meeting)<br />
Note over Estimate\nTemplate, Operation Team:Review Estimate\nClean up Cost Code\nConsolidate Units\nReview Cost<br />
Estimate\nTemplate->Operation Team:Budget .CSV file<br />
Operation Team-> Viewpoint: Upload Budget <br />
</sequencediagram><br />
<br />
Then,<br />
# The entire estimate data after cleanup get poured into Viewpoint using a '''[https://en.wikipedia.org/wiki/Comma-separated_values .CSV file]'''.<br />
# The CSV file is structured specifically in a format Viewpoint can read using Import Estimate Module.<br />
=== Step-by-Step ===<br />
==== Within Estimate Work Book, you will need to do the following ====<br />
===== Step 1: Locate the "Tab" =====<br />
[[File:Budget Upload - Worksheets.png|frame|center|sample estimate workbook]]<br />
# Open the Estimate File received from Estimate Turn Over Meeting<br />
# Locate “Summary” and Division pages, drag and position those sheets to the front of all other sheets.<br />
# Locate “Est To VP” Tab, there are 6 buttons on this tab, each have their own corresponded functions. We will go through them in later pages.<br />
<br />
===== Step 2: Buy Out, Estimate Adjustment =====<br />
# Do your contract buy out.<br />
# During the buy out, modify the estimate file to match the scope that was bought into the trade’s scope.<br />
[[File:Budget Upload - Sample Buyout.png|thumb|sample buyout process]]<br />
# For the example that was shown here, the access panel and a few other scopes were estimated with own forces. During buy out, the drywaller agreed to take on those scopes for an additional cost. The number has been adjusted and moved to Subcontract Cost accordingly.<br />
# During buy out, if agreement were made for trades to take on certain additional scope for no or any cost, modify the estimate file to match the agreements.<br />
# Repeat this for all scopes pertains to the project.<br />
# In case any offsets from original contract value, we can add those after all the buy out to contingency, or book fee – pending on each project case.<br />
<br />
===== Step 3: Pull All Estimate Data To One Page =====<br />
# Locate the button called “Consolidate”. Click on it, will open a dialog allow you to select which page to include on pulling the Estimate Data Over.<br />
[[File:Budget Upload - Consolidation Button.png|thumb|consolidation button]]<br />
# In most cases, all pages from 1 to 16 will be selected.<br />
# However, if only a portion of the budget is getting uploaded, such as a change order, select only the page you want to upload.<br />
<br />
In the "Consolidation" worksheet, we can fine tune the cost codes, units, descriptions.<br />
An example is shown here. This page allows you to [[File:Budget Update - Consolidation.PNG|thumb|sample consolidation page]]<br />
* view which lines share the same cost code<br />
* Group or ungroup the cost lines by cost code<br />
* Adjusting unit of measure, quantities as needed.<br />
* This page does not allow modification to costs per se.<br />
'''Do''' <br />
* A quick check on each Division line and make sure the cost matches.<br />
* Remind yourself that any additional cost located on the summary page will not shown here – such as Insurance and Fee.<br />
'''Don’t'''<br />
* Try to change the format<br />
* Try to change the cost<br />
You can modify the description, unit of measure, quantity of the first line of the duplicated code so that the description make sense in your future forecast. In the example that’s shown, I have changed the description from “Orientation and Labour” to “Safety Equipment, Orientation and Labour” as this code contains both costlines. <br />
[[File:Budget Upload - Consolidation Description Change.png|frame|center]]<br />
The upload result of this example will be<br />
* Quantity of 20 with units of weeks<br />
* 140 hours of labour, $2,720+$5,600 for labour cost<br />
* $7,800 for material cost.<br />
* Repeat this for all cost lines.<br />
You can also combine or separate cost code for costlines. in this example, I have separated the cost code for flooring protection from the flooring subtrade. Doing so allows me to forecast easier during project execution phase. Do this as needed for all cost lines.<br />
<br />
Once you have gone thru all the cost lines, review with CM or OM if required. If you are comfortable with the consolidation and the PM has completed the above checks, you can begin to export to Viewpoint phase<br />
* Locate the “CSV Export” button, a dialog will show to let you save the CSV file generated for this estimate.<br />
* Modify the file name as needed, click “Save”.<br />
* It is recommended saving this file to the project folder, under “4 – Estimating”<br />
<br />
=== Est 2.0 CSV Creation method ===<br />
<br />
<br />
<br />
==== Import Estimate ====<br />
===== Do this using Viewpoint Import Estimate Program. =====<br />
Log into Viewpoint, Locate Module “PM Import Estimate” in Project Management – Program folder. Double Click to open the module.<br />
[[File:Budget Upload - Viewpoint Import Estimate Location.png|thumb|Locate Import Estimate Module]]<br />
<br />
This module contains a few different buttons.<br />
* Template Master lists all template that can be used to read the CSV file. We will not be touching this button.<br />
* Import Data lets you import the CSB file that was exported<br />
* Edit Work Tables lets you edit any imported budget table.<br />
* Upload into PM lets you pour the data into PM module, either as Original Estimate or as a Change Order to Existing Estimate.<br />
<br />
Click the Import Data, a window will pop open as the example shows.<br />
[[File:Budget Upload - Import Estimate Button.png|thumb|Import Estimate Button]]<br />
* For template, use SYN, this is the template made for Synergy to read a specific CSV format.<br />
* For “Import File 1:” field, click “Browse” button to the right, and select the CSV file that was exported.<br />
* For “Import ID” field, make a new Import ID, for example, you can use your initial + a number.<br />
* For Default Holdback Percentage, use 10%. <br />
* Click “Import” Button<br />
<br />
Viewpoint will be doing some work, if the project is big, in regards to amount of cost codes, it may take a minute or two. Once the file is imported, Viewpoint will prompt you a Message Box, sometimes it will say there are some errors. These errors are caused by non-standard cost code, or unit of measures that was used during estimating stage, or during consolidation stage.<br />
<br />
Click on the “Edit Work Tables” button, Viewpoint will open up a window, by default it will open the most recent import made by you. We will only be using the “Items”, “Phase”, “Cost Types” tabs.<br />
<br />
Some of the tab name is probably not familiar to you, translation:<br />
* Items – Contract Items, these are the items shows up on your billing. <br />
* Phases – Cost Codes, this tab allows you to adjust how the codes are linked with Contract Items. (you don’t have to change the links, the contract items and their amount are much easier to adjust in Job Cost – JC Contract Master module). <br />
* Cost Types – Cost Types of each cost code. This tab shows, for example the cost allocated in each cost type for each cost code.<br />
<br />
On the contract items tab, you can edit the contract Item descriptions here. I recommend to do it in JC – Contract Master module once the import is completed however.<br />
[[File:Budget Upload - Review Data Table.png|thumb|Review Data Table]]<br />
On the cost code tab, any error will be high lighted with red. Error on this tab typically is caused by the Cost Code does not existing in Master Cost Code list. Select the line with Error, double click the phase field to edit. Click F4 key on your keyboard to call out the cost code look up list, pick an appropriate code from the list. Once the code is picked, you can also add .xx.xx to it to make it more customized. For example, 12010.01. Click “Save” button, or Ctrl+S to save the change. Viewpoint will prompt you a dialog ask if it should create a phase cross reference record, '''make sure to select “NO”'''. If you accidentally clicked yes, let Siyuan know, the cross reference can be deleted from the template.<br />
<br />
Similar procedure for Cost Types tab. Viewpoint has a bug that even if you changed cost code on Phase tab, the Cost Types tab will still show the error (although the cost code is correct). To clear up the error, you will need to double click the cost code and type in the same code again. Similar procedure for Unit of Measure Error as well. Annoying I know, hopefully they fix that in the future. <br />
<br />
Once all errors are cleared up, you can click the “Upload into PM” button. Viewpoint will open a window for this. Defaulted to the most recent Data Table that you edited. In the Project field, put in the project number that this budget is going into. The Start Month – this is the effective month of your budget, not your project schedule start. For example, if you set the start month to 02/21, the budget you upload today will not shown in forecast till the February batch in 2021. Doesn’t matter if you interfaced to December 2020. The red text here is a warning, telling me there are existing cost code and cost ($0 count as well) in the project already. Uploading will have the budget accumulated. If this is the first time budget uploading to this project, it typically because some codes were opened up by accounting for insurance purposes.<br />
<br />
'''Always a good habit to check!!''' Locate in Job Cost – Programs, the JC Original Estimate module. Open it, you will see what's existing in your project, for both cost code, and budget. '''If you already have budget in the project, uploading will accumulate, instead of overwrite.'''<br />
<br />
Another Option is to upload the budget as COQ (Change Order). This is useful for project that budget get approved in phases. PCO type is always COQ. The PCO field, is correspond to Pending Change Order module, pick one that you intent to use. Make a good (consistent) name for your COQ. Starting PCO item field, correspond to the PCO item in Pending Change Order. Typically you want this to start with 1, unless you are adding to an existing PCO. Increment by: '''Typically you want set this to 1'''. I can’t think of anything that would make you to change this to anything else. Note that the each Contract Item will be a new PCO item, when you are adding the budget as a change order.<br />
[[File:Budget Upload - Upload to PM.png|thumb|Import Estimate – Upload to PM]]<br />
Then hit the Upload button. Once the budget uploaded, it will prompt you that the budget is uploaded, and if you want to delete the data table. You can go ahead and delete it. If the data table have errors that’s not cleared up. You will not be able to upload the budget, instead, Viewpoint will prompt you a message box and tell you this. Since I have already uploaded my budget, I will not try to upload again. Just pretend the picture on the left is what you see once clicked the upload button.<br />
<br />
Locate the “Interface” module in Project Management – Program Folder. Double Click to open this program. Hit Validate, then Interface.<br />
[[File:Budget Upload - Add Bond Insurance Fee.png|thumb|Add Bond Insurance Fee]]<br />
Now go back to the Job Cost – Program, open module JC Original Estimate program. Remember that the items entered on the Summary sheet in Estimate Template will not be pulled? This is where we enter those a few items. Bond, Insurance, Fee. <br />
<br />
'''Once all these item added, your project total should matches up the contract amount.'''<br />
<br />
==== Import Estimate – Billing Schedule ====<br />
Locate in Job Cost – Program folder, JC Contract Master module. Double click to open.<br />
[[File:Budget Upload - Billing Schedule.png|thumb|Editing Billing Schedule]]<br />
# Go to your project, then select “Items” tab.<br />
# Adjust the description, add/delete the lines as needed.<br />
# Adjust the $ value in the Orig Amount. <br />
# The total amount should match the contract value.<br />
# Essentially this is the billing structure that accounting will get you to complete every month.<br />
Do:<br />
* Review tender documents and see if certain billing structure is required.<br />
* Check with CM or OM see if there are certain billing structure should be used<br />
* Check with Client and see if they want any particular item broken out<br />
* Double check the total mount of Billing, matches total amount of Estimate, Matches total amount of Contract Value.</div>ASamoilhttps://thewiki.builtplainly.com/index.php?title=Budget_Upload&diff=988Budget Upload2022-06-10T14:50:54Z<p>ASamoil: /* Est 2.0 CSV Creation method */</p>
<hr />
<div>== Introduction ==<br />
=== Objective: ===<br />
Establish a basic understanding and procedure for uploading budget from Estimate Template to Viewpoint.<br />
=== Agenda ===<br />
* Process diagram<br />
* Step by Step Tutorial<br />
* Buyout and adjust detail estimate<br />
* Consolidate detail estimate, fine tune code, units, descriptions<br />
* Export CSV file<br />
* Import CSV file to Viewpoint<br />
* Set up Billing<br />
== Tutorial ==<br />
=== What happens after a win? ===<br />
From operation standpoint we focus on the Estimate Review<br />
* Cost Code Clean Up<br />
* Consolidate Units<br />
* Review Cost and Bid<br />
* Buyout scopes<br />
* Identify contingency vs cash allowance<br />
* Any special agreement or alignment of trades<br />
* Etc.<br />
<br />
<sequencediagram style="modern-blue"><br />
Customer->Estimator: Award Project\nto Synergy<br />
Note over Estimator, Estimate\nTemplate : Reconcile Bids\nOrganize Bid Binder<br />
Estimator->Operation Team: Control Estimate (the Book)<br />
Estimator->Operation Team: Bid Binder<br />
Note over Estimator, Operation Team: Review Bid Strategy, Bids, Schedule\n(Turn Over Meeting)<br />
Note over Estimate\nTemplate, Operation Team:Review Estimate\nClean up Cost Code\nConsolidate Units\nReview Cost<br />
Estimate\nTemplate->Operation Team:Budget .CSV file<br />
Operation Team-> Viewpoint: Upload Budget <br />
</sequencediagram><br />
<br />
Then,<br />
# The entire estimate data after cleanup get poured into Viewpoint using a '''[https://en.wikipedia.org/wiki/Comma-separated_values .CSV file]'''.<br />
# The CSV file is structured specifically in a format Viewpoint can read using Import Estimate Module.<br />
=== Step-by-Step ===<br />
==== Within Estimate Work Book, you will need to do the following ====<br />
===== Step 1: Locate the "Tab" =====<br />
[[File:Budget Upload - Worksheets.png|frame|center|sample estimate workbook]]<br />
# Open the Estimate File received from Estimate Turn Over Meeting<br />
# Locate “Summary” and Division pages, drag and position those sheets to the front of all other sheets.<br />
# Locate “Est To VP” Tab, there are 6 buttons on this tab, each have their own corresponded functions. We will go through them in later pages.<br />
<br />
===== Step 2: Buy Out, Estimate Adjustment =====<br />
# Do your contract buy out.<br />
# During the buy out, modify the estimate file to match the scope that was bought into the trade’s scope.<br />
[[File:Budget Upload - Sample Buyout.png|thumb|sample buyout process]]<br />
# For the example that was shown here, the access panel and a few other scopes were estimated with own forces. During buy out, the drywaller agreed to take on those scopes for an additional cost. The number has been adjusted and moved to Subcontract Cost accordingly.<br />
# During buy out, if agreement were made for trades to take on certain additional scope for no or any cost, modify the estimate file to match the agreements.<br />
# Repeat this for all scopes pertains to the project.<br />
# In case any offsets from original contract value, we can add those after all the buy out to contingency, or book fee – pending on each project case.<br />
<br />
===== Step 3: Pull All Estimate Data To One Page =====<br />
# Locate the button called “Consolidate”. Click on it, will open a dialog allow you to select which page to include on pulling the Estimate Data Over.<br />
[[File:Budget Upload - Consolidation Button.png|thumb|consolidation button]]<br />
# In most cases, all pages from 1 to 16 will be selected.<br />
# However, if only a portion of the budget is getting uploaded, such as a change order, select only the page you want to upload.<br />
<br />
In the "Consolidation" worksheet, we can fine tune the cost codes, units, descriptions.<br />
An example is shown here. This page allows you to [[File:Budget Update - Consolidation.PNG|thumb|sample consolidation page]]<br />
* view which lines share the same cost code<br />
* Group or ungroup the cost lines by cost code<br />
* Adjusting unit of measure, quantities as needed.<br />
* This page does not allow modification to costs per se.<br />
'''Do''' <br />
* A quick check on each Division line and make sure the cost matches.<br />
* Remind yourself that any additional cost located on the summary page will not shown here – such as Insurance and Fee.<br />
'''Don’t'''<br />
* Try to change the format<br />
* Try to change the cost<br />
You can modify the description, unit of measure, quantity of the first line of the duplicated code so that the description make sense in your future forecast. In the example that’s shown, I have changed the description from “Orientation and Labour” to “Safety Equipment, Orientation and Labour” as this code contains both costlines. <br />
[[File:Budget Upload - Consolidation Description Change.png|frame|center]]<br />
The upload result of this example will be<br />
* Quantity of 20 with units of weeks<br />
* 140 hours of labour, $2,720+$5,600 for labour cost<br />
* $7,800 for material cost.<br />
* Repeat this for all cost lines.<br />
You can also combine or separate cost code for costlines. in this example, I have separated the cost code for flooring protection from the flooring subtrade. Doing so allows me to forecast easier during project execution phase. Do this as needed for all cost lines.<br />
<br />
Once you have gone thru all the cost lines, review with CM or OM if required. If you are comfortable with the consolidation and the PM has completed the above checks, you can begin to export to Viewpoint phase<br />
* Locate the “CSV Export” button, a dialog will show to let you save the CSV file generated for this estimate.<br />
* Modify the file name as needed, click “Save”.<br />
* It is recommended saving this file to the project folder, under “4 – Estimating”<br />
<br />
=== Est 2.0 CSV Creation method ===<br />
<br />
==== Import Estimate ====<br />
===== Do this using Viewpoint Import Estimate Program. =====<br />
Log into Viewpoint, Locate Module “PM Import Estimate” in Project Management – Program folder. Double Click to open the module.<br />
[[File:Budget Upload - Viewpoint Import Estimate Location.png|thumb|Locate Import Estimate Module]]<br />
<br />
This module contains a few different buttons.<br />
* Template Master lists all template that can be used to read the CSV file. We will not be touching this button.<br />
* Import Data lets you import the CSB file that was exported<br />
* Edit Work Tables lets you edit any imported budget table.<br />
* Upload into PM lets you pour the data into PM module, either as Original Estimate or as a Change Order to Existing Estimate.<br />
<br />
Click the Import Data, a window will pop open as the example shows.<br />
[[File:Budget Upload - Import Estimate Button.png|thumb|Import Estimate Button]]<br />
* For template, use SYN, this is the template made for Synergy to read a specific CSV format.<br />
* For “Import File 1:” field, click “Browse” button to the right, and select the CSV file that was exported.<br />
* For “Import ID” field, make a new Import ID, for example, you can use your initial + a number.<br />
* For Default Holdback Percentage, use 10%. <br />
* Click “Import” Button<br />
<br />
Viewpoint will be doing some work, if the project is big, in regards to amount of cost codes, it may take a minute or two. Once the file is imported, Viewpoint will prompt you a Message Box, sometimes it will say there are some errors. These errors are caused by non-standard cost code, or unit of measures that was used during estimating stage, or during consolidation stage.<br />
<br />
Click on the “Edit Work Tables” button, Viewpoint will open up a window, by default it will open the most recent import made by you. We will only be using the “Items”, “Phase”, “Cost Types” tabs.<br />
<br />
Some of the tab name is probably not familiar to you, translation:<br />
* Items – Contract Items, these are the items shows up on your billing. <br />
* Phases – Cost Codes, this tab allows you to adjust how the codes are linked with Contract Items. (you don’t have to change the links, the contract items and their amount are much easier to adjust in Job Cost – JC Contract Master module). <br />
* Cost Types – Cost Types of each cost code. This tab shows, for example the cost allocated in each cost type for each cost code.<br />
<br />
On the contract items tab, you can edit the contract Item descriptions here. I recommend to do it in JC – Contract Master module once the import is completed however.<br />
[[File:Budget Upload - Review Data Table.png|thumb|Review Data Table]]<br />
On the cost code tab, any error will be high lighted with red. Error on this tab typically is caused by the Cost Code does not existing in Master Cost Code list. Select the line with Error, double click the phase field to edit. Click F4 key on your keyboard to call out the cost code look up list, pick an appropriate code from the list. Once the code is picked, you can also add .xx.xx to it to make it more customized. For example, 12010.01. Click “Save” button, or Ctrl+S to save the change. Viewpoint will prompt you a dialog ask if it should create a phase cross reference record, '''make sure to select “NO”'''. If you accidentally clicked yes, let Siyuan know, the cross reference can be deleted from the template.<br />
<br />
Similar procedure for Cost Types tab. Viewpoint has a bug that even if you changed cost code on Phase tab, the Cost Types tab will still show the error (although the cost code is correct). To clear up the error, you will need to double click the cost code and type in the same code again. Similar procedure for Unit of Measure Error as well. Annoying I know, hopefully they fix that in the future. <br />
<br />
Once all errors are cleared up, you can click the “Upload into PM” button. Viewpoint will open a window for this. Defaulted to the most recent Data Table that you edited. In the Project field, put in the project number that this budget is going into. The Start Month – this is the effective month of your budget, not your project schedule start. For example, if you set the start month to 02/21, the budget you upload today will not shown in forecast till the February batch in 2021. Doesn’t matter if you interfaced to December 2020. The red text here is a warning, telling me there are existing cost code and cost ($0 count as well) in the project already. Uploading will have the budget accumulated. If this is the first time budget uploading to this project, it typically because some codes were opened up by accounting for insurance purposes.<br />
<br />
'''Always a good habit to check!!''' Locate in Job Cost – Programs, the JC Original Estimate module. Open it, you will see what's existing in your project, for both cost code, and budget. '''If you already have budget in the project, uploading will accumulate, instead of overwrite.'''<br />
<br />
Another Option is to upload the budget as COQ (Change Order). This is useful for project that budget get approved in phases. PCO type is always COQ. The PCO field, is correspond to Pending Change Order module, pick one that you intent to use. Make a good (consistent) name for your COQ. Starting PCO item field, correspond to the PCO item in Pending Change Order. Typically you want this to start with 1, unless you are adding to an existing PCO. Increment by: '''Typically you want set this to 1'''. I can’t think of anything that would make you to change this to anything else. Note that the each Contract Item will be a new PCO item, when you are adding the budget as a change order.<br />
[[File:Budget Upload - Upload to PM.png|thumb|Import Estimate – Upload to PM]]<br />
Then hit the Upload button. Once the budget uploaded, it will prompt you that the budget is uploaded, and if you want to delete the data table. You can go ahead and delete it. If the data table have errors that’s not cleared up. You will not be able to upload the budget, instead, Viewpoint will prompt you a message box and tell you this. Since I have already uploaded my budget, I will not try to upload again. Just pretend the picture on the left is what you see once clicked the upload button.<br />
<br />
Locate the “Interface” module in Project Management – Program Folder. Double Click to open this program. Hit Validate, then Interface.<br />
[[File:Budget Upload - Add Bond Insurance Fee.png|thumb|Add Bond Insurance Fee]]<br />
Now go back to the Job Cost – Program, open module JC Original Estimate program. Remember that the items entered on the Summary sheet in Estimate Template will not be pulled? This is where we enter those a few items. Bond, Insurance, Fee. <br />
<br />
'''Once all these item added, your project total should matches up the contract amount.'''<br />
<br />
==== Import Estimate – Billing Schedule ====<br />
Locate in Job Cost – Program folder, JC Contract Master module. Double click to open.<br />
[[File:Budget Upload - Billing Schedule.png|thumb|Editing Billing Schedule]]<br />
# Go to your project, then select “Items” tab.<br />
# Adjust the description, add/delete the lines as needed.<br />
# Adjust the $ value in the Orig Amount. <br />
# The total amount should match the contract value.<br />
# Essentially this is the billing structure that accounting will get you to complete every month.<br />
Do:<br />
* Review tender documents and see if certain billing structure is required.<br />
* Check with CM or OM see if there are certain billing structure should be used<br />
* Check with Client and see if they want any particular item broken out<br />
* Double check the total mount of Billing, matches total amount of Estimate, Matches total amount of Contract Value.</div>ASamoilhttps://thewiki.builtplainly.com/index.php?title=Budget_Upload&diff=987Budget Upload2022-06-10T14:50:34Z<p>ASamoil: /* Step 3: Pull All Estimate Data To One Page */</p>
<hr />
<div>== Introduction ==<br />
=== Objective: ===<br />
Establish a basic understanding and procedure for uploading budget from Estimate Template to Viewpoint.<br />
=== Agenda ===<br />
* Process diagram<br />
* Step by Step Tutorial<br />
* Buyout and adjust detail estimate<br />
* Consolidate detail estimate, fine tune code, units, descriptions<br />
* Export CSV file<br />
* Import CSV file to Viewpoint<br />
* Set up Billing<br />
== Tutorial ==<br />
=== What happens after a win? ===<br />
From operation standpoint we focus on the Estimate Review<br />
* Cost Code Clean Up<br />
* Consolidate Units<br />
* Review Cost and Bid<br />
* Buyout scopes<br />
* Identify contingency vs cash allowance<br />
* Any special agreement or alignment of trades<br />
* Etc.<br />
<br />
<sequencediagram style="modern-blue"><br />
Customer->Estimator: Award Project\nto Synergy<br />
Note over Estimator, Estimate\nTemplate : Reconcile Bids\nOrganize Bid Binder<br />
Estimator->Operation Team: Control Estimate (the Book)<br />
Estimator->Operation Team: Bid Binder<br />
Note over Estimator, Operation Team: Review Bid Strategy, Bids, Schedule\n(Turn Over Meeting)<br />
Note over Estimate\nTemplate, Operation Team:Review Estimate\nClean up Cost Code\nConsolidate Units\nReview Cost<br />
Estimate\nTemplate->Operation Team:Budget .CSV file<br />
Operation Team-> Viewpoint: Upload Budget <br />
</sequencediagram><br />
<br />
Then,<br />
# The entire estimate data after cleanup get poured into Viewpoint using a '''[https://en.wikipedia.org/wiki/Comma-separated_values .CSV file]'''.<br />
# The CSV file is structured specifically in a format Viewpoint can read using Import Estimate Module.<br />
=== Step-by-Step ===<br />
==== Within Estimate Work Book, you will need to do the following ====<br />
===== Step 1: Locate the "Tab" =====<br />
[[File:Budget Upload - Worksheets.png|frame|center|sample estimate workbook]]<br />
# Open the Estimate File received from Estimate Turn Over Meeting<br />
# Locate “Summary” and Division pages, drag and position those sheets to the front of all other sheets.<br />
# Locate “Est To VP” Tab, there are 6 buttons on this tab, each have their own corresponded functions. We will go through them in later pages.<br />
<br />
===== Step 2: Buy Out, Estimate Adjustment =====<br />
# Do your contract buy out.<br />
# During the buy out, modify the estimate file to match the scope that was bought into the trade’s scope.<br />
[[File:Budget Upload - Sample Buyout.png|thumb|sample buyout process]]<br />
# For the example that was shown here, the access panel and a few other scopes were estimated with own forces. During buy out, the drywaller agreed to take on those scopes for an additional cost. The number has been adjusted and moved to Subcontract Cost accordingly.<br />
# During buy out, if agreement were made for trades to take on certain additional scope for no or any cost, modify the estimate file to match the agreements.<br />
# Repeat this for all scopes pertains to the project.<br />
# In case any offsets from original contract value, we can add those after all the buy out to contingency, or book fee – pending on each project case.<br />
<br />
===== Step 3: Pull All Estimate Data To One Page =====<br />
# Locate the button called “Consolidate”. Click on it, will open a dialog allow you to select which page to include on pulling the Estimate Data Over.<br />
[[File:Budget Upload - Consolidation Button.png|thumb|consolidation button]]<br />
# In most cases, all pages from 1 to 16 will be selected.<br />
# However, if only a portion of the budget is getting uploaded, such as a change order, select only the page you want to upload.<br />
<br />
In the "Consolidation" worksheet, we can fine tune the cost codes, units, descriptions.<br />
An example is shown here. This page allows you to [[File:Budget Update - Consolidation.PNG|thumb|sample consolidation page]]<br />
* view which lines share the same cost code<br />
* Group or ungroup the cost lines by cost code<br />
* Adjusting unit of measure, quantities as needed.<br />
* This page does not allow modification to costs per se.<br />
'''Do''' <br />
* A quick check on each Division line and make sure the cost matches.<br />
* Remind yourself that any additional cost located on the summary page will not shown here – such as Insurance and Fee.<br />
'''Don’t'''<br />
* Try to change the format<br />
* Try to change the cost<br />
You can modify the description, unit of measure, quantity of the first line of the duplicated code so that the description make sense in your future forecast. In the example that’s shown, I have changed the description from “Orientation and Labour” to “Safety Equipment, Orientation and Labour” as this code contains both costlines. <br />
[[File:Budget Upload - Consolidation Description Change.png|frame|center]]<br />
The upload result of this example will be<br />
* Quantity of 20 with units of weeks<br />
* 140 hours of labour, $2,720+$5,600 for labour cost<br />
* $7,800 for material cost.<br />
* Repeat this for all cost lines.<br />
You can also combine or separate cost code for costlines. in this example, I have separated the cost code for flooring protection from the flooring subtrade. Doing so allows me to forecast easier during project execution phase. Do this as needed for all cost lines.<br />
<br />
Once you have gone thru all the cost lines, review with CM or OM if required. If you are comfortable with the consolidation and the PM has completed the above checks, you can begin to export to Viewpoint phase<br />
* Locate the “CSV Export” button, a dialog will show to let you save the CSV file generated for this estimate.<br />
* Modify the file name as needed, click “Save”.<br />
* It is recommended saving this file to the project folder, under “4 – Estimating”<br />
<br />
== Est 2.0 CSV Creation method ==<br />
<br />
==== Import Estimate ====<br />
===== Do this using Viewpoint Import Estimate Program. =====<br />
Log into Viewpoint, Locate Module “PM Import Estimate” in Project Management – Program folder. Double Click to open the module.<br />
[[File:Budget Upload - Viewpoint Import Estimate Location.png|thumb|Locate Import Estimate Module]]<br />
<br />
This module contains a few different buttons.<br />
* Template Master lists all template that can be used to read the CSV file. We will not be touching this button.<br />
* Import Data lets you import the CSB file that was exported<br />
* Edit Work Tables lets you edit any imported budget table.<br />
* Upload into PM lets you pour the data into PM module, either as Original Estimate or as a Change Order to Existing Estimate.<br />
<br />
Click the Import Data, a window will pop open as the example shows.<br />
[[File:Budget Upload - Import Estimate Button.png|thumb|Import Estimate Button]]<br />
* For template, use SYN, this is the template made for Synergy to read a specific CSV format.<br />
* For “Import File 1:” field, click “Browse” button to the right, and select the CSV file that was exported.<br />
* For “Import ID” field, make a new Import ID, for example, you can use your initial + a number.<br />
* For Default Holdback Percentage, use 10%. <br />
* Click “Import” Button<br />
<br />
Viewpoint will be doing some work, if the project is big, in regards to amount of cost codes, it may take a minute or two. Once the file is imported, Viewpoint will prompt you a Message Box, sometimes it will say there are some errors. These errors are caused by non-standard cost code, or unit of measures that was used during estimating stage, or during consolidation stage.<br />
<br />
Click on the “Edit Work Tables” button, Viewpoint will open up a window, by default it will open the most recent import made by you. We will only be using the “Items”, “Phase”, “Cost Types” tabs.<br />
<br />
Some of the tab name is probably not familiar to you, translation:<br />
* Items – Contract Items, these are the items shows up on your billing. <br />
* Phases – Cost Codes, this tab allows you to adjust how the codes are linked with Contract Items. (you don’t have to change the links, the contract items and their amount are much easier to adjust in Job Cost – JC Contract Master module). <br />
* Cost Types – Cost Types of each cost code. This tab shows, for example the cost allocated in each cost type for each cost code.<br />
<br />
On the contract items tab, you can edit the contract Item descriptions here. I recommend to do it in JC – Contract Master module once the import is completed however.<br />
[[File:Budget Upload - Review Data Table.png|thumb|Review Data Table]]<br />
On the cost code tab, any error will be high lighted with red. Error on this tab typically is caused by the Cost Code does not existing in Master Cost Code list. Select the line with Error, double click the phase field to edit. Click F4 key on your keyboard to call out the cost code look up list, pick an appropriate code from the list. Once the code is picked, you can also add .xx.xx to it to make it more customized. For example, 12010.01. Click “Save” button, or Ctrl+S to save the change. Viewpoint will prompt you a dialog ask if it should create a phase cross reference record, '''make sure to select “NO”'''. If you accidentally clicked yes, let Siyuan know, the cross reference can be deleted from the template.<br />
<br />
Similar procedure for Cost Types tab. Viewpoint has a bug that even if you changed cost code on Phase tab, the Cost Types tab will still show the error (although the cost code is correct). To clear up the error, you will need to double click the cost code and type in the same code again. Similar procedure for Unit of Measure Error as well. Annoying I know, hopefully they fix that in the future. <br />
<br />
Once all errors are cleared up, you can click the “Upload into PM” button. Viewpoint will open a window for this. Defaulted to the most recent Data Table that you edited. In the Project field, put in the project number that this budget is going into. The Start Month – this is the effective month of your budget, not your project schedule start. For example, if you set the start month to 02/21, the budget you upload today will not shown in forecast till the February batch in 2021. Doesn’t matter if you interfaced to December 2020. The red text here is a warning, telling me there are existing cost code and cost ($0 count as well) in the project already. Uploading will have the budget accumulated. If this is the first time budget uploading to this project, it typically because some codes were opened up by accounting for insurance purposes.<br />
<br />
'''Always a good habit to check!!''' Locate in Job Cost – Programs, the JC Original Estimate module. Open it, you will see what's existing in your project, for both cost code, and budget. '''If you already have budget in the project, uploading will accumulate, instead of overwrite.'''<br />
<br />
Another Option is to upload the budget as COQ (Change Order). This is useful for project that budget get approved in phases. PCO type is always COQ. The PCO field, is correspond to Pending Change Order module, pick one that you intent to use. Make a good (consistent) name for your COQ. Starting PCO item field, correspond to the PCO item in Pending Change Order. Typically you want this to start with 1, unless you are adding to an existing PCO. Increment by: '''Typically you want set this to 1'''. I can’t think of anything that would make you to change this to anything else. Note that the each Contract Item will be a new PCO item, when you are adding the budget as a change order.<br />
[[File:Budget Upload - Upload to PM.png|thumb|Import Estimate – Upload to PM]]<br />
Then hit the Upload button. Once the budget uploaded, it will prompt you that the budget is uploaded, and if you want to delete the data table. You can go ahead and delete it. If the data table have errors that’s not cleared up. You will not be able to upload the budget, instead, Viewpoint will prompt you a message box and tell you this. Since I have already uploaded my budget, I will not try to upload again. Just pretend the picture on the left is what you see once clicked the upload button.<br />
<br />
Locate the “Interface” module in Project Management – Program Folder. Double Click to open this program. Hit Validate, then Interface.<br />
[[File:Budget Upload - Add Bond Insurance Fee.png|thumb|Add Bond Insurance Fee]]<br />
Now go back to the Job Cost – Program, open module JC Original Estimate program. Remember that the items entered on the Summary sheet in Estimate Template will not be pulled? This is where we enter those a few items. Bond, Insurance, Fee. <br />
<br />
'''Once all these item added, your project total should matches up the contract amount.'''<br />
<br />
==== Import Estimate – Billing Schedule ====<br />
Locate in Job Cost – Program folder, JC Contract Master module. Double click to open.<br />
[[File:Budget Upload - Billing Schedule.png|thumb|Editing Billing Schedule]]<br />
# Go to your project, then select “Items” tab.<br />
# Adjust the description, add/delete the lines as needed.<br />
# Adjust the $ value in the Orig Amount. <br />
# The total amount should match the contract value.<br />
# Essentially this is the billing structure that accounting will get you to complete every month.<br />
Do:<br />
* Review tender documents and see if certain billing structure is required.<br />
* Check with CM or OM see if there are certain billing structure should be used<br />
* Check with Client and see if they want any particular item broken out<br />
* Double check the total mount of Billing, matches total amount of Estimate, Matches total amount of Contract Value.</div>ASamoilhttps://thewiki.builtplainly.com/index.php?title=Budget_Upload&diff=986Budget Upload2022-06-10T14:50:07Z<p>ASamoil: /* Step 3: Pull All Estimate Data To One Page */</p>
<hr />
<div>== Introduction ==<br />
=== Objective: ===<br />
Establish a basic understanding and procedure for uploading budget from Estimate Template to Viewpoint.<br />
=== Agenda ===<br />
* Process diagram<br />
* Step by Step Tutorial<br />
* Buyout and adjust detail estimate<br />
* Consolidate detail estimate, fine tune code, units, descriptions<br />
* Export CSV file<br />
* Import CSV file to Viewpoint<br />
* Set up Billing<br />
== Tutorial ==<br />
=== What happens after a win? ===<br />
From operation standpoint we focus on the Estimate Review<br />
* Cost Code Clean Up<br />
* Consolidate Units<br />
* Review Cost and Bid<br />
* Buyout scopes<br />
* Identify contingency vs cash allowance<br />
* Any special agreement or alignment of trades<br />
* Etc.<br />
<br />
<sequencediagram style="modern-blue"><br />
Customer->Estimator: Award Project\nto Synergy<br />
Note over Estimator, Estimate\nTemplate : Reconcile Bids\nOrganize Bid Binder<br />
Estimator->Operation Team: Control Estimate (the Book)<br />
Estimator->Operation Team: Bid Binder<br />
Note over Estimator, Operation Team: Review Bid Strategy, Bids, Schedule\n(Turn Over Meeting)<br />
Note over Estimate\nTemplate, Operation Team:Review Estimate\nClean up Cost Code\nConsolidate Units\nReview Cost<br />
Estimate\nTemplate->Operation Team:Budget .CSV file<br />
Operation Team-> Viewpoint: Upload Budget <br />
</sequencediagram><br />
<br />
Then,<br />
# The entire estimate data after cleanup get poured into Viewpoint using a '''[https://en.wikipedia.org/wiki/Comma-separated_values .CSV file]'''.<br />
# The CSV file is structured specifically in a format Viewpoint can read using Import Estimate Module.<br />
=== Step-by-Step ===<br />
==== Within Estimate Work Book, you will need to do the following ====<br />
===== Step 1: Locate the "Tab" =====<br />
[[File:Budget Upload - Worksheets.png|frame|center|sample estimate workbook]]<br />
# Open the Estimate File received from Estimate Turn Over Meeting<br />
# Locate “Summary” and Division pages, drag and position those sheets to the front of all other sheets.<br />
# Locate “Est To VP” Tab, there are 6 buttons on this tab, each have their own corresponded functions. We will go through them in later pages.<br />
<br />
===== Step 2: Buy Out, Estimate Adjustment =====<br />
# Do your contract buy out.<br />
# During the buy out, modify the estimate file to match the scope that was bought into the trade’s scope.<br />
[[File:Budget Upload - Sample Buyout.png|thumb|sample buyout process]]<br />
# For the example that was shown here, the access panel and a few other scopes were estimated with own forces. During buy out, the drywaller agreed to take on those scopes for an additional cost. The number has been adjusted and moved to Subcontract Cost accordingly.<br />
# During buy out, if agreement were made for trades to take on certain additional scope for no or any cost, modify the estimate file to match the agreements.<br />
# Repeat this for all scopes pertains to the project.<br />
# In case any offsets from original contract value, we can add those after all the buy out to contingency, or book fee – pending on each project case.<br />
<br />
===== Step 3: Pull All Estimate Data To One Page =====<br />
# Locate the button called “Consolidate”. Click on it, will open a dialog allow you to select which page to include on pulling the Estimate Data Over.<br />
[[File:Budget Upload - Consolidation Button.png|thumb|consolidation button]]<br />
# In most cases, all pages from 1 to 16 will be selected.<br />
# However, if only a portion of the budget is getting uploaded, such as a change order, select only the page you want to upload.<br />
<br />
In the "Consolidation" worksheet, we can fine tune the cost codes, units, descriptions.<br />
An example is shown here. This page allows you to [[File:Budget Update - Consolidation.PNG|thumb|sample consolidation page]]<br />
* view which lines share the same cost code<br />
* Group or ungroup the cost lines by cost code<br />
* Adjusting unit of measure, quantities as needed.<br />
* This page does not allow modification to costs per se.<br />
'''Do''' <br />
* A quick check on each Division line and make sure the cost matches.<br />
* Remind yourself that any additional cost located on the summary page will not shown here – such as Insurance and Fee.<br />
'''Don’t'''<br />
* Try to change the format<br />
* Try to change the cost<br />
You can modify the description, unit of measure, quantity of the first line of the duplicated code so that the description make sense in your future forecast. In the example that’s shown, I have changed the description from “Orientation and Labour” to “Safety Equipment, Orientation and Labour” as this code contains both costlines. <br />
[[File:Budget Upload - Consolidation Description Change.png|frame|center]]<br />
The upload result of this example will be<br />
* Quantity of 20 with units of weeks<br />
* 140 hours of labour, $2,720+$5,600 for labour cost<br />
* $7,800 for material cost.<br />
* Repeat this for all cost lines.<br />
You can also combine or separate cost code for costlines. in this example, I have separated the cost code for flooring protection from the flooring subtrade. Doing so allows me to forecast easier during project execution phase. Do this as needed for all cost lines.<br />
<br />
Once you have gone thru all the cost lines, review with CM or OM if required. If you are comfortable with the consolidation and the PM has completed the above checks, you can begin to export to Viewpoint phase<br />
* Locate the “CSV Export” button, a dialog will show to let you save the CSV file generated for this estimate.<br />
* Modify the file name as needed, click “Save”.<br />
* It is recommended saving this file to the project folder, under “4 – Estimating”<br />
<br />
[[Est 2.0 CSV Creation method]]<br />
<br />
==== Import Estimate ====<br />
===== Do this using Viewpoint Import Estimate Program. =====<br />
Log into Viewpoint, Locate Module “PM Import Estimate” in Project Management – Program folder. Double Click to open the module.<br />
[[File:Budget Upload - Viewpoint Import Estimate Location.png|thumb|Locate Import Estimate Module]]<br />
<br />
This module contains a few different buttons.<br />
* Template Master lists all template that can be used to read the CSV file. We will not be touching this button.<br />
* Import Data lets you import the CSB file that was exported<br />
* Edit Work Tables lets you edit any imported budget table.<br />
* Upload into PM lets you pour the data into PM module, either as Original Estimate or as a Change Order to Existing Estimate.<br />
<br />
Click the Import Data, a window will pop open as the example shows.<br />
[[File:Budget Upload - Import Estimate Button.png|thumb|Import Estimate Button]]<br />
* For template, use SYN, this is the template made for Synergy to read a specific CSV format.<br />
* For “Import File 1:” field, click “Browse” button to the right, and select the CSV file that was exported.<br />
* For “Import ID” field, make a new Import ID, for example, you can use your initial + a number.<br />
* For Default Holdback Percentage, use 10%. <br />
* Click “Import” Button<br />
<br />
Viewpoint will be doing some work, if the project is big, in regards to amount of cost codes, it may take a minute or two. Once the file is imported, Viewpoint will prompt you a Message Box, sometimes it will say there are some errors. These errors are caused by non-standard cost code, or unit of measures that was used during estimating stage, or during consolidation stage.<br />
<br />
Click on the “Edit Work Tables” button, Viewpoint will open up a window, by default it will open the most recent import made by you. We will only be using the “Items”, “Phase”, “Cost Types” tabs.<br />
<br />
Some of the tab name is probably not familiar to you, translation:<br />
* Items – Contract Items, these are the items shows up on your billing. <br />
* Phases – Cost Codes, this tab allows you to adjust how the codes are linked with Contract Items. (you don’t have to change the links, the contract items and their amount are much easier to adjust in Job Cost – JC Contract Master module). <br />
* Cost Types – Cost Types of each cost code. This tab shows, for example the cost allocated in each cost type for each cost code.<br />
<br />
On the contract items tab, you can edit the contract Item descriptions here. I recommend to do it in JC – Contract Master module once the import is completed however.<br />
[[File:Budget Upload - Review Data Table.png|thumb|Review Data Table]]<br />
On the cost code tab, any error will be high lighted with red. Error on this tab typically is caused by the Cost Code does not existing in Master Cost Code list. Select the line with Error, double click the phase field to edit. Click F4 key on your keyboard to call out the cost code look up list, pick an appropriate code from the list. Once the code is picked, you can also add .xx.xx to it to make it more customized. For example, 12010.01. Click “Save” button, or Ctrl+S to save the change. Viewpoint will prompt you a dialog ask if it should create a phase cross reference record, '''make sure to select “NO”'''. If you accidentally clicked yes, let Siyuan know, the cross reference can be deleted from the template.<br />
<br />
Similar procedure for Cost Types tab. Viewpoint has a bug that even if you changed cost code on Phase tab, the Cost Types tab will still show the error (although the cost code is correct). To clear up the error, you will need to double click the cost code and type in the same code again. Similar procedure for Unit of Measure Error as well. Annoying I know, hopefully they fix that in the future. <br />
<br />
Once all errors are cleared up, you can click the “Upload into PM” button. Viewpoint will open a window for this. Defaulted to the most recent Data Table that you edited. In the Project field, put in the project number that this budget is going into. The Start Month – this is the effective month of your budget, not your project schedule start. For example, if you set the start month to 02/21, the budget you upload today will not shown in forecast till the February batch in 2021. Doesn’t matter if you interfaced to December 2020. The red text here is a warning, telling me there are existing cost code and cost ($0 count as well) in the project already. Uploading will have the budget accumulated. If this is the first time budget uploading to this project, it typically because some codes were opened up by accounting for insurance purposes.<br />
<br />
'''Always a good habit to check!!''' Locate in Job Cost – Programs, the JC Original Estimate module. Open it, you will see what's existing in your project, for both cost code, and budget. '''If you already have budget in the project, uploading will accumulate, instead of overwrite.'''<br />
<br />
Another Option is to upload the budget as COQ (Change Order). This is useful for project that budget get approved in phases. PCO type is always COQ. The PCO field, is correspond to Pending Change Order module, pick one that you intent to use. Make a good (consistent) name for your COQ. Starting PCO item field, correspond to the PCO item in Pending Change Order. Typically you want this to start with 1, unless you are adding to an existing PCO. Increment by: '''Typically you want set this to 1'''. I can’t think of anything that would make you to change this to anything else. Note that the each Contract Item will be a new PCO item, when you are adding the budget as a change order.<br />
[[File:Budget Upload - Upload to PM.png|thumb|Import Estimate – Upload to PM]]<br />
Then hit the Upload button. Once the budget uploaded, it will prompt you that the budget is uploaded, and if you want to delete the data table. You can go ahead and delete it. If the data table have errors that’s not cleared up. You will not be able to upload the budget, instead, Viewpoint will prompt you a message box and tell you this. Since I have already uploaded my budget, I will not try to upload again. Just pretend the picture on the left is what you see once clicked the upload button.<br />
<br />
Locate the “Interface” module in Project Management – Program Folder. Double Click to open this program. Hit Validate, then Interface.<br />
[[File:Budget Upload - Add Bond Insurance Fee.png|thumb|Add Bond Insurance Fee]]<br />
Now go back to the Job Cost – Program, open module JC Original Estimate program. Remember that the items entered on the Summary sheet in Estimate Template will not be pulled? This is where we enter those a few items. Bond, Insurance, Fee. <br />
<br />
'''Once all these item added, your project total should matches up the contract amount.'''<br />
<br />
==== Import Estimate – Billing Schedule ====<br />
Locate in Job Cost – Program folder, JC Contract Master module. Double click to open.<br />
[[File:Budget Upload - Billing Schedule.png|thumb|Editing Billing Schedule]]<br />
# Go to your project, then select “Items” tab.<br />
# Adjust the description, add/delete the lines as needed.<br />
# Adjust the $ value in the Orig Amount. <br />
# The total amount should match the contract value.<br />
# Essentially this is the billing structure that accounting will get you to complete every month.<br />
Do:<br />
* Review tender documents and see if certain billing structure is required.<br />
* Check with CM or OM see if there are certain billing structure should be used<br />
* Check with Client and see if they want any particular item broken out<br />
* Double check the total mount of Billing, matches total amount of Estimate, Matches total amount of Contract Value.</div>ASamoilhttps://thewiki.builtplainly.com/index.php?title=Budget_Upload&diff=985Budget Upload2022-06-09T18:23:26Z<p>ASamoil: /* Ste-by-Step */</p>
<hr />
<div>== Introduction ==<br />
=== Objective: ===<br />
Establish a basic understanding and procedure for uploading budget from Estimate Template to Viewpoint.<br />
=== Agenda ===<br />
* Process diagram<br />
* Step by Step Tutorial<br />
* Buyout and adjust detail estimate<br />
* Consolidate detail estimate, fine tune code, units, descriptions<br />
* Export CSV file<br />
* Import CSV file to Viewpoint<br />
* Set up Billing<br />
== Tutorial ==<br />
=== What happens after a win? ===<br />
From operation standpoint we focus on the Estimate Review<br />
* Cost Code Clean Up<br />
* Consolidate Units<br />
* Review Cost and Bid<br />
* Buyout scopes<br />
* Identify contingency vs cash allowance<br />
* Any special agreement or alignment of trades<br />
* Etc.<br />
<br />
<sequencediagram style="modern-blue"><br />
Customer->Estimator: Award Project\nto Synergy<br />
Note over Estimator, Estimate\nTemplate : Reconcile Bids\nOrganize Bid Binder<br />
Estimator->Operation Team: Control Estimate (the Book)<br />
Estimator->Operation Team: Bid Binder<br />
Note over Estimator, Operation Team: Review Bid Strategy, Bids, Schedule\n(Turn Over Meeting)<br />
Note over Estimate\nTemplate, Operation Team:Review Estimate\nClean up Cost Code\nConsolidate Units\nReview Cost<br />
Estimate\nTemplate->Operation Team:Budget .CSV file<br />
Operation Team-> Viewpoint: Upload Budget <br />
</sequencediagram><br />
<br />
Then,<br />
# The entire estimate data after cleanup get poured into Viewpoint using a '''[https://en.wikipedia.org/wiki/Comma-separated_values .CSV file]'''.<br />
# The CSV file is structured specifically in a format Viewpoint can read using Import Estimate Module.<br />
=== Step-by-Step ===<br />
==== Within Estimate Work Book, you will need to do the following ====<br />
===== Step 1: Locate the "Tab" =====<br />
[[File:Budget Upload - Worksheets.png|frame|center|sample estimate workbook]]<br />
# Open the Estimate File received from Estimate Turn Over Meeting<br />
# Locate “Summary” and Division pages, drag and position those sheets to the front of all other sheets.<br />
# Locate “Est To VP” Tab, there are 6 buttons on this tab, each have their own corresponded functions. We will go through them in later pages.<br />
<br />
===== Step 2: Buy Out, Estimate Adjustment =====<br />
# Do your contract buy out.<br />
# During the buy out, modify the estimate file to match the scope that was bought into the trade’s scope.<br />
[[File:Budget Upload - Sample Buyout.png|thumb|sample buyout process]]<br />
# For the example that was shown here, the access panel and a few other scopes were estimated with own forces. During buy out, the drywaller agreed to take on those scopes for an additional cost. The number has been adjusted and moved to Subcontract Cost accordingly.<br />
# During buy out, if agreement were made for trades to take on certain additional scope for no or any cost, modify the estimate file to match the agreements.<br />
# Repeat this for all scopes pertains to the project.<br />
# In case any offsets from original contract value, we can add those after all the buy out to contingency, or book fee – pending on each project case.<br />
<br />
===== Step 3: Pull All Estimate Data To One Page =====<br />
# Locate the button called “Consolidate”. Click on it, will open a dialog allow you to select which page to include on pulling the Estimate Data Over.<br />
[[File:Budget Upload - Consolidation Button.png|thumb|consolidation button]]<br />
# In most cases, all pages from 1 to 16 will be selected.<br />
# However, if only a portion of the budget is getting uploaded, such as a change order, select only the page you want to upload.<br />
<br />
In the "Consolidation" worksheet, we can fine tune the cost codes, units, descriptions.<br />
An example is shown here. This page allows you to [[File:Budget Update - Consolidation.PNG|thumb|sample consolidation page]]<br />
* view which lines share the same cost code<br />
* Group or ungroup the cost lines by cost code<br />
* Adjusting unit of measure, quantities as needed.<br />
* This page does not allow modification to costs per se.<br />
'''Do''' <br />
* A quick check on each Division line and make sure the cost matches.<br />
* Remind yourself that any additional cost located on the summary page will not shown here – such as Insurance and Fee.<br />
'''Don’t'''<br />
* Try to change the format<br />
* Try to change the cost<br />
You can modify the description, unit of measure, quantity of the first line of the duplicated code so that the description make sense in your future forecast. In the example that’s shown, I have changed the description from “Orientation and Labour” to “Safety Equipment, Orientation and Labour” as this code contains both costlines. <br />
[[File:Budget Upload - Consolidation Description Change.png|frame|center]]<br />
The upload result of this example will be<br />
* Quantity of 20 with units of weeks<br />
* 140 hours of labour, $2,720+$5,600 for labour cost<br />
* $7,800 for material cost.<br />
* Repeat this for all cost lines.<br />
You can also combine or separate cost code for costlines. in this example, I have separated the cost code for flooring protection from the flooring subtrade. Doing so allows me to forecast easier during project execution phase. Do this as needed for all cost lines.<br />
<br />
Once you have gone thru all the cost lines, review with CM or OM if required. If you are comfortable with the consolidation and the PM has completed the above checks, you can begin to export to Viewpoint phase<br />
* Locate the “CSV Export” button, a dialog will show to let you save the CSV file generated for this estimate.<br />
* Modify the file name as needed, click “Save”.<br />
* It is recommended saving this file to the project folder, under “4 – Estimating”<br />
<br />
==== Import Estimate ====<br />
===== Do this using Viewpoint Import Estimate Program. =====<br />
Log into Viewpoint, Locate Module “PM Import Estimate” in Project Management – Program folder. Double Click to open the module.<br />
[[File:Budget Upload - Viewpoint Import Estimate Location.png|thumb|Locate Import Estimate Module]]<br />
<br />
This module contains a few different buttons.<br />
* Template Master lists all template that can be used to read the CSV file. We will not be touching this button.<br />
* Import Data lets you import the CSB file that was exported<br />
* Edit Work Tables lets you edit any imported budget table.<br />
* Upload into PM lets you pour the data into PM module, either as Original Estimate or as a Change Order to Existing Estimate.<br />
<br />
Click the Import Data, a window will pop open as the example shows.<br />
[[File:Budget Upload - Import Estimate Button.png|thumb|Import Estimate Button]]<br />
* For template, use SYN, this is the template made for Synergy to read a specific CSV format.<br />
* For “Import File 1:” field, click “Browse” button to the right, and select the CSV file that was exported.<br />
* For “Import ID” field, make a new Import ID, for example, you can use your initial + a number.<br />
* For Default Holdback Percentage, use 10%. <br />
* Click “Import” Button<br />
<br />
Viewpoint will be doing some work, if the project is big, in regards to amount of cost codes, it may take a minute or two. Once the file is imported, Viewpoint will prompt you a Message Box, sometimes it will say there are some errors. These errors are caused by non-standard cost code, or unit of measures that was used during estimating stage, or during consolidation stage.<br />
<br />
Click on the “Edit Work Tables” button, Viewpoint will open up a window, by default it will open the most recent import made by you. We will only be using the “Items”, “Phase”, “Cost Types” tabs.<br />
<br />
Some of the tab name is probably not familiar to you, translation:<br />
* Items – Contract Items, these are the items shows up on your billing. <br />
* Phases – Cost Codes, this tab allows you to adjust how the codes are linked with Contract Items. (you don’t have to change the links, the contract items and their amount are much easier to adjust in Job Cost – JC Contract Master module). <br />
* Cost Types – Cost Types of each cost code. This tab shows, for example the cost allocated in each cost type for each cost code.<br />
<br />
On the contract items tab, you can edit the contract Item descriptions here. I recommend to do it in JC – Contract Master module once the import is completed however.<br />
[[File:Budget Upload - Review Data Table.png|thumb|Review Data Table]]<br />
On the cost code tab, any error will be high lighted with red. Error on this tab typically is caused by the Cost Code does not existing in Master Cost Code list. Select the line with Error, double click the phase field to edit. Click F4 key on your keyboard to call out the cost code look up list, pick an appropriate code from the list. Once the code is picked, you can also add .xx.xx to it to make it more customized. For example, 12010.01. Click “Save” button, or Ctrl+S to save the change. Viewpoint will prompt you a dialog ask if it should create a phase cross reference record, '''make sure to select “NO”'''. If you accidentally clicked yes, let Siyuan know, the cross reference can be deleted from the template.<br />
<br />
Similar procedure for Cost Types tab. Viewpoint has a bug that even if you changed cost code on Phase tab, the Cost Types tab will still show the error (although the cost code is correct). To clear up the error, you will need to double click the cost code and type in the same code again. Similar procedure for Unit of Measure Error as well. Annoying I know, hopefully they fix that in the future. <br />
<br />
Once all errors are cleared up, you can click the “Upload into PM” button. Viewpoint will open a window for this. Defaulted to the most recent Data Table that you edited. In the Project field, put in the project number that this budget is going into. The Start Month – this is the effective month of your budget, not your project schedule start. For example, if you set the start month to 02/21, the budget you upload today will not shown in forecast till the February batch in 2021. Doesn’t matter if you interfaced to December 2020. The red text here is a warning, telling me there are existing cost code and cost ($0 count as well) in the project already. Uploading will have the budget accumulated. If this is the first time budget uploading to this project, it typically because some codes were opened up by accounting for insurance purposes.<br />
<br />
'''Always a good habit to check!!''' Locate in Job Cost – Programs, the JC Original Estimate module. Open it, you will see what's existing in your project, for both cost code, and budget. '''If you already have budget in the project, uploading will accumulate, instead of overwrite.'''<br />
<br />
Another Option is to upload the budget as COQ (Change Order). This is useful for project that budget get approved in phases. PCO type is always COQ. The PCO field, is correspond to Pending Change Order module, pick one that you intent to use. Make a good (consistent) name for your COQ. Starting PCO item field, correspond to the PCO item in Pending Change Order. Typically you want this to start with 1, unless you are adding to an existing PCO. Increment by: '''Typically you want set this to 1'''. I can’t think of anything that would make you to change this to anything else. Note that the each Contract Item will be a new PCO item, when you are adding the budget as a change order.<br />
[[File:Budget Upload - Upload to PM.png|thumb|Import Estimate – Upload to PM]]<br />
Then hit the Upload button. Once the budget uploaded, it will prompt you that the budget is uploaded, and if you want to delete the data table. You can go ahead and delete it. If the data table have errors that’s not cleared up. You will not be able to upload the budget, instead, Viewpoint will prompt you a message box and tell you this. Since I have already uploaded my budget, I will not try to upload again. Just pretend the picture on the left is what you see once clicked the upload button.<br />
<br />
Locate the “Interface” module in Project Management – Program Folder. Double Click to open this program. Hit Validate, then Interface.<br />
[[File:Budget Upload - Add Bond Insurance Fee.png|thumb|Add Bond Insurance Fee]]<br />
Now go back to the Job Cost – Program, open module JC Original Estimate program. Remember that the items entered on the Summary sheet in Estimate Template will not be pulled? This is where we enter those a few items. Bond, Insurance, Fee. <br />
<br />
'''Once all these item added, your project total should matches up the contract amount.'''<br />
<br />
==== Import Estimate – Billing Schedule ====<br />
Locate in Job Cost – Program folder, JC Contract Master module. Double click to open.<br />
[[File:Budget Upload - Billing Schedule.png|thumb|Editing Billing Schedule]]<br />
# Go to your project, then select “Items” tab.<br />
# Adjust the description, add/delete the lines as needed.<br />
# Adjust the $ value in the Orig Amount. <br />
# The total amount should match the contract value.<br />
# Essentially this is the billing structure that accounting will get you to complete every month.<br />
Do:<br />
* Review tender documents and see if certain billing structure is required.<br />
* Check with CM or OM see if there are certain billing structure should be used<br />
* Check with Client and see if they want any particular item broken out<br />
* Double check the total mount of Billing, matches total amount of Estimate, Matches total amount of Contract Value.</div>ASamoilhttps://thewiki.builtplainly.com/index.php?title=Report_and_Others&diff=981Report and Others2022-04-22T22:55:48Z<p>ASamoil: /* Report and Review */</p>
<hr />
<div>[[File:ReportAndReview1.2.0.14New.png|frame|center|link=]]<br />
<br />
= Report and Review =<br />
== General Settings ==<br />
<br />
=== [[Show LBR]] ===<br />
Shows or Hides HD's on the Summary Page<br />
<br />
=== [[Show IND]] ===<br />
Shows or Hides HD's on the Summary Page<br />
<br />
=== [[Freeze Top]] ===<br />
Freezes the Top few lines so they stay with you as you scroll<br />
<br />
=== [[Change Theme]] ===<br />
Changes the Current Workbook Theme<br />
<br />
=== [[Set Page Breaks]] ===<br />
Sets the Page Breaks for the Workbook<br />
<br />
=== [[Set Page Breaks|Set Page]] ===<br />
Sets the Page Break for the Current Worksheet<br />
<br />
== Summary Settings ==<br />
<br />
=== [[Show SD]] ===<br />
Shows or Hides SD's on the Summary Page<br />
<br />
=== [[Show HD]] ===<br />
Shows or Hides HD's on the Summary Page<br />
<br />
=== [[Show Zeros]] ===<br />
Show or Hides Zeros on the Summary Page<br />
<br />
<br />
=== [[Show Bond]] ===<br />
Enables or Disables the Bond Column<br />
<br />
== More ==<br />
<br />
=== [[Scratch Sheet]] ===<br />
Will create a blank worksheet that can be used for anything<br />
<br />
=== [[Approve WS]] ===<br />
Changes the Tab Color of the Worksheet to Green/Approved<br />
<br />
<br />
=== [[Extra Summary Data]] ===<br />
Adds extra lines to the bottom of the Summary Page<br />
<br />
=== [[Re-Calc WB]] ===<br />
Re-Calculates the entire Workbook<br />
<br />
=== [[PrintToPDF]] ===<br />
Prints the Workbook to a Pdf<br />
<br />
== Recap ==<br />
<br />
=== [[Select Material]] ===<br />
Sets the selected material value from the recap section into the Div<br />
<br />
=== [[Select Subtrade]] ===<br />
Sets the selected subtrade value from the recap section into the Div<br />
<br />
=== [[Full Recap]] ===<br />
Hides Div Cols and Shows Recap Section simutanously<br />
<br />
=== [[Hide Div Cols]] ===<br />
Hides all unnecessary Div Cols for Recap <br />
<br />
=== [[Show Recap]] ===<br />
Shows/Hides the Recap Section<br />
<br />
== Budget Summary Options ==<br />
<br />
=== [[Budget Sheet]] ===<br />
Creates a budget sheet between two different workbooks (the current one and another one)<br />
<br />
=== [[Show SD Budget]] ===<br />
Shows or hides all SD lines on the Budget Sheet<br />
<br />
=== [[Show Zeros Budget]] ===<br />
Shows or hides all Zeros lines on the Budget Sheet<br />
<br />
=== [[Show HD Budget]] ===<br />
Shows or hides all HD lines on the Budget Sheet</div>ASamoilhttps://thewiki.builtplainly.com/index.php?title=Report_and_Others&diff=980Report and Others2022-04-22T21:41:40Z<p>ASamoil: /* General Settings */</p>
<hr />
<div>[[File:ReportAndReview1.2.0.14New.png|frame|center|link=]]<br />
<br />
= Report and Review =<br />
== General Settings ==<br />
<br />
=== [[Show LBR]] ===<br />
Shows or Hides HD's on the Summary Page<br />
<br />
=== [[Show IND]] ===<br />
Shows or Hides HD's on the Summary Page<br />
<br />
=== [[Show SD]] ===<br />
Shows or Hides SD's on the Summary Page<br />
<br />
=== [[Show HD]] ===<br />
Shows or Hides HD's on the Summary Page<br />
<br />
=== [[Show Bond]] ===<br />
Enables or Disables the Bond Column<br />
<br />
== More ==<br />
<br />
=== [[Scratch Sheet]] ===<br />
Will create a blank worksheet that can be used for anything<br />
<br />
=== [[Approve WS]] ===<br />
Changes the Tab Color of the Worksheet to Green/Approved<br />
<br />
=== [[Freeze Top]] ===<br />
Freezes the Top few lines so they stay with you as you scroll<br />
<br />
=== [[Extra Summary Data]] ===<br />
Adds extra lines to the bottom of the Summary Page<br />
<br />
=== [[Change Theme]] ===<br />
Changes the Current Workbook Theme<br />
<br />
=== [[Re-Calc WB]] ===<br />
Re-Calculates the entire Workbook<br />
<br />
=== [[Set Page Breaks]] ===<br />
Sets the Page Breaks for the Workbook<br />
<br />
=== [[Set Page Breaks|Set Page]] ===<br />
Sets the Page Break for the Current Worksheet<br />
<br />
=== [[PrintToPDF]] ===<br />
Prints the Workbook to a Pdf<br />
<br />
== Recap ==<br />
<br />
=== [[Select Material]] ===<br />
Sets the selected material value from the recap section into the Div<br />
<br />
=== [[Select Subtrade]] ===<br />
Sets the selected subtrade value from the recap section into the Div<br />
<br />
=== [[Full Recap]] ===<br />
Hides Div Cols and Shows Recap Section simutanously<br />
<br />
=== [[Hide Div Cols]] ===<br />
Hides all unnecessary Div Cols for Recap <br />
<br />
=== [[Show Recap]] ===<br />
Shows/Hides the Recap Section<br />
<br />
== Budget Summary Options ==<br />
<br />
=== [[Budget Sheet]] ===<br />
Creates a budget sheet between two different workbooks (the current one and another one)<br />
<br />
=== [[Show SD Budget]] ===<br />
Shows or hides all SD lines on the Budget Sheet<br />
<br />
=== [[Show Zeros Budget]] ===<br />
Shows or hides all Zeros lines on the Budget Sheet<br />
<br />
=== [[Show HD Budget]] ===<br />
Shows or hides all HD lines on the Budget Sheet</div>ASamoilhttps://thewiki.builtplainly.com/index.php?title=Report_and_Others&diff=979Report and Others2022-04-22T21:40:55Z<p>ASamoil: /* Others */</p>
<hr />
<div>[[File:ReportAndReview1.2.0.14New.png|frame|center|link=]]<br />
<br />
= Report and Review =<br />
== General Settings ==<br />
<br />
=== [[Show SD]] ===<br />
Shows or Hides SD's on the Summary Page<br />
<br />
=== [[Show HD]] ===<br />
Shows or Hides HD's on the Summary Page<br />
<br />
=== [[Show IND]] ===<br />
Shows or Hides HD's on the Summary Page<br />
<br />
=== [[Show LBR]] ===<br />
Shows or Hides HD's on the Summary Page<br />
<br />
=== [[Show Bond]] ===<br />
Enables or Disables the Bond Column<br />
<br />
== More ==<br />
<br />
=== [[Scratch Sheet]] ===<br />
Will create a blank worksheet that can be used for anything<br />
<br />
=== [[Approve WS]] ===<br />
Changes the Tab Color of the Worksheet to Green/Approved<br />
<br />
=== [[Freeze Top]] ===<br />
Freezes the Top few lines so they stay with you as you scroll<br />
<br />
=== [[Extra Summary Data]] ===<br />
Adds extra lines to the bottom of the Summary Page<br />
<br />
=== [[Change Theme]] ===<br />
Changes the Current Workbook Theme<br />
<br />
=== [[Re-Calc WB]] ===<br />
Re-Calculates the entire Workbook<br />
<br />
=== [[Set Page Breaks]] ===<br />
Sets the Page Breaks for the Workbook<br />
<br />
=== [[Set Page Breaks|Set Page]] ===<br />
Sets the Page Break for the Current Worksheet<br />
<br />
=== [[PrintToPDF]] ===<br />
Prints the Workbook to a Pdf<br />
<br />
== Recap ==<br />
<br />
=== [[Select Material]] ===<br />
Sets the selected material value from the recap section into the Div<br />
<br />
=== [[Select Subtrade]] ===<br />
Sets the selected subtrade value from the recap section into the Div<br />
<br />
=== [[Full Recap]] ===<br />
Hides Div Cols and Shows Recap Section simutanously<br />
<br />
=== [[Hide Div Cols]] ===<br />
Hides all unnecessary Div Cols for Recap <br />
<br />
=== [[Show Recap]] ===<br />
Shows/Hides the Recap Section<br />
<br />
== Budget Summary Options ==<br />
<br />
=== [[Budget Sheet]] ===<br />
Creates a budget sheet between two different workbooks (the current one and another one)<br />
<br />
=== [[Show SD Budget]] ===<br />
Shows or hides all SD lines on the Budget Sheet<br />
<br />
=== [[Show Zeros Budget]] ===<br />
Shows or hides all Zeros lines on the Budget Sheet<br />
<br />
=== [[Show HD Budget]] ===<br />
Shows or hides all HD lines on the Budget Sheet</div>ASamoilhttps://thewiki.builtplainly.com/index.php?title=Report_and_Others&diff=978Report and Others2022-04-22T21:40:36Z<p>ASamoil: </p>
<hr />
<div>[[File:ReportAndReview1.2.0.14New.png|frame|center|link=]]<br />
<br />
= Report and Review =<br />
== Others ==<br />
<br />
=== [[Show SD]] ===<br />
Shows or Hides SD's on the Summary Page<br />
<br />
=== [[Show HD]] ===<br />
Shows or Hides HD's on the Summary Page<br />
<br />
=== [[Show IND]] ===<br />
Shows or Hides HD's on the Summary Page<br />
<br />
=== [[Show LBR]] ===<br />
Shows or Hides HD's on the Summary Page<br />
<br />
=== [[Show Bond]] ===<br />
Enables or Disables the Bond Column<br />
<br />
== More ==<br />
<br />
=== [[Scratch Sheet]] ===<br />
Will create a blank worksheet that can be used for anything<br />
<br />
=== [[Approve WS]] ===<br />
Changes the Tab Color of the Worksheet to Green/Approved<br />
<br />
=== [[Freeze Top]] ===<br />
Freezes the Top few lines so they stay with you as you scroll<br />
<br />
=== [[Extra Summary Data]] ===<br />
Adds extra lines to the bottom of the Summary Page<br />
<br />
=== [[Change Theme]] ===<br />
Changes the Current Workbook Theme<br />
<br />
=== [[Re-Calc WB]] ===<br />
Re-Calculates the entire Workbook<br />
<br />
=== [[Set Page Breaks]] ===<br />
Sets the Page Breaks for the Workbook<br />
<br />
=== [[Set Page Breaks|Set Page]] ===<br />
Sets the Page Break for the Current Worksheet<br />
<br />
=== [[PrintToPDF]] ===<br />
Prints the Workbook to a Pdf<br />
<br />
== Recap ==<br />
<br />
=== [[Select Material]] ===<br />
Sets the selected material value from the recap section into the Div<br />
<br />
=== [[Select Subtrade]] ===<br />
Sets the selected subtrade value from the recap section into the Div<br />
<br />
=== [[Full Recap]] ===<br />
Hides Div Cols and Shows Recap Section simutanously<br />
<br />
=== [[Hide Div Cols]] ===<br />
Hides all unnecessary Div Cols for Recap <br />
<br />
=== [[Show Recap]] ===<br />
Shows/Hides the Recap Section<br />
<br />
== Budget Summary Options ==<br />
<br />
=== [[Budget Sheet]] ===<br />
Creates a budget sheet between two different workbooks (the current one and another one)<br />
<br />
=== [[Show SD Budget]] ===<br />
Shows or hides all SD lines on the Budget Sheet<br />
<br />
=== [[Show Zeros Budget]] ===<br />
Shows or hides all Zeros lines on the Budget Sheet<br />
<br />
=== [[Show HD Budget]] ===<br />
Shows or hides all HD lines on the Budget Sheet</div>ASamoilhttps://thewiki.builtplainly.com/index.php?title=Hide_Div_Cols&diff=976Hide Div Cols2022-04-22T21:38:58Z<p>ASamoil: </p>
<hr />
<div>This button will Hide and Show the non-needed Recap Cols on each Div.<br />
<br />
This process is automatically done with the Full Recap button<br />
<br />
<br />
<br />
[[File:HideDivColsGIF.gif|frame|center|link=]]</div>ASamoilhttps://thewiki.builtplainly.com/index.php?title=Hide_Div_Cols&diff=975Hide Div Cols2022-04-22T21:38:41Z<p>ASamoil: </p>
<hr />
<div>This button will Hide and Show the non-needed Recap Cols on each Div.<br />
<br />
This process is automatically done with the Full Recap button<br />
<br />
<br />
<br />
[[File:HideDivColsGIF.gif|thumb|center|link=]]</div>ASamoilhttps://thewiki.builtplainly.com/index.php?title=File:HideDivColsGIF.gif&diff=974File:HideDivColsGIF.gif2022-04-22T21:38:34Z<p>ASamoil: </p>
<hr />
<div>HideDivColsGIF</div>ASamoilhttps://thewiki.builtplainly.com/index.php?title=Show_Recap&diff=973Show Recap2022-04-22T21:33:36Z<p>ASamoil: </p>
<hr />
<div>This button will Hide and Show the Recap Section on each Div.<br />
<br />
This process is automatically done with the Full Recap button<br />
<br />
<br />
<br />
[[File:ShowRecapGIF.gif|frame|center|link=]]</div>ASamoilhttps://thewiki.builtplainly.com/index.php?title=Show_Recap&diff=972Show Recap2022-04-22T21:33:13Z<p>ASamoil: Created page with "This button will Hide and Show the Recap Section on each Div. This process is automatically done with the Full Recap button link="</p>
<hr />
<div>This button will Hide and Show the Recap Section on each Div.<br />
<br />
This process is automatically done with the Full Recap button<br />
<br />
<br />
<br />
[[File:ShowRecapGIF.gif|center|link=]]</div>ASamoilhttps://thewiki.builtplainly.com/index.php?title=Hide_Div_Cols&diff=971Hide Div Cols2022-04-22T21:32:18Z<p>ASamoil: Created page with "This button will Hide link="</p>
<hr />
<div>This button will Hide <br />
<br />
<br />
<br />
[[File:ShowRecapGIF.gif|center|link=]]</div>ASamoilhttps://thewiki.builtplainly.com/index.php?title=File:ShowRecapGIF.gif&diff=970File:ShowRecapGIF.gif2022-04-22T21:29:16Z<p>ASamoil: </p>
<hr />
<div>ShowRecapGIF</div>ASamoilhttps://thewiki.builtplainly.com/index.php?title=Full_Recap&diff=969Full Recap2022-04-22T21:20:43Z<p>ASamoil: Created page with "This button will Show the Recap section, hide Some of the Division Columns and freeze the WS. link="</p>
<hr />
<div>This button will Show the Recap section, hide Some of the Division Columns and freeze the WS.<br />
<br />
<br />
[[File:FullRecapGIF.gif|center|link=]]</div>ASamoilhttps://thewiki.builtplainly.com/index.php?title=File:FullRecapGIF.gif&diff=968File:FullRecapGIF.gif2022-04-22T21:20:37Z<p>ASamoil: </p>
<hr />
<div>FullRecapGIF</div>ASamoilhttps://thewiki.builtplainly.com/index.php?title=Select_Subtrade&diff=967Select Subtrade2022-04-22T21:05:37Z<p>ASamoil: Created page with "This button will select a value (number) from the Recap Area and input the number into the current Div. The selected number will remain highlighted until it is replaced by an..."</p>
<hr />
<div>This button will select a value (number) from the Recap Area and input the number into the current Div.<br />
<br />
The selected number will remain highlighted until it is replaced by another number.<br />
<br />
<br />
<br />
[[File:SelectSubtradeGIF.gif|center|link=]]</div>ASamoilhttps://thewiki.builtplainly.com/index.php?title=File:SelectSubtradeGIF.gif&diff=966File:SelectSubtradeGIF.gif2022-04-22T21:05:30Z<p>ASamoil: </p>
<hr />
<div>SelectSubtradeGIF</div>ASamoilhttps://thewiki.builtplainly.com/index.php?title=Select_Material&diff=965Select Material2022-04-22T20:58:26Z<p>ASamoil: Created page with "This button will select a value (number) from the Recap Area and input the number into the current Div. The selected number will remain highlighted until it is replaced by an..."</p>
<hr />
<div>This button will select a value (number) from the Recap Area and input the number into the current Div.<br />
<br />
The selected number will remain highlighted until it is replaced by another number.<br />
<br />
<br />
<br />
[[File:SelectMaterialGIF.gif|center|link=]]</div>ASamoilhttps://thewiki.builtplainly.com/index.php?title=File:SelectMaterialGIF.gif&diff=964File:SelectMaterialGIF.gif2022-04-22T20:58:16Z<p>ASamoil: </p>
<hr />
<div>SelectMaterialGIF</div>ASamoil