tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 414636d1440069522-hire-date-and-annual-raise-labor-formula_bc
Sheet: Labor

LABOR
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016-01-01 00:00:00
NAME | TITLE | HIRE DATE | ALLOC | [NAME] | 2016-03-31 00:00:00 | 2016-06-30 00:00:00 | 2016-09-30 00:00:00 | 2016-12-31 00:00:00 | 2017-03-31 00:00:00 | 2017-06-30 00:00:00 | 2017-09-30 00:00:00 | 2017-12-31 00:00:00 | 2018-12-31 00:00:00 | 2019-12-31 00:00:00 | 2020-12-31 00:00:00 | 2021-12-31 00:00:00 | 2022-12-31 00:00:00 |  | Update dates for quarter and year end as needed
RESEARCH & DEV
Smith | Example 1 | 2016-06-01 00:00:00 | 1 | 100000
Smith | Example 1 | 2016-06-01 00:00:00 | 1 | 100000
 |  |  |  | TOTAL COMP:
 |  |  |  | TOTAL COMP:
 |  |  |  | TOTAL BURDENED LABOR :
Assumptions:
- Burdened labor rate |  | 0.3 | (includes workers comp, PTO, payroll taxes, health benefits)
- Annual raise (inflation) |  | 0.02
Spreadsheet: 211437d1359745213-1-1-million-data-points-that-need-to-be-sorted-ef347_split_data
Sheet: Sheet1

First_Name | Last_Name | Zip | State
first_1 | last_1 | zip_1 | ST_1
first_2 | last_2 | [NAME] | ST_2
first_3 | last_3 | zip_3 | ST_3
first_4 | [NAME] | zip_4 | ST_4
first_5 | last_5 | zip_5 | ST_5
first_6 | last_6 | zip_6 | ST_6
first_7 | last_7 | zip_7 | ST_7
first_8 | last_8 | zip_8 | ST_8
first_9 | last_9 | zip_9 | ST_9
first_10 | last_10 | zip_10 | ST_10
first_11 | last_11 | zip_11 | ST_11
first_12 | last_12 | [NAME] | ST_12
[NAME] | last_13 | zip_13 | ST_13
first_14 | last_14 | zip_14 | ST_14
first_15 | last_15 | zip_15 | [NAME]
first_16 | last_16 | zip_16 | ST_16
first_17 | last_17 | zip_17 | ST_17
Spreadsheet: 726056d1617030791-convert-data-from-skills-matrix-into-analyzable-data-model-by-employees-skills-in-rows-sample-original-data-and-desired-result
Sheet: Original data

Team | Employee | Background | Country | Hardware A | Hardware B | Hardware C | Hardware D | Hardware E | Hardware F | Software A | Software B
X | employee 1 | Art | Germany | [NAME] | ggg | EXPERT | EXPERT | EXPERT | EXPERT | EXPERT | EXPERT
Y | employee 2 | Science | France | ADVANCED | ADVANCED | EXPERT | EXPERT | EXPERT | EXPERT | ADVANCED | ADVANCED
Z | employee 3 | Enginieer | Belgium | ADVANCED | ADVANCED | EXPERT | EXPERT | EXPERT | EXPERT | ADVANCED | ADVANCED
Spreadsheet: 583963d1532852076-how-to-exclude-weekends-in-employee-absence-tracker-count-copy-of-holiday-and-absence-planning-1-
Sheet: Sept

 | Employee Holiday & Absence Scheduling
