tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 689795d1596654196-indirect-syntax-within-index-match-excel_help
Sheet: SERIES

 |  |  |  | 2015-06-30 00:00:00 | 2015-07-31 00:00:00 | 2015-08-31 00:00:00 | 2015-09-30 00:00:00 | 2015-10-31 00:00:00 | 2015-11-30 00:00:00 | 2015-12-31 00:00:00 | 2016-01-31 00:00:00 | 2016-02-29 00:00:00 | 2016-03-31 00:00:00 | 2016-04-30 00:00:00 | 2016-05-31 00:00:00 | 2016-06-30 00:00:00 | 2016-07-31 00:00:00 | 2016-08-31 00:00:00 | 2016-09-30 00:00:00 | 2016-10-31 00:00:00 | 2016-11-30 00:00:00 | 2016-12-31 00:00:00 | 2017-01-31 00:00:00 | 2017-02-28 00:00:00 | 2017-03-31 00:00:00 | 2017-04-30 00:00:00 | 2017-05-31 00:00:00 | 2017-06-30 00:00:00 | 2017-07-31 00:00:00 | 2017-08-31 00:00:00 | 2017-09-30 00:00:00 | 2017-10-31 00:00:00 | 2017-11-30 00:00:00 | 2017-12-31 00:00:00 | 2018-01-31 00:00:00 | 2018-02-28 00:00:00 | 2018-03-31 00:00:00 | 2018-04-30 00:00:00 | 2018-05-31 00:00:00 | 2018-06-30 00:00:00 | 2018-07-31 00:00:00 | 2018-08-31 00:00:00 | 2018-09-30 00:00:00 | 2018-10-31 00:00:00 | 2018-11-30 00:00:00 | 2018-12-31 00:00:00 | 2019-01-31 00:00:00 | 2019-02-28 00:00:00 | 2019-03-31 00:00:00 | 2019-04-30 00:00:00 | 2019-05-31 00:00:00 | 2019-06-30 00:00:00 | 2019-07-31 00:00:00 | 2019-08-31 00:00:00 | 2019-09-30 00:00:00 | 2019-10-31 00:00:00 | 2019-11-30 00:00:00 | 2019-12-31 00:00:00 | 2020-01-31 00:00:00 | 2020-02-29 00:00:00 | 2020-03-31 00:00:00 | 2020-04-30 00:00:00 | 2020-05-31 00:00:00 | 6.30.20 | 7.31.20
 | Fund 1-A | Rating 3 Yr | 3-Year
 | Fund 1-A | Rating 5 Yr | 5-Year
 | Fund 1-A | Rating 10 Yr | 10-Year
 | Fund 1-A | Rating Overall | Overall
 | Fund 1-C | Rating 3 Yr | 3-Year
 | Fund 1-C | Rating 5 Yr | 5-Year
 | Fund 1-C | Rating 10 Yr | 10-Year
 | Fund 1-C | Rating Overall | Overall
 | Fund 1-I | Rating 3 Yr | 3-Year
 | Fund 1-I | Rating 5 Yr | 5-Year
 | Fund 1-I | Rating 10 Yr | 10-Year
 | Fund 1-I | Rating Overall | Overall
Spreadsheet: 484236d1476185149-updating-holiday-planner-for-this-year-proposed-holiday-planner-based-on-2015-16
Sheet: AUG

 |  | Days
1
 |  | Entitlement | Taken | Remaining
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1
 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  |  |  |  |  | 1 | 1 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  | 1 | 1 | 1 | 1
 |  | 26
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1
Entering '1' in the relevant row/column represents 0.5 of a day
Spreadsheet: 0c9c6926-2ab5-46bc-86e8-6d1b78fdd961
Sheet: Sheet1

Characteristics of principal farm operator households, by age of principal operator, 2011 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Age of principal operator
Item | Less than 35 years old | 35-54 years old | 55-64 years old | 65 years old or more | All
Number of family farms | 83740.5008779556 | 667208.418680734 | 683844.899349293 | 679874.482618481 | 2114668.30152646
Percent of family farms | 3.95998279340111 | 31.5514455954682 | 32.3381638082749 | 32.1504078028557 | 100
Average age, principal operator | 29.8475165110067 | 46.7342996389615 | 58.6871630859192 | 73.0261764600012 | 58.3838681109806
Percent of principal operators retired from farming | 2.20318346354474 | 4.01175276264451 | 10.5783512212654 | 38.0428550734356 | 17.0047892685003
Percent of total value of production | 6.11035902586617 | 40.7769615921865 | 35.110355668956 | 18.0023237129911 | 100
Distribution by gross value of production
Less than $10,000 | 39.7292962831792 | 57.4583751545262 | 61.2765424373898 | 61.7971731189651 | 59.3859731115078
$10,000 to $249,999 | 45.177623422726 | 28.6573756497986 | 27.6855411766424 | 32.5159616827545 | 30.2378523401786
$250,000 or more | 15.0930802940947 | 13.8842491956752 | 11.0379163859675 | 5.6868651982806 | 10.3761745483135
Average farm size (operated acres) | 390.424357640975 | 422.023662056911 | 397.177819856484 | 332.33874740108 | 383.903580089393
Percent of acres | 4.02724490879438 | 34.6843772863184 | 33.4563209765893 | 27.8320568282978 | 100
Share of beginning farms |  |  | Percent
Established farm | 23.9893302386951 | 66.7229548528301 | 83.3298013020029 | 91.735182974623 | 78.4425932209727
Beginning farm | 76.0106697613048 | 33.2770451471701 | 16.670198697997 | 8.26481702537711 | 21.5574067790272
Farm cash business income, average | 33098.8462396852 | 33255.6485151267 | 36024.9025910503 | 16131.7317918359 | 28639.5560329798
Farm household finances |  |  | Dollars
Farm income, average | 16426.3023225059 | 16607.5892160923 | 18816 | 8236.90314342566 | 14623.169832797
Off-farm income, average | 51503.156279629 | 83351.6643995422 | 75735.6138667227 | 61696.1809824283 | 72665.2518307328
Total income, average | 67929.458602135 | 99959.2536156345 | 94552.2102200211 | 69933.084125854 | 87289.4216635298
Total income, median | 56310 | 70186 | 59602 | 43610 | 57050
Net worth, mean | 527968.539587785 | 857295.645194632 | 1140141.98614826 | 1092452.90048605 | 1011325.67809609
Net worth, median | 263558 | 491932 | 663914 | 675990 | 597767
Farm net worth, mean | 453511.329695418 | 676057.091262578 | 871616.393705523 | 852523.234873967 | 787219.189768429
Farm net worth, median | 195240 | 314387 | 398347 | 470617 | 384165
Non-farm net worth, mean | 74457.2098923664 | 181238.553932054 | 268525.592442742 | 239929.665612089 | 224106.488327658
Non-farm net worth, median | 46250 | 106653 | 169416 | 150108 | 141250
Source:  2011 USDA Agricultural Resource Management Survey.
Spreadsheet: phillip_m_love__30684__DenFRED
Sheet: Summary

Financial Liquidation Variance Summary
PRODUCTION MONTH:  4/00
DESK: Denver
 |  |  | Per [NAME], there is no finanical liquidations for DE 4/00 production
 | per OA reports |  | per [NAME] | var | expl
NGP&L LIQUIDATIONS | 0
Less (refer to [NAME]):
Discrepancies between Actuals & Flash | 0
[NAME]
GL Adjustments
In Actuals, not [NAME] (unexplained) | -100496
Not TAGG related:Reclass inv profits to storage reconciliation
Restated NGP&L
GL LIQUIDATIONS
Less (refer to [NAME]):
 | 0
Restated Actuals
[NAME]
unexplained
Spreadsheet: 122959d1317268560-sumif-s-formula-help-quarterly-rollup
Sheet: Sheet1

TA | Company | Month | Quarter | Year | Invoiced Amount
12 | TRX | 1 | 1 | 2010 | 126548
5 | XRC | 4 | 2 | 2010 | 5124
51 | TRX | 3 | 1 | 2011 | 24896
5 | TSI | 1 | 1 | 2010 | 5412
12 | TSI | 2 | 1 | 2009 | 325
12 | XRC | 12 | 4 | 2011 | 3582
12 | TRX | 3 | 1 | 2010 | 2354589
12 | ISC | 4 | 2 | 2009 | 254589
3 | XRC | 10 | 4 | 2010 | 25
3 | TSI | 6 | 2 | 2011 | 32532
5 | TRX | 7 | 3 | 2010 | 251145
4 | XRC | 8 | 3 | 2009 | 2156
7 | TSI | 9 | 3 | 2011 | 32478
45 | TRX | 11 | 4 | 2010 | 2145963
16 | TRX | 12 | 4 | 2011 | 2369
51 | XRC | 6 | 2 | 2009 | 236582
51 | STSI | 5 | 2 | 2010 | 2595
3 | TRX | 4 | 2 | 2011 | 59999
51 | ISC | 12 | 4 | 2010 | 2156584
Spreadsheet: 844304d1696018331-count-total-monthly-products-sold-in-gms-on-google-sheet-sample-sheet
Sheet: Account Receivables

