tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: david_delainey__8187__California Exposure 010117a
Sheet: Px - ISO 

RAC - Risk Assessment & Control
Exposure as of
 |  |  |  |  | Net Sales | Net Purchases |  |  | Enron's Net | CA ISO's |  | ISO
Counterparty | Enron Entity | Entity Code | Activity Month |  | (if A/R-A/P > $0) | (if A/P-A/R < $0) |  |  | Exposure | Net Exposure |  | Pmt. Date
California ISO | Enron Power Marketing, Inc. | ENA | November 2000 |  |  |  |  |  |  |  |  | 2001-02-02 00:00:00
California ISO | Enron Power Marketing, Inc. | ENA | December 2000 |  |  |  |  |  |  |  |  | 2001-03-05 00:00:00
California ISO | Enron Power Marketing, Inc. | ENA | MTD January 2001 |  |  |  |  |  |  |  |  | 2001-04-03 00:00:00
California ISO | Portland General | PGE | November 2000 |  | 7700000 |  |  |  |  |  |  | 2001-02-02 00:00:00
California ISO | Portland General | PGE | December 2000 |  | 45000000 |  |  |  |  |  |  | 2001-03-05 00:00:00
California ISO | Portland General | PGE | MTD January 2001 |  | 500000 |  |  |  |  |  |  | 2001-04-03 00:00:00
Total CA ISO
 |  |  |  |  |  |  |  |  |  |  | PX Net Purchases | PX Net Sales
 |  |  |  | Physical | Net Sales | Net Purchases |  |  | Enron's Net | CA PX's | Payment | Receipt
Counterparty | Enron Entity |  | Activity Month | Mark-to-Market | (if A/R-A/P > $0) | (if A/P-A/R < $0) |  |  | Exposure | Net Exposure | Date: | Date:
California Power Exchange Corporation | Enron Power Marketing, Inc. | ENA | November 2000 (Real Time Mkt) |  |  |  |  |  |  |  | 2001-02-01 00:00:00 | 2001-02-05 00:00:00
California Power Exchange Corporation | Enron Power Marketing, Inc. | ENA | December 2000 (Real Time Mkt) |  |  |  |  |  |  |  | 2001-03-02 00:00:00 | 2001-03-06 00:00:00
California Power Exchange Corporation | Enron Power Marketing, Inc. | ENA | December 2000 (Core Mkt) |  |  |  |  |  |  |  | 2001-01-16 00:00:00 | 2001-01-18 00:00:00
California Power Exchange Corporation | Enron Power Marketing, Inc. | ENA | December 2000 (Blk FW Mkt) |  |  |  |  |  |  |  | 2001-01-16 00:00:00 | 2001-01-18 00:00:00
California Power Exchange Corporation | Enron Power Marketing, Inc. | ENA | MTD January 2001 (Real Time Mkt) |  |  |  |  |  |  |  | 2001-04-02 00:00:00 | 2001-04-04 00:00:00
California Power Exchange Corporation | Enron Power Marketing, Inc. | ENA | MTD January 2001 (Core Mkt) |  |  |  |  |  |  |  | 2001-02-15 00:00:00 | 2001-02-20 00:00:00
California Power Exchange Corporation | Enron Power Marketing, Inc. | ENA | Existing Block FW Portfolio | -48000000 |  |  |  |  |  |  | Block forward positions out to 12/01
California Power Exchange Corporation | Portland General | PGE | December 2000 |  | 2800000 |  |  |  |  |  | 2001-01-16 00:00:00 | 2001-01-18 00:00:00
Total CA PX
 |  |  |  |  |  | ENRON |  |  | PORTLAND GENERAL |  | TOTAL
 |  |  | PCG REGULATED |  |  |  |  |  | 0
 |  |  | PCG NON-REGULATED FILING SUBS |  |  |  |  |  | 0
 |  |  | PCG EXPECTED NON-FILING SUBS |  |  |  |  |  | 0
 |  |  | EIX REGULATED
 |  |  | EIX NON-REGULATED |  |  |  |  |  | 0
 |  |  | SUBTOTAL
 |  |  | ISO
 |  |  | PX
 |  |  | SUBTOTAL
Spreadsheet: 771404d1646657632-help-with-stock-data-calculation-in-excel-excel-stock-data-problem
Sheet: Sheet1

PRICE HIGH |  | PRICE LOW
3.08 | 11:12:00 | 2.9 | 11:01:00
2.95 | 12:39:00 | 2.77 | 11:40:00
2.89 | 14:14:00 | 2.64 | 11:57:00
2.62 | 14:57:00 | 2.53 | 13:35:00
 |  | 2.62 | 14:04:00
 |  | 2.68 | 14:22:00
 |  | 2.46 | 14:47:00
Spreadsheet: 870302d1716841036-can-anyone-tell-what-mistake-i-am-doing-in-my-formulas-given-in-the-sample-file-sample-file
Sheet: Table 3

कार्यक्रम PROGRAM |  |  | पदोन्नति पूर्य प्रतिक्षण – अधीनस्थ कमयचारी से एसडब्ल्यूओ (अ.जा/अ.ज.जा) PRE-PROMOTION TRAINING SUB-STAFF TO SWO (SC/ST) | PROG CODE
 |  |  |  | AIT 0129
तर्षर् समूह/SUBJECT GROUP |  |  | HR, MARKETING, CUSTOMER SERVICE & COMPLIANCE
उद्देश्य/OBJECTIVE |  |  | TO IMPART KNOWLEDGE AND EMPOWER THE CANDIDATES TO COME OUT WITH BETTER PERFORMANCE IN THE PROMOTION PROCESS
लतक्षि समूह/TARGET GROUP |  |  | SUBSTAFF (SC/ST)
अर्तध/DURATION |  |  | 1 WEEK
DAY | SESSION | CONTENTS
Day 1 | I | General Banking & Demand Deposit
 | II | KYC/AML
 | III | Term Deposit
 | IV | Financial Inclusion
Day 2 | I | Priority Sector Lending
 | II | Government Sponsored Scheme
 | III | Agricultural Advances
 | IV | Retail Lending
Day 3 | I | Legal Aspect of Banking
 | II | General Banking – Cash / Securities
 | III | General Banking – Customer Service
 | IV | General Banking – Digital Banking
Day 4 | I | General Banking – Death Claim/Nomination/SDL/SCA
 | II | General Advances
 | III | Non Resident Deposits
 | IV | NPA & Recovery
Day 5 | I to IV | General English
Day 6 | I & II | General English
 | III | Official Language
 | IV | Interview Tips
Spreadsheet: richard_sanders__31855__Enron -  credit explosure 
Sheet: 020201

 | 2001-02-02 00:00:00
 | Description | Core Market | Description | CTS Market | Combined CTS/Core
 | Real Time Final from 11/1/00 - 11/13/00 | 1833.429999999995 | Total CTS Volatility Requirement | 69778064
 | Real Time Prelim. from 12/1/00 - 12/3/00 | 242336.02 | Total CTS Volumetric Requirement | 4410000
 | Real Time Estimates from 12/4/00 - 12/31/00 (Based on 25% Generation and Import and 10% of Loads and Exports) | 3182677.4025 | Additional Collateral due to not participating in CTS-Pool Performance Bond | 50000000
 | January collateral requirement based on Day Ahead (1/1/01 - 1/31/01) and [NAME] (1/1/01 - 1/31/01) trading activities. | 27356084.21
 | MMS Fees ([NAME].) from 1/1/01 - 1/31/01 | 49050.00999999973
 | Additional Collateral due to not participating in CORE-Pool Performance Bond | 20000000
 | Total Core Requirement : |  | Total CTS Requirement
 | Available Core Collateral - Prepayment Account : | 3570788 | Available CTS Collateral - Letter of Credit : | 87543184
 | Available Core Collateral - Letter of Credit : | 15000000 | Available CTS Collateral - Cash : | 36500000
 | Excess (Deficit) in Core Collateral |  | Excess (Deficit) in CTS Collateral
Spreadsheet: 587721d1535209534-data-lookup-across-multiple-sheets-using-data-validation-copy-of-sample-jmcgurl-
Sheet: Receiving

 | Dates (week SUN - SAT) | 2018-02-02 00:00:00
 | Global
Global | Cartons Received
Global | % to LW
Global | Average 12 week cartons
Global | This week vs 12 Week %
Global
Global | Errors
Global | [NAME]
Global | [NAME] not on File
Global | Error %
Global | 12 week error %
 | US
USA | Cartons Received | 173000 | 145998 | 158804 | 148026
USA | % to LW
USA | Average 12 week cartons
USA | This week vs 12 Week %
USA
USA | Item Level Received Cartons |  |  | 1012 | 1012
USA | Item Level Receiving Percentage
USA
USA | Errors
USA | [NAME] | 865 | 2680 | 4250
USA | [NAME] not on File
USA | Error %
 | APLA
APLA | Cartons Received | 4200 | 1893 | 3083 | 3757
APLA | % to LW
APLA | Average 12 week cartons
APLA | This week vs 12 Week %
APLA
APLA | Errors
APLA | [NAME] | 8 | 18 | 19 | 313
APLA | [NAME] not on File
APLA | Error %
 | China  (Avg for CHN, HK, TWN, MAC)
China | Cartons Received | 94052 | 98502 | 111281 | 22227
China | % to LW
China | Average 12 week cartons
China | This week vs 12 Week %
China
China | Errors
China | [NAME] | 1316 | 1640 | 1313
China | [NAME] not on File
China | Error %
 | [NAME] (GBR, RUS)
EMEA
EMEA | Cartons Received
EMEA | % to LW
EMEA | Average 12 week cartons
EMEA | This week vs 12 Week %
EMEA
EMEA | Errors
EMEA | [NAME]
EMEA | [NAME] not on File
EMEA | Error %
Spreadsheet: 122295d1316714792-copying-data-from-columns-to-a-new-sheet-when-the-result-of-a-cell-is-correct-ortz_demo
Sheet: Four

Date | Number | Surname | Forename | Staff | Type | Code | Team | Decision | Decision Date | Start | End | No. of Days
2011-09-04 00:00:00 | NW2221W | Smith | [NAME] | 5 | L | A22 | d | No | 2011-09-03 00:00:00 | 2011-09-06 00:00:00 | 2011-09-03 00:00:00 | 10
2011-09-04 00:00:00 | 003WW | [NAME] | [NAME] | 5 | T | A12 | d | No | 2011-09-03 00:00:00 | 2011-09-06 00:00:00 | 2011-09-03 00:00:00 | 10
2011-09-04 00:00:00 | [NAME] | Dunston | [NAME] | 11 | T | B6 | a | No | 2011-09-03 00:00:00 | 2011-09-06 00:00:00 | 2011-09-03 00:00:00 | 10
2011-09-04 00:00:00 | 87899 | Jones | [NAME] | 2 | A | F5 | d | Yes | 2011-09-03 00:00:00 | 2011-09-03 00:00:00 | 2011-09-03 00:00:00 | 10
2011-09-04 00:00:00 | ASD3 | Smith | [NAME] | 7 | T | F5 | d | Yes | 2011-09-03 00:00:00 | 2011-09-03 00:00:00 | 2011-09-03 00:00:00 | 5
2011-09-04 00:00:00 | ER4466 | [NAME] | [NAME] | 7 | G | C2 | e | No | 2011-09-03 00:00:00 | 2011-09-03 00:00:00 | 2011-09-03 00:00:00 | 5
2011-09-04 00:00:00 | 43459 | Pidge | [NAME] | 7 | T | C2 | e | No | 2011-09-03 00:00:00 | 2011-09-03 00:00:00 | 2011-09-03 00:00:00 | 5
2011-09-04 00:00:00 | FFGHJ | Watson | Stephen | 2 | A | A12 | d | Reserved | 2011-09-03 00:00:00 | 2011-09-03 00:00:00 | 2011-09-03 00:00:00 | 5
2011-09-05 00:00:00 | [NAME] | Jennings | [NAME] | 2 | A | F5 | d | Reserved | 2011-09-04 00:00:00 | 2011-09-04 00:00:00 | 2011-09-04 00:00:00 | 10
2011-09-05 00:00:00 | SDSAA | Boater | Adele | 5 | L | C12 | d | Recon | 2011-09-04 00:00:00 | 2011-09-04 00:00:00 | 2011-09-04 00:00:00 | 10
2011-09-05 00:00:00 | 34RT5 | [NAME] | [NAME] | 5 | T | C 12 | a | Yes | 2011-09-04 00:00:00 | 2011-09-04 00:00:00 | 2011-09-04 00:00:00 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Yes
 |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Reserved
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Recon
Spreadsheet: 211237d1359695219-press-and-show-only-row-filter_example
Sheet: Sheet1

Stuff | Group
asdfasd | 5
dafgdg | 1
ghdfghd | 3
dghdfgh | 3
dfghfgh | 1
hdsfhdfgh | 1
[NAME] | 6
fg | 7
[NAME] | 5
sdfgdsg | 3
dfsg | 7
sdfgdsfgdsf | 6
gdsfgsdfg | 5
Spreadsheet: 487888d1478290093-lock-cells-to-not-move-while-scrolling-help
Sheet: Sheet1

Orders Pulled | Total componates Pulled | Total componates pulled | Total componates pulled MTD
2016-10-31 00:00:00
MA026025 | 30 | TOTAL ORDERS PULLED | Total orders pulled MTD
MA026243 | 70
MA026119 | 25 | PCS PER ORDER | Average pcs per order  MTD
MA025895 | 10
MA026027 | 10
MA026396 | 40
MA026303 | 15
MA026219 | 40
MA026403 | 120
MA026154 | 50
MA026149 | 360
MA026150 | 360
MA025374 | 125
MA026458 | 202
MA026457 | 200
2016-11-01 00:00:00
MA026477 | 125 | TOTAL ORDERS PULLED
MA026563 | 160
MA026562 | 160 | PCS PER ORDER
MA026344 | 20
MA026270
Spreadsheet: 885505d1735156849-countifs-function-countifs-function
Sheet: Sheet1

Person 1 | ü
Person 2 | ü
Person 3 | ü | late |  | ü
Person 4 | ü
Person 5 | ü
Person 6 | ü | late
Person 7 | ü
Person 8 | ü
Person 9
Person 10 |  | late
Person 11
Person 12
Person 13 | ü | late
Person 14 | ü
Person 15 | ü
Person 16 | ü
Person 17 | ü
Person 18 | ü
Person 19 | ü | late
Person 20 | ü
Person 21 | ü
Person 22
Person 23
Person 24
Countif Total
 | =countif(B1:B24,E3)
[NAME]
 |  | =countifs(B1:B24,E3,C1:C24,"late")
Spreadsheet: 82885d1282891179-search-button-using-macro-rammohan
Sheet: TRAINZ

←← |  | TRAINZ
NATURE OF WORK
APP VALUE
SALES INCHARGE
CLIENTS REPRESENTATE |  | [NAME] ([PHONE])
ARCHITECT
PO DETAILS
SERVICE COORDINATES
SITE CONDITION
DELIVERY SCHEDULE
STATUS ON DAY TO DAY BASIS |  | Training room, Cafeteria, Conf room cabling done. VGA soldering work pending on the conf tables
ROUGH ESTIMATE OF THE MATERIAL
DAC VGA cable DB7001 |  | 203 mts
DAC Video cable ARR691C |  | 32 mts
DAC Spk-18 cable |  | 145 mts
Euro Audio Cable |  | 148 mts
6x4 Braun wall instalock ([NAME]) |  | 1 No
Universal ceiling mount kit |  | 4 No
NEC 42 LCD Monitors |  | 3 No's
42 " TV Wall mounts |  | 3 No's
[NAME]/o MIC THAI Polycom |  | 1 No
[NAME] |  | 15 No's
VGA Pins |  | 26 No's
DAC RCA Pins 302-529-A |  | 10 No's
Big wall mount |  | 1 No
Samsung HT-TZ 225 Spkr |  | 4 No's
←←
Spreadsheet: 122682d1317064088-conditional-format-for-overdue-date-conditional-formatting-for-medical-dates
Sheet: Sheet1

 |  |  |  |  |  |  |  | Last Medical Date |  |  | Last Medical Date + 1 Year
Spreadsheet: john_griffith__15782__10_19_01OH
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | [NAME] | 62 | 275 | 375 | 40.1 | 54.7 | 1.85 | 2001-10-19 10:18:00
 | HO Z1 | 63 | 750 | 850 | 45.8 | 52 | 1.94 | 2001-10-19 10:18:00
 | HO F2 | 63 | 1050 | 1150 | 48.8 | 53.5 | 2.03 | 2001-10-19 10:18:00
 | HO G2 | 63 | 1260 | 1360 | 48.3 | 52.2 | 1.99 | 2001-10-19 10:18:00
 | [NAME] | 62 | 1300 | 1400 | 45 | 48.4 | 1.82 | 2001-10-19 10:18:00
 | HO J2 | 61 | 1280 | 1380 | 40.9 | 44.1 | 1.63 | 2001-10-19 10:18:00
 | HO K2 | 60 | 1250 | 1375 | 37.3 | 41.1 | 1.48 | 2001-10-19 10:18:00
 | HO M2 | 60 | 1255 | 1375 | 34.7 | 38 | 1.37 | 2001-10-19 10:18:00
 | HO N2 | 60 | 1225 | 1425 | 31.9 | 37.2 | 1.3 | 2001-10-19 10:18:00
 | HO Q2 |  |  |  | 29.8 | 34.6 | 1.26 | 2001-10-17 15:11:00
 | HO U2 |  | \ |  | 28.8 | 34.4 | 1.25 | 2001-10-12 14:53:00
 | [NAME] |  |  |  | 24.3 | 26.8 | 1.08 | 2001-08-20 15:41:00
 | HO X2
 | [NAME]
 | HO F3 |  |  |  |  |  | 0.72 | 2001-07-18 22:45:00
 | [NAME]
Spreadsheet: matt_motley__26414__EMR Prices
Sheet: Sheet1

 |  | Peak |  | Off-Peak
Region | Delivery Date | Low | High | Low | High
Red numbers indicate flat, 24-hour products.
NW/N. Rockies | 2002-01-15 00:00:00 | 18.75 | 21.25 | 16.5 | 17.25
Mid-Columbia | 2002-01-15 00:00:00 | 18.75 | 21.25 | 16.5 | 17.25
COB | 2002-01-15 00:00:00 | 21.5 | 23 | 16.5 | 19
N. California | 2002-01-15 00:00:00 | 22.5 | 25.5 | 17 | 19
Midway/Sylmar | 2002-01-15 00:00:00 | NA | NA | NA | NA
S. California | 2002-01-15 00:00:00 | 23 | 26.25 | 16.75 | 18.75
Mead | 2002-01-15 00:00:00 | 22.75 | 25.75 | 17 | 18.25
Palo Verde | 2002-01-15 00:00:00 | 22 | 26 | 16 | 18
Inland SW | 2002-01-15 00:00:00 | 22 | 26 | 16 | 18.25
4-Corners | 2002-01-15 00:00:00 | 22.5 | 23.5 | 16 | 17
Central Rockies | 2002-01-15 00:00:00 | 17.75 | 22 | 13 | 15
Spreadsheet: 0a4f370c-bc60-4639-895b-46749d1688ec
Sheet: 9b

Product | EUR** | GBP | [NAME] | USD | TOTAL
Basis* | 159745 | 1035274 | 634087 | 4991004 | 6820110
FRA | 14559387 | 3394968 | 11213 | 13896871 | 31862439
IRS- [NAME] | 49191668 | 8534564 | 14545578 | 33196304 | 105468114
OIS | 12929030 | 3617229 |  | 3747065 | 20293324
VNS | 2123 | <1,000 |  | <1,000 | 2123
Zero Coupon | 99037 | 36817 | 33638 | 52174 | 221666
TOTAL | 76940990 | 16618852 | 15224516 | 55883419 | 164667777
Estimated gross notional amount outstanding, January 11 weekly snapshot, by product type and supermajor currency (millions of USD), cleared swaps only, all participant types and tenors. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for currency 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: 99612d1298229823-cpp-ei-fed-and-on-stub-book2
Sheet: Sheet1

 |  |  |  |  |  |  | Employee |  | Employer |  | Federal Tax |  | Ont Tax Calcs |  | Ontario Tax
Pay # | Hours | Pay | [NAME] | Gross | CPP | CPP YTD | EI | YTD EI | EI | YTD EI | Fed Tax | YTD | T4 | OHIP | [NAME] | YTD
1 | 84
2 | 78
3 | 71
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
 |  |  |  | 5.05 | 37774
 |  |  |  | 9.15
 |  | A | T3 | T4
Spreadsheet: 883071d1731560522-cross-table-book1_transpose
Sheet: Sheet1

Column1 | Orange | Apple | [NAME] | Mango |  |  | Column1 | Attribute | Count
Nov-1 | 10 | 20 | 30 | 12 |  |  | 2024-11-01 00:00:00 | Orange | 10
Nov-2 | 15 | 15 | 10 | 13 |  |  | 2024-11-02 00:00:00 | Orange | 15
Nov-3 | 5 | 0 | 0 | 12 |  |  | 2024-11-03 00:00:00 | Orange | 5
Nov-4 | 15 | 15 | 15 | 14 |  |  | 2024-11-04 00:00:00 | Orange | 15
 |  |  |  |  |  |  | 2024-11-01 00:00:00 | Mango | 12
 |  |  |  |  |  |  | 2024-11-02 00:00:00 | Mango | 13
 |  |  |  |  |  |  | 2024-11-03 00:00:00 | Mango | 12
 |  |  |  |  |  |  | 2024-11-04 00:00:00 | Mango | 14
 |  |  |  |  |  |  | 2024-11-01 00:00:00 | [NAME] | 30
 |  |  |  |  |  |  | 2024-11-02 00:00:00 | [NAME] | 10
 |  |  |  |  |  |  | 2024-11-04 00:00:00 | [NAME] | 15
 |  |  |  |  |  |  | 2024-11-01 00:00:00 | Apple | 20
 |  |  |  |  |  |  | 2024-11-02 00:00:00 | Apple | 15
 |  |  |  |  |  |  | 2024-11-04 00:00:00 | Apple | 15
Spreadsheet: brad_mckay__1412__NY City Forecast
Sheet: Tenn Data

Tennessee Gas Pipeline:
 |  | 2
 | 15106
 | 36892
 | 36893
 | 36896
 | 36920
 | 37948
 |  | Total
Spreadsheet: 174941d1345242228-transpose-and-sort-transpose-and-sort
Sheet: Sheet1

Raw data |  |  |  |  | Final Result |  |  |  |  | Why I need this
Organization | Record |  |  |  | AB | AC | AH |  |  | Organization | Record | New data being entered
AC |  |  |  |  | Record-4 | Record-1 | Record-2 |  |  | AB | Record-5
AH |  |  |  |  | Record-5 | Record-3 | Record-6 |  |  | AC | Record-8
AC |  |  |  |  | Record-13 | Record-7 | Record-10 |  |  | AH | Record-6
AB |  |  |  |  | Record-14 | Record-8
AB |  |  |  |  | Record-15 | Record-9
AH |  |  |  |  | Record-16 | Record-11
AC |  |  |  |  |  | Record-12
AC
AC
AH
AC
AC
AB
AB
AB
AB
Spreadsheet: cc7072c5-9ce9-4634-aa6b-d37c484a5e35
Sheet: Sheet1

