Spreadsheet risk




Spreadsheet risk is the risk associated with deriving a materially incorrect value from a spreadsheet application that will be utilized in making a related (usually numerically-based) decision. Examples include the valuation of an asset, the determination of financial accounts, the calculation of medicinal doses, or the size of a load-bearing beam for structural engineering. The risk may arise from inputting erroneous or fraudulent data values, from mistakes (or incorrect changes) within the logic of the spreadsheet or the omission of relevant updates (e.g., out of date exchange rates). Some single-instance errors have exceeded US$1 billion. Because spreadsheet risk is principally linked to the actions (or inaction) of individuals it is defined as a sub-category of operational risk.

Despite this, research carried out by ClusterSeven revealed that around half (48%) of c-level executives and senior managers at firms reporting annual revenues over £50m said there were either no usage controls at all or poorly applied manual processes over the use of spreadsheets at the firms.

In 2013 Thomas Herndon, a graduate student of economics at the University of Massachusetts Amherst found major coding flaws in the spreadsheet used by the economists Carmen Reinhart and Kenneth Rogoff in Growth in a Time of Debt, a very influential 2010 journal article. The Reinhart and Rogoff article was widely used as justification to drive 2010–2013 European austerity programs.

Comments

Post a Comment

Popular posts from this blog

28)Discussed: What to expect on Republic Moment 2021and what not to

India Republic Day -- Republic Day 2021: In 2020it was the agitation up against the Citizenship Amendment Act (CAA). Nowthousands of farmersprimarily from Punjab and Haryanahave been camping at the edges of Delhi for more than eight weeksdemanding the Centre repeal the three farm laws. For your second year in a short periodRepublic Day celebrations inside national capital will be kept under the shadow of strong protests against laws approved by the Centre. In 2020it was the agitation up against the Citizenship Amendment Act (CAA). This timethousands of farmersprimarily from Punjab and Haryanahave been camping at the edges of Delhi for more than eight weeksdemanding the Centre repeal the three farm laws. This specific years Republic Day march will also be the first major community event in pandemic times. What is new this year The case will be pared down in terms of the number of spectatorsthe size of walking in line contingents and other side destinations. The spectator size have be
Read more

Spreadsheet

Image
A spreadsheet is a computer application for organization, analysis and storage of data in tabular form. Spreadsheets were developed as computerized analogs of paper accounting worksheets. The program operates on data entered in cells of a table. Each cell may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells. A spreadsheet may also refer to one such electronic document. Spreadsheet users can adjust any stored value and observe the effects on calculated values. This makes the spreadsheet useful for "what-if" analysis since many cases can be rapidly investigated without manual recalculation. Modern spreadsheet software can have multiple interacting sheets and can display data either as text and numerals or in graphical form. Besides performing basic arithmetic and mathematical functions, modern spreadsheets provide built-in functions for common financial accountancy and statisti
Read more

History

Image
Paper spreadsheets edit The word 'spreadsheet' came from 'spread' in its sense of a newspaper or magazine item (text or graphics) that covers two facing pages, extending across the centerfold and treating the two pages as one large page. The compound word 'spread-sheet' came to mean the format used to present book-keeping ledgers—with columns for categories of expenditures across the top, invoices listed down the left margin, and the amount of each payment in the cell where its row and column intersect—which were, traditionally, a "spread" across facing pages of a bound ledger (book for keeping accounting records) or on oversized sheets of paper (termed 'analysis paper') ruled into rows and columns in that format and approximately twice as wide as ordinary paper. Early implementations edit Batch spreadsheet report generator edit A batch "spreadsheet" is indistinguishable from a batch compiler with added input data, producing an output
Read more