tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 859669d1707982759-trying-to-pull-data-from-two-sheets-with-formulas-vlookup-array-formula-test-excel-ans
Sheet: DATA ENTRY 

MANUAL ENTRY |  | SALES HISTORY TAB - MANUAL ENTRY |  |  |  |  |  | RPS DATA TAB - MANUAL ENTRY?
Custom SIM List | [NAME] | Pulled Sales History SIM List | SIM Description | [NAME] Months | Sales - 24 Months | Market Cost | Margin | Sell | [NAME] | Contract Start Date | Contract Stop Date | Cost-Side Claim | Authorization Name | Market Cost (Includes WTT) | Replacement Cost (NET cost) | Loaded Margin
[PHONE] | J |  |  | 480 | 388.53 | 308.15 | 0.206882351427174 |  | SASCO-PSO~ | 45152 |  | 0 | 0 | 64.196 | 62.63 | s
[PHONE] | g |  | T&B A1200S10PGC 1-5/8X1-5/8-SLOT-CH | 40 | 350.37 | 167.81 | 0.521049176584753 | 531.07 | SASCO-PSO~ | 45152 |  | 0 | 0 | 438.126 | 427.44 | s
[PHONE] | g |  | T&B 54105 6AWG-BLUE-1H-COP-LUG | 107 | 346.58 | 227.86 | 0.342547175255352 | 326.87 | PRICE GUIDANCE | 0 |  | 0 | 0 | 212.954 | 207.76 | s
[PHONE] | g |  | T&B 842-TB 1/2-BUSHED-NIPPLE | 5 | 12.42 | 7.8 | 0.371980676328502 | 248.47 | PRICE GUIDANCE | 0 |  | 0 | 0 | 156.138 | 152.33 | s
[PHONE] | g |  | T&B ST125-471 1-1/4-STAR-TECK-FTG | 4 | 233.86 | 173.56 | 0.257846574873856 | 5139.36 | 45035330-SASCO-ABB_ | 45168 |  | 3880.21 | 45035330 | 5311.458 | 5181.91 | s
[PHONE] | g |  | T&B 5266 1-1/2-L/T-SEALING-RING | 18 | 142.29 | 104.23 | 0.267481903155527 | 818.22 | PRICE GUIDANCE | 0 |  | 0 | 0 | 579.299 | 565.17 | s
[PHONE] | g |  | T&B ST075-468 3/4-MC-CBL-CONN | 5 | 147 | 109.09 | 0.257891156462585 | 2096.87 | 45035330-SASCO-ABB_ | 45168 |  | 1583.13 | 45035330 | 2670.873 | 2605.73 | s
[PHONE] | f |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
[PHONE] | dsds |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  |  |  |  |  |  |  | 5 | 7 | #N/A | 32 | 34 | 49 | 57 | s
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
Spreadsheet: 24485d1214920965-help-with-complex-formula-h-and-vlookup-zzz-test
Sheet: Sheet2

 | A | B | C
1 | Density | Viscosity | Temperature
2 | 0.457 | 3.55 | 500
3 | 0.525 | 3.25 | 400
4 | 0.616 | 2.93 | 300
5 | 0.675 | 2.75 | 250
6 | 0.746 | 2.57 | 200
7 | 0.835 | 2.38 | 150
8 | 0.946 | 2.17 | 100
9 | 1.09 | 1.95 | 50
10 | 1.29 | 1.71 | 0
Spreadsheet: 112802d1308797873-top-n-list-based-on-2-conditions-and-returning-adjacent-cell-text-topmanufacturers
Sheet: Sheet1

 |  |  |  | JP
Maker | Country | Production |  | 5 | Production | Maker
RENAULT | FR | 280 |  |  | 645 | SUZUKI
FORD | US | 346 |  |  | 453 | YAMAHA
PEUGEOT | FR | 203 |  |  | 346 | FORD
CHRYSLER | US | 35 |  |  | 333 | HONDA
MERCEDES | DE | 101 |  |  | 69 | SUBARU
FERRARI | IT | 234
PORSCHE | DE | 112
KIA | KR | 455
AUDI | DE | 123
VOLKSWAGEN | DE | 677
LAMBORGHINI | IT | 1
MAZDA | JP | 45
SUBARU | JP | 69
VOLVO | SE | 90
SCANIA | SE | 76
SKODA | CZ | 89
CHEVROLET | US | 554
TOYOTA | JP | 346
TRIUMPH | UK | 23
DUCATI | IT | 43
HONDA | JP | 333
YAMAHA | JP | 453
SUZUKI | JP | 645
Spreadsheet: 826519d1682067055-import-data-from-another-sheet-depending-on-a-job-ref-certificate-test
Sheet: Template

