tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: darrell_schoolcraft__7327__imball0202
Sheet: WTGmktg

 | /------------------------------------------  contract 22100  --------------------------------------------------------\
 | 10811 |  | 13234 |  | 16540 |  | 500648
 | Follet |  | Oasis Dairy Farms |  | WTG/TW Winker |  | Sum WTG New Mex
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | -194 | -143 |  |  | -1253 | -786
2 | -183 | -143 |  |  | -1189 | -786
3 | -164 | -143 |  |  | -1051 | -786
4 | -162 | -143 |  |  | -1329 | -786
5 | -175 | -143 |  |  | -1492 | -786
6 | -165 | -143 |  |  | -1260 | -786
7 | -135 | -143 |  |  | -1019 | -786
8 | -115 | -143 |  |  | -838 | -786
9 | -233 | -143 |  |  | -1113 | -786
10 | -202 | -143 |  |  | -1390 | -786
11 | -154 | -143 |  |  | -1253 | -786
12 | -160 | -143 |  |  | -1211 | -786
13 | -143 | -143 |  |  | -1225 | -786
14 | -133 | -143 |  |  | -933 | -786
15 | -128 | -143 |  |  | -981 | -786
16 | -104 | -143 |  |  | -840 | -786
17 | -98 | -143 |  |  | -951 | -786
18 | -94 | -143 |  |  | -565 | -786
19 | -111 | -143 |  |  | -808 | -786
20 | -90 | -143 |  |  | -700 | -786
21 | -125 | -143 |  |  | -1086 | -786
22 | -94 | -143 |  |  | -850 | -1278
23 | -64 | -143 |  |  | -552 | -1278
24 | -115 | -115 |  |  | -567 | -1278
25 | -246 | -115 |  |  | -955 | -1278
26
27
28
29
30
31
2002-01-31 00:00:00 |  |  |  |  |  |  |  |  | -37189.77
2002-02-25 00:00:00
CBS Volume
 |  |  | -4227
Spreadsheet: 797487d1663920475-use-smaller-than-in-getpivotdata-formula-test-17-
Sheet: Sheet1

 |  |  |  |  | Month | Product | Amount
 |  |  |  |  | 1 | Appels | 23
 |  |  |  |  | 1 | Pears | 16
 |  |  |  |  | 2 | Appels | 63
 |  |  |  |  | 2 | Pears | 5 |  |  |  |  |  |  | Sum of Amount | Column Labels
 |  |  |  |  | 3 | Appels | 12 |  |  |  |  |  |  | Row Labels | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | Grand Total
 |  |  |  |  | 3 | Pears | 85 |  |  |  |  |  |  | Appels | 23 | 63 | 12 | 45 | 12 | 45 | 52 | 25 | 63 | 43 | 64 | 25 | 472
 |  |  |  |  | 4 | Appels | 45 |  |  |  |  |  |  | Pears | 16 | 5 | 85 | 63 | 78 | 61 | 12 | 85 | 23 | 38 | 42 | 51 | 559
 |  |  |  |  | 4 | Pears | 63 |  |  |  |  |  |  | Grand Total | 39 | 68 | 97 | 108 | 90 | 106 | 64 | 110 | 86 | 81 | 106 | 76 | 1031
 |  |  |  |  | 5 | Appels | 12
 |  |  |  |  | 5 | Pears | 78
 |  |  |  |  | 6 | Appels | 45
 |  |  |  |  | 6 | Pears | 61
 |  |  |  |  | 7 | Appels | 52
 |  |  |  |  | 7 | Pears | 12
 |  |  |  |  | 8 | Appels | 25
 |  |  |  |  | 8 | Pears | 85 |  |  |  | Get sum of all appels before 6th month
 |  |  |  |  | 9 | Appels | 63
 |  |  |  |  | 9 | Pears | 23
 |  |  |  |  | 10 | Appels | 43
 |  |  |  |  | 10 | Pears | 38
 |  |  |  |  | 11 | Appels | 64
 |  |  |  |  | 11 | Pears | 42 |  |  |  | =GETPIVOTDATA("Amount",$O$7,"Month",<6,"Product","Appels")
 |  |  |  |  | 12 | Appels | 25
 |  |  |  |  | 12 | Pears | 51 |  |  |  | I was hoping this would work
