tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 4156aeec-4184-49e3-bbe8-cf37754d2bb5
Sheet: Sheet1

Spine Point | Spinal Salary |  | [NAME] (£) - 1 August 2014
 |  |  | Grade 1 |  |  | [NAME] |  |  | [NAME] |  |  | [NAME] |  |  | Grade 5 |  |  | Grade 6 |  |  | Grade 7 |  |  | [NAME] |  |  | Grade 9 |  |  | Grade 10
 |  |  | Basic Rate | Holiday Pay | Total | Basic Rate | Holiday Pay | Total | Basic Rate | Holiday Pay | Total | Basic Rate | Holiday Pay | Total | Basic Rate | Holiday Pay | Total | Basic Rate | Holiday Pay | Total | Basic Rate | Holiday Pay | Total | Basic Rate | Holiday Pay | Total | Basic Rate | Holiday Pay | Total | Basic Rate |  | Holiday Pay | Total
 |  |  | From 1 December 2014 all casual workers must not be paid below the New Living Wage rate of £8.70 (£7.85 plus 85p holiday pay)
1 | 13953
2 | 14257
3 | 14631
4 | 14959
5 | 15356
6 | 15765
7 | 16131
8 | 16577
9 | 17039
10 | 17528
11 | 18031
12 | 18549
13 | 19083
14 | 19632
15 | 20198
16 | 20781
17 | 21391
18 | 22029
19 | 22685
20 | 23386
21 | 24057
22 | 24775
23 | 25513
24 | 26274
25 | 27057
26 | 27864
27
28 | 29552
29 | 30434
30 | 31342
31 | 32277
32 | 33242
33 | 34233
34 | 35256
35
36 | 37394
37 | 38511
38 | 39685
39 | 40847
40 | 42067
41 | 43325
42
43 | 45954
44 | 47328
45 | 48743
46 | 50200
47 | 51702
48 | 53248
49 | 54841
50 | 56482
51 | 58172
52 | 59913 | # |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #
53 | 61706 | # |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #
54 | 63553 | # |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #
55 | 65455 | # |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #
56 | 67414 | # |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #
57 | 69431 | # |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #
58 | 71510 | # |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #
Spreadsheet: 489641d1479372672-comparing-multiple-items-to-see-if-they-match-if-they-match-then-getting-a-sum-sample-46-
Sheet: Folha1

 | Message Name | Area | Local Area | Time Posted | (CST) | DateStamp | Total Calls | Hangup | Helper | Helper | Total Calls | Hangup
 | 393526 | 3000 | 1200 | 09:03:00 | AM | 2016-07-06 00:00:00 | 1 | 0
 | 393526 | 3000 | 1200 | 09:03:00 | AM | 2016-07-06 00:00:00 | 1 | 1
 | Volume | ALL | ALL | 10:35:00 | AM | 3/25/2016 | 425 | 74
 | Volume | ALL | ALL | 10:35:00 | AM | 3/25/2016 | 971 | 351
 | [NAME] | 8351 | 1000 | 10:30:00 | AM | 3/21/2016 | 1 | 0
 | [NAME] | 8351 | 1100 | 02:09:00 | PM | 3/21/2016 | 4 | 3
 | Maint323) | 8381 | 1900 | 09:14:00 | AM | 3/24/2016 | 5 | 4
Spreadsheet: 1738167f-02c5-47c8-9cf6-44a9d9f0c9f5
Sheet: Sheet1

Curriculum 2013-14 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | 2013-02-20 00:00:00 | Unnamed: 6
Some Guidelines
Faculty are required to teach 2 graduate level courses and 2 undergraduate courses each year. One of these MUST be a Departmental
service REQUIRED course. See list of required service courses below. None service courses should be on a two year-rotating basis.
Course CANNOT be listed in the Bulletin unless you are planning to teach them every other year.
Faculty Member's Name:
On leave next year?
Courses you would like to |  | Undergrad:
teach and quarters: |  | Undergrad:
 |  | Grad:
 |  | Grad:
List other course in other departments
that you hold a joint appointment:
Freshman Seminars:
TA needed?
REQUIRED SERVICE COURSES
ANTHRO 90A |  | History of Archaeological Thought
ANTHRO 90B |  | Intro to Theory in Cultural and Social Anthropology
ANTHRO 90C |  | Intro to Theory in Ecological and Environmental Anthropology
ANTHRO 91 |  | Methods and Evidence in Anthropology
ANTHRO 91A |  | Archaeology Methods
ANTHRO 93 |  | Prefield Research Seminar
ANTHRO 94 |  | Postfield Research Seminar
ANTHRO 300 |  | Reading Theory Through Ethnography
ANTHRO 301 |  | History of Anthropological Theory, Culture and Society
ANTHRO 302 |  | History of Anthropological Theory, Ecology and Environment
ANTHRO 303 |  | Introduction to Archaeological Theory
ANTHRO 304 |  | Data Analysis for Quantitative Research
ANTHRO 305 |  | Research Method in Ecological Anthropology
ANTHRO 306 |  | Anthropological Methods and Research Design
ANTHRO 307 |  | Archaeological Methods and Research Desgin
ANTHRO 308 |  | Proposal Writing Seminar
ANTHRO 400 |  | Dissertation Writing Seminar
Required courses taught each year, historically for ANTHRO undegraduate curriculum
ANTHRO 1 |  | Intro to Cultural and Social Anthropology
ANTHRO 3 |  | Intro to Prehistoric Archaeology
ANTHRO 6 |  | Human Origins
ANTHRO 82/282 |  | Medical Anthropology
Possible Capstone Course |  | Professionalization
Possible Gateway Course
Spreadsheet: andy_zipper__197__DYNEGY-ICE VOL May23
Sheet: Enron Activity-ICE

ICE
Transactions and Notional Volume
By Enron Entity, Commodity, and [NAME]
Enron North America - ICE |  |  |  |  |  | Enron Power Marketing - ICE |  |  |  |  |  | Enron Canada Corp - ICE
ICE GAS VOLUME: |  | ENRON PERCENTAGE: |  |  |  | ICE POWER VOLUME: |  |  | ENRON PERCENTAGE:
ICE CRUDE PRODUCTS VOLUME: |  | ENRON PERCENTAGE:
 |  |  | Data |  |  |  |  |  | Data |  |  | No Activity
Trader | Product | Qty Units | Transactions | Volume |  | Trader | Product | Qty Units | Transactions | Volume
[NAME], J | NG Fin, FP for LD1 | MMBtus | 1 | 3650000 |  | Fischer, M | Firm-LD Peak | MWhs | 3 | 21600
[NAME], G | NG Fin BS, LD1 for IF | MMBtus | 1 | 1230000 |  | Motley, M | Firm-LD Peak | MWhs | 1 | 10800
Pimenov, V | NG [NAME], ID, GDD | MMBtus | 2 | 20000 |  | Richter, J | Firm-LD Off-Peak | MWhs | 2 | 47200
Grand Total |  |  | 4 | 4900000 |  | Stalford, R | Firm-LD Peak | MWhs | 2 | 32000
 |  |  |  |  |  | Dorland, C | Firm-LD Peak | MWhs | 2 | 6400
 |  |  |  |  |  | Grand Total |  |  | 10 | 118000
Spreadsheet: 183772d1349025774-list-all-cells-in-a-row-with-values-greater-than-zero-by-column-header-and-value-students-and-errors-v2
Sheet: Sheet1

 | Errors
Student Name | Skill1 | Skill2 | Skill3 | Skill4 | Skill5
Student 1 | 1 | 0 | 0 | 0 | 0 | Skill1(1)
Student 2 | 0 | 1 | 0 | 3 | 0 | Skill2(1) Skill4(3)
Student 3 | 0 | 0 | 0 | 0 | 0
Student 4 | 0 | 2 | 0 | 0 | 0 | [NAME])
Student 5 | 1 | 2 | 2 | 2 | 1 | Skill1(1) Skill2(2) Skill3(2) Skill4(2) Skill5(1)
Student 6 | 0 | 0 | 0 | 0 | 1 | Skill5(1)
Student 7 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 859010d1707485076-colour-coded-cells-with-formulas-example3
Sheet: All Data

