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.


My tenant name is guyinacube.  The default domain for the Tenant will be  Any users I add at this point will have a login/email address of 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 “” domain?

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

If you want to have your email look like 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, you can’t change it to be To use a different 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 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 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

SharePoint Team Site vs. OneDrive for Business

This post give an answer:

OneDrive for Business is meant to be your “me” place at the office. Basically, if you’re trying to compare it to your File Shares, it could be thought as the new “Home Folders” for users or the new “My Documents”.

SharePoint Team Site is meant to be the “We” part of the work for you and your team. In this location, the file isn’t owned or associated to one user, but rather the team itself or the Team Site if you will.

Posted in Office365, SharePoint | Tagged | Leave a comment