tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 86919d1286873899-pivot-sorting-issue-pivot-sorting-issue
Sheet: Pivot

Count of IKG
IKG | [NAME] | Naam | Total
B32 | 294051 | EagleBurgmann Belgium B.V.B.A. | 7
 | 291720 | KSB BELGIUM S.A. | 4
 | 275164 | RUHRPUMPEN GMBH | 3
 | 84346 | Klaus Union GmbH & Co. [NAME] | 2
 | 370715 | ALLWEILER PUMPS B.V. | 2
 | 245315 | Weir Minerals Germany GmbH | 1
 | 117343 | RICHTER CHEMIE-TECHNIK GMBH | 1
 | 294654 | AXFLOW N.V. | 1
 | 292847 | STERLING FLUID SYSTEMS | 1
 | 541413 | [NAME] | 1
B32 Total |  |  | 23
B28 | 292484 | RITTAL  N.V. | 4
 | 293166 | Van Loock Motoren BVBA | 3
 | 1000 | BASF SE | 2
 | 292470 | REXEL BELGIUM SA | 2
 | 291413 | SIEMENS SA | 2
 | 249188 | [NAME] | 1
 | 291745 | L. Vandenberghe N.V. | 1
 | 291221 | HARTING N.V. | 1
 | 292520 | RS Components | 1
B28 Total |  |  | 17
B35 | 248915 | Witzenmann GmbH | 13
 | 293445 | ERIKS N.V. | 2
 | 1804759 | MACHINING CONSTRUCTIONS | 1
B35 Total |  |  | 16
B37 | 212829 | VANAS N.V. | 5
 | 292456 | REPRO B.V.B.A. | 2
 | 563034 | 2 SIGN & SAFE NV | 1
 | 292227 | OVERTOOM INTERNATIONAL | 1
 | 293361 | FEBETRA | 1
 | 294312 | GALLER N.V. | 1
B37 Total |  |  | 11
B38 | 292562 | SAMSON N.V. | 8
 | 349138 | SCHUF VALVE TECHNOLOGY GMBH | 1
 | 331107 | CETI Valves en Services B.V. | 1
B38 Total |  |  | 10
B27 | 774536 | CONDITION MONITORING SYSTEMS BVBA | 4
 | 1000 | BASF SE | 3
B27 Total |  |  | 7
B34 | 293531 | ECOTECHNIC | 3
 | 309643 | SEPAC-FLACOVER N.V. | 1
 | 1000 | BASF SE | 1
B34 Total |  |  | 5
B36 | 294146 | Rajapack Benelux N.V. | 1
 | 291938 | INTERSAFE GROENEVELD BELGIUM N.V. | 1
 | 292227 | OVERTOOM INTERNATIONAL | 1
 | 292548 | Z-Safety & Services nv | 1
B36 Total |  |  | 4
B40 | 302879 | NEUHAUS NEOTEC | 2
 | 302940 | Protempo B.V. | 1
B40 Total |  |  | 3
B26 | 64432 | HONEYWELL SA / NV | 2
 | 294367 | INVENSYS SYSTEMS N.V. | 1
B26 Total |  |  | 3
B29 | 153862 | INDUSTRONIC | 2
 | 294095 | BLACK BOX NETWORK PRODUCTS NV | 1
B29 Total |  |  | 3
B31 | 180527 | BRAUNSCHWEIGER | 1
B31 Total |  |  | 1
B33 | 291489 | INTRAMET NOORD N.V. | 1
B33 Total |  |  | 1
B30 | 291413 | SIEMENS SA | 1
B30 Total |  |  | 1
Grand Total |  |  | 105
Spreadsheet: harry_arora__12147__Enron Metals New Account Application Form
Sheet: Sheet1

 |  |  | Approved | Initials and Date
 |  |  | AE
 |  |  | Credit Officer
 |  |  | Money Laundering Officer
Note: Explanation comments are available by placing the mouse over the small red tab located on the corner of each box.  To show all notes, go to the view dropdown box and select comments.  To print sheets with comments go to  file dropdown box and select page set up; change the comments dropdown box in the tab labeled sheets.
Enron Metals New Account Application Form
Please assure that this form is filled out in its entirety (all shaded areas) and that requested supporting information is attached
Legal Company Name |  |  | Date Submitted
 |  |  | (dd/mm/yy)
