Cosmic Supremacy Forum » Suggestions » I love graphs! » Hello Guest [Login|Register]
Last Post | First Unread Post Print Page | Recommend to a Friend | Add Thread to Favorites
Pages (2): [1] 2 next » Post New Thread Post Reply
Go to the bottom of this page I love graphs!
Author
Post « Previous Thread | Next Thread »
tmog66 Player-Rank: 1 tmog66 is a male
Serves Soup on Colony Shuttles


Registration Date: 16.04.2010
Posts: 21
Location: Arizona

I love graphs! Reply to this Post Post Reply with Quote Edit/Delete Posts Report Post to a Moderator       Go to the top of this page

I love graphs! statistics not only help me learn about other players and their strategies, but also are just fun.

I don't think I'm the only one here that thinks that the graph we have at the moment for our games is a little lacking.

I want to start a thread with suggestions for more graphs that we can hopefully include with future games. Such graphs may include:

-A more detailed score graph we can zoom in on and make it a line graph instead so it makes more sense.

-graph of your own ship units over time (because you obviously cant be allowed to see other players ship points)

-more graphs should be available after the game, i.e. a line graph of all players ship points over time.

-a line graph of number of or percent of planets owned(also after the game is over)

-a graph of one's own science production during the game, and everyone's science production after the game.

-what else do you guys think might be useful or could be made better about game graphs?
07.04.2012 03:47 tmog66 is offline Send an Email to tmog66 Search for Posts by tmog66 Add tmog66 to your Buddy List
tingling Player-Rank: 3 tingling is a male
Uses citizens as Ablative Armor


Registration Date: 17.11.2010
Posts: 1,727

RE: I love graphs! Reply to this Post Post Reply with Quote Edit/Delete Posts Report Post to a Moderator       Go to the top of this page

This one probably would[U]n't rank very high on Erwin's to do list.. but I think tmog brought up something that the community can maybe contribute to... we can't change game mechanics.. but we probably could help come up with the displays that would be outside of the client.. and we probably only need Erwin to confirm which data from galaxies is easily extracted so we can fiddle with the things displayed.. so far I've only heard Sygor streaming the scores turn by turn to his spreadsheet and graphing that..

__________________
Reminder to self: Patience is a virtue
07.04.2012 11:04 tingling is offline Send an Email to tingling Search for Posts by tingling Add tingling to your Buddy List
Innoble Player-Rank: 3
Puts Shields on Colony Ships


Registration Date: 14.04.2008
Posts: 124

Reply to this Post Post Reply with Quote Edit/Delete Posts Report Post to a Moderator       Go to the top of this page

One thing that would be easy to change is a normalized score graph. The vertical axis on the graphs now represents the current total score. It should simply represent 100% of the points, no matter what the total is. That way it is normalized for each turn. Then you can actually see the history of the game. See whats changing with the score of one player relative to another.

So if someone has half the points throughout the game, his graph would remain steady even though is score is increasing exponentially.

The way it is now, the graph is useless, since only the last bit is readable. Anything before the last 100 turns or so is too small to understand.
07.04.2012 23:54 Innoble is offline Send an Email to Innoble Search for Posts by Innoble Add Innoble to your Buddy List
Radiance Player-Rank: 2 Radiance is a female
Rules with an Iron Pinky


images/avatars/avatar-1053.jpg

Registration Date: 13.05.2011
Posts: 979
Location: USA

Yearning for Innoble's graph Reply to this Post Post Reply with Quote Edit/Delete Posts Report Post to a Moderator       Go to the top of this page

I agree with above posts. Would it REALLY be so hard to switch to line graphs, and either cumulative score or percent score?

I agree with Innoble that percent is better.

I have made some homemade tables for fame purposes, but it is time consuming.
08.04.2012 00:46 Radiance is offline Send an Email to Radiance Search for Posts by Radiance Add Radiance to your Buddy List
mizzihood Player-Rank: 4 mizzihood is a male
Uses citizens as Ablative Armor


