SynWiki - User contributions [en]

Timecard - Submitting

2023-08-17T16:06:51Z

Carsen der:

The timecard is a useful way for employees to track their hours. This provides useful insight into where time is spent and how efficiency could be increased.

After requesting a timecard or at 3pm, a robot named "Power Automate" will send you a timecard via teams. To view the timecard, navigate to the chat tab on the left side of the MS Teams window and press "Power Automate".

[[File:Timecard - Submitting - Chat tab gif.gif|center|frame]]

The timecard will look like this:
[[File:Timecard - Submitting - Timecard photo.png|center|thumb|580x580px]]
You must select the date and enter the estimate number. The cost plan number must match the cost plan number entered into the estimate book tender evaluation.

You may then fill in the number of hours for each activity and press submit. If you plan to submit another timesheet, that option may also be selected.

== Important Notes ==

* The estimate number must be in the exact format "20XX - XXX" with the space before and after the dash. Else there will be an error.
* There must be an estimate book created for the project of the timesheet ''before'' the timesheet is submitted.
* Only one timesheet may be submitted per project per day. If you submit a second one, it will overwrite the first. Each day, submit one timesheet per project.
* If filling out the timesheet at 3pm, estimate the remaining hours of the day.

[[Category:Timecard]]
[[Category:Estimating]]

Converting PDF to Excel

2023-07-24T19:20:10Z

Carsen der:

oConverting a PDF file to an Excel file is very useful for entering data.

Firstly, the PDF file should be exported as a PNG. With the PDF open in Adobe Acrobat, click on file, the hover over "Export To" → "Image" → "PNG" and click.
[[File:Converting PDF to Excel - PDF to PNG gif.gif|center|thumb|1018x1018px]]A location for saving may be selected. Please note that it creates a separate PNG file for each page in the PDF so an empty folder should be created before this step.

Next, open a blank Excel file. Click on the "Page Layout" button in the bottom right.
[[File:Converting PDF to Excel - Page Layout Excel Screenshot.png|center|thumb|1045x1045px]]
Now, enter the header and press "Picture" in the "Header and Footer" tab. Click "From a file" and navigate to where the PNG photos are stored. Click the first page and click "Open"
[[File:Converting PDF to Excel - Inserting Header Picture gif.gif|center|thumb|1041x1041px]]
[[File:Convert PDF to Excel - Page Orientation Screenshot .png|thumb|543x543px]]

Next, click "Format Picture", set the height to 70% and click "Ok". When you click out of the header, the image should appear. You may change the page orientation to "Portrait" in the "Page Layout" tab as well. Should you prefer this, the height of the picture should be set to 90%. To adjust the height of the picture again, click back into the (now invisible) header and click "Format Picture".
[[File:Converting PDF to Excel - Formatting Header Picture gif.gif|center|thumb|1042x1042px]]IMPORTANT: After each page is added, add a piece of text somewhere on the page and colour it white. Excel will not print the page if there is no text. This text is best placed in the top left corner.
[[File:Convert PDF to Excel - Placing Text Gif.gif|center|thumb|1039x1039px]]
The final step is to align the Excel box with the lines on the picture. This can be done by changing the size of the cells on the left side and top of the window.
[[File:Convert PDF to Excel - Changing Cell Size gif.gif|center|thumb|1038x1038px]]
Now, these steps can be repeated for each page that needs to be added. Make a new worksheet for each new page. To print to PDF, click "File", "Save as Adobe PDF" and save the entire workbook. Click "Convert to PDF" and save to a location.
[[File:Convert PDF to Excel - Saving as PDF gif.gif|center|thumb|1024x1024px]]

Converting PDF to Excel

2023-07-24T18:30:15Z

Carsen der:

oConverting a PDF file to an Excel file is very useful for entering data.

Firstly, the PDF file should be exported as a PNG. With the PDF open in Adobe Acrobat, click on file, the hover over "Export To" → "Image" → "PNG" and click.
[[File:Converting PDF to Excel - PDF to PNG gif.gif|center|thumb|1018x1018px]]A location for saving may be selected. Please note that it creates a separate PNG file for each page in the PDF so an empty folder should be created before this step.

Next, open a blank Excel file. Click on the "Page Layout" button in the bottom right.
[[File:Converting PDF to Excel - Page Layout Excel Screenshot.png|center|thumb|1045x1045px]]
Now, enter the header and press "Picture" in the "Header and Footer" tab. Click "From a file" and navigate to where the PNG photos are stored. Click the first page and click "Open"
[[File:Converting PDF to Excel - Inserting Header Picture gif.gif|center|thumb|1041x1041px]]
[[File:Convert PDF to Excel - Page Orientation Screenshot .png|thumb|543x543px]]

Next, click "Format Picture", set the height to 70% and click "Ok". When you click out of the header, the image should appear. You may change the page orientation to "Portrait" in the "Page Layout" tab as well. Should you prefer this, the height of the picture should be set to 90%. To adjust the height of the picture again, click back into the (now invisible) header and click "Format Picture".
[[File:Converting PDF to Excel - Formatting Header Picture gif.gif|center|thumb|1042x1042px]]IMPORTANT: After each page is added, add a piece of text somewhere on the page and colour it white. Excel will not print the page if there is no text. This text is best placed in the top left corner.
[[File:Convert PDF to Excel - Placing Text Gif.gif|center|thumb|1039x1039px]]
The final step is to align the Excel box with the lines on the picture. This can be done by changing the size of the cells of the left side and top of the window.
[[File:Convert PDF to Excel - Changing Cell Size gif.gif|center|thumb|1038x1038px]]
Now, these steps can be repeated for each page that needs to be added. Make a new worksheet for each new page. To print to PDF, click "File", "Save as Adobe PDF" and save the entire workbook. Click "Convert to PDF" and save to a location.
[[File:Convert PDF to Excel - Saving as PDF gif.gif|center|thumb|1024x1024px]]

File:Convert PDF to Excel - Saving as PDF gif.gif

2023-07-24T18:28:42Z

Carsen der:

Convert PDF to Excel - Saving as PDF gif

File:Convert PDF to Excel - Changing Cell Size gif.gif

2023-07-24T18:15:58Z

Carsen der:

Convert PDF to Excel - Changing Cell Size gif

File:Convert PDF to Excel - Placing Text Gif.gif

2023-07-24T18:10:43Z

Carsen der:

Convert PDF to Excel - Placing Text Gif

File:Convert PDF to Excel - Page Orientation Screenshot .png

2023-07-24T18:04:33Z

Carsen der:

Convert PDF to Excel - Page Orientation Screenshot

Converting PDF to Excel

2023-07-24T17:49:38Z

Carsen der:

Converting a PDF file to an Excel file is very useful for entering data.

