tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 44809d1243542321-need-help-filtering-a-list-in-a-new-worksheet-from-a-master-list-personnel-tracker-mock
Sheet: Mick

Current Manager: | Mick | Employees: | 16
 | Name | Contractor/ Employee ID | Logon ID | Purchasing Test Score | Suspense Test Score
 | [NAME] | C11111 | asdfhjkl1 | N/A | N/A
 | Glenda R | C11118 | asdfhjkl8 | N/A | 1
 | [NAME] | C11123 | asdfhjkl13 | 0.9713 | 0.9875
 | [NAME] | C11128 | [NAME] | 0.9713 | 0.975
 | Fairy B | [NAME] | asdfhjkl28 | N/A | N/A
 | [NAME] | C11143 | asdfhjkl33 | N/A | N/A
 | Nadia P | C11147 | asdfhjkl37 | N/A | N/A
 | [NAME] R | C11151 | asdfhjkl41 | 0.9933 | 0.8529
 | [NAME] | C11155 | asdfhjkl45 | 0.94 | 0.8529
 | Candace R | C11158 | asdfhjkl48 | 0.9533 | 0.8581
 | [NAME] | [NAME] | asdfhjkl52 | 0.96 | 0.9595
 | [NAME] | C11166 | asdfhjkl56 | N/A | 0.9481
 | [NAME] | C11170 | asdfhjkl60 | 0.8667 | 0.9625
 | [NAME] B | C11175 | asdfhjkl65 | 0.96 | 1
 | Nedezda K | C11178 | asdfhjkl68 | 0.9713 | 0.975
 | [NAME] | C11183 | [NAME] | N/A | 0.975
Spreadsheet: 167100d1341901330-filtering-one-specific-name-in-excel-2010-copy-of-morning-attendance-2-
Sheet: 22 Feb 2012

Daily Morning Staff |  |  |  |  | Wednesday
 | 07:30-14:30 |  | 2012-02-22 00:00:00
Name | Staff No. | Title | Time In | Out | Locations | Remarks
Naima Mohamed | 2166 | Client Ralation Supervisor | 07:30:00 | 14:30:00 | EFS
Sheikha [NAME] | 2120 | Reservation Officer | 07:30:00 | 14:30:00 | TOPS
Syed Sultan | 2888 | Supervisor | 07:30:00 | 14:30:00 | EFS
[NAME] | 4143 | Aircraft Team Leader | Annual | Annual | EFS | Annual
Jalil Nushadi | 1889 | Driver | 05:45:00 | 14:30:00 | EFS
[NAME] | 624 | Driver | 07:30:00 | 14:30:00 | EFS
Soud Sharar | 2097 | [NAME] Officer | 07:30:00 | 14:30:00 | [NAME]
[NAME] | 1897 | Manager | 07:30:00 | 14:30:00 | EFS
[NAME] | 4440 | Attendant | Annual | Annual | EFS | Annual
[NAME] | 1861 | Duty Officer | 07:30:00 | 14:30:00 | EFS
Spreadsheet: 722028d1615007319-return-another-cell-if-one-cell-equals-another-with-formula-return-another-cell
Sheet: Sheet5

10 | 20 | 30 | 40 | 50 | 60
 |  |  |  |  |  |  |  | How can I make I5:N5 equal another value enterd A5:F5 for every row?
1 | 2 | 3 | 4 | 5 | 6
3 | 4 | 1 | 4 | 4 | 2 |  |  |  |  | 10 | 40 | 40 | 20
1 | 2 | 6 | 5 | 4 | 3 |  |  |  |  | 60 | 50 | 40 | 30
 |  |  |  |  |  |  |  |  |  | 110 | 60 | 40 | 40
 |  |  |  |  |  |  |  |  |  | 160 | 70 | 40 | 50
 |  |  |  |  |  |  |  |  |  | 210 | 80 | 40 | 60
 |  |  |  |  |  |  |  |  |  | 260 | 90 | 40 | 70
 |  |  |  |  |  |  |  |  |  | 310 | 100 | 40 | 80
 |  |  |  |  |  |  |  |  |  | 360 | 110 | 40 | 90
 |  |  |  |  |  |  |  |  |  | 410 | 120 | 40 | 100
 |  |  |  |  |  |  |  |  |  | 460 | 130 | 40 | 110
Spreadsheet: 113985d1309863805-excel-2007-excel-funtion-help-tryout
Sheet: Sheet1

