Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
C TO
 
Posts: n/a
Default Challenging Charting

CREATE TABLE [dbo].[ScheduledTask] (
[WeekNum] [int] NULL ,
[DayNum] [int] NULL ,
[DayName] [char] (30) NULL ,
[PrevCompletedTime] [char] (8) NULL ,
[StartedTime] [char] (8) NULL ,
[PrevCompleted] [char] (30) NULL ,
[Started] [char] (30) NULL ,
[Busy] [char] (30) NULL ,
[Idle] [char] (30) NULL
) ON [PRIMARY]
GO


INSERT INTO [ScheduledTask]
([WeekNum],[DayNum],[DayName],[PrevCompletedTime],[StartedTime],[PrevCompleted],[Started],[Busy],[Idle])VALUES(NULL,1,'Monday','04:58:40','07:00:15','200 4-12-20 04:58:40','2004-12-20 07:00:15','00:00:00','122')
INSERT INTO [ScheduledTask]
([WeekNum],[DayNum],[DayName],[PrevCompletedTime],[StartedTime],[PrevCompleted],[Started],[Busy],[Idle])VALUES(NULL,2,'Tuesday','03:19:56','07:01:10','20 04-12-21 03:19:56','2004-12-21 07:01:10','00:00:00','222')
INSERT INTO [ScheduledTask]
([WeekNum],[DayNum],[DayName],[PrevCompletedTime],[StartedTime],[PrevCompleted],[Started],[Busy],[Idle])VALUES(NULL,2,'Tuesday','07:01:10','23:58:55','20 04-12-21 07:01:10','2004-12-21 23:58:55','00:00:00','1017')
INSERT INTO [ScheduledTask]
([WeekNum],[DayNum],[DayName],[PrevCompletedTime],[StartedTime],[PrevCompleted],[Started],[Busy],[Idle])VALUES(NULL,3,'Wednesday','02:02:27','06:41:57',' 2004-12-22 02:02:27','2004-12-22 06:41:57','00:00:00','279')
INSERT INTO [ScheduledTask]
([WeekNum],[DayNum],[DayName],[PrevCompletedTime],[StartedTime],[PrevCompleted],[Started],[Busy],[Idle])VALUES(NULL,4,'Thursday','06:41:57','06:42:40','2 004-12-22 06:41:57','2004-12-23 06:42:40','00:00:00','1441')
INSERT INTO [ScheduledTask]
([WeekNum],[DayNum],[DayName],[PrevCompletedTime],[StartedTime],[PrevCompleted],[Started],[Busy],[Idle])VALUES(NULL,5,'Friday','02:51:18','06:45:09','200 4-12-24 02:51:18','2004-12-24 06:45:09','00:00:00','234')
INSERT INTO [ScheduledTask]
([WeekNum],[DayNum],[DayName],[PrevCompletedTime],[StartedTime],[PrevCompleted],[Started],[Busy],[Idle])VALUES(NULL,6,'Saturday','06:45:09','00:01:27','2 004-12-24 06:45:09','2004-12-25 00:01:27','00:00:00','1036')
INSERT INTO [ScheduledTask]
([WeekNum],[DayNum],[DayName],[PrevCompletedTime],[StartedTime],[PrevCompleted],[Started],[Busy],[Idle])VALUES(NULL,6,'Saturday','21:19:52','23:07:19','2 004-12-25 21:19:52','2004-12-25 23:07:19','00:00:00','108')
INSERT INTO [ScheduledTask]
([WeekNum],[DayNum],[DayName],[PrevCompletedTime],[StartedTime],[PrevCompleted],[Started],[Busy],[Idle])VALUES(NULL,7,'Sunday','21:19:43','23:07:20','200 4-12-26 21:19:43','2004-12-26 23:07:20','00:00:00','108')
INSERT INTO [ScheduledTask]
([WeekNum],[DayNum],[DayName],[PrevCompletedTime],[StartedTime],[PrevCompleted],[Started],[Busy],[Idle])VALUES(NULL,1,'Monday','08:14:50','09:52:05','200 4-12-27 08:14:50','2004-12-27 09:52:05','00:00:00','98')
INSERT INTO [ScheduledTask]
([WeekNum],[DayNum],[DayName],[PrevCompletedTime],[StartedTime],[PrevCompleted],[Started],[Busy],[Idle])VALUES(NULL,1,'Monday','21:19:43','22:32:26','200 4-12-27 21:19:43','2004-12-27 22:32:26','00:00:00','73')
INSERT INTO [ScheduledTask]
([WeekNum],[DayNum],[DayName],[PrevCompletedTime],[StartedTime],[PrevCompleted],[Started],[Busy],[Idle])VALUES(NULL,2,'Tuesday','08:12:05','09:25:17','20 04-12-28 08:12:05','2004-12-28 09:25:17','00:00:00','73')
INSERT INTO [ScheduledTask]
([WeekNum],[DayNum],[DayName],[PrevCompletedTime],[StartedTime],[PrevCompleted],[Started],[Busy],[Idle])VALUES(NULL,2,'Tuesday','21:30:05','23:07:20','20 04-12-28 21:30:05','2004-12-28 23:07:20','00:00:00','97')
INSERT INTO [ScheduledTask]
([WeekNum],[DayNum],[DayName],[PrevCompletedTime],[StartedTime],[PrevCompleted],[Started],[Busy],[Idle])VALUES(NULL,3,'Wednesday','07:26:00','08:53:22',' 2004-12-29 07:26:00','2004-12-29 08:53:22','00:00:00','87')
INSERT INTO [ScheduledTask]
([WeekNum],[DayNum],[DayName],[PrevCompletedTime],[StartedTime],[PrevCompleted],[Started],[Busy],[Idle])VALUES(NULL,3,'Wednesday','16:59:43','17:36:07',' 2004-12-29 16:59:43','2004-12-29 17:36:07','00:23:51','37')
INSERT INTO [ScheduledTask]
([WeekNum],[DayNum],[DayName],[PrevCompletedTime],[StartedTime],[PrevCompleted],[Started],[Busy],[Idle])VALUES(NULL,3,'Wednesday','16:59:43','17:36:07',' 2004-12-29 16:59:43','2004-12-29 17:36:07','00:41:43','37')
INSERT INTO [ScheduledTask]
([WeekNum],[DayNum],[DayName],[PrevCompletedTime],[StartedTime],[PrevCompleted],[Started],[Busy],[Idle])VALUES(NULL,3,'Wednesday','21:29:01','23:07:20',' 2004-12-29 21:29:01','2004-12-29 23:07:20','00:00:00','98')
INSERT INTO [ScheduledTask]
([WeekNum],[DayNum],[DayName],[PrevCompletedTime],[StartedTime],[PrevCompleted],[Started],[Busy],[Idle])VALUES(NULL,4,'Thursday','11:49:32','13:04:25','2 004-12-30 11:49:32','2004-12-30 13:04:25','00:00:00','75')
INSERT INTO [ScheduledTask]
([WeekNum],[DayNum],[DayName],[PrevCompletedTime],[StartedTime],[PrevCompleted],[Started],[Busy],[Idle])VALUES(NULL,4,'Thursday','15:04:07','17:10:50','2 004-12-30 15:04:07','2004-12-30 17:10:50','11:18:07','126')
INSERT INTO [ScheduledTask]
([WeekNum],[DayNum],[DayName],[PrevCompletedTime],[StartedTime],[PrevCompleted],[Started],[Busy],[Idle])VALUES(NULL,4,'Thursday','21:20:46','22:33:01','2 004-12-30 21:20:46','2004-12-30 22:33:01','00:00:00','73')
INSERT INTO [ScheduledTask]
([WeekNum],[DayNum],[DayName],[PrevCompletedTime],[StartedTime],[PrevCompleted],[Started],[Busy],[Idle])VALUES(NULL,5,'Friday','07:54:00','11:07:03','200 4-12-31 07:54:00','2004-12-31 11:07:03','00:00:00','193')
INSERT INTO [ScheduledTask]
([WeekNum],[DayNum],[DayName],[PrevCompletedTime],[StartedTime],[PrevCompleted],[Started],[Busy],[Idle])VALUES(NULL,5,'Friday','15:21:49','18:05:32','200 4-12-31 15:21:49','2004-12-31 18:05:32','00:00:00','164')
INSERT INTO [ScheduledTask]
([WeekNum],[DayNum],[DayName],[PrevCompletedTime],[StartedTime],[PrevCompleted],[Started],[Busy],[Idle])VALUES(NULL,5,'Friday','21:19:43','23:05:35','200 4-12-31 21:19:43','2004-12-31 23:05:35','00:00:00','106')
INSERT INTO [ScheduledTask]
([WeekNum],[DayNum],[DayName],[PrevCompletedTime],[StartedTime],[PrevCompleted],[Started],[Busy],[Idle])VALUES(NULL,6,'Saturday','07:30:00','10:38:32','2 005-01-01 07:30:00','2005-01-01 10:38:32','00:00:00','188')
INSERT INTO [ScheduledTask]
([WeekNum],[DayNum],[DayName],[PrevCompletedTime],[StartedTime],[PrevCompleted],[Started],[Busy],[Idle])VALUES(NULL,6,'Saturday','15:21:49','18:05:37','2 005-01-01 15:21:49','2005-01-01 18:05:37','00:00:00','164')
INSERT INTO [ScheduledTask]
([WeekNum],[DayNum],[DayName],[PrevCompletedTime],[StartedTime],[PrevCompleted],[Started],[Busy],[Idle])VALUES(NULL,6,'Saturday','21:19:43','22:31:54','2 005-01-01 21:19:43','2005-01-01 22:31:54','00:00:00','72')
INSERT INTO [ScheduledTask]
([WeekNum],[DayNum],[DayName],[PrevCompletedTime],[StartedTime],[PrevCompleted],[Started],[Busy],[Idle])VALUES(NULL,7,'Sunday','10:42:21','11:54:23','200 5-01-02 10:42:21','2005-01-02 11:54:23','00:00:00','72')
INSERT INTO [ScheduledTask]
([WeekNum],[DayNum],[DayName],[PrevCompletedTime],[StartedTime],[PrevCompleted],[Started],[Busy],[Idle])VALUES(NULL,7,'Sunday','15:21:43','18:05:41','200 5-01-02 15:21:43','2005-01-02 18:05:41','00:00:00','164')
INSERT INTO [ScheduledTask]
([WeekNum],[DayNum],[DayName],[PrevCompletedTime],[StartedTime],[PrevCompleted],[Started],[Busy],[Idle])VALUES(NULL,7,'Sunday','21:29:03','23:07:19','200 5-01-02 21:29:03','2005-01-02 23:07:19','00:00:00','98')



