tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 8dc7eed3-3f1b-409e-8d99-93e4faedf5c5
Sheet: Sheet1

Nurse Leader Eligibility Documentation
Note:  Before beginning to enter data, create one line for each unit to be entered.  If additional lines are needed for a Unit Type, right click on a row number within that unit type and select "Insert".  Enter one unit per line.
Unit Type | Units | Name (Last, First) | Highest Nursing Degree | Job Title
Medical
Surgical
Med-Surg
Oncology
Step Down
Critical Care
Labor & Delivery
Ante/Post Partum
NICU
Pediatrics
PICU
Operating Room(s)
PACU
Amb. Procedure
Psych.
Rehab.
Ambulatory
Emergency Department
Specialty Practice
Acuity Adaptable
All Others
Spreadsheet: 22590d1211556848-increment-cell-values-in-excel-book2
Sheet: Sheet2

Cell | Regular Labor Hrs | Over time | Setup Hrs
s30 | 8 | 2 | 2
s35 | 8 | 2 | 2
s40 | 8 | 2 | 2
s50 | 8 | 2 | 2
s80 | 8 | 2 | 2
s30 | 8 | 2 | 2
s35 | 8 | 2 | 2
s40 | 8 | 2 | 2
s50 | 8 | 2 | 2
s80 | 8 | 2 | 2
s30 | 8 | 2 | 2
s35 | 8 | 2 | 2
s40 | 8 | 2 | 2
s50 | 8 | 2 | 2
s80 | 8 | 2 | 2
s30 | 8 | 2 | 2
s35 | 8 | 2 | 2
s40 | 8 | 2 | 2
s50 | 8 | 2 | 2
s80 | 8 | 2 | 2
s30 | 8 | 2 | 2
s35 | 8 | 2 | 2
s40 | 8 | 2 | 2
s50 | 8 | 2 | 2
s80 | 8 | 2 | 2
Spreadsheet: 885686d1735497928-generate-two-columns-based-on-a-branching-map-of-values-columns-worksheet-4-
Sheet: Sheet2

 |  |  |  |  |  |  |  |  | data
 |  |  |  | data
 |  |  |  | data
 |  |  |  |  | data |  |  |  | data
 |  |  |  |  | data
 |  |  |  |  |  |  | data |  | data
 |  |  |  |  |  |  |  | data
 |  |  |  |  |  |  |  | data
 |  |  |  |  |  |  |  | data
 |  |  |  |  | 0 | 0 | 0 | 0 | data
 |  |  |  | data | 0 | 0 | 0 | 0 | 0
 |  |  |  | data | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | data | 0 | 0 | 0 | data
 |  |  |  | 0 | data | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | data | 0 | data
 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | data | 0
 |  |  |  | 0 | 0 | 0 | 0 | data | 0
 |  |  |  | 0 | 0 | 0 | 0 | data | 0
Spreadsheet: 55888d1256051919-repeating-a-calculation-with-different-values-in-the-same-cell-example-workbook
Sheet: AUTO Peaks

 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Integrated Response
1
2
3
4
5
6
7
8
9
10
Spreadsheet: 63834d1264700610-running-total-test
Sheet: Sheet1

 | 2008-12-01 00:00:00 | Debit 1st CB | Debit | 1st CB | [NAME] | NB12345 | Doe, [NAME] | 7.918 | 3 | 9.47209 |  |  | 0
 | 2009-01-01 00:00:00 | Debit 1st CB | Debit | 1st CB | [NAME] | NB12345 | Doe, [NAME] | 137.275 | 347 | 63.1943 | 10 | 8 | 94.1176470588235
 | 2009-02-01 00:00:00 | Debit 1st CB | Debit | 1st CB | [NAME] | NB12345 | Doe, [NAME] | 123.286 | 450 | 91.2512 | 10 | 9 | 105.882352941176
 | 2009-03-01 00:00:00 | Debit 1st CB | Debit | 1st CB | [NAME] | NB12345 | Doe, [NAME] | 132.555 | 484 | 91.2829 | 10 | 9 | 105.882352941176
 | 2009-04-01 00:00:00 | Debit 1st CB | Debit | 1st CB | [NAME] | NB12345 | Doe, [NAME] | 141.629 | 580 | 83.3919 | 10 | 7 | 82.3529411764706
 | 2009-05-01 00:00:00 | Debit 1st CB | Debit | 1st CB | [NAME] | NB12345 | Doe, [NAME] | 132.759 | 500 | 94.1556 | 10 | 8.5 | 100
 | 2009-06-01 00:00:00 | Debit 1st CB | Debit | 1st CB | [NAME] | NB12345 | Doe, [NAME] | 134.141 | 472 | 87.9671 | 10 | 9 | 105.882352941176
 | 2009-07-01 00:00:00 | Debit 1st CB | Debit | 1st CB | [NAME] | NB12345 | Doe, [NAME] | 131.235 | 515 | 98.1065 | 10 | 9 | 105.882352941176
 | 2009-08-01 00:00:00 | Debit 1st CB | Debit | 1st CB | [NAME] | NB12345 | Doe, [NAME] | 130.434 | 517 | 99.0923 | 8 | 8 | 117.647058823529
 | 2009-09-01 00:00:00 | Debit 1st CB | Debit | 1st CB | [NAME] | NB12345 | Doe, [NAME] | 144.318 | 608 | 105.323 | 8 | 7.2 | 105.882352941176
 | 2009-10-01 00:00:00 | Debit 1st CB | Debit | 1st CB | [NAME] | NB12345 | Doe, [NAME] | 110.004 | 490 | 111.36 | 8 | 7.2 | 105.882352941176 |  |  | Correct
 | 2009-11-01 00:00:00 | Debit 1st CB | Debit | 1st CB | [NAME] | NB12345 | Doe, [NAME] | 132.455 | 509 | 96.0704 | 10 | 10 | 117.647058823529 |  |  | 3
 | 2009-12-01 00:00:00 | Debit 1st CB | Debit | 1st CB | [NAME] | NB12345 | Doe, [NAME] | 124.08 | 516 | 103.965 | 10 | 10 | 117.647058823529 |  |  | 3
 | 2010-01-01 00:00:00 | Debit 1st CB | Debit | 1st CB | [NAME] | NB12345 | Doe, [NAME] | 124.08 | 516 | 103.965 | 10 | 10 | 117.647058823529 |  |  | 2
 | 2010-02-01 00:00:00 | Debit 1st CB | Debit | 1st CB | [NAME] | NB12345 | Doe, [NAME] | 124.08 | 516 | 103.965 | 10 | 10 | 117.647058823529 |  |  | 2
 | 2010-03-01 00:00:00 | Debit 1st CB | Debit | 1st CB | [NAME] | NB12345 | Doe, [NAME] | 124.08 | 516 | 103.965 | 10 | 10 | 117.647058823529 |  |  | 2
 | 2010-04-01 00:00:00 | Debit 1st CB | Debit | 1st CB | [NAME] | NB12345 | Doe, [NAME] | 124.08 | 516 | 103.965 | 10 | 10 | 117.647058823529 |  |  | 1
 | 2010-05-01 00:00:00 | Debit 1st CB | Debit | 1st CB | [NAME] | NB12345 | Doe, [NAME] | 124.08 | 516 | 103.965 | 10 | 10 | 117.647058823529 |  |  | 1
Spreadsheet: kate_symes__18139__Deal Correction 2-6
Sheet:  Prior Day

Adjustment date | Date of applied calc | Deal Date | Desk | Reason | Correction located by: | Broker | Change | Details of reason | Deal # | Delivery | Term | Hours p/op/rtc | MW | Price | Counterparty
2001-02-05 00:00:00 | 2001-02-05 00:00:00 | 2001-02-02 00:00:00 | STSW | TA | Houston | APB | Added late deal; backdated to 2/2/01 |  | 514006 | Palo Verde | H-01 | On [NAME] | 25 | 217.5 | BP
2001-02-05 00:00:00 | 2001-02-05 00:00:00 | 2001-02-02 00:00:00 | STSW | TA | Houston | Bloomberg | Broker fee: from 0 to .005 |  | 512827 | NP-15 | Q2-01 | On [NAME] | 25 | 260 | Merrill
 |  |  | TA Count
2001-02-05 00:00:00 | 2001-02-05 00:00:00 | 2001-02-02 00:00:00 | STCA | CM | Houston | Prebon | Price: from 160 to 165 |  | 512609 | SP-15 | H-01 | [NAME] | 25 | 165 | Reliant
 |  |  | CM Count
2001-02-05 00:00:00 | 2001-02-05 00:00:00 | 2001-02-02 00:00:00 | STCA | JR | Houston | Bloomberg | Broker fee: from 0 to .005 |  | 512927 | NP-15 | Q2-01 | On [NAME] | 25 | 250 | Merrill
 |  |  | JR Count
2001-02-05 00:00:00 | 2001-02-05 00:00:00 | 2001-02-05 00:00:00 | LTSW/LTNW | Houston IT | N/A | ED&F Man | Added futures contract from 1/31 | New futures commodity: IT still working on application; adding correct settlement index for interdesk swap |  | Mid-C | J-01 | On [NAME] | 25 | 375 | N/A
 |  |  | Houston IT Count
 |  |  | Grand Count
Spreadsheet: 770263d1645965473-error-when-using-if-function-function
Sheet: Sheet1

 |  |  | function compares data from two cells of a  row  to data from two cells one row below
 |  | correct desired result | my incorrect function
 |  |  | IF(A11=A10,"R",""&IF(A11=B10,"X",""))
1 | 2 |  |  | correct
3 | 1 | X |  | correct | 3 | 1 | X
1 | 3 |  |  | correct | 1 | 3
2 | 1 |  |  | correct
1 | 2 |  |  | SHOULD BE BLANK | 2 | 1 | X
1 | 1 |  |  | correct | 1 | 2
2 | 1 | X |  | correct
1 | 2 | R |  | correct | 1 | 2 | Repeat
1 | 2 | R |  | SHOULD BE BLANK | 1 | 2
1 | 1 |  |  | correct
0 | 2 |  |  | correct
1 | 2 |  |  | SHOULD BE BLANK
2 | 3 |  |  | correct
1 | 3 |  |  | correct
1 | 4 |  |  | correct
3 | 2 |  |  | correct
1 | 1 |  |  | SHOULD BE BLANK
1 | 2 | R |  | correct
1 | 2 |  |  | SHOULD BE BLANK
2 | 2 | R |  | correct
2 | 2 |  |  | SHOULD BE BLANK
2 | 3 | R |  | correct
2 | 3 | X |  | correct
3 | 2 |  |  | correct
4 | 2 |  |  | correct
1 | 2 |  |  | correct
0 | 2
Spreadsheet: 226681d1365477935-selecting-a-table-based-on-drop-down-list-condition-specification_database
Sheet: Sheet4

SITE A | SITE ID | HUB001
 | Site NAME | [NAME]
 | LATITUDE | 09 26 21.46 S
 | LONGITUDE | 159 57 02.70 E
 | ELEVATION | 67 m ASL
SITE B | Site ID | HUB002
 | Site NAME | LEITONGO
 | LATITUDE | 09 00 43.80 S
 | LONGITUDE | 160 03 50.90 E
 | ELEVATION | 236 m ASL
 | PATH LENGTH | 48.86km
VENDOR  SPECIFICATIONS | VENDOR | Moseley |  | [NAME]
 | BAND | 3.8GHz |  | 3.8GHz
 | CAPACITY | 200mbps |  | 155mbps
 | CHANNEL SPACING | 40 MHz |  | 28 MHz
 | MODULATION | 128QAM |  | 128 QAM
ANTENNA  SPECIFICATIONS | ANTENNA TYPE | HSX6-36/A | HSX8-36 | HSX6-36/A
 | ANTENNA SIZE | 1.8m all both ends | 2.4m all both ends | 1.8m all both ends
 | ELLIPTICAL WAVEGUIDE | EWP37 | EWP37 | EWP37
[NAME] CALCULATION | AVAILABILITY (%) | 0.9999832 | 0.9999983 | 1
 | DOWNTIME (min pa) | 8.850833333333332 | 0.885 | 0.02533333333333333
 | DOWNTIME (seconds pa) | 531.05 | 53.1 | 1.52
 | SD IMPROVEMENT FACTOR | 2.49 | 7.86 | 574.48
Spreadsheet: louise_kitchen__22582__List of potential candidates
Sheet: Sheet1

Last name | First name | Org unit | Org unit | Supervisor | Job | Date on job | PRC
Marks | [NAME] | 01011261 | ENA Generation Investments | Mr. [NAME] O Robinson | Analyst - Rotation 1 | 2000-09-11 00:00:00 | 2
Lang | [NAME] | 01011261 | ENA Generation Investments | Mr. [NAME] | Analyst - Rotation 2 | 2000-09-13 00:00:00 | 3
 |  |  | NA- Principal Investing G&A
 |  |  | EES- Commodity Fulfillment
Quinn | [NAME] | 01011261 | ENA Generation Investments | Ms. [NAME] | Analyst - Rotation 2 | 2001-08-16 00:00:00 | 2
 |  |  | EGM- Clean Energy
Martin | Gregory | 01011261 | ENA Generation Investments | Mr. [NAME] J Tricoli | Sr Analyst - Rotation 1 | 2000-08-01 00:00:00 | 3
Hoff | [NAME] | 01013699 | ENA Corporate Development | Mr. [NAME] | Sr Analyst - Rotation 1 | 2001-08-15 00:00:00 | 2
 |  |  | Asset Marketing
 |  |  | NA- Capital Structuring
Edmonds | Marcus | 01019866 | ENA Treasury & Funding | Ms. [NAME] | Analyst - Rotation 2 | 2000-07-19 00:00:00 | 3
 |  |  | EES- M&A Corporate Development
Kolle | [NAME] | 01019866 | ENA Treasury & Funding | Ms. [NAME] | Analyst - Rotation 2 | 2001-07-23 00:00:00 | 2
 |  |  | EBS- Finance
[NAME] | Alejandro | 01028625 | ENA Commodity Structuring | Mr. [NAME] | Sr Analyst - Rotation 1 | 2001-08-01 00:00:00 | 2
 |  |  | NA- Principal Investing G&A
 |  |  | EL- Venezuela
[NAME] | Loftus | 01028625 | ENA Commodity Structuring | Mr. [NAME] | Associate - Rotation 2 | 2001-02-07 00:00:00 | 1
 |  |  | NA- Generation Investments
 |  |  | EES- Commodity Risk Management
[NAME] | Santiago | 01028625 | ENA Commodity Structuring | Mr. [NAME] | Associate - Rotation 2 | 2001-02-07 00:00:00 | 2
 |  |  | Corp- RAC- Investment Valuations
Burk | [NAME] | 01028626 | ENA Fundamental Analysis/IT | Mr. [NAME] | Analyst - Rotation 1 | 2001-01-16 00:00:00 | 3
[NAME] | Catalina | 01028626 | ENA Fundamental Analysis/IT | Mr. [NAME] | Analyst - Rotation 1 | 2001-01-16 00:00:00 | 3
[NAME] | Sachin | 01028626 | ENA Fundamental Analysis/IT | Mr. [NAME] | Analyst - Rotation 1 | 2000-07-17 00:00:00 | 2
 |  |  | EES- Rates & Tarriffs Central Region
O'Malley | Justin | 01028626 | ENA Fundamental Analysis/IT | Mr. [NAME] | Analyst - Rotation 2 | 2001-02-07 00:00:00 | 3
 |  |  | EES- Risk Control & Analysis
[NAME] | Lauren | 01028626 | ENA Fundamental Analysis/IT | Mr. [NAME] | Analyst - Rotation 2 | 2001-02-07 00:00:00 | 3
 |  |  | EES- Transaction Economics
 |  |  | EES- Accounting & Reporting
Olsen | [NAME] | 01047093 | ENW - Energy Ops Gas Logistics Wellhead | Mr. [NAME] | Analyst - Rotation 2 | 2001-06-12 00:00:00 | 3
 |  |  | NA- Energy Ops HPLC Logistics Unify
 |  |  | ES- HOU- Accounting Planning
Oh | [NAME] | 01060196 | NA - Wst Pwr Orig Structuring | Mr. [NAME] Perry | Analyst - Rotation 2 | 2001-07-01 00:00:00 | 1
 |  |  | ENA- West Origination Portland
Spreadsheet: 117122d1312465203-selecting-data-from-one-table-to-another-between-dates-tracker
Sheet: Sheet2

FROM | TO | Start Date | End Date | [NAME]
JACKSONVILLE,FL | CONYERS,GA | 2011-01-03 00:00:00 | 2011-01-04 00:00:00 | 400 |  |  | START DATE | 2011-01-03 00:00:00 |  | END DATE | 2011-01-16 00:00:00 |  | EMPLOYEE | BILL
JACKSONVILLE,FL | MACON,GA | 2011-01-15 00:00:00 | 2011-01-16 00:00:00 | 325
I want to input start date, end date, employee name and have the shown columns be populated with this matching criteria.
Depending on the dates and employee name the data displayed should change.
Date values should be >=Start Date and <=End Date
Spreadsheet: 61581d1262499582-how-to-add-multiple-cell-with-two-criteria-examp
Sheet: Sheet1

ITEM | GROUP | CONDITION | QTY |  |  | TV ALL | TV GOOD | TV BAD | COMPUTER ALL | COMPUTER GOOD | COMPUTER BAD
COMPUTER A | COMPUTER | GOOD | 5 |  |  | 25 |  |  | 14
TV C | TV | GOOD | 9
TV D | TV | BAD | 4 |  |  | with one criteria we could use sumif, but what if we got two criteria, such as this one
COMPUTER B | COMPUTER | BAD | 4 |  |  | I've two criteria to sum it (TV GOOD , TV BAD, COMPUTER GOOD, COMPUTER BAD), first criteria is group and the condition, what should I do ?
TV B | TV | BAD | 7
COMPUTER C | COMPUTER | BAD | 2
TV A | TV | GOOD | 5
COMPUTER D | COMPUTER | BAD | 3
Spreadsheet: 677077d1589189585-how-to-look-up-a-name-and-return-heading-example
Sheet: Sheet1

PART1
2019 |  |  |  | 2018 |  |  |  | 2017
Name | Number | Place |  | Name | Number | Place |  | Name | Number | Place
a | 123122 | sdfsfs |  | c | 155122 | fgw |  | h | 123122 | dfh
b | 232444 | [NAME] |  | b | 234244 | rt |  | f | 232444 | fgh
c | 123355 | dfsd |  | e | 233523 | ert |  | d | 123355 | rwerz
d | 234244 | sa |  | d | 234244 | hw45 |  | g | 234244 | rtzwr
e | 342455 | dfsd |  | f | 342455 | sr |  | j | 342455 | erw
f | 123789 | sa |  | i | 123789 | oo |  | c | 123789 | ert
g | 234288 | sdfsd |  | g | 234288 | sdg |  | a | 234288 | rter
h | 423456 | fsd |  | h | 423456 | wertf |  | t | 423456 | tert
i | 234298 | fsf |  | t | 234298 | sert |  | g | 234298 | erjg
PART2
Name | [NAME] | 2019 | 2018 | 2017
a
b
c
d
e
f
g
h
i
j
t
Spreadsheet: 94755d1294506160-how-to-make-a-one-point-conditional-mark-in-a-column-1101_nested_if
Sheet: Ark1

ACHIEVED |  |  | 100 |  |  |  | EXPECTED |  |  | 100
 | 5 |  |  |  |  |  |  | 5
 | 5 |  |  |  |  |  | 100 | 5
 | 5 |  |  |  |  |  |  | 5
#N/A
#N/A | 5 |  |  |  |  |  |  | 5
#N/A
#N/A | 5 | 13 |  |  |  |  |  | 5 | 13
Spreadsheet: 97545d1296682860-tracking-income-and-invoices-for-projects-multiple-search-results-test-project-tracking
Sheet: Apr 2011

 | Income and Expense Report
 |  | 2011-04-01 00:00:00
 |  | 0 | LOSS
 | Date | Payment Type | Reference / Debtor No. | Supplier Invoice Number | Income  ($) | Purchasing Property | Total Invoice Costs ($) | MAC | GN | HF | BM | Comments
 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  | PIF-ROW
 |  | Initial Instal'
 |  | Instalment
 |  | Final Instal'
 |  | Invoice Only
 |  | Other
Spreadsheet: 7d1fe8d2-76be-4cd2-a912-8effe71a0bc1
Sheet: Report

Unit | Unit Priority | [NAME] | Objective Id | Objective Name | Objective Priority | Strategic Direction | Impact Type
Human Resources | 1 | Providing excellent customer service to our clientele | 1.1 | HR [NAME] at the two campuses | 1 | None | -- Pick One --
Human Resources | 1 | Providing excellent customer service to our clientele | 1.2 | Improve communication media to employees | 1 | None | -- Pick One --
Human Resources | 1 | Ensure a safe and healthy working environment | 2.1 | Reduce the number of worker's compensation claims files | 1 | None | -- Pick One --
Human Resources | 1 | Ensure a safe and healthy working environment | 2.2 | Develop a Health and Wellness Program | 2 | None | -- Pick One --
Human Resources | 2 | Efficiently recruiting and hiring qualified individuals. | 3.1 | Efficient Recruitment and Hiring | 1 | None | -- Pick One --
Human Resources | 2 | Efficiently recruiting and hiring qualified individuals. | 3.2 | Develop a Mentoring Program for New Hires | 1 | None | -- Pick One --
Human Resources | 1 | Maintain and enhance the District Long Range Staffing Plan
Human Resources | 2 | Human Resources Policies and Procedures | 5.1 | Board Policies and Administrative Procedures | 1 | None | -- Pick One --
Human Resources | 2 | Human Resources Policies and Procedures | 5.2 | Human Resources Standard Operating Procedures Manual | 2 | None | -- Pick One --
Human Resources | 2 | Human Resources Policies and Procedures | 5.3 | Develop Employee Handbook | 3 | None | -- Pick One --
Human Resources | 1 | Enhance the District's Training Program | 6.1 | Conduct a Training Needs Assessment | 1 | None | -- Pick One --
Human Resources | 1 | Enhance the District's Training Program | 6.2 | Develop a training program for managers and classified employees. | 1 | None | -- Pick One --
Human Resources | 1 | Enhance the District's Training Program | 6.3 | Develop an training evaluation tool. | 1 | None | -- Pick One --
Spreadsheet: 61451afe-38b2-4907-bcb3-35f90731f565
Sheet: Unit Affordability Example

Exhibit 26: Unit [NAME] and Affordability Worksheet (Rental)
Sample
2014-15 Housing Development NOFA
Enter one type of unit per row; add rows if necessary.
1.  Rental:  Affordable Units
Indicate percentage of AMI used to calculate rents (e.g., 30% of 50% of AMI) | # of Units | Unit Type                (#BR / #Bath) | [NAME] | Maximum Tenant Income* | Per Unit Monthly Rent (Estimated Tenant Contribution) | Name of subsidy that is applied to the unit (If any) | Per Unit Amount of Subsidy Applied To The Unit (If Any) | Per Unit Rent Received** | Total Monthly Rent for Unit Type** | Per Unit Monthly Utility Allowances* | Total Gross Monthly Payment Per Unit (Incl. Utilities) | Accessible Unit? ([NAME], Visual/Hearing, etc)
30% of 30% AMI | 10 | 2/1 | 900 | 0.3 | 400 | PBS8 | 500 |  |  | 90 |  | Mobility
30% of 50% AMI | 20 | 1/1 | 500 | 0.5 | 700 |  | 0 |  |  | 70 |  | Visual/Hearing
30% of 50% AMI | 20 | 2/1 | 900 | 0.5 | 650 | PBS8 | 250 |  |  | 90
Total # [NAME] |  |  |  |  |  |  |  | Total Monthly Rental Income |  |  | ↑
2.  Managers' Units***
Indicate percentage of AMI used to calculate rents (e.g., 30% of 50% of AMI) | # of Units | Unit Type                (#BR / #Bath) | [NAME] |  |  |  |  | Proposed Monthly Rent | Total Monthly Rents |  | Rents in this column may not exceed Maximum Rents Per [NAME], Income, Rent & Housing Payment Limits
 | 1 | 2/2 | 1300 |  |  |  |  | 1300
Total # [NAME] |  |  |  |  |  |  |  | Total Monthly Rental Income
3.  Market Rate Units
 | # of Units | Unit Type                (#BR / #Bath) | [NAME] |  |  |  |  | Proposed Monthly Rent | Total Monthly Rents
Total # [NAME] |  |  |  |  |  |  |  | Total Monthly Rental Income
4.  Affordability Summary/City Restrictions |  |  |  |  |  |  |  |  |  |  | 5.  Annual Rental Revenue
This summary reflects the rent restrictions according to the City's requirements only and won't necessarily match the actual rent structure detailed in table 1 above. |  |  |  |  |  |  |  |  |  |  | Total Monthly Rents for ALL units
 | Total Project Units |  |  | % of Units
 |  |  | % units with annual rents ≤ 30% of 30% AMI |  |  |  |  |  |  |  |  | x12
 |  |  | % units with annual rents ≤ 30% of 60% AMI
 |  |  |  |  |  |  |  |  |  |  | Total Annual Rents for ALL Units
6.  [NAME] Utility Breakdown |  |  |  |  | 7. Unit [NAME]
Indicate which utilites will be paid by tenant (T) and which utilities will be paid by [NAME] (L).
 | Gas | Electric |  |  | Unit Type | # of Units | # of Special Needs Units | # of Homeless Units
Space Heating |  | T |  |  | SRO
Lighting |  | T |  |  | Studio
Cooking |  | T |  |  | 1 bedroom | 25 | 10 | 5
Hot Water | L |  |  |  | 2 bedroom | 25 | 10 | 5
Water | L |  |  |  | 3 bedroom
Garbage | L |  |  |  | 4 bedroom
* See [NAME]: "Income, Rent, Utility Allowance, Housing Payments Limits" for current utility allowances and rents.
** Including project-based rental assistance from Section 8, Public Housing ACC, HOPWA, Shelter Plus Care or similar project-based assistance.
*** Rent for manager's unit(s) should be listed as income here and an expense on the operating budget.
Spreadsheet: 773488d1647880821-index-to-get-the-value-with-multiple-condition-sample-1
Sheet: Sheet1

 | min | [NAME] |  | value
 | 1 | 5 |  | 25
 | 6 | 10 |  | 35
 | 11 | 15 |  | 45
 |  | given
 | a | 2
 | b | 5
 | c | 4
 |  | correct answer ==> |  | 45 | <====  formula to get  this value
 |  |  |  |  | (given will be changed)
 |  |  |  |  | if the given value with total 8, the correct answer will be 35)
Spreadsheet: 119664d1314644319-report-suggestions-book1
Sheet: Sheet1

 | Time to control: | 00:30:00
Time | phone number | call duration
03:00:00 | 555-1212 | 00:03:47 | 00:21:13
03:25:00 | 555-2345 | 00:02:45 | 00:27:15
03:55:00 | 555-4567 | 00:01:03 | 00:58:57
04:55:00 | 123456 | 00:00:06
Spreadsheet: 748246d1631985597-extract-all-value-related-to-duplicated-from-another-column-extract-all-related-value-for-duplicated-in-excel
Sheet: Sheet1

COLLM | Value |  |  | Need result like this
1005 | AL2230 |  |  | Number of dulpication | unique
1006 | AL2231 |  |  |  |  | AL2230 | AL2235 | AL2240
1007 | AL2232 |  |  |  | 1006 | AL2231
1008 | AL2233 |  |  |  | 1007 | AL2232
1009 | AL2234 |  |  |  | 1008 | AL2233 | AL2236 | AL2239 | AL2242 | AL2245
1005 | AL2235 |  |  |  | 1009 | AL2234
1008 | AL2236 |  |  |  | 1125 | AL2237
1125 | AL2237 |  |  |  | 1256 | AL2238
1256 | AL2238 |  |  |  | 1120 | AL2241
1008 | AL2239 |  |  |  | 1100 | AL2243 | AL2247
1005 | AL2240 |  |  |  | 1369 | AL2244
1120 | AL2241 |  |  |  | 5223 | AL2246
1008 | AL2242
1100 | AL2243
1369 | AL2244
1008 | AL2245
5223 | AL2246
1100 | AL2247
Spreadsheet: 710233d1608796303-sum-a-column-based-on-the-adjacent-column-dynamic-sum-1-
Sheet: Sheet1

 |  |  | Examples:
100 | 740 |  | 100 |  |  | 100 | 125 |  | 100 | 125 |  | 100 | 125 |  | 100 | 125 |  | 100 | 125
200 | 1607 |  | 200 |  |  | 200 | 0 |  | 200 | 246 |  | 200 | 246 |  | 200 | 246 |  | 200 | 246
300 | 200 |  | 300 |  |  | 300 | 0 |  | 300 | 0 |  | 300 | 285 |  | 300 | 285 |  | 300 | 285
400 | 0 |  | 400 |  |  | 400 | 0 |  | 400 | 0 |  | 400 | 0 |  | 400 | 124 |  | 400 | 124
500 | 0 |  | 500 |  |  | 500 | 0 |  | 500 | 0 |  | 500 | 0 |  | 500 | 0 |  | 500 | 256
Need formula in A7. If B3=0 or >0, it should sum A2:A6. If B3 value is >0, it should be B2+sum(A3:A6). If B4 value is >0, it should be B2:B3+sum(A4:A6). If B5 value is >0, it should be B2:B4+sum(A5:A6). If [NAME] value is >0, it should be B2:B5+sum(A6:A6).
Spreadsheet: 166657d1341688364-excel-solver-entering-a-product-mix-constraint-from-a-percentage-product-mix-solver2
Sheet: Sheet1

Assignment #2
Beechwood Specialty Electronics
[NAME]
 | (X) | (Y)
 | iPods | Cell Phones | Maximum | Minimum
Unit Cost ($) | 47 | 32
[NAME]. (Sq. Ft.) | 0.5 | 0.75 | 200 | 0
Sales Revenue ($) | 90 | 70
Profit per item
Capital Cost ($) | 200 | 50 | 3000 | 0
Decision Variables
 | iPods | Cell Phones
Optimal Quantity
[NAME]
[NAME] |  | 200 | =< 200
Marketing Constraint
Capital Constraint |  | 3000 | =< 3000
Total Profit (MAX P)
Spreadsheet: 717705d1612805641-return-unique-sequence-of-data-unique-sequence
Sheet: Sheet1

Name | Sale |  |  | unique sequence | Average |  |  | unique sequence | Average Sales
A | 191 |  |  | A
A | 162 |  |  | B
A | 179 |  |  | C
B | 133 |  |  | D
B | 182 |  |  | A
C | 158 |  |  | E
C | 178 |  |  | B
C | 158
C | 185
D | 179
D | 178
A | 154
A | 185
E | 191
E | 181
E | 176
B | 155
B | 105
B | 108
Spreadsheet: 685813d1594211544-how-to-show-the-values-on-pivot-table-context-answer
Sheet: Sheet1

Col.1 | Col.2 |  | 1-2 | 2-3 | 3-4 | 4-5 | 5-6 | 6-7 | 7-8
1-2 | 1-2
1-2 | 1-b2
1-2 | 1-#2
2-3 | 2-b3
2-3 | 2-3
2-3 | 2-#3
2-3 | b2-b3
2-3 | b2-3
2-3 | b2-#3
2-3 | #2-b3
2-3 | #2-3
2-3 | #2-#3
3-4 | 3-b4
3-4 | 3-4
3-4 | 3-#4
3-4 | b3-b4
3-4 | b3-4
3-4 | b3-#4
3-4 | #3-b4
3-4 | #3-4
3-4 | #3-#4
4-5 | 4-b5
4-5 | 4-5
4-5 | 4-#5
4-5 | b4-b5
4-5 | b4-5
4-5 | b4-#5
4-5 | #4-b5
4-5 | #4-5
4-5 | #4-#5
5-6 | 5-b6
5-6 | 5-6
5-6 | 5-#6
5-6 | [NAME]
5-6 | [NAME]
5-6 | b5-#6
5-6 | #5-b6
5-6 | #5-6
5-6 | #5-#6
6-7 | 6-b7
6-7 | 6-7
6-7 | 6-#7
6-7 | b6-b7
6-7 | b6-7
6-7 | b6-#7
6-7 | #6-b7
6-7 | #6-7
6-7 | #6-#7
7-8 | 7-8
7-8 | b7-8
7-8 | #7-8
Spreadsheet: michelle_lokay__26792__imball0203
Sheet: NNG

NNG
 | Measured | Scheduled | Imbalance
1635 | -89724
3531 | -158756 | -56650
60667 | -160744 | -470492
60749 | 9058 | 131663
61206
61334 | -214
62960
INDEX
2002-02-28 00:00:00 |  |  | 33520
2002-03-05 00:00:00
CBS Volume
 |  |  | 15258