tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 35791d1233445599-ignore-certain-cells-chachaexcel
Sheet: Jan

2009-01-24 00:00:00 | 00:00:00 | Network ([NAME]) | Normal | What did gone baby gone get on the ro... | 00:00:00 | 0.02 |  |  | Week |  |  |  |  | [NAME]? Yes= 1 | January
2009-01-24 00:00:00 | 00:01:00 | Network ([NAME]) | Normal | Comment The average male ejaculation ... | 00:00:00 | 0.02 |  |  | Searches | Completed | % Completion | QC |  | 0 | Week 1 | Week 2 | Week3 | Week 4
2009-01-24 00:00:00 | 00:10:00 | Specialist | Normal | what is Pizza Hut's phone number in G... | 03:41:00 | 0.1 |  |  |  |  |  | 1 |  | Complete | 605
2009-01-24 00:00:00 | 00:15:00 | Specialist | Normal | Comment i really need to know what ti... | 02:10:00 | 0.1 |  |  | Aborted | Clarified | Dropped | Total |  | Incomplete | 3
2009-01-24 00:00:00 | 00:16:00 | Network ([NAME]) | Normal | Why do I like it when my girlfriend f... | 02:02:00 | 0.02
2009-01-24 00:00:00 | 00:16:00 | Specialist | Normal | Comment I need the number to he bmw d... | 01:05:00 | 0.1 |  |  | Query/Hr | $/Hour | Best Query/Hr | Avg Q Time | Total Q Time | Questions | 601
2009-01-24 00:00:00 | 00:19:00 | Network ([NAME]) | Normal | What is the phone number for the near... | 00:00:00 | 0.02 |  |  |  |  |  |  |  | [NAME] | 1
2009-01-24 00:00:00 | 00:21:00 | Specialist | Normal | Comment Every year (Arsonal) Football... | 01:32:00 | 0.1 |  |  | Goal | Daily Goal | Over/Under | Over/Under | Hours left | Completion | 0.987
2009-01-24 00:00:00 | 00:23:00 | Specialist | Normal | what is the code you type into your c... | 01:31:00 | 0.1 |  |  | 900
2009-01-24 00:00:00 | 00:24:00 | Specialist | Normal | Who was President [NAME] married t... | 03:43:00 | 0 |  |  | Team | Bonus |  | Total (S)
2009-01-24 00:00:00 | 00:26:00 | Network ([NAME]) | Normal | When does the sun set in DC today? | 01:01:00 | 0.02
2009-01-24 00:00:00 | 00:29:00 | Network ([NAME]) | Normal | What is the number of the Golden mush... | 00:46:00 | 0.02
2009-01-24 00:00:00 | 00:31:00 | Network ([NAME]) | Normal | Who is in first place in the A series... | 01:19:00 | 0.02
2009-01-24 00:00:00 | 00:35:00 | Network ([NAME]) | Normal | Comment What's the number to greenwoo... | 01:17:00 | 0.02
2009-01-24 00:00:00 | 00:38:00 | Specialist | Normal | what do the letters in FDIC stand for! | 00:55:00 | 0.1
2009-01-24 00:00:00 | 00:40:00 | Specialist | Normal | What is a t-ball? | 00:54:00 | 0.1
2009-01-24 00:00:00 | 01:00:00 | Specialist | Normal | What is the translation for cago from... | 02:05:00 | 0.1
2009-01-24 00:00:00 | 01:10:00 | Specialist | Normal | [NAME] | 01:09:00 | 0.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0-1 | 1-2 | 2-3 | 3-4 | 4-5 | 5-6 | 6-7 | 7-8 | 8-9 | 9-10 | 10-11 | 11-12 | 12-13 | 13-14 | 14-15 | 15-16 | 16-17 | 17-18 | 18-19 | 20-21 | 21-22 | 22-23 | 23-24
Spreadsheet: 871038d1717495424-lookup-and-count-array-formula-query-attendance-spreadsheet-example-v2
Sheet: Attendances

