tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 329374d1404293303-index-match-and-sumproduct-or-sumif-on-multiple-criteria-o1-book-1-tabkaz-1
Sheet: Sheet2

 |  |  | Table
 |  |  | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday |  |  |  |  | Data sheet
 | Time | Duration |  |  |  |  |  |  |  |  |  |  |  | this should b the answer of 15:00 slot |  |  | Time | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday
 |  |  | 2014-07-01 00:00:00 | 2014-07-02 00:00:00 | 2014-07-03 00:00:00 | 2014-07-04 00:00:00 | 2014-07-05 00:00:00 | 2014-07-06 00:00:00 | 2014-07-07 00:00:00 | 2014-07-08 00:00:00 | 2014-07-09 00:00:00 | 2014-07-10 00:00:00 | Required solution |  |  |  | 14:00:00 | 0.226 | 0.59 | 0.56 | 0.09497 | 0.27667 | 0.71325 | 0.20273
 |  |  |  |  |  |  |  |  |  |  |  |  |  | manual calculation of all days |  |  | 15:00:00 | 0.35603 | 0.89 | 0.41 | 0.04118 | 0.32722 | 0.22469 | 0.04751
 | 15:00:00 | 25 | 1 | 5 | 2 | 2 |  | 5 |  | 5 | 1 | 1 |  |  |  |  | 16:00:00 | 0.09624 | 0.00683 | 0.15 | 0.2659 | 0.1042 | 0.13407 | 0.14101
 | 17:00:00 | 30 | 2 | 2 | 2 | 5 | 6 | 1 | 1 | 1 |  | 1 |  |  |  |  | 17:00:00 | 0.12411 | 0.1502 | 0.18 | 0.15454 | 0.08427 | 0.02839 | 0.24431
 |  |  |  |  |  |  |  |  |  |  |  |  | [It is an array formula] |  |  |  | 18:00:00 | 0.0788 | 0 | 0.1 | 0.12141 | 0.07616 | 0.05667 | 0.2356
 |  |  | Required details
 |  |  | find & match tue rating of 15:00 time in "data sheet" divide by 30 then *total no of spot on tue in table above for 15:00* spot duration for 15:00,  same way addup for all days i.e wed, thu, fri, sat,sun&mon. answer should be in single cell. Table above are dates which can be changed but data sheet sequence of days will remain same way |  |  |  |  |  |  |  |  |  |  |  |  |  | manual calculation of days
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | tue | wed | thu | fri | sat | [NAME] | mon
 | 15:00:00 | 25
 | 17:00:00 | 30
Spreadsheet: 217358d1362052631-help-with-excel-sheet-to-get-output-sales-3-feb-9-feb-2013
Sheet: Sheet5

color | (All)
Sum of qty
style no | Total
CP032 | 1
CP035 | 1
CP036 | 1
CP039 | 3
[NAME] | 2
DP058 | 1
DP083 | 1
[NAME] | 2
DP116 | 2
DP123 | 1
[NAME] | 3
DP152 | 1
[NAME] | 1
DP156 | 1
DP158 | 2
DP159 | 1
DP168 | 1
DP177 | 1
DP180 | 2
DP213 | 1
DP214 | 1
DP228 | 1
DP229 | 1
DP244 | 1
[NAME] | 1
DP308 | 1
DP326 | 1
DP333 | 1
FP038 | 1
FP107 | 1
FP168 | 1
FP185 | 1
GP031 | 1
GP032 | 1
GP124 | 1
[NAME] | 1
GP214 | 1
HP018 | 1
HP040 | 2
HP041 | 1
HP046 | 1
[NAME] | -1
[NAME] | 1
JP009 | 1
JP017 | 1
JP025 | 1
JP050 | 1
JP070 | 2
KP061 | 1
[NAME] | 1
KP101 | 1
KP148 | 1
KP161 | 1
[NAME] | 1
KP178 | 1
KP179 | 2
KP199 | 1
KP207 | 1
KP232 | 1
KP238 | 1
[NAME] | 1
KP255 | 1
PP004 | 1
PP057 | 1
PP079 | 1
PP084 | 1
PP088 | 2
PP100 | 1
SP029 | 1
SP036 | 1
SP061 | 1
SP094 | 2
TP005 | 1
TP061 | 1
TP064 | 1
TP082 | 2
TP093 | 3
TP166 | 1
TP187 | 1
TP204 | 1
WP001 | 1
Grand Total | 96
Spreadsheet: 539456d1506139097-excel-get-all-data-from-another-sheet-ho-status
Sheet: Sheet 1

