tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 175282d1345477033-latest-entry-based-upon-date-book2
Sheet: CodeHistory

[NAME] | Date | Code | Note
110242/M01 | 2012-08-17 00:00:00 | A | TEST
122013/M01 | 2012-08-13 00:00:00 | A | TEST
200456/M01 | 2012-08-13 00:00:00 | A | TEST
116927/M01 | 2012-08-13 00:00:00 | A | TEST
124234/M01 | 2012-08-13 00:00:00 | A | TEST
110834/M01 | 2012-08-13 00:00:00 | A | TEST
109705/M02 | 2012-08-13 00:00:00 | A | TEST
200912/M01 | 2012-08-13 00:00:00 | A | TEST
201472/M01 | 2012-08-13 00:00:00 | A | TEST
111879/M01 | 2012-08-13 00:00:00 | A | TEST
110819/M01 | 2012-08-13 00:00:00 | A | TEST
202334/M01 | 2012-08-13 00:00:00 | A | TEST
126923/M01 | 2012-08-13 00:00:00 | A | TEST
110604/M01 | 2012-08-13 00:00:00 | A | TEST
126334/M01 | 2012-08-13 00:00:00 | A | TEST
126340/M01 | 2012-08-13 00:00:00 | A | TEST
125839/M01 | 2012-08-13 00:00:00 | A | TEST
103919/M01 | 2012-08-13 00:00:00 | A | TEST
114775/M01 | 2012-08-13 00:00:00 | A | TEST
114196/M01 | 2012-08-13 00:00:00 | A | TEST
126213/M01 | 2012-08-13 00:00:00 | A | TEST
106219/M01 | 2012-08-13 00:00:00 | A | TEST
103067/M01 | 2012-08-13 00:00:00 | A | TEST
116101/M01 | 2012-08-13 00:00:00 | A | TEST
104649/M01 | 2012-08-13 00:00:00 | A | TEST
102618/M01 | 2012-08-13 00:00:00 | A | TEST
109019/M02 | 2012-08-13 00:00:00 | A | TEST
117071/M01 | 2012-08-13 00:00:00 | A | TEST
105565/M01 | 2012-08-13 00:00:00 | A | TEST
110242/M01 | 2011-09-23 00:00:00 | B | TEST2
122013/M01 | 2011-09-24 00:00:00 | B | TEST3
200456/M01 | 2011-09-25 00:00:00 | B | TEST4
116927/M01 | 2011-09-26 00:00:00 | B | TEST5
124234/M01 | 2011-09-27 00:00:00 | B | TEST6
110834/M01 | 2011-09-28 00:00:00 | B | TEST7
109705/M02 | 2011-09-29 00:00:00 | B | TEST8
200912/M01 | 2011-09-30 00:00:00 | B | TEST9
201472/M01 | 2011-10-01 00:00:00 | B | TEST10
111879/M01 | 2011-10-02 00:00:00 | B | TEST11
110819/M01 | 2011-10-03 00:00:00 | B | TEST12
202334/M01 | 2011-10-04 00:00:00 | B | TEST13
126923/M01 | 2011-10-05 00:00:00 | B | TEST14
110604/M01 | 2011-10-06 00:00:00 | B | TEST15
126334/M01 | 2011-10-07 00:00:00 | B | TEST16
126340/M01 | 2011-10-08 00:00:00 | B | TEST17
125839/M01 | 2011-10-09 00:00:00 | B | TEST18
103919/M01 | 2011-10-10 00:00:00 | B | TEST19
114775/M01 | 2011-10-11 00:00:00 | B | [NAME]
114196/M01 | 2011-10-12 00:00:00 | B | TEST21
126213/M01 | 2011-10-13 00:00:00 | B | TEST22
106219/M01 | 2011-10-14 00:00:00 | B | TEST23
103067/M01 | 2011-10-15 00:00:00 | B | TEST24
116101/M01 | 2011-10-16 00:00:00 | B | TEST25
104649/M01 | 2011-10-17 00:00:00 | B | TEST26
102618/M01 | 2011-10-18 00:00:00 | B | TEST27
109019/M02 | 2011-10-19 00:00:00 | B | TEST28
117071/M01 | 2011-10-20 00:00:00 | B | TEST29
105565/M01 | 2011-10-21 00:00:00 | B | TEST30
Spreadsheet: 807085d1669733876-calculate-sum-each-month-based-on-two-variables-sales-team-goals-asm-commission-calculator-2023
Sheet: vlookup

