tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 65804d1266463610-work-daily-schedule-work-daily-schedule-redesign
Sheet: Suggestion

 | 2010-01-01 00:00:00
NAMES | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End
[NAME] | 07:00:00 | 19:00:00
[NAME] | 11:00:00 | 23:00:00
MARY | 19:00:00 | 19:00:00
JACK | 07:00:00 | 19:00:00
[NAME] | 07:00:00 | 15:00:00
2010-01-01 00:00:00 | 07:00:00 | 11:00:00 | 15:00:00 | 19:00:00 | 23:00:00 | 03:00:00
 | [NAME] | [NAME] | [NAME] | [NAME] | MARY | MARY |  | <-- This is not automated, just an example
 | JACK | [NAME] | [NAME] | MARY
 | [NAME] | JACK | JACK
 |  | [NAME]
 | 07:00:00 | 11:00:00 | 15:00:00 | 19:00:00 | 23:00:00 | 03:00:00
 | 07:00:00 | 11:00:00 | 15:00:00 | 19:00:00 | 23:00:00 | 03:00:00
 | 07:00:00 | 11:00:00 | 15:00:00 | 19:00:00 | 23:00:00 | 03:00:00
 | 07:00:00 | 11:00:00 | 15:00:00 | 19:00:00 | 23:00:00 | 03:00:00
 | 07:00:00 | 11:00:00 | 15:00:00 | 19:00:00 | 23:00:00 | 03:00:00
 | 07:00:00 | 11:00:00 | 15:00:00 | 19:00:00 | 23:00:00 | 03:00:00
Spreadsheet: db867775-47e8-4b3a-9d3e-4cc4aa95170a
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Nabídka číslo: | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15
Dodavatel |  |  | Odběratel
 |  |  |  |  |  | tel
 |  |  |  |  |  | e-mail
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | IČO
 |  |  |  |  |  | DIČ
 |  |  | Dokončení zakázky:
 |  |  | Datum expedice:
 |  |  | [NAME] podmínky:
 |  |  | Adresa dodání:
Název materiálu |  |  | [NAME] ([NAME]) | [NAME] ([NAME]) | Počet (ks) | [NAME] (m2) | Cena | Cena po slevě | Sleva % | Cena položky
[NAME] |  |  | 800 |  |  | 0 | 280 | 280 |  | 0
 |  |  | 800 |  |  | 0 | 280 | 280 |  | 0
 |  |  | 800 |  |  | 0 | 280 | 280 |  | 0 |  |  |  |  | 0
 |  |  | 800 |  |  | 0 | 280 | 280 |  | 0
 |  |  | 800 |  |  | 0 | 280 | 280 |  | 0
 |  |  | 1200 |  |  | 0 | 280 | 280 |  | 0
 |  |  | 1200 |  |  | 0 | 280 | 280 |  | 0
 |  |  | 1200 |  |  | 0 | 280 | 280 |  | 0
 |  |  | 1200 |  |  | 0 | 280 | 280 |  | 0
 |  |  | 1200 |  |  | 0 | 280 | 280 |  | 0
Samolepící páska |  |  |  |  |  |  | 130 | 130 |  | 0
Spona stěnová |  |  |  |  |  |  | 6 | 6 |  | 0
Vrut 4*50 mm |  |  |  |  |  |  | 0.5 | 0.5 |  | 0
Vrut 5*100 mm |  |  |  |  |  |  | 1.4 | 1.4 |  | 0
Kolíčky pro spojování |  |  |  |  |  |  | 1 | 1 |  | 0
Kolíčkovací šablona |  |  |  |  |  |  | 1000 | 1000 |  | 0
Podložka pro vrut |  |  |  |  |  |  | 0.7 | 0.7 |  | 0
PUR pěna |  |  |  |  |  |  | 135 | 135 |  | 0
Hák na přenášení ekopanelů |  |  |  |  |  |  | 250 | 250 |  | 0
Doprava |  |  |  |  |  |  | 1 | 1 | 0 | 0
 |  |  |  |  | Celkem (m2) | 0 |  |  | Celkem (CZK) | 0
Potvrdíl |  |  |  |  |  |  |  |  | Celkem včetně DPH (CZK) | 0
Datum
Spreadsheet: 542724d1508055984-drop-down-lists-book1-1-
Sheet: Sheet1

Agent Name |  | Agent | Tasks |  |  |  |  | Agent |  | Tasks
Kaira |  | [NAME] | Audit |  |  |  |  | [NAME]
[NAME] |  | Kaira | Processes
[NAME] |  | Kai | Variations
[NAME] |  | [NAME] | over view
Kai |  | [NAME] | end of day
 |  | Kai | communications
 |  | [NAME] | Grouping
Spreadsheet: daren_farmer__5393__hpl0729
Sheet: Sheet1

HPLN0729.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  AMI_CHOSKI / ENRON
FROM:  [NAME]  (TU ELECTRIC)
 |  |  |  |  |  | ** Sat / Sun | ** Monday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 7/29-30/2000 | 2000-07-31 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs. | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
Enron (FM) |  | LS HPL [NAME] |  | HPL
 |  |  |  |  | 0 to 60  0900hrs | 0 to 60  0900hrs | 0 to 60  0900hrs
 |  |  |  |  | 60  to 0 2100hrs | 60  to 0 2100hrs | 60  to 0 2100hrs
 |  | Firm Summary
Enron (S) |  | Reklaw |  | ENA | 10 | 0 | 0
Enron (S) |  | Oasis Sealy |  | ENA | 40 | 0 | 0
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
Empire (Enron) |  | TOG 3 |  | Empire | 1.4 | 1.4 | 1.4
Empire (Enron) |  | [NAME]. |  | Empire | 8 | 8 | 8
Empire (Enron) |  | SANDHILLS |  | Empire | 3.6 | 3.6 | 3.6
Empire (Enron) |  | Sterling Plant |  | Empire | 5 | 5 | 5
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 177812d1346438822-drop-down-box-varied-answers-example
Sheet: Sheet1

 |  |  |  |  |  | Answer One | 1 | 2 | 3 | 4 | 5
 | Answer one | 1 |  |  |  | 1 | A | F | K | P | U
 |  |  |  |  |  | 2 | B | G | L | Q | V
 |  |  |  |  |  | 3 | C | H | M | R | W
 | Answer two |  |  |  |  | 4 | D | I | N | S | X
 |  |  |  |  |  | 5 | E | J | O | T | Y
Spreadsheet: 728593d1618523640-multiple-criteria-lookup-using-date-range-multipe-criteria-lookup
Sheet: Sheet1

Criteria |  | Expected Result |  |  | Lookup Table
ID | Date | Year |  |  | ID | Begin Date | End Date | Year
CY | 2020-01-02 00:00:00 | 2020 |  |  | CY | 2020-01-01 00:00:00 | 2020-12-31 00:00:00 | 2020
CY | 2021-05-02 00:00:00 | 2021 |  |  | CY | 2021-01-01 00:00:00 | 2021-12-31 00:00:00 | 2021
VA | 2020-07-24 00:00:00 | 2021 |  |  | VA | 2019-05-01 00:00:00 | 2020-04-30 00:00:00 | 2020
VA | 2019-09-13 00:00:00 | 2020 |  |  | VA | 2020-05-01 00:00:00 | 2021-04-30 00:00:00 | 2021
YR | 2020-05-24 00:00:00 | 2020 |  |  | VA | 2021-05-01 00:00:00 | 2022-04-30 00:00:00 | 2022
YR | 2021-10-23 00:00:00 | 2022 |  |  | YR | 2019-07-01 00:00:00 | 2020-06-30 00:00:00 | 2020
 |  |  |  |  | YR | 2020-07-01 00:00:00 | 2021-06-30 00:00:00 | 2021
 |  |  |  |  | YR | 2021-07-01 00:00:00 | 2022-06-30 00:00:00 | 2022
Spreadsheet: 07296c68-386c-439e-ae6d-c17a93d8cce3
Sheet: 7

THE ALLSTATE CORPORATION
DEBT TO CAPITAL
($ in millions)
 |  |  |  | Dec. 31, |  |  |  | Sept. 30, |  |  |  | June 30, |  |  |  | March 31, |  |  |  | Dec. 31, |  |  |  | Sept. 30, |  |  |  | June 30, |  |  |  | March 31,
 |  |  |  | 2012 |  |  |  | 2012 |  |  |  | 2012 |  |  |  | 2012 |  |  |  | 2011 |  |  |  | 2011 |  |  |  | 2011 |  |  |  | 2011
Debt
 | Long-term debt |  | $ | 6057 |  |  | $ | 6057 |  |  | $ | 6058 |  |  | $ | 6058 |  |  | $ | 5908 |  |  | $ | 5907 |  |  | $ | 5907 |  |  | $ | 5908
