tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 069e9432-6128-49ac-9493-5b885932c03e
Sheet: Hanover Area

 |  |  |  |  |  |  | 2013 Hanover
 | January |  |  |  |  |  | February |  |  |  |  |  | March
 | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr
 |  | 1 | 2 | 3 | 4 |  |  |  |  |  | 1 |  |  |  |  |  | 1
 | 7 | 8 | 9 | 10 | 11 |  | 4 | 5 | 6 | 7 | 8 |  | 4 | 5 | 6 | 7 | 8
 | 14 | 15 | 16 | 17 | 18 |  | 11 | 12 | 13 | 14 | 15 |  | 11 | 12 | 13 | 14 | 15
 | 21 | 22 | 23 | 24 | 25 |  | 18 | 19 | 20 | 21 | 22 |  | 18 | 19 | 20 | 21 | 22
 | 28 | 29 | 30 | 31 |  |  | 25 | 26 | 27 | 28 |  |  | 25 | 26 | 27 | 28 | 29
 | April |  |  |  |  |  | May |  |  |  |  |  | June
 | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr
 | 1 | 2 | 3 | 4 | 5 |  |  |  | 1 | 2 | 3
 | 8 | 9 | 10 | 11 | 12 |  | 6 | 7 | 8 | 9 | 10 |  | 3 | 4 | 5 | 6 | 7
 | 15 | 16 | 17 | 18 | 19 |  | 13 | 14 | 15 | 16 | 17 |  | 10 | 11 | 12 | 13 | 14
 | 22 | 23 | 24 | 25 | 26 |  | 20 | 21 | 22 | 23 | 24 |  | 17 | 18 | 19 | 20 | 21
 | 29 | 30 |  |  |  |  | 27 | 28 | 29 | 30 | 31 |  | 24 | 25 | 26 | 27 | 28
 | July |  |  |  |  |  | August |  |  |  |  |  | September
 | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr
 | 1 | 2 | 3 | 4 | 5 |  |  |  |  | 1 | 2 |  | 2 | 3 | 4 | 5 | 6
 | 8 | 9 | 10 | 11 | 12 |  | 5 | 6 | 7 | 8 | 9 |  | 9 | 10 | 11 | 12 | 13
 | 15 | 16 | 17 | 18 | 19 |  | 12 | 13 | 14 | 15 | 16 |  | 16 | 17 | 18 | 19 | 20
 | 22 | 23 | 24 | 25 | 26 |  | 19 | 20 | 21 | 22 | 23 |  | 23 | 24 | 25 | 26 | 27
 | 29 | 30 | 31 |  |  |  | 26 | 27 | 28 | 29 | 30 |  | 30
 | October |  |  |  |  |  | November |  |  |  |  |  | December
 | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr
 |  | 1 | 2 | 3 | 4 |  |  |  |  |  | 1 |  | 2 | 3 | 4 | 5 | 6
 | 7 | 8 | 9 | 10 | 11 |  | 4 | 5 | 6 | 7 | 8 |  | 9 | 10 | 11 | 12 | 13
 | 14 | 15 | 16 | 17 | 18 |  | 11 | 12 | 13 | 14 | 15 |  | 16 | 17 | 18 | 19 | 20
 | 21 | 22 | 23 | 24 | 25 |  | 18 | 19 | 20 | 21 | 22 |  | 23 | 24 | 25 | 26 | 27
 | 28 | 29 | 30 | 31 |  |  | 25 | 26 | 27 | 28 | 29 |  | 30 | 31
 | Every other Tuesday. (w/Gtysbrg)  [NAME] is subject to change.  Call CPFB with questions [PHONE]. Thank you.
 |  |  | Holiday closures. |  |  |  |  | Deliveries. |  |  |  | Inventory - warehouse closures.
Spreadsheet: 41126d1239648912-vlookup-hlookup-problems-problem-example-resolution-attempt
Sheet: dataPull