Spreadsheet: 752595d1634842680-returning-one-value-contained-in-a-list-wordmatch_gw_revb
Sheet: Sheet1

 |  |  | [NAME] attempt | GW attempt |  |  |  | Ideal Answers | GW attempt-2 | GW attempt-3
 | red |  |  |  |  | red ball, walk, show, tent, invade,matchmake,computer,
 | red ball |  |  |  |  |  |  | Red Ball
 | red pen
 | make
 | shift
 | computer |  |  |  |  |  |  | Computer
Spreadsheet: 731657d1620486509-v-lookup-based-on-different-sheets-using-data-validation-list-test-sheets-ans
Sheet: Sheet1

 | Select Month From Drop Down Menu  --> |  | 2022-07-01 00:00:00
 | Date | Day | CO | VO 1 | VO 2 | VO 3 | VO 4 | VO 5 | VO 6
 | Morning |  | a may
 | Afternoon
 | Date | Day | CO | VO 1 | VO 2 | VO 3 | VO 4 | VO 5 | VO 6
 | Morning |  | b may
 | Afternoon
 | Date | Day | CO | VO 1 | VO 2 | VO 3 | VO 4 | VO 5 | VO 6
 | Morning
 | Afternoon
 | Date | Day | CO | VO 1 | VO 2 | VO 3 | VO 4 | VO 5 | VO 6
 | Morning
 | Afternoon
 | Date | Day | CO | VO 1 | VO 2 | VO 3 | VO 4 | VO 5 | VO 6
 | Morning
 | Afternoon
 | Date | Day | CO | VO 1 | VO 2 | VO 3 | VO 4 | VO 5 | VO 6
 | Morning
 | Afternoon
 | Date |  | CO | VO 1 | VO 2 | VO 3 | VO 4 | VO 5 | VO 6
 | Morning
 | Afternoon
 | Date | Day | CO | VO 1 | VO 2 | VO 3 | VO 4 | VO 5 | VO 6
 | Morning
 | Afternoon
 | Date | Day | CO | VO 1 | VO 2 | VO 3 | VO 4 | VO 5 | VO 6
 | Morning
 | Afternoon
 | Date | Day | CO | VO 1 | VO 2 | VO 3 | VO 4 | VO 5 | VO 6
 | Morning
 | Afternoon
 | Date | Day | CO | VO 1 | VO 2 | VO 3 | VO 4 | VO 5 | VO 6
 | Morning
 | Afternoon
 | Date | Day | CO | VO 1 | VO 2 | VO 3 | VO 4 | VO 5 | VO 6
 | Morning
 | Afternoon
Spreadsheet: 07f7f649-4107-42fe-bf81-8a7592abc3ee
Sheet: Sedans&PassAmbs

 | Equip. | Federal | 2014 Monthly | 2014 Mileage
Vehicle Description | Code | Std. Item | Rate | Rate
PASSENGER VEHICLES
Sedan, Midsize | 1100 | 10B | 260 | 0.18
Sedan, Midsize, Special Services | 1125 | 17Z | 308 | 0.2
Sedan, Midsize, Special Services | 1126 | 17, 17F | 350 | 0.2
Sedan, Midsize, Special Services, Charger | 1127 | 17R | 373 | 0.2
Sedan, Compact | 1200 | 9C, 9J, 9Z | 171 | 0.15
Sedan, Compact (Hybrid) | 1203 | 9H | 171 | 0.11
Sedan, Subcompact | 1300 | 8C, 8Z | 160 | 0.135
Sedan, Subcompact (Hybrid) | 1301 | 8H, 8J | 160 | 0.105
Sedan/Station Wagon Subcompact (Electric) | 1305 | 8E | 171 | 0.059
Sedan/Station Wagon Subcompact (Electric) | 1307 | 8P | 171 | 0.075
Sedan, Subcompact (CNG) | 1330 | 8N | 160 | 0.135
Sedan, Microcompact | 1358 | 7, 7Z | 204 | 0.136
Sedan, Large, Special Services | 1426 | 17A, 17R | 376 | 0.24
Motorcycle (Electric) | 1701 | 2E | 256 | 0
Station Wagon, Subcompact | 2000 | 12A, 12Z | 189 | 0.145
Station Wagon, Subcompact | 2100 | 13B, 13Z | 242 | 0.16
*  Federal  Standard Item Numbers are provided for information only.  Because of changes in the Federal
Standards, GSA Fleet vehicles may be available for which a Standard Item Number no longer exists.
AMBULANCES AND MEDICAL VEHICLES
Patient [NAME], Wheel Chair Vans | 3150 | 281, 282, 283, 287 | 496 | 0.37
Type I, Conventional Cab & Chassis, Additional Duty | 3178 | 210 | 752 | 0.545
Type I, Conventional Cab & Chassis, Additional Duty | 3179 | 210 | 752 | 0.545
Type I, Conventional Cab &  Chassis w/ Narrow Modular Body | 3180 | 211 | 752 | 0.545
Type I, Conventional Cab &  Chassis w/ Narrow Modular Body | 3181 | 211 | 791 | 0.59
Type 3, Forward Cont Van, Modular Body | 3188 | 213 | 650 | 0.515
Indian Health Service Ambulance, [NAME] | 3195 | 213 | 342 | 0.41
Spreadsheet: 138839d1327940154-advancing-arrays-based-on-value-shedule_example-modified-by-tigeravatar-
Sheet: DAILYSTF

DAILY STAFFING
 | 2012-01-14 00:00:00 | 2012-01-14 00:00:00 | 6 | Day ID
SHIFT |  | LEAVE/TRAINING
0800 - 1600 | Person 5
8 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
0800 - 2115 | Person 4
8/S | #N/A
 | #N/A
 | #N/A
1045 - 2400 | #N/A
11 | #N/A
 | #N/A
 | #N/A
 | #N/A
1600-2400 | Person 2
16 | Person 3
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | Location 2
0900-1700 | Person 10
9 | Person 11
 | #N/A
 | #N/A
 | SUPERINTENDENT
Spreadsheet: 864761d1711887989-smooth-line-through-scatter-plot-normal-distribution-scatter-plot-normal-dist
Sheet: Sheet1

 |  | 3600 | 6.026989929157508e-05
 |  | 3592 | 6.098133411933407e-05
 |  | 3567 | 6.324229588099175e-05
 |  | 3518 | 6.784034000926621e-05
 |  | 3339 | 8.651876233148186e-05
 |  | 2809 | 0.0001574489525135977
 |  | 2338 | 0.0002301931048431761
 |  | 1853 | 0.0002930307714420517
 |  | 1146 | 0.0003173274503341507
 |  | 759 | 0.0002891075837877715
 |  | 465 | 0.0002524926093037355
 |  | 167 | 0.0002079184119911873
 |  | 41 | 0.0001882488439431969
 |  | 1 | 0.0001820116467903372
 |  | 0 | 0.0001818559855160914
 |  | 97 | 0.0001969992870756385
 |  | 250 | 0.0002207450658758395
 |  | 601 | 0.0002706871621157585
 |  | 1610 | 0.0003123334808474694
 |  | 2096 | 0.0002646324232415443
 |  | 2577 | 0.0001932714133911286
 |  | 1372 | 0.0003204030773259973
 |  | 349 | 0.0002357075330245177
 |  | 940 | 0.0003056377333817615
 |  | 3024 | 0.0001262279352783189
 |  | 3444 | 7.52043466118395e-05
 |  | 3201 | 0.0001028972555463401
Spreadsheet: 790771d1659984540-totalling-columns-dependent-upon-text-day-team-flexi-sheet
Sheet: Flexi Dates

 | 2022-06-26 00:00:00
Spreadsheet: 265129d1379083178-sheet-protection-protect-certain-columns-allow-copy-paste-row-ordercataloghelp
Sheet: Sheet1

New Name | Old Name | Order Code | [NAME] | Std DTA Long Description | Site Submitted DTA Short Description | Site Submitted DTA Long Description
[NAME] | VITAMIN B-12 | VITB12 | [NAME] | [NAME]
Vitamin D 25 OH Lvl | VIT D  25 HYDROXY | VITD25 | Vit D 25OH | Vitamin D 25 OH Lvl
WBC Cnt | WBC COUNT | WBC | WBC | WBC Cnt
WBC Cnt Man | WBC CNT MANUAL | WBCMAN | WBC Cnt Man | WBC Cnt Man
WBC Cnt Man | WBC CNT MANUAL | WBCMAN | WBC Side 1 | WBC Side 1 Cnt
WBC Cnt Man | WBC CNT MANUAL | WBCMAN | WBC Side 2 | WBC Side 2 Cnt
 | Entire sheet should restrict user from deleting row/columns, but allow insertion of rows and copy/paste
 | Red Should be Locked and Uneditable
 | Gree should be unlocked and allow user to insert their data.
Spreadsheet: 770777d1646246218-percentage-of-night-shifts-per-month-per-variable-year-sample-employee-statistics
Sheet: Sheet1

employee statistics
Year | 2016 |  |  |  |  |  |  |  |  |  |  |  |  | 2010
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011
Employee Name | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 2012
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2014
 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |  | 2015
Night shift | 10 | 15 | 7 | 5 | 16 | 14 | 2 | 0 | 12 | 12 | 20 | 18 |  | 2016
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017
result in % |  |  |  |  |  |  |  |  |  |  |  |  |  | 2018
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2019
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022
Spreadsheet: 153226d1335808828-making-a-schedule-with-auto-time-format-and-adding-total-hours-se-schedule
Sheet: jan 16

 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
 | 2012-01-16 00:00:00 | 2012-01-17 00:00:00 | 2012-01-18 00:00:00 | 2012-01-19 00:00:00 | 2012-01-20 00:00:00 | 2012-01-21 00:00:00
[NAME] | off | 9:30-5:30 | 8:00-5:00 | 8:00-5:00 | 8:30-5:30 | 9:15-5:15
 |  | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00
[NAME] | 8:30-5:30 | 8:30-5:30 | 9:30-5:30 | 8:30-5:30 | 9:30-5:30 | off
 | 2:00-3:00 | 2:00-3:00 | 2:00-3:00 | 2:00-3:00 | 2:00-3:00
Ray | 8:00-5:00 | 8:00-5:00 | 8:00-4:00 | 7:00-4:00 | 8:00-4:00 | off
 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00
Mark | 8:00-5:00 | 9:00-4:00 | 8:30-5:30 | 8:30-5:30 | off | 9:00-5:00
 | 1:00-2:00 | 1:00-2:00 | 1:00-2:00 | 1:00-2:00 |  | 1:00-2:00
[NAME] | 8:30-5:30 | off | 8:30-5:30 | 7:00-4:00-HOMER | 8:00-5:00 | 9:15-5:15-ctr
ctr 12-2 | 11:00-12:00 | off | 11:00-12:00 | 1ub | 11:00-12:00 | 11:00-12:00
Kat |  |  | 8:00-5:00 |  |  | 9:15-5:15
 |  |  | 12:00-1:00 |  |  | 12:00-1:00
 |  |  | 12:00-1:00
 |  |  |  |  |  | total hours
Spreadsheet: 134111d1325017050-simplified-report-for-equipment-maintenance-equipment-cost-report
Sheet: 879

AMC No. | 09-04 | EQUIPMENT COST REPORT
Unit Number | OTV 0879 |  | Start Date | 24/07/2011 |  |  |  | [NAME] |  | 555
Employee Name: |  |  | End Date | 06/08/2011 |  |  |  | Hour [NAME] |  | 5
Date | Receipt Number | Vendor | Fuel |  | [NAME] |  | Motor Oil |  | [NAME]. Cost | Total Cost | Odometer | PRINT NAME
 |  |  | Quantity | Cost | Quantity | Cost | Quantity | Cost
 |  |  |  |  |  | Hour [NAME] |  |  |  | Odometer End
Service Record
[NAME] | [NAME] | Vendor | Receipt Number
Filter Changed |  |  |  |  |  | NOTES
Oil Changed
Greased
Other
Supervisor Signature: __________________________________________
Spreadsheet: 20a392d2-7dd8-4e31-8937-15c2a7566f34
Sheet: D

Course color corresponds with term of offering.  RED for fall semester, PURPLE for J-term, GREEN for both fall and J-term.
 | AOK Designation | CAR Designation | Comment
Drama
DRAM 111 | Arts & Literature-Arts
DRAM 211 | Arts & Literature-Arts
DRAM 215 | Arts & Literature-Arts
DRAM 310 | Arts & Literature-Arts (3 times at 1 hour)
DRAM 320 | Arts & Literature-Arts
 | OR Arts & Literature-Literature
DRAM 330 | Arts & Literature-Arts
DRAM 331 | Arts & Literature-Arts | Computing
DRAM 332 | Arts & Literature-Arts
DRAM 333 | Arts & Literature-Arts
DRAM 334 | Arts & Literature-Arts
DRAM 341 | Arts & Literature-Arts
DRAM 342 | Arts & Literature-Arts
DRAM 381 |  | Experiential-Research
DRAM 381 | Arts & Literature-Arts |  | J-term 2012 (Black American Theater)
DRAM 381 | Arts & Literature-Arts |  | J-term 2013 (Playmaking: The Playwright's Process)
DRAM 382 |  | Experiential-Research
DRAM 422 |  | Experiential-Research; Capstone
Spreadsheet: michelle_cash__26496__OWBPA Data Sent
Sheet: Sheet1

STATISTICAL INFORMATION
OWBPA DATA
Offered Payments | [NAME] | Title | Age
Y | NY | Account Executive | 30
Y | NY | Account Executive | 45
 | NY | Accountant | 32
 | NY | Accountant | 43
 | NY | Accounting Manager | 36
 | CH | Administrative Assistant | 26
 | NY | Administrative Assistant | 31
 | NY | Administrative Assistant | 64
 | NY | Administrative Assistant | 56
 | MO | Administrative Assistant | 36
 | NY | Assistant Vice President | 38
 | NY | Bullion Trader | 52
 | NY | Cash Management Administrator | 60
Y | NY | Clearing/Adminstration Controller | 28
 | CH | Contract Administrator | 26
 | NY | Contract Administrator | 32
 | NY | Contract Administrator | 29
 | NY | Contract Administrator | 54
 | NY | Contract Administrator | 30
Y | NY | Contract Administrator | 25
 | NY | Domestic Traffic | 24
 | NY | Executive Assistant | 61
 | NY | Executive Vice President | 55
Y | NY | Financial Controller | 38
Y | NY | FX Dealer | 24
Y | NY | FX Dealer | 26
 | NY | FX Manager | 37
 | NY | [NAME] | 26
 | NY | [NAME] | 25
 | NY | [NAME] | 28
 | NY | [NAME] | 25
 | NY | [NAME] | 29
 | NY | Lead Sales | 39
 | NY | Mail [NAME] | 39
 | NY | Manager Corporate Accounting | 33
 | NY | Managing Director | 53
 | NY | Mgr, Admin/Terminal Trader | 36
 | NY | Mgr, Administration & Logistic | 60
 | CH | Operations Administrator | 33
 | NY | Operations Administrator | 29
 | NY | Operations Manager | 46
 | NY | Operations Specialist | 48
Y | NY | Pending | 35
Y | NY | President | 49
 | NY | President | 44
 | NY | President & CEO | 47
 | NY | Project Mgr\Risk Manager | 36
 | NY | Sales Representative | 35
 | NY | Sales Representative | 30
 | MO | [NAME] | 36
 | NY | Senior Network Manager | 39
 | NY | Senior Systems Administrator | 35
 | UK | Senior Vice President | 38
 | TX | Senior Vice President | 41
 | UK | Senior Vice President | 48
 | NY | Senior Vice President | 40
 | NY | Senior Vice President & CFO | 40
Y | NY | Sr LME Dealer | 31
Y | NY | Trader | 28
Y | NY | Trader | 37
Y | NY | Trader | 30
Y | NY | Trader | 30
 | CH | Trader | 46
 | NY | Trader | 45
 | NY | Trader | 29
 | NY | Trader | 42
 | NY | Trader | 39
 | NY | Traffic Adm./Sales Asst. | 41
 | CH | Traffic Administrator | 37
 | NY | Traffic\Contract Administrator | 53
 | NY | Traffic\Contract Administrator | 32
 | NY | Traffic\Contract Administrator | 51
 | NY | Treasurer | 44
 | CH | Vice President | 46
 | NY | Vice President | 53
 | NY | Vice President | 33
 | NY | Vice President | 33
 | NY | Vice President - MIS | 40
 | MO | Vice President - Trading | 56
 | NY | Vice President & Controller | 40
 | NY | VP, Operations & Compliance | 52
Spreadsheet: 00320644-0796-495b-ba6e-1715c54ad7c7
Sheet: Sheet1

FOUND IN | BUT NOT IN | Total | % with EST | Unnamed: 4 | # with EST | % found in genome | % found in one piece | Unnamed: 8 | # w/o EST | % found in genome.1 | % found in one piece.1
Beijing indica | Syngenta japonica IRGSP japonica | 8595 | 4.92 |  | 423 | 64.0661938534279 | 43.4988179669031 |  | 8172 | 44.3220753793441 | 33.90846793930494
Beijing indica Syngenta japonica | IRGSP japonica | 1967 | 27 |  | 531 | 10.54613935969868 | 6.77966101694915 |  | 1436 | 28.41225626740947 | 21.86629526462395
Beijing indica IRGSP japonica | Syngenta japonica | 1586 | 20.05 |  | 318 | 46.54088050314466 | 36.47798742138365 |  | 1268 | 60.17350157728707 | 47.00315457413249
Beijing indica     and ALL others |  | 36940 | 38.9 |  | 14369 |  |  |  | 22571
Syngenta japonica | Beijing indica IRGSP japonica | 3268 | 3.03 |  | 99 | 74.74747474747475 | 58.5858585858586 |  | 3169 | 32.02903124013884 | 26.94856421584096
Syngenta japonica Beijing indica | IRGSP japonica | 1727 | 29.3 |  | 506 | 10.27667984189723 | 7.312252964426877 |  | 1221 | 27.68222768222768 | 22.11302211302211
Syngenta japonica IRGSP japonica | Beijing indica | 5777 | 8.53 |  | 493 | 44.82758620689656 | 34.48275862068966 |  | 5284 | 57.24829674489024 | 44.43603330809992
Syngenta japonica     and ALL others |  | 35052 | 39.5 |  | 13844 |  |  |  | 21208
IRGSP japonica | Beijing indica Syngenta japonica | 1079 | 7.69 |  | 83 | 60.24096385542169 | 50.60240963855421 |  | 996 | 77.30923694779116 | 62.14859437751004
IRGSP japonica Beijing indica | Syngenta japonica | 1331 | 20.89 |  | 278 | 42.44604316546763 | 37.41007194244605 |  | 1053 | 58.0246913580247 | 48.81291547958214
IRGSP japonica Syngenta japonica | Beijing indica | 5817 | 8.77 |  | 510 | 41.96078431372549 | 32.74509803921568 |  | 5307 | 57.56547955530431 | 44.9783305068777
IRGSP japonica     and ALL others |  | 35408 | 40.31 |  | 14273 |  |  |  | 21135
Spreadsheet: 478827d1473088259-excel-formula-to-convert-data-range-to-columns-convert-data-to-columns
Sheet: Sheet2

 |  |  |  |  |  | Work Centre# |  |  | Work Centre# |  |  | Work Centre# |  |  | Work Centre# |  |  | Work Centre# |  |  | Work Centre# |  |  | Work Centre#
 |  |  |  |  |  | 1 |  |  | 2 |  |  | 3 |  |  | 4 |  |  | 5 |  |  | 6 |  |  | 7
 |  |  |  |  |  | Employee | Bonus |  | Employee | Bonus |  | Employee | Bonus |  | Employee | Bonus |  | Employee | Bonus |  | Employee | Bonus |  | Employee | Bonus
 | Table of Contents
Employee | Work Centre# | Bonus
[NAME] | 1 | 253
[NAME] | 2 | 255
[NAME] | 3 | 277
[NAME] | 4 | 244
Duanne Busch | 6 | 256 |  |  |  |  | need Excel formula/s to create output in coloumns as above please
[NAME] | 6 | 277
Ingrid Jones | 5 | 288 |  |  |  |  | [NAME] does not work as the dominant factor is the work centre # followed by employee name with bonus in decending order.
[NAME] | 5 | 211
[NAME] | 7 | 166 |  |  |  |  | any help is welcome, thank you!
[NAME] | 3 | 287
[NAME] | 3 | 261
[NAME] | 4 | 259
[NAME] | 1 | 258
[NAME] | 6
[NAME]
Ingrid Jones | 7 | 299
[NAME]
[NAME] | 2 | 122
[NAME] | 3 | 166
Spreadsheet: 674897d1588072878-combination-of-two-iterative-formula-expected
Sheet: Sheet1

 |  | ARRAY 1 |  |  |  |  |  |  |  | 3 | 1
3 | 1 | [NAME] | STEPHEN | JOANNE |  |  |  |  |  | 4 | 2
4 | 2 | TREVOR | THOMAS | FRED | [NAME] |  |  |  |  | 2 | 3
2 | 3 | STEPHEN | ANDREW |  |  |  |  |  |  | 3 | 4
3 | 4 | CRAIG | TREVOR | THOMAS |  |  |  |  |  | 7 | 5
7 | 5 | JOANNE | FRED | TREVOR | THOMAS | [NAME] | [NAME] | [NAME]
ARRAY2 | DESIRED | helper | ARRAY2 | DESIRED | helper | ARRAY2 | DESIRED | helper | ARRAY2 | DESIRED | helper
[NAME] |  |  | CRAIG |  |  | [NAME] |  |  | STEPHEN
STEPHEN |  |  | THOMAS |  |  | STEPHEN |  |  | ANDREW
 |  |  |  |  |  | CRAIG
 |  |  |  |  |  | THOMAS
Spreadsheet: 860680d1708688597-how-to-use-multiple-worksheets-to-list-categories-by-date-order-wgs-accounts
Sheet: Receipts by Category

 | Category | Date | [NAME] | Transaction | Receipts
 | Gun Subscriptions | 2023-04-03 00:00:00 | [NAME] | Cash | 21.5 |  |  | Guns Subscriptions Half / Fully Paid
 |  | 2023-04-03 00:00:00 | [NAME] (final payment) | Online | 1003.5 |  |  | First payment by 30th April
 |  | 2023-04-10 00:00:00 | [NAME] (full payment) | Online | 1025 |  |  | Final Payment by 31st July
 |  | 2023-04-11 00:00:00 | [NAME] (full payment) | Online | 2050
 |  | 2023-04-11 00:00:00 | [NAME] (full payment) | Online | 2050 |  |  | Full Guns | [NAME] | x | x
 |  | 2023-04-15 00:00:00 | [NAME] (full payment) | Online | 1025 |  |  | (£2050) | [NAME] | x | x
 |  | 2023-04-18 00:00:00 | [NAME] (full payment) | Online | 1025 |  |  |  | [NAME] | x | x
 |  | 2023-04-18 00:00:00 | [NAME] | Online | 1025 |  |  |  | [NAME] | x | x
 |  | 2023-04-21 00:00:00 | [NAME] | Online | 500
 |  | 2023-04-24 00:00:00 | [NAME] | Online | 525 |  |  | Half Guns | [NAME] | x | x
 |  | 2023-05-02 00:00:00 | [NAME] | Online | 1025 |  |  | (£1025) | [NAME] | x | x
 |  | 2023-05-03 00:00:00 | [NAME] (full payment) | Online | 1025 |  |  |  | [NAME] | x | x
 |  | 2023-05-06 00:00:00 | [NAME] | Online | 512.5 |  |  |  | [NAME] | x | x
 |  | 2023-05-06 00:00:00 | [NAME] | Online | 512.5 |  |  |  | [NAME] | x | x
 |  | 2023-05-08 00:00:00 | [NAME] | Online | 512.5 |  |  |  | [NAME] | x | x
 |  | 2023-05-08 00:00:00 | Smudge T-Smith (full payment) | Online | 1025 |  |  |  | Smudge T-Smith | x | x
 |  | 2023-05-15 00:00:00 | [NAME] (full payment) | Online | 1025 |  |  |  | [NAME] | x | x
 |  | 2023-07-14 00:00:00 | [NAME] (final poayment) | Online | 525 |  |  |  | [NAME] | x | x
 |  | 2023-07-19 00:00:00 | [NAME] payment) | Online | 1025 |  |  |  | [NAME] | x | x
 |  | 2023-07-31 00:00:00 | [NAME] (final payment) | Online | 512.5 |  |  |  | [NAME] | x | x
 |  | 2023-07-31 00:00:00 | [NAME] (final payment) | Online | 500 |  |  |  | Gregory Park | x | x
 |  | 2023-08-03 00:00:00 | [NAME] (final payment) | Online | 512.5
 |  | 2023-08-03 00:00:00 | [NAME] (final payment) | Online | 512.5 |  |  | Quarter Guns
 |  | 2023-08-09 00:00:00 | [NAME] (final payment) | Cheque | 1025 |  |  | (£512.50)
 | Gun Subscriptions - Total |  |  | (Estimated - £20,500)
 | Daily Gun Collections | 2023-10-14 00:00:00 | Gun Collections | Cash | 200
 |  | 2023-10-28 00:00:00 | Gun Collections | Cash | 200
 |  | 2023-11-11 00:00:00 | Gun Collections | Cash | 200
 |  | 2023-11-25 00:00:00 | Gun Collections | Cash | 200
 |  | 2023-12-09 00:00:00 | Gun Collections | Cash | 200
 |  | 2023-12-23 00:00:00 | Gun Collections | Cash | 200
 |  | 2024-01-06 00:00:00 | Gun Collections | Cash | 200
 |  | 2024-01-20 00:00:00 | Gun Collections | Cash | 200
 |  | 2024-01-27 00:00:00 | Gun Collections | Cash | 180
 | Daily Gun Collections - Total |  |  | (Estimated - £1,800)
 | Grand Total |  |  | (Estimated - £22,300)
Spreadsheet: 748261d1632003492-display-the-lowest-number-of-the-3-cells-using-if-and-l2-0-l3-0-l4-0-in-stock-0-inventory_for_excel_forum
Sheet: INVENTORY

Bundle Set | TYPE | SKU | STOCK |  |  |  |  | Individual Parts | TYPE | SKU | STOCK
 | Bundle 1 | PB-50036S-WM25 |  |  |  |  |  |  | pencil [NAME] | PB-50036S-HWH | 8
 |  |  |  |  |  |  |  |  | Pencil | PN-36S-SQWM-L | 6
 |  |  |  |  |  |  |  |  | Eraser | ER-10036S-WH | 2
 | Selling Formats:
 | Set 1: Pencil Box + Pencil + Eraser (3) |  |  |  |  |  |  |  | PARTS
Spreadsheet: 35627d1233214598-returning-multiple-results-for-one-lookup-value-multivalue-return-vlookups
Sheet: PO

DATE: |  | 2009-01-28 23:24:55
 |  |  |  |  |  |  |  |  |  |  |  | Cutting | XS-XL
 | STYLE: | 2784 |  |  |  |  |  |  |  |  |  | CO: | USA
COLOR |  |  |  |  | QTY |  |  | Cost
RED PEPPER |  |  |  |  | 300 |  |  |  |  | 5.5
AEGEAN SEA |  |  |  |  | 200 |  |  |  |  | 5.5
 |  |  |  | TOTAL UNITS | 500
 |  |  |  | TYPE OF PRE-PACK | 14 ppk
 |  | Merged cells removed so that an array formula can be used. The new installed function is called VLOOKUPS and it will return multiple values when the array is activated.
 |  | To activate the array, enter the formula in the first cell, copy it down the rest of the cells needed (I did rows 8 to 15), with the whole range still selected, press F2,
 |  | and then CTRL-SHIFT- ENTER to activate the array. This is active, so as data is added to the DATA sheet, this list will grow/sort automatically.