Date | Tack Pack No | Item | [NAME] | Merchandiser | Season | Cutting Status | [NAME] | Production Status | Finishing Status | [NAME]
17-9-2017 | FZ 284 | Ladies 2 pcs | 280 | Maruf | Eid A 17 |  |  |  |  | 16
 | FZ 282 | Ladies Top | 300 | Maruf | Eid A 17 |  | 309 |  |  | 77
 | SR 308 | Men's Knit Shirt | 200 | Rokon | Eid A 17 | 212 | 212 | 212 | 212 | 210
13-9-2017 | LE 208 | [NAME] | 218 | Arman | Eid A 17 |  | 217 |  | 149
 | LE 209 | [NAME] | 160 | Arman | Eid A 17 |  | 165 | 164 | 164 | 25
16-9-2017 | RB 233 | Men's Shirt | 344 | Rokon | Win-17 |  | 387 | 387 | 387 | 383
19-9-2017 | RT 261 | Ladies Top | 144 | Maruf | Win-17 |  |  |  |  | 107
 | LE 208 | [NAME] | 218 | Arman | Eid A 17 |  | 217 |  | 149
21-9-2017 | SR 309
Spreadsheet: 273875d1382952974-auto-copy-the-row-matter-by-understanding-presiding-cell-location-book1
Sheet: Sheet2

 |  |  | Array formula  is used.
 |  |  | To Enter array formula, After pasting formula
 |  |  |  | Press F2
 |  |  |  | Press Ctrl+Shift+Enter keys.
Spreadsheet: 74218d1274791121-table_array-name-lookup-using-column-header-as-reference-book2
Sheet: Sheet1

 |  | code | amount |  |  |  | DATA
 |  | 1234 | 500 |  |  | 1234
 |  | 1235 | 600 |  |  | 1235
 |  | 1236 | 700 |  |  | 1236
 |  | 1237 | 800 |  |  | 1237
 |  | 1238 | 900 |  |  | 1238
 |  | 1239 | 1000 |  |  | 1239
 |  | 1240 | 1100 |  |  | 1240
 |  | 1241 | 1200 |  |  | 1241
 |  | 1242 | 1300 |  |  | 1242
 |  | 1243 | 1400 |  |  | 1243
 |  | 1244 | 1500 |  |  | 1244
 |  | 1245 | 1600 |  |  | 1245
 |  | 1246 | 1700 |  |  | 1246
 |  | 1247 | 1800 |  |  | 1247
 |  | 1248 | 1900 |  |  | 1248
 |  | 1249 | 2000 |  |  | 1249
 |  | 1250 | 2100 |  |  | 1250
 |  | 1251 | 2200 |  |  | 1251
Spreadsheet: f18becf5-454a-4858-82f2-7136bb5b7115
Sheet: Sheet1

