tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 739396d1625672174-configurable-match-from-two-sheets-of-data-configurable-sheet-ans
Sheet: Beta

Beta | x | y | z | Sum | 1 | 2 | 3 | 4 | 5
1 | 39 | 23 | 18 | 80 |  | 8.717797887081348 | 5.830951894845301 | 2.82842712474619
2 | 33 | 21 | 12 | 66 | 8.717797887081348 |  | 4.69041575982343 | 10.77032961426901 | 4.898979485566356
3 | 36 | 19 | 15 | 70 | 5.830951894845301 | 4.69041575982343 |  | 8.366600265340756 | 5.099019513592784
4 | 41 | 25 | 18 | 84 | 2.82842712474619 | 10.77032961426901 | 8.366600265340756 |  | 10.77032961426901
5 | 37 | 19 | 10 | 66 | 4.35889894354067 | 4.898979485566356 | 5.099019513592784 | 10.77032961426901
Spreadsheet: 164941d1340965750-help-adding-up-data-from-a-table-example1
Sheet: Pivot

Name | [NAME]
Type | TI
Values
Sum of Jan | Sum of Feb | Sum of Mar | Sum of Apr | Sum of May | Sum of Jun | Sum of Jul | Sum of Aug | Sum of Sep | Sum of Oct
1003 | 1049 | 970 | 1058 | 951 | 1056 | 753 | 942 | 1059 | 1110
Spreadsheet: 71834d1272542930-tables-drilling-down-and-interrogation-table-interogation-a
Sheet: Sheet1

 | TABLE 4D1A
 | Conductor CSA | Reference method A  Enclosed in conduit in thermally insulating wall etc) |  | Reference method B Enclosed in conduit on a wall or in trunking etc) |  | Reference method C Clipped direct |  | Reference method F (in free air or on perforated cable tray horizontal or vertical)
 |  |  |  |  |  |  |  | Touching |  |  | Spaced by one diameter
 |  | 2 cables, single-phase a.c. or d.c. | 3 or 4 cables, three-phase a.c. | 2 cables, single-phase a.c. or d.c. | 3 or 4 cables, three-phase a.c. | 2 cables, single-phase a.c. or d.c. flat and touching | 3 or 4 cables, three-phase a.c. flat and touching and trefoil | 2 cables, single-phase a.c. or d.c. flat | 3 cables, three-phase a.c. flat | 3 cables, three-phase a.c. trefoil | 2 cables, single-phase a.c. or d.c. or 3 cables three-phase a.c. flat
 |  |  |  |  |  |  |  |  |  |  | Horizontal | Vertical
 | 1 | 11 | 10.5 | 13.5 | 12 | 15.5 | 14
 | 1.5 | 14.5 | 13.5 | 17.5 | 15.5 | 20 | 18
 | 2.5 | 20 | 18 | 24 | 21 | 27 | 25
 | 4 | 26 | 24 | 32 | 28 | 37 | 33
 | 6 | 34 | 31 | 41 | 36 | 47 | 43
 | 10 | 46 | 42 | 57 | 50 | 65 | 59
 | 16 | 61 | 56 | 76 | 68 | 87 | 79
 | 25 | 80 | 73 | 101 | 89 | 114 | 104 | 131 | 114 | 110 | 146 | 130
 | 35 | 99 | 89 | 125 | 110 | 141 | 129 | 162 | 143 | 137 | 181 | 162
 | 50 | 119 | 108 | 151 | 134 | 182 | 167 | 196 | 174 | 167 | 219 | 197
 | 70 | 151 | 136 | 192 | 171 | 234 | 214 | 251 | 225 | 216 | 281 | 254
 | 95 | 182 | 164 | 232 | 207 | 284 | 261 | 304 | 275 | 264 | 341 | 311
 | 120 | 210 | 188 | 269 | 239 | 330 | 303 | 352 | 321 | 308 | 396 | 362
 | 150 | 240 | 216 | 300 | 262 | 381 | 349 | 406 | 372 | 356 | 456 | 419
 | 185 | 273 | 245 | 341 | 296 | 436 | 400 | 463 | 427 | 409 | 521 | 480
 | 240 | 321 | 286 | 400 | 346 | 515 | 472 | 546 | 507 | 485 | 615 | 569
 | 300 | 367 | 328 | 458 | 394 | 594 | 545 | 629 | 587 | 561 | 709 | 659
 | 400 |  |  | 546 | 467 | 694 | 634 | 754 | 689 | 656 | 852 | 795
 | 500 |  |  | 626 | 533 | 792 | 723 | 868 | 789 | 749 | 982 | 920
 | 630 |  |  | 720 | 611 | 904 | 826 | 1005 | 905 | 855 | 1138 | 1070
 | 800 |  |  |  |  | 1030 | 943 | 1086 | 1020 | 971 | 1265 | 1188
 | 1000 |  |  |  |  | 1154 | 1058 | 1216 | 1149 | 1079 | 1420 | 1337
