Difference between revisions of "Module:SportsRankings/data/FIFA World Rankings/doc"

From blackwiki
Jump to navigation Jump to search
blackwiki>Jts1882
(add excel formulae)
 
blackwiki>Jts1882
(update excel code)
Line 4: Line 4:
 
Code for converting in excel:
 
Code for converting in excel:
  
<pre>=CONCAT("          {  '", UPPER(LEFT(B9,3)), "',  ",A9,",  ",E9," },   --", B9) </pre>
+
<pre>=CONCAT("          {  '", B11, "',  ",A11,",  ",E11,", ",LEFT(C11,FIND("(",C11)-1)," }, ")</pre>
 +
 
 
== Usage ==
 
== Usage ==
  

Revision as of 12:41, 4 December 2018

{{Module rating }}

Code for converting in excel:

=CONCAT("          {  '", B11, "',  ",A11,",  ",E11,", ",LEFT(C11,FIND("(",C11)-1)," },  ")

Usage

{{#invoke:SportsRankings/data/FIFA World Rankings|function_name}}