tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: eric_saibi__9799__091801R
Sheet: Leland Olds 01

Owner Name | Basin Electric Power
Station Name | Leland Olds Power Station
Unit Name | Unit 01
NERC Region | MAPP
State | ND
Fuel Type | [NAME]
Capacity | 216MW
Start Date | 2001-09-14 00:00:00
End Date | 2001-10-25 00:00:00
Prv. Start Date | 2001-10-05 00:00:00
Prv. End Date | 2001-11-22 00:00:00
Comments | Boiler O/H, Tube and [NAME]
SIC | 4911
Plant ID | 1014227
Unit ID | 1007280
Outage ID | 8515
Spreadsheet: 125107d1318878866-pivot-table-question-adv-filter-problem-report-log
Sheet: Summary of Log

Summary of issues by Department
 | Sales | Outside Sales | Shop | Materials | Accounting | Executive | Building 5
Count: | 61 | 1 | 10 | 7 | 8 | 2 | 1
Percentage: | 0.6777777777777778 | 0.01111111111111111 | 0.1111111111111111 | 0.07777777777777778 | 0.08888888888888889 | 0.02222222222222222 | 0.01111111111111111
 | Summary of issues by Employee
 | Person | Total Count |  | Person | Total Count
 | Amber | 12 | 0 | [NAME] | 1 | #N/A
 | [NAME] | 11 | 0 | Lauren | 7 | #N/A
 | Annette | 6 | 0 | [NAME] | 1 | #N/A
 | [NAME] | 3 | 0 | [NAME] | 1 | #N/A
 | [NAME] | 1 | 0 | Marge | 1 | #N/A
 | Carol | 1 | 0 | [NAME] | 1 | #N/A
 | Cassie | 2 | 0 | [NAME] | 6 | #N/A
 | [NAME] | 2 | 0 | [NAME] | 1 | #N/A
 | [NAME] | 1 | 0 | Nicole | 4 | #N/A
 | [NAME] | 2 | 0 | Nina | 1 | #N/A
 | [NAME] | 2 | 0 | [NAME] | 3 | #N/A
 | Joy | 5 | 0 | [NAME] | 7 | #N/A
 | [NAME] | 1 | 0 | Scot | 2 | #N/A
 | [NAME] | 1 | 0 | Stacy E | 1 | #N/A
 | [NAME] | 1 | 0
 |  |  |  |  | Summary From: 6/16/11 - |  | 10/17/11
Spreadsheet: 852203d1702306614-need-help-converting-a-google-sheets-formula-to-excel-ks-schedule-12112023
Sheet: VUTEK 3R's

VUTEK 3R |  | Total hours
Time to Print | Job # | Line # | Customer | QTY | H | W | Material | Sides to Print | [NAME] | Due_Date | Est. usage | PRESS | Notes
 | 242111 | 1 | Caleres | 4050 | 28 | 47 | PAP-SO-1374 - FOAMCORE 3/16IN WHITE 48X96 | 2 | 5-Pass | 2024-01-15 00:00:00 |  | VUTEK 3R's | For production quote- [NAME]
Spreadsheet: 116167d1311643818-pull-text-from-a-text-string-excel-forum-2-
Sheet: db102

