tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 841808d1693963741-nested-if-formula-with-an-error-testworkbook
Sheet: worksheet

PLE Weekly Wine Sales - CMW (station and employee name) |  |  | All T/A = Cellar Door |  | Check w/c = cd
Pt Leo Item Sales, 8/2/2018 12:49 PM |  |  | All Cocktail = [NAME]
[NAME] | Venue Area | [NAME] | [NAME] | Deptartment Name | Item Name | Net Quantity | Net of GST | PLE Name | Product | Variety | Type | Total Bottles | Month | Venue 2 | Venue 3 | Venue 4
2023-08-01 00:00:00 | Cellar Door | [NAME] O | REC1 | PLE - Bottle | Bt 2 Friends [NAME] 20 | 1 | 54.55 |  |  |  |  |  | August
2023-08-01 00:00:00 | Cellar Door | [NAME] O | REC1 | PLE - Bottle | Bt PLE Chard. 19 | 2 | 120 |  |  |  |  |  | August
2023-08-01 00:00:00 | Cellar Door | [NAME] O | REC1 | PLE - Bottle | Bt PLE N/V Spark. V21 | 5 | 300 |  |  |  |  |  | August
2023-08-01 00:00:00 | Cellar Door | [NAME] O | REC1 | PLE - Bottle | Bt PLE P.Gris 20 | 1 | 45.45 |  |  |  |  |  | August
2023-08-01 00:00:00 | Cellar Door | [NAME] O | REC1 | PLE - Bottle | Bt PLE P.Noir 19 | 2 | 120 |  |  |  |  |  | August
2023-08-01 00:00:00 | Cellar Door | Doshii | Local station | PLE - Glass | Gl PLE Method Traditionelle 2018 | 3 | 49.09 |  |  |  |  |  | August
2023-08-01 00:00:00 | Cellar Door | Doshii | Local station | PLE - Online | O/L Bt PLE P.Gris 20 | 2 | 0 |  |  |  |  |  | August
2023-08-01 00:00:00 | Cellar Door | Doshii | Local station | PLE - Online | O/L Bt PLE P.Noir 19 | 2 | 0 |  |  |  |  |  | August
2023-08-01 00:00:00 | Cellar Door | Doshii | Local station | PLE - Online | O/L Bt PLE Rose 22 | 2 | 0 |  |  |  |  |  | August
2023-08-01 00:00:00 | Cellar Door | Doshii | Local station | PLE - Online Packs | O/L Spring 3-Pack 23 | 2 | 182.73 |  |  |  |  |  | August
Spreadsheet: 166e7177-b0ba-4f29-98a8-38fc9470a2be
Sheet: Sheet1

GENERAL | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15
Resolution Fact Sheet |  |  |  |  |  |  | Resolution Number
Brief Title |  |  | Approval Deadline |  | Reason
 | Chouteau I-35 TIF Plan
 | 5 Year Status Report
Details |  |  |  |  | Positions/Recommendations
 | Specific Address |  |  |  | Sponsor
 |  |  |  |  | Programs,
 |  |  |  |  | Departments,
 |  |  |  |  | or Groups
 |  |  |  |  | Affected
 | Reason For Legislation
 |  |  |  |  | Applicants / |  | Applicant: Tax Increment Financing
 |  |  |  |  | Proponents |  | Commission
 |  |  |  |  |  |  | Other
 |  |  |  |  | Opponents |  | Groups or Individuals
 |  |  |  |  |  |  | Basis of opposition
 |  |  |  |  | Staff |  | X |  | For
 |  |  |  |  | Recommendation
 |  |  |  |  |  |  |  |  | Against
 |  |  |  |  |  |  | Reason Against
 |  |  |  |  | Board or
 |  |  |  |  | Commission |  | By |  |  | Tax Increment Financing Com.
 |  |  |  |  | Recommendation |  |  |  |  |  | Resolution
 |  |  |  |  |  |  | X |  | For |  |  |  | Against |  | No action taken
 |  |  |  |  |  |  |  |  | For, with revisions or conditions
 |  |  |  |  |  |  |  |  | (see details column for conditions)
 |  |  |  |  | Council
 |  |  |  |  | Committee Actions |  | x |  | Do pass
 |  |  |  |  |  |  |  |  | Do pass (as amended)
 |  |  |  |  |  |  |  |  | Committee Sub.
 |  |  |  |  |  |  |  |  | Without Recommendation
 |  |  |  |  |  |  |  |  | Hold
 |  |  |  |  |  |  |  |  | Do not pass
 |  |  |  |  |  |  |  |  |  |  |  | (Continued on next page)