Spreadsheet: chris_germany__2076__TW Compressor Gas 1_02
Sheet: Dec 2001

ECT - Enron Compressor Gas Sold to Richardson |  |  |  |  |  | contract 27789
Date | Nomed | Flowed
2001-12-22 00:00:00 | 25000 | 25000
2001-12-23 00:00:00 | 25000 | 25000
2001-12-24 00:00:00 | 25000 | 25000
2001-12-25 00:00:00 | 25000 | 25000
2001-12-26 00:00:00 | 25000 | 25000
2001-12-27 00:00:00 | 25000 | 25000
2001-12-28 00:00:00 | 25000 | 25000
2001-12-29 00:00:00 | 25000 | 25000
2001-12-30 00:00:00 | 25000 | 25000
2001-12-31 00:00:00 | 25000 | 25000
Spreadsheet: 709562d1608391157-change-formula-to-ignore-hidden-tabs-programme-test
Sheet: Block 5

Item Name | Price | 52 | 53 | 1 | 2 | 3 | 4 | 5 | 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 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | Total | Totals
Product 1 | 0.05
Product 2 | 0.1
Product 3 | 0.15
Product 4 | 0.2
Product 5 | 0.25
Product 6 | 0.3
Product 7 | 0.35
Product 8 | 0.4
Product 9 | 0.45
Product 10 | 0.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | @ |  | 0.0001 |  |  |  |  |  | Pol:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | + 20% VAT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Block | Area | Area | Perimeter (glass/path)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Block 1 | 23490 | A | 950
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Block 2 | 6441 | B | 840
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Block 3 | 5698 | C | 420
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Block 4 | 8728 | D | 1120
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Block 5 | 2508 | E | 400
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Block 6 | 13440 | F | 760
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Block 7 | 14976 | G | 820
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Block 8 | 14940 | H | 820
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Block 9 | 5455 | I | 430
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Block 10 | 5698 | J | 430
Spreadsheet: darrell_schoolcraft__7776__imbalsumm0106
Sheet: mewborne

 | [NAME]
 | 500174 |  | 53888 |  | 78060 |  | 78062
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 6274 | 6163 |  |  | 1156 | 1178 | 2098 | 1619
2 | 6245 | 6163 |  |  | 1038 | 1178 | 2024 | 1619
3 | 6272 | 6163 |  |  | 1004 | 1178 | 1965 | 1619
4 | 6068 | 6163 |  |  | 1008 | 1178 | 2150 | 1619
5 | 5977 | 6163 |  |  | 571 | 1178 | 1663 | 1619
6 | 6200 | 6163 |  |  | 695 | 1178 | 1911 | 1619
7 | 6546 | 6163 |  |  | 743 | 1178 | 2009 | 1619
8 | 6547 | 6163 |  |  | 923 | 1178 | 1207 | 1619
9 | 6522 | 6163 |  |  | 848 | 1178 | 2085 | 1619
10 | 6446 | 6163 |  |  | 686 | 1178 | 2052 | 1619
11 | 6297 | 6163 |  |  | 238 | 1178 | 1968 | 1619
12 |  |  |  |  | 875 | 1178 | 1999 | 1619
13 |  |  |  |  | 843 | 1178 | 1962 | 1619
14 |  |  |  |  | 1056 | 1178 | 1914 | 1619
15 |  |  |  |  | 805 | 1178 | 1974 | 1619
16 |  |  |  |  | 823 | 1178 | 1941 | 1619
17 |  |  |  |  | 1000 | 1178 | 1910 | 1619
18 |  |  |  |  | 414 | 1178 | 1874 | 1619
19
20
21
22
23
24 |  |  |  |  |  |  |  |  |  |  | 377
25 |  |  |  |  |  |  |  |  |  |  | 725
26
27
28
29
30
31
2001-05-31 00:00:00 |  |  |  |  |  |  |  |  | 362097.29
2001-06-18 00:00:00
Spreadsheet: 7b29fe1d-eb1d-4c1e-8702-24c397669d53
Sheet: Sheet1

