tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 678907d1590112314-counting-over-several-pages-and-if-conditions-arent-met-then-blank-iauditor-dashboard-for-example-sammyghr-
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: 115468d1311082453-using-vlookup-and-choose-functions-together-vlookup-and-choose
Sheet: Week 2

 | City | Mon | Tue | Wed | Thu | Fri
 | Cardiff | 0.3733378136473302 | 0.7289646686502034 | 0.2246734179481367 | 0.4407915025372109 | 0.9469737770596209
 | Dublin | 0.8732039147517625 | 0.5880930533463753 | 0.3679235073875722 | 0.4518029321359727 | 0.455171619583763
 | Edinburgh | 0.7668783072366523 | 0.9085180278288603 | 0.3680579565245727 | 0.9175396325177196 | 0.966368619553255
 | [NAME] | 0.8738863675027277 | 0.1587071132641791 | 0.981666569607297 | 0.5733398166754513 | 0.2386072714404516
 | London | 0.5331252498720582 | 0.5615845431473243 | 0.4230068483395935 | 0.401508164122629 | 0.6493422442891887
 | [NAME] | 0.4484516693432017 | 0.5514954815873478 | 0.5290031736566121 | 0.6493552261657323 | 0.6047691709832161
 | [NAME] | 0.895505044457749 | 0.1890524567808225 | 0.280213595912512 | 0.7625566527437035 | 0.7619948304299708
 | Swansea | 0.07596245598935347 | 0.4314086788978708 | 0.3676020854983095 | 0.5853941833912533 | 0.7231823711621415
Spreadsheet: 72393d1273072820-series-determination-lot
Sheet: Total

 | Start Lot | End Lot
 | 8991848000001554004 | 8991848000001599998
 | 8991848000001700000 | 8991848000001799999
 | 8991848000001800005 | 8991848000001874004
 | 8991848000001124004 | 8991848000001224003
 | 8991848000001224004 | 8991848000001389003
 | 8991848000001399004 | 8991848000001554003
 | 8991848000001903012 | 8991848000002203011
 | 8991848000002203017 | 8991848000002303016
 | 8991848000002303022 | 8991848000002603021
 | 8991848000002903024 | 8991848000003003023
 | 8991848000002753024 | 8991848000002803023
 | 8991848000002803024 | 8991848000002903023
Spreadsheet: 832586d1686455654-help-with-a-formula-in-a-timecard-timecard-sample-1-longbow-44-
Sheet: Sheet1

Day | Date | Holiday | Stat | Start | End | Total Hrs Wrkd | REG | TAH | DT
Sun
Mon
Tue
Wed
Thu
Fri | 2023-04-07 00:00:00 |  | Y | 07:00:00 | 21:00:00
Sat
Total
Spreadsheet: 883793d1732508623-returning-1-when-it-should-be-0-rows-unique-filter-function-sample-1
Sheet: Backend

Company | 3 |  |  | Company |  | Department |  | Training Topics |  | Month
Department | 1
Training Topics | 1
Month | 1
Total Participant per month |  |  |  |  |  |  |  |  | Problem:
 | February | April | June | July | August | September | October |  | if I choose the month [NAME], how to show Jan-June?
124 | 22 | 20 | 4 | 49 | 24 | 67 | 17 |  | also how to show the Mar: 0, May: 0, which not on rawdata?
Total topic by skill type
 | January |  | Problem:
[NAME] | 1 |  | if I choose Company Z, Dept ALL, Topics ALL, Month January --> Hardskill 1 which should be 0
Hard Skill | 1 |  | if I choose company Z, Dept ANS --> #[NAME]?
Spreadsheet: 58625d1258889314-vlookup-rubbish-instructions-book1-1-
Sheet: Sheet1

cat
dog | Cat |  | cat | 2
[NAME] |  | bob | dog | 3
 |  | [NAME] | [NAME] | 3 |  | cat | 2
 |  |  |  |  |  | dog | 3
 | dog |  |  |  |  | [NAME] | 3
 |  | bob
 |  | ian
 |  | brain
 | [NAME]
 |  | jason
 |  | [NAME]
 |  | jane
