tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: kevin_presto__19986__EAST SUMMARY TOP COUNTERPARTIES ALL REGIONS 2
Sheet: SUMMARY OF POSITIONS DEC 28-31

NET POSITIONS DEC 28 - JAN 7
PEAK | 2001-12-28 00:00:00 | 2001-12-29 00:00:00 | 2001-12-30 00:00:00 | 2001-12-31 00:00:00 |  | 2002-01-01 00:00:00 | 2002-01-02 00:00:00 | 2002-01-03 00:00:00 | 2002-01-04 00:00:00 | 2002-01-05 00:00:00 | 2002-01-06 00:00:00 | 2002-01-07 00:00:00
PJM | -1350 | -300 | -300 | -1350 |  | 50 | 300 | 300 | 300 | 50 | 50 | 300
ENTERGY | -200 | -50 | -50 | -200 |  | 0 | -50 | -50 | -50 | 0 | 0 | -50
CINERGY | -1300 | 0 | 0 | -1300 |  | -100 | -1150 | -1150 | -1150 | -100 | -100 | -1150
COMED | 0 | 0 | 0 | 0 |  | 0 | -100 | -100 | -100 | 0 | 0 | -100
TVA | 150 | 0 | 0 | 150 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
SOCO | -50 | 0 | 0 | -50
NEPOOL | -1111.5 | 25 | 25 | -1111.5 |  | -1115 | -1240 | -1240 | -1240 | -1115 | -1115 | -1240
SIGECO |  |  |  |  |  | -60 | 0 | 0 | 0 | -60 | -60 | 0
OFF-PEAK
PJM | -300 | -300 | -300 | -300 |  | 50 | 50 | 50 | 50 | 50 | 50 | 50
ENTERGY | -50 | -50 | -50 | -50
CINERGY | 50 | 50 | 50 | 50 |  | -100 | -100 | -100 | -100 | -100 | -100 | -100
COMED | 0 | 0 | 0 | 0
TVA | 0 | 0 | 0 | 0
SOCO | 0 | 0 | 0 | 0
NEPOOL | 25 | 25 | 25 | 25 |  | -75 | -75 | -75 | -75 | -75 | -75 | -75
Spreadsheet: 676930d1589078182-index-match-with-3-criteria-example
Sheet: Sheet1

Bank 1
Account | Currency | Amount
Account A | $$
Account B | $$
Account C | Eur
Account D | $$
Account E | Eur
Bank 2
Account | Currency | Amount
Account A | $$
Account B | $$
Account C | Eur
Account D | $$
Account E | Eur
Bank 3
Account | Currency | Amount
Account A | $$
Account B | $$
Account C | Eur
Account D | $$
Account E | Eur
Spreadsheet: scott_neal__38600__MgmtSum-Q2_2001_0518
Sheet: CapChrg

ENRON NORTH AMERICA
2nd QUARTER 2001 CAPITAL CHARGE
 |  | Capital Charge
Business Team |  | Forecast | Plan | [NAME] | Explanation
 |  |  | 0
 |  | 74 | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  | 0 | 0
 |  | 49 | 236
 |  |  | 0
 |  |  | 0
Total East Power
 |  | 963 | 111
 |  | 0 | 0
 |  | 1995 | 4139
 |  |  | 0
 |  |  | 0
 |  |  | 0
Total West Power
West (Allen/Tycholiz) |  |  | 0
Central (Shively/Luce) |  | 370 | 144
East (Neal/Vickers) |  | 209 | 1572
Texas (Martin) |  |  | 0
Financial (Arnold) |  |  | 0
Derivatives (Lagrasta) |  |  | 0
NG Structuring (McMicheal) |  |  | 0
NG Fundamentals (Gaskill) |  |  | 0
Management |  |  | 0 | 0
Total Natural Gas
Natural Gas (McKay/LeDain) |  | 32 | 99
Finance (Kitagawa) |  | 1993 | 304
Alberta Power (Zufferli/Davies) |  |  | 0
Ontario Power (Devries) |  | 0 | 447
Retail (Milnthorp) |  |  | 0
Executive (Milnthorp) |  |  | 0
Total Canada
Upstream Executive (Mrha) |  |  | 0
Compression Services ([NAME]) |  |  | 0
Offshore (Byargeon) |  | -69 | 653
Storage (Bieniawski) |  |  | 0
[NAME] (Grass) |  | 27 | 0
[NAME] (Mrha) |  |  | 0
Bridgeline (Mrha) |  | 7865 | 6282
HPL (Redmond) |  |  | 0
LT Fundamentals/Transport ([NAME]) |  |  | 0
Mexico (Yzaguirre) |  | 4151 | 0
Generation Investments (Duran) |  | 21941 | 15210
Principal Investing ([NAME]) |  | 4663 | 7109
Energy Capital Svcs (Thompson/Josey)
Restructuring (Redmond/Lydecker) |  | 8125 | 13372
[NAME] |  | 8204 | 32888
Cross Commodity (Lavorato) |  |  | 0
Office of the Chairman (Lavorato/Kitchen) |  |  | 0
TVA Settlement |  |  | 0
Overview |  |  | 0
Total Commercial
Other Interest Related |  | 0 | 0
Capital Charge Offset
Americas Capital Charge
Interest Expense/(Income) |  | 0 | 0 | 0
TOTAL
Unallocable Cap Charge |  |  |  | items not identifiable to a specific team- IT P,P&E, build-outs, broker cash, etc.
Original Delainey number
HPL |  |  | 81259
Spreadsheet: andy_zipper__190__Broker detail 5-21-01
Sheet: BROKER DEAL SUMMARY

