tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 226055d1365232524-excel-sales-invoice-tracker-sales-invoice-tracker
Sheet: Customers

 |  | Customers
 | Lookup | Company # | Company Name | Contact Name | Address | City | Country | ZIP Code | Phone | [NAME] | Fax
 |  | 1 | customer a | jonny | street a | Vilnius | Lithuania | 03110 | 999555999 | [EMAIL]
 |  | 99 | customer b | freddy | street b | Ruda | Palestine |  | 555444999 | [EMAIL]
 | Total
Spreadsheet: 881382d1729481471-sorting-day-data-to-give-me-weekly-data-number-of-occurances-to-forum
Sheet: Sheet1

 |  |  | WEEK | DAYS |  |  | WEEK |  | GREEN | RED | YELLOW | BLUE
 |  |  | 1 | Red |  |  | 1 |  |  | 4 | 0 | 0 |  |  |  | I have been manually entering formula
 |  |  |  | Red |  |  | 2 |  | 3 | 0 | 1 | 1
 |  |  |  | Red |  |  | 3 |  | 2 | 2 | 1 | 0
 |  |  |  | Red |  |  | 4 |  | 4 | 0 | 1 | 0
 |  |  |  |  |  |  | 5 |  | 4 | 1 | 0 | 0
 |  |  | 2 | Green |  |  | 6 |  | 1 | 0 | 2 | 0 |  | 0 | 4 | 0 | 0
 |  |  |  | Green |  |  | 7 |  | 3 | 1 | 1 | 0 |  | 3 | 0 | 1 | 1
 |  |  |  | Green |  |  |  |  |  |  |  |  |  | 2 | 2
 |  |  |  | Blue
 |  |  |  | Yellow
 |  |  | 3 | Yellow
 |  |  |  | Red
 |  |  |  | Red
 |  |  |  | Green
 |  |  |  | Green
 |  |  | 4 | Green
 |  |  |  | Green
 |  |  |  | Green
 |  |  |  | Yellow
 |  |  |  | Green
 |  |  | 5 | Green
 |  |  |  | Green
 |  |  |  | Red
 |  |  |  | Green
 |  |  |  | Green
 |  |  | 6 | Yellow
 |  |  |  | Yellow
 |  |  |  | Green
 |  |  | 7 | Green
 |  |  |  | Green
 |  |  |  | Green
 |  |  |  | Red
 |  |  |  | Yellow
Spreadsheet: 719874d1613863639-countifs-unique-values-for-one-criteria-countifs-ques
Sheet: Sheet1

 |  |  | Name | Region | Product
 |  |  | [NAME] | South | Widget
 |  |  | [NAME] | North | Straw |  |  |  | Total Widget Sold/South |  |  | =COUNTIFS(F4:F27,"Widget",E4:E27,"South")
 |  |  | Louis | North | Pencil |  |  |  | Unique Names that sold widget/South | 3 |  | ???
 |  |  | [NAME] | South | Tape
 |  |  | Sue | East | Widget
 |  |  | [NAME] | South | Widget
 |  |  | [NAME] | South | Bottle
 |  |  | Sue | South | Widget
 |  |  | [NAME] | West | Tape
 |  |  | Sue | North | Pencil
 |  |  | [NAME] | South | Widget
 |  |  | Louis | East | Jar
 |  |  | [NAME] | West | Bottle
 |  |  | [NAME] | South | Widget
 |  |  | [NAME] | North | Pencil
 |  |  | [NAME] | South | Widget
 |  |  | [NAME] | East | Jar
 |  |  | [NAME] | West | Widget
 |  |  | [NAME] | West | Pencil
 |  |  | Sue | South | Widget
 |  |  | [NAME] | South | Straw
 |  |  | Louis | East | Tape
 |  |  | [NAME] | West | Straw
 |  |  | [NAME] | South | Widget
Spreadsheet: 751641d1634220753-vlookup-constantly-returning-n-a-vlookup-error-sample
Sheet: SHEET C

11_CAT_CT660122T
14_CG_C35CC
11_CAT_CT660116T
17_CAT_CT680T
17_CAT_CT681T
14_CG_C35
19_CG_C35
11_CAT_CT660116T
20_CG_C35
14_CG_C35D
20_CG_C35D
06_CG_C35
10_CG_C35CC
20_CG_C35CC
15_CG_C35CCD
Spreadsheet: 797568d1663956947-counting-book1
Sheet: Sheet1