Cat | Dog | [NAME] |  |  | Pet | Total
2 | 3 | 3 |  |  | Cat | 2
bob | bob | jason |  |  | Dog | 3
[NAME] | ian | [NAME] |  |  | [NAME] | 3
 | [NAME] | jane
Spreadsheet: 101754d1299798121-calculate-based-on-multiple-criteria-bs-cap-analysis
Sheet: Analysis

DOB | Plan | Sex | Age | [NAME] |  | [NAME] Received
19530824 | HZU | F | 58 | 137.77
20101220 | [NAME] | F | 0 | 94.11
19761027 | H4V | F | 34 | 104.69
19701220 | HZY | F | 40 | 104.78
19510518 | H3Z | M | 60 | 146.47
20070326 | D85 | F | 4 | 24.61
19810709 | H3Z | F | 30 | 116.74
20040204 | D85 | F | 7 | 33.36
19990611 | DAR | F | 12 | 36.97
19530105 | RAH | M | 58 | 115.2
20020712 | H4U | F | 9 | 37.93
19690327 | H5F | F | 42 | 101.59
19500102 | PEA | F | 61 | 114.94
20090905 | HBM | F | 1 | 43.53
19690310 | H4F | M | 42 | 67.21
19980314 | HDB | M | 13 | 39.91
19530712 | HYF | F | 58 | 124.61
19560307 | PGB | F | 55 | 82.7
19740410 | H10 | F | 37 | 118.41
19550409 | PBP | F | 56 | 98.68
20010514 | H3Z | M | 10 | 42.87
19561020 | HDB | M | 54 | 106.01
19891231 | H3Z | F | 21 | 92.42
19960521 | H2E | F | 15 | 39.52
Spreadsheet: a715649c-14b3-4aa4-ac4e-b7a8ae8383ab
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
4383 | 25143 | [NAME] | Kiff | GBR | 136 | 00:36:26 | 00:00:00 | 01:33:04 | 00:00:00 | 00:49:14 | 1 | 02:58:43
Spreadsheet: 456720d1461008220-checking-two-sheets-for-missing-data-test2
Sheet: Sheet1

Last Name | First Name | Job Description/Duties | email address | Listed? Y/N
Abdehak | Hadi | X-Ray Tech/MA | [EMAIL]
Aceves | Carmen | Manager | [EMAIL]
Addison | [NAME] | [NAME] | [EMAIL]
Agredano | Nadine | Administration | [EMAIL]
Agredano | [NAME] | Credentialing Department | [EMAIL]
Aguilar | Amber | Front Office Receptionist | [EMAIL]
Aguilar | [NAME] | Front Office / Check Out | [EMAIL]
Aguilar | Yessenia | PI collector | [EMAIL]
Ahrens | Alicia | Physical Therapy Assistant | [EMAIL]
Spreadsheet: 846181d1697468351-multiply-value-from-the-drop-down-list-to-a-cell-quote-worksheet-draft-1-
Sheet: Data

 |  |  |  |  |  |  |  |  | Pices Installed per day | 18
 |  | Board [NAME] | 19 | 65-67 | 80-92 | 110-140 | 170-230 |  | Pieces instaled per hour | 2.25
 |  |  |  |  |  |  |  |  | Manuf per hr - LM | 20
 |  | Price per meter | 10 | 12 | 13 | 16 | 20
 |  | Price per Piece | 22 | 43 | 44 | 47 | 51
 |  | Caulking per LM | 6 | 6 | 6 | 6 | 6
 |  |  |  |  |  |  |  |  | [NAME] for every 17.5pc
 |  |  |  |  |  |  |  |  | > 30 min travel from workshop | 150
 |  |  |  |  |  |  |  |  | > 45 min travel from workshop | 200
 |  |  |  |  |  |  |  |  | > 60 min travel from workshop | 240
 |  |  |  |  |  |  |  |  | Aditional Flat Fees
 |  |  |  |  |  |  |  |  | Jobs under 20pc | 100
 |  |  |  |  |  |  |  |  | Tinted Paint per job | 55
 |  |  |  |  |  |  |  |  | 22.5 Degree Courners | 10
 |  |  |  |  |  |  |  |  | Wastage | 0.06
Spreadsheet: 08f8befe-b461-4c72-ae2f-0b8b1822212e
Sheet: T22

