tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 686291d1594477468-please-help-with-vloock-up-or-iferror-plano-de-manutencao-de-viaturas-2020
Sheet: Manutencao-Marco

 | Plano de Manutenção de Viaturas-Mina
 | [NAME]: Fevereiro
 | Item | Viatura | [NAME] | Tag | Matricula | Data Prevista para Manutenção | [NAME] para Manutencao | Km Actual | Motorista | Mecânico | Status
 | 1 | TOYOTA | HINO 500 | V064 | AAA-968-TT | 2020-02-09 00:00:00 | 193900 | 188898 | [NAME] | [NAME] | Concluido
 | 2 | ISUZU | KB250D-3,05M | V018 | AEM-965-MP | 2020-02-16 00:00:00 | 210000 | 205007 | [NAME] | Yfam Auto | Concluido
 | 3 | TOYOTA | COASTER 3.40M | V044 | AHD-297-MC | 2020-02-18 00:00:00 | 205000 | 206794 | Celso Chauque | [NAME] | Concluido
 | 4 | TOYOTA | COASTER 3.40M | L002 | [NAME] | 2020-02-22 00:00:00 | 155000 | 156908 | [NAME] | Leasing | Concluido
 | 5 | TOYOTA | COASTER 3.30M | V038 | AGS-760-MC | 2020-02-22 00:00:00 | 110000 | 105448 | Celso Chin | [NAME] | Concluido
 | 6 | TOYOTA | QUANTUM | L003 | AIR-806-MC | 2020-02-22 00:00:00 | 310000 | 309134 | [NAME] | Entreposto | Progresso
 | 7 | TOYOTA | COASTER 3.40M | L005 | [NAME] | 2020-02-23 00:00:00 | 160000 | 159658 | [NAME] | Leasing | Concluido
 | 8 | TOYOTA | COASTER 3.10M | V037 | AFB-664-MC | 2020-02-24 00:00:00 | 300000 | 298945 | Albino Nhantumbo | [NAME] | Concluido
 | 9 | TOYOTA | D4D | V049 | ADH-907-MC | 2020-02-29 00:00:00 | 80000 | 80847 | [NAME] | [NAME] | Progresso
 | 10 | TOYOTA | DINA | V053 | AGS-387-MP | 2020-03-14 00:00:00 | 365000 | 363802 | [NAME] | [NAME] | Concluido
 | 11 | ISUZU | KB250D-3,05M | V019 | AEM-918-MP | 2020-03-30 00:00:00 | 225000 | 223157 | [NAME] | [NAME] | Concluido
 | 12 | NISSAN | UD350-4,00M | V039 | AGK-366-MP | 2020-03-30 00:00:00 | 560000 | 558118 | [NAME] | [NAME] | Concluido
 | 13 | TOYOTA | COASTER 3.10M | L001 | AGS-297-MC | 2020-03-31 00:00:00 | 200000 | 198145 | [NAME] | Leasing | Concluido
 | 14 | ISUZU | KB250D-3,05M | V040 | AGH-689-MP | 2020-03-31 00:00:00 | 60000 | 57172 | Mustak Mussa | Entreposto | Concluido
 | 15 | NISSAN | UD350-4,00M | L003 | AAC-135-TT | 2020-04-05 00:00:00 | 65000 | 62468 | Goncalves Torres | Leasing | Concluido
 | 16 | TOYOTA | COASTER 3.40M | V046 | AHF-323-MC | 2020-04-06 00:00:00 | 330000 | 327664 | [NAME] | [NAME] | Concluido
 | 17 | TLB | BELL | Equ02 | BL - 315 SK | 2020-04-08 00:00:00 | 2250 HORAS | 2094 HORAS | Orlando Matavel | Lonagro | Concluido
 | 18 | FORD | RANGER | V063 | AJA-075-MC | 2020-06-06 00:00:00 | 10000 |  | Alcidio Nhapossa | Tecnocar | Concluido
Spreadsheet: 05f910e1-303a-42b2-bf7a-3c7e5c0a24ee
Sheet: Sheet1

