tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: cd6894fe-145e-493b-adfb-e8e6cbf37fbd
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
FAEAB | Test | FAEAB | Anti-Enterocyte Antibodies | Anti-Enterocyte Antibodies | Indirect Immunofluorescence | Plain, Red-Top Tube: Red |  |  | 2 | mL | Collect blood in red-top no additive tube and submit 2 mL of serum shipped frozen.   REQUIRED to accompany all specimens (testing will not proceed until all requirements are met): 1.      Completed clinical summary/medical history form            2.   See Special Instructions for a copy of the form. | 1mL | Hemolysis	NA Thawing	Warm reject; Cold reject Lipemia	NA Icterus	NA Other	NA | IgG: Negative IgA: Negative IgM: Negative   Test Performed by: The Children's Hospital of Philadelphia                               Main Bldg 5th Floor Rm 5203                               34th Street and Civic Center Blvd.                               Philadelphia, PA 19104-4318 | Batched | 4 - 8 weeks | 4 - 8 weeks | 3 | 88347 |  |  |  |  | The Children's Hospital of Philadelphia Main Bldg 5th Floor Rm 5
FAEAB | [NAME] | SRED | Serum Red |  |  |  | Frozen
FAEAB | Result | Z1700 | Anti-Enterocyte Antibodies | Anti-Enterocyte Antibodies | Numeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FAEAB | Result | Z1687 | Dilution of Serum | Dilution of Serum | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FAEAB | Result | Z1688 | IgG | IgG | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FAEAB | Result | Z1689 | IgA | IgA | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FAEAB | Result | [NAME] | IgM | IgM | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FAEAB | Result | Z1691 | Signed | Signed | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 215251d1361315237-formula-to-return-an-offset-value-depending-on-a-condition-report-looking-right-first-column-faster-formula
Sheet: Write Term Report

 | Writing Progress Term Assessment |  |  |  |  | Year.6 |  |  | [NAME] |  |  |  | 2013-02-10 00:00:00 |  |  |  |  |  | http://www.excelforum.com/excel-formulas-and-functions/898777-formula-to-return-an-offset-value-depending-on-a-condition.html
 |  | Autumn Term |  |  | [NAME] |  |  | [NAME]
 | Name | T1 | T1 | Levels | T2 | T2 | Levels | T3 | T3 | Levels |  | YTD | Comments
 |  | Start | Finish | Moved | Start | Finish | Moved | Start | Finish | Moved |  | Levels
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  | 88
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Do Not Remove |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wc | 1 | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wb | 2 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wa | 3 | 11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1c | 4 | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1b | 5 | 13
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1a | 6 | 14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2c | 7 | 15 |  |  |  |  |  |  |  |  |  |  | 1c
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2b | 8 | 16
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2a | 9 | 17
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3c | 10 | 18
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3b | 11 | 19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3a | 12 | 20 |  |  |  |  |  |  |  |  |  |  | 1c
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4c | 13 | 21
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4b | 14 | 22
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4a | 15 | 23
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5c | 16 | 24 |  |  |  |  |  |  |  |  |  |  | 1c
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5b | 17 | 25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5a | 18 | 26
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 27 |  |  |  |  |  |  |  |  |  |  | 2c
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33
Spreadsheet: michelle_lokay__26617__imbalsumm0102
Sheet: GPM

 | 23995 |  | 22051
 | 59687 |  | 10703
Day | Measured | Scheduled | Measured | Scheduled
1 | 25933 | 25000 | 24799 | 24000
2 | 26491 | 25000 | 24763 | 24000
3 | 25000 | 25000 | 24413 | 24000
4 | 24987 | 25000 | 24265 | 24000
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
2001-01-31 00:00:00 | Balance | -772485 |  | -64735
2001-02-04 00:00:00 | Balance
 | Contract #
 | 22864 |  |  |  | -58339.66
 | 20379 |  |  |  | -51695.87
 | 21459 |  |  |  | 10570.56
 | 26357 |  |  |  | 44144.84
 | 21544 |  |  |  | 61340.16
 | 24532 |  |  |  | -186461.09
 | Total Duke
Spreadsheet: 456933d1461135434-new-variable-based-on-multiple-date-ranges-nested-ifs-book1
Sheet: Sheet1

2014-01-01 00:00:00 |  |  |  |  | 1A
2014-01-02 00:00:00 |  |  |  |  | 1A
2014-01-03 00:00:00 |  |  |  |  | 1A
2014-01-04 00:00:00 |  |  |  |  | 1A
2014-01-05 00:00:00 |  |  |  |  | 1B
2014-01-06 00:00:00 |  |  |  |  | 1B
2014-01-07 00:00:00 |  |  |  |  | 1B
2014-01-08 00:00:00 |  |  |  |  | 1B
2014-01-09 00:00:00 |  |  |  |  | 1C
2014-01-10 00:00:00 |  |  |  |  | 1C
2014-01-11 00:00:00 |  |  |  |  | 1C
2014-01-12 00:00:00 |  |  |  |  | 1C
2014-01-13 00:00:00 |  |  |  |  | Other
2014-01-14 00:00:00 |  |  |  |  | 1D
2014-01-15 00:00:00 |  |  |  |  | 1D
2014-01-16 00:00:00 |  |  |  |  | 1D
2014-01-17 00:00:00 |  |  |  |  | 1D
2014-01-18 00:00:00 |  |  |  |  | 1E
2014-01-19 00:00:00 |  |  |  |  | 1E
2014-01-20 00:00:00 |  |  |  |  | 1E
2014-01-21 00:00:00 |  |  |  |  | 1E
2014-01-22 00:00:00 |  |  |  |  | Other
2014-01-23 00:00:00 |  |  |  |  | Other
2014-01-24 00:00:00 |  |  |  |  | Other
2014-01-25 00:00:00 |  |  |  |  | Other
2014-01-26 00:00:00 |  |  |  |  | Other
2014-01-27 00:00:00 |  |  |  |  | Other
2014-01-28 00:00:00 |  |  |  |  | Other
2014-01-29 00:00:00 |  |  |  |  | Other
2014-01-30 00:00:00 |  |  |  |  | Other
2014-01-31 00:00:00 |  |  |  |  | Other
2014-02-01 00:00:00 |  |  |  |  | Other
2014-02-02 00:00:00 |  |  |  |  | Other
2014-02-03 00:00:00 |  |  |  |  | Other
2014-02-04 00:00:00 |  |  |  |  | Other
2014-02-05 00:00:00 |  |  |  |  | Other
2014-02-06 00:00:00 |  |  |  |  | Other
2014-02-07 00:00:00 |  |  |  |  | Other
2014-02-08 00:00:00 |  |  |  |  | Other
2014-02-09 00:00:00 |  |  |  |  | Other
Spreadsheet: 54435d1254413059-search-for-text-within-a-string-lookup-and-then-return-item-701479_raoul_duke
Sheet: Sheet1

Film | [NAME] | [NAME] | Inc. [NAME] | Tag | Channel
How To Apply Bridal Makeup | Mascara | Powder | Beauty | Beauty | Beauty
How To Fight A Donkey
How To Write Excel Formulae |  |  |  | Tech | Tech
How To use iPod |  |  |  | Tech | Tech
How To Make Meat Feast Pizza |  |  |  | Food
How To Make Carrot Cake |  |  |  | Food | Food
Spreadsheet: eric_saibi__9846__100801
Sheet: Onondaga 01

Owner Name | Aquila Energy Corporation
Station Name | [NAME]
Unit Name | Unit 01 CT/HRSG
NERC Region | NPCC
State | NY
Fuel Type | Natural Gas
Capacity | 54 MW
Start Date | 2001-09-21 00:00:00
End Date | 2001-10-18 00:00:00
Prv. Start Date | 2001-09-21 00:00:00
Prv. End Date | 2001-10-04 00:00:00
Comments | Comb Insp. / Maintenance
SIC | 4931
Plant ID | 1013844
Unit ID | 1011791
Outage ID | 18430
Spreadsheet: 81847d1281992059-distribute-value-in-a-cell-to-different-column-based-on-condition-monthly-quantity-distribution_2003
Sheet: Sheet1

 |  |  |  |  |  |  | Project Month
 |  |  |  |  |  |  | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | 2011-07-01 00:00:00 | 2011-08-01 00:00:00 | 2011-09-01 00:00:00 | 2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00 | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00
Sl No | Discipline | UOM | Quantity | Duration | Start Month | Type | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
1 | Steel | MT | 1000 | 5 | 2 | BS |  | 80 | 240 | 360 | 240 | 80
2 | Equipment | MT | 2000 | 6 | 6 | LI |  |  |  |  |  | 333.3333333333333 | 333.3333333333333 | 333.3333333333333 | 333.3333333333333 | 333.3333333333333 | 333.3333333333333
3 | Piping Fabrication | Inch Dia | 10000 | 10 | 3 | TR |  |  | 200 | 700 | 1100 | 1500 | 1500 | 1500 | 1500 | 1100 | 700 | 200
4 | Piping Erection | Inch Dia | 20000 | 10 | 7 | TB |  |  |  |  |  |  | 600 | 1200 | 1800 | 2000 | 2800 | 2800 | 2800 | 2600 | 1800 | 1600
5 | Piping Testing | Inch Dia | 30000 | 8 | 13 | TF |  |  |  |  |  |  |  |  |  |  |  |  | 3525 | 4875 | 6000 | 6000 | 4200 | 2550 | 1650 | 1200
Note |  |  |  |  |  |  | The values in the cells from H4:AA8 is mannually fed based on quantities in D Column, duration in E Column,
 | BS - Bell Shaped |  |  |  |  |  | Starting from value based on F Column and finally type of distribution in G Column
 | LI - Linear |  |  |  |  |  | G Column will suggest whether distribution will follow bell shaped curve or linear curve or Trapezoidal curve.
 | TR - Trapezoidal |  |  |  |  |  | I request you friends to help me in either fill it with formula or with VBA.
 | TB - Triangle back loaded
 | TF - Triangle front loaded
Spreadsheet: 821276d1678566722-filtering-subjects-which-have-value-10-and-arrange-subjects-in-one-cell-for-each-student-book3
Sheet: Sheet1

current data
 |  |  |  |  |  |  |  | Output
Subject: | A | B | C | D |  |  |  | Name 1 | A,D
Name 1 | 10 | 0 | 0 | 10 |  |  |  | Name 2 | B,C
Name 2 |  | 10 | 10 |  |  |  |  | Name 3 | D
Name 3 | 0 | 0 | 0 | 10
Spreadsheet: darrell_schoolcraft__7331__imball0203
Sheet: Lonestar

 | 57245 |  | 500154
 | [NAME] |  | Pecos Del
Day | Measured | Scheduled | Measured | Scheduled
1 | -52125 | -53717 | -55029 | -54300
2 | -29081 | -34217 | -38945 | -44300
3 | -29493 | -34217 | -38994 | -44300
4 |  |  |  |  |  |  |  |  |  | [NAME] |  | Pecos Del |  |  | Cumulative
5 |  |  |  |  |  |  |  |  | Month | Measured | Scheduled | Measured | Scheduled | Imbalance | Balance
6 |  |  |  |  |  |  |  |  | 2000-12-01 00:00:00 | Balance as of 12/31/00 |  |  |  |  | -7752
7 |  |  |  |  |  |  |  |  | 2001-01-01 00:00:00 | -231248 | -57416 | -97420 | -261633
8 |  |  |  |  |  |  |  |  | 2001-02-01 00:00:00 | -21620 | -15000 | 0 | -5000
9 |  |  |  |  |  |  |  |  | 2001-03-01 00:00:00 | -162976 | 0 | -266 | -160000
10 |  |  |  |  |  |  |  |  | 2001-04-01 00:00:00 | -796190 | -10000 | -33222 | -771924
11 |  |  |  |  |  |  |  |  | 2001-05-01 00:00:00 | -893146 | -43184 | 0 | -842284
12 |  |  |  |  |  |  |  |  | 2001-06-01 00:00:00 | -652748 | -31034 | -332106 | -946401
13 |  |  |  |  |  |  |  |  | 2001-07-01 00:00:00 | -1299468 | -656709 | -734846 | -1410580
14 |  |  |  |  |  |  |  |  | 2001-08-01 00:00:00 | -1826791 | -534941 | -305444 | -1560630
15 |  |  |  |  |  |  |  |  | 2001-09-01 00:00:00 | -1552478 | -728692 | -117048 | -943957
16 |  |  |  |  |  |  |  |  | 2001-10-01 00:00:00 | -1139380 | -196498 | -307336 | -1322794
17 |  |  |  |  |  |  |  |  | 2001-11-01 00:00:00 | -144119 | -155994 | -1349971 | -1325152
18 |  |  |  |  |  |  |  |  | 2001-12-01 00:00:00 | -379245 | -376245 | -721032 | -724604
19 |  |  |  |  |  |  |  |  | 2002-01-01 00:00:00 | -279779 | -271068 | -1831943 | -1808648 |  |  | estimated
20
21
22
23
24
25
26
27
28
29
30
31
2002-02-28 00:00:00 |  |  |  |  | 53045
2002-03-03 00:00:00
CBS $
 |  |  | 90293.96
Spreadsheet: 115090d1310722771-delivery-dates-fabricator-status
Sheet: Supplier Delivery Status

Supplier | Package Name | PO No. | PO Date | IFC Dwgs Issued | Shop Dwgs Received | Shop Dwgs Issued | Fabrication Complete % | Promised Delivery Date | Actual Delivery Dates | Actual Delivery | Comment
Perth Cutting | Supply and fabricate as per Quote Number 33011 | 69789 | 2011-05-01 00:00:00 | YES | n/a | n/a |  | 2011-05-15 00:00:00 | 2011-05-13 00:00:00 | 2
SPM | Supply End Brackets | 78332 | 2011-06-02 00:00:00 | YES | n/a | n/a |  | 2011-06-12 00:00:00 | 2011-06-23 00:00:00 | -11
Kimono | Supply flange | 44352 | 2011-05-04 00:00:00 | YES | n/a | n/a |  | 2011-05-10 00:00:00 | 2011-05-05 00:00:00 | 5
Perth Cutting | Supply and fabricate as per Quote Number 33011 | 55533 | 2011-06-04 00:00:00 | YES | n/a | n/a |  | 2011-06-10 00:00:00 | 2011-06-15 00:00:00 | -5
Perth Cutting | Supply and fabricate as per Quote Number 33011 | 55533 | 2011-06-04 00:00:00 | YES | n/a | n/a |  | 2011-06-10 00:00:00 | 2011-06-15 00:00:00 | -5
Spreadsheet: 835537d1688647181-left-right-with-multiple-find-excel-question-left-and-right-with-find-_missing
Sheet: Feuil1

Control #'S | Breake down #1 | Breake down #2 | Breake down #3 | Breake down #4 | Breake down #5 | [NAME] down #1 | Breake down #1 | Breake down #2 | Breake down #3 | Breake down #4 | Breake down #5
111AA-222C-333BB | 111AA | 222C | 333BB
111ABC-222C-333XP | 111ABC | 222C | 333XP
111ABCDE-HIJKLM1-222C-333BB | 111ABCDE | HIJKLM1 | 222C | 333BB
176ABC-112S-111XP-112S-111XP | 176ABC | 112S | 111XP | 112S | 111XP
111ABCDE-112S-111XP-112S-111XP | 111ABCDE | 112S | 111XP | 112S | 111XP
111K-111S-111XP-111S-111K | 111K | 111S | 111XP | 111S | 111K
112S-112S-112S-112S-112S | 112S | 112S | 112S | 112S | 112S
Spreadsheet: 1ce1089a-6c3d-459d-b5dc-0f79a4a965f5
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
259424 | 64378 | [NAME] | Loesler | GER | 74 | 00:14:58 | 00:01:07 | 00:34:21 | 00:01:01 | 00:25:13 | 1 | 01:16:38
259424 | 56314 | [NAME] | Devicenzi | ITA | 71 | [NAME] | 00:00:58 | 00:34:36 | [NAME] | 00:35:24 | 2 | 01:27:17
259424 | 80943 | Giovanni | [NAME] | ITA | 75 | 00:18:49 | 00:01:12 | 00:37:23 | 00:00:47 | 00:30:10 | 3 | [NAME]
259424 | 56507 | [NAME] | Solodovnikov | RUS | 72 | [NAME] | 00:01:05 | 00:41:57 | 00:01:25 | 00:40:39 | 4 | 01:42:39
259424 | 55904 | Christian | Troger | AUT | 73 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | DQ | 00:00:00
Spreadsheet: louise_kitchen__24136__North America Plan 01-08 adj
Sheet: HR

 | Human Resources
 | 2002 Plan
 |  | 2001-09-01 00:00:00 |  | 2001 |  | 2002 |  |  | Per HC | New HC | Adj Comp |  |  | 2002
 |  | YTD Actual |  | Forecast |  | Plan |  |  |  |  |  |  |  | Plan
ENACOMP | Compensation
 | Special Pays | 0 |  |  |  | 0 |  | Compensation | 0 | 19
 | Analyst & Associate | 0 |  |  |  | 0
ENABENTX | Benefits & Payroll Taxes
ENAEMPEX | Employee Expense |  |  |  |  |  |  | Other |  | 19
ENAT&EEX | Travel & Entertainment Expense
ENAOUTSV | Outside Services | 0 |  |  |  |  |  | Total |  |  |  |  | 2206762
ENASUPP | Supplies Expense
ENAMKTEX | Marketing
ENACONTR | Charitable Contributions |  |  |  |  |  |  | [NAME] | 30000
ENARENT | Rent |  |  |  |  |  |  | Admins |  | 1
ENATECH | Technology |  |  |  |  |  |  | Staff | 41000
ENATRANS | Transportation |  |  |  |  |  |  | Analysts |  | 1
ENAOTHEX | Other Expenses |  |  |  |  |  |  | Associate |  | 2
ENATAXES | Taxes Other than Income |  |  |  |  |  |  | Specialist |  | 3
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  | Sr Specialst |  | 1
 |  |  |  |  |  |  |  | Managers |  | 4
 | Headcount |  |  | 84 |  |  |  | Directors |  | 1
 |  |  |  |  |  |  |  | General Counsel Asst
 | A&A Headcount |  |  |  |  |  |  | Vice President |  | 1
 |  |  |  |  |  |  |  | [NAME]
 | Total Headcount |  |  |  |  |  |  |  |  |  |  |  |  | 1
ENAOUTLG | Outside Legal |  |  |  |  |  |  | Benefits & Taxes |  |  | 0.2
ENAOUTTX | Outside Tax
ENAINSUR | Insurance
ENASYSDV | System Development
ENACORIT | Controllable Infrastructure
ENACORRN | Corporate Rent
ENAOTHAL | Other Allocated Direct  Expenses |  |  |  |  |  | Other Expense Calculation
ENADEPR | Depreciation & Amortization
ENAOUTSV | Outside Services | 180700.52 |  | 240934.0266666666 |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
Spreadsheet: 63318d1264222395-if-formula-defining-and-range-help-2
Sheet: Sheet1

status | DOB
junior | 1993
junior | 1993
junior | 1993
junior | 1993
amateur | 1977
amateur | 1977
amateur | 1977
amateur | 0
amateur | 0
junior | 1992
amateur | 1991
amateur | 1987
amateur | 1987
amateur | 1969
junior | 1999
junior | 1999
amateur | 1988
amateur | 1991
amateur | 1991
junior | 1995
amateur | 1991
junior | 1996
amateur | 1972
amateur | 1972
amateur | 1972
amateur | 1972
junior | 1993
junior | 1993
amateur | 1985
amateur | 1964
amateur
Spreadsheet: gstorey__12045__New TC IT tolls
Sheet: Summary

TCPL Proposed IT Tariff Changes
*Using March 12 price curves
FX | 1.555
Dawn 100% LF |  | $C/GJ
St. Clair 100% LF |  | $C/GJ
Emerson 100% LF |  | $C/GJ
 | Proposed IT Tolls ($US/MMBtu)** |  |  |  | % of %100 LF |  | Toll Change ($US/MMBtu)
 | Dawn | St. Clair | Emerson |  | All Points |  | Dawn | St. Clair | Emerson
Current IT Toll
2001-03-01 00:00:00
2001-04-01 00:00:00
2001-05-01 00:00:00
2001-06-01 00:00:00
2001-07-01 00:00:00
2001-08-01 00:00:00
2001-09-01 00:00:00
2001-10-01 00:00:00
2001-11-01 00:00:00
2001-12-01 00:00:00
2002-01-01 00:00:00
2002-02-01 00:00:00
2002-03-01 00:00:00
2002-04-01 00:00:00
2002-05-01 00:00:00
2002-06-01 00:00:00
2002-07-01 00:00:00
2002-08-01 00:00:00
2002-09-01 00:00:00
2002-10-01 00:00:00
** The IT tolls will likely remain the same until May-June 2001.
Spreadsheet: 728676d1618572580-creating-a-new-permit-register-kopie-van-permit-register-example-2
Sheet: BP

Status | BP
ABC Job Number | Address | Job Description | Client | Date of Confirmation  to Proceed | Permit  Number
ABC-21001 | Address 1 | Description 1 | Client 1 | 2021-03-05 00:00:00 | 123/123/123
ABC-21005 | Address 5 | Description 5 | Client 5 | 2021-04-10 00:00:00 | 456/456/456
ABC-21010 | Address 10 | Description 10 | Client 10 | 2021-04-15 00:00:00 | 789/789/789
Spreadsheet: 848494d1699226469-transpose-data-using-formulas-test-abhi2611-
Sheet: Topside Output

Sno | Cluster | [NAME] | Cost Category | Adjustment Type | Spend Month (MM/DD/YYYY) | Cost Local Currency | Note
1 | PDX | PDX1 | B | Manual | 2023-10-01 00:00:00 | 100
1 | PDX | PDX1 | B | Manual | 2023-11-01 00:00:00 | 100
2 | PDX | [NAME] | B | Manual | 2023-11-01 00:00:00 | 200
2 | PDX | [NAME] | B | Manual | 2023-12-01 00:00:00 | 200
3 | SFO | SFO1 | A | Manual | 2023-12-01 00:00:00 | 300
3 | SFO | SFO1 | A | Manual | 2024-01-01 00:00:00 | 300
4 | PDT | PDT1 | A | Manual | 2024-01-01 00:00:00 | 400
4 | PDT | PDT1 | A | Manual | 2024-02-01 00:00:00 | 400
4 | PDT | PDT1 | A | Manual | 2024-03-01 00:00:00 | 400
Sno | Cluster | [NAME] | Cost Category | Adjustment Type | Spend Month | Cost Local Currency
1 | PDX | PDX1 | B | Manual | Oct-23 | 100
1 | PDX | PDX1 | B | Manual | Nov-23 | 100
2 | PDX | [NAME] | B | Manual | Nov-23 | 200
2 | PDX | [NAME] | B | Manual | Dec-23 | 200
3 | SFO | SFO1 | A | Manual | Dec-23 | 300
3 | SFO | SFO1 | A | Manual | Jan-24 | 300
4 | PDT | PDT1 | A | Manual | Jan-24 | 400
4 | PDT | PDT1 | A | Manual | Feb-24 | 400
4 | PDT | PDT1 | A | Manual | Mar-24 | 400
Spreadsheet: 871356d1717745770-sum-across-columns-and-rows-book1-327-aligw
Sheet: Sheet1

 |  | Data
 |  | Location | Region | PRO | PRO-1 | PRO-2 | PRO-3 | PRO-4 |  |  | 3 | 10 | 0.3 | 0.4 | 0.2 | 0.1
 |  | Central Region | Region-1 | 4 | 2 | 1 | 1 | 0 |  | Eastern Region | 3 | 15 | 0.2 | 0.3333333333333333 | 0.1333333333333333 | 0.3333333333333333
 |  | Central Region | Region-11 | 3 | 0 | 1 | 1 | 1 |  | Northern Rgion | 4 | 22 | 0.2727272727272727 | 0.2272727272727273 | 0.2272727272727273 | 0.2727272727272727
 |  | Central Region | [NAME] | 3 | 1 | 2 | 0 | 0 |  | Western Region | 3 | 14 | 0.3571428571428572 | 0.4285714285714285 | 0.07142857142857142 | 0.1428571428571428
 |  | Eastern Region | Region-9 | 5 | 1 | 2 | 1 | 1
 |  | Eastern Region | Region-3 | 3 | 0 | 1 | 1 | 1 |  |  | Region-1 | 4 | 2 | 1 | 1 | 0
 |  | Eastern Region | [NAME] | 7 | 2 | 2 | 0 | 3 |  | Central Region | Region-11 | 3 | 0 | 1 | 1 | 1
 |  | Western Region | Region-4 | 6 | 2 | 3 | 0 | 1 |  | Central Region | [NAME] | 3 | 1 | 2 | 0 | 0
 |  | Western Region | Region-5 | 4 | 1 | 1 | 1 | 1 |  | Central Region | 3 | 10 | 0.3 | 0.4 | 0.2 | 0.1
 |  | Western Region | Region-8 | 4 | 2 | 2 | 0 | 0 |  | Eastern Region | Region-9 | 5 | 1 | 2 | 1 | 1
 |  | Northern Rgion | [NAME] | 6 | 2 | 3 | 0 | 1 |  | Eastern Region | Region-3 | 3 | 0 | 1 | 1 | 1
 |  | Northern Rgion | Region-6 | 8 | 2 | 0 | 3 | 3 |  | Eastern Region | [NAME] | 7 | 2 | 2 | 0 | 3
 |  | Northern Rgion | Region-10 | 3 | 2 | 1 | 0 | 0 |  | Eastern Region | 3 | 15 | 0.2 | 0.3333333333333333 | 0.1333333333333333 | 0.3333333333333333
 |  | Northern Rgion | Region-12 | 5 | 0 | 1 | 2 | 2 |  | Northern Rgion | [NAME] | 6 | 2 | 3 | 0 | 1
 |  |  |  |  |  |  |  |  |  | Northern Rgion | Region-6 | 8 | 2 | 0 | 3 | 3
 |  | Initial Working |  |  |  |  |  |  |  | Northern Rgion | Region-10 | 3 | 2 | 1 | 0 | 0
 |  |  |  |  |  |  |  |  |  | Northern Rgion | Region-12 | 5 | 0 | 1 | 2 | 2
 |  | Eastern Region | 3 | 15 | 0.2 | 0.3333333333333333 | 0.1333333333333333 | 0.3333333333333333 |  | Northern Rgion | 4 | 22 | 0.2727272727272727 | 0.2272727272727273 | 0.2272727272727273 | 0.2727272727272727
 |  | Northern Rgion | 4 | 22 | 0.2727272727272727 | 0.2272727272727273 | 0.2272727272727273 | 0.2727272727272727 |  | Western Region | Region-4 | 6 | 2 | 3 | 0 | 1
 |  | Western Region | 3 | 14 | 0.3571428571428572 | 0.4285714285714285 | 0.07142857142857142 | 0.1428571428571428 |  | Western Region | Region-5 | 4 | 1 | 1 | 1 | 1
 |  |  |  |  |  |  |  |  |  | Western Region | Region-8 | 4 | 2 | 2 | 0 | 0
 |  |  |  |  |  |  |  |  |  | Western Region | 3 | 14 | 0.3571428571428572 | 0.4285714285714285 | 0.07142857142857142 | 0.1428571428571428
Spreadsheet: 782850d1654332415-help-need-to-remove-multiple-nested-if-statements-timesheet
Sheet: Summary

TIME CARD
Month: | April | SELECT Month from Dropdown
Year: | 2022 | Change Month to Current Year
ACME |  | Person A | Person B | Person C | Person D
Day | Date | Hours Worked | Hours Worked | Hours Worked | Hours Worked
Total Employee Work Hours
Employee Signature
Approver's Signature |  |  | KEY TEAM TOTAL HOUR
Spreadsheet: 31205d1227010730-cumulative-interest-formula-interest-is-interesting
Sheet: Sheet1

 | Static Component | Inflationary Component | Expected Pension | Actual Pension | Deficit | Inflated Deficit
 | 500 | 500 | 1000 | 1000 | 0 | 0
 | 500 | 525 | 1025 | 1000 | 25 | 25
 | 500 | 551.25 | 1051.25 | 1000 | 51.25 | 77.5
 | 500 | 578.8125 | 1078.8125 | 1000 | 78.8125 | 160.1875
 | 500 | 607.7531250000001 | 1107.753125 | 1000 | 107.7531250000002 | 275.9500000000002
 | 500 | 638.1407812500001 | 1138.14078125 | 1000 | 138.1407812500001 | 427.8882812500003
 | 500 | 670.0478203125002 | 1170.0478203125 | 1000 | 170.0478203125003 | 619.3305156250008
 | 500 | 703.5502113281252 | 1203.550211328125 | 1000 | 203.5502113281252 | 853.8472527343761
 | 500 | 738.7277218945316 | 1238.727721894531 | 1000 | 238.7277218945314 | 1135.267337265626
 | 500 | 775.6641079892581 | 1275.664107989258 | 1000 | 275.6641079892581 | 1467.694812118166
Totals: | 5000 | 6288.946267774416 | 11288.94626777441 | 10000 | 1288.946267774415 | 1467.694812118166