tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 845556d1697026062-automate-extracting-data-creating-individual-confirmations-and-emailing-candy-
Sheet: Sheet1

Student Number | Employee name | Room Number | Election data |  |  |  | Timestamp | Information Output
123456 | Candy Queen | 445576 | Question id | Question text | Parent question id | User responses | April 23, 2022, 3:44:21 PM | 34% of my candy in a single day 33% a bag of candy given to me 1 day after receiving my gold star 33% a bag of candy given to me 2 days after receiving my gold star
 |  |  | 0 | I want to receive 100% of my candy in a single day. |  | False
 |  |  | Question id | Question text | Parent question id | User responses
 |  |  | 1 | % to be given as: |  | 34
 |  |  | Question id | Question text | Parent question id | User responses
 |  |  | 2 | % to be given as: |  | 33
 |  |  | Question id | Question text | Parent question id | User responses
 |  |  | 3 | % to be given as: |  | 33
 |  |  | Question id | Question text | Parent question id | User responses
 |  |  | 10 | A candy bag with no delay | 1
 |  |  | Question id | Question text | Parent question id | User responses
 |  |  | 20 | A bag of candy given to me [input data] day, after receiving my gold star OR | 2 | 1
 |  |  | Question id | Question text | Parent question id | User responses
 |  |  | 30 | A bag of candy given to me [input data] day, after receiving my gold star OR | 3 | 2
654321 | [NAME] | 445576 | Question id | Question text | Parent question id | User responses | April 23, 2022, 3:44:21 PM | 20% a bag of candy given to me 2 days after receiving my gold star 80% a bag of candy given to me immediately after receiving my gold star
 |  |  | 0 | I want to receive 100% of my candy in a single day. |  | False
 |  |  | Question id | Question text | Parent question id | User responses
 |  |  | 1 | % to be given as: |  | 20
 |  |  | Question id | Question text | Parent question id | User responses
 |  |  | 2 | % to be given as: |  | 80
 |  |  | Question id | Question text | Parent question id | User responses
 |  |  | 10 | % to be given as: | 1 | 2
 |  |  | Question id | Question text | Parent question id | User responses
 |  |  | 20 | A candy bag with no delay | 2
 |  | When reviewing the file, the following Question IDs go together
 |  | This question answers the percentage | This question answers the input, or how many days she will receive candy after her gold star
 |  | Question ID 1 | Question ID 10
 |  | Question ID 2 | Question ID 20
 |  | Question ID 3 | Question ID 30
Spreadsheet: 823129d1679727338-how-to-calculate-only-visible-cells-example
Sheet: Sheet2

 | ID | Debt Date | Due Date | Days between Due | Due Days Late | Vendor | Cost | Paid Date
 | 1140 | 2022-11-22 00:00:00 | 2023-02-20 00:00:00 |  | 33 | sm | 3361
 | 1143 | 2022-11-22 00:00:00 | 2023-02-20 00:00:00 |  | 33 | a | 845
 | 1144 | 2022-11-23 00:00:00 | 2023-02-21 00:00:00 |  | 32 | c | 1240
 | 1202 | 2022-12-13 00:00:00 | 2022-12-27 00:00:00 |  |  | s | 1170 | 2023-01-14 00:00:00
 | 1203 | 2022-12-13 00:00:00 | 2022-12-27 00:00:00 |  |  | s | 600 | 2023-01-14 00:00:00
 | 1154 | 2022-11-26 00:00:00 | 2023-02-24 00:00:00 |  | 29 | sm | 815
 | 1308 | 2023-01-25 00:00:00 | 2023-02-24 00:00:00 |  | 29 | SBP | 291.06
 | 1206 | 2022-12-15 00:00:00 | 2023-01-14 00:00:00 |  |  | c | 7444.366 | 2023-01-17 00:00:00
 | 1242 | 2022-12-28 00:00:00 | 2023-02-26 00:00:00 |  | 27 | cb | 1720
 | 1243 | 2022-12-28 00:00:00 | 2023-02-26 00:00:00 |  | 27 | cb | 1287.5
 | 1244 | 2022-12-28 00:00:00 | 2023-02-26 00:00:00 |  | 27 | in | 2775
 | 1153 | 2022-11-29 00:00:00 | 2023-02-27 00:00:00 |  | 26 | sm | 2815
 | 1155 | 2022-11-30 00:00:00 | 2023-02-28 00:00:00 |  | 25 | vi | 1915
 | 1160 | 2022-12-02 00:00:00 | 2023-03-02 00:00:00 |  | 23 | bt | 149.85
 |  | The target is to know how many days between due
 | 1 | Column I (Paid Date) > Filter (small triangle icon) > UNcheck 2023 |  |  |  | current problem is
 | 2 | 3 rows will be hidden |  |  |  | existing formula calculate exact 1 row before,
 | 3 | Cell E8 (black frame) should be 3 |  |  |  | eventhough that row already hidden because filtered out
 |  | because 32 - 29 = 3
 | 4 | Cell E11 (black frame) should be 2
 |  | because 29-27 = 2
Spreadsheet: 99422d1298043017-copy-and-paste-to-another-tab-mainstocklist
Sheet: Order Sheet 

The above is based on bentlybob's suggestion but ideally I would like the data presented like below: |  |  |  |  |  |  | Group | 0
Spreadsheet: phillip_m_love__30156__SitheFRED
Sheet: Summary

Financial Liquidation Variance Summary
PRODUCTION MONTH:  8/00
DESK: Sithe
 |  |  |  |  | To be updated by Economic & Gas Acctng:
 |  |  |  |  |  | Remaining
 | per OA reports |  | per [NAME] | var | Resolved Amount | To Be Resolved | expl
NGP&L LIQUIDATIONS | -188187
Less (refer to [NAME]):
Discrepancies between Actuals & Flash | 0 |  |  |  | 0
Per P. Love this is  a desk adj; to be accounted for in 8/00 prod |  |  |  |  | 0
[NAME] | 0 |  |  |  | 0
GL Adjustments |  |  |  |  | 0
In Actuals, not [NAME] (unexplained) | 0 |  |  |  | 0
Not TAGG related:Reclass inv profits to storage reconciliation
Restated NGP&L
GL LIQUIDATIONS
Less (refer to [NAME]):
In FL not GL, Acct to look at | 74622.7098 |  |  |  | 0
In Ontario GL, Sithe FL, change mapping | -39524.721 |  |  |  | 0
Discrepancies between Actuals & Flash
[NAME]
GL Adjustments
In [NAME], not Actuals (unexplained)
Not TAGG related:Unknown entry in OA report
Restated Actuals
[NAME]
unexplained
Spreadsheet: 128263d1320878001-sumproduct-w-one-criteria-coming-from-a-list-sumproduct-using-list
Sheet: Data 

Cost Code | Name | Hrs | $
20188815 | [NAME] | 28 | 2156
20288815 | [NAME] | 7 | 567
20388815 | [NAME] | 11 | 715
20388815 | [NAME] | 28 | 1932
20488815 | [NAME] | 1 | 87
20488823 | [NAME] | 18 | 900
20188823 | [NAME] | 23 | 1656
20888823 | [NAME] | 21 | 1953
20288819 | Amber Hicks | 27 | 2484
20296932 | [NAME] | 23 | 1495
20488815 | [NAME] | 1 | 65
20388815 | [NAME] | 23 | 1771
20388815 | [NAME] | 2 | 174
20578224 | [NAME] | 12 | 972
20188823 | [NAME] | 13 | 897
20296932 | [NAME] | 14 | 910
20578224 | [NAME] | 11 | 715
20188815 | [NAME] | 13 | 1053
20488815 | [NAME] | 8 | 616
20288819 | [NAME] | 16 | 1392
20288815 | [NAME] | 7 | 539
20296932 | [NAME] | 7 | 455
20188823 | [NAME] | 13 | 897
20288815 | [NAME] | 25 | 1625
20578224 | [NAME] | 10 | 810
20388815 | [NAME] | 1 | 81
20296932 | [NAME] | 28 | 2156
20488815 | [NAME] | 20 | 1740
20288815 | [NAME] | 11 | 715
20288819 | [NAME] | 16 | 1104
20288815 | [NAME] | 24 | 1560
20578224 | [NAME] | 28 | 2156
20188823 | [NAME] | 16 | 1296
20188815 | [NAME] | 21 | 1449
20388815 | [NAME] | 16 | 1392
20296932 | [NAME] | 28 | 1820
20578224 | [NAME] | 14 | 1134
20188823 | [NAME] | 16 | 1424
20956532 | [NAME] | 5 | 335
20188815 | [NAME] | 29 | 2320
20956532 | [NAME] | 18 | 1080
20388815 | [NAME] | 29 | 2755
20288819 | Amber Hicks | 17 | 1326
20288815 | [NAME] | 16 | 1280
20296932 | Amber Hicks | 4 | 264
20956532 | Amber Hicks | 5 | 250
20956532 | [NAME] | 20 | 1520
20956532 | [NAME] | 15 | 1290
20388815 | [NAME] | 1 | 100
20188815 | Amber Hicks | 24 | 1200
20956532 | [NAME] | 20 | 1260
20296932 | Amber Hicks | 12 | 1080
20288819 | [NAME] | 3 | 177
20956532 | [NAME] | 4 | 400
20296932 | [NAME] | 13 | 1027
20388815 | [NAME] | 19 | 1235
20188815 | [NAME] | 12 | 696
Spreadsheet: 770679d1646223536-dropdown-see-text-from-column-a-but-return-value-from-column-b-sample
Sheet: Sheet1

Day | Start date | Finish date | Start time | Finish time | Break mins | Work hours | Rate | Total | Manager | Notes
 | 2022-02-17 00:00:00 | 2022-02-17 00:00:00 | 1300 | 2100 | 30 |  |  |  | Jeanette | Need maximum space here for notes
 | 2022-02-18 00:00:00 |  | 700 | 1530 | 30 |  |  |  | Jeanette
 | 2022-02-19 00:00:00
 | 2022-02-20 00:00:00 |  | 730 | 1600 | 30 |  |  |  | [NAME]
 | 2022-02-21 00:00:00 |  | 1430 | 2100 | 30 |  |  |  | Jeanette
 | 2022-02-22 00:00:00
 | 2022-02-23 00:00:00 |  | 630 | 930 |  |  |  |  | Jeanette
 | 2022-02-24 00:00:00 |  | 630 | 1330 |  |  |  |  | Kayla
 | 2022-02-25 00:00:00 |  | 1530 | 2100 |  |  |  |  | Jeanette
 | 2022-02-26 00:00:00
 | 2022-02-27 00:00:00 |  | 730 | 1600 | 30 |  |  |  | [NAME]
 | 2022-02-28 00:00:00 |  | 1430 | 2100 | 30 |  |  |  | Jeanette
 | 2022-03-01 00:00:00 |  | 900 | 1300 |  |  |  |  | [NAME]
 | 2022-03-01 00:00:00 |  | 1430 | 2100 | 30 |  |  |  | Jeanette
 | 2022-03-02 00:00:00
Spreadsheet: 117383d1312752055-filtering-lookup-array-question-filtered
Sheet: 44002

CONTROL CABLE
CORE CARD
Location
Cable Number |  | 44002
Number of cores |  | 4
Spare cores |  | 0
Core size |  | 4mm2
Cable Type |  | Cu, PVC, SWA
Drawing References
Cable Service |  | CT Cable, 220kV CT,2S1, [NAME] M3311A
Panel Number | T44 PP |  | Panel Number |  | [NAME]
Cable Insulation resistance >100MΩ
Core Number | Ferrule Number |  | T44 PP | INITIAL | [NAME] | INITIAL
1 | BH200 |  | TBY1:1 |  | 132
2 | BH220 |  | TBY1:2 |  | 133
3 | BH240 |  | TBY1:3 |  | 134
4 | BH210 |  | TBY1:4 |  | 135
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
Termination Notes | 2011-08-01 00:00:00 | Label numbers on drawing says BKxxx (incorrect). |  |  |  | DJC
 |  | Links to be installed between 135,136,137 in ODJB
Edition Notes | 2011-08-01 00:00:00 | Was cable 4502 |  |  |  | DJC
Spreadsheet: 107744d1304901456-excel-2007-should-i-use-a-if-statement-prices-customers-
Sheet: Services by Dates

Service Chart by Dates
Service # | Name | Computer | Date Received | Date Preformed | Services Offered | Hours Taken | [NAME] | Parts | Discount | Total | Total After Install | Commitment | Received Amount
A100 | Hammerly, Joleen | Acer | 2011-05-02 00:00:00 | 2011-05-02 00:00:00 | Virus Removal | 1 | 40 | 0 | 20 | 20 | No Intall | 2011-05-13 00:00:00 | 0
[NAME] | Sandine, [NAME] | [NAME] 7741Z-5731 | 2011-04-27 00:00:00 |  | Replace Screen | 0 | 40 | 140 | 0 | 180 |  |  | 0
A102 | [NAME], [NAME] | Toshiba Satellite M45-S169 | 2011-04-27 00:00:00 |  | Replace Screen | 0 | 40 | 125 | 0 | 165 |  |  | 0
A103 | Burton, [NAME] | Dell Inspiron 531S | 2011-04-27 00:00:00 |  | Virus Removal/Clean Ups/Memory | 1 | 40 | 30 | 10 | 60 |  |  | 0
A104 | VanHouten, [NAME] | HP Pavillion dv6-1359wm | 2011-04-27 00:00:00 |  | Replace Screen | 0 | 25 | 125 | 0 | 165 |  |  | 0
A105
A106
A107
A108
A109
A110
A111
A112
A113
A114
A115
A116
A117
Spreadsheet: 125193d1318929917-random-assigning-of-specified-values-count-must-be-equal-random
Sheet: Sheet1

 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
Spreadsheet: 546861d1510241302-mortgage-paydown-projection-table-rental-valuation-breakdown-tweaked-for-app
Sheet: Projection

Mock Projection
Purchase Price
Deposit
Loan Amount
Interest Rate
Original Rent
Value Appreciation Rate |  | 0.05
Rent Appreciation Rate |  | 0.05
Year | Start of Year Market Value | Annual Price Appreciation | Year End Appreciated Market Value | Annual Principal Debt Paydown | Year End Accumulated Equity | Total Annual Return | Return on Investment | Return on Equity |  | Rent this year | Year End Loan Remaining
1 | 203000
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Spreadsheet: 68843d1269379178-consolidate-master
Sheet: Master

 | Asset | Location |  | Description | Classification | Serial Number | Site | Priority | MFG | Serial# | Model# | Size/Type | Decommissioned Y/N
I&E | 3026 | 14FV100A | 14 | CONTVAL: BUTANE LOOP 14 | CONTVAL |  | PASADENA | 1
Spreadsheet: 005b6801-8580-4d96-b866-5fd00c9c0c81
Sheet: 12d

Product | 0-3** | 3-6 | 6-12 | 12-24 | 24-60 | 60-120 | 120+ | TOTAL
Basis*
FRA
IRS- [NAME]
OIS
VNS
Zero Coupon
TOTAL | N/A*** | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Estimated swap dollar volumes, week ending November 9, by product type and tenor (value of all trades in millions of USD), cleared swaps only, all participant types and tenors. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
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 Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for tenor bucket 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: 1ef50df9-fd95-4868-9812-e00d22eb4d07
Sheet: 3

 | November 8 | November 15 | November 22 | November 29 | December 6
Total Interest Rate* | 17829 | 12193 | 16121 | 11858 | 19841
Cleared** | 12964 | 8282 | 11354 | 10325 | 14933
Uncleared | 4865 | 3911 | 4767 | 1533 | 4908
Total Cross-Currency | 861 | 646 | 817 | 223 | 639
Cleared | 0 | 0 | 0 | 0 | 0
Uncleared | 861 | 646 | 817 | 223 | 639
Total Credit | 8113 | 7494 | 13918 | 4729 | 8103
Cleared | 4793 | 4300 | 6302 | 2918 | 5232
Uncleared | 3320 | 3194 | 7616 | 1811 | 2871
Total FX | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Equity | N/A | N/A | N/A | N/A | N/A
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 | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
TOTAL | 26803 | 20333 | 30856 | 16810 | 28583
Weekly total, swap ticket volumes by asset class and cleared status (number of new trades), all products, tenors, and participant types. For cleared swaps, this table reflects the creation of only one of the two swaps that results from the clearing process. All price-forming trade events, including new trades, terminations, amendments, and novations, are included in ticket volumes.
*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: 105320d1302713811-how-to-get-a-count-of-timestamp-on-1-date-book1_making
Sheet: Sheet1

TSTAMP |  | Select from [NAME]-down |  |  | Unique dates
2011-01-04 14:47:00 |  | 2011-07-04 00:00:00 | 5 |  | 2011-01-04 00:00:00
2011-01-04 15:14:00 |  |  |  |  | 2011-04-04 00:00:00
2011-01-04 15:15:00 |  | 2007 and above COUNTIFS | 5 |  | 2011-07-04 00:00:00
2011-01-04 15:16:00 |  |  |  |  | 2011-08-04 00:00:00
2011-01-04 15:17:00
2011-01-04 15:18:00
2011-01-04 15:18:00
2011-01-04 15:37:00
2011-04-04 13:32:00
2011-04-04 09:31:00
2011-04-04 09:30:00
2011-04-04 09:33:00
2011-04-04 13:32:00
2011-04-04 13:35:00
2011-07-04 09:23:00
2011-07-04 09:26:00
2011-07-04 09:27:00
2011-07-04 09:22:00
2011-07-04 09:31:00
2011-08-04 13:42:00
2011-08-04 11:01:00
Spreadsheet: 111934d1308163158-merging-two-worksheets-and-setting-a-migration-date-merge-excel-worksheets2
Sheet: Sports Players

Name | Testing | col-c | col-d | col-e | col-f | col-g | col-h | col-i | col-j | col-k | col-l | Migration Date
[NAME] | a | a | a | a | a | a | a | a | a | a | a
[NAME] | b | b | b | b | b | b | b | b | b | b | b
[NAME] | c | c | c | c | c | c | c | c | c | c | c
[NAME] | d | d | d | d | d | d | d | d | d | d | d
[NAME] | e | e | e | e | e | e | e | e | e | e | e
[NAME] | f | f | f | f | f | f | f | f | f | f | f
[NAME] | g | g | g | g | g | g | g | g | g | g | g | 2011-06-06 00:00:00
[NAME] | h | h | h | h | h | h | h | h | h | h | h
[NAME] | i | i | i | i | i | i | i | i | i | i | i
[NAME] | j | j | j | j | j | j | j | j | j | j | j
[NAME] | k | k | k | k | k | k | k | k | k | k | k
[NAME] | l | l | l | l | l | l | l | l | l | l | l | 2011-06-10 00:00:00
Dirk Notitzki | m | m | m | m | m | m | m | m | m | m | m | 2011-06-13 00:00:00
[NAME] | n | n | n | n | n | n | n | n | n | n | n
Jean-Sebastien Giguere | o | o | o | o | o | o | o | o | o | o | o | 2011-06-14 00:00:00
[NAME] | p | p | p | p | p | p | p | p | p | p | p | 2011-06-14 00:00:00
[NAME] | q | q | q | q | q | q | q | q | q | q | q
[NAME] | r | r | r | r | r | r | r | r | r | r | r
Spreadsheet: 109edb07-75d7-42b0-8414-aef92041ad9e
Sheet: FACULTY INFORMATION FORM

Please use capital letters & no punctuation | EXAMPLE | class 1 info | class 2 info | class 3 info | class 4 info | class 5 info | class 6 info
Last Name | LOGAN
First Name | SARAH
MI | M
Printed Course Prefix (e.g. ACC, BCIS, ECO,  BUSI, FIN) and Number | PSY3303
Printed Date/Time (e.g. MW 08:00 AM, TR 12:30 PM or MWF 18:00 PM) | TR 18:00 PM
Bubbled in Meeting Days (MTWRFSN) NO [NAME] or Spaces | TR
In the Classroom Survey = Face  OR  Online Survey = Online | Face
Eight Week Course = Y (yes) or N (no).    If YES… 1 for first eight weeks or 2 for second eight weeks | Y-2
For On-line courses ONLY - Print course title. In addition, please provide a class roster with [NAME] "username@angelo .edu" with your FIF.  Dropped students can be withdrawn later. | Learning  and Cognition
Objectives:  (Scale - M = Minor or No Importance,  I = Important,                              E = Essential) | M, I, E | M, I, E | M, I, E | M, I, E | M, I, E | M, I, E | M, I, E
1.  Gaining factual knowledge (terminology, classifications, methods,       trends) | E
2.  Learning fundamental principles, generalizations, or theories | E
3.  Learning to apply course material (to improve thinking, problem       solving,  and decisions) | E
4.  Developing specific skills, competencies, and points of view needed       by professionals in the field most closely related to this course | I
5.  Acquiring skills in working with others as a member of a team | I
6.  Developing creative capacities (writing, inventing, designing,       performing in art, music, drama, etc.) | M
7.  Gaining a broader understanding and appreciation of       intellectual/cultural activity (music, science, literature, etc.) | M
8.  Developing skill in expressing oneself orally or in writing | M
9.  Learning how to find and use resources for answering questions or       solving problems | M
10.  Developing a clearer understanding of, and commitment to, personal         values | M
11.  Learning to analyze and critically evaluate ideas, arguments,         and points of view | M
12.  Acquiring an interest in learning more by asking questions and         seeking answers | M
[NAME] (e.g. ACC, BCIS, ECO,  BUSI, FIN) | PSY
Discipline codes:  ACC = 5203,  BCIS = 5212,  ECO = 4506,  FIN = 5208,   FIN w/ FIN Plan or REAL = 5215       LAW = 2200              (4 digits) | 4200
[NAME] (e.g. 800, 1230, or 1800) | 800
Bubbled Course Number                                                 (4 digits) | 3303
Enrollment | 23
Local Code for ECO2300, 2301, 2302 = 0800 or  Honors = 0801 Local Code for BCIS1305 = 0200 or  Honors = 0201              (4 digits)
Long (L) or Short (S) Forms | L
Number of Additional Questions to be answered on the Survey  ([NAME]. number of Additional questions that can be asked for Long form = 19 & Short form = 10) | 12
Is this class [NAME]?   Y or N | N
Spreadsheet: 811052d1672247112-looking-for-a-formula-to-return-current-month-miles-last-month-miles-all-time-high-and-low-book2
Sheet: Sheet1

 | Month | [NAME]
 | Jan | 2412 |  | Current Date
 | Feb | 3209
 | Mar | 2781
 | Apr | 3201 |  | Current Month | [NAME] Here | 2571
 | May | 3109 |  | Last Month | [NAME] Here | 2984
 | Jun | 3091
 | Jul | 3312 |  | All Time High | [NAME] Here | 3512 | Aug
 | Aug | 3512 |  | All Time Low | [NAME] Here | 2412 | Jan
 | Sep | 3289
 | Oct | 3364
 | Nov | 2984
 | Dec | 2571
Spreadsheet: 374bbd9c-77e0-433b-b0ae-2a8f9a7c44e1
Sheet: 15b

Product1 | HY3 | IG | Other | TOTAL
Index Tranche | - | - | - | -
Index | 4358 | 18743 | 4935 | 28036
Asia | . | . | 29 | 29
Europe | . | . | 4729 | 4729
North America | 4358 | 18743 | - | 23101
Other | . | - | 177 | 177
OTHER* | - | - | 10038 | 10038
TOTAL | 4358 | 18743 | 14973 | 38074
*OTHER variable includes exotic credit products, swaptions, and total return swaps.
Spreadsheet: 586052d1534176978-find-a-reference-in-column-based-on-topfive-value-top-five-list-w-year
Sheet: Blad1

 |  | Startyear | stopyear |  |  | TOP FIVE
ALFA | 23 | 2015 | 2020 |  |  |  |  | start year | stopyear
BRAVO | 45 | 2015 | 2019 |  |  | NAME top 1 | Value qty
CERK | 76 | 2016 | 2019 |  |  | [NAME] | Value qty
DELTA | 13 | 2018 | 2021 |  |  | NAME top 3 | Value qty
HELLO | 87 | 2019 | 2022
Spreadsheet: 820540d1678155211-help-with-dependent-drop-down-lists-draft-work-book-risk-category
Sheet: ListCMC

Critical Risks | Top Event | Top Event Array Spilled Without Duplicates | Consequence | Mitigation | Uncontrolled Risk | Non Duplic URR | Controlled Risk | Non Duplic CRR | Mitigation | Control 2 | Control 3 | Control 4 | Control 5 | Control 6 | Control 7 | Control 8 | Control 9 | Control 10 | Control 11 | Control 12 |  |  |  |  |  | Residual Risk Rating |  | Risk Control Effectiveness
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Low |  | Totally ineffective
Asset Failure | Building Light Fittings - Overheating | Elevator - Power Failure causing Elevator to stop |  | Schindler Tech Response |  |  |  |  | Elevator Phones | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | Medium |  | Largely ineffective
Breach of Security | Building Light Fittings - Overheating | Escalator - Steps shatter leaving a hole |  | 0 |  |  |  |  | ICR Procedures | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | High |  | Partially effective
Chronic & Acute Impact on Health | Building Light Fittings - Overheating |  |  | 0 |  |  |  |  | Other emergency responses including [NAME] and FENZ | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | Critical |  | Substantially effective
High Risk Work | Building Light Fittings - Overheating |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fully effective
Uncontrolled Release of Energy | Building Light Fittings - Overheating |  |  | 0
Vehicles | Building Light Fittings - Overheating |  |  | 0
 | Building Light Fittings - Overheating |  |  | 0
 | Building Light Fittings - Overheating |  |  | 0
 | Building Light Fittings - Overheating |  |  | 0
 | Building Light Fittings - Overheating |  |  | 0
 | Building Light Fittings - Overheating |  |  | 0
 | Building Light Fittings - Overheating
 | Building Light Fittings - Overheating
 | Building Light Fittings - Overheating
 | Elevator - Power Failure causing Elevator to stop
 | Elevator - Power Failure causing Elevator to stop
 | Elevator - Power Failure causing Elevator to stop
 | Elevator - Power Failure causing Elevator to stop
 | Escalator - Steps shatter leaving a hole
 | Escalator - Steps shatter leaving a hole
 | Escalator - Steps shatter leaving a hole
 | Escalator - Steps shatter leaving a hole
 | Escalator - Steps shatter leaving a hole
 | Escalator - Steps shatter leaving a hole
 | Escalator - Steps shatter leaving a hole