[NAME] | 14
[NAME] | 14
[NAME] | NON
[NAME] | OFF
[NAME] | 47
[NAME] | 47
[NAME] | MAX
[NAME] | OFF
[NAME] | 0
[NAME] | 0
[NAME] | NON
[NAME] | OFF
[NAME] | 34
[NAME] | 34
[NAME] | NON
[NAME] | OFF
[NAME] | 0
Split 1 Phase 5 Primary | 0
[NAME] | NON
[NAME] | OFF
[NAME] | 61
[NAME] | 61
[NAME] | MAX
[NAME] | OFF
[NAME] | 0
[NAME] | 0
[NAME] | NON
[NAME] | OFF
[NAME] | 34
[NAME] | 34
[NAME] | NON
[NAME] | OFF
[NAME] | 0
[NAME] | 0
[NAME] | OMT
[NAME] | OFF
[NAME] | 0
[NAME] | 0
[NAME] | OMT
[NAME] | OFF
[NAME] | 0
[NAME] | 0
[NAME] | OMT
[NAME] | OFF
[NAME] | 0
[NAME] | 0
[NAME] | OMT
[NAME] | OFF
[NAME] | 0
[NAME] | 0
[NAME] | OMT
[NAME] | OFF
[NAME] 14 Time | 0
[NAME] | 0
[NAME] 14 Mode | OMT
[NAME] | ON
[NAME] | 0
[NAME] | 0
[NAME] 15 Mode | OMT
[NAME] | OFF
[NAME] | 0
[NAME] | 0
[NAME] | OMT
[NAME] | OFF
[NAME] | 14
[NAME] | 14
[NAME] | NON
[NAME] | OFF
[NAME] | 47
[NAME] | 47
[NAME] | MAX
[NAME] | OFF
[NAME] | 0
[NAME] | 0
[NAME] | NON
[NAME] | OFF
[NAME] | 34
[NAME] | 34
[NAME] | NON
[NAME] | OFF
[NAME] | 0
[NAME] | 0
[NAME] | NON
[NAME] | OFF
[NAME] | 61
[NAME] | 61
[NAME] | MAX
[NAME] | OFF
[NAME] | 0
[NAME] | 0
[NAME] | NON
[NAME] | ON
[NAME] | 34
[NAME] | 34
[NAME] | NON
[NAME] | OFF
[NAME] | 0
[NAME] | 0
[NAME] | OMT
[NAME] | OFF
[NAME] | 0
[NAME] | 0
[NAME] 10 Mode | OMT
[NAME] | OFF
[NAME] | 0
[NAME] | 0
[NAME] | OMT
[NAME] | OFF
[NAME] | 0
[NAME] | 0
[NAME] 12 Mode | OMT
[NAME] | OFF
[NAME] | 0
[NAME] | 0
[NAME] 13 Mode | OMT
[NAME] | OFF
[NAME] 14 Time | 0
[NAME] 14 Primary | 0
[NAME] 14 Mode | OMT
[NAME] 14 Coor Phs | OFF
[NAME] | 0
[NAME] Phase 15 Primary | 0
[NAME] Phase 15 Mode | OMT
[NAME] | OFF
[NAME] | 0
[NAME] 16 Primary | 0
[NAME] 16 Mode | OMT
[NAME] | OFF
Spreadsheet: 64361d1265229229-multiple-values-for-a-cell-purchase
Sheet: CONGRESSIONAL

Sample
Product | Amount | Purchased by |  |  |  |  |  |  |  |  | [NAME] | [NAME] | [NAME] | [NAME]
Shoes | 3296.333333333333 | [NAME] | 3296.333333333333 | 1 | 0 | 0 | 0 | 0 | 0 |  | 3296.333333333333 | 0 | 0 | 0
[NAME] | 15933.33333333333 | [NAME], [NAME] | 7966.666666666667 | 2 | 6 | 0 | 0 | 0 | 0 |  | 7966.666666666667 | 7966.666666666667 | 0 | 0
T-Shirts | 5244.333333333333 | [NAME] | 5244.333333333333 | 1 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 5244.333333333333 | 0
Hats | 24474 | [NAME] | 24474 | 1 | 0 | 0 | 0 | 0 | 0 |  | 0 | 24474 | 0 | 0
Gloves | 2097.166666666667 | [NAME], [NAME], [NAME] | 699.0555555555557 | 3 | 3 | 10 | 0 | 0 | 0 |  | 699.0555555555557 | 0 | 699.0555555555557 | 699.0555555555557
 |  |  |  |  |  |  |  |  |  | Total | 11962.05555555555 | 32440.66666666667 | 5943.388888888889 | 699.0555555555557
Summary
Name | Amount
[NAME] | 11962.05555555555 | My goal is to move away from manually creating the formulas if there are two or more buyers.
[NAME] | 32440.66666666667
[NAME] | 5943.388888888889
[NAME] | 699.0555555555557
 |  | 1
Spreadsheet: 300216d1393416501-find-duplicate-order-ids-then-add-shipping-together-several-columns-to-the-right-temp1
Sheet: Sheet1

