tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 136774d1326817990-retrieve-values-from-every-nth-column-question
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RESULTS SHOULD READ:
ITEM 1 |  |  | 5 |  |  |  |  |  |  | 5 |  |  |  |  |  |  |  | 5 |  |  |  |  |  |  |  | 5 |  | 5 | 5 | 5 | 5
ITEM 2 |  |  | 4 |  |  |  |  |  |  | 4 |  |  |  |  |  |  |  | 4 |  |  |  |  |  |  |  | 4 |  | 4 | 4 | 4 | 4
ITEM 3 |  |  | 8 |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  | 8 |  | 8 | 8 | 8 | 8
ITEM 4 |  |  | 7 |  |  |  |  |  |  | 7 |  |  |  |  |  |  |  | 7 |  |  |  |  |  |  |  | 7 |  | 7 | 7 | 7 | 7
ITEM 5 |  |  | 9 |  |  |  |  |  |  | 9 |  |  |  |  |  |  |  | 9 |  |  |  |  |  |  |  | 9 |  | 9 | 9 | 9 | 9
ITEM 6 |  |  | 1 |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | 1 |  | 1 | 1 | 1 | 1
ITEM 7 |  |  | 2 |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  | 2 |  | 2 | 2 | 2 | 2
ITEM 8 |  |  | 3 |  |  |  |  |  |  | 3 |  |  |  |  |  |  |  | 3 |  |  |  |  |  |  |  | 3 |  | 3 | 3 | 3 | 3
ITEM 9 |  |  | 4 |  |  |  |  |  |  | 4 |  |  |  |  |  |  |  | 4 |  |  |  |  |  |  |  | 4 |  | 4 | 4 | 4 | 4
ITEM 10 |  |  | 5 |  |  |  |  |  |  | 5 |  |  |  |  |  |  |  | 5 |  |  |  |  |  |  |  | 5 |  | 5 | 5 | 5 | 5
ITEM 11 |  |  | 6 |  |  |  |  |  |  | 6 |  |  |  |  |  |  |  | 6 |  |  |  |  |  |  |  | 6 |  | 6 | 6 | 6 | 6
ITEM 12 |  |  | 7 |  |  |  |  |  |  | 7 |  |  |  |  |  |  |  | 7 |  |  |  |  |  |  |  | 7 |  | 7 | 7 | 7 | 7
Spreadsheet: 267982d1380330348-how-to-run-multiple-criteria-on-drop-down-lists-check
Sheet: Sheet1

 |  |  |  |  | Product | Cost |  | Product | Cost
1st Selection | 2nd Selection | Cost | 1. What i am looking forward to do is if the 1st selection contains products P,Q & R - and the 2nd selection contains products AA, BB, CC & DD then the cost of P,Q & R should be picked up from 'Pair 3' and added to the cost of AA/BB/CC/DD from pair 4. |  | A | 15.31 |  | AA | 9.35
P | CC |  |  |  | B | 21.27 |  | BB | 14.46
 |  |  | 2. If the 1st selection contains products A,B,C,D,E,F,G,H,I,J,K,L,M,N & O - and the 2nd selection is from Pair 4 - then the cost of A-O should be picked from either Pair 1 or Pair 2. |  | C | 29.78 |  | CC | 13.49
 |  |  |  |  | D | 45 |  | DD | 19.99
 |  |  | 3. if the 1st selection contains P,Q or R and the 2nd selection contains products EE,FF,GG or HH - then the cost of P,Q or R should be picked from pair 2 and the price of the later from pair 4. |  | E | 79 |  | EE | 12.87
 |  |  |  |  | F | 15.31 |  | FF | 18.38
 |  |  | 4. If the second selection is II - and the first selection is either P,Q or R - then the cost of P,Q & R should be picked from [NAME] but if the 1st selection is from A-O and 1nd selection is II then the cost of 1st selection should be picked from pair1. |  | G | 21.27 |  | GG | 17
 |  |  | Above The Red is as same as Condition 2 |  | H | 29.78 |  | HH | 23.5
 |  |  |  |  | I | 45 |  | II | 0
 |  |  |  |  | J | 79
 |  |  |  |  | K | 23
 |  |  |  |  | L | 29.5
 |  |  |  |  | M | 38
 |  |  |  |  | N | 55
 |  |  |  |  | O | 65
 |  |  |  |  | P | 20.75
 |  |  |  |  | Q | 27
 |  |  |  |  | R | 29.5
 |  |  |  |  | A | 15.31
 |  |  |  |  | B | 21.27
 |  |  |  |  | C | 29.78
 |  |  |  |  | D | 45
 |  |  |  |  | E | 79
 |  |  |  |  | F | 15.31
 |  |  |  |  | G | 21.27
 |  |  |  |  | H | 29.78
 |  |  |  |  | I | 45
 |  |  |  |  | J | 79
 |  |  |  |  | K | 23
 |  |  |  |  | L | 29.5
 |  |  |  |  | M | 38
 |  |  |  |  | N | 55
 |  |  |  |  | O | 65
 |  |  |  |  | P | 16.25
 |  |  |  |  | Q | 22.5
 |  |  |  |  | R | 25
