tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 98996d1297790953-subtotal-macro-sort-and-subtotal-macro
Sheet: Sheet1

10315 | 10316-01 | 10330-01 | 10316-02 | 10330-02
Fed W/H | SS W/H | SS Acc'd | Med W/H | Med Acc'd | Amt | Liability | Deposit
20488.84 | 3442.12 | 5081.23 | 1188.4 | 1188.4 | 31388.99 | 2011-01-04 00:00:00 | 2011-01-07 00:00:00
577.73 | 151.5 | 223.64 | 52.3 | 52.3 | 1057.47 | 2011-01-04 00:00:00 | 2011-01-07 00:00:00
2705.72 | 454.56 | 671.02 | 156.93 | 156.93 | 4145.16 | 2011-01-04 00:00:00 | 2011-01-07 00:00:00
50 | 8.33 | 12.3 | 2.88 | 2.88 | 76.38999999999999 | 2011-01-04 00:00:00 | 2011-01-07 00:00:00
55.69 | 15.15 | 22.37 | 5.23 | 5.23 | 103.67 | 2011-01-04 00:00:00 | 2011-01-07 00:00:00
587.5 | 98.7 | 145.7 | 34.08 | 34.08 | 900.0600000000002 | 2011-01-04 00:00:00 | 2011-01-07 00:00:00
543894.23 | 163117.06 | 240791.36 | 56314.1 | 56314.1 | 1060430.85 | 2011-01-07 00:00:00 | 2011-01-10 00:00:00
0 | 50.25 | 74.18 | 17.35 | 17.35 | 159.13 | 2011-01-07 00:00:00 | 2011-01-12 00:00:00
6071.25 | 1019.97 | 1505.67 | 352.13 | 352.13 | 9301.149999999998 | 2011-01-07 00:00:00 | 2011-01-12 00:00:00
615.07 | 231.92 | 342.35 | 80.07 | 80.07 | 1349.48 | 2011-01-07 00:00:00 | 2011-01-12 00:00:00
1702.5 | 286.02 | 422.22 | 98.75 | 98.75 | 2608.24 | 2011-01-10 00:00:00 | 2011-01-14 00:00:00
3693.5 | 620.51 | 915.99 | 214.23 | 214.23 | 5658.459999999999 | 2011-01-11 00:00:00 | 2011-01-14 00:00:00
254.63 | 208.11 | 307.2 | 71.85 | 71.85 | 913.6400000000001 | 2011-01-11 00:00:00 | 2011-01-14 00:00:00
6954.21 | 1168.31 | 1724.64 | 403.34 | 403.34 | 10653.84 | 2011-01-11 00:00:00 | 2011-01-14 00:00:00
1026.98 | 299.16 | 441.62 | 103.28 | 103.28 | 1974.32 | 2011-01-11 00:00:00 | 2011-01-14 00:00:00
616.37 | 103.54 | 152.85 | 35.74 | 35.74 | 944.24 | 2011-01-11 00:00:00 | 2011-01-14 00:00:00
1157.61 | 194.48 | 287.09 | 67.14 | 67.14 | 1773.46 | 2011-01-14 00:00:00 | 2011-01-20 00:00:00
4500 | 756 | 1116 | 261 | 261 | 6894 | 2011-01-14 00:00:00 | 2011-01-20 00:00:00
0 | 27.41 | 40.46 | 9.46 | 9.46 | 86.79000000000002 | 2011-01-14 00:00:00 | 2011-01-20 00:00:00
1308 | 219.74 | 324.38 | 75.86 | 75.86 | 2003.84 | 2011-01-14 00:00:00 | 2011-01-20 00:00:00
0 | 14.13 | 20.86 | 4.88 | 4.88 | 44.75000000000001 | 2011-01-14 00:00:00 | 2011-01-20 00:00:00
348.76 | 87.19 | 128.72 | 30.1 | 30.1 | 2212455.77 | 2011-01-18 00:00:00 | 2011-01-21 00:00:00
625 | 105 | 155 | 36.25 | 36.25 | 957.5 | 2011-01-18 00:00:00 | 2011-01-21 00:00:00
348.76 | 87.19 | 128.72 | 30.1 | 30.1 | 2212455.77 | 2011-01-18 00:00:00 | 2011-01-21 00:00:00
1984.84 | 333.45 | 492.24 | 115.12 | 115.12 | 3040.77 | 2011-01-18 00:00:00 | 2011-01-21 00:00:00
14.61 | 9.53 | 14.06 | 3.29 | 3.29 | 44.78 | 2011-01-18 00:00:00 | 2011-01-21 00:00:00
150 | 25.2 | 37.2 | 8.7 | 8.7 | 229.8 | 2011-01-18 00:00:00 | 2011-01-21 00:00:00
545966.04 | 163723.98 | 241714.85 | 56530.19 | 56530.19 | 1064465.25 | 2011-01-21 00:00:00 | 2011-01-24 00:00:00
1145697.84 | 336858.51 | 497293.92 | 116302.75 | 116302.75 | 6636117.57
Spreadsheet: 186e7d85-4338-466f-9a76-8fdd9eeed462
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Spot Barge Rates, 2000 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
DATE | TWC | MM | ILL | ST LOUIS | CINC | LOH | CAR-MEM | MEM-NO
000105 | 0 | 0 | 167 | 129 | 138 | 139 | 120 | 185
000112 | 0 | 0 | 184 | 162 | 159 | 160 | 152 | 188
000119 | 0 | 0 | 190 | 168 | 161 | 162 | 161 | 205
000126 | 0 | 0 | 276 | 166 | 155 | 158 | 155 | 205
000202 | 0 | 0 | 221 | 140 | 135 | 138 | 134 | 173
000209 | 0 | 0 | 161 | 134 | 132 | 131 | 125 | 180
000216 | 0 | 0 | 188 | 156 | 155 | 156 | 149 | 195
000223 | 0 | 0 | 171 | 150 | 151 | 151 | 144 | 197
000301 | 0 | 188 | 168 | 153 | 166 | 166 | 139 | 190
000308 | 225 | 187 | 183 | 144 | 167 | 170 | 136 | 183
000315 | 223 | 184 | 177 | 135 | 152 | 153 | 132 | 190
000322 | 210 | 172 | 165 | 129 | 129 | 134 | 125 | 175
000329 | 183 | 149 | 143 | 121 | 118 | 118 | 117 | 160
000405 | 183 | 149 | 140 | 117 | 120 | 123 | 113 | 150
000412 | 186 | 154 | 134 | 116 | 119 | 121 | 111 | 158
000419 | 181 | 145 | 134 | 116 | 119 | 123 | 106 | 155
000426 | 178 | 142 | 134 | 109 | 117 | 118 | 100 | 150
000503 | 173 | 142 | 136 | 107 | 118 | 118 | 100 | 150
000510 | 163 | 133 | 127 | 105 | 115 | 114 | 98 | 145
000517 | 152 | 131 | 121 | 104 | 108 | 107 | 96 | 140
000524 | 170 | 140 | 122 | 107 | 110 | 108 | 104 | 143
000531 | 163 | 133 | 119 | 102 | 109 | 108 | 103 | 175
000607 | 162 | 133 | 115 | 103 | 110 | 109 | 103 | 135
000614 | 177 | 151 | 138 | 108 | 115 | 115 | 106 | 160
000621 | 183 | 154 | 142 | 111 | 112 | 112 | 101 | 155
000628 | 226 | 185 | 178 | 127 | 120 | 121 | 109 | 165
000705 | 220 | 175 | 178 | 130 | 136 | 135 | 123 | 185
000712 | 217 | 175 | 183 | 127 | 130 | 131 | 123 | 178
000719 | 235 | 212 | 195 | 144 | 162 | 165 | 147 | 240
000726 | 241 | 226 | 213 | 184 | 188 | 192 | 180 | 258
000802 | 222 | 198 | 186 | 162 | 173 | 175 | 158 | 230
000809 | 206 | 181 | 170 | 153 | 166 | 168 | 144 | 190
000816 | 200 | 176 | 163 | 153 | 165 | 164 | 148 | 193
000823 | 246 | 230 | 206 | 188 | 203 | 202 | 188 | 257
000830 | 271 | 258 | 239 | 239 | 254 | 254 | 240 | 347
000906 | 267 | 256 | 249 | 237 | 248 | 247 | 233 | 325
000913 | 280 | 277 | 270 | 255 | 273 | 278 | 253 | 342
000920 | 313 | 332 | 320 | 332 | 329 | 334 | 320 | 400
000927 | 300 | 305 | 307 | 303 | 309 | 317 | 294 | 340
001004 | 250 | 230 | 227 | 224 | 233 | 229 | 219 | 263
001011 | 230 | 205 | 197 | 207 | 207 | 204 | 165 | 210
001018 | 187 | 182 | 174 | 153 | 192 | 188 | 147 | 190
001025 | 166 | 158 | 154 | 141 | 175 | 164 | 131 | 175
001101 | 172 | 163 | 158 | 144 | 236 | 225 | 133 | 173
001108 | 214 | 180 | 154 | 138 | 207 | 185 | 128 | 175
001115 | 201 | 150 | 132 | 120 | 138 | 134 | 116 | 165
001122 | 0 | 140 | 138 | 116 | 134 | 134 | 111 | 150
001129 | 0 | 150 | 142 | 120 | 141 | 140 | 113 | 153
001206 | 0 | 0 | 177 | 129 | 144 | 141 | 118 | 168
001213 | 0 | 0 | 202 | 159 | 145 | 144 | 131 | 173
001221 | 0 | 0 | 241 | 153 | 141 | 140 | 123 | 171
001227 | 0 | 0 | 260 | 186 | 138 | 138 | 120 | 169
010301 | 0 | 0 | 255 | 176 | 151 | 150 | 121 | 165
Spreadsheet: 20a392d2-7dd8-4e31-8937-15c2a7566f34
Sheet: Civilizations-History

