You are here

Home

Categorization spreadsheet

Sat, 2017-12-02 22:10 — Michael Dew
Designed for Windows computers only, not Macs.

Download for $5CAD from https://legaltree.gumroad.com/l/dfqhrj

The Microsoft Excel spreadsheet available for download contains macros that allow the user to rapidly categorize data. This is done by way of a form that allows one-click entering of category labels into a column in Excel. The different categories of data can then be tallied using the Sumif formula, or used in various other ways.

One obvious application for this spreadsheet is to categorize and tally household expenses, but it could be used for any situation in which a user wishes to categorize / label / tag data into 75 or fewer categories. 

An application for this spreadsheet in the legal context is if one has a long list of expenses that one wants to tally into different categories. For example, in a personal injury claim, one may have a long date ordered list of expense receipts for Physio, Chiropractor, Acupuncture, Massage Therapy, etc.  - the spreadsheet could be used to tag each amount and then tally the amounts in each category.

Security issues
The spreadsheet was developed using macros (programmed in visual basic) and in order for the spreadsheet to operate your security settings in Microsoft Excel must be set to allow macros to run.  To enable macros in Excel 2010 (similar procedures will apply in other versions of Excel) click:
  • File (i.e. the menu on the top left)
  • Options
  • Trust Centre
  • Trust Centre Settings
  • Macro settings
  • Enable all macros
 
Macros can pose a security risk because they make your computer perform certain steps automatically, but are typically only dangerous when made to be that way by a computer programmer with a malicious intention – hence the warning when you change the security settings in Excel. However, the macros available in the spreadsheet available for download on this page are made with good intentions and should not harm your computer.
 
Users downloading and using this spreadsheet do so entirely at their own risk and agree to accept all risks associated with using the spreadsheet. 
 
 

 
 

Copyright © 2007-2022 Legaltree Publishing Inc.

Legaltree was founded by Michael Dew, a Vancouver lawyer and is owned and operated by Legaltree Publishing Inc. 

Waiver of liability: All content on www.legaltree.ca is for information only and must not be relied on in any way. No legal advice is sought by browsing this site, and none is given. All links are provided for convenience only and no sites linked to are endorsed.