tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 835718d1688747821-if-between-this-value-range-then-this-or-these-overlapping-then-results-system-calculations
Sheet: CALCULATIONS

CALCULATIONS
Calculated [NAME] (L/hr) | System
377 | Resolute Flowdrive SU, Resolute FlowDrive MU 50
 | Resolute Flowdrive SU, Resolute FlowDrive MU 50
 | Resolute FlowDrive MU 100
 | Resolute FlowDrive MU 100
 | Resolute FlowDrive MU 300
 | Resolute Flowdrive SU, Resolute FlowDrive MU 50
 | Resolute Flowdrive SU, Resolute FlowDrive MU 50
 | Resolute FlowDrive MU 100
 | Resolute FlowDrive MU100
 | Resolute FlowDrive MU 300
 | Resolute Flowdrive SU, Resolute FlowDrive MU 25
 | Resolute Flowdrive SU, Resolute FlowDrive MU 50
 | Resolute Flowdrive SU, Resolute FlowDrive MU 50
 | Resolute Flowdrive SU, Resolute FlowDrive MU 50/100
 | Resolute FlowDrive MU 50/100
 | Resolute FlowDrive MU 100
 | Resolute Flowdrive SU, Resolute FlowDrive MU 25
 | Resolute Flowdrive SU, Resolute FlowDrive MU 50
 | Resolute Flowdrive SU, Resolute FlowDrive MU 50
 | Resolute Flowdrive SU, Resolute FlowDrive MU 50/100
 | Resolute FlowDrive MU 50/100
 | Resolute FlowDrive MU 100