Table 7--Peanuts:  U.S. supply and disappearance | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
 | Area |  | Yield |  | Supply |  |  |  |  |  | Disappearance
Year begin. | Planted | Harvested |  | Beginning |  |  |  |  | Domestic |  | Seed & |  |  | Ending
Aug. 1 |  |  |  | stocks | Imports | Production | Total |  | food | Crush | residual | Exports | Total | stocks
 | ------1,000 acres-------- |  | Pounds/acre |  |  |  | Million pounds
2010/11 | 1288 | 1255 | 3312.223107569721 | 1828.748 | 64.5919124166918 | 4156.84 | 6050.179912416692 |  | 2839.7 | 586.553 | 502.4034567803826 | 605.5844556363093 | 4534.240912416692 | 1515.939
2011/121 | 1140.6 | 1097.6 | 3312.973760932945 | 1515.939 | 215 | 3636.32 | 5367.259 |  | 2845 | 610 | 377.259 | 525 | 4357.259 | 1010
2012/132 | 1526 | 1486 | 3561.843876177658 | 1010 | 100 | 5292.9 | 6402.9 |  | 2939 | 595 | 519.8999999999996 | 665 | 4718.9 | 1684
1 Estimated.  2 Forecast.
Sources: USDA, National Agricultural Statistics Service, Crop Production and Peanut Stocks and Processing,and U.S. Department of Commerce,
U.S. Census Bureau, Foreign Trade Statistics.
Last update: | 2012-08-13 23:24:03.630000
Spreadsheet: 544319d1508857239-noob-question-conditional-formatting-temp-tracker
Sheet: Sheet1

Name | Area | Store | Position | Start Date | End Date | Introduction | Spirit | Intro 6 Steps | Product | Sistem 51 | Touch | Complete
[NAME] | South | Oxford Street | SA | 31/09/2017 | 2017-03-31 00:00:00 | 2017-10-02 00:00:00 | 2017-10-02 00:00:00 | 2017-10-02 00:00:00 | 2017-10-09 00:00:00 | 2017-10-09 00:00:00 | 2017-10-09 00:00:00
[NAME] | North | Edinburgh | SM | 2017-10-04 00:00:00 | 2017-10-06 00:00:00 | 2017-10-06 00:00:00 | 2017-10-10 00:00:00 |  | 2017-10-10 00:00:00
Spreadsheet: 881767d1729937249-dates-to-be-worked-by-an-employee-per-month-dates-listing
Sheet: Sheet1

[NAME] for the Period:  October 2024
Pay Date | 2024-10-25 00:00:00
Date | employee name
 | Time In | Time Out | Hours | Holidays
