DECS Excel Add-Ins 1.3.0.2
Creates custom buttons in Excel to automate DECS tasks.
Loading...
Searching...
No Matches
Package List
Here are the packages with brief descriptions (if available):
[detail level 123]
 NDECS_Excel_Add_Ins
 NProperties
 CResourcesA strongly-typed resource class, for looking up localized strings, etc
 CSettings
 CAddressThird-level class to deserialize JSON returned from US Census Bureau geocoding service
 CAddressmatchSecond-level class to deserialize JSON returned from US Census Bureau geocoding service
 CCensusDataUsed to deserialize JSON returned from US Census Bureau geocoding service
 CCensusTractFourth-level class to deserialize JSON returned from US Census Bureau geocoding service
 CCleaningRuleDefines a single replacement rule
 CCleaningRuleGuiSpecific type of @ RuleGui–representing a data cleaning rule
 CDateConversionRuleDefines a single date conversion rule
 CDateConverterCentralized class for all date conversion methods
 CDecsExcelRibbonMain class for DECS Excel Tools
 CDefineRulesFormForm to allow user to define a text-parsing rule
 CEnumExtensionsUse fancy Enum descriptions
 CExtractRuleDefines a single extraction rule
 CExtractRuleGui
 CFormatterClass that formats Excel output to look "nice"
 CGeocodeConnects to US Census Bureau's online geocoding service, queries for census info & parses the output
 CGeographiesThird-level class to deserialize JSON returned from US Census Bureau geocoding service
 CGlobals
 CInputSecond-level class to deserialize JSON returned from US Census Bureau geocoding service
 CListImporterHandles importing an Excel column of MRN, ICD codes, etc. into SQL format
 CMumpsDateConverterConverts MUMPS dates used in Epic to the Excel standard
 CNotesConfigDefines the way the current workbook & sheet should be parsed
 CNotesParserApplies rules to worksheet to clean, convert & extract required data
 CProcessingRowsSelectionHolds information from the user's selection of which rows to process:
 CResultFirst-level class to deserialize JSON returned from US Census Bureau geocoding service
 CRuleGuiA 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
 CRuleValidationErrorDescribes just why & where a rule has been found invalid
 CRuleValidationResultDescribes result of attempting to form a RegEx
 CStatusFormCustom form to show processing status
 CStopWatchUtilsComputes estimated time of completion. https://stackoverflow.com/a/6822458/18749636
 CSviProcessorMain class for AddSVI tool
 CSviScoreHolds both the raw score (from "SPL_THEMES" column) and fractional ranking ("RPL_THEMES")
 CSviTableBuilds & uses a Dictionary that maps the FIPS code to the SVI information
 CThisAddIn
 CThisRibbonCollection
 CUtilitiesUseful tools
 CZipCodeConverterBuilds 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