tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 231184d1366974739-moving-row-to-another-sheet-client
Sheet: Active

Name | Address | [NAME] | Telephone | Select
[NAME] | 22 Wellington Close | [EMAIL] | 123456 | Active |  |  | Active
[NAME] | 16 Warfdale Ave | [EMAIL] | 223344 | Inactive |  |  | Inactive
[NAME] | 27 [NAME] | [EMAIL] | 556633 | Active
Spreadsheet: 4ff4dbde-2337-4b7c-af07-c16c203cf53c
Sheet: Sheet1

WHITEFISH 2011 VOLLEYBALL | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
FROSH
NUMBER | PLAYER | GRADE | POSITION
3 | [NAME] | 9 | OH
4 | [NAME] | 9 | OH
10 | Haley Delagnes | 9 | S
12 | [NAME] | 9 | MH
13 | [NAME] | 9 | RH
14 | [NAME] | 9 | S
21 | [NAME] | 9 | OH
20 | [NAME] | 9 | MH
JV
3 | [NAME] | 9 | OH
4 | [NAME] | 10 | DS
5 | [NAME] | 9 | OH
10 | [NAME] | 10 | RH
11 | [NAME] | 11 | OH
12 | Brittany Barnes | 10 | DS
20 | [NAME] | 10 | S
21 | Sloan Ellis | 10 | RH
23 | [NAME] | 10 | RH
24 | [NAME] | 10 | RH
VARSITY
3 | [NAME] | 11 | DS
4 | [NAME] | 12 | RH
5 | [NAME] | 12 | S
10 | [NAME] | 11 | DS
11 | [NAME] | 11 | DS
12 | [NAME] | 10 | DS
13 | Brooke Silliker | 11 | MH
14 | Marlow Schulz | 10 | S/OH
15 | [NAME] | 12 | OH
21 | [NAME] | 11 | MH
23 | [NAME] | 11 | RH
Coaches
Freshmen: [NAME]
Junior Varsity: [NAME]
Varsity: [NAME]
Assistant: Amber Massey
Managers
Lauren Cain
[NAME]
Carly [NAME]
[NAME]
Administrators
Principal: [NAME]
Activities Director: [NAME]
Spreadsheet: 92974d1292491518-month-wise-datas-change-if-the-common-factor-change-power
Sheet: 2010-2011

 | 2010-2011 | 2010-09-01 00:00:00 |  |  | 2010-10-01 00:00:00 |  |  | 2010-11-01 00:00:00
 | PLANT | HHHD | HHHG | HHHU | HHHD | HHHG | HHHU | HHHD | HHHG | HHHU
 | Power Cost/Veh. | 10.85336542451656 | 0 | 48.97252244000733 | 13.82056049940231 | 0 | 55.8443055545246 | 22.68187782167043 | 0 | 64.99120917329947
 | Fuel Cost for Generation/Veh. | 234.0116134326009 | 262.5277546748775 | 48.21157469127451 | 185.0415837045944 | 263.7833655075366 | 34.39756027537543 | 186.740447819184 | 256.4678885369318 | 24.85272479408575
 | Other Fuel Cost/Veh. | 33.94902330073798 | 6.323536788955162 | 20.06505695809588 | 28.09664620641633 | 1.916178992998357 | 19.22340098472893 | 26.45870045959707 | 2.08385751936272 | 20.00278825609679
 | Total Power and Fuel Cost/Veh | 278.8140021578554 | 268.8512914638327 | 117.2491540893777 | 226.9587904104131 | 265.699544500535 | 109.465266814629 | 235.8810261004515 | 258.5517460562945 | 109.846722223482
Spreadsheet: 685858d1594229383-formula-to-find-a-value-in-a-chart-chart
Sheet: Sheet1

[NAME] | AMOUNT |  |  |  | [NAME] | LOW | MED | HIGH | HIGHPLUS
50 | 90 |  |  |  | 50 | 114 | 230 | 330 | 331
60 | 118 |  |  |  | 60 | 114 | 230 | 330 | 331
70 | 300 |  |  |  | 70 | 114 | 230 | 330 | 331
80 | 30 |  |  |  | 80 | 114 | 230 | 330 | 331
90 | 540 |  |  |  | 90 | 114 | 230 | 330 | 331
100 | 130 |  |  |  | 100 | 114 | 230 | 330 | 331
 | Result should be
 | 50 | LOW
 | 60 | MED
 | 70 | MED
 | 80 | LOW
 | 90 | HIGHPLUS
 | 100 | MED
