{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Waste Materials Properties"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import PFAS_SAT_ProcessModels as pspd\n",
    "import pandas as pd\n",
    "pd.set_option('display.max_colwidth', 0)\n",
    "\n",
    "IncomingFlow=pspd.IncomFlow()\n",
    "categories = ['Parameter Name', 'Parameter Description', 'amount', 'unit', 'uncertainty_type',\n",
    "              'loc', 'scale', 'minimum', 'maximum', 'Reference']"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## All the Waste Materials"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1. AFFF: AFFF\n",
      "2. C_DWaste: C_D Waste\n",
      "3. CombustionResiduals: Combustion Residuals\n",
      "4. Compost: Compost\n",
      "5. CompostResiduals: Compost Residuals\n",
      "6. ContactWater: Contact Water\n",
      "7. ContaminatedSoil: Contaminated Soil\n",
      "8. ContaminatedWater: Contaminated Water\n",
      "9. DewateredWWTSolids: Dewatered WWT Solids\n",
      "10. DriedWWTSolids: Dried WWT Solids\n",
      "11. FoodWaste: Food Waste\n",
      "12. LFLeachate: LF Leachate\n",
      "13. MSW: MSW\n",
      "14. ROConcentrate: RO Concentrate\n",
      "15. RawWWTSolids: Raw WWT Solids\n",
      "16. SpentGAC: Spent GAC\n",
      "17. SpentIER: Spent IER\n",
      "18. WWTEffluent: WWT Effluent\n",
      "19. WWTScreenRejects: WWT Screen Rejects\n"
     ]
    }
   ],
   "source": [
    "i = 1\n",
    "sortkeys=sorted(IncomingFlow.WasteMaterialsNameHelper)\n",
    "for key in sortkeys:\n",
    "    print('{}. {}: {}'.format(i, IncomingFlow.WasteMaterialsNameHelper[key], key))\n",
    "    i+=1"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Aqueous Film-Forming Foam Concentrate (AFFF)\n",
    "\n",
    "Aqueous film-forming foam (AFFF) concentrates are used for fire suppression, and the process alternatives considered for its management are shown in following figure. Currently included alternatives for AFFF include SCWO and deep well injection. Thermal treatment and solidification followed by landfill disposal are also potential treatment options that are not included in the current version of the SAT.\n",
    "\n",
    "<img src=\"../Images/WasteMaterials/AFFF_Diagram-v2.jpg\" alt=\"Drawing\" style=\"width: 700px;\"/>"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Aqueous Film-Forming Foam Concentrate Properties\n",
    "\n",
    "#### Assumptions and Limitations\n",
    "1.\tThere are different formulations of AFFF that may have different material properties. Users should be aware of these potential discrepancies.\n",
    "2.\tThe SAT does not currently allow for AFFF to be thermally treated or solidified and subsequently disposed in a landfill. Since these are conventional management systems for AFFF concentrates, they would be beneficial to add to the SAT. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Parameter Name</th>\n",
       "      <th>Parameter Description</th>\n",
       "      <th>amount</th>\n",
       "      <th>unit</th>\n",
       "      <th>uncertainty_type</th>\n",
       "      <th>loc</th>\n",
       "      <th>scale</th>\n",
       "      <th>minimum</th>\n",
       "      <th>maximum</th>\n",
       "      <th>Reference</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>231</th>\n",
       "      <td>density</td>\n",
       "      <td>Density</td>\n",
       "      <td>1.012</td>\n",
       "      <td>kg/L</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>232</th>\n",
       "      <td>PFOA</td>\n",
       "      <td>PFOA concentration</td>\n",
       "      <td>6.580</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.0</td>\n",
       "      <td>7.16</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>233</th>\n",
       "      <td>PFOS</td>\n",
       "      <td>PFOS concentration</td>\n",
       "      <td>45.000</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>36.2</td>\n",
       "      <td>53.80</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>234</th>\n",
       "      <td>PFBA</td>\n",
       "      <td>PFBA concentration</td>\n",
       "      <td>24.400</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>23.6</td>\n",
       "      <td>25.20</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>235</th>\n",
       "      <td>PFPeA</td>\n",
       "      <td>PFPeA concentration</td>\n",
       "      <td>33.000</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>29.4</td>\n",
       "      <td>36.60</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>236</th>\n",
       "      <td>PFHxA</td>\n",
       "      <td>PFHxA concentration</td>\n",
       "      <td>50.700</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>44.1</td>\n",
       "      <td>57.30</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>237</th>\n",
       "      <td>PFHpA</td>\n",
       "      <td>PFHpA concentration</td>\n",
       "      <td>12.300</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.3</td>\n",
       "      <td>14.30</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>238</th>\n",
       "      <td>PFNA</td>\n",
       "      <td>PFNA concentration</td>\n",
       "      <td>0.000</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>239</th>\n",
       "      <td>PFDA</td>\n",
       "      <td>PFDA concentration</td>\n",
       "      <td>0.000</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>240</th>\n",
       "      <td>PFBS</td>\n",
       "      <td>PFBS concentration</td>\n",
       "      <td>2.000</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.8</td>\n",
       "      <td>2.20</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>241</th>\n",
       "      <td>PFHxS</td>\n",
       "      <td>PFHxS concentration</td>\n",
       "      <td>14.500</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.7</td>\n",
       "      <td>16.30</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Parameter Name Parameter Description  amount       unit  uncertainty_type  \\\n",
       "231  density        Density               1.012   kg/L       0                  \n",
       "232  PFOA           PFOA concentration    6.580   10e-6g/kg  4                  \n",
       "233  PFOS           PFOS concentration    45.000  10e-6g/kg  4                  \n",
       "234  PFBA           PFBA concentration    24.400  10e-6g/kg  4                  \n",
       "235  PFPeA          PFPeA concentration   33.000  10e-6g/kg  4                  \n",
       "236  PFHxA          PFHxA concentration   50.700  10e-6g/kg  4                  \n",
       "237  PFHpA          PFHpA concentration   12.300  10e-6g/kg  4                  \n",
       "238  PFNA           PFNA concentration    0.000   10e-6g/kg  0                  \n",
       "239  PFDA           PFDA concentration    0.000   10e-6g/kg  0                  \n",
       "240  PFBS           PFBS concentration    2.000   10e-6g/kg  4                  \n",
       "241  PFHxS          PFHxS concentration   14.500  10e-6g/kg  4                  \n",
       "\n",
       "     loc  scale  minimum  maximum Reference  \n",
       "231 NaN  NaN    NaN      NaN                 \n",
       "232 NaN  NaN     6.0      7.16               \n",
       "233 NaN  NaN     36.2     53.80              \n",
       "234 NaN  NaN     23.6     25.20              \n",
       "235 NaN  NaN     29.4     36.60              \n",
       "236 NaN  NaN     44.1     57.30              \n",
       "237 NaN  NaN     10.3     14.30              \n",
       "238 NaN  NaN    NaN      NaN                 \n",
       "239 NaN  NaN    NaN      NaN                 \n",
       "240 NaN  NaN     1.8      2.20               \n",
       "241 NaN  NaN     12.7     16.30              "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "IncomingFlow.InputData.Data[(IncomingFlow.InputData.Data['Dictonary_Name']=='AFFF')|\\\n",
    "                            (IncomingFlow.InputData.Data['Dictonary_Name']=='AFFF_PFAS')][categories]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Construction and Demolition Waste (C_DWaste)\n",
    "\n",
    "Construction and Demolition (C&D) waste is generated during the construction and demolition of buildings and other infrastructure. It includes a wide variety of waste components including for example, dirt, broken brick and concrete, wallboard, ceiling tile, lumber and other flooring materials, electrical wiring and conduit, plumbing pipes and fixtures, furniture, and carpet. The following figure shows the potential alternatives used to treat C&D waste. C&D waste can be disposed in a dedicated C&D landfill, in MSW landfills, or sometimes by thermal treatment for wastes with a sufficiently high proportion of combustible material  The disposal of C&D waste in C&D landfills is potentially problematic as such landfills are often unlined based on prevailing state regulations. One source of PFAS in C&D waste is PFAS-treated carpet that has been shown to release PFAS in laboratory-scale landfill simulations.\n",
    "\n",
    "<img src=\"../Images/WasteMaterials/CandD_Waste_Diagram-v2.jpg\" alt=\"Drawing\" style=\"width: 700px;\"/>"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Construction and Demolition Waste Properties\n",
    "\n",
    "#### Assumptions and Limitations\n",
    "\n",
    "1.\tC&D waste is a heterogeneous material, and it is therefore important to update the material properties when a different composition is being managed. \n",
    "2.\tThere are also limited PFAS concentration data on different materials in C&D. The PFAS concentrations were measured using extractions and leaching tests and may be biased low due to the presence of PFAS that was not released to the aqueous phase in the test. If additional data on PFAS concentrations in C&D materials becomes available, then the default can be readily updated.\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Parameter Name</th>\n",
       "      <th>Parameter Description</th>\n",
       "      <th>amount</th>\n",
       "      <th>unit</th>\n",
       "      <th>uncertainty_type</th>\n",
       "      <th>loc</th>\n",
       "      <th>scale</th>\n",
       "      <th>minimum</th>\n",
       "      <th>maximum</th>\n",
       "      <th>Reference</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>242</th>\n",
       "      <td>bulk_dens</td>\n",
       "      <td>Bulk density - wet</td>\n",
       "      <td>574.000</td>\n",
       "      <td>kg/m3</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>319.0000</td>\n",
       "      <td>995.000</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243</th>\n",
       "      <td>ts_cont</td>\n",
       "      <td>Total solids content - wet</td>\n",
       "      <td>0.973</td>\n",
       "      <td>fraction wet weight</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.9210</td>\n",
       "      <td>0.958</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>244</th>\n",
       "      <td>VS_cont</td>\n",
       "      <td>VS content - dry</td>\n",
       "      <td>0.827</td>\n",
       "      <td>kg VS/kg TS</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.7692</td>\n",
       "      <td>0.880</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>245</th>\n",
       "      <td>C_cont</td>\n",
       "      <td>Organic C content - dry</td>\n",
       "      <td>0.240</td>\n",
       "      <td>fraction TS</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>246</th>\n",
       "      <td>PFOA</td>\n",
       "      <td>PFOA concentration</td>\n",
       "      <td>0.600</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>247</th>\n",
       "      <td>PFOS</td>\n",
       "      <td>PFOS concentration</td>\n",
       "      <td>1.970</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>248</th>\n",
       "      <td>PFBA</td>\n",
       "      <td>PFBA concentration</td>\n",
       "      <td>0.000</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>249</th>\n",
       "      <td>PFPeA</td>\n",
       "      <td>PFPeA concentration</td>\n",
       "      <td>0.000</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>250</th>\n",
       "      <td>PFHxA</td>\n",
       "      <td>PFHxA concentration</td>\n",
       "      <td>0.000</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>251</th>\n",
       "      <td>PFHpA</td>\n",
       "      <td>PFHpA concentration</td>\n",
       "      <td>0.000</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>252</th>\n",
       "      <td>PFNA</td>\n",
       "      <td>PFNA concentration</td>\n",
       "      <td>0.000</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>253</th>\n",
       "      <td>PFDA</td>\n",
       "      <td>PFDA concentration</td>\n",
       "      <td>0.000</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>254</th>\n",
       "      <td>PFBS</td>\n",
       "      <td>PFBS concentration</td>\n",
       "      <td>0.000</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>255</th>\n",
       "      <td>PFHxS</td>\n",
       "      <td>PFHxS concentration</td>\n",
       "      <td>0.000</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Parameter Name       Parameter Description   amount                 unit  \\\n",
       "242  bulk_dens      Bulk density - wet          574.000  kg/m3                 \n",
       "243  ts_cont        Total solids content - wet  0.973    fraction wet weight   \n",
       "244  VS_cont        VS content - dry            0.827    kg VS/kg TS           \n",
       "245  C_cont         Organic C content - dry     0.240    fraction TS           \n",
       "246  PFOA           PFOA concentration          0.600    10e-6g/kg             \n",
       "247  PFOS           PFOS concentration          1.970    10e-6g/kg             \n",
       "248  PFBA           PFBA concentration          0.000    10e-6g/kg             \n",
       "249  PFPeA          PFPeA concentration         0.000    10e-6g/kg             \n",
       "250  PFHxA          PFHxA concentration         0.000    10e-6g/kg             \n",
       "251  PFHpA          PFHpA concentration         0.000    10e-6g/kg             \n",
       "252  PFNA           PFNA concentration          0.000    10e-6g/kg             \n",
       "253  PFDA           PFDA concentration          0.000    10e-6g/kg             \n",
       "254  PFBS           PFBS concentration          0.000    10e-6g/kg             \n",
       "255  PFHxS          PFHxS concentration         0.000    10e-6g/kg             \n",
       "\n",
       "     uncertainty_type  loc  scale   minimum  maximum Reference  \n",
       "242  4                NaN  NaN     319.0000  995.000            \n",
       "243  4                NaN  NaN     0.9210    0.958              \n",
       "244  4                NaN  NaN     0.7692    0.880              \n",
       "245  0                NaN  NaN    NaN       NaN                 \n",
       "246  0                NaN  NaN    NaN       NaN                 \n",
       "247  0                NaN  NaN    NaN       NaN                 \n",
       "248  0                NaN  NaN    NaN       NaN                 \n",
       "249  0                NaN  NaN    NaN       NaN                 \n",
       "250  0                NaN  NaN    NaN       NaN                 \n",
       "251  0                NaN  NaN    NaN       NaN                 \n",
       "252  0                NaN  NaN    NaN       NaN                 \n",
       "253  0                NaN  NaN    NaN       NaN                 \n",
       "254  0                NaN  NaN    NaN       NaN                 \n",
       "255  0                NaN  NaN    NaN       NaN                 "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "IncomingFlow.InputData.Data[(IncomingFlow.InputData.Data['Dictonary_Name']=='C_DWaste')|\\\n",
    "                            (IncomingFlow.InputData.Data['Dictonary_Name']=='C_DWaste_PFAS')][categories]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Combustion Residuals (Thermal Treatment Residuals)\n",
    "\n",
    "Combustion residuals are produced during thermal processing and may include bottom ash, fly ash, and air pollution control (APC) residues. APC residues may include excess lime, reaction products in wet scrubber sludge, activated carbon, and gypsum. In the US, fly ash and bottom ash are typically combined and disposed in a dedicated ash landfill or in an MSW landfill. If a dry APC system is used, then the lime and salts or other residues may be added to this ash as well. \n",
    "\n",
    "\n",
    "\n",
    "<img src=\"../Images/WasteMaterials/Combustion_Residuals_Diagram-v2.jpg\" alt=\"Drawing\" style=\"width: 700px;\"/>"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Combustion Residuals Properties \n",
    "\n",
    "#### Assumptions and Limitations\n",
    "1.\tThe default modeling properties associated with combustion residuals are not currently responsive to the initial feedstocks and the type and operation of the facility (e.g., boiler type, APC system). There is currently little data on the actual disposition of PFAS entering combustion facilities including potential transformations and mineralization. \n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Parameter Name</th>\n",
       "      <th>Parameter Description</th>\n",
       "      <th>amount</th>\n",
       "      <th>unit</th>\n",
       "      <th>uncertainty_type</th>\n",
       "      <th>loc</th>\n",
       "      <th>scale</th>\n",
       "      <th>minimum</th>\n",
       "      <th>maximum</th>\n",
       "      <th>Reference</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>bulk_dens</td>\n",
       "      <td>Bulk density - wet</td>\n",
       "      <td>1000.0000</td>\n",
       "      <td>kg/m3</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>ts_cont</td>\n",
       "      <td>Total solids content - wet</td>\n",
       "      <td>0.8500</td>\n",
       "      <td>fraction wet weight</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>C_cont</td>\n",
       "      <td>Organic C content - dry</td>\n",
       "      <td>0.5000</td>\n",
       "      <td>fraction TS</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>PFOA</td>\n",
       "      <td>PFOA concentration</td>\n",
       "      <td>0.0001</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.003</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>PFOS</td>\n",
       "      <td>PFOS concentration</td>\n",
       "      <td>0.0001</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.003</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>PFBA</td>\n",
       "      <td>PFBA concentration</td>\n",
       "      <td>0.0001</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.003</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>PFPeA</td>\n",
       "      <td>PFPeA concentration</td>\n",
       "      <td>0.0001</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.003</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>PFHxA</td>\n",
       "      <td>PFHxA concentration</td>\n",
       "      <td>0.0001</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.003</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>PFHpA</td>\n",
       "      <td>PFHpA concentration</td>\n",
       "      <td>0.0001</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.003</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>PFNA</td>\n",
       "      <td>PFNA concentration</td>\n",
       "      <td>0.0001</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.003</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>PFDA</td>\n",
       "      <td>PFDA concentration</td>\n",
       "      <td>0.0001</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.003</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>PFBS</td>\n",
       "      <td>PFBS concentration</td>\n",
       "      <td>0.0001</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.003</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>PFHxS</td>\n",
       "      <td>PFHxS concentration</td>\n",
       "      <td>0.0001</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.003</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Parameter Name       Parameter Description     amount                 unit  \\\n",
       "82  bulk_dens      Bulk density - wet          1000.0000  kg/m3                 \n",
       "83  ts_cont        Total solids content - wet  0.8500     fraction wet weight   \n",
       "84  C_cont         Organic C content - dry     0.5000     fraction TS           \n",
       "85  PFOA           PFOA concentration          0.0001     10e-6g/kg             \n",
       "86  PFOS           PFOS concentration          0.0001     10e-6g/kg             \n",
       "87  PFBA           PFBA concentration          0.0001     10e-6g/kg             \n",
       "88  PFPeA          PFPeA concentration         0.0001     10e-6g/kg             \n",
       "89  PFHxA          PFHxA concentration         0.0001     10e-6g/kg             \n",
       "90  PFHpA          PFHpA concentration         0.0001     10e-6g/kg             \n",
       "91  PFNA           PFNA concentration          0.0001     10e-6g/kg             \n",
       "92  PFDA           PFDA concentration          0.0001     10e-6g/kg             \n",
       "93  PFBS           PFBS concentration          0.0001     10e-6g/kg             \n",
       "94  PFHxS          PFHxS concentration         0.0001     10e-6g/kg             \n",
       "\n",
       "    uncertainty_type  loc  scale  minimum  maximum Reference  \n",
       "82  0                NaN  NaN    NaN      NaN                 \n",
       "83  0                NaN  NaN    NaN      NaN                 \n",
       "84  0                NaN  NaN    NaN      NaN                 \n",
       "85  4                NaN  NaN     0.0      0.003              \n",
       "86  4                NaN  NaN     0.0      0.003              \n",
       "87  4                NaN  NaN     0.0      0.003              \n",
       "88  4                NaN  NaN     0.0      0.003              \n",
       "89  4                NaN  NaN     0.0      0.003              \n",
       "90  4                NaN  NaN     0.0      0.003              \n",
       "91  4                NaN  NaN     0.0      0.003              \n",
       "92  4                NaN  NaN     0.0      0.003              \n",
       "93  4                NaN  NaN     0.0      0.003              \n",
       "94  4                NaN  NaN     0.0      0.003              "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "IncomingFlow.InputData.Data[(IncomingFlow.InputData.Data['Dictonary_Name']=='CombustionResiduals')|\\\n",
    "                            (IncomingFlow.InputData.Data['Dictonary_Name']=='CombustionResiduals_PFAS')][categories]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Compost\n",
    "\n",
    "Finished compost (i.e., the product) is produced in the composting process. The treatment/management alternatives for finished compost are shown in the following figure. High quality compost may be land applied, but compost may also be used in landfills as alternative daily cover. Landfilling of compost typically occurs because of high contamination rates, a lack of local markets as well as demand from landfills that sometimes need substitutes for soil as a daily cover.\n",
    "\n",
    "\n",
    "<img src=\"../Images/WasteMaterials/Compost.jpg\" alt=\"Drawing\" style=\"width: 700px;\"/>"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Compost Properties \n",
    "\n",
    "There is currently limited data on PFAS in compost and given the large range of potential feedstocks and processes, the values for any specific compost are likely to vary significantly from the default data. The presence of PFAS in finished compost may be attributable to the presence of PFAS on various types of food packaging though further study is required to definitively prove this. Biosolids, if a feedstock for the composting process, are another potentially major contributor to PFAS to finished compost.\n",
    "#### Assumptions and Limitations:\n",
    "The default modeling properties associated with finished compost are not currently responsive to the initial feedstocks and the type and operation of the composting facility (e.g., windrows, mixed systems, Gore systems). With existing data, it is possible to create a mechanistic model for bulk density, solids content, and organic C content, but due to the limited amount of PFAS-related data on compost, it is not currently possible to develop a model that could reasonably estimate PFAS concentrations and partition coefficients mechanistically from incoming feedstocks."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Parameter Name</th>\n",
       "      <th>Parameter Description</th>\n",
       "      <th>amount</th>\n",
       "      <th>unit</th>\n",
       "      <th>uncertainty_type</th>\n",
       "      <th>loc</th>\n",
       "      <th>scale</th>\n",
       "      <th>minimum</th>\n",
       "      <th>maximum</th>\n",
       "      <th>Reference</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>bulk_dens</td>\n",
       "      <td>Bulk density - wet</td>\n",
       "      <td>500.000</td>\n",
       "      <td>kg/m3</td>\n",
       "      <td>5</td>\n",
       "      <td>500.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>400.00</td>\n",
       "      <td>700.00</td>\n",
       "      <td>[48]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>ts_cont</td>\n",
       "      <td>TS content</td>\n",
       "      <td>0.600</td>\n",
       "      <td>kg TS/kg</td>\n",
       "      <td>5</td>\n",
       "      <td>0.600</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.45</td>\n",
       "      <td>0.65</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>VS_cont</td>\n",
       "      <td>VS content - dry</td>\n",
       "      <td>0.600</td>\n",
       "      <td>kg VS/kg TS</td>\n",
       "      <td>5</td>\n",
       "      <td>0.600</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.40</td>\n",
       "      <td>0.70</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>C_cont</td>\n",
       "      <td>Organic C content - dry</td>\n",
       "      <td>0.280</td>\n",
       "      <td>kg C/kg TS</td>\n",
       "      <td>5</td>\n",
       "      <td>0.280</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.15</td>\n",
       "      <td>0.50</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>PFOA</td>\n",
       "      <td>PFOA concentration</td>\n",
       "      <td>5.240</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>5</td>\n",
       "      <td>5.240</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>26.00</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>PFOS</td>\n",
       "      <td>PFOS concentration</td>\n",
       "      <td>7.375</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>5</td>\n",
       "      <td>7.375</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>88.50</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>PFBA</td>\n",
       "      <td>PFBA concentration</td>\n",
       "      <td>3.267</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>5</td>\n",
       "      <td>3.267</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>12.04</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>PFPeA</td>\n",
       "      <td>PFPeA concentration</td>\n",
       "      <td>3.424</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>5</td>\n",
       "      <td>3.424</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.41</td>\n",
       "      <td>8.59</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>PFHxA</td>\n",
       "      <td>PFHxA concentration</td>\n",
       "      <td>16.407</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>5</td>\n",
       "      <td>16.407</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>61.00</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>PFHpA</td>\n",
       "      <td>PFHpA concentration</td>\n",
       "      <td>0.826</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>5</td>\n",
       "      <td>0.826</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>6.50</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>PFNA</td>\n",
       "      <td>PFNA concentration</td>\n",
       "      <td>1.045</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>5</td>\n",
       "      <td>1.045</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>8.10</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>PFDA</td>\n",
       "      <td>PFDA concentration</td>\n",
       "      <td>2.710</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>5</td>\n",
       "      <td>2.710</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>20.50</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>PFBS</td>\n",
       "      <td>PFBS concentration</td>\n",
       "      <td>7.360</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>5</td>\n",
       "      <td>7.360</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>41.90</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>PFHxS</td>\n",
       "      <td>PFHxS concentration</td>\n",
       "      <td>0.190</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>5</td>\n",
       "      <td>0.190</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.90</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Parameter Name    Parameter Description   amount         unit  \\\n",
       "14  bulk_dens      Bulk density - wet       500.000  kg/m3         \n",
       "15  ts_cont        TS content               0.600    kg TS/kg      \n",
       "16  VS_cont        VS content - dry         0.600    kg VS/kg TS   \n",
       "17  C_cont         Organic C content - dry  0.280    kg C/kg TS    \n",
       "18  PFOA           PFOA concentration       5.240    10e-6g/kg     \n",
       "19  PFOS           PFOS concentration       7.375    10e-6g/kg     \n",
       "20  PFBA           PFBA concentration       3.267    10e-6g/kg     \n",
       "21  PFPeA          PFPeA concentration      3.424    10e-6g/kg     \n",
       "22  PFHxA          PFHxA concentration      16.407   10e-6g/kg     \n",
       "23  PFHpA          PFHpA concentration      0.826    10e-6g/kg     \n",
       "24  PFNA           PFNA concentration       1.045    10e-6g/kg     \n",
       "25  PFDA           PFDA concentration       2.710    10e-6g/kg     \n",
       "26  PFBS           PFBS concentration       7.360    10e-6g/kg     \n",
       "27  PFHxS          PFHxS concentration      0.190    10e-6g/kg     \n",
       "\n",
       "    uncertainty_type      loc  scale  minimum  maximum Reference  \n",
       "14  5                 500.000 NaN     400.00   700.00   [48]      \n",
       "15  5                 0.600   NaN     0.45     0.65               \n",
       "16  5                 0.600   NaN     0.40     0.70               \n",
       "17  5                 0.280   NaN     0.15     0.50               \n",
       "18  5                 5.240   NaN     0.00     26.00              \n",
       "19  5                 7.375   NaN     0.00     88.50              \n",
       "20  5                 3.267   NaN     0.00     12.04              \n",
       "21  5                 3.424   NaN     0.41     8.59               \n",
       "22  5                 16.407  NaN     0.00     61.00              \n",
       "23  5                 0.826   NaN     0.00     6.50               \n",
       "24  5                 1.045   NaN     0.00     8.10               \n",
       "25  5                 2.710   NaN     0.00     20.50              \n",
       "26  5                 7.360   NaN     0.00     41.90              \n",
       "27  5                 0.190   NaN     0.00     1.90               "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "IncomingFlow.InputData.Data[(IncomingFlow.InputData.Data['Dictonary_Name']=='Compost')|\\\n",
    "                            (IncomingFlow.InputData.Data['Dictonary_Name']=='Compost_PFAS')][categories]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Compost Residuals\n",
    "\n",
    "\n",
    "\n",
    "<img src=\"../Images/WasteMaterials/Compost_Residuals.jpg\" alt=\"Drawing\" style=\"width: 700px;\"/>"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Compost Residuals Properties"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Parameter Name</th>\n",
       "      <th>Parameter Description</th>\n",
       "      <th>amount</th>\n",
       "      <th>unit</th>\n",
       "      <th>uncertainty_type</th>\n",
       "      <th>loc</th>\n",
       "      <th>scale</th>\n",
       "      <th>minimum</th>\n",
       "      <th>maximum</th>\n",
       "      <th>Reference</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>bulk_dens</td>\n",
       "      <td>Bulk density - wet</td>\n",
       "      <td>500.000000</td>\n",
       "      <td>kg/m3</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>ts_cont</td>\n",
       "      <td>Total solids content - wet</td>\n",
       "      <td>0.600000</td>\n",
       "      <td>fraction wet weight</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>VS_cont</td>\n",
       "      <td>VS content - dry</td>\n",
       "      <td>0.600000</td>\n",
       "      <td>kg VS/kg TS</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>C_cont</td>\n",
       "      <td>Organic C content - dry</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>fraction TS</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>PFOA</td>\n",
       "      <td>PFOA concentration</td>\n",
       "      <td>5.400000</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>3</td>\n",
       "      <td>5.400000</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.5</td>\n",
       "      <td>10.3</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>PFOS</td>\n",
       "      <td>PFOS concentration</td>\n",
       "      <td>1.090000</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>3</td>\n",
       "      <td>1.090000</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.4</td>\n",
       "      <td>1.6</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>PFBA</td>\n",
       "      <td>PFBA concentration</td>\n",
       "      <td>6.942857</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>3</td>\n",
       "      <td>6.942857</td>\n",
       "      <td>3.8</td>\n",
       "      <td>2.8</td>\n",
       "      <td>12.0</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>PFPeA</td>\n",
       "      <td>PFPeA concentration</td>\n",
       "      <td>5.967143</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>3</td>\n",
       "      <td>5.967143</td>\n",
       "      <td>2.3</td>\n",
       "      <td>2.7</td>\n",
       "      <td>8.6</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>PFHxA</td>\n",
       "      <td>PFHxA concentration</td>\n",
       "      <td>28.752860</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>3</td>\n",
       "      <td>28.752860</td>\n",
       "      <td>13.1</td>\n",
       "      <td>10.5</td>\n",
       "      <td>49.8</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>PFHpA</td>\n",
       "      <td>PFHpA concentration</td>\n",
       "      <td>0.365714</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>3</td>\n",
       "      <td>0.365714</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.6</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>PFNA</td>\n",
       "      <td>PFNA concentration</td>\n",
       "      <td>0.327143</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>3</td>\n",
       "      <td>0.327143</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.1</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>PFDA</td>\n",
       "      <td>PFDA concentration</td>\n",
       "      <td>0.730000</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>3</td>\n",
       "      <td>0.730000</td>\n",
       "      <td>1.1</td>\n",
       "      <td>0.1</td>\n",
       "      <td>3.2</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>PFBS</td>\n",
       "      <td>PFBS concentration</td>\n",
       "      <td>1.631429</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>3</td>\n",
       "      <td>1.631429</td>\n",
       "      <td>2.7</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7.6</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>PFHxS</td>\n",
       "      <td>PFHxS concentration</td>\n",
       "      <td>0.201429</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>3</td>\n",
       "      <td>0.201429</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.3</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Parameter Name       Parameter Description      amount  \\\n",
       "28  bulk_dens      Bulk density - wet          500.000000   \n",
       "29  ts_cont        Total solids content - wet  0.600000     \n",
       "30  VS_cont        VS content - dry            0.600000     \n",
       "31  C_cont         Organic C content - dry     0.500000     \n",
       "32  PFOA           PFOA concentration          5.400000     \n",
       "33  PFOS           PFOS concentration          1.090000     \n",
       "34  PFBA           PFBA concentration          6.942857     \n",
       "35  PFPeA          PFPeA concentration         5.967143     \n",
       "36  PFHxA          PFHxA concentration         28.752860    \n",
       "37  PFHpA          PFHpA concentration         0.365714     \n",
       "38  PFNA           PFNA concentration          0.327143     \n",
       "39  PFDA           PFDA concentration          0.730000     \n",
       "40  PFBS           PFBS concentration          1.631429     \n",
       "41  PFHxS          PFHxS concentration         0.201429     \n",
       "\n",
       "                   unit  uncertainty_type        loc  scale  minimum  maximum  \\\n",
       "28  kg/m3                0                NaN        NaN    NaN      NaN        \n",
       "29  fraction wet weight  0                NaN        NaN    NaN      NaN        \n",
       "30  kg VS/kg TS          0                NaN        NaN    NaN      NaN        \n",
       "31  fraction TS          0                NaN        NaN    NaN      NaN        \n",
       "32  10e-6g/kg            3                 5.400000   3.0    2.5      10.3      \n",
       "33  10e-6g/kg            3                 1.090000   0.4    0.4      1.6       \n",
       "34  10e-6g/kg            3                 6.942857   3.8    2.8      12.0      \n",
       "35  10e-6g/kg            3                 5.967143   2.3    2.7      8.6       \n",
       "36  10e-6g/kg            3                 28.752860  13.1   10.5     49.8      \n",
       "37  10e-6g/kg            3                 0.365714   1.0    0.0      2.6       \n",
       "38  10e-6g/kg            3                 0.327143   0.4    0.0      1.1       \n",
       "39  10e-6g/kg            3                 0.730000   1.1    0.1      3.2       \n",
       "40  10e-6g/kg            3                 1.631429   2.7    0.0      7.6       \n",
       "41  10e-6g/kg            3                 0.201429   0.1    0.1      0.3       \n",
       "\n",
       "   Reference  \n",
       "28            \n",
       "29            \n",
       "30            \n",
       "31            \n",
       "32            \n",
       "33            \n",
       "34            \n",
       "35            \n",
       "36            \n",
       "37            \n",
       "38            \n",
       "39            \n",
       "40            \n",
       "41            "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "IncomingFlow.InputData.Data[(IncomingFlow.InputData.Data['Dictonary_Name']=='CompostResiduals')|\\\n",
    "                            (IncomingFlow.InputData.Data['Dictonary_Name']=='CompostResiduals_PFAS')][categories]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Contact Water\n",
    "\n",
    "\n",
    "\n",
    "<img src=\"../Images/WasteMaterials/Contact_Water_Diagram-ms.png\" alt=\"Drawing\" style=\"width: 300px;\"/>"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Contact Water Properties"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Parameter Name</th>\n",
       "      <th>Parameter Description</th>\n",
       "      <th>amount</th>\n",
       "      <th>unit</th>\n",
       "      <th>uncertainty_type</th>\n",
       "      <th>loc</th>\n",
       "      <th>scale</th>\n",
       "      <th>minimum</th>\n",
       "      <th>maximum</th>\n",
       "      <th>Reference</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>density</td>\n",
       "      <td>Density</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>kg/L</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>ts_cont</td>\n",
       "      <td>Total solids content - wet</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>fraction wet weight</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>C_cont</td>\n",
       "      <td>Organic C content - dry</td>\n",
       "      <td>0.6000</td>\n",
       "      <td>fraction TS</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>PFOA</td>\n",
       "      <td>PFOA concentration</td>\n",
       "      <td>0.2000</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>PFOS</td>\n",
       "      <td>PFOS concentration</td>\n",
       "      <td>0.0600</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>PFBA</td>\n",
       "      <td>PFBA concentration</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>PFPeA</td>\n",
       "      <td>PFPeA concentration</td>\n",
       "      <td>0.9400</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>PFHxA</td>\n",
       "      <td>PFHxA concentration</td>\n",
       "      <td>4.7600</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>PFHpA</td>\n",
       "      <td>PFHpA concentration</td>\n",
       "      <td>0.2900</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>PFNA</td>\n",
       "      <td>PFNA concentration</td>\n",
       "      <td>0.0300</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>PFDA</td>\n",
       "      <td>PFDA concentration</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>PFBS</td>\n",
       "      <td>PFBS concentration</td>\n",
       "      <td>2.1300</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>PFHxS</td>\n",
       "      <td>PFHxS concentration</td>\n",
       "      <td>0.0115</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Parameter Name       Parameter Description  amount                 unit  \\\n",
       "56  density        Density                     1.0000  kg/L                  \n",
       "57  ts_cont        Total solids content - wet  0.0000  fraction wet weight   \n",
       "58  C_cont         Organic C content - dry     0.6000  fraction TS           \n",
       "59  PFOA           PFOA concentration          0.2000  10e-6g/kg             \n",
       "60  PFOS           PFOS concentration          0.0600  10e-6g/kg             \n",
       "61  PFBA           PFBA concentration          1.0000  10e-6g/kg             \n",
       "62  PFPeA          PFPeA concentration         0.9400  10e-6g/kg             \n",
       "63  PFHxA          PFHxA concentration         4.7600  10e-6g/kg             \n",
       "64  PFHpA          PFHpA concentration         0.2900  10e-6g/kg             \n",
       "65  PFNA           PFNA concentration          0.0300  10e-6g/kg             \n",
       "66  PFDA           PFDA concentration          0.0000  10e-6g/kg             \n",
       "67  PFBS           PFBS concentration          2.1300  10e-6g/kg             \n",
       "68  PFHxS          PFHxS concentration         0.0115  10e-6g/kg             \n",
       "\n",
       "    uncertainty_type  loc  scale  minimum  maximum Reference  \n",
       "56  0                NaN  NaN    NaN      NaN                 \n",
       "57  0                NaN  NaN    NaN      NaN                 \n",
       "58  0                NaN  NaN    NaN      NaN                 \n",
       "59  0                NaN  NaN    NaN      NaN                 \n",
       "60  0                NaN  NaN    NaN      NaN                 \n",
       "61  0                NaN  NaN    NaN      NaN                 \n",
       "62  0                NaN  NaN    NaN      NaN                 \n",
       "63  0                NaN  NaN    NaN      NaN                 \n",
       "64  0                NaN  NaN    NaN      NaN                 \n",
       "65  0                NaN  NaN    NaN      NaN                 \n",
       "66  0                NaN  NaN    NaN      NaN                 \n",
       "67  0                NaN  NaN    NaN      NaN                 \n",
       "68  0                NaN  NaN    NaN      NaN                 "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "IncomingFlow.InputData.Data[(IncomingFlow.InputData.Data['Dictonary_Name']=='ContactWater')|\\\n",
    "                            (IncomingFlow.InputData.Data['Dictonary_Name']=='ContactWater_PFAS')][categories]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Contaminated Soil\n",
    "\n",
    "Soils may become contaminated with PFAS through a variety of processes including AFFF application, or land application of PFAS-contaminated compost or biosolids. The following figure shows the treatment alternatives considered for the management of PFAS-contaminated soils. The soils may be stabilized in place, sent to thermal treatment, or disposed in a landfill. **Given the wide range of types of potential contaminated soil, default values were not developed. To assess contaminated soil, the user needs to provide the necessary material properties. The contaminated material is meant to represent a general contaminated soil that the user can specify.**\n",
    "\n",
    "\n",
    "<img src=\"../Images/WasteMaterials/Contaminated_Soil_Diagram-v2.jpg\" alt=\"Drawing\" style=\"width: 700px;\"/>\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Contaminated Soil Properties\n",
    "\n",
    "#### Assumptions and Limitations\n",
    "1.\tThe PFAS concentration and properties of contaminated soil will vary based on the location, soil, type, local hydrology, and how the soil became contaminated. Thus, **some user knowledge is important to properly represent this waste stream**."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Parameter Name</th>\n",
       "      <th>Parameter Description</th>\n",
       "      <th>amount</th>\n",
       "      <th>unit</th>\n",
       "      <th>uncertainty_type</th>\n",
       "      <th>loc</th>\n",
       "      <th>scale</th>\n",
       "      <th>minimum</th>\n",
       "      <th>maximum</th>\n",
       "      <th>Reference</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>bulk_dens</td>\n",
       "      <td>Bulk density - wet</td>\n",
       "      <td>1175.00</td>\n",
       "      <td>kg/m3</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>900.000</td>\n",
       "      <td>1400.0</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>ts_cont</td>\n",
       "      <td>Total solids content - wet</td>\n",
       "      <td>0.85</td>\n",
       "      <td>fraction wet weight</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>C_cont</td>\n",
       "      <td>Organic C content - dry</td>\n",
       "      <td>0.01</td>\n",
       "      <td>fraction TS</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.005</td>\n",
       "      <td>0.1</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>PFOA</td>\n",
       "      <td>PFOA concentration</td>\n",
       "      <td>1000.00</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>3000.0</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>PFOS</td>\n",
       "      <td>PFOS concentration</td>\n",
       "      <td>1000.00</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>3000.0</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>PFBA</td>\n",
       "      <td>PFBA concentration</td>\n",
       "      <td>1000.00</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>3000.0</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>PFPeA</td>\n",
       "      <td>PFPeA concentration</td>\n",
       "      <td>1000.00</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>3000.0</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>PFHxA</td>\n",
       "      <td>PFHxA concentration</td>\n",
       "      <td>1000.00</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>3000.0</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>PFHpA</td>\n",
       "      <td>PFHpA concentration</td>\n",
       "      <td>1000.00</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>3000.0</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>PFNA</td>\n",
       "      <td>PFNA concentration</td>\n",
       "      <td>1000.00</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>3000.0</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>PFDA</td>\n",
       "      <td>PFDA concentration</td>\n",
       "      <td>1000.00</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>3000.0</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>PFBS</td>\n",
       "      <td>PFBS concentration</td>\n",
       "      <td>1000.00</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>3000.0</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>PFHxS</td>\n",
       "      <td>PFHxS concentration</td>\n",
       "      <td>1000.00</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>3000.0</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Parameter Name       Parameter Description   amount                 unit  \\\n",
       "69  bulk_dens      Bulk density - wet          1175.00  kg/m3                 \n",
       "70  ts_cont        Total solids content - wet  0.85     fraction wet weight   \n",
       "71  C_cont         Organic C content - dry     0.01     fraction TS           \n",
       "72  PFOA           PFOA concentration          1000.00  10e-6g/kg             \n",
       "73  PFOS           PFOS concentration          1000.00  10e-6g/kg             \n",
       "74  PFBA           PFBA concentration          1000.00  10e-6g/kg             \n",
       "75  PFPeA          PFPeA concentration         1000.00  10e-6g/kg             \n",
       "76  PFHxA          PFHxA concentration         1000.00  10e-6g/kg             \n",
       "77  PFHpA          PFHpA concentration         1000.00  10e-6g/kg             \n",
       "78  PFNA           PFNA concentration          1000.00  10e-6g/kg             \n",
       "79  PFDA           PFDA concentration          1000.00  10e-6g/kg             \n",
       "80  PFBS           PFBS concentration          1000.00  10e-6g/kg             \n",
       "81  PFHxS          PFHxS concentration         1000.00  10e-6g/kg             \n",
       "\n",
       "    uncertainty_type  loc  scale  minimum  maximum Reference  \n",
       "69  4                NaN  NaN     900.000  1400.0             \n",
       "70  0                NaN  NaN    NaN      NaN                 \n",
       "71  4                NaN  NaN     0.005    0.1                \n",
       "72  4                NaN  NaN     0.000    3000.0             \n",
       "73  4                NaN  NaN     0.000    3000.0             \n",
       "74  4                NaN  NaN     0.000    3000.0             \n",
       "75  4                NaN  NaN     0.000    3000.0             \n",
       "76  4                NaN  NaN     0.000    3000.0             \n",
       "77  4                NaN  NaN     0.000    3000.0             \n",
       "78  4                NaN  NaN     0.000    3000.0             \n",
       "79  4                NaN  NaN     0.000    3000.0             \n",
       "80  4                NaN  NaN     0.000    3000.0             \n",
       "81  4                NaN  NaN     0.000    3000.0             "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "IncomingFlow.InputData.Data[(IncomingFlow.InputData.Data['Dictonary_Name']=='ContaminatedSoil')|\\\n",
    "                            (IncomingFlow.InputData.Data['Dictonary_Name']=='ContaminatedSoil_PFAS')][categories]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Contaminated Water\n",
    "\n",
    "Water may become contaminated with PFAS through a variety of processes including direct releases, AFFF application, or land application of PFAS-contaminated compost or biosolids. The following figure shows that the water may be directly injected into deep wells or treated in conventional or advanced wastewater treatment processes. **Given the wide range of types of potential contaminated water, default values were not developed. To assess contaminated water, the user needs to provide the necessary material properties**. However, landfill leachate and primary and secondary WWT effluent are described in their respective sections. The contaminated water material is meant to represent a general contaminated water stream. \n",
    "\n",
    "\n",
    "<img src=\"../Images/WasteMaterials/ContaminatedWater.jpg\" alt=\"Drawing\" style=\"width: 300px;\"/>"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Contaminated Water Properties\n",
    "\n",
    "#### Assumptions and Limitations\n",
    "1.\tThe PFAS concentration and properties of contaminated vary based on the source. Thus, **some user knowledge is important to properly represent this waste stream.**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Parameter Name</th>\n",
       "      <th>Parameter Description</th>\n",
       "      <th>amount</th>\n",
       "      <th>unit</th>\n",
       "      <th>uncertainty_type</th>\n",
       "      <th>loc</th>\n",
       "      <th>scale</th>\n",
       "      <th>minimum</th>\n",
       "      <th>maximum</th>\n",
       "      <th>Reference</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>108</th>\n",
       "      <td>density</td>\n",
       "      <td>Density</td>\n",
       "      <td>1.000</td>\n",
       "      <td>kg/L</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109</th>\n",
       "      <td>ts_cont</td>\n",
       "      <td>Total solids content - wet</td>\n",
       "      <td>0.005</td>\n",
       "      <td>fraction wet weight</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>110</th>\n",
       "      <td>C_cont</td>\n",
       "      <td>Organic C content - dry</td>\n",
       "      <td>0.500</td>\n",
       "      <td>kg C/kg TS</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>111</th>\n",
       "      <td>PFOA</td>\n",
       "      <td>PFOA concentration</td>\n",
       "      <td>100.000</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>112</th>\n",
       "      <td>PFOS</td>\n",
       "      <td>PFOS concentration</td>\n",
       "      <td>100.000</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>113</th>\n",
       "      <td>PFBA</td>\n",
       "      <td>PFBA concentration</td>\n",
       "      <td>100.000</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>114</th>\n",
       "      <td>PFPeA</td>\n",
       "      <td>PFPeA concentration</td>\n",
       "      <td>100.000</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115</th>\n",
       "      <td>PFHxA</td>\n",
       "      <td>PFHxA concentration</td>\n",
       "      <td>100.000</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>116</th>\n",
       "      <td>PFHpA</td>\n",
       "      <td>PFHpA concentration</td>\n",
       "      <td>100.000</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>117</th>\n",
       "      <td>PFNA</td>\n",
       "      <td>PFNA concentration</td>\n",
       "      <td>100.000</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>118</th>\n",
       "      <td>PFDA</td>\n",
       "      <td>PFDA concentration</td>\n",
       "      <td>100.000</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119</th>\n",
       "      <td>PFBS</td>\n",
       "      <td>PFBS concentration</td>\n",
       "      <td>100.000</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>120</th>\n",
       "      <td>PFHxS</td>\n",
       "      <td>PFHxS concentration</td>\n",
       "      <td>100.000</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Parameter Name       Parameter Description   amount                 unit  \\\n",
       "108  density        Density                     1.000    kg/L                  \n",
       "109  ts_cont        Total solids content - wet  0.005    fraction wet weight   \n",
       "110  C_cont         Organic C content - dry     0.500    kg C/kg TS            \n",
       "111  PFOA           PFOA concentration          100.000  10e-6g/kg             \n",
       "112  PFOS           PFOS concentration          100.000  10e-6g/kg             \n",
       "113  PFBA           PFBA concentration          100.000  10e-6g/kg             \n",
       "114  PFPeA          PFPeA concentration         100.000  10e-6g/kg             \n",
       "115  PFHxA          PFHxA concentration         100.000  10e-6g/kg             \n",
       "116  PFHpA          PFHpA concentration         100.000  10e-6g/kg             \n",
       "117  PFNA           PFNA concentration          100.000  10e-6g/kg             \n",
       "118  PFDA           PFDA concentration          100.000  10e-6g/kg             \n",
       "119  PFBS           PFBS concentration          100.000  10e-6g/kg             \n",
       "120  PFHxS          PFHxS concentration         100.000  10e-6g/kg             \n",
       "\n",
       "     uncertainty_type  loc  scale  minimum  maximum Reference  \n",
       "108  0                NaN  NaN    NaN      NaN                 \n",
       "109  0                NaN  NaN    NaN      NaN                 \n",
       "110  0                NaN  NaN    NaN      NaN                 \n",
       "111  4                NaN  NaN     10.0     1000.0             \n",
       "112  0                NaN  NaN    NaN      NaN                 \n",
       "113  0                NaN  NaN    NaN      NaN                 \n",
       "114  0                NaN  NaN    NaN      NaN                 \n",
       "115  0                NaN  NaN    NaN      NaN                 \n",
       "116  0                NaN  NaN    NaN      NaN                 \n",
       "117  0                NaN  NaN    NaN      NaN                 \n",
       "118  0                NaN  NaN    NaN      NaN                 \n",
       "119  0                NaN  NaN    NaN      NaN                 \n",
       "120  0                NaN  NaN    NaN      NaN                 "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "IncomingFlow.InputData.Data[(IncomingFlow.InputData.Data['Dictonary_Name']=='ContaminatedWater')|\\\n",
    "                            (IncomingFlow.InputData.Data['Dictonary_Name']=='ContaminatedWater_PFAS')][categories]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Dewatered WWT Solids \n",
    "\n",
    "\n",
    "\n",
    "<img src=\"../Images/WasteMaterials/WWT_Settling_Solids_Diagram_v3.jpg\" alt=\"Drawing\" style=\"width: 700px;\"/>"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Dewatered WWT Solids Properties"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Parameter Name</th>\n",
       "      <th>Parameter Description</th>\n",
       "      <th>amount</th>\n",
       "      <th>unit</th>\n",
       "      <th>uncertainty_type</th>\n",
       "      <th>loc</th>\n",
       "      <th>scale</th>\n",
       "      <th>minimum</th>\n",
       "      <th>maximum</th>\n",
       "      <th>Reference</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>134</th>\n",
       "      <td>bulk_dens</td>\n",
       "      <td>Bulk density - wet</td>\n",
       "      <td>800.000000</td>\n",
       "      <td>kg/m3</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>135</th>\n",
       "      <td>ts_cont</td>\n",
       "      <td>Total solids content - wet</td>\n",
       "      <td>0.200000</td>\n",
       "      <td>fraction wet weight</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>136</th>\n",
       "      <td>VS_cont</td>\n",
       "      <td>VS content - dry</td>\n",
       "      <td>0.600000</td>\n",
       "      <td>kg VS/kg TS</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>137</th>\n",
       "      <td>C_cont</td>\n",
       "      <td>Organic C content - dry</td>\n",
       "      <td>0.380000</td>\n",
       "      <td>fraction TS</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.30000</td>\n",
       "      <td>0.45000</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>138</th>\n",
       "      <td>PFOA</td>\n",
       "      <td>PFOA concentration</td>\n",
       "      <td>0.934565</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>5</td>\n",
       "      <td>0.934565</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.13008</td>\n",
       "      <td>3.98008</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>139</th>\n",
       "      <td>PFOS</td>\n",
       "      <td>PFOS concentration</td>\n",
       "      <td>3.678926</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>5</td>\n",
       "      <td>3.678926</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.53208</td>\n",
       "      <td>11.30008</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>140</th>\n",
       "      <td>PFBA</td>\n",
       "      <td>PFBA concentration</td>\n",
       "      <td>0.146226</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>5</td>\n",
       "      <td>0.146226</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00008</td>\n",
       "      <td>0.98008</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>141</th>\n",
       "      <td>PFPeA</td>\n",
       "      <td>PFPeA concentration</td>\n",
       "      <td>0.365103</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>5</td>\n",
       "      <td>0.365103</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00008</td>\n",
       "      <td>4.98008</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>142</th>\n",
       "      <td>PFHxA</td>\n",
       "      <td>PFHxA concentration</td>\n",
       "      <td>0.511518</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>5</td>\n",
       "      <td>0.511518</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00008</td>\n",
       "      <td>2.26008</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>143</th>\n",
       "      <td>PFHpA</td>\n",
       "      <td>PFHpA concentration</td>\n",
       "      <td>0.088188</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>5</td>\n",
       "      <td>0.088188</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00008</td>\n",
       "      <td>0.86808</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>144</th>\n",
       "      <td>PFNA</td>\n",
       "      <td>PFNA concentration</td>\n",
       "      <td>0.373149</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>5</td>\n",
       "      <td>0.373149</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00008</td>\n",
       "      <td>1.34208</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>145</th>\n",
       "      <td>PFDA</td>\n",
       "      <td>PFDA concentration</td>\n",
       "      <td>1.552180</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>5</td>\n",
       "      <td>1.552180</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.13928</td>\n",
       "      <td>16.86008</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>146</th>\n",
       "      <td>PFBS</td>\n",
       "      <td>PFBS concentration</td>\n",
       "      <td>0.125018</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>5</td>\n",
       "      <td>0.125018</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00008</td>\n",
       "      <td>1.59408</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>147</th>\n",
       "      <td>PFHxS</td>\n",
       "      <td>PFHxS concentration</td>\n",
       "      <td>0.107265</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>5</td>\n",
       "      <td>0.107265</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00008</td>\n",
       "      <td>0.55608</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Parameter Name       Parameter Description      amount  \\\n",
       "134  bulk_dens      Bulk density - wet          800.000000   \n",
       "135  ts_cont        Total solids content - wet  0.200000     \n",
       "136  VS_cont        VS content - dry            0.600000     \n",
       "137  C_cont         Organic C content - dry     0.380000     \n",
       "138  PFOA           PFOA concentration          0.934565     \n",
       "139  PFOS           PFOS concentration          3.678926     \n",
       "140  PFBA           PFBA concentration          0.146226     \n",
       "141  PFPeA          PFPeA concentration         0.365103     \n",
       "142  PFHxA          PFHxA concentration         0.511518     \n",
       "143  PFHpA          PFHpA concentration         0.088188     \n",
       "144  PFNA           PFNA concentration          0.373149     \n",
       "145  PFDA           PFDA concentration          1.552180     \n",
       "146  PFBS           PFBS concentration          0.125018     \n",
       "147  PFHxS          PFHxS concentration         0.107265     \n",
       "\n",
       "                    unit  uncertainty_type       loc  scale  minimum  \\\n",
       "134  kg/m3                0                NaN       NaN    NaN        \n",
       "135  fraction wet weight  0                NaN       NaN    NaN        \n",
       "136  kg VS/kg TS          0                NaN       NaN    NaN        \n",
       "137  fraction TS          0                NaN       NaN     0.30000   \n",
       "138  10e-6g/kg            5                 0.934565 NaN     0.13008   \n",
       "139  10e-6g/kg            5                 3.678926 NaN     0.53208   \n",
       "140  10e-6g/kg            5                 0.146226 NaN     0.00008   \n",
       "141  10e-6g/kg            5                 0.365103 NaN     0.00008   \n",
       "142  10e-6g/kg            5                 0.511518 NaN     0.00008   \n",
       "143  10e-6g/kg            5                 0.088188 NaN     0.00008   \n",
       "144  10e-6g/kg            5                 0.373149 NaN     0.00008   \n",
       "145  10e-6g/kg            5                 1.552180 NaN     0.13928   \n",
       "146  10e-6g/kg            5                 0.125018 NaN     0.00008   \n",
       "147  10e-6g/kg            5                 0.107265 NaN     0.00008   \n",
       "\n",
       "      maximum Reference  \n",
       "134 NaN                  \n",
       "135 NaN                  \n",
       "136 NaN                  \n",
       "137  0.45000             \n",
       "138  3.98008             \n",
       "139  11.30008            \n",
       "140  0.98008             \n",
       "141  4.98008             \n",
       "142  2.26008             \n",
       "143  0.86808             \n",
       "144  1.34208             \n",
       "145  16.86008            \n",
       "146  1.59408             \n",
       "147  0.55608             "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "IncomingFlow.InputData.Data[(IncomingFlow.InputData.Data['Dictonary_Name']=='DewateredWWTSolids')|\\\n",
    "                            (IncomingFlow.InputData.Data['Dictonary_Name']=='DewateredWWTSolids_PFAS')][categories]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Dried WWT Solids\n",
    "\n",
    "\n",
    "\n",
    "<img src=\"../Images/WasteMaterials/WWT_Settling_Solids_Diagram_v3.jpg\" alt=\"Drawing\" style=\"width: 700px;\"/>"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Dried WWT Solids Properties"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Parameter Name</th>\n",
       "      <th>Parameter Description</th>\n",
       "      <th>amount</th>\n",
       "      <th>unit</th>\n",
       "      <th>uncertainty_type</th>\n",
       "      <th>loc</th>\n",
       "      <th>scale</th>\n",
       "      <th>minimum</th>\n",
       "      <th>maximum</th>\n",
       "      <th>Reference</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>148</th>\n",
       "      <td>bulk_dens</td>\n",
       "      <td>Bulk density - wet</td>\n",
       "      <td>800.000000</td>\n",
       "      <td>kg/m3</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>149</th>\n",
       "      <td>ts_cont</td>\n",
       "      <td>Total solids content - wet</td>\n",
       "      <td>0.900000</td>\n",
       "      <td>fraction wet weight</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150</th>\n",
       "      <td>VS_cont</td>\n",
       "      <td>VS content - dry</td>\n",
       "      <td>0.600000</td>\n",
       "      <td>kg VS/kg TS</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>151</th>\n",
       "      <td>C_cont</td>\n",
       "      <td>Organic C content - dry</td>\n",
       "      <td>0.380000</td>\n",
       "      <td>fraction TS</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>152</th>\n",
       "      <td>PFOA</td>\n",
       "      <td>PFOA concentration</td>\n",
       "      <td>4.205191</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>5</td>\n",
       "      <td>4.205191</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.58501</td>\n",
       "      <td>17.91001</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>153</th>\n",
       "      <td>PFOS</td>\n",
       "      <td>PFOS concentration</td>\n",
       "      <td>16.554818</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>5</td>\n",
       "      <td>16.554818</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.39401</td>\n",
       "      <td>50.85001</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>154</th>\n",
       "      <td>PFBA</td>\n",
       "      <td>PFBA concentration</td>\n",
       "      <td>0.657668</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>5</td>\n",
       "      <td>0.657668</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00001</td>\n",
       "      <td>4.41001</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>155</th>\n",
       "      <td>PFPeA</td>\n",
       "      <td>PFPeA concentration</td>\n",
       "      <td>1.642614</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>5</td>\n",
       "      <td>1.642614</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00001</td>\n",
       "      <td>22.41001</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>156</th>\n",
       "      <td>PFHxA</td>\n",
       "      <td>PFHxA concentration</td>\n",
       "      <td>2.301483</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>5</td>\n",
       "      <td>2.301483</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00001</td>\n",
       "      <td>10.17001</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>157</th>\n",
       "      <td>PFHpA</td>\n",
       "      <td>PFHpA concentration</td>\n",
       "      <td>0.396495</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>5</td>\n",
       "      <td>0.396495</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00001</td>\n",
       "      <td>3.90601</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158</th>\n",
       "      <td>PFNA</td>\n",
       "      <td>PFNA concentration</td>\n",
       "      <td>1.678822</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>5</td>\n",
       "      <td>1.678822</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00001</td>\n",
       "      <td>6.03901</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>159</th>\n",
       "      <td>PFDA</td>\n",
       "      <td>PFDA concentration</td>\n",
       "      <td>6.984460</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>5</td>\n",
       "      <td>6.984460</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.62641</td>\n",
       "      <td>75.87001</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>160</th>\n",
       "      <td>PFBS</td>\n",
       "      <td>PFBS concentration</td>\n",
       "      <td>0.562233</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>5</td>\n",
       "      <td>0.562233</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00001</td>\n",
       "      <td>7.17301</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>161</th>\n",
       "      <td>PFHxS</td>\n",
       "      <td>PFHxS concentration</td>\n",
       "      <td>0.482341</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>5</td>\n",
       "      <td>0.482341</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00001</td>\n",
       "      <td>2.50201</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Parameter Name       Parameter Description      amount  \\\n",
       "148  bulk_dens      Bulk density - wet          800.000000   \n",
       "149  ts_cont        Total solids content - wet  0.900000     \n",
       "150  VS_cont        VS content - dry            0.600000     \n",
       "151  C_cont         Organic C content - dry     0.380000     \n",
       "152  PFOA           PFOA concentration          4.205191     \n",
       "153  PFOS           PFOS concentration          16.554818    \n",
       "154  PFBA           PFBA concentration          0.657668     \n",
       "155  PFPeA          PFPeA concentration         1.642614     \n",
       "156  PFHxA          PFHxA concentration         2.301483     \n",
       "157  PFHpA          PFHpA concentration         0.396495     \n",
       "158  PFNA           PFNA concentration          1.678822     \n",
       "159  PFDA           PFDA concentration          6.984460     \n",
       "160  PFBS           PFBS concentration          0.562233     \n",
       "161  PFHxS          PFHxS concentration         0.482341     \n",
       "\n",
       "                    unit  uncertainty_type        loc  scale  minimum  \\\n",
       "148  kg/m3                0                NaN        NaN    NaN        \n",
       "149  fraction wet weight  0                NaN        NaN    NaN        \n",
       "150  kg VS/kg TS          0                NaN        NaN    NaN        \n",
       "151  fraction TS          0                NaN        NaN    NaN        \n",
       "152  10e-6g/kg            5                 4.205191  NaN     0.58501   \n",
       "153  10e-6g/kg            5                 16.554818 NaN     2.39401   \n",
       "154  10e-6g/kg            5                 0.657668  NaN     0.00001   \n",
       "155  10e-6g/kg            5                 1.642614  NaN     0.00001   \n",
       "156  10e-6g/kg            5                 2.301483  NaN     0.00001   \n",
       "157  10e-6g/kg            5                 0.396495  NaN     0.00001   \n",
       "158  10e-6g/kg            5                 1.678822  NaN     0.00001   \n",
       "159  10e-6g/kg            5                 6.984460  NaN     0.62641   \n",
       "160  10e-6g/kg            5                 0.562233  NaN     0.00001   \n",
       "161  10e-6g/kg            5                 0.482341  NaN     0.00001   \n",
       "\n",
       "      maximum Reference  \n",
       "148 NaN                  \n",
       "149 NaN                  \n",
       "150 NaN                  \n",
       "151 NaN                  \n",
       "152  17.91001            \n",
       "153  50.85001            \n",
       "154  4.41001             \n",
       "155  22.41001            \n",
       "156  10.17001            \n",
       "157  3.90601             \n",
       "158  6.03901             \n",
       "159  75.87001            \n",
       "160  7.17301             \n",
       "161  2.50201             "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "IncomingFlow.InputData.Data[(IncomingFlow.InputData.Data['Dictonary_Name']=='DriedWWTSolids')|\\\n",
    "                            (IncomingFlow.InputData.Data['Dictonary_Name']=='DriedWWTSolids_PFAS')][categories]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Food Waste\n",
    "\n",
    "The management alternatives considered for food waste are shown in the following figure. This material can remain in the mixed MSW and be landfilled or incinerated, or it can be separated and composted or treated by anaerobic digestion (AD).\n",
    "\n",
    "\n",
    "<img src=\"../Images/WasteMaterials/Food_Waste-v2.jpg\" alt=\"Drawing\" style=\"width: 700px;\"/>"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Food Waste Properties \n",
    "\n",
    "PFAS has not been measured directly in the organic fraction of MSW, but it has been found in both food packaging and finished compost, so it would be expected to be in these feedstocks as well (Kotthoff et al., 2015; Choi et al., 2019; Lazcano et al., 2020). Food waste represents a large range of materials (e.g., vegetables, meats, coffee grounds, shells) from a variety of sources (e.g., residential, commercial, and industrial). The properties (e.g., solids content, C content, nutrient content) of these different types of food can vary considerably, and they each have different probabilities of being contaminated with PFAS. The heterogeneity of food waste makes it difficult to develop generalized default inputs.\n",
    "\n",
    "#### Assumptions and Limitations\n",
    "1.\tFood waste is heterogeneous, and the current data set does not consider how changes in food waste composition will impact its physical properties and PFAS concentrations. There is also limited PFAS concentration data on food waste. \n",
    "2.\tDefault data are based on the Netherlands and may not be representative of U.S. food waste. The concentrations provided by Noorlander et al. (2011) could be applied to U.S. dietary intake to improve the results. \n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Parameter Name</th>\n",
       "      <th>Parameter Description</th>\n",
       "      <th>amount</th>\n",
       "      <th>unit</th>\n",
       "      <th>uncertainty_type</th>\n",
       "      <th>loc</th>\n",
       "      <th>scale</th>\n",
       "      <th>minimum</th>\n",
       "      <th>maximum</th>\n",
       "      <th>Reference</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>bulk_dens</td>\n",
       "      <td>Bulk density - wet</td>\n",
       "      <td>435.000000</td>\n",
       "      <td>kg/m3</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>200.0</td>\n",
       "      <td>900.00</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>ts_cont</td>\n",
       "      <td>Total solids content - wet</td>\n",
       "      <td>0.200000</td>\n",
       "      <td>fraction wet weight</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>VS_cont</td>\n",
       "      <td>VS content - dry</td>\n",
       "      <td>0.910000</td>\n",
       "      <td>kg VS/kg TS</td>\n",
       "      <td>5</td>\n",
       "      <td>0.91</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.97</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>C_cont</td>\n",
       "      <td>Organic C content - dry</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>fraction TS</td>\n",
       "      <td>5</td>\n",
       "      <td>0.50</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.4</td>\n",
       "      <td>0.60</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>PFOA</td>\n",
       "      <td>PFOA concentration</td>\n",
       "      <td>0.005530</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>PFOS</td>\n",
       "      <td>PFOS concentration</td>\n",
       "      <td>0.009340</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>PFBA</td>\n",
       "      <td>PFBA concentration</td>\n",
       "      <td>0.071521</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>PFPeA</td>\n",
       "      <td>PFPeA concentration</td>\n",
       "      <td>0.011500</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>PFHxA</td>\n",
       "      <td>PFHxA concentration</td>\n",
       "      <td>0.001233</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>PFHpA</td>\n",
       "      <td>PFHpA concentration</td>\n",
       "      <td>0.001855</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>PFNA</td>\n",
       "      <td>PFNA concentration</td>\n",
       "      <td>0.002867</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>PFDA</td>\n",
       "      <td>PFDA concentration</td>\n",
       "      <td>0.003004</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>PFBS</td>\n",
       "      <td>PFBS concentration</td>\n",
       "      <td>0.000450</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>PFHxS</td>\n",
       "      <td>PFHxS concentration</td>\n",
       "      <td>0.002400</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Parameter Name       Parameter Description      amount  \\\n",
       "0   bulk_dens      Bulk density - wet          435.000000   \n",
       "1   ts_cont        Total solids content - wet  0.200000     \n",
       "2   VS_cont        VS content - dry            0.910000     \n",
       "3   C_cont         Organic C content - dry     0.500000     \n",
       "4   PFOA           PFOA concentration          0.005530     \n",
       "5   PFOS           PFOS concentration          0.009340     \n",
       "6   PFBA           PFBA concentration          0.071521     \n",
       "7   PFPeA          PFPeA concentration         0.011500     \n",
       "8   PFHxA          PFHxA concentration         0.001233     \n",
       "9   PFHpA          PFHpA concentration         0.001855     \n",
       "10  PFNA           PFNA concentration          0.002867     \n",
       "11  PFDA           PFDA concentration          0.003004     \n",
       "12  PFBS           PFBS concentration          0.000450     \n",
       "13  PFHxS          PFHxS concentration         0.002400     \n",
       "\n",
       "                   unit  uncertainty_type   loc  scale  minimum  maximum  \\\n",
       "0   kg/m3                4                NaN   NaN     200.0    900.00    \n",
       "1   fraction wet weight  0                NaN   NaN    NaN      NaN        \n",
       "2   kg VS/kg TS          5                 0.91 NaN     0.0      0.97      \n",
       "3   fraction TS          5                 0.50 NaN     0.4      0.60      \n",
       "4   10e-6g/kg            0                NaN   NaN    NaN      NaN        \n",
       "5   10e-6g/kg            0                NaN   NaN    NaN      NaN        \n",
       "6   10e-6g/kg            0                NaN   NaN    NaN      NaN        \n",
       "7   10e-6g/kg            0                NaN   NaN    NaN      NaN        \n",
       "8   10e-6g/kg            0                NaN   NaN    NaN      NaN        \n",
       "9   10e-6g/kg            0                NaN   NaN    NaN      NaN        \n",
       "10  10e-6g/kg            0                NaN   NaN    NaN      NaN        \n",
       "11  10e-6g/kg            0                NaN   NaN    NaN      NaN        \n",
       "12  10e-6g/kg            0                NaN   NaN    NaN      NaN        \n",
       "13  10e-6g/kg            0                NaN   NaN    NaN      NaN        \n",
       "\n",
       "   Reference  \n",
       "0             \n",
       "1             \n",
       "2             \n",
       "3             \n",
       "4             \n",
       "5             \n",
       "6             \n",
       "7             \n",
       "8             \n",
       "9             \n",
       "10            \n",
       "11            \n",
       "12            \n",
       "13            "
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "IncomingFlow.InputData.Data[(IncomingFlow.InputData.Data['Dictonary_Name']=='FoodWaste')|\\\n",
    "                            (IncomingFlow.InputData.Data['Dictonary_Name']=='FoodWaste_PFAS')][categories]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Landfill Leachate\n",
    "\n",
    "PFAS-contaminated landfill leachate is produced through the release and leaching of PFAS from materials disposed in landfills. The following figure shows the alternatives that are considered for the treatment of landfill leachate. The leachate may be treated by on- or off-site WWT, or it may be injected into deep wells. \n",
    "\n",
    "\n",
    "<img src=\"../Images/WasteMaterials/Landfill_Leachate.jpg\" alt=\"Drawing\" style=\"width: 400px;\"/>"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Landfill Leachate Properties\n",
    "\n",
    "The default values represent wet, temperate, and arid landfills with waste of different ages. **If the user is modeling landfill leachate, then it is recommended that they use values that are representative of their specific facility and location where available**. The properties of landfill leachate will vary based on things like the type of waste accepted and the waste age."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Parameter Name</th>\n",
       "      <th>Parameter Description</th>\n",
       "      <th>amount</th>\n",
       "      <th>unit</th>\n",
       "      <th>uncertainty_type</th>\n",
       "      <th>loc</th>\n",
       "      <th>scale</th>\n",
       "      <th>minimum</th>\n",
       "      <th>maximum</th>\n",
       "      <th>Reference</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>density</td>\n",
       "      <td>Density</td>\n",
       "      <td>1.00</td>\n",
       "      <td>kg/L</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.995</td>\n",
       "      <td>1.005</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>ts_cont</td>\n",
       "      <td>Total solids content - wet</td>\n",
       "      <td>0.01</td>\n",
       "      <td>fraction wet weight</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.005</td>\n",
       "      <td>0.050</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>C_cont</td>\n",
       "      <td>Organic C content - dry</td>\n",
       "      <td>0.50</td>\n",
       "      <td>fraction TS</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.300</td>\n",
       "      <td>0.700</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>PFOA</td>\n",
       "      <td>PFOA concentration</td>\n",
       "      <td>5.70</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.300</td>\n",
       "      <td>10.000</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>PFOS</td>\n",
       "      <td>PFOS concentration</td>\n",
       "      <td>0.09</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>PFBA</td>\n",
       "      <td>PFBA concentration</td>\n",
       "      <td>0.75</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>PFPeA</td>\n",
       "      <td>PFPeA concentration</td>\n",
       "      <td>0.68</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102</th>\n",
       "      <td>PFHxA</td>\n",
       "      <td>PFHxA concentration</td>\n",
       "      <td>1.65</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>103</th>\n",
       "      <td>PFHpA</td>\n",
       "      <td>PFHpA concentration</td>\n",
       "      <td>0.55</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>104</th>\n",
       "      <td>PFNA</td>\n",
       "      <td>PFNA concentration</td>\n",
       "      <td>0.05</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>105</th>\n",
       "      <td>PFDA</td>\n",
       "      <td>PFDA concentration</td>\n",
       "      <td>0.03</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>106</th>\n",
       "      <td>PFBS</td>\n",
       "      <td>PFBS concentration</td>\n",
       "      <td>0.19</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107</th>\n",
       "      <td>PFHxS</td>\n",
       "      <td>PFHxS concentration</td>\n",
       "      <td>0.27</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Parameter Name       Parameter Description  amount                 unit  \\\n",
       "95   density        Density                     1.00    kg/L                  \n",
       "96   ts_cont        Total solids content - wet  0.01    fraction wet weight   \n",
       "97   C_cont         Organic C content - dry     0.50    fraction TS           \n",
       "98   PFOA           PFOA concentration          5.70    10e-6g/kg             \n",
       "99   PFOS           PFOS concentration          0.09    10e-6g/kg             \n",
       "100  PFBA           PFBA concentration          0.75    10e-6g/kg             \n",
       "101  PFPeA          PFPeA concentration         0.68    10e-6g/kg             \n",
       "102  PFHxA          PFHxA concentration         1.65    10e-6g/kg             \n",
       "103  PFHpA          PFHpA concentration         0.55    10e-6g/kg             \n",
       "104  PFNA           PFNA concentration          0.05    10e-6g/kg             \n",
       "105  PFDA           PFDA concentration          0.03    10e-6g/kg             \n",
       "106  PFBS           PFBS concentration          0.19    10e-6g/kg             \n",
       "107  PFHxS          PFHxS concentration         0.27    10e-6g/kg             \n",
       "\n",
       "     uncertainty_type  loc  scale  minimum  maximum Reference  \n",
       "95   4                NaN  NaN     0.995    1.005              \n",
       "96   4                NaN  NaN     0.005    0.050              \n",
       "97   4                NaN  NaN     0.300    0.700              \n",
       "98   4                NaN  NaN     0.300    10.000             \n",
       "99   0                NaN  NaN    NaN      NaN                 \n",
       "100  0                NaN  NaN    NaN      NaN                 \n",
       "101  0                NaN  NaN    NaN      NaN                 \n",
       "102  0                NaN  NaN    NaN      NaN                 \n",
       "103  0                NaN  NaN    NaN      NaN                 \n",
       "104  0                NaN  NaN    NaN      NaN                 \n",
       "105  0                NaN  NaN    NaN      NaN                 \n",
       "106  0                NaN  NaN    NaN      NaN                 \n",
       "107  0                NaN  NaN    NaN      NaN                 "
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "IncomingFlow.InputData.Data[(IncomingFlow.InputData.Data['Dictonary_Name']=='LFLeachate')|\\\n",
    "                            (IncomingFlow.InputData.Data['Dictonary_Name']=='LFLeachate_PFAS')][categories]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Municipal Solid Waste (MSW)\n",
    "\n",
    "\n",
    "MSW consists of wastes that are typically managed by municipalities and counties and include waste generated from residential, commercial, industrial (excluding process waste), and institutional sources. The following figure shows the alternatives considered for the management of MSW. The MSW may be landfilled or thermally treated. MSW consists of variety of different materials including food, paper, food packaging, textiles, and plastics with different material properties and the potential to contain different amounts and types of PFAS. \n",
    "\n",
    "\n",
    "<img src=\"../Images/WasteMaterials/MSW_Residuals_Diagram-v2.jpg\" alt=\"Drawing\" style=\"width: 700px;\"/>"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### MSW Properties \n",
    "\n",
    "#### Assumptions and Limitations\n",
    "1.\tMSW is a heterogeneous material and it is therefore important to update the material properties when a different composition of MSW is being managed. \n",
    "2.\tThere is limited PFAS concentration data on different materials in MSW. The PFAS concentrations for carpets and rugs, food, textiles and bulky concentrations were measured using extractions and leaching tests and may be biased low due to the presence of PFAS that was not released to the aqueous phase in the test. If additional data on PFAS concentrations in MSW materials becomes available, then the default data can be updated.  \n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Parameter Name</th>\n",
       "      <th>Parameter Description</th>\n",
       "      <th>amount</th>\n",
       "      <th>unit</th>\n",
       "      <th>uncertainty_type</th>\n",
       "      <th>loc</th>\n",
       "      <th>scale</th>\n",
       "      <th>minimum</th>\n",
       "      <th>maximum</th>\n",
       "      <th>Reference</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>bulk_dens</td>\n",
       "      <td>Bulk density - wet</td>\n",
       "      <td>387.000</td>\n",
       "      <td>kg/m3</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>344.000</td>\n",
       "      <td>464.000</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>ts_cont</td>\n",
       "      <td>Total solids content - wet</td>\n",
       "      <td>0.254</td>\n",
       "      <td>fraction wet weight</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.230</td>\n",
       "      <td>0.310</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>VS_cont</td>\n",
       "      <td>VS content - dry</td>\n",
       "      <td>0.530</td>\n",
       "      <td>kg VS/kg TS</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.460</td>\n",
       "      <td>0.600</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>C_cont</td>\n",
       "      <td>Organic C content - dry</td>\n",
       "      <td>0.331</td>\n",
       "      <td>fraction TS</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.259</td>\n",
       "      <td>0.334</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>PFOA</td>\n",
       "      <td>PFOA concentration</td>\n",
       "      <td>1.070</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>10.000</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>PFOS</td>\n",
       "      <td>PFOS concentration</td>\n",
       "      <td>0.840</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>10.000</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>PFBA</td>\n",
       "      <td>PFBA concentration</td>\n",
       "      <td>0.000</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>10.000</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>PFPeA</td>\n",
       "      <td>PFPeA concentration</td>\n",
       "      <td>0.000</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>10.000</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>PFHxA</td>\n",
       "      <td>PFHxA concentration</td>\n",
       "      <td>0.000</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>10.000</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>PFHpA</td>\n",
       "      <td>PFHpA concentration</td>\n",
       "      <td>0.000</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>10.000</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>PFNA</td>\n",
       "      <td>PFNA concentration</td>\n",
       "      <td>0.000</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>10.000</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>PFDA</td>\n",
       "      <td>PFDA concentration</td>\n",
       "      <td>0.000</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>10.000</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>PFBS</td>\n",
       "      <td>PFBS concentration</td>\n",
       "      <td>0.000</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>10.000</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>PFHxS</td>\n",
       "      <td>PFHxS concentration</td>\n",
       "      <td>0.000</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>10.000</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Parameter Name       Parameter Description   amount                 unit  \\\n",
       "42  bulk_dens      Bulk density - wet          387.000  kg/m3                 \n",
       "43  ts_cont        Total solids content - wet  0.254    fraction wet weight   \n",
       "44  VS_cont        VS content - dry            0.530    kg VS/kg TS           \n",
       "45  C_cont         Organic C content - dry     0.331    fraction TS           \n",
       "46  PFOA           PFOA concentration          1.070    10e-6g/kg             \n",
       "47  PFOS           PFOS concentration          0.840    10e-6g/kg             \n",
       "48  PFBA           PFBA concentration          0.000    10e-6g/kg             \n",
       "49  PFPeA          PFPeA concentration         0.000    10e-6g/kg             \n",
       "50  PFHxA          PFHxA concentration         0.000    10e-6g/kg             \n",
       "51  PFHpA          PFHpA concentration         0.000    10e-6g/kg             \n",
       "52  PFNA           PFNA concentration          0.000    10e-6g/kg             \n",
       "53  PFDA           PFDA concentration          0.000    10e-6g/kg             \n",
       "54  PFBS           PFBS concentration          0.000    10e-6g/kg             \n",
       "55  PFHxS          PFHxS concentration         0.000    10e-6g/kg             \n",
       "\n",
       "    uncertainty_type  loc  scale  minimum  maximum Reference  \n",
       "42  4                NaN  NaN     344.000  464.000            \n",
       "43  4                NaN  NaN     0.230    0.310              \n",
       "44  4                NaN  NaN     0.460    0.600              \n",
       "45  4                NaN  NaN     0.259    0.334              \n",
       "46  4                NaN  NaN     0.000    10.000             \n",
       "47  4                NaN  NaN     0.000    10.000             \n",
       "48  4                NaN  NaN     0.000    10.000             \n",
       "49  4                NaN  NaN     0.000    10.000             \n",
       "50  4                NaN  NaN     0.000    10.000             \n",
       "51  4                NaN  NaN     0.000    10.000             \n",
       "52  4                NaN  NaN     0.000    10.000             \n",
       "53  4                NaN  NaN     0.000    10.000             \n",
       "54  4                NaN  NaN     0.000    10.000             \n",
       "55  4                NaN  NaN     0.000    10.000             "
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "IncomingFlow.InputData.Data[(IncomingFlow.InputData.Data['Dictonary_Name']=='MSW')|\\\n",
    "                            (IncomingFlow.InputData.Data['Dictonary_Name']=='MSW_PFAS')][categories]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Raw WWT Solids \n",
    "\n",
    "\n",
    "\n",
    "<img src=\"../Images/WasteMaterials/WWT_Settling_Solids_Diagram_v3.jpg\" alt=\"Drawing\" style=\"width: 700px;\"/>"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Raw WWT Solids Properties "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Parameter Name</th>\n",
       "      <th>Parameter Description</th>\n",
       "      <th>amount</th>\n",
       "      <th>unit</th>\n",
       "      <th>uncertainty_type</th>\n",
       "      <th>loc</th>\n",
       "      <th>scale</th>\n",
       "      <th>minimum</th>\n",
       "      <th>maximum</th>\n",
       "      <th>Reference</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>162</th>\n",
       "      <td>bulk_dens</td>\n",
       "      <td>Bulk density - wet</td>\n",
       "      <td>1000.000000</td>\n",
       "      <td>kg/m3</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>163</th>\n",
       "      <td>ts_cont</td>\n",
       "      <td>Total solids content - wet</td>\n",
       "      <td>0.030000</td>\n",
       "      <td>kg-TS/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.005000</td>\n",
       "      <td>0.050000</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>164</th>\n",
       "      <td>VS_cont</td>\n",
       "      <td>VS content - dry</td>\n",
       "      <td>0.600000</td>\n",
       "      <td>kg VS/kg TS</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>165</th>\n",
       "      <td>C_cont</td>\n",
       "      <td>Organic C content - dry</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>fraction TS</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>166</th>\n",
       "      <td>PFOA</td>\n",
       "      <td>PFOA concentration</td>\n",
       "      <td>0.140270</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>5</td>\n",
       "      <td>0.140270</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.019597</td>\n",
       "      <td>0.597097</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>167</th>\n",
       "      <td>PFOS</td>\n",
       "      <td>PFOS concentration</td>\n",
       "      <td>0.551924</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>5</td>\n",
       "      <td>0.551924</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.079897</td>\n",
       "      <td>1.695097</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>168</th>\n",
       "      <td>PFBA</td>\n",
       "      <td>PFBA concentration</td>\n",
       "      <td>0.022019</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>5</td>\n",
       "      <td>0.022019</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000097</td>\n",
       "      <td>0.147097</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>169</th>\n",
       "      <td>PFPeA</td>\n",
       "      <td>PFPeA concentration</td>\n",
       "      <td>0.054850</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>5</td>\n",
       "      <td>0.054850</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000097</td>\n",
       "      <td>0.747097</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>170</th>\n",
       "      <td>PFHxA</td>\n",
       "      <td>PFHxA concentration</td>\n",
       "      <td>0.076813</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>5</td>\n",
       "      <td>0.076813</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000097</td>\n",
       "      <td>0.339097</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>171</th>\n",
       "      <td>PFHpA</td>\n",
       "      <td>PFHpA concentration</td>\n",
       "      <td>0.013313</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>5</td>\n",
       "      <td>0.013313</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000097</td>\n",
       "      <td>0.130297</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>172</th>\n",
       "      <td>PFNA</td>\n",
       "      <td>PFNA concentration</td>\n",
       "      <td>0.056057</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>5</td>\n",
       "      <td>0.056057</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000097</td>\n",
       "      <td>0.201397</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>173</th>\n",
       "      <td>PFDA</td>\n",
       "      <td>PFDA concentration</td>\n",
       "      <td>0.232912</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>5</td>\n",
       "      <td>0.232912</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.020977</td>\n",
       "      <td>2.529097</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>174</th>\n",
       "      <td>PFBS</td>\n",
       "      <td>PFBS concentration</td>\n",
       "      <td>0.018838</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>5</td>\n",
       "      <td>0.018838</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000097</td>\n",
       "      <td>0.239197</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>175</th>\n",
       "      <td>PFHxS</td>\n",
       "      <td>PFHxS concentration</td>\n",
       "      <td>0.016175</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>5</td>\n",
       "      <td>0.016175</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000097</td>\n",
       "      <td>0.083497</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Parameter Name       Parameter Description       amount         unit  \\\n",
       "162  bulk_dens      Bulk density - wet          1000.000000  kg/m3         \n",
       "163  ts_cont        Total solids content - wet  0.030000     kg-TS/kg      \n",
       "164  VS_cont        VS content - dry            0.600000     kg VS/kg TS   \n",
       "165  C_cont         Organic C content - dry     0.500000     fraction TS   \n",
       "166  PFOA           PFOA concentration          0.140270     10e-6g/kg     \n",
       "167  PFOS           PFOS concentration          0.551924     10e-6g/kg     \n",
       "168  PFBA           PFBA concentration          0.022019     10e-6g/kg     \n",
       "169  PFPeA          PFPeA concentration         0.054850     10e-6g/kg     \n",
       "170  PFHxA          PFHxA concentration         0.076813     10e-6g/kg     \n",
       "171  PFHpA          PFHpA concentration         0.013313     10e-6g/kg     \n",
       "172  PFNA           PFNA concentration          0.056057     10e-6g/kg     \n",
       "173  PFDA           PFDA concentration          0.232912     10e-6g/kg     \n",
       "174  PFBS           PFBS concentration          0.018838     10e-6g/kg     \n",
       "175  PFHxS          PFHxS concentration         0.016175     10e-6g/kg     \n",
       "\n",
       "     uncertainty_type       loc  scale   minimum   maximum Reference  \n",
       "162  0                NaN       NaN    NaN       NaN                  \n",
       "163  0                NaN       NaN     0.005000  0.050000            \n",
       "164  0                NaN       NaN    NaN       NaN                  \n",
       "165  0                NaN       NaN    NaN       NaN                  \n",
       "166  5                 0.140270 NaN     0.019597  0.597097            \n",
       "167  5                 0.551924 NaN     0.079897  1.695097            \n",
       "168  5                 0.022019 NaN     0.000097  0.147097            \n",
       "169  5                 0.054850 NaN     0.000097  0.747097            \n",
       "170  5                 0.076813 NaN     0.000097  0.339097            \n",
       "171  5                 0.013313 NaN     0.000097  0.130297            \n",
       "172  5                 0.056057 NaN     0.000097  0.201397            \n",
       "173  5                 0.232912 NaN     0.020977  2.529097            \n",
       "174  5                 0.018838 NaN     0.000097  0.239197            \n",
       "175  5                 0.016175 NaN     0.000097  0.083497            "
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "IncomingFlow.InputData.Data[(IncomingFlow.InputData.Data['Dictonary_Name']=='RawWWTSolids')|\\\n",
    "                            (IncomingFlow.InputData.Data['Dictonary_Name']=='RawWWTSolids_PFAS')][categories]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## RO Concentrate\n",
    "\n",
    "RO concentrate is produced from RO systems that are used to remove PFAS and other contaminants during the treatment of contaminated water. The following figure shows the potential treatment alternatives for RO concentrate. This material may be directly released to surface water, disposed in a landfill after mixing to absorb free liquid, treated in a WWT plant, injected into a deep well, or treated through supercritical water oxidation (SCWO).\n",
    "\n",
    "\n",
    "<img src=\"../Images/WasteMaterials/RO_Concentrate_Diagram-v4.jpg\" alt=\"Drawing\" style=\"width: 700px;\"/>"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### RO Concentrate Properties\n",
    "\n",
    "#### Assumptions and Limitations\n",
    "The PFAS concentration in RO concentrate will vary based on PFAS concentrations in the water stream being treated and the recovery, at which the process operates. Thus, **some user knowledge is important to properly represent this waste stream.**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Parameter Name</th>\n",
       "      <th>Parameter Description</th>\n",
       "      <th>amount</th>\n",
       "      <th>unit</th>\n",
       "      <th>uncertainty_type</th>\n",
       "      <th>loc</th>\n",
       "      <th>scale</th>\n",
       "      <th>minimum</th>\n",
       "      <th>maximum</th>\n",
       "      <th>Reference</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>203</th>\n",
       "      <td>density</td>\n",
       "      <td>Density</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>kg/L</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>204</th>\n",
       "      <td>ts_cont</td>\n",
       "      <td>Total solids content - wet</td>\n",
       "      <td>9.000000e-01</td>\n",
       "      <td>fraction wet weight</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>205</th>\n",
       "      <td>VS_cont</td>\n",
       "      <td>VS content - dry</td>\n",
       "      <td>9.220000e-01</td>\n",
       "      <td>kg VS/kg TS</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>206</th>\n",
       "      <td>C_cont</td>\n",
       "      <td>Organic C content - dry</td>\n",
       "      <td>7.000000e-01</td>\n",
       "      <td>fraction TS</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>207</th>\n",
       "      <td>PFOA</td>\n",
       "      <td>PFOA concentration</td>\n",
       "      <td>7.246225e+07</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>208</th>\n",
       "      <td>PFOS</td>\n",
       "      <td>PFOS concentration</td>\n",
       "      <td>1.125292e+08</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>209</th>\n",
       "      <td>PFBA</td>\n",
       "      <td>PFBA concentration</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>210</th>\n",
       "      <td>PFPeA</td>\n",
       "      <td>PFPeA concentration</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>211</th>\n",
       "      <td>PFHxA</td>\n",
       "      <td>PFHxA concentration</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>212</th>\n",
       "      <td>PFHpA</td>\n",
       "      <td>PFHpA concentration</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>213</th>\n",
       "      <td>PFNA</td>\n",
       "      <td>PFNA concentration</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>214</th>\n",
       "      <td>PFDA</td>\n",
       "      <td>PFDA concentration</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>215</th>\n",
       "      <td>PFBS</td>\n",
       "      <td>PFBS concentration</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>216</th>\n",
       "      <td>PFHxS</td>\n",
       "      <td>PFHxS concentration</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Parameter Name       Parameter Description        amount  \\\n",
       "203  density        Density                     1.000000e+00   \n",
       "204  ts_cont        Total solids content - wet  9.000000e-01   \n",
       "205  VS_cont        VS content - dry            9.220000e-01   \n",
       "206  C_cont         Organic C content - dry     7.000000e-01   \n",
       "207  PFOA           PFOA concentration          7.246225e+07   \n",
       "208  PFOS           PFOS concentration          1.125292e+08   \n",
       "209  PFBA           PFBA concentration          0.000000e+00   \n",
       "210  PFPeA          PFPeA concentration         0.000000e+00   \n",
       "211  PFHxA          PFHxA concentration         0.000000e+00   \n",
       "212  PFHpA          PFHpA concentration         0.000000e+00   \n",
       "213  PFNA           PFNA concentration          0.000000e+00   \n",
       "214  PFDA           PFDA concentration          0.000000e+00   \n",
       "215  PFBS           PFBS concentration          0.000000e+00   \n",
       "216  PFHxS          PFHxS concentration         0.000000e+00   \n",
       "\n",
       "                    unit  uncertainty_type  loc  scale  minimum  maximum  \\\n",
       "203  kg/L                 0                NaN  NaN    NaN      NaN        \n",
       "204  fraction wet weight  0                NaN  NaN    NaN      NaN        \n",
       "205  kg VS/kg TS          0                NaN  NaN    NaN      NaN        \n",
       "206  fraction TS          0                NaN  NaN    NaN      NaN        \n",
       "207  10e-6g/kg            0                NaN  NaN    NaN      NaN        \n",
       "208  10e-6g/kg            0                NaN  NaN    NaN      NaN        \n",
       "209  10e-6g/kg            0                NaN  NaN    NaN      NaN        \n",
       "210  10e-6g/kg            0                NaN  NaN    NaN      NaN        \n",
       "211  10e-6g/kg            0                NaN  NaN    NaN      NaN        \n",
       "212  10e-6g/kg            0                NaN  NaN    NaN      NaN        \n",
       "213  10e-6g/kg            0                NaN  NaN    NaN      NaN        \n",
       "214  10e-6g/kg            0                NaN  NaN    NaN      NaN        \n",
       "215  10e-6g/kg            0                NaN  NaN    NaN      NaN        \n",
       "216  10e-6g/kg            0                NaN  NaN    NaN      NaN        \n",
       "\n",
       "    Reference  \n",
       "203            \n",
       "204            \n",
       "205            \n",
       "206            \n",
       "207            \n",
       "208            \n",
       "209            \n",
       "210            \n",
       "211            \n",
       "212            \n",
       "213            \n",
       "214            \n",
       "215            \n",
       "216            "
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "IncomingFlow.InputData.Data[(IncomingFlow.InputData.Data['Dictonary_Name']=='ROConcentrate')|\\\n",
    "                            (IncomingFlow.InputData.Data['Dictonary_Name']=='ROConcentrate_PFAS')][categories]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Spent GAC\n",
    "\n",
    "PFAS-laden spent granular activated carbon (GAC) is generated when GAC adsorption processes are used to treat water contaminated with PFAS. The following figure shows the management alternatives considered for spent GAC. The GAC can be landfilled, combusted, or thermally reactivated to generate GAC that can be reused for contaminant removal.\n",
    "\n",
    "<img src=\"../Images/WasteMaterials/GAC_Diagram-v2.jpg\" alt=\"Drawing\" style=\"width: 700px;\"/>"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Spent GAC Properties\n",
    "\n",
    "#### Assumptions and Limitations\n",
    "1. The PFAS concentration in GAC will vary based on PFAS concentrations in the water stream being treated. Thus, **some user knowledge is important to properly represent this waste stream.**\n",
    "\n",
    "2. The default concentrations are based on isotherm data at specified equilibrium concentration of 100 ng/L. These concentrations will vary under different conditions and using site-specific data will be beneficial.  \n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Parameter Name</th>\n",
       "      <th>Parameter Description</th>\n",
       "      <th>amount</th>\n",
       "      <th>unit</th>\n",
       "      <th>uncertainty_type</th>\n",
       "      <th>loc</th>\n",
       "      <th>scale</th>\n",
       "      <th>minimum</th>\n",
       "      <th>maximum</th>\n",
       "      <th>Reference</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>189</th>\n",
       "      <td>bulk_dens</td>\n",
       "      <td>Bulk density - wet</td>\n",
       "      <td>500.000</td>\n",
       "      <td>kg/m3</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>190</th>\n",
       "      <td>ts_cont</td>\n",
       "      <td>Total solids content - wet</td>\n",
       "      <td>0.900</td>\n",
       "      <td>fraction wet weight</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>191</th>\n",
       "      <td>Ash_cont</td>\n",
       "      <td>VS content - dry</td>\n",
       "      <td>0.078</td>\n",
       "      <td>kg VS/kg TS</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.04</td>\n",
       "      <td>0.14</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>192</th>\n",
       "      <td>C_cont</td>\n",
       "      <td>Organic C content - dry</td>\n",
       "      <td>0.700</td>\n",
       "      <td>fraction TS</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>193</th>\n",
       "      <td>PFOA</td>\n",
       "      <td>PFOA concentration</td>\n",
       "      <td>900.000</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194</th>\n",
       "      <td>PFOS</td>\n",
       "      <td>PFOS concentration</td>\n",
       "      <td>1500.000</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195</th>\n",
       "      <td>PFBA</td>\n",
       "      <td>PFBA concentration</td>\n",
       "      <td>0.000</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>196</th>\n",
       "      <td>PFPeA</td>\n",
       "      <td>PFPeA concentration</td>\n",
       "      <td>0.000</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>197</th>\n",
       "      <td>PFHxA</td>\n",
       "      <td>PFHxA concentration</td>\n",
       "      <td>0.000</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>198</th>\n",
       "      <td>PFHpA</td>\n",
       "      <td>PFHpA concentration</td>\n",
       "      <td>0.000</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199</th>\n",
       "      <td>PFNA</td>\n",
       "      <td>PFNA concentration</td>\n",
       "      <td>0.000</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>200</th>\n",
       "      <td>PFDA</td>\n",
       "      <td>PFDA concentration</td>\n",
       "      <td>0.000</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>201</th>\n",
       "      <td>PFBS</td>\n",
       "      <td>PFBS concentration</td>\n",
       "      <td>0.000</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>202</th>\n",
       "      <td>PFHxS</td>\n",
       "      <td>PFHxS concentration</td>\n",
       "      <td>0.000</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Parameter Name       Parameter Description    amount                 unit  \\\n",
       "189  bulk_dens      Bulk density - wet          500.000   kg/m3                 \n",
       "190  ts_cont        Total solids content - wet  0.900     fraction wet weight   \n",
       "191  Ash_cont       VS content - dry            0.078     kg VS/kg TS           \n",
       "192  C_cont         Organic C content - dry     0.700     fraction TS           \n",
       "193  PFOA           PFOA concentration          900.000   10e-6g/kg             \n",
       "194  PFOS           PFOS concentration          1500.000  10e-6g/kg             \n",
       "195  PFBA           PFBA concentration          0.000     10e-6g/kg             \n",
       "196  PFPeA          PFPeA concentration         0.000     10e-6g/kg             \n",
       "197  PFHxA          PFHxA concentration         0.000     10e-6g/kg             \n",
       "198  PFHpA          PFHpA concentration         0.000     10e-6g/kg             \n",
       "199  PFNA           PFNA concentration          0.000     10e-6g/kg             \n",
       "200  PFDA           PFDA concentration          0.000     10e-6g/kg             \n",
       "201  PFBS           PFBS concentration          0.000     10e-6g/kg             \n",
       "202  PFHxS          PFHxS concentration         0.000     10e-6g/kg             \n",
       "\n",
       "     uncertainty_type  loc  scale  minimum  maximum Reference  \n",
       "189  0                NaN  NaN    NaN      NaN                 \n",
       "190  0                NaN  NaN    NaN      NaN                 \n",
       "191  4                NaN  NaN     0.04     0.14               \n",
       "192  0                NaN  NaN    NaN      NaN                 \n",
       "193  0                NaN  NaN    NaN      NaN                 \n",
       "194  0                NaN  NaN    NaN      NaN                 \n",
       "195  0                NaN  NaN    NaN      NaN                 \n",
       "196  0                NaN  NaN    NaN      NaN                 \n",
       "197  0                NaN  NaN    NaN      NaN                 \n",
       "198  0                NaN  NaN    NaN      NaN                 \n",
       "199  0                NaN  NaN    NaN      NaN                 \n",
       "200  0                NaN  NaN    NaN      NaN                 \n",
       "201  0                NaN  NaN    NaN      NaN                 \n",
       "202  0                NaN  NaN    NaN      NaN                 "
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "IncomingFlow.InputData.Data[(IncomingFlow.InputData.Data['Dictonary_Name']=='SpentGAC')|\\\n",
    "                            (IncomingFlow.InputData.Data['Dictonary_Name']=='SpentGAC_PFAS')][categories]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Spent Ion Exchange Resin (Spent IER)\n",
    "\n",
    "\n",
    "<img src=\"../Images/WasteMaterials/Spent_Ion_Exchange_Resin_Diagram.jpg\" alt=\"Drawing\" style=\"width: 700px;\"/>\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Spent Ion Exchange Resin Properties "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Parameter Name</th>\n",
       "      <th>Parameter Description</th>\n",
       "      <th>amount</th>\n",
       "      <th>unit</th>\n",
       "      <th>uncertainty_type</th>\n",
       "      <th>loc</th>\n",
       "      <th>scale</th>\n",
       "      <th>minimum</th>\n",
       "      <th>maximum</th>\n",
       "      <th>Reference</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>217</th>\n",
       "      <td>density</td>\n",
       "      <td>Density</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>kg/L</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>218</th>\n",
       "      <td>ts_cont</td>\n",
       "      <td>Total solids content - wet</td>\n",
       "      <td>9.000000e-01</td>\n",
       "      <td>fraction wet weight</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>219</th>\n",
       "      <td>VS_cont</td>\n",
       "      <td>VS content - dry</td>\n",
       "      <td>9.220000e-01</td>\n",
       "      <td>kg VS/kg TS</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>220</th>\n",
       "      <td>C_cont</td>\n",
       "      <td>Organic C content - dry</td>\n",
       "      <td>7.000000e-01</td>\n",
       "      <td>fraction TS</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>221</th>\n",
       "      <td>PFOA</td>\n",
       "      <td>PFOA concentration</td>\n",
       "      <td>7.246225e+07</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222</th>\n",
       "      <td>PFOS</td>\n",
       "      <td>PFOS concentration</td>\n",
       "      <td>1.125292e+08</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223</th>\n",
       "      <td>PFBA</td>\n",
       "      <td>PFBA concentration</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>224</th>\n",
       "      <td>PFPeA</td>\n",
       "      <td>PFPeA concentration</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225</th>\n",
       "      <td>PFHxA</td>\n",
       "      <td>PFHxA concentration</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>226</th>\n",
       "      <td>PFHpA</td>\n",
       "      <td>PFHpA concentration</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>227</th>\n",
       "      <td>PFNA</td>\n",
       "      <td>PFNA concentration</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>228</th>\n",
       "      <td>PFDA</td>\n",
       "      <td>PFDA concentration</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>229</th>\n",
       "      <td>PFBS</td>\n",
       "      <td>PFBS concentration</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>230</th>\n",
       "      <td>PFHxS</td>\n",
       "      <td>PFHxS concentration</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Parameter Name       Parameter Description        amount  \\\n",
       "217  density        Density                     1.000000e+00   \n",
       "218  ts_cont        Total solids content - wet  9.000000e-01   \n",
       "219  VS_cont        VS content - dry            9.220000e-01   \n",
       "220  C_cont         Organic C content - dry     7.000000e-01   \n",
       "221  PFOA           PFOA concentration          7.246225e+07   \n",
       "222  PFOS           PFOS concentration          1.125292e+08   \n",
       "223  PFBA           PFBA concentration          0.000000e+00   \n",
       "224  PFPeA          PFPeA concentration         0.000000e+00   \n",
       "225  PFHxA          PFHxA concentration         0.000000e+00   \n",
       "226  PFHpA          PFHpA concentration         0.000000e+00   \n",
       "227  PFNA           PFNA concentration          0.000000e+00   \n",
       "228  PFDA           PFDA concentration          0.000000e+00   \n",
       "229  PFBS           PFBS concentration          0.000000e+00   \n",
       "230  PFHxS          PFHxS concentration         0.000000e+00   \n",
       "\n",
       "                    unit  uncertainty_type  loc  scale  minimum  maximum  \\\n",
       "217  kg/L                 0                NaN  NaN    NaN      NaN        \n",
       "218  fraction wet weight  0                NaN  NaN    NaN      NaN        \n",
       "219  kg VS/kg TS          0                NaN  NaN    NaN      NaN        \n",
       "220  fraction TS          0                NaN  NaN    NaN      NaN        \n",
       "221  10e-6g/kg            0                NaN  NaN    NaN      NaN        \n",
       "222  10e-6g/kg            0                NaN  NaN    NaN      NaN        \n",
       "223  10e-6g/kg            0                NaN  NaN    NaN      NaN        \n",
       "224  10e-6g/kg            0                NaN  NaN    NaN      NaN        \n",
       "225  10e-6g/kg            0                NaN  NaN    NaN      NaN        \n",
       "226  10e-6g/kg            0                NaN  NaN    NaN      NaN        \n",
       "227  10e-6g/kg            0                NaN  NaN    NaN      NaN        \n",
       "228  10e-6g/kg            0                NaN  NaN    NaN      NaN        \n",
       "229  10e-6g/kg            0                NaN  NaN    NaN      NaN        \n",
       "230  10e-6g/kg            0                NaN  NaN    NaN      NaN        \n",
       "\n",
       "    Reference  \n",
       "217            \n",
       "218            \n",
       "219            \n",
       "220            \n",
       "221            \n",
       "222            \n",
       "223            \n",
       "224            \n",
       "225            \n",
       "226            \n",
       "227            \n",
       "228            \n",
       "229            \n",
       "230            "
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "IncomingFlow.InputData.Data[(IncomingFlow.InputData.Data['Dictonary_Name']=='SpentIER')|\\\n",
    "                            (IncomingFlow.InputData.Data['Dictonary_Name']=='SpentIER_PFAS')][categories]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## WWT Effluent\n",
    "\n",
    "The following figure shows the treatment alternatives that were considered for primary and secondary wastewater effluent. The effluent can either be released to surface water or sent to advanced physico-chemical treatment (advance WWT) for PFAS removal.\n",
    "\n",
    "<img src=\"../Images/WasteMaterials/WWT_Effluent.jpg\" alt=\"Drawing\" style=\"width: 300px;\"/>"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### WWT Effluent Properties\n",
    "\n",
    "Existing data on PFAS in wastewater shows that the PFAS concentration will vary between treatment plants based on the source water properties, possible upstream contaminants, and potential treatment options. Therefore, if WWT effluent is the starting material in an analysis it is best for the user to understand the properties of their specific stream to improve their results. \n",
    "\n",
    "#### Assumptions and Limitations\n",
    "1.\tWhile there is data on PFAS in WWT influent and effluent, more research is needed on the fate of PFAS entering WWTPs including their potential transformations.\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Parameter Name</th>\n",
       "      <th>Parameter Description</th>\n",
       "      <th>amount</th>\n",
       "      <th>unit</th>\n",
       "      <th>uncertainty_type</th>\n",
       "      <th>loc</th>\n",
       "      <th>scale</th>\n",
       "      <th>minimum</th>\n",
       "      <th>maximum</th>\n",
       "      <th>Reference</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>176</th>\n",
       "      <td>density</td>\n",
       "      <td>Density</td>\n",
       "      <td>1.00000</td>\n",
       "      <td>kg/L</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>177</th>\n",
       "      <td>ts_cont</td>\n",
       "      <td>Total solids content - wet</td>\n",
       "      <td>0.00003</td>\n",
       "      <td>kg-TS/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000045</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>178</th>\n",
       "      <td>C_cont</td>\n",
       "      <td>Organic C content - dry</td>\n",
       "      <td>0.50000</td>\n",
       "      <td>fraction TS</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>179</th>\n",
       "      <td>PFOA</td>\n",
       "      <td>PFOA concentration</td>\n",
       "      <td>0.10000</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.500000</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>180</th>\n",
       "      <td>PFOS</td>\n",
       "      <td>PFOS concentration</td>\n",
       "      <td>0.01000</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.500000</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181</th>\n",
       "      <td>PFBA</td>\n",
       "      <td>PFBA concentration</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.500000</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>182</th>\n",
       "      <td>PFPeA</td>\n",
       "      <td>PFPeA concentration</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.500000</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183</th>\n",
       "      <td>PFHxA</td>\n",
       "      <td>PFHxA concentration</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.500000</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>184</th>\n",
       "      <td>PFHpA</td>\n",
       "      <td>PFHpA concentration</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.500000</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>185</th>\n",
       "      <td>PFNA</td>\n",
       "      <td>PFNA concentration</td>\n",
       "      <td>0.00700</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.500000</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>186</th>\n",
       "      <td>PFDA</td>\n",
       "      <td>PFDA concentration</td>\n",
       "      <td>0.00300</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.500000</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>187</th>\n",
       "      <td>PFBS</td>\n",
       "      <td>PFBS concentration</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.500000</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>188</th>\n",
       "      <td>PFHxS</td>\n",
       "      <td>PFHxS concentration</td>\n",
       "      <td>0.00700</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.500000</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Parameter Name       Parameter Description   amount         unit  \\\n",
       "176  density        Density                     1.00000  kg/L          \n",
       "177  ts_cont        Total solids content - wet  0.00003  kg-TS/kg      \n",
       "178  C_cont         Organic C content - dry     0.50000  fraction TS   \n",
       "179  PFOA           PFOA concentration          0.10000  10e-6g/kg     \n",
       "180  PFOS           PFOS concentration          0.01000  10e-6g/kg     \n",
       "181  PFBA           PFBA concentration          0.00000  10e-6g/kg     \n",
       "182  PFPeA          PFPeA concentration         0.00000  10e-6g/kg     \n",
       "183  PFHxA          PFHxA concentration         0.00000  10e-6g/kg     \n",
       "184  PFHpA          PFHpA concentration         0.00000  10e-6g/kg     \n",
       "185  PFNA           PFNA concentration          0.00700  10e-6g/kg     \n",
       "186  PFDA           PFDA concentration          0.00300  10e-6g/kg     \n",
       "187  PFBS           PFBS concentration          0.00000  10e-6g/kg     \n",
       "188  PFHxS          PFHxS concentration         0.00700  10e-6g/kg     \n",
       "\n",
       "     uncertainty_type  loc  scale  minimum   maximum Reference  \n",
       "176  0                NaN  NaN    NaN      NaN                  \n",
       "177  0                NaN  NaN     0.0      0.000045            \n",
       "178  0                NaN  NaN    NaN      NaN                  \n",
       "179  4                NaN  NaN     0.0      0.500000            \n",
       "180  4                NaN  NaN     0.0      0.500000            \n",
       "181  0                NaN  NaN     0.0      0.500000            \n",
       "182  0                NaN  NaN     0.0      0.500000            \n",
       "183  0                NaN  NaN     0.0      0.500000            \n",
       "184  0                NaN  NaN     0.0      0.500000            \n",
       "185  4                NaN  NaN     0.0      0.500000            \n",
       "186  4                NaN  NaN     0.0      0.500000            \n",
       "187  0                NaN  NaN     0.0      0.500000            \n",
       "188  4                NaN  NaN     0.0      0.500000            "
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "IncomingFlow.InputData.Data[(IncomingFlow.InputData.Data['Dictonary_Name']=='WWTEffluent')|\\\n",
    "                            (IncomingFlow.InputData.Data['Dictonary_Name']=='WWTEffluent_PFAS')][categories]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## WWT Screen Rejects"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### WWT Screen Rejects Properties"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Parameter Name</th>\n",
       "      <th>Parameter Description</th>\n",
       "      <th>amount</th>\n",
       "      <th>unit</th>\n",
       "      <th>uncertainty_type</th>\n",
       "      <th>loc</th>\n",
       "      <th>scale</th>\n",
       "      <th>minimum</th>\n",
       "      <th>maximum</th>\n",
       "      <th>Reference</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>121</th>\n",
       "      <td>bulk_dens</td>\n",
       "      <td>Bulk density - wet</td>\n",
       "      <td>800.000000</td>\n",
       "      <td>kg/m3</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>122</th>\n",
       "      <td>ts_cont</td>\n",
       "      <td>Total solids content - wet</td>\n",
       "      <td>0.600000</td>\n",
       "      <td>fraction wet weight</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>123</th>\n",
       "      <td>C_cont</td>\n",
       "      <td>Organic C content - dry</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>fraction TS</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>124</th>\n",
       "      <td>PFOA</td>\n",
       "      <td>PFOA concentration</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125</th>\n",
       "      <td>PFOS</td>\n",
       "      <td>PFOS concentration</td>\n",
       "      <td>0.297333</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>126</th>\n",
       "      <td>PFBA</td>\n",
       "      <td>PFBA concentration</td>\n",
       "      <td>0.164333</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>PFPeA</td>\n",
       "      <td>PFPeA concentration</td>\n",
       "      <td>0.414000</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>128</th>\n",
       "      <td>PFHxA</td>\n",
       "      <td>PFHxA concentration</td>\n",
       "      <td>0.481333</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129</th>\n",
       "      <td>PFHpA</td>\n",
       "      <td>PFHpA concentration</td>\n",
       "      <td>0.065333</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>130</th>\n",
       "      <td>PFNA</td>\n",
       "      <td>PFNA concentration</td>\n",
       "      <td>0.054333</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>131</th>\n",
       "      <td>PFDA</td>\n",
       "      <td>PFDA concentration</td>\n",
       "      <td>0.176667</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132</th>\n",
       "      <td>PFBS</td>\n",
       "      <td>PFBS concentration</td>\n",
       "      <td>0.060667</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133</th>\n",
       "      <td>PFHxS</td>\n",
       "      <td>PFHxS concentration</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>10e-6g/kg</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Parameter Name       Parameter Description      amount  \\\n",
       "121  bulk_dens      Bulk density - wet          800.000000   \n",
       "122  ts_cont        Total solids content - wet  0.600000     \n",
       "123  C_cont         Organic C content - dry     0.500000     \n",
       "124  PFOA           PFOA concentration          0.000000     \n",
       "125  PFOS           PFOS concentration          0.297333     \n",
       "126  PFBA           PFBA concentration          0.164333     \n",
       "127  PFPeA          PFPeA concentration         0.414000     \n",
       "128  PFHxA          PFHxA concentration         0.481333     \n",
       "129  PFHpA          PFHpA concentration         0.065333     \n",
       "130  PFNA           PFNA concentration          0.054333     \n",
       "131  PFDA           PFDA concentration          0.176667     \n",
       "132  PFBS           PFBS concentration          0.060667     \n",
       "133  PFHxS          PFHxS concentration         0.000000     \n",
       "\n",
       "                    unit  uncertainty_type  loc  scale  minimum  maximum  \\\n",
       "121  kg/m3                0                NaN  NaN    NaN      NaN        \n",
       "122  fraction wet weight  0                NaN  NaN    NaN      NaN        \n",
       "123  fraction TS          0                NaN  NaN    NaN      NaN        \n",
       "124  10e-6g/kg            0                NaN  NaN    NaN      NaN        \n",
       "125  10e-6g/kg            0                NaN  NaN    NaN      NaN        \n",
       "126  10e-6g/kg            0                NaN  NaN    NaN      NaN        \n",
       "127  10e-6g/kg            0                NaN  NaN    NaN      NaN        \n",
       "128  10e-6g/kg            0                NaN  NaN    NaN      NaN        \n",
       "129  10e-6g/kg            0                NaN  NaN    NaN      NaN        \n",
       "130  10e-6g/kg            0                NaN  NaN    NaN      NaN        \n",
       "131  10e-6g/kg            0                NaN  NaN    NaN      NaN        \n",
       "132  10e-6g/kg            0                NaN  NaN    NaN      NaN        \n",
       "133  10e-6g/kg            0                NaN  NaN    NaN      NaN        \n",
       "\n",
       "    Reference  \n",
       "121            \n",
       "122            \n",
       "123            \n",
       "124            \n",
       "125            \n",
       "126            \n",
       "127            \n",
       "128            \n",
       "129            \n",
       "130            \n",
       "131            \n",
       "132            \n",
       "133            "
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "IncomingFlow.InputData.Data[(IncomingFlow.InputData.Data['Dictonary_Name']=='WWTScreenRejects')|\\\n",
    "                            (IncomingFlow.InputData.Data['Dictonary_Name']=='WWTScreenRejects_PFAS')][categories]"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.9"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
