User talk:Aurora: Difference between revisions

From escforumwiki
Jump to navigation Jump to search
No edit summary
Line 22: Line 22:


ISC 10. You're welcome! And thanks for fixing the messy unupdated Congratulations page. [[User:Aurora|Aurora]] ([[User talk:Aurora|talk]]) 08:58, 8 February 2015 (CET)
ISC 10. You're welcome! And thanks for fixing the messy unupdated Congratulations page. [[User:Aurora|Aurora]] ([[User talk:Aurora|talk]]) 08:58, 8 February 2015 (CET)
==Easily make an array from Excel==
Hi <br/>
I saw you were doing the array in ISC 32 line by line.
I use another way to do that. I use this link '''[http://excel2wiki.net/index.php http://excel2wiki.net/index.php]''' to make arrays more easily.
For example (with the beginning of the last IJ vote sheet from the Excel file:
* select the cells you want from Excel > copy
* go to the link '''[http://excel2wiki.net/index.php http://excel2wiki.net/index.php]''', paste the cells
Here, I copied the headers from Excel so keep the checkbox format ''header'' checked.<br/>
Be careful too, it always had an extra ''carriage return'' at the end of the pasted text: delete it.
* ''Envoyer'' button (or Send button)
* Here you have a beautiful wiki array like that
{| {{table}}
| align="center" style="background:#f0f0f0;"|'''Country'''
| align="center" style="background:#f0f0f0;"|'''Auspikitan'''
| align="center" style="background:#f0f0f0;"|'''Zeme Kuku'''
| align="center" style="background:#f0f0f0;"|'''Lettuce'''
| align="center" style="background:#f0f0f0;"|'''Sanlyona'''
| align="center" style="background:#f0f0f0;"|'''Gebze'''
| align="center" style="background:#f0f0f0;"|'''Gandhara'''
| align="center" style="background:#f0f0f0;"|'''Xara Khanate'''
| align="center" style="background:#f0f0f0;"|'''Ponásikwa'''
| align="center" style="background:#f0f0f0;"|'''Green Apple'''
| align="center" style="background:#f0f0f0;"|'''Polland'''
| align="center" style="background:#f0f0f0;"|'''Almarania'''
| align="center" style="background:#f0f0f0;"|'''Noxus'''
| align="center" style="background:#f0f0f0;"|'''Points'''
|-
| Sunetti||1||5||||12||||||2||4||1||12||5||10||52
|-
| Tonallán||3||||5||4||||3||||12||10||||||12||49
|-
| Haven||6||||10||10||||||||5||||4||||8||43
|-
| Alteus||12||6||3||||3||||||||||||10||7||41
|}
<pre>
{| {{table}}
| align="center" style="background:#f0f0f0;"|'''Country'''
| align="center" style="background:#f0f0f0;"|'''Auspikitan'''
| align="center" style="background:#f0f0f0;"|'''Zeme Kuku'''
| align="center" style="background:#f0f0f0;"|'''Lettuce'''
| align="center" style="background:#f0f0f0;"|'''Sanlyona'''
| align="center" style="background:#f0f0f0;"|'''Gebze'''
| align="center" style="background:#f0f0f0;"|'''Gandhara'''
| align="center" style="background:#f0f0f0;"|'''Xara Khanate'''
| align="center" style="background:#f0f0f0;"|'''Ponásikwa'''
| align="center" style="background:#f0f0f0;"|'''Green Apple'''
| align="center" style="background:#f0f0f0;"|'''Polland'''
| align="center" style="background:#f0f0f0;"|'''Almarania'''
| align="center" style="background:#f0f0f0;"|'''Noxus'''
| align="center" style="background:#f0f0f0;"|'''Points'''
|-
| Sunetti||1||5||||12||||||2||4||1||12||5||10||52
|-
| Tonallán||3||||5||4||||3||||12||10||||||12||49
|-
| Haven||6||||10||10||||||||5||||4||||8||43
|-
| Alteus||12||6||3||||3||||||||||||10||7||41
|}
</pre>
* Then change what you want in it: add <nowiki>{{isc| }}</nowiki>,<nowiki>{{flagicon| }}</nowiki>, <nowiki>class="sortable wikitable"</nowiki> and change other small things.
to get that:
{| class="sortable wikitable"
| '''Country'''
| {{flagicon|Auspikitan}}
| {{flagicon|Zeme Kuku}}
| {{flagicon|Lettuce}}
| {{flagicon|Sanlyona}}
| {{flagicon|Gebze}}
| {{flagicon|Gandhara}}
| {{flagicon|Xara Khanate}}
| {{flagicon|Ponásikwa}}
| {{flagicon|Green Apple}}
| {{flagicon|Polland}}
| {{flagicon|Almarania}}
| {{flagicon|Noxus}}
| '''Points'''
|-
| Sunetti||1||5||||12||||||2||4||1||12||5||10||52
|-
| Tonallán||3||||5||4||||3||||12||10||||||12||49
|-
| Haven||6||||10||10||||||||5||||4||||8||43
|-
| Alteus||12||6||3||||3||||||||||||10||7||41
|}
<pre>
{| class="sortable wikitable"
| '''Country'''
| {{flagicon|Auspikitan}}
| {{flagicon|Zeme Kuku}}
| {{flagicon|Lettuce}}
| {{flagicon|Sanlyona}}
| {{flagicon|Gebze}}
| {{flagicon|Gandhara}}
| {{flagicon|Xara Khanate}}
| {{flagicon|Ponásikwa}}
| {{flagicon|Green Apple}}
| {{flagicon|Polland}}
| {{flagicon|Almarania}}
| {{flagicon|Noxus}}
| '''Points'''
|-
| Sunetti||1||5||||12||||||2||4||1||12||5||10||52
|-
| Tonallán||3||||5||4||||3||||12||10||||||12||49
|-
| Haven||6||||10||10||||||||5||||4||||8||43
|-
| Alteus||12||6||3||||3||||||||||||10||7||41
|}
</pre>
It is really helpuf for the votes. Easy, no ?
[[User:Bekhman|Bekhman]] [[User talk:Bekhman|(&#x24b7;)]] 00:58, 6 March 2015 (CET).

Revision as of 23:58, 5 March 2015

Good job

You're doing a very, very good work, here on the wiki, I wanted to say you.
Bravo.

Bekhman (Ⓑ) 21:51, 11 March 2014 (CET).

Undo

You can use the undo button when you view the history of a page to revert more easily the last modification, or the undo button when viewing differences between two revisions of a page. It's easier. :->

Bekhman (Ⓑ) 20:24, 15 January 2015 (CET).

I know about the "undo" button, but thanks for telling me anyway. :) Aurora (talk) 20:26, 15 January 2015 (CET)

Congratulations: 25 Editions of the Internatia Song Contest

I'm updating the page for the Congratulations song contest, and I have a question for you: do you know in which ISC contest this song for DPR Jindalea was ? I didn't find it nowhere !

  • Group: Moranbong Band
  • Title: "Without a Break"

Bekhman (Ⓑ) 20:30, 7 February 2015 (CET).

And if you have not win ISC contest when a new Congratulations contest is organized (surely after ISC50), you will have the tikatan vote to that :->

ISC 10. You're welcome! And thanks for fixing the messy unupdated Congratulations page. Aurora (talk) 08:58, 8 February 2015 (CET)

Easily make an array from Excel

Hi
I saw you were doing the array in ISC 32 line by line. I use another way to do that. I use this link http://excel2wiki.net/index.php to make arrays more easily.

For example (with the beginning of the last IJ vote sheet from the Excel file:

Here, I copied the headers from Excel so keep the checkbox format header checked.
Be careful too, it always had an extra carriage return at the end of the pasted text: delete it.

  • Envoyer button (or Send button)
  • Here you have a beautiful wiki array like that
Country Auspikitan Zeme Kuku Lettuce Sanlyona Gebze Gandhara Xara Khanate Ponásikwa Green Apple Polland Almarania Noxus Points
Sunetti 1 5 12 2 4 1 12 5 10 52
Tonallán 3 5 4 3 12 10 12 49
Haven 6 10 10 5 4 8 43
Alteus 12 6 3 3 10 7 41
{| {{table}}
| align="center" style="background:#f0f0f0;"|'''Country'''
| align="center" style="background:#f0f0f0;"|'''Auspikitan'''
| align="center" style="background:#f0f0f0;"|'''Zeme Kuku'''
| align="center" style="background:#f0f0f0;"|'''Lettuce'''
| align="center" style="background:#f0f0f0;"|'''Sanlyona'''
| align="center" style="background:#f0f0f0;"|'''Gebze'''
| align="center" style="background:#f0f0f0;"|'''Gandhara'''
| align="center" style="background:#f0f0f0;"|'''Xara Khanate'''
| align="center" style="background:#f0f0f0;"|'''Ponásikwa'''
| align="center" style="background:#f0f0f0;"|'''Green Apple'''
| align="center" style="background:#f0f0f0;"|'''Polland'''
| align="center" style="background:#f0f0f0;"|'''Almarania'''
| align="center" style="background:#f0f0f0;"|'''Noxus'''
| align="center" style="background:#f0f0f0;"|'''Points'''
|-
| Sunetti||1||5||||12||||||2||4||1||12||5||10||52
|-
| Tonallán||3||||5||4||||3||||12||10||||||12||49
|-
| Haven||6||||10||10||||||||5||||4||||8||43
|-
| Alteus||12||6||3||||3||||||||||||10||7||41
|}
  • Then change what you want in it: add {{isc| }},{{flagicon| }}, class="sortable wikitable" and change other small things.

to get that:

Country Auspikitan Zeme Kūku Lettuce Sanlyona Gebze Gandhara Xara Khanate Ponásikwa Green Apple Polland Almarania Noxus Points
Sunetti 1 5 12 2 4 1 12 5 10 52
Tonallán 3 5 4 3 12 10 12 49
Haven 6 10 10 5 4 8 43
Alteus 12 6 3 3 10 7 41
{| class="sortable wikitable"
| '''Country'''
| {{flagicon|Auspikitan}}
| {{flagicon|Zeme Kuku}}
| {{flagicon|Lettuce}}
| {{flagicon|Sanlyona}}
| {{flagicon|Gebze}}
| {{flagicon|Gandhara}}
| {{flagicon|Xara Khanate}}
| {{flagicon|Ponásikwa}}
| {{flagicon|Green Apple}}
| {{flagicon|Polland}}
| {{flagicon|Almarania}}
| {{flagicon|Noxus}}
| '''Points'''
|-
| Sunetti||1||5||||12||||||2||4||1||12||5||10||52
|-
| Tonallán||3||||5||4||||3||||12||10||||||12||49
|-
| Haven||6||||10||10||||||||5||||4||||8||43
|-
| Alteus||12||6||3||||3||||||||||||10||7||41
|}

It is really helpuf for the votes. Easy, no ?

Bekhman (Ⓑ) 00:58, 6 March 2015 (CET).