A small contribution to battlefield 2142 community

2006-10-27 04:20:03

#1

sparrowpisuke: Fractalman; +27|6662|Barcelona

NEW VERSION!!!!
this inludes Northern Strike Awards & Unlocks
http://rapidshare.com/files/17719144/St … 6.xls.html (newest version)
and a 'clear' version to write your own stats...
http://rapidshare.com/files/17720142/St … r.xls.html(newest clear version)

http://www.webpersonal.net/sparrowpisuk … 2%20v5.xls (old version)

http://www.webpersonal.net/sparrowpisuk … 2%20v4.xls (obsolete)
http://www.webpersonal.net/sparrowpisuk … 2%20v3.xls (obsolete)
http://www.webpersonal.net/sparrowpisuk … 2%20v2.xls (obsolete)
http://www.webpersonal.net/sparrowpisuk … 2%20v1.xls (obsolete)

I've made these excel files:
It's a file about bf2142 stats, awards, ranks and unlocks. It has my actually stats and awards progress as an example.
My english isn't very good, but i'll try to explain you how it works.
There's seven parts in the file: stats, badges, ribbons, medals, pins, ranks and unlocks.
All the green cells are the input data cells.
In stats part you may input the career and globals points, wins, losses, kills, deaths and the amount of medals and pins you have in the moment you update the file. If you update it every day in a diferent green row, you'll see you progress day by day.
In badges, ribbons, medals, pins, ranks parts you only must update the date that you accomplish it. There's the list of requeriments of all of the awards in the file.
Finally the unlocks part you must update the order of the unlocks, and it will show you the points you need to reach the objective.
Seeing the file is the best way to understand how it works.
Hope it enjoy you.
Maybe there's bugs in the file... ejem... in such case i'll work in the v2 patch...

Some pics...

https://www.webpersonal.net/sparrowpisuke/st_01_r.jpg

https://www.webpersonal.net/sparrowpisuke/st_02_r.jpg

https://www.webpersonal.net/sparrowpisuke/st_03_r.jpg

https://www.webpersonal.net/sparrowpisuke/st_04_r.jpg

https://www.webpersonal.net/sparrowpisuke/st_05_r.jpg

https://www.webpersonal.net/sparrowpisuke/st_06_r.jpg

https://www.webpersonal.net/sparrowpisuke/st_07_r.jpg

Last edited by sparrowpisuke (2007-02-22 06:58:39)

2006-10-27 06:40:17

#2

i_dun_nV_u: Member; +6|6613

that is very neat . good job

2006-10-27 06:42:47

#3

liquidat0r: wtf.; +2,223|6844|UK

Holy hell! How long did that take?

2006-10-27 06:44:19

#4

Towelly: It's A State Of Mind; +399|6807|Your attic

Hmm, Spinach eat your heart out I think.

2006-10-27 06:50:29

#5

Snipedya14: Dont tread on me; +77|6912|Mountains of West Virginia

nice +1

2006-10-27 06:52:05

#6

Simon: basically; +838|6875|UK

DAMN how long did that take ?

VERY nice job btw

2006-10-27 06:54:04

#7

mavrick 3399: EA GAMES PATCH EVERYTHING; +102|6758|Doncaster UK

Just Wow!!! +1

2006-10-27 06:54:41

#8

Samtheman53: Banned; +346|6912|UK

gj

2006-10-27 06:55:22

#9

BlaZin'Feenix: I'm just that good; +156|6836|Cork, Ireland

mavrick 3399 wrote:
Just Wow!!! +1

2006-10-27 06:58:15

#10

sparrowpisuke: Fractalman; +27|6662|Barcelona

how long did that take ?

only a few bored hours of my job time...

2006-10-27 07:00:42

#11

bEAv3D: Member; +24|6911|Fayettenam, NC USA

That's awesome!! +1

2006-10-28 00:16:37

#12

sparrowpisuke: Fractalman; +27|6662|Barcelona

Aother thing i forgot comment is the cells colours in the stats part.
Red means your stats are worse than the last update.
Blue means are better.

2006-10-29 23:14:08

#13

sparrowpisuke: Fractalman; +27|6662|Barcelona

I've found a little 'bug' in the v1 excel file.
There's a column protected and can't be updated. I've fixed it with this new version.

http://www.webpersonal.net/sparrowpisuk … 2%20v2.xls

Enjoy it!

2006-10-29 23:17:39

#14

<BoTM>J_Aero: Qualified Expert; +62|6682|Melbourne - Home of Football

Amazing

+1

2006-10-29 23:22:53

#15

null_o2: Member; +7|6663|Perth, West Australia

sparrowpisuke wrote:
I've found a little 'bug' in the v1 excel file.
There's a column protected and can't be updated. I've fixed it with this new version.

http://www.webpersonal.net/sparrowpisuk … 2%20v2.xls

Enjoy it!

edit that into your first post

its amazing +1 for you good sir.

2006-10-29 23:24:22

#16

Ekfud: Infantry Whore; +42|6893|Kingswood Country

Nice work. +1.

My own dodgy version for BF2 lacked the pics and some of the date tracking. Rather slick.

Ok - just looked at the unlock planning map; that is gold.

Last edited by Ekfud (2006-10-29 23:29:44)

2006-10-29 23:31:41

#17

Chou: Member; +737|7008

Good job there +1

2006-11-09 01:52:09

#18

sparrowpisuke: Fractalman; +27|6662|Barcelona

A new version released... (surely i have more free time than EA's programmers for release patches... )

http://www.webpersonal.net/sparrowpisuk … 2%20v3.xls

Fixes:
- Few badges requeriments.
- An error in time x day formula.
- An error in one daily stats formula.

New:
- Cells with global times of roles (lone wolf, squad leader, squad member, commander)

Note: if you have downloaded the last version, it's easily to update the new one with your soldier numbers. Open the two excel files and copy-paste the green cells (only the green cells).

Enjoy it!

2006-11-09 03:00:20

#19

Blackcats: Member; +17|6795|Germany

Great job sparrowpisuke! +1

2006-11-09 03:23:41

#20

Bernadictus: Moderator; +1,055|6954

Worth a sticky!

2006-11-09 07:37:39

#21

RexRandy: Member; +2|6932

Thats useful, thanks, mate!

2006-11-17 00:16:31

#22

sparrowpisuke: Fractalman; +27|6662|Barcelona

A new version and probably the last one (while EA dosn't change stats requeriments or something contained in excel file)

http://www.webpersonal.net/sparrowpisuk … 2%20v4.xls

New:
- Global time remainings in ribbons requeriments.

2006-11-27 23:42:02

#23

sparrowpisuke: Fractalman; +27|6662|Barcelona

Titan Survival Pin is now active in the new 1.06 patch and i've added it in a new excel file version...

http://www.webpersonal.net/sparrowpisuk … 2%20v5.xls

New:
- Titan survival pin stats.

Note: if you have downloaded the last version, it's easily to update the new one with your soldier numbers. Open the two excel files and copy-paste the green cells (only the green cells).

Enjoy it!

2006-11-29 02:05:13

#24

psH: Banned; +217|6600|Sydney

what are you? crazy? if you wrote that then you have the will of some shaolin monk guy.

2006-11-30 05:58:44

#25

B.Schuss: I'm back, baby... ( sort of ); +664|7058|Cologne, Germany

good lord

+1 for you

BF2S Forums A small contribution to battlefield 2142 community

mavrick 3399 wrote:

sparrowpisuke wrote:

Board footer