docs: def _get_sheet_metadata(workbook, name):
      """
      Get worksheet metadata. The sheet names tell us what type of table it is and where in the LiPD structure the data
      should be placed.
  
      Example VALID sheet name:
      paleo1measurement1
      paleo1model1ensemble1
      paleo1model1distribution1
  
      Example INVALID sheet names:
      paleo1measurement
      paleo1ensemble
      paleo1_measurement1
  
      NOTE: since each model will only have one ensemble and one summary, they should not have a trailing index number.
  
      :param obj workbook: Excel workbook
      :param str name: Dataset name
      :return dict int int str:
      """
      ct_paleo = 1
      ct_chron = 1
      metadata_str = ""
      sheets = []
      skip_sheets = ["example", "sample", "lists", "guidelines"]
  
      # Check what worksheets are available, so we know how to proceed.
      for sheet in workbook.sheet_names():
  
          # Use this for when we are dealing with older naming styles of "data (qc), data, and chronology"
          old = "".join(sheet.lower().strip().split())
  
          # Don't parse example sheets. If these words are in the sheet, assume we skip them.
          if not any(word in sheet.lower() for word in skip_sheets):
              # Group the related sheets together, so it's easier to place in the metadata later.
              if 'metadata' in sheet.lower():
                  metadata_str = sheet
  
              # Skip the 'about' and 'proxy' sheets altogether. Proceed with all other sheets.
              elif "about" not in sheet.lower() and "proxy" not in sheet.lower():
                  logger_excel.info("creating sheets metadata")
  
                  # If this is a valid sheet name, we will receive a regex object back.
                  m = re.match(re_sheet, sheet.lower())
  
                  # Valid regex object. This is a valid sheet name and we can use that to build the sheet metadata.
                  if m:
                      sheets, paleo_ct, chron_ct = _sheet_meta_from_regex(m, sheets, sheet, name, ct_paleo, ct_chron)
  
                  # Older excel template style: backwards compatibility. Hard coded for one sheet per table.
                  elif old == "data" or "data(qc)" in old or "data(original)" in old:
                      sheets.append({
                          "paleo_chron": "paleo",
                          "idx_pc": ct_paleo,
                          "idx_model": None,
                          "table_type": "measurement",
                          "idx_table": 1,
                          "old_name": sheet,
                          "new_name": sheet,
                          "filename": "paleo{}measurementTable1.csv".format(ct_paleo),
                          "table_name": "paleo{}measurementTable1".format(ct_paleo),
                          "data": ""
                      })
                      ct_paleo += 1
  
                  # Older excel template style: backwards compatibility. Hard coded for one sheet per table.
                  elif old == "chronology":
                      sheets.append({
                          "paleo_chron": "chron",
                          "idx_pc": ct_chron,
                          "idx_model": None,
                          "table_type": "measurement",
                          "idx_table": 1,
                          "old_name": sheet,
                          "new_name": sheet,
                          "filename": "chron{}measurementTable1.csv".format(ct_chron),
                          "table_name": "chron{}measurementTable1".format(ct_chron),
                          "data": ""
                      })
                      ct_chron += 1
                  else:
                      # Sheet name does not conform to standard. Guide user to create a standardized sheet name.
                      print("This sheet name does not conform to naming standard: {}".format(sheet))
                      sheets, paleo_ct, chron_ct = _sheet_meta_from_prompts(sheets, sheet, name, ct_paleo, ct_chron)
  
      return sheets, ct_paleo, ct_chron, metadata_str