tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 714318d1611171020-lookup-for-1st-2nd-3rd-etc-occurrences-from-list-book2
Sheet: Sheet1

 | SECTION A
 | ITEM 01
 | ITEM 02
 | ITEM 03
 | ITEM 04
 | SECTION B
 | ITEM 01
 | ITEM 02
 | ITEM 03
 | ITEM 04
 | ITEM 05
 | SECTION C
 | ITEM 01
 | ITEM 02
 | SECTION D
 | ITEM 01
 | ITEM 02
 | ITEM 03
 | ITEM 04
1st
2nd |  | <---------- | This should be SECTION B
3rd |  | <---------- | This should be SECTION C
4th |  | <---------- | This should be SECTION D
Spreadsheet: 76470d1277026037-restriction-on-if-statement-logictest
Sheet: Sheet1

0 |  |  | 0 |  |  | 0
255 |  |  | 601 |  |  | 0
601 |  |  | 702 |  |  | 0
1003 |  |  | 1003 |  |  | 1003
Everything is fine in this |  |  | Cell E5 should be given a |  |  | Cell H6 should be given
array |  |  | value of 75 rather than 50 |  |  | 175 rather than just 100
 |  |  | because 25 has not yet been |  |  | because neither 50 nor 25
 |  |  | awarded to previous cells |  |  | have been awarded in previous cells
 |  |  | in column E
 |  | The same logic applies to however many other combinations may be made
 |  | If a value has not been used in a previous cell, it should be added if the logic allows
 |  | it to be.
Spreadsheet: 833135d1686804184-sum-of-color-cell-sum-the-color-cells
Sheet: Sheet1

 |  |  | sum
Spreadsheet: 713845d1610974252-evaluate-date-range-for-last-date-in-year-semi-annual-quarter-and-year-daterange
Sheet: Sheet5

Dates | YrEnd | Last6/30/YY | LastQtr | Last Month
2006-01-03 00:00:00
2006-01-13 00:00:00
2006-01-30 00:00:00
2006-01-31 00:00:00
2006-02-01 00:00:00
2006-02-02 00:00:00
2006-02-24 00:00:00
2006-02-27 00:00:00
2006-02-28 00:00:00
2006-03-01 00:00:00
2006-03-10 00:00:00
2006-03-20 00:00:00
2006-03-31 00:00:00
2006-04-03 00:00:00
2006-04-18 00:00:00
2006-04-19 00:00:00
2006-04-20 00:00:00
2006-05-01 00:00:00
2006-05-16 00:00:00
2006-05-30 00:00:00
2006-05-31 00:00:00
2006-06-01 00:00:00
2006-06-20 00:00:00
2006-06-29 00:00:00
2006-07-03 00:00:00
2006-07-05 00:00:00
2006-07-17 00:00:00
2006-08-01 00:00:00
2006-08-24 00:00:00
2006-09-01 00:00:00
2006-09-05 00:00:00
2006-09-20 00:00:00
2006-09-29 00:00:00
2006-10-02 00:00:00
2006-10-19 00:00:00
2006-10-27 00:00:00
2006-11-01 00:00:00
2006-11-30 00:00:00
2006-12-01 00:00:00
2006-12-26 00:00:00
2006-12-27 00:00:00
2006-12-28 00:00:00
Spreadsheet: 18ccde9b-80b3-4776-b4be-ea5fc346d664
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Name: | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | SSN:
 |  |  | Spouse: |  |  |  |  |  |  |  |  |  | SSN:
 |  |  | Dependents: |  |  |  |  |  |  |  |  |  | SSN:
 |  |  |  |  |  |  |  |  |  |  |  |  | SSN:
 |  |  |  |  |  |  |  |  |  |  |  |  | SSN:
 |  |  |  |  |  |  |  |  |  |  |  |  | SSN:
( A ) |  |  | Address:
( B ) |  |  | Bank: |  |  |  |  |  |  |  |  |  | Safe Deposit
 |  |  | Address: |  |  |  |  |  |  |  |  |  | Box #:
 |  |  |  |  |  |  |  |  |  |  |  |  | Spouse's
