tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 491672d1480594678-sort-array-formula-results-in-descending-order-sort-array-formula-results-in-descending-order
Sheet: PS_DROP DOWN LISTS DATA

MANUFACTURE LOCATION |  | DEILVERY TYPE |  | DRIVER |  | TRANSPORT |  | DELIVERY No. |  | CLIENT LIST |  | JOB LIST |  | DELIVERY COUNT  (BY JOB) |  | TRANSPORT (DATE SPECIFIC)
SITE 1 |  | DELIVERY |  | Driver 1 |  | Vehicle 1 |  | DEL 1
SITE 2 |  | SITE |  | Driver 2 |  | Vehicle 2 |  | DEL 2
ALL OUTSOURSE |  | CLIENT COLLECT |  | Driver 3 |  | Vehicle 3 |  | DEL 3
 |  | OTHER |  | Driver 4 |  | Vehicle 4 |  | DEL 4 |  |  |  |  |  |  |  |  |  |  |  | =OFFSET(PRICELIST!$A$5,0,0,COUNTA(PRICELIST!$A$5:$A$202))
 |  | COLLECTION |  | Driver 5 |  | Vehicle 5 |  | DEL 5 |  |  |  |  |  |  |  |  |  |  |  | =IFERROR(INDEX(RANGE,MATCH(0,COUNTIF($A$3:A3,RANGE),0)),"")
 |  |  |  | Driver 6 |  | Vehicle 6 |  | DEL 6 |  |  |  |  |  |  |  |  |  |  |  | =OFFSET(CALCSHEET!$A$4, 0, 0, COUNT(IF(CALCSHEET!$A$4:$A$50="", "", 1)), 1)
 |  |  |  | Driver 7 |  | Vehicle 7 |  | DEL 7
 |  |  |  | Driver 8 |  | Vehicle 8 |  | DEL 8 |  |  |  |  |  |  |  |  |  |  |  | =IFERROR(INDEX(TYPE,MATCH(0,COUNTIF($B$3:B3,TYPE)+(RANGE<>$A$1),0)),"")
 |  |  |  |  |  |  |  | DEL 9
 |  |  |  |  |  |  |  | DEL 10
 |  |  |  |  |  |  |  | DEL 11
 |  |  |  |  |  |  |  | DEL 12
 |  |  |  |  |  |  |  | DEL 13
 |  |  |  |  |  |  |  | DEL 14
 |  |  |  |  |  |  |  | DEL 15
Spreadsheet: 167521d1342017291-how-to-average-data-by-year-average-by-year
Sheet: Sheet1

 |  | year | Data
 |  | 2007 | 2 | Column of averages by year
 |  | 2007 | 1
 |  | 2007 | 3 |  |  | Row Labels | Sum of Data
 |  | 2006 | 2 |  |  | 2005 | 5
 |  | 2006 | 4 |  |  | 2006 | 7
 |  | 2006 | 1 |  |  | 2007 | 6
 |  | 2005 | 2 |  |  | Grand Total | 18
 |  | 2005 | 3
Spreadsheet: 84199d1284191287-combine-hyperlink-with-lookup-time-table-2010-2011
Sheet: Year 13 HL HW marks

 | Name | Comments | Name | Comments | Name | Comments | Name | Comments | Name | Comments | Name | Comments
Exercise 2.1
Exercise 2.2
Exercise 2.3
Exercise 2.4
Exercise 2.5
Exercise 2.6
Exercise 2.7
Exercise 2.8
Exercise 2.9
Exercise 2.10
Exercise 2.11
Exercise 2.16
Exercise 2.17
Exercise 2.18
Exercise 2.19
Exercise 2.19 (2)
Exercise 2.20
Exercise 2.21
Exercise 6.1
Exercise 6.2
Exercise 6.6
Exercise 5.1
Exercise 5.2
Exercise 5.3
Exercise 5.5
Exercise 5.6
Exercise 5.7
Exercise 5.8
Exercise 5.9
Exercise 5.10
Exercise 5.13 & 5.14
Exercise 5.17
Exercise 5.18
Exercise 5.19
Exercise 5.20
Exercise 5.21
2Arithmetic Expressions Worksheet 2.php.pdf
If statement.php.pdf
11Tracing Algorithms.php.pdf
7Methods Worksheet 2.php.pdf
Spreadsheet: 97718d1296827348-lookup-formula-cell-not-showing-correct-value-copy-of-transfers
Sheet: transfer sheet

 | MANAGER [NAME]: |  | TEAM NAME:
 | PLAYERS OUT
 | NUMBER | NAME | TEAM | VALUE
 | 826 | B [NAME] | West Ham | 2
 |  |  | TOTAL OUT | 2
 | PLAYERS IN
 | NUMBER | NAME | TEAM | VALUE
 |  |  | TOTAL IN | 0
 | MANAGER [NAME]: |  | TEAM NAME:
 | PLAYERS OUT
 | NUMBER | NAME | TEAM | VALUE
 |  |  | TOTAL OUT | 0
 | PLAYERS IN
 | NUMBER | NAME | TEAM | VALUE
 |  |  | TOTAL IN | 0
 | MANAGER [NAME]: |  | TEAM NAME:
 | PLAYERS OUT
 | NUMBER | NAME | TEAM | VALUE
 |  |  | TOTAL OUT | 0
 | PLAYERS IN
 | NUMBER | NAME | TEAM | VALUE
 |  |  | TOTAL IN | 0
