tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 142224d1329744276-formula-error-vbax-state-updtd
Sheet: Graph

2012
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | New Stock | 2012
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Used stock in working condition
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Used stock in repairable condition
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Used stock in Non Working Condition/Non-repairable Condition
 |  | AP |  | True |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Non- Working Stock
 |  | Assam |  | True |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Repaired stock
 |  | CP |  | True
 |  | LP |  | True
 |  | GUJ |  | True
 |  | WP |  | True
 |  | HP |  | True
 |  | JK |  | True
 |  | KOL |  | True
 |  | [NAME] |  | True
 |  | MAH |  | True
 |  | MP |  | True
 |  | MUM |  | True
 |  | NE |  | True
 |  | OR |  | True
 |  | WB |  | True
Spreadsheet: 144941d1331220273-excel-2007-changing-a-defualt-date-00-00-1900-to-a-blank-deafult-date-3
Sheet: Output

uniq | Inspection A | Inspection B | Inspection C | Inspection D | Next A | Next B
20053026Z604785 | 2011-03-24 08:08:46 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2012-03-23 08:08:46 | 1900-01-01 00:00:00
20053026Z604785 | 2011-03-24 08:08:46 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2012-03-23 08:08:46 | 1900-01-01 00:00:00
20053026Z604785 | 2011-03-24 08:08:46 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2012-03-23 08:08:46 | 1900-01-01 00:00:00
Spreadsheet: 705548d1606184053-formul-to-compute-average-and-no-of-years-up-to-last-item-in-col-compute-average-and-count-up-to-last-item
Sheet: Sheet1

Date | Bank Interest rate
2018-09-01 00:00:00 | 5.75 |  |  | Average Interest
 | 5.75 |  |  | No of years
 | 5.75
 | 5.75
 | 6.75
 | 6.75
 | 6.75
 | 6.75
 | 6.75
 | 6.75
 | 6
 | 6
 | 6
 | 6
 | 6.25
 | 6.25
 | 6.75
 | 6.75
 | 6.75
 | 7
 | 7
 | 7
 | 7
 | 7
 | 7
 | 7
 | 7
 | 7
 | 7
 | 7
 | 7
 | 7
 | 7
 | 6.75
 | 6.75
 | 6.75
 | 6.75
 | 6.75
 | 6.75
 | 6.75
 | 6.75
 | 6.75
 | 6.5
 | 6.5
 | 6.5
 | 6.5
 | 6.5
 | 6.5
 | 6.5
 | 0.065
 | 0.0675
 | 0.0675
 | 0.0675
 | 0.0675
 | 0.0675
 | 0.0675
 | 0.0675
 | 0.0675
 | 0.0675
Spreadsheet: 832141d1686142418-if-any-cell-in-column-b-includes-any-of-these-words-in-range-j1-j4-then-highlight-row-daliye-conditionalformatentirerow
Sheet: Sheet1

No. | Item | 2016 | 2017 | 2018 | 2019 |  |  |  | Fixed
1 | Fixed assets |  |  |  |  |  |  |  | Loans
2 | Total non-current assets |  |  |  |  |  |  |  | Sales
3 | Cash and the like |  |  |  |  |  |  |  | Long
4 | Total current assets
 |  |  |  |  |  |  |  |  | If any cell in column B includes any of these words in range J1:J4, then highlight entire row with read
No. | Item | 2016 | 2017 | 2018 | 2019
1 | Total current liabilities
2 | long term loans
3 | Total non-current liabilities
4 | total liabilities
No. | Item | 2016 | 2017 | 2018 | 2019
1 | Sales
2 | Cost of Goods Sold
3 | Inventory
4 | Loans
No. | Item | 2016 | 2017 | 2018 | 2019
1 | Fixed Assets
2 | Cash Papers
3 | Inventory
4 | Long Loan
Spreadsheet: 87240d1287080626-excel-2007-error-bars-how-does-one-add-different-standard-dev-bars-qi
Sheet: Profession Grouping

Caregivers 2008 | Group | SD
[NAME]) | 2.11111111111111
NURSING ADMIN(CLINICAL) | 2.941168499920293
NURSING ADMIN(EDUCATION) | 3.3
PHYSICIAN EXECUTIVE | 3.030492555851923
PHYSICIAN EXECUTIVE | 2.644394394394393
PROSTHETICS | 2.933333333333334
PSYCHIATRY | 3.17647104674456
PSYCHOLOGY | 3.155555555555557
SENSORY & PHYSICAL REHAB | 3.12907268170426
SENSORY & PHYSICAL REHAB | 3.129074074074074
GROUP MEAN | 2.955067325268951 | 0.3470325267681159
Caregivers 2009 | Group
ACUTE CARE RN's | 3.148025101513473
ANESTHESIOLOGY | 3.12121212121212
AUDIOLOGY | 2.21212121212121
DENTAL | 2.591617933723196
GERIATRICS AND EXTENDED CARE | 3.264734299516906
MHCL RN's | 3.247574055158323
NEUROLOGY | 3.636363636363637
PSYCHIATRY | 3.290697674418604
PSYCHOLOGY | 3.06060606060606
Radiology | 3.191637630662024
Radiology | 3.188172043010753
SENSORY & PHYSICAL REHAB | 2.918604651162793
SENSORY & PHYSICAL REHAB | 2.935483870967743
Group Mean | 3.06206540695668 | 0.3513652561920193
Spreadsheet: 871715d1718131914-switch-elements-of-array-populate-empty-elements-with-most-recent-value-shift-headings
Sheet: Sheet1

 | Input | Values | Desired Output |  | [NAME]
data heading | a
 |  | xxx |  |  | a
empty heading | ab
data heading | aaa
 |  | xxx |  |  | a
data heading | b
 |  | xxx |  |  | a
 |  | xxx |  |  | a
data heading | bhj
 |  | xxx |  |  | a
empty heading | bhj
data heading | b3
 |  | xxx |  |  | a
 |  | xxx |  |  | a
 |  | xxx |  |  | a
data heading | ca
 |  | xxx |  |  | a
 |  | xxx |  |  | a
 |  | xxx |  |  | a
empty heading | chk
data heading | [NAME]
 |  | xxx |  |  | a
end of data
Spreadsheet: 865613d1712661071-new-invoice-allocation-register-test-invoice-allocation-register-emmagizer-amended
Sheet: Output

 | Enter Job Number here: | JN23/001
PO | PO Description | PO status | PO Value  (ex GST)
Spreadsheet: 454255d1459754904-if-then-subtotal-excel-forum-sample
Sheet: Sheet1

Category | Code | Type | Hours | Rate | Hours | Cost
Activity | 1 | ORDINARY HOURS | 311.0000 | 8,669.38
Activity | 2 | ANNUAL LEAVE | 93.5000 | 2,606.40
Activity | 22 | ANNUAL LEAVE LOADING | 93.5000 | 456.11
Activity | 52 | PUBLIC HOLIDAY- NOT WRKD | 22.0000 | 613.28
Activity | 55 | COMPASSIONATE LEAVE | 5.5000 | 153.32
Total 221 ACOSTA
Activity | 1 | ORDINARY HOURS | 262.0000 | 6,916.11
Activity | 2 | ANNUAL LEAVE | 11.5000 | 303.57
Activity | 3 | SICK LEAVE WITH CERTIFICATE | 61.0000 | 1,610.24
Activity | 12 | TERM - A/L - POST 17/8/93 | 85.0786 | 2,245.85
Activity | 14 | TERMINATION - A/L LOADING | 85.0786 | 393.02
Activity | 22 | ANNUAL LEAVE LOADING | 11.5000 | 53.13
Activity | 68 | JURY DUTY | 7.5000 | 197.98
Total 1134 AGUIRRE
Activity | 1 | ORDINARY HOURS | 545.9000 | 18,705.69
Activity | 2 | ANNUAL LEAVE | 30.4000 | 1,041.68
Activity | 3 | SICK LEAVE WITH CERTIFICATE | 7.6000 | 260.42
Activity | 4 | SICK LEAVE WITHOUT CERTIFICATE | 7.6000 | 260.42
Activity | 22 | ANNUAL LEAVE LOADING | 30.4000 | 182.29
Activity | 52 | PUBLIC HOLIDAY- NOT WRKD | 15.2000 | 520.84
Allowance | 5 | INTERP ALL [NAME] 38 HOURS |  | 57.69
Total 619 ALBREIHI
Activity | 1 | ORDINARY HOURS | 13.0000 | 403.07
Activity | 52 | PUBLIC HOLIDAY- NOT WRKD | 4.5000 | 139.52
Allowance | 2 | PM'S - REGISTERED NURSES |  | 51.80
Total 1251 AL-HASSANY
Spreadsheet: 172211d1344026706-adding-reminders-tigeravatar-example-for-psilver1
Sheet: Bag 13

Item | Expiration Date |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bag 13
Item 01 | 2012-08-14 00:00:00
Item 02 | 2012-08-14 00:00:00
Item 03 | 2012-08-11 00:00:00
Item 04 | 2012-08-16 00:00:00
Item 05 | 2012-08-10 00:00:00
Item 06 | 2012-08-10 00:00:00
Item 07 | 2012-08-15 00:00:00
Item 08 | 2012-08-12 00:00:00
Item 09 | 2012-08-14 00:00:00
Item 10 | 2012-08-17 00:00:00
Item 11 | 2012-08-06 00:00:00
Item 12 | 2012-08-15 00:00:00
Item 13 | 2012-08-15 00:00:00
Item 14 | 2012-08-04 00:00:00
Item 15 | 2012-08-13 00:00:00
Item 16 | 2012-08-04 00:00:00
Item 17 | 2012-08-15 00:00:00
Item 18 | 2012-08-14 00:00:00
Item 19 | 2012-08-08 00:00:00
Item 20 | 2012-08-13 00:00:00
Spreadsheet: 818207d1676647148-conditional-formatting-triggered-using-week-numbers-test
Sheet: Sheet1

 |  |  |  |  |  |  | 02/01/23 - 08/01/23 | 09/01/23 - 15/01/23 | 16/01/23 - 22/01/23 | 23/01/23 - 29/01/23 | 30/01/23 - 05/02/23 | 06/02/23 - 12/02/23 | 13/02/23 - 19/02/23 | 20/02/23 - 26/02/23
FRUIT |  |  |  |  | Amount | Frequency | week 1 | week 2 | week 3 | week 4 | week 5 | week 6 | week 7 | week 8
Apple |  |  |  |  | 1 | 2x | O |  |  | O |  | C
Orange |  |  |  |  | 2 | 2x |  |  | C |  | C |  | D
Lemon |  |  |  |  | 1 | 3x |  | O |  |  |  | O
Grapes |  |  |  |  | 20 | 2x |  | C |  |  |  |  | D | D
[NAME] |  |  |  |  | 1 | 1x |  |  |  | C |  | C |  | D
Spreadsheet: 737353d1624368436-formula-to-sum-a-row-dependant-upon-a-criteris-test-data-etaf
Sheet: Wxample

Week | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11
Shoes | 24121.56488758824 | 2000 | 24121.56488758824 | 2000 | 24121.56488758824 | 24121.56488758824 | 24121.56488758824 | 24121.56488758824 | 24121.56488758824 | 24121.56488758824 | 24121.56488758824
Trousers | 7388.343529411765 | 2000 | 7388.343529411765 | 2000 | 7388.343529411765 | 7388.343529411765 | 7388.343529411765 | 7388.343529411765 | 7388.343529411765 | 7388.343529411765 | 7388.343529411765
Socks | 1232.57 | 2000 | 1232.57 | 2000 | 1232.57 | 1232.57 | 1232.57 | 1232.57 | 1232.57 | 1232.57 | 1232.57
Report |  |  | Week no | 4
 | Week | YTD
Shoes
Trousers
Socks
Example attached - its cells C10, C11, C12 that I'm tring to calculate based upon week number input in cell E8
Spreadsheet: 288016d1389065248-how-to-identify-a-data-pattern-sales-per-q
Sheet: Data

**Enter transaction data here
Sales Rep | Q1 | Q2 | Q3 | Q4 | Q5 | Q6 | Q7
[NAME] | 131000 | 10000 | 87000 | 62000 | 22000 | 98000 | 72000
[NAME] | 26000 | 67000 | 67000 | 24000 | 63000 | 100000 | 105000
[NAME] | 105000 | 82000 | 87000 | 73000 | 11000 | 46000 | 100000
[NAME] | 41000 |  | 50000 | 109000 | 110000 |  | 96000
[NAME] | 65000 | 70000 | 94000 | 65000 | 85000 | 24000 | 80000
[NAME] | 42000 | 30000 | 70000 | 36000 | 83000 | 11000 | 95000
[NAME] | 106000 | 92000 | 107000 | 36000 | 53000 | 33000 | 53000
[NAME] | 57000 | 31000 |  | 47000 | 79000 |  | 93000
[NAME] | 23000 | 92000 | 31000 | 68000 | 40000 | 33000 | 44000
[NAME] | 30000 | 74000 | 37000 | 22000 | 103000 | 64000 | 58000
[NAME] | 74000 | 49000 | 18000 | 39000 | 57000 | 18000 | 38000
[NAME] | 54000 | 88000 |  |  | 17000 | 95000 | 73000
Salley Jemison | 53000 | 10000 | 62000 | 78000 | 109000 | 68000 | 46000
Salley Jemison | 53000 | 106000 | 66000 | 57000 | 88000 | 96000 | 98000
Salley Jemison | 87000 | 84000 | 97000 | 55000 | 45000 | 67000 | 64000
Salley Jemison | 102000 | 106000 |  | 70000 | 41000 | 37000
Jenifer Cogdill | 28000 | 23000 | 69000 | 56000 | 59000 | 20000 | 38000
Jenifer Cogdill | 24000 | 84000 | 24000 | 33000 | 92000 | 80000 | 34000
Jenifer Cogdill | 39000 | 98000 | 90000 | 59000 | 26000 | 13000 | 48000
Jenifer Cogdill | 98000 | 82000 | 97000 | 69000 | 48000 |  | 73000
Spreadsheet: john_forney__15496__SCHED2001
Sheet: JUNE'01

 |  |  |  |  |  |  |  |  |  |  | 24 HOUR SCHEDULE
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
NAME | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT
ERCOT | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
[NAME] | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  |  | N | N | N |  |  |  | D | D | D | D
JOHN FORNEY | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D/N | N | N | D | D | D | D | D |  |  | V | D | D | D | D
[NAME] | D |  |  |  | N | N | N |  | D | D |  |  |  |  |  |  |  |  | D | D | D | D |  |  | N | N | N |  |  | D
CHRIS WATTS | N | N | N | N |  |  |  |  |  |  | N | N |  |  |  | D | D |  | N | N | N |  | D | D
[NAME] |  | D | D |  |  |  |  | N | N | N |  |  | N | N |  |  |  |  |  |  |  | N | N | N |  |  |  | N | N | N
SOUTHEAST
[NAME] | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D
RUDY ACEVEDO | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D
MIGUEL GARCIA | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D
MAURICIO TREJO |  |  |  |  | N | N | N | N |  |  |  |  |  | N | N | N | N |  |  |  |  |  | D | D |  |  |  | N | N | N
[NAME] |  |  |  |  | N | N | N | N |  |  |  |  |  | N | N | N | N |  |  |  |  | D | D | D |  |  | N | N | N | N
MIDWEST
[NAME] | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D
J.D.KINSER | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D
DEAN LAURENT | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D
JUAN PADRON |  | D | D | D | D |  |  |  | N | N | N |  |  |  |  |  |  | N | N | N | N |  |  |  | N | N | N |  |  | D
DUSTIN COLLINS | N | N | N | N |  |  |  |  | D | D |  | N | N |  |  | D | D | D |  |  |  | N | N | N | N | N
ANDREW GREER |  | D | D | D |  |  |  |  | N | N | N |  |  | D |  |  |  | N | N | N | N | N |  |  | D | D |  |  | D | D
[NAME] (NEW)
NORTHEAST
[NAME] |  | N | N | N |  |  |  |  | D | D |  | N | N |  |  | D | D |  | N | N | N |  |  |  | N | N
NIGHTS
DAYS
Spreadsheet: 221161d1363385003-time-adherence-sheet-for-excel-work-times-1-
Sheet: Sheet1

 | Start | End | Time | Total Time
ACW | 08:30:00 | 09:00:00
ACW | 09:10:00 | 09:25:00
ACW | 09:30:00 | 09:45:00
This is what you asked for.
I would think it would be more like this.
 | Start | End | Time | Total Time
ACW | 08:30:00 | 09:00:00
ACW | 09:10:00 | 09:25:00
ACW | 09:30:00 | 09:45:00
 | 09:50:00 | 10:00:00
 |  |  |  |  | I would like it so that as you enter start times and end times down the rows, the elapsed time difference is reflected down column D. Column E would then add the total time from what ever row information was submitted for last.  [NAME], which poses the hardest obstacle ...would reflect the time used asthe percentage of time used from the 2 given hours in a day (which everyone in the job needs to keep above 75%) in other words, if you use all 2 hours given to you...You are at 75% adherence which is OK
Spreadsheet: 64497d1265331812-summary-different-day-expense-book1
Sheet: Sheet1

2010-02-04 00:00:00 |  |  | 2010-02-05 00:00:00 |  |  | 2010-02-06 00:00:00
Burger King | 5 |  | King Subs | 10 |  | Pizza Maria | 5
Pizza Maria | 3 |  | Pizzahut | 5 |  | Hello Subs | 20
[NAME] | 9 |  | Chicken filay | 15 |  | [NAME] | 10
Chicken Mexcio | 15 |  | Burger King | 5 |  | Burger Ginno | 5
SUMMARY
Burger
Pizza
Subs
Chicken
Spreadsheet: 186821d1350241012-stock-register-calculation-mechanic-test
Sheet: Sheet1

1 February 2012 to 28 February 2012
Stock Type | On hand 1 Feb 2012 | Incoming Quantity | Quantity in Stock | Until next order (min of 80) | Used (During month) | On hand 28 Feb 2012
Stock 1 | 80 |  | 80 |  | 25 | 55
Stock 2 | 80 |  | 80 |  | 16 | 64
Stock 3 | 80 |  | 80 |  | 0 | 80
Stock 4 | 80 |  | 80 |  | 7 | 73
Stock 5 | 80 |  | 80 |  | 79 | 1
1 March 2012 to 31 March 2012
Stock Type | On hand 1 Mar 2012 | Incoming Quantity | Quantity in Stock | Until next order (min of 80) | Used (During month) | On hand 31 Mar 2012
Stock 1 | 55 |  | 55 | ORDER NEW STOCK!! |  | 55
Stock 2 | 64 |  | 64 | ORDER NEW STOCK!! |  | 64
Stock 3 | 80 |  | 80 |  |  | 80
Stock 4 | 73 |  | 73 | ORDER NEW STOCK!! |  | 73
Stock 5 | 1 |  | 1 | ORDER NEW STOCK!! |  | 1
Spreadsheet: 743371d1628445375-index-match-works-for-some-cell-not-others-index-and-match-lesson
Sheet: Helper

COID | Market
3906 | PALM BEACH MARKET
20830 | DADE MARKET
24554 | BROWARD MARKET
03898 | BROWARD MARKET
20076 | PALM BEACH MARKET
20123 | PALM BEACH MARKET
20329 | DADE MARKET
20436 | PALM BEACH MARKET
20484 | BROWARD MARKET
20707 | BROWARD MARKET
20712 | BROWARD MARKET
21290 | TREASURE COAST MARKET
21502 | DADE MARKET
21573 | PALM BEACH MARKET
21574 | TREASURE COAST MARKET
23161 | TREASURE COAST MARKET
23162 | TREASURE COAST MARKET
23163 | TREASURE COAST MARKET
23164 | TREASURE COAST MARKET
23224 | TREASURE COAST MARKET
23232 | DADE MARKET
23239 | TREASURE COAST MARKET
23354 | BROWARD MARKET
23378 | DADE MARKET
23440 | BROWARD MARKET
23574 | PALM BEACH MARKET
23754 | TREASURE COAST MARKET
24134 | PALM BEACH MARKET
24136 | DADE MARKET
24136 | DADE MARKET
24137 | DADE MARKET
24177 | PALM BEACH MARKET
24214 | DADE MARKET
24220 | DADE MARKET
24220 | DADE MARKET
24220 | DADE MARKET
24227 | TREASURE COAST MARKET
24270 | DADE MARKET
24271 | DADE MARKET
24271 | DADE MARKET
24275 | PALM BEACH MARKET
24305 | DADE MARKET
24306 | DADE MARKET
24307 | DADE MARKET
24333 | TREASURE COAST MARKET
24366 | DADE MARKET
24382 | PALM BEACH MARKET
24383 | PALM BEACH MARKET
24403 | BROWARD MARKET
24417 | TREASURE COAST MARKET
24418 | DADE MARKET
24474 | PALM BEACH MARKET
24500 | BROWARD MARKET
24548 | DADE MARKET
24550 | DADE MARKET
24550 | DADE MARKET
24550 | DADE MARKET
24586 | DADE MARKET
24601 | DADE MARKET
24601 | DADE MARKET
24610 | None
24698 | TREASURE COAST MARKET
25119 | TREASURE COAST MARKET
25144 | TREASURE COAST MARKET
25488 | TREASURE COAST MARKET
25641 | TREASURE COAST MARKET
25778 | PALM BEACH MARKET
25804 | PALM BEACH MARKET
25911 | TREASURE COAST MARKET
26014 | BROWARD MARKET
26203 | PALM BEACH MARKET
26303 | TREASURE COAST MARKET
26314 | DADE MARKET
26314 | DADE MARKET
26314 | DADE MARKET
3187 | PALM BEACH MARKET
Spreadsheet: cooper_richey__4011__AB Power Fax
Sheet: Sheet1

 |  | GFI Alberta Electricity Desk
 |  | [NAME] [PHONE]
 |  | [EMAIL]
 |  | FLAT | LOAD
 | Maturity | bid $/Mwh | ask $/Mwh
 | Day Ahead | 42.5 | 44
 | 2001-12-01 00:00:00 | 36 | 38
 | 2002-01-02 00:00:00 | 38.5 | 40.5
 | Q1 2002 | 38.5 | 40.5
 | Q2 2002 | 35 | 37
 | Q3 2002 | 38 | 40
 | Q4 2002 | 40.5 | 42.5
 | Cal 2002 | 38 | 40
 | Cal 2003 | 37 | 39
Note:
GFI Brokers Limited ("GFI") has provided this information on the basis that its intended use is for indicative price only.
GFI provides no warranties as to the accuracy of this information.
GFI (and its affiliates) accept no liability whatsoever for any loss that may arise as a result of the provision and use of this information.
Spreadsheet: 777703d1650557292-serpentine-numbers-in-a-table-formula-serpentineformula
Sheet: Sheet1

Rows | 5
Columns | 10
 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
20 | 19 | 18 | 17 | 16 | 15 | 14 | 13 | 12 | 11
21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
40 | 39 | 38 | 37 | 36 | 35 | 34 | 33 | 32 | 31
41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50
Spreadsheet: 39474d1237651800-being-able-to-type-a-code-and-search-stats-test-1
Sheet: main page

Filter | All | 2009-03-01 00:00:00 | 2009-03-01 00:00:00 | 2009-02-01 00:00:00 | 2009-02-01 00:00:00 | 2009-01-01 00:00:00 | 2009-01-01 00:00:00 | 2008-12-01 00:00:00 | 2008-12-01 00:00:00 | 2008-12-01 00:00:00 | 2008-12-01 00:00:00 | 2008-11-01 00:00:00 | 2008-11-01 00:00:00 | 2008-11-01 00:00:00 | 2008-11-01 00:00:00 | 2008-11-01 00:00:00 | 2008-10-01 00:00:00 | 2008-10-01 00:00:00 | 2008-10-01 00:00:00 | 2008-10-01 00:00:00 | 2008-10-01 00:00:00 | 2008-10-01 00:00:00 | 2008-06-01 00:00:00 | 2008-06-01 00:00:00 | 2008-05-01 00:00:00 | 2008-05-01 00:00:00 | 2008-05-01 00:00:00 | 2008-05-01 00:00:00 | 2008-01-01 00:00:00 | 2008-01-01 00:00:00 | 2008-01-01 00:00:00 | 2008-01-01 00:00:00 | 2008-01-01 00:00:00 | 2007-12-01 00:00:00 | 2007-12-01 00:00:00 | 2007-11-01 00:00:00 | 2007-11-01 00:00:00 | 2007-11-01 00:00:00 | 2007-01-01 00:00:00 | 2007-01-01 00:00:00 | 2006-12-01 00:00:00 | 2006-12-01 00:00:00 | 2006-12-01 00:00:00 | 2006-12-01 00:00:00 | 2006-12-01 00:00:00 | 2006-11-01 00:00:00 | 2006-11-01 00:00:00
Code | player |  | W |  | W |  | W |  | L |  | L | W |  | W |  | L |  | D |  | L |  | D |  | W |  | D |  | W | D |  | L |  | W |  | W |  | W | W |  | W | W |  | W |  | W |  | W
PONR | R. Ponting | Saf | Test 2 | Saf | Test 1 | Saf | Test 3 | Saf | Test 2 | Saf | Test 1 | [NAME] 2nd | [NAME] | Test 1 | Ind | Test 4 | Ind | Test 3 | Ind | Test 2 | Ind | Test 1 | Win | Test 3 | Win | Test 2 | Win | Test 1 | Ind 4th | Ind | Test 3 | Ind | Test 2 | Ind | Test 1 | [NAME] | Test 2 | Sri 1st | Eng | Test 5 | Test 4 | Eng | Test 3 | Eng | Test 2 | Eng | Test 1
 |  | 9 | 81 | 83 | 25 | 0 | 53 | 101 | 99 | 0 | 32 | 79 | 4 | 17 | 24 | 8 | 87 | X | 5 | 2 | 123 | 17 | 18 | 39 | 65 | 38 | 158 | 5 | 140 | 20 | 45 | 55 | 1 | 4 | 3 | 31 | 53 | 56 | 45 | X | 7 | 2 | 75 | 142 | 49 | 196 | 60
Innings | 42 | count all scores
Dismissals | 4 | count all dismissals | ??
Not outs | nope | count all not outs. (not outs have the formula score/1
50's | 12 | all scores above 50 but less then 100
100's | 6 | all scores above 100
Runs | 2156 | sum of all scores
Average | 539 | runs divided by dismissals
Spreadsheet: 474382d1470746617-looking-for-easy-data-entry-to-output-monthly-calendar-view-calendar-inputs
Sheet: calendar inputs

Groups | Initative name | Start date | End date
Group 1 | Xyz | 2016-01-01 00:00:00 | 2016-01-15 00:00:00
Group 2 | xyx 1 | 2016-01-01 00:00:00 | 2016-02-28 00:00:00
Group 3 | xyx 2 | 2016-03-15 00:00:00 | 2016-03-30 00:00:00
Group 4 | xyx 3 | 2016-01-01 00:00:00 | 2016-01-15 00:00:00
Group 5 | [NAME] | 2016-01-01 00:00:00 | 2016-02-28 00:00:00
Group 6 | xyx 5 | 2016-03-15 00:00:00 | 2016-03-30 00:00:00
Group 7 | xyx 6 | 2016-01-01 00:00:00 | 2016-01-15 00:00:00
Group 8 | xyx 7 | 2016-01-01 00:00:00 | 2016-02-28 00:00:00
Group 9 | [NAME] | 2016-03-15 00:00:00 | 2016-03-30 00:00:00
Group 10 | xyx 9 | 2016-01-01 00:00:00 | 2016-01-15 00:00:00
Spreadsheet: kate_symes__18448__SP 15 pages
Sheet: DJ SP15

 |  |  | Firm | Volume | Firm | Volume | Sun & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | 24 HOUR | [NAME]
 | 2001-01-10 00:00:00 |  | 164.78 | 14800 | 129.9 | 2000
 | 2001-01-09 00:00:00 |  | 155.6 | 14000 | 129.75 | 3200
 | 2001-01-08 00:00:00 |  | 135.72 | 11600 | 102.7 | 2000
 | 2001-01-07 00:00:00 |  |  |  |  |  | 102.7 | 6000
 | 2001-01-06 00:00:00
 | 2001-01-05 00:00:00 |  | 139.35 | 10400 | 101.82 | 4400
 | 2001-01-04 00:00:00 |  | 146.31 | 6400 | 108.22 | 3600
 | 2001-01-03 00:00:00 |  | 146.92 | 4800 | 115.58 | 2400
 | 2001-01-02 00:00:00 |  | 143.57 | 2800 | 120 | 2600
 | 2001-01-01 00:00:00 |  |  |  |  |  | 120 | 7800
 | 2000-12-31 00:00:00 |  |  |  |  |  | 112 | 6000
 | 2000-12-30 00:00:00 |  | 135.5 | 4000 | 112 | 2000
 | 2000-12-29 00:00:00 |  | 176.02 | 3520 | 90.91 | 2200
 | 2000-12-28 00:00:00 |  | 174.87 | 3120 | 90.91 | 2200
 | 2000-12-27 00:00:00 |  | 239.8 | 2000 | 146.18 | 2200
 | 2000-12-26 00:00:00 |  | 257.67 | 3600 | 196.43 | 1712
 | 2000-12-25 00:00:00 |  |  |  |  |  | 224.43 | 8400
 | 2000-12-24 00:00:00 |  |  |  |  |  | 224.43 | 8400
 | 2000-12-23 00:00:00 |  | 291.25 | 3200 | 228.09 | 4400
 | 2000-12-22 00:00:00 |  | 291.25 | 3200 | 228.09 | 4400
 | 2000-12-21 00:00:00 |  | 291.25 | 3200 | 228.09 | 4400
 | 2000-12-20 00:00:00 |  | 283.65 | 8000 | 224.28 | 3600
 | 2000-12-19 00:00:00 |  | 276.47 | 6800 | 214.71 | 3400
 | 2000-12-18 00:00:00 |  | 242.3 | 5328 | 209.21 | 1072
 | 2000-12-17 00:00:00 |  |  |  |  |  | 209.8 | 3000
 | 2000-12-16 00:00:00 |  | 242.68 | 3728 | 216.75 | 1872
 | 2000-12-15 00:00:00 |  | 242.4 | 3328 | 216.75 | 1872