tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 50904d1250504977-vlookup-with-multiple-conditions-formula-20find-20example-1-
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
 |  |  |  |  |  | YTD | Budget | Forecast | Budget | Budget | Budget
 |  | 2005 | 2006 | 2007 | 2008 | 2009 | 2009 | 2009 | 2010 | 2011 | 2012
Customer Class | Data
Black | Quantity Sold | 1000 | 0 | 2000 | 3000 | 0 | 2000 | 0 | 0.05 | 0.1 | 0.1
Black | Net Sales Value | 6000 | 0 | 12000 | 18000 | 0 | 2270.1 | 0 | 0.05 | 0.1 | 0.1
Red | Quantity Sold | 3000 | 4000 | 5000 | 6000 | 7000 | 112200 | 10237.5 | 10237.55 | 10237.6 | 10237.6
Red | Net Sales Value | 12000 | 16000 | 20000 | 24000 | 28000 | 149754.32 | 36855 | 36855.05 | 36855.10000000001 | 36855.10000000001
Blue | Quantity Sold | 2000 | 3000 | 4000 | 5000 | 6000 | 49000 | 7897.5 | 7897.55 | 7897.6 | 7897.6
Blue | Net Sales Value | 3500 | 7000 | 11500 | 15000 | 18500 | 28289.63117647059 | 24350.625 | 24350.675 | 24350.725 | 24350.725
Yellow | Quantity Sold | 0 | 0 | 0 | -2000 | 0 |  | 0 | 0.05 | 0.1 | 0.1
Yellow | Net Sales Value | 0 | 0 | 0 | -500 | 0 |  | 0 | 0.05 | 0.1 | 0.1
Green | Quantity Sold | 4000 | 5000 | 6000 | 7000 | 8000 | 58000 | 11700 | 11700.05 | 11700.1 | 11700.1
Green | Net Sales Value | 16000 | 20000 | 24000 | 28000 | 32000 | 58320 | 42120 | 42120.05 | 42120.10000000001 | 42120.10000000001
Total Quantity Sold |  | 10000 | 12000 | 17000 | 19000 | 21000 | 221200 | 29835 | 29835.25 | 29835.5 | 29835.5
Total Net Sales Value |  | 37500 | 43000 | 67500 | 84500 | 78500 | 238634.0511764706 | 103325.625 | 103325.875 | 103326.125 | 103326.125
Spreadsheet: darrell_schoolcraft__7217__saledoc10_5TW
Sheet: Sheet1

Transwestern Pipeline Company
GAS [NAME]
 | GAS SALE INFORMATION |  |  |  |  | PURCHASE PARTY
Account Manager |  |  | [NAME] |  |  | Company: |  | Richardson Products
Deal Date: |  |  | 2001-10-29 00:00:00 |  |  | Contact Name: |  | [NAME]
Gas Sale Date (s) |  |  | 10/31/2001 |  |  | FAX Number:
Total Quantity |  |  | 15000 | MMBtu |  | Address: |  | Phone: [PHONE]
Gas Sale Price |  |  | El Paso Perm Gas Daily
GAS SALE TERMS
 |  | Contract Quantity (MMBtu)
SALE DATES |  |  |  | Daily
Start | End | Monthly |  | Min |  | [NAME] |  | Other
10/31/2001 | 2001-10-31 00:00:00 | 15000 |  | 15000 |  | 15000
RELATED SCHEDULING AND TRANSPORTATION REQUIREMENTS
Tranwestern Receipt/Delivery Point |  |  |  |  |  |  | DOWNSTREAM |  | TW UPSTREAM
Name |  |  | POI # |  | Daily Volume |  | Contract # |  | Contract Number
West Texas Pool |  |  | 58646 |  | 15000 |  |  |  | 22948
 |  |  | BILLING BY THIRD PARTY |  |  |  |  | Please direct all invoices to:
 |  |  | Month [NAME] Rec'd |  | Expected [NAME] |  |  | Debbie Mosely
 |  |  |  |  | To be determined |  |  | Transwestern Pipeline Company
 |  |  |  |  |  |  |  | P.O. Box 1188
 |  |  |  |  |  |  |  | Houston, TX  77251-1188
Comments:
Buyer: Please acknlowledge confirmation of the above deal by signing below and faxing this confirmation to:
Theresa Branney [PHONE]   Phone [PHONE]
Gas Buyer Signature |  |  |  |  |  |  | Date:
TW Acct Manager Signature |  |  |  |  |  |  | Date:
Spreadsheet: darrell_schoolcraft__7585__imball0112
Sheet: Amoco Abo

 | [NAME] |  | Amoco Abo fuel del