Step 2 |  |  |  |  |  |  | How it's supposed to work.
Site (friendly name) 6 | external pulled data goes in this box |  |  |  |  |  | 1. User pulls down step# in cell A2.
site (lookup name) 6 |  |  |  |  |  |  | 2. Cells A3 / A4 get updated using HLOOKUP
 |  |  |  |  |  |  | 3. Cells A19 / A20 get updated using VLOOKUP, by referencing cells A3 / A4
 |  |  |  |  |  |  | 4. Cells A35 / A36 get updated using VLOOKUP, by referencing cells A3 / A4
 |  |  |  |  |  |  | 5. etc.
 |  |  |  |  |  |  | What is actually happening.
 |  |  |  |  |  |  | 1. Everything works fine for Step 1.
 |  |  |  |  |  |  | 2. If "step 2" is selected in A2, then A3 / A4 populate correctly, but nothing else does
 |  |  |  |  |  |  | 3. Ditto step 3, step 4, etc.
site (lookup name) 6 | external pulled data goes in this box
#N/A
#N/A | external pulled data goes in this box
#N/A
#N/A | external pulled data goes in this box
#N/A
#N/A | external pulled data goes in this box
#N/A
Spreadsheet: 132670d1323880636-help-with-a-function-sum-daily-hours-depending-on-the-employee-name-example
Sheet: Timesheet

 |  |  | Available working hours
 |  | Name | January | February | March | Total hours
 |  | [NAME] | 180 | 160 | 100
 |  | [NAME] | 180 | 80 | 120
 |  | [NAME] | 100 | 100 | 20
 |  | Laureen | 160 | 140 | 180
 |  | Violeta | 180 | 180 | 80
 |  | Prisilla | 180 | 180 | 120
Spreadsheet: 490108d1479680874-how-to-make-dropdownt-list-of-unique-items-dependent-on-another-dropdown-list-shops-and-items-fixed
Sheet: List1

 |  |  |  |  |  | Shop | Item |  |  |  |  |  | Filtered list 1 | Filtered List 2
 |  |  |  |  |  | Kaufland | glue |  | Shop | [NAME] |  |  | Kaufland
 |  |  |  |  |  | [NAME] | glue |  | Item |  |  |  | [NAME]
 |  |  |  |  |  | [NAME] | scissors |  |  |  |  |  | Tesco
 |  |  |  |  |  | Tesco | pencil |  |  |  |  |  | Kaufland
 |  |  |  |  |  | Kaufland | ruler |  |  |  |  |  | Billa
 |  |  |  |  |  | Billa | scissors
 |  |  |  |  |  | Kaufland | paper
 |  |  |  |  |  | Tesco | ruler
 |  |  |  |  |  | Billa | glue
 |  |  |  |  |  | Billa | rubber
 |  |  |  |  |  | [NAME] | rubber
 |  |  |  |  |  | Kaufland | string
 |  |  |  |  |  | Billa | ink
 |  |  |  |  |  | Tesco | brush
 |  |  |  |  |  | [NAME] | string
 |  |  |  |  |  | Tesco | pencil
 |  |  |  |  |  | [NAME] | glue
 |  |  |  |  |  | Billa | ink
 |  |  |  |  |  | Kaufland | ruler
Spreadsheet: 712966d1610500316-rotating-column-based-on-date-not-even-sure-what-to-call-it-example
Sheet: Sheet1

NAME | Monday | Tuesday | Wednesd. | Thursday | Friday | Saturday | Sunday
Jan 11 2021
Employee 1 | Data | Data | Data | Data | Data | Data | Data
Employee 2 | Data | Data | Data | Data | Data | Data | Data
Employee 3 | Data | Data | Data | Data | Data | Data | Data
Employee 4 | Data | Data | Data | Data | Data | Data | Data
Employee 5 | Data | Data | Data | Data | Data | Data | Data
Employee 6 | Data | Data | Data | Data | Data | Data | Data
Employee 7 | Data | Data | Data | Data | Data | Data | Data
Employee 8 | Data | Data | Data | Data | Data | Data | Data
Employee 9 | Data | Data | Data | Data | Data | Data | Data
Employee 10 | Data | Data | Data | Data | Data | Data | Data
Spreadsheet: 692857d1598610939-sensitivity-analysis-sensitivity-analysis-sample-data-
Sheet: Data