EnronOnline Broker Detail for 5/21/2001
Completed Transactions:
TODAY
Date | 2001-05-21 00:00:00
 | Data | Commodity
 | DEAL COUNT |  | BROKER SAVING |  | Total DEAL COUNT | Total BROKER SAVING
Broker | Natural Gas | Power | Natural Gas | Power
APB Energy, Inc. |  | 12 |  | 1484.52 | 12 | 1484.52
Natsource LLC |  | 1 |  | 4 | 1 | 4
Amerex Natural Gas I, Ltd. | 14 |  | 1725 |  | 14 | 1725
Amerex Power, Ltd. |  | 1 |  | 368 | 1 | 368
Grand Total | 14 | 14 | 1725 | 1856.52 | 28 | 3581.52
LIFE TO DATE (First Trade March 28, 2001)
 | Data | Commodity
 | DEAL COUNT |  | BROKER SAVING |  | Total DEAL COUNT | Total BROKER SAVING
Broker | Natural Gas | Power | Natural Gas | Power
APB Energy, Inc. | 47 | 127 | 11956.25 | 7960.2 | 174 | 19916.45
Natsource LLC | 28 | 178 | 4207.5 | 16416 | 206 | 20623.5
Power Merchants Group, LLC | 8 |  | 634.83 |  | 8 | 634.83
Amerex Natural Gas I, Ltd. | 26 | 1 | 4313.75 | 4 | 27 | 4317.75
Amerex Power, Ltd. |  | 3 |  | 392 | 3 | 392
Grand Total | 109 | 309 | 21112.33 | 24772.2 | 418 | 45884.53
Failed Transactions:
TODAY
Date | 2001-05-21 00:00:00
FAILED TRANSACTION COUNT | Commodity
Broker | Natural Gas | Power | Grand Total
APB Energy, Inc. |  | 1 | 1
Amerex Natural Gas I, Ltd. | 1 |  | 1
Grand Total | 1 | 1 | 2
LIFE TO DATE (First Trade March 28, 2001)
FAILED TRANSACTION COUNT | Commodity
Broker | Natural Gas | Power | Grand Total
APB Energy, Inc. | 20 | 22 | 42
Natsource LLC | 4 | 31 | 35
Power Merchants Group, LLC | 17 |  | 17
Amerex Natural Gas I, Ltd. | 4 |  | 4
Amerex Power, Ltd. |  | 1 | 1
Grand Total | 45 | 54 | 99
Spreadsheet: 800303d1665587081-splitting-cells-and-rearranging-data-bookadd
Sheet: required-format

Sr. No | Company | Contact Person | Designation | Cellphone |  | Mail ID | Contact Address
1 | A | Mr. R - |  | 123456789
2 | B | Mr. [NAME] |  | 123456789 |  |  | City,State,Zip
 | B | Mr. [NAME] P | (Engineer) | 123456789
3 | C | Mr. [NAME] T - |  | 123456789 |  | email id 1for person 1 | Address 1 :City,State,Zip
 | C | Mr. [NAME] T |  | 123456789 |  | email id 2 for person 2 | Address 2 :City,State,Zip
Spreadsheet: 869605d1716215900-troubleshoot-my-lambda-for-multi-cell-ranges-sample-lambda-help
Sheet: Sheet1

