Breakthrough
Forum » Forums » Embassy
nkrunic 29th Sep 2015

Joined: 23rd Sep 2015
Rank: Soldier
Posts: 147
Likes 156



Hello Pheonix,

Thanks for hosting me at your site.

I am Niko (in game nkrunic) and I am deputy commander at Breakthrough clan helping the fellows there together with Mark Vii and PapaBear and will be here as Breakthrough's ambassador

Had quite a bit of games with fellows from your clan and enjoyed every single of them, tons of fun no matter win or lose. Also I truly appreciate Amaunet's dedication on holding ICE events and have a personal debt of gratitude to her as thanks to her I realized how many really cool people are around in this game and what means to have a style

Anyhow I am here now and any inquiries or things you wanna know about Breakthrough just shoot it this way.

Cheers
Niko
Like (13) · Comments (6)
Last Edit: 30th Sep 2015 by nkrunic
HiDeathinition 29th Sep 2015

Joined: 25th Jun 2015
Rank: Soldier
Posts: 307
Likes 236



Welcome, buddy. Style, swagger, class is what we are all about. Apart from Niouniaaaaaaa, Jose, Nutty, Dimi, and all the rest of this crazy gang.
Just kidding...
This is a really cool bunch of people and I am sure they will treat you with respect.
Like (6) · Comments (7)



Amaunet85 30th Sep 2015

Joined: 22nd Jun 2015
Rank: Diplomat
Posts: 860
Likes 560



Hey Nico! =D
Welcome to our humble abode
And thanks for the kind words =) Happy to have been of service =D
Like (2) · Comments (13)


Signature Picture
Zel_ 30th Sep 2015

Joined: 1st Jul 2015
Rank: Soldier
Posts: 476
Likes 218



Welcome Niko
Like (2) · Comments (0)
JoseOlas 30th Sep 2015

Joined: 22nd Jun 2015
Rank: Deputy Commander
Posts: 982
Likes 327



Welcome and spammmmm
Like (2) · Comments (7)


Signature Picture

Ma spoon is too big

Amaunet85 5th Oct 2015

Joined: 22nd Jun 2015
Rank: Diplomat
Posts: 860
Likes 560



Hey Breakthrough! Just a reminder: ICE5 is happening this Friday, October 9th, 7pm/19.00 UK-time, 8pm/20.00 CEST. Hope to see you guys there =D
Like (0) · Comments (7)


Signature Picture
back2black 5th Oct 2015

Joined: 22nd Jun 2015
Rank: Commander
Posts: 1063
Likes 738



Welcome btw have fun and feel free to join us on teamspeak
Like (2) · Comments (1)


nkrunic 10th Oct 2015

Joined: 23rd Sep 2015
Rank: Soldier
Posts: 147
Likes 156



Hey Amaunet and rest of Phoenix, thx for hosting ICE 5 it was great and chaotic and great, had tons of fun and guys liked it as well (despite some minor frustrations)
Like (2) · Comments (0)
nkrunic 21st Oct 2015

Joined: 23rd Sep 2015
Rank: Soldier
Posts: 147
Likes 156



Hey all,

As I promised here is the clan stats sheet I made for my fellows, you guys can fully edit it in any way you feel like, and I preloaded it with Pheonix stats.

The sheet is pulling clan stats and members through wargaming WoTb API. It loads up to 50 clan members by just typing in initials and should refresh fairly frequently.

These stats are automatically updated (If by some case it does not refresh you just need to retype clan initials) and should reflect the most recent stats. The structure is as follows:

1) Clan Stats page contains following stats per member: win rate, survival rate, kills/battle, destruction ratio, damage ratio, average damage, average spot, hit rate and draw rate (number of games ended in a draw). This page also contains the white field where you type clan initials to pull data into the sheet. Here you can switch between PHNX and PHNX_

2) Most battles; Highest HR; Most Awards page contains the top members

3) Awards, Battles, WR & HR page contains following stats per member: win rate, battles, hit rate, average damage, top gun medals, Raseiniai medals, Kolboanov medals, Pools medals, Radley Walters medals, Lehvaslaiho Medals, Scout medals, Steel Wall medals, Brothers in Arms medals and Crucial Contribution medals.

Link to google docs:
https://docs.google.com/s ... aPQ/edit?usp=sharing

Web page link:
https://docs.google.com/s ... EOQe0KVbfaPQ/pubhtml

Embed link:
<iframe src="https://docs.google.com/s ... ;></iframe>

Enjoy
Like (3) · Comments (5)
Last Edit: 10th Dec 2015 by nkrunic
Schoullzen 21st Oct 2015

Joined: 22nd Aug 2015
Rank: --
Posts: 115
Likes 38



welcome mate
Like (1) · Comments (1)
nkrunic 21st Oct 2015

Joined: 23rd Sep 2015
Rank: Soldier
Posts: 147
Likes 156



