tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 26275d1218305096-hours-book1
Sheet: Sheet1

NAME | SHIFT |  |  | HRS SCHED | 06:00:00 | 06:30:00 | 07:00:00 | 07:30:00 | 08:00:00 | 08:30:00 | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 01:00:00 | 01:30:00 | 02:00:00 | 02:30:00 | 03:00:00 | 03:30:00 | 04:00:00 | 04:30:00 | 05:00:00 | 05:30:00 | 06:00:00 | 06:30:00 | 07:00:00 | 07:30:00 | 08:00:00 | 08:30:00
[NAME] | 06:00:00 | - | 16:00:00 | 0 | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M
Shellie | 08:00:00 | - | 18:00:00 | 0 |  |  |  |  | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M
Brent | 15:00:00 | - | 01:00:00 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M | M | M | M | M | M | M | M | M | M | M | M
 |  | - |  | 0
Paola | 22:00:00 | - | 06:00:00 | 8
[NAME] | 1900-01-01 00:00:00 | - | 08:00:00 | 8 | 1 | 1 | 1 | 1
Marnie | 06:00:00 | - | 13:30:00 | 7.5 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
[NAME] | 06:00:00 | - | 13:30:00 | 7.5 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Damean | 07:30:00 | - | 13:30:00 | 6 |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Spreadsheet: 863365d1710870785-split-and-organize-values-from-array-to-new-array-split-text-dj
Sheet: Feuil1

 | /LABEL A|value01/[NAME] C|value03/LABEL D|value04/LABEL E|value05/LABEL F|value06/LABEL G|value07
 | [NAME][NAME] C|value03/LABEL D|value04/LABEL E|value05/LABEL F|value08
START WITH SPILLING ARRAY IN B6
 | [NAME][NAME] C|value03/LABEL D|value04/LABEL E|value05/LABEL F|value08
EXPECTED RESULT (spilling array in B10, 2 rows)
common: | [NAME] C|value03/LABEL D|value04/LABEL E|value05
specific: | /LABEL A|value01/LABEL F|value06/LABEL G|value07***/LABEL A|value12/LABEL F|value08
[NAME], FYI
 |  | #N/A |  |  | value01
 |  | #N/A |  | LABEL B | value02
 | LABEL A | value01 |  | LABEL C | value03
 | LABEL B | value02 |  | LABEL D | [NAME]
 | LABEL C | value03 |  | LABEL E | value05
 | LABEL D | [NAME] |  | [NAME] | value06
 | LABEL E | value05 |  | LABEL G | value07
 | [NAME] | value06 |  | LABEL A | value12
 | LABEL G | value07 |  | LABEL B | value02
 |  | #N/A |  | LABEL C | value03
 | LABEL A | value12 |  | LABEL D | [NAME]
 | LABEL B | value02 |  | LABEL E | value05
 | LABEL C | value03 |  | [NAME] | value08
 | LABEL D | [NAME]
 | LABEL E | value05
 | [NAME] | value08
Spreadsheet: 870299d1716831653-adjustment-of-formulas-from-google-sheets-to-excel-file-below-pic-west123-2-
Sheet: Sheet1

