tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 139503d1328279044-excel-2007-countif-problem-2011-stats
Sheet: HUN

Pos | Driver | Team | Nation | Points | Laps | [NAME] | Grid | Gained | Classification | Race Distance | Qualifying Time
1 | [NAME] |  |  | 25 | 70 | 00:01:23.937000 | 3 |  | 1 |  | 00:01:20.024000
2 | [NAME] |  |  | 18 | 70 | 00:01:23.875000 | 1 |  | 2 |  | 00:01:19.815000
3 | [NAME] |  |  | 15 | 70 | 00:01:23.711000 | 5 |  | 3 |  | 00:01:20.365000
4 | [NAME] |  |  | 12 | 70 | 00:01:23.661000 | 2 |  | 4 |  | 00:01:19.978000
5 | [NAME] |  |  | 10 | 70 | 00:01:23.718000 | 6 |  | 5 |  | 00:01:20.474000
6 | [NAME] |  |  | 8 | 70 | 00:01:23.415000 | 4 |  | 6 |  | 00:01:20.350000
7 | [NAME] |  |  | 6 | 69 | 00:01:25.935000 | 11 |  | 7 |  | 00:01:22.256000
8 | Sebastien Buemi |  |  | 4 | 69 | 00:01:25.977000 | 23 |  | 8 |  | 00:01:26.510000
9 | [NAME] |  |  | 2 | 69 | 00:01:24.857000 | 7 |  | 9 |  | 00:01:21.098000
10 | [NAME] |  |  | 1 | 69 | 00:01:26.025000 | 16 |  | 10 |  | 00:01:22.979000
11 | [NAME] |  |  | 0 | 69 | 00:01:24.664000 | 13 |  | 11 |  | 00:01:22.435000
12 | [NAME] |  |  | 0 | 69 | 00:01:24.664000 | 12 |  | 12 |  | 00:01:22.284000
13 | [NAME] |  |  | 0 | 68 | 00:01:25.018000 | 15 |  | 13 |  | 00:01:22.684000
14 | [NAME] |  |  | 0 | 68 | 00:01:25.579000 | 8 |  | 14 |  | 00:01:21.445000
15 | [NAME] |  |  | 0 | 68 | 00:01:24.999000 | 10 |  | 15 |  | 00:01:22.157000
16 | Pastor Maldonado |  |  | 0 | 68 | 00:01:25.724000 | 17 |  | 16 |  | 00:01:23.847000
17 | [NAME] |  |  | 0 | 66 | 00:01:28.022000 | 20 |  | 17 |  | 00:01:26.294000
18 | [NAME] |  |  | 0 | 66 | 00:01:28.876000 | 22 |  | 18 |  | 00:01:26.479000
19 | [NAME] |  |  | 0 | 65 | 00:01:29.068000 | 24 |  | 19 |  | 00:01:24.070000
20 | [NAME] |  |  | 0 | 65 | 00:01:29.208000 | 21 |  | 20 |  | 00:01:26.323000
21 | [NAME] |  |  | - | 55 | 00:01:27.149000 | 18 |  | RET |  | 00:01:24.362000
22 | [NAME] |  |  | - | 26 | 00:01:29.781000 | 9 |  | RET |  | 00:01:21.907000
23 | [NAME] |  |  | - | 23 | 00:01:30.826000 | 14 |  | RET |  | 00:01:22.470000
24 | Jarno [NAME] |  |  | - | 17 | 00:01:35.252000 | 19 |  | RET |  | 00:01:24.534000
Spreadsheet: 162515d1339942666-tryin-to-get-a-red-amber-green-colour-scheme-to-appear-within-a-certain-range-of-a-numbr-rhrp-planner_reply
Sheet: Sunday

Department Daily Schedule
Sun | 0600 | 0615 | 0630 | 0645 | 0700 | 0715 | 0730 | 0745 | 0800 | 0815 | 0830 | 0845 | 0900 | 0915 | 0930 | 0945 | 1000 | 1015 | 1030 | 1045 | 1100 | 1115 | 1130 | 1145 | 1200 | 1215 | 1230 | 1245 | 1300 | 1315 | 1330 | 1345 | 1400 | 1415 | 1430 | 1445 | 1500 | 1515 | 1530 | 1545 | 1600 | 1615 | 1630 | 1645 | 1700 | 1715 | 1730 | 1745 | 1800 | 1815 | 1830 | 1845 | 1900 | 1915 | 1930 | 1945 | 2000 | 2015 | 2030 | 2045 | 2100 | 2115 | 2130 | 2145 | 2200 | 2215 | 2230 | 2245 | 2300 | 2315 | 2330 | 2345 | Total
Vac 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Vac 2 |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Vac 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Vac 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Vac 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Total
Allowed Hours |  |  |  |  |  |  |  |  | 24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 37 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Variance +/-
Tills Open |  |  |  |  |  |  |  |  |  | 0 | 0
Spreadsheet: sara_shackleton__36847__shtanx
Sheet: A2_000615

