tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 167944d1342164921-i-want-to-send-data-in-multiple-workbook-projcet-22-expense-ledger
Sheet: COntractor-Electric Works

 |  |  |  |  |  |  | PROJECT # 22
 |  |  |  | Contractor-Electric |  |  | Mr.[NAME]
DATE | B# | P# | L# | Voucher No. | A/C | Description | [NAME]# | Qty | Rate | Cheq#/PS | Bank | Book# | A/C Ref # |  |  | DEBIT | CREDIT | BALANCE
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]# | Page# | Ledger#
2010-12-07 00:00:00 | 02 | 36 | CL-09 |  |  | Labour slab Pipes |  |  |  | 5175979 | BAH | B-25 |  | 31 | BL-01 |  | 5000 | 5000
2010-10-16 00:00:00 | 03 | 36 | CL-09 |  |  | [NAME] electric |  |  |  | 5192132 | BAH | F-06 |  | 77 | BL-01 |  | 5000 | 10000
2010-10-27 00:00:00 | 04 | 36 | CL-09 |  |  | [NAME] electric |  |  |  | 5192145 | BAH | F-06 |  | 78 | BL-01 |  | 25000 | 35000
2011-04-07 00:00:00 | 05 | 34 | CL-10 |  |  | [NAME] electric |  |  |  | 5214760 | BAH | F-15 |  | 22 | BL-02 |  | 100000 | 135000
2011-05-18 00:00:00 | 06 | 34 | CL-10 |  |  | [NAME] electric |  |  |  | 54689144 | HMB | A-1 |  | 67 | BL-02 |  | 25000 | 160000
2011-06-02 00:00:00 | 07 | 34 | CL-10 |  |  | [NAME] electric |  |  |  | 52608679 | HMB | A-2 |  | 69 | BL-02 |  | 25000 | 185000
2011-06-27 00:00:00 | 08 | 34 | CL-10 |  |  | [NAME] electric |  |  |  | 55915557 | HMB | A-3 |  | 72 | BL-02 |  | 50000 | 235000
2011-07-23 00:00:00 | 09 | 34 | CL-10 |  |  | [NAME] electric |  |  |  | 56173006 | HMB | A-4 |  | 73 | BL-02 |  | 25000 | 260000
2011-08-15 00:00:00 | 10 | 34 | CL-10 |  |  | [NAME] electric |  |  |  | 56173052 | HMB | A-4 |  | 75 | BL-02 |  | 25000 | 285000
2011-08-15 00:00:00 | 11 | 34 | CL-10 |  |  | [NAME] electric |  |  |  | 56173053 | HMB | A-4 |  | 75 | BL-02 |  | 25000 | 310000
2011-08-15 00:00:00 | 12 | 34 | CL-10 |  |  | [NAME] electric |  |  |  | 56173054 | HMB | A-4 |  | 75 | BL-02 |  | 50000 | 360000
Spreadsheet: 776868d1649949703-display-start-time-and-end-time-overlapping-overlapping-times-jbl0703-
Sheet: Feuil3

