tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 291531d1390326003-conditional-formatting-not-update-through-whole-worksheet-spoof-problem
Sheet: THISSHEET

 |  |  |  |  |  |  | 01 | 02 | 03 | 04 | 05 | 06 | 07 | 08 | 09 | 10 | 11 | 12
 | Status Overview |  |  |  |  |  | 2014
 | Index | Prio | Control | Country | City | Player | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |  | Comments
 | 1 | 1 | Left | Japan | London
 | 2 | 1 | Left | Denmark | Southampton
 | 3 | 1 | Left | England | Leeds
 | 4 | 1 | Left | Scotland | Bristol
 | 5 | 1 | Left | Germany | [NAME]
 | 6 | 1 | Left | England | Leeds
 | 7 | 1 | Left | Scotland | Bristol
 | 8 | 1 | Left | USA | Essex
 | 9 | 1 | Left | China | Swansea
 | 10 | 1 | Left | Germany | [NAME]
 | 11 | 1 | Left | China | Norfolk
 | 12 | 1 | Left | Japan | Birmingham
 | 13 | 1 | Left | Belgium | Texas
 | 14 | 1 | Left | China | Reading
 | 15 | 1 | Left | China | Swansea
 | 16 | 1 | Left | China | Norfolk
 | 17 | 1 | Left | Bangladesh | Chester
 | 18 | 1 | Left | Iceland | Derby
 | 19 | 2 | Left | China | Reading
 | 20 | 2 | Left | China | Bath
 | 21 | 2 | Left | Germany | Washington
 | 22 | 2 | Left | Slovenia | Arizona
 | 23 | 2 | Left | Iceland | Derby
 | 24 | 2 | Left | India | Bradford
 | 25 | 2 | Left | Australia | Brighton
 | 26 | 2 | Left | New Zealand | Cambridge
 | 27 | 2 | Left | Greenland | Oxford
 | 28 | 3 | Left | Madagascar | Carlisle
 | 29 | 3 | Left | Bangladesh | Chester
 | 30 | 3 | Left | France | New York
 | 31 | 3 | Left | Sudanwan | Poole
 | 32 | 3 | Left | Iceland | [NAME]
 | 33 | 3 | Left | [NAME] | Gloucester
 | 34 | 3 | Left | Belgium | Texas
 | 35 | 3 | Left | Tibet | Leister
 | 36 | 3 | Left | Turkey | Lincoln
 | 37 | 3 | Left | Australia | Newcastle
 | 38 | 1 | Right | Denmark | [NAME]
 | 39 | 2 | Right | Argentina | [NAME]
 | 40 | 2 | Right | Brazil | Peterborough
 | 41 | 3 | Right | Romania | Preston
 | 42 | 1 | Up | Madagascarins | Salisbury
 | 43 | 1 | Up | Holland | New Jersey
 | 44 | 1 | Up | Cech | Stoke on Trent
 | 45 | 1 | Up | USA | Sunderland
 | 46 | 1 | Up | Canada | Wells
 | 47 | 1 | Up | Canada | Wolverhampton
 | 48 | 1 | Up | Canada | York
 | 49 | 1 | Up | Ethiopia | [NAME]
 | 50 | 1 | Up | Sudan | Dundee
 | 51 | 2 | Up | North Korea | Aberdeen
 | 52 | 2 | Up | South Africa | Edinburgh
 | 53 | 2 | Up | Ivory Coast | Glasglow
 | 54 | 2 | Up | Iceland | Inverness
 | 55 | 2 | Up | Wales | Perth
 | 56 | 2 | Up | Wales | Stirling
 | 57 | 2 | Up | South Korea | [NAME]
 | 58 | 2 | Up | Ireland | Belfast
 | 59 | 2 | Up | Tibet | Dublin
 | 60 | 2 | Up | Lithuania | Lisburn
 | 61 | 3 | Up | Finland | Newry
 |  |  | Left |  | Left Target
 |  |  | Left |  | Left Achieved
 |  |  | Right |  | Right Target
 |  |  | Right |  | Right Achieved
 |  |  | Up |  | Up Target
 |  |  | Up |  | Up Achieved
 |  |  |  | Total Target
 |  |  |  | Total Achieved
