tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 25865d1217494121-looking-up-values-and-adding-them-totals
Sheet: Sheet1

look up value |  |  |  |  |  |  | number of items | sum 10 or less | sum over 10
20 | 10 |  |  | 20 | 10 |  | 16 | 140 | 95
 | 25 |  |  | 40 | 10
 | 15 |  |  | 60 | 10
 | 35 |  |  | 80 | 50
 | 10 |  |  | 20 | 10
 | 25 |  |  | 40 | 45
 | 15 |  |  | 60 | 10
 | 35 |  |  | 80 | 10
 | 10 |  |  | 20 | 10
 | 25 |  |  | 40 | 10
 | 15 |  |  | 60 | 10
 | 35 |  |  | 80 | 10
 | 50 |  |  | 20 | 10
 | 25 |  |  | 40 | 10
 | 15 |  |  | 60 | 10
 | 35 |  |  | 80 | 10
 | 10 |  |  | 20
 | 25 |  |  | 40
 | 15 |  |  | 60
 | 35 |  |  | 80
 | 45 |  |  | 20
 | 25 |  |  | 40
 | 15 |  |  | 60
 | 35 |  |  | 80
 | 10 |  |  | 20
 | 25 |  |  | 40
 | 15 |  |  | 60
 | 35 |  |  | 80
 | 10 |  |  | 20
 | 25 |  |  | 40
 | 15 |  |  | 60
 | 35 |  |  | 80
 | 10 |  |  | 20
 | 25 |  |  | 40
 | 15 |  |  | 60
 | 35 |  |  | 80
 | 10 |  |  | 20
 | 25 |  |  | 40
 | 15 |  |  | 60
 | 35 |  |  | 80
 | 10 |  |  | 20
 | 25 |  |  | 40
 | 15 |  |  | 60
 | 35 |  |  | 80
 | 10 |  |  | 20
 | 25 |  |  | 40
 | 15 |  |  | 60
 | 35 |  |  | 80
 | 10 |  |  | 20
 | 25 |  |  | 40
 | 15 |  |  | 60
 | 35 |  |  | 80
 | 10 |  |  | 20
 | 25 |  |  | 40
 | 15 |  |  | 60
 | 35 |  |  | 80
 | 10 |  |  | 20
 | 25 |  |  | 40
 | 15 |  |  | 60
 | 35 |  |  | 80
 | 10 |  |  | 20
 | 25 |  |  | 40
 | 15 |  |  | 60
 | 35 |  |  | 80
Spreadsheet: darrell_schoolcraft__7300__imball0112
Sheet: PEPL

 | Hansford
 | 8042
Day | Measured | Scheduled
1 |  | -7000
2 |  | -4786
3 | -20568 | -4786
4 | -6999 | -10000
5 | -5845 | -10000
6 | -8331 | -10000
7 | -8430 | -10000
8 | -35058 | -17270
9 | -565 | -17270
10 | -7231 | -17270
11 | -8566 | -2270
12
13 |  | -2578
14 |  | -12000
15
16
17
18
19
20 | -22369 | -5714
21 | -8466 | -8570
22 | -16160 | -14983
23 | -16435 | -14983
24 | -16410 | -14983
25 | -16299 | -14983
26 | -16327 | -14983
27 | -44139 | -43460
28 | -12714 | -12866
29 | 0 | -20000
30 | -43416 | -20000
31 | -21780 | -20000
2001-11-30 00:00:00
2001-12-31 00:00:00
CBS Dollars
 |  |  | 151190.72
Spreadsheet: 808546d1670513065-top-ten-percentile-period_end_p11_2022
Sheet: Expected Answer

