tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 817047d1675966516-if-statments-in-the-correct-logical-order-if-statment-logic
Sheet: Sheet2

 |  |  |  |  | Sale $ | Original Total Cost | New Value | New Ratio | New Land | New Bldg | Units | Unit $ | Nbr_Parcels
 |  |  |  |  | 0 | 89960 | 299760 | 3.332147621164962 | 43500 | 256260 | 5 | 59952 | 1
 |  |  |  |  | 0 | 100080 | 306970 | 3.06724620303757 | 43500 | 263470 | 5 | 61394 | 1
 |  |  |  |  | 0 | 72100 | 203450 | 2.821775312066574 | 33940 | 169510 | 4 | 50862.5 | 1
 |  |  |  |  | 320000 | 254940 | 287500 | 0.8984375 | 45750 | 241750 | 4 | 71875 | 1
 |  |  |  |  | 0 | 526090 | 576140 | 1.09513581326389 | 72900 | 503240 | 9 | 64015.55555555555 | 1
 |  |  |  |  | 0 | 528030 | 578080 | 1.094786281082514 | 72900 | 505180 | 9 | 64231.11111111111 | 1
 |  |  |  |  | 661000 | 186060 | 301940 | 0.1522642460917801 | 28800 | 273140 | 4 | 75485 | 3
 |  |  |  |  | 0 | 187430 | 250420 | 1.336072133596543 | 0 | 250420 | 4 | 62605 | 1
 |  |  |  |  | 0 | 185250 | 248240 | 1.340026990553306 | 0 | 248240 | 4 | 62060 | 1
 |  |  |  |  | 0 | 185250 | 248240 | 1.340026990553306 | 0 | 248240 | 4 | 62060 | 1
Spreadsheet: louise_kitchen__24097__NEWCO HEADCOUNT NAMES1
Sheet: Market Risk & Researcch

Market Risk & Research |  |  |  | ok |  | Bonus
[NAME] | Naveen | Research | Director |  |  |  | R
Hayden | [NAME] | Market Risk | Director |  |  |  | R
Gorny | Valdy | Market Risk | Director |  |  | 90000 | Did he get a retention bonus???
[NAME] | [NAME] | Market Risk | Director | 4 |  |  | R
Port | [NAME] | Market Risk | Sr. Director | 1 |  |  | R
[NAME] | Vasant | Research | VP | 1 |  | 150000
 |  |  | TOTAL | 6
Buy | [NAME] | MD | MD |  |  |  | GW
Heathman | [NAME] | [NAME] | [NAME] |  |  | 7500
[NAME] | Mark | Research | Manager |  |  | 60000
Schneider | Chip | RAC | VP |  |  |  | R
Hagelmann | Bjorn | Market Risk | Manager |  |  |  | R
 |  |  |  | 11
Spreadsheet: 856304d1705589564-need-to-add-a-cap-to-forumla-tiered-commission-example
Sheet: Sheet1

 |  |  |  | Gross Sales | Broker Rate | [NAME]
 |  |  |  | 0 | 0.35 | 0.65
 |  |  |  | 50000 | 0.2 | 0.8
 | [NAME] paid to broker |  |  | 65000 | 0.1 | 0.9
 | 25000 |  |  | 100000000 | 0 | 1
Date | Client | Address | Price | YTD Sales | Commision Rate | Commission Amount | Broker Commission | Broker Cumulative | Realtor Commission | [NAME]
2023-03-10 00:00:00 | [NAME] | 460 Trailwood Circle, [NAME], AR 72719 | 955000 |  | 0.015
2023-04-03 00:00:00 | [NAME] | 700 Skylar St (Lot 36), [NAME], AR 72713 | 415900 |  | 0.03
2023-06-23 00:00:00 | [NAME] | 4619 Highland Knolls, [NAME], AR 72758 | 475000 |  | 0.025
2023-06-21 00:00:00 | [NAME] | 3405 [NAME], Rogers, AR 72756 | 185000 |  | 0.025
2023-08-31 00:00:00 | [NAME] | 900 Illinois Ave, [NAME], AR 72719 | 195000 |  | 0.0275
2023-09-08 00:00:00 | Bachina | 721 Melrose Pl, Bentonville, AR 72712 | 370500 |  | 0.03
2023-09-13 00:00:00 | [NAME] | 3 [NAME], [NAME], AR 72714 | 385000 |  | 0.03
2023-09-29 00:00:00 | [NAME] | 520 Sorrento Dr, [NAME], AR 72719 | 390000 |  | 0.03
2023-12-15 00:00:00 | Shleby Ekstrand | 1 Renfrew Dr | 380000 |  | 0.02
 |  | 83 Portsmough |  |  | 0.02
 |  | 83 Portsmough | 332000 |  | 0.025