CIVILIZATIONS - HISTORY
Course color corresponds with term of offering.  RED for fall semester, PURPLE for J-term, GREEN for both fall and J-term.
 | AOK Designation | Comment
[NAME]
ARTH 210 | Civilizations-History (as HIST 101) | cross-listed with CLAS 210
 | OR Arts & Literature -Arts
Classical Studies
CLAS 210 | Civilizations-History (as HIST 101) | cross-listed with ARTH 210
 | OR Arts & Literature -Arts
History
HIST 100 | Civilizations-History
HIST 101 | Civilizations-History
HIST 111 | Civilizations-History
HIST 112 | Civilizations-History
Honors Program
HONR 123 | Civilizations-History (as HIST 101)
HONR 221 | Civilizations-History (as HIST 100 or 111)
HONR 273 | Civilizations-History (as HIST 100)
HONR 283 | Civilizations-History (as HIST 100)
Spreadsheet: 97386d1296586284-probability-of-next-in-sequence-next-order
Sheet: Sheet1

 |  | Customer 1 |  |  | Customer 2
 |  | combination count | % |  | combination count | %
 | Count
 | [NAME]
 | cm
 | cc
 |  | Orders |  |  | Orders
 |  | c |  |  | c
 |  | i |  |  | i
 |  | c |  |  | c
 |  | i |  |  | i
 |  | c |  |  | c
 |  | i |  |  | i
 |  | c |  |  | c
 |  | m |  |  | m
 |  | c |  |  | c
 |  | m |  |  | m
 |  | c |  |  | c
 |  | c |  |  | c
 |  |  |  |  | c
 |  |  |  |  | i
 |  |  |  |  | c
 |  |  |  |  | i
 |  |  |  |  | m
 |  |  |  |  | c
 |  |  |  |  | m
 |  |  |  |  | c
 |  |  |  |  | c
 |  |  |  |  | i
