NoBS|Public Lounge => Lounge => Topic started by: smitty1258 on February 16, 2008, 11:00:19 PM
Title: who is really really good with excel?
Post by: smitty1258 on February 16, 2008, 11:00:19 PM
anyone?
need something simple made up that will help with cod2 rotations.
Title: Re: who is really really good with excel?
Post by: devvil on February 17, 2008, 09:56:40 AM
hey
I could try do what you want. What yo wanna do with excel? Don
Title: Re: who is really really good with excel?
Post by: Fuzic 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.
Title: Re: who is really really good with excel?
Post by: werth on February 18, 2008, 08:40:48 AM
im not too bad with excel taken some financial accounting and excel courses
Title: Re: who is really really good with excel?
Post by: Fuzic 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?
Title: Re: who is really really good with excel?
Post by: KU@TO 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
Title: Re: who is really really good with excel?
Post by: Athrin on February 19, 2008, 06:02:02 PM
Seems you have enough to help but I do excel too.
Title: Re: who is really really good with excel?
Post by: devvil on February 19, 2008, 06:52:47 PM
In the middle of all this help, Smitty hasn
Title: Re: who is really really good with excel?
Post by: smitty1258 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.
Title: Re: who is really really good with excel?
Post by: smitty1258 on February 22, 2008, 09:35:09 PM
I wanted it to be something like this, but Im not sure is possible.
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
Title: Re: who is really really good with excel?
Post by: KU@TO 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
Title: Re: who is really really good with excel?
Post by: Fuzic on February 23, 2008, 04:16:54 AM
well i cant top that, looks ok.
Title: Re: who is really really good with excel?
Post by: smitty1258 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.
[url]http://www.megaupload.com/?d=G8CSENNH[/url]
Ghey link, because the upload folder is full :P
our upload folder is full?
Title: Re: who is really really good with excel?
Post by: KU@TO 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.
[url]http://www.megaupload.com/?d=G8CSENNH[/url]
Ghey link, because the upload folder is full :P
our upload folder is full?
I got that message yesterday when I tried attaching it.
Title: Re: who is really really good with excel?
Post by: smitty1258 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.
Title: Re: who is really really good with excel?
Post by: KU@TO on February 23, 2008, 05:26:26 PM
I added the dropdowns. You need to add the custom map names to column D on the "Setup" tab for the selections to work.
http://www.megaupload.com/?d=HCRYFYKV
Title: Re: who is really really good with excel?
Post by: smitty1258 on February 23, 2008, 06:25:34 PM
I added the dropdowns. You need to add the custom map names to column D on the "Setup" tab for the selections to work.
[url]http://www.megaupload.com/?d=HCRYFYKV[/url]
you are a fucking sexy bitch!
few last things that might make it super simple for noobs like me.
can you have it highlight every 4th, where a map needs to be filled in, that way we dont miss where it should go?
and can you have it so when you click the drop down it automatically starts at the top of the list? first few times i clicked weapon cfg i couldn't figure out why there was only 2 choices on some, and 3 or 4 on others, till i pressed the up key to scroll up.
also where do i find the setup tab? im on excel 08 also.
Title: Re: who is really really good with excel?
Post by: KU@TO on February 23, 2008, 09:29:23 PM
I made it so it highlights every 4th row in red until you change the custom map name. To go to the setup tab, you just click on the bottom of the page where it says setup. You can type the custom map names starting in cell "D2". (Don't delete D1!) As far as the dropdowns, that how excel handles them. When you click on the down arrow it highlights the current selection in the order it appears on the list. Nothing I can do about that...
here's the updated file:
http://www.megaupload.com/?d=TQPW0DS8
hit me up on xfire if you have any questions.
Title: Re: who is really really good with excel?
Post by: smitty1258 on February 24, 2008, 08:42:51 AM
you so fucking sexy!
Title: Re: who is really really good with excel?
Post by: I-C-E on February 24, 2008, 12:20:32 PM