tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 160818d1339221514-help-match-two-columns-with-different-criteria-runners
Sheet: Female 50Km

Place | Time | Km/h | Bib# | First | Last | City | Age | Div | [NAME] | O/All | Adjusted Place | in Entries
1 | 0.2148958333333333 | 9.69 | 594 | Nikki | [NAME] | VIC | 39 | 50km | F | 13
2 | 0.2370833333333333 | 8.79 | 554 | Isobel | Bespalov | VIC | 41 | 50km | F | 30
3 | 0.2495486111111111 | 8.35 | 580 | [NAME] | Lucas | VIC | 39 | 50km | F | 39
4 | 0.2582754629629629 | 8.07 | 545 | Fleur | Grose | VIC | 38 | 50km | F | 43
5 | 0.2588078703703704 | 8.05 | 573 | [NAME] | Emmerson | VIC | 25 | 50km | F | 44
6 | 0.2590625 | 8.04 | 513 | Anna | Moore | VIC | 27 | 50km | F | 46
7 | 0.2615393518518518 | 7.97 | 565 | [NAME] | Mckeown | VIC | 45 | 50km | F | 47
8 | 0.2620717592592592 | 7.95 | 570 | [NAME] | Macmillan | VIC | 33 | 50km | F | 48
9 | 0.2632060185185185 | 7.91 | 568 | [NAME] | Pate | VIC | 41 | 50km | F | 54
10 | 0.2686458333333333 | 7.75 | 590 | [NAME] | [NAME] | VIC | 40 | 50km | F | 59
11 | 0.2689236111111111 | 7.75 | 593 | Nicole | Barker | VIC | 40 | 50km | F | 60
12 | 0.2716435185185185 | 7.67 | 612 | Terrie | [NAME] | VIC | 36 | 50km | F | 64
13 | 0.2735763888888889 | 7.61 | 547 | Gayle | Cowling | VIC | 42 | 50km | F | 67
14 | 0.2750231481481482 | 7.58 | 589 | Michelle | Donnelly | VIC | 45 | 50km | F | 68
15 | 0.2844791666666667 | 7.32 | 519 | [NAME] | [NAME] | VIC | 26 | 50km | F | 71
16 | 0.2867013888888889 | 7.27 | 575 | Kerryn | [NAME] | VIC | 30 | 50km | F | 72
17 | 0.2904398148148148 | 7.17 | 558 | [NAME] | Shadbolt | VIC | 34 | 50km | F | 74
18 | 0.3057754629629629 | 6.81 | 592 | Nicola | [NAME] | VIC | 28 | 50km | F | 84
19 | 0.3109953703703703 | 6.7 | 504 | [NAME] | Lopez | CHILE | 28 | 50km | F | 86
20 | 0.3241666666666667 | 6.43 | 571 | Kaye | Ervin | VIC | 48 | 50km | F | 94
21 | 0.3241666666666667 | 6.43 | 542 | Ellen | Lavoie | VIC | 44 | 50km | F | 96
22 | 0.3255208333333333 | 6.4 | 578 | Kristy | Palcak | VIC | 25 | 50km | F | 98
23 | 0.3331712962962963 | 6.25 | 521 | Crystal | Shiu | VIC | 26 | 50km | F | 100
Spreadsheet: 89929d1289671847-i-get-an-error-in-index-and-match-formula-index-and-match-formula
Sheet: Setup

 | COUNTRY | Stage | AGE | Message
 | UK | 10 | 1 | 6
 | UK | 10 | 2 | 5
 | UK | 10 | 3 | 4
 | UK | 10 | 4 | 3
 | UK | 10 | 5 | 2
 | UK | 10 | 6 | 1
 | UK | 10 | 7 | 0
 | UK | 10 | >7 | Delay
 | UAE | 10 | 1 | 4
 | UAE | 10 | 2 | 3
 | UAE | 10 | 3 | 2
 | UAE | 10 | 4 | 1
 | UAE | 10 | >4 | Delay
 | KW | 10 | 1 | 9
 | KW | 10 | 2 | 8
 | KW | 10 | 3 | 7
 | KW | 10 | 4 | 6
 | KW | 10 | 5 | 5
 | KW | 10 | 6 | 4
 | KW | 10 | 7 | 3
 | KW | 10 | 8 | 2
 | KW | 10 | 9 | 1
 | KW | 10 | 10 | 0
 | KW | 10 | >10 | Delay
 | UK | 20 | 1 | 2
 | UK | 20 | 2 | 1
 | UK | 20 | 3 | 0
 | UK | 20 | >3 | Delay
 | UAE | 20 | 1 | 2
 | UAE | 20 | 2 | 3
 | UAE | 20 | 3 | 1
 | UAE | 20 | >3 | Delay
 | KW | 20 | 1 | 4
 | KW | 20 | 2 | 3
 | KW | 20 | 3 | 2
 | KW | 20 | 4 | 1
 | KW | 20 | 5 | 0
 | KW | 20 | >5 | Delay
