tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 183802d1349044653-making-a-cell-give-the-date-the-fist-monday-of-the-month-frankday_864524-making-a-cell-give-the-date-the-fist-monday-of-the-month_30sep12_01
Sheet: Sheet1

Date | 1st Monday | 2nd Monday | 3rd Monday | 4th Monday | 5th Monday |  |  |  | Month | 1st Monday | 2nd Monday | 3rd Monday | 4th Monday | 5th Monday
2012-01-01 00:00:00 |  |  |  |  |  |  |  |  | 2012-01-01 00:00:00
2012-02-04 00:00:00 |  |  |  |  |  |  |  |  | 2012-02-01 00:00:00
2012-03-07 00:00:00 |  |  |  |  |  |  |  |  | 2012-03-01 00:00:00
2012-04-10 00:00:00 |  |  |  |  |  |  |  |  | 2012-04-01 00:00:00
2012-05-13 00:00:00 |  |  |  |  |  |  |  |  | 2012-05-01 00:00:00
2012-06-16 00:00:00 |  |  |  |  |  |  |  |  | 2012-06-01 00:00:00
2012-07-19 00:00:00 |  |  |  |  |  |  |  |  | 2012-07-01 00:00:00
2012-08-22 00:00:00 |  |  |  |  |  |  |  |  | 2012-08-01 00:00:00
2012-09-25 00:00:00 |  |  |  |  |  |  |  |  | 2012-09-01 00:00:00
2012-10-28 00:00:00 |  |  |  |  |  |  |  |  | 2012-10-01 00:00:00
2012-11-30 00:00:00 |  |  |  |  |  |  |  |  | 2012-11-01 00:00:00
2012-12-31 00:00:00 |  |  |  |  |  |  |  |  | 2012-12-01 00:00:00
 |  |  |  |  |  |  |  |  | ^^^^^^^^
 |  |  |  |  |  |  |  |  | =$[NAME]))
^^^^^^^^^
=EOMONTH($A2,-1)+1+LOOKUP(WEEKDAY(EOMONTH($A2,-1)+1),ROW($1:$7),MOD(9-ROW($1:$7),9-2))+(7*(COLUMN(A1)-1))
Spreadsheet: 701742d1603904566-help-witth-averageif-book1
Sheet: 2020

 | 2 | 3 | 0 | 3
 |  | 2 | 2 | 0
 |  | 1 | 0 | 4
 |  | 2 | 4 | 4
 |  | 3 | 0 | 2
 |  | 2 | 0 | 2
 |  | 1 | 1 | 0
 |  | 3 | 3 | 0
 |  | 1 | 3 | 3
 |  | 3 | 1 | 0
 |  | 2 | 0 | 1
 |  | 1 | 2 | 1
 |  | 3 | 3 | 2
Spreadsheet: 769656d1645630029-create-a-lower-and-upper-estimate-with-a-200-minimum-difference-requirement-book1
Sheet: Sheet1

Estimate | Lower | Upper
348
376
404
432
460
488
516
544
572
600
628
656
684
712
740
768
796
824
852
880
908
936
964
992
1020
Spreadsheet: 77490d1277945311-conditional-shape-of-an-arrow-based-on-cell-value-drawlines
Sheet: Sheet1

0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16
1 |  |  |  |  |  |  |  |  |  |  |  |  | Rises | 7
2 |  |  |  |  |  |  |  |  |  |  |  |  | Runs | 6
3
4 |  |  |  |  |  |  |  |  |  |  |  |  | Height | 55 | 7 | Rise | 7.857142857142857
5 |  |  |  |  |  |  |  |  |  |  |  |  | Travel | 52.5 | 6 | Run | 8.25
6
7 |  |  |  |  |  |  |  |  |  |  |  |  | Total Stringer length |  | 76.03453162872775 | 7
8 |  |  |  |  |  |  |  |  |  |  |  |  | Top Railing |  | 78.13609921156802 | 7
9
10 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | 8
11 |  |  |  |  |  |  |  |  |  |  |  |  | 2x6 Stilts/ft |  | 5
12
13
14
15
16
Spreadsheet: 138348d1327616539-if-and-lookup-bid-sheet-to-po
Sheet: Sheet1

3.a.
Item | Description | Unit | Village Produce | City Produce | Country Produce | Best Bid $ | Best Company Quote | Last Price Paid
Avocados | 48 ct. | Case | 61.8 | 60.3 | 59.46 |  |  | 57.94
Cauliflower | 12 ct. | Case | 12.8 | 12.9 | 13.27 |  |  | 13.26
Cucumbers | Medium | Case | 11.1 | 11.52 | 10.91 |  |  | 11.34
Grapes | Red Seedless | [NAME] | 19.32 | 19.5 | 19.14 |  |  | 18.72
Lettuce | [NAME], 24 ct. | Case | 9.53 | 9.84 | 10.27 |  |  | 10.02
Lettuce | Romaine, 24 ct. | Case | 17.75 | 17.82 | 18.22 |  |  | 18.1
Pears | D'Anjou | Case | 20.82 | 20.58 | 20.64 |  |  | 20.62
Peppers | [NAME], Med. | Case | 8.3 | 8.38 | 9.28 |  |  | 9.02
Pineapples | 7 ct. | Case | 10.5 | 10.38 | 10.68 |  |  | 10.08
Potatoes | B Reds | 50# [NAME] | 15.06 | 14.82 | 14.88 |  |  | 14.98
Potatoes | Peeled, Large | 25# [NAME] | 17.52 | 17.22 | 17.28 |  |  | 17.18
Squash | Yellow #2 | 30# Case | 8.55 | 8.71 | 8.98 |  |  | 9.1
Strawberries | Driscoll | Flat | 18.29 | 18.06 | 17.1 |  |  | 18.3
3.b.
Item | Description | Unit | Par Value | On Hand | Special Order | Order Amount
Avocados | 48 ct. | Case | 6 | 2 | 3
Cauliflower | 12 ct. | Case | 5 | 1
Cucumbers | Medium | Case | 3 | 0
Grapes | Red Seedless | [NAME] | 4 | 1
Lettuce | [NAME], 24 ct. | Case | 5 | 2 | 4
Lettuce | Romaine, 24 ct. | Case | 3 | 0.5
Pears | D'Anjou | Case | 3 | 1
Peppers | [NAME], Med. | Case | 7 | 2 | 5
Pineapples | 7 ct. | Case | 4 | 0
Potatoes | B Reds | 50# [NAME] | 3 | 0.5
Potatoes | Peeled, Large | 25# [NAME] | 4 | 1 | 4
Squash | Yellow #2 | 30# Case | 5 | 2 | 2
Strawberries | Driscoll | Flat | 3 | 1.5
3.c.
 |  | [NAME]
Supplier |  |  |  | [NAME]
Company Name: | Village Produce |  |  | P.O. Number | 456
Street Address: | 123 Somewhere |  |  | Order Date: | 2000-01-01 00:00:00
City, State, Zip: | Village, CA 12345 |  |  | Delivery Date: | 2000-01-02 00:00:00
Phone Number: | 555-5555 |  |  | Phone Number: | 555-5557
Fax Number: | 555-5556 |  |  | Fax Number: | 555-5558
E-Mail: | [EMAIL] |  |  | E-Mail: | [EMAIL]
Contact: | Mr. [NAME] |  |  | Buyer: | Ms. [NAME]
Item | Description | Unit | Quantity | Unit Price $ | Extension
Total
Spreadsheet: 845154d1696677496-problem-with-rank-formula-problem-with-ranking
Sheet: Sheet1

 |  | [NAME] |  |  | [NAME] |  |  | [NAME] |  |  | [NAME]
 | Value | Rank |  | Serial | Index - Match |  | Value | Rank |  | Serial | Index - Match
 | -0.5999999999999996 |  |  | 1 |  |  | -0.5999999999999996 |  |  | 1
 | -1.05 |  |  |  |  |  | -1.05
 | 2.85 |  |  |  |  |  | 2.85
 | 0.5500000000000005 |  |  |  |  |  | 0.5500000000000005
 | 0.5500000000000005 |  |  |  |  |  | 0.5500000000000005
 | 12.8 |  |  |  |  |  | 12.8
 | 6.750000000000001 |  |  |  |  |  | 6.750000000000001
 | -10.7 |  |  |  |  |  | -10.7
 | 12.8 |  |  |  |  |  | 12.8
 | -0.6000000000000003 |  |  |  |  |  | -0.6000000000000003
 | -11.45 |  |  |  |  |  | -11.45
 | 10.9 |  |  |  |  |  | 10.9
 | -0.4499999999999997 |  |  |  |  |  | -0.4499999999999997
 | -4.5 |  |  |  |  |  | -4.5
 | -4.350000000000001 |  |  |  |  |  | -4.350000000000001
 | -7.8 |  |  |  |  |  | -7.8
 | -3.9 |  |  |  |  |  | -3.9
 | 2.6 |  |  |  |  |  | 2.6
 | -12.6 |  |  |  |  |  | -12.6
 | 3.65 |  |  |  |  |  | 3.65
 | -0.4499999999999995 |  |  |  |  |  | -0.4499999999999995
 | -0.8499999999999996 |  |  |  |  |  | -0.8499999999999996
 | 2.2 |  |  |  |  |  | 2.2
