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.
I have been working with TI-SDK for past two years and every time i come across some interesting trivia posed by the systems engineers 🙂 . One of such request was to enable automatic login in tisdk. The idea is to lead the user directly to command prompt after kernel boot up. I tried several approaches over weeks, and zeroed in on the following simpler approach.
I am going to run through serious of steps followed to enable auto login in tisdk or embedded linux.
The setup which I used:
Version: TISDK 7.0
Rootfs: Hosted on Network file system on ubuntu [ which is a guest OS on Vmware]
Firstly I need a configuration file for setting username and password. I can just hard code in the tool but want to give user the control.
The configuration file looks like:
Then I wrote a small tool to read the username and password from configuration file and use /bin/login for login to the shell..
// GPL, Author: Johnnie J. Alan
int nrv = 0;
FILE* fptr = 0;
// clear buffer
// open autologin profile file
fptr = fopen(“/etc/autologin.profile\0″,”r\0″);
// make sure the file exists and was opened
if (fptr != 0)
// the return value from fscanf will be 1 if the autologin profile name is read correctly
nrv = fscanf(fptr,”%s,%s\0”,user,pass);
// only autologin if the profile name was read successfully,
// otherwise show the regular login prompt
if (nrv > 0)
nrv = execlp(“login”,”login”,”-f”,user,0);
nrv = execlp(“login”,”login”,”\0″,pass,0);
Note: you can change this according to your needs
I cross compiled the tool for ARM and placed the compiled tool in /sbin
arm-linux-gnueabihf-gcc -o autologin autologin.c
Then I changed the init scripts to reflect the changes, basically setting up getty. My setup uses Uart0 port for console.
The configuration for the console is present in /etc/inittab. The changes which I made is highlighted below.