Spreadsheet: 0c21f5c8-72c6-4ba9-9e8a-56d96b5a0f06
Sheet: Page 2

 | Permit No.: | WQ0012796 |  | Facility Name: |  | Lakeview Packing Company |  |  |  |  |  | County: |  | Greene |  | Month: |  |  |  | Year:
 |  | Field Name: |  | 6 |  | Field Name: |  | 7 |  | Field Name: |  | 8 |  | Field Name: |  |  |  | Field Name:
 |  | Area (acres): |  | 1.11 |  | Area (acres): |  | 1.11 |  | Area (acres): |  | 1.47 |  | Area (acres): |  |  |  | Area (acres):
 |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop:
 |  | Load Type: |  | PAN |  | Load Type: |  | PAN |  | Load Type: |  | PAN |  | Load Type: |  |  |  | Load Type:
 |  | [NAME]? |  |  |  | [NAME]? |  |  |  | [NAME]? |  |  |  | [NAME]? |  |  |  | [NAME]?
 | Date | Volume Applied |  |  |  | Volume Applied |  |  |  | Volume Applied |  |  |  | Volume Applied |  |  |  | Volume Applied
 | Month | gal | mg/L | lbs/ac | lbs/ac | gal | mg/L | lbs/ac | lbs/ac | gal | mg/L | lbs/ac | lbs/ac | gal | mg/L | lbs/ac | lbs/ac | gal | mg/L | lbs/ac | lbs/ac
Spreadsheet: 63031d1264000930-getting-data-from-one-sheet-based-on-values-item
Sheet: sorted

Item # | Name | Item Type
Spreadsheet: 2a2748b5-d80d-4f64-9aaf-796d18f8db3f
Sheet: Student Teaching Admission

Cert Level | # Students | # Not Eligible with 2.75 Rule | Overall GPA            < 2.75 | Content GPA < 2.75 | Pedagogy GPA <2.75 | Retintion
ECH-6 GEN | 51 | 1 | 1 | 1 |  | 98%
[NAME] | 41 | 4 | 1 | 3 | 1 | 90%
4 thru 8 | 5 | 1 | 1 |  |  | 80%
All Level Drama | 2 |  |  |  |  | 100%
All Level Music | 11 |  |  |  |  | 100%
All Level PE | 3 | 1 | 1 | 1 | 1 | 66%
All Level Spanish | 2 |  |  |  |  | 100%
8-12 COMM | 1 |  |  |  |  | 100%
8-12 CHEM | 1 |  |  |  |  | 100%
8-12 DRAM | 1 |  |  |  |  | 100%
8-12 ENG | 9 |  |  |  |  | 100%
8-12 HIST | 9 | 5 | 3 | 4 |  | 44%
8-12 MATH | 7 |  |  |  |  | 100%
8-12 LIFE SCI | 2 | 1 |  | 1 |  | 50%
6-12 AG | 5 | 1 | 1 |  |  | 0.8
Total | 150 | 14 | 8 | 10 | 2 | 0.9
Spreadsheet: 99999d1298490973-changing-4a-into-a-single-number-exam-tracker-for-help
Sheet: Sheet1

