tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 86343d1286349658-excel-2007-refering-to-a-formula-in-a-cell-example1
Sheet: Sheet1

Project Code: | NRPF74-425 | 2010-11-02 00:00:00 |  | STATUS
 |  |  |  | 13
 |  |  |  | AA
 |  |  |  | NR
 |  |  |  | ZEW
 |  |  |  | 47
*DATA: Project Codes | Date Due | SP Formula
SD19 SHIPPING | 2010-10-20 00:00:00 | IF(INDEX(E:E,ROW())=13,"YES","NO")
AD-HOC | 2010-10-21 00:00:00 | IF(INDEX(E:E,ROW())=27,"YES","NO")
ANA BATTERY | 2010-10-22 00:00:00 | IF(INDEX(E:E,ROW())=33,"YES","NO")
G2 SHIPPING | 2010-10-23 00:00:00 | IF(INDEX(E:E,ROW())=47,"YES","NO")
JS-D3-NDR24 | 2010-10-24 00:00:00 | IF(INDEX(E:E,ROW())="AA","YES","NO")
JS-D3-NDR241 | 2010-10-25 00:00:00 | IF(INDEX(E:E,ROW())="AC","YES","NO")
NET SET | 2010-10-26 00:00:00 | IF(INDEX(E:E,ROW())="AR","YES","NO")
MD-NDR241 | 2010-10-27 00:00:00 | IF(INDEX(E:E,[NAME]")
S14-W73-NDR241 | 2010-10-28 00:00:00 | IF(INDEX(E:E,ROW())="ST","YES","NO")
S12-W32-NDR24 | 2010-10-29 00:00:00 | IF(INDEX(E:E,[NAME]")
S12-W32-NDR241 | 2010-10-30 00:00:00 | IF(INDEX(E:E,[NAME]")
RENAMING PARTS | 2010-10-31 00:00:00 | IF(INDEX(E:E,ROW())="PRO","YES","NO")
FOLDING TABLE | 2010-11-01 00:00:00 | IF(INDEX(E:E,ROW())="SED","NA","")
NRPF74-425 | 2010-11-02 00:00:00 | IF(INDEX(E:E,ROW())="TED","NA","")
DEQ33-ER18 | 2010-11-03 00:00:00 | IF(INDEX(E:E,ROW())="TEF","NA","")
DEQ34-ER18 | 2010-11-04 00:00:00 | IF(INDEX(E:E,ROW())="ZEW","CANCEL","")
DEQ38-ER18 | 2010-11-05 00:00:00 | IF(INDEX(E:E,ROW())="ZSC","CANCEL","")
DEQ77-ER18 | 2010-11-06 00:00:00 | IF(INDEX(E:E,ROW())="ZTO","CANCEL","")
 |  | **Cell B1 is a drop down list
 |  | **Cell A2:A5 are supposed to use formula according to the selection of B1
Spreadsheet: 598594d1542620307-formula-used-in-weekly-reduction-of-work-hours-test-workbook-tms
Sheet: Total Burn Rate

Facility | Monthly | Current | Monthly | Billable OT | Non-Billable | Non-Billable | Facility | Monthly | Current | Monthly | Billable OT | Non-Billable | Non-Billable
 | Hours | Balance | Burn Rate | Hours | Hours | Overtime |  | Hours | Balance | Burn Rate | Hours | Hours | Overtime
Middle Florida Authorized |  |  |  |  |  |  | Southern Florida Authorized
Middle Florida Actual |  |  |  |  |  |  | Southern Florida Actual
Southern Florida Authorized |  |  |  |  |  |  | Southern Georgia Authorized
Southern Florida Actual |  |  |  |  |  |  | Southern Georgia Actual
Southern Alabama Authorized |  |  |  |  |  |  | Circuit Required |  |  |  | Billable OT | Total Non-Billables
Southern Alabama Actual |  |  |  |  |  |  | Circuit Actual
Middle Alabama Authorized |  |  |  |  |  |  | Circuit Burn Rate
Middle Alabama Actual
Northern Alabama Authorized
Northern Alabama Actual
Southern Georgia Authorized
Southern Georgia Actual
Middle Georgia Authorized
Middle Georgia Actual
Northern  Georgia Authorized
Northern Georgia Actual
Circuit Required |  |  |  | Billable OT | Total Non-Billables
Circuit Actual
Burn Rate
Spreadsheet: richard_ring__31597__EFS Negawatts from cogen & CSC
Sheet: Sheet1

I. Existing Contract: VAMC Cogen Project
1 | [NAME] facilities will be up and running by July 1, 2002
2 | This means: 16 months will remain to contract expiration: October 31, 2003
3 | Impaced facilities include those three VAMCs Hospitals currently receiving physical power behind BECO
 |  | e.g. Bedford, Jamaica Plain, and West Roxbury
4 | Annual BECO Consumption (kWh) & Account Number Pre Cogen Installation
 |  | Site: | Account Number | kWh
 |  | Bedford | 26575561001 | 11412548
 |  | Jamaica Plain | 26029951006 | 22896005
 |  | West Roxbury | 26045601007 | 17586469
5 | Annual BECO Consumption (kWh) Post Cogen Installation:*
 |  | Bedford |  | 737051
 |  | Jamaica Plain |  | 467265
 |  | West Roxbury |  | 366231
 |  | * VAMC Approved
6 | Annual [NAME] by EFS Cogen Project
 |  | (i.e. reduction in kWh)
7 | [NAME] generated through end of Contract: 16 months
8 | [NAME] Cost:
 |  | VA EES Contract Price: | 0.049
 |  | Discount: | [NAME] | [NAME]
 |  |  | 0.047 | 0.035
 |  | Negawatt Cost:
9 | Cogen Negawatt Revenue:
 | Negawatt Price: NEPOOL Forward Price: July 2002:
 |  | July-August 2002 NEPOOL Forward Price as of today: 10/10/01
 |  | Enron On Line: | [NAME] | $56/mWhr
 |  |  | On [NAME] | $40/mWhr
 |  |  | Blend: | $50/mWh
 |  | [NAME]: |  | $20/mWh
 |  | Retail Forward Price/mWh* |  | 70
 |  | *Assumes 65% load factor and secondary voltage
 |  | Negawatt Revenue in Futures Market
10 | EES Commodity Desk Benefit from EFS Cogen Negawatts
II. New Energy Conservation Project: To be closed December 2001
1 | Annual Negawatts Generated by Projects (kWh Saved from Proposed Projects)*
 |  | Bedford |  | 350370
 |  | Jamaica Plain |  | 269419
 |  | West Roxbury |  | 275716
 |  | Total kWh saved
 | * | VAMC Approved
2 | Projects installed and commissioned by September 2001
3 | Project Negawatts generated through end of contract: 12 months
4 | Project Negawatt Cost
 |  | VA EES Contract Price |  | 0.049
 |  | Discount |  | [NAME] | [NAME]
 |  |  |  | 0.047 | 0.035
 |  | Negawatt Cost:
5 | Project Negawatt Revenue:
 |  | Negawatt Revenue in Futures Mket |  | 0.07
6 | EES Commodity Desk Benefit form EFS Proposed Project
Spreadsheet: 798786d1664729078-excel-conditional-median-medianhomesample
Sheet: Sheet1

Subdivision | Address | SP | Value | Closing Date | Year Built | Size | NewCon
Woodland Drives | 1221 Clark Avenue | 470000 | 221.7 | 2022-04-02 00:00:00 | 1972 | 2120 | No
Woodland Drives | 1128 Hemlock Street | 332000 | 262.66 | 2022-04-05 00:00:00 | 1970 | 1264 | No
Woodland Drives | 1117 Myers Park Dr Drive | 1100000 | 235.04 | 2022-04-06 00:00:00 | 2022 | 4680 | Yes
Woodland Drives | 1230 Circle Dr | 309000 | 212.22 | 2022-04-20 00:00:00 | 1959 | 1456 | No
Woodland Drives | 1230 Hemlock Street | 240000 | 144.14 | 2022-04-23 00:00:00 | 1970 | 1665 | No
Woodland Drives | 1239 Camellia Dr | 386000 | 169.74 | 2022-04-30 00:00:00 | 1960 | 2274 | No
Woodland Drives | 1126 S Magnolia Dr | 298000 | 165.18 | 2022-05-01 00:00:00 | 1955 | 1804 | No
Woodland Drives | 1237 Sarasota Drive | 316000 | 255.46 | 2022-05-06 00:00:00 | 1953 | 1237 | No
Woodland Drives | 1828 [NAME] | 310000 | 136.08 | 2022-05-10 00:00:00 | 1951 | 2278 | No
Woodland Drives | 1216 Hemlock Street | 495000 | 258.76 | 2022-05-10 00:00:00 | 2022 | 1913 | Yes
Woodland Drives | 1105 Sarasota Dr Drive | 395000 | 195.06 | 2022-05-21 00:00:00 | 1957 | 2025 | No
Woodland Drives | 1212 [NAME] | 384000 | 260.86 | 2022-05-26 00:00:00 | 1955 | 1472 | No
Woodland Drives | 1210 [NAME] | 416000 | 247.62 | 2022-05-29 00:00:00 | 1979 | 1680 | No
Woodland Drives | 2051 Country Club Drive | 442000 | 205.78 | 2022-05-29 00:00:00 | 1954 | 2148 | No
Woodland Drives | 1051 [NAME] | 420000 | 220.58 | 2022-06-07 00:00:00 | 1950 | 1904 | No
Woodland Drives | 1514 S Magnolia Dr | 260000 | 174.96 | 2022-06-11 00:00:00 | 1953 | 1486 | No
Woodland Drives | 1142 Old Fort Drive | 372000 | 237.86 | 2022-06-14 00:00:00 | 1951 | 1564 | No
Woodland Drives | 1177 Old Fort Road | 530000 | 218.82 | 2022-06-29 00:00:00 | 1948 | 2422 | No
Woodland Drives | 1102 Sarasota Drive | 515000 | 171.5 | 2022-06-30 00:00:00 | 2022 | 3003 | Yes
 |  | SP | Value | Size
Median Home | 2022-04-01 00:00:00
 | 2022-05-01 00:00:00
 | 2022-06-01 00:00:00
[NAME] Used (VALID) | =MEDIAN(IF(DATE(YEAR(Closing_Date),MONTH(Closing_Date),1)=$B23,SP))
 |  | SP | Value | Size
Median Existing Home | 2022-04-01 00:00:00
 | 2022-05-01 00:00:00
 | 2022-06-01 00:00:00
[NAME] Used (INVALID) | =MEDIAN(IF(NewCon="No",1)*IF(DATE(YEAR(Closing_Date),MONTH(Closing_Date),1)=$B29,SP))
Spreadsheet: 845954d1697238776-split-alphanumeric-data-into-individual-cells-excel-2010-transpose-letter-or-numbers
Sheet: Sheet1

[NAME] The 2nd
Spreadsheet: 114983d1310639150-copy-several-rows-of-cells-into-one-cell-book1_excelhelp-1-
Sheet: Sheet1

Data looks like:
List of items | Date |  | List of items | Date
1234 | 2001-09-12 00:00:00 |  | 1234
234 | 2003-02-23 00:00:00 |  | 234
98745 | 2004-03-25 00:00:00 |  | 98745
39284 | 2011-07-15 00:00:00 |  | 39284
9 | 2003-02-23 00:00:00 |  | 9
938 | 2004-03-25 00:00:00 |  | 938
89752 | 2011-07-15 00:00:00 |  | 89752
I want it to be transferred into
List of items | Date
1234 234 98745 39284 9 938 89752 | 12/09/2001 23/02/2003 25/03/2004 15/07/2011 23/02/2004 25/03/2004 15/07/2011
Spreadsheet: 156584d1337352612-excel-2007-identifying-duplicates-and-adding-a-value-in-to-a-column-identifying-duplicate-data
Sheet: Sheet1

Number | Data 1 | Data 2 | Duplicate Indicator
123 | United States | 14
124 | Argentina | 27
125 | Brazil | 33
123 | Setup | 14 | *
123A | Germany | 33
Spreadsheet: e5dbe648-a4ce-4bda-9705-a2f0908d6c87
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7126 | 47874 | Sean | [NAME] | GBR | 4 | 00:14:03 | 00:01:46 | 00:33:57 | 00:00:58 | [NAME] | 1 | 01:12:21
7126 | 30797 | [NAME] | [NAME] | GBR | 2 | 00:17:07 | 00:02:05 | 00:33:17 | 00:01:12 | 00:18:44 | 2 | 01:12:22
7126 | 47882 | [NAME] | Garner | GBR | 1 | [NAME] | 00:02:20 | 00:46:32 | 00:01:13 | [NAME] | 3 | [NAME]
Spreadsheet: 086bc2f1-84be-4849-b7f6-f2a754a4c7b0
Sheet: Sheet1

FAI Shop | Unnamed: 1 | Payment and Shipments Instructions on next page. | Unnamed: 3 | Unnamed: 4
Order Form |  |  | LAST NAME :
 |  |  | First Name :
 |  |  | e-mail :
Articles available | Note | Quantity | Prices | TOTAL
 |  |  | CHF | CHF
CIVL Proficiency Badges (pins) - Set of 10 [NAME] pins |  |  | 60 | 0
CIVL Proficiency Badges (pins) - Set of 10 Silver pins |  |  | 60 | 0
CIVL Proficiency Badges (pins) - Set of 10 Gold pins |  |  | 60 | 0
CIVL Proficiency Badge Diamond (pin) - Per piece |  |  | 18.5 | 0
CIVL Proficiency Patches - Set of 10 [NAME] patches | *** |  | 60 | 0
CIVL Proficiency Patches - Set of 10 Silver patches | *** |  | 60 | 0
CIVL Proficiency Patches - Set of 10 Gold patches | *** |  | 60 | 0
TOTAL to be paid (+ shipment costs not included) |  |  |  | 0
 |  | *** Embroidered patches to be sewn/ironed on shirts
Payment and Shipments Instructions on next page !
Spreadsheet: phillip_allen__28908__version 12_17
Sheet: Project Schedule

 | Work Days | 2000-12-01 00:00:00 | 2001-01-01 00:00:00 | 2001-02-01 00:00:00 | 2001-03-01 00:00:00 | 2001-04-01 00:00:00 | 2001-05-01 00:00:00 | 2001-06-01 00:00:00 | 2001-07-01 00:00:00 | 2001-08-01 00:00:00 | 2001-09-01 00:00:00 | 2001-10-01 00:00:00 | 2001-11-01 00:00:00 | 2001-12-01 00:00:00 | 2002-01-01 00:00:00 | 2002-02-01 00:00:00 | 2002-03-01 00:00:00 | 2002-04-01 00:00:00 | 2002-05-01 00:00:00 | 2002-06-01 00:00:00 | 2002-07-01 00:00:00 | 2002-08-01 00:00:00 | 2002-09-01 00:00:00 | 2002-10-01 00:00:00 | 2002-11-01 00:00:00 | 2002-12-01 00:00:00 | 2003-01-01 00:00:00 | 2003-02-01 00:00:00 | 2003-03-01 00:00:00 | 2003-04-01 00:00:00 | 2003-05-01 00:00:00 | 2003-06-01 00:00:00
 |  | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
Loan Approval | 10 | X
Document Prep | 10 | X | X
Closing Loan/Land | 1 |  | X
Survey |  |  | x
Re-Plat 2nd Parcel |  |  | x | x
Utility Design |  |  | x | x | x
City Submission |  |  |  |  | x
City Approval |  |  |  |  | x | x
Lot Improvements |  |  |  |  |  | x | x
Foundations | 3 wks/Phase, 4 Bldgs/Phase |  |  |  |  |  | Phase 1/2 | Phase 2/3 | Phase 3/4 | Phase 5/6 | Phase 6/7 | Phase 7/8
Unit Construction - 33 Bldgs
Phase 1 - 4 Bldgs + Mgr Office |  | Man Days
Phase 2 - 4 Bldgs |  | Man Days
Phase 3 - 4 Bldgs |  | Man Days
Phase 4 - 4 Bldgs |  | Man Days
Phase 5 - 4 Bldgs |  | Man Days
Phase 6 - 4 Bldgs |  | Man Days
Phase 7 - 4 Bldgs |  | Man Days |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
Phase 8 - 4 Bldgs |  | Man Days |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
Pre-Leasing
Phase 1 | 17 | Units |  |  |  |  |  |  |  |  |  |  |  |  | 17
Phase 2 | 17 | Units |  |  |  |  |  |  |  |  |  |  |  |  | 17
Phase 3 | 17 | Units |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17
Phase 4 | 17 | Units |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17
Phase 5 | 17 | Units |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17
Phase 6 | 16 | Units |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17
Phase 7 | 16 | Units |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17
Phase 8 | 16 | Units |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17
 |  | Units
Rent Stabilization
Appraisal for Permanent
Close On Permanent
Spreadsheet: 50410d1249850988-organizing-organizing
Sheet: Sheet1

Name | Genger |  |  |  | Female | Male
[NAME] | M |  |  |  | mary | [NAME]
mary | F |  |  |  | [NAME] | [NAME]
[NAME] | M |  |  |  | #N/A | Fred
Fred | M |  |  |  | #N/A | Nick
Nick | M |  |  |  | #N/A | #N/A
[NAME] | F |  |  |  | #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
Spreadsheet: 889725d1740645726-repeat-formula-but-of-different-range-size-and-return-as-dynamic-array-repeat-formula-and-return-as-array
Sheet: Sheet1

 | Original Data
 |  | Region | Type | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00
 |  | North | A | 19 | 9 | 20 | 9 | 6
 |  | North | B | 5 | 1 | 2 | 17 | 13
 |  | North | C | 20 | 10 | 11 | 17 | 14
 |  | South | A | 12 | 5 | 4 | 13 | 17
 |  | South | B | 12 | 20 | 4 | 9 | 14
 |  | South | C | 19 | 11 | 13 | 9 | 13
 | [NAME] |  | Type | -4 | -3 | -2 | -1 | 0
 |  |  | A | 0.05 | 0.05 | 0.1 | 0.1 | 0.05
 |  |  | B | 0.15 | 0.1 | 0.1 | 0.1 | 0.15
 |  |  | C | 0.15 | 0.1 | 0.2 | 0.05 | 0.1
 | Desired Result in dynamic array
 |  | Region | Type | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 |  | Version 2: |  |  |  |  |  | Version 1:
 |  | North | A |  |  |  |  |  |  |  | 3.65 | 2.5 | 1.05 | 0.3 |  |  | 3.65 | 2.5 | 1.05 | 0.3
 |  | North | B |  |  |  |  |  |  | 4.7 | 3.350000000000001 | 3.3 | 3.85 | 1.95 |  | 4.7 | 3.350000000000001 | 3.3 | 3.85 | 1.95
 |  | North | C |  |  |  |  |  |  | 8.5 | 6.350000000000001 | 4.75 | 2.4 | 1.4 |  | 8.5 | 6.350000000000001 | 4.75 | 2.4 | 1.4
 |  | South | A |  |  |  |  |  |  | 3 | 2.8 | 3.2 | 2.35 | 0.8500000000000001 |  | 3 | 2.8 | 3.2 | 2.35 | 0.8500000000000001
 |  | South | B |  |  |  |  |  |  | 7.200000000000001 | 5.7 | 2.9 | 2.75 | 2.1 |  | 7.200000000000001 | 5.7 | 2.9 | 2.75 | 2.1
 |  | South | C |  |  |  |  |  |  | 7.900000000000001 | 4.85 | 4.35 | 1.55 | 1.3 |  | 7.900000000000001 | 4.85 | 4.35 | 1.55 | 1.3
 |  |  |  |  |  |  |  |  |  |  | True | True | True | True |  |  | True | True | True | True
 |  |  |  |  |  |  |  |  |  | True | True | True | True | True |  | True | True | True | True | True
 |  |  |  |  |  |  |  |  |  | True | True | True | True | True |  | True | True | True | True | True
 |  |  |  |  |  |  |  |  |  | True | True | True | True | True |  | True | True | True | True | True
 |  |  |  |  |  |  |  |  |  | True | True | True | True | True |  | True | True | True | True | True
 |  |  |  |  |  |  |  |  |  | True | True | True | True | True |  | True | True | True | True | True
Spreadsheet: 232305d1367381338-toggling-between-datasets-compare-players-example
Sheet: Compare Players

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012/13 | Total Stats
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011/12 | Per Game
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010/11 | Player Rating
 |  |  |  |  |  |  |  |  | Season: | 2012/13 |  |  |  |  |  |  |  |  |  |  |  |  |  | Season: | 2012/13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009/10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  | Data Type: | Total Stats |  |  |  |  |  |  |  |  |  |  |  |  |  | Data Type: | Per Game |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Last 3
 |  |  |  |  | Yahoo! | Salary
Ref # | Player | Position | Team | Status | Page | 2012-13 | PR/G | PR | GP | G | A | PTS | +/- | PIM | Hits | BLKS | PPG | PPA | GWG | SOG | SO% | PR/G | PR | GP | G | A | PTS | +/- | PIM | Hits | BLKS | PPG | PPA | GWG | SOG | SO%
1 | [NAME] | C | PIT | MUST | Y!
5 | [NAME] | LW | PIT | SVB | Y!
20 | Pavel Datsyuk | C | DET | CCV | Y!
6 | [NAME] | LW/RW | WAS | MUST | Y!
3 | [NAME] | RW | TAM | HIT | Y!
2 | [NAME] | C | TAM | FF | Y!
12 | [NAME] | C | CHI | LEO | Y!
9 | [NAME] | C | NYI | LEO | Y!
7 | [NAME] | C | ANA | SVB | Y!
Spreadsheet: 879808d1727364864-choosecols-function-to-incorporate-manual-column-no-value-sheet1
Sheet: Expected Result

Lookup 1 | [NAME] |  | to be arrange alphabetically |  | this col.to be added in formula
Sun | Sheet1
Day | Application No | Code | Solar System | Exam | Base | Fee | Charge
Sun | AP-1 | 65363 | Venus | 1991.05.04 | MS | 2063 | 25
Sun | DJ-986 |  | Venus | 2099.65.30 | MS | 320
Sun | AS-5 | 6316 | Earth | 1010.03.02 | MS | 1500 | 6
Sun | LST-3 | 9843 | Mars | 1011.04.02 | MS | 500 | 65
Grand Total
Spreadsheet: 705833d1606323391-return-the-value-of-cell-based-from-2-criterias-sample-1
Sheet: Admin Scale

L/G | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25
1 | 3000 | 3230 | 3460 | 3690 | 3920 | 4150 | 4380 | 4610 | 4840 | 5070 | 5300 | 5530 | 5760 | 5990 | 6220 | 6450 | 6680 | 6910 | 7140 | 7370 | 7600 | 7830 | 8060 | 8290 | 8520
2 | 3300 | 3565 | 3830 | 4095 | 4360 | 4625 | 4890 | 5155 | 5420 | 5685 | 5950 | 6215 | 6480 | 6745 | 7010 | 7275 | 7540 | 7805 | 8070 | 8335 | 8600 | 8865 | 9130 | 9395 | 9660
3 | 3500 | 3800 | 4100 | 4400 | 4700 | 5000 | 5300 | 5600 | 5900 | 6200 | 6500 | 6800 | 7100 | 7400 | 7700 | 8000 | 8300 | 8600 | 8900 | 9200 | 9500 | 9800 | 10100 | 10400 | 10700
4 | 4000 | 4335 | 4670 | 5005 | 5340 | 5675 | 6010 | 6345 | 6680 | 7015 | 7350 | 7685 | 8020 | 8355 | 8690 | 9025 | 9360 | 9695 | 10030 | 10365 | 10700 | 11035 | 11370 | 11705 | 12040
5 | 4500 | 4870 | 5240 | 5610 | 5980 | 6350 | 6720 | 7090 | 7460 | 7830 | 8200 | 8570 | 8940 | 9310 | 9680 | 10050 | 10420 | 10790 | 11160 | 11530 | 11900 | 12270 | 12640 | 13010 | 13380
6 | 5700 | 6105 | 6510 | 6915 | 7320 | 7725 | 8130 | 8535 | 8940 | 9345 | 9750 | 10155 | 10560 | 10965 | 11370 | 11775 | 12180 | 12585 | 12990 | 13395 | 13800 | 14205 | 14610 | 15015 | 15420
7 | 6700 | 7140 | 7580 | 8020 | 8460 | 8900 | 9340 | 9780 | 10220 | 10660 | 11100 | 11540 | 11980 | 12420 | 12860 | 13300 | 13740 | 14180 | 14620 | 15060 | 15500 | 15940 | 16380 | 16820 | 17260
8 | 8200 | 8675 | 9150 | 9625 | 10100 | 10575 | 11050 | 11525 | 12000 | 12475 | 12950 | 13425 | 13900 | 14375 | 14850 | 15325 | 15800 | 16275 | 16750 | 17225 | 17700 | 18175 | 18650 | 19125 | 19600
9 | 10500 | 11010 | 11520 | 12030 | 12540 | 13050 | 13560 | 14070 | 14580 | 15090 | 15600 | 16110 | 16620 | 17130 | 17640 | 18150 | 18660 | 19170 | 19680 | 20190 | 20700 | 21210 | 21720 | 22230 | 22740
10 | 13500 | 14040 | 14580 | 15120 | 15660 | 16200 | 16740 | 17280 | 17820 | 18360 | 18900 | 19440 | 19980 | 20520 | 21060 | 21600 | 22140 | 22680 | 23220 | 23760 | 24300 | 24840 | 25380 | 25920 | 26460
11 | 18000 | 18575 | 19150 | 19725 | 20300 | 20875 | 21450 | 22025 | 2260 | 23175 | 23750 | 24325 | 24900 | 25475 | 26050 | 26625 | 27200 | 27775 | 28350 | 28925 | 29500 | 30075 | 30650 | 31225 | 31800
Spreadsheet: 0c9edd7f-0960-49d7-b0ca-42ecfae4322b
Sheet: Industrial Formatted for Print

Address | Street | Type | Suite | [NAME] | Rent | Overhead | Broker | Phone | Notes
2119 | Delaware Avenue | [NAME] |  | 10800 | 0.8 | NNN | [NAME] | [PHONE]
320 | Encinal Street | [NAME] |  | 7594 | 1.15 | NNN | [NAME] | [PHONE] | Dock high access.
115 | Harvey West Boulevard | [NAME] |  | 4200 | 1 | Gross | [NAME] | [PHONE]
511 | Swift Street | [NAME] |  | 1425 | 1800 | NNN | [NAME] | [PHONE] | artworkspacesantacruz.com
831 | Almar Avenue | Industrial |  | 44825 | 1 | NNN | [NAME] or [NAME] | [PHONE] | Good Earth Tea Building
125 | McPherson Street | Industrial |  | 10500 | 1.25 | NNN | [NAME] | [PHONE]
2801 | Mission Street | Industrial |  | 805 | 1 | Full Service | [NAME] | [PHONE] | University Business Park / Wrigley Building
2801 | Mission Street | Industrial |  | 1610 | 0.95 | Full Service | [NAME] | [PHONE] | University Business Park / Wrigley Building
2801 | Mission Street | Industrial |  | 2185 | 0.9 | Full Service | [NAME] | [PHONE] | University Business Park / Wrigley Building
2801 | Mission Street | Industrial |  | 4370 | 0.9 | Full Service | [NAME] | [PHONE] | University Business Park / Wrigley Building Divisible to 2,185 square feet
2801 | Mission Street | Industrial |  | 6555 | 0.9 | Full Service | [NAME] | [PHONE] | University Business Park / Wrigley Building Divisible to 2,185 square feet
1319 | River Street | Industrial |  | 1500 | 1.25 | Gross | [NAME] | [PHONE] | Onsite parking
1321 | River Street | Industrial |  | 1500 | 1.25 | Gross | [NAME] | [PHONE] | Onsite parking
1323 | River Street | Industrial |  | 1500 | 1.25 | Gross | [NAME] | [PHONE] | Onsite parking
820 | Swift Street | Industrial |  | 4000 | 0.9 |  | [NAME] or [NAME] | [PHONE] | 1,600 square foot warehouse with an 800 square foot office/mezzanine.
375 | Coral Street | Warehouse |  | 1112 | 0.95 | NNN | [NAME] | [PHONE] | Warehouse with rollup doors. 400+ square foot mezzanine
397 | Coral Street | Warehouse | B | 775 | Negotiable | NNN | [NAME] | [PHONE] | Storage space.
150 | DuBois Street | Warehouse | D | 1700 | 1800 |  | [NAME] | [PHONE] | Warehouse with 200 sqft mezzanine office and bathroom. Rent includes water, sewer, garbage, PG&E.
151 | Harvey West Boulevard | Warehouse |  | 14000 | 1 | NNN | [NAME] or [NAME] | [PHONE]
298 | Harvey West Boulevard | Warehouse |  | 10700 | 0.95 | NNN | [NAME] | [PHONE] | 17 foot clear height w/dock high door. Owner to provide improvements: skylights, RR core, sprinklers, lighting &/or electrical, rollup doors & more.
2521 | Mission Street | Warehouse |  | 7912 | 5625 |  | [NAME] | [PHONE]
2931 | Mission Street | Warehouse |  | 9000 | Negotiable |  | [NAME] | [PHONE] | Divisible to 1,800.Negotiable rent. [NAME]; inc. 1,200 sf office
1201 | [NAME] | Warehouse |  | 4099 | 0.8 | NNN | [NAME] | [PHONE] | [NAME] for layout and interior photos