tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: sally_beck__35536__Energy Ops - PRC Meetings Mid Yr 2001
Sheet: Sheet1

2001-05-31 00:00:00 | 2001-06-04 00:00:00 | 2001-06-05 00:00:00 | 2001-06-06 00:00:00 | 2001-06-08 00:00:00
Global | Gas Logistics | Gas/Power Risk Mgmt | Gas/Power Settlements | ENA/EIM/EGM
 |  |  | Deal Clearing/Volume Mgmt | Final Meeting
Attendees | Attendees | Attendees | Attendees | Attendees
[NAME] | [NAME] | [NAME] | [NAME] | [NAME]
[NAME] | [NAME] | [NAME] | [NAME] | [NAME]
[NAME] | [NAME] | [NAME] | [NAME] | [NAME]
[NAME] | [NAME] | [NAME] | [NAME] | [NAME]
[NAME] | [NAME] | Darron Giron | [NAME] | [NAME]
[NAME] | [NAME] | [NAME] | [NAME] | [NAME]
[NAME] | [NAME] | Casey Evans | [NAME] | [NAME]
[NAME] | [NAME] | [NAME] | [NAME] | Brent Price
[NAME] | [NAME] | [NAME] |  | [NAME]
[NAME] | [NAME] | [NAME] |  | [NAME]
[NAME] | [NAME] |  |  | [NAME]
[NAME] |  |  |  | [NAME]
[NAME] |  |  |  | [NAME]
[NAME] |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
Human Resources | Human Resources | Human Resources | Human Resources | Human Resources
Hector [NAME] | Hector [NAME] | Hector [NAME] | Hector [NAME] | Hector [NAME]
[NAME] | [NAME] | [NAME] | [NAME] | [NAME]
[NAME] | [NAME] | [NAME] | [NAME] | [NAME] (EGM)
 |  |  |  | [NAME] (EIM)
 |  |  |  | [NAME]
 |  | *conference from Portland
17 | 12 | 13 | 11 | 22
Spreadsheet: darrell_schoolcraft__7317__imball0202
Sheet: transcol

 | TransColorado
 | 500632
Day | Measured | Scheduled
1 | 75695 | 78800
2 | 94691 | 93799
3 | 94497 | 93799
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
31
2002-01-31 00:00:00 |  |  | 28675
2002-02-05 00:00:00
CBS Volume
 |  |  | -42160
Spreadsheet: michelle_lokay__26684__tw_priority_rate
Sheet: priority rate table for cap rls

Contract | [NAME] Id | Rate | Modifications as of 11/05/1999 |  |  |  | Update eff 1/1/2000 | Rate as of 1/1/2000 | Update eff 11/1/2000 | New Rate as of 11/1/2000
8255 | GRD | 0.0076 |  |  |  |  | 0.0066
8255 | RES | 0.3168 |  |  |  |  |  |  | 0.3232
8255 | SCS | 0.0686
8255 | TC2 | 0.0051
8255 | TC6 | 0.0007
20715 | RES | 0.1031 |  |  |  |  |  |  | 0.1052
20746 | SCS | 0.0443
20746 | TC2 | 0.0041
20746 | TC6 | 0.0004
20747 | GRD | 0.0076 |  |  |  |  | 0.0066
20747 | RES | 0.2554 |  |  |  |  |  |  | 0.2606
20747 | SCS | 0.0369
20747 | TC2 | 0.0052 |  |  |  |  |  |  | 0.005
20747 | TC6 | 0.0007
20748 | GRD | 0.0047 |  |  |  |  | 0.004
20748 | RES | 0.2554 |  |  |  |  |  |  | 0.2606
20748 | SCS | 0.0369
20748 | TC2 | 0.0052 |  |  |  |  |  |  | 0.005
20748 | TC6 | 0.0007
20755 | GRD | 0.0044
20822 | GRD | 0.0047 |  |  |  |  | 0.004
20822 | RES | 0.1647 |  |  |  |  |  |  | 0.1681
20822 | SCS | 0.0369
20822 | TC2 | 0.0023 |  |  |  |  |  |  | 0.0025
20822 | TC6 | 0.0003
20834 | RES | 0.1031 |  |  |  |  |  |  | 0.1052
20835 | RES | 0.1031 |  |  |  |  |  |  | 0.1052
20841 | GRD | 0.0044
21162 | GRD | 0.0076
21162 | RES | 0.2503
21162 | SCS | 0.0443
21162 | TC2 | 0.0051
21162 | TC6 | 0.0007
21165 | GRD | 0.0076 |  |  |  |  | 0.0066
21165 | RES | 0.2554 |  |  |  |  |  |  | 0.2606
21165 | SCS | 0.0443
21165 | TC2 | 0.005 |  |  |  |  |  |  | 0.0052
21165 | TC6 | 0.0007
21172 | RES | 0.101
21175 | RES | 0.1031 |  |  |  |  |  |  | 0.1052
23795 | GRD | 0.0044
24360 | TC2 | 0.0034
25923 | RES | 0.1031 |  |  |  |  |  |  | 0.1052
25924 | RES | 0.2554 |  |  |  |  |  |  | 0.2606
25924 | SCS | 0.0443
25924 | TC2 | 0.0053
25924 | TC6 | 0.0007
26371 | RES | 0.1031 |  |  |  |  |  |  | 0.1052
26372 | GRD | 0.0076 |  |  |  |  | 0.0066
26372 | RES | 0.2554 |  |  |  |  |  |  | 0.2606
26372 | SCS | 0.0443
26372 | TC2 | 0.0051
26372 | TC6 | 0.0007
26427 | RES | 0.101
26428 | RES | 0.2503
26428 | SCS | 0.0443
26428 | TC2 | 0.0046
26428 | TC6 | 0.0006
26429 | RES | 0.101
26430 | RES | 0.2503
26430 | SCS | 0.0443
26430 | TC2 | 0.0046
26430 | TC6 | 0.0006
26431 | RES | 0.2503
26431 | SCS | 0.0443
26431 | TC2 | 0.0046
26431 | TC6 | 0.0006
26432 | RES | 0.101
26677 | RES | 0.1031 |  |  |  |  |  |  | 0.1052
26678 | GRD | 0.0076 |  |  |  |  | 0.0066
26678 | RES | 0.2554 |  |  |  |  |  |  | 0.2606
26678 | SCS | 0.0443
26678 | TC2 | 0.0051 |  |  |  |  |  |  | 0.004
26678 | TC6 | 0.0007 |  |  |  |  |  |  | 0.0005
Spreadsheet: 741424d1627036428-trying-to-achieve-team-a-vs-team-b-scores-team-a-vs-team-b
Sheet: Individual team info

Galway | Vs | Limerick
Home Team |  | Away Team
Date | Galway | limerick
 |  |  |  |  | The current result for this game is incorrect as it has never been played
Spreadsheet: 202720d1356710064-auto-update-data-provider
Sheet: a

Monday:
Time |  |  |  | Class
Student
Location
Provider | 1 |  |  |  |  | Days | Duration | Provider
Tuesday:
Time |  |  |  | Class
Student
Location
Provider |  |  |  |  |  | Days | Duration | Provider
etc.
Spreadsheet: 691653d1597817853-how-to-auto-extract-data-by-person-name-and-auto-generate-save-in-individual-file-example
Sheet: StepB

 | Person | ID | Name | Cusotomer | Invoice No. | Invoice Date | Currency | Amount | VAT | Total
1 | [NAME] | 1234 | ABC Project | ABC | 123 | 2020-08-19 00:00:00 | USD | 100
2 | [NAME] | 4321 | JKC Project | JKC | 124 | 2020-08-19 00:00:00 | USD | 200
3 | [NAME] | 9877 | KKP Porject | KKP | 125 | 2020-08-19 00:00:00 | USD | 300
4 | [NAME] | 4689 | KKP Porject | KKP | 126 | 2020-08-19 00:00:00 | USD | 400
5 | [NAME] | 2937 | ABC Project | ABC | 127 | 2020-08-19 00:00:00 | USD | 500
6 | [NAME] | 3749 | ABC Project | ABC | 128 | 2020-08-19 00:00:00 | USD | 100
7 | [NAME] | 4563 | 123 Project | 123 | 129 | 2020-08-19 00:00:00 | USD | 110
8 | [NAME] | 3329 | ABS Project | ABS | 130 | 2020-08-19 00:00:00 | USD | 120
9
10
11
12
13
14
15
16
17
18
19
20
Spreadsheet: lisa_gang__22387__Elec Power Cost Enron Contract
Sheet: Sheet1

Year | Month | Enron Bill | Enron | PG&E Meter | PG&E Meter | Enron |  | Total kWh | [NAME] | Enron | PG&E
 |  | Total kWh | $/kWh | 2001 kWh | 2000 kWh | Invoice |  | Prior Yr. | Produced | kWh/Ton | kWh/Ton
2001 | Jan |  |  | 9652668 | 17301396 |  |  |  | 90088
2001 | Feb |  |  | 14641356 | 6125364 |  |  |  | 113690
2001 | March |  |  | 14051724 | 16665228 |  |  |  | 70483
2001 | April |  |  | 19538760 | 19648812 |  |  |  | 149997
2001 | May |  |  | 16937628 | 18325272 |  |  |  | 131585
2001 | June |  |  | 17910024 | 18160764 |  |  |  | 169369
2001 | July |  |  | 17885844 | 20071788 |  |  |  | 125506
2001 | Aug |  |  | 19609332 | 19221024 |  |  |  | 140401
2001 | Sept |  |  | 17064564 | 18910824 |  |  |  | 162227
2001 | Oct |  |  | 16726452 | 19546584 |  |  |  | 115694
 |  |  |  |  | PG&E Meter
 |  |  |  |  | $/kWh
2001 | Nov |  |  | 18024144 |  | 870615 |  | 19630848 | 133588
2001 | Dec |  |  | 10501488 |  | 636296.73 |  | 16393956 | 99309
2002 | January | 16281000 |  | 4847292 |  | 703992.92 |  | 9652668 | 38055
2002 | February | 6705000 |  | 15726720 |  | 289944.96 |  | 14641356 | 141080
2002 | March | 16905000 |  |  |  | 730968.89 |  | 14051724 | 145502
2002 | April |  |  |  |  |  |  | 19538760
2002 | May |  |  |  |  |  |  | 16937628
2002 | June |  |  |  |  |  |  | 17910024
2002 | July |  |  |  |  |  |  | 17885844
2002 | August |  |  |  |  |  |  | 19609332
2002 | September |  |  |  |  |  |  | 17064564
2002 | October |  |  |  |  |  |  | 16726452
2002 | November
2002 | December
 |  |  |  |  |  |  |  | 0.04903
Year | Month | Enron Bill | Enron | PG&E Meter | Enron Invoice $ | Enron | Amt Paid | True Up Est | [NAME] | Enron | PG&E
 |  | Total kWh | $/kWh | 2001 kWh | / Est kWh | Invoice | to Enron | $0.0490 / kWh | Produced | kWh/Ton | kWh/Ton
2001 | Nov |  |  | 18024144 |  | 870615 | 870615 |  | 133588
2001 | Dec |  |  | 10501488 |  | 636296.73 | 636296.73 |  | 99309
2002 | January | 16281000 |  | 4847292 |  | 703992.92 | 500000 |  | 38055
2002 | February | 6705000 |  | 15726720 |  | 289944.96 | 494000 |  | 141080
2002 | March | 16905000 |  |  |  | 730968.89 | 740000 |  | 145502 |  | 125
2002 | April
2002 | May
2002 | June |  |  | Estimates
2002 | July
2002 | August |  |  |  |  |  |  | Includes ISO Charges
2002 | September |  |  |  |  |  |  | with
2002 | October |  |  |  |  |  |  | Quarterly True UP
2002 | November
2002 | December
Spreadsheet: 373968d1422616447-formulla-for-next-day-auto-change-the-opening-cash-balance-expanditure-30-1-15
Sheet: Expenditure

 | EXPENDITURE
 | Account & Sataement
 | Opening balance  at starting | 9098
 | Bank Deposit
 | Cash In Shop
 | [NAME]
 | Today' sOp. Balance
 | Dated | Bank Deposit | Cash In Shop | Patrol | Mobile / Phone | Loan | Tea | Shop Rent | Elactercity Bill | Gas | Food / Vagitables | Medical | Transpor Charges | Adjustment | Maintenance | Bittu Personal | Neelu Personal | Miscellaneous | Notes
 | 2015-01-01 00:00:00 |  | 8000 | 100 |  |  | 40 | 950
 | 2015-01-02 00:00:00 | 10000 | 300 |  |  |  | 50 | 4700
 | 2015-01-03 00:00:00 |  | 2600 |  |  |  | 50 | 30 |  |  |  |  |  |  |  | 500
 | 2015-01-04 00:00:00 |  | 500
 | 2015-01-05 00:00:00 |  | 1450 |  |  |  | 40 | 550
 | 2015-01-06 00:00:00 |  | 2250 | 100 |  |  | 40 | 100
 | 2015-01-07 00:00:00 |  | 550 |  |  |  | 40 | 200
 | 2015-01-08 00:00:00 |  | 450 | 100 |  |  |  | 270
 | 2015-01-09 00:00:00 |  | 850 |  |  |  | 60 | 1390
 | 2015-01-10 00:00:00 |  | 25500 |  |  |  |  | 185 |  |  |  |  |  |  |  | 270
 | 2015-01-12 00:00:00 | 30000 | 3000 | 100 |  |  |  |  |  |  |  |  |  |  |  |  | 1200
 | 2015-01-13 00:00:00 |  | 6900 |  |  |  |  | 25
 | 2015-01-14 00:00:00 |  |  |  |  |  | 25 | 200
 | 2015-01-15 00:00:00 |  | 300 | 200 |  |  | 60 | 150
 | 2015-01-16 00:00:00 |  | 11100 |  |  |  | 48 | 2500 |  |  |  |  |  |  |  | 520
 | 2015-01-17 00:00:00 |  |  |  |  |  | 40
 | 2015-01-18 00:00:00 |  | 500
 | 2015-01-19 00:00:00 | 11000 |  | 200 |  | 3900 | 40 | 2240
 | 2015-01-20 00:00:00 |  |  |  |  |  | 30 | 640
 | 2015-01-21 00:00:00 |  |  |  |  |  | 50 | 120
 | 2015-01-22 00:00:00 |  | 200 |  |  |  | 40
 | 2015-01-23 00:00:00 |  | 37650 | 200 |  |  | 30 | 100
 | 2015-01-24 00:00:00
