tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 841046d1693302757-help-on-arranging-time-in-a-proper-manner-trial-sheet
Sheet: Sheet1

 | A | B | C
TotalDepMon | 596 | 333 | 931
N | 0.13
Instances1 | 76 | 89 | 220
Instances2 | 72 | 56 | 85
Instances3 | 72 | 32 | 76
Instances4 | 64 | 32 | 75
Instances5 | 59 | 24 | 71
LTBucketRank1 | B06 | B07 | B07
LTBucketRank2 | B07 | B14 | B18
LTBucketRank3 | B14 | B13 | [NAME]
LTBucketRank4 | B15 | B19 | B06
LTBucketRank5 | B09 | B11 | B13
Range1 | B06-B09 | B07 | B06-B07 | Results required (Mocked up manually).Difference between the buckets sould not be more than 3 hours and raking must be followed from the cells above.
Range 2 | B14-B15 | B11-B14 | B18-B20
Range 3 | not applicable | B19 | B13
Spreadsheet: 781436d1653321795-need-help-with-pulling-data-from-one-sheet-to-another-using-index-requiredtraining2022-test-1-aligw
Sheet: Dashboard

Select Supervisor Below | SupervisorList |  | Employee Name | Class1 | Class2 |  | Monday1End | Monday2End | Tuesday1End | Tuesday2End | Wednesday1End | Wednesday2End | Thursday1End | Thursday2End | [NAME] | Friday2End
Supervisor, [NAME] | Supervisor, [NAME]
 | Supervisor, [NAME]
Spreadsheet: kate_symes__18195__EESSales_dailyfeb
Sheet: 2-5

