tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 838177d1690806048-duplicate-values-within-same-row-example-duplicate-values
Sheet: test

NA_2021_S1 | NA_2021_S2 | NA_2022_S1 | NA_2022_S2 | NA_2023_S1
0.5 | F | F.5 | 1.0 | 1.5
D | 0.5 | F | F.5 | 1.0
0.5 | F | F | F.5 | 1.0
0.5 | F | 1.0 | 1.5 | 2.0
F | F.5 | 1.0 | 2.0 | 2.5
D | 0.5 | 0.5 | F.5 | 1.0
0.5 | F | F.5 | F.5 | 1.0
F | F.5 | 1.0 | 1.5 | 2.0
0.5 | F | 1.0 | 1.5 | 2.0
0.5 | F | F.5 | 1.5 | 2.5
0.5 | F | 1.0 | 1.5 | 2.0
0.5 | F | F | F.5 | F.5
F | F.5 | 1.0 | 2.0 | 2.5
0.5 | F | F | F.5 | F.5
0.5 | F | F.5 | 1.0 | 1.5
D | 0.5 | 0.5 | F.5 | 1.0
F | F.5 | 1.0 | 1.5 | 2.0
0.5 | F | F | F.5 | 1.0
0.5 | 0.5 | F | 1.0 | 1.5
F | F.5 | 1.0 | 1.5 | 1.5
F | F.5 | F.5 | 1.5 | 2.0
0.5 | F | F.5 | 1.0 | 1.5
0.5 | F | F.5 | 1.5 | 2.0
0.5 | F | F.5 | 1.5 | 2.0
0.5 | F | F.5 | F.5 | 1.0
0.5 | F | F.5 | F.5 | 1.0
0.5 | F | F.5 | 1.0 | 1.5
0.5 | 0.5 | F | F.5 | 1.0
0.5 | F | F | F.5 | 1.0
0.5 | F | F.5 | 1.5 | 2.0
0.5 | F | F.5 | 1.0 | 1.5
0.5 | F | F.5 | 1.5 | 1.5
0.5 | F | F.5 | 1.5 | 2.0
0.5 | F | F.5 | 1.0 | 2.0
D | 0.5 | 0.5 | F | F.5
0.5 | F | F | F.5 | 1.0
D | 0.5 | F | F.5 | 1.0
0.5 | F | F.5 | 1.0 | 1.5
0.5 | F | F.5 | 1.5 | 2.0
0.5 | F | F.5 | 1.0 | 1.5
0.5 | F | F | F.5 | 1.0
F | F.5 | 1.0 | 1.5 | 2.0
0.5 | 0.5 | F | F.5 | 1.0
D | D | 0.5 | F | F
0.5 | 0.5 | 0.5 | F.5 | 1.0
D | 0.5 | 0.5 | F | F.5
D | 0.5 | 0.5 | F | F.5
D | 0.5 | 0.5 | F | F.5
F | F.5 | F.5 | 1.5 | 2.0
0.5 | F | F | F.5 | 1.0
F | F.5 | 1.0 | 1.5 | 2.0
0.5 | F | F.5 | 1.0 | 1.5
0.5 | F | F | F | F.5
0.5 | F | F.5 | F.5 | 1.0
0.5 | F | 1.0 | 1.5 | 2.5
0.5 | F | 1.0 | 1.5
0.5 | F | F.5 | F.5
0.5 | 0.5
F | F
0.5 | F
0.5 | 0.5
0.5 | F
0.5
Spreadsheet: 807552d1669941935-help-with-formula-when-ref-a-data-table-in-a-different-column-help
Sheet: Sheet1

Data  A | Data B | doubler | input | location |  |  |  |  |  | Expected results
 |  |  | 0.28 | A |  |  |  |  |  | 0.28 | 0.33
 |  |  | 0.33 | B |  |  |  |  |  | 0.33 | 0.3
 |  |  | 0.3 | C |  |  |  |  |  | 0.3 | 0.36
 |  | x | 0.36 | D |  |  |  |  |  | 0.3 | 0.36
 |  |  | 0.28 | E |  |  |  |  |  | 0.36 | 0.28
 |  |  | 0.22 | F |  |  |  |  |  | 0.28 | 0.22
 |  |  | 0.19 | G |  |  |  |  |  | 0.22 | 0.19
 |  | X | 0.18 | H |  |  |  |  |  | 0.22 | 0.19
 |  | X | 0.16 | I |  |  |  |  |  | 0.22 | 0.19
 |  |  | 0.19 | J |  |  |  |  |  | 0.19 | 0.18
 |  |  | 0.21 | K |  |  |  |  |  | 0.18 | 0.16
 |  |  |  | L |  |  |  |  |  | 0.16 | 0.19
 |  |  |  |  |  |  |  |  |  | 0.19 | 0.21