Spreadsheet: 687054d1594928941-heavy-file-for-calculation-and-save-dates
Sheet: W Test

Sr.
 | File Name | Ext | Date | File Name | Ext | Date | File Name | Ext | Date | File Name | Ext | Date | File Name | Ext | Date
 | 01-01) 16-01-2019 | pdf |  | 01-01) 15-01-2019 | pdf |  | 02-01) 17-02-2019 | pdf |  | 01-01) 15-01-2019 | pdf |  | 01-01) 15-01-2019 | pdf
 | 01-02) 16-01-2019 | pdf |  | 02-01) 14-02-2019 | pdf |  | 04-01) 16-04-2019 | pdf |  | 02-01) 18-02-2019 | pdf |  | 02-01) 17-02-2019 | pdf
 | 02-01) 18-02-2019 | pdf |  | 03-01) 27-03-2019 | pdf |  | 07-01) 17-07-2019 | pdf |  |  |  |  | 04-01) 16-04-2019 | pdf
 | 02-02) 18-02-2019 | pdf |  | 05-01) 09-05-2019 | pdf |  | 05-01) 07-05-2020 | pdf |  |  |  |  | 09-01) 28-09-2019 | pdf
 | 05-01) 25-05-2019 | pdf |  | 08-01) 04-08-2019 | pdf |  | 06-01) 02-06-2020 | pdf |  |  |  |  | 12-01) 15-12-2019 | pdf
 | 07-01) 20-07-2019 | pdf |  | 11-01) 04-11-2019 | pdf |  |  |  |  |  |  |  | 03-01) 25-03-2020 | pdf
 | 09-01) 28-09-2019 | pdf |  | 02-01) 16-02-2020 | pdf
 | 12-01) 15-12-2019 | pdf
 | 03-01) 28-03-2020 | pdf
Spreadsheet: 734133d1622003494-i-would-like-a-cell-to-auto-fill-based-on-the-value-of-another-d-and-d-nerd-help
Sheet: Data

Size | MV | #ATT | DMG |  | Type | [NAME] |  | Level | [NAME] | Bad Save
Small | 14 | 1 | 2d4 |  | Aberrant | Mental |  | 1 | 7 | 5
Medium | 12 | 1 | 2d6 |  | Beast | Physical |  | 2 | 8 | 6
Large | 10 | 2 | 2d8 |  | Construct | Mental |  | 3 | 9 | 7
Huge | 8 | 3 | 2d10 |  | Devil | Both |  | 4 | 10 | 8
Gargantuan | 4 | 4 | 2d12 |  | Dragon | Both |  | 5 | 11 | 9
 |  |  |  |  | Elemental | Physical |  | 6 | 12 | 10
 |  |  |  |  | Fey | Mental |  | 7 | 13 | 11
 |  |  |  |  | Humanoid | Physical |  | 8 | 14 | 12
 |  |  |  |  | Ooze | Mental |  | 9 | 15 | 13
 |  |  |  |  | Plant | Physical |  | 10 | 16 | 14
 |  |  |  |  | Undead | Mental |  | 11 | 17 | 15
 |  |  |  |  |  |  |  | 12 | 18 | 16
 |  |  |  |  |  |  |  | 13 | 19 | 17
Spreadsheet: kate_symes__18092__Deal Correction 12-4
Sheet: Current Day

Adjustment date | Date of applied calc | Deal Date | Desk | Reason | Correction located by: | Broker | Change | Details of reason | Deal # | Delivery | Term | Hours p/op/rtc | MW | Price | Counterparty
2000-12-05 00:00:00 | 2000-12-05 00:00:00 | 2000-12-01 00:00:00 | STCA | CM | Houston | APB | Broker: from Prebon to APB |  | 471898 | SP-15 | 2000-12-04 00:00:00 | On peak | 25 | 218 | TransAlta
2000-12-05 00:00:00 | 2000-12-05 00:00:00 | 2000-12-01 00:00:00 | STCA | JR | Houston | APB | Broker: from no broker to APB |  | 471977 | SP-15 | BOM | On peak | 25 | 214.95 | EES
2000-12-05 00:00:00 | 2000-12-05 00:00:00 | 2000-12-01 00:00:00 | STCA | JR | Houston | Prebon | Broker: from no broker to Prebon |  | 471975 | SP-15 | BOM | On peak | 25 | 214.95 | EES
2000-12-05 00:00:00 | 2000-12-05 00:00:00 | 2000-12-01 00:00:00 | STNW | SC | Houston | APB | Broker: from Amerex to APB |  | 471842/841 | Mid-C | BOM | On peak | 50 | 310 | Avista/Powerex
2000-12-05 00:00:00 | 2000-12-05 00:00:00 | 2000-12-01 00:00:00 | STNW | SC | Houston | APB | Broker: from Amerex to APB
 |  |  | Grand Count