Spreadsheet: cara_semperger__1441__PGE_NOVEMBER_MIDC_PATHS
Sheet: NOV (22)

 |  |  | To Portland General Electric : [NAME], [NAME], and [NAME]
 |  |  | Phone 464-7067
 |  |  | From Enron: Cara, [NAME], and [NAME] |  |  |  |  |  | DAILY COLSTRIP = 0
 |  |  | Phone 464-3814, 3902, 3831 |  |  |  |  |  | MONTH LONG COLSTRIP = 47 ATC
 |  |  |  |  | Mid Columbia Paths
2001-11-22 00:00:00
 | FLAT
 | DAY | 22 | AVISTA(G)CHELAN | X | AVISTA | ENRON | PGE | X | COLSTRIP B/R
 | MONTH | 25 | WWP(G)MIDC | X | WWP | ENRON | PGE | X | COLSTRIP B/R
 | MONTH COLSTRIP PATHS
 | ALL HOURS
 | MONTH | 6 |  | X | PGE | ENRON | ASHGROVE | X | MPCO NETWORK TRANSMISSION TO LOAD
 | MONTH | 6 |  | X | PGE | ENRON | EXPRESS PIPE | X | MPCO NETWORK TRANSMISSION TO LOAD
 | MONTH | 7 |  | X | PGE | ENRON | HOLNAM | X | MPCO NETWORK TRANSMISSION TO LOAD
 | MONTH | 8 |  | X | PGE | ENRON | LOUISIANA P | X | MPCO NETWORK TRANSMISSION TO LOAD
 | MONTH | 5 |  | X | PGE | ENRON | LUZENAC | X | MPCO NETWORK TRANSMISSION TO LOAD
 | MONTH | 15 |  | X | PGE | ENRON | SMURFIT | X | MPCO NETWORK TRANSMISSION TO LOAD
Spreadsheet: 83005d1283014384-two-values-in-drop-down-list-issue_1
Sheet: Sheet3

Products | Price | Prod No.
Shoe | 3 | fg565s
Bread | 1 | 43g-44
Car | 333222 | 23433-je
Car | 333222 | 23433-je
Juice | 2.2 | 43-44ggf
Bread | 1 | 43g-44
Car | 333222 | 23433-je
Tomato | 1.1 | 123-hgj
Bread | 1 | 43g-44
Ice Cream | 3.3 | sdfd-333
Spreadsheet: michelle_lokay__26570__imbalsumm0012
Sheet: Continental

 | Contintental
 | 500204 |  | 500205
Day | Measured | Scheduled | Measured | Scheduled
1 | 6188 | 6546 | 3125 | 2754
2 | 6334 | 6546 | 1812 | 2733
3 | 6939 | 6546 | 2006 | 2738
4 | 6807 | 6295 | 2497 | 3004
5 | 6573 | 7471 | 903 | 3647
6 | 6768 | 7471 | 4368 | 3647
7 | 6935 | 7471 | 4015 | 3647
8 | 5156 | 7471 | 2736 | 3647
9 | 6608 | 7437 | 4783 | 3647
10 | 7241 | 7403 | 3618 | 3647
11 | 6667 | 7389 | 2891 | 3647
12 | 12863 | 7471 | 2671 | 3647
13 | 8057 | 7457 | 2295 | 3647
14 | 5798 | 7471 | 2648 | 3647
15 | 6590 | 7471 | 3194 | 3647
16 | 6633 | 7471 | 3458 | 3647
17 | 6718 | 7471 | 3506 | 3647
18 | 6666 | 7471 | 3730 | 3647
19 | 6379 | 7471 | 3674 | 3647
20 | 6530 | 7471 | 3333 | 3647
21 | 7007 | 7471 | 2856 | 3647
22 | 6962 | 7471 | 3011 | 3647
23 | 6701 | 7471 | 2984 | 3647
24 | 14022 | 7471 | 2420 | 3647
25 | 19658 | 7471 | 2702 | 3647
26
27
28
29
30
31
2000-11-30 00:00:00 |  |  |  |  | -282710.67
2000-12-25 00:00:00
Spreadsheet: 739890d1626065827-formula-to-pull-only-the-differences-between-sheets-occ-geo-template-sample-7-11-2021
Sheet: (E) GEO Updates