Spreadsheet: 192149d1352320015-straight-line-depreciation-calculation-stl-depr
Sheet: Sheet1

Purchase Date |  | Useful
(Mnth/Yr) | Cost | Life (yrs) |  | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | Total
Feb2007 | 100000 | 12 |  | 7638.888888888888 | 8333.333333333334 | 8333.333333333334 | 8333.333333333334 | 8333.333333333334 | 8333.333333333334 | 8333.333333333334 | 8333.333333333334 | 8333.333333333334 | 8333.333333333334 | 8333.333333333334 | 8333.333333333334 | 694.4444444444525 |  |  |  | 100000
2007-02-15 00:00:00 | 100000 | 12 |  | 7638.88888888889 | 8333.333333333332 | 8333.333333333332 | 8333.333333333332 | 8333.333333333332 | 8333.333333333332 | 8333.333333333332 | 8333.333333333332 | 8333.333333333332 | 8333.333333333332 | 8333.333333333332 | 8333.333333333332 | 694.4444444444445 | 0 | 0 | 0 | 99999.99999999996
2008-09-01 00:00:00 | 125000 | 12 |  | 0 | 3472.222222222222 | 10416.66666666667 | 10416.66666666667 | 10416.66666666667 | 10416.66666666667 | 10416.66666666667 | 10416.66666666667 | 10416.66666666667 | 10416.66666666667 | 10416.66666666667 | 10416.66666666667 | 10416.66666666667 | 6944.444444444444 | 0 | 0 | 125000
2007-02-13 00:00:00 | 100000 | 7 |  | ?
Spreadsheet: 703642d1605096951-search-box-for-named-ranges-test-case-files
Sheet: Case Type 1

Issue | current status | Reason | summary | note | case |  | note | audit week
Case type 1 | Resolved |  | 1 | Raw data action mismatches with actual action. All mismatch action tasks are under SIV part. | 20000255761826 |  |  | 42
 |  |  | 2 |  | 20000256591610 |  |  | 42
 |  |  | 3 |  | 20000256189409 |  |  | 42
 |  |  |  |  | 20000256128551 |  |  | 42
 |  |  |  |  | 20000256205867 |  |  | 42
 |  |  |  |  | 20000256135862 |  |  | 42
 |  |  |  |  | 20000254891685 |  |  | 42
 |  |  |  |  | 20000256176036 |  |  | 42
 |  |  |  |  | 20000256173191 |  |  | 42
 |  |  |  |  | 20000256204040 |  |  | 42
 |  |  |  |  | 20000256175144 |  |  | 42
 |  |  |  |  | 20000256152502 |  |  | 42
 |  |  |  |  | 20000256572497 |  |  | 42
Issue | current status | Reason | summary | note | case |  | note | audit week
Case type 2 | Resolved |  | 1 | Raw data action mismatches with actual action. All mismatch action tasks are under SIV part. | 20000255761826 |  |  | 42
 |  |  | 2 |  | 20000256591610 |  |  | 42
 |  |  | 3 |  | 20000256189409 |  |  | 42
 |  |  |  |  | 20000256128551 |  |  | 42
 |  |  |  |  | 20000256205867 |  |  | 42
 |  |  |  |  | 20000256135862 |  |  | 42
 |  |  |  |  | 20000254891685 |  |  | 42
 |  |  |  |  | 20000256176036 |  |  | 42
 |  |  |  |  | 20000256173191 |  |  | 42
 |  |  |  |  | 20000256204040 |  |  | 42
 |  |  |  |  | 20000256175144 |  |  | 42
 |  |  |  |  | 20000256152502 |  |  | 42
 |  |  |  |  | 20000256572497 |  |  | 42
