tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 108959d1305885592-vlookup-multiple-queries-visit
Sheet: Visits

Client ID | Dates Visited | Place Visited
1 | 2010-12-12 00:00:00 | Cardiff
2 | 2010-12-13 00:00:00 | Swansea
3 | 2010-12-14 00:00:00 | London
4 | 2010-12-15 00:00:00 | Cardiff
5 | 2010-12-16 00:00:00 | Cardiff
1 | 2010-12-17 00:00:00 | London
1 | 2010-12-18 00:00:00 | Swansea
2 | 2010-12-19 00:00:00 | Cardiff
5 | 2010-12-20 00:00:00 | Liverpool
Spreadsheet: 823189d1679794073-make-a-cell-with-many-lines-into-order-example1
Sheet: Date

Date Operations
[NAME] for working with dates Note: All dates are formatted using TEXT() to avoid formatting issues that can occur due to differences in formatting preferences
Date (input)
Preferred Format | [NAME]
Days | 7
Date plus a number of days
Date plus a number of working days
[NAME] (YYYYMMDD)
Today
Last week's dates (Monday, Friday, Sunday)
Last month's dates (First and Last)
First / Last business day this month
Converts text to a date, in a locale-independent way
Inputs
Text | 2008年12月31日 (水)
Separator | 年 | 月 | 日
Format | YMD
Calculated Values
1st token
2nd token
3rd token
Extracted Year
Extracted Month
Extracted Day
Output
Output Date Format
Reformatted Date
Spreadsheet: 812806d1673384247-drop-down-list-production-scorecard-test
Sheet: 1.4.23

MAIL PREP | 1.4.23 |  |  |  |  |  | Total Count |  |  |  |  |  |  |  |  |  |  | ERRORS:
 | C | RL | B | S | P |  |  | Pieces | % of [NAME] | Rep 1 | Rep 2 | Rep 3 | Rep 4 | Rep 5 | Rep 6 | Rep 7 |  | Processor | Error Description
Rep 1 |  | 7 |  |  |  |  | Client 1 |  |  |  |  |  |  |  |  |  |  | Rep 2 | Missing barcode
Rep 2 |  | 37 |  |  |  |  | Client 2
Rep 3 | 16 |  |  |  |  |  | Client 3
Rep 4 | 41 |  |  |  |  |  | Client 4
Rep 5 |  |  |  |  |  |  | Client 5
Rep 6 | 8 |  | 25
Rep 7 | 87 |  |  | 12
 | Daily Production Rating |  |  | Ranking
Rep 1
Rep 2
Rep 3
Rep 4
Rep 5
Rep 6
Rep 7
LETTER PRINT |  |  |  |  |  |  | Total Count
 | C | RL | B | S | P |  |  | Pieces | % of [NAME] | Rep 1 | Rep 2 | Rep 3 | Rep 4 | Rep 5 | Rep 6 | Rep 7
Rep 1 |  |  |  | 6 |  |  | Client 1
Rep 2 |  | 14 |  |  |  |  | Client 2
Rep 3 |  | 1 |  |  |  |  | Client 3
Rep 4 | 24 | 5 |  |  |  |  | Client 4
Rep 5 | 27 |  |  |  |  |  | Client 5
Rep 6 |  |  | 6
Rep 7 | 48
 | Daily Production Rating |  |  | Ranking
Rep 1
Rep 2
Rep 3
Rep 4
Rep 5
Rep 6
Rep 7
INTERNAL QC2 |  |  |  |  |  |  | Total Count
 | C | RL | B | S | P |  |  | Pieces | % of [NAME] | Rep 1 | Rep 2 | Rep 3 | Rep 4 | Rep 5 | Rep 6 | Rep 7
Rep 1 | 47 | 5 | 6 |  |  |  | Client 1
Rep 2 |  |  |  |  |  |  | Client 2
Rep 3 | 38 |  |  | 5 |  |  | Client 3
Rep 4 | 1 |  |  |  |  |  | Client 4
Rep 5 |  |  |  |  |  |  | Client 5
Rep 6 | 13 | 15 |  | 1
Rep 7
 | Daily Production Rating |  |  | Ranking