County | Funding: AB 109 Programs (2011-2012) | Funding: AB 109 DA/PD Activities (revocation) (2011-2012) | Funding: Allocation for Training, [NAME] purposes (one-time) (2011) | [NAME] N/N/N inmates (Year 4 Full Rollout) | Project Post-Release Community Supervision Pop. (Year 4 Rollout)
Alameda | 9221012 | 330530 | 650650 | 267 | 848
Alpine | 76883 | 2756 | 5425 | 2 | -
Amador | 543496 | 19482 | 38350 | 53 | 43
[NAME] | 2735905 | 98069 | 193050 | 268 | 181
Calaveras | 350757 | 12573 | 24750 | 21 | 25
Colusa | 214352 | 7684 | 15125 | 23 | 9
Contra Costa | 4572950 | 163919 | 322675 | 104 | 318
[NAME] | 221438 | 7938 | 15625 | 11 | 20
El Dorado | 1210643 | 43396 | 85425 | 68 | 81
Fresno | 8838368 | 316814 | 623650 | 518 | 971
[NAME] | 331271 | 11875 | 23375 | 28 | 19
Humboldt | 1526679 | 54724 | 107725 | 137 | 126
Imperial | 1296384 | 46469 | 91475 | 90 | 107
Inyo | 190968 | 6845 | 13475 | 15 | 15
Kern | 10834140 | 388353 | 764475 | 1019 | 1040
Kings | 2862035 | 102591 | 201950 | 321 | 185
Lake | 820913 | 29426 | 57925 | 73 | 75
[NAME] | 384770 | 13792 | 27150 | 32 | 26
Los Angeles | 112558276 | 4034688 | 7942300 | 8342 | 9791
Madera | 1688240 | 60516 | 119125 | 111 | 150
Marin | 1304178 | 46749 | 92025 | 66 | 53
Mariposa | 165458 | 5931 | 11675 | 13 | 11
Mendocino | 993812 | 35624 | 70125 | 75 | 50
Merced | 2498524 | 89560 | 176300 | 171 | 214
Modoc | 76883 | 2756 | 5425 | 2 | 3
Mono | 100267 | 3594 | 7075 | 3 | 7
[NAME] | 3846989 | 137897 | 271450 | 308 | 309
Napa | 1051917 | 37706 | 74225 | 70 | 69
Nevada | 515152 | 18466 | 36350 | 23 | 17
Orange | 23078393 | 827253 | 1628450 | 1464 | 1750
Placer | 2986395 | 107048 | 210725 | 251 | 153
Plumas | 153766 | 5512 | 10850 | 9 | 12
Riverside | 21074473 | 755421 | 1487050 | 1601 | 1683
Sacramento | 13140278 | 471018 | 927200 | 895 | 1203
San Benito | 547748 | 19634 | 38650 | 52 | 23
San Bernardino | 25785600 | 924293 | 1819475 | 2301 | 2521
San Diego | 25105698 | 899922 | 1771500 | 1821 | 2038
San Francisco | 5049838 | 181013 | 356325 | 164 | 421
San Joaquin | 6785908 | 243243 | 478825 | 450 | 639
[NAME] | 2200557 | 78880 | 155275 | 140 | 136
San Mateo | 4222902 | 151371 | 297975 | 208 | 351
Santa Barbara | 3878876 | 139040 | 273700 | 294 | 288
Santa Clara | 12566312 | 450444 | 886700 | 693 | 1067
Santa Cruz | 1662730 | 59601 | 117325 | 78 | 69
Shasta | 2988875 | 107137 | 210900 | 326 | 201
Sierra | 76883 | 2756 | 5425 | 1 | 1
Siskiyou | 445001 | 15951 | 31400 | 34 | 23
Solano | 3807662 | 136487 | 268675 | 278 | 363
Sonoma | 3240428 | 116154 | 228650 | 231 | 164
Stanislaus | 6010700 | 215456 | 424125 | 540 | 426
Sutter | 1167419 | 41847 | 82375 | 103 | 108
[NAME] | 1212415 | 43459 | 85550 | 154 | 50
Trinity | 144554 | 5182 | 10200 | 9 | 9
Tulare | 5657817 | 202806 | 399225 | 520 | 388
Tuolumne | 598767 | 21463 | 42250 | 47 | 33
Ventura | 5696790 | 204203 | 401975 | 380 | 363
Yolo | 2974703 | 106629 | 209900 | 277 | 215
[NAME] | 1005858 | 36055 | 70975 | 94 | 88
Spreadsheet: 468243d1467197526-format-cells-based-on-formulas-in-other-tab-sample-book
Sheet: Training History

 |  | WSOPT     0200 | WSOPT      0201 | WSOPT 201b | WSOPT     0202 | WSOPT     0203
 |  | Sample 1 | Sample 2 | Sample 3 | Sample 4 | Sample 5 |  |  | Sample workbook
 |  | Current Version | Current Version | Current Version | Current Version | Current Version
 |  | 0 | 0 | 0 | 0 | 0
