tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 722048d1615017626-sum-cell-dependant-on-ratio-with-xlookup-and-sumif-sample
Sheet: Sheet1

Hours by Shift | 2:3 | 1:2 | 1:3
Mon-Fri (6am-8pm) | 1.5 | 0 | 15
Mon-Fri (8pm-12am) | 6.5 | 0 | 29
Saturday | 4 | 0 | 12
Sunday | 4 | 0 | 12
Public holiday | 0.9 | 0 | 4.6
Other | 0 | 0 | 7
Other2 | 0 | 0 | 0
Total:
 | 2:3 | 1:2 | 1:3
RATIO1 | Staff | Participants |  |  |  |  | 6
1:1 | 1 | 1
1:2 | 1 | 2
1:3 | 1 | 3
1:4 | 1 | 4
1:5 | 1 | 5
1:6 | 1 | 6
1:7 | 1 | 7
1:8 | 1 | 8
1:9 | 1 | 9
1:10 | 1 | 10
1:11 | 1 | 11
1:12 | 1 | 12
1:13 | 1 | 13
1:14 | 1 | 14
1:15 | 1 | 15
1:16 | 1 | 16
1:17 | 1 | 17
1:18 | 1 | 18
1:19 | 1 | 19
1:20 | 1 | 20
2:1 | 2 | 1
2:2 | 2 | 2
2:3 | 2 | 3
2:4 | 2 | 4
2:5 | 2 | 5
2:6 | 2 | 6
2:7 | 2 | 7
2:8 | 2 | 8
2:9 | 2 | 9
2:10 | 2 | 10
2:11 | 2 | 11
2:12 | 2 | 12
2:13 | 2 | 13
2:14 | 2 | 14
2:15 | 2 | 15
2:16 | 2 | 16
2:17 | 2 | 17
2:18 | 2 | 18
2:19 | 2 | 19
2:20 | 2 | 20
3:1 | 3 | 1
3:2 | 3 | 2
3:3 | 3 | 3
3:4 | 3 | 4
3:5 | 3 | 5
3:6 | 3 | 6
3:7 | 3 | 7
3:8 | 3 | 8
3:9 | 3 | 9
3:10 | 3 | 10
3:11 | 3 | 11
3:12 | 3 | 12
3:13 | 3 | 13
3:14 | 3 | 14
3:15 | 3 | 15
3:16 | 3 | 16
3:17 | 3 | 17
3:18 | 3 | 18
3:19 | 3 | 19
3:20 | 3 | 20
4:1 | 4 | 1
4:2 | 4 | 2
4:3 | 4 | 3
4:4 | 4 | 4
4:5 | 4 | 5
4:6 | 4 | 6
4:7 | 4 | 7
4:8 | 4 | 8
4:9 | 4 | 9
4:10 | 4 | 10
4:11 | 4 | 11
4:12 | 4 | 12
4:13 | 4 | 13
4:14 | 4 | 14
4:15 | 4 | 15
4:16 | 4 | 16
4:17 | 4 | 17
4:18 | 4 | 18
4:19 | 4 | 19
4:20 | 4 | 20
5:1 | 5 | 1
5:2 | 5 | 2
5:3 | 5 | 3
5:4 | 5 | 4
5:5 | 5 | 5
5:6 | 5 | 6
5:7 | 5 | 7
5:8 | 5 | 8
5:9 | 5 | 9
5:10 | 5 | 10
5:11 | 5 | 11
5:12 | 5 | 12
5:13 | 5 | 13
5:14 | 5 | 14
5:15 | 5 | 15
5:16 | 5 | 16
5:17 | 5 | 17
5:18 | 5 | 18
5:19 | 5 | 19
5:20 | 5 | 20
6:1 | 6 | 1
6:2 | 6 | 2
6:3 | 6 | 3
6:4 | 6 | 4
6:5 | 6 | 5
6:6 | 6 | 6
6:7 | 6 | 7
6:8 | 6 | 8
6:9 | 6 | 9
6:10 | 6 | 10
6:11 | 6 | 11
6:12 | 6 | 12
6:13 | 6 | 13
6:14 | 6 | 14
6:15 | 6 | 15
6:16 | 6 | 16
6:17 | 6 | 17
6:18 | 6 | 18
6:19 | 6 | 19
6:20 | 6 | 20
Spreadsheet: 835619d1688683056-script-formula-macro-to-update-headers-examplebookheaders2
Sheet: Sheet1