EQUITY SWAP - SUMMARY ANNEX II
Counterparty | ECT Investments Inc. | Equity Payer: | ECT Investments Inc. | Date: | 2000-07-11 10:05:10.380000
[NAME]. #: | stkshts8.xls | Libor Payer: | MGT
Prepared By | [NAME] |  |  | Next Refix Date: | 2000-07-17 00:00:00
Annex Version # | 1 |  |  | Next Refix Payment Date: | 2000-07-20 00:00:00
Spread: | -0.007
1 Mo LIBOR Rate: | TBD
Initial Portfolio Details
Trade Date | Effective Date | Underlying Security | Number of Securities | Period Start Price | Notional
2000-06-15 00:00:00 | 2000-06-20 00:00:00 | Wisconsin Energy | 40100 | 21.1875 | 849618.75
2000-06-15 00:00:00 | 2000-06-20 00:00:00 | Ameren Corp | 35000 | 35.625 | 1246875
2000-06-15 00:00:00 | 2000-06-20 00:00:00 | Southern Co. | 30000 | 25.5625 | 766875
2000-06-15 00:00:00 | 2000-06-20 00:00:00 | Royal Dutch Petroleum | 66500 | 62.4375 | 4152093.75
2000-06-15 00:00:00 | 2000-06-20 00:00:00 | Smith International Inc | 50000 | 66.875 | 3343750
 |  |  |  | Period Start Portfolio Value: | 10359212.5
Additions / Unwinds |  |  | IPA Number |  | Initial Level
IPA Trade Date | IPA Effective Date | IPA Underlying Security | of Securities | IPA Price | for Payment | Notional
2000-06-20 00:00:00 | 2000-06-23 00:00:00 | Ameren Corp | -12300 | 35.1794 | 35.625 | -432706.62
2000-06-26 00:00:00 | 2000-06-29 00:00:00 | Southern Co. | -4000 | 25.0625 | 25.5625 | -100250
2000-06-27 00:00:00 | 2000-06-30 00:00:00 | Wisconsin Energy | -40100 | 20.9327 | 21.1875 | -839401.27
 |  |  |  |  | TOTAL | -1372357.89
CURRENT PORTFOLIO |  |  | Period Start Price / |  | New
Effective Date | Underlying Security | # of Equity Units | IPA Price |  | Notional
2000-06-23 00:00:00 | Ameren Corp | 22700 | 35.625 |  | 808687.5
2000-06-29 00:00:00 | Southern Co. | 26000 | 25.5625 |  | 664625
2000-06-20 00:00:00 | Royal Dutch Petroleum | 66500 | 62.4375 |  | 4152093.75
2000-06-20 00:00:00 | Smith International Inc | 50000 | 66.875 |  | 3343750
 |  |  |  | TOTAL: | 8969156.25
This Annex II sets forth the terms of the IPA as agreed to by Morgan the Counterparty on the applicable IPA Trade Date set forth
herein, relating to our Transaction with you originally done on May 17, 1999 (the "Transaction"), as set forth in a Confirmation for
such Transaction referenced # 5407304, with these new terms to take effect from and on the applicable IPA Effective Date as set
forth herein.  This Annex II supersedes any previous Annex II relating to these terms delivered to you.  All other terms of the
Transaction remain in full force and effect.
Approved:______________________________ |  |  | Approved:_______________________________
Marketer |  |  | Trader
Date:______________________________ |  |  | Date:__________________________________
Spreadsheet: 36567d1234449901-difficult-if-function-start-close
Sheet: Sheet1