Firstly, the PDF file should be exported as a PNG. With the PDF open in Adobe Acrobat, click on file, the hover over "Export To" → "Image" → "PNG" and click.
[[File:Converting PDF to Excel - PDF to PNG gif.gif|center|thumb|1018x1018px]]A location for saving may be selected. Please note that it creates a separate PNG file for each page in the PDF so an empty folder should be created before this step.

Next, open a blank Excel file. Click on the "Page Layout" button in the bottom right.
[[File:Converting PDF to Excel - Page Layout Excel Screenshot.png|center|thumb|1045x1045px]]
Now, enter the header and press "Picture" in the "Header and Footer" tab. Click "From a file" and navigate to where the PNG photos are stored. Click the first page and click "Open"
[[File:Converting PDF to Excel - Inserting Header Picture gif.gif|center|thumb|1041x1041px]]
Next, click "Format Picture", set the height to 70% and click "Ok". When you click out of the header, the image should appear.
[[File:Converting PDF to Excel - Formatting Header Picture gif.gif|center|thumb|1042x1042px]]

File:Converting PDF to Excel - Formatting Header Picture gif.gif

2023-07-24T17:48:43Z

Carsen der:

Converting PDF to Excel - Formatting Header Picture gif

File:Converting PDF to Excel - Inserting Header Picture gif.gif

2023-07-24T17:40:16Z

Carsen der:

Converting PDF to Excel - Inserting Header Picture gif

File:Converting PDF to Excel - Page Layout Excel Screenshot.png

2023-07-24T17:26:22Z

Carsen der:

Converting PDF to Excel - Page Layout Excel Screenshot

Converting PDF to Excel

2023-07-24T15:58:31Z

Carsen der:

Converting PDF to Excel

2023-07-24T15:09:34Z

Carsen der:

File:Converting PDF to Excel - PDF to PNG gif.gif

2023-07-24T15:08:01Z

Carsen der:

Converting PDF to Excel - PDF to PNG gif

Converting PDF to Excel

2023-07-24T14:49:46Z

Carsen der: Created page with "Converting a PDF file to an Excel file is very useful for entering data."

Converting a PDF file to an Excel file is very useful for entering data.

List of Content

2023-07-24T14:45:09Z

Carsen der:

<blockquote><big>'''''“Rocks in my path? I keep them all.'''''</big>

<big>'''''With them I shall build my castle.”'''''</big>

'''<big>''– Nemo Nox''</big>'''</blockquote>

==Project Management Items (what is/how to) ==

=== Viewpoint Fundamentals===

*[[Introduction to Viewpoint]]
*[[Cost Item vs Cost Code]]
*[[Viewpoint Quick Reference]]
*[[Viewpoint Terminology]]
*[[Viewpoint Report Module]]

