Publications/Computer Skills

Publications

• Curriculum for Faculty of Architecture & Urbanism, Royal University of Phnom Penh, Cambodia. 10 lecture courses in Environmental Science, Proportion & Composition, Project Management, Construction, Material Science, Computers in Architecture (in English & translated into Khmer)
• Training material for Environmental Science for Nicer Training & Greenworks.
• Web  Blog: Vast , currently over 400 posts ( as of  17 November 2021 )
• Posted Videos on YouTube for training/demonstrating certain topics-see below- over 190 videos currently

Computer Skills

General

1. MS Office including: Excel (& VBA Macro’s), Word, PowerPoint, Publisher, Access.
2. Google Docs & Google Sheets (with GAS programming)
3. MS Project, MS SQL, OneNote.

Graphics

• AutoCAD (25 years’ experience) – DraftSight, nanoCad & BricksCAD Shape
• Revit (10 years)
• GIMP
• Adobe Premier Pro & videoing tools for posting to YouTube
• QGIS (Mapping)

Programming

SQL, Python, JavaScript, NodeJS, ReactJS, HTML, AHK, C#, VB, CSS, Pascal, Lisp

Using Github, AWS & Google Clouds Services

General Web

Setting up web pages on hosted servers & Virtual Private Servers. WordPress website and raw HTML websites. Websites include:

• Web  Blog: Vast
• FM/AM Demonstration site: Visual Asset Strategic Tools
• Property Information demonstration site : Property Information
• Photographic Portfolio website: Imagery

Video Recording

OBS-Open Broadcaster Software & Adobe Premier Pro

Video training/explaining playlists on YouTube – Channel Max Drake
Currently about 190 videos &  79,000 views to date (17 November 2021 )

1. GlideApps -Playlist 1 & 2– Currently 58 videos
2. Free Productivity Tools-Playlist– Currently 42 videos
3. Visualise Facility & Assert Management- Playlist– Currently 38 videos
4. AutoHotKey –Playlist– Currently 18 videos
5. Revit Tips & Tricks-Playlist– Currently 9 videos
6. BIM Revit Existing Blg Model Setup for Data Extraction-Playlist– Currently 10 videos
7. Beginner coding-Playlist– Currently 6 videos
8. Honeycode-Playlist– Currently 9 videos
9. PWA’s –Playlist– Currently 6 videos

Mobile (Android) & WebApps

• GlideApps (for creating WebApps)
  1. 1. General App
     2. App of Apps a collection of App links from one app
     3. Construction/Property FM/AM
     4. Defects list for Contractor  Example for site inspection and repair
     5. Defects list for Designers – to report faults to be repaired
     6. Building Survey Info App Demo for Karori Library
     7. CheckOurtCheckIn Demo app for equipment, libraries etc
     8. Freezer Inventory App Demo (a generic Inventory App)
     9. Rental Home Compliance Demo App
     10. City Housing property Finder and PDF plan download demo
     11. Tour/Gallery/Translation
     12. HopOnHopOff– Translated for English, German, Chinese. Example of Tour App
     13. Museum Exhibition Demo app for translation for overseas guests. English, Chinese, Japanese, German & Arabic
     14. City Gallery Art Exhibition demo translation for overseas guests. English, Chinese, Japanese, German
     15. Wellington Museum Exhibit Translation App Demo. English, Chinese,Spanish, Arabic
     16. NZ Roadside Stories Demo audio stories via app
     17. Business Apps
     18. Small Business Booking App for Clients(for Barber shop) – Template for sale, sold 82 copies to date
     19. Small Business Booking App for Staff (for Barber shop) – Template for sale, sold 12 copies to date
     20. Motel Info App Demo
     21. Honey produce App for stallholder
     22. Fishing Business Tackle Shop Demo App
     23. Restaurant Reservations App demo
     24. eBusinessCard demo
     25. RealEstate App Demo
     26. Sales inventory Demo App
     27. Community type apps
     28. Conference App Demo
     29. Attendance App Demo
     30. Consensus App for anonymous feedback on questions for Office, business etc Demo
     31. Covid Cases Demo App (old)
     32. Personal Apps
     33. Personal spending tracker Demo
     34. Timesheet Demo App
     35. Location Tracker for Exercise Demo with Map
     36. Time & Expense Demo App
• AppInventor (for Android Apps)
  1. 1. App Inventor GPS lat/long capture from phone demo– aia file download
• Honeycode(Amazon Low code App for creating WebApps)

Windows Apps

These created using AutoHotKeys scripting language to create Windows apps for specific tasks.

1. 1. 1. Handheld Barcode Scanner & Data Entry with AHK’s Part 3– Text to Speech for confirmation of input for plant growth monitoring
      2. FileSave&Launch– keeping track of Recent Files for Windows See article and video
      3. TimeCapture– Simple time management app for Windows See  video

Analytics

• PythoAutoHotKeyn
• FME (Safe software)
• Knime
• Orange
• Weka
• Tableau Community

Asset Management Programs

• SPM (Property)
• OpenMaint(Property)