tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 46c06fac-8905-4dcf-b7c1-ada3243292ad
Sheet: Table 4.1

4.1 Turnover of retail establishments
Month | 2009–10 | 2010–11 | 2011–12 | 2012–13 | 2013-14
Value (a)(b) – $ million
July | 19598.7 | 20369.7 | 20682.7 | 21440.6 | 21872.3
August | 19648 | 20391.2 | 20812.3 | 21460.1 | 21975.5
September | 19639.1 | 20383 | 20823.2 | 21526.7 | 22180.3
October | 19757.4 | 20178 | 20854.5 | 21505.9 | 22284.9
November | 20108.5 | 20335.5 | 20929.1 | 21481.8
December | 19976.9 | 20388.1 | 20926.6 | 21392
January | 20047.3 | 20405.6 | 20949.3 | 21651.3
February | 19889.6 | 20609.7 | 20974.3 | 21922.1
March | 19943.9 | 20509.3 | 21219 | 21803.2
April | 20156.2 | 20686.2 | 21181.7 | 21783.5
May | 20163.6 | 20578.5 | 21341.6 | 21827.9
June | 20257 | 20537.1 | 21618.2 | 21835.7
Annual | 239186.2 | 245371.9 | 252312.5 | 259630.8
Annual change (a) – per cent
July | 4.875986622073583 | 3.933934393607743 | 1.536596022523653 | 3.664415187572217 | 2.01346977230115
August | 5.620212337051484 | 3.782573289902274 | 2.065106516536531 | 3.112582463254896 | 2.40166634824628
September | 6.071866442702884 | 3.787851785468789 | 2.15964283962127 | 3.378443274808873 | 3.036229426711941
October | 5.651720542231516 | 2.128822618360715 | 3.352661314302694 | 3.123546476779595 | 3.622261797925219
November | 7.225889705333415 | 1.128875848521773 | 2.919033217771869 | 2.640820675518782
December | 2.30608503272461 | 2.058377425926935 | 2.641246609541838 | 2.223963759043528
January | 2.892146295897106 | 1.787273099120569 | 2.664464656760885 | 3.350947287021526
February | 3.497333159880299 | 3.620485077628516 | 1.769069903977254 | 4.518863561596802
March | 1.14565371741557 | 2.834952040473524 | 3.460381387955707 | 2.753192893161781
April | 2.072730403253175 | 2.629463887042192 | 2.395316684552995 | 2.841131731636267
May | 1.133536634299006 | 2.05766827352258 | 3.70823918167018 | 2.27864827379392
June | 2.093066622315632 | 1.382731895147344 | 5.264131742066809 | 1.006096714805111
Annual | 3.70168319038604 | 2.598001620849932 | 3.127902782391412 | 2.498688842454433
(a) Monthly figures are seasonally adjusted.
(b)  Excludes hotels, licensed clubs, video hire outlets, hairdressing and beauty salons,
motor vehicle sales, motor vehicle parts and tyre retailing, fuel retailing and
marine equipment retailing. |  |  |  |  |  |  |  | Update
Source: ABS, Retail Trade, Australia, cat. no. 8501.0. |  |  |  |  |  |  |  | 2014-01-09 00:00:00
Spreadsheet: 886675d1736771456-multiple-coulmns-to-be-auto-generated-based-on-permutation-dataset
Sheet: Sheet1

 |  | Dataset
 |  | A | Ignore | 1001 | 1002 | Ignore | 1003
 |  | B | Ignore | 2001 | 2002 | Ignore | Ignore
 |  | ID | Subject 1 | Subject 2 | Subject 3 | Subject 5 | Subject 6
 |  | 1 | 100 | 200 | 300 | 800 | 900
 |  | 2
 |  | 3
 |  | 4
 |  | Desired output
 |  | A &B | ID | Amount | Amount |  | A &B | ID | Amount | Amount
 |  | 1001 | 1
 |  | 1001 | 2
 |  | 1001 | 3
 |  | 1001 | 4
 |  | 1002 | 1
 |  | 1002 | 2
 |  | 1002 | 3
 |  | 1002 | 4
 |  | 1003 | 1
 |  | 1003 | 2
 |  | 1003 | 3
 |  | 1003 | 4
 |  | 2001 | 1 |  | 200
 |  | 2001 | 2 |  | 201
 |  | 2001 | 3 |  | 202
 |  | 2001 | 4 |  | 203
 |  | 2002 | 1 |  | 300
 |  | 2002 | 2
 |  | 2002 | 3
 |  | 2002 | 4
Spreadsheet: craig_dean__4354__10_31actb
Sheet: Economics

 | Commodity Revenue (Cost) | Demand Charge | Total | Total Volume | $/Mwhr Commodity Cost | $/Mwhr Total Cost
Purchases
[NAME]. Cost Est. |  |  |  |  | 20 | 0
Incremental Purchases
[NAME]
4C Balancing
4C Realtime
[NAME]
PV Balancing
PV Realtime
SPS Pre
Artesia Balancing
Artesia Realtime
Sales
Incremental Sales
[NAME]
4C Balancing
4C Realtime
[NAME]
PV Balancing
PV Realtime
[NAME]
Artesia Balancing
Artesia Realtime
 |  |  |  |  |  |  | Heat | Fuel
Generation |  |  |  |  |  |  | Rate | Cost
4 Corners Unit 4 |  |  |  |  |  |  | 10.0576 | 1.3
4 Corners Unit 5 |  |  |  |  |  |  | 10.0576 | 1.3
PV Unit 1 |  |  |  |  |  |  | 10.16 | 0.6
PV Unit 2 |  |  |  |  |  |  | 10.16 | 0.6
PV Unit 3 |  |  |  |  |  |  | 10.16 | 0.6
Newman 1
Newman 2
Newman 3
GT 1
GT 2
GT1+ST1
GT2+ST1
Newman 4 |  |  |  |  |  |  |  | 1.96
Copper
Rio Grande 6
Rio Grande 7
Rio Grande 8
Total
Spreadsheet: 94040d1293824464-moving-data-from-a-row-to-column-based-on-dup-test_data_macro
Sheet: Raw Data

Company Name | First Name1 | Last Name1 | Title1 | Contact Number1 | Contact Email1 | Primary Address 1 | Primary Address 2 | Primary City | Primary State | [NAME] | Primary Country | Company Number | Toll-Free Number | Company Fax | Web Address | Employees At This Location | Primary Industry | Import Source
Company A | [NAME] | [NAME] | Director | [PHONE] | [EMAIL] | Test Address | Unit 4 | somewhere | CT | 6109 | United States | [PHONE] |  | [PHONE] | http://www.blah.com | 20 | Education | Hoovers
Company A | [NAME] | Shipman | Director | [PHONE] | [EMAIL] | Test Address | Unit 4 | somewhere | CT | 6109 | United States | [PHONE] |  | [PHONE] | http://www.blah.com | 10 | Education | Hoovers
Company A | [NAME] | Mance | Operations | [PHONE] | [EMAIL] | Test Address | Unit 4 | somewhere | CT | 6492 | United States | [PHONE] |  | [PHONE] | http://www.blah.com | 11 | Hospitality | Hoovers
Company A | [NAME] | [NAME] | President | [PHONE] | [EMAIL] | Test Address | Unit 4 | somewhere | CT | 6040 | United States | [PHONE] |  | [PHONE] | http://www.blah.com | 11 | Hospitality | Hoovers
Company A | [NAME] | Rickard | President | [PHONE] | [EMAIL] | Test Address | Unit 4 | somewhere | CT | 6489 | United States | [PHONE] |  | [PHONE] | http://www.blah.com | 18 | Software/Services | Hoovers
Company B | Michelle | Burnore | IT Manager | [PHONE] | [EMAIL] | Test Address | Unit 4 | somewhere | CT | 6489 | United States | [PHONE] |  | [PHONE] | http://www.blah.com | 18 | Software/Services | Hoovers
Company B | [NAME] | Rickard | Owner | [PHONE] | [EMAIL] | Test Address | Unit 4 | somewhere | CT | 6489 | United States | [PHONE] |  | [PHONE] | http://www.blah.com | 18 | Software/Services | Hoovers
Company B | [NAME] | Robertshaw | President | [PHONE] | [EMAIL] | Test Address | Unit 4 | somewhere | CT | 6103 | United States | [PHONE] |  | [PHONE] | http://www.blah.com | 25 | Software/Services | Hoovers
Company C | Hector | Torres | President | [PHONE] | [EMAIL] | Test Address | Unit 4 | somewhere | CT | 6106 | United States | [PHONE] |  | [PHONE] | http://www.blah.com | 10 | Software/Services | Hoovers
Company C | [NAME] | Funtes | Principal | [PHONE] | [EMAIL] | Test Address | Unit 4 | somewhere | CT | 6106 | United States | [PHONE] |  | [PHONE] | http://www.blah.com | 10 | Software/Services | Hoovers
Company C | Christine | Manzi | Staff | [PHONE] | [EMAIL] | Test Address | Unit 4 | somewhere | CT | 6106 | United States | [PHONE] |  | [PHONE] | http://www.blah.com | 11 | Medical | Hoovers
Company C | [NAME] | Aucoin | Manager | [PHONE] | [EMAIL] | Test Address | Unit 4 | somewhere | CT | 6106 | United States | [PHONE] |  | [PHONE] | http://www.blah.com | 11 | Medical | Hoovers
Spreadsheet: 748023d1631834391-value-look-up-based-on-time-periods-and-a-number-of-criteria-example-sumproduct
Sheet: % Lookup

ET Branch | NA Country | Insurance Type | Effective Start Date | Effective End Date | Swiss Re | Aspen | SCOR | Zurich | Allianz | 100% check
Americas | United States | RWI | 2021-07-01 00:00:00 | 2021-12-31 00:00:00 | 0.5633802816901409 | 0.2112676056338028 | 0.1408450704225352 | 0.08450704225352113
Americas | United States | Tax | 2021-07-01 00:00:00 | 2021-12-31 00:00:00 | 0.61538 | 0.23077 | 0.15385
Americas | United States | RWI | 2021-01-01 00:00:00 | 2021-06-30 00:00:00 | 0.597014925373134 | 0.164179104477612 | 0.1492537313432836 | 0.08955223880597014
Americas | United States | Tax | 2021-01-01 00:00:00 | 2021-06-30 00:00:00 | 0.65574 | 0.18033 | 0.16393
Americas | United States | RWI | 2020-12-01 00:00:00 | 2020-12-31 00:00:00 | 0.6060606060606061 | 0.1515151515151515 | 0.09090909090909091 |  | 0.1515151515151515
Americas | United States | RWI | 2020-11-01 00:00:00 | 2020-11-30 00:00:00 | 0.6666666666666666 | 0.1666666666666667 | 0.1666666666666667
Americas | United States | RWI | 2020-09-01 00:00:00 | 2020-10-31 00:00:00 | 0.5517241379310345 | 0.1379310344827586 | 0.1379310344827586 |  | 0.1724137931034483
Americas | United States | RWI | 2020-05-01 00:00:00 | 2020-08-31 00:00:00 | 0.59259 | 0.14815 | 0.07407 |  | 0.18519
Americas | United States | RWI | 2018-09-13 00:00:00 | 2020-04-30 00:00:00 | 0.5 | 0.125 | 0.0625 |  | 0.3125
Americas | United States | RWI | 2016-12-01 00:00:00 | 2018-09-12 00:00:00 | 0.5 | 0.14286 |  |  | 0.35714
Americas | United States | RWI | 2016-10-01 00:00:00 | 2016-11-30 00:00:00 | 0.58333 |  |  |  | 0.41667
Americas | United States | RWI | 2016-06-01 00:00:00 | 2016-09-30 00:00:00 | 0.57143 |  |  |  | 0.42857
Americas | Canada | RWI | 2021-07-01 00:00:00 | 2021-12-31 00:00:00 | 0.5303 | 0.22727 | 0.15152 | 0.09091
Americas | Canada | Tax | 2021-07-01 00:00:00 | 2021-12-31 00:00:00 | 0.58333 | 0.25 | 0.16667
Americas | Canada | RWI | 2021-05-01 00:00:00 | 2021-06-30 00:00:00 | 0.56452 | 0.17742 | 0.16129 | 0.09677
Americas | Canada | Tax | 2021-05-01 00:00:00 | 2021-06-30 00:00:00 | 0.625 | 0.19643 | 0.17857
Americas | Canada | RWI | 2021-01-01 00:00:00 | 2021-04-30 00:00:00 | 0.67308 | 0.21154 |  | 0.11538
Americas | Canada | Tax | 2021-01-01 00:00:00 | 2021-04-30 00:00:00 | 0.76087 | 0.23913
Americas | Canada | RWI | 2020-01-01 00:00:00 | 2020-12-31 00:00:00 | 0.5 | 0.14286 |  |  | 0.35714
Spreadsheet: 9fd3dd05-a3c3-4b06-b886-fcdbc92f0782
Sheet: 1.2

Cuadro 1.2
[NAME]
Nacimientos registrados por grupo de edad del padre, según grupo de edad de la madre al momento del registro, 2010
Grupos de edad de la madre al momento del registro | Total | Grupos de edad del padre al momento del registro
 |  | Menor de 15 años | 15-19 | 20-24 | 25-29 | 30-34 | 35-39 | 40-44 | 45-49 | 50 años y más | No especificada
Total país |  | 14 | 2176 | 18681 | 28038 | 24470 | 15178 | 7964 | 3808 | 3131 | 14174
15-19 |  | 5 | 1611 | 8623 | 5597 | 2333 | 1061 | 537 | 247 | 276 | 4329
20-24 |  | 5 | 719 | 10965 | 15660 | 9085 | 3917 | 1984 | 988 | 881 | 9548
25-29 |  | 9 | 199 | 3288 | 11412 | 12547 | 6493 | 3116 | 1484 | 1193 | 7582
30-34 |  | 11 | 57 | 960 | 3596 | 8455 | 7298 | 3661 | 1624 | 1426 | 5416
35-39 |  | 6 | 31 | 234 | 849 | 2059 | 3756 | 2945 | 1544 | 1338 | 3464
40-44 |  | 2 | 7 | 54 | 161 | 322 | 681 | 1245 | 1082 | 1158 | 1971
45-49 |  | 1 | 4 | 11 | 21 | 46 | 133 | 258 | 447 | 961 | 1195
50 años y más |  | 2 | 1 | 26 | 30 | 40 | 63 | 110 | 157 | 2071 | 2710
No especificado |  | 3 | 53 | 168 | 164 | 128 | 91 | 112 | 108 | 690 | 5342
Nota: Elaborado con datos registrados en las Oficialías del Estado Civil, Junta Central Electoral (JCF).
Fuente: Oficina Nacional de Estadística, (ONE).
Spreadsheet: 707549d1607344699-getting-information-for-a-table-book2
Sheet: Filter

Name | Claimants | Workcoach FTE | Interventions | Interventions Per FTE | Attended | Failed To Attend | Cancelled | Rescheduled
Barking |  | 5254 | 87.54 | 3127 | 621 | 440 | 607 | 13
Canning town | 31.95 | 2572 | 80.5 | 1447 | 287 | 254 | 345 | 2
Hackney | 37.59 | 3329 | 88.57 | 1998 | 315 | 195 | 196 | 19
Hoxton | 38.02 | 3690 | 97.06 | 1860 | 514 | 372 | 584 | 8
Poplar | 59.26 | 4937 | 83.31 | 2996 | 542 | 317 | 472 | 6
Redbridge | 41.19 | 4037 | 98.01 | 2420 | 511 | 307 | 539 | 5
Romford | 51.18 | 4368 | 85.35 | 2790 | 418 | 323 | 646 | 1
[NAME] | 39.54 | 3658 | 92.51 | 2086 | 274 | 413 | 520 | 0
Walthamstow | 53.02 | 5015 | 94.58 | 2742 | 559 | 568 | 586 | 7
Walthamstow support office | 12.28 | 1327 | 108.1 | 820 | 120 | 145 | 168 | 7
 | IF(AND(Filter!$A5<>"",Filter!B$4<>""),SUMPRODUCT(('Raw Data'!$A$39:$A$674=Filter!$A5)*('Raw Data'!$B$39:$J$39=Filter!B$4)*('Raw Data'!$B$39:$B$674)),"")
 | IF(AND(filter!$A5<>"",filter!B$4<>""),SUMPRODUCT(('raw data'!$A$3:$A$88=filter!$A5)*('raw data'!$B$2:$J$2=filter!B$4)*('raw data'!$B$3:$J$88)),"")
 | IF(AND(Filter!$A5<>"",Filter!C$4<>""),SUMPRODUCT(('Raw Data'!$A$3:$A$88=Filter!$A5)*('Raw Data'!$B$2:$J$2=Filter!C$4)*('Raw Data'!$B$3:$J$88)),"")
 | IF(AND(Filter!$A5<>"",Filter!C$4<>""),SUMPRODUCT(('Raw Data'!$A$39:$A$674=Filter!$A5)*('Raw Data'!$B$39:$J$39=Filter!C$4)*('Raw Data'!$B$39:$B$674)),"")
Spreadsheet: 756037d1637249800-looking-up-data-in-a-range-and-adding-up-together-book4
Sheet: JFS

 |  |  |  |  |  |  | a | b | c | d | e | f | g | h | i | j | k | l | l
 |  | DROP DOWN MENUE
 |  | 2021-01-01 00:00:00 | 2021-02-01 00:00:00
 | 2021-01-01 00:00:00
 | 2021-02-01 00:00:00 |  | a | b | c | d | e | f | g | h | i | j | k | l | M
 | 2021-03-01 00:00:00 | Referrals
 | 2021-04-01 00:00:00 | Starts
 | 2021-05-01 00:00:00 | Referrals to Starts Ratio
 | 2021-06-01 00:00:00
 | 2021-07-01 00:00:00
 | 2021-08-01 00:00:00
 | 2021-09-01 00:00:00
 | 2021-10-01 00:00:00
 | 2021-11-01 00:00:00
 | 2021-12-01 00:00:00
Spreadsheet: 810909d1672159687-sort-and-filter-functions-exclude-cells-but-still-sort-alphabetically-sort_filter_2
Sheet: Sheet1

Yes
No |  | Fruit Names | [NAME] 1 | [NAME] 2 | [NAME] 3 | [NAME] | [NAME] | [NAME] 3 List
 |  | — Choose Fruit — | Yes | No | No
 |  | All Fruit | No | Yes | No | N/A | Fruit Group 1 | Peach
 |  | Fruit Group 1 | No | Yes | No | Peach | Fruit Group 2 | Orange
 |  | Fruit Group 2 | No | Yes | No | Orange | Fruit Group 3 | [NAME]
 |  | Fruit Group 3 | No | Yes | No | [NAME] | Peach | Pear
 |  | N/A | Yes | No | Yes | Pear | Orange | Apple
 |  | Peach | Yes | Yes | Yes | Apple | [NAME] | Lime
 |  | Orange | Yes | Yes | Yes | Lime | Pear | [NAME]
 |  | [NAME] | Yes | Yes | Yes | [NAME] | Apple | [NAME]
 |  | Pear | Yes | Yes | Yes | [NAME] | Lime | Blueberry
 |  | Apple | Yes | Yes | Yes | Blueberry | [NAME] | Rockmelon
 |  | Lime | Yes | Yes | Yes | Rockmelon | [NAME] | Kiwi
 |  | [NAME] | Yes | Yes | Yes | Kiwi | Blueberry | Unknown
 |  | [NAME] | Yes | Yes | Yes | Unknown | Rockmelon
 |  | Mango | No | No | No |  | Kiwi
 |  | Blueberry | Yes | Yes | Yes |  | Unknown
 |  | Rockmelon | Yes | Yes | Yes
 |  | Kiwi | Yes | Yes | Yes
 |  | Unknown | Yes | Yes | Yes
 |  | Spare Fruit 1 | No | No | No
 |  | Spare Fruit 2 | No | No | No
 |  | Spare Fruit 3 | No | No | No
Spreadsheet: e175f2e6-12a8-45f7-a68b-375f1ac574dc
Sheet: Sheet1

Secretary of State (North Dakota) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Downloaded at 5/22/2013 2:20:50 AM
Precincts Reporting: 567/567 - Total Ballots Cast: 220479
2006 General Election - OFFICIAL RESULTS
Precinct | [NAME] (Al) Jaeger | [NAME] | TOTALS
Precinct 3901 | 465 | 274 | 739
TOTAL | 465 | 274 | 739
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 769153d1645353685-random-number-generation-based-on-probability-book1
Sheet: Sheet1

Values |  | NO repeat |  |  | Values | RAND |  | Can repeat
1 |  |  |  |  | 1
1 |  |  |  |  | 1
1 |  |  |  |  | 1
1 |  |  |  |  | 1
2 |  |  |  |  | 2
2 |  |  |  |  | 2
2 |  |  |  |  | 2
2 |  |  |  |  | 2
3 |  |  |  |  | 3
3 |  |  |  |  | 3
3 |  |  |  |  | 3
3 |  |  |  |  | 3
4 |  |  |  |  | 4
4 |  |  |  |  | 4
4 |  |  |  |  | 4
4 |  |  |  |  | 4
5 |  |  |  |  | 5
5 |  |  |  |  | 5
5 |  |  |  |  | 5
5 |  |  |  |  | 5
6 |  |  |  |  | 6
6 |  |  |  |  | 6
6 |  |  |  |  | 6
6 |  |  |  |  | 6
7 |  |  |  |  | 7
7 |  |  |  |  | 7
7 |  |  |  |  | 7
7 |  |  |  |  | 7
8 |  |  |  |  | 8
8 |  |  |  |  | 8
8 |  |  |  |  | 8
8 |  |  |  |  | 8
9 |  |  |  |  | 9
9 |  |  |  |  | 9
9 |  |  |  |  | 9
9 |  |  |  |  | 9
Spreadsheet: 876802d1723528583-how-to-create-a-pivot-table-to-represent-categorical-text-james1700-test-196-365-aligw
Sheet: Sheet2

 | Aware | Not Aware | (blank) | Grand Total
Product 1 | 30 | 71 |  | 101
Product 2 | x | x | x | x
Product 3 | x | x | x | x
Product 4 | x | x | x | x
Product 5 | x | x | x | x
Product 6 | x | x | x | x
 | Aware | Not Aware | Blank | Grand Total
Product 1 | 98 | 3 | 10 | 111
Product 2 | 100 | 1 | 10 | 111
Product 3 | 94 | 7 | 10 | 111
Product 4 | 33 | 68 | 10 | 111
Product 5 | 37 | 64 | 10 | 111
Product 6 | 30 | 71 | 10 | 111
Spreadsheet: 2d97a9f7-15d9-4fd3-a0db-9bbdfbab4719
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
OAK | Test | OAK | Oak, IgE | Oak, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m. - 8 p.m., Saturday; 8 a.m. - 3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
OAK | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
OAK | Result | OAK | Oak, IgE | Oak, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6189-5 | Quercus alba [NAME].IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: 682262d1591982948-sum-based-on-order-number-2020-06-12-oeldere-stax67-pt-682211d1591966063-sum-based-on-order-number-in
Sheet: Sheet1

Invoice Number | Details | Cost | Quantity | Item No | Unit | Expr1 | Exchange Rate | Value£ | WON | [NAME] | country | month | year
4420 | 106196 | 2500 | 40 | 1 | pc | 100000 | 1 | 100000 | 203363
4421 | 102928 | 35 | 6 | 1 | pc | 210 | 1 | 210 | 203398
4421 | 104443 | 150 | 6 | 2 | pc | 900 | 1 | 900 | 203398
4421 | 105001 | 100 | 6 | 3 | pc | 600 | 1 | 600 | 203398
4422 | 105923 | 4321.5 | 0.6 | 1 | km | 2592.900146484375 | 1 | 2592.900146484375 | 203392
4423 | 100218 | 1500 | 1.23 | 1 | km | 1845 | 1 | 1845 | 203371
4424 | 106098 | 7985.52 | 2 | 1 | pc | 15971.0400390625 | 1.2 | 13309.19921875 | 203323
4424 | 106098 | 7985.52 | 2 | 2 | pc | 15971.0400390625 | 1.2 | 13309.19921875 | 203323
4424 | 106098 | 7985.52 | 2 | 3 | pc | 15971.0400390625 | 1.2 | 13309.19921875 | 203323
4424 | 106098 | 7985.52 | 1 | 4 | pc | 7985.52001953125 | 1.2 | 6654.599609375 | 203323
4425 | 106205 | 5850 | 1 | 1 | pc | 5850 | 1 | 5850 | 203361
4426 | 106197 | 3660 | 2 | 1 | PC | 7320 | 1 | 7320 | 203358
4427 | 105605 | 3580 | 1 | 1 | pc | 3580 | 1 | 3580 | 203240
4427 | 105601 | 357 | 1 | 2 | pc | 357 | 1 | 357 | 203240
4427 | 105602 | 720 | 1 | 3 | pc | 720 | 1 | 720 | 203240
4427 | 105603 | 472 | 1 | 4 | pc | 472 | 1 | 472 | 203240
4427 | 105880 | 1003 | 1 | 5 | pc | 1003 | 1 | 1003 | 203240
Sum based on order number
Hi,
I need a liitle help with my spreadsheet.
On sheet 1, I want to be able to sum the values in the Expr1 column (green) for the numbers in WON (blue) so that the numbers in WON (blue) only appear once in the list, e.g. 203398 will equal 1710.
I then need to lookup [NAME] (yellow) on sheet 2 and then populate the columns on sheet 3 with the data.
Finally on sheet 3 I would like the total to change based on filtered results, e.g. if I filter orders shipped in June the total should be just for June, in this case £55,898.64.
TIA,
[NAME].
Spreadsheet: 855087d1704790761-added-week-numbers-into-cell-but-get-the-value-error-contract-register
Sheet: On Approval & Approved

Job No. | Item No. | Customer Order No. | Steelway Quote Ref No. | Customer | Specification | Value | Description / Contract | Drawn  By | Status | Date Rec'd  In D.O | Customers Date Required | Days  Remaining | Drawings Sent  For Approval Date | App'd Date | Date Issued  For Manufacture | Fabrication Duration | Works Dept.  Status | Estimated Works Completion Date (w/c) | Manufacturing  Dept. | Contact Name | Tank  Height (mm) | Tank Dia | Shipping Address | Shipping Requirements | Tanks Models  Requested
Spreadsheet: 25703d1217214536-changing-formula-color-not-cell-color-in-formula-bar-exampledate
Sheet: Sheet4

451 | 0 | 6
377 | 1 | 6
997 | 2 | 3
796 | 3 | 3
083 | 4 | 9
877 | 5 | 3
070 | 6 | 7
518 | 7 | 11
867 | 8 | 7
411 | 9 | 5
867
042
731
480
704
244
186
646
469
925
Spreadsheet: 886115d1736151239-sorting-data-from-a-dynamic-list-excel-help
Sheet: Data

 | Direction | Leader | Team | Closed Stops | No Stops Pub Only | No Stops Closed |  |  |  |  |  |  |  |  |  |  | Bus Stop | Closure
 |  |  |  |  |  |  | Date | Leader | Board |  | Boards | Dynamic | Duration (Days) |  |  |  | list | Type | [NAME]
 |  |  | Select Your Team |  |  |  |  | Select The Leader |  |  |  |  |  |  |  |  |  | [NAME]
 | AH | L | 04 | Publicity Only |  |  |  |  | All Buses | Publicity Only |  |  | Start date |  |  |  | Pub Only | Weekdays Only | Weekdays
 | L |  | 06 | Publicity & Hood |  |  |  |  | To Place | [NAME] |  |  | Finish Date |  |  |  | Pub & Hood | Weekends Only
 | L-AH |  | 07 |  |  |  |  |  | To Route | [NAME] |  |  |  |  |  |  | Removed | Saturdays Only | Weekends
 | R |  | 08 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sundays Only
 | R-AH |  | 09 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Saturdays Only
 | C-Nav |  | Edgware
 | EXT 1 |  | Eltham |  |  |  |  | Weekdays Only |  |  |  |  |  |  |  |  |  |  | Sundays Only
 | EXT 2 |  | Events |  |  |  |  | Weekends Only
 | EXT 3 |  | Morden
 | EXT 4 |  | [NAME]
 | EXT 5 |  | Turnpike Lane |  |  |  |  | When Instructed
 | EXT 6 |  | Uxbridge
Spreadsheet: 869087d1715753943-conditional-format-highlight-a-value-if-matches-with-a-group-data-and-set-criteria-sample-data
Sheet: Sheet1

Branch | Wages | Green | Orange |  | Red
 |  | Under | Between |  | Over
ABC | 320000 |  | 320000 | 326400
DEF | 20500 |  | 20500 | 20910
GHI | 47500 |  | 47500 | 48450
JKL | 63000 |  | 63000 | 64260
MNO | 25000 |  | 25000 | 25500
PQR | 21500 |  | 21500 | 21930
STU | 9500 |  | 9500 | 9690
VWX | 6700 |  | 6700 | 6834
YZ | 120000 |  | 120000 | 122400
Conditional Format - Update cell colour based on the criteria above
ABC | 350000
DEF | 18000
GHI | 5000
JKL | 63500
MNO | 26500
PQR | 22000
STU | 9300
VWX | 6800
YZ | 121000