tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 434e06b0-08d9-41e4-8739-424dad5b5aa4
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 18. COMMERCIAL FINANCE COMMITMENTS, Revolving Credit By Industry: Australia, Original ($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
Agriculture, forestry and fishing ; |  |  | Original | A2414246T | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
Mining ; |  |  | Original | A2414247V | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
Manufacturing ; |  |  | Original | A2414248W | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
Construction ; |  |  | Original | A2414249X | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
Wholesale trade ; |  |  | Original | A2414250J | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
Retail trade ; |  |  | Original | [NAME] | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
Transport and storage ; |  |  | Original | A2414252L | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
Finance and insurance ; |  |  | Original | [NAME] | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
Property and business services ; |  |  | Original | A2414254T | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
Cultural, recreational, personal and other services ; |  |  | Original | A2414255V | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
Public administration ; |  |  | Original | A2414256W | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
Health and community services ; |  |  | Original | A2414257X | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
Other industries ; |  |  | Original | A2414258A | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
TOTAL REVOLVING CREDIT ; |  |  | Original | A2414259C | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2010
Spreadsheet: 201501d1356013857-validation-of-table-form-data-with-single-input-validate-tabulated-data_rev_-
Sheet: Sheet1

 | Validate data tabulated below in B3- after selection pertiular die I want to get all direct materials data tabulated below in sample table 1, 2 &3. please help me to do so
 | Die 9812
 | Table 1
 | Die 1235 | Direct materials
 | Sr. No | item code | Description | bill of material per assembly | rate | cunsumption per month | pending po quantity
 | 1 | item 1 | aa | 2 | 20 | 25 | 50
 | 2 | item 2 | bb | 0.8 | 15 | 30 | 10
 | 3 | item 3 | cc | 5 | 10 | 120 | 90
 | 4 | item 4 | dd | 16 | 65 | 90 | 40
 | Table 2
 | Die 6789
 | Sr. No | item code | Description | bill of material per assembly | rate | cunsumption per month | pending po quantity
 | 1 | item 9 | ee | 0.5 | 20 | 25 | 200
 | 2 | item 13 | ff | 0.1 | 150.5 | 30 | 60
 | 3 | item 1 | aa | 6 | 20 | 120 | 50
 | 4 | item 2 | cc | 3 | 10 | 90 | 90
 | Table 3
 | Die 9812
 | Sr. No | item code | Description | bill of material per assembly | rate | cunsumption per month | pending po quantity
 | 1 | item 12 | gg | 0.5 | 600 | 300 | 600
 | 2 | item 13 | ff | 0.1 | 150.5 | 540 | 60
 | 3 | item 7 | hh | 6 | 60 | 120 | 50
 | 4 | item 5 | ii | 3 | 0.45 | 90 | 90
 | Die 1235
 | Die 6789
 | Die 9812
Spreadsheet: 835450d1688585477-cant-do-a-simple-addition-2019-mock-marksheet
Sheet: 2019 Reading

 |  |  | Foundation |  |  |  |  |  |  |  |  | Section B |  |  |  |  | Section C |  |  |  |  | Higher |  |  |  |  |  |  |  |  | Section B |  |  |  |  | Section C
Name | Class | Tier | 1 - Special event | 2 - Actor's life | 3 - Bullying | 4 - Play adaptation | 5 - Vocational courses | 6 - Business enterprise | 7 - Education | 8 - Veganism | 9 - Photography (T/F/NM) | 10 - Cinema | 11 - Ski seasons | 12 - Health Problems | 13 - Bull run opinions | 14 - Percentages | 15 - Translation | Total | Grade |  |  | 1 - Veganism | 2 - Applying for a job | 3 - Spanish families | 4 - Christmas | 5 - Guide book | 6 - Poems | 7 - Personality | 8 - Education | 9 - Environment | 10 - Bull run opinions | 11 - Weddings | 12 - Environment | 13 - TV | 14 - Health problems | 15 - Translation | Total | Grade
 |  |  | 0 | 2 | 0 | 3 | 2 | 0 | 3 | 2 | 3 | 1 | 0 | 0 | 2 | 2 | 0
 |  |  | 2 | 3 | 0 | 1 | 0 | 0 | 2 | 2 | 1 | 1 | 1 | 0 | 0 | 0 | 3
 |  |  | 1 | 2 | 1 | 2 | 2 | 0 | 1 | 2 | 0 | 2 | 1 | 1 | 1 | 1 | 4
 |  |  | 1 | 2 | 0 | 1 | 2 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 3 | 0 | 2
 |  |  | 0 | 1 | 0 | 1 | 2 | 0 | 3 | 1 | 1 | 0 | 0 | 0 | 2 | 2 | 1
 |  |  | 0 | 3 | 0 | 1 | 3 | 0 | 4 | 1 | 3 | 2 | 1 | 2 | 2 | 0 | 3
 |  |  | 0 | 3 | 0 | 1 | 3 | 0 | 1 | 2 | 2 | 2 | 2 | 0 | 0 | 0 | 1
 |  |  | 0 | 2 | 0 | 2 | 3 | 0 | 3 | 2 | 0 | 2 | 2 | 0 | 1 | 3 | 5
 |  |  | 2 | 2 | 0 | 1 | 0 | 1 | 2 | 1 | 2 | 1 | 0 | 2 | 4 | 1 | 1
 |  |  | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 2 | 3 | 3 | 2 | 0 | 1 | 2 | 0
 |  |  | 1 | 1 | 2 | 0 | 0 | 0 | 1 | 1 | 0 | 2 | 4 | 1 | 3 | 0 | 4
 |  |  | 3 | 2 | 0 | 1 | 2 | 0 | 1 | 2 | 2 | 1 | 2 | 0 | 2 | 2 | 3
 |  |  | 0 | 1 | 0 | 1 | 1 | 0 | 3 | 2 | 2 | 2 | 2 | 0 | 0 | 2 | 4
Spreadsheet: 54e118c7-7c07-44de-b15c-1f4395767533
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
LEVE | Test | LEVE | [NAME], Serum | [NAME], S | High-Turbulence Liquid Chromatography Mass Spectrometry (HTLC-MS/MS) | Plain, Red-Top Tube: Red |  |  | 1 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 1 mL Collection Instructions:  1. Draw blood immediately before next scheduled dose.  2. For sustained-release formulations ONLY, draw blood a minimum of 12 hours after last dose. 3. Spin down within 2 hours of draw. | 0.5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	NA | 12.0-46.0 mcg/mL | Monday through Sunday; 2 p.m. | Same day/1 day | 2 days | 1 | 80299 |  |  |  |  | Rochester
LEVE | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
LEVE | Result | 83140 | [NAME], S | [NAME], S | Numeric |  |  |  |  | mcg/mL |  |  |  |  |  |  |  |  |  | 30471-7 | [NAME]:MCnc:Pt:Ser/Plas:Qn:
Spreadsheet: tracy_geaccone__40534__NNGOrgPLFormatCORP02
Sheet: Investing

DETAIL OF EQUITY INVESTMENTS
BUSINESS ACQUISITIONS, INTERCOMPANY INVESTING & OTHER INVESTING ACTIVITIES
Non-Merchant Activities
(Millions of Dollars)
 | Investing Activities
 | Jan |  | Feb |  | Mar |  | Apr |  | May |  | Jun |  | Jul |  | Aug |  | Sep |  | Oct |  | Nov |  | Dec |  | Total
Equity Investments
Investment | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Investment | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Investment | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Investment | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Investment | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Miscellaneous
Total (line 124)
Cash Paid for Business Acquisitions
Investment | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Investment | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Investment | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Investment | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Investment | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Miscellaneous
Total (line 126)
Other Investing Activity
Net Salvage & Removal | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
McDay Energy Loan | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Base Gas Buyback | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -3.3 |  | -5 |  | -5 |  | -5 |  | -6.7 |  | 0 |  | 0
Operational Storage Adjustment | -2.4 |  | -2.3 |  | -2.3 |  | 0 |  | -2.5 |  | -2.5 |  | 0 |  | 0 |  | -5 |  | 0 |  | 0 |  | 0
Other | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Other | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Other | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Miscellaneous
Total (line 127)
Total Investing
G:\Cfp\9901Plan\Ect\[schedule.xls]Investing
1998-11-05 14:08:49.080000
Spreadsheet: 77c79e18-b275-47c7-afdf-caafbb169258
Sheet: Sheet1

2010 Gulf Coast Business & Liberal Arts Job Fair Employer Attendees | Unnamed: 1 | Unnamed: 2
ORGANIZATION | WEBSITE | MAJORS
Adult Protective Services | [NAME] | Social Work
Association Member Benefits Advisors | www.ambacareers.info | All Majors
Bankers Life & Casualty Company | http://www.bankerslife.com | All Majors
[NAME], LLC | www.ChildCareCareers.net | Teacher Certification,  Education of Young Children,  Educator of Young Children
City of Houston Department of Health & Human Services | www.houstontx.gov | Bachelor of Arts, Bachelor of Social Work,  Master of Business Administration  Master of Health Administration
Defense Contract Audit Agency | www.dcaa.mil | Accounting
DeMontrond Motor Corporation | www.demontrond.com | Sales Positions Available
Enterprise Rent-A-Car | go.enterprise.com | Business Administration, Communication,  Finance, Management, Marketing,  Psychology, Sociology, Public Service Leadership
Fastenal Company | http://www.fastenal.com | Business Administration, Communication,  Finance, Management, Psychology
First Investors Corporation | www.firstinvestors.com | All Majors
Green Mountain Energy | http://www.GreenMountain.com | All Majors
Harris County Department of Education | http://www.hcde-texas.org | Teaching/Education Positions Available
Kroger | www.kroger.com | All Majors
[NAME] | www.marykay.com/mbradshaw12 | All Majors
NASA/JSC | http://www.nasajobs.nasa.gov | Business Administration, Accounting, Finance,  Marketing, MBA - General
[NAME], P.C. | http://www.null-lairson.com | Accounting/Auditing, Accounting/Finance,  Bachelor of Arts, BBA
Region 4 Alternative Certification Program | www.region4acp.net | All Majors
Republic Services | www.republicservices.com | Business Administration, Accounting, Management, MBA - General,  Environmental Management,  MBA - Environmental Management
Salem Communications - Houston | www.1070knth.com | Communication
Target Corporation | http://www.Target.com/campus | Business Administration, Advertising/Public Relations  Customer Service, Human Resources  Law Enforcement, Management, Retail
Texas Campaign for the Environment | http://www.texasenvironment.org | All Majors
Texas Comptroller of Public Accounts | http://www.window.state.tx.us | Business Administration, Accounting,  MBA - General
Texas Teachers Alternative Certification | www.TexasTeachers.org | All Majors
The Gulf Coast Center | http://www.gcmhmr.com | Computer Science, Psychology,  Behavioral Science - General, Sociology,  Behavioral Science - I/O Psychology, Anthropology
The Reynolds & Reynolds Company | www.reyrey.com | Administrative/Support Services, Business Analyst  Consulting, Customer Service, Marketing
University of Houston Graduate College of Social Work | www.sw.uh.edu | All Majors
University of Texas Medical Branch | www.utmb.edu | For a list of current positions please visit us online www.utmb.edu/hcm
Waddell & Reed Financial Services | www.joinwaddell.com | Finance
Walgreens | http://www.walgreens.jobs | All Majors
 |  | Last Updated 9/20/2010 9:30AM
Spreadsheet: michelle_lokay__26627__imbalsumm0102
Sheet: PGETX

 |  |  |  |  | 12283
 | [NAME] |  | Pecos Del |  | Gunpoint #2
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 40390 | 23187 |  | 16764
2 | 24435 | 3436 |  | 10000
3 |  | -10190 |  | 10000
4 |  | -10190 |  | 10000
5 | 43 | -10190 | 1 | 10000
6 | 63503 | 38533 |  | 24703
7 | 203 | 4810 |  | 10000
8 |  | 1887 |  | 5153
9 | 18658 | 9330 |  | 5012
10 | 12128 | 2810 |  | 5000
11 |  | 2810 |  | 5000
12 | 8330 | 2810 |  | 5000
13 | 43520 | 27568 |  | 10000
14 | 26892 | 14746 |  | 10000
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 |  |  |  | 2001-01-31 00:00:00 |  |  | 125118.45
 |  |  |  | 2001-02-14 00:00:00
Spreadsheet: 814722d1674565959-formula-for-sliding-scale-matching-two-criteria-not-finding-correct-value-sliding-commission-on-two-criteria-not-working-corerctly
Sheet: Sheet1

Name | Joined | Position | Current Tenure | Entitlement | S/be | Tenure next year | Entitlement | S/be |  |  | Employee Classification | Tenure | Days
[NAME] | 2014-01-01 00:00:00 | Executive |  |  | 5 |  |  | 6 |  |  | Executive | 0 | 4
[NAME] | 2020-09-14 00:00:00 | Executive |  |  | 4 |  |  | 4 |  |  | Executive | 5 | 5
Yasmin | 2013-11-13 00:00:00 | Senior Management |  |  | 5 |  |  | 6 |  |  | Executive | 10 | 6
George | 2018-10-15 00:00:00 | Senior Management |  |  | 4 |  |  | 5 |  |  | Senior Management | 0 | 4
[NAME] | 2022-09-28 00:00:00 | Management |  |  | 3 |  |  | 3 |  |  | Senior Management | 5 | 5
[NAME] | 2016-10-01 00:00:00 | Management |  |  | 4 |  |  | 5 |  |  | Senior Management | 10 | 6
[NAME] | 2017-01-01 00:00:00 | Independent Contributor |  |  | 4 |  |  | 5 |  |  | Management | 0 | 3
 |  |  |  |  |  |  |  |  |  |  | Management | 3 | 4
 |  |  |  | Col N value based on C matching L and relevant row in M For value in D |  |  |  |  |  |  | Management | 7 | 5
 |  |  |  |  |  |  |  |  |  |  | Independent Contributor | 0 | 3
 |  |  |  |  |  |  |  |  |  |  | Independent Contributor | 3 | 4
 |  |  |  |  |  |  |  |  |  |  | Independent Contributor | 7 | 5
 |  |  |  |  |  |  |  |  |  |  | Administrative | 0 | 3
 |  |  |  |  |  |  |  |  |  |  | Administrative | 7 | 4
 |  |  |  |  |  |  |  |  |  |  | Administrative | 15 | 5
Spreadsheet: 863274d1710834257-rearranging-data-based-on-dates-data-rearrange-version-3-excelforum-1-
Sheet: Sheet1

 | ID | Month | Plan | Actual |  |  | Plan | Actual |  | ID | Plan | Actual |  |  | Plan | Actual
 | A01 | 2024-01-01 00:00:00 | 5 | 4 |  | A01 | 2024-01-01 00:00:00 | 2024-01-01 00:00:00 |  | A01 | 2024-01-01 00:00:00 | 2024-01-01 00:00:00 |  | A01 | 2024-01-01 00:00:00 | 2024-01-01 00:00:00
 | A02 | 2024-02-01 00:00:00 | 4 | 6 |  | A01 | 2024-01-01 00:00:00 | 2024-01-01 00:00:00 |  | A01 | 2024-01-01 00:00:00 | 2024-01-01 00:00:00 |  | A01 | 2024-01-01 00:00:00 | 2024-01-01 00:00:00
 | A03 | 2024-03-01 00:00:00 | 4 | 0 |  | A01 | 2024-01-01 00:00:00 | 2024-01-01 00:00:00 |  | A01 | 2024-01-01 00:00:00 | 2024-01-01 00:00:00 |  | A01 | 2024-01-01 00:00:00 | 2024-01-01 00:00:00
 | A04 | 2024-04-01 00:00:00 | 0 | 3 |  | A01 | 2024-01-01 00:00:00 | 2024-01-01 00:00:00 |  | A01 | 2024-01-01 00:00:00 | 2024-01-01 00:00:00 |  | A01 | 2024-01-01 00:00:00 | 2024-01-01 00:00:00
 |  |  |  |  |  | A01 | 2024-01-01 00:00:00 | No Actual |  | A01 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 |  | A01 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00
 |  |  |  |  |  | A02 | 2024-02-01 00:00:00 | 2024-02-01 00:00:00 |  | A02 | 2024-02-01 00:00:00 | 2024-02-01 00:00:00 |  | A02 | 2024-02-01 00:00:00 | 2024-02-01 00:00:00
 |  |  |  |  |  | A02 | 2024-02-01 00:00:00 | 2024-02-01 00:00:00 |  | A02 | 2024-02-01 00:00:00 | 2024-02-01 00:00:00 |  | A02 | 2024-02-01 00:00:00 | 2024-02-01 00:00:00
 |  |  |  |  |  | A02 | 2024-02-01 00:00:00 | 2024-02-01 00:00:00 |  | A02 | 2024-02-01 00:00:00 | 2024-02-01 00:00:00 |  | A02 | 2024-02-01 00:00:00 | 2024-02-01 00:00:00
 |  |  |  |  |  | A02 | 2024-02-01 00:00:00 | 2024-02-01 00:00:00 |  | A02 | 2024-02-01 00:00:00 | 2024-02-01 00:00:00 |  | A02 | 2024-02-01 00:00:00 | 2024-02-01 00:00:00
 |  |  |  |  |  | A02 | No Plan | 2024-02-01 00:00:00 |  | A02 | No Plan | 2024-02-01 00:00:00 |  | A02 | No Plan | 2024-02-01 00:00:00
 |  |  |  |  |  | A02 | No Plan | 2024-02-01 00:00:00 |  | A03 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 |  | A02 | No Plan | 2024-04-01 00:00:00
 |  |  |  |  |  | A03 | 2024-03-01 00:00:00 | No Actual |  | A03 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 |  | A03 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00
 |  |  |  |  |  | A03 | 2024-03-01 00:00:00 | No Actual |  | A03 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 |  | A03 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00
 |  |  |  |  |  | A03 | 2024-03-01 00:00:00 | No Actual |  | A03 | 2024-03-01 00:00:00 | No Actual |  | A03 | 2024-03-01 00:00:00 | No Actual
 |  |  |  |  |  | A03 | 2024-03-01 00:00:00 | No Actual |  | A04 | No Plan | No Actual |  | A03 | 2024-03-01 00:00:00 | No Actual
 |  |  |  |  |  | A04 | No Plan | 2024-04-01 00:00:00 |  | A04 | No Plan | No Actual |  | A04 | No Plan | No Actual
 |  |  |  |  |  | A04 | No Plan | 2024-04-01 00:00:00 |  | A04 | No Plan | No Actual |  | A04 | No Plan | No Actual
 |  |  |  |  |  | A04 | No Plan | 2024-04-01 00:00:00 |  |  |  |  |  | A04 | No Plan | No Actual
Spreadsheet: 781949d1653656389-find-records-that-match-id-and-see-if-any-records-contain-example
Sheet: account

Account ID | Account Number | Contact First Name | Contact Name | Telephone | [NAME] | Remittance/Communication E-mail
001U000000UqRco | 1234 |  | ELLIE | 1234567899 | 7777889898 | [EMAIL]
001U000000UqXOs | 12345 |  | KAREN SPARK | 2222222222 | 7411111111 | [EMAIL]
0011i000003l1yy | 123456 | MARTIN | STOCKLEY | 2222333333 | 7822222222 | [EMAIL]
Spreadsheet: 746673d1630943183-count-unique-ids-that-have-multiple-records-possible-pivot-table-answer
Sheet: Sheet1

Student ID | Month
1 | 2020-09-01 00:00:00 |  | September | 1
2 | 2020-09-01 00:00:00 |  | October | 2 |  | Month | (All)
3 | 2020-09-01 00:00:00 |  | November | 2
3 | 2020-09-01 00:00:00 |  | December | 3 |  | Row Labels | Count of Student ID
4 | 2020-10-01 00:00:00 |  |  |  |  | 11 | 3
5 | 2020-10-01 00:00:00 |  |  |  |  | 5 | 3
5 | 2020-10-01 00:00:00 |  |  |  |  | 10 | 2
5 | 2020-10-01 00:00:00 |  |  |  |  | 9 | 2
6 | 2020-10-01 00:00:00 |  |  |  |  | 3 | 2
7 | 2020-10-01 00:00:00 |  |  |  |  | 12 | 2
7 | 2020-10-01 00:00:00 |  |  |  |  | 15 | 2
8 | 2020-11-01 00:00:00 |  |  |  |  | 7 | 2
9 | 2020-11-01 00:00:00 |  |  |  |  | 1 | 1
9 | 2020-11-01 00:00:00 |  |  |  |  | 14 | 1
10 | 2020-11-01 00:00:00 |  |  |  |  | 13 | 1
10 | 2020-11-01 00:00:00 |  |  |  |  | 6 | 1
11 | 2020-12-01 00:00:00 |  |  |  |  | 2 | 1
11 | 2020-12-01 00:00:00 |  |  |  |  | 4 | 1
11 | 2020-12-01 00:00:00 |  |  |  |  | 8 | 1
12 | 2020-12-01 00:00:00 |  |  |  |  | Grand Total | 25
12 | 2020-12-01 00:00:00
13 | 2020-12-01 00:00:00
14 | 2020-12-01 00:00:00
15 | 2020-12-01 00:00:00
15 | 2020-12-01 00:00:00
Spreadsheet: 199822d1355332312-how-to-match-data-in-one-column-with-another-column-excel-forum
Sheet: What I Expect to See

Temp_Grid | Temperature |  | CLC_Grid | Percentage | Results
0 | 33.5 |  | 0 | 0.3333333333333333 | 33.5
1 | 32 |  | 2 | 0.2222222222222222 | 32
2 | 32 |  | 3 | 0.3333333333333333 | 34.6
3 | 34.6 |  | 4 | 0.1111111111111111 | 34.5
4 | 34.5 |  | 5 | 0.2222222222222222 | 33.75
5 | 33.75 |  | 10 | 0.1111111111111111 | 33
6 | 35 |  | 11 | 0.3333333333333333
7 | 34.375 |  | 12 | 0.1111111111111111
8 | 32.5 |  | 16 | 0.1111111111111111
9 | 32 |  | 17 | 0.1111111111111111
10 | 33 |  | 19 | 0.1111111111111111
Spreadsheet: 04bd32c7-e144-4b6d-873d-573f72ab3fdb
Sheet: February 2013

Spend over £25,000 - Publication template
Department family | Entity | Date | Expense type | Expense area | Supplier | Transaction number | Amount
DCMS | SMG | 2013-02-07 00:00:00 | Maintenance | NRM Estates | Honeywell Controls Ltd | 170380 | 89942
DCMS | SMG | 2013-02-07 00:00:00 | Maintenance | NMeM Estates | Honeywell Controls Ltd | 170381 | 82858
DCMS | SMG | 2013-02-07 00:00:00 | Gas | Science Museum Estates | Gazprom Marketing & Trading Limited | 170439 | 37048.72
DCMS | SMG | 2013-02-07 00:00:00 | Gas | Science Museum Estates | Gazprom Marketing & Trading Limited | 170440 | 30792.53
DCMS | SMG | 2013-02-07 00:00:00 | Gas | Science Museum Estates | Gazprom Marketing & Trading Limited | 170476 | 37048.72
DCMS | SMG | 2013-02-07 00:00:00 | Electricity | Science Museum Estates | Natural History Museum | 170725 | 44148.54
DCMS | SMG | 2013-02-07 00:00:00 | Rent | Science Museum Estates | The British Museum | 170977 | 97273.35
DCMS | SMG | 2013-02-21 00:00:00 | Build Construction | National MPG | Elmwood (Glasgow) Ltd | 171069 | 54907.71
DCMS | SMG | 2013-02-21 00:00:00 | Professional Fees | ScM Major projects | Universal Design Studio Limited | 171131 | 50250
DCMS | SMG | 2013-02-28 00:00:00 | Professional Fees | ScM Major projects | Universal Everything Limited | 171567 | 50000
DCMS | SMG | 2013-02-21 00:00:00 | Maintenance | Science Museum Estates | Cofely Limited | 171796 | 28974.85
Spreadsheet: 782532d1654096915-data-validation-alternate-formula-for-filter-function-test-5-ans
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | 1 | 2
 | 1 | A | 1 | A | <- I need this in data validation (drop down)
 | 2 | C | 2 | C
 | 1 | V
 | 2 | C
 | 1 | D
 |  |  |  |  |  | DV formula
 |  |  |  |  |  | =OFFSET($L$2,0,MATCH($D2,$L$1:$M$1,0)-1,COUNTIF(INDEX($L$2:$M$6,,MATCH($D2,$L$1:$M$1,0)),"?*"))
 |  |  |  |  |  | L and M are helper columns
Spreadsheet: 677163d1589222866-using-xlookup-vlookup-formula-into-a-validated-cell-to-return-a-value-into-that-cell-validation-vlookup
Sheet: Validated

 | UKMOB (11 digits)
[NAME]
[NAME]
carrie
[NAME]
esther
fred
greg
[NAME]
ian
[NAME]
[NAME]
lily
[NAME]
[NAME]
olivee
[NAME]
quentin
[NAME]
[NAME]
Spreadsheet: 07125bcf-fef7-475d-b0ca-6c7c380db387
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Standard |  | Sequence |  | Tm (ºC)
 | Primer
 | M13-40 |  | 5' - GTT TTC CCA GTC ACG AC - 3' |  | 56.14
 | [NAME] |  | 5' - GGA AAC AGC TAT GAC CAT G - 3' |  | 58.01
 | M13-20 |  | 5' - GTA AAA CGA CGG CCA GT -3' |  | 58.61
 | T3 |  | 5' - AAT TAA CCC TCA CTA AAG GG - 3' |  | 56.23
 | Universal T7 |  | 5' - TAA TAC GAC TCA CTA TAG GG - 3' |  | 50.83
 | T7term |  | 5' - GCT AGT TAT TGC TCA GCG G - 3' |  | 60.14
 | Sp6 |  | 5´ - ATT TAG GTG ACA CTA TAG - 3´ |  | 42.58
 | [NAME] |  | 5' - GCATTAAAGCAGCGTATC - 3'
 | H1 |  | 5’ TGGCAGGAAGATGGCTGTGA 3’