tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 777106d1650170112-looking-for-a-formula-to-transpose-data-from-one-table-to-another-schedule-template
Sheet: Sheet1

Template 1 |  |  |  |  | Template 2
Column1 | 01.Bal | 02.Bal | 03.Bal |  |  | 2022-04-01 00:00:00 | 2022-04-02 00:00:00 | 2022-04-03 00:00:00 |  | Value | 01.Bal | 02.Bal | 03.Bal
[NAME] | Day | Day | Day |  | Day | [NAME] | [NAME] | [NAME] |  | Day | [NAME] | [NAME] | [NAME]
[NAME] | Night | Night | Night |  | Swing | [NAME] | [NAME] | [NAME] |  | Night | [NAME] | [NAME] | [NAME]
[NAME] | Swing | Swing | Swing |  | Night | [NAME] | [NAME] | [NAME] |  | Swing | [NAME] | [NAME] | [NAME]
Spreadsheet: 550232d1512161975-spreadsheet-to-automatically-compare-data-vs-the-same-day-last-year-example2
Sheet: Sheet1

 | Average Temperature
 | This Year | Last Year |  | vs Last Year |  | << difference in temperature returned in cell F2, updating with the new temperature difference after each new day input
2017-12-01 00:00:00 | 11 | 8
 | 10 | 9
 | 12 | 13
 |  | 12
 |  | 10
 |  | 9
 |  | 9
 |  | 9
 |  | 8
 |  | 9
 |  | 11
 |  | 13
 |  | 12
 |  | 11
 |  | 12
 |  | 13
 |  | 13
 |  | 13
 |  | 14
 |  | 14
 |  | 15
 |  | 16
 |  | 15
 |  | 14
 |  | 13
 |  | 13
 |  | 12
 |  | 12
 |  | 11
 |  | 11
 |  | 11
Spreadsheet: e07f82e8-7c03-4d74-a81b-66e1dc98f756
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2012-01-25 13:34:25.580000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.5 | 102.125 | 102 | 101.875 | 101.5 |  | and are added to price quote
4.375 | 102.006 | 101.881 | 101.756 | 101.381
4.25 | 101.649 | 101.524 | 101.399 | 101.024 |  | Note: | Refer To Price [NAME]
4.125 | 101.278 | 101.153 | 101.028 | 100.653 |  |  | For all Price Adjs
4 | 100.851 | 100.726 | 100.601 | 99.976
3.875 | 100.278 | 100.153 | 100.028 | 99.403
3.75 | 99.406 | 99.281 | 99.156 | 98.531
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.875 | 102.125 | 102 | 101.875 | 101.5
3.75 | 101.949 | 101.824 | 101.699 | 101.324
3.625 | 101.672 | 101.547 | 101.422 | 101.047
3.5 | 101.355 | 101.23 | 101.105 | 100.73
3.375 | 100.95 | 100.825 | 100.7 | 100.075
3.25 | 100.377 | 100.252 | 100.127 | 99.502
3.125 | 99.752 | 99.627 | 99.502 | 98.877 |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2012-02-08 13:34:25.580000
30 DAY | 2012-02-23 13:34:25.580000
45 DAY | 2012-03-09 13:34:25.580000
60 DAY | 2012-03-24 13:34:25.580000
90 DAY | 2012-04-23 13:34:25.580000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 731618d1620460536-counting-the-number-of-diagnosis-codes-by-context-specialty-and-provider-sample-data-excel-ans
Sheet: Output

contextid | specialtyname | providername | Diagnosis code | Count of Diagnosis code
78 | OB | TITLO | [NAME] | 3
78 | OB | TITLO | Z951 | 1
78 | OB | TITLO | E663 | 4
78 | OB | TITLO | M810 | 1
78 | OB | TITLO | N952 | 2
78 | OB | TITLO | E559 | 3
78 | OB | TITLO | Z1151 | 1
78 | OB | TITLO | Z780 | 2
78 | OB | TITLO | 286010 | 1
78 | OB | TITLO | Z713 | 1
712 | Medicine | JAGLO | Z00129 | 2
712 | Medicine | JAGLO | Z130 | 1
712 | Medicine | JAGLO | Z1388 | 1
712 | Medicine | JAGLO | Z713 | 3
712 | Medicine | JAGLO | Z6853 | 1
712 | Medicine | JAGLO | Z7182 | 2
712 | Medicine | JAGLO | Z6852 | 1
712 | Medicine | JAGLO | Z00121 | 1
712 | Medicine | JAGLO | H50011 | 1
712 | Medicine | JAGLO | Z6851 | 1
712 | Medicine | JAGLO | Z7182 | 1
712 | Medicine | JAGLO | H6693 | 1
712 | Medicine | JAGLO | T85628A | 1
712 | Medicine | JAGLO | Y838 | 1
Spreadsheet: 710559d1609099107-help-with-cost-forecasting-formulas-project-reporting-v8
Sheet: WBS

Capital / Capital Expense / Expense | WBS / Cost Center  Number | WBS / Cost Center   Name | Budget | Budget Committed | Budget Remaining
- | - | - | $ | $ | $
Capital | 1 | A | 100000
Capital Expense | 2 | B | 200000
Expense | 3 | C | 300000
Capital | 4 | D | 400000
Capital Expense | 5 | E | 500000
Expense | 6 | F | 600000
Capital | 7 | G | 700000
Capital Expense | 8 | H | 800000
Expense | 9 | I | 900000
Capital | 10 | J | 1000000
Spreadsheet: kevin_ruscitti__20272__market briefs
Sheet: Sheet1

Market Brief | Thursday, June 7
Stocks | Close | Change | % Change
DJIA | 11090.74 | 20.5 | 0.001851811704172629
DJ 15 Util. | 369.53 | -3.12 | -0.008372467462766684
NASDAQ | 2264 | 46.27 | 0.02086367592087404
S&P 500 | 1276.96 | 6.930000000000064 | 0.005456564018172849
Market Vols | Close | Change | % Change
AMEX (000) | 114276 | 3020 | 0.027144603437118
NASDAQ (000) | 1651733 | -120429 | -0.06795597693664575
NYSE (000) | 1087555 | 25239 | 0.0237584673486985
Commodities | Close | Change | % Change
Crude Oil (Jul) | 27.75 | 0.03000000000000114 | 0.001082251082251123
Heating Oil (Jul) | 0.7592 | -0.007199999999999984 | -0.009394572025052172
Nat. Gas (Henry) | 3.79 | -0.01100000000000012 | -0.002893975269665909
Palo Verde (Jul) | 173 | 0 | 0
COB (Jul) | 160 | 0 | 0
PJM (Jul) | 77.5 | 1 | 0.0130718954248366
Dollar US $ | Close | Change | % Change
Australia $ | 1.929 | -0.008000000000000007 | -0.004130098089829637
Canada $ | 1.523 | -0.002000000000000002 | -0.001311475409836067
Germany Dmark | 2.301 | -0.004999999999999893 | -0.002168256721595791
Euro | 0.85 | 0.002599999999999936 | 0.003068208638187321
Japan ¥en | 120 | -0.4000000000000057 | -0.003322259136212672
Mexico NP | 9.1 | -0.01999999999999957 | -0.002192982456140304
[NAME] | 0.7197 | 0.001299999999999968 | 0.001809576837416436
Foreign Indices | Close | Change | % Change
Arg MerVal | 450.98 | 11.79 | 0.02684487351715663
[NAME]. | 3367.2 | 12 | 0.00357653791130186
[NAME] | 15464.06 | 135.23 | 0.008821938791153634
Can TSE 300 | 8191.5 | -2.889999999999418 | -0.0003526803093335097
Germany DAX | 6184.25 | -8.1899999999996 | -0.001322580436790603
[NAME] | 13253.39 | 0 | 0
Japan Nikkei 225 | 13277.51 | 102.67 | 0.007792884012253665
[NAME] | 6840.63 | 49.65000000000055 | 0.007311168638399841
UK FTSE 100 | 5948.3 | 46.80000000000018 | 0.0079301872405321
Source:  Yahoo! & TradingDay.com
Spreadsheet: 162439d1339876877-search-multiple-spreadsheets-d-report-log-2012-2
Sheet: April 2012

NHSP-W DISCIPLINARY REPORT LOG
D-Report Number | Date | Inmate | Reporting Staff | Violation(s) |  |  |  |  | Date of Disposition | Date of Hearings | Outcome | Sanctions (in days) |  |  |  |  |  |  |  |  |  |  |  | Notes
 |  |  |  |  |  |  |  |  |  |  | PG, FWOP, BS, Inc, FG, FNG | P/S | [NAME] | XD | Lost Cant | Lost Rec | Lost Radio | Lost TV | Lost Phone | Lost Radio | Good Time | Lost Visit | Restitution
04-01
04-02
04-03
04-04
04-05
04-06
04-07
04-08
04-09
04-10
04-11
04-12
04-13
04-14
04-15
04-16
04-17
04-18
04-19
04-20
04-21
04-22
04-23
04-24
04-25
04-26
04-27
04-28
04-29
04-30
04-31
04-32
04-33
04-34
04-35
04-36
04-37
04-38
04-39
04-40
04-41
04-42
04-43
04-44
04-45
04-46
04-47
04-48
04-49
04-50
04-51
04-52
04-53
04-54
04-55
04-56
04-57
04-58
04-59
04-60
04-61
04-62
04-63
04-64
04-65
04-66
04-67
04-68
04-69
04-70
04-71
04-72
04-73
04-74
04-75
04-76
04-77
04-78
04-79
04-80
04-81
04-82
04-83
04-84
04-85
04-86
04-87
04-88
04-89
04-90
04-91
04-92
04-93
04-94
04-95
04-96
04-97
04-98
04-99
Spreadsheet: 94884d1294656730-help-needed-agent-stats-tracker-teamstats
Sheet: Team

 | 2011-01-17 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2011-01-18 00:00:00
 | PG | SP | CM | KD | LS | RO | RG | SF | AK | AM | KR | AH | PG | SP | CM | KD | LS | RO | RG | SF | AK | AM | KR | AH
[NAME] | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5
Packs Out | 2 | 4 | 6 | 8 | 10 | 12 | 14 | 16 | 18 | 20 | 22 | 24
Collections | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
Packs Back | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
FMP Out | 100 | 200 | 300 | 400 | 500 | 600 | 700 | 800 | 900 | 1000 | 1100 | 1200
FMP In | 50 | 100 | 150 | 200 | 250 | 300 | 350 | 400 | 450 | 500 | 550 | 600
Calls Taken | 2 | 4 | 6 | 8 | 10 | 12 | 14 | 16 | 18 | 20 | 22 | 24
Spreadsheet: 24b5b7d9-78a8-4001-9b12-50240bd354ca
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
42229579 | 2014-07-09 18:09:14 | AXIS | 0 | 4 | 7 | 560655 | fellini33 | 7597 | eastern | 1941-10-18 | 1941-10-18 | Gates of Moscow | Aux portes [NAME]
42229878 | 2014-07-09 18:33:41 | ALLIES | 0 | 2 | 7 | 560655 | fellini33 | 7597 | eastern | 1941-10-18 | 1941-10-18 | Gates of Moscow | Aux portes [NAME]
42238363 | 2014-07-10 08:52:15 | AXIS | 0 | 5 | 7 | 1228328 | Woodrow Call | 7597 | eastern | 1941-10-18 | 1941-10-18 | Gates of Moscow | Aux portes [NAME]
42238494 | 2014-07-10 09:16:15 | ALLIES | 0 | 4 | 7 | 1228328 | Woodrow Call | 7597 | eastern | 1941-10-18 | 1941-10-18 | Gates of Moscow | Aux portes [NAME]
42257345 | 2014-07-11 18:56:02 | AXIS | 1 | 7 | 6 | 1601877 | [NAME] | 7597 | eastern | 1941-10-18 | 1941-10-18 | Gates of Moscow | Aux portes [NAME]
42257667 | 2014-07-11 19:30:45 | AXIS | 0 | 4 | 6 | 1601877 | [NAME] | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
42258088 | 2014-07-11 20:05:03 | ALLIES | 0 | 5 | 6 | 1601877 | [NAME] | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
42258529 | 2014-07-11 20:23:32 | AXIS | 1 | 4 | 1 | 1601877 | [NAME] | 6158 | western | 1944-06-06 | 1944-06-06 | Pegasus Bridge | Pegasus Bridge
42258763 | 2014-07-11 20:49:50 | ALLIES | 1 | 4 | 2 | 1601877 | [NAME] | 6158 | western | 1944-06-06 | 1944-06-06 | Pegasus Bridge | Pegasus Bridge
42266142 | 2014-07-12 10:24:09 | ALLIES | 0 | 4 | 6 | 470347 | hilarion lefuneste | 6155 | western | 1944-09-19 | 1944-09-19 | Arracourt | Arracourt
42300896 | 2014-07-14 18:42:11 | ALLIES | 1 | 6 | 5 | 1301798 | muemo | 6152 | western | 1944-12-20 | 1944-12-22 | [NAME] | St. Vith
42375746 | 2014-07-20 08:59:33 | ALLIES | 1 | 6 | 2 | 943675 | [NAME] | 8043 | eastern | 1939-09-08 | 1939-09-26 | Battle of Warsaw | Bataille de Varsovie
Spreadsheet: 349286d1412266107-count-the-number-of-visits-by-visit-types-levi_example
Sheet: Data Table

Visit Type |  | Visit Counts |  |  |  | Average Room Time | [NAME] | Min | Average Clincian Contact Time | [NAME] | Min
 |  | Day 1 | Day 2 | Day 3 | Total
1
2
3
4
5
6
7
8
All | All Visit Types
Spreadsheet: 870064d1716567512-rota-generator-rota-test-tommartin123-
Sheet: Sheet1

 | Week 1
 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday |  | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday
Early | 3-1 | 4-1 | 3-1 | 4-1 | 5-8 | 2-1 | 5-5
 | 5-1 | 4-2 | 5-13 | 4-2 | 5-9 | 2-2 | 5-6
 | 5-2 | 5-16 | 5-14 | 5-10 | 5-10 | 2-3 | 5-7
 | 5-3 | 5-17 | 5-15 | 5-11 | 5-11 | 5-8 | 5-8
 | 5-4 | 5-18 | 5-16 | 5-12 | 5-12 | 5-9 | 5-9
 | 5-5 | 5-9 | 5-17 | 5-13 | 5-13 | 5-10 | 5-10
 | 5-6 | 5-10 | 5-18 | 5-14 | 5-14 | 5-11 | 5-11
 | 5-7 | 5-11 | 5-1 | 5-15 | 5-15 | 5-12 | 5-12
 | 5-8 | 5-12 | 5-2 | 5-16 | 5-16 | 5-13 | 5-13
Late | 4-1 | 5-1 | 4-1 | 5-17 | 5-17 | 5-14 | 5-14
 | 4-2 | 5-2 | 4-2 | 5-18 | 5-18 | 5-15 | 5-15
 | 5-9 | 5-3 | 5-3 | 5-1 | 5-1 | 5-16 | 5-16
 | 5-10 | 5-4 | 5-4 | 5-2 | 5-2 | 5-17 | 5-17
 | 5-11 | 5-5 | 5-5 | 5-3 | 5-3 | 5-18 | 5-18
 | 5-12 | 5-6 | 5-6 | 5-4 | 5-4 | 5-1 | 5-1
 | 5-13 | 5-7 | 5-7 | 5-5 | 5-5 | 5-2 | 2-1
 | 5-14 | 5-8 | 5-8 | 5-6 | 5-6 | 5-3 | 2-2
 | 5-15 | 3-1 | 5-9 | 5-7 | 5-7 | 5-4 | 2-3
[NAME] |  |  |  |  |  |  | 18
Spreadsheet: 731983d1620734241-excel-formula-that-can-convert-total-units-to-cartons-rolls-and-pieces-help-2
Sheet: SUMMARY

 |  |  | FINISHED GOODS STOCK TAKEN REPORT- ON 11/03/2020 |  |  | 30/04/2021
 |  |  |  | BIN CARD RECORD
 | PRODUCT NAME | CARTONS | ROLLS | PCS | T/UNITS | BAL. IN UNITS | DIFF |  | UNIT IN | ROLLS IN | TOTAL
 |  |  |  |  |  |  |  |  | A ROLL | A CTN | UNITS/CTN
S/N
 | aaaa |  |  |  |  |  |  |  | 12 | 12 | 144
 | bbbb |  |  |  |  |  |  |  | 12 | 12 | 144
 | cccc |  |  |  |  |  |  |  | 20 | 27 | 540
Spreadsheet: 755275d1636746292-if-formula-to-ignore-result-if-both-index-functions-return-from-the-same-cell-example
Sheet: Sheet2

 | Score at: |  |  |  |  | Change?
 | 1 month | 6 months | 12 months
[NAME] | 4.666666666666667 | 0 | Insufficient data
Fred | 7.333333333333333 | Insufficient data | Insufficient data
[NAME] | 9 | Insufficient data | Insufficient data
Greg | 6 | 10 | Insufficient data
Sara | 3.666666666666667 | Insufficient data | Insufficient data
Lara | 5.333333333333333 | Insufficient data | 8
[NAME] | 8.333333333333334 | Insufficient data | 7
[NAME] to find value first cell containing data: |  |  |  |  | INDEX(B4:D4,MATCH(FALSE,B4:D4="data",0))
[NAME] to find value in last cell containing data: |  |  |  |  | INDEX(B4:D4,,COUNTIFS(B4:D4,"<>",B4:D4,"<>*data*"))
[NAME] to track change: |  |  |  |  | LET(First,[NAME]:D4,MATCH(FALSE,B4:D4="data",0)),Last,[NAME]:D4,,COUNTIFS(B4:D4,"<>",B4:D4,"<>*data*")),IFS(First>Last,"Gone down",First=Last,"No change",First<Last,"Gone up"))
Spreadsheet: 160020d1338929526-excel-2007-createa-a-packing-label-based-on-data-in-row-selected-sample
Sheet: RUSSEL

 |  | REX METAL
SHIPMENT | ONTIME | PO # | PART # | Qty | REV | Due Date: | SHIP | Size | Mat. Rec. | [NAME]
 |  | xxxxxxxxxxx1 | 364618 | 10 | D | 2012-04-03 00:00:00 |  | 3 x 1.5 x .188
 |  | xxxxxxxxxxx2 | 364655 | 10 | C | 2012-04-03 00:00:00 |  | 3 x 1.5 x .188
 |  | xxxxxxxxxxx3 | 365169 | 100 | C | 2012-04-03 00:00:00 |  | 120 x 40 x 5
 |  | xxxxxxxxxxxx4 | 365169 | 100 | C | 2012-04-10 00:00:00 |  | 120 x 40 x 5
 |  | xxxxxxxxxxxx5 | 365169 | 100 | C | 2012-03-27 00:00:00 |  | 120 x 40 x 5
 |  | xxxxxxxxxxxx6 | 311859 | 36 | B | 2012-03-27 00:00:00 |  | 50 x 40 x  3
 |  | xxxxxxxxxxxx7 | 364655 | 15 | C | 2012-04-10 00:00:00 |  | 3 x 1.5 x .188
 |  | #N/A
 |  |  |  |  |  |  |  | `
Spreadsheet: 859186d1707653943-detect-repeat-multiple-values-in-a-row-and-highlight-them-based-on-number-of-repeats-book1-1-
Sheet: Sheet2

 | POST
 | 1st
 | 2nd
 | 3rd
 | 4th
 | 5th
 | 6th
 | 7th
 | 8th
 | 9th
 | 10th
 | 11th
 | 12th
 | 13th
 | 14th
 | 15th
 | 16th
 | 17th
 | 18th
 | 19th
 | 20th
 | 21st
 | 22nd
 | 23rd
 | 24th
 | GAME | 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 | END
Spreadsheet: 141165d1329137101-match-data-in-column-1-from-table-and-place-number-in-column-2-table-lookup
Sheet: Sheet1

Column A | Column B |  | Data Table
1 | 10 |  | 5 | 60
2 | 10 |  | 10 | 60
3 | 10 |  | 15 | 60
4 | 10 |  | 20 | 60
5 | 60 |  | 25 | 60
6 | 10 |  | 30 | 60
7 | 10 |  | 35 | 60
8 | 10 |  | 40 | 60
9 | 10 |  | 45 | 60
10 | 60 |  | 50 | 60
11 | 10 |  | 55 | 60
12 | 10 |  | 60 | 60
13 | 10 |  | 65 | 60
14 | 10 |  | 70 | 60
15 | 60 |  | 75 | 60
16 | 10 |  | 80 | 60
17 | 10 |  | 85 | 60
18 | 10 |  | 90 | 60
19 | 10 |  | 95 | 60
20 | 60 |  | 100 | 60
21 | 10 |  | 105 | 60
22 | 10 |  | 110 | 60
23 | 10 |  | 115 | 60
24 | 10 |  | 120 | 60
25 | 60 |  | 125 | 60
 |  |  | 130 | 60
 |  |  | 135 | 60
 |  |  | 140 | 60
Spreadsheet: 104252d1301915800-need-with-nested-if-statement-test-7-
Sheet: Sheet4

 | Price | code
 | 34 | #12
 | 56 | #20
 | 77 | #12
 | 898 | #16
 | 79 | #12
 | 24 | #8
 | 23 | #20
 | 34 | #12
 | 4354 | #16
 | 4656 | #12
 | 7678 | #8
 | 6786 | #20
 | 87 | #12
Spreadsheet: 477159d1472150818-formula-to-add-row-data-if-blank-then-data-from-different-sheet-with-reference-criteria-sumofthings_response
Sheet: Plan 2

 |  | Plan 2 | Plan 2 | Plan 2 | Plan 2 | Plan 2 | Plan 2 | Plan 2 | Plan 2 | Plan 2 | Plan 2 | Plan 2 | Plan 2
 |  | 2016-01-01 00:00:00 | 2016-02-01 00:00:00 | 2016-03-01 00:00:00 | 2016-04-01 00:00:00 | 2016-05-01 00:00:00 | 2016-06-01 00:00:00 | 2016-07-01 00:00:00 | 2016-08-01 00:00:00 | 2016-09-01 00:00:00 | 2016-10-01 00:00:00 | 2016-11-01 00:00:00 | 2016-12-01 00:00:00 | Remaining
 | C Holcom | 15 | 30 | 60 | 100 | 225 | 300 | 640 | 60 | 60 | 100 | 160 | 700
 | A Ivanson | 20 | 60 | 100 | 160 | 400 | 640 | 640 | 85 | 85 | 140 | 200 | 700
 | B Risuto | 20 | 85 | 140 | 200 | 450 | 700 | 640 | 60 | 60 | 100 | 160 | 700
 | M Franklin | 20 | 85 | 140 | 200 | 450 | 700 | 640 | 85 | 85 | 140 | 200 | 700
 | Change headings to dates - formatted showing month only
 | Add Date Field for date check
 | Add if date row to show which months to include
Spreadsheet: 0ef680fb-5319-4b1e-b3f1-4bb136d21d8e
Sheet: Sheet1

37 | ΣΥΓΧΡΟΝΕΣ ΜΟΡΦΕΣ ΧΡΗΜΑΤΟΔΟΤΗΣΗΣ | ΛΧ0509 | Ε | Υ | ΛΑΖΑΡΙΔΗΣ [NAME] | 1α | ΧΡΗΜΑΤΟΟΙΚΟΝΟΜΙΚΗ ΔΙΟΙΚΗΣΗ - τεύχος Δ | ΛΑΖΑΡΙΔΗΣ Γ. - ΠΑΠΑΔΟΠΟΥΛΟΣ Δ. | ΛΑΖΑΡΙΔΗΣ Γ. - ΠΑΠΑΔΟΠΟΥΛΟΣ Δ., ΚΑΘΗΓΗΤΕΣ ΠΑΝΕΠΙΣΤΗΜΙΟΥ ΜΑΚΕΔΟΝΙΑΣ | 2006 | ΘΕΣ/ΝΙΚΗ
 |  |  |  |  |  | 1β | ΣΥΓΧΡΟΝΕΣ ΜΟΡΦΕΣ ΧΡΗΜ/ΣΗΣ - τεύχος Β - Β έκδοση - Β ανατύπωση | ΛΑΖΑΡΙΔΗΣ Γ. | ΛΑΖΑΡΙΔΗΣ Γ., ΚΑΘΗΓΗΤΗΣ ΠΑΝΕΠΙΣΤΗΜΙΟΥ ΜΑΚΕΔΟΝΙΑΣ | 2007 | ΘΕΣ/ΝΙΚΗ
 |  |  |  |  |  | 2 | ΣΥΓΧΡΟΝΑ ΧΡΗΜΑΤΟΟΙΚΟΝΟΜΙΚΑ ΠΡΟΪΟΝΤΑ | ΜΑΛΙΝΔΡΕΤΟΥ Β. | ΕΚΔΟΣΕΙΣ ΠΑΠΑΖΗΣΗ Α.Ε.Β.Ε., Νικηταρά 2 106 78 ΑΘΗΝΑ | 2002 | ΑΘΗΝΑ
39 | ΕΦΑΡΜΟΓΕΣ ΦΟΡΟΛΟΓΙΚΗΣ ΛΟΓΙΣΤΙΚΗΣ | ΛΧ0505 | Ε | Υ | ΓΚΙΝΟΓΛΟΥ ΔΗΜΗΤΡΙΟΣ | 1 | ΦΟΡΟΛΟΓΙΚΗ ΛΟΓΙΣΤΙΚΗ - ΕΦΑΡΜΟΓΕΣ | ΓΚΙΝΟΓΛΟΥ Δ. | ΒΙΒΛΙΑ - ΕΚΔΟΣΕΙΣ "Ε. & Δ. ΑΝΙΚΟΥΛΑ - Ι. ΑΛΕΞΙΚΟΣ" Ο.Ε., ΕΓΝΑΤΙΑΣ 156, 54621  ΘΕΣ/ΝΙΚΗ | 2004 | ΘΕΣ/ΝΙΚΗ
 |  |  |  |  |  | 2 | ΘΕΜΑΤΑ ΦΟΡΟΛΟΓΙΚΗΣ ΛΟΓΙΣΤΙΚΗΣ | ΧΕΒΑΣ Δ. | ΓΕΩΡΓΙΑ ΣΩΤ. ΜΠΕΝΟΥ ΕΚΔΟΣΕΙΣ, ΦΕΡΩΝ 5, 10434  ΑΘΗΝΑ | 2007 | ΑΘΗΝΑ
40 | ΔΙΕΘΝΕΙΣ ΧΡΗΜΑΤΟΔΟΤΙΚΕΣ ΑΓΟΡΕΣ | ΛΧ0514 | Ε | ΥΕ | ΜΙΧΑΛΟΠΟΥΛΟΣ ΓΕΩΡΓΙΟΣ | 1 | ΔΙΕΘΝΕΙΣ ΚΕΦΑΛΑΙΑΓΟΡΕΣ τόμος 1 - Θεωρία και [NAME] | ΣΥΡΙΟΠΟΥΛΟΣ ΚΩΣΤΑΣ | ΒΙΒΛΙΑ - ΕΚΔΟΣΕΙΣ "Ε. & Δ. ΑΝΙΚΟΥΛΑ - Ι. ΑΛΕΞΙΚΟΣ" Ο.Ε., ΕΓΝΑΤΙΑΣ 156, 54621  ΘΕΣ/ΝΙΚΗ | 1999 | ΘΕΣ/ΝΙΚΗ
 |  |  |  |  |  | 2 | ΠΑΓΚΟΣΜΙΕΣ ΧΡΗΜΑΤΟΠΙΣΤΩΤΙΚΕΣ ΑΓΟΡΕΣ | [NAME] | ΕΚΔΟΣΕΙΣ ΠΑΠΑΖΗΣΗ Α.Ε.Β.Ε., Νικηταρά 2 106 78 ΑΘΗΝΑ | 1996 | ΑΘΗΝΑ
Spreadsheet: louise_kitchen__22748__Turbine Position Report 061501
Sheet: Summary by Status

Turbine Position Report |  |  |  |  |  |  | CONFIDENTIAL
Summary by Status
($ MMs)
 |  |  |  |  |  | Financial Data as of
UNITS | MODEL | CONTROLLED BY | PROJECT(S) | DASH APPROVAL DATE / STATUS | CONTRACT COST | SCHEDULED CONTRACT PYMTS TO DATE | CANCELLATION COST TO DATE | STATUS
COMMITTED - turbines committed to deals which have been DASHed and financing is in process.
2 | 7EA |  |  |  |  |  |  | Committed
 |  |  | Total Committed
TENTATIVE - turbines tentatively committed to ONE deal which has not yet been DASHed, but is likely to be.
1 | MHI 501F simple cycle |  |  |  |  |  |  | Tentative
1 | 501D5A simple cycle |  |  |  |  |  |  | Tentative
1 | 7FA |  |  |  |  |  |  | Tentative
2 | MHI 501F simple cycle |  |  |  |  |  |  | Tentative
 |  |  | Total Tentative
AVAILABLE - turbines which may be potential matches with SEVERAL deals, none of which have been approved to date.
1 | MHI 501F simple cycle |  |  |  |  |  |  | Available
3 | 9FA STAG power islands |  |  |  |  |  |  | Available
2 | 11N1 |  |  |  |  |  |  | Available
2 | Fr 6B 60hz power barges (BV=0) |  |  |  |  |  |  | Available
1 | Steam Turbine (BV = 0) |  |  |  |  |  |  | Available
 |  |  | Total Available
NEGOTIATING - turbines for which the purchase is currently being negotiated, but Enron does not yet have control of these turbines.
3 | 7FA | EA | Unassigned | Analyzing |  | 0 | 0 | Negotiating
 |  |  | Total Negotiating
 | UNITS - TOTAL |  | GRAND TOTALS
SCHEDULED VS CANCELLATION PAYMENTS
($ MMs)
*  Total Cancellation Payments = Total Enron Exposure
Spreadsheet: daren_farmer__6364__EnronAvails0400
Sheet: Sid Richardson Plant

TO: | [NAME] |  | Effective Date |  |  | PHONE: | (713) 853-9272
 | ENRON NORTH AMERICA |  | 2000-04-01 00:00:00 |  |  | FAX: | (713) 646-2391
 |  |  |  |  |  | E-MAIL: | [EMAIL]
FROM: | JAN SVAJIAN |  |  |  |  | PHONE: | (405) 552-8163
 | DEVON ENERGY CORPORATION |  |  |  |  | FAX: | (405) 552-4664
 |  |  |  |  |  | E-MAIL: | [EMAIL]
 |  |  | VOLUME |  | DBQ |  | DBQ |  | EXCESS
 | CDP NAME & METER NUMBER |  | AVAILABLE |  | % |  | AVAILABLE |  | AMOUNT
 | [NAME] (90289) |  | 1009.25 |  | 0.75
 | [NAME] Sat #3 (K-332) |  | 97.5 |  | 0.75
 | Baird WE 1312 (K-351) |  | 82.55 |  | 0.75
 | KCC 359 Battery ([NAME]) |  | 91 |  | 0.75
 | KCC #135 (K-224) |  | 442 |  | 0.75
 | SKEU 108 Battery |  | 6282.581759999999 |  | 0.75
 | State Walton #5 (90337) |  | 385.125 |  | 0.75
 | Baird #1257 (90339) |  | 468 |  | 0.75
 | Baird #1875 (90329) |  | 204.75 |  | 0.75
 | Baird #1954 (90327) |  | 390 |  | 0.75
 | Baird #1955 (90328) |  | 487.5 |  | 0.75
 | H.E. Lovett #2 (90348) |  | 300.95 |  | 0.75
 | State Walton #1 (90336) |  | 401.69805 |  | 0.75
 | Baird #1382 (90338) |  | 435.5 |  | 0.75
 | [NAME] (90341) |  | 390 |  | 0.75
 | [NAME] (90340) |  | 1029.84375 |  | 0.75
 | [NAME] (90342) |  | 128.013227875 |  | 0.75
 | Baird #1381 (90353 |  | 325 |  | 0.75
 | KEYSTONE PLANT TAILGATE MMBTU/D
Spreadsheet: 34248d1231411644-xl-charting-problem-xl-chart-problem
Sheet: Data 

SWGR AFR Statistics
Year | Period | AFR
2005/2006 | 1 | 0.568
 | 2 | 0.687
 | 3 | 0.792
 | 4 | 0.994
 | 5 | 0.887
 | 6 | 0.895
 | 7 | 0.895
 | 8 | 0.797
 | 9 | 0.802
 | 10 | 0.8
 | 11 | 0.697
 | 12 | 0.598
 | 13 | 0.696
2006/2007 | 1 | 0.7
 | 2 | 0.694
 | 3 | 0.602
 | 4 | 0.404
 | 5 | 0.41
 | 6 | 0.415
 | 7 | 0.422
 | 8 | 0.538
 | 9 | 0.548
 | 10 | 0.551
 | 11 | 0.57
 | 12 | 0.589
 | 13 | 0.361
2008/2009 | 1 | 0.247
 | 2 | 0.127
 | 3 | 0.13
 | 4 | 0.133
 | 5 | 0.134
 | 6 | 0.135
 | 7 | 0.136
 | 8 | 0
 | 9 | 0
 | 10 | 0
 | 11 | 0
 | 12 | 0
 | 13 | 0
2009/2010 | 1 | 0
 | 2 | 0
 | 3 | 0
 | 4 | 0
 | 5 | 0
 | 6 | 0
 | 7 | 0
 | 8 | 0.122
 | 9 | 0.12
 | 10
 | 11
 | 12
 | 13
2010/2011 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
Spreadsheet: 42697d1241244933-updating-a-formula-based-on-multiple-sheets-demo
Sheet: 3

 | Estimated | No.Sold | Diff
Apple | 26 | 24 | 2
Mango | 27 | 30 | 3
[NAME] | 28 | 19 | 9
Pine Apple | 28 | 20 | 8
Kiwi | 30 | 17 | 13
Spreadsheet: 839893d1692283989-finding-partial-text-in-two-arrays-and-returning-one-or-more-values-listed-in-second-array-partial-match-of-arrays-example
Sheet: Initial State

Narrative | Matching Key Word? | Predetermined Key Words
Professional football players used to wear leather helmets. |  | width
Many professional athletes are adept at playing many different sports. | adept | height
How was the width and height of the modern football goal posts determined? | width; height; Football | helm
Baseball players wear helmets as well. | helm | adept
Soccer players don't wear helmets, but due to the many head injuries perhaps they should. | helm | Football
AZ has many different sport venues. | AZ | AZ