Office Attendance Statistics
Employee | From Date | To Date | HR Absences
[NAME] | 2024-01-01 00:00:00 | 2024-01-31 00:00:00 | 7.5
[NAME] | 2024-01-01 00:00:00 | 2024-01-31 00:00:00 | 1.25
[NAME] | 2024-01-01 00:00:00 | 2024-01-31 00:00:00 | 9.75
[NAME] | 2024-01-01 00:00:00 | 2024-01-31 00:00:00 | 0
[NAME] | 2024-01-01 00:00:00 | 2024-01-31 00:00:00 | 2.25
[NAME] | 2024-01-01 00:00:00 | 2024-01-31 00:00:00 | 7
[NAME] | 2024-01-01 00:00:00 | 2024-01-31 00:00:00 | 8
[NAME] | 2024-01-01 00:00:00 | 2024-01-31 00:00:00 | 7
Spreadsheet: 722367d1615221903-allocate-and-aggregate-values-based-on-percentages-example
Sheet: Sheet1

Values | Category | Number |  | Values | Type |  | Type | Column A | Column B | Column C |  | Column B
Value A | Category A | 10 |  | Value A | Type A |  | Type A | 0.5 | 0.5 | 0
Value B | Category A | 13 |  | Value C | Type B |  | Type B | 0.1 | 0.7 | 0.2
Value C | Category B | 5 |  | Value D | Type C |  | Type C | 0.3 | 0.4 | 0.3
Value D | Category B | 6 |  | Value E | Type C
Value E | Category A | 12
Spreadsheet: 329260d1404241043-obtaining-a-average-price-from-vlookup-formula-assembly-evaluation-before
Sheet: Campbell Hausfeld

Kit # | SKU | Quantity | Initial Cost | eBay     Price | Amazon Price | Averge Price | Percent | Item Cost | StoneEdge Current
NK405400 | CHD-AMB-NK405400 |  | 108
 | CHD-NLR-CHN20103 | 1 |  | 30 | 0
 | CHD-NLR-CHN10510 | 1 |  | 0 | 0
 | CHD-NLR-NB006003 | 1 |  | 0 | 0
 | CHD-NLR-CHN10310 | 1 |  | 40 | 0
- |  |  | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
Spreadsheet: randall_gay__31452__32614_2
Sheet: Gen Maintenance

 |  |  |  |  |  |  | List Total: |  |  |  | List Total: | Credit Total
Generator Maintenance
LINE | CATALOG | CAT |  |  |  |  |  |  | SIMILAR-TO | UNIT
ITEM | NUMBER | LOC | PART NAME | PART DESCRIPTION | CYC | QTY | SYS PRICE | UM | DWG NUMBER | PRICE | LINE PRICE
 | ____________
