tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 275059d1383320494-want-the-cells-with-the-formulas-to-appear-blank-until-conditions-are-added-coupon-spread-sheet
Sheet: Sheet3

Name              Non-Food Items | # of Items | Retail Price | # of Coupons | Coupon Price | Total Retail Price | Price After Tax | Coupon Discount | Price after Coupon | Total Price After Coupon and tax | Running Total
Right Guard | 4 | 0.99 | 4 | 1.5
Post | 8 | 1.98 | 4 | 2.5
 |  |  |  |  |  |  |  |  | Total
Name              Food Items | # of Items | Retail Price | # of Coupons | Coupon Price | Total Retail Price | Price After Tax | Coupon Discount | Price after Coupon | Total Price After Coupon | Running Total
Soup | 12 | 1.25 | 12 | 1
hamburger helper | 6 | 0.88 | 2 | 1
 |  |  |  |  |  |  |  |  | Total
 |  |  |  |  | Total Retail Food
 |  |  |  |  | Total Retail Non-Food
 |  |  |  |  | Total Retail (Before Coupons)
 |  |  |  |  | Total Spent (After [NAME])
Spreadsheet: 840313d1692643124-formula-to-return-previous-month-balance-edate-not-working-sample-etaf
Sheet: Sheet1

Current Date | Aug
Current Balance
Previous Month Balance
Month | Balance
Jan | 5000
2023-02-01 00:00:00 | 6000
2023-03-01 00:00:00 | 7000
2023-04-01 00:00:00 | 6000
2023-05-01 00:00:00 | 8000
2023-06-01 00:00:00 | 10000
Jul | 11000
Aug | 9000
2023-09-01 00:00:00 | 8000
2023-10-01 00:00:00
2023-11-01 00:00:00
2023-12-01 00:00:00
Spreadsheet: 112210d1308322500-if-equation-help-how-to-get-e-and-to-be-read-as-a-zero-eventozero-version-1-
Sheet: Sheet1

Player | Score | Helper
Player1 | -5
Player2 | -3
Player3 | E
Player4 | 2
Player5 | 4
Player6 | 4
Player7 | 4
Player8 | 6
Player9 | -
Spreadsheet: 135647d1326148678-matching-columns-and-then-subtracting-forum
Sheet: Sheet1

Account | Count |  | Account | Count |  | What I Need
10000 | 134 |  | 10003 | 34 |  | 112-34= 78
10001 | 222 |  | 10001 | 56 | 10001
10002 | 367 |  | 10002 | 90
10003 | 112 |  | 10000 | 111
I want to be able to search for the account number on the right side (for example: "10003", value of 34) and find 10003 on the left side and subtract it from that number.
So in the end I need a 5th colum that looks like the above. But with the answer of 78 not the equation (just showing that for the example)
Spreadsheet: 685436d1594011306-alphabetize-a-unique-list-based-on-criteria-sort-text
Sheet: Sheet1

 | Unsorted Data | Sort Rank | Sorted Data
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Elijah
 | Lucas
 | Mason
 | Logan
 | Emma
 | Olivia
 | Ava
 | [NAME]
 | Sophia
 | Charlotte
 | [NAME]
 | Amelia
 | Harper
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Elijah
 | Lucas
 | Mason
 | Logan
 | Emma
 | Olivia
 | Ava
 | [NAME]
 | Sophia
 | Charlotte
 | [NAME]
 | Amelia
 | Harper
 | [NAME]
Spreadsheet: 240264d1370274177-querying-an-excel-workbook-sample
Sheet:  Templates

Marketing Campaign Report
MKt. Project ID
Campaign Title
[NAME] ID(s): |  |  |  | Campaign Status
Tech Title(s): |  |  |  | Days Active
Inventor(s): |  |  |  | Technology Category
Date of Campaign: |  |  |  | Follow Up Period (days) | 14
Description: |  |  |  | % Rejected
Number of Companies: |  |  |  | Number of Replies:
Initial No of Contacts: |  |  |  | Number of NDA signed:
No. Delivered Emails |  |  |  | Initially Interested:
Number Opened |  |  |  | Initially Not Interested:
Activity Status: | Active |  |  | Initial Unknown Interest:
 | Closed |  |  | ~ %Open Rate
 | Invalid Address |  |  | ~ % Company Reply
 |  |  |  | ~% Company Interest
Campaign Mailing Metrics
Company | First Name | Last Name | Title | [NAME] | Resp to Mail | Interest Y/N/? | [NAME] | Status | Last Contact | Follow Up Needed | Notes | Opened
Spreadsheet: 483177d1475519665-find-non-blanks-cells-and-copy-to-another-worksheet-find-non_blank-cell
Sheet: Sheet1