Start reference time | End reference time |  |  |  |  | Start reference time | End reference time
21:00:00 | 02:00:00 |  |  |  |  | 09:00:00 | 11:00:00
Schedule |  |  |  |  |  | Schedule |  |  |  |  |  | What I need
Start time | End time |  | Start overlap time | End overlap time |  | Start time | End time |  | Start overlap time | End overlap time
19:00:00 | 20:00:00 |  |  |  |  | 07:00:00 | 08:00:00 |  |  |  |  | no overlap | no overlap |  | no overlap | no overlap
19:00:00 | 21:00:00 |  |  |  |  | 07:00:00 | 09:00:00 |  |  |  |  | no overlap | no overlap |  | no overlap | no overlap
19:00:00 | 22:00:00 |  |  |  |  | 07:00:00 | 10:00:00 |  |  |  |  | 09:00:00 | 10:00:00 |  | 21:00:00 | 22:00:00
19:00:00 | 00:00:00 |  |  |  |  | 07:00:00 | 11:00:00 |  |  |  |  | 09:00:00 | 11:00:00 |  | 21:00:00 | 00:00:00
19:00:00 | 01:00:00 |  |  |  |  | 07:00:00 | 13:00:00 |  |  |  |  | 09:00:00 | 11:00:00 |  | 21:00:00 | 01:00:00
19:00:00 | 02:00:00 |  |  |  |  | 09:00:00 | 13:00:00 |  |  |  |  | 09:00:00 | 11:00:00 |  | 21:00:00 | 02:00:00
19:00:00 | 04:00:00 |  |  |  |  | 10:00:00 | 13:00:00 |  |  |  |  | 10:00:00 | 11:00:00 |  | 21:00:00 | 02:00:00
21:00:00 | 04:00:00 |  |  |  |  | 11:00:00 | 13:00:00 |  |  |  |  | no overlap | no overlap |  | 21:00:00 | 02:00:00
22:00:00 | 04:00:00 |  |  |  |  | 12:00:00 | 13:00:00 |  |  |  |  | no overlap | no overlap |  | 22:00:00 | 02:00:00
01:00:00 | 04:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 01:00:00 | 02:00:00
02:00:00 | 04:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | no overlap | no overlap
03:00:00 | 04:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | no overlap | no overlap
Spreadsheet: 204847d1357663590-determine-length-of-breaks-between-shifts-breaks-between-shifts
Sheet: Breaks Between Shifts

Breaks Between Shifts |  |  |  |  |  |  |  | (All data is mocked up)
Employee ID | Badge | Surname | First Name | Known As | Payroll ID | Department | Person Status | Here goes, but it is quite complex.
8 | 1234 | Bloggs | [NAME] | Bloggs, [NAME] | najshdf | Office | Employee | We have here a display sheet that contains references to the other sheets.
 |  |  |  |  |  |  |  | The other two sheets contain exported information from our software.
 |  |  |  |  |  |  |  | The refresh page button runs a macro that fills down and deletes rows that are not used.
 |  |  |  |  |  |  |  | Now the tricky part.
 |  |  |  |  |  |  |  | The customer wants this report to show employees only if they HAVEN'T had
 |  |  |  |  |  |  |  | 11 hours off in-between shifts.
 |  |  |  |  |  |  |  | The clocking in times of the employees are shown in cells G-U (t_Attendance_data)
 |  |  |  |  |  |  |  | I need to somehow only display those who HAVEN'T had that break, but
 |  |  |  |  |  |  |  | I am very unsure how on how to go about this.
 |  |  |  |  |  |  |  | I'd imagine that you would need to create a formula to display text only
 |  |  |  |  |  |  |  | if the criteria is met for that employee, then use a filter to hide the "blanks"
 |  |  |  |  |  |  |  | We could potentially adjust the script used to export the data,
 |  |  |  |  |  |  |  | but my colleague who creates them has very little time and
 |  |  |  |  |  |  |  | this will require a whole re-write of the entire script.
 |  |  |  |  |  |  |  | Any suggestions on this would be highly appreciated!
Spreadsheet: kimberly_watson__20634__tw_priority_rate
Sheet: 9911

