tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 05f80a87-1d8f-4476-bc2c-2abf5e8ef7f6
Sheet: Lick&Morrison

 |  |  | 2014 Lick & Morrison F.E.  Delivery Calendar
 | January |  |  |  |  |  |  |  | February |  |  |  |  |  |  |  | March
 | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S
 |  |  |  | 1 | 2 | 3 | 4 |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | 1
 | 5 | 6 | 7 | 8 | 9 | 10 | 11 |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 |  | 2 | 3 | 4 | 5 | 6 | 7 | 8
 | 12 | 13 | 14 | 15 | 16 | 17 | 18 |  | 9 | 10 | 11 | 12 | 13 | 14 | 15 |  | 9 | 10 | 11 | 12 | 13 | 14 | 15
 | 19 | 20 | 21 | 22 | 23 | 24 | 25 |  | 16 | 17 | 18 | 19 | 20 | 21 | 22 |  | 16 | 17 | 18 | 19 | 20 | 21 | 22
 | 26 | 27 | 28 | 29 | 30 | 31 |  |  | 23 | 24 | 25 | 26 | 27 | 28 |  |  | 23 | 24 | 25 | 26 | 27 | 28 | 29
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30 | 31
 | April |  |  |  |  |  |  |  | May |  |  |  |  |  |  |  | June
 | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S
 |  |  | 1 | 2 | 3 | 4 | 5 |  |  |  |  |  | 1 | 2 | 3 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7
 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |  | 4 | 5 | 6 | 7 | 8 | 9 | 10 |  | 8 | 9 | 10 | 11 | 12 | 13 | 14
 | 13 | 14 | 15 | 16 | 17 | 18 | 19 |  | 11 | 12 | 13 | 14 | 15 | 16 | 17 |  | 15 | 16 | 17 | 18 | 19 | 20 | 21
 | 20 | 21 | 22 | 23 | 24 | 25 | 26 |  | 18 | 19 | 20 | 21 | 22 | 23 | 24 |  | 22 | 23 | 24 | 25 | 26 | 27 | 28
 | 27 | 28 | 29 | 30 |  |  |  |  | 25 | 26 | 27 | 28 | 29 | 30 | 31 |  | 29 | 30
 | July |  |  |  |  |  |  |  | August |  |  |  |  |  |  |  | September
 | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S
 |  |  | 1 | 2 | 3 | 4 | 5 |  |  |  |  |  |  | 1 | 2 |  |  | 1 | 2 | 3 | 4 | 5 | 6
 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |  | 3 | 4 | 5 | 6 | 7 | 8 | 9 |  | 7 | 8 | 9 | 10 | 11 | 12 | 13
 | 13 | 14 | 15 | 16 | 17 | 18 | 19 |  | 10 | 11 | 12 | 13 | 14 | 15 | 16 |  | 14 | 15 | 16 | 17 | 18 | 19 | 20
 | 20 | 21 | 22 | 23 | 24 | 25 | 26 |  | 17 | 18 | 19 | 20 | 21 | 22 | 23 |  | 21 | 22 | 23 | 24 | 25 | 26 | 27
 | 27 | 28 | 29 | 30 | 31 |  |  |  | 24 | 25 | 26 | 27 | 28 | 29 | 30 |  | 28 | 29 | 30
 |  |  |  |  |  |  |  |  | 31
 | October |  |  |  |  |  |  |  | November |  |  |  |  |  |  |  | December
 | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S
 |  |  |  | 1 | 2 | 3 | 4 |  |  |  |  |  |  |  | 1 |  |  | 1 | 2 | 3 | 4 | 5 | 6
 | 5 | 6 | 7 | 8 | 9 | 10 | 11 |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 |  | 7 | 8 | 9 | 10 | 11 | 12 | 13
 | 12 | 13 | 14 | 15 | 16 | 17 | 18 |  | 9 | 10 | 11 | 12 | 13 | 14 | 15 |  | 14 | 15 | 16 | 17 | 18 | 19 | 20
 | 19 | 20 | 21 | 22 | 23 | 24 | 25 |  | 16 | 17 | 18 | 19 | 20 | 21 | 22 |  | 21 | 22 | 23 | 24 | 25 | 26 | 27
 | 26 | 27 | 28 | 29 | 30 | 31 |  |  | 23 | 24 | 25 | 26 | 27 | 28 | 29 |  | 28 | 29 | 30 | 31
 |  |  |  |  |  |  |  |  | 30
 |  | Every Friday.  [NAME] is subject to change.  Call CPFB with questions [PHONE]. Thank you.
 |  | Holidays, Food Bank is Closed |  |  |  |  |  |  |  | Delivery dates to your area