Details
 |  |  |  |  | Policy/Program Impact
 |  |  |  |  | Policy or Program
 |  |  |  |  | Change |  | X |  | No |  |  |  | Yes
 |  |  |  |  | Operational
 |  |  |  |  | Impact
 |  |  |  |  | Assessment
 |  |  |  |  | Finances
 |  |  |  |  | Cost & Revenue
 |  |  |  |  | Projections --
 |  |  |  |  | Including Indirect
 |  |  |  |  | Costs
 |  |  |  |  | Financial Impact
 |  |  |  |  | Fund Source (s)
 |  |  |  |  | and Appropriation
 |  |  |  |  | Account Codes
Applicable Dates:
 | Approved by TIF Commission on December 8, 2004 by Resolution No. 12-7-04
Fact Sheet Prepared by:
Reviewed by:
Reference Numbers
Spreadsheet: john_forney__15519__s_9-10-01
Sheet: Sheet1

Flow Date |  | Available Off Peak Capacity |  |  |  |  |  |  | Available On Peak Capacity |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Available Off Peak Capacity
2001-09-10 00:00:00
Counterparty |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24
[NAME] |  | 135 | 135 | 135 | 135 | 135 | 135 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 135 | 135
Enron Call |  |  |  |  |  |  |  | -100 | -100 | -100 | -100 | -100 | -100 | -100 | -100 | -100 | -100 | -100 | -100 | -100 | -100 | -100 | -100
Mirant Call |  |  |  |  |  |  |  |  |  | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50
CP1 |  |  |  |  |  |  |  | -100 | -100 | -100 | -100 | -100 | -100 | -100 | -100 | -100 | -100 | -100 | -100 | -100 | -100 | -100 | -100
CP2 |  | -55 | -55 | -55 | -55 | -55 | -55 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -55 | -55
CP3 |  | -50 | -50 | -50 | -50 | -50 | -50 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -50 | -50
CP4 |  | -30 | -30 | -30 | -30 | -30 | -30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -30 | -30
CP5 |  |  |  |  |  |  |  | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50
CP6 |  |  |  |  |  |  |  | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50
Total
[NAME]: |  | Deal Details
22
Deal_id |  | CP | Volume | Price | Start Hour |  | End Hour
 |  | Mirant Call | -50 |  | 9 |  | 24
765924.1 |  | [NAME] | 135 | 22 | 1 |  | 6
765924.1 |  | [NAME] | 200 | 22 | 7 |  | 22
765924.1 |  | [NAME] | 135 | 22 | 23 |  | 24
758660.5 |  | Enron Call | -100 |  | 7 |  | 22
766962.1 |  | CP6 | -50 | 22.5 | 7 |  | 22
766614.1 |  | CP5 | -50 | 21.25 | 7 |  | 22
766212.1 |  | CP4 | -30 | 10 | 1 |  | 6
766212.1 |  | CP4 | -30 | 10 | 23 |  | 24
766125.1 |  | CP3 | -50 | 11 | 1 |  | 6
766125.1 |  | CP3 | -50 | 11 | 23 |  | 24
766017.1 |  | CP2 | -55 | 11 | 1 |  | 6
766017.1 |  | CP2 | -55 | 11 | 23 |  | 24
765970.1 |  | CP1 | -50 | 22.5 | 7 |  | 22
766012.1 |  | CP1 | -50 | 22.25 | 7 |  | 22
Spreadsheet: 25467eea-74c3-4eea-b7a9-c6ae05e72fc5
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Managed Futures Strategy HV Fund
 | Monthly Performance History
 | Inception Date | 2013-07-16 00:00:00
 |  | Class N | Class I | Newedge CTA | ML 3-Month T-bill Index
 | Date | QMHNX | QMHIX | Trend Sub-Index | Index