1 |  |  | 7A6 BRG. PAD SET (5) | BEARING | 20 | 2 | 15531.6 |  | 196C8937P0004 | 15531.6
2 |  |  | AIR FILTER ASSY | OP480 BRLS EXTR DUCT | 12 | 1 | 3346.35 |  | 341A6523P0001 | 3346.35
3 |  |  | BEARING SEAL 7A6 | BEARING | 8 | 2 | 532.51 |  | 196C8937P0001 | 532.51
4 |  |  | BENTLY NEVADA PROBE-3300 | GEN FINAL ASSY | 14 | 2 | 1043.7 |  | 0699L971G0005 | 1043.7
5 |  |  | BRUSH HOLDER ASM SINGLE | MONITOR BRUSH RIGGING | 19 | 4 | 607.95 |  | 0328B691G0012 | 607.95
6 |  |  | GAS RTD ELEMENT | AIR RTD ftS HEATERS | 8 | 4 | 179.92 |  | U7193SXXXXPXXX40 | 179.92
7 |  |  | LEVEL SWITCH | BASE ASSEMBLY | 9 | 2 | 567.53 |  | 236B6152P0001 | 567.53
8 |  |  | OIL [NAME] (MACH) EPOX | PED ASSY CE/TE EPOXY | 12 | 2 | 9049.32 |  | 190D5502G0002 | 9049.32
9 |  |  | OIL [NAME] VAPOR EXTR | PED ASSY CE/TE EPOXY | 12 | 2 | 3888.15 |  | 190D5502G0004 | 3888.15
10 |  |  | RET RING INSUL ASSY | ROTOR WIND | 9 | 2 | 2150.9 |  | 326B8352G0001 | 2150.9
11 |  |  | STRIP HEATER | GLAC ASSY | 15 | 1 | 126.79 |  | 341A3898P0001 | 126.79
12 |  |  | STRIP HEATER-750W/480V | BASE ASSY | 7 | 6 | 176.4 |  | 02028J49P0002 | 176.4
13 |  |  | SWITCH PRESS | BLK & PORT/6A3/7A6 | 6 | 1 | 425.04 |  | 236B3898P0001 | 425.04
14 |  |  | SWITCH PRESS | BLK & PORT/6A3/7A6 | 6 | 1 | 364.67 |  | 196C8617P0001 | 364.67
15 |  |  | TERMINAL ASM/MAIN 7A6 | ROTOR ASSY | 9 | 2 | 5831.7 |  | 236B2333G0001 | 5831.7
16 |  |  | THERMOCOUPLE | BEARING | 7 | 4 | 228.22 |  | U7025K101U060 | 228.22
Spreadsheet: 130202d1322128153-automatically-copy-content-into-empty-cell-below-book1-1-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | Note paste special column K to column C
 | 1100 | A9B00005243 | 28.10.2011 | 2 | DP11 | PC
 | 1103 | A9B00005582 | 20.10.2011 | 28 | DP11 | PC
 | 1106 | A9B00005626 | 24.10.2011 | 100 | DP11 | PC | 4500287777 | 200006160
 | 1109 | A9B00005630 | 21.10.2011 | 100 | DP11 | PC | 4500287777 | 200006160
 | 1112 | A9B00005632 | 25.10.2011 | 92 | DP11 | PC | 5500000553 | 200000789
 | 1113 |  | 18.10.2011 | 24 |  | PC | 5500000553 | 200000789
 | 1116 | [NAME] | 05.10.2011 | 1 | DP11 | PC
 | 1119 | A9B00006093 | 25.10.2011 | 24 | DP11 | PC
 | 1120 |  | 14.10.2011 | 2 |  | PC
 | 1121 |  | 05.10.2011 | 2 |  | PC
 | 1124 | A9B00009775 | 18.10.2011 | 60 | DP11 | PC
 | 1127 | A9B00010008 | 17.10.2011 | 25 | DP11 | PC | 4500272130 | 200000870
 | 1130 | A9B00010014 | 27.10.2011 | 500 | DP11 | PC | 4500273705 | 200000870
 | 1133 | A9B00010021 | 25.10.2011 | 50 | DP11 | PC | 4500290185 | ZDP12
 | 1136 | A9B00010037 | 27.10.2011 | 100 | DP11 | PC | 4500273705 | 200000870
 | 1139 | A9B00010040 | 28.10.2011 | 100 | DP11 | PC | 4500287392 | 200000870
 | 1142 | A9B00010044 | 11.10.2011 | 20 | DP11 | PC | 4500272130 | 200000870
 | 1145 | A9B00010051 | 05.10.2011 | 100 | DP11 | PC | 4500272130 | 200000870
 | 1148 | A9B00010072 | 27.10.2011 | 10 | DP11 | PC | 4500288506 | 200000870
 | 1149 |  | 27.10.2011 | 93 |  | PC | 4500288506 | 200000870
 | 1150 |  | 27.10.2011 | 27 |  | PC | 4500288506 | 200000870
 | 1153 | A9B00010081 | 04.10.2011 | 2 | DP11 | PC | 4500286970 | ZDP11
 | 1156 | A9B00010187 | 27.10.2011 | 4 | DP11 | PC | 4500273705 | 200000870
 | 1157 |  | 05.10.2011 | 8 |  | PC | 4500272130 | 200000870
 | 1160 | A9B00010209 | 05.10.2011 | 45 | DP11 | PC | 4500272130 | 200000870
 | 1163 | [NAME] | 05.10.2011 | 400 | DP11 | PC | 4500284256 | 200000870
 | 1166 | A9B00010250 | 05.10.2011 | 300 | DP11 | PC | 4500275212 | 200000870
 | 1169 | A9B00010274 | 20.10.2011 | 8 | DP11 | PC | 4500276424 | 200000870
 | 1170 |  | 20.10.2011 | 8 |  | PC | 4500276424 | 200000870
 | 1171 |  | 12.10.2011 | 3 |  | PC | 4500276424 | 200000870
 | 1174 | A9B00010284 | 04.10.2011 | 100 | DP11 | PC | 4500284256 | 200000870
 | 1177 | A9B00010288 | 25.10.2011 | 6 | DP11 | PC | 4500273705 | 200000870
Spreadsheet: 39749d1238026892-checks-and-balance-help-checks_balances
Sheet: Detail

FSR | Actual Month | Commi Month | Supplier | End Customer | Ship To Customer/CM | Normalized Cust Name | Shipto City | State | Disti / PO # | Product Type | Product | POS Qty | ASP | POS Amt | [NAME] | Total | Comments
 | 2009-02-01 00:00:00 | 2009-04-01 00:00:00 | ABC |  |  |  |  |  |  |  |  | 25 | 2533 | 63325 | 0.02 | 1266.5
 | 2009-02-01 00:00:00 | 2009-04-01 00:00:00 | ABC |  |  |  |  |  |  |  |  | 5 | 2213 | 11065 | 0.02 | 221.3
 | 2009-02-01 00:00:00 | 2009-04-01 00:00:00 | ABC |  |  |  |  |  |  |  |  | 2 | 72750 | 145500 | 0.02 | 2910
 | 2009-02-01 00:00:00 | 2009-04-01 00:00:00 | XYZ |  |  |  |  |  |  |  |  | 1 | 240000 | 240000 | 0.02 | 4800
 | 2009-02-01 00:00:00 | 2009-04-01 00:00:00 | XYZ |  |  |  |  |  |  |  |  | 60 | 112.2 | 6732 | 0.043 | 289.476
 | 2009-02-01 00:00:00 | 2009-04-01 00:00:00 | XYZ |  |  |  |  |  |  |  |  | 40 | 112.2 | 4488 | 0.043 | 192.984
 | 2009-02-01 00:00:00 | 2009-04-01 00:00:00 | XYZ |  |  |  |  |  |  |  |  | 720 | 42.8 | 30816 | 0.043 | 1325.088
 | 2009-02-01 00:00:00 | 2009-04-01 00:00:00 | JJJ |  |  |  |  |  |  |  |  | 720 | 42.8 | 30816 | 0.043 | 1325.088
 | 2009-02-01 00:00:00 | 2009-04-01 00:00:00 | OOO |  |  |  |  |  |  |  |  | 100 | 114.39 | 11439 | 0.043 | 491.877
 | 2009-02-01 00:00:00 | 2009-04-01 00:00:00 | OOO |  |  |  |  |  |  |  |  | 1000 | 51.74 | 51740 | 0.043 | 2224.82
Spreadsheet: 5ce69cea-2948-4877-9a4d-63c5377baec1
Sheet: Sheet1

ID | DOB | FirstName | MiddleName | LastName | NickName | Suffix | Gender | HomeEmail | WorkEmail | HomePhone | WorkPhone | Address1 | Address2 | Address3 | City | State | Zip | Graduation Year | Membership Level | Participation Level Player | Participation Level Coach | Participation Level Fan | Rulebook | Guardian ID | FirstNameGuardian | LastNameGuardian | Relationship | GuardianPhone | GuardianPhoneLocation | GuardianEmail | GuardianEmailLocation | [NAME] | Carrier | Policy | YouthUpgrade | IDGuardian2 | FirstNameGuardian2 | LastNameGuardian2 | Relationship2 | GuardianPhone2 | GuardianPhone2Location | GuardianEmail2 | GuardianEmail2Location | Guardian2DOB | TeamPosition
 | [NAME]/dd/yyyy | [NAME] |  | Doe | [NAME] | [NAME] | Male | [EMAIL] | [EMAIL] | [PHONE] | [PHONE] | 123 Main St | Apt |  | City | MD (must be abbreviated) | 12345 | yyyy | Yth, HIGH, or ADULT | Y or N | Y or N | Y or N |  |  | [NAME] | Doe | Parent or Guardian | [PHONE] | HOME, WORK, or CELL | [EMAIL] | HOME or WORK | [NAME]/dd/yyyy |  |  | Y or N |  |  |  |  |  |  |  |  |  | Player or Coach
Spreadsheet: 143751d1330547204-returning-a-row-of-data-based-on-cell-reference-and-date-fuel-workook_list
Sheet: Data

