tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 843954d1695767094-grab-the-3-rightmost-values-in-a-row-which-will-then-be-used-for-an-average-sample-football
Sheet: Sheet1

Player | Matches played | Recent form | Average
Player A |  |  |  |  |  |  |  |  |  |  | 7.75
Player B |  |  |  | 5
Player C |  |  |  | 5 |  | 5 |  | 4.5 |  | 5.25
Player D |  |  |  | 7 | 6.5 | 7.25 |  | 6.25 | 6.75 | 6.75 | 6.75
Player E |  |  |  | 5 | 5.5 |  |  | 5.5 | 5.25 | 5.5
Player F |  |  |  |  | 4.5 | 5 |  | 5.25 | 5.5 | 5.5 | 5.75
Player G |  |  |  | 6 | 6.5 | 5 |  | 6.5 |  | 7.25 | 7.25
Player H |  |  |  | 3.5 | 3 | 2 |  |  | 3 |  | 3.5
Player I |  |  |  |  | 8.5 |  |  |  |  |  | 8.5
Player J |  |  |  | 4.5 | 3.5 | 2.5 |  | 4 | 3.25 |  | 3.75
Player K |  |  |  | 5 | 3.5 | 4 |  |  |  |  | 3.75
Player L |  |  |  |  |  | 7.5 |  |  | 7.5 | 8
Player M |  |  |  |  |  |  |  |  | 6.5 | 5.75
Player N |  |  |  |  |  | 8.25 |  | 8.25 |  | 8 | 8
Player O |  |  |  |  |  |  |  |  | 6.75
Player P |  |  |  | 8 | 7.5 |  |  | 8.25 | 8 | 7
Player Q |  |  |  | 6 | 6 | 6 |  | 7 | 6.25 | 7.25 | 6.75
Player R |  |  |  |  |  |  |  | 5
Spreadsheet: sally_beck__33763__NA GAS AND POWER-REGION BREAKOUT 08-30-00 EM
Sheet: US POWER CHARTS

ENRON - POWER
AVERAGE EOL AND NON-EOL TRANSACTIONS PER DAY
REGION BREAKOUT
As of August 30, 2000
 |  | AVERAGE DEALS PER DAY
MONTH | DAYS | EOL | NON-EOL | TOTAL
1999-12-01 00:00:00 | 21 | 7 | 164 | 171
2000-01-01 00:00:00 | 20 | 58 | 422 | 480
2000-02-01 00:00:00 | 20 | 87 | 421 | 509
2000-03-01 00:00:00 | 23 | 108 | 460 | 568
2000-04-01 00:00:00 | 19 | 128 | 492 | 620
2000-05-01 00:00:00 | 22 | 93 | 442 | 534
2000-06-01 00:00:00 | 22 | 96 | 407 | 503
2000-07-01 00:00:00 | 19 | 152 | 473 | 626
2000-08-01 00:00:00 | 22 | 185 | 501 | 685
TOTAL AVERAGE | 188 | 101 | 420 | 521
REGION BREAKOUT (Region breakout based on deal locations)
Spreadsheet: 101805d1299850927-extracting-specifics-from-xls-file-excel-2003-pl-replacements-1100-and-1200
Sheet: 1207-BB 114

Phase | Project No. | Segment ID (GIE) | Route No. | Facility Type | Pipe O.D., in. | Segment Length, ft | Proposed [NAME] | Proposed End M.P. | Proposed total length, ft. | Proposed [NAME], in. | Segment Length per Construction Classification, ft |  |  | Bored Crossings |  | HDDs |  | Potential Re-route | Move-arounds | Comments, notes, assumptions
 |  |  |  |  |  |  |  |  |  |  | Non-cong. | Semi-cong. | High-cong. | Q-ty | Length, Feet | Q-ty | Length, Feet | Yes/No | Q-ty |  | [NAME] | MP1 | MP2 | JNTEFF | GIRTH_WELD | LONG_SEAM | JOINT_TYPE | [NAME] | W_THICK | TEST_DATE | TEST_PRESS | [NAME] | TEST_DUR | MAOP | SMYS_MAOP | MOP | SMYS_MOP | YR_INSTALL | CLASSESENT | HCA_ID | SCC_THREAT | MANU_HREAT | CONSTHREAT | OF_THREAT | HS_THREAT | Legend Name | PerSMYS | TestPer | Sub_J | Fab_Note | Threat | Seismic | Object_ID | Shape_Length
