tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 678260d1589800968-getting-error-in-simple-add-and-subtract-formula-salary-emp_01
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P | Present
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LC | Late Coming
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P * | In/Out Time not Marked
Days Of the Month: |  |  | 31 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SL | Short Leave
Minutes In a Day : |  |  | 360 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LC/SL | LC & Short Leave
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | L | Leave
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AA | OFF - Twice
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T. Day's Present | Late Comer | T. Day's P* | Short Leave | LC & Short Leave | Total Leave's | OFF -  Twice
Serial # | Employe # | Names | (*P = Present) - (*L =Leave) - (*AA = Double Absent)
 |  |  | Su | M | [NAME] | W | Th | F | Sa | Su | M | [NAME] | W | Th | F | Sa | Su | M | [NAME] | W | Th | F | Sa | Su | M | [NAME] | W | Th | F | Sa | Su | M | [NAME]
 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
1 | 6 | Jones | P | L | P | P | P | AA | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P
2 | 24 | [NAME]
3 | 139 | Jan | P | P | P | P | P | P | P | P | L | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P
4 | 0 | [NAME]
5 | 0 | [NAME] | P | P | P | P | L | L | P | P | P | P | P | P | P | AA | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P
5 | 0
5 | 0
5 | 0
5 | 0
5 | 0
5 | 0
5 | 0
5 | 0
Spreadsheet: 364a0bf2-e06f-4eb0-87ce-3d053b83a850
Sheet: Sheet1

Table S2. Drosophila candidate pain genes with known mammalian pain gene orthologs | Unnamed: 1 | Unnamed: 2
Transformant id | CG_ID | mouse_ortholog_entrez_id
20989,20991,40999 | CG5962 | 216869
8549 | CG1058 | 171209
47048,47047 | CG32792 | 171209
45360,17949,17950 | CG17203 | 14586
38319,38320 | CG10033 | 19091
23430,23431 | CG5890 | 56461
22196 | CG5711 | 216869
1385,1386 | CG9753 | 11539
1385,1386 | CG9753 | 11540
1385,1386 | CG9753 | 11542
3399,39222,39221,48495,3400 | CG2872 | 14427
3399,39222,39221,48495,3400 | CG2872 | 14428
49413 | CG11992 | 18033
11465,11464 | CG12796 | 12801
11465,11464 | CG12796 | 12802
11465,11464 | CG12796 | 14745
1815 | CG6881 | 12426
5261,5260 | CG5842 | 193034
5261,5260 | CG5842 | 246788
5261,5260 | CG5842 | 63873
35855 | CG8203 | 12568
41134 | CG1725 | 13385
41134 | CG1725 | 23859
37249 | CG5751 | 277328
47280,38930 | CG18069 | 12322
Spreadsheet: 02090b44-1c40-4924-a6ca-2f9b825a5842
Sheet: Sheet1

Abnormal Lab/Report Log | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | F/U | Result | Recommendation | F/U.1
Patient | DOB | Date of Abnormal Finding:what | Recommended Tx or F/U:where;when | Results | Recommendations
 | 1960-06-05 00:00:00 | [NAME] bx;endometroid adenocarcinoma | results given to pt-referred to Women's Health Center per Dr. [NAME]
 | 1957-06-11 00:00:00 | 6/14/2011:pelvic pn | SPRHC pelvic u/s:sch 6/22/2011
 | 1966-04-12 00:00:00 | 6/15/2010: Cat 0:SMC | L breast dx and u/s sch for 7/14/10:SMC | 7/22/10 dx and u/s L breast : cat 2 | SBE and yearly mammograms | 6/20/11:Cat 1
 | 1961-03-06 00:00:00 | 7/26/2011 screen mammo cat 0 | dx mammo sch 8/3/2011 @SMC | Cluster microcalcifications L breast;cat 3 | stereotactic bx sch at SMC on 8/25/2011-cmc
 | 1988-02-02 00:00:00 | 7/19/11 Pap= [NAME], dysplasia and HPV effect
 | 1980-11-30 00:00:00 | 6/20/2011:LSIS  +HPV | Colpo Scheduled 8/15/11 w/Dr. [NAME]
 | 1939-01-08 00:00:00 | 6-29-11 Bilat. Nipple discharge | Dx mammo and u/s at SMC | Cat 0 until receive previous mammo reults for comparison, pt advised | [NAME]: Cat 0 radiologist needs previous records, pt notified and is working to get the records |  | 8/9/11Referred to Dr. Girard for nipple discharge and breast pn-Pt informed and agreed with referral
 | 1987-08-12 00:00:00 | 8/3/11 PAP= NIL + HPV (2nd +HPV) | Left message need to schedule colpo
 | 1964-05-04 00:00:00 | 9/20/2010  A/E  cervical polyp;pap LSIS | colpo scheduled 10/18/10 | No bx taken;normal cervix | Return to Annual Exams
 | 1975-08-17 00:00:00 | 5/2/2011:pelvic pn,,poss fibroids | SPRHC pelvic u/s | Normal:6/13/2011 pt told results
 | 1930-03-23 00:00:00 | 12/13/11 atrophic vaginitis | recheck 6 months if not improved consider vulvar biopsy (June 2011)
 | 1974-09-06 00:00:00 | 6/30/11 L breast lumps x2 | Diagnostic Mammogram scheduled 7-12-11
Spreadsheet: daren_farmer__6635__Texas Nat_Gas Ops 0200 O&M Report
Sheet: 1497

1497 |  |  |  |  |  |  |  |  |  |  |  |  |  | ASSOCHC | TOTAL_HEADCOUNT
 |  |  |  |  |  |  |  |  |  |  |  |  |  | ALYSTHC | 2000-01-01 00:00:00 |  | 2000-02-01 00:00:00 |  | 2000-03-01 00:00:00 |  | 2000-04-01 00:00:00 |  | 2000-05-01 00:00:00 |  | 2000-06-01 00:00:00 |  | 2000-07-01 00:00:00 |  | 2000-08-01 00:00:00 |  | 2000-09-01 00:00:00 |  | 2000-10-01 00:00:00 |  | 2000-11-01 00:00:00 |  | 2000-12-01 00:00:00
 |  | ACTUAL |  | PLAN2000 |  |  |  | ACTUAL |  | PLAN2000
 |  | M.PER |  | M.PER |  |  |  | M.YTD |  | M.YTD |  |  |  |  | M.PER |  | M.PER |  | M.PER |  | M.PER |  | M.PER |  | M.PER |  | M.PER |  | M.PER |  | M.PER |  | M.PER |  | M.PER |  | M.PER
 |  |  |  |  |  | Monthly |  |  |  |  |  | YTD |  |  | January |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  | September |  | October |  | November |  | December
 |  | Actual |  | Plan |  | [NAME] |  | Actual YTD |  | Plan YTD |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
 | Direct Expense:
TOT_COMP | Compensation |  |  |  |  |  |  |  |  |  |  |  |  | Headcount
[NAME] | Benefits and Payroll Taxes |  |  |  |  |  |  |  |  |  |  |  |  | Analysts and Associates
TOT_EMP_EXP | Employee Expenses
TOT_RECRUITING | Recruiting & Relocations
TOT_OSIDE_SERV | Outside Services |  |  |  |  |  |  |  |  |  |  |  |  | Direct Expense:
[NAME] | Supplies and Expense |  |  |  |  |  |  |  |  |  |  |  |  | Compensation
TOT_MKT | Marketing |  |  |  |  |  |  |  |  |  |  |  |  | Benefits and Payroll Taxes
TOT_CHAR_CONT | Charitable Contributions |  |  |  |  |  |  |  |  |  |  |  |  | Employee Expenses
TOT_RENT | Rent (3rd Party) |  |  |  |  |  |  |  |  |  |  |  |  | Recruiting & Relocations
TOT_TECH | Technology |  |  |  |  |  |  |  |  |  |  |  |  | Outside Services
TOT_TRANS | Transportation |  |  |  |  |  |  |  |  |  |  |  |  | Supplies and Expense
CORP_IT | Corporate IT |  |  |  |  |  |  |  |  |  |  |  |  | Marketing
CORP_RENT | Corporate Rent |  |  |  |  |  |  |  |  |  |  |  |  | Charitable Contributions
TOT_OTH_EXP | Other Expenses |  |  |  |  |  |  |  |  |  |  |  |  | Rent (3rd Party)
[NAME] | Taxes Other Than Income |  |  |  |  |  |  |  |  |  |  |  |  | Technology
[PHONE] | Capital Allocation |  |  |  |  |  |  |  |  |  |  |  |  | Transportation
TOT_DEP_AMOR | Depreciation & Amortization |  |  |  |  |  |  |  |  |  |  |  |  | Corporate IT
 | Total Direct Expenses |  |  |  |  |  |  |  |  |  |  |  |  | Corporate Rent
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Other Expenses
9230999860 | Allocated Intercompany Billings |  |  |  |  |  |  |  |  |  |  |  |  | Taxes Other Than Income
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Capital Allocation
 | Net Expenses |  |  |  |  |  |  |  |  |  |  |  |  | Depreciation & Amortization
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Direct Expenses
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Allocated Intercompany Billings
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Net Expenses
Spreadsheet: michelle_lokay__26627__imbalsumm0102
Sheet: NNG

NNG
 | Measured | Scheduled | Imbalance
1635 | -48
3531 | -471107 | -385195
60667 | -288183 | -491655
60749 | 4760 | -8978
61206
61334 | -159766 | 0
62960
INDEX
2001-01-31 00:00:00 |  |  | 159600.24
2001-02-14 00:00:00
Spreadsheet: 05cafdf6-c136-464e-9d7c-9329763dfd2c
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | RESON: Count of items put on reserve each month - Moffitt Academic Year 2006-2007 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
Unit | Accum Total |  | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun
Moffitt | 5356 |  | 117 | 1340 | 619 | 146 | 113 | 48 | 1728 | 399 | 177 | 164 | 328 | 177
Spreadsheet: 730438d1619700856-average-non-continuous-cells-if-not-0-ef1522_2021-22-tracker-copy
Sheet: C3 E (Gra)

 | Class Attendance & Effort
 | Teacher |  |  |  |  |  |  |  |  |  |  | Course |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S month
 | Room |  |  |  |  |  |  |  |  |  |  | Period/Time |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Year
 | Pupils |  |  |  |  |  | Test name |  |  | Test name |  |  | Test name |  |  | Test name |  |  | Test name |  |  | Test name |  |  | Test name |  |  | Test name |  |  | Test name |  |  | Test name |  |  | Totals
 |  |  |  |  |  |  | Out of |  | 40 | Out of |  | ? | Out of |  | ? | Out of |  | ? | Out of |  | ? | Out of |  | ? | Out of |  | ? | Out of |  | ? | Out of |  | ? | Out of |  | ?
 | ID | Forename | Surname | Midys/additional | SEN | Target | M | % | Gra | /M | % | Gra | /M | % | Gra | /M | % | Gra | /M | % | Gra | /M | % | Gra | /M | % | Gra | /M | % | Gra | /M | % | Gra | /M | % | Gra | Average | On-track
 | 1 |  |  |  |  |  |  |  |  |  | 0 | 4 |  | 0 | 6 |  | 0 | 2 |  | 0 | 2 |  | 0 | 0 |  | 0 | 0 |  | 0 | 20 |  | 0 | 0 |  | 0 | 0
 | 2 |  |  |  |  |  |  |  |  |  |  | 3 |  |  |  |  |  | 5 |  |  |  |  |  | 9 |  |  | 7
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 20
 | 21
 | 22
 | 23
 | 24
 | 25
 | 26
 | 27
 | 28
 | 29
 | 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] a new row ABOVE this one: Right-click on the row number, select [NAME], then press Ctrl+d.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [42]
 |  |  |  |  |  |  | Bound |  | %
 |  |  |  |  |  |  |  | 9 | 0.9
 |  |  |  |  |  |  |  | 8 | 0.8
 |  |  |  |  |  |  |  | 7 | 0.7
 |  |  |  |  |  |  |  | 6 | 0.6
 |  |  |  |  |  |  |  | 5 | 0.5
 |  |  |  |  |  |  |  | 4 | 0.4
 |  |  |  |  |  |  |  | 3 | 0.3
 |  |  |  |  |  |  |  | 2 | 0.2
 |  |  |  |  |  |  |  | 1 | 0.1
 |  |  |  |  |  |  |  | 0 | 0
Spreadsheet: 94468d1294266790-countif-in-filtered-table-758852_cityofnr
Sheet: DATA

Date | Run # | Name | Amount2 | Balance | EMT1 | EMT2 | EMT3 | KEY
2011-01-01 00:00:00 | 2 | Doe,[NAME] | 200 | 200 | Sue | [NAME] | [NAME]
2011-01-02 00:00:00 | 3 | Deer,[NAME] | 200 | 0 | [NAME] | Sue | [NAME]
2011-01-03 00:00:00 | 2 | Doe,[NAME] | 100 | 25 | Sue | [NAME] | [NAME]
Spreadsheet: 174a123a-b730-4784-8753-600da4111155
Sheet: Kathleen Keenan

[NAME]
Fair Share Fee: Those Who Don't Pay Their Fair Share
Agree
Explain your fair share position, if you choose.
I have voted for the Agency fee bill every time it has come up in the House.
Teachers' Retirement: Support in the State Budget
Agree
Explain your teachers' retirement position, if you choose.
Underfunding of the pension systems is one of the most problematic issues we face. The teachers
system needs attention immediately and is a grave concern of mine!
Health Care: Continuing System Reform
Agree
Explain your health care reform position, if you choose
I am aware there are many concerns about the new system. To my knowledge there is nothing of
concern to the collective bargaining process. It is difficult to make any assumptions at this point.
Teaching Career: Retaining New Teachers
Agree
Explain your teaching career position, if you choose
No response
Teaching Profession: Simplifying Professional Relicensing
Agree
Explain your relicensing position, if you choose
Relicensing should be contingent on courses that align with the area of practice and should be made
available locally and within accessible time frames.
Name | email address | Address | Office sought | Are you an incumbent? |  | County
[NAME] | [EMAIL] | 8 Thorpe Avenue, St. Albans, Vt. 05478 | State Representative | Yes |  | Franklin
Spreadsheet: 138178d1327545049-hyperlink-with-a-vlookup-for-web-addresses-extract-hyperlink
Sheet: TR Menu

Course Title | Category | Credits | Focus Area/Objectives
Business | Web | 1 | Develop skills in Accounting
Finance | Web | 1 | Develop skills in Finance
Science | Web | 1 | Develop Skills in Science
Accounting | Class | 1 | Develop Skills in Accounting
Marketing | Class | 1 | Develop Skills in Marketing
Operations | Web | 1 | Develop Skills in Operations
Investments | Class | 1 | Develop skills in Invensments
Risk | Web | 1 | Develop Skills in Risk
Product Pricing | Class | 1 | Develop Skills in Product Pricing
Economics | Web | 1 | Develop skills in economics
Spreadsheet: 62109d1263012766-overtime-overtime-1-
Sheet: Sheet1

Shift | Start Time | End Time | Start Day | End Day | Rate |  | Est. tax
2 | 18:00:00 | 04:30:00 | 2010-01-04 00:00:00 | 2010-01-07 00:00:00 | 15.06 |  | 0.24
Day | Date | Start Time | End Time | Hours worked | Sraight Time |  | Over Time |  | Shift Prem |  | Short WW |  | Holiday |  | Vacation |  | Pay per Day
Sun | 2010-01-03 00:00:00 | 18:00:00
Mon | 2010-01-04 00:00:00 | 18:00:00 | 03:54:00 |  |  |  |  |  | 9.4 | 7.078200000000002
Tue | 2010-01-05 00:00:00 | 18:00:00 | 04:42:00 |  |  |  |  |  | 10 | 7.680600000000001
Wed | 2010-01-06 00:00:00 | 18:00:00 | 05:24:00 |  |  |  |  |  | 10 | 8.2077
Thu | 2010-01-07 00:00:00 | 18:00:00 | 05:30:00 |  |  |  |  |  | 10 | 8.283000000000001
Fri | 2010-01-08 00:00:00 | 18:00:00
Sat | 2010-01-09 00:00:00 | 18:00:00
 |  |  | Totals:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Gross Pay:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ~Taxes:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ~Net Pay:
Spreadsheet: 267614d1380120845-how-to-calculate-what-week-in-a-program-and-a-look-up-to-return-a-value-based-on-week-awh-test
Sheet: AWH Template

Week# | Hours
Week 1 | 0
Week 2 | 0
Week 3 | 3.5
Week 4 | 12.5
Week 5 | 15.5
Week 6 | 37.5
Week 7 | 37.5
Week 8 | 12
Week 9 | 11
Week 10 | 37.5
Week 11 | 37.5
Week 12 | 37.5
Week 13 | 18
Week 14 | 19
Program runs Monday - Friday, 1st day of the week is always a Friday
Spreadsheet: 706284d1606589516-prevent-excel-user-from-leaving-a-cell-blank-when-adjacent-cell-is-greater-than-zero-sample-spreadsheet
Sheet: DEC 1

 | MONDAY |  |  |  |  |  |  |  |  |  |  |  | TUESDAY |  |  |  |  |  |  |  |  |  |  |  | WEDNESDAY |  |  |  |  |  |  |  |  |  |  |  | THURSDAY |  |  |  |  |  |  |  |  |  |  |  | FRIDAY |  |  |  |  |  |  |  |  |  |  |  | TOTALS
Clinician Name | # Appointments Scheduled | Total Appointments Kept | Total Appointments Missed | Total Appts. Missed Due to Provider No-Show | Total Appt Encounter Forms Completed | # Notes Expected | # Notes Completed | # Group Members Expected | # of Members Actually Attended | # Group Encounter Forms Completed | # Group Notes Expected | # Group Notes Completed | # Appointments Scheduled | Total Appointments Kept | Total Appointments Missed | Total Appts. Missed Due to Provider No-Show | Total Appt Encounter Forms Completed | # Notes Expected | # Notes Completed | # Group Members Expected | # of Members Actually Attended | # Group Encounter Forms Completed | # Group Notes Expected | # Group Notes Completed | # Appointments Scheduled | Total Appointments Kept | Total Appointments Missed | Total Appts. Missed Due to Provider No-Show | Total Appt Encounter Forms Completed | # Notes Expected | # Notes Completed | # Group Members Expected | # of Members Actually Attended | # Group Encounter Forms Completed | # Group Notes Expected | # Group Notes Completed | # Appointments Scheduled | Total Appointments Kept | Total Appointments Missed | Total Appts. Missed Due to Provider No-Show | Total Appt Encounter Forms Completed | # Notes Expected | # Notes Completed | # Group Members Expected | # of Members Actually Attended | # Group Encounter Forms Completed | # Group Notes Expected | # Group Notes Completed | # Appointments Scheduled | Total Appointments Kept | Total Appointments Missed | Total Appts. Missed Due to Provider No-Show | Total Appt Encounter Forms Completed | # Notes Expected | # Notes Completed | # Group Members Expected | # of Members Actually Attended | # Group Encounter Forms Completed | # Group Notes Expected | # Group Notes Completed | SUM of Appointments Scheduled | SUM of Appointments Kept | SUM of Appointments Missed | SUM of Appts Missed Due to Provider No-Show | %of Appts Missed Due to Provider No-Show | SUM of Appt Encounter Forms Completed | % of Appointments Completed | SUM of Notes Expected | SUM of Notes Completed | % of Notes Completed | SUM of Group Members Expected | SUM of Members Who Attended | SUM of Group Encounter Forms Completed | SUM of Group Notes Expected | SUM of Group Notes Completed | % of Group Notes Completed
Spreadsheet: 700724d1603305624-match-column-and-row-help
Sheet: Sheet1

 | A | 2018 | 2019 | 2020 |  | B | 2018 | 2019 | 2020
 | Jan |  |  |  |  | Jan
 | Feb |  |  |  |  | Feb
 | Mar |  |  |  |  | Mar
 | Apr |  |  |  |  | Apr
 | May |  |  |  |  | May
 | Jun |  |  |  |  | Jun
 | Jul |  |  |  |  | Jul
 | Aug |  |  |  |  | Aug
 | Sep |  |  |  |  | Sep
 | Oct |  |  |  |  | Oct
 | Nov |  |  |  |  | Nov
 | Dec |  |  |  |  | Dec
 | 2018-01-01 00:00:00 | 2018-02-01 00:00:00 | 2018-03-01 00:00:00 | 2018-04-01 00:00:00 | 2018-05-01 00:00:00 | 2018-06-01 00:00:00 | 2018-07-01 00:00:00 | 2018-08-01 00:00:00 | 2018-09-01 00:00:00 | 2018-10-01 00:00:00 | 2018-11-01 00:00:00 | 2018-12-01 00:00:00 | 2019-01-01 00:00:00 | 2019-02-01 00:00:00 | 2019-03-01 00:00:00 | 2019-04-01 00:00:00 | 2019-05-01 00:00:00 | 2019-06-01 00:00:00 | 2019-07-01 00:00:00 | 2019-08-01 00:00:00 | 2019-09-01 00:00:00 | 2019-10-01 00:00:00 | 2019-11-01 00:00:00 | 2019-12-01 00:00:00 | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00
A | 0.3819386031219575 | 0.01553875746492084 | 0.825927189635823 | 0.6808414928072971 | 0.6729277348031367 | 0.7988991579593498 | 0.3881999887363397 | 0.3993794103551095 | 0.5716022678074695 | 0.02537570720896853 | 0.6935717657672082 | 0.8571988114361417 | 0.4366120456567927 | 0.5478628963822472 | 0.2426341714812504 | 0.7654723413384655 | 0.4436024925526709 | 0.08295986391583199 | 0.5768083833182093 | 0.8060625828782841 | 0.1944447874211125 | 0.446490929003016 | 0.1513022096832062 | 0.5826861083568914 | 0.7842675112489009 | 0.3029592684294782 | 0.6506531150625113 | 0.8149252460874757 | 0.1444515854351016 | 0.7147957138969442 | 0.09646443223625878 | 0.6255111605088843 | 0.8366803967718643 | 0.6863200351914394 | 0.7890495214218733 | 0.09215500626578188
B | 0.195346301197696 | 0.9722514494739396 | 0.676454416856217 | 0.169314484457414 | 0.3579723804203792 | 0.1160466902035634 | 0.3168682939225764 | 0.7912519546499635 | 0.2955876622401762 | 0.9152078184255381 | 0.8966192849389537 | 0.4530113100028373 | 0.2007212969356765 | 0.5570271002715937 | 0.07351966321051873 | 0.856662799710687 | 0.6292529759985591 | 0.9376670569454624 | 0.1668917354407586 | 0.0230173469886491 | 0.1086863468823256 | 0.3373370403350306 | 0.6311424314717445 | 0.5508755794246923 | 0.05533958820727403 | 0.221567073708171 | 0.3788297795373387 | 0.5092237468436794 | 0.3205193176880019 | 0.1985997302629368 | 0.2186855812848943 | 0.8914918586619556 | 0.6105217171962681 | 0.007466082425686471 | 0.5790084111432964 | 0.08626576337437031
Spreadsheet: 118818d1314027414-count-number-of-times-a-date-is-over-3-years-in-a-column-count-of-date-over-3-years
Sheet: PMHE licensing

 |  | [NAME] due every 3 years
Today's date | 2011-08-22 00:00:00
 |  | Need a formula to count the number of times a date in column B is 3 years past today's date.
 | Date Trainined
[NAME], F | 2009-10-15 00:00:00
Broad, W. | 2008-08-20 00:00:00
Daniels, S | 2009-10-26 00:00:00
Day, T. | 2009-10-19 00:00:00
Doe, [NAME] | 2009-10-26 00:00:00
Doe, [NAME] | 2009-10-18 00:00:00
Morrow, T. | 2009-11-16 00:00:00
Smith, J | 2009-08-01 00:00:00
Smithe, J | 2009-11-16 00:00:00
Toady, L | 2009-10-21 00:00:00
Wilkingson, B
Will, K. | 2009-10-09 00:00:00
Willow, C. | 2009-10-05 00:00:00
Wise, S | 2009-10-18 00:00:00
Spreadsheet: 220312d1363117268-is-there-a-way-to-automatically-work-out-stats-based-on-wins-and-losses-in-a-table-big-pots
Sheet: Sheet1

Last 6 game average
 | [NAME] |  | [NAME] |  | [NAME] |  | Mat Davies |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME]
Game 1 | W |  | W | L | W | W | W |  | W | W | W |  | L |  | W
Game 2 | W |  | W | W | W |  | L |  | W | W | W |  | W |  | W | L
Game 3 | W | W | W | L | L |  | W |  | W | W | L |  | W |  | W
Game 4 | W | W | W | W | L |  | L |  | W | W | W |  | W |  | W
Game 5 | W | L | L | W | W |  | W |  | W | W | W |  | L |  | L
Game 6 | W |  | W | W | L | L | W |  | W | W | W |  | W |  | W
Game 7 | L |  | W |  | W |  | W | W | W | W | W | W | W |  | W
Overall Average
Spreadsheet: 158543d1338302021-excel-2007-pivot-using-top-10-filter-and-subtotals-testing-pivot-table-subtotals-and-top10-filter
Sheet: pivot

 |  |  | Values
sales region | product line | customer group ID | Sum of Month Sales $x | Sum of YTD Sales $ x
COMPANY | Entry level | ANA58 | 3868403.13 | 93697856.64
 |  | CCT58 | 300729.655348031 | 19323912.98982402
 |  | KOZ58 | 523784.61 | 10904925.24
 |  | DLO58 | 355575.017384406 | 8736859.36750146
 |  | REN58 | 451674.916505881 | 8149414.10144658
 |  | NHA58 | 202068.71 | 4243562.76
 |  | NMT58 | 128839.78 | 3555551.04
 |  | DMT58 | 188038.08898857 | 3190434.345709722
 |  | BPE58 | 206939.27 | 3118027.08
 |  | OMT58 | 120189.37 | 3026387.46
Grand Total |  |  | 6346242.548226888 | 157946931.0244818
Spreadsheet: 878489d1725570530-how-to-sum-amounts-by-2-criteria-invoice-and-yes-test-etaf
Sheet: Sheet1

Invoice # | Line Amount | Include | Invoice Total | Included Total
12589 | 50 | Yes |  | 125
12589 | 75 | Yes
12589 | 20 | No
12590 | 100 | Yes |  | 100
12591 | 60 | Yes |  | 85
12591 | 25 | Yes
I know how to total by invoice number, but I am looking to add another criteria of only lines marked 'Yes'.
The answers I am looking for are in column E.