![]() |
DECS Excel Add-Ins 1.3.0.2
Creates custom buttons in Excel to automate DECS tasks.
|
| ▼NDECS_Excel_Add_Ins | |
| ▼NProperties | |
| CResources | A strongly-typed resource class, for looking up localized strings, etc |
| CSettings | |
| CAddress | Third-level class to deserialize JSON returned from US Census Bureau geocoding service |
| CAddressmatch | Second-level class to deserialize JSON returned from US Census Bureau geocoding service |
| CCensusData | Used to deserialize JSON returned from US Census Bureau geocoding service |
| CCensusTract | Fourth-level class to deserialize JSON returned from US Census Bureau geocoding service |
| CCleaningRule | Defines a single replacement rule |
| CCleaningRuleGui | Specific type of @ RuleGui–representing a data cleaning rule |
| CDateConversionRule | Defines a single date conversion rule |
| CDateConverter | Centralized class for all date conversion methods |
| CDecsExcelRibbon | Main class for DECS Excel Tools |
| CDefineRulesForm | Form to allow user to define a text-parsing rule |
| CEnumExtensions | Use fancy Enum descriptions |
| CExtractRule | Defines a single extraction rule |
| CExtractRuleGui | |
| CFormatter | Class that formats Excel output to look "nice" |
| CGeocode | Connects to US Census Bureau's online geocoding service, queries for census info & parses the output |
| CGeographies | Third-level class to deserialize JSON returned from US Census Bureau geocoding service |
| CGlobals | |
| CInput | Second-level class to deserialize JSON returned from US Census Bureau geocoding service |
| CListImporter | Handles importing an Excel column of MRN, ICD codes, etc. into SQL format |
| CMumpsDateConverter | Converts MUMPS dates used in Epic to the Excel standard |
| CNotesConfig | Defines the way the current workbook & sheet should be parsed |
| CNotesParser | Applies rules to worksheet to clean, convert & extract required data |
| CProcessingRowsSelection | Holds information from the user's selection of which rows to process: |
| CResult | First-level class to deserialize JSON returned from US Census Bureau geocoding service |
| CRuleGui | 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 |
| CRulesErrorForm | |
| CRuleValidationError | Describes just why & where a rule has been found invalid |
| CRuleValidationResult | Describes result of attempting to form a RegEx |
| CStatusForm | Custom form to show processing status |
| CStopWatchUtils | Computes estimated time of completion. https://stackoverflow.com/a/6822458/18749636 |
| CSviProcessor | Main class for AddSVI tool |
| CSviScore | Holds both the raw score (from "SPL_THEMES" column) and fractional ranking ("RPL_THEMES") |
| CSviTable | Builds & uses a Dictionary that maps the FIPS code to the SVI information |
| CThisAddIn | |
| CThisRibbonCollection | |
| CUtilities | Useful tools |
| CZipCodeConverter | 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 |