Weights | 50 | 30 | 20
ITEM # | FACTOR 1 | FACTOR 2 | FACTOR 3 | TOTAL SCORE
1 | High | Very High | Yes
2 | High | Very High | No
3 | High | High | Yes
4 | High | High | No
5 | High | Low | Yes
6 | High | Low | No
7 | High | Very Low | Yes
8 | High | Very Low | No
9 | Medium | Very High | Yes
10 | Medium | Very High | No
11 | Medium | High | Yes
12 | Medium | High | No
13 | Medium | Low | Yes
14 | Medium | Low | No
15 | Medium | Very Low | Yes
16 | Medium | Very Low | No
17 | Low | Very High | Yes
18 | Low | Very High | No
19 | Low | High | Yes
20 | Low | High | No
21 | Low | Low | Yes
22 | Low | Low | No
23 | Low | Very Low | Yes
24 | Low | Very Low | No
Spreadsheet: 584341d1533128928-sumif-is-blank-excel-upload
Sheet: Template 

Document Header Data |  | Field Definition | Please ensure there are no RED highlighted cells before submitting this form
Document date: |  | [NAME]
Reference: |  | 16 Characters
Requestor: |  | 25 Characters |  | Balance Control |  |  | Balance Control
Posting Date: |  | [NAME] |  | Debits |  |  | Profit and Loss
Posting Period: |  |  |  | Credits |  |  | Balance sheet
Lead Company Code: |  | 4 Characters |  | Control Total |  |  | Control Total
Currency: |  | 3 Characters
Document Type: |  | 2 Characters |  | Special Charaters
[NAME]: |  | [NAME] |  | Special Charaters
Originating PC
IAP RITM
Line Item Data
Company Code | G/L Account | Cost Centre | Profit Centre | WBS Element | Order No | Assignment | Line Item Text | Debit Amount | Credit Amount | FOM Compliance Code | Reason code | Partner Profit Centre | Transaction Type | Employee ID
 | 132000 |  |  |  |  |  | Test1! | 100
 | 139025 |  |  |  |  |  | Test2 | 100 | 100
 | 212500 |  |  |  |  |  | Test3& | 200
 | 600000 |  |  |  |  |  | Test | 100 | 200
Spreadsheet: 795092d1662500860-multiple-closest-matches-with-multiple-criteria-book1-tool_fairy-
Sheet: Summary

Current - With [NAME]
Name | Bk1 Rot | Bk1 Act | Bk1 Dif | Bk1 [NAME] | [NAME] | Lun Act | Lun Dif | [NAME] | Bk2 Rot | Bk2 Act | Bk2 Dif | Bk2 [NAME]
Staff 1
Staff 2
Staff 3
Staff 4 |  |  |  |  |  |  |  |  |  |  |  |  | << 14:04 till 14:13
Staff 5
Staff 6
Staff 7
Staff 8
Expected - No formulas
Name | Bk1 Rot | Bk1 Act | Bk1 Dif | Bk1 [NAME] | [NAME] | Lun Act | Lun Dif | [NAME] | Bk2 Rot | Bk2 Act | Bk2 Dif | Bk2 [NAME]
Staff 1 | 12:00:00 | 12:14:00 | 14 | 9.000000000000128 | 13:45:00 | 13:51:00 | 6 | 30 | 16:00:00 | 16:15:00 | 15 | 8.999999999999968
Staff 2 | 12:15:00 | 12:16:00 | 1 | 10.99999999999996 | 14:15:00 | 14:19:00 | 4 | 30 | 15:45:00 | 15:50:00 | 5 | 11.00000000000012
Staff 3 | 11:15:00 | 11:16:00 | 1 | 10.00000000000004 | 13:45:00 | 13:47:00 | 2 | 30 | 15:15:00 | 15:21:00 | 6 | 9.999999999999964
Staff 4 | 10:15:00 | 10:21:00 | 6 | 9.999999999999964 | 12:15:00 | 12:22:00 | 7 | 31 | 14:15:00 | 14:04:00 | -11 | 10
Staff 5 | 10:00:00 | 10:01:00 | 1 | 9.999999999999964 | 11:45:00 | 11:46:00 | 1 | 30 | 14:00:00 | 14:01:00 | 1 | 9.999999999999964
Staff 6 | 12:00:00 | 12:02:00 | 2 | 9.999999999999964 | 13:45:00 | 13:45:00 | 0 | 29 | 16:00:00 | 15:57:00 | -3 | 10.00000000000012
Staff 7 | 11:45:00 | 12:09:00 | 24 | 10.00000000000012 | 14:00:00 | 14:10:00 | 10 | 29 | 15:45:00 | 15:55:00 | 10 | 9.000000000000128
Staff 8 | - | - | - | - | - | - | - | - | - | - | - | -
Spreadsheet: 92745d1292307101-iteration-continuously-increases-after
Sheet: ThisWeeksGames

