tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 862886d1710451980-offset-max-formula-to-return-data-for-a-specific-week-account-summary
Sheet: Account stmts

 | Week Number |  |  |  |  |  |  | Week Goal |  |  |  |  | Week Actual: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Owner: |  |  | AR |  |  |  |  | Type: |  | Above is good
 | # of new account statements
Week | 1
Cumulative | 1
Week | 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 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52
Goal | 0 | 0 | 0 | 0 | 0 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30
Actual | 0 | 0 | 0 | 0 | 0 | 30 | 30 | 20 | 10 | 4 | 30 | 30 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Cumulative Goal | 0
Cumulative Actual
Gap
Green
Red
Cumulative gap
cumulative green
cumulative red
 |  |  |  | Urgent Temporary Countermeasures
 |  |  |  | Date Identified |  |  | Location |  |  |  | Issue Description |  |  |  |  |  |  | Corrective Action(s) |  |  |  |  |  |  |  |  |  |  |  |  | Person Responsible to [NAME] |  |  |  |  |  |  | Required Due Date |  |  | Expected Due Date |  |  | Status
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -
 | RTC |  | 22 | 25 | 40 | 30 | 19 | 58 | 53 | 45 | 54 | 37 | 56 | 79 | 518
 | MSM |  | 106 | 90 | 137 | 157 | 240 | 251 | 249 | 193 | 335 | 256 | 274 | 521 | 2809 |  | 31 |  | 37
 | WIMS |  | 26 | 28 | 35 | 32 | 44 | 47 | 59 | 40 | 82 | 32 | 58 | 79 | 561 | 453 | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 140.3333333
 |  |  | First Half Avg
 | RTC |  | 18
 | MSM |  | 31
 | WIMS |  | 17 | 21
Spreadsheet: 880414d1728075697-adding-a-search-box-to-excel-combobox-solution-bvj-
Sheet: Sheet1

 | Job No | Client | Address | Description | DEBENHAM LEISURE CENTRE
 | 1517 | TERRY K Mr | Chestnut Farm, [NAME] | [NAME] conversion
 | 15126 | [NAME] R | Port Pleasant, Aldeburgh | Alterations & extension
 | 1751 | JONES M Mr | Land adj 16 Fawcett Rd, Aldeburgh | New house
 | 1760 | QUEEN [NAME]’S SCHOOL | Barnet | New Music Department
 | 18200 | MAWSON, Mr & Mrs | Moat Farm, [NAME] | [NAME] conversion
 | 1918 | ROBSON, [NAME] | New House, Park Road, Aldeburgh | Alts & Ext
 | 1999 | DAVIS, [NAME] | Unit B, Willoughby Arms | Planning & B Regs
 | 19106 | HAYWARD, [NAME] | Ashmoor Hall, Campsea Ashe | Erection New Agricultural Bldgs
 | 19178 | DEBENHAM LEISURE CENTRE | [NAME], Debenham | New Car Park
 | 19187 | RACKHAM, Paul Ltd | [NAME] | [NAME] grain silos to residential unit
 | 19199 | WATSHAM, Mr & Mrs M | 3 [NAME], [NAME] | New Bungalow
 | 19200 | VINEGROW Ltd | 1 The Thoroughfare, Harleston | [NAME] – replacement & extg barn with new dwlg
 | 19201 | RYDER-DAVIES & PARTNERS | [NAME] | Feasibility New Vet Surgery
 | 2060 | DAVIS, [NAME] | Rookery Farm, Cratfield | Agric barn Prior Approval
 | 2068 | COOPER B Mr | Lodge Farm, [NAME] | Class Q Residential conversion
 | 2069 | [NAME], Mr | [NAME], Sotherton | Main barn extension
 | 2070 | LAWSON R Mr | Hill House Farm, Stradbroke | Annexe
 | 2097 | [NAME] | Carlton Green Farm, Carlton | [NAME] conversion
 | 20123 | ECKFORD P Mr & Mrs | The Mill House, Cransford | New annexe conversion
 | 20128 | PORTER E Mr | Grange Farm, Framlingham | Renovation of Listed Building
 | 20172 | HAYWARD, [NAME] | 243-246 Ashe Row, [NAME] | Possible Development
 | 20223 | ALBOROUGH, Mr & Mrs | The Willows, Framlingham | Extension
 | 20225 | FULLER, Mr [NAME] | Peace Haven, [NAME] | Extension
 | 20237 | BOOTY T Mr | 12 Cullingford Close, [NAME] | Variation of condition
 | 2101 | TANNER G (Shalford) Ltd Builders Yard | The St, Shalford | Resubmission Planning
Spreadsheet: 376555d1423646600-inserting-values-based-upon-a-drop-down-box-selection-saa-tables-revised
Sheet: Sheet1

Investor Risk Profile |  | Conservative
Asset Class |  | Amount to be Invested |  | Proposed % | SAA | [NAME] |  |  |  | Conservative | Moderately Conservative | Moderate | [NAME] | Aggressive
Australian Shares |  | 500 |  |  |  |  |  |  |  | 0.1 | 0.16 | 0.22 | 0.29 | 0.36
International Shares |  | 600 |  |  |  |  |  |  |  | 0.09 | 0.14 | 0.22 | 0.29 | 0.36
Property |  | 200 |  |  |  |  |  |  |  | 0.06 | 0.1 | 0.1 | 0.1 | 0.13
Australian Fixed Interest |  | 300 |  |  |  |  |  |  |  | 0.28 | 0.2 | 0.14 | 0.08 | 0.04
International Fixed Interest |  | 300 |  |  |  |  |  |  |  | 0.27 | 0.2 | 0.14 | 0.07 | 0.04
Cash |  | 100 |  |  |  |  |  |  |  | 0.1 | 0.1 | 0.08 | 0.07 | 0.02
Alternatives |  | 150 |  |  |  |  |  |  |  | 0.1 | 0.1 | 0.1 | 0.1 | 0.05
Growth
Defensive
Spreadsheet: vkaminski__40900__CASH_GasMat_0400MyCopy
Sheet: EINC

ENRON BOOK INCOME ($000)
Current Year
Calendar Year
Months Of Operation
Enron Earnings From Project Income
Project Earnings Before Depr, Int, & Taxes
Less: Interest Expense - Senior Debt
Less: Interest Expense - Subordinated Debt
Less: US GAAP Depreciation
Project Book Income Restated To GAAP
Times: In Counry Tax Rate (Effective Tax Rate)
Less: In Country Tax Expense
Project Book Income Restated To US GAAP After Tax
Times: Enron's Ownership Percentage
 | Subtotal - Enron Earnings From Project Income
Enron Earnings From Other Income / (Expense)
Less: Withholding Tax - Dividends
Less: Interest Expense - Trapped Cash Loans |  |  | (1)
Plus: Development Fee Capitalized & Amortized |  |  | (1)
Plus: Development Fee Recognized Currently |  |  | (1)
Plus: Technical Service Fee |  |  | (1)
Less: Consulting Fees Paid At Enron Level |  |  | (1)
Less: Houston Overheads Not Included In Project Costs |  |  | (1)
Less: Political Risk Ins - Enron Equity Capitalized & Amort |  |  | (1)
Less: Political Risk Ins - Enron Equity Expensed Currently |  |  | (1)
Plus: Indemnity Fee Capitalized and Amortized |  |  | (1)
Plus: Indemnity Fee Recognized Currently |  |  | (1)
Less: Withholding Tax On Indemnity Fee |  |  | (1)
Less: US Tax Cost / (Benefit) On (1)'s Above
 | Subtotal - Enron Earnings From Other Income / (Expense)
Enron Earnings From Bridge Loans
 |  |  | (2)
 |  |  | (2)
 |  |  | (2)
Less: US Tax (Cost) / Benefit On (2)'s Above
 | Subtotal - Enron Earnings From Bridge Loans
Enron Combined Book Income
 | Subtotal - Enron's Project Book Income
 | Subtotal - Other Enron Income / (Expenses)
 | Subtotal - Enron Bridge  Loan
 | Enron Book Income Prior To Cost Of Funds Charge
 | Less: ENE Cost Of Funds Charge - Expensed Currently |  | (3)
 | Less: ENE Cost Of Funds Charge - Capitalized & Amortized |  | (3)
 | Less: US Tax (Cost) / Benefit On (3)'s Above
 | Enron Book Income Including Cost Of Funds Charge
 | Memo: Cumulative Book Income (Prior To Cost Of Funds Charge)
 | Memo: Cumulative Book Income (Including Cost Of Funds Charge)
 |  | w/o COF | w/ COF
Enron Avg Book Income (Yrs 1-5) - Comm Ops
Enron Avg Book Income (Project Life) - Comm Ops
Enron Equity Payback Year On Book Income
ENE Cost Of Funds Charge Calculation (COF)
Cumulative Equity Used
Less: Cumulative A-T Cashflow
Outstanding Equity Subject To Cost Of Funds Charge
Times: Enron Cost Of Funds Rate
 | ENE Cost Of Funds Charge / (Benefit)
 | Memo: Cumulative ENE Cost Of Funds Charge / (Benefit)
Spreadsheet: 819206d1677295253-combine-columns-with-matching-headers-book1
Sheet: Sheet1

Date | Person 1 | Person 2 | Person 1 | Person 1 | Person 1 | Person 3 | Person 2 |  |  | Person 2 | Person 3
Date 1 | 1 | 5 | 10 | 14 | 15 | 18 | 19
Date 2 | 2 | 6 | 11 |  | 16 |  | 20 |  | 2 | 6
Date 3 | 3 | 7 | 12 |  | 17 |  | 21 |  | 3 | 7
Date 4 | 4 |  | 13 |  |  |  |  |  | 4 | 19
Date 5 |  |  |  |  |  |  |  |  | 10 | 20
Date 6 |  |  |  |  |  |  |  |  | 11 | 21
Date 7 |  |  |  |  |  |  |  |  | 12
Date 8 |  |  |  |  |  |  |  |  | 13
Date 9 |  |  |  |  |  |  |  |  | 14
Date 10 |  |  |  |  |  |  |  |  | 15
Date 11 |  |  |  |  |  |  |  |  | 16
Date 12 |  |  |  |  |  |  |  |  | 17
Date 13
Date 14
Date 15
Date 16
Spreadsheet: 94902d1294671164-sum-conditional-range-example
Sheet: Sheet1

Year | Proj. Demand (m^3)
2009 | 158574341 |  | Total Reserves (m^3)
2010
2011
2012 |  |  | Demand Growth Rate
2013 |  |  | 0.03
2014
2015 |  |  | Year Reserves Depleted
2016
2017
2018
2019
2020
2021
2022
2023
2024
2025
2026
2027
2028
2029
2030
2031
2032
2033
2034
2035
2036
2037
2038
2039
2040
2041
2042
2043
2044
2045
2046
2047
2048
2049
2050
2051
2052
2053
2054
2055
2056
2057
2058
2059
2060
2061
2062
2063
2064
2065
2066
2067
2068
2069
2070
2071
2072
2073
2074
2075
2076
2077
2078
2079
2080
2081
2082
2083
2084
2085
2086
2087
2088
2089
2090
2091
2092
2093
2094
2095
2096
2097
2098
2099
2100
2101
2102
2103
Spreadsheet: b314d320-37a1-4763-ac16-7f462b302b92
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7413 | 9830 | Viktoriia | Kachan | UKR | 0 | 00:21:06 | 00:00:00 | 01:02:57 | 00:00:29 | 00:37:00 | 1 | 02:01:31
7413 | 11887 | Agnieszka | Cieslak | POL | 0 | 00:22:52 | 00:00:00 | 01:01:11 | 00:00:34 | 00:38:23 | 2 | 02:03:00
7413 | 53569 | Stefania | Ion | [NAME] | 0 | 00:21:09 | 00:00:00 | 01:09:12 | 00:00:43 | 00:42:37 | 3 | 02:13:41
7413 | 9842 | Cigdem | Gulgec | TUR | 0 | 00:23:58 | 00:00:00 | 01:09:01 | 00:00:40 | 00:44:23 | 4 | 02:18:02
7413 | 18753 | Monika | Mikova | BUL | 0 | 00:22:09 | 00:00:00 | 01:12:28 | 00:00:40 | 00:44:33 | 5 | 02:19:50
7413 | 9838 | [NAME] | [NAME] | TUR | 0 | 00:25:46 | 00:00:00 | [NAME] | 00:00:57 | 00:46:40 | 6 | 02:20:37
Spreadsheet: 94289d1294149844-return-defined-name-sample
Sheet: Sheet1

 | 10 | 11 | 12 | 13 | 14 | 15 | 20 | 21 | 22 | 23 | 24 | 25 | 30 | 31 | 32
1 | 421 | 421 | 111 | 522 | 312 | 111 | 512 | 512 | 421 | 121 | 111 | 251 | 511 | 521 | 511
2 | 512 | 511 | 411 | 421 | 321 | 121 | 512 | 111 | 422 | 521 | 512 | 522 | 312 | 511 | 112
3 | 421 | 311 | 522 | 511 | 311 | 112 | 112 | 412 | 421 | 321 | 511 | 321 | 522 | 521 | 511
4 | 321 | 321 | 412 | 111 | 111 | 411 | 112 | 321 | 112 | 421 | 112 | 322 | 511 | 321 | 521
5 | 421 | 512 | 251 | 312 | 322 | 311 | 112 | 311 | 421 | 311 | 111 | 412 | 411 | 421 | 251
 | 33 | 34 | 35 | 40 | 41 | 42 | 43 | 44 | 45 | 50 | 51 | 52 | 53 | 54 | 55
1 | 251 | 422 | 321 | 311 | 311 | 112 | 121 | 521 | 512 | 422 | 311 | 312 | 311 | 422 | 511
2 | 511 | 412 | 412 | 511 | 321 | 511 | 251 | 312 | 112 | 421 | 422 | 411 | 521 | 322 | 521
3 | 112 | 321 | 522 | 421 | 312 | 322 | 112 | 521 | 111 | 311 | 312 | 321 | 522 | 312 | 251
4 | 512 | 421 | 512 | 251 | 121 | 511 | 311 | 511 | 321 | 251 | 422 | 522 | 311 | 422 | 411
5 | 421 | 121 | 422 | 322 | 112 | 311 | 511 | 111 | 121 | 421 | 312 | 311 | 111 | 512 | 312
Spreadsheet: 160330d1339055289-x-axis-woes-does-not-display-book1
Sheet:  Algae

 |  | Pre-treatment
Date sampled |  | 2012-05-02 00:00:00 | 2012-05-03 00:00:00 | 2012-05-06 00:00:00 | 2012-05-07 00:00:00 | 2012-05-14 00:00:00 | 2012-05-21 00:00:00 | 2012-05-28 00:00:00 | 2012-06-04 00:00:00
 | Units
Total Algae | cells/ml | 300750 | 380800 | 44300 | 34250 | 79700 | 72360
Total Cyanophyta | cells/ml | 119750 | 263800 | 19750 | 11400 | 7700 | 15400 | 58400 | 110380
Microcystis aeruginosa | cells/ml | 118750 | 263000 | 19600 | 11400 | 7700 | 0 | 39000 | 85300
Aphanocapsa (cyan) | cells/ml | 0 | 0 | 0 | 0 | 0 | 9000 | 14400 | 14000
Planktolyngbya sp | cells/ml | 600 | 800 | 150 | 0 | 0 | 0 | 5000 | 3600
Geitlerinema (Cyano) | cells/ml | 400 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | cells/ml | 165000 | 98000 | 20250 | 19250 | 50000 | 15400 | 22580 | 40860
Diatoms (Bacillariophyta) | cells/ml | 16000 | 19000 | 4300 | 3600 | 22000 | 1960 | 1060 | 820
Total Cyanophyta Biovolume | mm3/L | 4 | 12.56 | 0.94 | 0.54 | 0.37 | 0.32 | 2.57 | 5.62
[NAME] | mm3/L | 3.98 | 12.55 | 0.94 | 0.54 | 0.37 | 0.31 | 2.55 | 5.58
[NAME] | mm3/L | 0.01 | 0.01 | <0.01 | 0 | 0 | 0 | 0.01 | 0.01
[NAME] | mm3/L | 0.01 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | mm3/L | 0 | 0 | 0 | 0 | 0 | 0.01 | 0.01 | 0.01
Spreadsheet: 583776d1532635975-index-match-for-sheet-name-in-another-workbook-md_de_dash-forum_help
Sheet: Actuals

 | Operating Income
 | Code | January | February | March | April | May | June | July | August | September | October | November | December
 | 033300-020
 | 033302-020
 | 033310-020
 | 054400-020
 | 063600-020
Spreadsheet: 719955d1613930043-how-to-find-different-carracter-test
Sheet: Sheet1

USA
USA
USA
FRA
ENG
ENG
ENG
ENG
ENG
USA
USA
USA
USA
USA
USA
FRA
ENG
ENG
Spreadsheet: 267768d1380198360-value-ranking-formula-ranking-formula
Sheet: Sheet1

 |  |  |  |  |  |  |  | Rank
 |  |  |  |  |  |  |  |  | 0.05833333333333333
 |  |  |  |  |  |  |  |  | 0.05714285714285714
 |  |  |  |  |  |  |  |  | 0.09375
 |  |  |  |  |  |  |  |  | 0.1071428571428571
 |  |  |  |  |  |  |  |  | 0.06493506493506493
 |  |  |  |  |  |  |  |  | 0.07777777777777778
 |  |  |  |  |  |  |  |  | 0.06666666666666667
 |  |  |  |  |  |  |  |  | 0.07777777777777778
 |  |  |  |  |  |  |  |  | 0.06190476190476191
 |  |  |  |  |  |  |  |  | 0.05714285714285714
 |  |  |  |  |  |  |  | 1 | 0.3157894736842105
 |  |  |  |  |  |  |  |  | 0.05714285714285714
 |  |  |  |  |  |  |  | 2 | 0.1627906976744186
 |  |  |  |  |  |  |  |  | 0.07777777777777778
 |  |  |  |  |  |  |  |  | 0.05714285714285714
 |  |  |  |  |  |  |  |  | 0.08571428571428572
 |  |  |  |  |  |  |  |  | 0.06666666666666667
 |  |  |  |  |  |  |  |  | 0.08376963350785341
Spreadsheet: 96351d1295754935-cannot-solve-with-countif-function-countif
Sheet: Sheet1

NAME | START DATE | GROUP
A | 2011-01-11 00:00:00 | [NAME] |  | GROUP | [NAME]
B | 2011-01-15 00:00:00 | G2 |  | COUNT | 0
C | 2011-01-15 00:00:00 | G3
D |  | G2
E | 2011-01-12 00:00:00 | [NAME]
F |  | G2
G |  | G3
H | 2011-01-08 00:00:00 | G2
I |  | G2
J | 2011-01-17 00:00:00 | [NAME]
K |  | G2
Spreadsheet: 268697d1380739317-possible-vlookup-or-match-formula-to-return-results-approved-check-2
Sheet: Master

Search Term | BSE Material | BSE Category | MFG | Material Description | Market Cost per 1 | UM | Customer Material | Type | Generic | Total Savings Potential | CMIR2 | Savings per CMIR | Actual QTY | Potential QTY | Actual [NAME] | Potential [NAME] | Savings | Notes | Formula 1 | Formula 2
'006990023
 |  | Tools - Pulling Tape and Grips | NEPTCO | WP2500P/5000 POLY MULETAPE |  |  | '006990023 | Base
 |  | Tools - Pulling Tape and Grips | DURALINE ARNCO | BLWP25 6000FT 2500# [NAME] |  |  | '006990023 ALT3 | Alternate
 |  | Tools - Pulling Tape and Grips | NEPTCO | WP2500P 6000FT 2500# MUL REPL BY 2488244 |  |  | '006990023 ALT2 | Alternate
 |  | Tools - Pulling Tape and Grips | DURALINE ARNCO | BLWP25 5000FT 2500# [NAME] |  |  | '006990023 ALT1 | Alternate
 |  | Tools - Pulling Tape and Grips | DURALINE ARNCO | DLWP25S 5000FT 2500# [NAME]
'005722003
 |  | Electric MRO and Wiring Materials | THOMAS & BETTS | TY5232MX LOCKING CABLE TIE 8.00IN |  |  | '005722003 | Base
 |  | Electric MRO and Wiring Materials | PANDUIT | PLT2S-C0 CABLE TIE  7.4L (188MM |  |  | '005722003 ALT1 | Alternate
 |  | Electric MRO and Wiring Materials | GB-GARDNER BENDER | 46-108UVB 8-IN 18LB UVB CBL TIE |  |  | '005722003 NEEDS APPROVAL 5 | Needs Approval
 |  | Electric MRO and Wiring Materials | TYTON CORPORATION | T18L0C2 CABL TIE 8IN BLACK 100/PK |  |  | '005722003 NEEDS APPROVAL 6 | Needs Approval
 |  | Electric MRO and Wiring Materials | NSI INDUSTRIES | 8180 8IN BLACK CABLE TIE |  |  | '005722003 NEEDS APPROVAL 7 | Needs Approval
 |  | Electric MRO and Wiring Materials | PANDUIT | PLT2M-C0 CABLE TIE  8.0L (203MM |  |  | '005722003 NEEDS APPROVAL 8 | Needs Approval
 |  | Electric MRO and Wiring Materials | IDEAL INDUSTRIES | IT2M-C0 CBL TIE, 8" 18LB, UVB |  |  | '005722003 NEEDS APPROVAL 2 | Needs Approval
 |  | Electric MRO and Wiring Materials | THOMAS & BETTS | TY232MX LOCKING CABLE TIE-BULK 8.00IN |  |  | '005722003 NEEDS APPROVAL 4 | Needs Approval
 |  | Electric MRO and Wiring Materials | THOMAS & BETTS | L-8-18-0-C CABLE TIE |  |  | '005722003 NEEDS APPROVAL 1 | Needs Approval
 |  | Electric MRO and Wiring Materials | BURNDY | CT18200C0 18LB UV NYLON CBL TIE |  |  | '005722003 NEEDS APPROVAL 3 | Needs Approval
Spreadsheet: 4706a6dc-9434-4040-9830-f29603c2a8f5
Sheet: Rate History

Rate History |  |  |  |  |  | Year over Year Change
Fund | Expense per Contact Hour by  Discipline | 2001 | 2000 | 1999 |  | 2001 | 2000
1 | Agriculture |  | 6.669999999999999 | 6.81
2 | Architecture and Precision Production Trades |  | 6.829999999999999 | 6.640000000000001
3 | Biology, Physical Sciences, and Science Technology |  | 5.69 | 5.51
4 | Business Management, Marketing, and Administrative Services |  | 6.129999999999999 | 6.22
5 | Career Pilot |  | 19.42 | 18.69
6 | Communications |  | 9.21 | 8.21
7 | Computer and Information Sciences |  | 6.319999999999999 | 5.44
8 | Construction Trades |  | 6.42 | 5.99
9 | Consumer and Homemaking Education |  | 5.139999999999999 | 5.35
10 | Engineering |  | 9.829999999999998 | 7.640000000000001
11 | Engineering Related |  | 6.71 | 6.42
12 | English Language, Lit, Philosophy, Humanities, & Interdisciplinary |  | 5.68 | 5.26
13 | Foreign Languages |  | 5.81 | 5.699999999999999
14 | Health Occupations - Dental Assistants, Medical Lab, and [NAME]. Degree Nursing |  | 8.92 | 9.04
15 | Health Occupations - Dental Hygiene |  | 12.64 | 11.21
16 | Health Occupations - Other |  | 6.26 | 6.51
17 | Health Occupations - Respiratory Therapy |  | 8.739999999999998 | 8.64
18 | Health Occupations - Vocational Nursing |  | 6.999999999999999 | 5.76
19 | Mathematics |  | 5.26 | 4.96
20 | Mechanics and Repairers - Automotive |  | 7.669999999999999 | 6.49
21 | Mechanics and Repairers - Diesel, Aviation Mechanics, and Transportation Workers |  | 7.819999999999999 | 7.32
22 | Mechanics and Repairers - Electronics |  | 7.329999999999999 | 6.470000000000001
23 | Physical Education and Fitness |  | 6.879999999999999 | 6.21
24 | Protective Services and Public Administration |  | 5.579999999999999 | 4.94
25 | Psychology, Social Sciences, and History |  | 5.17 | 4.97
26 | Visual and Performing Arts |  | 7.35 | 7.33
28 | Developmental Education - Math |  | 0 | 0
29 | Developmental Education - Reading/Writing |  | 0 | 0
 | Average
 | Median
 | Standard Deviation
Spreadsheet: 81727d1281889998-sorting-club-members-into-teams-database-example
Sheet: Master Sheet

1st XI | 2nd XI | 3rd XI | 4th XI | 5th XI | Women's | Exiles | first_name | last_name | email | phone
y | y |  |  |  |  |  | [NAME] | [NAME] | [EMAIL] | 7524692455
 |  | y |  |  |  |  | Billy | Barrow | [EMAIL] | 7725489502
 | y | y |  |  |  |  | [NAME] | Calder | [EMAIL] | 7688499341
 | y |  |  |  |  |  | Dennis | Digby | [EMAIL] | 7850236489
y |  |  |  |  |  |  | [NAME] | Enstone | [EMAIL] | 7954674112
y | y |  |  |  |  |  | Fred | Forbes | [EMAIL] | 7567222164
Spreadsheet: 58810d1259074263-sumif-sum-range-bpsample
Sheet: Sample

Cost Centre | Saving | Project | [NAME] (000's) |  |  |  |  |  |  |  |  |  |  |  | F10 Total | F11 (000's) | Planned Implemented Date | Status | Type | Start Date
 |  |  | ACT | FCST | FCST | FCST | FCST | FCST | FCST | FCST | FCST | FCST | FCST | FCST
 |  |  | 2009-11-01 00:00:00 | 2009-12-01 00:00:00 | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00
1235 | Run Rate Reduction | Project # 1 | 0 | 0 | 0 | 13.88888888888889 | 13.88888888888889 | 13.88888888888889 | 13.88888888888889 | 13.88888888888889 | 13.88888888888889 | 13.88888888888889 | 13.88888888888889 | 13.88888888888889 | 125 | 166.6666666666667 | 2010-02-01 00:00:00 | G | Comp | 2010-01-01 00:00:00
 | Capacity Creation | Project # 2 | 0 | 0 | 5.6 | 5.6 | 5.6 | 5.6 | 5.6 | 5.6 | 5.6 | 5.6 | 5.6 | 5.6 | 56 | 67.19999999999999 | 2010-01-01 00:00:00 | G | Comp | 2009-10-01 00:00:00
1236 | Run Rate Reduction | Project # 3 | 0 | 115 | 115 | 115 | 115 | 115 | 115 | 115 | 115 | 115 | 115 | 115 | 1265 | 1380 | 2009-12-01 00:00:00 | G | Comp | 2009-11-01 00:00:00
 | Capacity Creation | Project # 4 | 0 | 26.27272727272727 | 26.27272727272727 | 26.27272727272727 | 26.27272727272727 | 26.27272727272727 | 26.27272727272727 | 26.27272727272727 | 26.27272727272727 | 26.27272727272727 | 26.27272727272727 | 26.27272727272727 | 289 | 315.2727272727273 | 2009-12-01 00:00:00 | G | WIP | 2009-10-01 00:00:00
Total Run Rate |  | 0 | 115 | 115 | 128.8888888888889 | 128.8888888888889 | 128.8888888888889 | 128.8888888888889 | 128.8888888888889 | 128.8888888888889 | 128.8888888888889 | 128.8888888888889 | 128.8888888888889 | 1390 | 1546.666666666667
Total Cap Creation |  | 0 | 26.27272727272727 | 31.87272727272727 | 31.87272727272727 | 31.87272727272727 | 31.87272727272727 | 31.87272727272727 | 31.87272727272727 | 31.87272727272727 | 31.87272727272727 | 31.87272727272727 | 31.87272727272727 | 345 | 382.4727272727272
Total Completed |  | 0 | 115 | 120.6 | 134.4888888888889 | 134.4888888888889 | 134.4888888888889 | 134.4888888888889 | 134.4888888888889 | 134.4888888888889 | 134.4888888888889 | 134.4888888888889 | 134.4888888888889 | 1446 | 1613.866666666667
Spreadsheet: 79003d1279232417-excel-2007-transposing-3-columns-into-multiple-columns-excel-forum-transpose-data
Sheet: Tranpose

Pupil Details |  | Hide | Aspirational Target
 | Subject | Helper
Name | Group | column
[NAME], [NAME] | Art&Des | [NAME], PeterArt&Des | B
[NAME], [NAME] | CreatArt | Allen, PeterCreatArt | A |  |  | Art&Des | CreatArt | D&T | English | Geography | History | Hu'ties | ICT | Maths | MFL | PE | Science
[NAME], [NAME] | D&T | [NAME], PeterD&T | A |  | [NAME], [NAME] | B | A | A | A | A* | A | A | A | A* | A | A | A*
[NAME], [NAME] | English | Allen, PeterEnglish | A |  | Allman, [NAME] | C | B | C | C | C | C | C | C | C | C | B | B
[NAME], [NAME] | Geography | Allen, PeterGeography | A* |  | [NAME],Mary | A | A | A | A | A | A | A | B | C | B | B | B
[NAME], [NAME] | History | Allen, PeterHistory | A
[NAME], [NAME] | Hu'ties | [NAME], PeterHu'ties | A |  |  | Art&Des | CreatArt | D&T | English | Geography | History | Hu'ties | ICT | Maths | MFL | PE | Science
[NAME], [NAME] | ICT | Allen, PeterICT | A |  | [NAME], [NAME] | B | A | A | A | A* | A | A | A | A* | A | A | A*
[NAME], [NAME] | Maths | Allen, PeterMaths | A* |  | Allman, [NAME] | C | B | C | C | C | C | C | C | C | C | B | B
[NAME], [NAME] | MFL | Allen, PeterMFL | A |  | [NAME],Mary | A | A | A | A | A | A | A | B | C | B | B | B
[NAME], [NAME] | PE | [NAME], PeterPE | A
[NAME], [NAME] | Science | Allen, PeterScience | A*
Allman, [NAME] | Art&Des | Allman, FredArt&Des | C
Allman, [NAME] | CreatArt | Allman, FredCreatArt | B
Allman, [NAME] | D&T | Allman, FredD&T | C
Allman, [NAME] | English | Allman, FredEnglish | C
Allman, [NAME] | Geography | Allman, FredGeography | C
Allman, [NAME] | History | Allman, FredHistory | C |  | Transposing 3 columns into multiple columns - Excel Help Forum
Allman, [NAME] | Hu'ties | Allman, FredHu'ties | C
Allman, [NAME] | ICT | Allman, FredICT | C
Allman, [NAME] | Maths | Allman, FredMaths | C
Allman, [NAME] | MFL | Allman, FredMFL | C
Allman, [NAME] | PE | Allman, FredPE | B
Allman, [NAME] | Science | Allman, FredScience | B
[NAME],Mary | Art&Des | [NAME],MaryArt&Des | A
[NAME],Mary | CreatArt | [NAME],MaryCreatArt | A
[NAME],Mary | D&T | [NAME],MaryD&T | A
[NAME],Mary | English | [NAME],MaryEnglish | A
[NAME],Mary | Geography | [NAME],MaryGeography | A
[NAME],Mary | History | [NAME],MaryHistory | A
[NAME],Mary | Hu'ties | [NAME],MaryHu'ties | A
[NAME],Mary | ICT | [NAME],MaryICT | B
[NAME],Mary | Maths | [NAME],MaryMaths | C
[NAME],Mary | MFL | [NAME],MaryMFL | B
[NAME],Mary | PE | [NAME],MaryPE | B
[NAME],Mary | Science | [NAME],MaryScience | B