2016-01-01 00:00:00
2016-01-02 00:00:00
2016-01-03 00:00:00
2016-01-08 00:00:00 |  |  | 1, Find the first non-blank cell in column B, [NAME].  Then copy B5 to Sheet2 A1.
2016-01-09 00:00:00 | Anchor |  | 2, Also copy cell A5 to Sheet2 A2
2016-01-10 00:00:00 |  |  | 3, Then find the next non-blank cell in column B, B11.  Then copy B11 to Sheet2 B1.
2016-01-15 00:00:00 |  |  | 4, Also copy cell A11 to Sheet2 B2
2016-01-16 00:00:00 |  |  | And so on
2016-01-17 00:00:00
2016-01-22 00:00:00
2016-01-23 00:00:00 | Rock
2016-01-24 00:00:00
2016-01-29 00:00:00 | Boars
2016-01-30 00:00:00
2016-01-31 00:00:00
Spreadsheet: mary_fischer__25634__31Q
Sheet: E16.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY #  031Q
COMPANY NAME    Limbach Constructors
ANALYSIS OF (GAIN) LOSS ON SALES OF ASSETS
FOR THE 3 MONTHS ENDED 3-31-2001
**LIST ALL PROPERTY SALES INCLUDING SALES OF REGULATORY ASSETS
**REGULATED COMPANIES DO NOT SHOW (GAIN)/LOSS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-16
 |  |  |  | (A) | + | (B) | + | (C) |  |  | + | (D) | + | (E) | + | (F) | + | (G) |  |  | =
 |  |  |  | GROSS SALE PROCEEDS |  |  |  | NET BOOK VALUE |  |  |  |  |  |  |  |  |  | OTHER (EXPLAIN) |  |  |  | (GAIN) LOSS
 |  | DATE |  |  |  | N/R OR OTHER |  | ASSET |  |  |  |  |  | ACCUM |  | EXP ASSOC |  | AMOUNT |  | HYPERION |  | DR / (CR)
[NAME] OF ASSET |  | OF SALE |  | CASH | + | (EXPLAIN BELOW) | + | AMOUNT |  | HYPERION ACCT | + | PP&E | + | [NAME] | + | WITH SALE | + | DR (CR) |  | ACCT | = | ENDING BAL |  | COMMENTS
PROCEEDS OR BOOK VALUE OF ASSETS
OF $1,000,000 OR MORE:
SALES OF PP&E
SALES OF OTHER ASSETS
 |  |  |  |  |  | (B)
OTHER (LESS THAN $1,000,000) :
Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] ACCT 1676
 |  | EXPLAIN: |  |  |  |  |  |  |  |  |  |  |  |  | Hyperion Income Accts :  DR/(CR)
 |  | Notes Receivable |  |  |  |  |  |  |  |  |  |  |  |  |  | Signs are reversed from Hyperion
 |  | (list amounts and terms):
 |  | Other:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-16
 |  |  |  |  |  | (B)
Spreadsheet: 502feac9-7471-4c6c-88e6-e443d449412a
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
40828665 | 2014-04-03 22:14:10 | ALLIES | 1 | 4 | 1 | 978695 | Buzz l'éclair | 6162 | western | 1944-06-06 | 1944-06-06 | Pointe-du-Hoc | Pointe-du-Hoc
40828904 | 2014-04-03 22:37:08 | AXIS | 1 | 4 | 2 | 978695 | Buzz l'éclair | 6162 | western | 1944-06-06 | 1944-06-06 | Pointe-du-Hoc | Pointe-du-Hoc
40990902 | 2014-04-14 20:47:36 | AXIS | 1 | 6 | 4 | 1229610 | [NAME] | 7271 | western | 1944-12-18 | 1944-12-18 | [NAME] | Villages jumeaux
40991319 | 2014-04-14 21:07:11 | ALLIES | 1 | 6 | 4 | 1229610 | [NAME] | 7271 | western | 1944-12-18 | 1944-12-18 | [NAME] | Villages jumeaux
41004265 | 2014-04-15 19:17:32 | AXIS | 0 | 5 | 6 | 678541 | Sauron93 | 12494 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
41004494 | 2014-04-15 19:30:39 | ALLIES | 0 | 5 | 6 | 678541 | Sauron93 | 12494 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
Spreadsheet: 719315d1613616694-possible-indirect-function-needed-or-any-feasible-method-indirect-match-other-sheets
Sheet: 46547-20241100046

Client ID | Client Name | Account | Name | Group Name | Invoice No | Description Total | Charge Type | Random | Random | Random | Random | Random | Random | Random | Random | Random | CCY | Invoice Charge
46547 | Example | 313131 | Example |  | 20241100046 | Surcharges |  |  |  |  |  |  |  |  |  |  | EUR | 1324.5
46547 | Example | 897976 | Example |  | 20241100046 | Surcharges |  |  |  |  |  |  |  |  |  |  | EUR | 12.56
46547 | Example | 741641 | Example |  | 20241100046 | Other Fees |  |  |  |  |  |  |  |  |  |  | EUR | 31316.46
46547 | Example | 767987 | Example |  | 20241100046 | SK SubTotal |  |  |  |  |  |  |  |  |  |  | USD | 121292.34
46547 | Example | 767988 | Example |  | 20241100046 | SK SubTotal |  |  |  |  |  |  |  |  |  |  | EUR | 151284.3
46547 | Example | 767989 | Example |  | 20241100046 | SK SubTotal |  |  |  |  |  |  |  |  |  |  | EUR | 181276.26
46547 | Example | 767990 | Example |  | 20241100046 | SK SubTotal |  |  |  |  |  |  |  |  |  |  | USD | 211268.22
Spreadsheet: 686469d1594648117-identifying-top-vendors-who-contribute-to-refunds-and-top-70-items-for-refunds-power-pivot-sample-data2
Sheet: Top 5 vendors 

Top 5 vendors for Backorder
[NAME] | Refunds
sirsara | 31263
vimosa | 8371
lilosale | 6762
circarch | 2718
Top 5 vendors for Pre-sell
[NAME] | Sum of Refunds
vimosa | 61948
silocha | 21557
simsa | 5765
[NAME] | 1713
Spreadsheet: 871393d1717770571-copy-multiple-rows-by-criteria-from-multiple-sheets-doable-mockup_rg
Sheet: Overview

 |  |  | Start Date | End Date |  |  | Test
 |  |  | 2024-10-01 00:00:00 | 2024-10-19 00:00:00 | [NAME] dates here
2024-10-01 00:00:00 | Account1 – Booking1 |  |  | Account1 – Booking1 |  |  |  | Account1 – Booking1
2024-10-02 00:00:00 | Account1 – Booking2 |  | 2024-10-02 00:00:00 | Account1 – Booking2 |  |  | 2024-10-02 00:00:00 | Account1 – Booking2
2024-10-03 00:00:00 | Account1 – Booking3 |  | 2024-10-03 00:00:00 | Account1 – Booking3 |  |  | 2024-10-03 00:00:00 | Account1 – Booking3
2024-10-04 00:00:00 | Account1 – Booking4 |  | 2024-10-04 00:00:00 | Account1 – Booking4 |  |  | 2024-10-04 00:00:00 | Account1 – Booking4
2024-10-05 00:00:00 | Account1 – Booking5 |  | 2024-10-05 00:00:00 | Account1 – Booking5 |  |  | 2024-10-05 00:00:00 | Account1 – Booking5
2024-10-10 00:00:00 | Account2 – Booking1 |  | 2024-10-10 00:00:00 | Account2 – Booking1 |  |  | 2024-10-10 00:00:00 | Account2 – Booking1
2024-10-11 00:00:00 | Account2 – Booking2 |  | 2024-10-11 00:00:00 | Account2 – Booking2 |  |  | 2024-10-11 00:00:00 | Account2 – Booking2
2024-10-12 00:00:00 | Account2 – Booking3 |  | 2024-10-12 00:00:00 | Account2 – Booking3 |  |  | 2024-10-12 00:00:00 | Account2 – Booking3
2024-10-13 00:00:00 | Account2 – Booking4 |  | 2024-10-13 00:00:00 | Account2 – Booking4 |  |  | 2024-10-13 00:00:00 | Account2 – Booking4
2024-10-14 00:00:00 | Account2 – Booking5 |  | 2024-10-14 00:00:00 | Account2 – Booking5 |  |  | 2024-10-14 00:00:00 | Account2 – Booking5
2024-10-15 00:00:00 | Account3 – Booking1 |  | 2024-10-15 00:00:00 | Account3 – Booking1 |  |  | 2024-10-15 00:00:00 | Account3 – Booking1
2024-10-16 00:00:00 | Account3 – Booking2 |  | 2024-10-16 00:00:00 | Account3 – Booking2 |  |  | 2024-10-16 00:00:00 | Account3 – Booking2
2024-10-17 00:00:00 | Account3 – Booking3 |  | 2024-10-17 00:00:00 | Account3 – Booking3 |  |  | 2024-10-17 00:00:00 | Account3 – Booking3
2024-10-18 00:00:00 | Account3 – Booking4 |  | 2024-10-18 00:00:00 | Account3 – Booking4 |  |  | 2024-10-18 00:00:00 | Account3 – Booking4
2024-10-19 00:00:00 | Account3 – Booking5 |  | 2024-10-19 00:00:00 | Account3 – Booking5
Spreadsheet: 141606d1329363097-copy-row-from-sheet-1-to-monthly-sheets-eg-3-4-5-etc-if-values-met-copy-of-post-placement-tracking-sheet
Sheet: April 2012

Client Name | Case Manager | Employer | 13 Weeks Due | 13 Weeks Claimed | 26 Weeks Due |  | first day of month: | 2012-04-01 00:00:00
 |  |  |  |  |  |  | Records #
Spreadsheet: 219bb193-7118-459e-9ca4-a494a82a3510
Sheet: Spell Ranks

Spell | Rank | Effect |  |  | Start-index | End-index | Rank Range | Value Range
Faerie Fire Feral
Mangle
[NAME]
Shred
Spreadsheet: 791722d1660565159-formula-to-merge-duplicate-and-textjoin-sample
Sheet: After

Order ID | Task Type | Description
SGAAW000955282 | Delivery
SGAAW000955078 | Delivery
SGAAW000955644 | Delivery
SGAAW000958006 | Delivery
SGAAW000958006 | Delivery
SGAAW000958006 | Delivery
SGAAW000958006 | Delivery
SGAAW000958006 | Delivery
SGAAW000958006 | Delivery
SGAAW000958006 | Delivery
SGAAW000958006 | Delivery
Spreadsheet: 04ac40d8-7e78-4352-97ce-9873fa4e62e3
Sheet: 7.3 Fac Prof Dev Service

Institution
Indicator 7: Personnel Demographics, Professional Development, Research, and Outcomes
Table 7.3: Faculty, Administrator, and Staff Professional Development and Service / AY 2010-11
Please enter the number of faculty participating in, and the Person Activities (PA) or Total FTE for professional development activities, research, and service.  PA is equal to the number of people attending an activity times the number of activities (e.g., if 2 people attend 2 conferences, and 1 person attends 3 conferences, PA equals (2 x 2) + (1 x 3) = 7.  Total FTE is the sum of the FTE of each faculty member involved in research or service.
Professional Development Activities
 |  | AY 2010-11
 |  | Number of Faculty / Administrator / Staff | Person Activities (PA)
Attended National Conferences |  | 3 | m
Attended Workshops/Seminars |  | 28 | faculty development
Enrolled in study for advanced degree or certification |  | 8 | Ph.D. or [NAME].D.
Participated in Summer Programs |  | 3 | m
Faculty / Administrator / Staff Service Contribution
 |  | AY 2010-11
 |  | Number of Faculty / Administrator / Staff | Total Hours
Student Support Services |  | 0 | 0
Campus Activities/Committee Services |  | 11 | 264
Curriculum/Course Development |  | 1 | 90
Laboratory Development/Enhancement |  | 1 | 480
Community Service as a representative of the institution (e.g. Tribal Committee) |  | 5 | 3170
Notes:
The figures provided are activities funded by OLC.  We do not keep data on professional development activities that are funded by individual departments or by individuals.
Spreadsheet: 270077d1381362736-forecasting-daily-customer-count-due-to-certain-variables-forecasting-and-schedule
Sheet: Seasonal Employee Schedule

 |  |  |  |  |  |  |  |  |  |  | Job rotation?
Admissions
Name
Name
Name
Name
Name
Name
Name
Name
Concessions
Name
Name
Name
Name
Name
Name
Attractions
Name
Name
Name
Name
Name
Name
Park Services
Name
Name
Name
Name
Name
Name
Name
Temp
Name
Name
Name
Name
Name
Name
Spreadsheet: 275883d1383672204-double-drop-box-formula-for-table-answer-fillet-welds
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  | Single Run Fillet Welds
 |  |  |  |  | Size | Carbon Steel | Stainless Steel | MIG |  |  |  |  | Size | Type | Time
 |  |  |  |  | 3mm | 0.22 | 0.29 | 0.15 |  |  |  |  | 8mm | Stainless Steel
 |  |  |  |  | 5mm | 0.29 | 0.39 | 0.19
 |  |  |  |  | 6mm | 0.37 | 0.49 | 0.24
 |  |  |  |  | 8mm | 0.42 | 0.56 | 0.31
 |  |  |  |  | 10mm | 0.58 | 0.78 | 0.39