Portage Lake Dam | Unnamed: 1
Local Time | Elevation
2012-12-23 12:01:43 | 850.14
2012-12-24 12:01:44 | 850.12
2012-12-25 12:01:42 | 850.05
2012-12-26 12:01:37 | 850.07
2012-12-27 12:01:39 | 850.09
2012-12-28 12:01:36 | 850.01
2012-12-29 12:01:45 | 850.05
2012-12-30 12:01:36 | 850.01
2012-12-31 12:01:37 | 849.9
2013-01-01 12:01:43 | 849.92
2013-01-02 12:01:42 | 849.94
2013-01-03 12:01:42 | 849.97
2013-01-04 12:01:40 | 849.99
2013-01-05 12:01:36 | 850.01
Spreadsheet: 89288d1289047496-cannot-edit-drop-down-menus-ecoluxx-economics-spreadsheet
Sheet: Economics

 | Economic calculation for Ecoluxx energy saving lighting products
 | Economical view
 | Purchase | 1st Year | 2nd Year | 3rd Year | 4th Year | 5th Year |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] fitting 1 x 18 Watt, LLB | RETROLUX 14 Watt, standard
 | Number of Ecoluxx products | 500 | 0 | 0 | 0 | 0
 | Costs per unit | 343.2
 | Purchase price per unit | 171600 | 0 | 0 | 0 | 0
 | Tax percentage | 0 | 0 | 0 | 0 | 0
 | Purchase price after tax benefit | 171600 | 0 | 0 | 0 | 0
 | Return of investment | 0.6825592306769902 | 0 | 0 | 0 | 0
 | Annual savings | 12944 | 210605 | 243181.25 | 283901.5625 | 334801.953125
 | Accumulated savings | 12944 | 223549 | 466730.25 | 750631.8125 | 1085433.765625
 | Contracting:
 | Client share of the savings | 0.3 | 0.2 | 0.2 | 0.2 | 0.2
 | Ecoluxx share of the savings | 0.7 | 0.8 | 0.8 | 0.8 | 0.8
 | Contracting rate | 129180.8 | 111235.6571428572 | 0 | 0 | 0
 | Contract period | 1.753449429017316 | - | - | - | -
 | Annual savings | 55363.20000000001 | 99369.34285714276 | 243181.25 | 283901.5625 | 334801.953125
 | Accumulated savings | 55363.20000000001 | 154732.5428571428 | 397913.7928571427 | 681815.3553571427 | 1016617.308482143
Spreadsheet: 102116d1300149536-formula-with-2-variables-and-2-fixed-values-amenasce2
Sheet: Sheet1

Month | Customers paying one time Fee | Customers paying the Montly Fee | Your Anserw?
2011-01-01 00:00:00 | 30 | 30
2011-01-02 00:00:00 | 20
2011-01-03 00:00:00 | 20
2011-01-04 00:00:00 | 20
2011-01-05 00:00:00 | 20
Spreadsheet: 265583d1379335048-search-for-specific-string-except-0a207
Sheet: Sheet1

Original List | Show Only "Insurance" Words | Show All Words Except "Insurance, Homes,Mexico"
car insurance |  |  |  |  | Insurance
health insurance |  |  |  |  | Homes
cheap rental homes |  | cheap rental homes |  |  | Mexico
cheap car rentals |  | cheap car rentals
vacation spot |  | vacation spot
destination mexico
Spreadsheet: 488865d1478877482-share-excel-file-christmas-market
Sheet: Sheet1

 | Family | Just Adults | November |  |  |  |  |  |  |  | December
 |  |  | Fri 18 | Sat 19 | Sun 20 |  | Fri 25 | Sat 26 | Sun 27 |  | Fri 2 | Sat 3 | Sun 4 |  | Fri 9 | Sat 10 | Sun 11 |  | Fri 16 | Sat 17 | Sun 18 | Notes:
Spreadsheet: 153874d1336075804-excel-2007-countifs-using-variable-to-identify-column-referenced-countifs-from-rangev2
Sheet: Answer if working properly

 | Correct Values
 |  | system 5 | system 3 | system 7 | << Data Validation list
 | Mon | 1 | 1 | 1
 | [NAME] | 0 | 3 | 2
 | Wed | 0 | 2 | 1
 | Thurs | 1 | 0 | 1
 | Fri | 0 | 0 | 0
 | total
Spreadsheet: 220771d1363262493-dropdown-list-data-validation-scabdog1
Sheet: sheet1

a
b
c
d
e | lookup this | validation list |  | defined name is
f | f | a |  | testing
g
k |  |  |  | data validation is allow list  =testing
l
p
r
t
bv
nh
j
[NAME]
kkl
[NAME]
fhhj
ffh
hjk
iop
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
Spreadsheet: 148017d1333100006-combine-aggregated-weeknumber-data-and-month-data-to-date-weeknumbers
Sheet: Sheet1

[NAME] | Week |  | dagen |  |  |  | Maand | Aantal dagen in maand
40909 | 3 | 2012-01-01 00:00:00 | 21 |  |  |  | 40909 | 31
40940 | 9 | 2012-02-01 00:00:00 | 63 |  |  |  | 40940 | 29
40969 | 10 | 2012-03-01 00:00:00 | 70 |  |  |  | 40969 | 31
40940 | 9 | 2012-02-01 00:00:00 | 63 |  |  |  | 41000 | 30
40940 | 8 | 2012-02-01 00:00:00 | 56 |  |  |  | 41030 | 31
40940 | 6 | 2012-02-01 00:00:00 | 42 |  |  |  | 41061 | 30
40940 | 5 | 2012-02-01 00:00:00 | 35 |  |  |  | 41091 | 31
40909 | 5 | 2012-01-01 00:00:00 | 35 |  |  |  | 41122 | 31
40940 | 6 | 2012-02-01 00:00:00 | 42 |  |  |  | 41153 | 30
40940 | 5 | 2012-02-01 00:00:00 | 35 |  |  |  | 41183 | 31
40909 | 5 | 2012-01-01 00:00:00 | 35 |  |  |  | 41214 | 30
40969 | 10 | 2012-03-01 00:00:00 | 70 |  |  |  | 41244 | 31
40969 | 10 | 2012-03-01 00:00:00 | 70 |  |  |  | 41275
40969 | 10 | 2012-03-01 00:00:00 | 70
Spreadsheet: 753070d1635231660-extracting-text-variable-formatted-string-into-two-columns-attempt-to-use-mid-and-right-sample
Sheet: Sheet1

 |  |  |  |  |  |  |  | Desired Return
 |  |  | Visitor | Home
 |  |  |  |  |  |  |  | Wisconsin | Illinois
 |  |  |  |  |  |  |  | Kansas | Virginia
 |  |  |  |  |  |  |  | Alabama | Missouri
 |  |  |  |  |  |  |  | UCLA | USC
 |  |  |  |  |  |  |  | Texas | Oklahoma St
 |  |  |  |  |  |  |  | Arizona | Colorado
 |  |  |  |  |  |  |  | N Carolina | Duke
 |  |  |  |  |  |  |  | Tennessee | Kentucky
 |  |  |  |  |  |  |  | [NAME] | Connecticut
 |  |  |  |  |  |  |  | Creighton | Marquette
 |  |  |  |  |  |  |  | Pittsburgh | Virginia
 |  |  |  |  |  |  |  | Syracuse | Clemson
 |  |  |  |  |  |  |  | St Bonavent | St Louis
 |  |  |  |  |  |  |  | Northwestern | Purdue
 |  |  |  |  |  |  |  | Notre Dame | GA Tech
 |  |  |  |  |  |  |  | Mississippi | Auburn
 |  |  |  |  |  |  |  | [NAME] | Providence
 |  |  |  |  |  |  |  | Miss State | S Carolina
#68 Mt St Mary at #1 Gonzaga |  |  |  |  |  |  |  | Mt St Mary | Gonzaga
Goal: Return the Visitor and Home Team Name Only in colmn's D and E.  Notice in highlighted cells only portions of the names are returned because I am premising the return based on the space " ".
Hoping there is a formula in each instance (Colmn D and E) that can return based on flexible formating of string (notice varying length and location of  spaces).
Extracting text variable formatted string into two columns; Attempt to use MID and RIGHT
I have a basketball schedule that is formatted as follows #x AAAA at #yy BBBB where AAAA and BBBB are team names. I want to extract AAAA to one column and BBBB to another column without any other portion of the string. The names AAAA and BBBB are not consistantly formatted (e.g. in some cases there are one or two spaces within a name for example Oklahoma St (1 space) or [NAME] (2 spaces). The names are always preceeded by the number sign and ranking (of varying lengths (e.g. #1, #99, or #125). I have attached a sample and highlighted cells that aren't returning the correct information.