Wilson Mar bio photo

Wilson Mar

Hello!

Email me Calendar Skype call

LinkedIn Twitter Gitter Instagram Youtube

Github Stackoverflow Pinterest

Budget spreadsheet

Your future, in little boxes

US (English)   Español (Spanish)   Français (French)   Deutsch (German)   Italiano   Português   Cyrillic Russian   中文 (简体) Chinese (Simplified)   日本語 Japanese   한국어 Korean

Overview

BTW, I am available to help you with this. Call me!

The spreadsheet

Click here to download spreadsheet:
btn green download button
Dev_evangelism_budget_v02_wm_2016.03.22.xlsx

(select Save File).

BTW, the file was created using Microsoft Office 2011 for Mac.

The columns

  • # contains counts of the deliverable.

  • Deliverables short description

  • Urgency: Number 1 is highest. You may want to use A,B,C,D instead here.

    This column is not used in any calculation.

  • Effort: Number for estimating, taken from Agile practitioners.

    This number may mean different things to different people.

    The coloring was set by highlighting the column and clicking Word’s Conditional Formatting icon on the Home ribbon or menu Format.

  • %: auto-calculated by an Excel formula.

    CAUTION: Typing in this column destroys the calculation.

  • Days: The number of man-days. The number in each row is a fraction of the total under the same column within the Totals tab. A separate tab is used so the Assets sheet can be sorted easier.

    Calculations are based on the percentage of Effort.

    CAUTION: Typing in this column destroys the calculation.

  • Yield: is for comment about the outcome (FTW).

  • Note:

Usage

This spreadsheet helps you realize when you’re over-extended with commitments.

Review the man-days to see if it’s reasonable,

The number of days at the bottom should be work-days (about 20 a month), less holidays, vacations, and a margin for various more urgent items that come up to eat up time along the way.

(> It’s better to under-commit and over-deliver than
over-commit and under-deliver.)

You can sort this spreadsheet by various columns.

Want someone to explain this to you? We’re available to help. Call me!

There’s more …

This is part of a series on Evangelism:

  1. Job Descriptions

  2. Evangelism dependencies
  3. Deliverables and Events Budgeting spreadsheet
  4. Evangelism Cost-Benefit analysis (Bang-for-the-buck comparion)

  5. Events and Conferences
  6. Calendar of Announcements
  7. Milestone events

  8. Social media
  9. Social media strategy
  10. Tweets
  11. Sentiment analysis (of favorable words or not)
  12. Responses to social media
  13. Tech Press mentions

  14. Competitive Comparisons (by analysts and others)
  15. Competitive Strategy
  16. Competitive Comparison Kit (for people to run for themselves)
  17. Objections, and how to handle them

  18. Target Customers
  19. Customer References
  20. Proof Points
  21. Email databases (User Acquisition)
  22. Remarketing of current or lapsed users

  23. Product websites
  24. Product wikis
  25. User Forums (Google, LinkedIn, Reddit, etc.)
  26. Surveys

  27. Product Roadmaps
  28. Release Schedule
  29. Tasks
  30. Issues

  31. environments for development, testing, demos, training, etc.
  32. Demo presentation scripts
  33. Beta activities
  34. Release Notes

  35. Tutorials
  36. Live event sign-up administration
  37. Webinars
  38. Video production capability
  39. Live Video Streaming

  40. Spiffs
  41. Hackathons
  42. Participating in Conferences
  43. Running Conferences
  44. Dynamic projections of tweets, etc.

  45. Recruitment follow-up