Lane_State | CORP_WK_NUM | CORP_PD_NUM | TOTAL_TOTAL
AZ--->AB | 41 | 11 | 6560.19
AZ--->AB | 42 | 11 | 11191.16
AZ--->AB | 43 | 11 | 6866.35
AZ--->AB | 44 | 11 | 9575
AZ--->BC | 41 | 11 | 5598.05
AZ--->BC | 42 | 11 | 5703.35
AZ--->BC | 43 | 11 | 11421.24
AZ--->BC | 44 | 11 | 17158.48
Spreadsheet: 69652d1270207848-formatting-problem-attaching-consolidate-target-updated
Sheet: 2010 vs 2009

Innovative  Pvt. Ltd. |  |  |  |  | Collection Analysis - 2008- 2009
 |  |  | Collection Comparisons
Collection |  |  | July to June 2010
 |  | Total | PS | BS | ES | Services | VAS
2009-10 | Lhr | 32487167 | 20428889 | 326095 | 31500 | 11700683
 | [NAME] | 230377913.41 | 79511143.22 | 75533121.95 | 15000000 | 50437323.24 | 9896325
 | ID | 72045353.05 | 57817863.93 | 0 | 0 | 14227489.12
 |  | 334910433.46 | 157757896.15 | 75859216.95 | 15031500 | 76365495.36 | 9896325
Collection |  |  | July to June 2009
 |  | Total | PS | BS | ES | Services | VAS
2008-09 | Lhr | 55782059.71055473 | -21125236.51797652 | 0 | 62166992.60037308 | 14740303.62815818 | N/A
 | [NAME] | 322637388.5650786 | 2671081.431869894 | 220099757.504866 | 46767544.48153377 | 53099005.14680897 | N/A
 | ID | 38629709.48467427 | 34425881.43444239 | 0 | 0 | 4203828.050231876 | N/A
 |  | 417049157.7603076 | 15971726.34833577 | 220099757.504866 | 108934537.0819069 | 72043136.82519902 | 0
%age
 |  | Total | PS | BS | ES | Services | VAS
 | Lhr | 0.5823945399035343 | -0.9670371729384443 |  | 0.000506699756291749 | 0.7937884656356986 | #N/A
 | [NAME] | 0.7140459276421737 | 29.76739768069823 | 0.3431767613298262 | 0.3207352484781999 | 0.9498732245651326 | #N/A
 | ID | 1.865024459440547 | 1.679488266410934 |  | 0 | 3.384412718597098 | #N/A
 |  | 0.8030478595343057 | 9.87732275831524 | 0.3446583395182655 | 0.1379865412995509 | 1.059996811983472 | #N/A
 |  | Total | PS | BS | ES | Services | VAS
 | 2009-10 | 334910433.46 | 157757896.15 | 75859216.95 | 15031500 | 76365495.36 | 9896325
 | 2008-09 | 417049157.7603076 | 15971726.34833577 | 220099757.504866 | 108934537.0819069 | 72043136.82519902 | 0
Spreadsheet: 08ee0fca-843e-40e0-80d5-337028f0723e
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
MPO | Test | MPO | Myeloperoxidase Antibodies, IgG, Serum | [NAME], S | [NAME] | Plain, Red-Top Tube: Red Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL Forms: If not ordering electronically, submit a General Request Form (Supply T239) with the specimen. | 0.35 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; [NAME] OK Other	NA | <0.4 U (negative) 0.4-0.9 U (equivocal) > or =1.0 U (positive) Reference values apply to all ages. | Monday through Saturday; 4 p.m. | 1 day | 4 days | 1 | 83516 |  |  |  |  | Rochester
MPO | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 21 days
MPO | Result | MPO | [NAME], S | [NAME], S | Numeric |  |  |  |  | U |  |  |  |  |  |  |  |  |  | 6969-0
Spreadsheet: 695294d1600138919-formula-to-extract-value-from-2-rows-below-excel-file
Sheet: Sheet2

Category | Identifier | Value | Type | Country | Instrument | Bid | Ask
Spreadsheet: e68a8f74-6fcb-478e-ad84-05b5767dbf81
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
EPIP1 | Test | EPIP1 | Epithelia Panel # 1 | Epithelia Panel # 1 | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top	 Acceptable: Serum gel [NAME]: 0.5 mL Additional Information: See Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
EPIP1 | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
EPIP1 | Result | EPIP1 | Epithelia Panel # 1 | Epithelia Panel # 1 | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 30185-3 | (Cat dander+Cow dander+Dog dander+Horse dander) Ab.IgE:ACnc:Pt:Ser:Qn:Multidisk
Spreadsheet: 268be74f-7032-420a-9b22-e23d38695001
Sheet: Sortable Performnce

 |  | 2013 Fall Semester Portfolio Performance
 |  | Name | Ticker | Value | % of Port | Today |  | 1 Week | 2013-2014 School Year | Summer 2013 | Since 4/25/13 | 2012-2013 School Year | Since 9/6/12
 |  | !Cash |  |  |  | 0
Spreadsheet: 798181d1664355082-lookup-fucntion-to-pull-information-from-many-column-formal-pmi-dashboard-v2
Sheet: BIODATA MASTER

[NAME]
 | NAME | ID NO | CODE | NO ID | NO PASSPORT | COUNTRY | FLY Y/N | EX/NON EX | AGE | HEIGHT | WEIGHT | SPONSOR/LPK/BLK | REGION | BLK | PMI LOCATION | AGENCY | NOTES
 | DINA AMELIYANI |  | JIC 005 | 12747793 | E0670726 | MALAYSIA |  | NON EX | 19 | 165 | 50 | SUNARYO | BREBES
 | EVA WIRANDIKA |  | JIC 003 | 12742833 | E0669030 | MALAYSIA |  | NON EX | 19 | 154 | 52 | [NAME] | BREBES
 | FAUZIYAH ISTIANAH |  | JIC 004 | 12742827 | E0660932 | MALAYSIA |  | NON EX | 19 | 152 | 52 | [NAME] | BREBES
 | KULSUM |  | JIC 011 | 12756127 |  | MALAYSIA |  | NON EX | 19 | 165 | 53 | SUMADI | GEGESIK
 | MEI MAYANG ANDRIYANI |  | JIC 001 | 12727840 | E0107340 | MALAYSIA |  | NON EX | 20 | 165 | 55 | SUPRI | KEBUMEN
 | MEI MAYANG ANDRIYANI |  | JIC 001 | 12727840 | E0107340 | MALAYSIA |  | NON EX | 20 | 165 | 55 | SUPRI | KEBUMEN
 | SITI NURJANAH |  | JIC 003 | 12728892 | E0669039 | MALAYSIA |  | NON EX | 19 | 149 | 50 | ENING | BREBES
 | TIARA MUSTIKASARI |  | JIC 002 | 12743972 | E0669957 | MALAYSIA |  | NON EX | 18 | 150 | 43 | ANOM | KEBUMEN
 | TRI MULYANI |  | JIC 005 | 12727901 | E0107473 | MALAYSIA |  | NON EX | 20 | 147 | 45 | JUNAEDI | TEGAL
 | VERA SINTIA |  | JIC 006 | 12727895 | E0107475 | MALAYSIA |  | NON EX | 18 | 151 | 58 | WINDI | TEGAL
 | [NAME] |  | JIC 002 | 12728895 | E0108231 | MALAYSIA |  | NON EX | 18 | 150 | 50 | ANDRE | BREBES
 | MEI MAYANG ANDRIYANI |  | JIC 001 | 12721473 | E01041123 | SINGAPORE |  | NON EX | 20 | 165 | 55 | SUPRI | KEBUMEN
 |  | *Conditional formating (highlight duplicate value)
Spreadsheet: 75041d1275562326-repeated-count-book1
Sheet: Sheet1