RowRef | Date | Name | Registration | Start Reading | Finish Reading | Amount Taken | Reading Taken | Milage
 | 2012-02-02 00:00:00 | [NAME] | FJ08 DLY | 405244 | 405307 | 127 | 63 | 306921
 | 2012-02-03 00:00:00 | [NAME] | YJ05 YKE | 405371 | 405703 | 332 | 332 | 652904
 | 2012-02-03 00:00:00 | Kirren | GN56 LVH | 405714 | 406200 | 486 | 486 | 334126
 | 2012-02-03 00:00:00 | [NAME] | FJ08 DLY | 406200 | 406363 | 163 | 163 | 307289
 | 2012-02-07 00:00:00 | [NAME] | FJ08 DLY | 406363 | 406921 | 371 | 558 | 308178
 | 2012-02-09 00:00:00 | [NAME] | YJ05 YKE | 406422 | 407398 | 476 | 976 | 654315
 | 2012-02-10 00:00:00 | [NAME] | FJ08 DLY | 407398 | 407673 | 275 | 275 | 308784
 | 2012-02-13 00:00:00 | Kirren | GN56 LVH | 407949 | 408269 | 420 | 320 | 334894
10 | 2012-02-12 00:00:00 | Lewis | GD59 KMO | 408269 | 408343 | 74 | 74 | 30654
 | 2012-02-12 00:00:00 | [NAME] | FJ08 DLY | 408343 | 408546 | 203 | 203 | 309426
 | 2012-02-13 00:00:00 | [NAME] | YJ05 YKE | 408974 | 409364 | 389 | 390 | 655977 |  | < click last cell and [NAME] to enter new record.
Total |  |  |  |  |  |  |  | 4203468
 |  |  |  |  |  |  |  |  |  | < RowRef is hidden in column A
 |  |  |  |  |  |  |  |  |  | < last row  has Totals. [NAME]; Count etc.
Spreadsheet: 125561d1319103617-multiple-rows-display-example
Sheet: Sheet1

Subject 1 | Subject 2
1 | 2
2 | 3
4 | 1
2 | 5
0 | 4
3 | 2
5 | 0
4 | 3
1 | 3
3 | 4
5 | 5
2 | 3
1 | 2
4 | 3
3 | 4
1 | 1
2 | 5
 | and so on…
Spreadsheet: 153767d1336050459-how-to-populate-the-cells-in-one-sheet-with-data-taken-from-a-user-selected-second-sheet-book1
Sheet: Sheet3

Sheet3-1
Sheet3-2
Sheet3-3
Sheet3-4
Sheet3-5
Sheet3-6
Sheet3-7
Sheet3-8
Sheet3-9
Sheet3-10
Sheet3-11
Sheet3-12
Sheet3-13
Sheet3-14
Sheet3-15
Sheet3-16
Sheet3-17
Sheet3-18
Sheet3-19
Sheet3-20
Sheet3-21
Sheet3-22
Sheet3-23
Sheet3-24
Sheet3-25
Sheet3-26
Sheet3-27
Sheet3-28
Sheet3-29
Sheet3-30
Spreadsheet: 102111d1300148103-formula-with-2-variables-and-2-fixed-values-amenasce
Sheet: Sheet1

Month | Rent | Interest | Plus 20 | Your Anserw?
2011-01-01 00:00:00 | 5 | 6 | 20
2011-01-02 00:00:00 | 5 | 9 | 40
2011-01-03 00:00:00 | 7 | 8 | 60
2011-01-04 00:00:00 | 8 | 7 | 80
2011-01-05 00:00:00 | 9 | 6 | 100
Spreadsheet: 759896d1639786732-2-criteria-vlookup-from-messy-less-messy-payroll-file-uploadtest
Sheet: DL

Day |  |  | Date | Start |  | Finish | Position |  |  |  | Comment |  |  |  |  | Job |  |  |  |  | Quantity
Sick Discretionary Taken (SICKDISC)
Person1
Person1 |  |  | 2021-08-02 00:00:00 |  |  |  | COUNTIN |  |  |  |  |  |  |  |  | Unallocated |  |  |  |  | 8.5
Person1 |  |  | 2021-08-03 00:00:00 |  |  |  | COUNTIN |  |  |  |  |  |  |  |  | Unallocated |  |  |  |  | 8.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Employee Totals |  |  |  | 17.00
Person2
Person2 |  |  | 2021-08-04 00:00:00 |  |  |  | PICK |  |  |  |  |  |  |  |  | Unallocated |  |  |  |  | 8.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Employee Totals |  |  |  | 8.5
Spreadsheet: 723713d1615847141-cashflow-weekend-and-public-holiday-work-around-cashflow
Sheet: Sheet2