Week | Day | Date | Away | PtsA |  | Home | PtsH | MyLine | MyTotals | AwayActualLine | AwayTotalLine | LineOff | TotalOff | Team to Pick | Total to Pick | Who Covered? | Correct | Over/Under? | Correct | PickEm | Correct
14 | Thu | 2010-12-09 00:00:00 | Indianapolis Colts | 30 | @ | Tennessee Titans | 28 |  |  | -3 | 44.5
14 | Sun | 2010-12-12 00:00:00 | [NAME] | 6 | @ | Buffalo Bills | 13 |  |  | 0 | 39
14 | Sun | 2010-12-12 00:00:00 | Atlanta Falcons | 31 | @ | Carolina Panthers | 10 |  |  | -8.5 | 42.5
14 | Sun | 2010-12-12 00:00:00 | New England Patriots | 36 | @ | Chicago Bears | 7 |  |  | -3 | 37.5
14 | Sun | 2010-12-12 00:00:00 | Denver Broncos | 13 | @ | Arizona Cardinals | 43 |  |  | -4 | 42.5
14 | Sun | 2010-12-12 00:00:00 | Philadelphia Eagles | 30 | @ | Dallas Cowboys | 27 |  |  | -3.5 | 50.5
14 | Sun | 2010-12-12 00:00:00 | Green Bay Packers | 3 | @ | Detroit Lions | 7 |  |  | -7 | 46
14 | Sun | 2010-12-12 00:00:00 | Oakland Raiders | 31 | @ | [NAME] | 38 |  |  | 4 | 42.5
14 | Sun | 2010-12-12 00:00:00 | New York Giants | 21 | @ | Minnesota Vikings | 3 |  |  | -2 | 43
14 | Sun | 2010-12-12 00:00:00 | St. Louis Rams | 13 | @ | New Orleans Saints | 31 |  |  | 9.5 | 47
14 | Sun | 2010-12-12 00:00:00 | [NAME] | 10 | @ | New York Jets | 6 |  |  | 5 | 39.5
14 | Sun | 2010-12-12 00:00:00 | Cincinnati Bengals | 7 | @ | Pittsburgh Steelers | 23 |  |  | 9.5 | 39.5
14 | Sun | 2010-12-12 00:00:00 | Kansas City Chiefs | 0 | @ | San Diego Chargers | 31 |  |  | 9.5 | 45.5
14 | Sun | 2010-12-12 00:00:00 | [NAME] | 21 | @ | San Francisco 49ers | 40 |  |  | 5.5 | 41.5
14 | Sun | 2010-12-12 00:00:00 | Tampa Bay Buccaneers | 17 | @ | Washington Redskins | 16 |  |  | 0 | 41
14 | Mon | 2010-12-13 00:00:00 | Baltimore Ravens | 34 | @ | Houston Texans | 28 |  |  | -2.5 | 46
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | Total Win % |  | PickEm Win %
Spreadsheet: 833549d1687078712-why-this-formula-does-not-work-with-several-tables-ranges-countblank-range-countblankforseveraltables
Sheet: Sheet1

Blanks | *=COUNTBLANK(Table1,Table2)
No. | Item | 2016 | 2017 | 2018 | 2019 | 2020
1
2
3
4
5
6
No. | Item | 2021 | 2022 | 2023 | 2024 | 2025
1
2
3
4
5
6
Spreadsheet: 492709d1481217424-sum-data-in-multiple-columns-example-data-
Sheet: Example

