I have been searching for while to add a progress indicator in excel. It is so elegant and easier for convening the percentage completion to the reader. I will walk you through the steps and settings. I used office 2010 professional.
We need to create a new rule for the cell. So select the cell for which you want progress indicator. Then click on “New Rules” from Home->Conditional formatting.
A popup window will appear, select the following options
After selecting the options mentioned above, click on “OK” to apply the rule for the cell selected.
Then go back to your excel sheet, click on the cell and update the number you wish for the progress bar in the formula bar.
You can copy this formatting to other cell and update the number in formula bar for each cell separately.
I am going to put forth my ideas based on my experience. Software designing needs lots of patience and need to be open to ideas or changes. The first few phase are very trivial for software design. I had an opportunity of designing three software from conceptual phase.
1.Gathering the requirements
May be this sounds easier, but believe me it needs your time. For the first software which i designed, it took me two months for requirement elicitation. First step is to find out whether the product is for the internal or external customers. Both customers are very unique, internal customers are critics and external customers are consumers.
After determining the customers, bring the stake holder in for a discussion and understand the following:
What is the end goal of the product?
What is scope of adding features in future ?
Is it aligned to the market trend
What is the targeted time frame ?
These discussions will give you a fair idea about the software/product and it will be easier for you to communicate in their language. Create a database to store all the meeting minutes, requirements documents. Go through the requirements document and create an understanding document based on your understanding about the requirement and get it reviewed by the stake holders.
Initial tough phase is completed.
2. Finalize the technology
Now you have a fair idea about the product. Do a market research about the softwares that can be used, just to give an example.
Is it easier to maintain
Is support available
Yes, online forums
This phase is also very trivial since this is going to determine path for rest of your project.
3. Proof of concept
According to me, this is where your software gets life. This phase can eliminate the unnecessary complication on platform, technology. In my first project i ignored this phase and it lead to major complications. We were to design a cross platform software for a Embedded product. My fellow engineers chose wxWidgets just based on the initial market research. The development went fine on one platform until time came to test on windows, the entire software broke. We ended up debugging the software to create work around.
So don’t do this mistake. This phase will not resolve any un foreseen issue, but it will at least give you an heads up.
4. Decide on the design pattern
Here comes the dilemma, there are more design patterns available than anticipated. In phase 3 you might get some idea about the working of the software in very high level. Use that understanding to zero in on design patterns. A piece of advise, have two or three design patterns as fall back position.
5. Decide on building blocks/modules
The design should be structured, easier to maintain and expendable. Create building blocks of the software and find a common blocks which can be used by all modules. Blocks not the very low level of coding, I am just talking about the modules.
I will take an example of GSM messaging, Layer 3 messaging RR,CC, SMS etc,
I created base block for the all the layers to be able to control completely if any changes in future.
6. Communication channel between modules
We have decided on the modules, number of building blocks and common blocks. Now we need to finalize on the mode of communication between these blocks. In my first project the softwares includes four services, a. Main GUI or tracing b. Configuration management c. Clock d. Simulation components. So How did i decide on the communication mechanism, its simple. First draw a map about who’s is going use those modules, is there any updates required during run time.
So in my case the configuration server holds all the information about the current running instance and needs to be update in runtime and broad casted. So i decided to go for a client server design on sockets, one for updating data and another for broadcast.
In your case it could be just a function call.
7.Designing individual modules
If you have reached this phase, you have complete understanding of the software by now. The modules are tap points for the application layers. So make sure you make it very generic so that it can be completely controlled by the application layer. For instance we will take the GUI wants to connect to a server
You may be an architect but in order to make your design rolling, you need to document. Keep in mind that the engineer does not have extensive knowledge, since he/she is not involved from conceptual phase. In first project i got this wrong and assumed the engineer knows.
After you document the design, make sure to get the design review by SME’s, stake holders. This will give a chance to correct the design, if you have missed any trivial part. This does not mean that you have got all requirement correct 🙂
Before closing up this discussion. The above mentioned points are purely based on my experience. I always strive to make the design make very generic and to embrace changes based on the customer experience.