Calibration Report |  |  |  |  | Job Ref
Vehicle Data
Registration No- |  |  |  |  | VIN
Make |  |  |  |  | Model
Mileage |  |  |  |  | Order No
Equipment Used
VCI Serial No |  |  |  | Diagnostic Tool used
Technician |  |  |  | IMI Acreditation
Work Carried out
Reason for work
Systems that have been calibrated |  |  |  |  | Coded control unit
Vehicle Scans Carried out |  |  |  |  | Notes
Spreadsheet: 735985d1623303989-help-adding-if-function-to-existing-sumif-function-chemical-inventory-control-in-progress
Sheet: Daily Transactions

 | Daily In & Out Transactions of Chemical Products
 | ALL WAREHOUSES
 | Date | Supplier | Received by | Taken by (Dept) | Owner (Dept) | Product | Check Name | Unit | In | Out | Order No | Delivery Note | Taken by
 | 2021-06-09 00:00:00 | Supplier 1 | [NAME] |  | Warehouse 1 | Product 1 |  |  | 20 |  | Order 255 | Del 1335
 | 2021-06-09 00:00:00 |  |  | Warehouse 2 | Warehouse 2 | Product 7 |  |  |  | 30 |  |  | [NAME]
Spreadsheet: 35942d1233670565-advanced-subtraction-addition-problem-2-copy-worksheet
Sheet: Simple

Additional Payments
Debt | Initial | Jan | Feb | Mar | Apr | May | . | Jul | Aug | Sep | Oct | Nov | Dec
CC 01 | 5000
CC 02 | 7500
CC 03 | 10000
Car | 15000
School | 20000
 | Interest | Min Payment
CC 01 | 25 | 250 | <---        This payment stays on CC 01 until it reaches a zero balance, then moves to CC 02. When CC 02 reaches a zero balance it moves to CC 03 untill all 3 credit cards (CC) reach a zero balance then its removed.
CC 02 | 50
CC 03 | 75
Car | 100 | 350 | <- These payments remain with their debt until the debt reaches a zero balance.
School | 100 | 150
 | /\  This interest adds on to each month until the balance reaches zero for that debt.
 | CC 01
 | CC 02 |  | These should be the numbers for january if no additional payments have been made.
 | CC 03
 | Car
 | School
Spreadsheet: 81354d1281557968-sumif-need-update-formula-pivot-table-workbook1
Sheet: Hárok1

NAME | DATE | POINTS(OWN) | POINTS(SHARED) | ACTUAL FROM ONE | TeamMate
[NAME] | 2010-01-21 00:00:00 | 15730 | 29323 | 10294 | [NAME]
[NAME] | 2009-11-09 00:00:00 | 1934 | 15730 | 1934
[NAME] | 2010-01-01 00:00:00 | 3934 | 0 | 3934
[NAME] | 2010-01-21 00:00:00 | 29323 | 0 | 29323 | [NAME]
[NAME] | 2010-11-03 00:00:00 | 15730 | 29323 | 2492
[NAME] | 2009-12-15 00:00:00 | 15730 | 29323 | 2944
Spreadsheet: 749380d1632764477-help-with-index-and-match-by-column-and-rows-sample-version-2
Sheet: Sheet1

 |  |  |  |  |  | ita | ita | ita | ita
 |  |  |  |  |  | Control1 | Control2 | Control3 | Control4
 |  |  |  |  |  | 0.14 | 0.084 | 0.042 | 0.035
Languaje | Control1 | Control2 | Control3 | Control4 | Task name
ita | 4 | 0 | 0 | 384 | TEST1
ita | 0 | 7 | 0 | 377 | TEST2
 |  |  |  |  |  | RED LINE NEED TO BE
 |  |  |  |  |  | 0 | 7 | 0 | 377