order ID | shipping-price | totalled shipping
[PHONE]-6193120
[PHONE]-8914712 | 1
[PHONE]-8914712 | 2
[PHONE]-8914712 | 2
[PHONE]-3054759
[PHONE]-2091505
[PHONE]-2091505
[PHONE]-9313947
[PHONE]-9936313 | 1.88
[PHONE]-6981121
[PHONE]-9817906 | 0.75
[PHONE]-9817906 | 0.5
[PHONE]-5771520
[PHONE]-6630720
[PHONE]-5625123 | 3.3
[PHONE]-1835548 | 3.3
[PHONE]-6431503 | 3.3
[PHONE]-7889140 | 3
[PHONE]-3419517
[PHONE]-5440325
[PHONE]-4245141 | 7.99
[PHONE]-2984360
[PHONE]-3300300
[PHONE]-3300300
[PHONE]-8234731
[PHONE]-9085965 | 3.3
[PHONE]-6070741
[PHONE]-9645958 | 3.3
[PHONE]-2619510
[PHONE]-2619510
[PHONE]-5051516
[PHONE]-9018752 | 1.1
[PHONE]-9018752 | 1.2
[PHONE]-9018752 | 0.9
[PHONE]-9018752 | 0.6
[PHONE]-8781950
[PHONE]-2994755
[PHONE]-4977923
[PHONE]-2729912
Spreadsheet: jeff_dasovich__14031__week8 picks
Sheet: Sheet1

 | Spread |  | Spread |  | Pick | Number
Detroit |  | Tampa Bay | 8.5 |  | TB | 10
New Orleans | 1.5 | Atlanta |  |  | NO | 4
Denver | 9.5 | Cincinnatti |  |  | Denver | 15
Arizona |  | Dallas | 7 |  | Dallas | 5
New England |  | Indy | 8.5 |  | Indy | 8
St. Louis | 7 | KC |  |  | St. Louis | 11
Buffalo |  | Minnesota | 6.5 |  | Minn | 6
Chicago |  | Philly | 7 |  | Philly | 12
49ers |  | Carolina | 3.5 |  | 49ers | 7
Tennessee |  | Baltimore | 1 |  | [NAME] | 2
Seattle |  | Oakland | 7.5 |  | Oakland | 13
Cleveland |  | Pittsburgh | 9 |  | Pitt | 14
Washington | 3.5 | Jacksonville |  |  | [NAME] | 3
Miami |  | Jets | 3 |  | Miami | 9
Spreadsheet: 791672d1660547051-special-selection-and-listing-of-data-template_petty-cash
Sheet: Non_VAT

 | [NAME]
 | Date | Details | Account | Reference | Amount | VAT
Spreadsheet: 215575d1361416627-calculate-lost-minutes-between-redundant-login-and-logout-records-for-each-id-lost-minutes-result
Sheet: IN-OUT

ID | Login | Logout |  | Correct time format
1 | 02:10:00 | 04:39:00
1 | 04:39:00 | 07:03:00 |  |  |  |  |  |  | Not correct time format. You need a space between AM/PM
1 | 07:05:00 | 08:00:00 |  |  |  | Login | Logout
2 | 08:02:00 | 10:00:00 |  |  |  | 2:10AM | 4:39AM
2 | 10:05:00 | 12:30:00 |  |  |  | 4:39AM | 7:03AM
2 | 12:34:00 | 14:05:00 |  |  |  | 7:05AM | [NAME]
2 | 14:15:00 | 16:00:00 |  |  |  | 8:02AM | 10:00AM
 |  |  |  |  |  | 10:05AM | 12:30PM
 |  |  |  |  |  | 12:34PM | 2:05PM
 |  |  |  |  |  | 2:15PM | 4:00PM
Spreadsheet: 703255d1604909033-top-10-list-with-one-more-dynamic-value-top-10-list-with-one-more-dynamic-value
Sheet: Sheet1

