tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 39145d1237344664-vlookup-list-problem-schedule-weekly
Sheet: 7 Day Schedule (5)

Master Production Schedule Week of |  |  |  |  | 2009-02-15 00:00:00
 |  | 2009-02-15 00:00:00 | 2009-02-16 00:00:00 | 2009-02-17 00:00:00 | 2009-02-18 00:00:00 | 2009-02-19 00:00:00 | 2009-02-20 00:00:00 | 2009-02-21 00:00:00
Product ID | Product | Sun | Mon | [NAME] | Weds | Thurs | Fri | Sat
68003
 | 14
61425
 | 15
68006
 | 17
1927
 | #N/A
68011
 | #N/A
1919
 | #N/A
[NAME]
 | 32
A68011
 | 31
A1919
 | 30
 |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  | 12500
Spreadsheet: 881116d1729027607-2-columns-multiplication-per-row-by-varying-quantities-needmathhelp-example-cost-sheet-tms
Sheet: 13501

Project Costs
Quote No. |  |  | Date: |  |  |  | Project Expenditure |  |  |  |  | Net Profit:
Customer |  |  |  |  |  |  | Revenue:
Project Name |  |  |  |  |  |  | Costs:
Referral Source |  |  |  |  |  |  | Margin:
EQUIPMENT COSTS |  |  |  |  |  |  | € or $ | Conversion |  |  |  | Total:
Vendor |  | Quote # | Date | Part # | Part Description |  | Cost Ea. | 1.15 | OEM | Our Cost | Margin | Sale Price | Quantity | Sale Price w/Quantity | TMS
 |  |  |  |  |  |  | 17177 |  | 0.075 |  | 0.2 |  | 1 |  |  | * | One formula
 |  |  |  |  |  |  | 480 |  |  |  | 0.2 |  | 1 |  | 600 |  | Clear everything below it
 |  |  |  |  |  |  | 835 |  | 0.075 |  | 0.2 |  | 1 |  | 970
 |  |  |  |  |  |  | 1694 |  | 0.075 |  | 0.2 |  | 1 |  | 1960
 |  |  |  |  |  |  | 835 |  |  |  | 0.2 |  | 1 |  | 1045
 |  |  |  |  |  |  | 5500 |  | 0.1 |  | 0.2 |  | 2 |  | 28470
 |  |  |  |  |  |  | 7600 |  | 0.1 |  | 0.2 |  | 2 |  | 39330
 |  |  |  |  |  |  | 3275 |  | 0.1 |  | 0.2 |  | 1 |  | 4240
 |  |  |  |  |  |  | 4500 |  | 0.1 |  | 0.2 |  | 1 |  | 5825
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | BSB | JT
Summation |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 102305
 |  |  |  |  | * | lr | Is a variable |  |  |  |  |  |  |  | Possibly:
 |  |  |  |  |  | MATCH("Summation",A:A,0)-1 | determines the last row of data based on the position of the Summation line
 |  |  |  |  |  | z | is a variable
 |  |  |  |  |  | M8:INDEX(M:M,lr) | is a range from row 8 to the last row of data
 |  |  |  |  |  | N8:INDEX(N:N,lr) | is a range from row 8 to the last row of data
 |  |  |  |  |  | MAP | a function to apply another function to the ranges specified
 |  |  |  |  |  | LAMBDA(x,y,x*y) | basically, defines two variables and multiplies them together
 |  |  |  |  |  | VSTACK(z,SUM(z)) | stacks the variable z and the sum of its elements
Spreadsheet: 219442d1362759877-difference-between-time-in-same-column-with-different-dates-new-sleep-log-further-analysis-experiments
Sheet: Sheet1

