tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: robin_rodrigue__33345__Canada Power Positions_Jun19
Sheet: H-rate_model

Section I  - Heat Rate Offer
(originator pays the floating heat rate and receives the pool)
Inputs |  |  |  |  | Outputs
Deal Volume per hour | 25 |  |  |  | Implied Fixed Price Offer
Total deal volume - MWh
Heat Rate offer | 9.66 |  |  |  | AECO Index Price ("actual") | 2
Term | F | (Peak or Flat) |  |  | Pool Price ("actual") | 24
AECO Bid | 4.995 | (Fixed for floating swap) |  |  | Profit (PV)
Power Offer | 48.25
Implied Heat Rate bid
Hedge Gas Volume |  | (GJ)
Days
Gas Volume
MWh per GJ
Gas Price
First Month | 2000-10-01 00:00:00
Last Month | 2000-10-01 00:00:00
Months
 |  |  |  |  |  | "Originator Economics"
 |  |  |  |  |  | [NAME] | Gas Swap | Power Swap
Month | Discount Factor | Hours | MWh | Days |  | (heat rate less pool) | (fixed less aeco) | (Pool less fixed) |  | Profit | Profit - PV
Section II  - Heat Rate Bid
(originator receives the pool and pays the floating heat rate)
Inputs |  |  |  |  | Outputs
Deal Volume per hour | 25 |  |  |  | Implied Fixed Price Bid
Total deal volume - MWh
Heat Rate Bid | 19 |  |  |  | AECO Index Price ("actual") | 2
Term | P | (Peak or Flat) |  |  | Pool Price ("actual") | 255
AECO Offer | 3.07 | (Fixed for floating swap) |  |  | Profit (PV)
Power Bid | 60
Implied Heat Rate Sale
Hedge Gas Volume |  | (GJ)
Days
Gas Volume
First Month | 2000-03-01 00:00:00
Last Month | 2000-03-01 00:00:00
Months
 |  |  |  |  |  | "Originator Economics"
 |  |  |  |  |  | [NAME] | Gas Swap | Power Swap
Month | Discount Factor | Hours | MWh | Days |  | (pool less heat rate) | (aeco less fixed) | (fixed less pool) |  | Profit | Profit - PV | Profit Chk
Spreadsheet: 540097d1506529523-filtering-column-with-combinations-of-values-khw1
Sheet: Sheet1

Name | Team | Skills |  |  | Filter skill: | Jkl | Filtered: | Name | Team | Skills
[NAME] | AAA | Abc, [NAME], Ghi
[NAME] | BBB | Abc, Ghi, Jkl
[NAME] | AAA | Ghi, Jkl, Def
[NAME] | BBB | Def, Mno, Abc
Spreadsheet: 675033d1588110957-extract-data-from-column-seprate
Sheet: Sheet1

aaaaa | Name | Phone | [NAME]
Column1 | [NAME] | [PHONE] | [EMAIL]
[NAME] #: [EMAIL]
[NAME] YangDRE #: [EMAIL]
[NAME] PerkinsDRE #: [EMAIL]
Rachel KahnDRE #: [EMAIL]
Felicia DaffaraDRE #: [EMAIL]
[NAME] #: [EMAIL]
[NAME] MetcalfDRE #: [EMAIL]
[NAME] #: [EMAIL]
[NAME] ZeusDRE #: [EMAIL]
[NAME] #: [EMAIL]
Gershom HyldrethDRE #: [EMAIL]
Oren ZroyaDRE #: [EMAIL]
Troy GregoryDRE #: [EMAIL]
[NAME] #: [EMAIL]
[NAME] #: [EMAIL]
Valeria MartinezDRE #: [EMAIL]
Christian StillmarkDRE #: [EMAIL]
[NAME] #: [EMAIL]
[NAME] BarhoumDRE #: [EMAIL]
Kimberly KovacDRE #: [EMAIL]
[NAME] #: [EMAIL]
Suzi FarajianiDRE #: [EMAIL]
Ramiah ThomasDRE #: [EMAIL]
Scott JamesDRE #: [EMAIL]
[NAME] #: [EMAIL]
Spreadsheet: 153173d1335791090-finding-and-summing-an-entry-once-book1
Sheet: Sheet1

1 | 00001 | 8743.3 |  |  |  |  |  | 00001 | 17486.6
2 | 00001 | 8743.3
3 | 00002 | 4720 |  |  |  |  |  | 00002 | 4720
4 | 00003 | 1197 |  |  |  |  |  | 00003 | 1197
5 | 00004 | 100 |  |  |  |  |  | 00004 | 100
6 | 00005 | 1398 |  |  |  |  |  | 00005 | 1398
7 | 00006 | 45282 |  |  |  |  |  | 00006 | 45282
8 | 00007 | 906 |  |  |  |  |  | 00007 | 906
9 | 00008 | 144458 |  |  |  |  |  | 00008 | 144458
10 | 00009 | 6416 |  |  |  |  |  | 00009 | 6416
11 | 00010 | 11655 |  |  |  |  |  | 00010 | 23310
12 | 00010 | 11655
13 | 00011 | 27662 |  |  |  |  |  | 00011 | 27662
14 | 00012 | 1920 |  |  |  |  |  | 00012 | 1920
15 | 00013 | 96 |  |  |  |  |  | 00013 | 96
16 | 00014 | 2706.75 |  |  |  |  |  | 00014 | 21654
17 | 00014 | 5413.5
18 | 00014 | 13533.75
19 | 00015 | 1411.5 |  |  |  |  |  | 00015 | 21840
20 | 00015 | 10920
21 | 00015 | 7280
22 | 00015 | 2228.5
23 | 00018 | 3528 |  |  |  |  |  | 00018 | 3528
Spreadsheet: 480085d1473771900-sumifs-for-2-variables-horizontal-and-vertical-ytd-sales-test-sumifs-2-variable-ytd-sales
Sheet: Sheet1

 | [NAME] | Amsterdam | Utrecht | Amersfoort | [NAME] | Eindhoven | Groningen | Alkmaar | Tilburg |  | Drop Down Selection - Title | Drop Down Selection - Shop
 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |  | Rainbow Six Siege | Amersfoort
Rainbow Six Siege | 6411953 | 5184521 | 6105169.715000001 | 6137453 | 5277737.281 | 6211940 | 5755269.152000001 | 5603742.016 | 6078502
The Division | 423866 | 333003 | 287719.525 | 365071 | 320644.873 | 286906.127 | 276896.729 | 278836 | 254238.251
Rainbow Six Siege | 6835819 | 5517524 | 6392889.240000001 | 6502524 | 5598382.154 | 6498846.127 | 6032165.881000001 | 5882578.016 | 6332740.251 |  | FYTD By Shop Through Drop Down Menus
The Division | 575972 | 413527 | 542972.376 | 533440 | 432906.252 | 523881 | 488677.842 | 431829.189 | 503602
Far Cry 4 | 575972 | 413527 | 542972.376 | 533440 | 432906.252 | 523881 | 488677.842 | 431829.189 | 503602
Far Cry 4 | 2085354 | 1689665 | 1989375.528 | 1893009 | 1704946.849 | 1995417 | 1577378 | 1797417.02 | 1890125
Watch Dogs 2
Spreadsheet: 856422d1705666984-using-excel-as-identification-page-paints-and-pigments
Sheet: Sheet1

 | A.MIG-3001 Pigment Black | A.MIG-3002 Pigment Light Dust | A.MIG-3003 Pigment North  Africa Dust | A.MIG-3004 Pigment Europe Earth | A.MIG-3005 Pigment Medium Rust | A.MIG-3006 Pigment Light  Rust | A.MIG-3007 Pigment Dark  Earth | A.MIG-3008 Pigment Track  Rust | A.MIG-3009 Pigment Gun Metal | A.MIG-3010 Pigment Concrete | A.MIG-3011 Pigment [NAME]  Dust | A.MIG-3012 Pigment Sand
 | A.MIG-3013 Pigment Rubble | A.MIG-3014 Pigment Russian Earth | A.MIG-3015 Pigment Brick  Dust | A.MIG-3016 Pigment White | A.MIG-3017 Pigment Primer  Red | A.MIG-3018 Pigment Middle East Dust | A.MIG-3019 Pigment Army  Green | A.MIG-3020 Pigment Metal Slag | A.MIG-3021 Pigment Polished Metal | A.MIG-3022 Pigment Vietnam Earth | A.MIG-3023 Pigment Sinai Dust | A.MIG-3024 Pigment Negev  Sand
 | A.MIG-3025 Pigment Syrian Ground | A.MIG-3026 Pigment Golan  Earth | A.MIG-3027 Pigment Farm Dark Earth | A.MIG-3028 Pigment City Dark Dust | A.MIG-3029 Pigment Winter Soil | A.MIG-3030 Pigment Factory [NAME] | A.MIG-2251 U-Rust Deep Oxide | A.MIG-2252 U-Rust Black Oxide Transparent | A.MIG-2253 U-Rust Black Oxide | A.MIG-2254 U-Rust Rust Oxide Patina | A.MIG-2255 U-Rust Copper Blue Patina | A.MIG-2256 U-Rust Oxide Grime
 | A.MIG-1000 [NAME] for German Dark Yellow | A.MIG-1001 [NAME] | A.MIG-1002 [NAME] | A.MIG-1003 Interiors Wash | A.MIG-1004 Light Rust Wash | A.MIG-1005 [NAME] for Green Vehicles | A.MIG-1006 [NAME] for Panzer Grey | A.MIG-1007 US Modern [NAME] | A.MIG-1008 [NAME] | A.MIG-1009 [NAME] | A.MIG-1010 Neutral Wash | A.MIG-1011 Black Wash
 | Muds
 | Streaking
Spreadsheet: sally_beck__35761__MgmtSum-Q1-0320
Sheet: Expenses

PLAN2000
TOT_OPS_EXPENSES | ENRON NORTH AMERICA
2000-03-01 00:00:00 | 1ST QUARTER 2000 EXPENSES
M.QTD
ENA |  |  | Direct Expenses
 | Business Team |  | Forecast | Plan | [NAME] |  | [NAME]
[NAME] | Gas Trading |  |  |  |  |  | Compensation increases related to promotions; Headcount over plan;AA allocations
[NAME] | Power Trading |  |  |  |  |  | Compensation increases, Employee expenses over plan, and Peace consulting fees
IR_FX | Financial Drift |  | 846 |  |  |  | London expenses deferred from 4Q99;Unplanned for relocation,consulting,computer costs
ECT_INV_IRFX | Financial Trading
CANADA | Canada |  | 3306
COAL | Coal |  |  |  |  |  | London expenses deferred from 4Q99; 2 Directors promoted to VP; Current qtr FX loss
WEATHER | Weather |  | 2233 |  |  |  | London expenses deferred from 4Q99 & current quarter FX loss;$1MM for consulting fees
SO2 | Emissions |  | 104
INSURANCE | Insurance Group |  | 1181
EXEC_TRD | Executive Trading
 | Total Trading & Risk Management
E_ORG | East Midstream
W_ORIG | West Midstream
PAPER | Industrial Downstream - Paper
CHEMICALS | Industrial Downstream - Chemicals
MDSTRM_IPP_ORIG | Midstream IPP
MEXICO | Mexico |  | 1466
EXEC_ORIG | Executive Origination
 | Total Origination
GENCOS | Genco
N_BS_DEV | Generation Investments |  | 1019 |  |  |  | Special pay in January
ASST_ORIG | Gas Assets |  | 4210
ASST_TRD | Gas Assets - Trading |  | 598
 | Total Assets
EQUITY | Principal Investing |  | 783
PROD_FIN | Energy Investments |  | 1742 |  |  |  | Special pay
ENVR_ENGY | Investment Management |  | 426
RESTRUCTURING | Restructuring |  | 395
FIN | Canada - Investing
 | Total Investing
CTG | Commercial Transactions Group |  | 5988
OF_CHAIR | Office of the Chairman |  |  |  |  |  | RC 2948 - Enron Online related expenses
 | Total Commercial
GROUP | Group |  |  |  |  |  | Compensation issues
TREASURY_INT | Other Interest Related Charges |  | 23347
 | Total
 |  |  | Operating Expenses
 | Business Team |  | Forecast | Plan | [NAME] |  | [NAME]
 | Genco |  | 7034 | 6605
 | Gas Assets |  | 38783
Spreadsheet: 715469d1611724612-sum-n-count-of-values-in-rows-sum-first-5-numbers
Sheet: Sheet1

Column 1 | Column 2 | Column 3 | Column 4 | Column 5 | Column 6 | Column 7 | Column 8 | Column 9 | Column 10 | Column 11 | Column 12 | Column 13 | Column 14 | Column 15 | Column 16 | Column 17 | Column 18 | Column 19 | Column 20 | If only value in range | With text, string in range
1 |  | 2 | a | 5 |  | 8 | 8 | 7 | 8 |  | 5 |  |  | 6 |  | 5 |  | 8 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 1 | 1 |  | 7
 |  | 8 |  |  |  | 2 | 8 |  | 3 |  | 3 |  | 7 |  |  | 9 |  | 4
5 |  |  | 8 | 7 | 8 |  | 5 | 5 |  |  | 8 | 7 | 8 |  | 5
 | 7 | 8 |  | 2 | 2 | 2 |  |  | 7 |  |  | 2 | 2 | 2 |  |  | 5 | 5
 |  | 2 | 8 |  | 3 |  | 3 |  |  | 2 | 8 |  | 3 |  | 3 | 2 |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  | 8 | 7 | 8 |  | 5
 |  |  |  |  | 7 | 8 |  | 2 | 2 | 2 |  |  | 8
 |  |  |  |  |  | 2 | 8 |  |  |  | 3 |  | 2 | 2 | 8 |  | 5 | 5
 |  |  |  |  | 5 |  | 8 | 8 |  | 8 |  | 5 | 3 |  | 2 | 2 |  |  | 7
 |  |  |  |  | 5 |  |  | 8 | 7 | 8 |  | 5 |  |  | 3 |  | 3
 |  |  |  |  |  | 7 | 8 |  | 2 | 2 | 2 |  | 8
 |  |  |  |  |  |  | 2 | 8 |  | 3 |  | 3 | 2 | 2 | 8 |  | 5 | 5
 |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  | 2 | 2 |  |  | 7
5 |  | 8 | 8 | 7 |  |  |  |  |  |  |  |  |  |  | 3 |  | 3
 | 7 |  |  | 2
Spreadsheet: 08172964-84f9-4cec-8ed6-dd8dc6c970ca
Sheet: 3ED

3ED RANKING OUT OF 66
ANON# | RANK
4058 | 6
4730 | 7
6208 | 12
6221 | 9
6338 | 15
6853 | 4
7385 | 3
23322 | 2
23568 | 10
23608 | 17
46148 | 13
69420 | 16
75955 | 5
76482 | 1
82694 | 14
99106 | 11
99610 | 8
Spreadsheet: 759448d1639557906-row-cell-reference-unchanged-when-dragging-formulas-across-to-the-next-column-example
Sheet: Sheet4

 |  |  |  |  |  |  |  | Jan | Feb | Mar | Apr | May
 | Data
 | Jan | Asset | 5000 |  |  |  | Asset
 | Jan | Liability | 5000
 | Jan | Equity | 5000 |  |  |  | Liability
 | Feb | Asset | 10000
 | Deb | Liability | 10000 |  |  |  | Equity
 | Feb | Equity | 10000
 | Mar | Asset | 15000
 | Mar | Liability | 15000
 | Mar | Equity | 15000
Spreadsheet: 868971d1715675746-sumif-_conditioned-of-performance-sumif_cond_values-of-specs-sent-in-each-group_percentagewise_brauns
Sheet: new request

Group | Members | Specification  Sent / No | Value, €
Group5 | Jan | yes | 2
Group2 | [NAME] | yes | 112
Group3 | Volker | 0 | 1
Group2 | Maria | 0 | 1
Group1 | [NAME] | 0 | 25
Group2 | [NAME] | yes | 50
Group3 | [NAME] | 0 | 60
Group4 | Katha | yes | 75
Group3 | [NAME] | yes | 15
Group4 | Holger | 0 | 12
Group1 | Anto | yes | 250
Group4 | Bernd | 0 | 4
Group3 | [NAME] | 0 | 85 |  | Amont of groups, in which specs "sent" are exceeding 50% with their value the total  specs value of the group
Group5 | Anna | yes | 60 |  | "3" | expected result
Group5 | Caroline | 0 | 20
Group1 | Alla | 0 | 75
Group2 | [NAME] | 0 | 38
Group3 | [NAME] | 0 | 42
Group3 | Tizian | yes | 120
Group4 | Vitus | 0 | 250
Group4 | Niklas | yes | 10
Group4 | [NAME] | yes | 100
Group1 | Xavier | 0 | 0 | Challenge:
Group1 | Oxana | 0 | 4 | -count amount of Groups (not members) which have SENT out a specification (column "C"=yes), however only THEN, when the total money value (within this particular group) of specificaitons [NAME] are equal or exceeding 50% of the total specification's VALUE (column "D") of this particular group.
Group5 | Cam | 0 | 90 | -Example on "Group 3": total specifications "sent" - 135€ out of 323€ of the whole group. Since it equals to LESS than 50% (135/323), => "Group 3" should not be counted for the final result.
Group5 | Uzay | 0 | 10 | - please in case if there are no entries in columns "Specification" and "Value, €", the result should be Zero , and not "1".
Group5 | Atakan | yes | 180
Group2 | [NAME] | yes | 300
Group6 | Vasja | 0 | 0 | PS  - Members are not important for this logic, names entries are just put for demo reasons
Group6 | Petja | 0 | 0
Group6 | Asja | 0 | 0
Spreadsheet: 1f0eb430-bd75-43cb-8a11-7012b917e267
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Child Care Provider Line of Credit Calculation
Contract Data |  |  | Children Served Aug2010
Number | Service Period | Amount | 0 to 5 | Total
[NAME] | 7.1.10 to 6.30.11 | 2162095 | 183 | 419
XXXX-8040 | 7.1.10 to 6.30.11 | 3900000 | 330 | 619
XXXX-8040 | 7.1.10 to 6.30.11 | 3849187 | 164 | 559
XXXX-8217 | 7.1.10 to 6.30.11 | 3153202 | 234 | 234
XXXX-8012 | 7.1.10 to 6.30.11 | 144710 | 35 | 35
Total for annual contract |  | 13209194 | 946 | 1866
Maximum at | 0.7 | 9246435.8
Contract amount per month |  | 770536.32
For # of months: | 3 | 2311608.96
0 to 5 Percent of Children Served |  | 0.51
Calculated Loan Amount for 0 to 5 age group percent |  | 1178920.57
Round to: |  | 1500000
Amount for the CD - Bank will loan up to approx 95% of the CD amt. | 0.95 | 1578947
Round to: |  | 1580000
Spreadsheet: 692662d1598488105-if-statement-with-multi-criteria-statement-inside-a-data-validation-list-stock-inventory-control-sample
Sheet: Sheet 2

 | ITEM NAME | [NAME] | DATE STOCK IN | QUANTITY IN |  | ITEM NAME | TRUE/FALSE if Less Than 5 | TOTAL QUANTITY IN | BALANCE TAKEN | STOCK QUANTITY LEFT | REORDER LEVEL | REORDER (auto-fill)
 | Item 1 |  |  | 10 |  | Item 1
 | Item 2 |  |  | 5 |  | Item 2
 | Item 3 |  |  | 8 |  | Item 3
 | Item 4 |  |  | 0 |  | Item 4
 | Item 5 |  |  | 7 |  | Item 5
 | Item 6 |  |  | 2 |  | Item 6
Spreadsheet: 0d3e9229-554f-400b-9425-ce9d9014a590
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
6709 | 31471 | [NAME] | Brea | VEN | 78 | 00:20:40 | 00:00:31 | 00:35:34 | 00:00:24 | 00:06:18 | 1 | [NAME]
6709 | 39568 | [NAME] | Ducreux | PAN | 81 | 00:25:28 | 00:00:49 | 00:38:55 | 00:00:49 | 00:10:25 | 2 | 01:16:29
6709 | 29298 | [NAME] | Licona | PAN | 82 | 00:28:46 | 00:01:03 | 00:35:44 | 00:00:57 | 00:11:52 | 3 | 01:18:23
6709 | 39567 | [NAME] | Concepcion | PAN | 79 | 00:31:16 | 00:00:49 | 00:36:32 | 00:01:08 | 00:15:57 | 4 | 01:25:45
Spreadsheet: 376605d1423661659-assistance-in-linking-cells-into-several-worksheet-full-price-list-sample
Sheet: ATLANTIC

Address : 60 Benoi Road F2 #02-11, SINGAPORE (629906)
Telephone : (65) 6265 8662            Fax : (65) 6265 7616
E-mail : [EMAIL]                 GST Reg No. 200708233N
No | IMPA No | ITEM | [NAME] | UNIT | ATLANTIC | Remark
Spreadsheet: 75600d1276142056-excel-2007-autofill-not-recognizing-a-pattern-correctly-excelproble
Sheet: Sheet3

 | This sheet just contains some data. Every third row contains numerical data, and the rest are textual data. The number of cells in each row that contain data can potentially be a very large (limitless) number.
I have | some | textual | data | in this | row.
and | some | more | in | this | row.
1
I have | some | textual | data | in this | row.
and | some | more | in | this | row.
1 | 2
I have | some | textual | data | in this | row.
and | some | more | in | this | row.
1 | 2 | 3
I have | some | textual | data | in this | row.
and | some | more | in | this | row.
1 | 2 | 3 | 4
I have | some | textual | data | in this | row.
and | some | more | in | this | row.
1 | 2 | 3 | 4 | 5
I have | some | textual | data | in this | row.
and | some | more | in | this | row.
1 | 2 | 3 | 4 | 5 | 6
I have | some | textual | data | in this | row.
and | some | more | in | this | row.
1 | 2 | 3 | 4 | 5 | 6 | 7
I have | some | textual | data | in this | row.
and | some | more | in | this | row.
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
Spreadsheet: 267208d1380012832-vlookup-function-0a215_a
Sheet: Wenn, Stuart

Wenn, [NAME]
Umpire | Player | Team | Position | Votes | Team Margin | K | H | D | CP | UP | DE% | CLG | M | CM | M50 | HO | CLR | CC | ST | R50 | FF | FA | T | 0.01 | Bo | [NAME] | G | B | GA | G% | TG% | DT
Spreadsheet: 1531e40b-e4bd-41fd-a801-9f2afa9df128
Sheet: Sheet1

Vertical [NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | 35951
A | B | C | D | E | F
Point | Point | z | z
number | description | (independent) | (test) | diff in z | (diff in [NAME]
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | sum | 0
 |  |  |  | average
 |  |  |  | RMSE
 |  |  |  | NSSDA
Spreadsheet: 838320d1690915112-comparing-two-sheets-looking-for-matches-rebate-example
Sheet: Sheet1

model
ASZC703610
AMST36CU1400AA
ASZH504810AA
amvc800804cn
asxs6s4210
AM9S800403AX
RX24RMVJUA
AM9S960803BN
GSX130301LC
GSX160181
GSXN403610
ASXH503010
AM9S800603AXAA
amvc960403bn
amvc960803bn
ASXH502410AA
AM9S800403AX
[NAME]
ASZH403610
AMST36CU1400
[NAME]
ASZS602410AA
CHPE2430B4AB
AMVC800603BNAD
Avpec25b14
[NAME]
ASZC160361
AMVC960603BN
AMST24BU1400
GSZH504210
AMST42CU1400
AM9S800805CU
ASXH406010
ASXH3N1810
ASZC703610
GM9S800603
ASXH504810AA
ASXH402410
AM9S800603BN
ASXH3N3010
ASX14031
AM9S800403AX
CAPTA3022A4
DM80VC0804CN
[NAME]
DZ17VSA241BA
ASXH503010
AM9S800603BN
AM9S800603BN
ASXH503010
gsxn403610
gm9s800804bn
Dm96tn1004cn
[NAME]
Dx17vss361ba
GSXB403010AA
GPH1630M41AB
GSXB404810AA
ASXH503610AA
AMVC960603BN
Dm96sn0603bn
GSZB403610AA
GSX130301LC
AMST24BU1400AA
GSZB402410AA
GSXN404810AA
Spreadsheet: 36356d1234250464-formula-that-returns-the-contents-of-every-fourth-row-except-when-that-row-is-empty-andysurtees
Sheet: Sheet1

Number | First Name | Last Name | Account | Status | Amount | Credit Card Number | [NAME] | [NAME] | Lead Source | Date | Memo | Shipping Address 1 | Shipping Address 2 | Shipping City | Shipping State/Province | [NAME] | Item
SO1000 | [NAME] | Doe | Sales Orders | Pending Fulfillment | 139.9 | 1234123412341234 | 06/10 | J Doe | CP1000 | 2009-01-30 00:00:00 | top doorbell | 15 Yemen Road |  | Yemen | Yemen | 3037
SO1000 | [NAME] | Doe | 4000 Sales | Pending Fulfillment | 118.14 | 1234123412341234 | 06/10 | J Doe | CP1000 | 2009-01-30 00:00:00 | ADD POSTAGE @ $9.95 | 15 Yemen Road |  | Yemen | Yemen | 3037 | Light kit
SO1000 | [NAME] | Doe | 4000 Sales | Pending Fulfillment | 9.05 | 1234123412341234 | 06/10 | J Doe | CP1000 | 2009-01-30 00:00:00 |  | 15 Yemen Road |  | Yemen | Yemen | 3037 | Postage, Standard
SO1000 |  |  | GST Collected | Pending Fulfillment | 12.71 |  |  |  | CP1000 | 2009-01-30 00:00:00 | Tax | 15 Yemen Road |  | Yemen | Yemen | 3037 | TS-AU
next2
next3
next4
next5
Spreadsheet: 774581d1648556036-sum-formula-with-condition-excel-formula
Sheet: Sheet1

 | Country | Country weight |  | Country to select | Country weight
 | Canada | 0.5 |  | Canada
 | Cape Verde | 0.5 |  | China
 | Cayman Islands | 0.5 |  | Chad
 | Chad | 1
 | Chile | 1 |  | Sum
 | China | 1.5
 | Colombia | 1.5
Spreadsheet: 735791d1623176459-sumif-function-skipping-1-column-book1
Sheet: Overview

Date | Name | Product 1 | Product 2 | Product 3 | Product 4 | Product 5
2021-01-01 00:00:00 | [NAME]
 | [NAME]
 | Lewis
Spreadsheet: 863592d1711017864-calculating-weighted-averages-slightly-differently-daily-completion2-1-
Sheet: BASIC

 | Activity | % Complete | Weight | Normalized  Weight | Weighted Score
 | physical | 100 | -5
 | emotional | 0 | 0
 | financial | 50 | 0
 | professional | 0 | 3
 |  | Daily score
Spreadsheet: 0e7aa726-28e2-48ad-ab4b-a858d2219961
Sheet: Sheet1

Table 4--U.S. fiber demand | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Dec. | Jan. | Feb. |  | Feb.
Item | 2013 | 2014 | 2014 |  | 2013
 | 1,000 480-lb. [NAME]
Cotton:
All consumed by mills 1/ | 244 | 291 | 269 |  | 281
Total since August 1 | 1471 | 1762 | 2031 |  | 1976
Daily rate | 11.1 | 12.7 | 13.4 |  | 14.1
Upland consumed by mills 1/ | 242 | 290 | 267 | 267 | 280
Total since August 1 | 1463 | 1753 | 2020 |  | 1967
Daily rate | 11 | 12.6 | 13.4 |  | 14
Upland exports | 741 | 1261 | 1331 |  | 1733
Total since August 1 | 2914 | 4175 | 5506 |  | 6604
Sales for next season | 59 | 169 | 378 |  | 368
Total since August 1 | 310 | 478 | 856 |  | 977
Extra-long staple exports | 65.5 | 80.9 | 67.6 |  | 66
Total since August 1 | 286.2 | 367.1 | 434.7 |  | 434.1
Sales for next season | 0 | 2.6 | 3 |  | 35.3
Total since August 1 | 0 | 2.6 | 5.6 |  | 39.8
 | Nov. | Dec. | Jan. |  | Jan.
 | 2013 | 2013 | 2014 |  | 2013
 | Million pounds
Manmade:
Raw fiber exports | 46 | 43.2 | 49.3 |  | 51.8
Noncellulosic | 45.3 | 42.7 | 48.5 |  | 51.3
Cellulosic | 0.7 | 0.5 | 0.8 |  | 0.5
Total since January 1 | 592.3 | 635.5 | 49.3 |  | 51.8
Total since January 1
 | 1,000 pounds
Wool and mohair:
Raw wool exports, clean | 694.1 | 698.8 | 671.7 |  | 665.2
Total since January 1 | 9298.7 | 9997.4 | 671.7 |  | 665.2
Wool top exports | 131.9 | 68.8 | 167.3 |  | 232.8
Total since January 1 | 2022.4 | 2091.2 | 167.3 |  | 232.8
Mohair exports, clean | 29.5 | 29.6 | 31.2 |  | 1.7
Total since January 1 | 714.6 | 744.2 | 31.2 |  | 1.7
1/  Estimated by USDA.
Sources: USDA, Farm Service Agency; USDA, Foreign Agricultural Service,
U.S. Export Sales; U.S. Dept. of Commerce, U.S. Census Bureau;
and [NAME].
Last update: 4/11/14.
Spreadsheet: 669554d1585459277-using-another-sheet-like-function-1
Sheet: Sheet 1

a | b | c | d | e | f | g | Result
10 | 19 | 616 | 456 | 654 | 984 | 209 | ? | See sheet 2
16 | 8 | 1535 | 615 | 6 | 65 | 684 | ?
1 | 79 | 654 | 61 | 5146 | 6 | 548 | ?
1 | 798 | 651 | 494 | 56 | 15 | 108 | ?
51 | 598 | 14 | 44 | 4 | 9 | 552 | ?
10 | 514 | 984 | 8 | 649 | 49 | 173 | ?
4 | 5166 | 984 | 646 | 489 | 4 | 651 | ?
4 | 91 | 984 | 511 | 4 | 516 | 88 | ?
89 | 89 | 98 | 6 | 1 | 19 | 44 | ?
4984 | 897 | 11 | 98 | 9 | 849 | 251 | ?
981 | 978 | 984 | 41 | 6 | 49 | 528 | ?
998 | 789 | 87 | 6 | 94 | 4 | 508 | ?
1 | 98 | 45 | 51 | 9 | 149 | 779 | ?
9 | 489 | 65 | 98 | 94 | 4 | 730 | ?
1 | 98 | 9874 | 4 | 2 | 984 | 898 | ?
Spreadsheet: 151399d1334888420-find-duplicates-and-place-in-a-single-row-names-and-groups
Sheet: Sheet1

Name | Groups
Person A | Group X
Person A | Group Y
Person A | Group Z
Person B | Group X
Person C | Group Z
Person D | Group X
Person D | Group Z
I want it to finish up like this v
Person A | Group X | Group Y | Group Z
Person B | Group X
Person C | Group Z
Person D | Group X | Group Z
Spreadsheet: benjamin_rogers__971__Peoples Bid Responses MTM
Sheet: NYMEX Settlements

 | 2002-03-01 00:00:00 | 2002-04-01 00:00:00 | 2002-05-01 00:00:00 | 2002-06-01 00:00:00 | 2002-07-01 00:00:00 | 2002-08-01 00:00:00 | 2002-09-01 00:00:00 | 2002-10-01 00:00:00
2002-03-15 00:00:00
2002-03-14 00:00:00
2002-03-13 00:00:00
2002-03-12 00:00:00
2002-03-11 00:00:00
2002-03-10 00:00:00
2002-03-09 00:00:00
2002-03-08 00:00:00
2002-03-07 00:00:00
2002-03-06 00:00:00
2002-03-05 00:00:00
2002-03-04 00:00:00
2002-03-03 00:00:00
2002-03-02 00:00:00
2002-03-01 00:00:00
2002-02-28 00:00:00
2002-02-27 00:00:00
2002-02-26 00:00:00
2002-02-25 00:00:00
2002-02-24 00:00:00
2002-02-23 00:00:00
2002-02-22 00:00:00
2002-02-21 00:00:00
2002-02-20 00:00:00
2002-02-19 00:00:00
2002-02-18 00:00:00
2002-02-17 00:00:00
2002-02-16 00:00:00
2002-02-15 00:00:00 | 2.2 | 2.25 | 2.335 | 2.41 | 2.485 | 2.555 | 2.55 | 2.585
2002-02-14 00:00:00 | 2.18 | 2.236 | 2.318 | 2.393 | 2.472 | 2.53 | 2.532 | 2.563
2002-02-13 00:00:00 | 2.256 | 2.32 | 2.398 | 2.465 | 2.533 | 2.588 | 2.599 | 2.628
2002-02-12 00:00:00 | 2.305 | 2.369 | 2.444 | 2.507 | 2.565 | 2.615 | 2.617 | 2.644
2002-02-11 00:00:00