tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 275558d1383574324-equation-that-depends-on-table-not-sure-how-to-explain-this-in-a-title-sample
Sheet: Raw data

P85 | Dura-Kote Clear | Exterior | 600BF8 | 1.250637 | 600RY | 1.200393 | 600WW | 1.691331 | 600YO | 1.602317
P86 | Dura-Kote Clear | Exterior | 600ER | 1.339276 | 600NO8 | 0.400826 | 600WW | 1.890824 | 600YO | 2.113754
P87 | Dura-Kote Clear | Exterior | 600BF8 | 0.856441 | 600ER | 1.490866 | 600NO8 | 0.040387 | 600WW | 1.825148 | 600YO | 1.531839
P88 | Dura-Kote Clear | Exterior | 600BF8 | 0.668409 | 600RY | 0.459485 | 600WW | 3.723342 | 600YO | 0.893443
[NAME] | Dura-Kote Clear | Exterior | 600BF8 | 0.609822 | 600RO8 | 0.417818 | 600WW | 3.584745 | 600YO | 1.132289
P9 | Dura-Kote Clear | Exterior | 600LM8 | 3.590716 | 600NO8 | 0.019974 | 600WW | 3.971563 | 600YO | 2.417747
P90 | Dura-Kote Clear | Exterior | 600BF8 | 1.699315 | 600RY | 0.562276 | 600WW | 1.803345 | 600YO | 1.679738
P91 | Dura-Kote Clear | Exterior | 600ER | 0.208821 | 600NO8 | 0.576478 | 600WW | 1.856872 | 600YO | 3.102509
P92 | Dura-Kote Clear | Exterior | 600BF8 | 0.45 | 600ER | 0.32 | 600WW | 3.42 | 600YO | 1.55
P93 | Dura-Kote Clear | Exterior | 600BF8 | 0.518296 | 600RY | 0.150374 | 600WW | 3.961619 | 600YO | 1.114391
P94 | Dura-Kote Clear | Exterior | 600ER | 0.433488 | 600NO8 | 0.282409 | 600WW | 3.762551 | 600YO | 1.266231
P95 | Dura-Kote Clear | Exterior | 600NO8 | 0.061139 | 600RY | 0.209278 | 600WW | 5.155136 | 600YO | 1.609761
P96 | Dura-Kote Clear | Exterior | 600ER | 0.055878 | 600NO8 | 0.026207 | 600RY | 0.083645 | 600WW | 4.981218 | 600YO | 0.597733
P97 | Dura-Kote White | Exterior | 600BF8 | 0.296899 | 600NO8 | 0.99404 | 600RY | 0.793965 | 600YO | 1.915097
P98 | Dura-Kote Clear | Exterior | 600ER | 0.360956 | 600NO8 | 0.501926 | 600WW | 4.419353 | 600YO | 0.462439
P99 | Dura-Kote Clear | Exterior | 600NO8 | 0.218182 | 600RO8 | 0.15836 | 600WW | 4.531842 | 600YO | 0.836296
 |  |  | BF8 | 1.9
 |  |  | NO8 | 1.955
 |  |  | RO8 | 2.15
 |  |  | LM8 | 1.82
 |  |  | ER | 1.25
 |  |  | RY | 1.9
 |  |  | YO | 1.79
 |  |  | WW | 2.045