images/avatars/avatar-1137.gif

Registration Date: 04.10.2009
Posts: 1,600
Location: Ljubljana, Slovenia

Reply to this Post Post Reply with Quote Edit/Delete Posts Report Post to a Moderator       Go to the top of this page

Hm, I might wget the the socre chart every x hours and parse it with some script. I'll try that, but then I must not turn off the computer.

Then I need a server to upload the pics.

__________________
Cosmic Supremacy charts

This post has been edited 1 time(s), it was last edited by mizzihood: 08.04.2012 16:19.

08.04.2012 16:14 mizzihood is offline Send an Email to mizzihood Homepage of mizzihood Search for Posts by mizzihood Add mizzihood to your Buddy List
tingling Player-Rank: 3 tingling is a male
Uses citizens as Ablative Armor


Registration Date: 17.11.2010
Posts: 1,727

Reply to this Post Post Reply with Quote Edit/Delete Posts Report Post to a Moderator       Go to the top of this page

Sygor did something when he was reporting stuff for GNN in the Rat Pack galaxies. not sure how it does it though.. i presume he'd have to keep his computer on every tick too.. hmm

__________________
Reminder to self: Patience is a virtue
08.04.2012 16:20 tingling is offline Send an Email to tingling Search for Posts by tingling Add tingling to your Buddy List
mizzihood Player-Rank: 4 mizzihood is a male
Uses citizens as Ablative Armor


images/avatars/avatar-1137.gif

Registration Date: 04.10.2009
Posts: 1,600
Location: Ljubljana, Slovenia

Reply to this Post Post Reply with Quote Edit/Delete Posts Report Post to a Moderator       Go to the top of this page

this file gets calls parser in a loop every hour with URL of the score page:
code:
1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
#!/bin/bash
while : ; 
do
	wget $1 -N -q
	name=$(echo "$1" | grep -o "galaxy.*");
	id=$(echo "$name" | grep -o "[0-9]*");
	mv $name $id
	./parse.cs.sh $id
	date
	ncftpput -u *** -p **** -C ftp.brutart.com csscores.tab.$id html/www.brutart.com/csscore.tab.$id
	sleep $2
done


parse.cs.sh that is called from the above code:
code:
1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:
71:
72:
73:
74:
75:
76:
77:
78:
79:
80:
81:
#!/bin/bash

cat $1 | \
grep "table id='list'" | \
sed 's/<\/tr>/<\/tr>\n/g' | \
sed 's/<td[^>]*>/|/g' | \
sed 's/<\/td>//g' | \
sed 's/<a [^>]*>//g' | \
grep -v "table>" | \
sed 's/<\/a[^>]*>//g' | \
sed 's/<tr>//g' | \
sed 's/<\/tr>//g' | \
sed 's/<[^>]*\/>//g' | \
sed 's/%nbsp;//g' | \
grep -v "<b>Playername</b>" | \
cut -d"|" -f 4,6 > .csscores.tmp.$1;
 
declare -a ARRAY
IFS=$'\n' 
while read  LINE;
do
    names[$i]=$(echo -e "$LINE\n" | cut -d "|" -f1);
    score[$i]=$(echo -e "$LINE\n" | cut -d "|" -f2);
    ((i++))
done < .csscores.tmp.$1
max=$(($i-1));

# make a sign file
echo ${names[@]} > .csscores.new.$1
echo ${score[@]} >> .csscores.new.$1

# make old file if it does not exist, so md5sum will not whine
touch .csscores.old.$1;

# get md5sums
md5old=$(md5sum .csscores.old.$1 | cut -d" " -f1);
md5new=$(md5sum .csscores.new.$1 | cut -d" " -f1);