( C ) |  |  | Office: |  |  |  |  |  |  |  |  |  | Office:
( D ) |  |  | Pastor / Priest:
 |  |  | Church Address:
 |  |  |  |  |  |  |  |  |  |  |  |  | Phone #:
( E ) |  |  | Lawyer:
 |  |  | Address:
 |  |  |  |  |  |  |  |  |  |  |  |  | Phone #:
( F ) |  |  | Accountant:
 |  |  | Address:
 |  |  |  |  |  |  |  |  |  |  |  |  | Phone #:
( G ) |  |  | Other: |  |  |  |  |  |  |  |  | (e.g. trusted friend, financial planner, mattress)
 |  |  |  |  |  |  |  |  |  |  |  |  | Phone #:
Spreadsheet: 888024d1738335751-excel-formula-help-updated-attendance-tracker
Sheet: HELPER

MONTH |  |  |  | Holiday | Date
January |  |  |  | New Year’s Day | 2025-01-01 00:00:00 |  |  |  |  |  | Excused EX | Unexcused UnEx | No Call No Show NCNS
February |  |  |  | Good Friday | 2025-04-18 00:00:00
March |  |  |  | Memorial Day | 2025-05-26 00:00:00
April |  |  |  | July 4th | 2025-07-04 00:00:00
May |  |  |  | Labor Day | 2025-09-01 00:00:00
June |  |  |  | Day Before Thanksgiving | 2025-11-27 00:00:00
July |  |  |  | Day After Thanksgiving | 2025-11-28 00:00:00
August |  |  |  | Christmas Eve | 2025-12-24 00:00:00
September |  |  |  | Christmas Day | 2025-12-25 00:00:00
October |  |  |  | Union Holiday | 2025-12-26 00:00:00
November |  |  |  | Union Holiday | 2025-12-29 00:00:00
December |  |  |  | Union Holiday | 2025-12-30 00:00:00
 |  |  |  | New Years Eve | 2025-12-31 00:00:00
Spreadsheet: phillip_m_love__30147__9910_OA
Sheet: TX-EGM-GL

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM)
REGION:  TEXAS
 |  |  | Total |  | Reclasses |  | October |  | November |  | December |  | January |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  | September
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations |  |  |  |  |  |  |  | 0
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
7 |  | Liquidations |  |  |  |  |  |  |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6660 | 18013.28 | -5683 | -15371
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5683 | 13894.94 | -12809 | -31318 | 5697 | 13929.17
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -5683 | -13894.94 | 6149 | 15034.31 | -14 | -34.23
23 | Fuel:
 | Transport Expense:
24 |  | Commodity |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -10195 | -11.7 | 7196 | 1458.56 | 1477 | 25.64
25 |  | Demand |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | -66 | -106.43 | -5749 | -143.82
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations |  |  |  |  |  |  |  | 0
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
FT-South Texas
 |  | Current Month MTM |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Financial Liquidations |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Originations |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | TOTAL FIRM TRADING
 |  | TOTAL GL
Spreadsheet: 725405d1616669079-help-calculating-numbers-in-multiple-columns-with-a-criteria-in-1-row-excel-help
Sheet: Sheet1

 |  | Total Hours | Total Cost | Rate |  | Hours | Cost | Hours | Cost | Hours | Cost | Hours | Cost | Hours | Cost
 | a | ??? | ??? | 100 |  | 10 |  | 20 |  | 20 |  | 20 |  | 20
 | b |  |  | 100 |  | 10 |  | 20 |  | 20 |  | 20 |  | 20
 | c |  |  | 100 |  | 10 |  | 20 |  | 20 |  | 20 |  | 20
 | d |  |  | 50 |  | 10 |  | 20 |  | 20 |  | 20 |  | 20
 | e |  |  | 50 |  | 10 |  | 20 |  | 20 |  | 20 |  | 20
 | f |  |  | 50 |  | 10 |  | 20 |  | 20 |  | 20 |  | 20
Spreadsheet: 688410d1595772979-scheduling-list-need-to-remove-blank-rows-excel-forum-remove-blanks-from-formula_chris
Sheet: Sheet1