Sample Name 1 | Mon-Fri | 2014-01-08 00:00:00 | 2014-10-31 00:00:00 |  | 2015-10-22 00:00:00
Sample Name 2 | Mon-Fri | 2016-06-06 00:00:00 | 2015-11-24 00:00:00
Sample Name 3 | Manager | 2016-06-06 00:00:00 | 2015-11-24 00:00:00
Sample Name 4 | Grren | 2016-06-16 00:00:00 | 2015-04-30 00:00:00 |  | 2016-03-11 00:00:00
Sample Name 5 | Blue | 2016-06-06 00:00:00 | 2015-05-25 00:00:00
Sample Name 6 | Red | 2016-06-06 00:00:00 | 2015-05-25 00:00:00
Sample Name 7 | Team leader | 2014-11-03 00:00:00 | 2015-04-24 00:00:00 |  | 2015-10-22 00:00:00
Sample Name 8 | Team leader | 2015-10-06 00:00:00
Sample Name 9 | Mon-Fri | 2015-10-14 00:00:00
Sample Name 10 | 4 on 4 off | 2016-06-06 00:00:00 | 2014-01-03 00:00:00
Sample Name 11 | 4 on 4 off | 2016-06-06 00:00:00 | 2014-10-29 00:00:00
Sample Name 12 | 4 on 4 off | 2016-06-06 00:00:00 | 2015-04-30 00:00:00 |  | 2016-03-14 00:00:00
Sample Name 13 | Mon-Fri | 2016-06-06 00:00:00 | 2015-11-24 00:00:00
Sample Name 14 | Mon-Fri | 2016-06-06 00:00:00 | 2015-11-24 00:00:00
Sample Name 15 | Manager | 2016-06-16 00:00:00 | 2015-04-30 00:00:00 |  | 2016-03-11 00:00:00
Sample Name 16 | Grren | 2016-06-06 00:00:00 | 2015-05-25 00:00:00
Sample Name 17 | Blue
Sample Name 18 | Red | 2014-02-03 00:00:00 | 2014-09-25 00:00:00
Sample Name 19 | Team leader | 2016-06-06 00:00:00 | 2015-04-30 00:00:00 |  | 2014-01-22 00:00:00
Sample Name 20 | Team leader | 2015-02-25 00:00:00 | 2015-04-30 00:00:00 |  | 2015-02-25 00:00:00 | 2015-10-24 00:00:00
Sample Name 21 | Mon-Fri
Sample Name 22 | 4 on 4 off | 2014-09-02 00:00:00 | 2015-04-30 00:00:00
Sample Name 23 | 4 on 4 off
Sample Name 24 | 4 on 4 off | 2016-06-06 00:00:00 | 2015-04-30 00:00:00
Sample Name 25 | Mon-Fri | 2016-06-06 00:00:00 | 2015-06-03 00:00:00 |  | 2016-03-11 00:00:00
Sample Name 26 | Mon-Fri | 2014-05-19 00:00:00 | 2015-04-30 00:00:00
Sample Name 27 | Manager
Sample Name 28 | Grren
Sample Name 29 | Blue
Sample Name 30 | Red
Sample Name 31 | Team leader
Sample Name 32 | Team leader | 2015-09-24 00:00:00 | 2015-11-23 00:00:00
Sample Name 33 | Mon-Fri
Sample Name 34 | 4 on 4 off
Sample Name 35 | 4 on 4 off
Sample Name 36 | 4 on 4 off
Sample Name 37 | Mon-Fri
Sample Name 38 | Mon-Fri
Sample Name 39 | Manager
Sample Name 40 | Grren
Sample Name 41 | Blue
Sample Name 42 | Red
Spreadsheet: 51357d1250958377-formula-needed-involving-if-condition-tenure
Sheet: Sheet1

