tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 272801d1382515214-sum-if-difference-is-positive-negative-book2
Sheet: 6 Mth Debt Values

6 Mth Debt (excl tax)
Project Number | M | A | M | J | J | A | S | O | N | D | J | F | M
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
378300 | 0 | 0 | 0 | 0 | 0 | 0 | 0
378395 | 0 | 0 | 0 | 0 | 0 | 0 | 0
378396 | 0 | 0 | 0 | 0 | 0 | 0 | 0
719900 | 0 | 0 | 0 | 0 | 0 | 0 | 50
725829 | 0 | 0 | 0 | 0 | 0 | 0 | 0
781392 | 0 | 0 | 0 | 0 | 0 | 0 | 0
800147 | 0 | 0 | 0 | 0 | 0 | 0 | 0
800148 | 0 | 0 | 0 | 0 | 0 | 0 | 0
800149 | 0 | 0 | 0 | 0 | 0 | 0 | 0
800150 | 0 | 0 | 0 | 0 | 0 | 0 | 0
800152 | 0 | 0 | 0 | 0 | 0 | 0 | 0
800153 | 0 | 0 | 0 | 0 | 0 | 0 | 0
800154 | 965.1151460906744 | 965.11 | 965.11 | 965.11 | 0 | 0 | 0
947600 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1148500 | 3433.499709577755 | 3433.5 | 3433.5 | 3433.5 | 3433.5 | 3433.5 | 0
1174000 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1174100 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1175600 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1697892 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1697894 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1775161 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1819603 | 8547 | 8547 | 8547 | 8547 | 8547 | 8547 | 5000
1819614 | 1370 | 1370 | 1370 | 1370 | 1370 | 1370 | 1370
2098500 | 49140.08924511334 | 49140.08 | 49140.08 | 49140.08 | 49140.08 | 49140.08 | 49140.08
2099847 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2099875 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2149600 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2158100 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2161600 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2161665 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2163000 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2165100 | 0 | 0 | 0 | 0 | 0 | 0 | 800
2167600 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2167670 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2168100 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2171500 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2186300 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2187400 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2198200 | 9284.175122166416 | 9284.18 | 9284.18 | 9284.18 | 9284.18 | 9284.18 | 9284.18
2198863 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2198900 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2208900 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2212300 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2215400 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2227100 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2232298 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2237801 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2242516 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2243400 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2244100 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2244450 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2244499 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2249100 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2250100 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2250101 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2257100 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2257199 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2258300 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2262300 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2264200 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2267701 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2272900 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2274400 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2277204 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2277302 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2277318 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2277321 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 99512d1298127269-excel-2007-formula-to-get-data-and-insert-in-1-row-datas
Sheet: Sheet1

a1 | a2 | a3 | a4 | a5 | a6 | a7 | [NAME] | ALL DATA
 |  | apple
 |  |  | banana
water
 |  |  |  | orange
 | [NAME]
 |  |  |  |  |  | student
 |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME]
Spreadsheet: lynn_blair__24470__NNGWKednotes_2001
Sheet: Mar 3 & 4, 2001

NNG WEEKEND NOTES
For cc Mail distribution:  [NAME], [NAME], [NAME], S. January, [NAME], [NAME], [NAME], TMS OnCall
SATURDAY |  |  | 2001-03-03 00:00:00
Mail distribution send to the above listing on Sunday evening.
H:\DATA\Process Guidelines\[NNGWKednotes Template.xls]Dec 25 & 26
 | PROCESS |  |  |  | COMMENTS:
 | Gas Day: | SAT |  |  | No difficulties with the process.
 | 7:00 A.M. Non-grid:
 | Gas Day: | FRI |  |  | No difficulties with the process.
 | 8:00 AM Final Storage
 | Gas Day: | SAT |  |  | No difficulties with the process.
 | 10:00 A.M. Intraday 1:
 | Gas Day: | SAT |  |  | No difficulties with the process.
 | 5:00 P.M. Intraday 2:
 | Gas Day: | SUN |  |  | No difficulties with the process.
 | 11:30 A.M. Timely
 | Gas Day: | SUN |  |  | No difficulties with the process
 | 6:00 P.M. Evening
 | Other Comments:
 | On Call Reps. |  |  |  | [NAME] |  | 6:30 - 3:30
 |  |  |  |  | [NAME] |  | 6:30 - 3: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 |  |  |  | Paged IT @ 0920 a.m. confirmations were not processing.
 |  |  |  |  | [NAME] coming into office she can't access the server from home.
 | Gas Day: | SUN |  |  | No difficulties with the process.
 | 10:00 A.M. Intraday 1:
 | Gas Day: | SUN |  |  | No difficulties with the process.
 | 5:00 P.M. Intraday 2:
 | Gas Day: | MON |  |  | No difficulties with the process.
 | 11:30 A.M. Timely |  |  |  | Paged IT to determine why POI 1318 did not show up to allocate.
 |  |  |  |  | POI 1318 was under capacity 330000 due to contract balancing.
 | Gas Day: | MON |  |  | No difficulties with the process.
 | 6:00 P.M. Evening |  |  |  | Storage came up for allocation (Market Area Only)
 |  |  |  |  | paged [NAME] , did not allocate
 | Other Comments:
 | On Call Reps: |  |  |  | [NAME] |  | 6:30 - 3:30
 |  |  |  |  | [NAME] |  | 6:30 - 3:30
 |  |  |  |  | [NAME] |  | 1:00 - 10:00
 |  |  |  |  | [NAME] |  | 1:00 - 10:00
Spreadsheet: 862226d1709972498-convert-a-vertical-calendar-table-to-a-normal-layout-by-month-calendar-from-list-aligw
Sheet: Yearly Calendar

2024 | Calendar
Date | January | February | March | April | May | June | July | August | September | October | November | December
1 |  | Mental Health |  |  | Acupuncture, Reiki
2 | Massasge | Massage |  | Esophagram | Teeth Cleaning
3 | [NAME] Shoulder Acupuncture |  |  | Shoulder PT Acupuncture, Reiki
4
5 |  |  | Massage
6 |  | Massage | Shoulder PT Swallow Evaluation Acupuncture, Reiki
7 |  | Acupuncture Reiki |  |  | Massage
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Spreadsheet: 88203cd8-1541-49fc-8c1c-ae740682f317
Sheet: Sheet1

Unnamed: 0
INSTRUCCIONES
[NAME] a que hay información que se comparte entre las diferentes hojas del Excel, la cuenta [NAME] por orden, empezando por la hoja "1-declaracions".
[NAME] celdas sombreadas en azul no se deben  rellenar, [NAME] o las rellena la administración.
[NAME] primera hoja, "[NAME]", detalla la documentación que debe contener la memoria económica final y la relaciona con las diferentes hojas de la cuenta justificativa
[NAME] las hojas tienen que ir firmadas por el representante legal de la entidad y llevar el sello de la entidad beneficiaria.
Instrucciones para [NAME]: "Documentos"
[NAME] debe indicar, con la ayuda de los desplegables de los recuadros pequeños de la izquierda, los documentos que se presentan y conforman [NAME] final.
Instrucciones para [NAME] 1("Declaraciones")
[NAME] debe elegir en el desplegable de la celda "tipo de proyecto", la modalidad de proyecto por la cual se solicitó [NAME], ya que determina diferentes campos [NAME].
Instrucciones para [NAME] 2 ("Justificantes")
[NAME] esta hoja se distingue entre los gastos que se justifican mediante [NAME] y tarjetas de embarque. Los gastos de alojamiento, [NAME] interno, que se ajusten al presupuesto aceptado y a las cantidades del anexo 7 de la convocatoria, se justifican automáticamente a través de las tarjetas de embarque originales. En caso que la entidad presupueste y justifique una cantidad mayor en estos conceptos, se deberá justificar como el resto de partidas, es decir, mediante la presentación de los justificantes de gasto originales o copias compulsadas.
[NAME] esta hoja se debe anotar el presupuesto aprobado y todos los justificantes de gasto que haya generado el proyecto dentro de cada celda con su información pertinente. [NAME] imputado tiene que [NAME] con el porcentaje que aparece en el sello estampillado en la factura original.
[NAME] hay justificantes en moneda extranjera se debe aportar [NAME] aplicado
[NAME] total a justificar del proyecto es el presupuesto aprobado más los intereses generados. La cantidad a justificar aparece en la celda que [NAME] nombre indica en el recuadro del final de la hoja.
Instrucciones para [NAME] 3 ("Presupuesto")
[NAME] esta hoja se [NAME], diferenciando las contribuciones exteriores (CAIB, ONGD ...) de las contribuciones locales ([NAME] local, beneficiarios ...). En la columna "Total justificado" se debe indicar el sumatorio de justificantes de gasto de cada [NAME] 3 " justificantes".
[NAME] se debe señalar en la celda correspondiente los motivos por los que se han producido estas desviaciones.
Instrucciones para [NAME] 5("Reintegro")
[NAME] deben indicar los datos del representante legal de la entidad (nombre, DNI, cargo), escoger el motivo de la devolución y señalar el capítulo presupuestario [NAME] pertenece el proyecto ejecutado.
[NAME] proceder a la devolución, siguiendo las indicaciones que figuran en la parte inferior de la hoja
Spreadsheet: 723905d1615941015-need-help-with-filtering-formula-temp1
Sheet: DataFilter

Bank Register
Bank Name |  | Account Type |  | Account Number |  | Account Descrption
BearState |  | Savings
CityBank
FirstBank
Bank Name: |  | The bank name uses the formula "UNIQUE(Bank_Info[Name])" to get the Bank Name from the Bank Info sheet to populate the list of bank names on the Bank Register Sheet.
Account Type: |  | The account type is using the formula "UNIQUE(FILTER(Bank_Info[Account Type],Bank_Info[Name]=Bank_Register[@Bank],""))" The problem I am having here is that it only populates the list off of Bank Register: A4. Not a problem until I get to B5, B6, [NAME] and etc on the Bank Register Sheet. Because it still looks in A4 on the Bank Register Sheet when I need B4 to look in A4, B5 look in A5, B6 look in A6, B7 look in A7 and etc. Which brings me to thinking I am using the wrong formulas?
Account Number: |  | Here I believe I will have the same issues as Account Type at the begining. I have used the steps in the YouTube Video below to try and at lest get the correct Account Numbers to show up for A4. It seems as if something is not working their ether. Any help is much appricated. Thanks
[NAME]: |  | https://youtu.be/fDB1Ktyhp3Y
Spreadsheet: 726717d1617383648-replace-duplicated-values-with-unique-values-replacing-duplicated-values
Sheet: Sheet1

order-id
[PHONE]-7587448
[PHONE]-7587448
[PHONE]-7587448
[PHONE]-7587448
[PHONE]-7587448
[PHONE]-7587448
[PHONE]-4516231
[PHONE]-4516231
[PHONE]-4516231
[PHONE]-4516231
[PHONE]-4516231
[PHONE]-4516231
[PHONE]-8542636
[PHONE]-8542636
[PHONE]-8542636
[PHONE]-8542636
[PHONE]-8542636
[PHONE]-8542636
[PHONE]-8567460
[PHONE]-8567460
[PHONE]-8567460
[PHONE]-8567460
[PHONE]-8567460
[PHONE]-8567460
[PHONE]-8567460
[PHONE]-8567460
[PHONE]-8567460
[PHONE]-6761038
[PHONE]-6761038
[PHONE]-6761038
[PHONE]-6761038
[PHONE]-6761038
[PHONE]-6761038
[PHONE]-8426656
[PHONE]-8426656
[PHONE]-8426656
[PHONE]-8426656
[PHONE]-8426656
[PHONE]-8426656
Spreadsheet: 8fb65508-28f8-46cf-a438-d3379f74a9b7
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7530 | 9358 | Lynette | Fischer | RSA | 0 | 00:29:01 | 00:00:36 | 01:21:16 | [NAME] | 00:54:26 | 1 | 02:45:40
Spreadsheet: 28189d1222182613-gathering-and-listing-data-from-another-sheet-copy-of-master-file-1-
Sheet: Select

Last row in CLIP | Got a Valid Value? | Row pos. of ED No. | CLIP Record Number | Process Date | CLIP Date | Ed.Number | Clip No |  | days between Start and Clip dates | days between Finish and [NAME] dates | Is CLIP date between Start and Finish Dates?
30 | 1 | 6 | 1 | 2008-07-10 00:00:00 | 2008-07-08 00:00:00 | PH206 / 416 | 1001 |  | -8 | 29 | 1
 | 1 | 9 | 1 | 2008-07-11 00:00:00 | 2008-07-08 00:00:00 | ME69 / 239929 | 1001 |  | -8 | 29 | 1
Last Row in this sheet | 1 | 11 | 1 | 2008-07-19 00:00:00 | 2008-07-08 00:00:00 | PF161 / 380 | 1001 |  | -8 | 29 | 1
 | 0 | #N/A | #N/A | #N/A | #N/A |  | #N/A |  | #N/A | #N/A | 0
 | 0 | #N/A | #N/A | #N/A | #N/A |  | #N/A |  | #N/A | #N/A | 0
3 | 0 | #N/A | #N/A | #N/A | #N/A |  | #N/A |  | #N/A | #N/A | 0
 | 0 | #N/A | #N/A | #N/A | #N/A |  | #N/A |  | #N/A | #N/A | 0
 | 0 | #N/A | #N/A | #N/A | #N/A |  | #N/A |  | #N/A | #N/A | 0
Spreadsheet: 167902d1342150578-a-complicated-look-up-table-with-multiple-conditions-complexlookup
Sheet: Result

 |  |  |  |  | 2012 | 2012 | 2012 | 2012 | 2012 | 2012 | 2012 | 2012 | 2012 | 2012 | 2012 | 2012 | 2013 | 2013 | 2013 | 2013 | 2013 | 2013 | 2013 | 2013 | 2013 | 2013 | 2013 | 2013
 |  |  |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
[NAME] |  |  | You should have a column for each criteria
TM72006 | [NAME](Z9002) | Z9002 |  | In Brand Text column from LookUP Data tab | 60 | 60 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TM72001 | [NAME]  (ZCT) | [NAME] |  | In Brand Text column from LookUP Data tab | 85 | 85 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TM72004 | TMF ACRYLIC 1-P (ZMB00) | [NAME] |  | In Product Size column from LookUP Data tab | 53 | 56 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TM72001 | TMF ACRYLIC 3-P (ZMA00) | ZMA00 |  | In Product Size column from LookUP Data tab | 63 | 75 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TM72006 | Phaco Tips | Reusable Tips | Disposable Tips | In Brand Text column from LookUP Data tab, 2 combined look up vales | 138 | 140 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TM72001 | PHACO ACC- FX [NAME] | Sovereign Accessories |  | In Brand Text column from LookUP Data tab | 34 | 34 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TM72001 | Phaco Equipment / Signature $ | WhiteStar Signature |  | In Brand Text column from LookUP Data tab | 32 | 32 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TM72001 | Fitzory | Kalmore |  | Not there in the Look UP Data | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Look UP Values |  | Look Up Values |  |  | to auto populate Net Sales Values values
from Terr Surg column of LookUP [NAME] |  | some of these values are found in "Brand Text" column and Some in "Product Size Column" |  |  | ( if value not there, should appear as blank, no #NA vales to be there)
Spreadsheet: 822941d1679604251-replace-repetitive-formulas-with-lambda-sample-replace-individual-formulas-with-lambda
Sheet: Sheet1

Statement | Position | Serial
2018 08 10
2018 08 10
2018 08 10
2018 08 10
2018 08 10
2018 08 10
2018 08 10
2018 09 11
2018 09 11
2018 09 11
2018 09 11
2018 09 11
2018 09 11
2018 09 11
2018 09 11
2018 09 11
2018 10 11
2018 10 11
2018 10 11
2018 10 11
2018 10 11
2018 10 11
2018 10 11
2018 10 11
2018 10 11
2018 10 11
2018 10 11
2018 11 09
2018 11 09
2018 11 09
2018 11 09
2018 11 09
2018 11 09
2018 11 09
2018 11 09
2018 11 09
Spreadsheet: 106031d1303257361-excel-2007-unique-conditional-formatting-highlight-revisions
Sheet: Sheet1

 | Helper | Flag | [NAME] for Helper | Formula for Flag
1000 A |  |  | =IF(CODE(RIGHT(A2,1))<65,CODE(RIGHT(A2,1))+100,CODE(RIGHT(A2,1))) | =IF(AND(LEFT(A2,4)=LEFT(A3,4),B2<B3),"","*")
1000 B |  |  | … and drag down | … and drag down |  |  |  |  |  |  |  | 00:00.0
1000 0
1000 1
1001 A
1001 B
1002 A
Spreadsheet: 72707d1273433178-help-with-an-excel-lookup-forumula-that-returns-column-heading-student_presentations
Sheet: Presenter 7

Seats | Presenter 7 Time Slot 1 | Presenter 7 Time Slot 2 | Presenter 7 Time Slot 3 | Presenter 7 Time Slot 4 | Presenter 7 Time Slot 5 | Presenter 7 Time Slot 6 | Presenter 7 Time Slot 7 | Presenter 7 Time Slot 8
1 |  |  |  |  |  |  |  | Student 19
2 |  |  |  |  |  |  |  | Student 18
3
4
5
6
7
8
9
10
11
12
13
14
15
Spreadsheet: 90999d1290683439-shift-range-down-by-x-amount-of-rows-shift-rows-ex
Sheet: Working sheet

 |  | Week
 |  | 47
Account | Product | Week | Account Manager | Comments | Status
abc123 | 123456 | 47 | Rita | No sales | Closed
abc246 | 456789 | 47 | [NAME] | Chase up | Open
zyx123 | 789123 | 46 | Sue
[NAME] | 753159 | 46 | Too
Spreadsheet: 201282d1355936043-maintaining-cell-references-sample
Sheet: Sheet1

 | Jan | Feb | March | April |  |  |  |  |  | Jan | Feb | March | April
Salary |  | etc |  |  |  |  |  |  | Salary |  | etc
Discretionary |  | etc |  |  |  |  |  |  | Discretionary |  | etc
Office Related |  | etc |  |  |  |  |  |  | Office Related |  | etc
Wages | 22 | etc |  |  |  |  |  |  | Postage | 15 | etc
Food | 11 | etc |  |  |  |  |  |  | Food | 11 | etc
PTO | 33 | etc |  |  |  |  |  |  | Wages | 22 | etc
Entertainment | 10 | etc |  |  |  |  |  |  | Entertainment | 10 | etc
Overtime | 12 | etc |  |  |  |  |  |  | PTO | 33 | etc
Postage | 15 | etc |  |  |  |  |  |  | Overtime | 12 | etc
Computers | 16 | etc |  |  |  |  |  |  | Computers | 16 | etc
Spreadsheet: 841615d1693809773-date-and-time-matching-between-2-sheets-new-microsoft-excel-worksheet
Sheet: Sheet1

Date | Time | Value
2023-08-02 00:00:00 | 20:15:00.000000 | 35412
2023-08-02 00:00:00 | 20:16:00.000000 | 35412
2023-08-02 00:00:00 | 20:17:00.000000 | 35410
2023-08-02 00:00:00 | 20:18:00.000000 | 35411
2023-08-02 00:00:00 | 20:19:00.000000 | 35411
2023-08-02 00:00:00 | 20:20:00.000000 | 35415
2023-08-02 00:00:00 | 20:21:00.000000 | 35417
2023-08-02 00:00:00 | 20:22:00.000000 | 35417
2023-08-02 00:00:00 | 20:23:00.000000 | 35417
2023-08-02 00:00:00 | 20:24:00.000000 | 35415
2023-08-02 00:00:00 | 20:25:00.000000 | 35417
2023-08-02 00:00:00 | 20:26:00.000000 | 35417
2023-08-02 00:00:00 | 20:27:00.000000 | 35417
2023-08-02 00:00:00 | 20:28:00.000000 | 35419
2023-08-02 00:00:00 | 20:29:00.000000 | 35420
2023-08-02 00:00:00 | 20:30:00.000000 | 35420
Spreadsheet: phillip_m_love__30161__9901_OA
Sheet: WE-GL 

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM)
REGION:  WEST
 |  |  | Total |  | Reclasses |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | September |  | October |  | November |  | December |  | January |  | February |  | March |  | April |  | May |  | June |  | 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 | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 58621 | 165522.51 | 58621 | 165522.51
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -58621 | -165522.51 | -58621 | -165522.51
7 |  | Liquidations |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
Spreadsheet: jonathan_mckay__17203__Tariffs New Update
Sheet: Cost Components

TARIFF SUMMARY
Transportation Point | F. Variable Components
ABC to [NAME] | ANG Firm Commodity+NEB Cost Recovery Charge
ABC to Stanfield* | [NAME] to Stanfield Fuel Ratio+ANG Firm Commodity+NEB Cost Recovery+ Stanfield Deliveries;Commodity Charge, ACA and GRI
ABC to Stanfield (NWPL)* | NWP Postage Stamp*(PGT Commodity Charge+ACA)+Northwest Postage Stamp*Kingsgate to StanfieldFuel Ratio*(ANG Firm Commodity+NEB Cost Recovery Charge)+ NWP Firm Commodity +GRI + ACA Charges
ABC to Malin* | [NAME] to [NAME] deliveries;Commodity Charge+ACA+GRI
Empress to Saskatchewan | TCPL's Empress to Sask. Commodity Toll
Empress to GLGT | TCPL's Empress to Emerson Commodity Toll+GLGT Pressure Demand Toll
Empress to Dawn | TCPL's Empress to Dawn Cmmodity toll + EDA Pressure Demand Toll
Empress to [NAME] | TCPL's Empress to Niagra Commodity Toll+ENAPressure Toll
Empress to Iroquois | TCPL's Empress to Iroqouis Commodity Toll+EIAPressure Toll
Empress to Chippawa | TCPL's ECA Commodity Toll+ECA Pressure Toll
Empress to Phillipsburg | TCPL's Emp. To Phillipsburg Commodity Toll+ Ephil.A Pressure Toll
Empress to St Clair | TCPL's ESCA Commodity Toll+ ESCA Pressure Toll
Empress to Ventura
Empress to Chicago
Empress to Parkway | TCPL's E-Park Commodity Toll + E-Park Pressure Toll
Empress to St. Clair (GLGT) w/o GLGT
Emerson to St. Clair (GLGT) w/o GLGT
Emerson to Fortune Lake (GLGT) w/o GLGT
Emerson to Carlton (GLGT) w/o GLGT
Alberta to Chicago via Alliance
BC to Chicago via Alliance | 0.04/FX*1.055056
Stanfield to Malin* | PGT's Stanfield to Malin Commodity Charge+ACA+GRI
Station 2 to AECO | [NAME] |  |  |  |  |  | Q:[NAME] is the number found, what does it signify & Why is it the "summer fuel tax" Bold means:Summer Fuel Tax
Station 2 to Huntingdon | T-South Huntington Delivery Summer Fuel Tax
Station 2 to NWPL* | NWPL Postage Stamp*T-South Huntington Delivery Fuel Tax+NWPL Commodity Charge+ACA+GRI
Huntingdon to NWPL* | NWP Commodity Charge+ACA+GRI
AECO to Station 2 ** | T-North Long Haul June fuel Tax estimate
Spreadsheet: 204575d1357580513-graphs-displaying-multiple-data-sample-data
Sheet: Sheet1

T’sect Location (m) | 0 | 50 | 100 | 150 | 200 | 250
Mean % [NAME] | 0 | 37.5 | 0 | 28.25 | 32.5 | 12
Mean % Other grasses | 129 | 23.75 | 76.25 | 17.5 | 8.25 | 17.5
Mean % Moss | 48 | 26.25 | 66.25 | 76.25 | 46.25 | 0
Mean % Herbs | 40 | 18.75 | 23.75 | 8.25 | 2.5 | 26.67
Mean n.o. [NAME]. | 4 | 2.75 | 2.25 | 2.5 | 2 | 0.75
Mean n.o. Moss spp. | 1 | 1.666667 | 1.333333 | 2.666667 | 1.333333 | 0.5
Mean n.o. Herb spp. | 5 | 4.25 | 4 | 3.75 | 1.25 | 0.25
Spreadsheet: 118194d1313514745-sum-values-based-off-lookup-table-sample
Sheet: Sheet1

LOOKUP TABLE
Cat2 | HIGH
Cat5 | HIGH |  |  |  |  |  |  |  |  | You could make the table flat, but for various reasons, I'd like to avoid if at all possible.  This is what it would look like nonetheless.
Cat3 | MED
Cat4 | LOW
Cat1 | HIGH
 |  |  |  |  |  |  |  |  |  | FLAT TABLE
 |  |  |  |  |  |  |  |  |  | Cat1 |  | TypeA | 5
 |  |  |  |  | LOOKUP | TYPE | Result |  |  | Cat1 |  | TypeB | 3
 | DATA TABLE |  |  |  | HIGH | TypeA |  |  |  | Cat3 |  | TypeA | 8
Cat1 | TypeA | 5 |  |  | MED | TypeB |  |  |  | Cat1 |  | TypeA | 9
Cat1 | TypeB | 3 |  |  | LOW | TypeA |  |  |  | Cat5 |  | TypeB | 1
Cat3 | TypeA | 8 |  |  |  |  |  |  |  | Cat4 |  | TypeA | 9
Cat1 | TypeA | 9 |  |  |  |  |  |  |  | Cat4 |  | TypeB | 3
Cat5 | TypeB | 1 |  |  |  |  |  |  |  | Cat2 |  | TypeB | 8
Cat4 | TypeA | 9 |  |  | NBVC Formula (no Type filter) |  |  |  |  | Cat3 |  | TypeB | 3
Cat4 | TypeB | 3 |  |  | HIGH |  |  |  |  | Cat4 |  | TypeA | 10
Cat2 | TypeB | 8 |  |  | MED
Cat3 | TypeB | 3 |  |  | LOW
Cat4 | TypeA | 10