I've moved this discussions remarks to the main page encase it was loaded here accidentally --P.Diakow 02:04, 11 February 2010 (UTC)
Overall
Really interesting concept, and huge savings!! That’s amazing. Really good idea how when the user scrolls down the screen, the title remains at the top of the screen.
Most of the edits seem to be in the formatting and flow. It is kind of hard to follow the flow in some places such as the assumptions table. (unsure of where all the numbers were used because there are no hyperlinks.)
One concern is with the inputs. If you start of with 8 servers, then you add 1 in the baseline year, shouldnt every year have an added server?? For year 1 they would then have 9 servers? I might jsut not completely understand what is going on, some maybe in the assumptions there should be a brief explanation of this.
Formatting It may look better to get rid of all of the cell lines (for example click on a vacant cell ctrl+A then fill with white). This just gives a better overall look. Maybe highlight the titles in a different colour, as well as important numbers/concepts or whatever you want to be caught by the eye (projected saving and assumptions have the right idea, more interesting to look at). If you were to print it out (print preview), parts of the text are cut off and moved to a new page. Also maybe put a header for when the sheets are printed. Need hyperlinks between assumptions, calculations and inputs.
Specific Sections
Introduction Save on the introduction tab then post it so when the file is opened, the user is on the introduction tab. Maybe have a hyper link that joins this page to the input page. So instead you could say, click here to input your values and see your savings, and have the click here hyperlinked to the input tab. The intro plot, and tables maybe should have some indication that it is an example of savings, also give the parameters in which this example was calculated. Maybe it is possible to break the opening paragraph up a bit. Have a section for limitations, and one for benefits (kind of like your appropedia page)
* Check spelling in the paragraph, the words disclaimer and deficiencies are misspelled * The page should be printable so that hard copies are available, re-format so that edges are not cut off * White out squares that are not being used, this will look better --P.Diakow 00:42, 11 February 2010 (UTC)
Inputs Why are the blue numbers optional? Maybe include a brief explanation or a hyperlink to the assumptions which explains this.
* Try changing the blue or yellow cells, they are very harsh colors, try something softer * Give an example of how big the average server is so that it's more clear what a typical surface area is * Explain what "Number of servers added (Provisioned)" means * Make it printable, try simply rotating it to a horizontal page * White out cells not being used --P.Diakow 00:51, 11 February 2010 (UTC)
Exec Summary The fonts are noticeably different and it is kind of distracting. Payback- what are the units?
* Include a limitations paragraph at the bottom to explain why the displayed savings may not always apply * In the baseline year for emissions reduction it might be better delete the NA and put zero or simply a dash * Possibly change the font of the cash flow graph, it's a bit hard to read * Possibly change the color of IRR and payback, red seems bad * Make it printable, try simply rotating it to a horizontal page * White out cells not being used --P.Diakow 01:02, 11 February 2010 (UTC)
Projected Savings Need formulas incase the user cannot follow the calculations. Maybe an explanation of why there is only 5 years of calculations (is this the life of a server?). Explanations of some of the calculations such as, Virtual Server License Annual Subscription Cost. What is this? There are a bunch of unfilled cells in the tables? In the environmental effect section and the energy& resource consumption. Include hyperlinks to the assumptions of the constants used for calculations.
* Check spelling personnel and virtualization are misspelled * It does not explain how to get the number of servers after virtualization * Summary of costs has no equations * Net present value is not the right equation, an interest rate was not taken into account, the value will be less * Explain net cash flow with discounting and maybe use a equation somewhere to help those that do not know what it is * The environmental effect section was missing values --P.Diakow 01:57, 11 February 2010 (UTC)
Assumptions/References The links to the internet sites don’t work. Maybe number the assumptions or something it is kind of a confusing table. There is too much empty space, should shrink down the table to avoid all the unused room.
* Use actual references rather than a companies virtualization calculator, or if you are using the site explain how to use it and what assumptions you used when doing calculations. This site could be helpful to businesses however reference it as a external application, and explain that it is a business site which may be biased. * Possibly explain how the cost of power was determined since the reference page did not contain the value you are using anywhere. * Explain the hours of operation calculation * Does it actually have a yearly license cost? * Where did you get the risk free rate of return from? no reference * The CO2 reference seemed a bit odd, the site did not seem professional or official, try finding another source... * Make it printable, try simply rotating it to a horizontal page * White out cells not being used --P.Diakow 01:24, 11 February 2010 (UTC)
I may have sounded harsh however overall the ECM is in good shape, changes just need to be made so that it is business ready. --P.Diakow 01:57, 11 February 2010 (UTC)
Good work!