Employee Number | Xref | First Name | Last Name | GEO
 | 500079 | ABEL | HERNANDEZ | 73
501287 | 501287 | CONNIE | CORPUS | 73
503418 | 503418 | MARTIN | ESPINOZA | 20
503771 | 503771 | NELSON | DAPAR | 73
504001 | 504001 | OLVIN | HERNANDEZ | 73
504734 | 504734 | [NAME] | LEBEL | 73
504769 | 504769 | RUBEN | POQUIZ | 20
506754 | 506754 | [NAME] | ALLEN | 20
506890 | 506890 | RICHARD | NICHOLSON | 57
506922 | 506922 | VICTOR | COLTON | 20
507074 | 507074 | [NAME] | POSADA | 73
507280 | 507280 | HUNG | PHAN | 73
507614 | 507614 | HUNG | TRUONG | 20
507772 | 507772 | [NAME] | DIAZ | 20
539388 | 539388 | BRADLEY | BEIER | 73
539532 | 539532 | DANIEL | ROOT | 55
540012 | 540012 | ADOLFO | CALLEJA MARIN | 73
540100 | 540100 | [NAME] | SMITH | 73
540971 | 540971 | WAYNE | RICKARDS | 20
0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0
Spreadsheet: 119684d1314651883-if-cell-equals-copy-row-emover
Sheet: Main

1 | A | B | C | X | E
2 | A | B | C | Y | E
3 | A | B | C | Z | E
4 | A | B | C | Y | E
Spreadsheet: phillip_m_love__30643__HS FT Ont Central
Sheet: Run Query

Daily Hedge Strip |  |  |  |  |  |  |  |  |  |  |  |  | Daily Hedge
User ID:
Password:
Included Deals | ALL
Today
Days in Month
Day of Month | 24 | 2000-05-24 00:00:00 | Update this cell daily.
PromptMonth | 2000-06-01 00:00:00
StartRange | D4
Enter NYMEX Date:
[NAME] | NXB2 | NX1
2000-05-24 00:00:00 | 2000-05-25 00:00:00 | 2000-05-26 00:00:00
Please Note:  Once the 'RUN ' button has been pressed, please do not disturb Excel.  Doing so will make you a bad person.
User ID:
Password: | Current Post Id's | Prior Post Id's
Date |  |  | # | Name | Type
Post Ids |  |  | 1 | Price
 |  |  | 2 | Basis | Basis
 |  |  | 3 | Gas Daily | [NAME]
 | 766690 |  | 4 | Gas Daily | [NAME] | Index only
 |  |  | 5 | Index
Spreadsheet: 97952d1297061760-multilookup-alongwith-sorting-for-only-months-plus-clubbing-like-data-multilookup-sort-clubbing
Sheet: U

Sr.No | Policy Holders Name | POLICY NO | Date of  Comm | T-T | MODE | NAME OF THE PLAN | Plan Type | SUM ASSURED
1 | [NAME] | 801848411 | 1997-03-28 00:00:00 | 75-20-20 | ECS | MONEY BACK | Insurance | 100000
2 | [NAME] | 801141846 | 2000-03-25 00:00:00 | 75-20-20 | ECS | MONEY BACK | Insurance | 100000
3 | [NAME] | 801141848 | 2001-12-24 00:00:00 | 122-17-17 | [NAME] | [NAME] | Insurance | 160000
4 | [NAME] | 801141849 | 2005-01-18 00:00:00 | 14-16-16 | ECS | ENDOWMENT  WITH BONUS | Insurance | 200000
5 | [NAME] | 801448161 | 2006-06-28 00:00:00 | 172-20-20 | HLY | FUTURE PLUS | ULIP | 0
6 | [NAME] | 801448164 | 2009-02-10 00:00:00 | 165-15-15 | ECS | JEEVAN SARAL | Insurance | 200000
7 | [NAME] | 801448165 | 2009-02-10 00:00:00 | 165-20-20 | ECS | JEEVAN SARAL | Insurance | 200000
Spreadsheet: 357243d1415349839-count-occurences-of-products-efb
Sheet: Blad2

[NAME] type | Q
 |  |  |  | Sum | Count
