|
Showing posts with label Excel. Show all posts
Showing posts with label Excel. Show all posts
TRICKS OF THE TRADE: ‘JENA-AUERSTADT’ PBeM PLAY AID0 commentsMOVEMENT & COMBAT TURN RECORD TEMPLATE FOR SPI’S ‘JENA-AUERSTADT’ (1975)Back on 27 January of this year, I published a set of PBeM (spreadsheet-style) Turn Record Templates for SPI’s MARENGO and WAGRAM; at the time, I didn’t include similar templates for the other two titles (BATTLE OF NATIONS and JENA-AUERSTADT) that make up the NAPOLEON AT WAR Quadri-game because, frankly, I couldn’t remember where I had stored their files. A few days ago, and quite by accident, I finally stumbled across the turn record spreadsheet for JENA-AUERSTADT. Given the fact that there are still no internet game platforms for this batch of older SPI titles, I have decided to publish this PBeM player aid as a favor to those gamers who continue to enjoy these early Napoleonic games, but who nonetheless have a difficult time finding face-to-face opponents when it comes to these titles. Needless-to-say, if I ever figure out where I hid the template for BATTLE OF NATIONS then I will immediately publish it, as well. For those players who are unfamiliar with this title, JENA-AUERSTADT offers the Prussian commander the choice of dividing his army and fighting two simultaneous battles: one engagement at Jena against the bulk of the French army under Napoleon, and the other against Marshal Davout’s out-numbered IIIrd Corps at Auerstadt (the historical scenario); alternatively, the Prussian player can choose to mass all of his forces at Jena in an effort to defeat the advancing Grande Armée before it can complete its concentration. The Prussians and their allies are outnumbered and less mobile than the more nimble French, but an all-or-nothing fight at Jena — because the bulk of Napoleon’s forces begin the game off-map and enter play a few units at a time — gives the Prussian player an excellent opportunity to defeat the French army in detail. In view of this unusual design feature, I believe that JENA-AUERSTADT offers players a fascinating set of operational problems and although it is a relatively simple “beer and pretzels” sort of game, it nonetheless is still one of my personal favorites. The Excel ‘spreadsheet’ file offered here is for the original SPI version of JENA-AUERSTADT (1975). This file has been set up to permit competing players to exchange new game moves via email attachments and, at the same time, to keep an accurate and detailed, ongoing record of all of the various game operations that can potentially occur in the course of a complete twelve turn match of this simple, but elegant game of Napoleonic warfare. JENA-AUERSTADT Excel spreadsheet link Additional useful game-related Internet linksTRICKS OF THE TRADE: ‘STALINGRAD’ PBeM PLAY AID4 commentsMOVEMENT & COMBAT TURN RECORD TEMPLATE FOR THE TAHGC GAME, ‘STALINGRAD’ (1963/1974)When everything is said and done, there is really nothing like face-to-face competition when it comes to playing wargames. Unfortunately, most players will find — particularly, as time goes on — that local face-to-face opponents can sometimes be hard to find. Happily, the ‘internet revolution’, besides its many other contributions to modern life, has also led to the development of a number of easy-to-use gaming software applications such as VASSAL, Cyberboard, and Zun Tzu, all of which have made ‘electronic’ wargaming both much faster and much more convenient than its play-by-mail (PBM) predecessor. In most cases, these gaming support sites will offer players all of the software tools they need to play online. However, there may still be times when reliance on one of these internet software applications is neither practical nor even preferable. In some cases, players will find that platforms for their favorite older games are not yet available on line. Or, if their favorite title is available on line, players may still occasionally find that existing internet gaming software — programmers being human — will have map or ‘Order of Battle’ mistakes that could detract from the playability of the game. In addition, there also seem to be a few modern Luddites remaining in the hobby who, for one reason or another, just don’t care for the ‘point and drag’ method of moving counters on a screen; gamers (like me) who, given their ‘druthers’, still prefer to have the game’s real map and counters spread out in front of them when they sit down to make their moves. Experience has shown me that, for this type of tradition-minded player, switching to a ‘spreadsheet’ format for internet gaming can be a handy, easy-to-use alternative to online, downloadable ‘game boxes’. That being said, the attached play aid is for them. The specific Excel ‘spreadsheet’ attachment offered with this post is for the 2nd Edition version (1974) of the Avalon Hill classic game, STALINGRAD (1963). This multi-page file has been set up to permit competing players to exchange game moves via email attachments and, at the same time, to keep an accurate and detailed, ongoing record of all of the various game operations that could potentially occur in the course of a complete twenty-four turn match. Excel spreadsheet: Stalingrad PBem Play Aid Template A Few Online Gaming SitesSome of my Favorite Online Support Sites
Related Stalingrad Map and Counters Blog Posts:TRICKS OF THE TRADE: ‘MARENGO’ & ‘WAGRAM’ PBeM PLAY AIDS9 commentsMOVEMENT & COMBAT TURN RECORD TEMPLATES FOR THE SPI GAMES, ‘MARENGO’ & ‘WAGRAM’ (1975)There is really nothing like face-to-face competition when it comes to playing wargames. Unfortunately, most players will find — particularly, once they leave college and get on with their lives — that local opponents who share the same gaming interests can often be hard to find, and once found, hard to stay in touch with over the long haul. Circumstances change: gaming clubs break up, opponents move or even, heaven forbid, drop out of the hobby completely. Thus, one of the great benefits to traditional board wargaming conferred by the internet age — speaking as a long-time competitive player — has been the now almost universal ability of present-day players to substitute ‘Play by Electronic Mail’ (PBeM) for its tiresome precursor, traditional ‘Play by Mail’ (PBM). This has meant that most games between geographically separated opponents can now — if both players are conscientious in their move-making — be completed in a matter of months or even weeks, instead of the year or more that postal play used to require.Happily, the ‘internet revolution’ has also led to the appearance of subscription (pay-as-you-go) wargame sites such as Hexwars, and also to the development of easy-to-use gaming software applications such as Vassal, ZunTzu, or Cyberboard which have made ‘electronic’ wargaming even faster (no set-up time) and more convenient. In fact, in the case of Vassal, players who are familiar with a game system no longer even have to have physical access to a copy of a favorite title in order to play it. Of course, reliance on software applications like Vassal or ZunTzu is not always either practical or even preferable. In many cases, players will find that platforms for their preferred games are not yet available online. Moreover, even when one of their favorite titles is available at one of these sites, players will occasionally find that existing internet gaming software — programmers being human — will have map or ‘order of battle’ mistakes that seriously detract from the actual playability of the game. Finally, there are still a few modern ‘Luddites’ like me who just don’t much care for the ‘point and drag’ method of moving counters on a computer screen; gamers who, instead, would actually rather have the real map and counters in front of them when they play. For this type of player, using a ‘spreadsheet’ format for internet gaming is a convenient alternative. And it is also, not surprisingly, the online gaming format that I still tend to prefer. The Excel spreadsheet files offered with this post are for the original versions of the SPI classic games, MARENGO and WAGRAM (1975). These files have been set up to permit competing players to exchange new game moves via email attachments and, at the same time, to keep an accurate and detailed, ongoing record of all of the various game operations that can potentially occur in the course of a complete fourteen turn match of either of these two games. MARENGO Excel spreadsheet link WAGRAM Excel spreadsheet link Additional useful game-related Internet links:Hexwars Vassal ZunTzu Cyberboard created by Dale Larson The Play by Email Emporium, Walt O’Hara Boardgame Players Association World Board Gaming Championships® Consimworld
Subscribe to:
Posts (Atom)
Pageviews last monthTranslateDice Rolling LinksHelpful Wargame Blogs and Links
Tournament LinksAmazonTags
1812
1815
1815 THE WATERLOO CAMPAIGN
1870
1914
1939-45
1940
1942
1944
3W
A HOUSE DIVIDED
A Study in Command
A Time for Trumpets
Aachen
Acre
ACROSS SUEZ
ADVANCED THIRD REICH
advice
AFRIKA KORPS
After Action Reports
AFTER THE HOLOCAUST
AGINCOURT
ALESIA
Allied
Allies
ALMA
alternate strategy
American
American Anniversary
American Army
American Civil War
American Revolutionary War
analysis
anniversary
ANZIO
Arab Israeli War
ARABIAN NIGHTMARE The Kuwait War
ARMADA
Armistice Day
Army of Northern Virginia
articles
ATLANTIC WALL
atlas
ATTACK IN THE ARDENNES
AUSTERLITZ
Australia
Austria
Avalanche
Axis
AXIS and ALLIES: EUROPE
BALACLAVA
Barbarossa
basic resource points
BASTOGNE
BATTLE FOR GERMANY
BATTLE FOR MIDWAY
BATTLE OF BRITAIN
Battle of Nations
BATTLE OF THE BULGE 91
battlegroup
Birthday
board economic game
board political game
board simulation
board simulations
board war game
Boardgame Players Association
boardsimulations
Boer War
bomb disposal
book
BORODINO
BPA
BREAKOUT and PURSUIT
BREAKOUT: NORMANDY
British
BULGE '65
Burma
CAESAR
CAESAR'S LEGIONS
Cambrai
Carnage and Culture
CASE WHITE
CASSINO
CAULDRON
Central Powers
CG
Charles S Roberts
CHINESE FARM
Christmas
Churchill's Generals
CIVILIZATION
classics
COAG
Coalition
COBRA
Cold War
combat results
Command Game Series
comment
components
Computer problems
confederate
ConsimWorld
Continental Congress
convention
counters
Crimea
D-Day
DAGC
Danny S. Parker
DARK DECEMBER
Darwin air raid
David Chandler
Decision Games
Declaration of Independence
description
DESERT STORM UPDATE
design
DG
Don Greenwood
DRESDEN
DRIVE ON STALINGRAD
DUNE
EAST FRONT
Eastern Front
eBay auctions
Eisenborn Ridge
Eisenhower
EL ALAMEIN
EMPIRES AT WAR
EMPIRES IN ARMS
Entente
ERIC GOLDERG'S KURSK
errata
Europa
European
Excel
EYLAU
Fall Gelb
fantasy
Father's Day
Festung Europa
Finland
Finnish
FIRE IN THE EAST
FIREFIGHT
Flag Day
FORTRESS AMERICA
FORTRESS EUROPA
founder
FRANCE 1940
Frank Chadwick
FREDERICK THE GREAT
French
FULDA GAP
game analysis
game design
game system
GDW
General
Ger
German
GETTYSBURG '64
GETTYSBURG '77
GLOBAL WAR
GMT
GOLAN
Great Siege
GRENADIER
grognards
Guadalcanal
guest post
GULF STRIKE
Gulf War
HANNIBAL
HBO
history
holidays
hypothetical
Independence Day
INDIAN OCEAN ADVENTURE
INKERMAN
interpretation
Into the Storm
INVASION SICILY
inventor
Iraqi
Italy
Japanese
Jean Lartéguy
JENA
JENA-AUERSTADT
John Churchill
John Keegan
July 4th
June 14th
kampfgruppen
Karl-Heinz Frieser
KHARKOV
KOREA
Korean War
KORSUN POCKET
KURSK
LA GRANDE ARMEE
LEE MOVES NORTH
LEE vs. MEADE
LEE'S LIEUTENANTS
LEIPZIG
LEIPZIG REVISED
Lille
links
LOST BATTLES
Lost Command
magazine
MAHARAJA
Malta
MANASSAS
Mans' Best Friend
Manstein Plan
map
Map and Counters
MARENGO
Marine Corps Birthday
Marlborough as Military Commander
MBC
Memorial Day
MIDWAY
MISSLE BOAT
MODERN BATTLES
monster game
MonsterGame.Con
Moscow
Mother's Day
movie
MUKDEN
MUSKET and PIKE
NAPOLEON AT LEIPZIG
NAPOLEON AT WATERLOO
NAPOLEON'S LAST CAMPAIGNS
Napoleonic
NAPOLEONS ART OF WAR
NATO
naval
Near Eastern
New Year
Normandy
Normandy Landings
North Africa
North Vietnam
notebook
OBJECTIVE MOSCOW
OMAHA BEACH
Operation Bagration
Operation Cobra
OPERATION CRUSADER
OPERATION TYPHOON
optional rules
OSG
Overlord
Pacific Theater
PANZER ARMEE AFRIKA
PANZER BATTLES
PANZER LEADER
PANZERBLITZ
PANZERGRUPPE GUDERIAN
PANZERKRIEG
PBeM
PBM
Pearl Harbor
Personal Notes
Personal Notes. WWII
play aide
play balance
production
Prussia
PWG
quadrigame
railroad repair rules
Rand Game Associates
reader comments
Recent Break in Blogging
RED SUN RISING
remembrance
review
RGA
RICHTHFEN'S WAR
RIFLE AND SABER
ROAD TO THE RHINE
Robert Cressman
Roman
rules
Russian
RUSSIAN CIVIL WAR
S and T
SAMURAI
SARATOGA: 1777
Saxony
science fiction
SEA LION
SEELOWE
September 11th 2001
Series 120
set-up
Sevastopol
Seven Years War
Sicily
siege
SIEGE OF CONSTANTINOPLE
SINAI
SOLDIER KING
SOLDIERS
SOLOMONS CAMPAIGN
SOUTH AFRICA
South Vietnam
Soviet
SPI
spreadsheet
SQUAD LEADER
ST #49
Stalingrad
Strategy and Tactics
tactical
TAHGC
TANNENBERG
TCHERNAYA RIVER
template
TGI
Thanksgiving
THE AMERICAN REVOLUTION
THE ARDENNES OFFENSIVE
THE ART OF SIEGE
THE BATTLE FOR MOSCOW
THE BATTLE OF LOBOSITZ
THE BATTLE OF MOSCOW
THE BATTLE OF NATIONS
THE BATTLE OF THE BULGE
The Blitzkrieg Legend
The Centurions
THE CIVIL WAR
THE CRIMEAN WAR
The Face of Battle
The Fall of France
THE FALL OF TOBRUK
THE FAST CARRIERS
THE FRANCO-PRUSSIAN WAR
THE GREAT WAR IN THE EAST
THE GUNS OF AUGUST
THE MARNE
The Mask of Command
THE MOSCOW CAMPAIGN
THE NEXT WAR
The Pacific
The Praetorians
THE RUSSIAN CAMPAIGN
THE RUSSO-JAPANESE WAR
THE WAR IN EUROPE MODULE1: THE FIRST WORLD WAR
The War in the West
THE WILDERNESS CAMPAIGN
THE WINTER WAR
THEIR FINEST HOUR
THIRD REICH
TO THE GREEN FIELDS BEYOND
TOBRUK
Toland
Torgau
tournament
Tradition
TSR
turn record chart
TURNING POINT
TURNING POINT STALINGRAD
TYPHOON
Tyre
union
US Constitution
USMC
USN
variant
Velikiye Luki
VERACRUZ
Veterans Day
VG
Victor Davis Hanson
Victory Games
Vietnam
VON MANSTEIN
WACHT AM RHEIN
WAGRAM
WAR AND PEACE
WAR BETWEEN THE STATES
war game
War in Europe
War in the East
WAR IN THE EAST 1ST EDITION
WAR IN THE EAST 2ND EDITION
WAR IN THE WEST
War of the Spanish Succession
Wargame Conventions
wargaming
Wargaming Events and Tournaments
Warsaw Pact
WATERLOO
WBC
WBC Convention
WBC Tournament Results
WBTS
WELLINGTON'S VICTORY
Western Front
WHITE DEATH
WOODEN SHIPS IRON MEN
WORLD WAR 1
WORLD WAR II
WORLD WAR II: European Theater of Operations
WURZBURG
WWI
WWII
YEAR OF THE RAT
Yom Kippur
Zitadelle
ZunTsu
Popular Posts
About Me
My Nephew Joe and Three Marine Buddies
Followers |