Capital resources
 | Debt |  | $ | 6057 |  |  | $ | 6057 |  |  | $ | 6058 |  |  | $ | 6058 |  |  | $ | 5908 |  |  | $ | 5907 |  |  | $ | 5907 |  |  | $ | 5908
 | Shareholders' equity
 |  | Common stock |  | 9 |  |  |  | 9 |  |  |  | 9 |  |  |  | 9 |  |  |  | 9 |  |  |  | 9 |  |  |  | 9 |  |  |  | 9
 |  | Additional capital paid-in |  | 3162 |  |  |  | 3154 |  |  |  | 3154 |  |  |  | 3151 |  |  |  | 3189 |  |  |  | 3177 |  |  |  | 3165 |  |  |  | 3156
 |  | Retained income |  | 33783 |  |  |  | 33496 |  |  |  | 32880 |  |  |  | 32565 |  |  |  | 31909 |  |  |  | 31303 |  |  |  | 31237 |  |  |  | 31971
 |  | Deferred ESOP expense |  | -41 |  |  |  | -41 |  |  |  | -41 |  |  |  | -41 |  |  |  | -43 |  |  |  | -43 |  |  |  | -43 |  |  |  | -42
 |  | Treasury stock |  | -17508 |  |  |  | -17368 |  |  |  | -17272 |  |  |  | -17034 |  |  |  | -16795 |  |  |  | -16693 |  |  |  | -16387 |  |  |  | -16173
 |  | Unrealized net capital gains and losses |  | 2834 |  |  |  | 2880 |  |  |  | 2070 |  |  |  | 1874 |  |  |  | 1400 |  |  |  | 1065 |  |  |  | 1475 |  |  |  | 1072
 |  | Unrealized foreign currency translation
 |  | adjustments |  | 70 |  |  |  | 70 |  |  |  | 58 |  |  |  | 65 |  |  |  | 56 |  |  |  | 49 |  |  |  | 82 |  |  |  | 78
 |  | Unrecognized pension and other
 |  | postretirement benefit cost |  | -1729 |  |  |  | -1363 |  |  |  | -1383 |  |  |  | -1407 |  |  |  | -1427 |  |  |  | -1135 |  |  |  | -1156 |  |  |  | -1173
 |  | Total shareholders' equity |  | 20580 |  |  |  | 20837 |  |  |  | 19475 |  |  |  | 19182 |  |  |  | 18298 |  |  |  | 17732 |  |  |  | 18382 |  |  |  | 18898
 |  | Total capital resources | $ | 26637 |  |  | $ | 26894 |  |  | $ | 25533 |  |  | $ | 25240 |  |  | $ | 24206 |  |  | $ | 23639 |  |  | $ | 24289 |  |  | $ | 24806
Ratio of debt to shareholders' equity |  |  |  | 29.43148688046647 | % |  |  | 29.06848394682536 | % |  |  | 31.10654685494223 | % |  |  | 31.58169116880409 | % |  |  | 32.28768171384851 | % |  |  | 33.31265508684864 | % |  |  | 32.13469698618213 | % |  |  | 31.26256746745688 | %
Ratio of debt to capital resources |  |  |  | 22.73904718999887 | % |  |  | 22.52175206365732 | % |  |  | 23.72615830493871 | % |  |  | 24.00158478605388 | % |  |  | 24.40717177559283 | % |  |  | 24.98836668217776 | % |  |  | 24.31965087076454 | % |  |  | 23.81681851165041 | %
Spreadsheet: kam_keiser__18014__Reco!J11
Sheet: Accrual

 | Enron North America
 | Business Analysis & Reporting - Portfolio Accounting
 | Income Statement Reconciliation - 2001 YTD
 |  | Book(s):
 |  | Subledger:
 |  | Month:
 | Responsibility Codes:  Financial Ops (FO), Financial Settlements (FS), Client Services (CS), Risk Management (RM), To Be Determined (TBD)
 | Types of Variances:  Prior Year Adjustments (P), Current Year Adjustments - Timing (T), Exposure (E), Other (O)
 |  | Resp. |  |  | Outstanding
Bookcode | Month | Code | Type | Description | 2000 ADJ * | [NAME]* | Feb-01* | Mar-01* | Apr-01* | May-01* | [NAME] | [NAME] | Aug-01* | Sep-01* | Oct-01* | Nov-01* | Dec-01* | Total**
 | May | FO | E | Broker fees on stmt but not in correct pc |  |  |  |  |  | -380 | 380
 | May | FO | O | [NAME] |  |  |  |  |  | -77 | 596 |  |  |  | 20
 | Jun | FS | O | Duke Energy Trading & Marketing (Offset PC 11837-$32 Rounding diff ) |  |  |  |  |  |  | -66096 | 66096
 | Jun | FS | O | El Paso Merchange Energy (offset with pc 11816; deal v99538.1 $74,550 ) |  |  |  |  |  |  | 74550 | -74550
 | Jul | RM | O | Texaco Natural Gas Inc - net w/ PC 11829 - revalue VB9536 using fixed price of 3.7405 and float of 3.79 (inv 0107903) |  |  |  |  |  |  |  | 945 |  | -4455 | 8910 | -5400
 | Aug | RM | O | Broker fees not taken - added to DPR (2nd WD) after liquidations ran |  |  |  |  |  |  |  |  | -3003 | 3003
 | Oct | FO | O | Broker fees taken by DPR but not booked in GL - offset in FT Texas |  |  |  |  |  |  |  |  |  |  | -20323 | 20323
 | Oct | FO | O | ZH book didn't book liquidations with [NAME] - will book in Nov |  |  |  |  |  |  |  |  |  |  | 20000 | -20000
 | Nov | FS | O | Third party variance |  |  |  |  |  |  |  |  |  |  |  | 70778
 |  |  |  | Subtotal
 | LESS 2001 ADJ TO DPR VS 2000 ACTUAL:
 | LESS 2001 ADJ TO G/L VS 2000 DPR:
 | SUBTOTAL - 2000 [NAME] ONLY
 | INCEPTION TO DATE RECONCILIATION
 | OUTSTANDING G/L ADJUSTMENTS:
 | G/L VARIANCES VS 2000 DPR
 | G/L VARIANCES VS 2001 DPR (SEE ABOVE)
 | TOTAL OUTSTANDING G/L ADJUSTMENTS
 | OUTSTANDING DPR ADJUSTMENTS:
 | DPR VARIANCES VS 2000 G/L
 | DPR VARIANCES VS 2001 G/L (SEE ABOVE)
 | TOTAL OUSTANDING DPR ADJUSTMENTS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Check
 | TOTAL OUTSTANDING VARIANCES - BY MONTH
 | *  FOR RESPONSIBILITY CODE:         RM = (DR)/CR |  |  |  |  |  |  |  |  |  |  | DPR OVER/(UNDER) G/L -  INCEPTION TO DATE
 | FOR RESPONSIBILITY CODE:       FS or FO = DR/(CR)
 | **  IF THE AMOUNT IN THIS COLUMN IS: |  |  |  |  |  |  |  |  |  |  | ACCRUAL (HYPERION)
 | (BRACKETED) = DPR IS LESS THAN THE G/L
 | W/O BRACKETS = DPR IS GREATER THAN THE G/L |  |  |  |  |  |  |  |  |  |  | DIFFERENCE
Spreadsheet: b05dec38-6462-43a8-88fd-611b7a7177a2
Sheet: Sheet1

Life Expectancy at Birth (in Years) by County, Maine, 2007 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 | Male |  | Female
 | Life Expectancy (in Years) | 90% CI | Life Expectancy (in Years) | 90% CI
Maine | 76 |  | 81.3
County
Androscoggin | 75.2 | 74.7, 75.5 | 79.9 | 79.4, 80.3
Aroostook | 74.6 | 74.1, 75.0 | 80.1 | 79.6, 80.6
Cumberland | 77.1 | 76.7, 77.3 | 81.7 | 81.3, 82.0
Franklin | 76.1 | 75.5, 76.7 | 80.3 | 79.5, 80.9
Hancock | 76 | 75.5, 76.5 | 81.3 | 80.7, 81.9
Kennebec | 75.7 | 75.2, 76.1 | 80.4 | 79.9, 80.7
Knox | 76.7 | 76.1, 77.2 | 81.4 | 80.8, 82.0
Lincoln | 77.3 | 76.6, 77.9 | 81 | 80.3, 81.5
Oxford | 74.5 | 73.9, 74.9 | 80 | 79.4, 80.5
[NAME] | 75 | 74.6, 75.3 | 80.1 | 79.7, 80.4
Piscataquis | 74.3 | 73.5, 75.0 | 80.5 | 79.6, 81.2
Sagadahoc | 76.5 | 75.9, 76.9 | 80.5 | 79.9, 81.1
Somerset | 74.8 | 74.2, 75.3 | 79.8 | 79.2, 80.3
[NAME] | 75.4 | 74.7, 75.9 | 80.8 | 80.1, 81.4
Washington | 73.1 | 72.5, 73.6 | 80.1 | 79.4, 80.6
York | 77 | 76.6, 77.3 | 81.5 | 81.1, 81.9
CI = Confidence Interval.
Data Source:  Kulkarni SC, Levin-Rector A, Ezzati J, [NAME].  Falling behind: life expectancy in US counties from 2000 to 2007 in an international context.  Population Health Metrics 2011;9:16, Web appendix (http://www.pophealthmetrics.com/content/supplementary/1478-7954-9-16-s1.doc, accessed 3/22/12).
Spreadsheet: 54819d1254864315-vlookup-with-same-values-vlookup-1-
Sheet: Sheet2

 | Nov | Dec | Jan
LA | 121 | 43243 | 456790
Washington | 12121 | 7878 | 6666
New York | 100 | 234234 | 44342
New York | 131313 | 6790 | 3157
LA | 100 | 54533 | 5807
Washington | 100 | 44567 | 2358
LA | 343636 | 45478 | 11114
LA | 356 | 45479 | 5646
New York | 45778 | 679 | 34579
Washington | 123567 | 479 | 362
Spreadsheet: 889958d1741030714-xlookup-with-varying-dates-xlookup-with-varying-dates
Sheet: Lineups

Phillies | 1-Apr | 2-Apr | 3-Apr | 4-Apr | 5-Apr | 6-Apr | 7-Apr | 8-Apr
[NAME] | X | x | x | x | x | x | x | x
[NAME] |  | x | x | x |  | x | x | x
[NAME] | x | x | x | x | x | x | x | x
Sandy | X |  |  |  | x | x
[NAME] | x | x | x | x |  | x | x | x
[NAME] |  | x |  |  | X
[NAME] | x |  | x | x | x |  | x | x
Dodgers | 3-Apr | 4-Apr | 5-Apr | 7-Apr | 9-Apr | 11-Apr | 12-Apr | 13-Apr
[NAME] | x |  | x | x | x | x | x | x
George |  | x | x | x |  |  | x
[NAME] | x | x | x | x | x |  | x | x
[NAME] |  |  | x |  | x | x
[NAME] | x |  |  | x |  |  |  | x
[NAME] |  | x | x | x | x | x | x
Ned | x | x |  |  |  | x | x | x
[NAME] | x | x |  |  | x | X |  | X
Spreadsheet: 7309c893-1c15-45b5-9a55-029ef378d82a
Sheet: Sheet1

Superintendent of Public Instruction - NON (North Dakota) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Downloaded at 6/20/2013 1:49:44 AM
Precincts Reporting: 693/693 - Total Ballots Cast: 94306
2000 Primary Election - OFFICIAL RESULTS
Precinct | [NAME] | [NAME] | TOTALS
Combined Precinct | 163 | 384 | 547
TOTAL | 163 | 384 | 547
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 828526d1683571411-combine-duplicate-rows-and-empty-columns-s666-pq-combine-duplicate-rows-and-empty-columns
Sheet: Sheet1

Company | COL 1 | COL 2 | COL 3 |  |  | COL 1 | COL 2 | COL 3 |  | Company | COL 1 | COL 2 | COL 3
Company 1 | A |  |  |  | Company 1 | A | B | C |  | Company 1 | A | B | C
Company 1 |  | B |  |  |  |  |  |  |  | Company 2 | A | B | C
Company 1 |  |  | C
Company 2 |  |  | C |  | Company 2 | A | B | C
Company 2 |  | B
Company 2 | A
Spreadsheet: 35211d1232743548-referencing-a-cell-based-on-position-of-another-cell-test
Sheet: Sheet1

Project Name
Project 1 | ww1 | ww2 | ww3 | ww4 | ww5 | ww6 | ww7 | ww8 | ww9
Plan | Phase 1 |  | Phase 2 |  |  | Phase 3
Support | ww3 | ww4 | ww5 | ww6 | ww7 | ww8 | ww9
Plan | Development |  |  |  |  | Testing
Spreadsheet: 3bcdcdd6-e409-4442-9067-f9853ee2baac
Sheet: Weekly Changes

 |  |  | Rail to port--Week to Week Changes |  |  |  |  |  |  |  |  | Rail to port--Changes in 4-week averages
 |  |  | MS | TX | Cross-Border-2 | Cross-Border | PNW | East coast | Total |  |  | MS | TX | Cross-Border-2 | Cross | PNW | East coast | Total
% chg from prior week |  |  |  |  |  | n/a |  |  |  |  | % chg from prior week |  |  |  | n/a
% chg from prior year |  |  |  |  |  | n/a |  |  |  |  | % chg from prior year |  |  |  | n/a
% chg from 4-yr avg. |  |  |  |  |  | n/a |  |  |  |  | % chg from 4-yr avg. |  |  |  | n/a
 |  |  | 4-yr avg |  |  |  |  |  | 4-yr avg |  |  | 4-yr avg |  |  |  |  |  | 4-yr avg
3rd Quarter 2014 |  |  |  |  |  | n/a
3rd Quarter 2013 |  |  |  |  |  | n/a
Change |  |  |  |  |  | n/a
Spreadsheet: 175260d1345472343-vlookup-multiple-conditions-rt-test
Sheet: Sheet1

2012-09-30 00:00:00 | 2012-09-30 00:00:00 | 2012-10-01 00:00:00 | 2012-10-02 00:00:00 | 2012-10-03 00:00:00 | 2012-10-04 00:00:00 | 2012-10-05 00:00:00 | 2012-10-06 00:00:00
 | 2012-09-30 00:00:00 | 2012-09-30 00:00:00 | 2012-10-01 00:00:00 | 2012-10-02 00:00:00 | 2012-10-03 00:00:00 | 2012-10-04 00:00:00 | 2012-10-05 00:00:00
IA 1 |  | 11:45:00 | 11:45:00 | 11:59:00 | 11:45:00 | 11:45:00
IA 2 |  | 10:30:00 | 10:30:00 | 10:30:00 | 10:30:00 | 10:30:00
IA 3 |  | 09:00:00 | 09:00:00 | 09:00:00 | 09:00:00 | 09:00:00
IA 4 |  | 08:00:00 | 08:00:00 | 08:00:00 | 08:00:00 | 08:00:00
IA 5 |  | 08:00:00 | 08:00:00 | 08:00:00 | 08:00:00 | 08:00:00
IA 6 |  | 08:00:00 | 08:00:00 | 08:00:00 | 08:00:00 | 08:00:00
OA 1
OA 2
OA 3
SA 1 |  | 08:00:00 | 08:00:00 | 08:00:00 | 08:00:00 | 08:00:00
SA 2 |  | 08:00:00 | 08:00:00 | 08:00:00 | 08:00:00 | 08:00:00
M1
M2
2012-10-01 00:00:00 | 2012-10-01 00:00:00 | 2012-10-02 00:00:00 | 2012-10-03 00:00:00 | 2012-10-04 00:00:00 | 2012-10-05 00:00:00 | 2012-10-06 00:00:00 | 2012-10-07 00:00:00
 | 2012-10-01 00:00:00 | 2012-10-01 00:00:00 | 2012-10-02 00:00:00 | 2012-10-03 00:00:00 | 2012-10-04 00:00:00 | 2012-10-05 00:00:00 | 2012-10-06 00:00:00
IA 1 |  | 08:00:00 | 11:45:00 | 08:00:00 | 11:45:00 | 09:00:00
IA 2 |  | 11:45:00 | 08:00:00 | 10:30:00 | 10:30:00 | 08:00:00
IA 3 |  | 09:00:00 | 09:00:00 | 11:45:00 | 11:45:00 | 11:45:00
IA 4 |  | 08:00:00 | 08:00:00 | 08:00:00 | 08:00:00 | 08:00:00
IA 5 |  | 08:00:00 | 08:00:00 | 08:00:00 | 08:00:00 | 08:00:00
IA 6 |  | 08:00:00 | 08:00:00 | 08:00:00 | 08:00:00 | 08:00:00
OA 1
OA 2
OA 3
SA 1 |  | 08:00:00 | 08:00:00 | 08:00:00 | 08:00:00 | 08:00:00
SA 2 |  | 08:00:00 | 08:00:00 | 08:00:00 | 08:00:00 | 08:00:00
M1
M2
Spreadsheet: 830904d1685230512-most-frequent-value-based-on-criteria-edit-most-frequent-value-based-on-criteria
Sheet: Sheet1

Client Number | Client Name | [NAME] | Amount | Sales Month
 | Client 1 | [NAME] | 12 | May |  | If [NAME] is empty, then exclude from calculation.
 | Client 2 | [NAME] | 45 | May |  | Also, if [NAME] is empty or includes the text "Unknown", then exclude from calculation.
 | Client 3 | [NAME] | 27 | May
 | Client 4 | [NAME] | 87 | May |  |  | [NAME] | Which Sales Person appears most frequently overall?
 | Client 5 | [NAME] | 19 | May
 | Client 6 | [NAME] | 52 | June |  |  | [NAME] | Which Sales Person appears most frequently in May?
 | Client 7 | [NAME] | 24 | June
 | Client 8 | [NAME] | 67 | June
 | Client 9 | [NAME] | 42 | June |  | Expected results: |  | [NAME] overall
 | Client 10 | [NAME] | 52 | June |  |  |  | [NAME] in May
 | Client 11 | [NAME] | 57 | June
 | Client 12 | [NAME] | 93 | May
 | Client 13 |  | 12
 | Client 14 |  | 42
 | Client 15 |  | 36
 | Client 16 |  | 91
 | Client 17 |  | 33
 | Client 18 |  | 18
 | Client 19 |  | 36
 | Client 20 |  | 43
 |  | Unknown PTT
 |  | RES Unknown
 |  | PLF Unknown
 |  | Unknown GRF
Spreadsheet: b38c9e9d-4532-4a17-be8b-c99c5e9d93a5
Sheet: Sheet1

GENERAL | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15
Ordinance Fact Sheet |  |  |  |  |  |  | Ordinance Number
Brief Title |  |  | Approval Deadline |  | Reason
 | Termination of the 10th & Troost TIF Plan
Details |  |  |  |  | Positions/Recommendations
 | Specific Address |  |  |  | Sponsor
 |  |  |  |  | Programs,
 |  |  |  |  | Departments,
 |  |  |  |  | or Groups
 |  |  |  |  | Affected
 | Reason For Legislation
 |  |  |  |  | Applicants / |  | Applicant
 |  |  |  |  | Proponents |  | Tax Increment Financing Commission
 |  |  |  |  |  |  | City Department
 |  |  |  |  |  |  | Other
 |  |  |  |  | Opponents |  | Groups or Individuals
 |  |  |  |  |  |  | Basis of opposition
 |  |  |  |  | Staff
 |  |  |  |  | Recommendation |  | X |  | For
 |  |  |  |  |  |  |  |  | Against
 |  |  |  |  |  |  | Reason Against
 |  |  |  |  | Board or
 |  |  |  |  | Commission |  | By |  |  | Tax Increment Financing Com.
 |  |  |  |  | Recommendation |  |  |  |  |  | Resolution
 |  |  |  |  |  |  | X |  | For |  |  |  | Against |  | No action taken
 |  |  |  |  |  |  |  |  | For, with revisions or conditions
 |  |  |  |  |  |  |  |  | (see details column for conditions)
 |  |  |  |  | Council
 |  |  |  |  | Committee Actions |  |  |  | Do pass
 |  |  |  |  |  |  |  |  | Do pass (as amended)
 |  |  |  |  |  |  |  |  | Committee Sub.
 |  |  |  |  |  |  |  |  | Without Recommendation
 |  |  |  |  |  |  |  |  | Hold
 |  |  |  |  |  |  |  |  | Do not pass
 |  |  |  |  |  |  |  |  |  |  |  | (Continued on reverse side)
Details |  |  |  |  | Policy/Program Impact
 |  |  |  |  | Policy or Program
 |  |  |  |  | Change |  | X |  | No |  |  |  | Yes
 |  |  |  |  | Operational
 |  |  |  |  | Impact
 |  |  |  |  | Assessment
 |  |  |  |  | Finances
 |  |  |  |  | Cost & Revenue
 |  |  |  |  | Projections --
 |  |  |  |  | Including Indirect
 |  |  |  |  | Costs
 |  |  |  |  | Financial Impact
 |  |  |  |  | Fund Source (s)
 |  |  |  |  | and Appropriation
 |  |  |  |  | Account Codes
Applicable Dates:
 | Approved by TIF Commission on July 13, 2005 by Resolution No. 7-5-05 |  | on 12-14-05, Resolution #12-6-05
Fact Sheet Prepared by:
Reviewed by:
Reference Numbers
Spreadsheet: 328864d1404122312-sumifs-selecting-a-column-from-a-range-example-sheet
Sheet: Total

March 2014
Done By | Activity 1 | Activity 2 | Activity 3 | Activity 4 | Activity 5 | Activity 6 | Activity 7 | Activity 8 | Activity 9 | Activity 10 | Activity 11 | Activity 12 | Total
AB
BC
CD
DE
EF
FG
GH
HI
IJ
JK
KL
LM
MN
Totals for Hours
Spreadsheet: a70ca3ff-074f-4820-a8c9-0594b01e8419
Sheet: Self Contained Classrm.

[NAME]: |  | High Cost Risk Pool Data Collection 2012-2013
Student SSID | Average Cost of Special Education Self Contained Classroom Per Student for Your LEA | Description of Unique Special Education Services as per Student IEP | Extraordinary Costs of Services Provided to Each Student (Prorate if services were for less than a full year) | Total Costs of Special Education Services  Average Classroom costs + Extraordinary Costs | Subtract $19,152  (3X the 2011-12 Average Per Pupil Expenditure for Utah) ($6384) | Medicaid  Reimbursement Received       (Subtracted from Total Costs) | Eligible Amount of Risk Pool Money
123456789 | 6000 | Physical Therapy, SLP, therapy swing, 2:1 aide | 22000 |  |  | 600
 |  |  |  |  |  | Subtotal
Spreadsheet: 0eaf62f5-d624-4cf0-83d5-6cf3de13a663
Sheet: Sheet1

Part | Value
C1,C2,C4 | GRM155R60J105KE19D
C3,C5 | GRM155R61A104KA01D
D1 | ASMT-YTB0-0AA02
J1 | 20021521-00010T1LF
Q1,Q2,Q3 | [NAME]
R1,R2 | ERJ-2GEJ910X
R3 | ERJ-2GEJ151X
R4,R5,R6 | ERJ-2GEJ103X
U1 | STM8S003F3P6
U2 | LSM330DLCTR
J2 | BH600-ND
Spreadsheet: 124242d1318267078-data-from-date-to-date-book1
Sheet: Sheet1

 |  | 2011-01-01 00:00:00 | 2011-01-02 00:00:00 | 2011-01-03 00:00:00 | 2011-01-04 00:00:00 | 2011-01-05 00:00:00 | 2011-01-06 00:00:00 | 2011-01-07 00:00:00 | 2011-01-08 00:00:00 | 2011-01-09 00:00:00 | 2011-01-10 00:00:00 | 2011-01-11 00:00:00 | 2011-01-12 00:00:00
from | to | 6 | 8 | 2 | 8 | 9 | 5 | 2 | 7 | 4 | 1 | 6 | 8
2011-01-04 00:00:00 | 2011-01-09 00:00:00
the average
Spreadsheet: 191208d1351969780-counting-the-numbers-with-3-book1-36-
Sheet: Sheet1

Year | 2010 |  | Consumption Ratio |  |  |  |  |  | All | All | All
Month | Apr |  |  |  |  |  |  |  | 2009 | Jan | A
Product | B |  | to get the cosumption ratio i need to show herethe result of column F with number  <= 3 over the total number of items in the same column |  |  |  |  |  | 2010 | Feb | B
 |  |  | the result will be based on the criteria which the user will select in the 1st 3 row of column B |  |  |  |  |  | 2011 | Mar | C
 |  |  |  |  |  |  |  |  | 2012 | Apr | D
 |  |  |  |  |  |  |  |  |  | May
Product | Year | Month | Stock | Consumed | left |  |  |  |  | Jun |  |  |  | your formulae is here
B | 2009 | Aug | 20 | 1 | 1 |  |  |  |  | Jul
B | 2010 | Apr | 10 | 6 |  |  |  |  |  | Aug
C | 2010 | May | 9 |  |  |  |  |  |  | Sep
D | 2011 | Jun | 12 | 5 |  |  |  |  |  | Oct
A | 2012 | Jul | 7 | 3 |  |  |  |  |  | Nov
B | 2009 | Aug | 5 |  | 2 |  |  |  |  | Dec
C | 2010 | Sep | 34 | 34
D | 2009 | Jan | 5 | 8
A | 2010 | Feb | 6 | 7
B | 2010 | Apr | 23 | 20 | 5
D | 2011 | Apr | 45 | 20
A | 2012 | May | 3 | 1