Hey all, the stats sheet is now operational again, my apology for not working properly for a while.

Reason (skip this blah blah if you are not a nerd): I realized it had a problem to automatically update without retyping clan's initials as script couldn't run on trigger event. In my try to resolve the problem I have set the trigger for running the script to pull data too often and it hit a google's limit for a day. Now the issue should be resolved and it should refresh the data once an hour unless you retype the clan's initials.

Some changes: The sheet fields are now locked so you can only type into the white field clan's initials. This was done as I have noticed someone erased the formula pulling the clan id, when this happens the sheet is not functioning as clan id cell pulls all the clan members into the sheet. If you want me to unlock other fields I can do that without any problem, I did it purely to make your life easier. Or you can save it as a copy on your google drive. In a case someone wants to tweak it feel free.

Apologies for maintenance session Hope you find it useful
Like (1) · Comments (1)
nkrunic 2nd Nov 2015

Joined: 23rd Sep 2015
Rank: Soldier
Posts: 147
Likes 156



Hey guys and girls,

Just wanted to say that at Breakthrough we have a backup TS server with 32 slots. It is not big but in the case of emergency you are also welcome to use it.

The server address is 85.82.213.21 port 9987. Currently the password is set to access it, but if you need to use it just message me and I will set a temporary pass so you can have access as well.

The server is meant as a back up and guest server for fellows from breakthrough and it is not much used. I have tested the connection and bandwidth seems pretty decent to pull up to 32 people.
Like (3) · Comments (2)
Last Edit: 2nd Nov 2015 by nkrunic
Zel_ 4th Nov 2015

Joined: 1st Jul 2015
Rank: Soldier
Posts: 476
Likes 218



nkrunic 4th Nov 2015

Joined: 23rd Sep 2015
Rank: Soldier
Posts: 147
Likes 156



It works just the script that is pulling the data from my google docs account reached a limit. If you make a copy of the spredsheet to your google drive and authorize the script it will work again
nkrunic 4th Nov 2015

Joined: 23rd Sep 2015
Rank: Soldier
Posts: 147
Likes 156



This happens as I have 3 sheets with time triggers pulling the data so google docs can hit a limit.
Zel_ 4th Nov 2015

Joined: 1st Jul 2015
Rank: Soldier
Posts: 476
Likes 218



It's working now
Like (1) · Comments (0)
nkrunic 5th Nov 2015

Joined: 23rd Sep 2015
Rank: Soldier
Posts: 147
Likes 156



OK juts a small update on stats sheet as Zel_ had a problem with it yesterday.

Depending on the amount of people accessing it and opening it, the sheet can eventually hit the limit for the day on how many calls it can make. This is a limit set by google itself. What happens in these situations is that it will show no stats whatsoever until the "ban" is lifted, and as I have Breakthrough and your version on my google drive that limit can be easily reached. Don't worry it will still function just you need to wait for a day (sorry can't do anything about that).

What you can do instead to make it work is following (Zel_ you already know this):

Go to File and then make a copy of the spreadsheet to your own google account. Once you have done that you will see Script Center Menu tab, click there and click on Read Data. Once you do that the pop up window saying Authorization Required appears, click continue, next window it will appear will say "ImportJSON would like to: View and manage your spreadsheets in Google Drive & Connect to an external service." Click Allow. (basically by this you will tell script yes it is OK to go and fetch data).

Wolla the sheet is now connected to your own goggle account and you can open it and update data.

You can also set it to update automatically. To do so go to Tools tab click Script Editor. You will see a new window with a code appears. Do not touch the code itself but do the following. You will see a small clock icon right under the publish tab, click on it. The "current project's triggers" window will appear and it will be empty. Click on "Add a new trigger", once you do that a new line with a trigger will appear. Under run field choose onEdit from drop down, under events choose "time-driven" then in the next drop down either choose hour timer or minute timer. If you have chosen minute timer set it on Every 30 minutes (means the spreadsheet will pull the data every 30 minutes and refresh), if you chosen hour timer set it to every hour (means it pulls the data every hour). Like this you ensure the sheet doesn't hit the limit and gets blank.

If you want a sheet to refresh data every time you open it then under triggers again choose onEdit from drop down but then set Events field on "from Spreadsheet" and set the next field on "On open"

Cheers
Niko

Like (2) · Comments (1)
Last Edit: 5th Nov 2015 by nkrunic
nkrunic 10th Dec 2015

Joined: 23rd Sep 2015
Rank: Soldier
Posts: 147
Likes 156



Hey guys due to changes in API after the update the CLAN STATS google spreadsheet was not functional I have now corrected the sheet and made one instance for you, just to reiterate what it does:

The sheet is pulling clan stats and members through wargaming WoTb API. It loads up to 50 clan members by just typing in initials and should refresh fairly frequently.