Spreadsheet: 117145d1312473044-might-be-simple-but-not-to-me-data-transfer-and-automatic-sorting-example-log
Sheet: Sheet2

 | Fault report log |  | This would be sorted automatically from recent to oldest report
 | Date | Time | Reported by | Issue | Location
 | 2011-08-04 00:00:00 | 17:02:00 | Employee 1 | Leak | LG121
 | 2011-08-04 00:00:00 | 16.19 | Employee 2 | Damaged equipment | LG167
 | 2011-08-04 00:00:00 | 15.03 | Employee 3 | Spill | LG167
 | 2011-08-04 00:00:00 | 12.47 | Employee 2 | Electricity out | LG121
 | 2011-08-04 00:00:00 | 10:02:00 | Employee 1 | Electricity out | LG021
 | 2011-08-04 00:00:00 | 09:45:00 | Employee 2 | Damaged equipment | LG105
 | 2011-08-03 00:00:00 | 17:02:00 | Employee 3 | Damaged equipment | LG167
 | 2011-08-03 00:00:00 | 16.19 | Employee 4 | Leak | LG121
 | 2011-08-03 00:00:00 | 15.03 | Employee 1 | Spill | LG121
 | 2011-08-03 00:00:00 | 12.47 | Employee 2 | Door issue | LG101
 | 2011-08-03 00:00:00 | 10:02:00 | Employee 1 | Electricity out | LG021
 | 2011-08-03 00:00:00 | 09:45:00 | Employee 2 | Damaged equipment | LG444
 | 2011-08-02 00:00:00 | 17:02:00 | Employee 3 | Spill | LG105
 | 2011-08-02 00:00:00 | 16.19 | Employee 1 | Leak | LG167
 | 2011-08-02 00:00:00 | 15.03 | Employee 2 | Leak | LG167
 | 2011-08-02 00:00:00 | 12.47 | Employee 3 | Door issue | LG121
 | 2011-08-02 00:00:00 | 12:05:00 | Employee 1 | Electricity out | LG021
 | 2011-08-02 00:00:00 | 11:20:00 | Employee 4 | Electricity out | LG444
 | 2011-08-02 00:00:00 | 11:12:00 | Employee 1 | Spill | LG167
 | 2011-08-02 00:00:00 | 10:31:00 | Employee 2 | Spill | LG121
 | 2011-08-02 00:00:00 | 10:02:00 | Employee 3 | Leak | LG444
 | 2011-08-02 00:00:00 | 09:45:00 | Employee 1 | A/C issue | LG105
 | 2011-08-01 00:00:00 | 12:05:00 | Employee 3 | Electricity out | LG167
 | 2011-08-01 00:00:00 | 11:20:00 | Employee 4 | Electricity out | LG021
 | 2011-08-01 00:00:00 | 11:12:00 | Employee 4 | Door issue | LG021
 | 2011-08-01 00:00:00 | 10:31:00 | Employee 1 | Damaged equipment | LG444
 | 2011-08-01 00:00:00 | 10:02:00 | Employee 1 | Door issue | LG121
 | 2011-08-01 00:00:00 | 09:45:00 | Employee 2 | A/C issue | LG021
 | 2011-08-01 00:00:00 | 09:20:00 | Employee 2 | Door issue | LG105
 | 2011-08-01 00:00:00 | 08:59:00 | Employee 3 | Damaged equipment | LG444