Calculations used to get from Start to Final allowing for Public Holidays (PH) and Weekends (WE)
START |  |  |  |  |  |  | FINAL
[NAME] date | Day of week | If Public Hol | If PH plus 1 | If still  PH plus 1 | If Sat plus 1 or Sun plus 2 | Check | if Now PH plus 1 |  | Var col  j to col  H | Var col J to col  A
2021-01-01 00:00:00
Spreadsheet: 8059ca51-5d58-4b05-918e-430c54472125
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
CFTH | Test | CFTH | Canary Feathers, IgE | Canary Feathers, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
CFTH | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
CFTH | Result | CFTH | Canary Feathers, IgE | Canary Feathers, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 7171-2
Spreadsheet: 647031d1572254839-vlookup-or-formula-to-return-a-number-related-to-a-word-that-is-typed-into-a-cell-pq-reshaping-tennis-data-aligw
Sheet: Sheet4

Column1 | PLAYER 1 | PLAYER 2 |  |  | PLAYER 1 | year | summary | Hard | Clay | I. hard | Carpet | Grass | Acrylic
Name | [NAME] | [NAME] |  |  | PLAYER 1 | 2019 | 21/19 | 43809 | 43590 | 43498 | 0/0 | 43498 | 0/0
Country | Croatia | Poland |  |  | PLAYER 1 | 2018 | 45/20 | 20/8 | 15/6 | 43560 | 0/0 | 43617 | 0/0
Birthdate | 28.09.88, 31 years | 11.02.97, 22 years |  |  | PLAYER 1 | 2017 | 46/22 | 43807 | 14/4 | 43684 | 0/0 | 43802 | 0/0
Height | 195 cm |  |  |  | PLAYER 1 | 2016 | 49/24 | 21/11 | 43558 | 17/7 | 0/0 | 43649 | 0/0
Weight | 79 kg |  |  |  | PLAYER 1 | 2015 | 35/19 | 15/8 | 43652 | 43618 | 0/0 | 43649 | 0/0
Profi since | 2005 |  |  |  | PLAYER 1 | 2014 | 54/21 | 24/9 | 43775 | 15/4 | 0/0 | 43557 | 0/0
Right-handed | Right-handed |  |  |  | PLAYER 1 | 2013 | 26/13 | 43650 | 43651 | 43648 | 0/0 | 43587 | 0/0
ATP ranking | 23 | 35 |  |  | PLAYER 1 | 2012 | 41/20 | 14/9 | 16/7 | 43498 | 0/0 | 43710 | 0/0
TOP ranking's position | 3 (16.04.18, 4985 points) | 33 (14.10.19, 1298 points) |  |  | PLAYER 1 | 2011 | 44/23 | 14/9 | 13/7 | 15/5 | 0/0 | 43498 | 0/0
Points | 1545 | 1298 |  |  | PLAYER 1 | 2010 | 40/22 | 19/10 | 43713 | 43774 | 0/0 | 43467 | 0/0
Prize money | 27.022.364 $ | 1.517.157 $ |  |  | PLAYER 1 | 2009 | 49/23 | 22/12 | 43775 | 14/3 | 0/0 | 43498 | 0/0
Matches total | 931 | 356 |  |  | PLAYER 1 | 2008 | 38/26 | 20/10 | 43623 | 43560 | 43466 | 43649 | 0/0
Win | 612 | 217 |  |  | PLAYER 1 | 2007 | 50/22 | 43683 | 22/7 | 43773 | 43587 | 43558 | 0/0
% | 65.74 % | 60.96 % |  |  | PLAYER 1 | 2006 | 41/29 | 43588 | 15/15 | 43803 | 43560 | 43587 | 0/0
 |  |  |  |  | PLAYER 1 | 2005 | 30/13 | 43618 | 16/6 | 43588 | 0/1 | 43525 | 0/0
 |  |  |  |  | PLAYER 1 | 2004 | 43527 | 43466 | 43466 | 43466 | 0/0 | 0/0 | 0/0
 |  |  |  |  | PLAYER 2 | 2019 | 36/26 | 23/11 | 43653 | 43501 | 0/0 | 43558 | 0/0
 |  |  |  |  | PLAYER 2 | 2018 | 52/30 | 22/15 | 16/4 | 43714 | 43526 | 43499 | 0/0
 |  |  |  |  | PLAYER 2 | 2017 | 56/32 | 33/13 | 43811 | 43529 | 43679 | 0/0 | 0/0
 |  |  |  |  | PLAYER 2 | 2016 | 48/28 | 43713 | 29/14 | 43745 | 0/2 | 0/0 | 0/0
 |  |  |  |  | PLAYER 2 | 2015 | 20/17 | 43740 | 43685 | 43469 | 43467 | 0/1 | 0/0
 |  |  |  |  | PLAYER 2 | 2014 | 43590 | 43498 | 43526 | 0/0 | 0/0 | 0/1 | 0/0
 |  |  |  |  | PLAYER 2 | 2012 | 0/1 | 0/0 | 0/1 | 0/0 | 0/0 | 0/0 | 0/0