Rep 1
Rep 2
Rep 3
Rep 4
Rep 5
Rep 6
Rep 7
Spreadsheet: 86312d1286324022-summing-up-same-words-sumifdog
Sheet: Sheet1

Name | Value
car | 3
car | 4
cat | 1
dog | 1
car | 6
dog | 3 |  |  | Row Labels | Sum of Value
 |  |  |  | car | 13
 |  |  |  | cat | 1
Car | 13 |  |  | dog | 4
cat | 1 |  |  | Grand Total | 18
dog | 4
Spreadsheet: jay_reitmeyer__13532__ENRON2001
Sheet: 9-01 #7010

 | MPC September 2001 Gas Transportation Invoice
Enron Gas Marketing, Inc
1200 17th Street - Suite 2750
Denver, CO  80202
Attention: [NAME]
Customer ID # 7010
Account # | 100737-6
Interruptible Transportation Charges
 |  | Quantity | Rate | Charge
Commodity Charge |  | 103111 | 0.2
Interruptible Storage Charges
Commodity Charges |  | Quantity | Rate | Charge
Injection Charge |  | 103111 | 0.023
Withdrawal Charge |  | 0 | 0.023
Capacity Charge |  | 862899 | 0.022
Canadian Montana Pipeline Charge
 |  | Quantity | Rate | Charge
 |  | 0 | 0.008
Total Transportation Invoice
Entered:______________ |  |  | Approved:_______________
Spreadsheet: 850080d1700478900-lookup-two-critera-from-two-columns-match-find-lowest-value-in-third-column-return-4th-book1
Sheet: Sheet1

City | Number | Value | Shipper |  |  |  | Location | Number | Shipper
Calgary | 1 | 3.25 | Yes |  |  |  | London | 1
Toronto | 1 | 4 | Post
Boston | 3 | 3.25 | Yes
Shanghai | 4 | 0.05555555555555555 | Star
Oslo | 5 | 4.53 | Fedex
London | 5 | 1 | Post
Tokyo | 1 | 2 | Fedex
Calgary | 15 | 3 | Star
Toronto | 1 | 1 | Yes
Chicago | 3 | 3 | Yes
London | 1 | 7 | Star
London | 1 | 0.5 | Fedex
New York | 1 | 0.2 | Post
Spreadsheet: 791806d1660601511-return-blank-date-if-there-is-no-data-in-the-input-cell-new-insurance-tracker
Sheet: 2022-2023 Plan Rates

 | Kaiser Dental Plan Rates |  |  |  | Providence Health Plan Rates |  |  |  | HSA Savings Plans
 | PPO Plan (Basic Plan) |  |  |  | Choice Plan (Basic Plan) |  |  |  | HSA Savings Contributions
 | CODE | EE Cost/mo. | ER Cost/mo. |  | CODE | EE Cost/mo. | ER Cost/mo. |  | CODE | EE Cost/mo. | ER Cost/mo.
 | Waived EE | 0 | 0 |  | Waived EE | 0 | 0 |  | Waived EE | Enter value | 0
 | PPO EE | 0 | 33.17 |  | Choice EE | 0 | 380.15 |  | HSA EE | Enter value | 53.05
 | PPO ES | 33.63 | 33.17 |  | Choice ES | 380.17 | 380.15 |  | HSA ES | Enter value | 53.05
 | PPO EF | 85.25 | 33.17 |  | Choice EF | 684.34 | 380.15 |  | HSA EF | Enter value | 53.05
 | PPO EC | 43.38 | 33.17 |  | Choice EC | 304.16 | 380.15 |  | HSA EC | Enter value | 53.05
 | HMO Plan (Buy-Up Plan) |  |  |  | Option Advantage A Plan (Buy-Up Plan) |  |  |  | MetLife Plan
 | CODE | EE Cost/mo. | ER Cost/mo. |  | CODE | EE Cost/mo. | ER Cost/mo. |  | CODE | EE Cost/mo. | ER Cost/mo.
 | HMO EE | 5.29 | 33.17 |  | Option A EE | 107.94 | 380.15 |  | Basic EE | 0 | 2.53
 | HMO ES | 44.27 | 33.17 |  | Option A ES | 596.05 | 380.15 |  | Basic Plus | Enter Value | 2.53
 | HMO EF | 104.12 | 33.17 |  | Option A EF | 986.58 | 380.15
 | HMO EC | 55.6 | 33.17 |  | Option A EC | 498.45 | 380.15
 |  |  |  |  | HSA Plan** (High Deductible Plan)
 |  |  |  |  | CODE | EE Cost/mo. | ER Cost/mo.
 |  |  |  |  | HSA EE | 0 | 327.1
 |  |  |  |  | HSA ES | 324.42 | 327.1
 |  |  |  |  | HSA EF | 583.98 | 327.1
 |  |  |  |  | HSA EC | 259.55 | 327.1
