tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 175515d1345558995-adding-cells-containing-the-results-of-formula-without-any-text-world-cell-profit-by-item
Sheet: Sheet1

Date: | Customer Name: | Inv #: | [NAME]: | Phone cost: | Accessories cost: | Labor: | Sales price: | Qty: | Profit Per Phone: | Net profit:
 |  |  |  |  |  |  |  |  | 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
 |  |  |  |  |  |  |  |  | 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
 |  |  |  |  |  |  |  |  | 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
 |  |  |  |  |  |  |  |  | 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
TOTAL: |  |  |  |  |  |  |  |  |  | #N/A
Spreadsheet: 7e0a8ae0-042c-4d0e-8f81-c79b6fdc2840
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
AVP | Test | AVP | [NAME], Plasma | [NAME], P | Radioimmunoassay (RIA) | EDTA (lavender-top) tube: EDTA |  |  | 5 | mL | [NAME]-poor plasma Collection Container/Tube: Lavender top (EDTA) iced tube Submission Container/Tube: Plastic vial [NAME]: 2 mL Collection Instructions: 1. Have patient fast and thirst for 6 hours (no liquids, including water, are allowed). 2. Process 5 mL of EDTA whole blood as follows: a. Spin down in a refrigerated centrifuge at approximately 1,000 x G (2,000 rpm for a 20-cm radius centrifuge) for 10 minutes. b. Remove plasma, carefully avoiding the platelet/buffy coat. Additional Information: This test should not be requested on patients who have recently received radioactive material. Forms: If not ordering electronically, submit a General Request Form (Supply T239) with the specimen. | 1.15 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK <4 hrs; Cold OK <24 hrs - refreeze - note to lab Lipemia	Mild OK; [NAME] OK Icterus	Mild OK; [NAME] OK Other	NA | Adults: <1.7 pg/mL Reference values were determined on platelet-poor EDTA plasma from individuals fasting no longer than overnight. | Wednesday; 1 p.m. | 3 days | 11 days | 1 | 84588 |  |  |  |  | Rochester
AVP | [NAME] | PLEDTA | [NAME] |  |  |  | Frozen | 14 days
AVP | Result | 80344 | [NAME], P | [NAME], P | Numeric |  |  |  |  | pg/mL |  |  |  |  |  |  |  |  |  | 3126-0 | [NAME]:MCnc:Pt:[NAME]:Qn:
Spreadsheet: 689399d1596377377-use-data-in-one-array-in-formulas-for-another-sample-cash-flow
Sheet: Senior Loan Schedule

 | SENIOR LOAN AMORTIZATION
 | Enter values |  |  |  |  |  |  | Loan summary
 | Loan amount |  |  |  |  |  |  | Scheduled payment
 | Annual interest rate |  |  |  |  |  |  | Scheduled number of payments
 | Loan period in years |  |  |  |  |  |  | Actual number of payments
 | Payments per year |  | 12 |  |  |  |  | Total early payments
 | Start date of loan |  |  |  |  |  |  | Total interest
 | Optional extra payments |  |  |  |  |  |  | Loan Origination
 | Pmt. No. | Payment Date | Beginning Balance | Scheduled Payment | Extra Payment | Total Payment | Principal | Interest | Ending Balance | Cumulative Interest
 |  |  |  |  | 0
Spreadsheet: 711904d1609960927-reorganizing-unorganized-data-sample-copy-2-
Sheet: SUMMARY

 | Snow | Rain | High Temp | Low Temp | Temp Change |  | DM06 |  |  |  |  | DM07 |  |  |  |  | DM08 |  |  |  |  | DM09 |  |  |  |  | DM10 |  |  |  |  | [NAME] |  |  |  |  | DM12 |  |  |  |  | DM13 |  |  |  |  | DM14 |  |  |  |  | DM15 |  |  |  |  | DM16 |  |  |  |  | [NAME] |  |  |  |  | DM18 |  |  |  |  | DM19 |  |  |  |  | [NAME] |  |  |  |  | DM31 |  |  |  |  | DM32 |  |  |  |  | DM33 |  |  |  |  | DM34 |  |  |  |  | DM35 |  |  |  |  | DM36 |  |  |  |  | DM37 |  |  |  |  | DM38 |  |  |  |  | DM39 |  |  |  |  | DM40 |  |  |  |  | DM41 |  |  |  |  | DM42 |  |  |  |  | DM43 |  |  |  |  | DM44 |  |  |  |  | DM45 |  |  |  |  | DM46 |  |  |  |  | DM47 |  |  |  |  | DM48 |  |  |  |  | DM49 |  |  |  |  | DM50