Quota per rep | 1650 |  |  | Quota per rep | 1650
# of Reps | 4 |  |  | # of Reps | 3 |  |  | Jan | 1
Monthly Team Quota |  |  |  | Monthly Team Quota |  |  |  | Feb | 2
 |  |  |  |  |  |  |  | Mar | 3
% of Team Goal Achieved | $6600 Monthly Quota | Monthly Payout |  | % of Team Goal Achieved | $6600 Monthly Quota | Monthly Payout |  | Apr | 4
125% + | $8250 or more | 2500 |  | 125% + | $6188 or more | 2500 |  | May | 5
100 - 124.99% | $6600 - $8249 | 1667 |  | 100 - 124.99% | $4950 - $6187 | 1667 |  | Jun | 6
75 - 99.99% | $4950 - $6599 | 1250 |  | 75 - 99.99% | $3713 - $4949 | 1250 |  | Jul | 7
50 - 74.99% | $3300 - $4949 | 850 |  | 50 - 74.99% | $2475 - $3712 | 850 |  | Aug | 8
0-49% | $3299 or less | 0 |  | 0-49% | $2474 or less | 0 |  | Sep | 9
 |  |  |  |  |  |  |  | Oct | 10
$6600 Quota (4 reps x $1650) |  |  |  | $4950 Quota (3 reps x $1650) |  |  |  | Nov | 11
Starting % Attainment | Payout |  |  | Starting % Attainment | Payout |  |  | Dec | 12
0 | 0 |  |  | 0 | 0
0.5 | 850 |  |  | 0.5 | 850
0.75 | 1250 |  |  | 0.75 | 1250
1 | 1667 |  |  | 1 | 1667
1.25 | 2500 |  |  | 1.25 | 2500
Spreadsheet: 824961d1680979835-array-formula-keep-using-the-1st-row-as-reference-question
Sheet: Sheet1

 |  |  | D |  |  |  | 100
A | 10
B | 20 |  |  |  | 70 | 60 |  |  |  |  |  |  | How come here still +p2 value?------> | 71 | 2
B | 30 |  |  |  | 80 | 60 |  |  |  |  |  |  | How come here still +p2 value?------> | 81 | 3
C | 40 |  |  |  | 90 | 60 |  |  |  |  |  |  | How come here still +p2 value?------> | 91 | 4
C | 50
D | 60
D | 70
D | 80
D | 90
Spreadsheet: 96769d1296062746-validation-lists-testvalidlist
Sheet: Entry

Employee Data Sample
Employee |  | Department |  | Hours Code
KRAUSE , MARVIN - 17238 |  | 101.01.2630 |  | R
LAMPMAN, BRENDA - 163336 |  | 101.01.2630 |  | RTEMP
ALDERSON, CHARITY - 186085 |  | 101.01.2630 |  | VT
ALLEN, SHAWNA - 184951 |  | 101.01.2630 |  | CT
[NAME], SARAH - 17583 |  | 101.01.2630 |  | OT
BITTNER, DANIEL - 15811 |  | 101.01.2630 |  | R
LASER, DEIDRE - 17233 |  | 101.01.2630 |  | R
MATUSCHKA, KOURTNEY - 193033 |  | 101.01.2630 |  | H
FELIX, JAMIE - 155616 |  | 101.14.3050 |  | R
Spreadsheet: 846169d1697462186-limit-number-of-entries-to-a-maximum-example
Sheet: Day 1

DAY
Area: | Supermarket A
Required No. | 3
Staff: | Staff ID | Skills
Staff 1 | 1111
Staff 2 | 1121
Staff 3 | 1123
Staff 4
Staff 5
Staff 6
Staff 7
Staff 8
Staff 9
Staff 10
Staff 11
Staff 12
Staff 13
Staff 14
Staff 15
Spreadsheet: 135045d1325773646-filtering-the-contents-of-a-dropdwon-list-ranaldproblem3-solution
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  | Restructured Table
 | Results table |  |  |  |  |  |  |  | Archive table
 | Item | Code |  |  |  |  |  |  | Item | Code |  |  | Toaster | House | [NAME] | Eggs | Milk
 | Toaster |  |  |  |  |  |  |  | Toaster | T1 |  |  | T1 | H1 | W1 | EGG001 | M1
 | [NAME] |  |  |  |  |  |  |  | House | H1 |  |  | T2 |  | [NAME] | EGG002 | M2
 | Eggs |  |  |  |  |  |  |  | [NAME] | W1
 |  |  |  |  |  |  |  |  | Eggs | EGG001
 |  |  |  |  |  |  |  |  | Milk | M1
 |  |  |  |  |  |  |  |  | [NAME] | [NAME]
 |  |  |  |  |  |  |  |  | Toaster | T2
 |  |  |  |  |  |  |  |  | Eggs | EGG002
 |  |  |  |  |  |  |  |  | Milk | M2
