tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 31526d1227376484-multiple-table-vlookups-and-results-help
Sheet: JAN

January
Customer No | Customer Surname Name | Customer No | Order Date
123456 | Bloggs | 123456 | 2008-01-01 00:00:00
223354 | Smith | 223354 | 2008-01-02 00:00:00
445588 | Bloggs | 445588 | 2008-01-03 00:00:00
456798 | Bloggs | 456798 | 2008-11-22 00:00:00
Spreadsheet: 847191d1698237333-average-of-orders-horizontal-to-vertical-paste-ans
Sheet: Sheet2

Order date | Product number | Customer ID | Order Count | Order Value |  | Customer ID | average between orders | average number of products | average number of ordered unique products
2021-02-21 00:00:00 | 1A | A1 | 1 | 0 |  | A3
2020-02-21 00:00:00 | 1A | A2 | 1 | 15.7 |  | A6
2020-11-16 00:00:00 | 1A | A3 | 1 | 37.2 |  | A1
2021-02-22 00:00:00 | 1B | A3 | 1 | 44.6
2020-09-05 00:00:00 | 5657 | A4 | 2 | 78.6
2021-01-17 00:00:00 | 78787 | A5 | 1 | 32.5
2020-12-03 00:00:00 | 878 | A6 | 1 | 67.7
2020-12-10 00:00:00 | 878787 | A6 | 1 | 89.1
2021-02-13 00:00:00 | 8787877 | A6 | 1 | 1
2021-02-17 00:00:00 | 8787878 | A6 | 2 | 90.1
2021-02-17 00:00:00 | 787878 | A6 | 2 | 130
Spreadsheet: 16c0646d-9f7b-4557-b1f0-b5748af1739e
Sheet: 28

شركت ساختماني گسترش و نوسازي صنايع ايرانیان مانا ([NAME])
يادداشتهاي [NAME] مالي
دوره مالي شش ماهه منتهي به 31 خرداد ماه 1390
13-2 | مانده حساب کارفرمایان به شرح زيرمی باشد:
 |  | 1390/03/31 |  | 1389/09/30
 |  | ريال |  | ريال
 | شرکت آلومینیوم [NAME] | 12216671993 |  | 7978730359
 | [NAME] صنعت | 4287150609 |  | 4287150609
 | پیمان مدیریت - شرکت موننکو | 28102472911 |  | 12920570216
 | شرکت سرمایه گذاری ساختمان سپه | 0 |  | 11372087760
 | ساختمان مرکزی وزارت نیرو | 5558739655 |  | 4351810912
 | سایر | 7120498532 |  | 1749585534
 | [NAME]
13-3 | [NAME] سايراشخاص (فروشندگان) ازاقلام زيرتشکيل [NAME]:
 |  | 1390/03/31 |  | 1389/09/30
 |  | ريال |  | ريال
 | دات کام شرق | 0 |  | 194285000
 | پیمانکاری بوالحسنی | 0 |  | 124415164
 | شرکت تچدا بتن | 0 |  | 466663831
 | آهن آلات تهران فام | 0 |  | 265098000
 | [NAME] وماسه شازند | 0 |  | 211417072
 | [NAME] باستان | 0 |  | 471345140
 | فروشگاه توانا | 0 |  | 293988000
 | مانده اقلام بستانکار بانک صادرات | 0 |  | 546534790
 | [NAME] بتن آماده باقری | 0 |  | 215681400
 | فروشندگان دفتر مرکزی | 1315894420 |  | 0
 | [NAME] شرق | 0 |  | 649122000
 | سنگ بعثت | 0 |  | 167563000
 | مانده اقلام بستانکاراستادیوم شیراز | 265515894 |  | 574622560
 | [NAME] بتن | 0 |  | 144098000
 | تاسیسات ماسه شوئی بیکران | 0 |  | 134381220
 | مانده اقلام بستانکار35متری بلوارمعلم | 1441944809 |  | 345387400
 | مانده اقلام بستانکاراحداث کارخانه کک سازی | 1196754814 |  | 221122124
 | فروشگاه سلامتیان | 0 |  | 153809000
 | کنسانتره جلال آباد | 1179693259 |  | 0
 | سایر | 2223922182 |  | 4158257197
 | [NAME] : |  |  |  | .
Spreadsheet: 753905d1635812957-cell-value-from-multiple-sheets-to-be-presented-in-master-sheet-michaelger-new-microsoft-excel-worksheet-2-
Sheet: 02112021