#check if config exists
i=$((0));
if [ -f .csscores.cfg.$1 ]; then
	#if it does jsut read it (I could check tab size if read is needed if i do a loop in this script)
	while read  LINE;
	do
		cfg[$i]=$LINE;
		((i++))
	done < .csscores.cfg.$1
else
		# if it doesn't make it from current names, and copy them to file name
	for i in $(seq 0 $max); do
		printf "%s\n" ${names[$i]} >> .csscores.cfg.$1;
		cfg[$i]=${names[$i]};
	done
fi

# if tab does not exist start it with names from cfg
if [ -f csscores.tab.$1 ]; then
	echo "" > /dev/null
else
	for i in $(seq 0 $max); do
		printf "%s | " ${cfg[$i]} >> csscores.tab.$1;
	done
fi

# if new name / sum file is different than the old one add an entry to the tab
if [ $md5old != $md5new ]; then
	cp .csscores.new.$1 .csscores.old.$1
	printf "\n" >> csscores.tab.$1;
	for i in $(seq 0 $max); do
		j=$((0));
		#find name from cfg entry in the $names 
		while [ ${names[$j]} != ${cfg[$i]} ]; do 
			j=$(($j+1));
		done
		# print corresponding score to tab
		printf "%d |" ${score[$j]} >> csscores.tab.$1;
	done
fi



__________________
Cosmic Supremacy charts

This post has been edited 5 time(s), it was last edited by mizzihood: 11.04.2012 20:18.

08.04.2012 19:59 mizzihood is offline Send an Email to mizzihood Homepage of mizzihood Search for Posts by mizzihood Add mizzihood to your Buddy List
mizzihood Player-Rank: 4 mizzihood is a male
Uses citizens as Ablative Armor


images/avatars/avatar-1137.gif

Registration Date: 04.10.2009
Posts: 1,600
Location: Ljubljana, Slovenia

Reply to this Post Post Reply with Quote Edit/Delete Posts Report Post to a Moderator       Go to the top of this page

Immoral galaxy score history
From turn 89
Slow Research galaxy score history
From turn 297

It will get updated. Challenge still remains for someone to make a chart tool from this table.

__________________
Cosmic Supremacy charts

This post has been edited 2 time(s), it was last edited by mizzihood: 08.04.2012 21:05.

08.04.2012 20:52 mizzihood is offline Send an Email to mizzihood Homepage of mizzihood Search for Posts by mizzihood Add mizzihood to your Buddy List
Sygor Player-Rank: 3
Invades without Troop Ships


images/avatars/avatar-1142.jpg

Registration Date: 22.12.2009
Posts: 251

Reply to this Post Post Reply with Quote Edit/Delete Posts Report Post to a Moderator       Go to the top of this page

When I did it for the Cup, I used a program called Autohotkey and ended up with a text file like this;

030913*Sugar*2749*+0.00
030913*Tabasco*1885*+0.00
030913*Sammy Na'vi jr.*1822*+0.00
030913*Salt*1822*+0.00
030913*Peter Law Borg*1822*+0.00
030913*Vanilla Bean*1822*+0.00
030913*Frank Kilrathi*1822*+0.00
030913*Dean Martian*1822*+0.00
030915*Sugar*4643*+0.00
030915*Sammy Na'vi jr.*4643*+0.00
030915*Salt*4633*+0.00
030915*Dean Martian*4633*+0.00
030915*Tabasco*3769*+0.00
030915*Frank Kilrathi*3716*+0.00
030915*Peter Law Borg*3706*+0.00
030915*Vanilla Bean*2779*+0.00

Not sure if this will work, but here is the complete file on the above game
Rat Pack vs Spice

This post has been edited 1 time(s), it was last edited by Sygor: 08.04.2012 21:47.

08.04.2012 21:36 Sygor is offline Send an Email to Sygor Search for Posts by Sygor Add Sygor to your Buddy List
NickVanran Player-Rank: 2 NickVanran is a male
Hurries Production on Hotdog Stands


images/avatars/avatar-698.jpg