Issue | current status | Reason | summary | note | case |  | note | audit week
Case type 3 | Resolved |  | 1 | Raw data action mismatches with actual action. All mismatch action tasks are under SIV part. | 20000255761826 |  |  | 42
 |  |  | 2 |  | 20000256591610 |  |  | 42
 |  |  | 3 |  | 20000256189409 |  |  | 42
 |  |  |  |  | 20000256128551 |  |  | 42
 |  |  |  |  | 20000256205867 |  |  | 42
 |  |  |  |  | 20000256135862 |  |  | 42
 |  |  |  |  | 20000254891685 |  |  | 42
 |  |  |  |  | 20000256176036 |  |  | 42
 |  |  |  |  | 20000256173191 |  |  | 42
 |  |  |  |  | 20000256204040 |  |  | 42
 |  |  |  |  | 20000256175144 |  |  | 42
 |  |  |  |  | 20000256152502 |  |  | 42
 |  |  |  |  | 20000256572497 |  |  | 42
Spreadsheet: 58823d1259083472-excel-2007-how-to-add-items-to-a-dropdown-list-dynamically-by-typing-in-the-dropdown-list-cell-tanf_-_requirement_gathering_template_-final-
Sheet: Case Assignemnt

 |  | DATA Gathering Template
Program | Temporary Assistance - Family Assistance and Safety Net
Function Name | Caseload Management
Activity Name | Case Assignment
Activity Description / Purpose | The process of assigning a case
 |  |  | Activity Predecessor | Activity [NAME] | Activity Input | Activity Output | Activity Successors
Steps | Tasks A task is any action that is being performed to complete a step | What unit does this? (SU) | Who does this? (W) | Applications used / System Interfaces / Tools Is there an automated system supporting the activity? | What happens before this? (P) | What causes the activity to happen (T) | Additional Information that is needed (I) | Is anything produced? (O) | What happens next ? (S) | V | Comments |  |  |  | Questions | Workarounds | Constraints/ Issues | Opportunities | Policy Considerations | Best Practices | Follow-Up | Comments
Assign Case
Accounting | Case Closure
Add Program/Person | Case Management (Undercare)
AFIS | Caseload Management
Agency Conference | Client Services/Benefits Delivery
Application Registration | Eligibility Determination
Authorization | Fair-Hearings & Appeals
[NAME] | Intake
Budget | Referrals
Case Assignment | Screening
Case Closure | Verification
Case Review
[NAME]
CBIC
Change
Clearance
Data Entry
DV-D-A Screen
Emergency Benefits
Expedited
Hearings
Interview
Investigation
Managed Care
Mass Changes
Monitor Activities
Notice
[NAME]
Plan Review
Pre-Screening
Reactivation
Reception
Records Management
Recoupment-Supplemental
Re-Determination-Renewal-Recert
Referral
Sanctions
Service Plan
Verify
Vouchers
Withdraw Application
Other
Spreadsheet: 699839d1602778735-how-to-automatically-copy-cells-ignoring-blank-cells-excel-help-1
Sheet: Sheet1

P M - STATUS |  |  |  |  |  |  |  | P M - STATUS
ASSET | PM [NAME] | WORK ORDER | DATE DUE | DAYS REMAINING |  |  |  | ASSET | PM [NAME] | WORK ORDER | DATE DUE | DAYS REMAINING
S01RBOT004CR02 | Renal Clearflex Autoloader 1 | 1641162 | 44121 | 2 |  |  |  | [NAME] | Weekly Maintenance Checks On Acute Racking Robot | 1640269 | 44120 | 1
 |  |  |  |  |  |  |  | ACUTEMANFILLMC001CR02 | Weekly Inspection Of Acute [NAME] Bag Support | 1640560 | 44120 | 1
 |  |  |  |  |  |  |  | S01RBOT004CR02 | Renal Clearflex Autoloader 1 | 1641162 | 44121 | 2
 |  |  |  |  |  |  |  | S01VACU0006CR01 | Weekly Check Of Oil Levels On Multivac Vacuum Pumps | 1641892 | 44122 | 3
 |  |  |  |  |  |  |  | S01TPLXVAC001CR01 | Weekly Clean Of Multivac Vacuum Filters | 1641878 | 44122 | 3
 |  |  |  |  |  |  |  | S01TANKALL | Monthly Agitator Check | 1623609 | 44123 | 4
[NAME] | Weekly Maintenance Checks On Acute Racking Robot | 1640269 | 44120 | 1
ACUTEMANFILLMC001CR02 | Weekly Inspection Of Acute [NAME] Bag Support | 1640560 | 44120 | 1
S01VACU0006CR01 | Weekly Check Of Oil Levels On Multivac Vacuum Pumps | 1641892 | 44122 | 3
S01TPLXVAC001CR01 | Weekly Clean Of Multivac Vacuum Filters | 1641878 | 44122 | 3
S01TANKALL | Monthly Agitator Check | 1623609 | 44123 | 4
Spreadsheet: 870302d1716841036-can-anyone-tell-what-mistake-i-am-doing-in-my-formulas-given-in-the-sample-file-sample-file
Sheet: Table 54

कार्यक्रम PROGRAM |  |  | जोखखम [NAME] | PROG CODE
 |  |  |  | IT 1550
तर्षर् समूह/JOB FAMILY |  |  | IC, INSPECTION & RISK MANAGEMENT
उद्देश्य/OBJECTIVE |  |  | TO    IMPART/UPDATE    NECESSARY    SKILLS    FOR    DATA MANAGEMENT/DATA   CLEANSING   AND   SENSITIZING   THE PERSONNEL ON RISK MANAGEMENT, RBI GUIDELINES, STEPS INITIATED  BY  BANKS,  ROLES  AND  RESPONSIBILITIES  OF BRANCHES/OFFICES.
लतक्षि समूह/TARGET GROUP |  |  | [NAME]
अर्तध/DURATION |  |  | 3 DAYS
DAY | SESSION | CONTENTS
Day 1 | I | a.  Introduction to Risk Management, b. Need for Risk Management and Importance, c.  Risk Regulations - Basel Norms - Components of Capital, Tier I and Tier II Capital, Deductions from Capital
 | II | Basel III norms, Three Pillars of Basel accord, a) Operational Risk b) Market Risk c) Credit Risk, d) Risk Management Policy requirements, Liquidity  coverage  [NAME],  NSFR,  Operational Risk  -  Components  of ORM-New  incident  Management  Module  and  its  features  to  be covered
 | III | Disclosures Capital Conservation; FCR and FCC, Disbursement Draw down, Unavailed limits RWAs, [NAME], LAPS Package - an introduction
 | IV | Fraud  risk  management  Policy,  Password  secrecy.  Whistle  Blower Policy, Preventive Vigilance
Day 2 | I & II | Basics of Balance Sheet and P&L Account Reading / Ratio Analysis and Financial Due Diligence, Creative Accounting Techniques / Cash and Fund Flow Statements
 | III | RBIA/RBS,   Security   Linkage,   CGTMSE   /   ECGC   coverage,   Data cleaning/Documentation/EWIRM, Risk Rating & Risk Mitigation, KRIs, Case studies on Credit Risk Rating - System Updation, [NAME] Proposal Rating
 | IV | Identification of circumstances leading to Conflicts of Interest and effective strategies to manage & transparently disclosing the same.
Day 3 | I | Building   Customer   Relationships   –   Understanding   the   need   of different customer segments
 | II | Role of Interpersonal Skills & motivation in a successful career
 | III | Working in Teams – Focus Personal and Organizational Goals
 | IV | Business Ethics and Value System &Valediction
Spreadsheet: 63904d1264764227-vlookup-with-mutliple-criteria-customer
Sheet: Sheet1

Custmer code | Plant code | Product code | Peding qty
1 | 2a | 14 | this the value to be picked from pending contracts file on the basis of customer code and product code
2 | 3a | 13
6 | 5a | 36
2 | 1a | 44
4 | 3a | 14
8 | 5a | 14
7 | 1a | 25
8 | 2a | 36
11 | 3a | 44
10 | 5a | 13
11 | 1a | 25
Spreadsheet: 269976d1381337421-huge-problem-with-the-indirect-function-trying-to-create-dependent-drop-downs-pcard-amounts-removed
Sheet: FEB

Regina Downtown
P-card [NAME]
Purpose: February | Statement
Description | Retailer | Goods Purchased | Total | GST | Fund | Org | Activity | Acct | Project | [NAME]
Events & Programming | Facebook | CS Winter Ads Promo | 13.91 | 0 | 520 | 0000 | R210 | 64202 | Y0721 | 00
Meetings, Receptions & food | [NAME] | [NAME] design consultant  JV, LG, [NAME] | 32.4 | 1.29 | 520 | 0000 | R110 | 64115 | Y0709 | 00
Special Projects | Sask Rough Riders | Grey Cup | 1353.6 | 0 | 520 | 0000 | R310 | 68102 | Y0732 | 00
Special Projects | Sask Rough Riders | Grey Cup | 200 | 0 | 520 | 0000 | R310 | 68102 | Y0732 | 00
Meetings, Receptions & food | Earls | Team mtg  JV, LG | 55.07 | 9.18 | 520 | 0000 | R110 | 64115 | Y0709 | 00
Events & Programming | Copper Kettle | CS Winter Team lunch | 157.84 | 7.04 | 520 | 0000 | R210 | 64115 | Y0721 | 00
Meetings, Receptions & food | Extra Foods | Groceries | 14.8 | 0 | 520 | 0000 | R110 | 64115 | Y0709 | 00
Events & Programming | Facebook | CS Winter Ads Promo | 29.7 | 0 | 520 | 0000 | R210 | 64202 | Y0721 | 00
Meetings, Receptions & food | Flip | [NAME] [NAME] Street UoR | 36.54 | 1.45 | 520 | 0000 | R110 | 64115 | Y0709 | 00
Events & Programming | Facebook | CS Winter Ads Promo | 27.96 | 0 | 520 | 0000 | R210 | 64202 | Y0721 | 00
Equip rentals & Office Supplies | Staples | Office Supplies | 43.19 | 1.96 | 520 | 0000 | R110 | 65112 | Y0706 | 00
Events & Programming | Facebook | CS Winter Ads Promo | 29.12 | 0 | 520 | 0000 | R210 | 64202 | Y0721 | 00
Member [NAME] | Mail Chimp | General Correspondence | 31.61 | 0 | 520 | 0000 | R210 | 64232 | Y0720 | 00
Events & Programming | Atlantis | CS Summer programming | 17.39 | 0 | 520 | 0000 | R210 | 64115 | Y0721 | 00
Meetings, Receptions & food | Atlantis | Mtg/ [NAME] | 5.76 | 0 | 520 | 0000 | R110 | 64115 | Y0709 | 00
Meetings, Receptions & food | Hotel Sask | Gold Metal Plates for Chef Milton | 353.4 | 14.02 | 520 | 0000 | R110 | 64115 | Y0709 | 00
 |  |  |  |  |  |  |  |  |  | 00
TOTAL RECEIPTS
Spreadsheet: 33346d1229637879-excel-2007-is-this-a-dynamic-range-issue-interpolation-program
Sheet: Data