Spreadsheet: 672904d1587059851-comparing-2-columns-to-see-if-it-is-duplicated-book1
Sheet: Sheet1

 |  |  |  | Match formula is what I am trying to get at.
 |  |  |  | It has to have the same name in column 1 and column 2
 |  | Company 1 | Company 2 | Match
 |  | Apple | Facebook | Yes | <-- [NAME] here?
 |  | Microsoft | Yahoo | no
 |  | Apple | Facebook | Yes
 |  | Microsoft | Facebook | no
 |  | Apple | Microsoft | no
Spreadsheet: 815403d1674922267-sequential-numbering-skipping-blank-rows-sequential-numbering-with-blanks_sample
Sheet: Outcome

Firstname | Lastname | Numbering
 |  | 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
Spreadsheet: 133859d1324712127-extract-data-from-one-sheet-to-another-copy_123
Sheet: Inventory

Inventory Details
Sl No | Date | Invoice No | Lot No | Bag Details | Total bags | Vehical No | Transport | Dispatch To
161 | 2011-11-26 00:00:00 | 722 | 148 | 5
 |  | 722 | 140 | 400
 |  | 722 | 157 | 40 | 445 | AP 07 TB 6888 | karnataka [NAME] | C.P Vizianagaram
162 | 2011-11-27 00:00:00 | 723 | 148 | 2
 |  | 723 | 157 | 20
 |  | 723 | 150 | 400 | 422 | TN 28 AF 5351 | Sai Logostic | C.P Vizianagaram
163 | 2011-11-27 00:00:00 | 724 | 148 | 5
 |  | 724 | 157 | 20
 |  | 724 | 160 | 400 | 425 | TN 28 AF 1193 | Sai Logostic | C.P Vizianagaram
164 | 2011-11-28 00:00:00 | 726 | 148 | 5
 |  | 726 | 157 | 20
 |  | 726 | 159 | 400 | 425 | TN 28 AF 9646 | Sai Logostic | C.P Vizianagaram
165 | 2011-11-28 00:00:00 | 727 | 148 | 4
 |  | 727 | 157 | 20
 |  | 727 | 147 | 400 | 424 | TN 28 AF 3911 | Sai Logostic | C.P Vizianagaram
166 | 2011-11-30 00:00:00 | 728 | 164 | 400
 |  | 728 | 157 | 20
 |  | 728 | 148 | 1 | 421 | TN 52 A 7178 | Sai Logostic | C.P Vizianagaram
 |  | 729 | 148 | 2 | 442 | TN 28 AH 0293 | [NAME] | C.P Vizianagaram
168 | 2011-12-02 00:00:00 | 730 | 163 | 340
 |  | 730 | 148 | 1 | 341 | AP 26 Y 2589 | Mangala Roadways | C.P Vizianagaram
175 | 2011-12-08 00:00:00 | 739 | 154 | 45
 |  | 739 | 170 | 235
 |  | 739 | 172 | 60 | 340 | AP 05 TT 6171 | karnataka [NAME] | C.P Vizianagaram
176 | 2011-12-08 00:00:00 | 740 | 172 | 340 | 340 | AP 05 TT 5907 | karnataka [NAME] | C.P Vizianagaram
177 | 2011-12-10 00:00:00 | 741 | 154 | 355
 |  | 741 | 155 | 68 | 423 | TN 28 AF 3875 | [NAME] | C.P Vizianagaram
178 | 2011-12-10 00:00:00 | 742 | 180 | 400
 |  | 742 | 155 | 20 | 420 | TN 28 AF 9911 | [NAME] | C.P Vizianagaram
Spreadsheet: 678519d1589931578-counting-over-several-pages-and-if-conditions-arent-met-then-blank-iauditor-dashboard-for-example
Sheet: 18 May 20 - 23 May 20

IAuditor Health & Safety Docs Dashboard
 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Percentage