Went to bed at: | Woke up at: | Hours slept | Total hrs. Awake | Total sleep cycle time | NOTES | Bed-time advance | Waking time advance
2013-02-26 13:00:00 | 2013-02-26 20:57:00 |  | Missing Monday | Missing Monday | Missing Monday
2013-02-27 14:50:00 | 2013-02-27 23:27:00 |  |  |  | INDUCED ADVANCE
2013-02-28 16:37:00 | 2013-02-28 23:38:00 |  |  |  | INDUCED ADVANCE
2013-03-01 16:30:00 | 2013-03-02 01:18:00 |  |  |  | INDUCED ADVANCE
2013-03-02 18:48:00 | 2013-03-03 02:00:00 |  |  |  | INDUCED ADVANCE
2013-03-03 19:40:00 | 2013-03-04 04:22:00 |  |  |  | INDUCED ADVANCE
2013-03-04 21:25:00 | 2013-03-05 04:46:00 |  |  |  | INDUCED ADVANCE
2013-03-05 20:20:00 | 2013-03-06 05:44:00
2013-03-06 20:31:00 | 2013-03-07 06:01:00
 |  |  |  | 23:38:00 | 01:18:00
Spreadsheet: 1292c8d3-6d22-454f-a0e9-a68dd9713ec9
Sheet: Capital

CAPITAL PROJECT
Ordinance Fiscal Note |  |  |  |  |  |  | Ordinance Number
Ordinance Title (in Brief)
Is  this ordinance for the following: |  |  |  |  | New Construction
 |  |  |  |  | Replacement
 |  |  |  |  | Repair
Was this project programmed in the Five-Year Capital Improvement Plan? |  |  |  |  |  |  |  | No |  |  | Yes
 | If yes, please identify year in which this project was funded.
 | If no, please detail the reasons why this project was not included and need for present funding request.
Does this project leverage non-city funds for design/construction? |  |  |  |  |  |  |  | No |  |  | Yes
 | If yes, please identify source and amount.
 | If no, please identify source and amount of city funds.
If ordinance is for construction or replacement of asset please provide the following information:
 | Total estimated costs (design through construction):
 | Estimated lifespan of project in years
 | Estimated annual operating and maintenance costs
 | (Please detail type of maintenance or operating costs needed, additional staffing, capital maintenance costs, utilities, etc.)
Are these O&M costs reflected in the current budget? |  |  |  |  |  |  |  | No |  |  | Yes
 | If yes, please please provide source of funds.
 | If no, please identify year in which additional operating and maintenance costs will be needed.
Reference Numbers: (Previously approved legislation):
Reviewed by:
 | 0ffice of Management and Budget |  |  | OMB Approval Date
Spreadsheet: e4924fa0-8860-4a02-94f2-bcbd19ab6774
Sheet: WC - OI Margin

GAAP to Non-GAAP Reconciliation
Operating Income To Underlying Operating Income
For the Three Months Ended June 30,
($ in millions, except percentages) ([NAME])
 |  |  | 2011 |  |  |  |  |  |  |  | 2010
 |  |  | As Reported (GAAP) |  | Integration Program Costs (1) |  | Acquisition-Related Costs (2) |  | [NAME](Non-GAAP) |  | As Reported (GAAP) |  | Integration Program Costs (1) |  | Acquisition-Related Costs (2) |  | [NAME](Non-GAAP)
Kraft Foods
 | Operating Income |  | 1806 |  | 136 |  | 0 |  | 1942 |  | 1701 |  | 149 |  | 10 |  | 1860
 | Operating Income Margin |  | 0.13 |  |  |  |  |  | 0.14 |  | 0.139 |  |  |  |  |  | 0.152
Kraft Foods North America
 | Segment Operating Income |  | 1139 |  | 14 |  | 0 |  | 1153 |  | 1187 |  | 7 |  | 0 |  | 1194
 | Segment Operating Income Margin |  | 0.18 |  |  |  |  |  | 0.182 |  | 0.193 |  |  |  |  |  | 0.194
Kraft Foods Europe
 | Segment Operating Income |  | 415 |  | 58 |  | 0 |  | 473 |  | 335 |  | 33 |  | 0 |  | 368
 | Segment Operating Income Margin |  | 0.118 |  |  |  |  |  | 0.134 |  | 0.12 |  |  |  |  |  | 0.132
Kraft Foods Developing Markets
 | Segment Operating Income |  | 518 |  | 55 |  | 0 |  | 573 |  | 429 |  | 32 |  | -2 |  | 459
 | Segment Operating Income Margin |  | 0.128 |  |  |  |  |  | 0.142 |  | 0.13 |  |  |  |  |  | 0.139
 | (1) Integration Program costs are defined as the costs associated with combining the Kraft Foods and Cadbury businesses,
 | and are separate from those costs associated with the acquisition.
 | (2) Acquisition-related costs include transaction advisory fees, U.K. stamp taxes and the impact of the Cadbury inventory revaluation.
Spreadsheet: 165421d1341227764-it-copies-but-it-doesnt-paste-accurately-sample-log
Sheet: Sheet1

G-BSGL                            Technical Log |  |  |  |  |  |  |  |  | [NAME]
Date | Pilot | P.O.B. | Nature | Brakes | Take | Landing | Brakes | Flight | Total | Engine
 |  |  | of Flight | Off | Off |  | ON | Time | Time | 2 days, 2:00:00 | Defects
2012-07-01 00:00:00 | G Smith | 2 | EGCV | 10:10:00 | 10:15:00 | 10:30:00 | 10:40:00
2012-07-02 00:00:00 | A Jones | 1 | EGCV | 11:00:00 | 11:05:00 | 11:55:00 | 12:00:00
G-BSGL                            Technical Log |  |  |  |  |  |  |  |  | [NAME]
G-BSGL                            Technical Log |  |  |  |  |  |  |  |  | [NAME]
Date | Pilot | P.O.B. | Nature | Brakes | Take | Landing | Brakes | Flight | Total | Engine
 |  |  | of Flight | Off | Off |  | ON | Time | Time | 2 days, 2:00:00 | Defects
2012-07-01 00:00:00 | G Smith | 2 | EGCV | 10:10:00 | 10:15:00 | 10:30:00 | 10:40:00
2012-07-02 00:00:00 | A Jones | 1 | EGCV | 11:00:00 | 11:05:00 | 11:55:00 | 12:00:00
Spreadsheet: 690441d1597105154-transpose-batch-excel-data-sample-xl
Sheet: Sheet1

Origin City: | Origin State: | Destination City: | Destination State: | Attribute.1 | Attribute.2 | Value
Aguascalientes | AG | Champaign | IL | 0 | 500 | 0.43
Aguascalientes | AG | Champaign | IL | 500 | 1000 | 0.37
Aguascalientes | AG | Champaign | IL | 1000 | 2000 | 0.43
Aguascalientes | AG | Champaign | IL | 2000 | 5000 | 0.38
Aguascalientes | AG | Champaign | IL | 5000 | 10000 | 0.22
Aguascalientes | AG | Champaign | IL | 10000 | 15000 | 0.17
Aguascalientes | AG | Champaign | IL | 15000 | 20000 | 0.18
Aguascalientes | AG | Champaign | IL | 20000 | 30000 | 0.13
Aguascalientes | AG | Champaign | IL | 30000 | 42500 | 0.12
Apodaca | NL | East Peoria | IL | 0 | 500 | 0.79
Apodaca | NL | East Peoria | IL | 500 | 1000 | 0.3
Apodaca | NL | East Peoria | IL | 1000 | 2000 | 0.14
Apodaca | NL | East Peoria | IL | 2000 | 5000 | 0.14
Apodaca | NL | East Peoria | IL | 5000 | 10000 | 0.18
Apodaca | NL | East Peoria | IL | 10000 | 15000 | 0.09
Apodaca | NL | East Peoria | IL | 15000 | 20000 | 0.13
Apodaca | NL | East Peoria | IL | 20000 | 30000 | 0.12
Apodaca | NL | East Peoria | IL | 30000 | 42500 | 0.1
Apodaca | NL | [NAME] | IL | 0 | 500 | 0.23
Apodaca | NL | [NAME] | IL | 500 | 1000 | 0.43
Apodaca | NL | [NAME] | IL | 1000 | 2000 | 0.23
Apodaca | NL | [NAME] | IL | 2000 | 5000 | 0.18
Apodaca | NL | [NAME] | IL | 5000 | 10000 | 0.17
Apodaca | NL | [NAME] | IL | 10000 | 15000 | 0.15
Apodaca | NL | [NAME] | IL | 15000 | 20000 | 0.14
Apodaca | NL | [NAME] | IL | 20000 | 30000 | 0.11
Apodaca | NL | [NAME] | IL | 30000 | 42500 | 0.11
Celaya | GJ | North Little Rock | AR | 0 | 500 | 0.76
Celaya | GJ | North Little Rock | AR | 500 | 1000 | 0.38
Celaya | GJ | North Little Rock | AR | 1000 | 2000 | 0.25
Celaya | GJ | North Little Rock | AR | 2000 | 5000 | 0.2
Celaya | GJ | North Little Rock | AR | 5000 | 10000 | 0.14
Celaya | GJ | North Little Rock | AR | 10000 | 15000 | 0.11
Celaya | GJ | North Little Rock | AR | 15000 | 20000 | 1.03
Celaya | GJ | North Little Rock | AR | 20000 | 30000 | 0.97
Celaya | GJ | North Little Rock | AR | 30000 | 42500 | 0.08
[NAME] | NL | [NAME] | IL | 0 | 500 | 0.74
[NAME] | NL | [NAME] | IL | 500 | 1000 | 0.53
[NAME] | NL | [NAME] | IL | 1000 | 2000 | 0.22
[NAME] | NL | [NAME] | IL | 2000 | 5000 | 0.27
[NAME] | NL | [NAME] | IL | 5000 | 10000 | 0.18
[NAME] | NL | [NAME] | IL | 10000 | 15000 | 0.16
[NAME] | NL | [NAME] | IL | 15000 | 20000 | 0.13
[NAME] | NL | [NAME] | IL | 20000 | 30000 | 0.12
[NAME] | NL | [NAME] | IL | 30000 | 42500 | 0.1
Spreadsheet: 1acbc5b5-eba7-43ce-aba6-394b78c6d600
Sheet: OCEAN

 | PROGRAM LEVEL | # | SLOs | # | ASSESSMENT METHOD DEFINED | # | ASSESSED  COURSE | # | DISCUSSION/ IMPROVEMENT | #
 | Program | 1 | X | 1 | X | 1 | X | 1 | X | 1
 | TOTAL
 | PERCENTAGE
 | COURSE
1 | OCEAN 100 | 1 | X | 1 | X | 1 | 1 | 1 | 1 | 1
1 | OCEAN 101 | 1 | X | 1 | X | 1 | 4 | 1 | 2 | 1
5 | OCEAN 101H | 1 | X | 1
 | TOTAL
 | PERCENTAGE
Spreadsheet: 168568d1342509509-automatically-change-the-color-of-a-chart-according-to-current-period-845514
Sheet: Charts

 | Current month:
 | [NAME] |  |  |  |  |  | Yellow ones are my forecasts and the bars representing these numbers need to be in different color in the chart below
 | P1/10 | [NAME] | P3/10 | P4/10 | P5/10 | P6/10 | P7/10 | P8/10 | P9/10 | P10/10 | P11/10 | P12/10
Acutal | 3333 | 1111 | 3344 | 3355 | 3366 | 987
Forecast |  |  |  |  |  |  | 7777 | 2323 | 3434 | 2311 | 5215 | 4444
Spreadsheet: 99166d1297890974-trigger-to-activate-appropriate-list-forum-sample-19d
Sheet: FINAL SORT

0 | <<<TRIGGER
070
061
052
304
080
017
260
053
440
090
018
207
603
054
190
820
703
640
055
092
083
704
605
039
480
057
409
580
706
950
086
077
609
708
709
808
809
990
Spreadsheet: a02f3c66-4f84-487d-b05d-9ea9baedc4ac
Sheet: enter data

FAS - Accumulated Grain Export Sales
[NAME]
Crop Year-Wheat=6/01-5/31;  Corn & Soybeans=9/01-8/31;
 | HRW |  | SRW |  | HRS |  | SWW |  | DUR |  | All |  | Corn |  | Soybean
 | Outstd | Accum | Outstd | Accum | Outstd | Accum | Outstd | Accum | Outstd | Accum | Outstd | Accum | Outstd | Accum | Outstd | Accum
2012-05-03 00:00:00 | 1074 | 9067 | 711 | 3621 | 874 | 5874 | 596 | 5198 | 44 | 447 | 3299 | 24206 | 9691 | 27837 | 5065 | 29419
2013-05-02 00:00:00 | 1406 | 8864 | 701 | 3631 | 518 | 5495 | 245 | 4361 | 58 | 489 | 2928 | 23840 | 4152 | 12714 | 2111 | 34371
enter the data on this sheet, then copy these two lines to the end to the copy data sheet
Spreadsheet: andy_zipper__182__DYNEGY-ICE VOL May14
Sheet: ICE-ENA

Enron North America
Activity on ICE
UOM | Deals | Volume
MMBtus
bbl
 |  |  |  |  |  |  | START | END
Enron North America Corp.
Commodity Type:  All
Instruments:  All
Trade Dates:  May-12-01 thru May-14-01
Trade Date | Deal ID | Leg ID | B/S | Product | Hub | Strip | START | END | Option | Strike | Style | Counterparty | Price | Price Units | Qty Per Period | Periods | Total Quantity | Qty Units | Trader
May-14-01 | 590700441 |  | Bought | NG Fin, FP for LD1 | [NAME] | Nov01-Mar02 | Nov-01-01 | Mar-31-02 |  |  |  | AEP Energy Services, Inc. | 4.7625 | USD / MMBtu | 5000 | Daily | 755000 | MMBtus | [NAME], J
May-14-01 | 111723411 |  | Sold | NG [NAME], ID, GDD | TET M3 | Next Day Gas | May-15-01 | May-15-01 |  |  |  | Mirant Americas Energy Marketing, LP | 0 | USD / MMBtu | 10000 | Daily | 10000 | MMBtus | Pimenov, V
May-14-01 | 209913861 |  | Sold | NG Fin, FP for LD1 | [NAME] | Cal 02 | Jan-01-02 | Dec-31-02 |  |  |  | El Paso Merchant Energy L.P. | 4.455 | USD / MMBtu | 2500 | Daily | 912500 | MMBtus | [NAME], J
May-14-01 | 186943878 |  | Sold | NG Fin BS, LD1 for IF | Waha | Cal 03 | Jan-01-03 | Dec-31-03 |  |  |  | AEP Energy Services, Inc. | 0 | USD / MMBtu | 10000 | Daily | 3650000 | MMBtus | [NAME] ,
May-14-01 | 404698249 |  | Sold | NG Fin BS, LD1 for GDM | Mich | [NAME] | Jun-01-01 | Oct-31-01 |  |  |  | Duke Energy Trading and Marketing LLC | 0.175 | USD / MMBtu | 5000 | Daily | 765000 | MMBtus | [NAME], G
May-14-01 | 122149640 |  | Sold | NG Fin BS, LD1 for GDM | Mich | 2001-10-01 00:00:00 | Oct-01-01 | Oct-31-01 |  |  |  | AEP Energy Services, Inc. | 0.18 | USD / MMBtu | 10000 | Daily | 310000 | MMBtus | [NAME], G
May-14-01 | 430171665 |  | Sold | NG Fin BS, LD1 for GDM | Mich | [NAME] | Jun-01-01 | Oct-31-01 |  |  |  | Duke Energy Trading and Marketing LLC | 0.17 | USD / MMBtu | 5000 | Daily | 765000 | MMBtus | [NAME], G
May-14-01 | 919472225 |  | Sold | NG Fin, FP for LD1 | [NAME] | Cal 02 | Jan-01-02 | Dec-31-02 |  |  |  | AEP Energy Services, Inc. | 4.4425 | USD / MMBtu | 2500 | Daily | 912500 | MMBtus | [NAME], J
May-14-01 | 531440437 |  | Bought | NG Fin BS, LD1 for IF | Waha | Cal 03 | Jan-01-03 | Dec-31-03 |  |  |  | AEP Energy Services, Inc. | -0.01 | USD / MMBtu | 10000 | Daily | 3650000 | MMBtus | [NAME] ,
May-14-01  Deals
Spreadsheet: 40469d1238773860-index-match-problem-sample
Sheet: Sheet1