Sponsoring AE |  |  | Credit Personnel
Client Type | Traditional? | Yes
 | EnronOnline? | Yes
GENERAL
 |  |  | Primary Contact
Address Line 1
Address Line 2
City
Country |  |  | Postcode
Direct Telephone |  |  | e-mail
Switchboard Telephone |  |  | Fax
BACKGROUND
How introduced |  |  | Key Personnel
Nature of Business |  |  | Prod./ Operating Facilities Details
Group Structure/ Ownership |  |  | Risk Management Policy
HEDGING ACTIVITIES
Products Traded |  |  | Hedging Policy
How Far Forward |  |  | Currencies
CREDIT
Account Carrying and Clearing Classification | Pricipal Account |  | Nominated Third Party (if any)
FINANCIALS TO ATTACH
 |  |  |  | Comments
Audited financial statements for Client |  | Yes
Audited financial statements for ultimate holding company |  | Yes
BANKING AND REFERENCES
Main Banking Details |  |  | Trade References
Bank Account Officer Contact Name
Bank Account Officer Telephone
COMPLIANCE QUESTIONS
 |  |  |  | Comments
1. Will the Client be using the LME to hedge his main business activities? |  | Yes
2. Has the Client traded on the LME previously? |  | Yes
3. Has the Client traded physical metal forward previously? |  | Yes
4. Is the Client aware of/ or been advised of the following:
a. There is unlimited liability on margined transactions? |  | Yes
b. The Client may be called for margin to secure open positions and that calls for margin must be settled immediately? |  | Yes
c. In the even of a failure to provide margin, the Client's position may be closed-out? |  | Yes
5. Has the Client been told that any credit limit is to cover forward market exposure only and that settlement must be made on the due date irrespective of the credit limit? |  | Yes
6. Has the Client been informed that the amount of the credit limit can be changed or cancelled at any time by us with reference to him? |  | Yes
OTHER DOCUMENTS TO ATTACH
Certificate of Incorporation |  | Yes
Corporate Brochure/ Company Presentation |  | Yes
 |  |  |  | List Other Documents Attached
Further relevant rationale in support of your application |  | Yes
PROPOSED LIMITS
Commission Arrangements |  |  | Security Arrangements
Suitable variation credit line for expected amount of business |  |  | Suggested original margin free position limit (in dollar metal value)
 | 0 |  |  | 0
REQUIRED SIGNATURES
Sponsoring AE |  |  | Date
Credit Officer |  |  | Date
Money Laundering Officer |  |  | Date
Spreadsheet: 774123d1648221267-identify-records-with-specific-condition-test11-etaf
Sheet: Sheet1

ID | Code | Status | Logins | Expected | [NAME] | Column1
253071690049 | Blue | Active | 2
566369030103 | Green | Active | 0 |  |  |  |  | Formula 1 Output word "Never" in Sheet1 Column F for the Unique ID, where ALL Codes meet the condition Column C = "Active" and Column D = 0   Formula 2 For [NAME] IDs (Sheet 2 and Sheet 1), output word "Never" in Sheet2 Column C for the Unique ID where ALL Codes meet the condition Column C = "Active" and Column D = 0   Basically I want to be able to identify which IDs have never logged in. For example Which IDs have 0 logins for all codes associated to the ID. I hope I am making sense.
566369030103 | Blue | Active | 0
566369030103 | Orange | Inactive | 0
566369030103 | Purple | Active | 16
560122395105 | Blue | Active | 0
560122395105 | Green | Active | 0
560122395105 | Purple | Active | 7
560122395105 | Orange | Active | 2
558415928107 | Pink | Active | 0 | Never
558415928107 | Turquoise | Active | 0 | Never
558415928107 | Bergundy | Active | 0 | Never
558415928107 | Red | Active | 0 | Never
558415928107 | None | Active | 0 | Never
558415928107 | White | Active | 0 | Never
558415928107 | Blue | Active | 0 | Never
558415928107 | Black | Active | 0 | Never
558415928107 | Grey | Active | 0 | Never
579036465109 | Duck | Active | 1
579036465109 | Red | Active | 334
766862153562 | Green | Active | 0 | Never
Spreadsheet: 826714d1682190384-confused-using-countif-s-across-multiple-worksheets-with-drop-down-menus-fy-23-icass-count-2023-2024-
Sheet: FY23 Workload