2023 Totals
Spreadsheet: 3e7c6c7b-9b29-4da2-a715-61e614612906
Sheet: List

 |  |  | Health-Related Institutions |  |  |  | Return to Index
 |  |  | FY 2011 Summary of Research Expenditures
 |  |  | December 16, 2011
Institution | Research Expenditures Per SRECNA | R & D Not Meeting the Definition of the Research Exp. Survey | Indirect Costs Associated w/ R & D | Capital Outlay for Research | Institution's Research Foundation Expenditures for R & D | Pass Throughts From TX Eng. Exp. Station | Total Research Expenditures As Deetermined by Research Survey
Total
9 Ok
 |  |  |  |  |  |  | Amts. Used for Formula Funding
12-16-2011 Totals | 1431939561 | 0 | 283601301 | 60190816 | 37158489 | 253184 | 1813143351
Spreadsheet: sally_beck__35760__MgmtSum-Q1-0327
Sheet: Whalley

ENRON NORTH AMERICA
1ST QUARTER 2000 EARNINGS ESTIMATE
Results based on Activity through February 17, 2000
 |  | Earnings Before Tax |  |  |  | Components of Earnings Before Tax |  |  |  |  |  |  |  |  |  | Variances from Plan
 |  |  |  |  |  | Actual | Deals | Forecast | Total | Operating | Capital | Direct | Allocated |  |  | Total | Operating | Capital | Direct | Allocated
Business Team |  | Estimate | Plan | [NAME] |  | Margin | Identified | Margin | Margin | Expenses | Charge | Expenses | Expenses | Total |  | Margin | Expenses | Charge | Expense | Expense | Total
Gas Trading
Power Trading
Financial Drift
Financial Trading
Canada
Coal
Weather
Emissions
Insurance Group
Gas Assets - Trading
Executive Trading
Total Trading & Risk Mgt.
Spreadsheet: 851231d1701451526-lookup-particular-column-in-table-whilst-summing-multiple-rows-with-criteria-npd-kpi-pack-test
Sheet: Product Revenue

Brand | RP | Description | 2023June | 2023July | 2023August | 2023September | 2023October | 2023November | 2023December | 2024January | 2024February | 2024March | 2024April | 2024May
Hello | [NAME] | produ ct 1 |  |  |  | 1832.76 | 29218.51
TEST | [NAME] | produ ct 2 |  |  |  |  | 53553 | 555
TEST | [NAME] | produ ct 3 |  |  | 2355 | 535 | 53
TEST | [NAME] | produ ct 4 |  |  |  |  | 626 | 62
TEST | [NAME] | produ ct 5 |  |  |  |  | 26 | 6266
TEST | [NAME] | produ ct 6
TEST | [NAME] | produ ct 7
TEST | [NAME] | produ ct 8
TEST | [NAME] | produ ct 9
TEST | [NAME] | produ ct 10
Bonjour | [NAME] | produ ct 11
Bonjour | [NAME] | produ ct 12
Bonjour | [NAME] | produ ct 13
Bonjour | [NAME] | produ ct 14
Bonjour | [NAME] | produ ct 15
Bonjour | [NAME] | produ ct 16
Bonjour | [NAME] | produ ct 17
Bonjour | [NAME] | produ ct 18
Bonjour | [NAME] | produ ct 19
Bonjour | [NAME] | produ ct 20
Bonjour | [NAME] | produ ct 21 |  |  |  | 2246.25 | 742.76
Bonjour | [NAME] | produ ct 22
Bonjour | [NAME] | produ ct 23
Total
Year to Date
Spreadsheet: 762963d1641918865-sum-of-values-across-multiple-sheets-sum-of-vls-mltpl-sheets
Sheet: FEB

