BREAKING INTO EUROPEAN DEFENCE PROCUREMENT - BLANK MODEL SET: THE BOOK'S OWN INPUTS

Type these back into the blank files and the book's results come back. Cell references are sheet!cell.
The readiness, interview and opportunity tracker has no blank version: it arrives as a blank record.

The_Money_and_the_Instruments_Blank.xlsx  (Chapters 1 and 2)

   The build-up!C6                           343
   The build-up!D6                           381
   The build-up!C7                           0.019
   The build-up!D7                           0.021
   The build-up!C8                           106
   The build-up!D8                           130
   The build-up!C9                           88
   The build-up!C10                          5
   The build-up!C21                          0.39
   The build-up!C27                          0.02
   The build-up!C28                          0.35
   The build-up!C29                          12
   The build-up!C30                          27
   The build-up!C37                          183.4
   The build-up!D37                          0.138
   The build-up!C38                          633000
   The build-up!D38                          0.086
   The build-up!C39                          60
   The build-up!C43                          200000
   Readiness 2030!C5                         800
   Readiness 2030!C6                         650
   Readiness 2030!C7                         150
   Readiness 2030!C15                        2025
   Readiness 2030!C16                        2028
   Readiness 2030!C17                        0.015
   Readiness 2030!C18                        18
   Readiness 2030!C19                        27
   The Roadmap targets!B4                    2026-08-20
   The Roadmap targets!B8                    2027-12-31
   The Roadmap targets!C8                    0.4
   The Roadmap targets!D8                    0.35
   The Roadmap targets!B9                    2030-12-31
   The Roadmap targets!C9                    0.55
   The Roadmap targets!B10                   2028-09-30
   The Roadmap targets!C10                   0.5
   The Roadmap targets!B11                   2030-12-31
   The Roadmap targets!C11                   200000
   The Roadmap targets!D11                   633000
   The Roadmap targets!B12                   2026-03-31
   The Roadmap targets!C12                   9
   The Roadmap targets!B13                   2030-12-31
   The Roadmap targets!B14                   2027-12-31
   The Roadmap targets!B15                   2028-12-31
   The Roadmap targets!B16                   2026-06-30
   The Roadmap targets!B17                   2026-06-30
   The four instruments!D5                   7.953
   The four instruments!D6                   0.3
   The four instruments!D7                   0.5
   The four instruments!D8                   1.5
   The four instruments!D9                   150
   The four instruments!D17                  7.953
   The four instruments!D18                  2.651
   The four instruments!D19                  5.302
   The four instruments!D24                  7.3
   The four instruments!D28                  410
   The four instruments!D29                  0.37
   The four instruments!D31                  1065
   The four instruments!D32                  1070
   The four instruments!D33                  675
   The four instruments!D34                  332
   The four instruments!D38                  57
   The four instruments!D39                  32
   The four instruments!D40                  25
   The four instruments!D44                  634
   The four instruments!D46                  0.38
   The four instruments!D47                  0.21
   The four instruments!D55                  1200
   The four instruments!D56                  300
   The four instruments!D57                  325
   The four instruments!D58                  240
   The four instruments!D59                  100
   The four instruments!D61                  260
   The four instruments!D64                  35.3
   Leverage!C5                               300
   Leverage!C6                               5
   Leverage!C7                               60
   Leverage!C10                              20
   Leverage!C11                              6
   Leverage!C14                              11
   Leverage!C20                              500
   Leverage!C21                              1.4
   Leverage!C23                              31
   Leverage!C25                              248
   Leverage!C26                              124
   Leverage!C27                              90
   Leverage!C28                              50
   Leverage!C29                              2
   Leverage!C38                              165
   Leverage!C39                              470
   Leverage!C41                              0.35
   Leverage!C45                              83
   Leverage!C46                              24
   Leverage!C50                              1980
   Leverage!C51                              131
   Leverage!C53                              5

   Result: investment 30.9% of expenditure; the EUR 650 bn assumes 0.90% of GDP a year; EDIP work programme commits 1,460 of 1,500; EUR 165 m at 35% implies 471.4.