Surname Forename | Gender | Target grade | 5EH01 - English Today - Studying Written Language (Reading) (20) | 5EH01 - English Today - Writing i+ii (13) | 5EH01 - English Today - Writing iii (7) | 5EH01 - English Today (40) | PREDICTED GRADE 5EH01 - English Today (40) | [NAME] achieved | Difference between target and grade achieved
Student A | F | 4a | 5 | 6 | 3 | 14 | E | 4a
Student B | F | 4c | 9 | 6 | 2 | 17 | E | 4c
Student C | F | 3b | 6 | 7 | 3 | 16 | E | 4b
Student D | F | 4c | 7 | 8 | 4 | 19 | D | 3a
Student E | F | 4a | 8 | 6 | 5 | 19 | D | 3c
Student F | F | 3a | 9 | 5 | 2 | 16 | E | 4b
Student G | M | 3a | 12 | 4 | 3 | 19 | D | 4c
Student H | F | 3c | 17 | 6 | 4 | 27 | C | 4b
Student I | F | 3b | 3 | 7 | 5 | 15 | E | 3b
Spreadsheet: 718603d1613231567-excel-copy-data-to-another-sheet-without-vlookup-for-a-price-calc-quote-calculator-using-index-aggregate-mrkovacic-
Sheet: Sheet1

MyCompany
 |  |  |  | DATE:
 |  |  |  | VALID UNTIL:
CUSTOMER
Home Buyer:
Lot:
Community:
PROPOSAL
[NAME] |  |  | Price | QTY | AMOUNT
 |  |  | [42] | Subtotal
TERMS AND CONDITIONS
1. Customer will be billed after indicating acceptance of this quote
2. Payment will be due prior to delivery of service and goods
3. Please fax or mail the signed price quote to the address above
[NAME] (sign below):
Signature: | x ___________________________________________
Print Name: | x ___________________________________________
Date: | x ___________________________________________
If you have any questions about this price quote, please contact us
[EMAIL]
Thank You For Your Business!
Spreadsheet: 480032d1473743256-conditional-formatting-based-on-another-column-example_solved
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WAREHOUSE
TASK | START DATE | START TIME | START DATE & TIME | FINISH DATE | FINISH TIME | FINISH DATE & TIME | DURATION | # [NAME] |  | START TIME | FINISH TIME (PRE ROUNDING) | FINISH TIME | SHIFT DURATION | BREAK | BILLABLE HOURS | FLT OPERATORS | STOREMAN | A&D CREW
A | 2016-10-04 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
Spreadsheet: 117634d1312918828-looking-for-a-formula-for-a-template-to-pull-data-under-specific-criteria-example
Sheet: Sheet1

Number that needs to be pulled | Estimate Date | Actual Date | Difference in days
100 | 2011-05-01 00:00:00 | 2011-05-07 00:00:00
100 | 2011-05-01 00:00:00 | 2011-05-07 00:00:00
100 | 2011-05-01 00:00:00 | 2011-05-07 00:00:00
100 | 2011-05-01 00:00:00 | 2011-05-07 00:00:00
200 | 2011-06-21 00:00:00 | 2011-06-30 00:00:00
200 | 2011-06-21 00:00:00 | 2011-06-30 00:00:00
200 | 2011-06-21 00:00:00 | 2011-06-30 00:00:00
200 | 2011-06-21 00:00:00 | 2011-06-30 00:00:00
200 | 2011-06-21 00:00:00 | 2011-06-30 00:00:00
150 | 2011-06-30 00:00:00 | 2011-07-03 00:00:00
120 | 2011-07-01 00:00:00 | 2011-07-03 00:00:00
Spreadsheet: 817827d1676462713-formula-help-linking-other-workbooks-with-changing-names-data2
Sheet: Sheet1

Name | Age | City | Country | CellNos
E | 34 | EE | EEE | 2222222222
F | 42 | FF | FFF
G | 38 | GG | GGG
H | 31 | HH | HHH
Spreadsheet: 759609d1639616710-sum-if-array-produces-zero-arrayproblem
Sheet: Boxes