These stats are automatically updated once an hour (If by some case it does not refresh you just need to retype clan initials) and should reflect the most recent stats. The structure is as follows:

1) Clan Stats page contains following stats per member: win rate, survival rate, kills/battle, destruction ratio, damage ratio, average damage, average spot, hit rate and draw rate (number of games ended in a draw). This page also contains the white field where you type clan initials to pull data into the sheet. Here you can switch between PHNX and PHNX_

2) Most battles; Highest HR; Most Awards page contains the top members

3) Awards, Battles, WR & HR page contains following stats per member: win rate, battles, hit rate, average damage, top gun medals, Raseiniai medals, Kolboanov medals, Pools medals, Radley Walters medals, Lehvaslaiho Medals, Scout medals, Steel Wall medals, Brothers in Arms medals and Crucial Contribution medals.

Link to google docs:
https://docs.google.com/s ... aPQ/edit?usp=sharing

Web page link:
https://docs.google.com/s ... EOQe0KVbfaPQ/pubhtml

Embed link:
<iframe src="https://docs.google.com/s ... ;></iframe>

Depending on the amount of people accessing it and opening it, the sheet can eventually hit the limit for the day on how many calls it can make. This is a limit set by google itself. What happens in these situations is that it will show no stats whatsoever until the "ban" is lifted, and as I have Breakthrough and your version on my google drive that limit can be easily reached. Don't worry it will still function just you need to wait for a day (sorry can't do anything about that).

What you can do instead to make it work is following (Zel_ you already know this):

Go to File and then make a copy of the spreadsheet to your own google account. Once you have done that you will see Script Center Menu tab, click there and click on Read Data. Once you do that the pop up window saying Authorization Required appears, click continue, next window it will appear will say "ImportJSON would like to: View and manage your spreadsheets in Google Drive & Connect to an external service." Click Allow. (basically by this you will tell script yes it is OK to go and fetch data).

Wolla the sheet is now connected to your own goggle account and you can open it and update data.

You can also set it to update automatically. To do so go to Tools tab click Script Editor. You will see a new window with a code appears. Do not touch the code itself but do the following. You will see a small clock icon right under the publish tab, click on it. The "current project's triggers" window will appear and it will be empty. Click on "Add a new trigger", once you do that a new line with a trigger will appear. Under run field choose onEdit from drop down, under events choose "time-driven" then in the next drop down either choose hour timer or minute timer. If you have chosen minute timer set it on Every 30 minutes (means the spreadsheet will pull the data every 30 minutes and refresh), if you chosen hour timer set it to every hour (means it pulls the data every hour). Like this you ensure the sheet doesn't hit the limit and gets blank.

If you want a sheet to refresh data every time you open it then under triggers again choose onEdit from drop down but then set Events field on "from Spreadsheet" and set the next field on "On open"

Cheers and enjoy
Like (1) · Comments (1)
Zel_ 10th Dec 2015

Joined: 1st Jul 2015
Rank: Soldier
Posts: 476
Likes 218



link

working now
Like (1) · Comments (0)
nkrunic 5th Feb 2016

Joined: 23rd Sep 2015
Rank: Soldier
Posts: 147
Likes 156



Hey guys we are experimenting with some youtube channel at breakthrough and I would like to hear a feedback from friends.

Here is the intro video to the channel

www.youtube.com/watch?v=97rb8uDFTn8

Here are the videos currently at the channel (here there will be mostly fun videos and gameplay videos without commentary)

www.youtube.com/channel/UCjNXN ... HDu0FXIAPrGZw/videos

And here is a separate channel from Gaz but it has educational videos/tutorials
www.youtube.com/channel/UClXmV34RHoDIBtqiMAWTENA

Now some things like too long intro on some of the videos gaz posted will be fixed in the future but any feedback is more than welcome
Like (1) · Comments (1)
Last Edit: 5th Feb 2016 by nkrunic
Forum » Forums » Embassy
Please login or register to reply.
Discord
<iframe src="https://discordapp.com/wi ... mp;theme=light" width="920" height="500" allowtransparency="true" frameborder="0"></iframe>
Welcome

Forgot Password?
Top Posters
unkindest
1227 posts

Niounia
1070 posts

back2black
1063 posts

JoseOlas
982 posts

Amaunet85
860 posts

KM_87
812 posts

Johan_Q_Irenicus
520 posts

Zel_
476 posts

Aviator609
371 posts

HiDeathinition
307 posts

Online Members
None
Online Guests: 4
Teamspeak
<div id="ts3viewer_1066751" style="width:; background-color:;"> </div>

<script type="text/javascript" src="http://static.tsviewer.co ... ;></script>

<script type="text/javascript">
<!--
var ts3v_url_1 = "http://www.tsviewer.com/t ... ration_h=none";
ts3v_display.init(ts3v_url_1, 1066751, 100);
-->
</script>
Roster