Contract | [NAME] Id | Rate | Modifications as of 11/05/1999 |  |  |  | Update eff 1/1/2000
8255 | GRD | 0.0076 |  |  |  |  | 0.0066
8255 | RES | 0.3168
8255 | SCS | 0.0686
8255 | TC2 | 0.0051
8255 | TC6 | 0.0007
20715 | RES | 0.1031
20746 | SCS | 0.0443
20746 | TC2 | 0.0041
20746 | TC6 | 0.0004
20747 | GRD | 0.0076 |  |  |  |  | 0.0066
20747 | RES | 0.2554
20747 | SCS | 0.0369
20747 | TC2 | 0.0052
20747 | TC6 | 0.0007
20748 | GRD | 0.0047 |  |  |  |  | 0.004
20748 | RES | 0.2554
20748 | SCS | 0.0369
20748 | TC2 | 0.0052
20748 | TC6 | 0.0007
20755 | GRD | 0.0044
20822 | GRD | 0.0047 |  |  |  |  | 0.004
20822 | RES | 0.1647
20822 | SCS | 0.0369
20822 | TC2 | 0.0023
20822 | TC6 | 0.0003
20834 | RES | 0.1031
20835 | RES | 0.1031
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
21165 | SCS | 0.0443
21165 | TC2 | 0.005
21165 | TC6 | 0.0007
21172 | RES | 0.101
21175 | RES | 0.1031
23795 | GRD | 0.0044
24360 | TC2 | 0.0034
25923 | RES | 0.1031
25924 | RES | 0.2554
25924 | SCS | 0.0443
25924 | TC2 | 0.0053
25924 | TC6 | 0.0007
26371 | RES | 0.1031
26372 | GRD | 0.0076 |  |  |  |  | 0.0066
26372 | RES | 0.2554
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
26678 | GRD | 0.0076 |  |  |  |  | 0.0066
26678 | RES | 0.2554
26678 | SCS | 0.0443
26678 | TC2 | 0.0051
26678 | TC6 | 0.0007
Spreadsheet: 89173d1288917892-vlookup-with-sumif-excel_forum_752045
Sheet: SUMMARY

Month: | 2010-09-01 00:00:00 |  |  |  | 21 | 2010-09-01 00:00:00
Location | Widgets |  | SHOULD BE | results
A | 65 |  | 150 | 150
B | 96 |  | 96 | 96
C | 62 |  | 71 | 71
Spreadsheet: 727692d1618038383-help-with-irr-and-price-to-value-irr-excel-workbook
Sheet: Sheet1

Life Expectency
Estimation Sheet
 | Insured:
 | Carrier: |  |  | Type: | Universal |  |  | Illustration Date: | 2021-01-01 00:00:00
 | Policy #: |  |  | Rating: | A |  |  | Life Expectancy Date: | 2021-01-01 00:00:00
 |  |  | Colva optimized premiums beginning on 4/11/2021.
 | Comments:
 | Age of Insured: |  |  |  | Face Value: | 8500000 | Percent |  | Premium as
 | Life Expectancy: |  |  |  | Cash Value: |  | of Face |  | % of Face
 | LE Evaluator: |  | Convergence |  | Sales Price: | 525000
 |  |  |  |  | LE Month:    105 |  | IRR at LE: | 0.1107
 |  |  | Year | Age | Year | Premium | Accum. Cost | IRR | Price to Value
 |  |  | 2022 | 89 | 1 | 325641 |  | 12.5203 | 0.1001
 |  |  |  |  |  | 401297
 |  |  |  |  |  | 445806
 |  |  |  |  |  | 490289
 |  |  |  |  |  | 534737
 |  |  |  |  |  | 579155
 |  |  |  |  |  | 638988
 |  |  |  |  |  | 705566
 |  |  |  |  |  | 776697
 |  |  |  | 99 |  | 852521
 |  |  |  | 100 |  | 933096
 |  |  |  | 101 |  | 1018273
 |  |  |  |  |  | Please show me what formula to use for I19 and J19.  Thanks!
