Here is a query that produces total number of scenarios by year:
Code:
SELECT sYear, count(*) AS Total
FROM ScenData.db
WHERE (sMonth > 0 AND sYear > 0) AND ScenID !=999
GROUP BY sYear
ORDER BY Total DESC
Not too surprisingly here is the list:
Code:
sYear Total
1944 199
1945 114
1941 109
1943 100
1942 91
1940 75
1939 57
1936 6
1938 6
1937 5
1934 4
1935 3
1946 2
1933 2
1932 1
1931 1
1930 1
* Note: I excluded out the twenty-five 1930 scenario's (real dates 1908-1929) I am currently working for this result.