Spreadsheet: 126300d1319625326-index-lookup-solution-example
Sheet: Summary

 |  | Entitlement | Remaining | Sick
[NAME] | Aberdeen
[NAME] | Aberdeen
[NAME] | Bellshill
[NAME] | Bellshill
[NAME] | Bellshill
[NAME] | Bellshill
[NAME] | Bellshill
[NAME] | Bellshill
[NAME] | Bellshill
[NAME] | Coleshill
[NAME] | Coleshill
[NAME] | Coleshill
[NAME] | Coleshill
[NAME] | Coleshill
[NAME] | Coleshill
[NAME] | Coleshill
[NAME] | Coleshill
[NAME] | Coleshill
[NAME] | Coleshill
[NAME] | Coleshill
[NAME] | Coleshill
[NAME] | Coleshill
[NAME] | Coleshill
[NAME] | Coleshill
[NAME] | Coleshill
[NAME] | Coleshill
[NAME] | Coleshill
[NAME] | Irlam
[NAME] | Irlam
[NAME] | Irlam
[NAME] | Irlam
[NAME] | Irlam
[NAME] | Irlam
[NAME] | Irlam
[NAME] | Irlam
[NAME] | Irlam
[NAME] | Irlam
[NAME] | Irlam
[NAME] | Irlam
[NAME] | Irlam
[NAME] | Irlam
[NAME] | Irlam
[NAME] | Irlam
[NAME] | Irlam
[NAME] | [NAME]
[NAME] | [NAME]
Clive Postill | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
Spreadsheet: 41296d1239792899-vlookup-from-multiple-sheets-shift-schedule
Sheet: SHIPPING

SHIPPING
[NAME]. | SAP NO. | NAME | SECTION
 | 640 |  |  | A
 | 805 |  |  | A
 | 616 |  |  | A
 | 1141 |  |  | A
 | 643 |  |  | A
 | 787 |  |  | A
 | 1101 |  |  | A
 | 1581 |  |  | A
 | 241 |  |  | A.
 | 1605 |  |  | A.
 | 206 |  |  | A.
 | 849 |  |  | A.
 | 291 |  |  | A.
 | 658 |  |  | B
 | 1774 |  |  | B
 | 1433 |  |  | B
 | 1330 |  |  | B
 | 2208 |  |  | B
 | 2220 |  |  | B
 | 2924 |  |  | B
 | 1082 |  |  | B
 | 477 |  |  | B.
 | 565 |  |  | B.
 | 1073 |  |  | B.
 | 546 |  |  | B.
 | 381 |  |  | C
 | 358 |  |  | C
 | 1501 |  |  | C
 | 657 |  |  | C
 | 1599 |  |  | C
 | 2216 |  |  | C
 | 1079 |  |  | C
 | 1159 |  |  | C
 | 2211 |  |  | C
 |  | 'A' SHIFT
 |  | 'B' SHIFT
 |  | 'C' SHIFT
 |  | 'G' SHIFT
 |  | TOTAL:
Spreadsheet: 839227d1691760105-counting-the-data-as-selecting-rows-pipe-size-sample
Sheet: sample

 |  |  | floors | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
 | Pipes | total length | height | 10 | 20 | 30 | 40 | 50 | 60 | 70 | 80 | 90
 | 10" | 210
 | 8" | 30
 | 6"
 | 4"
Spreadsheet: 031d51fb-45cf-4d05-a73f-fed715da74ca
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5609.0 Housing Finance, Australia
 | TABLE 12. HOUSING LOAN OUTSTANDINGS TO HOUSEHOLDS (OWNER OCCUPATION AND INVESTMENT HOUSING)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Owner-occupied housing ;  [NAME] ; |  |  | Original | A2435226X | 2002-03-01 00:00:00 | 2010-06-01 00:00:00 | 100 | $ Millions | STOCK | Month | 1
Owner-occupied housing ;  Permanent Building Societies ; |  |  | Original | A2435228C | 2002-03-01 00:00:00 | 2010-06-01 00:00:00 | 100 | $ Millions | STOCK | Month | 1
Owner-occupied housing ;  Credit Co-operatives ; |  |  | Original | A2435230R | 2002-03-01 00:00:00 | 2010-06-01 00:00:00 | 100 | $ Millions | STOCK | Month | 1
Owner-occupied housing ;  Total Authorised Deposit-taking Institutions (ADIs) ; |  |  | Original | A2435232V | 2002-03-01 00:00:00 | 2010-06-01 00:00:00 | 100 | $ Millions | STOCK | Month | 1
Investment housing ;  [NAME] ; |  |  | Original | A2435227A | 2002-03-01 00:00:00 | 2010-06-01 00:00:00 | 100 | $ Millions | STOCK | Month | 1
Investment housing ;  Permanent Building Societies ; |  |  | Original | A2435229F | 2002-03-01 00:00:00 | 2010-06-01 00:00:00 | 100 | $ Millions | STOCK | Month | 1
Investment housing ;  Credit Co-operatives ; |  |  | Original | A2435231T | 2002-03-01 00:00:00 | 2010-06-01 00:00:00 | 100 | $ Millions | STOCK | Month | 1
Investment housing ;  Total Authorised Deposit-taking Institutions (ADIs) ; |  |  | Original | A2435233W | 2002-03-01 00:00:00 | 2010-06-01 00:00:00 | 100 | $ Millions | STOCK | Month | 1
All residential housing ;  [NAME] ; |  |  | Original | A2435234X | 2002-03-01 00:00:00 | 2010-06-01 00:00:00 | 100 | $ Millions | STOCK | Month | 1
All residential housing ;  Permanent Building Societies ; |  |  | Original | A2435235A | 2002-03-01 00:00:00 | 2010-06-01 00:00:00 | 100 | $ Millions | STOCK | Month | 1
All residential housing ;  Credit Co-operatives ; |  |  | Original | A2435245F | 2002-03-01 00:00:00 | 2010-06-01 00:00:00 | 100 | $ Millions | STOCK | Month | 1
All residential housing ;  Total Authorised Deposit-taking Institutions (ADIs) ; |  |  | Original | A2435246J | 2002-03-01 00:00:00 | 2010-06-01 00:00:00 | 100 | $ Millions | STOCK | Month | 1
All residential housing ;  Securitisation Vehicles ; |  |  | Original | A2435238J | 2002-03-01 00:00:00 | 2010-06-01 00:00:00 | 100 | $ Millions | STOCK | Month | 1
All residential housing ;  Other Lenders ; |  |  | Original | A2435241W | 2002-03-01 00:00:00 | 2010-06-01 00:00:00 | 100 | $ Millions | STOCK | Month | 1
All residential housing ;  Total (Lender Housing) ; |  |  | Original | A2435244C | 2002-03-01 00:00:00 | 2010-06-01 00:00:00 | 100 | $ Millions | STOCK | Month | 1
© Commonwealth of Australia  2010
Spreadsheet: 16c0646d-9f7b-4557-b1f0-b5748af1739e
Sheet: 40

شركت ساختماني گسترش و نوسازي صنايع ايرانیان مانا(سهامي خاص)
يادداشتهاي [NAME] مالي
دوره مالي شش ماهه منتهي به 31 خرداد ماه 1390
29-حسابهاي [NAME]
سر فصل فوق به شرح زير قابل تفكيك است: |  |  | يادداشت |  | 1390/03/31 |  | 1389/09/30
 |  |  |  |  | ريال |  | ريال
اسناد [NAME] |  |  | 29-1
اسناد تضميني دريافتي |  |  | 29-2
سپرده هاي بانكي [NAME] ها |  |  | 29-3
جمع
29-1-اسناد [NAME] مي باشد:
 |  |  |  |  | 1390/03/31 |  | 1389/09/30
 |  |  |  |  | ريال |  | ريال
سفته هاي صادره به نفع ديگران |  |  |  |  | 547445232012 |  | 513847850312
ضمانتنامه هاي مانزد دیگران |  |  |  |  | 239778961284 |  | 200841655310
چكهاي صادره به نفع ديگران |  |  |  |  | 444547147160 |  | 375964636370
ضمانتنامه هاي شركت در مناقصه |  |  |  |  | 0 |  | 6532000000
سفته هاي تضميني در وجه صندوق آينده ساز بابت تضمين وام كاركنان |  |  |  |  | 0 |  | 40000000
29-2-اسناد تضميني دريافتي به نفع شرکت به شرح زير  مي باشد:
 |  |  |  |  | 1390/03/31 |  | 1389/09/30
 |  |  |  |  | ريال |  | ريال
اسناد تضمینی دیگران نزد شرکت - چک |  |  |  |  | 61378715558 |  | 77176136990
اسناد تضمینی دیگران نزد شرکت -  سفته |  |  |  |  | 28392573585 |  | 0
اسناد واخواهی شده |  |  |  |  | 14780900000 |  | 14780900000
چك و سفته هاي در يافتي از كاركنان بابت تضمين حسن انجام تعهدات |  |  |  |  | 0 |  | 6667000000
چك و سفته هاي دريافتي از كاركنان بابت وام |  |  |  |  | 0 |  | 1523500000
ضمانتنامه هاي دیگران نزد شركت |  |  |  |  | 9437082880 |  | 3220000000
29-3- سپرده هاي بانكي وثيقه شده نزد بانكها به منظور پشتوانه صدور ضمانتنامه بانكي به نفع كارفرمايان بوده كه پس از پايان موضوع ضمانتنامه و ابطال آن آزاد می گردد .
بانك | شعبه | [NAME] | نوع سپرده |  | 1390/03/31 |  | 1389/09/30
 |  |  |  |  | ريال |  | ريال
ملت | ملك الشعرا | [NAME] ( فیروزکوه ) | بلند مدت |  | 600000000 |  | 600000000
ملي | جم | دانشگاه صنعتی امیر کبیر | بلند مدت |  | 115009234 |  | 115009234
پاسارگاد | سلیمان خاطر | بلوارمعلم |  |  | 1140000000 |  | 1015000000
پاسارگاد | سلیمان خاطر | تصفیه آب شرب مشهد |  |  | 260000000 |  | 260000000
پاسارگاد | سلیمان خاطر | توسعه اماکن ورزشی |  |  | 470500000 |  | 0
پاسارگاد | سلیمان خاطر | [NAME] |  |  | 270500000 |  | 0
پاسارگاد | سلیمان خاطر | خراسان رضوی بانک صادرات |  |  | 182500000 |  | 0
پاسارگاد | سلیمان خاطر | [NAME] |  |  | 30500000 |  | 0
پاسارگاد | سلیمان خاطر | ضمانت پیش پرداخت وحسن انجام تعهدات |  |  | 545500000 |  | 0
Spreadsheet: 40394d1238697638-excel-2007-inserting-multiple-rows-in-multiple-lines-list-separate-rows-with-n-spaces
Sheet: After

1 | 570.8228058468814 | 688.1963421786801 | 828.1519198891549 | 327.3459957663931 | 96.68884575497128 | 539.692243342694 | 592.2167571625652 | 453.3385319354048 | 714.9932608791953
2
3
4
5 | 611.9208627815153 | 217.7834195692725 | 433.4778297105144 | 811.7622496759884 | 549.9567872332532 | 150.1438529831467 | 409.7759062523021 | 217.8869950972411 | 195.8112012619342
6
7
8
9 | 191.2080688165192 | 530.424339008885 | 195.4453723488197 | 236.1864365393282 | 699.7834633254598 | 476.9444046718574 | 647.8870062533792 | 464.040358817908 | 866.6678556819795
10
11
12
13 | 810.4591768169012 | 662.5440676582981 | 275.4568311648899 | 355.4812727250693 | 943.5426946076966 | 396.252613897885 | 77.35814490647464 | 457.1548656404341 | 234.5764803117307
Spreadsheet: 270051d1381352989-counting-thing-based-on-multiple-criteria-ef_example
Sheet: Sheet1

! | @ | # | % | ^ | * | &
Y | N | N | Y | N | Y | N
x | c | v | j | 8 | r | q
c | r | 8 | y | p | q | p
v | v | u | c | q | j | 8
8 | j | c | j | u | 8 | r
j | q | r | 8 | x | x | f
Spreadsheet: 101948d1300016584-automatically-lock-cells-cashflow-copia
Sheet: cashflowtemplate

Cash Flow (2008) ('000)
 | jan | feb | [NAME] | apr | may | jun | jul | aug | sept | oct | nov | dec
Grants | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Sales
Total Cash Inflow | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Payments
Wages
Advertising
Rent
Other overhead costs
Total Cash Outflow | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Net cash flow | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Opening Balance
Closing Balance
Spreadsheet: 774160d1648249668-find-unique-values-only-from-a-table-book1-udprocks-
Sheet: Sheet1

city | type | 2019 | 2020 | City & Type |  | Distinct City & Type | City | Type | 2019 | 2020
ajmer | A | 19 | 25
ajmer | A | 19 | 25
ajmer | B | 20 | 24
[NAME] | A | 16 | 10
[NAME] | B | 14 | 45
[NAME] | B | 14 | 45
udp | A | 12 | 13
udp | B | 14 | 15
udp | C | 23 | 22
Spreadsheet: 546725d1510167119-solver-how-to-find-the-lowest-possible-combinations-within-a-max-sum-limit-solver-combination-example
Sheet: Sheet2

DESTINATIONS
Destination ID | City | State | Mileage
NY1 | ROCHESTER | NY | 82
NY2 | BUFFALO | NY | 7
NY3 | BLASDELL | NY | 14
NY4 | BALLSTON SPA | NY | 284
NY5 | PHOENIX | NY | 161
NY6 | SANGERFIELD | NY | 208
NY7 | HENRIETTA | NY | 78
NY8 | BATAVIA | NY | 49
NY9 | SYRACUSE | NY | 158
NY10 | DEPEW | NY | 18
NY11 | HAMBURG | NY | 19
NY12 | WATERTOWN | NY | 221
NY13 | BEMUS POINT | NY | 77
NY14 | EAST SYRACUSE | NY | 161
NY15 | Orchard Park | NY | 21
NY16 | HORNELL | NY | 95
NY17 | LOCKPORT | NY | 33
NY18 | GENEVA | NY | 116
Maximum Mileage | 300
Spreadsheet: gerald_nemec__11529__Evaluation - Michelle Cash
Sheet: Sheet1

CANDIDATE EVALUATION FORM
Candidate: | Interviewer:
Requisition No. | Reports to:
Position: | Date:
Rate Candidate according to scale (5=highest, 1=lowest) in the following areas:
Customer Relations/Dealmaking | 5 | 4 | 3 | 2 | 1
Comments: | Build Relationships, Account Management, [NAME],
 | Select quality customers, Anticipate needs, Develop new ways to serve
 | customer, Propose workable deals, Negotiations, Closing.
Leadership/Visionary | 5 | 4 | 3 | 2 | 1
Comments: | Initiative, Motivating, Focus on results, Visionary thinking, Coaching,
 | Decision making, Performance measurement.
Industry Knowledge/Dealmaking | 5 | 4 | 3 | 2 | 1
Comments: | Knowledgeable about energy industry;  financial background,
 | physical  background.
Technical Knowledge/Financial/Derivatives | 5 | 4 | 3 | 2 | 1
Comments: | Specific to function, ability to learn and train others.
Strategic Skills/Innovation/Connecting/Leveraging: | 5 | 4 | 3 | 2 | 1
Comments: | Defining customer's problem/opportunity, [NAME] solve,Logical/
 | Analytical thought process, Product Development,Sees big picture,
 | Sees & defines new business opportunities.
Teamwork/Communications | 5 | 4 | 3 | 2 | 1
Comments: | Oral/Written communications,listening, team player, involves others,
 | shares information, values contributions.
Other Comments:
Overall Rating: | 5 | 4 | 3 | 2 | 1
 | [NAME] |  | Acceptable |  | Don't [NAME]
Obstacles to hiring this candidate:
Would  you like this candidate on your team: | Yes |  | No
Refer to other area:
Please return to:   [NAME]
Spreadsheet: kevin_hyatt__19599__Derailment_Summary
Sheet: Nov.Train Fuel Sum

Transwestern Pipeline Company
November 2000 Fuel Retention LOSE Estimate
$s Thou.
 |  | November Train Derailment Forecast
Retention Calculation
 |  | Displaced |  |  |  |  |  |  |  | Index
WEST |  | Daily Vol. |  | Fuel % |  | # Days |  | Retainage |  | Price
Thoreau to West |  | 0 | * | 0.045 | * | 4 | = |  | * | 5.04 | =
San Juan to West |  | 0 | * | 0.0475 | * |  | = |  | * |  | =
East of Thoreau to West |  | -313.66 | * | 0.05 | * |  | = |  | * |  | =
IG to El Paso Blnc |  | -95.4 | * | 0.0025 | * |  | = |  | * |  | =
San Juan to Thoreau/IG to I/B Link |  | -100 | * | 0.0025 | * | 1 | = |  | * |  | =
EAST - Retention |  | -100 | * | 0.0131 | * |  | = |  | * |  | =
TOTAL RETENTION
Less Fuel NOT Used * |  | 5 | * | 1 | * |  | = |  | * |  | =
Net Fuel Retention
Unaccounted for |  |  |  |  |  |  |  |  |  |  |  | 0
Net Fuel and Unaccounted for
(1) First of month index price used to calulate hedge gain/(loss)
1 |  | 53
 |  | 52
 |  | 50
 |  | 54
 |  | 54
 |  | 54
 |  | 54
 |  | 54
 |  | 53
Spreadsheet: 356041d1414951723-how-to-find-repeated-or-most-common-numbers-from-rows-max-repeat
Sheet: Sheet1

01 04 05 13 16 | 02 06 13 16 20 | 03 07 09 13 16 | 08 10 12 13 16 | 11 13 15 16 17 | 13 14 16 18 19
01 02 03 12 15 | 01 04 09 12 19 | 01 05 12 18 20 | 01 06 12 16 17 | 01 07 08 12 14 | 01 10 11 12 13
01 05 09 14 17 | 02 03 05 09 18 | 04 05 06 09 12 | 05 07 09 16 19 | 05 08 09 10 11 | 05 09 13 15 20
Spreadsheet: darron_c_giron__7992__midland_cogen
Sheet: firm9706

ENRON CAPITAL & TRADE RESOURCES
NETBACK AND FIRM CALCULATIONS
1997-06-01 00:00:00
IFGMR (TRKL/TX) |  |  | 2.22 |  |  | No. of Days: | 30
IFGMR (TRKL/LA) |  |  | 2.24
IFGMR (PEPL/TX/OK) |  |  | 2.13
IFGMR (ANR/LA) |  |  | 2.24
IFGMR (HENRY HUB) |  |  | 2.31
MIDLAND COGENERATION VENTURES
CONTRACT #16-60548-302 (Ultramar)
FIXED CONTRACT: | YEAR | PRICE | YEAR | PRICE
 | 1992 | 2.52 | 2001 | 3.93
 | 1993 | 2.4 | 2002 | 4.23
 | 1994 | 2.51 | 2003 | 4.73
 | 1995 | 2.61 | 2004 | 5.07
 | 1996 | 2.53 | 2005 | 5.43
 | 1997 | 2.65 | 2006 | 5.82 | JAN-SEP
 | 1998 | 2.67 | 2006 | 5.95 | OCT-DEC
 | 1999 | 2.9 | 2007 | 6.37
 | 2000 | 3.33
TERM: Through year 2004 ([NAME])  with annual renewal thereafter.
MaxDQ: 8500 MMBtu/DAY
MinDQ: 60% OF MaxDQ F7,000 MMBtu/DAY | DQ for December, January, and February, 80% of MaxDQ for all other months.
MIDLAND COGENERATION VENTURES
CONTRACT #016-60548-305 (Union Pacific)
PEPL VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.45 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS IFGMR(PEPL-TX/OK)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
TERM: JUNE 1, 1996 THROUGH SEPTEMBER 30, 2006
DESIGNATED QUANTITY -PEPL |  | 5000 | MMBTU/D
ANR VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.45 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS IFGMR (ANR/LA)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
TERM: JUNE 1, 1996 THROUGH SEPTEMBER 30, 2006
[NAME] -ANR |  | 4000 | MMBTU/D
TRKL/ LA-TRKL/TX AVG  VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.45 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS AVG IFGMR (TRKL/LA)/IFGMR(TRKL/TX)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
DESIGNATED TRKL TOTAL |  | 6000 | MMBTU/D
*Customer prefers rounding to nearest penny.
Spreadsheet: 152670d1335466600-which-formula-would-work-weatherdata1
Sheet: Calculations

 | Sensitive Receptor |  |  | Start Time | 11:00:00 | End Time | 11:27:00
 | Sum of N | Sum of E | Average Speed | Average Direction | Corrected Direction | Temp | Hum | Pressure
 | -118.0128795294 | -49.45872132320002 | 2.843507211022005 | 22.73836097375858 | 202.7383609737586 | 10.98611111111111 | 69.21428571428571 | 103.5029957142857
 | Upwind Receptor |  |  | Start Time |  | End Time
 | Sum of N | Sum of E | Average Speed | Average Direction | Corrected Direction | Temp | Hum | Pressure
 | 0 | 0 | 0 | #N/A | 0 | #N/A | #N/A | #N/A
 | Downwind Receptor |  |  | Start Time |  | End Time
 | Sum of N | Sum of E | Average Speed | Average Direction | Corrected Direction | Temp | Hum | Pressure
 | 0 | 0 | 0 | #N/A | 0 | #N/A | #N/A | #N/A
Spreadsheet: 31898d1227895341-find-two-min-values-and-asociate-them-with-there-type-example
Sheet: Sheet1

v | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
h1 | -4 | -3 | -2 | 0 | 2 | 3 | 2 | 2 | 0
h2 | -2 | -2 | 0 | 2 | 4 | 3 | 1 | -1 | -2
Spreadsheet: 787420d1657793110-find-data-in-cell-based-on-other-cell-test
Sheet: Sheet1

For WO | For Contract No | Part No | Description | In Stock | Qty | Qty Complete | Qty O/S | WO O/S | Date Required | On Order | Required | Complete | Part No2 | Description3 | WO No | UserDefinable2 | Production_Qty | Qty_Complete | SO Customer | Extra_Instructions_Non_RTF | Qty OS | Short | [NAME]
 |  | JBC1783/SL816G 7016 MATT D1036 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JBC1783/SL816G 7016 MATT D1036 - 17/07/2022_x000D_ JBC1822/SL816G 7016 MATT D1036 - 18/07/2022
 |  | JBC1822/SL816G 7016 MATT D1036 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JBC1783/SL816G 7016 MATT D1036 - 17/07/2022_x000D_ JBC1822/SL816G 7016 MATT D1036 - 18/07/2022
Spreadsheet: 104817d1302272522-searching-and-comparing-text-string-in-2-columns-notional-sheet
Sheet: Recommendations

Finding |  | Recommendation |  |  |  |  |  | Finding | Count
The blue bunny |  | Doesn't matter |  |  |  |  |  | green | 0
The green tree growns on the mountainside |  | Still doesn't matter |  |  |  |  |  | Fuzzy | 0
The Purple elephant showed up at midnight |  |  |  |  |  |  |  | Purple*showed | 0
Run fuzzy bunny, run |  | You get the point |  |  |  |  |  | black beans | 0
Black beans and rice |  | And |  |  |  |  |  | Blue | 0
I'll have a fuzzy navel please
And then his face turned green
Black bears are scary |  | I'm done
Spreadsheet: 765641d1643447868-vlookup-number-of-items-to-person-item-distirbution-
Sheet: Sheet1

Name |  | Salary | Leave | Sick | Items
[NAME] | Adam | 28 | 0 | 0 | 1 | Boat |  |  |  |  | 3 | Car A | 2 | Wire A | 4 | Laptops
 |  |  |  |  |  |  |  |  |  |  |  |  | 4 | Wire C | 3 | Computers |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Smith | [NAME] | 35 | 1 | 5 |  |  |  |  |  |  | 7 | Car B | 5 | Wire A | 5 | Laptops |  | Smith
 |  |  |  |  |  |  |  |  |  |  |  |  | 7 | Wire B | 10 | Computers |  | Smith
 |  |  |  |  |  |  |  |  | 3 | Bikes |  |  |  |  |  |  |  | Smith
Do | [NAME] | 50 | 2 | 3 |  |  |  |  |  |  | 2 | Car B | 3 | Wire C | 2 | Tablets |  | Do
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | Laptops |  | Do
Desired Results
Laptops
Computers
Tablets
Wire A
Wire B
Wire C
Car A
Car B
Spreadsheet: c1828654-024e-4469-8f07-20c5fde452da
Sheet: Sheet1

Bevölkerung des Freistaates Sachsen nach ausgewählten Altersgruppen | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
[NAME]
Alter von ... bis                     unter ... Jahren | 2011 | 2015 | 2020 | 2025
1 000
unter 20 | 3420 | 3385 | 3175 | 2829
20 - 65 | 14345 | 12963 | 11420 | 10091
65 und mehr | 5429 | 5706 | 6243 | 6700
Insgesamt | 23194 | 22054 | 20838 | 19620
%
unter 20 | 14.74519272225576 | 15.34868958012152 | 15.23658700451099 | 14.41896024464832
20 - 65 | 61.84789169612831 | 58.77845288836492 | 54.80372396583165 | 51.4322120285423
65 und mehr | 23.40691558161594 | 25.87285753151356 | 29.95968902965735 | 34.14882772680938
Insgesamt | 100 | 100 | 100 | 100
Abhängigkeitsquotient
Jugendquotient | 23.84105960264901 | 26.11278253490704 | 27.80210157618214 | 28.03488256862551
Altenquotient | 37.84593935169048 | 44.01758852117565 | 54.66725043782837 | 66.39579823605193
Gesamtquotient | 61.68699895433949 | 70.1303710560827 | 82.46935201401051 | 94.43068080467744
Gebietsstand: | 1. Januar 2012
Quelle: | 2011 Bevölkerungsfortschreibung auf Basis der [NAME] vom 03. Oktober 1990
 | 2012 - 2025 Bevölkerungsprognose
Bevölkerung jeweils am 31. Dezember
Prognoseergebnisse werden bei der Veröffentlichung immer auf volle [NAME] gerundet. [NAME] basieren [NAME] ungerundeten Werten. Beim [NAME] der [NAME] werden Ihnen die ungerundeten [NAME] zur Verfügung gestellt, damit [NAME] eigenen Berechnungen genauer durchführen können. Die Darstellung der Ergebnisse sollte dann aber wieder gerundet erfolgen.