Full Newsletter   Newsletter Archives

  Stambaugh Ness        SN Financial Strategies         SN Business Solutions   



Printable version 

By Steve Arnold
Stambaugh Ness Database Analyst and Report Writer

Is your spreadsheet system causing you pain?

Do you dread working with your spreadsheets?

Have you lost confidence that your spreadsheets will give you the information you need to run your business operations with confidence?

Maybe it's time to consider working with a database. Additional signs that you may need to begin using a database include:

  • Changes made in one report or document must also be made in others
  • You feel that the amount of data you must manipulate is becoming out of control
  • You are tracking related information, such as sales for different office locations, in several spreadsheets
  • Several of your employees must jockey to see who can view the same information at the same time
  • You must constantly scroll your monitor screen to view your large amount of data
  • You have difficulty viewing the specific sets of data you need

A spreadsheet can handle:

  • Simple lists of data
  • Number crunching and automatic calculations
  • The creation and use of easy charts and graphs
  • The creation of "what-if" scenarios

A database should be used if:

  • Your data must be changed periodically (for example, pricing)
  • You must generate reports based upon your information
  • Related information is an unmanageable amount to use in a spreadsheet
  • You need to maintain records, such as client contact information, for ongoing use


 Save article  Email Firm  Email to a Friend
Is this item worthy of implementation? Yes No Maybe
Is this item worth sharing with other associates? Yes No Maybe
Did this item present value to you and your business? Yes No Maybe
Comments:

Our firm provides the information in this e-newsletter for general guidance only, and does not constitute the provision of legal advice, tax advice, accounting services, investment advice, or professional consulting of any kind. The information provided herein should not be used as a substitute for consultation with professional tax, accounting, legal, or other competent advisers. Before making any decision or taking any action, you should consult a professional adviser who has been provided with all pertinent facts relevant to your particular situation. Tax articles in this e-newsletter are not intended to be used, and cannot be used by any taxpayer, for the purpose of avoiding accuracy-related penalties that may be imposed on the taxpayer. The information is provided "as is," with no assurance or guarantee of completeness, accuracy, or timeliness of the information, and without warranty of any kind, express or implied, including but not limited to warranties of performance, merchantability, and fitness for a particular purpose.

IRS Circular 230 Notice: To ensure compliance with requirements imposed by the IRS, we inform you that any US tax advice contained in this communication is not intended or written to be used, and cannot be used, for the purpose of avoiding penalties under the Internal Revenue Code.

Securities and advisory services offered through Geneos Wealth Management, Inc. Member FINRA/SIPC. Geneos Wealth Management, Inc is not affiliated with Stambaugh Ness.