Daily Pre Start - Foremen | 2020-05-18 00:00:00 | 2020-05-19 00:00:00 | 2020-05-20 00:00:00 | 2020-05-21 00:00:00 | 2020-05-22 00:00:00 | 2020-05-23 00:00:00 | ❌ | ✓ |  | Weekly Workplace Inspection  - Foremen | 18/05/2020 - 23/05/2020
Dameon | ✓ | ✓ | ✓ |  |  |  |  |  |  | Dameon | ✓
[NAME] | ✓ | ✓ | ✓ |  |  |  |  |  |  | [NAME] | ✓
[NAME] | ✓ | ✓ | ✓ |  |  |  |  |  |  | [NAME]
[NAME] | ✓ | ✓ | ✓ |  |  |  |  |  |  | [NAME]
[NAME] | ✓ | ✓ | ✓ |  |  |  |  |  |  | [NAME] | ✓
Harley | ✓ | ✓ | ✓ |  |  |  |  |  |  | Harley | ✓
[NAME] | ✓ | ✓ | ✓ |  |  |  |  |  |  | [NAME] | ✓
[NAME] | ✓ | ✓ | ✓ |  |  |  |  |  |  | [NAME] | ✓
Nathan | ✓ | ✓ | ✓ |  |  |  |  |  |  | Nathan | ✓
[NAME] | ✓ | ✓ | ✓ |  |  |  |  |  |  | [NAME]
[NAME] | ✓ | ✓ | ✓ |  |  |  |  |  |  | [NAME]
Tyson | ✓ | ✓ | ✓ |  |  |  |  |  |  | Tyson | ✓
Will | ✓ | ✓ | ✓ |  |  |  |  |  |  | Will | ✓
Daily Pre Start - Contractors |  |  |  |  |  |  |  |  |  | Weekly Workplace Inspection  - Contractors
 | N/A | N/A
 | ✓ | ❌ | ✓
Edge Protection [NAME] |  |  | 18/05/2020 - 23/05/2020 |  |  |  |  |  |  | Fortnightly [NAME] Foremen | 18/05/2020 - 23/05/2020
Laminex |  |  | ✓ |  |  |  |  |  |  | Dameon | ✓
Wilson |  |  |  |  |  |  |  |  |  | [NAME] | ✓
Canterbury Linen Services |  |  | ✓ |  |  |  |  |  |  | [NAME]
6 Doric Way |  |  | ✓ |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | Harley
 |  |  |  |  |  |  |  |  |  | [NAME]
Incidents/Accidents/Near Misses - Site |  |  | Type |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | Nathan
 |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | [NAME] | ✓
 |  |  |  |  |  |  |  |  |  | Tyson
 |  |  |  |  |  |  |  |  |  | Will
 |  |  |  |  |  |  |  |  |  | Fortnightly [NAME]
*** Means received but had to ask for it |  |  |  |  |  |  |  |  |  |  | ✓
❌   Means did not get one at all
Spreadsheet: 70e1586a-39d3-4384-850a-e78a9cfaa5a0
Sheet: Sheet1

Unnamed: 0 | ROTARY INTERNATIONAL PUBLIC RELATIONS GRANT KOSTENERSTATTUNGSFORMULAR | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 | Distrikt #___________________________ | RI Fiskaljahr 12/13
 | Kontakt Name/E-Mail _________________________________               GRANT-SUMME _______________________ | [NAME]  A BERICHTSFORMULAR BEIGEFÜGT A |  |  | SPA TO A/P ________________
 |  |  |  |  |  |  | LEISTUNGS    NACHWEIS
 | Welche Ausgaben zulässig sind, kann im [NAME] Ihrem Grant nachgelesen werden. Bitte legen Sie diesem Formular eine Kopie der [NAME], einen Zahlungsbeleg ([NAME], stornierter [NAME] etc.), einen Nachweis über die erfüllte [NAME] bei. Informationen zur Währungsumrechnung finden Sie auf [NAME]. http://www.rotary.org/RIdocuments/en_pdf/rits_payment_guidelines_en.pdf
 |  |  |  |  | BELEG BEIGEFÜGT | RECHNUNG  BEIGEFÜGT
 |  |  | WÄHRUNG | AUSGABE INSG.
 | DIENSTLEISTER & BESCHREIBUNG DER AUSGABE | DATUM
 | (Felder in gelb bitte nicht ausfüllen) Office Use Only. Notes: |  | Zwischensumme |  | [NAME]
 |  |  | Office Use Only |  | Currency exchange rate
 |  |  |  |  | Total US$
 |  |  |  |  | [NAME] amount  (local currency)
 |  |  | TOTAL |  | TOTAL  US$ AMOUNT PAID