1 | 1207 | 5181 | 114 | BB | 22 | 46 | 14.34 | 14.35 | 46 | 22 |  | 46 |  |  |  |  |  |  |  |  | 131.6 | 14.34 | 14.35 | 1.000 | ARC |  |  | -33000 | 0.286 |  | 0 |  | 0 | 0 | -9 | 497 | -57.9254 | 1966-03-25 00:00:00 | 3 | A5 | No | Yes | No | Yes | No | ManuNoTestHCA | -57.93 | 0 | N |  |  |  | 8246 | 12.49562066575578
2 | 1207 | 5110 | 114 | BB | 22 | 336 | 13.75 | 13.814 | 336 | 22 |  | 336 |  | 1 | 220 |  |  |  |  |  | 131.1 | 13.75 | 13.814 | 1.000 | ARC | SMLS | BBCR | 35000 | 0.3125 | 1958-08-01 00:00:00 | 810 | W | 0 | 497 | 49.984 | 497 | 49.984 | 1942-01-01 00:00:00 | 3 | I5 | No | Yes | Yes | Yes | No | FabGM2 | 49.98 | 1.63 | Y | Fab3 1-25-11 Liq | Fab&Con | Seismic Step | 17904 | 110.7642873423523
2 | 1207 | 5164 | 114 | BB | 22 | 16 | 14.35 | 14.35 | 16 | 22 |  | 16 |  |  |  |  |  |  |  |  | 131.8 | 14.35 | 14.35 | 1.000 | ARC | SMLS | BBCR | 35000 | 0.3125 | 1958-08-01 00:00:00 | 810 | W | 0 | 497 | 49.984 | 497 | 49.984 | 1942-01-01 00:00:00 | 3 | A5 | No | Yes | Yes | Yes | No | FabGM2 | 49.98 | 1.63 | Y | Fab3 1-25-11 Liq | Fab&Con | Seismic Step | 8477 | 4.874359352174618
Spreadsheet: 95168d1294844123-excel-2007-minimum-taxes-calculation-worksheet-kentucky-taxes
Sheet: Counties

Commonwealth of Kentucky
Local Government Premium Taxes
2010 - 2011  Schedule
Tax Code |  | All Other Risk Taxed | Min Tax
B | Anderson County | 0.04
E | Bell County | 0
30 | Breckinridge County | 0.05
A | Bullitt County | 0.05
 | Campbell County | 0.1
 | Carter County | 0.045
 | Casey County | 0.06
 | Clark County | 0.04
 | Crittenden County | 0.02
N-E-12 | Daviess County | 0
 | Elliott County | 0.06
36 | Fleming County | 0.06
 | Franklin County | 0.06
B-04 | Fulton County | 0.03 | 10
34 | Garrard County | 0.06
 | Henderson County | 0.08
A | Hopkins County | 0.1
 | Jackson County | 0.05
P-A | Jefferson County | 0.05
L-35 | Kenton County | 0.08 | 5
 | Lewis County | 0.06
D | Lexington-Fayette | 0.05 | 5
A-31 | Mason County | 0.07
A | Meade County | 0.05
 | Menifee County | 0.03
23 | Morgan County | 0.045
 | Oldham County | 0.1
18 | Owen County | 0.055
 | Owsley County | 0.07
38 | Powell County | 0.05
C-A | Pulaski County | 0.055 | 5
 | Rockcastle County | 0.04
 | Spencer County | 0.04
12 | Todd County | 0.06
 | Trigg County | 0.06
B | Washington County | 0.04 | 10
A | Wayne County | 0.05
Spreadsheet: 2585d31f-cb75-4ebd-8111-59624db35525
Sheet: Food Proc

 | BAKERY
 | Name of Co-Operative | File no. | Product Classification
1 | [NAME] | 7 | [NAME]
2 | Sizimisele Bakery Primary Co-op | 23 | [NAME]
3 | Masilinge Baking Project | 55 | [NAME]
4 | Zanekhono Baking & Multipurpose | 86 | [NAME]
5 | Shukushukuma Bakery | 119 | [NAME]
6 | Singenile Madladla Bakery co-op. Ltd. | 202 | [NAME]
 | DAIRY
 | Name of Co-Operative | File no. | Product Classification
1 | O.R. Tambo Dairy Co-operative | 5 | P1100
2 | Ikhwezi Dairy Co-operative | 11 | P1100
 | RED MEAT
 | Name of Co-Operative | File no. | Product Classification
1 | Nyanisweni Red Meat Project | 47 | P1180
 | HONEY
 | Name of Co-Operative | File no. | Product Classification
