tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: benjamin_rogers__1034__Shortlist2
Sheet: Orion

 | ORION POWER HOLDINGS
 | Activity/Strategy: | * Acquires non-nuclear power plants throughout the U.S. and Canada
 |  | * Sells Power in the merchant market, as well as under contract to utilities that originally sold the divested plants
 |  | * Power marketing
 | Comments: | * Formed as a JV between GS Capital Power II (managed by Goldman Sachs), and Constellation Energy Group (affiliate of Baltimore Gas & Electric)
 |  | * Goldman Sachs wants out
 |  | * Plan to do IPO
 |  | * 1998, Constellation entered into long-term contract with Granite State Electric Company, Fitchburg Gas and Electric Company, and Eastern Utilities Associates
 |  | * Power plants operated by Constellation Operating Services
 |  | * Target utilities forced to divest assets
 |  | * There is talk of Mitsubishi Corp. and Tokyo Electric Power Corp. (TEPCO) investing $200 million in Orion for 30% equity
 |  | - $120 million from Mitsubishi, $80 million from TEPCO
 |  | - Each would appoint 1 member to Orion's Board of Directors
 | Summary: | North America |  |  |  |  |  |  |  |  |  |  | North America (Net Equity) |  |  | International (Net Equity)
 |  | Net Equity (Op & Construction) | Operation |  |  | Construction |  |  | Pending Acquisition |  |  | Operation | Construction | Pending Acq | Operation | Construction | Development
 |  | (MW) | Plants | MW | Net Equity | Plants | MW | Net Equity | Plants | MW | Net Equity | MW | MW | MW | MW | MW | MW
 |  | 5229.4 | 32 | 5229.4 | 5229.4 | 0 | 0 | 0 | 0 | 0 | 0 | 5229.4 | 0 | 0 | 0 | 0 | 0
 | Company Type : | Joint Venture (formed 3/1998)
 | Stock Exchange: | Na
 | [NAME]: | Na
 | Holding Company: | 63% GS Capital Power, 37% Constellation Energy Group
 | Power Marketing: | Constellation Power Source
 | Subsidiary/ Affiliate: | Constellation Power Source, Baltimore gas & Electric (utility), Constellation Power, Constellation Energy Source, Constellation Energy Project & Services, BGE Commercial Building Systems, BGE Home Products & Services
 | Web Page: | www.orionpower.com (not set up yet)
Spreadsheet: eric_saibi__9843__CrackSpreadOptions
Sheet: Mini Case Study #2

Mini Case Study #2: ERCOT Example from Megawatt Daily
 | Let's look at a sample spark spread situation, courtesy of the 11/29/00 issue of Megawatt Daily  Here we look at the
electricity prices at ERCOT (Electric Reliability Council of Texas) and at gas prices at the Houston Ship Channel - as indicated in the
following table.
 |  |  | $/MMBtu | $/MWh | 7000 | 8000 | 10000 | 12000
 |  | ERCOT/ Houston Ship Channel | 5.83 | 54.58 | 13.77 | 7.94 | -3.72 | -15.38
 | On 11/29/00, gas trading at the Ship Channel averaged $5.83/MMBtu, and peak power was selling at $52.00-56.00 per
MWh in ERCOT (the average was $54.58).  In the above table we calculate the cost of generating electricity using gas turbines that operate
at various efficiencies, beginning with a highly efficient turbine which only requires 7 MMBtu to generate a megawatt hour, down to a
turbine that requires 12 MMBtu to get the same unit of power.
 | Looking at the most efficient turbine:  7*$5.83 = $40.81, the cost to generate one megawatt hour.  If one compares
that to the cost of buying power in ERCOT at $54.58/MWh, it turns out to be $13.77 cheaper per MWh to generate the power with the
high-efficiency turbine than to buy it off the grid ($54.58 - $40.81 = $13.77).
 | However, the story changes if the turbine burns 8 MMBtu, 10 [NAME] or 12 MMBtu to yield a hypothetical