Spreadsheet: 36866d1234841307-extract-data-from-column-to-new-spreadsheet-sample
Sheet: Sheet1 (3)

 | Item | Description | Due Date | Date | Remark | Date | Remark | Date | Remark | Date | Remark
 | 132001 | FABRICATION SCHEDULE (DETAILED WORK TIME SCHEDULE / MANUFACTURING PROGREES PLAN / PRODUCTION SCHEDULE) | 2008-10-23 00:00:00
 | 132002 | GENERAL ARRANGEMENT DRAWING | 2008-10-23 00:00:00 | 2009-02-10 00:00:00 | Submitted | 2009-02-19 00:00:00 | Rejected
 | 132003 | EQUIPMENT LIST | 2008-11-28 00:00:00
 | 132004 | PROJECT QUALITY PLAN INCLUDING INSPECTION AND TEST PLAN (ITP) | 2008-11-28 00:00:00
 | 132005 | INSTRUMENT LIST WITH BILL OF MATERIAL (BUYER'S FORMAT 'S4I') | 2008-12-18 00:00:00 | 2009-02-05 00:00:00 | Submitted
 | 132006 | LIST OF ALARMS AND TRIPS WITH SET POINTS | 2008-12-18 00:00:00
 | 132007 | INSTRUMENT CABLE SCHEDULE | 2008-12-18 00:00:00 | 2009-02-07 00:00:00 | Submitted | 2009-02-15 00:00:00 | Revised
 | 132008 | DATA SHEET FOR EACH INSTRUMENT | 2008-12-18 00:00:00
 | 132009 | ARRANGEMENT AND LAYOUT DRAWINGS FOR JUNCTION BOX | 2008-12-31 00:00:00
Spreadsheet: john_zufferli__16822__Can PWR Stack & Website for New Version 122001
Sheet: Can PWR - Website

WEBSITE ACCESS |  |  |  |  | Read
CAN PWR |  |  |  |  | Execute
 |  |  |  |  | None
Name | User ID | Position | Book Name Website Log In  OR READ ONLY WEBSITE | Tenor  (1-120 Months) | CAN Power Fin Swap (1916)
Cooper Richey | CRICHEY | Assoc-Power Trader | Alberta Gas/US West Power/Alberta Power | 24 | Execute
[NAME] | JZUFFER | VP-Canada Trading | Alberta Gas/BC Gas/Nymex Gas/US West Power/Alberta Power/Currency | [NAME] | Execute
Spreadsheet: 191193d1351963083-copy-paste-cells-containing-formulas-w-o-the-destination-cells-in-formulas-changing-example
Sheet: Sheet1

Item | Price | Sold | Profit | Sold | Profit
Sandwich | 3.99 | 4 |  | 4 |  |  | What I don't want
Salad | 4.99 | 6 |  | 6
Item | Price | Sold | Profit | Sold | Profit
Sandwich | 3.99 | 4 |  | 4 |  |  | What I DO want :D
Salad | 4.99 | 6 |  | 6
Spreadsheet: 824520d1680639420-lookup-with-multiple-conditions-and-and-or-person-2-fruit
Sheet: Sheet1

 | Name | Item | ID |  | ID | Client | Item 1 | Item 2 | Composite 1 | Composite 2
 | [NAME] | [NAME] |  |  | 1 | [NAME] | Pear | Apple
 | [NAME] | [NAME] |  |  | 2 | [NAME] | Apple | [NAME]
 | [NAME] | Pear |  |  | 3 | [NAME] | [NAME]
 | [NAME] | [NAME] |  |  | 4 | [NAME] | Pear | Apple
 | [NAME] | Pineapple |  |  | 5 | [NAME] | [NAME]
 | [NAME] | Peach |  |  | 6 | [NAME] | Kumquat | Pineapple
Spreadsheet: 76189d1276722847-breaking-up-data-across-multiple-worksheets-np-transactions_5-29-10_1test
Sheet: FREEMAJ2

68670533 | TO | 0 | 175
00B12061 | PR | 348153 | 2310
00B12061 | PR | 348155 | 25410
00BTL450 | PR | 348155 | 25410
00C00004 | TO | 0 | 2000
00B12061 | PR | 348153 | 43890
33070806 | PR | 348309 | 315000
00C00004 | TO | 0 | 214
68670605 | TO | 0 | 692
00B12061 | PR | 348153 | 2310
00B12061 | PR | 348153 | 2310
00BTL450 | TO | 0 | 2310
Spreadsheet: 816656d1675767419-perform-calculations-from-text-strings-book1
Sheet: Sheet1

1st addend/minuend | Operator | 2nd addend/subtrahend | RESULT
10 | ADD | 95
95 | ADD | 58
31 | ADD | 99
60 | ADD | 94
18 | ADD | 16
58 | ADD | 18
44 | ADD | 19
87 | ADD | 73
96 | ADD | 15
52 | ADD | 91
18 | ADD | 29
3 | ADD | 1
37 | ADD | 97
89 | ADD | 81
26 | ADD | 69
20 | SUBTRACT | 65
44 | SUBTRACT | 65
71 | SUBTRACT | 77
13 | SUBTRACT | 44
82 | SUBTRACT | 20
4 | SUBTRACT | 98
39 | SUBTRACT | 59
68 | SUBTRACT | 71
85 | SUBTRACT | 81
61 | SUBTRACT | 18
18 | SUBTRACT | 95
12 | SUBTRACT | 68
2 | SUBTRACT | 33
58 | SUBTRACT | 80
80 | SUBTRACT | 71
Spreadsheet: 821786d1678897607-methods-to-find-unique-id-and-list-shared-users-with-each-id-s666-pq-methods-to-find-unique-id-and-list-shared-users-with-each-id
Sheet: Sheet3

 |  | New User |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
User | Old UNITIDs | CNU | GMU | JMU | LU | NSU | ODU | RU | UMW | UVA | UVAW | VCU | VMI | VSU | VT | WM | RBC | new users
CNU | 4 |  |  |  |  | 4 |  |  |  |  |  |  | 2
GMU
JMU | 1 | 1 |  |  | 1 |  |  |  | 1 |  |  |  |  | 1
LU | 2 |  |  |  |  | 2 |  | 1 |  |  |  |  | 1
NSU
ODU
RU
UMW | 2 | 2 |  |  |  |  |  |  |  |  |  |  | 1
UVA
UVAW
VCU
VMI
VSU | 1 |  |  |  |  | 1 |  | 1
VT
WM
RBC
 | Count of UNITID | ListNew
 | [NAME] | CNU | LU | NSU | RU | UMW | VMI | VSU | GMU | UVA | VT | WM | VCU | ODU | JMU | Grand Total
 | CNU |  | 2 | 6 | 2 | 3 | 1 | 1 |  |  |  |  |  |  |  | 15
 | JMU | 1 | 1 | 1 | 4 | 1 |  | 1 |  |  |  | 3 |  | 4 |  | 16
 | LU | 2 |  | 6 | 2 | 4 | 1 | 4 |  |  |  |  |  |  |  | 19
 | UMW | 11 |  |  |  |  | 12 |  |  |  |  |  |  |  |  | 23
 | VSU | 1 |  | 5 | 4 | 2 | 1 |  |  |  |  |  |  | 1 |  | 14
 | UVAW | 2 | 3 | 2 |  | 5 |  | 2 |  |  |  |  |  |  |  | 14
 | NSU |  | 2 |  | 3 |  |  | 1 |  |  |  |  |  |  |  | 6
 | VMI | 2 |  |  |  |  |  | 1 |  |  |  |  |  |  |  | 3
 | ODU |  |  |  |  |  |  |  | 3 | 2 | 3 | 3 | 1 |  |  | 12
 | WM |  |  |  |  |  |  |  | 3 | 4 | 3 |  | 3 |  |  | 13
 | RU |  |  | 4 |  |  |  | 2 |  |  |  |  |  | 1 | 2 | 9
 | GMU |  |  |  |  |  |  |  |  |  |  | 2 | 1 | 1 |  | 4
 | UVA |  |  |  |  |  |  |  |  |  |  | 3 |  |  |  | 3
Spreadsheet: 49697d1249027457-have-symbols-register-as-a-numerical-value-vlookup-demo
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  | Total
 |  | Mr A | a |  | a | a | a |  | a |  | b | a | 53
 |  | Mr B | b | c | b | b | a |  | b |  | b |  | 37
 |  | Mr C | c |  |  | c |  |  | c | c | c | d | 26
 |  | Mr D |  | d |  |  | d |  | d |  | d |  | 24
 |  | a | 8
 |  | b | 5
 |  | c | 4
 |  | d | 6
Spreadsheet: 25345d1216636805-how-do-i-populate-multiple-cells-based-on-a-list-combobox-copy-of-sample
Sheet: IIS Sample

 |  |  | Select:
 |  | Plan | [NAME] |  | HMO X | [NAME] | Value Plus | US Access 8 | US Access2 | HMO XX
 | Calendar Year Ded | HMO | 0 |  | 0 | 0 | 0 | N/A | 1500 | N/A
 |  | PPO | N/A |  | 0 | N/A | N/A | $3000/9000 | 1500 | N/A
 | Policy [NAME] | HMO | Unlimited |  | Unlimited | Unlimited | Unlimited | Unlimited | Unlimited | Unlimited
 |  | PPO | N/A |  | N/A | N/A | N/A | 1Million | 1Million | N/A
 | Co-Insurance | HMO | N/A |  | N/A | N/A | N/A | N/A | N/A | N/A
 |  | PPO | N/A |  | N/A | N/A | N/A | 80/20 | 70/30 | N/A
 | Out of Area Co-Ins. | HMO | N/A |  | N/A | N/A | N/A | N/A | N/A | N/A
 |  | PPO | N/A |  | N/A | N/A | N/A | 70 / 30 | 70/30 | N/A
 | Office Visit Co-Pay | HMO | 10 |  | 10 | 10 | 10 | 10 | 10 | 20
 |  | PPO | N/A |  | N/A | N/A | N/A | 25 | 25 | N/A
 | Specialist Co-Pay | HMO | 15 |  | 10 | 15 | 15 | 10 | 10 | 20
 |  | PPO | N/A |  | N/A | N/A | N/A | 25 | 25 | N/A
 | X-rays | HMO | 15 |  | 10 | 15 | 15 | 10 | 10 | 20
 |  | PPO | N/A |  | N/A | N/A | N/A | 25 | 25 | N/A
 | Laboratory | HMO | 15 |  | 10 | 15 | 15 | 10 | 10 | 20
 |  | PPO | N/A |  | N/A | N/A | N/A | 25 | 25 | N/A
 | Prescription Co-Pay | HMO | 1209 |  | 5000 | 1209 | $10/20/35 | $10/20/35 | $10/20/35 | $10/20/35
 |  | PPO | N/A |  | N/A | N/A | N/A | N/A | N/A | N/A
 | Outpatient Surgery | HMO | None |  | 50 | None | 100 | 100 | None | 250
 |  | PPO | N/A |  | N/A | N/A | N/A | 80/20 | 250 | N/A
 | Hospital Co-Pay/Ded | HMO | None |  | $50.00/d-$250/m | None | 240 | 240 | None | $250/d
Spreadsheet: 776315d1649684109-divide-a-sheet-evenly-into-3-4-sheets-ptls
Sheet: Sheet5

 | 2019-05-02 00:00:00
187468816 | 2019-05-04 00:00:00
121656013 | 2019-05-06 00:00:00
157643928 | 2019-05-08 00:00:00
176565963 | 2019-05-10 00:00:00
164792999 | 2019-05-12 00:00:00
178132224 | 2019-05-14 00:00:00
116909534 | 2019-05-16 00:00:00
177313372 | 2019-05-18 00:00:00
120943015 | 2019-05-20 00:00:00
144288180 | 2019-05-22 00:00:00
187814357 | 2019-05-24 00:00:00
169708905 | 2019-05-26 00:00:00
133464597 | 2019-05-28 00:00:00
147119694 | 2019-05-30 00:00:00
Spreadsheet: 9e12236c-4e92-43b8-b8d9-52b91229f067
Sheet: ENGL 483

COURSE ASSESSMENT MATRIX
Engl 483 Advanced Composition II Prerequisite: Engl 223. This course guides students toward more sophisticated and broad research strategies with stylistic choices that are more varied and creative. By incorporating critical reading skills, this course instructs students to use reading to negotiate the ideas of others, form their own opinions, and enlarge each student’s repertoires of rhetorical strategies. This course will prepare students to communicate effectively, ethically, responsibly, professionally, and will provide students with skills, strategies, and conceptual knowledge to help them address a variety of communication tasks. 3 credits
Goal:  The goal of this course is to guide students toward more sophisticated and broad research strategies with stylistic choices that are more varied and creative.
Objective | Assessment Method | Desired Result | Corrective Action
Research, analyze and process reports in professional fields across the curriculum. | Weekly Assignments                                                          Class Participation  Writing projects scored with Rubric | Weekly Assignments Completed                                       80% students pass writing assignments | [NAME]Revise Weekly Assignments                      Revise Rubrics
Date | Form of Assessment and Actions Taken
Spring 2011 | Syllabus Reviewed --Mainly looked to see that all sections on checklist were present.  Scheduled to review content during the Fall 2011 semester.
Date | Form of Assessment and Actions Taken
Date | Form of Assessment and Actions Taken
Date | Form of Assessment and Actions Taken
Date | Form of Assessment and Actions Taken
Spreadsheet: chris_germany__1980__Ponderosa Pine Est Imbalance0502
Sheet: Sheet1

Ponderosa Pine Energy Cleburne Plant
TXU Lone Star Pipeline
May, 2002
Estimated Usages*
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
RECEIVED | 34517 | 34650 | 34650 | 34650 | 34650 | 34650 | 34650 | 44550 | 44550 | 44550
DELIVERED | 46582.503 | 38779 | 39407 | 40571 | 43385 | 38488 | 38749 | 42525 | 39764 | 42788
DAILY IMBALANCE
MONTHLY IMBALANCE
ACCUM IMBALANCE
 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
RECEIVED | 39600 | 39600 | 39600 | 34650 | 34650 | 34650 | 34649 | 34649 | 34649 | 34641
DELIVERED | 41388 | 35996 | 37133 | 40162 | 43913 | 46196 | 36484 | 39302 | 40432 | 40174
DAILY IMBALANCE
MONTHLY IMBALANCE
ACCUM IMBALANCE
 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
RECEIVED | 38106 | 39600 | 34650 | 34650 | 34650 | 34650 | 34650 | 0 | 0 | 0 | 0
DELIVERED | 37713 | 39366 | 33362 | 35231 | 39016 | 40101 | 32496 | 0 | 0 | 0 | 0
DAILY IMBALANCE
MONTHLY IMBALANCE
ACCUM IMBALANCE
*These numbers are based on estimates and are subject to change
Spreadsheet: 90299d1290045511-replace-names-in-one-column-under-certain-conditions-examplen
Sheet: Sheet1

AVERNA,[NAME]
Corn,Marlin
[NAME],ROBERT H
CATANESE,SALVATORE J & OLGA M
JIMENEZ,ALEJANDRO & HILDA M
Corn,Marlin
Hernara,Harry & Marie Anne Martin
White,Alex & John M
[NAME],[NAME]
[NAME]Harry & Marie Anne
[NAME],Harry & Marie Anne
HernaraMartin,Harry & Marie Anne
MartinHernara,Harry & Marie Anne
Martin,Harry & Marie Anne Hernara
CORNWALL,A ROBERT & CORNWALL,ANNA
HernaraMartin,Harry & Marie Anne & Ann Sally
HernaraMartin,Harry & Marie  & Ann Sally
HernaraMartin,Harry & Cortes,[NAME]
HernaraMartin,Harry & Smith,Marie Anne & Jenners,[NAME]
[NAME]
HernaraMartin,Harry & Marie,Anne & Ann Sally
KNUD J & MARIA L HOSTRUP
RAFIK RAYES & HODA TABAR
PRIMEAU,I & PRIMEAU,JANETTE
BAIN ED & HELEN
Spreadsheet: 768109d1644843939-calculate-new-prices-based-on-year-on-year-inflation-like-compound-interest-price-increase-calculator
Sheet: Sheet1

 |  |  |  |  |  | CUSTOMER | START PRICE | START YEAR | NEW PRICE |  | Answer Should be | I need the 'NEW PRICE' column to show prices that have increased from the 'START PRICE' by inflation, year-on-year, based on the yearly inflation rates in this table, but only taking into account the inflation rates from the 'START YEAR' and beyond. |  |  |  | INFLATION RATES
 |  |  |  |  |  | Mr. [NAME] | 15 | 2018 | ??? | << | 10.77 |  |  |  |  | YEAR | INFLATION
 |  |  |  |  |  | Mrs. [NAME] | 22 | 2019 | ??? | << | 23.12 |  |  |  |  | 2018 | 0.025
 |  |  |  |  |  | Mr. [NAME] | 18 | 2020 | ??? | << | 18.58 |  |  |  |  | 2019 | 0.018
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020 | 0.009
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021 | 0.023
 |  |  |  |  | Example: | CUSTOMER | START PRICE | START PRICE YEAR | NEW PRICE |  |  | Both these tables will be added to, with more data, and the 'New Price' column needs to update accordingly.
 |  |  |  |  |  | Mr. [NAME] | 10 | 2018 | 10.77
 |  |  |  |  |  | Inflation from 2018
 |  |  |  |  |  |  |  | (£10 * 2.5%)
 |  |  |  |  |  | Inflation from 2019
 |  |  |  |  |  |  |  | (£10.25 * 1.8%)
 |  |  |  |  |  | Inflation from 2020
 |  |  |  |  |  |  |  | (£10.43 * 0.9%)
 |  |  |  |  |  | Inflation from 2021
 |  |  |  |  |  | NEW PRICE |  | (£10.53 * 2.3%)
 |  |  |  |  |  |  | ^^^^^^^
 |  |  |  |  |  |  | I want this price to show in the 'NEW PRICE' column
Spreadsheet: 117749d1312999581-countif-based-on-certain-criteria-copy-of-dummy-data
Sheet: Sheet2

[NAME] | Loan Account No. | Sanction Value | Status
2011-08-01 00:00:00 | 123456789 | 500000 | Sanctioned
2011-08-01 00:00:00 | 98789 | 5000000 | Hold
2011-08-01 00:00:00 | 897978 | 100000 | Hold
2011-08-01 00:00:00 | 145646456 | 1000000 | Sanctioned
2011-08-01 00:00:00 | 321321312 | 20000 | Sanctioned
2011-08-01 00:00:00 | 131312 | 2500000 | Sanctioned
2011-08-02 00:00:00 | 131321321 | 3700000 | Sanctioned
2011-08-02 00:00:00 | 23132132132 | 1000000 | Sanctioned
2011-08-02 00:00:00 | 2313214 | 1000000 | Hold
2011-08-02 00:00:00 | 8749789 | 1000000 | Sanctioned
2011-08-02 00:00:00 | 87978954 | 2500000 | Sanctioned
2011-08-02 00:00:00 | 545648973 | 2500000 | Hold
2011-08-02 00:00:00 | 584674987 | 2500000 | Hold
2011-08-02 00:00:00 | 5456467 | 2500000 | Sanctioned
2011-08-02 00:00:00 | 568798796 | 1000000 | Sanctioned
2011-08-02 00:00:00 | 15467498798 | 3700000 | Sanctioned
2011-08-03 00:00:00 | 5649645646 | 3700000 | Sanctioned
2011-08-03 00:00:00 | 8979879 | 2500000 | Sanctioned
2011-08-03 00:00:00 | 45645466 | 1000000 | Hold
2011-08-03 00:00:00 | 674986464 | 1000000 | Sanctioned
2011-08-03 00:00:00 | 54564654 | 2500000 | Sanctioned
2011-08-03 00:00:00 | 446465 | 1000000 | Sanctioned
2011-08-04 00:00:00 | 5646456 | 1000000 | Hold
Spreadsheet: gerald_nemec__11497__Lumberton Soil Results
Sheet: Sheet1

DRAFT
TABLE 1
SOIL SAMPLING RESULTS
COGENTRIX - LUMBERTON, NORTH CAROLINA
Parameter | Units | Concentration
 |  | Background Soil Levels | LOWS-1-1 (2.5'-3.0') | LOWS-2-1 (2.5'-3.0') | LOWS-3-1 (2.5'-3.0') | LOWS-4-1 (2.5'-3.0') | LAS-1-1 (1.5') | LAS-1-2 (4.5') | LAS-2-1 (1.5') | LAS-2-2 (4.5') | LAS-3-1 (1.5') | LAS-3-2 (4.5') | LAS-4-1 (1.5') | LAS-4-2 (4.5') | LAS-5 (ash) | LD-1-1 (3.0') | LD-2 (2.5')
Arsenic | mg/kg | 1- 18 | NA | NA | NA | NA | 1.1 | 2 | 0.89 | 0.69 | 0.92 | <0.5 | 0.85 | 1.2 | 75 | NA | NA
Cadmium | mg/kg | ND - 4 | NA | NA | NA | NA | <0.099 | <0.088 | <0.086 | <0.085 | <0.11 | <0.1 | <0.087 | <0.087 | <0.19 | NA | NA
Chromium | mg/kg | 7 - 300 | NA | NA | NA | NA | 0.83 | 4.1 | 2 | 2 | 3.6 | 2 | 2.2 | 2.9 | 21 | NA | NA
Copper | mg/kg | 3 - 100 | NA | NA | NA | NA | 0.41 | 1.8 | 0.82 | 0.72 | 2 | 0.8 | 0.83 | 1.1 | 160 | NA | NA
Iron | mg/kg | 100 - 100,000 | NA | NA | NA | NA | 490 | 4200 | 1500 | 1300 | 780 | 1100 | 1700 | 2200 | 10000 | NA | NA
Lead | mg/kg | ND - 50 | NA | NA | NA | NA | 0.94 | 2.5 | 1.5 | 1.4 | 3.1 | 1.7 | 1.9 | 2.2 | 90 | NA | NA
Nickel | mg/kg | ND- 150 | NA | NA | NA | NA | <0.5 | 0.82 | 0.44 | <0.42 | 0.91 | <0.5 | 0.54 | 0.69 | 39 | NA | NA
Selenium | mg/kg | 0.1 - 0.8 | NA | NA | NA | NA | <0.5 | 0.65 | <0.43 | <0.42 | <0.55 | <0.5 | <0.43 | <0.43 | 30 | NA | NA
Zinc | mg/kg | 25 - 124 | NA | NA | NA | NA | 5.2 | 2.3 | 1.3 | 3.6 | 1.9 | 1.1 | 3.3 | 4 | 440 | NA | NA
Mercury | mg/kg | 0.03 - 0.52 | NA | NA | NA | NA | <0.0034 | 0.0066 | <0.0037 | 0.0081 | 0.0053 | 0.0085 | 0.0073 | 0.0085 | 0.23 | NA | NA
PCB-1016 | ug/kg | na | <36 | <35 | <35 | <35 | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA
PCB-1221 | ug/kg | na | <36 | <35 | <35 | <35 | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA
PCB-1232 | ug/kg | na | <36 | <35 | <35 | <35 | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA
PCB-1242 | ug/kg | na | <36 | <35 | <35 | <35 | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA
PCB-1248 | ug/kg | na | <36 | <35 | <35 | <35 | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA
PCB-1254 | ug/kg | na | <36 | <35 | <35 | <35 | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA
PCB-1260 | ug/kg | na | <36 | <35 | <35 | <35 | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA
TPH-Diesel | mg/kg | na | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | <5.3 | 6.2
Oil & Grease | mg/kg | na | 531 | 329 | 325 | 234 | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA
Oil & Grease (silica gel) | mg/kg | na | 188 | 206 | 198 | 205 | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA
Background Soil Levels from "Elements in North American Soils" (Dragun, 1991), ranges for North Carolina and Eastern USA.
na - Not Applicable |  |  |  |  | TPH = Total Petroleum Hydrocarbons
NA = Not Analyzed |  |  |  |  | PCB = Polychlorinated biphenyls
ND = Not Detected |  |  |  |  | LOWS = Lumberton Oil/Water Separator
mg/kg = milligrams per kilogram |  |  |  |  | LD = [NAME]
 |  |  |  |  | LAS = [NAME]
Spreadsheet: 27db53e9-01b7-4184-bcff-adccbecaa534
Sheet: Sheet1

Table 5--USDA-calculated world market rice prices (rough basis) 1/ | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13
 | 2011/12 |  |  | 2010/11 |  |  | 2009/10
 |  | Medium/ |  |  | Medium/ |  |  | Medium/
Month | Long | short |  | Long | short |  | Long | short
 | $/cwt
August | 14.08 | 14.4 |  | 9.58 | 9.68 |  | 11.33 | 11.42
September | 15.09 | 15.44 |  | 10.51 | 10.62 |  | 11.25 | 11.35
October | 15.63 | 15.99 |  | 12.15 | 12.29 |  | 11.02 | 11.11
November | 14.93 | 15.28 |  | 13.4 | 13.58 |  | 11.4 | 11.5
December | 13.9 | 14.21 |  | 14.5 | 14.67 |  | 13.03 | 13.15
January 2/ | 12.77 | 13.05 |  | 13.98 | 14.15 |  | 13.03 | 13.14
February |  |  |  | 12.68 | 13.35 |  | 12.74 | 12.99
March |  |  |  | 12.13 | 12.76 |  | 11.21 | 11.42
April |  |  |  | 11.76 | 12.36 |  | 10.53 | 10.72
May |  |  |  | 11.58 | 12.17 |  | 9.92 | 10.1
June |  |  |  | 11.78 | 12.39 |  | 9.41 | 9.57
July |  |  |  | 12.49 | 13.14 |  | 9.42 | 9.58
Market-year
average 1/ | 14.4 | 14.72833333333333 |  | 12.21166666666667 | 12.59666666666666 |  | 11.19083333333333 | 11.3375
1/ Simple average of the U.S. Department of Agriculture's weekly adjusted world market price.  2/  Preliminary.
Source: [NAME] and Rice Weekly Prices (ftp://ftp.fsa.usda.gov/public/cotton/default.htm), Farm Service Agency, USDA.
Last updated January 12, 2012.
Spreadsheet: 796826d1663586269-adding-a-further-criterion-to-an-existing-formula-in-order-to-create-a-tiebreak-ramsey
Sheet: playlist

 | Our next Event of the 2022 season is……. |  |  |  |  |  |  | PLAYER INDEX
 | on Friday 30th September |  |  |  |  |  |  |  |  |  | 00:06:00
 | Cambridgeshire, Last Chance & Masters at Ramsey |  |  |  |  | [NAME] | 09:30:00
 | Nearest the pins: | in 1 =     13th | in 2 =   4th | in 3 = 10th | Glory Hole = 7th | Captains Bottle = 2nd | Longest drive = 15th | 1 |  | 31
 |  | Tee-Time | Player |  | Exact Handicap | Playing Handicap | To Pay | 2 |  | 32 |  | Tee-Time |  | H'Cap | To Pay
5 |  |  |  |  |  |  | PAID | 3 |  | 33
25 | GROUP |  |  |  |  |  | 43 | 4 |  | 34
30 | 1 | 10:30:00 |  |  |  |  | PAID | 5 |  | 35
 |  |  |  |  |  |  |  | 6 |  | 36
3 |  |  |  |  |  |  | PAID | 7 |  | 37
19 | GROUP |  |  |  |  |  | PAID | 8 |  | 38
23 | 2 |  |  |  |  |  | PAID | 9 |  | 39
 |  |  |  |  |  |  |  | 10 |  | 40
8 |  |  |  |  |  |  | PAID | 11 |  | 41
37 | GROUP |  |  |  |  |  | PAID | 12 |  | 42
64 | 3 |  |  |  |  |  | 43 | 13 |  | 43
 |  |  |  |  |  |  |  | 14 |  | 44
17 |  |  |  |  |  |  | PAID | 15 |  | 45
18 | GROUP |  |  |  |  |  | PAID | 16 |  | 46
35 | 4 |  |  |  |  |  | PAID | 17 |  | 47
 |  |  |  |  |  |  |  | 18 |  | 48
24 |  |  |  |  |  |  | PAID | 19 |  | 49
43 | GROUP |  |  |  |  |  | PAID | 20 |  | 50
61 | 5 |  |  |  |  |  | 13 | 21 |  | 51
 |  |  |  |  |  |  |  | 22 |  | 52
15 |  |  |  |  |  |  | PAID | 23 |  | 53
27 | GROUP |  |  |  |  |  | 43 | 24 |  | 54
28 | 6 |  |  |  |  |  | PAID | 25 |  | 55
 |  |  |  |  |  |  |  | 26 |  | 56
26 |  |  |  |  |  |  | PAID | 27 |  | 57
36 | GROUP |  |  |  |  |  | 33 | 28 |  | 58
60 | 7 |  |  |  |  |  | PAID | 29 |  | 59
45 |  |  |  |  |  |  | PAID | 30 |  | 60
10 |  |  |  |  |  |  | PAID |  |  | 61
12 | GROUP |  |  |  |  |  | PAID |  |  | 62
22 | 8 |  |  |  |  |  | PAID |  |  | 63
29 |  |  |  |  |  |  | PAID |  |  | 64
 |  |  |  |  |  |  |  |  |  | 65
 | GROUP
 | 9
 | GROUP
 | 10
Spreadsheet: 218844d1362592746-lookup-index-match-array-help-accommodation
Sheet: Sheet1

 | Hotel A |  |  | Hotel B |  |  | Hotel C
 | 1 | 2 | 3 | 1 | 2 | 3 | 1 | 2 | 3
2013-01-01 00:00:00
2013-01-02 00:00:00
2013-01-03 00:00:00
2013-01-04 00:00:00
2013-01-05 00:00:00
2013-01-06 00:00:00
2013-01-07 00:00:00
2013-01-08 00:00:00
2013-01-09 00:00:00
2013-01-10 00:00:00
2013-01-11 00:00:00
2013-01-12 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | Date | Guest | Hotel | Room
2013-01-13 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2013-01-01 00:00:00 | Grant | Hotel A | 2
2013-01-14 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2013-01-02 00:00:00 | [NAME] | Hotel B | 3
2013-01-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2013-01-03 00:00:00 | [NAME] | Hotel C | 1
2013-01-16 00:00:00
2013-01-17 00:00:00
Spreadsheet: 110852d1307447302-need-help-with-price-calculator-with-exceptions-copy-of-prisberegner
Sheet: Prisberegneren

Input weight and dimensions |  |  |  | Choose your destination
Weight (kg) | Height | Length | Broad | Destination | Volume (m3) | Vol. [NAME] | Chargeable | Price
500 | 120 | 80 | 50 | Storbritannien EU
Spreadsheet: 814730d1674568363-multiple-data-validation-in-cells-a-b-compatability-ans
Sheet: Sheet1

Qty | Part
 | A V1 |  | A is not compatable with B at all regardless of version |  |  |  |  |  | =SUMPRODUCT((LEFT($B$2:$B$5,1)<>LEFT($B2,1))*$A$2:$A$5)=0
1 | B V1
 | A V2
 | B V2
Examples
Qty | Part |  |  | Qty | Part |  |  | Qty | Part |  |  | Qty | Part
1 | A v1 | Valid |  |  | A v1 | Valid |  |  | A v1 | Valid |  |  | A v1 | Valid
 | B v1 |  |  | 1 | B v1 |  |  |  | B v1 |  |  | 1 | B v1
1 | A v2 |  |  |  | A v2 |  |  | 1 | A v2 |  |  |  | A v2
 | B v2 |  |  |  | B v2 |  |  |  | B v2 |  |  | 1 | B v2
Qty | Part |  |  | Qty | Part |  |  | Qty | Part |  |  | Qty | Part
 | A v1 | Not Valid |  |  | A v1 | Not Valid |  |  | A v1 | Not Valid |  |  | A v1 | Not Valid
 | B v1 |  |  |  | B v1 |  |  | 1 | B v1 |  |  | 1 | B v1
2 | A v2 |  |  | 1 | A v2 |  |  | 1 | A v2 |  |  |  | A v2
 | B v2 |  |  | 1 | B v2 |  |  |  | B v2 |  |  | 2 | B v2