Calculate mission point with spreadsheet for Excel.new

by **Lynn** Thu 25 Aug - 15:13

Step 1: Copy the spreadsheet in a textdoc.

Asterix Obelix Rock Rebel Zeus Ormazd Architect Apostate Legendary Shepherd Panoramix Shep Pano Asterix =A2
=somme(a3:a300) =somme(b3:b300) =somme(c3:c300) =somme(d3:d300) =somme(e3:e300) =somme(f3:f300) =somme(g3:g300) =somme(h3:h300) =somme(i3:i300) =somme(j3:j300)*2 =somme(k3:k300)*2 =j2/2 =k2/2 Obelix =B2
14824,37 19179,15 13367,766 32592,8 7084,8 10911,8 12559,4 11999,3 6385 1068,24 3928,2 2136,48 7856,4 Rock =C2
- - - - - - - - - - - Rebel =D2
- - - - - - - - - - - Zeus =E2
- - - - - - - - - - - Ormazd =F2
- - - - - - - - - - - Architect =G2
- - - - - - - - - - - Apostate =H2
- - - - - - - - - - - Panoramix =K2
- - - - - - - - - - - Shepherd =J2
- - - - - - - - - - - Legendary =I2
0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0

Step 2: Replace "somme" by "sum" in english or the other word for the excel language you are using and reorganize the table to see clearly with spaces being careful to not delete the invisible tab.
Step 3: Replace the third row by your current mission points (not multiplied per 2 for panoramix and shepherd yet), you can note your multiplied per 2 shepherd and panoramix in the third row of pano and shep if necessary to have the vision on it on your text doc (use coma for numbers since dots don't work).
Step 4: After playing a game, replace the respective 0 by the mission point you made.
Step 5: Access Excel.new and copy your new spreadsheet there.
Step 6: Copy the second row from excel up to Legendary and replace the third row of your text doc up to the same spot (you can re-organize the spreadsheet by clicking the end of the number and pressing space, do not remove the tabulation, if you do you can restore it with tab, note that the right side of the spreadsheet lacks of organization due to the forum posting , you can re-oranize it this way). Then copy the second row of shep and pano from excel and replace the third row of shepherd and panoramix from your text doc the same way.
Step 7: Clear your mission points by refreshing all the calculated ones by the zero (select with a drag all the rows where you used to change the 0 and delete them, you can then refresh more 0s by selecting with a drag some 0s and adding them).
Step 8: From excel, copy the N and O columns with a drag selection to paste them on your forum profile.