PO Nos | finding out | reverse way
AA | 1 |  |  | AA | 5
AA |  | 2 |  | BB | 5
AA |  | 3 |  | CC | 4
AA |  | 4 |  | DD | 3
AA |  | 5 |  | EE | 3
BB | 2 |  |  | FF | 2
BB |  | 2
BB |  | 3
BB |  | 4
BB |  | 5
CC | 3
CC |  | 2
CC |  | 3
CC |  | 4
DD | 4
DD |  | 2
DD |  | 3
EE | 5
EE |  | 2
EE |  | 3
FF | 6
FF |  | 2
Spreadsheet: 1aba76e0-1809-4333-a751-1719a9029040
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Table 1 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 |  | Mills Act Property Tax Calculator
Item |  | Factor |  | Amount |  | INFORMATION TO BE INPUT
CURRENT TAXES
Assessed Value |  |  |  | 800000 |  | ASSESSED VALUE OF PROPERTY
Total Property Tax (1) |  | 0.013057 |  | 10445.6
Property Type (1=Residential, 2=Commercial) |  | 1 | Residential |  |  | PROPERTY TYPE
 |  |  |  |  |  | Property Type (1=Residential, 2=Commercial)
MILLS ACT TAXES
Annual Income
Monthly Rent |  | 1.25 | /sq.ft./ month |  |  | ESTIMATED RENT PER SF
Leaseable Area |  | 4000 | square feet |  |  | SQUARE FOOTAGE OF PROPERTY
Annual Rent |  |  |  | 60000
(less) Annual Expenses (2) |  | 0.25 | of Annual Rent | -15000
Net Annual Income |  |  |  | 45000
Capitalization Rate
Interest (3) |  | 0.0575
Risk Component (4) |  | 0.04 |  |  |  | RISK COMPONENT
Tax Rate (1) |  | 0.013057 |  |  |  | Calculated by model based on property type input
Total, [NAME] (Land) |  | 0.110557
Amortization (5) |  | 0.01666666666666667
Total, [NAME] (Improvements) |  | 0.1272236666666667
Assessed Value & Taxes
Weighted Average Capitalization Rate (6) |  | 0.1238903333333334
Assessed Value (based on Mills Act) |  |  |  | 363224.4646474973
Total Property Tax |  | 0.013057 |  | 4742.621834902372
CHANGE IN TAXES
Decrease due to Mills Act |  |  |  | -5702.978165097627
Change compared to Current Taxes |  |  |  | -0.5459694191906284
-1 | Total property tax rate is greater than 1 percent due to tax overrides.
 | Total rate may vary slightly year-to-year, and depends on specific location.
 | Actual taxes will also depend on share of overrides which are per-parcel rather than a % of value.
-2 | Alameda County Assessor's Office assumes approximately 25 percent of income
 | goes to property maintenance and other operating expenses.
-3 | 2005-2006 State Board of Equalization Mills Act interest rate. This rate is updated no later
 | than October 1 of each year.
-4 | Risk component is 2 percent for commercial properties and 4 percent for residential
 | properties.
-5 | Amortizes improvements over 60 years.
-6 | Assumes that land comprises 20 percent of value and improvements comprise 80
 | percent of value.  Value of land is not amortized.
Spreadsheet: 812519d1673204380-help-retrieving-the-second-last-value-in-a-list-book1
Sheet: Sheet1

