tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: b22990a0-6e1c-401b-ba2a-4b81f291af27
Sheet: Sheet1

[NAME], by Selected Demographics, Maine 2011, and by Year, Maine 2002-2011 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 |  | All |  | Male |  | Female
 |  | Number | Rate* | Number | Rate* | Number | Rate*
Maine Total |  | 272 | 20.47902857125648 | 150 | 23.07468660729806 | 122 | 17.99078341013825
Ethnicity
 | Hispanic | 2 | 11.13709767234659 | 2 | 22.19016975479862 | 0 | 0
 | Non-Hispanic | 228 | 17.4015249231051 | 128 | 19.9672412448327 | 100 | 14.94366239277922
 | Unknown | 42 |  | 20 |  | 22
Race
 | American Indian or [NAME] | 2 | 22.55045664674709 | 1 | 22.8310502283105 | 1 | 22.27667631989307
 | Asian, Native Hawaiian or Pacific Islander | 2 | 13.63233590075659 | 0 | 0 | 2 | 24.30133657351154
 | Black or African American | 37 | 220.1856700785527 | 24 | 255.291990213807 | 13 | 175.6044846683777
 | White | 190 | 14.98721748109047 | 100 | 16.13202448841317 | 90 | 13.89184733785899
 | Multiple races | 2 | 9.951734089665123 | 2 | 20.08838891120932 | 0 | 0
 | Unknown | 39 |  | 23 |  | 16
Age Group (yrs)
 | 0-4 | 0 | 0 | 0 | 0 | 0 | 0
 | 5--14 | 1 | 0.6608380748465204 | 1 | 1.286968160407712 | 0 | 0
 | 15-24 | 104 | 62.59441826312527 | 41 | 48.19900310354556 | 63 | 77.69624468150705
 | 25-44 | 140 | 44.8569863154151 | 86 | 55.84306799218197 | 54 | 34.15559772296015
 | 45-64 | 27 | 6.510699249099353 | 22 | 10.83669106564079 | 5 | 2.361966667926382
 | 65+ | 0 | 0 | 0 | 0 | 0 | 0
Year
 | 2002 | 140 | 10.81527054399266 | 96 | 15.23473392378507 | 44 | 6.623244275785871
 | 2003 | 229 | 17.53805528240098 | 146 | 22.93055653717185 | 83 | 12.40607628690621
 | 2004 | 211 | 16.01818329508454 | 126 | 19.59128840708831 | 85 | 12.60921808013529
 | 2005 | 141 | 10.66965316060098 | 79 | 12.2368117374259 | 62 | 9.172791724366485
 | 2006 | 137 | 10.36642670028315 | 83 | 12.83981021832318 | 54 | 7.99825815711245
 | 2007 | 118 | 8.958348991464517 | 73 | 11.35658269536822 | 45 | 6.672518712708035
 | 2008 | 96 | 7.292306009467844 | 53 | 8.250709483178671 | 43 | 6.378998556566141
 | 2009 | 143 | 10.84729511697253 | 81 | 12.58584791323534 | 62 | 9.188983298281808
 | 2010 | 162 | 12.19547999376675 | 86 | 13.22962944730915 | 75 | 11.05697289567378
 | 2011 | 272 | 20.47902857125648 | 150 | 23.07468660729806 | 122 | 17.99078341013825
* Rate = number of cases per 100,000 population using the corresponding year census estimate as the denominator.
Spreadsheet: 140971d1328993220-relational-contraints-in-solver-i-e-cant-pursue-project-a-and-b-at-same-time-solvershow
Sheet: Sheet1

Decision Variables: (1) Which Show to Invest in (2) How much to invest in each show
 | Show# | Invest (Yes=1,No=0) | ROI | Amount Invested | Total Return
 | 1 | 1 | 0.07
 | 2 | 1 | 0.09
 | 3 | 1 | 0.04
 | 4 | 1 | 0.25
 | 5 | 1 | 0.21
 | 6 | 1 | 0.14
 | 7 | 1 | 0.08
 | 8 | 1 | 0.16
Object to Maximize: Total Return
Constraints:
Show 2 can't be pursued unless Show 1 is
Show 3 can't be pursued unless Show 1 is
Show 4 can't be pursued unless Show 2 is
Show 4 can't be pursued unless Show 3 is
If Show 6 is funded, so MUST Show 7 (and vice-versa)
Shows 5 and 6 cannot be funded simultaneously
Total Amount Invested Must be <= | 28000
Amount invested in any one show >= | 700
Amount invested in any one show <= | 7000
Spreadsheet: 488347d1478622459-keep-different-cells-in-the-same-row-after-moving-one-example
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 70 | 27.4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 71 | 26.5
Configuration before change |  |  |  |  |  |  |  | Configuration after change |  |  |  |  |  |  |  |  |  |  |  | 72 | 25.6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 73 | 24.7
2027 | 66 |  | 100000 |  |  |  | 0.03 | 2027 | 66 |  | 100000 |  |  |  |  |  |  |  |  | 74 | 23.8
 | 67 |  |  |  |  |  | 0.03 |  | 67 |  |  |  |  |  |  |  |  |  |  | 75 | 22.9
 | 68 |  |  |  |  |  | 0.03 |  | 68
 | 69 |  |  |  |  |  | 0.03 |  | 69
 | 70 |  |  | 27.4 |  |  | 0.03 |  | 70
 |  |  |  | 26.5 |  |  | 0.03 |  | 71
 |  |  |  | 25.6 |  |  | 0.03 |  | 72
 |  |  |  | 24.7 |  |  | 0.03 |  | 73
 |  |  |  | 23.8 |  |  | 0.03 |  | 74
 |  |  |  | 22.9 |  |  | 0.03 |  | 75
 |  |  | If numbers in column B move, need the numbers in columns E&F to move with it
 |  |  | as shown in the difference between the above before and after examples
Spreadsheet: 59432d1259931036-vlookup-within-vlookups-new-copy_new
Sheet: Sheet1

Date |  |  |  |  |  |  |  |  |  |  |  | 2009-11-30 00:00:00
Quote |  |  |  |  |  |  |  |  |  |  |  | 81105
AGL ref |  |  |  |  |  |  |  |  |  |  |  | 10/1105/09
Shipper ref
Shipper short code |  |  |  |  |  |  |  |  |  |  |  | Client 3
Shipper |  |  |  |  |  |  |  |  |  |  |  | Client3 [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | Client3 [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | Client3 [NAME] 3
 |  |  |  |  |  |  |  |  |  |  |  | Client3 [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | Client3 Address Line 5
 |  |  |  |  |  |  |  |  |  |  |  | Client3 [NAME] 6
Contact |  |  |  |  |  |  |  |  |  |  |  | Stuart Eade |  |  |  | This is where you choose the consignee
Consignee |  |  |  |  |  |  |  |  |  |  |  | Client 3 Consignee A |  |  |  | associated with the shipper
Notify
Loading cargo at
Collection date |  |  |  |  |  |  |  |  |  |  |  | 2009-11-30 00:00:00
Collection time |  |  |  |  |  |  |  |  |  |  |  | 18:45:00 | hrs
Haulage by
Shipping line
Departure airport
[NAME] airport
Final destination
Flight number
ETS
Connecting airport
ETS
ETA
Time |  |  |  |  |  |  |  |  |  |  |  | 18:45:00 | hrs
Freight charges payable
Other charges payable
Declared value of goods
Amount of insurance
Shipping marks &/or case numbers
Number and kind of packages
Dimensions |  |  |  |  |  |  |  |  |  |  |  |  | cms
 |  |  |  |  |  |  |  |  |  |  |  |  | cms
 |  |  |  |  |  |  |  |  |  |  |  |  | cms
 |  |  |  |  |  |  |  |  |  |  |  |  | cms
 |  |  |  |  |  |  |  |  |  |  |  |  | cms
Total number of items
Gross weight |  |  |  |  |  |  |  |  |  |  |  |  | kgs
Chargeable weight |  |  |  |  |  |  |  |  |  |  |  |  | kgs
Cube |  |  |  |  |  |  |  |  |  |  |  |  | m³
Booking ref
MAWB no
Booking confirmation date
Invoice date
Spreadsheet: 773826d1648056725-conditional-formatting-for-date-values-between-1st-of-each-month-and-15th-16th-and-eom-condformattingdates
Sheet: Holiday Leave Planner 2018-2019

 | NOVEMBER 2018 |  |  |  |  |  |  |  | DECEMBER 2018 |  |  |  |  |  |  |  | JANUARY 2019 |  |  |  |  |  |  |  |  | Category | # of Days (Leave) | # of Hours (Leave)
 | Su | M | T | W | R | F | Sa |  | Su | M | T | W | R | F | Sa |  | Su | M | T | W | R | F | Sa |  |  | Weekend
 |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  | 1 |  |  |  | 1 |  |  |  |  |  |  | Federal Holiday (FH)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FH |  |  |  |  |  |  | [NAME] (TB)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] (AL)
 |  | FH
 |  |  |  |  | FH
 |  |  |  |  |  | AL
 |  |  |  |  |  |  |  |  |  | TB | FH | TB | TB | TB
 |  | AL |  |  |  |  |  |  |  | AL |  | AL | AL | AL
 |  |  |  |  |  |  |  |  |  | TB
 |  |  |  |  |  |  |  |  |  | AL
Spreadsheet: 77213d1277735588-excel-2007-finding-the-latest-data-based-on-2-variables-date-calculator
Sheet: Sheet1

Name | Test | Test date | valid for (days) | New test date
a | m3 | 2010-02-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | m1 | 10
a | m2 | 2010-04-03 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | m2 | 20
c | m3 | 2010-05-23 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | m3 | 30
a | m3 | 2010-08-04 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | m4 | 40
e | m5 | 2010-10-05 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | m5 | 50
Table required
Test | m1 | m2 | m3 | m4
Name
a | New test dates in here
b
c
d
e
Spreadsheet: 724721d1616337804-returning-value-from-last-few-cells-excluding-cells-with-no-value-new-microsoft-excel-worksheet
Sheet: Sheet1

Pay
Month | 1 | 2 | 3 | 4 | 5 | 6 | 7
employee | 1300 | 1300 | 1300 | 1500 |  | 1300 | 1300
Average Rate
 | 1 | 2 | 3 | 4 | 5 | 6 | 7
employee
Spreadsheet: 793385d1661441327-formula-to-calculate-national-insurance-in-two-different-countries-national-insurance
Sheet: Sheet1

First Name | Last Name | Location | Employment Type | [NAME] (GBP Amount) | Weekly Wage | Employer NI (weekly) | Employer NI (Yearly)
Adam | Smith | UK | Full-time | 30000 |  |  |  |  | UK | 0.155
Adam | Plovid | Bulgaria | Full-time | 10000 |  |  |  |  | Bulgaria | 0.1962
Spreadsheet: 01d5e329-958b-4bc5-a877-8aefc3bf9283
Sheet: Overall Metrics

[NAME] | Value |  | [NAME] | [NAME] | In-Degree Bin | In-Degree Frequency | Out-Degree Bin | Out-Degree Frequency | Betweenness Centrality Bin | Betweenness Centrality Frequency | Closeness [NAME] | Closeness Centrality Frequency | Eigenvector [NAME] | Eigenvector Centrality Frequency | PageRank Bin | PageRank Frequency | Clustering Coefficient Bin | Clustering Coefficient Frequency | Dynamic Filter Bin | Dynamic Filter Frequency |  | [NAME] | Value
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Not Available
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dynamic Filter Source Column Range | Vertices[Size2]
Readability Metric | Value
Minimum Degree
Maximum Degree
Average Degree
[NAME]
Minimum In-Degree
Maximum In-Degree
Average In-Degree
Median In-Degree
Minimum Out-Degree
Maximum Out-Degree
Average Out-Degree
Median Out-Degree
Minimum Betweenness Centrality
Maximum Betweenness Centrality
Average Betweenness Centrality
Median Betweenness Centrality
Minimum Closeness Centrality
Maximum Closeness Centrality
Average Closeness Centrality
Median Closeness Centrality
Minimum Eigenvector Centrality
Maximum Eigenvector Centrality
Average Eigenvector Centrality
Median Eigenvector Centrality
Minimum PageRank
Maximum PageRank
Average PageRank
Median PageRank
Minimum Clustering Coefficient
Maximum Clustering Coefficient
Average Clustering Coefficient
Median Clustering Coefficient
Spreadsheet: 103331d1301069172-list-to-table-test2
Sheet: Sheet1

U22 |  |  | U22 | F04 | U21 | T01 | P25 | S06 | A85 | B02 | P27 | W01 | U24
F04 |  | U22
U21 | U24 |  | F04
T01 |  | U21
P25 |  | T01
S06 |  | P25
T01 | U21 | W01 |  | S06
U21 |  | A85
T01 | U11 | U22 |  | B02
A85 | L03 | U11 | X15 |  | P27
 |  | W01
 |  | U24
Spreadsheet: 09e6a2e2-2356-4f26-b5a7-d165817acf12
Sheet: All sets

Set | All IS Sets | ACF Fall | [NAME] | ATTACK | BDAT | DAFT | FKT | GSAC | HFT | HT22 | HT23 | IMSANITY2 | IS103A | IS106A | [NAME] | IS108A | IS109 | IS110A | IS111 | IS112A | IS113 | IS114A | IS115 | LIST | MN Novice | OLEFIN | RAVE | RMTP | SCTD1 | WUHSAC
Stat lines
Average
Median
3rd Quartile
1st Quartile
Standard Deviation
[NAME]
Min
Spreadsheet: 883433d1732054880-i-trying-to-calculate-the-number-of-days-between-2-dates-time-period-checks
Sheet: Sheet1

 |  |  |  |  | Number of Days In Set Periods
 |  |  |  |  | From | To
 |  |  | Set Period |  | 2024-03-01 00:00:00 | 2024-05-31 00:00:00
 |  |  | Total Days In & Out |  | In | Out
 |  |  |  |  | 2024-02-11 00:00:00 | 2024-04-11 00:00:00 | 59
 |  |  |  |  | 2024-02-23 00:00:00 | 2024-05-08 00:00:00 | 74
 |  |  |  |  | 2024-03-03 00:00:00 | 2024-05-28 00:00:00 | 87
 |  |  |  |  | 2024-03-15 00:00:00 | 2024-06-15 00:00:00 | 77
 |  |  |  |  | 2024-04-19 00:00:00 | 2024-08-11 00:00:00 | 42
 |  |  |  |  | 2024-05-15 00:00:00 | 2024-07-13 00:00:00 | 16
Spreadsheet: 703805d1605183493-selecting-value-multiple-times-from-data-validation-list-jaf-quoting-tool
Sheet: ANALYSIS

 |  |  |  |  |  |  |  |  |  |  |  | DATE
 |  |  |  |  |  |  |  |  |  |  |  | FINAL PROJECT PRICE
Job Number |  |  |  |  |  |  |  |  |  |  |  | TOTAL PROFIT
Job Name |  |  |  |  |  |  |  |  |  |  |  | AVERAGE PROFIT MARGIN
Location
Distance |  |  |  |  |  |  |  |  |  |  |  | DISCOUNT APPLIED |  |  | 0.025
Director |  |  |  |  |  |  |  |  |  |  |  | FINAL PRICE AFTER DISCOUNT
Estimator |  |  |  |  |  |  |  |  |  |  |  | TOTAL PROFIT AFTER DISCOUNT
Planner |  |  |  |  |  |  |  |  |  |  |  | REVISED PROFIT MARGIN
QS
Premium Uplift
Product | Type | Rate App | Quantity |  | Material | Labour | Cutting | Adhesive | Travel | Waste |  | Rate |  | Total | Total Profit |  | Margin
CT101 |  | STANDARD | 55
CT101 |  | LARGE AREA | 1209
[NAME]
[NAME]
Spreadsheet: john_forney__15523__s_9-12-01
Sheet: Sheet1

Flow Date |  | Available Off Peak Capacity |  |  |  |  |  |  | Available On Peak Capacity |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Available Off Peak Capacity
2001-09-12 00:00:00
Counterparty |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24
[NAME] |  | 135 | 135 | 135 | 135 | 135 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 210 | 220 | 230 | 240 | 250 | 250 | 250 | 250 | 250 | 250 | 170 | 150
Enron Call |  |  |  |  |  |  |  | -100 | -100 | -100 | -100 | -100 | -100 | -100 | -100 | -100 | -100 | -100 | -100 | -100 | -100 | -100 | -100
Mirant Call |  |  |  |  |  |  |  |  |  | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50
CP1 |  | -50 | -50 | -50 | -50 | -50 | -50 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -50 | -50
CP2 |  | -30 | -30 | -30 | -30 | -30 | -30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -30 | -30
CP3 |  | -55 | -55 | -55 | -55 | -55 | -55 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -55 | -55
CP4 |  |  |  |  |  |  |  |  |  |  |  |  |  | -10 | -20 | -30 | -40 | -50 | -50 | -50 | -50 | -50 | -50 | -35 | -15
CP5 |  |  |  |  |  |  | -65
CP6 |  |  |  |  |  |  |  | -200 | -200 | -200 | -200 | -200 | -200 | -200 | -200 | -200 | -200 | -200 | -200 | -200 | -200 | -200 | -200
Total
[NAME]: |  | Deal Details
22
Deal_id |  | CP | Volume | Price | Start Hour |  | End Hour
 |  | Mirant Call | -50 |  | 9 |  | 24
770546.1 |  | [NAME] | 135 | 22 | 1 |  | 5
770546.1 |  | [NAME] | 200 | 22 | 6 |  | 6
770546.1 |  | [NAME] | 200 | 22 | 7 |  | 12
770546.1 |  | [NAME] | 210 | 22 | 13 |  | 13
770546.1 |  | [NAME] | 220 | 22 | 14 |  | 14
770546.1 |  | [NAME] | 230 | 22 | 15 |  | 15
770546.1 |  | [NAME] | 240 | 22 | 16 |  | 16
770546.1 |  | [NAME] | 250 | 22 | 17 |  | 22
770546.1 |  | [NAME] | 170 | 22 | 23 |  | 23
770546.1 |  | [NAME] | 150 | 22 | 24 |  | 24
758660.7 |  | Enron Call | -100 |  | 7 |  | 22
771148.1 |  | CP6 | -200 | 22 | 7 |  | 22
771111.1 |  | CP5 | -65 | 5 | 6 |  | 6
770519.1 |  | CP4 | -15 | 22 | 24 |  | 24
770519.1 |  | CP4 | -35 | 23 | 23 |  | 23
770519.1 |  | CP4 | -10 | 25 | 13 |  | 13
770519.1 |  | CP4 | -20 | 25 | 14 |  | 14
770519.1 |  | CP4 | -30 | 25 | 15 |  | 15
770519.1 |  | CP4 | -40 | 25 | 16 |  | 16
770519.1 |  | CP4 | -50 | 25 | 17 |  | 22
770518.1 |  | CP3 | -55 | 11 | 1 |  | 6
770518.1 |  | CP3 | -55 | 11 | 23 |  | 24
770515.1 |  | CP2 | -30 | 11 | 1 |  | 6
770515.1 |  | CP2 | -30 | 11 | 23 |  | 24
770514.1 |  | CP1 | -50 | 11 | 1 |  | 6
770514.1 |  | CP1 | -50 | 11 | 23 |  | 24
Spreadsheet: rick_buy__32698__DOUG
Sheet: 0201

4
POWER PLANTS  ACCOUNTS RECEIVABLE AGING
AS OF FEBRUARY 28, 2001
 |  |  | CURRENT |  | 1-30 |  | 31-60 |  | 61-90 |  | OVER 90 |  | TOTAL | COMMENTS
SMITH ENRON | A/R |  | 8545503.7 |  | 5280547.76 |  | 5352225.66 |  | 46681.43 |  |  |  |  | THIS MONTH TOTAL PAYMENTS
 | PER CENT |  |  |  |  |  | 0 |  | 0 |  |  |  |  | 1980000
PUERTO QUETZAL | A/R |  | 72893.35 |  | 9025.65 |  | 37119.76 |  | -152850.42 |  |  |  |  | THIS MONTH TOTAL PAYMENTS
 | PER CENT |  |  |  |  |  |  |  |  |  |  |  |  | 1757637.33
HAINAN MEINAN | A/R |  |  |  |  |  |  |  |  |  | 68695.76
 | PER CENT
DABHOL POWER CO | A/R |  | 453791.36 |  | -98798.97 |  | 222492.95 |  | 222492.95 |  |  |  |  | THIS MONTH TOTAL PAYMENTS
 | PER CENT |  |  |  |  |  |  |  |  |  |  |  |  | 323137.95
EMPRESA ENERGETICA | A/R |  | 0 |  | 1148606.8 |  | 860590.43 |  | 0 |  |  |  |  | THIS MONTH TOTAL PAYMENTS
 | PER CENT |  |  |  |  |  |  |  |  |  |  |  |  | 1588292.58
EGEMINSA | A/R |  | 1125618.82 |  | -898637.5 |  | 1244679.26 |  | -739143.8 |  |  |  |  | THIS MONTH TOTAL PAYMENTS
 | PER CENT
TOTALS | A/R
 | PER CENT
Spreadsheet: 764985d1643108161-generating-random-names-and-comparing-to-existing-list-badmintonschedulertesting
Sheet: Matches

 | 1 | 2 | 3 | 4 | 5 | 6
Game 1 | Court 1 | Court 2 | Court 3 | Court 4 | Court 5 | Sit Out
 | O | A | B | F | J | D
 | Q | C | I | G | M | U
 | S | E | L | K | N | V
 | W | H | R | T | P
Game 2 | Court 1 | Court 2 | Court 3 | Court 4 | Court 5 | Sit Out
 | B | C | E | F | G | A
 | H | D | L | I | K | M
 | T | J | P | N | O | W
 | U | Q | S | R | V
Game 3 | Court 1 | Court 2 | Court 3 | Court 4 | Court 5 | Sit Out
 | A | B | H | I | F | L
 | C | D | K | J | G | R
 | N | E | M | T | O | S
 | W | Q | V | U | P
Game 4 | Court 1 | Court 2 | Court 3 | Court 4 | Court 5 | Sit Out
 | C | F | A | J | D | B
 | H | G | M | N | E | K
 | O | I | R | S | P | Q
 | V | L | W | T | U
Court 1 | Court 2 | Court 3 | Court 4 | Court 5
Court 1 | Court 2 | Court 3 | Court 4 | Court 5
Court 1 | Court 2 | Court 3 | Court 4 | Court 5
Court 1 | Court 2 | Court 3 | Court 4 | Court 5
Spreadsheet: 845473d1696970664-sum-value-in-a-table-based-on-if-a-date-falls-between-two-other-dates-sample
Sheet: Sheet1

Net income | Payout Date |  | Start date | End date | Net
357.85 | 2022-06-20 00:00:00 |  | 2022-06-20 00:00:00
71.57 | 2022-06-23 00:00:00 |  | 2022-06-27 00:00:00
508.9299999999999 | 2022-06-30 00:00:00 |  | 2022-07-04 00:00:00
365.8 | 2022-07-07 00:00:00 |  | 2022-07-11 00:00:00
659.99 | 2022-07-14 00:00:00 |  | 2022-07-18 00:00:00
Spreadsheet: 733060d1621367872-need-help-with-ideas-for-scanning-inventory-test-draft
Sheet: Sheet1

PO | Service Tag | Scanned tag | Model | Location | Match
1 | 1ABCDEF |  | 1111 | Blank
1 | 2ABCDEF |  | 1111 | Blank |  |  |  |  |  | Scanned Item | 6ABCDEF
1 | 3ABCDEF |  | 1111 | Blank
1 | 4ABCDEF |  | 1111 | Blank
1 | 5ABCDEF |  | 1111 | Blank
1 | 6ABCDEF |  | 1111 | Blank
Spreadsheet: 64280d1265147706-backlog-priority-formulas-whiteboard
Sheet: Whiteboard

 | ACTIVE / N-ACTIVE | Status
 | Category | Category | Category | Category | Category | Category | Category | Category
 | Date | 2010-02-02 00:00:00 |  | TOTAL Files | 7457
 | GROUPS | TOTAL | Oldest Case | Days Old | Distribution
 | R | 3102 | 2009-11-26 00:00:00 | 68 | 0.4831974930247261
 | T | 1682 | 2009-11-18 00:00:00 | 76 | 0.2928286396268858
 | S | 1577 | 2009-12-02 00:00:00 | 62 | 0.223973867348388
 | U | 201 | 2009-12-12 00:00:00 | 52
 | M | 12 | 2010-01-29 00:00:00 | 4 | 0.0001099550558709128
 | V | 533 | 2010-01-29 00:00:00 | 4
 | WR | 277 | 2010-01-27 00:00:00 | 6
 | C | 706 | 2009-12-03 00:00:00 | 61
 | N-ACTIVE | 7179 | 2009-11-26 00:00:00 | 68
 | K | 266 | 2010-01-30 00:00:00 | 3
 | Status: | OK
Spreadsheet: scott_neal__38619__Trading Track  Rotations 529
Sheet: Rotation list

 | Name | Rotation Date | Group | Supervisor |  | Management Team/Interview Team | Training Team
 |  |  |  |  |  | [NAME] | [NAME]
Power |  |  |  |  |  | [NAME] | [NAME]
 | [NAME] | 2001-02-01 00:00:00 | MW-Fundamentals | [NAME] |  | [NAME] | [NAME]
 |  | 2001-04-01 00:00:00 | [NAME] | [NAME] |  | Black Don | [NAME]
 |  |  |  |  |  | [NAME] | Grigbsy Mike
 | [NAME] | 2001-02-01 00:00:00 | Book Running | [NAME] |  | [NAME] | [NAME]
 |  | 2001-05-01 00:00:00 | Fundamentals | [NAME] |  | [NAME] | [NAME]
 |  |  |  |  |  | [NAME] | [NAME]
 | [NAME] | 2001-02-01 00:00:00 | Real Time (night) | [NAME] |  | [NAME] | [NAME]
 |  | 2001-08-01 00:00:00 | TBC |  |  | Grigbsy Mike | Schwieger Jim
 |  |  |  |  |  | [NAME] | Shively [NAME]
 | [NAME] | 2001-02-01 00:00:00 | Fundamentals | [NAME] |  | Kitchen Louise | [NAME]
 |  | 2001-08-01 00:00:00 | S/E Fundamentals | [NAME][NAME] |  | [NAME] John
 |  |  |  |  |  | [NAME]
 | [NAME] | 2001-03-01 00:00:00 | Power Scheduling | [NAME] |  | [NAME]
 |  | 2001-09-01 00:00:00 | EES | [NAME] |  | [NAME]
 |  | 2002-03-01 00:00:00 | Real Time (days) | [NAME] |  | [NAME]
 |  |  |  |  |  | Schwieger Jim
 |  |  |  |  |  | Shively [NAME]
 | [NAME] | 2001-03-01 00:00:00 | Book Running | [NAME] |  | [NAME]
Gas |  | 2001-09-01 00:00:00 | Noms-Logistics | [NAME] |  | [NAME]
 |  |  |  |  |  | [NAME]
 | Bilal Bajwa | 2001-01-01 00:00:00 | Book Running | [NAME] |  | [NAME]
 |  | 2001-07-01 00:00:00 | Fundamentals | [NAME]
 |  |  |  |  |  | Training Schedule: | 32C2  Time:4-6 pm
 | [NAME] | 2001-02-01 00:00:00 | Mid Market | [NAME] |  | April 18th | [NAME]
 |  | 2001-08-01 00:00:00 | Structuring | [NAME] |  | May 2nd | [NAME]
 |  |  |  |  |  | May 16th | [NAME]
 | Denver Palchey | 2001-03-01 00:00:00 | Fundamentals | [NAME] |  | Re-schedule | [NAME]
 |  | 2001-09-01 00:00:00 | Structuring | [NAME] |  | June 13th | Grigbsy Mike
 |  |  |  |  |  | June 27th | [NAME]
 | [NAME] | 2001-02-01 00:00:00 | East Gas Trading | [NAME] |  | July 11th | [NAME]
 |  |  |  |  |  | July 25th | [NAME]
 | [NAME] | 2001-02-01 00:00:00 | Book Running | [NAME] |  | August 8th | [NAME]
 |  | 2001-08-01 00:00:00 | Noms-Logistics | [NAME] |  | August 22nd | Schwieger Jim
 |  |  |  |  |  | September 4th | Shively [NAME]
 | [NAME] | 2001-02-01 00:00:00 | Fundamentals | [NAME] |  | September 19th | [NAME]
 |  | 2001-08-01 00:00:00 | Book Running | [NAME]
 | [NAME] | 2001-03-01 00:00:00 | Noms-Logistics | [NAME]
 |  | 2001-09-01 00:00:00 | Fundamentals | [NAME]
 | [NAME] | 2001-02-01 00:00:00 | Fundamentals | [NAME]
 |  | 2001-08-01 00:00:00 | Noms-Logistics | [NAME]
Spreadsheet: kevin_presto__19948__Update 2 ss
Sheet: Sheet1

New Generation Project   UPDATE 2
2001-05-15 00:00:00
Please note that new/updated information is provided in red.  If you have any questions, please feel free to contact [NAME] (3-9510) or [NAME] (3-9844).
Company | Plant | MW | Unit | # of Units | MW/Unit | Fuel | Sched. Mo | Year | City | State | NERC | Test Date | Start Date
Mississippi Power | Daniel / Escatawpa | 1000 | CC |  |  | NG | 4 | 2001 | Jackson County | MS | SOCO
 |  |  |  | 1 | 532 |  |  |  |  |  |  | tested | in service
 |  |  |  | 2 | 532 |  |  |  |  |  |  | tested | 2001-05-01 00:00:00
Calpine | Hog Bayou Energy Center | 240 | CC |  |  | NG | 4 | 2001 | Mobile | AL | SOCO | not set | 2001-06-10 00:00:00
Duke Energy | Attala | 500 | CC |  |  | NG | 5 | 2001 | McAdams | MS | SPP | currently testing | approx 5/15
Great River Energy | [NAME] Junction | 486 | CT |  |  | NG | 5 | 2001 | Trimont | MN | MAPP |  | 2001-06-01 00:00:00
(NRG/Tenaska) |  |  |  | 1 | 85 |  |  |  |  |  |  | tested | approx 5/18
 |  |  |  | 2 | 85
 |  |  |  | 3 | 85
 |  |  |  | 4 | 85
 |  |  |  | 5 | 85
 |  |  |  | 6 | 85
[NAME] | New Castle | 335 | CT |  |  | NG | 5 | 2001 | New Castle Cty | DE | PJM | currently testing
 |  |  |  | 1 | 120 |  |  |  |  |  |  |  | 2001-06-01 00:00:00
 |  |  |  | 2 | 120 |  |  |  |  |  |  |  | 2001-07-01 00:00:00
 |  |  |  | 3 | 120 |  |  |  |  |  |  |  | 2001-08-01 00:00:00
Constellation Power | Big Sandy Peaker Plant LLC | 300 | CT |  |  | NG | 5 | 2001 | Wayne County | WV | ECAR | currently testing | 2001-06-01 00:00:00
 |  |  |  | 1 | 50
 |  |  |  | 2 | 50
 |  |  |  | 3 | 50
 |  |  |  | 4 | 50
 |  |  |  | 5 | 50
 |  |  |  | 6 | 50
Carolina Power & Light | MEAG/Merchant | 160 | CT |  |  | NG | 5 | 2001 | Monroe | GA | SOCO
 |  |  |  | 1 | 155 |  |  |  |  |  |  | currently testing | 2001-06-01 00:00:00
Spreadsheet: 112215d1308324795-grouped-by-a-counting-value-in-b-example-for-penfold
Sheet: Sheet1

Header A | Header B | [NAME]
A | 0
A | 1 | 1
A | 0
A | 1 | 2
A | 0
B | 0
B | 1 | 1
B | 1 | 2
B | 0
B | 1 | 3
C | 0
C | 0
C | 0
C | 1 | 1