ICASS WORKLOAD COUNTS |  |  |  |  |  |  |  | Sheets
 |  |  |  |  |  |  |  | May 23
FISCAL YEAR:   2023 |  |  |  |  |  |  |  | Jun 23
 |  |  |  |  |  |  |  | Jul 23
POST CODE:     240 GERMANY
 |  |  | Prepared by (please provide section, name and date)
[NAME] (see below & tab 2 & 3 for further guidance*): |  |  | (Please enter location here)
COST CENTER: |  |  | (Please enter cost center here)
AGENCY CODE | AGENCY NAME | WORKLOAD | AGENCY CODE | AGENCY NAME | WORKLOAD
1150 |  |  | 2117
1156 |  |  | 2121.1
1205 |  |  | 2122.5
1235 |  |  | 2144.9
1302 |  |  | 2150
1330 |  |  | 2800
1510 |  |  | 3100
1525 |  |  | 3600
1712 |  |  | 4700
1754.1 |  |  | 5705
1900 |  |  | 5713
1901 |  |  | 5718
1904.1 |  |  | 5725
1904.2 |  |  | 5741
1904.8 |  |  | 7004
1905.1 |  |  | 7005.1
1920 |  |  | 7020
1920.2 |  |  | 7023
1927.1 |  |  | 7024
1929.1 |  |  | 7025
1931 |  |  | 7203.1
1932.9 |  |  | 7203.2
1939 |  |  | 7210
1939.1 |  |  | 8900
1939.2 |  |  | 9568.2
1939.5 |  |  | 9568.3
1942 |  |  | 9700.3
1947.2 |  |  | 9705
1954 |  |  | 9705.1
1967 |  |  | 9705.2
1981 |  |  | 9715
1984 |  |  | 9733
2025 |  |  | 9782
2105.2 |  |  | 9993.2
2111.1 |  |  | 9993.3
2112.1
SUBTOTAL |  | 0 | SUBTOTAL |  | 0
 |  |  |  | GRAND TOTAL COUNT | 0
Agencies
1150 DSCA - Defense Security Cooperation Agency
1150.0 DSCA - Defense Security Cooperation Agency
1235  AG - FAS (Foreign Agricultural Service)
1235.0 AG - FAS (Foreign Agricultural Service)
1330  DOC - ITA - Global Markets
1330.0 DOC - ITA - Global Markets
1525  DOJ - FBI - LEGATT, [NAME]
1525.0 DOJ - FBI - LEGATT, [NAME]
1900  STATE - DP (DIPLOMATIC PROGRAMS)
1900.0 STATE - DP (DIPLOMATIC PROGRAMS)
1901   STATE - ICASS
1901.0 STATE - ICASS
1920   STATE - OBO - CONSTRUCTION PROJECTS
1920.0 STATE - OBO - CONSTRUCTION PROJECTS
Spreadsheet: 128612f3-dff4-44e0-ad8a-0a748b82e49d
Sheet: BLANK

San Antonio Independent School District
Estimated Facility Charges
for Alamo Stadium, Alamo Convocation Center, and Sports Complex
Lessee: |  |  |  |  | Type of Event:
Address: |  |  |  |  | Contact Person:
City/St/Zip |  |  |  |  | Contact Phone No:
Facility Requested:
 |  | Note:  [NAME] at ACC not available.  [NAME] to provide own equipment.
Date(s) Requested: |  |  |  |  | From |  | To
If an event/please indicate actual times it will begin/open and anticipated end.
Date(s) |  |  |  |  | Begin/Open |  | End
TO BE COMPLETED BY SAISD ATHLETIC OFFICE
Please Note That all Expenses Listed Below Are Approximate.
Rental Fee |  |  |  | $ |  |  | Notes
Labor: | Supervisor |  |  | $
 | Custodian/s |  |  | $
 | Police |  |  | $
 | Other As Needed |  |  | $
Total |  |  |  | $
Deposit Amt - $__________     Check No. - __________     Check Date - _______________
Athletic Office Receipt # - __________     Athletic Office Receipt Date - _______________
By signing this form, I acknowledge that the San Antonio Independent School District (District) has explained the estimated charges contained on this form.  I understand that I am fully liable for the charges unless the District's Board of Trustees waives the fees.  I understand that full payment must be submitted to the District within 30 days after the event is held.  I further understand that I am liable to the District for any administrative costs, or collection and attorney fees incurred for non-payment of the charges on this form.
Lessee Signature: |  |  |  |  |  | Date:
Spreadsheet: 547340d1510503270-filling-across-a-range-of-sheets-test
Sheet: Conch Pearl

BOAT NAME
OWNER NAME
MOORING TYPE
ADDRESS
HOME TEL
MOBILE TEL
[NAME]
BOAT TYPE
LENGTH
HULL COLOUR
UPPER DECK
TENDER?
DURATION
FEE
NEXT INVOICE DUE DATE | 2018-12-01 00:00:00
INVOICE DUE DATE | INVOICE REMINDER DATE | INVOICE SENT DATE | DATE PAID | NOTES
2018-12-01 00:00:00
Spreadsheet: 228634d1366171327-date-format-for-drop-down-calendar-in-excel-2007-date-format
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Procedure for Drop Down Calendar
 |  | 01/04/2013
 |  |  |  |  |  |  | Date | Amount
 |  |  |  |  |  |  | 2013-04-01 00:00:00 | 100
 |  |  |  |  |  |  | 2013-04-02 00:00:00
 |  |  |  |  |  |  | 2013-04-03 00:00:00
 |  |  |  |  |  |  | 2013-04-04 00:00:00
 |  |  |  |  |  |  | 2013-04-05 00:00:00
 |  |  |  |  |  |  | 2013-04-06 00:00:00
 |  |  |  |  |  |  | 2013-04-07 00:00:00
 |  |  |  |  |  |  | 2013-04-08 00:00:00
 |  |  |  |  |  |  | 2013-04-09 00:00:00
 |  |  |  |  |  |  | 2013-04-10 00:00:00
 |  |  |  |  |  |  | 2013-04-11 00:00:00
 |  |  |  |  |  |  | 2013-04-12 00:00:00
 |  |  |  |  |  |  | 2013-04-13 00:00:00
 |  |  |  |  |  |  | 2013-04-14 00:00:00
 |  |  |  |  |  |  | 2013-04-15 00:00:00
 |  |  |  |  |  |  | 2013-04-16 00:00:00
 |  |  |  |  |  |  | 2013-04-17 00:00:00
 |  |  |  |  |  |  | 2013-04-18 00:00:00
 |  |  |  |  |  |  | 2013-04-19 00:00:00
 |  |  |  |  |  |  | 2013-04-20 00:00:00
 |  |  |  |  |  |  | 2013-04-21 00:00:00
 |  |  |  |  |  |  | 2013-04-22 00:00:00
Spreadsheet: 1cc6326a-c4b4-4ff0-a96d-38fb85456fe7
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
 |  |  |  |  | PricewaterhouseCoopers/National Venture Capital Association
 |  |  |  |  | MoneyTree™ Report, Data: Thomson Reuters
Q2 2011 - Largest U.S. Venture Capital Investments
Company | City | State | Industry | Stage of Development | Investment Sequence | Amount | Business Description | Investors
CSN Stores LLC | Boston | MA | Consumer Products and Services | Later Stage | 1 | 165000000 | CSN Stores LLC operates as an online retailer of home and office goods. | Battery Ventures, L.P.,Great Hill Equity Partners LLC,HarbourVest Partners LLC,Spark Capital
[NAME], Inc. | New York | NY | Consumer Products and Services | Expansion | 4 | 138000300 | [NAME], Inc. operates a private online shopping community. | Draper Fisher Jurvetson,Eastward Capital,General Atlantic LLC,Goldman, Sachs & Company,Matrix Partners,New Enterprise Associates, Inc.,Pinnacle Ventures,SOFTBANK Corp.,TriplePoint Capital
Fisker Automotive, Inc. | Anaheim | CA | Industrial/Energy | Later Stage | 9 | 114999900 | Fisker Automotive, Inc. designs and manufactures electric vehicles. | Advanced Equities, Inc.,Kleiner Perkins Caufield & Byers,New Enterprise Associates, Inc.
Cameron Health, Inc. | [NAME] | CA | Medical Devices and Equipment | Later Stage | 11 | 107000000 | Develops, manufactures, and distributes implantable defibrillators. | Alloy Ventures,Delphi Ventures,PTV Sciences,RiverVest Venture Partners,Three Arch Partners,[NAME]
i/o Data Centers | Phoenix | AZ | IT Services | Later Stage | 2 | 105000000 | Provides outsourced data center services. | J.P. Morgan Asset Management,Sterling Partners
Coupons.com, Inc. | Mountain View | CA | Media and Entertainment | Later Stage | 7 | 100000000 | Coupons.com, Inc. provides online coupon solution services. | Undisclosed Firm
Intrexon Corporation | Blacksburg | VA | Biotechnology | Later Stage | 11 | 100000000 | Intrexon Corporation is a synthetic biology company. | Third Security, LLC.,Undisclosed Firm
Square, Inc. | San Francisco | CA | IT Services | Expansion | 4 | 100000000 | Square, Inc. provides mobile payment services. | Kleiner Perkins Caufield & Byers,Tiger Global Management LLC
Kabam, Inc. | Redwood City | CA | Software | Expansion | 5 | 84999800 | Kabam, Inc. develops entertainment applications for social networks. | Canaan Partners,Google Ventures,Intel Capital,Performance Equity Management LLC,Pinnacle Ventures,Redpoint Ventures,SK Telecom Ventures
Merrimack Pharmaceuticals, Inc. | Cambridge | MA | Biotechnology | Later Stage | 5 | 77000000 | Develops therapies for the treatment of autoimmune disease and cancer. | Credit Suisse Private Equity,Undisclosed Firm,Undisclosed Firm
Source:  PricewaterhouseCoopers/National Venture Capital Association MoneyTree™ Report, Data:  Thomson Reuters
Spreadsheet: 875182d1721759133-relative-cells-within-a-conditional-statement-sample
Sheet: Sheet 1

Table 1
Name | Opponent | Color
Name 1 |  | W
Name 2 |  | B
Name 3 |  | W
Name 4 |  | B
Name 5 |  | W
Name 6 |  | B
Name 7 |  | W
Name 8 |  | B
Spreadsheet: 860640d1708657087-filtered-formulas-investements-sample
Sheet: Sheet2

 |  |  |  |  |  |  |  |  |  |  |  |  | Gain
 |  |  |  |  |  |  |  |  |  | other bank | Total
 | Open | TFSA | RRSP |  | Subtotal | GIC | Secure | Growth | Subtotal | RRSP |  | Investements | Notes
2022-01-01 00:00:00 | 475 | 475 | 475 |  |  | 475 | 475 | 475 |  | 475
2022-01-07 00:00:00 | 450 | 450 | 450 |  |  | 450 | 450 | 450 |  | 450
2022-01-10 00:00:00 | 490 | 490 | 490 |  |  | 490 | 490 | 490 |  | 490
2023-04-23 00:00:00 | 500 | 500 | 500 |  |  | 500 | 500 | 500 |  | 500
2023-05-01 00:00:00 | 510 | 510 | 510 |  |  | 510 | 510 | 510 |  | 510
2023-05-01 00:00:00 | 520 | 520 | 520 |  |  | 520 | 520 | 520 |  | 520 |  | 150
2023-07-01 00:00:00 | 525 | 525 | 525 |  |  | 525 | 525 | 525 |  | 525 |  | 75
2024-08-14 00:00:00 | 485 | 485 | 485 |  |  | 485 | 485 | 485 |  | 485
2024-08-14 00:00:00 | 600 | 600 | 600 |  |  | 600 | 600 | 600 |  | 600 |  | 100
2024-08-30 00:00:00 | 550 | 550 | 550 |  |  | 550 | 550 | 550 |  | 550
Spreadsheet: 86711d1286670802-duplicate-number-increasing-extention-kbx_-
Sheet: Sheet1

Day | Shift | Rate |  |  | Day | Shift | Rate |  |  |  |  |  |  |  | Days
[NAME] | Days |  |  |  | [NAME] | Days |  |  |  |  |  |  |  |  | Swing
mon | Swing |  |  |  | mon | Swing |  |  |  |  |  |  |  |  | Grave
tue | Grave |  |  |  | tue | Grave
wed |  |  |  |  | wed | Swing
thu |  |  |  |  | thu | Days
fri |  |  |  |  | fri | Days
sat |  |  |  |  | sat | Grave
 | By Shft |  |  |  |  | By Day
Spreadsheet: 704551d1605620502-if-isnumber-search-and-or-with-extra-criteria-erf-log-projects-web-post
Sheet: VLV Parity

ERF | Site [NAME] | Bay(s) | Date (Estimate Complete) | SORT ALL FROM HERE 2 Date  (Outage Start) | SORT ALL FROM HERE 1 Probability | Rate | Hours  (Base) | Cost (Base) | Date  (Estimate  Void  365 Days) | Status
Spreadsheet: 069e9432-6128-49ac-9493-5b885932c03e
Sheet: Pheasant Ridge

 |  |  |  |  |  |  | 2013 Pheasant Ridge F.E.
 | January |  |  |  |  |  | February |  |  |  |  |  | March
 | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr
 |  | 1 | 2 | 3 | 4 |  |  |  |  |  | 1 |  |  |  |  |  | 1
 | 7 | 8 | 9 | 10 | 11 |  | 4 | 5 | 6 | 7 | 8 |  | 4 | 5 | 6 | 7 | 8
 | 14 | 15 | 16 | 17 | 18 |  | 11 | 12 | 13 | 14 | 15 |  | 11 | 12 | 13 | 14 | 15
 | 21 | 22 | 23 | 24 | 25 |  | 18 | 19 | 20 | 21 | 22 |  | 18 | 19 | 20 | 21 | 22
 | 28 | 29 | 30 | 31 |  |  | 25 | 26 | 27 | 28 |  |  | 25 | 26 | 27 | 28 | 29
 | April |  |  |  |  |  | May |  |  |  |  |  | June
 | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr
 | 1 | 2 | 3 | 4 | 5 |  |  |  | 1 | 2 | 3
 | 8 | 9 | 10 | 11 | 12 |  | 6 | 7 | 8 | 9 | 10 |  | 3 | 4 | 5 | 6 | 7
 | 15 | 16 | 17 | 18 | 19 |  | 13 | 14 | 15 | 16 | 17 |  | 10 | 11 | 12 | 13 | 14
 | 22 | 23 | 24 | 25 | 26 |  | 20 | 21 | 22 | 23 | 24 |  | 17 | 18 | 19 | 20 | 21
 | 29 | 30 |  |  |  |  | 27 | 28 | 29 | 30 | 31 |  | 24 | 25 | 26 | 27 | 28
 | July |  |  |  |  |  | August |  |  |  |  |  | September
 | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr
 | 1 | 2 | 3 | 4 | 5 |  |  |  |  | 1 | 2 |  | 2 | 3 | 4 | 5 | 6
 | 8 | 9 | 10 | 11 | 12 |  | 5 | 6 | 7 | 8 | 9 |  | 9 | 10 | 11 | 12 | 13
 | 15 | 16 | 17 | 18 | 19 |  | 12 | 13 | 14 | 15 | 16 |  | 16 | 17 | 18 | 19 | 20
 | 22 | 23 | 24 | 25 | 26 |  | 19 | 20 | 21 | 22 | 23 |  | 23 | 24 | 25 | 26 | 27
 | 29 | 30 | 31 |  |  |  | 26 | 27 | 28 | 29 | 30 |  | 30
 | October |  |  |  |  |  | November |  |  |  |  |  | December
 | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr
 |  | 1 | 2 | 3 | 4 |  |  |  |  |  | 1 |  | 2 | 3 | 4 | 5 | 6
 | 7 | 8 | 9 | 10 | 11 |  | 4 | 5 | 6 | 7 | 8 |  | 9 | 10 | 11 | 12 | 13
 | 14 | 15 | 16 | 17 | 18 |  | 11 | 12 | 13 | 14 | 15 |  | 16 | 17 | 18 | 19 | 20
 | 21 | 22 | 23 | 24 | 25 |  | 18 | 19 | 20 | 21 | 22 |  | 23 | 24 | 25 | 26 | 27
 | 28 | 29 | 30 | 31 |  |  | 25 | 26 | 27 | 28 | 29 |  | 30 | 31
 | 3rd Wednesday.  [NAME] is subject to change.  Call CPFB with questions [PHONE]. Thank you.
 |  |  | Holiday closures. |  |  |  |  | Deliveries. |  |  |  | Inventory - warehouse closures.
Spreadsheet: 709065d1608142956-need-to-lookup-values-and-sum-from-a-table-asking-for-help
Sheet: Sheet1

COURSE | #of HOLES | SCORE
Pine Ridge | 18 | 110
Pine Ridge | 18 | 117
Rolling Oaks | 18 | 97
Rolling Oaks | 18 | 118
Rolling Oaks | 18 | 59
Pine Ridge | 18 | 132
Rolling Oaks | 18 | 60
Pine Ridge | 18 | 109
Rolling Oaks | 18 | 123
[NAME] | 18 | 120
[NAME] | 18 | 115
The Woods | 18 | 128
Rolling Oaks | 18 | 107
 | AVG SCORE | LOW SCORE
[NAME] | ??? | ???
Pine Ridge | ??? | ???
Rolling Oaks | ??? | ???
The Woods | ??? | ???
I am trying to search the top table in order to
populate the bottom table.
Spreadsheet: 794185d1661933262-fix-formula-to-get-unique-op-from-multiple-rows-unique-row-op
Sheet: Sheet1

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | Unique |  | Correct OP |  | Result
A1 | B1 | C1 | A2 | B2 | C2 | A3 | B3 | [NAME] | A4 |  |  | A1
B2 | [NAME] | A1 | B3 | C4 | A2 | B4 | C5 | A3 | B5 |  |  | B2
A2 | B2 | B3 | A3 | B4 | B5 | A4 | B6 | B7 | A5 |  |  | A2
A3 | B4 | C5 | A4 | B5 | C6 | A5 | B6 | C7 | A6 |  |  | A3
A1 | B3 | C4 | A2 | B4 | C5 | A3 | B5 | C6 | A4 |  |  | B3
B1 | C2 | A2 | B2 | [NAME] | A3 | B3 | C4 | A4 | B4 |  |  | B1
C1 | B2 | A3 | C2 | B3 | A4 | [NAME] | B4 | A5 | C4 |  |  | C2
B2 | C2 | D2 | B3 | [NAME] | D3 | B4 | C4 | D4 | B5 |  |  | D2
A1 | D1 | B2 | A2 | D2 | B3 | A3 | D3 | B4 | AC1 |  |  | D1
D1 | B1 | C2 | D2 | B2 | [NAME] | D3 | B3 | C4 | D4 |  |  | D2
A3 | B2 | D2 | A4 | B3 | D3 | A5 | B4 | D4 | A6 |  |  | A4
Spreadsheet: 781211d1653061464-need-help-with-pulling-data-from-one-sheet-to-another-using-index-requiredtraining2022-test-1-aligw
Sheet: Records

[NAME] | FullName | Supervisor | Division | MaxOfClassDate | ClassName | Frequency | ClassType
003 | Employee, Mister | Supervisor, [NAME] | Manager, [NAME] | 2019-12-09 00:00:00 | Class1 | Annual | Annual
003 | Employee, Mister | Supervisor, [NAME] | Manager, [NAME] | 2019-05-08 00:00:00 | Class2 | Annual | Annual
004 | Employee, [NAME] | Supervisor, [NAME] | Manager, [NAME] | 2020-12-03 00:00:00 | Class1 | Annual | Annual
004 | Employee, [NAME] | Supervisor, [NAME] | Manager, [NAME] | 2018-05-24 00:00:00 | Class2 | Annual | Annual
Spreadsheet: 112093d1308246791-spreadsheet-for-cricket-cricket1
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BB
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FF
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GG
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HH
 | 5 | AA | M |  | 4 | BB | M |  | 3 | CC | M
 | 1 | W | 1 |  | 0 | W | 1 |  | 0 | W | 1 |  |  |  |  |  | CC
 | 1 | 1 | 0 |  | 1 | 1 | 0 |  | 0 | 1 | 0
 | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 1 | 6 | 5 |  | 1 | 6 | 5 |  | 1 | 6 | 5
Spreadsheet: 140e56f2-ad71-44fb-bf28-104540d23b89
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 46. OPERATING LEASE FINANCE COMMITMENTS: By Purpose: State (WA), Original (Number, $000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
1. . . [NAME] ; |  |  | Original | A2413759F | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | A2413760R | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413761T | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413762V | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | A2413763W | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles ; |  |  | Original | A2413764X | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
2. . . Other Transport Equipment ; |  |  | Original | A2413765A | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
3. . . Agricultural, Construction & Manufacturing equipment ; |  |  | Original | A2413766C | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
4. . . Office Equipment  ; |  |  | Original | A2413767F | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
5. . . Other ; |  |  | Original | A2413768J | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
TOTAL OPERATING LEASE FINANCE ; |  |  | Original | [NAME] | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2012