tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 855600d1705113770-average-if-of-unique-values-with-conditions-question-aurelien_21-
Sheet: Sheet1

Origin | Destination | Ticket | Fare | OD_Ticket | Count | Unique OD_tickets | Fare (average of unique fares if duplicate)
Pontefract | Woodlesford | ADVANCE | 5.1
Leeds | Bradford | ADVANCE | 3.5 |  |  | [NAME]
Leeds | Bradford | ADVANCE | 5.5 |  |  | Leeds - Bradford_SINGLE
Leeds | Bradford | ADVANCE | 5.5 |  |  | Castleford - Pontefract_ADVANCE
Leeds | Bradford | ADVANCE | 6
Leeds | Bradford | SINGLE | 7.5
[NAME] | Pontefract | ADVANCE | 3
[NAME] | Pontefract | ADVANCE | 4
Spreadsheet: 675414d1588273472-if-formula-to-gather-data-from-different-sheets-in-a-worksheet-lizsantiago07_demo
Sheet: lsantiago

[NAME], Angelly Michelle | 0
[NAME], [NAME] | 1
Beck, [NAME] | 2
[NAME], Gabriella Michelle | 3
Colon, Keian kenley | 0
[NAME], Aimeliz | 1
Driver, [NAME] | 2
FLORES-ALVARADO, YISLEIDI MAGALI | 2
[NAME], [NAME] | 3
[NAME], [NAME] | 0
MCGAUGHY, [NAME] | 1
Mercado, [NAME] | 0
Moore, Yaisreal Rashied | 1
[NAME], Alejandro [NAME] | 2
[NAME], [NAME] Heavenly | 3
Ramos, [NAME] | 0
[NAME], [NAME] | 1
RODRIGUEZ ARRIAGA, RICHELIEW SAMUEL | 2
[NAME], [NAME] | 2
Zelaya, Scarlet De Jesus | 3
Spreadsheet: 676970d1589120890-holidays-over-midnight-sample-time-sheet-keebellah-
Sheet: Sheet1

 |  | Total hours:
 |  |  | weekdays |  |  |  | weekend hours
 |  |  | 22:00:00 | 17:00:00 | 06:00:00
 |  |  | 06:00:00 | 22:00:00 | 08:30:00
 | start date&time | end date&time
 | 2020-05-01 20:00:00 | 2020-05-01 23:00:00
 | 2020-04-30 22:00:00 | 2020-05-01 04:00:00
 | 2020-01-03 20:00:00 | 2020-01-04 09:00:00
 | 2020-09-16 00:00:00 | 2020-09-16 05:00:00
 | 2020-01-22 02:00:00 | 2020-01-23 02:00:00
 | 2020-01-23 02:00:00 | 2020-01-23 07:00:00
 | 2020-01-24 12:00:00 | 2020-01-25 02:00:00
 | 2020-01-25 02:00:00 | 2020-01-25 10:00:00
Spreadsheet: dd008e97-b37c-403e-99ab-a8ca1bb82920
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
42755228 | 2014-08-17 02:12:07 | ALLIES | 1 | 6 | 3 | 1009110 | HO-SA-KAI | 1063 | western | 1944-06-07 | 1944-06-07 |  | Buron - 7 juin 1944
42755432 | 2014-08-17 02:32:17 | AXIS | 1 | 6 | 2 | 1009110 | HO-SA-KAI | 1063 | western | 1944-06-07 | 1944-06-07 |  | Buron - 7 juin 1944
Spreadsheet: 88641d1288433015-need-dropdown-to-auto-filter-table-and-say-custom-when-table-is-manually-filtered-dropdownautofilter
Sheet: Data

(Helper Cell)
 | NAME | Group | Category1 | Category2 | Category3 | Category4 | Category5 | [NAME]
 | Dog | B | ipsum | auctor | adipiscing | [NAME] | non
 | Elbow | D | elit | interdum | molestie | in | [NAME]
 | Flip | A | dolor | mi | Nunc | mi | justo
 | Karate | A | adipiscing | id | velit | posuere | condimentum
 | Lamp | A | sit | eget | posuere | dolor | Class
 | [NAME] | A | [NAME] | Cras | [NAME] | fermentum | congue
 | Sanchez | B | consectetur | lobortis | et | sodales | consequat
 | Stand | C | amet | eros | lectus | condimentum | aptent
Spreadsheet: 714720d1611335911-need-formual-to-auto-adjust-and-qty-formula-to-auto-allocate-percentage-and-qty
Sheet: Sheet1

Item | Old Qty % | New Qty. % | Old Qty. | New Qty.
Item 1 |  | ?? | 400
Item 2 |  | ?? | 400
Item 3 |  | 0.06 | 50
Item 4 |  | ?? | 150
Total must be 100% / 1000 Qty. |  | 1 |  | 1
 |  |  | Total qty must be 1000 | Total qty must be 1000
So I am changing percentage on Item 3 from 5 to 6%. Now I want to calculate new percentage for item 1, 2, & 4. The total for all 4 item should be 100%.
Column C - enter formula in cell C2, [NAME], C5 to calculate new % based on allocation in column b
Changing Item# 3 percentage from 5 to 6% - I Need formula to auto calculate percentage & qty. for item 1,2, & 4. Total new qty must be 1000 and % should be 100%
Spreadsheet: 24312d1214499409-formula-help-bid1a
Sheet: Sheet2

Possible choices | Number available
1001 | 2
1002 | 2
1003 | 2
1004 | 2
1005 | 2
1006 | 2
1007 | 1
1008 | 1
1009 | 1
1010 | 1
1011 | 1
1012 | 1
1013 | 1
1014 | 1
1015 | 1
1016 | 1
1017 | 1
1018 | 1
1019 | 1
1020 | 1
1021 | 1
1022 | 1
1023 | 1
1024 | 1
1025 | 1
1026 | 1
1027 | 1
1028 | 1
1029 | 1
1030 | 1
1031 | 1
1032 | 1
1033 | 1
1034 | 1
1035 | 1
1036 | 1
1037 | 1
1038 | 1
1039 | 1
1040 | 1
1041 | 1
1042 | 1
1043 | 1
1044 | 1
1045 | 1
1046 | 2
1047 | 2
1048 | 3
1049 | 3
1050 | 2
1051 | 5
1052 | 4
1053 | 5
1054 | 4
1055 | 5
1056 | 5
1057 | 1
1401 | 1
1402 | 1
1403 | 1
1404 | 1
1405 | 1
1406 | 1
1407 | 1
1408 | 1
1409 | 1
1410 | 1
1411 | 1
1412 | 1
1413 | 1
1414 | 1
1415 | 1
1416 | 1
1417 | 1
1418 | 1
1419 | 1
1420 | 1
1421 | 1
1422 | 1
1423 | 1
1424 | 1
1425 | 1
1426 | 1
1427 | 1
1428 | 1
1429 | 1
1430 | 1
1431 | 1
1432 | 1
1433 | 1
1434 | 1
1435 | 1
1436 | 1
1437 | 1
1438 | 1
1439 | 1
1440 | 1
1441 | 1
1442 | 1
1443 | 1
1444 | 1
1445 | 1
1446 | 2
1447 | 1
1448 | 2
1449 | 2
1450 | 5
1451 | 3
1452 | 3
1453 | 2
1454 | 3
1455 | 2
1456 | 2
1459 | 1
1801 | 1
1802 | 1
1803 | 1
1804 | 1
1805 | 1
1806 | 1
1807 | 1
1808 | 1
1809 | 1
1810 | 1
1811 | 1
1812 | 1
1813 | 1
1814 | 1
1815 | 1
1816 | 1
1817 | 1
1818 | 1
1819 | 1
1820 | 1
1821 | 1
1822 | 1
1823 | 1
1824 | 1
1825 | 1
1826 | 1
1827 | 1
1828 | 1
1829 | 1
1830 | 1
1831 | 1
1832 | 1
1833 | 1
1834 | 1
1835 | 1
1836 | 1
1837 | 1
1838 | 1
1839 | 1
1840 | 1
1841 | 1
1842 | 1
1843 | 1
1844 | 1
1845 | 1
Spreadsheet: 854791d1704549111-custom-formula-for-subscription-calculations-as-needed-monthly-annually-subscriptions
Sheet: Subscriptions (2)

DATE | FREQUENCY | PAYEE | AMOUNT
2024-01-01 00:00:00 | As-Needed | CallingCard.com | 10
2024-01-01 00:00:00 | As-Needed | E-Z Pass | 70
2024-01-04 00:00:00 | Monthly | SiriusXM.com | 22.89
2024-01-21 00:00:00 | Monthly | Experian.com | 29.99
2024-01-24 00:00:00 | Monthly | Netflix.com | 22.99
2024-04-14 00:00:00 | Annually | HomeAgain.com | 24.99
2024-07-27 00:00:00 | Annually | Ring.com | 39.99
 |  |  |  | MANUALLY COMPLETED
MONTH | MONTHLY AMOUNT |  |  | MONTH | MONTHLY AMOUNT | Notes for Calculation
2024-01-01 00:00:00 |  |  |  | JAN |  | As-Needed + Monthly
 |  |  |  | FEB |  | Monthly
 |  |  |  | MAR |  | Monthly
 |  |  |  | APR |  | Monthly + Annually
 |  |  |  | MAY |  | Monthly
 |  |  |  | JUN |  | Monthly
 |  |  |  | JUL |  | Monthly + Annually
 |  |  |  | AUG |  | Monthly
 |  |  |  | SEP |  | Monthly
 |  |  |  | OCT |  | Monthly
 |  |  |  | NOV |  | Monthly
 |  |  |  | DEC |  | Monthly
Spreadsheet: 222976d1363983679-group-companies-and-identify-the-ones-that-have-buyer-and-seller-pivot1
Sheet: Pivot

Option 1:
Added info to the pivot for Companies with both a [NAME] and a seller.
Count of Ile Role |  |  |  | [NAME]
Flow Date | Counterparty | Point Of Title Transfer | Volume Group Pipeline | Buyer | [NAME]
2/6/2013 | Company 5 | ANR - SE Pool | ANR |  | 3
2/6/2013 | Company 6 | ANR - SE Pool | ANR |  | 2
2013-02-01 00:00:00 | Company 1 | ANR - SE Pool | ANR | 1 | 3
2013-02-01 00:00:00 | Company 2 | ANR - SE Pool | ANR | 2
2013-02-02 00:00:00 | Company 3 | ANR - SE Pool | ANR |  | 3
2013-02-03 00:00:00 | Company 3 | ANR - SE Pool | ANR |  | 3
2013-02-04 00:00:00 | Company 3 | ANR - SE Pool | ANR |  | 3
2013-02-05 00:00:00 | Company 3 | ANR - SE Pool | ANR |  | 3
2013-02-05 00:00:00 | Company 4 | ANR - SE Pool | ANR | 2
2013-02-07 00:00:00 | Company 7 | ANR - SE Pool | ANR | 1 | 3
2013-02-07 00:00:00 | Company 8 | ANR - SE Pool | ANR |  | 2
Option 2:
Or maybe your looking for all companies to be listed and in the last column I indicated which ones have both a buyer and a seller:
Step one: Create Pivot
Count of Ile Role | [NAME]
Counterparty | Buyer | [NAME]
Company 1 | 1 | 3
Company 2 | 2
Company 3 |  | 12
Company 4 | 2
Company 5 |  | 3
Company 6 |  | 2
Company 7 | 1 | 3
Company 8 |  | 2
Step 2: Copy paste special values of pivot to analyze results
Counterparty | Buyer | [NAME] | Both?
Company 1 | 1 | 3
Company 2 | 2
Company 3 |  | 12
Company 4 | 2
Company 5 |  | 3
Company 6 |  | 2
Company 7 | 1 | 3
Company 8 |  | 2
Spreadsheet: 221300d1363458496-attemepting-to-link-and-automate-multiple-data-points-individual-rep-kpi-report-2013-example
Sheet: Todd

 | Jan |  |  | Feb |  |  | Mar |  |  | Apr |  |  | May |  |  | Jun |  |  | Jan-Jun Total
Results | Rep | Team |  | Rep | Team |  | Rep | Team |  | Rep | Team |  | Rep | Team |  | Rep | Team |  | Rep | Team
[NAME]
Act Rev
% to Goal
AB Goal
Act AB
% to Goal
[NAME]
Act Conv
% to Goal
Activity | Jan |  |  | Feb |  |  | Mar |  |  | Apr |  |  | May |  |  | Jun |  |  | Jan-Jun Total
Dial p/hr Goal |  | 8 |  |  | 8 |  |  | 7 |  |  | 7 |  |  | 7 |  |  | 7
Act Dial p/hr
% to Goal
Dial Total Goal
Act Total Dials
% to Goal
[NAME] Goal |  | 1:55:00 |  |  | 1:55:00 |  |  | 1:55:00 |  |  | 1:55:00 |  |  | 1:55:00 |  |  | 1:55:00 |  |  | 1:55:00
Act Avg Call Time
% to Goal
Drivers | Jan |  |  | Feb |  |  | Mar |  |  | Apr |  |  | May |  |  | Jun |  |  | Jan-Jun Total
OP Days |  | 20 |  |  | 21 |  |  | 21 |  |  | 21 |  |  | 22 |  |  | 21
FTE Count |  | 7.89 |  |  | 8.17 |  |  | 8.17 |  |  | 8.23 |  |  | 8.56 |  |  | 8.9
Man Hours
 | Jul |  |  | Aug |  |  | Sep |  |  | Oct |  |  | Nov |  |  | Dec |  |  | Jul-Dec Total
Results | Rep | Team |  | Rep | Team |  | Rep | Team |  | Rep | Team |  | Rep | Team |  | Rep | Team |  | Rep | Team
[NAME]
Act Rev
% to Goal
AB Goal
Act AB
% to Goal
[NAME]
Act Conv
% to Goal
Activity | Jul |  |  | Aug |  |  | Sep |  |  | Oct |  |  | Nov |  |  | Dec |  |  | Jul-Dec Total
Dial p/hr Goal | 7 | 7 |  | 7 | 7 |  | 7 | 7 |  | 7 | 7 |  | 7 | 7
Act Dial p/hr
% to Goal
Dial Total Goal
Act Total Dials
% to Goal
[NAME] Goal | 1:55:00 | 1:55:00 |  | 1:55:00 | 1:55:00 |  | 1:55:00 | 1:55:00 |  | 1:55:00 | 1:55:00 |  | 1:55:00 | 1:55:00 |  | 1:55:00 | 1:55:00 |  | 1:55:00 | 1:55:00
Act Avg Call Time
% to Goal
Drivers | Jul |  |  | Aug |  |  | Sep |  |  | Oct |  |  | Nov |  |  | Dec |  |  | Jul-Dec Total
OP Days
FTE Count
Man Hours
 | 2012 Total |  |  |  |  |  |  |  |  | 2012 Total |  |  |  |  |  | Drivers |  |  | 2012 Total
Results | Rep | Team |  |  |  |  | Activity |  |  | Rep | Team |  |  |  |  | OP Days
[NAME] |  |  |  |  |  |  | Dial p/hr Goal |  |  |  |  |  |  |  |  | FTE Count
Act Rev |  |  |  |  |  |  | Act Dial p/hr |  |  |  |  |  |  |  |  | Man Hours
% to Goal |  |  |  |  |  |  | % to Goal
AB Goal |  |  |  |  |  |  | Dial Total Goal
Act AB |  |  |  |  |  |  | Act Total Dials
% to Goal |  |  |  |  |  |  | % to Goal
[NAME] |  |  |  |  |  |  | [NAME] Goal |  |  | 1:55:00 | 1:55:00
Act Conv |  |  |  |  |  |  | Act Avg Call Time
% to Goal |  |  |  |  |  |  | % to Goal
Spreadsheet: 801580d1666262817-if-cell_1-x-from-list-1-then-cell_2-x-expanded-from-list-2-doc_register_003
Sheet: Register

 | Group |  | Document Type |  | Numerical Identifier | Document Number | Document Title | Date Released | Next Scheduled Review | DAYS
 | A |  | AA
 | A |  | BB
 | A |  | CC
 | A |  | DD
 | A |  | EE
 | A |  | FF
 | A |  | GG
 | A |  | HH
 | A |  | JJ
 | A
 | A |  | AA
 |  |  | AA
 | A
 | A |  | AA
 | B |  | AA
 | B |  | BB
 | B |  | AA
Spreadsheet: 709544d1608382023-change-formula-to-ignore-hidden-tabs-book1
Sheet: Sheet4

 |  |  |  |  |  |  |  |  |  |  | All sheets | Select "X" here | Selected
 |  | Result |  |  |  |  |  |  |  |  | Sheet1 |  |  | $N$2:INDEX($N$2:$N$20,SUMPRODUCT(--(LEN($N$2:$N$20)>0)))
 |  |  |  |  |  |  |  |  |  |  | Sheet2
 |  |  |  |  |  |  |  |  |  |  | Sheet3
Spreadsheet: 600759d1543939919-index-match-with-repeating-column-headers-sample-file
Sheet: Sheet1

Task | Activity No (Index 1) | Activity Name | Estimated Completion Date | Actual Complete Date | Comment | Activity No (Index 2) | Activity Name | Estimated Completion Date | Actual Complete Date | Comment
Task 1 | 1 | Backup old computer | 2017-09-30 00:00:00 | 2018-10-01 00:00:00 | Delayed due to lack of resources | 2 | Install new software | 2015-10-15 00:00:00 | 2015-10-15 00:00:00 | Completed on time
Task 2 | 1 | Submit purchase order for approval | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | Submitted on time | 2 | Order desks | 2017-01-02 00:00:00 | 2017-01-09 00:00:00 | Delayed due to being out of office
Task 3 | 1 | Test work station | 2017-04-04 00:00:00 | 2017-03-01 00:00:00 | Able to complete early due to other projects being on hold | 2 | Write test station report | 2017-04-11 00:00:00 | 2017-03-15 00:00:00 | Able to write report early due to other projects being on hold
 |  | Task 1
 |  | Activity Name | Estimated Completion Date | Actual Complete Date | Comment
Spreadsheet: 271328d1381914320-countifs-a-b-c-or-d-0a1ab-testing-stats-master-1
Sheet: Android

Android | Geek Culture |  |  | Science & Research |  |  | Personal/Opinion |  |  | Historic |  |  | AppStore Rating |  |  | Quotation |  |  | Anecdote/Fact |  |  | Question |  |  | App's Success |  |  | Country Specific |  |  | Endorsement |  |  | Love/Sex
 | No. of Promos | Won | % | No. of Promos | Won | % | No. of Promos | Won | % | No. of Promos | Won | % | No. of Promos | Won | % | No. of Promos | Won | % | No. of Promos | Won | % | No. of Promos | Won | % | No. of Promos | Won | % | No. of Promos | Won | % | No. of Promos | Won | % | No. of Promos | Won | %
Canada
UK
Australia
Germany
Russia
France
Sweden
Spain
Italy
Netherlands
Norway
Denmark
Korea
Turkey
Japan
Finland
Spreadsheet: darrell_schoolcraft__7805__imbalsumm0108
Sheet: williams

 | Milagro |  | La Maquina |  | [NAME] |  | [NAME]
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled |  |  |  |  |  |  |  | San Juan
1 | 320046 | 326630 | 68213 | 62006 | 60282 | 67308 | 134575 | 120400 |  |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount
2 | 322443 | 342258 | 80613 | 62006 | 65523 | 61458 | 114858 | 123670
3 | 339003 | 356730 | 65345 | 62006 | 62518 | 57038 | 133408 | 135294 |  |  |  | 2000-12-01 00:00:00 | 19698194 | 19662410 |  | 7.95
4 | 330189 | 334992 | 71515 | 62006 | 68003 | 60854 | 121528 | 122443 |  |  |  | 2001-01-01 00:00:00 | 18949781 | 18975457 |  | 8.1
5 | 325424 | 357543 | 76506 | 45334 | 60101 | 61458 | 122124 | 116046 |  |  |  | 2001-02-01 00:00:00 | 15193330 | 15256233 |  | 5.61
6 | 338716 | 363512 | 73883 | 62006 | 63277 | 61458 | 128438 | 126142 |  |  |  | 2001-03-01 00:00:00 | 17049350 | 17089226 |  | 4.87
7 | 307409 | 329009 | 81561 | 62006 | 61385 | 66177 | 128949 | 116696 |  |  |  | 2001-04-01 00:00:00 | 17652369 | 17743987 |  | 4.62
8 | 335665 | 339813 | 69904 | 62006 | 64156 | 66309 | 123188 | 131814 |  |  |  | 2001-05-01 00:00:00 | 16124989 | 16282021 |  | 3.44
9 | 339468 | 343257 | 62256 | 62006 | 68558 | 62714 | 133641 | 126893 |  |  |  | 2001-06-01 00:00:00 | 15928675 | 15936227 |  | 2.45
10 | 325004 | 326102 | 61460 | 62006 | 56382 | 53686 | 141587 | 135180 |  |  |  | 2001-07-01 00:00:00 | 16669639 | 16693576 |  | 2.45
11 | 348691 | 329322 | 39888 | 62006 | 62036 | 61116 | 154963 | 154094
12 | 343074 | 331485 | 41056 | 62006 | 63625 | 61306 | 145898 | 141767
13 | 329776 | 327012 | 46642 | 59179 | 62952 | 61308 | 138478 | 126232
14 | 326625 | 336221 | 37103 | 26877 | 56806 | 58064 | 133830 | 131396
15 | 336681 | 332244 | 61849 | 62006 | 56541 | 57130 | 149355 | 149369
16 | 330403 | 330339 | 63183 | 62006 | 56691 | 58312 | 153223 | 151210
17 | 334818 | 346212 | 81572 | 62006 | 63376 | 65126 | 135420 | 142145
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-07-31 00:00:00 |  |  |  |  |  |  |  |  | 310268
2001-08-17 00:00:00
CBS Dollars
 |  |  | 1379269.57
 |  |  | 300359.04
 |  |  | -250735.54
 |  |  | 44931.54
 |  |  | 2153062.32
 |  |  | 0.0238
 |  |  | 0.0153
Spreadsheet: 838884d1691494936-dcount-that-omits-hidden-cells-or-cells-with-specific-text-i-e-closed-risk-register-help
Sheet: Risk

 |  |  |  | V.Unlikely | Unlikely | Possible | Likely | V.Likely
 |  |  | Slight | Tol (1) | Tol (1) | Tol (1) | Tol (2) | N.Tol |  |  | Open
 |  |  | Minor | Tol (1) | Tol (1) | Tol (2) | N.Tol | N.Tol |  |  | Closed
 |  |  | Major | Tol (1) | Tol (2) | Tol (2) | N.Tol | Stop
 |  |  | Severe | Tol (2) | Tol (2) | N.Tol | Stop | Stop |  |  | Slight
 |  |  | Massive | Tol (2) | N.Tol | Stop | Stop | Stop |  |  | Minor
 |  |  |  |  |  |  |  |  |  |  | Major
 |  |  |  |  |  |  |  |  |  |  | Severe
 |  |  |  |  |  |  |  |  |  |  | Massive
 |  |  |  |  |  |  |  |  |  |  | V.Unlikely
 |  |  |  |  |  |  |  |  |  |  | Unlikely
 |  |  |  |  |  |  |  |  |  |  | Possible
 |  |  |  |  |  |  |  |  |  |  | Likely
 |  |  |  |  |  |  |  |  |  |  | V.Likely
Spreadsheet: 845524d1697016072-problem-incrementing-or-decrementing-a-cells-value-based-on-a-filters-value-golfscoresmultiplayerliveck76bak
Sheet: Handicaps

 |  |  | 2023-12-04 00:00:00 | 2024-01-08 00:00:00 | 2024-02-05 00:00:00 | 2024-03-04 00:00:00 | 2024-04-08 00:00:00 | 2024-05-06 00:00:00 | 2024-06-03 00:00:00
Team/Hcap | StartHcp | Hcaps for 13/11 | Hcaps for 04/12 | Hcaps for 08/01 | Hcaps for 05/02 | Hcaps for 04/03 | Hcaps for 08/04 | Hcaps for 06/05 | Hcaps for 03/06
Team1
Player1 | 12
Player2 | 17
Player3 | 16
Player4 | 17
Team2
Player5 | 10
Player6 | 15
Player7 | 19
Player8 | 22
Team3
Player9 | 15
Player10 | 20
Player11 | 25
Player12 | 28
Team4
Player13 | 13
Player14 | 19
Player15 | 21
Player16 | 22
Team5
Player17 | 12
Player18 | 14
Player19 | 19
Player20 | 23
Team6
Player21 | 17
Player22 | 19
Player23 | 22
Player24 | 25
Team7
Player22 | 10
Player23 | 16
Player24 | 22
Player25 | 25
Spreadsheet: andy_zipper__144__ICE - Mar19 Power & Gas VOL
Sheet: Financial Gas

 |  |  |  |  |  |  | FINANCIAL GAS VOLUME
'); } else { document.write(''); } } else { if (navigator.platform == "[NAME]") { document.write(''); } else { document.write(''); } }
Commodity Type:   Financial Gas Swaps/Forwards
Hub:  All
Trade Dates:  Mar-19-01 thru Mar-19-01
 | Description | Strip | Low Price | High Price | Weighted | Last Price | Last Price Date | Volume
 |  |  |  |  | Average Price
 | NG Fin BS, LD1 for GDM
 | NG Fin BS, LD1 for GDM - Mich - Apr01-Oct01 | Apr01-Oct01 | 0.243 | 0.243 | 0.243 | 0.243 | Mar-19-01 15:17 GMT | 2140000 | MMBtus
 | NG Fin BS, LD1 for IF
 | NG Fin BS, LD1 for IF - HSC - Apr01-Oct01 | Apr01-Oct01 | 0.043 | 0.043 | 0.043 | 0.043 | Mar-19-01 19:35 GMT | 10700000 | MMBtus
 | NG Fin BS, LD1 for IF - NNG-Demarc - Apr01-Oct01 | Apr01-Oct01 | 0.035 | 0.035 | 0.035 | 0.035 | Mar-19-01 16:10 GMT | 2140000 | MMBtus
 | NG Fin BS, LD1 for IF - Tran 65 - Apr01-Oct01 | Apr01-Oct01 | 0.025 | 0.025 | 0.025 | 0.025 | Mar-19-01 15:23 GMT | 2140000 | MMBtus
 | NG Fin BS, LD1 for NGI
 | NG Fin BS, LD1 for NGI - Socal - Apr01 | Apr01 | 4.7 | 4.7 | 4.7 | 4.7 | Mar-19-01 20:01 GMT | 150000 | MMBtus
 | NG Fin BS, LD1 for NGI - Socal - Oct01 | Oct01 | 4.4 | 4.4 | 4.4 | 4.4 | Mar-19-01 21:12 GMT | 155000 | MMBtus
 | NG Fin Sw Swap, FP for GDD
 | NG Fin Sw Swap, FP for GDD - Henry - Bal Month Gas | Bal Month Gas | 5.063 | 5.07 | 5.068 | 5.07 | Mar-19-01 16:02 GMT | 240000 | MMBtus
 | NG Fin, FP for LD1
 | NG Fin, FP for LD1 - Henry - Apr01 | Apr01 | 5.025 | 5.13 | 5.066 | 5.065 | Mar-19-01 20:08 GMT | 2250000 | MMBtus
 | NG Fin, FP for LD1 - Henry - May01 | May01 | 5.06 | 5.123 | 5.094 | 5.06 | Mar-19-01 16:26 GMT | 465000 | MMBtus
 | NG Fin, FP for LD1 - Henry - Apr01-Oct01 | Apr01-Oct01 | 5.13 | 5.138 | 5.134 | 5.138 | Mar-19-01 20:41 GMT | 5350000 | MMBtus
 | NG Fin, FP for LD1 - Henry - Nov01-Mar02 | Nov01-Mar02 | 5.253 | 5.253 | 5.253 | 5.253 | Mar-19-01 19:54 GMT | 755000 | MMBtus
Spreadsheet: 878097d1725065364-use-fields-in-one-sheet-to-enter-data-repeatedly-into-new-fields-in-another-sheet-tester-gas-mileage
Sheet: Data Sheet

DATE | Car's Est. MPG | [NAME] | Gallons Filled | Car's Est. [NAME] On | [NAME] with Light On | Car's Est. [NAME] Fill-up | Calculated MPG | Average Calculated MPG | Average Car's Est. MPG | Variance in Car's Est. MPG | Average Variance in Car's Est. MPG | Calculated Miles Left @ Light On | Average Calculated Miles Left @ Light On | Average Car's Est. [NAME] On | Variance in Car's Est. [NAME] On | Average Variance in Car's Est. [NAME] On | Calculated Tank Potential | Average Calculated Tank Potential | Car's Est. Tank Potential (Est. MPG) | Average Car's Est. Tank Potential (Est. MPG) | Variance in Car's Est. Tank Potential (Est. MPG) | Average Variance in Car's Est. Tank Potential (Est. MPG) | Car's Est. Tank Potential ([NAME] Driven+Left) | Average Car's Est. Tank Potential ([NAME] Driven+Left) | [NAME]. Tank Potential ([NAME] Driven+Left) | Difference in Tank Potential (Est. MPG vs. [NAME]) | Average Difference in Tank Potential (Est. MPG vs. [NAME])
2024-08-16 00:00:00 |  | 351.6 | 17.351 | 50 | 24.6
2024-08-18 00:00:00 | 21.5 | 118.8 | 5.599
2024-08-18 00:00:00 | 26.4 | 258.3 | 10.204
2024-08-22 00:00:00 | 23.5 | 361.4 | 15.763 |  |  | 50
2024-08-26 00:00:00 | 23.5 | 275.2 | 12.511 |  |  | 140
2024-08-27 00:00:00 | 25.4 | 420.9 | 16.572 | 40 | 10.1 | 30
Spreadsheet: 677030d1589157427-populate-calendar-and-summary-invercargill-leave
Sheet: Datatable

Employee | Location | Date | Leave type | Hours | Staff List.Location
Name1 | [NAME] | 2020-05-11 00:00:00 | Annual | 10 | [NAME]
Name1 | [NAME] | 2020-05-15 00:00:00 | Annual | 10 | [NAME]
Name1 | [NAME] | 2020-05-16 00:00:00 | Annual | 10 | [NAME]
Name1 | [NAME] | 2020-06-06 00:00:00 | Annual | 10 | [NAME]
[NAME] | [NAME] | 2020-05-18 00:00:00 | Annual | 10 | [NAME]
[NAME] | [NAME] | 2020-05-23 00:00:00 | Annual | 10 | [NAME]
[NAME] | [NAME] | 2020-05-25 00:00:00 | Annual | 10 | [NAME]
[NAME] | [NAME] | 2020-05-26 00:00:00 | Annual | 10 | [NAME]
Name3 | [NAME] | 2020-05-18 00:00:00 | Annual | 12 | [NAME]
Name3 | [NAME] | 2020-05-19 00:00:00 | Annual | 12 | [NAME]
Name3 | [NAME] | 2020-05-20 00:00:00 | Annual | 12 | [NAME]
Name4 | [NAME] | 2020-06-02 00:00:00 | Annual | 10 | [NAME]
Name4 | [NAME] | 2020-06-03 00:00:00 | Annual | 10 | [NAME]
Name4 | [NAME] | 2020-06-04 00:00:00 | Annual | 10 | [NAME]
Name4 | [NAME] | 2020-06-05 00:00:00 | Annual | 10 | [NAME]
Name5 | [NAME] | 2020-06-10 00:00:00 | Annual | 12 | [NAME]
Name5 | [NAME] | 2020-06-11 00:00:00 | Annual | 8 | [NAME]
Name5 | [NAME] | 2020-06-08 00:00:00 | Annual | 12 | [NAME]
Name5 | [NAME] | 2020-06-09 00:00:00 | Annual | 12 | [NAME]
Name6 | [NAME] | 2020-06-15 00:00:00 | Annual | 10 | [NAME]
Name6 | [NAME] | 2020-06-20 00:00:00 | Annual | 10 | [NAME]
Name6 | [NAME] | 2020-06-22 00:00:00 | Annual | 10 | [NAME]
Name6 | [NAME] | 2020-06-23 00:00:00 | Annual | 10 | [NAME]
Name7 | [NAME] | 2020-06-23 00:00:00 | Annual | 8 | [NAME]
Name7 | [NAME] | 2020-06-24 00:00:00 | Annual | 8 | [NAME]
Name7 | [NAME] | 2020-06-25 00:00:00 | Annual | 8 | [NAME]
Name7 | [NAME] | 2020-06-26 00:00:00 | Annual | 8 | [NAME]
Name7 | [NAME] | 2020-06-27 00:00:00 | Annual | 8 | [NAME]