Build Excel add-in code from Python library

[mjclawar]

Description

Create a script that generates the Excel add-in code needed for user-defined functions in Excel for arrays and single-value queries.

For example...
To generate STRATODEM.MEDIAN_HOUSEHOLD_INCOME_FOR_METRO, ideally we could define the API query structure needed in Python, then generate all versions of this query (metros, counties, states, ZIP codes, tracts, mile radius, drive time, etc.).

Functions to support off the shelf

• Median household income (total and by age of householder)
• Number of households by age
• Number of households by age and by income
• Median net worth (total and by age of householder)
• Number of households by age and by net worth
• Median home value (total and by age of householder)
• Number of owner-occupied units by home value
• Homeownership rate (total and by age)
• Net-migration (total and by age)
• Population
• Population by age
• Population by educational attainment level
• Population by age and by educational attainment level
• Population by Census-defined race/ethnicity
• Population by age and by Census-defined race/ethnicity
• Labor force
• Employment
• Unemployment
• Unemployment rate
• Others?