E  m  p  l  o  y  e  e | Absence Type Key |  | X | Vacation |  |  | T | Official Travel |  |  |  | S | Sick |  |  | M | Maternity |  |  | p | Parental |  |  |  | C | Compensation |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Public Holiday |  |  |  | Holiday
 | September | 2018 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Days
 | Employee Name | 2018-09-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Vacation | Official Travel | Sick | Maternity | Parental | Compensation
 |  | 2019-01-01 00:00:00
 | Employee 1
 | Employee 2
 | Employee 3
 | Employee 4
 | Employee 5
 | Employee 6
 | Employee 7
 | Employee 8
 | Employee 9
 | Employee 10
 | Employee 11
 | Employee 12
 | Employee 13 |  | x | x | x | x | x | x | x | x | x | x | x | x
 | Employee 14
 | Employee 15
 | Employee 16
 | Employee 17
 | Employee 18
 | Employee 19
 | Employee 20
 | Employee 21
 | Employee 22
 | Employee 23 | m | m | m | m | m | m | m | m | m | m | m | m | m | m | m | m | m | m | m | m | m | m | m | m | m | m | m | m | m | m | m
 | Employee 24
 | Employee 25
 | Employee 26
 | Employee 27
 | Employee 28
Spreadsheet: 273073d1382606887-vlookup-within-a-5-minute-timeframe-question-example
Sheet: AFTER

Table B
Ref | Time | Table A
1 | 13:41:00 | x
2 | 14:43:00 | x
3 | 15:55:00
4 | 17:12:00
5 | 17:42:00 | x
6 | 18:00:00
7 | 19:29:00
8 | 20:41:00 | x
9 | 21:39:00 | x
10 | 22:35:00 | x
Spreadsheet: 183237d1348756748-summary-will-not-pull-all-of-the-data-i-need-exceltest-1-
Sheet: Sheet1

Make/Model | TYPE | System | Position | CODE |  |  |  |  |  |  | Make/Model | TYPE | System | Position | CODE
Sony | Blue | 1 | Low | AAB
Sony | Blue | 1 | Low | AAB
Sony | Blue | 2 | Low | AAB
Dell | Blue | 5 | Medium | BAC
Dell | Blue | 5 | Medium | BAC
Dell | Blue | 5 | Medium | BAC
Dell | Orange | 5 | Medium | BAC
Dell | Orange | 2 | Medium | BAC
Dell | Orange | 2 | Medium | AAD
Dell | Orange | 2 | High | AAD
Spreadsheet: 61146d1261917669-list-validation-based-on-another-list-list-test
Sheet: Summary

 |  |  |  |  |  |  |  | Level1 | Level2
 | Fruits | Apples |  | Fruits |  |  | Test 1 | Fruits
 |  | Mangoes |  | Animals |  |  | Test 2
 |  | Bananas |  | Flowers |  |  | Test 3
 | Animals | Elephant
 |  | Lion
 |  | Tiger
 | Flowers | Rose
 |  | Lilly
Spreadsheet: 702735d1604505539-link-to-goto-cell-in-another-sheet-based-on-matching-cell-values-links_new
Sheet: Total

Cust | Name | TOTAL | 1 - 30 | 31 - 60 | 61 - 90 | OVER 90 | Enter Notes here
13337 | [NAME] | 412.91 | 5.91 | 0 | 0 | 407
13475 | ABC Store | 108 | 0 | 108 | 0 | 0
13688 | Discount Store | 429 | 5.39 | 28.5 | 18.11 | 377
Spreadsheet: 594704d1539905485-maths-query-working-out-how-the-individual-variable-contributes-to-the-overall-loss-stephenp12-book1-copy
Sheet: Sheet1

 |  | 2018-01-01 00:00:00 | Item to Vary: | Gross Received | Deduction | Yield | Deduction | Selling Costs |  |  | 2018-09-01 00:00:00 |  |  | [NAME]
 | Gross Received | 3691716 |  | 3448800 | 3691716 | 3691716 | 3691716 | 3691716 |  |  | 3448800
 | Deduction | 0.25 |  | 0.25 | 0.2772748782185108 | 0.25 | 0.25 | 0.25 |  |  | 0.2772748782185108
 | Net Received
 | Yield | 0.0355 |  | 0.0355 | 0.0355 | 0.036 | 0.0355 | 0.0355 |  |  | 0.036
 | Deduction | 2076590.25 |  | 2076590.25 | 2076590.25 | 2076590.25 | 1869400.8 | 2076590.25 |  |  | 1869400.8
 | Selling Costs | 0.063 |  | 0.063 | 0.063 | 0.063 | 0.063 | 0.068 |  |  | 0.068
 | Price
 |  |  | [NAME]
