tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: kevin_presto__19943__Genco O&M-New Albany-1-19-01
Sheet: comparison to Aug CE

GENCO
Comparison to August CE
2001 BUDGET
 |  | O&M Expenses |  |  |  | Owner's Expenses |  |  |  | Other |  |  |  | Total
 |  | 01 Budget | Aug 00 CE | [NAME] |  | 01 Budget | Aug 00 CE | [NAME] |  | 01 Budget | Aug 00 CE | [NAME] |  | 01 Budget | Aug 00 CE | [NAME]
Brownsville |  | 0 | 0 |  |  | 0 | 0 | 0 |  | 0 | 0
Caledonia |  | 0 | 0 |  |  | 0 | 0 | 0 |  | 0 | 0
New Albany
[NAME] |  | 0 | 0 |  |  | 0 | 0 | 0 |  | 0 | 0
Wheatland |  | 0 | 0 |  |  | 0 | 0 | 0 |  | 0 | 0
[NAME] |  | 0 | 0 |  |  | 0 | 0 | 0 |  | 0 | 0
Total Genco |  |  |  |  | A |  |  |  | B |  |  |  | C
Note:  2000 Peakers' Aug CE was grossed up to 1yr
 | [NAME]:
 | A | Primarily due to lower major maintenance.
 | B | Primarily due to budgeted O&M for the interconnect, which was $0 in 2000 offset by spare parts that were expensed in 2000.
 | C | Primarily due to higher Capital Charge credit which is a result of higher forecasted Revenue/Spread Value than in 00.
Spreadsheet: 273430d1382711022-sum-multiple-columns-with-veritical-and-horizontal-match-index-sumifs
Sheet: SOS DASH BOARD

 |  |  | DEC | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | 2013 |  |  |  |  |  |  |  | ^100964-C
FORECAST |  |  | 82.75 | 169.75 | 250.25 | 336.5 | 175.75 | 491.25 | 137.25 | 711.5 | 563.75 | 477.75 | 251.75 | 95 | 3743.25
R/M NEED/ ORDERS |  |  |  | #REF! | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
QTY REC 2013 |  |  | 0 | 0 | 0 | 0 | 1000 | 963 | 0 | 0 | 0 | 500 | 0 | 0 | 2463
QTY REC 2012 |  |  | 0 | 0 | 750 | 1000 | 1500 | 750 | 750 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 882179d1730424076-get-value-from-different-workbook-based-on-multiple-criteria-and-based-on-the-latest-date-source-workbook-example-1-
Sheet: Source workbook

 |  | Machine | ID number | Others | Others2 | Cyceltime
 |  | Example1 | 12345
 |  | Example2 | 67891
 |  | Example3 | 65743
 |  | Example4 | 97745
 |  | I need the cyceltime "column G" to be dynamic updated.
 |  | Based on the latest date from the "input workbook."
 |  | if the criterias matches from column C and D.
Spreadsheet: 882895d1731364033-duplicate-incident-numbers-in-two-rows-combines-rows
Sheet: Sheet1

