![]() |
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 |