Spreadsheet: 491000d1480248911-how-can-i-get-country-name-based-on-city-names-in-the-columns-country-name-based-on-city
Sheet: CityLookup

city | country
Newyork | USA
Washington | USA
Los Angeles | USA
Tokyo | Japan
Mumbai | India
Toronto | Canada
Karachi | Pakistan
London | England
Sidney | Australia
Berlin | Germany
Bejing | China
Spreadsheet: 91770d1291419752-autopopulate-table-sample-syllabus
Sheet: Sheet1

Syllabus A
Week | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
Routine 1 | 4 | 4 | 3 | 1 | 1
Routine 2 |  | 1 | 1 |  | 1 | 1 | 2 |  | 2 | 2 | 2 | 2
Routine 3 |  |  | 2 | 4 | 1 | 1 |  | 1 | 1
Routine 4 |  |  |  |  | 3 | 4 | 4 | 5 | 4 | 3 | 3 | 3
Start | 2011-02-11 00:00:00 | (Select date)
Group 1 | 2011-01-07 00:00:00
Routine 1 |  |  |  |  |  | 4 | 4 | 3 | 1 | 1
Routine 2 |  |  |  |  |  |  | 1 | 1 |  | 1 | 1 | 2 |  | 2 | 2 | 2 | 2
Routine 3 |  |  |  |  |  |  |  | 2 | 4 | 1 | 1 |  | 1 | 1
Routine 4 |  |  |  |  |  |  |  |  |  | 3 | 4 | 4 | 5 | 4 | 3 | 3 | 3
Problem:
Syllabus A consists of a various number of units from 4 different routines. If the start date is selected in cell B14, how can the table in rows 16 - 19 be automatically populated with the units from the Syllabus table starting from the date selected?
Spreadsheet: 104752d1302210481-conditional-formatting-date-ranges-audit-master-station-listing
Sheet: 767

IATA | ICAO | Airport | City | Country | Date of Last Audit | Auditor
BAH | OBBI | Bahrain Intl. | [NAME] | Bahrain
CIA | LIRA | Rome Clampino Airport | Rome | Italy
DXB | OMDB | Dubai International Airport | Dubai | UAE
GUA | MGGT | La Aurora International Airport | Guatemala City | Guatemala
KDH | OAKN | Kandahar Airport | Kandahar | Afganistan
KHI | OPKC | [NAME]. (Quaid-e Azam Intl) | Karachi | Pakistan
LEJ | EDDP | Leipzig/Halle Airport | Leipzig | Germany
LHE | OPLA | Allama Iqbal Intl. | Lahore | Pakistan
MIA | KMIA | Miami Intl. | Miami, FL | USA
OSL | ENGM | Oslo Airport | Ullensaker | Norway
PTY | MPTO | Tocumen Intl. | Panama City | Panama
SJO | MROC | Juan Santamaria Intl. | San Jose | Costa Rica
SKT | OPST | Sialkot Intl. | Sialkot | Pakistan
 | OAIX | Bagram AB | [NAME] | Afganistan
 | OAZI | Camp Bastion Airfield | [NAME] | Afganistan
