tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 111906d1308153000-copy-multiple-rows-based-on-values-copy-cell-formula-example
Sheet: Main

Name | Date | Name | Product | Quantity
[NAME] | 02/09/2007 | [NAME] | Apple | 2
[NAME] | 05/09/2007 | [NAME] | Pear | 3
[NAME] | 07/09/2007 | [NAME] | Grapes | 5
[NAME] | 11/09/2007 | [NAME] | Apple | 4
[NAME] | 15/09/2007 | [NAME] | Pear | 10
[NAME] | 23/09/2007 | [NAME] | Grapes | 3
[NAME] | 25/09/2007 | [NAME] | Grapes | 5
[NAME] | 13/06/2011 | [NAME] | Orange | 7
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Spreadsheet: 218249d1362408734-transfer-data-from-one-format-to-another-test2
Sheet: Sheet3

test | 35645 | 68.4330429172872
test | 35571 | 13.51675843187451
test | 36044 | 11.37028682425402
test | 36264 | 7.409494809951269
a2 | 34896 | 55.37188683051394
a2 | 35131 | 59.64576538230583
a2 | 35525 | 6.357276157220824
a2 | 36107 | 64.8563980881697
a2 | 36467 | 39.54958804192092
a2 | 36544 | 75.01204837192941
a3 | 34884 | 35.00036954866236
a3 | 34805 | 65.6816980885118
a3 | 34726 | 17.19727071759054
a3 | 34706 | 64.35386538042238
a4 | 34964 | 41.68205974390654
a4 | 35300 | 16.80967838939377
a5 | 35386 | 48.67874955559051
a5 | 35646 | 78.87760947265129
a5 | 36148 | 19.24119885964105
a5 | 36514 | 38.11649637496561
a6 | 34884 | 35.83530418663113
a6 | 34778 | 49.69366593933504
a6 | 35725 | 14.77142052193823
a6 | 36052 | 72.9264971296947
a6 | 36214 | 29.03379351185601
a6 | 36820 | 40.05140021807772
a7 | 34835 | 19.5862132852789
a7 | 35375 | 17.56938202633975
a7 | 35724 | 7.248534909166509
a7 | 35948 | 39.40248288758312
[NAME] | 34701 | 60.98039959773267
[NAME] | 34757 | 27.48057852843163
[NAME] | 34741 | 79.1342300532435
[NAME] | 34744 | 22.27310008321055
a9 | 34877 | 32.81296468193332
a10 | 36218 | 75.94262441017216
a10 | 36801 | 59.99582494239938
a10 | 36893 | 3.806962501948448
a10 | 37593 | 58.47627194576297
Spreadsheet: 150369d1334484487-sumproduct-countif-array-error-sample
Sheet: Total Surveys Q1 2012 Summary

Customer Satisfaction Survey Results Q1 2012
Division | [NAME] | Surveys Completed | [NAME]
Northeast
 | Lewis | 96 | 3.801180310839278
 | Rappa | 212 | 3.926841680732148
 | [NAME] | 404 | 4.146264557543122
 | Total (NE) | 712 | 4.034402566577538
Southeast
 | [NAME], [NAME] | 140 | 4.30271443125348
 | Henderson | 106 | 4.179795206667676
 | Total (SE) | 246 | 4.24974923691976
Mideast | Agonis | 378 | 3.862426989877199
 | [NAME], D | 215 | 4.081374509925602
 | Schrader | 304 | 3.878804713026993
 | Total (ME) | 897 | 3.920456582572789
Central | Inman | 335 | 4.152003824544576
 | Meyer | 90 | 4.233769526813117
 | Total (Central) | 425 | 4.169318914436738
West | Swart | 192 | 4.264577387778127
 | Solaro | 192 | 4.057681523999638
 | Wood | 330 | 3.962372363079883
 | Total (West) | 714 | 4.06926693400237
Omnicare Totals
Week Ending: | # of Surveys
 |  | running total