Date | [NAME] | [NAME] | °C | °C | °C |  | N | E | Z | Δ Last | Δ Baseline | N | E | Z | Δ Last | Δ Baseline | N | E | Z | Δ Last | Δ Baseline | N | E | Z | Δ Last | Δ Baseline | N | E | Z | Δ Last | Δ Baseline | N | E | Z | Δ Last | Δ Baseline | N | E | Z | Δ Last | Δ Baseline | N | E | Z | Δ Last | Δ Baseline | N | E | Z | Δ Last | Δ Baseline | N | E | Z | Δ Last | Δ Baseline | N | E | Z | Δ Last | Δ Baseline | N | E | Z | Δ Last | Δ Baseline | N | E | Z | Δ Last | Δ Baseline | N | E | Z | Δ Last | Δ Baseline | N | E | Z | Δ Last | Δ Baseline | N | E | Z | Δ Last | Δ Baseline | N | E | Z | Δ Last | Δ Baseline | N | E | Z | Δ Last | Δ Baseline | N | E | Z | Δ Last | Δ Baseline | N | E | Z | Δ Last | Δ Baseline | N | E | Z | Δ Last | Δ Baseline | N | E | Z | Δ Last | Δ Baseline | N | E | Z | Δ Last | Δ Baseline | N | E | Z | Δ Last | Δ Baseline | N | E | Z | Δ Last | Δ Baseline | N | E | Z | Δ Last | Δ Baseline | N | E | Z | Δ Last | Δ Baseline | N | E | Z | Δ Last | Δ Baseline | N | E | Z | Δ Last | Δ Baseline | N | E | Z | Δ Last | Δ Baseline | N | E | Z | Δ Last | Δ Baseline | N | E | Z | Δ Last | Δ Baseline | N | E | Z | Δ Last | Δ Baseline | N | E | Z | Δ Last | Δ Baseline | N | E | Z | Δ Last | Δ Baseline
2020-06-09 00:00:00
2020-06-16 00:00:00
2020-06-20 00:00:00
2020-06-26 00:00:00
2020-07-03 00:00:00
2020-07-10 00:00:00
2020-07-17 00:00:00
2020-07-24 00:00:00
2020-07-31 00:00:00
2020-08-07 00:00:00
2020-08-14 00:00:00
2020-08-21 00:00:00
2020-08-28 00:00:00
2020-09-04 00:00:00
2020-09-11 00:00:00
2020-09-18 00:00:00
2020-10-08 00:00:00
2020-11-10 00:00:00
2020-12-09 00:00:00
Spreadsheet: louise_kitchen__24127__North America Plan 01-02
Sheet: Research

 | 2002 Plan
 |  | 2001-09-01 00:00:00 |  | 2001 | 2002 |  |  |  | Per HC | New HC | Adj Comp |  |  | 2002
 |  | YTD Actual |  | Forecast | Plan |  |  |  |  |  |  |  |  | Plan
ENACOMP | Compensation
 | Special Pays | 0 |  |  |  |  |  | Compensation | 0
 | Analysts & Associates | 0
ENABENTX | Benefits & Payroll Taxes
ENAEMPEX | Employee Expense |  |  |  |  |  |  | Other
ENAT&EEX | Travel & Entertainment Expense
ENAOUTSV | Outside Services |  |  |  |  |  |  | Total |  |  |  |  | 1699109
ENASUPP | Supplies Expense
ENAMKTEX | Marketing
ENACONTR | Charitable Contributions |  |  |  |  |  |  | [NAME]
ENARENT | Rent |  |  |  |  |  |  | Admins | 48000 | 0
ENATECH | Technology |  |  |  |  |  |  | Staff | 49200 | 0
ENATRANS | Transportation |  |  |  |  |  |  | Analysts | 57600 | 0
ENAOTHEX | Other Expenses |  |  |  |  |  |  | Associate | 72000 | 0
ENATAXES | Taxes Other than Income |  |  |  |  |  |  | Specialist | 62400 | 0
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  | Sr Specialst | 74400 | 0
 |  |  |  |  |  |  |  | Managers | 90000 | 0
 | Headcount |  |  | 44 |  |  |  | Directors | 120000 | 1
 |  |  |  |  |  |  |  | General Counsel Asst | 178800 | 0
 | Analysts & Associate Headcount |  |  | 5 | 0 |  |  | Vice President | 216000 | 1
 |  |  |  |  |  |  |  | [NAME] | 312000
 | Total Headcount |  |  |  |  |  |  |  |  |  |  |  |  | 1
