---
title: "Financial Software: Top 10 Reasons Why a Database Kicks a Spreadsheet’s Butt | Intuitive Analytics"
description: I ve always believed there are actually three certainties in life in contrast to the far less archetypal two death taxes and finance people  love of
---

# Financial Software: Top 10 Reasons Why a Database Kicks a Spreadsheet’s Butt

 Posted by Peter Orr on Jul 16, 2010

I’ve always believed there are actually three certainties in life (in contrast to the far less archetypal two): death, taxes, and finance people’ love of spreadsheets.  Spreadsheets are excellent for doing certain types of work given their flexibility. Though frankly, these “electronic chalkboards” as their inventors called them are simply not the right medium for others. For instance, heavy duty simulation based number crunching and optimization shouldn’t be done on a chalkboard, electronic or otherwise. The memory management and numerics simply aren’t suitably industrial strength for big jobs like that. As a data store the spreadsheet also has drawbacks.  Sure it’s flexible and easy to add new bits, but that same flexibility is a problem when it comes to compatibility and consistency, virtues in and of themselves.

Here’s a top 10 list explaining how a database (sometimes) simply eats a spreadsheet’s lunch:

10) Database is a single, accessible location for complete, accurate information

9) Database offers on-demand distribution of data to professionals in all regional offices in your business

8) Impress your friends by confidently exclaiming, “We’ve implemented a best-practice abstraction of our data from our data format”

7) Easy to connect to a database from a spreadsheet to grab what you need

6) Much harder for an employee to email themselves their fancy, custom database before quitting and going to a competitor 

5) Analytic tools can be built to apply to entire database, increasing accuracy and boosting productivity – BIG time

4) Put your database in the cloud and join the millions of people who talk about cloud computing but only have a very foggy idea of what it is!

3) With a database you have a specific manager providing crystal clear responsibility for data integrity, completeness, and security

2) Sure Excel now has 16,000 columns and a million rows (on Sheet1), but just try and use them all! For gobs and gobs of data, a database is *the* solution, hands down.

And the number 1 reason a database kicks a spreadsheet’s butt is

1) Capturing data in a spreadsheet to run some #s is soooo 90s.  Nowadays you’ve got to apply your fancy numerical recipes to an entire database and auto-email results to your pre-defined audiences – 100x more efficient and *infinitely* cooler!

 

 

### Comments

### Subscribe to our Articles

### Browse by Tag **