2022-01-28 00:00:00 |  |  | 2500
2022-01-29 00:00:00 |  |  | 54.01600000000001
2022-02-01 00:00:00 |  |  | 3500
2022-02-01 00:00:00 |  |  | 932.45
2022-02-01 00:00:00 |  |  | 1284
2022-02-01 00:00:00 |  |  | 750
2022-02-01 00:00:00 |  |  | 20
2022-02-01 00:00:00 |  |  | 350
2022-02-01 00:00:00 |  |  | 550
2022-02-02 00:00:00 |  |  | 4.037696
2022-02-04 00:00:00 |  |  | 150
2022-02-04 00:00:00 |  |  | 11
2022-02-06 00:00:00 |  |  | 2278.62
2022-02-08 00:00:00 |  |  | 80
2022-02-08 00:00:00 |  |  | 80
2022-02-10 00:00:00 |  |  | 7
2022-02-13 00:00:00 |  |  | 16.98
2022-02-15 00:00:00 |  |  | 16
2022-02-16 00:00:00 |  |  | 300
2022-02-18 00:00:00 |  |  | 155.85
2022-04-01 00:00:00 |  |  | 1250
2023-01-30 00:00:00 |  |  | 750
2023-02-06 00:00:00 |  |  | 2323
2023-02-06 00:00:00 |  |  | 750
2023-02-13 00:00:00 |  |  | 750
2023-02-20 00:00:00 |  |  | 750
2023-02-27 00:00:00 |  |  | 750
Spreadsheet: 887048d1737137894-formula-required-for-calculating-who-sits-with-who-at-multiple-tables-formula-required-for-calculating-who-sits-with-who-at-multiple-tables
Sheet: Sheet1

There are two tables, the data below shows who sat at which table each week
 | Which table
 |  | Week 1 | Week 2 | Week 3 | Week 4 | Week 5
 | [NAME] | 1 | 2 | 1 | 1 | 2
 | Debbie | 2 | 1 | 1 | 2 | 2
 | [NAME] | 1 | 1 | 2 | 1 | 1
 | Mark | 2 | 2 | 2 | 2 | 1
Using the countif function it is possible to see how many times each person has sat at each table
 | How many times at each table
 |  | Table 1 | Table 2
 | [NAME]
 | Debbie
 | [NAME]
 | Mark
How am I able to calculate who has sat with each other person in total, (for example, how many times has [NAME] sat at the same table as Debbie)?
 | How many times sat with each other
 |  | [NAME] | Debbie | [NAME] | Mark
 | [NAME]
 | Debbie
 | [NAME]
 | Mark
Spreadsheet: 374158d1422697369-data-incorrectly-pulling-causing-error-in-formula-test-work
Sheet: Values