Spreadsheet: 59751d1260312797-excel-2007-how-to-sort-data-validation-menu-while-typing-characters-in-the-cell-for-the-menu-master_requirement_gathering_template_-final-
Sheet: Mass Changes

 |  |  | DATA Gathering Template
Program | Temporary Assistance - Family Assistance and Safety Net
Function Name | Case Management (Undercare)
Activity Name | Mass Changes
Activity Description / Purpose | Changes that occur for programs that affect all beneficiaries
 |  |  | Activity Predecessor | Activity [NAME] | Activity Input | Activity Output | Activity Successors
Steps | Tasks A task is any action that is being performed to complete a step | What unit does this? (SU) | Who does this? (W) | Applications used / System Interfaces / Tools Is there an automated system supporting the activity? | What happens before this? (P) | What causes the activity to happen (T) | Additional Information that is needed (I) | Is anything produced? (O) | What happens next ? (S) | V | Comments |  |  |  | Questions | Workarounds | Constraints/ Issues | Opportunities | Policy Considerations | Best Practices | Follow-Up | Comments
Check Daily Task Manager
Review exception reports
Make updates to case
Spreadsheet: 737348d1624367009-multi-dependent-dropdowns-with-auto-generated-cell-dependent-dropdown-table-example
Sheet: Master

Cuisine
Restaurant | Chicken | Pizza | Burgers | Indian | Chinese | [NAME] | Chips
Italian Hut | No | Yes | No | No | No | No | Yes
Bobs Chicken, Pizza & Burgers | Yes | Yes | Yes | No | No | No | Yes
[NAME] | No | No | No | No | No | Yes | Yes
Pathway to India | No | No | No | Yes | No | No | No
Oriental Express | No | No | No | No | Yes | No | No
Spreadsheet: 86001d1285965675-select-data-based-on-user-input-boxes
Sheet: Sheet1