Spreadsheet: 467252d1466625881-hyperlink-with-vlookup-hyperlink
Sheet: Lookup

 |  |  | Profit Center - Change, Cost Centre - Change/Block
 |  |  | A. Change Profit Centre, B. Change_Block CC
 |  |  |  |  |  |  | Answers | Sheet
 |  |  | Answer | Sheet |  |  | Profit Center - Create | A. Change Profit Centre
 |  |  | Profit Center - Create |  |  |  | Profit Center - Change | [NAME]
 |  |  | Profit Center - Change | A. Change Profit Centre |  |  | Cost Centre - Create | C. Change WBS
 |  |  | Cost Centre - Create |  |  |  | Cost Centre - Change/Block | D. Create_Change Network
 |  |  | Cost Centre - Change/Block | [NAME] |  |  | WBS - Create | E. PR or Applicant Mass Change
 |  |  | WBS - Create |  |  |  | WBS - Change | F. RP New
 |  |  | WBS - Change |  |  |  | Service Order - Create/Change | [NAME]
 |  |  | Service Order - Create/Change |  |  |  | Internal Order - Create/Change | H. Service Order
 |  |  | Internal Order - Create/Change |  |  |  | Networks/Network Activities - Create/Change | I. Internal Order
 |  |  | Networks/Network Activities - Create/Change |  |  |  | Person Responsible - Change | J Partner Tab
 |  |  | Person Responsible - Change |  |  |  | Person Responsible - New/Delete
 |  |  | Person Responsible - New/Delete |  |  |  | Applicant - Change
 |  |  | Applicant - Change |  |  |  | Applicant - New/Delete
 |  |  | Applicant - New/Delete |  |  |  | [NAME]
 |  |  | [NAME] |  |  |  | Cost Object Closure/Blocking
 |  |  | Cost Object Closure/Blocking |  |  |  | Tagging Changes
 |  |  | Tagging Changes |  |  |  | Don't Know/Unsure
 |  |  | Don't Know/Unsure
Spreadsheet: 211926d1359992287-sort-function-results-sort-values
Sheet: Sheet1

