tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 876825d1723546598-add-two-columns-for-all-combinations-lamlam28-add-for-combinations-365-aligw
Sheet: V1

 | Raw Data |  |  |  | Step 1 |  |  |  | Step 2 |  |  |  |  |  |  |  |  |  |  |  | Step 3
 | Here we have two sets of raw data (Column B ,Column D)  in ascending order |  |  |  | We extract the raw data that fulfill these conditions: |  |  |  | We add up the numbers in Column F and H for all possible combinations |  |  |  |  |  |  |  |  |  |  |  | We match all possible combinations from step 2 against specific numbers.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | The formula in Column W returns the number if a match is found.
 |  |  |  |  | 1. Number < the maximum limit in the respective yellow cells
 |  |  |  |  | 2. Difference of (Succeeding Number - Number) >1
 |  |  |  |  | [NAME] for Column B |  | [NAME] for Column D
 |  |  |  |  | 30 |  | 50
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ???
 | 1 |  | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No. to match | Return if exist in result per step 2
 | 3 |  | 6 |  | 3
 | 5 |  | 7 |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11
 | 9 |  | 8 |  | 9 |  | 8 |  | 9 | 11 | 13 | 17 | 19 |  | 22 | 26 | 30 | 32 | 37 |  | 17
 | 11 |  | 10 |  | 11 |  | 10 |  | 11 | 13 | 15 | 19 | 21 |  | 24 | 28 | 32 | 34 | 39 |  | 23
 | 13 |  | 13 |  |  |  | 13 |  | 14 | 16 | 18 | 22 | 24 |  | 27 | 31 | 35 | 37 | 42 |  | 46
 | 14 |  | 17 |  | 14 |  | 17 |  | 18 | 20 | 22 | 26 | 28 |  | 31 | 35 | 39 | 41 | 46 |  | 54
 | 18 |  | 19 |  | 18 |  | 19 |  | 20 | 22 | 24 | 28 | 30 |  | 33 | 37 | 41 | 43 | 48 |  | 63
 | 22 |  | 21 |  | 22 |  | 21 |  | 22 | 24 | 26 | 30 | 32 |  | 35 | 39 | 43 | 45 | 50
 | 24 |  | 26 |  | 24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Final Result
 | 27 |  | 27 |  | 27 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Is it possible to do it in one single formula?
 | 32 |  | 28 |  |  |  | 28 |  | 29 | 31 | 33 | 37 | 39 |  | 42 | 46 | 50 | 52 | 57
 | 33 |  | 32
 | 45 |  | 33 |  |  |  | 33 |  | 34 | 36 | 38 | 42 | 44 |  | 47 | 51 | 55 | 57 | 62
 | 48 |  | 37 |  |  |  | 37 |  | 38 | 40 | 42 | 46 | 48 |  | 51 | 55 | 59 | 61 | 66
 | 55 |  | 41 |  |  |  | 41 |  | 42 | 44 | 46 | 50 | 52 |  | 55 | 59 | 63 | 65 | 70
 | 56 |  | 43
 | 57 |  | 44 |  |  |  | 44 |  | 45 | 47 | 49 | 53 | 55 |  | 58 | 62 | 66 | 68 | 73
 | 61 |  | 52
Spreadsheet: andy_zipper__593__11_20_01OH
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | HO Z1 | 54 | 350 | 450 | 58.7 | 75.5 | 2.28 | 2001-11-20 11:00:00
 | HO F2 | 55 | 780 | 880 | 56.9 | 64.2 | 2.09 | 2001-11-20 11:00:00
 | HO G2 | 55 | 1060 | 1160 | 56.1 | 61.4 | 2.03 | 2001-11-20 11:00:00
 | [NAME] | 55 | 1220 | 1320 | 54.7 | 59.2 | 1.97 | 2001-11-20 11:00:00
 | HO J2 | 54 | 1280 | 1380 | 51.7 | 55.7 | 1.82 | 2001-11-20 11:00:00
 | HO K2 | 54 | 1300 | 1450 | 47.1 | 52.6 | 1.69 | 2001-11-20 11:00:00
 | HO M2 | 54 | 1350 | 1500 | 44.7 | 49.7 | 1.6 | 2001-11-20 11:00:00
 | HO N2 | 55 | 1400 | 1550 | 42.6 | 47.2 | 1.55 | 2001-11-20 11:00:00
 | HO Q2 | 56 | 1400 | 1600 | 39.3 | 44.9 | 1.48 | 2001-11-20 11:00:00
 | HO U2 |  |  |  | 36.9 | 40.9 | 1.37 | 2001-11-16 14:52:00
 | [NAME] |  |  |  | 38.4 | 42.2 | 1.42 | 2001-11-15 14:53:00
 | HO X2 |  |  |  | 37.9 | 40.3 | 1.38 | 2001-11-15 14:53:00
 | [NAME] |  |  |  | 33.3 | 36.6 | 1.32 | 2001-11-07 14:56:00
 | HO F3
 | [NAME] |  |  |  |  |  | 0.72 | 2001-07-18 22:45:00
 | HO H3
Spreadsheet: 870786d1717226659-calculating-cummulative-interest-betwwwen-two-dates-sample-sheet
Sheet: Sheet1

 |  |  | [NAME] | 100000
 |  |  | Interest Rate | 0.07
 |  |  | Initial Date | 2023-09-12 00:00:00
 |  |  | Maturity Date
 |  |  | Deposit Tenure | 395 | days from Initial Date
 |  |  | Compounding of Interest | every 3 Months
 |  |  | Financial Year | April-March
 |  |  | Results Envisaged
 |  | 1 | Interest Eared till 31-3-24
 |  | 2 | Opening Balance as on 1-4-24
 |  | 3 | Interest earned in Financial Year 24-25
 |  |  | (between 1-4-24 till 11-10-2024)
Spreadsheet: 1bf3f4a9-fefc-4015-a72b-8a45642d74f2
Sheet: Mathematics

April 2012  BST Raw Score to Scale Score Tables
Mathematics
Raw Score | Scale Score | Raw Score | Scale Score
0 | 300 | 41 | 565
1 | 353 | 42 | 568
2 | 382 | 43 | 571
3 | 400 | 44 | 574
4 | 413 | 45 | 577
5 | 423 | 46 | 581
6 | 432 | 47 | 584
7 | 439 | 48 | 590
8 | 446 | 49 | 591
9 | 452 | 50 | 594
10 | 458 | 51 | 600
11 | 463 | 52 | 602
12 | 468 | 53 | 606
13 | 473 | 54 | 610
14 | 477 | 55 | 614
15 | 482 | 56 | 619
16 | 486 | 57 | 624
17 | 490 | 58 | 629
18 | 493 | 59 | 634
19 | 497 | 60 | 640
20 | 500 | 61 | 647
21 | 504 | 62 | 655
22 | 507 | 63 | 663
23 | 511 | 64 | 673
24 | 514 | 65 | 686
25 | 517 | 66 | 704
26 | 520 | 67 | 733
27 | 523 | 68 | 780
28 | 526
29 | 529
30 | 532
31 | 535
32 | 538
33 | 541
34 | 544
35 | 547
36 | 550
37 | 553
38 | 556
39 | 559
40 | 562
Spreadsheet: 160365d1339067114-excel-2007-text-boxes-and-pictures-will-not-print-tried-lots-of-things-to-no-avail-copy-of-recipe-sheet-v5
Sheet: DIY Kit

 | W  A  R  E  H  O  U  S  E      C  O  P  Y      O  N  L  Y
 | MATERIALS SHEET FOR DIY KITS |  |  |  |  |  |  | Leaving the Warehouse on | Date
 |  |  |  |  |  |  |  | Going by
 |  |  |  |  |  |  |  | Issued | By | Date
 | Job No |  |  |  |  | Customer
 | No. Of Kits |  | 12 |  |  | Site Details
 | Area
 | Depth
 | [NAME] |  | Single Pack
 | AGGREGATE PER BATCH
 | Size | Type |  | Supplier |  | Kg in mix | Cum. Total | Total Req'd
 |  |  |  | BATCH TOTAL |  | 12 | [NAME]
 | Two Pack Resin % (Job Target) |  |  |  |  | Single Pack Resin %
 |  |  | [NAME] | Total Req'd |  |  |  | [NAME] | Total Req'd
 |  | I |  |  |  | [NAME]
 |  | P
 |  | Total
 |  | [NAME]
 |  | Job No
 |  | Mix Code
 |  | No. Of Kits
 |  | BATCHING RECORD |  |  |  |  |  | BATCHING RECORD
 |  | Batch No. |  |  |  |  |  | Batch No.
 |  | No of Batches |  |  |  |  |  | No of Batches
 |  | Date |  |  |  |  |  | Date
 |  | Batched By |  |  |  |  |  | Batched By
 |  | [NAME] | 2 Pack / Single Pack |  |  |  |  | [NAME] | 2 Pack / Single Pack
 |  |  | R4 / I | P |  |  |  |  | R4 / I | P
 |  | Wt per Batch | g | g |  |  |  | Wt per Batch | g | g
 |  | [NAME] | 2  /  5  /  10  ltr | 2  /  5  /  10  ltr |  |  |  | [NAME] | 2  /  5  /  10  ltr | 2  /  5  /  10  ltr
 |  | Drum No |  |  |  |  |  | Drum No
 |  | Where both A & B in same tub? |  | Yes  /  No |  |  |  | Where both A & B in same tub? |  | Yes  /  No
 |  | Catalyst added? | Yes  (        ml)  /  No |  |  |  |  | Catalyst added? | Yes  (        ml)  /  No
 |  | BATCHING RECORD |  |  |  |  |  | BATCHING RECORD
 |  | Batch No. |  |  |  |  |  | Batch No.
 |  | No of Batches |  |  |  |  |  | No of Batches
 |  | Date |  |  |  |  |  | Date
 |  | Batched By |  |  |  |  |  | Batched By
 |  | [NAME] | 2 Pack / Single Pack |  |  |  |  | [NAME] | 2 Pack / Single Pack
 |  |  | R4 / I | P |  |  |  |  | R4 / I | P
 |  | Wt per Batch | g | g |  |  |  | Wt per Batch | g | g
 |  | [NAME] | 2  /  5  /  10  ltr | 2  /  5  /  10  ltr |  |  |  | [NAME] | 2  /  5  /  10  ltr | 2  /  5  /  10  ltr
 |  | Drum No |  |  |  |  |  | Drum No
 |  | Where both A & B in same tub? |  | Yes  /  No |  |  |  | Where both A & B in same tub? |  | Yes  /  No
 |  | Catalyst added? | Yes  (        ml)  /  No |  |  |  |  | Catalyst added? | Yes  (        ml)  /  No
Spreadsheet: 763711d1642342405-find-some-with-consecutive-days-log-book-new-for-excel-forum-1-
Sheet: LogBook

 |  |  |  |  |  |  |  |  |  |  | 3 | Consecutive days
 |  |  |  |  |  |  |  |  |  |  |  | Consecutive days Block No. | Block length | [NAME] | Offset Blocks | Result for block |  | MAX
183 | 2012-09-16 00:00:00 |  |  |  |  |  |  |  |  |  | 1.4
184 | 2012-09-17 00:00:00 |  |  |  |  |  |  |  |  |  | 0.5
185 | 2012-09-18 00:00:00 |  |  |  |  |  |  |  |  |  | 0.7
186 | 2012-09-19 00:00:00 |  |  |  |  |  |  |  |  |  | 5.2
187 | 2012-09-21 00:00:00 |  |  |  |  |  |  |  |  |  | 3.6
188 | 2012-09-23 00:00:00 |  |  |  |  |  |  |  |  |  | 4.2
189 | 2012-09-24 00:00:00 |  |  |  |  |  |  |  |  |  | 3.6
190 | 2012-09-25 00:00:00 |  |  |  |  |  |  |  |  |  | 4.8
191 | 2012-09-26 00:00:00 |  |  |  |  |  |  |  |  |  | 1.1
192 | 2012-09-29 00:00:00 |  |  |  |  |  |  |  |  |  | 1
193 | 2012-09-30 00:00:00 |  |  |  |  |  |  |  |  |  | 3.1
194 | 2012-10-01 00:00:00 |  |  |  |  |  |  |  |  |  | 0.7
195 | 2012-10-02 00:00:00 |  |  |  |  |  |  |  |  |  | 5.8
196 | 2012-10-03 00:00:00 |  |  |  |  |  |  |  |  |  | 2.2
197 | 2012-10-05 00:00:00 |  |  |  |  |  |  |  |  |  | 1.1
198 | 2012-10-06 00:00:00 |  |  |  |  |  |  |  |  |  | 10
199 | 2012-10-08 00:00:00 |  |  |  |  |  |  |  |  |  | 20
200 | 2012-10-09 00:00:00 |  |  |  |  |  |  |  |  |  | 30
201 | 2012-10-12 00:00:00 |  |  |  |  |  |  |  |  |  | 2.3
202 | 2012-10-14 00:00:00 |  |  |  |  |  |  |  |  |  | 1.2
Spreadsheet: 145875d1331790808-transfer-data-from-one-sheet-to-another-when-specific-value-entered-in-first-sheet-example_2012_file
Sheet: Feb

Reporter | Date Rec. | Date Comp. | Witness | Description | Pages Rec | Pages Rtn | Job Type | Rate | Total | Tithe Amount | Tithed | Invoice # | Invoice Date | Date Paid | Monthly Tithe | Tithed MTD | Left to Tithe | Total | Amount Received | Total By Reporter | Amount Due | Amount Received
Jeanne | 2012-02-01 00:00:00 | 2012-02-04 00:00:00 |  |  | 54 | 54 | Regular | 1.2 |  |  | X | 001-13 | 2012-02-08 00:00:00 | 2012-02-26 00:00:00 |  |  |  |  |  | Jeanne
[NAME] | 2012-02-02 00:00:00 | 2012-02-03 00:00:00 |  |  | 288 | 288 | Rush | 1 |  |  |  | 007-15 | 2012-02-08 00:00:00 | 2012-03-07 00:00:00 |  |  |  |  |  | [NAME]
Karisa | 2012-02-06 00:00:00 | 2012-02-10 00:00:00 |  |  | 224 | 224 | Regular | 0.85 |  |  |  | 006-14 | 2012-02-15 00:00:00 |  |  |  |  |  |  | Karisa
Jeanne | 2012-02-07 00:00:00 | 2012-02-08 00:00:00 |  |  | 55 | 55 | Regular | 1.2 |  |  | X | 001-13 | 2012-02-08 00:00:00 | 2012-02-26 00:00:00 |  |  |  |  |  | [NAME]
[NAME] | 2012-02-12 00:00:00 | 2012-02-13 00:00:00 |  |  | 58 | 58 | Regular | 0.85 |  |  |  | 010-01 | 2012-02-28 00:00:00 | X |  |  |  |  |  | [NAME]
Jeanne | 2012-02-13 00:00:00 | 2012-02-14 00:00:00 |  |  | 16 | 16 | Regular | 1.3 |  |  | X | 001-13 | 2012-02-18 00:00:00 | 2012-02-26 00:00:00
[NAME] | 2012-02-14 00:00:00 | 2012-02-15 00:00:00 |  |  | 150 | 150 | Rush | 1 |  |  | X |  |  | X
Jeanne | 2012-02-15 00:00:00 | 2012-02-16 00:00:00 |  |  | 41 | 41 | Rush | 2.2 |  |  | X | 001-13 | 2012-02-18 00:00:00 | 2012-02-26 00:00:00
Jeanne | 2012-02-20 00:00:00 | 2012-02-20 00:00:00 |  |  | 12 | 12 | Regular | 1.2 |  |  |  | 001-14 | 2012-03-06 00:00:00 | X
Jeanne | 2012-02-20 00:00:00 | 2012-02-27 00:00:00 |  |  | 61 | 61 | Regular | 1.2 |  |  |  | 001-14 | 2012-03-06 00:00:00 | X
[NAME] | 2012-02-20 00:00:00 | 2012-02-22 00:00:00 |  |  | 104 | 104 | Regular | 0.85 |  |  |  | 010-01 | 2012-02-28 00:00:00 | X
Jeanne | 2012-02-21 00:00:00 | 2012-02-23 00:00:00 |  |  | 13 | 13 | Rush | 1.3 |  |  |  | 001-14 | 2012-03-06 00:00:00 | X
Jeanne | 2012-02-21 00:00:00 | 2012-02-27 00:00:00 |  |  | 68 | 68 | Regular | 1.2 |  |  |  | 001-14 | 2012-03-06 00:00:00 | X
[NAME] | 2012-02-24 00:00:00 | 2012-02-27 00:00:00 |  |  | 28 | 28 | Regular | 0.85 |  |  |  | 010-01 | 2012-02-28 00:00:00 | X
Jeanne | 2012-02-26 00:00:00 | 2012-02-28 00:00:00 |  |  | 75 | 85 | Regular | 1.2 |  |  |  | 001-14 | 2012-03-06 00:00:00 | X
Spreadsheet: 788046d1658239840-sumifs-with-derived-criteria-sumifs_derived_criteria_example
Sheet: Sales

Sales Rep | Sale Amount | Sale Area |  | Rep | Region | Total Sales
[NAME] | 100 | Area 1 |  | [NAME] | North | 550
[NAME] | 300 | Area 2
Cath | 500 | Area 3
[NAME] | 700 | Area 4
[NAME] | 200 | Area 5
[NAME] | 400 | Area 6
Cath | 600 | Area 7
[NAME] | 800 | Area 1
[NAME] | 250 | Area 2
[NAME] | 350 | Area 3
Cath | 450 | Area 4
[NAME] | 550 | Area 5
[NAME] | 100 | Area 6
[NAME] | 300 | Area 7
Cath | 500 | Area 1
[NAME] | 700 | Area 2
[NAME] | 200 | Area 3
[NAME] | 400 | Area 4
Cath | 600 | Area 5
[NAME] | 800 | Area 6
[NAME] | 250 | Area 7
[NAME] | 350 | Area 1
Cath | 450 | Area 2
[NAME] | 550 | Area 3
[NAME] | 100 | Area 4
[NAME] | 300 | Area 5
Cath | 500 | Area 6
[NAME] | 700 | Area 7
[NAME] | 200 | Area 1
[NAME] | 400 | Area 2
Cath | 600 | Area 3
[NAME] | 800 | Area 4
[NAME] | 250 | Area 5
[NAME] | 350 | Area 6
Cath | 450 | Area 7
[NAME] | 550 | Area 8
Spreadsheet: john_griffith__16222__2_1_02OH
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | [NAME] | 52 | 500 | 580 | 47.1 | 54.7 | 1.66 | 2002-02-01 10:29:00
 | HO J2 | 53 | 725 | 825 | 45.7 | 52 | 1.63 | 2002-02-01 10:29:00
 | HO K2 | 53 | 875 | 975 | 43.8 | 48.9 | 1.54 | 2002-02-01 10:29:00
 | HO M2 | 53 | 1000 | 1100 | 42.6 | 46.9 | 1.49 | 2002-02-01 10:29:00
 | HO N2 | 54 | 1075 | 1175 | 40.5 | 44.2 | 1.44 | 2002-02-01 10:29:00
 | HO Q2 | 55 | 1150 | 1250 | 38.7 | 42.1 | 1.4 | 2002-02-01 10:29:00
 | HO U2 | 56 | 1240 | 1340 | 37.9 | 40.9 | 1.39 | 2002-02-01 10:29:00
 | [NAME] | 57 | 1300 | 1400 | 36.6 | 39.5 | 1.36 | 2002-02-01 10:29:00
 | HO X2 | 57 | 1350 | 1475 | 35.8 | 39.1 | 1.34 | 2002-02-01 10:29:00
 | [NAME] | 58 | 1375 | 1525 | 34.3 | 38 | 1.32 | 2002-02-01 10:29:00
 | HO F3 | 59 | 1400 | 1550 | 32.8 | 36.4 | 1.28 | 2002-02-01 10:29:00
 | [NAME] |  |  |  | 32.8 | 35.2 | 1.26 | 2002-01-31 15:07:00
 | HO H3 |  |  |  | 32.5 | 35.9 | 1.27 | 2002-01-31 15:07:00
 | HO J3
 | [NAME] |  |  |  |  |  | 0.72 | 2001-07-18 22:45:00
 | HO M3
Spreadsheet: 839391d1691924552-neatest-value-demo
Sheet: Sheet1

Salary Structure:  [NAME]
Month/Year:  Aug/2023
SLNO | EMP ID. | Name | DA | HRA | CONVEYANCE | LUNCH | OTHERS | UNIFORM | BASIC. | RES CH PAY | Remarks | Search
1 | AV00001 | Muruganandam D
Spreadsheet: 865616d1712662682-how-to-automatically-match-cell-info-from-one-sheet-to-another-if-it-matches-a-cell-in-she-complete-list-mt
Sheet: Sheet1

Client Names
Summer Winds | manually input client name into A3 |  | When client name manually input into sheet1 A3 it needs to match that name in all clients incl contacts from D4:D203
Vehicle Details | Make & Model | Vehicle Reg | MOT | Service
OCC Approved  Drivers
Drivers Name | Driving Licence | [NAME] | Endorsements | [NAME]
Test 1       from AG4:AG203 ( AG4)  on all clients incl contacts tab if  sheet1A3 matches name in D4:D203 | 12345dcvt3    from Ah4:Ah203 ( Ah4)  on all clients incl contacts tab if  sheet1A3 matches name in D4:D203 | 08/04/2024    from Ai4:Ai203 ( Ai4)  on all clients incl contacts tab if  sheet1A3 matches name in D4:D203 | zero  from Aj4:Aj203 ( Aj4)  on all clients incl contacts tab if  sheet1A3 matches name in D4:D203 | 01/01/2027    from Ak4:Ak203 ( Ak4)  on all clients incl contacts tab if  sheet1A3 matches name in D4:D203
Flowers    from AL4:AL203 ( AL4)  on all clients incl contacts tab if  sheet1A3 matches name in D4:D203 | daffodil   from AM4:[NAME] ( AM4)  on all clients incl contacts tab if  sheet1A3 matches name in D4:D203 | 03/03/2024 from AN4:AN203 ( AN4)  on all clients incl contacts tab if  sheet1A3 matches name in D4:D203 | Zero from AO4:AO203 ( AO4)  on all clients incl contacts tab if  sheet1A3 matches name in D4:D203 | 16/07/2029 from AP4:AP203 ( AP4)  on all clients incl contacts tab if  sheet1A3 matches name in D4:D203
Spreadsheet: 72719d1273450966-how-to-automate-a-formula-on-a-table-payments
Sheet: Sheet1

Date | Amount | Description | Ref | Days until paid
2010-03-03 00:00:00 | 2000 | INV 1 | 5012 | 40
2010-03-14 00:00:00 | 1000 | INV 2 | 5012 | 29
2010-04-12 00:00:00 | -3000 | PAY 1 | 5012
2010-02-01 00:00:00 | 5000 | INV3 | 5013 | 71
2010-02-26 00:00:00 | 6000 | INV4 | 5013 | 46
2010-03-13 00:00:00 | 4000 | INV5 | 5013 | 31
2010-04-13 00:00:00 | -15000 | PAY 2 | 5013
Spreadsheet: 766184d1643793547-bar-graph-how-man-people-have-voted-for-10-9-8-7-etc-on-a-10-point-likert-scale-workbook
Sheet: Sheet1

ID | [NAME] | Fertigstellungszeit | E-Mail | Teamwork is important to me
1 | 2022-02-01 09:46:44 | 2022-02-01 09:51:37 | anonymous | 8
2 | 2022-02-01 09:51:41 | 2022-02-01 09:56:30 | anonymous | 10
3 | 2022-02-01 09:56:45 | 2022-02-01 09:59:49 | anonymous | 8
4 | 2022-02-01 11:00:47 | 2022-02-01 11:04:09 | anonymous | 9
 |  |  |  | 6
 |  |  |  | 7
 |  |  |  | 7
 |  |  |  | 8
 |  |  |  | 9
 |  |  |  | 10
 |  |  |  | 10
 |  |  |  | 10
 |  |  |  | 9
 |  |  |  | 9
 |  |  |  | 9
 |  |  |  | 9
 |  |  |  | 9
 |  |  |  | 9
 |  |  |  | 9
 |  |  |  | 10
 |  |  |  | 2
 |  |  |  | 10
 |  |  |  | 10
 |  |  |  | 10
 |  |  |  | 7
 |  |  |  | 8
 |  |  |  | 9
 |  |  |  | 10
 |  |  |  | 10
 |  |  |  | 9
 |  |  |  | 9
 |  |  |  | 8
 |  |  |  | 10
Spreadsheet: 682796d1592334360-hyperlink-to-select-correct-cell-reference-in-pivot-table-data-dynamically-hyperlink
Sheet: Total Applications

S.No | ID | Final Status | JR Open Date | Column3
1 | ID101 | Hold
2 | ID102 | Pending
3 | ID101 | Pending
4 | ID103 | Fail
5 | ID103 | Fail
6 | ID104 | Fail
7 | ID103 | Fail
8 | ID106 | Hold
9 | ID106 | Pending
10 | ID104 | Hold
11 | ID102 | Pending
12 | ID101 | Waiting
13 | ID112 | Pass
14 | ID103 | Fail
15 | ID103 | Fail
16 | ID112 | Fail
17 | [NAME] | Hold
18 | ID108 | Hold
19 | ID109 | Hold
20 | ID101 | Waiting
21 | ID102 | Fail
22 | ID101 | Pass
23 | ID103 | Fail
24 | ID103 | Fail
25 | ID104 | Fail
26 | ID103 | Fail
27 | ID106 | Fail
28 | ID106 | Waiting
29 | ID104 | Hold
30 | ID102 | Fail
31 | ID101 | Hold
32 | ID112 | Fail
33 | ID103 | Fail
34 | ID103 | Fail
35 | ID112 | Fail
36 | [NAME] | Fail
37 | ID108 | Pending
38 | ID109 | Pending
39 | ID101 | Fail
40 | ID102 | Pass
41 | ID101 | Fail
42 | ID103 | Fail
43 | ID103 | Fail
44 | ID104 | Fail
45 | ID103 | Fail
46 | ID106 | Waiting
47 | ID106 | Hold
48 | ID104 | Hold
49 | ID102 | Fail
50 | ID101 | Hold
51 | ID112 | Fail
52 | ID103 | Fail
53 | ID103 | Fail
54 | ID112 | Fail
55 | [NAME] | Fail
56 | ID108 | Fail
57 | ID109 | Fail
58 | ID101 | Fail
59 | ID102 | Fail
60 | ID101 | Fail
61 | ID103 | Fail
62 | ID103 | Pass
63 | ID104 | Hold
64 | ID103 | Pass
65 | ID106 | Fail
66 | ID106 | Pending
67 | ID104 | Hold
68 | ID102 | Fail
69 | ID101 | Hold
70 | ID112 | Fail
71 | ID103 | Hold
72 | ID103 | Pass
73 | ID112 | Pass
74 | [NAME] | Fail
75 | ID108 | Fail
76 | ID109 | Fail
77 | ID103 | Pass
78 | ID106 | Pending
79 | ID106 | Pending
80 | ID104 | Waiting
81 | ID102 | Pass
82 | ID101 | Fail
83 | ID112 | Pass
84 | ID103 | Pass
85 | ID103 | Waiting
86 | ID112 | Hold
87 | [NAME] | Hold
88 | ID108 | Fail
89 | ID109 | Waiting
90 | ID103 | Pass
91 | ID112 | Fail
92 | [NAME] | Pass
93 | ID108 | Fail
94 | ID109 | Waiting
95 | ID109 | Waiting
Spreadsheet: 0453a7b1-70f2-41f6-bb59-e78a58270c3e
Sheet: Failure-to-Activate

Reserve Asset Detail Report |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Reserve Asset Detail Report
SD_RSVASTDTL_<customer id>_<settlement_date>_<version>.CSV |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SD_RSVASTDTL_<customer id>_<settlement_date>_<version>.CSV
<[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <[NAME]
Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:[NAME]:ss> GMT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:[NAME]:ss> GMT
 |  |  | Asset |  |  |  | Ten-Minute Non-Spin Reserve |  |  |  |  |  |  |  |  | Thirty-Minute Operating Reserve
Trading Interval | Reserve Zone ID | Reserve Zone Name | Asset ID | Asset Name | Asset Type | Ownership Share | Asset Total TMNSR Delivered MWs | Forward Reserve TMNSR Contingency Target MW | Forward Reserve TMNSR Contingency Activated MW | Forward Reserve TMNSR Failure-to-Activate Flag | Forward Reserve TMNSR Failure-to-Activate MW | Forward Reserve TMNSR Payment Rate | Forward Reserve TMNSR Failure-to-Activate Penalty Rate | Forward Reserve TMNSR Failure-to-Activate Penalty | Participant Share Forward Reserve TMNSR Failure-to-Activate Penalty | Asset Total TMOR Delivered MWs | Forward Reserve TMOR Contingency Target MW | Forward Reserve TMOR Contingency Activated MW | Forward Reserve TMOR Failure-to-Activate Flag | Forward Reserve TMOR Failure-to-Activate MW | Forward Reserve TMOR Payment Rate | Forward Reserve TMOR Failure-to-Activate Penalty Rate | Forward Reserve TMOR Failure-to-Activate Penalty | Participant Share Forward Reserve TMOR Failure-to-Activate Penalty
Hour End | Number | String | Number | String | String | % | MWh | MWh | MWh | Flag | MWh | $/MWh | $/MWh | $ | $ | MWh | MWh | MWh | Flag | MWh | $/MWh | $/MWh | $ | $
Spreadsheet: 277547d5-6f15-457d-8283-1433dc03783f
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18
Southern Cross University
Card Printing Supply order form
* Must be completed
*GL code to be used for internal transfer
*GL Code For shipping
Please indicate supplies needed
Cards |  |  |  |  |  |  |  |  | Price (+gst) |  |  |  |  | Quantity
Mifare ISO-30 non-encoded cards, (500) |  |  |  |  |  |  |  |  | 1059.15 |  |  |  |  | 0 |  |  |  | 0
Mifare ISO-30 pre-encoded cards, (500) |  |  |  |  |  |  |  |  | 1369.5 |  |  |  |  | 0 |  |  |  | 0
Plastic ISO-30 cards, (500) |  |  |  |  |  |  |  |  | 335.5 |  |  |  |  | 0 |  |  |  | 0
[NAME] ISO-30 pre-encoded (500) |  |  |  |  |  |  |  |  | 350 |  |  |  |  |  |  | 0 |  | 0
(see over for card information) |  |  |  |  |  |  |  |  |  |  |  |  |  | Sub Total |  |  |  | 0
Printer Ribbons
FARGO HDP5000 Ribbons
HDP5000 [NAME], (500 images) |  |  |  |  |  |  |  |  | 249.7 |  |  |  |  | 0 |  |  |  | 0
[NAME], (1500 cards) |  |  |  |  |  |  |  |  | 166.1 |  |  |  |  | 0 |  |  |  | 0
FARGO DTC550
DTC550 [NAME], (500 cards) |  |  |  |  |  |  |  |  | 363 |  |  |  |  | 0 |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Sub Total |  |  |  | 0
Purchased on PO:
 |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL |  |  |  | 0
Person Authorising Internal Transfer
*Name:
*Contact Number:
*Email:
*Department:
*Date: |  |  |  |  | / |  |  | /
Delivery Address:
Please forward to the Campus Services Supervisor
I confirm that I am authorised to approve the internal transfer that will be created for the above supplies and freight for the amount shown on the GL code(s) listed.
*Signature:………………………………………………………………………………………………………………..………….
Mifare ISO-30 non-encoded cards
These cards contain chips that are ready to be encoded with the card number. You would select "print & encode" in the printing process. Only the HDP 5000 printers can use these cards.
Mifare ISO-30 pre-encoded cards
These cards contain chips that have already been encoded with a card number. With these cards you must enter the card number into the cardholders card information at the time of printing. A list of card numbers must be produced and maintained with each card number being crossed off as its used. Typically used by the DTC550 Printers although the HDP5000 printers can use them if the card number is manually inserted into the cardholders details and "print" is selcted instead of "print & encode".
Plastic ISO-30 cards
These cards do not contain chips, cannot be encoded, cannot be used for access control, and are typically used for offshore students. Both printer types can use these cards with the "print" (only) feature.
Supply Pricing
Supply prices directly reflect the buy price. Prices may change and for this reason this form should always be downloaded from the Facilities website to ensure correct prices are listed and avoid delays. The purchase order number will be listed on the updated form should confirmation be required.
Spreadsheet: list-files-in-a-folder
Sheet: Sheet1

 | ExcelExperts.com
 | VBA Tips - List Files In A Folder
 | Folder | c:\Test Folder\
 | Include Subfolders | 1
 | File Path | File Name | File Size | Last Modified
 | C:\Test Folder\0027.bmp | 0027.bmp | 49206 | 2009-04-16 16:09:02
 | C:\Test Folder\0028.bmp | 0028.bmp | 49206 | 2009-04-16 16:09:04
 | C:\Test Folder\0029.bmp | 0029.bmp | 49206 | 2009-04-16 16:09:05
 | C:\Test Folder\0030.bmp | 0030.bmp | 49206 | 2009-04-16 16:09:06
 | [NAME] | 0027.bmp | 49206 | 2009-04-16 16:09:02
 | [NAME] | 0028.bmp | 49206 | 2009-04-16 16:09:04
 | C:\Test Folder\NewFolder\TextFile.TXT | TextFile.TXT | 60 | 2009-05-13 10:14:07