Spreadsheet: 39036d1237249138-taking-information-from-a-database-summarybycategorykey
Sheet: Sheet1

Company | Category | Subcategory | Date | Cost |  |  | CatKey | Index |  | These two helper columns make array formulas unnecessary
ABC Towing | 1 | 1 | 2000-01-01 00:00:00 | 70 |  |  | 1-1 | 1-1-1 |  | CatKey is the key that will ID which Summary it should transfer into
[NAME]. | 1 | 2 | 2000-01-04 00:00:00 | 100 |  |  | 1-2 | 1-2-1 |  | Index is a unique code from the key that allows orderly sorting in the Summaries
Newspapers | 2 | 1 | 2000-01-07 00:00:00 | 50 |  |  | 2-1 | 2-1-1
[NAME]'s Parts | 1 | 2 | 2000-01-18 00:00:00 | 200 |  |  | 1-2 | 1-2-2
Spreadsheet: 160132d1338983974-how-to-simplify-criteria-conditions-for-dget-formula-proyecto-oeldere-
Sheet: pivot table

Sold-to | (Alles)
Som van T2011 | [NAME]
client | Material 1 | Material 2 | Material 3 | Material 4 | Material 5 | Material 6 | Other | Other | (leeg) | Eindtotaal
Client 1 | 559.1600000000001 | 15376.2 | 16631.96 | 776413.1200000002 |  |  |  |  | 404490.22 | 1213470.66
Client 10 | 5559.98 | 130762.12 | 1140.5 | 546568.8 | 0 | 0 |  |  | 342015.7 | 1026047.1
Client 11 | 17793.96 | 18208.76 | 22330.76 | 317234.88 |  |  |  |  | 187784.18 | 563352.54
Client 12 | 3249.639999999998 |  |  | 344650 |  |  |  |  | 173949.82 | 521849.46
Client 13 | 1393.34 | 71192.82 |  | 360622.58 |  |  |  |  | 216604.37 | 649813.11
Client 14 |  | 12675.12 |  | 382879 |  |  |  |  | 197777.06 | 593331.1799999999
Client 15 |  |  |  | 499358.08 |  |  |  |  |  | 499358.08
Client 16 |  |  |  | 409707.08 |  |  |  |  |  | 409707.08
Client 17 |  | 5395.15 |  | 1124601.88 |  |  |  |  | 567696.09 | 1697693.12
Client 18 | 755.52 | 152754.82 | 1007.36 | 435290.9199999999 |  |  |  |  | 294904.31 | 884712.9299999999
Client 19 |  |  |  | 974733.0400000002 |  | 0 |  |  | 487366.52 | 1462099.56
Client 2 |  | 45179.84 |  | 254431.54 | 354.76 | 9147.06 |  |  | 154556.6 | 463669.8
Client 20 | -263.68 |  |  | 849104.64 |  | 0 |  |  | 424420.48 | 1273261.44
Client 21 | 603.8400000000001 | -24632.2 | 1389.48 | 362990.4000000001 |  | 0 |  |  | 170175.76 | 510527.2800000001
Client 22 |  |  |  | 61221.36 |  |  |  |  |  | 61221.36
Client 23 | 6193.08 | 45935.12 | 8405.28 | 402799.34 |  |  |  |  | 231666.41 | 694999.23
Client 24 | 3123.62 |  | 11003.62 | 524040.9600000001 |  |  |  |  | 269084.1 | 807252.3
Client 25 |  |  |  |  |  |  |  |  | 0 | 0
Client 3 | 36904.34 | 1150195.62 | 0 | 1088758.04 |  | 0 |  |  | 1137929 | 3413787
Client 4 | 21235.36 | 1103081.68 |  | 912246 |  |  |  |  | 1018281.52 | 3054844.56
Client 5 | 88552.64 | 393675.7000000001 | 295201.64 | 2609439.680000001 |  | 0 |  |  | 1695332.54 | 5082202.200000001
Client 6 |  |  |  | 655147.44 |  | 62127.75999999999 |  |  | 358637.6 | 1075912.8
Client 7 |  |  |  | 568666.4800000002 |  | 21813.88 |  |  | 295240.18 | 885720.5400000003
Client 8 | 3527.6 | 747.02 | 238.06 | 206992.38 |  |  |  |  | 105752.53 | 317257.59
Client 9 | 38633.34 | 2058889.18 | 13704.76 | 392343.46 | 40228.64 |  |  |  | 1271899.69 | 3815699.069999999
Eindtotaal | 227821.74 | 5179436.949999999 | 371053.42 | 15060241.1 | 40583.4 | 93088.69999999998 |  |  | 10005564.68 | 30977789.99
Spreadsheet: 88439d1288266518-getting-graphs-to-ignore-formulae-chart-master
Sheet: DataEntry

 | Feature No.
 | Feature name |  | feature
 | [NAME] |  | 23.006
 | lower [NAME] |  | 22.985