Invoice | Order Date | Product | [NAME] (gms) | Quantity | Cost | Total Amount | Discount | Tax Amount | Shipping | Total Invoiced Amount | Total
1 | 2023-07-10 00:00:00 | Product A | 1000 | 2 | 1085
2 | 2023-07-11 00:00:00 | Product A | 1000 | 1 | 500
3 | 2023-07-12 00:00:00 | Product B | 1000 | 3 | 500
 | 2023-07-13 00:00:00 | Product C | 1000 | 2 | 500
4 | 2023-07-14 00:00:00 | Product D | 500 | 2 | 1085
5 | 2023-07-14 00:00:00 | Product D | 500 | 2 | 650
4 | 2023-07-14 00:00:00 | Product D | 500 | 2 | 650
5 | 2023-07-18 00:00:00 | Product D | 100 | 3 | 650
6 | 2023-07-18 00:00:00 | Product E | 500 | 1 | 650
 | 2023-07-21 00:00:00 | Product E | 100 | 1 | 650
6 | 2023-07-21 00:00:00 | Product E | 250 | 3 | 650
7 | 2023-07-21 00:00:00 | Product C | 250 | 5 | 198
7 | 2023-07-21 00:00:00 | Product C | 250 | 3 | 198
8 | 2023-07-23 00:00:00 | Product C | 100 | 2 | 198
9 | 2023-07-23 00:00:00 | Product E | 100 | 1 | 198
 | 2023-07-29 00:00:00 | Product E | 100 | 5 | 198
8 | 2023-07-29 00:00:00 | Product E | 300 | 1 | 198
9 | 2023-07-29 00:00:00 | Product B | 300 | 1 | 170
10 | 2023-07-29 00:00:00 | Product B | 300 | 2 | 170
11 | 2023-07-29 00:00:00 | Product B | 300 | 1 | 170
12 | 2023-07-29 00:00:00 | Product B | 1000 | 2 | 170
Spreadsheet: 713278d1610631281-finding-whichever-common-text-and-digits-between-two-lists-list-to-serach-text-with-text-string
Sheet: Find Matched Text

Serial | text | Find Here
1 | 123 SELCO -
2 | SERVICE
3 | AAA B & Q 1
4 | MY LIVING/ INV 1197
5 | Q RANGE 1S
6 | APPLE [PHONE]
Spreadsheet: 66651d1267298527-index-match-and-transpose-sample1
Sheet: Report

 | Bigger company
 | Client Since: |  |  | Fees Generated: | AUM:
 |  |  | YTD
 |  |  | Accrued
Accounts | Account Names |  |  | Performance vs Benchmark
 |  |  |  | 1mth | 3mth | 6mth | 9mth | YTD | 1 year
Spreadsheet: 202218d1356413525-variable-data-validation-example
Sheet: Sheet4

Locations | (All)
 |  |  |  | Brands | Adidas
Row Labels
Adidas |  |  |  | Row Labels
Brand X |  |  |  | Agra
Nike |  |  |  | Bhopal
Rebok |  |  |  | Faridabad
(blank) |  |  |  | Ghaziabad
Grand Total |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | Meerut
 |  |  |  | Nashik
 |  |  |  | Patna
 |  |  |  | Pimpri-Chinchwad
 |  |  |  | Rajkot
 |  |  |  | Srinagar
 |  |  |  | Vadodara
 |  |  |  | Varanasi
 |  |  |  | Vasai-Virar
 |  |  |  | Visakhapatnam
 |  |  |  | Grand Total
Spreadsheet: 702733d1604505396-returning-the-latest-status-example-3
Sheet: Master Service Id - KOSMOS

Service ID | DTL-Invoice line item | [NAME] service start date | [NAME] service end date | dtl - service status
805335145 |  | 2019-08-14 00:00:00 |  | Active
805335414 |  | 2019-01-28 00:00:00 |  | Active
805337155 |  | 2019-08-06 00:00:00 |  | #MULTIVALUE
805337226 |  | 2019-01-23 00:00:00 | 2019-01-23 00:00:00 | Ceased
805356890 |  | 2019-01-16 00:00:00 |  | Active
805357201
805423465 |  | 2020-01-20 00:00:00 |  | Active
805424773 |  | 2018-12-20 00:00:00 | 2018-12-20 00:00:00 | Ceased
805424990 |  | 2019-05-03 00:00:00 |  | Active
805425992 |  | 2019-02-14 00:00:00 |  | Active
805425992.
805426479 |  | 2019-06-04 00:00:00 |  | Active
805426573 |  | 2019-02-14 00:00:00 |  | Active
805426949 |  | 2018-12-28 00:00:00 | 2018-12-28 00:00:00 | Ceased
805427007 |  | 2019-04-17 00:00:00 |  | Active
805427082 |  | 2019-05-22 00:00:00 |  | Active
805427373 |  | 2019-08-06 00:00:00 |  | #MULTIVALUE
805427998 |  | 2019-02-18 00:00:00 |  | Active
805428235 |  | 2019-02-15 00:00:00 |  | Active
Spreadsheet: 164758d1340884159-excel-2007-trying-to-build-a-time-sheet-work-book-and-am-stuck-on-seperating-the-day-and-night-shift-new-project-pay-roll-and-time-sheet-beta-day-night-test-1
Sheet: Thursday Night Timesheeet

 |  |  | TRI TOOL INC.
 | Customer: |  |  |  |  |  |  |  |  | CUSTOMER CONTACT: |  |  |  |  |  | JOB NO: |  |  |  |  |  | Home Page
 | Work Location: |  |  |  |  |  |  |  |  | CUST. P.O. NO. |  |  |  |  |  | DATE:
 | Employee: |  |  |  |  | TOTAL HRS: |  | WORK [NAME]/WORK ORDER NO. |  |  |  |  |  |  |  |  | CONSUMABLES: |  |  |  |  | Payroll
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | QUAN: | PART NO:
 |  |  |  |  | Verify the following SAFTY ITEM CHECKLIST as required on this site. |  |  |  |  |  |  |  |  | Equipment Usage: |  |  |  |  | Tech Initial
 |  | NO | YES
 |  |  |  | 1 | If required, has the site specific training been completed?
 |  |  |  | 2 | If permits are required, do you have the proper papers?
 |  |  |  | 3 | Is Scaffolding correct and safe?
 |  |  |  | 4 | If lockout is required, has the proper procedure been followed?
 |  |  |  | 5 | Do you know the emergency signals?
 |  |  |  | 6 | Do you know the escape routes and assembley points?
 |  |  |  | 7 | Are safety glasses required?
 |  |  |  | 8 | Is a face sheild required?
 |  |  |  | 9 | Is a hard hat required?
 |  |  |  | 10 | Are flame resistant clothes required?
 |  |  |  | 11 | Is hearing protection required?
 |  |  |  | 12 | Are safety toed shoes required?
 |  |  |  | 13 | Are respirators required? |  |  |  |  |  |  |  |  | SIGNATURES:
 |  |  |  | 14 | Is fall protection equipment required?
 |  |  |  | 15 | Other: |  |  |  |  |  |  |  | CUSTOMER:
 |  |  |  |  |  |  |  |  |  |  |  |  | TRI TOOL:
Spreadsheet: 772585d1647374948-excel-formula-consolidate-data-in-columns-and-create-new-rows-two-criteria-test-workbook
Sheet: Sheet1

Value | Amount | Type |  | Distinct Values | Sum Of |  | "Distinct" Values | Sum Of
1 | 12 | A |  |  |  |  | 1 | 123.5
1 | 44.5 | A |  |  |  |  | 2 | 85
1 | 45 | A |  |  |  |  | 3 | 82.25
1 | 17 | A |  |  |  |  | 4 | 134.75
2 | 21 | A |  |  |  |  | 1 | 72.5
2 | 1 | A |  |  |  |  | 3 | 32.5
1 | 13 | C |  |  |  |  | 4 | 3
1 | 15.5 | C
1 | 17 | C
3 | 82.25 | A
3 | 0.5 | C |  | Currently ^ |  |  | What I want ^
1 | 27 | C
3 | 13 | C
3 | 19 | C
4 | 3 | C
1 | 5 | A
4 | 55 | A
2 | 63 | A
4 | 79.75 | A
Spreadsheet: 31861d1227839713-automatically-update-chart-help
Sheet: Sheet1