Registration Date: 21.06.2009
Posts: 611
Location: SEMO

Reply to this Post Post Reply with Quote Edit/Delete Posts Report Post to a Moderator       Go to the top of this page

Use the Hotmail or live program skydrive then set up a spreadsheet in the New Excel and have a day person and a night person to collaborate on imputing the scores.

Nick

__________________
Roll Eyes Spend not that, that you hope to make, spend only that, that you have on the things that you Value most. Wink


08.04.2012 23:33 NickVanran is offline Send an Email to NickVanran Search for Posts by NickVanran Add NickVanran to your Buddy List AIM Screen Name of NickVanran: NickVanran YIM Account Name of NickVanran: Startraderus
mizzihood Player-Rank: 4 mizzihood is a male
Uses citizens as Ablative Armor


images/avatars/avatar-1137.gif

Registration Date: 04.10.2009
Posts: 1,600
Location: Ljubljana, Slovenia

Reply to this Post Post Reply with Quote Edit/Delete Posts Report Post to a Moderator       Go to the top of this page

That is exactly what I tried to avoid. I'm still testing the script.... I had a bug. I'll see if it works now.

__________________
Cosmic Supremacy charts
08.04.2012 23:35 mizzihood is offline Send an Email to mizzihood Homepage of mizzihood Search for Posts by mizzihood Add mizzihood to your Buddy List
tmog66 Player-Rank: 1 tmog66 is a male
Serves Soup on Colony Shuttles


Registration Date: 16.04.2010
Posts: 21
Location: Arizona

Thread Starter Thread Started by tmog66
Reply to this Post Post Reply with Quote Edit/Delete Posts Report Post to a Moderator       Go to the top of this page

im sure we can do this without a person in the line. the script can do it all automatically.
09.04.2012 01:07 tmog66 is offline Send an Email to tmog66 Search for Posts by tmog66 Add tmog66 to your Buddy List
Nongolf Player-Rank: 3 Nongolf is a male
Wins even when not in your Galaxy


images/avatars/avatar-1040.gif

Registration Date: 29.09.2007
Posts: 5,815
Location: Denmark

Reply to this Post Post Reply with Quote Edit/Delete Posts Report Post to a Moderator       Go to the top of this page

kick-ass scripting mizzi! Big Grin
09.04.2012 02:11 Nongolf is offline Send an Email to Nongolf Search for Posts by Nongolf Add Nongolf to your Buddy List
mizzihood Player-Rank: 4 mizzihood is a male
Uses citizens as Ablative Armor


images/avatars/avatar-1137.gif

Registration Date: 04.10.2009
Posts: 1,600
Location: Ljubljana, Slovenia

Reply to this Post Post Reply with Quote Edit/Delete Posts Report Post to a Moderator       Go to the top of this page

Smile
galaxy 192
Slow research
Immoral

Immmoral stack chart... I'm not sure if it will update

Actually I'm quite certain it won't, so is there any candidate that would do a chart like this from web data?

__________________
Cosmic Supremacy charts

This post has been edited 5 time(s), it was last edited by mizzihood: 09.04.2012 11:31.

09.04.2012 06:08 mizzihood is offline Send an Email to mizzihood Homepage of mizzihood Search for Posts by mizzihood Add mizzihood to your Buddy List
mizzihood Player-Rank: 4 mizzihood is a male
Uses citizens as Ablative Armor


images/avatars/avatar-1137.gif

Registration Date: 04.10.2009
Posts: 1,600
Location: Ljubljana, Slovenia

Reply to this Post Post Reply with Quote Edit/Delete Posts Report Post to a Moderator       Go to the top of this page

WIN!


the chart has updated. We have live score in any format you want.

Is there any way to persuade google chart to only draw values that are legal. I mean that the x axis is only as long as Y values are legal.

__________________
Cosmic Supremacy charts

This post has been edited 1 time(s), it was last edited by mizzihood: 09.04.2012 14:26.

