paper "table"
The Director
AssignmentResourceExpenseTrendAnalysisWorksheet..xlsx2017
| 2017 (Constant Dollars, 2020) | |||||||||
| Transportation Security Administration (CAS-TSA) | Transportation Security Administration (CAS-TSA) | Type from spreadsheet calculations | |||||||
| Major Expense | % of Total TSA Budget | % of Total TSA Budget | |||||||
| Operations and Support | ERROR:#DIV/0! | Operations and Support | 91% | ||||||
| Procurement, Construction, and Improvements | ERROR:#DIV/0! | Procurement, Construction, and Improvements | 3% | ||||||
| Operations and Support (Discretionary Offering Fees) | ERROR:#DIV/0! | Operations and Support (Discretionary Offering Fees) | 3% | ||||||
| Procurement, Construction, and Improvements (Mandatory) | ERROR:#DIV/0! | Procurement, Construction, and Improvements (Mandatory) | 3% | ||||||
| Total TSA Budget | |||||||||
| Remember to convert to 2020 dollars before entering figures into the table | |||||||||
| The figures for 2017 were used in this example s that you can see from where rhey were copied. |
% of TSA Budget
(2020 Dollars)
Operations and Support Procurement, Construction, and Improvements Operations and Support (Discretionary Offering Fees) Procurement, Construction, and Improvements (Mandatory) 0.91106189414326133 2.7153317369293047E-2 2.7384675180089527E-2 3.2938184908382441E-2
2016
| 2016 (Constant Dollars, 2020) | |||||||||||
| Transportation Security Administration (CAS-TSA) | |||||||||||
| Major Expense | % of Total TSA Budget | Transportation Security Administration (CAS-TSA) | Type from spreadsheet calculations | ||||||||
| Operations and Support | ERROR:#DIV/0! | % of Total TSA Budget | |||||||||
| Procurement, Construction, and Improvements | ERROR:#DIV/0! | Operations and Support | 91% | ||||||||
| Operations and Support (Discretionary Offering Fees) | ERROR:#DIV/0! | Procurement, Construction, and Improvements | 3% | ||||||||
| Procurement, Construction, and Improvements (Mandatory) | ERROR:#DIV/0! | Operations and Support (Discretionary Offering Fees) | 3% | ||||||||
| Procurement, Construction, and Improvements (Mandatory) | 3% | ||||||||||
| Total TSA Budget | |||||||||||
| Remember to convert to 2020 dollars before entering figures into the table | |||||||||||
| The figures for 2017 were used in this example s that you can see from where rhey were copied. |
% of Total TSA Budget
Operations and Support Procurement, Construction, and Improvements Operations and Support (Discretionary Offering Fees) Procurement, Construction, and Improvements (Mandatory) 0.91106189414326133 2.7153317369293047E-2 2.7384675180089527E-2 3.2938184908382441E-2
2015
| 2015 (Constant Dollars, 2020) | |||||||||
| Transportation Security Administration (CAS-TSA) | Transportation Security Administration (CAS-TSA) | Type from spreadsheet calculations | |||||||
| Major Expense | % of Total TSA Budget | % of Total TSA Budget | |||||||
| Operations and Support | ERROR:#DIV/0! | Operations and Support | 91% | ||||||
| Procurement, Construction, and Improvements | ERROR:#DIV/0! | Procurement, Construction, and Improvements | 3% | ||||||
| Operations and Support (Discretionary Offering Fees) | ERROR:#DIV/0! | Operations and Support (Discretionary Offering Fees) | 3% | ||||||
| Procurement, Construction, and Improvements (Mandatory) | ERROR:#DIV/0! | Procurement, Construction, and Improvements (Mandatory) | 3% | ||||||
| Total TSA Budget | |||||||||
| Remember to convert to 2020 dollars before entering figures into the table | |||||||||
% of Total TSA Budget
Operations and Support Procurement, Construction, and Improvements Operations and Support (Discretionary Offering Fees) Procurement, Construction, and Improvements (Mandatory) 0.91106189414326133 2.7153317369293047E-2 2.7384675180089527E-2 3.2938184908382441E-2