Pos | name | total | country | shooting-PosShooting | shooting-PerfShooting | shooting-Shooting | fencing-pos | fencing-victories | fencing-defeats | fencing-points | fencing-status | swimming-pos | swimming-time | swimming-points | swimming-status | riding-pos | riding-points | riding-time | riding-status | riding-coursepen | riding-timepen | running-pos | running-time
1 | Hungary | 5504 | HUN | 7 | 263 | 1060 | 4 | 60 |  | 808 |  | 1 | 2:59.51 | 1368 |  | 1 | 1184 |  |  |  |  | 2 | 15:09.25
2 | Hungary  /  Great Britain | 5468 | GBR | 1 | 270 | 1144 | 5 | 58 |  | 784 |  | 2 | 3:06.45 | 1284 |  | 2 | 1136 |  |  |  |  | 1 | 15:00.44
3 | Hungary  /  Great Britain  /  Poland | 5332 | POL | 11 | 254 | 952 | 1 | 76 |  | 1000 |  | 10 | 3:13.56 | 1200 |  | 7 | 1120 |  |  |  |  | 6 | 15:15.05
4 | Hungary  /  Great Britain  /  Poland  /  Germany | 5240 | GER | 9 | 256 | 976 | 3 | 63 |  | 844 |  | 4 | 3:09.91 | 1244 |  | 9 | 1104 |  |  |  |  | 5 | 15:12.75
5 | Hungary  /  Great Britain  /  Poland  /  Germany  /  Italy | 5206 | ITA | 2 | 269 | 1132 | 7 | 50 |  | 688 |  | 7 | 3:12.22 | 1216 |  | 8 | 1110 |  |  |  |  | 7 | 15:15.67
6 | Hungary  /  Great Britain  /  Poland  /  Germany  /  Italy  /  Russia | 5168 | RUS | 12 | 247 | 868 | 2 | 67 |  | 892 |  | 6 | 3:11.25 | 1228 |  | 9 | 1104 |  |  |  |  | 3 | 15:11.08
7 | Hungary  /  Great Britain  /  Poland  /  Germany  /  Italy  /  Russia  /  Ukraine | 5074 | UKR | 3 | 266 | 1096 | 12 | 40 |  | 568 |  | 9 | 3:09.89 | 1204 |  | 5 | 1130 |  |  |  |  | 4 | 15:11.80
8 | Hungary  /  Great Britain  /  Poland  /  Germany  /  Italy  /  Russia  /  Ukraine  /  Lithuania | 5008 | LTU | 9 | 256 | 976 | 10 | 45 |  | 628 |  | 8 | 3:09.01 | 1212 |  | 2 | 1136 |  |  |  |  | 8 | 15:16.18
9 | Hungary  /  Great Britain  /  Poland  /  Germany  /  Italy  /  Russia  /  Ukraine  /  Lithuania  /  Czech Republic | 4792 | CZE | 5 | 264 | 1072 | 9 | 49 |  | 676 |  | 3 | 3:09.19 | 1252 |  | 11 | 992 |  |  |  |  | 12 | 16:20.61
10 | Hungary  /  Great Britain  /  Poland  /  Germany  /  Italy  /  Russia  /  Ukraine  /  Lithuania  /  Czech Republic  /  Belarussia | 4708 | BLR | 3 | 266 | 1096 | 6 | 55 |  | 748 |  | 11 | 3:18.90 | 1136 |  | 13 | 820 |  |  |  |  | 10 | 15:53.14
11 | Hungary  /  Great Britain  /  Poland  /  Germany  /  Italy  /  Russia  /  Ukraine  /  Lithuania  /  Czech Republic  /  Belarussia  /  China | 4682 | CHN | 5 | 264 | 1072 | 7 | 50 |  | 688 |  | 5 | 3:10.36 | 1236 |  | 12 | 858 |  |  |  |  | 11 | 16:13.38
12 | Hungary  /  Great Britain  /  Poland  /  Germany  /  Italy  /  Russia  /  Ukraine  /  Lithuania  /  Czech Republic  /  Belarussia  /  China  /  Mexico | 4600 | MEX | 8 | 262 | 1048 | 11 | 43 |  | 604 |  | 12 | 3:27.76 | 1028 |  | 4 | 1132 |  |  |  |  | 13 | 16:23.33
13 | Hungary  /  Great Britain  /  Poland  /  Germany  /  Italy  /  Russia  /  Ukraine  /  Lithuania  /  Czech Republic  /  Belarussia  /  China  /  Mexico  /  United States | 4384 | USA | 13 | 246 | 856 | 13 | 36 |  | 520 |  | 13 | 3:38.94 | 856 |  | 6 | 1128 |  |  |  |  | 9 | 15:24.76
Spreadsheet: 866274d1713228989-help-for-creating-major-league-table-24-soeyaza-
Sheet: Setting

 | R | Team | Last Year Rank | M | P | W | D | L | F | A | [NAME] | Pt | P | W | D | L | F | A | [NAME] | Pt | P | W | D | L | F | A | [NAME] | Pt | Pt Rank | GD Rank | F Rank | Last Year Position
 | R | Team | Last Year Rank | M | P | W | D | L | F | A | [NAME] | Pt | P | W | D | L | F | A | [NAME] | Pt | P | W | D | L | F | A | [NAME] | Pt | Pt Rank | GD Rank | F Rank | Last Year Position
 |  |  |  | 6
 |  |  |  | 6
 |  |  |  | 6
 |  |  |  | 6
 |  |  |  | 6
 |  |  |  | 6
 |  |  |  | 6
 |  |  |  | 6
 |  |  |  | 6
 |  |  |  | 6
 |  |  |  | 6
 |  |  |  | 6
 |  |  |  | 6
 |  |  |  | 6
 |  |  |  | 6
 |  |  |  | 6
 |  |  |  | 6
 |  |  |  | 6
 |  |  |  | 6
 |  |  |  | 6
 |  |  |  | 6
 |  |  |  | 6
 |  |  |  | 6
 |  |  |  | 6
Spreadsheet: 328310d1403867068-multiple-true-statements-but-need-one-to-override-the-other-example-workbook-for-forum-jacc
Sheet: TEKNE CUTTING SHEET (2)