HAWB Number | Origin Airport | Destination Airport | [NAME] | [NAME] | [NAME] | [NAME] | Pieces | Cost
ARS000I8N | DFW | AUS | 75119 | 78758 | 167.8999938964844 | A | 1 |  |  |  | P/U Volume → | 1-74 pieces | 75-124 pieces | 125+ pieces
ARS000HKJ | PHL | RIC | 19107 | 23005 | 237.8999938964844 | A | 52 |  |  |  | Zone ↓ | Price/piece | Price/piece | Price/piece
ARS000J6C | ORD | CMH | 60653 | 43230 | 373.8999938964844 | A | 30 |  |  |  | A | 7.33 | 6.37 | 5.41
ARS000FHE | PIT | RIC | 15024 | 23005 | 323.2000122070312 | A | 15 |  |  |  | B | 7.79 | 6.88 | 5.96
ARS000FHG | PIT | RIC | 15222 | 23005 | 326.7999877929688 | B | 28 |  |  |  | C | 8.25 | 7.38 | 6.51
ARS000IF4 | CLE | RIC | 44311 | 23005 | 431 | G | 262 |  |  |  | D | 8.7 | 7.89 | 7.07
ARS000JC8 | SEA | BOS | 98031 | 3868 | 3125 | G | 14 |  |  |  | E | 9.16 | 8.39 | 7.62
ARS000J7L | SEA | ATL | 98032 | 30318 | 2687.5 | G | 88 |  |  |  | F | 9.61 | 8.9 | 8.17
ARS000J43 | RNO | DFW | 89801 | 75007 | 1615.599975585938 | A | 44 |  |  |  | G | 10.07 | 9.4 | 8.72
63698803 | DFW | AUS | 75063 | 78758 | 205.6999969482422 | G | 3
ARS000J42 | LAX | BOS | 90220 | 3868 | 3084 | A | 18
ARS0005LA | MEM | DFW | 71901 | 75007 | 308.5 | A | 81
ARS000IDD | IND | CMH | 47240 | 43230 | 173.3000030517578 | B | 1
ARS000I2A | ORD | CMH | 61356 | 43230 | 462.8999938964844 | A | 54
ARS000IF1 | OKC | AUS | 73169 | 78758 | 383.8999938964844 | D | 66
ARS000J85 | ICT | ATL | 67210 | 30318 | 992.9000244140625 | C | 32
Spreadsheet: 777462d1650392824-counting-distinct-values-within-a-date-range-feeod-sample
Sheet: Visits Vs IX completed

Count of Site ID | Column Labels
Row Labels | No | Yes | (blank) | Grand Total
Central | 6 | 4 |  | 10
Call and Data testing | 2 | 3 |  | 5
Integration | 4 | 1 |  | 5
NE | 3 | 7 | 3 | 13
Call and Data testing | 2 | 2 | 2 | 6
Integration | 1 | 5 | 1 | 7
West | 8 | 4 |  | 12
Call and Data testing | 6 | 2 |  | 8
Integration | 2 | 2 |  | 4
Grand Total | 17 | 15 | 3 | 35
Spreadsheet: 785311d1656337844-return-different-texts-depending-on-day-of-month-book1
Sheet: Sheet1

2022-05-27 00:00:00
2022-05-28 00:00:00
2022-05-29 00:00:00
2022-05-30 00:00:00
2022-05-31 00:00:00
2022-06-01 00:00:00
2022-06-02 00:00:00
2022-06-03 00:00:00
2022-06-04 00:00:00
2022-06-05 00:00:00
2022-06-06 00:00:00
2022-06-07 00:00:00
2022-06-08 00:00:00
2022-06-09 00:00:00
2022-06-10 00:00:00
2022-06-11 00:00:00
2022-06-12 00:00:00
2022-06-13 00:00:00
2022-06-14 00:00:00
2022-06-15 00:00:00
2022-06-16 00:00:00
2022-06-17 00:00:00
Spreadsheet: 278169d1384593486-number-of-unique-values-in-column-a-based-on-values-in-columns-b-and-c-unique-awbs
Sheet: Sheet1

AWBs | Date | Name |  | Name | [NAME]
1234 | 2013-11-01 00:00:00 | [NAME] |  | Date | 2013-11-01 00:00:00 | 2013-11-02 00:00:00 | 2013-11-03 00:00:00
1235 | 2013-11-02 00:00:00 | [NAME] |  | # of AWBs
1236 | 2013-11-03 00:00:00 | [NAME]
Spreadsheet: 847549d1698417161-bulk-substitute-in-a-spilling-array-bulk-substitute
Sheet: Feuil1

 |  |  |  | spilling array |  |  |  | substitue table |  |  | expected result (spilling array)
ID:aze|Size:32|Label:rty |  |  |  |  |  |  |  | from | to |  | ID:aze|Size:32|Label:rty
ID:aze|Dim:32|Label2:rty |  |  |  | ID:aze|Dim:32|Label2:rty |  |  |  | Label2 | Label |  | ID:aze|Size:32|Label:rty
ID:aze|Size:32|Label:rty |  |  |  | ID:aze|Size:32|Label:rty |  |  |  | Label3 | Label |  | ID:aze|Size:32|Label:rty
ID:aze|Size:32|Label3:rty |  |  |  | ID:aze|Size:32|Label3:rty |  |  |  | Dim | Size |  | ID:aze|Size:32|Label:rty
ID:aze|Weight:32|Label:rty |  |  |  | ID:aze|Weight:32|Label:rty |  |  |  | Weight | Size |  | ID:aze|Size:32|Label:rty
Spreadsheet: 376b22c8-4055-42b9-85d7-7650dba0a454
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: |  |  | 2011-09-27 09:27:30.220000
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.375 | 101.875 | 101.75 | 101.625 | 101.25 |  | and are added to price quote
4.25 | 101.112 | 100.987 | 100.862 | 100.487
4.125 | 100.425 | 100.3 | 100.175 | 99.8 |  | Note: | Refer To Price [NAME]
4 | 100.01 | 99.885 | 99.76 | 99.385 |  |  | For all Price Adjs
3.875 | 99.493 | 99.368 | 99.243 | 98.618
3.75 | 98.523 | 98.398 | 98.273 | 97.648
 |  |  |  |  |  | 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.625 | 101.394 | 101.269 | 101.144 | 100.769
3.5 | 101.056 | 100.931 | 100.806 | 100.431
3.375 | 100.683 | 100.558 | 100.433 | 100.058
3.25 | 100.147 | 100.022 | 99.897 | 99.522
3.125 | 98.648 | 98.523 | 98.398 | 97.773
3 | 98.311 | 98.186 | 98.061 | 97.436
 |  |  |  |  |  | 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 | 2011-10-11 09:27:30.220000
30 DAY | 2011-10-26 09:27:30.220000
45 DAY | 2011-11-10 09:27:30.220000
60 DAY | 2011-11-25 09:27:30.220000
90 DAY | 2011-12-25 09:27:30.220000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: a6c832f6-822a-4d4e-b4a5-0000972618fa
Sheet: Sheet1

Unnamed: 0 | State of New Hampshire - Primary Election | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 | State Representative - SULLIVAN County - Republican
District No. 1 (2) | Clifford, r | Walker, r | Ward, r | [NAME], d | Lefebvre, d | [NAME]
Cornish | 50 | 53 | 47 |  |  | 1
Grantham | 92 | 101 | 115 | 3 | 1
Plainfield | 17 | 72 | 51 |  |  | 1
Springfield | 61 | 67 | 44 |  |  | 2
TOTALS | 220 | 293 | 257 | 3 | 1 | 4
District No. 2 (1) | Bowers, r | Gottling, d | [NAME]
Croydon | 68
Sunapee | 368 | 7 | 6
TOTALS | 436 | 7 | 6
District No. 3 (1) | Picano, r | O'Hearne, d | [NAME]
Claremont Ward 1 | 135 | 2 | 2
District No. 4 (1) | Lovett, r | [NAME], d | [NAME]
Claremont Ward 2 | 294 |  | 4
District No. 5 (1) | Madigan | Gagnon, d | [NAME]
Claremont Ward 3 | 25 |  | 3
District No. 6 (2) | Rollins, r | Rodeschin, r | Irwin, d | Franklin, d | [NAME]
Newport | 309 | 227 | 2 |  | 4
Unity | 72 | 73 |  |  | 1
TOTALS | 381 | 300 | 2 |  | 5
District No. 7 (1) | Grenier, r | [NAME], d | [NAME]
Acworth | 57 |  | 1
Goshen | 68 | 1 | 1
Langdon | 50 | 1
Lempster | 93
Washington | 94
TOTALS | 362 | 2 | 2
District No. 8 (1) | Laware, r | Sweeney, d | [NAME]
Charlestown | 197 |  | 1
District No. 9 (1)FL | Howard, r | Tanner, d | [NAME]
Cornish | 97 |  | 1
Croydon | 73 |  | 2
Grantham | 192 |  | 1
Newport | 342 |  | 1
Plainfield | 91 |  | 1
Springfield | 114
Sunapee | 383
Unity | 89 |  | 1
TOTALS | 1381 |  | 7
District No. 10 (1)FL | LaCasse, Sr., r | Cloutier, d | [NAME]
Claremont Ward 1 | 144 | 2 | 5
Claremont Ward 2 | 285 | 1 | 4
Claremont Ward 3 | 174 | 1 | 2
TOTALS | 603 | 4 | 11
District No. 11 (1)FL | Smith, r | Boland, d | [NAME]
Acworth | 54
Charlestown | 194 |  | 2
goshen | 68 |  | 1
Langdon | 50
Lempster | 83
Washington | 97
TOTALS | 546 |  | 3
Spreadsheet: jeff_dasovich__14041__final exam--Dasovich
Sheet: Income Statement

 |  |  |  | INCOME STATEMENT
 |  |  |  |  |  |  |  | Purchase |  | Pooling
(All figures in $millions) |  |  |  | AT&T |  | NCR |  | Method |  | Method
Total sales and revenues |  |  |  | 37285 |  | 6285
Total Costs and expenses |  |  |  | 32460 |  | 5632
Operating Income
Other income or loss |  |  |  | 232 |  | 64
Interest expenses |  |  |  | -828 |  | -67
Amortization of goodwill
Amortization of extra depreciation due to |  |  |  |  |  |  |  | -140
fair market valuation (1)
Amortization of extra depreciation |  |  |  |  |  |  |  | -9
Income before income taxes
Income tax (35.3% for AT&T; 43.2% for NCR)
Net income
Common shares outstanding (millions) |  |  |  | 1089 |  | 68 |  | 1289 |  | 1289
Earnings per share ($/share)
(1) Assumes that goodwill is amortized over 40 years and extra depreciation is amortized over 10 years.
Calculation for goodwill = $5.6 billion/40 years = $140 million.
Calculation for extra depreciation = $90 million/10 years = $9 million.
(All figures in $millions) |  |  |  | STATEMENT OF CASH FLOWS
Net Income
Incremental adjustments used to reconcile net
income to net cash provided by operations
Good will and extra depreciation expense
Net cash from operating activities