Product 1 | 1
Product 2 | 0
Product 3 | 0
Product 4 | 0
 | 1
 | 0
 | 0
 | 0
 | 0
 | 1
 | 0
 | 0
 | 0
 | 1
 | 0
 | 0
 | 1
 | 0
 | 0
 | 0
 | 0
 | 1
 | 0
 | 0
 | 3
 | 0
 | 0
 | 0
 | 0
 | 1
 | 0
 | 0
 | 1
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 2
Spreadsheet: 835512d1688638051-working-out-why-index-match-is-returning-error-index-match
Sheet: Sheet1

Insurance Company | Body Type | Plan Name | Commission
Methaq | [NAME] Cars | CMP
Alliance | 4WD | CMP
ASNIC | Sports car/coupe | CMP
ADNT | Pick up/Luxury trucks | CMP
Yas Takaful | Buses/Vans | CMP
Insurance House | Equipement and heavy vehicle | CMP
 | [NAME] | CMP
Spreadsheet: 155618d1336990808-serial-number-ikon_durga
Sheet: Sheet1

pincode | PRIORITY
767002 | 1
767002 | 2
767016 | 1
767016 | 2
767016 | 3
767017 | 1
767017 | 2
767017 | 3
767017 | 4
767017 | 5
767018 | 1
767020 | 1
767021 | 1
767021 | 2
Spreadsheet: 741406d1627028030-return-difference-of-value-in-between-blank-cells-test-spot-blank-and-return-above-and-below-blank
Sheet: Sheet1

 | Data | Diff |  | Expected Return
 | 224387020
 | 224393450
 | 224400330
 | 224406510
 | 224414320
 | 224420730
 |  |  |  | =(B11-B8)/2
 |  | 0 |  | =(B11-B8)/2
 | 224428360
 | 224432780
 | 224439500
 | 224448360
 | 224453320
 |  |  |  | =(B19-B15)/3
 |  |  |  | =(B19-B15)/3
 |  |  |  | =(B19-B15)/3
 | 224476240
 | 224483850
 | 224491320
Spreadsheet: 717487d1612698589-combine-table-with-dsum-function-and-data-table-tool-color-ans
Sheet: Sheet1

Product | Color | Sell |  | Product | Color | Product | Color | Product | Color | Product | Color | Product | Color | Product | Color
A | Blue | 100 |  |  | Blue |  | Green | B | Blue | B | Green | C | Blue | C | Green |  | Please, without VBA & helper colomns
B | Green | 200 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I mean you can use range(E2:G2)
A | Blue | 300 |  |  | A | B | C
A | Blue | 400 |  | Blue |  |  |  |  |  |  | Desired result
B | Green | 500 |  | Green |  |  |  |  |  |  | A | B | C
A | Green | 600 |  |  |  |  |  |  |  | Blue | 800 | 0 | 100
C | Blue | 100 |  |  |  |  |  |  |  | Green | 1400 | 700 | 0
A | Green | 800 |  | Colored rang(F5:H6) is My Result
 |  |  |  | Tbl | =Sheet1!$A$1:$C$9
Spreadsheet: 677548d1589392381-highlight-a-row-that-fits-two-criteria-household
Sheet: Sheet1