megawatt hour.  At 8,000, it's still economical to self-generate by $7.94/MMBtu.  But at 10,000 the spread is -$3.72, and power is cheaper
to buy than to generate with gas.  At a heat rate of 12,000 it's cheaper to buy from the grid by $15.38.  Recall that negative numbers
indicate gas is more expensive than power.
 | Spark spreads look at a very simple world - one where the turbine sits next to the switchyard, and both sit on top of a
natural gas pipleline.  There are no transaction costs and no transmission or transportation costs.  In the above example it is assumed that
the peaking plant is natural gas-fired, and that gas turbines operate at only four standard heat rates.  Too bad the world is not like that.
At any rate the spark spread is still a useful way to view the energy marketplace and benchmark relative energy costs.
Spreadsheet: rick_buy__32847__Sum 10-17 E11
Sheet: Sum

 |  |  | Effective Date
 |  |  | 2000-12-31 00:00:00 | 2001-03-31 00:00:00 | 2001-06-29 00:00:00
 | E-rating | Raptor 1 | 11 | 11 | 11
 |  | Raptor 2 | 11 | 11 | 11
 |  | Raptor 3 | 11 | 11 | 11
 |  | Raptor 4
 | Settle | Raptor 1 | 2003-08-03 00:00:00 | 2003-08-03 00:00:00 | 2003-08-03 00:00:00
 |  | Raptor 2 | 2003-06-29 00:00:00 | 2003-06-29 00:00:00 | 2003-06-29 00:00:00
 |  | Raptor 3 | 2003-09-27 00:00:00 | 2003-09-27 00:00:00 | 2003-09-27 00:00:00
 |  | Raptor 4
 | Term (months) | Raptor 1
 |  | Raptor 2
 |  | Raptor 3
 |  | Raptor 4
 | Cumulative | Raptor 1
 | Default | Raptor 2
 | Prob | Raptor 3
 |  | Raptor 4
 | PRM | Raptor 1 | 300627928.0635379 | 392278783.1335217 | 383495854.8699997 |  | Additional funding
 | Liability (1) | Raptor 2 | 1306798.046 | 41817537.472 | 41817537.472 |  | Hanover only
 |  | Raptor 3 | 196703974 | 256383299 | 211342299 |  | TNPC
 |  | Raptor 4 | 0 | 0 | 0
 | Recovery | Raptor 1 | 0.5
 |  | Raptor 2
 |  | Raptor 3
 |  | Raptor 4
 | Loss | Raptor 1
 |  | Raptor 2
 |  | Raptor 3
 |  | Raptor 4
 | Booked |  | 0 | -37000000 | -29000000
 | Remaining
 | Cushion |  | -39000000 | -28000000 | -30000000
 | Net
 | (1)  Unrealized loss only.  Realized losses booked to note payable
Spreadsheet: 184248d1349193388-self-expanding-refreshing-ranges-exp_refresh-ranges
Sheet: Sheet1

Names | TV Shows |  |  |  | 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 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 60 | 61 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70 | 71 | 72 | 73 | 74 | 75 | 76 | 77 | 78 | 79 | 80 | 81 | 82 | 83 | 84 | 85 | 86 | 87 | 88 | 89 | 90 | 91 | 92 | 93 | 94 | 95 | 96 | 97 | 98 | 99 | 100 | 101 | 102 | 103 | 104 | 105 | 106 | 107 | 108 | 109 | 110 | 111 | 112 | 113 | 114 | 115 | 116 | 117 | 118 | 119 | 120 | 121 | 122 | 123 | 124 | 125 | 126 | 127 | 128 | 129 | 130 | 131 | 132 | 133 | 134 | 135 | 136 | 137 | 138 | 139 | 140 | 141 | 142 | 143 | 144 | 145 | 146 | 147 | 148 | 149 | 150 | 151 | 152 | 153 | 154 | 155 | 156 | 157 | 158 | 159 | 160 | 161 | 162 | 163 | 164 | 165 | 166 | 167 | 168 | 169 | 170 | 171 | 172 | 173 | 174 | 175 | 176 | 177 | 178 | 179 | 180 | 181 | 182 | 183 | 184 | 185 | 186 | 187 | 188 | 189 | 190 | 191 | 192 | 193 | 194 | 195 | 196 | 197 | 198 | 199 | 200
[NAME] | Breaking Bad |  |  |  | Breaking Bad | [NAME] | American Idol | Mad Men | The Office | [NAME] and Recreation | Law and Order | [NAME] | X Factor | The Rising Sunset | Swims the Mighty Dessert |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
[NAME] | [NAME] |  |  | [NAME]
Sophie | American Idol |  |  | [NAME]
[NAME] | Mad Men |  |  | Sophie
[NAME] | The Office |  |  | [NAME]
[NAME] | [NAME] and Recreation |  |  | [NAME]
[NAME] | Law and Order |  |  | [NAME]
[NAME] | [NAME] |  |  | [NAME]
[NAME] | X Factor |  |  | [NAME]
[NAME] | The Rising Sunset |  |  | [NAME]
Tarzan | Swims the Mighty Dessert |  |  | [NAME]
 |  |  |  | Tarzan
Spreadsheet: 686608d1594713935-two-sumproduct-from-two-tables-2-sumproduct_with_2_tables
Sheet: Sheet1

 |  | TABLE 1 |  |  |  | TABLE 2 |  |  |  | TOTAL TABLE 1+ TABLE 2 | SUMPRODUCT | SUMIF
 |  | EMP 1 | 114 | 0.1536388140161725 |  | EMP 1 | 19 | 0.3333333333333333 |  | EMP 1
 |  | EMP 2 | 69 | 0.09299191374663072 |  | EMP 2 | 10 | 0.1754385964912281 |  | EMP 2
 |  | EMP 3 | 66 | 0.0889487870619946 |  | EMP 3 | 7 | 0.1228070175438596 |  | EMP 3
 |  | EMP 4 | 60 | 0.08086253369272237 |  | EMP 4 | 4 | 0.07017543859649122 |  | EMP 4
 |  | EMP 5 | 55 | 0.07412398921832884 |  | EMP 5 | 4 | 0.07017543859649122 |  | EMP 5
 |  | EMP 6 | 50 | 0.0673854447439353 |  | EMP 6 | 4 | 0.07017543859649122 |  | EMP 6
 |  | EMP 7 | 43 | 0.05795148247978436 |  | EMP 7 | 3 | 0.05263157894736842 |  | EMP 7
 |  | EMP 8 | 42 | 0.05660377358490566 |  | EMP 8 | 2 | 0.03508771929824561 |  | EMP 8
 |  | EMP 9 | 37 | 0.04986522911051213 |  | EMP 9 | 2 | 0.03508771929824561 |  | EMP 9
 |  | EMP 10 | 37 | 0.04986522911051213 |  | EMP 10 | 1 | 0.01754385964912281 |  | EMP 10
 |  | EMP 11 | 35 | 0.04716981132075472 |  | EMP 11 | 1 | 0.01754385964912281 |  | EMP 11
 |  | EMP 12 | 35 | 0.04716981132075472 |  |  |  |  |  | EMP 12
 |  | EMP 13 | 32 | 0.0431266846361186 |  |  |  |  |  | EMP 13
 |  | EMP 14 | 20 | 0.02695417789757413 |  |  |  |  |  | EMP 14
 |  | EMP 15 | 17 | 0.02291105121293801 |  |  |  |  |  | EMP 15
 |  | EMP 16 | 16 | 0.0215633423180593 |  |  |  |  |  | EMP 16
 |  | EMP 17 | 11 | 0.01482479784366577 |  |  |  |  |  | EMP 17
 |  | EMP 18 | 3 | 0.004043126684636119 |  |  |  |  |  | EMP 18
 |  | EMP 19 | 0 | 0 |  |  |  |  |  | EMP 19
 |  | TOTAL | 742 | 1 |  | TOTAL | 57 | 1 |  | TOTAL
Spreadsheet: 790693d1659951155-creating-a-rolling-sum-formula-rolling_sum
Sheet: Sheet1

 | Total | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul
A |  | 1 |  |  |  |  |  |  |  |  |  |  |  | 1
b |  |  | 1 | 1 |  |  |  |  |  |  | 1 |  | 2
c |  |  | 1 |  |  | 1 |  |  | 2
d |  |  |  |  | 1 |  |  |  |  |  |  |  | 2
e |  |  |  |  |  |  |  |  |  | 1 | 3 |  | 1
f |  |  |  |  |  |  |  |  |  | 1
g |  |  | 1 |  |  |  |  | 1 |  |  |  |  | 2
Spreadsheet: 82685d1282720282-how-to-trim-blanks-from-a-formula-cell-codelookup101
Sheet: Sheet2

 |  |  |  |  |  |  |  |  |  |  |  | Code | Description
ASM SIGNATURE IS REQUIRED | AUTH SIGN STAMP  REQUIRED |  |  |  |  |  |  |  |  |  |  | A | ASM SIGNATURE IS REQUIRED
SIGN M/M NOMINEE AGREMNT |  |  |  |  |  |  |  |  |  |  |  | B | AUTH SIGN STAMP  REQUIRED
SIGN MISMATCH  WITH  DOCS |  |  |  |  |  |  |  |  |  |  |  | C | AUTH SIGN LETTER REQUIRED
INCOMPLETE  DOCS  OR FORM | [NAME] NOMINEE WITNESS |  |  |  |  |  |  |  |  |  |  | D | DOCS  NOT CLEAR OR LEGIBLE
SIGN M/M NOMINEE AGREMNT | SIGN MISMATCH  WITH  DOCS |  |  |  |  |  |  |  |  |  |  | E | [NAME] WITH DOCS
ROOM,COTTAGE,HOTEL IN ADD |  |  |  |  |  |  |  |  |  |  |  | F | SIGN M/M NOMINEE AGREMNT
 |  |  |  |  |  |  |  |  |  |  |  | G | SIGN MISMATCH  WITH  DOCS
 |  |  |  |  |  |  |  |  |  |  |  | H | INCOMPLETE  DOCS  OR FORM
 |  |  |  |  |  |  |  |  |  |  |  | I | [NAME] NOMINEE WITNESS
 |  |  |  |  |  |  |  |  |  |  |  | J | OFFICE ADDRESS IS REQUIRED
 |  |  |  |  |  |  |  |  |  |  |  | K | ROOM,COTTAGE,HOTEL IN ADD
 |  |  |  |  |  |  |  |  |  |  |  | L | DOB MISMATCH IN FORM DOCS
 |  |  |  |  |  |  |  |  |  |  |  | M | COUNTER - SIGN IS REQD IN EC
 |  |  |  |  |  |  |  |  |  |  |  | N | COUNTERSIGN REQ IN ADDRES
 |  |  |  |  |  |  |  |  |  |  |  | O | NAME IS MIS-MATCH  IN  FORM
 |  |  |  |  |  |  |  |  |  |  |  | P
 |  |  |  |  |  |  |  |  |  |  |  | Q
 |  |  |  |  |  |  |  |  |  |  |  | R
 |  |  |  |  |  |  |  |  |  |  |  | S
 |  |  |  |  |  |  |  |  |  |  |  | T
 |  |  |  |  |  |  |  |  |  |  |  | U
 |  |  |  |  |  |  |  |  |  |  |  | V
 |  |  |  |  |  |  |  |  |  |  |  | W
 |  |  |  |  |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  |  |  |  |  | Y
 |  |  |  |  |  |  |  |  |  |  |  | Z
Spreadsheet: 727554d1617959592-dynamic-array-formula-for-nearest-non-blank-nearest-non-blank
Sheet: AverageByRow

Row average | Sort of dynamic formula | Test that didn't work out |  | Data source
 |  |  |  | 1 | 1.1 | 0.9
 | 2.133333333333333 |  |  | 2 | 2.3 | 2.1
 | 3.066666666666666 |  |  | 3.2 | 2.9 | 3.1
"Sort of dynamic formula" assumes three columns of data per row
But what if there are many more columns, or even worse, what if column range is variable?
Row average |  |  |  | Data source (may be result of another formula)
=? |  |  |  | 1 | 1.1 | 0.9 | 0.8 | 1 | 1.1
 |  |  |  | 2 | 2.3 | 2.1 | 2 | 2 | 2.2 | 1.9 | 2
 |  |  |  | 3.2 | 2.9 | 3.1
Spreadsheet: 88021d1287923050-auto-sorting-and-grouping-data-by-column-sorting10000
Sheet: Avatar

Background |  |  | helper | Raw Respect Modifiers |  | Raw Statistic Modifiers |  | Raw Miscellaneous Modifiers
Farmer |  |  | 28 | Communist Respect | 10
1 | Communist Respect | 10 | 70 | Intellectual Respect | -10
1 | Intellectual Respect | -10 |  |  |  | Farmer Production | 0.5
2 | Farmer Production | 0.5
- | - | -
- | - | -
Rise To Power |  |  | 23 | Capitalist Respect | 5
Elected as Capitalist |  |  | 135 | US Relations | 15
- | High Democratic Exp. | - |  |  |  | Factory Production | 0.2
1 | Capitalist Respect | 5 |  |  |  | Liberty | 0.2
1 | US Relations | 15
2 | Factory Production | 0.2
2 | Liberty | 0.2 |  | Intellectual Respect | 25
- | - | - |  |  |  | Education & Skill Rate | 0.3
- | - | -
Quality 1
Scholarly
1 | Intellectual Respect | 25 |  |  |  | Overall Production | 0.1
2 | Education & Skill Rate | 0.3
- | - | -
- | - | -
- | - | -
Quality 2 |  |  |  | Communist Respect | -10
Hardworking |  |  |  |  |  | Building Cost | -0.05
2 | Overall Production | 0.1 |  |  |  |  |  | $25 Maximum Salary | -
- | - | -
- | - | - | 109 | Religious Respect | -10
- | - | - |  |  |  |  |  | Annual Binge | $300-1500
- | - | - |  |  |  |  |  | [NAME] At Gambling | -
Flaw 1
Cheapskate
1 | Communist Respect | -10 |  | Net Respect Modifiers |  | Net Statistic Modifiers |  | Net Miscellaneous Modifiers |  |  | Democratic Expectation
2 | Building Cost | -0.05 |  | Capitalist Respect | 5 |  |  |  |  |  | High
3 | $25 Maximum Salary | - |  | Communist Respect | 0
- | - | - |  | Intellectual Respect | 15
[NAME] |  |  |  | Religious Respect | -10
Compulsive Gambler |  |  |  | US Relations | 15
1 | Religious Respect | -10
3 | Annual Binge | $300-1500
3 | [NAME] At Gambling | -
- | - | -
Spreadsheet: 377599d1424085118-a-formula-which-rejects-duplicating-data-data-validation-examples
Sheet: DependentList

Vegetables | Fruits | Meats
Arugula | Apple | Beef |  | Vegetables | Celery
Asparagus | [NAME] | Chicken
Beet | Lemon | Lamb
Broccoli | Orange | Pork
Carrot | Peach
Cauliflower | Pear
Celery | [NAME]
Corn | [NAME]
Green Bean
Onion
Potato
Radish
Squash
Turnip
Spreadsheet: 05a42c5a-4bdd-44a8-89f1-7496d094ee4f
Sheet: Sheet1

Degree Level, Top 10 Places of Origin for | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
the United States, 2008-2009
Places of Origin | Top 10 Places of Origin | Total Number of International Students | Undergraduate  International Students | Graduate  International Students | Non-degree-seeking International Students | Optional Practical Training
#1 | India | 103260 | 15600 | 71019 | 1755 | 14886
#2 | China | 98235 | 26275 | 57452 | 6296 | 8212
#3 | South Korea | 75065 | 37078 | 25463 | 7390 | 5134
#4 | Canada | 29697 | 14261 | 13185 | 473 | 1778
#5 | Japan | 29264 | 16770 | 6287 | 3970 | 2237
#6 | Taiwan | 28065 | 7143 | 15332 | 2146 | 3444
#7 | Mexico | 14850 | 8934 | 4148 | 1044 | 724
#8 | Vietnam | 12823 | 9247 | 1944 | 1271 | 361
#9 | Turkey | 12148 | 4393 | 6838 | 937 | 1095
#10 | Saudi Arabia | 12661 | 7563 | 2903 | 2041 | 154
Total of All Places of Origin | Total | 671616 | 269874 | 283329 | 51812 | 66601
Source:  Institute of International Education. Open Doors Report on International Educational Exchange.
Spreadsheet: 163925d1340551998-using-sumifs-to-add-specific-criteria-sample
Sheet: Sheet1

year | team | category | points |  | texans |  |  | this is my two formula but it failed
2001 | texans | off | 100 |  | texans
2001 | texans | def | 200
2001 | eagle | off | 300 |  |  | I want the texans to add up to be 100+500=600 in G1
2001 | eagle | def | 400
2002 | texans | off | 500 |  |  | this is my 2 formulas but it's failed,
2002 | texans | def | 600 |  |  | SUMIFS(points,team,F1,category,"off",year,"2001",category,"2002")
2002 | eagle | off | 700 |  |  | SUMIFS(points,team,F2,category,"off",year,{"2001";"2002"})
2002 | eagle | def | 800
 |  |  |  |  |  | can someone help me get the texans to add up to be 600 in offense in 2001 and 2002?
Spreadsheet: 145679d1331701290-lookup-cell-in-workbook-a-if-true-then-post-contents-of-row-into-workbook-b-test-book
Sheet: Sheet2

Month to pull |  | JAN
JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC
Month | Date of Proposal | Division | Insurance (Y/N) | Project # | Name of Project | Executed Contract | Date of Contract | Job Sell | Job Cost | Proposed Profit | Gross Profit Margin | Actual Profit | Revenue Pipeline | Lost Revenue | Date Job Invoiced | Actual Revenue | Actual Cost | Work Completed (Yes/No) | # of Days Overdue | Invoice Paid | Reason for Not Executed
Spreadsheet: 861196d1709139057-add-gross-margin-line-to-a-pivot-table-example-p-and-l
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | Sum of AMOUNT | Column Labels
 |  |  |  | Period | [NAME] | AMOUNT |  |  | Row Labels | 1 | 2 | Grand Total
 |  |  |  | 1 | TURNOVER | 100 |  |  | TURNOVER | 100 | 150 | 250
 |  |  |  | 1 | Cost of sales | -50 |  |  | Cost of sales | -50 | -50 | -100
 |  |  |  | 2 | TURNOVER | 150 |  |  | Gross Profit | 50 | 100 | 150
 |  |  |  | 2 | Cost of sales | -50
Spreadsheet: holden_salisbury__12309__Bike Trip Tally
Sheet: Tally Sheet

DATE | To | From | Total # [NAME]
2001-09-01 00:00:00 |  |  |  |  |  |  | Days to Ride
2001-09-02 00:00:00 |  |  |  |  |  |  | Weekend/Holiday
2001-09-03 00:00:00
2001-09-04 00:00:00
2001-09-05 00:00:00 |  |  |  |  | Enter 1 to show you rode in or home from work
2001-09-06 00:00:00
2001-09-07 00:00:00
2001-09-08 00:00:00
2001-09-09 00:00:00
2001-09-10 00:00:00
2001-09-11 00:00:00
2001-09-12 00:00:00
2001-09-13 00:00:00
2001-09-14 00:00:00
2001-09-15 00:00:00
2001-09-16 00:00:00
2001-09-17 00:00:00
2001-09-18 00:00:00
2001-09-19 00:00:00
2001-09-20 00:00:00
2001-09-21 00:00:00
2001-09-22 00:00:00
2001-09-23 00:00:00
2001-09-24 00:00:00
2001-09-25 00:00:00
2001-09-26 00:00:00
2001-09-27 00:00:00
2001-09-28 00:00:00
2001-09-29 00:00:00
2001-09-30 00:00:00
Spreadsheet: 127283d1320268877-excel-2007-how-to-extract-items-from-spreadsheet-test
Sheet: Sheet1

from | to | date | message
me | 8045551212 | 2011-11-02 00:00:00 | hey
8045551212 | me | 2011-11-02 00:00:00 | whats up
8045557777 | me | 2011-11-02 00:00:00 | hello
me | 8045557777 | 2011-11-02 00:00:00 | how r u
me | 8045556666 | 2011-11-02 00:00:00 | whats up
8045556666 | me | 2011-11-02 00:00:00 | not much
I want it to spit out like this
from | to | date | message
8045557777 | me | 2011-11-02 00:00:00 | hello
me | 8045557777 | 2011-11-02 00:00:00 | how r u
8045557777 | me | date | message
me | 8045557777 | date | message
me | 8045557777 | date | message
8045557777 | me | date | message
and any other cells that have the same number in the "to" or "from" column into a spreadsheet by itself |  |  |  |  |  |  |  |  | itself and eliminate all other numbers so that I can just read messages to and from that certain phone numbe
Spreadsheet: b928b813-06e9-4c2b-9304-d7b85f47d048
Sheet: Sheet1

[NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Quelle: http://ergebnisse.vimentis.ch/
Frage:
[NAME] müssen gleich behandelt werden wie private [NAME] (sie erhalten keine [NAME] öffentlichen Hand und können [NAME] gehen).
 | Welches ist Ihre höchste abgeschlossene Ausbildung?
Antwort | Obligatorische Schule oder (noch) keine abgeschlossene Ausbildung | [NAME], [NAME], berufsvorbereitende [NAME], [NAME] | Maturitätsschule, Diplommittelschule | Höhere Fach- oder [NAME] ([NAME]. Fach- oder [NAME], HKG, TS) | Universität, Hochschule, Fachhochschule, Höhere Fachschule ([NAME], HWV, HFG, HFS)
[NAME] | 0.24 | 0.26 | 0.19 | 0.31 | 0.25
[NAME] | 0.63 | 0.62 | 0.7 | 0.61 | 0.67
Neutral / Weiss nicht | 0.14 | 0.11 | 0.11 | 0.08 | 0.08
Angaben zu den [NAME]
Erhebungsjahr | 2010
Stichprobengrösse | 29292
Erhebungszeitraum | 02.10.2010 bis: 06.12.2010
[NAME] | [NAME]
Methodik / Repräsentativität
Um soziodemographische Verzerrungen [NAME], wurden sämtliche [NAME] nach [NAME], Alter, Bildung und Region gemäss der wahren [NAME] älter als 15 Jahre gewichtet. Es bleibt eine psychographische Verzerrung wegen
der [NAME] über das Internet, welche nicht korrigiert [NAME]. Diese Verzerrung wird anhand einzelner [NAME] für jede [NAME] abgeschätzt. Demnach sind [NAME] auf dieser Seite angegebenen [NAME] mit einer
Präzision von &plusmn;2% [NAME].
[NAME] und [NAME] auf dieser Seite dürfen unter Angabe der Quelle weiterverwendet werden.
Spreadsheet: 725052d1616512279-count-with-changes-in-multiple-criteria-count-formula-ans-2
Sheet: Sheet1

Invoice Number | Explanation-Remark- | Count Formula | Examples | Need a formula that will add a .1 to the invoice number for every change in the remark.
[PHONE] | 02/02-03/01 #050579760100001 G |  | [PHONE].1
[PHONE] | 02/02-03/01 #050579760100001 H |  | [PHONE].2
[PHONE] | 02/02-03/04 #AUGM1 E |  | [PHONE].1
[PHONE] | 01/01-02/01 #92564300 W |  | [PHONE].1 | B6<>B5
[PHONE] | 01/01-02/01 #92564300 W |  | [PHONE].1
[PHONE] | 01/07-02/05 #101542300 W |  | [PHONE].2
[PHONE] | 01/07-02/05 #101542300 W |  | [PHONE].2
[PHONE] | 01/07-02/05 #101566300 W |  | [PHONE].3
[PHONE] | 01/07-02/05 #101566300 W |  | [PHONE].3
[PHONE] | 01/07-02/05 #101573300 W |  | [PHONE].4
[PHONE] | 01/07-02/05 #101573300 W |  | [PHONE].4
[PHONE] | 01/07-02/05 #103191301 W |  | [PHONE].5
[PHONE] | 01/07-02/05 #103197300 W |  | [PHONE].6
[PHONE] | 01/07-02/05 #103197300 W |  | [PHONE].6
[PHONE] | 12/30-03/01 #[PHONE] S |  | [PHONE].1
[PHONE] | 12/30-03/01 #[PHONE] W |  | [PHONE].2
[PHONE] | 02/13-03/15 #[PHONE] E |  | [PHONE].3
[PHONE] | 02/13-03/15 #[PHONE] N |  | [PHONE].4
[PHONE] | 02/13-03/15 #[PHONE] E |  | [PHONE].5
[PHONE] | 02/13-03/15 #[PHONE] N |  | [PHONE].6
[PHONE] | 02/13-03/15 #[PHONE] E |  | [PHONE].7
Spreadsheet: 755377d1636821071-formula-result-is-different-from-evaluated-result-avg-example-data_gw
Sheet: Sheet1

Product | [NAME]
BC0002 | 21000 |  | BC0002
BC0006 | 90000
BC0006 | 1000
BC0006 | 0
BC0006 | 82000
BC0022 | 81000
BC0022 | 80000
BC0022 | 100000
BC0022 | 59000 |  |  |  | 21000
BC0022 | 81000 |  |  |  | 21000
BC0022 | 33000
BC0086 | 82090
BC0086 | 57600
BC0109 | 111725
BC0109 | 105000
BC0109 | 185950
BC0109 | 158975
BC0109 | 161325
BC0109 | 219000 |  | 90000
 |  |  | 1000
 |  |  | 90000
 |  |  | 1000
Spreadsheet: 773536d1647911905-compare-number-to-set-of-ranges-and-then-calculate-with-corresponding-numbers-vlookup-true-for-income-percent
Sheet: Ranges

Income Range |  | % for [NAME]
0 | 500000 | 0
500001 | 750000 | 0.1
750001 | 1000000 | 0.15
1000001 | 1250000 | 0.2
1250001 | 1500000 | 0.25
1500001 | 1750000 | 0.3
1750001 | 2000000 | 0.4
2000001 | 3500000 | 0.5
3500001 | 3750000 | 0.6
Example:
The total income on the Income tab is $900,000
Comparing the income to the table on the Ranges tabe, the percentage for [NAME] would be 15%
Calculating 15% of $900,000, [NAME] would get $135,000
Spreadsheet: 68829d1269369093-formula-using-if-and-cell-reference-1060-mod-2
Sheet: Base pricing

4 3/4 Base | 12.1 | NEED TO MULTIPLY THIS TIMES COLUMN F or G EXCEPT IF THERE IS AN ENTRY IN COLUMN L
5 3/4 Base | 11.5 | EACH PAGE WILL DRAW FROM APPROPRIATE SIZE
6 3/4 Base | 13.75
4 3/4 4" Face | 9.25 | NEED TO MULTIPLY THIS TIMES COLUMN L
5 3/4 4" face | 8.95 | EACH PAGE WILL DRAW FROM APPROPRIATE SIZE
6 3/4 4" face | 9.65
Hinges | 2 | NEED TO MULTIPLY BY COLUMN J
STRIKE | 2.75 | COLUMN K
ALL FIELDS NEED TO ADD ACROSS THE ROW AND SUM ENTERED IN COLUMN P FOR EACH ROW