Spreadsheet: 37d3b11d-5af8-4b33-833e-f12599a20e67
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
259079 | 64040 | Lochi | Lochner | RSA |  | 00:44:47 | 00:00:00 | 01:19:28 | 00:00:00 | 00:24:41 | 1 | 02:28:56
259079 | 16436 | [NAME] | [NAME] | RSA |  | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2 | [NAME]
Spreadsheet: 94a4633c-e795-4906-b28e-267a2d4fd4a9
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
FPHAS | Test | FPHAS | Phadiatop (Allergy Screen) | Phadiatop (Allergy Screen) | Enzyme Immunoassay | Plain, Red-Top Tube: Red |  |  | 1 | mL | Draw blood in a plain red-top tube(s), serum gel tube(s) is acceptable. Spin down and send 1 mL of serum refrigerated in a plastic vial. | 0.5 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	Mild OK; Gross reject Icterus	NA Other	NA | Negative The Phadia Phadiatop test is an allergy screening test with excellent sensitivity and specificity for inhalant allergy. It uses an ImmunoCAP with a balanced mixture of representative allergens, including grasses, trees, weeds, cat, dog, mites and molds. A positive result indicates that the patient is allergic to one or more of these allergens; a negative indicates the patient is not allergic to inhalant allergens. Note that the test does not assess a patient's sensitivity to food, drug, chemical or certain unusual or rare allergens.  Test Performed by: Viracor-IBT Laboratories                              1001 NW Technology Dr.                              Lee's Summit, MO 64086 | Monday through Friday | 1 -2 days | 3 - 6 days | 1 | 86005 |  |  |  |  | Viracor-IBT Laboratories
FPHAS | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 28 days
FPHAS | Result | FPHAS | Phadiatop (Allergy Screen) | Phadiatop (Allergy Screen) | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: kate_symes__18190__EESSales_dailymarch
Sheet: 2-9

NP15 | 2001-02-09 00:00:00 |  |  |  |  |  | SP15 |  |  |  |  |  |  |  | ZP26
Fixed Peak | 226 | Fixed Off Peak | 208.5 |  |  |  | Fixed Peak | 163.78 |  | Fixed Off Peak | 135.71 |  |  |  | Fixed Peak |  | Fixed Off Peak
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 | 0 | 0 | -10.29 | -10.29 |  |  | 1 | -267.83 | 0 | -54 | -269.83 |  |  | 1 | -2.03 | 0 | 0 | -2.03
2 | 0 | 0 | -9.42 | -9.42 |  |  | 2 | -268.96 | 0 | -54 | -258.96 |  |  | 2 | -2 | 0 | 0 | -2
3 | 0 | 0 | -8.87 | -8.87 | 0 |  | 3 | -269.22 | 0 | -44 | -254.22 |  |  | 3 | -1.98 | 0 | 0 | -1.98
4 | 0 | 0 | -8.7 | -8.7 |  |  | 4 | -270.22 | 0 | -44 | -256.22 |  |  | 4 | -1.97 | 0 | 0 | -1.97
5 | 0 | 0 | -8.9 | -8.9 |  |  | 5 | -269.98 | 0 | -44 | -267.98 |  |  | 5 | -1.98 | 0 | 0 | -1.98
6 | 0 | 0 | -11.24 | -11.24 |  |  | 6 | -267.32 | 0 | -54 | -298.32 |  |  | 6 | -2.08 | 0 | 0 | -2.08
7 | 0 | 0 | -14.66 | -14.66 |  |  | 7 | -341.15 | 0 | -54 | -288.15 |  |  | 7 | -2.21 | 0 | 0 | -2.21
8 | -0.35 | 0 | -17 | -17.35 |  |  | 8 | -339.03 | 0 | -54 | -313.03 |  |  | 8 | -2.33 | 0 | 0 | -2.33
9 | -1.08 | 0 | -17 | -18.08 |  |  | 9 | -337.85 | 0 | -54 | -339.85 |  |  | 9 | -2.36 | 0 | 0 | -2.36
10 | 0 | 0 | -16.96 | -16.96 |  |  | 10 | -339.72 | 0 | -54 | -361.72 |  |  | 10 | -2.31 | 0 | 0 | -2.31
11 | -0.62 | 0 | -17 | -17.62 |  |  | 11 | -338.74 | 0 | -54 | -374.74 |  |  | 11 | -2.35 | 0 | 0 | -2.35
12 | -1.67 | 0 | -17 | -18.67 |  |  | 12 | -337.92 | 0 | -54 | -375.92 |  |  | 12 | -2.38 | 0 | 0 | -2.38
13 | -1.64 | 0 | -17 | -18.64 |  |  | 13 | -337.35 | 0 | -54 | -377.35 |  |  | 13 | -2.39 | 0 | 0 | -2.39
14 | -1.2 | 0 | -17 | -18.2 |  |  | 14 | -337.69 | 0 | -54 | -377.69 |  |  | 14 | -2.36 | 0 | 0 | -2.36
15 | -0.59 | 0 | -17 | -17.59 |  |  | 15 | -338.73 | 0 | -54 | -373.73 |  |  | 15 | -2.34 | 0 | 0 | -2.34
16 | -0.89 | 0 | -17 | -17.89 |  |  | 16 | -337.98 | 0 | -54 | -364.98 |  |  | 16 | -2.35 | 0 | 0 | -2.35
17 | -1.47 | 0 | -17 | -18.47 |  |  | 17 | -337.92 | 0 | -54 | -351.92 |  |  | 17 | -2.37 | 0 | 0 | -2.37
18 | -4.46 | 0 | -17 | -21.46 |  |  | 18 | -334.1 | 0 | -54 | -345.1 |  |  | 18 | -2.51 | 0 | 0 | -2.51
19 | -5.18 | 0 | -17 | -22.18 |  |  | 19 | -334.15 | 0 | -54 | -337.15 |  |  | 19 | -2.54 | 0 | 0 | -2.54
20 | -2.41 | 0 | -17 | -19.41 |  |  | 20 | -336.39 | 0 | -54 | -325.39 |  |  | 20 | -2.42 | 0 | 0 | -2.42
21 | -0.71 | 0 | -17 | -17.71 |  |  | 21 | -338.29 | 0 | -54 | -315.29 |  |  | 21 | -2.35 | 0 | 0 | -2.35
22 | 0 | 0 | -16.17 | -16.17 |  |  | 22 | -340.44 | 0 | -54 | -294.44 |  |  | 22 | -2.28 | 0 | 0 | -2.28
23 | 0 | 0 | -14.32 | -14.32 |  |  | 23 | -264.4 | 0 | -54 | -315.4 |  |  | 23 | -2.2 | 0 | 0 | -2.2
24 | 0 | 0 | -12.07 | -12.07 |  |  | 24 | -266.82 | 0 | -54 | -292.82 |  |  | 24 | -2.11 | 0 | 0 | -2.11
Spreadsheet: 01f6d33b-44c1-4c9f-850d-e963fe116aff
Sheet: Sheet1