XXXXX Details |  |  |  |  |  |  | assessment 1 |  |  | Assessment 2 |  |  | Assessment 3 |  |  | Assessment 4 |  |  | Assessment 5
Ref3 | Name | Age | Sex | Ref4 | Ref5 | Status | Code ID | Date | Code Term | Code ID | Date | Code Term | Code ID | Date | Code Term | Code ID | Date | Code Term | Code ID | Date | Code Term
0001 | Name1 | 25 | M | unknow1 | Ref5
0002 | [NAME] | 26 | M | unknow2 | Ref5
0003 | Name3 | 27 | M | unknow3 | Ref5
0004 | Name4 | 28 | M | unknow4 | Ref5
0005 | Name5 | 29 | M | unknow5 | Ref5
0006 | Name6 | 30 | M | unknow6 | Ref5
0007 | Name7 | 31 | M | unknow7 | Ref5
0008 | Name8 | 32 | M | unknow8 | Ref5
0009 | Name9 | 33 | M | unknow9 | Ref5
0010 | Name10 | 34 | M | unknow10 | Ref5
Spreadsheet: 142558d1329913733-excel-2010-if-the-value-is-found-in-column-a-then-sum-the-amounts-in-cell-in-b-test-budget-spreadsheet
Sheet: Budget Sheet

 | Budget Test
 | Item | Amount | Expense to Date | Balance
 | Petrol | 5000
 | Internet | 6000
 | Consumables | 8000
 | Spares | 2000
 | Labor | 9000
Spreadsheet: 275211d1383394288-calling-data-from-another-sheet-with-an-if-function-or-macro-vlookup
Sheet: New

Value | Name
Spreadsheet: 37062d1235012416-sort-question-baskets
Sheet: Sheet1

25 03 48 19 33 | 03 19 25 33 48
1 | 1
52 63 98 83 87 | 52 63 83 87 98 |  | 52 | 52 63 83 87 98
 |  |  | 63
 |  |  | 98
 |  |  | 83
 |  |  | 87
 |  |  | 31
 |  |  | 31
 |  |  | 59
 |  |  | 20
 |  |  | 17
 |  |  | 55
 |  |  | 4
 |  |  | 39
 |  |  | 19
 |  |  | 17
 |  |  | 77
 |  |  | 9
 |  |  | 82
 |  |  | 74
 |  |  | 74
 |  |  | 61
 |  |  | 3
 |  |  | 49
 |  |  | 55
 |  |  | 13
Spreadsheet: lindy_donoho__22206__Griffith-Calpine
Sheet: Griffith

Griffith
 | Scheduled Deliveries | Actual Deliveries
April | 61035 | 174124
May | 378120 | 248972
June | 1117225 | 1031744
July | 133818 | 85071
August | 1059132 | 1123235
Sept | 934720 | 1006977
Oct | 1124136 | 1146881
Spreadsheet: 688125d1595580144-find-horizontal-category-then-sort-vertically-book-6
Sheet: Sheet2