No. | Date | Value |  |  |  |  |  |  |  | Months | SUM (Value)
1 | 2011-07-04 00:00:00 | 201 |  |  |  |  |  |  |  | January
2 | 2011-07-05 00:00:00 | 2 |  |  |  |  |  |  |  | February
3 | 2011-07-06 00:00:00 | 2534 |  |  |  |  |  |  |  | March
4 | 2011-07-06 00:00:00 |  |  |  |  |  |  |  |  | April
5 | 2011-07-07 00:00:00 | 345 |  |  |  |  |  |  |  | August
6 | 2011-07-08 00:00:00 | 75 |  |  |  |  |  |  |  | May
7 | 2011-07-09 00:00:00 | 35 |  |  |  |  |  |  |  | June
8 | 2011-07-10 00:00:00 | 32 |  |  |  |  |  |  |  | July
9 | 2011-07-10 00:00:00 |  |  |  |  |  |  |  |  | August
10 | 2011-07-11 00:00:00 | 42 |  |  |  |  |  |  |  | September
11 | 2011-07-12 00:00:00 | 2 |  |  |  |  |  |  |  | October
12 | 2011-07-13 00:00:00 |  |  |  |  |  |  |  |  | November
13 | 2011-07-14 00:00:00 | 6 |  |  |  |  |  |  |  | December
14 | 2011-07-15 00:00:00 | 3
15 | 2011-07-16 00:00:00 | 45
16 | 2011-07-16 00:00:00
17 | 2011-07-17 00:00:00 | 678
18 | 2011-07-18 00:00:00
19 | 2011-07-19 00:00:00 | 4
20 | 2011-07-20 00:00:00 | 67
21 | 2011-07-21 00:00:00 | 34
22 | 2011-07-21 00:00:00
23 | 2011-07-22 00:00:00
24 | 2011-07-23 00:00:00 | 67
25 | 2011-07-24 00:00:00 | 3
26 | 2011-07-25 00:00:00 | 3
27 | 2011-07-26 00:00:00 | 12
28 | 2011-07-27 00:00:00 | 32
29 | 2011-07-27 00:00:00
30 | 2011-07-28 00:00:00 | 21
31 | 2011-07-29 00:00:00
32 | 2011-07-30 00:00:00 | 32
33 | 2011-07-31 00:00:00 | 1
34 | 2011-08-03 00:00:00
35 | 2011-08-06 00:00:00
36 | 2011-08-30 00:00:00
Spreadsheet: 778268d1650965297-formula-like-a-vlookup-but-to-bring-back-multiple-results-formula-help
Sheet: Sheet1

code | Name | discount | Nominal | Discount | Nominal | Discount | Nominal |  |  | Code | Discount | Nominal
A001 | Smith | Award 20% |  | Award 5% |  | Sale 10% |  |  |  | A001 | Award 20% | 12345
B002 | Jones |  |  |  |  |  |  |  |  | A001 | Award 5% | 12346
D001 | Davies |  |  |  |  |  |  |  |  | E002 | Award 35% | 12344
E002 | [NAME] |  |  |  |  |  |  |  |  | E002 | Sale 40% | 21244
 |  |  |  |  |  |  |  |  |  | A001 | Sale 10% | 21245
 |  | I want to populate the yellow cells based on the data in the orange section.
 |  | I have typed in the results I would expect for the first line.
Spreadsheet: 79596d1279816660-using-a-lookup-to-find-a-value-but-the-index-column-changes-reference-maintaining-vlookup-example
Sheet: Sheet2

Forename | Surname | Job | Age
1 | 2 | 3 | 4
Fred | Bloggs | Engineer | 35
[NAME] | Smith | Layabout | 44
[NAME] | Gently | Sales | 26
[NAME] | Scone | Manager | 30
Spreadsheet: 791067d1660142302-i-need-to-calculate-the-average-days-the-tickets-have-been-open-in-the-past-30-days-maintanace-tickets
Sheet: Issue Log

Maintenance Tickets
 |  |  |  |  | Date
# | Issue | Priority | Type of Issue | Submitted By | Open | Close | Days open | Currently Worked on by | Completed by | External  Completion Cost | Any Preventative  [NAME] | Comments
1 |  |  |  |  | 2022-04-19 00:00:00
2 |  |  |  |  | 2022-04-20 00:00:00 | 2022-05-09 00:00:00
3 |  |  |  |  | 2022-04-21 00:00:00
4 |  |  |  |  | 2022-04-22 00:00:00
5 |  |  |  |  | 2022-04-23 00:00:00
6 |  |  |  |  | 2022-04-24 00:00:00 | 2022-05-09 00:00:00
7 |  |  |  |  | 2022-04-25 00:00:00 | 2022-05-09 00:00:00
8 |  |  |  |  | 2022-04-26 00:00:00
9 |  |  |  |  | 2022-04-27 00:00:00
10 |  |  |  |  | 2022-04-27 00:00:00
11 |  |  |  |  | 2022-04-27 00:00:00
12 |  |  |  |  | 2022-04-27 00:00:00
13 |  |  |  |  | 2022-04-24 00:00:00
14 |  |  |  |  | 2022-04-24 00:00:00
15 |  |  |  |  | 2022-04-24 00:00:00
16 |  |  |  |  | 2022-05-08 00:00:00
17 |  |  |  |  | 2022-05-09 00:00:00
18 |  |  |  |  | 2022-05-10 00:00:00
19
Spreadsheet: louise_kitchen__22741__Turbine Position Report 040601
Sheet: Summary by Region

Turbine Position Report |  |  |  |  |  |  |  | CONFIDENTIAL
Summary by Controlling Region
($ MMs) |  |  |  |  |  |  |  | DRAFT
 |  |  |  |  |  |  | Financial Data as of
UNITS | MODEL | CONTROLLED BY | STATUS | DASH APPROVAL DATE / STATUS | PROJECT(S) | CONTRACT COST | SCHEDULED CONTRACT PYMTS TO DATE | CANCELLATION
EWS
 |  |  |  |  | TOTAL EECC
EA
 |  |  |  |  | TOTAL EA
EGM
 | UNITS - TOTAL |  |  |  | GRAND TOTALS
 |  |  |  |  | per Summary By [NAME] report
 |  |  |  |  | Difference
Spreadsheet: 112701d1308742296-index-match-multiple-criteria-multiple-sheets-lookup-multiple-conditions-2
Sheet: Compare

 |  | ID | Phasing Data | Patt | S1/CL | S2/CL | S3/CL | S4/CL | S5/CL | S6/CL | S7/CL | S8/CL
 |  | 1 | MinGreen | MD
 |  | 3 | AllRed | MD
 |  | 3 | Yellow | PM
 |  | 4 | Walk | PO
 |  | 5 | DontWalk | WA
Spreadsheet: 68822d1269366594-using-min-and-max-function-to-find-times-testtimes
Sheet: Sheet 1

ID | Start Date & Time | End Date & Time |  | Start Date & Time | End Date & Time
1 | 2010-03-18 01:25:26 | 2010-03-18 01:26:20 |  | 01:25 AM | 01:26 AM
2 | 2010-03-11 16:15:58 | 2010-03-11 16:16:26 |  | 04:15 PM | 04:16 PM
3 | 2010-03-08 11:55:31 | 2010-03-08 11:55:31 |  | 11:55 AM | 11:55 AM
 | MINIMUM START | 2010-03-08 11:55:31 |  | MINIMUM START | 11:55 AM
 | MINIMUM END | 2010-03-08 11:55:31 |  | MINIMUM END | 11:55 AM
 | MAXIMUM START | 2010-03-18 01:25:26 |  | MAXIMUM START | 01:25 AM
 | MAXIMUM END | 2010-03-18 01:26:20 |  | MAXIMUM END | 01:26 AM
Spreadsheet: 219544d1362779122-countifs-and-date-ranges-test-me-forum
Sheet: Test

Applicant /  Project Number | Initiation Date | Date Updated | Money Requested | Loans | Loans Guarantees Issued | [NAME] | Loan Guarantee Issued | Loans | Cost Savings | Transactions | Number of Applicants
asd | 2013-01-02 00:00:00 | 2013-04-02 00:00:00 | 140000 | 700000 | 1260000 | 1820000 |  |  | 2300 | 1 | 1
SDE | 2013-01-02 00:00:00 | 2013-04-02 00:00:00 | 220000 | 1100000 | 1980000 | 2860000 |  |  | 4500 |  | 1
FER | 2013-03-01 00:00:00 | 2013-03-21 00:00:00 | 160200 | 801000 | 1441800 | 2082600 |  |  | 6700 | 1 | 1
GGG | 2013-01-01 00:00:00 | 2013-03-20 00:00:00 | 358000 | 895000 | 1432000 | 1969000 |  |  | 8900 |  | 1
BSE | 2013-08-01 00:00:00 | 2013-03-23 00:00:00 | 260000 | 1300000 | 2340000 | 3380000 |  |  | 2300 | 1
ERT | 2013-07-01 00:00:00 | 2013-03-08 00:00:00 | 266000 | 1330000 | 2174360 | 3091020 |  |  | 4500 | 1 | 1
DFV | 2013-07-01 00:00:00 | 2013-03-08 00:00:00 | 300000 | 1500000 | 2335560 | 3313920 |  |  | 2300 | 1 | 1
CDRE | 2013-02-01 00:00:00 | 2013-02-14 00:00:00 |  |  | 2496760 | 3536820 |  |  | 4500 |  | 11
asd | 2013-02-01 00:00:00 | 2013-01-10 00:00:00 | 750000 | 2500000 | 2657960 | 3759720 |  |  | 2300 | 1
SDE | 2013-09-01 00:00:00 | 2013-09-14 00:00:00 | 195000 | 1300000 | 2819160 | 3982620 |  |  | 4500 |  | 1
FER | 2013-08-01 00:00:00 | 2013-09-13 00:00:00 | 500000 | 1250000 | 2980360 | 4205520 |  |  | 2300 | 1 | 1
GGG | 2013-08-01 00:00:00 | 2013-09-02 00:00:00 |  |  | 3141560 | 4428420 |  |  | 4500 |  | 1
BSE | 2013-05-01 00:00:00 | 2013-07-05 00:00:00 | 73007 |  | 3302760 | 4651320 |  |  | 2300 | 1 | 11
ERT | 2013-05-01 00:00:00 | 2013-05-02 00:00:00 | 380000 | 950000 | 3463960 | 4874220 |  |  | 4500
DFV | 2013-04-01 00:00:00 | 2013-04-25 00:00:00 | 381891 | 954729 | 3625160 | 5097120 |  |  | 2300 | 1 | 11
CDRE | 2013-01-09 00:00:00 | 2013-03-02 00:00:00 | 334000 | 835000 | 3786360 | 5320020 |  |  | 4500
asd | 2013-01-01 00:00:00 | 2013-02-23 00:00:00 | 400000 | 1000000 | 3947560 | 5542920 |  |  | 100 | 1 | 1
SDE | 2013-04-01 00:00:00 | 2013-02-21 00:00:00 | 400000 | 1000000 | 4108760 | 5765820 |  |  | 2300 |  | 11
FER | 2013-01-09 00:00:00 | 2013-02-07 00:00:00 | 400000 | 1000000 | 4269960 | 5988720 |  |  | 4500 | 1 | 1
GGG | 2013-01-01 00:00:00 | 2013-12-20 00:00:00 | 360000 | 966453 | 4431160 | 6211620 |  |  | 6700
BSE | 2013-04-01 00:00:00 | 2013-12-20 00:00:00 | 375000 | 1250000 | 4592360 | 6434520 |  |  | 8900 | 1 | 1
ERT
DFV
CDRE
GRAND TOTAL
Spreadsheet: 730831d1619979418-find-the-percentage-a-cell-is-in-a-time-range-and-the-average-time-within-each-5x20-strategy-tms
Sheet: RESULTS (v2)

 | TIME TRADED %
 |  |  |  |  | Much shorter formula … |  | Ave times
 | 06:00:00 | 08:59:00
 | 09:00:00 | 09:29:00
 | 09:30:00 | 09:49:00
 | 09:50:00 | 10:29:00
 | 10:30:00 | 11:29:00
 | 11:30:00 | 14:59:00
 | 15:00:00 | 16:00:00
 | GAIN/LOSS
 | Trading Days Span |  | 53
 | Trading Days
 | Trading Days %
 | Total Wins
 | Total Points /share
 | Average Points /share |  |  |  | Excluding top 2 and bottom 2
 | Win/Loss % |  |  |  | Note, this is Win % on days there was a 5x20 strategy win
 | ENTRY REASON %
 | PM CONSOLIDATION
 | R2G
 | MOMO
 | CONSOLIDATION
 | PMH
 | BO
 | HIGHS %
 | Entry-High Ave |  |  |  | Percentage High above Entry
 | High-Close Ave |  |  |  | Percentage High above Close
Spreadsheet: 06e4eb47-e806-47a8-bf75-8e524c315c48
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 |  |  |  |  |  | [NAME] EMPLOYEE TIMESHEET
YORK COLLEGE
PAYROLL OFFICE
TO BE COMPLETED BY SUPERVISOR
TITLE: |  |  |  |  |  | APPOINTED HOURS:
DEPT#: |  |  |  |  |  | TOTAL HOURS USED TO DATE:
 |  |  |  |  |  | BALANCE HOURS:
PAYROLL PERIOD: __________________________
NAME: LAST________________________________ |  |  |  |  |  |  | FIRST: _______________________________________
SOC. SEC. NO.      XXX-XX-____________________ |  |  |  |  |  |  | DEPARTMENT: ________________________________
 |  |  | (Last four digits only)
No. | Day | Date | Time In | Meal Period | Time Out | # [NAME] | Sick Hours | Annual Hours | Total | Shift Hours | Signature
1 | SUN
2 | MON
3 | TUES
4 | WED
5 | THURS
6 | FRI
7 | SAT
WEEKLY SUB-TOTAL:
8 | SUN
9 | MON
10 | TUES
11 | WED
12 | THURS
13 | FRI
14 | SAT
WEEKLY SUB-TOTAL:
TOTAL HOURS:
I certify that the hours above have been worked.  Sick and/or annual leave hours have to be taken as indicated.
All computations are correct and there are sufficient funds in my allocation to pay this expenditure.
Prepared By |  |  |  |  | Department's Extension |  |  |  | Chairperson/Authorized Representative
Spreadsheet: 880761d1728622933-extract-data-in-a-row-based-on-an-if-formula-when-it-is-true-check-file_corrected
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | focus point
 |  |  |  |  |  |  |  |  |  |  |  | 0.05 |  |  |  | this should be the result
 |  |  |  |  |  |  | 24 09 vs 23 09 |  | 24 09 vs 24 09 est |  |  | 25 |  |  |  | comments |  |  | test solution
 |  |  | 2023 09 | 2024 09 | 2024 09 est |  | DIF | % | DIF | % |  | A | B |  | check A | A8 | BC |  |  | AC
A1 | AC |  | 13 | 33 | 25 |  |  |  |  |  |  |  |  |  | check A | A12 | BC |  | A10 | BC
A2 | BC |  | 20 | 20 | 33 |  |  |  |  |  |  |  |  |  | check B | A1 | AC |  | A11 | AC
A3 | AC |  | 11 | 30 | 51 |  |  |  |  |  |  |  |  |  | check B | A7 | AC |  | A12 | BC
A4 | BC |  | 2 | 2 | 4 |  |  |  |  |  |  |  |  |  | check B | A10 | BC |  | A14 | BC
A5 | AC |  | 3 | 3 | 6 |  |  |  |  |  |  |  |  |  | check B | A11 | AC |  | A15 | AC
A6 | BC |  | 4 | 4 | 71 |  |  |  |  |  |  |  |  |  | check B | A12 | BC |  | A18 | BC
A7 | AC |  | 556 | 200 | 45 |  |  |  |  |  |  |  |  |  | check B | A14 | BC
A8 | BC |  | 7 | 33 | 67 |  |  |  |  |  |  |  |  |  | check B | A15 | AC
A9 | AC |  | 77 | 77 | 89 |  |  |  |  |  |  |  |  |  | check B | A18 | BC
A10 | BC |  | 987 | 600 | 500
A11 | AC |  | 43 | 43 | 32
A12 | BC |  | 65 | 200 | 150
A13 | AC |  | 56 | 56 | 56
A14 | BC |  | 78 | 100 | 66
A15 | AC |  | 44 | 44 | 23
A16 | BC |  | 45 | 45 | 56
A17 | AC |  | 67 | 67 | 78
A18 | BC |  | 83 | 87 | 82
Spreadsheet: 107424d1304599166-need-formula-for-a-macro-function-example
Sheet: 20

1435
Name | Amount
Name 2 | 143
Name 1 | 141
Name 2 | 171
Name 3 | 179
Name 2 | 186
Name 2 | 136
Name 2 | 126
Name 3 | 158
Name 1 | 118
Name 1 | 187
Name 3 | 101
Name 2 | 122
Name 3 | 122
Name 2 | 101
Name 1 | 120
Name 1 | 105
Name 1 | 173
Name 2 | 118
Name 1 | 135
Name 2 | 110
Name 1 | 153
Name 1 | 184
Name 2 | 165
Name 1 | 119
Name 3 | 108
Spreadsheet: 0b0e7a2c-31bd-42ef-b7cc-17a629e7462a
Sheet: Subject TOTALS

Success Rate = % receiving passing grade | Success Rates
 | MSJC Dual Enrollment Total by Subject
[To view course data click on Subject Name below] | AY11-12
Subject | SU11 | FA11 | SP12
Accounting
Alcohol/Drug Studies
Allied Health
Administration of Justice
Anatomy & Physiology
Anthropology
Art
American Sign Language
Astronomy
Audio Technology
Automotive/Transportation
Business Administration
Biology
Computer Applications
Childhood Development & Education
Chemistry
Communication
Corrections
Computer Science/Informations Systems
Dance
Diagnostic Medical Sonography
Economics
Education/Teacher Preparation
English
Engineering
Environment Science
Earth Science
English as a Second Language
Fire Technology
French
Geography
Geology
Gerontology
Guidance
Honors Enrichment Program
History
Horticulture
Health Science
Humanities
LEAD
Legal Assistant
[NAME]
[NAME]
Mathematics
Management/Supervision
Multimedia
Music
Networking
Nursing
Nutrition
Occupational Internship
Office Technology
Physical Education
PEIC
Philosophy
Photography
Physics
Portuguese
Political Science
Psychology
Real Estate
Reading
Sustainable Energy Management
Sociology
Spanish
Teaching Assistant
Theater Arts
Viticulture and Enology
Water Technology
Term Dual Enrollment Average Success Rate
Success rate = # of “A, B, C, CR & P” grades divided by (the # of all grades) “A, B, C, CR, P, D, F, NC, NP, I and W”
Spreadsheet: 828544d1683593729-rent-roll-calculation-rental-revised-2
Sheet: Rent Roll 

Year | 2022
Monthly Rental |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | New End Date | Termination Date | Rent Free |  | Backdated Rental |  | Amount (+ xx, increase;  - xx, reduce)
Floor | Shop | Tenant | Area |  |  |  | Start | End | Terminate |  |  |  | Rental |  |  |  |  |  |  |  |  |  |  |  | Start | End | Start | End | $ | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00
B2 | 1 | ABC | 1216 | qtr1 |  |  | 2020-12-16 00:00:00 | 2023-05-02 00:00:00 |  |  |  |  | 100 |  |  |  |  |  |  |  |  |  |  |  | 2020-12-16 00:00:00 | 2021-01-15 00:00:00
 |  | xyz |  | qtr2 |  |  | 2021-01-25 00:00:00 | 2024-12-31 00:00:00 |  |  |  |  | 150 |  |  |  |  |  |  |  |  |  |  |  | 2021-02-01 00:00:00 | 2021-03-20 00:00:00
B2 | 2 | DEF | 450 | qtr1 |  |  | 2022-01-01 00:00:00 | 2023-07-15 00:00:00 |  |  |  |  | 2000 |  |  |  |  |  |  |  |  |  |  |  | 2022-01-01 00:00:00 | 2022-02-28 00:00:00 | 2022-07-01 00:00:00 | 2022-08-31 00:00:00 | -300
 |  | scr |  | qt2 |  |  | 2019-07-20 00:00:00 | 2023-04-19 00:00:00 |  |  |  |  | 3000 |  |  |  |  |  |  |  |  |  |  | 2022-04-02 00:00:00
 |  | sdf |  | qtr3 |  |  | 2020-07-20 00:00:00 | 2022-12-02 00:00:00 |  |  |  |  | 4000
 |  | rty |  | qtr4 |  |  | 2021-07-20 00:00:00 | 2022-03-19 00:00:00 |  |  |  |  | 5000
Spreadsheet: 852586d1702569684-weighted-average-rent-per-square-foot-for-plaza-if-lease-started-after-a-certain-date-working-rent-roll-2
Sheet: Increase or Decrease

 | Commercial Workbook | Rents in Place | Tenant Recoveries in place | Other Income | Potential Gross Income | Effective Gross Income | Total Expenses | Reserves | Actual NOI | As Is Adjustment | Actual NOI (after As Is Adj.) | Normalized NOI | Value |  |  | Proforma 2020 | Proforma 2021 | % Inc./Dec. | Absolute Difference
 | Proforma 2020 | 1929465.72 | 628753.9094390118 |  | 2558219.629439012 | 2430308.647967061 |  |  |  | -127910.9814719506 |  | 1540507.088528049 | 23701000 |  | Real Estate Taxes | 321575.27 | 324848.4967
 | Proforma 2021 | 1875741.72 | 609895.0379406109 |  | 2511841.757940611 | 2511841.757940611 |  |  |  | 0 |  | 1628583.612602392 | 25056000 |  | Property Insurance | 11239.36 | 11205.8129
 | % Inc./Dec. |  |  |  |  |  |  |  |  |  |  |  |  |  | Utilities | 30422.08 | 20400.4478
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Repairs and Maintenance | 155154.05 | 174828.0697
 | Commercial Workbook: |  | 2018 Actual | 2019 Actual | 2020 Actual | [NAME] | 2021 Budget |  | Other Income 1 | Other Income 2 |  |  |  |  | [NAME]
 | Annual Recoveries |  |  |  |  |  |  |  | 0 |  |  |  |  |  | Management Fees | 72909.25943901183 | 75355.25273821832
 | Total Expenses - Non-Rec. - Reserves |  |  |  |  |  |  |  | 26205 |  |  |  |  |  | Payroll & Benefits
 | Recovery Ratio |  |  |  |  |  |  |  |  |  |  |  |  |  | Advertising & Marketing
 | Total Operating Expenses |  |  |  |  |  |  |  |  |  |  |  |  |  | Professional Fees | 20918.27 | 2509.0079
 | Non-Recoverable Expenses |  |  |  |  |  |  |  |  |  |  |  |  |  | General and Administrative | 16535.62 | 11564.7576
 | Reserves |  | 0 | 0 | 0 |  | 0 |  |  |  |  |  |  |  | Other Expenses | 0 | 1498.65
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Other Expenses | 248710 | 248710
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ground Rent
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Reserves* | 12337.65 | 12337.65
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Operating Expenses
 |  | Multi-Family
 | Multi-Family Workbook | Leased Rental Revenue | Other Income | Potential Gross Income | Effective Gross Income | Total Expenses | Reserves | Actual NOI | As Is Adjustment | Actual NOI (after As Is Adj.) | Normalized NOI | Value
 | Proforma 2020
 | Proforma 2021 |  |  |  |  |  |  |  | 0
 | % Inc./Dec.
 |  | Commercial |  |  |  |  |  |  |  |  | Multi-Family
 | Multi-Family Workbook | Rents in place | Reimbursements | Other Income 1 | Other Income 2 | Potential Gross Income | Effective Gross Income | Total Potential Gross Income | Total Effective Gross Income |  | Other Income 1 | Other Income 2
 | Proforma 2020 | 0 | 0 | 0 | 0
 | Proforma 2021 | 0 | 0 | 0 | 0
 | % Inc./Dec.
Spreadsheet: d20fe2ed-2a41-43d5-b95f-6f4514b1e51c
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
EMA | Test | EMA | Endomysial Antibodies (IgA), Serum | Endomysial Abs, S (IgA) | Staining of [NAME] by Indirect Immunofluorescence Assay (IFA) for IgA Endomysial Antibodies (EMA) | Serum Gel Tube: SGT |  |  | 2 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 2 mL Forms: If not ordering electronically, submit a Dermatopathology/Immunodermatology Request Form (Supply T060) with the specimen. | Adults: 1 mL/Pediatric: 0.5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK Lipemia	Mild reject; Gross reject Icterus	Mild OK; Gross reject Other	NA | Report includes presence and titer of circulating IgA endomysial antibodies. Negative in normal individuals; also negative in dermatitis herpetiformis or celiac disease patients adhering to gluten-free diet. See Results of IF Testing* in Cutaneous Immunofluorescence Testing in Special Instructions. | Monday through Friday; 7 a.m.-5 p.m. | 2 days (not reported on Saturday or Sunday) | 7 days* | 1 | 86256 |  |  |  |  | Rochester
EMA | [NAME] | SERUM | Serum |  |  |  | Refrigerated
EMA | Result | 9360 | Endomysial Ab | Endomysial Ab | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31365-0 | [NAME]:ACnc:Pt:Ser:Ord: