![]() |
DECS Excel Add-Ins 1.3.0.2
Creates custom buttons in Excel to automate DECS tasks.
|
▼CMicrosoft.Office.Tools.AddInBase | |
CDECS_Excel_Add_Ins.ThisAddIn | |
CDECS_Excel_Add_Ins.Address | Third-level class to deserialize JSON returned from US Census Bureau geocoding service |
CDECS_Excel_Add_Ins.Addressmatch | Second-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.CensusData | Used to deserialize JSON returned from US Census Bureau geocoding service |
CDECS_Excel_Add_Ins.CensusTract | Fourth-level class to deserialize JSON returned from US Census Bureau geocoding service |
CDECS_Excel_Add_Ins.CleaningRule | Defines a single replacement rule |
CDECS_Excel_Add_Ins.DateConversionRule | Defines a single date conversion rule |
CDECS_Excel_Add_Ins.DateConverter | Centralized class for all date conversion methods |
CDECS_Excel_Add_Ins.EnumExtensions | Use fancy Enum descriptions |
CDECS_Excel_Add_Ins.ExtractRule | Defines a single extraction rule |
▼CForm | |
CDECS_Excel_Add_Ins.DefineRulesForm | Form to allow user to define a text-parsing rule |
CDECS_Excel_Add_Ins.RulesErrorForm | |
CDECS_Excel_Add_Ins.StatusForm | Custom form to show processing status |
CDECS_Excel_Add_Ins.Formatter | Class that formats Excel output to look "nice" |
CDECS_Excel_Add_Ins.Geocode | Connects to US Census Bureau's online geocoding service, queries for census info & parses the output |
CDECS_Excel_Add_Ins.Geographies | Third-level class to deserialize JSON returned from US Census Bureau geocoding service |
CDECS_Excel_Add_Ins.Globals | |
CDECS_Excel_Add_Ins.Input | Second-level class to deserialize JSON returned from US Census Bureau geocoding service |
▼COffice.IRibbonExtensibility | |
CDECS_Excel_Add_Ins.DecsExcelRibbon | Main class for DECS Excel Tools |
CDECS_Excel_Add_Ins.ListImporter | Handles importing an Excel column of MRN, ICD codes, etc. into SQL format |
CDECS_Excel_Add_Ins.MumpsDateConverter | Converts MUMPS dates used in Epic to the Excel standard |
CDECS_Excel_Add_Ins.NotesConfig | Defines the way the current workbook & sheet should be parsed |
CDECS_Excel_Add_Ins.NotesParser | Applies rules to worksheet to clean, convert & extract required data |
CDECS_Excel_Add_Ins.ProcessingRowsSelection | Holds information from the user's selection of which rows to process: |
CDECS_Excel_Add_Ins.Properties.Resources | A strongly-typed resource class, for looking up localized strings, etc |
CDECS_Excel_Add_Ins.Result | First-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.RuleGui | A 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.CleaningRuleGui | Specific type of @ RuleGui–representing a data cleaning rule |
CDECS_Excel_Add_Ins.ExtractRuleGui | |
CDECS_Excel_Add_Ins.RuleValidationError | Describes just why & where a rule has been found invalid |
CDECS_Excel_Add_Ins.RuleValidationResult | Describes result of attempting to form a RegEx |
CDECS_Excel_Add_Ins.StopWatchUtils | Computes estimated time of completion. https://stackoverflow.com/a/6822458/18749636 |
CDECS_Excel_Add_Ins.SviProcessor | Main class for AddSVI tool |
CDECS_Excel_Add_Ins.SviScore | Holds both the raw score (from "SPL_THEMES" column) and fractional ranking ("RPL_THEMES") |
CDECS_Excel_Add_Ins.SviTable | Builds & uses a Dictionary that maps the FIPS code to the SVI information |
CDECS_Excel_Add_Ins.Utilities | Useful tools |
CDECS_Excel_Add_Ins.ZipCodeConverter | Builds 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 |