Spreadsheet: 883092d1731579145-linking-two-sheets-with-data-specific-information-job-book-test-1
Sheet: Job Regsiter 

Sample No | Sample Identification | Sample Identification2 | Sample Identifcation | Incriments | Mass  Received | Sample Type | Date  Received | Job Number | Client | Order Number | Job Details | Prep | CL | HAC | A/C | MIX | A/S SO3 | W/S SO4 | tS | S2- | MCHW Sulphate Suite | [NAME] | Alkalis | Volhard | Paint | Water | C/S | Other
1 |  |  |  |  |  |  |  | 22499 | [NAME] | dfbv | dfgb | x | x | x | x
2 |  |  |  |  |  |  |  |  |  |  |  | x | x |  | x
3 |  |  |  |  |  |  |  |  |  |  |  |  | x | x
4 |  |  |  |  |  |  |  |  |  |  |  | x | x |  | x
5 |  |  |  |  |  |  |  |  |  |  |  |  | x | x
6 |  |  |  |  |  |  |  | 22500
7
8
9
10
11
12
13
14
15
Spreadsheet: 00d61013-3573-4c27-bf19-bc793fcf7c4d
Sheet: Lab Roster

Lab Training |  |  | PI: | last updated:
Name of Employee | Principal Investigator of the lab in which you are working | Department | E-mail | Employee ID or POI # for non-employees | Student ID | General job title: PI, [NAME], Undergrd, PRA | Field Research | Enrolled in Occupational Health | Completed IACUC Training |  | A | B | C | D | E | F | G | H | I | J | K | L | M | N |  |  |  |  |  |  | List all animal species (common names) that you are working with. | Have you taken the IACUC training? | Are you New to conducting CU Boulder Animal Research?
Example |  |  |  |  |  |  | Yes | Yes | Yes |  | P- 15yrs |  | In Training by [NAME] |  |  | P-01/02/2011 Trained by T. Monk |  | P |  |  |  |  |  | T
 |  |  |  |  |  |  |  |  |  | 2010-01-03 00:00:00
 |  |  |  |  |  |  |  |  |  | 2011-04-22 00:00:00
 |  |  |  |  |  |  |  |  |  | 2011-01-06 00:00:00
Procedures
A:  [NAME] care (rats) |  | G: |  | M:
B: |  | H: |  | N:
C: |  | I:
D: |  | J:
E: |  | K:
F: |  | L:
P:  Skilled in procedure
(T): Training in procedure
Spreadsheet: 3227eabc-934f-45c7-9f99-920a77e2687c
Sheet: PPI 002

