Need help tidying up a report

**alexm999** · 03-02-2006, 10:16 AM

I have a report generated every morning. And I need to sum it all up to look more 'tidy' as the boss puts it. Can anyone help or give me ideas. Here's an example of the copy and paste from the CSV file created.

Ref No Received(EST) Scheduled(EST) Delivered(EST) Cost Pages #Success #Failed Bill Code
77187001 3/1/2006 10:27 3/1/2006 19:30 3/1/2006 10:42 $0.00 1 0 2 MA
77187002 3/1/2006 10:27 3/1/2006 19:30 3/1/2006 10:42 $0.00 1 0 248 NH
77187004 3/1/2006 10:27 3/1/2006 19:30 3/1/2006 10:42 $0.00 1 0 192 NH
77187005 3/1/2006 10:27 3/1/2006 19:30 3/1/2006 10:42 $0.00 1 0 229 NH
77187006 3/1/2006 10:27 3/1/2006 19:30 3/1/2006 10:42 $0.00 1 0 87 NH
77187008 3/1/2006 10:27 3/1/2006 19:30 3/1/2006 10:42 $0.00 1 0 251 NH
77187010 3/1/2006 10:27 3/1/2006 19:30 3/1/2006 10:42 $0.00 1 0 1242 NH
77187011 3/1/2006 10:27 3/1/2006 19:30 3/1/2006 10:42 $0.00 1 0 442 NH
77187041 3/1/2006 10:27 3/1/2006 19:30 3/1/2006 10:42 $0.00 1 0 896 NH
77187044 3/1/2006 10:27 3/1/2006 19:30 3/1/2006 10:43 $0.00 1 0 240 NH
77187046 3/1/2006 10:27 3/1/2006 19:30 3/1/2006 10:43 $0.00 1 0 134 NH
77210557 3/1/2006 16:15 3/1/2006 18:30 3/1/2006 18:57 $19.83 1 661 334 CO
77210559 3/1/2006 16:15 3/1/2006 18:30 3/1/2006 19:03 $22.50 1 750 395 CO
77210560 3/1/2006 16:15 3/1/2006 18:30 3/1/2006 18:58 $14.04 1 468 338 CO
77210561 3/1/2006 16:15 3/1/2006 18:30 3/1/2006 18:53 $2.73 1 91 72 CO
77210562 3/1/2006 16:15 3/1/2006 18:30 3/1/2006 18:51 $0.15 1 5 11 CO
77210582 3/1/2006 16:16 3/1/2006 18:30 3/1/2006 18:57 $39.42 1 1314 617 CO
77210609 3/1/2006 16:16 3/1/2006 18:30 3/1/2006 18:54 $5.58 1 186 147 CO
77210613 3/1/2006 16:16 3/1/2006 18:30 3/1/2006 18:51 $0.03 1 1 4 CO
77210614 3/1/2006 16:16 3/1/2006 18:30 3/1/2006 18:48 $0.12 1 4 0 CO
77210615 3/1/2006 16:16 3/1/2006 18:30 3/1/2006 18:58 $18.96 1 632 392 CO
77210616 3/1/2006 16:16 3/1/2006 18:30 3/1/2006 18:51 $0.09 1 3 2 CO
77210617 3/1/2006 16:16 3/1/2006 18:30 3/1/2006 18:48 $0.27 1 9 3 CO
77210618 3/1/2006 16:16 3/1/2006 18:30 3/1/2006 18:54 $1.08 1 36 31 CO
77210662 3/1/2006 16:17 3/1/2006 18:30 3/1/2006 18:54 $1.50 1 50 31 CO
77210663 3/1/2006 16:17 3/1/2006 18:30 3/1/2006 18:51 $0.15 1 5 4 CO
77210664 3/1/2006 16:17 3/1/2006 18:30 3/1/2006 18:43 $0.12 1 4 0 CO
77210666 3/1/2006 16:17 3/1/2006 18:30 3/1/2006 18:54 $1.35 1 45 40 CO
77210667 3/1/2006 16:17 3/1/2006 18:30 3/1/2006 18:43 $0.18 1 6 0 CO
77210668 3/1/2006 16:17 3/1/2006 18:30 3/1/2006 18:51 $0.21 1 7 6 CO
77210670 3/1/2006 16:17 3/1/2006 18:30 3/1/2006 18:51 $0.06 1 2 3 CO
77210671 3/1/2006 16:17 3/1/2006 18:30 3/1/2006 18:37 $0.09 1 3 0 CO
77210672 3/1/2006 16:17 3/1/2006 18:30 3/1/2006 18:54 $0.30 1 10 11 CO
77210675 3/1/2006 16:17 3/1/2006 18:30 3/1/2006 19:02 $24.03 1 801 514 CO
77210676 3/1/2006 16:17 3/1/2006 18:30 3/1/2006 18:51 $0.15 1 5 4 CO
77210677 3/1/2006 16:17 3/1/2006 18:30 3/1/2006 18:54 $1.56 1 52 53 CO
77210683 3/1/2006 16:17 3/1/2006 18:30 3/1/2006 18:51 $0.30 1 10 5 CO
77210694 3/1/2006 16:18 3/1/2006 18:30 3/1/2006 18:51 $0.00 1 0 3 CO
77210695 3/1/2006 16:18 3/1/2006 18:30 3/1/2006 18:52 $0.09 1 3 5 CO
77210696 3/1/2006 16:18 3/1/2006 18:30 3/1/2006 18:54 $0.60 1 20 6 CO
77210697 3/1/2006 16:18 3/1/2006 18:30 3/1/2006 18:55 $0.45 1 15 8 CO
77210698 3/1/2006 16:18 3/1/2006 18:30 3/1/2006 18:53 $0.93 1 31 15 CO
77210700 3/1/2006 16:18 3/1/2006 18:30 3/1/2006 18:52 $0.36 1 12 6 CO
77210701 3/1/2006 16:18 3/1/2006 18:30 3/1/2006 18:55 $0.60 1 20 14 CO
77210702 3/1/2006 16:18 3/1/2006 18:30 3/1/2006 18:52 $0.18 1 6 14 CO
77210703 3/1/2006 16:18 3/1/2006 18:30 3/1/2006 18:55 $0.63 1 21 22 CO
77210704 3/1/2006 16:18 3/1/2006 18:30 3/1/2006 18:52 $7.83 1 261 147 CO
77210706 3/1/2006 16:18 3/1/2006 18:30 3/1/2006 18:55 $0.84 1 28 17 CO
77210707 3/1/2006 16:18 3/1/2006 18:30 3/1/2006 18:48 $0.27 1 9 8 CO
77210708 3/1/2006 16:18 3/1/2006 18:30 3/1/2006 18:55 $0.54 1 18 16 CO
77210773 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:52 $0.03 1 1 1 CO
77210775 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:53 $1.05 1 35 27 CO
77210778 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:43 $0.36 1 12 6 CO
77210779 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:57 $1.23 1 41 29 CO
77210780 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:37 $0.03 1 1 2 CO
77210781 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:55 $5.01 1 167 118 CO
77210782 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:55 $4.95 1 165 104 CO
77210783 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:55 $1.11 1 37 42 CO
77210784 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:55 $0.87 1 29 36 CO
77210785 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:52 $0.06 1 2 5 CO
77210786 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:52 $0.03 1 1 3 CO
77210787 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:54 $3.93 1 131 118 CO
77210794 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:54 $13.44 1 448 329 CO
77210795 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:55 $1.35 1 45 24 CO
77210796 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:57 $9.21 1 307 213 CO
77210799 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:55 $1.29 1 43 17 CO
77210800 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:55 $2.19 1 73 54 CO
77210801 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:56 $2.79 1 93 74 CO
77210810 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:56 $1.32 1 44 30 CO
77210823 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:52 $0.09 1 3 8 CO
77210825 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:37 $0.21 1 7 2 CO
77210826 3/1/2006 16:20 3/1/2006 18:30 3/1/2006 18:56 $1.53 1 51 47 CO
77210827 3/1/2006 16:20 3/1/2006 18:30 3/1/2006 18:54 $0.33 1 11 12 CO
77210828 3/1/2006 16:20 3/1/2006 18:30 3/1/2006 18:57 $2.04 1 68 63 CO
77210829 3/1/2006 16:20 3/1/2006 18:30 3/1/2006 18:52 $0.03 1 1 4 CO
77210837 3/1/2006 16:20 3/1/2006 18:30 3/1/2006 18:56 $0.75 1 25 21 CO
77210845 3/1/2006 16:20 3/1/2006 18:30 3/1/2006 18:52 $0.09 1 3 5 CO
77210862 3/1/2006 16:20 3/1/2006 18:30 3/1/2006 18:56 $2.79 1 93 96 CO
77210863 3/1/2006 16:20 3/1/2006 18:30 3/1/2006 18:43 $0.06 1 2 2 CO
77210864 3/1/2006 16:20 3/1/2006 18:30 3/1/2006 18:53 $6.09 1 203 149 CO
77210865 3/1/2006 16:20 3/1/2006 18:30 3/1/2006 18:49 $0.54 1 18 8 CO
77210924 3/1/2006 16:21 3/1/2006 17:45 3/1/2006 18:07 $2.94 1 98 17 KS
77210929 3/1/2006 16:21 3/1/2006 17:45 3/1/2006 18:07 $2.37 1 79 17 KS
77210951 3/1/2006 16:21 3/1/2006 17:45 3/1/2006 18:11 $41.19 1 1373 176 KS
77210952 3/1/2006 16:21 3/1/2006 17:45 3/1/2006 18:05 $0.42 1 14 1 KS
77211013 3/1/2006 16:22 3/1/2006 17:45 3/1/2006 18:02 $0.60 1 20 6 KS
77211015 3/1/2006 16:22 3/1/2006 17:45 3/1/2006 18:02 $0.54 1 18 5 KS
77211016 3/1/2006 16:22 3/1/2006 17:45 3/1/2006 18:02 $0.24 1 8 1 KS
77211018 3/1/2006 16:22 3/1/2006 17:45 3/1/2006 18:02 $0.60 1 20 8 KS
77211019 3/1/2006 16:22 3/1/2006 17:45 3/1/2006 18:07 $0.78 1 26 6 KS
77211020 3/1/2006 16:22 3/1/2006 17:45 3/1/2006 17:51 $0.06 1 2 0 KS
77211021 3/1/2006 16:22 3/1/2006 17:45 3/1/2006 18:07 $0.24 1 8 3 KS
77211022 3/1/2006 16:22 3/1/2006 17:45 3/1/2006 18:08 $1.17 1 39 9 KS
77211024 3/1/2006 16:22 3/1/2006 17:45 3/1/2006 18:08 $0.24 1 8 4 KS
77211027 3/1/2006 16:22 3/1/2006 17:45 3/1/2006 18:09 $5.88 1 196 59 KS
77211029 3/1/2006 16:22 3/1/2006 17:45 3/1/2006 18:07 $3.03 1 101 23 KS
77211031 3/1/2006 16:22 3/1/2006 17:45 3/1/2006 18:02 $0.54 1 18 4 KS
77211032 3/1/2006 16:22 3/1/2006 17:45 3/1/2006 18:07 $1.26 1 42 8 KS
77211033 3/1/2006 16:22 3/1/2006 17:45 3/1/2006 18:07 $1.56 1 52 17 KS
77211036 3/1/2006 16:22 3/1/2006 17:45 3/1/2006 18:02 $0.63 1 21 4 KS
77211037 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:05 $0.27 1 9 7 KS
77211038 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:05 $0.36 1 12 7 KS
77211039 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:02 $0.54 1 18 6 KS
77211041 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:02 $0.15 1 5 2 KS
77211043 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:01 $0.03 1 1 1 KS
77211044 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:07 $0.27 1 9 1 KS
77211053 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 17:53 $0.27 1 9 0 KS
77211065 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 17:51 $0.06 1 2 0 KS
77211070 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:05 $0.93 1 31 5 KS
77211071 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:05 $0.39 1 13 4 KS
77211072 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 17:58 $0.81 1 27 0 KS
77211074 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:02 $0.09 1 3 0 KS
77211076 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:02 $1.14 1 38 5 KS
77211080 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:05 $0.57 1 19 1 KS
77211090 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:09 $0.51 1 17 4 KS
77211096 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:09 $0.39 1 13 12 KS
77211097 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:05 $0.51 1 17 1 KS
77211098 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:05 $0.39 1 13 4 KS
77211100 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:09 $0.63 1 21 7 KS
77211101 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:07 $0.87 1 29 8 KS
77211102 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 17:54 $0.24 1 8 2 KS
77211105 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:05 $0.45 1 15 2 KS
77211107 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:07 $3.69 1 123 22 KS
77211108 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:05 $0.48 1 16 3 KS
77211113 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:06 $0.27 1 9 4 KS
77211114 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:03 $0.54 1 18 3 KS
77211115 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:06 $6.51 1 217 43 KS
77211117 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:07 $11.13 1 371 103 KS
77211119 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:06 $0.30 1 10 2 KS
77211120 3/1/2006 16:24 3/1/2006 17:45 3/1/2006 18:09 $0.57 1 19 2 KS
77211121 3/1/2006 16:24 3/1/2006 17:45 3/1/2006 17:53 $0.36 1 12 2 KS
77211130 3/1/2006 16:24 3/1/2006 17:45 3/1/2006 18:06 $0.84 1 28 6 KS
77211140 3/1/2006 16:24 3/1/2006 17:45 3/1/2006 18:06 $0.33 1 11 5 KS