Client First Name | Client Last Name | Square Feet | Client Address1 | Client Address2 | Client City | Client State | [NAME] | Client Email | Client Work Phone | Client Mobile | Client Home Phone
[NAME] | Smith | 2000 | 123 test st | st 3 | Phoenix | AZ | 85024 | [EMAIL] | 4567894545 | 7898521203 | 7412588522
[NAME] | [NAME] | 2002 | 456 test st | st 4 | Peoria | AZ | 85025 | [EMAIL] | 5623258974 | 5648745120
Spreadsheet: e9f2f264-1740-4134-b1ba-e73fafabef61
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SNOWSHOE | T1 | SKATE | T2 | SKI | POSITION | TOTAL TIME
6406 | 28247 | Tone | Dalen | NOR | 52 | 00:24:04 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1 | 01:27:26
6406 | 28253 | Margarita | Ovsyannikva | RUS | 51 | 00:24:27 | 00:00:00 | [NAME] | 00:00:00 | [NAME] | 2 | 01:30:46
Spreadsheet: 681396d1591545963-rolling-average-formula-golf-handicaps-test
Sheet: Sam

Score | Course | Par | Over Par | Rolling Average
81 | Chiltern Forest |  |  | #N/A |  | Rolling Average
96 | Millbrook |  |  | #N/A
99 | Bedford |  |  | #N/A
93 | Chiltern Forest |  |  | #N/A
93 | Three Locks |  |  | #N/A
91 | Bedford |  |  | #N/A
89 | Three Locks |  |  | #N/A
95 | Millbrook |  |  | #N/A
95 | Millbrook |  |  | #N/A
97 | Millbrook
90 | Three Locks
88 | Millbrook
86 | Chiltern Forest
95 | Millbrook
87 | Chiltern Forest
95 | Millbrook
91 | Millbrook
109 | Millbrook
105 | Millbrook
96 | Millbrook
97 | Millbrook
96 | Millbrook
Spreadsheet: 471833d1469205567-transpose-data-birnen2
Sheet: Tabela de conrespondencias

 | Legenda: | 0 - Unconfirmed
 |  | 1 - Confirmed
Tabela 1 |  |  |  |  |  |  |  | Tabela 2
 |  | A |  |  |  |  |  | A | B | Resultado
 | Conexões | 1 | 2 | 3 | 4 | 5
B | 1
 | 2 | 1
 | 3 | 0 | 1
 | 4 | 1 | 1 | 1 |  |  |  |  |  |  | Confirmed not Unconfirmed
 | 5 | 0 | 0 | 1 | 0
 |  |  |  |  |  |  |  |  |  |  | Unconfirmed not Confirmed
Tabela 3 |  |  |  |  |  |  |  | Tabela 4
 |  | A |  |  |  |  |  | A | B | Resultado
 | Conexões | [NAME] | paulo | [NAME] | andre | rui
B | [NAME]
 | Paulo | 1
 | [NAME] | 0 | 1
 | andre | 1 | 1 | 1
 | rui | 0 | 0 | 1 | 0