99.067 | 99.421 | 16.59 | 124.92 | 134.202 | 161.512 | 97.169 | 141.51
97.996 | 105.264 | 25.845 | 110.701 | 136.206 | 156.74 | 100.582 | 136.546
96.931 | 109.436 | 34.277 | 97.132 | 138.188 | 153.634 | 104.841 | 131.409
95.891 | 111.486 | 42.685 | 85.723 | 140.169 | 152.623 | 111.199 | 128.409
94.905 | 112.218 | 51.625 | 75.601 | 142.184 | 152.876 | 119.406 | 127.226
94.029 | 112.415 | 61.094 | 65.157 | 144.262 | 153.556 | 128.68 | 126.252
93.35 | 112.298 | 70.643 | 53.699 | 146.359 | 154.352 | 138.344 | 124.342
92.938 | 111.85 | 79.561 | 41.973 | 148.253 | 155.212 | 147.712 | 121.534
92.782 | 111.15 | 87.122 | 31.435 | 149.58 | 156.068 | 155.972 | 118.557
92.791 | 110.423 | 92.786 | 23.197 | 150.044 | 156.785 | 162.363 | 115.983
92.889 | 109.898 | 96.244 | 17.665 | 149.535 | 157.213 | 166.346 | 113.909
93.09 | 109.727 | 97.366 | 14.756 | 148.076 | 157.183 | 167.64 | 112.123
93.472 | 110.034 | 96.146 | 14.127 | 145.761 | 156.494 | 166.112 | 110.273
94.072 | 110.826 | 92.684 | 15.178 | 142.688 | 155.102 | 161.858 | 107.862
94.839 | 111.818 | 87.322 | 17.034 | 138.832 | 153.342 | 155.504 | 104.356
95.711 | 112.569 | 80.739 | 18.854 | 134.078 | 151.72 | 148.17 | 99.593
96.669 | 112.742 | 73.814 | 20.32 | 128.52 | 150.589 | 141.072 | 94.134
97.728 | 112.109 | 67.367 | 21.71 | 122.63 | 150.163 | 135.258 | 89.077
98.914 | 110.471 | 62.032 | 23.577 | 117.015 | 150.615 | 131.561 | 85.609
100.237 | 107.701 | 58.159 | 26.355 | 112.143 | 152.062 | 130.458 | 84.513
101.657 | 103.799 | 55.706 | 30.17 | 108.265 | 154.544 | 131.907 | 85.876
103.076 | 98.883 | 54.348 | 34.841 | 105.386 | 158.041 | 135.465 | 89.189
104.364 | 93.232 | 53.742 | 40.029 | 103.288 | 162.404 | 140.51 | 93.771
105.396 | 87.346 | 53.67 | 45.578 | 101.663 | 167.258 | 146.325 | 99.249
106.089 | 81.828 | 53.895 | 51.634 | 100.259 | 172.082 | 152.067 | 105.529
106.44 | 77.107 | 54.017 | 58.23 | 98.918 | 176.454 | 156.911 | 112.247
106.517 | 73.337 | 53.549 | 64.963 | 97.536 | 180.146 | 160.213 | 118.512
106.423 | 70.541 | 52.081 | 71.313 | 96.051 | 183.036 | 161.54 | 123.394
106.241 | 68.629 | 49.489 | 77.254 | 94.498 | 185.131 | 160.86 | 126.743
106.014 | 67.32 | 46.034 | 83.356 | 93.061 | 186.666 | 158.714 | 129.391
105.736 | 66.294 | 42.105 | 90.11 | 92.058 | 187.969 | 155.811 | 132.215
Spreadsheet: 546900d1510247077-conditional-chart-range-starbuk
Sheet: Sheet1

Date | Value1
2017-01-01 00:00:00 | 2
2017-01-02 00:00:00 | 1
2017-01-03 00:00:00 | 6
2017-01-04 00:00:00 | 4
2017-01-05 00:00:00 | 5
2017-01-06 00:00:00 | 8
2017-01-07 00:00:00 | 9
2017-01-08 00:00:00 | 4
2017-01-09 00:00:00 | 5
2017-01-10 00:00:00 | 6
2017-01-11 00:00:00 | 7
2017-01-12 00:00:00 | 11
2018-01-01 00:00:00
Spreadsheet: 884571d1733806808-10-columns-change-into-1-column-voorbeeld
Sheet: nieuw 

 |  | nul | een | twee | drie
totaal per lln |  | gemiddelde | gemiddelde
 |  | 5.7 | 6.9
 |  | 5 | 7
 |  | 1.2 | 1.2
 |  | 3.8 | 5
 |  | 5.1 | 5.5
 |  | 4.2 | 6.6
 |  | 4.1 | 3.5
 |  | 5.3 | 6.4
 |  | 4.3 | 4.2
 |  | 2 | 2
 |  | 4.1 | 5.7
 |  | 5.5 | 5.7
 |  | 4.1 | 5.2
 |  | 3.1 | 4.2
 |  | 2.1 | 3.1
 |  | 3.9 | 4.3
 |  | 4.9 | 4.8
 |  | 5 | 6.2
 |  | 2.2 | 1.8
 |  | 6.5 | 7
 |  | 3.4 | 4.1
 |  | 1.1 | 4.6
 |  | 3.6 | 3.7
 |  | 3.921739130434782 | 4.72608695652174
 |  | 3.93 | 4.709999999999999
Spreadsheet: 635957d1565093744-help-automatic-an-excel-calculation-example-1-edit
Sheet: Sales Price

Distributor Product Price | Selling Platform Fee | Tax on Sale | Profit | Profit % | Tax on Purchase | Net Sale | Selling Price
100 |  |  |  |  |  |  | 140.86
1
25.86
33.15
155.97
12.23
35
68
199
12345
15.5
Spreadsheet: 864657d1711735457-need-help-with-2-row-header-worksheet-monthly-asset-listing-excel-data-nxt2-1-
Sheet: Sheet1

Asset Listing
Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7
Asset No. | Description | Location | Depr. basis | Disposal Price | Accum. Depr.
Asset ID | Class | Department | In Service Date | Disposal Date | [NAME]. Date | Book Value
2021 | Athletic Field Turf | Athletics | 1220790.2 | 0 | 966458.9 | 254331.3
 | Athletic Fields | Athletics | 2016-03-01 00:00:00 |  | 2024-01-31 00:00:00
2022 | Athletic Field Lighting | Athletics | 344183.75 | 0 | 108991.53 | 235192.22
 | Athletic Fields | Athletics | 2016-03-01 00:00:00 |  | 2024-01-31 00:00:00
2023 | Athletic Field Fence | Athletics | 15829.95 | 0 | 6134.14 | 9695.81
 | Athletic Fields | Athletics | 2016-05-01 00:00:00 |  | 2024-01-31 00:00:00
1559 | Large Conference Room Ceiling |  | 49048.5 | 0 | 18393.2 | 30655.3
 | Building Improvements |  | 2012-11-01 00:00:00 |  | 2024-01-31 00:00:00
1560 | Roll-Up Doors / Ceramics & IT |  | 10975.28 | 0 | 4115.72 | 6859.56
 | Building Improvements |  | 2012-11-01 00:00:00 |  | 2024-01-31 00:00:00
1738 | Air Conditioning Units - Faculty |  | 78171 | 0 | 27142.7 | 51028.3
 | Building Improvements |  | 2013-09-01 00:00:00 |  | 2024-01-31 00:00:00
1750 | Generator |  | 80766.77 | 0 | 40046.88 | 40719.89
 | Building Improvements | Operations | 2014-03-01 00:00:00 |  | 2024-01-31 00:00:00
1860 | LED Outdoor Parking Fixtures | Parking Lot | 9300 | 0 | 2919.16 | 6380.84
 | Building Improvements | Operations | 2014-09-01 00:00:00 |  | 2024-01-31 00:00:00
1871 | Admin Office Remodel | [NAME] | 4292 | 0 | 1311.47 | 2980.53
 | Building Improvements | Administrative | 2014-12-01 00:00:00 |  | 2024-01-31 00:00:00
1872 | Drinking Fountain | Athletics | 5951 | 0 | 3636.7 | 2314.3
 | Building Improvements | Athletics | 2014-12-01 00:00:00 |  | 2024-01-31 00:00:00
1873 | Amphitheater | Amphitheater | 133729.96 | 0 | 40490.46 | 93239.5
 | Building Improvements | Administrative | 2015-01-01 00:00:00 |  | 2024-01-31 00:00:00
2017 | [NAME] | [NAME] | 10321.3 | 0 | 2809.66 | 7511.64
 | Building Improvements | Athletics | 2015-12-01 00:00:00 |  | 2024-01-31 00:00:00
2086 | [NAME] | Adirondack | 14864 | 0 | 10033.21 | 4830.79
 | Building Improvements | Operations | 2017-05-01 00:00:00 |  | 2024-01-31 00:00:00
2087 | ATS Switch for Generator | Parking Lot | 34342.47 | 0 | 7822.47 | 26520
 | Building Improvements | Facilities | 2017-04-01 00:00:00 |  | 2024-01-31 00:00:00
2141 | Gate - Main Entrance | Parking Lot | 65148 | 0 | 41803.3 | 23344.7
 | Building Improvements | Facilities | 2017-09-01 00:00:00 |  | 2024-01-31 00:00:00
2146 | Gym Lights | Gym | 44660 | 0 | 9428.25 | 35231.75
 | Building Improvements | Operations | 2017-10-01 00:00:00 |  | 2024-01-31 00:00:00
2158 | Ubterface Carpet Tile | A231 | 6000 | 0 | 4687.5 | 1312.5
 | Building Improvements | Facilities | 2017-11-01 00:00:00 |  | 2024-01-31 00:00:00
2239 | Monument Sign 7'-6" x 4'-7" | Parking Lot | 27546.12 | 0 | 8149.08 | 19397.04
 | Building Improvements | Facilities | 2018-03-01 00:00:00 |  | 2024-01-31 00:00:00
Spreadsheet: 120612d1315407664-need-a-formula-to-add-certain-columns-together-115-monks-park
Sheet: Sheet1

SOR Code | Description | SOR | Quantity | SOR Total | SOR -20%
 | Works as per original order 3903172/1
 | Works completed
 | General
730009 | Void:Safety check and test gas installation | 32.4 | 1 | 32.4 | 25.92
730005 | Void:Test and commission central heating system | 21.6 | 1 | 21.6 | 17.28
391301 | Nightlatch: Renew complete | 44.02 | 1 | 44.02 | 35.22
730011 | Void:Temporary cap gas supply | 10.64 | 1 | 10.64 | 8.51
740003 | Cooker:Disconnect seal cap make safe | 6.54 | 1 | 6.54 | 5.23
460028 | Garden: Cut grass NE 100mm | 1.29 | 40 | 51.6 | 41.28
335003 | Door: Ease Adjust Rehang internal new butts | 18.28 | 1 | 18.28 | 14.62
318117 | Window:Ease and Adjust PVCU | 6.62 | 2 | 13.24 | 10.59
450007 | Room: Redecorate 15-20sm Ceiling area | 241.86 | 1 | 241.86 | 193.49
436209 | Window:Prepare paint metal NE 1.50sm | 14.6 | 1 | 14.6 | 11.69
630113 | Sink: Renew NE 42mm combination waste | 38.85 | 2 | 77.7 | 62.16
318117 | Window:Ease and Adjust PVCU | 6.62 | 1 | 6.62 | 5.3
630513 | WC pan:Renew seat complete | 26 | 1 | 26 | 20.8
631125 | Shower: Renew curtain | 23.07 | 1 | 23.07 | 18.46
Manual | Locate and repair water hammer | 23.84 | 3 | 71.52 | 57.22
631337 | Tap: Renew bath mixer with shower attachment | 88.38 | 1 | 88.38 | 70.7
318117 | Window:Ease and Adjust PVCU | 6.62 | 2 | 13.24 | 10.59
335003 | Door: Ease Adjust Rehang internal new butts | 18.28 | 1 | 18.28 | 14.62
318117 | Window:Ease and Adjust PVCU | 6.62 | 2 | 13.24 | 10.59
318117 | Window:Ease and Adjust PVCU | 6.62 | 2 | 13.24 | 10.59
335003 | Door: Ease Adjust Rehang internal new butts | 18.28 | 1 | 18.28 | 14.62
415013 | Plaster repair: Repair crack to wall or ceiling | 5.46 | 3 | 16.38 | 13.1
Manual | To get electric key charged | 23.84 | 1 | 23.84 | 19.07
 | Charge Electric key |  |  |  | 20
 |  |  |  | Sub total | 711.65
 |  |  |  | VAT @ 20% | 142.33
 |  |  |  | Total | 853.98
Spreadsheet: 86721d1286682951-adding-cells-list
Sheet: Sheet2

 |  | 2010
 |  | City | Sales | + / - Last Year |  |  |  | City
49 | 1 | Atlanta | 49 | -13 |  | 1 | 64 | Kansas City
52 | 2 | Birmingham | 52 | +9 |  | 2 | 61 | Tulsa
64 | 3 | Kansas City | 64 | -3 |  | 3 | 53 | Jacksonville
53 | 4 | Jacksonville | 53 |  |  | 4 | 52 | Birmingham
41 | 5 | Tupelo | 41 |  |  | 5 | 49 | Atlanta
61 | 6 | Tulsa | 61 |  |  | 6 | 41 | Tupelo
 | 7
Spreadsheet: 843889d1695717668-dyn-arr-fx-for-sub-totals-byrow-book3
Sheet: Sheet1

 | Totals |  |  |  |  | Values
 | S | M | L | XL |  | S | M | L | XL | S | M | L | XL | S | M | L | XL
 |  |  |  |  |  | 7 | 9 | 3 | 3 | 7 | 6 | 6 | 9 | 8 | 2 | 4 | 8
 |  |  |  |  |  | 6 | 1 | 2 | 9 | 10 | 5 | 4 | 3 | 7 | 4 | 10 | 2
 |  |  |  |  |  | 1 | 5 | 5 | 6 | 9 | 5 | 10 | 8 | 9 | 1 | 4 | 6
 |  |  |  |  |  | 9 | 5 | 8 | 5 | 1 | 7 | 5 | 3 | 9 | 7 | 7 | 8