Register now to gain access to all of our features. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more. If you already have an account, login here - otherwise create an account for free today!
[Data Collection] - "Annals of Castle Black"
Posted 22 January 2014 - 01:57 PM
- Tywin likes this
Posted 26 January 2014 - 08:22 PM
Secondly: I'm having some problems with google spreadsheet - because it doesn't support 3D ranges, I seem to have to manually update the master (Metadata) sheet every time a new sheet's data is entered. I attempted to fix this using a script, similar to this one, but the trouble is the script won't automatically update and so has to be manually re-entered every time I want to add a sheet anyway. I've seen some suggestions of a dummy-value (like googleclock() ) to force scripts to update, but I haven't had any luck.
Functionally speaking it's not a big deal. It means that every couple of days I added all the new sheets to 6 formulas, and drag them down the metadata sheet. Still, I'd prefer the process be automated so people can immediately see the fruits of their labour on the meta-data sheet. Anyone have any suggestions to automate this process?
Posted 28 January 2014 - 05:32 PM
Posted 29 January 2014 - 03:25 PM
Edit: And thanks to Fruszu for filling in a ton more data!
Posted 03 February 2014 - 02:29 PM
Posted 03 February 2014 - 03:22 PM
What happens when a new FAQ update takes effect? I hope that pre-FAQ and post-FAQ data can be separated.
Yup. Every entry includes the FAQ dating it (as well as the most recent CP - although I don't use that information (yet) in any automated function). I'll automatically archive all data for prior FAQs, which will still be accessible as historical data, when the new one comes along.
Posted 06 February 2014 - 07:41 PM
Posted 06 February 2014 - 08:05 PM
Posted 07 February 2014 - 09:21 PM
Posted 07 February 2014 - 09:33 PM
You misspelt my name.
The size of the data (thanks to the addition of the complete Stahleck stats (credit to Tomdiidiot)) is large enough to justify including an over-representation ratio for agendas - so they've been added to the metadata sheet.
Posted 09 February 2014 - 10:15 PM
Posted 10 February 2014 - 06:00 AM
- LaurenF likes this
Posted 10 February 2014 - 07:35 PM
Posted 16 February 2014 - 12:22 AM
Hoping to see quite a few additions from this weekend! Chicago, Boston, and Montreal have all promised me updates without me actually hounding them down, and Australia's got a few they're overdue on reporting!
Posted 16 February 2014 - 04:18 PM
Posted 16 February 2014 - 04:29 PM
1 game went to time.
No one went undefeated in swiss.
Top 4 was Martell bloodthirst, Lannister Pbtt, Targ no agenda, Stark HoD.
Posted 16 February 2014 - 08:48 PM
- zoltan likes this
Posted 17 February 2014 - 03:35 AM
As I've got to do a bunch of stuff to get this week's podcast up, I won't be updating the meta-data to include the 5 new submissions until tomorrow.