tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 468366d1467260364-using-the-sort-filter-function-in-different-unconnected-areas-of-a-spreadsheet-all-store-weekending
Sheet: Sheet1

Week 26
 |  |  |  | Bread |  | Food |  | Sides |  | Paper |  | Produce |  | Beverage |  | Total COGs |  | Mgmt | Inshop | Drivers | DMR | Total Labor
Store | GM | Sales | Growth | This Week | Last Week | This Week | Last Week | This Week | Last Week | This Week | Last Week | This Week | Last Week | This Week | Last Week | This Week | Last Week
2346 | [NAME] | 14325.25 | -0.0656 | 0.0321 | 0.0369 | 0.1169 | 0.1425 | 0.0236 | 0.0265 | 0.0102 | 0.0136 | 0.0235 | 0.0265 | 0.0126 | 0.0132 | 0.2425 | 0.2295 | 0.1632 | 0.0898 | 0.0365 | 0.0235 | 0.3156
2630 | Santa | 12369.39 | -0.0325 | 0.0402 | 0.0325 | 0.1225 | 0.1235 | 0.0299 | 0.0285 | 0.0125 | 0.0115 | 0.0268 | 0.0213 | 0.0148 | 0.0141 | 0.2412 | 0.2365 | 0.1465 | 0.1096 | 0.0632 | 0.0325 | 0.3265
1804 | Blaine | 18654.32 | -0.0321 | 0.0325 | 0.0425 | 0.1165 | 0.1325 | 0.0265 | 0.0312 | 0.0136 | 0.0109 | 0.0256 | 0.0321 | 0.0135 | 0.0121 | 0.2361 | 0.2398 | 0.1422 | 0.0936 | 0.0298 | 0.0398 | 0.2965
1291 | [NAME] | 15954.32 | 0.1291 | 0.0391 | 0.0375 | 0.1295 | 0.2632 | 0.0365 | 0.0252 | 0.0118 | 0.0117 | 0.0299 | 0.0289 | 0.0115 | 0.0142 | 0.2365 | 0.241 | 0.1525 | 0.0892 | 0.0425 | 0.0298 | 0.3654
Totals/Averages
 |  |  |  |  |  |  |  |  |  | # of complaints | Sales $
 |  | Cash O/U | Mng Meals | Emp Meals | Promos | Waste | Freebie Totals | OTD | % Catering | for year | per Complaint
Store | GM
1291 | [NAME] | 5.36 | 159.63 | 12.356 | 900.23 | 15.65 | 1000 | 05:43:00 | 0.0532 | 3 | 130256
2630 | Santa | -12.59 | 129.36 | 36.36 | 159.63 | 2.36 | 1125.32 | 03:00:00 | 0.0475 | 0 | 100985.65
2346 | [NAME] | -3.26 | 456.32 | 56.95 | 325.26 | 24.25 | 1600 | 06:56:00 | 0.0398 | 1 | 89635.32
1804 | Blaine | 1.23 | 200.36 | 18.79 | 635.23 | 36.65 | 1235 | 04:32:00 | 0.0236 | 2 | 68952.25
Totals/Averages
Spreadsheet: 94979d1294706468-make-a-calendar-with-noted-birthdays-etc-my2011-25
Sheet: Dates

 | [NAME] | 1965-01-02 00:00:00 |  | 0
 | [NAME] | 1976-01-05 00:00:00 |  | 0 |  |  |  |  |  | Birthday
 | [NAME] | 1996-01-07 00:00:00 |  | 0 |  |  |  |  |  | Anniversary
 | [NAME] | 1978-01-07 00:00:00 |  | 0
 | [NAME] | 1987-01-11 00:00:00 |  | 0
 | [NAME] | 1981-01-23 00:00:00 |  | 0 |  |  |  |  |  | ABC
 | [NAME] | 1966-02-15 00:00:00 |  | 0 |  |  |  |  |  | DEF
 | [NAME] | 1987-06-08 00:00:00 |  | 0
 | [NAME] | 2010-11-01 00:00:00 |  | 0
 | [NAME] | 1925-12-05 00:00:00 |  | 0
Mo/Day | Birthdays |  | Date Number | Already used? | Year | Table1 | Month | Table2 | Day | Note
Mo/Day | Birthdays |  | Date Number | Already used? | Year | Table1 | Month | Table2 | Day | Note
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14
Spreadsheet: 0960e9d2-f0f2-4013-a75d-d731ede9ade6
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 9. FINANCE COMMITMENTS, For Motor Vehicles: 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
Personal Finance - New motor cars and station wagons ; |  |  | Original | A2414166T | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
Personal Finance - Used motor cars and station wagons ; |  |  | Original | A2414167V | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
Personal Finance - Motor cycles ; |  |  | Original | A2414168W | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
Personal Finance - Other motor vehicles ; |  |  | Original | A2414169X | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
Personal Finance - Total ; |  |  | Original | A2414170J | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
Commercial Finance ; |  |  | Original | A2414171K | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
Value of Lease Finance Commitments ; |  |  | Original | A2414172L | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
TOTAL ; |  |  | Original | A2414173R | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | DERIVED | Month | 1
© Commonwealth of Australia  2011
Spreadsheet: 164380d1340739149-lookup-word-formula-excel-lookup-formula-help
Sheet: Data

REGION
VARCHAR(30)
Canada
Canada
Canada
Canada
Canada
Unassigned
Unassigned
US East
US East
US East
US East
US East
US Federal
US Federal
US Federal
US Federal
US Federal
US Federal
US Federal
US Federal
US Federal
US Federal
US West
US West
Alps
Alps
Alps
Alps
Alps
Alps
Alps
Alps
Alps
Alps
Alps
Germany
Germany
Germany
Germany
Germany
Germany
Germany
Nordic
Nordic
Nordic
UKI
UKI
UKI
UKI
UKI
UKI
UKI
UKI
Unassigned
Unassigned
Unassigned
Unassigned
Unassigned
Unassigned
Unassigned
Unassigned
Benelux
Benelux
Benelux
Benelux
France
France
France
France
France
France
France
Italy
Italy
Italy
Italy
Italy
Italy
SPGI
SPGI
SPGI
SPGI
SPGI
SPGI
SPGI
SPGI
ANZ
ANZ
ANZ
ANZ
ANZ
CEE
CEE
CEE
CEE
CEE
CEE
CEE
CEE
CEE
GCG
GCG
GCG
GCG
GCG
GCG
GCG
GCG
GCG
GCG
GCG
ISA
ISA
Korea
Korea
Korea
Korea
Korea
Korea
Korea
Korea
LA
LA
LA
LA
LA
LA
LA
LA
LA
MEA
MEA
MEA
MEA
MEA
MEA
MEA
MEA
MEA
MEA
Unassigned
Unassigned
Unassigned
Unassigned
Unassigned
Unassigned
Unassigned
Unassigned
Unassigned
Japan
Japan
Japan
Japan
Japan
Japan
Japan
Japan
Japan
Japan
Canada
Canada
Canada
Canada
Canada
Canada
Canada
Canada
Canada
Spreadsheet: mary_fischer__25634__31Q
Sheet: ELIST.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY #  031Q |  | (Please print)  PREPARED BY: | Sonya City
E-SCHEDULES CHECK LIST
For the period ending: 06/30/2001 |  | REVIEWED BY: | [NAME]
*  PRIORITY SCHEDULE
SCH | CONSOL ACCT | QUARTERLY SCHEDULES | COMPLETED or N/A
E-1 | 053, 060 | A/R - Other | N/A
E-2 * | 195 | Other Current Assets | N/A
E-3 * | TOT_INVEST_SUBS | Investment in Unconsolidated
 | TOT_EQEARN_OTH | Affiliates, Partnerships & Joint Ventures | N/A
E-4 * | 269, 270, 280 | Merchant and Other Investments | N/A
E-5 | 344 | Goodwill | N/A
E-6 * | TOT_PPE | Property, Plant & Equipment | N/A
 | [NAME] | Depreciation, Depletion & Amortization
[NAME] * | 343, 360 | Other Deferred Charges | N/A
E-11* | 655 | Other Current Liabilities | N/A
E-12 * | 450,  TOT_NP_OTHER | Short-Term and Long-Term Debt | N/A
 | 770,  705,  775,  765
E-14* | 860 | Other Deferred Credits | N/A
E-15 | 855 | Minority Interests | N/A
E-16* | 1676 | (Gain) Loss on Sales of Assets | N/A
E-20* | 1690, 1775 | Other Income and Other Deductions | COMPLETED
E-21 |  | Lease Expense & Future Lease Commitments | COMPLETED
E-31 | VARIOUS ACCOUNTS | Equity/Invmt Sub | COMPLETED
E-36 | TOT_INVEST_SUBS | Investee's Summarized Information | N/A
 | TOT_EQEARN_OTH
 |  | ADDITIONAL SCHEDULES FOR YEAR END ONLY
E-18 | 65, 641, 815, 840 | Analysis of Reserve Items | N/A
Spreadsheet: 888333d1738834610-which-formula-would-be-best-to-use-formula-query-6-feb
Sheet: Sheet1

Day | Opening hours |  |  |  |  | Day | Time of activity
Monday | 420 | 2400 | 1 |  |  | Monday | 400
Tuesday | 420 | 2400 | 2 |  |  | Monday | 0521
Wednesday | 500 | 2200 | 3 |  |  | Tuesday | 0521
Thursday | 500 | 2200 | 4 |  |  | Tuesday | 1000
Friday | 600 | 2100 | 5 |  |  | Wednesday | 900
Saturday | 600 | 2000 | 6 |  |  | Wednesday | 2355
Sunday | 730 | 1700 | 7 |  |  | Thursday | 423
 |  |  |  |  |  | Thursday | 1905
 |  |  |  |  |  | Friday | 0524
 |  |  |  |  |  | Saturday | 0524
 |  |  |  |  |  | Saturday | 600
 |  |  |  |  |  | Saturday | 1925
 |  |  |  |  |  | Saturday | 2001
 |  |  |  |  |  | Sunday | 705
 |  |  |  |  |  | Sunday | 801
 |  |  |  |  |  | Sunday | 1500
 |  |  |  |  |  | Sunday | 2109
Spreadsheet: 879377d1726850807-need-help-vlookup-not-pulling-data-across-vlookup
Sheet: Sheet2

Request Id | Date | Start | End | Request Grade
[PHONE] | 2024-08-01 00:00:00 | 08:50:00 | 10:20:00 | Polish
[PHONE] | 2024-08-01 00:00:00 | 08:55:00 | 09:25:00 | Slovak
[PHONE] | 2024-08-01 00:00:00 | 09:00:00 | 10:00:00 | Pushto
[PHONE] | 2024-08-01 00:00:00 | 09:00:00 | 12:00:00 | Romanian
[PHONE] | 2024-08-01 00:00:00 | 09:15:00 | 10:15:00 | Oromo
[PHONE] | 2024-08-01 00:00:00 | 09:20:00 | 13:20:00 | Polish
[PHONE] | 2024-08-01 00:00:00 | 09:30:00 | 11:30:00 | Urdu
[PHONE] | 2024-08-01 00:00:00 | 09:30:00 | 11:00:00 | Urdu
[PHONE] | 2024-08-01 00:00:00 | 10:00:00 | 11:00:00 | Arabic
[PHONE] | 2024-08-01 00:00:00 | 10:00:00 | 11:15:00 | Arabic
[PHONE] | 2024-08-01 00:00:00 | 10:00:00 | 14:00:00 | Urdu
[PHONE] | 2024-08-01 00:00:00 | 10:00:00 | 11:30:00 | Urdu
[PHONE] | 2024-08-01 00:00:00 | 10:00:00 | 11:00:00 | Kurdish-Sorani
[PHONE] | 2024-08-01 00:00:00 | 10:00:00 | 11:00:00 | Arabic
[PHONE] | 2024-08-01 00:00:00 | 10:15:00 | 10:45:00 | Turkish
[PHONE] | 2024-08-01 00:00:00 | 10:15:00 | 11:15:00 | Romanian
[PHONE] | 2024-08-01 00:00:00 | 10:25:00 | 14:00:00 | Slovak
[PHONE] | 2024-08-01 00:00:00 | 10:30:00 | 12:30:00 | Farsi
[PHONE] | 2024-08-01 00:00:00 | 10:30:00 | 11:30:00 | Spanish
[PHONE] | 2024-08-01 00:00:00 | 10:30:00 | 11:30:00 | Arabic
[PHONE] | 2024-08-01 00:00:00 | 10:30:00 | 11:30:00 | Polish
[PHONE] | 2024-08-01 00:00:00 | 11:00:00 | 12:00:00 | Urdu
[PHONE] | 2024-08-01 00:00:00 | 11:00:00 | 12:30:00 | Urdu
[PHONE] | 2024-08-01 00:00:00 | 11:00:00 | 12:00:00 | Kurdish-Sorani
[PHONE] | 2024-08-01 00:00:00 | 11:00:00 | 12:00:00 | Arabic
Spreadsheet: 587036d1534797761-adding-data-to-new-sheets-from-main-sheet-example
Sheet: Banana

[NAME] | Ford | Seattle | 17
[NAME] | Ford | Bangor | 39
[NAME] | Chevy | New York City | 664
[NAME] | Dodge | Miami | 603
[NAME] | Dodge | Tusla | 3673
[NAME] | BMW | Bangor | 3954
[NAME] | GMC | New York City | 531
[NAME] | Chevy | Miami | 476
[NAME] | Dodge | Tusla | 246
[NAME] | Dodge | Miami | 357
Spreadsheet: 813736d1673964294-match-and-extract-data-from-two-possible-sources-and-enter-in-to-cell-match-data-from-different-sources
Sheet: Internal Users

Full Name | Employee Number | First Name | Surname | Job Title | Work Email Address
 | 38035694 | User | 1 | IT Analyst | [EMAIL]
 | 38032228 | User | 2 | HR Officer | [EMAIL]
 | 38031516 | User | 4 | Systems Administrator | [EMAIL]
 | 38037607 | User | 7 | Department Manager | [EMAIL]
 | 38040487 | User | 9 | HR Officer | [EMAIL]
 | 38037721 | User | 11 | IT Analyst | [EMAIL]
 | 38040062 | User | 12 | [NAME] | [EMAIL]
 | 38030173 | User | 3 | HR Manager | [EMAIL]
 | 38035693 | User | 6 | Business Analyst | [EMAIL]
Spreadsheet: 753634d1635589736-row-in-table-not-working-row-copy
Sheet: MRF

 | Section 1: Your details
 | Name
 | Department
 | [NAME]
 | Budget code
 | Section 2: Event details
 | Event name
 | Event date
 | Delivery date
 | Section 4: Delivery details
 | Name
 | [NAME]
 | [NAME]
 | Address
 | Index | Shelf | Price | Quantity | Total | Product | Comm code | Origin | Notes
 | 1 | H | 0.13 |  |  | Balloons | 95 03 00 99 | Poland
 | 2 | H | 0.84 |  |  | Bubble blowers | 95 03 00 95 | China
 | 3 | H | 2.21 |  |  | Cotton bags | 42 02 92 98 | India
 | 4 | H | 0.22 |  |  | Glow in the dark pens | 96 08 10 92 | Spain | 5 x Colours
 | 5 | H | 4.48 |  |  | Heat sensitive mugs | 69 12 00 23 | China
 | 6 | H | 0.65 |  |  | Lanyards | 56 09 00 00 | China
 | 7 | H | 0.89 | 4 |  | A5 notepads | 48 20 10 30 | UK
 | 8 | H | 0.11 |  |  | Pencils | 96 09 10 10 | China
 | 9 | H | 2.84 |  |  | Safety specs/glasses | 90 04 90 10 | Taiwan/Chinese Taipei
 | 10 | H | 0.57 | 5 |  | Primary school stickers - English | 48 21 10 10 | UK
 | 11 | H | 1.1 |  |  | RSC stylus pen | 96 08 10 10 | China
 | 12 | H | 1.9 |  |  | Top trump cards | 95 04 40 00 | UK
 | 13 | H | 0.24 |  |  | Recycled pens | 96 08 10 10 | China
 | 14 | H | 0.21 |  |  | Fold-out Periodic Table | 49 01 10 00 | UK
 | 15 | H | 6.31 |  |  | Tshirt - size S | 61 09 10 00 | Check label | Black
 | 16 | H | 6.31 |  |  | Tshirt - size M | 62 09 10 00 | Check label | Black
 | 17 | H | 6.31 |  |  | Tshirt - size L | 63 09 10 00 | Check label | Black
 | 18 | H | 6.31 | 20 |  | Tshirt - size XL | 64 09 10 00 | Check label | Black
 | 19 | H | 10 |  |  | Solar powered battery charger | 85 36 69 90 | China
 | 20 | H | 5 |  |  | Travel plug/adaptor | 85 07 60 00 | China
 | 21 | I | 0.01
 | 22 | I | 0.01
 | 23 | I | 0.01
 | 24 | I | 0.01
 | 25 | I | 0.01
 | 26 | I | 0.01
 | 27 | I | 0.01
 | 28 | I | 0.01
 | 29 | I | 0.01
 | 30 | I | 0.01
 | 31 | I | 0.01
 | 32 | I | 0.01
 | 33 | I | 0.01
 | 34 | I | 0.01
 | 35 | I | 0.01
 | 36 | I | 0.01
 | 37 | I | 0.01
 | 38 | I | 0.01
 | 39 | I | 0.01
 | 40 | I | 0.01
 | 41 | I | 0.01
 | 42 | I | 0.01
 | 43 | I | 0.01
 | 44 | I | 0.01
 | 45 | I | 0.01
 | 46 | I | 0.01
 | 47 | I | 0.01
 | 48 | I | 0.01
 | 49 | I | 0.01
 | 50 | I | 0.01
 | 51 | I | 0.01
 | 52 | I | 0.01
 | 53 | I | 0.01
 | 54 | I | 0.01
 | 55 | I | 0.01
 | 56 | I | 0.01
 | 57 | I | 0.01
 | 58 | I | 0.01
 | 59 | I | 0.01
 | 60 | I | 0.01
 | 61 | I | 0.01
 | 62 | I | 0.01
 | 63 | I | 0.01
 | 64 | I | 0.01
 | 65 | I | 0.01
 | 66 | I | 0.01
 | 67 | I | 0.01
 | 68 | I | 0.01
 |  | I
Spreadsheet: 73845d1274398221-golf-scorecard-issue-tempparaverages
Sheet: Sheet1

Par | 4 | 3 | 4 | 4 | 3 | 3 | 3 | 3 | 4
2010-05-01 00:00:00 | 5 | 5 | 4 | 5 | 4 | 3 | 4 | 5 | 4 |  | Par 3's | Average Number of Shots
2010-05-04 00:00:00 | 4 | 4 | 4 | 6 | 4 | 2 | 6 | 3 | 4 |  | Par 4's | Average Number of Shots
Spreadsheet: 794707d1662232254-find-cell-address-in-single-row-for-last-non-blank-value-not-the-highest-value-sample-1-
Sheet: Sheet1

Doors | Refinish | Last value in row | 2011
 | Door |  | Com | Part | Side | Com | Part | Side | Com | Part | Side | Com | Part | Side | Com | Part | Side | Com | Part | Side | Com | Part | Side | Com | Part | Side | Com | Part | Side | Com | Part | Side | Com | Part | Side | Com | Part | Side | Com | Part | Side | Com | Part | Side | Com | Part | Side | Com | Part | Side | Com | Part | Side | Com | Part | Side | Com | Part | Side | Com | Part | Side | Com | Part | Side | Com | Part | Side | Com | Part | Side | Com | Part | Side | Com | Part | Side
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 123 |  |  |  |  |  |  |  |  |  | 245
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 123 |  |  |  |  |  |  |  |  |  |  | 125 |  |  |  |  | 245
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 120 |  |  |  | 245 |  |  |  |  |  |  |  |  | 245
 |  |  | 245 |  |  |  |  |  |  |  |  |  |  |  |  |  | 106 | 245 |  |  |  |  |  |  |  |  | 245
 |  |  | 245 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 245 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 104
 |  |  |  |  |  | 245 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 172
Spreadsheet: 719214d1613561585-return-number-of-out-of-date-training-in-a-month-excel-forum-help-gk-
Sheet: matrix

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ruben Martin
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Aitor Garmindea
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  | Months Warning | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-02-17 00:00:00
n |  |  | 1
5
s | SECTION |  |  | Fork Lift Truck |  | [NAME] |  | [NAME] |  | Scissor Lift |  | Over Head Crane
 | EGE |  | Min Req
 |  |  | Plan
 | Total Associates |  | Actual
 |  |  | Gap
 | Training Valid / Years |  |  | 3 |  | 3 |  | 3 |  | 3 |  | 3 |  | 3 |  | 3 |  | 3
 | ASSOCIATE NAME | ASS NO. | DATE | STATUS |  | STATUS |  | STATUS |  | STATUS |  | STATUS |  | STATUS |  | STATUS |  | STATUS
 |  |  | START DATE
 |  |  | END DATE
 |  |  | START DATE | 2018-01-01 00:00:00
 |  |  | END DATE
 |  |  | START DATE |  |  |  |  |  |  |  |  | 2018-02-13 00:00:00
 |  |  | END DATE
 |  |  | START DATE | 2017-01-01 00:00:00
 |  |  | END DATE
 |  |  | START DATE
 |  |  | END DATE
 |  |  | START DATE | 2018-03-01 00:00:00
 |  |  | END DATE
 |  |  | START DATE | 2018-02-18 00:00:00
 |  |  | END DATE
 |  |  | START DATE | 2018-02-17 00:00:00
 |  |  | END DATE
 |  |  | START DATE
 |  |  | END DATE
 |  |  | START DATE
 |  |  | END DATE
 |  |  | START DATE
 |  |  | END DATE
 |  |  | START DATE
 |  |  | END DATE
 |  |  | START DATE
 |  |  | END DATE
 |  |  | START DATE
 |  |  | END DATE
 |  |  | START DATE
 |  |  | END DATE
 |  |  | START DATE
 |  |  | END DATE
 |  |  | START DATE
 |  |  | END DATE
 |  |  | START DATE
 |  |  | END DATE
 |  |  | START DATE
 |  |  | END DATE
 |  |  | START DATE
 |  |  | END DATE
 |  |  | START DATE
 |  |  | END DATE
 |  |  | START DATE
 |  |  | END DATE
 |  |  | START DATE
 |  |  | END DATE
 |  |  | START DATE
 |  |  | END DATE
 |  |  | START DATE
 |  |  | END DATE
 |  |  | START DATE
 |  |  | END DATE
 |  |  | START DATE
 |  |  | END DATE
 |  |  | START DATE
 |  |  | END DATE
 |  |  | START DATE
 |  |  | END DATE
 |  |  | START DATE
 |  |  | END DATE
 |  |  | START DATE
 |  |  | END DATE
 |  |  | START DATE
 |  |  | END DATE
 |  |  | START DATE
 |  |  | END DATE
 |  |  | START DATE
 |  |  | END DATE
 |  |  | START DATE
 |  |  | END DATE
 |  |  | START DATE
 |  |  | END DATE
 |  |  | START DATE
 |  |  | END DATE
 |  |  | START DATE
 |  |  | END DATE
 |  |  | START DATE
 |  |  | END DATE
 | 5 | Out of Date
 | s | Due in 3 Months
 | l | Completed
 | n | Training Needed
2021 | April | April | April
 | May | May | May
 | June | June | June
 | July | July | July
 | August | August | August
 | September | September | September
 | October | October | October
 | November | November | November
 | December | December | December
 | January | January | January
 | February | February | February
 | March | March | March
Total Associates
 | 6
Spreadsheet: 752038d1634548332-from-table-find-repeated-values-of-multiple-columns-of-data-forumhelp_10-18
Sheet: Sheet1

 | store 1 | store 2 | store 3 | store 4 |  | Fruits sold at the same time in four stores | Fruits sold at the same time in three stores | Fruits sold at the same time in two stores | Fruits sold at the same time in one store
 | Orange | Orange | banana | cantaloupe |  | Orange | banana | cantaloupe | Peach
 | Apple | banana | Apple | Apple |  |  | Apple | watermelon | Grape
 | banana | watermelon | Orange | Orange |  |  |  | Papaya
 | Peach | Papaya | mango | mango |  |  |  | mango
 | watermelon | cantaloupe | Kiwi | Kiwi |  |  |  | Kiwi
 | Grape |  | durian | durian |  |  |  | durian
 | Papaya
Spreadsheet: 854791d1704549111-custom-formula-for-subscription-calculations-as-needed-monthly-annually-subscriptions
Sheet: Subscriptions

DATE | FREQUENCY | PAYEE | AMOUNT
2024-01-01 00:00:00 | As-Needed | CallingCard.com | 10
2024-01-01 00:00:00 | As-Needed | E-Z Pass | 70
2024-01-04 00:00:00 | Monthly | SiriusXM.com | 22.89
2024-01-21 00:00:00 | Monthly | Experian.com | 29.99
2024-01-24 00:00:00 | Monthly | Netflix.com | 22.99
2024-04-14 00:00:00 | Annually | HomeAgain.com | 24.99
2024-07-27 00:00:00 | Annually | Ring.com | 39.99
 |  |  |  | MANUALLY COMPLETED
MONTH | MONTHLY AMOUNT |  |  | MONTH | MONTHLY AMOUNT | Notes for Calculation
JAN |  |  |  | JAN |  | As-Needed + Monthly
FEB |  |  |  | FEB |  | Monthly
MAR |  |  |  | MAR |  | Monthly
APR |  |  |  | APR |  | Monthly + Annually
MAY |  |  |  | MAY |  | Monthly
JUN |  |  |  | JUN |  | Monthly
JUL |  |  |  | JUL |  | Monthly + Annually
AUG |  |  |  | AUG |  | Monthly
SEP |  |  |  | SEP |  | Monthly
OCT |  |  |  | OCT |  | Monthly
NOV |  |  |  | NOV |  | Monthly
DEC |  |  |  | DEC |  | Monthly
Spreadsheet: 792419d1660895057-multiple-key-word-match-book4
Sheet: Sheet1

DESC | RESULT |  |  | KEY 1 | KEY 2 | RESULT
BEARING, BALL, SINGLE ROW 6311-Z | BEARING,BALL |  |  | BEARING | BALL | BEARING,BALL
BEARING, BALL, SKF 6004-2Z | BEARING,BALL |  |  | BEARING | ROLLER | BEARING,ROLLER
BEARING, BALL, SKF 6201 | BEARING,BALL |  |  | BEARING | THRUST | BEARING,THRUST
BEARING, BALL, SKF 6202-2Z | BEARING,BALL
BEARING,ROLLER,SPL 22217 KBX | BEARING,ROLLER
Spreadsheet: 704419d1605540717-nested-if-function-formula-issue-is-this-the-best-way-to-solve-this-problem-accounting-v2-
Sheet: Sheet1 (1)