Spreadsheet: 72375d1273058915-skipping-blank-cells-with-if-function-fpl
Sheet: Fixtures

 | FIXTURES
 |  |  | Score
 | Warrick |  |  | vs |  |  | [NAME]
 | Warrick |  |  | vs |  |  | [NAME]
 | Warrick |  |  | vs |  |  | [NAME]
 | Warrick |  |  | vs |  |  | Mark
 | Warrick |  |  | vs |  |  | [NAME]
 | Warrick |  |  | vs |  |  | [NAME]
 | [NAME] |  |  | vs |  |  | Warrick
 | [NAME] |  |  | vs |  |  | [NAME]
 | [NAME] |  |  | vs |  |  | [NAME]
 | [NAME] |  |  | vs |  |  | Mark
 | [NAME] |  |  | vs |  |  | [NAME]
 | [NAME] |  |  | vs |  |  | [NAME]
 | [NAME] |  |  | vs |  |  | Warrick
 | [NAME] |  |  | vs |  |  | [NAME]
 | [NAME] |  |  | vs |  |  | [NAME]
 | [NAME] |  |  | vs |  |  | Mark
 | [NAME] |  |  | vs |  |  | [NAME]
 | [NAME] |  |  | vs |  |  | [NAME]
 | [NAME] |  |  | vs |  |  | Warrick
 | [NAME] |  |  | vs |  |  | [NAME]
 | [NAME] |  |  | vs |  |  | [NAME]
 | [NAME] |  |  | vs |  |  | Mark
 | [NAME] |  |  | vs |  |  | [NAME]
 | [NAME] |  |  | vs |  |  | [NAME]
 | Mark |  |  | vs |  |  | Warrick
 | Mark |  |  | vs |  |  | [NAME]
 | Mark |  |  | vs |  |  | [NAME]
 | Mark |  |  | vs |  |  | [NAME]
 | Mark |  |  | vs |  |  | [NAME]
 | Mark |  |  | vs |  |  | [NAME]
 | [NAME] |  |  | vs |  |  | Warrick
 | [NAME] |  |  | vs |  |  | [NAME]
 | [NAME] |  |  | vs |  |  | [NAME]
 | [NAME] |  |  | vs |  |  | [NAME]
 | [NAME] |  |  | vs |  |  | Mark
 | [NAME] |  |  | vs |  |  | [NAME]
 | [NAME] |  |  | vs |  |  | Warrick
 | [NAME] |  |  | vs |  |  | [NAME]
 | [NAME] |  |  | vs |  |  | [NAME]
 | [NAME] |  |  | vs |  |  | [NAME]
 | [NAME] |  |  | vs |  |  | Mark
 | [NAME] |  |  | vs |  |  | [NAME]
Spreadsheet: 701153d1603566133-using-powerquery-to-import-data-from-a-website-to-an-excel-spreadsheet-finvizpquery-problem
Sheet: Sheet1

Path |  |  | Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10 | Column11 | Column12
V |  |  | Index | DJIA S&P500 | P/E | 37.65 | EPS (ttm) | 5.26 | Insider Own | 0.002 | Shs Outstand | 1.98B | Perf Week | -1.12%
 |  |  | Market [NAME] | 419.84B | Forward P/E | 34.08 | EPS next Y | 5.81 | Insider Trans | -0.0622 | [NAME] | 1.42B | Perf Month | 1.27%
 |  |  | Income | 11.33B | PEG | 4.37 | EPS next Q | 1.09 | Inst Own | 0.964 | Short Float | 1.81% | Perf Quarter | 0.56%
 |  |  | Sales | 22.88B | P/S | 18.35 | EPS this Y | 20.00% | Inst Trans | 0.0003 | Short Ratio | 3.36 | Perf Half Y | 15.28%
 |  |  | Book/sh | 15.27 | P/B | 12.97 | EPS next Y | 15.94% | ROA | 0.152 | Target Price | 224.84 | Perf Year | 12.40%
 |  |  | Cash/sh | 7.85 | P/C | 25.24 | EPS next 5Y | 8.61% | ROE | 0.383 | 52W Range | 133.93 - 217.35 | Perf YTD | 5.38%
 |  |  | Dividend | 1.20 | P/FCF | 46.63 | EPS past 5Y | 19.80% | ROI | 0.265 | 52W High | -8.90% | Beta | 0.88
 |  |  | Dividend % | 0.61% | [NAME] | 1.60 | Sales past 5Y | 12.60% | Gross Margin | 0.805 | 52W Low | 47.85% | ATR | 3.96
 |  |  | Employees | 19500 | Current Ratio | 1.60 | Sales Q/Q | -17.20% | Oper. Margin | 0.641 | RSI (14) | 42.28 | Volatility | 1.83% 1.75%
 |  |  | Optionable | Yes | Debt/Eq | 0.69 | EPS Q/Q | -21.70% | Profit Margin | 0.495 | Rel Volume | 0.77 | Prev Close | 197.99
 |  |  | Shortable | Yes | LT Debt/Eq | 0.59 | Earnings | Oct 28 AMC | Payout | 0.203 | [NAME] | 7.66M | Price | 198.01
 |  |  | Recom | 1.90 | SMA20 | -1.53% | SMA50 | -2.45% | SMA200 | 0.0354 | Volume | 5,866,993 | Change | 0.01%