Date | Name | DM
2021-10-22 00:00:00 | P1 | 14.01666666666667
2021-10-22 00:00:00 | P2 | 14.95 |  |  | 0
2021-10-22 00:00:00 | P3 | 6.8 |  |  | 0
2021-10-22 00:00:00 | P4 | 9.616666666666667 |  |  | 0
2021-10-22 00:00:00 | P5 | 14.08333333333333 |  |  | 0
2021-10-22 00:00:00 | P6 | 11.26666666666667 |  |  | 0
2021-10-22 00:00:00 | P7 | 5.766666666666667 |  |  | 0
2021-10-22 00:00:00 | P8 | 13.3 |  |  | 0
2021-10-22 00:00:00 | P9 | 8.383333333333333 |  |  | 0
2021-10-22 00:00:00 | P10 | 3.55 |  |  | 0
2021-10-20 00:00:00 | P1 | 9.783333333333333 |  |  | 0
2021-10-20 00:00:00 | P2 | 13 |  |  | 0
2021-10-20 00:00:00 | P3 | 8.2 |  |  | 0
2021-10-20 00:00:00 | P4 | 13.16666666666666 |  |  | 0
2021-10-20 00:00:00 | P1 | 9.333333333333334 |  |  | 0
2021-10-20 00:00:00 | P6 | 8.033333333333333 |  |  | 0
2021-10-20 00:00:00 | P7 | 9.616666666666667 |  |  | 0
2021-10-20 00:00:00 | P8 | 8.683333333333334 |  |  | 0
2021-10-20 00:00:00 | P9 | 4.816666666666666 |  |  | 0
2021-10-20 00:00:00 | P1 | 4.483333333333333 |  |  | 0
Spreadsheet: 885181d1734612532-color-the-cell-in-one-column-based-on-the-color-of-another-cell-in-another-column-colors-to-forum
Sheet: Sheet1

Week 1 | Mon | 2024-01-01 00:00:00
 | Tue | 2024-01-02 00:00:00 |  |  |  | Red
 | Wed | 2024-01-03 00:00:00 |  |  |  | Red
 | Thu | 2024-01-04 00:00:00 |  |  |  | Red
 | Fri | 2024-01-05 00:00:00 |  |  |  | Red
Week 2 | Mon | 2024-01-08 00:00:00 |  |  |  | Green
 | Tue | 2024-01-09 00:00:00 |  |  |  | Green
 | Wed | 2024-01-10 00:00:00 |  |  |  | Green
 | Thu | 2024-01-11 00:00:00 |  |  |  | Blue
 | Fri | 2024-01-12 00:00:00 |  |  |  | Yellow
Week 3 | Mon | 2024-01-15 00:00:00 |  |  |  | Yellow
 | Tue | 2024-01-16 00:00:00 |  |  |  | Blue
Spreadsheet: 768526d1645012614-running-values-based-on-criteria-errors-in-a-table-learnexcel22
Sheet: Daily

Date | Details | Category | Paids | Sub Details | Income | Expenses | Balance | Column1 | Column2
2022-01-01 00:00:00 | Brought Forward | Opening | Cash |  | 100
2022-01-01 00:00:00 | Brought Forward | Opening | ENBD |  | 669.3
2022-01-01 00:00:00 | Brought Forward | Opening | Pay IT |  | 1000
2022-01-01 00:00:00 | Brought Forward | Opening | NoL |  | 113
2022-01-01 00:00:00 | Brought Forward | Opening | SIB |  | 795.55
2022-01-06 00:00:00 | December | Salary | ENBD |  | 1000
2022-01-09 00:00:00 | Dinner | Food | Cash |  | 100 | 0
2022-01-09 00:00:00 | Water | Beverages | Cash |  |  | 10
 |  |  | Cash |  | 100
2022-01-09 00:00:00 | Breakfast | Food | Cash |  |  | 20
2022-01-09 00:00:00 | RTA | Transport | Cash |  |  | 30
2022-01-09 00:00:00 | Transport | Transport | Cash | Car lift January |  | 40
2022-01-09 00:00:00 | Dinner | Food | Cash |  | 100 | 0
2022-01-10 00:00:00 | Office | OfficeRent | Cash | Rent | 500
2022-01-10 00:00:00 | Office | LoanReturn | Cash | Amazon | 969
2022-01-10 00:00:00 | Lunch | Food | ENBD | Office Lunch |  | 18.75
2022-01-10 00:00:00 | Dinner | Food | Cash |  |  | 17
2022-01-11 00:00:00 | Rent | Room | Cash | January Rent |  | 700
2022-01-11 00:00:00 | Dinner | Food | Cash |  |  | 10
2022-01-12 00:00:00 | Dinner | Food | Cash |  |  | 20
2022-01-12 00:00:00 | Bilal | OutLoan | Cash |  |  | 800
2022-01-13 00:00:00 | Breakfast | Food | Cash |  |  | 7
2022-01-13 00:00:00 | Dinner | Food | Cash |  |  | 10
2022-01-14 00:00:00 | Breakfast | Food | Cash |  |  | 5
2022-01-14 00:00:00 | Lunch | Food | Cash |  |  | 13
2022-01-14 00:00:00 | Dinner | Food | Cash |  |  | 5
2022-01-15 00:00:00 | Breakfast | Food | Cash |  |  | 4
Spreadsheet: 0a4f370c-bc60-4639-895b-46749d1688ec
Sheet: 11c

Product | AUD** | CAD | CHF | DKK | KRW | NOK | NZD | SEK | ZAR | TOTAL
Basis* | <100 | <100 | <100 |  |  |  |  |  |  | <100
FRA |  |  | 898 | <100 |  | 630 |  | 654 |  | 2182
IRS- [NAME] | 1045 | 818 | 314 | <100 |  | <100 | 260 | 314 | 462 | 3213
OIS |  | <100 | <100 |  |  |  |  |  |  | <100
VNS
Zero Coupon |  |  |  |  |  |  |  | <100 |  | <100
TOTAL | 1045 | 818 | 1212 | <100 |  | 630 | 260 | 968 | 462 | 5395
Estimated swap transaction volumes, week ending January 11, by product type and major currency (millions of USD), all participant types, cleared and uncleared.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown.
*See Data Dictionary for product descriptions.
**See Data Dictionary for major currency descriptions.
***N/A indicates that data are not currently available.
Note: Transaction volumes currently include house and client trades by FCMs in the interest rate asset class.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 1926df0d-6cd8-45e0-b651-4166c2f5df53
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
FFLUC | Test | FFLUC | Fluconazole (Diflucan) | Fluconazole (FLU) | [NAME] dilution |  |  |  |  |  | Container/Tube: Agar slant or other appropriate media [NAME] Organism in pure culture  Collection Instructions: 1.	Organism must be in pure culture, actively growing. 2.	Place specimen in a large infectious container (Supply T146) and label as an etiologic agent. |  | Specimens other than	Actively growing mold in pure culture Anticoagulants other than	NA Hemolysis	NA Thawing	NA Lipemia	NA Icteric	NA | Test Performed by:  U.T. Health Science Ctr San Antonio                                        7703 [NAME]Department of Pathology                                        Fungal Lab                                        San Antonio, TX 78229-3900 | Monday | 4-10 days | 6-12 days |  | Profile |  |  |  |  | U.T. Health Science Ctr San Antonio
FFLUC | [NAME] | VARIES | Varies |  |  |  | Ambient
FFLUC | Order Question | Z2195 | Source |  | Plain Text
FFLUC | Order Question | Z2194 | Received as (Organism) |  | Plain Text
FFLUC | Result | Z2195 | Source | Source | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FFLUC | Result | Z2194 | Received as (Organism) | Received as (Organism) | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FFLUC | Result | Z2196 | Result | Result | Alphanumeric |  |  |  |  | ug/mL |  |  |  |  |  |  |  |  |  | In Process
FFLUC | Result | Z2200 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FFLUC | Billing Component | FFLUC |  | microdilution or agar dilution,minimum, lethal concentration |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 87187
FFLUC | Billing Component | FFLUC |  | microdilution or agar dilution |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 87186
FFLUC | Billing Component | FFLUC |  | macrobroth dilution method |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 87188
Spreadsheet: 866048d1712984077-help-for-creating-major-league-table-24
Sheet: table

 | WORLD FOOTBALL LEAGUE |  |  |  |  |  |  |  |  |  | VISIT EXCELTEMPLATE.NET FOR MORE TEMPLATES AND UPDATES
 | Position | Team | P | W | D | L | F | A | [NAME] | Pts | HOME GAME |  |  |  |  |  |  |  | AWAY GAME
 |  |  |  |  |  |  |  |  |  |  | P | W | D | L | F | A | [NAME] | Pts | P | W | D | L | F | A | [NAME] | Pts
 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 | Position | Team | P | W | D | L | F | A | [NAME] | Pts | HOME GAME |  |  |  |  |  |  |  | AWAY GAME
 |  |  |  |  |  |  |  |  |  |  | P | W | D | L | F | A | [NAME] | Pts | P | W | D | L | F | A | [NAME] | Pts
 | 1