No
43 | DATE | Fix | s
1 | 2010-09-22 00:00:00 | 1 | 22.99
2 | 2010-09-22 00:00:00 | 1 | 22.99
3 | 2010-09-22 00:00:00 | 1 | 22.989
4 | 2010-09-22 00:00:00 | 1 | 22.989
5 | 2010-09-15 00:00:00 | 1 | 22.989
6 | 2010-09-15 00:00:00 | 1 | 22.99
7 | 2010-09-15 00:00:00 | 1 | 22.99
8 | 2010-09-15 00:00:00 | 1 | 22.991
9 | 2010-09-14 00:00:00 | 1 | 22.989
10 | 2010-09-14 00:00:00 | 1 | 22.991
11 | 2010-09-14 00:00:00 | 1 | 22.99
12 | 2010-09-14 00:00:00 | 1 | 22.991
13 | 2010-09-08 00:00:00 | 1 | 22.991
14 | 2010-09-08 00:00:00 | 1 | 22.991
15 | 2010-09-08 00:00:00 | 1 | 22.99
16 | 2010-09-08 00:00:00 | 1 | 22.99
17 | 2010-09-06 00:00:00 | 1 | 22.991
18 | 2010-09-06 00:00:00 | 1 | 22.989
19 | 2010-09-06 00:00:00 | 1 | 22.99
20 | 2010-09-06 00:00:00 | 1 | 22.99
21 | 2010-08-31 00:00:00 | 1 | 22.988
22 | 2010-08-31 00:00:00 | 1 | 22.987
23 | 2010-08-31 00:00:00 | 1 | 22.988
24 | 2010-08-31 00:00:00 | 1 | 22.99
25 | 2010-08-26 00:00:00 | 1 | 22.991
26 | 2010-08-26 00:00:00 | 1 | 22.99
27 | 2010-08-26 00:00:00 | 1 | 22.991
28 | 2010-08-26 00:00:00 | 1 | 22.992
29 | 2010-08-25 00:00:00 | 1 | 22.99
30 | 2010-08-25 00:00:00 | 1 | 22.99
31 | 2010-08-25 00:00:00 | 1 | 22.989
32 | 2010-08-24 00:00:00 | 1 | 22.989
33 | 2010-08-24 00:00:00 | 1 | 22.991
34 | 2010-08-24 00:00:00 | 1 | 22.988
35 | 2010-08-24 00:00:00 | 1 | 22.988
36 | 2010-08-24 00:00:00 | 1 | 22.991
37 | 2010-08-23 00:00:00 | 1 | 22.991
38 | 2010-08-23 00:00:00 | 1 | 22.99
39 | 2010-08-23 00:00:00 | 1 | 22.991
40 | 2010-08-19 00:00:00 | 1 | 22.989
41 | 2010-08-13 00:00:00 | 1 | 22.989
42 | 2010-08-13 00:00:00 | 1 | 22.991
43 | 2010-08-13 00:00:00 | 1 | 22.989
Spreadsheet: darrell_schoolcraft__7776__imbalsumm0106
Sheet: Calpine

 | Calpine So. Point Power Del
 | 78113
Day | Measured | Scheduled
1 | -52917 | -37500
2 | -38872 | -40000
3 | -34322 | -40000
4 | -44422 | -29550
5 | -41682 | -45983
6 | -60431 | -68633
7 | -62347 | -50000
8 | -65929 | -79625
9 | -52330 | -64819
10 | -42397 | -50000
11 | -61555 | -49841
12 | -55007 | -65300
13 | -63094 | -65300
14 | -61350 | -65241
15 | -43564 | -40000
16 | -41479 | -40000
17 | -41244 | -40001
18 | -41244 | -50000
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-05-31 00:00:00 |  |  | -357096.85
2001-06-18 00:00:00
Spreadsheet: 0a8791de-84e4-4eb4-bfac-22483612972b
Sheet: Collision Repair Certs

COLLISION REPAIR TECHNOLOGY
Certificates
Student Name:
ID #
Automotive Painter | Semester | Grade
___ CRT 100 (2) Introduction to Collision Repair
___ CRT 130 (6) Non-Structural Analysis and Damage Repair
___ CRT 131 (6) Non-Structural Analysis and Damage Repair Lab
___ CRT 150 (6) Painting and [NAME]
___ CRT 151 (6) Painting and Refinishing Lab
___ CRT 230 (6) Structural Analysis and Damage Repair
___ CRT 231 (6) Structural Analysis and Damage Repair Lab
Automotive Painter Helper
___ CRT 100 (2) Introduction to Collision Repair
___ CRT 150 (6) Painting and [NAME]
___ CRT 151 (6) Painting and Refinishing Lab
Collision Repair Helper
___ CRT 100 (2) Introduction to Collision Repair
___ Electives (Collision Repair Courses with exception of CRT 150 and CRT 151.)
Collision Repairer
___ CRT 100 (2) Introduction to Collision Repair
___ CRT 130 (6) Non-Structural Analysis and Damage Repair
___ CRT 131 (6) Non-Structural Analysis and Damage Repair Lab
___ CRT 150 (6) Painting and [NAME]
___ CRT 151 (6) Painting and Refinishing Lab
___ CRT 230 (6) Structural Analysis and Damage Repair
___ CRT 231 (6) Structural Analysis and Damage Repair Lab
___ CRT 250 (6) Mechanical and Electrical Components
___ CRT 251 (6) Mechanical and Electrical Components Lab
Southeast Kentucky Community & Technical College | Updated Spring 2013
Spreadsheet: 486674d1477600720-need-to-call-up-info-maybe-a-vlookup-question-i-dont-know-testingagain
Sheet: Facebook

LASTNAME, FIRST
EMPLOYEE # |  |  |  | EMPLOYEE # |  | 2215 |  | EMPLOYEE # |  | 4092
DEPT | HIRE DATE
LASTNAME, FIRST |  |  |  | LASTNAME, FIRST |  |  |  | LASTNAME, FIRST
EMPLOYEE # |  |  |  | EMPLOYEE # |  |  |  | EMPLOYEE #
DEPT | HIRE DATE |  |  | DEPT | HIRE DATE |  |  | DEPT | HIRE DATE
EMPLOYEE # |  | 921 |  | EMPLOYEE # |  | 3447 |  | EMPLOYEE # |  | 2215
Spreadsheet: 734582d1622244447-sumif-formula-problem-with-error-check-mark-sumif
Sheet: Sheet2

Feature No | Description | M.C | FIN | AUD | LAW | BENG.B | HR | TRAIN | SERV | MAT | EXP | M.P | ENG | PLN | OPS | DRL | ICT | HSE
2 | Utilities
3 | Employees' Travelling Business Expense
4 | Contract Catering
5 | Direct Rent
6 | Office Supplies
7 | Equipment Rental
Spreadsheet: 91472d1291211115-sort-filter-lookup-problem-sort
Sheet: Sheet1

1 | Fridge | 654
1 | Fridge | 235
1 | Bed | 458
1 | Shoes | 654
1 | Shoes | 235
1 | Skirt | 489
1 | Skirt | 247
2 | Fridge | 521
2 | Fridge | 258
2 | Bed | 645
2 | Shoes | 465
3 | Shoes | 156
3 | Skirt | 456
3 | Skirt | 546
4 | Fridge | 554
4 | Fridge | 645
4 | Bed | 546
5 | Shoes | 123
5 | Shoes | 897
5 | Skirt | 546
6 | Skirt | 458
6 | Fridge | 984
6 | Fridge | 214
Spreadsheet: 289775d1389689063-find-the-earliest-result-for-the-same-period-sample-choose-earliest
Sheet: Earliest

ISIN | Name | INT1 EPS MEAN EST | INT1 EPS END DATE | INT1 EPS NO ESTS. |  | ISIN | Name | INT1 EPS MEAN EST | INT1 EPS END DATE | INT1 EPS NO ESTS.
US0378331005 | Apple | 0.05 | 2001-12-31 00:00:00 | 18 |  | US3696041033 | GE
 |  | 0.08 | 2002-03-31 00:00:00 | 18 |  | (4000 more companies)
Spreadsheet: 879019d1726454589-formula-works-but-not-for-data-validation-ajaxs87-process-schedule-maker
Sheet: RotationBoard

PROCESS / QUARTER | QTR 1 | QTR 2 | QTR 3 | QTR 4 | QTR 5 |  | TM ABSENT | START OF ABSENCE | RETURN FROM ABSENCE
[NAME]
RAKU
AC FILL
[NAME]
AIRFLOW
FINISH
LR DOT
R HEADLAMP
L HEADLAMP
[NAME]
LR SEAT
R SEAT UNLOAD
L SEAT UNLOAD
[NAME]
LF SEAT
REINFORCEMENT
R ROCKER
L ROCKER
R BUMPER
L BUMPER
ENGINE WIRE
REAR CONSOLE
R Q GATE
L Q GATE
RESTRICTION
 | ANTHONY | ANTHONY | ANTHONY | ANTHONY | ANTHONY |  | ANTHONY | QTR 2 |  | AUSTIN
 | AUSTIN | AUSTIN | AUSTIN | AUSTIN | AUSTIN |  | AUSTIN | QTR 3 |  | BRANDON
 | BRANDON | BRANDON | BRANDON | BRANDON | BRANDON |  | BRANDON | QTR 4 |  | DESTINY
 | BUDDY | BUDDY | BUDDY | BUDDY | BUDDY |  | BUDDY | QTR 5 |  | JATARI
 | CARLOS | CARLOS | CARLOS | CARLOS | CARLOS |  | CARLOS |  |  | LASHEIA
 | CASEY | CASEY | CASEY | CASEY | CASEY |  | CASEY |  |  | PORSHE
 | CHRIS | CHRIS | CHRIS | CHRIS | CHRIS |  | CHRIS |  |  | DERRICK
 | CHRISTIENA | CHRISTIENA | CHRISTIENA | CHRISTIENA | CHRISTIENA |  | CHRISTIENA |  |  | RODERICK
 | COREY | COREY | COREY | COREY | COREY |  | COREY
 | DANNY | DANNY | DANNY | DANNY | DANNY |  | DANNY
 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] |  | [NAME]
 | DESTIN | DESTIN | DESTIN | DESTIN | DESTIN |  | DESTIN
 | DESTINY | DESTINY | DESTINY | DESTINY | DESTINY |  | DESTINY
 | DUSTIN | DUSTIN | DUSTIN | DUSTIN | DUSTIN |  | DUSTIN
 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] |  | [NAME]
 | GENA | GENA | GENA | GENA | GENA |  | GENA
 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] |  | [NAME]
 | JATARI | JATARI | JATARI | JATARI | JATARI |  | JATARI
 | JEFFREY | JEFFREY | JEFFREY | JEFFREY | JEFFREY |  | JEFFREY
 | JEREMY | JEREMY | JEREMY | JEREMY | JEREMY |  | JEREMY
 | KEVIN | KEVIN | KEVIN | KEVIN | KEVIN |  | KEVIN
 | LASHEIA | LASHEIA | LASHEIA | LASHEIA | LASHEIA |  | LASHEIA
 | MARCUS | MARCUS | MARCUS | MARCUS | MARCUS |  | MARCUS
 | MATTHEW | MATTHEW | MATTHEW | MATTHEW | MATTHEW |  | MATTHEW
 | NICK | NICK | NICK | NICK | NICK |  | NICK
 | PORSHE | PORSHE | PORSHE | PORSHE | PORSHE |  | PORSHE
 | QUINTUARUS | QUINTUARUS | QUINTUARUS | QUINTUARUS | QUINTUARUS |  | QUINTUARUS
 | SCOTTIE | SCOTTIE | SCOTTIE | SCOTTIE | SCOTTIE |  | SCOTTIE
 | SOLOMON | SOLOMON | SOLOMON | SOLOMON | SOLOMON |  | SOLOMON
 | TABITHA | TABITHA | TABITHA | TABITHA | TABITHA |  | TABITHA
 | TAYLOR | TAYLOR | TAYLOR | TAYLOR | TAYLOR |  | TAYLOR
 | THRASHER | THRASHER | THRASHER | THRASHER | THRASHER |  | THRASHER
 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] |  | [NAME]
 | CONSUELA | CONSUELA | CONSUELA | CONSUELA | CONSUELA |  | CONSUELA
 | MELISSA | MELISSA | MELISSA | MELISSA | MELISSA |  | MELISSA
 | RESOURCE | RESOURCE | RESOURCE | RESOURCE | RESOURCE |  | RESOURCE
 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] |  | [NAME]
 | DERRICK | DERRICK | DERRICK | DERRICK | DERRICK |  | DERRICK
 | QUENTIN | QUENTIN | QUENTIN | QUENTIN | QUENTIN |  | QUENTIN
 | RODERICK | RODERICK | RODERICK | RODERICK | RODERICK |  | RODERICK