Problem |  |  |  |  |  |  |  |  | Result
Sl. No. | State | Value |  | What to Do |  | Desired State | F |  | Sl. No. | State | Value
1 | A | 2333 |  | List top 10 based on the values field and compare with a specific state, if the specified state is already in the top 10 then do nothing other wise add the specific state to the list and remaining as other states.  The Desired State is a dynamic value and to be selected from the dropdown list. |  |  |  |  | 1
2 | B | 6565 |  |  |  |  |  |  | 2
3 | C | 48 |  |  |  |  |  |  | 3
4 | D | 5484 |  |  |  |  |  |  | 4
5 | E | 4541 |  |  |  |  |  |  | 5
6 | F | 54551 |  |  |  |  |  |  | 6
7 | G | 545 |  |  |  |  |  |  | 7
8 | H | 448 |  |  |  |  |  |  | 8
9 | I | 48897 |  |  |  |  |  |  | 9
10 | J | 112121 |  |  |  |  |  |  | 10
11 | K | 151
12 | L | 15 |  |  |  |  |  |  | 12 | Other States
13 | M | 1548 |  |  |  |  |  |  |  | Total
14 | N | 4548
15 | O | 5487
16 | P | 4848
17 | Q | 48
18 | R | 445
19 | S | 58
20 | T | 4884
 | Total
Spreadsheet: 848737d1699380243-combine-aggregated-lists-in-to-a-separate-combined-list-aggregated-lists
Sheet: Yellow Car

Ref No | Vehicle | Colour
Spreadsheet: 330923d1404905168-using-is-number-and-search-function-sample-1-
Sheet: sample

Statement details | Cost | Category- entered manually |  | Formulae normal way | Formulae structured references | Example Table
[NAME] | 50 | Food |  |  |  | item | catagory
[NAME] | 20 | school |  |  |  | Aldi | Food
Direct Debit 147014 REA TRANSACTIONS RENT PAYMENT6018590 | 30 | house |  |  |  | woolworths | Food
TMSGS                NetBank BPAY  Lotto | 30 | Birthday presents, charitable donations, other gifts,lotto,mass |  |  |  | Coles | Food
JUST CUTS PENRITH        PENRITH   [NAME] | 80 | Medicines, toiletries, hairdressing, personal items |  |  |  | [NAME] | School
Direct Debit 119218 VODAFONE | 36 | telephone |  |  |  | lotto | Birthday presents, charitable donations, other gifts,lotto,mass
BLOOMS THE CHEMIST P | 13 | Medicines, toiletries, hairdressing, personal items |  |  |  | Blooms | Medicines, toiletries, hairdressing, personal items
WOOLWORTHS W1087 | 64 | Food |  |  |  | vodafone | telephone
Coles | 25 | Food |  |  |  | rent | house
Income
Expenditure
Rent
Childcare
public transport
Heating
Telephone
Electricity
TV
Household
Food and non-alcoholic drinks
Special gluten free food
Alcohol
Clothing and footwear
Medicines, toiletries, hairdressing, personal items
Car (tax, insurance, fuel etc), fares, other travel
Going out, Entertainment
Holidays
Birthday presents, charitable donations, other gifts,lotto,mass
Life insurance, medical insurance, other insurance
Gardening / Outdoor items
Other expenditure
Christmas
Kitty
Savings ( + from, - to )
School
xtra activities girls
Loan
Camping
Total income / expenditure
Spreadsheet: 133363d1324361751-excel-2007-changing-the-month-daily-schedule-bvj-
Sheet: Sheet3

 | A | Postpaid | 2011 |  |  |  | G | Postpaid | 2010
 | B | Prepaid | 2010 |  |  |  | D | Prepaid | 2010
 | C | Postpaid | 2008 |  |  |  | H | Postpaid | 2010
 | D | Prepaid | 2010 | No
 | E | Postpaid | 2011
 | F | Prepaid | 2010
 | G | Postpaid | 2010 | No
 | H | Postpaid | 2010 | No
Spreadsheet: 150144d1334310831-take-data-from-tables-on-other-sheets-irtest2
Sheet: Sheet1

 |  | Dimensions
 |  | Length | [NAME] | Depth | Dimensional Weight | Actual Weight |  | Greatest weight
 |  | 50 | 50 | 50 |  | 26.3
 | Destination | Express Plus | Express | Express Saver | Standard | Expedited
 | Germany
 | Cost
Spreadsheet: 866298d1713264097-historic-currency-conversion-example
Sheet: Sales Money Due

Client | Pixies
Confirmation Date | 2024-01-01 00:00:00
Location
Holiday Date
Currency | USD
Base Currency | GBP
Payment Date | Amount | Sterling
2024-01-01 00:00:00 | 50
2024-02-01 00:00:00 | 100
2024-03-01 00:00:00 | 10000
2024-04-01 00:00:00 | 5135182
Total
Spreadsheet: 84014d1284022283-excel-2008-graphing-petedam
Sheet: Data