09.04.2012 13:18 mizzihood is offline Send an Email to mizzihood Homepage of mizzihood Search for Posts by mizzihood Add mizzihood to your Buddy List
mizzihood Player-Rank: 4 mizzihood is a male
Uses citizens as Ablative Armor


images/avatars/avatar-1137.gif

Registration Date: 04.10.2009
Posts: 1,600
Location: Ljubljana, Slovenia

Reply to this Post Post Reply with Quote Edit/Delete Posts Report Post to a Moderator       Go to the top of this page

Well, I obviously have a bug.. I took the thing down.. I'll look in it tonight.
edit: bug is fixed, chart will start to appear soon.

__________________
Cosmic Supremacy charts

This post has been edited 3 time(s), it was last edited by mizzihood: 11.04.2012 20:19.

11.04.2012 13:21 mizzihood is offline Send an Email to mizzihood Homepage of mizzihood Search for Posts by mizzihood Add mizzihood to your Buddy List
mizzihood Player-Rank: 4 mizzihood is a male
Uses citizens as Ablative Armor


images/avatars/avatar-1137.gif

Registration Date: 04.10.2009
Posts: 1,600
Location: Ljubljana, Slovenia

Reply to this Post Post Reply with Quote Edit/Delete Posts Report Post to a Moderator       Go to the top of this page

Charts are back online. Old data was unfortunately lost, because I didn't save the downloaded webpages.

__________________
Cosmic Supremacy charts
12.04.2012 14:59 mizzihood is offline Send an Email to mizzihood Homepage of mizzihood Search for Posts by mizzihood Add mizzihood to your Buddy List
tmog66 Player-Rank: 1 tmog66 is a male
Serves Soup on Colony Shuttles


Registration Date: 16.04.2010
Posts: 21
Location: Arizona

Thread Starter Thread Started by tmog66
Reply to this Post Post Reply with Quote Edit/Delete Posts Report Post to a Moderator       Go to the top of this page

Wow im very impressed! thanks a bunch mizzihood. i think this would be a great addition to the community here. now to persuade Erwin to include a link to this on every game's page.
14.04.2012 01:57 tmog66 is offline Send an Email to tmog66 Search for Posts by tmog66 Add tmog66 to your Buddy List
lefamonster Player-Rank: 1 lefamonster is a male
Serves Soup on Colony Shuttles


images/avatars/avatar-1124.jpg

Registration Date: 17.04.2012
Posts: 14
Location: Colorado

Wow.. Awesome idea Reply to this Post Post Reply with Quote Edit/Delete Posts Report Post to a Moderator       Go to the top of this page

Is there any further development on this? I am a huge fan of graphs, and is one a my favorite things to do in SINS at the end of a good game.

Was looking around the UI today and was wondering if I could get more data..

Need input, More Input Stephanie!
04.05.2012 01:50 lefamonster is offline Send an Email to lefamonster Homepage of lefamonster Search for Posts by lefamonster Add lefamonster to your Buddy List
mizzihood Player-Rank: 4 mizzihood is a male
Uses citizens as Ablative Armor


images/avatars/avatar-1137.gif

Registration Date: 04.10.2009
Posts: 1,600
Location: Ljubljana, Slovenia

Reply to this Post Post Reply with Quote Edit/Delete Posts Report Post to a Moderator       Go to the top of this page

My computer diedSmile I'll check those servers nongolf suggestd

__________________
Cosmic Supremacy charts
04.05.2012 01:56 mizzihood is offline Send an Email to mizzihood Homepage of mizzihood Search for Posts by mizzihood Add mizzihood to your Buddy List
Pages (2): [1] 2 next » Tree Structure | Board Structure
Jump to:
Post New Thread Post Reply
Cosmic Supremacy Forum » Suggestions » I love graphs!

Forum Software: Burning Board 2.3.6, Developed by WoltLab GmbH