ENAOUTLG | Outside Legal |  |  |  |  |  |  | Benefits & Taxes |  |  | 0.2
ENAOUTTX | Outside Tax
ENAINSUR | Insurance
ENASYSDV | System Development
ENACORIT | Controllable Infrastructure
ENACORRN | Corporate Rent
ENAOTHAL | Other Allocated Direct  Expenses |  |  |  |  | Other Expense Calculation
ENADEPR | Depreciation & Amortization
 |  |  |  |  |  | Total Misc Exp |  | Old HC | Exp/Old HC | New HC | Exp/New HC
Spreadsheet: 100053d1298524488-excel-2007-two-formula-in-pivot-table-column-test1
Sheet: Data

Date | T# | Issue | Site | Length of Outage | Unit | Agents Impacted | Prod Hours
2011-01-07 00:00:00 | 19291386 | Power Outage | New York | 00:40:00 | Preassembly | 8 | 5.33336
2011-01-07 00:00:00 | 19291386 | Power Outage | New York |  | Assembly | 4 | 2.66668
2011-01-07 00:00:00 | 19291386 | Power Outage | New York |  | Packaging | 11 | 7.33337
2011-01-15 00:00:00 | 19354991 | [NAME] welder | New Mexico | 01:10:00 | Preassembly | 27 | 8.3750125
2011-01-15 00:00:00 | 19354991 | [NAME] welder | New Mexico |  | Assembly | 10 | 6.52015
2011-01-15 00:00:00 | 19354991 | [NAME] welder | New Mexico |  | Packaging | 13 | 8.7491
2011-01-21 00:00:00 | 19365847 | [NAME] pallet jack | New Mexico | 00:30:00 | Packaging | 10 | 5.25
2011-01-30 00:00:00 | 19365928 | Defective bolts | Iowa | 02:10:00 | Assembly | 12 | 6.48
2011-01-30 00:00:00 | 19365928 | Defective bolts | New York |  | Assembly | 8 | 4.36
2011-01-30 00:00:00 | 19365928 | Defective bolts | New Mexico |  | Assembly | 20 | 10.48
Spreadsheet: 727787d1618111047-linear-interpolation-in-excel-linearinterpolation2
Sheet: Sheet1

 | X | Y |  |  | New X | Interpolated Value
 | 0 | 634 |  |  | 115 | 475.3
 | 200 | 358
 | 400 | 261
 | 600 | 214
 | 800 | 187 |  |  |  |  | The problem: I expect two possible interpolated values, not one
 | 1000 | 169
 | 1200 | 154
 | 1400 | 143
 | 1600 | 134
 | 1800 | 126
 | 1570 | 112
 | 1360 | 100
 | 1120 | 89
 | 920 | 79
 | 730 | 70
 | 510 | 62
 | 300 | 55
 | 105 | 49
 | 0 | 44
Spreadsheet: 65820d1266477630-lookup-formula-demo
Sheet: NO2

Name | Birthday |  |  | Address | phone | Start date
 |  |  |  | Job | Cell | Quit Date
MrE | 1975 | Feb | 13 | Don't know street | 55223222 | 2007-03-02 00:00:00
 |  |  |  | Secretary | 905555221
MrD | 1978 | Mar | 30 | Have not a clue Rd | 22555 | 2008-04-06 00:00:00
 |  |  |  | Manager | 905555221
MrS | 1979 | Apr | 31 | Wouldn't know how to to get there Street | 552222552 | 2010-01-02 00:00:00
 |  |  |  | sales clerk | 905555221
Spreadsheet: richard_sanders__31686__ICE Sale Calc
Sheet: Flash

ICE DRILLING
Sale of assets
8/31/99
 |  |  |  |  |  | P&L Effect
 |  | Gross |  | Net to ECT |  | Net to ECT |  | Net to ECT
 |  |  |  |  |  | (Per Flash) |  | (Per MPR)