Spreadsheet: 160077d1338962742-problem-in-making-pivot-table-aaaa
Sheet: Intranet applications URLS

Intranet - Application Name | deepinder.a.singh (Add ACG ID) | [NAME] (Add ACG ID) | amit.arvind.chorgi (Add ACG ID) | shubha.singh  (Add ACG ID) | nidhi.mittal  (Add ACG ID) | deepali.shinde  (Add ACG ID) | amrita.dubey  (Add ACG ID) | vivel.b.kumar.singh  (Add ACG ID) | Krishnaprasad.sk  (Add ACG ID) | [NAME]  (Add ACG ID) | anshuman.a.mishra  (Add ACG ID) | bhartendu.gupta  (Add ACG ID) | paramjit.h.singh  (Add ACG ID) | devendra.rajput  (Add ACG ID) | Yes | No
[NAME] for RIB, RSL | NO | NO |  | NO | NO
RIB-RMS ADMIN GUI | NO | NO |  | NO | NO
RIB-SIM ADMIN GUI | NO | NO |  | NO | NO
RIB-RPM ADMIN GUI | NO | NO |  | NO | NO
RIB-TAFR ADMIN GUI | NO | NO |  | NO | NO
RIB Payload XSD | NO | NO |  | NO | NO
[NAME] for RMS, ReIM, RPM, Alloc, SIM | NO | NO |  | NO | NO
RMS | NO | NO |  | NO | NO
ReIM | NO | NO |  | NO | NO
RPM | NO | NO |  | NO | NO
Alloc | NO | NO |  | NO | NO
SIM | NO | NO |  | NO | NO
RM24 | NO | NO |  | NO | NO
[NAME] for RM 2.4 | NO | NO |  | NO | NO
CO 13.4 | NO | NO |  | NO | NO
[NAME] for CO 13.4 | NO | NO |  | NO | NO
BI Publisher | NO | NO |  | NO | NO
[NAME] | NO | NO |  | NO | NO
Back Office 13.4 | NO | NO |  | NO | NO
VELTI | NO | NO |  | NO | NO
Solve Centurion Webservices: Primary | NO | NO |  | NO | NO
Solve Centurion Webservices: Secondary | NO | NO |  | NO | NO
Solve Centurion - Chip and Pin Transactions:- Primary | NO | NO |  | NO | NO
Solve Centurion - Chip and Pin Transactions:- Secondary | NO | NO |  | NO | NO
Solve Portal: Primary | NO | NO |  | NO | NO
Solve Portal: Secondary | NO | NO |  | NO | NO
Solve Centurion | NO | NO |  | NO | NO
SVAP- VAP11 | YES | YES |  | YES | YES
SVAP- VAP5 | YES | YES |  | YES | YES
SVAP- VAP12 | NO | NO |  | NO | NO
SVAP- VAP7 | YES | YES |  | YES | YES
SVAP- VAP3 | YES | YES |  | YES | YES
E Business | YES | YES |  | YES | YES
E Shop-T1 | NO | NO |  | YES | NO
EShop-T2 | YES | YES |  | YES | YES
ESHOP-T3 | YES | YES |  | YES | YES
EShop-T4 | YES | YES |  | YES | YES
EShop-PAT | YES | YES |  | YES | YES
Spreadsheet: 100643d1298948952-helicopter-graph-helicopter-power
Sheet: Data