Spreadsheet: 48797d1248103819-need-to-delete-gaps-in-cells-postcodes-radio-stations
Sheet: Forth

Area: Radio Station - Forth One
Postcode
EH 1 1
EH 1 2
EH 1 3
EH 2 1
EH 2 2
EH 2 3
EH 2 4
EH 3 5
EH 3 6
EH 3 7
EH 3 8
EH 3 9
EH 4 1
EH 4 2
EH 4 3
EH 4 4
EH 4 5
EH 4 6
EH 4 7
EH 4 8
EH 5 1
EH 5 2
EH 5 3
EH 6 4
EH 6 5
EH 6 6
EH 6 7
EH 6 8
EH 7 4
EH 7 5
EH 7 6
EH 8 7
EH 8 8
EH 8 9
EH 9 1
EH 9 2
EH 9 3
EH 10 4
EH 10 5
EH 10 6
EH 10 7
EH 11 1
EH 11 2
EH 11 3
EH 11 4
EH 12 0
EH 12 5
EH 12 6
EH 12 7
EH 12 8
EH 12 9
EH 13 0
EH 13 9
EH 14 1
EH 14 2
EH 14 3
EH 14 4
EH 14 5
EH 14 6
EH 14 7
EH 15 1
EH 15 2
EH 15 3
EH 16 4
EH 16 5
EH 16 6
EH 17 7
EH 17 8
EH 18 1
EH 19 2
EH 19 3
EH 20 9
EH 21 6
EH 21 7
EH 21 8
EH 22 1
EH 22 2
EH 22 3
EH 22 4
EH 22 5
EH 23 4
EH 24 9
EH 25 9
EH 26 0
EH 26 8
EH 26 9
EH 27 8
EH 28 8
EH 29 9
EH 30 9
EH 31 2
EH 32 0
EH 32 9
EH 33 1
EH 33 2
EH 34 5
EH 35 5
EH 36 5
EH 37 5
EH 38 5
EH 39 4
EH 39 5
EH 40 3
EH 41 3
EH 41 4
EH 42 1
EH 46 7
EH 47 0
EH 47 7
EH 47 8
EH 47 9
EH 48 1
EH 48 2
EH 48 3
EH 48 4
EH 49 6
EH 49 7
EH 51 0
EH 51 9
EH 52 5
EH 52 6
EH 53 0
EH 54 5
EH 54 6
EH 54 7
EH 54 8
EH 54 9
EH 55 8
FK 1 1
FK 1 2
FK 1 3
FK 1 4
FK 1 5
FK 2 0
FK 2 7
FK 2 8
FK 2 9
FK 3 0
FK 3 8
FK 3 9
FK 4 1
FK 4 2
FK 5 3
FK 5 4
FK 6 5
FK 6 6
FK 13 6
FK 14 7
KY 1 1
KY 1 2
KY 1 3
KY 1 4
KY 2 5
KY 2 6
KY 3 0
KY 3 9
KY 4 0
KY 4 8
KY 4 9
KY 5 0
KY 5 8
KY 5 9
KY 6 1
KY 6 2
KY 6 3
KY 7 4
KY 7 5
KY 7 6
KY 8 1
KY 8 2
KY 8 3
KY 8 4
KY 8 5
KY 8 6
KY 9 1
KY 10 2
KY 10 3
KY 11 1
KY 11 2
KY 11 3
KY 11 4
KY 11 7
KY 11 8
KY 11 9
KY 12 0
KY 12 7
KY 12 8
KY 12 9
KY 13 0
KY 13 8
KY 13 9
Households & Population: 2001 Census, Small Area Statistics (Crown Copyright)
Spreadsheet: 713736d1610902359-formula-for-next-due-date-example-credit-cards
Sheet: Barb

[NAME] | Capital One Platinum | American Express Everyday | Chase Freedom | [NAME] | [NAME] | [NAME]'s | Discover | PayPal | Total
Interest Rate | 0.149 | 0.2924 | 0.2374 | 0.2299 | 0.2524 | 0.2499 | 0.1899 | 0.2399
Due Day | 2nd | 20th | 12th♥ | 22nd | 16th | 19th | 2nd | 12th
Limit | 3000 | 500 | 1000 | 2590 | 2000 | 700 | 8500 | 3000
Balance | 2143.89 | 207.48 | 186.09 | 2520.57 | 1287.03 | 0 | 8212.91 | 2910.75
Utilization
Target Balance
Over Target
Percent Target
Overutilization
Updated | 2020-10-03 00:00:00 | 2020-10-03 00:00:00 | 2020-10-03 00:00:00 | 2020-10-03 00:00:00 | 2020-10-03 00:00:00 | 2020-10-28 00:00:00 | 2020-10-28 00:00:00 | 2020-09-20 00:00:00 | ♥
Agency | Source | Range | Score | Weighted | Updated
Transunion | creditkarma.com | 300-850 | 610 |  | 2020-10-28 00:00:00
Equifax | creditkarma.com | 280-850 | 620 |  | 2028-10-28 00:00:00
CreditWise | creditwise.capitalone.com | 300-850 | 610 |  | 2020-10-28 00:00:00
FICO | usa.experian.com | 300-850 | 623 |  | 2020-09-06 00:00:00
Chase CJ | secure01b.chase.com | 300-850 | 607 |  | 2020-09-22 00:00:00
FICO | cardbenefits.citi.com | 250-900 | 636 |  | 2020-08-28 00:00:00
Discover |  |  | 652 |  | 2020-08-30 00:00:00
 |  |  |  |  | ♥
 |  |  |  |  | ♥
 |  |  | ♥
Spreadsheet: 719770d1613803523-if-and-statement-multiple-criteria-dummy-worksheet-2
Sheet: Sheet1

Labor Group | Date | PTO  to Payout or Recover | PTO  Paid (Hours) | PTO Rollover
264 | 2019-03-16 00:00:00 | 61.2 | 0
446 | 2019-04-22 00:00:00 | 80.6 | 0 | 80.6
446 | 2020-02-09 00:00:00 | 80.6 | 0 | 80.6
554 | 2020-02-09 00:00:00 | 80.6 | 0 | 80.6
Spreadsheet: 738562d1625119092-drop-down-list-with-2-condition-reference-2
Sheet: Data

CF Project | MARKET UNIT | CLIENT GROUP | ENTITY ID | [NAME] | ENTITY LEAD | CATEGORY |  |  |  | CALL-OUT | ACTION | ETC | AGEING DURATION |  |  |  |  | Helper 1 | Helper 2 | Helper 3
 | A | B | 343171 | ABS | A | Delivery Milestones |  |  |  | A | A | A
 |  |  | 336385 |  |  | Delivery Milestones
 |  |  | 333604 |  |  | Information Security
 |  |  | 328350 |  |  | Delivery Milestones
 |  |  | 331365 |  |  | Delivery Milestones
 |  |  | 331125 |  |  | Delivery Milestones
 |  |  | 329108 |  |  | Delivery Milestones
 |  |  | 327193 |  |  | Delivery Milestones
 |  |  | 325028 |  |  | Delivery Milestones
333604 |  |  | 326423 |  |  | Information Security
 |  |  | 315803 |  |  | Delivery Milestones
 |  |  | 320034 |  |  | Delivery Milestones
 |  |  | 322563 |  |  | Delivery Milestones
 |  |  | 315802 |  |  | Delivery Milestones
Spreadsheet: 775a41bb-debe-4fbb-8cc5-f140656056c4
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2012-09-07 09:45:52.580000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4 | 102.125 | 102 | 101.875 | 101.5 |  | and are added to price quote
3.875 | 101.932 | 101.807 | 101.682 | 101.307
3.75 | 101.801 | 101.676 | 101.551 | 101.176 |  | Note: | Refer To Price [NAME]
3.625 | 101.389 | 101.264 | 101.139 | 100.764 |  |  | For all Price Adjs
3.5 | 100.752 | 100.627 | 100.502 | 99.877
3.375 | 99.877 | 99.752 | 99.627 | 99.002
3.25 | 98.92 | 98.795 | 98.67 | 98.045
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | TIB Annual Mortgage Conference
 |  |  |  |  |  | October 3rd thru 5th
 |  |  |  |  |  | Register Now!!!
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.375 | 102.09 | 101.965 | 101.84 | 101.465
3.25 | 101.692 | 101.567 | 101.442 | 101.067
3.125 | 101.392 | 101.267 | 101.142 | 100.767
3 | 101.041 | 100.916 | 100.791 | 100.416
2.875 | 100.421 | 100.296 | 100.171 | 99.546
2.75 | 99.762 | 99.637 | 99.512 | 98.887
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2012-09-21 09:45:52.580000
30 DAY | 2012-10-06 09:45:52.580000
45 DAY | 2012-10-21 09:45:52.580000
60 DAY | 2012-11-05 09:45:52.580000
90 DAY | 2012-12-05 09:45:52.580000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 729757d1619318808-column-number-of-nth-text-book1
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  | LEFT TO RIGHT | RIGHT TO LEFT
 | TEXT | TEXT | TEXT |  |  |  | TEXT |  | TEXT | TEXT | TEXT | 4 | 8 | 8
TEXT |  |  | TEXT |  |  |  |  |  |  |  | TEXT | 4 | NOT COUNT FOR | NOT COUNT FOR
 |  |  | TEXT | TEXT | TEXT | TEXT |  |  | TEXT | TEXT |  | 4 | 7 | 6
TEXT |  | TEXT |  |  |  |  | TEXT |  | TEXT | TEXT |  | 4 | 10 | 3
 |  | TEXT |  |  | TEXT | TEXT | TEXT | TEXT | TEXT | TEXT | TEXT | 4 | 8 | 9
WHAT FORMULA OF YELLOW RANGE, FROM [NAME] TO RIGHT/RIGHT TO LEFT, HOW MUCH TEXT DOES FOUR STORY NUMBER? IF COUNT SMALLER VALUE OF M COLUMN, "NOT COUNT FOR"
Spreadsheet: 685158d1593767801-index-and-match-not-working-through-a-power-query-indexmatch
Sheet: PriceSheet

item | 0 | 25 | 50 | 100 | 250 | 500 | 1000 | 5000 | 10000 | 25000 | 50000
[NAME] | 3.17 | 3.17 | 3.17 | 3.17 | 3.02 | 2.94 | 2.86 | 2.74 | 2.74 | 2.74 | 2.74
JPA5 | 1.63 | 1.63 | 1.63 | 1.55 | 1.52 | 1.47 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4
JPA6 | 0.79 | 0.79 | 0.79 | 0.79 | 0.75 | 0.74 | 0.71 | 0.68 | 0.68 | 0.68 | 0.68
P111 | 4.1 | 4.1 | 4.1 | 3.89 | 3.81 | 3.69 | 3.69 | 3.69 | 3.69 | 3.69 | 3.69
N107 | 1.65 | 1.65 | 1.65 | 1.65 | 1.62 | 1.6 | 1.58 | 1.56 | 1.56 | 1.56 | 1.56
WAT5 | 1.6 | 1.6 | 1.6 | 1.31 | 1.25 | 1.18 | 1.18 | 1.18 | 1.18 | 1.18 | 1.18
P107 | 0.12 | 0.12 | 0.12 | 0.12 | 0.12 | 0.12 | 0.12 | 0.12 | 0.12 | 0.12 | 0.12
BOX1 | 2.4 | 2.4 | 2.4 | 2.4 | 2.05 | 1.8 | 1.7 | 1.6 | 1.6 | 1.6 | 1.6
DEA5 | 1.65 | 1.65 | 1.65 | 1.65 | 1.62 | 1.6 | 1.58 | 1.56 | 1.56 | 1.56 | 1.56
EG555 | 0.23 | 0.23 | 0.23 | 0.23 | 0.23 | 0.22 | 0.22 | 0.21 | 0.2 | 0.2 | 0.2
FLX5 | 1.9 | 1.9 | 1.9 | 1.8 | 1.7 | 1.6 | 1.52 | 1.52 | 1.52 | 1.52 | 1.52
DV03 | 100 | 0.26 | 0.26 | 0.24 | 0.23 | 0.22 | 0.21 | 0.21 | 0.21 | 0.21 | 0.21
Spreadsheet: 215205d1361305613-trying-to-lookup-the-same-value-and-return-it-multiple-times-vlookup-index-testing
Sheet: Sheet3

AS
BSE
BS
BSE
BS
BA
BS
BS
BA
BSE
BS
BS
[NAME]
BSE
BSE
BS
BSE
BSE
BS
BS
BA
[NAME]
BS
BSE
BS
BS
BSW
BA
[NAME]
BS
Spreadsheet: andy_zipper__169__DYNEGY-ICE VOL Apr13
Sheet: ICE-Power

Intercontinental Exchange - ICE |  |  |  |  |  | POWER VOLUME
POWER
Commodity Type:   Power Swaps/Forwards
Hub:  All
Trade Dates:  Apr-13-01 thru Apr-13-01
Description | Strip | Low Price | High Price | Weighted | Last Price | Last Price Date | Volume
 |  |  |  | Average Price
Firm-LD Peak
Firm-LD Peak - Cin - Next Day | Next Day | 45 | 47.75 | 45.913 | 47.75 | Apr-13-01 13:05 GMT | 16000 | MWhs
Firm-LD Peak - Cin - May01 | 2001-05-01 00:00:00 | 52.25 | 53.7 | 53.067 | 53.7 | Apr-13-01 14:12 GMT | 52800 | MWhs
Firm-LD Peak - Cin - Jun01 | 2001-06-01 00:00:00 | 77.25 | 77.25 | 77.25 | 77.25 | Apr-13-01 12:40 GMT | 16800 | MWhs
Firm-LD Peak - Cin - Jul01-Aug01 | Jul01-Aug01 | 124.25 | 124.25 | 124.25 | 124.25 | Apr-13-01 13:59 GMT | 70400 | MWhs
Firm-LD Peak - Comed - Dec01 | 2001-12-01 00:00:00 | 42.5 | 42.5 | 42.5 | 42.5 | Apr-13-01 12:41 GMT | 16000 | MWhs
Firm-LD Peak - Ent - May01 | 2001-05-01 00:00:00 | 61.25 | 61.25 | 61.25 | 61.25 | Apr-13-01 12:44 GMT | 17600 | MWhs
Firm-LD Peak - Ent - Q4 01 | Q4 01 | 47.25 | 47.25 | 47.25 | 47.25 | Apr-13-01 13:03 GMT | 51200 | MWhs
Firm-LD Peak - Nepool - Next Day | Next Day | 54.5 | 54.5 | 54.5 | 54.5 | Apr-13-01 11:41 GMT | 800 | MWhs
Firm-LD Peak - PJM-W - Bal Week | Bal Week | 51 | 51 | 51 | 51 | Apr-13-01 12:54 GMT | 4000 | MWhs
Firm-LD Peak - PJM-W - Next Day | Next Day | 50 | 51 | 50.2 | 51 | Apr-13-01 12:32 GMT | 4000 | MWhs
Firm-LD Peak - PJM-W - May01 | 2001-05-01 00:00:00 | 52.15 | 53 | 52.575 | 53 | Apr-13-01 14:04 GMT | 35200 | MWhs
Spreadsheet: michelle_lokay__26697__imball0111rev
Sheet: PGETX

 |  |  |  |  | 12283
 | [NAME] |  | Pecos Del |  | Gunpoint #2
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | -82662 | -69336 | -8383 | -19935
2 | -120423 | -72501 |  | -46705 |  |  |  |  |  |  |  |  |  | Avg
3 | -140024 | -68089 | -18196 | -89940 |  |  |  |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount
4 | -117792 | -67764 | -40001 | -89746
5 | -121732 | -67746 | -55353 | -109734
6 | -134186 | -100468 | -2492 | -27732 |  |  |  |  |  | 2001-01-01 00:00:00 | -715680 | -705664 |  | 8.21
7 | -91332 | -61530 |  | -29940 |  |  |  |  |  | 2001-02-01 00:00:00 | -661568 | -648307 |  | 5.62
8 | -38986 | -39030 |  |  |  |  |  |  |  | 2001-03-01 00:00:00 | -1831536 | -1828209 |  | 4.98
9 | -61929 | -56530 |  | -4416 |  |  |  |  |  | 2001-04-01 00:00:00 |  | -3486797 |  | 4.87
10 | -110019 | -63530 |  | -44940 |  |  |  |  |  | 2001-05-01 00:00:00 | -3735499 | -3753054 |  | 3.82
11 | -110065 | -63530 |  | -44940 |  |  |  |  |  | 2001-06-01 00:00:00 |  | -5025875 |  | 3.2
12 | -109068 | -63530 |  | -44940 |  |  |  |  |  | 2001-07-01 00:00:00 | -4565965 | -4525416 |  | 2.77
13 | -42337 | -40964 | -27331 | -27940
14 | -51768 | -37312 | -1012 | -13960
15 | -70141 | -55515 |  | -14331
16 | -144155 | -80946 |  | -61549
17 | -98838 | -65097 |  | -33937
18 | -82974 | -65097 | -15862 | -33911
19 | -94445 | -65097 | -5460 | -34874
20 | -45227 | -44529 | -1 | -266
21 | -110760 | -86867 | -58623 | -82027
22 | -85467 | -66089 | -2849 | -20468
23 | -86790 | -66089 |  | -21138
24 | -90332 | -66089 | -1 | -24191
25 | -86913 | -66009 |  | -20782
26 | -85644 | -66087 |  | -19097
27 | -42217 | -42982 |  | 1161
28 | -49123 | -28899 |  | -25000
29 | -34453 | -1317 |  | -37156
30 | -58448 | -42329 |  | -16025
31
 |  |  |  | 2001-10-31 00:00:00 |  |  | 440470.54
 |  |  |  | 2001-11-30 00:00:00
 | CBS Volume
 |  |  |  | 101407
Spreadsheet: 160208d1339007322-dependent-drop-down-list-wage-comparison-v1
Sheet: Data Entry

 | = entry field, from lookup values
 | = automatically populated
 | = entry field
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HOURLY |  |  | TOTAL
Project | Desc | DO # | Subcontract | Sub | Week Ending | Worker's Name | 2008 Classification | Hours - S | Rate Paid | Hours - OT | Rate Paid | [NAME] | Amt Paid | 2011/2012 Wage Determination | 2011/2012 Classification | 2011/2012 Rate | 2011/2012 Fringe | OT Rate | 2011/2012 Wages | Net Difference
660000227 |  |  |  |  |  |  | Electrician | 8 | 15 | 4 | 22.5 | 4.5 |  | Building | [NAME]
Spreadsheet: 48653d1247863817-vlookup-401-ded-worksheet-upload
Sheet: Export

1 | Doe, [NAME] | 0 | 0 | 0
2 | [NAME], [NAME] | 0 | 0 | 0
2 | [NAME], [NAME] | 0 | 0 | 0
4 | [NAME], [NAME] | 0 | 0 | 0
4 | [NAME], [NAME] | 0 | 0 | 0
6 | Thompson, Jake | 0 | 0 | 0
7 | Garner, [NAME] | 0 | 0 | 0
8 | Holland, Maria | 0 | 0 | 0
9 | Graft, Scott | 0 | 0 | 0
10 | Topper, [NAME] | 0 | 0 | 0
11 | [NAME], [NAME] | 0 | 0 | 0
12 | Trully, [NAME] | 0 | 0 | 0
13 | Fanta, [NAME] | 0 | 0 | 0
14 | Shelton, [NAME] | 0 | 0 | 0
15 | Edwards, [NAME] | 0 | 0 | 0
16 | Earhardt, Dale | 0 | 0 | 0
17 | [NAME], [NAME] | 0 | 0 | 0
18 | Frontal, [NAME] | 0 | 0 | 0
19 | Edon, [NAME] | 0 | 0 | 0
20 | [NAME], [NAME] | 0 | 0 | 0
21 | Bing, [NAME] | 0 | 0 | 0
22 | [NAME], [NAME] | 0 | 0 | 0
23 | [NAME], [NAME] | 0 | 0 | 0
24
25
26
27
28
29
30
Spreadsheet: 73461d1274127592-dynamic-line-chart-example
Sheet: Sheet1

Date | Sales | Profit
Jan | 214 | 120
Feb | 280 | 200
Mar | 397 | 250
Apr | 412 | 312
May | 551 | 516
Jun | 604 | 600
Jul | 689 | 675
Aug | 756 | 697
Spreadsheet: 677389d1589330119-assignment-assistance-formulas-sales-manager-excel-assignment
Sheet: Q3

Ex: | We have a three super markets A,B and C
 | A | B | C
 | 25 | 40 | 35
Heinz |  | √ | √
Dorra | √ |  | √
Helman | √ | √
What is the numeric distribution % ?
Heinz
Dorra
Helman
What is the weighted distribution % ?
Heinz
Dorra
Helman
Spreadsheet: 768393d1644944824-index-match-that-compares-if-date-is-between-two-dates-and-returns-yes-or-no-jjoseph08-practice
Sheet: Jul-Sep

Date = Mon-Sun Weekly completion
Salary | 7/5-7/11 | 7/12-7/18 | 7/19-7/25 |  | 7/26-8/1 | 8/2-8/8 | 8/9-8/15 | 8/16-8/22 | 8/23-8/29 | 8/30-9/5 | 9/6-9/12 | 9/13-9/19 | 9/20-9/26 | 9/27-10/3 |  |  |  | 1/11-1/18 | 1/11-1/19 | 1/11-1/20
*[NAME]
*[NAME] Merten
*[NAME]
Hourly | 7/5-7/11 | 7/12-7/18 | 7/19-7/25 |  | 7/26-8/1 | 8/2-8/8 | 8/9-8/15 | 8/16-8/22 | 8/23-8/29 | 8/30-9/5 | 9/6-9/12 | 9/13-9/19 | 9/20-9/26 | 9/27-10/3
OPEN
[NAME]
[NAME]
[NAME]
Dewayne Pillow
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | √
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Blacked cells = N/A           * = Mon-Fri shifts |  |  | X
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | VAC
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OFF
[NAME]
[NAME]
[NAME]
[NAME]
Shannon Reeves
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
OPEN
[NAME]
[NAME]
Lance May
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Spreadsheet: 01e118d2-4d57-43b6-b1bf-5ad2f5dedb28
Sheet: Machine Tool

MACHINE TOOL TECHNOLOGY                                        Student Name:
Diploma - CNC Machinist                                                   ID #
General Education | Semester | Grade
___ Area I Writing/Accessing Information, Oral Communication,
Heritate, Humanities or Foreign Language (3)
___ Area II ___ MAT 116 (3) Technical Mathematics
OR ___ MAT 126 (3) Technical Algebra & Trigonometry
___ Area III ___ CIT 105 (3) [NAME]  to Computers OR ___ IC3 Computer Literacy Exam
Electives
___ Co-op or [NAME] (1)
Technical Core
___ CMM 110 (3) Fundamentals of Machine Tools A
AND ___ CMM 112 (4) Fundamentals of Machine Tools B
OR ___ CMM 114 (7) Fundamentals of Machine Tools
___ CMM 118 (2) Metrology/Control Charts
___ CMM 120 (3) Applied Machining I AND ___ CMM 122 (3) Applied Machining II
OR ___ CMM 124 (6) Applied Machining
___ CMM 130 (3) Manual Programming AND ___ CMM 132 (3) CAD/CAM/CNC
OR CMM 134 (6) Manual Programming/CAD/CAM/CNC
OR CMM 138 (6) Intro to Programming & CNC Machines
___ CMM 210 (3) Industrial Machining I AND ___ CMM 212 (3) Industrial Machining II
OR ___ CMM 214 (6) Industrial Machining
___ CMM 220 (4) Advanced Industrial Machining I
AND ___CMM 222 (2) Advanced Industrial Machining II
OR ___ CMM 224 (6) Advanced Industrial Machining
___ CMM 2301 (3) Intro to Conversational Programming
AND ___ CMM 2302 (3) Conversational Editing and Subroutines
OR ___ CMM 230 (6) Conversational Programming
OR ___ CMM 234 (6) CNC Machines and Coding Practices
___ CMM 2401 (3) Intro to 3-D Code Sequencing and Tool Path Production
AND ___ CMM 2402 (3) Advanced 3-D Code Sequencing and Macro Systems
OR ___ CMM 240 (6) [NAME] to 3-D Programming
OR ___ CMM 244 (6) Advanced Programming/Setup Practices
___ BRX 110 (2) Basic Blueprint Reading for Machinists
AND ___ BRX 210 (2) Mechanical [NAME] for Machinists
OR ___ BRX 112 (4) Blueprint Reading for Machinists
Southeast Kentucky Community & Technical College | Updated Spring 2013