by agentcom on Fri Sep 20, 2013 9:41 am
Yeah, I think Robe's post was just meant to show that data can be pulled, which is also sort of stating the obvious.
What I was picturing (correct me if I'm wrong) is that you'd have a sheet that has the "game information" that will be uploaded to the site. This would be pulled from other spreadsheets, saved as a csv and uploaded. So, the csv would end up looking something like this:
4,agentcom,patrickaa317,robespierre__,greanoaks,S,Classic,A,S,E,C,F,N,20,pw
Basically,
[#players],[player1],[player2],...,[playern],[gametype],[map name or code],[deploy],[turnorder],[spoils],[forts],[fog],[trench],[roundlimit],[password]
Something like that. The gametype and player names are different enough that the player names could be parsed first to ensure there's N players for an N-player game. The map code idea is a good one just requires a separate Vlookup on a table published by CC. All the variables are distinct enough that you can make them unique (I know because I've done this for spreadsheets that I work on and MapRank and the Game Search already do it, too).
Is that the right idea Robes?
If so, the spreadsheets themselves would be fairly easy to design, IMO.