Permit No.: |  | WQ0034380 |  | Facility Name: |  | Sanderson Farms WWTF |  |  |  |  | County: | Lenoir |  | Month: |  |  | Year:
PPI: |  | 002 | Flow Measuring Point: |  |  |  |  |  |  | Parameter Monitoring Point:
Parameter Code |  |  | 31616 | 00610 | 00620 | 00600 | 00400 | 00665
Day | ORC Arrival Time | ORC Time On Site
 | 24-hr | hrs
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
Average:
Daily Maximum:
Daily Minimum:
Sampling Type: |  |  | Grab | Grab | Grab | Grab | Grab | Grab
Monthly Limit:
Daily Limit:
Sample Frequency: |  |  | 3 x Year | 3 x Year | 3 x Year | 3 x Year | 3 x Year | 3 x Year
Spreadsheet: 689582d1596531234-counting-between-dates-with-added-criterion-dummy-sheet
Sheet: Sheet1

 | Breach = 'TRUE' (Columns K, N and Q)
 | Start | 2020-07-22 00:00:00
 | End Date | 2020-06-10 00:00:00
 | Fund Name | Breaches |  |  |  |  | Return as of | My Portfolio |  |  | [NAME]'s Portfolio |  |  | [NAME]'s Portfolio
 |  |  |  |  |  |  |  | 1 Day Return (%) | 3 Day Return (%) | Breaches | 1 Day Return (%) | 3 Day Return (%) | Breaches | 1 Day Return (%) | 3 Day Return (%) | Breaches
 | My Portfolio |  |  |  |  |  | 2020-06-10 00:00:00 |  |  | False |  |  | False |  |  | False
 | [NAME]'s Portfolio |  |  |  |  |  | 2020-06-11 00:00:00 |  |  | False |  |  | True |  |  | False
 | [NAME]'s Portfolio |  |  |  |  |  | 2020-06-12 00:00:00 |  |  | False |  |  | True |  |  | False
 |  |  |  |  |  |  | 2020-06-15 00:00:00 |  |  | False |  |  | False |  |  | False
 |  |  |  |  |  |  | 2020-06-16 00:00:00 |  |  | False |  |  | False |  |  | False
 |  |  |  |  |  |  | 2020-06-17 00:00:00 |  |  | False |  |  | False |  |  | True
 |  |  |  |  |  |  | 2020-06-18 00:00:00 |  |  | False |  |  | True |  |  | False
 |  |  |  |  |  |  | 2020-06-19 00:00:00 |  |  | False |  |  | False |  |  | False
 |  |  |  |  |  |  | 2020-06-22 00:00:00 |  |  | False |  |  | False |  |  | False
 |  |  |  |  |  |  | 2020-06-23 00:00:00 |  |  | False |  |  | False |  |  | False
 |  |  |  |  |  |  | 2020-06-24 00:00:00 |  |  | True |  |  | True |  |  | True
 |  |  |  |  |  |  | 2020-06-25 00:00:00 |  |  | False |  |  | False |  |  | False
 |  |  |  |  |  |  | 2020-06-26 00:00:00 |  |  | False |  |  | False |  |  | False
 |  |  |  |  |  |  | 2020-06-29 00:00:00 |  |  | False |  |  | False |  |  | False
 |  |  |  |  |  |  | 2020-06-30 00:00:00 |  |  | False |  |  | False |  |  | False
 |  |  |  |  |  |  | 2020-07-01 00:00:00 |  |  | False |  |  | False |  |  | False
 |  |  |  |  |  |  | 2020-07-02 00:00:00 |  |  | True |  |  | False |  |  | True
 |  |  |  |  |  |  | 2020-07-03 00:00:00 |  |  | False |  |  | False |  |  | False
 |  |  |  |  |  |  | 2020-07-06 00:00:00 |  |  | False |  |  | False |  |  | False
 |  |  |  |  |  |  | 2020-07-07 00:00:00 |  |  | True |  |  | True |  |  | True
 |  |  |  |  |  |  | 2020-07-08 00:00:00 |  |  | False |  |  | False |  |  | False
 |  |  |  |  |  |  | 2020-07-09 00:00:00 |  |  | False |  |  | False |  |  | False
 |  |  |  |  |  |  | 2020-07-10 00:00:00 |  |  | False |  |  | False |  |  | False
 |  |  |  |  |  |  | 2020-07-13 00:00:00 |  |  | False |  |  | True |  |  | False
 |  |  |  |  |  |  | 2020-07-14 00:00:00 |  |  | False |  |  | False |  |  | False
 |  |  |  |  |  |  | 2020-07-15 00:00:00 |  |  | True |  |  | True |  |  | True
 |  |  |  |  |  |  | 2020-07-16 00:00:00 |  |  | False |  |  | False |  |  | False
 |  |  |  |  |  |  | 2020-07-17 00:00:00 |  |  | False |  |  | False |  |  | False
 |  |  |  |  |  |  | 2020-07-20 00:00:00 |  |  | True |  |  | True |  |  | True
 |  |  |  |  |  |  | 2020-07-21 00:00:00 |  |  | False |  |  | False |  |  | False
 |  |  |  |  |  |  | 2020-07-22 00:00:00 |  |  | False |  |  | False |  |  | False
Spreadsheet: 273182d1382631296-multiple-rows-to-multiple-columns-transpose-example
Sheet: Example

Table Example |  |  | Report Example
AcctNum | Comments |  | AcctNum | Comments1 | Comments2 | Comments3 | Comments4 | Comments5 | Comments6 | Comments7
1 | good standing |  | 1 | good standing | reviewed on date | over draft
1 | reviewed on date |  | 2 | late fee on date | current
1 | over draft |  | 3 | good standing | over draft | late fee on date | current | good standing | closed
2 | late fee on date
2 | current
3 | good standing
3 | over draft
3 | late fee on date
3 | current
3 | good standing
3 | closed
Spreadsheet: 788310d1658398896-max-value-in-a-row-max-value
Sheet: Blad1