Spreadsheet: 544252d1508833807-help-trying-to-link-values-from-one-workbook-to-another-formulas-for-dimensions-of-shited-spur-gears-samp
Sheet: Gear 2000 - Gear 2002

POSITIVE SHIFTED SPUR GEAR |  |  |  |  |  | MAX ADDENDUM |  | MIN # OF TEETH
SYMBOL | TO FIND | FORMULA | EXAMPLE |  |  | HA1 | HA2 | Z1 | [NAME]
 |  |  | PINION | GEAR
M | MODULE |  | 3.75
α | PRESSURE ANGLE |  | 20
Z1 , [NAME] | NUMBER OF TEETH
X1 , X2 | COEFFICIENT OF PROFILE SHIFT |  | 0.249 | 0.074
Inv αW | INVOLUTE FUNCTION αw | 2 TAN ( α ) [ ( x1 + x2 ) / ( z1 + z2 ) ] + INV ( α )
αw | WORKING PRESSURE ANGLE | [NAME] ( INV αw )        (ITERATIVE 100)
Y | CENTER DISTANCE INCREMENT FACTOR | [ ( Z1 + Z2 ) / 2 ] * [ ( COS ( α ) / COS ( αw ) ) - 1 ]
AX | CENTER DISTANCE | [ ( ( Z1 + Z2 ) / 2 ) + Y ] * M
DP | PITCH DIAMETER | Z * M
DB | BASE DIAMETER | Dp  * COS ( α )
DW | WORKING PITCH DIAMETER | DB / COS ( αw )
HA1 | ADDENDUM | ( 1 + Y - X2 ) * M |  |  |  | MEASURED VALUES
HA2 |  | ( 1 + Y - X1 ) * M
HWA | WHOLE DEPTH | [ 2.25 + Y - ( X1 + X2 ) ] * M |  |  |  | DA | ΔDA | DF | DFΔ
DA | OUTSIDE DIAMETER | DP + ( 2 * HA ) |  |  |  | 193.125 |  | 176.25
DF | ROOT DIAMETER | DA - ( 2 * HWA ) |  |  |  | 199.25 |  | 182.25
Adjusted Center Distance Calculations
AA | ADJUSTED CENTER DISTANCE | ADJUSTED TO 0.50MM INCREMENT
[NAME] | ADJUSTED CENTER DISTANCE INCREMENT FACTOR | ( AA / M ) - [ ( Z1 + Z2 ) / 2 ]
αWA | ADJUSTED WORKING PRESSURE ANGLE | cos -1 [ ( ( Z1 + Z2 ) cos ( α ) ) / ( ( 2 * YA ) + [NAME] ) ]
XA1 + XA2 | ADJUSTED COEFFICIENT OF PROFILE SHIFT | [ ( Z1 + Z2 ) * ( INV ( αwa ) - INV ( α ) ) ] / ( 2 TAN ( α ) )
Δ XAA | COEFFICIENT OF PROFILE SHIFT FACTOR | (XA1 + XA2) / (X1 + X2)
XA1, XA2 | ADJUSTED COEFFICIENT OF PROFILE SHIFT | XAA * X(1,2)
DB | ADJUSTED BASE DIAMETER | Dp  * COS ( αWA )
DAWP | ADJUSTED WORKING PITCH DIAMETER | DB / COS ( αWA )
HAA1 | ADJUSTED ADDENDUM | ( 1 + YA - XA2 ) * M
HAA2 |  | ( 1 + YA - XA1 ) * M
HWAA | ADJUSTED WHOLE DEPTH | [ 2.25 + YA - ( XA1 + XA2 ) ] * M
DAA | ADJUSTED OUTSIDE DIAMETER | DAWP + ( 2 * HAA )
DAF | ADJUSTED ROOT DIAMETER | DAA - ( 2 * HWAA )
Spreadsheet: 837140d1689876186-indirect-a1-a5-and-a1-to-spill-a1-from-other-sheets-doesnt-work-how-could-i-do-it-example-2
Sheet: DBParis

Shop | N° Client | Date Liv. | N° Cde | N° B.L | City | Adress | Quantity
1 |  | 2022-02-01 00:00:00 | 1 | 1 | XXXX |  | 1
1 | 1 | 2022-02-01 00:00:00 | 2 | 2 | XXXX | 75000 | 3
1 | 2 | 2022-02-01 00:00:00 | 3 | 3 | XXXX | 76000 | 8
1 | 1 | 2022-02-01 00:00:00 | 4 | 4 | XXXX | 76000 | 6
1 | 2 | 2022-02-01 00:00:00 | 5 | 5 | XXXX | 77000 | 1
1 | 1 | 2022-02-01 00:00:00 | 6 | 6 | XXXX | 77000 | 6
1 | 2 | 2022-02-01 00:00:00 | 7 | 7 | XXXX | 78000 | 10
1 | 1 | 2022-02-01 00:00:00 | 0 | 8 | XXXX | 78000 | 5
1 | 2 | 2022-02-01 00:00:00 | 9 | 9 | XXXX | 79000 | 1
1 | 1 | 2022-02-01 00:00:00 | 10 | 10 | XXXX | 79000 | 1
1 | 2 | 2022-02-01 00:00:00 | 11 | 11 | XXXX | 80000 | 0
1 | 1 | 2022-02-01 00:00:00 | 0 | 12 | XXXX | 80000 | 0
1 | 2 | 2022-02-01 00:00:00 | 13 | 13 | XXXX | 81000 | 0
1 | 1 | 2022-02-01 00:00:00 | 14 | 14 | XXXX | 81000 | 1
1 | 2 | 2022-02-01 00:00:00 | 15 | 15 | XXXX | 82000 | 0
1 | 1 | 2022-02-01 00:00:00 | 16 | 16 | XXXX | 82000 | 0
1 | 2 | 2022-02-01 00:00:00 | 17 | 17 | XXXX | 83000 | 12
1 | 1 | 2022-02-02 00:00:00 | 0 | 18 | XXXX | 83000 | 3
1 | 2 | 2022-02-02 00:00:00 | 19 | 19 | XXXX | 84000 | 12
1 | 1 | 2022-02-02 00:00:00 | 20 | 20 | XXXX | 84000 | 0
1 | 2 | 2022-02-02 00:00:00 | 21 | 21 | XXXX | 85000 | 8
1 | 1 | 2022-02-02 00:00:00 | 22 | 22 | XXXX | 85000 | 1
1 | 2 | 2022-02-02 00:00:00 | 23 | 23 | XXXX | 86000 | 1
1 | 1 | 2022-02-02 00:00:00 | 24 | 24 | XXXX | 86000 | 2
1 | 2 | 2022-02-02 00:00:00 | 0 | 25 | XXXX | 87000 | 1
1 | 1 | 2022-02-02 00:00:00 | 0 | 26 | XXXX | 87000 | 10
1 | 2 | 2022-02-02 00:00:00 | 27 | 27 | XXXX | 88000 | 2
1 | 1 | 2022-02-02 00:00:00 | 28 | 28 | XXXX | 88000 | 0
1 | 2 | 2022-02-02 00:00:00 | 29 | 29 | XXXX | 89000 | 0
1 | 1 | 2022-02-02 00:00:00 | 30 | 30 | XXXX | 89000 | 0
1 | 2 | 2022-02-02 00:00:00 | 31 | 31 | XXXX | 90000 | 13
1 | 1 | 2022-02-02 00:00:00 | 32 | 32 | XXXX | 90000 | 4
1 | 2 | 2022-02-02 00:00:00 | 33 | 33 | XXXX | 91000 | 3
1 | 1 | 2022-02-03 00:00:00 | 34 | 34 | XXXX | 91000 | 1
1 | 2 | 2022-02-03 00:00:00 | 0 | 35 | XXXX | 92000 | 0
1 | 1 | 2022-02-03 00:00:00 | 36 | 36 | XXXX | 92000 | 1
1 | 2 | 2022-02-03 00:00:00 | 37 | 37 | XXXX | 93000 | 1
1 | 1 | 2022-02-03 00:00:00 | 38 | 38 | XXXX | 93000 | 24
1 | 2 | 2022-02-03 00:00:00 | 39 | 39 | XXXX | 94000 | 7
1 | 1 | 2022-02-03 00:00:00 | 40 | 40 | XXXX | 94000 | 15
1 | 2 | 2022-02-03 00:00:00 | 41 | 41 | XXXX | 95000 | 5
1 | 1 | 2022-02-03 00:00:00 | 42 | 42 | XXXX | 95000 | 5
1 | 2 | 2022-02-03 00:00:00 | 43 | 43 | XXXX | 96000 | 3
1 | 1 | 2022-02-03 00:00:00 | 44 | 44 | XXXX | 96000 | 0
1 | 2 | 2022-02-03 00:00:00 | 45 | 45 | XXXX | 97000 | 0
1 | 1 | 2022-02-03 00:00:00 | 46 | 46 | XXXX | 97000 | 2
1 | 2 | 2022-02-03 00:00:00 | 47 | 47 | XXXX | 98000 | 1
1 | 1 | 2022-02-03 00:00:00 | 48 | 48 | XXXX | 98000 | 7
1 | 2 | 2022-02-03 00:00:00 | 49 | 49 | XXXX | 99000 | 2
1 | 1 | 2022-02-03 00:00:00 | 50 | 50 | XXXX | 99000 | 9
Spreadsheet: 680057d1590761429-consolidate-information-and-return-a-value-with-max-results-in-the-row-return-value-in-a-row-1-
Sheet: Sheet1

 | name1 |  | 2019-01-01 00:00:00 | name1
 | [NAME] |  | 2019-01-02 00:00:00 | [NAME]
 | name3 | 1 | 2019-01-03 00:00:00 | name3
 | name4 | 1 | 2019-01-04 00:00:00 | name4 |  | Should be 1 bacause  C9 is empty.
 | name5 | 1 | 2019-01-05 00:00:00 | name5
 | [NAME] |  | 2019-01-06 00:00:00
 | name3 |  | 2019-01-07 00:00:00
 | name4 |  | 2019-01-08 00:00:00
 | name5 |  | 2019-01-09 00:00:00
 | name1 | 1 | 2019-01-10 00:00:00
 | [NAME] | 1 | 2019-01-11 00:00:00
 | name3 |  | 2019-01-12 00:00:00
 | name4 | 1 | 2019-01-13 00:00:00
 | name5 |  | 2019-01-14 00:00:00
 | [NAME] | 1 | 2019-01-15 00:00:00
Spreadsheet: 594187d1539615439-expanding-pie-chart-section-sample
Sheet: Dashboard

 | NOTE: RANDOMLY GENERATED SAMPLE DATA USED AS SIMULATED TEMPLATE |  |  |  |  |  |  |  |  |  | Filter Count by Quarter | Green | Yellow | Red |  |  |  |  |  | Filter Count by Quarter | Green | Yellow | Red
 |  | Q1 |  | Q2 |  | Q3 |  | Q4 |  |  | Q1 |  |  |  |  |  |  |  |  | Q1
 | Colour | Attitude Drug 1 Count | Attitude Drug 12Count | Attitude Drug 1 Count | Attitude Drug 12Count | Attitude Drug 1 Count | Attitude Drug 12Count | Attitude Drug 1 Count | Attitude Drug 12Count
 | Green | 55 | 44 | 67 | 52 | 50 | 65 | 77 | 87
 | Yellow | 66 | 66 | 60 | 77 | 87 | 73 | 68 | 60
 | Red | 79 | 91 | 73 | 71 | 63 | 62 | 55 | 53
 | Attitude Drug 1 Count |  |  |  | Attitude Drug 12Count
 |  | Green | Yellow | Red |  | Green | Yellow | Red
 | Q1 | 55 | 66 | 79 | Q1 | 44 | 66 | 91
 | Q2 | 67 | 60 | 73 | Q2 | 52 | 77 | 71
 | Q3 | 50 | 87 | 63 | Q3 | 65 | 73 | 62
 | Q4 | 77 | 68 | 55 | Q4 | 87 | 60 | 53
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Filter by Region
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | East
 | Lets say the red part of the pie is chosen when clicked on - it would display that table below (table extrapolated from 'List' Tab
 | Last Name | First and Middle Name | Rank | Region | Share 1 | Share 2 | Attitude Drug 1 | Attitude Drug 2 | Tactic
 | Last Name 8 | First Name 8 | 8 | East | 100 | 0 | Red | Green | Tactic 8
 | Last Name 11 | First Name 11 | 11 | East | 50 | 50 | Red | Red | Tactic 11
 | Last Name 13 | First Name 13 | 13 | East | 50 | 50 | Red | Red | Tactic 13
 | Last Name 15 | First Name 15 | 15 | East | 30 | 70 | Red | Green | Tactic 15
 | Last Name 21 | First Name 21 | 21 | South | 65 | 35 | Red | Green | Tactic 21
 | Last Name 24 | First Name 24 | 24 | South | 40 | 60 | Red | Red | Tactic 9
 | Last Name 25 | First Name 25 | 25 | South | 52 | 48 | Red | Red | Tactic 10
 | Last Name 26 | First Name 26 | 26 | South | 55 | 45 | Red | Red | Tactic 11
 | Last Name 28 | First Name 28 | 28 | West | 37 | 63 | Red | Green | Tactic 13
 | Last Name 34 | First Name 34 | 34 | West | 52 | 48 | Red | Green | Tactic 11
 | Last Name 37 | First Name 37 | 37 | West | 25 | 75 | Red | Red | Tactic 14
 | Last Name 38 | First Name 38 | 38 | West | 0 | 0 | Red | Green | Tactic 1
 | Last Name 39 | First Name 39 | 39 | West | 55 | 45 | Red | Red | Tactic 2
 | Last Name 41 | First Name 41 | 41 | West | 67 | 33 | Red | Green | Tactic 4
Spreadsheet: 100813d1299055548-count-unique-items-within-a-choice-example1
Sheet: Sheet1

Number | Company
46 | A
47 | A
48 | B
61 | A
62 | A
63 | A
64 | A
65 | A
66 | A
67 | A
68 | A
69 | A
83 | B
84 | A
85 | A
86 | A
103 | B
104 | A
105 | A
107 | A
108 | A
109 | A
110 | A
118 | C
122 | A
129 | A
156 | B
157 | A
158 | A
159 | A
168 | A
169 | A
170 | A
172 | A
175 | C
Spreadsheet: hunter_shively__12736__EnovateDPR0115
Sheet: 5 Day Roll

ENRON CAPITAL AND TRADE RESOURCES
 |  | DO NOT TOUCH!! | ONLY RUN BEFORE YOU LINK ANY NEW ROLLS!!
Commodity | 5 Day Rolling Total | Current Day | Current Day-1 | Current Day-2 | Current Day-3 | Current Day-4
ENA Gas Trading
Short Term Gas |  |  | -50.20831987300177 | -168.1440735500014 | 87.82937327400799 | 158.7207389439941
 |  | 13 | 12 | 11 | 10 | 7 | 6
 |  | 17 | 84 | 12 | -54 | 19 | -53
Spreadsheet: 68f5f87c-07d2-4149-8cce-c33103325178
Sheet: Sheet1

Initative and Referendum Basic Requirements | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Type of Measure | Initial Signatures | Review Period | Supplemental Signature Process  (after Attorney General verification) | Additional Information
Constitutional Amendment | At least 1,000 signatures of registered voters  Materials submitted to the Attorney General | 10 calendar days | 10% of votes cast for governor in previous election (2010).   Currently, a statewide total of 385,253 signatures. (This requirement will fluctuate following each gubernatorial election.)  [NAME] must be obtained from at least 44 of Ohio's 88 counties.   From each of the 44 counties, signatures must equal at least 5% of votes cast for governor in that county in previous election. | www.sos.state.oh.us / Legislation and Ballot Issues/ Putting an Issue on the Ballot / Constitutional Amendment
[NAME] (any law passed by voters is not subject to referendum) | At least 1,000 signatures of registered voters   Original materials submitted to the Secretary of State.   Copy of law subject to referendum and copy of summary of law submitted to the Attorney General | 10 business days | 6% of votes cast for governor in previous election (2010)  Currently, a statewide total of 231,150 signatures. (This requirement will fluctuate following each gubernatorial election.)  [NAME] must be obtained from at least 44 of Ohio's 88 counties.   From each of the 44 counties, signatures must equal at least 3% of votes cast for governor in that county in previous election. | www.sos.state.oh.us / Legislation and Ballot Issues / Putting an Issue on the Ballot / Referendum
[NAME] | At least 1,000 signatures of registered voters  Materials submitted to the Attorney General | 10 calendar days | 3% of votes cast for governor in previous election (2010).   Currently, a statewide total of 115,570. (This requirement will fluctuate following each gubernatorial election.)  [NAME] must be obtained from at least 44 of Ohio's 88 counties.   From each of the 44 counties, signatures must equal at least 1.5% of votes cast for governor in that county in previous election. | www.sos.state.oh.us / Legislation and Ballot Issues / Putting an Issue on the Ballot / Initiated Statute
Nothing in this chart should be construed as legal advice and should not be relied upon as a sole source of information.  Petitioners are encouraged to consult legal counsel
Spreadsheet: 861704d1709566792-pulling-data-from-multiple-excel-sheet-payroll-test
Sheet: FMB

Narrative | Journal | Amount | Nominal Code | Cost Centre | Dept.
Net Wages | Cr | 702.10 | 2220
National Insurance | Cr | 915.59 | 2210
PAYE | Cr | 480.05 | 2210
Pension | Cr | 26.66 | 2230
Employers Pension | Dr | 7.16 | 6023
Paid Absence | Dr | 60.44 | 6900
Payments | Dr | 833.17 | 6001
Employers NIC | Dr | 929.21 | 6020
Attachments | Cr | 6.80 | 2240
GMB | Cr | 34.52 | 2250
Payments | Dr | 15.38 | 6004
Payments | Dr | 357.14 | 6008
Annual Leave | Dr | 40.10 | 6015
Payments | Dr | 255.12 | 6009
Student Loan | Cr | 38.00 | 2210
Deductions | Cr | 25.00 | 6025
Payments | Dr | 562.97 | 6003
Payments | Dr | 5.52 | 6005
Payments | Dr | 42.94 | 6002
Payments | Dr | 77.71 | 6006
SSP | Dr | 415.72 | 6021
SMP | Dr | 1601.60 | 6022
Total SMP Recovered | Dr | 1473.48 | 2210
SMP Recovered | Cr | 1473.48 | 6022
Payments | Dr | 62.00 | 6007
Payments | Dr | 62.02 | 6010
Advance Deduction | Cr | 59.48 | 2220
Spreadsheet: 587721d1535209534-data-lookup-across-multiple-sheets-using-data-validation-copy-of-sample-jmcgurl-
Sheet: Master

 | Select a Date | 2018-02-16 00:00:00
 | Select Geo | USA |  |  |  |  | [NAME]
 | Receiving |  |  | [NAME] |  |  | Crash Rate
 | Cartons Received |  |  | [NAME] |  |  | Loads
 | % to LW |  |  | % to LW |  |  | Crashes
 | Average 12 week cartons |  |  | 12 week average |  |  | Crash Rate
 | This week vs 12 Week % |  |  |  |  |  | 6 wk [NAME]
 | Item Level Received Cartons |  |  | OOS Audits
 | Item Level Receiving Percentage
 |  |  |  | [NAME]
 | Errors |  |  | % to LW
 | [NAME] |  |  | 12 week average
 | [NAME] not on File
 | Error % |  |  | [NAME]
 |  |  |  | [NAME]
 | Logins |  |  | % to LW
 |  |  |  | 12 week average
 | [NAME]
 | % to LW
 | 12 week average (unique) |  |  | Units Refilled
 | Total Logins
 | % to LW |  |  | Total Units Refilled
 | 12 week averge (total) |  |  | % to LW
 |  |  |  | Average 12 week
 |  |  |  | This week vs 12 Week %
Spreadsheet: 228580d1366148149-need-to-create-spreadsheet-for-asset-management-mobile-inventory
Sheet: Hardware

Name | Type | Make | Model | S/N
[NAME] | GPS | Magellan | RoadMate 2230T-LM
LAP-1 | Laptop | Dell | Inspiron 1100
LAP-2 | Laptop | Dell | Latitude D520
[NAME] | Laptop | Dell | Vostro 1510
LAP-4 | Laptop | Dell | Vostro 1520
LAP-5 | Laptop | Dell | Vostro 1520
[NAME] | Laptop
LAP-7 | Laptop | Dell | [NAME] 10
LAP-8 | Laptop | Dell | [NAME] 10
PROJ-1 | Projector | Epson | EMP-S4
PROJ-2 | Projector