tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 212296d1360088369-spend-based-on-region-and-atttributes-challenge-excel-help
Sheet: Sheet1

 | Input Sheet |  |  |  |  | Main sheet
 | Vendor | Spend | Country |  |  | Step 1 |  |  |  |  |  |  |  | Step 2 |  |  | Step 3 my problem
 | [NAME] | 12 | Sweden |  |  | Suppliers | [NAME] | Spend | Groping | Assign attribute | Unique | Spend |  | Countries | Regions
 | Banana1 | 10 | Sweden |  |  |  |  |  |  |  |  |  |  |  |  |  | EU
 | banana | 2 | USA |  |  | [NAME] | [NAME] | 14 | [NAME] | Old | [NAME] | 24 |  | Sweden | EU |  | North. A
 | Grape2 | 3 | USA |  |  | Banana1 | Banana1 | 10 | [NAME] | Old | Grape | 102 |  | USA | North. A |  | Asia
 | Grape | 24 | Portugal |  |  | banana | Grape2 | 3 | Grape | New | Apple | 272 |  | Portugal | EU
 | Grape | 53 | USA |  |  | Grape2 | Grape | 77 | Grape | New |  |  |  | Norway | EU
 | Grape17 | 22 | Portugal |  |  | Grape | Grape17 | 22 | Grape | New |  |  |  | China | Asia
 | Apple | 245 | Norway |  |  | Grape | Apple | 248 | Apple | New
 | Apple | 3 | USA |  |  | Grape17 | Orange | 24 | Apple | New
 | Orange | 24 | China |  |  | Apple
 |  |  |  |  |  | Apple
 | This is a bacis view of my input |  |  |  |  | Orange
 | and its it not fixed values
 | they will change on a monthyly basis |  |  |  | 1 | As a begining i find the unique supplier and |  |  |  |  |  |  | 2 | i group the countries by region |  | 3 | I need to find the regional spend
 |  |  |  |  |  | group them  based on their "skills" |  |  |  |  |  |  |  |  |  |  | But problem is that it have to be devided into groups based on
 |  |  |  |  |  | And assign an attribute |  |  |  |  |  |  |  |  |  |  | the assignd attribute of the supplier
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | This means that when looking at the North.A Spend, i will have
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | to be able to devide the spend based on the attribute
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ex. New =25 Old = 75 %
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Based on my limited input iam having a hard time trying
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | to figure out how to used theese nessary groupings
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | efficietly, and how to retirve my regional ratios based on Attribute
Spreadsheet: 842352d1694456709-count-of-occurrences-count-tms
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | C010
 |  | Equipment Code | Start Date | Finish date | Calculated Finish |  | 1st Date range | 2023-08-01 00:00:00 | 2023-08-10 00:00:00
 |  | C010 | 2023-08-05 08:50:00 | 2023-08-05 09:10:00
 |  | C010 | 2023-08-07 10:00:00 | 2023-08-07 11:00:00 |  |  | Count
 |  | C010 | 2023-08-12 09:00:00 | 2023-08-12 11:30:00
 |  | C010 | 2023-08-14 13:43:00 | 2023-08-14 14:25:00
 |  | C010 | 2023-08-26 09:30:00 | 2023-08-26 10:20:00
 |  | C010 | 2023-08-30 16:57:00 | 2023-08-30 17:17:00 |  |  | 2nd Date range | 2023-08-20 00:00:00 | 2023-09-11 00:00:00
 |  | C010 | 2023-09-06 08:35:00 | 2023-09-06 09:04:00
 |  | C010 | 2023-09-08 14:26:00 |  |  |  | Count |  |  | Number expected 4 | based on start date
Spreadsheet: 833156d1686820521-if-statement-uses-more-than-64-levels-of-nesting-book1
Sheet: Sheet1