J
 |  |  |  |  |  |  |  |  | POSITION ELIGIBILITY
 | RANK | PLAYER INFORMATION |  | LEAGUE BUDGET TOTALS |  |  |  |  | 2014 GAMES PLAYED BY POSITION
 | MIXED | TM | PLAYER | DEFAULT | CUSTOM | INFLATION | AUC-PRICE |  | C | 1B | 2B | SS | 3B | CI | MI | LF | CF | RF | OF | DH | SP | RP | P | VALUE
 | 1 | LAA | [NAME] | 42 |  |  |  | 42 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 149 | 0 | 149 | 8 | 0 | 0 | 0 | 50
 | 2 | LAD | [NAME] | 41 |  |  |  | 41 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 27 | 0 | 27 | 45
 | 3 | PIT | [NAME] | 38 |  |  |  | 38 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 146 | 0 | 146 | 0 | 0 | 0 | 0 | 46
 | 4 | DET | [NAME] | 36 |  |  |  | 36 | 0 | 126 | 0 | 0 | 10 | 136 | 0 | 0 | 0 | 0 | 0 | 25 | 0 | 0 | 0 | 47
 | 5 | ARZ | [NAME] | 35 |  |  |  | 35 | 0 | 109 | 0 | 0 | 0 | 109 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 30
 | 6 | MIA | [NAME] | 34 |  |  |  | 34 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 143 | 143 | 2 | 0 | 0 | 0 | 29
 | 7 | CWS | [NAME] | 33 |  |  |  | 33 | 0 | 109 | 0 | 0 | 0 | 109 | 0 | 0 | 0 | 0 | 0 | 35 | 0 | 0 | 0 | 50
 | 8 | MIL | [NAME] | 32 |  |  |  | 32 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 145 | 0 | 145 | 1 | 0 | 0 | 0 | 60
 | 9 | BAL | [NAME] | 31 |  |  |  | 31 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 155 | 0 | 155 | 4 | 0 | 0 | 0 | 75
 | 10 | SEA | [NAME] | 31 |  |  |  | 31 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 34 | 0 | 34 | 0
 | 11 | TOR | [NAME] | 30 |  |  |  | 30 | 0 | 12 | 0 | 0 | 0 | 12 | 0 | 0 | 12 | 131 | 133 | 13 | 0 | 0 | 0 | 0
 | 12 | TOR | [NAME] | 30 |  |  |  | 30 | 0 | 81 | 0 | 0 | 0 | 81 | 0 | 2 | 0 | 0 | 2 | 46 | 0 | 0 | 0 | 0
 | 13 | HOU | [NAME] | 29 |  |  |  | 29 | 0 | 0 | 156 | 0 | 0 | 0 | 156 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0
 | 14 | SEA | [NAME] | 29 |  |  |  | 29 | 0 | 0 | 150 | 0 | 0 | 0 | 150 | 0 | 0 | 0 | 0 | 8 | 0 | 0 | 0 | 0
 | 15 | CLE | [NAME] | 28 |  |  |  | 28 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 107 | 46 | 0 | 147 | 8 | 0 | 0 | 0 | 0
Spreadsheet: 752274d1634675108-how-to-change-change-formulas-such-that-formula-is-based-on-work-days-rather-than-days-samplesheet1
Sheet: Sample

TASK | START | END | DAYS | WORK DAYS
Main Level |  |  |  | 5
Task 1 | 2021-10-20 00:00:00 |  | 7
Task 2 | 2021-10-20 00:00:00 |  | 7
Sub-Level
Task 3 |  |  | 2
Task 4 |  |  | 4
Task 5 |  |  | 1
Task 6 |  |  | 2
Task 7 |  |  | 3
Task 8 |  |  | 2
Task 9 |  |  | 1
Task 10 |  |  | 1
Task 11 |  |  | 1
Sub-Level 2
Task 13 |  |  | 2
Task 14 |  |  | 2
Task 15 |  |  | 4
Sub-Level 3
Task 16 | 2021-10-18 00:00:00 |  | 19
Task 17 |  |  | 8
Task 18 |  |  | 9
Sub-Level 4
Task 19 |  |  | 14
Task 20 |  |  | 14
Task 21 |  |  | 14
Sub-Level 5
Task 22 |  |  | 5
Task 23 |  |  | 1
Task 24 |  |  | 22
Spreadsheet: 165b248d-c8e3-482e-a09f-92ba3d8930b1
Sheet: Corrective Action Report

