Scenario Database

[MarkSheppard]

Started this little database to make finding interesting scenarios easier for everyone - all the scenarios are in now.

version 1.0 is attached as an XLS file, which just about any serious spreadsheet program can use; from there, it's just a matter of sorting the data to bring what you'd like to the top.

It's arranged like so:

Slot No--------------Title--------------------------------Battle/Front--------------Date------------Side 1----------Side 2---------Best Played As
36---------Goering Regiment at Uman---------Eastern Front 1941---------08/02/41---------Soviet---------German---------Germans
8---------------Dickens I Hill 445 -----------------------Italy 1944-------------03/15/44---------ANZAC------German
37--------Valentine's Day Air Mail-------------Pacific Theatre 1942--------02/14/42---------Japan---------Dutch
39-------------Bloody Ridge-----------------------Guadalcanal 1942---------09/13/42---------Japan---------USMC


So if you only want to look for eastern front battles, just sort column C alphabetically, and look for the row of eastern front battles. You could then add a secondary sorting feature to sort them by "best as" to find those scenarios best played as either germans or soviets easily.

[dlazov]

Mark,

Thanks!

Once your done could you repost or update?

[MarkSheppard]

I just updated it, so far 227 out of 359 are in

[dlazov]

Mark,

Cool, your smoking....

104-236 are blank or you know that, sorry.

Once your done do you mind if I convert this to a SQL Server Database? I could make some snappy web pages on it.

I could not host it, but it would be cool to build it out in web format.

[MarkSheppard]

That's an excellent idea, an online web-based database of stock SPWW2 scenarios..

One of the problems I'm coming across is how to classify the scenarios; I don't want to get too specific; and I wonder if it's more appropriate to write:

"Poland 1944"
"Germany 1945"
"Hungary 1944"

than simply "Eastern Front 1944/45"

[Double_Deuce]

dlazov said:
Once your done do you mind if I convert this to a SQL Server Database? I could make some snappy web pages on it.

I could not host it, but it would be cool to build it out in web format.

I have access to a windows server but no little if anything about MsSQL. What about using MySQL? I have some Linux accounts with that available as well.

What would be needed to get this up and running online?

[MarkSheppard]

Version 1.0 uploaded; using it as a base here are some rough statistics, I didn't count every thing so this is sort of incomplete:

12 Scenarios dealing with the Arnheim (A Bridge too Far) Campaign

12 Scenarios dealing with the Balkans 1940-1944

4 Scenarios dealing with the Battle of the Bulge

3 Scenarios dealing with Burma 1942-1943

2 Scenarios dealign with China 1937-1944

3 Scenarios Dealing with Crete 1941

1 Scenario dealing with East Africa 1940

121 Scenarios dealing in one way or another with the Eastern Front 1941-1945

4 Scenarios dealing with Finland 1941-1944

25 Scenarios dealing with France 1940

2 Scenarios dealing with Guadalcanal 1942

4 Scenarios dealing with Hungary 1944-1945

3 Hypothetical scenarios set in Germany 1945, Gibraltar 1940, and Sweden 1940

4 Scenarios set in Italy 1943-1944

5 Scenarios dealing with Iwo Jima 1945

2 Scenarios Dealing with Kursk 1943

30 Scenarios Dealing with Normandy 1944 (and possibly France 1944)

26 Scenarios Dealing with North Africa 1940-1942

6 Scenarios dealing with Norway 1940

5 Scenarios dealing with the PTO from 1941-1942

2 Scenarios Dealing with the Phillipines 1941-1945

23 Scenarios dealing with Poland 1939

4 Scenarios dealing with Sicily 1943

4 Scenarios Dealing with the Spanish Civil War

8 Scenarios dealing with Stalingrad 1942

23 Scenarios dealing with the Western Front 1942-1945

3 Scenarios dealing with the Winter War