الجدول 22: السكان في الجمهورية العربية السورية بحسب [NAME] تعداد 1994
Table 22: Population of Syrian Arab Republic by age groups, 1994 census
 | Nationals | المواطنون | Non-nationals | [NAME] | Urban | حضر | Rural | ريف | Total |  | المجموع
[NAME] | ذكور | إناث | ذكور | إناث | ذكور | إناث | ذكور | إناث | ذكور | إناث | [NAME]
Age group | Male | Female | Male | Female | Male | Female | Male | Female | Male | Female | Both sexes
0-4 | ... | ... | ... | ... | ... | ... | ... | ... | 1056000 | 994000 | 2050000
5-9 | ... | ... | ... | ... | ... | ... | ... | ... | 1087000 | 1033000 | 2120000
10-14 | ... | ... | ... | ... | ... | ... | ... | ... | 1030000 | 975000 | 2005000
15-19 | ... | ... | ... | ... | ... | ... | ... | ... | 814000 | 785000 | 1599000
20-24 | ... | ... | ... | ... | ... | ... | ... | ... | 632000 | 622000 | 1254000
25-29 | ... | ... | ... | ... | ... | ... | ... | ... | 527000 | 518000 | 1045000
30-34 | ... | ... | ... | ... | ... | ... | ... | ... | 427000 | 420000 | 847000
35-39 | ... | ... | ... | ... | ... | ... | ... | ... | 332000 | 320000 | 652000
40-44 | ... | ... | ... | ... | ... | ... | ... | ... | 271000 | 256000 | 527000
45-49 | ... | ... | ... | ... | ... | ... | ... | ... | 202000 | 190000 | 392000
50-54 | ... | ... | ... | ... | ... | ... | ... | ... | 170000 | 171000 | 341000
55-59 | ... | ... | ... | ... | ... | ... | ... | ... | 135000 | 129000 | 264000
60-64 | ... | ... | ... | ... | ... | ... | ... | ... | 144000 | 133000 | 277000
65+ | ... | ... | ... | ... | ... | ... | ... | ... | 222000 | 187000 | 409000
غير محدد    Not stated | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ...
المجموع    Total | ... | ... | ... | ... | ... | ... | ... | ... | 7049000 | 6733000 | 13782000
Spreadsheet: sara_shackleton__36501__ENE MTM 0630 revised 2
Sheet: Credit Suisse 4-6

Current Date
Termination Date
Interest Payment Date
Quarter End Date
Lowest Date
Phantom Stock Hedge |  | Effective Date | 2000-04-06 00:00:00
Credit Suisse |  | Termination Date | 2000-05-08 00:00:00
 |  |  |  | Total |  |  |  | Total |  |  |  | Total |  |  |  |  |  | Total |  |  |  | Total
 |  |  | Quarter End | Quarter End |  | Quarter End | Quarter End | Quarter End |  | Quarter End | Quarter End | Quarter End |  |  |  | Quarter End | Quarter End | Quarter End |  | Quarter End | Quarter End | Quarter End
ENE |  |  | 2000-06-30 00:00:00 | 2000-06-30 00:00:00 |  | 2000-09-30 00:00:00 | 2000-09-30 00:00:00 | 2000-09-30 00:00:00 |  | 2000-12-31 00:00:00 | 2000-12-31 00:00:00 | 2000-12-31 00:00:00 |  | Year 2000 |  | 2001-03-31 00:00:00 | 2001-03-31 00:00:00 | 2001-03-31 00:00:00 |  | 2001-06-30 00:00:00 | 2001-06-30 00:00:00 | 2001-06-30 00:00:00 |  | Year 2001 |  | LTD
 | Market Price |  | 76.125
Shares: | 460000
Opening price
Interest Payment Dates |  |  | 2000-07-06 00:00:00 |  |  | 2000-07-06 00:00:00 | 2000-10-06 00:00:00 |  |  | 2000-10-06 00:00:00 | 2001-01-06 00:00:00 |  |  |  |  | 2001-01-06 00:00:00 | 2001-04-05 00:00:00 |  |  | 2001-04-05 00:00:00 | 2001-04-04 00:00:00
Equity Payment (CSFB pays if price goes up/Enron pays if price goes down)
 | Opening value
 | Closing Value
 | MTM