Box Type | [NAME] (ft) | [NAME] (ft) | [NAME] (ft) | Available Colors
A | 1 | 1 | 1 | [NAME]
B | 2 | 3 | 2 | Brown, Grey
C | 1 | 3 | 1 | Blue, Red
D | 3 | 4 | 2 | Blue, Grey, Brown
E | 2 | 1 | 3 | Red
F | 2 | 2 | 2 | Red, Yellow
G | 1 | 2 | 3 | Orange, Yellow
H | 4 | 4 | 4 | Black
I | 3 | 3 | 3 | White
J | 2 | 2 | 2 | Green, Orange
K | 1 | 2 | 1 | Purple, Blue
L | 2 | 3 | 2 | Blue
M | 3 | 4 | 3 | Black
Spreadsheet: 93900d1293661016-excel-2007-clearing-a-row-after-a-particular-word-selected-cat-working-file
Sheet: 266CD

266CD
LAST QUARTERLY | QUARTERLY DUE NLT | NEXT QUARTERLY START | UPDATED BY: | LAST MASO | MASO DUE NLT | NEXT MASO START | UPDATED BY: | JACKET REVIEW | IMT 68     DATE | IMT 68 REVIEW
2010-02-01 00:00:00 | N/A | N/A | JAD | 2010-02-01 00:00:00 | N/A | N/A | JAD |  | 2009-09-17 00:00:00 | 2010-09-08 00:00:00
JACKET REVIEW
NAME |  | DATE ACCOMPLISHED |  | COMMENTS / FINDINGS
DEEMER |  | 2010-09-08 00:00:00
GENERAL ACCOUNT INFORMATION / NOTES
All Assets turned in. Commanders justification letter forwarded to MASO/MUFM 21 Oct 10
RETURN TO STATUS PAGE |  |  | INVENTORY STATUS PAGE
Spreadsheet: 33352d1229646113-pivot-table-filtering-on-individual-counts-not-total-test4
Sheet: 46

Week Num | 46
Count of Case ID.
Name | Total
Name 1036 | 7
Name 1045 | 9
Name 1173 | 6
Name 1354 | 8
Name 1727 | 7
Name 1743 | 7
Name 188 | 7
Name 1882 | 8
Name 1929 | 12
Name 1960 | 7
Name 1994 | 7
Name 2023 | 8
Name 2073 | 9
Name 261 | 6
Name 53 | 12
Name 630 | 7
Name 68 | 6
Name 804 | 6
Name 815 | 6
Name 828 | 6
Name 876 | 7
Name 877 | 6
Grand Total | 164
Spreadsheet: 834531d1687882972-need-formula-size-reduction-days-per-month
Sheet: Sheet1

 |  |  | 2023-01-01 00:00:00
2023-02-13 00:00:00 | 2023-04-06 00:00:00
2023-02-13 00:00:00
Spreadsheet: 109279d1306185136-comparing-grades-and-using-conditional-formatting-example
Sheet: Sheet2

3 more |  |  | 2 more |  | one more |  |  | Target | matched |  | one less |  | 2 less |  | 3 less |  | 4 less |  | 5 less |  | 6 less | 7 less | 8 less
58 |  |  | 58 |  | 58 |  | # | 58 | 58 |  | 52 |  | 46 |  | 40 |  | 34 |  | 28 |  | 22 | 16 | 10
58 |  |  | 58 |  | 58 |  | a | 52 | 52 |  | 46 |  | 40 |  | 34 |  | 28 |  | 22 |  | 16 | 10 | 10
58 |  |  | 58 |  | 52 |  | b | 46 | 46 |  | 40 |  | 34 |  | 28 |  | 22 |  | 16 |  | 10 | 10 | 10
58 |  |  | 52 |  | 46 |  | c | 40 | 40 |  | 34 |  | 28 |  | 22 |  | 16 |  | 10 |  | 10 | 10 | 10
52 |  |  | 46 |  | 40 |  | d | 34 | 34 |  | 28 |  | 22 |  | 16 |  | 10 |  | 10 |  | 10 | 10 | 10
46 |  |  | 40 |  | 34 |  | e | 28 | 28 |  | 22 |  | 16 |  | 10 |  | 10 |  | 10 |  | 10 | 10 | 10
40 |  |  | 34 |  | 28 |  | f | 22 | 22 |  | 16 |  | 10 |  | 10 |  | 10 |  | 10 |  | 10 | 10 | 10
34 |  |  | 28 |  | 22 |  | g | 16 | 16 |  | 10 |  | 10 |  | 10 |  | 10 |  | 10 |  | 10 | 10 | 10
28 |  |  | 22 |  | 16 |  | u | 10 | 10 |  | 10 |  | 10 |  | 10 |  | 10 |  | 10 |  | 10 | 10 | 10
 | 57 | A*
 | 56.88461538461539 | A*
 | 56.73913043478261 | A*
 | 56.55 | A*
 | 51.10344827586207 | A
 | 51 | A
 | 50.8695652173913 | A
 | 50.7 | A
 | 50.47058823529412 | A
 | 45.20689655172414 | B
 | 45.11538461538461 | B
 | 45 | B
 | 44.85 | B
 | 44.64705882352941 | B
 | 44.35714285714285 | B
 | 39.31034482758621 | C
 | 39.23076923076923 | C
 | 39.1304347826087 | C
 | 39 | C
 | 38.8235294117647 | C
 | 38.57142857142857 | C
 | 38.18181818181818 | C
 | 33.34615384615385 | D
 | 33.26086956521739 | D
 | 33.15 | D
 | 33 | D
 | 32.78571428571428 | D
 | 32.45454545454545 | D
 | 31.875 | D
 | 27.39130434782609 | E
 | 27.3 | E
 | 27.17647058823529 | E
 | 27 | E
 | 26.72727272727273 | E
 | 26.25 | E
 | 25.2 | E
 | 21.45 | F
 | 21.35294117647059 | F
 | 21.21428571428572 | F
 | 21 | F
 | 20.625 | F
 | 19.8 | F
 | 15.52941176470588 | G
 | 15.42857142857143 | G
 | 15.27272727272727 | G
 | 15 | G
 | 14.4 | G
 | 9.642857142857142 | U
 | 9.545454545454545 | U
 | 9.375 | U
 | 9 | U
Spreadsheet: 673242d1587282084-using-vlookup-to-find-the-similar-element-in-another-sheet-and-update-in-first-sheet-testtable
Sheet: Sheet2

Prod ID | [NAME] | Manager [NAME] | Unit Head
01TDFGHK | TOM | JENNIFER | STUART
07MKLUKO | [NAME] | GOUGH | STUART
09KLFGMK | SMITH | ANDREW | STUART
11PKIDIOT | [NAME] | ANDY | STUART
08HJIKLUG | JACOBSON | RAZDAN | KALE
03KHSFHK | NICKOGEN | ANDERESON | [NAME]
41GHDFTH | [NAME] | PETER | [NAME]
Spreadsheet: 598353d1542388635-index-and-aggregate-to-ignore-0s-and-functions-test_aggregate-ans1
Sheet: Sheet1

Taxes | Rent | Utilities | Others | Own taxes | Own Rent | Misc | Account | Leasing | Balance | Comments
323 | 0
 |  |  |  |  | 2 | 76
 | 243 |  | 342 |  |  | 32
 |  |  | 34 |  |  | 11 |  | 34 | 34
The employer must be taxed accordingly | Company paid rent |  | Other finances |  | The rent is own paid | Miscellaneous finances |  | Leasing expenses | Total balance
NOTE: C2 is having formula
 |  |  |  |  |  |  |  |  |  | [NAME]:J2<>0)*(A2:J2<>""))
0
Spreadsheet: 587319d1534955819-flagging-values-after-certain-text-samplesheets
Sheet: Desired Result

