tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 862406d1710155048-find-all-10-digit-in-a-matrix-and-sum-it-sum-10-digit-numbers
Sheet: Blad1

[PHONE] | 1 | 100 |  |  |  | SUM ALL ROWS in C-column
[PHONE] | 2 | 200 |  |  |  | based in rows in A-column that has
[PHONE] | 3 | 300 |  |  |  | 10 digits
[PHONE] | 4 | 400
E3324567 | 5 | 500 |  |  |  | Which means that rows in this case shoul be Sum
ABC1234 | 6 | 600
 |  |  |  |  |  | A1+A2+A3+A4
Spreadsheet: 126069d1319505264-offset-and-match-on-3-variables-template_dashboard_080811
Sheet: Lookup

 | Instructions: Lookup information, do not edit this spreadsheet directly, all values are automatically derived from the two WebDataSegments pages 1) Change column names of Succes Event 1 through Success Event 3 to your liking
Control Limits | New Visitors | Returning Visitors | Unique Visitors | Visits | Visits/Visitor | Single Page Visits | [NAME] | Page Views | Page Views/Visits | Customers | Orders | Items | Items/Order | Revenues | Average [NAME] | eCommerce Conversion | Success Event 1 | Success Event 2 | Success Event 3 | Success Rate
Upper Limit
Average
Lower Limit
Month Offset | New Visitors | Returning Visitors | Unique Visitors | Visits | Visits/Visitor | Single Page Visits | [NAME] | Page Views | Page Views/Visits | Customers | Orders | Items | Items/Order | Revenues | Average [NAME] | eCommerce Conversion | Success Event 1 | Success Event 2 | Success Event 3 | Success Rate
-12
-11
-10
-9
-8
-7
-6
-5
-4
-3
-2
-1
0
Spreadsheet: 769782d1645685216-filter-function-with-scroll-bar-book1
Sheet: Dashboard

 | Trading Portfolio |  |  |  |  |  |  | NIFTY |  |  | SENSEX
 |  | Realised Profit / Loss |  |  |  |  |  |  | Summary |  |  |  |  |  |  | Sectorwise Holding
 |  | Stocks | Quantity | Buy | Sell | Profit / Loss |  |  | Investment:
 |  |  |  |  |  |  |  |  | Networth:
 |  |  |  |  |  |  |  |  |  | Day Loss | (Unrealised):
 |  |  |  |  |  |  |  |  |  | Profit / Loss | (Unrealised):
 |  |  |  |  |  |  |  |  |  | Holding Profit / Loss | (Realised):
 |  |  |  |  |  |  |  |  |  | Overall Profit / Loss | (Realised):
 |  |  |  |  |  |  |  |  | Total Gains |  | t   u | Total Losses
 |  | Holding Stocks
 |  | Stocks | Quantity |  | Investment |  |  |  | Current Market |  |  |  |  |  |  | Unrealised P/L |  | Realised P/L
 |  |  | Total | Long Term | Price | Value |  | % | Price | Value | % | Change | Change % |  | Day Gain | Value | % | Value
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
Spreadsheet: 122781d1317144310-excel-2007-summing-a-column-based-on-multiple-criteria-in-2-other-columns-example
Sheet: Summary

Owner | AA
Hardware
Software
Lease
Total
Owner | BB
Hardware
Software
Lease
Total | 30
Owner | CC
Hardware
Software
Lease
Total
Owner | DD
Hardware
Software
Lease
Total
Owner | Total
Hardware
Software
Lease
Total
Spreadsheet: 810637d1671905425-filtering-data-with-search-box-option-search-sample-file-1-
Sheet: FILTERED DATA

FILTERED DATA
SEARCH |  |  | R
TOTAL :
Sl. No. | Regd. No. | HS ROLL NO. | Name | Father's Name | Class | Sec. | Roll No. | Sex | Lang. 1 | Lang. 2 | Comp. Elec. 1 | Comp. Elec. 2 | Comp. Elec. 3 | Opt. Elec.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | > DUPLICATE
Spreadsheet: 751732d1634288501-calculate-and-count-occurrences-across-multiple-non-adjacent-columns-and-multiply-earnings
Sheet: WEEK 2

 |  |  | Monday | Monday |  | Tuesday | Tuesday |  | Wednesday | Wednesday |  | Thursday | Thursday |  | Friday | Friday
 |  |  | Morning | Afternoon |  | Morning | Afternoon |  | Morning | Afternoon |  | Morning | Afternoon |  | Morning | Afternoon
 | Location 1 |  |  |  |  | Volunteer 1 |  |  | Volunteer 1 |  |  | Volunteer 1 |  |  | Volunteer 1
 | Location 2 |  |  | Volunteer 11 |  |  | Volunteer 11 |  |  | Volunteer 11 |  |  | Volunteer 11 |  |  | Volunteer 11
 | Location 3 |  | Volunteer 6 |  |  | Volunteer 6 |  |  | Volunteer 6 |  |  | Volunteer 6 |  |  | Volunteer 6
 | Location 4
 | Location 5 |  |  | Volunteer 2 |  |  | Volunteer 2 |  |  | Volunteer 2 |  |  | Volunteer 2 |  |  | Volunteer 2
 | Location 6
 | Location 7 |  | Volunteer 10 |  |  | Volunteer 10 |  |  | Volunteer 10 |  |  | Volunteer 10 |  |  | Volunteer 10
 | Location 8
 | Location 9
 | Location 10 |  | Volunteer 4 |  |  | Volunteer 4 |  |  | Volunteer 4 |  |  | Volunteer 4 |  |  | Volunteer 4
 | Location 11
 | Location 12 |  | Volunteer 1
 | Location 13 |  |  | Volunteer 7 |  |  | Volunteer 7 |  |  | Volunteer 7 |  |  | Volunteer 7 |  |  | Volunteer 7
 | Location 14 |  | Volunteer 5 |  |  | Volunteer 5 |  |  | Volunteer 5 |  |  | Volunteer 5 |  |  | Volunteer 5
 | Location 15
 | Location 16
 | Location 17
 | Location 18
Spreadsheet: 854425d1704304670-sorting-issue-cells-picking-up-as-smallest-number-question
Sheet: Dividend Forecast

 | Sym | Ex Date | # Days | Pay Date | # Days | Gross DVD | Dividend Yield | Impact (bps) | Next EST DVD Ex Date | # Days | Next EST Gross DVD
 | AAPL | 00:00:00 | - | 2024-02-12 00:00:00 | 40 | 0.003559 | 0.03753289119485154 | 12.01988378026297 | 2024-02-01 00:00:00 | 29 | 0.003586304838208669
 | GOOG | 00:00:00 | - | 2024-01-19 00:00:00 | 16 | 0.05 | 0.00854082335389016 | 1.993726901536703 | 2024-05-28 00:00:00 | 146 | 0.2
 | MSFT | 2024-03-28 00:00:00 | 85 | - | - | 0 | 0.0174042764793635 | 6.329563382563311 | 2024-03-28 00:00:00 | 85 | 55
 | NFLX | 00:00:00 | - | - | - | 98 | 0.1160714285714286 | 24.26566200297814 | 2024-05-07 00:00:00 | 125 | 545
 | GE | 00:00:00 | - | 2024-03-27 00:00:00 | 84 | 0.5478593 | 0.07788027690278865 | 24.5821518328608 | 2024-04-30 00:00:00 | 118 | 0.2235090834011069
 | URI | 00:00:00 | - | - | - | 0.176147 | 0.04848439794429441 | 14.4010611786584 | 2024-06-11 00:00:00 | 160 | 0.8747652110147877
 | PFE | 00:00:00 | - | - | - | 1.47 | 0.1195052723088247 | 27.54536708318149 | 00:00:00 | 0 | -
 | BMY | 00:00:00 | - | - | - | 4.25 | 0.06335616438356165 | 13.76870234353159 | 2024-02-14 00:00:00 | 42 | 5
 | BABA | 00:00:00 | - | - | - | 25 | 0.04602604906780736 | 11.26265319491647 | 2024-05-16 00:00:00 | 134 | 30
 | SHOP | 00:00:00 | - | - | - | 264.66838 | 0.04338825663582224 | 15.89910942427183 | 2024-03-18 00:00:00 | 75 | 317.602
 | MCD | 00:00:00 | - | - | - | - | 0.03731343283582089 | 12.32283275979022 | 2024-02-08 00:00:00 | 36 | 3500
 | BTC | 00:00:00 | - | - | - | - | - | - | 00:00:00 | 0 | -
 | UPST | 00:00:00 | - | - | - | - | - | - | 00:00:00 | 0 | -
 | DOCN | 00:00:00 | - | - | - | - | - | - | 00:00:00 | 0 | -
 | GILD | 00:00:00 | - | - | - | - | - | - | 00:00:00 | 0 | -
Spreadsheet: 885401d1734951619-pivot-table-issue-resend-log-copyv3
Sheet: MOM

Feb
Row Labels | Sum of Value of resent products £ | Count of orders
Carrier Damaged | 1282.2 | 7
[NAME] | 9.99 | 1
Incorrect Item Received | 345.98 | 3
[NAME] from Order | 69.94 | 2
Lost in Transit | 449.91 | 5
Order processed but not shipped | 1364.18 | 10
Product Issue - Fault | 318.97 | 1
Grand Total | 3841.169999999999 | 29
March
Row Labels | Sum of Value of resent products £ | Count of orders
Carrier Damaged | 3437.719999999998 | 15
[NAME] | 683.77 | 7
Incorrect Item Received | 536.91 | 6
[NAME] from Order | 1206.89 | 8
Lost in Transit | 2985.75 | 8
Order processed but not shipped | 1216.38 | 5
Other (please add to comments) | 4.99 | 1
Product Issue - Colour Match | 449.97 | 2
Product Issue - Damaged | 310.96 | 5
Product Issue - Fault | 149.97 | 2
Grand Total | 10983.30999999999 | 59
Spreadsheet: 819669d1677625619-convert-false-result-with-0-overtime
Sheet: February

Day | Date | Hrs | Type | Hrs to be paid | [NAME]
Wednesday | 2023-02-01 00:00:00 | 6 | Standard
Thursday
Friday |  | 4 | Standard
Saturday
Sunday
Monday |  | 5 | AL Holiday
Tuesday |  | 7 | US Holiday
Wednesday
Thursday
Friday |  | 5 | AL Holiday
Saturday
Sunday
Monday
Tuesday
Wednesday |  | 6 | Standard
Thursday
Friday |  | 4 | AL Holiday
Saturday
Sunday
Monday
Tuesday
Wednesday |  | 1 | Standard
Thursday
Friday
Saturday
Sunday |  | 4 | Standard
Monday
Tuesday
Spreadsheet: 717177d1612522767-using-countif-to-do-a-sequential-count-based-on-three-matched-columns-sample
Sheet: Sheet1

 | LINE | W/O ID | Qtr | Stoppage ID
 | 1 | A | 1ST
 | 2 | B | 1ST
 | 3 | C | 1ST
 | 4 | B | 2ND |  |  | These two columns have matched data and the =COUNTIF() has correctly returned 2
 | 5 | E | 1ST
 | 1 | A | d/t
 | 1 | A | 2nd
 | 8 | H | 1ST
 | LINE | W/O ID | Qtr | Stoppage ID
 | 1 | A | 1ST
 | 2 | B | 1ST
 | 3 | C | 1ST
 | 4 | B | 2ND |  |  | If I change D20 to not match then the =COUNTIF() adjusts correctly to 1
 | 5 | E | 1ST
 | 1 | A | 1st
 | 1 | A | D/T
 | 8 | H | 1ST
 | LINE | W/O ID | Qtr | Stoppage ID
 | 1 | A | 1ST
 | 2 | B | 1ST
 | 3 | C | 1ST |  |  | If I swap the data in [NAME] and D32 than the = COUNTIF() returns an inncorect value of 1 in both rows
 | 4 | B | 2ND
 | 5 | E | 1ST
 | 1 | A | D/t
 | 1 | A | 1st
 | 8 | H | 1ST
Spreadsheet: 747326d1631387266-help-with-creating-a-price-comparison-database-price-comparison-by-year
Sheet: Sheet1

Product | Date effective | Price | % change
AA | 2021-02-01 00:00:00 | 10.2
BB | 2021-04-15 00:00:00 | 11.89
CC | 2021-07-16 00:00:00 | 78
AA | 2021-06-25 00:00:00 | 11.5
BB | 2021-06-26 00:00:00 | 12.77
CC | 2021-06-27 00:00:00 | 83.28
DD | 2021-06-28 00:00:00 | 13.79
BB | 2021-06-29 00:00:00 | 12.63
CC | 2021-06-30 00:00:00 | 10.04
AA | 2021-12-01 00:00:00 | 14.03
DD | 2021-12-02 00:00:00 | 15
 |  |  |  | Product | Price Now | 2021 |  | 2020 |  | 2019
 |  |  |  | Coke | 1.21 | 2021-09-11 00:00:00 | 1.21 | 2020-11-07 00:00:00 | 1.14 | 2019-08-09 00:00:00 | 1.05
 |  |  |  |  |  | 2021-05-05 00:00:00 | 1.2 | 2020-07-06 00:00:00 | 1.1 | 2019-04-03 00:00:00 | 1.01
 |  |  |  |  |  | 2021-09-03 00:00:00 | 1.15
Spreadsheet: 26635810-5fa9-4258-bd7f-77a1822f7845
Sheet: Sheet1

contract no.: | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Contract title:
goods
services
construction
[NAME]
Contractor Address:
[NAME]:
DBA, if applicable:
Contractor signatory authority:
Contact name:
Contact phone:
Contact email:
Start Date:
End Date:
No. of extensions: |  | To:
Contract Expiration:
120 days before:
90 days before:
60 days before:
30 days before:
Comments:
Amendments:
 | Description |  | Number | Date
[NAME] requirements:
 |  | Rec'd | Effective | Expires
Insurance:
license:type:
Compliance check:
Milestone/Deliverables:
 | Description |  | Target date | Completed
Monitoring:
Ongoing service/delivery over period of time:
schedule of dates check to with end users |  |  | scheduled | received
Spreadsheet: 64702d1265502312-complex-calculations-competition-partisipants-and-scores-09-10
Sheet: September

September Competition - OPEN |  |  |  |  | 50 | Total Partisipants |  |  | 0.6063797313797313 | want to see edits
Beginners | Image | Score | Place | Edit | 21 | 0.8095238095238095
Agnieszka Szczurowska | I Have My Eyes on You | 15 | 1 | X
[NAME] | "Smoke 'em If You Got 'em" | 14 | 5 | X
[NAME] | Ready for Launch | 12 | 19 | X
[NAME] | The Cabin | 13 | 9 | X
[NAME] | Busy Bee | 14 | 3
[NAME] | Morning Light | 13 | 8 | X
[NAME] | Drift Wood | 14 | 2 | X
[NAME] | Who U Looking at? | 13 | 7 | X
[NAME] | [NAME] | 12 | 18 | X | * | edit audio
[NAME] | Parking Patterns | 14 | 4 | X
[NAME] | Watermelons and Canned Vegetables | 11 | 21
[NAME] | Sunflower | 13 | 11
[NAME] | Who Dat? | 13 | 10 | X
[NAME] | Monolith | 12 | 17 |  | * | increase dark background
[NAME] | [NAME] | 12 | 16 | X |  | Edit audio
[NAME] | Mount Rushmore | 11 | 20 | X
[NAME] | Shark Aquarium | 12 | 15 | X
[NAME] | Red Tail Hawk | 12 | 12 | X
[NAME] | [NAME] | 12 | 14 | X
[NAME] | Fun in the Water | 14 | 6 | X
[NAME] | Forever Love | 12 | 13 | X
Advanced | Image | Score | Place | Edit | 16 | 0.625
[NAME] | Mexican Officer at the Alamo | 11 | 16 | X | *
[NAME] | [NAME] | 11 | 15
[NAME] | Water Flower | 11 | 14 | X
[NAME] | Wonder in the Details | 11 | 13 | X
[NAME] | Hot Air Flirt | 12 | 12
[NAME] | New Mexico Bird | 13 | 11 | X |  | Edit audio, she mentions about sex of bird , who cares.
[NAME] | Bull Elk | 13 | 10 | X
[NAME] | Blueberry's  (sp) | 13 | 9
[NAME] | Sunset Frolic | 13 | 8 | X
[NAME] | The Long Pier | 14 | 7 | X
[NAME] | It's A Hit! | 14 | 6 | X
[NAME] | [NAME] in Seligman, AZ | 14 | 5
[NAME] | Renaissance in Old Montreal | 14 | 4 | X
[NAME] | Crystal City Mill | 14 | 3
[NAME] | Ascension | 14 | 2 | X
[NAME] | Summer Flower | 15 | 1
Masters | Image | Score | Place | Edit | 13 | 0.3846153846153846
[NAME] | [NAME] | 11 | 13
[NAME] | Santa Fe Window | 13 | 12
[NAME] | City through Window Walkway | 13 | 11 | X | * | crop little girl off right side
[NAME] | Responsible | 13 | 10 | X
[NAME] | Lone Star Barn | 13 | 9
[NAME] | Orange Spring Mound | 13 | 8 | X
[NAME] | Bird on a Perch | 14 | 7 | X
[NAME] | Orange Roses | 14 | 6
[NAME] | Sandhill Cranes Takeoff | 14 | 5
[NAME] | Egyptian Temple | 14 | 4
Eleanore Avery | [NAME] in Winter Pool ll | 14 | 3
[NAME] | Mr. [NAME] | 14 | 2 | X
[NAME] | Tulip | 15 | 1
Spreadsheet: 4215f31d-302d-41d3-9dfb-e07ffba77426
Sheet: Locomotives 1900-1965

# | Manufacturer | Year | Type | Notes
6 | General Electric | 1914
7 | General Electric | 1914
8 | [NAME] | 1943 |  | #8 ex-US Army Transportation Corps #7983. Might have been sold to a mining railroad in Michigan.
9 | [NAME] | 1943 |  | #9 ex-US Army Transportation Corps #7980; to Johnstown & Stony Creek RR #3; to NYCTA in 1961 renumbered #9; renumbered #20000 (June 1966); presently at Trolley Museum of NY, Kingston, NY.
10 | General Electric | 1959 | 35T one truck | Originally used for Speno Rail Grinder work train. 10 - renumbered 20006 (June 1966). Operational, part of NY Transit Museum collection, located either at the museum or Coney Island Yard depending on what cars are at the museum.
11 | General Electric | 1959 | 35T one truck | Originally used for Speno Rail Grinder work train. 11 - renumbered 20007 (June 1966).  Scrapped December 2000.
12 | General Electric | 1948 | 70T | Purchased by NYCTA in 1961; #12 ex-Claremont and Concord
13 | General Electric | 1948 | 70T | Purchased by NYCTA in 1961; #13 ex-Hoosac Tunnel and Wilmington
41 | Magor | 1932 | R-3 Drill Motor | #41 was sold to the Trolley Museum of New York in 1978, but remained in New York City, first on loan to the New York Transit Museum, then later under the care of the Railway Preservation Corp. In 2008, the car was sold from the museum to the RPC. It is still at Coney Island Yard.
42 | Magor | 1932 | R-3 Drill Motor | #42 was in a collision in 1948 and remained in storage until 1955 at 207th St Yard, at which time it was scrapped.
62 | Pressed Steel | 1906 | IRT Drill Motor | Utilized for switching IRT equipment around the shops. At Shore Line Trolley Museum, East Haven, CT.
# | Manufacturer | Year | Type | Notes
9421 | Middletown | 1903 | [NAME] | Presently at Shore Line Trolley Museum.
9425 | Middletown | 1903 | [NAME] | Was at Shore Line Trolley Museum, now at Middletown & Hummelstown RR
1 | Brooklyn Heights RR | 1904 | [NAME] | #1 scrapped 1955
2 | Brooklyn Heights RR | 1904 | [NAME] | #2 scrapped 1947(?)
3 | Brooklyn Heights RR | 1904 | [NAME] | #3 scrapped 1954
4 | Brooklyn Heights RR | 1907 | [NAME] | Presently located at Shore Line Trolley Museum.
5 | GE/Alco | 1910 | [NAME] | 1960s number 20002. Part of New York Transit Museum historic fleet. #5 was overhauled in 1998.
6 | Geneal Electric | 1921 | [NAME] | 1960s number 20003. Part of New York Transit Museum historic fleet. #6 was overhauled in 2002.
7 | GE/Westinghouse | 1926 | [NAME] | 1960s number 20004. Part of New York Transit Museum historic fleet. #7 is the only locomotive on TA property to still have trolley pole.
Spreadsheet: 828625d1683644371-rent-roll-calculation-rental-revised-2-1-ans2
Sheet: Rent Roll 

Year | 2022
Monthly Rental |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | New End Date | Termination Date | Rent Free |  | Backdated Rental |  | Amount (+ xx, increase;  - xx, reduce)
Floor | Shop | Tenant | Area |  |  |  | Start | End | Terminate |  |  |  | Rental |  |  |  |  |  |  |  |  |  |  |  | Start | End | Start | End | $ | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00
B2 | 1 | ABC | 1216 | qtr1 |  |  | 2020-12-16 00:00:00 | 2023-05-02 00:00:00 |  |  |  |  | 100 |  |  |  |  |  |  |  |  |  |  |  | 2020-12-16 00:00:00 | 2021-01-15 00:00:00
 |  | xyz |  | qtr2 |  |  | 2021-01-25 00:00:00 | 2024-12-31 00:00:00 |  |  |  |  | 150 |  |  |  |  |  |  |  |  |  |  |  | 2021-02-01 00:00:00 | 2021-03-20 00:00:00
B2 | 2 | DEF | 450 | qtr1 |  |  | 2022-01-01 00:00:00 | 2023-07-15 00:00:00 |  |  |  |  | 2000 |  |  |  |  |  |  |  |  |  |  |  | 2022-01-01 00:00:00 | 2022-02-28 00:00:00 | 2022-07-01 00:00:00 | 2022-08-31 00:00:00 | -300
 |  | scr |  | qt2 |  |  | 2019-07-20 00:00:00 | 2023-04-19 00:00:00 |  |  |  |  | 3000 |  |  |  |  |  |  |  |  |  |  | 2022-04-02 00:00:00
 |  | sdf |  | qtr3 |  |  | 2020-07-20 00:00:00 | 2022-12-02 00:00:00 |  |  |  |  | 4000
 |  | rty |  | qtr4 |  |  | 2021-07-20 00:00:00 | 2022-03-19 00:00:00 |  |  |  |  | 5000
Spreadsheet: cara_semperger__1437__PGE_NOVEMBER_MIDC_PATHS
Sheet: NOV (6)

 |  |  | 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-06 00:00:00
 | HLH
 | DAY | 10 | PSPL(G)MIDC | X | PINWEST | ENRON | PGE | X | COLSTRIP B/R
 | DAY | 5 | [NAME] #10710NF-EWEB | X | AQUILA | ENRON | PGE | X | COLSTRIP B/R
 | DAY | 7 | PACW(G)MIDC | X | PACW | ENRON | PGE | X | COLSTRIP B/R
 | MONTH | 25 | AVISTA(G)CHELAN | X | AVISTA | ENRON | PGE | X | COLSTRIP B/R
 | LLH
 | DAY | 22 | [NAME] MPC(T)COLSTRIP/BURKE #[NAME]-AVA(T)BURKE/PGE #NF | X | DETM | 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: tori_kuykendall__39967__DailyPrices
Sheet: Price Sheet

 | Gas Daily Prices
 |  |  |  |  |  |  |  |  | MTD Avg. | Prior Year MTD Avg. | Index
Socal
PG&E City Gate
Malin
San Juan
Permian
Waha
Kern River/Opal
Stanfield
Sumas
Aeco
PEPL
Chicago
[NAME]
Socal/SJ
Socal/Perm
Socal/Malin
PG&E/Socal
Rockies/Sumas
SJ/Rockies
Waha/Perm
Waha/SJ
Perm/SJ
PEPL/Perm
PEPL/Rockies
Chicago/Malin
 | Gas Daily Monthly Averages
 | Socal | PG&E City Gate | Malin | San Juan | Permian | Waha | NW, Domestic | Stanfield | Sumas | Aeco | PEPL | Chicago | [NAME]
 | Spreads
 | Socal/SJ | Socal/Perm | Socal/Malin | PG&E/Socal | Rockies/Sumas | SJ/Rockies | [NAME] | Waha/SJ | Perm/SJ | PEPL/Perm | PEPL/Rockies | Chicago/Malin
 | N/A | N/A | N/A | N/A
 |  |  |  | N/A
 |  |  |  | N/A
 |  |  |  | N/A
 | Indicies
 | NGI Socal | IFGMR PG&E City Gate | NGI Malin | IFGMR San Juan | IFGMR Permian | IFGMR TRCO Waha | IFGMR NWPL [NAME] | Stanfield | IFGMR NWPL Spot Canada | Aeco | [NAME]
1998-02-01 00:00:00
 | Index Spreads
 | Socal/SJ | Socal/Perm | Socal/Malin | PG&E/Socal | Rockies/Sumas | SJ/Rockies | [NAME] | Waha/SJ | Perm/SJ
 |  |  |  | N/A
 |  |  |  | N/A
 |  |  |  | N/A
Spreadsheet: 115079d1310712972-complex-connecting-data-between-2-table-table-2-1-
Sheet: Table2

CODE | Aprroval status
5005023287 | Acceptable | Acceptable
5004990694 | Not acceptable | Not acceptable
5005023111 | Acceptable | Acceptable
5004993940 | Acceptable | Acceptable
5004980191 | Acceptable | Acceptable
5004941432 | Acceptable | Acceptable
5004954387 | Not acceptable | Not acceptable
5004955222 | Acceptable | Acceptable
5004955221 | Not acceptable | Not acceptable
5004790257 | Acceptable | Acceptable
5004919296 | Acceptable | Acceptable
5004929785 | Not acceptable | Not acceptable
5004964246 | Acceptable | Acceptable
5004973382 | Not acceptable | Not acceptable
5004993942 | Acceptable | Acceptable
5005002227 | Not acceptable | Not acceptable
5004941375 | Not acceptable | Not acceptable
5004941477 | Acceptable | Acceptable
5004962365 | Acceptable | Acceptable
5004964435 | Acceptable | Acceptable
5004970071 | Acceptable | Acceptable
5005008221 | Not acceptable | Not acceptable
5005012458 | Not acceptable | Not acceptable
5004957073 | Acceptable | Acceptable
5004955209 | Acceptable | Acceptable
5005025927 | Not acceptable | Not acceptable
5005025928 | Acceptable | Acceptable
Spreadsheet: 61657d1262600117-combined-and-summary-combined-and-summary-in-pivot
Sheet: Sheet3

Sum of Amount
 | 2010-01-01 - 2010-01-07 | 2010-01-08 - 2010-01-14 | 2010-01-15 - 2010-01-21 | 2010-01-22 - 2010-01-28 | 2010-01-29 - 2010-01-31 | Grand Total
LKT Co., Ltd | 250 | 630 |  |  |  | 880
Titanic Trading |  |  | 100 | 500 | 1410 | 2010
WZT Technology | 500 |  | 200 | 400 |  | 1100
Grand Total | 750 | 630 | 300 | 900 | 1410 | 3990
Spreadsheet: 826254d1681897923-extracting-month-in-mmm-format-from-a-mmm-yy-date-s666-pq-extracting-month-in-mmm-format-from-a-mmm-yy-date
Sheet: Sheet1

2021-11-01 00:00:00 | Nov
2021-12-01 00:00:00 | Dec
2022-01-01 00:00:00 | Jan
Column1 |  | Column1 | Month Name
2022-02-01 00:00:00 |  | 2022-02-01 00:00:00 | Feb
2022-03-01 00:00:00 |  | 2022-03-01 00:00:00 | Mar
2022-04-01 00:00:00 |  | 2022-04-01 00:00:00 | Apr
2022-05-01 00:00:00 |  | 2022-05-01 00:00:00 | May
2022-06-01 00:00:00 |  | 2022-06-01 00:00:00 | Jun
2022-07-01 00:00:00 |  | 2022-07-01 00:00:00 | Jul
2022-08-01 00:00:00 |  | 2022-08-01 00:00:00 | Aug
2022-09-01 00:00:00 |  | 2022-09-01 00:00:00 | Sep
2022-10-01 00:00:00 |  | 2022-10-01 00:00:00 | Oct
2022-11-01 00:00:00 |  | 2022-11-01 00:00:00 | Nov
2022-12-01 00:00:00 |  | 2022-12-01 00:00:00 | Dec
2023-01-01 00:00:00 |  | 2023-01-01 00:00:00 | Jan
2023-02-01 00:00:00 |  | 2023-02-01 00:00:00 | Feb
2023-03-01 00:00:00 |  | 2023-03-01 00:00:00 | Mar
2023-04-01 00:00:00 |  | 2023-04-01 00:00:00 | Apr
Spreadsheet: 846717d1697842607-bringing-shift-pattern-into-a-rolling-calendar-calendar-with-shift
Sheet: Next Year 

Calendar
 | MON | TUE | WED | THU | FRI | SAT | SUN |  | MON | TUE | WED | THU | FRI | SAT | SUN |  | MON | TUE | WED | THU | FRI | SAT | SUN
 | MON | TUE | WED | THU | FRI | SAT | SUN |  | MON | TUE | WED | THU | FRI | SAT | SUN |  | MON | TUE | WED | THU | FRI | SAT | SUN
 | MON | TUE | WED | THU | FRI | SAT | SUN |  | MON | TUE | WED | THU | FRI | SAT | SUN |  | MON | TUE | WED | THU | FRI | SAT | SUN
 | MON | TUE | WED | THU | FRI | SAT | SUN |  | MON | TUE | WED | THU | FRI | SAT | SUN |  | MON | TUE | WED | THU | FRI | SAT | SUN
Spreadsheet: 810460d1671786557-find-and-return-a-value-based-each-date-date-by-rev
Sheet: Main

PartNum | Rev1 | Rev2 | Rev3 | Rev4 | Rev5
100-101-039
100-101-041
100-101-058 | EU02SE | EU03SE | EU04SE | EU05SE | EU06SE
PartNum | Revision 1 | Revision 2 | Revision 3 | Revision 4 | Revision 5
100-101-039 | PJ01SB | PJ02SB
100-101-041 | ZF01JA | ZF0JA
100-101-058 | EU02SE | EU03SE | EU04SE | EU05SE | EU06SE