Day | Measured | Scheduled | Measured | Scheduled | Imbal
1 | 12873 | 10932
2 | 13275 | 10932
3 | 15491 | 10932 | -1
4 | 14090 | 10897 | -2
5 | 14451 | 10932 | -6
6 | 13027 | 10932 | -56
7 | 11185 | 10932 | -97
8 | 10651 | 10866 | -111
9 | 10898 | 10932 | -36
10 | 11139 | 10932 | -13
11 | 11928 | 10932 | -37
12 | 11557 | 10157 | -23
13 | 10718 | 10157 | -36
14 | 11228 | 10157 | -64
15 | 11959 | 10157 | -98
16 | 10946 | 10157 | -89
17 | 11993 | 10157 | -250
18 | 13205 | 10157 | -31
19 | 12992 | 10157 | -57
20 | 14614 | 10157 | -110
21 | 15993 | 10157 | -1190
22 | 19902 | 10157 | -3524
23 | 23570 | 10157 | -3480
24 | 17900 | 10157 | -3553
25 | 17626 | 10157 | -3522
26 | 17384 | 10157 | -3519
27 | 19657 | 10157 | -3511
28 | 20402 | 10157 | -2399
29 | 14734 | 10157 | -1930
30
31
2001-11-30 00:00:00 |  |  |  |  | 392389.58
2001-12-29 00:00:00
CBS Volume
 |  |  | -260608
Spreadsheet: 142517d1329882731-excel-2007-consolidating-different-values-under-different-names-indifferent-tabs-to-master-sheet-varification-doc
Sheet: VIKAS TOWER

VIKAS TOWER |  |  |  |  |  |  |  | VASANTKUNJ |  |  |  | VASANTKUNJ |  |  |  | VASANTKUNJ |  |  |  | VASANTKUNJ |  |  |  | VASANTKUNJ |  |  |  | VASANTKUNJ |  |  |  | VASANTKUNJ |  |  |  | VASANTKUNJ |  |  |  | VASANTKUNJ |  |  |  | VASANTKUNJ |  |  |  | VASANTKUNJ |  |  |  | VASANTKUNJ |  |  |  | VASANTKUNJ |  |  |  | VASANTKUNJ |  |  |  | VASANTKUNJ |  |  |  | VASANTKUNJ |  |  |  | VASANTKUNJ |  |  |  | VASANTKUNJ |  |  |  | VASANTKUNJ |  |  |  | VASANTKUNJ |  |  |  | VASANTKUNJ |  |  |  | VASANTKUNJ |  |  |  | VASANTKUNJ |  |  |  | VASANTKUNJ |  |  |  | VASANTKUNJ |  |  |  | VASANTKUNJ |  |  |  | VASANTKUNJ |  |  |  | VASANTKUNJ |  |  |  | VASANTKUNJ |  |  |  | VASANTKUNJ |  |  |  | VASANTKUNJ |  |  |  | VASANTKUNJ |  |  |  | VASANTKUNJ |  |  |  | VASANTKUNJ |  |  |  | VASANTKUNJ |  |  |  | VASANTKUNJ |  |  |  | VASANTKUNJ |  |  |  | VASANTKUNJ |  |  |  | VASANTKUNJ |  |  |  | VASANTKUNJ |  |  |  | VASANTKUNJ |  |  |  | VASANTKUNJ |  |  |  | VASANTKUNJ |  |  |  | VASANTKUNJ |  |  |  | VASANTKUNJ |  |  |  | VASANTKUNJ |  |  |  | VASANTKUNJ |  |  |  | VASANTKUNJ |  |  |  | VASANTKUNJ |  |  |  | VASANTKUNJ |  |  |  | VASANTKUNJ |  |  |  | VASANTKUNJ |  |  |  | VASANTKUNJ |  |  |  | VASANTKUNJ |  |  |  | VASANTKUNJ |  |  |  | VASANTKUNJ |  |  |  | VASANTKUNJ |  |  |  | VASANTKUNJ |  |  |  | VASANTKUNJ |  |  |  | VASANTKUNJ |  |  |  | VASANTKUNJ |  |  |  | VASANTKUNJ
SNO | Part Code | Description | Qty | Qty (As on Date 16th Jan-2012)
Section-V,  Part A, SNO-3, 5 | PE-SV Router, PE-SDN Router |  | 1
Existing Material Redeployment
A | Power System
 | 200 AH Battery |  | 2