0 | 8
1 | 9 |  |  |  | 4
2 | 11 |  |  |  | 34
3 | 13 |  |  |  | 66
4 | 13
5 | 14
6 | 16
7 | 19
8 | 19
9 | 21
10 | 22
11 | 27
12 | 28
13 | 29
14 | 30
15 | 31
16 | 32
17 | 33
18 | 34
19 | 35
20 | 36
21 | 37
22 | 38
23 | 39
24 | 40
25 | 41
26 | 42
27 | 43
28 | 44
29 | 45
30 | 46
31 | 47
32 | 48
33 | 49
34 | 50
35 | 51
36 | 52
37 | 53
38 | 54
39 | 55
40 | 56
41 | 57
42 | 58
43 | 59
44 | 60
45 | 61
46 | 62
47 | 63
48 | 64
49 | 65
50 | 66
51 | 67
52 | 68
53 | 69
54 | 70
55 | 71
56 | 72
57 | 73
58 | 74
59 | 75
60 | 76
61 | 77
62 | 78
63 | 79
64 | 80
65 | 81
66 | 82
67 | 83
68 | 84
69 | 85
70 | 86
71 | 87
72 | 88
73 | 89
74 | 90
75 | 91
76 | 92
77 | 93
78 | 94
79 | 95
80 | 96
81 | 97
82 | 98
83 | 99
84 | 100
85 | 101
86 | 102
87 | 103
88 | 104
89 | 105
90 | 106
91 | 107
92 | 108
93 | 109
94 | 110
95 | 111
96 | 112
97 | 113
98 | 114
99 | 115
100 | 116
101 | 117
102 | 118
103 | 119
104 | 120
105 | 121
106 | 122
107 | 123
108 | 124
109 | 125
110 | 126
111 | 127
112 | 128
113 | 129
114 | 130
115 | 131
116 | 132
117 | 133
118 | 134
119 | 135
120 | 136
121 | 137
122 | 138
123 | 139
124 | 140
125 | 141
126 | 142
127 | 143
128 | 144
129 | 145
130 | 146
131 | 147
132 | 148
133 | 149
134 | 150
135 | 151
136 | 152
137 | 153
138 | 154
139 | 155
140 | 156
141 | 157
142 | 158
143 | 159
144 | 160
145 | 161
146 | 162
147 | 163
148 | 164
149 | 165
150 | 166
151 | 167
152 | 168
153 | 169
154 | 170
155 | 171
156 | 172
157 | 173
158 | 174
159 | 175
160 | 176
161 | 177
162 | 178
163 | 179
164 | 180
165 | 181
166 | 182
167 | 183
168 | 184
169 | 185
170 | 186
171 | 187
172 | 188
173 | 189
174 | 190
175 | 191
176 | 192
177 | 193
178 | 194
179 | 195
180 | 196
181 | 197
182 | 198
183 | 199
184 | 200
185 | 201
186 | 202
187 | 203
188 | 204
189 | 205
190 | 206
191 | 207
192 | 208
193 | 209
194 | 210
195 | 211
196 | 212
197 | 213
198 | 214
199 | 215
200 | 216
Spreadsheet: 850158d1700541151-formula-for-identify-top-75-percentage-and-its-average-top-75
Sheet: Sheet1

