tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 814886d1674649424-count-unique-items-in-a-bin-and-reset-this-count-once-the-original-items-have-been-removed-sample
Sheet: Sheet1

Posting Date | Posting Time | Entry Type | Document No. | Item No. | Quantity | [NAME]
2023-01-24 00:00:00 | 09:54:12 | Place | PWPT3365796 | 212-125-OR1 | 3 | BD026 | Need to count the number of unique 'Item No's being placed into this Bin
2023-01-24 00:00:00 | 09:55:38 | Place | PWPT3365800 | 212-125-OR0.5 | 2 | BD026
2023-01-24 00:00:00 | 09:57:58 | Place | PWPT3365807 | 212-125-WT1.5 | 5 | BD026
2023-01-24 00:00:00 | 10:00:38 | Place | PWPT3365813 | 212-125-BL3 | 5 | BD026
2023-01-24 00:00:00 | 10:02:40 | Place | PWPT3365817 | TIE-V1625B | 3 | BD026
2023-01-24 00:00:00 | 10:06:04 | Place | PWPT3365827 | 212-125-VT3 | 10 | BD026
2023-01-24 00:00:00 | 10:12:54 | Place | PWPT3365852 | 212-125-GY3 | 8 | BD026
2023-01-24 00:00:00 | 10:18:35 | Place | PWPT3365871 | 212-125-YL3 | 15 | BD026
2023-01-24 00:00:00 | 10:28:33 | Place | PWPT3365902 | 212-125-GN1.5 | 40 | BD026
2023-01-24 00:00:00 | 11:42:27 | Take | PWPT3366158 | 212-125-YL3 | -15 | BD026 | Reset count
2023-01-24 00:00:00 | 11:42:53 | Take | PWPT3366159 | TIE-V1625B | -1 | BD026
2023-01-24 00:00:00 | 11:43:17 | Take | PWPT3366160 | 212-125-OR0.5 | -2 | BD026
2023-01-24 00:00:00 | 11:43:37 | Take | PWPT3366161 | 212-125-OR1 | -3 | BD026
2023-01-24 00:00:00 | 11:44:48 | Take | PWPT3366167 | 212-125-GN1.5 | -40 | BD026
2023-01-24 00:00:00 | 11:45:20 | Take | PWPT3366168 | TIE-V1625B | -2 | BD026
2023-01-24 00:00:00 | 11:45:52 | Take | PWPT3366171 | 212-125-WT1.5 | -5 | BD026
2023-01-24 00:00:00 | 11:46:24 | Take | PWPT3366173 | 212-125-GY3 | -8 | BD026
2023-01-24 00:00:00 | 11:47:19 | Take | PWPT3366176 | 212-125-BL3 | -5 | BD026
2023-01-24 00:00:00 | 11:48:02 | Take | PWPT3366179 | 212-125-VT3 | -10 | BD026
2023-01-24 00:00:00 | 14:03:25 | Place | PWPT3366579 | 00878M | 2 | BD026 | Need to count the number of unique 'Item No's being placed into this Bin
2023-01-24 00:00:00 | 14:35:21 | Place | PWPT3366681 | OM8G43200SO1RX8NE12 | 5 | BD026
2023-01-24 00:00:00 | 14:50:11 | Place | PWPT3366738 | JYJNW | 9 | BD026
2023-01-24 00:00:00 | 14:51:23 | Place | PWPT3366740 | KG52T | 5 | BD026
Spreadsheet: 151392d1334882903-working-schedule-hjb-schedule-1-
Sheet: Trace

Part Number | Part Name |  | Std Time | New Sched Time | 1.3 | Decimal
032115M3260 | QTN 1500 2-Axis Turret |  | 138 | 02:59 | 179.4 | 2.99
032115U0280 | QTN 2-Axis Turret Option |  | 72 | 01:33 | 93.60000000000001 | 1.56
[PHONE] | QTN 2-Axis Turret |  | 72 | 01:33 | 93.60000000000001 | 1.56
[PHONE] | QTN 2-AxisTurret Base |  | 143 | 03:05 | 185.9 | 3.098333333333334
032215U0241 | QTN M Turret (CDI) |  | 210 | 04:33 | 273 | 4.55
032215U0260 | QTN M Turret (CDI) |  | 210 | 04:33 | 273 | 4.55
[PHONE] | QTN M Turret |  | 117 | 02:32 | 152.1 | 2.535
[PHONE] | QTN 350 M Turret. |  | 102 | 02:12 | 132.6 | 2.21
[PHONE] | QTN [NAME] |  | 114 | 02:28 | 148.2 | 2.47
[PHONE] | 400 Head Stock |  | 41 | 00:53 | 53.3 | 0.8883333333333334
[PHONE] | 450 [NAME] 2Axis |  | 203 | 04:23 | 263.9 | 4.398333333333334
[PHONE] | 450 Head Stock |  | 41 | 00:53 | 53.3 | 0.8883333333333334
[PHONE] | VTC 800 Hsg Siemens |  | 74 | 01:36 | 96.2 | 1.603333333333333
0B071500023 | QTS 2 Axis Turret |  | 107 | 02:19 | 139.1 | 2.318333333333333
0B071500562 | QTS M Turret |  | 170 | 03:41 | 221 | 3.683333333333333
0B071500563 | QTS M Turret |  | 170 | 03:41 | 221 | 3.683333333333333
0B081500023 | QTS 350 2Axis [NAME] |  | 148 | 03:12 | 192.4 | 3.206666666666667
0B081500311 | QTS 350 M Turret |  | 185 | 04:00 | 240.5 | 4.008333333333334
Spreadsheet: darrell_schoolcraft__7327__imball0202
Sheet: Citizens-Griffith

 | Citizens-Griffith
 | POI 78069 - Citizens Griffith
Day | Measured | Scheduled
1 | -72039 | -57926
2 | -56841 | -58000
3 | -37738 | -45943
4 | -65947 | -57943
5 | -67788 | -64999
6 | -62250 | -64486
7 | -48009 | -54967
8
9
10 | -11316 | -6000
11 | -63764 | -51407
12 | -58527 | -67499
13 | -41171 | -51000
14 | -49898 | -52000
15 | -52161 | -60000
16 | -36534 | -33000
17 | -40628 | -29000
18 | -65332 | -54999
19 | -69179 | -54999
20 | -50001 | -69999
21 | -36526 | -50000
22 | -39318 | -35000
23 | -23799 | -16000
24 | -3979 | -5000
25 | -41787 | -35000
26
27
28
29
30
31
2002-01-31 00:00:00 |  |  | 23627.8
2002-02-25 00:00:00
CBS Volume
 |  |  | 14942
Spreadsheet: da36e4e5-f406-46e9-a08c-d87a1b2ec22f
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
HBA1C | Test | HBA1C | [NAME], Blood | [NAME], B | Ion-Exchange Chromatography Quantitative | EDTA (lavender-top) tube: EDTA |  |  | 3 | mL | Container/Tube: Lavender top (EDTA) [NAME]: 3 mL Collection Instructions: Send specimen in original tube. | 2 mL | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA | > or =18 years: 4.0-6.0% Reference values have not been established for patients that are <18 years of age. | Monday through Sunday; Continuously | Same day/1 day | 1 day | 1 | 83036 |  |  |  |  | Rochester
HBA1C | [NAME] | WBEDTA | [NAME] EDTA |  |  |  | Refrigerated | 7 days
HBA1C | Result | HBA1C | [NAME], B | [NAME], B | Numeric |  |  |  |  | % |  |  |  |  |  |  |  |  |  | 4548-4 | [NAME]/Hemoglobin.total:MFr:Pt:[NAME]:Qn:
Spreadsheet: 770158d1645834508-replacing-offset-to-sum-up-to-max-value-from-specific-cell-test-2
Sheet: Leads

Machine | 4103 | Machine | 4104 | Machine | 4105 | Machine | 4106
Engineering DWG | 2800026-A-05-0000 | Engineering DWG | 2800026-A-05-0000 | Engineering DWG | 2800026-A-10-0000 | Engineering DWG | 2800026-A-10-0000
Minutes | 50 | Minutes | 60 | Minutes | 20 | Minutes | 60
Starting N-Block | N1 | Starting N-Block | N11 | Starting N-Block | N11 | Starting N-Block | N11
Helper Column |  | Helper Column |  | Helper Column |  | Helper Column
Total N-Blocks |  | Total N-Blocks |  | Total N-Blocks |  | Total N-Blocks
Ending N-Block |  | Ending N-Block |  | Ending N-Block |  | Ending N-Block
Total Time (min.) |  | Total Time (min.) |  | Total Time (min.) |  | Total Time (min.)
Time Balance (min.) |  | Time Balance (min.) |  | Time Balance (min.) |  | Time Balance (min.)
Machine | 4107 | Machine | 4108 | Machine | 4109 | Machine | 4110
Machine | 4111 | Machine | 4112 | Machine | 4113 | Machine | 4114
Machine | 4115 | Machine | 4116 | Machine | 4201 | Machine | 4202
Machine | 4203 | Machine | 4204 | Machine | 4205 | Machine | 4206
Machine | 4207 | Machine | 4208 | Machine | 4209 | Machine | 4301
Machine | 4303 | Machine | 4304 | Machine | 4305 | Machine | 4306
Machine | 4307 | Machine | 4308 | Machine | 4309 | Machine | 4310
Spreadsheet: 719283d1613588309-click-n-drag-formula-that-auto-fills-sequential-sequence-book1
Sheet: Sheet1

Data
Data
Data
Data
Data
Data
Data
Data
Data
Data
Spreadsheet: 151392d1334882903-working-schedule-hjb-schedule-1-
Sheet: Master

Plt No | Part | Name | Cycle Time | Scheduled Start Time | Extra for 1st one | Minus | Delays | I/D | Scheduled Finish | I/D | Dkt No when finished | Actual Finish | Operator
 | Shift Start Time |  | 16:00:00 | 07:00:00 |  |  |  |  | 15:00:00
2 | 0B071500023 | QTS 2 Axis Turret | 107 | 09:19:00 |  |  | 00:05:00 | Thur | 09:24:00 | D6 |  | 09:25:00 | [NAME]
1 | 0B071500023 | QTS 2 Axis Turret | 107 | 09:24:00 |  |  | 01:00:00 |  | 12:43:00 | D4 |  | 12:05:00 | [NAME]
2 | 0B071500023 | QTS 2 Axis Turret | 107 | 12:43:00 |  |  |  |  |  | D7 |  | 14:50:00 | [NAME]
1 | 0B071500023 | QTS 2 Axis Turret | 107 |  |  |  |  |  |  | D5 | 71092 | 06:35:00 | [NAME]
2 | 0B071500023 | QTS 2 Axis Turret | 107 |  |  |  |  |  |  | D8 |  | 09:40:00 | [NAME]
1 | 0B071500023 | QTS 2 Axis Turret | 107 |  |  |  |  |  |  | D10 |  | 12:20:00 | [NAME]
2 | 0B071500023 | QTS 2 Axis Turret | 107 |  |  |  |  |  |  | D9 |  | 15:05:00 | [NAME]
1 | 0B071500023 | QTS 2 Axis Turret | 107 |  |  |  |  | Sat |  | D11 | 71383 | 06:45:00 | [NAME]
2 | [PHONE] | QTN [NAME] | 114 |  |  | 02:28:00 |  | Sun
1 | [PHONE] | QTN [NAME] | 114
2 | [PHONE] | QTN 350 M Turret. | 102 |  |  |  |  | Mon
1 | [PHONE] | QTN 350 M Turret. | 102
2 | [PHONE] | QTN 350 M Turret. | 102 |  |  |  |  | [NAME]
1 | [PHONE] | QTN 350 M Turret. | 102
2 | 0B081500311 | QTS 350 M Turret | 185 |  | 02:00:00
1 | 0B081500311 | QTS 350 M Turret | 185 |  |  |  |  | Wed
2 | 0B081500023 | QTS 350 2Axis [NAME] | 148 |  | 01:00:00
1 | 0B081500023 | QTS 350 2Axis [NAME] | 148
2 | 0B081500023 | QTS 350 2Axis [NAME] | 148 |  |  |  |  | Thur
1 | [PHONE] | QTN 350 M Turret. | 102 |  | 02:00:00
2 | [PHONE] | QTN 350 M Turret. | 102
1 | [PHONE] | QTN 350 M Turret. | 102
2 | [PHONE] | QTN 350 M Turret. | 102 |  |  |  |  | Fri
1 | 0B071500563 | QTS M Turret | 170 |  | 02:00:00
2 | 0B071500563 | QTS M Turret | 170 |  |  |  |  | Sat
1 | 0B071500563 | QTS M Turret | 170
2 | 0B071500563 | QTS M Turret | 170
1 | 0B071500563 | QTS M Turret | 170 |  |  |  |  | Mon
2 | 0B071500563 | QTS M Turret | 170
1 | 0B071500563 | QTS M Turret | 170
2 | 0B071500563 | QTS M Turret | 170 |  |  |  |  | [NAME]
1 | 0B071500563 | QTS M Turret | 170
2 | 0B071500563 | QTS M Turret | 170
1 | 0B071500563 | QTS M Turret | 170 |  |  |  |  | Wed
Spreadsheet: 101486d1299602674-trying-to-create-formula-to-return-movie-titles-depending-on-studio-and-release-month-movie-list
Sheet: Data

Title | Studio | Release | Budget |  | Quarter | Sequence | Code 1 | Code 2
Movie 1 | Paramount | March | 200 |  | Q1 | 1 | Paramount-Q1 | Q1-1-Paramount
Movie 2 | Universal | March | 13 |  | Q1 | 1 | Universal-Q1 | Q1-1-Universal
Movie 3 | Time Warner | April | 32 |  | Q2 | 1 | Time Warner-Q2 | Q2-1-Time Warner
Movie 4 | Paramount | Spring | 50 |  | Q2 | 1 | Paramount-Q2 | Q2-1-Paramount
Movie 5 | Time Warner | Q1 | 100 |  | Q1 | 1 | Time Warner-Q1 | Q1-1-Time Warner
Movie 6 | Paramount | November | 200 |  | Q4 | 1 | Paramount-Q4 | Q4-1-Paramount
Spreadsheet: 3a589514-6e11-416a-a4d1-e02c5634dab8
Sheet: Sheet1

High Expectations for New Teachers in Edgewood                                                         New Teacher Induction and Mentoring Program | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
FALL NEW TEACHER AND MENTOR SUPPORT LOG
Name of Mentor: | Name of New Teacher:
Dates of Support and Training | Topic | Date | Signature New Teacher | Signature Mentor
January  Meeting Week 2
January Meeting Week 3
January Meeting Week 4
February  Meeting Week 1
February Meeting Week 2
February  Meeting Week 3
February  Meeting Week 4
March Meeting Week 1
March  Meeting Week 3
March  Meeting Week 4
April Meeting Week 1
April Meeting Week 2
April Meeting Week 3
April Meeting Week 4
May Meeting Week 1
May Meeting Week 2
May Meeting Week 3
May Meeting Week 4
For Staff Development Office Only | THIS LOG IS DUE  TO THE STAFF DEVELOPMENT OFFICE                       May 24, 2013
Date Received:
Signature of Staff Development Coordinator:
Spreadsheet: 274987d1383302790-if-and-formula-usage-rates
Sheet: Sheet1

From | To | Standard rate | Enhanced rate |  | Usage Type | Actual Usage |  | Actual Cost
0 | 2400 | 0.33 | 0.45 |  | STD | 2200
2401 | 10000 | 0.45 | 0.45
10001 |  | 0.25 | 0.25
Spreadsheet: 196840d1354120908-spreadsheet-to-show-the-results-of-golf-competitions-golf-league-table-including-reults
Sheet: MIDLANDS

 |  | THE CROWN GOLF SOCIETY ANSTEY LEICESTER
 |  |  | RESULT WEST MIDLANDS G.C 2012
 | PLAYER | HANDICAP | POINTS SCORED | LEADERBOARD POINTS
1ST |  |  |  | 30
2ND |  |  |  | 29
3RD |  |  |  | 28
4TH |  |  |  | 27
5TH |  |  |  | 26
6TH |  |  |  | 25
7TH |  |  |  | 24
8TH |  |  |  | 23
9TH |  |  |  | 22
10TH |  |  |  | 21
11TH |  |  |  | 20
12TH |  |  |  | 19
13TH |  |  |  | 18
14TH |  |  |  | 17
15TH |  |  |  | 16
16TH |  |  |  | 15
17TH |  |  |  | 14
18TH |  |  |  | 13
19TH |  |  |  | 12
20TH |  |  |  | 11
21ST |  |  |  | 10
22ND |  |  |  | 9
23RD |  |  |  | 8
24TH |  |  |  | 7
25TH |  |  |  | 6
26TH |  |  |  | 5
27TH |  |  |  | 4
28TH |  |  |  | 3
29TH |  |  |  | 2
30TH |  |  |  | 1
31st |  |  |  | 0
32nd |  |  |  | 0
33rd |  |  |  | 0
34th |  |  |  | 0
35th |  |  |  | 0
36th |  |  |  | 0
37th |  |  |  | 0
38th |  |  |  | 0
39th |  |  |  | 0
40th |  |  |  | 0
41st |  |  |  | 0
42nd |  |  |  | 0
43rd |  |  |  | 0
44th |  |  |  | 0
45th |  |  |  | 0
46th |  |  |  | 0
47th |  |  |  | 0
48th |  |  |  | 0
49th |  |  |  | 0
50th |  |  |  | 0
 | LONGEST DRIVE |  |  | 30TH JUNE 2012
 | NEAREST PIN
Spreadsheet: 63121d1264078998-define-a-timerange-test
Sheet: Sheet1

 |  |  |  |  |  | ARRIVAL | DEPARTURE
Shift I |  |  |  |  |  | 05:30:00 | 20:45:00 |  | ARRIVAL - SHIFT I -> 05:00 - 12:59 |  |  |  | return as result SHIFT I
Between |  | Da |  |  |  | 16:00:00 | 11:34:00 |  | DEPARTURE - SHIFT I -> 15:00 - 21:00
Shift I |  |  |  |  |  | 08:02:34 | 17:05:00
Shift I |  |  |  |  |  | 05:40:00 | 15:58:00 |  | ARRIVAL - SHIFT II -> 13:00 - 16:00 |  |  |  | return as result Shift II
Shift II |  |  |  |  |  | 13:30:00 | 21:30:00 |  | DEPARTURE - SHIFT II -> <23:59
Shift II |  |  |  |  |  | 14:01:00 | 22:05:00
Shift III |  |  |  |  |  | 20:33:00 | 06:45:00 |  | [NAME] 19:00 - 23:00 |  |  |  | return as result SHIFT III
Shift II |  |  |  |  |  | 15:30:00 | 23:00:00 |  | [NAME] <=08:00
Shift I |  |  |  |  |  | 10:07:00 | 19:39:00
Shift I |  |  |  |  |  | 11:20:00 | 20:47:00 |  | ARRIVAL SHIFT I AND II -> 05:00 - 08:00 |  |  |  | return as result SHIFT I and II
Shift I |  |  |  |  |  | 07:22:36 | 16:55:17 |  | DEPARTURE SHIFT I AND II -> >=23:59
Shift I |  |  |  |  |  | 07:13:01 | 16:28:30
Shift I |  |  |  |  |  | 07:33:29 | 16:12:20
Shift I |  |  |  |  |  | 07:22:42 | 17:05:28 |  | The formula must check if $C$3 contains "da". If false, return blank.
Shift I |  |  |  |  |  | 06:52:17 | 16:42:10
Shift I |  |  |  |  |  | 07:13:09 | 16:24:42
Shift I |  |  |  |  |  | 07:22:38 | 16:35:05
Shift I |  |  |  |  |  | 07:00:05 | 16:58:53
Shift I |  |  |  |  |  | 06:50:05 | 16:55:30
Shift I |  |  |  |  |  | 07:04:46 | 16:34:06
Shift I |  |  |  |  |  | 07:15:14 | 16:55:19
Shift I |  |  |  |  |  | 07:10:43 | 17:05:30
Shift I |  |  |  |  |  | 07:41:08 | 16:49:59
Between |  |  |  |  |  | 07:16:24 | 10:11:41
Shift I |  |  |  |  |  | 07:28:43 | 16:49:30
Shift I |  |  |  |  |  | 07:55:54 | 16:44:00
Shift I |  |  |  |  |  | 08:06:34 | 16:59:36
Shift I |  |  |  |  |  | 07:15:41 | 16:51:33
Shift I |  |  |  |  |  | 05:49:31 | 17:03:36
Shift I |  |  |  |  |  | 07:01:01 | 16:52:27
Shift I |  |  |  |  |  | 07:03:25 | 16:56:50
Shift I |  |  |  |  |  | 07:30:28 | 16:52:24
Schimbul III |  |  |  |  |  | 21:39:00 | 05:55:00
Schimbul III |  |  |  |  |  | 22:08:00 | 06:10:00
Spreadsheet: 107809d1304967110-lookup-value-on-seperate-sheet-based-upon-cell-value-book1
Sheet: MATERIAL

.25 12560-1 | .312 12560-1 | .140 46177 | .156 46177 | .25 46100
R7726--1AE | R8208--3BF | A27136-- |  | M09396-07J2148-C24
[NAME] | R8208--3BD | A27136-- |  | M09401-07J2129-D24
[NAME] | R8208--3BC |  |  | M09396-07J2147-C24
R7726--1AB | R8208--3BA |  |  | R8005--2AA
R7726--1AA | R8208--4BF |  |  | R8005--2BI
R7729--39CG | R8208--4BG |  |  | R8005--2AC
[NAME] | R8208--4BC |  |  | R8005--2AB
[NAME] | R8208--4BA |  |  | R8005--2AE
R7729--39CE | R8208--4BB |  |  | R8005--2AD
R7729--39CD | R8208--3AD |  |  | R8005--2AG
R7729--2AG | R8208--3AC
R7729--39CB | R8208--3AB
R7729--39CA | R8208--2CF
R7726--1AI | R8208--2CG
R7726--1AH | R8208--3AA
R7726--1AG | R8208--2CE
R7726--1AF | R8208--2CD
R7726--1CB | R8208--2CC
[NAME] | R8208--2CB
R7726--1CD | R8208--2CA
[NAME] | R8208--3CF
[NAME] | R8208--3CE
[NAME] | R8208--3CD
[NAME] | R8208--3CC
R7726--1CI | R8208--1BE
[NAME] | R8208--1BB
[NAME] | R7735--39AE
[NAME] | R7735--39AF
R7729--2BE | R7735--39AG
R7726--2BH | R7735--3CF
[NAME] | R7735--3BG
R7726--2BA | R7735--3CC
[NAME] | R7735--3CD
[NAME] | R7735--3CG
[NAME] | R7735--3CA
 | R7735--3CE
 | R7735--3CB
 | R7735--1BE
 | R7735--1BF
 | R7735--1BG
 | R7735--4AC
 | R7735--4AB
 | R7735--4AF
 | R7735--4AE
 | R7735--2CC
 | R7735--2CA
 | R8208--1CA
 | R8208--4AA
 | R8208--4BE
 | 8187H-48268-
 | [NAME]
 | 8186H-48273-
 | 8186H-48273-
 | R0539- -1CE
 | R0539--1CF
 | 7631H-44700-
 | 7631H-44700-
 | 7631H-44699-
 | R8208--4BD
 | R8208--4AG
 | R8208--4AD
 | R7735--4AD
 | R7735--4AA
 | R7735--3AF
Spreadsheet: phillip_m_love__30138__200007_OA
Sheet: TX-HPLC-FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  [NAME]
 |  |  | NGP&L |  | CPR Adjustments |  | 3rd Day CPR |  | [NAME] |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron | 53659386 | 229178102
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 954974 | 3930102
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 54614360 | 233108204
 |  |  | 0 | 0
 | Purchases: |  | 0 | 0
6 |  | 3rd Party / Inter Enron | -58721475 | -250156859
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | -2453686 | -9828172
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 12460 | 53219
 | Total Purchases: |  | -61162701 | -259931812
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
11 |  | Sales | 83898347 | 347644559
12 |  | Purchases | -80573389 | -333941539
 | Total Intra CTS Sales / Purchases |  | 3324958 | 13703020
 |  |  | 0 | 0
 | Imbalances: |  | 0 | 0
13 |  | In Kind | 0 | 0
14 |  | Cash Out | 0 | 0
15 |  | Cash In | 0 | 0
16 |  | Synthetic Storage | 0 | 0
 | Total Imbalances: |  | 0 | 0
 |  |  | 0 | 0
 | Storage: |  | 0 | 0
17 |  | Injection (Sales to Stg) | 4188690 | 16387712
18 |  | W/D (Purchase from Stg) | -6063754 | -26513879
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | -6063754 | -26513879
 | Total Storage: |  | -1875064 | -10126167
 |  |  | 0 | 0
20 | Linepack: |  | 0 | 0
 |  |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
 |  |  | 0 | 0
22 | UA4: |  | 5098447 | 21730969.10107911
 |  |  | 0 | 0
23 | Fuel: |  | 0 | 0
 |  |  | 0 | 0
 | Transport Expense: |  | 0 | 0
24 |  | Commodity | 0 | -1710770
25 |  | Demand | 0 | 0
 | Total Transport Expense: |  | 0 | -1710770
 |  |  | 0 | 0
 | Transport Revenue: |  | 0 | 0
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | 0
 | Total Transport Revenue: |  | 0 | 0
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
28 |  | Transport Expense | 0 | 0
29 |  | Transport Revenue | 0 | 0
 | Total Intra CTS Transport |  | 0 | 0
 |  |  | 0 | 0
 | Tie Out Schedule Items: |  | 0 | 0
 |  | MTM Income: | 0 | 0
30 |  | Current Gross Book Balance | 0 | 0
31 |  | Prior Month Book Balance | 0 | 0
 |  | Total MTM Income | 0 | 0
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | 0
34 |  | Originations | 0 | 0
35 |  | Broker Fees | 0 | -155
36 |  | Asset Group Demand Charges | 0 | 0
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 0
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | 0
 |  | TOTAL INTRA-MTH
Spreadsheet: 744d264d-26f3-4bab-9a80-eed99ccca29c
Sheet: Change of Vehicle Details

 | CHANGE OF VEHICLE DETAILS FOR AIRSIDE ACCESS VEHICLE PERMIT |  |  |  |  |  |  |  | For Office Use Only
 |  |  |  |  |  |  |  |  | New Expiry Date:
 |  |  |  |  |  |  |  |  | Old [NAME]:
Name and Address of Employer / Company
 |  |  |  |  |  |  | Telephone No:
 |  |  |  |  |  |  | Mobile No:
 |  |  |  |  |  |  | 24 Hour Contact Telephone No:
Details of Current Vehicle: |  |  |  |  |  | Details of New/Replacement Vehicle
PERMIT NUMBER |  |  |  |  |  | PERMIT NUMBER
Fleet Number |  |  |  |  |  | Fleet Number
Registration Number |  |  |  |  |  | Registration Number
Vehicle Type |  |  |  |  |  | Vehicle Type
Make |  |  |  |  |  | Make
Model |  |  |  |  |  | Model
Colour |  |  |  |  |  | Colour
Weight & Height |  |  |  |  |  | Weight & Height
License Category Required |  |  |  |  |  | License Category Required
Call Sign |  |  |  |  |  | Call Sign
Fuel Type |  |  |  |  |  | Fuel Type
Year of Acquistion |  |  |  |  |  | Year of Acquistion
Permit Access                             (Ramp, Aeroclub or Ramp + Aeroclub) |  |  |  |  |  | Permit Access                                  (Ramp, Aeroclub or Ramp + Aeroclub)
* Applications for Fleet Vehicles may be attached to this application
Detailed reasons for requiring a change to vehicle details
 |  |  |  |  |  |  |  | YES | NO
 |  |  |  |  |  | New Vehicle
 |  |  |  |  |  | Insurance
 |  |  |  |  |  | Amber Rotating Beacon
 |  |  |  |  |  | Security KeyPad
 |  |  |  |  |  | Company Livery
 |  |  |  |  |  | Permanently Painted
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | Last NCT Certificate
Will you have a requirement to service aircraft within the manoeuvring area?
The Airside Vehicle Access Permit remains the property of Cork Airport and may be withdrawn on request.                                                                                The permit must be returned to the AMU Support Officer, AMU, Old Terminal, Cork Airport, Kinsale Road, Cork on completion of the contract or expiry of the permit.
 |  |  |  |  |  | Approval
Print Name: |  |  |  |  |  | Print Name:
 |  |  |  |  |  |  | (Line Manager)
Signature |  |  |  |  |  | Signature
 |  |  |  |  |  |  | (Line Manager)
Date: |  |  |  |  |  | Date:
Spreadsheet: 86043d1286011326-ignoring-blank-cells-in-a-chart-cash-deposits-and-orders-sample-4-
Sheet: 09-08-10

CASH ORDER
Denomination |  | 2010-09-08 00:00:00 | Area #1 | Area #2 | Area #3 | Area #4 | Area #5 | Area #6 | Total
100 |  | 917100 |  | 1369700
20 |  | 1662880 |  | 818600
10 |  | 7470 | 20680 | 0
5 |  | 398765 |  | 183065
1 |  | 111811 |  | 42231
0.25 |  | 8379 | 13382 | 0 |  | 5000 | 5000
0.05 |  | 5181 | 1388 | 0 |  | 2000 | 2000
0.01 |  | 1415 | 447 | 0
Total
Spreadsheet: 836291d1689239209-finding-cell-reference-for-a-max-value-excel-issue-v2
Sheet: Sheet1

Project | Category |  | Project | Subproject | cost | Category
1 | U |  | 1 | a | 3 | S
2 | S |  | 1 | b | 4 | T
3 | S |  | 1 | c | 6 | U
4 | S |  | 2 | a | 7 | S
5 | U |  | 2 | d | 2 | V
6 | V |  | 3 | a | 8 | S
 |  |  | 3 | e | 3 | W
 |  |  | 3 | d | 6 | V
 |  |  | 4 | a | 4 | S
 |  |  | 5 | b | 1 | T
 |  |  | 5 | c | 4 | U
 |  |  | 5 | e | 2 | W
 |  |  | 5 | f | 1 | X
 |  |  | 6 | d | 6 | V
Spreadsheet: 868245d1714991343-byrow-limitations-ranges-vs-arrays-byrow
Sheet: Sheet1

 |  |  |  | 2 | 3 | 4 | 5
 | 2
 | 3
 | 4
 | 5
 |  |  |  |  |  |  |  |  |  |  | Questions:
 | MAP 1 |  | MAP 2 |  | BYROW 1 |  | [NAME] |  | [NAME] |  | - Single Transpose: Why is MAP 2 working, but [NAME] not?
 |  |  |  |  |  |  |  |  |  |  | - Double Transpose: Why is BYROW 1 working, but [NAME] not?
 | 2, 3, 4, 5, 6 |  | 2, 3, 4, 5, 6 |  | 2, 3, 4, 5, 6 |  | 2 |  | 2
 | 3, 4, 5, 6, 7 |  | 3, 4, 5, 6, 7 |  | 3, 4, 5, 6, 7 |  | 3 |  | 3 |  | - Trying to incorporate the 'INDEX(i,1,1)' approach mentioned here by [NAME]
 | 4, 5, 6, 7, 8 |  | 4, 5, 6, 7, 8 |  | 4, 5, 6, 7, 8 |  | 4 |  | 4 |  | https://techcommunity.microsoft.com/t5/excel/another-issue-with-byrow/m-p/3777828
 | 5, 6, 7, 8, 9 |  | 5, 6, 7, 8, 9 |  | 5, 6, 7, 8, 9 |  | 5 |  | 5
 | works |  | works |  | works |  | fails |  | fails |  | Side illustration: INDEX(array,r,c) as employed in MAKEARRAY situations:
 |  |  |  |  |  |  |  |  |  |  |  | 2 | 3 | 4 | 5
 |  |  |  |  |  |  |  |  |  |  | 2 | 3 | 4 | 5 | 6
 | MAP 1 |  |  |  |  |  |  | works |  |  | 3 | 4 | 5 | 6 | 7
 | MAP 2 |  |  |  |  |  |  | works |  |  | 4 | 5 | 6 | 7 | 8
 | MAP 3 |  |  |  |  |  |  | works |  |  | 5 | 6 | 7 | 8 | 9
 | BYROW 1 |  |  |  |  |  |  | works
 | [NAME] |  |  |  |  |  |  | fails
 | [NAME] |  |  |  |  |  |  | fails
 | [NAME] |  |  |  |  |  |  | fails
 | (result unchanged) |  | (result unchanged) |  | (result unchanged) |  | [NAME] INDEX(I,1,1) |  | [NAME] INDEX(I,1,1) |  | [NAME] procedure employed to BYROW-problem
 |  |  |  |  |  |  | 2, 3, 4, 5, 6 |  | 2, 3, 4, 5, 6
 |  |  |  |  |  |  | 3, 4, 5, 6, 7 |  | 3, 4, 5, 6, 7
 |  |  |  |  |  |  | 4, 5, 6, 7, 8 |  | 4, 5, 6, 7, 8
 |  |  |  |  |  |  | 5, 6, 7, 8, 9 |  | 5, 6, 7, 8, 9
 |  | MAP 3 |  | [NAME]
 |  |  | works |  | fails
 |  | 2, 3, 4, 5, 6 |  | 2
 |  | 3, 4, 5, 6, 7 |  | 3
 |  | 4, 5, 6, 7, 8 |  | 4
 |  | 5, 6, 7, 8, 9 |  | 5