Spreadsheet: lisa_gang__22494__Hanson Scheduling Model_6_23_24
Sheet: Scheduling

 |  |  |  |  | HANSON PERMANENTE CEMENT
 |  |  |  |  |  | Power Usage Forecast
 | CALIFORNIA SCHEDULING COORDINATION AND
 | ENERGY PURCHASES AND SALES AGREEMENT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monday: Tuesday Scheduling
 | Day of Scheduling |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tuesday: Wednesday Scheduling
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wednesday: Thursday Scheduling
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Thursday: Friday & Saturday Scheduling
 | 2002-06-23 00:00:00 | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | Total |  |  |  |  |  |  |  |  | Friday: Sunday and Monday LLH Scheduling
 | 2002-06-24 00:00:00 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 |  |  |  |  |  |  |  |  |  | Friday: Monday HLH
 |  | 29.94 | 29.928 | 29.868 | 26.376 | 25.272 | 25.26 | 24.924 | 24.828 | 24.612 | 24.552 | 24.576 | 25.332 | 29.16 | 29.472 | 29.472 | 29.568 | 29.58 | 29.604 | 29.652 | 29.94 | 30.66 | 30.816 | 30.804 | 30.876 |  |  |  |  |  |  |  |  |  | Holiday
 |  | 30.924 | 31.02 | 31.056 | 30.984 | 31.176 | 31.392 | 31.848 | 31.98 | 32.016 | 32.172 | 32.04 | 29.1 | 27.084 | 26.832 | 26.76 | 26.928 | 26.916 | 29.712 | 31.056 | 30.924 | 31.02 | 31.248 | 31.524 | 31.392
 |  | 25.965 | 25.965 | 25.965 | 25.965 | 25.965 | 25.965 | 26.165 | 26.165 | 26.165 | 26.165 | 26.165 | 26.165 | 26.165 | 26.165 | 26.165 | 26.165 | 26.165 | 26.165 | 26.74 | 26.74 | 26.74 | 26.74 | 27.62 | 27.62
 |  | 28.72 | 28.72 | 28.72 | 28.72 | 29.47 | 29.47 | 29.67 | 29.67 | 29.67 | 29.67 | 29.67 | 29.67 | 24.045 | 24.045 | 24.795 | 23.915 | 23.915 | 23.915 | 28.59 | 28.59 | 29.47 | 29.47 | 28.72 | 28.72
 | Day Ahead Incremental Quantity (Hanson needs to purchase)
 | Day Ahead Decremental Quantity (Hanson needs to sell)
 | Contact Persons
 | EPMI | Telephone |  |  | E-Mail
 | [NAME] | 503/464-3829 |  |  | [EMAIL]
 | [NAME] | 503/464-5053 |  |  | [EMAIL]
 | [NAME] | 503/464-3822 |  |  | [EMAIL]
 | [NAME] | 503/464-3824 |  |  | [EMAIL]
 | [NAME] | [PHONE] |  |  | [EMAIL]
 | Hanson | Telephone |  |  | E-Mail
 | [NAME] Manager | [PHONE] |  |  | [EMAIL]
 | [NAME] Engineer | [PHONE] |  |  | [EMAIL]
 | [NAME]  - VP Operations | [PHONE] |  |  | [EMAIL]
 | [NAME] | [PHONE] |  |  | [EMAIL]
Spreadsheet: 135574d1326129727-conditional-formatting-conditional-formatting
Sheet: Sheet1

Level | Number | Day | Dates | Site | Visitor | Time | Phone
JV | 422204 | Tue | 2012-01-10 00:00:00 | Hicksville | East Meadow | 18:45:00 | 555-5555
JV | 422092 | Thur | 2012-01-12 00:00:00 | Friends | Locust Valley | 17:30:00 | 555-5555
JV | 422824 | Tue | 2012-01-17 00:00:00 | Plainedge | Hewlett | 17:30:00 | 555-5555
JV | 425680 | Thur | 2012-01-19 00:00:00 | Farmingdale | Syosset | 16:00:00 | 555-5555
JV | 422217 | Fri | 2012-01-20 00:00:00 | Hicksville | Plainview | 18:30:00 | 555-5555
JV | 422220 | Fri | 2012-01-27 00:00:00 | Plainview | MacArthur | 18:30:00 | 555-5555
JV | 422666 | Tue | 2012-01-31 00:00:00 | [NAME] | Freeport | 16:15:00 | 555-5555
JV | 422342 | Fri | 2012-02-03 00:00:00 | [NAME] | Long Beach | 16:30:00 | 555-5555
JV | 422584 | Tue | 2012-02-07 00:00:00 | Seaford | North Shore | 17:15:00 | 555-5555
JHB | 426206 | Thur | 2012-02-09 00:00:00 | Wantagh | Plainview 7 | 16:30:00 | 555-5555
JV | 422121 | Fri | 2012-02-10 00:00:00 | CSH | Wheatley | 17:00:00 | 555-5555
JV | 422240 | Mon | 2012-02-13 00:00:00 | Hicksville | MacArthur | 18:15:00 | 555-5555
JHB | 425812 | Thur | 2012-02-16 00:00:00 | Southwoods | Garden City 7 | 16:30:00 | 555-5555
JHB | 425736 | Fri | 2012-03-02 00:00:00 | Hicksville | Seaford 8 | 16:15:00 | 555-5555
JHB | 425740 | Mon | 2012-03-05 00:00:00 | Plainedge | [NAME] | 16:30:00 | 555-5555
JHB | 425823 | Tue | 2012-03-06 00:00:00 | CSH | Weber 7 | 16:30:00 | 555-5555
Spreadsheet: 878133d1725108842-formula-for-intersection-of-rows-and-columns-extend-excel-8-365-wip-aligw
Sheet: Sheet1