Spreadsheet: 669621d1585503114-automatically-count-from-drop-down-list-on-another-sheet-sample
Sheet: PROJECTS

NO | DATE | COMPANY NAME | PROJECT | STATUS
18 | 2017-08-22 00:00:00 | ANDRITZ HYDRO |  | Rejected
19 | 2017-08-22 00:00:00 | ANDRITZ HYDRO |  | StandBy
20 | 2017-08-22 00:00:00 | ANDRITZ HYDRO |  | Rejected
21 | 2017-08-22 00:00:00 | ANDRITZ HYDRO |  | Cancelled
221 | 2019-03-04 00:00:00 | SIEMENS |  | Confirmed
432 | 2019-03-05 00:00:00 | SIEMENS |  | Confirmed
453 | 2019-03-05 00:00:00 | SIEMENS |  | Rejected
809 | 2019-03-07 00:00:00 | SIEMENS |  | Confirmed
1002 | 2019-03-07 00:00:00 | SIEMENS |  | Rejected
Spreadsheet: 824379d1680532486-is-there-such-formula-to-take-date-from-different-cells-and-put-into-another-cell-year_q
Sheet: Sheet1

 | Q1 | Q2 | Q3 | Q4 |  |  | 1997-Q3
1994 | 5 | 7 | 6 | 5 |  |  | 1999-Q4
1995 | 11 | 2 | 3 | 6 |  |  | 2000-Q3
1996 | 6 | 8 | 10 | 2 |  |  | 2003-Q1
1997 | 6 | 6 | 8 | 3
1998 | 6 | 12 | 4 | 3
1999 | 8 | 4 | 9 | 3
2000 | 5 | 10 | 11 | 7
2001 | 9 | 3 | 3 | 7
2002 | 7 | 3 | 4 | 3
2003 | 5 | 5 | 7 | 10
Spreadsheet: 265236d1379119371-matching-two-pairs-of-cells-between-two-lists-sample-matching-names-for-csd
Sheet: Sheet1

 | DISIS |  |  |  |  |  | CLIENT LIST
 | Line # | last name | join date | combine | matched with |  | Last name | birthdate | combine | matched with
 | 16 | Leblanc | 1035530 |  |  |  | leblanc | 1035530
 | 5 | Bouchard | 311198 |  |  |  | bouchard | 311198
 | 19 | Simard | 741570 |  |  |  | simard | 741570
 | 17 | Leblanc | 563465 |  |  |  | leblanc | 563465
 | 3 | Tremblay | 1035530 |  |  |  | tremblay | 1035530
 | 28 | [NAME] | 204406 |  |  |  | [NAME] | 204406
 | 1 | Tremblay | 225 |  |  |  | lavoie | 22
 | 2 | Tremblay | 326 |  |  |  | poirier | 500791
 | 4 | Côté | 801374 |  |  |  | fortin | 1000000
 | 6 | Bouchard | 1010335 |  |  |  | Giggie | 500791
 | 7 | Bouchard | 253974 |  |  |  | fournier | 25
 | 8 | Lavoie | 525734 |  |  |  | fournier | 33
 | 9 | Fortin | 734255
 | 10 | Gagné | 785880
 | 11 | Ouellet | 500791
 | 12 | Ouellet | 758265 |  |  |  | E3 copied down >> =C3&D3
 | 13 | Ouellet | 430269 |  |  |  | F3 copied down >> =MATCH(E3,$J$3:$J$14,0)
 | 14 | Lévesque | 817979 |  |  |  | J3 copied down >> =H3&I3
 | 15 | Bergeron | 448165
 | 18 | Leblanc | 684921 |  |  |  | 14 est le nombre de ligne dans la liste du client
 | 20 | [NAME] | 658622
 | 21 | Caron | 338314 |  |  |  |  | step 1 | concatenate
 | 22 | Caron | 602202 |  |  |  |  | step 2 | run formula
 | 23 | Caron | 506600 |  |  |  |  | step 3 | sort by [NAME] With
 | 24 | Dubé | 140435
 | 25 | [NAME] | 268296
 | 26 | [NAME] | 462489
 | 27 | [NAME] | 422671
 | 29 | Lefebvre | 173398
 | 30 | Poulin | 260721
 | 31 | Thibault | 437105
 | 32 | St-Pierre | 91548
 | 33 | [NAME] | 477022
 | 34 | Martin | 297837
 | 35 | Landry | 461070
 | 36 | [NAME] | 537291
