| Pages: [1] :: one page |
| Author |
Thread Statistics | Show CCP posts - 5 post(s) |
Highkoo
   |
Posted - 2006.05.17 22:20:00 -
[1]
I have microsoft spreadsheet, i do not have excel.
I am trying to figure the highest percentage of availabiltiy for my members to do mining op's. The problem is i suck at math and do not know how to use ms spreadsheet.
The data i have is of days and times of availibility for my corp members, how then do i input this data to recieve the best possible times for corp ops based on member availiblity?
I am not math savy, so please if you are going to help talk in laymans terms, if possible.
Thanks =)
|
Audrea
|
Posted - 2006.05.17 22:41:00 -
[2]
lol, just take your diary, with a line every hour for each day, 24 lines a day.
Now write down how many members available each hour at a day, each day, 7 days 
Now go over the list, and pick the day and hour with most members online for longest time 
Simple enough? 
You could complicate it a bit - add factor of skills - so those online who mine with osprey, get less factor multiplier than those who mine with retriever, and covetor can even more multiplier. Then u can really pick the best hours.
Good luck 
PS: First 
----------------------------------------------
All my posts are my own opinions and dont not represent any organization until stated otherwise. |
Misty Love
|
Posted - 2006.05.17 22:42:00 -
[3]
how about passing this duty to someone who CAN do the job?
|
Hast
|
Posted - 2006.05.17 22:43:00 -
[4]
it might be the right forum, but I think it would fitt better in Stations, Starbases and Outposts forum since people that post here arent the brightest bulbs
 Originally by: Sarmaul
I WILL FIREBOMB CCP IF MINMATAR GET A T2 BATTLECRUISER WITH A ******* TARGET PAINTING BONUS
|
Highkoo
|
Posted - 2006.05.17 23:06:00 -
[5]
Well thank you for the critisism, but i still am hoping for someone more helpfull.
|
Betonela
|
Posted - 2006.05.17 23:10:00 -
[6]
Originally by: Highkoo
I have microsoft spreadsheet, i do not have excel.
try openoffice
|
Highkoo
|
Posted - 2006.05.17 23:17:00 -
[7]
Originally by: Betonela
Originally by: Highkoo
I have microsoft spreadsheet, i do not have excel.
try openoffice
Ok i will try that thank you.
|
Kinsy
|
Posted - 2006.05.18 00:33:00 -
[8]
The easiest and simplest way to do what you require is to tell them there is a crokite roid in the belt you are in the size of the moon. Its just hidden behind veldspar.
Carrot, stick!
|
Chewan Mesa
|
Posted - 2006.05.18 08:21:00 -
[9]
Ehrm, I know there are people having bloody spreadsheets for everything, but how about you do it the normal way?
Put a poll up or have a corp-meeting asking your members which 2-3 days per week usually suit them best, then do the mining ops on those days?
You dont need a master in corp ops scheduling to hold one...
|
Mochalatte
|
Posted - 2006.05.18 08:54:00 -
[10]
Originally by: Kinsy
The easiest and simplest way to do what you require is to tell them there is a crokite roid in the belt you are in the size of the moon. Its just hidden behind veldspar.
Carrot, stick!
they see right through that.tell them it spawns after all the veld as been mined in a belt.
|
St'oto
|
Posted - 2006.05.18 08:57:00 -
[11]
I will do it for isk lol. :D
|
Highkoo
|
Posted - 2006.05.18 11:20:00 -
[12]
Originally by: Mochalatte
Originally by: Kinsy
The easiest and simplest way to do what you require is to tell them there is a crokite roid in the belt you are in the size of the moon. Its just hidden behind veldspar.
Carrot, stick!
they see right through that.tell them it spawns after all the veld as been mined in a belt.
Yes but i do believe that was also mentioned by Kinsey <-
Very nice and i do apreciate the understanding guys...
Look i am not an ass, i may look and sound like one but i will most definately assure you that i am not.
All i want to know is what i had stated in My Op, anyone with some advise or Instructions on how to do so would be very much apreciated.
Thank you
H.K.
|
Highkoo
|
Posted - 2006.05.18 11:28:00 -
[13]
Originally by: Chewan Mesa
Ehrm, I know there are people having bloody spreadsheets for everything, but how about you do it the normal way?
Put a poll up or have a corp-meeting asking your members which 2-3 days per week usually suit them best, then do the mining ops on those days?
You dont need a master in corp ops scheduling to hold one...
Thank you for the advice Mesa, that should prove very helpfull for now. Yet i intend for there to be many more members, and as our Corp is on the up i think it more apropiate to have a chart that can be adjusted as needid
Thank you
H.K.
|
Grissem
|
Posted - 2006.05.18 11:48:00 -
[14]
You could try something like this. Number of people online
It's an excel document but hopefully should open on microsoft spreadsheet or whatever
Very basic sheet that i've put together in about 5 minutes, hope it helps
Signature too large, please ensure it is 400*120 pixels or less - Udat  |
Highkoo
|
Posted - 2006.05.18 11:57:00 -
[15]
Originally by: Grissem
You could try something like this. Number of people online
It's an excel document but hopefully should open on microsoft spreadsheet or whatever
Very basic sheet that i've put together in about 5 minutes, hope it helps
Grissem:
Thank you, this is very helpfull.
So i imagine all i need to do is imput my data and the proccede to calculate.
Note if i spelled....................................^^^^^^^^ wrong shoot me.
H.K.
|
Highkoo
|
Posted - 2006.05.18 11:58:00 -
[16]
Above post got squeeged oh well.
Thank you for the sheet.
|
Grissem
|
Posted - 2006.05.18 11:59:00 -
[17]
Originally by: Highkoo
Originally by: Grissem
You could try something like this. Number of people online
It's an excel document but hopefully should open on microsoft spreadsheet or whatever
Very basic sheet that i've put together in about 5 minutes, hope it helps
Grissem:
Thank you, this is very helpfull.
So i imagine all i need to do is imput my data and the proccede to calculate.
Note if i spelled....................................^^^^^^^^ wrong shoot me.
H.K.
Yeah that's right mate, put in the figures and the charts will change accordingly. little one for the days, big one for the hours in the day and then you can decide which day and time is best to get your guys together.
---------
Signature too large, please ensure it is 400*120 pixels or less - Udat |
Spacehulk
|
Posted - 2006.05.19 01:08:00 -
[18]
If your corp is really small .. I mean so small that you only have 1-2 people online at one time then forget it, you wont please everyone.
The way I do it events for my corp, and they tend to be major events, is to post about it 2 weeks atleast ahead of time and work up the momentum. Then I specify a time but the event is usualy a whole day or a whole weekend, I did say it was major ... When you post on your forum you will get the feel of when is a good time for people to join when they respond on what convenient for them and even when I do that I usualy run it as a poll.
If I plan an event for the corp it definetly has to be a time I could join since I'm planning and working on it and most members would be able to accomidate that otherwise its a waste of my time and it'll never be as much fun if the coordinator isn't there to get things rolling
Freedom Technologies
|
| |
|
| Pages: [1] :: one page |
| First page | Previous page | Next page | Last page |