Spreadsheet: 154361d1336399934-formula-with-alternating-cells-rsml
Sheet: Sheet1

 | Company Name | [NAME] | Request signed | Request forwarded | supplier contact | supplier approval | P.L. Contact | P.L. Approval | L.P. Contact | L.P. Approval | PSP contact | PSP Approval | [NAME] contact | [NAME] | Bidders | [NAME] | Quotes Received | Vendor | Vendor  # | Company # | Amount | Del. Date | CCB Submitted | CCB Approval | CCB Complete | Final Status
 | Wal mart | 2012-02-02 00:00:00 | 2012-02-04 00:00:00 | 2012-02-07 00:00:00 | [NAME] | 2012-03-01 00:00:00 | [NAME] | 2012-03-01 00:00:00 | [NAME] | 2012-03-03 00:00:00 | [NAME] | 2012-03-05 00:00:00 | [NAME] | 2012-03-05 00:00:00 | [NAME] | 2012-03-06 00:00:00 | 2012-03-09 00:00:00 | [NAME] | 00-1233 | 134324 | 700 | 2012-07-03 00:00:00 | 2012-04-01 00:00:00 | 2012-04-08 00:00:00 | 2012-04-25 00:00:00 | Complete
 | Cosco | 2012-02-03 00:00:00 | 2012-02-05 00:00:00 | 2012-03-01 00:00:00 | [NAME] | 2012-03-01 00:00:00 | [NAME] | 2012-03-02 00:00:00 | [NAME] | 2012-03-04 00:00:00 | [NAME] | 2012-03-06 00:00:00 | [NAME] |  | [NAME] |  |  | [NAME] |  |  |  |  |  |  |  | Underway
 | K mart |  |  |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  |  | [NAME] |  |  |  |  |  |  |  | Not started
Spreadsheet: 166647d1341683489-averageif-statement-for-excel-2003-copy-of-example
Sheet: Sheet1

Criteria | Number to average |  | For nerds |  | for the rest of us plebs
A | 1 |  | 7.5 |  | 3.333333333333333
B | 2 |  | 6.4 |  | 6.4
C | 3 |  | 10.5 |  | 10.5
A | 4
A | 5
B | 6
B | 7
B | 8
B | 9
C | 10
C | 11
C | 12
C | 13
C | 14
Spreadsheet: 54628d1254674976-import-data-range-based-on-specific-criteria-sample-wrk-shedule
Sheet: Sheet1

MCAW / MCSH / MMSH / T- 12 WORK SCHEDULE  WEEK |  |  |  |  |  |  |  | 47 | WEEK TOTAL HRS = |  |  |  | 0
WO # | TASK # | UNIT # | USI # | EQUIP # | WORK ORDER DESC | HOLDS | STATUS | TARGET START | HOURS | PRIORITY | WO TYPE | EARLY DATE | LATE  DATE | ITEM # | CREW
2009-11-16 00:00:00
MCAW | MON TOTAL HRS = |  | 0 |  |  |  | MCSH | MON TOTAL HOURS = |  | 0 |  | MMSH | MON TOTAL HOURS = |  | 0 | NOTES
MCAW | MON RESOURCE% = |  | 0 |  |  |  | MCSH | MON RESOURCE % = |  | 0 |  | MMSH | MON RESOURCE % = |  | 0
2009-11-17 00:00:00
MCAW | TUE TOTAL HRS = |  | 0 |  |  |  | MCSH | TUES TOTAL HOURS = |  | 0 |  | MMSH | TUES TOTAL HOURS = |  | 0 | NOTES
MCAW | TUE RESOURCE%  = |  | 0 |  |  |  | MCSH | TUES RESOURCE % = |  | 0 |  | MMSH | TUES RESOURCE % = |  | 0
Spreadsheet: 763158d1642011908-cumulative-array-cumulative-array
Sheet: Sheet1

 |  |  |  |  | Table A | 9 | 6 | 8 | 6 | 7 | 3
 |  |  |  |  |  | 9 | 6 | 10 | 7 | 4 | 7
 |  |  |  |  |  | 10 | 1 | 10 | 1 | 7 | 10
 |  |  |  |  |  | 9 | 8 | 8 | 5 | 7 | 8
 |  |  |  |  | Table B | 6 | 2 | 1 | 2 | 5 | 5
 |  |  |  |  |  | 5 | 2 | 2 | 9 | 3 | 1
 |  |  |  |  |  | 9 | 4 | 4 | 2 | 6 | 5
 |  |  |  |  |  | 1 | 5 | 7 | 4 | 3 | 6
 |  |  |  |  | Result
 |  |  |  |  | A-B
 |  |  |  |  | Required
 |  |  |  |  |  |  | 4 | 7 | 4 | 0 | 0
 |  |  |  |  |  | 4 | 4 | 8 | 0 | 1 | 4
 |  |  |  |  |  | 1 | 0 | 6 | 0 | 1 | 5
 |  |  |  |  |  | 8 | 0 | 1 | 0 | 4 | 2
