Spreadsheet: 27198895-c9d2-4485-86cf-47c81e5b7dbc
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
DevDet - WP11 Testbeam
Beneficiary short name | Average direct monthly salary * (€) | Rate for personnel indirect costs (%) | Rate for material and travel indirect costs (%) |  | Subproject | Task 1 | Task 2 | Task 3 | Comment |  | Super B
CERN - AB | 5800 | 0.6 | 0.6 |  | Common | Beamline | Moveable equipment | Related infrastructure |  |  | Not moveable equipment
CERN - ATLAS | 5800 | 0.6 | 0.6 |  | ATLAS |  | DAQ, DCS, readout | Cooling |  |  | Remotely controlled mechanics at BTF | LNF
PRAGUE-AS, TU, CH | 4000 | 0.6 | 0.6 |  | ATLAS |  | DAQ, DCS, readout | Cooling |  |  | Beam monitor with GEM | LNF
OSLO | 5800 | 0.6 | 0.6 |  | ATLAS |  | DAQ, telescope |  |  |  | Beam calorimeter | LNF
NIKHEF | 5400 | 0.6 | 0.6 |  | ATLAS |  | Mechical table ? | Cooling |  |  |  | PG
BONN | 4200 | 0.6 | 0.6 |  | ATLAS |  | DAQ, telescope |  |  |  | Magnetic field probes | LNF
FREIBOURG | 4200 | 0.6 | 0.6 |  | ATLAS |  | DAQ, telescope |  |  |  | Improve tagged photon beam | LNF
GOETTINGEN | 4200 | 0.6 | 0.6 |  | ATLAS |  | DAQ, DCS, readout
Geneva | 5800 | 0.6 | 0.6 |  | ATLAS |  | DCS |  |  |  | Moveable equipment
CERN - CMS | 5800 | 0.6 | 0.6 |  | CMS |  | x |  |  |  | Straw tube telescope | LNF
HELSINKI | 5800 | 0.6 | 0.6 |  | CMS |  | Telescope |  |  |  | Development of BTF DAQ | LNF
INFN-CMS | 4200 | 0.6 | 0.6 |  | CMS |  | x |  | Which groups ? |  |  | FE
AACHEN | 4200 | 0.6 | 0.6 |  | CMS |  |  | Cooling |  |  | Related infrastructure
CANTABRIA | 3900 | 0.6 | 0.6 |  | CMS |  | x |  |  |  | Thermohydraulic testbench | PI
Neutrino groups | 5800 | 0.6 | 0.6 |  | [NAME] (to be expanded) | [NAME], TOF, [NAME] | DAQ, readout, etc
INFN-SuperB | 4200 | 0.6 | 0.6 |  | SuperB (to be expanded) | Beamline upgrade | Telescope and DAQ | Thermal testbench | See on the right
GLASGOW | 5400 | 0.6 | 0.6 |  | LHCb |  | DAQ, readout, telescope
IN2P3 | 4200 | 0.6 | 0.6 |  | ATLAS and CMS? |  | Telescope/DAQ for 3D
CNRS | 4200 | 0.6 | 0.6 |  | Undefined |  | To be clarified |  | Focus MICROMEGAS, WP9?
* To prevent rounding problems on the cost data, give the monthly salary as a multiple of 100 €
Beneficiary short name ª (all costs in €) | Person-Months | Personnel direct costs | Personnel indirect costs | Sub-contracting cost | Consumable and prototype direct costs | Travel direct costs | Material and travel indirect costs | Total direct costs | Toal indirect costs | Total costs (direct +indirect) | EC requested funding | Sums | Goal | Comment
CERN - AB | 48 | 278400 | 167040 | 0 | 260000 | 10000 | 162000 | 548400 | 329040 | 877440 | 292480 | 292480 | 300000
CERN - ATLAS | 18 | 104400 | 62640 | 0 | 20000 | 5000 | 15000 | 129400 | 77640 | 207040 | 69013.33333333333 | 465173.3333333333 | 400000 | ATLAS
PRAGUE-AS, TU, CH | 18 | 72000 | 43200 | 0 | 20000 | 10000 | 18000 | 102000 | 61200 | 163200 | 54400 |  |  | Have real input
OSLO | 18 | 104400 | 62640 | 0 | 20000 | 10000 | 18000 | 134400 | 80640 | 215040 | 71680
NIKHEF | 24 | 129600 | 77760 | 0 | 20000 | 5000 | 15000 | 154600 | 92760 | 247360 | 82453.33333333333 |  |  | Have real input
BONN | 18 | 75600 | 45360 | 0 | 20000 | 8000 | 16800 | 103600 | 62160 | 165760 | 55253.33333333334
FREIBOURG | 12 | 50400 | 30240 | 0 | 10000 | 8000 | 10800 | 68400 | 41040 | 109440 | 36480
GOETTINGEN | 12 | 50400 | 30240 | 0 | 5000 | 5000 | 6000 | 60400 | 36240 | 96640 | 32213.33333333333
Geneva | 18 | 104400 | 62640 | 0 | 10000 | 5000 | 9000 | 119400 | 71640 | 191040 | 63680
CERN - CMS | 125 | 725000 | 435000 | 0 | 20000 | 10000 | 18000 | 755000 | 453000 | 1208000 | 402666.6666666667 | 402666.6666666667 | 400000 | CMS
HELSINKI | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Need breakdown on CMS groups, for tasks and budgets, [NAME] is clear for thermal box and cooling
INFN-CMS | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
AACHEN | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
CANTABRIA | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Neutrino groups | 110 | 638000 | 382800 | 0 | 80000 | 35000 | 69000 | 753000 | 451800 | 1204800 | 401600 | 401600 | 400000 | Neutrino
INFN-SuperB | 92 | 386400 | 231840 | 0 | 80000 | 5000 | 51000 | 471400 | 282840 | 754240 | 251413.3333333333 | 251413.3333333333 | 250000 | SuperB
GLASGOW | 12 | 64800 | 38880 | 0 | 20000 | 5000 | 15000 | 89800 | 53880 | 143680 | 47893.33333333334 |  |  | LHCb
IN2P3 | 12 | 50400 | 30240 | 0 | 20000 | 5000 | 15000 | 75400 | 45240 | 120640 | 40213.33333333334
CNRS | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Totals: | 537 | 2834200 | 1700520 | 0 | 605000 | 126000 | 438600 | 3565200 | 2139120 | 5704320 | 1901440
FIXED TARGETS |  |  |  |  |  |  |  |  |  | 5250000 | 1750000 |  | 1750000
CHECKING THE CONDITION |  |  |  |  |  |  |  |  |  | NOT OK | NOT OK
ª In alphabetic order
Material cost = consumable + prototype costs (assuming there are no durable equipment submitted to depreciation)
Personnel costs = person-months * monthly direct salary (inclusive contributions to social and other benefits)
Sub-contracting => note: subcontracted items do not give rise to reimbursement of overheads
Note: for TA and NA full-rate overheads have to be decalred according to the 1st table. EC nonetheless re-imburses 7% for these activities.
=> with the EU funding requested in the 2nd Table, it is possible to pay for more person-months than listed