Q | 1 |  |  |  |  | 8
Q | 2 |  |  | W |  | 9
W | 3 |  |  | E |  | 10
E | 4 |  |  | R
W | 5
E | 6
W | 7
Q | 8
W | 9
E | 10
R | 11
E | 12
W | 13
Q | 14
Spreadsheet: benjamin_rogers__1264__NewCo-7-15-00
Sheet: FPLE_Wind Summary

 | FPLE Wind Valuation Summary
 | ('000 $)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Interest
 |  |  |  |  |  |  | Net Income |  | DCF Value |  |  |  |  |  | Target |  |  |  | Levered |  | Tax Shield |  | Debt |  | % |  | Valuation is run
 |  |  |  |  | Net MW |  | 2001 |  | Equity |  | Debt (a) |  | Total |  | Unlevered IRR |  | $/KW |  | Plant Value |  | Allocation |  | Allocation |  | by Cash Flow |  | proof
 | -  Consolidated Wind Assets
 |  | [NAME] |  |  | 42 |  |  |  |  |  | 0
 |  | Southwest Mesa |  |  | 75 |  |  |  |  |  | 0
 |  | Vansycle |  |  | 24.9 |  |  |  |  |  | 0
 | -  Non-Consolidated Wind Assets
 |  | [NAME] |  |  | 28 |  |  |  |  |  | 0
 |  | Pacific Crest (b) |  |  | 14 |  |  |  |  |  | 0
 |  | Sky River |  |  | 38.5 |  |  |  |  |  | 0
 |  | [NAME] |  |  | 15 |  |  |  |  |  | 0
 |  | Green Ridge |  |  | 82.5 |  |  |  |  |  | 0
 |  | Mojave 16/17/18 (c) |  |  | 42.5 |  |  |  |  |  | 0
 |  | Morwind |  |  | 14.5 |  |  |  |  |  | 0
 |  | Victory Garden |  |  | 11 |  |  |  |  |  | 0
 | -  Non-Core Wind Assets
 |  | WPP 92 |  |  | 15 |  |  |  |  |  | 0
 |  | WPP 91-2 |  |  | 15.5 |  |  |  |  |  | 0
 |  | Mojave 3/5 (d) |  |  | 22.1 |  |  |  | 0 |  | 0 |  | 0 |  |  |  | 0
 |  | WPP 89 |  |  | 13.8 |  |  |  |  |  | 0
 |  | WPP 91 |  |  | 12 |  |  |  |  |  | 0
 |  | WPP 90 |  |  | 7.5 |  |  |  |  |  | 0
 |  | Altamont Power (d) |  |  | 8.8 |  |  |  | 0 |  | 0 |  | 0
 | Wind Portfolio
 | (a)  FPLE debt.
 | (b)  Assumes refinancing of FPLE debt
 | (c)  DCF valuation doe not include the value of non-repowered turbines
 | (d)  Non-core assets included at book value
Spreadsheet: 708551d1607928835-array-formula-to-combine-2-numbers-into-a-matrix-matrix-numbers-ans
Sheet: Sheet1

 |  |  |  |  |  |  | 0 | 1 | 2 | 3 | 4 | 5
 |  |  |  |  |  | 0
 |  |  |  |  |  | 1
 |  |  |  |  |  | 2
 |  |  |  |  |  | 3
 |  |  |  | formula is indipendent of Matrix shown here
Spreadsheet: 133811d1324647114-vlookup-formula-dnsiaec0093r-11
Sheet: SUMMARY 2

 |  | SDV Logistics (Singapore) Pte Ltd
 |  | 101 ALPS AVE
 |  | #03-01
 |  | Singapore 498793
 |  | Tel: +65 64168333 Fax: +65 65874871
 |  | COMPANY REG NO: 198304000N
 |  | www.sdvsingapore.com
 |  |  |  |  |  |  | CONSOLIDATED INVOICE NO : | DNSIAEC0093R/11
 |  | SIA ENGINEERING CO LTD |  |  |  |  | DATE: | 2011-11-14 00:00:00
 |  | ATTN: MATERIALS DEPARTMENT
 |  | #03-M,SIAEC HANGAR 2,
 |  | 31 AIRLINE ROAD, |  |  |  |  | ACCOUNT NO. : | C00477
 |  | 819831, SINGAPORE
 | ITEM | DETAILS OF CHARGES |  |  | TOTAL INVOICE AMT |  | GST AMT | TOTAL AMOUNT
 |  | AS PER ATTACHED |  |  | 17475.16 |  | 0 | 17475.16
 |  | Total  Amount (SGD) |  |  |  |  |  | 17475.16
 | REMARKS:
Important:All transactions are subject to the Standard Trading Terms and Conditions of the Singapore Logistics Association or for airfreight, of the Singapore Aircargo Agents Associations. Copy available upon request. If there is any discrepancy, kindly c
 |  |  |  |  |  | SDV LOGISTICS (SINGAPORE) PTE LTD
Remarks: All payments should be made to SDV LOGISTICS (SINGAPORE) PTE LTD. Official receipt will be provided upon request. Invoice not paid according to the above terms of payment will carry an interest of 2% per month.
 |  |  |  |  |  | Authorised Signature
Our Bank Details: HONGKONG AND SHANGHAI BANK CORPORATION LIMITED 21 COLLYER QUAY HSBC BUILDING SINGAPORE 049320 |  |  | Account No: (SGD) 141-504977-001 (USD) 260-401419-179 SWIFT CODE: HSBCSGSG (SGD A/C)
Spreadsheet: 886233d1736264621-leave-entitlement-calculation-leave-entitlement-calculation
Sheet: Off day

Entitlement | 2025-01-01 00:00:00 | 2025-12-31 00:00:00 |  |  | FT | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8
 | 2025-12-31 00:00:00 |  |  |  | FT-M | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 |  |  | Workings: | # Leave Days by Month | Start Month | End Month | # Leave Days in |  |  | # Calendar Days in |  | # [NAME] in |  | Pro-rate Leave in |  |  | Total # Leave Days Entitled | Combined Formula | Using LET
Emp Code | Entity | Join Date | Entitle 2025 | Off days as of 31/12 | Terminated | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total Off |  |  |  |  |  | Start Month | End Month | Months Between | Start Month | End Month | Start Month | End Month | Start Month | End Month | Months Between
T-124 | FT-M | 2018-12-11 00:00:00 |  |  | 2025-01-08 00:00:00
T-148 | FT | 2022-06-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
[NAME] | FT-M | 2022-06-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
[NAME] | FT-M | 2023-12-16 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
T-154 | FT-M | 2023-12-16 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
T-166 | FT-M | 2025-07-08 00:00:00 |  |  | 2025-11-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
T-168 | FT | 2024-07-25 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
T-169 | FT-M | 2024-08-01 00:00:00 |  |  | 2025-06-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
T-171 | FT-M | 2024-08-11 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
T-175 | FT-M | 2024-08-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
T-176 | FT-M | 2024-09-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
T-177 | FT | 2024-09-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
T-178 | FT-M | 2024-09-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
T-179 | FT-M | 2024-09-01 00:00:00 |  |  | 2025-11-18 00:00:00
T-180 | FT | 2024-09-01 00:00:00
T-181 | FT | 2024-09-01 00:00:00
T-182 | FT | 2024-09-01 00:00:00
T-183 | FT-M | 2025-09-01 00:00:00 |  |  | 2025-11-18 00:00:00
T-184 | FT-M | 2024-09-01 00:00:00
T-185 | FT-M | 2024-09-01 00:00:00
Spreadsheet: 121164d1315893905-splitting-names-up-into-columns-book1
Sheet: Sheet1

 |  |  | Hide these columns
Dr [NAME] | Dr | [NAME] | Brand |  |  | Brand
Mr [NAME] | Mr | [NAME] | [NAME] | Mitchell |  | [NAME] | Mitchell
Miss Evonne Day | Miss | Evonne | Day |  |  | Day
Mr [NAME] | Mr | Clifford | Ivor | Louis | Simons | Ivor Louis | Simons
Spreadsheet: 52151d1251843396-input-table-output-table-columns-example-2
Sheet: Sheet1

 |  | Column1 | Column2
 |  | 1 | 659
 |  | 2 | 759
 |  | 3 | 859
 |  | 4 | 236
 |  | 5 | 234
 |  | 6 | 523 |  |  |  | I would like to fill the output table with values from column 2 corresponding to (in the same row) values from column 1
 |  | 7 | 6236 |  |  |  | The output table should contain the column 2 values in the same slots as the column 1 values in the input table
 |  | 8 | 2342
 |  | 9 | 3525.07142857143
 |  | 10 | 3979.30952380953 |  |  |  | Thanks a lot =)
 |  | 11 | 4433.54761904762
 |  | 12 | 4887.78571428572
 |  | 13 | 5342.02380952381
 |  | 14 | 5796.26190476191 |  |  | Input Table |  | x | y | z | x1 | y1 | z1 | x2 | y2 | z2 | etc
 |  | 15 | 6250.5
 |  | 16 | 6704.7380952381 |  |  |  | 1 | 6 | 7 | 8 | 10 | 11 | 1 | 2 | 3 | 4 | 5
 |  | 17 | 7158.97619047619 |  |  |  | 2 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21
 |  | 18 | 7613.21428571429 |  |  |  | 3 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
 |  | 19 | 8067.45238095238 |  |  |  | 4 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41
 |  | 20 | 8521.69047619048 |  |  |  | 5 | 42 | 46 | 43 | 44 | 45 |  |  |  |  | 48
 |  | 21 | 8975.92857142857
 |  | 22 | 9430.16666666667
 |  | 23 | 9884.40476190477
 |  | 24 | 10338.6428571429 |  |  | Output Table |  | x | y | z | x1 | y1 | z1 | x2 | y2 | z2 | etc
 |  | 25 | 10792.880952381
 |  | 26 | 11247.1190476191 |  |  |  | 1 | 523 | 6236 | 2342 | 3979.31
 |  | 27 | 11701.3571428572 |  |  |  | 2
 |  | 28 | 12155.5952380953 |  |  |  | 3
 |  | 29 | 12609.8333333334 |  |  |  | 4
 |  | 30 | 13064.0714285715 |  |  |  | 5
 |  | 31 | 13518.3095238096
 |  | 32 | 13972.5476190477
 |  | 33 | 14426.7857142857
 |  | 34 | 14881.0238095238
 |  | 35 | 15335.2619047619
 |  | 36 | 15789.5
 |  | 37 | 16243.7380952381
 |  | 38 | 16697.9761904762
 |  | 39 | 17152.2142857143
Spreadsheet: 722115d1615047772-add-1-to-a-given-value-in-every-3-years-based-on-a-range-of-dates-sample3
Sheet: Sheet1

 |  | From | To |  |  | From | To | Step
 |  | 1980-09-02 00:00:00 | 2005-03-10 00:00:00 |  |  | 1980-09-02 00:00:00 |  | 1
 |  |  |  |  |  | 1981-01-01 00:00:00 |  | 1
 |  |  |  |  |  | 1982-01-01 00:00:00 |  | 1
 |  |  |  |  |  | 1983-01-01 00:00:00 | 1983-09-01 00:00:00 | 1
 |  |  |  |  |  | 1983-09-02 00:00:00 | 1983-12-21 00:00:00 | 2
 |  |  |  |  |  | 1984-01-01 00:00:00 |  | 2
 |  |  |  |  |  | 1985-01-01 00:00:00 |  | 2
 |  |  |  |  |  | 1986-01-01 00:00:00 | 1986-09-01 00:00:00 | 2
There will be an additional 1 step in every 3 years but not exceeding 8 with font color red. The cells filled with green are the end dates in each period. |  |  |  |  |  | 1986-09-02 00:00:00 |  | 3
 |  |  |  |  |  | 1987-01-01 00:00:00 |  | 3
 |  |  |  |  |  | 1988-01-01 00:00:00 |  | 3
 |  |  |  |  |  | 1989-01-01 00:00:00 | 1989-09-01 00:00:00 | 3
 |  |  |  |  |  | 1989-09-02 00:00:00 |  | 4
 |  |  |  |  |  | 1990-01-01 00:00:00 |  | 4
 |  |  |  |  |  | 1991-01-01 00:00:00 |  | 4
 |  |  |  |  |  | 1992-01-01 00:00:00 | 1992-09-01 00:00:00 | 4
 |  |  |  |  |  | 1992-09-02 00:00:00 |  | 5
 |  |  |  |  |  | 1993-01-01 00:00:00 |  | 5
 |  |  |  |  |  | 1994-01-01 00:00:00 |  | 5
 |  |  |  |  |  | 1995-01-01 00:00:00 | 1995-09-01 00:00:00 | 5
 |  |  |  |  |  | 1995-09-02 00:00:00 |  | 6
 |  |  |  |  |  | 1996-01-01 00:00:00 |  | 6
 |  |  |  |  |  | 1997-01-01 00:00:00 |  | 6
 |  |  |  |  |  | 1998-01-01 00:00:00 | 1998-09-01 00:00:00 | 6
 |  |  |  |  |  | 1998-09-02 00:00:00 |  | 7
 |  |  |  |  |  | 1999-01-01 00:00:00 |  | 7
 |  |  |  |  |  | 2000-01-01 00:00:00 |  | 7
 |  |  |  |  |  | 2001-01-01 00:00:00 | 2001-09-01 00:00:00 | 7
 |  |  |  |  |  | 2001-09-02 00:00:00 |  | 8
 |  |  |  |  |  | 2002-01-01 00:00:00 |  | 8
 |  |  |  |  |  | 2003-01-01 00:00:00 |  | 8
 |  |  |  |  |  | 2004-01-01 00:00:00 |  | 8
 |  |  |  |  |  | 2005-01-01 00:00:00 | 2005-03-10 00:00:00 | 8
Spreadsheet: 220697d1363237858-rounding-hours-for-timesheet-2-26-13-thru-3-12-13
Sheet: Non-Exempt

Name:  Omid Naeeni
Pay Period:   2/26 - 3/12/13 |  |  | 2010-10-27 00:00:00 | 2010-11-10 00:00:00 | Schedule: | M-F:  8:00 am - 5:00 pm   Sat:
Date | Time In | Time Out | Time In | Time Out | Notes | Hours
2010-06-07 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00
2010-06-08 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00
2010-06-09 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00
2010-06-10 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00
2013-02-26 00:00:00 | 08:00:00 | 14:00:00 | 15:00:00 | 17:00:00
2013-02-27 00:00:00 | 08:00:00 | 14:00:00 | 15:00:00 | 17:00:00
2013-02-28 00:00:00 | 08:00:00 | 14:00:00 | 15:00:00 | 17:00:00
2013-03-01 00:00:00 | 08:00:00 | 14:00:00 | 15:00:00 | 17:00:00
2013-03-04 00:00:00 | 09:00:00 | 14:00:00 | 15:00:00 | 18:00:00
2013-03-05 00:00:00 | 09:00:00 | 14:00:00 | 15:00:00 | 18:00:00
2013-03-06 00:00:00 | 09:00:00 | 14:00:00 | 15:00:00 | 18:00:00
2013-03-07 00:00:00 | 09:00:00 | 14:00:00 | 15:00:00 | 18:00:00
2013-03-08 00:00:00 | 09:00:00 | 14:00:00 | 15:00:00 | 18:00:00
2013-03-11 00:00:00 | 09:00:00 | 14:00:00 | 15:00:00 | 19:00:00
2013-03-12 00:00:00 | 09:00:00 | 14:00:00 | 15:00:00 | 18:00:00
2010-09-13 00:00:00 | 12:00:00 | 12:00:00 | 12:00:00 | 12:00:00
 |  |  |  |  |  |  | TOTAL HR
 |  |  |  |  |  | [NAME]:
 |  |  |  |  |  | Hourly Wage: | 13
 |  |  |  |  |  | OT Hours
 |  |  |  |  |  | OT Wage | 19.5
I certify that the hours recorded on this timesheet are a true and accurate |  |  |  |  |  | Hourly Total: |  | TOTAL WAGE
record of the hours I have worked this payroll period
Signed:…………………………………………… |  |  | Dated:  …………………………………………
 |  |  |  |  |  |  |  | (Rev: Jan 2013)