preview

Spreadsheet : The First Commercial Spreadsheet Program

Decent Essays

Before spreadsheet was invented, people used to do and solve calculations on a piece of paper or by calculators (they still use calculators even today). Spreadsheet was invented by Dan Bricklin and Bob Frankston in 1979. Visual calculator was in fact the first commercial spreadsheet program. After it was invented, it made peoples’ life much easier in terms of doing calculations automatically, speeding up the calculations, lots of calculations are done simultaneously and also saving up peoples’ time. Spreadsheets are so important today because many companies and organisations use a lot of spreadsheet models to manipulate complex data/ problems as it contains accurate data. Manipulation of data can be applied to non-numeric data. It is a …show more content…

We need to have sufficient information and right tools for cash flow forecast. Sometimes this cash flowing forecast are likely to be more accurate than other types of complex problem. For example a company started their business with £5,000 and their first month’s sale is £5,500, so their end of sales would be £66,000 and expenses would be £55,440 and their net cash flow is £10,503. Budget can be modelled in a spreadsheet. For a successful budget, a plan is needed. The term budget means that an amount of money given to individuals or groups to be used for a particular purpose. If the business does not check their cost then it may face bankruptcy. If people do not keep track of their budget then they might end up in debt sometime. For example the university tuition fees. The tuition fees are so high that students end up taking loans of £27000-30000. But the students cannot return the loan they took as a result they end up committing suicide or sometimes face mental depression. This happens because they don’t have a budget control and also they don’t keep track of the money they are spending. What-if scenario means changing one variable and seeing what happens to other value. Using what-if, quantities of different components can be changed and the results could be analysed. What-if is similar to goal seeking in spreadsheet. For example an ice cream company would ask their staff “What if we increase ice cream sales in the summer rather

Get Access