customer_id | firstname | lastname | address1 | homephone | workphone | cellphone | headofhousehold | FamilyID1 | FamilyName1 | FamilyRole1
44 |  |  |  |  |  |  | No | 2 |  | Adult / Guardian
121310 |  |  |  |  |  |  | No | 2 |  | Adult / Guardian
27 |  |  |  |  |  |  | No | 3 |  | Adult / Guardian
46 |  |  |  |  |  |  | No | 4 |  | Adult / Guardian
48 |  |  |  |  |  |  | No | 6 |  | Adult / Guardian
50 |  |  |  |  |  |  | No | 8 |  | Adult / Guardian
52 |  |  |  |  |  |  | No | 10 |  | Adult / Guardian
53 |  |  |  |  |  |  | Yes | 11 |  | Adult / Guardian
395 |  |  |  |  |  |  | No | 11 |  | Adult / Guardian
54 |  |  |  |  |  |  | Yes | 12 |  | Adult / Guardian
55 |  |  |  |  |  |  | No | 13 |  | Adult / Guardian
5974 |  |  |  |  |  |  | No | 15 |  | Adult / Guardian
57 |  |  |  |  |  |  | Yes | 15 |  | Adult / Guardian
221 |  |  |  |  |  |  | No | 16 |  | Adult / Guardian
10736 |  |  |  |  |  |  | No | 16 |  | Adult / Guardian
4228 |  |  |  |  |  |  | Yes | 17 |  | Adult / Guardian
62 |  |  |  |  |  |  | Yes | 19 |  | Adult / Guardian
69 |  |  |  |  |  |  | No | 21 |  | Adult / Guardian
83 |  |  |  |  |  |  | No | 22 |  | Adult / Guardian
85 |  |  |  |  |  |  | Yes | 23 |  | Adult / Guardian
114263 |  |  |  |  |  |  | No | 23 |  | Adult / Guardian
114266 |  |  |  |  |  |  | No | 23 |  | Adult / Guardian
86 |  |  |  |  |  |  | No | 24 |  | Adult / Guardian
87 |  |  |  |  |  |  | No | 25 |  | Adult / Guardian
89 |  |  |  |  |  |  | No | 27 |  | Adult / Guardian
90 |  |  |  |  |  |  | Yes | 28 |  | Adult / Guardian
91 |  |  |  |  |  |  | No | 29 |  | Adult / Guardian
93 |  |  |  |  |  |  | No | 31 |  | Adult / Guardian
94 |  |  |  |  |  |  | Yes | 32 |  | Adult / Guardian
97 |  |  |  |  |  |  | Yes | 34 |  | Adult / Guardian
98 |  |  |  |  |  |  | No | 35 |  | Adult / Guardian
105 |  |  |  |  |  |  | No | 37 |  | Adult / Guardian
104 |  |  |  |  |  |  | Yes | 37 |  | Adult / Guardian
106 |  |  |  |  |  |  | No | 38 |  | Adult / Guardian
107 |  |  |  |  |  |  | No | 39 |  | Adult / Guardian
108 |  |  |  |  |  |  | No | 40 |  | Adult / Guardian
109 |  |  |  |  |  |  | Yes | 41 |  | Adult / Guardian
110 |  |  |  |  |  |  | No | 42 |  | Adult / Guardian
111 |  |  |  |  |  |  | No | 43 |  | Adult / Guardian
112 |  |  |  |  |  |  | No | 43 |  | Adult / Guardian
Spreadsheet: 143443d1330425209-referecing-worksheets-and-returning-areas-eol_checker_new_angusdn
Sheet: tsunami nfw

Consistency check
GLO: HP Printer final assembly (DfX)
 | Inputs | Outputs | Outputs - Inputs
Technical quantities
Mass [kg] | 33.6 | 33.6 | 0
1 Steel and iron materials
Steel and iron materials (unspecified) [kg] | 7.93e-05 | 7.93e-05 | 0
3 Nonferrous heavy metals, cast and wrought alloys
Nonferrous heavy metals, cast and wrought alloys (unspecified) [kg] | 0.00141 | 0.00141 | 0
5 Polymer materials
Plastics in packaging [kg] | 0.000593 | 0.000593 | 0
Polymer materials (unspecified) [kg] | 0.00684 | 0.00684 | 0
1.1 Steels / cast steel / sintered steel
Steels / cast steel / sintered steel (unspecified) [kg] | 0.00892 | 0.00892 | 0
3.1 Copper
Copper (unspecified) [kg] | 0.000185 | 0.000185 | 0
5.3 Elastomers / elastomeric compounds
Elastomers / elastomeric compounds (unspecified) [kg] | 3.08e-05 | 3.08e-05 | 0
5.5 Polymeric compounds
[NAME] compounds (unspecified) [kg] | 8.5e-05 | 8.5e-05 | 0
5.1b Thermoplaste unfilled
Thermoplaste unfilled (unspecified) [kg] | 0.00197 | 0.00197 | 0
5.4.1 Polyurethane
Polyurethane (unspecified) [kg] | 1.48e-07 | 1.48e-07 | 0
5.4.2 Unsaturated polyester
Unsaturated polyester (unspecified) [kg] | 3.63e-06 | 3.63e-06 | 0
7.1 Modified organic natural materials
Modified organic natural materials (unspecified) [kg] | 0.00133 | 0.00133 | 0
7.2 Ceramic / glass
Ceramic / glass (unspecified) [kg] | 1.62e-05 | 1.62e-05 | 0
8.1 Electronics
Electronics (unspecified) [kg] | 8.12e-05 | 8.12e-05 | 0
Material declaration electronics
Aluminum (E) [kg] | 1.28e-06 | 1.28e-06 | 0
Aluminum oxide (Al2O3) (E) [kg] | 5.28e-06 | 5.28e-06 | 0
Antimony oxide ([NAME] trioxide) (Sb2O3) (E) [kg] | 1.83e-07 | 1.83e-07 | 0
Copper (E) [kg] | 0.000392 | 0.000392 | 0
Copper in alloy (E) [kg] | 48 | 48 | 0
Electrolyte (E) [kg] | 1.94e-07 | 1.94e-07 | 0
[NAME] resin (E) [kg] | 1.27e-05 | 1.27e-05 | 0
Ferrites (E) [kg] | 2.61e-06 | 2.61e-06 | 0
Glas (E) [kg] | 5.32e-09 | 5.32e-09 | 0
Gold (E) [kg] | 1.78e-06 | 1.78e-06 | 0
Inorganic flame retardants (E) [kg] | 5.09e-10 | 5.09e-10 | 0
Natural rubber (NR) (E) [kg] | 5.07e-07 | 5.07e-07 | 0
Nickel (E) [kg] | 2.24e-07 | 2.24e-07 | 0
Palladium in alloy (E) [kg] | 1.26e-06 | 1.26e-06 | 0
Paper (E) [kg] | 3.75e-07 | 3.75e-07 | 0
Phenol-Formaldehyde-Resin (PF) (E) [kg] | 2.53e-07 | 2.53e-07 | 0
Polyamide 6 (PA6) (E) [kg] | 1.59e-06 | 1.59e-06 | 0
Polybutylene terephthalate (PBT) (E) [kg] | 2.57e-05 | 2.57e-05 | 0
Polyurethane (E) [kg] | 1.34e-06 | 1.34e-06 | 0
[NAME] chloride (PVC) (E) [kg] | 1.51e-07 | 1.51e-07 | 0
Silicon (E) [kg] | 4.8e-07 | 4.8e-07 | 0
Silicon dioxide (SiO2) (E) [kg] | 1.96e-05 | 1.96e-05 | 0
Silver (E) [kg] | 0.393 | 0.393 | 0
Silver in alloy (E) [kg] | 3.62e-08 | 3.62e-08 | 0
Tetrabromobisphenol A (TBBA) (E) [kg] | 1.55e-07 | 1.55e-07 | 0
Tin (E) [kg] | 3.17e-08 | 3.17e-08 | 0
Tin in alloy (E) [kg] | 3.59e-06 | 3.59e-06 | 0
Unalloyed steel (Fe-C) (E) [kg] | 5.56e-07 | 5.56e-07 | 0
4.4 Batteries
Battery (Li-ion) [kg] | 7.41e-06 | 7.41e-06 | 0
Spreadsheet: 487321d1478019692-formula-to-consolidate-tables-consolidatetables3
Sheet: Desired Result