ITEM | [NAME] | QTY | LENGTH | WIDTH | THKNS | MATERIAL | P/S | COMMENTS |  | L+ | W+ | THK+ |  | LENGTH | WIDTH | THK |  | LENGTH | WIDTH | THKNS
1 | PANEL 1 | 1 | 500 | 44 | 18 | MDF |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | After Material Name
2 | TIE RAIL S/WOOD | 1 | 500 | 44 | 19 | SOFTWOOD
3 | PANEL 1 EDGING | 1 | 500 | 18 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | < = Adds 100mm  TO LENGTH
4 | Oak post | 1 | 500 | 44 |  | oak |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | > = For tennons this adds 2x material width & rounds up to the nearest 100mm TO LENGTH
5 | worktop | 1 | 500 | 44 |  | zebrano >
6 | door lipping | 1 | 500 | 42 | 3 | poplar
7 | oak edging | 1 | 500 | 44 |  | oak
8 |  | 1 | 500 | 44
9 |  | 1 | 500 | 44
10 |  | 1 | 500 | 44
11 |  | 1 | 500 | 44
12 |  | 1 | 500 | 44
13 |  | 1 | 500 | 44
14 |  | 1 | 500 | 44
15 |  | 1 | 500 | 44
16 |  | 1 | 500 | 44
Spreadsheet: 31355d1227177365-multiple-dependent-dropdown-sample
Sheet: Sheet1

Department | Sub Department | Item
Marketing | [NAME] | Team A
Accounts | Unit 2 | Current Account
Department | Sub Department | Item
Accounts | Unit 1 | New account
 |  | Old account
 | Unit 2 | current account
 |  | Not so current acccount
 | Unit 3 | other acccounts
Marketing | [NAME] | Team A
 |  | Team B
 | [NAME] | Best Team
 |  | Bad Team
Finance | Fin1 | Office Team
 |  | Client Team
 | Fin2 | Other Fin matters
Sales | Sales 1 | Area 1
 |  | Area 2
 | Sales 2 | Mexico
 |  | Germany
Spreadsheet: 831596d1685743795-dynamically-referencing-excel-question
Sheet: Sheet2

Examples | ACC | EXM | FRT | FSC | INF | MSC | Grand Total
Example 1 |  | 0 | 10 | 20 | 0 | 0 | 6500
Example 2 |  | 0 | 15 | 65 |  |  | 4.07
Example 3 |  | 0 | 95 | 12 |  |  | 7.6
Example 4 |  | 0 | 13.8 | 2.48 |  |  | 16.28
Example 5 |  | 0 | 56 | 0.62 |  |  | 11.67
Example 6 |  | 0 | 13.8 | 2.48 |  |  | 16.28
Example 7 |  | 0 | 11.05 | 0.62 |  |  | 11.67
Example 8 |  | 0 | 11.05 | 0.62 |  |  | 11.67
Example 9 |  | 0 | 11.05 | 0.62 |  |  | 11.67
Example 10 |  | 0 | 14.5 | 1.24 |  |  | 15.74
Example 11 |  | 0 | 6.9 | 1.24 |  |  | 8.14
Spreadsheet: 218703d1362547231-extract-certain-value-and-combine-sample-data-ans
Sheet: Sample 1

A | B | C | D |  |  |  |  |  | Expected result:
[NAME] | group1111 | group2222 | group8293 | 1234, 1111, 2222, 8293 |  |  |  |  | 1234, 1111, 2222, 8293
group2222 | group4444 | [NAME] | [NAME] | 2222, 4444, 1122, 8888 |  |  |  |  | 2222, 4444, 1122, 8888
group3210 | group7777 | group22 | [NAME] | 3210, 7777, 22, 9483
group4198 | group11110 | group1078 | group10078 | 4198, 11110, 1078, 10078
Spreadsheet: 679963d1590705778-help-with-datedif-wrapped-with-iferror-function-datedif-wrapped-with-iferror
Sheet: Sheet1

Houses | Prior Sale Date | Current Sale Date | Yrs & Mth
House 1 |  | 2020-05-15 00:00:00 |  |  | Datedif formula in column D.
House 2 | 2017-01-02 00:00:00 | 2019-02-12 00:00:00 |  |  | If column B is blank, would like to show "No Prior Sale Date"
House 3 |  | 2018-12-31 00:00:00 |  |  | in column D.
House 4 | 2008-10-21 00:00:00 | 2019-10-07 00:00:00
House 5 | 2009-05-12 00:00:00 | 2017-06-13 00:00:00
House 6 | 2009-12-01 00:00:00 | 2017-12-31 00:00:00
House 7 | 2010-06-22 00:00:00 | 2018-07-08 00:00:00
House 8 | 2008-12-31 00:00:00 | 2019-01-19 00:00:00
House 9 | 2011-09-02 00:00:00 | 2019-08-02 00:00:00
House 10 | 2012-02-21 00:00:00 | 2020-02-13 00:00:00
House 11 |  | 2020-08-26 00:00:00
Spreadsheet: 216492d1361789823-equation-help-for-military-database-height-and-weight
Sheet: Height & Weight