Bernard Liengme · 03-02-2006, 10:45 AM

We need to know what has to be summed.
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"alexm999" <[email protected]> wrote in
message news:[email protected]...
>
> I have a report generated every morning. And I need to sum it all up to
> look more 'tidy' as the boss puts it. Can anyone help or give me ideas.
> Here's an example of the copy and paste from the CSV file created.
>
> Ref
> No Received(EST) Scheduled(EST) Delivered(EST) Cost Pages #Success #Failed
> Bill
> Code
> 77187001 3/1/2006 10:27 3/1/2006 19:30 3/1/2006 10:42 $0.00 1 0 2 MA
> 77187002 3/1/2006 10:27 3/1/2006 19:30 3/1/2006 10:42 $0.00
> 1 0 248 NH
> 77187004 3/1/2006 10:27 3/1/2006 19:30 3/1/2006 10:42 $0.00
> 1 0 192 NH
> 77187005 3/1/2006 10:27 3/1/2006 19:30 3/1/2006 10:42 $0.00
> 1 0 229 NH
> 77187006 3/1/2006 10:27 3/1/2006 19:30 3/1/2006 10:42 $0.00 1 0 87 NH
> 77187008 3/1/2006 10:27 3/1/2006 19:30 3/1/2006 10:42 $0.00
> 1 0 251 NH
> 77187010 3/1/2006 10:27 3/1/2006 19:30 3/1/2006 10:42 $0.00
> 1 0 1242 NH
> 77187011 3/1/2006 10:27 3/1/2006 19:30 3/1/2006 10:42 $0.00
> 1 0 442 NH
> 77187041 3/1/2006 10:27 3/1/2006 19:30 3/1/2006 10:42 $0.00
> 1 0 896 NH
> 77187044 3/1/2006 10:27 3/1/2006 19:30 3/1/2006 10:43 $0.00
> 1 0 240 NH
> 77187046 3/1/2006 10:27 3/1/2006 19:30 3/1/2006 10:43 $0.00
> 1 0 134 NH
> 77210557 3/1/2006 16:15 3/1/2006 18:30 3/1/2006 18:57 $19.83
> 1 661 334 CO
> 77210559 3/1/2006 16:15 3/1/2006 18:30 3/1/2006 19:03 $22.50
> 1 750 395 CO
> 77210560 3/1/2006 16:15 3/1/2006 18:30 3/1/2006 18:58 $14.04
> 1 468 338 CO
> 77210561 3/1/2006 16:15 3/1/2006 18:30 3/1/2006 18:53 $2.73
> 1 91 72 CO
> 77210562 3/1/2006 16:15 3/1/2006 18:30 3/1/2006 18:51 $0.15 1 5 11 CO
> 77210582 3/1/2006 16:16 3/1/2006 18:30 3/1/2006 18:57 $39.42
> 1 1314 617 CO
> 77210609 3/1/2006 16:16 3/1/2006 18:30 3/1/2006 18:54 $5.58
> 1 186 147 CO
> 77210613 3/1/2006 16:16 3/1/2006 18:30 3/1/2006 18:51 $0.03 1 1 4 CO
> 77210614 3/1/2006 16:16 3/1/2006 18:30 3/1/2006 18:48 $0.12 1 4 0 CO
> 77210615 3/1/2006 16:16 3/1/2006 18:30 3/1/2006 18:58 $18.96
> 1 632 392 CO
> 77210616 3/1/2006 16:16 3/1/2006 18:30 3/1/2006 18:51 $0.09 1 3 2 CO
> 77210617 3/1/2006 16:16 3/1/2006 18:30 3/1/2006 18:48 $0.27 1 9 3 CO
> 77210618 3/1/2006 16:16 3/1/2006 18:30 3/1/2006 18:54 $1.08
> 1 36 31 CO
> 77210662 3/1/2006 16:17 3/1/2006 18:30 3/1/2006 18:54 $1.50
> 1 50 31 CO
> 77210663 3/1/2006 16:17 3/1/2006 18:30 3/1/2006 18:51 $0.15 1 5 4 CO
> 77210664 3/1/2006 16:17 3/1/2006 18:30 3/1/2006 18:43 $0.12 1 4 0 CO
> 77210666 3/1/2006 16:17 3/1/2006 18:30 3/1/2006 18:54 $1.35
> 1 45 40 CO
> 77210667 3/1/2006 16:17 3/1/2006 18:30 3/1/2006 18:43 $0.18 1 6 0 CO
> 77210668 3/1/2006 16:17 3/1/2006 18:30 3/1/2006 18:51 $0.21 1 7 6 CO
> 77210670 3/1/2006 16:17 3/1/2006 18:30 3/1/2006 18:51 $0.06 1 2 3 CO
> 77210671 3/1/2006 16:17 3/1/2006 18:30 3/1/2006 18:37 $0.09 1 3 0 CO
> 77210672 3/1/2006 16:17 3/1/2006 18:30 3/1/2006 18:54 $0.30
> 1 10 11 CO
> 77210675 3/1/2006 16:17 3/1/2006 18:30 3/1/2006 19:02 $24.03
> 1 801 514 CO
> 77210676 3/1/2006 16:17 3/1/2006 18:30 3/1/2006 18:51 $0.15 1 5 4 CO
> 77210677 3/1/2006 16:17 3/1/2006 18:30 3/1/2006 18:54 $1.56
> 1 52 53 CO
> 77210683 3/1/2006 16:17 3/1/2006 18:30 3/1/2006 18:51 $0.30 1 10 5 CO
> 77210694 3/1/2006 16:18 3/1/2006 18:30 3/1/2006 18:51 $0.00 1 0 3 CO
> 77210695 3/1/2006 16:18 3/1/2006 18:30 3/1/2006 18:52 $0.09 1 3 5 CO
> 77210696 3/1/2006 16:18 3/1/2006 18:30 3/1/2006 18:54 $0.60 1 20 6 CO
> 77210697 3/1/2006 16:18 3/1/2006 18:30 3/1/2006 18:55 $0.45 1 15 8 CO
> 77210698 3/1/2006 16:18 3/1/2006 18:30 3/1/2006 18:53 $0.93
> 1 31 15 CO
> 77210700 3/1/2006 16:18 3/1/2006 18:30 3/1/2006 18:52 $0.36 1 12 6 CO
> 77210701 3/1/2006 16:18 3/1/2006 18:30 3/1/2006 18:55 $0.60
> 1 20 14 CO
> 77210702 3/1/2006 16:18 3/1/2006 18:30 3/1/2006 18:52 $0.18 1 6 14 CO
> 77210703 3/1/2006 16:18 3/1/2006 18:30 3/1/2006 18:55 $0.63
> 1 21 22 CO
> 77210704 3/1/2006 16:18 3/1/2006 18:30 3/1/2006 18:52 $7.83
> 1 261 147 CO
> 77210706 3/1/2006 16:18 3/1/2006 18:30 3/1/2006 18:55 $0.84
> 1 28 17 CO
> 77210707 3/1/2006 16:18 3/1/2006 18:30 3/1/2006 18:48 $0.27 1 9 8 CO
> 77210708 3/1/2006 16:18 3/1/2006 18:30 3/1/2006 18:55 $0.54
> 1 18 16 CO
> 77210773 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:52 $0.03 1 1 1 CO
> 77210775 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:53 $1.05
> 1 35 27 CO
> 77210778 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:43 $0.36 1 12 6 CO
> 77210779 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:57 $1.23
> 1 41 29 CO
> 77210780 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:37 $0.03 1 1 2 CO
> 77210781 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:55 $5.01
> 1 167 118 CO
> 77210782 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:55 $4.95
> 1 165 104 CO
> 77210783 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:55 $1.11
> 1 37 42 CO
> 77210784 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:55 $0.87
> 1 29 36 CO
> 77210785 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:52 $0.06 1 2 5 CO
> 77210786 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:52 $0.03 1 1 3 CO
> 77210787 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:54 $3.93
> 1 131 118 CO
> 77210794 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:54 $13.44
> 1 448 329 CO
> 77210795 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:55 $1.35
> 1 45 24 CO
> 77210796 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:57 $9.21
> 1 307 213 CO
> 77210799 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:55 $1.29
> 1 43 17 CO
> 77210800 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:55 $2.19
> 1 73 54 CO
> 77210801 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:56 $2.79
> 1 93 74 CO
> 77210810 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:56 $1.32
> 1 44 30 CO
> 77210823 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:52 $0.09 1 3 8 CO
> 77210825 3/1/2006 16:19 3/1/2006 18:30 3/1/2006 18:37 $0.21 1 7 2 CO
> 77210826 3/1/2006 16:20 3/1/2006 18:30 3/1/2006 18:56 $1.53
> 1 51 47 CO
> 77210827 3/1/2006 16:20 3/1/2006 18:30 3/1/2006 18:54 $0.33
> 1 11 12 CO
> 77210828 3/1/2006 16:20 3/1/2006 18:30 3/1/2006 18:57 $2.04
> 1 68 63 CO
> 77210829 3/1/2006 16:20 3/1/2006 18:30 3/1/2006 18:52 $0.03 1 1 4 CO
> 77210837 3/1/2006 16:20 3/1/2006 18:30 3/1/2006 18:56 $0.75
> 1 25 21 CO
> 77210845 3/1/2006 16:20 3/1/2006 18:30 3/1/2006 18:52 $0.09 1 3 5 CO
> 77210862 3/1/2006 16:20 3/1/2006 18:30 3/1/2006 18:56 $2.79
> 1 93 96 CO
> 77210863 3/1/2006 16:20 3/1/2006 18:30 3/1/2006 18:43 $0.06 1 2 2 CO
> 77210864 3/1/2006 16:20 3/1/2006 18:30 3/1/2006 18:53 $6.09
> 1 203 149 CO
> 77210865 3/1/2006 16:20 3/1/2006 18:30 3/1/2006 18:49 $0.54 1 18 8 CO
> 77210924 3/1/2006 16:21 3/1/2006 17:45 3/1/2006 18:07 $2.94
> 1 98 17 KS
> 77210929 3/1/2006 16:21 3/1/2006 17:45 3/1/2006 18:07 $2.37
> 1 79 17 KS
> 77210951 3/1/2006 16:21 3/1/2006 17:45 3/1/2006 18:11 $41.19
> 1 1373 176 KS
> 77210952 3/1/2006 16:21 3/1/2006 17:45 3/1/2006 18:05 $0.42 1 14 1 KS
> 77211013 3/1/2006 16:22 3/1/2006 17:45 3/1/2006 18:02 $0.60 1 20 6 KS
> 77211015 3/1/2006 16:22 3/1/2006 17:45 3/1/2006 18:02 $0.54 1 18 5 KS
> 77211016 3/1/2006 16:22 3/1/2006 17:45 3/1/2006 18:02 $0.24 1 8 1 KS
> 77211018 3/1/2006 16:22 3/1/2006 17:45 3/1/2006 18:02 $0.60 1 20 8 KS
> 77211019 3/1/2006 16:22 3/1/2006 17:45 3/1/2006 18:07 $0.78 1 26 6 KS
> 77211020 3/1/2006 16:22 3/1/2006 17:45 3/1/2006 17:51 $0.06 1 2 0 KS
> 77211021 3/1/2006 16:22 3/1/2006 17:45 3/1/2006 18:07 $0.24 1 8 3 KS
> 77211022 3/1/2006 16:22 3/1/2006 17:45 3/1/2006 18:08 $1.17 1 39 9 KS
> 77211024 3/1/2006 16:22 3/1/2006 17:45 3/1/2006 18:08 $0.24 1 8 4 KS
> 77211027 3/1/2006 16:22 3/1/2006 17:45 3/1/2006 18:09 $5.88
> 1 196 59 KS
> 77211029 3/1/2006 16:22 3/1/2006 17:45 3/1/2006 18:07 $3.03
> 1 101 23 KS
> 77211031 3/1/2006 16:22 3/1/2006 17:45 3/1/2006 18:02 $0.54 1 18 4 KS
> 77211032 3/1/2006 16:22 3/1/2006 17:45 3/1/2006 18:07 $1.26 1 42 8 KS
> 77211033 3/1/2006 16:22 3/1/2006 17:45 3/1/2006 18:07 $1.56
> 1 52 17 KS
> 77211036 3/1/2006 16:22 3/1/2006 17:45 3/1/2006 18:02 $0.63 1 21 4 KS
> 77211037 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:05 $0.27 1 9 7 KS
> 77211038 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:05 $0.36 1 12 7 KS
> 77211039 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:02 $0.54 1 18 6 KS
> 77211041 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:02 $0.15 1 5 2 KS
> 77211043 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:01 $0.03 1 1 1 KS
> 77211044 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:07 $0.27 1 9 1 KS
> 77211053 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 17:53 $0.27 1 9 0 KS
> 77211065 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 17:51 $0.06 1 2 0 KS
> 77211070 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:05 $0.93 1 31 5 KS
> 77211071 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:05 $0.39 1 13 4 KS
> 77211072 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 17:58 $0.81 1 27 0 KS
> 77211074 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:02 $0.09 1 3 0 KS
> 77211076 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:02 $1.14 1 38 5 KS
> 77211080 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:05 $0.57 1 19 1 KS
> 77211090 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:09 $0.51 1 17 4 KS
> 77211096 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:09 $0.39
> 1 13 12 KS
> 77211097 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:05 $0.51 1 17 1 KS
> 77211098 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:05 $0.39 1 13 4 KS
> 77211100 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:09 $0.63 1 21 7 KS
> 77211101 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:07 $0.87 1 29 8 KS
> 77211102 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 17:54 $0.24 1 8 2 KS
> 77211105 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:05 $0.45 1 15 2 KS
> 77211107 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:07 $3.69
> 1 123 22 KS
> 77211108 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:05 $0.48 1 16 3 KS
> 77211113 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:06 $0.27 1 9 4 KS
> 77211114 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:03 $0.54 1 18 3 KS
> 77211115 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:06 $6.51
> 1 217 43 KS
> 77211117 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:07 $11.13
> 1 371 103 KS
> 77211119 3/1/2006 16:23 3/1/2006 17:45 3/1/2006 18:06 $0.30 1 10 2 KS
> 77211120 3/1/2006 16:24 3/1/2006 17:45 3/1/2006 18:09 $0.57 1 19 2 KS
> 77211121 3/1/2006 16:24 3/1/2006 17:45 3/1/2006 17:53 $0.36 1 12 2 KS
> 77211130 3/1/2006 16:24 3/1/2006 17:45 3/1/2006 18:06 $0.84 1 28 6 KS
> 77211140 3/1/2006 16:24 3/1/2006 17:45 3/1/2006 18:06 $0.33 1 11 5 KS
>
>
> --
> alexm999
> ------------------------------------------------------------------------
> alexm999's Profile:
> http://www.excelforum.com/member.php...fo&userid=4918
> View this thread: http://www.excelforum.com/showthread...hreadid=518210
>

**alexm999** · 03-02-2006, 10:51 AM

The is to be summed:
Everything is centered on the Billing code which is an abbreviation of a state. (CO, VT, MA, etc...)
Then to be summed and broken up are:
State, Delivery Date and Time, Success, Failed and cost.
I don't mind having the CSV file opened, but in a different excel file, i need to sum up the above mentioned.

Hope this helps.

Need help tidying up a report

LinkBack

Thread Tools

Rate This Thread

Display

Need help tidying up a report

Re: Need help tidying up a report

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions