tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 868842d1715564596-custom-calendar-help-dynamic-calendar-3-
Sheet: NOV

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A | B | C | D
 |  |  |  |  |  |  |  |  |  | B |  | B
 |  |  |  |  |  |  |  |  |  | A |  | A
B |  | B |  | D |  | D |  | D |  | D |  | A
A |  | A |  | C |  | C |  | C |  | C |  | B
A |  | A |  | A |  | C |  | C |  | C |  | C
B |  | B |  | B |  | D |  | D |  | D |  | D
B |  | B |  | B |  | B |  | D |  | D |  | D
A |  | A |  | A |  | A |  | C |  | C |  | C
D |  | A |  | A |  | A |  | A |  | C |  | C
C |  | B |  | B |  | B |  | B |  | D |  | D
Spreadsheet: 867420d1714246435-convert-cell-to-date-dates2-etaf
Sheet: Sheet1

Code | Name | Publish date | Date in Excel format
TSLA | [NAME] | Jun 13, 2025, 4 PMEDT
TSLA | [NAME] | Apr 21, 2025, 4 PMEDT
TSLA | [NAME] | Jan 22, 2025, 4 PMEST
TSLA | [NAME] | Oct 16, 2024, 6 AMEDT
TSLA | [NAME] | Jul 17, 2024, 6 AMEDT
TSLA | [NAME] | Jun 13, 2024, 4 PMEDT
TSLA | [NAME] | Apr 23, 2024, 4 PMEDT
TSLA | [NAME] | Jan 24, 2024, 4 PMEST
TSLA | [NAME] | Jan 02, 2024, 12 PMEST
TSLA | [NAME] | Oct 18, 2023, 4 PMEDT
TSLA | [NAME] | Jul 19, 2023, 4 PMEDT
TSLA | [NAME] | Apr 19, 2023, 4 PMEDT
TSLA | [NAME] | Jan 25, 2023, 4 PMEST
TSLA | [NAME] | Oct 19, 2022, 4 PMEDT
TSLA | [NAME] | Jul 20, 2022, 4 PMEDT
TSLA | [NAME] | Apr 20, 2022, 4 PMEDT
TSLA | [NAME] | Jan 26, 2022, 4 PMEST
TSLA | [NAME] | Oct 20, 2021, 4 PMEDT
TSLA | [NAME] | Jul 26, 2021, 4 PMEDT
TSLA | [NAME] | Apr 26, 2021, 4 PMEDT
TSLA | [NAME] | Jan 27, 2021, 4 PMEST
TSLA | [NAME] | Oct 21, 2020, 4 PMEDT
TSLA | [NAME] | Jul 22, 2020, 4 PMEDT
TSLA | [NAME] | Apr 29, 2020, 4 PMEDT
TSLA | [NAME] | Jan 29, 2020, 4 PMEST
TSLA | [NAME] | Oct 23, 2019, 4 PMEDT
TSLA | [NAME] | Jul 24, 2019, 4 PMEDT
TSLA | [NAME] | Apr 24, 2019, 5 PMEDT
TSLA | [NAME] | Jan 30, 2019, 4 PMEST
TSLA | [NAME] | Oct 24, 2018, 4 PMEDT
TSLA | [NAME] | Aug 01, 2018, 4 PMEDT
TSLA | [NAME] | May 02, 2018, 4 PMEDT
TSLA | [NAME] | Feb 07, 2018, 4 PMEST
TSLA | [NAME] | Nov 01, 2017, 4 PMEDT
TSLA | [NAME] | Aug 02, 2017, 4 PMEDT
TSLA | [NAME] | May 03, 2017, 4 PMEDT
TSLA | [NAME] | Feb 22, 2017, 2 PMEST
TSLA | [NAME] | Oct 26, 2016, 4 PMEDT
TSLA | [NAME] | Aug 03, 2016, 4 PMEDT
TSLA | [NAME] | May 04, 2016, 4 PMEDT
TSLA | [NAME] | Feb 10, 2016, 4 PMEST
TSLA | [NAME] | Nov 03, 2015, 4 PMEST
TSLA | [NAME] | Aug 05, 2015, 4 PMEDT
TSLA | [NAME] | May 06, 2015, 4 PMEDT
TSLA | [NAME] | Feb 11, 2015, 4 PMEST
TSLA | [NAME] | Nov 05, 2014, 5 PMEST
TSLA | [NAME] | Jul 31, 2014, 12 AMEDT
TSLA | [NAME] | May 07, 2014, 12 AMEDT
TSLA | [NAME] | Feb 19, 2014, 12 AMEST
TSLA | [NAME] | Nov 05, 2013, 12 AMEST
TSLA | [NAME] | Aug 07, 2013, 12 AMEDT
TSLA | [NAME] | May 08, 2013, 12 AMEDT
TSLA | [NAME] | Feb 20, 2013, 12 AMEST
TSLA | [NAME] | Nov 05, 2012, 12 AMEST
TSLA | [NAME] | Jul 25, 2012, 12 AMEDT
TSLA | [NAME] | May 09, 2012, 12 AMEDT
TSLA | [NAME] | Feb 15, 2012, 12 AMEST
TSLA | [NAME] | Nov 02, 2011, 12 AMEDT
TSLA | [NAME] | Aug 03, 2011, 12 AMEDT
TSLA | [NAME] | May 04, 2011, 12 AMEDT
TSLA | [NAME] | Feb 15, 2011, 12 AMEST
TSLA | [NAME] | Nov 09, 2010, 12 AMEST
PrevNext
Spreadsheet: elizabeth_sager__9515__ADMINV___A-EPMI_-02-08-2001Formated
Sheet: ADMINV___A-EPMI_-02-08-2001

 | INVOICE
 | Please Remit To: |  |  |  |  | Invoice No: | 101399
 | California Power Exchange |  |  |  |  | Invoice Date: | 2001-02-08 00:00:00
 | BANK OF AMERICA |  |  |  |  | Short Name: | EPMI
 | 1850 Gateway Blvd |  |  |  |  | Invoice Cycle: | CYCLE 2
 | Concord CA 94520 |  |  |  |  | Due Date: | 2001-02-20 00:00:00
 | Account # 12335-25421 |  |  |  |  | Payout to Participant | 2001-02-27 00:00:00
 | Routing # 121000358
 |  |  |  |  |  | AMOUNT DUE: | 17846030.82
 | Customer:
 | ENRON POWER MKTG INC
 | 1400 SMITH ST
 | HOUSTON TX 77002
 | For Banking questions, please call | [PHONE]
 | For Billing questions, please call | [PHONE]
Segment | Name | Trade Day | Settlement ID | Type P/F | Charge($) | Payments($)
RTD | REAL TIME DEFAULT - RTD | 2000-11-30 00:00:00 | NOVRT DF ADMNFEE | F | 17846030.82
 | Total Invoice - Net Charge/(Payments): |  |  |  | 17846030.82
Spreadsheet: sara_shackleton__36433__Capex gas contract
Sheet: ms

Master Gas Contract Terms
 |  | ATTORNEY:
DATE: |  | DEAL MAKER: | [NAME]
COUNTERPARTY: | Capex S.A. | CONTACT:
ADDRESS: |  | TITLE:
 |  | PHONE:
 |  | FAX:
Incorporation State |  | S&P Rating
STRUCTURE | COUNTERPARTY | ECT
GUARANTOR (RATING) |  | Enron Corp.
LIMIT $ MILLIONS |  | 15
Incorporation State |  | OR
COLLATERAL  THRESHOLD MATRIX in $
based on S & P and
Moody's ratings | 3 | 15
Specify Type of Debt:
COLLATERAL TYPE
Letter of Credit | X | X
Cash | X | X
Treasuries/Maturity limit
MINIMUM TRANSFER $
COLLATERAL ROUNDING
Delivery Amount | 100000
Return Amount
HOLDING and USE OF COLLATERAL
Permitted | X | X
Minimum S & P/Moody's
rating permitted
MATERIAL ADVERSE CHANGE TRIGGERS - AS ADDITIONAL EVENT OF DEFAULT
APPLY TO:
-Counterparty | X
-Guarantor |  | X
Debt Ratings Change
-Below = S&P/Moody's | BB | BBB-
Financial Covenants
-Funded Debt/TNW
-Minimum Net Worth
-EBITDA/Interest
Non-Specific
-Unilateral
Non-Standard Definitions
-Funded Debt
-Net Worth
EVENTS OF DEFAULT
3rd party debt | X | X
-Counterparty ($[NAME]) | 5
-Guarantor ($[NAME]) |  | 100
Change in ownership
FINANCIAL STATEMENTS
-Standard | X | X
- Request financials on:
CREDIT DECISION: | APPROVED :  X | DECLINED:
OUTSTANDING SWAP TRANSACTIONS: |  | YES: | NO:
ALL SWAPS TO ROLL UP UNDER NEW MASTER: |  | YES: | NO:
CREDIT PROVISIONS OF MASTER TO GOVERN: |  | YES: | NO:
OTHER COMMENTS: | ALL currencies are expressed in USD.
GLOBAL CREDIT:  Please complete the attached form below if the following conditions exist:
A)  No previous guidance limit exists or .....
B)  The proposed contractual limits exceed the existing guidance limits.
CREDIT REVIEW  PREPARED BY: |  | [NAME] | x3-3559
Spreadsheet: 05165766-85cd-47cb-b777-4f9fa87172f3
Sheet: 4

 | November 22 | November 29 | December 6 | December 13 | December 20
Total Interest Rate* | 32242 | 23716 | 39681 | 42724 | 47081
SDs and MSPs** | 13030 | 8866 | 15376 | 18870 | 21347
Other | 19212 | 14850 | 24305 | 23854 | 25734
Total Cross-Currency | 1634 | 446 | 1278 | 1922 | 1286
SDs and MSPs | 1022 | 299 | 860 | 1363 | 834
Other | 612 | 147 | 418 | 559 | 452
Total Credit | 27836 | 9458 | 16206 | 9670 | 12243
SDs and MSPs | 13284 | 5527 | 8364 | 5763 | 6956
Other | 14552 | 3931 | 7842 | 3907 | 5287
Total FX | N/A | N/A | N/A | N/A | N/A
SDs and MSPs | N/A | N/A | N/A | N/A | N/A
Other | N/A | N/A | N/A | N/A | N/A
Total Equity | N/A | N/A | N/A | N/A | N/A
SDs and MSPs | N/A | N/A | N/A | N/A | N/A
Other | N/A | N/A | N/A | N/A | N/A
Total Other Commodity | N/A | N/A | N/A | N/A | N/A
SDs and MSPs | N/A | N/A | N/A | N/A | N/A
Other | N/A | N/A | N/A | N/A | N/A
TOTAL | 61712 | 33620 | 57165 | 54316 | 60610
Weekly total, swap ticket volumes by asset class and participant type (number of new trades), all products and tenors, cleared and uncleared. For cleared swaps, the creation of each of the two resulting swaps is attributed only to the counterparty facing the clearing organization (i.e., the clearing organization’s participation is not displayed). For uncleared swaps, each trade is attributed to both swap counterparties. All price-forming trade events, including new trades, terminations, amendments, and novations, are included in ticket volumes. Because this table shows transactions by participant, the totals on this table are twice those displayed on the "Transaction Ticket Volume by Cleared Status" table.
*See Data Dictionary for asset class descriptions.
**See Explanatory Notes for participant type descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 694031d1599310866-if-any-index-match-combination-contains-value-flag-2020-09-05-oeldere-jm45t3r5-694030d1599310136-if-any-index-match-combination-contains-value-
Sheet: Sheet1

 |  | High Level Brand | Store | Contract | Signed or Not Signed
 |  | Gucci | Gucci | Contract 1 | Signed
 |  |  | Gucci | Contract 2 | Signed
 |  |  | Gucci | Contract 3 | Signed
 |  |  | Gucci | Contract 4 | Signed
 |  |  | Gucci | Contract 5 | Signed
 |  | Patagonia | Patagonia | Contract 1 | Signed
 |  |  | Patagonia | Contract 2 | Not Signed
 |  |  | Patagonia | Contract 3 | Signed
 |  |  | Patagonia | Contract 4 | Not Signed
 |  |  | Patagonia | Contract 5 | Not Signed
 |  | Nike | Nike | Contract 1 | Signed
 |  |  | Nike | Contract 2 | Signed
 |  |  | Nike | Contract 3 | Signed
 |  |  | Nike | Contract 4 | Signed
 |  |  | Nike | Contract 5 | Not Signed
 |  | Adidas | Adidas | Contract 1 | Signed
 |  |  | Adidas | Contract 2 | Signed
 |  |  | Adidas | Contract 3 | Signed
 |  |  | Adidas | Contract 4 | Signed
 |  |  | Adidas | Contract 5 | Signed
Spreadsheet: benjamin_rogers__1192__test model from Erin
Sheet: ENA IDC

Draw Schedule & Capital Budget
Construction Term
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Check
Date
Financing Months
 |  | Total
Net Interest During Consturction
EQUITY & DEBT FUNDING:
Debt
Equity
TOTAL DRAW DOWN
INITIAL TOTAL DRAW DOWN
INITIAL EQUITY & DEBT FUNDING:
Debt
Equity
Total
INTEREST DURING CONSTRUCTION - Page 2
CONSTRUCTION FINANCING TERMS:
Commitment ($000s)
Draw Date
Rate
Spread
Swap
Other Fees |  |  | 0.02286
ENA Price Risk Mgmt Debt
Draw
Fund Monthly Commitment
Aggregate fund consumption
Ending Cash Balance
Previous Months Interest Accrued
Aggregate [NAME]
Interest Accrued
Total Other Fee
Monthly Interest income
Monthly Interest
Net Monthly interest expense/(income)
Total Interest During Construction
Total Other Fees
Total Capital Costs
Cumulative Capital Costs
Equity by Year
Total Equity
If All Equity
Spreadsheet: 110810d1307404457-how-to-cross-referencing-two-lists-and-copying-relevant-information-book1
Sheet: Sheet1

Name | Phone | Address
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Igor
Gordo
Spreadsheet: 855256d1704894007-removing-a-number-from-a-list-in-a-cell-if-it-appears-elsewhere-unallocated-duties
Sheet: Duty Allocation

 | 2023-12-01 00:00:00 | 2023-12-02 00:00:00 | 2023-12-03 00:00:00 | 2023-12-04 00:00:00 | 2023-12-05 00:00:00 | 2023-12-06 00:00:00 | 2023-12-07 00:00:00 |  |  |  | Duty | Duty | Duty | Duty | Duty | Duty | Duty | Duty | Duty | Duty
 | Duty No | Duty No | Duty No | Duty No | Duty No | Duty No | Duty No |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
[NAME] | OFF | OFF | 7 |  |  |  |  |  |  | 2023-12-01 00:00:00 | [NAME] | Stuart | NA | [NAME] | [NAME] | NA | NA | NA | NA | NA
[NAME] | 1 | 3 |  | OFF | OFF |  |  |  |  | 2023-12-02 00:00:00 |  |  | [NAME]
Stuart | 2 |  | 10 |  |  | OFF | OFF |  |  | 2023-12-03 00:00:00 |  |  |  |  |  |  | [NAME] |  |  | Stuart
[NAME] | 5 | OFF | OFF |  |  |  |  |  |  | 2023-12-04 00:00:00
[NAME] | 4 |  | OFF | OFF |  |  |  |  |  | 2023-12-05 00:00:00
[NAME] | OFF |  |  |  |  |  | OFF |  |  | 2023-12-06 00:00:00
Duties to Cover | 3 | 1 2 4 5 | 6 8 9 | 6 7 8 9 10 | 6 7 8 9 10 | 6 7 8 9 10 | 1 2 3 4 5 |  |  | 2023-12-07 00:00:00
Alternatively Maybe Like This
Duties to Cover | 1 2 3 4 5 | 1 2 3 4 5 | 6 7 8 9 10 | 6 7 8 9 10 | 6 7 8 9 10 | 6 7 8 9 10 | 1 2 3 4 5
Unallocated | 3 | 1 2 4 5 | 6 8 9 | 6 7 8 9 10 | 6 7 8 9 10 | 6 7 8 9 10 | 1 2 3 4 5
Rory
Hans
Spreadsheet: kim_ward__20764__EEI
Sheet: Master

POWER MASTER AGREEMENT INFORMATION SHEET
 |  | LEGAL CONTACT:
DATE: |  | EPMI CONTACT:
COUNTERPARTY: | Tucson Electric Power Company | CONTACT: | [NAME]
ADDRESS: |  | TITLE:
 |  | PHONE: | [PHONE]
 |  | FAX:
 |  | S&P RATING: | [NAME]
ENTITY TYPE: | Corporation | MOODY'S RATING: | nr
 |  | FITCH IBC | BB-
TYPE OF AGREEMENT:
Bilateral (Purch & Sale) | X | Power Marketing
Unilateral - EPMI Purch only |  | Industrial Producer - EPMI Purch only
Unilateral - EPMI Sale only
Transaction Specific
TRANSACTION TENOR LIMITS | open
COVER PROVISIONS
(Failure to Deliver/Receive) | X
STANDARD TRIGGER EVENTS
Non-Payment | X
Representations | X
Other Covenants | X
Bankruptcy | X
TERMS SPECIFIC TO: | COUNTERPARTY | EPMI
COLLATERAL THRESHOLD | See Below | See Below | USD
Applies to [NAME] to Market only
Applies to MTM and [NAME] | X | X
Collateral Multiple | 250000 | 250000 | USD
COLLATERAL THRESHOLD TYPE
In a form acceptable...
Cash | X | X
US Treasuries
Letter of Credit | X | X
ADDITIONAL TRIGGER EVENTS
Cross Default 3rd Party Debt: | X | X
-Counterparty | 10000000
-Guarantor |  | 100000000
Material Adverse Change:
-Counterparty | X
-Guarantor |  | X
Non-Specific | X
-Bilateral
-Unilateral | X
Debt Ratings Change | X | X
-Below S&P or Moody's | [NAME] | [NAME]
-Type of debt | Senior Unsecured Debt | Senior Unsecured Debt
Financial Covenants
-Funded Debt/Net Worth
-Minimum Net Worth
-Fixed Charge Coverage
-Interest Coverage
Non-Standard Definitions
-Funded Debt
-Net Worth
-Cash Flow
Ownership Change
-Less than 51% owned by:
COLLATERAL TYPE
In a form and amount acceptable
to non-defaulting party | X | X
Other
GUARANTOR BREACH
GUARANTOR (RATING) |  | Enron Corp. (BBB+/Baa1)
$ LIMIT |  | 25000000
Incorporation State:
FINANCIAL STATEMENTS
-Counterparty
-Guarantor | X | X
-Parent
OTHER COMMENTS:
Collateral Threshold based on S&P Sr. Unsecured ratings: |  | Counterparty / EPMI
 | BBB- or above
 | BB & BB+
 | B+ & BB-
 | Below B- | 0
CREDIT REVIEW  PREPARED BY: |  | [NAME] | 5-7712
Spreadsheet: 889154d1739881537-i-want-to-know-each-security-code-number-on-a-specific-date-excel-query-17-02-2025
Sheet: Summary

Security Code |  |  |  |  |  |  | AED | EUR | GBP | [NAME] | SAR | USD | 1-Year | 3-Months | 6-Months | 2024-02-15 00:00:00 | 2024-02-16 00:00:00 | 2024-08-19 00:00:00 | 2024-08-20 00:00:00 | 2024-08-21 00:00:00 | 2024-11-18 00:00:00 | 2024-11-19 00:00:00 | Security Code # | Security Issuance Date | Tenure of Investment | Amount of Investment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A | B | C | D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I want to know amount of total investment of each security code on specific date (not to repeat security code – need sum of below information against one single code) as followings:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.       How many security codes are there on a specific date (not to repeat).
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2.       amount of total investment against each security code Maturity date wise
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3.       amount of total investment against each security code Currency wise
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.       amount of total investment against each security code Tenure wise; and
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5.       amount of total investment against each security code issue date.
Spreadsheet: 767716d1644592206-need-to-copy-data-from-one-excel-table-to-another-that-has-a-different-format-new-format
Sheet: LWS

Workstation Inventory
Location Information |  |  |  |  | Ambulatory |  | Workstation |  |  |  |  |  |  |  |  |  |  | Peripheral Devices |  |  |  |  |  |  | [NAME].
Deparment Name / Unit | Building | Floor | Location Of Workstation | Room Number,  (Especially for Exam Rooms) | Exam Room | Map Reference | Computer Name | Workstation Type | Login Strategy | [NAME] | [NAME] | New Epic Name | LWS ID : after upload | BCA | Primary Use | Epic Department ID | Epic Department Name | Document Scanner | Biometrics/Tap Badge | [NAME] | Credit Card Reader | e-Signature Pad | [NAME] | Web Cam | Has Power | Has Data | USB Printer | Other/Comments
[NAME] |  | 1 | Conference Room |  |  | PC1 | CMCCATHLB02 | Desktop | Multi-User (Kiosk) | < 23" |  |  |  |  | Clinical IP
[NAME] |  | 1 | Drs Office |  |  | PC2 | CMCCATHLB04 | Desktop | Single User | < 23" | < 23" |  |  |  | Clinical IP |  |  |  |  |  |  |  |  | Yes - Add Model in Comments |  |  | Yes - Add Model in Comments | WC - Logitec HP LJ Pro MFP M426fdw Dragon Mic
[NAME] |  | 1 | Control Room | cathlab4 |  | PC3 | CMCCATHLB03 | Desktop | Multi-User (Kiosk) | 24" |  |  |  |  | Clinical IP
[NAME] |  | 1 | Control Room | cathlab4 |  | PC4 | CMCCATHLB05 | Desktop | Multi-User (Kiosk) | 24" |  |  |  |  | Clinical IP
[NAME] |  | 1 | Control Room | cathlab4 |  | PC5 | CMCCATHLB06 | Desktop | Multi-User (Kiosk) | 24" |  |  |  |  | Clinical IP
[NAME] |  | 1 | Cath OR | cathlab4 |  | MED1 | CATHLAB4 |  |  |  |  |  |  |  | Clinical IP |  |  |  |  |  |  |  |  |  |  |  |  | No Aux
[NAME] |  | 1 | Control Room | cathlab3 |  | PC6 | CMCCATHLB07 | Desktop | Multi-User (Kiosk) | < 23" |  |  |  |  | Clinical IP
Spreadsheet: 2866f3cb-1ec4-42b8-994f-2208a8b65123
Sheet: Cleantech

 |  |  |  |  |  | PricewaterhouseCoopers/National Venture Capital Association
 |  |  |  |  |  | MoneyTree™ Report, Data: Thomson Reuters
 |  |  |  |  |  | Cleantech Sector Investments Q1 1995 - Q1 2012
Quarter | 1995 |  | 1996 |  | 1997 |  | 1998 |  | 1999 |  | 2000 |  | 2001 |  | 2002 |  | 2003 |  | 2004 |  | 2005 |  | 2006 |  | 2007 |  | 2008 |  | 2009 |  | 2010 |  | 2011 |  | 2012
 | # of Deals | Amount Invested | # of Deals | Amount Invested | # of Deals | Amount Invested | # of Deals | Amount Invested | # of Deals | Amount Invested | # of Deals | Amount Invested | # of Deals | Amount Invested | # of Deals | Amount Invested | # of Deals | Amount Invested | # of Deals | Amount Invested | # of Deals | Amount Invested | # of Deals | Amount Invested | # of Deals | Amount Invested | # of Deals | Amount Invested | # of Deals | Amount Invested | # of Deals | Amount Invested | # of Deals | Amount Invested | # of Deals | Amount Invested
1 | 10 | 27734100 | 13 | 36796000 | 14 | 34275800 | 12 | 69708100 | 13 | 32049900 | 16 | 183284000 | 24 | 118531000 | 11 | 92960000 | 13 | 60013900 | 13 | 28015000 | 23 | 159273200 | 30 | 316395800 | 48 | 465737700 | 67 | 1210058000 | 49 | 419938000 | 90 | 896376800 | 79 | 1189644300 | 73 | 950678900
2 | 6 | 16139000 | 9 | 62950100 | 12 | 34107100 | 7 | 27764000 | 12 | 56626000 | 15 | 248089600 | 17 | 147449300 | 9 | 46570000 | 12 | 69181300 | 24 | 111333300 | 28 | 195360100 | 44 | 526965200 | 60 | 576082800 | 73 | 925846800 | 53 | 576509800 | 84 | 1533001700 | 94 | 1170031000
3 | 11 | 21091100 | 11 | 16913300 | 12 | 43089000 | 11 | 20947400 | 12 | 57313100 | 10 | 73947300 | 9 | 21281900 | 13 | 83081000 | 13 | 49968900 | 20 | 104260000 | 20 | 88211100 | 38 | 512689900 | 76 | 1075906800 | 87 | 1152059300 | 65 | 998544600 | 65 | 712008100 | 87 | 923299300
4 | 8 | 12032000 | 15 | 46779900 | 14 | 68891000 | 12 | 65516800 | 18 | 162345700 | 10 | 109266400 | 11 | 55520100 | 17 | 104192100 | 18 | 50306700 | 24 | 179597500 | 23 | 133126400 | 36 | 381512700 | 73 | 953854400 | 70 | 864905500 | 71 | 453545700 | 68 | 849191800 | 82 | 1362035900
Grand Total | 35 | 76996200 | 48 | 163439300 | 52 | 180362900 | 42 | 183936300 | 55 | 308334700 | 51 | 614587300 | 61 | 342782300 | 50 | 326803100 | 56 | 229470800 | 81 | 423205800 | 94 | 575970800 | 148 | 1737563600 | 257 | 3071581700 | 297 | 4152869600 | 238 | 2448538100 | 307 | 3990578400 | 342 | 4645010500 | 73 | 950678900
 | Source:  PricewaterhouseCoopers/National Venture Capital Association MoneyTree™ Report, Data:  Thomson Reuters
Spreadsheet: 72423d1273096406-returning-values-from-multiple-sheets-using-multiple-searches-music2010sales
Sheet: Mar2010Sales

TC Reporting Month | # [NAME] | PayRate for one sold | Total Earned | Currency | Album Title | [NAME] | Name of store or service | Country Of Sale
2010-03 | 7 | 0.71 | 4.97 | EUR | Touching The Winky | Touching Things Is Fun (the Winky Song) | iTunes UK/European Union | GB
2010-03 | 1 | 0.71 | 0.71 | EUR | Touching The Winky | Funt | iTunes UK/European Union | ES
2010-03 | 1 | 0.71 | 0.71 | EUR | Touching The Winky | Touching Things Is Fun (the Winky Song) | iTunes UK/European Union | ES
2010-03 | 1 | 0.7 | 0.7 | USD | Touching The Winky | It's a Penis | iTunes U.S. | US
2010-03 | 1 | 0.7 | 0.7 | USD | Touching The Winky | Penguins | iTunes U.S. | US
Spreadsheet: 93512d1293073626-rearranging-a-large-table-tablepuzzle
Sheet: Sheet1

Before
 | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00
Project A
Actual | 100 | 101 | 102 | 103 | 104 | 105 | 106 | 107 | 108 | 109 | 110 | 111
Forecast | 90 | 91 | 92 | 93 | 94 | 95 | 96 | 97 | 98 | 99 | 100 | 101
Project B
Actual | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200
Forecast | 185 | 185 | 185 | 185 | 185 | 185 | 185 | 185 | 185 | 185 | 185 | 185
Project C
Actual | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400
Forecast | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500
Note: There are more than 50 projects.
After
 | 2010-01-01 00:00:00 |  | 2010-02-01 00:00:00 |  | 2010-03-01 00:00:00
 | Actual | Forecast | Actual | Forecast | Actual | Forecast
Project A | 100 | 90 | 101 | 91 | 102 | 92
Project B | 200 | 185 | 200 | 185 | 200 | 185
Project C | 400 | 500 | 400 | 500 | 400 | 500
One thing that make the work more complicated is the fact that there are three different verisions of the forecast (Q1, Q2 and [NAME]) saved in three different spreadsheets but all of them using exactly
the same template. That's why I would like to do something like a Vlookup.
 | 2010-01-01 00:00:00 | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-07-01 00:00:00
 | Actual | Forcast | Actual | Forcast | Actual | Forcast | Actual | Forcast | Actual | Forcast | Actual | Forcast | Actual | Forcast
Project A | 100 | 90 | 101 | 91 | 102 | 92 | 103 | 93 | 104 | 94 | 105 | 95 | 106 | 96
Project B | 200 | 185 | 200 | 185 | 200 | 185 | 200 | 185 | 200 | 185 | 200 | 185 | 200 | 185
Project C | 400 | 500 | 400 | 500 | 400 | 500 | 400 | 500 | 400 | 500 | 400 | 500 | 400 | 500
 | Find the formulas in the yellow cells.
Spreadsheet: 3a86dd30-4262-41bc-8e59-4074dac5dc55
Sheet: Sheet1

Unnamed: 0 | State of New Hampshire - Primary Election | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
2012-09-11 00:00:00 | Governor - Democratic
Strafford County | [NAME], d | [NAME], d | [NAME], d | Ovide Lamontagne, r | [NAME], r | [NAME], r | [NAME]
[NAME] | 512 | 238 | 32 | 2 | 2 |  | 1
[NAME] | 158 | 156 | 2 | 2
[NAME] | 169 | 180 | 19
[NAME] | 202 | 196 | 21 | 4 | 3
[NAME] | 180 | 199 | 31 | 1 | 1
[NAME] | 108 | 130 | 25 | 3 | 1
[NAME] 6 | 100 | 133 | 27 | 2 | 1
[NAME] | 545 | 550 | 30 |  | 1
Farmington | 142 | 135 | 26 | 4 | 1 |  | 1
[NAME] | 229 | 267 | 18 |  | 2 |  | 1
Madbury | 116 | 89 | 6
[NAME] | 47 | 35 | 13
Milton | 112 | 113 | 35 | 5 | 2 | 1
New Durham | 57 | 89 | 15 | 2 | 1 |  | 1
Rochester Ward 1 | 151 | 131 | 19 | 1 | 1 |  | 1
[NAME] | 174 | 104 | 23 | 3
[NAME] 3 | 161 | 125 | 15 | 2 | 1
Rochester Ward 4 | 162 | 131 | 27 | 3 | 1
Rochester Ward 5 | 136 | 111 | 19 | 11
Rochester Ward 6 | 134 | 92 | 22 | 4 | 3
[NAME] | 135 | 74 | 8 | 3 | 1
[NAME] | 101 | 65 | 9 | 1
[NAME] | 89 | 58 | 5 | 1 |  |  | 1
[NAME] 3 | 60 | 32 | 14 | 3
[NAME] | 97 | 31 | 11 | 2
[NAME] 5 | 51 | 32 | 8 | 1 | 1
Strafford | 166 | 167 | 8 | 2 | 1
TOTALS | 4294 | 3663 | 488 | 62 | 24 | 1 | 6
Sullivan County | [NAME], d | [NAME], d | [NAME], d | Ovide Lamontagne, r | [NAME], r | [NAME], r | [NAME]
Acworth | 34 | 37 | 4 |  |  |  | 0
Charlestown | 106 | 104 | 37 | 1 |  |  | 1
Claremont Ward 1 | 57 | 96 | 12 | 3 | 1 |  | 0
Claremont Ward 2 | 133 | 31 | 23 | 2 | 3 |  | 1
Claremont Ward 3 | 81 | 120 | 34 | 3 | 1 |  | 0
Cornish | 104 | 72 | 12 | 2 |  |  | 0
Croydon | 10 | 18 | 1 |  |  |  | 1
Goshen | 19 | 26 | 3 |  | 1 |  | 1
Grantham | 190 | 148 | 17 |  |  |  | 0
Langdon | 19 | 21 | 2
Lempster | 28 | 30 | 3 | 1 | 1 |  | 0
Newport | 130 | 139 | 42 | 2 | 1 |  | 0
Plainfield | 189 | 78 | 11 |  |  |  | 0
Springfield | 41 | 59 | 8 | 1
Sunapee | 118 | 136 | 15 | 1 |  |  | 0
Unity | 47 | 36 | 12 | 1 |  |  | 0
Washington | 33 | 25 | 1 | 1 |  |  | 0
TOTALS | 1339 | 1176 | 237 | 18 | 8 |  | 4