Due Date | Work Start | Work End |  | Work Completed Date | Ticket | Asset | Work Assigned
2009-01-20 00:00:00 | 2009-01-20 20:30:00 | 2009-01-20 23:30:00 | -4:52 7:52 | 2009-01-20 15:37:26 | 1-373425 | headeuro101 | 2ndShiftCHI
2009-01-20 00:00:00 | 2009-01-20 20:30:00 | 2009-01-20 23:30:00 | 0:07 2:52 | 2009-01-20 20:37:26 | 1-373426 | headeuro102 | 2ndShiftCHI
2009-01-20 00:00:00 | 2009-01-20 20:30:00 | 2009-01-20 23:30:00 | 3:25 +0:25 | 2009-01-20 23:55:26 | 1-373427 | headeuro103 | 2ndShiftCHI
2009-01-20 00:00:00 | 2009-01-20 20:30:00 | 2009-01-20 23:30:00 | 19:07 +16:07 | 2009-01-22 15:37:26 | 1-373428 | headeuro104 | 2ndShiftCHI
2009-01-20 00:00:00 | 2009-01-20 15:30:00 | 2009-01-20 23:30:00 | 1:54 6:05 | 2009-01-20 17:24:07 | 1-373537 | clrtalsql | Coyle  Michael
2009-01-20 00:00:00 | 2009-01-20 20:30:00 | 2009-01-20 23:30:00 | -1:35 4:35 | 2009-01-20 18:54:57 | 1-373457 | optqs501 | 2ndShiftCHI
2009-01-20 00:00:00 | 2009-01-20 20:30:00 | 2009-01-20 23:30:00 | -1:35 4:35 | 2009-01-20 18:54:57 | 1-373458 | [NAME] | 2ndShiftCHI
2009-01-20 00:00:00 | 2009-01-20 16:30:00 | 2009-01-20 18:30:00 | 2:27 +0:27 | 2009-01-20 18:57:13 | 1-373484 | euro21 | 2ndShiftCHI
2009-01-20 00:00:00 | 2009-01-20 16:30:00 | 2009-01-20 19:30:00 | 2:27 0:32 | 2009-01-20 18:57:41 | 1-373536 | miifeed01 | 2ndShiftCHI
Spreadsheet: 769859d1645711784-is-this-doable-lookup-images-in-several-cells-fruit
Sheet: Fruit

Fruits | One | Two | Three | Image One | Image Two | Image Three | Image Four
Apples | 1 | 2 | 3
Oranges | 3 | 1 | 2
Pears | 2 | 3 | 1
Spreadsheet: 111888d1308147581-average-ffb7
Sheet: Sheet1

Cust ID | Outlet ID |  | Membership ID
000002658X | MIM |  | 000002658X
000002658X | SOU |  | 000010923X
000002658X | BRA |  | 000015491X
000002658X | PCP |  | 000025616X
000002658X | BKK |  | 000027253X
000002658X | ROW |  | 000029715X
000010923X | PRE |  | 000029729X
000010923X | GAR |  | 000033456X
000010923X | BDP |  | 000033988X
000010923X | CIR |  | 000034557X
000015491X | LMY |  | 000036339X
000015491X | INV |  | 000038589X
000025616X | WIN |  | 000038933X
000025616X | LON |  | 000044442X
000025616X | BKK |  | 000044568X
000025616X | FOU |  | 000046546X
000027253X | ELV |  | 000048832X
000029715X | CRW |  | 000049396X
000029715X | GRA |  | 000049723X
000029715X | BHF |  | 000050726X
000029729X | BUN |  | 000052752X
000029729X | KLE |  | 000056123X
000029729X | GOD |  | 000056333X
Spreadsheet: 104109d1301749977-if-function-with-less-than-or-equals-and-greater-than-parameters-if-values
Sheet: Sheet1

Value | Value I want returned |  | Number | Code
<=1 | A |  | 1
>1<=2 | B |  | 3
>2<=3 | C |  | 20
>3<=5 | D |  | 20
>5<=10 | E |  | 6
>10 | F |  | 1.8
 |  |  | 10
 |  |  | 12
 |  |  | 16
 |  |  | 8
 |  |  | 5.4
 |  |  | 3.2
 |  |  | 4.8
 |  |  | 2.7
 |  |  | 6
 |  |  | 50
 |  |  | 3.95
 |  |  | 0.8
 |  |  | 5.2
 |  |  | 9.6
 |  |  | 15.6
Spreadsheet: 0c0d0e39-7c28-468c-b1b3-fcb1ff6ad9ec
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Cuadro 4.1.08
[NAME]
Porcentaje de viviendas a nivel nacional por año, según combustible que se utiliza para cocinar, 2002, 2005-2007
Combustible que se utiliza para cocinar | CENSO 2002 | ENHOGAR 2005 | ENHOGAR 2006 | ENHOGAR 2007 | ENIGH 2007
Total | 100 | 100.4327353092128 | 100.1715418243551 | 99.95240437511099 | 100.1
Gas propano | 84 | 82.8376067363453 | 81.09548286865943 | 83.04263411617568 | 78.9
Carbón | 3 | 3.524809307470562 | 3.372195417340401 | 3.629459680723863 | 3.1
Leña | 10 | 9.832707500000861 | 9.369347313194364 | 9.32011158157413 | 10.4
Electricidad | 0 | 0.03339171656668209 | 0.01677907266458483 | 0.03050142158411317 | 1.2
[NAME] | … | 0.005534538657461119 | 0.01188024181989744 | … | 0
No cocina | 3 | 4.195733756221274 | 6.234072366398551 | 3.906821508865105 | 6.3
Otro | 0 | 0.00295175395064593 | 0.0717845442778909 | 0.02287606618808487 | 0.2
Fuente: Censo Nacional de Población y Vivienda 2002
Encuesta de Hogar de Propósitos Múltiples 2005-2006-2007
Encuesta Nacional de Ingresos y Gastos de los Hogares 2007
Spreadsheet: 716380d1612190418-pulling-data-from-a-table-that-changes-size-district-schedule-report-3-
Sheet: Page1_1

Schedule for District |  |  |  |  | Jan 31, 2021 - Feb 6, 2021
Property Id | Employee Name | Sunday 31/Jan | Monday 1/Feb | Tuesday 2/Feb | Wednesday 3/Feb | Thursday 4/Feb | Friday 5/Feb | Saturday 6/Feb
12345 | Employee A |  |  |  |  |  |  | 9:30 - 5:00
 | Employee B |  | 9:30 - 6:00
 | Employee C | 9:30 - 6:00 |  | 9:30 - 6:00 | 9:30 - 6:00 | 9:30 - 5:00
12346 | Employee C |  | 9:30 - 6:00
 | Employee D | 9:30 - 5:00 |  | 9:30 - 6:00 | 9:30 - 6:00 | 9:30 - 6:00 | 9:30 - 6:00 | 9:30 - 5:00
12347 | Employee E |  |  | 9:30 - 6:00 | 9:30 - 6:00
 | Employee F | 9:30 - 5:00 | 9:30 - 6:00 |  |  | 9:30 - 6:00 | 9:30 - 6:00 | 9:30 - 5:00
12348 | Employee G |  | 9:30 - 6:00 | 9:30 - 6:00 | 9:30 - 6:00 | 9:30 - 6:00 | 9:30 - 6:00 | 9:30 - 5:00
 | Employee B | 9:30 - 5:00
12349 | Employee H |  |  | 9:30 - 6:00 | 9:30 - 6:00 | 9:30 - 6:00 | 9:30 - 6:00 | 9:30 - 6:00
 | Employee I | 9:30 - 5:00 | 9:30 - 6:00
12350 | Employee J |  |  |  |  |  | 9:30 - 6:00 | 9:30 - 6:00
 | Employee K | 9:30 - 5:00 | 9:30 - 6:00 | 9:30 - 6:00 | 9:30 - 6:00 | 9:30 - 6:00
12351 | Employee L |  |  | 9:30 - 6:00 | 9:30 - 6:00 | 9:30 - 6:00 | 9:30 - 6:00 | 9:30 - 5:00
 | Employee J | 9:30 - 5:00 | 9:30 - 6:00
12352 | Employee B |  |  |  |  | 9:30 - 6:00
 | Employee I |  |  | 9:30 - 6:00 | 9:30 - 6:00 |  | 9:00 - 6:00
 | Employee E | 9:30 - 5:00 | 9:30 - 6:00 |  |  |  |  | 9:30 - 5:00
12353 | Employee J |  |  | 9:30 - 6:00 | 9:30 - 6:00
 | Employee M | 9:30 - 5:00 | 9:30 - 6:00 |  |  | 9:30 - 6:00 | 9:30 - 6:00 | 9:30 - 5:00
12354 | Employee A |  |  | 9:30 - 6:00 | 9:30 - 6:00
 | Employee N | 9:30 - 0:00 | 9:30 - 6:00 |  |  | 9:30 - 6:00 | 9:30 - 6:00 | 9:30 - 5:00
12355 | Employee O | 9:30 - 5:00 | 9:30 - 6:00 |  |  | 9:30 - 6:00 | 9:30 - 6:00 | 9:30 - 5:00
 | Employee B |  |  | 9:30 - 6:00
12356 | Employee P | 9:30 - 5:00 | 9:30 - 6:00 | 9:30 - 6:00 |  | 9:30 - 6:00 | 9:30 - 6:00 | 9:30 - 5:00
 | Employee B |  |  |  | 9:30 - 6:00
12357 | Employee A | 9:30 - 5:00 | 9:30 - 6:00
 | Employee Q |  |  | 9:30 - 6:00 | 9:30 - 6:00 | 9:30 - 6:00 | 9:30 - 6:00 | 9:30 - 5:00
 | Sun | Mon | [NAME] | Wed | Thurs | Fri | Sat
Employee A | 12357 | 12357 | 12345 | 12345 | OFF | OFF | 12345
Employee B
Employee C
Employee D
Employee E
Employee F
Employee G
Employee H
Employee I
Employee J
Employee K
Employee L
Employee M
Employee N
Employee O
Employee P
Employee Q
Spreadsheet: 88207d1288104549-pivot-reports-pareto-chart
Sheet: Sheet1

 | problem | count | percent of Total | cumulative total
 | not compatible | 23 | 30.66666666666666 | 30.66666666666666
 | does no perform as expected | 15 | 20 | 50.66666666666666
 | found at a cheaper price | 11 | 14.66666666666667 | 65.33333333333333
 | changed mind | 10 | 13.33333333333333 | 78.66666666666666
 | too complicated | 7 | 9.333333333333334 | 87.99999999999999
 | missing manual | 5 | 6.666666666666667 | 94.66666666666666
 | missing disk | 4 | 5.333333333333334 | 99.99999999999999
 | TOTAL | 75 | 99.99999999999999 | 99.99999999999999
Spreadsheet: 0478c1d9-8971-42cb-9381-88acdb976c25
Sheet: 10 Planning

10 | Chapter planning: Maintain an active planning process that guides chapter program and supports the lodge’s plans.
 |  | Have a written annual plan approved by the lodge executive committee; submit approved plan to district committee and/or executive. |  |  | [NAME] | 25
 |  | Conduct an annual review and update of your plan, in conjunction with your lodge’s plan |  |  | Silver | 50
 |  | Meet with the district committee and/or executive to review/update your plan |  |  | Gold | 100
 | Evaluate Achievement | Did the chapter create a written annual plan?
 |  | Did the lodge executive committee approve the chapter's written annual plan?
 |  |  | On what date?
 |  | Did the chapter submit the approved plan to the district committee and/or district executive?
 |  |  | On what date?
 |  | Did the chapter conduct an annual review and update of the plan?
 |  |  | On what date?
 |  | Did the chapter chief and adviser meet with the district committee and/or district executive to review/update the plan?
 |  |  | On what date?
 |  | What benefits did the chapter realize from maintaining a written annual plan?
 | Analyze the Past
 |  | How can the chapter achieve this goal more efficiently next year?
 | Plan for Next Year
Spreadsheet: 0c8082a9-411f-4431-aa51-0821042195d0
Sheet: Sheet1

Date | Sport | Opponent | Time | Results
09/04/2005 | Football | at Syracuse | 12:00 AM | W, 15-7
09/10/2005 | Football | WOFFORD | 12:00 AM | W, 35-7
09/17/2005 | Football | at Maryland | 12:00 AM | W, 31-19
[NAME] | Football | EAST CAROLINA | 12:00 AM | W, 20-15
10/01/2005 | Football | VIRGINIA TECH | 12:00 AM | L, 17-34
10/08/2005 | Football | at Rutgers | 12:00 AM | W, 27-14
10/15/2005 | Football | LOUISVILLE | 12:00 AM | W, 46-44 (3OT)
11/02/2005 | Football | CONNECTICUT | 12:00 AM | W, 45-13
11/09/2005 | Football | at Cincinnati | 12:00 AM | W, 38-0
11/24/2005 | Football | PITT | 12:00 AM | W, 45-13
12/03/2005 | Football | at USF | 12:00 AM | W, 28-13
01/02/2006 | Football | Georgia (Sugar Bowl) | 12:00 AM | W, 38-35
Spreadsheet: 69418d1269953045-two-way-lookup-sample-layout
Sheet: Sheet3

Country | Destination | Weight | Quarter | Price | Addition
DE | London | 30kg | 1 | 344 | 55
DE | London | 40Kg | 1 | 4334 | 55
DE | London | 50Kg | 1 | 4343 | 55
DE | London | 60Kg | 1 | 44 | 55
DE | London | 30kg | 2 | 344 | 0
DE | London | 40Kg | 2 | 4334 | 0
DE | London | 50Kg | 2 | 4343 | 0
DE | London | 60Kg | 2 | 44 | 0
DE | London | 30kg | 3 | 344 | 0
DE | London | 40Kg | 3 | 4334 | 0
DE | London | 50Kg | 3 | 4343 | 0
DE | London | 60Kg | 3 | 44 | 0
DE | London | 30kg | 4 | 344 | 0
DE | London | 40Kg | 4 | 4334 | 0
DE | London | 50Kg | 4 | 4343 | 0
DE | London | 60Kg | 4 | 44 | 0
DE | Sweden | 30kg | 1 | 66 | 55
DE | Sweden | 40Kg | 1 | 66 | 55
DE | Sweden | 50Kg | 1 | 66 | 55
DE | Sweden | 60Kg | 1 | 66 | 55
DE | Sweden | 30kg | 2 | 66 | 0
DE | Sweden | 40Kg | 2 | 66 | 0
DE | Sweden | 50Kg | 2 | 66 | 0
DE | Sweden | 60Kg | 2 | 66 | 0
DE | Sweden | 30kg | 3 | 66 | 0
DE | Sweden | 40Kg | 3 | 66 | 0
DE | Sweden | 50Kg | 3 | 66 | 0
DE | Sweden | 60Kg | 3 | 66 | 0
DE | Sweden | 30kg | 4 | 66 | 0
DE | Sweden | 40Kg | 4 | 66 | 0
DE | Sweden | 50Kg | 4 | 66 | 0
DE | Sweden | 60Kg | 4 | 66 | 0
DE | [NAME] | 30kg | 1 | 77 | 55
DE | [NAME] | 40Kg | 1 | 77 | 55
DE | [NAME] | 50Kg | 1 | 77 | 55
DE | [NAME] | 60Kg | 1 | 77 | 55
DE | [NAME] | 30kg | 2 | 77 | 0
DE | [NAME] | 40Kg | 2 | 77 | 0
DE | [NAME] | 50Kg | 2 | 77 | 0
DE | [NAME] | 60Kg | 2 | 77 | 0
DE | [NAME] | 30kg | 3 | 77 | 0
DE | [NAME] | 40Kg | 3 | 77 | 0
DE | [NAME] | 50Kg | 3 | 77 | 0
DE | [NAME] | 60Kg | 3 | 77 | 0
DE | [NAME] | 30kg | 4 | 77 | 0
DE | [NAME] | 40Kg | 4 | 77 | 0
DE | [NAME] | 50Kg | 4 | 77 | 0
DE | [NAME] | 60Kg | 4 | 77 | 0
Spreadsheet: 156047d1337161467-pivot-table-help-needed-calcuated-item-not-sure-pivot
Sheet: Pivot

[NAME] Mileage | Column Labels
Row Labels | AB56NNE | PX51ABC | PY52DRS | PY53EEA | ZX04LMA | Grand Total
2009
Jan |  |  |  | 0 |  | 0
Jun |  |  |  | 0 |  | 0
2010
Jan |  |  |  | 0 |  | 0
Dec | 184155 | 114855 | 121215 |  | 246269 | 246269
2011
Jan | 189885 | 119194 | 123684 |  | 250810 | 250810
Feb | 191409 | 122138 | 127455 |  | 253916 | 253916
Mar | 198577 | 127352 | 134763 | 97753 | 257650 | 257650
Apr | 202209 | 132256 | 141491 | 101742 | 264347 | 264347
May | 207914 | 134828 | 145085 | 109536 | 269909 | 269909
Jun | 208347 | 139141 | 151696 | 115877 | 276085 | 276085
Jul |  | 145361 | 158462 | 117678 | 281403 | 281403
Aug | 212119 | 151778 | 163591 | 119666 | 286710 | 286710
Sep | 217973 | 159870 | 169857 | 122470 | 292153 | 292153
Oct | 224461 | 165025 | 175846 | 129165 | 294420 | 294420
Nov | 230887 | 173032 | 192742 | 139423 |  | 230887
Dec | 240130 | 179313 |  | 149760 |  | 240130
2012
Jan | 248229 | 186918 | 195558 | 154878 |  | 248229
Feb | 251110 | 196035 | 202596 | 163970 |  | 251110
Mar | 252922 | 197927 | 212103 | 171237 |  | 252922
Apr | 254923 | 204402 | 212267 | 178153 |  | 254923
May | 258530 | 207528 | 213762 |  |  | 258530
Grand Total | 258530 | 207528 | 213762 | 178153 | 294420 | 294420
Spreadsheet: 194957d1353367828-help-with-bar-charts-or-something-better-to-compare-two-year-sales-charting-query-compare-2011-vs-2012
Sheet: CUSTOMER

Line Text | Corneal
Sales org. | 3580
Sum of   Netinv.sls | Period | SALES
Sold-to Name | 1.2011 | 2.2011 | 3.2011 | 4.2011 | 5.2011 | 6.2011 | 7.2011 | 8.2011 | 9.2011 | 10.2011 | 11.2011 | 12.2011 | Grand Total
CINCOTTA CHEMIST - BEAUMONT HILLS |  |  |  |  |  | 59.61 |  |  |  |  |  |  | 59.61
CINCOTTA CHEMIST - BELROSE |  | 432.32 |  | 307.5 | 267.48 | 59.61 |  | 224.4 |  | 155.28 | 165.81 | 53.43 | 1665.83
CINCOTTA CHEMIST - BLACKTOWN |  |  |  |  |  | 284.01 |  |  |  | 246.18 |  |  | 530.19
CINCOTTA CHEMIST - BURWOOD |  |  |  |  |  | 59.61 |  |  |  |  |  |  | 59.61
CINCOTTA CHEMIST - CARLINGFORD |  |  |  |  |  | 59.61 |  |  |  | 316.02 |  |  | 375.63
CINCOTTA CHEMIST - ENGADINE | 216.55 |  |  | 267.48 |  | 59.61 |  | 444.66 |  |  | 306.96 | 264.09 | 1559.35
CINCOTTA CHEMIST - FIVE DOCK |  |  | 256.5 |  | 556.74 | 59.61 |  | 224.4 | 1319.1 |  |  |  | 2416.35
CINCOTTA CHEMIST - MERRYLANDS | 1498.38 |  | 1475.82 | 414.06 | 921 | 1470.15 | 470.7 | 601.74 | 797.88 | 1025.33 | 665.25 | 1032.53 | 10372.84
CINCOTTA CHEMIST - NEUTRAL BAY | 242.31 |  | 368.22 |  |  | 59.61 |  |  |  |  | 483.81 |  | 1153.95
CINCOTTA CHEMIST - PIALBA |  |  |  |  |  | 59.61 | -59.61 |  |  |  |  |  | 0
CINCOTTA CHEMIST - REVESBY | 198.16 |  | 295.15 |  | 192.65 | 59.61 | 353.31 |  |  |  | 284.3 |  | 1383.18
CINCOTTA CHEMIST GLEBE | 112.2 |  |  | 306.96 |  | 59.61 | 363.81 |  |  |  | 369.58 |  | 1212.16
Grand Total | 2267.6 | 432.32 | 2395.69 | 1296 | 1937.87 | 2350.26 | 1128.21 | 1495.2 | 2116.98 | 1742.81 | 2275.71 | 1350.05 | 20788.7
Line Text | (All)
Sales org. | (All)
Sum of  Netinv.sls | Period | SALES
Sold-to Name | 1.2012 | 2.2012 | 3.2012 | 4.2012 | 5.2012 | 6.2012 | 7.2012 | 8.2012 | 9.2012 | 10.2012 | Grand Total
CINCOTTA CHEMIST - BELROSE | 612 | 195.39 |  |  | 94.2 |  |  | 0 | 223.32 |  | 1124.91
CINCOTTA CHEMIST - BLACKTOWN |  |  |  | 70.41 | 195.78 |  |  |  |  |  | 266.19
CINCOTTA CHEMIST - BURWOOD |  | 74.34 |  |  |  |  |  |  |  |  | 74.34
CINCOTTA CHEMIST - CARLINGFORD |  | 105.35 |  |  |  |  |  |  |  |  | 105.35
CINCOTTA CHEMIST - ENGADINE |  |  |  |  | 291.84 |  |  |  |  |  | 291.84
CINCOTTA CHEMIST - FIVE DOCK | 0 |  |  |  |  |  |  |  | 465.84 |  | 465.84
CINCOTTA CHEMIST - MERRYLANDS | 649.2 | 902.34 | 386.21 | 672.49 | 198.93 | 849.06 | 896.64 |  | 388.2 | 310.56 | 5253.63
CINCOTTA CHEMIST - NEUTRAL BAY | 289.36 | 151.68 | 223.77 |  | 202.62 | 273.72 |  |  |  |  | 1141.15
CINCOTTA CHEMIST - REVESBY |  |  |  |  | 254.77 |  |  |  |  |  | 254.77
CINCOTTA CHEMIST GLEBE |  | 224.4 |  |  | 194.76 |  | 433.86 |  | 386.22 |  | 1239.24
CINCOTTA DISCOUNT CHEMIST RIVERSTON |  |  |  |  |  |  |  | 242.94 |  |  | 242.94
Grand Total | 1550.56 | 1653.5 | 609.98 | 742.9 | 1432.9 | 1122.78 | 1330.5 | 242.94 | 1463.58 | 310.56 | 10460.2
Spreadsheet: 96194d1295611481-conditional-formating-issue-761038
Sheet: Sheet1

LONG DURATION |  | Starts / SR | 2007/08 | 2008/09 | 2009/10 | 2009/10 + / - than 2007/08 | 2009/10 + / - than 2008/09 | SR + / - than White U19
Under 19 | African | Starts | 819 | 666 | 660
 |  | Success Rate | 0.6764346764346765 | 0.7252252252252253 | 0.7575757575757576
 | [NAME] | Starts | 43 | 41 | 41
 |  | Success Rate | 0.6046511627906976 | 0.8292682926829268 | 0.6829268292682927
 | Caribbean | Starts | 641 | 659 | 808
 |  | Success Rate | 0.6365054602184087 | 0.7268588770864947 | 0.698019801980198
 | Chinese | Starts | 119 | 137 | 69
 |  | Success Rate | 0.8571428571428571 | 0.7591240875912408 | 0.7391304347826086
 | Indian | Starts | 30 | 19 | 32
 |  | Success Rate | 0.7333333333333333 | 0.7894736842105263 | 0.6875
 | Not Known | Starts | 142 | 83 | 74
 |  | Success Rate | 0.7394366197183099 | 0.6506024096385542 | 0.5540540540540541
 | Other | Starts | 243 | 196 | 195
 |  | Success Rate | 0.7078189300411523 | 0.6581632653061225 | 0.6358974358974359
 | Other Asian | Starts | 162 | 191 | 145
 |  | Success Rate | 0.5802469135802469 | 0.7958115183246073 | 0.7931034482758621
 | Other Black | Starts | 203 | 193 | 204
 |  | Success Rate | 0.7586206896551724 | 0.6787564766839378 | 0.6813725490196079
 | Other Mixed | Starts | 36 | 36 | 90
 |  | Success Rate | 0.6111111111111112 | 0.5833333333333334 | 0.6888888888888889
 | Other White | Starts | 272 | 294 | 266
 |  | Success Rate | 0.7132352941176471 | 0.8163265306122449 | 0.7443609022556391
 | Pakistani | Starts | 12 | 33 | 35
 |  | Success Rate | 0.5833333333333334 | 0.6666666666666666 | 0.6571428571428571
 | White British | Starts | 1169 | 1231 | 1905
 |  | Success Rate | 0.6903336184773311 | 0.7514216084484159 | 0.7202099737532809
 | White Irish | Starts | 28 | 24 | 39
 |  | Success Rate | 0.75 | 0.75 | 0.6410256410256411
 | White/ Black African | Starts | 84 | 55 | 74
 |  | Success Rate | 0.6547619047619048 | 0.6363636363636364 | 0.6891891891891891
 | White/Asian | Starts | 45 | 45 | 39
 |  | Success Rate | 0.7777777777777778 | 0.7555555555555555 | 0.7692307692307693
 | White/Black Caribbean | Starts | 193 | 212 | 268
 |  | Success Rate | 0.6217616580310881 | 0.7264150943396226 | 0.6977611940298507