===Operation / PM Duty Items ===
*[[Budget Upload]]
*[[Subcontract Management]]
**[[Generating Subcontract Using Template]]
**[[Sending Subcontract using DocuSign]]
*[[Project Change Management]]
*[[Document Controls]]
**[[Document Controls#RFI management|RFI management]]
**[[Document Controls#Submittal Management|Submittal management]]
*[[Project Cost and Forecast|Project Cost and Forecast - Pending Decision on Future PM software suite]]
*[[Cash Flow Projection]]
**[[Using Provided Template to Set Up Cash Flow Projection]]
*[[Viewpoint Reports]]
**Change Order Log
**Submittal and RFI log
**JC Cost Totals Drilldown
**Project Cost and Forecast
*[[Project Close Out]]
*<del>[[Creating Projection Codes]]</del>
*<del>[[How to Complete a Cost Forecast using PM Cost Projections|Forecasting with PM Cost Projections]]</del>
*[[Finance Calendar]]

===Sequence Diagram for Typical Processes===

*[[Development and Building Permits]]
*[[Demo Permit Process]]
*[[How to: Get Utility - Gas]]
*[[How to: Get Utility - Water]]
*[[How to: Get Utility - Power]]
*[[Project Close Out Process]]
---------------------

==Estimating Items (what is/how to)==

=== SGC Submission Review Procedures ===

* [[SGC Submission Review Procedures]]

=== Converting PDF to Excel ===

* [[Converting PDF to Excel]]

===Estimate 2.0 (Software) ===
*[[Download Tutorial]]
*[[Tutorial]]
*[[General Help Manual]]
*[[How-to: Quick Guide]]
*[[FAQ]]

===Estimating Timecard===
*[[Timecard - Initial Setup|Initial Setup]]
*[[Timecard - Requesting|Requesting a Timecard]]
*[[Timecard - Submitting|Submitting a Timecard]]
*[[Timecard - Report|Viewing the Timecard Report]]

---------------------

==Business Technology==
*[[Amer page here]]
===<s>TimeLapse (obsolete)</s> ===
*[[Set-up Tutorial | <s>TimeLapse Set-up Tutorial</s>]]
===Power BI===
*[[Power BI|Power BI Summary]]
*[[Columns and Measures]]
*[[Power BI - Visualizations|Visualizations]]
*[[Power BI - Other Features|Other Features]]

---------------------

[[Category:List Of Content]]

SGC Submission Review Procedures

2023-07-19T19:47:38Z

Carsen der:

[[File:SGS Submission Review Process.png|center|thumb|1428x1428px]]

√*optional Denotes that this individual is to be made aware of any submisison (through MMM, direct contact, etc) and will decide on what level of review is required and who is to be included in the review

In any instance, the chief estimator or designate is to properly inform the optional persons of the project and determine the level of review.

File:SGS Submission Review Process.png

2023-07-19T19:47:25Z

Carsen der:

SGS Submission Review Process

SGC Submission Review Procedures

2023-07-19T19:43:46Z

Carsen der:

{| class="wikitable"
| colspan="12" rowspan="2" |'''SGC Submission Review Procedures'''
|-
|-
| colspan="12" |All submissions are to be reviews as per the table outlined below
|-
| rowspan="2" |
|
| colspan="5" |'''Submissions (New & Existing Projects)'''

'''With Commercial Terms (hard bid, RFP or negotiated)'''
| colspan="5" |'''Budget Submissions (New & Existing Projects)'''

'''Without Commerical Terms'''
|-
|'''Value in Millions'''
|0-1
|1-5
|6-15
|15-30
|>30
|0-1
|1-5
|6-15
|15-30
|>30
|-
|
|
|
|
|
|
|
|
|
|
|
|
|-
| rowspan="6" |'''Estimate Reviews'''
|'''Lead Estimator'''
|√
|√
|√
|√
|√
|√
|√
|√
|√
|√
|-
|'''Chief Estimator (or designate)'''
|√*optional
|√
|√
|√
|√
|√*optional
|√*optional
|√
|√
|√
|-
|'''Project Lead (Project Development Manager/Construction manager) - if applicable'''
|√
|√
|√
|√
|√
|√
|√
|√
|√
|
|-
|'''Operations Manager'''
|
|√*optional
|√
|√
|√
|
|
|√*optional
|√
|√
|-
|'''Business Unit President'''
|
|
|√*optional
|√
|√
|
|
|
|√*optional
|√
|-
|'''COO'''
|
|
|
|√*optional
|√
|
|
|
|
|√*optional
|-
|
|
|
|
|
|
|
|
|
|
|
|
|-
| rowspan="6" |'''Fee Reviews'''
|'''Chief Estimator (or designate)'''
|√
|√
|√
|√
|√
|
|
|√
|√
|√
|-
|'''Project Lead (Project Development Manager/Construction manager) - if applicable'''
|√
|√
|√
|√
|√
|
|√
|√
|√
|√
|-
|'''Operations Manager'''
|
|√
|√
|√
|√
|
|
|√
|√
|√
|-
|'''Business Unit President'''
|
|√*optional
|√
|√
|√
|
|
|√*optional
|√
|√
|-
|'''COO'''
|
|
|√* Optional
|√
|√
|
|
|
|√*optional
|√
|-
|'''SGC President'''
|
|
|
|√*Optional
|√
|
|
|
|
|√*optional
|}

√*optional Denotes that this individual is to be made aware of any submisison (through MMM, direct contact, etc) and will decide on what level of review is required and who is to be included in the review

In any instance, the chief estimator or designate is to properly inform the optional persons of the project and determine the level of review.

SGC Submission Review Procedures

2023-07-19T19:41:26Z

Carsen der:

{| class="wikitable"
| colspan="12" rowspan="2" |SGC Submission Review Procedures
|-
|-
|All submissions are to be reviews as per the table outlined below
|
|
|
|
|
|
|
|
|
|
|
|-
|
|
|Submissions (New & Existing Projects)
With Commercial Terms (hard bid, RFP or negotiated)
|
|
|
|
|Budget Submissions (New & Existing Projects)
Without Commerical Terms
|
|
|
|
|-
|
|Value in Millions
|0-1
|1-5
|6-15
|15-30
|>30
|0-1
|1-5
|6-15
|15-30
|>30
|-
|
|
|
|
|
|
|
|
|
|
|
|
|-
| rowspan="6" |Estimate Reviews
|Lead Estimator
|√
|√
|√
|√
|√
|√
|√
|√
|√
|√
|-
|Chief Estimator (or designate)
|√*optional
|√
|√
|√
|√
|√*optional
|√*optional
|√
|√
|√
|-
|Project Lead (Project Development Manager/Construction manager) - if applicable
|√
|√
|√
|√
|√
|√
|√
|√
|√
|
|-
|Operations Manager
|
|√*optional
|√
|√
|√
|
|
|√*optional
|√
|√
|-
|Business Unit President
|
|
|√*optional
|√
|√
|
|
|
|√*optional
|√
|-
|COO
|
|
|
|√*optional
|√
|
|
|
|
|√*optional
|-
|
|
|
|
|
|
|
|
|
|
|
|
|-
| rowspan="6" |Fee Reviews
|Chief Estimator (or designate)
|√
|√
|√
|√
|√
|
|
|√
|√
|√
|-
|Project Lead (Project Development Manager/Construction manager) - if applicable
|√
|√
|√
|√
|√
|
|√
|√
|√
|√
|-
|Operations Manager
|
|√
|√
|√
|√
|
|
|√
|√
|√
|-
|Business Unit President
|
|√*optional
|√
|√
|√
|
|
|√*optional
|√
|√
|-
|COO
|
|
|√* Optional
|√
|√
|
|
|
|√*optional
|√
|-
|SGC President
|
|
|
|√*Optional
|√
|
|
|
|
|√*optional
|}
√*optional Denotes that this individual is to be made aware of any submisison (through MMM, direct contact, etc) and will decide on what level of review is required and who is to be included in the review

In any instance, the chief estimator or designate is to properly inform the optional persons of the project and determine the level of review.

List of Content

2023-07-19T19:39:17Z

Carsen der: /* Estimate 2.0 (Software) */

<blockquote><big>'''''“Rocks in my path? I keep them all.'''''</big>

<big>'''''With them I shall build my castle.”'''''</big>

'''<big>''– Nemo Nox''</big>'''</blockquote>

==Project Management Items (what is/how to) ==

=== Viewpoint Fundamentals===

*[[Introduction to Viewpoint]]
*[[Cost Item vs Cost Code]]
*[[Viewpoint Quick Reference]]
*[[Viewpoint Terminology]]
*[[Viewpoint Report Module]]

===Operation / PM Duty Items ===
*[[Budget Upload]]
*[[Subcontract Management]]
**[[Generating Subcontract Using Template]]
**[[Sending Subcontract using DocuSign]]
*[[Project Change Management]]
*[[Document Controls]]
**[[Document Controls#RFI management|RFI management]]
**[[Document Controls#Submittal Management|Submittal management]]
*[[Project Cost and Forecast|Project Cost and Forecast - Pending Decision on Future PM software suite]]
*[[Cash Flow Projection]]
**[[Using Provided Template to Set Up Cash Flow Projection]]
*[[Viewpoint Reports]]
**Change Order Log
**Submittal and RFI log
**JC Cost Totals Drilldown
**Project Cost and Forecast
*[[Project Close Out]]
*<del>[[Creating Projection Codes]]</del>
*<del>[[How to Complete a Cost Forecast using PM Cost Projections|Forecasting with PM Cost Projections]]</del>
*[[Finance Calendar]]

===Sequence Diagram for Typical Processes===

*[[Development and Building Permits]]
*[[Demo Permit Process]]
*[[How to: Get Utility - Gas]]
*[[How to: Get Utility - Water]]
*[[How to: Get Utility - Power]]
*[[Project Close Out Process]]
---------------------

==Estimating Items (what is/how to)==

=== SGC Submission Review Procedures ===

* [[SGC Submission Review Procedures]]

===Estimate 2.0 (Software) ===
*[[Download Tutorial]]
*[[Tutorial]]
*[[General Help Manual]]
*[[How-to: Quick Guide]]
*[[FAQ]]

===Estimating Timecard===
*[[Timecard - Initial Setup|Initial Setup]]
*[[Timecard - Requesting|Requesting a Timecard]]
*[[Timecard - Submitting|Submitting a Timecard]]
*[[Timecard - Report|Viewing the Timecard Report]]

---------------------

==Business Technology==
*[[Amer page here]]
===<s>TimeLapse (obsolete)</s> ===
*[[Set-up Tutorial | <s>TimeLapse Set-up Tutorial</s>]]
===Power BI===
*[[Power BI|Power BI Summary]]
*[[Columns and Measures]]
*[[Power BI - Visualizations|Visualizations]]
*[[Power BI - Other Features|Other Features]]

---------------------

[[Category:List Of Content]]

SGC Submission Review Procedures

2023-07-19T19:37:13Z

Carsen der:

{| class="wikitable"
| colspan="12" rowspan="2" |SGC Submission Review Procedures
|-
|-
| colspan="2" |All submissions are to be reviews as per the table outlined below
|
|
|
|
|
|
|
|
|
|
|-
| rowspan="2" |
|
| colspan="5" |Submissions (New & Existing Projects)
With Commercial Terms (hard bid, RFP or negotiated)
| colspan="5" |Budget Submissions (New & Existing Projects)
Without Commerical Terms
|-
|Value in Millions
|0-1
|1-5
|6-15
|15-30
|>30
|0-1
|1-5
|6-15
|15-30
|>30
|-
|
|
|
|
|
|
|
|
|
|
|
|
|-
| rowspan="6" |Estimate Reviews
|Lead Estimator
|√
|√
|√
|√
|√
|√
|√
|√
|√
|√
|-
|Chief Estimator (or designate)
|√*optional
|√
|√
|√
|√
|√*optional
|√*optional
|√
|√
|√
|-
|Project Lead (Project Development Manager/Construction manager) - if applicable
|√
|√
|√
|√
|√
|√
|√
|√
|√
|
|-
|Operations Manager
|
|√*optional
|√
|√
|√
|
|
|√*optional
|√
|√
|-
|Business Unit President
|
|
|√*optional
|√
|√
|
|
|
|√*optional
|√
|-
|COO
|
|
|
|√*optional
|√
|
|
|
|
|√*optional
|-
|
|
|
|
|
|
|
|
|
|
|
|
|-
| rowspan="6" |Fee Reviews
|Chief Estimator (or designate)
|√
|√
|√
|√
|√
|
|
|√
|√
|√
|-
|Project Lead (Project Development Manager/Construction manager) - if applicable
|√
|√
|√
|√
|√
|
|√
|√
|√
|√
|-
|Operations Manager
|
|√
|√
|√
|√
|
|
|√
|√
|√
|-
|Business Unit President
|
|√*optional
|√
|√
|√
|
|
|√*optional
|√
|√
|-
|COO
|
|
|√* Optional
|√
|√
|
|
|
|√*optional
|√
|-
|SGC President
|
|
|
|√*Optional
|√
|
|
|
|
|√*optional
|}
√*optional Denotes that this individual is to be made aware of any submisison (through MMM, direct contact, etc) and will decide on what level of review is required and who is to be included in the review

In any instance, the chief estimator or designate is to properly inform the optional persons of the project and determine the level of review.

SGC Submission Review Procedures

2023-07-19T19:36:52Z

Carsen der:

{|
| colspan="12" rowspan="2" |SGC Submission Review Procedures
|-
|-
| colspan="2" |All submissions are to be reviews as per the table outlined below
|
|
|
|
|
|
|
|
|
|
|-
| rowspan="2" |
|
| colspan="5" |Submissions (New & Existing Projects)
With Commercial Terms (hard bid, RFP or negotiated)
| colspan="5" |Budget Submissions (New & Existing Projects)
Without Commerical Terms
|-
|Value in Millions
|0-1
|1-5
|6-15
|15-30
|>30
|0-1
|1-5
|6-15
|15-30
|>30
|-
|
|
|
|
|
|
|
|
|
|
|
|
|-
| rowspan="6" |Estimate Reviews
|Lead Estimator
|√
|√
|√
|√
|√
|√
|√
|√
|√
|√
|-
|Chief Estimator (or designate)
|√*optional
|√
|√
|√
|√
|√*optional
|√*optional
|√
|√
|√
|-
|Project Lead (Project Development Manager/Construction manager) - if applicable
|√
|√
|√
|√
|√
|√
|√
|√
|√
|
|-
|Operations Manager
|
|√*optional
|√
|√
|√
|
|
|√*optional
|√
|√
|-
|Business Unit President
|
|
|√*optional
|√
|√
|
|
|
|√*optional
|√
|-
|COO
|
|
|
|√*optional
|√
|
|
|
|
|√*optional
|-
|
|
|
|
|
|
|
|
|
|
|
|
|-
| rowspan="6" |Fee Reviews
|Chief Estimator (or designate)
|√
|√
|√
|√
|√
|
|
|√
|√
|√
|-
|Project Lead (Project Development Manager/Construction manager) - if applicable
|√
|√
|√
|√
|√
|
|√
|√
|√
|√
|-
|Operations Manager
|
|√
|√
|√
|√
|
|
|√
|√
|√
|-
|Business Unit President
|
|√*optional
|√
|√
|√
|
|
|√*optional
|√
|√
|-
|COO
|
|
|√* Optional
|√
|√
|
|
|
|√*optional
|√
|-
|SGC President
|
|
|
|√*Optional
|√
|
|
|
|
|√*optional
|}
√*optional Denotes that this individual is to be made aware of any submisison (through MMM, direct contact, etc) and will decide on what level of review is required and who is to be included in the review

In any instance, the chief estimator or designate is to properly inform the optional persons of the project and determine the level of review.

SGC Submission Review Procedures

2023-07-19T19:32:30Z

Carsen der:

{| class="wikitable"
| colspan="12" rowspan="2" |'''SGC Submission Review Procedures'''
|-

|-
| colspan="2" |All submissions are to be reviews as per the table outlined below
|
|
|
|
|
|
|
|
|
|
|-
| rowspan="2" |
|
| colspan="5" |'''Submissions (New & Existing Projects)'''

'''With Commercial Terms (hard bid, RFP or negotiated)'''
| colspan="5" |'''Budget Submissions (New & Existing Projects)'''

'''Without Commerical Terms'''
|-
|'''Value in Millions'''
|0-1
|1-5
|6-15
|15-30
|>30
|0-1
|1-5
|6-15
|15-30
|>30
|-
|
|
|
|
|
|
|
|
|
|
|
|
|-
| rowspan="6" |'''Estimate Reviews'''
|'''Lead Estimator'''
|√
|√
|√
|√
|√
|√
|√
|√
|√
|√
|-
|'''Chief Estimator (or designate)'''
|√*optional
|√
|√
|√
|√
|√*optional
|√*optional
|√
|√
|√
|-
|'''Project Lead (Project Development Manager/Construction manager) - if applicable'''
|√
|√
|√
|√
|√
|√
|√
|√
|√
|
|-
|'''Operations Manager'''
|
|√*optional
|√
|√
|√
|
|
|√*optional
|√
|√
|-
|'''Business Unit President'''
|
|
|√*optional
|√
|√
|
|
|
|√*optional
|√
|-
|'''COO'''
|
|
|
|√*optional
|√
|
|
|
|
|√*optional
|-
|
|
|
|
|
|
|
|
|
|
|
|
|-
| rowspan="6" |'''Fee Reviews'''
|'''Chief Estimator (or designate)'''
|√
|√
|√
|√
|√
|
|
|√
|√
|√
|-
|'''Project Lead (Project Development Manager/Construction manager) - if applicable'''
|√
|√
|√
|√
|√
|
|√
|√
|√
|√
|-
|'''Operations Manager'''
|
|√
|√
|√
|√
|
|
|√
|√
|√
|-
|'''Business Unit President'''
|
|√*optional
|√
|√
|√
|
|
|√*optional
|√
|√
|-
|'''COO'''
|
|
|√* Optional
|√
|√
|
|
|
|√*optional
|√
|-
|'''SGC President'''
|
|
|
|√*Optional
|√
|
|
|
|
|√*optional
|-
|
|
|
|
|
|
|
|
|
|
|
|
|}
√*optional Denotes that this individual is to be made aware of any submisison (through MMM, direct contact, etc) and will decide on what level of review is required and who is to be included in the review

In any instance, the chief estimator or designate is to properly inform the optional persons of the project and determine the level of review.

SGC Submission Review Procedures

2023-07-19T19:21:05Z

Carsen der: Created page with " {| class="wikitable" | colspan="12" rowspan="2" |'''SGC Submission Review Procedures''' | | |- | | |- | colspan="2" |All submissions are to be reviews as per the table out..."

{| class="wikitable"
| colspan="12" rowspan="2" |'''SGC Submission Review Procedures'''
|
|
|-
|
|
|-
| colspan="2" |All submissions are to be reviews as per the table outlined below
|
|
|
|
|
|
|
|
|
|
|
|
|-
| rowspan="2" |
|
| colspan="5" |'''Submissions (New & Existing Projects)'''

'''With Commercial Terms (hard bid, RFP or negotiated)'''
| colspan="5" |'''Budget Submissions (New & Existing Projects)'''

'''Without Commerical Terms'''
|
|
|-
|'''Value in Millions'''
|0-1
|1-5
|6-15
|15-30
|>30
|0-1
|1-5
|6-15
|15-30
|>30
|
|
|-
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|-
| rowspan="6" |'''Estimate Reviews'''
|'''Lead Estimator'''
|√
|√
|√
|√
|√
|√
|√
|√
|√
|√
|
|
|-
|'''Chief Estimator (or designate)'''
|√*optional
|√
|√
|√
|√
|√*optional
|√*optional
|√
|√
|√
|
|
|-
|'''Project Lead (Project Development Manager/Construction manager) - if applicable'''
|√
|√
|√
|√
|√
|√
|√
|√
|√
|
|
|
|-
|'''Operations Manager'''
|
|√*optional
|√
|√
|√
|
|
|√*optional
|√
|√
|
|
|-
|'''Business Unit President'''
|
|
|√*optional
|√
|√
|
|
|
|√*optional
|√
|
|
|-
|'''COO'''
|
|
|
|√*optional
|√
|
|
|
|
|√*optional
|
|
|-
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|-
| rowspan="6" |'''Fee Reviews'''
|'''Chief Estimator (or designate)'''
|√
|√
|√
|√
|√
|
|
|√
|√
|√
|
|
|-
|'''Project Lead (Project Development Manager/Construction manager) - if applicable'''
|√
|√
|√
|√
|√
|
|√
|√
|√
|√
|
|
|-
|'''Operations Manager'''
|
|√
|√
|√
|√
|
|
|√
|√
|√
|
|
|-
|'''Business Unit President'''
|
|√*optional
|√
|√
|√
|
|
|√*optional
|√
|√
|
|
|-
|'''COO'''
|
|
|√* Optional
|√
|√
|
|
|
|√*optional
|√
|
|
|-
|'''SGC President'''
|
|
|
|√*Optional
|√
|
|
|
|
|√*optional
|
|
|-
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|}
√*optional Denotes that this individual is to be made aware of any submisison (through MMM, direct contact, etc) and will decide on what level of review is required and who is to be included in the review

In any instance, the chief estimator or designate is to properly inform the optional persons of the project and determine the level of review.

List of Content

2023-07-19T19:15:37Z

Carsen der:

<blockquote><big>'''''“Rocks in my path? I keep them all.'''''</big>

<big>'''''With them I shall build my castle.”'''''</big>

'''<big>''– Nemo Nox''</big>'''</blockquote>

==Project Management Items (what is/how to) ==

=== Viewpoint Fundamentals===

*[[Introduction to Viewpoint]]
*[[Cost Item vs Cost Code]]
*[[Viewpoint Quick Reference]]
*[[Viewpoint Terminology]]
*[[Viewpoint Report Module]]

===Operation / PM Duty Items ===
*[[Budget Upload]]
*[[Subcontract Management]]
**[[Generating Subcontract Using Template]]
**[[Sending Subcontract using DocuSign]]
*[[Project Change Management]]
*[[Document Controls]]
**[[Document Controls#RFI management|RFI management]]
**[[Document Controls#Submittal Management|Submittal management]]
*[[Project Cost and Forecast|Project Cost and Forecast - Pending Decision on Future PM software suite]]
*[[Cash Flow Projection]]
**[[Using Provided Template to Set Up Cash Flow Projection]]
*[[Viewpoint Reports]]
*[[Project Close Out]]
*<del>[[Creating Projection Codes]]</del>
*<del>[[How to Complete a Cost Forecast using PM Cost Projections|Forecasting with PM Cost Projections]]</del>
*[[Finance Calendar]]
*[[Viewpoint Reports - Operation - Most Used Reports|Reports - what and where]]
** Change Order Log
**Submittal and RFI log
**JC Cost Totals Drilldown
**Project Cost and Forecast

===Sequence Diagram for Typical Processes===

*[[Development and Building Permits]]
*[[Demo Permit Process]]
*[[How to: Get Utility - Gas]]
*[[How to: Get Utility - Water]]
*[[How to: Get Utility - Power]]
*[[Project Close Out Process]]
---------------------

==Estimating Items (what is/how to)==

===Estimate 2.0 (Software) ===
*[[Download Tutorial]]
*[[Tutorial]]
*[[General Help Manual]]
*[[How-to: Quick Guide]]
*[[FAQ]]
*[[SGC Submission Review Procedures]]

===Estimating Timecard===
*[[Timecard - Initial Setup|Initial Setup]]
*[[Timecard - Requesting|Requesting a Timecard]]
*[[Timecard - Submitting|Submitting a Timecard]]
*[[Timecard - Report|Viewing the Timecard Report]]

---------------------

==Business Technology==
*[[Amer page here]]
===<s>TimeLapse (obsolete)</s> ===
*[[Set-up Tutorial | <s>TimeLapse Set-up Tutorial</s>]]
===Power BI===
*[[Power BI|Power BI Summary]]
*[[Columns and Measures]]
*[[Power BI - Visualizations|Visualizations]]
*[[Power BI - Other Features|Other Features]]

---------------------

[[Category:List Of Content]]

Timecard - Requesting

2023-07-14T14:33:10Z

Carsen der:

A timecard will automatically be sent to your MS teams at 3pm each day. It will be under the name "Power Automate" in the chat tab. To request a timecard, navigate to the teams tab on the left side of the MS teams window.
[[File:Timecard - Requesting - Teams tab screenshot .png|center|frame]]
Next, click on "Your teams", click on the Synergy Estimating team and click on "Timecard"
[[File:Timecard - Requesting - Navigating to timecard team gif.gif|center|thumb|570x570px]]
Make sure that the "Post" tab is active at the tap of the page
[[File:Timecard - Requesting - Post tab screenshot.png|center|thumb|902x902px]]
Next, create a new conversation and type "TIMECARD". Note: "TIMECARD" must be fully capitalized.
[[File:Timecard - Requesting - Typing TIMECARD gif.gif|center|thumb|911x911px]]
Within the next couple of minutes, a timecard will be received. Please click [[Timecard - Submitting|here]] to learn more about submitting a timecard.

[[Category:Timecard]]
[[Category:Estimating]]

File:Timecard - Requesting - Post tab screenshot.png

2023-07-14T14:32:31Z

Carsen der:

Timecard - Requesting - Post tab screenshot

Timecard - Report

2023-07-13T19:30:55Z

Carsen der:

To view the timecard report page, click on the Teams tab on the left side of MS teams:[[File:Timecard - Requesting - Teams tab screenshot .png|center|frame]]
Next, click on "Your teams", click on the Synergy Estimating team and click on "Timecard"
[[File:Timecard - Requesting - Navigating to timecard team gif.gif|center|thumb|570x570px]]Click the tab at the top of the page labeled "Timesheet" to display the Power BI report.
[[File:Timecard - Report - Clicking timesheet tab gif.gif|center|thumb|1070x1070px]]The controls to the report are all in the top right. The estimator and the timeframe can be adjusted to filter the results.
[[File:Timecard - Report - Report controls screenshot .png|center|thumb|338x338px|The filter controls]]

=== Missing Timecard Report ===
To view the Missing Timecard Report, press the "View Missed Timecards" button directly under the title.
[[File:Timecard - Report - View Missed Timecards Screenshot.png|center|thumb|978x978px]]
You can return to the main page by clicking the "Back" button.
[[File:Timecard - Report - Back button screenshot.png|center|thumb|967x967px]]
[[Category:Timecard]]
[[Category:Estimating]]

File:Timecard - Report - Back button screenshot.png

2023-07-13T19:30:18Z

Carsen der:

Timecard - Report - Back button screenshot

File:Timecard - Report - View Missed Timecards Screenshot.png

2023-07-13T19:27:23Z

Carsen der:

Timecard - Report - View Missed Timecards Screenshot

Timecard - Initial Setup

2023-07-10T17:36:03Z

Carsen der:

The first step is setting up a Power BI account to view the report.
To view the timecard report page, click on the Teams tab on the left side of MS teams:[[File:Timecard - Requesting - Teams tab screenshot .png|center|frame]]
Next, click on "Your teams", click on the Synergy Estimating team and click on "Timecard"
[[File:Timecard - Requesting - Navigating to timecard team gif.gif|center|thumb|570x570px]]Click the tab at the top of the page labeled "Timesheet" to get started with Power BI.
[[File:Timesheet - Initial Setup - Clicking timesheet tab screenshot.png|center|thumb|782x782px]]
You will presented will a screen saying you must sign up for Power BI. Click "Sign up"
[[File:Timesheet - Initial Setup - Sign up screen screenshot.png|center|frameless|646x646px]]
This will prompt a brower to open with a sign up page. Proceed with creating a Power BI account.
[[File:Timesheet - Initial Setup - Creating a Power BI account screenshot.png|center|thumb|645x645px]]
After creating an account, navigate back to Teams. At this point it may say "Request access", proceed. After the admin accepts your access request, you can follow the instruction [[Timecard - Report|here]] to view the report.
[[Category:Timecard]]
[[Category:Estimating]]

File:Timesheet - Initial Setup - Creating a Power BI account screenshot.png

2023-07-10T17:33:11Z

Carsen der:

Timesheet - Initial Setup - Creating a Power BI account screenshot

File:Timesheet - Initial Setup - Sign up screen screenshot.png

2023-07-10T17:30:21Z

Carsen der:

Timesheet - Initial Setup - Sign up screen screenshot

File:Timesheet - Initial Setup - Clicking timesheet tab screenshot.png

2023-07-10T17:26:52Z

Carsen der:

Timesheet - Initial Setup - Clicking timesheet tab screenshot

Timecard - Initial Setup

2023-07-10T17:18:19Z

Carsen der:

Timecard - Initial Setup

2023-07-10T17:16:26Z

Carsen der:

The first step is setting up a Power BI account to view the report.

Timecard - Submitting

2023-07-05T19:25:45Z

Carsen der:

The timecard is a useful way for employees to track their hours. This provides useful insight into where time is spent and how efficiency could be increased.

After requesting a timecard or at 3pm, a robot named "Power Automate" will send you a timecard via teams. To view the timecard, navigate to the chat tab on the left side of the MS Teams window and press "Power Automate".

[[File:Timecard - Submitting - Chat tab gif.gif|center|frame]]

The timecard will look like this:
[[File:Timecard - Submitting - Timecard photo.png|center|thumb|580x580px]]
You must select the date and enter the estimate number.

At the moment, the cost plan is not supported; it must be left blank.

You may then fill in the number of hours for each activity and press submit. If you plan to submit another timesheet, that option may also be selected.

== Important Notes ==

* The estimate number must be in the exact format "20XX - XXX" with the space before and after the dash. Else there will be an error.
* There must be an estimate book created for the project of the timesheet ''before'' the timesheet is submitted.
* Only one timesheet may be submitted per project per day. If you submit a second one, it will overwrite the first. Each day, submit one timesheet per project.
* If filling out the timesheet at 3pm, estimate the remaining hours of the day.

[[Category:Timecard]]
[[Category:Estimating]]

Timecard - Requesting

2023-07-05T19:23:49Z

Carsen der:

A timecard will automatically be sent to your MS teams at 3pm each day. It will be under the name "Power Automate" in the chat tab. To request a timecard, navigate to the teams tab on the left side of the MS teams window.
[[File:Timecard - Requesting - Teams tab screenshot .png|center|frame]]
Next, click on "Your teams", click on the Synergy Estimating team and click on "Timecard"
[[File:Timecard - Requesting - Navigating to timecard team gif.gif|center|thumb|570x570px]]
Next, create a new conversation and type "TIMECARD". Note: "TIMECARD" must be fully capitalized.
[[File:Timecard - Requesting - Typing TIMECARD gif.gif|center|thumb|911x911px]]
Within the next couple of minutes, a timecard will be received. Please click [[Timecard - Submitting|here]] to learn more about submitting a timecard.

[[Category:Timecard]]
[[Category:Estimating]]

Power BI - Columns and Measures

2023-07-05T16:42:53Z

Carsen der:

== Overview ==
Creating a new column or a new measure both fundamentally do the same thing. They are both methods of manipulating data for easier visualization. For most purposes, creating a new column is the easier method, especially for users who are familier with Excel. The reason that a measure may be used, is that the new values created from it are calculated as they are needed, they are not stored. This means that when the column is hundreds of thousands, or even millions of rows, a measure will keep the program running smoothly and quickly, whereas a new column may impact performance and size of the file.

== DAX ==
''DAX'' is a collection of functions, of which data can be manipulated and is the basis behind both columns and measures. If there is a large number of rows imported into Power BI, it is important to write your DAX expressions correctly to avoid the program slowing down. It has been shown that Power BI can support datasets with >a trillion rows with correctly written DAX. Some common DAX functions include (but are not even close to limited to):

* SUM: This adds all the numbers in the specified column ('''''SUM(<column>)''''')
* FILTER: The filter functions allows the manipulation of data context to create new calculations. This is one of the most useful DAX functions and creating a working knowledge of it is very powerful ('''''FILTER(<nowiki><table>,<filter>)</nowiki>''''')
* COUNT: The count function counts the number of rows in a given column ('''''COUNT(<column>)''''')

== Example ==
Here we will continue the example started on the [[Power BI]] page.

=== Example column ===

First, navigate to the dataview with the table icon on the left side of the window.[[File:Dataview.gif|center|thumb|1219x1219px]]Let's create a new column to change the format of the date. Select "New Column" in the "Table Tools" tab.

[[File:New Column.png|center|thumb|1229x1229px]]
Now we can highlight the text field and enter the following:

Date_Column(New) = FORMAT(Sheet1[date],"ddd, mmm dd/yy")
[[File:Textbox.png|center|thumb|1233x1233px]]
Let's break this DAX expression down.

# Date_Column(New): The text before the "=" sign specifies the name of the new column. This can be anything but for simplicity, we named it something easy to identify.
# FORMAT(): This DAX function converts a value to text, in this case a date value to our specified format.
# Sheet1[date]: As consistent with the usage of the FORMAT function, this specifies the value to be converted to text. "Sheet1" is the worksheet and "[date]" is the column to pull from. We can identify these two on the right side of the window.
# "ddd, mmm dd/yy": This specifies the format that we would like our date in.

Upon clicking enter, the column should populate with the same dates, just reformatted.

=== Example Measure ===
Navigate back to the report view here
[[File:Report View.png|center|thumb|1245x1245px]]
Lets create a new measure to find the sum of all the sizes. The twist of this measure will be that it will only account for jobs that were won.

Click "New Measure"
[[File:New Measure.gif|center|thumb|1243x1243px]]
Enter the following DAX expression:

Volume Won = CALCULATE(SUM(sheet1[size (mil)]),FILTER(sheet1,sheet1[won/lost]="won"))

Let's break this expression down into smaller parts:

# Volume Won: Again, just the name of the measure.
# CALCULATE: This function allows the evaluation of an expression with filters applied. In the case, we see two inputs. The SUM input and the FILTER input, separated by a comma.
# SUM: This is the expression to be evaluated. Just like the last time SUM was used, we are evaluating the sum of all the rows in the "size (mil)" column of the "sheet1" worksheet.
# FILTER: The first and only filter applied to the calculate function. The calculate function can take more than one filter but for this example, we just want one. In the FILTER function, we must specify the sheet and the criteria. The sheet is "sheet1" and the criteria is that the row in the column "[won/lost]" is ="won".

This expression may seem complicated to those unfamiliar to coding but expressions like this can be really powerful once one becomes familiar with their usage. The new measure we just created can be seen here:
[[File:Measure Creation Screenshot 2.png|center|thumb|1230x1230px]]
Please follow the next tutorial to learn about [[Power BI - Visualizations|visualizations]]

[[Category:Power BI]]
[[Category:Estimating]]

Power BI - Columns and Measures

2023-07-05T16:41:51Z

Carsen der:

== Overview ==
Creating a new column or a new measure both fundamentally do the same thing. They are both methods of manipulating data for easier visualization. For most purposes, creating a new column is the easier method, especially for users who are familier with Excel. The reason that a measure may be used, is that the new values created from it are calculated as they are needed, they are not stored. This means that when the column is hundreds of thousands, or even millions of rows, a measure will keep the program running smoothly and quickly, whereas a new column may impact performance and size of the file.

== DAX ==
''DAX'' is a collection of functions, of which data can be manipulated and is the basis behind both columns and measures. If there is a large number of rows imported into Power BI, it is important to write your DAX expressions correctly to avoid the program slowing down. It has been shown that Power BI can support datasets with >a trillion rows with correctly written DAX. Some common DAX functions include (but are not even close to limited to):

* SUM: This adds all the numbers in the specified column ('''''SUM(<column>)''''')
* FILTER: The filter functions allows the manipulation of data context to create new calculations. This is one of the most useful DAX functions and creating a working knowledge of it is very powerful ('''''FILTER(<nowiki><table>,<filter>)</nowiki>''''')
* COUNT: The count function counts the number of rows in a given column ('''''COUNT(<column>)''''')

== Example ==
Here we will continue the example started on the [[Power BI]] page.

=== Example column ===

First, navigate to the dataview with the table icon on the left side of the window.[[File:Dataview.gif|center|thumb|1219x1219px]]Let's create a new column to change the format of the date. Select "New Column" in the "Table Tools" tab.

[[File:New Column.png|center|thumb|1229x1229px]]
Now we can highlight the text field and enter the following:

Date_Column(New) = FORMAT(Sheet1[date],"ddd, mmm dd/yy")
[[File:Textbox.png|center|thumb|1233x1233px]]
Let's break this DAX expression down.

# Date_Column(New): The text before the "=" sign specifies the name of the new column. This can be anything but for simplicity, we named it something easy to identify.
# FORMAT(): This DAX function converts a value to text, in this case a date value to our specified format.
# Sheet1[date]: As consistent with the usage of the FORMAT function, this specifies the value to be converted to text. "Sheet1" is the worksheet and "[date]" is the column to pull from. We can identify these two on the right side of the window.
# "ddd, mmm dd/yy": This specifies the format that we would like our date in.

Upon clicking enter, the column should populate with the same dates, just reformatted.

=== Example Measure ===
Navigate back to the report view here
[[File:Report View.png|center|thumb|1245x1245px]]
Lets create a new measure to find the sum of all the sizes. The twist of this measure will be that it will only account for jobs that were won.

Click "New Measure"
[[File:New Measure.gif|center|thumb|1243x1243px]]
Enter the following DAX expression:

Volume Won = CALCULATE(SUM(sheet1[size (mil)]),FILTER(sheet1,sheet1[won/lost]="won"))

Let's break this expression down into smaller parts:

# Volume Won: Again, just the name of the measure.
# CALCULATE: This function allows the evaluation of an expression with filters applied. In the case, we see two inputs. The SUM input and the FILTER input, seperated by a comma.
# SUM: This is the expression to be evaluated. Just like the last time SUM was used, we are evaluating the sum of all the rows in the "size (mil)" column of the "sheet1" worksheet.
# FILTER: The first and only filter applied to the calculate function. The calculate function can take more than one filter but for this example, we just want one. In the FILTER function, we must specify the sheet and the criteria. The sheet is "sheet1" and the criteria is that the row in the column "[won/lost]" is ="won".

This expression may seem complicated to those unfamiliar to coding but expressions like this can be really powerful once one becomes familiar with their usage. The new measure we just created can be seen here:
[[File:Measure Creation Screenshot 2.png|center|thumb|1230x1230px]]
Please follow the next tutorial to learn about [[Power BI - Visualizations|visualizations]]

[[Category:Power BI]]
[[Category:Estimating]]

Power BI - Columns and Measures

2023-07-05T16:39:48Z

Carsen der:

== Overview ==
Creating a new column or a new measure both fundamentally do the same thing. They are both methods of manipulating data for easier visualization. For most purposes, creating a new column is the easier method, especially for users who are familier with Excel. The reason that a measure may be used, is that the new values created from it are calculated as they are needed, they are not stored. This means that when the column is hundreds of thousands, or even millions of rows, a measure will keep the program running smoothly and quickly, whereas a new column may impact performance and size of the file.

== DAX ==
''DAX'' is a collection of functions, of which data can be manipulated and is the basis behind both columns and measures. If there is a large number of rows imported into Power BI, it is important to write your DAX expressions correctly to avoid the program slowing down. It has been shown that Power BI can support datasets with >a trillion rows with correctly written DAX. Some common DAX functions include (but are not even close to limited to):

* SUM: This adds all the numbers in the specified column ('''''SUM(<column>)''''')
* FILTER: The filter functions allows the manipulation of data context to create new calculations. This is one of the most useful DAX functions and creating a working knowledge of it is very powerful ('''''FILTER(<nowiki><table>,<filter>)</nowiki>''''')
* COUNT: The count function counts the number of rows in a given column ('''''COUNT(<column>)''''')

== Example ==
Here we will continue the example started on the [[Power BI]] page.

=== Example column ===

First, navigate to the dataview with the table icon on the left side of the window.[[File:Dataview.gif|center|thumb|1219x1219px]]Let's create a new column to change the format of the date. Select "New Column" in the "Table Tools" tab.

[[File:New Column.png|center|thumb|1229x1229px]]
Now we can highlight the text field and enter the following:

Date_Column(New) = FORMAT(Sheet1[date],"ddd, mmm dd/yy")
[[File:Textbox.png|center|thumb|1233x1233px]]
Let's break this DAX expression down.

# Date_Column(New): The text before the "=" sign specifies the name of the new column. This can be anything but for simplicity, we named it something easy to identify.
# FORMAT(): This DAX function converts a value to text, in this case a date value to our specified format.
# Sheet1[date]: As consistent with the usage of the FORMAT function, this specifies the value to be converted to text. "Sheet1" is the worksheet and "[date]" is the column to pull from. We can identify these two on the right side of the window.
# "ddd, mmm dd/yy": This specifies the format that we would like our date in.

Upon clicking enter, the column should populate with the same dates, just reformatted.

=== Example Measure ===
Navigate back to the report view here
[[File:Report View.png|center|thumb|1245x1245px]]
Lets create a new measure to find the sum of all the sizes. The twist of this measure will be that it will only account for jobs that were won.

Click "New Measure"
[[File:New Measure.gif|center|thumb|1243x1243px]]
Enter the following DAX expression:

Volume Won = CALCULATE(SUM(sheet1[size (mil)]),FILTER(sheet1,sheet1[won/lost]="won"))

Let's break this expression down into smaller parts:

# Volume Won: Again, just the name of the measure.
# CALCULATE: This function allows the evaluation of an expression with filters applied. In the case, we see two inputs. The SUM input and the FILTER input, seperated by a column.
# SUM: This is the expression to be evaluated. Just like the last time SUM was used, we are evaluating the sum of all the rows in the "size (mil)" column of the "sheet1" worksheet.
# FILTER: The first and only filter applied to the calculate function. The calculate function can take more than one filter but for this example, we just want one. In the FILTER function, we must specify the sheet and the criteria. The sheet is "sheet1" and the criteria is that the row in the column "[won/lost]" is ="won".

This expression may seem complicated to those unfamiliar to coding but expressions like this can be really powerful once one becomes familiar with their usage. The new measure we just created can be seen here:
[[File:Measure Creation Screenshot 2.png|center|thumb|1230x1230px]]
Please follow the next tutorial to learn about [[Power BI - Visualizations|visualizations]]

[[Category:Power BI]]
[[Category:Estimating]]

Timecard - Report

2023-07-05T15:45:26Z

Carsen der:

File:Timecard - Report - Report controls screenshot .png

2023-07-05T15:44:39Z

Carsen der:

Timecard - Report - Report controls screenshot

Timecard - Report

2023-07-05T15:41:09Z

Carsen der:

Timecard - Report

2023-07-05T15:40:43Z

Carsen der:

File:Timecard - Report - Clicking timesheet tab gif.gif

2023-07-05T15:40:19Z

Carsen der:

Timecard - Report - Clicking timesheet tab gif

Timecard - Report

2023-07-05T15:35:09Z

Carsen der:

Timecard - Submitting

2023-07-04T20:50:05Z

Carsen der:

The timecard is a useful way for employees to track their hours. This provides useful insight into where time is spent and how efficiency could be increased.

After requesting a timecard or at 3pm, a robot named "Power Automate" will send you a timecard via teams. To view the timecard, navigate to the chat tab on the left side of the MS Teams window and press "Power Automate".

[[File:Timecard - Submitting - Chat tab gif.gif|center|frame]]

The timecard will look like this:
[[File:Timecard - Submitting - Timecard photo.png|center|thumb|580x580px]]
You must select the date and enter the estimate number.

At the moment, the cost plan is not supported. At the moment it must be left blank.

You may then fill in the number of hours for each activity and press submit. If you plan to submit another timesheet, that option may also be selected.

== Important Notes ==

* The estimate number must be in the exact format "20XX - XXX" with the space before and after the dash. Else there will be an error.
* There must be an estimate book created for the timesheet of the project ''before'' the timesheet is submitted.
* Only one timesheet may be submitted per project per day. If you submit a second one, it will overwrite the first. Each day, submit one timesheet per project.
* If filling out the timesheet at 3pm, estimate the remaining hours of the day.

[[Category:Timecard]]
[[Category:Estimating]]

File:Timecard - Submitting - Chat tab gif.gif

2023-07-04T20:49:45Z

Carsen der:

Timecard - Submitting - Chat tab gif