RockandGrohl
Well-known Member
- Joined
- Aug 1, 2018
- Messages
- 790
- Office Version
- 365
- Platform
- Windows
I feel like I'm abusing this forum with the amount of questions I have.
On Column A there is a list 300-strong of paper names. You can have things like:
<tbody>
</tbody>
These papers and templates need to have different tours assigned to them, I think there's 3 I need to worry about:
UK Tours
EU Tours
Promo Tours
Every week we choose a tour to put in Promo sizes (16x9 and 17x6) and if a paper has this size available in column B, it should be a promo size.
Otherwise for any paper that only features once (such as Eastleigh Times and Clacton) we would want to feature a UK tour.
For any paper that features multiple times (either same name or multiples in a week), we want one of the features to be EU.
So Gloucester Echo would have 1 UK and one EU.
To illustrate this, I think we have a maximum of 5 same papers in any one week, so here's what I would want, the number is the number of features:
1 - 1 UK
2 - 1 UK, 1 EU
3 - 2 UK, 1 EU
4 - 3 UK, 1 EU
5 - 4 UK, 1 EU
And anywhere there is a 17x6 or a 16x9 in the Template Size, this should be a Promo tour.
So who's up to the challenge?
On Column A there is a list 300-strong of paper names. You can have things like:
A | B | C | |
1 | Paper | Template Size | Ideal Result |
2 | Banbury Guardian - Mon | 16x9 | Promo |
3 | Banbury Guardian - Tue | 17x9 | UK |
4 | Banbury Guardian - Fri | 17x9 | EU |
5 | Clacton & Frinton Gazette | 17x9 | UK |
6 | Eastleigh Times | 20x4 | UK |
7 | Gloucester Echo - Tue | 17x6 | UK |
8 | Gloucester Echo - Thu | 17x6 | Promo |
<tbody>
</tbody>
These papers and templates need to have different tours assigned to them, I think there's 3 I need to worry about:
UK Tours
EU Tours
Promo Tours
Every week we choose a tour to put in Promo sizes (16x9 and 17x6) and if a paper has this size available in column B, it should be a promo size.
Otherwise for any paper that only features once (such as Eastleigh Times and Clacton) we would want to feature a UK tour.
For any paper that features multiple times (either same name or multiples in a week), we want one of the features to be EU.
So Gloucester Echo would have 1 UK and one EU.
To illustrate this, I think we have a maximum of 5 same papers in any one week, so here's what I would want, the number is the number of features:
1 - 1 UK
2 - 1 UK, 1 EU
3 - 2 UK, 1 EU
4 - 3 UK, 1 EU
5 - 4 UK, 1 EU
And anywhere there is a 17x6 or a 16x9 in the Template Size, this should be a Promo tour.
So who's up to the challenge?