Spreadsheet: 754873d1636551351-reference-every-8th-cell-from-another-sheet-example-workbook
Sheet: Awarded Production 

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Project Name |  | MONTH OF APRIL 2021 |  |  |  |  |  |  |  |  | MONTH OF MAY 2021
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FORECAST LABOR |  | ACTUAL LABOUR |  | FORECAST MATERIAL |  | ACTUAL MATERIAL |  |  | FORECAST LABOR |  | ACTUAL LABOUR |  | FORECAST MATERIAL |  | ACTUAL MATERIAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Production | Cost | Production | Cost | Production | Cost | Production | Cost |  | Production | Cost | Production | Cost | Production | Cost | Production | Cost
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Proj 1 |  | 4 | 400 | 7 | 700 | 10 | 1000 | 13 | 1300 |  | 3 | 300 | 6 | 600 | 9 | 900 | 12 | 1200
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Proj 2 |  | 3 | 300 | 6 | 600 | 9 | 900 | 12 | 1200 |  | 2 | 200 | 5 | 500 | 8 | 800 | 11 | 1100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Proj 3 |  | 2 | 200 | 5 | 500 | 8 | 800 | 11 | 1100 |  | 4 | 400 | 7 | 700 | 10 | 1000 | 13 | 1300
Spreadsheet: 0a8791de-84e4-4eb4-bfac-22483612972b
Sheet: Diesel Tech 1

DIESEL TECHNOLOGY
Associate in Applied Science
Student Name:
ID #
General Education | Semester | Grade
___ Writing/Accessing Information (3)
___ Mathematics (3)
___ [NAME] (3)
___ Behavioral Science (3)
___ Heritage/Humanities/Foreign Language (3)
___ CIT 105 (3) Introduction to Computers or IC3 Computer Literacy Exam
Technical Core
Required
___ BEX 100 (3) Basic Electricity for Non-Majors
AND ___ BEX 101 (2) Basic Electricity Lab for Non-Majors
OR ___ ADX 120 (3) Basic Automotive Electricity
AND ___ ADX 121 (2) Basic Electiricity Lab
OR ___ ELT 110 (5) Circuits I
___ ADX 170 (3) Climate Control AND ___ ADX 171 (1) Climate Control Lab
___ DIT 103 (2) Preventive Maintenance Lab
___ DIT 110 (3) Introduction to Diesel Engines
AND ___ DIT 111 (2) Introduction to Diesel Engines Lab
OR ___ ADX 150 (3) Engine Repair AND ___ ADX 151 (2) Engine Repair
___ [NAME] (3) Diesel Engine Repair AND ___ DIT 113 (2) Diesel Engine Repair Lab
___ DIT 140 (3) Hydraulics AND ___ DIT 141 Hydraulics Lab
OR ___ FPX 100 (3) Fluid Power AND ___ FPX 101 (2) Fluid Power Lab
___ DIT 150 (3) Power Trains AND ___ DIT 151 (2) Power Trains Lab
___ DIT 190 (3) Electrical Systems for Diesel Equipment
AND ___ DIT 191 (2) Electrical Systems for Diesel Equipment Lab
OR ___ ADX 260 (3) Electrical Systems AND ___ ADX 261 (2) Electrical Systems Lab
Agriculture Diesel Technician Option
___ DIT 152 (3) Powertrain for Construction Equipment
___ DIT 153 (2) Powertrain for Construction Equipment Lab
___ DIT 121 (3) Introduction to Maintenance Welding Lab
OR ___ IMT 100 (3) Welding for Maintenance
AND ___ IMT 101 (2) Welding for [NAME]
OR ___ WLD 120 (3) Shielded Metal Arc Welding (SMAW)
AND ___ WLD 121 (2) Shielded Metal Arc Welding (SMAW) Lab
Southeast Kentucky Community & Technical College | Updated Spring 2013
Spreadsheet: 167164d1341919486-copy-data-with-3-horisontal-or-vertical-criterias-index-and-match-test-excel-sample3
Sheet: Forecasts

Last occured quarter is [NAME] and previous Q1/12
Problem 1.
Cars | Last occured quarter | Previous quarter
World TOTAL | 2341 | 2335
Boats | Last occured quarter | Previous quarter
World TOTAL | 9678 | 9700
 |  |  |  |  |  |  |  |  | If last occurred is [NAME] I need the Q3/12 and [NAME] to be left empty although Data Source sheet has numbers in them
Problem 2.
 |  |  |  |  |  |  |  |  |  |  | forecast | forecast
Cars | Q1/10 | Q2/10 | Q3/10 | Q4/10 | Q1/11 | Q2/11 | Q3/11 | Q4/11 | Q1/12 | [NAME] | Q3/12 | Q4/12
World TOTAL | 2287 | 2293 | 2299 | 2305 | 2311 | 2317 | 2323 | 2329 | 2335 | 2341
 |  |  |  |  |  |  |  |  |  |  | forecast | forecast
Boats | Q1/10 | Q2/10 | Q3/10 | Q4/10 | Q1/11 | Q2/11 | Q3/11 | Q4/11 | Q1/12 | [NAME] | Q3/12 | Q4/12
World TOTAL | 9876 | 9854 | 9832 | 9810 | 9788 | 9766 | 9744 | 9722 | 9700 | 9678
Spreadsheet: 86654d1286579676-excel-2007-automatically-copy-data-from-master-sheet-new-microsoft-office-excel-worksheet-ii
Sheet: United States

 |  | 5 | Ishan | New Delhi | Hair Oil
5 | 2 | 9 | pike | moruya | shaving cream
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 0 | 0 | 0
9 | 6
Spreadsheet: 788861d1658768394-calculate-total-head-count-from-forecast-hours-sample-data-sheet
Sheet: Sheet1

Location | Month | Job Titile | Forecast Hours | Actual Hours | Total FTE | FT | PT | Casual | Total Employees
Location A | Jan | [NAME] | 165 | 172
Location A | Feb | [NAME] | 120 | 100
Location A | Mar | [NAME] | 100 | 80
Location A | Apr | [NAME] | 100 | 80
Location A | May | [NAME] | 300 | 320
Location A | Jun | [NAME] | 250 | 200
Location A | Jul | [NAME] | 200 | 180
Location A | Aug | [NAME] | 200 | 200
Location A | Sep | [NAME] | 250 | 225
Location A | Oct | [NAME] | 100 | 115
Location A | Nov | [NAME] | 100 | 100
Location A | Dec | [NAME] | 300 | 285
Location A | Jan | Driver | 200 | 180.5
Location A | Feb | Driver | 200 | 200
Location A | Mar | Driver | 250 | 180
Location A | Apr | Driver | 100 | 80
Location A | May | Driver | 300 | 310
Location A | Jun | Driver | 300 | 315
Location A | Jul | Driver | 300 | 300
Location A | Aug | Driver | 300 | 350
Location A | Sep | Driver | 300 | 320
Location A | Oct | Driver | 250 | 240
Location A | Nov | Driver | 250 | 235
Location A | Dec | Driver | 250 | 220.5
 |  |  |  | 180.5
Spreadsheet: 183884d1349085927-consectutive-numbers-0a1_fot_f1
Sheet: Φύλλο1

1992-03-07 00:00:00
1992-03-08 00:00:00
1992-03-09 00:00:00
1992-03-10 00:00:00 |  |  |  | It ranges between 33670 & 44853
1992-03-11 00:00:00
1992-03-12 00:00:00
1992-03-13 00:00:00
1992-06-26 00:00:00
1992-03-15 00:00:00
1992-03-16 00:00:00
1992-03-17 00:00:00
1992-03-18 00:00:00
1992-03-19 00:00:00
1992-03-20 00:00:00
2012-08-04 00:00:00
1992-03-22 00:00:00
1992-03-23 00:00:00
1992-03-24 00:00:00
1992-03-25 00:00:00
1992-03-26 00:00:00
2017-06-09 00:00:00
1992-03-28 00:00:00
1992-03-29 00:00:00
1992-03-30 00:00:00
1992-03-31 00:00:00
1992-04-01 00:00:00
1992-04-02 00:00:00
1992-04-03 00:00:00
1992-04-04 00:00:00
1992-04-05 00:00:00
Spreadsheet: kate_symes__18888__MeadMktplace (2)
Sheet: MeadMktplace

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME]
 | 2001-03-20 00:00:00 |  | 323.59 | 624 | 221.88 | 1600
 | 2001-03-19 00:00:00 |  | 291.72 | 1024 | 197.04 | 1272 | 197.2 | 635 | 225 | 20
 | 2001-03-18 00:00:00 |  | 220 | 0 | 182.5 | 0 | 149.33 | 1225 | 119.19 | 980
 | 2001-03-17 00:00:00 |  | 204.13 | 1008 | 134.76 | 2888 | 180.48 | 2250 | 127.55 | 570
 | 2001-03-16 00:00:00 |  | 204.13 | 1008 | 134.84 | 2864 | 209.71 | 1442 | 126.88 | 1046
 | 2001-03-15 00:00:00 |  | 180.74 | 2160 | 109.85 | 2184 | 189 | 2490 | 123.8 | 1881
 | 2001-03-14 00:00:00 |  | 163.59 | 1024 | 89.3 | 696 | 152.63 | 4365 | 107.38 | 1787
 | 2001-03-13 00:00:00 |  | 166.63 | 2064 | 81.94 | 1392 | 154.62 | 2586 | 118.47 | 1995
 | 2001-03-12 00:00:00 |  | 172.81 | 1424 | 102.15 | 1696 | 159.9 | 3783 | 116.27 | 2115
 | 2001-03-11 00:00:00 |  | 145 | 160 | 95 | 0 | 118.53 | 2962 | 105.52 | 2029
 | 2001-03-10 00:00:00 |  | 150.25 | 1024 | 85.52 | 1544 | 103.36 | 1254 | 105.49 | 1840
 | 2001-03-09 00:00:00 |  | 150.25 | 1024 | 85.52 | 1544 | 155.44 | 2180 | 106.38 | 1520
 | 2001-03-08 00:00:00 |  | 180 | 400 | 99 | 1000 | 173.53 | 731 | 126.23 | 1620
 | 2001-03-07 00:00:00 |  | 271.07 | 448 | 177.36 | 1664 | 205.39 | 1019 | 146.01 | 1746
 | 2001-03-06 00:00:00 |  | 302.29 | 944 | 166.83 | 1072 | 202.39 | 2764 | 134.22 | 1696
 | 2001-03-05 00:00:00 |  | 280 | 800 | 172.5 | 800 | 189.65 | 2226 | 131.16 | 1376
 | 2001-03-04 00:00:00 |  | 230 | 0 | 170 | 400 | 171.88 | 2765 | 131.78 | 1320
 | 2001-03-03 00:00:00 |  | 230.28 | 464 | 153.46 | 1040 | 170.84 | 1909 | 147.7 | 685
 | 2001-03-02 00:00:00 |  | 230.28 | 464 | 153.46 | 1040 | 204.08 | 1930 | 128.66 | 1229
 | 2001-03-01 00:00:00 |  | 267.19 | 512 | 141.82 | 880 | 233.33 | 777 | 144.63 | 726
 | 2001-02-28 00:00:00 |  | 170 | 320 | 112.22 | 1800 | 230.04 | 274 | 158.91 | 659
 | 2001-02-27 00:00:00 |  | 171 | 64 | 113.75 | 1600 | 176.51 | 603 | 108.24 | 1877
 | 2001-02-26 00:00:00 |  | 177.86 | 224 | 133.56 | 1392 | 157.54 | 2280 | 111.96 | 1798
 | 2001-02-25 00:00:00 |  | 147.5 | 0 | 135 | 280 | 131.22 | 2999 | 108.91 | 2383
 | 2001-02-24 00:00:00 |  | 174.29 | 224 | 115.26 | 1560 | 148.66 | 1535 | 132.09 | 1146
 | 2001-02-23 00:00:00 |  | 174.29 | 224 | 115.54 | 1480 | 166.64 | 2128 | 118.23 | 893
 | 2001-02-22 00:00:00 |  | 201.14 | 224 | 118.5 | 1312 | 160.02 | 656 | 90.98 | 787
 | 2001-02-21 00:00:00 |  | 210 | 224 | 148.86 | 560 | 161.32 | 1192 | 89.98 | 1296
 | 2001-02-20 00:00:00 |  | 232.14 | 224 | 137.14 | 112 | 130.89 | 1348 | 114.12 | 758
 | 2001-02-19 00:00:00 |  | 232.14 | 224 | 145 | 160 | 156.82 | 1839 | 154.53 | 1668
 | 2001-02-18 00:00:00 |  | 287.5 | 320 | 240.5 | 0 | 197.15 | 771 | 166.45 | 1129
Spreadsheet: 00a9e96e-ffe0-4448-8eea-81db14fe1dcf
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 |  | CONTRACT NO. | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 |  | ITEM NO.
 |  |  | PLAN QUANTITY =
 |  | DAILY |  |  |  |  | DAILY | MIX
 | AEB # | TOTAL | ACCUM. | AEB # | ACCUM. | PAYMENT | TOTAL | DESIGN
DATE | TOTAL | PLACED | TOTAL | PAY TOTAL | PAY TOTAL | NO. | DELIVERED | NO.
FINAL TOTAL
Spreadsheet: 101773d1299813190-draft-day-registration-help-team-draft
Sheet: Players

ID | Name | Rank | Requested Teammate
1 |  | 18
2 |  | 10
3 |  | 12
4 |  | 11
5 |  | 10
6 |  | 16 | 37
7 |  | 8
8 |  | 14 | 35
9 |  | 9
10 |  | 16 | 27
11 |  | 10 | 110
12 |  | 15
13 |  | 11 | 108
14 |  | 12
15 |  | 18
16 |  | 11
17 |  | 12
18 |  | 18
19 |  | 8
20 |  | 18
21 |  | 12
22 |  | 11
23 |  | 18
24 |  | 14
25 |  | 10
26 |  | 13
27 |  | 9
28 |  | 9
29 |  | 12
30 |  | 16
31 |  | 10
32 |  | 11
33 |  | 10 | 71
34 |  | 18
35 |  | 18
36 |  | 12
37 |  | 12
38 |  | 18
39 |  | 10
40 |  | 17
41 |  | 12 | 78
42 |  | 13
43 |  | 14 | 60
44 |  | 14
45 |  | 17
46 |  | 11
47 |  | 9 | 41
48 |  | 10
49 |  | 8
50 |  | 13 | 82
51 |  | 13
52 |  | 14
53 |  | 9
54 |  | 9
55 |  | 12
56 |  | 18
57 |  | 14
58 |  | 11
59 |  | 11
60 |  | 18 | 5
61 |  | 9
62 |  | 11
63 |  | 13
64 |  | 11
65 |  | 15
66 |  | 13
67 |  | 14
68 |  | 11
69 |  | 16
70 |  | 11
71 |  | 15 | 13
72 |  | 18
73 |  | 18
74 |  | 9
75 |  | 18 | 20
76 |  | 16
77 |  | 9
78 |  | 9
79 |  | 8 | 29
80 |  | 18
81 |  | 13
82 |  | 15
83 |  | 8 | 61
84 |  | 14 | 77
85 |  | 13
86 |  | 13
87 |  | 8
88 |  | 10
89 |  | 8
90 |  | 12 | 79
91 |  | 14 | 69
92 |  | 11 | 22
93 |  | 13
94 |  | 10
95 |  | 17
96 |  | 13 | 95
97 |  | 14
98 |  | 12
99 |  | 14
100 |  | 11
101 |  | 18
102 |  | 8 | 68
103 |  | 13
104 |  | 12
105 |  | 15
106 |  | 10
107 |  | 17
108 |  | 17 | 5
109 |  | 16 | 73
110 |  | 8
111 |  | 13
112 |  | 8
Spreadsheet: 773899d1648111135-combine-function-with-adress-range-test
Sheet: Sheet1

 |  |  |  |  | POINT | SPEC |  |  | RESULT1 | RESULT2 | RESULT3...
 |  |  |  |  | 1 |  | 3.0 CAR |  | 1.1 | 1.6
 |  |  |  |  | 2 |  | 3.0 CAR |  | 1.5 | 1.4
 |  |  |  |  | 3 |  | 3.5 CAR |  | 2.5 | 1.3
 |  |  |  |  | 4 |  | 3.5 CAR |  | 2.1 | 2.2
 |  |  |  |  | 5 |  | 3.0 CAR |  | 1.5 | 1.3
 |  |  |  |  | 6 |  | 4.0 CAR |  | 1.2 | 1.6
 |  |  | FROM | UNTIL | 7 |  | 3.0 CAR |  | 2.5 | 1.3
 |  |  | 4 | 10
