tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 66f2e0e6-42b7-418e-bc34-9963ef7a17fb
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
42303807 | 2014-07-15 00:03:44 | AXIS | 1 | 6 | 4 | 1351059 | misterfunny | 12494 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
42304068 | 2014-07-15 00:23:47 | ALLIES | 1 | 6 | 4 | 1351059 | misterfunny | 12494 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
42343303 | 2014-07-17 22:26:38 | AXIS | 0 | 4 | 7 | 828272 | hester24 | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
42343482 | 2014-07-17 22:41:26 | ALLIES | 0 | 5 | 7 | 828272 | hester24 | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
42354596 | 2014-07-18 20:49:34 | AXIS | 1 | 6 | 4 | 787691 | TMuscle | 12493 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
42354834 | 2014-07-18 21:12:28 | ALLIES | 0 | 5 | 7 | 1606804 | player1606804 | 7597 | eastern | 1941-10-18 | 1941-10-18 | Gates of Moscow | Aux portes [NAME]
42355077 | 2014-07-18 21:36:18 | AXIS | 1 | 7 | 5 | 1606804 | player1606804 | 7597 | eastern | 1941-10-18 | 1941-10-18 | Gates of Moscow | Aux portes [NAME]
42369944 | 2014-07-19 23:32:22 | AXIS | 1 | 6 | 5 | 1121936 | rodneydangerfield | 6155 | western | 1944-09-19 | 1944-09-19 | Arracourt | Arracourt
42370242 | 2014-07-19 23:54:18 | ALLIES | 0 | 5 | 6 | 1121936 | rodneydangerfield | 6155 | western | 1944-09-19 | 1944-09-19 | Arracourt | Arracourt
42383683 | 2014-07-20 22:21:49 | AXIS | 1 | 6 | 3 | 27020 | [NAME] | 12494 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
42383953 | 2014-07-20 22:39:12 | ALLIES | 0 | 1 | 6 | 27020 | [NAME] | 12494 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
42409223 | 2014-07-22 18:38:45 | AXIS | 0 | 4 | 7 | 1523772 | rice dolar | 12495 | western | 1944-06-23 |  | Battle for Hill 178 | Combat pour la cote 178
42450387 | 2014-07-25 19:38:53 | AXIS | 0 | 2 | 5 | 1610234 | Ted_Hilton | 7665 | pacific | 1942-10-23 | 1942-10-23 | Matanikau River | Rivière Matanikau
42450638 | 2014-07-25 19:50:01 | ALLIES | 1 | 5 | 2 | 1610234 | Ted_Hilton | 7665 | pacific | 1942-10-23 | 1942-10-23 | Matanikau River | Rivière Matanikau
42495683 | 2014-07-28 23:06:45 | ALLIES | 1 | 6 | 3 | 1343508 | [NAME] | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
42495968 | 2014-07-28 23:43:39 | AXIS | 1 | 6 | 5 | 1343508 | [NAME] | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
42506633 | 2014-07-29 18:42:11 | ALLIES | 0 | 3 | 6 | 1611411 | thewand45 | 8708 | western | 1944-07-25 | 1944-07-25 | Operation Spring | Opération Spring
42506755 | 2014-07-29 19:14:17 | ALLIES | 1 | 7 | 5 | 1594632 | azur94 | 7661 | eastern | 1944-02-16 | 1944-02-17 | Breakout to Lisyanka | [NAME]
42507113 | 2014-07-29 19:37:54 | AXIS | 1 | 7 | 6 | 1594632 | azur94 | 7661 | eastern | 1944-02-16 | 1944-02-17 | Breakout to Lisyanka | [NAME]
Spreadsheet: 806494d1669346068-creating-formulas-based-on-numerical-series-formula_52779
Sheet: Sayfa1

 | Criteria |  | Value |  | Check |  | Explanation |  | Results |  |  |  | [NAME] copied down until Row 209 (for 200 rows)
 | Ymax |  | 10 |  |  |  | Ymax > 0  Positif Integer |  | Ymax
 | Nmax |  | 39 |  |  |  |  |  | Xmax |  |  |  | List
 | Start X |  | 0 |  |  |  | [NAME] |  |  |  |  |  | N | X | Y
Spreadsheet: chris_stokley__3903__Cash Flow information ECR1122 Specs v5
Sheet: Ref Data

# | Data Elements | Comments
 | General Information
1 | Source System Name | 11 systems
2 | Source System ID Number
77 | Creation Date | File creation date
 | Referential Information
3 | Customer Name | Name that appears on invoice
4 | System Customer ID Number | HP = contract #, others = customer #
8 | Customer Account (Site) ID Number | HP = UDC acct #, others = billing address reference #
9 | Customer Account (Site) Name | HP = utility name for acct, others = billing group name for acct(s)
10 | Customer Account (Site) Street Address | "     "     "     "     "     "
11 | Customer Account (Site) Street Address2 | "     "     "     "     "     "
12 | Customer Account (Site) City | "     "     "     "     "     "
13 | Customer Account (Site) County | "     "     "     "     "     "
14 | Customer Account (Site) State | "     "     "     "     "     "
15 | Customer Account (Site) zip | "     "     "     "     "     "
17 | Customer Contact Name | Most recent name
18 | Customer Contact Telephone Number | Most recent number
N2 | Customer profile | Strategic, etc.
 | Other Notes
 | There will be one record for each new or changed customer record
Spreadsheet: 815990d1675297622-sorting-a-data-set-of-known-high-then-getting-value-before-and-after-that-known-value-test2-1-
Sheet: Test

Date | Time | Open | High | Low | Close | Column7 | Column8 | Column9 | Column10
2023-01-29 00:00:00 | 18:30:00 | 1944 | 1945.6 | 1941.9 | 1944.9 | 0 | 0 | 1945.6 | 0
2023-01-29 00:00:00 | 19:00:00 | 1944.8 | 1945.1 | 1943.7 | 1945.1 | 1945.1 | 0 | 0 | 0
2023-01-29 00:00:00 | 19:30:00 | 1945.2 | 1945.8 | 1944 | 1945.4 | 0 | 0 | 0 | 0
2023-01-29 00:00:00 | 20:00:00 | 1945.3 | 1946.2 | 1944.3 | 1944.9 | 0 | 0 | 0 | 1944.3
2023-01-29 00:00:00 | 20:30:00 | 1944.8 | 1947.4 | 1940.2 | 1942.8 | 0 | 1940.2 | 1947.4 | 0
2023-01-29 00:00:00 | 21:00:00 | 1942.6 | 1944.9 | 1940.8 | 1943.6 | 0 | 0 | 0 | 0
2023-01-29 00:00:00 | 21:30:00 | 1943.6 | 1943.6 | 1941.6 | 1942.7 | 0 | 0 | 0 | 1941.6
2023-01-29 00:00:00 | 22:00:00 | 1942.8 | 1942.8 | 1940.7 | 1942.3 | 0 | 0 | 0 | 0 |  |  |  |  | LH
2023-01-29 00:00:00 | 22:30:00 | 1942.2 | 1942.3 | 1940.7 | 1941.1 | 0 | 0 | 0 | 1940.7 |  |  |  |  | HIGH
2023-01-29 00:00:00 | 23:00:00 | 1941 | 1942.3 | 1940.1 | 1942.1 | 1942.3 | 1940.1 | 0 | 0 |  |  |  |  | LH
2023-01-29 00:00:00 | 23:30:00 | 1942 | 1947.6 | 1941.9 | 1947.1 | 0 | 0 | 0 | 0
2023-01-30 00:00:00 | 00:00:00 | 1947.2 | 1950.1 | 1947 | 1949 | 0 | 0 | 1950.1 | 0
2023-01-30 00:00:00 | 00:30:00 | 1949 | 1949.3 | 1947.6 | 1948.1 | 0 | 0 | 0 | 1947.6
2023-01-30 00:00:00 | 01:00:00 | 1948.2 | 1948.2 | 1945.8 | 1946.9 | 0 | 0 | 0 | 0
2023-01-30 00:00:00 | 01:30:00 | 1946.9 | 1947.7 | 1944.9 | 1946.9 | 0 | 1944.9 | 0 | 0
2023-01-30 00:00:00 | 02:00:00 | 1947 | 1947.7 | 1945.4 | 1946.4 | 0 | 0 | 1947.7 | 1945.4
2023-01-30 00:00:00 | 02:30:00 | 1946.5 | 1947.2 | 1942.1 | 1944.1 | 0 | 0 | 0 | 0
2023-01-30 00:00:00 | 03:00:00 | 1944 | 1944.6 | 1938.3 | 1940.1 | 0 | 0 | 0 | 0
2023-01-30 00:00:00 | 03:30:00 | 1940.1 | 1940.2 | 1936.7 | 1937.5 | 0 | 0 | 0 | 0
2023-01-30 00:00:00 | 04:00:00 | 1937.5 | 1939.2 | 1936.2 | 1938.9 | 1939.2 | 1936.2 | 0 | 0
2023-01-30 00:00:00 | 04:30:00 | 1938.8 | 1940 | 1937.7 | 1939.9 | 0 | 0 | 0 | 0
Spreadsheet: 698325d1601922452-connecting-hr-info-diff-tabs-if-criteria-etc-sample-sheet
Sheet: sheet1

Position Number | LAST NAME | FIRST - MIDDLE NAME
[PHONE]-001 | Stanford | [NAME] | OFFICE OF THE DIRECTOR
[PHONE]-910 | [NAME] | Chief | IT Division
[PHONE]-001 | Dancer | Tiny L | EA Branch
[PHONE]-901 | [NAME] | Morgan | EA Branch
[PHONE]-901 | Pony | My L | OFFICE OF THE DIRECTOR
Spreadsheet: 148870d1333583235-formula-wont-recognize-another-formula-need-help-asap-lot-check-2-
Sheet: Sheet3

2 | TDGENAP185-0050
3 | TDGENAP185-0075
4 | TDGENAP185-0100
5 | TDGENAP185-0125
6 | TDGENAP185-0150
7 | TDGENAP185-0175
8 | TDGENAP185-0200
9 | TDGENAP185-0225
10 | TDGENAP185-0250
11 | TDGENAP185-0275
12 | TDGENAP185-0300
13 | TDGENAP185-0325
14 | TDGENAP185-0350
15 | TDGENAP185-0375
16 | TDGENAP185-0400
17 | TDGENAP185-0425
18 | TDGENAP185-0450
19 | TDGENAP185-0475
20 | TDGENAP185-0500
21 | TDGENAP185-0525
22 | TDGENAP185-0550
23 | TDGENAP185-0575
24 | TDGENAP185-0600
26 | TDGENAP185-0650
28 | TDGENAP185-0700
30 | TDGENAP185-0750
32 | TDGENAP185-0800
33 | TDGENAP185-0850
34 | TDGENAP185-0900
35 | TDGENAP185-0950
36 | TDGENAP185-1000
37 | TDGENAP185-1050
38 | TDGENAP185-1100
39 | TDGENAP185-1150
51 | TDGENAP184+0025
52 | TDGENAP184+0050
53 | TDGENAP184+0075
54 | TDGENAP184+0100
55 | TDGENAP184+0125
56 | TDGENAP184+0150
57 | TDGENAP184+0175
58 | TDGENAP184+0200
59 | TDGENAP184+0225
60 | TDGENAP184+0250
61 | TDGENAP184+0275
62 | TDGENAP184+0300
63 | TDGENAP184+0325
64 | TDGENAP184+0350
65 | TDGENAP184+0375
66 | TDGENAP184+0400
Spreadsheet: kate_symes__18178__MeadMktplace 2-26
Sheet: MeadMktplace

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME]
 | 2001-02-26 00:00:00 |  | 177.86 | 224 | 133.56 | 1392
 | 2001-02-25 00:00:00 |  | 147.5 | 0 | 135 | 280 | 131.22 | 2999 | 108.91 | 2383
 | 2001-02-24 00:00:00 |  | 174.29 | 224 | 115.26 | 1560 | 148.66 | 1535 | 132.09 | 1146
 | 2001-02-23 00:00:00 |  | 174.29 | 224 | 115.54 | 1480 | 166.64 | 2128 | 118.23 | 893
 | 2001-02-22 00:00:00 |  | 201.14 | 224 | 118.5 | 1312 | 160.02 | 656 | 90.98 | 787
 | 2001-02-21 00:00:00 |  | 210 | 224 | 148.86 | 560 | 161.32 | 1192 | 89.98 | 1296
 | 2001-02-20 00:00:00 |  | 232.14 | 224 | 137.14 | 112 | 130.89 | 1348 | 114.12 | 758
 | 2001-02-19 00:00:00 |  | 232.14 | 224 | 145 | 160 | 156.82 | 1839 | 154.53 | 1668
 | 2001-02-18 00:00:00 |  | 287.5 | 320 | 240.5 | 0 | 197.15 | 771 | 166.45 | 1129
 | 2001-02-17 00:00:00 |  | 282.14 | 224 | 221.43 | 112 | 230.67 | 1640 | 205.12 | 1180
 | 2001-02-16 00:00:00 |  | 387.5 | 384 | 198.75 | 192 | 251.75 | 3017 | 181.8 | 1576
 | 2001-02-15 00:00:00 |  | 387.5 | 384 | 198.75 | 192 | 391.66 | 5037 | 207.21 | 1058
 | 2001-02-14 00:00:00 |  | 275.24 | 1312 | 150.92 | 392 | 304.68 | 695 | 197.1 | 1165
 | 2001-02-13 00:00:00 |  | 185 | 160 | 151.57 | 1400 | 194.42 | 1165 | 136.79 | 587
 | 2001-02-12 00:00:00 |  | 207.14 | 560 | 138.91 | 880 | 140.84 | 1676 | 158.45 | 785
 | 2001-02-11 00:00:00 |  | 150 | 160 | 140 | 600 | 141.19 | 3174 | 132.09 | 2803
 | 2001-02-10 00:00:00 |  | 153.75 | 320 | 115.46 | 1720 | 150.05 | 2068 | 161.43 | 828
 | 2001-02-09 00:00:00 |  | 153.75 | 320 | 116.25 | 1760 | 168.64 | 1070 | 117.98 | 945
 | 2001-02-08 00:00:00 |  | 176.25 | 960 | 148.1 | 2000 | 174.99 | 844 | 91.4 | 1905
 | 2001-02-07 00:00:00 |  | 169.28 | 4224 | 131.32 | 3628 | 190.46 | 1300 | 95.76 | 1283
 | 2001-02-06 00:00:00 |  | 149.44 | 720 | 146.14 | 1400 | 153.56 | 520 | 88.67 | 917
 | 2001-02-05 00:00:00 |  | 160.19 | 1864 | 143.63 | 1772 | 142.39 | 1579 | 82.26 | 1310
 | 2001-02-04 00:00:00 |  | 150 | 0 | 146.67 | 1200 | 94.46 | 2705 | 81.4 | 2734
 | 2001-02-03 00:00:00 |  | 165 | 0 | 152.1 | 2000 | 127.82 | 6039 | 83.63 | 2119
 | 2001-02-02 00:00:00 |  | 160 | 320 | 148.88 | 1600 | 145.26 | 2069 | 111.08 | 2227
 | 2001-02-01 00:00:00 |  | 231.82 | 176 | 161.58 | 696 | 171.56 | 2512 | 111.53 | 1611
 | 2001-01-31 00:00:00 |  | 250 | 64 | 145 | 32 | 196.22 | 2670 | 133.68 | 1348
 | 2001-01-30 00:00:00 |  | 200.83 | 384 | 142.84 | 592 | 205.28 | 1618 | 135.46 | 1365
 | 2001-01-29 00:00:00 |  | 232.86 | 224 | 197.1 | 1000 | 188.91 | 2740 | 130.63 | 1506
 | 2001-01-28 00:00:00 |  | 200 | 320 | 175 | 0 | 178.38 | 3068 | 130.84 | 1999
 | 2001-01-27 00:00:00 |  | 232.14 | 560 | 159 | 1000 | 196.47 | 1231 | 125.85 | 2421
Spreadsheet: lynn_blair__24470__NNGWKednotes_2001
Sheet: Jan 27 & 28 2001

NNG WEEKEND NOTES
For cc Mail distribution:  [NAME], [NAME], [NAME], S. January,  [NAME], [NAME], [NAME], [NAME]
SATURDAY |  |  | 2001-01-27 00:00:00
Mail distribution send to the above listing on Sunday evening.
H:\DATA\Process Guidelines\[NNGWKednotes Template.xls]Dec 9 & 10
 | PROCESS |  |  |  | COMMENTS:
 | Gas Day: | SAT |  |  | Communication problem with non-grid allocation process
 | 7:00 A.M. Non-grid:
 | Gas Day: | FRI |  |  | No difficulties with the process.
 | 8:00 AM Final Storage
 | Gas Day: | SAT |  |  | Problems with Allocation Wizard- Called EDS
 | 10:00 A.M. Intraday 1: |  |  |  | Confirmations extended for TW & El Paso.
 | Gas Day: | SUN |  |  | No difficulties with the process.
 | 11:30 A.M. Timely
 | Gas Day: | SAT |  |  | No difficulties with the process.
 | 5:00 P.M. Intraday 2: |  |  |  | Confirmations extended for TW & El Paso & NBPL.
 | Gas Day: | SUN |  |  | No difficulties with the process.
 | 6:00 P.M. Evening
 | Other Comments: |  |  |  | Received late EDI respones for Non Grid and final due to Main EDI went out of space.
 |  |  |  |  | Problem was fixed in a timely manner and no process deadlines were extended
 | On Call Reps. |  |  |  | [NAME] | 6:30 - 3:30
 |  |  |  |  | [NAME] | 6:30 - 3:30
 |  |  |  |  | [NAME] | 9:30 - 6:30
 |  |  |  |  | [NAME] | 1:00 - 10:00
 |  |  |  |  | [NAME] | 1:00 - 10:00
