Wilson Mar bio photo

Wilson Mar

Hello. Hire me!

Email me Calendar Skype call 310 320-7878

LinkedIn Twitter Gitter Google+ Youtube

Github Stackoverflow Pinterest

Budget spreadsheet

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. Resumes (mine)

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

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

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

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

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

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

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

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

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

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

  46. Recruitment follow-up