tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 102607d1300556660-2-way-lookup-index-or-any-command-2-way-value-lookup
Sheet: Parent Table 

Meters | Month | Year | Tag | Value
17-27A1 | Oct | 2009 | R1 | 0.0006
17-27A1 | Nov | 2009 | R1 | 0.0004
17-27A1 | Dec | 2009 | R1 | 0.0006
17-27A1 | Jan | 2010 | R1 | 0
17-27A1 | Feb | 2010 | R1 | 0.0003
17-27A1 | Mar | 2010 | R1 | 0.0008
17-27A1 | Apr | 2010 | R1 | 0.0006
17-27A1 | May | 2010 | R1 | 0.0009
17-27A1 | Jun | 2010 | R1 | 0.0006
17-27A1 | Oct | 2009 | T1 | 0.75
17-27A1 | Nov | 2009 | T1 | 0.75
17-27A1 | Dec | 2009 | T1 | 0.75
17-27A1 | Jan | 2010 | T1 | 2
17-27A1 | Feb | 2010 | T1 | 0.75
17-27A1 | Mar | 2010 | T1 | 0.75
17-27A1 | Apr | 2010 | T1 | 1
17-27A1 | May | 2010 | T1 | 0.75
17-27A1 | Jun | 2010 | T1 | 0.75
17-27A1 | Oct | 2009 | K1 | 1
17-27A1 | Nov | 2009 | K1 | 1
17-27A1 | Dec | 2009 | K1 | 1
17-27A1 | Jan | 2010 | K1 | 3
17-27A1 | Feb | 2010 | K1 | 1
17-27A1 | Mar | 2010 | K1 | 1
17-27A1 | Apr | 2010 | K1 | 1
17-27A1 | May | 2010 | K1 | 1
17-27A1 | Jun | 2010 | K1 | 1
17-27A1 | Oct | 2009 | R2 | 0.0006
17-27A1 | Nov | 2009 | R2 | 0.0005
17-27A1 | Dec | 2009 | R2 | 0.0007
17-27A1 | Jan | 2010 | R2 | 0
17-27A1 | Feb | 2010 | R2 | 0.0002
17-27A1 | Mar | 2010 | R2 | 0.0009
17-27A1 | Apr | 2010 | R2 | 0.0008
17-27A1 | May | 2010 | R2 | 0.0015
17-27A1 | Jun | 2010 | R2 | 0.0008
17-27A1 | Oct | 2009 | T2 | 1
17-27A1 | Nov | 2009 | T2 | 1
17-27A1 | Dec | 2009 | T2 | 1
17-27A1 | Jan | 2010 | T2 | 2
17-27A1 | Feb | 2010 | T2 | 1
17-27A1 | Mar | 2010 | T2 | 1.5
17-27A1 | Apr | 2010 | T2 | 1.25
17-27A1 | May | 2010 | T2 | 1
17-27A1 | Jun | 2010 | T2 | 1
17-27A1 | Oct | 2009 | K2 | 2
17-27A1 | Nov | 2009 | K2 | 1.5
17-27A1 | Dec | 2009 | K2 | 2
17-27A1 | Jan | 2010 | K2 | 3
17-27A1 | Feb | 2010 | K2 | 2
17-27A1 | Mar | 2010 | K2 | 2
17-27A1 | Apr | 2010 | K2 | 2
17-27A1 | May | 2010 | K2 | 2
17-27A1 | Jun | 2010 | K2 | 2
17-27A1 | Oct | 2009 | R3 | 0.0012
17-27A1 | Nov | 2009 | R3 | 0.0009
17-27A1 | Dec | 2009 | R3 | 0.0015
17-27A1 | Jan | 2010 | R3 | 0
17-27A1 | Feb | 2010 | R3 | 0.0005
17-27A1 | Mar | 2010 | R3 | 0.0058
17-27A1 | Apr | 2010 | R3 | 0.002
17-27A1 | May | 2010 | R3 | 0.003
17-27A1 | Jun | 2010 | R3 | 0.0008
17-27A1 | Oct | 2009 | T3 | 2.5
17-27A1 | Nov | 2009 | T3 | 2.5
17-27A1 | Dec | 2009 | T3 | 2.5
17-27A1 | Jan | 2010 | T3 | 2
17-27A1 | Feb | 2010 | T3 | 2.5
17-27A1 | Mar | 2010 | T3 | 4
17-27A1 | Apr | 2010 | T3 | 2.5
17-27A1 | May | 2010 | T3 | 2.5
17-27A1 | Jun | 2010 | T3 | 2.5
17-27A1 | Oct | 2009 | K3 | 5
17-27A1 | Nov | 2009 | K3 | 5
17-27A1 | Dec | 2009 | K3 | 5
17-27A1 | Jan | 2010 | K3 | 3
17-27A1 | Feb | 2010 | K3 | 5
17-27A1 | Mar | 2010 | K3 | 7
17-27A1 | Apr | 2010 | K3 | 5
17-27A1 | May | 2010 | K3 | 5
17-27A1 | Jun | 2010 | K3 | 5
Spreadsheet: 92801538-044b-40c8-b38c-b3948d1d5108
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
FINTB | Test | FINTB | Interleukin 1b | Interleukin 1-Beta | Direct radioimmunoassay/enzyme immunoassay | EDTA (lavender-top) tube: EDTA Plain, Red-Top or serum gel tube: Red |  |  | 3 | mL | SUBMIT ONLY 1 OF THE FOLLOWING:   Serum Draw blood in a plain, red-top or serum-gel tube(s). Separate immediately and send 3 mL of serum frozen in a plastic vial. Note: 1. Indicate serum on request form.               2. Label specimen appropriately (serum).   [NAME] blood in a lavender-top (EDTA) tube(s). Separate immediately and send 3 mL of EDTA plasma frozen in a plastic vial. Note: 1. Indicate plasma on request form.               2. Label specimen appropriately (plasma).   Patient preparation:            Patient should NOT be on any Corticosteroids,                anti-inflammatory medications or pain killers, if possible,                for at least 48 hours prior to collection of specimen. | 1 mL | Specimens other than	Serum, plasma Anticoagulants other than	EDTA Hemolysis	NA Thawing	Warm reject; Cold reject Lipemia	NA Icteric	NA | Up to 1.00 pg/mL   Test Performed By:  Interscience Institute                                         944 West Hyde Park Blvd                                         Inglewood, CA  90302 | Varies Monday through Friday | 5 days | 7 days | 1 | 83519 |  |  |  |  | Inter Science Institute
FINTB | [NAME] | VARIES | Varies |  |  |  | Frozen | 365 days
FINTB | Result | Z0943 | Interleukin 1-Beta | Interleukin 1-Beta | Numeric |  |  |  |  | pg/mL |  |  |  |  |  |  |  |  |  | 13629-1
Spreadsheet: 152789d1335528378-automaticaly-make-an-exact-copy-of-a-sheet-to-another-sheet-in-another-file-kosten
Sheet: Sheet2

Artikel | Beschrijving | Prijs | Prijs/5 | Prijs/10 | Prijs/50
000.001A | [NAME] | 1.6935 | 8.382825 | 16.240665 | 76.766355
000.001B | [NAME] | 1.6535 | 8.184825 | 15.857065 | 74.953155
000.002A | [NAME] | 1.8535 | 9.174825 | 17.775065 | 84.019155
000.015D | [NAME] | 1.7635 | 8.729325000000001 | 16.911965 | 79.939455
000.815V | Duvel | 1.6235 | 8.036325 | 15.569365 | 73.593255
013.956B | [NAME] | 1.8935 | 9.372825 | 18.158665 | 85.83235499999999
025.842G | [NAME] | 1.5535 | 7.689825000000001 | 14.898065 | 70.42015500000001
41026
4
Spreadsheet: eric_saibi__9870__101901R
Sheet: Mitchell 01

Owner Name |  | American Electric Power Company Incorporated
Station Name |  | Mitchell Power Station
Unit Name |  | Mitchell 01
NERC Region |  | ECAR
State |  | WV
Fuel Type |  | Coal
Capacity |  | 816 MW
Start Date |  | 2001-10-12 00:00:00
End Date |  | 2002-01-04 00:00:00
Prv. Start Date |  | 2001-10-12 00:00:00
Prv. End Date |  | 2001-11-08 00:00:00
Comments |  | Boiler Work
SIC |  | 4911
Plant ID |  | 1017322
Unit ID |  | 1007867
Outage ID |  | 16103
Spreadsheet: 95302d1294922184-modify-sumproduct-and-sumif-formulas-help_123
Sheet: Pivot

 | [NAME]
 |  |  |  |  |  |  |  |  | Supplier
 | GC_Part Number | Part Number | Sub-Part Number | OPCO | Business Unit | Category | Sub-Category | Delivery Location | Supplier 1 | Supplier 2 | Supplier 3 | Supplier 4 | Supplier 5
 |  |  |  |  |  |  |  |  | 1.25 |  |  | 2.22 | 1.04
 |  |  |  |  |  |  |  | Need totals displaying similar information as above such as coverage, quoted vs. total parts, savings, etc
 |  |  |  |  |  |  |  | Model should be sorted by OPCO, then Business Unit, Category, then Sub-Category with sub-totals for each in compact form (a single part is displayed per line)
Spreadsheet: 127616d1320427485-excel-2007-maintain-formula-while-sorting-cells-dummy-beforeandafter-book1
Sheet: BEFORE Cost of Supplies

Iteam # | Beads | Price | Quanity | Notes
BEad0001 | Red 6mm | 2 | 1 | Store A
[NAME] | Blue 6mm | 4 | 1 | Store A
BEad0003 | Green 6mm | 6 | 1 | Store B
BEad0004 | Purple 6mm | 1 | 2 | Store C
BEad0005 | Yellow 6mm | 7 | 5 | Store B
BEad0006 | Brown 6mm | 9 | 2 | Store B
BEad0007 | Black 6mm | 3 | 1 | Store A
 | This is how I originally entered the information, I did not enter it alphabetically
Spreadsheet: 885233d1734674517-the-unique-function-is-not-working-as-expected-problem
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =[NAME],UNIQUE(FILTER(X6:Z6,X6:Z6<>"")))
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Source data |  |  |  | My requirement |  | I tried but failed
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 314 (21) | 314 (21) | 315 (21) |  | 314 (21)+315 (21)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 314 (21) | 314 (21) | 314 (21) |  | 314 (21)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 314 (21) | 315 (21) | 315 (21) |  | 314 (21)+315 (21)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 315 (21) | 315 (21) | 315 (21) |  | 315 (21)
Spreadsheet: 147693d1332934732-how-to-offset-a-vlookup-tabe-array-by-x-columns-vlookup-dynamic-table-array
Sheet: Sheet1

Table number | Data | Vlookup forumla to return #N/A if the number doesn't exist in table x (defined in Column 1)
1 | 11
1 | 3
1 | 6
1 | 12
1 | 6
2 | 20
2 | 5
2 | 1 | #N/A
3 | 1
3 | 3
3 | 12
3 | 13
 |  |  | Vlookup table array:
 |  |  | Table 1 | Table 2 | Table 3 | ….etc
 |  |  | 2 | 5 | 1
 |  |  | 3 | 7 | 3
 |  |  | 5 | 8 | 5
 |  |  | 6 | 11 | 7
 |  |  | 8 | 12 | 12
 |  |  | 11 | 13 | 13
 |  |  | 12 | 18 | 15
 |  |  | 13 | 19
 |  |  | 19 | 20
Spreadsheet: 0471bd3f-0934-4f61-a879-df8d1382f694
Sheet: Sheet1

KIWANIS INTERNATIONAL EXPENSE REPORT |  |  |  |  |  |  |  |  |  | VENDOR #
 |  |  | Name |  |  |  |  |  |  | Travel:Start Date |  |  | End Date
 |  |  |  |  |  |  |  |  |  | Type of Travel:   Local ______    US____     Int'l______
 |  |  |  |  |  |  |  |  |  | Foreign Currency: Country ___________  [NAME] ______
 |  |  | Purpose of Travel/Expense
Day | Date | Destination | Hotel | Personal Meals |  |  | Air/Rail | Car Rent | Auto | Phone | Tolls | Entertainment | Other | Daily Totals
 |  |  |  | [NAME] | Lunch | Dinner | /Bus | /Taxi | Mileage |  | Parking
Item Totals
Submitted By: |  |  | Date |  |  | Expense Report Summary Section: |  |  |  |  | Expense Distribution Summary:
 |  |  |  |  |  |  |  |  |  | Amount | Account Number |  |  | Amount
Approved By: |  |  | Date |  |  | Total Expenses |  |  |  | $ |  |  |  | $
 |  |  |  |  |  | Less: Direct Bill Items
Approved By: |  |  | Date |  |  | Subtotal--Cash Expenses |  |  |  | $
Special Instructions/Return Check to: |  |  |  |  |  | Less: Cash Advance(s)
 |  |  |  |  |  | Subtotal--Due to/from Employee |  |  |  | $
[NAME] | [NAME] | 36328 | 36334 | 315 |  | Finance Dept. Adjustments
 |  |  |  |  |  |  |  |  | Total | $ |  |  | Total | $
Spreadsheet: 851153d1701372020-vlookup-formula-or-let-sample-data-for-lookup
Sheet: Lookup

Movement # | VENDER LOCATION ID 1 | VENDER NAME 1 | VENDER LOCATION ID 2 | VENDER NAME 2
690570 |  | VENDOR-Z002 | [PHONE] | VENDOR-Z003
691724 |  | VENDOR-Z002 | [PHONE] | VENDOR-Z003
710693 |  | VENDOR-Z002 | [PHONE] | VENDOR-Z006
715310 |  | VENDOR-Z006 | [PHONE] | VENDOR-Z009
719458 |  | VENDOR-Z006 | [PHONE] | VENDOR-Z005
727931 |  | VENDOR-Z002 | [PHONE] | VENDOR-Z001
732314 |  | VENDOR-Z006 | [PHONE] | VENDOR-Z003
733287 |  | VENDOR-Z002 | [PHONE] | VENDOR-Z000
734341 |  | VENDOR-Z002 | [PHONE] | VENDOR-Z009
Spreadsheet: 872369d1718770028-choosecols-wont-let-me-use-relative-references-how-can-i-do-this-using-choosecols-function-i-want-the-column-numbers-to-be-relactive
Sheet: Sheet1

Table 1
Name1 | [NAME] | Sex | Place
Erika | Mustermann | (female) | Germany |  |  |  | Mustermann | Germany
[NAME] | Doe | (female) | US |  |  | [NAME] | Doe | US
[NAME] | Smith | (female) | UK |  |  | [NAME] | Smith | UK
[NAME] | Citizen | (female) | Australia |  |  | [NAME] | Citizen | Australia
[NAME] | Dupont | (male) | France |  |  | [NAME] | Dupont | France
[NAME] | Bloggs | (male) | UK |  |  | [NAME] | Bloggs | UK
[NAME] | Canadian | (male) | Canada |  |  | [NAME] | Canadian | Canada
[NAME] | Doe | (male) | US |  |  | [NAME] | Doe | US
[NAME] | Smith | (male) | UK |  |  | [NAME] | Smith | UK
[NAME] | Citizen | (male) | Australia |  |  | [NAME] | Citizen | Australia
[NAME] | Murphy | (male) | Ireland |  |  | [NAME] | Murphy | Ireland
[NAME] | Murphy | (female) | Ireland |  |  | [NAME] | Murphy | Ireland
[NAME] | Mustermann | (male) | Germany |  |  | [NAME] | Mustermann | Germany
Otto | Normalverbraucher | (male) | Germany |  |  | Otto | Normalverbraucher | Germany
Mario | Rossi | (male) | Italy |  |  | Mario | Rossi | Italy
[NAME] | [NAME] | (male) | Russia |  |  | [NAME] | [NAME] | Russia
Maria | Ivanova | (female) | Russia |  |  | Maria | Ivanova | Russia
Table 13 |  |  |  |  |  | Actual Outcome |  |  |  | Desired Outcome
Name1 | Middle Name | [NAME] | Sex | Place
Erika |  | Mustermann | (female) | Germany |  |  | 0 | (female) |  |  | Mustermann | Germany
[NAME] |  | Doe | (female) | US |  | [NAME] | 0 | (female) |  | [NAME] | Doe | US
[NAME] |  | Smith | (female) | UK |  | [NAME] | 0 | (female) |  | [NAME] | Smith | UK
[NAME] |  | Citizen | (female) | Australia |  | [NAME] | 0 | (female) |  | [NAME] | Citizen | Australia
[NAME] |  | Dupont | (male) | France |  | [NAME] | 0 | (male) |  | [NAME] | Dupont | France
[NAME] |  | Bloggs | (male) | UK |  | [NAME] | 0 | (male) |  | [NAME] | Bloggs | UK
[NAME] |  | Canadian | (male) | Canada |  | [NAME] | 0 | (male) |  | [NAME] | Canadian | Canada
[NAME] |  | Doe | (male) | US |  | [NAME] | 0 | (male) |  | [NAME] | Doe | US
[NAME] |  | Smith | (male) | UK |  | [NAME] | 0 | (male) |  | [NAME] | Smith | UK
[NAME] |  | Citizen | (male) | Australia |  | [NAME] | 0 | (male) |  | [NAME] | Citizen | Australia
[NAME] |  | Murphy | (male) | Ireland |  | [NAME] | 0 | (male) |  | [NAME] | Murphy | Ireland
[NAME] |  | Murphy | (female) | Ireland |  | [NAME] | 0 | (female) |  | [NAME] | Murphy | Ireland
[NAME] |  | Mustermann | (male) | Germany |  | [NAME] | 0 | (male) |  | [NAME] | Mustermann | Germany
Otto |  | Normalverbraucher | (male) | Germany |  | Otto | 0 | (male) |  | Otto | Normalverbraucher | Germany
Mario |  | Rossi | (male) | Italy |  | Mario | 0 | (male) |  | Mario | Rossi | Italy
[NAME] |  | [NAME] | (male) | Russia |  | [NAME] | 0 | (male) |  | [NAME] | [NAME] | Russia
Maria |  | Ivanova | (female) | Russia |  | Maria | 0 | (female) |  | Maria | Ivanova | Russia
Spreadsheet: 780564d1652544804-excel-crashes-usng-this-formula-2-upload-compact-2022-mai
Sheet: Sheet1

 |  |  | [NAME]
 |  |  | Japan | Germany | USA | Italy | number |  | Japan | Germany | USA | Italy | number
Germany | BMW |  |  |  |  |  |  |  | Nissan | BMW | Jeep | Ferrari | 2435
 |  |  |  |  |  |  |  |  | Honda | Porsche | Ford | Pagani | 3546
Germany | Porsche |  |  |  |  |  |  |  | Toyota | Mercedes-Benz | Buick | Mazzanti | 0
USA | Jeep |  |  |  |  |  |  |  | Subaru | Audi | Chevrolet | Lamborghini | 777323
Japan | Nissan |  |  |  |  |  |  |  |  | Volkswagen | GMC | Maserati
Italy | Ferrari |  |  |  |  |  |  |  |  | Opel |  | [NAME]
number | 2435
Italy | Pagani
USA | Ford
USA | Buick
Japan | Honda
USA | Chevrolet
Italy | Mazzanti
Japan | Toyota
Germany | Mercedes-Benz
Germany | Audi
USA | GMC
Japan | Subaru
Germany | Volkswagen
Italy | Lamborghini
Italy | Maserati
number | 3546
Germany | Opel
number | 777323
Italy | [NAME]
Spreadsheet: 74204d1274782176-copy-and-paste-to-a-new-line-invoicingtool
Sheet: Invoice

 |  |  |  | INVOICE
 | Test Business |  | DATE: | 2010-05-25 00:00:00
 | 1234 Main Street |  | INVOICE # | 5
 | City, Province
 | Phone: [PHONE] |  | FOR: | Landscaping
 | [EMAIL]
 |  |  | BILL TO: | [NAME]
 |  |  |  | Devstudios
 |  |  |  | 6015 Golden Sunset Ct
 |  |  |  | Bakersfield, CA  93313
 |  |  |  | [PHONE]
 | [NAME] |  |  | AMOUNT
 | whatever |  |  | 235
 | watever else |  |  | 123
 | something else |  |  | 3215.32
 |  |  | SUBTOTAL | 3573.32
 |  |  | PST | 178.67 | 0.05
 |  |  | GST | 178.67 | 0.05
 |  |  | OTHER
 |  |  | TOTAL | 3930.66
Spreadsheet: 845843d1697177221-filter-formula-help-help
Sheet: Sheet1

[NAME] by Profile & Channel
REF FIELD FOM RAWDATA | COL
Agency |  | applies to all tables
[NAME] |  | applies to all tables
[NAME]
REF FIELD FOM RAWDATA | COL
Type_of_product_bought
[NAME] (don't touch)
 | Product 1 | Product 2 | Product 3 | Product 4 | Product 5 | Errors | TOTAL | IDs with issues
Company 3 | 2 | 0 | 0 | 1 | 0 | 1 | 4
Spreadsheet: 98086d1297159203-excel-lookup-for-to-return-multiple-approximate-matches-book4
Sheet: Sheet2

BigMouth | 6 |  | BigMouth | BigMouth AG | BigMou | 0 | 0 | 0
Mon | 6 |  | BigMouth | BigMouth AG | BigMou | 0 | 0 | 0
 |  |  | BigMouth | BigMouth AG | BigMou | 0 | 0 | 0
 |  |  | BigMouth | BigMouth AG | BigMou | 0 | 0 | 0
0 |  |  | BigMouth | BigMouth AG | BigMou | 0 | 0 | 0
0 |  |  | BigMouth | BigMouth AG | BigMou | 0 | 0 | 0
0 |  |  | BigMouth | BigMouth AG | BigMou | 0 | 0 | 0
 |  |  | BigMouth | BigMouth AG | BigMou | 0 | 0 | 0
 |  |  | BigMouth | BigMouth AG | BigMou | 0 | 0 | 0
Spreadsheet: 738020d1624766359-capturing-down-events-with-dates-downtime-calc-test-ans
Sheet: Sheet1

TIME | Running |  | Down (in Min)
2021-12-01 05:00:00 | 0 |  |  |  | Down Events | From What Time | Total Min |  |  |  | In Hours |  | Down Events | From What Time | Total Min
2021-12-01 05:01:00 | 0 |  |  |  | 1 |  |  |  |  | Total Down |  |  | 1 | 12/1/2021  5:00:00 AM to 12/1/2021  5:19:00 AM | 20
2021-12-01 05:01:59.990000 | 0 |  |  |  | 2 |  |  |  |  |  |  |  | 2 | ???? | ??
2021-12-01 05:02:59.985000 | 0 |  |  |  | 3 |  |  |  |  |  |  |  | 3 | ??? | ??
2021-12-01 05:03:59.980000 | 0 |  |  |  | 4
2021-12-01 05:04:59.975000 | 0 |  |  |  | 5
2021-12-01 05:05:59.970000 | 0
2021-12-01 05:06:59.965000 | 0
2021-12-01 05:07:59.960000 | 0
2021-12-01 05:08:59.955000 | 0
2021-12-01 05:09:59.950000 | 0
2021-12-01 05:10:59.945000 | 0
2021-12-01 05:11:59.940000 | 0
2021-12-01 05:12:59.935000 | 0
2021-12-01 05:13:59.930000 | 0
2021-12-01 05:14:59.925000 | 0
2021-12-01 05:15:59.920000 | 0
2021-12-01 05:16:59.915000 | 0
2021-12-01 05:17:59.910000 | 0
2021-12-01 05:19:00 | 0
2021-12-01 05:19:59.900000 | 7866
2021-12-01 05:20:59.895000 | 7866
2021-12-01 05:21:59.890000 | 7866
2021-12-01 05:22:59.885000 | 7866
2021-12-01 05:23:59.880000 | 7866
2021-12-01 05:24:59.875000 | 7866
2021-12-01 05:25:59.870000 | 0
2021-12-01 05:26:59.865000 | 0
2021-12-01 05:27:59.860000 | 0
2021-12-01 05:28:59.855000 | 0
2021-12-01 05:29:59.850000 | 0
2021-12-01 05:30:59.845000 | 7866
2021-12-01 05:31:59.840000 | 0
2021-12-01 05:32:59.835000 | 0
2021-12-01 05:33:59.830000 | 0
Spreadsheet: 4daa2e2c-2c3f-42a5-994e-fef400576f36
Sheet: Sheet1

Principal farm operator household finances, by ERS farm typology, 2011 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Item | Residence farms | Intermediate farms | Commercial farms | All
 | Number
Number of farms | 1254256.08801553 | 640990.539426687 | 219421.674084244 | 2114668.30152646
 | Income, median dollars per household
Farm income | -3244 | -1897 | 84649 | -2250
Off-farm income | 67500 | 41250 | 29250 | 53424
Earned Income | 53218 | 17500 | 12500 | 32500
Unearned Income | 8750 | 17991 | 2750 | 12500
Total household income | 61260 | 45889 | 127009 | 57050
 | Income, average dollars per household
Farm income | -4644.37764760417 | 4320.55536147265 | 154859.468104543 | 14623.4375808229
Off-farm income | 88455.3794296825 | 49404.8834717016 | 50355.7528706301 | 72665.2518307328
Earned Income | 66259.7019037609 | 27564.2375514347 | 35861.4638548277 | 51376.2997041097
Unearned Income | 22195.6775259215 | 21840.6459202667 | 14494.2890158026 | 21288.952126623
Total household income | 83811.0017820782 | 53725.4388331739 | 205215.220975174 | 87288.6894115559
 | Balance sheet, median dollars per household
Total household assets | 559176 | 710955 | 2227713 | 672500
Farm assets | 322716 | 501945 | 1973951 | 412300
Non-farm assets | 184881 | 151653 | 172806 | 178500
Total household debt | 17925 | 30975 | 207576 | 34300
Farm debt | 500 | 1038 | 145896 | 800
Non-farm debt | 750 | 0 | 250 | 250
Household net worth | 493025 | 640376 | 1924793 | 597767
 | Balance sheet, average dollars per household
Total household assets | 799466.506065688 | 1040573.06306457 | 3295303.58315786 | 1131522.25741934
Farm assets | 502865.056389409 | 818806.195011424 | 2988918.40934402 | 856589.216769796
Non-farm assets | 296601.449676278 | 221766.868053147 | 306385.173813839 | 274933.040649547
Total household debt | 83887.5691267944 | 80183.9872775941 | 444792.729133737 | 120213.102266713
Farm debt | 27251.9504079332 | 46663.5382546723 | 376616.060371547 | 69386.549944826
Non-farm debt | 56635.6187188614 | 33520.4490229218 | 68176.6687621883 | 50826.552321888
Household net worth | 715578.936938892 | 960389.075786978 | 2850510.85402412 | 1011309.15515262
Source:  2011 USDA Agricultural Resource Management Survey.
Spreadsheet: 881575d1729683035-highlight-closest-value-show-difference
Sheet: Example

NO: | LN1: | LN2: |  | PIN1 | PIN2 | PIN READ:
1 | 2245.49 | 2229.9 |  | 2489 | 252.2 | 2236.8 |  |  |  |  | CF formula: =ABS($G2-B2)=MIN(ABS($G2-$B2:$C2))
2 | 2237.55 | 2246.39 |  | 2519 | 279.7 | 2239.3 |  |  |  |  | Applies to: =$[NAME]
3 | 2159.98 | 2421.63 |  | 2674 | 242.4 | 2431.6
4 | 2285.18 | 2249.69 |  | 2508 | 220.8 | 2287.2
5 | 2300.39 | 2311.6 |  | 2564 | 246
6 | 1139.12 | 1167.35 |  | 1416 | 244.1 | 1171.9
7 | 1202.1 | 1167.87 |  | 1451 | 248.7 | 1202.3
8 | 1178.85 | 1189.09 |  | 1414 | 217.6
THE FORMULA WOULD SHOW THE CLOSEST TO PIN READ (EITHER LN1 OR LN2 IN EACH ROW)
NO: | LN1: | LN2: |  | PIN1 | PIN2 | PIN READ:
1 | 2245.49 | 2229.9 |  | 2489 | 252.2 | 2236.8
2 | 2237.55 | 2246.39 |  | 2519 | 279.7 | 2239.3
3 | 2159.98 | 2421.63 |  | 2674 | 242.4 | 2431.6
4 | 2285.18 | 2249.69 |  | 2508 | 220.8 | 2287.2
5 | 2300.39 | 2311.6 |  | 2564 | 246
6 | 1139.12 | 1167.35 |  | 1416 | 244.1 | 1171.9
7 | 1202.1 | 1167.87 |  | 1451 | 248.7 | 1202.3
8 | 1178.85 | 1189.09 |  | 1414 | 217.6
Spreadsheet: 43751d1242360031-viewing-multiple-worksheets-on-one-main-worksheet-solutioncalendar
Sheet: MayChild

Select The Month & Type of Calendar
Month | Type
GuideLine |  | Click to Go on Specific Calendar
CYPD TRAINING MAY  2009
Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday
 |  |  |  |  |  |  |  |  |  | 2009-05-01 00:00:00 |  | 2009-05-02 00:00:00
2009-05-03 00:00:00 |  | 2009-05-04 00:00:00 |  | 2009-05-05 00:00:00 |  | 2009-05-06 00:00:00 |  | 2009-05-07 00:00:00 |  | 2009-05-08 00:00:00 |  | 2009-05-09 00:00:00
2009-05-10 00:00:00 |  | 2009-05-11 00:00:00 |  | 2009-05-12 00:00:00 |  | 2009-05-13 00:00:00 |  | 2009-05-14 00:00:00 |  | 2009-05-15 00:00:00 |  | 2009-05-16 00:00:00
2009-05-17 00:00:00 |  | 2009-05-18 00:00:00 |  | 2009-05-19 00:00:00 |  | 2009-05-20 00:00:00 |  | 2009-05-21 00:00:00 |  | 2009-05-22 00:00:00 |  | 2009-05-23 00:00:00
2009-05-24 00:00:00 |  | 2009-05-25 00:00:00 |  | 2009-05-26 00:00:00 |  | 2009-05-27 00:00:00 |  | 2009-05-28 00:00:00 |  | 2009-05-29 00:00:00 |  | 2009-05-30 00:00:00
2009-05-31 00:00:00 |  |  |  |  |  |  |  |  |  | Notes:
Spreadsheet: 820385d1678080163-extract-2-x-specific-characters-one-text-one-numeric-from-a-cell-in-excel-365-extract-data
Sheet: Sheet1

 |  | extract  2 x specific characters, one text, one numeric  from a extisting data cell in excel 365
 |  | Data in single cell |  | Expected Outcome |  |  | Formulae does not work
 |  | Wearne   Hayden  - O4 - AAA |  | O4
 |  | Prendergast   Eddie  - O4 - WEL |  | O4
 |  | [NAME]  aviee - O4 - NTT |  | O4 |  |  | =TEXTAFTER(C7, {"O", ","S","; "})
 |  | [NAME] |  | [NAME]
 |  | Strathmore  Edward - S4 - ASA |  | [NAME]
 |  | Data in single cell | Text Between Delimiters
 |  | Wearne   Hayden  - O4 - AAA | O4
 |  | Prendergast   Eddie  - O4 - WEL | O4
 |  | [NAME]  aviee - O4 - NTT | O4
 |  | [NAME] | [NAME]
 |  | Strathmore  Edward - S4 - ASA | [NAME]