Height and Weight
NAMES | GENDER | AGE | HT | WT | MAX WT | lbs OVER | PASS/FAIL
 | M | 27 | 65 | 157
 | M | 32 | 74 | 212
 | M | 19 | 68 | 188
 | M | 22 | 65 | 178
 | M | 19 | 67 | 171
 | F | 28 | 59 | 121
 | F | 18 | 64 | 153
 | M | 25 | 70 | 227
 | M | 19 | 71 | 213
 | F | 22 | 65 | 141
 | F | 18 | 58 | 111
 | F | 24 | 62 | 125
 | F | 21 | 60 | 118
 | M | 20 | 71 | 155
 | M | 19 | 65 | 158
 | M | 22 | 68 | 150
 | F | 18 | 62 | 123
 | M | 21 | 69 | 182
 | M | 21 | 65 | 133
 | M | 21 | 69 | 171
 | M | 19 | 71 | 182
 | F | 22 | 60 | 138
 | F | 23 | 62 | 133
 | F | 23 | 68 | 148
 | F | 18 | 63 | 111
 | M | 21 | 69 | 198
 | M | 31 | 71 | 164
 | F | 19 | 64 | 122
 | M | 23 | 70 | 160
 | M | 20 | 65 | 139
 | M | 22 | 67 | 162
 | F | 19 | 70 | 153
 | M | 27 | 75 | 208
 | M | 21 | 69 | 168
 | M | 30 | 67 | 162
 | F | 20 | 62 | 124
 | F | 18 | 60 | 133
 | F | 23 | 68 | 172
 | M | 26 | 67 | 162
 | M | 23 | 64 | 162
 | F | 22 | 66 | 112
 | M | 19 | 67 | 133
 | M | 21 | 68 | 167
 | M | 20 | 71 | 153
 | F | 22 | 61 | 122
 | M | 21 | 75 | 178
 | M | 18 | 68 | 161
 | M | 28 | 71 | 174
 | F | 20 | 68 | 168
Spreadsheet: 110172d1306929716-finding-if-price-data-between-cells-satisfies-conditions-copy-of-findvalue
Sheet: Sheet1

 | Price |  | Action | Test Y to 1st x back | Test Y to 2nd x back | Test Y to 3rd x back | etc
2009-04-10 00:00:00 | 94.45 | x
2009-04-17 00:00:00 | 121 | x
2009-04-24 00:00:00 | 93.3
2009-05-01 00:00:00 | 93.5 | x | Y
2009-05-08 00:00:00 | 93.2
2009-05-15 00:00:00 | 94.65
2009-05-22 00:00:00 | 100.5 | x | Y |  |  |  | Indicates if cell(d8)= Y then find if price at previous x is > than all prices from x+1 to subsequent Y
2009-05-29 00:00:00 | 103.7
2009-06-05 00:00:00 | 102.1
2009-06-12 00:00:00 | 100 | x
2009-06-19 00:00:00 | 99.9
2009-06-26 00:00:00 | 103.3
2009-07-03 00:00:00 | 94.65 |  | Y |  |  |  | Indicates if cell(d14)= Y then find if price at previous x is > than all prices from x+1 to subsequent Y
2009-07-10 00:00:00 | 93.5
2009-07-17 00:00:00 | 103.7
 |  | Test is to see if in column D = 'Y' then test to find if price at previous x is > or < than all prices from x+1 to subsequent Y
Spreadsheet: 735385d1622921705-count-rows-with-same-numbers-count-rows-that-contain-certain-combinations-patpcv-
Sheet: Sheet1

 |  |  |  |  | 1 | 2 | 3
 |  |  |  |  | 2 | 3 | 4
 |  |  |  |  | 3 | 4 | 5
1 | 2 | 3 | 4 | 5
3 | 4 | 5 | 9 | 0
4 | 5 | 1 | 2 | 3
Spreadsheet: 856509d1705728456-how-to-solve-the-problem-of-finding-the-last-0-numbers-in-a-formula-excel-1-ans
Sheet: Sheet1

 | B1 | B2 | B3 | B4 | B5 | B6 | B7 | B8 | B9 |  | RESULT
A1 | 2 | 2 | 2 | 0 | 0 | 1 | 0 | 0 | 0 |  | 3
A2 | 0 | 4 | 2 | 2 | 0 | 0 | 0 | 0 | 2 |  | 0
A3 | 2 | 3 | 1 | 0 | 0 | 0 | 0 | 1 | 0 |  | 1
A4 | 0 | 4 | 0 | 0 | 1 | 1 | 0 | 0 | 0 |  | 3
A5 | 0 | 4 | 2 | 0 | 0 | 0 | 0 | 1 | 0 |  | 1
A6 | 0 | 0 | 0 | 0 | 7 | 0 | 5 | 0 | 0 |  | 2
A7 | 9 | 5 | 0 | 10 | 2 | 2 | 0 | 0 | 0 |  | 3
A8 | 0 | 0 | 2 | 0 | 2 | 0 | 0 | 0 | 0 |  | 4
A9 | 2 | 0 | 0 | 3 | 4 | 0 | 0 | 0 | 0 |  | 4
A10 | 2 | 0 | 3 | 2 | 2 | 0 | 0 | 0 | 0 |  | 4
A11 | 0 | 5 | 2 | 0 | 12 | 0 | 0 | 0 | 0 |  | 4
A12 | 2 | 4 | 7 | 2 | 2 | 0 | 0 | 0 | 0 |  | 4
A13 | 2 | 0 | 0 | 3 | 0 | 0 | 0 | 0 | 0 |  | 5
Spreadsheet: 858714d1707298481-creating-a-button-to-flick-between-forecast-and-actuals-new-forecasting-template-draft-to-share-v2
Sheet: Contigency & Risk

 | Contigency | Current year | 24/25 Forecast | 25/26 Forecast | 26/27 Forecast | 27/28 Forecast | 28/29 Forecast | Anticipated Final Cost (AFC)
Spreadsheet: 82467d1282554585-baseline-v-current-graph-please-example
Sheet: Sheet1

currentEnd Date | baseline end date | current value | baseline value
2009-12-01 00:00:00 | 2009-12-01 00:00:00 | 8365.95 | 8365.95
2010-06-01 00:00:00 | 2010-06-01 00:00:00 | 7634.7 | 7634.7
2010-09-01 00:00:00 | 2009-12-01 00:00:00 | 7434.7 | 7597.2
2010-09-01 00:00:00 | 2010-05-01 00:00:00 | 7334.7 | 7578.45
2010-10-01 00:00:00 | 2010-03-01 00:00:00 | 7284.7 | 7528.45
2010-10-01 00:00:00 | 2009-12-01 00:00:00 | 7234.7 | 7503.45
2010-11-01 00:00:00 | 2010-12-01 00:00:00 | 4384.7 | 6078.45
Dec 10 | 2010-12-01 00:00:00 | 4381.2 | 6073.45
2011-01-01 00:00:00 | 2011-01-01 00:00:00 | 4373.7 | 6065.95
2011-03-01 00:00:00 | 2010-12-01 00:00:00 | 2948.7 | 4640.95
2011-07-01 00:00:00 | 2011-04-01 00:00:00 | 2939.7 | 4631.95
2011-07-01 00:00:00 | 2010-11-01 00:00:00 | 2929.7 | 4616.95
2011-07-01 00:00:00 | 2009-12-01 00:00:00 | 2344.7 | 4279.45
2014-01-01 00:00:00 | 2014-01-01 00:00:00 | 1706.3 | 3880.45
2014-01-01 00:00:00 | 2014-01-01 00:00:00 | 1227.5 | 3720.85
2015-05-01 00:00:00 | 2015-05-01 00:00:00 | 935 | 3045.85
2015-12-01 00:00:00 | 2011-01-01 00:00:00 | 747.5 | 2858.35
Spreadsheet: 684429d1593363129-pair-up-values-in-one-range-area-with-values-in-other-range-area-book1
Sheet: Sheet1

Group One | A | B | C | D | E |  |  | A | B | C | D | E
 | 5 | 3 | 7 | 6 | 4 |  |  | A III |  | C II | D II | E III
 |  |  |  |  |  |  |  | A IV |  | C III | D III | E IV
 |  |  |  |  |  |  |  | A V |  | C IV | D IV
Group Two | I | II | III | IV | V |  |  |  |  | C V | D V
 | 2 | 4 | 7 | 6 | 5