ARTICLENR | NR of purchases |  |  | Article nr | Highest nr of purchases
1 | 3 |  |  | 4 | 56
2 | 5 |  |  | 8 | 27
3 | 2 |  |  | 5 | 23
4 | 56
5 | 23 |  |  | THIS IS THE RESULT i want to GET
6 | 12
7 | 17
8 | 27
9 | 3
10 | 6
Spreadsheet: 762006d1641345934-count-the-status-base-on-the-user-and-unique-value-for-asking
Sheet: Sheet1

 |  |  |  | Result
 |  | User001 | for "x" | 1
 |  |  | for "o" | 1
USERS | UNIQUE VALUE | GENERATED VALUE | SAMPLE OF GENERATED VALUE | STATUS
User001 | 1 |  |  | x
User001 | 1 |  |  | x
User001 | 2 |  |  | o
User001 | 3 |  |  | o
User002 | 1
User002 | 1
User002 | 2
User002 | 2
User002 | 3
User003 | 1
User003 | 1
User003 | 2
User003 | 2
User003 | 3
User003 | 4
User003 | 4
User001 | 1 |  |  | x
User001 | 1 |  |  | x
User001 | 2 |  |  | o
User001 | 3
User002 | 1
User002 | 1
User002 | 2
User002 | 2
User002 | 3
User003 | 1
User003 | 1
User003 | 2
User003 | 2
User003 | 3
User003 | 4
User003 | 4
Spreadsheet: 466547d1466269356-sum-data-for-specific-range-data
Sheet: Sheet1

DATE | SHIFT NO | APPLE | BANANA | CERRY | DRAGONFRUIT | NAME |  | [NAME] |  |  |  | BRUCE
2016-06-01 00:00:00 | 1 | 0 | 15 | 0 | 0 | [NAME] |  | APPLE | BANANA | CERRY | DRAGONFRUIT | APPLE | BANANA | CERRY | DRAGONFRUIT
 | 2 | 90 | 0 | 0 | 0 | BRUCE | WEEK 1
 | 3 | 100 | 0 | 0 | 0 | CLAY | WEEK 2
2016-06-02 00:00:00 | 1 | 0 | 0 | 5 | 7 | [NAME]
 | 2 | 1 | 2 | 0 | 0 | BRUCE
 | 3 | 0 | 0 | 0 | 0 | CLAY
2016-06-03 00:00:00 | 1 | 100 | 0 | 0 | 0 | [NAME]
 | 2 | 0 | 50 | 0 | 0 | [NAME]
 | 3 | 20 | 0 | 0 | 0 | BRUCE
2016-06-04 00:00:00 | 1 | 0 | 0 | 10 | 10 | [NAME]
 | 2 | 20 | 0 | 0 | 0 | [NAME]
 | 3 | 70 | 0 | 0 | 0 | BRUCE
2016-06-05 00:00:00 | 1 | 0 | 0 | 0 | 0 | CLAY
 | 2 | 50 | 50 | 0 | 0 | [NAME]
 | 3 | 100 | 25 | 0 | 0 | [NAME]
2016-06-06 00:00:00 | 1 | 100 | 0 | 0 | 0 | CLAY
 | 2 | 0 | 0 | 0 | 0 | [NAME]
 | 3 | 0 | 50 | 20 | 0 | [NAME]
2016-06-07 00:00:00 | 1 | 0 | 0 | 0 | 0 | BRUCE
 | 2 | 0 | 0 | 0 | 0 | [NAME]
 | 3 | 100 | 0 | 0 | 0 | [NAME]
2016-06-08 00:00:00 | 1 | 50 | 50 | 0 | 0 | BRUCE
 | 2 | 20 | 20 | 0 | 0 | [NAME]
 | 3 | 21 | 0 | 20 | 20 | [NAME]
2016-06-09 00:00:00 | 1 | 22 | 0 | 20 | 20 | [NAME]
 | 2 | 23 | 0 | 20 | 20 | BRUCE
 | 3 | 24 | 0 | 20 | 20 | CLAY
2016-06-10 00:00:00 | 1 | 25 | 0 | 20 | 20 | [NAME]
 | 2 | 0 | 0 | 20 | 20 | BRUCE
 | 3 | 0 | 0 | 20 | 20 | CLAY
