tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: richard_sanders__31924__Intrust_pmts
Sheet: Sheet1

Enron Economic Development Corp.
Expenditures to Intrust
Date | Amount | Paid By | Description
1999-01-01 00:00:00 | 80000 | ECT | Advance - Repaid May 1999
1999-03-04 00:00:00 | 7659.33 | CCC | Reimburse CCC expenses
1999-03-18 00:00:00 | 7438.99 | CCC | Reimburse CCC expenses
1999-04-15 00:00:00 | 17397.14 | CCC | Reimburse CCC expenses
 | 150000 | CCC | Purchase of CCC from Intrust
1999-04-30 00:00:00 | 199000 | HEOF | Partnership Formation Fees
1999-04-30 00:00:00 | 37312.5 | HEOF | Partnership Management Fees
1999-06-01 00:00:00 | 16759.99 | HEOF | Legal fees associated with HEOF
1999-08-06 00:00:00 | 30855 | HEOF | [NAME]less $6,645 to fund GP interest
 |  |  | Total
Spreadsheet: 790086d1659533088-countifs-with-multiple-criteria-formula-mock-up
Sheet: Balancing - Support

Employee | Employee2 | Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10 | Column11 | Column12 | Column13 | Column14 | Column15 | Column16 | Column17 | Column18 | Column19 | Column20 | Column21 | Column22 | Column23 | Column24 | Column25 | Column26 | Column27 | Column28 | Column29 | Column30 | Column31 | Column32 | Column33 | Column34 | Column35 | Column36 | Column37 | Column38 | [NAME] | Column40 | Column41 | Column42 | Column43 | Column44 | Column45 | Column46 | Column47 | Column48 | Column49 | Column50 | Column51 | Column52 | Column53 | Column54 | Column55 | Column56 | Column57 | Column58 | Column59 | Column60 | Column61 | Column62 | Column63 | Column64 | Column65 | Column66 | Column67 | Column68 | Column69 | Column70 | Column71 | Column72 | Column73 | Column74 | Column75 | Column76 | Column77 | Column78 | Column79 | Column80 | Column81 | Column82 | Column83 | Column84
Spreadsheet: 1a687800-02a8-4b17-8949-dce8cd570f5f
Sheet: Códigos

[NAME] (CCRCODE)
1 | [NAME]
2 | CCDR Centro
3 | CCDR Lisboa e Vale do Tejo
4 | [NAME]
5 | Algarve
[NAME] (DISTRICTCODE)
1 | Aveiro
2 | Beja
3 | Braga
4 | Bragança
5 | [NAME]
6 | Coimbra
7 | [NAME]
8 | Faro
9 | [NAME]
10 | Leiria
11 | [NAME]
12 | Portalegre
13 | Porto
14 | Santarém
15 | Setúbal
16 | [NAME] do [NAME]
17 | Vila Real
18 | Viseu
19 | Açores
20 | Madeira
Spreadsheet: 845292d1696838370-data-cleansing-data-cleansing-aligw
Sheet: גיליון6

Table Name - Conversion |  |  |  | Table Name - MyList
Find | Replace |  |  | List For Cleaning |  |  | List after cleaning |  | Desired output
Alabama | AL |  |  | Alabama- United States |  |  |  |  | U.S.A, AL
Georgia | GA |  |  | Alaska, U.S |  |  |  |  | U.S.A - Ala
Kansas | KS |  |  | U.S- Arizona |  |  |  |  | U.S.A - Ari
New Mexico | NM |  |  | U.S.A/ California |  |  |  |  | U.S.A - Cal
New York | NY |  |  | United States Of ;Florida |  |  |  |  | U.S.A - Flo
Pennsylvania | PA |  |  | Georgia ;United States |  |  |  |  | U.S.A, GA
Texas | TX |  |  | Kansas   U.S |  |  |  |  | U.S.A, KS
Virginia | VA |  |  | United States  Louisiana |  |  |  |  | U.S.A - Lou
United States Of |  |  |  | U.S /  Maine |  |  |  |  | U.S.A - Mai
- |  |  |  | U.S.A #  Maryland |  |  |  |  | U.S.A - Mar
, |  |  |  | New Mexico -  United States |  |  |  |  | U.S.A, NM
# |  |  |  | New York -  United States |  |  |  |  | U.S.A, NY
/ |  |  |  | Pennsylvania /  U.S.A |  |  |  |  | U.S.A, PA
. |  |  |  | Texas / |  |  |  |  | U.S.A, TX
USA |  |  |  | Virginia# |  |  |  |  | U.S.A, VA
US
;
United States
Spreadsheet: 888935d1739559200-template-for-weekly-schedule-that-will-look-like-my-example-weekly-schedule-working-template
Sheet: Printable Table

Continental Services - Arizona |  | Continental Services - Arizona
Monday |  | Tuesday
2022-10-03 00:00:00 |  | 2022-10-04 00:00:00
Day |  | FM Morenci
FM Morenci |  | 2410 Belt Replacement
2410 Belt Replacement |  | XXXXXXXXXX/1234567
XXXXXXXXXX/1234567 |  | [LEAD] Barnes, Chase
[LEAD] Barnes, Chase |  | Currier, Stephen
Night |  | FM Safford
FM Morenci |  | 2420 Saddle Repair
2410 Belt Replacement |  | XXXXXXXXXX/4567890
XXXXXXXXXX/1234567 |  | Cape, Brage
Currier, Stephen |  | Driver, [NAME]
(blank)
FM Safford
2420 Saddle Repair
XXXXXXXXXX/4567890
Cape, Brage
Spreadsheet: 24464d1214887278-simple-problem-sum-of-certain-fields-accross-several-books-online-connect-reg
Sheet: Vodafone

 |  |  | Vodafone Connections - MARCH 2008
No: | Date | Customer Name | Rate Plan | Model | IMEI | Mobile No. | BAN | Staff | Staff Comms | Total Comms | Handset Cost | Upfront | GP
MTD |  |  |  |  |  |  |  |  |  |  |  |  | 0
1 |  |  |  |  |  |  |  |  |  |  |  |  | 0
2 |  |  |  |  |  |  |  |  |  |  |  |  | 0
3 |  |  |  |  |  |  |  |  |  |  |  |  | 0
4 |  |  |  |  |  |  |  |  |  |  |  |  | 0
5 |  |  |  |  |  |  |  |  |  |  |  |  | 0
6 |  |  |  |  |  |  |  |  |  |  |  |  | 0
7 |  |  |  |  |  |  |  |  |  |  |  |  | 0
8 |  |  |  |  |  |  |  |  |  |  |  |  | 0
9 |  |  |  |  |  |  |  |  |  |  |  |  | 0
10 |  |  |  |  |  |  |  |  |  |  |  |  | 0
11 |  |  |  |  |  |  |  |  |  |  |  |  | 0
12 |  |  |  |  |  |  |  |  |  |  |  |  | 0
13 |  |  |  |  |  |  |  |  |  |  |  |  | 0
14 |  |  |  |  |  |  |  |  |  |  |  |  | 0
15 |  |  |  |  |  |  |  |  |  |  |  |  | 0
16 |  |  |  |  |  |  |  |  |  |  |  |  | 0
17 |  |  |  |  |  |  |  |  |  |  |  |  | 0
18 |  |  |  |  |  |  |  |  |  |  |  |  | 0
19 |  |  |  |  |  |  |  |  |  |  |  |  | 0
20 |  |  |  |  |  |  |  |  |  |  |  |  | 0
21 |  |  |  |  |  |  |  |  |  |  |  |  | 0
22 |  |  |  |  |  |  |  |  |  |  |  |  | 0
23 |  |  |  |  |  |  |  |  |  |  |  |  | 0
24 |  |  |  |  |  |  |  |  |  |  |  |  | 0
25 |  |  |  |  |  |  |  |  |  |  |  |  | 0
26 |  |  |  |  |  |  |  |  |  |  |  |  | 0
27 |  |  |  |  |  |  |  |  |  |  |  |  | 0
28 |  |  |  |  |  |  |  |  |  |  |  |  | 0
29 |  |  |  |  |  |  |  |  |  |  |  |  | 0
30 |  |  |  |  |  |  |  |  |  |  |  |  | 0
31 |  |  |  |  |  |  |  |  |  |  |  |  | 0
32 |  |  |  |  |  |  |  |  |  |  |  |  | 0
33 |  |  |  |  |  |  |  |  |  |  |  |  | 0
34 |  |  |  |  |  |  |  |  |  |  |  |  | 0
35 |  |  |  |  |  |  |  |  |  |  |  |  | 0
36 |  |  |  |  |  |  |  |  |  |  |  |  | 0
37 |  |  |  |  |  |  |  |  |  |  |  |  | 0
38 |  |  |  |  |  |  |  |  |  |  |  |  | 0
39 |  |  |  |  |  |  |  |  |  |  |  |  | 0
40 |  |  |  |  |  |  |  |  |  |  |  |  | 0
41 |  |  |  |  |  |  |  |  |  |  |  |  | 0
42 |  |  |  |  |  |  |  |  |  |  |  |  | 0
43 |  |  |  |  |  |  |  |  |  |  |  |  | 0
44 |  |  |  |  |  |  |  |  |  |  |  |  | 0
45 |  |  |  |  |  |  |  |  |  |  |  |  | 0
46 |  |  |  |  |  |  |  |  |  |  |  |  | 0
47 |  |  |  |  |  |  |  |  |  |  |  |  | 0
48 |  |  |  |  |  |  |  |  |  |  |  |  | 0
49 |  |  |  |  |  |  |  |  |  |  |  |  | 0
50 |  |  |  |  |  |  |  |  |  |  |  |  | 0
51 |  |  |  |  |  |  |  |  |  |  |  |  | 0
52 |  |  |  |  |  |  |  |  |  |  |  |  | 0
53 |  |  |  |  |  |  |  |  |  |  |  |  | 0
54 |  |  |  |  |  |  |  |  |  |  |  |  | 0
55 |  |  |  |  |  |  |  |  |  |  |  |  | 0
56 |  |  |  |  |  |  |  |  |  |  |  |  | 0
57 |  |  |  |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: 0f46019c-11ef-40b3-82bb-fdce837e6ca5
Sheet: Sheet1

Expense & Travel Voucher | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 | 5550 [NAME], Suite 120
 | [NAME], IL  60008
 | Phone: 847/956-0900
 | Fax: 847/956-0999
Name: |  |  |  |  |  | Trip/Meeting Purpose: |  | 2013 Preceptorship Program
Address:
Social Security or Tax ID Number #: ______________________
Location(s): |  |  |  |  |  |  | Date(s):
Preceptor:
 |  |  |  |  |  | DATES:
Expenses Paid |  |  |  |  |  |  |  |  |  | $
by [NAME]: |  |  |  |  |  |  |  |  |  | Total:
Ground | Transport:
Lodging:
Food:
Other:
Airfare:
(Less):
Personal Expenses
Total Expenses
Paid by [NAME]:
 |  |  |  |  |  |  | RECAP OF EXPENSES PAID BY TRAVELER
 |  |  |  |  |  |  |  |  | TOTAL EXPENSES PAID:
660-52
ACCOUNT CODE |  |  |  |  |  |  |  |  | LESS PERSONAL:
 |  |  |  |  |  |  |  |  | NET DUE TO TRAVELER:
 |  |  | Katasha Charleston |  |  |  |  |  | Awarded | ____________
ASDS APPROVAL SIGNATURE
Please attach documentation for all expenses in excess of $25.00 |  |  |  |  |  |  |  | SIGNATURE OF TRAVELER
 |  |  |  | GUIDELINES FOR EXPENSES
APPROVAL |  |  | Supervisor approval must be obtained.
BUSINESS PURPOSE |  |  | Reason for expense must be indicated.
AIRFARE |  |  | Air fare should be computed at coach class via the most direct route.
 |  |  | Exclude from Net Due To(From) [NAME] if direct billed.
GROUND TRANSPORTATION |  |  | Reimbursement will be made for necessary taxi, limousine, and bus service
 |  |  | incurred due to company business.  Rail travel should be via the most direct route.
 |  |  | Auto expense will be reimbursed at 56.5 cents per mile.
 |  |  | Please reflect computation below indicating miles driven.
LODGING |  |  | Attach hotel bills.  If housing expense is to be billed directly, please
 |  |  | pay all personal charges (spouse's charges, movies, phone, etc.) before
 |  |  | signing bill.
FOOD |  |  | All meals will be paid at cost.  Scheduled meals during meetings will be charged
 |  |  | to the company's master account.  [NAME] added to bills are not to exceed 15%.
 |  |  | Persons in attendance at meal must be indicated.
OTHER |  |  | Tips, telephone calls, etc. will be reimbursed when related directly to company
 |  |  | business.  Travel insurance is not reimbursed since the company maintains a
 |  |  | $100,000 travel-accident policy, which covers accidental death, disability or
 |  |  | dismemberment for persons traveling on company business.
SUPPORTING DOCUMENTS |  |  | Expenses over $25.00 must have supporting documents.
 |  |  | Attach all receipts received, indicating on each the necessary information per above.
 |  |  | MISCELLANEOUS NOTES, COMPUTATIONS, ETC.
$
Amount |  |  | Description
Spreadsheet: 760007d1639908445-family-numbering-family-numbering-ans
Sheet: Sheet1

 |  | NAME
 |  | A
 |  | B
 |  | C
 |  | D
 |  | E
 |  | F
 |  | G
 |  | H
 |  | I
 |  | J
 |  | K
 |  | L
 |  | TO BE CONTINUE
Spreadsheet: 298161d1392726822-highlight-cells-on-sheet-1-if-the-text-is-also-on-sheet-2-example-1-altered
Sheet: Sheet1

a | b | c
Elegant Moments Hosiery Catalogue | [NAME]
Elegant Moments Hosiery Catalogue | [NAME]
Elegant Moments 2013 Costume | 2013EMCost
Elegant Moments 2013 Costume | 2013EMCost
70 Denier Opaque Tights | 70Den
70 Denier Opaque Tights | 70Den
70 Denier Opaque Tights | 70Den
70 Denier Opaque Tights | 70Den
Lace Open Back Panty | A-Abbigail
Lace Open Back Panty | A-Abbigail
Lace Open Back Panty | A-Abbigail
Lace Open Back Panty | A-Abbigail
Lace Open Back Panty | A-Abbigail
Lace Open Back Panty | A-Abbigail
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
Floral Lace French Knickers | A-Agnes
Floral Lace French Knickers | A-Agnes
Floral Lace French Knickers | A-Agnes
Floral Lace French Knickers | A-Agnes
Floral Lace French Knickers | A-Agnes
Floral Lace French Knickers | A-Agnes
Spreadsheet: 42080d1240606605-automatically-keeping-rows-sorted-in-alphabetical-order-indirect
Sheet: Sheet1

Range to Sum | E:E |  | 1 | 4
Total | 15 |  | 2 | 5
 |  |  | 3 | 6
Try the following values in Cell B1
E:E
D1:E2
E1
D2
etc
Here's an example that will refer to a different sheet
Sheet to reference | Sheet1
Range to sum | D:D
Full reference | [NAME]
Total | 6
Try
Sheet2
Sheet3
Spreadsheet: darrell_schoolcraft__7297__imball0112
Sheet: WTG

 | /------------------------------------------  contract 22100  --------------------------------------------------------\ |  |  |  |  |  |  |  | /------------------------------------------------------------------------------------------------  contract 21816  -----------------------------------------------------------------\
 | 10811 |  | 13234 |  | 16540 |  | 500648 |  | 10518 |  | 13276 |  | 13475 |  | 500176 |  | 500390 |  | 500612
 | Follet |  | Oasis Dairy Farms |  | WTG/TW Winker |  | Sum WTG New Mex |  | [NAME] |  | Fred Born |  | WT Tx Water System |  | [NAME] |  | WT Tx Water System |  | [NAME]
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | -107 | -150 |  |  | -778 | -1001 |  | -2
2 | -84 | -150 |  |  | -696 | -1001 |  | -2
3 | -57 | -150 |  |  | -532 | -1001 |  | -2
4 | -51 | -150 |  |  | -477 | -1001 |  | -2
5 | -79 | -150 |  |  | -615 | -1001 |  | -2
6 | -85 | -150 |  |  | -674 | -1001 |  | -2
7 | -106 | -150 |  |  | -853 | -1001 |  | -2
8 | -131 | -150 |  |  | -1087 | -1001 |  | -2
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-11-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -10558
2001-12-08 00:00:00
CBS Volume
 |  |  | 5317
Spreadsheet: 739949d1626099443-replacing-only-text-between-quotes-book1
Sheet: Sheet1

Initial text | Replace with | Desired Result
[TEA]: 'TEA', | ONE | [TEA]: 'ONE',
[WATER]: 'WATER', | TWO | [WATER]: 'TWO',
[WINE]: 'WINE', | THREE | [WINE]: 'THREE',
{ label: 'White Vinegar', value: 'White Vinegar' }, | Four | { label: 'Four', value: 'Four' },
{ label: '[NAME], value: '[NAME] }, | Five | { label: 'Five', value: 'Five' },
{ label: 'Malt Vinegar', value: 'Malt Vinegar' }, | Six | { label: 'Six', value: 'Six' },
Spreadsheet: 696964d1601051840-counting-occurrences-in-a-5-day-work-week-pdt-rule-calc
Sheet: Sheet1

PDTRule | Day | Date | Trade Type
1 |  | 2020-08-19 00:00:00 | Day |  | 5 day rolling work week (mon - fri) how many "Day" in column 'D' have occurred in previous 5 days (not including weekends)
 |  | 2020-08-21 00:00:00 | O/N
2 |  | 2020-08-24 00:00:00 | Day |  | What I want is column 'A' to produce a 0, 1, 2, 3 depending on how many have occurred in the past 5 workdays
3 |  | 2020-08-24 00:00:00 | Day
4 |  | 2020-08-24 00:00:00 | Day |  | I think that is how column 'A' Should look …
5 |  | 2020-08-25 00:00:00 | Day
 |  | 2020-08-25 00:00:00 | O/N
 |  | 2020-08-25 00:00:00 | O/N
 |  | 2020-08-26 00:00:00 | O/N
 |  | 2020-08-29 00:00:00 | O/N
2 |  | 2020-08-31 00:00:00 | Day
 |  | 2020-08-31 00:00:00 | O/N
 |  | 2020-09-01 00:00:00 | O/N
2 |  | 2020-09-02 00:00:00 | Day
1 |  | 2020-09-09 00:00:00 | Day
2 |  | 2020-09-10 00:00:00 | Day
3 |  | 2020-09-15 00:00:00 | Day
 |  | 2020-09-15 00:00:00 | O/N
 |  | 2020-09-16 00:00:00 | O/N
 |  | 2020-09-22 00:00:00 | O/N
 |  | 2020-09-22 00:00:00 | O/N
1 |  | 2020-09-23 00:00:00 | Day
2 |  | 2020-09-23 00:00:00 | Day
3 |  | 2020-09-23 00:00:00 | Day
Spreadsheet: 755527d1636934494-how-to-cal-monthly-salary-for-mid-hire-termination-using-sumifs-or-sumproduct-headcount-test-_-test-shrihanuman-
Sheet: Tables

 | Year: | 2021
 | FX rate
 | Currency_Code | Global_Rate_00 | to USD |  |  |  |  |  |  | Currency/USD | Price |  |  | USD/Currency | Price
 | AUD | 1.3425 |  |  |  |  |  |  |  | #[NAME]! |  |  |  | #[NAME]!
 | CAD | 1.295 |  |  |  |  |  |  |  | #[NAME]! |  |  |  | #[NAME]!
 | CHF | 0.91 |  |  |  |  |  |  |  | #[NAME]! |  |  |  | #[NAME]!
 | [NAME] | 761.25 |  |  |  |  |  |  |  | #[NAME]! |  |  |  | #[NAME]!
 | CNY | 6.5825 |  |  |  |  |  |  |  | #[NAME]! |  |  |  | #[NAME]!
 | COP |  | 0.00026 | FX @ 9/13/2021 |  |  |  |  |  | #[NAME]! |  |  |  | #[NAME]!
 | CRC | 613.87 |  |  |  |  |  |  |  | #[NAME]! |  |  |  | #[NAME]!
 | CZK | 21.3 |  |  |  |  |  |  |  | #[NAME]! |  |  |  | #[NAME]!
 | DKK | 6.1125 |  |  |  |  |  |  |  | #[NAME]! |  |  |  | #[NAME]!
 | EUR | 0.825 |  |  |  |  |  |  |  | #[NAME]! |  |  |  | #[NAME]!
 | GBP | 0.745 |  |  |  |  |  |  |  | #[NAME]! |  |  |  | #[NAME]!
 | HKD | 7.755 |  |  |  |  |  |  |  | #[NAME]! |  |  |  | #[NAME]!
 | HNL | 24.1546 |  |  |  |  |  |  |  | #[NAME]! |  |  |  | #[NAME]!
 | ILS | 3.325 |  |  |  |  |  |  |  | #[NAME]! |  |  |  | #[NAME]!
 | INR | 72.95 |  |  |  |  |  |  |  | #[NAME]! |  |  |  | #[NAME]!
 | [NAME] | 105.5 |  |  |  |  |  |  |  | #[NAME]! |  |  |  | #[NAME]!
 | MYR | 4.06 |  |  |  |  |  |  |  | #[NAME]! |  |  |  | #[NAME]!
 | NOK | 8.7075 |  |  |  |  |  |  |  | #[NAME]! |  |  |  | #[NAME]!
 | NZD | 1.45 |  |  |  |  |  |  |  | #[NAME]! |  |  |  | #[NAME]!
 | PLN | 3.7 |  |  |  |  |  |  |  | #[NAME]! |  |  |  | #[NAME]!
 | SEK | 8.3875 |  |  |  |  |  |  |  | #[NAME]! |  |  |  | #[NAME]!
 | SGD | 1.3275 |  |  |  |  |  |  |  | #[NAME]! |  |  |  | #[NAME]!
 | USD | 1 |  |  |  |  |  |  |  | #[NAME]! |  |  |  | #[NAME]!
 | ZAR | 16.1575 |  |  |  |  |  |  |  | #[NAME]! |  |  |  | #[NAME]!
 | PHP |  | 0.02 | These are based on FX rate in 9/7/2021 |  |  |  |  |  | #[NAME]! |  |  |  | #[NAME]!
 | UAH |  | 0.037 |  |  |  |  |  |  | #[NAME]! |  |  |  | #[NAME]!
Spreadsheet: 86295d1286303357-refrencing-product-codes-to-get-cost-value-example
Sheet: Disposable and Reusable

 | 1=Tena | 1=liner
66=not applicable | 2=Poise | 2=pull-up/protective underwear/disposable underwear
77=not done/dementia | 3=Attends | 3=brief
88=cancellation/no show | 4=Depends | 4=male pad
99=missing data | 5=Store brand | 5=small pad/light pad
55=missing form | 6=Always | 6=medium pad/regular pad
 | 7=Kotex | 7=large pad/super pad
 | 8=carefree | 8=disposable blue pad
 | 9=multiple brands/no name/life brand | 9=toilet paper/kleenex
 |  | 10=incontinence pad
 |  | 11=ultra pad/maxi pad/sanitary pad/diaper
Patient Code | 1. Brand Name (refer to codes above) | 1. Product Name (refer to codes above) | Unit Cost
1 | 66 | 66
 | 66 | 66
2 | 1 | 10
 | 2 | 10
3 | 2 | 6
 | 77 | 77
4 | 4 | 2
 | 4 | 2
5 | 55 | 55
 | 88 | 88
Spreadsheet: 156889d1337543507-um-by-month-and-by-client-sales-seasonality-by-month1
Sheet: SALES

SALES
Invoice Nr: | Date | Client | Value Mts. | Rate | Value USD
1 | 2012-04-12 00:00:00 | sos | 100 | 28
2 | 2012-04-14 00:00:00 | sos | 600 | 28
3 | 2012-04-03 00:00:00 | Vale | 1000 | 28
4 | 2012-03-20 00:00:00 | vale | 3000 | 28
5 | 2012-01-10 00:00:00 | Ernest | 1000 | 28
6 | 2012-02-15 00:00:00 | Alfred | 7000 | 28
7 | 2012-03-10 00:00:00 | August | 9000 | 28
8 | 2012-05-01 00:00:00 | Ernest | 15000 | 28
9 | 2012-06-10 00:00:00 | Alfred | 20000 | 28
10 | 2012-07-20 00:00:00 | Vale | 25000 | 28
Spreadsheet: 626095d1558962019-extract-or-filter-data-filter-cathrine-paul-
Sheet: Sheet1

Group no | Names | Quantity | filter data |  |  | Group no | Names | Quantity |  |  |  |  |  |  |  |  |  |  |  | Group no | Names | Quantity | Result
045/001 | bakery | 1500 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 045/001 | bakery | 1500
045/001001 | cakes | 120 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 045/001001 | cakes | 120
045/001001001 | Dry fruits cake | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 045/001001001 | Dry fruits cake | 10
045/001001002 | Fresh cakes | 14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 045/001001002 | Fresh cakes | 14
045/001002 | Sweets | 1750 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 045/001002 | Sweets | 1750
045/001002001 | Hand made | 20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 045/001002001 | Hand made | 20
045/001002004 | Sugar free | 13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 045/001002004 | Sugar free | 13
045/002 | vegetables and fruits | 4111 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 045/008 | Milk | 555
045/002001 | Veg | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 045/008001 | Cow | 710
045/002001004 | Capsicum | 17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 045/008001003 | Bottle | 200
045/002001007 | Tomatto | 14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 045/008001004 | cover | 476
045/002005 | fruits | 30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 045/008003 | Goat | 320
045/002005001 | Apple | 800 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 045/008003002 | Bottle | 220
045/002005004 | Orange | 145 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 045/008005004 | cover | 11
045/005 | Ice cream | 125
045/005007 | bar | 10
045/005007002 | choco bar | 20
045/008 | Milk | 555
045/008001 | Cow | 710
045/008001003 | Bottle | 200
045/008001004 | cover | 476
045/008003 | Goat | 320
045/008003002 | Bottle | 220
045/008005004 | cover | 11
Spreadsheet: 836221d1689178559-provide-last-user-ignoring-blanks-except-if-only-data-catz-example
Sheet: Logins

Device SN | User | Date/time |  |  | DESIRED RESULTS: Unique SN | DESIRED RESULTS: Last user | DESIRED RESULTS: Last login time
sn1 |  | 06/25/2023 00:00 |  |  | sn1 | u1 | 06/24/2023 00:00
sn1 | u1 | 06/24/2023 00:00 |  |  | sn2 | u3 | 06/21/2023 15:13
sn1 | u1 | 06/23/2023 13:42 |  |  | sn3 | u2 | 06/16/2023 00:00
sn1 | u2 | 06/22/2023 00:00 |  |  | sn4 | no user information available | 06/13/2023 11:57
sn2 | u3 | 06/21/2023 15:13 |  |  | sn5 | u4 | 06/22/2023 13:20
sn2 | u3 | 06/20/2023 04:20 |  |  | sn6 | u6 | 06/20/2023 00:00
sn2 | u3 | 06/19/2023 05:15 |  |  | sn7 | u7 | 07/02/2023 20:00
sn2 | u3 | 06/18/2023 08:37
sn2 | u3 | 06/17/2023 16:01
sn3 |  | 06/16/2023 00:00
sn3 | u2 | 06/16/2023 00:00
sn3 | u3 | 06/14/2023 12:14
sn4 |  | 06/13/2023 11:57
sn5 | u4 | 06/22/2023 13:20
sn5 | u5 | 06/21/2023 13:05
sn5 | u4 | 06/12/2023 14:00
sn6 | u6 | 06/20/2023 00:00
sn7 | u7 | 07/02/2023 20:00
sn7 |  | 07/02/2023 19:59
Spreadsheet: 1d0f2072-d4a2-4143-972d-9759b1141ee8
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | 报表K | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 |  |  |  |  |  |  | (01/00)
 | 国际民航组织
 | 航空运输报表
 | 空中航行服务财务数据
 | 联系人： |  |  |  | 国家名称：
 | 单位： |  |  |  | 覆盖的飞行情报区/高空飞行情报区：
 | 电话：
 | 传真：
 | 电子邮件：
 |  | 如果不能提供准确数据，可使用估计数据，用星号（*）注明
 | 截至年： |  |  |  |  | 货币：
 | 第一部分：收入
 | 各项职能和项目的收入 |  |  |  |  | 数额
 |  |  |  |  |  | 小计 | [NAME]
 | 1. 航路服务………………………………………………………………………………………………………………………………………………………………..
 | 1.1   航路费收入…………………………………….....………………………………………………….
 | 1.2 其他收入（例如机场和进近和机场管制费）………………………………………………….………...
 | 2. 进近和机场管制服务……………………..………………………………………………….…………………………………………….
 | 2.1 进近和机场管制费收入…………………...……………………………………….……….
 | 2.2  其他收入(例如机场和航路费)………………..………………………………………………………..………….
 | 3. 赠款和补贴…………………………………………………………………………...…………………..……………………………………
 | 4. 其他收入…………………………………………………………………………………...……………...……………………………………………..
 | 5. [NAME]…………………………………………………………………………………………………...………………………………………….
 | 第二部分：支出
 | [NAME] |  |  |  |  |  | 数额
 | 1.  运行和维护（如人员，物资，服务等）……………………..……………………………..……………………………
 | 2.  行政管理…………………………………………………………………………………………...…………..…………………………….
 | 3.  折旧和/或摊销…………………………………………………………………………...………………………….………………………..
 | 4.  利息…………………………………………………………………………………….……………………………………...…………………………….
 | 5.  [NAME]…………………………………………….………………………………………...………………………………………………………..
 | 6.  支出合计…………………………………………...………………………………...……………………………………………………………..
 | 各项职能费用分配（支出总额或百分比）
 | 6.1   航路服务……………………………………………………...…………………………………………………………………………………….
 | 6.2  进近和机场管制服务………………………………….………………………...………………………………………………
 | 6.3   其他空中航行服务………………………………………….………………………………………………………………………
 | 6.4   非航空活动……………………………………………………….……………………………………
 | 第三部分：各项服务年内资本投资总额
 | 服务 |  |  |  |  |  | [NAME]
 | 1.  ATM - 空中交通管理……………………………………………..…………………………………….…………………………………………
 | 2.  CNS -通信、导航、监视……………………….…………………………………...……………………………………..
 | 3.  MET -气象服务……………………………………………….……………………………….……………………………………………..……………………..
 | 4.  SAR - 搜寻与援救服务…………………………………………………..………………………………..……………………………………………..
 | 5.  AIS - 航空情报服务………………………………………………….………………...…………………………………………………..
 | 6.  合计…………………………………………………………………...………………………………………….…………………………………………………..
 | 第四部分：员工
 | 按服务和类型计的人员 | 航路 + 终端区空中航行服务 |  |  |  |  |  | 航路＋终端区空中航行服务合计 | 其他空中航行服务 | [NAME]
 |  | 空中交通管理 | 通信、导航、监视 | 气象服务 | 航空情报服务 | 搜寻与援救 | 兼职
 | 空中交通管制员 运行
 | 空中交通管制员 其他职责
 | 运行支援人员 （非空中交通管制员）
 | 技术支援
 | 行政管理
 | 辅助性服务
 | 其他
 | 人员合计（相当于全职)
 | 备注（描述与填报说明存在任何无法避免的偏差情况）：
 |  |  |  |  |  |  | [NAME]