Given the DDL above and import it into a csv file, I need to generate a
chart using EXCEL that display the idle window based on the following
specs....


Let's say I have a fiscal year that starts on 12/20 and ends on 12/19 the
next year.

My ultimate goal is trying to display the Idle window of a series of
scheduled tasks on each day of the week, on a Excel Spreadsheet. It may have
the look of the MS Project Schedule Task.

My Challenges a

1. My x-axis may be the DayName (7 values) with only and with minor scale
that contains hour. My y-axis may be grouped by the actual date (14 days),
with the values of the actual prevCompleted and Started (29 series in this
sample). If this is too complicated to accomplish, then my Y-axis may be
group by the 29 series instead of the 14 days. If I must write a query to
iterate my data after 7 days so that the Excel Chart can understand it, how
the query should be written? If that is not neccessary, how?

2. How can I generate weeknum based on the given data?

My ultimate goal of this chart is to identify the idle windows every week.

Many thanks.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Charting Problems Quacknot Charts and Charting in Excel 0 January 12th 05 04:43 PM
CHARTING W/INDIRECT SERIES Ronbo Charts and Charting in Excel 3 January 3rd 05 06:17 PM
Multiple rows of data on a single axis (charting) ramseysgirl Charts and Charting in Excel 8 December 29th 04 07:00 PM
Charting data ranges that change mikelee101 Charts and Charting in Excel 2 December 17th 04 12:07 AM
Charting time? help please... Gustavo Monteverde Charts and Charting in Excel 1 November 28th 04 05:53 AM


All times are GMT +1. The time now is 01:17 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"