* | 2013-07-31 00:00:00 | 0.0009999999999998899 | 0.0009999999999998899 | -0.005578512396694268 | -7.254167156300895e-06
 | 2013-08-31 00:00:00 | -0.005994005994006013 | -0.004995004995004937 | -0.02528049287250034 | 4.787785054571891e-05
 | 2013-09-30 00:00:00 | -0.0261306533 | -0.0261044177 | -0.005949981232535761 | 4.788e-05
 | 2013-10-31 00:00:00 | 0.0144478844 | 0.0144329897 | 0.02548539729156563 | -3.77183e-05
 | 2013-11-30 00:00:00 | 0.05595116988809767 | 0.05589430894308944 | 0.02702039257757405 | 5.948115027853973e-05
 | 2013-12-31 00:00:00 | 0.04081745 | 0.040778132 | 0.006462292963183014 | 0.00013056
 | 2014-01-31 00:00:00 | -0.04819277108433739 | -0.04814814814814816 | -0.0444574424107026 | 0.00013056
 | * partial month return, inception date [NAME]
 | Managed Futures Strategy HV Fund
 | [NAME]
 | Month-end Returns as of | Class N | Class I | Newedge CTA | ML 3-Month T-bill Index
 | January 31, 2014 | QMHNX | QMHIX | Trend Sub-Index | Index
 | 1 Year
 | 3 Years
 | 5 Years
 | 10 Years
 | Since Inception Cumulative Return | 0.0283025606087397 | 0.02930258938967345 | -0.02408821415738382 | 0.0003714336547242514
 | Since Inception Annualized Return
 | Since Inception Annualized Monthly Volatility | 0.1060733468614024 | 0.1055872046453045 | 0.07815582995301125 | 0.0001466254577274554
 | Quarter-end Returns as of | Class N | Class I | Newedge CTA | ML 3-Month T-bill Index
 | December 31, 2013 | QMHNX | QMHIX | Trend Sub-Index | Index
 | 1 Year
 | 3 Years
 | 5 Years
 | 10 Years
 | Since Inception Cumulative Return | 0.08036851304462522 | 0.08136847912533796 | 0.02131692418253728 | 0.0002408422103654662
 | Since Inception Annualized Return
Spreadsheet: 147830d1332993771-eliminating-deminishing-daily-averages-excel_testing
Sheet: Sheet1

MONTH | MISSIONS
JAN | 17
FEB | 75
MAR | 86
APR | 3
MAY
JUN
JUL
AUG
SEP
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
Spreadsheet: 67833d1268339973-tables-and-formulas-dummyexample
Sheet: Sheet1

10 | jared |  |  |  | 88 | adress
15 | bill |  |  |  | 15 | adress
61 | [NAME] |  |  |  | 77 | adress
77 | [NAME] |  |  |  | 65 | adress
65 | Doug |  |  |  | 5 | adress
5 | [NAME] |  |  |  | 1 | adress
1 | [NAME] |  |  |  | 63 | adress
88 | [NAME] |  |  |  | 45 | adress
14 | [NAME] |  |  |  | 61 | adress
45 | vinny |  |  |  | 14 | adress
63 | [NAME] |  |  |  | 10 | adress
Spreadsheet: 42900082-c13f-4807-9c53-005f550dd1e3
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2011-10-18 09:22:22.030000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.5 | 101.786 | 101.661 | 101.536 | 101.161 |  | and are added to price quote
4.375 | 101.279 | 101.154 | 101.029 | 100.654
4.25 | 100.586 | 100.461 | 100.336 | 99.961 |  | Note: | Refer To Price [NAME]
4.125 | 100.165 | 100.04 | 99.915 | 99.54 |  |  | For all Price Adjs
4 | 99.695 | 99.57 | 99.445 | 98.82
3.875 | 99.094 | 98.969 | 98.844 | 98.219
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.875 | 101.456 | 101.331 | 101.206 | 100.831
3.75 | 100.956 | 100.831 | 100.706 | 100.331
3.625 | 100.604 | 100.479 | 100.354 | 99.979
3.5 | 100.273 | 100.148 | 100.023 | 99.648
3.375 | 99.863 | 99.738 | 99.613 | 98.988
3.25 | 99.289 | 99.164 | 99.039 | 98.414
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2011-11-01 09:22:22.030000
30 DAY | 2011-11-16 09:22:22.030000
45 DAY | 2011-12-01 09:22:22.030000
60 DAY | 2011-12-16 09:22:22.030000
90 DAY | 2012-01-15 09:22:22.030000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 818705d1677006104-not-vlookup-formula-in-excel-excel-file-etaf
Sheet: Sheet1

 | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 |  |  |  |  | Project Number | 2023-01-01 00:00:00 | 2023-02-01 00:00:00