Category | Value
animal | dog
animal | bird
animal | cat
color | red
color | white
color | blue
food | bread
food | rice
tree | oak
tree | [NAME]
Spreadsheet: 2bd00a1e-e076-4125-8826-96fa41ed7197
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
BGA | Test | BGA | Beta-Galactosidase, Leukocytes | Beta-Galactosidase, Leukocytes | Fluorometric | Yellow-Top (ACD) Tube: ACD |  |  | 7 | mL | [NAME] must arrive within 72 hours of draw to be stabilized. Draw specimen Monday through Thursday only and not the day before a holiday. [NAME] should be drawn and packaged as close to shipping time as possible.   Container/Tube: Preferred: Yellow top (ACD solution B) Acceptable: Yellow top (ACD solution A) [NAME]: 7 mL Collection Instructions: Do not transfer blood to other containers. Forms: 1.   1. New York Clients-Informed consent is required. Please document on the request form or electronic order that a copy is on file. An Informed Consent for Genetic Testing (Supply T576) is available in Special Instructions. 2.   2. If not ordering electronically, submit a Biochemical Genetics Request Form (Supply T439) with the specimen. | 5 mL | Hemolysis	Mild OK; Gross reject Thawing	NA Lipemia	NA Icterus	NA Other	NA | > or =1.56 nmol/min/mg | Specimens are processed Monday through Sunday.  Assay is performed on Wednesday; | 8 days | 15 days | 1 | 82657 |  |  |  |  | Rochester
BGA | [NAME] | ACDZ | [NAME] ACD |  |  |  | Refrigerated | 72 hours
BGA | Result | 8486 | Beta-Galactosidase, Leukocytes | Beta-Galactosidase, Leukocytes | Numeric |  |  |  |  | nmol/min/mg |  |  |  |  |  |  |  |  |  | 24061-4 | Beta galactosidase:CCnt:Pt:WBC:Qn:
BGA | Result | 34979 | Interpretation (BGA) | Interpretation (BGA) | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 59462-2 | Clinical biochemist review:Imp:Pt:XXX:Nar:
BGA | Result | 34907 | Reviewed By | Reviewed By | Numeric
Spreadsheet: 65338d1266002710-non-dealing-customer-detail-with-color-code-temp_avk
Sheet: result

code | customer name | machine no | machine install date | city | dist | result : customer last invoice no | invoice date
A0289 | abcd | 22.1111/077777 | 2007-11-11 00:00:00 | aaaa | ab
A0289 | abcd | 22.1111/077777 | 2007-11-11 00:00:00 | aaaa | ab
A0289 | abcd | 23.2345/077777 | 2007-11-11 00:00:00 | aaaa | ab
A0289 | abcd | 23.2345/077777 | 2007-11-11 00:00:00 | aaaa | ab
A0289 | abcd | 23.2345/077777 | 2007-11-11 00:00:00 | bbb | ba
D0191 | defg | 24.2345/089999 | 2008-12-11 00:00:00 | [NAME] | ca
O0034 | olmn | 25.234/0808899 | 2008-01-01 00:00:00 | ddd | da
P0302 | pqrs | 23.2345/0820111 | 2008-02-02 00:00:00 | ddd | da
Spreadsheet: 9110cb4e-c72d-4352-b919-f484b037cb66
Sheet: Sheet1

Attachment K- Electric Utility Information | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Customer Name:
Site Address:
Contractor:
If relying on Remote Net Metering to Justify the size of the system, identify the NYS Net Metering Law Section that identifies that this technology is eligible:
Utility Tariff that applies to this technology and site:
 | Account # | Name on Utility Bill | Service Address | Utility Provider | NYISO Zone | Recent 12 month total usage (kWh) | Start (mm/yy) | End (mm/yy)
Host Site Meter
Satellite Meter 1
Satellite [NAME]
Satellite Meter 3
Satellite [NAME]
Spreadsheet: 81284d1281527469-adding-a-computed-column-at-end-for-a-growing-list-using-fn-no-macros-report101
Sheet: Sheet2

StudentName | Marks1 | Marks2 | Marks3 | Marks4 | Marks5 | Marks6
Spreadsheet: 717441d1612648269-numbering-returned-matches-in-array-by-date-excel-forum-example
Sheet: Sheet1

Item | Position | Type | Date | Helper | Desired Outcome
10000 | 1
10003 | 1 | [NAME] | 2021-01-04 00:00:00 |  | 1
10005 | 1 | [NAME] | 2021-01-02 00:00:00 |  | 1
10004 | 1
10004 | 2
10003 | 1 | Apple | 2021-01-15 00:00:00 |  | 1
10001 | 1
10007 | 1
10003 | 1 | Apple | 2021-02-01 00:00:00 |  | 2
9865 | 1
10008 | 1
10009 | 1
10005 | 1 | Apple | 2021-02-02 00:00:00 |  | 1
10003 | 1 | Apple | 2021-02-06 00:00:00 |  | 3
10005 | 1 | Apple | 2021-02-09 00:00:00 |  | 2
10010 | 1
10010 | 2
10010 | 3
10011 | 1
Spreadsheet: 680498d1591051912-avoiding-a-circular-reference-when-calculating-bonuses-based-on-profit-margin-executivecompensationexample
Sheet: Hypothetical2020

 | January |  |  |  |  | February |  |  |  |  | March |  |  |  |  | April
 | Actuals | %ofRevenue | Hypothetical | %ofRevenue | Manual | Actuals | %ofRevenue | Hypothetical | %ofRevenue | Manual | Actuals | %ofRevenue | Hypothetical | %ofRevenue | Manual | Actuals | %ofRevenue | Hypothetical | %ofRevenue | Manual
Revenue | 108248 |  |  |  |  | 80901 |  |  |  |  | 95331 |  |  |  |  | 89811
Compensation of Officers | 10115 |  |  |  | 0.1 | 11395 |  |  |  | 0.08 | 10359 |  |  |  | 0.09 | 9171 |  |  |  | 0.08
Health Insurance
Base Comp
Monthly "Bonus"
OtherExpenses | 63564 |  |  |  |  | 68094 |  |  |  |  | 60782 |  |  |  |  | 62556
Total Expenses | 73678 |  |  |  |  | 79491 |  |  |  |  | 71142 |  |  |  |  | 71727
EBITDA | 34570 |  |  |  |  | 1410 |  |  |  |  | 24190 |  |  |  |  | 18084
Officer Share of EBITDA
Officer [NAME]
[NAME]
Spreadsheet: benjamin_rogers__911__PJM Eastern Hub Pricing
Sheet: Peak

Year | 1998
Month | Average of RT East Hub | Average of RT West Hub | Delta Real Time
4 | 22.54647727272729 | 22.52164772727274
5 | 32.88612499999998 | 33.14359375
6 | 35.71020833333334 | 35.72303571428572
7 | 51.631222826087 | 51.46307065217393
8 | 42.04494047619048 | 42.05142857142858
9 | 30.67869047619047 | 31.00711309523808
10 | 22.24136363636363 | 22.24502840909089
11 | 20.3315 | 20.48381249999999
12 | 18.87744318181817 | 18.9038068181818
Grand Total | 30.88342447916675 | 30.94459635416673
Year | 1999
Month | Average of RT East Hub | Average of RT West Hub | Delta Real Time
1 | 22.7574375 | 22.73678125
2 | 17.33009375000002 | 17.24390625
3 | 21.03904891304349 | 20.94875
4 | 25.64161931818182 | 25.66909090909092
5 | 27.01799999999999 | 27.122125
6 | 57.6299715909091 | 57.36372159090909
7 | 166.0365056818182 | 159.5049715909092
8 | 46.80928977272728 | 44.12147727272728
9 | 27.9198214285714 | 26.24752976190474
10 | 25.28255952380955 | 23.96723214285714
11 | 23.63452380952379 | 21.75151785714285
12 | 22.75630434782608 | 20.65421195652173
Grand Total | 40.76872081712052 | 39.36466926070044
Year | 2000
Month | Average of RT East Hub | Average of RT West Hub | Delta Real Time | Average of DA East Hub | Average of DA West Hub | Delta Day Ahead
1 | 41.02360119047617 | 29.35702380952378
2 | 29.18627976190478 | 27.59125
3 | 27.54168478260869 | 27.06858695652175
4 | 33.03559374999999 | 30.50481249999999
5 | 52.905 | 41.93991477272729
6 | 41.649375 | 28.6065625 |  | 49.2352556818182 | 35.8959375
7 | 40.15723214285712 | 33.73 |  | 40.05461309523811 | 36.99458333333333
8 | 44.93478260869565 | 40.76801630434784 |  | 48.36470108695652 | 47.0311956521739
9 | 31.41928124999999 | 30.42803124999999 |  | 31.041875 | 29.83859375
10 | 41.73752840909089 | 41.64539772727272 |  | 42.68426136363637 | 42.54397727272727
11 | 41.55520833333335 | 41.19386904761908 |  | 44.0394047619047 | 43.60544642857139
12 | 58.94790624999997 | 55.85084374999999 |  | 64.23184375000007 | 65.19393750000003
Grand Total | 40.32736328124989 | 35.67754638671862 |  | 45.67829697986575 | 42.95736157718124
Year | 2001
Month | Average of RT East Hub | Average of RT West Hub | Delta Real Time | Average of DA East Hub | Average of DA West Hub | Delta Day Ahead
1 | 47.37477272727269 | 45.39450973863632 |  | 49.2565625 | 46.90019886363638
2 | 41.7438125 | 33.4755 |  | 44.31121875000002 | 36.23787500000002
3 | 46.939375 | 39.19191532258063 |  | 50.59403225806454 | 42.96844758064516
4 | 43.21129166666666 | 41.46285416666668 |  | 45.9087916666667 | 43.16897916666666
5 | 46.73576704545455 | 38.78178977272729 |  | 45.81886363636366 | 41.72153409090915
Grand Total | 43.9227068661972 | 38.73780256514087 |  | 46.34395686619699 | 41.68134683098576
Spreadsheet: 101947b9-0176-469e-9832-a984a79f2f28
Sheet: Sheet1

Tier 1: DELIVERABLE TABLE | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Incubator Company:
PI: |  | Ph: |  | E-mail:
12-Month Duration
Task Number and Title | Criteria and Deliverable                                (Specific, Measurable, Achievable, Relevant, Timely) What, How, Who, Where? |  | Date (Months after contract start) | % of total DOE funding* | Additional Notes
-- |  |  | 1 | 0.2 | Refined design templates and decision tree
Baseline
1 |  |  | 3 | 0.1 | Advanced market research will be used to scope out customer base
Customer / supplier advanced research
2 |  |  | 9 | 0.2 | Final design with links but not working code
Website design
1 |  |  | 9 | 0.1 | Final design with links but not working code
Customer / supplier advanced research
3 |  |  | 10 | 0.1 | Functioning site with working code
Code Development
2 |  |  | 12 | 0.3 | Final website that functions on platforms such as…
Final Deliverable
**Quarterly Technical Progress Reports |  |  |  | -- | Short letter format, emphasizing status
Draft/Final Technical Progress Report |  |  |  | ---
Final Review |  |  | 12-months after subcontract execution |  | Detailed accomplishments and status
Spreadsheet: 631839d1562857002-distance-between-coordinates-shown-in-a-sorted-list-xlf_1282014_part2
Sheet: xx

 |  |  | Location ID | x | y
 |  |  | HY675
 |  |  | Location ID | Coordinate X | Coordinate Y | Distance (m)
 |  |  | PG343
 |  |  | PL122
 |  |  | [NAME]
 |  |  | KO420
 |  |  | OL942
 |  |  | PY492
 |  |  | PT940
 |  |  | HY675
 |  |  | [NAME]
 |  |  | KH387
 |  |  | UB482
 |  |  | HF029
 |  |  | RH392
 |  |  | LN392
 |  |  | ES492
 |  |  | NJ111
 |  |  | LK392
 |  |  | KL329
 |  |  | GF329
 |  |  | DF392
 |  |  | DR029
 |  |  | SD932
 |  |  | WE942
 |  |  | DE902
 |  |  | [NAME]
 |  |  | RH992
 |  |  | LR012
 |  |  | [NAME]
 |  |  | OR654
