tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: louise_kitchen__24127__North America Plan 01-02
Sheet: Central Gas - Orig

 | Central Gas - Orig
 | 2002 Plan
 |  |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp
 |  | 2001-09-01 00:00:00 |  | 2001 |  | % | 2002
 |  | YTD Actual |  | Forecast |  | of Total | Plan
ENACOMP | Compensation |  |  |  |  |  |  | Compensation | 0
 | Special Pays |  |  | 0 |  |  | 0
 | Analyst & Associates
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  |  | Other
ENAEMPEX | Employee Expense
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  |  | Total
ENAOUTSV | Outside Services
ENASUPP | Supplies Expense
ENAMKTEX | Marketing |  |  |  |  |  |  | Intern | 33000
ENACONTR | Charitable Contributions |  |  |  |  |  |  | [NAME] | 48400 | 0
ENARENT | Rent |  |  |  |  |  |  | Staff | 49500 | 0
ENATECH | Technology |  |  |  |  |  | 15000 | Specialist | 57750 | 0
ENATRANS | Transportation |  |  |  |  |  |  | Sr. Specialist | 71500 | 0
ENAOTHEX | Other Expenses |  |  |  |  |  |  | Analyst | 60500 | 0
ENATAXES | Taxes Other than Income |  |  |  |  |  | 0 | Associate | 89100 | 0
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  | Manager | 110000
 |  |  |  |  |  |  |  | Director | 143000
 | Headcount |  |  |  |  |  |  | Sr. Director | 165000 | 0
 |  |  |  |  |  |  |  | VP | 198000 | 1
 | A&A Headcount |  |  |  |  |  |  | MD | 220000 | 0
 | Total Headcount |  |  |  |  |  |  |  |  |  | 0.2
 |  |  |  |  |  |  | Other Expense Calculation
 | Outside Services | 254512
 |  |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
Spreadsheet: da97973c-13cb-484b-87ec-e67990d89985
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
261356 | 72818 | [NAME] | [NAME] | CAN | 28 | 00:09:44 | 00:01:35 | 00:36:29 | 00:00:45 | 00:16:22 | 1 | 01:04:54
261356 | 69962 | [NAME] | Hammer | USA | 26 | [NAME] | 00:02:07 | 00:36:20 | 00:00:38 | 00:15:20 | 2 | 01:05:43
261356 | 32641 | Joel | Rosinbum | USA | 27 | 00:12:07 | 00:01:46 | [NAME] | 00:00:49 | 00:21:11 | 3 | 01:13:27
261356 | 51378 | [NAME] | Ramos | USA | 29 | 00:13:03 | 00:02:20 | 00:40:01 | [NAME] | 00:19:20 | 4 | 01:15:32
261356 | 72513 | [NAME] | Flamand | CAN | 30 | 00:14:46 | 00:02:12 | 00:40:52 | 00:00:45 | 00:22:09 | 5 | [NAME]
Spreadsheet: 877217d1723947124-fully-automatic-seating-plan-exam-hall-for-various-group-input
Sheet: 7th ba

S. No | Register No | Student Name
1 | 126087001 | Aba
2 | 126087002 | Aba
3 | 126087004 | Aks
4 | 126087005 | Apa
5 | 126087006 | Bhu
6 | 126087007 | Bow
7 | 126087008 | [NAME]
8 | 126087009 | [NAME]
9 | 126087010 | Gay
10 | 126087011 | Gay
11 | 126087012 | Gov
12 | 126087013 | Har
13 | 126087014 | Har
14 | 126087015 | [NAME]
15 | 126087016 | Him
16 | 126087017 | Jan
17 | 126087018 | Jef
18 | 126087019 | Jyo
19 | 126087020 | Kav
20 | 126087021 | Kav
21 | 126087022 | [NAME]
22 | 126087023 | [NAME]
23 | 126087024 | Mah
24 | 126087025 | Moh
25 | 126087026 | Mon
26 | 126087027 | Nan
27 | 126087028 | Neh
28 | 126087060 | Gee
Spreadsheet: 547674d1510674075-using-excel-to-match-data-copy-of-sample-excel-sheet-watkinsam-
Sheet: Student Responses

 | Q1 | Q2 | Q3 | Q4 | Q5