Modules(columns) | T/F |  |  |  |  | Modules(columns) | Analytics | Systems Analyst | Business Analyst | Development | Product Manager | Department Manager | Team Leader
d3 | FALSE |  |  |  |  | d3 | 1 | 2 | 3 | 4 | 5 | 6 | 7
Administration | FALSE |  |  |  |  | Administration | 1 | 2 | 3 | 4 | 5 | 6 | 7
Obstetrics | FALSE |  |  | 15.5 |  | Obstetrics | 1 | 2 | 3 | 4 | 5 | 6 | 7
Pharmacy | FALSE |  | Systems Analyst | 30.5 |  | Pharmacy | 1 | 2 | 3 | 4 | 5 | 6 | 7
BARS - Healthcare Monitoring | TRUE |  |  |  |  | BARS - Healthcare Monitoring | 1 | 2 | 3 | 4 | 5 | 6 | 7
BARS.STAR | TRUE |  |  |  |  | BARS.STAR | 1 | 2 | 3 | 4 | 5 | 6 | 7
Vaccination | TRUE |  |  |  |  | Vaccination | 1 | 2 | 3 | 4 | 5 | 6 | 7
VIMIS RF AKiNEO | TRUE |  |  |  |  | VIMIS RF AKiNEO | 1 | 2 | 3 | 4 | 5 | 6 | 7
VIMIS RF Oncology | TRUE |  |  |  |  | VIMIS RF Oncology | 1 | 2 | 3 | 4 | 5 | 6 | 7
VIMIS RF Prevention | FALSE |  |  |  |  | VIMIS RF Prevention | 1 | 2 | 3 | 4 | 5 | 6 | 7
VIMIS RF CVD | FALSE |  |  |  |  | VIMIS RF CVD | 1 | 2 | 3 | 4 | 5 | 6 | 7
HMP | FALSE |  |  |  |  | HMP | 1 | 2 | 3 | 4 | 5 | 6 | 7
Outside ARM | FALSE |  |  |  |  | Outside ARM | 1 | 2 | 3 | 4 | 5 | 6 | 7
Military registration | FALSE |  |  | Hard-50% |  | Military registration | 1 | 2 | 3 | 4 | 5 | 6 | 7
Hospital physician | FALSE |  |  |  |  | Hospital physician | 1 | 2 | 3 | 4 | 5 | 6 | 7
Diagnostics | FALSE |  | Positions |  |  | Diagnostics | 1 | 2 | 3 | 4 | 5 | 6 | 7
Dispensary registration | FALSE |  | Analytics | TRUE |  | Dispensary registration | 1 | 2 | 3 | 4 | 5 | 6 | 7
Remote monitoring | FALSE |  | Systems Analyst | TRUE |  | Remote monitoring | 1 | 2 | 3 | 4 | 5 | 6 | 7
Health diary | FALSE |  | Business Analyst | FALSE |  | Health diary | 1 | 2 | 3 | 4 | 5 | 6 | 7
Unified registry | FALSE |  | Development | FALSE |  | Unified registry | 1 | 2 | 3 | 4 | 5 | 6 | 7
User information support | FALSE |  | Product Manager | FALSE |  | User information support | 1 | 2 | 3 | 4 | 5 | 6 | 7
IPRA | FALSE |  | Department Manager | FALSE |  | IPRA | 1 | 2 | 3 | 4 | 5 | 6 | 7
IEMC | FALSE |  | Team Leader | FALSE |  | IEMC | 1 | 2 | 3 | 4 | 5 | 6 | 7
Call center | FALSE |  |  |  |  | Call center | 1 | 2 | 3 | 4 | 5 | 6 | 7
Spreadsheet: 871051d1717501638-adding-data-from-other-sheets-to-final-points-table-euro-2024-master-sheet
Sheet: Sheet2

Br. |  | Player |  | POINTS MADE
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
Spreadsheet: 01d93c69-5e6c-4dbc-becd-f9d3219ac6f9
Sheet: tillage graph

