DECS_Excel_Add_Ins Namespace Reference

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

Enumerations
enum	DataType { Date , Varchar }
	Some information needs to be encoded in SQL as a date, the rest can use varchar.
enum	RuleComponent { NewColumn , Pattern , Replace }
	Enum to capture whether a GUI component holds NewColumn, Pattern or Replace definitions.
enum	RuleType { Cleaning , Extract }
	What's the purpose of this rule?
enum	LocationSource { Address = 1 , Zip = 2 , Unknown = 0 }
	Are we using full address or just the zip code?