TOTAL BILLABLE FTE |  | 30
0-6 months
6-12 months
>12 months
DOJ | 2007-07-05 00:00:00 | 2007-11-06 00:00:00 | 2006-04-07 00:00:00 | 2005-11-08 00:00:00 | 2008-11-09 00:00:00 | 2006-11-10 00:00:00 | 2006-11-11 00:00:00 | 2003-11-12 00:00:00 | 2006-11-13 00:00:00 | 2006-11-14 00:00:00 | 2006-11-15 00:00:00 | 2006-11-16 00:00:00 | 2006-11-17 00:00:00 | 2006-11-18 00:00:00 | 2006-11-19 00:00:00 | 2006-11-20 00:00:00 | 2006-11-21 00:00:00 | 2006-11-22 00:00:00 | 2006-11-23 00:00:00 | 2006-11-24 00:00:00 | 2006-11-25 00:00:00 | 2006-11-26 00:00:00 | 2006-11-27 00:00:00 | 2006-11-28 00:00:00 | 2006-11-29 00:00:00 | 2006-11-30 00:00:00 | 2006-12-01 00:00:00 | 2006-12-02 00:00:00 | 2006-12-03 00:00:00 | 2006-12-04 00:00:00
Tenure(months) | 25 | 21 | 40 | 45 | 9 | 33 | 33 | 69 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32
Spreadsheet: 829327d1684145764-filter-define-txt-basis-difference-cells-book4
Sheet: Sheet1

 | Customer Price (USD) | Vendor [NAME]) | Margin Amount | Margin % | Cost Base Price | Priority
 | 185.72 | 130 |  |  | 182
 | 283 | 110 | 173 | 0.6113074204946997 | 75
 | 1276.29 | 150 | 1126.29 | 0.882471852008556 | 182
 | 1967.66 | 550 | 1417.66 | 0.7204801642560199 | 560
 | 628.56 | 320 | 308.5599999999999 | 0.4908998345424462 | 380.8
 | 180 | 80 | 100 | 0.5555555555555556 | 66
 | 800 | 550 | 250 | 0.3125 | 560
Spreadsheet: benjamin_rogers__1185__United American Energy 02-09-00
Sheet: Taxes

TAXES
('000 $)
STATE TAXES
State Income Taxes
Adjusted Pretax Book Income
Plus Book Depreciation & Amortization
Less State Tax Depreciation
State Taxable Income
State Income Tax Rate
Current State Income Tax Expense (Benefit)
Beginning NOL's | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
New NOL's
Expired NOLs | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NOL Utilization (8 years)
Ending NOL's
TOTAL STATE TAXES UTILIZING NOLs
FEDERAL TAXES
State Taxable Income
Less: State Taxes
Federal Taxable Income
Federal Tax Rate
Federal Tax Expense/ (Benefit)
Beginning NOL's | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
New NOL's
Expired NOLs | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NOL Utilization (15 years)
Ending NOL's
TOTAL STATE TAXES UTILIZING NOLs
Spreadsheet: 513271bc-97be-4e2e-9ac5-16c0a4c00996
Sheet: BookFlix

Scholastic BookFlix 2014
 | Books Viewed | Other Material Viewed | Web Links Used
July | 722 | 216 | 49
August | 1577 | 533 | 47
September | 6528 | 2348 | 45
October
November
December
Notes:
Live to Public on July 15, 2014.
Other Material = games, author biographies
Web Links = each book pair has a web links section of sites put together by bookflix on the topic.
Spreadsheet: 7f5cc381-c97f-4eb9-ae1e-23732b4f588e
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
INPUT HERE=> | Back Squat=> |  | Front Squat=> |  | Snatch=> |  | Clean and Jerk => |  | KG
 | Front Squat => | 6.9 | Back Squat => | -8.3 | Back Squat => | -21.79 | Back Squat => | -27.44
 | Snatch => | 11.55 | Snatch => | 7.67 | Front Squat => | -11.8 | Front Squat => | -14.66
 | Clean and Jerk => | 17.56 | Clean and Jerk => | 11.58 | Clean and Jerk => | 3.6 | Snatch => | -3
 | Total => | 29.11 | Total => | 19.25 | Total => | 3.6 | Total => | -3
 | Front Squat => | 15.211896078 | Back Squat => | -18.298367746 | Back Squat => | -48.0387268898 | Back Squat => | -60.4948446928 | Pounds
 | Snatch => | 25.463391261 | Snatch => | 16.9094554954 | Front Squat => | -26.014546916 | Front Squat => | -32.3197676092
 | Clean and Jerk => | 38.71317320719999 | Clean and Jerk => | 25.5295299396 | Clean and Jerk => | 7.936641432 | Snatch => | -6.613867859999999
 | Total => | 64.1765644682 | Total => | 42.438985435 | Total => | 7.936641432 | Total => | -6.613867859999999
Spreadsheet: 182016d1348238982-array-match-function-needed-book1
Sheet: Sheet1

Color | Blue | Green | Red | Yellow | Pink | Purple | Black
Number | 1 | 2 | 3 | 4 | 5 | 6 | 7
Blue
Black
Yellow |  |  | <-- need an array/match function which will put the correct number by each color.
Pink
Green
Red
Spreadsheet: 741468d1627050192-column-b-and-column-c-of-sheet1-to-be-updated-by-column-b-and-c-of-contact-details-lkk
Sheet: CONTACT DETAILS

Name | id no. | E-mail 1 - Value | unit no.
Name | Memtdertiis No. | E-mail 1 - Value | sione 1 - Value
1-tmriti toni 2- [NAME] tantoti toni | DaY033 | [EMAIL] | 12345026123717
aatiita Kalra | tR50201 | [EMAIL] | 12371170871123
[NAME] | aaY1207 | [EMAIL] | [PHONE] 3312333
atddul Waiid Ratier | tR50037 | [EMAIL] | 1.23123068123123e+17
atdiidartii arma | tR51142 | [EMAIL] | 123871040664
atdiijit [NAME] | RTi10131 | [EMAIL] | 123873440414
atdiijit ten | Otd0164 | [EMAIL] | 4740106033
xyz | tR70146 | [EMAIL] | 123711555135
[NAME] | tR7081123 | [EMAIL] | 12341681235362
atdiitiek | tR50200 | [EMAIL] | 12381810123120
[NAME] | RH60031 | [EMAIL] | xx50xx53xx040
ykhil Myhyjyn | SR70287 | [EMAIL] | xxxx530022xx
ykhil Mylhotry | q60082 | [EMAIL] | xx590xxxxxxxx
ykhiltsh ktyr | q60510 | [EMAIL] | xx1xx745531
bgkhiltsh [NAME] | q60614 | [EMAIL] | xx2xx3xx0xx
[NAME] | SR70432 | [EMAIL] | xx1xxxx95xx54
bglkbg [NAME] | SH80244 | [EMAIL] | xx50xx53xx040
bgMbgN KUMbgR | SR50429 | [EMAIL] | xxxx530022xx
bgmbgrdttp Singh | OB0157 | [EMAIL] | xx590xxxxxxxx
Spreadsheet: 861722d1709570841-sumif-function-with-multiple-criteria-from-a-data-list-to-get-orders-and-returns-impossible-excel-aligw-response
Sheet: Data

Serial number |  |  | Type |  |  | Delivery quantity |  |  | Customer # |  |  |  |  |  |  |  |  |  |  |  | Created on
1 |  |  | Order |  |  | 1 |  |  | 674700 |  |  |  |  |  |  |  |  |  |  |  | 10/1/2022
0 |  |  | Order |  |  | 1 |  |  | 674700 |  |  |  |  |  |  |  |  |  |  |  | 10/1/2022
1 |  |  | Return |  |  | 1 |  |  | 674700 |  |  |  |  |  |  |  |  |  |  |  | 10/1/2023
2 |  |  | Order |  |  | 1 |  |  | 674700 |  |  |  |  |  |  |  |  |  |  |  | 10/1/2023
3 |  |  | Order |  |  | 1 |  |  | 674700 |  |  |  |  |  |  |  |  |  |  |  | 10/1/2023
4 |  |  | Order |  |  | 1 |  |  | 674700 |  |  |  |  |  |  |  |  |  |  |  | 10/1/2023
3 |  |  | Return |  |  | 1 |  |  | 674700 |  |  |  |  |  |  |  |  |  |  |  | 10/1/2023
5 |  |  | Order |  |  | 1 |  |  | 674700 |  |  |  |  |  |  |  |  |  |  |  | 10/1/2023
6 |  |  | Order |  |  | 1 |  |  | 674700 |  |  |  |  |  |  |  |  |  |  |  | 10/1/2023
2 |  |  | Return |  |  | 1 |  |  | 674700 |  |  |  |  |  |  |  |  |  |  |  | 10/1/2023
7 |  |  | Order |  |  | 1 |  |  | 674700 |  |  |  |  |  |  |  |  |  |  |  | 10/1/2023
0 |  |  | Return |  |  | 1 |  |  | 674700 |  |  |  |  |  |  |  |  |  |  |  | 10/1/2023
Spreadsheet: 880329d1727964090-trying-to-create-an-excel-doc-thatll-allow-me-to-schedule-people-on-projects-availability
Sheet: Assignments

Employee Name | Assignment | Start Date | Hours
Sky | Stat Holiday | 2024-10-14 00:00:00 | 7.5
Sky | Stat Holiday | 2024-12-23 00:00:00 | 15
Nia | Stat Holiday | 2024-10-14 00:00:00 | 7.5
Nia | Stat Holiday | 2024-12-23 00:00:00 | 15
[NAME] | Stat Holiday | 2024-10-14 00:00:00 | 7.5
[NAME] | Stat Holiday | 2024-12-23 00:00:00 | 15
Sky | Vacation | 2024-10-07 00:00:00 | 7.5
Sky | Project ABC | 2024-10-14 00:00:00 | 37.5
Sky | Project ABC | 2024-10-21 00:00:00 | 10
Nia | Project ZYZ | 2024-09-30 00:00:00 | 37.5
Nia | Project ZYZ | 2024-10-07 00:00:00 | 37.5
Nia | Vacation | 2024-10-21 00:00:00 | 37.5
[NAME] | Project ZYZ | 2024-10-07 00:00:00 | 17.5
[NAME] | Project ZYZ | 2024-10-14 00:00:00 | 17.5
[NAME] | Project ZYZ | 2024-10-21 00:00:00 | 27.5
Spreadsheet: james_steffes__12912__EGS Contract Update Form
Sheet: End Notes

 | SUPPLIER COMPANY CONTACTS
 | Item |  |  | Description
 | Company Name; d/b/a and License Number |  |  | Enter in shaded area of form starting in column 'C'.
 | Date Submitted |  |  | Enter in shaded area of form at column 'K'. e.g. 09/01/1999. (Format has been preset.)
 | Phone, FAX and Zip Code |  |  | Enter these numbers without punctuation e.g.       [PHONE]
 | Company License Number |  |  | This will be in either of the following formats:                  A-110XXX or A-125XXX.
 | Statutory Agent | (1) |  | Company designate to receive service or process of legal matters in the Commonwealth.
 | CEO/President | (2) |  | Information for current CEO/President of the company.
 | [NAME] | (3) |  | Who may the Commission contact regarding questions about the application or the entity.
 | Tariff Contact | (4) |  | Who may the Commission contact regarding the Company's Tariff?
 | Annual Reports | (5) |  | Who may the Commission contact regarding the annual report?
 | Assessments | (6) |  | Who may the Commission contact regarding the annual assessment?
 | PEMA Contact | (7) |  | Pennsylvania Emergency Management Agency contact person who is available on a 24 hour 7 day basis.
 | Customer Service | (8) |  | When residential or small commercial customers are served the company must provide a customer contact person and phone number.
 | Legal Counsel | (9) |  | Who may the Commission contact regarding legal issues?
 | Complaints Contact | (10) |  | Who may the Commission contact for information about customer billing, rates charged, service provided or other types of complaints?
 | EDI Transactions | (11) |  | Identify the Electronic Data Interexchenge contact person with responsibility for the development and maintenance of EDI transactions.
 | Electric Phase-In Committee | (12) |  | Identify the company's representative on the electric phase-in committee.
Spreadsheet: 116639d1311962231-designing-a-survey-in-excel-and-vb-questionnaire-on-nat-testing-of-blood-donations
Sheet: 6. HBV

 |  | HBV test results |  |  |  |  | HBV test results | 0
 |  | HBV test results
 |  | Confirmed HBsAg positive during the indicated year*
 |  | Donations from first time tested donors**, number
 |  | Donations from repeat tested donors***, number
 |  |  |  |  |  |  | Confirmed HBsAg positive*
 |  | HBsAg and anti-HBc and NAT positive during the indicated year |  |  |  |  | Donations from first time tested donors**, number | 0
 |  |  |  |  |  |  | Donations from repeat tested donors***, number | 0
 |  | Donations from first time tested donors**, number
 |  |  |  |  |  |  | HBsAg and anti-HBc and NAT positive
 |  | Donations from repeat tested donors***, number |  |  |  |  | Donations from first time tested donors**, number | 0
 |  |  |  |  |  |  | Donations from repeat tested donors***, number | 0
 |  | HBsAg and NAT positive, anti-HBc negative during the indicated year |  |  |  |  | HBsAg and NAT positive, anti-HBc negative
 |  |  |  |  |  |  | Donations from first time tested donors**, number | 0
 |  | Donations from first time tested donors**, number |  |  |  |  | Donations from repeat tested donors***, number | 0
 |  | Donations from repeat tested donors***, number
 |  | *           Confirmed HBsAg positive: Repeatedly reactive ([NAME] 2 times reactive) in a screening test plus
 |  | positive in a confirmatory assay (e. g. neutralisation, anti-HBc, NAT).
 |  | **         Donations from first time tested donors: From a person who was tested for the first time
 |  | without report of prior serological testing in the blood establishment.
 |  | ***       Donations from repeat tested donors:
 |  | From a donor who has been subjected to previous serological testing in a given blood establishment.
 |  |  |  | Page 28 of 34
Spreadsheet: 33679d1230250366-problem-with-showing-rows-and-columns-in-a-pivot-table-pivot-20table-20example-1-1
Sheet: Article ID

Article ID | Exp 1 | Exp 2 | Exp 3 | Exp 4 | Exp 5
1 | 0.02 | 0.54 | 0.25 | 0.35 | 0.65
2 | 1.02 | 0.84 | 0.65 | 0.15 | 0.95
3 | 0.52 | 0.44 | 0.28 | 0.3 | 0.62
4 | 0.2 | 0.35 | 0.18 | 0.45 | 0.85
5 | 1.36 | 1.58 | 1.8 | 2.02 | 2.24
6 | 1.52 | 1.051 | 0.582 | 0.113 | -0.356
7 | 0.52 | 1.166 | 1.812 | 2.458 | 3.104
8 | 0.48 | 1.281 | 2.082 | 2.883 | 3.684
9 | 0.09 | 1.396 | 2.702 | 4.008 | 5.314
10 | 1.62 | 1.511 | 1.402 | 1.293 | 1.184
11 | 18 | 1.626 | -14.748 | -31.122 | -47.496
12 | 0.98 | 1.741 | 2.502 | 3.263 | 4.024
13 | 1.01 | 1.856 | 2.702 | 3.548 | 4.394
 | 27.34 | 15.378 | 2.196000000000001 | -10.286 | -20.838
Spreadsheet: 731956d1620714850-formula-to-split-holidays-and-rest-days-split-dates
Sheet: Sheet1

 | Holidays | 07+29
 | Rest Days | Other Dates
Employee ID | Dates | Holidays | Rest Days
1 | 29+07 | 07+29 |  |  |  |  | Could you help me in my question ,please?
2 | 21+28+29 | 29 | 21+28 |  |  |  | I want to split dates of Holidays and Rest Days from Column B
3 | 19+29 | 29 | 19 |  |  |  | Dates of Holidays are in Cell "C1"
4 | 29 | 29 |  |  |  |  | Rest days are remaining dates written in column B after removing [NAME]
5 | 29 | 29 |  |  |  |  | Office 365
6 | 29 | 29
7 | 29 | 29
8 | 04+29 | 29 | 04
9 | 10 |  | 10
10 | 29 | 29
11 | 29 | 29
12 | 24+29 | 29 | 24
13 | 29 | 29
14 | 29 | 29
15 | 29 | 29
16 | 29 | 29
17 | 29 | 29
18 | 29 | 29
19 | 29 | 29
20 | 29 | 29
21 | 26+29 | 29 | 26
22 | 29 | 29
23 | 13+17+24+29 | 29 | 13+17+24
24 | 05+12+18+19+26 |  | 05+12+18+19+26
25 | 29 | 29
26 | 29 | 29
27 | 29 | 29
28 | 29 | 29
29 | 29 | 29
30 | 29 | 29
31 | 09+10+17+29+30 | 29 | 09+10+17+30
32 | 29 | 29
33 | 24 |  | 24
34 | 29 | 29
35 | 29 | 29
36 | 13+28+29+07 | 07+29 | 13+28
37 | 29+07 | 07+29
38 | 29+07 | 07+29
39 | 29+07 | 07+29
40 | 29+07 | 07+29
41 | 29+07 | 07+29
42 | 29+07 | 07+29
43 | 29+07 | 07+29
44 | 29+07 | 07+29
45 | 29+07 | 07+29
46 | 29 | 29
47 | 29 | 29
48 | 14+15+27 |  | 14+15+27
49 | 16+17+24+29+30 | 29 | 16+17+24+30
50 | 29 | 29
51 | 18+19+25+26+29 | 29 | 18+19+25+26
52 | 16+17+23+24+29 | 29 | 16+17+23+24
53 | 29 | 29
54 | 02+03+09+10+16+17 | 29 | 02+03+09+10+16+17
55 | 29 | 29
Spreadsheet: 833867d1687294987-return-an-entire-table-or-range-of-values-using-xlookup-or-another-formula-function-template-sample
Sheet: Ops Analyst

Program | 2
 | Jan | Feb | March | April | May | June
Phase I
SQL |  |  |  |  |  | Complete
VBA |  |  |  |  |  | Complete
Excel
Communication |  |  |  |  |  | Complete
Phase II
Advanced SQL
Python |  |  |  | Complete
Spreadsheet: 724450d1616164986-multiple-if-with-and-formula-but-one-of-the-options-is-not-returning-correct-outcome-book2
Sheet: Sheet1

Long/Short? | Trend Directon | Points
Long | Uptrend
Long | Sidetrend
Long | Downtrend
Short | Uptrend
Short | Sidetrend
Short | Downtrend
Spreadsheet: daren_farmer__6608__TransportFlash
Sheet: 9902

February 1999 Transport Expense Flash
 |  |  | Commodity Expenses |  |  |  | Comments
Texas Co. 78 |  |  |  |  |  |  | Long term deal commodity expense
Texas Co. 78 |  |  | 1240 |  |  |  | payable to Pan Grande Pipeline (078-67235-14-001)
Texas Co. 16 |  |  | 11606 |  |  |  | payable to Black Marlin (016-09135-02-005/006)
Texas Co. 16 |  |  | 18875 |  |  |  | payable to Amoco Gas Company (012-87103-02-002)
Texas Co. 16 |  |  | 132639 |  |  |  | payable to [NAME] (016-65890-02-022/27)
Texas Co. 16 |  |  | 43476.925 |  |  |  | payable to PG&E/Valero (016-66947-02-004/10)
Texas Co. 16 |  |  | 12400 |  |  |  | payable to Channel Industries
Texas Co. 16 |  |  |  |  | 98300 |  | Centana Storage Demand Charge
 |  |  |  |  |  |  | ***booked as an annuity and is located in financial price
Totals
Spreadsheet: 30441d1225950367-sumproduct-with-different-ranges-widgets
Sheet: Locations

Location 1
Widgets | Count1 | Count2 | Count3
A | 2 | 0 | 2
C | 1 | 4 | 2
D | 0 | 2 | 3
 | 9 | 8 | 16
 | #N/A
Spreadsheet: 476176d1471647857-vba-for-row-height-to-stay-with-data-test
Sheet: Sheet1 (2)

Header 1 | [NAME] | [NAME]
Fake data | Fake data
Fake data | Blue
Fake data | Blue
Fake data | Blue
Fake data | Yellow
Fake data | Yellow
Fake data | Fake data
Fake data | Fake data
Fake data | Yellow 2
Fake data | Yellow 2
Fake data | Green
Fake data | Fake data
Spreadsheet: 698560d1602054155-dependent-dropdown-list-problem-book2
Sheet: Event

No | Admin1 [NAME] | Admin2 NAME | Admin3 NAME | Admin4 NAME | Admin1 CODE | Admin2 CODE | Admin3 CODE | Admin4 CODE
1 | [NAME] | Asahan | Meranti | Serdang
2 | [NAME] | [NAME] | Meranti | Kelampai Setolo
3
4