Helper | Unit Number | Gear | Diff | Location | bolt | Operation Type | Unit Type | Timestamp | Result | Value | Dimension | Lower Limit | Upper Limit
 | 123DLE26221325 | 123 | DLE | H140C (Mod 5) - Run Down  Ring Gear Bolts |  | [NAME] 01.Torque | 68260236AE | 2022-09-19 19:01:52 | 1 | 231.64 | Nm | 225 | 235
 | 123DLE26221325 | 124 | DLE | H140C (Mod 5) - Run Down  Ring Gear Bolts |  | [NAME] 02.Torque | 68260236AE | 2022-09-19 19:01:52 | 1 | 232.04 | Nm | 225 | 235
 | 123DLE26221325 | 125 | DLE | H140C (Mod 5) - Run Down  Ring Gear Bolts |  | [NAME] 03.Torque | 68260236AE | 2022-09-19 19:01:52 | 1 | 230.91 | Nm | 225 | 235
 | 123DLE26221325 | 126 | DLE | H140C (Mod 5) - Run Down  Ring Gear Bolts |  | [NAME] 04.Torque | 68260236AE | 2022-09-19 19:01:52 | 1 | 231.96 | Nm | 225 | 235
 | 123DLE26221325 | 127 | DLE | H140C (Mod 5) - Run Down  Ring Gear Bolts |  | [NAME] 05.Torque | 68260236AE | 2022-09-19 19:01:52 | 1 | 232.04 | Nm | 225 | 235
 | 123DLE26221325 | 128 | DLE | H140C (Mod 5) - Run Down  Ring Gear Bolts |  | [NAME] 06.Torque | 68260236AE | 2022-09-19 19:01:52 | 1 | 233.73 | Nm | 225 | 235
 | 123DLE26221325 | 129 | DLE | H140C (Mod 5) - Run Down  Ring Gear Bolts |  | [NAME] 07.Torque | 68260236AE | 2022-09-19 19:01:52 | 1 | 232.51 | Nm | 225 | 235
 | 123DLE26221325 | 130 | DLE | H140C (Mod 5) - Run Down  Ring Gear Bolts |  | [NAME] 08.Torque | 68260236AE | 2022-09-19 19:01:52 | 1 | 231.42 | Nm | 225 | 235
 | 123DLE26221325 | 131 | DLE | H140C (Mod 5) - Run Down  Ring Gear Bolts |  | [NAME] 09.Torque | 68260236AE | 2022-09-19 19:01:52 | 1 | 231.82 | Nm | 225 | 235
 | 123DLE26221325 | 132 | DLE | H140C (Mod 5) - Run Down  Ring Gear Bolts |  | [NAME] 10.Torque | 68260236AE | 2022-09-19 19:01:52 | 1 | 232.54 | Nm | 225 | 235
 | 123DLE26221325 | 133 | DLE | H140C (Mod 5) - Run Down  Ring Gear Bolts |  | [NAME] 11.Torque | 68260236AE | 2022-09-19 19:01:52 | 1 | 232.05 | Nm | 225 | 235
 | 123DLE26221325 | 134 | DLE | H140C (Mod 5) - Run Down  Ring Gear Bolts |  | [NAME] 12.Torque | 68260236AE | 2022-09-19 19:01:52 | 1 | 232.05 | Nm | 225 | 235
Spreadsheet: 740075d1626175617-split-text-in-excel-using-formulas-left-right-search-len-or-substitute-function-split
Sheet: Sheet1

Name List | Desired Outcome |  | [NAME]
Firstname | First | name
Lastname | Last | name
First name | First | name
Last name | Last | name
Spreadsheet: 798908d1664808394-what-formula-to-use-for-summary-data-ot
Sheet: 95A

 |  | SEPTEMBER |  |  | North OT:
 | CALENDAR YEAR | CALENDAR MONTH
 |  |  |  |  |  |  |  |  | Monday
 |  |  |  |  | [NAME] |  |  | a/b
 |  | Noel/Dave |  |  |  | [NAME] |  | a/b
 |  |  |  |  | fred | gfds |  | a/b
 |  |  |  |  |  |  |  | a/b
 |  |  |  |  |  |  |  | a/b
 |  |  |  |  |  |  |  | a/b
Spreadsheet: 58823d1259083472-excel-2007-how-to-add-items-to-a-dropdown-list-dynamically-by-typing-in-the-dropdown-list-cell-tanf_-_requirement_gathering_template_-final-
Sheet: Change

 |  |  | DATA Gathering Template