Graph data
Quantity | Price | Demand | Supplies
20 | 100 | 130 | 10
40 | 200 | 110 | 20
60 | 300 | 90 | 30
80 | 400 | 70 | 40
100 | 500 | 50 | 50
120 | 600 | 30 | 60
140 | 700 | 10 | 70
Spreadsheet: 685333d1593930096-multi-price-list-example
Sheet: Sheet1

Part No | Part Desc | Charge | No | Charge | No | Charge | No | Charge | No | Charge | No
PHAE150003 | Anti Vandal 2 + 1 Toilet 12' | 8.74 | 50 | 8.87 | 11 | 9.26 | 6 | 10.24 | 4
PHAE150004 | Anti Vandal 3 + 1 Toilet  16' | 10.88 | 28
PHAE150007 | Anti Vandal Canteen + Drying Room 20' | 5 | 9 | 5.79 | 16 | 6.72 | 4 | 8.85 | 24
PHAE150007 | Anti Vandal Canteen 20'
PHAE150008 | 24' x 10' Canteen - C/W Sink Unit, 4 Mess Tables, 20 Poly Chairs, Microwave and [NAME] | 7.55 | 72 | 8 | 48 | 9 | 84
PHAE150008 | Anti Vandal Canteen 24'
PHAE150008 | Anti Vandal Canteen 24 x 9
PHAE150012 | Anti [NAME] 20' | 5.57 | 9 | 6.63 | 3 | 7.95 | 36 | 8 | 48 | 9 | 48
Spreadsheet: 167783d1342102812-excel-2007-changing-denominator-every-nth-cell-changing-denominator
Sheet: Sheet1

2008-01-31 00:00:00 | 158802
2008-02-29 00:00:00 | 146346
2008-03-31 00:00:00 | 155,56
2008-04-30 00:00:00 | 147403
2008-05-30 00:00:00 | 158988
2008-06-30 00:00:00 | 125726
2008-07-31 00:00:00 | 142128
2008-08-29 00:00:00 | 166699
2008-09-30 00:00:00 | 144865
2008-10-31 00:00:00 | 182443
2008-11-28 00:00:00 | 57245
2008-12-31 00:00:00 | 92926
2009-01-30 00:00:00 | 20226
Spreadsheet: john_griffith__15770__10_18_01LO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | CL X1 | EXP |  |  | 63.1 | 74 | 0.95 | 2001-10-16 14:40:00
 | CL Z1 | 21.5 | 267 | 272 | 57.4 | 58.5 | 0.78 | 2001-10-18 13:08:00
 | CL F2 | 22 | 362 | 372 | 52.6 | 54 | 0.74 | 2001-10-18 13:08:00
 | CL G2 | 22 | 432 | 438 | 50.2 | 50.9 | 0.7 | 2001-10-18 13:08:00
 | CL H2 | 22 | 465 | 477 | 47.1 | 48.4 | 0.66 | 2001-10-18 13:08:00
 | CL J2 | 22 | 485 | 500 | 44.2 | 45.6 | 0.62 | 2001-10-18 13:08:00
 | CL K2 | 22 | 505 | 525 | 41.9 | 43.5 | 0.59 | 2001-10-18 13:08:00
 | CL M2 | 22 | 525 | 535 | 40.6 | 41.3 | 0.57 | 2001-10-18 13:08:00
 | CL N2 | 22 | 525 | 540 | 37.9 | 39 | 0.53 | 2001-10-18 13:08:00
 | CL Q2 | 22 | 525 | 545 | 35.9 | 37.3 | 0.51 | 2001-10-18 13:08:00
 | CL U2 | 22 | 525 | 545 | 34.3 | 35.6 | 0.48 | 2001-10-18 13:08:00
 | [NAME] | 22 | 530 | 550 | 33 | 34.2 | 0.46 | 2001-10-18 13:08:00
 | [NAME] | 21.5 | 535 | 555 | 31.7 | 32.9 | 0.44 | 2001-10-18 13:08:00
 | CL M3 | 21.5 | 535 | 565 | 26.9 | 28.5 | 0.37 | 2001-10-18 13:08:00
 | CL Z3 | 21.5 | 535 | 570 | 24.1 | 25.6 | 0.34 | 2001-10-18 13:08:00