Example:
Title | Year | Amount | Year | Amount | Year | Amount | Year | Amount
NAME 1 | 2011 | 100 | 2011 | 125 | 2013 | 200 | 2013 | 50
[NAME] 2 | 2011 | 50 | 2011 | 75 | 2012 | 50 | 2014 | 25
NAME 3 | 2013 | 50 | 2013 | 25 | 2014 | 100 | 2015 | 20
NAME 4 | 2012 | 125 | 2014 | 25 | 2015 | 50 | 2015 | 25
Desired:
Title | 2011 | 2012 | 2013 | 2014 | 2015
NAME 1 | 225 | 0 | 250 | 0 | 0
[NAME] 2 | 125 | 50 | 0 | 25 | 0
NAME 3 | 0 | 0 | 75 | 100 | 20
NAME 4 | 125 | 0 | 0 | 25 | 75
Spreadsheet: 690816d1597309613-simple-warehouse-location-management-template-my-sample-wms
Sheet: Lookup Page

EXPECTED RESULT
Code Check | CODE | [NAME]
 | CK3 | CK3
RACKS | QUANTITIES
A1 | 3
A2 | 52
B1 | 44
B2 | 32
C1 | 456
C2 | 71
Spreadsheet: 804944d1668442916-want-to-sum-values-across-multiple-sheets-with-multiple-criteria-chemical-usage
Sheet: 2-May-2022

Magnacide Application Spreadsheet
Date: |  |  | Application Method |  | Applicator |  | Certificate #
 |  |  | Injection |  | [NAME] |  | [NAME]
P.C.P. # | 10948 |  | Water Coordinator |  | [NAME]
Tank Serial # | AA954248 |  |  |  | [NAME]
Location (County) |  |  | Start Time | am | End Time | am | Total Time (min)
 |  |  |  | pm |  | pm
Land Location |  |  |  | Pest Controlled
 |  |  | Algae |  | Submerged Aquatic
Location ID (Lateral) |  |  | Canal Flow (ft³/s) |  | Water Temperature
Precipitation (Y/N) |  |  | Orifice |  | Reg  |  PSI  |  Tank |  | Volume from Chart
Y | N
Start Wind Speed/Direction (km/h) |  |  | PPM Magnacide |  | PPM Acrolein |  | Treatment Rate (GPM)
End Wind Speed/Direction (km/h) |  |  | [NAME] |  | End Gal |  | Total Usage
 |  |  |  |  |  |  | 15
Notes
Date: |  |  | Application Method |  | Applicator |  | Certificate #
 |  |  | Injection |  | [NAME] |  | [NAME]
P.C.P. # | 10948 |  | Water Coordinator |  | [NAME]
Tank Serial # | E8692 |  |  |  | [NAME]
Location (County) |  |  | Start Time | am | End Time | am | Total Time (min)
 |  |  |  | pm |  | pm
Land Location |  |  |  | Pest Controlled
 |  |  | Algae |  | Submerged Aquatic
Location ID (Lateral) |  |  | Canal Flow (ft³/s) |  | Water Temperature
Precipitation (Y/N) |  |  | Orifice |  | Reg  |  PSI  |  Tank |  | Volume from Chart
Y | N
Start Wind Speed/Direction (km/h) |  |  | PPM Magnacide |  | PPM Acrolein |  | Treatment Rate (GPM)
End Wind Speed/Direction (km/h) |  |  | [NAME] |  | End Gal |  | Total Usage
 |  |  |  |  |  |  | 7
Notes
Spreadsheet: mike_carson__27576__KOCH
Sheet: Sheet1

 | Power for delivery 1/9/02
 | On-Peak
 |  | EPMI | [NAME]'s
 |  | MW | AVG |  | Credit | EPMI | Total
 |  | Postion | Price |  | Fee | COST | Dollars
 | Entergy | 100 | 19.45 |  | 1
 | TVA | 0 |  |  | 1
 | Cinergy | -700 | 20.35 |  | 1
 | Comed | -100 | 19.5 |  | 1
 | Off-Peak
 |  | EPMI | [NAME]'s
 |  | MW | AVG |  | Credit |  | Total
 |  | Postion | Price |  | Fee |  | Dollars
 | Entergy | 0 |  |  | 1
 | TVA | 0 |  |  | 1
 | Cinergy | -50 | 14.5 |  | 1
 | Comed | 0 |  |  | 1
 |  |  |  |  | Grand |  | Wire Amount
 |  |  |  |  | Total | >>>>>>
Spreadsheet: 437452d1451350237-possible-scenarios-possible
Sheet: Scenarios

