search

closup / process-xbrl

An open source tool to convert ACFRs from Excel to inline XBRL
https://closup.umich.edu/acfr-tool
3 stars 1 forks source link

Replace or generalize contexts.xlsx #2

Closed kwheelan closed 6 months ago

kwheelan commented 1 year ago

The existing code uses contexts.xlsx to translate Excel into xlm, but this sheet includes some hard-coding (like the dates). It seems that this sheet identifies the full context for each sheet-column combination in the Excel sheet. Ideally we would instead have:

  1. A dictionary to relate possible column headers to the appropriate context, scope, statement.
  2. A function to create the xlm code from the relevant inputs