Spreadsheet: 753143d1635266928-index-match-formula-for-duplicate-values-index-match-book
Sheet: Date Order

Part | Due
 |  |  |  |  |  |  | Date Displayed here |  | Results from here (only the cells which have the corrosponding specific date, [NAME] of 4 results)
 |  |  |  |  |  |  | 2019-01-04 00:00:00 |  | Pears | Apples | Bananas | Stones
 |  |  |  | This is what I need: |  |  | 2019-01-07 00:00:00 |  | BX35640 | SI5345
 |  |  |  |  |  |  | 2019-01-10 00:00:00 |  | SE25509
Spreadsheet: 825522d1681377654-how-to-get-sum-of-rows-where-several-rows-are-empty-in-between-gettotalsumofeachfieldname
Sheet: Sheet2

Fields name | Time
Test1 | 00:00:03
Test1
Test1 | 00:00:01
Test1
Test2 | 00:00:00
Test2
Test2 | 00:00:01
Test2
Test2 | 00:00:00
Test2
Test2 | 00:00:01
Test2
Test2 | 00:00:00
Test2
Test3
Test3
Test3 | 00:00:03
Test3
Test3 | 00:00:01
Test3
Test3 | 00:00:00
Test3
Test4 | 00:00:01
Test4
Test4 | 00:00:00
Test4
Test4 | 00:00:01
Test4
Test4
Test4
Test5
Test5
Test5 | 00:00:00
Test5
Test6 | 00:00:01
Test6
Test6 | 00:00:00
Test6
[NAME] | 00:00:01
[NAME]
[NAME] | 00:00:00
Test8
Test8 | 00:00:01
Test8
Test8 | 00:00:00
Test8
Test8 | 00:00:01
Test8
Test8
Test9
Test9
Test9 | 00:00:00
Test9
Test9 | 00:00:01
Spreadsheet: 18d13262-696b-4525-b234-be5ca63a2307
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
DIG | Test | DIG | Digoxin, Serum | Digoxin, S | Electrochemiluminescent Immunoassay | Serum Gel Tube: SGT |  |  | 1 | mL | Container/Tube:  Preferred: Serum gel Acceptable: Red top [NAME]: 1 mL | 0.5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	NA Icterus	NA Other	NA | Therapeutic concentration: 0.5-2.0 ng/mL Toxic concentration: > or =4.0 ng/mL Pediatric toxic concentrations may be higher. Reference values have not been established for patients that are <16 years of age. | Monday through Sunday; Continuously | Same day/1 day | 1 day | 1 | 80162 |  |  |  |  | Rochester
DIG | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
DIG | Result | DIG | Digoxin, S | Digoxin, S | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 10535-3
Spreadsheet: 0030a257-b5e4-4071-b438-414670fefe9d
Sheet: ethnic

AY07-08 | AY08-09 | [NAME] | AY10-11 | AY11-12
2007 | 2008 | 2009 | 2010 | 2011
 |  |  |  |  |  | White |  | White
 |  |  |  |  |  | Hispanic |  | Hispanic
 |  |  |  |  | B | African American |  | African American
 |  |  |  |  |  | Asian |  | Asian
 |  |  |  |  |  | Native American |  | Native American
 |  |  |  |  |  | Filipino |  | Filipino
 |  |  |  |  |  | Pacific Islander |  | Pacific Islander
 |  |  |  |  |  | Multi-Race |  | Multi-Race
 |  |  |  |  |  | Unknown |  | Unknown
Spreadsheet: 890354d1741767841-help-cant-xlookup-percentages-sample-wb
Sheet: Sheet1