value x | value y | value z |  | spill range returned incorrectly | expected result,  but want it to be one array returned |  |  |  |  |  |  | formula
3.5 | 4.99 | 32 |  |  |  |  |  |  |  |  |  | value | result
8.16 | 4.99 | -20 |  | 0 |  |  |  |  |  |  |  | x: 0 - 4 | 4
6.72 | 0 | 89 |  | 0 |  |  |  |  |  |  |  | x: >4 - 6 | 1
7.2 | 4.97 | 2 |  | 0 |  |  |  |  |  |  |  | x: 6 - 8, with y > 0 and z < 100 | 4
8.28 | 4.99 | 200 |  | 0 |  |  |  |  |  |  |  | x: >6 | 0
8.57 | 4.95 | 157 |  | 0
6.78 | 10.2 | 42 |  | 0
6.73 | 4.97 | 50 |  | 0
4.35 | 4.98 | 345 |  | #N/A
8.94 | 4.99 | 212 |  | 0
Spreadsheet: gstorey__12026__Feb01
Sheet: table2

NATURAL GAS EXPORTS BY TERM, REGION, AND CUSTOMER TYPE |  |  |  |  |  |  |  |  |  |  |  | TABLE 2
EXPORTATIONS DE GAZ NATUREL PAR TERME, RÉGION, ET CLIENT
 |  |  |  | AVERAGE PRICE |  |  |  |  |  | AVERAGE PRICE
 | VOLUME |  |  | PRIX MOYEN |  |  | VOLUME |  |  | PRIX MOYEN
 | (MILLIONS M3) |  |  | ($CDN/GJ) |  |  | (MILLIONS M3) |  |  | ($CDN/GJ)
 |  |  | % CHANGE |  |  | % CHANGE |  |  | % CHANGE |  |  | % CHANGE
 |  |  | VARIATION |  |  | VARIATION | 1999-11-01 00:00:00 | 2000-11-01 00:00:00 | VARIATION | 1999-11-01 00:00:00 | 2000-11-01 00:00:00 | VARIATION
 | 2000-02-01 00:00:00 | 2001-02-01 00:00:00 | EN % | 2000-02-01 00:00:00 | 2001-02-01 00:00:00 | EN % | 2000-02-01 00:00:00 | 2001-02-01 00:00:00 | EN % | 2000-02-01 00:00:00 | 2001-02-01 00:00:00 | EN %
TERM/TERME
LONG-TERM (FIRM)/LONG TERME (GARANTI) | 2247.4 | 1668.4 | -25.8 | 3.59 | 7.87 | 119.3 | 9028.4 | 7506.9 | -16.9 | 3.56 | 8.21 | 130.4
SHORT-TERM (FIRM)/COURT TERME (GARANTI) | 4060.5 | 4075.9 | 0.4 | 3.28 | 8.91 | 171.7 | 15540.6 | 18164.6 | 16.9 | 3.3 | 9.92 | 200.7
SHORT-TERM/COURT TERME (INTERRUPTIBLE) | 1951.9 | 2768.9 | 41.9 | 3.49 | 9.66 | 177.1 | 9273.4 | 13049.9 | 40.7 | 3.38 | 10.61 | 213.9
TOTAL - TERM/TERME | 8259.7 | 8513.2 | 3.1 | 3.41 | 8.95 | 162.4 | 33842.3 | 38721.4 | 14.4 | 3.39 | 9.82 | 189.6
REGION/RÉGION
CALIFORNIA/CALIFORNIE | 1620.8 | 1316.9 | -18.7 | 3.06 | 10.82 | 253.7 | 7021.7 | 6159.8 | -12.3 | 3.22 | 10.41 | 223.4
MIDWEST/MIDWEST | 2980.3 | 3050.4 | 2.4 | 3.25 | 8.57 | 163.5 | 12414.3 | 14389.3 | 15.9 | 3.22 | 9.33 | 189.5
MOUNTAIN/ROCHEUSES | 121.9 | 26.1 | -78.6 | 3.12 | 5.45 | 74.9 | 346.3 | 151.3 | -56.3 | 3.06 | 6.68 | 118.4
NORTHEAST/NORD-EST | 2353.7 | 2760 | 17.3 | 4.01 | 8.65 | 115.7 | 9081.5 | 12645.4 | 39.2 | 3.86 | 9.45 | 144.5
PACIFIC NORTHWEST/NORD-OUEST PACIFIQUE | 1183 | 1359.8 | 14.9 | 3.15 | 8.67 | 175.7 | 4978.5 | 5375.7 | 8 | 3.23 | 11.44 | 254.5
TOTAL - REGION/RÉGION | 8259.7 | 8513.2 | 3.1 | 3.41 | 8.95 | 162.4 | 33842.3 | 38721.4 | 14.4 | 3.39 | 9.82 | 189.6
CUSTOMER TYPE/CLIENT
END-USER/UTILISATEURS ULTIMES | 698.7 | 627.8 | -10.4 | 3.76 | 6.68 | 77.8 | 2686.7 | 2349.8 | -12.5 | 3.78 | 6.97 | 84.5
LDC/SDL | 2202.2 | 1848.4 | -16.1 | 3.44 | 8.67 | 151.9 | 8884.7 | 8368 | -5.8 | 3.46 | 9.31 | 169.1
MARKETING CO./DISTRIBUTEURS | 5063.4 | 5748.6 | 13.5 | 3.39 | 9.34 | 175.8 | 21040.2 | 26403.1 | 25.5 | 3.33 | 10.38 | 211.3
PIPELINE/PIPELINES | 295.4 | 288.5 | -67.3 | 2.81 | 7.43 | 163.8 | 1230.7 | 1407.1 | 14.3 | 3.05 | 7.5 | 145.5
TOTAL - CUSTOMER TYPE/CLIENT | 8259.7 | 8513.2 | 3.1 | 3.41 | 8.95 | 162.35 | 33842.3 | 38721.4 | 14.4 | 3.39 | 9.82 | 189.6
 | PRICE AT THE INTERNATIONAL BORDER |  |  |  |  |  |  | À LA FRONTIÈRE INTERNATIONALE
Spreadsheet: 717608d1612771315-modified-countif-function-to-count-one-occurance-from-each-row-adjusted-countif-function
Sheet: Sheet1

[NAME] | Org 1 | Org 2 | Org 3 | Org 4 | Org 5
 | [Seadawy, [NAME], Dept Math, [NAME], [NAME], Saudi Arabia
 | [Ahmed, Muhammad Adeel; Jouhar, Rizwan] King Faisal Univ, Coll Dent, Dept Restorat Dent & Endodont, [NAME], Saudi Arabia | [Zafar, [NAME]] Taibah Univ, Coll Dent, Dept Restorat Dent, [NAME], Saudi Arabia | [[NAME], [NAME] King Faisal Univ, Coll Dent, Dept Prosthodont & Dent Implantol, [NAME], Saudi Arabia
 | [[NAME], Imran] Taibah Univ, [NAME], Dept Chem, Al Medina Al Munawara 41477, Saudi Arabia | [Alharbi, [NAME], [NAME], Dept Biol, [NAME], Saudi Arabia
 | [Ewees, [NAME], Dept ESyst, [NAME], Saudi Arabia
 | [[NAME], [NAME]; Jleli, [NAME]; Samet, Bessem] King Saud Univ, [NAME], Dept Math, Riyadh, Saudi Arabia
 | [Alyami, Hussain] Taif Univ, [NAME], At Taif, Saudi Arabia
 | [[NAME], Ming-Hui; [NAME], Lain-Jong] King Abdullah Univ Sci & Technol, Phys Sci & Engn Div, Thuwal, Saudi Arabia
 | [Bousahla, Abdelmoumen Anis; [NAME], Fouad; Tounsi, Abdeldjebbar; Bedia, [NAME]; Benrahou, [NAME]; Tounsi, Abdelouahed] King Fahd Univ Petr & Minerals, Dept Civil & Environm Engn, Dhahran 31261, Eastern Provinc, Saudi Arabia | [[NAME], [NAME], Jeddah Community Coll, GRC Dept, Jeddah, Saudi Arabia
 | [Alhabib, [NAME], [NAME], King Fahad Cardiac Ctr, Dept Cardiac Sci, Riyadh, Saudi Arabia | [Al-Muhsen, [NAME]] King Saud Univ, King Saud Univ Med City, Riyadh, Saudi Arabia
 | [Dang, Shuping; [NAME], [NAME]; Shihada, Basem; [NAME], [NAME]] KAUST, Comp Elect & Math Sci & Engn Div, Thuwal, Saudi Arabia
 | [[NAME], [NAME]] King Saud Univ, Sustainable Energy Technol SET Ctr, Coll Engn, POB 800, Riyadh 11421, Saudi Arabia
 | [[NAME], [NAME] King Abdulaziz Univ, Chem Dept, [NAME], POB 80203, Jeddah 21589, Saudi Arabia | [[NAME], [NAME] King Abdulaziz Univ, Ctr Excellence Adv [NAME], POB 80203, Jeddah 21589, Saudi Arabia
 | [[NAME], [NAME] King Abdulaziz Univ, [NAME], Chem Dept, POB 80203, Jeddah 21589, Saudi Arabia | [[NAME], [NAME] King Abdulaziz Univ, Ctr Excellence Adv [NAME], POB 80203, Jeddah 21589, Saudi Arabia
 | [[NAME], [NAME]; Alsohime, Fahad; Hasanato, Rana] King Saud Univ, [NAME], Dept Pathol & Lab Med, Riyadh, Saudi Arabia | [[NAME], Haya; Almourfi, [NAME], Natl Ctr Genom Technol, Riyadh, Saudi Arabia | [Al-Muhsen, [NAME]] King Saud Univ, [NAME], Dept Pediat, Immunol Res Lab, Riyadh, Saudi Arabia | [Al Turki, Saeed] Misery Natl Guard Hlth Affairs, King Abdulaziz Med City, Dept Pathol & Lab Med, [NAME], Riyadh, Saudi Arabia | [Al Turki, Saeed] King Abdullah Int Med Res Ctr, Canc & Blood Res, Riyadh, Saudi Arabia
 | [[NAME], Xiaopeng; [NAME], [NAME]; [NAME], [NAME]; [NAME], [NAME]; Troughton, Joel; Gasparini, Nicola; [NAME], Yuanbao; Alsalloum, [NAME]; Maity, [NAME]; Turedi, [NAME]; [NAME], [NAME]; [NAME], Derya; [NAME], [NAME]; Han, [NAME]; [NAME], [NAME]; [NAME], [NAME], [NAME], Thuwal, Saudi Arabia | [Hedhili, [NAME]] KAUST, Imaging & Characterizat Core Lab, Thuwal, Saudi Arabia
Spreadsheet: 833108d1686792547-search-box-issues-contract-template_sample
Sheet: Contract Main

 | Today's Date
Contract Status
Active
About to Expire
Expired
 | [NAME] | [NAME] | Vendor Phone No. | Contract Number | Line Item | Type of Service/Product | Valid Date | [NAME] | Status            (Days Remaining) | Contract Value | Delivery Timeframe | Unit cost
1 | ABC |  | 4164439555 | CRO 47020597 | 10 | Mobile Radio - Truck mounted | 2022-03-01 00:00:00 | 2024-02-28 00:00:00 |  | 374273.65 | EA | 961.07
2 | ABC |  | 4164439555 | CRO 47020597 | 20 | Portable Radio - Handheld | 2022-03-01 00:00:00 | 2024-02-28 00:00:00 |  | 374274.65 | EA | 961.07
3 | ABC |  | 4164439555 | CRO 47020597 | 30 | Base Station - Office | 2022-03-01 00:00:00 | 2024-02-28 00:00:00 |  | 374275.65 | EA | 1296.68
6 | DEF |  | 4167987675 | DPO 3612341 |  | 5OZ Cone Cup (1000) |  |  |  |  | Auto Delivery | 22
7 | GHI |  | 9057910612 | CRO 47021960 | 10 | SW [NAME] | 2019-01-07 00:00:00 | 2023-12-31 00:00:00 |  | 214406.44 | EA | 50
8 | GHI |  | 9057910612 | CRO 47021960 | 20 | SW TDO Commissioners TS | 2019-01-07 00:00:00 | 2023-12-31 00:00:00 |  | 214406.44 | EA | 50
30 | GHI |  | 9057910612 | CRO 47021960 | 290 | Pt 1-Tbl G Bed bug service | 2019-01-07 00:00:00 | 2023-12-31 00:00:00 |  | 214406.44 | EA | 60
31 | GHI |  | 9057910612 | CRO 47021960 | 300 | Pt 2-Tbl A Type A Emergency svc 7am-5pm | 2019-01-07 00:00:00 | 2023-12-31 00:00:00 |  | 214406.44 | EA | 25
32 | GHI |  | 9057910612 | CRO 47021960 | 310 | Pt 2-Tbl A Type A Emergency svc a/h M-F | 2019-01-07 00:00:00 | 2023-12-31 00:00:00 |  | 214406.44 | EA | 25
33 | JKL |  | 416774811 | CRO | 60 | Optional purging service | 2018-07-03 00:00:00 | 2023-07-02 00:00:00 |  | 3960.76 | EA | 52.80136874999999
34 | JKL |  | 416774811 | CRO | 70 | Optional temporary bins | 2018-07-03 00:00:00 | 2023-07-02 00:00:00 |  | 3960.76 | EA | 49.27044644999999
Spreadsheet: 57572d1257784184-excel-2007-visual-representation-of-rota-copy-of-4-week-rota-v2
Sheet: drop down lists

off
07:30:00 | 1
08:00:00 | 2
08:30:00 | 3
09:00:00 | 4
 | 5
09:30:00 | 6
10:00:00
12:00:00
13:00:00
13:30:00
14:00:00
14:30:00
15:00:00
15:30:00
16:00:00
16:30:00
17:00:00
17:30:00
18:00:00
21:00:00
21:30:00
22:00:00
22:30:00
23:00:00
Spreadsheet: 0ec5a9ff-70b4-47ed-8cd7-5cdfca57ceb7
Sheet: Sheet1

A.  Research Personnel | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Coordinator Clinical Procedures | Frequency | Time Involved |  | Notes
Initial Screening |  |  |  | # of Sites:
Review Inclusion/Exclusion Criteria
Review Informed Consent |  |  |  | # of Subjects:
Screening/Enrollment Logs
Patient Randomization |  |  |  | # of Subjects Locally:
Medical/Surgical History/Demographics
Non Serious Adverse Events |  |  |  | # of Screen Failures:
Serious Adverse Events
[NAME] |  |  |  | Enrollment Period:
[NAME] Visits
Vital Signs |  |  |  | Budget Open:
Study Drug |  |  |  | PI Effort:
Study Drug  Administration
Study Drug Accountability |  |  |  | Competing Trials:
Study Drug Compliance
 |  |  |  | Initial or Add-on Site:
Study Device
Pre Procedure Set Up |  |  |  | Advertising/Recruit:
Device Accountability
Device Application |  |  |  | Addt'l Comments:
Device Operation Parameters
Device Removal/Explant Procedure
In-patient Assessments (List)
Out-patient Assessments &/or Questionnaires (List)
Patient Education
Physicians Orders - Initial
Physicians Orders - Subsequent
Patient Communication
Staff Education/Communication
Scheduling Patient Visits/Procedures
Source Documentation - Create
CRF Completion - Initial Visit
CRF Completion - Subsequent Visit(s)
Queries
 | Frequency | Time Involved
Regulatory Work (over course of trial)
IND Safety Reports
Amendments
Annual Progress Reports
Conference Calls
Monitor Visits
# of Visits anticipated during course of trial
Time spent with monitor for each visit
*If any lab or hosptial procedure requires submission to a central lab and/or core imaging lab, please provide manual at the first meeting.
B.  Research Procedures
Will any Investigational Pharmacy be Used for This Study?      Yes   No
Dispension Frequency   _____
[NAME]Yes/No | Total Frequency | # Standard of Care | # Research Only |  | Processing Lab *
(* - Refers to [NAME], Special Hematology, Core Endo, Reference, etc)
Central Labs         Yes/No | Total Frequency | Processing Lab *
Lab Collection
Lab Processing - Basic
Lab Processing - Complex
Freeze/Hold
Lab Shipping - Ambient
Lab Shipping - Frozen
 | Total Frequency | # Standard of Care | # Research Only |  | Core Lab (Yes/No)
Hospital Procedures    Yes/No
Miscellaneous
Total Subject Compensation
Study Supplies (List any supplies that are not being provided by the Sponsor or Pharmacy)
Spreadsheet: 858161d1706897262-dynamic-formula-to-calculate-value-based-on-multiple-criteria-book4-1-
Sheet: After Data

 |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
Product Code | Total |  |  | Total  Town Qty | TOWN 1 | TOWN 2 | TOWN 3 | TOWN 4 |  |  |  | TOTAL
A1010 |  |  |  | 33
A1010 |  |  |  | 98
A1010 |  |  |  | 41
A1010 |  |  |  | 570
A1010 |  |  |  | 0
A1010 |  |  |  | 214
A1010 |  |  |  | 36
A1010 | Total |  |  |  | 400 | 262 | 180 | 150
A1030 |  |  |  | 25
A1030 |  |  |  | 75
A1030 | Total |  |  |  | 40 | 20 | 10 | 30
A1035 |  |  |  | 15
A1035 |  |  |  | 0
A1035 |  |  |  | 30
A1035 | Total |  |  |  | 20 | 10 | 5 | 10
B1150 |  |  |  | 30
B1150 |  |  |  | 20
B1150 |  |  |  | 0
B1150 |  |  |  | 45
B1150 |  |  |  | 65
B1150 | Total |  |  |  | 50 | 60 | 20 | 30
Spreadsheet: 794274d1661960164-finding-a-value-from-multiple-tables-on-the-same-sheet-example-sheet
Sheet: Sheet1

Example sheet
2022-08-31 00:00:00
AL |  |  |  |  | AK |  |  |  |  | AZ |  |  |  |  | AR |  |  |  |  | CA |  |  |  |  | CO
 | First | Second | Average |  |  | First | Second | Average |  |  | First | Second | Average |  |  | First | Second | Average |  |  | First | Second | Average |  |  | First | Second | Average
2021 | 1 | 2 |  |  | 2021 | 3 | 4 |  |  | 2021 | 2 | 3 |  |  | 2021 | 4 | 5 |  |  | 2021 | 1 | 2 |  |  | 2021 | 1 | 2
2022 | 2 | 3 |  |  | 2022 | 4 | 5 |  |  | 2022 | 3 | 4 |  |  | 2022 | 5 | 6 |  |  | 2022 | 2 | 3 |  |  | 2022 | 2 | 3
2023 | 3 | 4 |  |  | 2023 | 5 | 6 |  |  | 2023 | 4 | 5 |  |  | 2023 | 6 | 7 |  |  | 2023 | 3 | 4 |  |  | 2023 | 3 | 4
2024 | 4 | 5 |  |  | 2024 | 6 | 7 |  |  | 2024 | 5 | 6 |  |  | 2024 | 7 | 8 |  |  | 2024 | 4 | 5 |  |  | 2024 | 4 | 5
2025 | 5 | 6 |  |  | 2025 | 7 | 8 |  |  | 2025 | 6 | 7 |  |  | 2025 | 8 | 9 |  |  | 2025 | 5 | 6 |  |  | 2025 | 5 | 6
CT |  |  |  |  | DE |  |  |  |  | FL |  |  |  |  |  |  |  |  |  | GA |  |  |  |  | 2026 | 6 | 7
 | First | Second | Average |  |  | First | Second | Average |  |  | First | Second | Average |  |  |  |  |  |  |  | First | Second | Average |  | 2027 | 7 | 8
2022 | 1 | 2 |  |  | 2021 | 3 | 4 |  |  | 2021 | 4 | 5 |  |  |  |  |  |  |  | 2021 | 1 | 2
2023 | 2 | 3 |  |  | 2022 | 4 | 5 |  |  | 2022 | 5 | 6 |  |  |  |  |  |  |  | 2022 | 2 | 3
2024 | 3 | 4 |  |  | 2023 | 5 | 6 |  |  | 2023 | 6 | 7 |  |  |  |  |  |  |  | 2023 | 3 | 4
2025 | 4 | 5 |  |  | 2024 | 6 | 7 |  |  | 2024 | 7 | 8 |  |  |  |  |  |  |  | 2024 | 4 | 5
2026 | 5 | 6 |  |  | 2025 | 7 | 8 |  |  | 2025 | 8 | 9 |  |  |  |  |  |  |  | 2025 | 5 | 6
2027 | 6 | 7 |  |  | 2026 | 8 | 9
HI |  |  |  |  | ID |  |  |  |  | IL |  |  |  |  | IN |  |  |  |  | IO |  |  |  |  | KA
 | First | Second | Average |  |  | First | Second | Average |  |  | First | Second | Average |  |  | First | Second | Average |  |  | First | Second | Average |  |  | First | Second | Average
2020 | 1 | 2 |  |  | 2021 | 5 | 6 |  |  | 2021 | 1 | 2 |  |  | 2021 | 3 | 4 |  |  | 2020 | 2 | 3 |  |  | 2018 | 1 | 2
2021 | 2 | 3 |  |  | 2022 | 6 | 7 |  |  | 2022 | 2 | 3 |  |  | 2022 | 4 | 5 |  |  | 2021 | 3 | 4 |  |  | 2019 | 2 | 3
2022 | 3 | 4 |  |  | 2023 | 7 | 8 |  |  | 2023 | 3 | 4 |  |  | 2023 | 5 | 6 |  |  | 2022 | 4 | 5 |  |  | 2020 | 3 | 4
2023 | 4 | 5 |  |  | 2024 | 8 | 9 |  |  | 2024 | 4 | 5 |  |  | 2024 | 6 | 7 |  |  | 2023 | 5 | 6 |  |  | 2021 | 4 | 5
2024 | 5 | 6 |  |  | 2025 | 9 | 10 |  |  | 2025 | 5 | 6 |  |  | 2025 | 7 | 8 |  |  | 2024 | 6 | 7 |  |  | 2022 | 5 | 6
2025 | 6 | 7 |  |  | 2026 | 10 | 11 |  |  | 2026 | 6 | 7 |  |  | 2026 | 8 | 9 |  |  |  |  |  |  |  | 2023 | 6 | 7
2026 | 7 | 8 |  |  | 2027 | 11 | 12 |  |  | 2027 | 7 | 8 |  |  | 2027 | 9 | 10
2027 | 8 | 9
Spreadsheet: 128641d1321142746-v-look-up-help-invoice-v10
Sheet: Master

KingFisher Tackle
Customer: | Mr [NAME]
Ref No.: AC101KFT
Contact No. [PHONE]
No | Description |  |  | Item Cost | Total Cost |  |  |  |  |  |  |  | 0
0 |  |  |  | 0 | 0 |  |  |  |  |  | 50 | 1 Pint Fresly Turned Caster | 2
0 |  |  |  | 0 | 0 |  |  |  |  |  | 100 | 1/2 Pint Red Maggots | 0.6
0 |  |  |  | 0 | 0 |  |  |  |  |  | 20 | 1KG Worms | 15
0 |  |  |  | 0 | 0 |  |  |  |  |  | 25 | 6mm Miracle Baits Snowball Pellets | 3
0 |  |  |  | 0 | 0 |  |  |  |  |  |  | Bag of KingFisherTackle 4mm Feed Pellet | 2.5
0 |  |  |  | 0 | 0 |  |  |  |  |  |  | Discorger | 0.5
0 |  |  |  | 0 | 0 |  |  |  |  |  |  | [NAME] | 3
0 |  |  |  | 0 | 0 |  |  |  |  |  | 200 | KingFisher Tackle £20 [NAME] Used | -20
0 |  |  |  | 0 | 0 |  |  |  |  |  | 2 | Maver Mxi Series 5 Attachments | 50
0 |  |  |  | 0 | 0 |  |  |  |  |  | 1 | Maver Mxi Series 5 SeatBox | 350
0 |  |  |  | 0 | 0 |  |  |  |  |  | 5 | Maver Umbrellas | 20
0 |  |  |  | 0 | 0 |  |  |  |  |  | 2 | [NAME] and Keep Net Pack | 30
0 |  |  |  | 0 | 0 |  |  |  |  |  | 15 | Miracle Paste 500g | 2.5
0 |  |  |  | 0 | 0 |  |  |  |  |  | 10 | [NAME] 16 Barbed Hooks Xtra Strong | 2
 |  |  |  | Total Excluding VAT | 0
 |  |  |  | VAT Rate | 0.2
 |  |  |  | Discount | £0.00
 |  |  |  | Discounted Total Excluding VAT | 0
 |  |  |  | Discounted Total VAT | 0
 |  |  |  | Total To Pay | 0
KingFisher Tackle
1 House Lakes, [NAME], Lincs, PE21TZ6
44[PHONE]
Hope To See You Soon!
Come To Us For Your Fishing Needs!
Spreadsheet: 765627d1643437023-solved-only-sum-when-there-are-2-values-if-not-return-a-blank-cell-sum-only-if-both-cells-have-values
Sheet: Sheet1

 |  |  |  | Longterm
 |  |  | Avg. Flow | Average | Sum
 |  | January | 5.227307692307691 | 5.148628667347801
 |  | February | 6 | 5.156141948158543
 |  | March |  | 6.155418586789521 |  |  |  | Want these cells blank if both cells D & E are not values
 |  | April |  | 8.317627450980362
 |  | May |  | 7.50914231499048
 |  | June |  | 6.917847058823496
Spreadsheet: james_steffes__12953__MTM Orig Summary 101801
Sheet: Europe

 |  |  |  |  |  |  |  |  | EES Europe
 |  |  |  |  |  |  |  |  | 4Q/2001 MTM Origination Summary
 |  |  |  |  |  | Origination |  |  |  |  |  |  |  | Risk Management
Deals | Silo | State | Region | Type | Channel | Commodity Type | TCV | Sales Orig. O-K | Credit Reserve | NETA / Renewables Provision | Consumption Premium | Net Orig. Value O-K               (MTM @ Offer) |  | Hedge Mngmt | Valuation Prudencies | NET RM |  | Total Value
($000's US$) |  |  |  |  |  |  |  |  |  |  |  |  |  | M-O |  | RM |  | (MTM)
Middle Market (Crossley Cooke)
Enron Direct |  |  |  |  |  | Power |  |  |  |  | 0 |  |  | 0 | 0
Enron Direct |  |  |  |  |  | Gas | 0 |  | 0 | 0 | 0
Enron Directo |  |  |  |  |  | Power | 0 |  | 0 | 0 | 0
Enron Direct, Netherlands |  |  |  |  |  | Power | 0 |  | 0 | 0 | 0 |  |  | 0 | 0
Energy Portfolio Mgmt (Rexrode)
 |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0
TOTAL Europe Q3
1Q 2001 |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 | 0 |  | 2597.022
2Q 2001
3Q 2001 |  |  |  |  |  |  | 276436.6016636559 | -2387.21209459337 | -205.3868815718753 | 5355.159002165246 | 0
4Q 2001
YTD 2001
New Closed Deals not on DPR** |  |  | TCV* | Sales Orig. O-K (Net of Consumption Premium) | Credit Reserve | Implementation Premium | Consumption Premium | Net Orig. Value O-K (MTM @ offer)
 |  |  |  | 0 |  | 0
Total New Deals: