tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 720021d1613983642-can-we-create-a-formula-to-extract-time-from-a-timesheet-and-populate-it-diff-columns-sample-timesheets
Sheet: Sheet1

 |  |  | Start time | Finish time | Total hrs | 6am-10pm | 10pm-midnight | 12pm-6am
 |  | 2019-06-27 00:00:00 | 10:30:00 | 15:00:00 | 04:30:00 | 4.5
 |  | 2019-06-29 00:00:00 | 16:05:00 | 00:50:00 | 08:45:00 | 5.92 | 2 | 0.83
 |  | 2019-06-30 00:00:00 | 11:00:00 | 17:45:00 | 06:45:00 | 6.75
 |  | 2019-07-01 00:00:00 | 13:35:00 | 22:10:00 | 08:35:00 | 8.42 | 2 | 0.17
 |  | 2019-07-04 00:00:00 | 15:20:00 | 00:05:00 | 08:45:00
 |  | 2019-07-05 00:00:00 | 14:00:00 | 22:35:00 | 08:35:00
 |  | 2019-07-06 00:00:00 | 15:20:00 | 23:45:00 | 08:25:00
 |  | 2019-07-07 00:00:00 | 11:00:00 | 17:15:00 | 06:15:00
 |  | 2019-07-08 00:00:00 | 14:10:00 | 21:35:00 | 07:25:00
 |  | 2019-07-11 00:00:00 | 14:05:00 | 00:30:00 | 10:25:00
Spreadsheet: 876362d1723042688-sort-by-letter-grade-sample-v2
Sheet: Sheet1

City | Sales | Grade
Paris | 1.2 | B
NY | 5 | A+
Berlin | 4.5 | A
Hong Kong | 0.5 | C
LA | 3 | A-
Toronto | 0.7 | B-
Spreadsheet: 3547be10-7b5a-4b2f-a4ee-f6ceb7ef7fec
Sheet: Sheet1

Table S6. Primers | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Gene | TAIR ID | Primer Name | Primer Type | Primer Sequence
PIE1-6 | AT3G12810 | PIE1-F | PCR | TTGAGGAGCTGCTCAGACGTTATACCTCT
 |  | PIE1-R | PCR | TCTCTGGCATTTGATGAAATGACTGACCT
 |  | SALK-TDNA-LB1 | PCR | TGGTTCACGTAGTGGGCCATCG
HTA8 | AT2G38810 | HTA8-F | PCR | TCCAGAGAGGATGATGATGAAACTGAA
 |  | HTA8-R | PCR | TCCAGATCCGTCGTCGAAATCA
 |  | FLAG-TDNA-LB1 | PCR | CGTGTGCCAGGTGCCCACGGAATAGT
HTA11 | AT3G54560 | HTA11-F | PCR | TTGTTTGACTGTGTACGGTTAGATCTAGA
 |  | HTA11-R | PCR | CAGAACATTGCACATACTAGAACCAAACA
 |  | SALK-TDNA-LB1 | PCR | TGGTTCACGTAGTGGGCCATCG
HTA9 | AT1G52740 | HTA9-F | PCR | TAACACAAAGTACGCTGATCGAACGAACA
 |  | HTA9-R | PCR | GATCGCGTTTAAGTGGTAGATCGATGAGA
 |  | SALK-TDNA-LB1 | PCR | TGGTTCACGTAGTGGGCCATCG
HTA4 | AT4G13570 | [NAME] | PCR | TTGAAAATGTTCGGATGATTATGGTGGAGG
 |  | HTA4-R | PCR | ATAATTGTTCCTTTGATGAGTGTGTCAAGC
 |  | SALK-TDNA-LB1 | PCR | TGGTTCACGTAGTGGGCCATCG
IBM1-6 | [NAME] | IBM1-F | PCR | TAGTTTTGATATCTGCCTTAGCTGTTGCC
 |  | IBM1-R | PCR | CTTTTACCCAATGGTGCTGAAAATGCTTC
 |  | SALK-TDNA-LB1 | PCR | TGGTTCACGTAGTGGGCCATCG
[NAME]-6 | AT5G49160 | [NAME] | PCR | TGTGACTGAGAACCGCTGTCAGGATCGTTTAAAGAGATC
 |  | [NAME]-R | PCR | CGTACTATAAGACCTCCGAAG
HTA8 | AT2G38810 | HTA8-RT-F | RT-PCR | GCTGGTAAAGGTGGGAAAGGGCTTCTAGC
 |  | HTA8-RT-R | RT-PCR | TCAGCAGTCAAGTATTCTAGAATTGATGAAGCGTAAACAG
HTA11 | AT3G54560 | [NAME] | RT-PCR | TCGTTCCCTTGATGAGTGTGTCCAGC
 |  | [NAME] | RT-PCR | GACTCGTAGCTGCGAAGACGATGGCTGC
HTA9 | AT1G52740 | HTA9-RT-F | RT-PCR | ACCCAGCGGTAGCGACAAGGATAAGGAC
 |  | HTA9-RT-R | RT-PCR | TTGTGCGATCTCCTTTCTCTTTCAATCTC
HTA4 | AT4G13570 | HTA4-RT-F | RT-PCR | TTGAAAATGTTCGGATGATTATGGTGGAGG
 |  | HTA4-RT-R | RT-PCR | ATAATTGTTCCTTTGATGAGTGTGTCAAGC
EF1alpha | [NAME] | EF1-RT-F | RT-PCR | TCGAGACCACCAAGTACTACTGC
 |  | EF1-RT-R | RT-PCR | ATCATACCAGTCTCAACACGTCC
HTA9 | AT1G52740 | HTA9-Q-F | QPCR | AGCGGTAGCGACAAGGATAAG
 |  | HTA9-Q-R | QPCR | TGGTAGGGTGCATCGTCTGT
UBQ5 | AT3G62250 | UBQ-Q-F | QPCR | TTCTGGTAAACGTAGGTGACTCC
 |  | UBQ-Q-R | QPCR | GAAGACTTACCAAGCCGAAG
Spreadsheet: 707328d1607181400-some-sort-of-if-roundup-formula-required-book1-4-
Sheet: Sheet1

0.14 | 0.48 | 0 | 0
0.03 | 0.14 | 0.24 | 0.35
0.08 | 0.29 | 0.37 | 0.55
0.04 | 0.19 | 0.4 | 0.51
0.02 | 0.13 | 0.36 | 0.45
0.06 | 0.22 | 0.23 | 0.4
0.04 | 0.17 | 0.27 | 0.4
0.05 | 0.22 | 0.42 | 0.55
0.08 | 0.31 | 0.38 | 0.58
0.08 | 0.29 | 0.37 | 0.55
0.13 | 0.47 | 0 | 0
0.07 | 0.28 | 0 | 0
0.03 | 0.12 | 0.21 | 0.31
0.02 | 0.14 | 0.37 | 0.46
0.04 | 0.18 | 0.32 | 0.44
0.05 | 0.19 | 0.29 | 0.42
0.05 | 0.19 | 0.3 | 0.44
0.01 | 0.06 | 0.25 | 0.3
0.03 | 0.12 | 0.2 | 0.29
0.09 | 0.32 | 0 | 0
0.07 | 0.26 | 0.33 | 0.51
0.02 | 0.09 | 0.18 | 0.25
0.04 | 0.21 | 0.46 | 0.58
0.03 | 0.13 | 0.23 | 0.33
0.01 | 0.04 | 0.19 | 0.22
0.07 | 0.27 | 0 | 0
Spreadsheet: 81517d1281653864-excel-2007-combining-statistical-data-from-one-sheet-to-another-sts
Sheet: Sheet1

 | GP | W | L | OTL | SO | GAA | SV% | SHTS | SVS | MIN
Storm
Roof
Silver
Purple
Spreadsheet: 733659d1621691879-but-i-need-two-parameters-instead-of-one-als-fout-index-i-i-aggregaat-test2-5-
Sheet: vlist (2)

Verschil alles | prijs nl | prijs d | [NAME] <50 | km NL 50-100 | [NAME]500 | [NAME]50 | km d 50-100 | km d 100-500 | km d >500 | Wacht | project | Vertrek | Aankomst | begeleider | besteld | weg | wacht | uren | km | land | verkoop | Wacht2 | inkoop | [NAME] | Wacht3
 | 42.5 | 1.15 | 150 | 2.8 | 1.8 | 300 | 4.5 | 1.65 | 1.3 | 45 | 5120 | darp | oldenzaal | hilco | 20:00:00 | 20:14:00 |  | 4 | 100 | nl
 |  |  |  |  |  |  |  |  |  |  | 5120 | darp | oldenzaal | kees | 20:00:00 | 20:00:00 |  | 3.5 | 85 | nl
[NAME] | als J=nl;I:I | als J=nl; K:K | als J=d;I:I | als J=d:K:K | wacht |  |  |  |  |  | 5120 | oldenzaal | loheide | nl |  |  |  |  | 281 | d
5140 |  |  |  |  |  |  |  |  |  |  | 5120 | oldenzal | loheide | nl |  |  |  |  | 279 | d
5141 |  |  |  |  |  |  |  |  |  |  | 5135 | loheide | darp | nl |  |  |  |  | 283 | d
Totaal |  |  |  |  |  |  |  |  |  |  | 5135 | loheide | darp | nl |  |  |  |  | 276 | d
 |  |  |  |  |  |  |  |  |  |  | 5140 | darp | t Haarde | roland | 11:00:00 | 11:20:00 |  | 3.25 | 56 | nl
 |  |  |  |  |  |  |  |  |  |  | 5141 | oirschot | zoutkamp | roland |  |  |  | 6.75 | 140 | nl
Spreadsheet: 0268e56d-5d3b-4893-8a66-beaa9a99bb88
Sheet: SONET RING - Missouri

Vendor Information
 | AT&T |  |  | Address: 12851 [NAME], St. Louis, MO 63131 |  |  | Contact Name: [NAME] |  | GSA Region 6 LSA         Solicitation # 6QTC-11-SH-001
Phone number:         [PHONE] |  |  | Fax number:  NA |  |  |  | Email: [EMAIL]
CLIN | Services Offered | Geographic Area Served | MINUS 10%   Month To Month | Month To Month | One-Time Installation Price | MINUS 10% One-Time Installation Price | Service Pricing Notes |  | Tariff
 | Dedicated Sonet Ring Service
 | Dedicated Sonet Ring OC3
002L-PN | [NAME] [NAME] (USOC-FP5CX) | Missouri | 1415 |  | ICB | ICB | Per node
002L-CON | OC3 Central Office [NAME] (USOC-FC5CX) | Missouri | 800 |  | ICB | ICB | Per node
002L-DS1-N | DS1 at OC3 Node (USOC-SPRAX) | Missouri | 45 |  | N/C | N/C | Per port
002L-DS3-N | DS3 at OC3 Node (USOC-SPRBX) | Missouri | 110 |  | N/C | N/C | Per port
002L-MI | MILEAGE 1YAZX | Missouri | 220 |  | N/C | N/C | Per mile
 | Dedicated Sonet Ring OC12
002M-PN | OC12 Customer [NAME] (USOC-FPDCX) | Missouri | 2200 |  | ICB | ICB | Per node
002M-CON | OC12 Central Office [NAME] (USOC-FC5DX) | Missouri | 1850 |  | ICB | ICB | Per node
002M-DS3-N | DS3 at OC12 [NAME] (USOC-SPRCX) | Missouri | 110 |  | N/C | N/C | Per port
002M-0C3 | [NAME]  at OC12 [NAME] (USOC-SPREX) | Missouri | 135 |  | N/C | N/C | Per port
002M-DS1-N | DS1 at OC12 [NAME] (USOC-SPRGX) | Missouri | 45 |  | N/C | N/C | Per port
002M-MI | Mileage (USOC-1YAZX) | Missouri | 220 |  | N/C | N/C | Per mile
 | Dedicated Sonet Ring OC48
002N-PN | OC48 Customer [NAME] (USOC-FPDEX) | Missouri | 4725 |  | ICB | ICB | Per node
002N-CON | OC48 Central Office [NAME] (USOC-FC5EX) | Missouri | 4190 |  | ICB | ICB | Per node
002N-0C12-N | OC12 at OC48 [NAME] (USOC-SPRHX) | Missouri | 360 |  | N/C | N/C | Per port
002N-0C3-N | [NAME]  at OC48 [NAME] (USOC-SPRJX) | Missouri | 135 |  | N/C | N/C | Per port
002N-DS3-N | DS3 at OC48 [NAME] (USOC-SPRKX) | Missouri | 110 |  | N/C | N/C | Per port
002N-DS1-N | DS1 at OC48 [NAME] (USOC-SPRLX) | Missouri | 45 |  | N/C | N/C | Per port
002N-MI | Mileage 1YAZX | Missouri | 220 |  | N/C | N/C | Per mile
002N-OP/EL-AD | Optical to Electrical add/drop mux (USOC-MXJDX) | Missouri | 550 |  | N/C | N/C | Per port
Note 1:
Spreadsheet: a55a2928-f9ce-4454-8cf6-7724b326dc1a
Sheet: Sheet1

Attorney General - REP (North Dakota) | Unnamed: 1 | Unnamed: 2
Downloaded at 5/24/2013 6:07:09 PM
Precincts Reporting: 604/604 - Total Ballots Cast: 92213
2004 Primary Election - OFFICIAL RESULTS
Precinct | [NAME] | TOTALS
Precinct 2301 | 89 | 89
Precinct 2302 | 15 | 15
Precinct 2304 | 18 | 18
Precinct 2903 | 8 | 8
TOTAL | 130 | 130
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 191950d1352260399-need-help-with-excel-sheet-to-input-data-into-another-sheet-for-fantasy-football-league-testing
Sheet: Team 5

POS | OVERALL | PRICE |  |  | POS | OVERALL | PRICE |  |  | POS | OVERALL | PRICE
QB--1 |  |  | TEAM: TEST |  | LE--1 |  |  |  |  | K--1
QB--2 |  |  |  |  | LE--2 |  |  |  |  | [NAME]
QB--3 |  |  |  |  | LE--3 |  |  |  |  | P--1
HB--1 |  |  |  |  | RE--1 |  |  |  |  | P--2
HB--2 |  |  |  |  | RE--2
HB--3 |  |  |  |  | RE--3
FB--1 |  |  |  |  | DT--1
FB--2 |  |  |  |  | DT--2
WR--1 |  |  |  |  | DT--3
WR--2 |  |  |  |  | DT--4
WR--3 |  |  |  |  | LOLB--1
WR--4 |  |  |  |  | LOLB--2 |  |  |  |  | OFFENSE TOTAL
WR--5 |  |  |  |  | LOLB--3 |  |  |  |  | DEFENSE TOTAL
WR--6 |  |  |  |  | [NAME] |  |  |  |  | SPC TEAM TOTAL
TE--1 |  |  |  |  | MLB--1 |  |  |  |  | TOTAL
TE--2 |  |  |  |  | MLB--2 |  |  |  |  | Points over [NAME]
TE--3 |  |  |  |  | MLB--3
LT--1 |  |  |  |  | MLB--4
LT--2 |  |  |  |  | ROLB--1 |  |  |  |  | ** a negative value in the 'Points over [NAME]' is Good
LT--3 |  |  |  |  | ROLB--2 |  |  |  |  | ** a negative value means you are under the limit by
LG--1 |  |  |  |  | ROLB--3 |  |  |  |  | that many points
LG--2 |  |  |  |  | ROLB--4 |  |  |  |  | ** a postive value means you are over the limit by
LG--3 |  |  |  |  | CB--1 |  |  |  |  | that many points
C--1 |  |  |  |  | CB--2
C--2 |  |  |  |  | CB--3
C--3 |  |  |  |  | CB--4
RG--1 |  |  |  |  | CB--5
[NAME] |  |  |  |  | CB--6
RG--3 |  |  |  |  | FS--1
RT--1 |  |  |  |  | FS--2
RT--1 |  |  |  |  | FS-3
RT--3 |  |  |  |  | SS--1
 |  |  |  |  | SS--2
 |  |  |  |  | SS--3
Spreadsheet: 798999d1664871304-how-to-copy-formula-down-rcti-example
Sheet: RCTI Journal

Account | Amount | Transaction Type | Voucher No. | Cost Centre |  |  |  |  | Location | Entity | Invoice |  | SUPP ID | Description
Spreadsheet: 857683d1706632512-formula-with-an-if-statement-formula-with-if
Sheet: Planilha1

 | Projected | Actual |  |  | Projected | Actual
Income 1 | 1500 | 1700 |  | Previous Month's bank balance | 1500 | 1700
Income 2 | 750 | 700 |  | Income | 2250 | 2400
Total Monthly income | 2250 | 2400 |  | Bank Account | 1895 | 2135
Rent/Mortgage | 500 | 500
Electricity bill | 500 | 500
Water bill | 500 | 500
Union Gas bill | 500 | 500
Gas for Car | 500 | 500
Home Insurance | 500 | 500
Car Insurance | 500 | 500
Groceries | 500 | 500
Retirement Savings |  |  | yes | if d 14=yes sum F4*0 2 | if d14e S sum G4*0 2
Spending | 150 | 250
Vacation |  |  | yes | if d16 Ye s sum F4*0 1 | ifd16e S sum G4*0 1
Total Expenses | 1855 | 1965
Spreadsheet: 323627d1402109034-calculating-rolling-average-ignoring-0-values-test-data
Sheet: Sheet1

Value | Name | Position | Team |  | [NAME] | PPM |  | Total PTS | [NAME] | [NAME] | 3 RA | 5 RA | Round 1 | Round 2 | Round 3 | Round 4 | Round 5 | Round 6 | Round 7 | Round 8 | Round 9 | Round 10 | Round 11 | Round 12 | Round 13 | Round 14 | Round 15 | Round 16 | Round 17 | Round 18 | Round 19 | Round 20 | Round 21 | Round 22 | Round 23 | Round 24 | Round 25 | Round 26
 |  |  |  |  |  |  |  |  |  |  | 3 | 5 | Pts | Pts | Pts | Pts | Pts | Pts | Pts | Pts | Pts | Pts | Pts | Pts | Pts | Pts | Pts | Pts | Pts | Pts | Pts | Pts | Pts | Pts | Pts | Pts | Pts | Pts
 | Player 1 |  |  |  | 7 | 1.1 |  | 639 | 80 | 91 |  |  | 65 | 95 | 76 | 84 | 103 | 142 | 0 | 0 | 0 | 74 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Player 2 |  |  |  | 11 | 1.1 |  | 941 | 78.5 | 85 |  |  | 132 | 81 | 50 | 46 | 53 | 39 | 93 | 108 | 94 | 131 | 0 | 114 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Player 3 |  |  |  | 5 | 1.2 |  | 430 | 69.8 | 86 |  |  | 32 | 0 | 0 | 0 | 0 | 0 | 94 | 65 | 106 | 133 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Player 4 |  |  |  | 12 | 1.1 |  | 1032 | 75.2 | 86 |  |  | 62 | 93 | 58 | 87 | 120 | 82 | 110 | 62 | 66 | 75 | 97 | 120 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Player 5 |  |  |  | 10 | 0.9 |  | 763 | 80.5 | 76 |  |  | 71 | 47 | 99 | 0 | 87 | 91 | 70 | 85 | 73 | 84 | 0 | 56 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Player 6 |  |  |  | 10 | 1 |  | 767 | 79.3 | 76 |  |  | 80 | 33 | 48 | 125 | 71 | 40 | 109 | 46 | 105 | 110 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Player 7 |  |  |  | 9 | 0.8 |  | 614 | 80.6 | 68 |  |  | 56 | 52 | 53 | 79 | 55 | 29 | 0 | 155 | 62 | 73 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Player 8 |  |  |  | 11 | 1.2 |  | 829 | 65.3 | 75 |  |  | 78 | 71 | 70 | 91 | 81 | 73 | 91 | 64 | 69 | 83 | 0 | 58 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 801375d1666181576-xlookup-and-duplicates-xlookup-issue-v2
Sheet: Patients

PatientID | recipient_first_name | recipient_last_name | Kit Mail Date | [NAME] | [NAME] | Kit Result Date | Result
H06019710 01
H11008461 00
H12000860 01
H17024081 01
H19004115 01
H19009311 01
H19013032 01
H19018045 01
H19035306 01
H19052921 01
H19052922 01
H19054735 01
H20029351 01
Spreadsheet: a5ec482d-9d5f-43c6-a626-7138bd139bd2
Sheet: InsHRA-Request

Premium Saver-Insured HRA-Request for Quote
Employer Name: |  |  |  |  |  |  | Telephone:
Employer Address:
Employer City: |  |  |  |  | State: |  | Zip Code:
Nature of business |  |  |  |  |  |  | Effective Date:
Agent Name: |  |  |  |  |  |  | Telephone:
[NAME] To: |  |  |  | Fax to: |  |  | Questions:
Current Plan(s) | Plan One |  |  | Plan Two |  |  | Plan Three
Medical Carrier
Deductible Amount
Employee Coinsurance | 0 |  |  | 0 |  |  | 0
$ Of Coinsurance
Total Dollars OOP
Doctor Office
Specialist Office Visit
Chiropractic
Drug Co Pays
Emergency Room Copay
Urgent Care Copay
Drug Deductible Amount | 0 |  |  | 0 |  |  | 0
Renewal Date
 | # Employee | Current | Renewal | # Employee | Current | Renewal | # Employee | Current | Renewal
Employee
Employee and Spouse
Employee/Child(ren)
Family
 |  |  |  | Special Instructions
Alternate Plan
Medical Carrier
Deductible Amount
[NAME]. |  |  | %
$ Of Coinsurance
Total Dollars OOP
Doctor Office
Specialist Office Visit
Chiropractic
Drug Co Pays |  |  |  | Primary Goal of this [NAME] is to Save Premium
ER Copay |  |  |  | Second Goal is to…
Urgent Care Copay |  |  |  | (Please check one)
Drug Deductible Amt | 0 |  |  |  | Save Premium
Renewal Date |  |  |  |  | Keep the Current Deductible & Coinsurance
 | # | Rates |  |  | Increase the Deductible & Coinsurance (increases savings)
Employee |  |  |  |  | Lower the Deductible and Coinsurance (improves benefits)
Employee/Spouse
Employee/Child(ren)
Family
Notes
Are Rates Firm | Yes/No
Insured HRA Plan Design (please enter the plan design you want quoted)
 |  |  |  | Plan One |  | Plan Two |  | Plan Three
Deductible Amount (Per Person)
Deductible Type  (Calendar Year or Plan Year) |  |  |  | Calendar |  | Calendar |  | Calendar
Co-Insurance % |  |  |  | % |  | % |  | %
Co-Insurance $ [NAME] (Excludes Deductible)
Benefit Amount
Spreadsheet: 27d90b33-ef7d-4186-8986-198c04c36a50
Sheet: Table 5.3

Monthly Statistical Bulletin
5.3 Lending for housing
Month | 2009–10 | 2010–11 | 2011–12 | 2012–13 | 2013–14
Value (a) – $ million
July | 22706.823 | 19885.251 | 20030.76 | 20615.71 | 24396.541
August | 22651.27 | 19676.912 | 20361.678 | 20735.945 | 23843.904
September | 23260.315 | 19668.605 | 20031.279 | 21558.684 | 25557.273
October | 22808.017 | 19939.15 | 19793.641 | 21807.911 | 26369.896
November | 22128.753 | 19935.037 | 19965.698 | 21565.45 | 27016.544
December | 21167.665 | 20313.707 | 20925.787 | 21262.954 | 27043.46
January | 20620.118 | 19546.619 | 20850.717 | 21997.868 | 26885.374
February | 20289.471 | 19144.868 | 20410.691 | 22163.776 | 27642.004
March | 19992.647 | 18794.944 | 20015.42 | 23060.675 | 27345.502
April | 19980.224 | 19370.009 | 20689.918 | 23200.718
May | 20271.352 | 19901.434 | 20375.732 | 23693.737
June | 19864.225 | 19863.632 | 20684.127 | 23975.119
Annual | 256108.717 | 236430.333 | 244404.217 | 264700.603
Annual change (a) – per cent
July | 20.42913456298554 | -12.4260976535555 | 0.7317433408308371 | 2.920258642208284 | 18.339562401683
August | 25.78938129477386 | -13.13108713109684 | 3.480048088846455 | 1.838095072518087 | 14.98826795692214
September | 28.81763845133389 | -15.44136440112698 | 1.843923348910614 | 7.625099725284645 | 18.5474632867201
October | 21.85753855649146 | -12.57832717329174 | -0.7297653109585966 | 10.17634906079179 | 20.9189454230623
November | 17.94288449868147 | -9.913418980274214 | 0.1538045803476606 | 8.012502242596288 | 25.27697775840523
December | 7.893425012933863 | -4.034256966935191 | 3.01313787778863 | 1.611251227970545 | 27.18580870748248
January | -0.1270200732401028 | -5.206075930312326 | 6.671731822265548 | 5.501734065068353 | 22.2180894984914
February | -2.871707078323915 | -5.641364429856266 | 6.611813672468259 | 8.589052668525543 | 24.7170337761941
March | -11.22163592643588 | -5.990717487284202 | 6.493639991691369 | 15.2145445861241 | 18.58066600392227
April | -14.1658448503607 | -3.054094889026271 | 6.814188883443495 | 12.13537917356655
May | -11.24866334603236 | -1.824831417263129 | 2.383235298521691 | 16.28410208771886
June | -14.92892637272768 | -0.002985266226074312 | 4.130639351353271 | 15.91071259618546
Annual | 4.286752225557649 | -7.683605708742817 | 3.372614629781864 | 8.304433634219976
(a) Monthly figures are seasonally adjusted.
Source: ABS, Housing finance, Cat. no. 5609.0 | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=5609.0&viewtitle=Housing%20Finance,%20Australia~Jan%202008~Latest~11/03/2008&&tabname=Past%20Future%20Issues&prodno=5609.0&issue=Jan%202008&num=&view=& | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=5609.0&viewtitle=Housing%20Finance,%20Australia~Jan%202008~Latest~11/03/2008&&tabname=Past%20Future%20Issues&prodno=5609.0&issue=Jan%202008&num=&view=&
 |  |  |  |  |  |  |  | Update
 |  |  |  |  |  |  |  | 2014-06-10 00:00:00
Spreadsheet: 139103d1328076079-nested-if-statement-with-index-and-match-within-vanguard-template
Sheet: Sheet1

 | [NAME]
 | Product | [NAME] |  |  |  | CATEGORY | Category 2 | do this with lists |  |  |  |  |  |  |  | BEAMS
 | Length (mm) | 3400 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Category 1 | Category 2 | Category 3
 | Projection | 3500 |  |  |  | Beams and Brackets |  |  |  |  |  |  |  |  |  | 50 x 50 | 47 | 90 | 47
 | Operation | Remote |  |  |  |  |  |  |  |  |  |  |  |  |  | 100 x 50 | 47 | 92 | 47
 | Control | Telis 16 - silver |  |  |  | Beams | Price | Length | Total |  |  |  |  |  |  | 150 x 50 | 95 | 94 | 95
 | Sensor | Wind sensor - RTS (inc. 1 channel remote) |  |  |  | 250 x 50 |  | 4 |  | ------------------------------->>>> |  |  |  |  |  | 200 x 50 | 105 | 96 | 130
 | Material Category | Category 3 |  |  |  |  |  |  |  |  |  |  |  |  |  | 250 x 50 | 125 | 100 | 125
 | Frieght | Cost | 400 |  |  | Brackets | Price | Amount | Total
 | [NAME] | No |  |  |  | Rafter | 120 | 10 |  |  |  |  |  |  |  |  | INDEX(Q5:T10,MATCH(G9,Q6:Q10,0),2) | IF(H4="Category 2",INDEX(Q5:T10,MATCH(G9,Q6:Q10,0),3) | INDEX(Q5:T10,MATCH(G9,Q6:Q10,0),4)))
 | Beam | No |  |  |  |  |  |  |  |  |  |  |  |  |  |  | This is 2 in the match | This is the 3 in the match | This is the number 4 in the match
 | Brackets | No
 | Drafting | Cost | 250 |  |  |  |  |  |  |  |  |  |  |  |  | Column 1 | Column 2 | Column 3 | Column 4
 | Buffer | Cost | 250
 | Kit | Cost
 | Labour | Cost | 810
 | Total
 | GST
 | Total inc GST
Spreadsheet: 224290d1364506555-logical-function-with-conditional-formatting-conditional
Sheet: Sheet1

Initial
ROW 1 | 1 | 3.2 | 3 | 4 | 2 | 2.3 | 4 | 5 |  |  | if any of these match…
ROW 2 | 3.2 |  | 2 |  |  | 2.3 | 4 |  | 3.2 | 6 | …any of these
Desired Result
ROW 1 | 1 | 3.2 | 3 | 4 | 2 | 2.3 | 4 | 5 |  |  | conditional format red
ROW 2 | 3.2 |  | 2 |  |  | 2.3 | 4 |  | 3.2 | 6
Spreadsheet: john_zufferli__16734__Tolling Inputs 10-23
Sheet: Sheet1

 | PROJECT SUMMARY
 | Plant |  | AES Calgary
 | Capacity |  | 525 MW (nominal)
 | Delivery Point |  | [NAME] substation
 | Configuration |  | 2 1x1 gas-fired combined-cycle gas turbines
 | Structure |  | For initial discussion purposes, please propose a capacity payment ($/kW-month) under a tolling arrangement in which the toller delivers gas to and takes power from the plant with full dispatch rights, including ancillary services.  As discussions proceed, AES Calgary may propose alternative structures, including financially-settled hedges (e.g., contract for differences), for the final definitive agreement.
 | Availability |  | Buyer can select 8 on-peak months for 98 percent availability,
 |  |  | so long as the 4 off-peak months occur in 2 two-month blocks,
 |  |  | e.g., April & May and October & November.
 |  |  | Off-peak average availability = 85 percent
 |  |  | [NAME] can preschedule Planned Outages anytime during off-peak months
 | Term |  | Term |  | Dates
 |  |  | 15 Years |  | 1/04 - 12/18
 |  |  | 10 Years |  | 1/04 - 12/13
 |  |  | 5 Years |  | 1/04 - 12/08
 | Performance (per unit)
 |  |  | Net Output |  | Net Heat Rate |  | [NAME] **
 | Baseload |  | (MW) |  | (kJ/kWh HHV) |  | (% per minute)
 | Winter: |  | 234.32775 |  | 7707.61554915 |  | 0.05
 | Summer: |  | 218.61375 |  | 7617.203636549999 |  | 0.05
 |  |  | Incremental |  | Incremental Heat |  | [NAME] **
 | Peaking |  | Output (MW) |  | Rate (kJ/kWh HHV) |  | (% per minute)
 | Winter: |  | 26.18514999999999 |  | 9918.359523050281 |  | 0.15
 | Summer: |  | 26.86414999999999 |  | 10123.2466910362 |  | 0.15
 | ** Ramp rates are from min load up to full load or from full load down to min load.  For base load capacity, min load is ~ 106 MW; for peaking capacity, min load = 0 MW.
 |  | Definition: |  |  |  | Fuel |  | Net Energy
 |  | Hours after |  | Length of |  | Consumed |  | Produced during
 | Starts | Last Shutdown |  | Startup (min) |  | (GJ) |  | Startup (MWh)
 | Cold | > 72 |  | 240 |  |  |  | 216
 | Warm | 12 - 72 |  | 160 |  |  |  | 209
 | Hot | < 12 |  | 80 |  |  |  | 92
 | Variable O&M (C$/MWh)
 | [NAME] number of starts allowed |  | 250 | per 8,000 operating hours
Spreadsheet: 53848d1253783034-separate-and-sort-number-sample2
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | This area I keep make on other sheet.
 | My sample table |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Purpose for input data
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | You can key into any cell below table 2 digit/cell (00-99)
 |  |  | 00 | 10 | 20 | 30 | 40 | 50 | 60 | 70 | 80 | 90 |  |  |  |  |  |  | 84 | 02 | 14 | 52 | 00 | 30 | 66 | 76 | 86 | 96
 |  |  | 01 | 11 | 21 | 31 | 41 | 51 | 61 | 71 | 81 | 91 |  |  | Matching Number |  |  |  | 72 | 22 | 15 | 55 | 05 | 31 | 65 | 75 | 85 | 95
 |  |  | 02 | 12 | 22 | 32 | 42 | 52 | 62 | 72 | 82 | 92 |  |  | check |  |  |  | 93 | 40 | 16 | 50 | 06 | 32 | 20 | 46 | 41 | 03
 |  |  | 03 | 13 | 23 | 33 | 43 | 53 | 63 | 73 | 83 | 93 |  |  |  |  |  |  | 19 | 71 | 81 | 11 | 07 | 33 | 28 | 29 | 51
 |  |  | 04 | 14 | 24 | 34 | 44 | 54 | 64 | 74 | 84 | 94 |  |  |  |  |  |  | 37 | 11 | 80 | 25 | 08 | 34 | 61 | 39 | 60
 |  |  | 05 | 15 | 25 | 35 | 45 | 55 | 65 | 75 | 85 | 95 |  |  |  |  |  |  | 87 | 84 | 54 | 67 | 09 | 35 | 47 | 97 | 38
 |  |  | 06 | 16 | 26 | 36 | 46 | 56 | 66 | 76 | 86 | 96 |  |  |  |  |  |  | 43 | 53 | 63 | 73 | 83 | 36 | 57 | 98 | 77
 |  |  | 07 | 17 | 27 | 37 | 47 | 57 | 67 | 77 | 87 | 97 |  |  |  |  |  |  | 48 | 58 | 68 | 78 | 13 | 70 | 90 | 45 | 92
 |  |  | 08 | 18 | 28 | 38 | 48 | 58 | 68 | 78 | 88 | 98 |  |  |  |  |  |  | 74 | 59 | 69 | 79 | 44 | 89 | 91 | 61 | 82
 |  |  | 09 | 19 | 29 | 39 | 49 | 59 | 69 | 79 | 89 | 99 |  |  |  |  |  |  | 04 | 23 | 27 | 18 | 64 | 99 | 88 | 17 | 56
Show Result = |  |  | 10 |  |  |  | set
 | Separate and sort Number
 | 01 | 10 | 12 | 21 | 24 | 26 | 42 | 49 | 62 | 94 |  |  | 1st Style
 |  |  |  |  | OR
 | 01 | 10 | 12 | 21 | 24 | 42 | 26 | 62 | 49 | 94 |  |  | 2nd Style
Spreadsheet: 805192d1668583918-beginning-of-month-date-formula-cell-beginning-of-month-range
Sheet: Sheet1

 | 2022-11-01 00:00:00
 | Period From: |  |  |  |  |  |  | Until:
 |  |  |  | Cell used to show week number
 | Desciption |  |  | Mon | Tue | Wed | Thu | Fri | Sat | Sun