- [public finance (17)](https://www.intuitive-analytics.com/blog/topic/public-finance)
- [refunding (15)](https://www.intuitive-analytics.com/blog/topic/refunding)
- [public finance analytics (14)](https://www.intuitive-analytics.com/blog/topic/public-finance-analytics)
- [Financial Decisions (13)](https://www.intuitive-analytics.com/blog/topic/financial-decisions)
- [advance refunding (13)](https://www.intuitive-analytics.com/blog/topic/advance-refunding)
- [bond option (13)](https://www.intuitive-analytics.com/blog/topic/bond-option)
- [public finance software (12)](https://www.intuitive-analytics.com/blog/topic/public-finance-software)
- [call option (11)](https://www.intuitive-analytics.com/blog/topic/call-option)
- [interest rate model (9)](https://www.intuitive-analytics.com/blog/topic/interest-rate-model)
- [municipal finance software (9)](https://www.intuitive-analytics.com/blog/topic/municipal-finance-software)
- [SIFMA (8)](https://www.intuitive-analytics.com/blog/topic/sifma)
- [Financial Models (7)](https://www.intuitive-analytics.com/blog/topic/financial-models)
- [debt structuring (7)](https://www.intuitive-analytics.com/blog/topic/debt-structuring)
- [yield curve modeling (7)](https://www.intuitive-analytics.com/blog/topic/yield-curve-modeling)
- [decision support (6)](https://www.intuitive-analytics.com/blog/topic/decision-support)
- [financial analysis (6)](https://www.intuitive-analytics.com/blog/topic/financial-analysis)
- [financial model (6)](https://www.intuitive-analytics.com/blog/topic/financial-model)
- [libor (6)](https://www.intuitive-analytics.com/blog/topic/libor)
- [refunding efficiency (6)](https://www.intuitive-analytics.com/blog/topic/refunding-efficiency)
- [Finance Professionals (5)](https://www.intuitive-analytics.com/blog/topic/finance-professionals)
- [bond sizing (5)](https://www.intuitive-analytics.com/blog/topic/bond-sizing)
- [financial economy (5)](https://www.intuitive-analytics.com/blog/topic/financial-economy)
- [financial forecasting (5)](https://www.intuitive-analytics.com/blog/topic/financial-forecasting)
- [municipal swaps (5)](https://www.intuitive-analytics.com/blog/topic/municipal-swaps)
- [swaps (5)](https://www.intuitive-analytics.com/blog/topic/swaps)
- [tax-exempt financing (5)](https://www.intuitive-analytics.com/blog/topic/tax-exempt-financing)
- [Financial Software (4)](https://www.intuitive-analytics.com/blog/topic/financial-software)
- [Financial Technology (4)](https://www.intuitive-analytics.com/blog/topic/financial-technology)
- [Wall Street (4)](https://www.intuitive-analytics.com/blog/topic/wall-street)
- [callable bonds (4)](https://www.intuitive-analytics.com/blog/topic/callable-bonds)
- [refunding adjusted yield (4)](https://www.intuitive-analytics.com/blog/topic/refunding-adjusted-yield)
- [risk in finance (4)](https://www.intuitive-analytics.com/blog/topic/risk-in-finance)
- [tax risk (4)](https://www.intuitive-analytics.com/blog/topic/tax-risk)
- [Financial Engineers (3)](https://www.intuitive-analytics.com/blog/topic/financial-engineers)
- [Intuitive Analytics (3)](https://www.intuitive-analytics.com/blog/topic/intuitive-analytics)
- [Risk Management (3)](https://www.intuitive-analytics.com/blog/topic/risk-management)
- [SIFMA/LIBOR (3)](https://www.intuitive-analytics.com/blog/topic/sifmalibor)
- [SIFMA/LIBOR ratios (3)](https://www.intuitive-analytics.com/blog/topic/sifmalibor-ratios)
- [Spreadsheets (3)](https://www.intuitive-analytics.com/blog/topic/spreadsheets)
- [business process (3)](https://www.intuitive-analytics.com/blog/topic/business-process)
- [debt profiling (3)](https://www.intuitive-analytics.com/blog/topic/debt-profiling)
- [hedging (3)](https://www.intuitive-analytics.com/blog/topic/hedging)
- [monte carlo (3)](https://www.intuitive-analytics.com/blog/topic/monte-carlo)
- [press (3)](https://www.intuitive-analytics.com/blog/topic/press)
- [pv savings (3)](https://www.intuitive-analytics.com/blog/topic/pv-savings)
- [refundings (3)](https://www.intuitive-analytics.com/blog/topic/refundings)
- [variable rate (3)](https://www.intuitive-analytics.com/blog/topic/variable-rate)
- [BABs (2)](https://www.intuitive-analytics.com/blog/topic/babs)
- [Behavioral Finance (2)](https://www.intuitive-analytics.com/blog/topic/behavioral-finance)
- [CFaR (2)](https://www.intuitive-analytics.com/blog/topic/cfar)
- [Economist (2)](https://www.intuitive-analytics.com/blog/topic/economist)
- [Financial Services (2)](https://www.intuitive-analytics.com/blog/topic/financial-services)
- [Fischer Black (2)](https://www.intuitive-analytics.com/blog/topic/fischer-black)
- [Investment Banks (2)](https://www.intuitive-analytics.com/blog/topic/investment-banks)
- [Risk Metrics (2)](https://www.intuitive-analytics.com/blog/topic/risk-metrics)
- [Tax and Accounting Issues (2)](https://www.intuitive-analytics.com/blog/topic/tax-and-accounting-issues)
- [build america bonds (2)](https://www.intuitive-analytics.com/blog/topic/build-america-bonds)
- [cash flow at risk (2)](https://www.intuitive-analytics.com/blog/topic/cash-flow-at-risk)
- [database (2)](https://www.intuitive-analytics.com/blog/topic/database)
- [debt service chart (2)](https://www.intuitive-analytics.com/blog/topic/debt-service-chart)
- [financial risk (2)](https://www.intuitive-analytics.com/blog/topic/financial-risk)
- [linear algebra (2)](https://www.intuitive-analytics.com/blog/topic/linear-algebra)
- [muni (2)](https://www.intuitive-analytics.com/blog/topic/muni)
- [municipal default (2)](https://www.intuitive-analytics.com/blog/topic/municipal-default)
- [municipal investor (2)](https://www.intuitive-analytics.com/blog/topic/municipal-investor)
- [probability (2)](https://www.intuitive-analytics.com/blog/topic/probability)
- [public finance marketing (2)](https://www.intuitive-analytics.com/blog/topic/public-finance-marketing)
- [variable rate bonds (2)](https://www.intuitive-analytics.com/blog/topic/variable-rate-bonds)
- [(Un)Calculated Risk (1)](https://www.intuitive-analytics.com/blog/topic/uncalculated-risk)
- [Financial Management (1)](https://www.intuitive-analytics.com/blog/topic/financial-management)
- [Intellectual Property (1)](https://www.intuitive-analytics.com/blog/topic/intellectual-property)
- [Maximum Annual Debt Service (MADS) (1)](https://www.intuitive-analytics.com/blog/topic/maximum-annual-debt-service-mads)
- [Organization for Economic and Co-Operation and Dev (1)](https://www.intuitive-analytics.com/blog/topic/organization-for-economic-and-co-operation-and-dev)
- [Peter Orr (1)](https://www.intuitive-analytics.com/blog/topic/peter-orr)
- [SmartModels Stage III (1)](https://www.intuitive-analytics.com/blog/topic/smartmodels-stage-iii)
- [The Program for International Student Assessment ( (1)](https://www.intuitive-analytics.com/blog/topic/the-program-for-international-student-assessment)
- [Treasury Debt (1)](https://www.intuitive-analytics.com/blog/topic/treasury-debt)
- [VaR (1)](https://www.intuitive-analytics.com/blog/topic/var)
- [Weighted Average Life (1)](https://www.intuitive-analytics.com/blog/topic/weighted-average-life)
- [Win Smith (1)](https://www.intuitive-analytics.com/blog/topic/win-smith)
- [credit (1)](https://www.intuitive-analytics.com/blog/topic/credit)
- [cusip (1)](https://www.intuitive-analytics.com/blog/topic/cusip)
- [debt service graph (1)](https://www.intuitive-analytics.com/blog/topic/debt-service-graph)
- [escrow (1)](https://www.intuitive-analytics.com/blog/topic/escrow)
- [future tax rates (1)](https://www.intuitive-analytics.com/blog/topic/future-tax-rates)
- [interest rate markets (1)](https://www.intuitive-analytics.com/blog/topic/interest-rate-markets)
- [libor swaps (1)](https://www.intuitive-analytics.com/blog/topic/libor-swaps)
- [markets (1)](https://www.intuitive-analytics.com/blog/topic/markets)
- [monte carlo method (1)](https://www.intuitive-analytics.com/blog/topic/monte-carlo-method)
- [monte carlo model (1)](https://www.intuitive-analytics.com/blog/topic/monte-carlo-model)
- [municipal data (1)](https://www.intuitive-analytics.com/blog/topic/municipal-data)
- [negative arbitrage (1)](https://www.intuitive-analytics.com/blog/topic/negative-arbitrage)
- [optimization (1)](https://www.intuitive-analytics.com/blog/topic/optimization)
- [smartmodels utilities (1)](https://www.intuitive-analytics.com/blog/topic/smartmodels-utilities)
- [swaps that swallow town (1)](https://www.intuitive-analytics.com/blog/topic/swaps-that-swallow-town)
- [tax policy (1)](https://www.intuitive-analytics.com/blog/topic/tax-policy)
- [workflow (1)](https://www.intuitive-analytics.com/blog/topic/workflow)

[View all +](https://www.intuitive-analytics.com/blog/bid/26889/Financial-Software-Top-10-Reasons-Why-a-Database-Kicks-a-Spreadsheet-s-Butt#blog-sidebar-tags)