State of New Hampshire - Primary Election | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
State Representatives - COOS County - Democratic
District No. 1 (2) | Enman, d | Daugherty, r | [NAME], Jr. r | Rappaport, r | [NAME]
Atkinson & Gilmanton Ac Gt
Cambridge | 1
[NAME] | 14 |  |  | 1
Colebrook | 85 | 4 | 2 | 2 | 7
Columbia | 22 |  |  |  | 1
Dix's Grant
Dixville | 1
Errol | 36
Erving's Location
[NAME] | 2
[NAME]
Pittsburg | 37 |  |  |  | 1
Second College Grant
Stewartstown | 20
[NAME] | 29
Wentworth's Location | 3
TOTALS | 250 | 4 | 2 | 3 | 9
District No. 2 (1) | Moynihan, d | Tierney, Jr., r | [NAME]
Dummer | 24
Milan | 98
Northumberland | 121 |  | 42
[NAME] | 36
TOTALS | 279
District No. 3 (3) | Coulombe, d | Theberge, d | [NAME], d | [NAME]
Berlin | 727 | 798 | 699 | 5
District No. 4 (1) | Merner, d | [NAME], r | [NAME]
[NAME] | 38
Kilkenny
Lancaster | 133 | 1 | 16
TOTALS | 171 | 1 | 16
District No. 5 (1) | Hammon, d | Tholl, Jr., r | [NAME]
Carroll | 60 |  | 2
[NAME] | 61 |  | 2
Randolph | 73
[NAME] | 128 |  | 3
TOTALS | 322 |  | 7
District No. 6 (1) | Hatch, d | [NAME]
Bean's Grant
Bean's Purchase
[NAME]'s Purchase
Crawford's Purchase
Cutt's Grant
[NAME] | 263 | 3 |  |  | 266
Green's Grant
Hadley's Purchase
Low and Burbank's Gt.
Martin's Location
[NAME]'s Grant
Sargent's Purchase
Shelburne | 42 |  |  |  | 42
Success
[NAME] and [NAME]'s Pur
TOTALS | 305 | 3 |  |  | 308
District No. 7 (1) FL | Merrick, d | [NAME], r | Rideout, r | Young, r | [NAME]
Carroll | 59 |  |  |  | 2
[NAME] | 43
Dummer | 21
[NAME] | 60 |  |  |  | 1
Kilkenny
Lancaster | 167 | 3 | 5 |  | 6
Milan | 85
Northumberland | 132
Randolph | 73
[NAME] | 34 | 2 |  | 1
[NAME] | 124 | 2 | 1
TOTALS | 798 | 7 | 6 | 1 | 9
Spreadsheet: 868314d1715034973-calculating-start-time-when-shifts-go-past-midnight-schedule-example-tms
Sheet: Sheet1