Rules
1. If value of a cell in group-1 is more than 5 (--> 6 and 7), it's paired up with value of cell in group-2 which is more than 4 (--> 5, 6 and 7)
2. If value of a cell in group-1 is 4, it's paired up with value of cell in group-2 which is more than 5 (-->  6 and 7)
3. Those pairs will be put in yellow area
Spreadsheet: 769623d1645621674-delete-every-5th-row-year_202020-1-
Sheet: indexQuarterly

 | Q1-12 | Q2-12 | Q3-12 | Q4-12 | Q1-13 | Q2-13 | Q3-13 | Q4-13 | Q1-14 | Q2-14 | Q3-14 | Q4-14 | Q1-15 | Q2-15 | Q3-15 | Q4-15 | Q1-16 | Q2-16 | Q3-16 | Q4-16 | Q1-17 | Q2-17 | Q3-17 | Q4-17 | Q1-18 | Q2-18 | Q3-18 | Q4-18 | Q1-19 | Q2-19 | Q3-19 | Q4-19 | Q1-20 | Q2-20
T-shirt.
sweater.
jacket.
coat.
jeans.
socks.
shorts.
tracksuit.
 |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 6 | 7 | 8 | 9 | 11
 | sample Values not needed from above table
 | 93.2608376235391 | 90.83254999759933 | 89.56546904526176 | 80.27085287788354
 | 106.5378389543991 | 99.94188150255873 | 98.82503624831472 | 97.89996934899409
 | 91.25320501957096 | 96.20834399503755 | 97.52793678085578 | 140.5560126579401
 | 215.5800314017861 | 264.7829638069842 | 243.6291808098106 | 134.445471023327
 | 146.5818625388688 | 152.03055761919 | 178.6002716725876 | 165.9930261521648
 | 120.3111867971363 | 114.7487608967639 | 138.4389974649735 | 95.3627880627627
 | 110.6963761638244 | 113.6324027259957 | 101.6991069024572 | 138.9661556898088
 | 99.60445723901493 | 101.9105690404659 | 101.1812331283436 | 98.78866624654627
 | sample result |  | only quarterly values being retrieved
Spreadsheet: jeff_dasovich__14234__Vons Model
Sheet: Trading Comps

 | Appendix 7
 | Comparable Company Analysis
 |  |  |  |  |  |  |  |  |  |  | Free
 |  |  |  |  |  |  |  |  |  | Book value | Cash flow |  | Price to . . .
 |  |  | Price | Shares o/s |  | 1996 |  |  |  | per share | per share |  |  |  |  | Book | Free Cash
 |  |  | 12/15/96 | (millions) |  | Sales | EBITDA | Net income |  | 12/31/96 | 12/31/96 |  | Sales | EBITDA | Earnings | Value | Flow
 | Delchamps, Inc. | regional | 20 | 7.1 |  | 1126.6 | 34.9 | 3.9 |  | 15.88 | 5.5
 | Food Lion, Inc. | regional | 8.625 | 470.2 |  | 9005.9 | 593.2 | 206.1 |  | 2.59 | 0.67
 | Giant Food Inc. | regional | 32.875 | 59.4 |  | 3860.6 | 274.9 | 102.2 |  | 13.82 | 3.35
 | Hannaford Bros. Co. | regional | 32.25 | 42.3 |  | 2957.6 | 224.2 | 75.2 |  | 13.46 | 4.76
 | Quality Food Centers, Inc. | regional | 34.75 | 14.9 |  | 805.3 | 64.8 | 25.4 |  | 5.24 | 3.42
 | Weis Markets, Inc. | regional | 32.875 | 42.3 |  | 1753.2 | 128.8 | 78.9 |  | 19.47 | 2.45
 | Winn Dixie Stores, Inc. | regional | 31.5 | 151.6 |  | 12955.5 | 538.8 | 255.6 |  | 8.85 | 3.69
 | American Stores Company | multi-regional | 19.375 | 293.9 |  | 18308.9 | 1111.4 | 316.8 |  | 8.04 | 2
 | The Great Atl. & Pacific Tea Co. | multi-regional | 30.625 | 38.2 |  | 10101.4 | 377.2 | 57.2 |  | 21.53 | 6.85
 | The Kroger Co. | highly leveraged | 21.5625 | 262.8 |  | 25170.9 | 1211.1 | 349.9 |  | -4.66 | 1.82
 | Smith's Food & Drug Centers | highly leveraged | 29.375 | 19.5 |  | 2890 | 197.5 | -164.2 |  | -7.73 | 4.21