Cost | P_1 | P_2 | P_3 | P_4 | P_5 | P_6 | [NAME]
Team1 | 1 | 2 | 2 | 3 | 2 | 1 | 1
Team2 | 2 | 1 | 3 | 2 | 2 | 2 | 3
Team3 | 1 | 3 | 4 | 4 | 3 | 3 | 1
Spreadsheet: 6d897c50-1119-4078-aa65-269f9ace1bb4
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
ZNS | Test | ZNS | Zinc, Serum | Zinc, S | Dynamic Reaction Cell-Inductively Coupled Plasma-Mass Spectrometry (DRC-ICP-MS) | Royal blue-top Monoject trace element blood collection tube: RylBlue |  |  | 0.8 | mL | Collection Container/Tube: Plain, royal blue-top Monoject trace element blood collection tube, product #8881-307006 (Supply T184) Submission Container/Tube: 7-mL Mayo metal-free, screw-capped, polypropylene vial (Supply T173) [NAME]: 0.8 mL Collection Instructions: 1. Allow the specimen to clot for 30 minutes, then centrifuge the specimen to separate serum from the cellular fraction. Serum must be removed from cellular fraction within 4 hours of specimen collection. Avoid hemolysis. 2. Remove the stopper. Carefully pour specimen into Mayo metal-free, polypropylene vial, avoiding transfer of the cellular components of blood. Do not insert a pipet into the serum to accomplish transfer, and do not ream the specimen with a wooden stick to assist with serum transfer. 3. See Metals Analysis-Collection and Transport in Special Instructions for complete instructions. Additional Information: High concentrations of gadolinium, iodine, and barium are known to interfere with most metals tests. If gadolinium-, iodine-, or barium-containing contrast media has been administered, a specimen should not be collected for 96 hours. | 0.2 mL | Hemolysis	Mild reject; Gross reject Thawing	Warm OK; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	Mild OK; Gross reject Other	NA | 0-10 years: 0.60-1.20 mcg/mL > or =11 years: 0.66-1.10 mcg/mL | Monday through Friday; 8 a.m. - 6 p.m.; Saturday; 8 a.m. - 3 p.m./Continuously | 1 day | 3 days | 1 | 84630 |  |  |  |  | Rochester
ZNS | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
ZNS | Result | 8620 | Zinc, S | Zinc, S | Numeric |  |  |  |  | mcg/mL |  |  |  |  |  |  |  |  |  | 5763-8
Spreadsheet: 880014d1727627475-populating-table-from-a-dropdown-list-drop-down-example
Sheet: Data

 | Table 1 |  |  | Table 2 |  |  | Table 3 |  |  | Table 4
Flow temperature [°C] | A |  |  | B |  |  | C |  |  | D
Outside temperature [°C] | Column 1 | Column 2 | Column 3 | Output [kW] | Input [kW] | COP | Output [kW] | Input [kW] | COP | Output [kW] | Input [kW] | COP
1 | 3 | 18 | 48 | 0 | 15 | 42 | 1 | 19 | 46 | 3 | 12 | 35
2 | 0 | 11 | 24 | 5 | 11 | 44 | 5 | 18 | 40 | 0 | 11 | 25
3 | 10 | 20 | 31 | 7 | 14 | 23 | 3 | 19 | 22 | 4 | 18 | 45
4 | 6 | 10 | 40 | 6 | 20 | 35 | 4 | 19 | 47 | 7 | 11 | 27
5 | 1 | 18 | 17 | 5 | 14 | 20 | 6 | 17 | 19 | 7 | 19 | 17
6 | 10 | 18 | 35 | 0 | 17 | 28 | 10 | 11 | 41 | 8 | 19 | 49
7 | 0 | 12 | 45 | 3 | 14 | 31 | 10 | 10 | 37 | 8 | 11 | 36
8 | 9 | 19 | 10 | 3 | 14 | 45 | 8 | 13 | 36 | 9 | 13 | 26
9 | 4 | 17 | 31 | 3 | 14 | 36 | 6 | 19 | 24 | 4 | 19 | 44
10 | 4 | 14 | 26 | 2 | 12 | 33 | 10 | 18 | 24 | 6 | 13 | 45
Table Number
Table 1
Table 2
Table 3
Table 4
Spreadsheet: 0c05e9ea-4365-4f40-b6be-d8192ded1a96
Sheet: Sheet1