OBS | ACRES | AGE | EDUC | COUNTY
1 | 190 | 50 | 14 | [NAME]
2 | 135 | 59 | 14 | Haynes
3 | 275 | 39 | 16 | Haynes
4 | 185 | 49 | 14 | Haynes
5 | 340 | 39 | 12 | [NAME]
6 | 575 | 32 | 16 | Haynes
7 | 210 | 51 | 14 | [NAME]
8 | 95 | 55 | 8 | Haynes
9 | 55 | 67 | 8 | [NAME]
10 | 210 | 28 | 12 | Haynes
11 | 280 | 35 | 14 | Haynes
12 | 0 | 68 | 8 | [NAME]
13 | 120 | 55 | 12 | Haynes
14 | 80 | 59 | 12 | [NAME]
15 | 600 | 30 | 18 | [NAME]
16 | 415 | 29 | 18 | Haynes
17 | 0 | 62 | 8 | Haynes
18 | 395 | 27 | 16 | Haynes
19 | 480 | 31 | 16 | [NAME]
20 | 180 | 52 | 12 | [NAME]
21 | 60 | 63 | 6 | Haynes
22 | 0 | 61 | 12 | Haynes
23 | 108 | 61 | 12 | Haynes
24 | 225 | 46 | 12 | [NAME]
25 | 295 | 37 | 16 | [NAME]
Spreadsheet: 493228d1481612968-auto-update-problem-question
Sheet: Main FIle

Main Table
Sr. No. | Emp.Code No. | Name | F/H_Name | Designation | Rs. | dob
1 | 136790 | Ram |  | XEN.(E) | 100 | 1986-01-01 00:00:00 | working
2 | 155784 | [NAME] |  | A.E.E | 100 | 1986-12-31 00:00:00 | non working
3 | 369788 | Krishan |  | XEN.(E) | 50
4 | 982785 | Kanhiya |  | A.E.E | 100 | 1989-02-10 00:00:00 | working
5 | 124586 | Seeta |  | XEN.(E) | 100
6 | 125893 | Geeta |  | XEN.(E) | 100 | 1952-06-06 00:00:00 | vrs
7 | 111111 | Ajay |  | XEN.(E) | 100 | 1947-07-08 00:00:00 | non working
8 | 222222 | Vijay |  | XEN.(E) | 70
Answer Table
3 | 369788 |  |  |  |  | 1990-10-10 00:00:00 | working
5 | 124586 |  |  |  |  | 1962-05-16 00:00:00 | non working
7 | 111111 |  |  |  |  | 1947-07-08 00:00:00 | non working
8 | 222222 |  |  |  |  | 2000-10-29 00:00:00 | working
Actually I used vlookup on column A to F for display the values |  |  |  |  |  | I manually feed dob in g15, g16 and g18 (g17 actually already feeded in Main Table, formula did not do anything if value found in main table) and I want these three DOB automatically fill up in Main Table
Spreadsheet: 121158d1315886814-live-report-summation-excel
Sheet: Sheet1