Employee | Widgets | Hours | Widgets per hour
Terrence | 125 | 40
[NAME] | 105 | 38
[NAME] | 225 | 40
Total
Employee | Widgets | Hours | Widgets per hour
Terrence | 125 | 40
[NAME] | 105 | 38
[NAME] | 125 | 41
Total
Employee | Widgets | Hours | Widgets per hour
Terrence | 125 | 40
[NAME] | 105 | 38
Zack | 221 | 40
Total
Spreadsheet: 747046d1631197096-formula-to-combine-forecast-data-with-ingoing-materials-of-forecasted-items-book1-6-
Sheet: Material forecast

 |  | Material forecast per SKU
 |  | Item name | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 2022 | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | 2023 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | 2024 | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 | 2025-06-01 00:00:00 | 2025-07-01 00:00:00 | 2025-08-01 00:00:00 | 2025-09-01 00:00:00 | 2025-10-01 00:00:00 | 2025-11-01 00:00:00 | 2025-12-01 00:00:00 | 2025
 |  | Item 1
 |  | Item 2
 |  | Item 3
 |  | Item 4
 |  | Item 5
 |  | Item 6
 |  | Item 7
 |  | Item 8
 |  | Item 9
 |  | Item 10
Spreadsheet: 770051d1645794350-dropdown-list-from-multiple-sheets-example-3-
Sheet: Summary

[NAME]
Quarterly Financials Summary File
Period | FY 2021
Updated per: | 31/12/2021 | Revenues | Gross Income | EBITDA | Cash & Cash Equivalents
 | Company 1
 | Company 2
 | Company 3
 | Company 4
 | Company 5
 | Company 6
 | Company 7
 | Company 8
 | Company 9
 | Company 10
 | Company 11
 | Company 12
Q1 2021
Q2 2021
Q3 2021
Q4 2021
FY 2021
Q1 2022
Q2 2022
Q3 2022
[NAME]
FY 2022
Q1 2023
Q2 2023
Q3 2023
Q4 2023
FY 2023
Spreadsheet: 703642d1605096951-search-box-for-named-ranges-test-case-files
Sheet: CASE2

Issue | CASE2
current status | Resolved
summary | 1
 | 2
 | 3
note
case |  | note | audit week | Resolved date
ID NUMBERS |  | [NAME] | [NAME] | DATE
ID NUMBERS |  | [NAME] | [NAME] | DATE
ID NUMBERS |  | [NAME] | [NAME] | DATE
ID NUMBERS |  | [NAME] | [NAME] | DATE
ID NUMBERS |  | [NAME] | [NAME] | DATE
ID NUMBERS |  | [NAME] | [NAME] | DATE
ID NUMBERS |  | [NAME] | [NAME] | DATE
ID NUMBERS |  | [NAME] | [NAME] | DATE
ID NUMBERS |  | [NAME] | [NAME] | DATE
Spreadsheet: 758179d1638722436-index-formulas-to-rearrange-from-vertical-to-horizontal-tf16400504_win32
Sheet: My New Recipe

 |  | My New Recipe |  |  | Appetizer | Recipe Index
 |  | Amount | Measurement | Ingredient | Directions | Preparation Time
 |  | 1 | Box | Crackers | Using a knife, smear desired amount of cream cheese onto one side of a cracker.   Place a small slice of smoked salmon on top of the cream cheese.  Add several drops of honey mustard-dill sauce on top of the salmon.  Top with a small amount of dill | 5 Minutes
 |  | 1 | Package | Cream Cheese
 | Calories | 1 | Package | [NAME]
 | 60 | 1 | Tablespoon | Honey mustard-dill sauce |  | Cook Time
 |  | 5 | [NAME] (s) | Fresh Dill |  | 0 Minutes
 | Recipe Tags
 | salmon, crackers, cream cheese
 |  |  |  |  |  | Yield (Servings)
 | Comments |  |  |  |  | 12 Servings
 | A recipe in progress
