skip to content W3C SVG

Project Management

Aug 12, 2019
Apr 22, 2020

IMAGE GALLERY (8)

See things happening as they progress in realtime

Agile Methodologies

PM Use cases

provides visual queus on completed vs todo

  1. Track Marketing Campaigns
  2. Track development progress

PM in 25 mins

  • For problems - listen to customers
  • For solutions - do not listen to them
  • Watch/dont watch competition - Does it really help?
  • Steal like an Artist
  • Always learn - be dumb

What are we tracking?

  • Products / Projects
  • Tasks / Subtasks
  • Time
  • Project Boards

PM Tools

Project Name FREE Reporting
Project Open y y
Open Project y ?
Taiga y n
todoist y y

Task analysis

is the analysis of how a task is accomplished

  1. including a detailed description of both manual and mental activities
  2. task and element duration’s
  3. task frequency,
  4. task allocation,
  5. task complexity,
  6. environmental conditions,
  7. necessary clothing and equipment,

and any other unique factors involved in or required for one or more people to perform a given task.1

Implementation

App Script

  • Apps Script services provide ways for your script to easily access data on Google and external systems.
  • Server side JS that runs on google cloud, giving your apps data from Gcloud
  • App Script is Serverless
  • Built-In with in GSuite
    • docs/sheets, slides
  • Advanced service uses HTTP REST API
    • Big query
    • YouTube
  • Is NOT client side and does not run on browser
  • JavaScript syntax, to automate various workflows b/w google projects
  • Tools –> App Script Editor
  • Application (sheets) have data (sheets-files) with ranges and cells
  • Use breakpoints and debug functions to list app available google provided classes in this object
  • Google provides Google script Dashboard to list and audit all scripts which were run with status.
  • Can use services like YouTube, analytic, translate, bigquery
  • Types os app scripts
    • Standalone
    • Add-Ons (docs, sheets, Forms), document bound scripts
    • Simple web apps & site bounding gadgets
  • Save App Scripts in your google drive
  • Google App Maker uses app scripts in the back-end
  • AppScript Apps will prompt user for OAuth prompt.

Use cases

  • send emails from spread sheet trackers
  • Plan visits to all addresses from spreadsheet
  • Video statistics from YouTube in sheets for analysis and research purposes
  • Run App scripts from anywhere using AppScript Execution API
  • Auto generating google forms (standalone app script)
  • Put data from multiple Forms in one spreadsheet/doc or external database
  • Pragmatically create slides
  • Scan data, title, amount, vendor from expense sheet and auto-fill in form, to transfer it to google sheets without ever leaving the Gmail
  • Develop chatbots for Hangout call
  • Commandline App script Projects
  • Sending SMS on meeting using Google colander
  • Custom Menu to run App Scripts
  • Google sheets to Gcal Sync
  • Send email on a link click on page
  • Google Apps Script can interact with APIs from all over the web like github etc.
  • Make full fledged web-applications out of sheets with UI and appscript as business Logic.
  • Google internally uses a AppScript based project management tool for Drive and docs team
  • Social Media Content Tracking Google Spreadsheets
function myFunction() {
  var sheet = SpreadsheetApp.getActiveSheet();
  var address = sheet.getRange("A1").getValue();

  var map = Maps.newStaticMap().addMarker(address);
  Logger.log(map.getMapUrl());
  sheet.getRange("B1").setValue(map.getMapUrl());

  MailApp.sendEmail("email@addr", "Subject", "body map.getMapUrl()");
}

What do I need?

  • Idea Capture system - brainstorm/research, +/-
  • Spaced Repetition system

Building your own PM solution

  • Use all the power provided by google Suite, adwords, sheets, analytics, search
  • inbuilt sharing capabilities
  • 4 Google sheets Files, which talks amongst themselves using push/pull
    • Central Tracker
    • Content Tracker
    • Outreach Tracker
    • Client Tracker
  • Never touch Client Files, updated TRACKERS and client files are automatically updated
  • Use google sheets as database to your website
  • Something like WOrkep
  • One Google Drive Folder per project where you put your competitive analysis, research etc.
    • Project Files could me sheets/docs/slides, videos, audio notes, github-integration, time-tracking etc.
  • How to keep associated links for a project together, capture and present them, GKeep?
  • data-studio for creating dashboards
  • Able to generate reports that no tool can do
  • Google OAUTH PLaygroubd

Google sheets functions

  1. sparklines
  2. query
  3. Join
  4. textjoin
  5. concatinate &
  6. pivot table
    1. Protect range
    2. sum and sumif functions 3.
  7. Geo charts
  8. Google App Maker

Inspirations

Footnotes

gsuitedevs/apps-script-samples