I have a solution I have developed but I keep finding my description of that it does for people to be way too complex and long.
I know there's a market for it. The solution is a tool I have been looking for in a number of jobs. Some of the features of my solution don't exist elsewhere and are things various bosses at various companies have asked my co-workers and I to find a solution for. I have even found people asking for this style solution on stackoverflow - unanswered for 4.5 years;
https://stackoverflow.com/questions/37173851/unit-testing-both-excel-formulas-and-vb-with-the-same-tool/61606254#61606254
The solution is essentially allowing people to work in a new way leveraging knowledge that they already have by extending MS Excel to behave differently which gives the user much greater effectiveness. It can even remove an analyst or developer from translating the spreadsheet into code, or greatly reduce the amount of work for one.
But getting the idea across initially requires me to be able to reduce my solution to an elevator pitch or similar.
Are there heuristics or rule-of-thumb to boil a complex and novel idea or concept down to something a "normal" person would understand in a sentence or two? (normal being someone not neck-deep in the minutiae of developing the solution)
Are there ways to train in how to do this -- books, courses, youtube...?
EDIT:
The idea isn't so complex, I've simply extended MS Excel to do things it couldn't before.
But it's the fact that Excel couldn't do this before that's difficult to describe as people appear to be comfortable/resolved to themselves that Excel doesn't and cannot do this.
In a genuine nutshell:-
FlyingKoala allows you to use Python to calculate the math you've expressed in Excel formulas.
But that's way too simple. From here the conversation always follows;
The reality of that is who cares..? Excel already calculates. Who on earth would want Python to do what Excel is already doing?
Then I add; You can write functions for yourself in Python. The response is; So? Other solutions do that already too (xlwings, datanitro, pyxll). Why write another one?
Thea answer is
FlyingKoala will do the conversion from Excel formulas to Python for you ("hands-free") and uses functions you've written in Python seamlessly. It will also provide the ability for you to use the Python generated from Excel formulas in Python generally. So the math you define in Excel and its formulas can become a "module" or "black-box" math component in Python without needing an analyst or developer to translate them.
FlyingKoala also provides the ability to write unit tests for Excel formulas. I meet resistance here too. Because people couldn't do this before FlyingKoala it's in their mind that they can't thoroughly test models written in Excel. People who write models and need to satisfy clients, managers, banks or auditors through demonstration that the model is calculating correctly need this.
You may want to look at the Jobs to be Done framework:
https://jtbd.info/2-what-is-jobs-to-be-done-jtbd-796b82081cca
https://www.youtube.com/watch?v=flKcN2x50rw
In a nutshell, describe your product in terms of what "jobs" it helps your users do.
More broadly, describing things in terms of things people already understand works well. That is why you see so many companies use phrases like "Uber for X" or "AirBnb for Y".
Yeah, Jobs-to-be-Done is a great framework for this kind of analysis, a more formal approach to "what's the customer pain you're trying to assuage?"
Sometimes it feels too formal to me, and obscures the underlying point that the opening Kathy Sierra quote in the article brings to bear so well: "Upgrade your user, not your product. Don’t build better cameras — build better photographers."
Pair that quote with figure 6, and you really don't need the rest of the article. :)
I did find the discussion on "what is a Job and what isn't a Job" really helpful, though. And Clayton Christiansen's talk is perfect. (Never heard him talk before.) Both bring you to the same conclusion: relentlessly focus on the customer's experience.
What's the pain your customers experience?
You've clearly hit upon one. Clear away the Python and the Excel, the unit tests and the black boxes. What's the human pain those clients and managers and bankers and auditors are experiencing?
Some ideas, based on your description:
If you can isolate the pain you're addressing and put it in the same terms your customers use, then communicating the nature of the fix becomes easier.
Thanks for taking the time to reply.
If I get what you are saying I am fixated on features and benefits (or maybe even worse... just the tech) rather than the connection with what matters to the people I'm trying to reach.
Does this encapsulate the concept you're presenting?
Am I getting closer..?
This is closer:
Remember, it's not about your product, it's about your customer, and how your product makes your customers awesome by nullifying their pain.
Let your customer picture himself standing fearlessly, calculations in hand, before a phalanx of frowning managers, bankers, and auditors. Your customer has no fear, because those calculations are sound, and he can prove it.
The technical stuff about Python and user interfaces comes later, once you're off the elevator with an intrigued future customer beside you.
The concept of visualization is helping.
Picturing the user/customer standing proud on a mountain, cape flowing with manager cowering in the greatness of what they can do. Person deflecting critical questions of their work with a shield that has my logo on it.
Then describing to that person that using {the thing} they can be the one standing on the mountain, boss cowering in their greatness.
FlyingKoala allows transparent calculations to other domain experts, bankers and auditors. It also enables analysts to complete conversions from Excel to Python automatically and facilitates testing.
Sounds like you're on your way. Good luck!
Hi @bradbase, is this still something you're working on?
Sure is :D
Awesome. The idea to extend MS Excel sounds interesting. You said that you were having some trouble communicating it, and you asked about heuristics to to simplify your messaging. I actually developed a web application for this purpose. SplashPad (https://getsplashpad.com) helps you describe and promote your product effectively by suggesting language while you write.
I am interested in hearing more about what challenges you're facing when communicating about your idea, and perhaps I can help. Are you open to a chat? You can find a time that works for you here: https://tinyurl.com/y338v92o.