Subteam | Team | Activity | Priority | Status | 2011-08-29 00:00:00 | 2011-09-05 00:00:00 | 2011-09-12 00:00:00 | 2011-09-19 00:00:00 | 2011-09-26 00:00:00 | 2011-10-03 00:00:00 | 2011-10-10 00:00:00 | 2011-10-17 00:00:00 | 2011-10-24 00:00:00 | SME1 | Effort | SME2 | Effort | SME3
FIN-AA | TOTAL | TOTAL |  |  |  |  |  |  |  |  |  |  |  |  | 32 |  | 70
FIN-AA | Conversion | TC2 Data Reconciliation Review | P1 | Not Started |  |  |  |  |  |  |  |  |  | PS | 4 | ADG | 1
FIN-AA | Conversion | Conversion FD review | P1 | Not Started |  |  | X |  |  |  |  |  |  | PS | 2 | ADG
FIN-AA | Conversion | TC2 Conversion Defect Resolution | P1 | Not Started | X | X | X |  |  |  |  |  |  | PS | 2 | ADG | 6
FIN-AA | Conversion | TC3 Data Mapping (High priority) | P1 | Not Started |  |  |  | X |  |  |  |  |  | PS | 1 | ADG
FIN-AA | Functional | Design Gaps | P1 | Started |  |  | X |  |  |  |  |  |  | PS | 2 | MCG | 10
FIN-AA | Functional | Complete change requests | P1 | Closed |  |  |  |  |  |  |  |  |  | PS |  | ADG | 5
FIN-AA | Legacy | Assembly Testing | P1 | Closed |  |  |  |  |  |  |  |  |  | PS |  | ADG | 4
FIN-AA | Legacy | Cutover Plan per Interface | P1 | Not Started |  |  |  |  |  |  |  |  |  | NPP | 1 | ADG | 5
FIN-AA | Test | Defect Resolution | P1 | WIP |  | X | X |  |  |  |  |  |  | NPP | 3 | ADG | 9
FIN-AA | Test | SIT Test Preparation | P2 | WIP | X | X | X |  |  |  |  | X |  | SKS | 5 | MCG | 6
FIN-AA | Deploy | Cutover Plan Preparation | P2 | Not Started |  | X | X | X | X | X | X |  |  | SKS | 1 | ADG
FIN-AA | Change | [NAME] detailed review | P2 | Not Started |  | X | X | X |  |  |  |  |  | SKS | 3 | MCG
FIN-AA | Change | Training Course Review | P2 | WIP | X | X | X | X | X | X | X | X |  | SKS | 2 | MCG | 7
FIN-AA | Change | Data Preparation | P2 | Not Started |  | X |  |  |  |  |  |  |  | SKS | 1 | MCG | 8
FIN-AA | Conversion | TC3 support and reconciliation | P2 | Not Started |  |  |  |  |  |  |  | X |  | SKS | 4 | MCG
FIN-AA | Deploy | Cutover Process documentation | P2 | Not Started |  |  |  |  |  |  |  |  |  | NPP |  | ADG
FIN-AA | Tech | Performance Test inputs | P2 | WIP |  |  |  | X | X | X |  |  |  | NPP | 1 | ADG | 9
 |  |  | SME | Effort   days
 |  |  | PS | 11
 |  |  | ADG | 39
 |  |  | NPP | 5
 |  |  | SKS | 16
 |  |  | MCG | 31
Spreadsheet: 841532d1693722722-need-help-with-resource-forecasting-formula-resource-plan-draft_v2-aligw
Sheet: Resource Heatmap

Resource Bandwidth/Heatmap
 |  | Day of the selected Month
Resource Name | September 2023 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
Person 1
Person 2
Person 3
Person 4
Person 5
Person 6
Person 7
Person 8
Person 9
Person 10
Spreadsheet: 742708d1627984241-if-formula-not-returning-correct-results-patcheen-if-statement-aligw
Sheet: Sheet1

 | worker 1 |  | 50
 | worker 2 |  |  |  | 100
Spreadsheet: 105778d1303064616-sorting-columns-from-many-tables-within-one-worksheet-randomjockeys
Sheet: Sheet1

 | Jockeys |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] In Order | Y MINUS D