Spreadsheet: 9619e948-78d3-4870-81d5-92193e117fec
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
42698435 | 2014-08-12 22:40:16 | AXIS | 1 | 7 | 5 | 1526787 | browndog | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
42724663 | 2014-08-14 21:23:59 | AXIS | 1 | 6 | 5 | 789097 | Itsvan | 12498 | western | 1944-07-11 |  | [Normandy] Bretel Wood | [NAME]
42724931 | 2014-08-14 21:40:57 | ALLIES | 0 | 3 | 6 | 789097 | Itsvan | 12498 | western | 1944-07-11 |  | [Normandy] Bretel Wood | [NAME]
Spreadsheet: 803758d1667666893-learn-chess-with-excel-how-to-detect-checkmate-learn-chess-with-excel-pw2
Sheet: Pieces

Figurines | Español | English | Française | Italiano | Deutsch | Português
♔ | R | K | R | R | K | R
♕ | D | Q | D | D | D | D
♖ | T | R | T | T | T | T
♗ | A | B | F | A | L | B
♘ | C | N | C | C | S | C
♙ | P | P | P | P | B | P
♚ | r | k | r | r | k | r
♛ | d | q | d | d | d | d
♜ | t | r | t | t | t | t
♝ | a | b | f | a | l | b
♞ | c | n | c | c | s | c
♟ | p | p | p | p | b | p
Spreadsheet: 807457d1669908472-index-match-data-from-two-tables-test1
Sheet: Sheet1

 | TABLE 1 |  |  |  |  |  |  |  |  |  |  |  |  | TABLE 2 |  |  |  |  |  |  | TABLE 3 - DESIRED ANSWER
Doc Number | R1 Baseline | R1 Forecast | R1 Actual | R1 Cancelled | [NAME] | [NAME] | A1 Actual | A1 Cancelled | [NAME] | [NAME] | C1 Actual | [NAME] |  | Planned  IDC | Forecast  IDC | Planned  AFC | Forecast  AFC | Planned  IFU | Forecast  IFU |  | Planned  IDC | Forecast  IDC | Planned  AFC | Forecast  AFC | Planned  IFU | Forecast  IFU
110-001 | A | H |  |  | O | V |  |  | CC | JJ |  |  |  | R1 Baseline | R1 Forecast | [NAME] | [NAME] | [NAME] | [NAME]
110-002 | B | I |  |  | P | W |  |  | DD | KK |  |  |  | R1 Baseline | R1 Forecast | [NAME] | [NAME] | [NAME] | [NAME]
110-003 | C | J |  |  | Q | X |  |  | EE | LL |  |  |  | [NAME] | [NAME] | R1 Baseline | R1 Forecast | [NAME] | [NAME]
110-004 | D | K |  |  | R | Y |  |  | FF | MM |  |  |  | [NAME] | [NAME] | R1 Baseline | R1 Forecast | [NAME] | [NAME]
110-005 | E | L |  |  | S | Z |  |  | GG | NN |  |  |  | [NAME] | [NAME] | R1 Baseline | R1 Forecast | [NAME] | [NAME]
110-006 | F | M |  |  | T | AA |  |  | HH | OO |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
110-007 | G | N |  |  | U | BB |  |  | II | PP |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
Spreadsheet: 882749d1731192524-help-with-textsplit-textbefore-textafter-and-vstack-excel-helped
Sheet: Promotions

Text To Columns 1 | Text To Columns 2 | Text To Columns 3 |  | VSTACK |  | Value | Trim |  | Promo Code | Usages | Value |  | Driver Promotions | Usages | Pay Out |  | Restaurant Promotions | Usages | Value | Pay Out
 |  |  |  |  |  |  |  |  |  |  |  |  | TONY516 |  |  |  | Get 5% Off Gurkha!
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Get 5% Off Balti Curries!
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Get 5% Off Curry Corner!
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Get 5% Off BLT!
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] Wednesday's at Gurkha
 | £2.22 - TONY516
 | £3.25 - HELEN
 | £2.18 - STUDY10
 | £0.01 - FREE Dip With Every Pizza
Spreadsheet: 886024d1735974280-how-to-automatically-add-entry-on-one-sheet-based-on-another-sheet-test-1
Sheet: Merdistric Lanao del Norte

Biometrics | Full Name
Spreadsheet: 58622d1258885819-dragging-formulas-that-refer-across-sheets-dummysheet
Sheet: Sheet1

Year |  | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2004 | 2005
Period |  | Jan | Feb | March | April | May | June | Jan | Jan
[NAME]
Bar Revenue |  | 1400 | 3209 | 213432 | 23432 | 23432 | 23432 | 23432 | 23432