Author Topic: who is really really good with excel?  (Read 3582 times)

smitty1258

  • NoBS|Administrator
  • General

  • Offline
  • *
  • "See, the problem is that God gives men a brain and a penis, and only enough blood to run one at a time."

  • 6071
  • Karma:
    +0/-0
  • Personal Text
    pwning sounds!
    • No Bullshit!
who is really really good with excel?
« on: February 16, 2008, 11:00:19 PM »
anyone?

need something simple made up that will help with cod2 rotations.
A story. A man fires a rifle for many years. and he goes to war. And afterwards he comes home, and he sees that whatever else he may do with his life - build a house, love a woman, change his son's diaper - he will always remain a jarhead. And all the jarheads killing and dying, they will always be me. We are still in the desert.

Quote from: Baim
not even pentium 1 billion will improve YOUR skills :)
Quote from: Evilgenius
* Evilgenius pulls out his cock to compare

devvil

  • Lieutenant

  • Offline
  • *

  • 166
  • Karma:
    +0/-0
Re: who is really really good with excel?
« Reply #1 on: February 17, 2008, 09:56:40 AM »
hey

I could try do what you want. What yo wanna do with excel? Don

Fuzic

  • Corporal

  • Offline
  • *

  • 25
  • Karma:
    +0/-0
Re: who is really really good with excel?
« Reply #2 on: February 18, 2008, 02:31:43 AM »
I can find my way around excel, depends what you really need, I dont do VB code, but the rest yes i can do.

werth

  • NoBS|Member
  • General

  • Offline
  • *

  • 6172
  • Karma:
    +3/-5
  • Personal Text
    fuck WoW!
Re: who is really really good with excel?
« Reply #3 on: February 18, 2008, 08:40:48 AM »
im not too bad with excel taken some financial accounting and excel courses



Fuzic

  • Corporal

  • Offline
  • *

  • 25
  • Karma:
    +0/-0
Re: who is really really good with excel?
« Reply #4 on: February 18, 2008, 09:27:23 AM »
Do you want to have a "total" random map sequence?
You could do this by assighing numbers to maps and gametypes, say between 1-50, then generate a random number between 1-50 (in excel) and play that map and gametype. For instance the randbetween(1,50) function. Install the toolpak first otherwise it wont work.
Is that what your looking for?

KU@TO

  • NoBS|Member
  • Colonel

  • Offline
  • *

  • 574
  • Karma:
    +1/-2
Re: who is really really good with excel?
« Reply #5 on: February 18, 2008, 11:51:49 AM »
i do a lot of excel modeling for my work.  lmk what i can do to help

Athrin

  • Guest
Re: who is really really good with excel?
« Reply #6 on: February 19, 2008, 06:02:02 PM »
Seems you have enough to help but I do excel too.

devvil

  • Lieutenant

  • Offline
  • *

  • 166
  • Karma:
    +0/-0
Re: who is really really good with excel?
« Reply #7 on: February 19, 2008, 06:52:47 PM »
In the middle of all this help, Smitty hasn

smitty1258

  • NoBS|Administrator
  • General

  • Offline
  • *
  • "See, the problem is that God gives men a brain and a penis, and only enough blood to run one at a time."

  • 6071
  • Karma:
    +0/-0
  • Personal Text
    pwning sounds!
    • No Bullshit!
Re: who is really really good with excel?
« Reply #8 on: February 20, 2008, 07:32:59 AM »
sorry guys, ive been distracted trying to recover my data from my crashed 0 array.

Ill post here in a few days once I get back to normal.
A story. A man fires a rifle for many years. and he goes to war. And afterwards he comes home, and he sees that whatever else he may do with his life - build a house, love a woman, change his son's diaper - he will always remain a jarhead. And all the jarheads killing and dying, they will always be me. We are still in the desert.

Quote from: Baim
not even pentium 1 billion will improve YOUR skills :)
Quote from: Evilgenius
* Evilgenius pulls out his cock to compare

smitty1258

  • NoBS|Administrator
  • General

  • Offline
  • *
  • "See, the problem is that God gives men a brain and a penis, and only enough blood to run one at a time."

  • 6071
  • Karma:
    +0/-0
  • Personal Text
    pwning sounds!
    • No Bullshit!
Re: who is really really good with excel?
« Reply #9 on: February 22, 2008, 09:35:09 PM »
I wanted it to be something like this, but Im not sure is possible.

this should be the order of the columns.


set nobs_map1"exec weapons_all.cfg | gametype | SD | map | mp_carentan" |


this column needs to add one to the map # when a new map gets added, so _map2, _map3 etc.

this column needs to have options to choose and HAS TO START with " options would be "exec weapons_all.cfg , "exec weapons_bash.cfg , "exec weapons_rifles_only.cfg , "exec weapons_sniper_pistol_only.cfg , exec weapons_fun.cfg , "exec weapons_shotty_ppsh_only.cfg etc.

this column needs to be the same EVERYTIME

this column needs to have options, sd, tdm, dm , ctf, ctfb, bt, esd, hq,  etc

this column needs to be the same EVERYTIME

this column is the tricky one, if its possible I would want all the stop maps as options, mp_breakout mp_brecourt mp_burgundy mp_carentan mp_dawnville  mp_trainstation mp_farmhouse mp_downtown mp_railyard  mp_leningrad mp_harbor mp_matmata  mp_toujane  mp_decoy   mp_rhine AND ALSO COUNT BRIDGE AS A STOCK MAP

now I would like that last column to auto fill and skip, for instance fill in 4 stock maps at random, and then skip a slot, and start a fill again.

get what i mean?

like :

set nobs_map1 "exec weapons_all.cfg gametype sd map gsm_megiddo_v1"
set nobs_map2 "exec weapons_all.cfg gametype sd map mp_carentan"
set nobs_map3 "exec weapons_all.cfg gametype ctfb map mp_toujane"
set nobs_map4 "exec weapons_all.cfg gametype esd map "
set nobs_map5 "exec weapons_all.cfg gametype lib map mp_powcamp_lib"
set nobs_map6 "exec weapons_bash.cfg gametype dm map 5ronin_aim" //bash only
set nobs_map7 "exec weapons_rifles_only.cfg gametype sd map mp_bridge" //rifles only
set nobs_map8 "exec weapons_all.cfg gametype ctf map "
set nobs_map9 "exec weapons_all.cfg gametype sd map mp_matmata"

then for every 4th map we could put in a custom map. if you notice there is no map every 4th slot
« Last Edit: February 22, 2008, 09:37:17 PM by smitty1258 »
A story. A man fires a rifle for many years. and he goes to war. And afterwards he comes home, and he sees that whatever else he may do with his life - build a house, love a woman, change his son's diaper - he will always remain a jarhead. And all the jarheads killing and dying, they will always be me. We are still in the desert.

Quote from: Baim
not even pentium 1 billion will improve YOUR skills :)
Quote from: Evilgenius
* Evilgenius pulls out his cock to compare

KU@TO

  • NoBS|Member
  • Colonel

  • Offline
  • *

  • 574
  • Karma:
    +1/-2
Re: who is really really good with excel?
« Reply #10 on: February 23, 2008, 03:21:20 AM »
I took a stab at it.  It's not very pretty, but it's a start... I set up the file so you can add an unlimited number of maps and game types.  (Just add them on the "Setup" tab, but make sure you keep the existing format.)  It has a little macro that creates the rotation for you.  Let me know how you want to do the custom maps.

http://www.megaupload.com/?d=G8CSENNH

Ghey link, because the upload folder is full :P
« Last Edit: February 23, 2008, 03:22:59 AM by KU@TO »

Fuzic

  • Corporal

  • Offline
  • *

  • 25
  • Karma:
    +0/-0
Re: who is really really good with excel?
« Reply #11 on: February 23, 2008, 04:16:54 AM »
well i cant top that, looks ok.

smitty1258

  • NoBS|Administrator
  • General

  • Offline
  • *
  • "See, the problem is that God gives men a brain and a penis, and only enough blood to run one at a time."

  • 6071
  • Karma:
    +0/-0
  • Personal Text
    pwning sounds!
    • No Bullshit!
Re: who is really really good with excel?
« Reply #12 on: February 23, 2008, 09:19:00 AM »
I took a stab at it.  It's not very pretty, but it's a start... I set up the file so you can add an unlimited number of maps and game types.  (Just add them on the "Setup" tab, but make sure you keep the existing format.)  It has a little macro that creates the rotation for you.  Let me know how you want to do the custom maps.

http://www.megaupload.com/?d=G8CSENNH

Ghey link, because the upload folder is full :P


our upload folder is full?
A story. A man fires a rifle for many years. and he goes to war. And afterwards he comes home, and he sees that whatever else he may do with his life - build a house, love a woman, change his son's diaper - he will always remain a jarhead. And all the jarheads killing and dying, they will always be me. We are still in the desert.

Quote from: Baim
not even pentium 1 billion will improve YOUR skills :)
Quote from: Evilgenius
* Evilgenius pulls out his cock to compare

KU@TO

  • NoBS|Member
  • Colonel

  • Offline
  • *

  • 574
  • Karma:
    +1/-2
Re: who is really really good with excel?
« Reply #13 on: February 23, 2008, 11:48:51 AM »
I took a stab at it.  It's not very pretty, but it's a start... I set up the file so you can add an unlimited number of maps and game types.  (Just add them on the "Setup" tab, but make sure you keep the existing format.)  It has a little macro that creates the rotation for you.  Let me know how you want to do the custom maps.

http://www.megaupload.com/?d=G8CSENNH

Ghey link, because the upload folder is full :P


our upload folder is full?


I got that message yesterday when I tried attaching it.

smitty1258

  • NoBS|Administrator
  • General

  • Offline
  • *
  • "See, the problem is that God gives men a brain and a penis, and only enough blood to run one at a time."

  • 6071
  • Karma:
    +0/-0
  • Personal Text
    pwning sounds!
    • No Bullshit!
Re: who is really really good with excel?
« Reply #14 on: February 23, 2008, 12:26:56 PM »
ok it looks pretty good, just a few things.

Can you make drop down menus somehow to change the gametype, the exec weapons choices, and stock maps. We dont want to add custom maps except the bridge to stock drop down menu.

now when you generate some maps are fun sd, fun, it would be good to go in and have a drop down to change it, as well as maps, incase they are to close to eachother

we will fill in the custom maps every 4th map manually.
A story. A man fires a rifle for many years. and he goes to war. And afterwards he comes home, and he sees that whatever else he may do with his life - build a house, love a woman, change his son's diaper - he will always remain a jarhead. And all the jarheads killing and dying, they will always be me. We are still in the desert.

Quote from: Baim
not even pentium 1 billion will improve YOUR skills :)
Quote from: Evilgenius
* Evilgenius pulls out his cock to compare