tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 862633d1710306266-exclude-holidays-in-total-holiday-sample-1-3-
Sheet: Jan

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Current formula
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Holiday Count | Weekdays Count | Weekend Count | Entitlement | Total Taken | Balance
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
 |  | Please Change Date below |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | If Holiday is on Weekend |  |  |  |  |  | Aiming for this result
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Holiday Count | Weekdays Count | Weekend Count | Entitlement | Total Taken | Balance
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 3.5 | 4 | 10
 |  | 2018-01-01 00:00:00 | 1 | 1 | 1 |  |  |  | 1 | 1 |  |  | 1 | 0.5 |  |  |  |  |  |  |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  | Holiday fall on weekend | 3.5 days is filled | 4 Weekend is filled excluding Holiday
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | If Holiday is on Weekdays |  |  |  |  |  | Aiming for this result
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Holiday Count | Weekdays Count | Weekend Count | Entitlement | Total Taken | Balance
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 6.5 | 2 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Holiday fall on weekdays | 6.5 days is filled | 2 Weekend is filled excluding Holiday
Spreadsheet: 225157d1364913766-conditional-formating-to-match-a-list-conditional-formating-bracket
Sheet: Scores

 | RD 1 | Score |  | RD 2 | Score |  | RD 3 | Score |  | RD 4 | Score |  | Winner |  |  | Loosers
 | Team A | 5 |  |  | 2
 | Team B | 4 |  |  | 3
 | Team C | 6 |  |  | 3
 | Team D | 7 |  |  | 4
 | Team E | 3 |  |  | 5
 | Team F | 6 |  |  | 6
 | Team G | 2 |  |  | 7
 | Team H | 3 |  |  | 4
 | Team I | 2
 | Team J | 3
 | Team K | 4
 | Team L | 6
 | Team M | 8
 | Team N | 7
 | Team O | 4
 | Team P | 6
Spreadsheet: 154432d1336423099-more-than-one-countif-jrios_sample_05may12_01
Sheet: Jan-2

DSI North Operations Log
Opener |  |  |  |  |  |  |  | Day of the Week |  | Tuesday
Closer |  |  |  |  |  |  |  | Date
Routes |  | Driver |  | Assistant |  | Stops / Pieces | Door | Carpet | Phone | Area
Zip Codes
98001 | 98001 | 98002 | 98002 | 98002 | 98002 | 98002 | 98003
 |  |  |  |  |  |  |  |  | 98001 |  |  |  | 98001
 |  |  |  |  | 98003
 |  |  |  |  |  |  |  |  | 98001
Spreadsheet: 787883d1658133721-if-vlookup-and-mod-subtotal-backwards-math-calculation-examplev2
Sheet: Sheet1

 | CURRENT RESULTS:
 | Item | Current Price | Start to calculate in how many years | Every how many years (Once-off = 0) | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6
 |  |  |  |  | 2022
 | Apples | 10 | 2 | 2
 | Pears | 15 | 3 | 1
 | Strawberries | 13 | 5 | 1
 | [NAME] | 22 | 2 | 1
 | EXPECTED RESULTS:
 | Item | Current Price | Start to calculate in how many years | Every how many years (Once-off = 0) | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6
 |  |  |  |  | 2022
 | Apples | 10 | 2 | 2
 | Pears | 15 | 3 | 1
 | Strawberries | 13 | 5 | 0
 | [NAME] | 22 | 2 | 0
 | NOTE: Main formula considers an increase of 10% per year
Spreadsheet: benjamin_rogers__933__histoical cube data
Sheet: Zone J

Monthly Avg Report
Filters:  NERC Region-NYISO ZONEJ; On/Off Peak-On Peak
 | 2000 |  | 2001
 | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug
Electricity ($/MWH) | 62.3575 | 85.6709999999999 | 69.2804545454545 | 54.2929999999999 | 61.4618181818181 | 63.9314285714285 | 67.170909090909 | 67.5719047619047 | 62.65 | 141.058
Heat Rate (HHUB) | 11397.9241013143 | 9851.77092916283 | 8236.08559386144 | 9705.57740436181 | 11903.8647768289 | 12244.049247606 | 15855.7939914163 | 17982.6384488657 | 20240.7692307692 | 45283.467094703
Heat Rate (Local) | 10518.9774279058 | 6813.88690050107 | 6261.48221181497 | 8877.93312075872 | 10764.7480296154 | 11208.5490065119 | 14500.6378176822 | 16005.0755695916 | 18313.6135857461 | 38923.2891832229
Natural Gas (HHUB) | 5.47095238095238 | 8.696 | 8.41181818181818 | 5.59399999999999 | 5.16318181818181 | 5.22142857142857 | 4.23636363636363 | 3.75761904761904 | 3.09523809523809 | 3.115
Natural Gas (Local) | 5.92809523809523 | 12.573 | 11.0645454545454 | 6.1155 | 5.70954545454545 | 5.70380952380952 | 4.63227272727272 | 4.22190476190476 | 3.42095238095238 | 3.624
Oil 2 ($/MMB) | 7.38571428571428 | 6.71849999999999 | 6.00136363636363 | 5.58999999999999 | 5.28181818181818 | 5.54761904761904 | 5.52227272727272 | 5.40999999999999 | 4.99333333333333 | 5.17777777777777
Oil 6 1.0% ($/MMB) | 4.53809523809523 | 4.0665 | 4.0340909090909 | 3.70449999999999 | 3.715 | 3.62619047619047 | 3.68454545454545 | 3.2447619047619 | 3.07999999999999 | 3.24888888888888
High Temp | 52.5714285714285 | 38.15 | 39.1363636363636 | 44.05 | 44.8636363636363 | 61.9523809523809 | 71.5909090909091 | 82.3333333333333 | 83.4285714285714 | 95.125
Low Temp | 41.4285714285714 | 26.05 | 29.1363636363636 | 30.5 | 33.7727272727272 | 44.8095238095238 | 56.4090909090909 | 67.2857142857142 | 67.5714285714285 | 77.5
CDDS |  |  |  |  |  | 3.5 | 10.2142857142857 | 10.475 | 10.5 | 21.3125
HDDS | 18 | 32.9 | 30.8636363636363 | 27.725 | 25.6818181818181 | 13.2105263157894 | 6.23333333333333 | 3.5
Spreadsheet: 861836d1709662676-return-results-based-on-changing-sheet-name-and-column-course-info-dj
Sheet: Solve

 |  |  |  |  |  |  |  |  | EXAMPLE RESULT
 |  |  | Type: | Data B | <<-- drop down of tab names |  |  |  | Type: | Data A | <<-- drop down of tab names
 |  |  | Subject: | Science | <<-- drop down of subjects |  |  |  | Subject: | Science | <<-- drop down of subjects
 | Tabs
 | Data A |  | Name | Class |  |  |  |  | Name | Class
 | Data B |  |  | E |  |  |  |  | [NAME] | E
 |  |  | [NAME] | D |  |  |  |  | [NAME] | D
 | Subject |  | [NAME] | S |  |  |  |  | [NAME] | S
 | Math |  | [NAME] | A |  |  |  |  | [NAME] | A
 | Science |  | [NAME] | A |  |  |  |  | [NAME] | A
 | French |  | Sophia | S |  |  |  |  | Sophia | S
 | Spanish |  | [NAME] | F |  |  |  |  | [NAME] | F
 | English |  | [NAME] | T |  |  |  |  | [NAME] | T
 | History |  | [NAME] | T |  |  |  |  | [NAME] | T
 | Literature |  | Joel | T |  |  |  |  | Joel | T
 | Finance
 | Econ
 | Psych
 | Gym
 | German
 | Writing
 | Business
 | DEI
 | Accounting
 | Anthro
 | Biology
 | Engineering
 | Civics
 | Geomoetry
 | Design
 | Art
 | Design
 | Humanities
Spreadsheet: 673200d1587246423-how-to-display-the-latest-20-dates-from-a-data-sheet-golf-handicap-index-calculation-golfhandicapindexcalculation-5-
Sheet: Sheet2

Date | course | Score | Rating | slope | Diff | low 10
2020-02-01 00:00:00 |  | 108 | 71.6 | 130
2020-02-01 00:00:00 |  | 102 | 70.1 | 123
2020-01-31 00:00:00 |  | 104 | 72.5 | 128
2020-01-31 00:00:00 |  | 112 | 72.5 | 128
2020-01-30 00:00:00 |  | 99 | 67.9 | 116
2020-01-30 00:00:00 |  | 108 | 70.8 | 127
2019-11-03 00:00:00 |  | 105 | 69.4 | 126
2019-10-31 00:00:00 |  | 104 | 69.4 | 126
2019-10-24 00:00:00 |  | 107 | 67.7 | 120
2019-10-14 00:00:00 |  | 99 | 67 | 115
2019-09-30 00:00:00 |  | 106 | 69.2 | 120
2019-09-25 00:00:00 |  | 112 | 69.4 | 126
2019-09-22 00:00:00 |  | 98 | 69.6 | 126
2019-09-21 00:00:00 |  | 101 | 70.6 | 129
2019-09-19 00:00:00 |  | 121 | 67.7 | 124
2019-09-15 00:00:00 |  | 107 | 69.4 | 126
2019-09-15 00:00:00 |  | 99 | 69.9 | 126
2019-09-14 00:00:00 |  | 108 | 68.7 | 120
2019-09-12 00:00:00 |  | 95 | 67.7 | 120
2019-09-08 00:00:00 |  | 97 | 70.6 | 126
Spreadsheet: 709594d1608427862-change-formula-to-ignore-hidden-tabs-excelforum1335831programme-test
Sheet: Block 10

Item Name | Price | 52 | 53 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | Total | Totals
Product 1 | 0.05
Product 2 | 0.1
Product 3 | 0.15
Product 4 | 0.2
Product 5 | 0.25
Product 6 | 0.3
Product 7 | 0.35
Product 8 | 0.4
Product 9 | 0.45
Product 10 | 0.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | @ |  | 0.0001 |  |  |  |  |  | Pol:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | + 20% VAT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Block | Area | Area | Perimeter (glass/path)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Block 1 | 23490 | A | 950
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Block 2 | 6441 | B | 840
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Block 3 | 5698 | C | 420
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Block 4 | 8728 | D | 1120
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Block 5 | 2508 | E | 400
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Block 6 | 13440 | F | 760
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Block 7 | 14976 | G | 820
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Block 8 | 14940 | H | 820
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Block 9 | 5455 | I | 430
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Block 10 | 5698 | J | 430
Spreadsheet: 845752d1697116445-if-formula-to-calculate-banding-based-on-multiple-criteria-banding-calcs
Sheet: Sheet1

UK |  |  | Scottish |  |  | Wales
£0.01 - £37,700.99 | 0.2 |  | £0.01 - £2,162.99 | 0.19 |  | £0.01 - £37,700.99 | 0.2
£37,701 - £150,000 | 0.4 |  | £2,163 - £13,118.99 | 0.2 |  | £37,701 - £150,000 | 0.4
Over £150,000 | 0.45 |  | £13,119 - £31,092.99 | 0.21 |  | Over £150,000 | 0.45
 |  |  | £31,093 - £150,000 | 0.41
 |  |  | Over £150,000 | 0.46
Country | Tax Code Breakdown | Tax Free Allowance | Taxable Pay | Tax Banding | PSA Tax Rate | Banding
England | 1257 |  | -3145.6 | 0 | 0.2
Wales | 77 |  | -261.35 | 0 | 0.2
England | 1257 |  | 22446.37 | 0.2
Scotland | 1257 |  | 17344 | 0.21
Wales | 1257 |  | 15176.29 | 0.2
Wales | 1256 |  | -3104.610000000001 | 0 | 0.2
Wales | 1257 |  | 28572.18 | 0.2
Wales | 1257 | 12570 | 59503.56 | 0.4 | 0.4
Wales | 1257 | 12570 | 41533.83 | 0.4 | 0.4
See start of forumla in colum G, how do I build on that to give me the correct banding based on country and taxable pay. Banding is shown in tables above
Column F has the correct answers but these have been put in manually and I need a formula as over 800 lines.
Spreadsheet: 842831d1694801586-how-to-i-lookup-a-calculated-value-in-one-sheet-that-matches-a-value-on-another-sheet-example-default-formula-changed-
Sheet: Charged

 |  |  |  |  | TOTALS:
Date | Start Time | End Time | Duration | Duration (Rounded) | Overtime | Amount Due #1 | Amount Due #2
2023-01-01 00:00:00 | 05:59:00 | 08:22:00
2023-01-02 00:00:00 | 09:21:00 | 11:37:00
Spreadsheet: 0c4a24a1-8ea6-40ba-8b53-a769e907a7c7
Sheet: Sheet1

Table 9--Wheat:  U.S. exports, [NAME] and export sales comparison (1,000 metric tons),6/8/12 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 | 2009/10 |  | 2010/11 |  | 2011/12(as of 6/7/12)
Importing |  |  |  |  |  | Out-
country |  |  |  |  | Shipments | standing | Total
Data |  | Export |  | Export | Export
source | Census 1/ | sales 2/ | Census 1/ | sales 2/ | sales 2/
Country:
Egypt | 423.6 | 455.6 | na | 4021.2 | 949.8 | 60.3 | 1010.1
Nigeria | 3256.1 | 3233 | na | 3645.3 | 3248 | 104.4 | 3352.4
Japan | 3171 | 3148.3 | na | 3273 | 3512.1 | 332.6 | 3844.7
Mexico | 1999.7 | 1974.6 | na | 2601 | 3495.9 | 67.1 | 3563
Philippines | 1573.1 | 1517.5 | na | 1806.3 | 2038.6 | 50.6 | 2089.2
South Korea | 1102.1 | 1110.7 | na | 406.5 | 1983 | 106.7 | 2089.7
Taiwan | 837.8 | 843.6 | na | 912.9 | 887.9 | 87.5 | 189.4
Venezuela | 658.1 | 657.8 | na | 615.7 | 593.5 | 63.8 | 657.3
Colombia | 623 | 575.4 | na | 782.7 | 446.2 | 10 | 456.2
Peru | 525.5 | 566.8 | na | 922.9 | 564.8 | -13 | 551.8
Indonesia | 539 | 528.6 | na | 781.4 | 830 | 0 | 830
EU-27 | 545.4 | 606.1 | na | 1307.6 | 1228.1 | 2.5 | 1230.6
Total grain | 23181.9 | 21686.3 | na | 33438.5 | 26627.3 | 1295.6 | 27922.9
Total (including
products) | 23976.9 | 21794.1 | na | 33538.8 | 26812.5 | 1314.7 | 28127.2
USDA forecast
of Census |  |  |  | 35244 |  |  | 65.26
1/ Source is U.S. Department of Commerce, U.S. Census Bureau
2/ Source is Foreign Agricultural Service's weekly U.S. Export Sales report.
Source: USDA, Foreign Agricultural Service's, U.S. Export Sales.
Spreadsheet: 142078d1329632378-transpose-data-re-arrange-columns-and-rows-excel_sample
Sheet: Start

food | survival | cans | kits | emergency
fsa.com/food-for-health-international/ | fsa.com/survival-backpacks/ | fsa.com/provident-provisions-harvest-2-pack-food-supply-2-3-people-for-1-year/ | fsa.com/survival-backpacks/ | fsa.com/emergency-food-buckets/
fsa.com/wise-foods/ | fsa.com/guardian-elite-survival-kit/ | fsa.com/provident-provisions-harvest-3-pack-food-supply-3-people-1-year/ | fsa.com/wise-food-storage-deluxe-survival-kit-2-weeks-1-person/ | fsa.com/emergency-reserve/
fsa.com/wise-foods-long-term-emergency-food-supplies/ | fsa.com/guardian-survival-kit/ | [NAME] | fsa.com/guardian-1-person-deluxe-backpack-survival-kit/ | fsa.com/mainstay-emergency-rations/
fsa.com/food-for-health-emergency-food-1100-serving-kit-survival-food-for-a-year/ | fsa.com/quake-kare/ | fsa.com/provident-provisions-harvest-6-pack-food-supply-6-10-people-1-year/ | fsa.com/guardian-4-person-deluxe-bucket-survival-kit/ | [NAME]
fsa.com/food-for-health-international-275-serving-emergency-food-bucket/ | fsa.com/guardian-1-person-deluxe-backpack-survival-kit/ | [NAME] | fsa.com/guardian-5-person-deluxe-bucket-survival-kit/ | fsa.com/rations-survival-bars/
fsa.com/food-for-health-international-200-serving-emergency-food-bucket/ | fsa.com/guardian-2-person-deluxe-backpack-survival-kit/ | fsa.com/provident-provisions-harvest-10-pack-food-supply-10-people-1-year/ | fsa.com/guardian-elite-survival-kit/ | fsa.com/er-emergency-ready-2400-calorie-emergency-food-bar-case-of-20/
fsa.com/wise-food-storage-4320-serving-gourmet-food-supply-buckets-ready-made/ | fsa.com/guardian-5-person-deluxe-bucket-survival-kit/ | fsa.com/provident-provisions-emergency-food-kits/ | fsa.com/survival-food-kits/ | fsa.com/quake-kare/
fsa.com/wise-food-storage-1440-serving-gourmet-food-supply-buckets-ready-made/ | fsa.com/guardian-2-person-essentials-backpack-survival-kit/ | fsa.com/provident-provisions-harvest-deluxe-food-supply-1-person-1-year/ | fsa.com/guardian-2-person-deluxe-backpack-survival-kit/ | fsa.com/er-emergency-ready-100-person-deluxe-survival-kit/
fsa.com/wise-food-storage-2160-serving-gourmet-food-supply-buckets-ready-made/ | fsa.com/guardian-4-person-deluxe-bucket-survival-kit/ | fsa.com/provident-provisions-sweets-brownies-sugar-variety-case-10-cans/ | fsa.com/guardian-2-person-deluxe-bucket-survival-kit/ | fsa.com/emergency-reserve-90-serving-breakfast-lunch-and-dinner/
fsa.com/wise-food-storage-720-serving-gourmet-food-supply-buckets-ready-made/ | fsa.com/guardian-cat-survival-kit/ | fsa.com/provident-provisions-grains-no-2-granola-oats-rice-variety-case-10-cans/ | fsa.com/guardian-2-person-essentials-backpack-survival-kit/ | fsa.com/er-emergency-ready-1-person-basic-bagged-survival-kit/
Spreadsheet: 78900d1279192494-exporting-data-based-on-criteria-sla-example
Sheet: Sheet1

Date | Contract | SLA
2010-07-01 00:00:00 | Client 1 | 87.1
2010-07-02 00:00:00 | Client 2 | 100
2010-07-03 00:00:00 | Client 3 | 0
2010-07-04 00:00:00 | Client 3 | 0
2010-07-05 00:00:00 | Client 3 | 97.1
2010-07-06 00:00:00 | Client 4 | 100
2010-07-07 00:00:00 | Client 1 | 80
2010-07-08 00:00:00 | Client 2 | 97.1
2010-07-09 00:00:00 | Client 3 | 95
2010-07-10 00:00:00 | Client 3 | 0
2010-07-11 00:00:00 | Client 3 | 0
2010-07-12 00:00:00 | Client 4 | 97.4
2010-07-13 00:00:00 | Client 3 | 100
2010-07-14 00:00:00 | Client 4 | 92.3
Spreadsheet: 691918d1597946432-help-with-vlookup-and-index-match-not-returning-all-unique-values-linkingpartnumbersb
Sheet: Sheet1

 | 50200-TLA-20-CL1 |  | What results should be
 |  |  | 50200-TLA-20-CL1
 |  |  | 50200-TLA-20-BK
 |  |  | 50200-TLA-A510-20
 |  |  | 50200-TLA-A510-20-W
 |  |  | BE200-TLA-A000
 |  |  | BE200-TLA-R000
 |  |  | BE300-TLA-A000
 |  |  | BE300-TLA-R000
 |  |  | 50200-TLA-A530-M1
 |  |  | 50200-TLA-R530-M1
 |  |  | 50200-TLA-A53
 |  |  | 50200-TLA-R53
Spreadsheet: 120695d1315464861-lookup-multiple-returns-lookup
Sheet: Customers

Forename | Surname | DOB | Gender | Attribute | Postcode
[NAME] | Smith | 1963-03-11 00:00:00 | f | B-S-11/03/1963-f | SA1 2BC
Beard | [NAME] | 1980-07-09 00:00:00 | f | B-D-09/07/1980-f | CF4 9GH
Bhudia | Dalel | 1989-08-01 00:00:00 | m | B-D-01/08/1989-m | BS2 6LK
Black | Stuart | 1972-09-11 00:00:00 | m | B-S-11/09/1972-m | HG9 9OK
Bowyer | [NAME] | 1971-02-26 00:00:00 | m | B-R-26/02/1971-m | SW1 4TT
Bull | [NAME] | 1982-07-25 00:00:00 | m | B-A-25/07/1982-m | BR6 9HY
[NAME] | [NAME] | 1989-01-07 00:00:00 | f | B-M-07/01/1989-f | CO42 3HB
Beard | [NAME] | 1980-07-09 00:00:00 | f | B-D-09/07/1980-f | JF9 4LF
Black | Stuart | 1972-09-11 00:00:00 | m | B-S-11/09/1972-m | BFPO32
Bull | [NAME] | 1982-07-25 00:00:00 | m | B-A-25/07/1982-m | KS7 8PL
Spreadsheet: 16a9118f-08be-4e91-876b-642ca96f5d5b
Sheet: Your Annual Plan

 | MONTHLY COSTS:  Think of fun things to do every month and enter them below as activities.  Enter activity names and costs in the highlighted cells only.
 | SEPTEMBER |  | OCTOBER |  | NOVEMBER
 | Planned Activity | Cost | Planned Activity | Cost | Planned Activity | Cost
 | This Month's Total: |  | This Month's Total: |  | This Month's Total:
 | DECEMBER |  | JANUARY |  | FEBRUARY
 | Planned Activity | Cost | Planned Activity | Cost | Planned Activity | Cost
 | This Month's Total: |  | This Month's Total: |  | This Month's Total:
 | [NAME] |  | APRIL |  | MAY
 | Planned Activity | Cost | Planned Activity | Cost | Planned Activity | Cost
 | This Month's Total: |  | This Month's Total: |  | This Month's Total:
 | [NAME] |  | JULY |  | AUGUST
 | Planned Activity | Cost | Planned Activity | Cost | Planned Activity | Cost
 | This Month's Total: |  | This Month's Total: |  | This Month's Total:
 | Registration & Insurance | 0 |  | Number of Selling Scouts in your Unit: |  | 40
 | Advancements | 0 |  | Your Unit's Comission |  | 0.3
 | Uniforms | 0 | Enter the number of Scouts and your comission to calculate your goals: | Unit Total Activity Cost and Expenses
ANNUAL COSTS: Enter other annual Unit expenses: | Scholarships | 0
 | Other Expenses | 0 |  | Unit [NAME]
 | Annual Total:
 |  |  |  | Scout Sales Goal
Spreadsheet: 141353d1329230073-trying-to-display-information-from-multiple-sheets-onto-1-summary-sheet-ef41_copy-of-production-scheduler-2-
Sheet: Feb 2012

2012-02-01 00:00:00
Date Submitted | Job No | Site | Customer | Project Engineer / Manager | Scope of work | Min People | Budget Hours | Field of work | Start Date | Finish Date | Comments / Additional Information | Special Tools |  |  | Match
What you had (below):
2012-01-26 00:00:00 | A16554 |  | SIEMENS | [NAME] | 2 X MOBILE ANALYSIS RACKS | 1 | 40 | ELECTRICAL | 2012-02-13 00:00:00 | 2012-02-27 00:00:00
 |  |  |  |  |  | 1 | 40 | MECHANICAL | 2012-02-13 00:00:00 | 2012-02-27 00:00:00
2012-02-08 00:00:00 | N14700/2816 | RYEHOUSE | NAT GRID | [NAME] | INSTALL HAND RAIL / BARRIERS | 1 | 8 | MECHANICAL | 2012-02-17 00:00:00 | 2012-02-17 00:00:00 |  | 36V HAMMER DRILL, 1 1/2" TUBE CUTTER
2012-01-30 00:00:00 | N16000 | SAPPERTON | NAT GRID | S.OWEN | GTA | 1 | 80 | ELECTRICAL | 2012-02-13 00:00:00 | 2012-02-24 00:00:00
Spreadsheet: lisa_gang__22393__Hanson Scheduling Model_4_16
Sheet: Scheduling

 |  |  |  |  | HANSON PERMANENTE CEMENT
 |  |  |  |  |  | Power Usage Forecast
 | CALIFORNIA SCHEDULING COORDINATION AND
 | ENERGY PURCHASES AND SALES AGREEMENT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monday: Tuesday Scheduling
 | Day of Scheduling |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tuesday: Wednesday Scheduling
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wednesday: Thursday Scheduling
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Thursday: Friday & Saturday Scheduling
 | 2002-04-16 00:00:00 | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | Total |  |  |  |  |  |  |  |  | Friday: Sunday and Monday LLH Scheduling
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 |  |  |  |  |  |  |  |  |  | Friday: Monday HLH
 |  | 31.152 | 30.948 | 30.804 | 30.972 | 31.128 | 31.308 | 31.716 | 30.024 | 25.176 | 25.476 | 22.044 | 20.616 | 20.868 | 20.808 | 20.64 | 20.34 | 27.072 | 29.784 | 31.332 | 31.308 | 30.744 | 30.756 | 30.66 | 25.524 |  |  |  |  |  |  |  |  |  | Holiday
 |  | 31.61023590669259 | 31.61023590669259 | 31.61023590669259 | 31.61023590669259 | 32.36023590669259 | 32.36023590669259 | 32.56023590669258 | 30.16 | 30.16 | 30.16 | 30.16 | 30.16 | 28.635 | 28.635 | 29.385 | 28.505 | 30.90523590669259 | 30.90523590669259 | 31.48023590669258 | 31.48023590669258 | 32.36023590669259 | 32.36023590669259 | 31.61023590669259 | 31.61023590669259
 | Day Ahead Incremental Quantity (Hanson needs to purchase)
 | Day Ahead Decremental Quantity (Hanson needs to sell)
 | Contact Persons
 | EPMI | Telephone |  |  | E-Mail
 | [NAME] | 503/464-3829 |  |  | [EMAIL]
 | [NAME] | 503/464-5053 |  |  | [EMAIL]
 | [NAME] | 503/464-3822 |  |  | [EMAIL]
 | [NAME] | 503/464-3824 |  |  | [EMAIL]
 | [NAME] | [PHONE] |  |  | [EMAIL]
 | Hanson | Telephone |  |  | E-Mail
 | [NAME] Manager | [PHONE] |  |  | [EMAIL]
 | [NAME] Engineer | [PHONE] |  |  | [EMAIL]
 | [NAME]  - VP Operations | [PHONE] |  |  | [EMAIL]
 | [NAME] | [PHONE] |  |  | [EMAIL]