Program | Temporary Assistance - Family Assistance and Safety Net
Function Name | Case Management (Undercare)
Activity Name | Change
Activity Description / Purpose | Since many factors qualify a client for  benefits, many factors may change throughout the life of a benefit and need to be applied to the case record
 |  |  | Activity Predecessor | Activity [NAME] | Activity Input | Activity Output | Activity Successors
Steps | Tasks A task is any action that is being performed to complete a step | What unit does this? (SU) | Who does this? (W) | Applications used / System Interfaces / Tools Is there an automated system supporting the activity? | What happens before this? (P) | What causes the activity to happen (T) | Additional Information that is needed (I) | Is anything produced? (O) | What happens next ? (S) | V | Comments |  |  |  | Questions | Workarounds | Constraints/ Issues | Opportunities | Policy Considerations | Best Practices | Follow-Up | Comments
Check Daily Task Manager
Determine whether further verification is required
Make arrangements to get verification
Record information in case notes
Update information in WMS
Redetermine eligibility
Accounting | Case Closure
Add Program/Person | Case Management (Undercare)
AFIS | Caseload Management
Agency Conference | Client Services/Benefits Delivery
Application Registration | Eligibility Determination
Authorization | Fair-Hearings & Appeals
[NAME] | Intake
Budget | Referrals
Case Assignment | Screening
Case Closure | Verification
Case Review
[NAME]
CBIC
Change
Clearance
Data Entry
DV-D-A Screen
Emergency Benefits
Expedited
Hearings
Interview
Investigation
Managed Care
Mass Changes
Monitor Activities
Notice
[NAME]
Plan Review
Pre-Screening
Reactivation
Reception
Records Management
Recoupment-Supplemental
Re-Determination-Renewal-Recert
Referral
Sanctions
Service Plan
Verify
Vouchers
Withdraw Application
Other
Spreadsheet: ffc12177-f02c-4c99-9b15-d85e064218dd
Sheet: Month 1

Month 1: __________ - __________ |  |  |  |  |  |  |  |  |  |  |  | Fill in weights and reps for each lift by replacing the "X"'s
 |  |  |  |  |  |  |  |  |  |  |  |  |  | SUPPLEMENTAL WORK
BENCH | [NAME] | 0.9 |  |  |  | EST. MAX | Weight | Reps
 |  |  |  |  |  |  | X | X
 | Sets | Reps | Percentage |  |  | Pounds |  |  | Reps Completed |  |  | Comments
Week 1 | 3 | 5 | 0.65 | 0.75 | 0.85
Week 2 | 3 | 3 | 0.7 | 0.8 | 0.9
Week 3 | 3 | 5,3,1 | 0.75 | 0.85 | 0.95
Week 4 | 3 | 5 | 0.4 | 0.5 | 0.6
DEADLIFT | [NAME] | 0.9 |  |  |  | EST. MAX | Weight | Reps
 |  |  |  |  |  |  | X | X
 | Sets | Reps | Percentage |  |  | Pounds |  |  | Reps Completed |  |  | Comments
Week 1 | 3 | 5 | 0.65 | 0.75 | 0.85
Week 2 | 3 | 3 | 0.7 | 0.8 | 0.9
Week 3 | 3 | 5,3,1 | 0.75 | 0.85 | 0.95
Week 4 | 3 | 5 | 0.4 | 0.5 | 0.6
PRESS | [NAME] | 0.9 |  |  |  | EST. MAX | Weight | Reps
 |  |  |  |  |  |  | X | X
 | Sets | Reps | Percentage |  |  | Pounds |  |  | Reps Completed |  |  | Comments
Week 1 | 3 | 5 | 0.65 | 0.75 | 0.85
Week 2 | 3 | 3 | 0.7 | 0.8 | 0.9
Week 3 | 3 | 5,3,1 | 0.75 | 0.85 | 0.95
Week 4 | 3 | 5 | 0.4 | 0.5 | 0.6
SQUAT | [NAME] | 0.9 |  |  |  | EST. MAX | Weight | Reps
 |  |  |  |  |  |  | X | X
 | Sets | Reps | Percentage |  |  | Pounds |  |  | Reps Completed |  |  | Comments
Week 1 | 3 | 5 | 0.65 | 0.75 | 0.85
Week 2 | 3 | 3 | 0.7 | 0.8 | 0.9
Week 3 | 3 | 5,3,1 | 0.75 | 0.85 | 0.95
Week 4 | 3 | 5 | 0.4 | 0.5 | 0.6
 |  |  |  |  |  | Weight x Reps x .0333 + Weight = Estimated 1RM
 |  |  |  |  |  | - Warm-up: 1x5 at 40%, 1x5 at 50%, 1x3 at 60%
 |  |  |  |  |  | - LAST SET = (Reps) + Max reps, except for Week 4
Spreadsheet: 2c22f166-a770-474b-a4a6-1ab293387ea9
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 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25 | Unnamed: 26 | Unnamed: 27 | Unnamed: 28 | Unnamed: 29 | Unnamed: 30
REIT Name: | Agree Realty Corporation
 |  |  |  |  | Data requested by ICI and SIFMA by
Primary Layout Report Date: | 2006-12-31 00:00:00 |  |  |  | 2007-01-09 00:00:00
This spreadsheet and the accompanying instructions do not constitute, and should not be considered a substitute for, legal advice.  The rules governing the proper tax characterization of distributions by REITs can be complex.  Each REIT should consult its
Please list Securities in [NAME] (Skip Rows Between Entries)
1 | 2 | 3 | 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
 |  |  |  |  |  |  |  |  |  | Year Included in Shareholders' Income |  |  |  | Form 1099 Box 1a Breakdown |  | Box 1a Total |  | Form 1099 Box 1b Breakdown |  | Box 1b Total | Box 2a | Box 2b | Box 2c | Box 2d | Box 3 | Box 6 | Box 8 | Box 9 |  | Alternative
 |  |  |  |  |  |  |  |  | Total |  |  |  |  |  | Foreign | Ordinary | Qualified | Qualified | Qualified | Qualified | Total Capital | Unrecap |  |  |  | Foreign | Cash | Noncash | Exempt | Minimum
Security |  | Ticker | Estimated | Reclass | Corrected | Record | Ex-Dividend | Payable | Distribution | 2005 | 2007 | 2006 | Income | Short-term | Tax | Dividends | Income | Short-term | Foreign Tax | Dividends | [NAME]. | Sec. 1250 | Section 1202 | Collectibles | Nondividend | Tax | Liquidation | Liquidation | Interest | Tax
Description | CUSIP | Symbol | (E) | (R) | (C) | Date | Date | Date | Per Share | (Prior Year) | (Next Year) | (Current Year) | Dividends | Capital Gain | Paid | (14+15) | Dividends | Gains | Paid | -18 |  | Gain | Gain | (28%) Gain | Distributions | Paid | Distr | Distr | Dividends | %of Column 30
 |  |  |  |  |  |  |  |  | (11+12+13) |  |  | (14+15+22+26)
