An aerosol model was used to simulate the generation and transport of aerosols over Germany during the HD(CP)2 Observational Prototype Experiment (HOPE) field campaign of 2013. The aerosol number concentrations and size distributions were evaluated against observations, which shows satisfactory agreement in the magnitude and temporal variability of the main aerosol contributors to cloud condensation nuclei (CCN) concentrations. From the modelled aerosol number concentrations, number concentrations of CCN were calculated as a function of vertical velocity using a comprehensive aerosol activation scheme which takes into account the influence of aerosol chemical and physical properties on CCN formation. There is a large amount of spatial variability in aerosol concentrations; however the resulting CCN concentrations vary significantly less over the domain. Temporal variability is large in both aerosols and CCN. A parameterization of the CCN number concentrations is developed for use in models. The technique involves defining a number of best fit functions to capture the dependence of CCN on vertical velocity at different pressure level ... mehrs. In this way, aerosol chemical and physical properties as well as thermodynamic conditions are taken into account in the new CCN parameterization. A comparison between the parameterization and the CCN estimates from the model data shows excellent agreement. This parameterization may be used in other regions and time periods with a similar aerosol load; furthermore, the technique demonstrated here may be employed in regions dominated by different aerosol species.