Q1 | Q2 | Q3 | Q4 | Q5 | Q6 | Q7 | Q8 | Q9 | Q10 | Q11 | Q12 | Q13 | Q14 | Q15 | Q16 | Q17 | Q18 | Dash Flag | Notes
2 | 3 | 4 | 3 | 3 | 3 | 5 | 1 | 3 | 2 | 2 | 3 | 5 | 5 | - | - | - | - | N | <- No values after "-"
2 | 3 | 4 | 3 | 3 | 4 | 3 | 5 | 3 | 2 | 3 | - | 2 | 1 | 5 | 5 | 5 | - | Y | <-responses continue after first set of dashes
2 | 5 | 1 | 2 | 2 | 5 | 1 | 1 | 2 | 2 | 3 | 4 | 4 | 5 | 5 | 4 | 5 | 5 | N | <- No values after "-"
2 | 2 | 1 | 2 | 2 | - | - | - | - | - | - | - | - | - | - | - | - | - | N | <- No values after "-"
5 | 1 | 4 | 1 | 5 | 3 | 1 | 4 | 2 | 1 | 2 | 5 | 2 | 3 | - | - | - | - | N | <- No values after "-"
- | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | 5 | Y | <-responses continue after first set of dashes
2 | 3 | 4 | 3 | 3 | 2 | 5 | 1 | 4 | 1 | - | - | - | - | - | - | - | - | N | <- No values after "-"
5 | 4 | 4 | 2 | 2 | - | - | - | - | - | - | - | - | - | - | - | - | - | N | <- No values after "-"
2 | 2 | 2 | 5 | 2 | 2 | 1 | 1 | 1 | 3 | 3 | 4 | 1 | 3 | - | - | - | - | N | <- No values after "-"
4 | 1 | 1 | 5 | 2 | 4 | 3 | 3 | 2 | 2 | 1 | 1 | 4 | 5 | 3 | 4 | 4 | - | N | <- No values after "-"
4 | 1 | 5 | 5 | 5 | 5 | 5 | 5 | 2 | 4 | 3 | 3 | 3 | 2 | 2 | 4 | 5 | - | N | <- No values after "-"
4 | 4 | 5 | 1 | 3 | 2 | 5 | 5 | - | - | 3 | 3 | 3 | 4 | - | - | - | - | Y | <-responses continue after first set of dashes
4 | 1 | 1 | 5 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | N | <- No values after "-"
4 | 4 | 3 | 5 | 2 | 4 | 4 | 3 | 4 | 1 | 1 | - | - | - | - | - | - | - | N | <- No values after "-"
2 | 2 | 5 | 4 | 1 | 4 | 5 | 5 | - | - | - | - | - | - | - | - | - | - | N | <- No values after "-"
1 | 1 | 5 | 1 | 3 | - | - | - | - | - | - | - | - | - | - | - | - | - | N | <- No values after "-"
4 | 5 | 5 | 5 | - | - | - | - | - | - | - | - | - | - | - | 4 | 1 | 1 | Y | <- No values after "-"
- | 5 | 1 | 3 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | Y | <-responses continue after first dash
Spreadsheet: 888487d1738968237-update-needed-to-formula-to-only-show-data-for-month-sample-sheet
Sheet: January

 | Note: Rep names must be entered in exactly as they are shown in the survey report. Enter the supervisor name in the green boxes.
 | Claim Rep | Number of Promoters | Number of Detractors | Total Survey Count | Overall Score
 | [NAME]
 | [NAME]
 |  |  |  | Team Score
 |  |  |  | Team Score
 |  |  |  | Team Score
 |  |  |  | Team Score
 | Sup 5
 |  |  |  | Team Score
 | Sup 6
 |  |  |  | DRG Score
Spreadsheet: 751972d1634484289-index-match-to-return-multiple-values-that-meeting-the-criteria-multiple-criteria-multiple-values
Sheet: Sheet1

Data
 | F1 | F2 | F3
a | 11 | 12 | 13
b
c
a
Output
 | F1 | F3
a
b
a |  |  | <-------- |  |  | should be these values
Spreadsheet: 02d1dae1-973a-43a7-8632-adf467bd0460
Sheet: DO

Table | Dominican Rep |  | Latin America and the Caribbean
 | Grain | Root | Commercial | Food aid |  | Aggregate
Year | production | production | imports | receipts |  | availability
 |  | (grain equiv.) | (grains) | (grain equiv.) |  | of all food
 |  |  | ---1,000 tons ---