SCG BWF World Junior Championships 2013 23 October - 3 November , Bangkok Thailand | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Accreditation Application Form
Return to  e-mail: [EMAIL]  NO LATER THAN 23 September  2013
Category |  |  | Organization
Contact |  |  | E-mail
Tel/Fax |  |  | Address
No. | Full Name |  | Function |  | Remarks
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
NOTE:  Please adhere to the Accreditation Policy and enclose an E-photo of all the participants.
(Thank you to name the photos as NAME_FIRST NAME)
BWF | : BWF Official, Support Staff |  |  | REF | :Referee
PLA | :Player |  |  | DPR | :Deputy Referee
CAP | :Team Captain |  |  | UMP | :BWF Appointed Umpire
COA | :Coach |  |  | LJD | : BWF Appointed Line Judge
DOC | :Doctor/Physiotherapist |  |  | E | :Journalist
ACC | :Other accompanying official |  |  | EP | :Photographer
INT | :Interpreter |  |  | RHBs | :IMG and its licensee
 |  |  |  | ENR | :Non-rights holding broadcaster
Spreadsheet: 197628d1354498349-return-all-matching-rows-of-a-table-based-on-dropdown-cell-book1-1-test
Sheet: Sheet1

Inventory ID | Product | Cost Price | Sale Price | Quantity Available | Date Ordered |  |  |  |  |  |  | A
20122 | A | 200 | 400 | 10 | 2012-01-19 00:00:00 |  |  |  |  |  |  | B
20129 | B | 150 | 300 | 10 | 2012-01-20 00:00:00 |  |  |  |  |  |  | C
20001 | A | 130 | 370 | 25 | 2011-09-14 00:00:00
20111 | A | 100 | 350 | 5 | 2011-09-01 00:00:00
22991 | C | 5 | 50 | 100 | 2012-11-25 00:00:00
22992 | C | 7 | 70 | 50 | 2012-11-29 00:00:00
29321 | B | 140 | 300 | 10 | 2011-09-29 00:00:00
Product | Inventory ID
A
Spreadsheet: 49471d1248820950-excluding-decimals-excluding-decimals
Sheet: Sheet1

7.26 | 0
8.75 | 0
10 | 10
4.1 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
Spreadsheet: 686478d1594650501-avoiding-deleting-information-as-the-year-begins-avoiding-deleting-information
Sheet: Sheet1

ZW$ |  |  |  |  |  |  |  |  |  |  |  |  |  | Year | 2019 |  |  | Month | January
Sales Journal
Date | Customer Code | Name | Vat Number | Invoice | Amount | Vat % | [NAME] | Amount incl [NAME] | Payment Terms |  | 1919-01-01 00:00:00 | 1919-02-01 00:00:00 | 1919-03-01 00:00:00 | 1919-04-01 00:00:00 | 1919-05-01 00:00:00 | 1919-06-01 00:00:00 | 1919-07-01 00:00:00 | 1919-08-01 00:00:00 | 1919-09-01 00:00:00 | 1919-10-01 00:00:00 | 1919-11-01 00:00:00 | 2020-12-01 00:00:00 | Year to date
2019-01-01 00:00:00 | C001 |  |  | 123 | 10000 | 0.15 |  |  | 20
1919-01-02 00:00:00 | C002 |  |  | 124 | 20000 |  |  |  | 30
1919-02-03 00:00:00 | C005 |  |  | 125 | 30000
1919-02-04 00:00:00 | C010 |  |  | 126 | 40000 |  |  |  |  |  | Question 1: |  | I want excel formula that when I click  at P2 and T2 to show the report for 2020, the Sales Journal has transcations for  2019
1919-03-05 00:00:00 | C001 |  |  | 127 | 5000 |  |  |  |  |  |  |  | and 2020 (in red). The above report is showing the report for 2019.
1919-06-06 00:00:00 | C002 |  |  | 128 | 10000 |  |  |  | 20
1919-04-07 00:00:00 | C005 |  |  | 129 | 15000 |  |  |  |  |  | Question 2: |  | Requesting for formula which will detect that the invoice number is already used in the sales Journal.
1919-05-08 00:00:00 | C010 |  |  | 130 | 20000 |  |  |  |  |  |  |  | and is it possible to have formula for incrementing invoice number?
1919-06-01 00:00:00 | C001 |  |  | 131 | 2000
1919-07-02 00:00:00 | C002 |  |  | 132 | 4000 |  |  |  | 10 | 2019 |  | INVOICE
1919-08-03 00:00:00 | C005 |  |  | 133 | 6000 |  |  |  |  | 2020
1919-09-04 00:00:00 | C010 |  |  | 134 | 8000 |  |  |  |  | 2021 |  | Name of Company |  |  |  |  | Date
1919-10-05 00:00:00 | C001 |  |  | 135 | 1000 |  |  |  |  | 2022 |  | Address
1919-11-06 00:00:00 | C002 |  |  | 136 | 2000 |  |  |  |  |  |  | Telephone |  |  |  |  | Invoice Number |  | 144
1919-12-07 00:00:00 | C005 |  |  | 137 | 3000 |  |  |  |  | January
1920-01-08 00:00:00 | C010 |  |  | 138 | 4000 |  |  |  |  | February
2020-01-01 00:00:00 | C001 |  |  | 139 | 80000 | 0.15 |  |  | 20 | March |  | Product Code |  | Product |  | Qnty | Unity Price |  | Total
2020-01-02 00:00:00 | C002 |  |  | 140 | 10000 |  |  |  | 30 | April |  | A-001 |  | Bread |  | 7000 | 1
2020-02-03 00:00:00 | C005 |  |  | 141 | 30000 |  |  |  |  | June |  | S-020 |  | Sugar |  | 1500 | 2
2020-02-04 00:00:00 | C010 |  |  | 142 | 40000
2020-03-05 00:00:00 | C001 |  |  | 143 | 5000 |  |  |  |  |  |  | Total
2020-07-14 00:00:00 | C002 |  |  | 144 | 10000 |  |  |  | 20
Spreadsheet: peter_keavey__28659__BMO Curve
Sheet: Sheet1

 | 2001-11-01 00:00:00
 | 2001-11-02 00:00:00
 | 2001-11-03 00:00:00 | 2.95
 | 2001-11-04 00:00:00 | 2.95
 | 2001-11-05 00:00:00 | 2.95
 | 2001-11-06 00:00:00 | 2.88
 | 2001-11-07 00:00:00 | 2.75
 | 2001-11-08 00:00:00 | 2.74
 | 2001-11-09 00:00:00 | 2.72
 | 2001-11-10 00:00:00
 | 2001-11-11 00:00:00
 | 2001-11-12 00:00:00
 | 2001-11-13 00:00:00
 | 2001-11-14 00:00:00
 | 2001-11-15 00:00:00 | 2.71
 | 2001-11-16 00:00:00
 | 2001-11-17 00:00:00
 | 2001-11-18 00:00:00
 | 2001-11-19 00:00:00
 | 2001-11-20 00:00:00
 | 2001-11-21 00:00:00
 | 2001-11-22 00:00:00
 | 2001-11-23 00:00:00
 | 2001-11-24 00:00:00
 | 2001-11-25 00:00:00
 | 2001-11-26 00:00:00
 | 2001-11-27 00:00:00
 | 2001-11-28 00:00:00
 | 2001-11-29 00:00:00
 | 2001-11-30 00:00:00
Spreadsheet: 854171d1704143283-closest-date-with-criteria-with-maxifs-formula-closestdate
Sheet: Sheet1

Date | Symbol | Closest RS Date |  |  |  | Date | Symbol | [NAME]
2023-12-04 00:00:00 | MULN |  |  |  |  | 2023-05-04 00:00:00 | MULN | 1 for 10
2023-12-05 00:00:00 | ABC |  |  |  |  | 2023-08-11 00:00:00 | MULN | 1 for 20
2023-12-06 00:00:00 | ABC |  |  |  |  | 2023-12-04 00:00:00 | SYTA | 1 for 10
2023-12-07 00:00:00 | ABC |  |  |  | Desired date in cell C2-> | 2023-12-21 00:00:00 | MULN | 1 for 50
2023-12-30 00:00:00 | MULN |  |  |  | Desired date in cell C6 -> | 2023-12-30 00:00:00 | MULN | 1 for 10