Date | ID | Start | Stop
2102024 | 316048 | 21:00:00 | 01:00:00 |  |  |  |  |  | One formula. Does not need intermediate calculations in columns E and F
2102024 | 316048 | 01:30:00 | 05:00:00
2102024 | 316048 | 05:30:00 | 08:00:00
2102024 | 312969 | 22:00:00 | 01:30:00
2102024 | 312969 | 02:00:00 | 05:30:00
2102024 | 312969 | 06:00:00 | 09:00:00
2102024 | 313972 | 21:00:00 | 00:00:00
2102024 | 313972 | 04:31:00 | 07:00:00
2102024 | 21396 | 22:34:00 | 00:00:00
2102024 | 21396 | 01:00:00 | 02:30:00
2102024 | 21396 | 03:04:00 | 04:30:00
2102024 | 21396 | 04:32:00 | 07:00:00
2102024 | 22114 | 15:31:00 | 20:00:00
2102024 | 22114 | 20:30:00 | 00:00:00
2102024 | 22189 | 15:30:00 | 19:30:00
2102024 | 22189 | 20:04:00 | 00:00:00
2102024 | 22255 | 22:31:00 | 03:00:00
Spreadsheet: mary_fischer__25630__1581 - 2001
Sheet: ELIST.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 1581 |  | (Please print)  PREPARED BY: | [NAME]
E-SCHEDULES CHECK LIST
For the period ending: 06/30/2001 |  | REVIEWED BY: | [NAME]
*  PRIORITY SCHEDULE
SCH | CONSOL ACCT | QUARTERLY SCHEDULES | COMPLETED or N/A
E-1 | 053, 060 | A/R - Other | N/A
E-2 * | 195 | Other Current Assets | N/A
E-3 * | TOT_INVEST_SUBS | Investment in Unconsolidated
 | TOT_EQEARN_OTH | Affiliates, Partnerships & Joint Ventures | N/A
E-4 * | 269, 270, 280 | Merchant and Other Investments | N/A
E-5 | 344 | Goodwill | N/A
E-6 * | TOT_PPE | Property, Plant & Equipment
 | [NAME] | Depreciation, Depletion & Amortization | N/A
[NAME] * | 343, 360 | Other Deferred Charges | N/A
E-11* | 655 | Other Current Liabilities | N/A
E-12 * | 450,  TOT_NP_OTHER | Short-Term and Long-Term Debt | N/A
 | 770,  705,  775,  765
