tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 729643d1619232420-ranking-list-based-on-test-scores-new-hire-testing
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I am working on an Excel sheet that places a rank by each person based on their score for a certain part of a hiring test, each section is tested individually and then the average of the rank of each list is used to rank them overall. It will only rank if each all scores are listed, but I would like to to rank regardless of if all section scores are entered and regardless of if each persons scores are entered. If I delete even one score the overall averages go to #value!. Also I may have 30 people testing one time but only 5 people testing the next time so I may not have each cell filled out. I will attach the file for reference.
Name A-Z |  | Written Exam |  | Fintess Eval |  | Interview |  | Average of 3 tests | Overall Rank
Last | First | Score | Place | Score | Place | Score | Place |  |  |  |  | Written Exam Helper 1 | Written Exam Helper 2 | Fitness Eval Helper 1 | Fitness Eval Helper 2 | Interview Helper 1 | Interview Helper 2
 |  | 88 |  | 22 |  | 58
 |  | 100 |  | 88 |  | 90
 |  | 100 |  | 85 |  | 25
 |  | 100 |  | 86 |  | 23
 |  | 100 |  | 87 |  | 24
 |  | 100 |  | 88 |  | 25
 |  | 100 |  | 89 |  | 26
 |  | 100 |  | 91 |  | 27
 |  | 100 |  | 90 |  | 28
 |  | 100 |  | 92 |  | 29
 |  | 100 |  | 93 |  | 30
 |  | 100 |  | 94 |  | 31
 |  | 100 |  | 95 |  | 32
 |  | 100 |  | 96 |  | 33
 |  | 100 |  | 97 |  | 34
 |  | 100 |  | 98 |  | 35
 |  | 100 |  | 85 |  | 36
 |  | 100 |  | 84 |  | 37
 |  | 100 |  | 83 |  | 38
 |  | 100 |  | 82 |  | 39
 |  | 100 |  | 81 |  | 40
 |  | 100 |  | 80 |  | 41
 |  | 100 |  | 79 |  | 42
 |  | 100 |  | 78 |  | 43
 |  | 100 |  | 77 |  | 45
 |  | 100 |  | 76 |  | 45
 |  | 100 |  | 75 |  | 46
 |  | 100 |  | 74 |  | 47
 |  | 100 |  | 73 |  | 48
 |  |  |  | 72 |  | 49
Spreadsheet: 137647d1327295593-if-a-name-from-dropdown-then-e-list-item-and-g-list-item-if_then_testing
Sheet: Sheet1

name |  |  |  | fruit |  | color
billy bob |  |  |  | apple |  | red
list of names |  |  |  | fruit data |  |  |  |  |  |  |  |  |  |  | fruit | color
jone |  |  |  | apple |  | blue |  |  |  |  |  |  |  |  | apple | black
billy bob |  |  |  | apple |  | red |  |  |  |  |  |  |  |  | apple | red
[NAME] |  |  |  | banana |  | yellow |  |  |  |  |  |  |  |  | banana | yellow
Spreadsheet: jeffrey_a_shankman__14004__Stranded Cost Analysis Structuring Confidential
Sheet: Overmarket Chart

 | Mark-to-Market of
 | DWR Contracts By Counter Party
 | ($s, negative number means contract is above market)
 | Calpine
 | Coral
 | [NAME]
 | Dynegy
 | Allegheny
 | High Desert
 | GWF
 | Mirant
 | Constellation
 | El Paso
 | Morgan Stanley
 | Alliant
 | PG&E Gen
 | Clearwood
 | IID
 | Duke Energy
 | Total Overmarket PV
Spreadsheet: 217175d1361997935-help-with-stock-take-multiple-listings-of-part-numbers-that-need-to-be-accumulated-help-required-variance-report
Sheet: Sheet1

Part Number | On Hand |  | Part Number | Counted |  | Part Number | On Hand | Counted | [NAME]
00771-00240 | 50 |  | 00771-00240 | 29 |  | 00771-00240
00771-00320 | 50 |  | 00771-00320 | 32 |  | 00771-00320
00771-00480 | 50 |  | 00771-00480 | 12 |  | 00771-00480
 |  |  | 00890-1087 | 1 |  | 00890-1087
0124072 | 5 |  | 0124072 | 6 |  | 0124072
0124074 | 6 |  | 0124074 | 5 |  | 0124074
0134072 | 4 |  | 0134072 | 2 |  | 0134072
0134074 | 4 |  | 0134074 | 4 |  | 0134074
0144072 | 2 |  | 0144072 | 3 |  | 0144072
 |  |  | 0144074 | 9 |  | 0144074
0183-9005 | 2 |  | 0183-9005 | 0 |  | 0183-9005
0276062 | 1 |  | 0276062 | 0 |  | 0276062
0286062 | 2 |  | 0286062 | 1 |  | 0286062
0296062 | 0 |  | 0296062 | 3 |  | 0296062
0371472 | 2 |  | 0371472 | 0 |  | 0371472
0381472 | 3 |  | 0381472 | 0 |  | 0381472
0391472 | 0 |  | 0391472 | 0 |  | 0391472
11021 | 1 |  | 11021 | 1 |  | 11021
20132 | 0 |  | 20132 | 2 |  | 20132
20133 | 0 |  | 20133 | 2 |  | 20133
 |  |  | 20144 | 3 |  | 20144
20183 | 0 |  | 20183 | 0 |  | 20183
20196 | 10 |  | 20196 | 10 |  | 20196
20197 | 41 |  | 20197 | 40 |  | 20197
Spreadsheet: 773380d1647844624-trying-to-make-an-automatic-competition-ladder-for-the-new-nrl-season-dally-m-2022
Sheet: Ladder

 | NRL 2022 Ladder
Rank | Team | W | D | L | For | Against | P+/- | Points
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | `
Spreadsheet: 759904d1639796548-2-criteria-vlookup-from-messy-less-messy-payroll-file-uploadtest
Sheet: Daily Export

 | 2021-08-02 00:00:00 |  | 2021-08-03 00:00:00 |  | 2021-08-04 00:00:00 |  | 2021-08-05 00:00:00
 | Monday |  | Tuesday |  | Wednesday |  | Thursday
Employee | SL | DL | SL | DL | SL | DL | SL | DL
Person1
Person2
 |  | 8.5 |  | 8.5 | 8.5
 | 8.5 |  |  |  |  | 8.5
Spreadsheet: 92108d1291767907-summarizing-cost-data-from-list-by-unit-excel-example
Sheet: Sheet3

Labor Cost
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13
C11013 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Total
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13
C11013 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
C12172 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
C12181 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
C12182 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
C12839 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
C12840 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 0e7ce6ab-e5d2-4b10-8ef1-6b3562ae904a
Sheet: Mergent

Mergent
2009-2010
COUNTER-Compliant?: | No
 | 2009-07-01 00:00:00 | 2009-08-01 00:00:00 | 2009-09-01 00:00:00 | 2009-10-01 00:00:00 | 2009-11-01 00:00:00 | 2009-12-01 00:00:00 | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | Total | 2009-2010 Price | Price per unit
MergentOnline
Logins | 26 | 5 | 5 | 38 | 665 | 99 | 10 | 144 | 122 | 179 | 46 | 15
Searched | 132 | 43 | 6 | 55 | 3307 | 253 | 31 | 617 | n/a | 273 | 131 | 50 |  | 15000
Companies Viewed | 68 | 9 | 0 | 55 | 939 | 160 | 7 | 653 | 107 | 239 | 74 | 11 |  | 15000
Time in database | 07:17:35 | 02:08:47 | 00:49:09 | 05:54:01 | 6d 23:18:23 | 18:25:37 | 02:04:20 | 1d   02:37:0 | 1d  09:58:3 | 1d  13:42:5 | 11:43:28 | 02:55:28 | —
 | 2009-07-01 00:00:00 | 2009-08-01 00:00:00 | 2009-09-01 00:00:00 | 2009-10-01 00:00:00 | 2009-11-01 00:00:00 | 2009-12-01 00:00:00 | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | Total | 2009-2010 Price | Price per unit
Mergent WebReports
Logins | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Searched | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A |  |  | N/A
Companies Viewed | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A |  |  | N/A
Time in database | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | —
Mergent WebReports purchased 4/2010.
Spreadsheet: 736657d1623780226-show-current-balance-in-a-customer-invoice-tracker-invoice-tracker-trial-2
Sheet: Invoice Tracker

 | Title
 | 2021-2022 Invoice Statement
 | Student: | Name Name
 | Parents: | Name and Name Name |  |  | Currently Owed |  | Remaining for Year
 | Address:
 | Phone:
 | Invoice # | Date | Payment Due | Customer Name | Amount | Late Fee | Total Paid | Date Paid | Outstanding
 | 1001 | 2021-05-01 00:00:00 | 2021-05-15 00:00:00 | Name | 617.5 |  | 0 | 2021-06-02 00:00:00
 | 1002 | 2021-06-01 00:00:00 | 2021-06-15 00:00:00 | Name | 617.5 |  | 1000 | 2021-06-02 00:00:00
 | 1003 | 2021-08-01 00:00:00 | 2021-08-15 00:00:00 | Name | 617.5
 | 1004 | 2021-09-01 00:00:00 | 2021-09-15 00:00:00 | Name | 617.5
 | 1005 | 2021-10-01 00:00:00 | 2021-10-15 00:00:00 | Name | 617.5
 | 1006 | 2021-11-01 00:00:00 | 2021-11-15 00:00:00 | Name | 617.5
 | 1007 | 2021-12-01 00:00:00 | 2021-12-15 00:00:00 | Name | 617.5
 | 1008 | 2022-01-01 00:00:00 | 2022-01-15 00:00:00 | Name | 395
 | 1009 | 2022-02-01 00:00:00 | 2022-02-15 00:00:00 | Name | 395
 | 1010 | 2022-03-01 00:00:00 | 2022-03-15 00:00:00 | Name | 395
 | 1011 | 2022-04-01 00:00:00 | 2022-04-15 00:00:00 | Name | 395
 | 1012 | 2022-05-01 00:00:00 | 2022-05-15 00:00:00 | Name | 395
 | Total
Spreadsheet: 52373d1252067640-populate-cells-depending-on-criteria-of-other-cell-uploadfile
Sheet: Comp Sheet

 |  |  |  |  |  |  |  |  | Event | 8 | Green Drive
 |  |  |  |  |  |  |  |  |  | Time | Name | H/Cap | 7/8ths | Stableford | Back 9
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |  |  |  |  |  | Score
[NAME] | 7 | 7 |  |  | 8 | 8 | 8 | 8
BS | 8 | 9 |  |  | 9 | 7 | 7 | 8
JF | 7 | 7 |  |  | 8 | 6 | 6 | 7
BB | 13 | 13 |  |  | 13 | 13 | 13 | 12
PC | 13 | 13 |  |  | 13 | 13 | 14 | 14
AL | 13 | 11 |  |  | 11 | 10 | 10 | 10
PM | 13 | 13 |  |  | 13 | 13 | 13 | 13
SG | 19 | 20 |  |  | 20 | 21 | 21 | 22
MB | 16 | 16 |  |  | 17 | 17 | 17 | 14
AW | 17 | 17 |  |  | 18 | 18 | 19 | 19
PW | 18 | 18 |  |  | 19 | 19 | 20 | 20
TD | 26 | 27 |  |  | 27 | 28 | 28 | 29
DS | 27 | 28 |  |  | 23 | 23 | 23 | 24
[NAME] | 30 | 30 |  |  | 31 | 31 | 31 | 32
Spreadsheet: 716799d1612368326-time-decomposition-formula-example
Sheet: Sheet1

Position_date | INDEX | PROFILE | Maturity Name | Maturity Index | Maturity
2021-02-02 00:00:00 | EL_ELIA | Pks | DAY | D01 | 2021-02-03 00:00:00
2021-02-02 00:00:00 | EL_ELIA | Pks | DAY | D02 | 2021-02-04 00:00:00
2021-02-02 00:00:00 | EL_ELIA | Pks | DAY | D03 | 2021-02-05 00:00:00
2021-02-02 00:00:00 | EL_ELIA | Pks | DAY | D04 | 2021-02-06 00:00:00
2021-02-02 00:00:00 | EL_ELIA | Pks | DAY | D05 | 2021-02-07 00:00:00
2021-02-02 00:00:00 | EL_ELIA | Pks | DAY | D06 | 2021-02-08 00:00:00
2021-02-02 00:00:00 | EL_ELIA | Pks | DAY | D07 | 2021-02-09 00:00:00
2021-02-02 00:00:00 | EL_ELIA | Pks | DAY | D08 | 2021-02-10 00:00:00
2021-02-02 00:00:00 | EL_ELIA | Pks | DAY | D09 | 2021-02-11 00:00:00
2021-02-02 00:00:00 | EL_ELIA | Pks | DAY | D10 | 2021-02-12 00:00:00
2021-02-02 00:00:00 | EL_ELIA | Pks | DAY | D11 | 2021-02-13 00:00:00
2021-02-02 00:00:00 | EL_ELIA | Pks | DAY | D12 | 2021-02-14 00:00:00
2021-02-02 00:00:00 | EL_ELIA | Pks | DAY | D13 | 2021-02-15 00:00:00
2021-02-02 00:00:00 | EL_ELIA | Pks | DAY | D14 | 2021-02-16 00:00:00
2021-02-02 00:00:00 | EL_ELIA | Pks | WEEK | W06 | WEEK-06
2021-02-02 00:00:00 | EL_ELIA | Pks | WEEK | W07 | WEEK-07
2021-02-02 00:00:00 | EL_ELIA | Pks | WEEK | W08 | WEEK-08
2021-02-02 00:00:00 | EL_ELIA | Pks | WEEK | W09 | WEEK-09
2021-02-02 00:00:00 | EL_ELIA | Pks | WEEK | W10 | WEEK-10
2021-02-02 00:00:00 | EL_ELIA | Pks | WEEK | W11 | WEEK-11
2021-02-02 00:00:00 | EL_ELIA | Pks | WEEK | W12 | WEEK-12
2021-02-02 00:00:00 | EL_ELIA | Pks | WEEK | W13 | WEEK-13
2021-02-02 00:00:00 | EL_ELIA | Pks | MONTH | M00 | 2021-02-01 00:00:00
2021-02-02 00:00:00 | EL_ELIA | Pks | MONTH | M01 | 2021-03-01 00:00:00
2021-02-02 00:00:00 | EL_ELIA | Pks | QUARTER | M02 | 2021-04-01 00:00:00
2021-02-02 00:00:00 | EL_ELIA | Pks | QUARTER | M03 | 2021-05-01 00:00:00
2021-02-02 00:00:00 | EL_ELIA | Pks | QUARTER | M04 | 2021-06-01 00:00:00
2021-02-02 00:00:00 | EL_ELIA | Pks | QUARTER | M05 | 2021-07-01 00:00:00
2021-02-02 00:00:00 | EL_ELIA | Pks | QUARTER | M06 | 2021-08-01 00:00:00
2021-02-02 00:00:00 | EL_ELIA | Pks | QUARTER | M07 | 2021-09-01 00:00:00
2021-02-02 00:00:00 | EL_ELIA | Pks | QUARTER | M08 | 2021-10-01 00:00:00
2021-02-02 00:00:00 | EL_ELIA | Pks | QUARTER | M09 | 2021-11-01 00:00:00
2021-02-02 00:00:00 | EL_ELIA | Pks | QUARTER | M10 | 2021-12-01 00:00:00
2021-02-02 00:00:00 | EL_ELIA | Pks | YEAR | M11 | 2022-01-01 00:00:00
2021-02-02 00:00:00 | EL_ELIA | Pks | YEAR | M12 | 2022-02-01 00:00:00
2021-02-02 00:00:00 | EL_ELIA | Pks | YEAR | [NAME] | 2022-03-01 00:00:00
Spreadsheet: 859347d1707757635-extracting-date-and-mixed-data-types-to-produce-a-12-month-publication-output-auto-12-view-of-publications-v2
Sheet: Monthly_Publication_List

Pub_Date | Pub_Title | Unicode_Chars
Tentative May-12 | TEST 1 | 128218
2024-02-02 00:00:00 | TEST 2 | 128218
2024-05-16 00:00:00 | TEST 3 | 128218
2024-05-16 00:00:00 | TEST 4 | 128218
2024-12-13 00:00:00 | TEST 5 | 128218
2024-12-12 00:00:00 | TEST 6 | 128218
2024-12-13 00:00:00 | TEST 7 | 128218
2024-12-14 00:00:00 | TEST 8 | 128218
2024-05-15 00:00:00 | TEST 9 | 128218
2024-05-16 00:00:00 | TEST 10 | 128218
2024-11-02 00:00:00 | TEST 11 | 128218
2024-03-02 00:00:00 | TEST 12 | 128218
2024-11-02 00:00:00 | TEST 13 | 128218
Tentative Nov-10 | TEST 14 | 128218
Tentative Nov-10 | TEST 15 | 128218
Tentative Nov-10 | TEST 16 | 128218
2024-02-02 00:00:00 | TEST 17 | 128218
2024-02-02 00:00:00 | TEST 18 | 128218
2024-01-05 00:00:00 | TEST 19 | 128218
2024-07-05 00:00:00 | TEST 20 | 128218
2024-07-05 00:00:00 | TEST 21 | 128218
2024-07-12 00:00:00 | TEST 22 | 128218
2024-07-05 00:00:00 | TEST 23 | 128218
2024-06-11 00:00:00 | TEST 24 | 128218
2024-06-07 00:00:00 | TEST 25 | 128218
2024-06-25 00:00:00 | TEST 26 | 128218
2024-02-02 00:00:00 | TEST 27 | 128218
2024-10-14 00:00:00 | TEST 28 | 128218
2024-10-15 00:00:00 | TEST 29 | 128218
2024-10-16 00:00:00 | TEST 30 | 128218
2024-02-10 00:00:00 | TEST 31 | 128218
2024-09-10 00:00:00 | TEST 32 | 128218
2024-02-10 00:00:00 | TEST 33 | 128218
2024-02-10 00:00:00 | TEST 34 | 128218
2024-02-10 00:00:00 | TEST 35 | 128218
2024-02-10 00:00:00 | TEST 36 | 128218
2024-01-10 00:00:00 | TEST 37 | 128218
2024-01-01 00:00:00 | TEST 38 | 128218
Confirmed Jan | TEST 39 | 128218
2024-04-02 00:00:00 | TEST 40 | 128218
2024-04-03 00:00:00 | TEST 41 | 128218
Tentative Apr-23 | TEST 42 | 128218
Tentative Apr-24 | TEST 43 | 128218
Confirmed Feb | TEST 44 | 128218
Tentative Mar | TEST 45 | 128218
Confirmed Jan | TEST 46 | 128218
Confirmed Jan | TEST 47 | 128218
Confirmed Jan | TEST 48 | 128218
2024-01-01 00:00:00 | TEST 49 | 128218
2024-02-01 00:00:00 | TEST 50 | 128218
2024-03-01 00:00:00 | TEST 51 | 128227
2024-04-01 00:00:00 | TEST 52 | 128227
2024-05-01 00:00:00 | TEST 53 | 128227
2024-06-01 00:00:00 | TEST 54 | 128227
2024-07-01 00:00:00 | TEST 55 | 128227
2024-08-01 00:00:00 | TEST 56 | 128227
2024-09-01 00:00:00 | TEST 57 | 128227
2024-10-01 00:00:00 | TEST 58 | 128227
2024-11-01 00:00:00 | TEST 59 | 128227
2024-12-02 00:00:00 | TEST 60 | 128227
2024-12-03 00:00:00 | TEST 61 | 128227
2024-12-04 00:00:00 | TEST 62 | 128227
Spreadsheet: 78377d1278709819-select-from-a-range-using-index-and-match-example2
Sheet: Sheet1

Salesman | Date | Pears | Apples | Oranges | Potatoes
[NAME] | 2010-01-01 00:00:00 | 1 | 3 | 7 | 2
George | 2010-02-01 00:00:00 | 3 | 7 | 2 | 0
[NAME] | 2010-02-01 00:00:00 | 7 | 2 | 0 | 5
[NAME] | 2010-03-01 00:00:00 | 2 | 0 | 4 | 6
George | 2010-03-01 00:00:00 | 0 | 5 | 6 | 5
[NAME] | 2010-03-01 00:00:00 | 4 | 6 | 5 | 3
[NAME] | 2010-04-01 00:00:00 | 7 | 5 | 5 | 5
George | 2010-04-01 00:00:00 | 5 | 8 | 9 | 0
[NAME] | 2010-05-01 00:00:00 | 3 | 9 | 0 | 3
Salesman | [NAME]
Date | 2010-03-01 00:00:00
Oranges | 4
Spreadsheet: kate_symes__18236__Cob
Sheet: DJ COB Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-03-26 00:00:00 |  | 324.62 | 5200 | 196.15 | 1560
 | 2001-03-25 00:00:00 |  |  |  |  |  |  |  | 86.42 | 965 |  | 197.59 | 3480
 | 2001-03-24 00:00:00 |  | 304.64 | 6640 | 198.68 | 760 | 190.9 | 2680 | 187.34 | 1463
 | 2001-03-23 00:00:00 |  | 305.27 | 5840 | 202.5 | 400 | 405.31 | 3225 | 358.35 | 1365
 | 2001-03-22 00:00:00 |  | 373.61 | 7200 | 222.62 | 840 | 401.04 | 3938 | 388.28 | 1215
 | 2001-03-21 00:00:00 |  | 441.52 | 3680 | 243.61 | 720 | 491.64 | 1345 | 382.76 | 870
 | 2001-03-20 00:00:00 |  | 399.53 | 5120 | 308.69 | 560 | 483.98 | 1040 | 363.65 | 1000
 | 2001-03-19 00:00:00 |  | 458.18 | 14320 | 290 | 200 | 410.04 | 1220 | 293.22 | 885
 | 2001-03-18 00:00:00 |  |  |  |  |  |  |  | 256.06 | 3083 |  | 310 | 1200
 | 2001-03-17 00:00:00 |  | 244.64 | 5600 | 200.19 | 1040 | 357.5 | 360 | 276.3 | 270
 | 2001-03-16 00:00:00 |  | 244.64 | 5600 | 200.19 | 1040 | 394.78 | 335 | 330 | 360
 | 2001-03-15 00:00:00 |  | 216.79 | 7600 | 168.33 | 1200 | 254.45 | 627 | 261.36 | 550
 | 2001-03-14 00:00:00 |  | 213.33 | 7200 | 178.33 | 600 | 246.45 | 900 | 222.58 | 1035
 | 2001-03-13 00:00:00 |  | 217.05 | 8800 | 174.4 | 1000 | 234.06 | 1946 | 237.07 | 870
 | 2001-03-12 00:00:00 |  | 270 | 6800 | 205 | 200 | 237.03 | 3775 | 219.92 | 1945
 | 2001-03-11 00:00:00 |  |  |  |  |  |  |  | 239.18 | 2715 |  | 205 | 600
 | 2001-03-10 00:00:00 |  | 228.93 | 5600 | 165 | 600 | 294.74 | 950 | 265.54 | 925
 | 2001-03-09 00:00:00 |  | 228.93 | 5600 | 165 | 600 | 366.94 | 1070 | 296.17 | 1600
 | 2001-03-08 00:00:00 |  | 276.67 | 6000 | 200 | 200 | 346.11 | 3730 | 314.25 | 2395
 | 2001-03-07 00:00:00 |  | 340.26 | 7600 | 263.33 | 600 | 350.64 | 3925 | 325.92 | 1567
 | 2001-03-06 00:00:00 |  | 338.57 | 2800 | 269.58 | 960 | 357.4 | 2896 | 344.21 | 1295
 | 2001-03-05 00:00:00 |  | 327 | 2000 | 306.25 | 800 | 344.21 | 4538 | 365.1 | 1235
 | 2001-03-04 00:00:00 |  |  |  |  |  |  |  | 330 | 1125 |  | 306.25 | 2400
 | 2001-03-03 00:00:00 |  | 298.33 | 4800 | 223.97 | 584 | 350 | 75 | 350 | 600
 | 2001-03-02 00:00:00 |  | 298.33 | 4800 | 223.97 | 584 | 365 | 200 | 350 | 285
 | 2001-03-01 00:00:00 |  | 292.12 | 6800 | 280 | 200 | 429.4 | 1762 | 326.61 | 930
 | 2001-02-28 00:00:00 |  | 200.76 | 5152 | 183.49 | 1328 | 338.36 | 10459 | 285.21 | 1523
 | 2001-02-27 00:00:00 |  | 202.25 | 2912 | 135 | 200 | 275.53 | 4475 | 267.2 | 795
 | 2001-02-26 00:00:00 |  | 248.21 | 5600 | 195 | 240 | 258.41 | 5480 | 226.05 | 950
 | 2001-02-25 00:00:00 |  |  |  |  |  |  |  | 181.6 | 2500 |  | 200 | 360
 | 2001-02-24 00:00:00 |  | 196.43 | 2800 | 140 | 200 | 214.05 | 4252 | 232.89 | 760
 | Explanatory Notes
 | R = REVISED |  |  | S = SURVEYED DATA |  |  |  | N/Q - NO QUOTE
 | Index: Weighted average price of megawatthours sold at COB. The Index is quoted in $/Mwh.
 | For questions or comments please call Antoine Eustache (609)520-7058 or [NAME] (609) 520-7067.
Spreadsheet: 866770d1713690742-conditional-sum-through-many-sheets-debit-notes-copy
Sheet: TC Debit Note

 | [NAME]
 | Ref no | 2
 | Revised? | No |  | Bank: |  | Bank 4
 | Debit Note Date | 2024-04-16 00:00:00
 | Commissions
 |  |  | Percentage | Amount in: |  | Amount in USD |  | Exchange rate:
 | Total Commission: |  | 0.05 |  |  |  |  | 1
 | our Commission: |  | 0.0125 |  |  |  |  |  |  | OUR REF: |  | / |  |  |  | /
 | Broker 1 |  | 0.05
 | Broker 2 |  | 0.05 |  |  |  |  |  |  | D  E  B  I  T     N  O  T  E
 | Net for us
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M/V |  |  | ACC |  |  | CP DD
 |  |  |  |  |  |  |  |  |  | Commission on hire of captioned vessel:
 | Hire Calculations
 |  |  |  |  |  |  |  |  |  | FROM: |  |  |  |  |  |  |  |  |  |  |  | HOURS
 |  |  |  |  |  |  |  |  |  | TO: |  |  |  |  |  |  |  |  |  |  |  | HOURS
 | ON HIRE
 | Daily Hire: |  |  | 999999 | USD | Notes: |  |  |  | TTL DAYS : |  |  |  |  |  |  |  |  |  |  | DAYS
 |  |  |  |  |  |  |  |  |  | [NAME]:
 | Dates: | From: | Date: | 2024-02-05 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL:
 |  |  | Time: | 13:00:00
 |  | To: | Date: | 2024-04-30 00:00:00
 |  |  | Time: | 20:30:00
 | [NAME]
 | Daily Hire:
 | [NAME]? | Yes |  | Yes |  | Yes |  | Notes:
 |  | Date | Time | Date | Time | Date | Time
 | From | 2024-04-01 00:00:00 | 10:00:00 | 2024-04-02 00:00:00 | 04:00:00 | 2024-04-03 00:00:00 | 10:00:00
 | To | 2024-04-02 00:00:00 | 03:00:00 | 2024-04-02 00:00:00 | 05:00:00 | 2024-04-05 00:00:00 | 15:33:00
 | TOTAL
 | [NAME]? | Yes |  | Yes |  | Yes |  | Notes:
 |  | Date | Time | Date | Time | Date | Time
 | From | 2024-04-01 00:00:00 | 10:00:00 | 2024-04-02 00:00:00 | 04:00:00 | 2024-04-03 00:00:00 | 10:00:00
 | To | 2024-04-02 00:00:00 | 03:00:00 | 2024-04-02 00:00:00 | 05:00:00 | 2024-04-05 00:00:00 | 15:33:00
 | TOTAL
 | [NAME]? | Yes |  | Yes |  | Yes |  | Notes:
 |  | Date | Time | Date | Time | Date | Time
 | From | 2024-04-01 00:00:00 | 10:00:00 | 2024-04-02 00:00:00 | 04:00:00 | 2024-04-03 00:00:00 | 10:00:00
 | To | 2024-04-02 00:00:00 | 03:00:00 | 2024-04-02 00:00:00 | 05:00:00 | 2024-04-05 00:00:00 | 15:33:00
 | TOTAL
 | [NAME]? | Yes |  | Yes |  | Yes |  | Notes:
 |  | Date | Time | Date | Time | Date | Time |  |  |  |  |  |  |  |  |  |  |  |  |  | GRAND TOTAL:
 | From | 2024-04-01 00:00:00 | 10:00:00 | 2024-04-02 00:00:00 | 04:00:00 | 2024-04-03 00:00:00 | 10:00:00
 | To | 2024-04-02 00:00:00 | 03:00:00 | 2024-04-02 00:00:00 | 05:00:00 | 2024-04-05 00:00:00 | 15:33:00 |  |  | COMMISSION |  |  |  |  |  |  |  |  |  |  | DUE:
 | TOTAL
 |  |  |  |  |  |  |  |  |  | Please make payment to:
 |  | Additional Charges:
 |  | Additional/Less |  | Description |  | Amount
 |  | Additional |  | LALA |  | 99999999
 |  | Additional |  | LELA |  | 72
 |  |  |  | RV |  | 287
 |  |  |  | RVV |  | 2
 |  | Additional |  | RV |  | 2572
 |  |  |  | V |  | 572
 |  |  |  | VV |  | 72
 |  |  |  | V |  | 75
 |  |  |  | AV |  | 2
 |  |  |  | SV |  | 4
 |  |  |  |  |  |  |  |  |  | ***********
Spreadsheet: 872523d1718889691-help-with-complex-formula-sor-template-etaf
Sheet: Breakdown of Costs

Works | W (mm) | H ([NAME]) | Area (m2) | Qty | SOR code | Unit | Description | Unit Price | Total Cost (£)
Fire Stopping | 100 | 900 |  | 1
Fire Stopping | 250 | 750 |  | 2
Fire Stopping | 500 | 600 |  | 3
Fire Stopping | 500 | 900 |  | 1
Fire Stopping | 700 | 1000 |  | 2
Fire Stopping | 1000 | 900 |  | 5
Fire Stopping | 1000 | 1000 |  | 10
Spreadsheet: darrell_schoolcraft__7819__imbalsumm0109
Sheet: NNG

NNG
 | Measured | Scheduled | Imbalance
1635 | -279274
3531 | -445830 | -199521
60667 | -70921 | -27236
60749 | 690582 | 146933
61206
61334 | -35203
62960
INDEX
2001-08-31 00:00:00 |  |  | 400688.32
2001-09-15 00:00:00
CBS Volume
 |  |  | -29477
Spreadsheet: richard_sanders__31686__ICE Sale Calc
Sheet: MPR

ICE DRILLING
Sale of assets
8/31/99
 |  | Gross |  | Net to ECT
Cash Proceeds |  | 9312198.88
Write off cost basis of Investment |  | -9979591.85
Write off accrued interest receivable
Write off BS FV Adj. |  | 1999996
Realized gain on sale in 8/99
Add'l proceeds recorded as income in 9/99 |  | 273646.86
Total 3rd quarter gain on sale
Spreadsheet: 493426d1481718953-holiday-records-working-on-individual-anniversaries-holiday-dates
Sheet: Employees

 | Holiday Allowance | 395
 |  | Year | 2016 |  |  | 2017
Employee ID | Name | Start Date | Leave year ending | Holiday Hours | [NAME] | Leave year ending | Holiday Hours | [NAME]
1 | Emp A | 2009-01-31 00:00:00
2 | Emp B | 2011-05-14 00:00:00
3 | Emp C | 2012-11-01 00:00:00
4 | Emp D | 2013-12-12 00:00:00