Spreadsheet: 0791d3d9-ae77-4c49-bd54-8b3347914f8a
Sheet: 1997-98

Table N
Students Domiciled within the UK by Method of Study
Country/Region | Undergraduate |  |  | Graduate |  |  | Total
 | Full Time | Part Time | Total | Full Time | Part Time | Total
England
Greater London | 3032 | 116 |  | 969 | 704
South East | 2257 | 47 |  | 607 | 339
South West | 613 | 4 |  | 136 | 30
North and Yorkshire | 310 | 4 |  | 93 | 13
North West | 304 | 7 |  | 83 | 17
Midlands | 556 | 6 |  | 143 | 42
East Anglia | 272 | 7 |  | 75 | 86
Not Known | 1 | 1 |  | 9 | 2
Subtotal
Northern Ireland | 25 | 1 |  | 13 | 3
Scotland | 89 | 1 |  | 64 | 6
Wales | 181 | 2 |  | 35 | 9
Channel Isles and Isle of Man | 25 | 0 |  | 3 | 0
Not Known | 21 | 25 |  | 5 | 13
Total
This table is concerned with students whose domicile at the time of application is within the UK irrespective of nationality.
The sum of Tables N and O is equivalent to the total number of students attending UCL.
Spreadsheet: 217404d1362062156-auto-filling-an-annual-leave-calendar-annual-leave-tracker-draft
Sheet: Leave Applications

 |  | Date Requested
Name | Initials | From | Full Day/ Half Day  (If single day) | To  (If multiple days) | Number of days | Accepted/ Rejected/ Pending (A/R/P) | Authoriser | Comments
[NAME] | MA | 2013-01-02 00:00:00 | Full Day |  | 1 | A | Allan Davies |  |  |  |  | AM
[NAME] | MO | 2013-04-13 00:00:00 | PM |  | 0.5 | R | Allan Davies |  |  |  |  | PM
[NAME] | PS | 2013-05-24 00:00:00 | AM |  | 0.5 | A | Allan Davies |  |  |  |  | Full Day
[NAME] | SC | 2013-06-14 00:00:00 |  | 2013-06-17 00:00:00 | 4 | P
Spreadsheet: 69853d1270541088-pulling-info-out-of-an-old-layout-oct-08
Sheet: 10-13-08 2nd

Daily Problem Report |  |  |  |  |  | 2nd shift |  | Date |  | 2008-10-13 00:00:00
 |  | Daily cases |  | Daily hours |  | Daily Avg Per Month |  | Note
ER |  | 6 |  | 2 |  | 4.2
PR |  | 0 |  |  |  | 2.1
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
ER |  | 5-1 | 67185/6-08010/20-00 |  | Problem: O/L burr & misloacted part |  |  | Station: 5/5 |  | Ran: 0 of 1200 | 0.5
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause: | Too much clearance & too much weld |  |  | 1215-1245
 |  |  |  |  | Explain: | Caulked the edge a bit and ground on the weld. |  |  |  |  | M.S
 |  |  |  |  | Frontside 5/5. Lower cutter on the top surface needs to be oranged to a part.
Stamping T/L: [NAME]
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
ER |  | 3-1 | 53731/2-08020-00 |  | Problem: O/Lburr |  |  | Station:4/6,6/6 |  | Ran:0        of 900 | 0.5
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause: | Too much clearance . |  |  | 4:30-5:00
 |  |  |  |  | Explain: | Front side horseshoe and the backside parting cutter was caulked.This was ok for production |  |  |  |  | [NAME]
 |  |  |  |  | This die will need to come to the shop for repairs after production.
Stamping T/L: [NAME]
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
 |  |  |  |  | Problem: |  |  | Station: |  | Ran:
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause:
 |  |  |  |  | Explain:
Stamping T/L:
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
 |  |  |  |  | Problem: |  |  | Station: |  | Ran:
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause:
 |  |  |  |  | Explain:
Stamping T/L:
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
 |  |  |  |  | Problem: |  |  | Station: |  | Ran:
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause:
 |  |  |  |  | Explain:
Stamping T/L:
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
 |  |  |  |  | Problem: |  |  | Station: |  | Ran:
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause:
 |  |  |  |  | Explain:
Stamping T/L:
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
 |  |  |  |  | Problem: |  |  | Station: |  | Ran:
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause:
 |  |  |  |  | Explain:
Stamping T/L:
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
 |  |  |  |  | Problem: |  |  | Station: |  | Ran:
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause:
 |  |  |  |  | Explain:
Stamping T/L:
Misc.Notes:
Spreadsheet: 885071d1734491597-granulating-weekly-timesheet-to-days-vlookup-index-formula-timesheet-demo
Sheet: Transformation Format

Date | Employee | Pay Item | Class/Project | Service/Role | Hours | Description
2024-12-02 00:00:00 | [NAME] | Regular Pay | [NAME] | Management | 4 | Working on this stupid spreadsheet
2024-12-03 00:00:00 | [NAME] | Sick | HR | Stat/Vac/Sick | 8 | [NAME]
2024-12-04 00:00:00 | [NAME] | Regular Pay | [NAME] | Management | 4 | Working on this stupid spreadsheet
2024-12-05 00:00:00 | [NAME] | Regular Pay | [NAME] | Management | 2 | Working on this stupid spreadsheet
2024-12-06 00:00:00 | [NAME] | Regular Pay | [NAME] | Management | 2 | Working on this stupid spreadsheet
2024-12-02 00:00:00 | Bojangles | Regular Pay | Lodge | Reporting | 4 | Building walls
2024-12-03 00:00:00 | Bojangles | Regular Pay | Lodge | Reporting | 2 | Building walls
2024-12-04 00:00:00 | Bojangles | Regular Pay | Lodge | Reporting | 1 | Building walls
2024-12-03 00:00:00 | Slugger | Regular Pay | Geese | Reporting | 1 | Reporting on Geese etc
Spreadsheet: 876275d1722959840-show-hide-rows-of-teams-as-match-pairs-regarding-data-1_show_or_hide_football_matches_pairs
Sheet: Sheet3(Desired TotalGoals 2.5)

B1 | Newcastle United | 0 | 3
B2 | Fulham | 0 | 0
C1 | Manchester City | 1 | 2
C2 | Crystal Palace | 0 | 2
[NAME] | West Ham United | 2 | 3
G2 | [NAME] | 0 | 0
H1 | Brentford | 1 | 1
H2 | [NAME] | 0 | 2
Spreadsheet: 112289d1308408791-how-to-copy-cells-based-on-to-new-page-formula-aproach
Sheet: results

row3 | row3b | row3c | 0.2
row7 | row7b | row7c | 0.18
row8 | row8b | row8c | 0.18
row9 | row9b | row9c | 0.17
row12 | row12b | row12c | 0.2
row13 | row13b | row13c | 0.14
row16 | row16b | row16c | 0.12
row19 | row19b | row19c | 0.13
[NAME] | row20b | row20c | 0.12
row21 | row21b | row21c | 0.14
[NAME] | row22b | row22c | 0.12
row23 | row23b | row23c | 0.12
row24 | row24b | row24c | 0.2
Spreadsheet: 825859d1681583585-difference-of-2-cells-dd-mm-yyyy-hh-mm-as-general-value-sample_file
Sheet: Sheet1

 | Vehicle | Seal No | Driver Cell No | Reporting Date | Report Time | Merged_1 | Offloading Date | Unload Time | Merged_2 | Detention
 | SWA-260 | 8047-8046 | [PHONE] | 2023-04-02 00:00:00 | 10:30:00 | 02-Apr-23 10:30:00 AM | 2023-04-04 00:00:00 | 12:00:00 | 04-Apr-23 12:00:00 PM | #[NAME]!
 | JT-5794 |  |  | 2023-04-02 00:00:00 | 10:30:00 | 02-Apr-23 10:30:00 AM | 2023-04-05 00:00:00 | 11:15:00 | 05-Apr-23 11:15:00 AM | #[NAME]!
 | JW-6360 | 1875-1863 | 3037807356 | 2023-04-01 00:00:00 | 09:00:00 | 01-Apr-23 09:00:00 AM | 2023-04-06 00:00:00 | 10:00:00 | 06-Apr-23 10:00:00 AM | #[NAME]!
 | JV-6978 | 01458-1481 | 3008986950 | 2023-04-03 00:00:00 | 09:00:00 | 03-Apr-23 09:00:00 AM | 2023-04-07 00:00:00 | 23:50:00 | 07-Apr-23 11:50:00 PM | #[NAME]!
 | JV-6978 | 01458-1481 | 3008986950 | 2023-04-03 00:00:00 | 09:00:00 | 03-Apr-23 09:00:00 AM | 2023-04-07 00:00:00 | 23:50:00 | 07-Apr-23 11:50:00 PM | #[NAME]!