SUNDAY
 | PROCESS |  |  |  | COMMENTS:
 | Gas Day: | SUN |  |  | No difficulties with the process.
 | 7:00 A.M. Non-grid:
 | Gas Day: | SAT |  |  | No difficulties with the process.
 | 8:00 AM Final Storage
 | Gas Day: | SUN |  |  | No difficulties with the process.
 | 10:00 A.M. Intraday 1: |  |  |  | Confirmations extended for TW & El Paso.
 | Gas Day: | SUN |  |  | No difficulties with the process.
 | 5:00 P.M. Intraday 2: |  |  |  | Confirmations extended for TW & El Paso & NBPL.
 | Gas Day: | MON |  |  | No difficulties with the process.
 | 11:30 A.M. Timely
 | Gas Day: | MON |  |  | No difficulties with the process.
 | 6:00 P.M. Evening
 | On Call Reps: |  |  |  | [NAME] | 6:30 - 3:30
 |  |  |  |  | [NAME] | 6:30 - 3:30
 |  |  |  |  | [NAME] | 9:30 - 6:30
 |  |  |  |  | [NAME] | 1:00 - 10:00
 |  |  |  |  | [NAME] | 1:00 - 10:00
Spreadsheet: benjamin_rogers__1309__site_visit_schedule for Ross & Fred
Sheet: Confirm - Calpine

 |  | Company | Calpine
 |  | Company Contact & Number | [NAME](408) 792-1105
 |  | Site or Sites | Lincoln
 |  | Site Visit Date | Wednesday October 25th
 |  | Directions to Hotels/Site | See DealBench - Due Diligence List/Plant Pictures Section
 |  | Meeting Time/Place | Wednesday Morning
 |  |  | Lincoln Energy Center
 |  |  | 27150 South Kankakee Rd.
 |  |  | Manhattan, IL 60442
 |  | Enron Site Visit Coordinator | [NAME]
 |  |  | Work: (713) 853-5406 / Cell: (713) 412-4612
 |  |  | [NAME]
 |  |  | Work: (713) 646-7071 / (281) 450-2844
 |  |  | Lincoln - [NAME] (Plant Manager)
 |  |  | Work (815) 478-3852
 |  | Calpine Site Visit Team
Spreadsheet: 0b33bdd9-8331-4410-96bd-511c5b1dff4b
Sheet: GPA

 | GPA Calculator
 | Course | Credits | Value | Grade | Points |  |  | Instructions |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | 1.  Under "Course" input the course name. |  |  |  |  |  |  |  |  | Return To AA
 |  |  |  |  |  |  |  | Example:  HIS 104 |  |  |  |  |  |  |  |  | Return To AS
 |  |  |  |  |  |  |  | Note:  If a course has been repeated, only record the course with the highest |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | grade.
 |  |  |  |  |  |  |  | 2.  Under "Grade" select a grade from the dropdown box.
 |  |  |  |  |  |  |  | Note:  Transfer & Developmental courses do not count towards GPA.
 |  |  |  |  |  |  |  | 3.  Under "Credits" enter a credit value or select one from the dropdown box.
 |  |  |  |  |  |  |  | Example:  HIS 104 is 3 credits.
 |  |  |  |  |  |  |  | Example: |  | Course | Grade | Credits
 |  |  |  |  |  |  |  |  |  | HIS 104 | A | 3
 |  |  |  |  |  |  |  | 4.  GPA will be automatically calculated.
 |  |  |  |  |  |  |  | 5.  If you would like to see what the GPA would be if repeated a course is repeated,
 |  |  |  |  |  |  |  | simply change the grade to see how it affects the GPA.
 |  |  |  |  |  |  |  | Example:  You got a D in HIS 104 but would like to retake it.  Change your grade
 |  |  |  |  |  |  |  | in HIS 104 to something else to see how much it would affect your GPA.
 |  |  |  |  |  |  |  | GPA Calculation
 |  |  |  |  |  |  |  | Total Grade Points:
 |  |  |  |  |  |  |  | Total Credits:
 |  |  |  |  |  |  |  | GPA:
Spreadsheet: 192468d1352413890-combining-data-series-with-different-data-examples
Sheet: Chiffres

12017984 |  | [PHONE]
12018040 |  | [PHONE]
12018115 |  | [PHONE]
12018123 |  | [PHONE]
12018172 |  | [PHONE]
12018198 |  | [PHONE]
12018198 |  | [PHONE]
12018230 |  | [PHONE]
12018230 |  | [PHONE]
12018289 |  | [PHONE]
12018297 |  | [PHONE]
12018313 |  | [PHONE]
12018420 |  | [PHONE]
12018503 |  | [PHONE]
12018529 |  | [PHONE]
12018545 |  | [PHONE]
12018594 |  | [PHONE]
12018727 |  | [PHONE]
12018875 |  | [PHONE]
12018875 |  | [PHONE]
12018891 |  | [PHONE]
12018909 |  | [PHONE]
12018909 |  | [PHONE]
12018933 |  | [PHONE]
12019014 |  | [PHONE]
12019170 |  | [PHONE]
12019238 |  | [PHONE]
12019253 |  | [PHONE]
12019279 |  | [PHONE]
12019311 |  | [PHONE]
Spreadsheet: phillip_m_love__30138__200007_OA
Sheet: TX-HPLR-GL 

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  HPL
REGION:  TEXAS
 |  |  | Total |  | Reclasses |  | July |  | August |  | September
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron |  |  |  |  | 139173 | 612500.37 | 930 | 4092.93
2 |  | Liquidations |  |  |  |  | 0 | 0 | 0 | 0
3 |  | Interdesk |  |  |  |  | 0 | 0 | 0 | 0
4 |  | Option Premiums |  |  |  |  | 0 | 0 | 0 | 0
5 |  | Dmd Reimbursements |  |  |  |  | 0 | 0 | 0 | 0
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron |  |  |  |  | 0 | 0 | 0 | 0 |  | 26765.93
7 |  | Liquidations |  |  |  |  | 0 | 0 | 0 | 0
8 |  | Interdesk |  |  |  |  | 0 | 0 | 0 | 0
9 |  | Option Premiums |  |  |  |  | 0 | 0 | 0 | 0
10 |  | [NAME] |  |  |  |  | 0 | 0 | 0 | 0
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales |  |  |  |  | 0 | 0 | 0 | 0
12 |  | Purchases |  |  |  |  | -139173 | -609577.74 | -930 | -4073.4
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind |  |  |  |  | 0 | 0 | 0 | 0
14 |  | Cash Out |  |  |  |  | 0 | 0 | 0 | 0
15 |  | Cash In |  |  |  |  | 0 | 0 | 0 | 0
16 |  | Synthetic Storage |  |  |  |  | 0 | 0 | 0 | 0
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg) |  |  |  |  | 0 | 0 | 0 | 0
18 |  | W/D (Purchase from Stg) |  |  |  |  | 0 | 0 | 0 | 0
19 |  | Inventory Profit |  |  |  |  | 0 | 0 | 0 | 0
 |  | Total W/D
 | Total Storage:
20 | Linepack: |  |  |  |  |  | 0 | 0 | 0 | 0
21 | Shrinkage: |  |  |  |  |  | 0 | 0 | 0 | 0
22 | UA4: |  |  |  |  |  | 0 | 0 | 0 | 0
23 | Fuel: |  |  |  |  |  | 0 | 0 | 0 | 0
 | Transport Expense:
24 |  | Commodity |  |  |  |  | -233894 | 1172793.6 | -66243 | -288590.95 |  | 288591.84
25 |  | Demand |  |  |  |  | 0 | 0 | 0 | 0
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate |  |  |  |  | 0 | 0 | 0 | 0
27 |  | Intrastate |  |  |  |  | 0 | 0 | 0 | 0
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense |  |  |  |  | 0 | 0 | 0 | 0
29 |  | Transport Revenue |  |  |  |  | 0 | 0 | 0 | 0
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance |  |  |  |  | 0 | 0 | 0 | 0
31 |  | Prior Month Book Balance |  |  |  |  | 0 | 0 | 0 | 0
 |  | Total MTM Income
32 |  | Prudency |  |  |  |  | 0 | 0 | 0 | 0
33 |  | Financial Liquidations |  |  |  |  | 0 | 0 | 0 | 0
34 |  | Originations |  |  |  |  | 0 | 0 | 0 | 0
35 |  | Broker Fees |  |  |  |  | 0 | 0 | 0 | 0
36 |  | Asset Group Demand Charges |  |  |  |  | 0 | 0 | 0 | 0
37 |  | [NAME] |  |  |  |  | 0 | 0 | 0 | 0
38 |  | Interdesk Charges |  |  |  |  | 0 | 0 | 0 | 0
39 |  | Canada |  |  |  |  | 0 | 0 | 0 | 0
40 |  | Miscellaneous |  |  |  |  | 0 | 0 | 0 | 0
 |  | TOTAL
Spreadsheet: 786644d1657317365-named-range-brings-an-error-when-used-in-a-chart-customer-trend-analysis-draft-3a-
Sheet: Chart Data Source

 | GRAPH 1
 | GRAPH 2
Spreadsheet: 154961d1336630157-please-need-help-buy-and-sell
Sheet: DATA File

BUY | SELL
1 | 1 | ADANIENT | 270.8 | 266.9 | 273.75 | 266.1
1 | 1 | ADANIPORTS | 123.9 | 122.95 | 124.85 | 122.6
1 | 1 | ADANIPOWER | 55.85 | 56 | 56.25 | 54.95 | BUY | 55.2 | 55.5 |  |  |  |  |  |  | auto updat in arrange sheet buy and sell
2 | 1 | ALBK | 152.8 | 154.75 | 159.9 | 150.25
2 | 1 | AMBUJACEM | 144.3 | 144 | 144.6 | 141.65
2 | 1 | ANANTRAJ | 52.75 | 52.65 | 53.4 | 52.3 | SELL |  |  | 53.3 | 53
2 | 2 | ANDHRABANK | 113.15 | 115.05 | 117 | 111.2
2 | 2 | APIL | 363.05 | 355.05 | 366 | 352.4 | BUY | 361.8 | 365.2
3 | 2 | ASHOKLEY | 28.15 | 28.2 | 28.75 | 27.85
3 | 2 | ASIANPAINT | 3685.55 | 3699 | 3734 | 3631.1
3 | 2 | AUROPHARMA | 120.75 | 120.85 | 123.95 | 120.5
3 | 2 | AXISBANK | 974.5 | 970.3 | 981.9 | 961.35
3 | 2 | BAJAJ-AUTO | 1491.45 | 1480 | 1498 | 1471.85
3 | 2 | BAJAJHLDNG | 803.95 | 809.9 | 810 | 800 | BUY | 802.6 | 805.1
4 | 2 | BANKBARODA | 655.5 | 650 | 663.3 | 644.5
4 | 2 | BANKINDIA | 327.95 | 329.05 | 333.8 | 324.55
4 | 2 | BEL | 1410.6 | 1402.1 | 1415.1 | 1401.2
4 | 2 | BEML | 528.15 | 520.5 | 532 | 518.15 | BUY | 524.7 | 528.2
5 | 2 | BHARATFORG | 342.45 | 336 | 343.95 | 335.05
Spreadsheet: 188607d1350931714-how-to-calculate-the-time-between-purchases-for-multiple-customers-repeat-customers
Sheet: Data

Customers | Month | HW | SW | P
A | 2005-01-01 00:00:00 |  |  | 107403.75
 | 2006-02-01 00:00:00
 | 2006-11-01 00:00:00 | 0 | 52447.5
 | 2006-12-01 00:00:00 | 0 | 19980
 | 2008-01-01 00:00:00 | 0 | 0
 | 2008-02-01 00:00:00 | 0 | 0
B | 2010-03-01 00:00:00 | 0 | 0
 | 2010-11-01 00:00:00 | 20400 | 0
C | 2011-12-01 00:00:00 | 21350 | 21360.94
 | 2012-03-12 00:00:00 | 0 | 11594
D | 2012-05-01 00:00:00 | 0 | 0
 | 2012-06-12 00:00:00 | 0 | 4800
 | 2012-09-01 00:00:00 | 0 | 0
E | 2010-09-01 00:00:00 | 24320 | 20820
F | 2011-03-01 00:00:00 | 0 | 17440
 | 2011-09-01 00:00:00 | 0 | 0
 | 2012-02-12 00:00:00 | 0 | 2000
 | 2012-04-01 00:00:00 | 0 | 0
G | 2011-05-11 00:00:00 | 12200 | 3200
H | 2012-06-04 00:00:00 | 25225 | 22875
 | 2012-09-01 00:00:00 | 72540 | 9900
I | 2012-02-12 00:00:00 | 8200 | 10800
J | 2011-02-01 00:00:00 | 135000 | 288000
 | 2011-04-11 00:00:00 | 0 | 0
 | 2011-09-11 00:00:00 | 0 | 0
K | 2012-03-12 00:00:00 | 70400 | 99000
 | 2012-07-01 00:00:00 | 0 | 0
L | 2012-09-01 00:00:00 | 0 | 52200
M | 2011-12-11 00:00:00 | 12700 | 18000
O | 2008-07-01 00:00:00 | 40000 | 14375.42
 | 2008-10-01 00:00:00 | 0 | 5000
 | 2009-06-01 00:00:00 | 20000 | 15000
 | 2009-10-01 00:00:00 | 0 | 0
 | 2010-02-01 00:00:00 | 0 | 0
 | 2010-08-01 00:00:00 | 0 | 0
 | 2010-10-01 00:00:00 | 0 | 0
 | 2011-01-01 00:00:00 | 0 | 0
 | 2011-02-01 00:00:00 | 0 | 26000
 | 2011-10-11 00:00:00 | 0 | 0
 | 2012-02-12 00:00:00 | 35400 | 29310
 | 2012-07-01 00:00:00 | 0 | 0
P | 2012-04-01 00:00:00 | 28975 | 14250
Q | 2011-10-11 00:00:00 | 20400 | 33500
R | 2012-06-08 00:00:00 | 0 | 0
S | 2012-08-12 00:00:00 | 0 | 0
T | 2011-07-11 00:00:00 | 18500 | 0
U | 2009-10-01 00:00:00 | 50750 | 214500
 | 2009-11-01 00:00:00 | 0 | 0
 | 2010-11-01 00:00:00 | 0 | 0
 | 2011-01-01 00:00:00 | 0 | 0
 | 2011-03-11 00:00:00 | 0 | 0
 | 2011-09-11 00:00:00 | 0 | 0
 | 2012-04-01 00:00:00 | 0 | 39000
 | 2012-10-01 00:00:00 | 0 | 0
V | 2012-09-01 00:00:00 | 190260 | 0
W | 2006-05-01 00:00:00 | 20290 | 0
 | 2007-05-01 00:00:00 | 0 | 0
 | 2008-04-01 00:00:00 | 0 | 95840
 | 2008-05-01 00:00:00 | 0 | 0
 | 2009-04-01 00:00:00 | 0 | 0
 | 2009-05-01 00:00:00 | 0 | 0
 | 2009-12-01 00:00:00 | 17000 | 0
 | 2010-04-01 00:00:00 | 0 | 0
 | 2011-05-11 00:00:00 | 0 | 0
 | 2012-05-01 00:00:00 | 0 | 0
 | 2012-05-24 00:00:00 | 0 | 18000
X | 2009-12-01 00:00:00 | 20000 | 7500
 | 2010-09-01 00:00:00 | 0 | 12000
 | 2010-12-01 00:00:00 | 0 | 26000
 | 2012-06-08 00:00:00 | 9000 | 0
 | 2012-07-01 00:00:00 | 0 | 0
Y | 2011-12-11 00:00:00 | 35375 | 41300
Z | 2008-06-01 00:00:00 | 59740 | 104062.5
 | 2009-06-01 00:00:00 | 0 | 0
 | 2010-08-01 00:00:00 | 0 | 0