Country | A | B
Poland | Francesco | Mark
U.K. | [NAME] | [NAME]
Italy | [NAME] | [NAME]
France | [NAME] | [NAME]
Germany | [NAME] | [NAME]
Greece | Ire | Ire
Spain | Martin | [NAME]
Spreadsheet: 686291d1594477468-please-help-with-vloock-up-or-iferror-plano-de-manutencao-de-viaturas-2020
Sheet: Reparacoes

 | Controlo de Reparação de Viaturas
 | Item | Tag | Matricula | Avarias | Data de Entrada | Data de Saida | Reponsavel pela [NAME] | Status
 | 1 | V033 | ADQ-333-MC | Sangramento das balatas e substituição das anilhas das Bombetas de travões. | 2019-10-27 00:00:00 | 2019-11-04 00:00:00 | IGILDO
 | 2 | V037 | AFB-664-MC | Vazamento do diesel na bomba injectora,[NAME] de vendantes,[NAME] e molas de sucção e elementar da bomba injectora. | 2019-10-29 00:00:00 | 2019-11-01 00:00:00 | IGILDO
 | 3 | V054 | [NAME] | Problemas de compressor de Ar condicionado. | 2019-10-30 00:00:00 |  | Calleb
 | 4 | V049 | ADH-907-MC | Substituição de apoios do motor [NAME] e directo. | 2019-10-30 00:00:00 | 2019-10-30 00:00:00 | IGILDO
 | 5 | V042 | AFD-574-MP | Mudancas de anilhas de bombenta de diesel. | 2019-10-30 00:00:00 | 2019-10-30 00:00:00 | IGILDO/ZITO
 | 6 | V046 | AHF-323-MC | Problemas de balatas [NAME] estacionamento). | 2019-10-31 00:00:00 | 2019-10-31 00:00:00 | ANDRE MANHQUE
 | 7 | V044 | AHD-297-MC | Problemas de Embriagem | 2019-10-31 00:00:00 | 2019-10-31 00:00:00 | IGILDO
 | 8 | V042 | AFD-574-MP | Avaria de Motor de arranque. | 2019-11-01 00:00:00 |  | IGILDO
 | 9 | V037 | AFB-664-MC | Comando de Motor | 2019-11-08 00:00:00 |  | IGILDO
 | 10 | V036 | AEB-349-MP | [NAME], ar condicionado,estacionamento,ventoinha e conta kilometro. | 2019-11-08 00:00:00 |  | IGILDO
 | 11 | V045 | AEC-227-MP | Ar condicionado | 2019-11-12 00:00:00 |  | Calleb
 | 12 | V034 | AEG-156-MC | Splite troca de Pneus | 2019-11-12 00:00:00 |  | Matias
 | 13 | V018 | AEM-918-MC | [NAME],problema de ar-condicionado e manutencao preventiva | 2019-11-13 00:00:00 | 2019-11-13 00:00:00 | MAVALE
 | 14 | V019 | AEM-918-MP | Luz de presenca, ar condicionado ,fuga de oleo de travao e avarias do vidro do [NAME] nao abre. | 2019-11-13 00:00:00 | 2019-11-13 00:00:00 | Calleb/Zito
 | 15 | V039 | AGK-366-MP | Sistema de Mudanças(não esta acionar a partilha para engrenar baixas) | 2019-11-13 00:00:00 |  | [NAME]
 | 16 | V018 | AEM-965-MP | Problemas de Ar Condicionado | 2019-11-14 00:00:00 | 2019-11-17 00:00:00 | Calleb
 | 17 | V045 | AEC-227-MP | Ar condicionado,escada,falta veio de atracao,suporte do pneu sobressalente e power sterring | 2019-11-15 00:00:00 |  | Calleb/Mavale
 | 18 | V059 | AAA-982-TT | Ar-condicionado,avaria de sistema eletrico, pneu sobressalente, e diagnostico deb painel. | 2019-11-15 00:00:00 |  | Calleb/Zito
 | 19
 | 20
Spreadsheet: 678724d1590040723-vlookup-multiple-criteria-award-category
Sheet: Sales Target

Name | Total Sales | Result | Total Sales | Result | Total Sales | Result | Total Sales | Result | Total Sales | Result | Total Sales | Result | Criteria |  |  | Achieve?
 | (Running 1st Week) |  | (Running 2nd Week) |  | (Running 3rd Week) |  | (Running 4th Week) |  | (Running 5th Week) |  | (Running 6th Week) |  | New Block | Existing Block | Result
[NAME] | 10392 | PASS | 9080 | PASS | 7043 | PASS | 5531 | PASS | 4199 | FAIL | 3362 | FAIL | 3 | 1444
[NAME] | 1294 | FAIL | 1119 | FAIL | 948 | FAIL | 948 | FAIL | 778 | FAIL | 626 | FAIL | 4 | 1745
[NAME] | 12466 | PASS | 10247 | PASS | 8027 | PASS | 6444 | PASS | 5374 | PASS | 4615 | FAIL | 3 | 1600
[NAME] | 6360 | PASS | 5295 | PASS | 4353 | FAIL | 3406 | FAIL | 2989 | FAIL | 2734 | FAIL | 2 | 1600
[NAME] | 7361 | PASS | 5530 | PASS | 4663 | FAIL | 3960 | FAIL | 3074 | FAIL | 2619 | FAIL | 6 | 1920
Spreadsheet: 810775d1672057933-auto-formulas-from-one-sheet-to-another-autoformula-column-i
Sheet: Stammdaten

Abrechnungs Monat |  | 2022-11-01 00:00:00 |  |  |  | KZ
[NAME] |  | 22:00:00 | 05:00:00 |  |  | A
Tarifstundenlohn |  | 11.55 |  |  |  | F
Preis pro MiniBar |  | 0.1 |  |  |  | K
Preis pro [NAME] |  | 0.9 |  |  |  | U
 |  |  |  |  |  | PT
 |  |  |  |  |  | Q
 |  |  |  |  |  | FT
Extra Stunden Preis
Checker Stunden Preis
Objektleiter Paushal |  | 3093
Spreadsheet: 219276d1362696303-need-to-copy-formulas-150-times-xlf-rd
Sheet: CUR_EXP_REPORT

[NAME] |  |  |  | DATES | LABOUR |  |  |  |  | MATERIALS + SHIPPING COSTS
# |  |  |  | From : To | R&D Description Of Activity | Annex | Name | Hrs | Labour Costs $26.24 /hr | Mat        (NET) | Ship /   H | Foreign exchge  [$] | Duty fees/  Brok /     Srv | QTY | Costs($) before taxes
# |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
# | 1 |  |  | <SEPT-10-12> | PASSIVE COMPONENTS: Various components used in new ACM Board prototype | [NAME] | xxxxx | 0 | 0 | 20.06 | 0 | 0 | 0 | 1 | 20.06
O | 1 |  |  | <SEPT-10-12> | BREADBOARDS: Electronic bread boards for new ACM board prototype | [NAME] | xxxxx | 0 | 0 | 30.98 | 0 | 0 | 0 | 1 | 0
# | 2 |  |  | <OCT-26-12> | DC/DC CONVERTORS: Electronic bread boards for new ACM board prototype | [NAME] | xxxxx | 0 | 0 | 92.21 | 20.3 | 0 | 0 | 1 | 112.51
# | 3 |  |  | <SEPT-14-12> | VTFT DONGLE LICENCE: Dongle licence key + delivery charges | [NAME] | xxxxx | 0 | 0 | 45.22 | 41 | 0 | 6.45 | 1 | 92.67
# | 1 |  |  | <NOV-22-12> | ELECTRONIC COMPONENTS FOR NEW SENSOR TECHNOLOGY: Various electronics components for new sensor technology | [NAME] | xxxxx | 0 | 0 | 29.8 | 0 | 0 | 0 | 1 | 29.8
O | 1 |  |  | <JAN-19-12> | LOGICOM MEETTINGS: Several meetings were held on the issue of future boards and their operating system | [NAME] | xxxxx | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0
O | 5 |  |  | 0 | TESTERRRRRR: NO $$$$$$ | [NAME] | xxxxx | 99 | 2597.76 | 111 | 1 | 1 | 1 | 1 | 0
#
# |  |  |  |  |  | Cumulative Labour: |  |  | 2597.76 | Cumulative Claim costs: |  |  |  |  | 369.04
#
#
#
Spreadsheet: mike_swerzbin__28042__EMR Prices
Sheet: Sheet1

 |  | Peak |  | Off-Peak
Region | Delivery Date | Low | High | Low | High
Red numbers indicate flat, 24-hour products.
NW/N. Rockies | 2001-12-25 00:00:00 | 17 | 18 | 17 | 18
Mid-Columbia | 2001-12-25 00:00:00 | 17 | 18 | 17 | 18
COB | 2001-12-25 00:00:00 | 15.5 | 16.25 | 15.5 | 16.25
N. California | 2001-12-25 00:00:00 | 15 | 18.5 | 15 | 18.5
Midway/Sylmar | 2001-12-25 00:00:00 | NA | NA | NA | NA
S. California | 2001-12-25 00:00:00 | 14 | 17 | 14 | 17
Mead | 2001-12-25 00:00:00 | 14.25 | 15 | 14.25 | 15
Palo Verde | 2001-12-25 00:00:00 | 13.25 | 14.75 | 13.25 | 14.75
Inland SW | 2001-12-25 00:00:00 | 13.25 | 15 | 13.25 | 15
4-Corners | 2001-12-25 00:00:00 | 13.5 | 14.5 | 13.5 | 14.5
Central Rockies | 2001-12-25 00:00:00 | 13 | 14 | 13 | 14
NW/N. Rockies | 2001-12-26 00:00:00 | 19.25 | 21 | 17 | 18
Mid-Columbia | 2001-12-26 00:00:00 | 19.25 | 21 | 17 | 18
COB | 2001-12-26 00:00:00 | 21 | 23 | 15.5 | 16.25
N. California | 2001-12-26 00:00:00 | 24 | 23.5 | 15 | 18.5
Midway/Sylmar | 2001-12-26 00:00:00 | NA | NA | NA | NA
S. California | 2001-12-26 00:00:00 | 22 | 25.25 | 14 | 17
Mead | 2001-12-26 00:00:00 | 21 | 23.5 | 14.25 | 15
Palo Verde | 2001-12-26 00:00:00 | 21.5 | 23.75 | 13.25 | 14.75
Inland SW | 2001-12-26 00:00:00 | 21 | 23.75 | 13.25 | 15
4-Corners | 2001-12-26 00:00:00 | 21.5 | 23 | 13.5 | 14.5
Central Rockies | 2001-12-26 00:00:00 | 19.5 | 21.25 | 13 | 14
Spreadsheet: 120599d1315403110-converting-data-in-matrix-form-into-a-vector-expand
Sheet: Sheet1

Blue | 1 | 10 | Tall | 1 | Blue | 10 | Tall
Red | 2 | 15 | Tall | 2 | Red | 15 | Tall
Blue | 1 | 20 | Small | 4 | Red | 15 | Tall
green | 3 | 20 | Tall | 5 | Blue | 20 | Small
green | 2 | 20 | small | 8 | green | 20 | Tall
black | 10 | 30 | long | 10 | green | 20 | Tall
blue | 5 | 23 | even | 20 | green | 20 | Tall
 |  |  |  | 25 | green | 20 | small
 |  |  |  | 25 | green | 20 | small
 |  |  |  | 25 | black | 30 | long
 |  |  |  | 25 | black | 30 | long
 |  |  |  | 25 | black | 30 | long
 |  |  |  | 25 | black | 30 | long
 |  |  |  | 25 | black | 30 | long
 |  |  |  | 25 | black | 30 | long
 |  |  |  | 25 | black | 30 | long
 |  |  |  | 25 | black | 30 | long
 |  |  |  | 25 | black | 30 | long
 |  |  |  | 25 | black | 30 | long
 |  |  |  | 25 | blue | 23 | even
 |  |  |  | 25 | blue | 23 | even
 |  |  |  | 25 | blue | 23 | even
 |  |  |  | 25 | blue | 23 | even
 |  |  |  | 25 | blue | 23 | even
Spreadsheet: 62424d1263382030-look-up-and-place-certain-dates-within-months-with-an-extra-lookup-exampledata1
Sheet: Sheet1

 | Start Date | Year 1 | Year 2 | Year 3 | Year 4 | Year 5
Bloggs | 2010-01-02 00:00:00 | 50000 | 58000 | 68000 | 75000 | 79000
Sinatra | 2010-03-12 00:00:00 | 40000 | 45000 | 49000 | 52000 | 58000
Spreadsheet: 206021d1357992825-tracking-athletic-records-atheltic-records-example-sirtifiable-oeldere-
Sheet: Sheet1

Results |  |  |  |  | Records
Number | Event | Performance | Old |  | Name | Number | 80m | 100m | 200m | 300m | 400m | 1500m
1025 | 100m | 00:12:02 | [NAME] |  | [NAME] | 1025
6587 | 200m | 00:23:08 | [NAME] |  | [NAME] | 6587
2398 | 80m | 00:09:06 | 9.6 Sec |  | [NAME] | 2398
1568 | 300m | 01:05:03 | 1 Min 5.3 Sec |  | Cara | 1568
1426 | 100m | 00:25:03 | 25.3 Sec |  | Emma | 1426
7845 | 400m | 02:06:08 | 2 Min 6.8 Sec |  | Martin | 7845
3355 | 1500m | 05:22:01 | 5 Min 22.1 Sec |  | [NAME] | 3355
1025 | 100m | 00:11:03 | 11.3 Sec
6587 | 200m | 00:24:08 | 24.8 Sec
2398 | 80m | 00:09:06 | 9.63 Sec
1568 | 300m | 01:15:03 | 1 Min 15.3 Sec |  |  | Waarden
1426 | 100m | 00:22:03 | 22.3 Sec |  | Rijlabels | count Performance | [NAME] | Min  Performance
7845 | 400m | 01:46:08 | 1 Min 46.8 Sec |  | 100m | 4 | 00:25:03 | 00:11:03
3355 | 1500m | 04:32:01 | 4 Min 32.1 Sec |  | 1025 | 2 | 00:12:02 | 00:11:03
 |  |  |  |  | 1426 | 2 | 00:25:03 | 00:22:03
 |  |  |  |  | 1500m | 2 | 05:22:01 | 04:32:01
 |  |  |  |  | 3355 | 2 | 05:22:01 | 04:32:01
 |  |  |  |  | 200m | 2 | 00:24:08 | 00:23:08
 |  |  |  |  | 6587 | 2 | 00:24:08 | 00:23:08
 |  |  |  |  | 300m | 2 | 01:15:03 | 01:05:03
 |  |  |  |  | 1568 | 2 | 01:15:03 | 01:05:03
 |  |  |  |  | 400m | 2 | 02:06:08 | 01:46:08
 |  |  |  |  | 7845 | 2 | 02:06:08 | 01:46:08
 |  |  |  |  | 80m | 2 | 00:09:06 | 00:09:06
 |  |  |  |  | 2398 | 2 | 00:09:06 | 00:09:06
 |  |  |  |  | Eindtotaal | 14 | 05:22:01 | 00:09:06
Spreadsheet: 70168d1270862242-assign-value-to-letters-for-averaging-performance
Sheet: Sheet1

Date | Progress and Accomplishments | Technical Competence | Teamwork | Innovation & Adaptation | Customer Care | Initiative | Communication | Integrity |  |  | Averages
 |  | D | P | M |  |  |  |  |  | Technical Competence
 |  | P | M | M |  |  |  |  |  | Teamwork
 |  | M | D | D |  |  |  |  |  | Innovation & Adaptation
 |  | M | D | D |  |  |  |  |  | Customer Care
 |  | M | D | P |  |  |  |  |  | Initiative
 |  | P | D | P |  |  |  |  |  | Communication
 |  | P | D | P |  |  |  |  |  | Integrity
 |  | D | D | P
 |  | D | M | P
 |  | D | M | P
 |  | D | M | P
 |  | D |  | P
 |  | M |  | D
 |  | M
 |  | P
 |  | P
 |  | M
 |  | M
Spreadsheet: 80447d1280670126-automatic-updating-sample-workbook-complete-
Sheet: PERSTAT Summary

Provider | Assigned | Duty | R&R | Sick Call | TDY | RDO | Medical Leave | [NAME] | Hospital | LWOP | Emergency Leave | Absent
AGS
BAE
BAE-TVS
RG33
BFT
CROWS
Digital Backbone
DRS
EMA
ESP
FPI
GDLS
Government
Honeywell
ISS
ITT
Jacobs
JLI
[NAME]
ManTech
ManTech / VSE
[NAME]
OSHKOSH
PM
PM CROWS
PM/FLIR
Rangerland
RRAD
SPAWAR
Stanley
TJFIG
Unknown
VSE
Totals
Provider | Assigned | Duty | R&R | Sick Call | TDY | RDO | Medical Leave | [NAME] | Hospital | LWOP | Emergency Leave | Absent
Spreadsheet: 861727d1709572182-populate-from-another-sheet-with-duplicates-product-pick-dj
Sheet: Search

Customer # | Customer Name | Product name | [NAME] (lbs) | [NAME] (kgs)
3004 |  | Carton
2714 |  | Sacks
2872 |  | Small Carton
Spreadsheet: 730923d1620051343-formulas-and-drop-down-lists-workload_dashboard
Sheet: Azure_Regions

DisplayName | Location
East Asia | eastasia
Southeast Asia | southeastasia
Central US | centralus
East US | eastus
East US 2 | eastus2
West US | westus
North Central US | northcentralus
South Central US | southcentralus
North Europe | northeurope
West Europe | westeurope | euw
Japan West | japanwest
Japan East | japaneast
Brazil South | brazilsouth
Australia East | australiaeast
Australia Southeast | australiasoutheast
South India | southindia
Central India | centralindia
West India | westindia
Canada Central | canadacentral
Canada East | canadaeast
UK South | uksouth
UK West | ukwest
West Central US | westcentralus
West US 2 | westus2
Korea Central | koreacentral
Korea South | koreasouth
France Central | francecentral
France South | francesouth
Australia Central | australiacentral
Australia Central 2 | [NAME]
UAE Central | uaecentral
UAE North | [NAME]
South Africa North | southafricanorth | zan
South Africa West | southafricawest | zaw
Switzerland North | switzerlandnorth
Switzerland West | switzerlandwest
Germany North | germanynorth
Germany West Central | germanywestcentral
Norway West | norwaywest
Norway East | norwayeast
Brazil Southeast | brazilsoutheast
West US 3 | westus3
Spreadsheet: 36427d1234304737-excel-2007-min-0-for-s-not-in-a-set-lowest-value-out-of-a-spread-out-list
Sheet: Sheet1

2 |  | 0 |  | 2 |  | 3 |  | 4 |  | 6 |  | 7 |  | 0 |  | 5 |  | 6 |  | 5 |  | 4 |  | 3 |  | 5 |  | 2 |  | 0 |  | 0 |  | 3 |  | 5 |  | 4 |  | 2
2 | <--answer here
Spreadsheet: 54107d1254139369-conditional-formatting-based-on-several-cell-values-conditionhelp
Sheet: Sheet1

 | Shifts |  | 7/5 | RD | 2/12 | 4/2
 | Numbers & Colours |  | 2 | 1 | 2 | 1 | << Conditional Formatting will be applied to these
 | Jo |  | PST |  | PST
 | [NAME] |  |  | PST | PST | PST
 | [NAME]
 | [NAME] |  | PST
 | Conditions
1 | So formatting - If Shift = 7/5 and Numbers =>1 then green.  OR If Shift = 2/12 or 4/2 and number is >1 then green OR if shift = RD Then green
2 | If Shift = 7/5, 2/12 or 4/2 AND Number = 0 Then RED
3 | If Shift = 2/12 or 4/2 and Numbers = 1 then go Amber
 | THANK YOU IN ADVANCE
Spreadsheet: 758975d1639204657-how-to-get-unique-text-value-from-column-values-book1_un
Sheet: Sheet1

A/A
A/A
T/T
A/A
C/C
MISSING
G/G
C/C
G/G
T/T
Spreadsheet: phillip_platter__31378__RT-STCA August
Sheet: Aug06

DATE | FERC FILE | SERVICE CUST | HR BEG | HR END | TOTAL HRS | DEL PT | SUPPLY | MW PER HR | TOTAL MW | SCHEDULE ID | PRICE | MARKET | PRICE | FEES | CONG | A_S CHARGE | BASIS | FERC ADJ | ENPOWER DEALS | TMM | LINE LOSSES | P_L | FILE SOURCE | TAG NO
2001-08-06 00:00:00 |  | Y | 7 | 8 |  | SP15 | WESCO | 50 |  |  | 48 | STCALI | 68.14 |  |  |  |  |  |  | 718319,718320 | 1 |  | 0
 |  | Y | 9 | 9 |  | SP15 | CORAL | 25 |  |  | 42.5 | STCALI | 68.14 |  |  |  |  |  |  | 718896,718320 | 1 |  | 0
 |  | Y | 9 | 9 |  | SP15 | RELIANT | 18 |  |  | 47 | STCALI | 68.14 |  |  |  |  |  |  | 718926,718320 | 1 |  | 0
 |  | Y | 9 | 9 |  | SP15 | EES | 7 |  |  | 20 | STCALI | 68.14 |  |  |  |  |  |  | 718943,718320 | 1 |  | 0
 |  | Y | 10 | 10 |  | SP15 | CORAL | 25 |  |  | 42.5 | STCALI | 68.14 |  |  |  |  |  |  | 718896,718320 | 1 |  | 0
 |  | Y | 10 | 10 |  | SP15 | RELIANT | 25 |  |  | 47 | STCALI | 68.14 |  |  |  |  |  |  | 718926,718320 | 1 |  | 0
 |  | Y | 11 | 22 |  | SP15 | WESCO | 25 |  |  | 53 | STCALI | 68.14 |  |  |  |  |  |  | 718319,718320 | 1 |  | 0
 |  | Y | 11 | 12 |  | SP15 | WESCO | 25 |  |  | 50 | STCALI | 68.14 |  | 0.6 |  |  |  |  | 719364, 718320 | 1 |  | 0
 |  | Y | 13 | 18 |  | SP15 | WESCO | 25 |  |  | 58 | STCALI | 68.14 |  |  |  |  |  |  | 718319,718320 | 1 |  | 0
 |  | Y | 19 | 19 |  | SP15 | CORAL | 25 |  |  | 58 | STCALI | 68.14 |  |  |  |  |  |  | 718896,718320 | 1 |  | 0
 |  | Y | 20 | 20 |  | SP15 | CORAL | 10 |  |  | 58 | STCALI | 68.14 |  |  |  |  |  |  | 718896,718320 | 1 |  | 0
 |  | Y | 20 | 20 |  | SP15 | EES | 15 |  |  | 48 | STCALI | 68.14 |  |  |  |  |  |  | 720264, 718320 | 1 |  | 0
 |  | Y | 21 | 22 |  | SP15 | EES | 25 |  |  | 48 | STCALI | 68.14 |  |  |  |  |  |  | 720264, 718320 | 1 |  | 0
Spreadsheet: 69297d1269852697-excel-2008-conditional-if-with-first-letter-of-a-word-and-elimination-of-multiple-returned-value-datamerge
Sheet: Sheet1

Codigo | Familia | @fam | @ABC | Especie | Nombre vulgar | List A | IF..then
31305M3Z-18 | Trepadoras |  |  | Euonymus Japonica "Aurea luna" | Evonimo
31304M3Z-18 | Trepadoras |  | :a.png | Euonymus Japonica "Aurea" | Evonimo | Cítricos
32201C31WCO10-99 | Arbustos |  |  | Laurus Nobilis Aucuba | Laurel | Palmáceas
32201C31WCO12-99 | Arbustos |  |  | [NAME] Abelia | Laurel | Trepadoras
32201C31WCO14-99 | Arbustos |  | :l.png | [NAME] | Laurel | Arbustos
87200C18W-99 | [NAME] |  |  | Bacopa | Bacopa | Coníferas
60300C55ZX-18 | Cítricos |  |  | Citrus limon variegata | [NAME] | Forestal
60300C60ZX-18 | Cítricos |  | :c.png | Citrus limon | [NAME] | Frutales
20305M2ZPI-07 | Trepadoras |  | :b.png | Bougainvillea sanderiana | Bougainvillea sanderiana | Ejemplares
35102C26WPI60-99 | Arbustos |  | :b.png | Buxus Sempervirens | Boj | [NAME]
35102C30WPIT2-99 | Arbustos |  |  | Buxus Sempervirens | Boj
List A (Col G) is the drop-down information reuqired for Col B)
IF.. Then is the information required for (Col C) which will link to a graphic when exported
The objective is to sort the list by Family (which will be A-Z from the Col B) and the in Col D, to check the first Letter of the Species (Col E) and
place the corresponding :a.png, :b.png etc as the result HOWEVER, as many of the Plants have long names a "sort" A-Z would need to be performed
in order to find the first real instance of A,B,C etc.
Multiple versions of the ":a.png", ":b.png" etc should be eliminated IF they are repeated within the same families (Col B).
As you can see from the above the ":b.png" is returned twice as it is correctly assigned to the first letter of the Plant name in Col E but once to the
Family "[NAME]" in Col B and also to the Family "Arbustos" in Col B.
Spreadsheet: 97325d1296542234-joining-columns-of-different-lengths-from-different-sheets-concatenate_sheets
Sheet: Control

 | On this sheet | There are this many rows | Rows to subtract
0 | Sheet1 | 6 | 0
7 | Sheet2 | 3 | 6
10 | Sheet3 | 5 | 9
999999 |  | 0 | 14
999999 |  | 0 | 14
999999 |  | 0 | 14
999999 |  | 0 | 14
999999 |  | 0 | 14
999999 |  | 0 | 14
Spreadsheet: 50758d1250238900-vlookup-with-multiple-conditions-formula-find-example
Sheet: Individual Sheets

8 | Gross up | 11.7 | 2009 Price change | 0.9 | 2010 Price change | 0.05 | 0.2 | 0.15 | 0.1
dimStock | Cups
dimDepots
 |  |  |  |  |  | Budget | YTD | Forecast | Budget | Budget | Budget
 |  | 2005 | 2006 | 2007 | 2008 | 2009 | 2009 | 2009 | 2010 | 2011 | 2012
Customer Class | Data
Black | Quantity Sold | 7000 |  | 2000 | 10000 | 2000 |  | 0 | 0.05 | 0.1 | 0.1
 | Net Sales Value | 6629 |  | 2162 | 11800 | 2270.1 |  | 0 | 0.05 | 0.1 | 0.1
Red | Quantity Sold | 113200 | 115850 | 19100 | 44825 | 112200 |  | 0 | 0.05 | 0.1 | 0.1
 | Net Sales Value | 67662.85 | 79623.51 | 14600.12 | 34110.94 | 149754.32 |  | 0 | 0.05 | 0.1 | 0.1
Blue | Quantity Sold | 70700 | 61425 | 48250 | 47349 | 49000 |  | 0 | 0.05 | 0.1 | 0.1
 | Net Sales Value | 30547.28 | 32397.19 | 27417.24 | 31286.94 | 28289.63117647059 |  | 0 | 0.05 | 0.1 | 0.1
Yellow | Quantity Sold |  |  |  | -2000 |  |  | 0 | 0.05 | 0.1 | 0.1
 | Net Sales Value |  |  |  | -586 |  |  | 0 | 0.05 | 0.1 | 0.1
Green | Quantity Sold | 84000 | 70375 | 60750 | 62724 | 58000 |  | 0 | 0.05 | 0.1 | 0.1
 | Net Sales Value | 56709.88 | 48533.56 | 42650.18 | 46693.71 | 58320 |  | 0 | 0.05 | 0.1 | 0.1
Total Quantity Sold |  | 274900 | 247650 | 130100 | 162898 | 221200 | 0 | 0 | 0.25 | 0.5 | 0.5
Total Net Sales Value |  | 161549.01 | 160554.26 | 86829.54 | 123305.59 | 238634.0511764706 | 0 | 0 | 0.25 | 0.5 | 0.5
Spreadsheet: 613451ab-348a-4932-b143-2c3e10964aed
Sheet: Abstinence Education

Grant: |  | Title V - Abstinence Education Grant Program
CFDA # |  | 93.235
GRANT NUMBER: |  | 6710
FISCAL YEAR: |  | 10/1/2013 THROUGH 9/30/2014
[NAME]: |  | Not allowed on this grant
Question regarding payments: |  | [NAME]-866-6724  or  [EMAIL]
Questions regarding grant: |  | Marti Rodriguez [PHONE] or [EMAIL]
LAST DAY TO SUBMIT REQUESTS FOR THIS GRANT  - November 15, 2014
Code | District Name | ALLOCATION | PAYMENTS TO DATE | BALANCE | OCTOBER  2013 | NOVEMBER  2013 | DECEMBER  2013 | JANUARY  2014 | FEBRUARY  2014 | [NAME]  2014 | APRIL  2014 | MAY  2014 | JUNE  2014 | JULY  2014 | AUGUST  2014 | SEPTEMBER  2014
Y582 | Pueblo City-County Health Dept | 57193 |  |  |  |  | 5463 | 3497 | 6355
Y583 | Friends First, Inc. | 211867 |  |  |  |  |  | 13297 | 16589
Y584 | Center for Relationship Education | 229757 |  |  |  |  | 16210 |  | 16246