closup / process-xbrl

3 stars 1 forks source link

Remove manual xbrl element columns #3

Closed kwheelan closed 3 months ago

kwheelan commented 9 months ago

The example Excel sheet (from Clayton, CA) has manually inputted categories as highlighted columns in the Excel sheet (XBRL Element column). These elements identify the "name" in each xlm entry, ie. the row in the original Excel data. Instead we could:

  1. Create a dictionary and/or function that translates between official prefix:name and possible labels in Excel sheets. It seems like maybe some version of this existed on the original branch in a file called elements.csv? There are other similar datasheets from XBRL, like this one.
  2. Create a function to systematically insert the correct name into the xlm