Spreadsheet: 111504d1307884533-configure-your-filters-to-be-by-data-entry-enquiry-book
Sheet: Sheet1

43 | [NAME] [NS] | [NAME] [NS] | [NAME] is not working | (2) Normal | Closed | HeadOffice |  |  | 2011-01-19 10:08:53 | 2011-02-14 11:10:56
430 | [NAME] [NS] | [NAME] [NS] | configure security Cameras on CEO Laptop | (2) Normal | Closed | HeadOffice |  |  | 2011-03-21 08:52:29 | 2011-03-21 10:56:23
531 | [NAME] [NS] | [NAME] [NS] | IP Phone Ringer sound is off | (2) Normal | Closed | HeadOffice |  |  | 2011-03-29 12:55:23 | 2011-03-29 12:58:28
637 | [NAME] [NS] | [NAME] [NS] | Can't log on to oracle | (2) Normal | Closed | HeadOffice | Application | Others | 2011-04-11 07:46:01 | 2011-04-11 08:32:14
656 | [NAME] [NS] | [NAME] [NS] | Cannot open requisition in Oracle program | (2) Normal | Closed | Factory | Application | Others | 2011-04-12 10:37:14 | 2011-04-12 10:53:52
24 | [NAME] [NS] | [NAME] [NS] | [NAME] | (2) Normal | Closed | HeadOffice |  |  | 2011-01-17 08:31:33 | 2011-03-13 12:24:46
154 | [NAME] [NS] | [NAME] [NS] | Outlook do not display user details | (1) High | Closed | HeadOffice |  |  | 2011-02-16 09:43:31
353 | [NAME] [NS] | [NAME] [NS] | Create sheet for usernames of Work centre printers | (2) Normal | Closed | Factory |  |  | 2011-03-09 11:14:09 | 2011-03-09 12:05:41
741 | [NAME] [NS] | [NAME] [NS] | change printer toner | (2) Normal | Closed | Factory | Other Equipment | [NAME] | 2011-04-26 13:14:53 | 2011-04-27 06:11:19
721 | [NAME] [NS] | [NAME] [NS] | Print Excel sheet from USB flash | (2) Normal | Closed | Factory | Other Equipment | Other | 2011-04-20 14:36:08 | 2011-04-20 14:38:26
Spreadsheet: 702562d1604414271-depreciation-formula-using-drop-down-list-2-adjusted-depreciation-using-drop-down-list-my-copy
Sheet: Sheet1

Kindly asking for a depreciation formula for columns M, N and O. Please note that in column L8, L9, L10 , there is a drop down list where you select either SLN or DB.
** Land and [NAME] should not be depreciated
** In case of disposal ([NAME]) Annual depreciation should be zero
** After the useful life of the asset depreciation should not be calculated.
 |  |  |  |  |  |  | SLN
 |  |  |  |  |  |  | DB
