2025 06-June 18 - Marian Coussan - TVA Reporting spreadsheet

Date: 2025 06-June 18

• White columns do not pull from another tab - the yellow and blue columns do
• The Master Workboook - TEM BioRem Data-Calcs-v2.xlsx
• Semi annual reports for maxson's air permit
• Biogas sampling
• Involvement with the TVA report
• Write an automated analyzer to check the xlsx sheet for:
  • sig figs
  • what else?
    Is the BioRem system working as it should? Tanks 1234, the SWG analyzer.
    Download data from analyzer to SD card. Data is loaded, sanitized and converted.

Pages (ehhhhh no this is wrong):

1. Inlet, BioTank 1
2. Tank 2
3. Tank 3
4. Tank 4
5. Tank 5
6. Tank 6, Outlet

• MRU Analyzer fun facts:

|Date|Time|O2 [%]|CO2 [%]|H2S dil. [ppm]|CH4 [%]: Currently seen in SWG100 biogas analyzer SD card data.

Historically seen, but not late.y: |Net cal. val. [MJ/m³]|Gross cal. val. [MJ/m³]|T-sensor [°F]|Balance N2 [%]|Net BTUs [btu/cf]|Gross BTUs [btu/cf]|

The handheld units measure: |O2 [%]|CO2 [%]|H2S dil. [ppm]|CH4 [%]| Net BTUs [btu/cf]|

There is a log book in the shed

Ovation names? Or standard SCADA.

On the left is the raw data pulled from the SWG100 biogas analyzer. On the right of the grey bar is the final averaged per day or the data pulled by hand with the handheld analyzer.

pages 2,3,4,5 is just extra info. Sheets 1 and 6 are reported to the TVA.

BGFLOW1 has not been used in a long time
BGFLOW2 is the biogas to be flared after treartment

• Grab dates June 1st - now from log book

NA means there was no biogas, whereas - means they weren't treating it
NA is for the TVA report and it means something to them.