Spreadsheet: 133036d1324119131-require-formula-to-identify-a-number-not-text-cheapest-price
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | a | b | c | d | e | f | g | h | i | j | k | l | m
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 80 | 21 | 40 | 31 | 39 | 10 | 9 | 19 | 68 | 38 | 74 | 58 | 54 | 9
Spreadsheet: 127656d1320443361-making-vlookup-persistent-sample-1-
Sheet: Inventory list

Stock# | Date | Make | Model | Color
3401 | 2011-08-29 00:00:00 | Oldsmobile | Eighty-Eight | Green |  | 1st way: using vlookup function:
3402 | 2011-08-29 00:00:00 | Dodge | [NAME] | Blue |  | stock #: | 3402 |  | Date: | 2011-08-29 00:00:00 | VLOOKUP(H3, StockChart, 2)
3403 | 2011-08-29 00:00:00 | Saturn | SC2 | Green |  |  |  |  | Make: | Dodge | VLOOKUP(H3, StockChart, 3)
3404 | 2011-08-29 00:00:00 | Chevrolet | Blazer | White |  |  |  |  | Model: | [NAME] | VLOOKUP(H3, StockChart, 4)
3405 | 2011-09-01 00:00:00 | Pontiac | [NAME] | Black |  |  |  |  | Color: | Blue | VLOOKUP(H3, StockChart, 5)
3406 | 2011-09-01 00:00:00 | Dodge | Stratus R/T | Black
3407 | 2011-09-01 00:00:00 | Chrysler | Sebring | White
3408 | 2011-09-01 00:00:00 | Chevrolet | Malibu | Gold
3409 | 2011-09-01 00:00:00 | Pontiac | Grand Am | Red |  | 2nd way: using INDEX function:
3410 | 2011-09-01 00:00:00 | Dodge | Stratus | [NAME]
3411 | 2011-09-01 00:00:00 | Dodge | Neon | Purple |  | stock #: | 3402 |  | Date | 2011-08-29 00:00:00 | INDEX(StockChart, MATCH(Stock,Row, 0), MATCH(J12,Column, 0))
3412 | 2011-09-08 00:00:00 | Pontiac | [NAME] | Silver |  |  |  |  | Make | Dodge | INDEX(StockChart, MATCH(Stock,Row, 0), MATCH(J13,Column, 0))
3413 | 2011-09-08 00:00:00 | Oldsmobile | Alero | Red |  |  |  |  | Model | [NAME] | INDEX(StockChart, MATCH(Stock,Row, 0), MATCH(J14,Column, 0))
3414 | 2011-09-08 00:00:00 | Chevrolet | Malibu | Silver |  |  |  |  | Color | Blue | INDEX(StockChart, MATCH(Stock,Row, 0), MATCH(J15,Column, 0))
3415 | 2011-09-08 00:00:00 | Pontiac | Grand Am | Red |  | Obviously, one equation looks more intimidating, but it's WAY more versitile, and is more forgiving for future changes.
3416 | 2011-09-10 00:00:00 | Chevrolet | Lumina | Silver
3417 | 2011-09-10 00:00:00 | Ford | Explorer | Blue
3418 | 2011-09-10 00:00:00 | Ford | Explorer | Red
3419 | 2011-09-10 00:00:00 | Chevrolet | Malibu | [NAME]
3420 | 2011-09-10 00:00:00 | Chevrolet | Malibu | Green
3421 | 2011-09-10 00:00:00 | Oldsmobile | Intrigue | White
3422 | 2011-09-10 00:00:00 | Chevrolet | Lumina | Blue
3423 | 2011-09-10 00:00:00 | Oldsmobile | Alero | Silver
3424 | 2011-09-10 00:00:00 | Pontiac | Aztek | Red
3425 | 2011-09-10 00:00:00 | Chevrolet | Suburban | Grey
3426 | 2011-09-15 00:00:00 | Ford | Taurus | White
3427 | 2011-09-15 00:00:00 | Chevrolet | Lumina | White
3428 | 2011-09-15 00:00:00 | Oldsmobile | Alero | Silver
3429 | 2011-09-15 00:00:00 | Dodge | Neon | Black
3430 | 2011-09-15 00:00:00 | Dodge | [NAME] | Grey
Spreadsheet: 149499d1333992719-excel-2007-returning-a-value-if-the-first-one-is-blank-clean
Sheet: Clean

 | 002
 | LXML
 | LXML
 | LXML
 | LXML
 | LXML | A1
 | LXML | A1
 | LXML
 | LXML
 | LXML | A1
 | LXML | A1
 | LXML
 | LXML | A1
 | LXML
 | LXML | A1
 | LXML
 | LXML
 | LXML
 | LXML
 | LXML
 | LXML
 | LXML | A1
 | LXML
 | LXML
 | LXML
 | LXML
 | LXML
 | LXML
 | LXML | A1
 | LXML | A1
 | LXML | A1
 | LXML
 | LXML | A1
 | LXML
 | LXML | A1
 |  | A1
 | LXML | A1
 | LXML | A1
 | LXML
 | LXML | A1
 | LXML
 | LXML
 |  | A1
 |  | A1
 | LXML
 | LXML | A1
 | LXML | A1
 | LXML
 | LXML | A1
 | LXML
 | LXML
 | LXML
 | LXML | A1
 | LXML | A1
 | LXML | A1
 | LXML | A1
 | LXML | A1
 | LXML
 | LXML | A1
 | LXML | A1
 | LXML
 | LXML | A1
 | LXML | A1
 | LXML
 | LXML
 | LXML
 | LXML
 | LXML
 | LXML
 | LXML | A1
 | LXML
 | LXML
 | LXML
 |  |  | Total