DIV | NUM | PRICE | CONTRI | SUM | average
AA | 1 | 2.2305761 | 0.25
AA | 2 | 1.9826327 | 0.1128001311022451
AA | 3 | 1.5937878 | 0.0906771449846251
AA | 4 | 1.3153554 | 0.0748359802428589
AA | 5 | 1.0388263 | 0.12
AA | 6 | 0.8675439 | 0.04
AA | 7 | 0.6685939 | 0.07
AA | 8 | 0.5918046 | 0.03069004492848541
AA | 9 | 0.5394239 | 0.03069004492848541
AA | 10 | 0.5176282 | 0.02944999788524578
AA | 11 | 0.5096999 | 0.02899892428022659
AA | 12 | 0.4879966 | 0.02776413425313213
AA | 13 | 0.4669618 | 0.0265673779413304
AA | 14 | 0.3817897 | 0.02172158676364352
AA | 15 | 0.376922 | 0.02144464328431606
AA | 16 | 0.3234115 | 0.02
DIV | NUM | PRICE | CONTRI | SUM | average
BB | 1 | 2.2305761 | 0.1269066511984466
BB | 2 | 1.9826327 | 0.1128001311022451
BB | 3 | 1.5937878 | 0.0906771449846251
BB | 4 | 1.3153554 | 0.0748359802428589
BB | 5 | 1.0388263 | 0.05910310206850727
BB | 6 | 0.9933398 | 0.05651518794634926
BB | 7 | 0.8675439 | 0.09
BB | 8 | 0.6685939 | 0.1
BB | 9 | 0.5918046 | 0.03367019845224569
BB | 10 | 0.5394239 | 0.01
BB | 11 | 0.5176282 | 0.04
BB | 12 | 0.5096999 | 0.02899892428022659
BB | 13 | 0.4879966 | 0.02776413425313213
BB | 14 | 0.4669618 | 0.0265673779413304
BB | 15 | 0.3817897 | 0.02172158676364352
BB | 16 | 0.376922 | 0.02144464328431606
BB | 17 | 0.3284382 | 0.01868620043389044
BB | 18 | 0.3284382 | 0.04
BB | 19 | 0.3284382 | 0.01868620043389044
Spreadsheet: 863904d1711300910-ifs-function-problem-tax-bracket-dj
Sheet: Sheet1

Not working [NAME]
Tax Bracket | Lower | Upper | Amount to Tax | Actual Amount | Before Deduction Tax | After Standard Deduction | Total Tax | Effective Rate
0.1 | 0 | 16550
0.12 |  | 63100
0.22 |  | 100500
0.24 | 100500 | 191950
0.32 |  | 243700 |  |  | 0
0.35 |  | 609350 |  |  | 0
0.37 |  | 1000000 |  |  | 0
 | TOTAL |  |  | 124734.33
Manual
Tax Bracket | Lower | Upper | Amount to Tax | Actual Amount | Before Deduction Tax | After Standard Deduction | Total Tax | Effective Rate
0.1 | 0 | 16550
0.12 |  | 63100
0.22 |  | 100500
0.24 | 100500 | 191950 |  |  |  |  |  |  | <---------- | I manually just put in cell E23 ( E27-C23)  to get the result I need. I want the IFS formula above to be able to evalute it and automatically update it. Thanks!
0.32 |  | 243700 |  |  | 0
0.35 |  | 609350 |  |  | 0
0.37 |  | 1000000 |  |  | 0
 | TOTAL |  |  | 124734.33
Spreadsheet: 163930d1340553166-index-and-match-formula-help-table-help
Sheet: Sheet1

Table 1 |  |  | Table 2
Name | Number |  | Name | Number | Selection
[NAME] | 3.05 |  | [NAME] | 3.05 | 1
[NAME] | 3
[NAME] | 2.98
[NAME] | 3.01 |  | Duplicate Table 2's
[NAME] | 2.96
Delia | 2.9 |  | Name | Number | Selection
Elsie | 2.9 |  | [NAME] | 3.01 | 2
George | 2.9
[NAME] | 2.875 |  | Name | Number | Selection
[NAME] | 2.9 |  | [NAME] | 3 | 3
Rose | 3
Winifred | 2.9 |  | Name | Number | Selection
Cecil | 2.875 |  | Rose | 3 | 4
Mable | 2.87
Godfrey | 2.88
Sid | 2.88
Reginald | 2.875
[NAME] | 2.86
[NAME] | 2.9
[NAME] | 3
Spreadsheet: 221619d1363625854-conditional-formatting-highlight-all-rows-in-table-with-error-in-any-cell-pm2a-beneficiary-data-_excel-forum_3-18-2013
Sheet: Distribution List Generator

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | District | Chiefdom
 | 1 | Select the District from the dropdown list to the right |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
 |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Kailahun | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bombali | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Penguia
 | 2 | Select all relevent chiefdoms from the dropdown lists to the right |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Peje West
 |  |  |  | [NAME] |  | Penguia |  | Sanda Loko |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sanda Loko
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | 3 | Press the button to generate your list
Spreadsheet: 762510d1641584777-lookup-multiple-criteria-multiple-results-excel-q
Sheet: Denver_P6