Instrument Pair: | [NAME] | Customer: |  | Month: |  | Year:
Entries/Exits | Date | Order Type | Side | Price | Profit % | average price | Executed QTY | Cost | Pos Size % | exec QTY calc | [NAME] | Status | Profit USD | Pfolio Value | Net Profit | Service Fee | Net Profit Total
Entry pos 1 |  | limit | buy | 10333 |  | 10330 | 0.3
Entry pos 2 |  | limit | buy | 10689.98
Entry pos 3 |  | limit | buy | 10900.87 |  |  |  |  |  |  |  |  |  |  |  |  | Service Fee Total
Entry pos 4 |  | limit | buy
Exit pos 1 |  | limit | sell | 11500 |  | 11500 | 0.089483
Exit pos 2 |  | limit | sell | 15313 |  | 13100 | 0.136908 |  |  |  |  |  |  |  |  |  | Profit Grand Total
Exit pos 3 |  | limit | sell | 16500 |  | 15789 | 0.131539
Exit pos 4 |  | limit | sell
Spreadsheet: 695399d1600189424-cash-flow-workbook-is-sumifs-the-best-function-sample
Sheet: Cash Flow

September
Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |  | Income | Expenses | Balance
 |  | 1
 |  |  |  | 1
October
Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
November
Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
1
 |  | 1 |  | 3
December
Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
 |  |  |  |  | 1
Monthly Income
Item | Amount | Per Week
Work | 4000
Rental | 1200
Cell Phone | 40
Monthly Expenses
Item | Due Date | Amount
Gym | 1 | 50
Cell phone | 1 | 100
Mortgage | 1 | 1500
Insurance | 5 | 150
Loan | 7 | 200
Car | 8 | 300
Utilities | 13 | 100
TV/Internet | 13 | 75
Spreadsheet: 00c44e93-e2fd-4a89-84f9-a325683ae3fb
Sheet: Q2 JOHN

[NAME]
n | 36 |  | period | amount owing at the end of the period | cash payment |  | Intrinsic
P | 50000 |  | 0
X |  |  | 1
F |  |  | 2
rate | 0.011 |  | 3
(1 + rate)^n |  |  | 4
 |  |  | 5
 |  |  | 6
 |  |  | 7
 |  |  | 8
 |  |  | 9
 |  |  | 10
 |  |  | 11
 |  |  | 12
 |  |  | 13
 |  |  | 14
 |  |  | 15
 |  |  | 16
 |  |  | 17
 |  |  | 18
 |  |  | 19
 |  |  | 20
 |  |  | 21
 |  |  | 22
 |  |  | 23
 |  |  | 24
 |  |  | 25
 |  |  | 26
 |  |  | 27
 |  |  | 28
 |  |  | 29
 |  |  | 30
 |  |  | 31
 |  |  | 32
 |  |  | 33
 |  |  | 34
 |  |  | 35
 |  |  | 36
Spreadsheet: 550148d1512131558-need-formula-to-bring-a-cell-value-from-non-successive-rows-index-of-last-match-cse
Sheet: Sheet 1

Invoice | Value | Mapping Value | Pending Amount
Invoice A | 500 | 400 | 100
Invoice B | 600 | 450
Invoice A |  | 50 | 50 | Note: formula in B4 is a CSE (Control+Shift+Enter) or [NAME] formula.
Invoice B |  | 150 | 0
Invoice A |  | 25 | 25
Invoice A |  | 25 | 0
Note : "Invoice A" is there in multiple rows which are not successive
End result will be like the below table
Invoice | Value | Mapping Value | Pending Amount
Invoice A | 500 | 400 | 100
Invoice B | 600 | 450
Invoice A | 100 | 50 | 50
Invoice B | 150 | 150 | 0
Invoice A | 50 | 25 | 25
Invoice A | 25 | 25 | 0
Spreadsheet: eric_saibi__9827__092801U
Sheet: Paradise 03

Owner Name |  | Tennessee Valley Authority
Station Name |  | Paradise Power Station
Unit Name |  | Paradise 03
NERC Region |  | SERC
State |  | KY
Fuel Type |  | Coal
Capacity |  | 1,150 MW
Start Date |  | 2001-09-27 00:00:00
End Date |  | 2001-10-01 00:00:00
Comments |  | Tube Leak
SIC |  | 4911
Plant ID |  | 1012553
Unit ID |  | 1003648
Outage ID |  | 18551