Produce GAPs Harmonized Food Safety Standard
Field Operations & Harvesting - USDA Checklist
USDA, AMS, Fruit and Vegetable Program |  |  |  |  | Report #:
Good Agricultural Practice & Good Handling Practices |  |  |  |  |  |  | of
CORRECTIVE ACTION REPORT
Company Name/Farm: |  |  |  |  | Date:
Lead Auditor:
Crop(s):
Description of Non Conformity:
Notified company staff at time of finding non-conformity (Yes or No):
Checklist question number and/or section of auditee food safety plan associated with non-conformity:
Corrective Action Proposed and Time Frame for Implementation:  (Attach separate sheet if necessary)
Company Representative Signature:
Signature affirms statements concerning Non-Conformity, Corrective Action, and Implementation are correct.
Auditor signature for acceptance of proposed corrective action and timetable for implementation:
Top portion for AUDITOR USE ONLY; bottom portion for Company and Auditor use.
Spreadsheet: 716526d1612258069-conversion-of-sales-leads-to-targets-leadtosales
Sheet: Sheet2

 | Sale Month | Forecast Widgit Sales | # [NAME] to meet Widget Sales | Jan | Feb | Mar | Apr |  | Final result |  |  | Month | %
 | 2022-01-31 00:00:00 | 382 |  | 5 |  |  |  |  |  |  |  | 1 | 0.08
 |  | 412 |  | 57 | 5 |  |  |  |  |  |  | 2 | 0.57
 |  | 413 |  | 32 | 57 | 5 |  |  |  |  |  | 3 | 0.32
 |  | 407 |  | 3 | 32 | 57 | 5 |  |  |  |  | 4 | 0.03
 |  | 450 |  |  | 3 | 32 | 57
 |  | 433 |  |  |  | 3 | 32
 |  | 325 |  |  |  |  | 3
 |  | 100
 |  | 100
 |  | 100
 |  | 100
 |  | 492
 |  | 397
 |  | 450
 |  | 462
 |  | 436
 |  | 460
 |  | 416
Spreadsheet: 194804d1353339000-how-to-make-a-list-from-data-out-of-multiple-sheets-dummie
Sheet: sheet 1

Collection
Comments:
Total from totals
Contract | [NAME] size+ color                       Uniquenr | Brand | Material nr. | Model | Color | Size | Release date | Contract timeframe |  | Comment |  | Contract QTY | 2012-11-13 00:00:00 | 2012-12-01 00:00:00 | 2013-01-01 00:00:00 | 2013-02-01 00:00:00 | 2013-03-01 00:00:00 | 2013-04-01 00:00:00 | 2013-05-01 00:00:00 | 2013-06-01 00:00:00 | 2013-07-01 00:00:00 | 2013-08-01 00:00:00 | 2013-09-01 00:00:00 | 2013-10-01 00:00:00 | 2013-11-01 00:00:00 | 2013-12-01 00:00:00 | 2014-01-01 00:00:00 | 2014-02-01 00:00:00 | 2014-03-01 00:00:00 | 2014-04-01 00:00:00 | 2014-05-01 00:00:00 |  | 1st delivery                     date and amount |  | 2nd delivery                     date and amount |  | 3th delivery                     date and amount |  | 4th delivery                     date and amount |  | 5th delivery                     date and amount |  | 6th delivery                     date and amount |  | 7th delivery                     date and amount |  | 8th delivery                     date and amount |  | 9th delivery                     date and amount
 |  | sdfsdf | 565325 | [NAME] | 5090 | 979797 | 2012-10-08 00:00:00 |  |  |  |  |  |  |  |  | 11 |  |  | 44 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-09-08 00:00:00 | 222 | 2110-09-08 00:00:00 | 14124
 |  | Bladiebla | 565326 | kjoj334 | 5091 | 979798 | 2012-10-09 00:00:00
 |  | bvvvvb | 565327 | kjoj335 | 5092 | 979799 | 2012-10-10 00:00:00
 |  | 2423wrfe | 565328 | kjoj336 | 5093 | 979800 | 2012-10-11 00:00:00
 |  | afasdasd | 565329 | kjoj337 | 5094 | 979801 | 2012-10-12 00:00:00
 |  | adffgsdg | 565330 | [NAME] | 5095 | 979802 | 2012-10-13 00:00:00
 |  | hfdhe4t2 | 565331 | kjoj339 | 5096 | 979803 | 2012-10-14 00:00:00
Spreadsheet: 162507d1339939754-help-with-calculations-in-a-meal-plan-example
Sheet: Tuesday

Tuesday | Servings | Serving Size | Food Item | Protein | Fat | Carbs | Total
Breakfast | 1 |  | Egg
 | 1 |  | Brokkoli
 | 1 |  | Cabbage
 | 1 |  | Carrot
 |  |  | TOTAL
