tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 291373d1390268812-updating-multiple-worksheets-from-initial-worksheet-list-example_brm
Sheet: Sheet1

MI - 8 Input Expansion`42.5 MPCF
MI - 8 Input Expansion`42.6 MPCF
MI - 8 Input Expansion`46.0 New MITR Control Room
MI - 8 Input Expansion`46.1 New MITR Control Room
MI - 8 Input Expansion`46.5 MITR Chlorine Shed
MI - 8 Input Expansion`46.6 New MITR Control Room
MI - 8 Input Expansion`46.7 New MITR Control Room
MI - 8 Input Expansion`55.0 Telecoms Rm 099 R62 Sub Brace
MI - 8 Input Expansion`55.1 Telecoms Room 099 R62 Sub Brace
MI - 8 Input Expansion`55.2 Telecoms Room 099 R62 Sub Brace
MI - 8 Input Expansion`55.3 Telecoms Room 099 R62 Sub Brace
MI - 8 Input Expansion`55.4 K61 [NAME]
MI - 8 Input Expansion`55.5 K61 Chiller Sub
MI - 8 Input Expansion`61.0 PbSm Substation No.1
MI - 8 Input Expansion`61.1 PbSm Substation No.1
MI - 8 Input Expansion`61.2 PbSm Substation No.1
MI - Door`42.1 MPCF Emergency M/C Door
MI - Door`42.2 MPCF Entry Door
MI - Door`42.3 MPCF Rear Door
MI - Door`44.0.1 [NAME]
MI - Door`44.1.1 CuCo W/House Rigging Gate
MI - Door`46.1 Isa Skills Centre Main Entry
MI - Door`46.2 Isa Skills Centre Student Entry
MI - Door`47.0.1 Met Plants Building S/East Entry
MI - Door`47.0.2 Met Plants Building ADT Office
MI - Door`47.0.3 ADT Work Shop
MI - Door`47.0.4 Met Plants Building East Courtyard Entry
MI - Door`47.0.5 ADT Store Room
MI - Door`47.1 Met Plants Crisis Room
MI - Door`47.1.1 Met Plants Building North Entry
MI - Door`47.2.1 Met Plants Building West Entry
MI - Door`47.2.2 Met Plants Building West Courtyard Entry
MI - Door`47.3.1 Met Plants Building South Downstairs Entry
MI - Door`47.3.2 Met Plants Building South Upstairs Entry
MI - Door`48.2 R62 Upstairs [NAME]
MI - Door`48.3 R62 Upstairs East Exit
MI - Door`48.4 R62 Human Resources
MI - Door`49.0.1 R62 Parts Store
MI - Door`53.0.1 R60 2nd Floor Server Room
MI - Door`53.1 R60 2nd Floor West
MI - Door`53.2 R60 2nd Floor East
MI - Door`53.3 R60 2nd [NAME]
MI - Door`53.4 R60 2nd Floor Plant Room
Spreadsheet: 271833d1382076924-conditional-formating-turn-color-based-on-another-cell-value-test-emp-details
Sheet: Before sheet

Name | Employer | Years of experience
[NAME] | ABC corp | 0
[NAME] | AT&T mobile | 4
[NAME] | T-Mobile
Mini
Goofy |  | 0
[NAME] | Verizion
[NAME] | Verizion
[NAME] | T-Mobile | 5
Spreadsheet: 002ff8f7-34f1-4f75-ab90-dc7586af3484
Sheet: EXP-Other

Expense Exhibit |  |  |  | EXP-Other
Insurance Company: | Insert Company Name
Program | Insert Program Type
Expense Category | Expense Ratio  (% Premium)
(Add/Delete rows as needed) | Fixed | Variable | Total
Commissions
Taxes, Licenses, & Fees
Other Acquisition Expenses
General Expenses
Reinsurance Expenses
Other Expenses
Other Income
Profit and Contingencies
Total Expense and Profit Ratio
Permissible Loss and Fixed Expense Ratio
Insurer Notes:
Notes:
1.  Provide a copy of the actual Insurance Expense Exhibit as submitted with the Annual Statement
2.  Explain and support any significant variances between the expenses reported in this exhibit and the Insurance Expense Exhibit
3. Reinsurance Expenses should be the net cost of reinsurance; a supporting exhibit showing the calculation of the provision is needed
4.  If "Other Expenses" or "Other Income" provisions included, then define (selected expense provisions should be reduced for anticipated fee income)
4a. When including a dividend provision, the company's dividend payment history, the company's current dividend practice, whether dividends are related to loss experience, the capitalization of the company, and other factors affecting the payment of dividends should be taken into account
5.  Profit and Contingencies percentage may not exceed 5.0%
6.  [NAME] exhibit for each Program type being filed
Spreadsheet: 66195d1266898338-matching-criteria-book2
Sheet: Sheet1

Col 1 | Col 2 | Col 3 | Col 4 | Col 5 | Col 6
Stock A | Buy | Cheap | 7 | 4 | 0.05 |  |  | Selection 1 | Buy
Stock B | Hold | Fair Value | 15 | 4 | 0.04 |  |  | Selection 2 | Cheap
Stock C | Buy | Cheap | 191 | 1 | 0.05 |  |  | Selection 3 | 4-8
Stock D | Buy | Cheap | 56 | 7 | 0.013 |  |  | Selection 4 | >3
Stock E | Hold | Fully Priced | 13 | 3 | 0.02 |  |  | Selection 5 | >3%
Stock F | Sell | Expensive | 14 | 5 | 0.027
Stock G | Sell | Expensive | 90 | 2 | 0.056
Stock H | Hold | Cheap | 4 | 1 | 0.008
Stock I | Hold | Fully Priced | 11 | 6 | 0.026
Stock J | Buy | Fair Value | 21 | 5 | 0.035
Stock K | Sell | Fully Priced | 76 | 3 | 0.041 |  |  |  | Selected Criteria
Stock L | Hold | Cheap | 23 | 2 | 0.05 |  |  |  | Stock A
 | Selection 1 | Selection 2 | Selection 3 | Selection 4 | Selection 5
 | Buy | Cheap | <4 | >3 | >3%
 | Hold | Fair Value | 4-8 | >4 | >4%
 | Sell | Fully Priced | 9-15 | >5 | >5%
 |  | Expensive | >16
Spreadsheet: 862078d1709852567-beginner-trouble-sorting-bilateral-trade-paper-2
Sheet: EC440 (3)

Herzog, Blake Richard
[EMAIL]
Country Name | Country Code | Home | Dist | U.S GDP Trillions | Foreign GDP | Foreign GDP (Trillions) | Exports(millions) | Exports(trillions) | Predicted Trade | Actual Trade | Gravity Term
Tunisia | TUN | USA | 7023.72 | 21.38 | 419905540184 | 0.42 | 460.82
Sudan | SDN | USA | 10225.49 | 21.38 | 32338079165 | 0.0323 | 74.09
Serbia | SRB | USA | 8998 | 21.38 | 51514242939 | 0.0515 | 150.72
Portugal | PRT | USA | 5425.189 | 21.38 | 239987000000 | 0.24 | 1715.6
Iraq | IRQ | USA | 9651.111 | 21.38 | 233636000000 | 0.234 | 1189.17
Senegal | SEN | USA | 6157.48 | 21.38 | 23403995992 | 0.0234 | 196.74
Zambia | ZMB | USA | 12156.13 | 21.38 | 23308667781 | 0.0233 | 99.46
Norway | NOR | USA | 5916.703 | 21.38 | 408743000000 | 0.409 | 3897.34
Denmark | DNK | USA | 6191.893 | 21.38 | 346499000000 | 0.346 | 3195.19
Nigeria | NGA | USA | 8493.132 | 21.38 | 474517000000 | 0.475 | 3198.11
Estonia | EST | USA | 6653.48 | 21.38 | 31081901909 | 0.0311 | 410.66
Lithuania | LTU | USA | 6956.313 | 21.38 | 54808531641 | 0.0548 | 933.93
Ireland | IRL | USA | 5117.716 | 21.38 | 398933000000 | 0.399 | 9796.56
United Kingdom | GBR | USA | 5570.161 | 21.38 | 2851410000000 | 2.85 | 69079.94
Belarus | BLR | USA | 7125.836 | 21.38 | 64410122847 | 0.00644101 | 125.11
Switzerland | CHE | USA | 6272.285 | 21.38 | 721369000000 | 0.721369 | 17987.25
Uruguay | URY | USA | 8617.354 | 21.38 | 62048585619 | 0.062 | 1616.18
Kuwait | KWT | USA | 10209.52 | 21.38 | 136192000000 | 0.136 | 3170.73
Peru | PER | USA | 5890.553 | 21.38 | 228326000000 | 0.228 | 9658.28
Cambodia | KHM | USA | 14208.13 | 21.38 | 27089390033 | 0.0271 | 513.94
Australia | AUS | USA | 16008.79 | 21.38 | 1394670000000 | 1.39467 | 25875.48
Armenia | ARM | USA | 9088.867 | 21.38 | 13619290539 | 0.001361 | 52.9
Panama | PAN | USA | 3580.789 | 21.38 | 69721787500 | 0.0697 | 7537.82
Georgia | GEO | USA | 8980.505 | 21.38 | 17470436259 | 0.0175 | 768.65
Jamaica | JAM | USA | 2549.896 | 21.38 | 15830766571 | 0.0158 | 2480.26
Malaysia | MYS | USA | 15130.12 | 21.38 | 365178000000 | 0.365 | 13193.72
Bolivia | BOL | USA | 6400.357 | 21.38 | 40895322851 | 0.0040895 | 552.27
Dominican Republic | DOM | USA | 2508.955 | 21.38 | 88941372558 | 0.008894 | 9208
Costa Rica | CRI | USA | 3564.9 | 21.38 | 64417670521 | 0.0064417 | 6219.63
Bahrain | BHR | USA | 10643.58 | 21.38 | 38653318085 | 0.003865 | 1406.46
Spreadsheet: 705737d1606290336-average-last-n-rows-based-on-conditions-sample
Sheet: Sheet1

Player | Desc | Total | Workings | Divisor | Result
Player A |  | 61
Player A |  | 31
Player A |  | 6
Player A | NB | 74
Player A |  | 2 | 2+74+6+31+61 | Divide by 4
Player A |  | 5 | 5+2+74+6+31 | Divide by 4
Player A | NB | 45 | 45+5+2+74+6 | Divide by 3
Player A |  | 87 | 87+45+5+2+74 | Divide by 3
Player B |  | 6
Player B |  | 44
Player B |  | 9
Player B | DNQ | 0
Player B |  | 17 | 17+9+44+6 | Divide by 5
Player B |  | 3 | 3+17+9+44+6 | Divide by 5
Player B | DNQ | 0 | 3+17+9+44+6 | Divide by 5
Player B | DNQ | 0 | 3+17+9+44+6 | Divide by 5
Player B | NB | 1 | 1+3+17+9+44 | Divide by 4
Player B |  | 2 | 2+1+3+17+9 | Divide by 4
Spreadsheet: 28fef978-a07c-433d-a7de-3a7be567b9d2
Sheet: Summer 2016

2015-2016 Class Schedule |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | You may select up to three classroom attributes.  Select only course requirements, as the number of available classrooms will be reduced with each attribute selected.
[NAME] (including [NAME])
Summer 2016
Subject | Course and Title | Subtitle/Alternate Title | Section | [NAME] | Part of Term | Dates | Days | Times | Credits | Instructor(s) | Instructor ID | FT or Adj | Contract Code | Percentage | Registration Approval | [NAME] | Blackboard Y/N | Campus: [NAME], [NAME], Online, Blended |  |  |  | Cross list?   SUBJ CRSE SEC | Comments
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Classroom Attribute A | Classroom Attribute B | Classroom Attribute C
Spreadsheet: 104706d1302196406-consolidate-duplicate-rows-into-one-cell-test-success
Sheet: extraction

number | first | last | name | original price | price1 | price 2 | price 3 | price 4 | EXTRACT UNIQUE | number | first | price 1 | price 2 | price 3 | price 4 | TOTAL
Spreadsheet: 862965d1710517678-calendar-formulas-and-conditional-formatting-annual-calendar
Sheet: June

 |  |  |  |  |  |  |  |  | JUN
 | NOTES
Spreadsheet: 5d7eb204-26e0-4f5a-bcb5-03d6e75c3be1
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
42809591 | 2014-08-20 22:42:42 | ALLIES | 0 | 5 | 6 | 1611343 | DDB73 | 6154 | mediterranean | 1944-08-20 | 1944-08-26 | Toulon | Toulon
42810074 | 2014-08-20 23:09:06 | AXIS | 0 | 4 | 6 | 1611343 | DDB73 | 6154 | mediterranean | 1944-08-20 | 1944-08-26 | Toulon | Toulon
42810495 | 2014-08-20 23:33:39 | ALLIES | 1 | 6 | 1 | 1174565 | Capt [NAME] | 6154 | mediterranean | 1944-08-20 | 1944-08-26 | Toulon | Toulon
42862515 | 2014-08-24 17:45:58 | AXIS | 0 | 2 | 5 | 243582 | Vercingetorix1302 | 6153 | western | 1944-08-24 | 1944-08-24 | Liberation of Paris | Libération de Paris
42862670 | 2014-08-24 18:16:14 | ALLIES | 1 | 5 | 4 | 243582 | Vercingetorix1302 | 6153 | western | 1944-08-24 | 1944-08-24 | Liberation of Paris | Libération de Paris
42880530 | 2014-08-25 22:26:40 | AXIS | 1 | 6 | 3 | 704025 | secret_strategem | 6150 | mediterranean | 1944-08-25 | 1944-08-25 | [NAME] | [NAME]
42882039 | 2014-08-26 00:19:22 | ALLIES | 0 | 4 | 6 | 719682 | marc2601 | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
42882564 | 2014-08-26 00:39:27 | AXIS | 0 | 3 | 6 | 719682 | marc2601 | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
Spreadsheet: 887535d1737755664-generating-1-column-of-data-into-a-calendar-reviews-calendar-test_3
Sheet: Nov

 |  |  | 2026-11-02 00:00:00 | 2026-11-03 00:00:00 | 2026-11-04 00:00:00 | 2026-11-05 00:00:00 | 2026-11-06 00:00:00 | 2026-11-07 00:00:00
 |  |  | 2026-11-09 00:00:00 | 2026-11-10 00:00:00 | 2026-11-11 00:00:00 | 2026-11-12 00:00:00 | 2026-11-13 00:00:00 | 2026-11-14 00:00:00
 |  |  | 2026-11-16 00:00:00 | 2026-11-17 00:00:00 | 2026-11-18 00:00:00 | 2026-11-19 00:00:00 | 2026-11-20 00:00:00 | 2026-11-21 00:00:00
 |  |  | 2026-11-23 00:00:00 | 2026-11-24 00:00:00 | 2026-11-25 00:00:00 | 2026-11-26 00:00:00 | 2026-11-27 00:00:00 | 2026-11-28 00:00:00
 |  |  | 2026-11-30 00:00:00 | 2026-12-01 00:00:00 | 2026-12-02 00:00:00 | 2026-12-03 00:00:00 | 2026-12-04 00:00:00 | 2026-12-05 00:00:00
 |  |  | 2026-12-07 00:00:00 | Notes
Spreadsheet: 0064f787-13e0-41fa-bcba-96215b953a37
Sheet: B

Course color corresponds with term of offering.  Blue for Spring semester, PURPLE for J-term, GREEN for both Spring and J-term.
 | AOK Designation | CAR Designation | Comment
Biology
BIOL 121 | Natural & Mathematical Sciences-Nat Sci w Lab
BIOL 122 | Natural & Mathematical Sciences-Nat Sci w Lab
BIOL 124 | Natural & Mathematical Sciences-Nat Sci w Lab
BIOL 125 | Natural & Mathematical Sciences-Nat Sci w Lab
BIOL 126 | Natural & Mathematical Sciences-Nat Sci w Lab
BIOL 127 | Natural & Mathematical Sciences-Nat Sci w Lab
BIOL 129 | Natural & Mathematical Sciences-Nat Sci w Lab
BIOL 133 | Natural & Mathematical Sciences-Nat Sci w Lab
BIOL 151 | Natural & Mathematical Sciences-Nat Sci w Lab
BIOL 155 | Natural & Mathematical Sciences-Nat Sci w Lab
BIOL 175 | Natural & Mathematical Sciences-Nat Sci w Lab
BIOL 182 | Natural & Mathematical Sciences-Nat Sci w Lab
BIOL 250 |  | Experiential-Travel
BIOL 309 | Natural & Mathematical Sciences-Nat Sci w Lab
BIOL 315 | Natural & Mathematical Sciences-Nat Sci w Lab
BIOL 333 | Natural & Mathematical Sciences-Nat Sci w Lab | Experiential-Travel
BIOL 335 | Natural & Mathematical Sciences-Nat Sci w Lab | Experiential-Travel
BIOL 350 |  | Computing
BIOL 381 | Natural & Mathematical Sciences-Nat Sci w Lab |  | 2009-2010 (Flies, Fishes, and Foods)
BIOL381 | Natural & Mathematical Sciences-Nat Sci w Lab |  | Summer 2013 (Special Topics in General Zoology)
 |  |  | Fall 2011 (Evolution & Natural Selection)
BIOL 400 |  | Experiential-Research; Capstone
BIOL 450 |  | Experiential-Research
BIOL 487-488 |  | Experiential-Research; Capstone
BIOL 491-492 |  | Experiential-Research
BIOL 493-494 |  | Experiential-Research
BIOL 496-498 |  | Experiential-Research; Capstone
BIOL 499 |  | Capstone
Black Studies
BLST 160 | Social Sciences | Non-Western, Experiential-Travel | Cross-listed with PSYC 160
BLST 201 | Social Sciences |  | Cross-listed with SOCI 225
BLST 381 |  | Experiential-Travel | J-Term 2009,2010;2012  Cross-listed with HIST 381
BLST 381 | Arts & Literature-Arts |  | J-Term 2013 (Black American Theatre)
Business
BUSN 111 | Social Sciences
BUSN 213 | Social Sciences
BUSN 336 |  | Computing
BUSN 425 |  | Capstone | Accounting & Economics/Business major
BUSN 450-451 |  | Experiential-Internship, Capstone | Economics/Business major
BUSN 452 |  | Capstone; Experiential-Internship | Accounting major
BUSN 455 |  | Capstone; Experiential-Field Studies
BUSN 481 |  | Experiential-Travel | J-Term 2014(Industrailization: Progression of Industrail Rev.In GB)
BUSN 491-492 |  | Capstone; Experiential-Research | Accounting & Economics/Business major
BUSN 496-498 |  | Capstone; Experiential-Research | Accounting & Economics/Business major
Spreadsheet: 744874d1629516092-start-index-match-from-a-specific-cell-reference-example-list_2
Sheet: Sheet1

 |  | Player 1
 |  | Player 2
 |  | Player 3
 |  | Player 4
 |  | Player 5
 |  | Player 2
 |  | Player 3
 |  | Player 4
 |  | Player 5
 |  | Player 1
 |  | Player 5
 |  | Player 4
 |  | Player 3
 |  | Player 2
 |  | Player 1
 |  | Player 5
 |  | Player 2
 |  | Player 3
 |  | Player 4
 |  | Player 5
 |  | Player 1
 |  | Player 5
 |  | Player 4
 |  | Player 3
 |  | Player 2
 |  | Player 1
 |  | Player 4
 |  | Player 5
 |  | Player 1 | 142 | Y
 |  | Player 2 | 154 | N
 |  | Player 3 | 160 | Y
 |  | Player 4 | 166 | N
 |  | Player 5 | 172 | Y
Spreadsheet: 816124d1675380596-randomise-data-from-a-column-into-another-sample
Sheet: Sheet1

Original List | Randomised List
[NAME] | [NAME]
Charles (B&W) | George (B&W)
[NAME] | [NAME]
[NAME] (B&W) | [NAME] (B&W)
George | [NAME]
George (B&W) | [NAME] (B&W)
[NAME] | [NAME]
James (B&W) | [NAME] (B&W)
[NAME] | [NAME]
[NAME] (B&W) | [NAME] (B&W)
[NAME] | [NAME]
[NAME] (B&W) | [NAME] (B&W)
[NAME] | [NAME]
[NAME] (B&W) | [NAME] (B&W)
[NAME] | [NAME]
[NAME] (B&W) | [NAME] (B&W)
[NAME] | George
[NAME] (B&W) | Charles (B&W)
[NAME] | [NAME]
[NAME] (B&W) | James (B&W)
Spreadsheet: andy_zipper__263__Broker detail 4-27-01 
Sheet: FAILED DEALS SUMMARY

EnronOnline
[NAME] for 4/26/2001
Failed Transactions:
LIFE TO DATE
FAILED TRANSACTION COUNT |  | Commodity
Broker | Failed Reason | Natural Gas | Power | Grand Total
APB Energy, Inc. | FAILURE: counterparty exceeded credit limit | 1 |  | 1
 | [NAME]: counterparty has no bid access to product | 1 | 5 | 6
 | FAILURE: Limit price violated |  | 4 | 4
 | [NAME]: traded-for counterparty has a collateralized GTC and brokered | 5 |  | 5
 | FAILURE: Volume not available for base product of hedge | 1 |  | 1
APB Energy, Inc. Total |  | 8 | 9 | 17
Natsource LLC | FAILURE: counterparty exceeded credit limit |  | 4 | 4
 | [NAME]: counterparty has no bid access to product | 1 | 1 | 2
 | [NAME]: counterparty has no offer access to product |  | 3 | 3
 | FAILURE: Limit price violated |  | 1 | 1
 | [NAME]: product violates counterparty term limit |  | 2 | 2
 | [NAME]: traded-for counterparty has a collateralized GTC and brokered | 1 | 6 | 7
Natsource LLC Total |  | 2 | 17 | 19
Power Merchants Group, LLC | FAILURE: counterparty exceeded credit limit | 1 |  | 1
 | FAILURE: Limit price violated | 10 |  | 10
 | [NAME]: traded-for counterparty has a collateralized GTC and brokered | 1 |  | 1
Power Merchants Group, LLC Total |  | 12 |  | 12
Grand Total |  | 22 | 26 | 48
Spreadsheet: 110063d1306853263-print-range-of-pdf-files-test-file
Sheet: Index

Sheet Number | Description | Issue Number | Release Date | Approved By | File Location | Last Release Date | Amended By | Approved By | EDM Number
 | Section 1
5001 | Trolley Wheels Fitting | 1 | 2011-05-20 00:00:00 | ABR | Click Here
5002 | [NAME] | 1 | 2011-05-20 00:00:00 | ABR | Click Here
5003 | Drill Holes In Chassis | 1 | 2011-05-20 00:00:00 | ABR | Click Here
5004 | Chassis Earthing Points | 1 | 2011-05-20 00:00:00 | ABR | Click Here
5005 | Auxiliary Motor & Pump Prep | 1 | 2011-05-20 00:00:00 | ABR | Click Here
5006 | Auxiliary Motor & Pump Fitting | 1 | 2011-05-20 00:00:00 | ABR | Click Here
5007 | Pressure Filter | 1 | 2011-05-20 00:00:00 | ABR | Click Here
5008 | Compressor & Motor Assembly Mounting Brackets | 1 | 2011-05-20 00:00:00 | ABR | Click Here
5009 | Battery Mounting Pads | 1 | 2011-05-20 00:00:00 | ABR | Click Here
5010 | Hopper Dump Valve Bulkhead Adaptor | 1 | 2011-05-20 00:00:00 | ABR | Click Here
5011 | Sequence Valve Prep | 1 | 2011-05-20 00:00:00 | ABR | Click Here
5012 | Sequence Valve Fitting | 1 | 2011-05-20 00:00:00 | ABR | Click Here
5013 | Hopper Dump Valve Prep | 1 | 2011-05-20 00:00:00 | ABR | Click Here
5014 | Hopper Dump Valve Fitting | 1 | 2011-05-20 00:00:00 | ABR | Click Here
5015 | [NAME] | 1 | 2011-05-20 00:00:00 | ABR | Click Here
5016 | Water Pump Assembly | 1 | 2011-05-20 00:00:00 | ABR | Click Here
5017 | Water Pump Fitting | 1 | 2011-05-20 00:00:00 | ABR | Click Here
5018 | Water Manifold Assembly | 1 | 2011-05-20 00:00:00 | ABR | Click Here
5019 | Water Manifold Fitting | 1 | 2011-05-20 00:00:00 | ABR | Click Here
5020 | Water Strainer Assembly | 1 | 2011-05-20 00:00:00 | ABR | Click Here
5021 | Water Strainer Fitting | 1 | 2011-05-20 00:00:00 | ABR | Click Here
5022 | Hopper Cylinders Fitting | 1 | 2011-05-20 00:00:00 | ABR | Click Here
5023 | Side Panel Pivots Prep | 1 | 2011-05-20 00:00:00 | ABR | Click Here
5024 | Side Panel Pivots Fitting | 1 | 2011-05-20 00:00:00 | ABR | Click Here
5025 | Side Panel Latch Mounting Brackets | 1 | 2011-05-20 00:00:00 | ABR | Click Here
5026 | Chassis Gas [NAME] Joints | 1 | 2011-05-20 00:00:00 | ABR | Click Here
5027 | [NAME] | 1 | 2011-05-20 00:00:00 | ABR | Click Here
5028 | Chassis Conical Stops | 1 | 2011-05-20 00:00:00 | ABR | Click Here
5029 | Battery Locating Pins | 1 | 2011-05-20 00:00:00 | ABR | Click Here
5030 | [NAME] | 1 | 2011-05-20 00:00:00 | ABR | Click Here
5031 | Front Axle Fitting | 1 | 2011-05-20 00:00:00 | ABR | Click Here
5032 | Rear Axle Fitting | 1 | 2011-05-20 00:00:00 | ABR | Click Here
5033 | Handbrake Cables Fitting | 1 | 2011-05-20 00:00:00 | ABR | Click Here
5034 | Battery Pack Plungers | 1 | 2011-05-20 00:00:00 | ABR | Click Here
5035 | Hydraulic Tank Assembly | 1 | 2011-05-20 00:00:00 | ABR | Click Here
5036 | Hydraulic Tank Fitting | 1 | 2011-05-20 00:00:00 | ABR | Click Here
5037 | Chassis Brake Pipes | 1 | 2011-05-20 00:00:00 | ABR | Click Here
5038 | Water Hoses | 1 | 2011-05-20 00:00:00 | ABR | Click Here
5039 | Screenwash Hose & Chassis Camera Cable | 1 | 2011-05-20 00:00:00 | ABR | Click Here
Spreadsheet: 767279d1644390509-merge-two-sheets-in-a-third-one-sheet1-sheet2
Sheet: A+B

title1 | title2 | title3 |  | what i need to have
a | 1 | blue
b | 2 | green
c | 3 | yellow
d | 4 | blue
e | 5 | white
f | 6 | black
g | 7 | yellow
h | 8 | red
Spreadsheet: 267989d1380334539-create-a-searchable-excel-document-spreadsheet-example-mlcb
Sheet: data

first name | last name | address | city | state | zip | phone
[NAME] | doe | 5487 n 1 st | any city | WA | 86547 | [PHONE]
[NAME] | [NAME] | 512 n a st | anycity | CA | 99206 | [PHONE]
[NAME] | [NAME] | 124 e main | any city | Ca | 99206 | [PHONE]
[NAME] | [NAME] | 457 e Washington | any city | WA | 86547 | [PHONE]
Spreadsheet: 748822d1632372832-how-to-extract-purchase-unit-cost-and-check-duplicates-of-same-product-book1
Sheet: Sheet 2 

Product | Product Description | Purchase Cost |  | Duplicate of Product
102094 | a | 6.8
102233 | a | 2.25
103079 | a | 23
104245 | a | 18
104250 | a | 72
104272 | a | 9
104352 | a | 2.2
105092 | a | 1.5
105097 | a | 3.5
105124 | a | 1.8
105169 | a | 1.65
106065 | a | 60
107003 | a | 43.5
107006 | a | 3
107015 | a | 0.6
107017 | a | 4
107020 | a | 2.25
107026 | a | 69
107029 | a | 47.5
107030 | a | 1.15
107042 | a | 2.75
107043 | a | 1.2
107050 | a | 1.2
107051 | a | 3.5
107052 | a | 66
107053 | a | 17
107058 | a | 40
107065 | a | 27.38
107067 | a | 0.6
107072 | a | 84
107074 | a | 3.2
107080 | a | 31.2
107092 | a | 40
107105 | a | 2.6
107114 | a | 1.8
107119 | a | 2.3
107122 | a | 1.8
107122 | a | 2
107132 | a | 6.2
107170 | a | 76.86
107172 | a | 32.04
107177 | a | 6.5
107186 | a | 1.15
107188 | a | 1.8
107191 | a | 6.3
107202 | a | 0.55
Spreadsheet: ffdb6960-3eaa-42df-81ff-df5415aac0b3
Sheet: Income Statement

 |  | Current Period | Prior Period
 | Notes | ([NAME]) | ([NAME])
 |  | 1 January 2011 – | 1 January 2010 –
 |  | 31 March 2011 | 31 March 2010
Revenue | 5 | 2886897 | 2583509
Cost of sales (-) |  | -1200267 | -1229967
Gross profit |  | 1686630 | 1353542
Marketing, sales and distribution expenses (-) |  | -468468 | -348709
General administrative expenses (-) |  | -402773 | -368068
Research and development expenses (-) |  | -8916 | -9255
Other operating income |  | 91399 | 89082
Other operating expense (-) |  | -24364 | -27424
Operating profit |  | 873508 | 689168
Financial income |  | 168051 | 138311
Financial expense (-) |  | -289394 | -129760
Profit before tax |  | 752165 | 697719
Tax expense
Tax expense for the period |  | -210250 | -212378
Deferred tax income |  | 29374 | 18347
Net profit |  | 571289 | 503688
Attribution of net profit
Attributable to equity holders of the parent |  | 608840 | 546255
Minority interest |  | -37551 | -42567
 |  | 608840 | 546255
Earnings per shares attributable to equity holders of the parent from (in full Kuruş) (Note 4) |  | 0.174 | 0.1561
Earnings per diluted shares attributable to equity holders of the parent from (in full Kuruş) (Note 4) |  | 0.174 | 0.1561
Spreadsheet: 393289d1430931391-npv-with-dynamic-range-npv-with-dynamic-range
Sheet: Sheet1

2019 | 2015
 | 0 | 0 | 0 | 0 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000
 |  |  |  |  |  |  |  |  |  |  | This is the NPV at each point in time. The NPV of years 2019-2024 should be $101,513.84. Your solution is also right.
would like B2 to be NPV of cells in row 2 that occur after year specified in A2
I think this also works if I assume A2 is the first year to be "discounted"