Denver DC
Zone | Attendees | Global ID | Position | [NAME] | Needs Room | RoomNight
[NAME] | [NAME] | 80058369 | RSA
 | [NAME] |  | RSA
COS
Ft. Collins | [NAME] |  | RSS |  | Yes | 3
 | [NAME] |  | RSS |  | Yes | 2
 | [NAME] |  | RSS |  | Yes | 2
 | [NAME] |  | CSS |  | Yes | 2
 | [NAME] |  | CSS |  | NO | 2
 | [NAME] |  | RSS |  |  | 2
New Mexico
El Paso
Shoemaker
Spreadsheet: 879231d1726674574-calculate-hours-and-minutes-using-military-time-that-might-be-different-dates-arrival_discharge-time
Sheet: Sheet1

[NAME] | [NAME] | Disch Date | Disch Time | Time in UC/ED  (h:[NAME])
2024-01-09 00:00:00 | 15:31:00 | 2024-01-10 00:00:00 | 15:39:00
2024-01-10 00:00:00 | 08:57:00 | 2024-01-11 00:00:00 | 09:05:00
2024-01-16 00:00:00 | 18:58:00 | 2024-01-16 00:00:00 | 20:25:00
2024-01-18 00:00:00 | 00:14:00 | 2024-01-18 00:00:00 | 00:51:00
Spreadsheet: 83507d12-d077-4666-b890-4a3ddc0cc795
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FBEN | Test | FBEN | Benzene, Occupational Exposure, Blood | Benzene, Blood | Headspace Gas Chromatography/Flame Ionization Detection (GC-FID) | Green-Top Tube (Sodium Heparin): GrnNaHp |  |  | 20 | mL | Draw blood in a green-top (sodium heparin) tube(s) and send 20 mL in two tubes of sodium heparin whole blood refrigerated. Blood should be drawn at end of shift. Tubes should be filled to prevent loss of volatile compound into headspace. | 2.5 mL (in two tubes) | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA | Units:	mg/L   Normal (unexposed population): None detected Exposed (end-of-shift): Blood benzene concentrations of greater than 0.1 mg/L correlate with exposure to greater than 10 ppm benzene in air. Toxic: Blood benzene concentrations greater than 0.90 mg/L have been observed in fatal cases of benzene exposure.      Test Performed By:	Medtox Laboratories 402 W. County Road D St. Paul, MN  55112 | Monday through Sunday | 7 days | 9 - 11 days | 1 | 84600 |  |  |  |  | Medtox Laboratories, Inc.
FBEN | [NAME] | WBNAH | WB Sodium Heparin |  |  |  | Refrigerated | 14 days
FBEN | Result | Z1153 | Benzene | Benzene | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 85219d1285255809-extract-data-across-multiple-columns-data-across-columns-example
Sheet: Sheet1

