Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Graphing Database Growth Rate
Hello, all -- I have a job that grabs the size of each SQL Server database
and log file size and saves one row per database into a table. I run this routine on a daily basis, so I basically grab the size each day and can monitor growth. The table data is below. What I would like to do is have a SQL Query setup to graph the data in Excel to show the growth rate of each database by week, month, year. I'm not sure the best way to do the SQL and the best way to do the graph. Since new databases are created all the time, new rows will appear in the output -- so creating specific graphs for each database may not be ideal... so I'm hoping someone could help me. Essentially, I want a graph of: By Week -All Databases (DB274, DB332, DB344, etc) showing the start size and the end size within a specified period. By Month - All Databases (DB274, DB332, DB344, etc) showing the start size and the end size within a specified period. By Year - All Databases (DB274, DB332, DB344, etc) showing the start size and the end size within a specified period. I woudl then like to graph each database individually showing its individual growt as: By Week - DB274 By Month - DB274 By Year - DB274 Then again another by Week, Month, Year for each remaining database. I figure I'll need a separate query for the Week, Month, Year for all databases. Then separate queries for the Week, Month, Year for each individual database. How to have this in Excel for graphing is another big question for me. Obviously, as new databases come on... I do not want to have to remember and add/create a new graph. (If this is required, fine... I'm just trying to find a dynamic solution here.) Here is all my data that I've been collecting each data starting 12/17/04 thru 02/01/05. Any help or pointers would be appreciated greatly. ID RECORD_TYPE DBNAME DATA_SIZE DATA_USED LOG_SIZE LOG_USED STAT_DATE ----------- ----------- -------------------------------------------------- ----------- ----------- ----------- ----------- ------------------------------------------------------ 2 1 DB274 15670.00 15517.00 3.49 .40 2005-01-17 13:59:10.477 36 1 DB274 15670.00 15518.00 .99 .62 2005-01-18 08:00:11.637 70 1 DB274 15670.00 15518.00 .99 .57 2005-01-19 08:00:09.123 104 1 DB274 15670.00 15518.00 .99 .70 2005-01-20 08:00:09.873 138 1 DB274 15670.00 15519.00 .99 .60 2005-01-21 08:00:10.237 172 1 DB274 15670.00 15520.00 .99 .57 2005-01-22 08:00:11.680 206 1 DB274 15670.00 15519.00 10.99 .71 2005-01-23 08:00:15.493 240 1 DB274 15670.00 15519.00 5.99 .59 2005-01-24 08:00:10.137 274 1 DB274 15670.00 15520.00 3.49 .79 2005-01-25 08:00:09.380 308 1 DB274 15670.00 15522.00 3.49 .60 2005-01-27 08:00:10.640 342 1 DB274 15670.00 15523.00 3.49 .90 2005-01-28 08:00:11.520 376 1 DB274 15670.00 15524.00 3.49 .59 2005-01-29 08:00:14.120 411 1 DB274 15670.00 15523.00 5.99 .47 2005-01-30 08:00:10.823 446 1 DB274 15670.00 15523.00 5.99 .79 2005-01-31 08:00:09.457 481 1 DB274 15720.00 15692.00 3.49 .53 2005-02-01 08:00:07.140 3 1 DB332 828.00 727.00 .99 .43 2005-01-17 13:59:10.477 37 1 DB332 828.00 728.00 .99 .55 2005-01-18 08:00:11.637 71 1 DB332 828.00 730.00 .99 .68 2005-01-19 08:00:09.123 105 1 DB332 828.00 732.00 .99 .65 2005-01-20 08:00:09.873 139 1 DB332 828.00 733.00 .99 .58 2005-01-21 08:00:10.237 173 1 DB332 828.00 734.00 .99 .59 2005-01-22 08:00:11.680 207 1 DB332 828.00 733.00 3.99 .54 2005-01-23 08:00:15.493 241 1 DB332 828.00 734.00 1.99 .41 2005-01-24 08:00:10.137 275 1 DB332 828.00 736.00 1.99 .62 2005-01-25 08:00:09.380 309 1 DB332 828.00 741.00 1.99 .42 2005-01-27 08:00:10.640 343 1 DB332 828.00 745.00 1.99 .68 2005-01-28 08:00:11.520 377 1 DB332 828.00 754.00 1.99 1.34 2005-01-29 08:00:14.120 412 1 DB332 878.00 746.00 3.99 .54 2005-01-30 08:00:10.823 447 1 DB332 878.00 747.00 2.99 1.10 2005-01-31 08:00:09.457 482 1 DB332 878.00 752.00 1.99 .59 2005-02-01 08:00:07.140 4 1 DB344 27.00 20.00 .99 .52 2005-01-17 13:59:10.477 38 1 DB344 27.00 20.00 .99 .58 2005-01-18 08:00:11.637 72 1 DB344 27.00 21.00 .99 .68 2005-01-19 08:00:09.123 106 1 DB344 27.00 21.00 .99 .65 2005-01-20 08:00:09.873 140 1 DB344 27.00 22.00 .99 .53 2005-01-21 08:00:10.237 174 1 DB344 27.00 22.00 .99 .60 2005-01-22 08:00:11.680 208 1 DB344 27.00 22.00 .99 .66 2005-01-23 08:00:15.493 242 1 DB344 27.00 22.00 .99 .56 2005-01-24 08:00:10.137 276 1 DB344 27.00 23.00 .99 .54 2005-01-25 08:00:09.380 310 1 DB344 27.00 24.00 .99 .58 2005-01-27 08:00:10.640 344 1 DB344 27.00 25.00 .99 .56 2005-01-28 08:00:11.520 378 1 DB344 27.00 26.00 .99 .63 2005-01-29 08:00:14.120 413 1 DB344 77.00 26.00 .99 .61 2005-01-30 08:00:10.823 448 1 DB344 34.00 26.00 .99 .63 2005-01-31 08:00:09.457 483 1 DB344 34.00 32.00 .99 .59 2005-02-01 08:00:07.140 5 1 DB347 1303.00 1127.00 5.99 .47 2005-01-17 13:59:10.477 39 1 DB347 1303.00 1127.00 .99 .55 2005-01-18 08:00:11.637 73 1 DB347 1303.00 1128.00 .99 .69 2005-01-19 08:00:09.123 107 1 DB347 1303.00 1129.00 .99 .63 2005-01-20 08:00:09.873 141 1 DB347 1303.00 1130.00 .99 .67 2005-01-21 08:00:10.237 175 1 DB347 1303.00 1131.00 .99 .66 2005-01-22 08:00:11.680 209 1 DB347 1303.00 1130.00 5.99 .47 2005-01-23 08:00:15.493 243 1 DB347 1303.00 1131.00 5.99 .53 2005-01-24 08:00:10.137 277 1 DB347 1303.00 1132.00 .99 .52 2005-01-25 08:00:09.380 311 1 DB347 1303.00 1134.00 .99 .56 2005-01-27 08:00:10.640 345 1 DB347 1303.00 1135.00 .99 .63 2005-01-28 08:00:11.520 379 1 DB347 1303.00 1136.00 .99 .55 2005-01-29 08:00:14.120 414 1 DB347 1303.00 1135.00 5.99 .47 2005-01-30 08:00:10.823 449 1 DB347 1303.00 1135.00 5.99 .64 2005-01-31 08:00:09.457 484 1 DB347 1303.00 1144.00 .99 .57 2005-02-01 08:00:07.140 6 1 DB358 369.00 312.00 5.99 .47 2005-01-17 13:59:10.477 40 1 DB358 369.00 312.00 .99 .51 2005-01-18 08:00:11.637 74 1 DB358 369.00 313.00 .99 .60 2005-01-19 08:00:09.123 108 1 DB358 369.00 313.00 .99 .68 2005-01-20 08:00:09.873 142 1 DB358 369.00 314.00 .99 .56 2005-01-21 08:00:10.237 176 1 DB358 369.00 314.00 .99 .54 2005-01-22 08:00:11.680 210 1 DB358 369.00 314.00 5.99 .47 2005-01-23 08:00:15.493 244 1 DB358 369.00 314.00 5.99 .66 2005-01-24 08:00:10.137 278 1 DB358 369.00 315.00 3.49 1.47 2005-01-25 08:00:09.380 312 1 DB358 369.00 316.00 3.49 .79 2005-01-27 08:00:10.640 346 1 DB358 369.00 316.00 3.49 1.64 2005-01-28 08:00:11.520 380 1 DB358 369.00 316.00 3.49 1.80 2005-01-29 08:00:14.120 415 1 DB358 369.00 316.00 3.49 1.76 2005-01-30 08:00:10.823 450 1 DB358 369.00 316.00 .99 .65 2005-01-31 08:00:09.457 485 1 DB358 369.00 317.00 .99 .54 2005-02-01 08:00:07.140 7 1 DB377 881.00 777.00 5.99 .47 2005-01-17 13:59:10.477 41 1 DB377 881.00 777.00 .99 .52 2005-01-18 08:00:11.637 75 1 DB377 881.00 778.00 .99 .67 2005-01-19 08:00:09.123 109 1 DB377 881.00 779.00 .99 .50 2005-01-20 08:00:09.873 143 1 DB377 881.00 779.00 .99 .53 2005-01-21 08:00:10.237 177 1 DB377 881.00 780.00 .99 .57 2005-01-22 08:00:11.680 211 1 DB377 881.00 779.00 5.99 .47 2005-01-23 08:00:15.493 245 1 DB377 881.00 779.00 5.99 .68 2005-01-24 08:00:10.137 279 1 DB377 881.00 780.00 3.49 2.66 2005-01-25 08:00:09.380 313 1 DB377 881.00 783.00 .99 .55 2005-01-27 08:00:10.640 347 1 DB377 881.00 784.00 .99 .70 2005-01-28 08:00:11.520 381 1 DB377 881.00 784.00 .99 .54 2005-01-29 08:00:14.120 416 1 DB377 881.00 784.00 5.99 .47 2005-01-30 08:00:10.823 451 1 DB377 881.00 784.00 5.99 .58 2005-01-31 08:00:09.457 486 1 DB377 881.00 785.00 5.99 1.60 2005-02-01 08:00:07.140 8 1 DB424 69.00 17.00 52.99 52.59 2005-01-17 13:59:10.477 42 1 DB424 69.00 17.00 52.99 52.59 2005-01-18 08:00:11.637 76 1 DB424 69.00 17.00 52.99 52.59 2005-01-19 08:00:09.123 110 1 DB424 69.00 17.00 53.99 52.97 2005-01-20 08:00:09.873 144 1 DB424 69.00 17.00 53.99 52.97 2005-01-21 08:00:10.237 178 1 DB424 69.00 17.00 53.99 52.99 2005-01-22 08:00:11.680 212 1 DB424 69.00 18.00 57.99 57.71 2005-01-23 08:00:15.493 246 1 DB424 69.00 18.00 57.99 57.71 2005-01-24 08:00:10.137 280 1 DB424 69.00 18.00 57.99 57.71 2005-01-25 08:00:09.380 314 1 DB424 69.00 18.00 57.99 57.73 2005-01-27 08:00:10.640 348 1 DB424 69.00 18.00 57.99 57.75 2005-01-28 08:00:11.520 382 1 DB424 69.00 18.00 57.99 57.73 2005-01-29 08:00:14.120 417 1 DB424 69.00 18.00 62.99 62.65 2005-01-30 08:00:10.823 452 1 DB424 69.00 18.00 62.99 62.65 2005-01-31 08:00:09.457 487 1 DB424 69.00 18.00 62.99 62.66 2005-02-01 08:00:07.140 9 1 DB489 55.00 17.00 40.99 40.76 2005-01-17 13:59:10.477 43 1 DB489 55.00 17.00 40.99 40.76 2005-01-18 08:00:11.637 77 1 DB489 55.00 17.00 40.99 40.76 2005-01-19 08:00:09.123 111 1 DB489 55.00 17.00 41.99 41.16 2005-01-20 08:00:09.873 145 1 DB489 55.00 17.00 41.99 41.16 2005-01-21 08:00:10.237 179 1 DB489 55.00 17.00 41.99 41.18 2005-01-22 08:00:11.680 213 1 DB489 55.00 17.00 45.99 45.78 2005-01-23 08:00:15.493 247 1 DB489 55.00 17.00 45.99 45.78 2005-01-24 08:00:10.137 281 1 DB489 55.00 17.00 45.99 45.78 2005-01-25 08:00:09.380 315 1 DB489 55.00 17.00 45.99 45.80 2005-01-27 08:00:10.640 349 1 DB489 55.00 18.00 49.99 49.39 2005-01-28 08:00:11.520 383 1 DB489 55.00 18.00 49.99 49.39 2005-01-29 08:00:14.120 418 1 DB489 55.00 18.00 54.99 54.72 2005-01-30 08:00:10.823 453 1 DB489 55.00 18.00 54.99 54.72 2005-01-31 08:00:09.457 488 1 DB489 55.00 18.00 54.99 54.72 2005-02-01 08:00:07.140 384 1 DB530 17.00 12.00 .99 .34 2005-01-29 08:00:14.120 419 1 DB530 17.00 13.00 .99 .61 2005-01-30 08:00:10.823 454 1 DB530 17.00 13.00 .99 .61 2005-01-31 08:00:09.457 489 1 DB530 24.00 18.00 .99 .54 2005-02-01 08:00:07.140 10 1 DB533 500.00 451.00 24.88 10.98 2005-01-17 13:59:10.477 44 1 DB533 500.00 451.00 24.88 10.98 2005-01-18 08:00:11.637 78 1 DB533 500.00 452.00 24.88 3.13 2005-01-19 08:00:09.123 112 1 DB533 500.00 453.00 24.88 6.46 2005-01-20 08:00:09.873 146 1 DB533 500.00 454.00 24.88 10.04 2005-01-21 08:00:10.237 180 1 DB533 500.00 454.00 24.88 .58 2005-01-22 08:00:11.680 214 1 DB533 500.00 454.00 24.88 4.47 2005-01-23 08:00:15.493 248 1 DB533 500.00 454.00 24.88 4.74 2005-01-24 08:00:10.137 282 1 DB533 500.00 454.00 24.88 7.99 2005-01-25 08:00:09.380 316 1 DB533 500.00 456.00 24.88 15.13 2005-01-27 08:00:10.640 350 1 DB533 500.00 457.00 24.88 5.86 2005-01-28 08:00:11.520 385 1 DB533 500.00 457.00 24.88 9.01 2005-01-29 08:00:14.120 420 1 DB533 500.00 457.00 24.88 12.74 2005-01-30 08:00:10.823 455 1 DB533 500.00 457.00 24.88 13.14 2005-01-31 08:00:09.457 490 1 DB533 500.00 462.00 24.88 7.11 2005-02-01 08:00:07.140 11 1 DB562 95.00 78.00 .99 .51 2005-01-17 13:59:10.477 45 1 DB562 95.00 78.00 .99 .51 2005-01-18 08:00:11.637 79 1 DB562 95.00 78.00 .99 .59 2005-01-19 08:00:09.123 113 1 DB562 95.00 78.00 .99 .50 2005-01-20 08:00:09.873 147 1 DB562 95.00 79.00 .99 .61 2005-01-21 08:00:10.237 181 1 DB562 95.00 79.00 .99 .55 2005-01-22 08:00:11.680 215 1 DB562 95.00 79.00 .99 .53 2005-01-23 08:00:15.493 249 1 DB562 95.00 79.00 .99 .56 2005-01-24 08:00:10.137 283 1 DB562 95.00 79.00 .99 .51 2005-01-25 08:00:09.380 317 1 DB562 95.00 80.00 .99 .62 2005-01-27 08:00:10.640 351 1 DB562 95.00 80.00 .99 .58 2005-01-28 08:00:11.520 386 1 DB562 95.00 81.00 .99 .64 2005-01-29 08:00:14.120 421 1 DB562 95.00 81.00 .99 .54 2005-01-30 08:00:10.823 456 1 DB562 95.00 81.00 .99 .64 2005-01-31 08:00:09.457 491 1 DB562 95.00 84.00 .99 .51 2005-02-01 08:00:07.140 12 1 DB586 150.00 132.00 .99 .60 2005-01-17 13:59:10.477 46 1 DB586 150.00 132.00 .99 .60 2005-01-18 08:00:11.637 80 1 DB586 150.00 132.00 .99 .67 2005-01-19 08:00:09.123 114 1 DB586 150.00 132.00 .99 .55 2005-01-20 08:00:09.873 148 1 DB586 150.00 133.00 .99 .54 2005-01-21 08:00:10.237 182 1 DB586 150.00 133.00 .99 .59 2005-01-22 08:00:11.680 216 1 DB586 154.00 133.00 .99 .65 2005-01-23 08:00:15.493 250 1 DB586 154.00 133.00 .99 .53 2005-01-24 08:00:10.137 284 1 DB586 154.00 133.00 .99 .55 2005-01-25 08:00:09.380 318 1 DB586 154.00 134.00 .99 .56 2005-01-27 08:00:10.640 352 1 DB586 154.00 134.00 .99 .55 2005-01-28 08:00:11.520 387 1 DB586 154.00 135.00 .99 .56 2005-01-29 08:00:14.120 422 1 DB586 155.00 135.00 .99 .61 2005-01-30 08:00:10.823 457 1 DB586 155.00 135.00 .99 .58 2005-01-31 08:00:09.457 492 1 DB586 155.00 135.00 .99 .66 2005-02-01 08:00:07.140 13 1 DB587 229.00 197.00 .99 .56 2005-01-17 13:59:10.477 47 1 DB587 229.00 197.00 .99 .56 2005-01-18 08:00:11.637 81 1 DB587 229.00 198.00 .99 .69 2005-01-19 08:00:09.123 115 1 DB587 229.00 199.00 .99 .70 2005-01-20 08:00:09.873 149 1 DB587 229.00 200.00 .99 .57 2005-01-21 08:00:10.237 183 1 DB587 229.00 200.00 .99 .59 2005-01-22 08:00:11.680 217 1 DB587 229.00 200.00 .99 .59 2005-01-23 08:00:15.493 251 1 DB587 229.00 200.00 .99 .70 2005-01-24 08:00:10.137 285 1 DB587 229.00 201.00 .99 .67 2005-01-25 08:00:09.380 319 1 DB587 229.00 203.00 .99 .64 2005-01-27 08:00:10.640 353 1 DB587 229.00 203.00 .99 .69 2005-01-28 08:00:11.520 388 1 DB587 229.00 203.00 .99 .66 2005-01-29 08:00:14.120 423 1 DB587 229.00 203.00 .99 .58 2005-01-30 08:00:10.823 458 1 DB587 229.00 203.00 .99 .58 2005-01-31 08:00:09.457 493 1 DB587 229.00 207.00 .99 .64 2005-02-01 08:00:07.140 14 1 DB611 841.00 724.00 5.99 .47 2005-01-17 13:59:10.477 48 1 DB611 841.00 724.00 5.99 .48 2005-01-18 08:00:11.637 82 1 DB611 841.00 725.00 .99 .56 2005-01-19 08:00:09.123 116 1 DB611 841.00 726.00 .99 .56 2005-01-20 08:00:09.873 150 1 DB611 841.00 726.00 .99 .62 2005-01-21 08:00:10.237 184 1 DB611 841.00 726.00 .99 .69 2005-01-22 08:00:11.680 218 1 DB611 841.00 726.00 10.99 1.37 2005-01-23 08:00:15.493 252 1 DB611 841.00 726.00 5.99 .68 2005-01-24 08:00:10.137 286 1 DB611 841.00 727.00 5.99 .68 2005-01-25 08:00:09.380 320 1 DB611 841.00 728.00 .99 .52 2005-01-27 08:00:10.640 354 1 DB611 841.00 729.00 .99 .64 2005-01-28 08:00:11.520 389 1 DB611 841.00 729.00 .99 .56 2005-01-29 08:00:14.120 424 1 DB611 841.00 729.00 5.99 .47 2005-01-30 08:00:10.823 459 1 DB611 841.00 729.00 5.99 .47 2005-01-31 08:00:09.457 494 1 DB611 841.00 743.00 .99 .61 2005-02-01 08:00:07.140 15 1 DB634 47000.00 46820.00 13.49 .40 2005-01-17 13:59:10.477 49 1 DB634 47000.00 46820.00 .99 .34 2005-01-18 08:00:11.637 83 1 DB634 47000.00 46820.00 .99 .51 2005-01-19 08:00:09.123 117 1 DB634 47000.00 46821.00 .99 .52 2005-01-20 08:00:09.873 151 1 DB634 47000.00 46821.00 .99 .54 2005-01-21 08:00:10.237 185 1 DB634 47000.00 46821.00 .99 .51 2005-01-22 08:00:11.680 219 1 DB634 47000.00 46821.00 50.99 6.71 2005-01-23 08:00:15.493 253 1 DB634 47000.00 46821.00 13.49 .53 2005-01-24 08:00:10.137 287 1 DB634 47000.00 46821.00 .99 .56 2005-01-25 08:00:09.380 321 1 DB634 47000.00 46823.00 .99 .58 2005-01-27 08:00:10.640 355 1 DB634 47000.00 46824.00 .99 .51 2005-01-28 08:00:11.520 390 1 DB634 47000.00 46826.00 .99 .54 2005-01-29 08:00:14.120 425 1 DB634 47000.00 46823.00 50.99 6.18 2005-01-30 08:00:10.823 460 1 DB634 47000.00 46823.00 25.99 .47 2005-01-31 08:00:09.457 495 1 DB634 47000.00 46895.00 13.49 3.34 2005-02-01 08:00:07.140 16 1 DB683 1385.00 1220.00 3.49 .59 2005-01-17 13:59:10.477 50 1 DB683 1385.00 1221.00 3.49 .66 2005-01-18 08:00:11.637 84 1 DB683 1385.00 1222.00 3.49 1.95 2005-01-19 08:00:09.123 118 1 DB683 1385.00 1224.00 3.49 2.87 2005-01-20 08:00:09.873 152 1 DB683 1385.00 1225.00 3.49 .45 2005-01-21 08:00:10.237 186 1 DB683 1385.00 1231.00 3.49 1.78 2005-01-22 08:00:11.680 220 1 DB683 1385.00 1230.00 5.99 .52 2005-01-23 08:00:15.493 254 1 DB683 1385.00 1230.00 5.99 1.57 2005-01-24 08:00:10.137 288 1 DB683 1385.00 1231.00 3.49 .62 2005-01-25 08:00:09.380 322 1 DB683 1385.00 1235.00 3.49 .58 2005-01-27 08:00:10.640 356 1 DB683 1385.00 1237.00 3.49 2.03 2005-01-28 08:00:11.520 391 1 DB683 1385.00 1239.00 3.49 1.50 2005-01-29 08:00:14.120 426 1 DB683 1435.00 1238.00 13.49 1.34 2005-01-30 08:00:10.823 461 1 DB683 1435.00 1238.00 5.99 .48 2005-01-31 08:00:09.457 496 1 DB683 1435.00 1247.00 3.49 .61 2005-02-01 08:00:07.140 17 1 DB770 13000.00 12845.00 5.99 .47 2005-01-17 13:59:10.477 51 1 DB770 13000.00 12845.00 .99 .34 2005-01-18 08:00:11.637 85 1 DB770 13000.00 12845.00 .99 .35 2005-01-19 08:00:09.123 119 1 DB770 13000.00 12845.00 .99 .35 2005-01-20 08:00:09.873 153 1 DB770 13000.00 12845.00 .99 .35 2005-01-21 08:00:10.237 187 1 DB770 13000.00 12845.00 .99 .35 2005-01-22 08:00:11.680 221 1 DB770 13000.00 12845.00 10.99 .88 2005-01-23 08:00:15.493 255 1 DB770 13000.00 12845.00 5.99 .51 2005-01-24 08:00:10.137 289 1 DB770 13000.00 12845.00 .99 .34 2005-01-25 08:00:09.380 323 1 DB770 13000.00 12845.00 .99 .34 2005-01-27 08:00:10.640 357 1 DB770 13000.00 12845.00 .99 .49 2005-01-28 08:00:11.520 392 1 DB770 13000.00 12845.00 .99 .49 2005-01-29 08:00:14.120 427 1 DB770 13000.00 12845.00 5.99 .47 2005-01-30 08:00:10.823 462 1 DB770 13000.00 12845.00 5.99 .47 2005-01-31 08:00:09.457 497 1 DB770 13000.00 12845.00 .99 .34 2005-02-01 08:00:07.140 18 1 DB776 1425.00 1274.00 .99 .41 2005-01-17 13:59:10.477 52 1 DB776 1425.00 1274.00 .99 .64 2005-01-18 08:00:11.637 86 1 DB776 1425.00 1276.00 .99 .51 2005-01-19 08:00:09.123 120 1 DB776 1425.00 1278.00 .99 .53 2005-01-20 08:00:09.873 154 1 DB776 1425.00 1279.00 .99 .53 2005-01-21 08:00:10.237 188 1 DB776 1425.00 1282.00 .99 .55 2005-01-22 08:00:11.680 222 1 DB776 1425.00 1280.00 5.99 .51 2005-01-23 08:00:15.493 256 1 DB776 1425.00 1280.00 .99 .35 2005-01-24 08:00:10.137 290 1 DB776 1425.00 1282.00 .99 .68 2005-01-25 08:00:09.380 324 1 DB776 1425.00 1292.00 .99 .55 2005-01-27 08:00:10.640 358 1 DB776 1425.00 1300.00 .99 .54 2005-01-28 08:00:11.520 393 1 DB776 1425.00 1303.00 .99 .56 2005-01-29 08:00:14.120 428 1 DB776 1475.00 1293.00 5.99 .47 2005-01-30 08:00:10.823 463 1 DB776 1475.00 1293.00 5.99 .65 2005-01-31 08:00:09.457 498 1 DB776 1475.00 1310.00 3.49 .66 2005-02-01 08:00:07.140 19 1 DB778 1051.00 926.00 1.48 .63 2005-01-17 13:59:10.477 53 1 DB778 1051.00 926.00 .99 .42 2005-01-18 08:00:11.637 87 1 DB778 1051.00 929.00 .99 .54 2005-01-19 08:00:09.123 121 1 DB778 1051.00 932.00 .99 .66 2005-01-20 08:00:09.873 155 1 DB778 1051.00 936.00 .99 .54 2005-01-21 08:00:10.237 189 1 DB778 1051.00 940.00 .99 .66 2005-01-22 08:00:11.680 223 1 DB778 1051.00 937.00 2.99 .88 2005-01-23 08:00:15.493 257 1 DB778 1051.00 938.00 1.48 .55 2005-01-24 08:00:10.137 291 1 DB778 1051.00 947.00 .99 .60 2005-01-25 08:00:09.380 325 1 DB778 1051.00 965.00 .99 .56 2005-01-27 08:00:10.640 359 1 DB778 1051.00 994.00 .99 .69 2005-01-28 08:00:11.520 394 1 DB778 1051.00 1011.00 .99 .61 2005-01-29 08:00:14.120 429 1 DB778 1101.00 974.00 2.99 1.03 2005-01-30 08:00:10.823 464 1 DB778 1101.00 982.00 1.48 .50 2005-01-31 08:00:09.457 499 1 DB778 1101.00 1053.00 1.23 .62 2005-02-01 08:00:07.140 20 1 DB779 4366.00 4111.00 .99 .38 2005-01-17 13:59:10.477 54 1 DB779 4366.00 4111.00 .99 .38 2005-01-18 08:00:11.637 88 1 DB779 4366.00 4113.00 .99 .53 2005-01-19 08:00:09.123 122 1 DB779 4366.00 4114.00 .99 .55 2005-01-20 08:00:09.873 156 1 DB779 4366.00 4117.00 .99 .60 2005-01-21 08:00:10.237 190 1 DB779 4366.00 4118.00 .99 .60 2005-01-22 08:00:11.680 224 1 DB779 4366.00 4117.00 6.99 1.99 2005-01-23 08:00:15.493 258 1 DB779 4366.00 4117.00 2.99 .87 2005-01-24 08:00:10.137 292 1 DB779 4366.00 4118.00 1.99 .76 2005-01-25 08:00:09.380 326 1 DB779 4366.00 4136.00 .99 .53 2005-01-27 08:00:10.640 360 1 DB779 4366.00 4147.00 .99 .67 2005-01-28 08:00:11.520 395 1 DB779 4366.00 4170.00 .99 .56 2005-01-29 08:00:14.120 430 1 DB779 4416.00 4140.00 7.99 2.29 2005-01-30 08:00:10.823 465 1 DB779 4416.00 4140.00 .99 .34 2005-01-31 08:00:09.457 500 1 DB779 5916.00 5883.00 .99 .58 2005-02-01 08:00:07.140 21 1 DB780 744.00 631.00 5.99 .47 2005-01-17 13:59:10.477 55 1 DB780 744.00 631.00 .99 .34 2005-01-18 08:00:11.637 89 1 DB780 744.00 632.00 .99 .59 2005-01-19 08:00:09.123 123 1 DB780 744.00 633.00 .99 .56 2005-01-20 08:00:09.873 157 1 DB780 744.00 634.00 .99 .67 2005-01-21 08:00:10.237 191 1 DB780 744.00 634.00 .99 .55 2005-01-22 08:00:11.680 225 1 DB780 744.00 635.00 5.99 .47 2005-01-23 08:00:15.493 259 1 DB780 744.00 635.00 5.99 .63 2005-01-24 08:00:10.137 293 1 DB780 744.00 635.00 5.99 .71 2005-01-25 08:00:09.380 327 1 DB780 744.00 637.00 5.99 .77 2005-01-27 08:00:10.640 361 1 DB780 744.00 637.00 5.99 2.90 2005-01-28 08:00:11.520 396 1 DB780 744.00 638.00 5.99 1.23 2005-01-29 08:00:14.120 431 1 DB780 744.00 638.00 5.99 1.90 2005-01-30 08:00:10.823 466 1 DB780 744.00 638.00 5.99 .47 2005-01-31 08:00:09.457 501 1 DB780 744.00 642.00 3.49 2.81 2005-02-01 08:00:07.140 22 1 DB781 1190.00 996.00 5.99 .53 2005-01-17 13:59:10.477 56 1 DB781 1190.00 996.00 .99 .40 2005-01-18 08:00:11.637 90 1 DB781 1190.00 997.00 .99 .57 2005-01-19 08:00:09.123 124 1 DB781 1190.00 998.00 .99 .55 2005-01-20 08:00:09.873 158 1 DB781 1190.00 999.00 .99 .64 2005-01-21 08:00:10.237 192 1 DB781 1190.00 1001.00 .99 .53 2005-01-22 08:00:11.680 226 1 DB781 1190.00 1000.00 5.99 .47 2005-01-23 08:00:15.493 260 1 DB781 1190.00 1001.00 5.99 .57 2005-01-24 08:00:10.137 294 1 DB781 1190.00 1002.00 5.99 1.15 2005-01-25 08:00:09.380 328 1 DB781 1190.00 1004.00 5.99 1.82 2005-01-27 08:00:10.640 362 1 DB781 1190.00 1006.00 5.99 .70 2005-01-28 08:00:11.520 397 1 DB781 1190.00 1008.00 5.99 2.00 2005-01-29 08:00:14.120 432 1 DB781 1190.00 1007.00 5.99 .48 2005-01-30 08:00:10.823 467 1 DB781 1190.00 1007.00 .99 .35 2005-01-31 08:00:09.457 502 1 DB781 1190.00 1011.00 .99 .61 2005-02-01 08:00:07.140 23 1 DB784 851.00 724.00 5.99 .47 2005-01-17 13:59:10.477 57 1 DB784 851.00 724.00 .99 .34 2005-01-18 08:00:11.637 91 1 DB784 851.00 725.00 .99 .56 2005-01-19 08:00:09.123 125 1 DB784 851.00 726.00 .99 .52 2005-01-20 08:00:09.873 159 1 DB784 851.00 726.00 .99 .59 2005-01-21 08:00:10.237 193 1 DB784 851.00 727.00 .99 .52 2005-01-22 08:00:11.680 227 1 DB784 851.00 727.00 5.99 .47 2005-01-23 08:00:15.493 261 1 DB784 851.00 727.00 5.99 .63 2005-01-24 08:00:10.137 295 1 DB784 851.00 727.00 5.99 .82 2005-01-25 08:00:09.380 329 1 DB784 851.00 729.00 5.99 .55 2005-01-27 08:00:10.640 363 1 DB784 851.00 729.00 5.99 2.63 2005-01-28 08:00:11.520 398 1 DB784 851.00 730.00 5.99 2.81 2005-01-29 08:00:14.120 433 1 DB784 851.00 730.00 5.99 1.98 2005-01-30 08:00:10.823 468 1 DB784 851.00 730.00 5.99 .47 2005-01-31 08:00:09.457 503 1 DB784 851.00 738.00 3.49 2.08 2005-02-01 08:00:07.140 24 1 DB785 591.00 495.00 .99 .34 2005-01-17 13:59:10.477 58 1 DB785 591.00 495.00 .99 .34 2005-01-18 08:00:11.637 92 1 DB785 591.00 495.00 .99 .52 2005-01-19 08:00:09.123 126 1 DB785 591.00 496.00 .99 .56 2005-01-20 08:00:09.873 160 1 DB785 591.00 497.00 .99 .66 2005-01-21 08:00:10.237 194 1 DB785 591.00 497.00 .99 .55 2005-01-22 08:00:11.680 228 1 DB785 591.00 497.00 5.99 .47 2005-01-23 08:00:15.493 262 1 DB785 591.00 497.00 5.99 .65 2005-01-24 08:00:10.137 296 1 DB785 591.00 498.00 5.99 .60 2005-01-25 08:00:09.380 330 1 DB785 591.00 500.00 5.99 .78 2005-01-27 08:00:10.640 364 1 DB785 591.00 500.00 5.99 2.87 2005-01-28 08:00:11.520 399 1 DB785 591.00 501.00 5.99 .78 2005-01-29 08:00:14.120 434 1 DB785 591.00 501.00 5.99 1.45 2005-01-30 08:00:10.823 469 1 DB785 591.00 501.00 5.99 .47 2005-01-31 08:00:09.457 504 1 DB785 591.00 502.00 3.49 .60 2005-02-01 08:00:07.140 25 1 DB820 133.00 118.00 .99 .55 2005-01-17 13:59:10.477 59 1 DB820 133.00 118.00 .99 .67 2005-01-18 08:00:11.637 93 1 DB820 133.00 119.00 .99 .57 2005-01-19 08:00:09.123 127 1 DB820 133.00 119.00 .99 .56 2005-01-20 08:00:09.873 161 1 DB820 133.00 121.00 .99 .66 2005-01-21 08:00:10.237 195 1 DB820 133.00 121.00 .99 .54 2005-01-22 08:00:11.680 229 1 DB820 136.00 121.00 .99 .67 2005-01-23 08:00:15.493 263 1 DB820 136.00 121.00 .99 .59 2005-01-24 08:00:10.137 297 1 DB820 136.00 122.00 .99 .59 2005-01-25 08:00:09.380 331 1 DB820 136.00 124.00 .99 .52 2005-01-27 08:00:10.640 365 1 DB820 136.00 125.00 .99 .54 2005-01-28 08:00:11.520 400 1 DB820 136.00 126.00 .99 .60 2005-01-29 08:00:14.120 435 1 DB820 142.00 125.00 .99 .63 2005-01-30 08:00:10.823 470 1 DB820 142.00 125.00 .99 .68 2005-01-31 08:00:09.457 505 1 DB820 142.00 127.00 .99 .51 2005-02-01 08:00:07.140 26 1 DB859 92288.00 92048.00 13.49 .51 2005-01-17 13:59:10.477 60 1 DB859 92288.00 92048.00 .99 .51 2005-01-18 08:00:11.637 94 1 DB859 92288.00 92048.00 .99 .57 2005-01-19 08:00:09.123 128 1 DB859 92288.00 92050.00 .99 .52 2005-01-20 08:00:09.873 162 1 DB859 92288.00 92052.00 .99 .58 2005-01-21 08:00:10.237 196 1 DB859 92288.00 92054.00 .99 .70 2005-01-22 08:00:11.680 230 1 DB859 92288.00 92053.00 50.99 8.85 2005-01-23 08:00:15.493 264 1 DB859 92288.00 92054.00 13.49 .52 2005-01-24 08:00:10.137 298 1 DB859 92288.00 92055.00 13.49 5.08 2005-01-25 08:00:09.380 332 1 DB859 92288.00 92104.00 13.49 5.50 2005-01-27 08:00:10.640 366 1 DB859 92388.00 92362.00 13.49 1.32 2005-01-28 08:00:11.520 401 1 DB859 93288.00 93241.00 13.49 .93 2005-01-29 08:00:14.120 436 1 DB859 93488.00 93231.00 13.49 9.25 2005-01-30 08:00:10.823 471 1 DB859 93488.00 93242.00 13.49 .54 2005-01-31 08:00:09.457 506 1 DB859 95788.00 95757.00 13.49 8.86 2005-02-01 08:00:07.140 27 1 DB872 63891.00 63624.00 5.99 .63 2005-01-17 13:59:10.477 61 1 DB872 63891.00 63624.00 .99 .50 2005-01-18 08:00:11.637 95 1 DB872 63891.00 63624.00 .99 .55 2005-01-19 08:00:09.123 129 1 DB872 63891.00 63626.00 .99 .61 2005-01-20 08:00:09.873 163 1 DB872 63891.00 63626.00 .99 .56 2005-01-21 08:00:10.237 197 1 DB872 63891.00 63627.00 .99 .68 2005-01-22 08:00:11.680 231 1 DB872 63891.00 63627.00 10.99 1.65 2005-01-23 08:00:15.493 265 1 DB872 63891.00 63627.00 5.99 .66 2005-01-24 08:00:10.137 299 1 DB872 63891.00 63627.00 .99 .60 2005-01-25 08:00:09.380 333 1 DB872 63891.00 63677.00 .99 .62 2005-01-27 08:00:10.640 367 1 DB872 63941.00 63925.00 .99 .63 2005-01-28 08:00:11.520 402 1 DB872 64391.00 64369.00 .99 .53 2005-01-29 08:00:14.120 437 1 DB872 64641.00 64364.00 10.99 1.76 2005-01-30 08:00:10.823 472 1 DB872 64641.00 64364.00 8.49 .55 2005-01-31 08:00:09.457 507 1 DB872 64641.00 64500.00 .99 .53 2005-02-01 08:00:07.140 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating growth with negative numbers | Excel Worksheet Functions | |||
Need help with exel database | Excel Discussion (Misc queries) | |||
Need help with exel database | Excel Discussion (Misc queries) | |||
How do I create a "List If" function.I need to search a database . | Excel Worksheet Functions | |||
i want to open database exclusively | Excel Discussion (Misc queries) |