tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 06f9d68f-01b7-4c86-b91c-0e4f460095c1
Sheet: New Budget

New Budget/Chart Request Form
Note:  All "Y" budgets, MUST fill out the UBIT Questionnaire found on General Accountings Web page Questionnaire
under Links at bottom of the page. |  |  |  | http://www/uihome.uidaho.edu/default.aspx?pid=79447
To Be Completed By Requesting Department |  |  |  |  | Chart: | 9 |  | Effective Date:
Orgn: |  |  |  | Title:
 |  |  |  |  |  | 35 characters maximum
Purpose:
How will the money be expended:
Activity:  On Campus |  |  |  |  | Off Campus |  |  | Check One
Estimated Income |  |  | Identify Sources and Amounts: |  |  |  | Descriptions
Sales & Services: |  |  | R______ | $
Spec Course/Wrkshp Fees: |  |  | R______ | $ |  | Attach Approved Request for Special Lab & Course Fee
[NAME]: |  |  | R______ | $
Other Sources: |  |  | R______ | $
Estimated Expenditures |  |  |  |  |  |  | Comments
 |  | Salaries 01: | $
 |  | Fringe Benefits 02: | $
 |  | Temporary Help 03: | $
 |  | Travel 04: | $
 |  | Operating Expenses 05: | $
 |  | Capital Outlay > $5,000. 06: | $
 |  | Capital Outlay 07: | $
 |  | Reserves 08: | $
 |  | Trustee/ Benefit 10: | $
 |  | Transfers 15: | $
 |  | Total: | $
Reporting Department: |  |  |  |  |  | Note:  [NAME] code will be assigned to this department
Requested by: |  |  |  |  |  |  |  | Date:
 |  |  |  | Signature |  |  | Phone #
Department Head: |  |  |  |  |  |  |  | Date:
 |  |  |  | Signature |  |  | Phone #
[NAME]: |  |  |  |  |  |  |  | Date:
 |  |  |  | Signature |  |  | Phone #
**FOR OFFICE USE ONLY**
To:  General Accounting
Program Code:
Fund: |  |  |  | Predecessor: |  |  |  | Fund Type:
Orgn: |  |  |  | Predecessor: |  |  |  | Index:
 | Default Bank Code: | 12 |  | Edits: | Fund:   Y   N         Orgn:   Y   N         Prog:   Y   N
BSAS: |  |  |  |  | Entered by: |  |  | Date:
 | Signature
Spreadsheet: 760867d1640480404-return-text-that-is-not-equal-to-a-value-microsoft-excel-worksheet
Sheet: Sheet1

Column 1 | column 2 | Column 3 | Column 4
Apple | No | No | Apple
No | No | Orange | Orange
No | Grapes | No | Grapes
Kiwi | No | No | Kiwi
Spreadsheet: 717787d1612857259-conditional-formatting-between-two-sheets-book1-13-ans
Sheet: Raw Data

Number | Participant_First_Name | Participant_Last_Name | DOB | Rep | Services | Services_2 | Services_3
100 | Name 1 | Surname 1 | 2014-07-08 00:00:00 | Individual | Assessment and report
101 | Name 2 | Surname 2 | 2014-06-25 00:00:00 | Individual | Assessment and report | , Individual intervention
102 | Name 3 | Surname 3 | 2006-11-06 00:00:00 | Individual | Assessment and report | , Psychology Service | , [NAME]
103 | Name 4 | Surname 4 | 2003-03-14 00:00:00 | Individual | Assessment and report | , Psychology Service | , Individual intervention
104 | Name 5 | Surname 5 | 2014-01-23 00:00:00 | Individual | Physiotherapy
105 | Name 6 | Surname 6 | 2016-07-06 00:00:00 | Individual | Assessment and report | , [NAME] therapy
106 | Name 7 | Surname 7 | 23/6/1967 | Organisation | Physiotherapy | , Psychology Service | , Assessment and report
107 | Name 8 | Surname 8 | 2010-02-09 00:00:00 | Individual | Art therapy
108 | Name 9 | Surname 9 | 2013-08-29 00:00:00 | Individual | Art therapy
109 | Name 10 | Surname 10 | 2008-09-24 00:00:00 | Individual | Art therapy | , Assessment and report
110 | Name 11 | Surname 11 | 2011-01-01 00:00:00 | Individual | Art therapy | , Assessment and report
111 | Name 12 | Surname 12 | 2000-08-17 00:00:00 | Individual | Art therapy | , Psychology Service
112 | Name 13 | Surname 13 | 2003-06-20 00:00:00 | Individual | Art therapy
Spreadsheet: 103372d1301095786-help-with-index-match-and-offset-forumla-pipeline-report
Sheet: Report

 | Pipeline Report
 |  |  |  |  |  |  |  | Notes: | The same company can be in different parts of the pipeline (statuses).
 |  |  |  |  |  |  |  |  | If a company is in two different parts of the pipeline (e.g. in Active & Prospect), it will have different information for the clients and target tab.
 | *(Data on Seperate Tab) |  |  |  |  |  |  |  | My main problem is getting the client (target) tab generated from the data in the separate tab.
 |  |  | Work so Far |  |  |  |  |  |  |  | What it should look like
(hide) | (hide) | (hide)
Criteria | Criteria | Row | Status | Sector | Sub-Sector | Company | Client (Target) |  |  |  | Status | Sector | Sub-Sector | Company | Client (Target)
 |  |  | Active |  |  |  |  |  |  |  | Active
 |  |  |  | Sector 1 |  |  |  |  |  |  |  | Sector 1
 |  |  |  |  | Sub-Sector A |  |  |  |  |  |  |  | Sub-Sector A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Company A | Bob(15)+Sue(12)+David(5)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Company F | David+John(75)
 |  |  |  |  |  |  |  |  |  |  |  |  | Sub-Sector B
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Company C | Mary(55)
 |  |  |  |  |  |  |  |  |  |  |  | Sector 2
 |  |  |  |  |  |  |  |  |  |  |  |  | Sub-Sector C
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Company B | Bob+Sue+David+John(6)+Mary(3)
 |  |  |  |  |  |  |  |  |  |  |  |  | Sub-Sector D
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Company D | Sue(87)+John(655)+Mary(45)
 |  |  |  |  |  |  |  |  |  |  | Prospect
 |  |  |  |  |  |  |  |  |  |  |  | Sector 1
 |  |  |  |  |  |  |  |  |  |  |  |  | Sub-Sector A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Company A | John(8)+Mary
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Company F | Mary(45)+Bob(33)+Sue(1)
 |  |  |  |  |  |  |  |  |  |  |  |  | Sub-Sector B
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Company C | [NAME])
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Company E | Mary+David(155)+John(65)+Sue(23)+Bob
 |  |  |  |  |  |  |  |  |  |  |  | Sector 2
 |  |  |  |  |  |  |  |  |  |  |  |  | Sub-Sector D
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Company D | Bob+David(12)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Company G | Sue+John(14)
 |  |  |  |  |  |  |  |  |  |  | Closed
 |  |  |  |  |  |  |  |  |  |  |  | Sector 1
 |  |  |  |  |  |  |  |  |  |  |  |  | Sub-Sector B
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Company C | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | Sector 2
 |  |  |  |  |  |  |  |  |  |  |  |  | Sub-Sector D
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Company G | Mary(18)+Bob(98)+David(62)
Spreadsheet: 585107d1533632880-deleting-lines-from-a-list-test-6-
Sheet: Sheet2

email | Remark
[EMAIL] | Select For Delete
[EMAIL] | Select For Delete
[EMAIL] | Select For Delete
[EMAIL] | Select For Delete
[EMAIL] | Select For Delete
[EMAIL] | Select For Delete
[EMAIL] | Select For Delete
[EMAIL] | Select For Delete
[EMAIL] | Select For Delete
Spreadsheet: 885853d1735730547-formula-working-inconsistently-formula-not-working-on-all-instances
Sheet: Sheet1

Reporter | Date of Article | Was the article accurate? | Merger confirmed
[NAME] | 2024-02-23 00:00:00 | Yes | 2024-03-30 00:00:00
Ian | 2024-06-13 00:00:00 | No
Ian | 2024-05-28 00:00:00 | No
[NAME] | 2024-03-01 00:00:00 | Yes | 2024-06-18 00:00:00
[NAME] | 2024-02-09 00:00:00 | No
Ian | 2024-05-17 00:00:00 | No
Ian | 2024-05-07 00:00:00 | Yes | 2024-05-25 00:00:00 |  |  | old fashioned |  | 365 version | 365 version no error check
[NAME]
Ian
S/be: |  |  |  |  |  |  |  |  |  | of course this row just as a sample
 |  |  |  |  | shall be 18 !
Spreadsheet: 136833d1326838316-vacation-accrual-formula-2012_vacation_tracker-test
Sheet: Accrual dates

Pay Days (accrual Day) | count | [NAME] | Accrual throughout the year for ASD in G2 (Hours) | Actual Hours theoretically taken | Theoretical Accrual Time (Hours) | Testing CALCULATIONS
2012-01-13 00:00:00 | 1 |  |  |  | 120 | Adjusted Service Date | 2004-03-16 00:00:00 |  |  | Vacation Days | ASD Datediff | Accrual Calculation | Notes
2012-01-27 00:00:00 | 1 |  |  |  | 120 | Pretend Date | 2012-03-17 00:00:00 |  |  | 15 Days | <1 Year |  | [NAME] Doesn't Change
2012-02-10 00:00:00 | 1 |  |  | 24 |  | Roll Over Time | 120 |  |  | 15 Days | <7 Year |  | [NAME] Doesn't Change
2012-02-24 00:00:00 | 1 |  |  |  |  | Hours Taken |  |  |  | 15 to 22 Days | 7 to 8 Years |  | Accrual Calc Changes
2012-03-09 00:00:00 | 1 |  |  | 4 |  |  |  |  |  | 22 Days | 8 - 13 Year |  | [NAME] Doesn't Change
2012-03-23 00:00:00 | 1 |  |  |  |  |  |  |  |  | 22 to 25 Days | 13 to 14 Years |  | Accrual Calc Changes
2012-04-06 00:00:00 | 1 |  |  |  |  | Accrual |  |  |  | 25 Days | 14+ Years |  | [NAME] Doesn't Change
2012-04-20 00:00:00 | 1 |  |  |  |  | Time
2012-05-04 00:00:00 | 1
2012-05-18 00:00:00 | 1 |  |  |  |  | Should be | 105.8461538461538
2012-06-01 00:00:00 | 1
2012-06-15 00:00:00 | 1 |  |  |  |  | [NAME]
2012-06-29 00:00:00 | 1 |  |  |  |  | <=7 Years |  |  | If you reach [NAME] You stop accrual time  ** Flaw in the formula, not sure how to fix!!***
2012-07-13 00:00:00 | 1 |  |  |  |  | 8 to 13 Years
2012-07-27 00:00:00 | 1 |  |  |  |  | 14+ Years
2012-08-10 00:00:00 | 1 |  |  |  | 176
2012-08-24 00:00:00 | 1 |  |  | 6 | 176
2012-09-07 00:00:00 | 1 |  |  |  | 176
2012-09-21 00:00:00 | 1 |  |  |  | 176
2012-10-05 00:00:00 | 1 |  |  | 40 |  |  |  |  |  |  | Accrual Amount
2012-10-19 00:00:00 | 1 |  |  |  |  |  |  |  |  |  | ASD Change < ASD Date
2012-11-02 00:00:00 | 1 |  |  |  |  |  |  |  |  |  | ASD Change > ASD Date
2012-11-16 00:00:00 | 1
2012-11-30 00:00:00 | 1
2012-12-14 00:00:00 | 1 |  |  |  | 176
2012-12-28 00:00:00 | 1 |  |  |  | 176
Spreadsheet: 886508d1736528924-sorting-data-from-a-dynamic-list-jeffcmusic-excel-help-tms-jeffcmusic-
Sheet: Route Stops

Route → |  | Route Number |  |  | 113
 |  | In Bound |  |  |  |  |  |  |  | Out Bound |  |  |  |  | Stops To Close
[NAME] |  | Stop Sq | Bus Stops # | Bus Stop Name | Main Road | Point Letter | [NAME] |  | Stop Squence | Bus Stops # | Bus Stop Name | Main Road | Point Letter |  | Enter Stop # | Closure Type
 |  | 1 |  |  |  |  |  |  | 1 |  |  |  |  |  | 25118 | Publicity Only
 |  | 2 |  |  |  |  |  |  | 2 |  |  |  |  |  | 15760 | Publicity Only
 |  | 3 |  |  |  |  |  |  | 3 |  |  |  |  |  | 29797 | Publicity & Hood
 |  | 4 |  |  |  |  |  |  | 4 |  |  |  |  |  | 15758 | Publicity Only
 |  | 5 |  |  |  |  |  |  | 5 |  |  |  |  |  | 16105 | Publicity & Hood
 |  | 6 |  |  |  |  |  |  | 6 |  |  |  |  |  | 14702 | Publicity Only
 |  | 7 |  |  |  |  |  |  | 7
 |  | 8 |  |  |  |  |  |  | 8
 |  | 9 |  |  |  |  |  |  | 9
 |  | 10 |  |  |  |  |  |  | 10
 |  | 11 |  |  |  |  |  |  | 11
 |  | 12 |  |  |  |  |  |  | 12
 |  | 13 |  |  |  |  |  |  | 13
 |  | 14 |  |  |  |  |  |  | 14
 |  | 15 |  |  |  |  |  |  | 15
 |  | 16 |  |  |  |  |  |  | 16
 |  | 17 |  |  |  |  |  |  | 17
 |  | 18 |  |  |  |  |  |  | 18
 |  | 19 |  |  |  |  |  |  | 19
 |  | 20 |  |  |  |  |  |  | 20
 |  | 21 |  |  |  |  |  |  | 21
 |  | 22 |  |  |  |  |  |  | 22
 |  | 23 |  |  |  |  |  |  | 23
 |  | 24 |  |  |  |  |  |  | 24
 |  | 25 |  |  |  |  |  |  | 25
 |  | 26 |  |  |  |  |  |  | 26
 |  | 27 |  |  |  |  |  |  | 27
 |  | 28 |  |  |  |  |  |  | 28
 |  | 29 |  |  |  |  |  |  | 29
 |  | 30 |  |  |  |  |  |  | 30
 |  | 31 |  |  |  |  |  |  | 31
 |  | 32 |  |  |  |  |  |  | 32
 |  | 33 |  |  |  |  |  |  | 33
 |  | 34 |  |  |  |  |  |  | 34
 |  | 35 |  |  |  |  |  |  | 35
 |  | 36 |  |  |  |  |  |  | 36
 |  | 37 |  |  |  |  |  |  | 37
 |  | 38 |  |  |  |  |  |  | 38
 |  | 39 |  |  |  |  |  |  | 39
 |  | 40 |  |  |  |  |  |  | 40
 |  | 41 |  |  |  |  |  |  | 41
 |  | 42 |  |  |  |  |  |  | 42
 |  | 43 |  |  |  |  |  |  | 43
 |  | 44 |  |  |  |  |  |  | 44
 |  | 45 |  |  |  |  |  |  | 45
 |  | 46 |  |  |  |  |  |  | 46
 |  | 47 |  |  |  |  |  |  | 47
 |  | 48 |  |  |  |  |  |  | 48
 |  | 49 |  |  |  |  |  |  | 49
 |  | 50 |  |  |  |  |  |  | 50
 |  | 51 |  |  |  |  |  |  | 51
 |  | 52 |  |  |  |  |  |  | 52
 |  | 53 |  |  |  |  |  |  | 53
 |  | 54 |  |  |  |  |  |  | 54
 |  | 55 |  |  |  |  |  |  | 55
 |  | 56 |  |  |  |  |  |  | 56
 |  | 57 |  |  |  |  |  |  | 57
 |  | 58 |  |  |  |  |  |  | 58
 |  | 59 |  |  |  |  |  |  | 59
 |  | 60 |  |  |  |  |  |  | 60
 |  | 61 |  |  |  |  |  |  | 61
 |  | 62 |  |  |  |  |  |  | 62
 |  | 63 |  |  |  |  |  |  | 63
 |  | 64 |  |  |  |  |  |  | 64
 |  | 65 |  |  |  |  |  |  | 65
 |  | 66 |  |  |  |  |  |  | 66
 |  | 67 |  |  |  |  |  |  | 67
 |  | 68 |  |  |  |  |  |  | 68
 |  | 69 |  |  |  |  |  |  | 69
 |  | 70 |  |  |  |  |  |  | 70
Spreadsheet: 878205d1725274978-separate-letter-from-number-housenumber-map3-4-
Sheet: Blad1

address |  | street | number | letter added to number
perenlaan test 9a |  |  | 9a
herken 47 |  | herken | 47
lkajsdf 8d |  | lkajsdf | 8d
jfjaja 99 zv |  | jfjaja | 99 zv
jkasldjfklsdaj 397b |  | jkasldjfklsdaj | 397b
Hello World 69 a |  | Hello World | 69 a
strasse grosse |  | strasse grosse
ThisStreet76 b |  | ThisStreet | 76 b
 |  |  | as you can see column D also contains a letter, I want the letters to appear in column E and only the number in column D.
Spreadsheet: 105082d1302547789-threshold-formula-nasdaq1007daily
Sheet: Stats

 |  | [NAME] |  |  |  |  |  | [NAME]
 |  | Min | 0 |  |  |  |  | Min
 |  | [NAME] |  |  |  |  |  | [NAME] | 0
 |  | Average |  |  |  |  |  | Average
 |  | Stdev |  |  |  |  |  | Stdev
 |  | Avg + 3σ |  |  |  |  |  | Avg + 3σ
 |  | [NAME] |  |  |  |  |  | [NAME]
 |  | Range | Fi | fi | ∑fi | μ + xσ |  | Range | Fi | fi | ∑fi | μ + xσ
 | 1 |  |  |  |  |  | 1
 |  |  | #REF! |  |  |  |  |  | #REF!
 |  |  | #REF! |  |  |  |  |  | #REF!
 |  |  | #REF! |  |  |  |  |  | #REF!
 |  |  | #REF! |  |  |  |  |  | #REF!
 |  |  | #REF! |  |  |  |  |  | #REF!
 |  |  | #REF! |  |  |  |  |  | #REF!
 |  |  | #REF! |  |  |  |  |  | #REF!
 |  |  | #REF! |  |  |  |  |  | #REF!
 |  |  | #REF! |  |  |  |  |  | #REF!
 |  |  | #REF! |  |  |  |  |  | #REF!
 |  |  | #REF! |  |  |  |  |  | #REF!
 |  |  | #REF! |  |  |  |  |  | #REF!
 |  |  | #REF! |  |  |  |  |  | #REF!
 |  |  | #REF! |  |  |  |  |  | #REF!
 |  |  | #REF! |  |  |  |  |  | #REF!
 |  |  | #REF! |  |  |  |  |  | #REF!
 |  |  | #REF! |  |  |  |  |  | #REF!
 |  |  | #REF! |  |  |  |  |  | #REF!
 |  |  | #REF! |  |  |  |  |  | #REF!
 |  | n= |  |  |  |  |  | n=
Spreadsheet: 31814d1227781918-automatically-update-chart-help
Sheet: Sheet1

Cost | P_1 | P_2 | P_3 | P_4 | P_5 | P_6
Team1 | 1 | 2 | 2 | 3 | 2 | 1
Team2 | 2 | 1 | 3 | 2 | 2 | 2
Team3 | 1 | 3 | 4 | 4 | 3 | 3
Spreadsheet: louise_kitchen__23066__0111MarginRequirements
Sheet: Template

FUTURES MARGIN REQUIREMENTS
2001-11-28 00:00:00
2001-11-27 00:00:00
 | US $$$ |  |  |  |  |  |  |  |  |  |  |  | CANADIAN $$$
Broker | TE | Credit Facility Covering TE | TE Less CreditCoverage | Net Option Value | Initial Margin | Line of Credit Covering Initial Margin (except EDF [NAME] see calc below) | Initial Margin Less Line of Credit Covering Initial Margin |  | Daily Facility Movement Inc/(Dec) Line |  | Wire Day Cash In/(Out) |  | OTE | Initial Margin
ABN-Amro Inc |  |  |  | 0
ADM INVESTOR |  |  |  | 0
BANK ONE |  |  |  | 0
CARR FUTURES (NG) |  |  |  | 0
CARR FUTURES INC. |  |  |  | 0
CREDIT SUISSE FIRST BOSTON |  |  |  | 0
EDF MAN
FIMAT |  |  |  | 0 |  |  |  | 1
HSBC - US$ |  |  |  | 0
HSBC - Canadian | 0 |  |  | 0
JP Morgan |  |  |  | 0
[NAME] |  |  |  | 0
PARIBAS |  |  |  | 0
PRUDENTIAL SI |  |  |  | 0
REFCO, INC |  |  |  | 0
R J O'BRIEN |  |  |  | 0
SAUL STONE & COMPANY |  |  |  | 0
SMITH BARNEY, INC |  |  |  | 0
SMITH BARNEY, INC  (Financial) |  |  |  | 0
TOTAL EXCLUDING MID-DAY CALLS
MID-DAY CALLS: (based solely on Market Movement)
EDF Mann | 0
TOTAL INCLUDING MID-DAY CALLS
 |  | Used Line
Credit Lines: | Line | OTE | Initial Margin | Total Line Used | Total Line Unused
Smith Barney | 50000000 | 0
1 Includes amounts withheld from payments due Enron.  Fimat's customer agreement states that excess margin including OTE due to Enron must first be used to pay down advances on the facility.
Spreadsheet: 877933d1724858123-excel-formula-to-count-users-based-on-dates-question
Sheet: Sheet1

 |  |  |  | 2024-06-01 00:00:00 |  | Count of how may was active in June 2024
Name | Dept | Active date | Inactive Date | active in this month?
Test1 | x | 2023-11-15 00:00:00 | 2024-06-15 00:00:00 | Active
Test2 | y | 2023-09-28 00:00:00 |  | Active
Test3 | z | 2024-05-11 00:00:00 |  | Active
Test4 | a | 2023-12-06 00:00:00 | 2024-08-15 00:00:00 | Active
Test5 | b | 2024-01-15 00:00:00 | 2024-05-03 00:00:00 | Not
Spreadsheet: 1239e261-92b5-4690-99e6-2f432ce5d389
Sheet: Sheet1

Date | Sport | Opponent | Time | Results
10/05/2013 | Rowing | Head of the Ohio (Pittsburgh, Pa.) | 12:00 AM | Results
10/26/2013 | Rowing | Head of the [NAME] (Philadelphia, Pa.) (Varsity Squad) | 12:00 AM | Results
11/02/2013 | Rowing | Head of the Occoquan (Fairfax, Va.) (Varsity & Novice Squads) | 12:00 AM | Results
11/08/2013 | Rowing | Duquesne (Morgantown, W.Va.) (Novice Squad) | 12:00 AM | All Day
11/17/2013 | Rowing | [NAME] (Earlysville, Va.) (Varsity Squad) | 12:00 AM | Results
03/15/2014 | Rowing | Oak Ridge Cardinal Invitational (Oak Ridge, Tenn.) | 07:30 AM | Results
03/16/2014 | Rowing | Oak Ridge Cardinal Invitational (Oak Ridge, Tenn.) | 07:30 AM | Results
[NAME] | Rowing | [NAME] (Scrimmage) | 11:00 AM | Recap
04/05/2014 | Rowing | at Indiana (Bloomington, Ind.) | 12:00 AM | Results
04/12/2014 | Rowing | Knecht Cup Regatta (West Windsor, N.J.) | 12:00 AM | Results
04/13/2014 | Rowing | Knecht Cup Regatta (West Windsor, N.J.) | 12:00 AM | Results
05/03/2014 | Rowing | Big 12 Championships (Oklahoma City, Okla.) | 12:00 AM | 5th/5
05/17/2014 | Rowing | Conference USA Championships (Oak Ridge, Tenn.) | 12:00 AM | 10th/11
Spreadsheet: 815994d1675299400-need-formula-that-matches-value-with-different-criteria-sample7
Sheet: Sheet1

 |  | Todays Date | 2023-02-01 00:00:00 | Answers |  | Todays Date | 2023-02-03 00:00:00 | Answers
 |  | Credit card 1 |  | 500 |  | Credit card 1 |  | 750
 |  | Credit card 2 | Insert formula here | 650 |  | Credit card 2 | Insert formula here | 1000
Name | Date | Balance
Credit card 1 | 2023-02-01 00:00:00 | 500
Credit card 2 | 2023-02-01 00:00:00 | 650
Credit card 1 | 2023-02-03 00:00:00 | 750
Credit card 2 | 2023-02-03 00:00:00 | 1000
Spreadsheet: 143582d1330466139-fundamental-date-calculation-error-excel-office-2010-sublease-calc
Sheet: Master

 |  |  | 2012-02-01 00:00:00 | 40999 | [NAME]
File Id | Expiration | [NAME] to [NAME] (Months) | [NAME] to ETD (Months) | Early Term Date | FY0 | FY1 | FY2 | FY3 | FY4 | FY5+ | Total
1 | 2014-12-31 00:00:00 |  |  | 2012-10-31 00:00:00 |  |  |  |  |  |  | 1000
2 | 2014-12-31 00:00:00 |  |  | 2013-10-31 00:00:00 |  |  |  |  |  |  | 2000
3 | 2014-12-31 00:00:00 |  |  | 2014-09-30 00:00:00 |  |  |  |  |  |  | 3000
4 | 2015-12-31 00:00:00 |  |  | 2015-12-31 00:00:00 |  |  |  |  |  |  | 4000
5 | 2015-12-31 00:00:00 |  |  | 2015-12-31 00:00:00 |  |  |  |  |  |  | 5000
6 | 2016-12-31 00:00:00 |  |  | 2014-11-30 00:00:00 |  |  |  |  |  |  | 6000
7 | 2016-12-31 00:00:00 |  |  | 2018-11-30 00:00:00 |  |  |  |  |  |  | 7000
8 | 2017-07-31 00:00:00 |  |  | 2017-07-31 00:00:00 |  |  |  |  |  |  | 8000
9 | 2018-01-31 00:00:00 |  |  | 2015-07-31 00:00:00 |  |  |  |  |  |  | 9000
10 | 2020-06-30 00:00:00 |  |  | 2016-08-30 00:00:00 |  |  |  |  |  |  | 10000
11 | 2020-06-30 00:00:00 |  |  | 2019-08-30 00:00:00 |  |  |  |  |  |  | 11000
 |  |  |  |  | 2012-01-01 00:00:00 | 2013-01-01 00:00:00 | 2014-01-01 00:00:00 | 2015-01-01 00:00:00 | 2016-01-01 00:00:00 | 2017-01-01 00:00:00
 |  |  |  |  | 2012-12-31 00:00:00 | 2013-12-31 00:00:00 | 2014-12-31 00:00:00 | 2015-12-31 00:00:00 | 2016-12-31 00:00:00 | 2017-12-31 00:00:00
1 | 10 | 11 | 12 | 13 | 23 | 24 | 25 | 26 | 27 | 28 | 29
Spreadsheet: 0647f4b6-7bcf-4050-856e-7c739d2e795b
Sheet: VAR-Auto

Rating Variable Support Exhibit |  |  |  |  | VAR-Auto
Insurance Company: | Insert Company Name
Program: | Insert Program Type
Effective Date: | MM/DD/YYYY
Rating Variable: | [NAME]
Category | Earned Premium or Earned Exposures | Support for Change | Current Factor | Proposed Factor | % Change
(Add/Delete rows as needed) |  | (Add columns as needed)
C 1
C 2
C 3
C 4
C 5
C 6
C 7
C 8
etc
Total
Insurer Notes:
Notes:
1.  [NAME] this exhibit for each Rating Variable (i.e. Base Rates, Territory, Driver Class, etc)
2.  List each Category affected by your proposed Rating Variable changes (i.e. Driver Class SM20, Driver Class SM21, Driver Class SM 22, etc)
2a.  If Category codes are company specific, provide the Category code definition
3.  [NAME] or [NAME] should be used as weights to calculate the Total % Change
3a.  Alternatively, the Total % Change could be calculated by re-rating your entire book, which should be acknowledged in the Insurer Notes
4.  Support for Change value uses loss or competitive data to support your Proposed Factor selections (i.e. Indicated Factor, Indicated Change, Countrywide Factor, etc.)
5. When generalized linear modeling is used, the company should provide an overview of how the GLM analysis was performed and include a Quantiles Test, sum of squared errors, mean squared error, average absolute error, and a comparison of predicted and actual frequencies and/or losses demonstrating that the proposed rating plan is a better predictor of losses than the current rating plan
5a. The quantiles should be defined based upon the product of all relativities assigned by the proposed rating plan (i.e. if quintiles are used, then quintile 1 contains the 20% of risks with the lowest overall relativity assigned by the proposed plan, and quintile 5 contains the 20% of risks with the highest overall relativity assigned by the proposed plan)
5b. Sufficient information and documentation explaining the data and calculations being used should be submitted
5c. At a minimum, the following values should be included: actual losses from the holdout data set (show Countrywide and South Carolina results; include comments regarding credibility if applicable), predicted losses from the current rating plan, and predicted losses from the proposed rating plan
5d. The errors for the proposed values should be lower than the errors for those currently in use
5e. For the Department to conclude that the proposed rating plan is acceptable, it is necessary to demonstrate that the proposed rating plan does not introduce a pattern of errors (including overcorrection at the endpoints) when comparing the proposed relativities to the actual relativities from the holdout data set
6.  [NAME] exhibit for each Program type being filed
Spreadsheet: 68679d1d-6391-4c9b-a111-ebd085c0ddbd
Sheet: 5

 | Jul 19 | Jul 26 | Aug 2 | Aug 9 | Aug 16
Total Interest Rate* | 84500 | 84500 | 84500 | 84500 | 84500
Cleared** | N/A*** | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Cross-Currency | 3500 | 3500 | 3500 | 3500 | 3500
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Credit | 105000 | 105000 | 105000 | 105000 | 105000
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Equity | 25000 | 25000 | 25000 | 25000 | 25000
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Other Commodity | 105000 | 105000 | 105000 | 105000 | 105000
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
TOTAL | 323000 | 323000 | 323000 | 323000 | 323000
Weekly total, estimated swap event volumes by asset class and cleared status (in number of events), all products, tenors, and participant types.
Estimates of weekly event volumes are derived from data published in the 2012 ISDA Operations Benchmarking Survey, which defines an "event" as a new trade, confirmable amendment, partial or full termination, increase, decrease, or novation.
*See Data Dictionary for asset class descriptions.
**See Explanatory Notes for cleared and uncleared descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 827759d1683022098-based-on-2-criteria-checks-create-sequence-numbering-sample1
Sheet: Sheet1

Product | [NAME] | Product Number (Target text) | [NAME] (not working well)
Apple | 1 | Apple-1-1 |  | < check if [NAME] and [NAME] are same, then give it a sequence number (Product+Req Nr+Sequence), if its unique then start from 1
Apple | 1 | Apple-1-2
Apple | 1 | Apple-1-3
Apple | 2 | Apple-2-1
Apple | 2 | Apple-2-2
Melon | 1 | Melon-1-1
Melon | 2 | Melon-2-1
Melon | 3 | [NAME]
[NAME] | 1 | Banana-1-1
[NAME] | 1 | Banana-1-2
Apple | 3 | Apple-3-1