Before Training | Servings | Serving Size | Food Item | Protein | Fat | Carbs | Total
 | 1 |  | Egg
 | 1 |  | Brokkoli
 | 1 |  | Cabbage
 |  |  | TOTAL
After Training | Servings | Serving Size | Food Item | Protein | Fat | Carbs | Total
 | 1 |  | Egg
 | 1 |  | Brokkoli
 | 1 |  | Cabbage
 | 1 |  | Carrot
 |  |  | TOTAL
2 Hours After Training | Servings | Serving Size | Food Item | Protein | Fat | Carbs | Total
 | 1 |  | Egg
 | 1 |  | Brokkoli
 | 1 |  | Cabbage
 | 1 |  | Carrot
 |  |  | TOTAL
Evening Meal | Servings | Serving Size | Food Item | Protein | Fat | Carbs | Total
 | 1 |  | Egg
 | 1 |  | Brokkoli
 | 1 |  | Cabbage
 | 1 |  | Carrot
 |  |  | TOTAL
 |  |  | Daily TOTALS:
Spreadsheet: 758624d1638974338-if-with-sumproduct-from-multiple-sheets-result-dig-gk-
Sheet: Data

Apr | DEPT TOT | 2021
 | TOTAL COST (TSEK) - ACTUAL | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual
 |  | Jan | Feb | Mar | Apr | Maj | Jun | Jul | Aug | Sep | Okt | Nov | Dec | YTD
 | Content / Product Costs
 | Marketing and Advertising
 | Customer Operations
 | Sales and  Distribution
 | G&A / Other
 | Net retention costs
 | Net customer acquisition costs
 | Own retail chain costs
 | Running OpEy + Customer Investments
 | Check
 | Ack
 | ↓↓↓ RELEASED RESERVE ↓↓↓
 | Total Released Reserve
 | RELEASED RESERV (TSEK) Online
 | Customer Operations
 | [NAME] finance and billing
 | Customer Other customer operations costs
 | [NAME] operations staff direct costs
 | Sales and  Distribution
 | Sales Other channel operating costs OPEX
 | Sales Sales and Distribution staff direct costs OPEX
 | TOTAL OpEy + Customer Investments
 | Ack
 | RELEASED RESERV (TSEK) New Business
 | Customer Operations
 | [NAME] finance and billing
 | Customer Other customer operations costs
 | [NAME] operations staff direct costs
 | Sales and  Distribution
 | Sales Other channel operating costs OPEX
 | Sales Sales and Distribution staff direct costs OPEX
 | TOTAL OpEy + Customer Investments
 | Ack
 | RELEASED RESERV (TSEK) Digital Transformation
 | Customer Operations
 | [NAME] finance and billing
 | Customer Other customer operations costs
 | [NAME] operations staff direct costs
 | Sales and  Distribution
 | Sales Other channel operating costs OPEX
 | Sales Sales and Distribution staff direct costs OPEX
 | TOTAL OpEy + Customer Investments
 | Ack
 | TOTAL COST (TSEK) - BUDGET | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | BU
 |  |  |  |  |  |  |  |  |  |  |  |  |  | YTD
 | Check
 | Ack
Spreadsheet: 96733d1296049361-counting-an-item-once-when-it-has-several-parts-to-it-weeksclosed
Sheet: Sheet2

