tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 484412d1476266195-entity-relationship-diagram-in-excel-relationships
Sheet: Relationships 

Item 1 | Item 2
Driverless cars | Electric Vehicles, e-Bikes/Cars to e-Jets/boats
Driverless cars | Shared car ownership
Driverless cars | The autonomous flying car is set to become a reality
Driverless cars | Changing Auto Insurance Landscape (Random thoughts)
Driverless cars | New Car Tech (ADAS)
Driverless cars | Smart together: humans and machines
Driverless cars | IOT (Internet Of Things)
Post Batteries | Nanotechnology
Nanotechnology | Ultra-Light Materials
Ultra-Light Materials | Changes in Steel manufacturing
Changes in Steel manufacturing | Driverless cars
Driverless cars | Use of [NAME] for commercial & other activities
IOT (Internet Of Things) | Increasing threat of corporate [NAME]
IOT (Internet Of Things) | The future of risks and products for car insurers
Increasing threat of corporate [NAME] | IOT (Internet Of Things)
Connected Cars | IOT (Internet Of Things)
IOT (Internet Of Things) | Advanced, Pervasive, Invisible Analytics
Smart technology will help insurers cut claims | Wearables
Spreadsheet: 79a7348f-3945-48e5-b44a-cbc5383d634a
Sheet: Sheet1

The Homecoming | Unnamed: 1 | Unnamed: 2 | Income | Expenditure | Unnamed: 5 | Unnamed: 6
Society Theatre Company
Venue | Rent |  |  | 258.5 |  | £220 + VAT
 | Rates |  |  | 100 |  | Estimate
Publicity | Posters x 80 |  |  | 60
 | Beer mats x 1000 |  |  | 100
 | Photography |  |  | 40
 | Programmes |  |  | 51
Text | Performance Rights |  |  | 225
 | Script copies |  |  | 15
Props | Cigars |  |  | 15
Set | Paint brush |  |  | 2.99
 | Paint brush |  |  | 3.99
 | Paint brush |  |  | 2.98
 | Paint |  |  | 90 |  | Brown, black, magnolia
 | Wood screws |  |  | 1.78
Make up | Eyeliner |  |  | 6.25
 | Pencil sharpener |  |  | 1.75
 | Hair gel |  |  | 5.98 |  | £2.99 x 2
 | More eyeliner |  |  | 2.69
JCR | Grant from Cuth's JCR |  | 400
Sales | Ticket Sales |  | 700 |  |  | Approximate
 |  | Total | 1100 | 982.9100000000001
 |  | Net | 117.0899999999999
Spreadsheet: 0478c1d9-8971-42cb-9381-88acdb976c25
Sheet: 16 Chapter Leadership

16 | Chapter leadership:  Participate in and/or conduct at least one LLD during the year with qualified instructors using current material.
 |  | Achieve at least 66% of chapter leadership  trained or 3% increase |  |  | [NAME] | 25
 |  | Achieve at least 83% of chapter leadership trained or 3% over 66% |  |  | Silver | 50
 |  | Achieve at least 100% of chapter leadership trained or 3% over 83% |  |  | Gold | 100
 | LLD courses must be conducted at either the lodge or chapter level, with qualified instructors and using current LLD materials (see www.oa-bsa.org), to train chapter officers, committee chairmen and their advisers.  Eligible participants include elected and appointed youth members of the LEC and their advisers.
 | [NAME]
 |  | Number and dates of LLDs conducted during this year with qualified instructors and current material
 |  | 1.
 |  | 2.
 |  | 3.
 |  | 4.
 | Evaluate Success
 |  | What is the number one area of training most needed in the chapter?
 | Plan for Next Year
Spreadsheet: 704873d1605790743-editing-weekly-monthly-assignment-template-project-tracker-test-ans
Sheet: Week View

 | ASSIGNMENTS | MONTH VIEW
 | Select Month: | Enter the Year: | Select Week No.:
 | November |  | Week 4
 | WEEK VIEW
 | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY
Spreadsheet: 48647d1247851723-picking-5-highest-lowest-numbers-from-a-list-john-excel
Sheet: Sheet1

 | Score | Ranked |  |  | Absolute Strengths | Absolute development Areas | Relative Strengths | Relative development areas
1 | 7.2
2 | 7.3
3 | 7.2
4 | 5.7
5 | 5.25
6 | 7
7 | 5.05
8 | 5.06
9 | 5.09
10 | 7.2
11 | 7
12 | 7.285714285714286
13 | 5.33
14 | 6.166666666666667
15 | 6
16 | 5.9
17 | 6.2
18 | 7
19 | 7.1
20 | 7.2
21 | 7.15
22 | 7
23 | 6.8
24 | 5.3
Spreadsheet: 47241d1246224284-formatting-tables-edidet-
Sheet: Sheet1

Table 1
 | 4 | 3 | 2 | 1
1000 | 7.5-7.79 | 7.8-8.09 | 8.1-8.24 | >8.25
1200 | 8.7-8.79 | 8.8-9.14 | 9.15-9.29 | >9.3
Table 2 |  |  |  |  | Table 3
 | 1000 | 1200 |  |  |  | 1000 | 1200
Fast | 7.7 | 9.11 |  |  | Fast
Firm |  |  |  |  | Firm
Good |  | 9.23 |  |  | Good
Yield |  | 8.79 |  |  | Yield
Mud | 8.7 |  |  |  | Mud
Soft | 8.14 | 10.15 |  |  | Soft
What I would like is for when i write in table 2 8.98 in the fast 1200 cell is for table 3 to then change to the colour to correspond with table 1.
Ideally I would like to name the cell. For example when i type in 8.98 in the fast 1200 cell on table 2, i would like on table 3 for it to have both the colour and number, in this instance the cell would be coloured red and have number 3 in it.
Is this possible?
Thanks
G
Spreadsheet: 0141fa75-ecec-43c1-a5f4-3379a58c9451
Sheet: Sheet1

6b, run 1 (healthy) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Redundant |  |  |  | Non-redundant
Total Peptides | 12231 | 1 |  | Total Peptides | 5174 | 1
-10 < PPM < 10 | 10556 | 0.8631 |  | -10 < PPM < 10 | 4322 | 0.8353
PPM ≤ -10 or PPM [NAME] 10 | 1675 | 0.1369 |  | PPM ≤ -10 or PPM [NAME] 10 | 852 | 0.1647
PPM ≤-10 | 307 | 0.0251 |  | PPM ≤-10 | 191 | 0.0369
PPM ≥ 10 | 1368 | 0.1118 |  | PPM ≥ 10 | 661 | 0.1278
Total "forward" peptides | 12187 | 1 |  | Total "forward" peptides | 5140 | 1
-10 < PPM < 10 | 10553 | 0.8659 |  | -10 < PPM < 10 | 4319 | 0.8403
PPM ≤ -10 or PPM [NAME] 10 | 1634 | 0.1341 |  | PPM ≤ -10 or PPM [NAME] 10 | 821 | 0.1597
PPM ≤-10 | 277 | 0.0227 |  | PPM ≤-10 | 169 | 0.0329
PPM ≥ 10 | 1357 | 0.1113 |  | PPM ≥ 10 | 652 | 0.1268
Total "reverse" peptides | 44 | 1 |  | Total "reverse" peptides | 34 | 1
-10 < PPM < 10 | 3 | 0.0682 |  | -10 < PPM < 10 | 3 | 0.0882
PPM ≤ -10 or PPM [NAME] 10 | 41 | 0.9318 |  | PPM ≤ -10 or PPM [NAME] 10 | 31 | 0.9118
PPM ≤-10 | 30 | 0.6818 |  | PPM ≤-10 | 22 | 0.6471
PPM ≥ 10 | 11 | 0.25 |  | PPM ≥ 10 | 9 | 0.2647
[NAME]: | Total: 0.72% | PPM range: 0.05% |  | [NAME]: | Total: 1.31% | PPM range: 0.12%
Spreadsheet: 832838d1686635004-want-to-use-arrays-to-solve-problem-array-help
Sheet: Sheet1

 | [NAME] | 64
 | Results: (Concatenated)
 | Each row /2 | arbitrary | [NAME]
 |  | 1
 |  | 3
 |  | 2
 |  | 4
 |  | 6
 |  | 7
Spreadsheet: 771362d1646644993-multiple-formula-if-and-match-issue-sample-updated
Sheet: Sheet1

PARTICIPANT_NAME | START_DATE | END_DATE |  | PARTICIPANT_NAME | START_DATE | END_DATE
Person 1 | 2021-06-30 00:00:00 | 2022-06-30 00:00:00 |  | Person 1 | 2021-06-30 00:00:00 | 2024-06-30 00:00:00 |  |  |  | Extended
Person 2 | 2021-11-26 00:00:00 | 2022-11-26 00:00:00 |  | Person 2 | 2021-11-26 00:00:00 | 2023-11-26 00:00:00 |  |  |  | Extended
Person 3 | 2021-09-30 00:00:00 | 2022-09-30 00:00:00 |  | Person 3 | 2021-09-30 00:00:00 | 2022-09-30 00:00:00 |  |  |  | No Change
Person 4 | 2021-05-06 00:00:00 | 2022-05-06 00:00:00 |  | Person 4 | 2021-05-06 00:00:00 | 2022-05-06 00:00:00 |  |  |  | No Change
Person 5 | 2020-09-02 00:00:00 | 2022-09-02 00:00:00 |  | Person 5 | 2020-09-02 00:00:00 | 2022-09-02 00:00:00 |  |  |  | No Change
Person 6 | 2021-04-29 00:00:00 | 2022-04-29 00:00:00 |  | Person 6 | 2021-04-29 00:00:00 | 2022-04-29 00:00:00 |  |  |  | No Change
Person 7 | 2020-09-14 00:00:00 | 2021-12-12 00:00:00 |  | Person 7 | 2020-09-14 00:00:00 | 2021-12-12 00:00:00 |  |  |  | No Change
Person 8 | 2021-02-02 00:00:00 | 2023-02-02 00:00:00 |  | Person 8 | 2021-02-02 00:00:00 | 2023-02-02 00:00:00 |  |  |  | No Change
Person 9 | 2021-04-28 00:00:00 | 2022-04-28 00:00:00 |  | Person 9 | 2021-04-28 00:00:00 | 2022-04-28 00:00:00 |  |  |  | No Change
Person 10 | 2021-10-18 00:00:00 | 2022-02-21 00:00:00 |  | Person 10 | 2021-10-18 00:00:00 | 2022-02-21 00:00:00 |  |  |  | No Change
Spreadsheet: 840608d1692862674-an-easy-question-i-guess-regarding-a-table-lookup-test-example
Sheet: Konfigs

 | Probalility level | Kolumn1 | Kolumn2 | Kolumn3
 |  | 0 | 0.099 | Very low
 |  | 0.1 | 0.99 | Low
 |  | 1 | 9.99 | Moderate
 |  | 10 | 99 | High
 |  | 100 |  | Very high
 | Anpassat, se motivering
Spreadsheet: 858071d1706845056-enter-first-date-of-the-year-only-and-will-populate-the-rest-of-the-months-calendar-test
Sheet: Apr

 |  |  | WK No. |  | 14 | 14 | 14 | 14 | 14 | 14 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 17 | 17 | 17 | 17 | 17 | 17 | 17 | 18 | 18
 |  |  | Day |  | 2024-04-02 00:00:00 | 2024-04-03 00:00:00 | 2024-04-04 00:00:00 | 2024-04-05 00:00:00 | 2024-04-06 00:00:00 | 2024-04-07 00:00:00 | 2024-04-08 00:00:00 | 2024-04-09 00:00:00 | 2024-04-10 00:00:00 | 2024-04-11 00:00:00 | 2024-04-12 00:00:00 | 2024-04-13 00:00:00 | 2024-04-14 00:00:00 | 2024-04-15 00:00:00 | 2024-04-16 00:00:00 | 2024-04-17 00:00:00 | 2024-04-18 00:00:00 | 2024-04-19 00:00:00 | 2024-04-20 00:00:00 | 2024-04-21 00:00:00 | 2024-04-22 00:00:00 | 2024-04-23 00:00:00 | 2024-04-24 00:00:00 | 2024-04-25 00:00:00 | 2024-04-26 00:00:00 | 2024-04-27 00:00:00 | 2024-04-28 00:00:00 | 2024-04-29 00:00:00 | 2024-04-30 00:00:00
 |  |  |  |  | 2024-04-02 00:00:00 | 2024-04-03 00:00:00 | 2024-04-04 00:00:00 | 2024-04-05 00:00:00 | 2024-04-06 00:00:00 | 2024-04-07 00:00:00 | 2024-04-08 00:00:00 | 2024-04-09 00:00:00 | 2024-04-10 00:00:00 | 2024-04-11 00:00:00 | 2024-04-12 00:00:00 | 2024-04-13 00:00:00 | 2024-04-14 00:00:00 | 2024-04-15 00:00:00 | 2024-04-16 00:00:00 | 2024-04-17 00:00:00 | 2024-04-18 00:00:00 | 2024-04-19 00:00:00 | 2024-04-20 00:00:00 | 2024-04-21 00:00:00 | 2024-04-22 00:00:00 | 2024-04-23 00:00:00 | 2024-04-24 00:00:00 | 2024-04-25 00:00:00 | 2024-04-26 00:00:00 | 2024-04-27 00:00:00 | 2024-04-28 00:00:00 | 2024-04-29 00:00:00 | 2024-04-30 00:00:00
Spreadsheet: 438146d1451785487-comparing-one-columns-against-two-different-columns-with-either-or-comparing-in-two-columns-either-or
Sheet: Sheet1

Table 1 |  |  |  |  | Table 2 |  |  |  | Desired Result
Email 1 | [NAME] | First Name | Last Name |  | [NAME] | First Name | Last Name |  | Is Email Address from Table 2 in Table 1 (Y/N)?
[EMAIL] | [EMAIL] | [NAME] | Doe |  | [EMAIL] | [NAME] | Blass |  | N
[EMAIL] |  | Tee | Vee |  | [EMAIL] | [NAME] | Doe |  | Y
[EMAIL] | [EMAIL] | Ray | DeeO |  | [EMAIL] | Ray | Deo |  | Y
Spreadsheet: 1f7254dc-a755-442e-8d7b-0f470100affb
Sheet: Sheet1

شماره قرادداد | عنوان طرح | [NAME] (مجریان ) | استادراهنما | ناظر | [NAME] (ریال) | هزینه آزمایش | هزینه پرسنلی | هزینه وسایل | شماره وتاریخ قرارداد | تاریخ تصویب | [NAME] | تاریخ خاتمه | مدت | [NAME] | نوع مطاله | توضیحات
43 | بررسی امواج مایکروویوبافرکانس [NAME] موشهای سوری نربااستفاده ازآزمون اجتنابی غیرفعال | [NAME] یوسف زنجانی -دل آرام ناهید | [NAME] | دکترسیرتی | 5000000 |  | 4090000 | 1400000 | 9076-87/9/3 | 87/4/3 | 87/10/21 | 88/8/1 | یکسال | + | کاربردی
48 | بررسی شیوع وشدت هیپوناترومی دربیماران مبتلابه نارسایی احتقانی قلب بستری [NAME] بوعلی | [NAME] -خانم الهام هادی بیگی -فاطمه واعظی -سارامعماریان | دکترآرش کردی | دکترسیماسیاح | 6000000 |  | 1900000 | 3900000 | 10972-87/11/27 | 87/10/21 | 87/10/21 | 88/10/21 | یکسال | + | کاربردی
53 | ارزیابی میزان باروری کیست های هیداتیدوتعیین ویبیلیتی پروتوکسولون دردامهای کشتارگاه قزوین | دکترشهنازی -آمنه حدادان -آنیاجعفری | مجتبی شهنازی | دکترآقامیریان | 4882500 |  | 1700000 | 1082500 | 11575-87/12/15 | 87/10/21 | 87/10/21 | 88/9/25 | یکسال | + | کاربردی
51 | بررسی اثرضددردی کربونوکسولون درآزمون فرمالین درموش | خانم آمنه حدادان -دکترنصیری اصل-دکترزمان سلطانی | دکترنصیری اصل | دکترغیبی | 4992000 |  | 1050000 | 3942000 | 11851-87/12/22 | 87/10/21 | 87/10/21 | 1388/10/21 | یکسال | + | کاربردی
52 | بررسی اثرکربنوکسولون برفعالیت ضددردی مورفین درآزمون فرمالین درموش | خانم موناحمیدی -دکترنصیری اصل دکترزمان سلطانی | دکترنصیری اصل | دکترغیبی | 3497500 |  | 980000 | 2517500 | 11850-87/12/22 | 87/10/21 | 87/10/21 |  | یکسال | + | کاربردی
54 | بررسی اثرتزریق داخلی صفاتی عصاره [NAME] بابونه matriearia chamomillaبرتشنج ناشی ازنپتیلن تترازول درموش های سوری نر | [NAME] آبادی -علی عبداله | [NAME] آبادی | دکتراسماعیلی | 5957000 |  | 3790000 | 1967000 | 447-88/1/27 | 87/10/21 | 87/10/21 |  | یکسال | + | کاربردی
102 | بررسی اثرات هیستوپاتولوژیک استرس اجتماعی برروی طحال موش سوری نر | دکتررجایی -طیبه هادیگل | دکتررجایی | دکتر حقدوست | 5900000 | 3000000 | 1150000 | 1750000 | 7328-89/1/18 | 88/12/10 | 88/12/15 |  | یکسال | + | کاربردی
101 | ارزیابی هیستوپاتولوژیک میزان [NAME] [NAME] پس ازدرمان به وسیله پسوندسلولهای استئوبلاستی درخرگوش نر | دکترشمس -طیبه هادیگل | دکترشمس | دکتر حقدوست | 6900000 |  | 2900000 | 4000000 | 7328-89/1/18 | 88/12/10 | 88/12/15 |  | یکسال | + | کاربردی
111 | برسی اثرات [NAME] بر کبد موش سوری | دکتر رجایی- آیدا محمدیان | دکتر رجایی | دکتر اژدری | 5300000 |  | 3000000 | 1400000 |  | 89/3/17 | 89/3/17 |  | 6 ماه |  | بنیادی- کاربردی
Spreadsheet: 6f4df3e6-71a3-403c-9ea7-3ef5f9ea0148
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
THYM | Test | THYM | Thyme, IgE | Thyme, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
THYM | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
THYM | Result | THYM | Thyme, IgE | Thyme, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 7737-0
Spreadsheet: 7f06e6b0-7621-4e44-b742-d1b6b1d26194
Sheet: Sheet1

Securities | % of Assets
Enbridge Income Fund Hld | 3.33%
BCE Inc. | 3.15%
Veresen Inc. | 3.00%
Capital Power Corp | 2.95%
Emera Inc. | 2.74%
Potash Corp of Saskatchwn | 2.65%
Fortis Inc. | 2.59%
Thomson Reuters Corp | 2.50%
Rogers Communications Inc | 2.48%
Northland Power Inc | 2.44%
Power Financial Corp. | 2.39%
Bank of Montreal | 2.39%
Crescent Point Energy Crp | 2.35%
Cdn Imperial Bk of Commrc | 2.34%
Inter Pipeline Ltd. | 2.30%
Great-West Life Company | 2.27%
Sun Life Financial Inc. | 2.24%
Power Corporation Canada | 2.24%
Royal Bank of Canada | 2.23%
National Bank of Canada | 2.21%
Transcontinental Inc Cl A | 2.12%
TELUS Corp. | 2.12%
Husky Energy Inc. | 2.12%
IGM Financial Inc. | 2.11%
Freehold Royalties Ltd | 2.09%
Bank of Nova Scotia | 2.01%
[NAME] Cl B Nvs | 1.95%
Toronto-Dominion Bank | 1.95%
Shaw Communicatn Cl B Nvs | 1.95%
Keyera Corp | 1.95%
Cineplex Inc. | 1.90%
Enbridge Inc. | 1.79%
TransCanada Corp. | 1.77%
Brookfield Property Ptner | 1.73%
ARC Resources Ltd | 1.71%
Pembina Pipeline Inc | 1.70%
Genworth MI Canada Inc | 1.64%
Dorel Industries Inc Cl B | 1.51%
Vermilion Energy Inc. | 1.48%
CI Financial Corp | 1.43%
Mullen Group Ltd. | 1.34%
First Capital Realty Inc | 1.30%
Teck Resources Ltd Cl B | 1.25%
Aimia Inc. | 1.10%
Canadian Oil Sands Ltd | 1.08%
Agrium Inc. | 0.91%
Ensign Energy Srvcs Inc | 0.87%
Wajax Corporation | 0.83%
Manulife Financial Corp. | 0.81%
AGF Management Ltd Cl B | 0.71%
Baytex Energy Corp. | 0.57%
Cash | 0.42%
Finning International Inc | 0.36%
Cdn Utilities Cl A NVS | 0.36%
Manitoba Telecom Services | 0.25%
Total Holdings in Portfolio | 55
Spreadsheet: daren_farmer__5946__SMI23reveff061000_2
Sheet: Sheet1

To:   [NAME]          (Enron)
From: [NAME] ([NAME])
Date:  6/09/00
Subject:  Revised Availabilities Effective 6/10/00
Effective Date | CTP NAME | Gross Vol. (MMBtu/d) | PVR % | PVR Volume | Avail. After PVR (MMBtu/d) | DBQ | Excess
2000-06-10 00:00:00 | SMI 23 | 64990 | 0 |  |  | 41553
1st of month DBQ = 41553/d
This change supersedes the previous change made effective for 6/10/00.
The Sea Robin Plant will shut down Monday, June 12, 2000 at 9:00 a.m. for repairs and maintenance.
The plant should be back up on Thursday, June 15, 2000.
Spreadsheet: 685885d1594246138-removing-duplicates-based-on-multiple-values-book1
Sheet: Sheet1

1 | [NAME] | Contact |  |  | 1 | [NAME] | Contact | Donor
1 | [NAME] | Donor |  |  | 2 | [NAME] | Contact | Donor | Staff
2 | [NAME] | Donor |  |  | 3 | [NAME] |  | Donor | Staff
2 | [NAME] | Contact
2 | [NAME] | Staff |  |  |  | I want it to look like this ^^
3 | [NAME] | Staff
3 | [NAME] | Donor
Looks like this ^^
Spreadsheet: 501269d1486670839-date-range-to-return-certain-rows-from-data-stored-on-separate-sheet-of-workbook-example-33-
Sheet: Main Sheet

This will be in white font and will not print>>> |  |  |  |  | Date Range: | 2017-01-01 00:00:00 | 2017-03-01 00:00:00
Company Logo with calendar
 |  |  |  |  | Based on date range I want the rows from next page (highlighted to show here)
 |  |  |  |  | And when I change those dates up there, this front page populateswith different data
 |  |  |  |  | I just copied and pasted, but I want it to be a Vlookup sort of thing based on between G1 and H1, but I just do not know the words to use!!
Spreadsheet: hunter_shively__12668__Nov_01 Volume Changes
Sheet: Nov 7

Pipeline | Producer | Deal | Zone | Current Volume | New Volume | Change | Index | GDA
ANR | Torch | 1060018 | Gath | 0 | 5 |  |  | 5
ANR | Torch | 1059865 | Gath | 1 | 6 |  | 5
ANR | Cosstex | 1131077 | Gath | 3010 | 2720 |  |  | -290
CGFL | Forest | 1109818 | [NAME] | 3856 | 2256 |  | -1600
SNAT | Stone | 1054822 | Uncnstrnd WH | 4697 | 4232 |  | -465
TENN | Panaco | 1135603 | Zone 500 | 5070 | 4800 |  |  | -270
TENN | Forest | 1109820 | Zone 500 | 3542 | 2835 |  | -707
TENN | W&T | 1135864 | Zone 800 | 2900 | 3638 |  | 738
TENN | Progas | 1143677 | Zone 800 | 2203 | 5051 |  |  | 2848
TENN | Westport | 1143232 | Zone 800 | 5670 | 8000 |  |  | 2330
TETCO | Unimark | 1146397 | ELA | 6722 | 4267 |  |  | -2455
TRCO | Energy Res | 1135719 | Z 3 | 7320 | 5850 |  |  | -1470
TRNKL | Forest | 1127986 | ELA | 2512 | 2300 |  |  | -212
 |  |  |  |  |  | Daily Total
 |  |  |  |  |  | MTD Total | -17090 | 6359
Spreadsheet: 737470d1624435182-how-to-extract-data-from-one-worksheet-into-another-excel-forum-workbook
Sheet: Worksheet 1

Worksheet 1
CompanyName | FirstName | Surname | JobTitle | [NAME] | Area | FileName | Verification
McDonalds | [NAME] | Smith | Director | [EMAIL] | North | ExcelWorkbook1
McDonalds | [NAME] | Jones | Director | [EMAIL] | North | ExcelWorkbook2
McDonalds | [NAME] | Greeb | Director | [EMAIL] | North | ExcelWorkbook3
Spreadsheet: 84801d1284862088-if-or-and-too-many-arguments-risk-template-sample
Sheet: Risk Level

 |  |  |  |  | Risk Level Conversion Table
 |  |  |  |  | Level | Likelihood | Impact
 |  |  |  |  | H | 3 - Possible | 5 - Highly Significant
 |  |  |  |  | H | 4 - Likely | 5 - Highly Significant
 |  |  |  |  | H | 5 - Highly Likely | 5 - Highly Significant
 |  |  |  |  | H | 3 - Possible | 4 - Significant
 |  |  |  |  | H | 4 - Likely | 4 - Significant
 |  |  |  |  | H | 5 - Highly Likely | 4 - Significant
 |  |  |  |  | M | 2 - Unlikely | 5 - Highly Significant
 |  |  |  |  | M | 2 - Unlikely | 4 - Significant
 |  |  |  |  | M | 2 - Unlikely | 3 - Moderately Significant
 |  |  |  |  | M | 3 - Possible | 3 - Moderately Significant
 |  |  |  |  | M | 4 - Likely | 3 - Moderately Significant
 |  |  |  |  | M | 5 - Highly Likely | 3 - Moderately Significant
 |  |  |  |  | L | 1 - Very Unlikely | 5 - Highly Significant
 |  |  |  |  | L | 1 - Very Unlikely | 4 - Significant
 |  |  |  |  | L | 1 - Very Unlikely | 3 - Moderately Significant
 |  |  |  |  | L | 1 - Very Unlikely | 2 - Slightly Significant
 |  |  |  |  | L | 1 - Very Unlikely | 1 - Not Significant
 |  |  |  |  | L | 2 - Unlikely | 2 - Slightly Significant
 |  |  |  |  | L | 2 - Unlikely | 1 - Not Significant
 |  |  |  |  | L | 3 - Possible | 2 - Slightly Significant
 |  |  |  |  | L | 3 - Possible | 1 - Not Significant
 |  |  |  |  | L | 4 - Likely | 2 - Slightly Significant
 |  |  |  |  | L | 4 - Likely | 1 - Not Significant
 |  |  |  |  | L | 5 - Highly Likely | 2 - Slightly Significant
 |  |  |  |  | L | 5 - Highly Likely | 1 - Not Significant
Spreadsheet: daren_farmer__5239__BMSPT051
Sheet: BMSPT066

BAMMEL STORAGE ACTIVITY
VOLUME SPLIT BY Counterparties
2001-05-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | SWING CONTRACT VOLUMES |  |  |  |  | ECT LONG/(SHORT) |  |  |  | LONG/(SHORT)
 |  | HPL INDEX |  |  | HPL FIXED PRICE |  |  |  |  | TOTAL | HL&P | CP&L | TUFCO | TOTAL |  | ECT FIRST OF THE MONTH | TUFCO/ HL&P/ CP&L SWING VOLUME | ECT LONG OR (SHORT) |  | ECT TOTAL | HPLC Excluding 3rd Party | Net LONG/ (SHORT)
 |  | MTD Adjustment | CURRENT DAY | Total | MTD Adjustment | CURRENT DAY | Total | 3rd Party | HPLC Total |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  | Reinject Fees
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Injected Volume | Value
Beginning Balance
1 | Scheduled |  |  |  |  |  |  |  |  |  | 0 | 0
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Estimated
 | Estimated
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Index: | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fuel: | 0.01
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fuel Rate:
Ending Balance |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Prod.[NAME]:
Variances:
Total Projected
April 28 thru May 4
May 5 thru May 11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Previous Position: |  | 318590
May 12 thru May 18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]:
May 19 thru May 25