Cash |  | 9312198.88
Write off Loan |  | -9979591.85
Write off AIR
Write off BS FV Adj. |  | 1999996
Reverse FV Loss |  | -1999996
Write off Warrants and BS FV Adj. |  | 0
Reverse FV Loss |  | -68027
Total realized loss
Unrealized loss as of 6/30/99
3Q realized gain
Total realized loss at 8/31/99
AIR @ 7/31/99 |  | 449132.31
Int. received in cash proceeds |  | -3688.24
August AIR |  | 25425.49
AIR @ 8/31/99
Spreadsheet: 841638d1693825013-index-match-formula-230904-study-plan-grade-3-1-2-
Sheet: Weekly Plan

ST. MARY’S CATHOLIC HIGH SCHOOL, FUJAIRAH
STUDY PLAN – WEEK No. |  |  | 2
CLASS: GRADE 3                                                                                                      SECTION: A, B, C, D, E
DATE |  | DAY |  | SUBJECT | PORTION
 | Plan | SATURDAY
 |  | SUNDAY
 |  | MONDAY
 |  | TUESDAY
 |  | WEDNESDAY
Spreadsheet: 707707d1607428299-find-dublicates-find-duplicates-formula
Sheet: Sheet1

Agreement | Part number | How can this be solved with an "easy" forumula instead?
4356238256 | ABC12345
4356238257 | ABC12345
4356238258 | ABC12345
4356238259 | ABC12348
4356238260 | ABC12349 | Duplicate. Same part number appears on same agreement twice
4356238261 | ABC12350
4356238262 | ABC12350
4356238263 | ABC12352
4356238264 | [NAME]
4356238265 | ABC12354
4356238260 | ABC12349 | Duplicate. Same part number appears on same agreement twice
4356238267 | ABC12349
4356238268 | ABC12357
4356238269 | ABC12358
4356238270 | [NAME] | Duplicate. Same part number appears on same agreement twice
4356238271 | ABC12360
4356238272 | [NAME]
4356238273 | ABC12362
4356238274 | ABC12363
4356238275 | ABC12364
4356238270 | [NAME] | Duplicate. Same part number appears on same agreement twice
Spreadsheet: 702898d1604596561-dynamic-excel-function-based-on-players-involved-and-timing-dynamic-formula
Sheet: Sheet1

 | Assumption |  |  |  |  |  |  |  |  | Assumption
 |  | All Players | Player 1 and 2 | Player 1 Only | Player 1 and 3 | Player 2 and 3 | Player 2 Only | Player 3 Only |  |  | Player 1 Only | Player 2 Only | Player 1 and 2 | Player 3 Only | Player 1 and 3 | Player 2 and 3 | All Players
 |  | 0.15 | 0.2 | 0.25 | 0.2 | 0.2 | 0.25 | 0.25 |  |  | 0.25 | 0.25 | 0.2 | 0.25 | 0.2 | 0.2 | 0.15
 | Player 1 | 0.425 | 0.48 | 0.75 | 0.48 | 0 | 0 | 0 |  | Player 1 | 0.75 | 0 | 0.48 | 0 | 0.48 | 0 | 0.425
 | Player 2 | 0.2833333333333334 | 0.3200000000000001 | 0 | 0 | 0.48 | 0.75 | 0 |  | Player 2 | 0 | 0.75 | 0.3200000000000001 | 0 | 0 | 0.48 | 0.2833333333333334
 | Player 3 | 0.1416666666666667 | 0 | 0 | 0.3200000000000001 | 0.3200000000000001 | 0 | 0.75 |  | Player 3 | 0 | 0 | 0 | 0.75 | 0.3200000000000001 | 0.3200000000000001 | 0.1416666666666667
 | Entry Assumption |  |  |  |  |  |  |  |  | Entry Assumption
 |  | Entry Year | 2020 | 2021 | 2022 | 2023 | 2024 |  |  |  | Entry Year | 2020 | 2021 | 2022 | 2023 | 2024
 | Player 1 | 2020 | 0.15 | 0.25 | 0.35 | 0.4 | 0.45 |  |  | Player 1 | 2020 | 0.15 | 0.25 | 0.35 | 0.4 | 0.45
 | Player 2 | 2021 | 0 | 0.2 | 0.25 | 0.3 | 0.35 |  |  | Player 2 | 2021 | 0 | 0.2 | 0.25 | 0.3 | 0.35
 | Player 3 | 2022 | 0 | 0 | 0.05 | 0.075 | 0.1 |  |  | Player 3 | 2022 | 0 | 0 | 0.05 | 0.075 | 0.1
 | Calculation |  |  |  |  |  |  |  |  | Calculation
 |  |  | 2020 | 2021 | 2022 | 2023 | 2024 |  |  |  |  | 2020 | 2021 | 2022 | 2023 | 2024
 | Player 1 |  |  |  |  |  |  |  |  | Player 1
 | Player 2 |  |  |  |  |  |  |  |  | Player 2
 | Player 3 |  |  |  |  |  |  |  |  | Player 3
 |  |  | 0
 |  |  | 0 | 0