A1 & LXML Files | 69 | 31 | 100
[NAME] |  | 31 | 31
LXML Files | 69 |  | 69
[NAME]
Spreadsheet: 159324d1338578228-how-to-combine-vlookup-and-defined-names-testfile
Sheet: prestamo

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16
loan_id | Nombre | Apellido | loan_cust_id | invest_id | bank_id | monto_ini | moneda | int_mens | fech_ini | fech_fin | tiempo_ini | tipo_pres | cuesto | comi_% | remarks
1 |  |  | 1 | 1
2 |  |  | 2 | 1
3 |  |  | 3 | 1
4 |  |  | 4 | 2
5 |  |  | 1 | 2
6 |  |  | 5 | 2
7 |  |  | 6 | 2
8 |  |  | 7 | 2
9 |  |  | 8 | 2
10 |  |  | 5 | 2
11 |  |  | 1 | 2
12 |  |  | 9 | 2
13 |  |  | 10 | 2
14 |  |  | 11 | 2
15 |  |  | 12 | 2
16 |  |  | 13 | 2
17 |  |  | 11 | 2
18 |  |  | 9 | 2
19 |  |  | 10 | 2
20 |  |  | 13 | 2
21 |  |  | 9 | 2
22 |  |  | 14 | 2
23 |  |  | 15 | 2
24 |  |  | 1 | 2
25 |  |  | 5 | 2
26 |  |  | 16 | 2
27 |  |  | 17 | 2
28 |  |  | 18 | 2
29 |  |  | 19 | 2
30 |  |  | 20 | 2
31 |  |  | 3 | 2
32 |  |  | 9 | 2
33 |  |  | 21 | 2
34 |  |  | 22 | 2
35 |  |  | 23 | 2
36 |  |  | 17 | 2
37 |  |  | 24 | 2
38 |  |  | 14 | 2
39 |  |  | 12 | 2
40 |  |  | 17 | 2
41 |  |  | 25 | 2
42 |  |  | 11 | 2
43 |  |  | 25 | 2
44 |  |  | 26 | 2
45
46
47
48
49
50
51
0 |  |  |  | 0
Spreadsheet: 547340d1510503270-filling-across-a-range-of-sheets-test
Sheet: Nancy Jean

BOAT NAME
OWNER NAME
MOORING TYPE
ADDRESS
HOME TEL
MOBILE TEL
[NAME]
BOAT TYPE
LENGTH
HULL COLOUR
UPPER DECK
TENDER?
DURATION
FEE
NEXT INVOICE DUE DATE | 2015-10-22 00:00:00
INVOICE DUE DATE | INVOICE REMINDER DATE | INVOICE SENT DATE | DATE PAID | NOTES
2015-10-22 00:00:00
Spreadsheet: 731003d1620111251-formulas-with-multiple-range-criteria-not-returning-result-sample-28-ans-3
Sheet: Paste CN

Order No. | Order Time | Trade No. | Trade Time | Security/ Contract description | [NAME] ( B/S ) | Quantity | Gross Rate/ Trade Price Per Unit (Rs) | Brokerage Per unit (Rs) | Net Rate Per unit (Rs) | Closing Rate Per unit only Der.(Rs) | Net Total (Before Levies) (Rs) | Remarks |  |  |  |  | Security/ Contract description
NCL NSE F&O
1600000054898923 | 1:07:31 PM | 752810731 | 1:07:32 PM | OPTIDX BANKNIFTY 08 APR 2021 30000 PUT | B | 25 | 43.2 | 0.3 | 43.5 | 27.3 | 1087.5
1600000054898923 | 1:07:31 PM | 752814160 | 1:08:15 PM | OPTIDX BANKNIFTY 08 APR 2021 30000 PUT | B | 175 | 43.2 | 0.3 | 43.5 | 27.3 | 7612.5
1600000054898923 | 1:07:31 PM | 752814873 | 1:08:23 PM | OPTIDX BANKNIFTY 08 APR 2021 30000 PUT | B | 25 | 43.2 | 0.3 | 43.5 | 27.3 | 1087.5
1600000054898923 | 1:07:31 PM | 752814881 | 1:08:23 PM | OPTIDX BANKNIFTY 08 APR 2021 31000 PUT | B | 25 | 43.2 | 0.3 | 43.5 | 27.3 | 1087.5
Spreadsheet: 36873d1234847038-excel-2007-how-do-i-reference-a-min-value-in-another-spreadsheet-discrete-measures
Sheet: SR

Level | 25PE | 25CS | 5PE | 5CS | 75PE | 75CS | 10PE | 10CS | 15PE | 15CS
Spreadsheet: 779090d1651583817-sum-datas-by-date-across-different-sheets-sample
Sheet: June

Date | Sales
2022-06-01 00:00:00 | 1
2022-06-02 00:00:00 | 1
2022-06-03 00:00:00 | 1
2022-06-04 00:00:00 | 1
2022-06-05 00:00:00 | 1
2022-06-06 00:00:00 | 1
2022-06-07 00:00:00 | 1
2022-06-08 00:00:00 | 1
2022-06-09 00:00:00 | 1
2022-06-10 00:00:00 | 1
2022-06-11 00:00:00 | 1
2022-06-12 00:00:00 | 1
2022-06-13 00:00:00 | 1
2022-06-14 00:00:00 | 1
2022-06-15 00:00:00 | 1
2022-06-16 00:00:00 | 1
2022-06-17 00:00:00 | 1
2022-06-18 00:00:00 | 1
2022-06-19 00:00:00 | 1
2022-06-20 00:00:00 | 1
2022-06-21 00:00:00 | 1
2022-06-22 00:00:00 | 1
2022-06-23 00:00:00 | 1
2022-06-24 00:00:00 | 1
2022-06-25 00:00:00 | 1
2022-06-26 00:00:00 | 1
2022-06-27 00:00:00 | 1
2022-06-28 00:00:00 | 1
2022-06-29 00:00:00 | 1
2022-06-30 00:00:00 | 1
Spreadsheet: lynn_blair__24382__ONEOK Imb Stmt-Dol Val Stmt
Sheet:  DOL. VAL. STMT.

STMT D/T: |  | 07/20/01
PREPARER NAME:  NORTHERN NATURAL GAS COMPANY
VOLUME IMBALANCE AND DOLLAR VALUATION CALCULATIONS
ACCOUNTING PERIOD:  JUNE  2001
SVC REQ NAME: |  |  | ONEOK MIDSTREAM GAS SUPPLY, LLC |  |  |  |  |  |  | CR | = | DUE NNG
SVC REQ K: |  |  | 103135 |  |  |  |  |  |  | POSITIVE | = | DUE SVC REQ
CONTACT NAME: |  |  | WOODSON, HARRY
VOLUMETRIC IMBALANCE |  |  |  |  | QUANTITY |  | DOLLAR-VALUED IMBALANCE |  |  |  |  | QUANTITY |  |  | INDEX PRICE |  | IMB VALUE
BEGINNING IMBALANCE (QUANTIY) |  |  |  |  | 0 |  | BEGINNING IMBALANCE (QUANTITY) 200103 |  |  |  |  | 193214 |  |  |  |  | 1192857.73
 |  |  |  |  |  |  |  | PER ARBITRATION SETTLEMENT