Spreadsheet: 881109d1729021693-calculating-number-of-winter-workdays-between-two-dats-revised-structural-erection-worksheet-test
Sheet: Invoice 01

 |  | 511 East Steel Loop, Suite 201
 |  | Palmer, AK  99645
 |  | Phone:  [PHONE]
 |  | Fax:      [PHONE]
TO: |  |  |  |  | INVOICE DATE: |  | 0/00/2024
 |  |  |  |  | INVOICE NO:
 |  |  |  | Submitted
 |  |  |  | Via Email
JOB NO:
DOL NUMBER:
JOB NAME:
[NAME] |  | CONTRACT AMOUNT ( $ ) | PREVIOUS BILLED (%) | PREVIOUS BILLED ( $ ) | CURRENT BILLING (%) | CURRENT BILLING ( $ ) | [NAME] (%) | JTD  BILLING ( $ )
Labor
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
LABOR TOTALS: |  |  | 0 |  | 0
CHANGE REQUESTS:
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
CHANGE REQUEST TOTALS:
TOTALS ALL TO DATE:
Please Remit Payment to: |  |  |  | TOTAL CURRENT BILLING
Iron Inc
511 East Steel Loop |  |  |  | TOTAL PREVIOUS BILLING
Palmer, AK 99645
 |  |  |  | TOTAL AMOUNT DUE THIS INVOICE
Spreadsheet: 77825d1278328805-range-lookups-with-overlapping-entries-and-extra-check-vakantie-2010
Sheet: Marcel

Vakantie
DATE | DATE | NAME | [NAME]
2010-07-31 00:00:00 | 2010-08-21 00:00:00 | Marcel | [NAME]
2010-08-21 00:00:00 | 2010-08-21 00:00:00 | Marcel | Vrije dag
2010-12-27 00:00:00 | 2010-12-31 00:00:00 | Marcel | Kerstvakantie
2010-08-12 00:00:00 | 2010-08-12 00:00:00 | [NAME] | Vrije dag
[NAME]
Day | Description
2 |  |  | 1 (Sunday) to 7 (Saturday).
4
Part-Time Dag
Day | Description
5 |  |  | 1 (Sunday) to 7 (Saturday).
Spreadsheet: 682240d1591972057-extracting-lines-after-change-test-11-frequency
Sheet: Sheet1

ID | Invoice Number | ItemCode | LineAmount
1 | INVE0105742 | PARTS070 | 0
2 | INVE0105742 | PARTS070 | 0
3 | INVE0105742 | PARTS070 | 0
1158 | INVE0105742 | 5500N3VD | 0
1159 | INVE0105742 | 5500N3VD | 0
1160 | INVE0105742 | 5500N3VD | 0
9323 | INVE0105742 | D-5500-36-HHP | 0
9324 | INVE0105742 | D-5500-36-HHP | 0
9325 | INVE0105742 | D-5500-36-HHP | 0
11647 | INVE0105742 | D-5500-36-HUP | 0
11648 | INVE0105742 | D-5500-36-HUP | 0
11649 | INVE0105742 | D-5500-36-HUP | 0
40592 | INVE0105742 | D-5500-36-SUP | 0
40593 | INVE0105742 | D-5500-36-SUP | 0
40594 | INVE0105742 | D-5500-36-SUP | 0
3860 | INVE0106234 | PARTS045 | 70
3861 | INVE0106234 | PARTS045 | 70
3862 | INVE0106234 | PARTS045 | 70
7085 | INVE0106234 | FREIGHT | 3.79
7086 | INVE0106234 | FREIGHT | 3.79
7087 | INVE0106234 | FREIGHT | 3.79
Desired Results
Spreadsheet: 813350d1673690689-adding-negative-numbers-to-positive-sample-2-
Sheet: Sheet1

Income | Sales | Expense | Fees |  | Stock/Mat | Postage/Courier | Website Exp | Check Expense Total | Check Income Total | TOTAL
 |  |  |  |  |  |  | -21
 |  |  | -2.22
29 | 29 |  | -4.63
 |  |  |  |  |  | -5.8
 |  |  |  |  | -13.2
27.5 | 27.5 |  | -3.22
 |  |  |  |  | -9.2
 |  |  |  |  | -18.7
108 | 108
 |  |  |  |  |  | -7.3
