DECS Excel Add-Ins 1.3.0.2
Creates custom buttons in Excel to automate DECS tasks.
Loading...
Searching...
No Matches
Class Hierarchy
This inheritance list is sorted roughly, but not completely, alphabetically:
[detail level 12]
 CMicrosoft.Office.Tools.AddInBase
 CDECS_Excel_Add_Ins.ThisAddIn
 CDECS_Excel_Add_Ins.AddressThird-level class to deserialize JSON returned from US Census Bureau geocoding service
 CDECS_Excel_Add_Ins.AddressmatchSecond-level class to deserialize JSON returned from US Census Bureau geocoding service
 Cglobal.SystemConfiguration.ApplicationSettingsBase
 CDECS_Excel_Add_Ins.Properties.Settings
 CDECS_Excel_Add_Ins.CensusDataUsed to deserialize JSON returned from US Census Bureau geocoding service
 CDECS_Excel_Add_Ins.CensusTractFourth-level class to deserialize JSON returned from US Census Bureau geocoding service
 CDECS_Excel_Add_Ins.CleaningRuleDefines a single replacement rule
 CDECS_Excel_Add_Ins.DateConversionRuleDefines a single date conversion rule
 CDECS_Excel_Add_Ins.DateConverterCentralized class for all date conversion methods
 CDECS_Excel_Add_Ins.EnumExtensionsUse fancy Enum descriptions
 CDECS_Excel_Add_Ins.ExtractRuleDefines a single extraction rule
 CForm
 CDECS_Excel_Add_Ins.DefineRulesFormForm to allow user to define a text-parsing rule
 CDECS_Excel_Add_Ins.RulesErrorForm
 CDECS_Excel_Add_Ins.StatusFormCustom form to show processing status
 CDECS_Excel_Add_Ins.FormatterClass that formats Excel output to look "nice"
 CDECS_Excel_Add_Ins.GeocodeConnects to US Census Bureau's online geocoding service, queries for census info & parses the output
 CDECS_Excel_Add_Ins.GeographiesThird-level class to deserialize JSON returned from US Census Bureau geocoding service
 CDECS_Excel_Add_Ins.Globals
 CDECS_Excel_Add_Ins.InputSecond-level class to deserialize JSON returned from US Census Bureau geocoding service
 COffice.IRibbonExtensibility
 CDECS_Excel_Add_Ins.DecsExcelRibbonMain class for DECS Excel Tools
 CDECS_Excel_Add_Ins.ListImporterHandles importing an Excel column of MRN, ICD codes, etc. into SQL format
 CDECS_Excel_Add_Ins.MumpsDateConverterConverts MUMPS dates used in Epic to the Excel standard
 CDECS_Excel_Add_Ins.NotesConfigDefines the way the current workbook & sheet should be parsed
 CDECS_Excel_Add_Ins.NotesParserApplies rules to worksheet to clean, convert & extract required data
 CDECS_Excel_Add_Ins.ProcessingRowsSelectionHolds information from the user's selection of which rows to process:
 CDECS_Excel_Add_Ins.Properties.ResourcesA strongly-typed resource class, for looking up localized strings, etc
 CDECS_Excel_Add_Ins.ResultFirst-level class to deserialize JSON returned from US Census Bureau geocoding service
 CMicrosoft.Office.Tools.Ribbon.RibbonCollectionBase
 CDECS_Excel_Add_Ins.ThisRibbonCollection
 CDECS_Excel_Add_Ins.RuleGuiA set of controls: two textboxes, a delete button and the panel that contains them all. Meant to be inherited & instantiated by CleaningRule and ExtractRule classes
 CDECS_Excel_Add_Ins.CleaningRuleGuiSpecific type of @ RuleGui–representing a data cleaning rule
 CDECS_Excel_Add_Ins.ExtractRuleGui
 CDECS_Excel_Add_Ins.RuleValidationErrorDescribes just why & where a rule has been found invalid
 CDECS_Excel_Add_Ins.RuleValidationResultDescribes result of attempting to form a RegEx
 CDECS_Excel_Add_Ins.StopWatchUtilsComputes estimated time of completion. https://stackoverflow.com/a/6822458/18749636
 CDECS_Excel_Add_Ins.SviProcessorMain class for AddSVI tool
 CDECS_Excel_Add_Ins.SviScoreHolds both the raw score (from "SPL_THEMES" column) and fractional ranking ("RPL_THEMES")
 CDECS_Excel_Add_Ins.SviTableBuilds & uses a Dictionary that maps the FIPS code to the SVI information
 CDECS_Excel_Add_Ins.UtilitiesUseful tools
 CDECS_Excel_Add_Ins.ZipCodeConverterBuilds a Dictionary<string, List<ulong>> from the nationwide zip code-->census tract file. File available from https://www.huduser.gov/portal/datasets/usps_crosswalk.html