The_35_Per_Cent_Content_Test_Blank.xlsx  (Chapter 7; the sixty-line tape is invented, not the book's)

   The worked example!C6                     400000
   The worked example!C7                     0.35
   The worked example!D12                    48000
   The worked example!D13                    21000
   The worked example!D14                    39000
   The worked example!C22                    72000
   The worked example!D22                    26000
   The worked example!C23                    35000
   The worked example!D23                    7000
   The worked example!C33                    8000
   The worked example!C34                    11000
   Headroom under stress!C10                 4
   Headroom under stress!C11                 0.75
   Design authority!C6                       0.35
   Design authority!C7                       0.35
   Design authority!C14                      48000
   Design authority!C15                      0
   Design authority!C16                      39000
   Design authority!C17                      21000
   Design authority!C18                      0
   Design authority!C19                      11000
   Your bill of materials!B5                 Chassis weldment
   Your bill of materials!C5                 Verlaine Industrie
   Your bill of materials!D5                 Third country
   Your bill of materials!E5                 14000
   Your bill of materials!F5                 0
   Your bill of materials!H5                 yes
   Your bill of materials!B6                 Power supply module
   Your bill of materials!C6                 Alderiq Ltd
   Your bill of materials!D6                 EU
   Your bill of materials!E6                 12000
   Your bill of materials!F6                 0
   Your bill of materials!H6                 yes
   Your bill of materials!B7                 Signal-processing assembly
   Your bill of materials!C7                 Kelvara Optics
   Your bill of materials!D7                 EU
   Your bill of materials!E7                 28000
   Your bill of materials!F7                 0
   Your bill of materials!H7                 yes
   Your bill of materials!B8                 RF front end
   Your bill of materials!C8                 Brightfell Components
   Your bill of materials!D8                 Third country
   Your bill of materials!E8                 4500
   Your bill of materials!F8                 0
   Your bill of materials!H8                 yes
   Your bill of materials!B9                 Antenna array
   Your bill of materials!C9                 Sarnia Electronique
   Your bill of materials!D9                 EEA-EFTA
   Your bill of materials!E9                 18000
   Your bill of materials!F9                 0
   Your bill of materials!H9                 yes
   Your bill of materials!B10                Cooled IR detector
   Your bill of materials!C10                Hafnia Microsystems
   Your bill of materials!D10                EEA-EFTA
   Your bill of materials!E10                36000
   Your bill of materials!F10                0
   Your bill of materials!H10                yes
   Your bill of materials!B11                Uncooled IR module
   Your bill of materials!C11                Delph Precision
   Your bill of materials!D11                EU
   Your bill of materials!E11                1300
   Your bill of materials!F11                0
   Your bill of materials!H11                yes
   Your bill of materials!B12                Inertial measurement unit
   Your bill of materials!C12                Delph Precision
   Your bill of materials!D12                Associated (NO)
   Your bill of materials!E12                3600
   Your bill of materials!F12                700
   Your bill of materials!H12                yes
   Your bill of materials!B13                GNSS receiver
   Your bill of materials!C13                Ostmark Mechanik
   Your bill of materials!D13                United States
   Your bill of materials!E13                8100
   Your bill of materials!F13                0
   Your bill of materials!H13                yes
   Your bill of materials!B14                Servo drive
   Your bill of materials!C14                Vantera Systems
   Your bill of materials!D14                EU
   Your bill of materials!E14                2500
   Your bill of materials!F14                0
   Your bill of materials!H14                yes
   Your bill of materials!B15                Gearbox
   Your bill of materials!C15                Kelvara Optics
   Your bill of materials!D15                EU
   Your bill of materials!E15                3400
   Your bill of materials!F15                1000
   Your bill of materials!H15                yes
   Your bill of materials!B16                Slip ring
   Your bill of materials!C16                Nordlicht GmbH
   Your bill of materials!D16                EU
   Your bill of materials!E16                7600
   Your bill of materials!F16                2200
   Your bill of materials!H16                yes
   Your bill of materials!B17                Wiring harness
   Your bill of materials!C17                Nordlicht GmbH
   Your bill of materials!D17                EU
   Your bill of materials!E17                5300
   Your bill of materials!F17                0
   Your bill of materials!H17                yes
   Your bill of materials!B18                Connector set
   Your bill of materials!C18                Delph Precision
   Your bill of materials!D18                United States
   Your bill of materials!E18                8900
   Your bill of materials!F18                0
   Your bill of materials!H18                yes
   Your bill of materials!B19                Cooling fan assembly
   Your bill of materials!C19                Hafnia Microsystems
   Your bill of materials!D19                Third country
   Your bill of materials!E19                8200
   Your bill of materials!F19                0
   Your bill of materials!H19                yes
   Your bill of materials!B20                Heat exchanger
   Your bill of materials!C20                Nordlicht GmbH
   Your bill of materials!D20                Third country
   Your bill of materials!E20                5100
   Your bill of materials!F20                0
   Your bill of materials!H20                yes
   Your bill of materials!B21                Environmental seal kit
   Your bill of materials!C21                Alderiq Ltd
   Your bill of materials!D21                Associated (NO)
   Your bill of materials!E21                2200
   Your bill of materials!F21                0
   Your bill of materials!H21                yes
   Your bill of materials!B22                Display unit
   Your bill of materials!C22                Alderiq Ltd
   Your bill of materials!D22                EU
   Your bill of materials!E22                8600
   Your bill of materials!F22                0
   Your bill of materials!H22                yes
   Your bill of materials!B23                Operator console
   Your bill of materials!C23                Delph Precision
   Your bill of materials!D23                EU
   Your bill of materials!E23                900
   Your bill of materials!F23                0
   Your bill of materials!H23                yes
   Your bill of materials!B24                Ruggedised computer
   Your bill of materials!C24                Kelvara Optics
   Your bill of materials!D24                EU
   Your bill of materials!E24                21000
   Your bill of materials!F24                8000
   Your bill of materials!H24                yes
   Your bill of materials!B25                Solid-state drive
   Your bill of materials!C25                Verlaine Industrie
   Your bill of materials!D25                Third country
   Your bill of materials!E25                2500
   Your bill of materials!F25                0
   Your bill of materials!H25                yes
   Your bill of materials!B26                Ethernet switch
   Your bill of materials!C26                Alderiq Ltd
   Your bill of materials!D26                EU
   Your bill of materials!E26                2400
   Your bill of materials!F26                0
   Your bill of materials!H26                yes
   Your bill of materials!B27                Fibre transceiver
   Your bill of materials!C27                Vantera Systems
   Your bill of materials!D27                United States
   Your bill of materials!E27                1200
   Your bill of materials!F27                0
   Your bill of materials!H27                yes
   Your bill of materials!B28                Battery pack
   Your bill of materials!C28                Ostmark Mechanik
   Your bill of materials!D28                United States
   Your bill of materials!E28                3200
   Your bill of materials!F28                0
   Your bill of materials!H28                yes
   Your bill of materials!B29                Charger unit
   Your bill of materials!C29                Kelvara Optics
   Your bill of materials!D29                United States
   Your bill of materials!E29                4700
   Your bill of materials!F29                0
   Your bill of materials!H29                yes
   Your bill of materials!B30                DC-DC converter
   Your bill of materials!C30                Nordlicht GmbH
   Your bill of materials!D30                EU
   Your bill of materials!E30                2100
   Your bill of materials!F30                0
   Your bill of materials!H30                yes
   Your bill of materials!B31                EMI filter
   Your bill of materials!C31                Alderiq Ltd
   Your bill of materials!D31                EU
   Your bill of materials!E31                6500
   Your bill of materials!F31                0
   Your bill of materials!H31                yes
   Your bill of materials!B32                Circuit breaker panel
   Your bill of materials!C32                Hafnia Microsystems
   Your bill of materials!D32                EU
   Your bill of materials!E32                1100
   Your bill of materials!F32                0
   Your bill of materials!H32                yes
   Your bill of materials!B33                Cable gland set
   Your bill of materials!C33                Brightfell Components
   Your bill of materials!D33                United States
   Your bill of materials!E33                7100
   Your bill of materials!F33                0
   Your bill of materials!H33                yes
   Your bill of materials!B34                Mounting bracket set
   Your bill of materials!C34                Alderiq Ltd
   Your bill of materials!D34                EU
   Your bill of materials!E34                1900
   Your bill of materials!F34                0
   Your bill of materials!H34                yes
   Your bill of materials!B35                Vibration isolator
   Your bill of materials!C35                Sarnia Electronique
   Your bill of materials!D35                EU
   Your bill of materials!E35                2700
   Your bill of materials!F35                0
   Your bill of materials!H35                yes
   Your bill of materials!B36                Shock mount
   Your bill of materials!C36                Delph Precision
   Your bill of materials!D36                Third country
   Your bill of materials!E36                4100
   Your bill of materials!F36                0
   Your bill of materials!H36                yes
   Your bill of materials!B37                Optical window
   Your bill of materials!C37                Sarnia Electronique
   Your bill of materials!D37                Third country
   Your bill of materials!E37                6600
   Your bill of materials!F37                0
   Your bill of materials!H37                yes
   Your bill of materials!B38                Lens assembly
   Your bill of materials!C38                Alderiq Ltd
   Your bill of materials!D38                EU
   Your bill of materials!E38                1600
   Your bill of materials!F38                0
   Your bill of materials!H38                no
   Your bill of materials!B39                Filter wheel
   Your bill of materials!C39                Brightfell Components
   Your bill of materials!D39                EU
   Your bill of materials!E39                8100
   Your bill of materials!F39                2200
   Your bill of materials!H39                yes
   Your bill of materials!B40                Focus mechanism
   Your bill of materials!C40                Verlaine Industrie
   Your bill of materials!D40                Third country
   Your bill of materials!E40                6600
   Your bill of materials!F40                0
   Your bill of materials!H40                yes
   Your bill of materials!B41                Stepper motor
   Your bill of materials!C41                Verlaine Industrie
   Your bill of materials!D41                EU
   Your bill of materials!E41                6300
   Your bill of materials!F41                2700
   Your bill of materials!H41                yes
   Your bill of materials!B42                Encoder
   Your bill of materials!C42                Brightfell Components
   Your bill of materials!D42                EU
   Your bill of materials!E42                2600
   Your bill of materials!F42                0
   Your bill of materials!H42                yes
   Your bill of materials!B43                Limit switch set
   Your bill of materials!C43                Kelvara Optics
   Your bill of materials!D43                EU
   Your bill of materials!E43                3900
   Your bill of materials!F43                0
   Your bill of materials!H43                yes
   Your bill of materials!B44                Temperature sensor set
   Your bill of materials!C44                Delph Precision
   Your bill of materials!D44                EU
   Your bill of materials!E44                1600
   Your bill of materials!F44                0
   Your bill of materials!H44                yes
   Your bill of materials!B45                Pressure sensor
   Your bill of materials!C45                Brightfell Components
   Your bill of materials!D45                EU
   Your bill of materials!E45                2300
   Your bill of materials!F45                0
   Your bill of materials!H45                yes
   Your bill of materials!B46                Humidity sensor
   Your bill of materials!C46                Hafnia Microsystems
   Your bill of materials!D46                EU
   Your bill of materials!E46                1000
   Your bill of materials!F46                0
   Your bill of materials!H46                yes
   Your bill of materials!B47                Accelerometer
   Your bill of materials!C47                Verlaine Industrie
   Your bill of materials!D47                Associated (NO)
   Your bill of materials!E47                3000
   Your bill of materials!F47                0
   Your bill of materials!H47                yes
   Your bill of materials!B48                Gyroscope module
   Your bill of materials!C48                Delph Precision
   Your bill of materials!D48                EU
   Your bill of materials!E48                4500
   Your bill of materials!F48                0
   Your bill of materials!H48                yes
   Your bill of materials!B49                Magnetometer
   Your bill of materials!C49                Kelvara Optics
   Your bill of materials!D49                EU
   Your bill of materials!E49                4800
   Your bill of materials!F49                0
   Your bill of materials!H49                yes
   Your bill of materials!B50                Radio module
   Your bill of materials!C50                Vantera Systems
   Your bill of materials!D50                United States
   Your bill of materials!E50                6700
   Your bill of materials!F50                0
   Your bill of materials!H50                yes
   Your bill of materials!B51                Crypto module
   Your bill of materials!C51                Sarnia Electronique
   Your bill of materials!D51                United States
   Your bill of materials!E51                2400
   Your bill of materials!F51                0
   Your bill of materials!H51                yes
   Your bill of materials!B52                Key fill device interface
   Your bill of materials!C52                Alderiq Ltd
   Your bill of materials!D52                United States
   Your bill of materials!E52                5000
   Your bill of materials!F52                0
   Your bill of materials!H52                yes
   Your bill of materials!B53                Firmware licence
   Your bill of materials!C53                Vantera Systems
   Your bill of materials!D53                Third country
   Your bill of materials!E53                7500
   Your bill of materials!F53                0
   Your bill of materials!H53                yes
   Your bill of materials!B54                Test adapter
   Your bill of materials!C54                Sarnia Electronique
   Your bill of materials!D54                United States
   Your bill of materials!E54                3500
   Your bill of materials!F54                0
   Your bill of materials!H54                yes
   Your bill of materials!B55                Calibration fixture
   Your bill of materials!C55                Brightfell Components
   Your bill of materials!D55                EU
   Your bill of materials!E55                3900
   Your bill of materials!F55                0
   Your bill of materials!H55                yes
   Your bill of materials!B56                Paint and coating
   Your bill of materials!C56                Hafnia Microsystems
   Your bill of materials!D56                EU
   Your bill of materials!E56                7500
   Your bill of materials!F56                2600
   Your bill of materials!H56                no
   Your bill of materials!B57                Fastener set
   Your bill of materials!C57                Kelvara Optics
   Your bill of materials!D57                EU
   Your bill of materials!E57                2300
   Your bill of materials!F57                0
   Your bill of materials!H57                no
   Your bill of materials!B58                Label and marking kit
   Your bill of materials!C58                Ostmark Mechanik
   Your bill of materials!D58                EU
   Your bill of materials!E58                9100
   Your bill of materials!F58                0
   Your bill of materials!H58                yes
   Your bill of materials!B59                Transit case
   Your bill of materials!C59                Ostmark Mechanik
   Your bill of materials!D59                Associated (NO)
   Your bill of materials!E59                3800
   Your bill of materials!F59                0
   Your bill of materials!H59                yes
   Your bill of materials!B60                Desiccant assembly
   Your bill of materials!C60                Alderiq Ltd
   Your bill of materials!D60                Third country
   Your bill of materials!E60                3800
   Your bill of materials!F60                0
   Your bill of materials!H60                yes
   Your bill of materials!B61                Grounding kit
   Your bill of materials!C61                Brightfell Components
   Your bill of materials!D61                EU
   Your bill of materials!E61                8100
   Your bill of materials!F61                0
   Your bill of materials!H61                yes
   Your bill of materials!B62                Lightning arrestor
   Your bill of materials!C62                Alderiq Ltd
   Your bill of materials!D62                EU
   Your bill of materials!E62                6100
   Your bill of materials!F62                0
   Your bill of materials!H62                yes
   Your bill of materials!B63                Software build tooling
   Your bill of materials!C63                Alderiq Ltd
   Your bill of materials!D63                EU
   Your bill of materials!E63                2100
   Your bill of materials!F63                0
   Your bill of materials!H63                no
   Your bill of materials!B64                Documentation set
   Your bill of materials!C64                Kelvara Optics
   Your bill of materials!D64                EU
   Your bill of materials!E64                6500
   Your bill of materials!F64                0
   Your bill of materials!H64                yes
   Design authority!A14                      RF power amplifier module
   Design authority!B14                      ITAR, United States
   Design authority!A15                      Gate-array firmware toolchain
   Design authority!B15                      EAR, United States
   Design authority!A16                      Cooled infrared detector
   Design authority!B16                      third-country national control
   Design authority!A17                      Inertial measurement unit
   Design authority!B17                      third-country national control
   Design authority!A18                      Crypto module
   Design authority!B18                      national approval, EU
   Design authority!A19                      Data converters (requalified)
   Design authority!B19                      none after requalification

   Result: 27.0% first pass, 35.25% after the drill-down, 33.00% after requalification; the headroom absorbs 9.31% of foreign cost inflation.

Proposal_Economics_and_Scoring_Blank.xlsx  (Chapters 3 and 9; the action and its figures are illustrative)

   Funding rates!C11                         40
   Funding rates!C13                         0.65
   Funding rates!C14                         0.35
   Funding rates!D21                         1
   Funding rates!D22                         0
   Funding rates!D23                         1
   Funding rates!D24                         0
   The co-financing trap!C8                  36
   The co-financing trap!C9                  7
   The co-financing trap!C10                 0.12
   The co-financing trap!C22                 0.55
   The co-financing trap!C23                 0.35
   The co-financing trap!C24                 0.1
   The co-financing trap!E22                 1
   The co-financing trap!E23                 0
   The co-financing trap!E24                 0
   The co-financing trap!C32                 250
   The co-financing trap!C33                 0.55
   The co-financing trap!C34                 0.12
   The co-financing trap!C36                 0.12
   The co-financing trap!C49                 0.08
   EDIP windows!C22                          60
   EDIP windows!C35                          165
   EDIP windows!C36                          470
   Scoring!C5                                27
   Scoring!C6                                3
   Scoring!C7                                1
   Scoring!C8                                4
   Scoring!C9                                12
   Scoring!C10                               24
   Scoring!C11                               50
   Scoring!C17                               2
   Scoring!D17                               5
   Scoring!E17                               4.2
   Scoring!C18                               2
   Scoring!D18                               5
   Scoring!E18                               3.8
   Scoring!C19                               1
   Scoring!D19                               5
   Scoring!E19                               4.5
   Scoring!G17                               4
   Scoring!C23                               18

   Result: blended rate 41.0%, EU support 22.4 of 40; break-even probability 58.7%; your score 20.5, passing both tests.