Incident number | OFFENSE | Offense1 [NAME] | Domestic Violence | Incident Status Description | Incident Occurred | Incident Location | ZipCode |  | Incident number | OFFENSE | Offense1 [NAME] | Domestic Violence | Incident Status Description | Incident Occurred | Incident Location | ZipCode
20200346523 |  |  |  | UNFOUNDED | 05/16/2020  12:00 | 179 PINEAPPLE LN | 37013 |  | 20200346523 | 740 | Matter of Record | Y | UNFOUNDED | 05/16/2020  12:00 | 179 PINEAPPLE LN | 37013
20200346523 | 740 | Matter of Record | Y |  |  |  |  |  | 20200346523
20200346524 |  |  |  | UNFOUNDED | 05/16/2020  13:01 | 913 ALGONQUIN CT | 37013 |  | 20200346524 | 740 | Matter of Record | N | UNFOUNDED | 05/16/2020  13:01 | 913 ALGONQUIN CT | 37013
20200346524 | 740 | Matter of Record | N |  |  |  |  |  | 20200346524
20200346823 |  |  |  | UNFOUNDED | 05/16/2020  16:27 | 4896 PACKARD DR | 37013 |  | 20200346823 | 690 | Death - Suicide | N | UNFOUNDED | 05/16/2020  16:27 | 4896 PACKARD DR | 37013
20200346823 | 690 | Death - Suicide | N |  |  |  |  |  | 20200346823
20200347412 |  |  |  | OPEN | 05/16/2020  22:20 | COLEMONT DR |  |  | 20200347412 | 23F | Theft From Motor Vehicle | N | OPEN | 05/16/2020  22:20 | COLEMONT DR
20200347412 | 23F | Theft From Motor Vehicle | N |  |  |  |  |  | 20200347412
20200348257 |  |  |  | UNFOUNDED | 05/17/2020  09:57 | 127 BAKERTOWN RD | 37211 |  | 20200348257 | 685 | Death - Natural | N | UNFOUNDED | 05/17/2020  09:57 | 127 BAKERTOWN RD | 37211
20200348257 | 685 | Death - Natural | N |  |  |  |  |  | 20200348257
20200348509 |  |  |  | OPEN | 05/17/2020  07:00 | BAKERTOWN RD |  |  | 20200348509 | 23H | All Other Larceny | N | OPEN | 05/17/2020  07:00 | BAKERTOWN RD
20200348509 | 23H | All Other Larceny | N |  |  |  |  |  | 20200348509
20200348778 |  |  |  | REFUSED TO COOPERATE | 05/16/2020  23:00 | 4900 CIMARRON WAY | 37013 |  | 20200348778 | 240 | Motor Vehicle Theft | N | REFUSED TO COOPERATE | 05/16/2020  23:00 | 4900 CIMARRON WAY | 37013
20200348778 | 240 | Motor Vehicle Theft | N |  |  |  |  |  | 20200348778
20200349525 |  |  |  | UNFOUNDED | 05/17/2020  22:21 | 227 LEESHAN CT | 37013 |  | 20200349525 | 740 | Matter of Record | N | UNFOUNDED | 05/17/2020  22:21 | 227 LEESHAN CT | 37013
20200349525 | 740 | Matter of Record | N |  |  |  |  |  | 20200349525
Spreadsheet: 857f150a-824d-4e68-a8e0-0e008433a568
Sheet: Sheet1

Table 4--Cottonseed:  U.S. supply and disappearance | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 | Supply |  |  |  |  | Disappearance
Year beginning | Beginning |  |  |  |  |  |  |  |  | Ending
August 1 | stocks | Production | Imports | Total |  | Crush | Exports | Other | Total | stocks
 | 1,000 short tons
2011/12 | 617.563 | 5370 | 71.60123601533701 | 6059.164236015337 |  | 2400 | 132.689 | 3096.475236015337 | 5629.164236015337 | 430
2012/131 | 430 | 5666 | 0.005 | 6096.005 |  | 2500 | 191.377 | 2912.628 | 5604.005 | 492
2013/142 | 492 | 4406 | 100 | 4998 |  | 2000 | 200 | 2365 | 4565 | 433
1 Estimated.  2 Forecast.
Sources: USDA, National Agricultural Statistics Service, Crop Production and U.S. Department of Commerce,
U.S. Census Bureau, Foreign Trade Statistics.
Last update: | 2014-03-11 21:11:55.620000
Spreadsheet: 108695d1305708018-call-top3-based-on-duplicate-data-and-ranking-info-776034_sophyex-v3
Sheet: Pivot I

Row Labels | Sum of Value | Average of Value2 | Count of Value2
USA | 10 | 3.333333333333333 | 3
[NAME] | 1 | 1 | 1
[NAME] | 3 | 3 | 1
[NAME] | 6 | 6 | 1
CAN | 16 | 5.333333333333333 | 3
[NAME] | 4 | 4 | 1
[NAME] | 5 | 5 | 1
[NAME] | 7 | 7 | 1
FRA | 36 | 12 | 3
[NAME] | 11 | 11 | 1
[NAME] | 12 | 12 | 1
[NAME] | 13 | 13 | 1
MEX | 57 | 19 | 3
[NAME] | 18 | 18 | 1
[NAME] | 19 | 19 | 1
[NAME] | 20 | 20 | 1
Grand Total | 119 | 9.916666666666666 | 12
Spreadsheet: 02c5f0e3-48a3-48d0-9027-7f1ee76b3c94
Sheet: Summary

 | College & Universities Summary
 | Summary of Sources and Uses of Funds
 | Fiscal Year 2010
 |  |  |  | A | B | C |  | D |  | E | F |  | G |  | H
 |  |  |  | Operating Budgets
 |  |  |  | Board Approved Budgets |  |  |  | CEO Approved |  | Estimated Budgets |  |  | Total |  | %
 |  |  |  | General | Professional- Technical | Special |  | Auxiliary |  | Instit | Grants & |  | Operating |  | of
 |  |  |  | Education | Education | Programs |  | Enter.   (1) |  | Accounts | Contracts |  | Budgets |  | Total
 | SOURCES OF FUNDS:
 |  | State Appropriations |  |  |  |  |  |  |  |  |  |  |  |  |  | State Funds
1 |  | General Account |  |  |  |  |  |  |  |  |  |  |  |  |  | Endowment Funds
 |  | General Acct - One time funds |  |  |  |  |  |  |  |  |  |  |  |  |  | One-Time Funds
 |  | Endowment Funds |  |  |  |  |  |  |  |  |  |  |  |  |  | Student Fee Revenue |  |  |  | Student Fee Revenue: |  | General Revenue
 |  | Student Fees |  |  |  |  |  |  |  |  |  |  |  |  |  | Federal Funds |  |  |  |  |  | Institutional
 |  | Student Fees/Other - One time |  |  |  |  |  |  |  |  |  |  |  |  |  | State Grants & Contracts
 |  | ARRA Stimulus Funds |  |  |  |  |  |  |  |  |  |  |  |  |  | Private Gifts, Grts & Contr
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Aux Ent & Generated Fds
 |  | Total Appropriations
 |  | Other Student Fees |  |  |  |  |  |  |  |  |  |  |  |  |  | Instruction
 |  | Federal Approp |  |  |  |  |  |  |  |  |  |  |  |  |  | Research
 |  | Federal Grants & Contracts |  |  |  |  |  |  |  |  |  | (3) |  |  |  | Public Service
 |  | State Grants & Contracts |  |  |  |  |  |  |  |  |  |  |  |  |  | Academic Support
 |  | Private Gifts, Grts & Contr |  |  |  |  |  |  |  |  |  |  |  |  |  | Libraries
 |  | Sales & Serv of Educ Act |  |  |  |  |  |  |  |  |  |  |  |  |  | Student Services
 |  | Sales & Serv of Aux Ent |  |  |  |  |  |  |  |  |  |  |  |  |  | Institutional Support
 |  | Indirect Costs |  |  |  |  |  |  |  |  |  |  |  |  |  | Physical Plant
 |  | Other |  |  |  |  |  |  |  |  |  |  |  |  |  | Scholarships & Fellowships
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Auxiliary Enterprises   (1) & (2)
 |  | Total Revenue |  |  |  |  |  |  |  |  |  |  |  |  |  | One-time Replacement Capital
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Other
 | USES OF FUNDS:
 |  | Instruction
 |  | Research
 |  | Public Service
 |  | Academic Support
 |  | Libraries
 |  | Student Services
 |  | Institutional Support
 |  | Physical Plant
 |  | Scholarships & Fellowships |  |  |  |  |  |  |  |  |  | (3)
 |  | Auxiliary Enterprises   (1) & (3)
 |  | Mandatory Transfers
 |  | Other
 |  | One-time Replacement Capital
 |  | Total Uses
 | Incr/(Decr) to Balance
 | Employee FTE
 |  | (1)  General Education program supports intercollegiate athletics which is an auxiliary enterprise and reported in the General Education
 |  | column not the auxiliary enterprise column.
 |  | (2)  Auxiliary Enterprises includes University of Idaho's Kibbie Dome operations
 |  | (3)  Includes Federal Direct Student Loan funds
Spreadsheet: 638628d1566631608-allocation-formula-to-allocate-excess-stocks-to-required-inter-trasnfer-file-test
Sheet: Shortage

Sku Code | To Store | Qty Needed | cumulative | From | total excess | Remaining Qty | Action
1000058 | HKP06 | 3 |  | hpp28 | 6 | 3
1000058 | HHP20 | 4 |  | hpp28 | 6 | 3 |  | should allocate remaining 3 that is less than second demand of 4
1000058 | HHP30 | 4 |  | hpp28 | 6 | 0
1000058 | HHP28 | 5 |  | hpp28 | 6 | 0
1000060 | HHP27 | 2 |  | hpp28 | 9 | 7
1000060 | HKP22 | 5 |  | hpp28 | 9 | 2
1000061 | [NAME] | 1 |  | hpp28 | 0
1000061 | HKP25 | 1 |  | hpp28 | 0
1000061 | HKP06 | 2 |  | hpp28 | 0 |  |  | need to calculate remaining Qty also need to improve allocation formaula in Action column
Spreadsheet: 833149d1686817346-power-query-how-to-get-prev-months-value-how-to-get-prev-months-value-pq-example-spreadsheet-copy
Sheet: Sheet1

 | Row Labels | Stock Level | Stock Change |  |  |  |  | Row Labels | Sum of Stock Level | Stock Change
 | Mar |  |  |  |  |  |  | Mar
 | Bag | 137 | 137 |  |  |  |  | Bag | 137
 | Barrel | 8 | 8 |  |  |  |  | Barrel | 8
 | Bottle | 22 | 22 |  |  |  |  | Bottle | 22
 | Box | 152 | 152 |  |  |  |  | Box | 152
 | Crate | 54 | 54 |  |  |  |  | Crate | 54
 | Grand Total | 373 | 373 |  |  |  |  | Grand Total | 373
Spreadsheet: 122378d1316775738-vlookup-array-formula-to-show-multiple-results-trial-worksheet-1-
Sheet: Product Codes

Join "B" + "C" | Company | Product | Code
 | BT | landline | BT-1
 | Talk Talk | landline | T1
 | O2 | monthly contract | O2-M
 | BT | Broadband | BT-B
 | Orange | phones | O-P
 | BT | landline | BT-L1
 | Orange | phones | O-MB
Spreadsheet: 773693d1648008825-vlookup-multiple-criteria-example-v3
Sheet: By Task Order

Table | ID | Task Order | Employee Name | 2021-12-15 00:00:00 | 2021-12-31 00:00:00 | 2022-01-15 00:00:00 | 2022-01-31 00:00:00 | 2022-02-14 00:00:00 | 2022-02-28 00:00:00 | 2022-03-15 00:00:00 | 2022-03-31 00:00:00 | 2022-04-15 00:00:00
 | 1001 | 01 AA.AD | [NAME], [NAME] | 0 | 0 | 0 | 5 | 0 | 0 | 5
 | 2403 | 01 AA.AD | Doe, [NAME] | 0 | 0 | 0 | 0 | 0 | 9 | 0
 | 2050 | 01 AA.AD | Fisher, Mary | 0 | 0 | 0 | 0 | 15 | 0 | 0
 | 1920 | 01 AA.AD | [NAME], [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | TO01
 | 1001 | 02 AC.AD | [NAME], [NAME] | 0 | 5 | 5 | 5 | 5 | 5 | 5
 | 2403 | 02 AC.AD | Doe, [NAME] | 0 | 10 | 10 | 10 | 10 | 10 | 10
 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | TO02
 | 2050 | 03 AB.AD | Fisher, Mary | 0 | 8 | 8 | 8 | 8 | 8 | 8
 | 1920 | 03 AB.AD | [NAME], [NAME] | 0 | 15 | 10 | 4 | 3 | 21 | 5
 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | TO03
Spreadsheet: 145457d1331587581-lookup-cell-in-workbook-a-if-true-then-post-contents-of-row-into-workbook-b-test-book
Sheet: Sheet2

Month | Date of Proposal | Division | Insurance (Y/N) | Project # | Name of Project | Executed Contract | Date of Contract | Job Sell | Job Cost | Proposed Profit | Gross Profit Margin | Actual Profit | Revenue Pipeline | Lost Revenue | Date Job Invoiced | Actual Revenue | Actual Cost | Work Completed (Yes/No) | # of Days Overdue | Invoice Paid | Reason for Not Executed
NOV | 2011-11-29 00:00:00 | Consulting |  | 112143 | The Solomon Organization | Yes | 2012-01-27 00:00:00 | 3986 | 2391
Spreadsheet: 65985d1266602124-sum-cells-by-common-date-sample_report
Sheet: report.csv

Date | Impressions | Clicks
2009-01-01 00:00:00 | 6 | 4
2009-01-01 00:00:00 | 3 | 1
2009-01-02 00:00:00 | 6 | 4
2009-01-02 00:00:00 | 3 | 1
2009-01-02 00:00:00 | 4 | 1
2009-01-03 00:00:00 | 5 | 2
2009-01-03 00:00:00 | 2 | 2
2009-01-04 00:00:00 | 1 | 1
2009-01-04 00:00:00 | 1 | 1
2009-01-04 00:00:00 | 1 | 1
2009-01-04 00:00:00 | 3 | 1
2009-01-05 00:00:00 | 2 | 1
2009-01-05 00:00:00 | 1 | 1
2009-01-05 00:00:00 | 1 | 1
2009-01-06 00:00:00 | 1 | 1
2009-01-06 00:00:00 | 3 | 3
2009-01-06 00:00:00 | 10 | 1
2009-01-06 00:00:00 | 2 | 1
2009-01-07 00:00:00 | 7 | 2
2009-01-07 00:00:00 | 22 | 4
2009-01-07 00:00:00 | 13 | 2
2009-01-07 00:00:00 | 1 | 1
2009-01-08 00:00:00 | 2 | 2
2009-01-08 00:00:00 | 5 | 4
2009-01-08 00:00:00 | 6 | 1
2009-01-09 00:00:00 | 6 | 4
2009-01-09 00:00:00 | 2 | 2
2009-01-09 00:00:00 | 19 | 2
2009-01-09 00:00:00 | 2 | 1
2009-01-09 00:00:00 | 15 | 1
2009-01-09 00:00:00 | 2 | 1
2009-01-10 00:00:00 | 9 | 4
2009-01-10 00:00:00 | 1 | 2
2009-01-10 00:00:00 | 15 | 1
2009-01-10 00:00:00 | 1 | 1
2009-01-10 00:00:00 | 4 | 1
2009-01-10 00:00:00 | 1 | 1
2009-01-11 00:00:00 | 1 | 2
2009-01-11 00:00:00 | 1 | 1
2009-01-11 00:00:00 | 1 | 2
2009-01-12 00:00:00 | 10 | 6
2009-01-12 00:00:00 | 29 | 4
2009-01-12 00:00:00 | 6 | 1
2009-01-12 00:00:00 | 1 | 1
2009-01-13 00:00:00 | 5 | 3
2009-01-13 00:00:00 | 1 | 1
2009-01-13 00:00:00 | 13 | 3
2009-01-13 00:00:00 | 2 | 1
2009-01-13 00:00:00 | 3 | 1
2009-01-13 00:00:00 | 1 | 1
2009-01-13 00:00:00 | 2 | 1
2009-01-13 00:00:00 | 4 | 2
2009-01-14 00:00:00 | 8 | 6
2009-01-14 00:00:00 | 18 | 1
2009-01-14 00:00:00 | 5 | 2
2009-01-15 00:00:00 | 23 | 3
2009-01-15 00:00:00 | 15 | 4
2009-01-15 00:00:00 | 1 | 1
2009-01-15 00:00:00 | 4 | 1
2009-01-15 00:00:00 | 5 | 1
2009-01-16 00:00:00 | 1 | 1
2009-01-16 00:00:00 | 11 | 3
2009-01-16 00:00:00 | 1 | 1
2009-01-16 00:00:00 | 25 | 1
2009-01-16 00:00:00 | 2 | 1
2009-01-16 00:00:00 | 13 | 3
2009-01-17 00:00:00 | 1 | 1
2009-01-17 00:00:00 | 5 | 2
2009-01-17 00:00:00 | 3 | 1
2009-01-17 00:00:00 | 1 | 1
2009-01-18 00:00:00 | 18 | 1
2009-01-18 00:00:00 | 1 | 1
2009-01-18 00:00:00 | 2 | 1
2009-01-19 00:00:00 | 2 | 2
2009-01-19 00:00:00 | 1 | 1
2009-01-19 00:00:00 | 4 | 1
2009-01-19 00:00:00 | 3 | 1
2009-01-19 00:00:00 | 1 | 1
2009-01-19 00:00:00 | 5 | 2
Spreadsheet: 118069d1313421349-best-way-to-represent-this-data-move-stats-by-shift
Sheet: by date

Shift Move Stats | Tool
Date & Shift | T1 | T2 | T3 | Total
A
2011-08-07 00:00:00 | 10 | 2 | 3 | 15
2011-08-08 00:00:00 | 20 | 2 | 3 | 25
2011-08-09 00:00:00 | 1 | 2 | 3 | 6
A Total | 31 | 6 | 9 | 46
B
2011-08-07 00:00:00 | 1 | 2 | 3 | 6
2011-08-08 00:00:00 | 1 | 2 | 3 | 6
2011-08-09 00:00:00 | 1 | 2 | 3 | 6
B Total | 3 | 6 | 9 | 18
C
2011-08-07 00:00:00 | 1 | 2 | 3 | 6
2011-08-08 00:00:00 | 1 | 2 | 3 | 6
2011-08-09 00:00:00 | 1 | 2 | 3 | 6
C Total | 3 | 6 | 9 | 18
D
2011-08-07 00:00:00 | 1 | 2 | 3 | 6
2011-08-08 00:00:00 | 1 | 2 | 3 | 6
2011-08-09 00:00:00 | 1 | 2 | 3 | 6
D Total | 3 | 6 | 9 | 18
Total | 40 | 24 | 36 | 100
 |  |  |  |  |  |  |  |  |  | Likely we will want to do day number rather then date. Then switch day number to first row in axis fields. Well we will want to fake normalize the days in a week so each week will have day 1 2 3 4 in the chart, this way we can compare each tools moves output with each shift.
Spreadsheet: 543587d1508467825-how-to-calculate-and-avoid-work-hours-2-populated
Sheet:  SEPTEMBAR 2017

Ime i prezime: | VLADIMIR | DUBRAVKO | SLOBODAN | VLADIMIR | UKUPNO SATI SEPTEMBAR
Datum:
2017-09-01 00:00:00 | 18 - 06 | FREE | VACATION | 06 - 18
2017-09-02 00:00:00 | FREE | 06 - 18 | VACATION | 18 - 06 | 30 | DANA
2017-09-03 00:00:00 | 06 - 18 | 18 - 06 | VACATION | FREE | 24 | SATA
2017-09-04 00:00:00 | 18 - 06 | FREE | VACATION | 06 - 18
2017-09-05 00:00:00 | FREE | FREE | 06 - 18 | 18 - 06
2017-09-06 00:00:00 | FREE | 06 - 18 | 18 - 06 | FREE
2017-09-07 00:00:00 | 06 - 18 | 18 - 06 | FREE | FREE
2017-09-08 00:00:00 | 18 - 06 | FREE | FREE | 06 - 18
2017-09-09 00:00:00 | FREE | FREE | 06 - 18 | 18 - 06
2017-09-10 00:00:00 | FREE | 06 - 18 | 18 - 06 | FREE
2017-09-11 00:00:00 | 06 - 18 | 18 - 06 | FREE | FREE
2017-09-12 00:00:00 | 18 - 06 | FREE | FREE | 06 - 18
2017-09-13 00:00:00 | FREE | FREE | 06 - 18 | 18 - 06
2017-09-14 00:00:00 | FREE | 06 - 18 | 18 - 06 | FREE
2017-09-15 00:00:00 | 06 - 18 | 18 - 06 | FREE | FREE
2017-09-16 00:00:00 | 18 - 06 | FREE | FREE | 06 - 18
2017-09-17 00:00:00 | FREE | FREE | 06 - 18 | 18 - 06
2017-09-18 00:00:00 | FREE | 06 - 18 | 18 - 06 | FREE
2017-09-19 00:00:00 | 06 - 18 | 18 - 06 | FREE | FREE
2017-09-20 00:00:00 | 18 - 06 | FREE | FREE | 06 - 18
2017-09-21 00:00:00 | FREE | FREE | 06 - 18 | 18 - 06
2017-09-22 00:00:00 | FREE | 06 - 18 | 18 - 06 | FREE
2017-09-23 00:00:00 | 06 - 18 | 18 - 06 | FREE | FREE
2017-09-24 00:00:00 | 18 - 06 | FREE | FREE | 06 - 18
2017-09-25 00:00:00 | FREE | FREE | 06 - 18 | 18 - 06
2017-09-26 00:00:00 | FREE | 06 - 18 | 18 - 06 | FREE
2017-09-27 00:00:00 | 06 - 18 | 18 - 06 | FREE | FREE
2017-09-28 00:00:00 | 18 - 06 | FREE | FREE | 06 - 18
2017-09-29 00:00:00 | FREE | FREE | 06 - 18 | 18 - 06
2017-09-30 00:00:00 | FREE | 06 - 18 | 18 - 06 | FREE
Ukupno:
Spreadsheet: 29550d1224612277-excel-2007-averaging-excelexample
Sheet: Sheet1

Name | Term - YRS | Rate | Balance
 | 6 | 0.05
 | 5 | 0.05
 | 10 | 0.05
 | 5 | 0.035
 | 10 | 0.05
 | 15 | 0.05
 | 10 | 0.05
 | 5 | 0.05
 | 10/20 | 0.05
 | 4 | 0.0475
 | 10 | 0.0475
 | 2 | 0.0475
 | 10/25 | 0.05
 | 10/20 | 0.0475
 | 5 | 0.035
 | 5 | 0.035
 | 5 | 0.035
 | 5 | 0.035
 | 15 | 0.04
 | 15 | 0.04
 | 4 | 0.035
 | 4 | 0.035
 | 10 | 0.0375
 | 10 | 0.0375
 | 10 | 0.0375
 | 10 | 0.0375
 | 10/15 | 0.0375
 | 10 | 0.0375
 | 15 | 0.04
 | 8 | 0.0375
 | 15 | 0.04
 | 10 | 0.0375
 | 5 | 0.035
 | 10 | 0.0375
 | 15 | 0.04
 | 10/20 | 0.0375
 | 15 | 0.04
 | 10 | 0.0375
 | 5 | 0.035
 | 4 | 0.035
 | 4 | 0.035
 | 10 | 0.0375
 | 15 | 0.04
 | 15 | 0.04
 | 5 | 0.035
 | 15 | 0.04
Total
Cumulative Totals |  |  | Test Excel Function
TERM | Balance | Avg. Rate
1-5 Years (3.84%) | 0
6-10 Years (4.23%) | 0
11-15 Years (4.11%) | 0
Name | Term - YRS | Rate | Balance
 | 15 | 0.04
 | 10 | 0.0375
 | 15 | 0.04
 | 10 | 0.0375
 | 15 | 0.04
 | 10 | 0.0375
 | 15 | 0.04
Total
Cumulative Totals
TERM | Balance | Avg. Rate
1-5 Years (3.84%) | 0
6-10 Years (4.16%) | 0
11-15 Years (4.08%) | 0
Name | Term - YRS | Rate | Balance
 | 15 | 0.04
 | 15 | 0.04
 | 15 | 0.04
 | 15 | 0.04
 | 15 | 0.04
 | 5 | 0.035
 | 10 | 0.0375
 | 10 | 0.0375
 | 15 | 0.04
 | 10 | 0.0375
 | 10 | 0.0375
 | 15 | 0.04
 | 10 | 0.0375
Total
TERM | Balance | Avg. Rate
1-5 Years (3.82%) | 0
6-10 Years (4.09%) | 0
11-15 Years (4.05%) | 0
Spreadsheet: 64071d1264937306-using-sum-in-auto-filter-faults-data
Sheet: Data

P | U | C | F | DT
17 | 7 | 5 | green | 5
18 | 10 | 5 | green | 20
17 | 8 | 2 | yellow | 10
10 | 5 | 3 | purple | 30
10 | 3 | 5 | red | 40
14 | 7 | 2 | orange | 20
17 | 9 | 7 | green | 25
Spreadsheet: 745657d1630082004-filtered-lookup-with-multi-column-data-return-draftexcelforumhelpnewweeklyphecreadings
Sheet: Pivot_pH

Crop | Ficus lyrata | Dynamic Chart Title
Zone | (All)
Row Labels | Average of Measured pH | Average of Target pH Low | Average of Target pH Range
32 | 4.86 | 5.5 | 1.5
33 | 4.93 | 5.5 | 1.5
27 | 5.51 | 5.5 | 1.5
29 | 5.38 | 5.5 | 1.5
Spreadsheet: sally_beck__33824__global standards daily reporting
Sheet: B 04

Quantitative Standards
Daily Exception Reports
Reports Supporting Quantitative Standards B
Report B 04:
Purpose: | To capture when reporting to DPR group was received late.
Date | Exported | By | Reason (to be supplied by commodity group) | Key contact
2000-10-27 00:00:00 | 2000-10-30 12:10:00 | from pwrdpr.xls | System failed | [NAME]
2000-10-27 00:00:00 | 2000-10-30 14:15:00 | from PWRB1027a-includes Alberta.xls
2000-10-27 00:00:00 | 2000-10-30 12:55:00 | from Orig1027B.xls
2000-10-27 00:00:00 | 2000-10-30 16:55:00 | from London_DPR_2000_10_27.xls
2000-10-27 00:00:00 | 2000-10-30 14:04:00 | from 1000_int.xls
Spreadsheet: mary_hain__25859__IOU04
Sheet: Current Market

 |  |  | Using Rate Case Market Estimate |  |  | Using 46 $/MWh |  | Using $46 and $400 million CRAC
 |  | Load | Price | Market | Benefit in Millions | Market | Benefit in Millions | Price w/CRAC | Market | Benefit in Millions | m/kwh Incr | CRAC share in $ | % share of CRAC
IOU
 | Exchange | 900
 | RL | 1000 | 19.25 | 28.1 |  | 46
Public
 | PF | 5575 | 19.25 | 28.1
 | FPS I&S | 125 | 14.25 | 28.1
DSI
 | IPTAC | 1490 | 23 | 28.1
 |  |  |  | Revenue Subject to CRAC: |  |  |  | million | Benefits
 |  |  |  |  | Rate multiplier
 |  |  |  |  |  | CRAC $ | 400
Spreadsheet: 816538d1675690195-adding-effort-as-a-multiplicator-to-an-existing-formula-sample
Sheet: Sheet1

 | Table 1
 | Item | Current efficiency score | Target efficiency score | Effort
 | Workflow 1 | 1 | 7 | 1
 | Process 1 | 3 | 5 | 2
 | Workflow 2 | 2 | 6 | 3
 | Process 2 | 4 | 5 | 1
 | Table 2
 | *Can't just multiply effort with current efficiency score
 | Item | Current efficiency score | Target efficiency score | Effort | New
 | Workflow 1 | 7 | 7 | 1
 | Process 1 | 5 | 5 | 2
 | Workflow 2 | 6 | 6 | 3
 | Process 2 | 5 | 5 | 1
Spreadsheet: mary_fischer__25625__1290
Sheet: E16.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 1290
ANALYSIS OF (GAIN) LOSS ON SALES OF ASSETS
FOR THE 6 MONTHS ENDED 6-30-2001
**LIST ALL PROPERTY SALES INCLUDING SALES OF REGULATORY ASSETS
**REGULATED COMPANIES DO NOT SHOW (GAIN)/LOSS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-16
 |  |  |  | (A) | + | (B) | + | (C) |  |  | + | (D) | + | (E) | + | (F) | + | (G) |  |  | =
 |  |  |  | GROSS SALE PROCEEDS |  |  |  | NET BOOK VALUE |  |  |  |  |  |  |  |  |  | OTHER (EXPLAIN) |  |  |  | (GAIN) LOSS
 |  | DATE |  |  |  | N/R OR OTHER |  | ASSET |  |  |  |  |  | ACCUM |  | EXP ASSOC |  | AMOUNT |  | HYPERION |  | DR / (CR)
[NAME] OF ASSET |  | OF SALE |  | CASH | + | (EXPLAIN BELOW) | + | AMOUNT |  | HYPERION ACCT | + | PP&E | + | [NAME] | + | WITH SALE | + | DR (CR) |  | ACCT | = | ENDING BAL |  | COMMENTS
PROCEEDS OR BOOK VALUE OF ASSETS
OF $1,000,000 OR MORE:
SALES OF PP&E
SALES OF OTHER ASSETS
 |  |  |  |  |  | (B)
OTHER (LESS THAN $1,000,000) :
Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] ACCT 1676
 |  | EXPLAIN: |  |  |  |  |  |  |  |  |  |  |  |  | Hyperion Income Accts :  DR/(CR)
 |  | Notes Receivable |  |  |  |  |  |  |  |  |  |  |  |  |  | Signs are reversed from Hyperion
 |  | (list amounts and terms):
 |  | Other:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-16
 |  |  |  |  |  | (B)