Concession No | Date | Week No | Severity | Raised/Closed
200090155 | 2010-08-14 00:00:00 | 40 | Minor | Raised
200090155 | 2010-08-14 00:00:00 | 40 | Minor | Raised |  |  | Count of Concession No |  | Week No
200090155 | 2010-08-14 00:00:00 | 40 | Minor | Raised |  |  | Severity | Raised/Closed | 40 | 41 | 42 | 43 | 45 | 46 | 47 | Grand Total
200090155 | 2010-08-14 00:00:00 | 40 | Minor | Raised |  |  | Major | Raised |  |  |  |  |  | 1 | 1 | 2
200090297 | 2010-08-18 00:00:00 | 45 | Minor | Raised |  |  | Major Total |  |  |  |  |  |  | 1 | 1 | 2
200090297 | 2010-08-18 00:00:00 | 45 | Minor | Raised |  |  | Minor | Closed | 1 | 1 | 1 | 1 |  |  |  | 4
200090297 | 2010-08-18 00:00:00 | 45 | Minor | Raised |  |  |  | Raised | 4 |  |  |  | 4 |  |  | 8
200090297 | 2010-08-18 00:00:00 | 45 | Minor | Raised |  |  | Minor Total |  | 5 | 1 | 1 | 1 | 4 |  |  | 12
200090367 | 2010-08-26 00:00:00 | 46 | Major | Raised |  |  | Grand Total |  | 5 | 1 | 1 | 1 | 4 | 1 | 1 | 14
200090530 | 2010-08-26 00:00:00 | 47 | Major | Raised
200090155 | 2010-08-10 00:00:00 | 40 | Minor | Closed
200090155 | 2010-08-11 00:00:00 | 41 | Minor | Closed
200090155 | 2010-08-12 00:00:00 | 42 | Minor | Closed
200090155 | 2010-08-13 00:00:00 | 43 | Minor | Closed
Spreadsheet: 859267d1707722509-multiple-choice-data-stack-up-under-specific-column-along-multiple-box-expected-outcome
Sheet: Sheet0

Recipient Last Name | Recipient First Name | Recipient Email | User Language | 1- What department are you in? - Selected Choice | 1- What department are you in? - Other - Text | 2- Are you responsible for submitting CCTs? | 3- What is your job title/role? - Selected Choice | 3- What is your job title/role? - Other - Text | 4- List the study ID(s) that require modification | 5- Is there anything else you would like to share with us? | Test - Selected Choice | Test - Please enter study ID1 - Text | Test - Please enter study ID2 - Text | Test - Please enter study [NAME]
Mac | Nina | [EMAIL] | EN | Dermatology - Research |  | Yes | Pharmacist |  | 20121-09586
Mac | Nina | [EMAIL] | EN | Dermatology - Research |  | Yes | Pharmacist |  | 2024-00010
Mac | Nina | [EMAIL] | EN | Dermatology - Research |  | Yes | Pharmacist |  | 2025-0989
Mac | Nina | [EMAIL] | EN | Dermatology - Research |  | Yes | Pharmacist |  | 10234-0987
Johny | tampam | [EMAIL] | EN | hemathology |  | Yes | RN |  | 2024-00011 |  |  | 2024-00011 | 2025-0967 | 10234-0988
Johny | tampam | [EMAIL] | EN | hemathology |  | Yes | RN |  | 2025-0967
Johny | tampam | [EMAIL] | EN | hemathology |  | Yes | RN |  | 10234-0988
Gony | arinaz | [EMAIL] | SP | GI |  | NO | MD |  | 2024-00012
Gony | arinaz | [EMAIL] | SP | GI |  | NO | MD |  | 2025-0991
Gony | arinaz | [EMAIL] | SP | GI |  | NO | MD |  | 10234-076 |  |  | 2024-00012 | 2025-0991 | 10234-076
Spreadsheet: 300561d1393512172-combine-data-from-one-sheet-to-another-removing-duplicates-activelist
Sheet: Sheet1

