tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 85760d1285789715-sorting-women27sgrandprix2010
Sheet: 4.5 Doubles

Rank | Name | Total | Average | Barber City | ISS/LG Open | SOCC Spring Classic | Tournament 4 | Tournament 5 | Tournament 6 | Tournament 7 | Tournament 8 | Tournament 9 | Tournament 10
1 | Heather Farrer | 120 | 30 | 40 | 80 | 0
2 | [NAME] | 90 | 26.66666666666667 | 10 | 40 | 40
3 | [NAME] | 80 | 26.66666666666667 | 0 | 80 | 0
4 | [NAME] | 70 | 23.33333333333333 | 10 | 20 | 40
5 | Estanfinia Limpias | 55 | 18.33333333333333 | 40 | 15 | 0
6 | [NAME] | 40 | 13.33333333333333 | 0 | 40 | 0
7 | [NAME] | 20 | 6.666666666666667 | 0 | 0 | 20
8 | [NAME] | 20 | 6.666666666666667 | 0 | 20 | 0
9 | [NAME] | 20 | 6.666666666666667 | 0 | 0 | 20
10 | [NAME] | 20 | 6.666666666666667 | 20 | 0 | 0
11 | [NAME] | 20 | 6.666666666666667 | 20 | 0 | 0
12 | [NAME] | 15 | 5 | 0 | 15 | 0
13 | [NAME] | 10 | 3.333333333333333 | 0 | 10 | 0
14 | [NAME] | 10 | 3.333333333333333 | 0 | 0 | 10
15 | Hedy Bloom | 10 | 3.333333333333333 | 0 | 0 | 10
16 | Tori Seaman | 10 | 3.333333333333333 | 0 | 10 | 0
17 |  | 0 | 0 | 0
18 |  | 0 | 0 | 0
19 |  | 0 | 0 | 0
20 |  | 0 | 0 | 0
21 |  | 0 | 0 | 0
22 |  | 0 | 0 | 0
23 |  | 0 | 0 | 0
24 |  | 0 | 0 | 0
25 |  | 0 | 0 | 0
26 |  | 0 | 0 | 0
27 |  | 0 | 0 | 0
28 |  | 0 | 0 | 0
29 |  | 0 | 0 | 0
30 |  | 0 | 0 | 0
31 |  | 0 | 0 | 0
32 |  | 0 | 0 | 0
33 |  | 0 | 0 | 0
34 |  | 0 | 0 | 0
35 |  | 0 | 0 | 0
36 |  | 0 | 0 | 0
37 |  | 0 | 0 | 0
38 |  | 0 | 0 | 0
39 |  | 0 | 0 | 0
40 |  | 0 | 0 | 0
41 |  | 0 | 0 | 0
42 |  | 0 | 0 | 0
43 |  | 0 | 0 | 0
44 |  | 0 | 0 | 0
45 |  | 0 | 0 | 0
46 |  | 0 | 0 | 0
47 |  | 0 | 0 | 0
48 |  | 0 | 0 | 0
49 |  | 0 | 0 | 0
50 |  | 0 | 0 | 0
51 |  | 0 | 0 | 0
52 |  | 0 | 0 | 0
53 |  | 0 | 0 | 0
54 |  | 0 | 0 | 0
55 |  | 0 | 0 | 0
56 |  | 0 | 0 | 0
57 |  | 0 | 0 | 0
58 |  | 0 | 0 | 0
59 |  | 0 | 0 | 0
60 |  | 0 | 0 | 0
61 |  | 0 | 0 | 0
62 |  | 0 | 0 | 0
63 |  | 0 | 0 | 0
64 |  | 0 | 0 | 0
65 |  | 0 | 0 | 0
66 |  | 0 | 0 | 0
67 |  | 0 | 0 | 0
68 |  | 0 | 0 | 0
69 |  | 0 | 0 | 0
70 |  | 0 | 0 | 0
71 |  | 0 | 0 | 0
72 |  | 0 | 0 | 0
73 |  | 0 | 0 | 0
74 |  | 0 | 0 | 0
Spreadsheet: 480384d1473884520-conditional-formatting-help-formula-based-conditional-formating-help-template
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NEEDS TO BE CONDITIONAL FORMATTING
Limit 1 | Limit 2 | Limit 3 | Limit 4 | Monthly amounts | Monthly amounts | Monthly amounts | Monthly amounts | Monthly amounts | Monthly amounts | Monthly amounts | Monthly amounts | Monthly amounts | Monthly amounts | Monthly amounts | Total | QA
Total | Total | Total | Total | September | October | November | December | January | February | March | April | May | June | July
200000 | 40000 | 120320 | 2138382 | 4000 |  | 676565 |  |  |  | 0 |  | 0
40000 | 500000 | 920392 | 3920392 |  | 2343 |  | 33333 | 34555 | 9000 |  |  |  | 5555555 | 900
10000 | 200000 | 900000 | 503000 |  |  |  |  | 23424 | 200000 |  | 500076 | 889500
10000 | 754839 | 500000 | 40000 | 23422 |  | 5456745 |  |  |  |  | 54343 | 70000 |  | 67876
Spreadsheet: 735425d1622983015-traffic-sign-for-kpi-book1-44-ans
Sheet: Summery

 | INPUT YOUR FINANCIAL DATA
 | 25 KPIs can be shown for 7 years
 | Metrices | 2008 | 2009 | 2010 | 2011
 | Revenue | 125000 | 143137.45 | 142000 | 145687.46
 | Muncipal Tax | -62965 | -59150 | -56452 | -66769
 | Service Tax | -3086 | -2884 | -3444 | -69348
 | Exp | -5342 | -5178 | -5044 | -4979
 | Income Tax | 0 | 0 | 0 | -3183
 | Net Profit
Spreadsheet: 482682d1475182479-conditional-formating-for-data-entry-in-a-cell-running-material-list
Sheet: Running Material List

Description | Part Number | Qnty | Job Name | Date Submited | Date Ordered | Date Filled | Vendor
1 gang plastic remodel box |  | 1 | Break room counter receptacle | 2016-09-22 00:00:00
Maintained Rotary Switch spst |  | 1 | SureBoard Vacuum Switch | 2016-09-22 00:00:00
[NAME] |  | 1 | SureBoard Machine | 2016-09-22 00:00:00
4x4x1.5 metal box with 1/2" and 3/4" [NAME]'s |  | 5 | Paging System | 2016-09-22 00:00:00
20 amp duplex receptacles |  | 5 | Paging System | 2016-09-22 00:00:00
4x4 duplex receptacle industrial covers |  | 5 | paging system | 2016-09-22 00:00:00
250 watt metal halide flood |  | 1 | shipping canopy | 2016-09-22 00:00:00
wall mount lights |  | 3 | canopy over saw by shipping | 2016-09-22 00:00:00
Cutting Oil 16oz Spray | 2F146 | 11 |  | 2016-09-22 00:00:00 |  | 2016-09-20 00:00:00 | Grainger
8mm x 1.25 tap and associated drill bit. or 12 x 2-1/2" 5/16" eyebolts and 5/16" tap. | 14798/14797 | 1, 1, / 5 | cable interlock at 506 | 2016-09-22 00:00:00 | 2016-09-26 00:00:00 | 2016-09-27 00:00:00 | McMaster-CARR
#2 pencils aint none!  no where! |  |  |  |  |  |  | got me  some
Ferrule single, 16awg | 70037446 | 500 |  |  | 2016-09-27 00:00:00 |  | Allied
Ferrule dual, 16awg | 70037652 | 500 |  |  | 2016-09-28 00:00:00 |  | Allied
Spreadsheet: 860224d1708412946-help-with-vlook-up-and-data-validation-google-sheet-exercise
Sheet: Instruction

Worksheet 1
1 | INSTRUCTIONS: [NAME] 1
 | Freeze and [NAME] 1
2 | INSTRUCTIONS: Set up conditional formatting
 | Set up conditional formatting so that the "Status" column (column G) shows:
 | Yellow for "Confirmed"
 | Green for "Completed"
3 | INSTRUCTIONS: Create a formula to fill in the missing data in cells D10 & D11
 | Using the COUNTIF formula in cells D10 & D11
 | count the number of times each status is used in column G
Bonus | INSTRUCTIONS: Conditional format the range a2:i7
 | Set up conditional formatting that differentiates "CONFIRMED" and "COMPLETED"
 | status and will highlight the entire row of the table
 | E.g. When [NAME] is "CONFIRMED," A2:I2 is highlighted yellow.
Worksheet 2
1 | INSTRUCTIONS: Enter data validation in cells C4:C9
 | Create data validation in cells C4:C9 (Table A)
 | so that only numbers between 4:00 and 8:00 display as valid
2 | INSTRUCTIONS: Set up an IFS formula in E4:E9
 | Setup an IFS formula so that E4:E9 (Table A) displays the "Cost to Rent"
 | for each robot based on the "Cost Per Hour" (Table B).
3 | INSTRUCTIONS: Create a formula to fill in the missing data in cells K11:K12
 | Create a formula with VLOOKUP to calculate the comission percentage
 | for Robot 1 and 2. Your formula should refer to Table C.
Worksheet 3
1 | INSTRUCTIONS: Build onto Pivot Table A
 | Display the "Hours Rented" row and show totals
 | Display the SUM of "Cost to Rent" value with a Grand Total
2 | INSTRUCTIONS: Edit the date format in G4:G14
 | Using the date format tool, change the dates in G4:G14 to display as [NAME]/dd/yyyy
 | E.g. 01/01/2030
Spreadsheet: 787566d1657874861-remove-characters-between-two-symbols-and-more-with-formula-forum_upload_characters
Sheet: Sheet1

Original text | [NAME] test | Example output |  | ;1 | ;2 | ;3 | ;4 | ;5 | ;6 | ;7 | ;8 | ;9 | ;10 | &nbsp;
Myall Creek Wattle is known&nbsp;from two populations near Delungra and [NAME]. Each population occupies less than 5 hectares. Individuals on&nbsp; Kirramingly&nbsp;Nature Reserve have been&nbsp;described as a separate subspecies <span style="font-style: [NAME]>subsp.<span style="font-style: italic"> planitiicola (</span>formerly<span style="font-style: italic"> planiticola)</span>,of which six small patches exist.&nbsp;The distribution, ecology&nbsp;and failure of each subspecies to form seed pods suggests the species was once very widely distributed in the region. |  | Myall Creek Wattle is known from two populations near Delungra and [NAME]. Each population occupies less than 5 hectares. Individuals on Kirramingly Nature Reserve have been described as a separate subspecies [NAME] atrox subsp. [NAME] (formerly planiticola),of which six small patches exist.The distribution, ecology and failure of each subspecies to form seed pods suggests the species was once very widely distributed in the region.
May require regular fire to maintain populations. Too-infrequent fire may lead to population decline, particularly if the fire interval is greater than 20 years.;1|Usually grows in wet heath and acid swamp areas and along watercourses on granite, above 900 m altitude.;2|Associated species include <em>Baeckea omissa, [NAME] microphylla, [NAME] sieberi, [NAME] and <em>Restio</em> species.;3|Flowers from September to November.  The species does not spread vegetatively and is probably an obligate seeder.;4 |  | May require regular fire to maintain populations. Too-infrequent fire may lead to population decline, particularly if the fire interval is greater than 20 years. Usually grows in wet heath and acid swamp areas and along watercourses on granite, above 900 m altitude. Associated species include [NAME], [NAME] microphylla, [NAME] sieberi, [NAME] and Restio species. Flowers from September to November. The species does not spread vegetatively and is probably an obligate seeder.
Spreadsheet: 767605d1644544814-sumif-with-two-tables-book2
Sheet: Sheet1

Category | Index |  |  | Index | month | electricity usage |  |  | Total electricity by type
Buildings | 25 |  |  | 25 | Jan | 10000 |  |  | Buildings
Lights | 456 |  |  | 25 | Feb | 200000 |  |  | Lights
Buildings | 22 |  |  | 25 | Mar | 344444
Buildings | 1 |  |  | 456 | Jan | 56789
Lights | 26 |  |  | 456 | Feb | 111100
Lights | 345 |  |  | 456 | Mar | 1230953
Lights | 354 |  |  | 22 | Jan | 4356576
Lights | 5678 |  |  | 22 | Feb | 43564357
 |  |  |  | 22 | Mar | 12234
Spreadsheet: 738807d1625242199-formula-for-creating-whole-date-out-of-separate-day-month-and-year-date-maker
Sheet: whole date

Day | Month | Year |  |  |  |  |  |  | Date
1 | 1 | 2021 |  |  |  |  |  |  | 2021-01-01 00:00:00
2 | 1 | 2021 |  |  |  |  |  |  | 2021-01-02 00:00:00
3 | 1 | 2021 |  |  |  |  |  |  | 2021-01-03 00:00:00
4 | 1 | 2021 |  |  |  |  |  |  | 2021-01-04 00:00:00
5 | 1 | 2021 |  |  |  |  |  |  | 2021-01-05 00:00:00
6 | 1 | 2021 |  |  |  |  |  |  | 2021-01-06 00:00:00
7 | 1 | 2021 |  |  |  |  |  |  | 2021-01-07 00:00:00
8 | 1 | 2021 |  |  |  |  |  |  | 2021-01-08 00:00:00
Spreadsheet: 850186d1700570841-pi-ci-of-continuous-data-example-data
Sheet: Sheet1

X-variable | Y-variable
Lot 1 | 10.1
Lot 2 | 10
Lot 3 | 10
Lot 4 | 10.1
Lot 5 | 10.1
Lot 6 | 10
Lot 7 | 9.9
Lot 8 | 10
Lot 9 | 9.9
Lot 10 | 10
Lot 11 | 10.1
Lot 12 | 10.1
Lot 13 | 10
Lot 14 | 10.3
Lot 15 | 10.3
Lot 16 | 10.3
Spreadsheet: 771827d1646863384-unique-count-with-condition-involving-3-keywords-test3
Sheet: Sheet1

ID | Type | Status
10824375041 | Cop | ISSUED
116334111048 | Cop | RENEWED
219670034046 | Cop | EXPIRED
228056127019 | Gem | RENEWED
228056127019 | Cop | ISSUED
228056127019 | Cop | RENEWED
358256702046 | Ob | RENEWED
358256702046 | Ob | ISSUED
358256702046 | Gem | ISSUED
409362001037 | Gem | RENEWED
434792695034 | Cop | REPAIR
434792695034 | Ob | ISSUED
484037250046 | Ob | EXPIRED
576335107040 | Cop | RENEWED
638386774563 | Gem | ISSUED
641511808033 | Ob | REPAIR
775945439047 | Cop | DESTROY
775945439047 | Gem | ISSUED
Spreadsheet: 860891d1708908485-divided-by-number-more-than-2-asd
Sheet: Munka1

1054 |  | divisor | compare spec
1046 |  | 10 | 2
20
20
20
14
14
45
45
45
45
45
45
45
45
110
110
240
20
20
20
122
108
470
332
80
110
Spreadsheet: larry_campbell__21031__SeminolePTE
Sheet: TANKs

NORTHERN NATURAL GAS COMPANY
SEMINOLE COMPRESSOR STATION
TNRCC ACCOUNT NO. GA-0174-T
TANK EMISSIONS
 |  |  | Annual | Maximum | Working | Standing | Annual | [NAME]
 |  | Capacity | Throughput | [NAME] | Losses | Losses | Emissions | Emissions
Tank ID | Contents | (gals) | (gal/yr) | (gals/hr) | (lb/yr) | (lb/yr) | (tpy) | (lb/hr)
TK-1 | Condensate | 8820 |  | 4200 | 526 | 645
TK-2 | [NAME] | 3000 |  | 4200 | 0 | 0
TK-3 | [NAME] | 2202 |  | 4200 | 0 | 0
TK-4 | Engine Coolant | 1000 |  | 4200 | 0 | 0 | 0 | 0
TK-5 | Engine Coolant | 939 |  | 4200 | 0 | 0
TK-6 | [NAME] | 3286 |  | 4200 | 0 | 0
TOTAL
Note:
(1) Turnovers conservatively estimated at 1 per month.
(2) Emissions from tanks (except TK-1) are assumed to be insignificant due to the low vapor pressures of the contents and the low annual throughput.
Spreadsheet: 01089cf2-2929-4790-b351-9e92f2a86ba5
Sheet: NP Child Find

 | Non-Public Child Find
 | School District:
 | Reviewer:
 | Date:
 | Purpose:
 | - LEAs are required to do child find with non publics in their boundaries (not  paid with proportionate share amount)
 | - Each LEA must maintain in its records ;
 | 1.) | the number of children evaluated
 | 2.) | the number of children determined to be children with disabilities
 | 3.) | the number of children served
 | 4) | the district is able to document its timely consultation with non-public schools
 | ATTRIBUTES
 | A | B | C | D | COMMENTS
Participating NP
 | Legend
 | Y | Attribute Satisfied
 | N | Attribute Not Satisfied
 | N/A | Attribute Not Applicable
 | Attributes
 | A | The LEA maintains in its records the number of children evaluated.
 | B | The LEA maintains in its records the number of children determined to be SWD
 | C | The LEA maintains in its records the number of children served
 | D | The LEA held timely consultation with NP as noted in the NS3 documentation
Spreadsheet: ca661c3f-7553-46be-940b-0d2c8d7d71de
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
FFTHC | Test | FFTHC | THC (Tetrahydrocannabinol) Confirmation | THC (Tetrahydrocannabinol), Serum | Gas Chromatography-Mass Spectrometry (GC-MS) | Plain, Red-Top Tube: Red OR |  |  | 5 | mL | Submit only 1 of the following specimens:   Plasma Draw blood in a green-top (sodium heparin) tube(s), plasma gel tube is not acceptable. Spin down and send 5 mL sodium heparin plasma refrigerated in plastic vial.   Serum Draw blood in a plain, red-top tube(s), serum gel tube is not acceptable. Spin down and send 5 mL of serum refrigerated in plastic vial. | 2 mL | Hemolysis	NA Thawing	Cold OK; Warm reject Lipemia	NA Icterus	NA Other	NA | Units:  ng/mL  This specimen was handled by Medtox Laboratories as a forensic specimen under chain of custody protocol. Compound identification for positive specimens is performed by GC/MS.   Test Performed by: Medtox Laboratories, Inc.                              402 W. County Road D                              St. Paul, MN 55112 | Monday through Sunday | 5 days | 7 - 9 days | 1 | 82491 |  |  |  |  | Medtox Laboratories, Inc.
FFTHC | [NAME] | VARIES | Varies |  |  |  | Refrigerated | 14 days
FFTHC | Result | Z1164 | Tetrahydrocannabinol (THC) | Tetrahydrocannabinol (THC) | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FFTHC | Result | Z1136 | Carboxy-THC | Carboxy-THC | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: john_griffith__15653__Book1
Sheet: Sheet1

 |  |  | Natural Gas Straddles
 | Month | Strike | Bid | Offer | Mid-Pt. Vol | Net Change
 | M | 4.25 | 0.35 | 0.38 | 0.4984999999999989 | -0.0413999999999955
 | N | 4.3 | 0.63 | 0.66 | 0.5179999999999987 | -0.01979999999999782
 | Q | 4.35 | 0.84 | 0.86 | 0.534099999999998 | -0.006299999999999306
 | U | 4.4 | 1.01 | 1.03 | 0.5358999999999986 | -0.008399999999999075
 | V | 4.45 | 1.16 | 1.2 | 0.5510999999999975 | -0.002399999999999736
 | X | 4.6 | 1.33 | 1.37 | 0.5534999999999985 | -0.0005999999999999339
 | Z | 4.8 | 1.53 | 1.58 | 0.5671999999999972 | 0.000299999999999967
 | F | 4.85 | 1.68 | 1.71 | 0.5722999999999977 | 0.0008999999999999009
 | G | 4.7 | 1.72 | 1.75 | 0.5692999999999984 | 0.0005999999999999339
 | H | 4.55 | 1.56 | 1.61 | 0.5128999999999982 | -0.001499999999999835
 | J | 4.2 | 1.18 | 1.25 | 0.4051999999999979 | 0.001199999999999868
 | K | 4.15 | 1.1 | 1.2 | 0.376399999999999 | 0.008699999999999042
 |  |  | 2001-05-09 15:15:03.790000
Spreadsheet: 680195d1590852302-index-match-for-less-than-match-type-index-match_match-type
Sheet: Sheet2

 |  | 2020-05-31 00:00:00 | 2020-04-30 00:00:00 | 2020-03-31 00:00:00 | 2020-02-29 00:00:00 | 2020-01-31 00:00:00
small | haha | 12 | 34 | 56 | 98 | 85
medium | hehe | 78 | 89 | 910 | 54 | 52
large | hoho | 1112 | 1314 | 1516 | 321 | 63
Less than |  | With 2 criteria |  | With 3 criteria
criteria 1 | haha
criteria 2 | small
criteria 3 | 2020-03-30 00:00:00
Spreadsheet: daren_farmer__5989__Enron Nom Change
Sheet: Sheet1

To:   [NAME]          (Enron) |  |  |  |  |  | Phone: | (713) 853-9272
From:  Jan Svajian      ([NAME]) |  |  |  |  |  | FAX: | (713) 646-2391
Date:  6/16/00 |  |  |  |  |  | E-Mail: | [EMAIL]
Subject:  New Well Nomination for June 16th
Effective Date | CTP NAME | Gross Vol. (MMBtu/d) | DBQ Available | Excess Available | First of the month original nomination |  | Pipeline affected
2000-06-16 00:00:00 | Garza Plant | 6694 | 6158 | 536 | 4694 |  | TEJAS
A new well has been added to the Garza/Trevino Plant volume.  The well first came on late afternoon
June 15th.  It is expected to increase in volume over the next few days.  An updated nom will be
provided next week.
Spreadsheet: 169249d1342745352-pivot-table-excel-2003-suppress-zero-values-testpivot-ver-3
Sheet: Sheet1

DateRange | DataRange |  |  |  |  |  | DESIRED DISPLAY:
2000-01-31 00:00:00 | 10
2001-01-31 00:00:00 | 100 |  |  |  |  |  | Sum of Field1
2001-01-31 00:00:00 | -100 |  |  |  |  |  | DateRange | Total
2002-01-31 00:00:00 | 2000 |  |  |  |  |  | 2000-01-31 00:00:00 | 10
2002-01-31 00:00:00 | 2000 |  |  |  |  |  | 2002-01-31 00:00:00 | 2000
2002-01-31 00:00:00 | -2000 |  |  |  |  |  | Grand Total | 2010
2003-01-31 00:00:00 | 30000
2003-01-31 00:00:00 | -30000
 |  |  | CURRENT PIVOT TABLE
 | 8 |  | Sum of Field1
 | 5 |  | DateRange | Total
 |  |  | 2000-01-31 00:00:00 | 10
 |  |  | 2001-01-31 00:00:00 | 0
 |  |  | 2002-01-31 00:00:00 | 2000
 |  |  | 2003-01-31 00:00:00 | 0
 |  |  | Grand Total | 2010
Spreadsheet: darrell_schoolcraft__7326__imball0202
Sheet: SoCal

 | 10487 |  | 56697
Day | Measured | Scheduled | Measured | Scheduled
1 | -612464 | -611587
2 | -602028 | -603119
3 | -605205 | -615801
4 | -600868 | -601843
5 | -593916 | -602338
6 | -575011 | -571740
7 | -669282 | -667521
8 | -671065 | -664800
9 | -571431 | -572711
10 | -571738 | -572576
11 | -563485 | -560934
12 | -581906 | -589362
13 | -571728 | -541916
14 | -592118 | -607600
15 | -631385 | -629596
16 | -650691 | -642137
17 | -643787 | -645105
18 | -627703 | -630123
19 | -614723 | -633922
20 | -630010 | -626564
21 | -603746 | -615885
22 | -530120 | -532986
23 | -464082 | -462576
24 | -499408 | -498282
25 | -478849 | -472622
26
27
28
29
30
31
2002-01-31 00:00:00 |  |  |  |  | 94012
2002-02-24 00:00:00
CBS Dollars
 |  |  | 310268
Spreadsheet: lisa_gang__22313__ENA_PGE_JUNE_6_2002
Sheet: JD-MAL OR CPTJK TRANS

From: | EPMI
To: | PGE System Transactions
Date: | 2002-06-06 00:00:00
Total Transmission
HE
ENDING | PGE TRANNY | PGE TRANNY | PGE TRANNY | PGE TRANNY | TOTAL
Pacific Prevailing
Time | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | [NAME] USED
(PPT) |  |  |  |  | Total In To PGE Trans
0100 | 0 | 0 | 0 | 0
0200 | 0 | 0 | 0 | 0
0300 | 0 | 0 | 0 | 0
0400 | 0 | 0 | 0 | 0
0500 | 0 | 0 | 0 | 0
0600 | 0 | 0 | 0 | 0
0700 | 75 | 25 | 25 | 25
0800 | 75 | 25 | 25 | 25
0900 | 75 | 25 | 25 | 25
1000 | 75 | 25 | 25 | 25
1100 | 75 | 25 | 25 | 25
1200 | 75 | 25 | 25 | 25
1300 | 75 | 25 | 25 | 25
1400 | 75 | 25 | 25 | 25
1500 | 75 | 25 | 25 | 25
1600 | 75 | 25 | 25 | 25
1700 | 75 | 25 | 25 | 25
1800 | 75 | 25 | 25 | 25
1900 | 75 | 25 | 25 | 25
2000 | 75 | 25 | 25 | 25
2100 | 75 | 25 | 25 | 25
2200 | 75 | 25 | 25 | 25
2300 | 0 | 0 | 0 | 0
2400 | 0 | 0 | 0 | 0
 | BPA(G)24966 | BPA(G)24966 | BPA(G)24661 | BPA(G)24718
 | BPA(T)SYS/JD | BPA(T)SYS/JD | BPA(T)SYS/JD | BPA(T)SYS/JD
 | AEP | AEP | AEP | AEP
 | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE)
 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5
 | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE)
 | AEP | AEP | AEP | AEP
 | MID | SNCL | MORGAN | SDGE
 | MID(T)CPJK/TRACEY/WESLEY | ISO(T)CPJK/NP15 | PUGET | ISO(T)MALIN/NP15
 | MID(L)WESLEY | SNCL(L)NP15 | CORAL | SDGE(L)NP15
 |  |  | ISO(T)MALIN/NP15
 |  |  | [NAME]
Spreadsheet: 738846d1625281217-calculating-running-average-cost-example_avg_cost-warehouse-approach-v2-2-
Sheet: Version4

Limits:
Trade Symbol | Transaction | Date | [NAME] | Quantity | Price | Fees | Total Cost | Needed for correct cumulative average cost value |  | Cumulative Units | Cumulative Average Cost | Current Balance (FIFO) | Sales Only -  Separated for RAW data |  | Gain (Loss) P & L | Notes
 | Purchase | 2021-02-22 00:00:00 |  | 3.514923 | 14.21 | 0
 | Purchase |  |  | 1.95554 | 12.8 | 0
 | Purchase | 2021-02-23 00:00:00 |  | 2.121327 | 11.78 | 0
 | Purchase | 2021-03-24 00:00:00 |  | 374.242645 | 13.45 | 0
 | Sale-All | 2021-03-29 00:00:00 | Short | -381.834442 | 13.34 | 0
 | Purchase | 2021-04-17 00:00:00 |  | 13.380624 | 37.72 | 0
 | Purchase |  |  | 12.706329 | 39.39 | 0
 | Purchase | 2021-04-27 00:00:00 |  | 28.600846 | 35.18 | 0
 | Purchase | 2021-05-04 00:00:00 |  | 74.626678 | 67.52 | 0
 | Purchase |  |  | 270.208195 | 74.56 | 0
 | Sale-All | 2021-05-04 00:00:00 | Short | -399.522672 | 78.52 | 0
 | Purchase | 2021-05-04 00:00:00 |  | 179.734944 | 84.04 | 0
 | Purchase | 2021-05-05 00:00:00 |  | 49.622456 | 101.4 | 0
 | Purchase |  |  | 246.20782 | 102.55 | 0
 | Purchase |  |  | 165.37101 | 103.4 | 0
 | Sale-All | 2021-05-05 00:00:00 | Short | -640.93623 | 104.18 | 0
 | Purchase | 2021-05-05 00:00:00 |  | 30.301633 | 99.03 | 0
 | Purchase | 2021-05-06 00:00:00 |  | 276.819944 | 145.41 | 0
 | Sale-All | 2021-05-06 00:00:00 | Short | -307.121577 | 168.49 | 0
 | Purchase | 2021-05-06 00:00:00 |  | 277.1079 | 182.23 | 0
 | Purchase |  |  | 138.149505 | 182.77 | 0
 | Sale-Partial | 2021-05-08 00:00:00 | Short | -107.381606 | 127.43 | 0 |  |  |  |  |  |  |  |  |  | Should be a positive number, not a negative … here is where things get complicated…
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | How do we show in L26 that the average cost is $182.41 after making a partial sale here?  No additional purchases were made after 5/6 that would change this number here, and selling a partial amount out of the total buy-in does not change on average what your cost was per share.  Think of this as whats in the past is the past and you can't change the past.  We wouldn't be facing this problem here if all quantity was sold out on 5/8...
Totals: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Also, how do we get P26 to show a value that represents a portion of the loss based on the fact that this partial sale was done to minimize some of the losses when the price dropped $55 per share?  That value should equate to somewhere around $5000.00
Spreadsheet: 808409d1670441716-formula-to-look-in-a-number-column-and-find-a-certain-type-of-number-sample-8-
Sheet: Sheet2

 | 14
AAA-AMC | 18
AMC Settlement Services | 236
American Valuation Corp | 996
AMSA | 285
[NAME] Services | 82
Appraisal House USA | 667
[NAME] | 6
Appraisal Management Solutions | 169
Appraisal MC | 34
Appraisal Unlimited Management Group | 972
AppraisalTek | 493
[NAME] | 721
[NAME] | 9
AssetVal Valuation Solutions | 112
Spreadsheet: 775871d1649355469-xlookup-and-countifs-countifs-help
Sheet: TechHrs

 | PAYROLL PERIOD: | 2022-03-14 00:00:00 |  |  | THRU
Tech # | Employee Name | MON | TUE | WED | THR | FRI | SAT | SUN | Total Hours
1 | Employee 1
2 | Employee 2
3 | Employee 3
4 | Employee 4
6 | Employee 5
23
24
25