Need help tidying up a report

A

alexm999

I have a report generated every morning. And I need to sum it all up t
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.

Re
No Received(EST) Scheduled(EST) Delivered(EST) Cost Pages #Success #Failed Bil
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.0
1 0 248 NH
77187004 3/1/2006 10:27 3/1/2006 19:30 3/1/2006 10:42 $0.0
1 0 192 NH
77187005 3/1/2006 10:27 3/1/2006 19:30 3/1/2006 10:42 $0.0
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.0
1 0 251 NH
77187010 3/1/2006 10:27 3/1/2006 19:30 3/1/2006 10:42 $0.0
1 0 1242 NH
77187011 3/1/2006 10:27 3/1/2006 19:30 3/1/2006 10:42 $0.0
1 0 442 NH
77187041 3/1/2006 10:27 3/1/2006 19:30 3/1/2006 10:42 $0.0
1 0 896 NH
77187044 3/1/2006 10:27 3/1/2006 19:30 3/1/2006 10:43 $0.0
1 0 240 NH
77187046 3/1/2006 10:27 3/1/2006 19:30 3/1/2006 10:43 $0.0
1 0 134 NH
77210557 3/1/2006 16:15 3/1/2006 18:30 3/1/2006 18:57 $19.8
1 661 334 CO
77210559 3/1/2006 16:15 3/1/2006 18:30 3/1/2006 19:03 $22.5
1 750 395 CO
77210560 3/1/2006 16:15 3/1/2006 18:30 3/1/2006 18:58 $14.0
1 468 338 CO
77210561 3/1/2006 16:15 3/1/2006 18:30 3/1/2006 18:53 $2.7
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.4
1 1314 617 CO
77210609 3/1/2006 16:16 3/1/2006 18:30 3/1/2006 18:54 $5.5
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.9
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.0
1 36 31 CO
77210662 3/1/2006 16:17 3/1/2006 18:30 3/1/2006 18:54 $1.5
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.3
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.3
1 10 11 CO
77210675 3/1/2006 16:17 3/1/2006 18:30 3/1/2006 19:02 $24.0
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.5
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.9
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.6
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.6
1 21 22 CO
77210704 3/1/2006 16:18 3/1/2006 18:30 3/1/2006 18:52 $7.8
1 261 147 CO
77210706 3/1/2006 16:18 3/1/2006 18:30 3/1/2006 18:55 $0.8
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.5
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.0
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
 
A

alexm999

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top