Spreadsheet: 156235d1337238226-look-up-and-select-test
Sheet: Sheet1

 |  | Total |  |  |  |  | SH | LH
 |  | Shades
Direction | Nil | In | Out |  |  |  |  |  |  | [NAME] 10am | [NAME]
Sth |  |  |  |  |  | [NAME]
SE |  |  |  |  |  | [NAME]
E |  |  |  |  |  | [NAME]
NE |  | 14.9 |  |  |  | [NAME]
N |  |  |  |  |  | [NAME]
NW |  |  |  |  |  | [NAME]
W |  |  |  |  |  | [NAME]
SW |  | 9.1 |  |  |  | [NAME]
Horizontal |  |  |  |  |  | [NAME]
Spreadsheet: 83933d1283964785-conditional-look-up-or-if-statement-active-cc-1
Sheet: Sheet2

 | Bills | Groceries | Gas | Miscellaneous | Big Purchase
2010-09-01 00:00:00
2010-10-01 00:00:00
2010-11-01 00:00:00
2010-12-01 00:00:00
2011-01-01 00:00:00
2011-02-01 00:00:00
2011-03-01 00:00:00
2011-04-01 00:00:00
2011-05-01 00:00:00
2011-06-01 00:00:00
2011-07-01 00:00:00
2011-08-01 00:00:00
2011-09-01 00:00:00
Spreadsheet: 62046d1262947394-vlookup-test
Sheet: PGM

 | Copy to Team Leader at the end of business
 |  |  | DATE: | 2010-01-08 10:44:00
 | RCL | PD T/O | PT T/O | RH T/O | RU T/O | IR T/O
 | Investor Deal Reference | 0 | 0 | 0 | 0 | 0
6 | 0
 | #N/A
8 | #N/A
 | #N/A
10
15
Spreadsheet: 22617d1211639981-grouping-data-filters-over-multiple-worksheets-cabs
Sheet: EasiPlan

Period: | 1 | To be used as a guide only
EasiPlan S/Rate (%) - | 5
Name: | EP Units | 0.04 | 0.05 | 0.06 | 0.07 | 8%+
Person 01 | 1 | 4 | 5 | 6 | 7 | 8
Person 02 | 2 | 8 | 10 | 12 | 14 | 16
Person 03 | 3 | 12 | 15 | 18 | 21 | 24
Person 04 | 4 | 16 | 20 | 24 | 28 | 32
Person 05 | 5 | 20 | 25 | 30 | 35 | 40
Person 06 | 6 | 24 | 30 | 36 | 42 | 48
Spreadsheet: louise_kitchen__23121__North America Nov 14
Sheet: SPECIALREPORT -1

TRADE DATE | NA GAS | NA POWER | US EAST GAS | US CENTRAL GAS | US WEST GAS | US NYMEX GAS | US TEXAS GAS | US EAST POWER | US CENTRAL POWER | US WEST POWER | CAN EAST GAS | CAN WEST GAS | CAN POWER | TOTAL TRADE CNT
2001-11-14 00:00:00 | 2588 | 872 | 627 | 438 | 440 | 873 | 44 | 447 | 3 | 404 | 12 | 154 | 18 | 5254
2001-11-13 00:00:00 | 2330 | 933 | 532 | 527 | 509 | 578 | 74 | 436 | 5 | 484 | 12 | 98 | 8 | 4817
2001-11-12 00:00:00 | 2631 | 833 | 670 | 586 | 479 | 745 | 54 | 711 | 3 | 111 | 28 | 69 | 8 | 4785
2001-11-11 00:00:00 | 29 | 10 | 0 | 0 | 0 | 29 | 0 | 10 | 0 | 0 | 0 | 0 | 0 | 41
2001-11-10 00:00:00 | 14 | 17 | 0 | 0 | 0 | 14 | 0 | 17 | 0 | 0 | 0 | 0 | 0 | 31
2001-11-09 00:00:00 | 1839 | 784 | 469 | 356 | 329 | 540 | 29 | 467 | 1 | 303 | 32 | 84 | 13 | 3662
2001-11-08 00:00:00 | 2387 | 941 | 525 | 199 | 399 | 1051 | 55 | 714 | 1 | 210 | 15 | 143 | 16 | 4395
2001-11-07 00:00:00 | 3575 | 1592 | 786 | 688 | 800 | 992 | 51 | 933 | 7 | 641 | 65 | 193 | 11 | 6162
2001-11-06 00:00:00 | 3825 | 1581 | 955 | 837 | 695 | 983 | 74 | 1005 | 5 | 563 | 61 | 220 | 8 | 6318
2001-11-05 00:00:00 | 4034 | 1605 | 981 | 806 | 714 | 1119 | 79 | 883 | 8 | 703 | 48 | 287 | 11 | 6542
2001-11-04 00:00:00 | 30 | 10 | 0 | 0 | 0 | 30 | 0 | 10 | 0 | 0 | 0 | 0 | 0 | 41
2001-11-03 00:00:00 | 27 | 32 | 0 | 0 | 0 | 27 | 0 | 32 | 0 | 0 | 0 | 0 | 0 | 59
2001-11-02 00:00:00 | 3790 | 1205 | 994 | 867 | 787 | 748 | 81 | 681 | 6 | 502 | 45 | 268 | 16 | 5858
2001-11-01 00:00:00 | 4031 | 1498 | 1002 | 858 | 697 | 1066 | 90 | 983 | 11 | 495 | 58 | 260 | 9 | 6605
Spreadsheet: 220710d1363244293-adding-rows-automatically-in-two-separate-worksheets-examplev17
Sheet: Full Balance Sheet

BALANCE SHEET
 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017
Total non-current assets
Total current assets
Total assets
Total non-current liab.
Total Current liab.
Total Liabilities
Total Equity
Total Equity & Liabilities
Spreadsheet: darron_c_giron__7943__trans summary 012302
Sheet: TRANSACTIONSUMMARYREPORT -1

EnronOnline
 | Transaction Summary Report
Transaction ID | Transaction Time | Counterparty Name | Commodity Group | Product Type | Product ID | Product Name | Buy Volume | Sell Volume | Units | Price | External User ID | Trader ID | Risk Book | Bridge | Enron Entity | Deal ID | Global Counterparty ID | Begin Date | End Date
235 | 2002-01-23 16:24:57 | Dynegy Marketing and Trade | Natural Gas | US Gas Fin Swap | 44734 | US Gas Swap      IF TCO Pool             Feb02           USD/MM | 10000 |  | MMBtu | 0.25 | [NAME] | ARING | FB-EAST3 | TAGG/ ERMS | Enron North America Corp. | AAA172.1 | 61981 | 2002-02-01 20:59:33 | 2002-02-28 20:59:33
236 | 2002-01-23 16:25:17 | Dynegy Marketing and Trade | Power | US East Power Fin Swap | 30173 | US Pwr Fin Swap  PJM W IntC Peak         Apr02           USD/MWh | 50 |  | MWh | 44.25 | [NAME] | KPRESTO |  | Enpower US | Enron North America Corp. |  | 61981 | 2002-04-01 00:00:00 | 2002-04-30 00:00:00
237 | 2002-01-23 16:25:29 | Dynegy Marketing and Trade | Power | US East Power Fin Swap | 30609 | US Pwr Fin Swap  PJM W IntC Peak         25Jan02         USD/MWh | 50 |  | MWh | 23.65 | [NAME] | KPRESTO |  | Enpower US | Enron North America Corp. |  | 61981 | 2002-01-25 20:59:33 | 2002-01-25 20:59:33
238 | 2002-01-23 16:26:14 | Dynegy Marketing and Trade | Natural Gas | US Gas Fin Swap | 44734 | US Gas Swap      IF TCO Pool             Feb02           USD/MM | 10000 |  | MMBtu | 3 | [NAME] | ARING | FB-EAST3 | TAGG/ ERMS | Enron North America Corp. | AAA173.1 | 61981 | 2002-02-01 20:59:33 | 2002-02-28 20:59:33
Spreadsheet: 37349d1235332767-variable-decimal-format-example24
Sheet: Sheet1

 | cells formated as:-
 | text | 123.12000 | [PHONE] | 1.257730000 | 1.234 | 1.45
 | general | 20 | 20 | 20 | 20 | 20
 | % | 0.027 | 0.027 | 0.027 | 0.027 | 0.027
 | general | 123.12005 | [PHONE] | 1.257784000 | 1.234 | 1.45
Spreadsheet: 0073be2f-5a4b-4306-8f7d-b0a62ef7c37c
Sheet: Res 3 Blank

Washington Park Reservoir Improvements Project - Options Discussion Evaluation Framework - Preliminary September 2013
Rating Scale
Superior: | S | The option has significant benefits over other options for this goal
Acceptable: | A | The option meets the goal
Inferior: | I | The option is significantly less responsive to this goal than other options
Neutral: | N | No difference between options
 | Reservoir No. 3
Goals and Objectives | Water Over the Divide | In the Ravine | Landscape Terraces | Cascade
Be Good Stewards of Public Funds
• Ensure costs provide the greatest community benefit
• Prudently spend public money & limit impact on ratepayers
[NAME] maintenance and operating costs low
Respect Historic Resources
• Minimize impacts to historic structures and features
• Maintain historic character of the site
[NAME] the historic function of the reservoirs in the context of the overall Portland water system
• Retain the sites reflective & tranquil character that is now created & heightened by the visual connection to an expansive water.
Be a Good Neighbor
• Reduce use of neighborhood parking by park visitors
• Avoid attraction of nuisance & illegal activities into the park & neighborhoods
• Enhance the quality of the park as an amenity for neighbors & visitors
• Minimize construction impacts
Enhance Park Experience
• Provide public access & opportunities for low-intensity recreation
• Retain the sites reflective & tranquil character that is now created & heightened by the visual connection to an expansive water.
• Enhance views into and from the area
• Provide people with ability to connect with nature in the city
• Maintain security of the park and water facilities
• Ensure the new visible features enhance current park uses and are compatible with future park uses
Support Sustainability
• Create sustainable landscapes that provide habitat for birds and other native wildlife
• Minimize climate change impacts due to construction, operations and maintenance.
• Promote wise use of our water resources through design, maintenance and education.
Spreadsheet: 26d33ede-6dd1-424a-beb3-39463c74ea3e
Sheet: Capital

CAPITAL PROJECT |  |  |  |  |  |  | 120524
Ordinance Fiscal Note |  |  |  |  | REVISED |  | Ordinance Number
Ordinance Title (in Brief)
 | Project No. 89003453 - NE 68th St and N Belmont Sanitary Sewer Ext.
Is this ordinance for the following: |  |  |  |  | New Construction
 |  |  |  | X | Replacement
 |  |  |  |  | Repair
Was this project programmed in the Five-Year Capital Improvement Plan? |  |  |  |  |  |  | X | No |  |  | Yes
 | If yes, please identify year in which this project was funded.
 | If no, please detail the reasons why this project was not included and need for present funding request.
 | PIAC-funded project
Does this project leverage non-city funds for design/construction? |  |  |  |  |  |  | X | No |  |  | Yes
 | If yes, please identify source and amount.
 | Source of Funds:
 | Year Funded:
 | Amount of Non-City Funds: |  |  | $
 | If no, please identify source and amount of city funds.
 | Acct #: |  |  |  | 13-3090-808108-B-611060-89003453
 | Name of Fund: |  |  |  | Water & Sewer NC1
 | Year Funded: |  |  |  | FY13
 | Amount of City Funds: |  |  | $ | 136000
If ordinance is for new construction or replacement of asset please provide the following information:
 | Total estimated costs (design through construction): |  |  | $
 | Estimated lifespan of project in years |  |  | $
 | Estimated annual operating and maintenance costs |  |  | $
 | (Please detail type of maintenance or operating costs needed, additional staffing, capital maintenance costs, utilities, etc.)
Are these O&M costs reflected in the current budget? |  |  |  |  |  |  | x | No |  |  | Yes
 | If yes, please please provide source of funds.
 | If no, please identify year in which additional operating and maintenance costs will be needed. |  |  |  |  |  |  |  |  |  | FY13
Reference Numbers: (Previously approved legislation): |  |  |  |  | 100017 |  |  | 951492
Reviewed by:
 |  |  |  |  |  | OMB Approval Date
Spreadsheet: 99813d1298386961-col-d-average-col-c-for-all-rows-where-col-b-is-the-same-dummy
Sheet: Sheet1

Tech | Territory | Sales | [NAME]
[NAME] | Miami | 23434
[NAME] | Miami | 44356
[NAME] | Atlanta | 32552
[NAME] | Atlanta | 67889
[NAME] | Orlando | 108776
[NAME] | Orlando | 57733
Sue | Memphis | 32456
[NAME] | Memphis | 87956
[NAME] | Dallas | 34532
[NAME] | Dallas | 98643
Shari | Charlotte | 25677
[NAME] | Charlotte | 45254
[NAME] | Charlotte | 89545
Spreadsheet: 139060d1328050729-countif-and-if-mixed-nested-formula-help-buyer-source-statistics-test
Sheet: Stats

Overall Stats |  |  | Suburb Stats | [NAME]
IWC |  |  | IWC | =COUNTIF(=COUNTIF('Source Info'!B:B,Stats!E1),"IWC")
Internet Total |  |  | Internet Total
Domain |  |  | Domain
REA |  |  | REA |  |  |  |  | =SUMPRODUCT(('Source Info'!B:B=E1)*('Source Info'!C:C))
Other/Unknown |  |  | Other/Unknown |  |  |  |  | =SUMPRODUCT(--('Source Info'!$B:$B='Stats'!E1),--('Source Info'!$C:$C<>""))
Signboard |  |  | Signboard
Magazine |  |  | Magazine
Agent Referral |  |  | Agent Referral
Word of mouth |  |  | Word of mouth
Other |  |  | Other
Spreadsheet: 848014d1698831242-finding-latest-publication-date-that-conatins-data-finding_max_publication_date-aligw
Sheet: Sheet1

 |  |  |  |  |  |  | Value | Date
 |  |  |  |  |  |  |  | 01.10.2023 |  |  | Answer should be |  | 2023-09-01 00:00:00
 |  |  |  |  |  |  | 30.810961 | 01.09.2023
 |  |  |  |  |  |  | 30.469743 | 01.08.2023
 |  |  |  |  |  |  | 30.890926 | 01.07.2023
 |  |  |  |  |  |  | 29.939593 | 01.06.2023
 |  |  |  |  |  |  | 28.761806 | 01.05.2023
 |  |  |  |  |  |  | 28.764684 | 01.04.2023
 |  |  |  |  |  |  | 27.953041 | 01.03.2023
 |  |  |  |  |  |  | 28.919763 | 01.02.2023
 |  |  |  |  |  |  | 28.334813 | 01.01.2023
 |  |  |  |  |  |  | 28.316901 | 01.12.2022
 |  |  |  |  |  |  | 28.378949 | 01.11.2022
 |  |  |  |  |  |  | 27.080767 | 01.10.2022