Spreadsheet: 582555d1531936415-formulas-work-separately-but-not-combined-test2
Sheet: REF

REF
"INT | Direction | Substrate | CSV Edge | CSV Edge Code | V Edge Code | V>H EDGE | Top | Code | Dim | Right | Code2 | Dim3 | Bottom | Code4 | Dim5 | Left | Code6 | Dim7 | N | H ALUM | V ALUM | H ZINC | V ZINC | H-A LVLZ 2 | H-A LVLZ 25 | H-A LVLZ 3 | H-A LVLZ 35 | H-A LVLZ 4 | V-A LVLZ 2 | V-A LVLZ 25 | V-A LVLZ 3 | V-A LVLZ 35 | V-A LVLZ 4 | Prog? | Panel Type | Panel Depth | [NAME] | P4 File | V>H P4 File | BA∠1W-X Axis | BA∠2X-X Axis | BA∠3W-Z Axis | BA∠4X-Z Axis | Face X | Face Z | Taper | TDepth | RDepth | BDepth | LDepth | TR∠ | RB∠ | BL∠ | RL∠ | RB dim | RB inches
"INT_ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IF(B2="H",(COUNTIF('EDGES & BEND ALLOWANCE'!$Y$2:$Y$319,E2)>0)
\
_Z |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Y | CHECK H |  |  | 1
.P4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AE | CHECK V |  |  | 2
// |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Z | CHECK H_2 |  |  | 3
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | '=IF(CSV!AK3="E1",1.25) |  |  |  |  |  |  | AA | CHECK H_25 |  |  | 4
FaceZ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =IF(CSV!AK3="V1","VAR") |  |  |  |  |  |  | AB | CHECK H_3 |  |  | 5
" |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =IF(CSV!AK3="L1","VAR") |  |  |  |  |  |  | AC | CHECK H_35 |  |  | 6
_4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AD | CHECK H_4 |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AF | CHECK HZ |  |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AG | CHECK VZ |  |  | 9
Spreadsheet: 676768d1588959759-lookup-groupmembers-and-sum-a-groups-amount-group-count
Sheet: Blad1

 |  | type | worth |  |  |  | results to be
 |  | abc10-djfsd | 30 |  |  | Group | abc10 | 70
 |  | [NAME] | 40 |  |  | Group | adc10 | 90
 |  | adc10-ddsg42t56 | 40 |  |  | Group | wet20 | 80
 |  | adc10-flgro02wr543 | 50 |  |  | Group | gre20 | 100
 |  | wet20-34mvkfgkrt4 | 20 |  |  | Group | abc30, abc31 | 50
 |  | wet20-dlfk0934 | 60 |  |  | Group | dam30, dam31 | 30
 |  | gre20-fsdgtgtdr65 | 40
 |  | [NAME] | 60 |  |  | For example:
 |  | abc30-ksfgksg043 | 20 |  |  | All rows in"C" with [NAME]…. Should be accumulated to a sum
 |  | abc31-jsdfgksder | 30
 |  | dam30-djkdf93f39f | 10
 |  | dam31-fdsksd9034 | 20
This table can be up to 100 rows as [NAME]
with a great mix in product codes
but can be defined in groups.
I want to see a list how much in each group
Spreadsheet: 81937d1282050923-data-validation-list-length-list-example
Sheet: Sheet1

List |  |  | <-Dropdown
A
b
c
d
e
f
g
h
i
j
k
List
m
n
o
p
q
r
s
t
u
v