Spreadsheet: a3d63399-a945-441f-81e5-7ce1fbaae66b
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: |  |  | 2014-06-23 09:16:06.270000
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.75 | 102.875 | 102.75 | 102.625 | 102.25 |  | and are added to price quote
4.625 | 102.75 | 102.625 | 102.5 | 102.125
4.5 | 102.625 | 102.5 | 102.375 | 102 |  | Note: | Refer To Price [NAME]
4.375 | 102.117 | 101.992 | 101.867 | 101.492 |  |  | For all Price Adjs
4.25 | 101.511 | 101.386 | 101.261 | 100.636
4.125 | 100.664 | 100.539 | 100.414 | 99.789
4 | 99.662 | 99.537 | 99.412 | 98.787
3.875 | 98.619 | 98.494 | 98.369 | 97.744
3.75 | 97.744 | 97.619 | 97.494 | 96.869
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.75 | 102.733 | 102.608 | 102.483 | 102.108
3.625 | 102.339 | 102.214 | 102.089 | 101.714
3.5 | 101.786 | 101.661 | 101.536 | 101.161
3.375 | 101.067 | 100.942 | 100.817 | 100.442
3.25 | 100.43 | 100.305 | 100.18 | 99.555
3.125 | 99.994 | 99.869 | 99.744 | 99.119
3 | 99.244 | 99.119 | 98.994 | 98.369 |  | 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 | 2014-07-07 09:16:06.270000
30 DAY | 2014-07-22 09:16:06.270000
45 DAY | 2014-08-06 09:16:06.270000
60 DAY | 2014-08-21 09:16:06.270000
90 DAY | 2014-09-20 09:16:06.270000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 781073d1652970574-compare-4-cells-if-they-have-the-same-value-with-3-different-possibilities-and-match-comparison
Sheet: Sheet1

1 | 1 | 2 | 3 | 1 | 2 | 3
1 | 1 | 2 | 3 | 1 | 2 | 3
1 | 1 | 2 | 3 | 1 | 2 | 4
1 | 1 | 2 | 3 | 2 | 3 | 3
Target is, that when Column A Row1-4 is checked, that there shall be only 1s, 2s or 3rs, then it that would be good and shall show True and if not, it shall be False.
Spreadsheet: cooper_richey__4220__enron
Sheet: Enron 

 | Forecast and Climate Data For ENRON Canada
 |  |  |  | Date:
 |  |  | TEMPERATURE
 | Date | MAXIMUM | MINIMUM | MEAN | CLIMATE | HEATING DEGREE D.
 |  | °C | °C | °C  (T) | MEAN | 18.0-T
 | Calgary
 | Edmonton
 | Vancouver
 | Toronto
 | NOTES:  1. Climatological Day = 2301 MST to 2300 MST
 | *** Not for redistribution***
Spreadsheet: 226214d1365307686-filter-help-vanpool-bvj-
Sheet: Expenditures & Income

 |  | Vanpool Budget
< |  |  |  |  |  |  |  |  |  | date | <--Criteria range
 |  | [NAME]/Credits |  |  |  | Payments |  |  |  | 2013-04-04 00:00:00 | specify desired date
 |  | DATE | [NAME] | AMOUNT |  | DATE | [NAME] | Pymt Confirm # | AMOUNT |  | DATE | [NAME] | Pymt Confirm # | AMOUNT
 |  | 2013-04-01 00:00:00 | [NAME] | 3856.52 |  | 2013-03-15 00:00:00 | Borszich | [PHONE]-267796 / [PHONE]-267797 | 230 |  | 2013-04-04 00:00:00 | [NAME] | [PHONE]-267823 | 125
 |  | 2013-04-05 00:00:00 | [NAME] | -757.3 |  | 2013-03-15 00:00:00 | [NAME] | [PHONE]-267799 | 245 |  | 2013-04-04 00:00:00 | Wood | [PHONE]-267824 | 125
 |  |  |  |  |  | 2013-03-15 00:00:00 | [NAME] | [PHONE]-267801 | 125 |  | 2013-04-04 00:00:00 | Caliman | [PHONE]-267826 | 125
 |  |  |  |  |  | 2013-03-15 00:00:00 | Craycraft | [PHONE]-267804 | 245 |  | 2013-04-04 00:00:00 | [NAME] | [PHONE]-267825 | 125
 |  |  |  |  |  | 2013-03-15 00:00:00 | [NAME] | [PHONE]-267806 | 125 |  | 2013-04-04 00:00:00 | [NAME] | [PHONE]-267827 | 230
 |  |  |  |  |  | 2013-03-15 00:00:00 | Kubik | [PHONE]-267808 | 125 |  | 2013-04-04 00:00:00 | McGavin | [PHONE]-267829 | 125
 |  |  |  |  |  | 2013-03-15 00:00:00 | Lagasse | [PHONE]-267809 | 125 |  | 2013-04-04 00:00:00 | [NAME] | [PHONE]-267830 | 125 | <---- copy to New location (L8)
 |  |  |  |  |  | 2013-03-15 00:00:00 | McManus | [PHONE]-267810 | 245 |  | 2013-04-04 00:00:00 | Parrish | [PHONE]-267832 | 125
 |  |  |  |  |  | 2013-03-15 00:00:00 | Mendoza | [PHONE]-267812 | 245 |  | 2013-04-04 00:00:00 | Smith | [PHONE]-267833 | 125
 |  |  |  |  |  | 2013-03-15 00:00:00 | Moore | [PHONE]-267814 | 245
 |  |  |  |  |  | 2013-03-15 00:00:00 | Neiswender | [PHONE]-267815 | 234
 |  |  |  |  |  | 2013-03-15 00:00:00 | Noehl | [PHONE]-267816 | 125
 |  |  |  |  |  | 2013-03-15 00:00:00 | Ramos | [PHONE]-267817 | 125
 |  |  |  |  |  | 2013-03-15 00:00:00 | Shurbet | [PHONE]-267820 | 125
 |  |  |  |  |  | 2013-03-15 00:00:00 | [NAME] | [PHONE]-267821 | 245
 |  |  |  |  |  | 2013-04-04 00:00:00 | [NAME] | [PHONE]-267823 | 125
 |  |  |  |  |  | 2013-04-04 00:00:00 | Wood | [PHONE]-267824 | 125
 |  |  |  |  |  | 2013-04-04 00:00:00 | Caliman | [PHONE]-267826 | 125
 |  |  |  |  |  | 2013-04-04 00:00:00 | [NAME] | [PHONE]-267825 | 125
 |  |  |  |  |  | 2013-04-04 00:00:00 | [NAME] | [PHONE]-267827 | 230
 |  |  |  |  |  | 2013-04-04 00:00:00 | McGavin | [PHONE]-267829 | 125
 |  |  |  |  |  | 2013-04-04 00:00:00 | [NAME] | [PHONE]-267830 | 125
 |  |  |  |  |  | 2013-04-04 00:00:00 | Parrish | [PHONE]-267832 | 125
 |  |  |  |  |  | 2013-04-04 00:00:00 | Smith | [PHONE]-267833 | 125
Spreadsheet: louise_kitchen__23837__2QYTD Orig w notes
Sheet: Midwest Power

Midwest Power
Mid Year 2001
Originator |  | Commodity |  | Team |  | Total |  | %Total
Clynes |  | Power |  | Midwest
Baughman |  | Power |  | Midwest |  | 1156703
[NAME] |  | Power |  | Midwest
Kelly |  | Power |  | Midwest |  | 500000
[NAME] |  | Power |  | Midwest |  | 333666
Sewell |  | Power |  | Midwest |  | 233291
Wang |  | Power |  | Midwest |  | 50000
Total
Spreadsheet: 888914d1739538348-calculate-the-total-sales-for-a-month-from-the-dates-in-an-range-monthly-visits-with-costs-v3
Sheet: Sheet1

Postcode | Price | Frequency (Weeks) | No. Visits after Initial | Initial Visit | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
SW1V 4JB | 250 | 8 | 6 | 2025-01-01 00:00:00
LS8 2ET | 150 | 8 | 6 | 2025-01-01 00:00:00
CM16 7BD | 150 | 8 | 6 | 2025-01-13 00:00:00
HU13 0AY | 171.28 | 8 | 6 | 2025-01-01 00:00:00
LE2 9FL | 171.28 | 8 | 6 | 2025-01-01 00:00:00
SG12 7NG | 171.28 | 8 | 6 | 2025-01-01 00:00:00
SL2 4QE | 171.28 | 8 | 8 | 2025-01-01 00:00:00
ST5 5AY | 171.28 | 8 | 6 | 2025-01-01 00:00:00
TF2 9TJ | 171.28 | 8 | 4 | 2025-01-01 00:00:00
LA15 8UJ | 160 | 8 | 6 | 2025-01-01 00:00:00
SL1 5QU | 160 | 8 | 6 | 2025-01-01 00:00:00
WN6 0UQ | 160 | 8 | 10 | 2025-01-01 00:00:00
 |  | No. Jobs | Total per month
 | January | 12 | 2058.68 |  |  | 12 | 2057.68
 | February | 11 | 1907.68 |  | January | 11 | 1907.68
 | March | 1 | 150 |  | January | 1 | 150
 | April | 11 | 1907.68 |  | January | 11 | 1907.68
 | May | 1 | 150 |  | January | 1 | 150
 | June | 12 | 2058.68 |  | January | 12 | 2057.68
 | July | 0 | 0 |  | January | 0 | 0
 | August | 12 | 2058.68 |  | January | 12 | 2057.68
 | September | 0 | 0 |  | January | 0 | 0
 | October | 11 | 1886.4 |  | January | 11 | 1886.4
 | November | 0 | 0 |  | January | 0 | 0
 | December | 10 | 1636.4 |  | January | 11 | 1886.4
Spreadsheet: 85132d1285185811-combining-two-formulas-book3
Sheet: PSV's

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | UNIT: | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EQUIPMENT ID: | P8050012
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P&ID: | pid
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SIZE: |  | SIZE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TYPE: |  | TYPE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MFG: |  | mfg |  |  | P8050012
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MODEL #: |  | MODEL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SERIAL #: |  | serial
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PROCESS SH: |  | GUTZ
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PROCESS TU: |  | PROCESS TU
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TEMA: |  | TEMA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SHELL DES PRESS:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SHELL DES TEMP:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SHELL MATL:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SHELL THK:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SHELL CA: |  | CA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TUBE MATERIAL:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TUBE COUNT:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TUBE SIZE:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TUBE LENGTH: |  | 20'
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CHANNEL MATL: |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CHANNEL CA: |  | CHAN CA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BUNDLE WEIGHT: |  | WEIGHT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Notes
[NAME] |  |  | Exchangers |  | DATE:
P8050012 desc |  |  |  |  |  |  |  |  | WALKED BY: | [NAME]
 |  |  |  |  |  |  |  |  | SUPERVISOR: | [NAME]
#N/A
Spreadsheet: jeff_dasovich__14192__MERTON3A
Sheet: Merton 3(a)

Merton Truck Company -- Problem 3(a)
 | M 101 | M 102 | M 103
Contribution | 3000 | 5000 | 2000 |  | [NAME]. =
Quantity | 0 | 0 | 0 |  | Total Profit =
 |  |  |  | Total |  | Total
 | Machine-hours per Truck |  |  | Consumed |  | Available
 |  |  |  | Machine |  | Machine
 | M 101 | M 102 | M 103 | Hrs. per Mo. |  | Hrs. per Mo.
Eng. Assem. | 1 | 2 | 0.8 |  | <= | 4000
[NAME]. | 2 | 2 | 1.5 |  | <= | 6000
M 101 Assem. | 2 | 0 | 1 |  | <= | 5000
M 102 Assem. | 0 | 3 | 0 |  | <= | 4500
Spreadsheet: 768113d1644845318-checking-to-see-if-multiple-values-from-one-list-exist-in-the-other-test-54-ans
Sheet: Sheet1

Product | Match
apples
pears
bananas
kiwi
watermelon
grapes
strawberries
raspberries
blueberries
avocado
spinach
tomatoes
potato
[NAME]
onions
courgettes
cucumber
lettuce
coconut
peppers
potato, apples, pears
onions, cauliflower
apples, pears
beetroot, apples, radish
Spreadsheet: e8d6cdb6-6633-451e-b743-12d079e475d1
Sheet: Sheet1

Adresseliste fra www.proff.no | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Bransje:Bedriftsrådgivning
FIRMANAVN | ADRESSE | POSTNR. | POSTSTED | TELEFON | TELEFAKS
Vega SMB AS | [NAME] v 28 | 1366 | Lysaker | 815 48 333 | 67 12 85 51
Beckman Lundevall Revisjon AS | [NAME]. 70 | 0680 | Oslo | 22 78 28 00 | 22 78 28 01
Sikkerhetsledelse AS | Trollåsv. 4 | 1414 | Trollåsen | 66 10 99 40 | 66 10 99 41
Nemko AS | Gaustadalléen 30 | 0373 | Oslo | 22 96 03 30 | 22 96 05 50
Enova Business Services AS | Astrids v 1 | 1473 | LØRENSKOG | 67 98 04 20
[NAME] | Filipstad Brygge 1 | 0252 | Oslo | 23 11 42 00 | 23 11 42 01
Akselera AS | Strandv. 33 | 1366 | Lysaker | 952 68 706
Akselera AS | Bredsgården 2 | 5003 | Bergen | 911 91 627
Intersoft Management Systems AS | Lysaker torg 45 | 1366 | Lysaker | 22 22 63 00
Akselera Norway AS | Strandv. 33 | 1366 | Lysaker | 952 68 706
Mimir AS | Bredochs g 1 | 3256 | Larvik | 33 11 55 30
Headvisor AS | [NAME] g 19 | 0159 | Oslo | 22 47 65 50 | 22 41 30 00
Fjaler Næringsutvikling |  | 6963 | [NAME] | 57 73 76 76
BearingPoint Norway AS | Tjuvholmen allé 3 | 0252 | Oslo | 24 06 90 00 | 24 06 90 01
Akselera Norway AS | Bredsgården 2 | 5003 | Bergen | 911 91 627
Russel Reynolds Associates AS | Haakon VII's g 1 | 0161 | Oslo | 22 03 80 10
Uniconsult AS | Dronning Mauds g 3 | 0250 | Oslo | 23 23 94 00
CBA Consultans AS | Klinestadmoen 9 | 3241 | Sandefjord | 454 14 600
McKinsey & Company Inc Norway | [NAME] g 5 | 0161 | Oslo | 22 86 25 00 | 22 86 26 00
EH Consulting | Sykehusg. 30 | 8613 | Mo i Rana | 906 14 830
EG Consult AS | Støtvigv. 45 | 1560 | Larkollen | 902 05 415
ISCO Group AS | Oscars g 23 | 0352 | Oslo | 22 06 87 00 | 22 06 87 01
[NAME] | Vollsv. 13C | 1366 | Lysaker | 67 11 15 00 | 67 11 15 01
Strategica People and Processes AS | Bogstadv. 30 | 0355 | Oslo | 23 36 60 52
[NAME] | Gjellumlia 10A | 1389 | Heggedal | 975 62 979
Trenger du oppdaterte adresselister til DM /TM? [NAME] (www.forvalt.no) tilbyr ett segmenterings- og uttekksverktøy hvor du [NAME] frem til din målgruppe og eksportere lister til Excel. Du kan gjøre oppslag så ofte du vil, med en begrensning på 3500 selskap per søk. Våre telefonnummere er hentet fra Telefonkatalogen og [NAME].  Med segmenteringsverktøy kan du: - Hente ut adresseliste før en DM utsendelse - Lage ringelister - Hente ut bransjestatistikker - Oppdatere din kundedatabase  Se http://forvalt.no/segmenteringsverktoy/
Spreadsheet: 153054d1335732492-excel-2007-conditional-formatting-with-2-variables-rick52-1-1-
Sheet: Sheet1

dyn |  |  |  |  |  | a | a | b | b | c | d
0.191 | 0.1501 |  |  |  | bio | 0.21 | 0.22 | 0.15 | 0.16 | 0.01 | 0.01
 | b |  |  |  | coa | 0.21 | 0.22 | 0.15 | 0.16 | 0.02 | 0.3
0.0532 | 0.0511 |  |  |  | dyn | 0.185 | 0.195 | 0.2 | 0.21 | 0.02 | 0.02
c | d |  |  |  | nex | 0.19 | 0.2 | 0.15 | 0.18 | 0.01 | 0.05
 |  |  |  |  | $A$2=VLOOKUP(A2,F3:F6,1) - that just finds…and uses the row it finds from…the value in A2
A2 Text populated from drop down based in F3:F6 |  |  |  |  | $B$3>VLOOKUP(A2,F2:L6,MATCH($B$4,$F$2:$L$2,0),FALSE) - this compares the B3 value with its corresponding value in your lookup range
A3 & B3 manually populated |  |  |  |  | MATCH($B$4,$F$2:$L$2,0) - this looks for the value in A4 or B4, in the headings in F2:L2, to give the column to look in.
A5 & B5 manually populated |  |  |  |  | I split your >21 <22 range into 2 colums for the lookup, then added 1 to the math() to look in the 2nd occurrence of "a"
 |  |  |  |  | for the red CF, I just added a not() to the CF, to negate the evaluation
[NAME] (Green or Red) based on [NAME],                             B4 based on B3  etc.
The problem comes in with overlapping or differing values depending on product (from drop down) being produced.
How can the drop down or something else be used to select the values that trigger the format?
 |  |  |  |  |  | a |  | b |  | c | d
 |  |  |  |  | bio | > 21 < 22 |  | > 15 < 16 |  | < 1 | < 1
 |  |  |  |  | coa | > 21 < 22 |  | > 15 < 16 |  | < 2 | < 30
 |  |  |  |  | dyn | > 18.5 < 19.5 |  | > 20 < 21 |  | < 2 | < 2
 |  |  |  |  | nex | > 19 < 20 |  | > 15 < 18 |  | < 1 | < 5
Biofos |  |  | Coarse |  |  | Dynafos |  |  | Nexfos
P | P > 21 < 22 |  | P | P > 21 < 22 |  | P | P  > 18.5 < 19.5 |  | P | P > 19 < 20
Ca | Ca > 15 < 16 |  | Ca | Ca> 15 < 16 |  | Ca | Ca > 20 < 21 |  | Ca | Ca > 15 < 18
12 | < 1 |  | 8 | < 2 |  | 12 | < 2 |  | Na | Na > 4 < 5
-100 | < 1 |  | 12 | < 30 |  | -100 | < 2 |  | Insol | Insol >5 < 6
 |  |  |  |  |  |  |  |  | 12 | < 1
 |  |  |  |  |  |  |  |  | -100 | < 5
bio
coa
dyn
nex
Spreadsheet: 38147d1236267491-sumproduct-question-sampleexcel
Sheet: EXAMPLE

 |  |  |  | Month: | 1
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
$(000's) |  | FCST | FCST | FCST | FCST | FCST | FCST | FCST | FCST | FCST | FCST | FCST | FCST
[NAME] SALES: |  | January | February | March | April | May | June | July | August | September | October | November | December | Q1 | Q2 | Q3 | Q4 | TOTAL | PLAN | ACT VS PLAN
OUTSIDE SALES- TRADE |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | #N/A | #N/A
ALLOWANCES |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | #N/A | #N/A
RETURNS |  | -0.12288 | 30.83815 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 30.71527 | 0 | 0 | 0 | 30.71527 | #N/A | #N/A
OTHER SALES |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | #N/A | #N/A
PAYMENT DISCOUNTS |  | #N/A | #N/A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | #N/A | 0 | 0 | 0 | #N/A | #N/A | #N/A
INTERCOMPANY |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | #N/A | #N/A
 | TOTAL GROSS SALES | #N/A | #N/A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | #N/A | 0 | 0 | 0 | #N/A | #N/A | #N/A
Notes: Trying To Get the new formula where the "value" is in Cell C12 to work, but the new conditon added is not working correctly. The new condition is there to block any data that has not happened to stop accruals from showing.
Example: It is the end of January  according to F4 and I need it to report from the Data sheet only from January on or Data Sheet Data from D1 only