Dividend Payment (CSBI pays)
Expected quarterly dividend |  |  | 0 |  |  | 0.125 |  |  |  | 0.125 |  |  |  |  |  | 0.125 |  |  |  | 0.125
Payment
Interest Payment (Enron pays)
Interest Rate |  |  | 0.0628 |  |  |  | 0.0609 |  |  |  | 0.0609 |  |  |  |  |  | 0.0609 |  |  |  | 0.0609
Spread |  |  | 0.0105 |  |  | 0.0105 | 0.0105 |  |  | 0.0105 | 0.0105 |  |  |  |  | 0.0105 | 0.0105 |  |  | 0.0105 | 0.0105
All in Rate
Annual Day Count |  |  | 365 |  |  | 365 | 365 |  |  | 365 | 365 |  |  |  |  | 365 | 365 |  |  | 365 | 365
Beginning of period
End of period
Day Count
Payment
Net receipt/(payment)
Spreadsheet: 888471d1738956064-adjusting-a-maxifs-to-second-largest-date-found-observation-tracking-sample-01
Sheet: ENTRY

DATA ENTRY
X
DATE | DEPARTMENT | EMPLOYEE | OBSERVER | a. | b. | c. | d. | e. | f. | g. | h. | i. | j. | k. | l. | m. | n. | o. | Tally
2022-04-20 00:00:00 | Dept #01 | Employee #01 | Observer #01 | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
2022-10-03 00:00:00 | Dept #02 | Employee #02 | Observer #02 | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
2022-11-04 00:00:00 | Dept #03 | Employee #03 | Observer #03 | X | X | X | X | X | X |  |  | X |  | X | X | X | X | X
2022-11-04 00:00:00 | Dept #04 | Employee #04 | Observer #04 | X | X |  |  |  | X |  |  |  |  | X |  |  |  | X
2022-11-04 00:00:00 | Dept #05 | Employee #05 | Observer #05 | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
2022-11-04 00:00:00 | Dept #06 | Employee #06 | Observer #06 | X | X | X | X | X | X | X | X | X | X | X |  |  | X | X
2022-11-05 00:00:00 | Dept #07 | Employee #07 | Observer #07 | X | X |  | X |  | X |  | X |  |  |  |  |  |  | X
2022-11-05 00:00:00 | Dept #08 | Employee #08 | Observer #08 | X | X | X | X | X | X | X | X | X |  | X | X | X | X | X
2022-11-05 00:00:00 | Dept #01 | Employee #01 | Observer #09 | X | X | X | X |  | X | X |  | X |  | X | X | X | X | X
2022-11-05 00:00:00 | Dept #02 | Employee #02 | Observer #10 | X | X | X | X | X | X | X | X | X | X |  |  | X | X | X
2022-11-05 00:00:00 | Dept #03 | Employee #03 | Observer #11 | X | X | X | X | X | X | X | X | X | X | X |  |  | X | X
2022-11-07 00:00:00 | Dept #04 | Employee #04 | Observer #12 | X | X | X | X | X | X |  | X | X |  | X | X | X | X | X
2022-11-08 00:00:00 | Dept #05 | Employee #05 | Observer #13 | X | X | X | X | X | X | X |  | X |  | X |  | X | X | X
2022-11-08 00:00:00 | Dept #06 | Employee #06 | Observer #14 | X | X | X | X | X | X |  | X |  | X | X | X | X | X | X
2022-11-09 00:00:00 | Dept #07 | Employee #07 | Observer #15 | X | X | X | X | X |  | X | X | X | X | X | X |  | X
2022-11-10 00:00:00 | Dept #08 | Employee #08 | Observer #16 | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
2022-11-10 00:00:00 | Dept #01 | Employee #01 | Observer #17 | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
2022-11-11 00:00:00 | Dept #02 | Employee #02 | Observer #18 | X | X | X | X | X | X |  |  | X |  | X | X | X |  | X
2022-11-13 00:00:00 | Dept #03 | Employee #03 | Observer #19 | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
2022-11-13 00:00:00 | Dept #04 | Employee #04 | Observer #20 | X | X | X | X | X | X | X | X | X | X | X |  | X | X | X
2022-11-14 00:00:00 | Dept #05 | Employee #05 | Observer #21 | X | X | X |  | X | X | X | X | X | X |  | X | X | X | X
2022-11-15 00:00:00 | Dept #06 | Employee #06 | Observer #22 | X | X | X | X | X | X | X |  | X |  | X | X | X |  | X
Spreadsheet: phillip_m_love__30654__9902_OA
Sheet: EAST-CON-FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  ECTR (EGM) / LRC
REGION: EAST
 |  |  | NGP&L |  | CPR Adjustments |  | 3rd Day CPR |  | [NAME] |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