1 | [NAME] co-op | 135 | P2070
Spreadsheet: a2a4d011-de85-4799-b901-0ace3e42e125
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SNOWSHOE | T1 | SKATE | T2 | SKI | POSITION | TOTAL TIME
2876 | 7616 | [NAME] | Springman | GBR | 138 | 00:15:09 | 00:00:36 | 00:45:03 | 00:01:31 | 00:32:50 | 1 | 01:35:09
2876 | 15755 | Rita | Käshammer | GER | 139 | 00:16:17 | 00:00:49 | 00:46:45 | 00:02:04 | 00:29:58 | 2 | 01:35:53
2876 | 15475 | Petra | Scholler | GER | 136 | 00:17:08 | 00:01:20 | 00:45:46 | 00:02:57 | 00:32:45 | 3 | 01:39:56
2876 | 15757 | Gigliola | Colautti | ITA | 137 | 00:16:27 | 00:00:41 | 00:45:55 | 00:02:03 | [NAME] | 4 | 01:41:03
2876 | 10254 | Luisella | [NAME] | ITA | 140 | 00:16:18 | 00:00:55 | 00:51:05 | 00:01:59 | 00:35:45 | 5 | 01:46:02
Spreadsheet: daren_farmer__5334__June_Hours_Survey
Sheet: Hours

 | 1840
 | Manager
RC | Position | Activity Name | Last Month | Hours
1840 | Manager | Ad Hoc Reqs | 0
1840 | Manager | [NAME] | 0
1840 | Manager | Attach [NAME] to SITARA Deal | 0
1840 | Manager | Bid Week Preparation | 0
1840 | Manager | [NAME] | 0
1840 | Manager | [NAME] | 0
1840 | Manager | Chk deal for reasonable | 0
1840 | Manager | Commercial Related Projects | 0
1840 | Manager | Curve Setup | 0
1840 | Manager | Deal Movement | 0
1840 | Manager | [NAME] | 0
1840 | Manager | EOL Risk Management Support | 0
1840 | Manager | Maintain Tickets/ Rate Table | 0
1840 | Manager | [NAME] | 0
1840 | Manager | Monitor Sitara Bridge Forward | 0
1840 | Manager | New Cntrprty Notif | 0
1840 | Manager | New Contract Req Notif | 0
1840 | Manager | Participate in Training | 0
1840 | Manager | Performance Feedback | 0
1840 | Manager | Preventative OA | 0
1840 | Manager | [NAME] | 0
1840 | Manager | Research Deals | 0
1840 | Manager | Service P&L | 0
1840 | Manager | Special Projects-Administrative | 0
1840 | Manager | System Downtime | 0
1840 | Manager | [NAME] | 0
1840 | Manager | Verify Cparty on Deal | 0
Spreadsheet: theresa_staab__39608__north central purchase detail 2001
Sheet: Jan 01

North Central Oil | Contact: | [NAME] |  |  | Enron North America
 | PH: | (713) 268-4532
 | FAX: |  |  |  | [NAME] | PH:  [PHONE]
 | E-Mail: | [EMAIL] |  |  |  | FAX:  [PHONE]
January, 2001
First of Month Nomination: | 27049
Btu factor
Transportation | 0.14 | per [NAME] (25,000/d)
IF CIG Index | 8.63
 |  | Index Discount/Premium | Lost Creek Transport/MMBtu | Total Net Back
Net Backs: | CIG GD | 0.03 | -0.14141417487
 | Firm Quantity | 0 | -0.14141417487
 | IF CIG (90%) | 0.04 | -0.14141417487
 |  | 90% of FOM Nom. Less Firm Quantity | 90% of FOM less Firm Quantity | Firm Quantity | Firm Quantity Volume MMBtu | GD Volume | CIG GD Volume MMBtu |  | Total [NAME] | $ CIG +.04 | $ [NAME] | $ CIG GD | Total Payment
 | CIG GD Rockies | IF CIG less Netback |  | CIG less Netback | 15000 | [NAME] less Netback
2001-01-01 00:00:00 | 8.875 |  |  |  |  |  |  |  | 26778.51
 | 8.875 |  |  |  |  |  |  |  | 26778.51
 | 8.05 |  |  |  |  |  |  |  | 26778.51
 | 8.545 |  |  |  |  |  |  |  | 26778.51
 | 8.58 |  |  |  |  |  |  |  | 26778.51
 | 8.72 |  |  |  |  |  |  |  | 26778.51
 | 8.72 |  |  |  |  |  |  |  | 26778.51
 | 8.72 |  |  |  |  |  |  |  | 26778.51
 | 9.435 |  |  |  |  |  |  |  | 26778.51
 | 8.905 |  |  |  |  |  |  |  | 27171.54
 | 9.175 |  |  |  |  |  |  |  | 27171.54
 | 8.515 |  |  |  |  |  |  |  | 27171.54
 | 8.455 |  |  |  |  |  |  |  | 27171.54
 | 8.455 |  |  |  |  |  |  |  | 27171.54
 | 8.455 |  |  |  |  |  |  |  | 27171.54
 | 8.455 |  |  |  |  |  |  |  | 27171.54
 | 8.05 |  |  |  |  |  |  |  | 21012.75
 | 7.61 |  |  |  |  |  |  |  | 24687.63
 | 6.965 |  |  |  |  |  |  |  | 25667.73
 | 7.39 |  |  |  |  |  |  |  | 25667.73
 | 7.39 |  |  |  |  |  |  |  | 25667.73
 | 7.39 |  |  |  |  |  |  |  | 25667.73
 | 7.545 |  |  |  |  |  |  |  | 25667.73
 | 6.775 |  |  |  |  |  |  |  | 25667.73
 | 6.725 |  |  |  |  |  |  |  | 24687.63
 | 7.26 |  |  |  |  |  |  |  | 24687.63
 | 6.81 |  |  |  |  |  |  |  | 24163.92
 | 6.81 |  |  |  |  |  |  |  | 24163.92
 | 6.81 |  |  |  |  |  |  |  | 24163.92
 | 6.55 |  |  |  |  |  |  |  | 25144.02
 | 5.68 |  |  |  |  |  |  |  | 25144.02
 |  |  |  |  |  |  |  |  | avg. $/MMBtu
Spreadsheet: 767489d1644497783-vlookup-doesnt-work-here-is-there-another-formula-example-5-
Sheet: Sheet1

From [NAME] | price |  |  | On System | Price
12580R13 65M | 123 |  |  | 12580R13 M
12580R13 65Q | 124 |  |  | 12580R13
13570R15 70T | 125 |  |  | 13570R15 T
14565R15 72T | 126 |  |  | 14565R15 T
14565R15 72Y | 127 |  |  | 14565R15 72Y
14570R13 71T | 128 |  |  | 14570R13
14580R13 75M | 129 |  |  | 14580R13 M
14580R13 75Q | 130 |  |  | 14580R13 Q
14580R14 76T | 131 |  |  | 14580R14 76T
15560R15 74T | 132 |  |  | 15560R15
15565R15 74T | 133 |  |  | 15565R15 74T
15560R20 80Q | 134 |  |  | 15560R20
15565R13 73T | 135 |  |  | 15565R13 73T
15565R13 73Y | 136 |  |  | 15565R13 Y
Spreadsheet: 691785d1597870015-creating-student-ids-from-student-information-excel
Sheet: Sheet1

Date requested | ID | First name | Last Name | Date of Birth |  |  |  |  | Place of Birth | Agent | School | Program | Visa | Notes
2020-03-16 00:00:00 |  | [NAME] | Smith | 05-07-1990
2020-03-16 00:00:00 |  | [NAME] | Smith | 26-05-2001
2020-03-17 00:00:00 |  | [NAME] | [NAME] | 03-02-1997
2020-03-17 00:00:00 |  | [NAME] | [NAME] | 01-02-1994
2020-03-17 00:00:00 |  | [NAME] | Scott | 21-09-2000
2020-03-17 00:00:00 |  | Sasha | Scott | 19-01-2001
2020-03-17 00:00:00 |  | [NAME] | Atwood | 25-12-2000
2020-03-17 00:00:00 |  | Sara | Atwood | 17-04-2002
2020-03-18 00:00:00 |  | [NAME] | Jones | 23-03-1994
2020-03-18 00:00:00 |  | Sara | Jones | 23-06-2001
2020-03-19 00:00:00 |  | Bethany | Swim | 23-09-1996
2020-03-20 00:00:00 |  | Jake | Swim | 02-02-1996
2020-03-20 00:00:00 |  | [NAME] | Swim | 24-08-2001
2020-03-23 00:00:00 |  | Maria | Pirell | 26-04-2001
Spreadsheet: eric_saibi__9920__102601R
Sheet: Peach Bottom 02

Owner Name |  | Exelon Nuclear
Station Name |  | Peach Bottom Nuclear Power Station
Unit Name |  | Peach Bottom 02
NERC Region |  | MAAC
State |  | PA
Fuel Type |  | Nuclear
Capacity |  | 1,152 MW
Start Date |  | 2001-10-23 00:00:00
End Date |  | 2001-10-28 00:00:00
Prv. Start Date |  | 2001-10-23 00:00:00
Prv. End Date |  | 2001-10-26 00:00:00
Comments |  | Generator problem. Hoping to come back on line this weekend.
SIC |  | 4911
Plant ID |  | 1000282
Unit ID |  | 1005385
Outage ID |  | 18712
Spreadsheet: 116835d1312214549-if-function-between-sheets-with-text-and-numbers-load-board
Sheet: CAT

Driver # | Book Date | Company | Load # | [NAME] | Fuel | [NAME] | Shared | PU Date | PU Time | City, State | Drop Date | Drop Time | City, State | Truck | Trailer #(s) | Percentage | BOLs | Location? | Billed
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Received? | CH or ME or DM
CAT001 | 2011-07-26 00:00:00 | [NAME] | 102407050 |  |  | 40 |  | 2011-07-26 00:00:00 | 08:00:00 | Chanhassen, MN | 2011-07-27 00:00:00 | 09:00:00 | St Louis, MO | 4 | 843530
CAT002 | 2011-07-25 00:00:00 | CH [NAME] | 94950354 | 750 | 732 |  | [NAME] | 2011-07-26 00:00:00 | Apt | Alsip, IL | 2011-07-27 00:00:00 | 6:00 - 14:00 | Albertville, MN | 1 | 843530
Spreadsheet: 695209d1600098966-index-match-if-then-list-alphabetically-eg-1
Sheet: Sheet1

TASK NAME | TASK FREQUENCY |  | LISTED | TASK FREQUENCY | Expected Results
APO0001 | 10 |  | APO0001
APO0002 | 5 |  | APO0002
CPO0001 |  |  | CPO0002
CPO0002 | 3 |  | CPO0003
CPO0003 | 7 |  | SPH0002
[NAME]
SPH0002 | 5
Spreadsheet: andy_zipper__600__11_20_01LO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | CL F2 | 19 | 260 | 275 | 67.1 | 71 | 0.82 | 2001-11-20 11:50:00
 | CL G2 | 19.5 | 365 | 380 | 59.8 | 62.3 | 0.75 | 2001-11-20 11:50:00
 | CL H2 | 19.5 | 425 | 440 | 57 | 59 | 0.71 | 2001-11-20 11:50:00
 | CL J2 | 19.5 | 470 | 480 | 54.7 | 55.9 | 0.68 | 2001-11-20 11:50:00
 | CL K2 | 19.5 | 505 | 520 | 52 | 53.6 | 0.65 | 2001-11-20 11:50:00
 | CL M2 | 20 | 525 | 535 | 48.4 | 49.3 | 0.61 | 2001-11-20 11:50:00
 | CL N2 | 20 | 530 | 550 | 45.2 | 46.9 | 0.58 | 2001-11-20 11:50:00
 | CL Q2 | 20 | 535 | 560 | 42.8 | 44.8 | 0.55 | 2001-11-20 11:50:00
 | CL U2 | 20 | 540 | 565 | 40.9 | 42.8 | 0.53 | 2001-11-20 11:50:00
 | [NAME] | 20 | 545 | 570 | 39.2 | 41 | 0.5 | 2001-11-20 11:50:00
 | CL X2 | 20.5 | 545 | 580 | 36.6 | 39 | 0.49 | 2001-11-20 11:50:00
 | [NAME] | 20.5 | 545 | 575 | 35.2 | 37.2 | 0.47 | 2001-11-20 11:50:00
 | CL M3 | 21 | 550 | 590 | 29.1 | 31.3 | 0.4 | 2001-11-20 11:50:00
 | CL Z3 | 21 | 540 | 600 | 25.3 | 28.2 | 0.35 | 2001-11-20 11:50:00
 | CL M4 | 21.5 | 540 | 610 | 22.7 | 25.6 | 0.33 | 2001-11-20 11:50:00
Spreadsheet: 852803d1702748243-index-match-array-returning-duplicate-values-test
Sheet: Sheet1

 |  |  | Service Average Scores | Self Determination | Emotional Well-being | Physical Well-being | Material Well-being | Rights | Personal Development | Social Inclusion | Interpersonal Relationships
 |  |  |  | 3 | 4 | 5 | 4 | 4 | 3 | 2 | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  | SMALL | LARGE
Spreadsheet: 4e8bd856-dab1-4b41-869a-d143d1e7a1da
Sheet: Sheet1

Ponto | [NAME] | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Decimais | Unnamed: 10 | [NAME] | Unnamed: 12 | Unnamed: 13 | [NAME] | Unnamed: 15 | Unnamed: 16 | Decimais.1 | Unnamed: 18 | [NAME] | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25 | Coeficientes | Unnamed: 27 | Unnamed: 28 | Unnamed: 29 | Unnamed: 30 | Unnamed: 31 | Unnamed: 32 | Coordenadas planas UTM - SIRGAS2000 | Unnamed: 34 | Unnamed: 35
- | f |  |  | l |  |  | H | MC | f | l | X | Y | Z | X | Y | Z | f | l | f |  |  | l |  |  | H | I | IIP2 | IIIP4 | IVP | VP3 | A'6P6 | B'5P5 | E | N | H
- | ° | ´ | " | ° | ´ | " | m | ° | ° | ° | m | m | m | m | m | m | ° | ° | ° | ´ | " | ° | ´ | " | m | - | - | - | - | - | - | - | m | m | m
SAT91855 | -28 | 42 | 0.9864 | -49 | 24 | 31.5232 | 32.4 | -51 | -28.700274 | -49.40875644444444 | 3642980.470521461 | -4251653.102688352 | -3044830.773344991 | 3642913.120521461 | -4251649.222688352 | -3044868.993344991 | -28.70077464026685 | -49.40925398549955 | -28 | 42 | 2.788704960660766 | -49 | 24 | 33.31434779839299 | 32.59633553866297 | 3174834.743534501 | 1035.869187742709 | 0.2430179334089374 | 155382.6658662252 | 10.83421519535302 | 4.537071139452151e-05 | -0.0001472571036389581 | 655393.4999341634 | 6824129.144214451 | 32.59633553866297
Spreadsheet: 785581d1656502281-create-a-list-of-words-based-on-conditional-rule-oak-2122-56-termly-cew-analysis-sheet-updated
Sheet: Overview

Oak 21/22 | Overview Out of 103 Words |  |  |  |  |  |  |  |  |  |  | Number of Pupils |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17
Year 5/6 CEW Analysis Sheet | Cerys | [NAME] | Logan | Mason | Tilly | [NAME] | Ewan | Lilly-R | [NAME] | [NAME] | Jessica | Emma | [NAME] | [NAME] | Lilly | Ashton | Logan H |  |  |  |  |  |  |  |  |  |  |  | Class Average
Autumn 1
Autumn 2
Spring 1
Spring 2
Summer 1
Summer 2
Spreadsheet: 99297d1297971872-completing-tax-tables-nbvc-is-my-hero-
Sheet: Store Number EFIN 

EFIN | Store Number | Total Bank Returns | Total Prep Fees | 70% Commission | Plus $10 Add-On | Net
360758 | 168
361105 | 177
363809 | 228
368582 | 149
370647 | 237
370788 | 246
370789 | 245
370861 | 255
372613 | 87
372614 | 106
372615 | 113
372618 | 115
372619 | 83
372620 | 82
372714 | 147
372833 | 88
372834 | 136
372835 | 65
372983 | 153
372984 | 150
373199 | 167
373213 | 176
430806 | 212
431527 | 231
431531 | 230
431532 | 229
431657 | 234
431663 | 238
431666 | 242
432134 | 249
432213 | 289
433279 | 271
433319 | 279
433334 | 275
433725 | 284
435130 | 141
435135 | 138
435136 | 93
435137 | 72
435533 | 144
435534 | 79
435535 | 117
435536 | 139
435537 | 78
435539 | 94
435540 | 142
435541 | 85
435848 | 151
596952 | 258
620588 | 185
621074 | 219
621076 | 211
621097 | 221
621992 | 241
621993 | 240
622118 | 236
622452 | 288
622454 | 247
622558 | 260
622639 | 291
622640 | 251
622642 | 250
623686 | 263
625978 | 154
625979 | 157
625980 | 158
625981 | 156
625982 | 155
626698 | 162
626699 | 285
626700 | 159
626701 | 172
626702 | 171
626703 | 163
626704 | 286
626705 | 210
626706 | 170
626807 | 181
626808 | 178
626809 | 173
626811 | 182
630878 | 225
632460 | 248
632462 | 244
634258 | 264
634259 | 265
634262 | 266
634321 | 273
730200 | 294
730712 | 220
730716 | 209
730718 | 207
730719 | 206
730720 | 205
730721 | 213
730722 | 204
730723 | 203
730724 | 202
730725 | 201
730727 | 200
731358 | 233
732617 | 268
732620 | 269
732623 | 270
732630 | 278
733721 | 29
733999 | 92
734000 | 46
734001 | 48
734003 | 25
734004 | 140
734005 | 24
734006 | 95
740371 | 184
740373 | 186
740374 | 192
740375 | 187
740376 | 193
740380 | 194
740382 | 188
740385 | 259
740386 | 190
740387 | 183
740647 | 199
742804 | 235
745232 | 274
747234 | 63
747235 | 18
747236 | 76
747237 | 120
747239 | 127
747240 | 1
747241 | 7
747242 | 9
747243 | 110
747244 | 123
747245 | 12
747246 | 86
747247 | 68
747248 | 10
747250 | 5
747864 | 14
747866 | 4
747867 | 8
747868 | 119
747869 | 3
747870 | 124
747871 | 109
747872 | 2
747873 | 22
747874 | 6
747875 | 17
747876 | 11
748975 | 169
749238 | 175
759013 | 58
759015 | 160
759016 | 27
759019 | 114
759020 | 103
759021 | 36
759022 | 280
759023 | 26
759024 | 122
759025 | 111
759633 | 105
759636 | 71
759637 | 102
759638 | 116
759639 | 118
759641 | 28
759643 | 21
759644 | 23
759646 | 55
759647 | 15
760340 | 198
761128 | 218
761131 | 216
762385 | 281
762610 | 232
765115 | 283
765128 | 133
765130 | 189
767306 | 13
767307 | 20
767308 | 100
767310 | 91
767821 | 101
767822 | 43
767823 | 107
767824 | 108
768994 | 174
841638 | 287
841648 | 282
850046 | 195
850047 | 196
850049 | 197
850277 | 292
850659 | 276
851772 | 60
851773 | 84
851774 | 53
851775 | 125
851776 | 81
851777 | 64
851778 | 50
851779 | 62
851780 | 166
851781 | 130
851784 | 34
851964 | 32
851965 | 143
851966 | 44
851967 | 45
851968 | 129
851969 | 52
851970 | 51
851971 | 98
851972 | 59
851973 | 30
851975 | 49
851976 | 128
852298 | 180
880456 | 214
880989 | 243
881867 | 293
881868 | 57
881921 | 145
882047 | 73
882048 | 74
882049 | 70
882051 | 148
Spreadsheet: 698382d1601967534-re-formula-to-ignore-specific-text-during-cell-reference-from-pivot-data-sample-data
Sheet: Sheet2

OrderDate | Region | Rep | Item | Units | Unit Cost | Total
2019-01-06 00:00:00 | East | Jones | Pencil | 95 | 1.99 | -189.05
2019-01-23 00:00:00 | Central | Kivell | Binder | 50 | 19.99 | 999.4999999999999
2019-02-09 00:00:00 | Central | [NAME] | Pencil | 36 | 4.99 | 179.64
2019-02-26 00:00:00 | Central | [NAME] | Pen | 27 | 19.99 | 539.7299999999999
2019-03-15 00:00:00 | West | Sorvino | Pencil | 56 | 2.99 | 167.44
2019-04-01 00:00:00 | East | Jones | Binder | 60 | 4.99 | 299.4
2019-04-18 00:00:00 | Central | [NAME] | Pencil | 75 | 1.99 | 149.25
2019-05-05 00:00:00 | Central | [NAME] | Pencil | 90 | 4.99 | 449.1
2019-05-22 00:00:00 | West | Thompson | Pencil | 32 | 1.99 | 63.68
2019-06-08 00:00:00 | East | Jones | Binder | 60 | 8.99 | 539.4
2019-06-25 00:00:00 | Central | Morgan | Pencil | 90 | 4.99 | 449.1
2019-07-12 00:00:00 | East | [NAME] | Binder | 29 | 1.99 | 57.71
2019-07-29 00:00:00 | East | Parent | Binder | 81 | 19.99 | 1619.19
2019-08-15 00:00:00 | East | Jones | Pencil | 35 | 4.99 | 174.65
2019-09-01 00:00:00 | Central | Smith | Desk | 2 | 125 | 250
2019-09-18 00:00:00 | East | Jones | Pen Set | 16 | 15.99 | 255.84
2019-10-05 00:00:00 | Central | Morgan | Binder | 28 | 8.99 | 251.72
2019-10-22 00:00:00 | East | Jones | Pen | 64 | 8.99 | 575.36
2019-11-08 00:00:00 | East | Parent | Pen | 15 | 19.99 | 299.85
2019-11-25 00:00:00 | Central | Kivell | Pen Set | 96 | 4.99 | 479.04
2019-12-12 00:00:00 | Central | Smith | Pencil | 67 | 1.29 | -86.43
2019-12-29 00:00:00 | East | Parent | Pen Set | 74 | 15.99 | 1183.26
2020-01-15 00:00:00 | Central | [NAME] | Binder | 46 | 8.99 | 413.54
2020-02-01 00:00:00 | Central | Smith | Binder | 87 | 15 | 1305
2020-02-18 00:00:00 | East | Jones | Binder | 4 | 4.99 | 19.96
2020-03-07 00:00:00 | West | Sorvino | Binder | 7 | 19.99 | 139.93
2020-03-24 00:00:00 | Central | [NAME] | Pen Set | 50 | 4.99 | 249.5
2020-04-10 00:00:00 | Central | [NAME] | Pencil | 66 | 1.99 | 131.34
2020-04-27 00:00:00 | East | [NAME] | Pen | 96 | 4.99 | 479.04
2020-05-14 00:00:00 | Central | [NAME] | Pencil | 53 | 1.29 | 68.37
2020-05-31 00:00:00 | Central | [NAME] | Binder | 80 | 8.99 | 719.2
2020-06-17 00:00:00 | Central | Kivell | Desk | 5 | 125 | 625
2020-07-04 00:00:00 | East | Jones | Pen Set | 62 | 4.99 | -3096.43
2020-07-21 00:00:00 | Central | Morgan | Pen Set | 55 | 12.49 | -6876.43
2020-08-07 00:00:00 | Central | Kivell | Pen Set | 42 | 23.95 | -1005.43
2020-08-24 00:00:00 | West | Sorvino | Desk | 3 | 275 | -825
2020-09-10 00:00:00 | Central | [NAME] | Pencil | 7 | 1.29 | -9
2020-09-27 00:00:00 | West | Sorvino | Pen | 76 | 1.99 | 151.24
2020-10-14 00:00:00 | West | Thompson | Binder | 57 | 19.99 | 1139.43
2020-10-31 00:00:00 | Central | [NAME] | Pencil | 14 | 1.29 | 18.06
2020-11-17 00:00:00 | Central | [NAME] | Binder | 11 | 4.99 | 54.89
2020-12-04 00:00:00 | Central | [NAME] | Binder | 94 | 19.99 | 1879.06
2020-12-21 00:00:00 | Central | [NAME] | Binder | 28 | 4.99 | 139.72
Spreadsheet: 714482d1611243400-display-range-based-on-multiple-cell-values-test-cases-templates-sandbox2
Sheet: Sheet1

Test Scenario: | Copays
Retail Tiers: | 3
Mail Tiers:
Smart90:
VBID:
Excl Accredo:
Pricing Band:
Test Case Name/Description | Expected Results | Actual Results/Comments | Tester | Test Date | Status | Test Pharmacy NPI | Test Member ID
Spreadsheet: 169157d1342713797-pivot-table-excel-2003-suppress-zero-values-testpivot-ver-3
Sheet: Sheet1

DateRange | DataRange |  |  |  |  |  | DESIRED DISPLAY:
2000-01-31 00:00:00 | 10
2001-01-31 00:00:00 | 100 |  |  |  |  |  | Sum of Field1
2001-01-31 00:00:00 | -100 |  |  |  |  |  | DateRange | Total
2002-01-31 00:00:00 | 2000 |  |  |  |  |  | 2000-01-31 00:00:00 | 10
2002-01-31 00:00:00 | 2000 |  |  |  |  |  | 2002-01-31 00:00:00 | 2000
2002-01-31 00:00:00 | -2000 |  |  |  |  |  | Grand Total | 2010
2003-01-31 00:00:00 | 30000
2003-01-31 00:00:00 | -30000
 |  |  | CURRENT PIVOT TABLE
 | 8 |  | Sum of Field1
 | 5 |  | DateRange | Total |  | Filter
 |  |  | 2000-01-31 00:00:00 | 10 |  | 10
 |  |  | 2001-01-31 00:00:00 | 0 |  | 0
 |  |  | 2002-01-31 00:00:00 | 2000 |  | 2000
 |  |  | 2003-01-31 00:00:00 | 0 |  | 0
 |  |  | Grand Total | 2010