Sheet 1
Colulmn A | Colulmn B | Colulmn C | Colulmn D | Colulmn E | Colulmn F
Mr. [NAME] | Sec. 1 | TeamA | Dept. A | Basic | Group 1 - Class 1
Mr. [NAME] | Sec. 2 | TeamB | Dept. B | Basic | Group 2 - Class 1
Mr. [NAME] |  | TeamC | Dept. C | Advanced | Group 3 - Class 1
Mr. [NAME] | Sec. 3 | TeamC | Dept. C | Basic | Group 3 - Class 1
Mr. [NAME] | Sec. 4 | TeamA | Dept. A | Basic | Group 1 - Class 1
Mr. [NAME] |  | TeamA | Dept. A | Advanced | Group 1 - Class 1
Mr. [NAME] |  | TeamC | Dept. C | Advanced | Group 3 - Class 1
Mr. [NAME] | Sec. 5 | TeamB | Dept. B | Basic | Group 2 - Class 1
Mr. I | Sec. 6 | TeamA | Dept. A | Basic | Group 1 - Class 1
Mr. [NAME] |  | TeamC | Dept. C | Advanced | Group 3 - Class 1
Sheet 2 |  |  |  | Sheet 3
Group 1 | Group 2 | Group 3 |  | Group 1 | Group 2 | Group 3
Spreadsheet: 633be199-91ec-489d-9e31-f7d651b1dada
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Bht Entertainment | 881534201015 | Rocfish | [NAME], The | 2005-09-13 | Compact Disc | Children | 12.99 | N | To Be Retired
Bht Entertainment | 881534200995 | Rocfish | [NAME], The | 2005-09-13 | DVD | Children | 12.98 | N | To Be Retired
Spreadsheet: 119943d1314879400-inserting-rows-across-sheets-komet12_testing
Sheet: BPD_DEF

 |  | Last Name | First Name | Occp | Dept | Team | Shift | GMIN | BPD | [NAME] | Interview | Math | Written | Comments | Test Taken On:
Spreadsheet: 58033d1258353071-exclude-non-mature-data-copy-of-monthly-cancels-v2
Sheet: 2008

Monthly Billing [NAME]: 2008
Printed on: | 2009-11-17 06:19:00
 | Oct-08 |  | Nov-08 |  | Dec-08 |  | Total
