Excel horizontal axis date/month format

  1. right click “x axis”, select “format axis”
  2. Select “Number”,
  3. Category: “Custom”
  4. Type: “[$-en-US]mmm;@”
  5. and then, change Format Code to: [$-en-US]mmm;@
  6. click “Add”

Number to Date:

  1. Major Units “30” means “30 days”

 

Advertisements
Posted in Uncategorized | Leave a comment

Excel create Gantt Chart

refer to this post

Posted in Uncategorized | Leave a comment

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.

https://????.sharepoint.com/sites/????/_layouts/15/guestaccess.aspx?guestaccesstoken=JUcWH5UX……

https://????.sharepoint.com/sites/????/_layouts/15/guestaccess.aspx?guestaccesstoken=pI%2fr5NfgoDa8….

  • How to Share

2017-09-06-0001

 

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