Job ID | Location | Subject | Scheduled start | Assignment | Job Plan Number | Reference | Status | LAST_STATUS_CHANGE_DATE | Work Category | WORK_ORDER_TYPE_LABEL | Unread Correspondence |  |  | Date | Label | Column1 | Column2 | Column3 | WO completion
PM-0176270 |  |  | 2025-03-12 07:00:00 |  | GRND-1M-01 | 93362989 | En Route | 2025-03-12 06:20:37 | GM | PM | YES |  |  |  |  |  |  |  |  |  |  | MAXIFS(O2:O1005, INT(O2:O1005), V2)
PM-0176139 |  |  | 2025-03-11 07:00:00 |  | GRND-1M-01 | 93362722 | Completed | 2025-03-11 16:06:44 | GM | PM | YES |  |  |  |  |  |  |  |  |  | 2025-03-11 00:00:00
PM-0175505 |  |  | 2025-03-06 09:00:00 |  | GRND-1M-01 | 93361889 | Completed | 2025-03-11 14:54:01 | GM | PM | YES |  |  |  |  |  |  |  |  |  | 00:00:00
PM-0175647 |  |  | 2025-03-07 07:00:00 |  | GRND-1M-01 | 93362057 | Completed | 2025-03-11 14:25:00 | GM | PM | YES
PM-0175221 |  |  | 2025-03-17 07:00:00 |  | GRND-1M-01 | 93361533 | Completed | 2025-03-11 13:43:43 | GM | PM | YES
PM-0175191 |  |  | 2025-03-11 08:00:00 |  | GRND-1M-01 | 93361496 | On Hold - F/O Required (FM) | 2025-03-11 13:23:57 | GM | PM | YES
PM-0175664 |  |  | 2025-03-18 08:00:00 |  | GRND-1M-01 | 93362091 | Completed | 2025-03-11 12:24:55 | GM | PM | YES
PM-0175601 |  |  | 2025-03-10 11:00:00 |  | GRND-1M-01 | 93362018 | Completed | 2025-03-11 12:24:13 | GM | PM | YES
PM-0175577 |  |  | 2025-03-10 10:00:00 |  | GRND-1M-01 | 93361987 | Completed | 2025-03-11 12:20:14 | GM | PM | YES
PM-0175351 |  |  | 2025-03-10 09:30:00 |  | GRND-1M-01 | 93361702 | Completed | 2025-03-11 12:13:40 | GM | PM | YES
PM-0175326 |  |  | 2025-03-10 09:00:00 |  | GRND-1M-01 | 93361673 | Completed | 2025-03-11 11:52:32 | GM | PM | YES
PM-0175591 |  |  | 2025-03-10 12:00:00 |  | GRND-1M-01 | 93362004 | Completed | 2025-03-11 11:47:44 | GM | PM | YES
PM-0175320 |  |  | 2025-03-10 08:30:00 |  | GRND-1M-01 | 93361669 | Completed | 2025-03-11 11:11:13 | GM | PM | YES
PM-0175552 |  |  | 2025-03-18 09:00:00 |  | GRND-1M-01 | 93361964 | Completed | 2025-03-11 10:56:07 | GM | PM | YES
PM-0175656 |  |  | 2025-03-18 11:00:00 |  | GRND-1M-01 | 93362083 | Completed | 2025-03-11 10:45:28 | GM | PM | YES
PM-0175593 |  |  | 2025-03-18 10:00:00 |  | GRND-1M-01 | 93362005 | Completed | 2025-03-11 10:28:18 | GM | PM | YES
PM-0176137 |  |  | 2025-03-07 07:00:00 |  | GRND-1M-01 | 93362718 | En Route | 2025-03-11 10:06:42 | GM | PM | YES
PM-0175515 |  |  | 2025-03-17 08:00:00 |  | GRND-1M-01 | 93361896 | Completed | 2025-03-11 10:03:05 | GM | PM | YES
[NAME] |  |  | 2025-03-11 07:00:00 |  | GRND-1M-01 | 93361757 | Completed | 2025-03-11 09:55:57 | GM | PM | YES
PM-0175281 |  |  | 2025-03-10 07:30:00 |  | GRND-1M-01 | 93361611 | Completed | 2025-03-11 09:41:05 | GM | PM | YES
PM-0175568 |  |  | 2025-03-17 09:00:00 |  | GRND-1M-01 | 93361977 | Completed | 2025-03-11 09:38:22 | GM | PM | YES
Spreadsheet: 771614d1646757638-counting-consecutive-dates-with-a-unique-id-count-consecutive-dates
Sheet: Sheet1

