tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 139022d1328037613-summing-vlookup-for-multiple-accounts-copy-of-sales-example
Sheet: Sheet1

A. |  |  |  |  |  | B. |  |  |  |  |  |  |  |  | C.
Given (Data Set) |  |  |  |  |  | (Given sales) I have I want to be able to use vlookup to add the number ID next to sales ID) |  |  |  |  |  |  |  |  | Totals (What I want)
Number ID's | Sales ID's |  |  |  | Number ID | Sales ID | Sales |  |  |  |  |  |  |  | Number ID | Sales
66 | 322165 |  |  |  |  | 322165 | 20587 |  |  |  |  |  |  |  | 3 | 333
23 | 167673 |  |  |  |  | 167673 | 1914 |  |  |  |  |  |  |  | 4 | 6955
6 | 973109 |  |  |  |  | 973109 | 1896 |  |  |  |  |  |  |  | 6 | 16229
6 | 828477 |  |  |  |  | 828477 | 14333 |  |  |  |  |  |  |  | 8 | 1777
21 | 173437 |  |  |  |  | 173437 | 1234 |  |  |  |  |  |  |  | 11 | 4321
79 | 302699 |  |  |  |  | 302699 | 540 |  |  |  |  |  |  |  | 21 | 1234
79 | 279807 |  |  |  |  | 279807 | 220 |  |  |  |  |  |  |  | 23 | 1914
79 | 986619 |  |  |  |  | 986619 | 16890 |  |  |  |  |  |  |  | 29 | 321
79 | 986597 |  |  |  |  | 986597 | 17870 |  |  |  |  |  |  |  | 66 | 20587
4 | 875019 |  |  |  |  | 875019 | 6955 |  |  |  |  |  |  |  | 79 | 35520
3 | 615925 |  |  |  |  | 615925 | 333
29 | 305937 |  |  |  |  | 305937 | 321
11 | 843689 |  |  |  |  | 843689 | 4321 |  |  |  |  |  |  |  | Number ID | Sum of Sales
8 | 391549 |  |  |  |  | 391549 | 1777 |  |  |  |  |  |  |  | 3 | 333
5 | 454059 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 6955
3 | 423199 |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 16229
11 | 501781 |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 1777
88 | 617840 |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 | 4321
9 | 855628 |  |  |  |  |  |  |  |  |  |  |  |  |  | 21 | 1234
5 | 421067 |  |  |  |  |  |  |  |  |  |  |  |  |  | 23 | 1914
8 | 869414 |  |  |  |  |  |  |  |  |  |  |  |  |  | 29 | 321
20 | 777115 |  |  |  |  |  |  |  |  |  |  |  |  |  | 66 | 20587
20 | 863218 |  |  |  |  |  |  |  |  |  |  |  |  |  | 79 | 35520
20 | 338453 |  |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total | 89191
20 | 777799
20 | 406377
20 | 406749
6 | 378860
6 | 373279
1 | 452358
7 | 266435
10 | 773281
51 | 403726
51 | 658627
44 | 585614
19 | 891880
88 | 307171
79 | 765166
Spreadsheet: 58091d1258404465-tables-from-lists-707438-tables-from-lists
Sheet: Search

 |  |  |  |  | Area | Team Leader |  | Team Leader | Area
 | Search By:
 | Area
 | Leeds- Sales and Service
 | Name | Area | Team Leader | Complaint handling | TL cover | [NAME] | Audits | FOS submissions | MI | Mail | Logging work | CD burning/ call retrieval
 | [NAME] | Leeds- Sales and Service | [NAME]
 | [NAME] | Leeds- Sales and Service | [NAME]
 | [NAME] | Leeds- Sales and Service | [NAME]
 | [NAME] | Leeds- Sales and Service | [NAME]
 | [NAME] | Leeds- Sales and Service | [NAME]
 | [NAME] | Leeds- Sales and Service | [NAME]
 | [NAME] | Leeds- Sales and Service | [NAME]
 | [NAME] | Leeds- Sales and Service | [NAME]
 | [NAME] | Leeds- Sales and Service | [NAME]
 | [NAME] | Leeds- Sales and Service | [NAME]
 | [NAME] | Leeds- Sales and Service | [NAME]
 | [NAME] | Leeds- Sales and Service | [NAME]
 | Des Goaten | Leeds- Sales and Service | [NAME]
 | Alexa O Sullivan | Leeds- Sales and Service | [NAME]
 | [NAME] | Leeds- Sales and Service | [NAME]
 | [NAME] | Leeds- Sales and Service | [NAME]
 | [NAME] | Leeds- Sales and Service | [NAME]
 | [NAME] | Leeds- Sales and Service | [NAME]
 | [NAME] | Leeds- Sales and Service | [NAME]
Spreadsheet: 775536d1649168179-i-would-like-to-remove-unit-suite-and-floor-from-and-addresses-revised-sample-address-file
Sheet: Sheet1

Current Address Format |  | Desired Address Format
8006 DISCOVERY DR STE 300 |  | 8006 Discovery Place | STE 300
7319 SPRING HILL DR
303 PEACHTREE CENTER AVE NE STE 200 |  | 303 Peachtree Center Ave NE | STE 200
2520 NORTHWINDS PKWY FL 4 |  | 2520 Northwinds Pkwy | FL 4
7455 CHANCELLOR DR FL 2 |  | 7455 Chancellor Dr | FL 2
3333 PEACHTREE RD NE FL 10 |  | 3333 Peachtree Rd NE | FL 10
110 S STRATFORD RD FL 3 |  | 110 S Stratford Rd | FL 3
434 FAYETTEVILLE ST FL 29 |  | 434 [NAME] | FL 29
150 W MAIN ST FL 14 |  | 150 W Main St | FL 14
1445 NEW YORK AVE NW FL 4 |  | 1445 New York Ave NW | FL 4
214 N TRYON ST FL 19 |  | 214 N Tryon St | FL 19
3333 PEACHTREE RD NE FL 11 |  | 3333 Peachtree Rd NE | FL 11
2 W WASHINGTON ST STE 800 |  | 2 Washington St | Ste 800
3333 PEACHTREE RD NE FL 10 |  | 3333 Peachtree Rd NE | FL 10
1001 SEMMES AVE FL 6 |  | 1001 Semmes Ave | FL 6
303 PEACHTREE CENTER AVE NE STE 200 |  | 303 Peachtree Ave NE | Ste 200
2636 W NORTH AVE UNIT 1A |  | 2636 W North Ave | Unit 1A
41 RACHEL DR
7455 CHANCELLOR DR
101 N CHERRY ST FL 7 |  | 101 N [NAME] | FL 7
Spreadsheet: 40581d1238957136-median-with-date-range-sample_median_2
Sheet: Sheet1

 |  |  | Type |  |  | value | date
740514 | 2990 | CLERMONT | A | 1199000 | 2006-09-18 00:00:00
755471 | 3390 | BELLAIRE | A | 1250000 | 2005-09-01 00:00:00
734627 | 3322 | CHERRY | S | 729000 | 2009-01-15 00:00:00 | 707000 | 2009-03-23 00:00:00 | 0 | N | 0 | BANK
730580 | 3034 | COLORADO | S | 325000 | 2009-01-01 00:00:00 | 315000 | 2009-03-05 00:00:00 | 6500 | CC | 0 | CORP
717435 | 3315 | BIRCH | S | 684900 | 2008-10-31 00:00:00 | 642000 | 2008-12-26 00:00:00 | 22335 | PP | 0 | BANK
714686 | 3200 | DAHLIA | S | 247900 | 2008-10-20 00:00:00 | 219000 | 2009-01-30 00:00:00 | 6570 | CC | 0 | INDIV
712029 | 3039 | CLERMONT | S | 324900 | 2008-10-14 00:00:00 | 320000 | 2008-12-24 00:00:00 | 0 | N | 0 | INDIV
711053 | 2848 | GRAPE | S | 199900 | 2008-10-10 00:00:00 | 200000 | 2008-11-03 00:00:00 | 5600 | CC | 0 | INDIV
708172 | 3070 | DAHLIA | S | 132900 | 2008-10-02 00:00:00 | 135600 | 2008-11-26 00:00:00 | 0 | N | 0 | BANK
708290 | 3051 | BELLAIRE | S | 640500 | 2008-10-02 00:00:00 | 535000 | 2009-03-04 00:00:00 | 0 | N | 0 | BANK
703374 | 3034 | COLORADO | S | 145900 | 2008-09-16 00:00:00 | 140000 | 2008-10-13 00:00:00 | 0 | N | 0 | BANK
709236 | 3357 | FLAMINGO | S | 220000 | 2008-09-16 00:00:00 | 176000 | 2009-01-16 00:00:00 | 0 | N | 0 | INDIV
729382 | 3024 | BIRCH | S | 845000 | 2008-08-29 00:00:00 | 712300 | 2009-02-04 00:00:00 | 6700 | CC | 0 | INDIV
695041 | 3021 | DEXTER | S | 236900 | 2008-08-22 00:00:00 | 185000 | 2009-03-12 00:00:00 | 0 | N | 0 | CORP
706328 | 2932 | FAIRFAX | S | 199900 | 2008-08-22 00:00:00 | 206000 | 2008-11-19 00:00:00 | 6000 | CC | 0 | INDIV
708269 | 4891 | CORNELL | S | 149900 | 2008-08-21 00:00:00 | 153000 | 2008-11-13 00:00:00 | 2000 | CC | 0 | BANK
691024 | 2806 | DAHLIA | S | 189900 | 2008-08-13 00:00:00 | 160000 | 2008-09-19 00:00:00 | 0 | N | 0 | INDIV
criteria
date between 1-oct-08 and 1-nov-08 so result set would be.
714686 | 3200 | DAHLIA | S | 247900 | 2008-10-20 00:00:00 | 219000 | 2009-01-30 00:00:00 | 6570 | CC | 0 | INDIV
712029 | 3039 | CLERMONT | S | 324900 | 2008-10-14 00:00:00 | 320000 | 2008-12-24 00:00:00 | 0 | N | 0 | INDIV
711053 | 2848 | GRAPE | S | 199900 | 2008-10-10 00:00:00 | 200000 | 2008-11-03 00:00:00 | 5600 | CC | 0 | INDIV
708172 | 3070 | DAHLIA | S | 132900 | 2008-10-02 00:00:00 | 135600 | 2008-11-26 00:00:00 | 0 | N | 0 | BANK
708290 | 3051 | BELLAIRE | S | 640500 | 2008-10-02 00:00:00 | 535000 | 2009-03-04 00:00:00 | 0 | N | 0 | BANK
then I believe those need to be sorted by value
708172 | 3070 | DAHLIA | S | 132900 | 2008-10-02 00:00:00 | 135600 | 2008-11-26 00:00:00 | 0 | N | 0 | BANK
711053 | 2848 | GRAPE | S | 199900 | 2008-10-10 00:00:00 | 200000 | 2008-11-03 00:00:00 | 5600 | CC | 0 | INDIV
714686 | 3200 | DAHLIA | S | 247900 | 2008-10-20 00:00:00 | 219000 | 2009-01-30 00:00:00 | 6570 | CC | 0 | INDIV
712029 | 3039 | CLERMONT | S | 324900 | 2008-10-14 00:00:00 | 320000 | 2008-12-24 00:00:00 | 0 | N | 0 | INDIV
708290 | 3051 | BELLAIRE | S | 640500 | 2008-10-02 00:00:00 | 535000 | 2009-03-04 00:00:00 | 0 | N | 0 | BANK
then we need the median value from this result set
219000 | median
Spreadsheet: 849121d1699648712-how-to-copy-formulas-across-the-row-when-criteria-are-in-static-cells-sample-report-purchase-and-supplier-payments-ans
Sheet: Purchase Forecast 

 |  |  | Purchase Budget
 |  | Month of Purchase |  |  |  |  |  |  |  |  | Procurement period |  |  | Item | Forecast Month
 |  | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 60 Days | 30 days | 0 Days |  | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00
 |  |  |  |  |  |  | ??? | ??? | ??? | ???? | 0.25 | 0.5 | 0.25 | Stock & Purchase - PT A | 300000 | 250000 | 150000 | 300000 | 450000 | 250000
 |  |  |  |  |  |  | ???? | ???? | ???? | ??? | 0.2 | 0.6 | 0.2 | Stock & Purchase - PT B | 250000 | 100000 | 150000 | 75000 | 100000 | 125000
Spreadsheet: 177601d1346355656-how-to-populate-workbook-pages-from-microsoft-query-copy-of-total-misses-for-period-6
Sheet: 7-072,080

 |  |  |  |  |  |  |  | 7-072   7-080
 |  |  |  |  |  |  |  | TOTAL MISSES FOR THIS PAY PERIOD
CHPUB | CHACT# | CHDIST | CHRTE | CHTIME | CHTTYP | CHTRCD | UNNBR | PREDIR | STREET | SUFFIX | PSTDIR | SUNTYP | SUNNBR | POZIP5 | CHSTAT | CHSMM | CHSDD | CHSYY
Spreadsheet: 6b6e8ebd-675a-475b-8b56-15cd6b7d5f29
Sheet: Sheet1

A = agree | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19
M= maybe
D = disagree
Main categories are highlighted with color. However not always the numbers under the category are adding up. This is because if the same expert commented in 2 or more topics in a group, is only concidered once in the total count.
We have:
15 PhDs, 7 MDs, and 6 MD/PhDs
19 men and 9 women
16 interviewed in person and 12 interviewed over the phone
9 received their first doctorate degree up to 1986, 11 from 1986 to 1995, and 8 after 1995
In total: 28 experts
Expert Groups:
[NAME], MD (or equivalent), MD/PhD
PhD: | 2 | 9 | 10 | 11 | 12 | 15 | 16 | 18 | 19 | 20 | 22 | 24 | 25 | 26 | 28
MD: | 1 | 5 | 6 | 7 | 8 | 14 | 17
MD/PhD: | 3 | 4 | 13 | 21 | 23 | 27
ii. Men, Women
M: | 1 | 2 | 3 | 4 | 5 | 6 | 8 | 9 | 10 | 13 | 16 | 17 | 18 | 20 | 21 | 22 | 24 | 26 | 27
W: | 7 | 11 | 12 | 14 | 15 | 19 | 23 | 25 | 28
iii. UChicago / in person, Elsewhere / over the phone
in person: | 1 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17
over the phone: | 2 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28
iv. Year of first medical or doctorate degree (ie years of experience as expert)
before 70: | 21
71-75: | 10
76-80: | 14 | 22
81-85: | 8 | 16 | 20 | 27 | 28
86-90: | 5 | 7 | 9 | 12 | 24 | 26
91-95: | 6 | 13 | 15 | 18 | 23
96-00: | 1 | 2 | 3 | 4 | 11 | 17 | 19 | 25
Spreadsheet: 68988d1269520469-using-month-formulas-to-count-data-book1
Sheet: Customer Complaints

 | Customer Complaints
 | Date Opened | Date Closed | Customers Name | Policy Number | Brief description of complaint | Complaint resolved within 24hrs? | Was compensation provided? | If yes, how much?
 | 2010-01-01 00:00:00 | 2010-01-02 00:00:00 |  |  |  | Yes |  | 676
 | 2010-01-02 00:00:00 | 2010-01-11 00:00:00 |  |  |  | No |  | 766
 | 2010-01-03 00:00:00 | 2010-01-12 00:00:00 |  |  |  | No |  | 777
 | 2010-01-04 00:00:00 | 2010-02-02 00:00:00 |  |  |  | No |  | 444
 | 2010-01-05 00:00:00 | 2010-02-03 00:00:00 |  |  |  | No |  | 444
 | 2010-02-01 00:00:00 | 2010-02-02 00:00:00 |  |  |  | Yes |  | 444
 | 2010-02-02 00:00:00 | 2010-02-16 00:00:00 |  |  |  | No |  | 444
 | 2010-02-03 00:00:00 | 2010-02-17 00:00:00 |  |  |  | No
 | 2010-02-04 00:00:00 | 2010-02-18 00:00:00 |  |  |  | No
 | 2010-02-05 00:00:00 | 2010-03-01 00:00:00 |  |  |  | No
Spreadsheet: 59624d1260217146-excel-2007-checking-a-range-of-dates-with-if-or-select-case-example1
Sheet: TA2008-24

FLEXIBLE SCHEDULE CERTIFICATION FORM
NAME: |  |  |  |  |  |  |  |  |  |  |  | Established Hours:
 |  |  |  |  |  |  |  |  |  |  |  | M | 06:30:00 | 16:30:00 | M: | 06:30:00 | 16:30:00
ORG: |  |  |  |  |  |  |  |  |  |  |  | T: | 06:30:00 | 16:30:00 | T: | 06:30:00 | 16:30:00
 |  |  |  |  |  |  |  |  |  |  |  | W | 06:30:00 | 16:30:00 | W: | 06:30:00 | 16:30:00
PP Ending: |  |  |  |  |  |  |  |  |  |  |  | T: | 06:30:00 | 16:30:00 | T: | 06:30:00 | 16:30:00
 |  | PP | 08-24 |  |  |  |  |  |  |  |  | F: | off | off | F: | off | off
 |  | Working Hours |  | Time in Duty Status |  |  |  | *Telework Hours |  | Credit Hours |  |  | [NAME]
Date |  | Arrive | [NAME] | Regular | Overtime | Comp | Holiday | Worked | Code | Earned | Used | Balance | Annual | Sick | Comp | LWOP | Other | Remarks
Previous Balance
S | 2008-11-09 00:00:00
M
T |  | Veteran's Day
W
T
F
S
S
M
T
W
T
F
S
Ending Balance |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL PAYABLE HRS.
Totals
 | Employee Signature: |  |  |  |  |  |  |  |  |  | Supervisor Signature:
 |  |  |  |  |  |  |  |  |  |  |  | *Telework Indicator Codes
 |  |  |  |  |  |  |  |  |  |  |  | Code |  | "Fixed" Telework Agreement
 |  |  |  |  |  |  |  |  |  |  |  | C | 3 or more days per week at alternate work site
 |  |  |  |  |  |  |  |  |  |  |  | F | 2 or fewer days per week at alternate work site
 |  |  |  |  |  |  |  |  |  |  |  | Code |  | “As Needed” Telework Agreement
 |  |  |  |  |  |  |  |  |  |  |  | I | Work performed at alternate work site
 |  |  |  |  |  |  |  |  |  |  |  | The Telework columns are to be left blank for those
 |  |  |  |  |  |  |  |  |  |  |  | employees who did not work at an alternate worksite during
 |  |  |  |  |  |  |  |  |  |  |  | the Pay Period.
Spreadsheet: 039c03ba-a28a-474d-98a9-bdf17ceec38a
Sheet: Sheet1

Qualified Substance Use Disorders Trainee (QSUDPT) Applicant Documentation Checklist | Unnamed: 1 | Unnamed: 2
IDAPA 16.07.20 subsection 223
Submit documentation to [NAME] at [EMAIL] or fax to [PHONE]
Name:
Documentation- Certification/Licensure (one of the following) | Documentation to be submitted to SUD Bureau in compliance with IDAPA  16.07.20, subsection 223 | a
ISAS (Idaho Student in Addiction Studies) | Copy of current IBADCC Certificate                         (No other certificate will be accepted)
ICRC Trainee (International Certification & Reciprocity Consortium) | Copy of current ICRC documentation for Trainees
[NAME] (Native American Certified Alcohol/Drug Abuse Counselor Intern) | Copy of current NACADC Certification
Northwest Indian A/D Specialist Counselor Intern | Copy of current NW Indian A/D Specialist documentation for Interns (Chemical Dependency Specialist I)
Idaho Licensed Clinical Social Worker or Idaho Licensed Masters Social Worker | Copy of current Idaho License(s)
Idaho Licensed Marriage and [NAME], Idaho Registered Marriage & Family Therapist Intern or Idaho Licensed Associate Marriage & Family Therapist | Copy of current Idaho License(s)
Idaho Licensed Nurse Practitioner | Copy of current Idaho License
Idaho [NAME] Nurse Specialist | Copy of current Idaho License
Idaho [NAME] Assistant | Copy of current Idaho License
Idaho Licensed Professional Counselor or Idaho Licensed Clinical Professional Counselor | Copy of current Idaho License(s)
Idaho Licensed Psychologist or Idaho Licensed Psychologist Extender | Copy of current Idaho License(s)
Idaho [NAME] | Copy of current Idaho License
Idaho Licensed Professional Nurse (RN) | Copy of current Idaho License
QSUDPT Initial Professional Development Plan | Located on DHW/SUD Qualified Professionals web page - complete and submit according to instructions
Professional Development Plan - Intensify Supervision according to observations and rating scale scores | Located on DHW/SUD Qualified Professionals web page - complete and submit according to instructions
Continuing QSUDP approval is dependent upon the applicant maintaining current Idaho licensure.  Copies of all certifications and licensure need to be sent to the Department upon receipt of your renewal from the credentialing authority.
IDAPA Website:   http://adm.idaho.gov/adminrules/rules/idapa16/0720.pdf
DHW/SUD Qualified Professionals web page:  [NAME]
(Form updated 010412)
Spreadsheet: 840534d1692803766-need-to-enter-data-3-times-a-day-on-same-date-richbauer-blood-pressure-log-sample
Sheet: Blood Pressure Log

Blood Pressure Log
Name | [Your Name] | Your Age
D.O.B | 1967-07-12 00:00:00
[NAME] | 120 | mmHg
[NAME] | 80 | mmHg                      from
Normal Pulse | 60 | BPM                             to
Date | [NAME]  (mmHg) | [NAME]  (mmHg) | Pulse  (BPM) | [NAME]  (mmHg) | [NAME]  (mmHg) | Noon Pulse  (BPM) | [NAME]  (mmHg) | Night Diastolic  (mmHg) | Night Pulse  (BPM) | [NAME] | Column1 | [NAME] | Normal Puls
2014-02-25 00:00:00 | 135 | 80 | 65 | 162 | 96 | 78 | 108 | 64 | 52
2014-02-26 00:00:00 | 130 | 82 | 64 | 156 | 98 | 77 | 104 | 66 | 51
2014-02-27 00:00:00 | 129 | 80 | 65 | 155 | 96 | 78 | 103 | 64 | 52
2014-02-28 00:00:00 | 135 | 85 | 68 | 162 | 102 | 82 | 108 | 68 | 54
2014-03-01 00:00:00 | 140 | 90 | 72 | 168 | 108 | 86 | 112 | 72 | 58
2014-03-02 00:00:00 | 135 | 85 | 68 | 162 | 102 | 82 | 108 | 68 | 54
2014-03-03 00:00:00 | 125 | 80 | 65 | 150 | 96 | 78 | 100 | 64 | 52
2014-03-04 00:00:00 | 128 | 80 | 64 | 154 | 96 | 77 | 102 | 64 | 51
2014-03-05 00:00:00 | 135 | 84 | 63 | 162 | 101 | 76 | 108 | 67 | 50
2014-03-06 00:00:00 | 140 | 90 | 70 | 168 | 108 | 84 | 112 | 72 | 56
2014-03-07 00:00:00 | 135 | 80 | 65 | 162 | 96 | 78 | 108 | 64 | 52
2014-03-08 00:00:00 | 130 | 80 | 65 | 156 | 96 | 78 | 104 | 64 | 52
2014-03-09 00:00:00 | 120 | 80 | 60 | 144 | 96 | 72 | 96 | 64 | 48
2014-03-10 00:00:00 | 125 | 80 | 60 | 150 | 96 | 72 | 100 | 64 | 48
2014-03-11 00:00:00 | 125 | 80 | 65 | 150 | 96 | 78 | 100 | 64 | 52
2014-03-12 00:00:00 | 130 | 85 | 65 | 156 | 102 | 78 | 104 | 68 | 52
2014-03-13 00:00:00 | 125 | 85 | 60 | 150 | 102 | 72 | 100 | 68 | 48
2014-03-14 00:00:00 | 130 | 80 | 65 | 156 | 96 | 78 | 104 | 64 | 52
2014-03-15 00:00:00 | 125 | 80 | 65 | 150 | 96 | 78 | 100 | 64 | 52
2014-03-16 00:00:00 | 130 | 80 | 70 | 156 | 96 | 84 | 104 | 64 | 56
2014-03-17 00:00:00 | 130 | 80 | 75 | 156 | 96 | 90 | 104 | 64 | 60
Spreadsheet: 0f05b788-4497-4e9e-a8d7-71ed8a579a37
Sheet: 11b

Product | EUR** | GBP | [NAME] | USD | TOTAL
Basis* | <100 | <100 | 106 | 248 | 354
FRA | 3544 | 1860 |  | 3466 | 8870
IRS- [NAME] | 7966 | 1733 | 1356 | 11458 | 22513
OIS | 506 | 216 |  | 488 | 1210
VNS | <100 |  |  |  | <100
Zero Coupon | <100 | <100 |  | <100 | <100
TOTAL | 12016 | 3809 | 1462 | 15660 | 32947
Estimated swap transaction volumes, week ending November 30, by product type and supermajor currency (in number of transactions), all participant types, cleared and uncleared.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown.
*See Data Dictionary for product descriptions.
**See Data Dictionary for supermajor currency descriptions.
***N/A indicates that data are not currently available.
Note: Transaction volumes currently include house and client trades by FCMs in the interest rate asset class.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 545918d1509723032-formula-for-computing-frequency-of-programs-across-years-copy-of-sample_set_2-darko_giac-
Sheet: Sheet1

 |  |  |  |  |  |  | Count of Years:
Row Labels | Count of Year |  |  |  |  |  | Year
ABCD | 4 |  |  |  |  |  | 2010
2010 | 1 |  |  |  |  |  | 2011
2011 | 1 |  |  |  |  |  | 2012
2012 | 1 |  |  |  |  |  | 2013
2015 | 1 |  |  |  |  |  | 2014
ABCD.ADM | 5 |  |  |  |  |  | 2015
2012 | 1 |  |  |  |  |  | 2016
2013 | 1
2014 | 1
2015 | 1
2016 | 1
ABCD.HLTH | 5
2012 | 1
2013 | 1
2014 | 1
2015 | 1
2016 | 1
IMG.DIPLOMA | 7
2010 | 1
2011 | 1
2012 | 1
2013 | 1
2014 | 1
2015 | 1
2016 | 1
Grand Total | 21
Spreadsheet: 880163d1727786131-data-text-from-one-tab-into-another-sample-recall-list-v230924
Sheet: Template

Unique ID | Last Name | First Name | Full Name | Birth Date | Employee Email Address | Position (Job Role) | Business Unit/Function - (Division) | Location | Area - (Department) | Location - (Screen Location) | Manager | Line Manager [NAME]
NZ091442D | [NAME] | [NAME] |  | 1973-01-25 00:00:00 | [EMAIL] | Supervisor | Building Products & National Businesses | Norfolk | Norfolk Highway Services | Norfolk | Mr [NAME] | [EMAIL]
YS282853A | Rees | [NAME] |  | 1952-03-09 00:00:00 |  | Fitter | South West & Wales | Port Talbot | South West & Wales Operations A&A | Port Talbot | Mr [NAME] | [EMAIL]
JE904163D | Walsh | [NAME] |  | 1976-09-03 00:00:00 |  | [NAME] | South East | Ship Based | South East Marine | Ship Based | Mr [NAME] | [EMAIL]
JJ278383D | Aarons | [NAME] |  | 1982-04-30 00:00:00 | [EMAIL] | Operative | Packed Products & Powders | Linford | Operations | Linford | Mr [NAME] | [EMAIL]
Spreadsheet: 881450d1729524711-xirr-vs-irr-xirr-not-working-irr-vs-xirr-inquiry
Sheet: sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  | `
 |  | [NAME]
 |  | Annual Discount Rate/WACC | 0.2
 |  | Monthly Discount Rate/WACC |  |  | 2 | 2 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
 |  | Project Start Date | 2025-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2025-01-31 00:00:00 | 2026-12-31 00:00:00
 |  | Period | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 1 | 2 | 3 | 4
 |  | Monthly Cost/Benefits
 |  | Year # | Year 1 |  |  |  |  |  |  |  |  |  |  |  | Year 2 |  |  |  |  |  |  |  |  |  |  |  | Year 3 |  |  |  |  |  |  |  |  |  |  |  | Year 4 |  |  |  |  |  |  |  |  |  |  |  | Year 5
 |  | Month End Date |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yr 1 Total | Yr 2 Total | Yr 3 Total | Yr 4 Total | Yr 5 Total
 |  | Cost | (enter as negative #) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | . | .
1 |  | cash outflow | -123421
2
3
6
4
5
7
8
15
16
9
10
11
12
13
14
17
18
19
20
 |  | Total Cost
 | 1 | Benefit
1 |  | cash inflow | 0 | 0 | 0 | 0 | 0 | 399.2718615937629 | 8088.564080104465 | 21640.36945424066 | 25575.45836087363 | 33060.49866631022 | 32215.06566543295 | 34693.55960807716 | 39137.02442441636 | 42235.00782191439 | 48013.74959107523 | 48160.63269628701 | 51545.79222992214 | 48030.41962003114 | 51244.58961903141 | 51294.08105223044 | 49160.13524483633 | 50058.95687296975 | 42848.97066196741 | 44747.09301144001 | 61558.90607451415 | 73823.07624467858 | 86437.96524770558 | 85170.14889412094 | 88055.50308226212 | 82462.07496430981 | 84130.89854207169 | 83761.62721814425 | 81599.8867949706 | 82970.59181242879 | 71122.63241413631 | 66118.99357843655
2
3
6
4
5
7
8
15
16
9
10
 |  | Total Benefit
 |  | Total Cash Flow
 |  | Discount Factor
 |  | Discounted Cash Flow
 |  | Cumulative DCF
 |  | (A) Last Period w Negative DCF
 |  | (B) Abs value of DCF at the end of A | 0
 |  | (C) DCF during the period after A
 |  | (DPP) = A + (B / C) in months
 |  | PBP in Years
 |  | PBP in years |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PBP (yrs)
 |  | NPV
 |  | ROI |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ROI
 |  | IRR
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XIRR