tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 860224d1708412946-help-with-vlook-up-and-data-validation-google-sheet-exercise
Sheet: Worksheet 2

Pivot Table |  |  |  |  | Table A
 |  |  |  |  | Project Category | Bid Amount | Won or Lost | Budget Tier | Potential Revenue
 |  |  |  |  | MKTG ONLY | 103 | Won | $5,000 to $10,000 | 10800
 |  |  |  |  | MKTG ONLY | 106 | Won | $10,000 to $15,000 | 21600
 |  |  |  |  | WEB ONLY | 51 | Lost | $15,000 to $20,000 | 36764
 |  |  |  |  | MKTG ONLY | 77 | Lost | Above $20,000 | 26460
 |  |  |  |  | MKTG + WEB | 80 | Won | $10,000 to $15,000 | 19251
 |  |  |  |  | WEB ONLY | 100 | Lost | $15,000 to $20,000 | 14908
 |  |  |  |  | WEB ONLY | 73 | Lost | $15,000 to $20,000 | 14908
 |  |  |  |  | MKTG ONLY | 0 | Won | Below $5,000 | 21600
 |  |  |  |  | MKTG + WEB | 51 | Won | $15,000 to $20,000 | 34375
 |  |  |  |  | MKTG + WEB | 51 | Won | $5,000 to $10,000 | 38348
 |  |  |  |  | WEB ONLY | 208 | Lost | Below $5,000 | 16748
 |  |  |  |  | This is a list of the marketing bids that we have placed for the services we offer.
 |  |  |  |  | MKTG ONLY - Marketing bids only
 |  |  |  |  | MKTG + WEB - Marketing and Web bids
 |  |  |  |  | WEB - Web bids only
1 | INSTRUCTIONS: Build onto Pivot Table in cell A3.
 | Display the Project Category and Potential Revenue.
 | Show the winning Bid Amount per Project Category.
Spreadsheet: 468518d1467326886-finding-similar-issues-in-a-large-excel-dataset-sample_data
Sheet: Sheet1

ID | Description | Corresponding symbol |  | Symbol
c10015_g1_i1 | [NAME] indica TCP family protein | TCP |  | NAC
c10023_g1_i1 | [NAME] lycopersicum Ribosomal protein L30/L70 family protein | L30/L70 |  | WRKY
c10065_g1_i1 | Mtr Medicago truncatula CPP family protein | CPP |  | L30/L70
c10078_g1_i1 | [NAME] mays [NAME] family protein | FAR1 |  | [NAME]
c10092_g1_i1 | Phe Phyllostachys heterocycla HD-ZIP family protein | HD-ZIP |  | C2H2
 |  |  |  | CPP
 |  |  |  | NF-YA
 |  |  |  | TCP
 |  |  |  | CPP
 |  |  |  | FAR1
 |  |  |  | HD-ZIP
Spreadsheet: darrell_schoolcraft__7303__imball0201
Sheet: transcol

 | TransColorado
 | 500632
Day | Measured | Scheduled
1 | 106165 | 117417
2 | 117972 | 117437
3 | 124002 | 124207
4 | 100788 | 100788
5 | 104942 | 104207
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
2001-12-31 00:00:00 |  |  | 12821
2002-01-05 00:00:00
CBS Volume
 |  |  | -49782
Spreadsheet: 211781d1359934708-highlight-postcodes-across-entire-worksheet-martinsample
Sheet: Original

FIRST/FORNAME | SURNAME | TEL 1 | TEL 2 | DOB | [NAME] | PROVIDER | ADDRESS | POSTCODE
 |  |  |  |  |  |  |  |  | 4 | Chapel Road | [NAME] |  | Suffolk |  | IP17 1BH | PROVIDER
 |  |  |  |  |  |  |  |  | 4 | Oatfield Lane | [PHONE] | [PHONE] | Liverpool |  | [NAME] 0EY
 |  |  |  |  |  |  |  |  | 4 | [PHONE] | Faraday Street | Middlesbrough | [PHONE] | TS1 4EQ | PROVIDER
 |  |  |  |  |  |  |  |  | 4 | St  Andrews Estate |  | Cullompton | [NAME] | [NAME] | PROVIDER
 |  |  |  |  |  |  |  |  | 4 | [NAME] | DD1 1DD | [PHONE] | Sheffield | PROVIDER
 |  |  |  |  |  |  |  |  | 4 | Princess Ave | [PHONE] | Doncaster |  | DN7 5QN | PROVIDER
 |  |  |  |  |  |  |  |  | 4 | BEACON RISE | GATESHEAD |  | TYNE AND WEAR |  | NE9 6RJ |  | PROVIDER
 |  |  |  |  |  |  |  |  | 4 | Lincoln Green | [PHONE] | PROVIDER | Melksham |  | SN12 7RJ
 |  |  |  |  |  |  |  |  | 4 | Pear Close |  | [PHONE] | London |  | SE14 6DB |  | PROVIDER
 |  |  |  |  |  |  |  |  | 4 |  | West Drive | [PHONE] | Lancaster |  | LA1 5BY |  | .
Spreadsheet: 06c9ee9a-0198-4afa-b3fd-46141b554a28
Sheet: Sheet1

Drugs/Narcotics and Alcohol Involvement | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
by Offense Category, 2011
Offense Category | Total Offenses1 | Drugs/Narcotics and Alcohol Involvement
 |  | Drugs/ Narcotics | Percentage2 | Alcohol | Percentage2
Total | 5643241 | 339124 | 0.06009383614841188 | 250605 | 0.04440799179053313
Crimes Against Persons | 1321523 | 25375 | 0.01920133058599812 | 158520 | 0.1199525093396029
[NAME] | 1226300 | 22940 | 0.01870667862676343 | 150746 | 0.1229275055043627
Homicide Offenses | 3792 | 152 | 0.04008438818565401 | 251 | 0.06619198312236287
Kidnapping/Abduction | 15310 | 549 | 0.03585891574134552 | 1633 | 0.1066623122142391
Sex Offenses, Forcible | 69356 | 1608 | 0.02318472806966953 | 5657 | 0.08156468077743814
Sex Offenses, Nonforcible | 6765 | 126 | 0.01862527716186253 | 233 | 0.0344419807834442
Crimes Against Property | 3687952 | 30119 | 0.008166863343123772 | 51090 | 0.01385321717853161
[NAME] | 15467 | 115 | 0.007435184586539083 | 338 | 0.02185297730652357
Bribery | 293 | 17 | 0.05802047781569966 | 28 | 0.09556313993174062
Burglary/Breaking & Entering | 575394 | 4192 | 0.007285442670587458 | 4903 | 0.008521117703695208
Counterfeiting/Forgery | 74131 | 1635 | 0.02205555030958708 | 601 | 0.008107269563340572
Destruction/Damage/Vandalism | 810046 | 4217 | 0.005205877197097449 | 22531 | 0.02781446979554248
Embezzlement | 17000 | 183 | 0.01076470588235294 | 68 | 0.004
Extortion/Blackmail | 1217 | 18 | 0.01479046836483155 | 14 | 0.01150369761709121
Fraud Offenses | 245301 | 2895 | 0.01180182714297944 | 2377 | 0.009690135792353068
Larceny/Theft Offenses | 1683877 | 13291 | 0.007893094329336407 | 15899 | 0.009441901041465618
Motor Vehicle Theft | 161169 | 919 | 0.005702089111429618 | 1744 | 0.01082093951069995
Robbery | 72143 | 1138 | 0.01577422618965111 | 1663 | 0.0230514395021
[NAME] Offenses | 31914 | 1499 | 0.0469699818261578 | 924 | 0.028952810678699
Crimes Against Society | 633766 | 283630 | 0.4475311076959004 | 40995 | 0.06468475746568923
Drug/Narcotic Offenses | 550343 | 277831 | 0.5048324408596093 | 34547 | 0.06277357938594658
Gambling Offenses | 1238 | 34 | 0.02746365105008077 | 42 | 0.03392568659127625
Pornography/Obscene Material | 5791 | 41 | 0.007079951649110689 | 63 | 0.01087895009497496
Prostitution Offenses | 10213 | 381 | 0.03730539508469598 | 176 | 0.01723293841182806
Weapon Law Violations | 66181 | 5343 | 0.08073314093168735 | 6167 | 0.09318384430576751
1Drugs/Narcotics and Alcohol Involvement will not add to Total Offenses because this table shows only two aspects of Data Element 8, [NAME].
2Percentage is derived from Drugs/Narcotics and Alcohol Involvement as they relate to Data Element 8, [NAME].
Spreadsheet: 837809d1690448179-drop-down-chooses-defined-list-test-file-5-aligw
Sheet: Lookups

Ash PM
Duty (GP) A
Duty (GP) B
Duty (Salaried) A
Duty (Salaried) B
GP Anima AM
GP Anima PM
GP Routine AM
GP Routine PM
GP Triage AM (Salaried) A
GP Triage AM (Salaried) B
GP Triage AM A
GP Triage AM B
Minor Illness AM
Minor Illness PM
Salaried GP Anima AM
Salaried GP Anima PM
Salaried GP Routine AM
Salaried GP Routine PM
Spreadsheet: 190034d1351510618-merge-same-records-to-one-row-sample1-with-code_-2-
Sheet: Sheet1

Problem No. | Problem |  | Action Taken | Done by | Done on
121 | Oil Leakage |  | 1) 2pcs have sand-hole in thread, 2) one the M10 thread forms a through hole. | Ravi | 2012-10-01 00:00:00
121 | Oil Leakage |  | 1) 2pcs have sand-hole in thread, 2) one the M10 thread forms a through hole. | Ravi | 2012-10-01 00:00:00
122 | abnormal Noise | a | [NAME] | Raj | 2012-10-10 00:00:00
122 | abnormal Noise | a | [NAME] | Srinivasan | 2012-10-13 00:00:00
122 | abnormal Noise | b | Repared Part sent to Customer | Srinivasan | 2012-10-13 00:00:00
123 | Oil Leakage | a | Oil Changed | Ravi | 2012-10-01 00:00:00
123 | Oil Leakage | b | Oil Seal Replaced | Ravi | 2012-10-01 00:00:00
124 | Oil Leakage | c | Repared Part sent to Customer | Suresh | 2012-10-05 00:00:00
Spreadsheet: 681564d1591636658-index-a-datasheet-to-create-an-invoice-using-1-criterion-test_data_3
Sheet: Invoice

Customer |  |  |  |  |  |  |  |  |  |  |  | Misc |  |  |  | <<List>>
Name |  |  |  |  |  |  |  |  |  |  |  | Date |  |  |  | 2020-01-01 00:00:00
Address |  |  |  |  |  |  |  |  |  |  |  | Order No. |  |  |  | 2020-02-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | INVOICE NUMBER |  |  |  | 2020-03-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-04-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-05-01 00:00:00
Site |  |  |  |  |  |  |  |  |  |  |  | Invoiced by Date | 2020-10-01 00:00:00 |  |  | 2020-06-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-07-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-08-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-09-01 00:00:00
 |  | Description |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-10-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL |  |  | 2020-11-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-12-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | Sub Total
Spreadsheet: 1fa41163-0187-499f-be47-1122c8602d79
Sheet: Cost Factor

 |  | 2010/11
 | Total Adjusted Revenues
 | Administrative $
 | Facility $ (prior yr facilities allocation) | 4206660
 | Instructional Funding
 | Inst. Overhead Factor
 |  |  |  |  |  |  |  | Not Needed
 |  | 2010/11 Expenditures | 2010/11 Instructional Compensation | 2011/12 Total Credits | Instructional Cost per Credit | Departmental Cost per Credit | Institutional Cost per Credit | Departmental Overhead % | Calculated Faculty FTE | Actual Faculty FTE | Faculty Instructional Hours | IH_Cost | Department IH_Cost | Institutional IH_Cost | Revenue per Credit Hour | Instructional Break-Even Class [NAME] | Departmental Break-Even Class [NAME] | Institutional Break-Even Class [NAME] | Restricted Class Size | Cost Factor
 | Agriculture |  | 404624.43 |  |  |  |  |  |  | 3.219
 | Art & Music |  | 1124676.93 |  |  |  |  |  |  | 18
 | Biology |  | 996802.07 |  |  |  |  |  |  | 15.125
 | Chemistry & Biochemistry |  | 514254.34 |  |  |  |  |  |  | 8.875
 | Communication, Mass Media, & Theatre |  | 981628.61 |  |  |  |  |  |  | 13.11
 | English & Modern Langagues |  | 1878453.29 |  |  |  |  |  |  | 7.5
 | Pol Science & Criminal Justice |  | 762164.38 |  |  |  |  |  |  | 10.75
 | History & Political Science |  | 692558.3 |  |  |  |  |  |  | 10.625
 | Mathematics & Computer Science |  | 1448850.49
 | Physics |  | 604948.09 |  |  |  |  |  |  | 8
 | Accounting, Economics, & Finance |  | 1169666.86 |  |  |  |  |  |  | 15
 | Aerospace Studies
 | Management & marketing |  | 1279505.89 |  |  |  |  |  |  | 12.625
 | Security Studies & Criminal Justice
 | Teacher Education |  | 750714.67 |  |  |  |  |  |  | 10.67
 | Curriculum & Instruction |  | 766315.62 |  |  |  |  |  |  | 15.52
 | Kinesiology |  | 759352.23 |  |  |  |  |  |  | 10.805
 | Nursing |  | 2006062.14 |  |  |  |  |  |  | 30.125
 | Athletic Training
 | Physical Therapy |  | 805494.07 |  |  |  |  |  |  | 8
 | Psychology, Sociology & Social Work |  | 1074004.89 |  |  |  |  |  |  | 17
 | Academic Affairs |  | 60525 |  |  |  |  |  |  | 5.25 |  |  |  |  |  |  |  |  |  | 1
 | Total
Spreadsheet: 690275d1596995673-list-top-10-based-on-highest-values-in-a-table-puzzle-and-conquest
Sheet: Sheet1

Star Rating | Hero | Infantry Att | Infantry Def | Infantry HP | [NAME] | [NAME] | Range HP | Calvery Att | Calvery Def | Calvery HP | Seige Att | Seige Def | Seige HP | [NAME] | [NAME] | Troop HP | Total Inf Att | Total Inf Def | Total Inf Hp | Total Range Att | Total Range Def | Total Range HP | Total Calvary Att | Total Calvary Def | Total Calvary HP | Total Seige Att | Total Seige Def | Total Seige HP | Total Att | Total Def | Total HP
3 | Elros |  |  |  |  |  |  |  |  |  |  |  |  | 5
2 | Agnimp |  |  |  |  |  |  |  |  |  |  |  |  | 3
2 | Florine |  |  |  |  |  |  |  |  |  |  |  |  | 3
3 | Scarlet |  |  |  |  |  |  |  |  |  |  |  |  | 3
2 | Albertus |  |  |  |  |  |  |  |  |  |  |  |  | 3
3 | Eri |  |  |  |  |  |  |  |  |  |  |  |  | 2
3 | Talon |  |  |  |  |  |  |  |  |  |  |  |  | 2
2 | Lamassu |  |  |  |  |  |  |  |  |  |  |  |  | 2
2 | Naax |  |  |  |  |  |  |  |  |  |  |  |  | 2
3 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 1.5
3 | Cerno |  |  |  |  |  |  |  |  |  |  |  |  | 1.5
3 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 1.5
3 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 1.5
3 | Sakhir |  |  |  |  |  |  |  |  |  |  |  |  | 1.5
5 | Medusa |  |  |  |  |  |  |  |  |  |  |  |  | 1.2 | 0.096 | 0.096
4 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 1.2
4 | Apollo |  |  |  |  |  |  |  |  |  |  |  |  | 1.2
4 | Nilesh |  |  |  |  |  |  |  |  |  |  |  |  | 1.2
3 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 1.2
5 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 1
5 | Lux |  |  |  |  |  |  |  | 0.16 | 0.16 |  |  |  | 1
5 | Ryska |  |  |  |  |  |  |  |  |  |  |  |  | 1
5 | Sarbor |  |  |  |  |  |  |  |  |  |  |  |  | 1
5 | Sun Wukong |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0.064 | 0.064
5 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 0.064
5 | Zues |  |  |  |  |  |  |  |  |  |  |  |  | 1
4 | Deedoe |  |  |  |  |  |  |  |  |  |  |  |  | 1
4 | Fuga |  |  |  |  |  |  |  |  |  |  |  |  | 1
4 | Regina |  |  |  |  |  |  |  |  |  |  |  |  | 1
4 | Yune |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0.032 | 0.032
Spreadsheet: 138459d1327672803-pulling-sums-from-sheets-slinkyfoxcontracting
Sheet: Weekly Contractor Revenue

Weekly Contractor Revenue
Week Ending: | [NAME] | [NAME] | [NAME]
2012-01-29 00:00:00
Spreadsheet: 877449d1724273453-dynamic-table-01-copia
Sheet: F Caixa MO24

 | Contas | Nomes | janeiro-24 | fevereiro-24 | março-24 | abril-24 | maio-24 | junho-24 | julho-24 | agosto-24 | setembro-24 | outubro-24 | novembro-24 | dezembro-24
 | COBRANÇA | [NAME] | 14646936.87 | 11944613.95 | 6799413.529999999 | 17205776.09 | 10812481.16 | 10506787.92 | 11863688.32 | 0 | 0 | 0 | 0 | 0
 |  | [NAME] | 47312378.54000001 | 44646694.58 | 42324258.22 | 49884084.38 | 45377178.21000001 | 41569114.98 | 52060514.48999999 | 0 | 0 | 0 | 0 | 0
 |  | [NAME] | 4089191.7 | 5577350.44 | 6217078.71 | 6893914.7 | 6827199.67 | 5181606.34 | 6187703.32 | 0 | 0 | 0 | 0 | 0
 |  | [NAME] | 90236.86 | 93660.95 | 88427.77 | 101853.03 | 99237.28000000003 | 96990.69 | 112342.51 | 0 | 0 | 0 | 0 | 0
 |  | Total Cobrança
Spreadsheet: 744019d1628867633-formula-to-get-month-from-date-entered-for-last-13-months-sample-13-roll
Sheet: Sheet1

2021-07-31 00:00:00 | <--- date will produce the below A3 - M4
July | August | September | October | November | December | January | February | March | April | May | June | July
2020 | 2020 | 2020 | 2020 | 2020 | 2020 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021
2021-05-31 00:00:00 | <--- date will produce the below A11 - M12
May | June | July | August | September | October | November | December | January | February | March | April | May
2020 | 2020 | 2020 | 2020 | 2020 | 2020 | 2020 | 2020 | 2021 | 2021 | 2021 | 2021 | 2021
Spreadsheet: sally_beck__35041__MgmtSum-Q2-0501
Sheet: GrossMargin

PLAN2000
[NAME] | ENRON NORTH AMERICA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DEALS IDENTIFIED
2000-06-01 00:00:00 | 2ND QUARTER 2000 DETAIL OF GROSS MARGIN
M.QTD
ENA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Forecast Margin Calculation
 |  |  |  |  |  |  |  |  | Actual | Deals | Forecast | Total | Margin |  |  |  | Earnings Before Allocated Expenses
 | Business Team |  | DPR (1) | MPR | Accruals |  | Other | FTA | Margin | Identified | Margin | Margin | Plan | [NAME] |  |  | Plan | Forecast | [NAME]
GAS_TRAD | Gas Trading |  | 37748
[NAME] | Power Trading |  | 40629 |  |  |  | 0
IR_FX | Financial Drift |  | 9797
ECT_INV_IRFX | Financial Trading
TRD_MKT | Canada Trading |  | 4334 | 0 | 0 |  |  |  |  |  |  |  | 11556
COAL | Coal |  | 2342 | 67 | 73
WEATHER | GRM -  Weather |  | 246 | 0 | 0
SO2 | Emissions |  | -938
INSURANCE | GRM - New Products
 | Total Trading & Risk Management
E_ORG | East Midstream
W_ORIG | West Midstream |  |  | 494
DWNSTRM_IND_ORIG | Industrial Downstream
MDSTRM_IPP_ORIG | Midstream IPP
fin | Canada Origination & Finance |  |  | 1768 | 0 |  |  |  |  |  |  |  | 11556
MEXICO | Mexico
 | Total Origination
N_BS_DEV | Generation Investments |  |  |  |  |  |  |  |  |  |  |  | 12234
ASST_ORIG | ENA Upstream Assets |  | -44 |  | 15029 |  | 1990
ASST_TRD | ENA Upstream Assets - Trading
 | Total Assets
EQUITY | Principal Investing |  |  | -23517 | 0
PROD_FIN | Energy Capital Services |  |  | 293 | 0
ASST_MGT_AND_RESTRCT | Special Assets
CTG_ASSETS | CTG Assets |  |  | 5444 | 320
 | CTG Assets
 | Total Investing
CTG | Commercial Transactions Group
OF_CHAIR | Office of the Chairman
TREASURY_INT | Other Interest Related Charges |  |  | -4168 | -15200
 | Overview
 | Total
 | (1) Excludes Cap. Charge & Operating Costs
 | Check Figures
 | Gas Trading
 | Emerging Businesses
Spreadsheet: 852949d1702924425-if-statement-with-four-columns-to-choose-from-select-new-assignee-from-columns
Sheet: Sheet1

Client ID | Assigned employee 2023 | Office 1 | Office 2 | Office 3 | Assigned employee 2024 | If only B and C were in play… | Desired goal
105 | Connor | [NAME] |  |  | [NAME] |  | Keep column B, unless a new employee is assigned in C, D or E
109 | Connor |  |  | [NAME] | [NAME] |  | Keep column B, unless a new employee is assigned in C, D or E
111 | Connor |  |  | [NAME] | [NAME] |  | Keep column B, unless a new employee is assigned in C, D or E
171 | Connor |  |  |  | Connor |  | Keep column B, unless a new employee is assigned in C, D or E
172 | Connor |  | Jeremy | Kathy | ERROR |  | This should return an error or a caution, because we can’t have two new assignees
173 | Connor |  |  |  | Connor |  | Keep column B, unless a new employee is assigned in C, D or E
181 | Connor |  |  |  | Connor |  | Keep column B, unless a new employee is assigned in C, D or E
185 | Connor |  |  |  | Connor |  | Keep column B, unless a new employee is assigned in C, D or E
187 | Connor | [NAME] |  |  | [NAME] |  | Keep column B, unless a new employee is assigned in C, D or E
190 | Gayle |  |  |  | Gayle |  | Keep column B, unless a new employee is assigned in C, D or E
191 | Gayle |  |  |  | Gayle |  | Keep column B, unless a new employee is assigned in C, D or E
195 | Gayle |  |  |  | Gayle |  | Keep column B, unless a new employee is assigned in C, D or E
197 | Gayle |  |  |  | Gayle |  | Keep column B, unless a new employee is assigned in C, D or E
199 | Gayle |  | [NAME] |  | [NAME] |  | Keep column B, unless a new employee is assigned in C, D or E
Spreadsheet: 84831d1284924379-number-format-and-sum-function-book1
Sheet: Sheet1

Home team | Away team | Results
A | B | 32
A | C | 21
A | D | 30
A | E | 24
A | F | 23
So,goal difference for the team A should be  12-10
But when I use Sum (B3:B7 ) I get
Spreadsheet: gerald_nemec__11355__AEP Master Physical
Sheet: AMASTPSA 

MASTER FIRM PURCHASE/SALE AGREEMENT INFORMATION SHEET
ECT Entity: | ECT | ATTORNEY:
DATE: | 2001-03-19 00:00:00 | ECT CONTACT:
COUNTERPARTY: | AEP Energy Services, Inc. | CONTACT:
ADDRESS: |  | TITLE:
 |  | PHONE:
 |  | FAX:
INCORPORATION STATE: |  | S&P Rating
STRUCTURE | COUNTERPARTY | ECT ENTITY
COLLATERAL
THRESHOLD  in US$ | 10000000 | 5000000
COMMITTED VOLUMES
THRESHOLD in $[NAME] | n/a | n/a
COLLATERAL REQUIRED FOR:
ALL TRADES | x | x
OTHER | x | x
COLLATERAL TYPE
Letter of Credit | x | x
COLLATERAL  MULTIPLE | 250000 | 250000
GUARANTOR (RATING) | American Electric Power Company Inc. (A-) | Bridgeline Holdings, LP
LIMIT in $[NAME] | 10 | 5
Incorporation State: | ? | Deleware
MATERIAL ADVERSE CHANGE TRIGGERS  APPLY TO:
-Counterparty
-Guarantor | x | x
Debt Ratings Change | x
-Below = S&P | BBB-
Financial Covenants |  | x
-Funded Debt/Equity |  | (to be determined)
-Minimum Net worth
-Cash Flow/CMLTD
-Current Ratio
Non-Specific
-Unilateral
Ownership Change
-Less than 50.8% owned by:
Non-Standard Definitions
-Funded Debt
-Net Worth
-Cash Flow
EVENTS OF DEFAULT
3rd party debt | x | x
-Counterparty
-Guarantor ($[NAME]) | 50000000 | 15000000
FIN'L STATEMENTS
-Standard | X | X | Upon request
CREDIT DECISION: | APPROVED:  X | DECLINED:
OUTSTANDING PHYSICAL TRADES: |  | YES: | NO:
ALL TRADES TO ROLL UP UNDER NEW MASTER: |  | YES: | NO:
OTHER COMMENTS:
CREDIT REVIEW  PREPARED BY: |  | B. Reves | x-9897
Spreadsheet: 76186d1276719259-breaking-up-data-across-multiple-worksheets-np-transactions_5-29-10_1test
Sheet: Components

CARMICM | 56000002 | RS | 5008 | 33462
CARMICM | 56000002 | RS | 5008 | 23166
CARMICM | 56100002 | RS | 5009 | 4176
CARMICM | 56100002 | RS | 5009 | 8816
CARMICM | 68670150 | PR | 348177 | 4500
CARMICM | 68670253 | PR | 348176 | 2500
CARMICM | 68670257 | PR | 348176 | 1500
CARMICM | 68670323 | PR | 348177 | 3500
CARMICM | 68670327 | PR | 348177 | 5500
CARMICM | 68670428 | PR | 348176 | 1500
CARMICM | 68670429 | PR | 348176 | 1500
CARMICM | 68670515 | PR | 348177 | 3000
CARMICM | 68670618 | PR | 348177 | 3500
CARMICM | 00B00002 | PR | 348040 | 3888
CARMICM | 00B00002 | PR | 348040 | 5184
FREEMAJ2 | 33070806 | PR | 348309 | 315000
FREEMAJ2 | 68670533 | TO |  | 175
FREEMAJ2 | 68670605 | TO |  | 692
FREEMAJ2 | 00B12061 | PR | 348153 | 2310
FREEMAJ2 | 00B12061 | PR | 348155 | 25410
FREEMAJ2 | 00B12061 | PR | 348153 | 2310
FREEMAJ2 | 00B12061 | PR | 348153 | 2310
FREEMAJ2 | 00B12061 | PR | 348153 | 43890
FREEMAJ2 | 00BTL450 | PR | 348155 | 25410
FREEMAJ2 | 00BTL450 | TO |  | 2310
FREEMAJ2 | 00C00004 | TO |  | 214
FREEMAJ2 | 00C00004 | TO |  | 2000
NORMANS | 53607005 | PR | 347903 | 40
NORMANS | 53607005 | PR | 347903 | 48
NORMANS | 53607005 | PR | 347903 | 20
NORMANS | 53607005 | PR | 347903 | 192
NORMANS | 56000002 | TO |  | 15444
NORMANS | 00CAP656 | TO |  | 77000
NORMANS | 00CAP656 | TO |  | 77000
Spreadsheet: matthew_lenhart__26352__West Prices0530-01
Sheet: Power West Price Peak

 |  |  | 2001 |  |  | 2001 |  |  |  |  | 2002 |  |  |  |  | 2003 | 2004 |  |  | 2005-2014
Peak | 2000-08-01 00:00:00 | 2001-01-01 00:00:00 | 2001-02-01 00:00:00 | 2001-03-01 00:00:00 | 2001-04-01 00:00:00 | 2001-05-01 00:00:00 | 2001-06-01 00:00:00 | Q3-01 | Q4-01 | Cal-01 | Q1-02 | Q2-02 | Q3-02 | Q4-02 | Cal-02 | Cal-03 | [NAME] | Q1 | Q2 | Q3 | Q4 | Cal 05-14
MID-COLUMBIA | 0
COB | 0
NP15 | 0
ZP26 | 0
SP15 | 0
Palo Verde | 0
ROCKIES | 0
Price change |  |  | 2001 |  |  | 2001 |  |  |  |  | 2002 |  |  |  |  | 2003 | 2004 |  |  | 2005-2014
Peak | 2000-08-01 00:00:00 | 2001-01-01 00:00:00 | 2001-02-01 00:00:00 | 2001-03-01 00:00:00 | 2001-04-01 00:00:00 | 2001-05-01 00:00:00 | 2001-06-01 00:00:00 | Q3-01 | Q4-01 |  | Q1-02 | Q2-02 | Q3-02 | Q4-02 | Cal-02 | Cal-03 | [NAME] | Q1 | Q2 | Q3 | Q4 | Cal 05-14
MID-COLUMBIA | 0
COB | 0
NP15 | 0
ZP26 | 0
SP15 | 0
Palo Verde | 0
ROCKIES | 0
 |  |  | 2001 |  |  | 2001 |  |  |  |  | 2002 |  |  |  |  | 2003 | 2004 |  |  | 2005-2014
Peak | 2000-08-01 00:00:00 | 2001-01-01 00:00:00 | 2001-02-01 00:00:00 | 2001-03-01 00:00:00 | 2001-04-01 00:00:00 | 2001-05-01 00:00:00 | 2001-06-01 00:00:00 | Q3-01 | Q4-01 |  | Q1-02 | Q2-02 | Q3-02 | Q4-02 | Cal-02 | Cal-03 | [NAME] | Q1 | Q2 | Q3 | Q4 | Cal 05-14
MID-COLUMBIA | 0 | 0 | 0 | 0 | 0 | 100 | 230 | 280 | 191.6666666666667 | 218.125 | 150 | 75 | 171 | 68.33333333333333 | 116.0833333333333 | 57.41666666666666 | 46.6525 | 37.46636666666667 | 24.20576666666668 | 68.93 | 31.87243333333335 | 40.6186416666667
COB | 0 | 0 | 0 | 0 | 0 | 100 | 230 | 293.3333333333333 | 196.6666666666667 | 225 | 165 | 84.33333333333333 | 180 | 70.66666666666667 | 125 | 62.58333333333334 | 50.56916666666668 | 38.10433333333333 | 28.51299999999999 | 69.9 | 39.51300000000001 | 44.00758333333339
NP15 | 0 | 0 | 0 | 0 | 0 | 155 | 230 | 260.3333333333333 | 128 | 193.75 | 100 | 67 | 126 | 45 | 84.5 | 45.41666666666666 | 42.5 | 34.45333333333335 | 35.04 | 69.13333333333335 | 34.04 | 43.1666666666666
ZP26 | 0 | 0 | 0 | 0 | 0 | 150 | 230 | 259 | 115 | 187.75 | 98.33333333333333 | 84 | 130.3333333333333 | 57 | 92.41666666666667 | 45.16666666666666 | 41.66666666666666 | 33.715 | 35.04 | 65.5426512239002 | 34.02454540154229 | 42.08054915636054
SP15 | 0 | 0 | 0 | 0 | 0 | 150 | 230 | 260.6666666666667 | 115 | 188.375 | 81 | 69.33333333333333 | 135 | 43 | 82.08333333333333 | 50.41666666666666 | 46.08333333333334 | 37.25217116379137 | 39.15109582551638 | 70.69696911446701 | 36.78011845633126 | 45.97008864002643
Palo Verde | 0 | 0 | 0 | 0 | 0 | 150 | 250 | 301.6666666666667 | 116.6666666666667 | 206.875 | 80 | 75 | 180 | 45 | 95 | 45.95499538989043 | 40 | 37.90269435977837 | 37.24273312889584 | 59.68327474102461 | 31.48139266196002 | 41.57752372291468
ROCKIES | 0 | 0 | 0 | 0 | 0 | 150 | 250 | 301.6666666666667 | 116.6666666666667 | 206.875 | 80 | 75 | 180 | 45 | 95 | 45.95499538989043 | 40 | 37.90269435977837 | 37.24273312889584 | 59.68327474102461 | 31.48139266196002 | 41.57752372291468