105 | 105 |  | -3.35
 |  |  |  |  |  | -13.74
 |  |  |  |  |  |  | -87.51
Spreadsheet: 92191d1291833560-excel-2007-pull-data-from-multiple-sheet-example
Sheet: 3

Qualification Tensile Inspection
Supplier | ABC
 | ([NAME]) | (in)
[NAME]: | 4
Length: | 150
 |  |  |  | Date Tested: | 2010-11-05 00:00:00
 | Tested at Location: | ABC |  | Tested by:
Cavity | Tensile Strength (N) | [NAME] (lbf) | Insertion Force (N) | Moisture | Comments
1 | 259 |  |  | 3.6
2 | 247 |  |  | 2.6
3 | 248
4 | 236
5 | 198
6 | 226
7 | 286
8 | 252
9 | 237
10 | 223
11 | 262
12 | 217
13 | 275
14 | 233
15 | 218
16 | 198
17 | 189
18 | 213
19 | 218
20 | 230
21 | 220
22 | 218
23 | 193
24
25 | 226
26 | 197
27 | 225
28 | 252
29 | 233
30 | 245
31 | 239
32 | 219
33 | 199
34 | 233
35 | 220
36 | 200
37 | 205
38 | 196
39 | 108
40 | 203
41 | 243
42 | 236
43 | 235
44 | 291
45 | 226
46 | 240
47 | 226
48 | 211
49 | 229
50 | 221
51 | 226
52 | 181
53 | 216
54 | 262
Average |  |  | Average
Min |  |  | Min
[NAME] |  |  | [NAME]
[NAME] |  |  | [NAME]
Spreadsheet: 201127d1355864485-simple-transfer-of-information-so-lost-master-spreadsheet-client-table
Sheet: Master

 | master
Market | Client's Name | Month/Year | Contract Amt | Contract Due | Paid to Date | [NAME].
[NAME] | [NAME] | 2012-01-01 00:00:00 | 400 | 2012-02-23 00:00:00 | 2012-02-21 00:00:00 | 0
[NAME] | [NAME] | 2012-03-01 00:00:00 | 1000 | 2012-04-01 00:00:00 | 2012-04-01 00:00:00 | 300
[NAME] | [NAME] | 2012-04-01 00:00:00 | 450 | 2012-05-05 00:00:00 | 2012-07-03 00:00:00 | 50
Colonial | [NAME] | 2012-02-01 00:00:00 | 2400 | 2012-07-06 00:00:00 | 2012-08-03 00:00:00 | 212
Total
Spreadsheet: 792070d1660727897-formula-to-auto-calculate-gestation-please-help-2022-2023-screening-db-copy
Sheet: April 22- March 23

Explanatory notes: The purpose of this spreadsheet is to act as our main ANNB screening failsafe database, monitoring each client closely to ensure seamless movement throughout the screening pathway.
Patient Details |  |  |  |  |  | Booking Details |  | Gestation Details |  |  | Bloods |  |  | ANSCT |  |  |  | Serology |  |  | Blood Group |  | First Trimester Screening |  |  |  |  |  |  |  | Second Trimester Screening |  |  |  |  |  | [NAME] |  |  |  | Anomaly Repeat |  |  | Growth |  | Referral/ Further Diagnostic Testing |  |  |  | Additional Comments | Affected by Covid-19
Surname | Forename | DOB | PASID | NHS number | Date of booking | Team | Caseload surgery | Gestation weeks | Gestation days | Live gestation from scan | Taken at booking | Reason | Date taken | Resulted before 10/40 | No- reason | Sickle Cell | Thalassaemia | HIV | [NAME] | Syphillis | Group | Antibodies | Dating scan | Gestation weeks | Gestation days | Reason for NOT having | T21 | T18/13 | <PAPP-A | <PAPP-A actioned | Reason for NOT having | Reason for having | Date taken | T21 | Raised AFP | [NAME] actioned | Reason for NOT having | Date | Gestation | Complete/for repeat scan/ referral | Date | Gestation | Complete/ incomplete | Date | Gestation | Reason for referral | Referred to | PND | Outcome
 |  |  |  |  | 2022-04-01 00:00:00 |  |  | 10 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-04-12 00:00:00 | 12 | 4 |  |  |  |  |  |  |  |  |  |  |  |  | 2022-06-06 00:00:00
 |  |  |  |  | 2022-04-01 00:00:00 |  |  | 9 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-04-22 00:00:00 | 12 | 2 |  |  |  |  |  |  |  |  |  |  |  |  | 2022-06-15 00:00:00
 |  |  |  |  | 2022-04-01 00:00:00 |  |  | 10 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-04-25 00:00:00 | 13 | 5 |  |  |  |  |  |  |  |  |  |  |  |  | 2022-06-08 00:00:00
 |  |  |  |  | 2022-04-01 00:00:00 |  |  | 11 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-04-13 00:00:00 | 12 | 4 |  |  |  |  |  |  |  |  |  |  |  |  | 2022-06-06 00:00:00
 |  |  |  |  | 2022-04-01 00:00:00 |  |  | 10 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-04-12 00:00:00 | 11 | 5 |  |  |  |  |  |  |  |  |  |  |  |  | 2022-06-14 00:00:00
 |  |  |  |  | 2022-04-01 00:00:00 |  |  | 8 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-05-03 00:00:00 | 12 | 2 |  |  |  |  |  |  |  |  |  |  |  |  | 2022-06-27 00:00:00
 |  |  |  |  | 2022-04-01 00:00:00 |  |  | 12 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-04-07 00:00:00 | 13 | 2