NP15 | 2001-02-05 00:00:00 |  |  |  |  |  | SP15 |  |  |  |  |  |  |  | ZP26
Fixed Peak | 182 | Fixed Off Peak | 175 |  |  |  | Fixed Peak | 178.5 |  | Fixed Off Peak | 166.25 |  |  |  | Fixed Peak | 178.5 | Fixed Off Peak | 166.25
Index Peak |  | Index [NAME] |  |  |  |  | Index Peak |  |  | Index [NAME] |  |  |  |  | Index Peak |  | Index [NAME]
HE | Fixed | Other | DJ Index | Load | var |  | HE | Fixed | Other | DJ Index | Load | var |  | HE | Fixed | Other | DJ Index | Load | var
1 | -56.72 | 0 | -17 | -8.72 |  |  | 1 | -192.63 | 0 | -54 | -246.63 |  |  | 1 | -1.97 | 0 | 0 | -1.97
2 | -66.76 | 0 | -17 | -7.76 |  |  | 2 | -184.24 | 0 | -54 | -238.24 |  |  | 2 | -1.93 | 0 | 0 | -1.93
3 | -67.26 | 0 | -17 | -7.26 |  |  | 3 | -182.97 | 0 | -54 | -236.97 |  |  | 3 | -1.91 | 0 | 0 | -1.91
4 | -62.2 | 0 | -17 | -7.2 |  |  | 4 | -188.46 | 0 | -54 | -242.46 |  |  | 4 | -1.91 | 0 | 0 | -1.91
5 | -44.44 | 0 | -17 | -7.44 |  |  | 5 | -205.18 | 0 | -54 | -259.18 |  |  | 5 | -1.92 | 0 | 0 | -1.92
6 | -9.55 | 0 | -17 | -9.55 |  |  | 6 | -241.2 | 0 | -54 | -295.2 |  |  | 6 | -2 | 0 | 0 | -2
7 | -107.13 | 0 | -17 | -38.13 |  |  | 7 | -283.23 | 0 | -54 | -337.23 |  |  | 7 | -2.16 | 0 | 0 | -2.16
8 | -77.6 | 0 | -17 | -40.6 |  |  | 8 | -312.69 | 0 | -54 | -366.69 |  |  | 8 | -2.26 | 0 | 0 | -2.26
9 | -52.47 | 0 | -17 | -41.47 |  |  | 9 | -337.46 | 0 | -54 | -391.46 |  |  | 9 | -2.29 | 0 | 0 | -2.29
10 | -35.6 | 0 | -17 | -41.6 |  |  | 10 | -354.5 | 0 | -54 | -408.5 |  |  | 10 | -2.3 | 0 | 0 | -2.3
11 | -27.7 | 0 | -17 | -41.7 |  |  | 11 | -362.52 | 0 | -54 | -416.52 |  |  | 11 | -2.3 | 0 | 0 | -2.3
12 | -25.97 | 0 | -17 | -42.97 |  |  | 12 | -364.4 | 0 | -54 | -424.4 |  |  | 12 | -2.35 | 0 | 0 | -2.35
13 | -25.66 | 0 | -17 | -42.66 |  |  | 13 | -364.89 | 0 | -54 | -427.89 |  |  | 13 | -2.35 | 0 | 0 | -2.35
14 | -25.46 | 0 | -17 | -42.46 |  |  | 14 | -364.65 | 0 | -54 | -429.65 |  |  | 14 | -2.33 | 0 | 0 | -2.33
15 | -24.99 | 0 | -17 | -41.99 |  |  | 15 | -364.75 | 0 | -54 | -424.75 |  |  | 15 | -2.32 | 0 | 0 | -2.32
16 | -27.16 | 0 | -17 | -42.16 |  |  | 16 | -363.09 | 0 | -54 | -417.09 |  |  | 16 | -2.33 | 0 | 0 | -2.33
17 | -34.83 | 0 | -17 | -42.83 |  |  | 17 | -355.72 | 0 | -54 | -409.72 |  |  | 17 | -2.35 | 0 | 0 | -2.35
18 | -30.12 | 0 | -17 | -45.12 |  |  | 18 | -359.86 | 0 | -54 | -413.86 |  |  | 18 | -2.44 | 0 | 0 | -2.44
19 | -42.28 | 0 | -17 | -46.28 |  |  | 19 | -348.23 | 0 | -54 | -402.23 |  |  | 19 | -2.49 | 0 | 0 | -2.49
20 | -53.66 | 0 | -17 | -44.66 |  |  | 20 | -336.02 | 0 | -54 | -390.02 |  |  | 20 | -2.43 | 0 | 0 | -2.43
21 | -68.96 | 0 | -17 | -42.96 |  |  | 21 | -321.31 | 0 | -54 | -375.31 |  |  | 21 | -2.37 | 0 | 0 | -2.37
22 | -90.9 | 0 | -17 | -40.9 |  |  | 22 | -299.46 | 0 | -54 | -353.46 |  |  | 22 | -2.27 | 0 | 0 | -2.27
23 | 0 | 0 |  | -13.3 |  |  | 23 | -252.62 | 0 | -54 | -322.62 |  |  | 23 | -2.17 | 0 | 0 | -2.17
24 | -10.69 | 0 | -17 | -10.69 |  |  | 24 | -239.43 | 0 | -54 | -293.43 |  |  | 24 | -2.05 | 0 | 0 | -2.05
Spreadsheet: 180917d1347873398-dropdown-v-lookup-issue-overtime-calculator-sandbox
Sheet: Stats Input Sheet

Agent Name | Staffed Time | Staffed Time | Staffed Time | Staffed Time | Staffed Time | Staffed Time | Staffed Time | Staffed Time | Staffed Time | Staffed Time | Staffed Time | Staffed Time | Staffed Time | Staffed Time | Staffed Time | Staffed Time | Staffed Time | Staffed Time | Staffed Time | Staffed Time | Staffed Time | Staffed Time | Staffed Time | Staffed Time | Staffed Time | Staffed Time | Staffed Time | Staffed Time | Staffed Time | Staffed Time | Staffed Time
Spreadsheet: 202584d1356635746-totaling-quatnities-with-drop-down-list-cable-group
Sheet: Sheet1 (2)

Monday |  |  |  |  |  |  | 2012-12-31 00:00:00 | 4 Sensor 10' | 4 Sensor 15' | 4 Sensor 20' | 4 Sensor 25' | 4 Sensor 30' | 4 Sensor 40' | 4 Sensor 50' | Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 Sensor | 3'
 | Cable Type | Length | Qty | Notes |  |  | [NAME] |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 Sensor | 5'
2012-12-31 00:00:00 | 4 Sensor | 15' | 10 |  |  |  |  | 8 Sensor 10' | 8 Sensor 15' | 8 Sensor 20' | 8 Sensor 25' | 8 Sensor 30' | 8 Sensor 40' | 8 Sensor 50' | Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 DIN | 10'
2013-01-01 00:00:00 | 4 Sensor | 20' | 10 |  |  |  |  |  |  |  |  |  |  |  | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 DIN | 15'
 | 5 DIN | 25' | 10 |  |  |  |  | 5 din 10' | 5 din 15' | 5 din 20' | 5 din 25' | 5 din 30' | 5 din 40' | 5 din 50' | Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13 DIN | 20'
 | 8 DIN | 25' | 10 |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25'
 | 13 DIN | 20' | 20 |  |  |  |  | 8 din 10' | 8 din 15' | 8 din 20' | 8 din 25' | 8 din 30' | 8 din 40' | 8 din 50' | Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30'
 | 8 Sensor | 10' | 30 |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40'
 | 4 Sensor | 30' | 10 |  |  |  |  | 13 din 10' | 13 din 15' | 13 din 20' | 13 din 25' | 13 din 30' | 13 din 40' | 13 din 50' | Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50'
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: louise_kitchen__24046__East Power Consolidation
Sheet: Midwest Origination

 |  | 2001-09-01 00:00:00 |  | 2001-09-01 00:00:00 |  | %
 |  | YTD Actual |  | Annualized |  | of Total
ENACOMP | Compensation
 | Special Pays | 250000
 | Analysts & Associates
ENABENTX | Benefits & Payroll Taxes
ENAEMPEX | Employee Expense
ENAT&EEX | Travel & Entertainment Expense
ENAOUTSV | Outside Services
ENASUPP | Supplies Expense
ENAMKTEX | Marketing
ENACONTR | Charitable Contributions
ENARENT | Rent
ENATECH | Technology
ENATRANS | Transportation
ENAOTHEX | Other Expenses
ENATAXES | Taxes Other than Income
ENATOTDR | Total Direct Expenses
 | Headcount |  |  | 7
 | Analyst & Associate Headcount |  |  | 3
 | Total Headcount
ENAOUTLG | Outside Legal
ENAOUTTX | Outside Tax
ENAINSUR | Insurance
ENASYSDV | System Development
ENACORIT | Controllable Infrastructure
ENACORRN | Corporate Rent
ENAOTHAL | Other Allocated Direct  Expenses
ENADEPR | Depreciation & Amortization
 | Boondoggles |  |  | 37025
Spreadsheet: chris_germany__1831__DecCohCHOICE-ENA
Sheet: Dec 3

 | COH CHOICE NOMINATIONS TO ACTUALS
 | FOR GAS DAY |  |  |  |  |  |  |  | 2000-12-03 00:00:00
 |  | MA | NOM ID |  | FT |  | AT |  | FORECASTED |  | ACTUALS |  | CONTRACT # | % Storage | Over | Sto | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FT DROP |  | AT DROP
 | COH 3-15 | 22-15 | 3342 |  |  |  |  |  | 1471 |  | 1602 |  | 67694 |  |  |  |  |  | 25 | 1 | 24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 | 2 | 25
 | COH 5-2 | 23N-02 | 3343 |  |  |  |  |  | 5788 |  | 5788 |  | 67694 |  |  |  |  |  | 25 | 3 | 25
 |  |  |  |  |  |  |  |  | 5000 |  | 5000 |  | 68918 | 0 |  |  |  |  | 24 | 4 | 24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26 | 5 | 25
 | COH 5-7 | 23N-07 | 3344 |  |  |  |  |  | 2136 |  | 2264 |  | 67694 |  |  |  |  |  | 26 | 6 | 25
 |  |  |  |  |  |  |  |  | 1535 |  | 1535 |  | 68915 | 0 |  |  |  |  | 25 | 7 | 24
 |  |  |  |  |  |  |  |  | 1540 |  | 1540 |  | 69693 | 0 |  |  |  |  | 27 | 8 | 25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 | 9 | 23
 | COH 7-1 | 23-01 | 3788 |  |  |  |  |  | 15074 |  | 15728 |  | 67694 |  |  |  |  |  | 30 | 15 | 27
 |  |  |  |  |  |  |  |  | 673 |  | 673 |  | 69149 | 0 |  |  |  |  | 26 | 35 | 23
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 68915 | 0 |  |  |  |  | 24 | 39 | 24
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 68918 | 0
 | COH 7-3 | 23-03 | 3789 |  |  |  |  |  | 1651 |  | 1651 |  | 67694
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | %
 | COH 7-4 | 23-04 | 3345 |  |  |  |  |  | 1373 |  | 1373 |  | 67694 |  |  |  |  |  | Storage
 |  |  |  |  |  |  |  |  | 1915 |  | 1915 |  | 68916 | 0 |  |  |  |  | #67694
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.5
 | COH 7-5 | 23-05 | 2777 |  |  |  |  |  | 14768 |  | 15392 |  | 67694
 | COH 7-6 | 23-06 | 3346 |  |  |  |  |  | 2136 |  | 2240 |  | 67694
 | COH 7-8 | 23-08 | 3790 |  |  |  |  |  | 4379 |  | 4608 |  | 67694
 | COH 7-9 | 23-09 | 3791 |  |  |  |  |  | 5756 |  | 6046 |  | 67694
 | COH 8-35 | 24-35 | 3348 |  |  |  |  |  | 976 |  | 1211 |  | 67694 | 1
 |  |  |  |  |  |  |  |  | 1000 |  | 1000 |  | 69823 | 0
 | COH 8-39 | 24-39 | 3792 |  |  |  |  |  | 47 |  | 47 |  | 67694 | 1
 |  |  |  |  |  |  |  | x | 1.Nom to COH |  | 1. Email to COH |  |  |  |  |  |  | FOM
 |  |  |  |  |  |  |  | x | 2.Email to ENA |  | 2. Email to ENA |  |  |  |  |  |  | Buy/(Sell) NPC (from/to) ENA
Spreadsheet: 112615d1308684248-using-multiple-arguments-book1
Sheet: Sheet1

 |  |  |  |  | ITEM1 | ITEM1 | ITEM1 ITEM1 | GREEN BOOK
 |  |  |  |  | ITEM1 | ITEM2 | ITEM1 ITEM2 | YELLOW BOOK
ITEM1 | ITEM2 | ITEM1 ITEM2 | YELLOW BOOK |  | ITEM1 | ITEM3 | [NAME] | RED BOOK
 |  |  |  |  | ITEM1 | ITEM4 | ITEM1 ITEM4 | BLUE BOOK
 |  |  |  |  | ITEM1 | ITEM5 | ITEM1 ITEM5 | BLACK BOOK
Spreadsheet: 768271d1644913491-if-function-optimisation-book1
Sheet: Sheet1

Lot | PRICE |  |  |  | Lot | Low | High
1 |  |  |  |  | 1 | 1000 | 2000
2 |  |  |  |  | 2 | 2000 | 3000
3 |  |  |  |  | 3 | 5000 | 7500
RATE | 1
1= [NAME]
100-120 = USD
121-150 = EUR
Spreadsheet: rick_buy__32887__Turbine Position Report 111601
Sheet: Summary by Type

Turbine Position Report |  |  |  |  |  |  |  | CONFIDENTIAL
Summary by Turbine Type
($ MMs)
 |  |  |  |  |  |  | Financial Data as of
UNITS | MODEL | CONTROLLED BY | PROJECT(S) | DASH APPROVAL DATE / STATUS | CONTRACT COST | SCHEDULED CONTRACT PYMTS TO DATE | CANCELLATION | STATUS
 |  |  |  |  |  |  |  | Available
 |  |  |  | total per above
 |  |  |  | per Summary By [NAME] report
 |  |  |  | Difference
Spreadsheet: 211496d1359763793-excel-adding-to-cells-value-without-formula-bornin1992
Sheet: BBUS 2210

Course Faculty: |  |  |  |  | SL Leader:
 | Total SL Group |  | SL Group  6+ hrs |  | Non SL Group |  | Total
Grade | Number | Percent | Number | Percent | Number | Percent | Number | Percent
A | 13 |  | 3 |  | 15
B | 18 |  | 9 |  | 6
C | 37 |  | 6 |  | 10
D | 4 |  | 1 |  | 2
F | 19 |  | 7 |  | 16
W | 3 |  | 0 |  | 8
Combined A, B, & C
Combined D, F, & W
GPA
DNC | 1 |  | 0 |  | 7
Totals
Total Graded Enrollment
DNC
Total Enrollment
Number of SL Session Hours Offered During the Term |  |  |  |  |  |  | 40
Total Number and Percentage of Graded Students Attending SL
Total Contact Hours of SL Participating Students |  |  |  |  |  |  | 516
Mean Number of Sessions Attended by SL Participants
Mean Size of SL Sessions
Mean of Student Satisfaction with SL Leader ( 1=low, 5=high) |  |  |  |  |  |  | 4.59
 |  |  |  |  |  |  | 4-point scale | 6+ hrs
Mean Final Grade of SL Participants / 6+hrs Participants
Mean Final Grade of Non-SL Participants |  |  |  |  |  |  | 2
Difference from SL / 6+hrs SL to Non-SL group
Spreadsheet: 128743d1321251143-offset-questions-using-offset
Sheet: Sheet1

 |  |  |  |  |  | This is the reference
 |  |  |  |  |  | [NAME]:[NAME]
 |  |  |  | Name | age | month | day | year
 |  |  |  |  |  |  |  |  |  | formula with { }
 |  | this is 0 ----> |  | a | 26 | 4 | 21 | 2001 |  | a
 |  | this is ---->1 |  | b | 27 | 7 | 22 | 2002
 |  |  |  | c | 28 | 8 | 23 | 2003
 |  |  |  | d | 29 | 9 | 24 | 2004
 |  |  |  | e | 30 | 2 | 25 | 2005 |  | OFFSET(G11:G15,0,-2)
 |  |  |  | this is -2 | this is -1 |  | this is +1 | this is +2 |  | [NAME] : [NAME] | > range to be referenced
 |  |  |  |  | or column -1 from --> | COLUMN 0 | <---- or column 1 | or column 2
 |  |  |  |  |  |  |  |  |  | 0 | the first row to be offset
 |  |  |  |  |  |  |  |  |  | -2
Spreadsheet: 149070d1333675507-need-to-pull-multiple-reference-points-into-one-spread-sheet-kit-report-draft
Sheet: APRIL

APRIL | FORECAST QTY | CHANGE TO FORECAST QTY |  | DATE OF CHANGE | CHANGE VS FORECASTEDQTY |  | REQUEST DATE | REQUESTED QUANTITY |  | SCHEDULED PULL  DATE | EST.PULL COMPLETE DATE |  | EST. LINE SET UP DATE | EST. LINE SET UP  COMPLETE | ACTUAL LINE SET UP  COMPLETE |  | EST. ASSEMBLY START DATE | EST. ASSEMBLY COMPLETION DATE | ACTUAL ASSEMBLY START DATE | TODAY'S ASSEMBLY PRODUCTION | CURRENT QUANTITY COMPLETE | REMAINING WIP QTY | ACTUAL DATE OF COMPLETION |  | CURRENT ON HAND INVENTORY | UNITS [NAME] | SHIPPED VS FORECAST
Toric & Multifocal
PCT84108X |  | 0
PCT108X |  | 0
PCT84324X |  | 0
PCT324X |  | 0
PCMF324NX |  | 0
PCMF10825X |  | 0
BFTRC520X |  | 0
BFTRC460X |  | 0
BFTRC780X |  | 0
BFMF520X |  | 0
AVTRC780X |  | 0
AVTRC520X |  | 0
BT324X |  | 0
BT108X |  | 0
Dailies
CS1D1200X | 50 | 0
EQ1D1200X | 2500 | 0
CS1DT400X | 98 | 0
PC1D1200X | 803 | 0
PC1DMF600X | 0 | 0
Sphere
PCC60 | 100 | 0
EP6060X | 64 | 0
Biofinity207X | 475 | 0
F55A60 | 0 | 0
XC60X | 30 | 0
55UVASPHX | 16 | 0
AVAIRA207X | 650 | 0
Canada
Toric & Multifocal
PCT84CAN324X | 4 | 0
PCTCAN324X | 1 | 0
PCMFCAN324NX | 14 | 0
BFTRCCAN780X | 60 | 0
ENTRCCAN780X | 100 | 0
BFMFCAN520X | 125 | 0
Dailies
BIOMEDICS52CAN1200X | 10 | 0
PC1DCAN1080X | 24 | 0
PC1DCAN1200X | 0 | 0
BIOMEDICS1DTCAN400X | 5 | 0
PC1DMFCAN600X | 0 | 0
Sphere
PCCCAN180X | 4 | 0
55SPHCAN186X | 0 | 0
EP60CAN180X | 5 | 0
BIOFINITYCAN207X | 17 | 0
[NAME]
ENC100CAN207X | 30 | 0
Spreadsheet: eric_saibi__9792__020602
Sheet: Coronado 02