Spreadsheet: 741214d1626903762-help-on-xlookup-formula-with-multiple-criteria-price3category
Sheet: ORDER

 | PRODUCT | QTY | UNIT | CATEGORY | UNIT PRICE | TOTAL PRICE
 | APPLE | 3 | BOX | TRADE | 30
 | ORANGE JUICE | 3 | PAIL | TRADE | 12
 | MANGO | 2 | PIECE | DISTRIBUTOR | 7
 | MANGO | 4 | BOX | RETAIL | 45
 | STRAWBERRY | 2 | PIECE | RETAIL | 10
 | [NAME] | 1 | BAG | DISTRIBUTOR | 7
Spreadsheet: 731298d1620284621-calculate-quantity-based-on-multiple-conditions-fifo_model_for_many_products_no_vba_v5
Sheet: multiple products

 |  |  | INVENTORY MODEL. FIFO CALCULATION. MULTIPLE  SKUs!!!!!!!
 |  |  |  | Purchase |  |  | Usage |  |  |  | Closing balance
 |  |  | SKU | Quantity | Value | Unit price | SKU | Quantity | Value | Unit price | Quantity | Value | Unit price
 |  |  | A
 |  |  | B
 | INSERT ROWS |  | X
 |  |  | C
 |  |  | Total |  |  |  | Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | INVENTORY SPLIT BY FIFO
 |  |  | Purchase |  |  |  | Usage |  |  |  |  |  |  |  | ONLY FOR EXCEL GEEKS & NERDS!!! |  |  |  |  |  | Total |  |  |  | Total |  |  |  | Total |  |  |  | Total
 | SKU/ID | ID | SKU | Quantity | Value | Unit price | SKU | Quantity | Value | Unit price |  |  |  |  | Technical column 1 | Technical column 2 | Technical column 3 | Value | Value with validation |  | SKU | Quantity | Value | Unit price | SKU | Quantity | Value | Unit price | SKU | Quantity | Value | Unit price | SKU | Quantity | Value | Unit price
 |  |  |  | 0 | 0 | 0 | do not amend this row, ANYWHERE!!! |  |  |  |  |  |  |  | do not amend this row, ANYWHERE!!!
 |  |  |  | 0 | 0 |  | do not amend this row, ANYWHERE!!! |  |  |  |  |  |  |  | do not amend this row, ANYWHERE!!!
 |  | 1 | A | 3 | 100 |  | A | 1
 |  |  | A | 6 | 100 |  | A | 4
 |  |  | B | 12 | 20 |  | A | 1
 |  |  | A | 7 | 7 |  | A | 8
 |  |  | A | 8 | 64 |  | B | 10
 |  |  | A | 6 | 1 |  | B | 1
 |  |  | B | 2 | 1 |  | A | 12
 |  |  | A | 2 | 4 |  |  | 12
 |  |  | A | 1 | 10 |  |  | 12
 |  |  | A | 12 | 0 |  |  | 12
 |  |  | A | 0 | 0 |  | B | 1
 |  |  | A | 0 | 0
 |  |  | A | 0 | 0
 |  |  | A | 0 | 0
 |  |  | C | 10 | 150
 |  |  | C | 12 | 123
 |  |  | X | 9 | 100
 |  |  | X | 8 | 90
 |  |  | X | 12 | 80
 |  |  | X | 15 | 70 |  | X | 36
 |  |  |  |  |  |  |  |  |  |  |  | AND THEN COPY FORMULA
 |  |  |  |  |  |  |  |  |  |  |  | FROM ROW 34
 |  | 1000 | C | 1 | 9 |  | C | 21
Spreadsheet: 780620d1652618917-data-not-extracted-applying-and-criteria-in-filter-function-dummy-test
Sheet: Data

125 | A | 25
326 | B |  |  |  | 45
126 | C | 60
364 | D
316 | F | 75 |  |  | 35
46 | G | 80
124 | K | 65 |  |  | 32
468 | M |  | 25 | 36
Spreadsheet: 266952d1379876963-need-a-formula-which-will-show-a-payout-grid-range
Sheet: Sheet1