40105254 | 5973.69 | 2110.7 |  |  |  |  | 21605071
30405165 | 7394.81 | 317.35 |  |  |  |  | 21605069
20305170 | 27.03 | 3256.6 |  |  |  |  | 31005068
20305171 | 2055.24 | 3012.58 |  |  |  |  | 21605068
20205066 | 42898.13 | 34812.37 |  |  |  |  | 21605069
20205061 | 3568.67 | 371.4 |  |  |  |  | 31005070
20305168 | 221.04 | 11071.47 |  |  |  |  | 02807103
40105252 | 19609.86 |  |  |  |  |  | 31005071
02807103 | 3082.14 |  |  |  |  |  | 21605070
09906958 | 231.82 | 155.81
40105256 | 10383.3 | 10509.72
40105197 | 6955.7 | 864.75
20305169 | -2894.88 | 3202.02
40105249 |  | 85.74
40105259 |  | 17.19
30405194 | 3022.3 | 6588.45
30405179 | 0 | -6556.41
30405195 | 202.8
30405181 | 243.49
09907123 | 1774.75 | 112.38
30405185 | 37.28
30405190 | 34.89
30405199 |  | 440
30405187 | 9651.72
20305174 |  | 784.51
61005122 | -11607.62 | 3565.41
61005115 | 304.88
61005125 | -6813.43
61005124 | 23788.53 | 140.24
21205273 | 0 | -415.84
21205302 |  | 218.75
21205303 |  | 35992.63
21205298 | 4538.07 | 625
21205274 | 0 | -415.84
21205297 | 2324.52 | -2110
61004500 | -5204.66
20105040 | 111.09 | 941.8
20105041 | 7601.95 | 3394
20505090 | 3340.08 | 4658.16
30005107 |  | 1463.85
30005101 | 434.28 | 694.2
30005105 | -26.52
20505098 | 160.41
09906899 | 201.19
20405044 | 10.04
21605059 | 91859.47 | -91220.5
21605069 | 361.01 | 126.44
21605069 | 70 | 100
21605071 | 21705.93 | 1449.63
21605068 | 8220.28 | -3591
31005070 | 4.25
21605070 | 168.49 | 179.28
31005071 |  | 4829.91
31005071 |  | 1000
Spreadsheet: phillip_allen__28811__Westgate Proforma-Phillip Allen
Sheet: 1302SF 2Sty

TWO STORY DUPLEX PLAN B:  3 Bedroom, 2 1/2 Bath, 1302 SF
Descriptions | Qty. | Unit | Unit Cost | Unit Total | Per SF | Unit Total W/Ovrhd | Per SF
Area Calculations: |  |  |  | Masonry |  |  | S.F.
Heated Area: |  |  |  | Foundation |  |  | S.F.
Lower Level | 866 | S.F. |  | Flatwork
Upper Level | 436 | S.F. |  | Patio |  |  | S.F.
Total Heated |  | S.F. |  | Second patio |  | 0
 |  |  |  | Walk
Other Covered Areas: |  |  |  | Driveway
Garage | 386 | S.F. |  | Windows |  | 9
Entry/Covd Porch | 22 | S.F. |  | Ext. Doors |  | 1
Total Other Covered |  | S.F. |  | Interior Doors |  | 9
Total Covered SF |  | S.F. |  | Const.Time |  |  | Months
Professional Services
Architectural | 0 | L.S. |  |  |  |  |  | Rear Patio
Structural Engineering |  | S.F. | 0.15 |  |  |  |  | Courtyard | 0
Construction Surveying | 0 | L.S. | 315 |  |  |  |  | Front Walk |  |  | 3.5
Interior Design | 1 | L.S. | 0
Permits & Fees
Building Permits | 1 | L.S. | 150
Building Inspections | 1 | L.S. | 100
Utility Connections | 1 | L.S. | 0
Insurance
Builder's Risk |  | Mos.
General Liability | 1 | L.S. | 500
Temporary Utilities
Electricity |  | Mos. | 30
Water |  | Mos. | 30
Sanitary Facilities |  | Mos. | 10
Clean Up
Site Clean Up | 1 | L.S. | 750
Building Clean |  | S.F. | 0.1
Sitework
Environmental Controls | 0 | L.S. | 0
Lot Clear | 1 | Each | 150
Finish Grading | 1 | L.S. | 150
Sprinkler System | 1 | L.S. | 0
Landscaping | 1 | L.S. | 0
Privacy Fencing | 0 | L.F. | 15
Fence Gate | 0 | L.S. | 100
Concrete Work
Foundation |  | S.F. | 5.75
Underpinning | 1 | L.S. | 100
Flatwork |  | S.F. | 2
Driveway |  | S.F. | 2.25
Carpentry
Framing Materials |  | S.F. | 2.5
[NAME] |  | S.F. | 1.9
[NAME] |  | S.F. | 1.2
Framing Labor |  | S.F. | 3.5
Entry Door | 1 | L.S. | 285
Exterior Doors |  | LS | 285
Trim Materials |  | S.F. | 0.6
Interior Doors |  | DRS | 85
Trim Labor |  | S.F. | 0.6
Base Cabinets | 33 | L.F. | 60
Upper Cabinets | 16 | L.F. | 30
Glass & Mirrors
Windows |  | Wdws. | 85
Shower Enclosures | 0 | L.S. | 0
Mirrors | 36 | S.F. | 5
Moisture Protectors
Roofing & Flashing |  | SQS. | 52
Gutters | 1 | L.S. | 200
Insulation |  | S.F. | 0.75
Drywall |  | S.F. | 3
Masonry
Stone Veneer |  | S.F. | 5.5
Painting (Heated) |  | S.F. | 2
Painting (Covered) |  | S.F. | 0.6
[NAME] | 48 | S.F. | 5.5
Carpet & Vinyl |  | S.Y. | 15
Laminate Counters | 27 | L.F. | 24
Syn. Marble Counters | 9 | L.F. | 24
Syn. Marble Lavatories | 2 | Lavs | 40
Syn. Marble Tubs | 0 | Tub | 750
[NAME] | 1 | Tub | 300
Window Treatments |  | WDWS. | 35
F.P. Treatments | 0 | L.S. | 0
Specialties
Hardware | 1 | L.S. | 500
Metal Fireplaces | 0 | EA. | 650
Overhead Door & Openor | 1 | DRS. | 700
Electrical
Wiring & Panels |  | S.F. | 2.25
Fixtures | 1 | L.S. | 750
TV. Phone Prewire | 1 | L.S. | 150
Mechanical
Plumbing | 1 | L.S. | 4200
Laterals | 25 | L.F. | 15
Plumbing Fixtures | 1 | L.S. | 2000
Appliances | 1 | L.S. | 990
HVAC |  | L.S. | 2.85
Supervision |  | Mos.
TOTAL
Spreadsheet: 35581d1233175794-elements-from-total-solver
Sheet: Solver

 | Amounts | Match? |  | Target | 154.61 |  |  |  | 0
 | 84.83 |  |  |  |  |  |  |  | 2
 | 62.45 |  |  | Current Match | 0 |  |  |  | 1
 | 22.31 |  |  | Difference | 154.61 |  |  |  | 100
 | 51.53
 | 24.06
 | 33.44 |  |  | The author of the template is [NAME].  He can be reached at |  |  |  |  |  | www.tushar-mehta.com
 | 47.47
 | 40.71 | 0 |  | Warning
 | 54.45 | 0 |  | This worksheet is unprotected -- it must be for Solver to work correctly.
 |  |  |  | Consequently, failure to exactly follow the directions below can lead to data
 |  |  |  | corruption and incorrect results.
 |  |  |  | The template is made available as-is.  Use it at your own discretion and risk
 |  |  |  | Solver has certain limitations.  So, it may or may not work for your problem
 |  |  |  | Check here to indicate your acceptance.  Otherwise the template will not work
 |  |  |  | 1
 |  |  |  | Directions
 |  |  |  | (1) To enable the template, check the checkbox above
 |  |  |  | (indicates you have read, understood, and accepted the warning)
 |  |  |  | (2) Paste the amounts (values only, no formulas) to be matched into column B starting with B2
 |  |  |  | (3) Enter the target amount in F1
 |  |  |  | (4) Clear all existing values in column C starting with C2
 |  |  |  | (5) Start Solver (Tools | Solver…)
 |  |  |  | (6) In the Solver Parameters dialog box, click the Options button
 |  |  |  | (7) In the resulting Solver Options dialog box, click [NAME]… button
 |  |  |  | (8) In the Load Model dialog box, specify the range J1:J4
 |  |  |  | (9) If Solver asks about 'Reset previous Solver cell selections' click OK
 |  |  |  | (10) Back in the Solver Options dialog box, click OK
 |  |  |  | (11) Back in the Solver Parameters dialog box, click Solve
 |  |  |  | (12) If any of the values in column C are very close to zero (1E-8 or even smaller),
 |  |  |  | change them to zero, or open the Solver Parameters (Tools | Solver...) dialog
 |  |  |  | box and click the Solve button one more time
Spreadsheet: 267804d1380211241-pulling-data-from-a-master-list-company-wide-employee-list-final
Sheet: Branch Employee Listing

 |  |  |  |  |  |  | location | Oklahoma City
 |  |  |  |  |  |  | job title | Sales
 | location |  | Oklahoma City |  |  |  | count of
 |  | Administrative
 |  | EMP ID | NAME | JOB TITLE | Hire Date
 |  |  | Regional General Manager
 | job title |  | General Manager
 | job title |  | Clerical
 | job title |  | Operations
 |  |  |  |  |  | count of
 |  |  | [NAME]
 |  | EMP ID | NAME | JOB TITLE | Hire Date
 | job title |  | Sales Manager
 | job title |  | Sales
 |  |  |  |  |  | count of
 | job title |  | Driver
 |  | EMP ID | NAME | JOB TITLE | Hire Date
 |  |  |  |  |  | count of
 |  |  | Yard & Warehouse Personnel
 |  | EMP ID | NAME | JOB TITLE | Hire Date
 | job title |  | Yard & Warehouse
 | job title |  | Yard & Warehouse Foreman
 |  |  |  |  |  | count of
 |  |  | [NAME]
 |  | EMP ID | NAME | JOB TITLE | Hire Date
 | job title |  | [NAME] Manager
 | job title |  | [NAME]
 |  |  |  |  |  | count of
Spreadsheet: 648081d1572874162-dropdown-list-dependent-on-2-criterias-excel_dropdown-example-
Sheet: Entry Data

Region | Productcode | Category | Permittance | Comments |  | helper
USA | 123 | Clothes
Spreadsheet: 61215d1262029364-excel-2007-vlookup-need-multiple-results-712050-vlookup-need-multiple-results
Sheet: Details

Month | Repeation
Jan | Jan 1
Feb | Feb 1
Mar | [NAME]
Apr | Apr 1
May | May 1
Jun | [NAME]
Jul | Jul 1
Aug | Aug 1
Sep | Sep 1
Sep | Sep 2
Nov | Nov 1
Dec | Dec 1
Sep | Sep 3
Oct | Oct 1
Nov | Nov 2
Nov | Nov 3
Apr | Apr 2
May | May 2
Jun | [NAME]
Jul | Jul 2
Aug | Aug 2
Sep | Sep 4
Oct | Oct 2
Sep | Sep 5
Oct | Oct 3
Nov | Nov 4
Dec | Dec 2
Apr | Apr 3
May | May 3
Spreadsheet: darrell_schoolcraft__7299__imball0112
Sheet: Conoco

 | Maljamar |  | Zia |  |  |  |  |  |  |  |  | Avg
Day | Measured | Scheduled | Measured | Scheduled |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount
1 | 34725 | 33702 | 34933 | 32000
2 | 34843 | 33589 | 35369 | 32000 |  |  | 2001-03-01 00:00:00 |  |  |  | 4.98
3 | 34085 | 33702 | 37069 | 32000 |  |  | 2001-04-01 00:00:00 |  |  |  | 4.87
4 | 36422 | 35544 | 34771 | 29872 |  |  | 2001-05-01 00:00:00 |  |  |  | 3.82
5 | 36277 | 33702 | 30329 | 32000 |  |  | 2001-06-01 00:00:00 |  |  |  | 3.2
6 | 40078 | 36144 | 21788 | 34000 |  |  | 2001-07-01 00:00:00 |  |  |  | 2.77
7 | 34452 | 35502 | 34276 | 33385
8 | 35161 | 36050 | 35128 | 32613
9 | 33439 | 36143 | 34652 | 32699
10 | 33854 | 36144 | 33814 | 32699
11 | 33642 | 36144 | 33797 | 32700
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-11-30 00:00:00 |  |  |  |  | 377734.69
2001-12-11 00:00:00
CBS Volume
Spreadsheet: 271393d1381927162-find-cell-address-of-a-value-found-using-a-vlookup-formula-datelookup
Sheet: Wallplanner

Asset No. | 2013-10-27 00:00:00 | 2013-11-03 00:00:00 | 2013-11-10 00:00:00 | 2013-11-17 00:00:00 | 2013-11-24 00:00:00 | 2013-12-01 00:00:00 | 2013-12-08 00:00:00 | 2013-12-15 00:00:00 | 2013-12-22 00:00:00 | 2013-12-29 00:00:00 | 2014-01-05 00:00:00 | 2014-01-12 00:00:00 | 2014-01-19 00:00:00 | 2014-01-26 00:00:00 | 2014-02-02 00:00:00 | 2014-02-09 00:00:00 | 2014-02-16 00:00:00 | 2014-02-23 00:00:00 | 2014-03-02 00:00:00 | 2014-03-09 00:00:00 | 2014-03-16 00:00:00 | 2014-03-23 00:00:00 | 2014-03-30 00:00:00 | 2014-04-06 00:00:00 | 2014-04-13 00:00:00 | 2014-04-20 00:00:00 | 2014-04-27 00:00:00 | 2014-05-04 00:00:00 | 2014-05-11 00:00:00 | 2014-05-18 00:00:00 | 2014-05-25 00:00:00 | 2014-06-01 00:00:00 | 2014-06-08 00:00:00 | 2014-06-15 00:00:00 | 2014-06-22 00:00:00 | 2014-06-29 00:00:00 | 2014-07-06 00:00:00
2001 |  |  | 48W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24W
Spreadsheet: 700128d1602983301-formula-to-extract-numbers-from-within-a-cell-book1
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | 21-3-1 |  |  |  | 1
 |  |  |  |  |  |  |  |  | 12-18-2 |  |  |  | 2
 |  |  |  |  |  |  |  |  | 5-16 |  |  | 16 | 0
 |  |  |  |  |  |  |  |  | 20-3-1 |  |  | 3 | 1
 |  |  |  |  |  |  |  |  | 22-6 |  |  | 6 | 0
 |  |  |  |  |  |  |  |  | 9-17 |  |  | 17 | 0
 |  |  |  | [NAME] in green works fine
 |  |  |  | Should be the number between the dashes but if there is only 1 dash it would be the number to the right of the dash
 |  |  |  | M3=Formula ok
 |  |  |  | M4=Only shows 1, not 18
 |  |  |  | Orange should be formula that reflects number to the right of the 2nd dash but 0 if there is no 2nd dash
 |  |  |  | Numbers in red reflect what the outcome of the formula should be
Spreadsheet: 195902d1353705940-creating-a-list-outcome
Sheet: Sheet3

Data |  | Outcome
switch | CP1 - Test | switch CP1 - Test
switch | CP2 - Test | [NAME]
switch | CP3 - Test | switch CP3 - Test
switch | CP4 - Test | switch CP4 - Test
switch | CP5 - Test | switch CP5 - Test
switch | CP6 - Test | [NAME]
switch | CP7 - Test | switch CP7 - Test
switch | CP8 - Test | [NAME]
switch | CP9 - Test | [NAME]
Test | CP1 - Test | Test CP1 - Test
Test | CP2 - Test | Test CP2 - Test
Test | CP3 - Test | Test CP3 - Test
Test | CP4 - Test | Test CP4 - Test
Test | CP5 - Test | Test CP5 - Test
Test | CP6 - Test | Test CP6 - Test
Test | CP7 - Test | Test CP7 - Test
Test | CP8 - Test | Test CP8 - Test
Test | CP9 - Test | Test CP9 - Test
 |  |  |  | don’t need these two colums , only the outcome