E-14* | 860 | Other Deferred Credits | N/A
E-15 | 855 | Minority Interests | N/A
E-16* | 1676 | (Gain) Loss on Sales of Assets | N/A
E-20* | 1690, 1775 | Other Income and Other Deductions | N/A
E-21 |  | Lease Expense & Future Lease Commitments | N/A
E-31 |  | Reconciliation of Stockholder's Equity and Investment in Subs | completed
E-36 | TOT_INVEST_SUBS | Investee's Summarized Information | N/A
 | TOT_EQEARN_OTH
 |  | ADDITIONAL SCHEDULES FOR YEAR END ONLY
E-18 | 65, 641, 815, 840 | Analysis of Reserve Items | N/A
Spreadsheet: 146982d1332448181-vacation-accrual-formula-2012_vacation_tracker-v2
Sheet: Calendar

 |  |  |  |  |  |  |  | Manipulate slider to select desired year
 | 2012
 |  | January |  |  |  |  |  |  |  | April |  |  |  |  |  |  |  | July |  |  |  |  |  |  |  | October
 |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S
 |  | February |  |  |  |  |  |  |  | May |  |  |  |  |  |  |  | August |  |  |  |  |  |  |  | November
 |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S
 |  | March |  |  |  |  |  |  |  | June |  |  |  |  |  |  |  | September |  |  |  |  |  |  |  | December
 |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S
Spreadsheet: 103616d1301359477-grouping-numbers-together-buckets
Sheet: Sheet1

 |  |  |  |  |  |  |  | Lowest Prices
 | Part Number | Price | 1stRow | [NAME] | AddToEnd |  |  | Bucket 1 | Bucket 2 | Bucket 3 | Bucket 4
 | 000-1 | 3.55 |  |  | 0 |  | 000-1
 | 000-1 | 3.65 |  |  |  |  | 000-2
 | 000-1 | 5.5 |  |  |  |  | 000-3
 | 000-1 | 5.55
 | 000-1 | 6
 | 000-1 | 6.5
 | 000-1 | 4.25
 | 000-1 | 9.8
 | 000-1 | 7.6
 | 000-1 | 12
 | 000-1 | 14
 | 000-1 | 2.5
 | 000-2 | 2.44
 | 000-2 | 5.56
 | 000-2 | 8.78
 | 000-2 | 1.78
 | 000-2 | 2.39
 | 000-2 | 2.33
 | 000-2 | 2.76
 | 000-2 | 2.05
 | 000-2 | 1.72
 | 000-2 | 3.75
 | 000-2 | 15.95
 | 000-2 | 10
 | 000-2 | 3.46
 | 000-2 | 1.85
 | 000-2 | 3.67
 | 000-2 | 3.7
 | 000-2 | 5.15
 | 000-3 | 6
 | 000-3 | 7
 | 000-3 | 5
 | 000-3 | 4
 | 000-3 | 6.5
 | 000-3 | 7.5