DESIRED RESULT
 |  |  |  |  | [NAME] | Surname2 | [NAME] | ContactNo2 | Name3 | Surname3 | [NAME] | ContactNo3 | Name4 | Surname4 | [NAME] | ContactNo4 | Name5 | Surname5 | email5 | ContactNo5 | Name6 | Surname6 | email6 | ContactNo6
 | [NAME]
 | [NAME]
MAIL MERGE
A16
R60
69U
A9 was R6O - i.e. letter O rather than 0 - zero
Spreadsheet: 713302d1610641001-make-a-table-based-on-all-options-in-a-data-validation-drop-down-example
Sheet: Input

Company Revenue Risk: |  |  | Low |  |  |  | Total Rev £
Customer | Product | Units | Risk level | Month | Unit Price | Revenue | Included? | Calc Revenue
Smarts | Lemonade | 50 | Low | 2021-01-01 00:00:00 | 6
[NAME] | Prosecco | 20 | High | 2021-01-01 00:00:00 | 18
Hong | OJ | 100 | Medium | 2021-01-01 00:00:00 | 4
County | Cider | 25 | Low | 2021-01-01 00:00:00 | 12
George | Still Water | 60 | Low | 2021-01-01 00:00:00 | 2
Kings | Merlot | 15 | Low | 2021-01-01 00:00:00 | 15
Smarts | Prosecco | 85 | Low | 2021-02-01 00:00:00 | 18
[NAME] | Lemonade | 12 | High | 2021-02-01 00:00:00 | 6
Hong | Cider | 17 | Low | 2021-02-01 00:00:00 | 12
County | OJ | 12 | Medium | 2021-02-01 00:00:00 | 4
George | OJ | 96 | High | 2021-02-01 00:00:00 | 4
Kings | Still Water | 10 | Low | 2021-02-01 00:00:00 | 2
Smarts | Prosecco | 56 | Low | 2021-03-01 00:00:00 | 18
[NAME] | Merlot | 23 | Medium | 2021-03-01 00:00:00 | 15
Hong | Merlot | 19 | Low | 2021-03-01 00:00:00 | 15
County | Lemonade | 22 | Low | 2021-03-01 00:00:00 | 6
George | Lemonade | 45 | Low | 2021-03-01 00:00:00 | 6
Kings | OJ | 52 | High | 2021-03-01 00:00:00 | 4
Smarts | Prosecco | 30 | Low | 2021-04-01 00:00:00 | 18
[NAME] | Cider | 20 | High | 2021-04-01 00:00:00 | 12
Hong | Cider | 57 | Low | 2021-04-01 00:00:00 | 12
County | Still Water | 76 | Medium | 2021-04-01 00:00:00 | 2
George | Prosecco | 49 | Low | 2021-04-01 00:00:00 | 18
Kings | Still Water | 28 | High | 2021-04-01 00:00:00 | 2
Smarts | Merlot | 52 | Low | 2021-05-01 00:00:00 | 15
[NAME] | Lemonade | 16 | Medium | 2021-05-01 00:00:00 | 6
Hong | Merlot | 41 | Low | 2021-05-01 00:00:00 | 15
County | Still Water | 19 | High | 2021-05-01 00:00:00 | 2
George | Lemonade | 37 | High | 2021-05-01 00:00:00 | 6
Kings | Cider | 20 | Low | 2021-05-01 00:00:00 | 12
Smarts | Prosecco | 40 | Medium | 2021-06-01 00:00:00 | 18
[NAME] | Cider | 60 | High | 2021-06-01 00:00:00 | 12
Hong | Lemonade | 70 | Low | 2021-06-01 00:00:00 | 6
County | Still Water | 55 | Medium | 2021-06-01 00:00:00 | 2
George | Merlot | 16 | Medium | 2021-06-01 00:00:00 | 15
Kings | Prosecco | 8 | High | 2021-06-01 00:00:00 | 18
Spreadsheet: 754478d1636238601-create-7-dependent-dropdown-using-data-validation-based-on-multiple-dependent-columns-ef1555_filter_multiple_fields
Sheet: Output

 | Period | PMU | MCO | country | Division | category | brand
 | 202101 |  |  | DENMARK | All |  | DOVE