Time Normal | Tournament | Entry |  | [NAME] | Action Sold | Result |  |  |  |  | Time Normal | Tournament | Buy In | Entry | [NAME] | action-sold | Total Prize | Duration | Rank | Result
mat-tooltip-trigger | tournament-name | mat-cell 2 | mat-cell 3 | mat-cell 4 | staking-profile-action-sold
May 25, 19:30 | [NAME] Special $2.50 | 1 | 2.5 | 1.1 up to 60% | 1 | 0
May 25, 19:10 | Speed Racer Bounty $3.21 [10 BB] | 1 | 3.21 | 1.1 up to 60% | 0.8333 | 0
May 25, 17:05 | Micro Madness $1.88 [Hyper] | 3 | 1.88 | 1.1 up to 60% | 0.5 | 0
May 25, 14:10 | Speed Racer Bounty $1.08 [10 BB] | 1 | 1.08 | 1.1 up to 60% | 1 | 0
May 25, 12:30 | [NAME] $3.21 | 1 | 3.21 | 1.01 up to 50% | 0 | 0 | Note: no share sold but was played.
May 25, 09:10 | Speed Racer Bounty $3.21 [10 BB] | 1 | 3.21 | 1.1 up to 50% | 1 | 0.75
May 24, 21:05 | Daily Special $3 | 2 | 3 | 1.01 up to 50% | 1 | 0
May 24, 19:10 | Speed Racer Bounty $3.21 [10 BB] | 2 | 3.21 | 1.01 up to 50% | 1 | 0
May 24, 14:10 | Speed Racer Bounty $1.08 [10 BB] | 6 | 1.08 | 1.1 up to 30% | 0 | 0 | Note: no share sold but wasy played.
May 25, 19:30 | [NAME] Special $2.50 | 2.5 | 1160 | 2691.2 | 0.209247685 | 974 / 1,160 | 0
May 25, 19:10 | Speed Racer Bounty $3.21 [10 BB] | 3.21 | 557 | 1671 | 0.052604167 | 538 / 557 | 0
May 25, 17:05 | Micro Madness $1.88 [Hyper] | 1.88 | 788 | 1363.24 | 0.139479167 | 787 / 788 | 0
May 25, 17:05 | Micro Madness $1.88 [Hyper] | 1.88 | 788 | 1363.24 | 0.139479167 | 764 / 788 | 0
May 25, 17:05 | Micro Madness $1.88 [Hyper] | 1.88 | 788 | 1363.24 | 0.139479167 | 740 / 788 | 0
Spreadsheet: 209310d1359060747-how-to-format-spreadsheet-to-change-color-after-x-dates-in-excell-2007-example2_date_con_etaf-4-
Sheet: Sheet1

2012-02-06 00:00:00 | 2012-10-10 00:00:00 | 2012-12-04 00:00:00 | 2012-12-19 00:00:00
2012-03-16 00:00:00 | TCS | 2012-06-29 00:00:00 | 2012-06-29 00:00:00 |  |  |  |  |  |  | Sure lets see - all dates in each cell expires in 1 year i.e 24/1/2013 - expires on 23/1/2014. What I'm looking at doing is getting a formula that would make it easy to just look at the spreadsheet so that if the the expiration date is withn 90 days, fill the cell to green, same if the expiration date is in 30 days change to yellow and once the expiration date is reached changed to red. If the date is currentthen there would be no fill in the cell. I just need to be able to look at the spreadsheet and easy identify the cells that need attention, for that i will need 4 formulas
2012-10-10 00:00:00 | 2012-10-10 00:00:00 | 2012-09-12 00:00:00 | 2012-10-10 00:00:00
2012-03-13 00:00:00 | 2012-10-10 00:00:00 | 2012-12-04 00:00:00 | 2012-03-26 00:00:00
 |  |  | 2012-11-15 00:00:00
2012-09-12 00:00:00 | 2012-10-10 00:00:00 | 2012-12-18 00:00:00 | 2012-08-03 00:00:00
2012-03-13 00:00:00 | 2012-10-10 00:00:00 | 2012-01-05 00:00:00 | 2012-01-07 00:00:00
2012-03-13 00:00:00 |  | 2013-01-08 00:00:00 | 2013-01-08 00:00:00
2012-03-06 00:00:00 | 2013-01-09 00:00:00 | 2012-02-14 00:00:00 | 2012-07-17 00:00:00 |  |  |  |  |  |  | 1. current - no fill
 |  |  |  |  |  |  |  |  |  | 2. 60 days prior to expiration - green
[NAME] |  |  |  |  | Days Old |  |  |  |  | 3. 30 days prior to expiration - yellow
 |  |  |  |  |  |  |  |  |  | 4. expired - red
 |  |  |  |  |  |  |  |  |  | hopefully this helps
Spreadsheet: 839707d1692176015-sumproduct-sum-from-multiple-sheets-depending-on-specific-month-file
Sheet: 1

1 |  | CY | CY | CY | CY | CY | CY | CY | CY | CY | CY | CY | CY
 |  | Actuals | Actuals | Actuals | Actuals | Actuals | Actuals | Actuals | Actuals | Actuals | Actuals | Actuals | Actuals
 |  | 202301 | 202302 | 202303 | 202304 | 202305 | 202306 | 202307 | 202308 | 202309 | 202310 | 202311 | 202312
Opening |  | 826531 | 823061 | 821013 | 819288 | 818785 | 819609 | 819389 | 820709 | 820709 | 820709 | 820709 | 820709
Spreadsheet: 276248d1-8956-49fd-80b7-ca55c309179b
Sheet: Sheet1

PENGUMUMAN HASIL PLPG TAHAP 13-14 BLOK DAN 4 NON BLOK
NO | NO PESERTA | NAMA | INSTANSI | KAB/KOTA | STATUS PLPG
1 | 11030622710767 | SUPRIYONO | SMP N 23 PURWOREJO | Kab. Purworejo | Lulus
2 | 11030622710829 | [NAME] | SMP N 14 PURWOREJO | Kab. Purworejo | Lulus
3 | 11030606310857 | SUYANI | SMP N 8 PURWOREJO | Kab. Purworejo | Lulus
4 | 11030606310970 | EKO ANJARIYATI | SMP PGRI GRABAG | Kab. Purworejo | Lulus
5 | 11030622710901 | SIDIK | SMP N 28 PURWOREJO | Kab. Purworejo | [NAME]
6 | 11030622710930 | SURIPTO | SMP N 13 PURWOREJO | Kab. Purworejo | [NAME]
7 | 11030606310805 | DARYANTI | SMP Pancasila 1 Purworejo | Kab. Purworejo | [NAME]
Spreadsheet: 682005d1591875554-help-creating-worksheet-to-do-equations-line-off-best-fit
Sheet: Sheet1

PSI | Sensor | PWM
0 | 651 | 20
5 | 645 | 35
10 | 630 | 46
15 | 596 | 59
20 | 564 | 70
25 | 517 | 88
30 | 480 | 105
35 | 438 | 124
40 | 390 | 144
45 | 347 | 162
50 | 299 | 183
55 | 223 | 201
60 | 156 | 243
Spreadsheet: 215456d1361384335-get-maximum-value-per-row-of-an-embedded-2d-array-to-create-an-embedded-1d-column-vector-excel-array-problem
Sheet: Sheet1

Match all Items where a given name occurs, and all the times it occurs |  |  |  |  |  |  |  |  |  | This is what the formulae give |  |  |  |  |  | This is desired result
 |  | Item | Name 1 | Name 2 | Name 3 | Name 4 | Name 5 | Name= | [NAME] | Item | Item Row | Name 1 | Name 2 | Name 3 |  | Item | Item Row | Name 1 | Name 2 | Name 3
 |  | First | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] |  |  |  |  |  |  |  |  | Second | 5 | [NAME] | [NAME] | [NAME]
 |  | Second | [NAME] | [NAME] | George | [NAME] | [NAME] |  |  |  |  |  |  |  |  | Third | 6 | [NAME] | - | -
 |  | Third | [NAME] | Sheena | [NAME] | George | Susan2 |  |  |  |  |  |  |  |  | - | - | - | - | -
 |  | Fourth | Anne | [NAME] | David1 | [NAME] | [NAME] |  |  |  |  |  |  |  |  | - | - | - | - | -
 | I need to use SMALL on a 1-col vector [NAME] derived from the 4x5 matrix array by obtaining the MAX value per row
 | HOW?
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bracket Counts
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ( | )
 | ISNUMBER(SEARCH($J$20,$D$21:$H$24)) |  |  |  |  |  | IF(ISNUMBER(SEARCH($J$20,$D$21:$H$24)),ROW($21:$24),0) |  |  |  |  |  | SMALL(IF(ISNUMBER(SEARCH($J$20,$D$21:$H$24)),ROW($21:$24)),ROW(*:*))
 |  | False | False | False | False |  |  | False | False | False | False |  |  | 5
 | False | True | False | True | True |  | False | 5 | False | 5 | 5 |  |  | 6
 | True | False | False | False | False |  | 6 | False | False | False | False |  |  | -
 | False | False | True | False | False |  | False | False | 7 | False | False |  |  | -
Spreadsheet: 44518d1243274567-breaking-a-tie-sampletiebreak
Sheet: Sheet1

Rank | School | Score | Ties | Tie Rank |  | New Order | 5th | 6th
3 | Brooksville | 312 | 3121 | 3091 | 1 | Groman | 79 | 83
6 | [NAME] | 319 | 3191 | 3092 | 1 | Dorland | 78 | 81
1 | Groman | 309 | 3091 | 3121 | 3 | Brooksville | 79 | 83
5 | Fisher | 317 | 3171 | 3122 | 3 | [NAME] | 81 | 84
7 | Crossville | 325 | 3251 | 3171 | 5 | Fisher | 77 | 88
1 | Dorland | 309 | 3092 | 3191 | 6 | [NAME] | 81 | 87
3 | [NAME] | 312 | 3122 | 3251 | 7 | Crossville | 81 | 85
 | How do I break the ties with a 5th player score and rank the teams again?
 | In the above example, Groman and Dorland are tied at 309. Dorland has a lower 5th player score.
 | Dorland is first and Groman is 2nd.
 | How do I re-rank them?
Spreadsheet: 50289d1249655902-getting-a-formula-to-show-zero-until-it-is-used-timesheet
Sheet: Weeks 1-4

 |  |  |  |  |  |  | Name |  |  |  |  |  |  |  | Dept./Section |  |  | CLS
Working Hours Record Sheet |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Accounting period begins |  |  |  | 2009-06-29 00:00:00
 |  | w/c | 2009-06-29 00:00:00 |  |  |  | w/c | 2009-07-06 00:00:00 |  |  |  | w/c | 2009-07-13 00:00:00 |  |  |  | w/c | 2009-07-20 00:00:00
Day |  | Time On | Time Off | No. of Hours |  |  | Time On | Time Off | No. of Hours |  |  | Time On | Time Off | No. of Hours |  |  | Time On | Time Off | No. of Hours
Monday | am |  |  | 0 | 0 |  |  |  | 0 | 0 |  |  |  | 0 | 0 |  |  |  | 0 | 0
 | pm |  |  | 0 | 0 |  |  |  | 0 | 0 |  |  |  | 0 | 0 |  |  |  | 0 | 0
Tuesday | am |  |  | 0 | 0 |  |  |  | 0 | 0 |  |  |  | 0 | 0 |  |  |  | 0 | 0
 | pm |  |  | 0 | 0 |  |  |  | 0 | 0 |  |  |  | 0 | 0 |  |  |  | 0 | 0
Wednesday | am |  |  | 0 | 0 |  |  |  | 0 | 0 |  |  |  | 0 | 0 |  |  |  | 0 | 0
 | pm |  |  | 0 | 0 |  |  |  | 0 | 0 |  |  |  | 0 | 0 |  |  |  | 0 | 0
Thursday | am |  |  | 0 | 0 |  |  |  | 0 | 0 |  |  |  | 0 | 0 |  |  |  | 0 | 0
 | pm |  |  | 0 | 0 |  |  |  | 0 | 0 |  |  |  | 0 | 0 |  |  |  | 0 | 0
Friday | am |  |  | 0 | 0 |  |  |  | 0 | 0 |  |  |  | 0 | 0 |  |  |  | 0 | 0
 | pm |  |  | 0 | 0 |  |  |  | 0 | 0 |  |  |  | 0 | 0 |  |  |  | 0 | 0
Saturday | am |  |  | 0 | 0 |  |  |  | 0 | 0 |  |  |  | 0 | 0 |  |  |  | 0 | 0
 | pm |  |  | 0 | 0 |  |  |  | 0 | 0 |  |  |  | 0 | 0 |  |  |  | 0 | 0
Sunday | am |  |  | 0 | 0 |  |  |  | 0 | 0 |  |  |  | 0 | 0 |  |  |  | 0 | 0
 | pm |  |  | 0 | 0 |  |  |  | 0 | 0 |  |  |  | 0 | 0 |  |  |  | 0 | 0
Total |  | Week 1 |  | 0 | 0 |  | Week 2 |  | 0 | 0 |  | Week 3 |  | 0 | 0 |  | Week 4 |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 3 |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 2 |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 1 |  | 0 | 0
 | I certify that the details entered on this sheet are correct |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sub-total |  | 0 | 0
Employee's Signature |  |  |  |  |  |  | Date |  |  | [NAME]'s Signature |  |  |  |  |  |  | Date
Spreadsheet: 235185d1368402051-help-merging-two-tables-book1
Sheet: Sheet2

Item Code | Full Description
94231 | 1st Enterprise Bank
91417 | BNP Paribas
75748 | BANK OF AMERICA CORP
75725 | BANK OF CHINA
72769 | BANK OF CYPRUS
64609 | BANK OF KYOTO
64502 | Citigroup
63791 | BANK OF QUEENSLAND
59987 | BANK EAST ASIA LTD
38800 | BANK OF YOKOHAMA LTD
32096 | JPMorgan Chase
28954 | Deutsche Bank
16949 | Mitsubishi UFJ Financial Group
12730 | Hong Kong and Shanghai Banking Corporation
Spreadsheet: 226681d1365477935-selecting-a-table-based-on-drop-down-list-condition-specification_database
Sheet: Sheet3

SITE A | SITE ID | HUB001
 | Site NAME | [NAME]
 | LATITUDE | 09 26 21.46 S
 | LONGITUDE | 159 57 02.70 E
 | ELEVATION | 67 m ASL
SITE B | Site ID | HUB002
 | Site NAME | LEITONGO
 | LATITUDE | 09 00 43.80 S
 | LONGITUDE | 160 03 50.90 E
 | ELEVATION | 236 m ASL
 | PATH LENGTH | 48.86km
VENDOR  SPECIFICATIONS | VENDOR | Ericsson  [NAME] | [NAME]. IP | [NAME]. IP
 | BAND | 3.8GHz | 3.8GHz | 3.8GHz
 | CAPACITY | 236T mbps | 257 mbps | 350 mbps
 | CHANNEL SPACING | 40 MHz | 40 MHz | 56 MHz
 | MODULATION | 256 QAM | 256 QAM | 256 QAM
ANTENNA  SPECIFICATIONS | ANTENNA TYPE | HSX6-36/A | HSX6-36/A | HSX6-36/A
 | ANTENNA SIZE | 1.8m all both ends | 1.8m all both ends | 1.8m all both ends
 | ELLIPTICAL WAVEGUIDE | EWP37 | EWP37 | EWP37
[NAME] CALCULATION | AVAILABILITY (%) | 0.9999984 | 0.999999 | 0.9999913
 | DOWNTIME (min pa) | 0.8448333333333333 | 0.503 | 4.574833333333333
 | DOWNTIME (seconds pa) | 50.69 | 30.18 | 274.49
 | SD IMPROVEMENT FACTOR | 68.21 | 88.89 | 29.59
Spreadsheet: 250c6a37-042a-4919-bc13-416a932afce2
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
BOT | Test | BOT | Botrytis cinerea, IgE | [NAME], IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
BOT | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
BOT | Result | BOT | [NAME], IgE | [NAME], IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6049-1
Spreadsheet: 87726d1287588891-excel-2007-x-axis-formatting-help-with-excel
Sheet: Sheet2

 | SAMPLE
 |  | 2010-07-10 00:00:00 |  |  |  |  | 2010-08-10 00:00:00
 |  | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 1 | Week 2 | Week 3 | Week 4 | Week 5
Field 1 |  | 18 |  |  |  |  | 180
Field 2 |  | 25.566667 |  |  |  |  | 107.563334
Field 3 |  | 25.566667 |  |  |  |  | 132.488905
Field 4 |  | 2 | 4 | 6 | 8 | 10 | 2 | 4 | 6 | 8 | 10
Spreadsheet: darrell_schoolcraft__7303__imball0201
Sheet: PGETX

 |  |  |  |  | 12283
 | [NAME] |  | Pecos Del |  | Gunpoint #2
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | -80030 | -24949 |  | -55000
2 | -80766 | -25000 |  | -55000 |  |  |  |  |  |  |  |  |  | Avg
3 | -137218 | -51083 |  | -84879 |  |  |  |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount
4 | -104302 | -36052 |  | -67165
5 | -96064 | -28622 |  | -67000
6 | -96167 | -28417 |  | -67000 |  |  |  |  |  | 2001-01-01 00:00:00 | -715680 | -705664 |  | 8.21
7 |  |  |  |  |  |  |  |  |  | 2001-02-01 00:00:00 | -661568 | -648307 |  | 5.62
8 |  |  |  |  |  |  |  |  |  | 2001-03-01 00:00:00 | -1831536 | -1828209 |  | 4.98
9 |  |  |  |  |  |  |  |  |  | 2001-04-01 00:00:00 |  | -3486797 |  | 4.87
10 |  |  |  |  |  |  |  |  |  | 2001-05-01 00:00:00 | -3735499 | -3753054 |  | 3.82
11 |  |  |  |  |  |  |  |  |  | 2001-06-01 00:00:00 |  | -5025875 |  | 3.2
12 |  |  |  |  |  |  |  |  |  | 2001-07-01 00:00:00 | -4565965 | -4525416 |  | 2.77
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 |  |  |  | 2001-12-31 00:00:00 |  |  | -68258
 |  |  |  | 2002-01-06 00:00:00
 | CBS Volume
 |  |  |  | -5084
Spreadsheet: 30342d1225819638-how-to-group-dates-into-month-excelforum_2003_upload
Sheet: Sheet6

 | Data
Date | Sum of Catergory 2 | Sum of Catergory 1
2007-01-01 00:00:00 | 2.8 | 0
2007-02-01 00:00:00 | 8.100000000000001 | 0
2007-03-01 00:00:00 | 6.75 | 1.35
2007-04-01 00:00:00 | 8.95 | 2.55
2007-05-01 00:00:00 | 4.05 | 1.55
2007-06-01 00:00:00 | 3.85 | 1.5
2007-07-01 00:00:00 | 3.05 | 0.4
2007-08-01 00:00:00 | 4.15 | 0.8
2007-09-01 00:00:00 | 7.949999999999999 | 1.9
2007-10-01 00:00:00 | 6.149999999999999 | 2.25
2007-11-01 00:00:00 | 6.15 | 1.75
2007-12-01 00:00:00 | 4.899999999999999 | 2.1
2008-01-01 00:00:00 | 5.15 | 2.8
2008-02-01 00:00:00 | 4.4 | 2.45
2008-03-01 00:00:00 | 5.15 | 2.45
2008-04-01 00:00:00 | 3.95 | 1.55
2008-05-01 00:00:00 | 3.6 | 4.1
2008-06-01 00:00:00 | 7.050000000000001 | 13.6
2008-07-01 00:00:00 | 3.1 | 14.25
2008-08-01 00:00:00 | 2.4 | 5.999999999999999
2008-09-01 00:00:00 | 4 | 12.1
2008-10-01 00:00:00 | 4.2 | 10.5
Grand Total | 109.85 | 85.95
Spreadsheet: 159650d1338803930-excel-2007-extracting-alphanumeric-strings-hms
Sheet: Sheet1

 |  | hours | mins | seconds
1d8h0m |  | 32 | 0 | 0
7d7h22m |  | 175 | 22 | 0
20d17h22m |  | 497 | 22 | 0
15h57m16s |  | 15 | 57 | 16
2h37m20s |  | 2 | 37 | 20
14h7m5s |  | 14 | 7 | 5
1h1m1s |  | 1 | 1 | 1
Spreadsheet: chris_germany__2319__2001tran02
Sheet: Feb Matrix

Transco FT Commodity |  |  |  |  |  |  |  |  | CGAS FT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2.8 |  |  | 3.03
 | 1 | 2 | 3 | 4 | 4A | 5 | 6 |  | CGAS Fuel
1
2 |  |  |  |  |  |  |  |  | CNG FT
3 |  |  |  |  |  |  |  |  | CNG Fuel
4
4A
5 |  |  |  |  |  |  |  |  |  |  |  |  | St 65
6 |  |  |  |  |  |  |  |  | [NAME] |  |  |  | 4.46 | 4.455
 | INCLUDES GRI ($0.0072) and Great Plains Surcharge ($0.0131) |  |  |  |  |  |  |  | Iroq -GRI |  |  |  | 4.42 | 4.44
TETCO | to:  St. 65 | STX | WLA | ELA |  |  |  |  | [NAME]
Zn 3 - 65 |  |  |  |  | "ELA Rate Assumes $0.0622 'IT'" |  |  |  | Total |  |  | Ela
TRCO IT Rates |  | 2 | 3 | 4 | 4A | 5 | 6
2
3
4
6
 | Note:  2-2, 2-3, and 3-3 rates do not include surcharges.
Tenn FT Commodity
 |  | Toca/Patt |  |  |  |  |  |  |  |  |  | [NAME]
 |  | Kinder | Hiedelburg
 | Chicago | Carnes | Rosehill | Pugh | Varibus | Zone 2 | Zone 3 | Zone 4 | Zone 5 | Zone 6
0 |  |  |  |  |  |  |  |  |  |  |  | Stx
L
1
2
4
5
6
MGT Rate |  |  |  |  | [NAME] include GRI of $0.0075
Fuel |  |  |  |  | [NAME] difference:
 |  |  |  |  | [NAME] difference:
TETCO FT Commodity using April - November Fuels
 | STX | LRC | [NAME] | M-1 | M-2 | M-3 |  |  | It to M2 | It to M3
STX
ETX
WLA
ELA
M1
M2
M3
 |  |  |  |  | Texas Gas FT Commodity
Sonat | 0-0 | 0-1 | 0-2 | 0-3 |  | SL-Inter | SL-Intra | 1 | 4
 |  |  |  |  | SL
 |  |  |  |  | 1
Gulf Onshore IT-Mainline FT |  |  |  |  | Algonquin |  |  | NFG | [NAME] 3 |  | FT
 | Off | On | Leach |  | Commodity and Fuel
Off |  |  |  |  | AFT-1
On |  |  |  |  |  |  |  |  | FEBRUARY, 2001
ML |  |  |  |  |  |  | TENNESSEE GAS PIPELINE: SPECIAL TRANS. RATES
 | Offshore and [NAME] are IT rates |  |  |  |  |  | 0 | L | 1 | 2 | 3
 |  |  |  |  |  | 0
 |  |  |  |  |  | L
Transport expense using Prices shown below |  |  |  |  |  | 1
Trco Z1 |  |  | CGLF On
[NAME] |  |  | M/L
Trco Z3 |  |  | TGT Sl
[NAME] |  |  | [NAME]
[NAME] |  |  | TGP/NFG Niagara
Stx |  |  | CNG SP
[NAME] |  |  | CGAS
Ela |  |  | Iroquois
M1
M3 |  |  | [NAME]
Spreadsheet: 5fd672bb-43f8-4368-b6e0-3308d0b14fc7
Sheet: Demand Curve

a = | 1 | b = | 1 | Py = |  | I =
increment | 0.2
[NAME]
0
Spreadsheet: 878168d1725197269-help-with-filter-formula-usd-payments
Sheet: Transactions

Date | Bank | Name | I.D Number | Account | Account Number | Group Code | Group | Description | Invoice | Reference | ZWL VAT | USD VAT | [NAME] | [NAME] | USD Debit | USD Credit
2024-02-01 00:00:00 | Cash - US$ |  |  | Feeding Programme | 2810 | P1 | Payment for general and administrative expenses |  |  | 2160 | First Term |  |  |  | 4
2024-01-31 00:00:00 | US$ |  |  | Vehicle Maintenance | 2710 | P1 | Payment for general and administrative expenses |  |  | 2161 | First Term |  |  |  | 80
2024-02-06 00:00:00 | Cash - US$ |  |  | Vehicle Maintenance | 2710 | P1 | Payment for general and administrative expenses |  |  | 2168 | First Term |  |  |  | 1
2024-02-06 00:00:00 | US$ | Net Salaries | ST 002 | Salaries & Wages | 2500 | D10 | Payment for salaries & Wages |  |  | 2169 | First Term | Sundry |  |  | 813
2024-01-31 00:00:00 | US$ |  |  | Sundry Expenses | 2760 | P1 | Payment for general and administrative expenses | TARMS REGISTRATION |  | 2173 | First Term |  |  |  | 50
2024-02-08 00:00:00 | US$ | Net Salaries | ST 002 | Salaries & Wages | 2500 | P2 | Payment for salaries & Wages |  |  | 2178 | First Term | Sundry |  |  | 833
2024-02-08 00:00:00 |  |  |  | Vehicle Maintenance | 2710 | P1 | Payment for general and administrative expenses |  |  | 2179 | First Term |  |  |  | 1
2024-02-09 00:00:00 | Cash - US$ |  |  | Vehicle Maintenance | 2710 | D10 | Payment for general and administrative expenses |  |  | 2180 | First Term |  |  |  | 4
2024-02-09 00:00:00 | US$ |  |  | Feeding Programme | 2810 | P1 | Payment for general and administrative expenses |  |  | 2181 | First Term |  |  |  | 100
2024-01-31 00:00:00 | Cash - US$ | LIAM MPALA | CT 056 | Fees | 2000 | C1 | Cash receipts from customers |  |  | 16642 | First Term | Customer |  |  |  | 20
2024-01-31 00:00:00 |  | MUZIWANDILE NDEBELE | CT 074 | Fees | 2000 | C1 | Cash receipts from customers |  |  | 16643 | First Term | Customer |  |  |  | 400
2024-01-26 00:00:00 | US$ | LINDANI NCUBE | CT 051 | Fees | 2000 | D10 | Cash receipts from customers |  |  | 16801 | First Term | Customer |  |  |  | 200
2024-01-28 00:00:00 | US$ | ZOLANI DUBE | CT 152 | Fees | 2000 | C1 | Cash receipts from customers |  |  | 16802 | First Term | Customer |  |  |  | 200
2024-01-30 00:00:00 | US$ | LINDANI NCUBE | CT 051 | Fees | 2000 | C1 | Cash receipts from customers |  |  | 16803 | First Term | Customer |  |  |  | 200
2024-01-03 00:00:00 | Swipe - ZIG | NATHANIEL MUGWAGWA | CT 395 | Fees | 2000 | C1 | Cash receipts from customers |  |  | 16055 | First Term | Customer |  | 450000