% |  |  | 100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 395 | 375
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 395 | 375
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 395 | 375
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 395 | 375
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 395 | 375
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 395 | 375
 |  |  |  |  |  |  |  |  |  |  |  | 395 | 375
 |  |  |  |  |  |  |  |  |  | 395 | 375
 |  |  |  |  |  |  |  | 395 | 375
 |  |  |  |  |  | 395 | 375
 |  |  |  | 395 | 375
 |  | 395 | 375
 |  |  |  |  |  |  |  |  |  |  | 29 |  | 25.7 |  | 22.9 |  | 20 |  | 16.7 |  | 13.4 |  | 10.7 |  | 7.4 |  | Number of tick marks past 45 from the right
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12000 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12000 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12000 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12000 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12000 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12000 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 12000 | 0
 |  |  |  |  |  |  |  |  |  |  | 12000 | 0
 |  |  |  |  |  |  |  |  | 12000 | 0
 |  |  |  |  |  |  | 12000 | 0
 |  |  |  |  | 12000 | 0
 |  |  | 12000 | 0
 | 12000 | 0
X
Y
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X displacement | Y displacement | X scale | Y scale
C | 45 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 130
610 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 125 | 120 | 0.1 | 0.0002
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30 | 0 | 0 | 1e-05 | d1
Spreadsheet: tracy_geaccone__40260__C0366-112458
Sheet: Dept_100150

ENRON PROPERTY & SERVICES CORP
1400 Smith Street
Houston, Texas   77251 - 1188
MONTHLY INVOICE DETAIL
TRAVEL - Dept. 100150
June, 2001
0366  EOC - Executive
Date | Ticket Number | Work Order | Service Name | Service Description | # [NAME] | Unit Cost | UOM | Service | Ticket
 |  |  |  |  |  |  |  | Total | Total
 |  |  | R/C 112458
2001-05-04 00:00:00 | TVL5125429 |  | [PHONE] GADD/ERIC D | Int'l Air Travel | 1 | 200 | /MNTH | 200
 |  |  |  |  |  |  | Ticket Total |  | 200
2001-05-18 00:00:00 | TVL5127643 |  | [PHONE] GADD/ERIC D | Domestic Air Travel | 1 | 56.3 | /MNTH | 56.3
 |  |  |  |  |  |  | Ticket Total |  | 56.3
2001-05-23 00:00:00 | [NAME] |  | [PHONE] GADD/ERIC D | Air Commission | 1 | -50 | /MNTH | -50
 |  |  |  | Int'l Air Travel | 1 | 200 | /MNTH | 200
 |  |  |  |  |  |  | Ticket Total |  | 150
2001-05-24 00:00:00 | TVL5128394 |  | [PHONE] GADD/ERIC D | Air Commission | 1 | -37.9 | /MNTH | -37.9
 |  |  |  | Int'l Air Travel | 1 | 200 | /MNTH | 200
 |  |  |  |  |  |  | Ticket Total |  | 162.1
2001-05-24 00:00:00 | TVL5128395 |  | [PHONE] GADD/ERIC D | Domestic Air Travel | 1 | 56.3 | /MNTH | 56.3
 |  |  |  |  |  |  | Ticket Total |  | 56.3
 |  |  |  |  |  |  | Total for R/C: 112458 |  | 624.7
 |  |  |  |  |  |  | Total for Dept_100150 |  | 624.7
Spreadsheet: andy_zipper__167__DYNEGY-ICE VOL Apr11
Sheet: ICE-ECC

Enron Canada Corporation
Activity on ICE
UOM | Deals | Volume
 |  |  |  |  |  |  | START | END
Enron Canada Corp.
Commodity Type:  All
Instruments:  All
Trade Dates:  Apr-11-01 thru Apr-11-01
Trade Date | Deal ID | Leg ID | B/S | Product | Hub | Strip | START | END | Option | Strike | Style | Counterparty | Price | Price Units | Qty Per Period | Periods | Total Quantity | Qty Units | Trader
Spreadsheet: 757753d1638447054-im-looking-for-help-on-how-link-a-master-sheet-to-populate-another-sheets-in-the-workbook-team-roster
Sheet: FGB

Washington Nationals
Team Owner
Team Salary
[NAME]
Available Salary
Roster
Minor League Players
Name | Salary | Years | Tm | Lg | W | L | W-L% | ERA | G | GS | GF | CG | SHO | SV | IP | H | R | ER | HR | BB | IBB | SO | HBP | BK | WP | BF | ERA+ | FIP | WHIP | BB9 | HR9 | H9 | SO9 | SO/W
Starling Marte
Spreadsheet: richard_sanders__32083__attachments
Sheet: Attachment B

Summary of All Schedules Submitted on May 24, 1999 for Deliveries on May 25, 1999
Notes:
 | Purchases |  |  | Sales |  |  |  |  |  | Prices
 | Tijuana | NP15 | SP15 | 4 Corners | Malin | Palo Verde | Silver Peak | Total |  | Tijuana | NP15 | SP15 | 4 Corners | Malin | Palo Verde | Silver Peak
0100 |  | 184 | 117 | -53.03 | -50 | -170 | 0 |  |  | 21.38 | 21.38 | 21.38 | 14.85 | 21.38 | 21.38 | 21.38
0200 |  | 179 | 112 | -50 | 0 | -190 | 0 |  |  | 19.07 | 19.07 | 19.07 | 11.99 | 19.07 | 17 | 19.07
0300 |  | 176 | 110 | -50 | 0 | -144.02 | 0 |  |  | 18.41 | 18.41 | 18.41 | 11.99 | 18.41 | 14.85 | 18.41
0400 |  | 174 | 109 | -50 | 0 | -110 | 0 |  |  | 14.36 | 14.36 | 14.36 | 11.99 | 14.36 | 14.36 | 14.36
0500 |  | 170 | 115 | -68.03 | -32.3 | -180 | 0 |  |  | 20.45 | 20.45 | 20.45 | 14.85 | 20.45 | 15 | 20.45
0600 |  | 178 | 132 | -50 | -50 | -150 | 0 |  |  | 24.4967 | 24.4967 | 24.4967 | 24.4967 | 24.4967 | 24.4967 | 24.4967
0700 |  |  | 172 | -50 | 0 | -140 | -3.03 |  |  | 38 | 38 | 38 | 38 | 38 | 38 | 19.94
0800 |  |  | 375 | 0 | 0 | -120 | -3.03 |  |  | 38.99 | 38.99 | 38.99 | 38.99 | 38.99 | 38.99 | 25.89
0900 | 50 |  | 344 | 0 | 0 | -20 | -3.03 |  |  | 51.92 | 51.92 | 51.92 | 51.92 | 51.92 | 51.92 | 26.91
1000 | 70 |  | 361 | 0 | 0 | 0 | -3.03 |  |  | 37.6 | 37.6 | 37.6 | 37.6 | 37.6 | 37.6 | 27.59
1100 | 120 |  | 371 | 0 | 0 | 0 | -3.03 |  |  | 48.38 | 48.38 | 48.38 | 48.38 | 48.38 | 48.38 | 28.38
1200 | 120 | 23 | 409 | 0 | 0 | 0 | -3.03 |  |  | 48.18 | 48.18 | 48.18 | 48.18 | 48.18 | 48.18 | 28.18
1300 | 100 | 23 | 408 | 0 | 0 | 0 | -3.03 |  |  | 48 | 48 | 48 | 48 | 48 | 48 | 27.99
1400 | 110 | 45 | 429 | 0 | 0 | 0 | -3.03 |  |  | 48.77 | 48.77 | 48.77 | 48.77 | 48.77 | 48.77 | 28.76
1500 | 140 | 43 | 426 | 0 | 0 | 0 | -3.03 |  |  | 48.98 | 48.98 | 48.98 | 48.98 | 48.98 | 48.98 | 28.97
1600 | 140 | 38 | 420 | 0 | 0 | 0 | -3.03 |  |  | 49.99 | 49.99 | 49.99 | 49.99 | 49.99 | 49.99 | 28.1
1700 | 120 | 34 | 417 | 0 | 0 | 0 | -3.03 |  |  | 49.99 | 49.99 | 49.99 | 49.99 | 49.99 | 49.99 | 28.19
1800 | 90 | 25 | 409 | 0 | 0 | 0 | -3.03 |  |  | 47.06 | 47.06 | 47.06 | 47.06 | 47.06 | 47.06 | 27.05
1900 | 70 | 15 | 400 | 0 | 0 | 0 | -3.03 |  |  | 38.99 | 38.99 | 38.99 | 38.99 | 38.99 | 38.99 | 26.57
2000 | 60 | 20 | 401 | 0 | 0 | 0 | -3.03 |  |  | 35.69 | 35.69 | 35.69 | 35.69 | 35.69 | 35.69 | 25.68
2100 | 150 | 27 | 394 | 0 | 0 | 0 | -3.03 |  |  | 39.5 | 39.5 | 39.5 | 39.5 | 39.5 | 39.5 | 29.28
2200 | 120 | 21 | 381 | 0 | 0 | -80 | -3.03 |  |  | 38.99 | 38.99 | 38.99 | 38.99 | 38.99 | 38.99 | 26.48
2300 | 80 | 208 | 147 | -10 | -25 | -130 | 0 |  |  | 25.99 | 25.99 | 25.99 | 23.99 | 25.99 | 23 | 25.99
2400 | 20 | 196 | 129 | -50 | -25 | -180 | 0 |  |  | 24.5 | 24.5 | 24.5 | 19.78 | 24.5 | 22 | 24.5
 |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 594731d1539933664-find-closest-time-match-with-multi-criteria-return-another-value-exampleforforum
Sheet: Sheet1

evntuser | zone | evnttsD | evnttsT
CL0199 | 3 | 2018-09-07 00:00:00 | 23:20:01
CL0192 | 3 | 2018-09-07 00:00:00 | 00:00:01
CL0192 | UNK | 2018-09-07 00:00:00 | 00:00:04
CL2768 | 8 | 2018-09-08 00:00:00 | 15:09:24
The user ID has a match
The dates also match
The UNK fell at 12:00:04 AM, the closest known was Zone 3 at 12:00:01 AM
The highlighted cell would be where the formula is entered
Spreadsheet: 855642d1705148841-average-if-of-unique-values-with-conditions-question-7-
Sheet: Sheet1

Origin | Destination | Ticket | Fare | OD_Ticket |  | Unique OD_tickets | Fare (average of unique fares if duplicate)
Pontefract | Woodlesford | ADVANCE | 5.1 |  |  |  | 5.1
Leeds | Bradford | ADVANCE | 3.5 |  |  | [NAME] | 5
Leeds | Bradford | ADVANCE | 5.5 |  |  | Leeds - Bradford_SINGLE | 7.5
Leeds | Bradford | ADVANCE | 5.5 |  |  | Castleford - Pontefract_ADVANCE | 3.5
Leeds | Bradford | ADVANCE | 6
Leeds | Bradford | SINGLE | 7.5
[NAME] | Pontefract | ADVANCE | 3
[NAME] | Pontefract | ADVANCE | 4
Spreadsheet: 119088d1314193766-insert-value-to-a-different-cell-based-on-condition-copy-of-insert-into-cell-example
Sheet: Sheet1

 |  |  | Name | Chosen | Not Chosen | Chosen1 | Chosen2 |  |  |  |  |  |  | Yes
 |  |  | [NAME] | Yes |  | 1 | 0
Sum of Chosen1 |  |  | Sum of Chosen2
Name | Total |  | Name | Total
[NAME] | 1 |  | [NAME] | 0
Spreadsheet: 672720d1586970693-filter-with-multiple-or-criteria-help
Sheet: Team A

Team A
Brand | Inititative | Priority | Status | Launch Timing | Exp. Team / Business Team
 | Test 123 | 1 | In Progress | Q2 | Ops Marketing  International   Domestic Team A   Team B Team C
CD | Test 456 | 2 | In Progress | Q2 | Ops Marketing  International   Domestic Team A   Team D Team E
EF | Test 4785 | 3 | In Progress | Q2 | Team A
AB | Test 5118 | 3 | In Progress | Q3/Q4 | Team A
All Teams
Brand | Inititative | Priority | Status | Launch Timing | Exp. Team / Business Team
 | Test 2121 | 1 | Next on Deck | Q3 | All Teams
AB | Test 4119 | 1 | Requires Discovery | TBD | All Teams
EF | Test 6783 | 3 | On Hold | Q2 | All Teams
Spreadsheet: 56344d1256543559-timesheet-overtime-formula-help-copy-of-time-sheets
Sheet: NEW TIMESHEET

 |  |  |  | TIME SHEET
[NAME]:
 |  |  |  | DATE: | 2009-10-19 00:00:00
JOB NO | PROJECT | [NAME] OF WORK |  | START/FINISH | MON | TUES | WED | THUR | FRI | SAT | SUN
 |  |  |  |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  |  |  |  |  | Totals
 |  |  | ORD TOTALS
 |  |  | NORMAL PAY TOTALS
 |  |  | TIME & A HALF TOTALS
 |  |  | DOUBLE TIME TOTALS
Spreadsheet: 159682d1338815652-excel-2007-i-need-a-formula-which-when-dates-match-transfer-the-data-from-the-entire-row-dates-and-data
Sheet: Monthly Data

 | Changes automatically every month
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Holidays11
 | 1 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  | 2012-01-06 00:00:00 | Fixed Date | 2
 | 2 |  | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 |  |  |  | 2012-02-27 00:00:00 | Non Fixed Date | 3
 | 3 |  | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 |  |  |  | 2012-03-25 00:00:00 | Fixed Date | 4
 | 4 |  | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 |  |  |  | 2012-04-13 00:00:00 | Non Fixed Date | 5
 | 5 |  | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 |  |  |  | 2012-04-16 00:00:00 | Non Fixed Date | 6
 | 6 |  | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 |  |  |  | 2012-05-01 00:00:00 | Fixed Date | 7
 | 7 |  | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 |  |  |  | 2012-06-04 00:00:00 | Non Fixed Date | 8
 | 8 |  | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 |  |  |  | 2012-08-15 00:00:00 | Fixed Date | 9
 | 9 |  | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 |  |  |  | 2012-10-28 00:00:00 | Fixed Date | 10
 | 10 |  | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 |  |  |  | 2012-12-24 00:00:00 | Fixed Date | 11
 | 11 |  | 11 | 11 | 11 | 11 | 11 | 11 | 11 | 11 | 11 | 11 | 11 |  |  |  | 2012-12-25 00:00:00 | Fixed Date | 12
 | 12 |  | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 |  |  |  | 2012-12-26 00:00:00 | Fixed Date | 13
 | 13 |  | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13
 | 14 |  | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14
 | 15 |  | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15
 | 16 |  | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16
 | 17 |  | 17 | 17 | 17 | 17 | 17 | 17 | 17 | 17 | 17 | 17 | 17
 | 18 |  | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 18
 | 19 |  | 19 | 19 | 19 | 19 | 19 | 19 | 19 | 19 | 19 | 19 | 19
 | 20 |  | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20
 | 21 |  | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20
 | 22
 | 23
 | 24