Spreadsheet: 208093d1358701428-scheduled-work-exceeding-available-time-copy-of-work-overload
Sheet: Sheet1

Inspection |  |  | Completion Date | Due Date | Tech | Manual Hrs | Est. Man Done | Tech | [NAME] | Est. DCC Done | Customer | Engineer | Parts | Daily notes |  |  | Hours to Outsource
a |  |  | open | 2013-01-24 00:00:00 |  | 12 |  |  | 12 |  | G | [NAME] | y |  |  |  | Manual Hrs | [NAME]
b |  |  | open | 2013-01-25 00:00:00 |  | 0 |  |  | 0 |  | G | Jake | y |  |  | 2013-01-18 00:00:00
c |  |  | open | 2013-01-24 00:00:00 |  | 4 |  |  | 4 |  | G | Ernie | y
d |  |  | open | 2013-01-25 00:00:00 |  | 8 |  |  | 8 |  | G | Crusack | y
e |  |  | open | 2013-01-18 00:00:00 |  | 5 |  |  | 5 |  | S | Beanz | y
r |  |  | open | 2013-01-18 00:00:00 |  | 4 |  |  | 4 |  | S | Beanz | y
s |  |  | open | 2013-01-22 00:00:00 |  | 0 |  |  | 0 |  | S | Beanz | y
f |  |  | open | 2013-01-22 00:00:00 |  | 6 |  |  | 6 |  | S | Beanz | y
c |  |  | open | 2013-01-22 00:00:00 |  | 8 |  |  | 8 |  | S | Hillder | y
a1 |  |  | open | 2013-01-22 00:00:00 |  | 10 |  |  | 10 |  | r | Hillder | y
a2 |  |  | open | 2013-01-23 00:00:00 |  | 8 |  |  | 8 |  | r | Hillder | y
a3 |  |  | open | 2013-01-24 00:00:00 |  | 6 |  |  | 6 |  | r | Hillder | y
a4 |  |  | open | 2013-01-24 00:00:00 |  | 6 |  |  | 6 |  | r | Hillder | y
a5 |  |  | open | 2013-01-23 00:00:00 |  | 8 |  |  | 8 |  | r | Hillder | y
a6 |  |  | open | 2013-01-25 00:00:00 |  | 10 |  |  | 10 |  | r | Hillder | y
a7 |  |  | open | 2013-01-25 00:00:00 |  | 8 |  |  | 8 |  | r | Hillder | y
b1 |  |  | open | 2013-01-23 00:00:00 |  | 6 |  |  | 6 |  | r | Hillder | y
b2 |  |  | open | 2013-01-22 00:00:00 |  | 3 |  |  | 3 |  | L | Beanz | y
b3 |  |  | open | 2013-01-22 00:00:00 |  | 12 |  |  | 12 |  | L | Beanz | y
b4 |  |  | open | 2013-01-24 00:00:00 |  | 0 |  |  | 0 |  | L | Dale | y
[NAME] |  |  | open | 2013-01-25 00:00:00 |  | 0 |  |  | 0 |  | L | Paerth | y
b6 |  |  | open | 2013-01-25 00:00:00 |  | 0 |  |  | 0 |  | L | Paerth | y
b7 |  |  | open | 2013-01-28 00:00:00 |  | 7 |  |  | 7 |  | L | Jake | y
c1 |  |  | open | 2013-01-25 00:00:00 |  | 0 |  |  | 0 |  | L | Jake | y
c2 |  |  | open | 2013-01-25 00:00:00 |  | 0 |  |  | 0 |  | L | Jake | y