tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 696861d1601016163-fomula-to-display-average-of-last-12-months-data-metric-excel
Sheet: Stats Graph

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Select the Month > | 2020-10-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Incident Statistics
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Month | Total Hours | MM TRIFR | MM LTIFR | MM TAXI TRIFR | MM TAXI LTIFR | Client 1 TRIFR | Client 1 LTIFR | Target TRIFR | Client 2 TRIFR | Client 2 | Client 3 | Client 3LTI ACT | Manhours
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 46
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 44
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 38
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 36
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 34
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: 186420d1350036886-search-beers
Sheet: T

Brewery |  | Beer
[NAME]'s Blackbeck |  | Trial Run
[NAME] |  | Golden Best
 |  | [NAME]
 |  | Best Bitter
 |  | Porter
 |  | [NAME]
 |  | Ram Tam(XXXX)
Teignworthy |  | Beachcomber
Thompson’s |  | Best Bitter
Thornbridge |  | Bohemia
Three Rivers |  | Summer’s Pearl
 |  | GMT
Three B’s |  | Weavers Brew
Thwaites |  | Best Mild
 |  | Bitter
 |  | Craftsman
 |  | Lancaster Bomber
 |  | [NAME]
 |  | Old [NAME]
 |  | Thoroughbred
 |  | Good Elf
 |  | Bloomin
Tigertops |  | [NAME]
Titanic |  | Captain [NAME]
 |  | Doric Temple
 |  | Wheelhouse
 |  | Full Kiln Ale
 |  | Ale Over
 |  | Olympic
 |  | [NAME]
 |  | England’s Glory
 |  | Steerage
Tolly |  | Original Best Bitter
[NAME] |  | Mild
 |  | Original Best Bitter
[NAME] |  | OSB
Tomintoul |  | Callie
 |  | Wildcat
[NAME]’s |  | Hermitage Mild
Townes |  | Double Bagger
Traquair House |  | Traquair House Ale
Tring |  | The Ridgeway Bitter
 |  | Monks Gold
Triple FFF |  | Moondance
Tryst |  | Carronade IPA
Tunnel |  | Two Orks
Spreadsheet: 791229d1660218485-returning-multiple-team-names-with-the-highest-score-in-the-event-of-a-tie-sample-data-1-
Sheet: Week 7

 |  |  |  |  | Wilson's Cougars |  |  |  |  |  |  | Cheese Weasels |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | Can only [NAME] So many times |  |  |  |  |  |  | Team Brilliant! |  |  |  |  |  |  | Dream Team Bubbs |  |  |  |  |  |  | Greg's Team |  |  |  |  |  |  | Team [NAME] |  |  |  |  |  |  | Team B |  |  |  |  |  |  | Team Ruggles
# of Zeros
# of Bye Players
Amount Won
High Score Winner
Spreadsheet: 52559d1252413933-help-with-a-formula-referencing-multiple-tabs-sept-09-sales-and-labor
Sheet: Totals

 | 2009-09-07 00:00:00
 |  | Daily | WTD
 | Sales | #N/A | 11127
 | Sales +/- LY | 434 | -2091
 | [NAME] | 0.1072268907563025 | 0.1192594589736677
 | FOH Hrs | 112 | 205
 | FOH% | 0.0642016806722689 | 0.06147209490428687
 | FOH Prod | 53.125 | 54.27804878048781
 | BOH Hrs | 66 | 147
 | BOH % | 0.1342243975903614 | 0.1595755535149475
 | BOH Prod | 80.48484848484848 | 66.6734693877551
 | lunches | 2623 | 4906
 | lunch +/- LY | 788 | -270
Spreadsheet: 269338d1381134330-reference-data-in-a-row-based-on-data-in-a-cell-training-record-matrix
Sheet: Legend

 | Colour Legend
 | Colour | Meaning | Conditional Formatting Formula | Colour Code
 |  | Expired | If cell value is between 36892 and =TODAY() | R: 255 G: 0 B: 0
 |  | Within 2 Months of [NAME] | If cell value is between =TODAY() and =TODAY()+62 | R: 255 G:153 B: 0
 |  | Required | Manually Coloured | R: 204 G: 153 B: 255
 |  | Not Required | Manually Coloured | N/A
 |  | Okay / Current | If cell value is between =TODAY()+62 and =TODAY()+99999 | R: 0 G: 255 B: 0
 |  | Information | Base Colour | R: 255 G: 255 B: 0
 | **Please enter all dates in dd/mm/yy format.**
 |  | Roles: | Electrician
 |  |  | Refrigeration Mechanic | [NAME]
 |  |  | Dual Trade | Karratha
 |  |  | Electrical Apprentice | Perth
 |  |  | Trade Assistant
 |  |  | Supervisor
 |  |  | Manager
 |  | Licence: | Electrical Mechanic
 |  |  | Electrical Fitter
 |  |  | Restricted Electrical Worker
 |  |  | Electrician's [NAME]
Spreadsheet: 856179d1705519900-dynamic-array-for-cumulative-count-book1-fast-reduced-1-
Sheet: Sheet1

 |  |  | 30 secs |  | 33  secs |  | 73 secs |  | 80  secs |  | 0.16 secs |  | 0.24 secs |  | 0.14 secs |  | 0.24 secs
Item | Value |  | Cumulative COUNTIF |  | Cumulative  SUMIF |  | Total COUNTIF |  | Total SUMIF |  | Cumulative COUNTIF |  | Cumulative  SUMIF |  | Total COUNTIF |  | Total SUMIF |  | cumulative countif on a subset of r (value in column B should be < 15)
C | 20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
C | 23 |  |  |  |  |  |  |  |  |  | 2 |  | 43 |  | 5 |  | 73 |  | D | 1
B | 14 |  |  |  |  |  |  |  |  |  | 1 |  | 14 |  | 6 |  | 75 |  | D | 2
D | 3 |  |  |  |  |  |  |  |  |  | 1 |  | 3 |  | 3 |  | 21 |  | B | 2
B | 16 |  |  |  |  |  |  |  |  |  | 2 |  | 30 |  | 6 |  | 75 |  | D | 3
D | 4 |  |  |  |  |  |  |  |  |  | 2 |  | 7 |  | 3 |  | 21 |  | B | 3
A | 16 |  |  |  |  |  |  |  |  |  | 1 |  | 16 |  | 4 |  | 65 |  | A | 1
B | 13 |  |  |  |  |  |  |  |  |  | 3 |  | 43 |  | 6 |  | 75 |  | C | 1
D | 14 |  |  |  |  |  |  |  |  |  | 3 |  | 21 |  | 3 |  | 21 |  | B | 4
B | 9 |  |  |  |  |  |  |  |  |  | 4 |  | 52 |  | 6 |  | 75 |  | C | 2
A | 15 |  |  |  |  |  |  |  |  |  | 2 |  | 31 |  | 4 |  | 65
B | 15 |  |  |  |  |  |  |  |  |  | 5 |  | 67 |  | 6 |  | 75
C | 15 |  |  |  |  |  |  |  |  |  | 3 |  | 58 |  | 5 |  | 73
A | 14 |  |  |  |  |  |  |  |  |  | 3 |  | 45 |  | 4 |  | 65
A | 20 |  |  |  |  |  |  |  |  |  | 4 |  | 65 |  | 4 |  | 65
C | 14 |  |  |  |  |  |  |  |  |  | 4 |  | 72 |  | 5 |  | 73
B | 8 |  |  |  |  |  |  |  |  |  | 6 |  | 75 |  | 6 |  | 75
C | 1 |  |  |  |  |  |  |  |  |  | 5 |  | 73 |  | 5 |  | 73
Spreadsheet: 767405d1644446141-counting-text-cells-with-duplicates-based-on-multi-base-criteria-excel-count-question
Sheet: Sample1

 | System | Date |  |  | System | Total Calendar Days Count
 | CLNC 1 | 2020-10-23 00:00:00 |  |  | CLNC 1 | 5
 | CLNC 1 | 2020-10-26 00:00:00 |  |  | CLNC 2 | 7
 | CLNC 1 | 2020-10-27 00:00:00
 | CLNC 1 | 2020-10-27 00:00:00
 | CLNC 1 | 2020-10-28 00:00:00
 | CLNC 1 | 2020-10-28 00:00:00
 | CLNC 1 | 2020-10-29 00:00:00
 | CLNC 2 | 2020-10-06 00:00:00
 | CLNC 2 | 2020-10-06 00:00:00
 | CLNC 2 | 2020-10-07 00:00:00
 | CLNC 2 | 2020-10-07 00:00:00
 | CLNC 2 | 2020-10-08 00:00:00
 | CLNC 2 | 2020-10-14 00:00:00
 | CLNC 2 | 2020-10-15 00:00:00
 | CLNC 2 | 2020-10-20 00:00:00
 | CLNC 2 | 2020-10-27 00:00:00
 | CLNC 2 | 2020-10-27 00:00:00
 | CLNC 2 | 2020-10-27 00:00:00
 | CLNC 2 | 2020-10-27 00:00:00
Spreadsheet: 731539d1620395754-highlight-date-range-on-calendar-data
Sheet: Non Hire

 |  |  |  | [NAME] RECORD
M/C No. | Storage Start Date | Storage End Date | No. of Days | Comments
3099 | 2019-12-10 00:00:00 | 2020-02-16 00:00:00 |  | Refurb prior to hire
3099 | 2020-05-28 00:00:00 | 2020-06-11 00:00:00 |  | Check over & HF
3099 | 2020-08-10 00:00:00 | 2020-09-21 00:00:00 |  | CT change, oil top up, new return roller, grease top up, shaft
3103 | 2020-10-22 00:00:00 | 2020-11-25 00:00:00 |  | Delivered to Core by Hoban
3099 | 2020-11-17 00:00:00 | 2020-11-24 00:00:00 |  | Not on hire
3099 | 2020-12-04 00:00:00 | 2020-12-08 00:00:00 |  | Not on hire - back fr Rec Lives
3099 | 2021-01-28 00:00:00 | 2021-03-24 00:00:00 |  | Not on hire back from TW
3118 | 2021-02-27 00:00:00 | 2021-03-19 00:00:00 |  | Demo at Countrystyle starts 230321, then onto LE for Metso hire for late del of new shredder
Spreadsheet: 757495d1638292424-get-results-from-large-data-in-excel-o365-tracking
Sheet: DATA

Target | Count
MFA
Sharepoint
Teams |  |  |  |  |  | Target | Count
OneDrive |  |  |  |  |  | Assistance
Outlook |  |  |  |  |  | Target | Count
InfoPath |  |  |  |  |  | Login
OneNote |  |  |  |  |  | Target | Count
Powerpoint |  |  |  |  |  | Problem
Excel
Word
AIP
Office365_Assistance
Office365_Problem
Target | Count
MFA_Login-issue
SharePoint_Login-issue
Teams_Login-issue
OneDrive_Login-issue
Outlook_Login-issue
InfoPath_Login-issue
OneNote_Login-issue
Powerpoint_Login-issue
Excel_Login-issue
Word_Login-issue
Login-issue_BE
Login-issue_NL
Target | Count
MFA_Assistance
SharePoint_Assistance
Teams_Assistance
OneDrive_Assistance
Outlook_Assistance
OneNote_Assistance
Powerpoint_Assistance
Excel_Assistance
Word_Assistance
AIP_Assistance
AIP_Assistance
Office365_Assistance
Target | Count
MFA_Problem
SharePoint_Problem
Teams_Problem
OneDrive_Problem
Outlook_Problem
InfoPath_Problem
OneNote_Problem
Powerpoint_Problem
Excel_Problem
Word_Problem
Office365_Problem
Target
A.TEC.BNL.CPI.WORKPLACE-MGT.BE
A.TEC.BNL.CPI.WORKPLACE-MGT.NL
Spreadsheet: 888929d1739550987-count-for-every-use-with-a-30-second-gap-14-feb-30-gap-count
Sheet: Sheet1

2025-02-03T10:15:05.149Z
2025-02-03T10:15:17.141Z
2025-02-03T10:15:17.795Z
2025-02-03T10:15:19.953Z
2025-02-03T10:15:25.825Z
2025-02-03T10:15:49.041Z
2025-02-03T10:15:49.133Z
2025-02-03T12:15:20.908Z
2025-02-03T17:11:29.193Z
2025-02-03T17:11:30.601Z
2025-02-03T17:11:57.415Z
2025-02-03T17:12:05.721Z
2025-02-03T17:12:06.228Z
2025-02-03T17:12:09.421Z
2025-02-03T17:12:25.233Z
2025-02-03T17:12:28.844Z
2025-02-03T17:12:31.519Z
2025-02-03T17:12:32.688Z
2025-02-03T17:12:39.253Z
2025-02-03T17:12:46.060Z
2025-02-03T17:12:46.822Z
2025-02-03T21:46:52.712Z
2025-02-03T21:47:17.478Z
2025-02-03T21:47:17.500Z
2025-02-03T21:47:17.493Z
2025-02-03T21:47:17.494Z
2025-02-04T10:49:28.888Z
2025-02-04T12:40:51.270Z
2025-02-04T12:41:25.392Z
2025-02-04T12:41:26.022Z
2025-02-04T12:41:26.234Z
2025-02-04T12:41:28.958Z
2025-02-04T12:41:34.906Z
2025-02-04T12:41:39.565Z
2025-02-04T12:41:40.294Z
2025-02-04T12:41:40.668Z
2025-02-04T12:41:41.135Z
2025-02-04T12:41:46.508Z
2025-02-04T14:48:05.521Z
2025-02-04T14:48:07.463Z
2025-02-04T14:48:07.720Z
2025-02-04T14:48:07.841Z
2025-02-04T14:48:08.112Z
2025-02-04T14:48:11.884Z
2025-02-04T14:48:11.916Z
2025-02-04T14:48:11.928Z
Spreadsheet: 693238d1598877860-filter-and-sort-out-a-list-into-data-input-sheet-except-a-blank-cells-copy-of-resource-sheet
Sheet: Activity Resource Sheet (2)

1
Description
[NAME]
[NAME]
Bearing
[NAME]
[NAME]
[NAME]
Deshutter Web
Deck scaffolding (inside web)
[NAME]
[NAME]
Top Slab Concrete
[NAME]
[NAME]
Bearing
[NAME]
[NAME]
[NAME]
Deshutter Web
Deck scaffolding (inside web)
[NAME]
[NAME]
Top Slab Concrete
PT preparation works
Post Tension works
PT Grouting
[NAME] (all activities)
[NAME]
[NAME]
[NAME]
Bearing
[NAME]
[NAME]
[NAME]
Deshutter Web
Deck scaffolding (inside web)
[NAME]
[NAME]
Top Slab Concrete
[NAME]
[NAME]
Bearing
[NAME]
[NAME]
[NAME]
Deshutter Web
Deck scaffolding (inside web)
[NAME]
[NAME]
Top Slab Concrete
[NAME]
[NAME]
Bearing
[NAME]
[NAME]
[NAME]
Deshutter Web
Deck scaffolding (inside web)
[NAME]
[NAME]
Top Slab Concrete
PT preparation works
Post Tension works
PT Grouting
[NAME] (all activities)
[NAME]
[NAME]
[NAME]
Bearing
[NAME]
[NAME]
[NAME]
Deshutter Web
Deck scaffolding (inside web)
[NAME]
[NAME]
Top Slab Concrete
[NAME]
[NAME]
Bearing
[NAME]
[NAME]
[NAME]
Deshutter Web
Deck scaffolding (inside web)
[NAME]
[NAME]
Top Slab Concrete
PT preparation works
Post Tension works
PT Grouting
[NAME] (all activities)
[NAME]
Abutment Wall Steel
Abutment Wall Shuttering
Abutment Wall Concreting
Abutment Wall Deshuttering/curing
Spreadsheet: jeff_dasovich__14085__CDWR Contracts 
Sheet: Summary

Company | Term | MW | Price |  | Type
 |  |  | $/MWH | $[NAME]
Allegheny | Jan 03 - Dec 03 | 150 | 76 | - | 6 x 16
 | 2001-03-01 00:00:00 | 150 | 61 | - | 6 x 16
 | Apr 01 - Jun 01 | 750 | 61 | - | 6 x 16
 | Jul 01 - Sep 01 | 250 | 61 | - | 6 x 16
 | Oct 01 - Dec 03 | 250 | 61 | - | 7 x 24
 | Jan 04 - Dec 04 | 500 | 61 | - | 7 x 24
 | Jan 05 - Dec 11 | 1000 | 61 | - | 7 x 24
Alliance | Aug 01 - Oct 10 | 80 |  | -
BPA | Evergreen | 18 | 55 | - | 7 x 24
 | Evergreen | tbd | 1.1/1.0 | Exchange | tbd
Calpine | Oct 01 - Dec 11 | 200-1,000 | 59 | -
 | Jul 01 - Dec 01 | 200 | 115 | -
 | Jan 02 - Dec 11 | 1000 | 61 | -
 | Aug 01 - Jun 21 | 90-495 | 73 | $161 - $200
Spreadsheet: 845323d1696859114-filter-by-column-and-by-row-competence-matrix-filter-updated1-1-aligw
Sheet: Sheet2

 | Management |  |  |  | Operational |  |  |  | Technical |  |  |  | Languages |  |  |  | Solution Control
Name/skill | Business Dev | [NAME] | Project Manager | PMO | Finance | Manufacturing | Supply chain | Human Resources | Configuration | Lobbies | Data Migration | Developer | Dutch | English | French | German | Solution Architect | Process Design | [NAME] | ClickLearn
Marian | X |  |  | X | C | C | X | C |  | X |  | C |  | X |  | X
George | x |  | X | C | X | X | X | C | X |  | X | C | X |  | X | X | C | X |  | C
Alina |  | X | X |  | X |  | X | C |  |  |  |  |  | X
Radu |  |  | X |  |  |  | C | C |  | C |  |  | X |  |  | X |  |  | C
Cristian |  |  | C | C |  | X | C | C |  |  | C | X |  | X | X |  |  | C |  | C
 | Management |  |  | Operational |  |  | Technical |  |  | Languages |  |  | Solution |  |  | Certified
 | Business Dev |  |  | Finance |  |  | Configuration |  |  | Dutch |  |  | Solution Architect |  |  | C
 | [NAME] |  |  | Manufacturing |  |  | Lobbies |  |  | English | True |  | Process Design | True |  | X
 | Project Manager | True |  | Supply chain | True |  | Data Migration |  |  | French |  |  | [NAME]
 | PMO |  |  | Human Resources | True |  | Developer | True |  | German |  |  | ClickLearn | True
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expected result
 | one filter result |  |  | two filters results |  |  | three filters results |  |  | four filters results |  |  | five filters results |  |  | six filters results |  | ALL filters results
 |  | George |  |  | George |  |  | George
 |  | Alina |  |  | Alina
 |  | Radu |  |  | Radu
 |  | Cristian |  |  | Cristian |  |  | Cristian |  |  | Cristian |  |  | Cristian |  |  | Cristian
Spreadsheet: 484277d1476199557-want-data-from-one-spreadsheet-to-auto-populate-to-another-elmer-fudd-realty-rents-2016
Sheet: Master List

Elmer [NAME]
Rents
Date | Building | Apt. # | Check # | Amount
2016-10-05 00:00:00 | 485 | b1 | 149 | 1350
 | 610 | b2 | 259 | 1223.38
 |  | c5 | 152 | 1733.16
 | 909 | a5 | 797 | 455.87
 |  | c4 | cash | 1850
 | 141 | c4 | 1011 | 1300
Spreadsheet: 32042d1228164953-adding-names-and-showing-on-all-sheets-generic-hours-and-miles_2008
Sheet: November

NOVEMBER | Month Total | Month Total | 08XXX1 | NYC | 08XXX1 | STL | 08XXX3 | LAX
CD? Then "Y" |  | CD |  |  | y
 | HOURS | [NAME] | HOURS | CD [NAME] | HOURS | CD [NAME] | HOURS | CD [NAME]
 |  | 45 |  | 15 |  | 15 |  | 15
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
AB Hours /Job | 0 |  | 0 |  | 0 |  | 0
AB-CD /Job |  | 15 |  |  |  | 15
 | 0 |  |  |  | 0
Spreadsheet: 779858d1652151445-populate-calendars-based-on-office-location-daf-office-scheduling-draft-aligw-1-
Sheet: AP

Month: | April
Year: | 2022
Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
 | -3 | -2 | -1 | 0 | 1 | 2
Spreadsheet: phillip_m_love__30713__200009_OA
Sheet: TX-EGM-FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  ECTR (EGM)
 |  |  | NGP&L |  | CPR Adjustments |  | 3rd Day CPR |  | [NAME] |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron | 12058069 | 38430000.50999999
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 0 | 0
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 12058069 | 38430000.50999999
 |  |  | 0 | 0
 | Purchases: |  | 0 | 0
6 |  | 3rd Party / Inter Enron | -7716905 | -24767566.75999999
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | 0 | 0
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 16787 | 58072
 | Total Purchases: |  | -7700118 | -24709494.75999999
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
11 |  | Sales | 22328896 | 78557718.52000001
12 |  | Purchases | -23023876 | -81056970.81
 | Total Intra CTS Sales / Purchases |  | -694980 | -2499252.289999992
 |  |  | 0 | 0
 | Imbalances: |  | 0 | 0
13 |  | In Kind | 0 | 0
14 |  | Cash Out | 0 | 0
15 |  | Cash In | 0 | 0
16 |  | Synthetic Storage | 0 | 0
 | Total Imbalances: |  | 0 | 0
 |  |  | 0 | 0
 | Storage: |  | 0 | 0
17 |  | Injection (Sales to Stg) | 0 | 0
18 |  | W/D (Purchase from Stg) | 0 | 0
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | 0 | 0
 | Total Storage: |  | 0 | 0
 |  |  | 0 | 0
20 | Linepack: |  | 0 | 0
 |  |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
 |  |  | 0 | 0
22 | UA4: |  | -3662971 | -16634209.88058033
 |  |  | 0 | 0
23 | Fuel: |  | -16787 | 0
 |  |  | 0 | 0
 | Transport Expense: |  | 0 | 0
24 |  | Commodity | 0 | 0
25 |  | Demand | 0 | 0
 | Total Transport Expense: |  | 0 | 0
 |  |  | 0 | 0
 | Transport Revenue: |  | 0 | 0
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | 0
 | Total Transport Revenue: |  | 0 | 0
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
28 |  | Transport Expense | 0 | 0
29 |  | Transport Revenue | 0 | 0
 | Total Intra CTS Transport |  | 0 | 0
 |  |  | 0 | 0
 | Tie Out Schedule Items: |  | 0 | 0
 |  | MTM Income: | 0 | 0
30 |  | Current Gross Book Balance | 0 | 3738744.55
31 |  | Prior Month Book Balance | 0 | -707475
 |  | Total MTM Income | 0 | 3031269.55
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | 18763672.01
34 |  | Originations | 0 | 70305
35 |  | Broker Fees | 0 | 753
36 |  | Asset Group Demand Charges | 0 | -98300
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 0
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | -380082
 |  | TOTAL INTRA-MTH
FT-South Texas
 |  | Current Month MTM | 0
 |  | Financial Liquidations | 0 | 0
 |  | Originations | 0 | 0
 |  | TOTAL FIRM TRADING
 |  | TOTAL NGPL
Spreadsheet: 672463d1586877707-re-running-count-by-hour-of-the-day-thread-running-count-per-15-minutes
Sheet: Result

 | Row Labels | Store 5 detector
 | 01:45:00 | 1
 | 04:15:00 | 1
 | 04:30:00 | 1
 | 07:30:00 | 3
 | 07:45:00 | 7
 | 08:00:00 | 13
 | 08:15:00 | 20
 | 08:30:00 | 21
 | 08:45:00 | 24
 | 09:00:00 | 24
 | 09:15:00 | 23
 | 09:30:00 | 22
 | 09:45:00 | 19
 | 10:00:00 | 14
 | 10:15:00 | 13
 | 10:30:00 | 12
 | 10:45:00 | 10
 | 11:00:00 | 8
 | 11:15:00 | 8
 | 11:30:00 | 8
 | 11:45:00 | 9
 | 12:00:00 | 9
 | 12:15:00 | 10
 | 12:30:00 | 10
 | 12:45:00 | 9
 | 13:00:00 | 4
 | 13:15:00 | 4
 | 13:30:00 | 3
 | 13:45:00 | 3
 | 14:00:00 | 4
 | 14:15:00 | 4
 | 14:30:00 | 5
 | 14:45:00 | 6
 | 15:00:00 | 7
 | 15:15:00 | 8
 | 15:30:00 | 10
 | 15:45:00 | 10
 | 16:00:00 | 10
 | 16:15:00 | 9
 | 16:30:00 | 8
 | 16:45:00 | 8
 | 17:00:00 | 8
 | 17:15:00 | 9
 | 17:30:00 | 11
 | 17:45:00 | 13
 | 18:00:00 | 15
 | 18:15:00 | 12
 | 18:30:00 | 8
 | 18:45:00 | 6
 | 19:00:00 | 5
 | 19:15:00 | 1
 | 19:30:00 | 1
 | Grand Total | 62
Spreadsheet: 730437d1619700807-average-non-continuous-cells-if-not-0-2021-22-tracker-copy
Sheet: C3 E (Att)

 | Class Attendance & Effort
 | Teacher |  |  |  |  |  |  |  |  |  |  | Course |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S month
 | Room |  |  |  |  |  |  |  |  |  |  | Period/Time |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Year
 | Pupils |  |  |  |  | Enter: P = Present, A = Absent // E = Excellent, G = Good or L = Low standard of work |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Totals
 |  |  |  |  |  | D
 | ID | Forename | Surname | Midys/additional | SEN | L | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-02 00:00:00 |  | 1900-01-03 00:00:00 |  | 1900-01-04 00:00:00 |  | 1900-01-05 00:00:00 | 1900-01-06 00:00:00 | 1900-01-06 00:00:00 |  | 1900-01-07 00:00:00 |  | 1900-01-08 00:00:00 | 1900-01-09 00:00:00 | 1900-01-09 00:00:00 |  | 1900-01-10 00:00:00 |  | 1900-01-11 00:00:00 |  | 1900-01-12 00:00:00 |  | 1900-01-13 00:00:00 |  | 1900-01-14 00:00:00 | 1900-01-15 00:00:00 | 1900-01-15 00:00:00 | P | A | E | G | L
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 20
 | 21
 | 22
 | 23
 | 24
 | 25
 | 26
 | 27
 | 28
 | 29
 | 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] a new row ABOVE this one: Right-click on the row number, select [NAME], then press Ctrl+d.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [42]
Spreadsheet: 61201d1262019210-need-assistance-with-returning-multiple-values-statescities
Sheet: lookup

state |  | towns/cities |  |  |  |  |  |  |  |  | validation list
Arizona |  | aaaa |  |  |  |  |  |  |  |  | Alabama
 |  | ggg |  |  |  |  |  |  |  |  | Alaska
 |  | lll |  |  |  |  |  |  |  |  | American Samoa
 |  | uuuu |  |  |  |  |  |  |  |  | Arizona
 |  | vvvv |  |  |  |  |  |  |  |  | Arkansas
 |  | tttt |  |  |  |  |  |  |  |  | California
 |  |  |  |  |  |  |  |  |  |  | Colorado
 |  |  |  |  |  |  |  |  |  |  | Connecticut
 |  |  |  |  |  |  |  |  |  |  | Delaware
 |  |  |  |  |  |  |  |  |  |  | District of Columbia
 |  |  |  |  |  |  |  |  |  |  | Florida
 |  |  |  |  |  |  |  |  |  |  | Georgia
 |  |  |  |  |  |  |  |  |  |  | Guam
 |  |  |  |  |  |  |  |  |  |  | Hawaii
 |  |  |  |  |  |  |  |  |  |  | Idaho
 |  |  |  |  |  |  |  |  |  |  | Illinois
 |  |  |  |  |  |  |  |  |  |  | Indiana
 |  |  |  |  |  |  |  |  |  |  | Iowa
 |  |  |  |  |  |  |  |  |  |  | Kansas
 |  |  |  |  |  |  |  |  |  |  | Kentucky
 |  |  |  |  |  |  |  |  |  |  | Louisiana
 |  |  |  |  |  |  |  |  |  |  | Maine
 |  |  |  |  |  |  |  |  |  |  | Maryland
 |  |  |  |  |  |  |  |  |  |  | Massachusetts
 |  |  |  |  |  |  |  |  |  |  | Michigan
 |  |  |  |  |  |  |  |  |  |  | Minnesota
 |  |  |  |  |  |  |  |  |  |  | Mississippi
 |  |  |  |  |  |  |  |  |  |  | Missouri
 |  |  |  |  |  |  |  |  |  |  | Montana
 |  |  |  |  |  |  |  |  |  |  | Nebraska
 |  |  |  |  |  |  |  |  |  |  | Nevada
 |  |  |  |  |  |  |  |  |  |  | New Hampshire
 |  |  |  |  |  |  |  |  |  |  | New Jersey
 |  |  |  |  |  |  |  |  |  |  | New Mexico
 |  |  |  |  |  |  |  |  |  |  | New York
 |  |  |  |  |  |  |  |  |  |  | North Carolina
 |  |  |  |  |  |  |  |  |  |  | North Dakota
 |  |  |  |  |  |  |  |  |  |  | Northern Marianas Islands
 |  |  |  |  |  |  |  |  |  |  | Ohio
 |  |  |  |  |  |  |  |  |  |  | Oklahoma
 |  |  |  |  |  |  |  |  |  |  | Oregon
 |  |  |  |  |  |  |  |  |  |  | Pennsylvania
 |  |  |  |  |  |  |  |  |  |  | Puerto Rico
 |  |  |  |  |  |  |  |  |  |  | Rhode Island
 |  |  |  |  |  |  |  |  |  |  | South Carolina
 |  |  |  |  |  |  |  |  |  |  | South Dakota
 |  |  |  |  |  |  |  |  |  |  | Tennessee
 |  |  |  |  |  |  |  |  |  |  | Texas
 |  |  |  |  |  |  |  |  |  |  | Utah
 |  |  |  |  |  |  |  |  |  |  | Vermont
 |  |  |  |  |  |  |  |  |  |  | Virginia
 |  |  |  |  |  |  |  |  |  |  | Virgin Islands
 |  |  |  |  |  |  |  |  |  |  | Washington
 |  |  |  |  |  |  |  |  |  |  | West Virginia
 |  |  |  |  |  |  |  |  |  |  | Wisconsin
 |  |  |  |  |  |  |  |  |  |  | Wyoming