Amount | Expected Output |  | Min Value | [NAME] | Grid
6431 | 5000+ |  | 0 | 0 | 0
3631 | 3001-4000 |  | 1 | 500 | 0-500
3139 | 3001-4000 |  | 501 | 1000 | 501-1000
7902 | 5000+ |  | 1001 | 2000 | 1001-2000
4120 | 4001-5000 |  | 2001 | 3000 | 2001-3000
1585 | 1001-2000 |  | 3001 | 4000 | 3001-4000
13239 | 5000+ |  | 4001 | 5000 | 4001-5000
100 | 0-500 |  | 5001 |  | 5000+
7333 | 5000+
0 | 0
7000 | 5000+
700 | 501-1000
500 | 0-500
5648 | 5000+
14764 | 5000+
0 | 0
2423 | 2001-3000
12894 | 5000+
3210 | 3001-4000
800 | 501-1000
0 | 0
3979 | 3001-4000
1066 | 1001-2000
8588 | 5000+
Spreadsheet: 16c0646d-9f7b-4557-b1f0-b5748af1739e
Sheet: 10

 | [NAME] گسترش و نوسازی صنایع ایرانیان مانا ( سهامی خاص )
 | یادداشتهای توضیحی صورتهای مالی
 | دوره مالي شش ماهه منتهي به 31 خرداد ماه 1390
 | 4-موجودی نقد
 |  |  |  | يادداشت |  | 1390/03/31 |  | 1389/09/30
 |  |  |  |  |  | ریال |  | ریال
 | موجودی نقد نزد صندوق |  |  |  |  | 1215990092 |  | 0
 | موجودی نقدی ارزی نزد صندوق |  |  |  |  | 14882943 |  | 0
 | موجودی نقد نزد بانکها |  |  | 4-1
 | [NAME] باکارفرمایان |  |  | 4-2
 | تنخواه گردانها |  |  | 4-3 |  |  |  | 3888767162
 | وجوه بین راهی |  |  |  |  | 0 |  | 1680000000
 | 4-1- موجودي نزد بانك ها از اقلام ز‌ير [NAME] |  |  |  |  | 1390/03/31 |  | 1389/09/30
 |  |  |  |  |  | ریال |  | ریال
 | سپرده های کوتاه مدت ديداری |  |  | 4-1-1
 | حسابهای جاری |  |  | 4-1-2 |  |  |  | 977221408
 | حسابهای جاری ارزی |  |  | 4-1-3 |  | 1179600 |  | 1035600
 | 4-1-1   صورت ريزسپرده های کوتاه مدت ديداری نزد بانکها به شرح زير مي باشد:
 |  |  |  |  |  | 1390/03/31 |  | 1389/09/30
 |  |  |  |  |  | ریال |  | ریال
 | بانک پاسارگاد سلیمان خاطر  [PHONE] |  |  |  |  | 1427472 |  | 10000
 | [NAME]طرح سپاس ) |  |  |  |  |  |  | 922877754
 | [NAME]       29217/53 |  |  |  |  | 127193245 |  | 128578370
 | [NAME] میرزای شیراز  [PHONE] |  |  |  |  | 0 |  | 17544961
 | [NAME] میرزای شیراز  [PHONE] |  |  |  |  | 0 |  | 200566
 | [NAME] سپرده سلیمان خاطر221/8100/839504/1 |  |  |  |  | 0 |  | 3737291
 | [NAME]
 | مبلغ 128،620،717ريال ازسپرده های کوتاه مدت ديداری به منظورصدورضمانت نامه های بانکی به نفع کارفرمايان وثیقه شده است .
 | نرخ سودتضمين شده سپرده های کوتاه مدت ديداری برای سال جاری براساس قانون [NAME] ربا [NAME].
Spreadsheet: 142387d1329819562-how-to-select-maximum-values-based-on-age-in-a-cell-with-an-existing-drop-down-list-pensions-calcs-v2mod
Sheet: Pension Plan Projections

 | Personal Details
 | Name | [NAME]
 | Date of Birth | 1981-01-01 00:00:00
 | Age
 | Dependent Children? | No
 | Annual Salary | 50000
Contributions | Employee Contribution | Employer Contribution | Additional Voluntary Contribution (if applicable)
If based on % then please select from drop-down | 0.05 | 0.075 | 0
If based on € amount (monthly) then please enter amount
Monthly Contribution in Eur
 |  | Total Monthly Contribution
Spreadsheet: 823727d1680113451-how-to-find-coordinates-using-slope-and-height-sample-workbook
Sheet: coords (empty)

row | column | height | slope | x coordinate | y coordinate
1 | 1 |  |  | formula | formula
1 | 2
1 | 3
1 | 4
1 | 5