2024-09-24 00:00:00 | 07:00:00 | 17:00:00 | 8.999999999999984
2024-09-25 00:00:00 | 07:00:00 | 17:00:00 | 8.999999999999984
2024-09-26 00:00:00 | 07:00:00 | 17:00:00 | 8.999999999999984
2024-09-27 00:00:00
2024-09-28 00:00:00 | 07:00:00 | 17:00:00 | 8.999999999999984
2024-09-29 00:00:00 | 07:00:00 | 17:00:00 | 8.999999999999984
2024-09-30 00:00:00 | 07:00:00 | 17:00:00 | 8.999999999999984
2024-10-01 00:00:00 | 07:00:00 | 17:00:00 | 8.999999999999984
2024-10-02 00:00:00 | 07:00:00 | 17:00:00 | 8.999999999999984
2024-10-03 00:00:00
2024-10-04 00:00:00
2024-10-05 00:00:00 | 07:00:00 | 17:00:00 | 8.999999999999984
2024-10-06 00:00:00 | 07:00:00 | 17:00:00 | 8.999999999999984
2024-10-07 00:00:00 | 07:00:00 | 17:00:00 | 8.999999999999984
2024-10-08 00:00:00 | 07:00:00 | 17:00:00 | 8.999999999999984
2024-10-09 00:00:00 | 07:00:00 | 17:00:00 | 8.999999999999984
2024-10-10 00:00:00
2024-10-11 00:00:00
2024-10-12 00:00:00 | 07:00:00 | 17:00:00 | 8.999999999999984
2024-10-13 00:00:00 | 07:00:00 | 17:00:00 | 8.999999999999984
2024-10-14 00:00:00 | 07:00:00 | 17:00:00 | 8.999999999999984
2024-10-15 00:00:00 | 07:00:00 | 17:00:00 | 8.999999999999984
2024-10-16 00:00:00 | 07:00:00 | 17:00:00 | 8.999999999999984
2024-10-17 00:00:00
2024-10-18 00:00:00
2024-10-19 00:00:00 | 07:00:00 | 17:00:00 | 8.999999999999984
2024-10-20 00:00:00 | 07:00:00 | 17:00:00 | 8.999999999999984
2024-10-21 00:00:00 | 07:00:00 | 17:00:00 | 8.999999999999984
2024-10-22 00:00:00 | 07:00:00 | 17:00:00 | 8.999999999999984
2024-10-23 00:00:00 | 07:00:00 | 17:00:00 | 8.999999999999984
Spreadsheet: 751185d1633958921-programme-duration-and-resourcing-dryer-boot-programme-excel-2
Sheet: Light

 |  |  |  |  |  |  |  |  |  |  |  |  | Legend: |  | On track |  |  |  |  | Low risk |  |  |  |  | Med risk |  |  |  |  | High risk |  |  |  |  | Overall
 | Project lead
 | Project Start Date: | 2021-10-04 00:00:00 | Hours Per Day | 10
 | Milestone description | Category | Assigned to | Supervisor | Welder | Plater | Rigger | Fitter | Semi-Skilled | Pipe Fitter | Progress | Start | Days
 | B Dryer Overhaul | Overall |  |  |  |  |  |  |  |  |  | 2021-10-04 00:00:00 | 11
 | Offline Turn on Blocks | Overall |  |  |  |  |  |  |  |  |  | 2021-10-04 00:00:00 | 7
 | Tyre Air Gaps | Low Risk | [NAME] | 0.333 |  |  |  | 0.666 | 1 |  | 1 | 2021-10-06 00:00:00 | 1
 | Dryer Shims | High Risk | [NAME] | 1 | 1 | 1 |  |  | 1 |  |  | 2021-10-15 00:00:00 | 6
 | Internal Repairs | High Risk | [NAME] | 1 | 1 | 1 |  |  | 2 |  | 0.1 | 2021-10-11 00:00:00 | 2
 | Lifters 12 of Install | Low Risk | [NAME] | 1 | 1 | 1 |  |  | 2 |  | 0 | 2021-10-13 00:00:00 | 2
 | Girth Gear Inspection Inc. Cleaning and Root Checks | Low Risk | [NAME] | 0.333 |  |  |  | 0.666 |  |  | 1 | 2021-10-06 00:00:00 | 1
 | Tyre Spacer Wear | Low Risk | [NAME] | 0.333 |  |  |  | 0.666 |  |  | 1 | 2021-10-06 00:00:00 | 1
 | Girth Gear Bolt Checks | Low Risk | [NAME] | 1 |  |  |  | 1 |  |  | 1 | 2021-10-07 00:00:00 | 1
 | Grease Line Checks | Low Risk | [NAME] |  |  |  |  | 1 |  |  | 1 | 2021-10-07 00:00:00 | 1
 | [NAME] and Inspect | Low Risk | [NAME] | 1 |  |  |  | 2 |  |  | 1 | 2021-10-08 00:00:00 | 1
 | General Inspection of all running Faces Tyres Rollers and Thrust Rollers | Low Risk | [NAME] | 0.333 |  |  |  | 0.666 |  |  | 1 | 2021-10-09 00:00:00 | 1
 | [NAME] | Low Risk | [NAME] | 0.333 |  |  |  | 0.666 |  |  | 1 | 2021-10-09 00:00:00 | 1
 | Structural Inpsection of Pinths | Low Risk | [NAME] | 0.333 |  |  |  | 0.666 |  |  | 0 | 2021-10-09 00:00:00 | 1
 | Inspect Inlet Outlet Seals | Low Risk | [NAME] | 1 |  |  |  | 2 |  |  | 0 | 2021-10-10 00:00:00 | 1
 | Shell Thickness checks | Low Risk | Axiom |  |  |  |  |  |  |  | 1 | 2021-10-11 00:00:00 | 1
 | Online Continious Motion | Overall |  |  |  |  |  |  |  |  |  | 2021-10-12 00:00:00 | 4
 | Bearing Temp Checks | Low Risk |  | 1 |  |  |  | 1 |  |  |  | 2021-10-12 00:00:00 | 1
 | Radial & Axial Alignment | Low Risk |  | 1 |  |  |  | 1 |  |  |  | 2021-10-13 00:00:00 | 2
 | Recommision with Test Run | Low Risk |  | 1 |  |  |  | 1 |  |  |  | 2021-10-15 00:00:00 | 1
 | To add more data, [NAME] new rows ABOVE this one
Spreadsheet: 820927d1678354297-counttfs-depending-on-criteria-eh_countifs-range-in-not-in
Sheet: Sheet1

Type | In MWP |  | SMs | In | Not in
[NAME] Lmb- In Mrnd | Not in MWP |  |  | 0 | 1
[NAME] Joint | ACRE LN LM NZ JT LG WR OTBN FZ |  | [NAME] Ofl- Liver | 0 | 2
[NAME] | ACRE LN LM OTH MINCE   20%+ [NAME] |  | [NAME] Lmb- In Mrnd | 1 | 0
[NAME] Lmb- In Mrnd | [NAME]FS |  | [NAME] Joint | 1 | 0
[NAME] Ofl- Liver | Not in MWP |  | [NAME] | 1 | 0
[NAME] Ofl- Liver | Not in MWP
Spreadsheet: 292152d1390503629-conditional-formatting-multiple-column-based-on-reference-cell-inincubus
Sheet: Sheet1

y | 236 | 464 | 23_ | 36_
x | 343 | 124 | 236 | 44_
x | 436 | _89 | 36_ | 464
w | 346 | 634 | 35_ | 162
z | 252 | 152 | 23_ | 536
Spreadsheet: 854933d1704699364-filter-without-result-to-show-blank-for-vstack-filter-without-result
Sheet: Sheet2

Code | Start | End | Prorate |  |  | 2023-06-30 00:00:00 |  | Code | Start | End | Cost
#1 | 2023-05-12 00:00:00 |  | 500 |  |  |  |  |  | 2023-06-11 00:00:00 |  | 150 |  | Basically, I want the top to be Code that start in the Month (E1) and bottom to show Code that end in the Month (E1)
#2 | 2023-05-27 00:00:00 | 2023-06-01 00:00:00 | 600 |  |  |  |  | #4 | 2023-06-26 00:00:00 | 2023-09-16 00:00:00 | 3600 |  | However, the formula only work nicely if the filter is a valid for both Start and End.
#3 | 2023-06-11 00:00:00 |  | 150 |  |  |  |  | #2 | 2023-05-27 00:00:00 | 2023-06-01 00:00:00 | 600 |  | How do I make a Iferror, then it will show blank?
#4 | 2023-06-26 00:00:00 | 2023-09-16 00:00:00 | 3600
#5 | 2023-07-11 00:00:00 |  | 800 |  |  |  |  |  |  |  |  |  | *If the eomonth of START = G1, den ((G1-Start)/day(G1))*column D
#6 | 2023-09-01 00:00:00 |  | 300 |  |  |  |  |  |  |  |  |  | if eomonth of [NAME], den ((Day(end)/Day(g1))*column D
#7 | 2023-09-16 00:00:00 |  | 600
#8 | 2023-10-01 00:00:00 |  | 900
#9 | 2023-10-16 00:00:00 | 2023-12-31 00:00:00 | 7500
#10 | 2023-10-31 00:00:00 |  | 3000
 |  |  |  |  |  |  |  | Code | Start | End | Cost | Prorate
 |  |  |  |  |  |  |  |  | 2023-06-11 00:00:00 |  | 150 | 95
 |  |  |  |  |  |  |  | #4 | 2023-06-26 00:00:00 | 2023-09-16 00:00:00 | 3600 | 480
 |  |  |  |  |  |  |  | #2 | 2023-05-27 00:00:00 | 2023-06-01 00:00:00 | 600 | 20
Spreadsheet: 787652d1657905200-calculating-time-differences-that-pass-over-midnight-times
Sheet: Sheet1

 | Start | Finish | Within 20 Mins | Within 1 Hour | 1 hour +
 | 23:58:00 | 00:12:00
 | 22:46:00 | 00:25:00
 | 22:42 | 01:02:00
 | 21:27 | 01:05:00
 | 21:22 | 00:58:00
 | 21:19 | 22:18:00
 | 21:18 | 00:31:00
 | 21:18 | 21:22:00
 | 21:14 | 23:05:00
 | 21:12 | 00:10:00
 | 21:10 | 00:14:00
 | 21:06 | 00:02:00
 | 20:59 | 00:02:00
Spreadsheet: 105810d1303108979-how-to-remove-s-0-9-and-spaces-regexp-sept-1-2004
Sheet: Ex 7 Remove repeated words

Menu Page
 | [NAME] | Error Tested String
 | the the fat fat fat cat | the fat cat
 | It was 2 2 degrees | It was 2 degrees
 | No not nothing | No not nothing
 | Fred fred Jones | [NAME]
 | 1 2 3 3 4 | 1 2 3 4
 | 3 1 2 3 | 3 1 2 3
 | No no No Mr Fawlty | No Mr Fawlty
 | the fast faster | the fast faster
 | Macro | RegExp_Early_Replace_7
 | Global | 1
 | Current Direction Pattern | \b(\w+)\b(\s+\1\b)+
 | Dave's Direction Pattern | \b(\w+)\b(\s+\1\b)+
Spreadsheet: 836440d1689354891-cleanup-of-data-that-is-merged-by-client-and-requires-text-to-columns-and-transposing-cleanup
Sheet: Solution

Client Account | Contact Names | Contact Emails
Client 1 | [NAME] | [EMAIL]
Client 2 | [NAME] | [EMAIL]
Client 3 | [NAME] | [EMAIL]
Client 3 | [NAME] | [EMAIL]
Client 3 | [NAME] | [EMAIL]
Client 3 | [NAME] | [EMAIL]
Client 4 | [NAME] | [EMAIL]
Client 4 | [NAME] 8 | [EMAIL]
Client 4 | [NAME] 9 | [EMAIL]
Spreadsheet: 140362d1328718273-cell-reference-1-column-to-the-right-referencing-13-more-cell-reference
Sheet: Formula

2011-12-17 00:00:00
Spreadsheet: 793633d1661592339-fix-data-columns-layout-songs-vstack-aligw
Sheet: Sheet

Original Data |  |  |  |  |  | Final Data
Vol. 001 |  |  |  |  |  | Vol. 001
Song | Vocalist | Song | Vocalist |  |  | Song | Vocalist |  | [NAME] Khser [NAME] | [NAME]
[NAME] Khser [NAME] | [NAME] | [NAME] | [NAME] |  |  | [NAME] Khser [NAME] | [NAME] |  | [NAME] | [NAME]
[NAME] | [NAME] | [NAME] | [NAME] |  |  | [NAME] | [NAME] |  | [NAME] | [NAME]
[NAME] 10 | Samouth+Sothea | [NAME] | [NAME] |  |  | [NAME] 10 | Samouth+Sothea |  | [NAME] | [NAME]
Nov Smak Nov Sduy | [NAME] | [NAME] | [NAME] |  |  | Nov Smak Nov Sduy | [NAME] |  | [NAME] | Samouth+Sothea
Teuk Phnek Deum Chhnam | [NAME] | Bong Cham Ngor Ngum [NAME] | [NAME] |  |  | Teuk Phnek Deum Chhnam | [NAME] |  | [NAME] | [NAME]
[NAME] Angvor | [NAME] | Bong Ches Taetam Khnom | Samouth+Sothea |  |  | [NAME] Angvor | [NAME] |  | Nov Smak Nov Sduy | [NAME]
[NAME] | Pen Ran | [NAME] Yub | Pen Ran |  |  | [NAME] | Pen Ran |  | [NAME] | [NAME]
Vol. 002 |  |  |  |  |  | [NAME] | [NAME] |  | Teuk Phnek Deum Chhnam | [NAME]
Song | Vocalist | Song | Vocalist |  |  | [NAME] | [NAME] |  | Bong Cham Ngor Ngum [NAME] | [NAME]
[NAME] | [NAME] | Chom Ork Cham Orn | Pen Ran |  |  | [NAME] | [NAME] |  | [NAME] Angvor | [NAME]
[NAME] Own Na | [NAME] | Chompa Paylin | [NAME] |  |  | [NAME] | [NAME] |  | Bong Ches Taetam Khnom | Samouth+Sothea
[NAME] | [NAME] | [NAME] | [NAME] |  |  | Bong Cham Ngor Ngum [NAME] | [NAME] |  | [NAME] | Pen Ran
La Bumbayer | [NAME] | [NAME] | [NAME] |  |  | Bong Ches Taetam Khnom | Samouth+Sothea |  | [NAME] Yub | Pen Ran
Lear Phoum Sake Sok | [NAME] | Kbot Huey Kbot Theit - Sothea | [NAME] |  |  | [NAME] Yub | Pen Ran |  | Vol. 2
Marina | [NAME] | [NAME] | [NAME] |  |  | Vol. 002 |  |  | [NAME] | [NAME]
[NAME] Kern [NAME] | Samouth+Sothea | [NAME] | Pen Ran |  |  | Song | Vocalist |  | Chom Ork Cham Orn | Pen Ran
 |  |  |  |  |  | [NAME] | [NAME] |  | [NAME] Own Na | [NAME]
 |  |  |  |  |  | [NAME] Own Na | [NAME] |  | Chompa Paylin | [NAME]
 |  |  |  |  |  | [NAME] | [NAME] |  | [NAME] | [NAME]
 |  |  |  |  |  | La Bumbayer | [NAME] |  | [NAME] | [NAME]
 |  |  |  |  |  | Lear Phoum Sake Sok | [NAME] |  | La Bumbayer | [NAME]
 |  |  |  |  |  | Marina | [NAME] |  | [NAME] | [NAME]
 |  |  |  |  |  | [NAME] Kern [NAME] | Samouth+Sothea |  | Lear Phoum Sake Sok | [NAME]
 |  |  |  |  |  | Chom Ork Cham Orn | Pen Ran |  | Kbot Huey Kbot Theit - Sothea | [NAME]
 |  |  |  |  |  | Chompa Paylin | [NAME] |  | Marina | [NAME]
 |  |  |  |  |  | [NAME] | [NAME] |  | [NAME] | [NAME]
 |  |  |  |  |  | [NAME] | [NAME] |  | [NAME] Kern [NAME] | Samouth+Sothea
 |  |  |  |  |  | Kbot Huey Kbot Theit - Sothea | [NAME] |  | [NAME] | Pen Ran
 |  |  |  |  |  | [NAME] | [NAME]
 |  |  |  |  |  | [NAME] | Pen Ran
Spreadsheet: 272505d1382412095-count-of-account-numbers-length-of-stay-sample-v2
Sheet: Sheet1

Account Number | Time In | Time Out | Unit | Length of Stay |  | consolidated list | total length of stay
X123 | 12:53:00 | 12:54:00 | 4 |  |  | X123
X123 | 12:54:00 | 13:01:00 | 5 |  |  | X456
X456 | 01:06:00 | 01:10:00 | 4 |  |  | X789
X789 | 07:08:00 | 07:09:00 | 3
X789 | 07:09:00 | 08:10:00 | 4
X789 | 08:10:00 | 09:00:00 | 5
 | For the 'consolidated list,' copy values in A into G and "remove duplicates" in data tab
Spreadsheet: 770795d1646253591-working-time-directive-calculations-timesheet2
Sheet: 22-11-21

 | HMP BARLINNIE ESTATES |  |  |  |  | Week No. |  |  |  |  | Week Commencing |  |  |  |  |  |  | On Call Engineer |  |  | S Rudden / S Barclay
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | On Call Manager |  |  | I Beveridge
Toil | Name | Leave | MONDAY |  |  |  | TUESDAY |  |  |  | WEDNESDAY |  |  |  | THURSDAY |  |  |  | FRIDAY |  |  |  | SATURDAY |  | SUNDAY |  | Signature | leave |  | toil
 |  |  | HRS | TOIL | O/T | OTHER | HRS | TOIL | O/T | OTHER | HRS | TOIL | O/T | OTHER | HRS | TOIL | O/T | OTHER | HRS | TOIL | O/T | OTHER | O/T | TOIL | O/T | TOIL |  | Total | Balance | Total | Balance | total from last week | total leave taken
 | [NAME] |  | 7.5 |  |  |  | 7.5 |  |  |  | 7.5 |  |  |  | 7.5 |  |  |  | 7
 | [NAME] |  | 0 |  |  | AL | 7.5 |  |  |  | 7.5 |  |  | TR | 7.5 |  |  |  | 7 | -2
 | [NAME] |  | 7.5 |  |  |  | 7.5 |  |  |  | 7.5 |  |  |  | 7.5 |  |  |  | 7 |  |  |  | 8 |  | 8
 | [NAME] |  | 7.5 |  |  |  | 7.5 |  |  |  | 7.5 |  |  |  | 7.5 |  |  |  | 7
 | [NAME] |  | 7.5 |  |  |  | 7.5 |  |  |  | 7.5 |  |  |  | 7.5 |  |  |  | 4 |  |  | 3hrs | 6 |  | 6.5
 | [NAME] |  | 7.5 |  |  | TR | 7.5 |  |  |  | 7.5 |  |  |  | 4 |  |  | 1/2 AL | 7 |  |  |  |  |  |  |  | Leave | 0.5
 | [NAME] |  | 7.5 |  |  |  | 0 |  |  | SK | 0 |  |  | SK | 0 |  |  | SK | 0 |  |  | SK |  |  |  |  | Sick
 | [NAME] |  | 7.5 |  |  |  | 7.5 |  |  |  | 7.5 |  |  |  | 7.5 |  |  |  | 7 |  |  |  | 8 |  | 8
 | [NAME] |  | 7.5 |  |  |  | 7.5 |  |  |  | 7.5 |  |  |  | 0 |  |  | AL | 0 |  |  | AL
Spreadsheet: ac431b09-f9f6-4f10-a347-ea9d0094dd6d
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
5718 | 21290 | [NAME] | [NAME] | GBR | 0 | 00:24:53 | 00:03:27 | 01:13:22 | 00:02:50 | 00:58:48 | 1 | 02:43:19
Spreadsheet: 109359d1306249372-assigning-a-value-to-a-dropdown-list-qa
Sheet: Sheet1

Question | % |  | Actual Score
Question 1 | 0.16 | Yes | 0.16 |  |  |  |  |  |  |  | If C2 is a "Yes" it needs to pull through the % in cell D1. If C2 is "No" it must not pull any % in D1, however if C1 is "N/A" it must take the % and divide to the other 6 questions
Question 2 | 0.15 | No | no Score
Question 3 | 0.2 | Yes | 0.2
Question 4 | 0.15 | Yes | 0.15
Question 5 | 0.25 | Yes | 0.25
Question 6 | 0.09 | N/A
 |  | Yes
 |  | No
 |  | N/A