5-20 |  |  |  | 5-20 | 2 | 5 | 20 |  | 5 | 20 |  | 4 | 2
5-22 |  |  |  | 5-22 | 2 | 5 | 22 |  | 5 | 22 |  | 4 | 6
5-24 |  |  |  | 5-24 | 2 | 5 | 24 |  | 5 | 24 |  | 4 | 18
4-18 | y | 19-12-2012 |  | 4-18 | 2 | 4 | 18 |  | 4 | 18 |  | 4 | 34
4-34 | y | 19-12-2012 |  | 4-34 | 2 | 4 | 34 |  | 4 | 34 |  | 4 | 46
5-30 | y | 19-12-2012 |  | 5-30 | 2 | 5 | 30 |  | 5 | 30 |  | 5 | 2
5-46 | y | 19-12-2012 |  | 5-46 | 2 | 5 | 46 |  | 5 | 46 |  | 5 | 6
5-35 | y | 19-12-2012 |  | 5-35 | 2 | 5 | 35 |  | 5 | 35 |  | 5 | 8
5-8 | y | 19-12-2012 |  | 5-8 | 2 | 5 | 8 |  | 5 | 8 |  | 5 | 10
5-16 | y | 19-12-2012 |  | 5-16 | 2 | 5 | 16 |  | 5 | 16 |  | 5 | 12
5-38 | y | 19-12-2012 |  | 5-38 | 2 | 5 | 38 |  | 5 | 38 |  | 5 | 14
5-18 | y | 19-12-2012 |  | 5-18 | 2 | 5 | 18 |  | 5 | 18 |  | 5 | etc
5-12 | y | 19-12-2012 |  | 5-12 | 2 | 5 | 12 |  | 5 | 12 |  | 5 | etc
5-40 | y | 19-12-2012 |  | 5-40 | 2 | 5 | 40 |  | 5 | 40 |  | 5
5-10 | y | 19-12-2012 |  | 5-10 | 2 | 5 | 10 |  | 5 | 10 |  | 5
5-14 | y | 19-12-2012 |  | 5-14 | 2 | 5 | 14 |  | 5 | 14 |  | 5
5-2 | y | 19-12-2012 |  | 5-2 | 2 | 5 | 2 |  | 5 | 2 |  | 5
4-2 | y | 19-12-2012 |  | 4-2 | 2 | 4 | 2 |  | 4 | 2 |  | 5
5-6 | y | 19-12-2012 |  | 5-6 | 2 | 5 | 6 |  | 5 | 6 |  | 5
5-34 | y | 19-12-2012 |  | 5-34 | 2 | 5 | 34 |  | 5 | 34 |  | 5
4-6 | y | 19-12-2012 |  | 4-6 | 2 | 4 | 6 |  | 4 | 6 |  | 5
4-46 | y | 19-12-2012 |  | 4-46 | 2 | 4 | 46 |  | 4 | 46 |  | 5
Spreadsheet: 858888d1707392819-help-sumif-multiple-tabs-example2
Sheet: December 

Name | NHS | 1st | 2nd | 3rd | Seen | Comments |  |  | Month Summary
Name 150
Name 151
Name 152 |  |  |  |  |  |  |  |  | Done Totals
Name 153 |  |  |  |  |  |  |  |  | Outstanding Totals
Name 154
Name 155
Name 156
Name 157
Name 158
Name 159
Name 160
Name 161
Spreadsheet: 34983d1232462727-excel-2007-excel-2007-cant-save-bol-and-color-cells-on-my-worksheet-sheet1
Sheet: Sheet1

 | WEEKLY STATUS
 |  |  | New
 | Project # |  | Status Change description | Current
Developer | UNxxxx | Acct/Client | For This Week | Status | ECM
Developer 1 | 1 | Co 1 | Pending | active
Developer 2 | 1 | Co 2 | Working in Profress | active
Spreadsheet: 700813d1603356077-if-functions-with-two-conditions-test-if-or-ifs-3
Sheet: Feuille 3

Français 2019-2020 | [NAME] | Français 2018-2019 | [NAME] | Comparatif
0.8044 | A | 1
0.2 | D | 0.2
0.2 | D | 0.4
0.2 | D | 0.6
0.2 | D | 0.8
0.4 | C | 0.2
0.4 | C | 0.4
0.4 | C | 0.6
0.4 | C | 0.8
0.6 | B | 0.2
0.6 | B | 0.4
0.6 | B | 0.6
0.6 | B | 0.8
0.8 | A | 0.8
0.8
Spreadsheet: 48260d1247506080-multiple-date-range-lookup-book3
Sheet: Sheet1

DATA |  | 1 | 0.75 | 0.5 | 0.25
commission | date | current month | next month | next 2 months | after
 |  | 2009-07-31 00:00:00 | 2009-08-31 00:00:00 | 2009-10-01 00:00:00 | 2009-11-01 00:00:00
12345 | 2009-06-02 00:00:00 | 12345 | 9258.75 | 6172.5 | 3086.25
5000 | 2009-11-15 00:00:00 | 0 | 0 | 0 | 0
300 | 2009-08-30 00:00:00 | 0 | 225 | 150 | 75
1000 | 2009-09-15 00:00:00 | 0 | 0 | 500 | 250
Trying to get this result
12345 | 2009-06-02 00:00:00 | 12345
5000 | 2009-11-15 00:00:00 |  |  |  | 1250
300 | 2009-08-30 00:00:00 |  | 225
1000 | 2009-09-15 00:00:00 |  |  | 500