Spreadsheet: 856590d1705783408-average-formula-help-names_average
Sheet: Sheet1

 |  |  | Week #s
Name | Start week | Average | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
[NAME] | 2 |  | 7 | 9 | 9 | 7 | 8 | 2 | 0 | 5 | 1 | 0
Mark | 3 |  | 5 | 4 | 3 | 8 | 8 | 9 | 7 | 2 | 0 | 0
[NAME] | 4 |  | 6 | 7 | 7 | 4 | 7 | 7 | 2 | 7 | 5 | 0
[NAME] | 2 |  | 8 | 6 | 1 | 9 | 7 | 10 | 3 | 7 | 9 | 1
Barb | 5 |  | 2 | 2 | 10 | 1 | 8 | 6 | 6 | 2 | 1 | 7
[NAME] | 1 |  | 4 | 10 | 5 | 10 | 4 | 4 | 8 | 0 | 1 | 2
Greg | 1 |  | 10 | 10 | 1 | 8 | 7 | 6 | 3 | 8 | 0 | 1
[NAME] | 5 |  | 9 | 4 | 8 | 1 | 1 | 7 | 1 | 8 | 8 | 0
[NAME] | 2 |  | 9 | 4 | 4 | 3 | 6 | 7 | 1 | 10 | 9 | 5
[NAME] | 2 |  | 4 | 8 | 1 | 4 | 5 | 7 | 4 | 0 | 6 | 3
Spreadsheet: 779391d1651755500-dynamic-formula-duplicate-single-id-into-2-rows-but-split-account-and-amount-expenses
Sheet: 04.22

 |  |  |  |  |  |  |  |  |  |  | 2022-04-30 00:00:00
 |  |  |  |  |  |  |  |  |  |  | External id | ACCOUNT | DEBIT | CREDIT | DEPARTMENT | Vendor ID | MEMO | [NAME] | Currency
 | ILS
 |  |  |  |  |  |  | 30.04.22
 | Account | Vendor ID | Department | MEMO | Currency | Amount in ILS | Exchange rate | Amount in USD | JE
 | 610040.02 | 201370 | G&A : Accounting & Finance | Accrued  vendor A 04.22 | ILS | 52000 | 0.314861
 | 611000.32 | 2252883 | [NAME] : People | Accrued  vendor B 04.22 | ILS | 31000 | 0.301477 |  | yes
 | 616150 | 252001 | People | Accrued  vendor C 04.22 | ILS | 14850 | 0.301477 |  | yes
 | 611020 | 252907 | Engineering : Engineering. | Accrued  vendor D 04.22 | ILS |  | 0.301477 |  | yes
 | 610090.03 | 253159 |  | Accrued  vendor D 04.22 |  | 50000 | 0.301477
 | 616250 |  | G&A : Accounting & Finance | Accrued  vendor H 04.22 | ILS | 120000 | 0.301477
 | 607000.02 |  | People | Accrued  vendor I 04.22 |  |  | 0.301477
 | 612000.67 |  | G&A : Accounting & Finance | Accrued  vendor J 04.22 |  |  | 0.301477
 | 618350 | 2252922 | G&A : Accounting & Finance | Accrued  vendor K 04.22 | ILS | 5200 | 0.301477 |  | yes
 | 620100 | 251927 | G&A : Accounting & Finance | Accrued  vendor L 04.22 | ILS | 3400 | 0.301477 |  | yes
 | 611020 | 2252935 | Engineering : Engineering. | Accrued  vendor M 04.22 | ILS | 15000 | 0.301477 |  | yes
 | Total
 | USD
 | Account |  | Department | Details |  | Amount in ILS | Exchange rate | Amount in USD
 | 501300 | 201040 | [NAME] | Accrued  vendor N 04.22 | USD |  | 3.317 | 1430000 | yes
 | 501300 | 201040 | [NAME] | Accrued  vendor O 04.22 | USD |  | 3.238 | 318888.75
 | 610070 |  | G&A : Accounting & Finance | Accrued  vendor P 04.22 | USD |  | 3.317 |  | yes
 | 505200.01 | 253193 | [NAME] | Accrued  vendor Q 04.22 | USD |  | 3.317 | 170000 | yes
 | 612000.84 | 201250 | Engineering : Engineering. | Accrued  vendor R 04.22 | USD |  | 3.317 |  | yes
 | Total
Spreadsheet: 695464d1600227531-index-with-match-test
Sheet: Sheet2

 |  |  | Test1 | Test2 | Test3 | Test4 | Test5 | Test6 | [NAME] | Test8 | Test9
[NAME] |  |  | 8 | 0 | 25 | 0 | 55 | 92 | 13 | 55 | 56
[NAME] |  |  | 44 | 56 | 78 | 36 | 52 | 97 | 64 | 84 | 80
justin |  |  |  | 0 | 46 | 72 | 85 | 63 | 67 | 88 | 99
Spreadsheet: 716405d1612197081-sum-values-with-criteria-sample
Sheet: PAYDAY 30th July

Week: | Hours: | Pay: | Notes: |  |  | Break Down: |  |  |  |  |  |  | WEEKLY PAY: | DAILY PAY: | HOURLY:
BASIC: |  | 2000
ADDITION: |  |  |  |  |  | Natwest:
OTHER BONUS: |  |  |  |  |  | Entertainment:
 |  |  |  |  |  | Car:
[NAME]: |  | 0 |  |  |  | Loan:
 |  |  |  |  |  | Phone:
Est Tax: |  |  |  |  |  | Credit Improver:
Est NI: |  |  |  |  |  | Rent:
Total: |  |  |  |  |  | Credit Card:
 |  |  |  |  |  | Total:
Total Est Pay Before Tax:
Total Est Pay After Tax: |  |  |  |  |  | Monzo:
Actual Pay: |  | 1775.22 |  |  |  | Predicted: |  |  | Actual:
 |  |  |  |  |  | Amount L/O |  |  | Amount L/O
Deductions: |  |  |  |  |  | Days till next pay | 28 |  | Days till next pay | 28
Rent |  | 120 |  |  |  | Budget |  |  | Budget
Fuel |  | 160
Car Insurance |  | 181.68
Phone |  | 15
Loan |  | 130.08
ISA |  | 200
Credit Improver |  | 12
Credit Card
Other
Budget: |  | 290
 |  |  |  |  |  | NI Calculator:
Total:
 |  |  |  |  |  | PA: | 793.05
Total Est Left On 28th May: |  |  |  |  |  | BT - PA:
Total Acc Left On 28th May:
 |  |  |  |  |  | Total:
 |  |  |  |  |  | Tax Calculator:
 |  |  |  |  |  | PA: | 954.18
 |  |  |  |  |  | BT - PA:
 |  |  |  |  |  | Est Tax:
Spreadsheet: 99004d1297793555-filter-data-from-table-price-history-reading
Sheet: Sheet2

Item Code |  | Doc Date | Unit Price
B001 |  | 2001-01-03 00:00:00 | 1.1 | IV |  | L.Date1 | [NAME] | L.Date2 | L.S.P.2
B001 |  | 2001-01-04 00:00:00 | 1.2 | IV | C001
C001 |  | 2001-01-05 00:00:00 | 1.3 | IV | B001
B001 |  | 2001-01-06 00:00:00 | 1.4 | IV
c001 |  | 2001-01-07 00:00:00 | 1.5 | IV
B001 |  | 2001-01-08 00:00:00 | 1.6 | IV
B001 |  | 2001-01-09 00:00:00 | 1.7 | IV
Spreadsheet: 864591d1711701276-3-consecutive-vowels-categorise-3-cons-vowels-pull
Sheet: Sheet1

ARCHAEA | AEA
ALTHAEA | AEA
TAIAHAS | AIA
MANAIAS | AIA
WAIATAS | AIA
COBAEAS
BANDEAU
[NAME]
TABLEAU
BAUERAS
BATTEAU
BATEAUX
FABLIAU
CARDIAE
CADEAUX
FASCIAE
ARCHAEI
CHAPEAU
CHATEAU
COAEVAL
CAEOMAS
COAITAS
AOUDADS
KAIAKED
NAIADES
LEGUAAN
MANGEAO
GATEAUS
GATEAUX
ANTLIAE
SPIRAEA
APNOEAL
PLATEAU
MANTEAU
APNOEAS
KAWAIIS
ANTIAIR
MANOAOS
TATOUAY
BERCEAU
[NAME]
BIVOUAC
TABOOED
[NAME]
SEEABLE
BEAUFET
SUEABLE
BEAUTER
BEAUFIN
WOOABLE
BUREAUS
BUREAUX
BAGUIOS
ACCOIED
CAMEOED
CODEIAS
FAIENCE
OCHREAE
CORNEAE
GOUACHE
PAIOCKE
APNOEIC
PAEONIC
SCORIAE
MORCEAU
PONCEAU
CASEOUS
COTEAUS
COTEAUX
CARIOUS
VACUOUS
DEAIRED
RADIOED
QUAERED
FADEOUT
GEOIDAL
LIAISED
MIAULED
QUAILED
MIAOWED
RADIOES
APPUIED
NAPOOED
RONDEAU
DOUANES
ZOOIDAL
ARDUOUS
HERNIAE
HEAUMES
LEQUEAR
MARQUEE
PERAEON
QUAERES
RESEAUS
RESEAUX
LINGUAE
GLUTAEI
GASEOUS
HAVEOUR
ATHEOUS
LIAISES
LOIASES
[NAME]
TAKEOUT
NOTAEUM
RAMEOUS
[NAME]
TONNEAU
ZOUAVES
FATUOUS
SAGOUIN
HAVIOUR
LIAISON
LOIASIS
TAUIWIS
ROOIKAT
PRONAOI
SANIOUS
ANXIOUS
PAVIOUR
SOUARIS
SAVIOUR
[NAME]
MONOAOS
BEDOUIN
GOBIOID
DUBIOUS
BOUILLI
BILIOUS
[NAME]
[NAME]
ROOIBOS
OBVIOUS
RUBIOUS
COOEYED
RESCUEE
ECHOIER
QUIESCE
[NAME]
MECHOUI
MEIOTIC
[NAME]
[NAME]
VICIOUS
[NAME]
CORIOUS
CURIOUS
NOCUOUS
VIDEOED
RODEOED
QUEENED
QUEERED
UNFEUED
REOILED
MIMEOED
ENNUIED
QUIETED
RONEOED
FOLIOED
QUOIFED
HIKOIED
HIDEOUS
HIDEOUT
TENIOID
QUOINED
OSTEOID
QUOITED
TEDIOUS
DEVIOUS
WIDEOUT
UNWOOED
[NAME]
SIMIOID
OPIOIDS
VIDUOUS
EPEEIST
QUEERER
SQUEEZE
FOUETTE
SEMEION
MEIOSES
REQUIEM
PEREION
QUIETEN
QUIETER
[NAME]
UNQUEEN
OEUVRES
[NAME]
IGNEOUS
ROGUIER
VOGUIER
MILIEUS
MILIEUX
MEIOSIS
INQUIET
ROOINEK
[NAME]
ROUILLE
PILEOUS
PURLIEU
LIQUEUR
TIMEOUS
TIMEOUT
ENVIOUS
NIVEOUS
UNQUIET
PITEOUS
WIPEOUT
QUOITER
SERIOUS
QUIETUS
LUTEOUS
TENUOUS
OSSEOUS
FOLIOUS
FURIOUS
NIMIOUS
IMPIOUS
SIMIOUS
INVIOUS
[NAME]
OSMIOUS
[NAME]
SINUOUS
Spreadsheet: 875647d1722264104-add-leading-zeros-in-all-segments-leadzero
Sheet: Sheet1

 | Orig | Prefix | Number | Extract |  |  | Seg1 | Seg2 | Seg3 | Join | Cons
 | A1
 | A12
 | CM1
 | CM12
 | A1.1 |  |  |  | 1
 | A1.12 |  |  |  | 12
 | A1.C |  |  |  | C
 | A12.C |  |  |  | C
 | CM1.1 |  |  |  | 1
 | CM1.12 |  |  |  | 12
 | CM1.C |  |  |  | C
 | CM12.C |  |  |  | C
 | A1B
 | A12B
 | CM1B
 | CM12B
 | A1.1B |  |  |  | 1B
 | A12.1B |  |  |  | 1B
 | A1.12B |  |  |  | 12B
 | A12.12B |  |  |  | 12B
 | [NAME] |  |  |  | 1 | 1
 | A12.1.1 |  |  |  | 1 | 1
 | A12.12.1 |  |  |  | 12 | 1
 | A12.12.12 |  |  |  | 12 | 12
 | A12B.1.1 |  |  |  | 1 | 1
 | A12B.12.1 |  |  |  | 12 | 1
 | A12B.12.12C |  |  |  | 12 | 12C
 | A2A.2.1 |  |  |  | 2 | 1
 | A12C.F.F |  |  |  | F | F
Spreadsheet: phillip_allen__29923__Treaty Oaks Sales Sheet
Sheet: Sheet1

FOR SALE |  |  |  |  |  |  | THE SMITH COMPANY
 |  |  |  |  |  |  | REAL ESTATE SERVICES
[NAME] |  |  |  |  |  |  | 9400 Circle Drive
3700 Manchaca Road |  |  |  |  |  |  | [NAME],  Texas  78736
Austin, Texas 78704 |  |  |  |  |  |  | CONTACT:  JEFF SMITH
 |  |  |  |  |  |  | (512)394-0908
PRICE: |  |  |  |  |  |  | (512)394-0913 Fax
1700000
 |  |  |  |  | RATIOS:
PROPERTY INFORMATION: |  |  |  |  | Price\Unit:
Number of Units: |  | 48 |  |  | Price\S.F.:
Net Rentable Area: |  | 26662 |  |  | Rent\Sq. Ft.
Number of Stories: |  | 2 |  |  | Expenses\Unit: |  | 3000
Number of Buildings: |  | 4 |  |  | Expenses\Sq. Ft.
Land Area: |  | 62,291 s.f. |  |  | Gross Rent Multiplier:
Year Built: |  | 1980 |  |  | [NAME]:
Exterior: |  | Wood and brick
Roof: |  | Pitched Comp. Shingles |  |  | Proforma Income and Expenses:
HVAC: |  | Individual units |  |  | Gross Rental Income
Electricity: |  | Separately metered |  |  | Less V & C: (5.00%)
Gas: |  | Master - Laundry Only |  |  | Effective Gross Income
Hot Water: |  | Individual units |  |  | Other Income (1.00%)
Occupancy: |  | 0.98 |  |  | Total Income
Amenities: |  | Laundry Room |  |  | Less Operating Expenses:
 |  | Pool |  |  | Net Operating Income:
UNIT MIX AND PROFORMA RENT SCHEDULES
 |  | Unit | Total | Rent\ | Total | Rent\
Unit Type | # [NAME] | Sq. Ft. | Sq. Ft. | Month | Rent | Sq. Ft. |  |  |  |  | 12
1\1 | 47 | 546 |  | 600
2\2 | 1 | 850 |  | 775
Totals\Ave.
Comments: | Good location in South Austin near downtown, major roads and employers.
 | Improvements have been extensively renovated .
 | PLEASE DO NOT VISIT THE SITE WITHOUT AN APPOINTMENT,
 | OR COMMUNICATE WITH THE MANAGER OR TENANTS.
The information herein, while based upon information supplied by the owner and from other sources deemed reliable, is not in any way warranted by
The Smith Co. or the owner of the property and is presented prior to sale, change in price, or removal from the market without notice.  Interested
persons are encouraged to retain legal and technical consultants to advise them of any and all aspects of this property.  This information is provided
for your use as long as you have need of it, but at all times remains the property of The Smith Co.  Under no circumstances is any part of this
report to be reproduced, copied or in any way duplicated without the express written consent of The Smith Company.
Spreadsheet: daren_farmer__5878__CES-Tejas_0006
Sheet: Avails 6-1

[NAME] (PennzEnergy) South Texas Properties |  |  |  |  |  | Received : | 2000-05-25 00:00:00
Effective: | 2000-06-01 00:00:00
Pipeline | Location | [NAME] | Base | Swing | Total | WIO | Grand Total | Comments
Gulf Energy | [NAME] | 19-1043-00 | 324 | 28 |  | 0 |  | Termed up with Gulf Energy (evergreen)
 | Comitas South | 440-559 | 477 | 42 |  | 109
 | Tejas Plant | 29320 | 88 | 8 |  | 4
 | Jennings 63 Plant | 440-565 | 3789 | 330 |  | 0 |  | Termed up with Tejas thru 12/00
 | Haynes Plant | 440-557 | 346 | 30 |  | 0 |  | MTM - Terminate for 4/99
 | Haynes 17, 18 | 23-603-01 | 1607 | 140 |  | 231
 | [NAME] | 31-504-04 | 0 | 0 |  | 0
 | Garza Plant | 440-552 | 4318 | 376 |  | 311 |  | Trevino Plant gas is sometimes re-routed through Garza Plant
 | [NAME] | 21-022-08 | 0 | 70 |  | 0
Spreadsheet: 149363d1333880120-carry-rows-over-to-new-sheet-under-only-specific-circumstances-pointsheets
Sheet: Cust. Copy

No | [NAME] | QTY. | NOTES
1
Spreadsheet: 43205d1241782573-lookup-multiple-records-with-one-criteria-sample
Sheet: Sheet1

First | Last | Number |  | [NAME]
[NAME] | test1 | 6 |  | [NAME] | test1
[NAME] | test2 | 6 |  | [NAME] | test2
[NAME] | [NAME] | 1 |  | [NAME] | [NAME]
[NAME] | main | 2 |  | [NAME] | main
[NAME] | main | 3 |  | [NAME] | davey
pat | troy | 4
[NAME] | [NAME] | 5
[NAME] | davey | 6
Spreadsheet: 468394d1467276294-extract-data-from-columns-where-a-row-is-not-n-a-extract-data-from
Sheet: Raw DAta

Notes
This is the format the data is run
I want to extract the columns where Row 11 is NOT #N/A
Raw data does NOT have blue highlights, I just want to
 |  |  |  |  |  |  |  |  |  |  | A | AA | AAA | AAAA | AAAA | AAAAAA | AAAAAA | AAAAA | AAA | AAAAAA |  |  | AAA
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | B | #N/A | #N/A | #N/A | #N/A | #N/A | BB | BBB | BBBB | BBBBB | #N/A | #N/A | BBBBB | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  | CCC | CCC | CCC | CCC | CCC | CCC | CCC | CCC | CCC | CCC |  |  | CCC
 | Desired Outcome
Spreadsheet: 599522d1543160456-fill-rows-based-on-payment-type-jessica
Sheet: Entries

Date | Amount | Memo | Variable Expense | Fixed Expense | Income | Payee | Notes | Payment Type
2018-08-17 00:00:00 | 10.21 |  | Unexpected |  |  | Red Pocket Mobile | data for Jessica | Discover (J)
2018-08-23 00:00:00 | 10.21 |  | Unexpected |  |  | Red Pocket Mobile | data for Jessica | Discover (J)
2018-08-24 00:00:00 | 2.7 |  | Education |  |  | [NAME] |  | Discover (J)
2018-08-27 00:00:00 | 15.94 |  |  | [NAME] |  | [NAME] | recurring education expense to access work projects | Discover (J)
2018-09-09 00:00:00 | 53.15 |  | Education |  |  | Amazon | Delivering Health Care in America (Kindle) | American Express (J)
2018-09-09 00:00:00 | 85.71 |  | Education |  |  | Amazon | Delivering Health Care in America (Kindle) | American Express (J)
2018-09-06 00:00:00 | 45.16 |  | Fuel & Car Wash |  |  |  |  | Chase Visa (A)
2018-09-06 00:00:00 | 26.81 |  |  | Sling TV |  | Sling TV |  | Amazon Visa (B)
2018-09-06 00:00:00 | 11.86 |  | Groceries |  |  | Amazon | soup for Jessica | Amazon Visa (B)
Spreadsheet: darrell_schoolcraft__7252__saledoc02_12aTW
Sheet: Sheet1

Transwestern Pipeline Company
GAS [NAME]
 | GAS SALE INFORMATION |  |  |  |  | PURCHASE PARTY
Account Manager |  |  | [NAME] |  |  | Company: |  | Atra Power
Deal Date: |  |  | 2002-02-12 00:00:00 |  |  | Contact Name: |  | [NAME]
Gas Sale Date (s) |  |  | 2/12/2002 |  |  | FAX Number:
Total Quantity |  |  | 3936 | MMBtu |  | Address: |  | Phone: [PHONE]
Gas Sale Price |  |  | 2.24
GAS SALE TERMS
 |  | Contract Quantity (MMBtu)
SALE DATES |  |  |  | Daily
Start | End | Monthly |  | Min |  | [NAME] |  | Other
2/12/2002 | 02/12/02 | 3936 |  | 3936 |  | 3936
RELATED SCHEDULING AND TRANSPORTATION REQUIREMENTS
Tranwestern Receipt/Delivery Point |  |  |  |  |  |  | DOWNSTREAM |  | TW UPSTREAM
Name |  |  | POI # |  | Daily Volume |  | Contract # |  | Contract Number
WT Pool |  |  | 58646 |  | 3936 |  |  |  | 22948
 |  |  | BILLING BY THIRD PARTY |  |  |  |  | Please direct all invoices to:
 |  |  | Month [NAME] Rec'd |  | Expected [NAME] |  |  | Debbie Mosely
 |  |  |  |  | To be determined |  |  | Transwestern Pipeline Company
 |  |  |  |  |  |  |  | P.O. Box 1188
 |  |  |  |  |  |  |  | Houston, TX  77251-1188
Comments:
Buyer: Please acknlowledge confirmation of the above deal by signing below and faxing this confirmation to:
[NAME] [PHONE]   Phone [PHONE]
Gas Buyer Signature |  |  |  |  |  |  | Date:
TW Acct Manager Signature |  |  |  |  |  |  | Date: