d2jsp
Log InRegister
d2jsp Forums > Off-Topic > Sports Coliseum > Hockey > Official Off-topic Off-hockey Thread > Ofc
Prev1254725482549255025515001Next
Closed New Topic New Poll
Member
Posts: 60,940
Joined: Jun 28 2007
Gold: 72,087.29
Mar 5 2015 01:56pm
Quote (KoJ @ Mar 5 2015 02:54pm)
im not sure what you want with this spreadsheet

looks like you have multiple time stamps each day

and then a corresponding set of data in D through J


data output on feb 5. i need that range to increase to feb 25

everything with the same format and the random numbers i gave you in the pm
Member
Posts: 49,220
Joined: Oct 24 2003
Gold: 0.00
Mar 5 2015 01:57pm
can u explain to me what the numbers are/what they are for

may help me wrap my head around it


u got aim or msn?
Member
Posts: 49,220
Joined: Oct 24 2003
Gold: 0.00
Mar 5 2015 01:59pm
so there's 8 days in here, the 5th through the 12th

and you have 8 made up data points

are you saying the first row of data is for the 5th

the second is for the 6th and so on
Member
Posts: 60,940
Joined: Jun 28 2007
Gold: 72,087.29
Mar 5 2015 02:00pm
Quote (KoJ @ Mar 5 2015 02:57pm)
can u explain to me what the numbers are/what they are for

may help me wrap my head around it


u got aim or msn?


i dont

each hour a device reads out data, this data is displayed in those columns

i need each hour from feb 5 at 3:35 to feb 25 at 2:35, with random numbers of data within a certain range. the range i gave you

the first few rows are data are correct, the remaining will be made up. literally

Quote (KoJ @ Mar 5 2015 02:59pm)
so there's 8 days in here, the 5th through the 12th

and you have 8 made up data points

are you saying the first row of data is for the 5th

the second is for the 6th and so on


those are 8 hours for february 5th with each hour there. i need to finish feb 5, then an addition 24 hours for 20 days. another 480 rows essentially.

This post was edited by partank on Mar 5 2015 02:03pm
Member
Posts: 9,663
Joined: Aug 23 2004
Gold: 6,310.00
Mar 5 2015 02:02pm
Quote (KoJ @ Mar 5 2015 02:57pm)
can u explain to me what the numbers are/what they are for

may help me wrap my head around it


u got aim or msn?


there's people with msn still?
Member
Posts: 49,220
Joined: Oct 24 2003
Gold: 0.00
Mar 5 2015 02:04pm
so you just want a formula to create 24, 1 hour periods for each day?

Quote (slickjay @ Mar 5 2015 12:02pm)
there's people with msn still?




yep we use it all the time at work for having instant conversations

we use aim and skype and essentially what ever our customers use

This post was edited by KoJ on Mar 5 2015 02:05pm
Member
Posts: 60,940
Joined: Jun 28 2007
Gold: 72,087.29
Mar 5 2015 02:05pm
Quote (KoJ @ Mar 5 2015 03:04pm)
so you just want a formula to create 24, 1 hour periods for each day?


yes, but it has to be at the 35min 7 second interval

i got the first column now, just took a little longer
Member
Posts: 27,518
Joined: May 10 2009
Gold: 13,891.00
Mar 5 2015 02:05pm
Got an order at work today to deliver to

2339 Kahmehameha hwy

In Honolulu Hawaii

Its even spelled how I always thought it would be! :p

If I lived there I would immediately change my legal name to Goku
Member
Posts: 63,625
Joined: Sep 27 2007
Gold: 103.00
Mar 5 2015 02:07pm
don't forget sunday march 8 2am becomes 3am. time moving forward 1 hour
Member
Posts: 49,220
Joined: Oct 24 2003
Gold: 0.00
Mar 5 2015 02:13pm
Quote (h4bs @ Mar 5 2015 12:07pm)
don't forget sunday march 8 2am becomes 3am. time moving forward 1 hour


hey, dont you tell me what to do
Go Back To Hockey Topic List
Prev1254725482549255025515001Next
Closed New Topic New Poll