Name | On FS01 | On FS02 | On FS03 | On FS04 | On FS05 |  | Deleted | Access | [NAME]
Name | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Server | Deleted | Access | [NAME] | [NAME] (2 Columns; non N/A) | [NAME] (all Columns)
04-xxxxxx | #N/A | #N/A | 2010-09-22 08:48:49 | #N/A | 00:00:00 | aklmafs03.xxxx.net
04-xxxxxx | #N/A | #N/A | 2010-09-22 08:48:49 | #N/A | 00:00:00 | aklmafs05.xxxx.net
04Sxxxxxx | #N/A | #N/A | 00:00:00 | #N/A | 2010-09-22 04:30:34 | aklmafs03.xxxx.net
04Sxxxxxx | #N/A | #N/A | 00:00:00 | #N/A | 2010-09-22 04:30:34 | aklmafs05.xxxx.net
07xxxxxxx | #N/A | #N/A | 2010-09-09 13:20:34 | #N/A | 2010-09-09 12:03:17 | aklmafs03.xxxx.net
07xxxxxxx | #N/A | #N/A | 2010-09-09 13:20:34 | #N/A | 2010-09-09 12:03:17 | aklmafs05.xxxx.net
07Jxxxxxx | #N/A | #N/A | 2010-09-13 11:29:42 | #N/A | 2010-09-17 15:18:14 | aklmafs03.xxxx.net
07Jxxxxxx | #N/A | #N/A | 2010-09-13 11:29:42 | #N/A | 2010-09-17 15:18:14 | aklmafs05.xxxx.net
07Axxxxxx | #N/A | #N/A | 2010-09-13 15:32:21 | #N/A | 2010-09-17 10:38:08 | aklmafs03.xxxx.net
07Axxxxxx | #N/A | #N/A | 2010-09-13 15:32:21 | #N/A | 2010-09-17 10:38:08 | aklmafs03.xxxx.net
07Axxxxxx | #N/A | #N/A | 2010-09-13 15:32:21 | #N/A | 2010-09-17 10:38:08 | aklmafs05.xxxx.net
07Bxxxxxx | #N/A | #N/A | 2010-09-13 16:00:51 | #N/A | 2010-09-13 14:12:46 | aklmafs03.xxxx.net
07Bxxxxxx | #N/A | #N/A | 2010-09-13 16:00:51 | #N/A | 2010-09-13 14:12:46 | aklmafs05.xxxx.net
07Cxxxxxx | #N/A | #N/A | 2010-08-26 12:12:51 | #N/A | 2010-09-22 06:52:46 | aklmafs03.xxxx.net
07Cxxxxxx | #N/A | #N/A | 2010-08-26 12:12:51 | #N/A | 2010-09-22 06:52:46 | aklmafs05.xxxx.net
07Qxxxxxx | #N/A | #N/A | 2010-08-30 13:14:24 | #N/A | 2010-09-21 16:29:55 | aklmafs03.xxxx.net
07Qxxxxxx | #N/A | #N/A | 2010-08-30 13:14:24 | #N/A | 2010-09-21 16:29:55 | aklmafs05.xxxx.net
11Mxxxxxx | #N/A | #N/A | #N/A | #N/A | 2010-09-22 06:56:17 | aklmafs05.xxxx.net
11Mxxxxxx | #N/A | #N/A | #N/A | #N/A | 2010-09-22 06:56:17 | aklmafs05.xxxx.net
11MZxxxxx | #N/A | #N/A | 00:00:00 | #N/A | 2010-09-22 05:59:45 | aklmafs03.xxxx.net
11MZxxxxx | #N/A | #N/A | 00:00:00 | #N/A | 2010-09-22 05:59:45 | aklmafs05.xxxx.net
19DZxxxxx | #N/A | #N/A | 00:00:00 | #N/A | 2010-09-14 13:36:20 | aklmafs03.xxxx.net
19DZxxxxx | #N/A | #N/A | 00:00:00 | #N/A | 2010-09-14 13:36:20 | aklmafs05.xxxx.net
Spreadsheet: 876351d1723038549-if-function-returning-information-from-cell-with-formula-stock-ex
Sheet: Stock 1

Name |  |  | Description | Stock On Hand | Program | [NAME] | [NAME]
ALOY0001K | REV029.0194 | KTA253 |  | 18 |  | Available | 9317745751519
ALOY0002K | REV029.0206 | WA420L |  | 0 |  | To Be Defined | 9317745790082
ALOY0003K |  |  |  | 0 |  | Not Applicable | 9317745790341
ALOY0009K |  |  |  | 0 |  | To Be Defined | 9317745772187
[NAME] |  | WA452L |  | 0 |  | Not Applicable | 9317745771883
ALOY0011K |  |  |  | 0 |  | Not Applicable | 9317745771890
ALOY0012K |  |  |  | 0 |  | Not Applicable | 9317745771906
ALOY0014K |  |  |  | 0 |  | Special Order | 9317745769354
ALOY0015K |  | KTA291 |  | 0 |  | Special Order | 9317745775645
[NAME] |  |  |  | 0 |  | Special Order | 9317745781486
ALOY0017K |  |  |  | 0 |  | Special Order | 9317745775652
ALOY0018K | REV029.0200 | KTA252 |  | 13 |  | Available | 9317745781158
ALOY0019K |  |  |  | 0 |  | Not Applicable | 9317745809845
ALOY0020K |  |  |  | 2 |  | New Product | 9317745810285
ALOY0021K |  |  |  | 0 |  | Not Applicable | 9317745817666
[NAME] |  | KTA383 |  | 5 |  | Available | 9317745787396
ALOY0046K |  |  |  | 0 |  | Available | 9317745768999
[NAME] |  |  |  | 0 |  | To Be Defined | 9317745769019
ALOY0046XK |  |  |  | 4 |  | Available | 9317745769002
ALOY0090K | REV256.0032 | KTA255 |  | 10 |  | Available | 9317745783954
ALOY1388-90AK |  | [NAME] |  | 1 |  | Special Order | 9317745770305
Spreadsheet: 267947d1380311426-need-excel-2010-pivot-table-with-running-totals-that-reset-to-baseline-test2-requisitions-solution
Sheet: DATA

DATE | REQUISITION # | MONTH | Month2 | VENDOR NAME | AMOUNT | Running Total
2012-09-13 00:00:00 | 58930 |  | 01-SEP | BRADLEY | 4334.15 |  |  | Step 1 | Sort Requisition # | Smallest to Largest
2013-02-12 00:00:00 | 61152 |  | 06-FEB | BRADLEY | 178128 |  |  | Step 2 | Sort Vendor Name | A to Z
2013-06-06 00:00:00 | 62236 |  | 10-JUN | BRADLEY | 3375
2013-06-18 00:00:00 | 62237 |  | 10-JUN | BRADLEY | 78128
2013-08-14 00:00:00 | 62257 |  | 12-AUG | BRADLEY | 4563.74
2013-04-03 00:00:00 | 61164 |  | 08-APR | Cannon | 74250
2013-03-13 00:00:00 | 61159 |  | 07-MAR | DELTA | 6900
2013-03-27 00:00:00 | 61161 |  | 07-MAR | DELTA | 12500
2012-10-18 00:00:00 | 58933 |  | 02-OCT | EMERY | 100000
2012-10-18 00:00:00 | 58934 |  | 02-OCT | EMERY | 320000
2013-01-30 00:00:00 | 61150 |  | 05-JAN | EMERY | 15821.58
2013-02-12 00:00:00 | 61151 |  | 06-FEB | EMERY | 8500
2013-03-01 00:00:00 | 61156 |  | 07-MAR | EMERY | 249018
2013-06-18 00:00:00 | 61654 |  | 10-JUN | EMERY | 381489
2013-07-29 00:00:00 | 62251 |  | 11-JUL | EMERY | 81120.51
2013-08-20 00:00:00 | 62614 |  | 12-AUG | EMERY | 75000
2013-01-09 00:00:00 | 58951 |  | 05-JAN | GREENHOUSE | 31048.4
2013-02-21 00:00:00 | 61154 |  | 06-FEB | GREENHOUSE | 1077
2013-05-13 00:00:00 | 61653 |  | 09-MAY | GREENHOUSE | 86541.25
2013-05-29 00:00:00 | 61659 |  | 09-MAY | GREENHOUSE | 1515.2
2013-06-13 00:00:00 | 62030 |  | 10-JUN | GREENHOUSE | 14323.86
2013-07-24 00:00:00 | 62250 |  | 11-JUL | GREENHOUSE | 117322.57
2012-10-19 00:00:00 | 58936 |  | 02-OCT | HARRISON | 100000
2013-03-06 00:00:00 | 61158 |  | 07-MAR | HARRISON | 100000
2013-08-21 00:00:00 | 62615 |  | 12-AUG | HARRISON | 100000
2013-08-30 00:00:00 | 62616 |  | 12-AUG | HARRISON | 100000
2013-08-20 00:00:00 | 62613 |  | 12-AUG | Keystone | 56270
2012-11-05 00:00:00 | 58938 |  | 03-NOV | LINDEL | 26950
2012-11-05 00:00:00 | 59254 |  | 03-NOV | LINDEL | 4454
2013-06-24 00:00:00 | 62239 |  | 10-JUN | Multivista | 16303
2012-10-18 00:00:00 | 58935 |  | 02-OCT | NANCY | 57000
2013-04-03 00:00:00 | 61163 |  | 08-APR | Parson | 13997.44
2013-07-17 00:00:00 | 62248 |  | 11-JUL | Parson | 4381.43
2012-11-14 00:00:00 | 58942 |  | 03-NOV | WINTER | 1581
Spreadsheet: 497f286d-c5b2-41e8-be70-11697551e085
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SNOWSHOE | T1 | SKATE | T2 | SKI | POSITION | TOTAL TIME
5408 | 39403 | [NAME] | [NAME] | GBR | 141 | 00:19:32 | 00:00:28 | [NAME] | 00:01:43 | 00:27:30 | 1 | 01:15:17
Spreadsheet: andy_zipper__109__Cost Allocation 02-21-01
Sheet: Sheet1

 |  | Index
 |  |  |  | INVOICE SENT
 |  |  |  | INVOICE NOT SENT
 |  | Development Cost for EnronOnline
 |  | New Countries/ Commodity |  | Description | 2001-01-01 00:00:00 | 2001-02-01 00:00:00 | 2001-03-01 00:00:00 | 2001-04-01 00:00:00 | 2001-05-01 00:00:00 | 2001-06-01 00:00:00 | 2001-07-01 00:00:00 | 2001-08-01 00:00:00 | 2001-09-01 00:00:00 | 2001-10-01 00:00:00 | 2001-11-01 00:00:00 | 2001-12-01 00:00:00 | Total
 |  | Chile--Metals |  | Country Launch |  |  | 25000
 |  | Greece--Sea Freight |  | Country Launch |  |  | 25000
 |  | Hong Kong--Metals |  | Country Launch |  |  | 25000
 |  | Israel--Sea Freight |  | Country Launch |  |  | 25000
 |  | Latvia--LPG |  | Country Launch |  |  | 25000
 |  | Monaco--Metals |  | Country Launch |  |  | 25000
 |  | Peru--Metals |  | Country Launch |  |  | 25000
 |  | Russia--Metals |  | Country Launch |  |  | 25000
 |  | Slovakia--Continental Power |  | Country Launch |  |  | 25000
 |  | South Africa--Coal |  | Country Launch |  |  | 25000
 |  | Taiwan--Metals |  | Country Launch |  |  | 25000
 |  | Turkey--Sea Freight |  | Country Launch |  |  | 25000
 |  | China--Metals |  | Country Launch |  |  | 25000
 |  | US --Pipeline Capacity-TW |  | Initial Set Up |  | 85000
 |  | US --Pipeline Capacity-FGT |  | Initial Set Up |  | 85000
 |  | US --Pipeline Capacity-NNG |  | Initial Set Up |  | 75000
 |  | US --Pipeline Capacity-NNG |  | Annual Support Fee |  | 35000
 |  | Total |  | Total
 |  | Country & |  | New Products | 2001-01-01 00:00:00 | 2001-02-01 00:00:00 | 2001-03-01 00:00:00 | 2001-04-01 00:00:00 | 2001-05-01 00:00:00 | 2001-06-01 00:00:00 | 2001-07-01 00:00:00 | 2001-08-01 00:00:00 | 2001-09-01 00:00:00 | 2001-10-01 00:00:00 | 2001-11-01 00:00:00 | 2001-12-01 00:00:00 | Total
 |  | Commodity Group
 |  | Bandwidth |  | IP Premium Transport | 250000
 |  | Brazil Power |  | Phy Firm |  | 100000
 |  |  |  | Total
 |  |  |  | Grand Total