Owner Name |  | Salt River Project
Station Name |  | Coronado [NAME]
Unit Name |  | Coronado 02
NERC Region |  | WSCC
State |  | AZ
Fuel Type |  | Coal
Capacity |  | 411 MW
Start Date |  | 2002-02-05 00:00:00
End Date |  | 2002-02-10 00:00:00
Comments |  | Tube Leak
SIC |  | 4911
Plant ID |  | 10106260
Unit ID |  | 1007077
Outage ID |  | 19785
Spreadsheet: 219692d1362884511-sumifs-with-multiple-lookups-with-multiple-results-to-lookup-other-values-testmodel3
Sheet: Totals

 |  | Total Mods
Comp1 | AK |  | Lookup state, see combo, then choose comp that have X in that Mod, add total |  |  |  |  |  |  |  | Combo3 | Comp1 | Comp2 | Mod1 | Mod3 | Mod4
Comp2 | AL |  |  |  |  |  |  |  |  |  | Combo2 | Comp2 | Comp4 | Mod1 | Mod2
[NAME] | AL |  |  |  |  |  |  |  |  |  | Combo1 | Comp1 | [NAME] | Mod2 | Mod3
Comp4 | AZ |  |  |  |  |  |  |  |  |  |  | Comp4 |  | Mod2 | Mod3
Comp4 | AK
Comp5 | CO |  |  |  |  |  |  |  |  |  |  | Comp5 |  | Mod1 | Mod2
Spreadsheet: 731141d1620209082-summing-horizontal-ranges-where-the-criteria-is-in-a-row-test_horizontal_range
Sheet: Sheet1

 | [NAME] | Billy | Catrina | [NAME] | Ethel | Fred | George | Horace
2020-11-01 00:00:00 | 29 | 42 | 47 | 45 | 6 | 11 | 27 | 42
2020-11-02 00:00:00 | 8 | 28 | 23 | 49 | 30 | 6 | 37 | 25
2020-11-03 00:00:00 | 17 | 37 | 1 | 34 | 14 | 44 | 6 | 49
2020-11-04 00:00:00 | 29 | 26 | 26 | 3 | 49 | 11 | 14 | 33 |  |  |  |  |  | 2020-11-01 00:00:00 | 2020-11-02 00:00:00
2020-11-05 00:00:00 | 37 | 42 | 12 | 47 | 4 | 27 | 47 | 27 |  |  |  |  |  | 249 | 206
2020-11-06 00:00:00 | 3 | 15 | 50 | 38 | 42 | 34 | 34 | 27
Spreadsheet: 270183d1381410446-what-lookup-function-should-i-use-tracker-example-pivot
Sheet: PivotReport

Ref | 6063
Name | Date | Sum of Income Amount
Batman Appeal | 2013-02-27 00:00:00 | 100
[NAME] | 2013-02-25 00:00:00 | 20
 | 2013-03-08 00:00:00 | 3000
[NAME] | 2013-02-25 00:00:00 | 20
 | 2013-03-20 00:00:00 | 200
[NAME] | 2013-02-27 00:00:00 | 120
[NAME] | 2013-02-20 00:00:00 | 50
 | 2013-03-04 00:00:00 | 125
Marcus | 2013-02-26 00:00:00 | 15
 | 2013-09-24 00:00:00 | 5000
[NAME] | 2013-02-25 00:00:00 | 20
 | 2013-03-21 00:00:00 | 20
[NAME] | 2013-02-21 00:00:00 | 10
 | 2013-03-06 00:00:00 | 30
[NAME] | 2013-02-20 00:00:00 | 20
 | 2013-03-05 00:00:00 | 25
[NAME] | 2013-02-27 00:00:00 | 50
Superman | 2013-02-27 00:00:00 | 20
Grand Total |  | 8845
Spreadsheet: jeffrey_a_shankman__13915__Family pool
Sheet: Week #13

 |  |  |  |  |  |  |  | = | 1st place
 |  |  |  |  |  |  |  | = | 2nd place
 |  |  |  |  |  |  |  | = | 3rd place
 |  |  |  |  |  |  |  | = | 4th place
 |  | Old Rank | New Rank | Prior Total | New Total | Weekly Total | Lost | PHIL | KC | ST. L | ATL | DET | CHIC | TB | CINCIN | TENN | CLEVE | DENVER | MIAMI | CAR | NO | NE | NYJ | MINN | PITT | INDY | BALT | SD | SEA | AZ | OAK | DALLAS | WASH | BUFF | SF | GB | JACK |  | StL/NYG | StL/MN | NE/NYG | NE/MN |  | TB | SL
3 | Prentice | 12 |  | 845 |  |  |  | 9 |  | 15 |  |  | 11 | 12 |  |  | 6 |  | 2 |  | 8 |  | 7 |  | 10 |  | 4 | 5 |  |  | 14 |  | 1 |  | 13 |  | 3 |  |  |  |  |  | Prentice
4 | [NAME] | 18 |  | 825 |  |  |  |  | 5 | 8 |  | 10 |  | 9 |  | 6 |  |  | 3 |  | 12 |  | 11 |  | 15 |  | 4 | 7 |  |  | 14 |  | 2 |  | 1 | 13 |  |  |  |  |  |  | [NAME]
1 | Eldon | 9 |  | 847 |  |  |  | 4 |  | 14 |  |  | 8 | 9 |  |  | 2 |  | 5 |  | 11 |  | 3 |  | 10 |  | 1 |  | 7 |  | 15 |  | 12 |  | 13 | 6 |  |  |  |  |  |  | Eldon
2 | Cameron&Scott | 6 |  | 865 |  |  |  | 7 |  | 10 |  |  | 13 | 8 |  |  | 2 |  | 5 |  | 12 |  | 1 |  | 9 |  | 6 |  | 3 |  | 15 |  | 11 |  | 14 | 4 |  |  |  |  |  |  | Cameron&Scott
6 | [NAME] | 22 |  | 808 |  |  |  |  | 5 |  | 3 |  | 9 | 10 |  |  | 4 | 2 |  |  | 11 |  | 1 |  | 7 |  | 14 | 12 |  |  | 13 |  | 15 |  | 8 | 6 |  |  |  |  |  |  | [NAME]
 | Bobbi Sue | 2 |  | 889 |  |  |  | 3 |  | 4 |  |  | 5 | 2 |  |  | 10 | 15 |  |  | 6 |  | 9 |  | 8 |  | 7 | 1 |  |  | 13 |  | 11 |  | 12 | 14 |  |  |  |  |  |  | Barrie
 | TOTAL
 | AVERAGE
 | Edge |  |  |  |  |  |  | 1 |  | 15 |  | 9 |  | 2 |  | 12 |  | 14 |  |  | 10 | 6 |  |  | 8 | 3 |  |  | 4 |  | 5 | 11 |  | 7 |  |  | 13
Spreadsheet: 806526d1669366451-power-query-adding-rows-sample
Sheet: Sheet1

 | Year | 21 | 20 | 19
 | Net Sales | 1000 | 800 | 700
 | Cost | 500 | 400 | 300
 | Gross Profit
 | general exp | 50 | 40 | 35
 | Marketing | 50 | 40 | 35
 | others | 50 | 40 | 35
 | Net profit
Spreadsheet: 90354d1290095310-extract-data-to-separate-sheets-based-on-separate-criteria-book3
Sheet: Sheet1

LAST NAME | FIRST NAME | PHONE | CITY | STATE | SHIFT
Dow | [NAME] | [PHONE] | Portsmouth | NH | WD 1 | WD 1_1
Dow | [NAME] | [PHONE] | Portsmouth | NH | WD 1 | WD 1_2
Dow | [NAME] | [PHONE] | Portsmouth | NH | WD 1 | WD 1_3
Dow | [NAME] | [PHONE] | Portsmouth | NH | WD 2 | WD 2_1
Dow | [NAME] | [PHONE] | Portsmouth | NH | WD 1 | WD 1_4
Dow | [NAME] | [PHONE] | Portsmouth | NH | WD 2 | WD 2_2
Dow | [NAME] | [PHONE] | Portsmouth | NH | WD 1 | WD 1_5
Spreadsheet: 42141d1240698187-if-cell-x-0-then-copy-range-of-cells-book1
Sheet: Sheet1

 | products
 | Ref | Qty | Description | Price | Order | Total
 |  | 2.5 | wheat | 25 | 0 | 0
 |  | 7.5 | flour | 63.92 | 0 | 0
 |  | 10 | nuts | 64.16 | 0 | 0
 |  | 25 | raisins | 127.9 | 0 | 0
 |  | 25 | chocolate | 141.75 | 0 | 0
Spreadsheet: f2a02657-813f-4d07-95ab-04472aad2a68
Sheet: 2014-2015

2015-2016 Class Schedule |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | You may select up to three classroom attributes.  Select only course requirements, as the number of available classrooms will be reduced with each attribute selected.
International Journalism
Fall 2015
Subject | Course and Title | Subtitle/Alternate Title | Days | Times | Sec | Part of Term | Credits | Hamline Plan | Instructor(s) | Instructor ID | FT or Adj | [NAME] | Registration Approval Required? | [NAME] | Seats to be Saved | Saved Seats Type | Campus: [NAME], [NAME], Online, Blended |  |  |  | Cross list? SUBJ CRSE SEC | XLST total enrl | Areas of Study | Comments
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Classroom Attribute A | Classroom Attribute B | Classroom Attribute C
Spreadsheet: benjamin_rogers__919__PJM Load Forecast
Sheet: Query Data

PJM Forecasted System Constraints:
 | Updated as of: 3-27-2001  15:55
 | Constrained operations ARE expected in the DPL-South and PL areas on 03/28/01.
 | Constrained operations ARE expected in the DPL-South area on 03/29/01.
 | HLD
 |  |  |  | PJM HOURLY FORECAST LOAD MW
Data updated as of Wed Mar 28 06:57:41 2001
Date         1      2      3      4      5      6      7      8      9      10     11     12
+-----------++-----++-----++-----++-----++-----++-----++-----++-----++-----++-----++-----++-----+
03/28/01 am  27200  26500  26500  26500  27200  29400  33300  35200  34800  34200  33800  33200
pm  32600  32300  31800  31800  32100  33300  35300  35500  34700  33300  31000  28900
03/29/01 am  25500  24700  24500  24600  25300  27000  29900  31700  32600  32600  32500  32300
pm  31900  31500  31500  31600  32300  33400  34700  34600  33800  32200  30000  27600
03/30/01 am  25700  24900  24500  24500  25000  27100  30400  32300  32600  32200  32100  31700
pm  31100  30800  30400  30000  29900  30200  31700  32300  31600  30300  28500  26800
03/31/01 am  22900  22000  21600  21500  21800  22500  23400  24700  26000  26500  26500  26200
pm  25600  24900  24400  24100  24200  24600  26200  27500  26800  25700  24200  22500
04/01/01 am  22300  21500  21500  21000  21000  21400  22000  23400  25100  26100  26500  26400
pm  26100  25500  24900  24700  24900  25700  27400  28300  27800  26800  25200  23500
04/02/01 am  23000  22200  22000  22100  22800  24900  28800  31000  31100  31400  31600  31100
pm  30700  30400  29900  29300  29100  28900  28800  29800  31200  30100  27600  25200
04/03/01 am  23000  22200  22000  22100  22800  24900  28800  31000  31100  31400  31600  31100
pm  30700  30400  29900  29300  29100  28900  28800  29800  31200  30100  27600  25200
04/04/01 am    --     --     --     --     --     --     --     --     --     --     --     --
pm    --     --     --     --     --     --     --     --     --     --     --     --