Match_row | Period | PMU | MCO | country | Division | category | brand
Spreadsheet: b1b210b4-636a-487e-8d36-4eff79507d5a
Sheet: Regatta Ships

Regatta 2013   Attendance | No. | Regatta ships
Ship | # | Bos'n | Skipper | M-crew | F-crew | M-Adult | F-Adult | Total | Contact
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
Crew 525
staff
 |  |  | Totals
Spreadsheet: 776319d1649686101-conditional-formating-based-on-cell-value-jeriss-dashboard
Sheet: OVERVIEW

YEAR | QUARTER | [NAME] |  |  |  |  |  | REVENUES TVAC |  |  |  |  | BANK BALANCE
 |  | RECEIVED | TO RECEIVE | CANCELED | TOTAL |  |  | RECEIVED | TO RECEIVE | CANCELED | TOTAL
2021 | ALL |  |  |  |  |  |  |  |  |  |  |  | 2572.06
2022 | ALL |  |  |  |  |  |  |  |  |  |  |  | ...
2023 | ALL |  |  |  |  |  |  |  |  |  |  |  | ...
2024 | ALL |  |  |  |  |  |  |  |  |  |  |  | ...
2025 | ALL |  |  |  |  |  |  |  |  |  |  |  | ...
 |  | REVENUS TOTAUX HTVA |  |  |  |  |  | REVENUS TOTAUX TVAC
 |  | ESTIMATION DES REVENUS TOTAUX HTVA FUTURS (SUR BASE DE LA MAINTENCE) |  |  |  |  |  | ESTIMATION DES REVENUS TOTAUX TVAC FUTURS (SUR BASE DE LA MAINTENCE)
Spreadsheet: 735417d1622972735-multiple-criteria-lookup-value-between-two-numbers-pipe-spec
Sheet: Sheet1

Spec | Size 1 | [NAME] | Material | Sch.
A3 | 2 | 11 | A333-6 | 80 |  |  | Spec | Size | Material
A3 | 12 | 26 | API-5L B | 40 |  |  | A3 | 8 | ??
AH3 | 2 | 11 | ASTM 1 | 20
AH3 | 12 | 26 | ASTM 2 | 40
Spreadsheet: 92745d1292307101-iteration-continuously-increases-after
Sheet: Week4