[NAME] | Chemistry of Life | Water, Acids, and Bases | Ecology | Ecology | Scientific Method
Student 1 |  |  | x
Student 2 |  |  |  |  | x
Student 3 | x |  | x
Student 4
Student 5 | x |  |  |  | x
Student 6
Student 7
Student 8 |  |  | x
Student 9 | x
Student 10
Student 11 |  |  | x |  | x
Student 12
Student 13 |  |  | x |  | x
Student 14
Student 15 |  |  | x
Student 16 |  | x |  |  | x
Student 17 |  |  | x |  | x
Student 18
Student 19 |  | x |  |  | x
Student 20
Student 21
Student 22 | x |  | x | x
Student 23 |  |  | x
Student 24 |  |  | x
Spreadsheet: 126409d1319670678-index-and-match-formula-tournamenttemplatetest
Sheet: Silent Auction Donation

Category:
[NAME] | Description of Item | First Name | Last Name | Company Name | Title | Street Address | City | State | Zip Code | E-mail | Phone |  |  |  |  | [NAME] in Charge:
Spreadsheet: darrell_schoolcraft__7775__imbalsumm0106
Sheet: Citizens-Griffith

 | Citizens-Griffith
 | POI 78069 - Citizens Griffith
Day | Measured | Scheduled
1 | -13023 | -11000
2 | -20518 | -15000
3 | 0 | 0
4 | -6053 | -7500
5 | -27198 | -10000
6 | -20791 | -25000
7 | -20037 | -10000
8 | -26317 | -25000
9 | -65319 | -19998
10 | -17199 | -19998
11 |  | -19998
12 | -10287 | -35000
13 | -45272 | -60000
14 | -54959 | -64930
15 | -79416 | -80465
16 | -17950 | -30000
17 | -38641 | -25000
18 | -50070 | -56274
19 | -76948 | -44811
20 | -47875 | -96850
21 | -23254 | -68789
22 | -82339 | -81531
23 | -81376 | -36434
24 | -77092 | -97989
25
26
27
28
29
30
31
2001-05-31 00:00:00 |  |  | 57398.07
2001-06-24 00:00:00
Spreadsheet: 769273d1645446677-delete-duplicates-both-pairs-duplicates
Sheet: NEW

Current
Person | Date |  |  |  | Result
[NAME] | 2013-02-11 00:00:00 |  |  |  | [NAME] | 2013-02-11 00:00:00 |  |  |  | 2013-02-11 00:00:00
[NAME] | 2013-02-12 00:00:00 |  |  |  | [NAME] | 2013-02-12 00:00:00 |  |  | [NAME] | 2013-02-12 00:00:00
[NAME] | 2013-02-13 00:00:00 |  |  |  | [NAME] | 2013-02-18 00:00:00 |  |  | [NAME] | 2013-02-18 00:00:00
[NAME] | 2013-02-14 00:00:00 |  |  |  | [NAME] | 2013-02-19 00:00:00 |  |  | [NAME] | 2013-02-19 00:00:00
[NAME] | 2013-02-15 00:00:00 |  |  |  | [NAME] | 2013-02-20 00:00:00 |  |  | [NAME] | 2013-02-20 00:00:00
[NAME] | 2013-02-16 00:00:00 |  |  |  | [NAME] | 2013-02-21 00:00:00 |  |  | [NAME] | 2013-02-21 00:00:00
[NAME] | 2013-02-17 00:00:00 |  |  |  | [NAME] | 2013-02-27 00:00:00 |  |  | [NAME] | 2013-02-27 00:00:00
[NAME] | 2013-02-18 00:00:00 |  |  |  | [NAME] | 2013-02-28 00:00:00 |  |  | [NAME] | 2013-02-28 00:00:00
[NAME] | 2013-02-19 00:00:00 |  |  |  | [NAME] | 2013-03-01 00:00:00 |  |  | [NAME] | 2013-03-01 00:00:00
[NAME] | 2013-02-20 00:00:00
[NAME] | 2013-02-21 00:00:00
[NAME] | 2013-02-13 00:00:00
[NAME] | 2013-02-14 00:00:00
[NAME] | 2013-02-15 00:00:00
[NAME] | 2013-02-16 00:00:00
[NAME] | 2013-02-17 00:00:00
[NAME] | 2013-02-27 00:00:00
[NAME] | 2013-02-28 00:00:00
[NAME] | 2013-03-01 00:00:00
Spreadsheet: 97597d1296733881-hiding-default-data-created-by-formula-banned-students-list
Sheet: Sheet1

Banned Students
Name of Student | Date Banned | Restriction in place | Sanctioned by | Date for access to be restored | Completed by
 | 2011-02-03 00:00:00
Spreadsheet: 45559d1244310557-sorting-top-subcontractors
Sheet: Sheet1

Total Points | Division 2
 | AREA 1 |  | Top Subs
27 | Sub 1 |  | Sub 1 | 27 | 1st
6 | Sub 2 |  | Sub 3 | 10 | 2nd
10 | Sub 3
 | AREA 2 |  | Top Subs
8 | Sub 3 |  | Sub 5 | 15 | 1st
5 | Sub 4 |  | Sub 3 | 8 | 2nd
15 | Sub 5
Spreadsheet: 105679d1302961328-multiple-cell-drop-down-list-pricing-system-send-to-excel-forum
Sheet: Kemp Pricing Worksheet

Kemp Custom Cabinet Pricing System
Customer: |  |  | Quote date - | 2011-04-16 00:00:00
Job:
[NAME]: |  |  | Phone # -
Room: |  |  | Fax # -
Quantity | Item Code | Item Description | List Price | Total List
 |  |  |  |  |  | Double Click on a cell in column B
 |  |  |  | 0 |  | Begin Typing an Item Code
 |  |  |  | 0 |  | Use the Up/Down Arrow Keys to [NAME]
 |  |  |  | 0 |  | Use the TAB or ENTER key to exit the ComboBox
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  | Shipping |  | 0
 |  |  | Subtotal | 0
Door Style |  |  |  | 0
Wood Species |  |  |  | 0
 | Finish |  |  | 0
Special Finish |  |  |  | 0
 |  |  | Subtotal | 0
 |  |  | Net | 0
 |  |  | Margin | 0.33
 |  |  | Retail Total | 0
Spreadsheet: 168734d1342552700-copy-across-multiple-rows-and-columns-the-data-to-one-column-removing-dupilicates-blank-15640
Sheet: Nov25-Dec1m

Main Arena
 | 2012-11-25 00:00:00 |  |  | Thru | 2012-12-01 00:00:00
 | SUN | MON | TUE | WED | THURS | FRI | SAT
 | 2012-11-25 00:00:00 | 2012-11-26 00:00:00 | 2012-11-27 00:00:00 | 2012-11-28 00:00:00 | 2012-11-29 00:00:00 | 2012-11-30 00:00:00 | 2012-12-01 00:00:00 |  |  |  | Blocks | Team | Hours
7:00AM |  |  |  |  |  |  |  | 7:00AM |  |  | 0 | 05 [NAME] | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 04 Flags | 0
[NAME] |  |  |  |  |  |  |  | [NAME] |  |  | 0 | 03 [NAME] | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 02 Flags | 0
[NAME] |  |  |  |  |  |  |  | [NAME] |  |  | 0 | 01 Flags | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 00 Flags | 0
10:00AM |  |  |  |  |  |  |  | 10:00AM |  |  | 0 | 99 Flags | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 98 Flags | 0
11:00AM |  |  |  |  |  |  |  | 11:00AM |  |  | 0 | Midget A | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | Midget AA | 0
12:00PM |  |  |  |  |  |  |  | 12:00PM
1:00PM |  |  |  |  |  |  |  | 1:00PM
2:00PM |  |  |  |  |  |  |  | 2:00PM
3:00PM |  |  |  |  |  |  |  | 3:00PM
4:00PM |  |  |  |  |  |  |  | 4:00PM
5:00PM |  |  |  |  |  |  |  | 5:00PM
6:00PM |  |  |  |  |  |  |  | 6:00PM
7:00PM |  |  |  |  |  |  |  | 7:00PM
8:00PM |  |  |  |  |  |  |  | 8:00PM
9:00PM |  |  |  |  |  |  |  | 9:00PM
10:00PM |  |  |  |  |  |  |  | 10:00PM
11:00PM |  |  |  |  |  |  |  | 11:00PM
 | Cancellations or Corrections
 | Date | Time | Customer | Operations Personal | Comments
Spreadsheet: 221684d1363639576-comparing-columns-for-values-higher-lower-or-equal-example1
Sheet: Sheet1

Account | Jan | Feb | March | April | May | June | July | August | Sept | Oct | Nov | Dec
Example | 7034.88 | 3062.47
Example | 3066.16 | 4008.88
Example | 1007.89 | 1042.28
Example | 2569.42 | 2777.61
Example | 2409.72 | 3308.41
Example | 911.15 | 664.63
Example | 740.26 | 512.58
Example | 5058.49 | 4534.68
Example | 1957.6 | 2343.75
Example | 2579.83 | 1542.81
Example | 15223.48 | 7611.55
Example | 4182.71 | 6496.34
Example | 2072.27 | 2015.81
Example | 1391.39 | 1308.08
Example | 1759.67 | 1193.85
Example | 3455.96 | 3086.64
Example | 3438.77 | 2779.82
Example | 8117.53 | 4402.2
Example | 2231.9 | 1243.17
Example | 11131.86 | 8252.92
Example | 4069.44 | 6779.94
Example | 4617.39 | 3399.9
Example | 3775.38 | 4184.34
Example | 15515.8 | 13611.03
Example | 33701.59 | 25458.91
Example | 899.24 | 759.89
Example | 2940.11 | 1759.34
Example | 1778.2 | 1407.43
Example | 3067.93 | 5155.81
Example | 1490.8 | 1711.71
Example | 0 | 0
Example | 6148.66 | 5129.4
Example | 1851.11 | 1406.69
Example | 1890.31 | 1959.13
Example | 1019.56 | 1084.56
Example | 1925.59 | 1356.82
Example | 6237.42 | 5412.11
Example | 11940.8 | 20539.65
Example | 3263.5 | 3937.41
Example | 2557.75 | 2451.89
Example | 1684.55 | 1951.46
Example | 6764.92 | 5696.59
Example | 28324.7 | 35775.43
Example | 2485.8 | 3389.94
Example | 9555.43 | 3532.47
Example | 236.03 | 901.68
Example | 2985.21 | 2932.81
Example | 2977.81 | 2141.33
Example | 613.82 | 677.9
Example | 1020.61 | 916.69
Example | 469.17 | 324.59
Example | 893.95 | 998.02
Example | 1267.39 | 1129.9
Example | 1497.07 | 2410.11
Example | 520.31 | 1574.27
Example | 797.82 | 1576.07
Example | 766.84 | 517.3
Example | 7047.88 | 6155.41
Example | 11980.17 | 7603.08
Example | 2766.85 | 7203.84
Example | 2149.52 | 3172.65
Example | 1881.77 | 1471.18
Example | 2327.22 | 2115.51
Example | 575.06 | 273.26
Example | 1954.09 | 1803.48
Example | 606.09 | 809.61
Example | 17537.76 | 21151.61
Example | 1006.29 | 4310.9
Example | 1997.78 | 2163.13
Example | 1730.06 | 1938.74
Example | 849.84 | 798.48
Example | 7640.31 | 8591.56
Example | 4731.02 | 6668.12 | 4567 | 56788
Example | 11784.21 | 8526.55
Example | 3594.7 | 4758.42
Example | 536.59 | 0
Example | 1612.06 | 1553.85
Example | 9476.62 | 12776.77
Example | 4345.69 | 5360.42
Example | 24796.66 | 28741.51
Example | 1788.37 | 1808.03
Example | 1514.96 | 931.13
Example | 1872.62 | 1089.85
Example | 1198.66 | 1060.67
 | Total number of accounts up & down for each month compared to the previous month
UPS
DOWNS
EQUAL
Spreadsheet: 266339d1379586121-diplaying-status-value-based-on-cell-value-attendance-report
Sheet: Sheet1

 | AUG-2013 |  | Monthly Summary