2012-01-18 00:00:00 | 146 | 146
2012-01-25 00:00:00 | 232
2012-02-01 00:00:00 | 238
2012-02-08 00:00:00 | 225
2012-02-15 00:00:00 | 360
2012-02-22 00:00:00 | 313
2012-02-29 00:00:00 | 226
2012-03-07 00:00:00 | 181
2012-03-14 00:00:00 | 437
2012-03-21 00:00:00 | 267
2012-03-28 00:00:00
Spreadsheet: 029bd04b-4d9a-4ba5-8313-91cfc0afec91
Sheet: GMP Products

Related Products / Products that can be re-purposed
Current GMP Products | Delivery Method
GMP Fundamentals for Pharma | 2-day course
Auditing for GMP | 2-day course
GMPs: Beyond the Fundamentals | 2-day course
GMP: Why do we need it? | DVD
10 Principles of GMP | DVD
Employee Orientation Series: Doing our Best (Pharma Industry) | DVD
Employee Orientation Series: Doing our Best (Medical Device Industry) | DVD
Employee Orientation Series (Doing our Best [Pharmaceutical Industry] and They Trust Us [Medical Device] | DVDs
Medical Device Quality Systems Manual (FDA Quality System Regulation) | Manual
Line Operator Training
Orientation | [NAME]
Contamination Mix-ups and Errors | [NAME]
Production and [NAME] | [NAME]
Equipment, Containers and Production Documents | [NAME]
Buildings and Facilities | [NAME]
Final Problems | [NAME]
Spreadsheet: 72870d1273587442-auto-population-of-summary-sheet-test-data
Sheet: LR_Summary

DAY-WISE PROCUREMENT REPORT |  |  |  |  | SUPPLIER-WISE TARGET VS ACTUAL |  |  |  |  |  |  |  | QUALITY-WISE TONNAGE REPORT
DATE | WEEKDAY | NO. OF TEUS | DAY'S AVERAGE | TOTAL WEIGHT | S.NO. | NAME OF THE SUPPLIER | TARGET |  | ACHIEVEMENT |  | AVERAGE | [NAME] | QUALITY | ACHIEVEMENT |  | AVERAGE
 |  |  |  |  |  |  | MTS | FCL'S | MTS | FCL'S |  |  |  | MTS | FCL'S
2010-04-01 00:00:00 |  |  |  |  | 1 |  |  |  |  |  |  |  | EMHM82
 |  |  |  |  |  |  |  |  |  |  |  |  | EMHM91
 |  |  |  |  |  |  |  |  |  |  |  |  | EMHMBS
 |  |  |  |  |  |  |  |  |  |  |  |  | EMHMSS
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | EMHTBB
 |  |  |  |  |  |  |  |  |  |  |  |  | EMNFAT
 |  |  |  |  |  |  |  |  |  |  |  |  | EMNFS1
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | EMRMYR
 |  |  |  |  |  |  |  |  |  |  |  |  | EMRMPS
 |  |  |  |  |  |  |  |  |  |  |  |  | EMSMHO
 |  |  |  |  |  |  |  |  |  |  |  |  | EMSMCO
 |  |  |  |  |  |  |  |  |  |  |  |  | EMSMCS
 |  |  |  |  |  |  |  |  |  |  |  |  | EMSMGB
 |  |  |  |  |  |  |  |  |  |  |  |  | EMSMOS
 |  |  |  |  |  |  |  |  |  |  |  |  | EMSMRR
 |  |  |  |  |  |  |  |  |  |  |  |  | EMSMEC
 |  |  |  |  |  |  |  |  |  |  |  |  | EMBLMS
 |  |  |  |  |  |  |  |  |  |  |  |  | EMBNBB
 |  |  |  |  |  |  |  |  |  |  |  |  | EMBTPS
 |  |  |  |  |  |  |  |  |  |  |  |  | EMCIBL
 |  |  |  |  |  |  |  |  |  |  |  |  | EMCISL
TOTAL |  |  |  |  | TOTAL |  |  |  |  |  |  |  | TOTAL
Spreadsheet: 1f0888ca-7629-4b98-84f5-8a261d51bcc9
Sheet: Sheet1

Practice_Code | Cost_Share_Program | Practice_Name | Component | Unit_Type | Unit_Cost | Cost_Type | Share_Rate
314 | EQIP 2014 | Brush Management | Mechanical, Small Shrubs | Ac | 73.47 | PR | 100
314 | EQIP 2014 | Brush Management | Mechanical, Large Shrubs | Ac | 274.55 | PR | 100
314 | EQIP 2014 | Brush Management | Mechanical and Chemical, [NAME], Medium Infestation | Ac | 93.34 | PR | 100
314 | EQIP 2014 | Brush Management | Chemical, Individual Plant Treatment | Ac | 25.43 | PR | 100
314 | EQIP 2014 | Brush Management | Mechanical and Chemical, [NAME], Dense Infestation | Ac | 284.05 | PR | 100
314 | EQIP 2014 | Brush Management | Hand Cut and Chemical, [NAME], Dense Infestation | Ac | 501.76 | PR | 100
647 | EQIP 2014 | Early Successional Habitat Development and Management | Alder Regneration | Ac | 291.90 | PR | 100
647 | EQIP 2014 | Early Successional Habitat Development and Management | Aspen Regeneration | Ac | 389.78 | PR | 100
647 | EQIP 2014 | Early Successional Habitat Development and Management | [NAME] | Ac | 175.16 | PR | 100
666 | EQIP 2014 | Forest Stand Improvement | Marking Only, Even Aged Stand, Commercial Harvest | Ac | 46.46 | PR | 100
Spreadsheet: 741338d1626977021-help-with-multipe-if-function-please-forum-sample
Sheet: Sheet1

 | Team A |  |  | Team B |  |  | Team C |  |  | Team D |  |  | Team E |  |  | Team F |  |  | Team G |  |  | Team H |  |  | Played | Wom | [NAME] | Lost
Team A |  |  |  | D |  |  | L |  |  | L |  |  | W |  |  |  |  |  | W |  |  | W
 |  | - |  | 0 | - | 0 | 0 | - | 1 | 2 | - | 3 | 1 | - | 0 |  | - |  | 1 | - | 0 | 2 | - | 1
Team B
 |  | - |  |  | - |  |  | - |  |  | - |  |  | - |  |  | - |  |  | - |  |  | -
Team C
 |  | - |  |  | - |  |  | - |  |  | - |  |  | - |  |  | - |  |  | - |  |  | -
Team D
 |  | - |  |  | - |  |  | - |  |  | - |  |  | - |  |  | - |  |  | - |  |  | -
Team E
 |  | - |  |  | - |  |  | - |  |  | - |  |  | - |  |  | - |  |  | - |  |  | -
Team F
 |  | - |  |  | - |  |  | - |  |  | - |  |  | - |  |  | - |  |  | - |  |  | -
Team G
 |  | - |  |  | - |  |  | - |  |  | - |  |  | - |  |  | - |  |  | - |  |  | -
Team H
 |  | - |  |  | - |  |  | - |  |  | - |  |  | - |  |  | - |  |  | - |  |  | -
Spreadsheet: 269356d1381138933-counts-unique-values-per-dates-counts
Sheet: Sheet1

Account Number | Dates |  | 2013-10-02 00:00:00 | 2013-10-03 00:00:00
10001 | 2013-10-02 00:00:00 |  | 3 | 3
10001 | 2013-10-02 00:00:00
10001 | 2013-10-02 00:00:00
1002 | 2013-10-02 00:00:00
10001 | 2013-10-02 00:00:00
10023 | 2013-10-02 00:00:00
10001 | 2013-10-03 00:00:00
10001 | 2013-10-03 00:00:00
10001 | 2013-10-03 00:00:00
1002 | 2013-10-03 00:00:00
10001 | 2013-10-03 00:00:00
10023 | 2013-10-03 00:00:00
Spreadsheet: 550649d1512477111-auto-filling-dates-and-days-skipping-a-column-each-time-xlf-_-auto-filling-dates-and-days-skipping-a-column-each-time-_-forstalebuns-_-as
Sheet: Sheet1

 | Wednesday | 2017-12-06 00:00:00 | Thursday | 2017-12-07 00:00:00 | Friday | 2017-12-08 00:00:00 | Monday | 2017-12-11 00:00:00 | Etc…
 | 2017-12-06 00:00:00 | 2017-12-06 00:00:00
Spreadsheet: 731657d1620486509-v-lookup-based-on-different-sheets-using-data-validation-list-test-sheets-ans
Sheet: Apr 23

Enter 1st of Month Here -> | 2023-04-01 00:00:00 | Controller | Volunteer 1 | Volunteer 2 | Volunteer 3 | Volunteer 4 | Volunteer 5 | Volunteer 6
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
Sat
Sun
Spreadsheet: 787400d1657785410-index-match-with-multiple-criteria-incl-wildcard-test-file-formats
Sheet: Prod summary

MECAPACK 1
Date | No de barquettes totale | Gn 1/3 | Bol | Verrines | No de barquettes Equipe matin | No de barquettes Equipe Apres-midi | Start time  (1st tray) | Finish time (Last tray) | start time 1st tray GN 1/3 | last tray GN 1/3 | start time 1st tray Bol | [NAME] | start time 1st tray Verrines | last tray Verrines
 |  |  |  |  |  |  | 13:00:00
2021-06-01 00:00:00
2021-06-02 00:00:00
2021-06-03 00:00:00
Spreadsheet: 30084d1225384202-transferring-data-from-a-price-list-to-a-bill-of-materials-ses-grid-tie-dc-power-worksheet-10-24-08
Sheet: Packing List Vendor 1

7960 - B Soquel Dr. #140 |  |  |  | Order Number |  | 0
Aptos, Ca. 95003 |  |  |  | Order Date:
Tel: [PHONE] |  |  |  | Shipping Method |  | Best way
Fax: [PHONE] |  |  |  | Shipping Terms |  | Prepay and add
email:  [EMAIL] |  |  |  | Payment Terms |  | Prepaid
Ship To | 0
 | 0
 | 0
 | 0
 | 0
Phone | 0
Item |  |  |  |  | Unit Cost | Total Cost
No. | Supplier Code | SES Part # | Description | Qty | US | US
1 | 0 | 0 | 0 | 0 | [NAME] | [NAME]
2 | 0 | 0 | 0 | 0 | [NAME] | [NAME]
3 | 0 | 0 | 0 | 0 | [NAME] | [NAME]
4 | 0 | 0 | 0 | 0 | [NAME] | [NAME]
5 | 0 | 0 | 0 | 0 | [NAME] | [NAME]
6 | 0 | 0 | 0 | 0 | [NAME] | [NAME]
7 | 0 | 0 | 0 | 0 | [NAME] | [NAME]
8 | 0 | 0 | 0 | 0 | [NAME] | [NAME]
9 | 0 | 0 | 0 | 0 | [NAME] | [NAME]
10 | 0 | 0 | 0 | 0 | [NAME] | [NAME]
11 | 0 | 0 | 0 | 0 | [NAME] | [NAME]
12 | 0 | 0 | 0 | 0 | [NAME] | [NAME]
13 | 0 | 0 | 0 | 0 | [NAME] | [NAME]
14 | 0 | 0 | 0 | 0 | [NAME] | [NAME]
15 | 0 | 0 | 0 | 0 | [NAME] | [NAME]
16 | 0 | 0 | 0 | 0 | [NAME] | [NAME]
17 | 0 | 0 | 0 | 0 | [NAME] | [NAME]
18 | 0 | 0 | 0 | 0 | [NAME] | [NAME]
19 | 0 | 0 | 0 | 0 | [NAME] | [NAME]
20 | 0 | 0 | 0 | 0 | [NAME] | [NAME]
21 | 0 | 0 | 0 | 0 | [NAME] | [NAME]
22 | 0 | 0 | 0 | 0 | [NAME] | [NAME]
23 | 0 | 0 | 0 | 0 | [NAME] | [NAME]
24 | 0 | 0 | 0 | 0 | [NAME] | [NAME]
25 | 0 | 0 | 0 | 0 | [NAME] | [NAME]
Special Instructions
1.   Please inspect shipment and notify us immediately if there is any damage.
2.  Please take digital photos of the damage, and note damage on dirvers bill of lading
3.  Please keep original packing until you have verified that you have received everything and items are undamaged..
4.  Verify that you have received everything listed on this packing list.  Please call us immediately if you think anything is missing.
 |  |  | THANK YOU FOR YOUR BUSINESS!
For questions about this Packing List:
[NAME]
[PHONE]     [EMAIL]
Spreadsheet: 67467d1268085550-list-dates-when-multiple-criteria-is-met-satreport
Sheet: Paste

[01]lastfirst | Student id | [studenttest] grade Level | [studenttest] test Date | [studenttest] testid | [test] name | Test score id | [testscore] name | Alphascore | Num score
Griffin, Stewie | 438 | 12 | 2009-06-06 00:00:00 | 8 |  | 16 | SAT Critical Reading |  | 380
Griffin, Stewie | 438 | 12 | 2009-06-06 00:00:00 | 8 |  | 383 | SAT I - Essay |  | 0
Griffin, Stewie | 438 | 12 | 2009-06-06 00:00:00 | 8 |  | 17 | SAT Math |  | 350
Griffin, Stewie | 438 | 12 | 2009-06-06 00:00:00 | 8 |  | 18 | SAT Writing |  | 370
Griffin, Stewie | 438 | 10 | 2007-10-05 00:00:00 | 8 |  | 16 | SAT Critical Reading |  | 390
Griffin, Stewie | 438 | 10 | 2007-10-05 00:00:00 | 8 |  | 383 | SAT I - Essay |  | 0
Griffin, Stewie | 438 | 10 | 2007-10-05 00:00:00 | 8 |  | 17 | SAT Math |  | 520
Griffin, Stewie | 438 | 10 | 2007-10-04 00:00:00 | 8 |  | 16 | SAT Critical Reading |  | 300
Griffin, Stewie | 438 | 10 | 2007-10-04 00:00:00 | 8 |  | 383 | SAT I - Essay |  | 1
Griffin, Stewie | 438 | 10 | 2007-10-04 00:00:00 | 8 |  | 17 | SAT Math |  | 300
Griffin, Stewie | 438 | 10 | 2007-10-04 00:00:00 | 8 |  | 18 | SAT Writing |  | 600
Griffin, Stewie | 438 | 12 | 2009-05-02 00:00:00 | 8 |  | 16 | SAT Critical Reading |  | 470
Griffin, Stewie | 438 | 12 | 2009-05-02 00:00:00 | 8 |  | 383 | SAT I - Essay |  | 0
Griffin, Stewie | 438 | 12 | 2009-05-02 00:00:00 | 8 |  | 17 | SAT Math |  | 490
Griffin, Stewie | 438 | 12 | 2009-05-02 00:00:00 | 8 |  | 18 | SAT Writing |  | 470
Spreadsheet: d0a782c1-4a0c-4a5c-aa4e-777c1f5188b5
Sheet: Blad1

startnr | 100 - 199     li | 200 - 299 | 300 - 399 | 400 - 499 | 500 - 599 | 600 - 699 | 700 - 799 | 800 - 899
→ | Veteranen & Dames | re | [NAME] | re | [NAME] | re | [NAME] | re
 | snelmars | snelmars | verpl per fiets | verpl per fiets | * werpgewichten | snelmars | mars rechtsom | mars rechtsom
 | verpl per fiets | verpl per fiets | hiba | kayak | kaartleesopdr. fiets | kaartleesopdr. fiets | schieten in mars | schieten in mars
 | hiba | kayak | verpl per fiets | verpl per fiets | * afstand schatten | * afstand schatten | mars voltooien | mars voltooien
 | verpl per fiets | verpl per fiets | survival | oriënteringsparcours | snelmars | * werpgewichten | * werpgewichten | snelmars
 | survival | oriënteringsparcours | verpl per fiets | verpl per fiets | mars [NAME] | mars [NAME] | kaartleesopdr. fiets | kaartleesopdr. fiets
DAG
1 | verpl per fiets | verpl per fiets | oriënteringsparcours | survival | schieten in mars | schieten in mars | * afstand schatten | * afstand schatten
 | oriënteringsparcours | survival | verpl per fiets | verpl per fiets | mars vervolg | mars vervolg | snelmars | * werpgewichten
 | verpl per fiets | verpl per fiets | kayak | hiba
 | kayak | hiba | verpl per fiets | verpl per fiets
 |  |  |  |  | *  =  op de route [NAME]
 | verpl per fiets | verpl per fiets | snelmars | snelmars
 | * werpgewichten | snelmars | mars rechtsom | mars rechtsom | snelmars | snelmars | verpl per fiets | verpl per fiets
 | kaartleesopdr. fiets | kaartleesopdr. fiets | schieten in mars | schieten in mars | verpl per fiets | verpl per fiets | hiba | kayak
 | * afstand schatten | * afstand schatten | mars voltooien | mars voltooien | hiba | kayak | verpl per fiets | verpl per fiets
 | snelmars | * werpgewichten | * werpgewichten | snelmars | verpl per fiets | verpl per fiets | oriënteringsparcours | survival
 | mars [NAME] | mars [NAME] | kaartleesopdr. fiets | kaartleesopdr. fiets | oriënteringsparcours | survival | verpl per fiets | verpl per fiets
DAG
2 | schieten in mars | schieten in mars | * afstand schatten | * afstand schatten | verpl per fiets | verpl per fiets | survival | oriënteringsparcours
 | mars vervolg | mars vervolg | snelmars | * werpgewichten | survival | oriënteringsparcours | verpl per fiets | verpl per fiets
 |  |  |  |  | verpl per fiets | verpl per fiets | kayak | hiba
 |  |  |  |  | kayak | hiba | verpl per fiets | verpl per fiets
 | *  =  op de route [NAME] |  |  |  | verpl per fiets | verpl per fiets | snelmars | snelmars
Spreadsheet: 269352d1381137310-using-if-and-function-displaying-closest-date-with-two-necessary-conditions-project
Sheet: Issue Register

 | Issue Register |  |  |  |  |  |  |  |  |  | Priority | Status
 | Project Name |  |  |  | Project # |  |  |  |  |  | Low | Open
 | Project manager |  |  |  | Sponsor |  |  |  |  |  | Med | Close
 | Project artifacts |  |  |  | Updated |  |  |  |  |  | High
 | Sr No | Date | List of Issues | Reason Of Issue | Solution | Priority | Status | Resolved Date | Comments
 | 1 | 2013-09-29 00:00:00 | issue1 | reason_issue1 | soln1 | High | Open |  | na |  |  |  | Date | List of Issues | Reason Of Issue | Solution | Priority | Status
 | 2 | 2013-09-10 00:00:00 | [NAME] | reason_issue2 | [NAME] | High | Open |  | na |  |  |  | 2013-10-02 00:00:00 | issue14 | reason_issue14 | soln14 | Low | Open
 | 3 | 2013-09-25 00:00:00 | issue3 | reason_issue3 | soln3 | High | Open |  | na
 | 4 | 2013-07-01 00:00:00 | issue4 | reason_issue4 | [NAME] | Low | Close | 2013-09-30 00:00:00 | NA
 | 5 | 2013-08-22 00:00:00 | issue5 | reason_issue5 | soln5 | High | Open |  | NA
 | 6 | 2013-09-25 00:00:00 | issue6 | reason_issue6 | soln6 | High | Open |  | NA
 | 7 | 2013-09-26 00:00:00 | issue7 | reason_issue7 | soln7 | Low | Open |  | NA
 | 8 | 2013-09-27 00:00:00 | issue8 | reason_issue8 | soln8 | High | Open |  | NA
 | 9 | 2013-05-10 00:00:00 | [NAME] | reason_issue9 | soln9 | Low | Close | 2013-10-04 00:00:00 | NA
 | 10 | 2013-09-01 00:00:00 | issue10 | reason_issue10 | [NAME] | High | Open |  | NA
 | 11 | 2013-09-30 00:00:00 | issue11 | reason_issue11 | soln11 | Low | Close | 2013-10-03 00:00:00 | NA
 | 12 | 2013-09-05 00:00:00 | issue12 | reason_issue12 | soln12 | Low | Close | 2013-09-30 00:00:00 | NA
 | 13 | 2013-05-10 00:00:00 | issue13 | reason_issue13 | soln13 | High | Open |  | NA
 | 14 | 2013-10-02 00:00:00 | issue14 | reason_issue14 | soln14 | Low | Open
Spreadsheet: 128841d1321304920-finding-lowest-cost-from-a-list-with-wildcard-lowestpricesexcludingshanghai
Sheet: Final Cost

Exact Match on Part Code excluding Shanghai
Part Code | Low Price Excl.
 | Shanghai
AAA1
BBB1
CCC1
CCC
 |  |  | 1.Trying to organise the rows directly above so they are populated the same but by lowest cost value (left to right), see example below (and keeps the wildcard)
 |  |  | AAA1 - $4.1 - AOS | AAA1 - $5.3 - DSB | AAA1 - $5.5 - ALP
 |  |  | BBB1 - $7.5 - STA | BBB10 - $7.5 - STA | BBB1 - $9.8 - ALP | BBB10 - $10.32 - AOS | BBB1 - $10.5 - DSB
2. Populate the wildcard table below so that any wildcard input in column A would return the lowest price in column B (again excluding Shanghai). Plus return the corresponding value
from column F of Raw data sheet into column C
Wildcard Tabe
Part Code | Low Price Excl. | Return Column F
 | Shanghai | value Raw Data
AAA
BBB
C1
CCC
Spreadsheet: 0b3b2867-4dd1-467d-a864-17569e2128f8
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 | Unnamed: 31 | Unnamed: 32
 |  |  |  |  |  |  |  | City and County of Denver
 |  |  |  |  |  |  |  | Kronos Change Form
 |  | Instructions
 |  |  |  |  | Please complete this form and send to the Controller's Office, Payroll Division at: 201 [NAME]. 1109; Denver, CO 80202 or save as and then email to [EMAIL] or fax to [PHONE].
 |  | Employee Information |  |  | All fields in the section must be completed.
 |  |  |  |  | Employee Name |  |  |  |  |  |  |  |  | Employee ID Number |  |  |  |  |  |  | Date
 |  |  |  |  | Department |  |  |  |  |  |  |  |  | Supervisor |  |  |  |  |  |  | Supervisor E-mail Address
 |  |  |  |  | Supervisor Work Phone:
 |  | Permanent Schedule Change Request |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Multiple Employee Permanent [NAME]
 |  |  |  |  |  |  |  | Sunday |  |  |  | Monday |  |  |  | Tuesday |  |  |  | Wednesday |  |  |  | Thursday |  |  |  | Friday |  |  |  | Saturday
 |  |  |  |  | Week One
 |  |  |  |  | Week Two
 |  |  |  |  | Effective Date |  |  |  |  |  |  |  |  |  |  |  | All new schedules must be effective on the first day of the pay period.
 |  | Pay Code Adjustments |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Multiple Employee Pay Code Adjustments
 |  |  |  |  | Type |  |  |  |  |  |  | Date(s)/Time(s)) |  |  |  |  |  |  |  |  |  |  |  | Amount
 |  | Prior Period Adjustments |  |  | Example: Vacation or Sick time not requested in time for the current pay period |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Multiple Employee Prior Period Adjustments
 |  |  |  |  | Date |  |  |  | Pay Code |  |  |  |  | Amount |  |  |  | Punch In |  |  |  | Punch Out |  |  |  | Punch In |  |  |  | Punch Out
 |  | Sick to Vacation |  |  | Sick to Vacation Conversion
 |  |  |  |  |  | Date |  |  |  |  | Amount in hours
 |  | Badge Update |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Multiple Employee Badge Updates
 |  |  |  |  |  | Badge Number
 |  | Comments
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Revised 6/15/2012
 |  | Additional forms: |  |  |  |  |  | Exemplary Performance Request |  |  |  |  |  |  |  |  | Report To Update
 |  |  | Straight Time: Declared Emergency
 |  |  | Straight Time: Holiday
 |  |  | Straight Time: Snow
 |  |  | 1.5 Rate: Emergency Response
 |  |  | 1.5 Rate: Holiday
 |  |  | 1.5 Rate: Public Event
 |  |  | 1.5 Rate: Snow
 |  |  | Comp to Overtime
 |  |  | Overtime to Comp
Spreadsheet: 8760a3f5-12b4-4e52-b039-25b1f41c9a9b
Sheet: non-GAAP Net Income and Expense

The NASDAQ OMX Group, Inc.
Reconciliation of GAAP to Non-GAAP Earnings and
Reconciliation of GAAP to Non-GAAP Operating Expenses
(in millions, except per share amounts)
 |  | Three Months Ended
 |  | December 31, |  | September 30, |  | December 31,
 |  | 2009 |  | 2009 |  | 2008
GAAP Net Income attributable to NASDAQ OMX: |  | 43 | 43 | 60 |  | 35
Adjustments:
Professional fees |  | 2 |  | 2 |  | 0
Technology |  | 3 |  | 0 |  | 0
Occupancy |  | 8 |  | 0 |  | 0
Regulatory |  | -3 |  | 0 |  | 0
Gain on sales of businesses |  | -12 |  | 0 |  | 0
Impairment of unconsolidated investees |  | 87 |  | 0 |  | 0
Workforce reductions |  | 6 |  | 4 |  | 0
Asset retirements |  | 0 |  | 10 |  | 0
Debt conversion expense |  | 0 |  | 25 |  | 0
Merger expenses |  | 0 |  | 5 |  | 10
Asset impairment charge |  | 0 |  | 0 |  | 35
Loss on foreign currency contracts, net |  | 0 |  | 0 |  | 47
Total Adjustments |  | 91 |  | 46 |  | 92
Adjustment to the income tax provision to reflect Non-GAAP adjustments(1) |  | -37 |  | -7 |  | -17
Non-recurring tax items, net |  | 2 |  | -10 |  | 0
Total Adjustments, net of tax |  | 56 |  | 29 |  | 75
Non-GAAP Net Income attributable to NASDAQ OMX: |  | 99 |  | 89 |  | 110
GAAP Diluted Earnings per Common Share: |  | 0.2 |  | 0.28 |  | 0.17
Total Adj. from Non-GAAP Net Income Above: |  | 0.26 |  | 0.14 |  | 0.35
Non-GAAP Diluted Earnings per Common Share: |  | 0.46 |  | 0.42 |  | 0.52
 |  | Three Months Ended
 |  | December 31, |  | September  30, |  | December 31,
 |  | 2009 |  | 2009 |  | 2008
GAAP Operating Expenses: |  | 220 |  | 218 |  | 223
Other Adjustments:
Professional fees |  | -2 |  | -2 |  | 0
Technology |  | -3 |  | 0 |  | 0
Occupancy |  | -8 |  | 0 |  | 0
Regulatory |  | 3 |  | 0 |  | 0
Workforce reductions |  | -6 |  | -4 |  | 0
Asset retirements |  | 0 |  | -10 |  | 0
Merger expenses |  | 0 |  | -5 |  | -10
Total Adjustments |  | -16 |  | -21 |  | -10
Non-GAAP Operating Expenses |  | 204 |  | 197 |  | 213
(1) We determine the tax effect of each item based on the tax rules in the respective jurisdiction where the transaction occurred.