<p>I've seen different program managers write specs in different format. Almost every one has had his/her own style of writing a spec.</p>

<p>On one hand are those wordy documents which given to a programmer are likely to cause him/her missing a few things. I personally dread the word documents spec...I think its because of my reading style...I am always speed reading things which I think will cause me to miss out on key points.</p>

<p>On the other hand, I have seen this innovative specs written in Excel by one of our clients. The way he used to write the spec was kind of create a mock application in Excel and use some VBA to mock it. He would do things like on button click where should the form go or what action should it perform (in comments). </p>

<p>On data form, he would display a form in cells and on each data entry cell he would comment on what valid values are, what validation should it perform etc. </p>

<p>I think that using this technique, it was less likely to miss out on things that needed to be done. Also, it was much easier to unit test it for the developer. The tester too had a better understanding of the system as it 'performed' before actually being written.</p>

<p>Visio is another tool to do screen design but I still think Excel has a better edge over it considering its VBA support and its functions.</p>

<p>Do you think this should become a more popular way of writing spec? I know it involves a bit of extra work on part of project manager(or whoever is writing the spec) but the payoff is huge...I myself could see a lot of productivity gain from using it. And if there are any better formats of specs that would actually help programmer.</p>

[{'answer_id': 23105, 'author': 'Thomas Owens', 'author_id': 572, 'author_profile': 'https://Stackoverflow.com/users/572', 'pm_score': 0, 'selected': False, 'text': "<p>One of the Microsoft Press books has excellent examples of various documents, including an SRS (which I think is what you are talking about). It might be one of the requirements books by Weigert (I think that's his name, I'm blanking on it right now). I've seen US government organizations use that as a template, and from my three work experiences with the government, they like to make their own whereever they can, so if they are reusing it, it must be good.</p>\n\n<p>Also - a spec should contain NO CODE, in my opinion. It should focus on what the system must do, should do, and can not do using text and diagrams.</p>\n"}, {'answer_id': 23107, 'author': 'TheEmirOfGroofunkistan', 'author_id': 1874, 'author_profile': 'https://Stackoverflow.com/users/1874', 'pm_score': 3, 'selected': False, 'text': '<p><a href="http://www.joelonsoftware.com/articles/fog0000000036.html" rel="nofollow noreferrer">Joel on Software</a> is particularly good at these and has some good articles about the subject...</p>\n<p>A specific case: <a href="http://www.joelonsoftware.com/articles/AardvarkSpec.html" rel="nofollow noreferrer">the write-up</a> and <a href="http://web.archive.org/web/20051028171624/https://www.joelonsoftware.com/RandomStuff/copilot_spec.pdf" rel="nofollow noreferrer">the spec</a>.</p>\n'}, {'answer_id': 34198, 'author': 'paulgreg', 'author_id': 3122, 'author_profile': 'https://Stackoverflow.com/users/3122', 'pm_score': 2, 'selected': False, 'text': '<p>I think you may have a look about Test-Driven Requirements, which is a technique to make executable specifications.</p>\n\n<p>There are some great tools like <a href="http://fit.c2.com/" rel="nofollow noreferrer">FIT</a>, <a href="http://fitnesse.org/" rel="nofollow noreferrer">Fitnesse</a>, <a href="http://www.greenpeppersoftware.com/en/products/" rel="nofollow noreferrer">GreenPepper</a> or <a href="http://www.concordion.org/" rel="nofollow noreferrer">Concordion</a> for that purpose.</p>\n'}, {'answer_id': 40277, 'author': 'Vinnie', 'author_id': 2890, 'author_profile': 'https://Stackoverflow.com/users/2890', 'pm_score': 2, 'selected': False, 'text': '<p>Two approaches have worked well for me.</p>\n\n<p>One is the "working prototype" which you sort of described in your question.  In my experience, the company contracted a user interface expert to create fully functional HTML mocks.  The data on the page was static, but it allowed for developers and management to see and play with a "functional" version of the site.  All that was left to do was replace the static data on the pages with dynamic content - this prototype was our spec for the initial version of our product.  The designer even included detailed explanation of some subtle behavior in popup dialogs that would appear when hovering over mock links. It worked well for our team.</p>\n\n<p>On a subsequent project, we didn\'t have the luxury of the UI expert, but we used similar approach.  We used a wiki to mock a version of the site.  We created links between the functional aspects of the system and documented each piece of functionality in detail.  Each piece of functionality could, in turn, link to detailed design and architecture decisions.  We also used to wiki to hold our to list feature list for each release (which became our release notes).  These documents linked back to the detailed feature page.  The wiki became a living document - describing our releases and evolution of our system in great detail.  It was an invaluable resource.  </p>\n\n<p>I prefer the wiki to the working prototype because it\'s more easily extensible - growing and becoming more valuable as your system evolves.</p>\n'}]
['https://Stackoverflow.com/questions/23091', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/2528/']