FT-East
 |  | Current Month MTM
 |  | Financial Liquidations
 |  | Originations
 |  | TOTAL FIRM TRADING
 |  | TOTAL NGPL
Spreadsheet: 10688e21-50c7-42b3-9f2f-b7d2c537a667
Sheet: Civilizations-History

 |  | CIVILIZATIONS - HISTORY |  | COURSES IN RED  ARE FALL  2012      PURPLE  J-TERM    GREEN  BOTH FALL & J-TERM
[NAME] | AOK designation | CAR designation | Comment
ARTH 210 | Civilizations-History | Non-Western | counts as HIST101, cross-listed with CLAS 210
Classics
CLAS 210 | Civilizations-History | Non-Western | counts as HIST101, cross-listing with ARTH 210
History
HIST 100 | Civilizations-History
HIST 101 | Civilizations-History
HIST 111 | Civilizations-History |  | only for Education minor
HIST 112 | Civilizations-History |  | only for Education minor
Honors Program
HONR 123 | Civilizations-History |  | equivalent to HIST 101
HONR 273 | Civilizations-History |  | equivalent to HIST 100
HONR 283 | Civilizations-History |  | equivalent to HIST 100
Spreadsheet: 60529d1261058446-have-postcodes-flag-up-when-entered-or-start-clicked-sample-101-
Sheet: Sheet2

se20
cr1
h21
h22
h23
h24
h25
cr1
cr2
cr3
cr4
cr5
cr6
[NAME]
se20
se21
se22
se23
se24
[NAME]
se26
se27
se28
se29
se30
se31
se32
[NAME]
se34
se35
se36
se37
se38
se39
se40
se41
se42
se43
se44
se45
se46
se47
se48
se49
se50
se51
se52
se53
se54
se55
se56
se57
se58
[NAME]
se60
se61
se62
se63
se64
se65
se66
se67
se68
se69
se70
[NAME]
se72
se73
se74
se75
se76
se77
se78
se79
se80
se81
se82
se83
se84
se85
se86
se87
se88
se89
se90
se91
se92
se93
se94
se95
se96
se97
se98
se99
se100
se101
se102
se103
se104
se105
se106
se107
se108
se109
se110
se111
se112
se113
se114
se115
se116
se117
se118
se119
se120
se121
se122
se123
se124
se125
se126
se127
se128
se129
se130
se131
[NAME]
se133
se134
se135
se136
se137
se138
se139
se140
se141
se142
se143
[NAME]
se145
se146
[NAME]
[NAME]
se149
se150
se151
se152
se153
[NAME]
se155
se156
[NAME]
[NAME]
se159
se160
se161
[NAME]
se163
se164
se165
se166
se167
se168
se169
se170
se171
se172
se173
se174
[NAME]
[NAME]
se177
se178
se179
se180
se181
se182
se183
se184
se185
se186
se187
se188
se189
se190
se191
se192
se193
se194
se195
se196
[NAME]
se198
se199
se200
se201
se202
se203
se204
se205
se206
se207
se208
se209
se210
[NAME]
se212
se213
se214
se215
se216
se217
se218
se219
se220
se221
se222
se223
se224
se225
se226
se227
se228
se229
se230
[NAME]
se232
Spreadsheet: 788956d1658822845-conditional-formatting-a-range-of-cells-based-on-the-value-of-corresponding-range-book2formatting
Sheet: Sheet2