1 | JF
2 | JS
3 | [NAME] |  | Rating | Earnings |  |  |  |  |  |  |  |  |  | Lbs | [NAME] | LBW | Previous Owner | New Owner | Claims
4 | PO |  | 1 | 3 | Sleeping | G2 3F | 103 | 49.76 | 9 | 4 | 1 | 3 | 1 | 2 | 1 | 0 | 1 | 108 |  | 0 | Shore Stables | 0 |  | 2
5 | HN |  | 2 | 4 | Kev's Lad | G2 3M | 100 | 19.8 | 10 | 4 | 2 | 5 | 4 | 0 | 0 | 0 | 0 | 120 |  | 0.4 | Batey's | 0 |  | 1
6 | MH |  | 3 | 1 | Black Western | G2 3M | 101 | 50.67 | 17 | 7 | 2 | 1 | 1 | 0 | 1 | 1 | 0 | 120 |  | 0.85 | Buddha Farms | 0 |  | 4
7 | MC |  | 4 | 2 | Witbier | G2 3M | 101 | 58.78 | 25 | 11 | 2 | 4 | 3 | 1 | 1 | 1 | 0 | 120 |  | 1.8 | Beer Baron Racing | 0 |  | 3
8 | AT
9 | KA
10 | LW |  | Rating | Earnings |  |  |  |  |  |  |  |  |  | Lbs | [NAME] | LBW | Previous Owner | New Owner | Claims
11 | AM |  | 1 | 8 | Oh So Close | G2 3M | 100 | 34.81 | 4 | 3 | 0 | 9 | 3 | 2 | 0 | 0 | 0 | 120 | JF | 0 | H007 | 0 |  | 1
12 | YC |  | 2 | 5 | Arctic Ace | G2 3F | 100 | 70.07 | 21 | 7 | 3 | 2 | 1 | 1 | 0 | 0 | 0 | 108 | AM | 0.48 | [NAME] | 0 |  | 5
13 | BA |  | 3 | 7 | Red Hollow | G2 3F | 100 | 34.16 | 4 | 1 | 0 | 14 | 5 | 5 | 0 | 0 | 0 | 108 | MH | 0.84 | [NAME] | 0 |  | 3
14 | KB |  | 4 | 3 | Smooth Victory | G2 3M | 100 | 34.7 | 9 | 3 | 0 | 18 | 8 | 3 | 0 | 0 | 0 | 120 | RP | 1.4 | [NAME] | 0 |  | 6
15 | TR |  | 5 | 10 | Itstoofar | G2 3M | 100 | 32.47 | 8 | 1 | 2 | 10 | 4 | 1 | 0 | 0 | 0 | 120 | LW | 1.76 | [NAME] | 0 |  | 4
16 | RP |  | 6 | 9 | Holy Horse | G2 3M | 100 | 31.91 | 9 | 3 | 2 | 11 | 5 | 1 | 0 | 0 | 0 | 120 | JS | 2.28 | Sin City Stables | 0 |  | 2
17 | TK |  | 7 | 6 | Spectacular Blast | G2 3M | 100 | 13.55 | 2 | 0 | 1 | 9 | 2 | 1 | 0 | 0 | 0 | 120 | LF | 2.6 | [NAME]'s Pack | 0 |  | 10
18 | KR |  | 8 | 2 | Apeckalypse Now | G2 3M | 100 | 35.23 | 13 | 8 | 1 | 4 | 3 | 0 | 0 | 0 | 0 | 120 | TK | 3.08 | [NAME]'s Pack | 0 |  | 7
19 | ZH |  | 9 | 4 | [NAME] | G2 3F | 100 | 34.84 | 18 | 12 | 1 | 5 | 2 | 1 | 0 | 0 | 0 | 108 | EM | 3.4 | DOC MDTERPS | 0 |  | 9
20 | LT |  | 10 | 1 | Fore More | G2 3M | 100 | 5.01 | 2 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 120 | JP | 3.92 | Robslobs | 0 |  | 8
21 | GB
22 | ND
23 | ZA
24 | JP
25 | SB
26 | TL
27 | EM
28 | HB
29 | AL
30 | ML
31 | TJ
32 | CS
33 | YM
34 | LF
Spreadsheet: 877621d1724420520-sum-lookup-result-ekac-sum-3-365-aligw
Sheet: Sheet1

 |  |  |  | Data |  |  |  |  |  |  | Match & Sum
 |  |  |  |  |  |  |  |  |  |  |  | Result
 |  |  |  | #100 | 3803238.44 |  |  |  |  |  |  | 14970982.96
 |  |  |  | #104 | 3803238.45 |  |  |  |  |  | #079/#078 | 13156806.53
 |  |  |  | #096 | 3764034.35 |  |  |  |  |  | #096/#097 | 7528068.71
 |  |  |  | #097 | 3764034.36 |  |  |  |  |  | #100/#104 | 7606476.890000001
 |  |  |  | #079 | 4385602.18 |  |  |  |  |  | #128/#126 | 9058314.49
 |  |  |  | #148 | 4432140.23 |  |  |  |  |  | #148/#149 | 8864799.25
 |  |  |  | #149 | 4432659.02
 |  |  |  | #128 | 4529157.24
 |  |  |  | #126 | 4529157.25
 |  |  |  | #078 | 8771204.35
 |  |  |  | #010 | 14970982.96
Spreadsheet: 104515d1302103028-excel-help-trying-to-make-a-football-team-picker-football-team-picker
Sheet: Sheet1