Primary price point | 6.99 |  | 6.99 |  | 7.97
Joins | 4435 |  | 9347 |  | 15031 |  | 28813
Trial cancel | 1754 |  | 3448 |  | 5235 |  | 10437
Trial % | 0.3954904171364149 |  | 0.3688884133946721 |  | 0.3482802208768545 |  | 0.3622323256863221
Bad card | 126 |  | 259 |  | 431 |  | 816
Bad Card % (Joins) | 0.02841037204058625 |  | 0.02770942548411255 |  | 0.02867407358126538 |  | 0.02832054975184813
Bad Card % (Billed) | 0.04699738903394256 |  | 0.04390574673673504 |  | 0.0439975500204165 |  | 0.04440574662603396
Month 1 Bill | 2555 |  | 5639 |  | 9360 |  | 17554
Month 1 Cancel | 602 | 0.1357384441939121 | 1383 | 0.1479619129132342 | 2687 | 0.1787638879648726 | 4672 | 0.1621490299517579
Month 2 Bill | 1950 |  | 4256 |  | 6673 |  | 12879
Month 2 Cancel | 386 | 0.08703494926719278 | 1032 | 0.1104097571413288 | 1701 | 0.1131661233450868 | 3119 | 0.1082497483774685
Month 3 Bill | 1564 |  | 3224 |  | 4972 |  | 9760
Month 3 Cancel | 356 | 0.08027057497181511 | 725 | 0.07756499411575907 | 1037 | 0.06899075244494711 | 2118 | 0.07350848575295874
Month 4 Bill | 1208 |  | 2498 |  | 3934 |  | 7640
Month 4 Cancel | 267 | 0.06020293122886133 | 427 | 0.04568310687921258 | 653 | 0.04344354999667354 | 1347 | 0.04674973102419047
Month 5 Bill | 941 |  | 2071 |  | 3261 |  | 6273
Month 5 Cancel | 142 | 0.03201803833145434 | 317 | 0.03391462501337327 | 481 | 0.03200053223338434 | 940 | 0.03262416270433485
Month 6 Bill | 799 |  | 1745 |  | 2790 |  | 5334
Month 6 Cancel | 105 | 0.02367531003382187 | 254 | 0.02717449449021076 | 423 | 0.02814184019692635 | 782 | 0.02714052684552112
Month 7 Bill | 691 |  | 1493 |  | 2376 |  | 4560
Month 7 Cancel | 109 | 0.0245772266065389 | 224 | 0.02396490852680004 | 310 | 0.02062404364313752 | 643 | 0.02231631555200777
Month 8 Bill | 585 |  | 1276 |  | 2066 |  | 3927
Month 8 Cancel | 83 | 0.01871476888387824 | 151 | 0.01615491601583396 | 261 | 0.01736411416406094 | 495 | 0.01717974525387846
Month 9 [NAME] | 502 |  | 1125 |  | 1805 |  | 3432
Month 9 Cancel | 63 | 0.01420518602029312 | 131 | 0.01401519204022681 | 183 | 0.01217483866675537 | 377 | 0.01308437163780238
Month 10 Bill | 439 |  | 993 |  | 1609 |  | 3041
Month 10 Cancel | 44 | 0.00992108229988726 | 116 | 0.01241039905852145 | 77 | 0.005122746324263189 | 237 | 0.008225453788220595
Month 11 Bill | 394 |  | 857 |  | 1084 |  | 2335
Month 11 Cancel | 30 | 0.006764374295377677 | 40 | 0.004279447951214294 | 6 | 0.0003991750382542745 | 76 | 0.002637698261201541
Month 12 Bill | 173 |  | 482 |  |  |  | 655
Month 12 Cancel | 2 | 0.0004509582863585118 | 0 | 0 |  | 0 | 2 | 6.941311213688266e-05
Total: | 11801 |  | 25659 |  | 39930 |  | 77390
Billing Events: | 2.660879368658399 |  | 2.745158874505189 |  | 2.656509879582197 |  | 2.685940374136675
Spreadsheet: 863233d1710792772-finding-data-from-table-1-with-various-variables-to-enter-the-correct-value-in-table-2-need-sorting
Sheet: Sheet1

 | TABLE 1 |  |  |  |  | TABLE 2
 | Student ID | Module Number | Module |  |  | Student ID | Module1 | Module2 | Module3 | Module4 | Module5 | Module6 | Module7 | Module8
 | 124756 | Module1 | ANTH0013 - Theoretical Perspectives in Social Anthropology and Material Culture |  |  | 124756
 | 124756 | Module2 | ANTH0014 - The Anthropology of Kinship and Gender |  |  | 6547896
 | 124756 | Module3 | ANTH0044 - Human Behavioural Ecology |  |  | 8754561
 | 124756 | Module4 | ARCL0030 - Current Issues in Archaeological Theory |  |  | 20132
 | 124756 | Module5 | ARCL0038 - Research and Presentation Skills |  |  | 124575
 | 124756 | Module6 | ARCL0054 - The Aztecs and the Conquest of Mexico
 | 124756 | Module7 | ARCL0208 - The Archaeology of London
 | 124756 | Module8 | LCSP0002 - Spanish Level 1
 | 6547896 | Module1 | ANTH0013 - Theoretical Perspectives in Social Anthropology and Material Culture
 | 6547896 | Module2 | ANTH0049 - Anthropology of Capitalisms
 | 6547896 | Module3 | ANTH0062 - Anthropology of Cultural Heritage and Museum Anthropology
 | 6547896 | Module4 | ANTH0064 - Anthropology of the Built Environment
 | 6547896 | Module5 | ARCL0030 - Current Issues in Archaeological Theory
 | 6547896 | Module6 | ARCL0038 - Research and Presentation Skills
 | 6547896 | Module7 | ARCL0083 - The Early Islamic World
 | 6547896 | Module8 | ARCL0208 - The Archaeology of London
 | 8754561 | Module1 | ANTH0013 - Theoretical Perspectives in Social Anthropology and Material Culture
 | 8754561 | Module2 | ANTH0073 - Digital Infrastructure: Materiality, Information and Politics
 | 8754561 | Module3 | ANTH0079 - Aspects of Applied Medical Anthropology
 | 8754561 | Module4 | ARCL0030 - Current Issues in Archaeological Theory
 | 8754561 | Module5 | ARCL0036 - Archaeological Illustration and Imaging
 | 8754561 | Module6 | ARCL0038 - Research and Presentation Skills
 | 8754561 | Module7 | ARCL0041 - Organic Materials in Archaeology
 | 8754561 | Module8 | LCSP0002 - Spanish Level 1
 | 20132 | Module1 | ANTH0013 - Theoretical Perspectives in Social Anthropology and Material Culture
 | 20132 | Module2 | ANTH0014 - The Anthropology of Kinship and Gender
 | 20132 | Module3 | ANTH0136 - The Anthropology of Violent Aftermaths
 | 20132 | Module4 | ARCL0027 - Archaeological Surveying
 | 20132 | Module5 | ARCL0030 - Current Issues in Archaeological Theory
 | 20132 | Module6 | ARCL0038 - Research and Presentation Skills
 | 20132 | Module7 | ARCL0049 - The Archaeology of Human Remains
 | 20132 | Module8 | LCBS0001 - British Sign Language Level 1
 | 124575 | Module1 | ANTH0013 - Theoretical Perspectives in Social Anthropology and Material Culture
 | 124575 | Module2 | ANTH0049 - Anthropology of Capitalisms
 | 124575 | Module3 | ANTH0059 - Anthropology of Religion
 | 124575 | Module4 | ARCL0030 - Current Issues in Archaeological Theory
 | 124575 | Module5 | ARCL0038 - Research and Presentation Skills
 | 124575 | Module6 | ARCL0083 - The Early Islamic World
 | 124575 | Module7 | POLS0027 - Human Rights and World Politics
Spreadsheet: 874465d1721059838-assigning-a-number-to-a-name-no-tap-bowling-scores-template
Sheet: Roster

Total Bowlers |  |  |  |  | Total Bowlers |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Payout Amount
Date |  |  |  |  | Date |  |  |  |  |  |  | 1 | [NAME] | 202 | M | 40 | Mark | 200 | M | 1/4%
# | NAME | M/W | HDCP | Verify | # | NAME | M/W | HDCP | Verify |  |  | 2 | [NAME] | 116 | M | 41 | [NAME] | 200 | W | 1/2%
 |  |  |  |  |  |  |  |  |  |  |  | 3 | [NAME] | 145 | M | 42 | [NAME] | 200 | W | 3/4%
 |  |  |  |  |  |  |  |  |  |  |  | 4 | [NAME] | 100 | W |  |  |  |  | 0.01
 |  |  |  |  |  |  |  |  |  |  |  | 5 | [NAME] | 189 | W |  |  |  |  | 0.0125
 |  |  |  |  |  |  |  |  |  |  |  | 6 | [NAME] | 100 | M |  |  |  |  | 0.015
 |  |  |  |  |  |  |  |  |  |  |  | 7 | Coleen | 100 | W |  |  |  |  | 0.0175
 |  |  |  |  |  |  |  |  |  |  |  | 8 | [NAME] | 205 | W |  |  |  |  | 0.02
 |  |  |  |  |  |  |  |  |  |  |  | 9 | Doug | 100 | M |  |  |  |  | 0.0225
 |  |  |  |  |  |  |  |  |  |  |  | 10 | [NAME] | 100 | M |  |  |  |  | 0.025
 |  |  |  |  |  |  |  |  |  |  |  | 11 | [NAME] | 189 | M |  |  |  |  | 0.0275
 |  |  |  |  |  |  |  |  |  |  |  | 12 | [NAME] | 113 | M |  |  |  |  | 0.03
 |  |  |  |  |  |  |  |  |  |  |  | 13 | CeCe | 100 | W
 |  |  |  |  |  |  |  |  |  |  |  | 14 | [NAME] | 100 | M
 |  |  |  |  |  |  |  |  |  |  |  | 15 | [NAME] | 100 | W
 |  |  |  |  |  |  |  |  |  |  |  | 16 | [NAME] | 100 | M
 |  |  |  |  |  |  |  |  |  |  |  | 17 | Beryl Slie | 240 | M
 |  |  |  |  |  |  |  |  |  |  |  | 18 | [NAME] | 224 | W
 |  |  |  |  |  |  |  |  |  |  |  | 19 | [NAME] | 100 | M
 |  |  |  |  |  |  |  |  |  |  |  | 20 | [NAME] | 100 | W
 |  |  |  |  |  |  |  |  |  |  |  | 21 | [NAME] | 100 | M
 |  |  |  |  |  |  |  |  |  |  |  | 22 | [NAME] | 100 | M
 |  |  |  |  |  |  |  |  |  |  |  | 23 | [NAME] | 100 | W
 |  |  |  |  |  |  |  |  |  |  |  | 24 | [NAME] | 100 | W
 |  |  |  |  |  |  |  |  |  |  |  | 25 | [NAME] | 100 | W
 |  |  |  |  |  |  |  |  |  |  |  | 26 | [NAME] | 100 | W
 |  |  |  |  |  |  |  |  |  |  |  | 27 | Mac | 100 | M
 |  |  |  |  |  |  |  |  |  |  |  | 28 | [NAME] | 100 | M
 |  |  |  |  |  |  |  |  |  |  |  | 29 | [NAME] | 100 | M
 |  |  |  |  |  |  |  |  |  |  |  | 30 | [NAME] | 100 | M
 |  |  |  |  |  |  |  |  |  |  |  | 31 | [NAME] | 100 | M
 |  |  |  |  |  |  |  |  |  |  |  | 32 | [NAME] | 100 | M
 |  |  |  |  |  |  |  |  |  |  |  | 33 | [NAME] | 145 | M
 |  |  |  |  |  |  |  |  |  |  |  | 34 | Billy | 100 | M
Spreadsheet: 42219d1240832989-shading-areas-off-a-countif-excel-example
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | a
a | a | a | a | a | a | a | a | a | a |  | 44
a | a | a | a | a | a | a | a | a | a
a | a | a | a | a | a | a | a | a | a
a | a | a | a | a | a | a | a | a | a
a | a | a | a | a | a | a | a | a | a
a | a | a | a | a | a | a | a | a | a
a | a | a | a | a | a | a | a | a | a
a | a | a | a | a | a | a | a | a | a
a | a | a | a | a | a | a | a | a | a
a | a | a | a | a | a | a | a | a | a
a | a | a | a | a | a | a | a | a | a
a | a | a | a | a | a | a | a | a | a
a | a | a | a | a | a | a | a | a | a
a | a | a | a | a | a | a | a | a | a
a | a | a | a | a | a | a | a | a | a
a | a | a | a | a | a | a | a | a | a
a | a | a | a | a | a | a | a | a | a
a | a | a | a | a | a | a | a | a | a
a | a | a | a | a | a | a | a | a | a
a | a | a | a | a | a | a | a | a | a
Spreadsheet: 677563d1589397445-pivot-table-filter-deearo-
Sheet: SHEET 1

DATE | Description | Money in | Money Out | MONEY IN REASON | MONEY OUT REASON
2020-03-17 00:00:00 | CARD PAYMENT TO MAGNET ACTURIS RECEIPT,579.03 GBP, RATE 1.00/GBP ON 13-03-2020 |  | 45
2020-03-14 00:00:00 | CARD PAYMENT TO TFL TRAVEL CH,3.00 GBP, RATE 1.00/GBP ON 12-03-2020 |  | 3 |  | NON
2020-03-02 00:00:00 | DIRECT DEBIT PAYMENT TO VIRGIN MEDIA PYMTS REF 214427, MANDATE NO 0021 |  | 30
2020-03-02 00:00:00 | DIRECT DEBIT PAYMENT TO BRITISH GAS REF 123456, MANDATE NO 0075 |  | 50
2020-03-02 00:00:00 | DIRECT DEBIT PAYMENT DERPE, MANDATE NO 0026 |  | 60
2020-02-03 00:00:00 | DIRECT DEBIT PAYMENT DERPE, MANDATE NO 0026 |  | 60
2020-02-03 00:00:00 | DIRECT DEBIT PAYMENT TO VIRGIN MEDIA PYMTS REF 214427, MANDATE NO 0021 |  | 30
2020-02-03 00:00:00 | DIRECT DEBIT PAYMENT TO BRITISH GAS REF 123456, MANDATE NO 0075 |  | 50
2019-12-24 00:00:00 | CARD PAYMENT TO ISLEWORTH,9.99 GBP, RATE 1.00/GBP ON 21-12-2019 |  | 9.99 |  | REPAIRS 38
2019-12-18 00:00:00 | CARD PAYMENT TO FIREPROTECT,75.05 GBP, RATE 1.00/GBP ON 15-12-2019 |  | 15 |  | REPAIRS 38
Spreadsheet: 8b300c92-6613-4ada-91b3-525cbdbdd530
Sheet: Sheet1

CCMEP™    EXTENSION OF CERTIFICATION (EOC) ELIGIBILITY WORKSHEET | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
 | Units [Points]                                          Maximum / Minimum Points | MY POINTS | PLEASE COMPLETE THIS PAGE and EMAIL IT AS AN ATTACHMENT                                          TO:  [EMAIL]
EDUCATION FORMAL & INFORMAL | Section Requires Minimum of 4 pts | 0 | ALL INFORMATION MUST RELATE TO EDUCATION OR EXPERIENCE ACQUIRED                                                 SINCE YOUR LAST CERTIFICATION *
Formal Education |  |  | * Educational institution, graduation year, and major or degree type
Associates Degree | 0.5 point | 0
Undergraduate Degree | 1 point | 0
Masters Degree [specify type] | 1 point | 0
Doctoral Degree [specify type] | 2 points | 0
 |  | 0
Informal Education | Maximum allowed for EOC  =  6 points |  | * Activities for CME professionals; specify activity, organizer, month and year
Conferences, national or regional | 1 point per conference | 0
Online courses, webinars, exam prep | 0.5 pt per  course | 0
NC-CME Practice Exam | 0.5 | 0
Other - please specify | [to be determined per activity] | 0
 |  | 0 | Maximum allowed  = 6 points
EXPERIENCE - RELATED TO CME | Section Requires Minimum of 4 pts | 0
Employment | Maximum allowed for EOC =  3  points |  | * Employer(s) and years of employment
Years employed full-time | 1 point per year | 0
Years employed part-time | 0.5 point per year | 0
 |  | 0 | Maximum allowed  =  3 points
Memberships | Maximum allowed for EOC = 5 points |  | * Individual Membership Years:
Alliance for CME | 1 point per year | 0
SACME | 1 point per year | 0
GAME | 1 point per year | 0
Other: | 1 point per year | 0
 |  | 0 | Maximum allowed  =  5 points
[NAME] | Maximum allowed for EOC = 5 points |  | * Type of work (Board / Officer / Surveyor / Committee) and year(s)
ACCME, ACME, NAMEC,                                                 NC-CME, [NAME], etc. | 1 point per term or year | 0
 |  | 0
Publications and Presentations | Maximum allowed for EOC = 5 points |  | * Journal/Newsletter/Conference; Month and Year
Peer-reviewed Journals | 1 point per article | 0
Newsletters | 0.5 point per article | 0
Presentations | 1 point per hour | 0
 |  | 0 | Maximum allowed  =  5 points
Licensed Healthcare Practitioner |  |  | * Specify discipline per state with current license number(s):
Medicine, nursing, pharmacy, psychology, etc. | 1 point per license | 0
 | YOUR TOTAL POINTS | 0 | The required minimum to qualify for Extension of Certification (EOC) is 12 points.
By submitting the information on this spreadsheet, you are affirming that this information is true and that you will present additional documentation if requested.
Name / Date: | E-mail address: |  | Phone:
Revised 2011-02-11 | (This will be your signature)