WaterCAD error “Value does not fall within the expected range”

please refer to this post:

Error performing standard tasks: “Value does not fall within the expected range”

Posted in WaterCAD | Leave a comment

Site Plan consist

  1. Title Cover page
  2. Conditions
  3. Existing condition & demolition plan
  4. site plan overall
  5. grading plan
  6. utility plan
  7. dry utility plan
  8. Utility profile
  9. storm water management plan
  10. erosion and sedimentation plan
  11. construction phase
  12. traffic control plan
  13. site plan details
  14. building architecture plan
  15. landscape plan
  16. lighting plan
  17. photometer plan
Posted in Uncategorized | Leave a comment

Outlook email search tips

see this post: Learn to narrow your search criteria for better searches in Outlook

Posted in Office365, SharePoint, SharePoint online, Uncategorized | Leave a comment

Combine multiple excel sheet (Power Query)

refer to this article

Power Query is included with Excel 2016. It has been renamed and is now on the Data tab of the Ribbon in the Get & Transform section. This means there is nothing to install. If you are using Excel 2016, go to the Data tab on the ribbon and press the New Querybutton to create a query and open the Power Queryeditor.

  1. prepare each sheet: create “Table”. Column names shall be identical (it is case sensitive).
  2. create query “From Table”.
  3. merge query and load data to a new sheet
Posted in Uncategorized | Leave a comment

SharePoint online: share document

  • Get Access link:

“View” and “Edit” are difference links: e.g.



  • How to Share



Posted in Office365, SharePoint online, Uncategorized | Leave a comment

Office 365 (SharePoint online): tenant vs. Domain (DNS) name

  • Excerpt from this Post:

When you create a tenant for your organization, we will then register two different DNS entries by default.  Let’s assume the tenant name we are picking is guyinacube.  The two DNS entries that will be created are the following.

  • guyinacube.onmicrosoft.com
  • guyinacube.sharepoint.com

My tenant name is guyinacube.  The default domain for the Tenant will be guyinacube.onmicrosoft.com.  Any users I add at this point will have a login/email address of user@guyinacube.onmicrosoft.com if I do nothing else.

There is no cost to having a Tenant itself.  The cost comes in with whatever subscriptions you have for your Tenant and the number of licenses you are paying for.  This may be O365 Subscription, SharePoint Online, Exchange, Power BI, etc…

  • Excerpt from this Post:

Why do I have an “onMicrosoft.com” domain?

Office 365 creates a domain for you, like contoso.onmicrosoft.com, when you sign up with the service. The user ID that you create when you sign up includes the domain, like alan@contoso.onmicrosoft.com.

If you want to have your email look like alan@contoso.com: buy the domain or just follow the steps in Add your users and domain to Office 365 if you own it already.

  • You can’t rename the onmicrosoft domain after sign-up. For example, if the initial domain you chose was fourthcoffee.onmicrosoft.com, you can’t change it to be fabrikam.onmicrosoft.com. To use a different onmicrosoft.com domain, you’d have to start a new subscription with Office 365.
  • You can’t rename your team site URL. Your team site URL is based on your onmicrosoft.com domain name, and because of the way SharePoint Online architecture works, unfortunately you can’t rename the team site.
  • You can’t remove your onmicrosoft domain. Office 365 needs to keep it around because it’s used behind the scenes for your subscription. But you don’t have to use the domain yourself after you’ve added a custom domain.

You can keep using the initial onmicrosoft.com domain even after you add your domain. It still works for email and other services, so it’s your choice.

Posted in Office365, SharePoint online | Leave a comment

Write Project Bid Documents

  1. Decide which General Condition (GC) to use (e.g. AIA, EJCDC)
  2. prepare “Supplementary Condition” (SC) that tweak (revise) General Condition
  3. Prepare “Tech Specification”, decide which Divisions to use
  4. Prepare “Special Provision” that tweak Tech Specification,
  5. Prepare “Agreement”,
  6. Prepare “Instruction to Bidders”

Construction Agreement type:

  1. Master Service Agreement (MSA)
  2. Construction Agreement
  3. Network pipeline Install and Repairs Agreement
  4. Engineering Services Agreement

Open-Bid process:

  • Pre-bid meeting
  • Respond to bidders questions
  • Bid evaluation / recommendations
  • Pre-construction meeting
  • Submittal review & approval
  • Respond to contractor Requests for Information
  • Construction inspections (periodic inspections, not a full time inspector)
  • As-built drawings (field markup)
  • Final inspection / Punch list / Final certifications
Posted in Uncategorized | Leave a comment