Common | 8492100 | ADC |  |  |  | 2006-03-31 00:00:00 | 2006-03-29 00:00:00 | 2006-04-13 00:00:00 | 0.49 |  |  | 0.49 | 0.45 |  |  | 0.45 |  |  |  |  |  |  |  |  | 0.04
Common | 8492100 | ADC |  |  |  | 2006-06-30 00:00:00 | 2006-06-28 00:00:00 | 2006-07-13 00:00:00 | 0.49 |  |  | 0.49 | 0.45 |  |  | 0.45 |  |  |  |  |  |  |  |  | 0.04
`
Common | 8492100 | ADC |  |  |  | 2006-09-29 00:00:00 | 2006-09-27 00:00:00 | 2006-10-12 00:00:00 | 0.49 |  |  | 0.49 | 0.45 |  |  | 0.45 |  |  |  |  |  |  |  |  | 0.04
Common | 8492100 | ADC |  |  |  | 2006-12-22 00:00:00 | 2006-12-20 00:00:00 | 2007-01-04 00:00:00 | 0.49 |  |  | 0.49 | 0.45 |  |  | 0.45 |  |  |  |  |  |  |  |  | 0.04
Totals |  |  |  |  |  |  |  |  | 1.96 |  |  | 1.96 | 1.8 |  |  | 1.8 |  |  |  |  |  |  |  |  | 0.16
Spreadsheet: 677181d1589226988-calculate-work-performance-efficiency-backlog-1-
Sheet: Sheet1

Week # | Created | Closed | Backlog
1 | 5 | 4 | 1
2 | 10 | 6
3 | 33 | 30
4 | 8 | 6
5 | 13 | 12
6 | 6 | 13
7 | 20 | 11
8 | 13 | 15
9 | 22 | 9
10 | 2 | 24
11 | 11 | 7
12 | 8 | 2
13 | 10 | 17
14 | 2 | 1
15 | 15 | 15
16 | 7 | 6
17 | 3 | 5
Spreadsheet: 40028d1238342480-today-function-and-viewing-or-printing-original-date-index
Sheet: DATA

INDEX | DATE | CUSTOMER | ADDRESS | AMOUNT
1 | 2009-01-28 00:00:00 | ABC | YZ | 5000
2 | 2009-02-21 00:00:00 | DEF | MN | 4000
3 | 2009-03-29 00:00:00 | GHI | OP | 6000
Spreadsheet: 872588d1718964111-dashboard-with-tables-linking-to-specific-person-hr-dashboard-anon
Sheet: Issues

Raised By | Date Raised | Caused By | Issue Type | Our Ref (job/Quote) | Brief Issue Description | Impact | Resolution | Wasted Time (Mins) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Commissioning Error |  |  |  |  |  |  |  |  | Staff | Issue Type | Impact
[NAME] | 2024-02-12 00:00:00 | [NAME] | Reporting Error | 123 | TEST | High | Test Resolve | 60 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Customer Service |  |  |  |  |  |  |  |  | [NAME] | Commissioning Error | High
[NAME] | 2024-02-12 00:00:00 | [NAME] | Commissioning Error | 456 | TEST | Medium | Test Resolve | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Reporting Error |  |  |  |  |  |  |  |  | [NAME] | Customer Service | Medium
[NAME] | 2024-02-12 00:00:00 | [NAME] | Customer Service | 789 | TEST | High | Test Resolve | 45 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Install Error |  |  |  |  |  |  |  |  | [NAME] | Reporting Error | Low
[NAME] | 2024-02-12 00:00:00 | [NAME] | Customer Service | 321 | TEST | Low | Test Resolve | 30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Service Error |  |  |  |  |  |  |  |  | [NAME] | Install Error
[NAME] | 2024-04-14 00:00:00 | [NAME] | Install Error | 1551 |  |  |  | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Service Error
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Customer
Spreadsheet: 55623d1255714286-telling-excel-a-cell-equals-another-cell-on-a-worksheet-hprp-assessment-final-sample
Sheet: HPRP A-Housing History

Homelessness Prevention and Rapid Re-Housing Program
APPLICANT INFORMATION
Intake Date: | 2009-10-25 00:00:00 |  |  | # in Household: | 3
Household Information
Last Name: | Doe | M. Initial: | M | First Name: | [NAME]
Last Name: | 0 | M. Initial: | 0 | First Name: | 0
Home Phone: | [PHONE] |  | Cell [NAME]): | 0
Work [NAME]): | [PHONE] |  | [NAME]): | 0
HPRP ASSESSMENT
General Information
[NAME] |  |  | ANSWER
Do you currently have a bus pass?
Do you have birth certificates for all members of the household?
If not, who does not have a birth certificate?
Do you have SS cards for all members of the household?
If not, who does not have a SS card?
Housing History
[NAME] |  |  |  |  | ANSWER
If currently homeless, how long have you been living in a shelter or on the streets?
In what city was your last permanent address?
When did you live at this address?
How many times have you been without housing in the past 3 years?
For what reason(s) did you leave your last housing?
Rental Payment History
[NAME] |  |  |  |  | ANSWER
If in an apartment, how much is your rent per month? |  |  |  |  | 0
Do you have any outstanding rent payments?
If yes, how many months are you behind ?
Utility Payment History
[NAME] |  |  |  |  | ANSWER
How much do you spend on utilities per month? |  |  |  |  | 0
Do you have any outstanding utility bills?
If yes, please detail below.
Utility Type | Contact Information |  |  | Number of Months Overdue | Cost Per Month | Total Amount Owed
 | Total: |  |  | 0 | 0 | 0
Spreadsheet: darrell_schoolcraft__7302__imball0201
Sheet: Agave

Agave imbalance
 | Measured | Scheduled | Imbalance
56339 | 95944 | 100316
78311 |  | 16100 |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
500238 | 88432 | 104396 |  |  |  |  |  |  |  |  | lunch | 7.6
500239 | 117447 | 86521
500293 | 56691 | 54263
500302 |  | 828
500303 |  | 18551
500305 | 150469 | 153380
500307 | 10603 | 6384
500313 |  | 303
500314
500655
500657 |  | 20988
INDEX
2001-12-31 00:00:00 |  |  | 68958.7
2002-01-03 00:00:00
CBS Volume
 |  |  | 44250
Spreadsheet: 134395d1325265532-formula-to-pull-cell-info-from-workbook-auto-filter301211
Sheet: total

TOTALS | group 6400-6449
 |  |  |  | month of date out
RO | VEHICLE | DATE IN | DATE OUT |  | TOTAL COST | DEDUCT | CUST PAY
6450 | Pathfinder | 2011-11-01 00:00:00 | 2011-11-15 00:00:00 | 11 | 2319.96 | 500 | 0
6451 | Xa | 2011-11-20 00:00:00 | 2011-12-28 00:00:00 | 12 | 307.76 | 250 | 0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
Spreadsheet: 859658d1707977326-comparing-values-betwen-sheets-and-returning-values-book1
Sheet: EUC

CI NAME | Exists? In DV range | Match | Address of Match | Row of Match | Colum of match | Name (row) associated with match | Name (column) associated with match |  | match | MATCH(A2,DV!$B$2:$F$11)
JM3532 |  |  |  |  |  |  |  |  | Address of Match | ADDRESS(MATCH(A2,DV!$B$2:$F$11),COLUMN(DV!$A2))
DP2960 |  |  |  |  |  |  |  |  | Row of Match | MATCH(A2,DV!$B$2:$F$11)
DP2961 |  |  |  |  |  |  |  |  | Column of Match | MATCH(A2, DV!$B$2:$F$11, 0)
DP7356 |  |  |  |  |  |  |  |  | Name Associated with Match | INDEX(DV!$A:$A,E2)
DP9882
DQ0683
DQ0775
DQ2256
DQ2403
DQ3656
DR0386
DR0494
DR2454
DR3060
DR4134
DR6177
DR6604
DR8546
DR8555
DR9155
DR9660
DR9908
DZ0979
JD0062
JD0342
JD1750
JL0709
JL1896
JL3021
JL4050
JL4352
JL4691
JL5091
JL5120
JL5337
[NAME]
JL6869
JL7066
JL7904
JL7939
JL8019
JL8020
JL8030
JL8031
JL8043
JL8044
JL8573
JL8628
JL9418
JL9438
JL9493
JL9563
JL9564
JL9589
JL9596
JM0016
JM0135
JM0138
JM0144
JM0189
JM0212
JM0215
JM0401
JM0731
JM0888
JM0941
JM1136
JM1296
JM1462
JM1560
JM1587
JM1589
[NAME]
JM1863
JM1866
JM1868
JM1871
JM1874
JM2139
[NAME]
JM2148
JM2210
JM2252
JM3532
JM3577
JM3641
JQ1439
JQ1499
JQ1812
JQ2217
JQ2278
JQ3767
JQ3768
JQ3770
JQ3774
JQ3777
JQ4085
[NAME]
JQ4852
JQ4856
JQ4913
JQ4914
JQ5119
JQ7633
JQ7636
JQ8387
JQ8388
JQ8749
JQ8907
JQ8908
JQ9415
JQ9546
JQ9786
JQ9787
JQ9788
JQ9789
JR0410
[NAME]
JR0453
JR1380
JR1643
JR1746
JR2057
JR2061
JR2078
JR2092
JR2095
[NAME]
JR2814
JR2844
JR2872
JR2875
[NAME]
JR2982
JR3034
JR3035
JR3131
JR3181
JR3668
JR3791
JR3966
JR4496
JR5550
[NAME]
JR5846
JR6436
JR6989
JR7011
JR7016
JR7018
JR7019
JR7028
JR7137
[NAME]
JR7139
JR7140
JR7275
JR7401
JR7915
JR7949
JR8001
JR8007
JR8317
JR8377
JR8389
JS0100
JS0111
JS0118
JS0119
JS0177
JS0284
JS0495
JS0496
JS0633
JS0635
JS0637
JS0639
JS0691
JS0692
JS0694
JS0695
JS0827
JS0828
JS0871
JS0872
JS1267
JS1268
JS1458
JS1459
JS2829
JS2830
JS2868
JS2871
[NAME]
JS2876
TP0839
TP2301
TP3971
TP3972
Spreadsheet: benjamin_rogers__1264__NewCo-7-15-00
Sheet: ENA_Allocation

ALLOCATION
Project |  | By Project Cost |  | By Cashflow
Brownsville |  | 0.125039438479223 |  | 0.1544055419784738
Caledonia |  | 0.1511835224699338 |  | 0.1558587124333399
New Albany |  | 0.145392174776267 |  | 0.1197550000844939
Sub Total
[NAME] |  | 0.170742065516558 |  | 0.1750496898264828
Wheatland |  | 0.1561848046993598 |  | 0.17174199460296
[NAME] |  | 0.2514579940586584 |  | 0.2231890610742496
Sub Total
Total
Spreadsheet: 13e1cec9-183c-477a-a40c-d8f91b2f8369
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
40298145 | 2014-03-01 15:26:30 | AXIS | 1 | 5 | 3 | 1511925 | dl1 | 7666 | pacific | 1943-01-10 | 1943-01-22 | Slopes of Mount Austen | Pentes du mont [NAME]
40298322 | 2014-03-01 15:38:58 | ALLIES | 0 | 4 | 5 | 1511925 | dl1 | 7666 | pacific | 1943-01-10 | 1943-01-22 | Slopes of Mount Austen | Pentes du mont [NAME]
40393289 | 2014-03-07 04:57:40 | ALLIES | 0 | 3 | 6 | 188507 | WiredNun | 8043 | eastern | 1939-09-08 | 1939-09-26 | Battle of Warsaw | Bataille de Varsovie
40393576 | 2014-03-07 05:15:54 | AXIS | 0 | 1 | 6 | 188507 | WiredNun | 8043 | eastern | 1939-09-08 | 1939-09-26 | Battle of Warsaw | Bataille de Varsovie
Spreadsheet: 875223d1721808076-average-with-sumproduct-across-2d-range-inc-with-1d-criteria-and-ignoring-error-values-2d-sum-with-1d-range-ignoring-errors
Sheet: Excel Forum

 | Year: | 2024
 |  | 2023 | 2023 | 2024 | 2024 | 2024 | 2024 | 2024 | 2025 | 2025 | 2025
 | 1 |  | 10 | 8 | 5 | 8 | 22 | 25 | 13 | 6 | 9
 | 2
 | 3 |  |  |  | 4 | 9 | 6 | 3 | 2 | 7 | 2
 | 4 |  |  |  |  |  | 45 | 4 | 7 | 7 | 48
 | 5
 | 6
 | 7 |  |  | 99 | 55 | 7 | 8 | 7 | 5 | 4 | 6
 | 8
 | 9
 | 10 |  |  |  |  |  | 4 | 4 | 7 | 7 | 8
 |  |  |  |  |  |  |  |  |  | Sum of all cells satisfying 2024 criteria: |  | (Should be 323!)
 |  |  |  |  |  |  |  |  |  | Count of all cells satisfying 2024 criteria: |  | (Should be 18!)
 |  |  |  |  |  |  |  |  |  | Average of all 2024 cells: |  | (Should be 17.94!)
 |  |  |  |  |  |  |  |  |  |  |  | ..and then, ideally, L20 but all in one formula :)
Spreadsheet: 859296d1707733788-right-wrong-formula-drag-right-scrab-quiz-horizontal
Sheet: Sheet1

 | ADENPST | xxx |  | PEDANTS
 | ADENPST | pentads |  | PENTADS
 | ADENRST | xxx |  | DARNEST
 | ADENRST | endarts |  | ENDARTS
 | ADENRST | xxx |  | STANDER
 | ADENRST | starned |  | STARNED
 | ADENSTT | xxx |  | ATTENDS
 | ADENSTV | advents |  | ADVENTS
 | ADENSTY | stayned |  | STAYNED
 | AEFFNST | naffest |  | NAFFEST
 | AEFJNST | fanjets |  | FANJETS
 | AEFNNST | xxx |  | ENFANTS
 | AEFNSST | fastens |  | FASTENS
 | AEFNSST | fatness |  | FATNESS
 | AEFNSTT | xxx |  | FATTENS
 | AEGHNST | stengah |  | STENGAH
 | AEGLNST | xxx |  | GELANTS
 | AEGLNST | xxx |  | LANGEST
 | AEGLNST | xxx |  | [NAME]
 | AEGMNST | xxx |  | MAGNETS
 | ADEMNST | tandems |  | TANDEMS
 | ADENNST | xxx |  | STANDEN