56 | 40 | 38 | 37 | 56 | 47 |  |  |  |  |  |  |  | 70
53 | 70 | 61 | 67 | 64 | 66
41 | 57 | 50 | 66 | 48 | 47
28 | 36 | 57 | 44 | 57 | 44
63 | 63 | 51 | 59 | 65 | 52
21 | 51 | 47 | 54 | 50 | 51
50 | 63 | 67 | 62 | 62 | 56
69 | 63 | 61 | 80 | 56 | 54
49 | 53 | 57 | 55 | 53 | 52
60 | 63 | 44 | 32 | 56 | 39 |  |  |  |  |  |  | 50 | 57
53 | 59 | 51 | 77 | 57 | 57
36 | 65 | 52 | 65 | 49 | 57
51 | 50 | 46 | 69 | 47 | 44
38 | 54 | 64 | 54 | 64 | 52
74 | 67 | 56 | 94 | 66 | 63
58 | 54 | 50 | 73 | 54 | 48
34 | 68 | 45 | 46 | 63 | 62
73 | 56 | 64 | 79 | 64 | 66
48 | 61 | 46 | 73 | 58 | 53
51 | 52 | 54 | 62 | 54 | 56
50 | 68 | 71 | 65 | 60 | 62
39 | 64 | 58 | 67 | 54 | 60
 |  |  | 54 | 46
50 | 58 | 59 | 53 | 53 | 51
28 | 60 | 32 | 40 | 50 | 42
84 | 63 | 60 | 59 | 61 | 50
50 | 69 | 67 | 80 | 55 | 52
50 | 68 | 60 | 50 | 55 | 54 |  |  |  |  |  |  |  | 70
25 | 58 | 46 | 52 | 33 | 37 |  |  |  |  |  |  |  | 50
50 | 59 | 64 | 66 | 62 | 60
65 | 64 | 63 | 53 | 62 | 52
38 | 47 | 60 | 63 | 57 | 51
69 | 58 | 51 | 56 | 55 | 50
36 | 62 | 61 | 53 | 65 | 29
32 | 55 | 59 | 54 | 57 | 50
Spreadsheet: 754414d1636147993-writing-ifs-formula-looking-in-different-columns-to-return-text-example-workbook
Sheet: Sheet1

Accounts | Status | Current Units | Kickoff email | Assesssment call | Cust call | Deployment call | Order(s) placed
Account 1 |  | 30 | Done
Account 2 |  | 60 | Done | Done
Account 3 |  | 45 | Done | Done | Done
Spreadsheet: 68939156-3d86-431e-a4b5-0f0d74f76f85
Sheet: Sheet1

Listi | Unnamed: 1
VI-1 | Íbúðaverð á höfuðborgarsvæðinu
VI-2 | Fasteignaverð á höfuðborgarsvæðinu
VI-3 | Íbúðaverð á höfuðborgarsvæðinu
VI-4 | Markaðsverð húsnæðis
VI-5 | Auglýstar fasteignir og meðalsölutími birgða
VI-6 | Fjöldi og fjárhæð nýrra íbúðalána
VI-7 | Raunverð atvinnuhúsnæðis á höfuðborgarsvæðinu
VI-8 | Velta atvinnuhúsnæðis eftir tegund og starfsemi
VI-9 | [NAME]
Spreadsheet: 129895d1321965538-separating-cell-values-separating-cell-values
Sheet: Blad1

£100.99
£14.99
£14.49
£13.99
£13.49
£12.99
£12.49
£11.99
£11.49
£10.99
£10.49
£9.99
£9.49
£8.99
£8.49
£7.99
£7.49
£6.99
£6.49
£5.99
£5.49
£4.99
£4.49
£3.99
£3.49
£2.99
£2.49
£1.99
£1.49
£0.99
£0.49
Spreadsheet: 116716d1312048336-selective-columns-copy-of-handicapscorecards-master2
Sheet: result

Position | PLAYER | TOTAL |  | [NAME] | No | PLAYER | PAR 3 | TOTAL | S.I. > | 1 | 2 | 3
Spreadsheet: 741697d1627282998-countifs-with-three-identifier-checks-and-between-specific-time-countifs_samplesheet-aligw
Sheet: Sheet1