Week | Day | Date | Winner/tie | PtsW |  | [NAME]/tie | PtsL
4 | Sun | 2010-10-03 00:00:00 | New York Giants | 17 |  | Chicago Bears | 3
4 | Sun | 2010-10-03 00:00:00 | San Diego Chargers | 41 |  | Arizona Cardinals | 10
4 | Sun | 2010-10-03 00:00:00 | Baltimore Ravens | 17 | @ | Pittsburgh Steelers | 14
4 | Sun | 2010-10-03 00:00:00 | Houston Texans | 31 | @ | Oakland Raiders | 24
4 | Sun | 2010-10-03 00:00:00 | New York Jets | 38 | @ | Buffalo Bills | 14
4 | Sun | 2010-10-03 00:00:00 | Atlanta Falcons | 16 |  | San Francisco 49ers | 14
4 | Sun | 2010-10-03 00:00:00 | Green Bay Packers | 28 |  | Detroit Lions | 26
4 | Sun | 2010-10-03 00:00:00 | Denver Broncos | 26 | @ | Tennessee Titans | 20
4 | Sun | 2010-10-03 00:00:00 | St. Louis Rams | 20 |  | [NAME] | 3
4 | Sun | 2010-10-03 00:00:00 | New Orleans Saints | 16 |  | Carolina Panthers | 14
4 | Sun | 2010-10-03 00:00:00 | [NAME] | 23 |  | Cincinnati Bengals | 20
4 | Sun | 2010-10-03 00:00:00 | [NAME] | 31 |  | Indianapolis Colts | 28
4 | Sun | 2010-10-03 00:00:00 | Washington Redskins | 17 | @ | Philadelphia Eagles | 12
4 | Mon | 2010-10-04 00:00:00 | New England Patriots | 41 | @ | [NAME] | 14
Spreadsheet: 55746d1255952582-how-do-i-work-out-compound-interest-compint
Sheet: Sheet1

Invested | 175000
IR | 0.1571
Year 1 | 202492.5
Year 2 | 234304.07175
Year 3 | 271113.241421925
Year 4 | 313705.1316493094
Year 5 | 362988.2078314159
Year 6 | 420013.6552817314
Year 7 | 485997.8005264914
Year 8 | 562348.0549892031
Year 9 | 650692.9344280069
Year 10 | 752916.7944266468
 | 4.302381682437981
Spreadsheet: jeff_dasovich__14083__ENRON2
Sheet:  PG&E Scenarios

[NAME]
RESOURCE TYPE | ELECTRICITY GENERATION (GWH) | REVENUE REQUIREMENT ($ MILLIONS) | AVERAGE COST ($/MWH)
QF | 21000 |  | 80
Fossil | 1500 |  | 113
Hydro | 12700
[NAME] | 17000 |  | 35
Other Purchases | 8300 |  | 42
SUBTOTAL UTILITY GENERATION
CDWR Purchases |  |  | 80
TOTAL GENERATION
Ancillary Services Uplift |  |  | 10
Fully Loaded Procurement Costs at Generation
Fully Loaded Procurement Costs at Meter
Generation Component in Retail Rates |  |  | 70
Necessary Rate Increase (Decrease)
Retail Sales at Meter | 82300
Retail Sales at Generation
WAPA & CCSF Sales @ Generation
TOTAL SYSTEM LOAD
Utility Generation
NET SHORT
DRY
RESOURCE TYPE | ELECTRICITY GENERATION (GWH) | REVENUE REQUIREMENT ($ MILLIONS) | AVERAGE COST ($/MWH)
QF | 21000 |  | 80
Fossil | 1500 |  | 113
Hydro | 7900
[NAME] | 17000
Other Purchases | 8300 |  | 42
SUBTOTAL UTILITY GENERATION
CDWR Purchases |  |  | 80
TOTAL GENERATION
Ancillary Services Uplift |  |  | 10
Fully Loaded Procurement Costs at Generation
Fully Loaded Procurement Costs at Meter
Generation Component in Retail Rates |  |  | 70
Necessary Rate Increase (Decrease)
Retail Sales at Meter | 82300
Retail Sales at Generation
WAPA & CCSF Sales @ Generation
TOTAL SYSTEM LOAD
Utility Generation
NET SHORT
WET
RESOURCE TYPE | ELECTRICITY GENERATION (GWH) | REVENUE REQUIREMENT ($ MILLIONS) | AVERAGE COST ($/MWH)
QF | 21000 |  | 80
Fossil | 1500 |  | 113
Hydro | 15450
[NAME] | 17000 |  | 35
Other Purchases | 8300 |  | 42
SUBTOTAL UTILITY GENERATION
CDWR Purchases |  |  | 80
TOTAL GENERATION
Ancillary Services Uplift |  |  | 10
Fully Loaded Procurement Costs at Generation
Fully Loaded Procurement Costs at Meter
Generation Component in Retail Rates |  |  | 70
Necessary Rate Increase (Decrease)
Retail Sales at Meter | 82300
Retail Sales at Generation
WAPA & CCSF Sales @ Generation
TOTAL SYSTEM LOAD
Utility Generation
NET SHORT