tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 840457d1692750254-would-like-to-list-several-cells-from-a-lookup-incl-other-data-vstack-hstack-mosom-4
Sheet: Sheet2

Manager: | Manager 3
Roles: |  |  |  |  |  |  |  |  |  |  | Role 3 | Role 5
 | Role 3 |  | Topic 1 | Module 1 | Area 1 | Focus 1 | y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Role 3 |  |  |  |  |  |  |  |  |  |  |  |  |  | Role 5
 | Role 5 |  | Topic 1 | Module 1 | Area 1 |  | y |  |  |  | Module 1 | Area 1 | Focus 1 | y |  |  |  |  |  |  |  |  |  |  | Module 1 | Area 1 | Focus 1 | y |  |  |  |  |  |  |  |  |  |  | Module 1 | Area 1 |  | y
 |  |  | Topic 1 | Module 1 | Area 2 | Focus 1 | y |  |  | Topic 1 | Module 1 | Area 1 |  | y |  |  |  |  |  |  |  |  |  | Topic 1 | Module 1 | Area 1 |  | y |  |  |  |  |  |  |  |  |  | Topic 1 | Module 1 | Area 2 | Focus 1 | y
 |  |  | Topic 1 | Module 2 | Area 2 | Focus 1 | y |  |  | Topic 1 | Module 1 | Area 1 |  | y |  |  |  |  |  |  |  |  |  | Topic 1 | Module 1 | Area 2 | Focus 2 | y |  |  |  |  |  |  |  |  |  | Topic 1 | Module 2 | Area 1 | Focus 1 | y
 |  |  | Topic 1 | Module 2 | Area 3 | Focus 1 | y |  |  | Topic 1 | Module 1 | Area 2 | Focus 1 | y |  |  |  |  |  |  |  |  |  | Topic 1 | Module 2 | Area 1 | Focus 2 | y |  |  |  |  |  |  |  |  |  | Topic 1 | Module 2 | Area 1 | Focus 2 | y
 |  |  | Topic 1 | Module 1 | Area 2 | Focus 2 | y |  |  | Topic 1 | Module 2 | Area 2 | Focus 1 | y |  |  |  |  |  |  |  |  |  | Topic 1 | Module 2 | Area 2 | Focus 1 | y |  |  |  |  |  |  |  |  |  | Topic 1 | Module 2 | Area 3 | Focus 2 | y
 |  |  | Topic 1 | Module 2 | Area 1 | Focus 2 | y |  |  | Topic 1 | Module 2 | Area 3 | Focus 1 | y |  |  |  |  |  |  |  |  |  | Topic 1 | Module 2 | Area 3 | Focus 1 | y
 |  |  | Topic 1 | Module 2 | Area 3 | Focus 2 | y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Topic 1 | Module 2 | Area 3 | Focus 2 | y |  |  |  |  |  |  |  |  |  | Topic 1 | Module 1 | Area 1 | Focus 1 | n
 |  |  | Topic 1 | Module 2 | Area 1 | Focus 1 | y |  |  | Topic 1 | Module 2 | Area 1 | Focus 1 | n |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Topic 1 | Module 1 | Area 1 |  | n
 |  |  | Topic 1 | Module 2 | Area 1 | Focus 1 | n |  |  | Topic 1 | Module 2 | Area 1 | Focus 2 | n |  |  |  |  |  |  |  |  |  | Topic 1 | Module 1 | Area 1 |  | n |  |  |  |  |  |  |  |  |  | Topic 1 | Module 1 | Area 2 | Focus 2 | n
 |  |  | Topic 1 | Module 2 | Area 1 | Focus 2 | n |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Topic 1 | Module 1 | Area 2 | Focus 1 | n |  |  |  |  |  |  |  |  |  | Topic 1 | Module 2 | Area 2 | Focus 1 | n
 |  |  | Topic 1 | Module 1 | Area 1 |  | n |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Topic 1 | Module 2 | Area 1 | Focus 1 | n |  |  |  |  |  |  |  |  |  | Topic 1 | Module 2 | Area 3 | Focus 1 | n
 |  |  | Topic 1 | Module 1 | Area 2 | Focus 1 | n
 |  |  | Topic 1 | Module 1 | Area 1 | Focus 1 | n
 |  |  | Topic 1 | Module 1 | Area 2 | Focus 2 | n
 |  |  | Topic 1 | Module 2 | Area 2 | Focus 1 | n
 |  |  | Topic 1 | Module 2 | Area 3 | Focus 1 | n
Spreadsheet: 714874d1611416419-return-value-of-latest-balance-for-each-month-and-accounts-copie-de-forum-excel-22-jan-2021-1-complete
Sheet: Épargnes Inv.

1) | [NAME] for latest balance (cells D6 to D9) |  |  |  |  | Thanks again for taking the time:) !! I appreciate it!
2) | [NAME] to update CLOSING BALANCE after each deposit/withdrawal and ANNUAL REPORT (Column G)
3) | [NAME] to know profit loss on the "ANNUAL REPORT" (Column F)
 |  |  | BALANCE REPORT | PROFIT/ LOSS | CLOSING BALANCE
 | Solde actuel des comptes: | AR
 |  | FT
 |  | PL
 |  | UR
DATE | Description | ACCOUNT | AMOUNT | BALANCE REPORT | PROFIT/ LOSS | CLOSING BALANCE
2020-01-10 00:00:00 | Deposit | AR | 200
2020-01-21 00:00:00 | Deposit | AR | 200
2020-01-30 00:00:00 | Deposit | AR | 200
2020-03-01 00:00:00 | Deposit | FT | 300
2020-03-01 00:00:00 | Deposit | AR | 25
2020-03-05 00:00:00 | Withdrawal | AR | -30
2020-03-11 00:00:00 | Withdrawal | FT | -45
2020-03-13 00:00:00 | Withdrawal | AR | 20
2020-03-01 00:00:00 | Deposit | PL | 60
2020-03-01 00:00:00 | Deposit | UR | 80
2020-05-01 00:00:00 | Annual report (balance now at 230$) | AR | 0 | 230 |  | 230
2020-05-01 00:00:00 | Annual report (balance now at 280$) | PL | 0 | 320 |  | 320
2020-05-01 00:00:00 | Annual report (balance now at 55$) | PL | 0 | 55 |  | 65
2020-05-01 00:00:00 | Annual report (balance now at 77$) | UR | 0 | 77 |  | 77
2020-06-15 00:00:00 | Withdrawal | AR | -50
2020-06-15 00:00:00 | Withdrawal | FT | -60
2020-06-15 00:00:00 | Withdrawal | PL | -40
2020-06-15 00:00:00 | Withdrawal | UR | -70
2021-01-01 00:00:00 | Deposit | AR | 120
2021-01-01 00:00:00 | Deposit | FT | 100
2021-01-01 00:00:00 | Deposit | PL | 90
2021-01-01 00:00:00 | Deposit | UR | 80
Spreadsheet: 605370d1547051723-alphabetize-column-while-moving-associated-data-alphabetize-help-please
Sheet: BrandA

PartnerName
 | 853.1860237720916 | 375.6516517005425 | 742.8905068748893 | 465.148505049008 | 713.8785438915487 | 61.9728102575704 | 176.6720359890205
 | 120.9278517469567 | 326.2795641754846 | 982.5640059101114 | 671.3332831275872 | 785.8682030187438 | 533.1068395207539 | 101.1056783347081
 | 641.6170801163837 | 653.646599590389 | 551.7438109801218 | 343.8804532582721 | 155.7135806007954 | 431.1297379000154 | 159.178495583123
 | 884.3186249959682 | 501.4044942031258 | 982.5098472276414 | 114.1533188674195 | 984.0684392464321 | 45.35102421393822 | 631.5246009882793
 | 590.7382996083852 | 250.4543678766191 | 321.8514854286025 | 489.2868526651323 | 263.9653577655009 | 687.1787243442819 | 36.76774728769438
Spreadsheet: 9a54f7e5-57f3-4615-b584-1de3660f9a7a
Sheet: Index

 |  | Ameriprise Financial, Inc.
Statistical Supplement Information
Table of Contents
 |  |  | Page
 | Ameriprise Financial, Inc.
 |  | Statistical Supplement Presentation | 4
 |  | Consolidated GAAP Income Statements | 5
 |  | GAAP to Operating Reconciliation | 6
 |  | Operating Income Statements | 7
 |  | Highlights | 9
 |  | [NAME], Per Share and Capital Summary | 10
 |  | Segment Summary | 11
 | Advice & Wealth Management Segment
 |  | Segment Operating Income Statements | 14
 |  | Segment Metrics | 15
 | Asset Management Segment
 |  | Segment Operating Income Statements | 17
 |  | Segment Metrics | 18
 |  | Columbia Asset Management Products | 19
 |  | Threadneedle Asset Management Products | 20
 |  | Mutual Fund Performance | 21
 | Annuities Segment
 |  | Segment Operating Income Statements | 23
 |  | Segment Metrics | 24
 | Protection Segment
 |  | Segment Operating Income Statements | 26
 |  | Segment Metrics | 27
 | Corporate & Other Segment
 |  | Segment Operating Income Statements | 29
 | Eliminations
 |  | Operating Income Statements | 30
 | Balance Sheet and Ratings Information
 |  | Consolidated Balance Sheets | 32
 |  | Capital and Ratings Information | 33
 |  | Investments | 34
 | Non-GAAP Financial Information |  | 35
 | Glossary of Selected Terminology
 |  | Glossary of Selected Terminology - Segments | 36
 |  | Glossary of Selected Terminology | 37
 | Exhibit A
 |  | Disclosed Items | 39
 | Exhibit B
 |  | Reconciliation of GAAP Segment Income Statements to Segment Operating Income Statements | 45
 |  | Reconciliation of GAAP Metrics to Operating Metrics | 47
Spreadsheet: 112589d1308675848-help-with-multiple-sheets-new-hub-workstream-log2
Sheet: Overview

Southern Hub Workstream Log |  | Overview |  | April - June
Work Priority |  |  | 1 - High | 2 - Medium | 3 - Low
Type | Project Description | Priority | Name | Request Origin | Request Date | Estimated Deadline | Status
QRP-Related Task | TEST | 1 | Operations | 2011-06-10 00:00:00 | 2011-06-15 00:00:00 | Initiated
Presentation | a test | 3 | AB | 2011-05-09 00:00:00 | 2011-05-06 00:00:00 | Not Started
QRP-Related Task | TEST | 1 | Operations | 2011-06-10 00:00:00 | 2011-06-15 00:00:00 | Initiated
Presentation | a test | 1 | Operations | 2011-05-09 00:00:00 | 2011-05-06 00:00:00 | Not Started
Reports |  |  |  | 2011-06-10 00:00:00 | 2011-06-15 00:00:00 | Initiated
Spreadsheet: 03113223-47e5-4817-83e2-bf23f14917a6
Sheet: sizing

Assume:  Q = 15 MGD, effluent P = 1 mg/L, 1 wt% P in duckweed
 |  |  |  | Area needed at given Duckweed Density |  |  |  | @ 20 d HRT
 |  |  |  | 800 lb/Ac | 1000 lb/Ac | 2000 lb/Ac |  | Digester Vol
Influent P, mg/L | ∆ P, mg/L | ∆ P, lb/d | Duckweed, lb/d | Acres/d | Acres | Acres |  | ft3 | gal | Height
3
8
10
14
 |  |  |  |  |  |  | Diameter | 100 | ft
 |  |  | g/L |  |  | wet | Area |  | ft2
 |  |  | lb/L |  |  | dry
 |  |  | lb/gal
 | Feed |  | lb/ft3
 |  |  |  | IN | OUT | 28% of TS removed
 |  |  |  |  |  | lb/d | lbs TS After Digestion
 |  |  |  |  |  | ft3/d | Digested Sludge
 |  |  |  | ∆TS/d |  | lb TS/d
 |  |  |  |  |  | [NAME] | Methane Produced L/g ∆TS |  |  | L/g
 |  |  |  |  | 1000 | Btu/ft3 CH4 |  |  |  | ft3/g
 |  |  |  |  |  | Btu/d Produced |  |  |  | ft3/lb destroyed
 |  |  |  |  |  | Btu/min
 |  |  |  |  | 0.55 | MW equivalent
 |  |  |  |  |  |  |  | P in liquid calculation
Spreadsheet: 543297d1508328442-extract-min-of-variable-length-numbers-after-text-test
Sheet: Sheet1

 | Project Phase | Beginning + Duration |  |  |  |  | Project Phase | Expected outcome
 | A | T0 + 14 |  |  |  |  | A | T0 + 21 |  | as min (T0 and T12) is T0 and [NAME] (14 and 21)
 | B | T0 + 28 |  |  |  |  | B | T0 + 8 |  | etc …
 | C | T0 + 15 |  |  |  |  | C | T0 + 15
 | D | T14 + 12 |  |  |  |  | D | T14 + 13
 | A | T12 + 21
 | B | T5 + 8
 | C | T7+14
 | D | T14+13
Spreadsheet: chris_stokley__4001__Closing 091901 cert debtor
Sheet: Cert Dec-00

 | Certification for Market Settlement September 28, 2001
 | For the Trade Month of December 2000
ISO Creditors to whom amounts are Owed:
# | Customer Name | Trade Month |  |  | Amount Owed | % of total owed to Creditors
 | Total Due to 48 SCs (Creditors) | 2000-12-01 00:00:00 |  |  | 1471079852.9
Amounts owed by [NAME] that remain unpaid:
Preliminary and final invoices were provided in March's certification.
# | Customer Name | Date | Inv # | Type | Unpaid Balance | % of total due from Debtors
1243 | California Power Exchange | 2001-02-27 00:00:00 | 14163 | Mkt | 1430114437.65
1243 | California Power Exchange | 2001-03-15 00:00:00 | 14323 | Mkt | 54594957.95
2769 | California Power Exchange | 2001-02-27 00:00:00 | 14126 | Mkt | 12171363.36
2769 | California Power Exchange | 2001-03-15 00:00:00 | 14286 | Mkt | 235652.69
1011 | Pacific Gas and Electric (a) | 2001-02-27 00:00:00 | 14183 | Mkt | 11335555.36
1008 | Salt River Project | 2001-03-15 00:00:00 | 14345 | Mkt | 1600779.14
1010 | Southern California Edison | 2001-03-15 00:00:00 | 14344 | Mkt | 3337442.11
2465 | Strategic Energy | 2001-03-15 00:00:00 | 14298 | Mkt | 535113.08
 | Total Due From SCs (Debtors)
 | (a) - pre-bankruptcy activity
 | Summary of activity for Trade Month of December 2000:
 | Due from SCs
 | Preliminary Invoices |  |  |  | 1503186210.21
 | Final Invoices |  |  |  | 72817565.78
 | Total Invoiced
 | Collected 3/5/01
 | Collected 3/9/01 |  |  |  | 1095680.05
 | Collected 3/22/01 |  |  |  | 4668657.91
 | Collected 4/20/01
 | Total Collected
 | Offset against Nov-00 Market AP
 | Cancelled Dec-00 Market AR invoice |  |  |  | 147750
 | Offset against Dec-00 Market AP
 | Offset against Jan-01 GMC
 | Offset against Jan-01 Market AP
 | Offset against Feb-01 Market AP
 | Offset against Mar-01 Market AP
 | Offset against Apr-01 Market AP |  |  |  | 24782.38
 | Offset against May-01 Market AP
 | Offset against Jun-01 Market AP |  |  |  | 434861.71
 | Total Adjustments
 | Balance Due from SCs
 | Due to SCs
 | Preliminary Invoices
 | Final Invoices |  |  |  | 81563642.97
 | Total Invoiced
 | Paid 3/7/01 |  |  |  | 45426874.33
 | Paid 3/97/01 |  |  |  | 1095680.05
 | Paid 3/23/01 |  |  |  | 4660365.5
 | Paid 3/27/01 |  |  |  | 8292.41
 | Paid 4/23/01 |  |  |  | 1243.61
 | Total Paid
 | Offset against Dec-00 GMC
 | Offset against Dec-00 Market AR
 | Cancelled Dec-00 Market AP invoices
 | FERC ordered reduction Dec-00 Market AP |  |  |  | 1291405.14
 | Offset against Jan-01 Market AR
 | Offset against Feb-01 Market AR |  |  |  | 33196.74
 | Offset against Mar-01 Market AR |  |  |  | 2962776.9
 | Total Adjustments
 | Balance Due to SCs
Spreadsheet: louise_kitchen__24243__SepYTD Orig w notes Revised
Sheet: North East Power

Northeast Power
By Team
Originator |  | Commodity |  | Team |  | Total |  | %Total
[NAME] |  | Power |  | Northeast Orig
Wood |  | Power |  | Northeast Orig
Hammond |  | Power |  | Northeast Orig |  | 552600
Ader |  | Power |  | Northeast Orig
[NAME] |  | Power |  | Northeast Orig |  | 125000
[NAME] |  | Power |  | Northeast Orig
Schener |  | Power |  | Northeast Orig |  | 50000
Wheeler |  | Power |  | Northeast Orig |  | 48800
Duran |  | Power |  | Northeast Orig |  | 15500
Total *
*  $150,000 related to Old Dominion(Dalton) is included in Midwest Power.
Spreadsheet: 770604d1646188577-auto-import-of-data-in-summary-sheet-from-other-sheets-customers-visit-schedule
Sheet: D

S/No. | Name | Date | Time | Status | Remarks
1 | D1
2 | D2 | 2022-02-21 00:00:00 | 2.30pm | Confirmed
3 | D3
4 | D4
5 | D5
6 | D6
7 | D7 | 2022-03-01 00:00:00 | 1000am | Confirmed
8 | D8
9 | D9
10 | D10
Spreadsheet: 762161d1641415574-display-cell-text-after-meeting-countifs-criteria-training-form
Sheet: Sheet1

Date | Time | Manager | Agent |  |  |  |  | [NAME] | Christine
2022-01-06 00:00:00 | 10:00:00 | [NAME] | [NAME] |  | Monday | 2022-01-03 00:00:00 | 09:00:00
 |  |  |  |  |  |  | 10:00:00
 |  |  |  |  |  |  | 11:00:00
 |  |  |  |  |  |  | 12:00:00
 |  |  |  |  |  |  | 13:00:00
 |  |  |  |  |  |  | 14:00:00
 |  |  |  |  |  |  | 15:00:00
 |  |  |  |  |  |  | 16:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | Hey
 |  |  |  |  | Tuesday | 2022-01-04 00:00:00 | 09:00:00
 |  |  |  |  |  |  | 10:00:00
 |  |  |  |  |  |  | 11:00:00
 |  |  |  |  |  |  | 12:00:00
 |  |  |  |  |  |  | 13:00:00
 |  |  |  |  |  |  | 14:00:00
 |  |  |  |  |  |  | 15:00:00
 |  |  |  |  |  |  | 16:00:00
 |  |  |  |  | Wednesday | 2022-01-05 00:00:00 | 09:00:00
 |  |  |  |  |  |  | 10:00:00
 |  |  |  |  |  |  | 11:00:00
 |  |  |  |  |  |  | 12:00:00
 |  |  |  |  |  |  | 13:00:00
 |  |  |  |  |  |  | 14:00:00
 |  |  |  |  |  |  | 15:00:00
 |  |  |  |  |  |  | 16:00:00
 |  |  |  |  | Thursday | 2022-01-06 00:00:00 | 09:00:00
 |  |  |  |  |  |  | 10:00:00
 |  |  |  |  |  |  | 11:00:00
 |  |  |  |  |  |  | 12:00:00
 |  |  |  |  |  |  | 13:00:00
 |  |  |  |  |  |  | 14:00:00
 |  |  |  |  |  |  | 15:00:00
 |  |  |  |  |  |  | 16:00:00
 |  |  |  |  | Friday | 2022-01-07 00:00:00 | 09:00:00
 |  |  |  |  |  |  | 10:00:00
 |  |  |  |  |  |  | 11:00:00
 |  |  |  |  |  |  | 12:00:00
 |  |  |  |  |  |  | 13:00:00
 |  |  |  |  |  |  | 14:00:00
 |  |  |  |  |  |  | 15:00:00
 |  |  |  |  |  |  | 16:00:00
Spreadsheet: benjamin_rogers__1054__Consolidated 6 Peaker-062000
Sheet: Wheatland

INCOME STATEMENT - WHEATLAND
('000 $)
Revenue
Fixed Price Period: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Demand Payment
Energy Payment
Start Charge
Amortization of Power Contract
Merchant Period:
Demand Payment | 0 | 0 | 0
Variable Revenue | 0 | 0 | 0
Interest Income
Total Revenue
Expense
Fixed O&M
Variable O&M
Major [NAME]
Owner's Expense
Property Taxes Liability | 0 | 117.987 | 216.843 | 295.985 | 346.251 | 468.657 | 641.059 | 753.232 | 765.3 | 699.258 | 854.333 | 854.3 | 854.3 | 854.3 | 854.3 | 854.3 | 854.3 | 854.3 | 854.3 | 854.3
Franchise Tax | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Expense
EBITDA
Depreciation & Amortization
EBIT
Interest Expense
EBT
Book State Tax Benefit / (Expense)
Shareholder Fed. Tax Benefit / (Expense)
After Tax Book Income
CASH FLOW - WHEATLAND
('000 $) | 2001 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Check
EBITDA less Amortization of Power Contract
Plus Property Tax Liability
Less Property Tax Expense | -203.273
Debt Service
Pre Tax Cash Flow
State Cash Taxes Benefit (Expense)
Federal Cash Taxes Benefit (Expense)
After Tax Cash Flow
STATE TAX & SUPPLEMENTAL TAX - WHEATLAND
 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22
('000 $) | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020
SUPPLEMENTAL TAXES
Adjusted Gross Income Tax
Pretax Book Income less Amortization of Power Contract
Adjusted Gross Income Rate
State Adjusted Gross Income Tax
State Gross Receipts Taxes
Gross Receipts less Amortization of Power Contract
Gross Receipts Tax Rate
Gross Receipts Tax Liability
Greater of Adjusted or Gross Receipts
STATE TAXES
Pretax Book Income less Amortization of Power Contract
Plus Book Depreciation & Amortization
Less Tax Depreciation
State Taxable Income
State Income Tax Rate
Current State Income Tax Expense (Benefit)
Beginning NOL's | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
New NOL's
Expired NOL's | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NOL Utilization
Ending NOL's
Total State Taxes Utilizing NOLs
Total State & Misc. Taxes
Spreadsheet: 594395d1539736946-1-cell-web-query-autorefreshing-price-value-need-to-generate-column-list-record-of-values-examplequery
Sheet: Sheet1

Last | Bid | Ask |  |  | Time | Rate
1.1579 | 1.1578 | 1.1580 |  |  | 20:27:00 | 1.1578
 |  |  |  |  | 20:28:00 | 1.1578
 |  |  |  |  | 20:29:00 | 1.1578
 |  |  |  |  | 20:30:00 | 1.1579
 |  |  |  |  | 20:31:00 | 1.1579
 |  |  |  |  | 20:32:00 | 1.1579
 |  |  |  |  | 20:33:00 | 1.1579
 |  |  |  |  | 20:34:00
 |  |  |  |  | 20:35:00
 |  |  |  |  | 20:36:00
 |  |  |  |  | 20:37:00
 |  |  |  |  | 20:38:00
 |  |  |  |  | 20:39:00
 |  |  |  |  | 20:40:00
 |  |  |  |  | 20:41:00
 |  |  |  |  | 20:42:00
 |  |  |  |  | 20:43:00
 |  |  |  |  | 20:44:00
 |  |  |  |  | 20:45:00
 |  |  |  |  | 20:46:00
 |  |  |  |  | 20:47:00
 |  |  |  |  | 20:48:00
Spreadsheet: 1fbaafda-7640-4a13-9551-073ac8b98b44
Sheet: 21st CENTURY - ELO

Grant: |  | 21st CENTURY GRANT
CFDA # |  | 84.287
GRANT NUMBER: |  | 6287
FISCAL YEAR: |  | SIX MONTHS 3/1/13 THROUGH 8/31/13
[NAME]: |  | NO CARRYOVER ALLOWED - LAST DAY TO REQUEST THESE FUNDS SEPTEMBER 15, 2013
Question regarding payments: |  | [NAME]  [PHONE] or [EMAIL]
Questions regarding grant: |  | Marti Rodriguez [PHONE] or [EMAIL]
GBL/ORG |  | 222G/7000
Code | District/Agency Name | Schools | 6 MONTH ALLOCATION | PAYMENTS TO DATE | BALANCE | [NAME] 2013 | APRIL 2013 | MAY 2013 | JUNE 2013 | JULY 2013 | AUGUST 2013 | SEPTEMBER 2013 | OCTOBER 2013
0020 | Adams 12 | Coronado, Thornton ES | 28160 |  |  |  |  |  |  |  | 9808 | 14145
0480 | Boulder Valley SD | Columbine, Emerald, Sanchez, University Hills ES | 50000 |  |  |  |  |  |  | 50000
0880 | Denver Public SD | Bruce Randolph & Skinner | 28667
1220 | [NAME] | Bea Underwood ES | 25406 |  |  |  |  |  |  |  |  | 18299.58
1420 | Jefferson County SD | Foster ES, Arvada K-8 ES | 32000 |  |  |  |  |  |  | 1411 | 11553 | 12288 | 1579
1510 | Lake County R-1 | Lake County MS | 41649 |  |  |  |  |  |  |  | 29201 | 12448
1550 | Poudre R-1 | Lincoln IB World MS, Putnam ES | 49922 |  |  |  |  |  |  | 13320 | 23369 | 1729
1560 | Thompson R2-J SD | [NAME] | 33000 |  |  |  |  |  |  | 1103
Y008 | Adams 12 Five Star Schools | Cohort 6 | 49971 |  |  |  |  |  |  |  |  | 21506
Y863 | [NAME] | Harrington, SOAR Oakland | 45000 |  |  |  |  |  |  |  |  | 45000
Spreadsheet: 266312d1379581088-how-many-followup-made-by-a-salesman-between-a-particular-set-of-dates-help1
Sheet: Sheet1

date | name | age | salesman |  |  | between dates
[NAME] | VERMA | 29 | 4840374 |  |  | 2013-04-01 00:00:00 | 2013-07-31 00:00:00
[NAME] | RAJAK | 47 | 4840374
05/15/2013 | NEMA | 19 | 4840374 |  |  | salesman
05/15/2013 | NEMA | 27 | 4840374 |  |  | 4840374 | 0 |  | I need formulas here
05/24/2013 | BABBAR | 37 | 4840374 |  |  | 5842374 | 1
2013-06-08 00:00:00 | THAKUR | 33 | 4840374
06/28/2013 | BHAN | 38 | 4840374
[NAME] | KHATRI | 5 | 4840374
07/26/2013 | AGRAWAL | 27 | 4840374
08/10/2013 | WADHAWA | 6 | 4840374
09/11/2013 | BHASIN | 29 | 4840374
04/17/2013 | GOHIYA | 24 | 5842374 |  |  | In this example salesman 4840374 met "nema" more than 1 time but the age dose not match hence they are different people.
04/17/2013 | [NAME] | 26 | 5842374
05/13/2013 | RAJAK | 38 | 5842374
07/13/2013 | KOHLI | 39 | 5842374
07/14/2013 | KOHLI | 39 | 5842374
[NAME] | KOHLI | 39 | 5842374
07/16/2013 | KOHLI | 39 | 5842374
[NAME] | KOHLI | 39 | 5842374
07/31/2013 | SEN | 24 | 5842374
Spreadsheet: 98262d1297250167-average-last-five-non-blank-cells-averageoflast5nonblanks
Sheet: Sheet1

Numbers | Helper Col |  |  |  |  |  |  |  | Marcol |  |  |  |  | DonkeyOte |  | With helper(2007)
3 | 1 |  | 5.8 | <<Average of the Last 5 non blanks |  |  |  |  | 9 |  | 5.8 |  |  | 5.8 |  | 2 | 5.8
2 | 2 |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
5 | 3 |  |  |  |  |  |  |  | 7 |  |  |  |  |  |  | 4
4 | 4 |  |  |  |  |  |  |  | 6 |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
5 | 5 |  | Put numbers in Column A |  |  |  |  |  | 5 |  |  |  |  |  |  | 6
8 | 6 |  | Make sure Helper row  is filled in |  |  |  |  |  | 4 |  |  |  |  |  |  | 7
 |  |  | See answer in yellow abov |  |  |  |  |  |  |  |  |  |  |  |  | 0
5 | 7 |  |  |  |  |  |  |  | 3 |  |  |  |  |  |  | 8
5 | 8 |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
6 | 9 |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: 29386d1224371596-solved-how-to-identify-duplicates-in-a-worksheet-customer-mailing
Sheet: Sheet1

Surname | Forename 2 | Forename | D.O.B
Smith | [NAME] | [NAME] | 1960-01-01 00:00:00 | April | Unique
Smith |  | [NAME] | 1940-03-01 00:00:00 | April | Unique
Smith |  | Jon | 1960-01-01 00:00:00 | September | Duplicate
Smith | [NAME] | [NAME] | 1960-01-01 00:00:00 | September | Duplicate
Smith |  | [NAME] | 1940-03-01 00:00:00 | September | Duplicate
Smith |  | [NAME] | 1941-03-01 00:00:00 | September | Unique
Smith | [NAME] |  | 1941-03-01 00:00:00 | September | Duplicate
Spreadsheet: 99061d1297832105-help-using-lookup-for-multiple-positions-in-fantasy-baseball-draft-bb-dft2
Sheet: C

Column1 | First name | Last Name | Team | Owner
1 | [NAME] | Mauer, | MIN
2 | Buster | Posey, | SF
3 | [NAME] | McCann, | ATL
4 | Victor | Martinez, | DET
5 | Bengie | Molina
6 | [NAME] | Santana, | CLE
7 | Miguel | Montero, | AZ
8 | [NAME] | Lopez, | HOU
9 | Geovany | Soto, | CHI-N
10 | Kurt | Suzuki, | OAK
11 | [NAME] | Napoli, | TEX
12 | [NAME] | Wieters, | BAL
13 | Jorge | Posada, | NY-A
14 | [NAME] | Pierzynski, | CHI-A
15 | [NAME] | Iannetta, | COL
16 | [NAME] | [NAME], | FLA
17 | [NAME] | Jaso, | TB
18 | [NAME] | [NAME], | PIT
19 | Miguel | Olivo, | SEA
20 | Yadier | Molina, | STL
21 | [NAME] | Ruiz, | PHI
22 | [NAME] | Montero, | NY-A
23 | [NAME] | [NAME], | DET
24 | [NAME] | Rodriguez, | WAS
25 | [NAME] | Martin, | NY-A
26 | J.P. | Arencibia, | TOR
27 | Ramon | Hernandez, | CIN
28 | [NAME] | Lucroy, | MIL
29 | Wilson | Ramos, | WAS
30 | [NAME] | Kendall, | KC
31 | [NAME] | Thole, | NY-N
32 | Nick | Hundley, | SD
33 | Kelly | Shoppach, | TB
34 | [NAME] | [NAME], | HOU
35 | [NAME] | Hanigan, | CIN
36 | Ronny | Paulino, | NY-N
37 | Yorvit | Torrealba, | TEX
38 | Tyler | Flowers, | CHI-A
39 | Ramon | [NAME], | CHI-A
40 | [NAME] | Teagarden, | TEX
41 | Rod | Barajas, | LA
42 | Hank | Conger, | ANA
43 | Francisco | Cervelli, | NY-A
44 | J. | Saltalamacchia, | BOS
45 | [NAME] | Snyder, | PIT
46 | [NAME] | Varitek, | BOS
47 | Adam | Moore, | SEA
48 | [NAME] | Mesoraco, | CIN
49 | Travis | d'Arnaud, | TOR
50 | Wilin | Rosario, | COL