Spreadsheet: 84769d1284811509-sum-with-counta-and-countif-with-many-matching-criteria-example
Sheet: Sheet1

 | Happy |  | Doc
Week 35 | 0.95 | 0.7 | 0.88 | 0.6 | Monday
 | 0.92 | 0.65 | 0.67 | 0.5 | Tuesday
 | 0.87 | 0.75 | 0.72 | 0.59 | Wednesday
 | 0.98 | 0.8 | 0.62 | 0.48 | Thursday
 | 0.99 | 0.82 | 0.8 | 0.78 | Friday
 | N/A | 0 | N/A | 0 | Saturday
 | N/A | 0 | N/A | 0 | Sunday
Week 36 | 0.85 | 0.71 | 0.8 | 0.72 | Monday
 | 0.87 | 0.65 | 0.85 | 0.75 | Tuesday
 | 0.95 | 0.8 | 0.89 | 0.78 | Wednesday
 | 0.93 | 0.82 | 0.9 | 0.79 | Thursday
 | 0.89 | 0.69 | 0.95 | 0.82 | Friday
 | N/A | 0 | 0.95 | 0.88 | Saturday
 | N/A | 0 | N/A | 0 | Sunday
 | Actual | Capacity | Actual | Capacity
Row | 0 | 7 | 14
 |  |  |  |  |  | Based on sum all percentages devided by sum(counta all cells within a week minus countif all N/A within a week) in Actual column
Actual | Week 35 | Week 36
Doc | 0.7380000000000001 | 0.89 |  |  |  | based on sum all percentages within a week but Monday to Friday devided by 5 in capacity column
Happy | 0.942 | 0.898
5 Days
Doc | 0.5900000000000001 | 0.772 |  |  |  | Based on sum all percentages within a week but Monday to Sunday devided by 7 in capacity column
Happy | 0.744 | 0.734
7 Days
Doc | 0.4214285714285714 | 0.6771428571428572
Happy | 0.5314285714285715 | 0.5242857142857142
Spreadsheet: 770298d1645984379-excel-formula-to-produce-balance-sheet-balance-sheet-2021b
Sheet: Trial Balance

 | TRIAL BALANCE | SUM(((B7='Trial Balance'!$E$4:$E$19)*('Trial Balance'!$C$4:$C$19))-((B7='Trial Balance'!$E$4:$E$19)*('Trial Balance'!$D$4:$D$19)))
 | *************** | DR | CR | Balance Sheet
 | School development funds |  | 846341.62 | School development funds
 | Accumulated funds |  | 491809.59 | Accumulated funds
 | Buildings @ Cost | 331833 |  | Non-current Assets
 | Equipment @ Cost | 206430.88 |  | Non-current Assets
 | Equipment - Accum Depreciation |  | 56922.58666666667 | Non-current Assets
 | Motor Vehicles | 124400 |  | Non-current Assets
 | Motor Vehicles - Accum Depreciation |  | 119298.0293389605 | Non-current Assets
 | Furniture @ Cost | 777068.89 |  | Non-current Assets
 | Furniture - Accum Depreciation |  | 171647.2673333333 | Non-current Assets
 | Receivables | 2868092.2 |  | Debtors and other receivables
 | STANBIC USD ACCOUNT | 165135.46 |  | Cash and equivalents
 | NOSTRO US$ | 49071.96 |  | Cash and equivalents
 | CBZ - COLLEGIATE:  [PHONE] | 9775.96 |  | Cash and equivalents
 | Sundry Suppliers |  | 309172.0966610402 | Sundry Suppliers
 | Net Surplus / (defict) for the year |  | 2536617.16 | Net Surplus for the year
 | Net Profit/Loss this year | 2536617.16
 | School Fees |  | 5459362.3 | Fees
 | Bus fares |  | 49728.95 | Sundry
 | SWIMMING |  | 1486 | Sundry
 | Donation Income |  | 39860 | Sundry
 | Sundry Income |  | 3155.29 | Sundry
 | Accounting Fees | 23920 |  | Accounting Fees
 | Subs to association | 63339.25 |  | Subs to association
 | Workshops & Conferences | 2167.44 |  | Workshops & Conferences
 | Depreciation | 89628.09 |  | Depreciation
 | Bank Charges | 129879.56 |  | Bank Charges
 | Electricity & Water | 92375.57 |  | Electricity & Water
 | Teas & Cleaning | 11991.01 |  | Teas & Cleaning
 | Funeral cover | 2534.13 |  | Funeral cover
 | Printing & Stationery | 43659.2 |  | Printing & Stationery
 | Salaries & Wages | 1405068.4 |  | Salaries & Wages
 | Telephone & Internet | 53781.11 |  | Telephone & Internet
 | Medical Aid | 4116 |  | Medical Aid
 | Insurance & Licence | 24727.48 |  | Insurance & Licence
 | Repairs & Maintenance | 336859.33 |  | Repairs & Maintenance
 | Security | 8468.61 |  | Security
 | [NAME] expenses | 349963.47 |  | [NAME] expenses
 | NSSA | 12713.9 |  | NSSA
 | Sundry expenses | 98662.48999999999 |  | Sundry expenses
 | Fuel | 263120.34 |  | Fuel
Spreadsheet: 720280d1614093501-need-to-extract-data-and-skip-blanks-indexing-with-conditions-from-multiple-sheets-dawn-clark-
Sheet: Millroom_Laser

Projected Delivery Date (to Production / ENG) | Priority | Part# | S/O # | S/O Due / ENG PROMISE | Rev | ORIG Job Qty | ACTUAL QTY | Raw Mat'l PO / ECO# | Job # | Job in machine area (YES or NO) | VT MEC PO# | Status | Chemfilm/PASSIVATE | Paint / Silkscreen | PROJECTED RUN TIME (IN DAYS) | Projected Machine Finish Date | Ready for chem film process | Notes
2021-02-22 00:00:00 | 1 | P/N 10 |  |  | A | 70 |  |  |  | N/A | 55752 |  | No | No |  | 2021-02-22 00:00:00
2021-02-22 00:00:00 | 2 | P/N 11 |  |  | A1 | 16 |  | ECO 4785 | 31606 | Kitted |  |  | No | No |  | 2021-02-22 00:00:00
2021-02-25 00:00:00 | 3 | P/N 12 | 17482 | 2020-07-30 00:00:00 | A | 67 |  |  | N/A | N/A | 55373 |  | YES | No |  | 2021-02-22 00:00:00 | x
2021-02-25 00:00:00 | 4 | P/N 13 | 17482 | 2020-07-30 00:00:00 | A | 10 |  |  | N/A | N/A | 55373 |  | YES | No |  | 2021-02-22 00:00:00
2021-02-22 00:00:00 | 5 | P/N 14 | 17482 | 2020-09-11 00:00:00 | A | 50 |  |  | 26171 | [NAME] / kitted | - | IP | No | No | 0 | 2021-02-22 00:00:00 |  | Working, Needs Millwork(Mar)
Spreadsheet: 702544d1604410220-depreciation-formula-using-drop-down-list-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 Building | 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)
LB001 | Land and Building | Land and Building | 2015-04-10 00:00:00 | 60000
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 | 3000 | 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
 | Truck | Motor Vehicles | 2010-05-30 00:00:00 | 25000 | 5000 | 10 |  |  |  |  | DB
Spreadsheet: 843807d1695653127-creating-calendar-from-data-within-summary-page-of-workbook-rb-example
Sheet: Summary

Sheet No. | Date to Claim Retention | Project No | Project | Agreed Final Account | Amount Paid to date | Retention held on LPLL | Retention owed to Subcontractors | [NAME] to LPLL
1
2
3
4
Spreadsheet: 865656d1712682988-how-to-create-a-second-column-on-pivot-table-pivot-problem-2-zanshin777-
Sheet: Sheet2

Activity | Duration (mins) | Category | Priority | Status
Yoga | 60 | Physical Activity | Urgent | Active
Fitness | 60 | Physical Activity | Urgent | Active
Reading | 15 | Health |  | Active
Production | 120 | Work | Urgent | Active
Writing | 30 | Other |  | Passive
Purchasing | 120 | Work | Urgent | Active
Marketing | 30 | Work |  | Passive