Clipboard Font is Alignment V2 fr A B C D F G . J K E Homework Case: The following data are downloaded from sales module of a company's ERP system. The ERP system automatically recognizes sales and posts the journal entry "DR AR CR Sales" to general ledger when an invoice is created. Sales personnel are responsible of creating invoices after shipping labels are printed from shipping department. Shipping labels are printed when carriers are booked and the products are ready to be shipped to customers. The times and dates for all sales are automatically recorded by the ERP system when the sale is complete (inovice generated). All sales 1 over $20.000 must be authorized by a senior manager before the sale can be entered into the system. Requirements: Please use Excel functions to find as many fraud red flags as possible. Please create new tab to list the flagged items with a brief explanation as why these items deserve further attentions and/or investigations. You may further elaborate on the possible motivations behind frauster and what they intend to achieve by creating such misleading information, how they may be benefited from such actitivties. Please use at least two excel funcitons in your analysis: filter and pivot table. Please create at least 3 new tabs in the following 3 suspicious areas: invoice generated 2 date, credit memos, and invoice amounts. Credit Date Credit Amount 4 Salesperson A 5 11/7/2015 $14,768.82 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 Invoice Sale Date Sale Time Number 20001 11/2/2015 13:31:28 20002 11/2/2015 13:41:33 20003 11/2/2015 15:19:56 20004 11/2/2015 16:26:52 20005 11/2/2015 16:01:22 20006 11/2/2015 09:24:38 20007 11/2/2015 11:03:18 20008 11/2/2015 15:46:55 20009 11/2/2015 09:52:03 20010 11/2/2015 10:37:37 20011 11/2/2015 09:21:39 20012 11/2/2015 13:15:29 20013 11/2/2015 10:13:52 20014 11/2/2015 16:01:19 20015 11/2/2015 13:45:07 20016 11/12/2015 13:03:29 20017 11/12/2015 14:54:29 20018 11/3/2015 09:59:28 20019 11/3/2015 12:48:32 20020 11/3/2015 13:50:00 20021 11/6/2015 21:50:01 20022 11/6/2015 09:12:09 20023 11/6/2015 08:49:04 20024 11/9/2015 16:09:15 20025 11/9/2015 15:56:03 20026 11/9/2015 16:36:17 Query1 Sale Amount $8,090.03 $19,166.57 $6,269.27 $13,361.81 $9.216.60 $11,528.98 $19,000.00 $9,579.46 $14.768.82 $8.733.64 $18,992.28 $12,019.59 $51,394.33 $7,922.47 $35,896.57 $10,308.75 $19,900.00 $20,000.00 $12,406.18 $7,242.38 $17,490.62 $12,852.28 $12,636.12 $7,691.13 $11.976.10 $9,615.38 B B B A A B B B Customer Credit Memo Number Number 1124 1131 1127 1132 1140 1137 1123 1120 1129 3145 1128 1131 1124 1126 1138 1138 1137 1123 1133 1130 1128 3146 1123 1122 1140 1121 1122 1120 11/9/2015 $7,242.38 V2 fic A . J L F A B B B E $7,691.13 $11,976.10 $9,615.38 $11,746.38 $11,869.73 $7,268.23 $8,596.85 $8,481.82 $9,202.38 $11,433.28 $7,368.18 $10,526.33 $12,739.12 $22,279.29 $8,642.30 $10,156.87 $33.944.90 $9,254.25 $23,024.87 $12.989.18 $10,647.12 $13,339.77 $12,740.33 $9,013.10 $12,161.29 $16,095.11 $8,065.38 $12,640.85 $10,189.61 $10,095.27 $8,572.98 $9.108.29 $15,878.98 $4,193.80 $15,341.83 $10,196.52 $11,661.46 $10,758.88 $6.289.17 $9,873.70 $5,157.19 $16,752.49 $8,890.23 $2,328.24 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 3147 11/19/2015 B 20024 11/9/2015 16:09:15 20025 11/9/2015 15:56:03 20026 11/9/2015 16:36:17 20027 11/9/2015 11:15:21 20028 11/9/2015 13:24:57 20029 11/9/2015 14:40:00 20030 11/9/2015 10:26:11 20031 11/10/2015 15:19:42 20032 11/10/2015 11:19:07 20033 11/10/2015 15:49:12 20034 11/10/2015 12:57:16 20035 11/10/2015 12:58:52 20036 11/10/2015 16:52:50 20037 11/10/2015 14:57:42 20038 11/10/2015 08:18:30 20039 11/10/2015 12:31:05 20040 11/10/2015 16:45:09 20041 11/10/2015 11:59:35 20042 11/10/2015 15:14:08 20043 11/10/2015 14:53:19 20044 11/13/2015 11:50:15 20045 11/13/2015 16:03:49 20046 11/13/2015 16:46:06 20047 11/16/2015 08:58:28 20048 11/17/2015 10:50:28 20049 11/17/2015 11:58:58 20050 11/17/2015 12:42:27 20051 11/18/2015 14:27:40 20052 11/18/2015 08:47:27 20053 11/18/2015 12:40:34 20054 11/18/2015 12:29:54 20055 11/18/2015 09:39:16 20056 11/18/2015 12:28:35 20058 11/18/2015 16:33:14 20059 11/18/2015 12:46:28 20060 11/18/2015 08:44:16 20061 11/18/2015 10:11:15 20062 11/18/2015 12:37:52 20063 11/18/2015 14:26:14 20064 11/18/2015 11:22:32 20065 11/23/2015 14:40:52 20066 11/23/2015 16:33:15 20067 11/23/2015 15:37:23 20068 11/23/2015 14:58:59 Query1 G 1121 1122 1120 1138 1123 1139 1130 1128 1125 1132 1127 1126 1132 1130 1121 1136 1139 1132 1133 1134 1121 1133 1140 1122 1137 1137 1133 1135 1122 1139 1131 1128 1128 1122 1137 1139 1139 1131 1138 1121 1127 1132 1122 1131 $13,339.77 B B B B B A A B B A A B B B Select destination and press ENTER or choose Paste Clipboard Font Alignment NU V2 fx A B D H | J L M 3148 11/27/2015 $16,347.16 3149 12/4/2015 56,154.50 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 20068 11/23/2015 14:58:59 20069 11/23/2015 11:59:15 20070 11/23/2015 15:41:09 20071 11/23/2015 11:53:21 20072 11/23/2015 10:24:09 20073 11/23/2015 09:56:26 20074 11/23/2015 08:45:30 20075 11/23/2015 15:45:53 20076 11/23/2015 08:03:35 20077 11/23/2015 16:39:52 20078 11/23/2015 11:29:28 20079 11/24/2015 11:40:57 20080 11/23/2015 15:42:01 20081 11/23/2015 13:32:53 20082 11/27/2015 15:45:10 20083 11/27/2015 13:14:14 20084 11/29/2015 16:45:18 20085 11/30/2015 10:20:23 20086 12/1/2015 16:32:05 20087 12/2/2015 23:59:20 20088 12/3/2015 13:02:39 20089 12/4/2015 13:15:24 20090 12/5/2015 15:18:40 20091 12/6/2015 12:15:02 20092 12/7/2015 13:20:02 20093 12/7/2015 12:58:33 20094 12/7/2015 08:00:33 20095 12/7/2015 13:27:41 20096 12/7/2015 14:50:42 20097 12/7/2015 16:42:47 20098 12/7/2015 15:22:13 20099 12/7/2015 08:55:28 20100 12/7/2015 09:04:34 20101 12/7/2015 09:20:06 20102 12/7/2015 16:07:28 20103 12/7/2015 11:38:53 20104 12/8/2015 15:21:01 20105 12/9/2015 08:48:59 20106 12/10/2015 14:36:26 20107 12/10/2015 11:42:13 20108 12/10/2015 11:26:09 20109 12/10/2015 14:17:25 20110 12/10/2015 15:43:57 20111 12/10/2015 10:14:00 Query1 E $2.328.24 $8,167.30 $19,501.61 $16,347.16 $14,079.82 $7.447.57 $19,517.71 $19,215.15 $9,367.23 $11,766.31 $14,180.12 $15,712.36 $2,100.50 $14,082.60 $10,131.77 $12,265.47 $11,601.16 $9,275.42 $6,154.50 $19,620.92 $15.937.89 $11,527.53 $11,000.00 $8,450.33 $18,405.26 $3,619.23 $18,645.75 $6,578.34 $18,093.13 $4,845.48 $6,242.81 $7.924.09 $8.658.08 $7,007.32 $3,520.91 $19,261.76 $6,565.19 $2,439.22 $19,727.30 $16,278.43 $13,013.14 $10,929.47 $11,609.49 $13,491.48 F B B B A B A B A B B B B A B A B B G 1131 1125 1132 1127 1137 1127 1138 1136 1121 1123 1125 1136 1135 1131 1131 1133 1127 1122 1128 1123 1138 1128 1128 1133 1129 1127 1127 1134 1135 1135 1136 1137 1130 1137 1131 1139 1130 1128 1126 1125 1127 1122 1131 1131 3150 12/10/2015 $8,450.33 V2 fic A H J L 113 114 115 116 117 3151 12/15/2015 $6,676.89 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 B 20110 12/10/2015 15:43:57 20111 12/10/2015 10:14:00 20112 12/10/2015 15:36:54 20113 12/10/2015 08:27:22 20114 12/10/2015 16:31:27 20115 12/10/2015 14:05:08 20116 12/10/2015 10:48:26 20117 12/10/2015 14:54:41 20118 12/10/2015 16:06:00 20119 12/11/2015 11:20:13 20120 12/12/2015 10:48:14 20121 12/14/2015 09:52:15 20122 12/15/2015 16:57:25 20123 12/15/2015 13:11:02 20124 12/15/2015 11:30:54 20125 12/15/2015 14:43:49 20126 12/15/2015 11:11:15 20127 12/15/2015 16:47:20 20128 12/15/2015 11:50:26 20129 12/15/2015 11:43:20 20130 12/15/2015 15:12:00 20131 12/15/2015 15:09:53 20132 12/15/2015 16:34:42 20133 12/15/2015 13:52:15 20134 12/16/2015 15:21:25 20135 12/17/2015 15:20:32 20136 12/17/2015 13:25:11 20137 12/17/2015 13:18:13 20138 12/17/2015 10:01:47 20139 12/17/2015 12:29:28 20140 12/17/2015 15:07:45 20141 12/17/2015 09:06:08 20142 12/17/2015 15:31:17 20143 12/17/2015 08:43:26 20144 12/17/2015 11:06:17 20145 12/17/2015 11:24:16 20146 12/18/2015 10:27:40 20147 12/18/2015 11:35:39 20148 12/18/2015 12:41:36 20149 12/18/2015 11:28:52 20150 12/18/2015 08:08:42 20151 12/18/2015 14:16:39 20152 12/18/2015 14:04:07 20153 12/18/2015 08:22:59 Query1 E $11,609.49 $13,491.48 $11,394.20 $18,722.71 $6,676.89 $15,522.17 $16,862.09 $9,720.17 $2,144.23 $20,000.00 $1,313.20 $12,001.03 $8,945.43 $10,651.88 $19,950.38 $8,249.02 $17,533.31 $11,001.68 $6,823.19 $12,139.93 $14,165.34 $4,154.50 $7,470.75 $4,883.66 $17,758.23 $17,531.37 $2,317.27 $18,830.85 $13,506.35 $4,127.72 $7,708.64 $19,838.53 $5,920.71 $2,713.66 $7,658.64 $13,572.72 $8,431.59 $17,274.08 $13.650.99 $2,929.79 $5,770.52 $16,060.28 $6,019.88 $13,855.02 B B B A B B B A B B B G 1131 1131 1136 1120 1122 1136 1123 1120 1140 1137 1133 1131 1131 1126 1128 1120 1128 1127 1130 1129 1124 1126 1131 1135 1123 1140 1139 1123 1130 1126 1120 1129 1133 1137 1122 1131 1131 1132 1125 1131 1127 1123 1131 1126 3152 12/18/2015 $2,713.66 B B B B A Select destination and press ENTER or choose Paste V2 Jx . J K 155 156 157 158 159 160 161 162 163 164 165 167 168 16 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 B 20152 12/18/2015 14:04:07 20153 12/18/2015 08:22:59 20154 12/18/2015 14:15:31 20155 12/18/2015 15:18:08 20156 12/18/2015 14:24:42 20157 12/18/2015 08:36:40 20158 12/18/2015 15:29:56 20159 12/21/2015 08:09:48 20160 12/21/2015 15:34:36 20161 12/21/2015 15:39:14 20162 12/21/2015 13:25:43 20163 12/21/2015 12:31:20 20164 124 2015 09:25:14 2016 12/25/2015 08:44:46 20166 12/28/2015 12:09:18 20167 12/28/2015 16:31:43 20168 12/28/2015 08:26:46 20169 12/29/2015 13:17:15 20170 12/29/2015 09:26:45 20171 12/29/2015 15:06:47 20172 12/29/2015 12:08:06 20173 12/29/2015 12:00:07 20174 12/29/2015 16:28:11 20175 12/29/2015 08:02:08 20176 12/29/2015 09:19:42 20177 12/30/2015 13:13:27 20178 12/30/2015 09:25:38 20179 12/30/2015 15:13:07 20180 12/30/2015 12:58:40 20181 12/30/2015 09:49:12 20182 12/30/2015 10:12:23 20183 12/30/2015 09:48:58 20184 12/30/2015 13:46:23 20185 12/30/2015 09:21:55 20186 12/30/2015 13:56:37 20187 12/31/2015 14:30:48 20188 12/31/2015 11:07:08 20189 12/31/2015 11:50:07 20190 12/31/2015 10:02:10 20191 12/31/2015 13:24:34 20192 12/31/2015 08:13:58 20193 12/31/2015 15:10:11 20194 12/31/2015 09:25:07 20195 12/31/2015 09:54:44 Query1 E S6,019.88 $13.855.02 $2,431.98 $15,554.61 S19,201.72 $7,863.56 $12,893.38 $9,211.68 $12.688.61 S5,231.75 $9,939.27 S6,246.39 $1,755.58 S8,665.86 $3,865.13 $13,545.34 $12.993.26 $6,857.84 $2.708.21 S19,706.56 $15,068.97 55.054.97 $6,724.03 $13,430.05 $5,777.13 S17,496.36 S3,475.16 S1,010.15 54.345.11 $6,650.05 $14.524.24 $9.814.08 $11,254.15 $12.913.63 $8.394.80 33,887.53 $52.570.33 S17,024.96 S76.855.56 S5,734.48 $12,055.12 $19.922.71 $13.271.91 S65,560.26 F A B B B B A B B B B B B A A A B A B A G 1131 1126 1134 1132 1135 1140 1124 1131 1136 1138 1125 1135 1121 1138 1130 1140 1137 1130 1121 1129 1133 1129 1126 1130 1122 1125 1129 1126 1127 1128 1133 1122 1122 1139 1139 1124 1136 1132 1133 1133 1129 1124 1120 1137 3153 1/4/2016 $13,430.05 3154 1/5/2016 S52,570.33 3155 18.2016 S65,560.26 V2 > fx D H | J L 182 183 184 185 186 187 188 189 190 191 3154 1/5/2016 $52,570.33 3155 1/8/2016 $65,560.26 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 B 20179 20180 20181 20182 20183 20184 20185 20186 20187 20188 20189 20190 20191 20192 20193 20194 20195 20196 20197 20198 20199 20200 20201 20202 20203 20204 20205 20206 20207 20208 20209 20210 20211 20212 20213 20214 20215 20216 20217 20218 C 12/30/2015 15:13:07 12/30/2015 12:58:40 12/30/2015 09:49:12 12/30/2015 10:12:23 12/30/2015 09:48:58 12/30/2015 13:46:23 12/30/2015 09:21:55 12/30/2015 13:56:37 12/31/2015 14:30:48 12/31/2015 11:07:08 12/31/2015 11:50:07 12/31/2015 10:02:10 12/31/2015 13:24:34 12/31/2015 08:13:58 12/31/2015 15:10:11 12/31/2015 09:25:07 12/31/2015 09:54:44 12/31/2015 10:14:32 12/31/2015 11:23:28 12/31/2015 12:41:08 12/31/2015 15:26:53 12/31/2015 13:14:22 12/31/2015 08:04:40 12/31/2015 15:49:03 12/31/2015 11:37:24 12/31/2015 08:47:40 12/31/2015 13:42:59 12/31/2015 12:48:42 12/31/2015 14:32:09 12/31/2015 09:57:43 12/31/2015 14:33:23 12/31/2015 11:49:20 12/31/2015 13:12:14 12/31/2015 16:37:34 12/31/2015 16:22:09 12/31/2015 16:59:59 12/31/2015 11:20:51 12/31/2015 13:19:13 12/31/2015 15:55:44 12/31/2015 15:28:05 E $1,010.15 $4,345.11 $6,650.05 $14,524.24 $9,814.08 $11,254.15 $12.913.63 $8.394.80 $3,887.53 $52,570.33 $17,024.96 $76,855.56 $5,734.48 $12,055.12 $18,922.71 $13,271.91 $65,560.26 $6,688.70 $2,992.18 $19,751.44 $9,597.51 $5,315.27 $127,981.66 $8,749.26 $6,216.79 $11,548.85 $10,057.62 $5,142.81 $5,070.24 $83,751.99 $18,465.39 $1,928.34 $19,734.02 $14,864.40 $177,995.38 $66,251.33 $16.209.47 $11,146.17 $8,775.79 $19,790.05 LOOCOOMUUUUUUUUUUUUUUU 1126 1127 1128 1133 1122 1122 1139 1139 1124 1136 1132 1133 1133 1129 1124 1120 1137 1131 1126 1138 1134 1131 1127 1123 1128 1131 1122 1135 1134 1136 1128 1132 1123 1139 1137 1124 1125 1134 1130 1139 3156 1/12/2016 $83,751.99 3157 1/13/2016 $177,995.38 217 218 219 220 221 222 223 224 225 Query1 Colostdoctisatie Clipboard Font is Alignment V2 fr A B C D F G . J K E Homework Case: The following data are downloaded from sales module of a company's ERP system. The ERP system automatically recognizes sales and posts the journal entry "DR AR CR Sales" to general ledger when an invoice is created. Sales personnel are responsible of creating invoices after shipping labels are printed from shipping department. Shipping labels are printed when carriers are booked and the products are ready to be shipped to customers. The times and dates for all sales are automatically recorded by the ERP system when the sale is complete (inovice generated). All sales 1 over $20.000 must be authorized by a senior manager before the sale can be entered into the system. Requirements: Please use Excel functions to find as many fraud red flags as possible. Please create new tab to list the flagged items with a brief explanation as why these items deserve further attentions and/or investigations. You may further elaborate on the possible motivations behind frauster and what they intend to achieve by creating such misleading information, how they may be benefited from such actitivties. Please use at least two excel funcitons in your analysis: filter and pivot table. Please create at least 3 new tabs in the following 3 suspicious areas: invoice generated 2 date, credit memos, and invoice amounts. Credit Date Credit Amount 4 Salesperson A 5 11/7/2015 $14,768.82 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 Invoice Sale Date Sale Time Number 20001 11/2/2015 13:31:28 20002 11/2/2015 13:41:33 20003 11/2/2015 15:19:56 20004 11/2/2015 16:26:52 20005 11/2/2015 16:01:22 20006 11/2/2015 09:24:38 20007 11/2/2015 11:03:18 20008 11/2/2015 15:46:55 20009 11/2/2015 09:52:03 20010 11/2/2015 10:37:37 20011 11/2/2015 09:21:39 20012 11/2/2015 13:15:29 20013 11/2/2015 10:13:52 20014 11/2/2015 16:01:19 20015 11/2/2015 13:45:07 20016 11/12/2015 13:03:29 20017 11/12/2015 14:54:29 20018 11/3/2015 09:59:28 20019 11/3/2015 12:48:32 20020 11/3/2015 13:50:00 20021 11/6/2015 21:50:01 20022 11/6/2015 09:12:09 20023 11/6/2015 08:49:04 20024 11/9/2015 16:09:15 20025 11/9/2015 15:56:03 20026 11/9/2015 16:36:17 Query1 Sale Amount $8,090.03 $19,166.57 $6,269.27 $13,361.81 $9.216.60 $11,528.98 $19,000.00 $9,579.46 $14.768.82 $8.733.64 $18,992.28 $12,019.59 $51,394.33 $7,922.47 $35,896.57 $10,308.75 $19,900.00 $20,000.00 $12,406.18 $7,242.38 $17,490.62 $12,852.28 $12,636.12 $7,691.13 $11.976.10 $9,615.38 B B B A A B B B Customer Credit Memo Number Number 1124 1131 1127 1132 1140 1137 1123 1120 1129 3145 1128 1131 1124 1126 1138 1138 1137 1123 1133 1130 1128 3146 1123 1122 1140 1121 1122 1120 11/9/2015 $7,242.38 V2 fic A . J L F A B B B E $7,691.13 $11,976.10 $9,615.38 $11,746.38 $11,869.73 $7,268.23 $8,596.85 $8,481.82 $9,202.38 $11,433.28 $7,368.18 $10,526.33 $12,739.12 $22,279.29 $8,642.30 $10,156.87 $33.944.90 $9,254.25 $23,024.87 $12.989.18 $10,647.12 $13,339.77 $12,740.33 $9,013.10 $12,161.29 $16,095.11 $8,065.38 $12,640.85 $10,189.61 $10,095.27 $8,572.98 $9.108.29 $15,878.98 $4,193.80 $15,341.83 $10,196.52 $11,661.46 $10,758.88 $6.289.17 $9,873.70 $5,157.19 $16,752.49 $8,890.23 $2,328.24 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 3147 11/19/2015 B 20024 11/9/2015 16:09:15 20025 11/9/2015 15:56:03 20026 11/9/2015 16:36:17 20027 11/9/2015 11:15:21 20028 11/9/2015 13:24:57 20029 11/9/2015 14:40:00 20030 11/9/2015 10:26:11 20031 11/10/2015 15:19:42 20032 11/10/2015 11:19:07 20033 11/10/2015 15:49:12 20034 11/10/2015 12:57:16 20035 11/10/2015 12:58:52 20036 11/10/2015 16:52:50 20037 11/10/2015 14:57:42 20038 11/10/2015 08:18:30 20039 11/10/2015 12:31:05 20040 11/10/2015 16:45:09 20041 11/10/2015 11:59:35 20042 11/10/2015 15:14:08 20043 11/10/2015 14:53:19 20044 11/13/2015 11:50:15 20045 11/13/2015 16:03:49 20046 11/13/2015 16:46:06 20047 11/16/2015 08:58:28 20048 11/17/2015 10:50:28 20049 11/17/2015 11:58:58 20050 11/17/2015 12:42:27 20051 11/18/2015 14:27:40 20052 11/18/2015 08:47:27 20053 11/18/2015 12:40:34 20054 11/18/2015 12:29:54 20055 11/18/2015 09:39:16 20056 11/18/2015 12:28:35 20058 11/18/2015 16:33:14 20059 11/18/2015 12:46:28 20060 11/18/2015 08:44:16 20061 11/18/2015 10:11:15 20062 11/18/2015 12:37:52 20063 11/18/2015 14:26:14 20064 11/18/2015 11:22:32 20065 11/23/2015 14:40:52 20066 11/23/2015 16:33:15 20067 11/23/2015 15:37:23 20068 11/23/2015 14:58:59 Query1 G 1121 1122 1120 1138 1123 1139 1130 1128 1125 1132 1127 1126 1132 1130 1121 1136 1139 1132 1133 1134 1121 1133 1140 1122 1137 1137 1133 1135 1122 1139 1131 1128 1128 1122 1137 1139 1139 1131 1138 1121 1127 1132 1122 1131 $13,339.77 B B B B B A A B B A A B B B Select destination and press ENTER or choose Paste Clipboard Font Alignment NU V2 fx A B D H | J L M 3148 11/27/2015 $16,347.16 3149 12/4/2015 56,154.50 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 20068 11/23/2015 14:58:59 20069 11/23/2015 11:59:15 20070 11/23/2015 15:41:09 20071 11/23/2015 11:53:21 20072 11/23/2015 10:24:09 20073 11/23/2015 09:56:26 20074 11/23/2015 08:45:30 20075 11/23/2015 15:45:53 20076 11/23/2015 08:03:35 20077 11/23/2015 16:39:52 20078 11/23/2015 11:29:28 20079 11/24/2015 11:40:57 20080 11/23/2015 15:42:01 20081 11/23/2015 13:32:53 20082 11/27/2015 15:45:10 20083 11/27/2015 13:14:14 20084 11/29/2015 16:45:18 20085 11/30/2015 10:20:23 20086 12/1/2015 16:32:05 20087 12/2/2015 23:59:20 20088 12/3/2015 13:02:39 20089 12/4/2015 13:15:24 20090 12/5/2015 15:18:40 20091 12/6/2015 12:15:02 20092 12/7/2015 13:20:02 20093 12/7/2015 12:58:33 20094 12/7/2015 08:00:33 20095 12/7/2015 13:27:41 20096 12/7/2015 14:50:42 20097 12/7/2015 16:42:47 20098 12/7/2015 15:22:13 20099 12/7/2015 08:55:28 20100 12/7/2015 09:04:34 20101 12/7/2015 09:20:06 20102 12/7/2015 16:07:28 20103 12/7/2015 11:38:53 20104 12/8/2015 15:21:01 20105 12/9/2015 08:48:59 20106 12/10/2015 14:36:26 20107 12/10/2015 11:42:13 20108 12/10/2015 11:26:09 20109 12/10/2015 14:17:25 20110 12/10/2015 15:43:57 20111 12/10/2015 10:14:00 Query1 E $2.328.24 $8,167.30 $19,501.61 $16,347.16 $14,079.82 $7.447.57 $19,517.71 $19,215.15 $9,367.23 $11,766.31 $14,180.12 $15,712.36 $2,100.50 $14,082.60 $10,131.77 $12,265.47 $11,601.16 $9,275.42 $6,154.50 $19,620.92 $15.937.89 $11,527.53 $11,000.00 $8,450.33 $18,405.26 $3,619.23 $18,645.75 $6,578.34 $18,093.13 $4,845.48 $6,242.81 $7.924.09 $8.658.08 $7,007.32 $3,520.91 $19,261.76 $6,565.19 $2,439.22 $19,727.30 $16,278.43 $13,013.14 $10,929.47 $11,609.49 $13,491.48 F B B B A B A B A B B B B A B A B B G 1131 1125 1132 1127 1137 1127 1138 1136 1121 1123 1125 1136 1135 1131 1131 1133 1127 1122 1128 1123 1138 1128 1128 1133 1129 1127 1127 1134 1135 1135 1136 1137 1130 1137 1131 1139 1130 1128 1126 1125 1127 1122 1131 1131 3150 12/10/2015 $8,450.33 V2 fic A H J L 113 114 115 116 117 3151 12/15/2015 $6,676.89 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 B 20110 12/10/2015 15:43:57 20111 12/10/2015 10:14:00 20112 12/10/2015 15:36:54 20113 12/10/2015 08:27:22 20114 12/10/2015 16:31:27 20115 12/10/2015 14:05:08 20116 12/10/2015 10:48:26 20117 12/10/2015 14:54:41 20118 12/10/2015 16:06:00 20119 12/11/2015 11:20:13 20120 12/12/2015 10:48:14 20121 12/14/2015 09:52:15 20122 12/15/2015 16:57:25 20123 12/15/2015 13:11:02 20124 12/15/2015 11:30:54 20125 12/15/2015 14:43:49 20126 12/15/2015 11:11:15 20127 12/15/2015 16:47:20 20128 12/15/2015 11:50:26 20129 12/15/2015 11:43:20 20130 12/15/2015 15:12:00 20131 12/15/2015 15:09:53 20132 12/15/2015 16:34:42 20133 12/15/2015 13:52:15 20134 12/16/2015 15:21:25 20135 12/17/2015 15:20:32 20136 12/17/2015 13:25:11 20137 12/17/2015 13:18:13 20138 12/17/2015 10:01:47 20139 12/17/2015 12:29:28 20140 12/17/2015 15:07:45 20141 12/17/2015 09:06:08 20142 12/17/2015 15:31:17 20143 12/17/2015 08:43:26 20144 12/17/2015 11:06:17 20145 12/17/2015 11:24:16 20146 12/18/2015 10:27:40 20147 12/18/2015 11:35:39 20148 12/18/2015 12:41:36 20149 12/18/2015 11:28:52 20150 12/18/2015 08:08:42 20151 12/18/2015 14:16:39 20152 12/18/2015 14:04:07 20153 12/18/2015 08:22:59 Query1 E $11,609.49 $13,491.48 $11,394.20 $18,722.71 $6,676.89 $15,522.17 $16,862.09 $9,720.17 $2,144.23 $20,000.00 $1,313.20 $12,001.03 $8,945.43 $10,651.88 $19,950.38 $8,249.02 $17,533.31 $11,001.68 $6,823.19 $12,139.93 $14,165.34 $4,154.50 $7,470.75 $4,883.66 $17,758.23 $17,531.37 $2,317.27 $18,830.85 $13,506.35 $4,127.72 $7,708.64 $19,838.53 $5,920.71 $2,713.66 $7,658.64 $13,572.72 $8,431.59 $17,274.08 $13.650.99 $2,929.79 $5,770.52 $16,060.28 $6,019.88 $13,855.02 B B B A B B B A B B B G 1131 1131 1136 1120 1122 1136 1123 1120 1140 1137 1133 1131 1131 1126 1128 1120 1128 1127 1130 1129 1124 1126 1131 1135 1123 1140 1139 1123 1130 1126 1120 1129 1133 1137 1122 1131 1131 1132 1125 1131 1127 1123 1131 1126 3152 12/18/2015 $2,713.66 B B B B A Select destination and press ENTER or choose Paste V2 Jx . J K 155 156 157 158 159 160 161 162 163 164 165 167 168 16 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 B 20152 12/18/2015 14:04:07 20153 12/18/2015 08:22:59 20154 12/18/2015 14:15:31 20155 12/18/2015 15:18:08 20156 12/18/2015 14:24:42 20157 12/18/2015 08:36:40 20158 12/18/2015 15:29:56 20159 12/21/2015 08:09:48 20160 12/21/2015 15:34:36 20161 12/21/2015 15:39:14 20162 12/21/2015 13:25:43 20163 12/21/2015 12:31:20 20164 124 2015 09:25:14 2016 12/25/2015 08:44:46 20166 12/28/2015 12:09:18 20167 12/28/2015 16:31:43 20168 12/28/2015 08:26:46 20169 12/29/2015 13:17:15 20170 12/29/2015 09:26:45 20171 12/29/2015 15:06:47 20172 12/29/2015 12:08:06 20173 12/29/2015 12:00:07 20174 12/29/2015 16:28:11 20175 12/29/2015 08:02:08 20176 12/29/2015 09:19:42 20177 12/30/2015 13:13:27 20178 12/30/2015 09:25:38 20179 12/30/2015 15:13:07 20180 12/30/2015 12:58:40 20181 12/30/2015 09:49:12 20182 12/30/2015 10:12:23 20183 12/30/2015 09:48:58 20184 12/30/2015 13:46:23 20185 12/30/2015 09:21:55 20186 12/30/2015 13:56:37 20187 12/31/2015 14:30:48 20188 12/31/2015 11:07:08 20189 12/31/2015 11:50:07 20190 12/31/2015 10:02:10 20191 12/31/2015 13:24:34 20192 12/31/2015 08:13:58 20193 12/31/2015 15:10:11 20194 12/31/2015 09:25:07 20195 12/31/2015 09:54:44 Query1 E S6,019.88 $13.855.02 $2,431.98 $15,554.61 S19,201.72 $7,863.56 $12,893.38 $9,211.68 $12.688.61 S5,231.75 $9,939.27 S6,246.39 $1,755.58 S8,665.86 $3,865.13 $13,545.34 $12.993.26 $6,857.84 $2.708.21 S19,706.56 $15,068.97 55.054.97 $6,724.03 $13,430.05 $5,777.13 S17,496.36 S3,475.16 S1,010.15 54.345.11 $6,650.05 $14.524.24 $9.814.08 $11,254.15 $12.913.63 $8.394.80 33,887.53 $52.570.33 S17,024.96 S76.855.56 S5,734.48 $12,055.12 $19.922.71 $13.271.91 S65,560.26 F A B B B B A B B B B B B A A A B A B A G 1131 1126 1134 1132 1135 1140 1124 1131 1136 1138 1125 1135 1121 1138 1130 1140 1137 1130 1121 1129 1133 1129 1126 1130 1122 1125 1129 1126 1127 1128 1133 1122 1122 1139 1139 1124 1136 1132 1133 1133 1129 1124 1120 1137 3153 1/4/2016 $13,430.05 3154 1/5/2016 S52,570.33 3155 18.2016 S65,560.26 V2 > fx D H | J L 182 183 184 185 186 187 188 189 190 191 3154 1/5/2016 $52,570.33 3155 1/8/2016 $65,560.26 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 B 20179 20180 20181 20182 20183 20184 20185 20186 20187 20188 20189 20190 20191 20192 20193 20194 20195 20196 20197 20198 20199 20200 20201 20202 20203 20204 20205 20206 20207 20208 20209 20210 20211 20212 20213 20214 20215 20216 20217 20218 C 12/30/2015 15:13:07 12/30/2015 12:58:40 12/30/2015 09:49:12 12/30/2015 10:12:23 12/30/2015 09:48:58 12/30/2015 13:46:23 12/30/2015 09:21:55 12/30/2015 13:56:37 12/31/2015 14:30:48 12/31/2015 11:07:08 12/31/2015 11:50:07 12/31/2015 10:02:10 12/31/2015 13:24:34 12/31/2015 08:13:58 12/31/2015 15:10:11 12/31/2015 09:25:07 12/31/2015 09:54:44 12/31/2015 10:14:32 12/31/2015 11:23:28 12/31/2015 12:41:08 12/31/2015 15:26:53 12/31/2015 13:14:22 12/31/2015 08:04:40 12/31/2015 15:49:03 12/31/2015 11:37:24 12/31/2015 08:47:40 12/31/2015 13:42:59 12/31/2015 12:48:42 12/31/2015 14:32:09 12/31/2015 09:57:43 12/31/2015 14:33:23 12/31/2015 11:49:20 12/31/2015 13:12:14 12/31/2015 16:37:34 12/31/2015 16:22:09 12/31/2015 16:59:59 12/31/2015 11:20:51 12/31/2015 13:19:13 12/31/2015 15:55:44 12/31/2015 15:28:05 E $1,010.15 $4,345.11 $6,650.05 $14,524.24 $9,814.08 $11,254.15 $12.913.63 $8.394.80 $3,887.53 $52,570.33 $17,024.96 $76,855.56 $5,734.48 $12,055.12 $18,922.71 $13,271.91 $65,560.26 $6,688.70 $2,992.18 $19,751.44 $9,597.51 $5,315.27 $127,981.66 $8,749.26 $6,216.79 $11,548.85 $10,057.62 $5,142.81 $5,070.24 $83,751.99 $18,465.39 $1,928.34 $19,734.02 $14,864.40 $177,995.38 $66,251.33 $16.209.47 $11,146.17 $8,775.79 $19,790.05 LOOCOOMUUUUUUUUUUUUUUU 1126 1127 1128 1133 1122 1122 1139 1139 1124 1136 1132 1133 1133 1129 1124 1120 1137 1131 1126 1138 1134 1131 1127 1123 1128 1131 1122 1135 1134 1136 1128 1132 1123 1139 1137 1124 1125 1134 1130 1139 3156 1/12/2016 $83,751.99 3157 1/13/2016 $177,995.38 217 218 219 220 221 222 223 224 225 Query1 Colostdoctisatie