Spreadsheet: 746109d1630509778-adding-up-data-in-different-sheets-sample
Sheet: results

 | DROP DOWN MENU
 | Ealing
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 01/01/20222
 | . |  | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | YTD
 | ACTON | Total Number of claimants
 |  | 25+ Claimants
 |  | Ratio: Total Number of claimants to 25+ Claimants
 | EALING | Total Number of claimants
 |  | 25+ Claimants
 |  | Ratio: Total Number of claimants to 25+ Claimants
Spreadsheet: 842148d1694197099-one-name-range-to-apply-for-all-sheets-1982-worksheet-level-named-ranges-includes-values-
Sheet: Sheet3

 |  |  |  | 1 | 1 | 1 | 1 | 1
 |  |  |  | 1 | 1 | 1 | 1 | 1
 |  |  |  | 1 | 1 | 1 | 1 | 1
 |  |  |  | 1 | 1 | 1 | 1 | 1
 |  |  |  | 1 | 1 | 1 | 1 | 1
 |  |  |  | 1 | 1 | 1 | 1 | 1
 |  |  |  | 1 | 1 | 1 | 1 | 1
 |  |  |  | 1 | 1 | 1 | 1 | 1
 |  |  |  | 1 | 1 | 1 | 1 | 1
 |  |  |  | 1 | 1 | 1 | 1 | 1
 |  |  |  | 1 | 1 | 1 | 1 | 1
 |  |  |  | 1 | 1 | 1 | 1 | 1
 |  |  |  | 1 | 1 | 1 | 1 | 1
 |  |  |  | 1 | 1 | 1 | 1 | 1
 |  |  |  | 1 | 1 | 1 | 1 | 1
 |  |  |  | 1 | 1 | 1 | 1 | 1
 |  |  |  | 1 | 1 | 1 | 1 | 1
 |  |  |  | 1 | 1 | 1 | 1 | 1
 |  |  |  | 1 | 1 | 1 | 1 | 1
 |  |  |  | 1 | 1 | 1 | 1 | 1
 |  |  |  | 1 | 1 | 1 | 1 | 1
Spreadsheet: 0594e86a-d714-40cf-916c-14876ffda431
Sheet: Sheet1

American Heart Association | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Basic Life Support (first-aid specific) Course Evaluation
Instructor Name(s):
Course Type (use for HS and/or Fam/Friends First Aid courses):
Course Date(s):                                                                                    Course Time(s):
Please rate to what extent you achieved each of the following objectives during this course:
Upon completion of this course the participant will be able to: | Excellent | Good | Fair | Poor | N/A for this curriculum | Comments:
Discuss injury/illness prevention techniques
Discuss the "basics of first aid"
Medical Emergencies:
Identify emergencies, discuss and demonstrate first aid techniques - stroke, heart attack, breathing difficulty, diabetes, allergic reactions, shock, seizure, [NAME], supplement [NAME], hemostatic agents
Injury Emergencies:
Identify emergencies, discuss and demonstrate first aid techniques - bleeding, wounds, head/spine, eye, broken bones, sprains, bruises, burns/electrocution, tourniquets
Environmental Emergencies:
Identify emergencies, discuss and demonstrate first aid techniques - bites/stings, poisoning, hot/cold, abuse
Rate the Instructor’s Overall Presentation: | Excellent | Good | Fair | Poor |  | Comments:
How would you rate the instructor’s knowledge of the material?
Is there any additional instructional information you would like to see added to the course?
Include any Additional Comments on the back of this page:
 |  | Thank you for your interest in improving our courses.