1) Prototype is in excel [https://docs.google.com/spreadsheet/ccc?key=0AnY88nc-0TsQdElNNjlKMVJHbTk4WnZqTXNwdlhVRnc&usp=sharing]
2) Yellow cells are user input field
3) Look and feel - coloring, cell merge, aggregation function should and usage must be same as excel in Web. on tab out from cell the related cell might recalculated as it does in excel
4) conditional formatting - negative number should be in red.
5) Phases, years should be generated dynamically to allow users to enter the numbers. dynamic columns, rows feature.
6) user input only in numeric (numbers, percentage)
7) Technology - ASP.NET/VB.NET , editable grid with client side feature
8) GIVEN THE DETAILS OF THE REQUIREMENT. THIS PROJECT SHOULD BE COMPLETED IN 5 DAYS