S. No | Name | Team | Min Req. Hours | Hours Worked | Extra Hours | Status
1 | A | NC | 180:00 | 180:53 | 0:53 |  | OK |  |  | NC | ST | TU | [NAME] | PDE
2 | B | NC | 171:00 | 175:26 | 4:26 |  | OK
3 | C | NC | 157:30 | 161:43 | 4:13 |  | OK |  |  | 0 | 0 | 1 | 1 | 0
4 | D | ST | 180:00 | 183:27 | 3:27 |  | OK
5 | E | NC | 171:00 | 184:46 | 13:46 |  | > 10 Hours |  |  | 0 to 5 | OK
6 | F | ST | 171:00 | 195:14 | 24:14 |  | > 10 Hours |  |  | 5 to 10 | >5 Hours
7 | G | TU | 171:00 | 174:26 | 3:26 |  | OK |  |  | >10 | >10 Hours
8 | H | ST | 175:30 | 181:18 | 5:48 |  | > 5 Hours |  |  | <0 | SHORT FALL
9 | I | TU | 171:00 | 172:59 | 1:59 |  | OK
10 | G | [NAME] | 157:30 | 158:20 | 0:50 |  | OK
11 | K | [NAME] | 180:00 | 174:45 | -5:15 |  | SHORT FALL
12 | L | PDE | 180:00 | 222:19 | 42:19 |  | > 10 Hours
13 | M | TU | 171:00 | 187:13 | 16:13 |  | > 10 Hours
14 | N | TU | 135:00 | 0:00 | -135:00 |  | SHORT FALL
Spreadsheet: 714164d1611127935-comparing-text-and-numbers-to-output-a-text-test-spreadsheet
Sheet: Sheet1

 | Oil Production
 | Risers
 | Tag Number | Type | Signal Description | Units | Asset | Alarm | Alarm Name | Alarm Priority | Enabled | Signal Function Description (design intent) | Time to Event (TTE) mins | Required Operator Action (operator response) | Operator Response Time (ORT) | Urgency | Urgency Category | Operator Action PCS Display | Consequence of Operator Inaction | Missed Alarm Consequence ranking | Safety, Enviromental or Commercial? | Priority Justification | Alarm Management Standard  - proposed priority |  | P&ID  no
 |  |  |  |  |  |  |  |  |  |  | Minutes |  | Minutes | TTE-ORT=Urgency | Table 3 of AMS |  |  | Table 1 of AMS | Table 1 of AMS |  | Figure 4.1 of AMS
32465 | PAHH01070 | Digital | BTN PRODN RISER | HI-HI | /Assets/T1 | State0AlarmPriority | st0 HI-HI | Low | Enabled | Signal indicates a high  riser pressure.  The signal will cause the PSD system to take action to protect the riser and associated equipment. | 720 | CCRO to source the cause of the high pressure.  Check for 1st Stage Separator Trip or HIC valve position. Once sourced the CCRO should restart production if safe to do so. | 2 |  |  | Source the cause of the trip.  Check 1st Stage Separator operation and HIC valve position.  [NAME] production. | Deferred production | 4 | Commercial | Low financial consequence - Process upset or equipment damage.  Cost $50K-$500K | Medium - High (PCS)
32466 |  | Digital | BTN PRODN RISER | HI-HI | /Assets/T1 | State1AlarmPriority | st1 NORMAL | Journal | Not Enabled | Signal indicates a high  riser pressure.  The signal will cause the PSD system to take action to protect the riser and associated equipment. |  | No action required |  |  |  | N/A | Normal operating status |  |  | No significant consequences identified
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Below table just to clarify, not using in formula in W6.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Consequence
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 4 | 3 | 2 | 1 | Urgency: LOOKUP(O6,{0,1,20,60,720}*1.01,{5,4,3,2,1})
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Value indicates emergency: biggest : most urgent
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <=6 ( exclude 5) | Low
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 & <=12 | Medium
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | rest | High
Spreadsheet: 07c6884e-bd6c-4855-b692-276c65d69d23
Sheet: In days

Enter full year entitlement in days
(if part-time, use calculator 1 on leave calculator if not known) |  |  | Working days |  |  | INSTRUCTIONS FOR USE
 |  |  | Monday |  |  | 1.  Calculate entitlement (pro-rated if part-time)
Enter date of start of contract e.g. 1 October 2011 | 2011-10-01 00:00:00 |  | Tuesday |  |  | 2. Put your working days in the table to the left (as a reminder).
(or  start date for annual leave year) |  |  | Wednesday |  |  | 3. Complete the table for Bank and University Holidays, putting in the proportion of  a day you would normally work on that day. Put in 1 for a full day.  If you do not normally work that day, enter zero.
Enter end date of holiday year  i.e. 31 August 2012 | 2012-08-31 00:00:00 |  | Thursday |  |  | 4. Put zero for any days that occurred before you started work at the University.
 |  |  | Friday |  |  | 5. Add on the further days of bookable annual leave as they are taken, or when they are planned.
Number of days between the these two dates |  |  | Total
Entitlement in days
HOLIDAY RECORD
 | Proportion of day normally hours worked on that day(s) | Running total of leave taken | Running total of leave remaining |  |  | Note: The values used are fractions of a day  e.g. 1 day = 1.0, ½ day = 0.5 days
Bank and University Holidays
Monday 26th December
Tuesday 27th December
Wednesday 28th December
Thursday 29th December
Friday 30th December
Monday 2nd January 2012
Friday 6th April
Monday 9th April
Tuesday 10th April
Monday 7th May
Monday 4th June
Tuesday 5th June
Monday 27th August
Tuesday 28th August
Bookable Leave
Spreadsheet: 760900d1640525650-sum-based-on-criteria-sum-based-on-criteria
Sheet: Sheet1

 |  |  |  |  |  |  |  | SOLUTION 2 USING A HELPER COLUMN FOR DATA VALIDATION CODES AND SUMIF
Employee Name | Emp Code | Month | Description | Amount [USD] | Amount [SAR]
A | 7423 | 2021-11-30 00:00:00 | Hotel Charges | 200 | 750.8 | HC
A | 7423 | 2021-11-30 00:00:00 | Airfare Charges | 100 | 375.4 | AC
B | 7843 | 2021-11-30 00:00:00 | [NAME] | 3000 | 11250 | SA
Total  Hotel Charges | HC |  |  | 200
Total  Airfare Charges | AC |  |  | 100
Total  Salary Advance | SA |  |  | 3000
 |  |  |  | SOLUTION 1 USING INDEX MATCH WITH
 |  |  |  | [NAME] AND RIGHT
Spreadsheet: 686571d1594689170-conditional-format-needed-to-highlight-based-on-matching-text-in-certain-cells-cond-format-formula-1-
Sheet: Formula

 |  | SECTION 1 |  | SECTION 2 |  | SECTION 3 |  | SECTION 4
 |  | ABC
 |  |  |  | DEF
 |  |  |  |  |  |  |  | JKL
 |  |  |  |  |  | GHI
 |  | SECTION 5 |  | SECTION 6 |  | SECTION 7 |  | SECTION 8
 |  | ABC
 |  |  |  |  |  |  |  | JKL
 |  |  |  |  |  | GHI
 |  |  |  | DEF
 |  | ABC |  | DEF |  | GHI |  | JKL
 |  | SECTION 9 |  | SECTION 10 |  | SECTION 11 |  | SECTION 12
Spreadsheet: 1c238db8-173c-498c-9563-f4eb6bbf25d2
Sheet: 15a

Product1 | Cleared2 | Uncleared | TOTAL
Index Tranche | 0 | 231.2927347 | 231.2927347
Index | 251986.2614266 | 3477.4234827 | 255463.6849093
Europe | 117644.6046256 | 644.6294641 | 118289.2340897
North America/Asia | 132054.316801 | 2812.2940186 | 134866.6108196
Other | 2287.34 | 20.5 | 2307.84
OTHER* | 3234.7789796 | 3671.2760408 | 6906.0550203
TOTAL | 255221.0404062 | 7379.9922581 | 262601.0326643
*OTHER variable includes exotic credit products, swaptions, and total return swaps.
Spreadsheet: 854627d1704434813-data-validation-to-allow-only-alphanumerics-example-sheet-ans
Sheet: Sheet1

Pickup Street | Pickup City | [NAME] | [NAME] | Dropoff Street | Trip Purpose | Dropoff City | Dropoff State | [NAME] |  | FORMULA
1234 Fake Street | Auburn | WA | 98007 | 4567 Fake Street | Groceries | Auburn | WA | 98072 |  | =LET(l,[NAME],CODE(MID(A2,ROW(INDIRECT("1:"&l)),1)),b,[NAME])
4567 Fake Street | Auburn | WA | 98072 | 1234 Fake Street | Shopping | Auburn | WA | 98007
4333 Faux Ave | Seattle | WA | 98032 | 8796 Not Real Ave | Groceries | Kent | WA | 98032
8796 Not Real Ave | Kent | WA | 98032 | 4333 Faux Ave | Shopping | Seattle | WA | 98032
Spreadsheet: 730025d1619505125-highlight-correct-cells-arboleas-scores
Sheet: Sheet1

 |  |  | WEEKS RESULT | WEEKS RESULT | WEEKS RESULT | WEEKS RESULT | WEEKS RESULT | WEEKS RESULT | WEEKS RESULT | WEEKS RESULT | WEEKS RESULT | WEEKS RESULT | WEEKS RESULT
 | CORRECT RESULT |  | HOME | AWAY | HOME | AWAY | DRAW | AWAY | HOME | AWAY | DRAW | DRAW | HOME
 |  |  | Spurs   Southampton | Villa           Man City | Leicester  Baggies | Arsenal  Everton | Liverpool  Newcastle | West Ham  Chelsea | Sheffield  Brighton | Wolves  Burnley | [NAME] | Villa  Baggies | Leicester  Crystal  Pal |  | THIS WEEKS TOTAL |  | LAST WEEKS TOTAL |  | TOTAL OVERALL
 | PLAYERS | SCORE THIS WEEK
 | [NAME] |  | HOME | AWAY | HOME | AWAY | HOME | HOME | AWAY | HOME | AWAY | HOME | HOME |  |  |  | 169
 | [NAME] |  | HOME | AWAY | HOME | HOME | HOME | DRAW | AWAY | HOME | AWAY | HOME | HOME |  |  |  | 156
 | [NAME] |  | HOME | AWAY | HOME | HOME | HOME | AWAY | AWAY | HOME | AWAY | DRAW | HOME |  |  |  | 157
 | Biggin |  | HOME | AWAY | HOME | HOME | HOME | AWAY | HOME | HOME | AWAY | HOME | HOME |  |  |  | 153
 | Jellybaby |  | HOME | DRAW | HOME | HOME | HOME | DRAW | HOME | HOME | DRAW | AWAY | HOME |  |  |  | 149
 | Dorreen 1 |  | HOME | AWAY | HOME | AWAY | HOME | AWAY | DRAW | HOME | AWAY | AWAY | DRAW |  |  |  | 148
 | [NAME] |  | HOME | AWAY | HOME | DRAW | HOME | DRAW | DRAW | HOME | AWAY | HOME | HOME |  |  |  | 146
 | Princess |  | AWAY | AWAY | HOME | HOME | HOME | AWAY | AWAY | AWAY | AWAY | AWAY | HOME |  |  |  | 144
 | [NAME] |  | HOME | AWAY | DRAW | DRAW | HOME | HOME | AWAY | HOME | AWAY | HOME | HOME |  |  |  | 137
 | Angleseyite |  | HOME | DRAW | HOME | HOME | HOME | HOME | DRAW | HOME | DRAW | HOME | HOME |  |  |  | 135
 | Timb |  | DRAW | AWAY | HOME | DRAW | HOME | DRAW | HOME | HOME | DRAW | DRAW | HOME |  |  |  | 134
 | [NAME] |  | HOME | AWAY | DRAW | DRAW | HOME | HOME | HOME | HOME | DRAW | DRAW | HOME |  |  |  | 128
 | Ianjax |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 116
 | Filipe |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 106