Asset Code | Asset Name | Asset Category | Acquisition Date | Cost | Salvage | Useful life | End of Useful Life | Years To Date | Valuation | Disposals | Depreciation Method | Accumulated Depreciation | Annual Dpreciation | Asset Value end of Year | Profit / (Loss) on Disposal | Revaluation Gain / (Loss)
LB001 | Land and Buiding | Land and Building | 2015-04-10 00:00:00 | 60000 |  |  |  |  |  |  | SLN
OA001 | Computer | Office Appliance | 2018-05-03 00:00:00 | 5000 | 1000 | 5 |  |  |  | 2000 | SLN
MV001 | Motor Vehicle | Motor Vehicles | 2016-10-01 00:00:00 | 12000 | 3000 | 5 |  |  |  |  | DB
ME001 | Sawmill | Machinery and Equipment | 2020-01-01 00:00:00 | 10000 | 2000 | 8 |  |  |  |  | SLN
 | Printer | Office Appliance | 2009-03-10 00:00:00 | 2000 | 300 | 10 |  |  |  |  | DB
 | Truck | Motor Vehicles | 2010-05-30 00:00:00 | 25000 | 5000 | 10 |  |  |  |  | DB
Desired Outcome
Asset Code | Asset Name | Asset Category | Acquisition Date | Cost | Salvage | Useful life | End of Useful Life | Years To Date | Valuation | Disposals | Depreciation Method | Accumulated Depreciation | Annual Dpreciation | Asset Value end of Year | Profit / (Loss) on Disposal | Revaluation Gain / (Loss) | DB WORKINGS
LB001 | Land and Building | Land and Building | 2015-04-10 00:00:00 | 60000 | 1 | 1
OA001 | Computer | Office Appliance | 2018-05-03 00:00:00 | 10000 | 1000 | 10 |  |  |  |  | SLN
MV001 | Motor Vehicle | Motor Vehicles | 2016-10-01 00:00:00 | 10000 | 1000 | 10 |  |  |  |  | DB
ME001 | Sawmill | Machinery and Equipment | 2018-01-01 00:00:00 | 10000 | 2000 | 10 |  |  |  | 2000 | SLN
 | Printer | Office Appliance | 2009-03-10 00:00:00 | 7000 | 300 | 10 |  |  |  |  | SLN
LB002 | Land and Building | Land and Building | 2011-05-30 00:00:00 | 40000 | 1 | 1 |  |  | 70000 |  | DB
Spreadsheet: 806813d1669610830-copy-group-of-cells-to-another-location-based-on-cell-content-groups
Sheet: Sheet1

Group 1 |  |  | Group 2 |  |  | Group 3 |  |  | Group 4 |  |  | Group 5
[NAME] | X | Y | Ringer | X | Y | Dawson | X | Y | Huston | X |  | Hemphill | X | Y
Flowers | X |  | Brooks | X |  | Fisher | X | Y | [NAME] | X |  | Rapley | X
Hardy | X |  | McDowell | X |  | [NAME] | X | Y | Eggleton | X | Y | Mahoney | X | Y
McCallum | X | y | [NAME] | X | Y | Watson | X | Y | Youngman | X |  | Bartels | X | Y
Sunderland | X | Y | [NAME] | X |  | Scott | X | Y | Kruska | X | Y | Thiriet | X
Naylor | X | Y | Forster | X |  | Nicholson | X |  | Richards | X |  | Cotteril | X | Y
Reidy | X |  | Peach | X | Y | Jasek | X |  | Simmons | X |  | [NAME] | X
[NAME] | X |  | Perkins | X | Y | Milligan | X |  | [NAME] | X | Y | Walters | X | Y
Staples | X | Y | Vincent | X | Y | Townsend | X |  | Baxter | X | Y | Talliard | X
Compliance |  |  | Klein | X |  | Clay | X |  | [NAME] | X | Y | Starling | X
Group A |  | Boat | Group B |  | Boat | Group  C |  | Boat | Group D |  |  | Group E
Spreadsheet: phillip_allen__29604__SM134 Proforma
Sheet: Comps

 |  |  |  | ONE BEDROOM |  |  |  |  |  |  |  |  |  |  | TWO BEDROOMS |  |  |  |  |  |  |  |  | THREE BEDROOMS
 |  |  |  | SMALLER |  |  |  |  | LARGER |  |  |  |  | ONE BATH |  |  |  |  | TWO BATH |  |  |  |  | TWO BATH |  |  |  |  | THREE & THREE 1/2 BATH |  |  |  |  | FOUR BEDROOMS |  |  |  |  | THREE BATH |  |  |  |  | FOUR BATH
 | Total Units | Age |  | Size | Rent | Rent/SF | Rent/Bdrm |  | Size | Rent | Rent/SF | Rent/Bdrm |  | Size | Rent | Rent/SF | Rent/Bdrm |  | Size | Rent | Rent/SF | Rent/Bdrm |  | Size | Rent | Rent/SF | Rent/Bdrm |  | Size | Rent | Rent/SF | Rent/Bdrm |  | Size | Rent | Rent/SF | Rent/Bdrm |  | Size | Rent | Rent/SF | Rent/Bdrm |  | Size | Rent | Rent/SF | Rent/Bdrm
[NAME] | 173 | 1 |  | 477 | 650 | 1.36 | 650 |  |  |  |  |  |  |  |  |  |  |  | 800 | 1000 | 1.25 | 500 |  |  |  |  |  |  | 944 | 1374 | 1.46 | 458 |  | 1100 | 1600 | 1.45 | 400
The [NAME] | 152 | 3 |  | 689 | 705 | 1.02 | 705 |  | 806 | 755 | 0.94 | 755 |  | 988 | 910 | 0.92 | 455 |  | 1105 | 1025 | 0.93 | 512.5 |  | 1250 | 1210 | 0.97 | 403.33 |  |  |  |  |  |  | 1350 | 1624 | 1.2 | 406
Hillside Ranch | 258 | 3 |  | 501 | 600 | 1.2 | 600 |  | 755 | 725 | 0.96 | 725 |  | 886 | 810 | 0.91 | 405 |  | 933 | 900 | 0.96 | 450 |  |  |  |  |  |  |  |  |  |  |  | 1556 | 1880 | 1.21 | 470
Sterling Univ. Apts. | 192 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1058 | 1064 | 1.01 | 532 |  |  |  |  |  |  | 1000 | 1281 | 1.28 | 427
Sterling Univ. Apts. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1058 | 976 | 0.92 | 488
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 990.8 | 993 | 1.01 | 496.5
SM134 | 134 | 0 |  | 0 | 0 |  |  |  | 0 | 0 | 0 | 0 |  |  |  |  |  |  | 1107 | 1150
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1198 | 1200
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 600
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1198 |  | 1.25
Spreadsheet: 762331d1641496135-vlookup-not-incrementing-when-copying-book1
Sheet: Sheet1

 | Spreadsheet 1 |  | Spreadsheet 2
 | Part # |  | Part # | Ref 1 | Ref 2 | Ref 3 | Ref 4 | Ref 5 | Ref 6 | Ref 7 | Ref 8 | Ref 9 | Ref 10 | Ref 11 | Ref 12 | Ref 13 | Ref 14 | Ref 15
 | 4270057100 |  | 4270057100 | 71739679 | 71753274 | 71773493 | [PHONE] | 716061 | OCV9502 | BMS54529 | VTS106 | CV0009 | OCV003 | 12655420 | 12578517 | 12628347 | 12646783 | 12679099
 | [NAME]
 | 4270057100
 | Expected Result
 | 4270057100 |  |  | 71739679 | 71753274 | 71773493 | [PHONE] | 716061 | OCV9502 | BMS54529 | VTS106 | CV0009 | OCV003 | 12655420 | 12578517 | 12628347 | 12646783 | 12679099