Spreadsheet: 490955d1480194839-time-formula-please-help-workbook6
Sheet: Sheet3

 | JANUARY
 |  | 1st | 2nd | 3rd | 4th | 5th | 6th PAYDAY | 7th
 | Projected: | 07:00:00 | 07:00:00 | 07:00:00 | 07:00:00 | 07:00:00
 |  | 14:00:00 | 14:00:00 | 14:00:00 | 14:00:00 | 14:00:00 | - | -
 | Actual:
 |  | 8th | 9th | 10th | 11th | 12th | 13th | 14th
 | Projected: | 07:00:00 | 07:00:00 | 07:00:00 | 07:00:00 | 07:00:00
 |  | 14:00:00 | 14:00:00 | 14:00:00 | 14:00:00 | 14:00:00 | - | -
 | Actual:
 |  | 15th | 16th | 17th | 18th | 19th | 20th PAYDAY | 21st
 | Projected: | 07:00:00 | 07:00:00 | 07:00:00 | 07:00:00 | 07:00:00
 |  | 14:00:00 | 14:00:00 | 14:00:00 | 14:00:00 | 14:00:00 | - | -
 | Actual:
 |  | 22nd | 23rd | 24th | 25th | 26th | 27th | 28th
 | Projected: | 07:00:00 | 07:00:00 | 07:00:00 | 07:00:00 | 07:00:00
 |  | 14:00:00 | 14:00:00 | 14:00:00 | 14:00:00 | 14:00:00 | - | -
 | Actual:
 |  | 29th | 30th | 31st | FEB 1st | 2nd | 3rd PAYDAY | 4th
 | Projected: | 07:00:00 | 07:00:00 | 07:00:00 | 07:00:00 | 07:00:00
 |  | 14:00:00 | 14:00:00 | 14:00:00 | 14:00:00 | 14:00:00 | - | -
 | Actual:
Spreadsheet: 145387d1331565006-index-match-several-sheets-to-one-formula-vml
Sheet: tab2

1.14 |  |  | Dep Date |  |  |  |  |  |  | 2011-04-28 00:00:00 | 2011-05-05 00:00:00 | 2011-05-12 00:00:00 | 2011-05-19 00:00:00 | 2011-05-26 00:00:00 | 2011-06-02 00:00:00 | 2011-06-09 00:00:00 | 2011-06-16 00:00:00 | 2011-06-23 00:00:00 | 2011-06-30 00:00:00 | 2011-07-07 00:00:00 | 2011-07-14 00:00:00 | 2011-07-21 00:00:00 | 2011-07-28 00:00:00 | 2011-08-04 00:00:00 | 2011-08-11 00:00:00 | 2011-08-18 00:00:00 | 2011-08-25 00:00:00 | 2011-09-01 00:00:00 | 2011-09-08 00:00:00 | 2011-09-15 00:00:00 | 2011-09-22 00:00:00 | 2011-09-29 00:00:00 | 2011-10-06 00:00:00
PORTOMYRINA |  |  | W/c Date |  | 2011-04-02 00:00:00 | 2011-04-09 00:00:00 | 2011-04-16 00:00:00 | 2011-04-23 00:00:00 | 2011-04-30 00:00:00 | 2012-05-05 00:00:00 | 2012-05-12 00:00:00 | 2012-05-19 00:00:00 | 2012-05-26 00:00:00 | 2012-06-02 00:00:00 | 2012-06-09 00:00:00 | 2012-06-16 00:00:00 | 2012-06-23 00:00:00 | 2012-06-30 00:00:00 | 2012-07-07 00:00:00 | 2012-07-14 00:00:00 | 2012-07-21 00:00:00 | 2012-07-28 00:00:00 | 2012-08-04 00:00:00 | 2012-08-11 00:00:00 | 2012-08-18 00:00:00 | 2012-08-25 00:00:00 | 2012-09-01 00:00:00 | 2012-09-08 00:00:00 | 2012-09-15 00:00:00 | 2012-09-22 00:00:00 | 2012-09-29 00:00:00 | 2012-10-06 00:00:00 | 2012-10-13 00:00:00 | 2012-10-20 00:00:00 | 2012-10-27 00:00:00 | TOTAL | 2011-04-30 00:00:00 | 2011-05-31 00:00:00 | 2011-06-30 00:00:00 | 2011-07-31 00:00:00 | 2011-08-31 00:00:00 | 2011-09-30 00:00:00 | 2011-10-31 00:00:00 | Total
LXS |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 4 | 5 | 5 | 5 | 5 | 6 | 6 | 6 | 6 | 6 | 7 | 7 | 7 | 7 | 8 | 8 | 8 | 8 | 9 | 9 | 9 | 9 | 9 | 10 | 1 | 1 |  | 4 | 5 | 6 | 7 | 8 | 9 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.1193630468666256 | 0.2176968364935097 | 0.3015594484372952 | 0.2310964512949157 | 0.1113541091693971 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Other Costs | Transfers | -11.40350877192983 |  |  |  |  |  |  |  | -1590.789473684211 | -1590.789473684211 | -1590.789473684211 | -1590.789473684211 | -2011.578947368421 | -1950 | -1950 | -1950 | -1950 | -1950 | -2001.315789473684 | -2001.315789473684 | -2001.315789473684 | -2001.315789473684 | -2001.315789473684 | -2001.315789473684 | -1300.855263157895 | -1950 | -1950 | -1950 | -1908.947368421053 | -1336.263157894737 | 0 | 0 |  |  | -40528.69736842105 | -1590.789473684211 | -6783.947368421053 | -9750 | -8005.263157894738 | -7253.486842105263 | -7145.21052631579 | 0 | -40528.69736842105 | 0
 | Handling | 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
Spreadsheet: 233756d1367922590-making-a-time-15-minute-interval-exclusive-finalenergycalc
Sheet: Extra

1 |  | 00:00:00
1.5 |  | 00:15:00
2 |  | 00:30:00
 |  | 00:45:00
 |  | 01:00:00
 |  | 01:15:00
 |  | 01:30:00
 |  | 01:45:00
 |  | 02:00:00
 |  | 02:15:00
 |  | 02:30:00
 |  | 02:45:00
 |  | 03:00:00
 |  | 03:15:00
 |  | 03:30:00
 |  | 03:45:00
 |  | 04:00:00
 |  | 04:15:00
 |  | 04:30:00
 |  | 04:45:00
 |  | 05:00:00
 |  | 05:15:00
 |  | 05:30:00
 |  | 05:45:00
 |  | 06:00:00
 |  | 06:15:00
 |  | 06:30:00
 |  | 06:45:00
 |  | 07:00:00
 |  | 07:15:00
 |  | 07:30:00
 |  | 07:45:00
 |  | 08:00:00
 |  | 08:15:00
 |  | 08:30:00
 |  | 08:45:00
 |  | 09:00:00
 |  | 09:15:00
 |  | 09:30:00
 |  | 09:45:00
 |  | 10:00:00
 |  | 10:15:00
 |  | 10:30:00
 |  | 10:45:00
 |  | 11:00:00
 |  | 11:15:00
 |  | 11:30:00
 |  | 11:45:00
 |  | 12:00:00
 |  | 12:15:00
 |  | 12:30:00
 |  | 12:45:00
 |  | 13:00:00
 |  | 13:15:00
 |  | 13:30:00
 |  | 13:45:00
 |  | 14:00:00
 |  | 14:15:00
 |  | 14:30:00
 |  | 14:45:00
 |  | 15:00:00
 |  | 15:15:00
 |  | 15:30:00
 |  | 15:45:00
 |  | 16:00:00
 |  | 16:15:00
 |  | 16:30:00
 |  | 16:45:00
 |  | 17:00:00
 |  | 17:15:00
 |  | 17:30:00
 |  | 17:45:00
 |  | 18:00:00
 |  | 18:15:00
 |  | 18:30:00
 |  | 18:45:00
 |  | 19:00:00
 |  | 19:15:00
 |  | 19:30:00
 |  | 19:45:00
 |  | 20:00:00
 |  | 20:15:00
 |  | 20:30:00
 |  | 20:45:00
 |  | 21:00:00
 |  | 21:15:00
 |  | 21:30:00
 |  | 21:45:00
 |  | 22:00:00
 |  | 22:15:00
 |  | 22:30:00
 |  | 22:45:00
 |  | 23:00:00
 |  | 23:15:00
 |  | 23:30:00
 |  | 23:45:00
 |  | 1900-01-01 00:00:00