Spreadsheet: 140111d1328625300-excel-2007-conditional-formatting-between-dates-help-0127
Sheet: Sheet1

 |  |  |  | 2012-01-02 00:00:00 | 2012-01-09 00:00:00 | 2012-01-16 00:00:00 | 2012-01-23 00:00:00 | 2012-01-30 00:00:00 | 2012-02-06 00:00:00 | 2012-02-13 00:00:00 | 2012-02-20 00:00:00 | 2012-02-27 00:00:00 | 2012-03-05 00:00:00 | 2012-03-12 00:00:00 | 2012-03-19 00:00:00 | 2012-03-26 00:00:00 | 2012-04-02 00:00:00 | 2012-04-09 00:00:00 | 2012-04-16 00:00:00 | 2012-04-23 00:00:00 | 2012-04-30 00:00:00 | 2012-05-07 00:00:00 | 2012-05-14 00:00:00 | 2012-05-21 00:00:00 | 2012-05-28 00:00:00 | 2012-06-04 00:00:00 | 2012-06-11 00:00:00 | 2012-06-18 00:00:00 | 2012-06-25 00:00:00 | 2012-07-02 00:00:00 | 2012-07-09 00:00:00 | 2012-07-16 00:00:00 | 2012-07-23 00:00:00 | 2012-07-30 00:00:00 | 2012-08-06 00:00:00 | 2012-08-13 00:00:00 | 2012-08-20 00:00:00 | 2012-08-27 00:00:00 | 2012-09-03 00:00:00 | 2012-09-10 00:00:00 | 2012-09-17 00:00:00 | 2012-09-24 00:00:00 | 2012-10-01 00:00:00 | 2012-10-08 00:00:00 | 2012-10-15 00:00:00 | 2012-10-22 00:00:00 | 2012-10-29 00:00:00 | 2012-11-05 00:00:00 | 2012-11-12 00:00:00 | 2012-11-19 00:00:00 | 2012-11-26 00:00:00 | 2012-12-03 00:00:00 | 2012-12-10 00:00:00 | 2012-12-17 00:00:00 | 2012-12-24 00:00:00 | 2012-12-31 00:00:00
 |  | 8 |  | January |  |  |  |  | February |  |  |  | March |  |  |  | April |  |  |  |  | May |  |  |  | June |  |  |  | July |  |  |  |  | August |  |  |  | September |  |  |  |  | October |  |  |  |  | November |  |  |  | December
 |  |  |  | 1 | 2 | 3 | 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 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53
 |  | Date From | Date To | 2 | 9 | 16 | 23 | 30 | 6 | 13 | 20 | 27 | 5 | 12 | 19 | 26 | 2 | 9 | 16 | 23 | 30 | 7 | 14 | 21 | 28 | 4 | 11 | 18 | 25 | 2 | 9 | 16 | 23 | 30 | 6 | 13 | 20 | 27 | 3 | 10 | 17 | 24 | 1 | 8 | 15 | 22 | 29 | 5 | 12 | 19 | 26 | 3 | 10 | 17 | 24 | 31
8 | 10 | 2012-02-22 00:00:00 | 2012-03-04 00:00:00
Spreadsheet: 3724da69-85a3-4eca-b299-2cb8d197e638
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
261301 | 60932 | Mark | [NAME] | USA | 3057 | 00:09:59 | 00:03:14 | 00:37:42 | 00:02:24 | [NAME] | 1 | 01:20:12
261301 | 22133 | Mohamed | Lahna | MAR | 3058 | 00:12:19 | 00:02:17 | [NAME] | 00:01:21 | 00:31:02 | 2 | 01:23:51
261301 | 7986 | [NAME] | Perkins | USA | 3056 | 00:13:26 | [NAME] | 00:40:38 | 00:02:06 | 00:35:08 | 3 | 01:34:06
261301 | 7987 | Grant | [NAME] | CAN | 3061 | 00:12:11 | 00:03:04 | 00:41:01 | 00:02:55 | 00:39:31 | 4 | 01:38:41
261301 | 70011 | [NAME] | Pruett | USA | 3062 | 00:12:19 | 00:04:52 | 00:50:55 | 00:02:28 | 00:33:06 | 5 | [NAME]
261301 | 43855 | Travis | Ricks | USA | 3059 | 00:19:21 | 00:03:07 | 00:47:25 | 00:03:14 | 00:34:29 | 6 | 01:47:33
Spreadsheet: 126918d1320060879-formulas-from-columns-to-rows-between-data-sheets-book1_shatan1984
Sheet: Sheet1

Data1 | abc1
Data2 | abc2
Data3 | abc3
Data4 | abc4
Data5 | [NAME]
Data6 | abc6
Data7 | [NAME]
Data8 | abc8
Data9 | abc9
Data10 | abc10
Data11 | abc11
Data12 | abc12
Data13 | abc13
Data14 | abc14
Data15 | abc15
Data16 | abc16
[NAME] | abc17
Data18 | abc18
Data19 | abc19