Post by pokerjunky on Dec 20, 2012 8:09:10 GMT -5
charts.startradersrpg.com/
as i got deeper into the game again i started messing around with those old motion charts i made. i dropped in the updated spreadsheet i got from here. then i loaded it into an external webpage so i could add a few fields to the page.
i dropped in a simple bitly script so you can now generate a link to any chart configuration you make. in other words, as you play with the four fields that are graphed (x-axis, y-axis, size, and color) you can create a link that saves that chart state by simply clicking the Create Custom Chart Link button. by posting that link here, we can click it and see your chart. making changes to the chart won't ever affect any of the links people post because the link is one unalterable saved state. it also lets you bookmark the charts that are most useful for your playing style. you can see some of my bookmarks across the top.
i added the query field as an easy way to filter the data. well, its easy if you know sql. you can see i trimmed out the outliers such as aliens because they dominate every single chart but they are never the useful data points. you can easily add them back in or restrict it further by making/modifying your own query. every field on the chart can be put into the query (Sails, Engines, Guns, etc) and all the basic standard sql statement work. you can see the documentation here: developers.google.com/chart/interactive/docs/querylanguage#Language_Syntax
even better, the query also gets saved into the bitly url, so you can truly set up and share any chart you want.
i want to plug in planets data as well. all i have to do is change the spreadsheet id. i need to track down the most up-to-date planet data first. i am tempted to add a field for spreadsheet id as well, since i built this as a flexible tool for viewing any google spreadsheet. this would allow other people to plug in their own spreadsheets when i inevitably wander off again.
my goal with this is to basically crowd-source good data analysis. there are a hundred ways to find really useful data points i will never think of. this way the most useful charts will be identified as we collaborate. there are plenty of nuances to strategy i have yet to master, particularly combat, that this could be really helpful to understand. speaking of which: those links across the top reflect my current understanding of what are actually the most important parameters related to those activities. i would love input on whether those are actually the most useful. i'm glad to swap those links out, if someone makes a better Boarding chart for instance.
i picked up this domain last year since i saw it wasn't taken and i didn't want someone to snatch it before cory got to it. i pointed it at his website but we never got around to getting it transferred and set up properly. so i thought, why not use a subdomain?
btw cory, its awesome to see the new data curves in your ship balancing algorithm ;D
as i got deeper into the game again i started messing around with those old motion charts i made. i dropped in the updated spreadsheet i got from here. then i loaded it into an external webpage so i could add a few fields to the page.
i dropped in a simple bitly script so you can now generate a link to any chart configuration you make. in other words, as you play with the four fields that are graphed (x-axis, y-axis, size, and color) you can create a link that saves that chart state by simply clicking the Create Custom Chart Link button. by posting that link here, we can click it and see your chart. making changes to the chart won't ever affect any of the links people post because the link is one unalterable saved state. it also lets you bookmark the charts that are most useful for your playing style. you can see some of my bookmarks across the top.
i added the query field as an easy way to filter the data. well, its easy if you know sql. you can see i trimmed out the outliers such as aliens because they dominate every single chart but they are never the useful data points. you can easily add them back in or restrict it further by making/modifying your own query. every field on the chart can be put into the query (Sails, Engines, Guns, etc) and all the basic standard sql statement work. you can see the documentation here: developers.google.com/chart/interactive/docs/querylanguage#Language_Syntax
even better, the query also gets saved into the bitly url, so you can truly set up and share any chart you want.
i want to plug in planets data as well. all i have to do is change the spreadsheet id. i need to track down the most up-to-date planet data first. i am tempted to add a field for spreadsheet id as well, since i built this as a flexible tool for viewing any google spreadsheet. this would allow other people to plug in their own spreadsheets when i inevitably wander off again.
my goal with this is to basically crowd-source good data analysis. there are a hundred ways to find really useful data points i will never think of. this way the most useful charts will be identified as we collaborate. there are plenty of nuances to strategy i have yet to master, particularly combat, that this could be really helpful to understand. speaking of which: those links across the top reflect my current understanding of what are actually the most important parameters related to those activities. i would love input on whether those are actually the most useful. i'm glad to swap those links out, if someone makes a better Boarding chart for instance.
i picked up this domain last year since i saw it wasn't taken and i didn't want someone to snatch it before cory got to it. i pointed it at his website but we never got around to getting it transferred and set up properly. so i thought, why not use a subdomain?
btw cory, its awesome to see the new data curves in your ship balancing algorithm ;D