[NAME] TO IMBALANCE: |  |  |  |  |  |  | [NAME] TO IMBALANCE:
 | SETTLEMENT |  |  |  | 0 |  |  | SETTLEMENT |  |  |  | 0 |  |  |  |  | 0
 | CURRENT MONTH |  |  |  | 0 |  |  | CURRENT MONTH  200106 |  |  |  | -77874 | CR |  | 3.4243 |  |  | CR
 | PRIOR PERIODS |  | 200104 |  | 0 |  |  | PRIOR PERIODS |  |  |  |  |  |  | 4.9474
 | PRIOR PERIODS |  | 200105 |  | 0 |  |  | PRIOR PERIODS |  |  |  |  |  |  | 3.9657
Spreadsheet: 835187d1688393076-calculating-running-percentage-for-rows-with-blank-cells-but-will-be-populated-feedback-stats-1-aligw
Sheet: 2023

 | Respondent identity | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 |  |  |  |  |  |  |  |  |  | TOTAL |  | Average | Median | Mode
1 | Timeliness of papers (did you have enough time to read them etc?) | 3 | 4 | 4 | 5 | 5 | 5 | 4 | 2 | 4 | 5 | 5 | 3 | 5 | 3 | 5 | 3
2 | Information about the meeting (enough and in time) | 4 | 5 | 4 | 5 | 5 | 5 | 4 | 3 | 4 | 5 | 5 | 4 | 5 | 5 | 5 | 5
3 | How easy was it to find the venue / join the virtual meeting? | 5 | 5 | 4 | 5 | 5 | 4 | 5 | 3 | 4 | 5 | 3 | 4 | 5 | 5 | 4 | 4
4 | How did you find the room layout? | 4 | 4 | 5 | 4 | 4 | 4 | 5 | 3 | 3 | 4 | 5 | 5 | 5 | x | 3 | 3
5 | How did you find the refreshments and catering? | 4 | 5 | 4 | 4 | 4 | 4 | 5 | 3 | 4 | 3 | 5 | 5 | 5 | x | 5 | 4
6 | How did you find the venue environment, eg  temperature, accessibility, facilities? | 4 | 4 | 4 | 5 | 5 | 4 | 5 | 3 | 4 | 4 | 4 | 5 | 5 | x | 4 | 3
7 | How was the timing of the meeting? | 5 | 4 | 4 | 5 | 4 | 4 | 3 | 2 | 4 | 4 | 5 | 5 | 5 | x | 5 | 2
8 | Was the information presented easy to understand? | 4 | 5 | 4 | 5 | 5 | 5 | 4 | 4 | 4 | 4 | 5 | 4 | 5 | x | 5 | 4
9 | Were the presenters easily heard? | 4 | 5 | 4 | 5 | 4 | 5 | 5 | 3 | 4 | 5 | 5 | 5 | 5 | 4 | 5 | 5
10 | Were the presentations easily seen? | 4 | 5 | 4 | 5 | 5 | 3 | 5 | 3 | 4 | 5 | 5 | 3 | 5 | 5 | 4 | 5
11 | Do you feel meeting attendees had an opportunity to participate? | 3 | 4 | 5 | 5 | 5 | 5 | 3 | 3 | 2 | 4 | 5 | 3 | 5 | 4 | 4 | 5
12 | How useful did you find the meeting? | 3 | 5 | 3 | 4 | 5 | 4 | 3 | 3 | 4 | 3 | 5 | 3 | 5 | 5 | 4 | 3
13 | How enjoyable was the meeting? | 3 | 4 | 3 | 4 | 4 | 1 | 2 | 2 | 2 | 2 | 5 | 2 | 3 | 5 | 3 | 2
Spreadsheet: 861954d1709770760-use-a-number-in-a-cell-as-a-cell-reference-in-a-formula-test
Sheet: Event Attendees Report

Space | Last | Attendee Name | Attendee Address 1 | Attendee Address 2 | Attendee City | Attendee State | Postal Code | Country | Attendee Organization Name
 |  | [NAME] | 123 Rocky Rd |  | Chicago | IL | 60061 | United States | ABC Company
 |  | [NAME] | 456 [NAME] | Unit 2 | Nashville | TN | 37201 | United States | Best Buy
 |  | [NAME] | 567 Third St |  | Quebec | QC | G1J 1R8 | Canada | [NAME]'s Dog Grooming