Spreadsheet: 692827d1598597703-extracting-data-from-another-sheet-exfo-3-textjoin
Sheet: income

Sequence No. | Order ID | refund id | Original product price | Your [NAME] product promotion | Voucher | Shipping Fee Paid by [NAME] | Shipping Rebate From Shopee | Shipping Fee Paid By Shopee On Your Behalf | Refund Amount to [NAME] (RM) | Service Fee (Incl. SST) | Transaction Fee (Incl. SST) | Total Released Amount (RM) | Parent SKU Reference No. | SKU Reference No. | Quantity
1 | 200808F2PXW8P9 |  | 31.9 | -0.63 | -8 | 0 | 12.4 | -12.4 | 0 | -0.74 | -0.44 | 22.09 | 36-0118D/36-0118N | 0/0 | 1/1
2 | 2008167ABJMTPF |  | 25 | -5.1 | 0 | 0 | 4.66 | -4.66 | 0 | -0.63 | -0.32 | 18.95 | 91-HL016 | 91-HL016-BK | 1
3 | 2008166UAYTJYF |  | 22 | -2.1 | 0 | 4.66 | 0 | -4.66 | 0 | -0.63 | -0.52 | 18.75 | 36-3173 | 0 | 1
4 | 2008167JN7HEPF |  | 35 | -5.1 | 0 | 4.66 | 0 | -4.66 | 0 | -0.95 | -0.73 | 28.22 | 36-AT288 | 36-AT288G-R | 1
5 | 2008155QVH4PHE |  | 75 | -33.7 | -3 | 0 | 4.66 | -4.66 | 0 | -1.22 | -0.81 | 36.27 | 36-238/36-238/36-GG-968/36-GG-968/36-GG-968 | 238C/238H/36-968-2/36-968-8/36-968-10 | 1/1/1/1/1
6 | 2008178RRE9D1D |  | 38 | -3.7 | -3 | 0 | 5.04 | -5.04 | 0 | -1 | -0.66 | 29.64 | 83-2142/2026/2139/2022/93-YQ219/15-1132-1/15-1131-1 | 83-2139/93-YQ219-B/0/0 | 10/1/1/1
7 | 2008142E25CTNT |  | 48 | -7.11 | -3 | 0 | 4.66 | -4.66 | 0 | -1.2 | -0.8 | 35.89 | 36-88168-4S/36-2016-5A/2017-5A/2017-6A/2017-7A | 0/36-2017-7A | 1/1
8 | 2008167TJWDWWB |  | 24 | -4.2 | 0 | 0 | 4.66 | -4.66 | 0 | -0.63 | -0.42 | 18.75 | 36-989 | 36-989-S7-W | 1
9 | 2008046F70S99Y |  | 56 | -23.31 | 0 | 0 | 9.01 | -9.01 | 0 | -1.04 | -0.69 | 30.96 | 36-2016-5A/2017-5A/2017-6A/2017-7A/36-2016-5A/2017-5A/2017-6A/2017-7A/36-2016-5A/2017-5A/2017-6A/2017-7A/36-2016-5A/2017-5A/2017-6A/2017-7A | 36-2016-5A-R/36-2016-5A-B/36-2017-5A-Y/36-2017-5A-S | 1/1/1/2
10 | 200816889X9NQ3 |  | 54.3 | -1.44 | -3 | 0 | 4.66 | -4.66 | 0 | -1.59 | -1.06 | 47.21 | 36-AT288/36-ZR2043/93-659/666 | 36-AT288D-Y/36-ZR2043D/93-659 | 1/1/3