Spreadsheet: sally_beck__35348__Headcount by BU
Sheet: Sheet1

ENRON NETWORKS - ENERGY OPERATIONS
2002 PLAN vs 2001 FORECAST HEADCOUNT
 |  | EA |  |  | EGM |  |  | EIM |  |  | EES |  |  | EBS |  |  | Other |  |  | Total
Function |  | 2001 Forecast | 2002 Plan |  | 2001 Forecast | 2002 Plan |  | 2001 Forecast | 2002 Plan |  | 2001 Forecast | 2002 Plan |  | 2001 Forecast | 2002 Plan |  | 2001 Forecast | 2002 Plan |  | 2001 Forecast | 2002 Plan
Deal Capture / Documentation |  | 40 |  |  |  |  |  | 2 |  |  | 25 | 32 |  | 0 | 0
Risk Management |  | 87 |  |  |  |  |  |  |  |  | 33 | 34 |  | 0 | 0
Logistics |  | 74 |  |  |  |  |  | 2 | 3 |  | 29 | 29 |  | 0 | 0
Volume Management |  |  |  |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
Settlements |  | 71 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
Trade Accounting |  |  |  |  |  |  |  | 2 |  |  | 0 | 0 |  | 0 | 0
Other |  |  |  |  |  |  |  |  |  |  |  |  |  | 37 | 36
Transaction Structuring |  | 0 | 0 |  | 10 | 10 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
Technology |  | 0 | 0 |  | 2 | 2 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
Special Projects |  | 0 | 0 |  | 0 | 0 |  | 6 | 17 |  | 0 | 0 |  | 0 | 0
Management |  |  | 5 |  |  |  |  |  |  |  | 2 |  |  | 0 | 0 |  | 2 | 8
Subtotal Direct Headcount
Global
Global Counterparty/OPD/Rates |  | 21 | 20 |  | 3 | 8 |  | 1 | 2 |  | 17 | 17 |  | 0.5 | 2 |  | 2.5 | 1
Global Contracts/Records Mgmt |  | 16 | 17 |  | 0.5 | 3 |  | 0.5 | 4 |  | 22 | 15 |  |  |  |  | 0.5 | 2
DPR/Risk Policy/Global Reporting |  | 7 | 7 |  | 5 | 4 |  | 1 | 2 |  | 3 | 4 |  | 0.5 | 2 |  | 4.5 | 7
Total Headcount
Spreadsheet: 850283d1700654493-each-day-how-many-time-repeated-repeated-days-dynamic-range
Sheet: Sheet1

Time |  | Result
2022-01-06 02:00:00
2022-01-06 10:00:00
2022-01-06 12:00:00
2022-01-06 13:00:00
2022-01-06 14:00:00
2022-01-06 15:00:00
2022-01-14 00:00:00
2022-01-14 07:00:00
2022-01-14 08:00:00
2022-01-14 16:00:00
2022-01-18 05:00:00
2022-01-18 08:00:00
2022-01-18 12:00:00
2022-01-18 22:00:00
2022-01-21 02:00:00
2022-01-21 04:00:00
2022-01-21 10:00:00
2022-01-21 15:00:00
2022-01-24 07:00:00
2022-01-24 08:00:00
2022-01-24 10:00:00
2022-01-24 16:00:00
2022-01-11 03:00:00
2022-01-11 11:00:00
2022-01-11 17:00:00
2022-01-17 08:00:00
2022-01-17 08:00:00
2022-01-17 15:00:00
2022-01-20 02:00:00
2022-01-20 12:00:00
2022-01-20 17:00:00
2022-01-25 08:00:00
2022-01-25 13:00:00
2022-01-25 17:00:00
2022-01-27 04:00:00
2022-01-27 12:00:00
2022-01-27 13:00:00
2022-01-10 15:00:00
2022-01-10 15:00:00
2022-01-12 10:00:00
2022-01-12 10:00:00
2022-01-13 09:00:00
2022-01-13 20:00:00
2022-01-19 03:00:00
2022-01-19 18:00:00
2022-01-26 12:00:00
2022-01-26 18:00:00
2022-01-28 08:00:00
2022-01-28 15:00:00
2022-01-03 15:00:00
2022-01-04 18:00:00
2022-01-07 14:00:00
2022-01-31 15:00:00
Spreadsheet: 860937d1708954574-less-than-or-greater-than-with-time-shift-log
Sheet: Sheet2

Start 1st shift | End 1st Shift | 1st Shift Length | Start 2nd Shift | End 2nd Shift | Break | Total (Hrs)
 |  |  | 19:45:00 | 05:30:00
12:00:00 | 13:30:00 |  | 19:00:00 | 05:30:00
 |  |  | 19:00:00 | 05:30:00 | 01:00:00
 |  | 01:30:00 | 19:00:00 | 05:30:00
 |  |  | 19:45:00 | 07:30:00 | 03:00:00
 |  | 02:00:00 | 20:00:00 | 06:30:00
 |  |  | 19:45:00 | 07:30:00
 |  | 02:00:00 | 20:00:00 | 06:30:00
 |  |  | 20:00:00 | 07:30:00
 |  | 00:40:00 | 21:00:00 | 07:30:00 | 02:00:00
 |  | 01:00:00 | 19:00:00 | 04:30:00
 |  | 02:00:00 | 19:30:00 | 05:30:00
 |  |  | 20:00:00 | 05:30:00
 |  |  | 20:30:00 | 05:30:00
 |  |  | 19:45:00 | 05:30:00
 |  |  | 20:45:00 | 05:30:00
 |  | 02:30:00 | 19:30:00 | 06:00:00
 |  |  | 19:45:00 | 07:00:00
 |  | 02:00:00 | 19:30:00 | 06:00:00
 |  | 00:45:00 | 19:45:00 | 05:45:00
 |  | 02:00:00 | 19:45:00 | 06:00:00 | 01:00:00
 |  | 00:45:00 | 20:00:00 | 08:37:00
 |  | 01:00:00 | 20:00:00 | 08:00:00 | 01:40:00
 |  |  | 20:00:00 | 05:30:00
 |  | 01:00:00 | 20:00:00 | 05:31:00
 |  | 02:30:00 | 19:00:00 | 06:30:00
 |  | 00:45:00 | 20:00:00 | 06:15:00
 |  | 00:40:00 | 20:20:00 | 07:00:00
 |  | 01:40:00 | 20:30:00 | 06:30:00 | 01:00:00
 |  | 01:30:00 | 20:00:00 | 06:15:00
 |  |  | 20:20:00 | 06:15:00
 |  | 01:30:00 | 22:30:00 | 06:00:00
 |  | 01:00:00 | 20:00:00 | 06:15:00
 |  |  | 20:20:00 | 09:00:00 | 01:00:00
 |  | 01:30:00 | 20:45:00 | 06:00:00
 |  | 00:45:00 | 19:45:00 | 05:55:00
 |  | 01:50:00 | 19:30:00 | 07:00:00
 |  | 02:00:00 | 19:30:00 | 07:00:00 | 00:30:00
 |  | 01:45:00 | 20:00:00 | 05:20:00 | 01:00:00
13:30:00 | 15:00:00 |  | 19:50:00 | 08:30:00 | 02:30:00
00:00:00 | 00:00:00 |  | 19:00:00 | 05:50:00 | 00:00:00
12:00:00 | 12:45:00 |  | 19:20:00 | 05:30:00
12:00:00 | 12:45:00 |  | 19:30:00 | 05:30:00 | 00:30:00
 |  |  | 19:40:00 | 05:57:00
 |  |  | 19:35:00
12:30:00 | 13:30:00 |  | 19:40:00 | 06:30:00 | 01:40:00
12:00:00 | 13:50:00 |  | 20:00:00 | 06:25:00 | 00:00:00
12:05:00 | 13:40:00 |  | 19:45:00 | 07:45:00 | 01:45:00
 |  |  | 19:05:00 | 07:00:00 | 00:40:00
12:30:00 | 13:45:00 |  | 20:00:00 | 07:45:00 | 00:00:00
13:00:00 | 15:00:00 |  | 20:15:00 | 06:50:00 | 03:30:00
Spreadsheet: 90599d1290373527-generating-multi-ple-worksheets-from-a-single-master-worksheet-attn2010
Sheet: JD

BP
Spreadsheet: 117718d1312982281-meging-info-in-table-info
Sheet: Sheet1

Given Name | S/name | Family name | info |  |  | Given Name | S/name | Family name | info
Gname1 | Sname1 | Fname1 | HHH |  |  | Gname1 | Sname1 | Fname1 | HHH, CP12, 34, [NAME], data2
 |  |  | CP12 |  |  | Gname2 | Sname2 | Fname2
 |  |  | 34 |  |  | Gname3 | Sname3 | Fname3 | SSSK, CP2345, 23, [NAME], data4
 |  |  | [NAME]
 |  |  | data2
Gname2 | Sname2 | Fname2
Gname3 | Sname3 | Fname3 | SSSK
 |  |  | CP2345
 |  |  | 23
 |  |  | data3
 |  |  | data4
Spreadsheet: 70871d1271623575-excel-line-graphs-average-example-of-data-and-graph
Sheet: Sheet1

Time | recorded values |  | avg.
10:27:33.600000 | 5.220800000000001
10:32:33.600000 | 3.2968
10:37:33.600000 | 2.7976
10:42:33.600000 | 2.7976
10:47:33.600000 | 4.815200000000001
10:52:33.600000 | 3.172
10:57:33.600000 | 4.2744
11:02:33.600000 | 2.8288
11:07:33.600000 | 4.5552
11:12:33.600000 | 3.3384
11:17:33.600000 | 2.8288
11:22:33.600000 | 3.7024
11:27:33.600000 | 2.5792
11:32:33.600000 | 3.6504
11:37:33.600000 | 3.2448
11:42:33.600000 | 2.4232
11:47:33.600000 | 2.5064
11:52:33.600000 | 2.1008
11:57:33.600000 | 1.768
12:02:33.600000 | 1.6016
12:07:33.600000 | 2.756
12:12:33.600000 | 3.9728
12:17:33.600000 | 3.5464
12:22:33.600000 | 4.139200000000001
12:27:33.600000 | 2.0904
12:32:33.600000 | 1.8928
12:37:33.600000 | 3.6296
12:42:33.600000 | 3.5464
12:47:33.600000 | 1.9448
12:52:33.600000 | 2.8912
12:57:33.600000 | 1.8304
13:02:33.600000 | 1.4768
13:07:33.600000 | 2.392
13:12:33.600000 | 1.3416
13:17:33.600000 | 0.8112
13:22:33.600000 | 0.6968000000000001
13:27:33.600000 | 0.6344
13:32:33.600000 | 0.5824
13:37:33.600000 | 0.5616
13:42:33.600000 | 0.5408
13:47:33.600000 | 0.6136
13:52:33.600000 | 0.6344
13:57:33.600000 | 0.6344
14:02:33.600000 | 0.6344
14:07:33.600000 | 0.6136
14:12:33.600000 | 0.6032000000000001
14:17:33.600000 | 0.5928
14:22:33.600000 | 0.5720000000000001
14:27:33.600000 | 0.5616
14:32:33.600000 | 0.5512
14:37:33.600000 | 0.5304
14:42:33.600000 | 0.52
14:47:33.600000 | 0.5096
14:52:33.600000 | 0.5096
Spreadsheet: 79547d1279791221-non-duplicate-drop-down-list-and-non-blank-lists-grahams-template-new
Sheet: Input

Unique_ID | ID_No | Question 1 | Question 2 | Question 3 | Question 4 | Question 5 | Question 6 | Question 7 | Question 8 | Question 9 | Question 10 | Question 11 | Question 12 | Question 13 | Question 14 | Question 15 | Question 16 | Question 17 | Question 18 | Question 19 | Question 20 | Question 21 | Question 22 | Question 23 | Question 24 | Question 25 | Question 26 | Question 27 | Question 28 | Question 29 | Question 30 | Question 31 | Question 32 | Question 33 | Question 34 | Question 35 | Question 36 | Question 37 | Question 38 | Question 39 | Question 40 | Question 41 | Question 42 | Question 43 | Question 44 | Question 45 | Question 46 | Question 47 | Question 48 | Question 49 | Question 50 | Question 51 | Question 52 | Question 53 | Question 54 | Question 55 | Question 56 | Question 57 | Question 58 | Question 59 | Question 60 | Question 61 | Question 62 | Question 63 | Question 64 | Question 65 | Question 66 | Question 67 | Question 68 | Question 69 | Question 70 | Question 71 | Question 72 | Question 73 | Question 74 | Question 75
Unique ID | ID Number | Question 1 | Question 2 | Question 3 | Question 4 | Question 5 | Question 6 | Question 7 | Question 8 | Question 9 | Question 10 | Question 11 | Question 12 | Question 13 | Question 14 | Question 15 | Question 16 | Question 17 | Question 18 | Question 19 | Question 20 | Question 21 | Question 22 | Question 23 | Question 24 | Question 25 | Question 26 | Question 27 | Question 28 | Question 29 | Question 30 | Question 31 | Question 32 | Question 33 | Question 34 | Question 35 | Question 36 | Question 37 | Question 38 | Question 39 | Question 40 | Question 41 | Question 42 | Question 43 | Question 44 | Question 45 | Question 46 | Question 47 | Question 48 | Question 49 | Question 50 | Question 51 | Question 52 | Question 53 | Question 54 | Question 55 | Question 56 | Question 57 | Question 58 | Question 59 | Question 60 | Question 61 | Question 62 | Question 63 | Question 64 | Question 65 | Question 66 | Question 67 | Question 68 | Question 69 | Question 70 | Question 71 | Question 72 | Question 73 | Question 74 | Question 75
Test | 1 | 1 |  |  | 5 | This is a test 1
Test | 2 | 4 |  |  |  | This is a test 2
Test 1
Test 3
 |  |  |  |  |  | This is a test 4
Spreadsheet: benjamin_rogers__1171__Gleason - 501F & 501FD
Sheet: Debt Amortization

Debt Amortization
EBITDA
DSCR - Tranche A
DSCR - Tranche B
DSCR - Tranche C
Interest Rate For Period, Tranche A
Interest Rate For Period, Tranche B
Interest Rate For Period, Tranche C
Total Annual CFAFDS
NPV of CFAFDS Tranche A
NPV of CFAFDS Tranche B
NPV of CFAFDS Tranche C
NPV of Total CFAFDS
Tranche A
Beginning Balance
Interest
Principal
Total Debt Service
Ending Balance
Average Life (years)
Tranche B
Beginning Balance
Interest
Principal
Total Debt Service
Ending Balance
Average Life (years)
Tranche C
Beginning Balance
Interest
Principal
Total Debt Service
Ending Balance
Average Life (years)
TOTAL ANNUAL DEBT AMORTIZATION
Beginning Balance
Interest
Principal
Total Debt Service
Ending Balance
Average Life (years)
Check
TRANCHE 1
Beginning Prinipal
Interest Rate
Term
Grace Period
 |  | Project Period
Beginning Balance
Interests
Principal Payments
Debt Service
Ending Balance
Average Life (years)
 |  | Percentage of Principal Repaid |  | 0.25 | 0.25 | 0.25 | 0.25 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TRANCHE 2
Beginning Prinipal
Interest Rate
Term
Grace Period
 |  | Project Period
Beginning Balance
Interests
Principal Payments
Debt Service
Ending Balance
Average Life (years)
 |  | Percentage of Principal Repaid |  | 0 | 0 | 0.05 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.2 | 0.25 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TRANCHE 3
Beginning Prinipal
Interest Rate
Term
Grace Period
 |  | Project Period
Tranche A
Beginning Balance
Interests
Principal Payments
Debt Service
Ending Balance
Average Life (years)
 |  | Percentage of Principal Repaid |  | 0 | 0 | 0 | 0 | 0.02 | 0.02 | 0.03 | 0.03 | 0.03 | 0.04 | 0.04 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.1 | 0.12 | 0.15 | 0.17 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 221084d1363362554-same-formula-works-in-1-spreadsheet-but-no-another-working-tracking-sheet
Sheet: Lists

 | Select |  | Select |  |  | Select |  | Select |  | Select
 | Print Copy |  | AM |  |  | Yes |  | FTP |  | All Corrections Made
 | PDF |  | PM |  |  | No |  | Hard Drive |  | Corrections Made but Re-Records Needed
 |  |  | Eve |  |  |  |  | Other |  | Re-Records Not Needed
 |  |  |  |  |  |  |  |  |  | Re-Records Needed
 |  |  |  |  |  |  |  |  |  | Re-Records Done
Downloads | 1 | Number of CD's | 7.316455696202532 | Final Running Time | 578 |  |  |  |  | All Corrections and Re-Records Done
Audio CD | 1 | Rounded Up Number | 8 | Average time per CD | 72.25
Cassette | 0
Spreadsheet: 880069d1727705072-detect-employee-actual-entry-data-and-exit-date-detect-employee-actual-entry-data-and-exit-date
Sheet: Sheet1

Employee Name | Entry Date | Exit Date | Role | Team | Actual Entry Date | Actualy Exit Date | Check if Entry Date is promotion or transfer date | Check if Exit Date is promotion or transfer date |  | Actual Entry Date | Actualy Exit Date | Check | Check
A | 2021-10-01 00:00:00 | 2021-11-30 00:00:00 | Engineer | Data Science |  |  |  |  |  | 2021-06-01 00:00:00 | 2021-11-30 00:00:00
A | 2021-06-01 00:00:00 | 2021-09-30 00:00:00 | Engineer | Engineering 1 |  |  |  |  |  | 2021-06-01 00:00:00 | 2021-11-30 00:00:00
B | 2022-10-01 00:00:00 |  | Manager | Engineering 1 |  |  |  |  |  | 2021-03-01 00:00:00
B | 2021-10-15 00:00:00 | 2022-09-30 00:00:00 | Technical Architect | Engineering 1 |  |  |  |  |  | 2021-03-01 00:00:00
B | 2021-03-01 00:00:00 | 2021-10-14 00:00:00 | Engineer | Engineering 1 |  |  |  |  |  | 2021-03-01 00:00:00
C | 2024-08-01 00:00:00 | 2027-07-31 00:00:00 | Trainee | Apprenticeship |  |  |  |  |  | 2024-08-01 00:00:00 | 2027-07-31 00:00:00
D | 2022-05-23 00:00:00 | 2023-04-30 00:00:00 | Product Manager | Supply Chain |  |  |  |  |  | 2020-12-01 00:00:00 | 2023-04-30 00:00:00
D | 2020-12-01 00:00:00 | 2022-05-22 00:00:00 | Product / Service Owner | Supply Chain |  |  |  |  |  | 2020-12-01 00:00:00 | 2023-04-30 00:00:00
E | 2023-10-01 00:00:00 |  | Engineer | Engineering 2 |  |  |  |  |  | 2023-10-01 00:00:00
E | 2020-12-01 00:00:00 | 2022-05-31 00:00:00 | Engineer | Engineering 2 |  |  |  |  |  | 2020-12-01 00:00:00 | 2022-05-31 00:00:00
Spreadsheet: 228019d1365956914-finding-the-top-3-most-common-results-in-a-list-and-presenting-them-in-a-separate-sheet-0mode
Sheet: Winners

Funniest Student |  |  |  | Sportiest Student |  |  |  | Quirkiest Student |  |  |  | Happiest Student
1st Boy | [NAME] |  |  | 1st Boy |  |  |  | 1st Boy |  |  |  | 1st Boy
2nd Boy | Fred |  |  | 2nd Boy |  |  |  | 2nd Boy |  |  |  | 2nd Boy
[NAME] | [NAME] |  |  | [NAME] |  |  |  | [NAME] |  |  |  | [NAME]
1st Girl |  |  |  | 1st Girl |  |  |  | 1st Girl |  |  |  | 1st Girl
2nd Girl |  |  |  | 2nd Girl |  |  |  | 2nd Girl |  |  |  | 2nd Girl
[NAME] |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | [NAME]
Best Mucician |  |  |  | Best Artist |  |  |  | Quietest Student |  |  |  | Loudest Student
1st Boy |  |  |  | 1st Boy |  |  |  | 1st Boy |  |  |  | 1st Boy
2nd Boy |  |  |  | 2nd Boy |  |  |  | 2nd Boy |  |  |  | 2nd Boy
[NAME] |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | [NAME]
1st Girl |  |  |  | 1st Girl |  |  |  | 1st Girl |  |  |  | 1st Girl
2nd Girl |  |  |  | 2nd Girl |  |  |  | 2nd Girl |  |  |  | 2nd Girl
[NAME] |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | [NAME]
Best Smile |  |  |  | Most Likely to Rule the World |  |  |  | Most Likely to be the Prime Minister |  |  |  | Most Likely to be Famous
1st Boy |  |  |  | 1st Boy |  |  |  | 1st Boy |  |  |  | 1st Boy
2nd Boy |  |  |  | 2nd Boy |  |  |  | 2nd Boy |  |  |  | 2nd Boy
[NAME] |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | [NAME]
1st Girl |  |  |  | 1st Girl |  |  |  | 1st Girl |  |  |  | 1st Girl
2nd Girl |  |  |  | 2nd Girl |  |  |  | 2nd Girl |  |  |  | 2nd Girl
[NAME] |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | [NAME]
Most Hardworking Student |  |  |  | Most Caring Student |  |  |  | Most Caring Student |  |  |  | Most Cleaver Student
1st Boy |  |  |  | 1st Boy |  |  |  | 1st Boy |  |  |  | 1st Boy
2nd Boy |  |  |  | 2nd Boy |  |  |  | 2nd Boy |  |  |  | 2nd Boy
[NAME] |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | [NAME]
1st Girl |  |  |  | 1st Girl |  |  |  | 1st Girl |  |  |  | 1st Girl
2nd Girl |  |  |  | 2nd Girl |  |  |  | 2nd Girl |  |  |  | 2nd Girl
[NAME] |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | [NAME]
Couple Most Likely to [NAME] |  |  |  | Best Double Act
1st |  |  |  | 1st
2nd |  |  |  | 2nd
3rd |  |  |  | 3rd
Spreadsheet: joe_parks__14802__BridgeDPR0613
Sheet: Bridgeline DPR2

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BRIDGELINE GAS MARKETING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DAILY POSITION REPORT
 |  | Position |  |  | Maturity / Gap Risk |  |  | Value-at-Risk |  |  |  | P&L ($000)
Business Unit - Commodity Group |  | Net Open | Limit |  | Sensitivity | Limit |  | 1-Day |  | Limit |  | Today | 5 Day Rolling | MTD | QTD | YTD |  | Yesterday's MTD | Yesterday's QTD | Yesterday's YTD
BRIDGELINE GAS MARKETING
GAS TRADING |  |  | 15 Bcf |  |  |  |  |  |  | 2000
1 Month |  |  |  |  |  | 9 Bcf 1 Month
2-12 Months |  |  |  |  |  | 25 Bcf 2-12 Months
13-18 Months |  |  |  |  |  | 5 Bcf 13-18 Months
TOTAL TRADING
Notes to File
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MTD | QTD | YTD
 |  |  |  |  |  |  |  |  |  |  |  |  | ENRON NORTH AMERICA | 1460.875040299999 | 6615.875040299999 | 11906.8750403
 |  |  |  |  |  |  |  |  |  |  |  |  | GAS TRADING | 1460.875040299999 | 6615.875040299999 | 11906.8750403
 | 0
 |  |  |  |  |  |  |  |  |  | 5923.328615262726
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 5923.328615262726
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | -2243.48
 |  |  |  |  |  |  |  |  |  | 998027.0603850778
Spreadsheet: 868685d1715349803-nested-array-query-fail-alternatives-nested_array
Sheet: Sheet1

Query Criteria (filter array result) |  |  |  |  | Query Data |  |  |  |  | expected return
a1 |  |  |  |  | a1 | a1-d1 | a1-z1 |  |  | a1 | a1-d1 | a1-z1
a3 |  |  |  |  | a1 | [NAME] | [NAME] |  |  | a1 | [NAME] | [NAME]
a5 |  |  |  |  | a1 | a1-d3 | [NAME] |  |  | a1 | a1-d3 | [NAME]
 |  |  |  |  | a2 | a2-d1 | a2-z1 |  |  | a3 | a3-d1 | a3-z1
 |  |  |  |  | a3 | a3-d1 | a3-z1 |  |  | a3 | a3-d2 | [NAME]
 |  |  |  |  | a3 | a3-d2 | [NAME] |  |  | a5 | a5-d1 | a5-z1
 |  |  |  |  | a4 | a4-d1 | a4-z1
 |  |  |  |  | a4 | [NAME] | a4-z2
 |  |  |  |  | a5 | a5-d1 | a5-z1
using byrow/lambda |  |  |  |  | using filter only
Spreadsheet: 1e7e882e-8b06-4ba6-99d6-81a81405504f
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 | Risk Balanced Commodity Fund
 | Monthly Performance History
 | Inception Date | 2012-07-09 00:00:00
 |  | Class I | Class N | UBS Dow Jones
 | Date | ARCIX | ARCNX | Commodity Index
* | 2012-07-31 00:00:00 | 0.02699999999999991 | 0.02699999999999991 | 0.03248631122739276
 | 2012-08-31 00:00:00 | 0.03602726387536515 | 0.03505355404089583 | 0.01298355992804878
 | 2012-09-30 00:00:00 | 0.01597744360902253 | 0.01599247412982119 | 0.01705559998270556
 | 2012-10-31 00:00:00 | -0.0545790934320074 | -0.0537037037037037 | -0.03872880663780853
 | 2012-11-30 00:00:00 | -0.004892367906066619 | -0.005870841487279899 | 0.0005160544468780781
 | 2012-12-31 00:00:00 | -0.0294985250737464 | -0.02952755905511817 | -0.0260713221720742
 | 2013-01-31 00:00:00 | 0.04660587639311053 | 0.04665314401622722 | 0.0239726
 | 2013-02-28 00:00:00 | -0.07066795740561471 | -0.07073643410852715 | -0.04086798
 | 2013-03-31 00:00:00 | -0.01770833333333333 | -0.01876955161626692 | 0.00673825
 | 2013-04-30 00:00:00 | -0.05832449628844105 | -0.05844845908607876 | -0.02790998
 | 2013-05-31 00:00:00 | -0.013513514 | -0.013544018 | -0.02242793
 | 2013-06-30 00:00:00 | -0.04794520547945202 | -0.04805491990846678 | -0.04714576
 | 2013-07-31 00:00:00 | 0.01079136690647475 | 0.01081730769230771 | 0.01362443
 | 2013-08-31 00:00:00 | 0.03202846975088969 | 0.03210463733650415 | 0.03402301
 | 2013-09-30 00:00:00 | -0.024137931 | -0.0241935484 | -0.02554184
 | 2013-10-31 00:00:00 | -0.0070671378 | -0.0082644628 | -0.0147661928
 | 2013-11-30 00:00:00 | -0.02016607354685651 | -0.01904761904761909 | -0.008003462071515033
 | 2013-12-31 00:00:00 | 0.003631961 | 0.002427184 | 0.01239895
 | 2014-01-31 00:00:00 | -0.01085645355850418 | -0.01089588377723971 | 0.00297646201515489
 | * partial month return, inception date 7/9/2012
 | Risk Balanced Commodity Fund
 | [NAME]
 | Month-end Returns as of | Class I | Class N | UBS Dow Jones Commodity
 | January 31, 2014 | ARCIX | ARCNX | Index
 | 1 Year | -0.2061955475116145 | -0.2083333336568224 | -0.1137850787157384
 | 3 Years
 | 5 Years
 | 10 Years
 | Since Inception Cumulative Return | -0.1800000005794982 | -0.1830000003338408 | -0.09581784309885266
 | Since Inception Annualized Return | -0.119139210148372 | -0.1212005917452353 | -0.06235702323970216
 | Since Inception Annualized Monthly Volatility | 0.1154246689719549 | 0.1149315219421225 | 0.08739980881388516
 | Quarter-end Returns as of | Class I | Class N | UBS Dow Jones Commodity
 | December 31, 2013 | ARCIX | ARCNX | Index
 | 1 Year | -0.1600810542916495 | -0.1622718056161442 | -0.09523320688603654
 | 3 Years
 | 5 Years
 | 10 Years
 | Since Inception Cumulative Return | -0.1710000005858585 | -0.1740000003375184 | -0.0985011202710705
 | Since Inception Annualized Return | -0.1190547961976401 | -0.1212109000920074 | -0.06769115328253228