Type | Time | Name | Destination
Reg | 2021-07-19 21:48:41 | Name One | 156
Reg | 2021-07-12 20:09:42 | Name One | 155 |  |  | Destination |  | 155 | Type | Reg
Reg | 2021-07-19 17:57:55 | Name Two | 156
SL | 2021-07-19 18:03:09 | Name Two | 157 |  |  |  | Time Start | Time End | Name One | Name Two | Name Three | Name Four | Name Five
SL | 2021-07-19 18:20:02 | Name Three | 268 |  |  |  | 13:00:00 | 13:30:00
Reg | 2021-07-19 21:49:55 | Name Four | 268 |  |  |  | 13:30:00 | 14:00:00
SL | 2021-07-13 19:46:57 | Name One | 155 |  |  |  | 14:00:00 | 14:30:00
SL | 2021-07-13 21:51:28 | Name Three | 157 |  |  |  | 14:30:00 | 15:00:00
SL | 2021-07-15 13:58:08 | Name Five | 157 |  |  |  | 15:00:00 | 15:30:00
SL | 2021-07-14 21:27:44 | Name Two | 156 |  |  |  | 15:30:00 | 16:00:00
Reg | 2021-07-12 20:09:42 | Name One | 155 |  |  |  | 16:00:00 | 16:30:00
Reg | 2021-07-12 20:09:42 | Name One | 155 |  |  |  | 16:30:00 | 17:00:00
Reg | 2021-07-12 20:09:42 | Name Three | 155 |  |  |  | 17:00:00 | 17:30:00
Reg | 2021-07-12 20:09:42 | Name Five | 156 |  |  |  | 17:30:00 | 18:00:00
 |  |  |  |  |  |  | 18:00:00 | 18:30:00
 |  |  |  |  |  |  | 18:30:00 | 19:00:00
 |  |  |  |  |  |  | 19:00:00 | 19:30:00
 |  |  |  |  |  |  | 19:30:00 | 20:00:00
 |  |  |  |  |  |  | 20:00:00 | 20:30:00
 |  |  |  |  |  |  | 20:30:00 | 21:00:00
 |  |  |  |  |  |  | 21:00:00 | 21:30:00
 |  |  |  |  |  |  | 21:30:00 | 22:00:00
 |  |  |  |  |  |  | 22:00:00 | 22:30:00
 | The goal is to have the table take an accurate count if the Destination matches, the [NAME] matches, the Type matches, and it is Equal to or between the specified times.
 | For this example it should report on the row for 20:00 to 20:30, 3 for Name One and 1 for Name Three.
Spreadsheet: 104784d1302240025-pmt-formula-help-segagirl
Sheet: Financing

Loan Options - Opal Industries Purchase
Amount of Loan
Period (months) | 36
Interest Rate (yearly) | 0.055
 |  | Number of Monthly Payments
 |  | 12 | 24 | 36 | 48 | 60
Rates | 0.025
 | 0.03
 | 0.035
 | 0.04
 | 0.045
 | 0.05
 | 0.055
 | 0.06
 | 0.065
Spreadsheet: 808166d1670332810-lookup-values-with-multiple-inputs-example-lookup-v2
Sheet: TABLE B

Summary | Date | Person A | Person B | Person C | Person D | Person E |  | Notes
 | 2022-12-05 00:00:00
 | 2022-12-06 00:00:00
 | 2022-12-07 00:00:00 |  | Apple
 | 2022-12-08 00:00:00 | Carrot |  |  | Orange |  |  | In this row [NAME] is ignored because it is not a fruit included in Table A
 | 2022-12-09 00:00:00 |  |  |  |  | Pear
 | 2022-12-10 00:00:00 |  |  | Apple | Apple |  |  | In this row two people have apple under their name on this date, I only need the first value to be returned
 | 2022-12-11 00:00:00
 | 2022-12-12 00:00:00 |  |  |  | [NAME]
 | 2022-12-13 00:00:00
 | 2022-12-14 00:00:00 | Pear
Spreadsheet: 165534d1341258172-excel-2007-index-and-match-with-duplicates-book
Sheet: fail

 | martial Artist |  | Values |  | Top 6  Martial Artists |  |  | Top 6 Values
 | [NAME] |  | 9
 | [NAME] |  | 8
 | [NAME] |  | 7
 | Chow-Yun Fat |  | 5
 | [NAME] |  | 5
 | [NAME] |  | 10
 | [NAME] |  | 7
 | [NAME] |  | 7