ID | Name | Date of Hospital Visit | # [NAME]
80009 | Hetfield | 2021-07-19 00:00:00 | 3
80009 | Hetfield | 2021-07-21 00:00:00 | 3
80009 | Hetfield | 2020-04-05 00:00:00 | 1
80009 | Hetfield | 2020-04-07 00:00:00 | 1
80010 | Ulrich | 2020-09-01 00:00:00 | 2
80011 | Trujillo | 2020-10-05 00:00:00 | 1
80009 | Hetfield | 2021-07-20 00:00:00 | 3
80010 | Ulrich | 2020-09-02 00:00:00 | 2
Spreadsheet: 673450d1587393145-sort-multiple-columns-using-custom-buttons-all-forum-topics-final-spreadsheet
Sheet: Master

 |  | Search Term
 |  | TOPICS | FORUM CATEGORY | REPLIES | VOICES | AUTHOR | DATE TOPIC CREATED | LAST ACTIVITY DATE | ATTACHMENTS | TOPIC I.D.# |  |  |  |  |  |  |  |  |  |  | TAB I.D. | TAB I.D. | TAB I.D. | TAB I.D. | TAB I.D.
 |  | yES | test |  |  | test |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T | FC | A | DC | LA
 |  | test | test |  |  | test |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T | FC | A | DC | LA
 |  | yes | yes |  |  | yes | 2020-04-19 00:00:00 | 2020-04-19 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | T | FC | A | DC | LA
 |  | OK | OK |  |  | OK | 2020-04-19 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | T | FC | A | DC | LA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T | FC | A | DC | LA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T | FC | A | DC | LA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T | FC | A | DC | LA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T | FC | A | DC | LA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T | FC | A | DC | LA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T | FC | A | DC | LA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T | FC | A | DC | LA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T | FC | A | DC | LA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T | FC | A | DC | LA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T | FC | A | DC | LA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T | FC | A | DC | LA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T | FC | A | DC | LA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T | FC | A | DC | LA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T | FC | A | DC | LA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T | FC | A | DC | LA
Spreadsheet: 163007d1340141035-index-match-large-based-on-a-criteria-839273-index_large_match_help-with-criteria
Sheet: Sheet1

 |  |  |  |  |  |  |  | Only IF A = RED  --   Index / Large / Match   formula to show the largest price effect.
Raw Data
Model | Part # | Price Effect | Mix Effect | Prev Month Price | Curr Month Price
Red | ABC | 5 | 20 | 80 | 90
Red | DEF | 6 | 21 | 81 | 91 |  |  |  | Desired Results in yellow below
Yellow | GHI | 7 | 22 | 82 | 92
Blue | JKL | 8 | 23 | 83 | 93 |  |  |  | TOP 3 Largest Price Effects -  Model:  RED
Red | MNO | 9 | 24 | 84 | 94 |  |  |  | # | Model | Price Effect | Part Number | Curr Month Price
Red | PQR | 10 | 25 | 85 | 95 |  |  |  | 1 | Red
Red | STU | 11 | 26 | 86 | 96 |  |  |  | 2 | Red
Red | VWX | 12 | 27 | 87 | 97 |  |  |  | 3 | Red
Blue | ABC | 13 | 28 | 88 | 98
 |  |  |  |  |  |  |  | Only IF A = Blue --   Index / Large / Match   formula to show the largest price effect.
 |  |  |  |  |  |  |  |  | Desired Results in yellow below
 |  |  |  |  |  |  |  |  | TOP 3 Largest Price Effects -  Model:  Blue
 |  |  |  |  |  |  |  |  | # | Model | Price Effect | Part Number | Curr Month Price
 |  |  |  |  |  |  |  |  | 1 | Blue
 |  |  |  |  |  |  |  |  | 2 | Blue
Spreadsheet: 851616d1701804372-conditional-formatting-using-responses-from-ms-forms-scheduling-test-1-
Sheet: TAURO 2

T1 | 37.63 | Total hours |  |  |  |  | 2023-11-30 00:00:00 |  | 11:59:19
Time to Print | Job # | Line # | Customer | QTY | H | W | Material | Sides to Print | [NAME] | Due Date | Est. usage | PRESS | Notes
 | 242111 | 1 | Caleres | 4050 | 28 | 47 | PAP-SO-1374 - FOAMCORE 3/16IN WHITE 48X96 | 2 | 4 Pass | 2024-01-15 00:00:00 |  |  | For production quote- [NAME]