2002 | 522.804 | 82.48736652996068 | 1440.666005 | 13.011495 |  | 2356.6731419862
2003 | 453.641 | 90.9713615489381 | 1285.572001 | 2.450499 |  | 2304.885159927783
2004 | 427.955 | 70.03175233064775 | 1275.79215 | 12.99675 |  | 2372.73978637553
2005 | 436.799 | 63.04054775210819 | 1572.8555 | 0.270789 |  | 2432.148126556179
2006 | 449.312 | 74.20747899444807 | 1782.108 | 12 |  | 2545.199649105368
2007 | 468.312 | 78.26777966705501 | 1718.946 | 0 |  | 2640.199739676907
2008 | 558.48 | 63.46094381681297 | 1408.140382 | 2.94114 |  | 2813.781386285333
2009 | 603.02 | 63.46094381681297 | 1432.168751 | 1.543243 |  | 2855.008735820257
2010(e) | 618.2 | 75.64932261352489 | 1431.103044333333 | 1.494794333333333 |  | 2868.201805777016
Projections |  |  |  | Food gaps*
 |  |  |  | NG | DG
2011 | 664.4893411742844 | 77.51421523433132 | 1399.805933944342 | 0 | 54.54094079839366 | 2876.126382158737
2016 | 715.1016448291831 | 87.32141771331156 | 1479.791689718028 | 0 | 42.77523490247796 | 3104.323900212204
2021 | 762.2674737516517 | 97.96683801039455 | 1523.113796880548 | 0 | 32.99648140824741 | 3313.383862619389
Source: Economic Research Service, using data from FAOSTAT (grain and root and tuber production and imports), and the World Food Program (food aid).
*NR stands for nutritional requirements and describes the amount of grain equivalent needed to support nutritional standards on
*NG stands for nutritional gap and describes the amount of grain equivalent needed to support nutritional standards on
income quintile to reach the nutrional requirement.
Spreadsheet: 69156d1269645354-nested-if-statements-to-calculate-increase-decrease-accountdata-1-
Sheet: Sheet1

 | Starting Balance | Day1 | Day2 | Day3 | Day4 | Day5
Account 1 | 500 | 1000 | 300 |  | 500 | 1000
Account 2 | 300 |  | 600 | 100
Account 3 | 1000
Account 4 | 200 |  | -500 | -200
Account 5 | 300 |  | 800
 |  | Increase / Decrease on Account |  |  |  |  |  |  |  |  | Increase / Decrease on Account
 |  | Day1 | Day2 | Day3 | Day4 | Day5 |  |  |  |  | Day1 | Day2 | Day3 | Day4 | Day5
Account 1 | 500 |  |  |  |  |  |  |  | Account 1 | 500 | 500 | -200 |  | 200 | 500
Account 2 | 300 |  |  |  |  |  |  |  | Account 2 | 300 |  | 600 | -500
Account 3 | 1000 |  |  |  |  |  |  |  | Account 3 | 1000
Account 4 | 200 |  |  |  |  |  |  |  | Account 4 | 200 |  | -700 | 500
Account 5 | 300 |  |  |  |  |  |  |  | Account 5 | 300 |  | 500
Spreadsheet: 38307d1236422479-display-data-in-horizontal-format-task2
Sheet: Sheet1

Current Format
Material | Component
123456 | [NAME] | label
123456 | YYY | carton
123456 | ZZZ | bottle
123456 | AAA | cap |  |  |  |  |  |  |  |  | CCC | TTT
123456 | AAA | cap
123457 | BBB | tube
123457 | [NAME] | label
123458 | ZZZ | bottle
123458 | GGG | nozzle
123458 | JJJ | tin
123458 | KKK | can
123458 | BBB | tube
123458 | YYY | carton
123458 | LLL | leaflet
123459 | UUU | box
123460 | BBB | tube
123460 | YYY | carton
123460 | CCC | pin
123460 | TTT | syringe
 |  |  |  |  |  | Required format
 |  |  |  |  |  |  |  | carton | bottle | cap | tube | nozzle | tin | can | leaflet | box | pin | syringe
 |  |  |  |  |  | 123456 | [NAME] | YYY | ZZZ | AAA
 |  |  |  |  |  | 123457 | [NAME] |  |  |  | BBB
 |  |  |  |  |  | 123458 |  | YYY | ZZZ |  | BBB | GGG | JJJ | KKK | LLL
 |  |  |  |  |  | 123459 |  |  |  |  |  |  |  |  |  | UUU
 |  |  |  |  |  | 123460 |  | YYY |  |  | BBB |  |  |  |  |  | CCC | TTT