Employee ID | Social Security Number | Last Name | First Name | Middle Name | Inactive | Start Date | Date Employee Inactivated | Suta State | State | Employee Class | Department | Job Title | Gender | Ethnic Origin
21909 | 316-13-4922 | Abase | [NAME] | L | No |  |  | CA | CA | 01 | IR08 | BU3 | Female | N/A
35910 | 216-13-4935 | Acevedo | [NAME] |  | No |  |  | NY | NY | 02 | IR09 | BU1 | Male | N/A
35911 | 216-13-4936 | Acevedo | [NAME] |  | No |  |  | CA | CA | 03 | IR10 | BU3 | Male | N/A
35912 | 216-13-4937 | Ackerman | [NAME] |  | No |  |  | FL | FL | 04 | IR11 | BU3 | Male | N/A
52584 | 321-85-8541 | Acjipt | Left |  | No |  |  | CA | C | 9 | IR12 | BU4 | Male | N/A
35913 | 216-13-4938 | Adkins | [NAME] | T | No |  |  | CA | CA | 05 | IR12 | BU3 | Male | N/A
35914 | 216-13-4939 | Agarwal | Hector |  | No |  |  | GA | GA | 06 | IR13 | BU3SL | Male | N/A
35915 | 216-03-4850 | Agresse | [NAME] |  | No |  |  | CA | CA | 07 | IR14 | BU0 | Male | N/A
35916 | 299-93-4941 | Aguilar | [NAME] |  | No |  |  | CA | CA | 08 | IR15 | BU1 | Male | N/A
35917 | 216-13-4942 | Aguilar | [NAME] |  | No |  |  | CA | CA | 09 | IR16 | [NAME] | Male | N/A
35918 | 216-13-4943 | Ainsworth | [NAME] | R | No |  |  | MA | CT | 10 | IR17 | BU3 | Male | N/A
35919 | 216-13-4944 | Akimseu | Leah | M | No |  |  | HI | HI | 11 | IR18 | BU3 | Male | N/A
35920 | 216-13-4945 | [NAME] | [NAME] |  | No |  |  | PA | PA | 12 | IR19 | BU3 | Male | N/A
35921 | 216-13-4946 | Aleem | [NAME] |  | No |  |  | TX | TX | 13 | IR20 | BU3 | Male | N/A
35922 | 216-13-4947 | Alejo | [NAME] |  | No |  |  | CA | CA | 14 | IR21 | BU1SL | Male | N/A
35923 | 216-13-4948 | Alonzo | [NAME] |  | No |  |  | CA | CA | 15 | IR22 | BU3 | Male | N/A
35924 | 216-13-4949 | Alvarado | Lucky | R | No |  |  | NV | NV | 16 | IR23 | BU3 | Male | N/A
35925 | 216-13-4950 | Ambriz | Franky | A | No |  |  | CA | CA | 17 | IR24 | [NAME] | Male | N/A
35926 | 216-13-4951 | Andalon | BJ | D | No |  |  | CA | CA | 18 | IR25 | [NAME] | Male | N/A
35927 | 216-13-4952 | Andersen | Flip | W | No |  |  | IL | IL | 19 | IR26 | BU3 | Male | N/A
Spreadsheet: 758967d1639194983-if-vlookup-large-combination-if_vlookup_large-test
Sheet: Formulas

 | Sample Location 1 |  |  |  |  |  |  |  |  |  |  | Date Range
 | Quality Characteristic | Unit | 1 |  |  |  |  |  |  |  |  | 2020-01-01 00:00:00 | 2021-10-30 00:00:00
 |  |  | most recent | second most | third… | 4 | 5 | 6 | 7 | 8 |  | Average For Date Range and Location | Value(s) within date range
 | Ammonia as N (mg/L) | mg/L |  | 0.14 | <0.05 | 0.25 | 0.11
 | Aluminium (t) (mg/L) | ug/L |  | 0.27 | 2.24 | 0.35 | 0.09 |  |  |  |  |  | 0.15
 | Carbonate (mg/L) | mg/L |  | 20 | 0.19 | <20 | <20 |  |  |  |  |  | 0.14
 | Bicarbonate (mg/L) | mg/L |  | 708 | <20 | 992 | 768 |  |  |  |  |  | <0.05
 | C | mg/L |  |  |  |  |  |  |  |  |  |  | 0.25
 | Cu (t) | ug/L
 | Chloride (mg/L) | mg/L |  | 742 | 936 | 1130 | 939
 | Iron (t) (mg/L) | mg/L |  | 0.59 | 3.68 | 2 | 0.8
 | Pb (t) | ug/L
 | Mn (s) | mg/L
 | Nitrate + Nitrite | mg/L
 | N (t) | mg/L
 | pH (min) | pH unit
 | pH ([NAME]) | pH unit
 | K | mg/L
 | Na | mg/L
 | Sulphate | mg/L
 | EC | uS/cm
 | TOC | mg/L
 | Zn | mg/L
 | [NAME] | mg/L