Playing | Name | Skill Level | Position | Random |  |  |  | Team One |  | vs | Team Two
Yes | [NAME] | 5 | Out | 0.8059639589164229 |  |  |  | Player | Skill |  | Player | Skill
Yes | [NAME] | 6 | Out | 0.3248881475358765 |  |  |  | [NAME] | 5 |  | [NAME] | 6
Yes | [NAME] | 5 | Out | 0.3516169669835932 |  |  |  | [NAME] | 6 |  | [NAME] | 6
Yes | [NAME] | 6 | Out | 0.334118834491133 |  |  |  | [NAME] | 5 |  | [NAME] | 10
Yes | [NAME] | 8 | Out | 0.423093719893728 |  |  |  | [NAME] | 6 |  | [NAME] | 7
Yes | [NAME] cutting | 2 | Out | 0.3449647782808032 |  |  |  | [NAME] | 8 |  | Oiliver Snoad | 5
Yes | [NAME] ([NAME]'s Mate) | 6 | Out | 0.1811022322982949 |  |  |  | [NAME] cutting | 2 |  | [NAME] | 6
Yes | [NAME] | 6 | Out | 0.07797625764659277 |  |  |  | [NAME] ([NAME]'s Mate) | 6
Yes | [NAME] | 6 | Out | 0.02907346212590012
Yes | [NAME] | 10 | Out | 0.5321796701352632 |  |  |  | Total Score | 38 |  | Total Score | 40
Yes | [NAME] | 7 | Out | 0.531433643391498
Yes | Oiliver Snoad | 5 | Out | 0.1944698045867186
Yes | [NAME] | 6 | Out | 0.6233004678404149 |  | Put a Yes next to Players who will play this game
 | [NAME] | 10 | Out | 0.3044587592593598 |  | Then Click the Button "New Rand Teams" to randomly pick teams
 | [NAME] (Gamestation) | 5 | Out | 0.7027906425634874 |  | Read the team score at the bottom of the random picks
 | [NAME] | 10 | Goalie | 0.4125204010254305 |  | Click the button until you like the Totals or pairings.
 | [NAME] | 5 | Out | 0.9621881363520444
 | [NAME] | 7 | Goalie | 0.6210968347159278 |  | The way this works is:
 | [NAME] | 5 | Out | 0.5278190676235607 |  | I recorded a macro to sort the A-D by Playing and then Random
 | Justin Munday | 5 | Out | 0.5410700142311753 |  | After sorting the Team formulas simply pick off players
 | [NAME] | 10 | Out | 0.9385020950078343 |  | Easy Peasy!
 | [NAME] | 5 | Out | 0.7476605728891801
13 | Players
78 | Total Points
39 | Points Per Team
Spreadsheet: 698371d1601961993-index-formula-for-a-calibration-record-index-formula-for-a-calibration-record-sample-2-
Sheet: EF

 |  |  |  | Date:
 |  |  | Information
Equipment Number |  |  |  | EN 002
Description
Location
Manufacturer and Model
Serial Number
Calibration and/or [NAME]
Date Calibration and/or Maintenance Completed
Calibration and/or Maintenance Due Date
Notes
 |  |  | Calibration and/or Maintenance Requirements
Spreadsheet: 140041d1328607381-excel-vlookup-with-max-statement-into-another-table-test
Sheet: User Max Amount

Original Table with Multiple amounts per user |  |  |  |  | New Table
User | PRODUCT_ID | ACTIVITY_AMOUNT |  |  | User | PRODUCT_ID | Activity Amount
A | 195597 | 1.99 |  |  | A | 277074 | 155.66 |  | The maximum amount from A is inserted and the proudct ID that was purchased as well.
A | 704627 | 15 |  |  | B
A | 158876 | 19.99 |  |  | C
A | 308304 | 1 |  |  | D
A | 292412 | 5 |  |  | E
A | 277074 | 155.66 |  |  | F
B | 919993 | 22.99 |  |  | G
B | 283007 | 299.99 |  |  | H
C | 252213 | 2
C | 216627 | 117.72
D | 226964 | 1299.99
D | 243480 | 237.66
E | 261730 | 14.99
E | 277462 | 149.99
E | 159775 | 79.99
F | 273438 | 49.99
F | 264205 | 99.99
G | 970673 | 99.9
G | 295175 | 99.99
H | 239082 | 49.99
H | 273594 | 59.99
H | 229240 | 16.49
Spreadsheet: 700547d1603225231-unique-alphabetical-order-order-1-
Sheet: Foglio1

ID | Stato | Anno | YES | 2020
Fami.4 |  | 2020
Fami.2 |  | 2020
Fami.3 | YES | 2019
Fami.7 | YES | 2020
Fami.1 | YES | 2020
Fami.10 | YES | 2020
Spreadsheet: 524432d1498087909-need-execel-to-do-math-and-spit-out-data-working
Sheet: Table 1

ZIP | CRRT | Rate Category | Total Walk Seq. | Total Residential | Total Possible | %
92543 | C006 | WS | 366 | 366 |  | 1
92543 | C012 | WS | 1262 | 1262 |  | 1
92543 | C015 | WS | 909 | 909 |  | 1
92543 | C016 | WS | 785 | 785 |  | 1
92543 | C019 | WS | 998 | 998 |  | 1
92543 | C025 | WS | 721 | 721 |  | 1
92543 | C027 | WS | 860 | 860 |  | 1
92543 | C033 | WS | 1029 | 1029 |  | 1
92543 | C035 | WS | 838 | 838 |  | 1
92543 | C046 | WS | 421 | 421 |  | 1
92543 | C047 | WS | 968 | 968 |  | 1
92543 | C048 | WS | 626 | 626 |  | 1
92543 | C052 | WS | 1075 | 1075 |  | 1
92543 | C084 | WS | 413 | 413 |  | 1
92545 | C017 | WS | 1104 | 1104 |  | 1
92545 | C029 | WS | 752 | 752 |  | 1
92545 | C037 | WS | 1055 | 1055 |  | 1
92545 | C042 | WS | 704 | 704 |  | 1
92545 | C053 | WS | 772 | 772 |  | 1
92545 | C056 | WS | 379 | 379 |  | 1
92545 | C059 | WS | 887 | 887 |  | 1
92545 | C071 | WS | 793 | 793 |  | 1
92545 | C072 | WS | 875 | 875 |  | 1
92545 | C079 | WS | 940 | 940 |  | 1
92545 | C080 | WS | 1150 | 1150 |  | 1
92545 | C083 | WS | 797 | 797 |  | 1
92545 | R002 | WS | 836 | 836 |  | 1
92545 | R004 | WS | 777 | 777 |  | 1
92545 | R005 | WS | 728 | 728 |  | 1
92545 | R006 | WS | 908 | 908 |  | 1
92545 | R008 | WS | 884 | 884 |  | 1
92545 | R009 | WS | 794 | 794 |  | 1
92545 | R010 | WS | 874 | 874 |  | 1
92582 | C006 | WS | 1132 | 1132 |  | 1
92582 | C007 | WS | 1225 | 1225 |  | 1
92582 | C017 | WS | 1157 | 1157 |  | 1
Spreadsheet: 298370d1392771287-index-and-match-formula-monthsie-totals
Sheet: C

Sr | Category | Description | Pack size | Unit | January | February | March | April | May | June | July | August | September | October | November | December | Total
1 |  | Delico | 0.4 | [NAME] | 0 | 200 | 1300 | 2000 | 0 | 0 | 0 | 3200 | 2800 | 0 | 0 | 0
2 |  | Parco | 10 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
3 |  | Doce | 0.25 | [NAME] | 0 | 0 | 500 | 500 | 0 | 0 | 0 | 8200 | 13000 | 0 | 0 | 0
4 |  | Fast | 0.35 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
5 |  | Sider | 1 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 500 | 500 | 0
6 |  | Glaxo | 10 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
7 |  | Sweets | 0.25 | [NAME] | 0 | 0 | 500 | 0 | 0 | 0 | 0 | 0 | 0 | 1500 | 500 | 0
8 |  | Parden | 0.5 | [NAME] | 200 | 0 | 100 | 200 | 0 | 0 | 0 | 0 | 0 | 300 | 0 | 0
9 |  | Romeo | 0.25 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
10 |  | Clutch | 1 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1000 | 0 | 0
11 |  | [NAME] | 10 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
12 |  | Rifit | 0.5 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1700 | 1600 | 300 | 0 | 400
13 |  | Ganzo | 0.5 | [NAME] | 0 | 0 | 0 | 200 | 200 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 147930d1333039358-data-validation-and-vlookup-counts
Sheet: Speech Therapist-20

[NAME]: | 20
Job Title | Count |  | Employed Type | Count
bsc audiology | 1 |  | Independent - Retail | 0
cccslp | 1 |  | Chain - Retail | 0
gfgh | 1 |  | Hospital | 0
[NAME] | 1 |  | Consultant | 0
LGCuvkydly | 1 |  | Institutional - Other | 0
M.Ed | 1 |  | Retired | 0
M.S. | 1 |  | Unemployed | 0
MD | 1
mr | 1
Ph.D. | 1
pharmacy tech | 1
R.Ph. | 1
RN CPhT | 1
rph | 1
rpht | 1
SLP | 4
Teacher | 1