Spreadsheet: 871327d1717702650-spillable-multiplication-formula-use-spill-operator-book2
Sheet: Salaries & Fringe

Position or Title | Salary | Fringe | % Allocated to Project | Training Expenses (Column A + Column B) x Column C | Check
 | 25412 |  | 0.1
 | 68741 |  | 0.07 | 4821.0127
 | 11227.7 |  | 0.023 | 258.72769
 | 17447.88 |  | 0.16 | 2796.964800000001
 | 24534.64 |  | 0.25 | 6145.315
 | 32487.98 |  | 0.41 | 13345.3811
 | 41307.9 |  | 0.24 | 9932.7336
 | 50994.4 |  | 0.21 | 10729.1709
 | 61547.48 |  | 0.54 | 33298.7868
 | 72967.14 |  | 0.11 | 8041.6358
 | 85253.38 |  | 0.57 | 48686.7552
 | 98406.20000000001 |  | 0.14 | 13803.0438
 | 112425.6 |  | 0.31 | 34918.1551
 | 127311.58 |  | 0.17 | 21684.0899
 | 143064.14 |  | 0.67 | 96035.09320000002
 | 159683.28 |  | 0.2 | 31997.336
 | 177169 |  | 0.65 | 115378.653
 | 195521.3 |  | 0.46 | 90110.68340000001
 | 214740.18 |  | 0.05 | 10757.4095
 | 234825.64 |  | 0.32 | 75286.97920000002
 | 255777.68 |  | 0.12 | 30751.6392
 | 277596.3 |  | 0.01 | 2781.2373
 | 300281.5 |  | 0.51 | 153434.5353
 | 100426.6496 |  | 0.28 | 28172.888688
 | 111623.0412 |  | 0.55 | 61509.31666000001
 | 123602.4372 |  | 0.03 | 3715.118316
 | 136390.835 |  | 0.36 | 49193.991
 | 150014.232 |  | 0.42 | 63125.69003999999
 | 164498.6256 |  | 0.18 | 29666.011608
 | 179870.0132 |  | 0.64 | 115335.528448
 | 196154.3922 |  | 0.06 | 11791.624932
 | 213377.76 |  | 0.1 | 21378.318
 | 231566.114 |  | 0.27 | 62641.64538000001
 | 250745.4516 |  | 0.13 | 32658.843308
 | 270941.7702 |  | 0.5 | 135728.2801
 | 292181.0672 |  | 0.59 | 172714.362248
 | 314489.34 |  | 0.44 | 138638.2228
 | 337892.586 |  | 0.47 | 159111.25542
 | 362416.8025999999 |  | 0.39 | 141611.103114
 | 388087.9872 |  | 0.02 | 7776.507143999999
 | 414932.1372 |  | 0.68 | 282689.944896
 | 442975.25 |  | 0.56 | 248537.464
 | 472243.323 |  | 0.04 | 18925.62332
 | 502762.3536 |  | 0.19 | 95706.34468400001
 | 534558.3392 |  | 0.4 | 214229.59968
 | 567657.2772000001 |  | 0.09 | 51186.22444800002
 | 602085.165 |  | 0.38 | 229227.0675
 | 637868.0000000001 |  | 0.6 | 383447.97
 | 81351.104 |  | 0.43 | 35047.43982000001
 | 90842.10673999999 |  | 0.29 | 26394.2649546
 | 101113.089672 |  | 0.33 | 33430.71589176
 | 112204.961186 |  | 0.45 | 50588.16803370001
 | 124159.669568 |  | 0.58 | 72149.43034944
 | 137020.203 |  | 0.08 | 10982.44344
 | 150830.58956 |  | 0.61 | 92181.47343160001
 | 165635.897222 |  | 0.49 | 81315.79753877998
 | 181482.233856 |  | 0.52 | 94550.06800511999
 | 198416.747228 |  | 0.53 | 105360.68073084
 | 216487.625 |  | 0.3 | 65069.6865
 | 61322.9767116 |  | 0.34 | 20889.425481944
 | 69637.39843648 |  | 0.48 | 33489.4600495104
 | 78752.52586000001 |  | 0.69 | 54442.48754340001
 | 88723.27142280001 |  | 0.35 | 31112.14449798
 | 99606.97422207998 |  | 0.63 | 62871.62125991039
 | 34899.624163888 |  | 0.22 | 7692.50551605536
 | 41149.80492117119 |  | 0.62 | 25561.35065112614
 | 48126.768102 |  | 0.37 | 17840.73699774
 | 55893.52271018801 |  | 0.26 | 14559.92790464888
 | 64517.02143989758 |  | 0.07 | 4524.772100792831
 | 74068.31996467199 |  | 0.66 | 48977.97297668351
 | 84622.7393461552 |  | 0.15 | 12717.52790192328
Total Direct Personnel Salaries (Subtotal Project Faculty & Staff)
*estimated total cost for Title IV-E related activities
Note:  Please refer to Title IV-E Training Handbook for detailed information regarding allowable expenses, documentation requirements, etc.
Title IV-E Training Contracts Handbook