2016-06-11 00:00:00 | 1 | 0 | 0 | 20 | 20 | BRUCE
 | 2 | 0 | 0 | 20 | 20 | CLAY
 | 3 | 0 | 0 | 20 | 20 | [NAME]
2016-06-12 00:00:00 | 1 | 0 | 0 | 20 | 20 | BRUCE
 | 2 | 0 | 0 | 20 | 20 | CLAY
 | 3 | 0 | 0 | 20 | 20 | [NAME]
2016-06-13 00:00:00 | 1 | 0 | 0 | 20 | 20 | BRUCE
 | 2 | 0 | 0 | 20 | 20 | CLAY
 | 3 | 0 | 0 | 20 | 20 | [NAME]
2016-06-14 00:00:00 | 1 | 30 | 0 | 20 | 20 | [NAME]
 | 2 | 0 | 0 | 20 | 20 | BRUCE
 | 3 | 0 | 0 | 20 | 20 | CLAY
Spreadsheet: 14c74b6e-fff7-47e3-bac4-46d1da705cd1
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2
 | استمـارة شعبـة الإحصاءات في الأمم المتحدة/برنامج الأمم المتحدة للبيئة عن الإحصاءات البيئية لعام 2006
 | الفرع: المياه
 | قائمة المحتويات
 | إرشادات | مقدمة، الخطوات التى تتبع، وصف الجداول [NAME]
 | التعاريف | قائمة التعاريف
 | الجدول م1 | موارد المياه العذبة المتجددة
 | الجدول م2 | موازنة استخدام المياه
 | الجدول م3 | استخلاص المياه العذبة
 | الجدول م4 | صناعة إمدادات المياه ([NAME] الدولي الموحد - 41)
 | الجدول م5 | [NAME] المياه
 | الجدول م6 | مرافق معالجة المياه المستعملة
 | الجدول م7 | الجماعات [NAME] المياه المستعملة
 | الجدول م8 | صحيفة المعلومات التكميلية
Spreadsheet: 525710d1498845176-counting-dates-that-meeta-condition-countif-dates
Sheet: Sheet1

Task | Date
1 | 2016-04-01 00:00:00
2 | 2017-01-15 00:00:00
3 | 2016-01-15 00:00:00
4 | 2016-09-23 00:00:00
5 | 2016-04-28 00:00:00
6 | 2016-02-23 00:00:00
7 | 2017-06-15 00:00:00
8 | 2016-08-10 00:00:00
9 | 2016-09-15 00:00:00
10 | 2016-04-15 00:00:00
11 | 2016-10-23 00:00:00
12 | 2016-03-15 00:00:00
13 | 2017-01-01 00:00:00
14 | 2016-03-31 00:00:00
15 | 2016-07-24 00:00:00
16 | 2016-09-15 00:00:00
17 | 2016-02-01 00:00:00
18 | 2016-06-21 00:00:00
19 | 2016-06-16 00:00:00
20 | 2016-10-01 00:00:00
21 | 2017-01-23 00:00:00
22 | 2017-05-29 00:00:00
23 | 2016-06-23 00:00:00
24 | 2016-04-19 00:00:00
25 | 2016-07-23 00:00:00
26 | 2016-04-19 00:00:00
27 | 2016-10-09 00:00:00
28 | 2016-11-15 00:00:00
29 | 2016-06-30 00:00:00
 | Total
Spreadsheet: 736092d1623344467-calculate-number-of-weeks-on-each-pay-period-with-rotation-employee-rotation-schedule-test
Sheet: DaysOff

Days Off: Vacation, Sick Leave, Personal Leave
Date | Employee | Type | Lookup Value |  | V = Vacation
2021-01-15 00:00:00 | Employee 1 | V |  |  | S = Sick Leave
2021-01-16 00:00:00 | Employee 2 | V |  |  | P = Personal Leave
2021-01-17 00:00:00 | Employee 3 | S
2021-02-14 00:00:00 | Employee 3 | P
2021-01-08 00:00:00 | Employee 4 | V
 |  |  |  | ◄ Insert more rows ABOVE this one
Spreadsheet: 122473d1316831225-sumifs-returns-0-when-i-dont-want-it-to-sumifs_example
Sheet: Data2

LOTID | Sum
A77
[NAME]
A20
A2
A7
A1
A77
A59
[NAME]
A73
A15
A63
A64
A27
A49
[NAME]
A46
A25
A32
A41
A38
A69
A70
A67
A31
A53
A40
A80
A76
A52
A58
A72
A18
[NAME]
A19