tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 2039460c-37ae-4451-a5f5-8bce81588a11
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Exercise Science - Pre-PT Curriculum (4 Year)
Fall |  |  |  | Spring
 | Course | [NAME] |  |  | Course | [NAME]
EXSC 110 | Introduction to Exercise Science | 2 |  | EXSC 140 | Priciples of Personal Wellness | 3
BIOL 108 | Anatomy and Physiology I | 4 |  | BIO 109 | Anatomy and Physiology II | 4
PSYC 103 | Introduction to Psychology | 3 |  | COMM 103 | Public Speaking | 3
IDC 100 | [NAME] | 1 |  | English 101 | English Composition | 3
IDC 101 | [NAME] | 3 |  | EXSC elective/general elective |  | 3
EXSC elective/general elective |  | 3 |  |  |  | 16
 |  | 16
Fall |  |  |  | Spring
 | Course | [NAME] |  |  | Course | [NAME]
NURS 200 | Nutrition | 3 |  | ENG. 200 | English Literature | 3
CHEM 103 | General Chemistry I | 4 |  | EXSC 240 | Physiology of Exercise | 4
IDC 200 | US Experience | 3 |  | THEO 200 | Ultimate Questions | 3
PHIL 160 | Introduction to Philosophy | 3 |  | HIST 116/7 | Western Civilization | 3
MATH 116 | Math prereq for Physics | 3 |  | CHEM 104 | General Chemistry II | 4
 |  | 16 |  |  |  | 17
Fall |  |  |  | Spring
 | Course | [NAME] |  |  | Course | [NAME]
Fine Arts |  | 3 |  | MATH 205 | Statistics | 4
IDC 301 | Cross Cultural Experience | 3 |  | EXSC 360 | Exercise Testing and Prescription | 4
PHIL 301 | Ethics | 3 |  | RTH 410 | Adv Physioloigic Testing | 3
EXSC 324 | Basic Injury Prevention and Care | 4 |  | RTH 323 | Introduction to Pharmacology | 2
PHYS 201 | Physics I | 4 |  | PHYS 202 | Physics II | 4
 |  | 17 |  |  |  | 17
Fall |  |  |  | Spring
 | Course | [NAME] |  |  | Course | [NAME]
EXCS 444 | Internship I | 3 |  | EXSC 455 | Internship II | 3
EXSC 400 | Research Methods | 3 |  | RTH 455 | Adv Cardiac Life Support | 2
EXSC 325 | Kinesiology | 3 |  | THEO 3xx |  | 3
EXSC 415 | Community Wellness | 3 |  | IDC 401 | Senior Seminar | 3
EXSC elective/general elective |  | 3 |  | EXSC elective/general elective |  | 3
 |  | 15 |  |  |  | 14
Bold indicates prerequisites for PT
note: this path does not require BIOL 130 |  |  |  |  | 126 minimum
Spreadsheet: 551201d1512757536-sumif-for-a-specific-item-code-sumif-excel-question-help-updated
Sheet: Sheet2

To Number | 4424-9999 | 3647-5874 | 5746-0000
TO605 | 7620
TO606 | 1688
TO607 | 620
TO608 | 0
FS-20-006 |  | 6000
FS-86-013 |  | 3000
FS-467-001 |  | 5000
FS-103-006 |  | 600
100-19-844-ST |  |  | 14564.05
132-04 ST |  |  | 26
143-11 ST |  |  | 8735
25-07 ST |  |  | 7876
Spreadsheet: 94355d1294191040-excel-2007-referencing-a-spreadsheet-test-repair-estimator
Sheet: Sheet2

Labor Grid | 0 | 0.1 | 0.2 | 0.3 | 0.4 | 0.5 | 0.6 | 0.7 | 0.8 | 0.9
0 | Free | 4.8 | 12.8 | 20.8 | 28.8 | 40 | 48 | 56 | 64 | 72
1 | 80 | 88.968 | 97.152 | 105.352 | 113.568 | 121.8 | 130.048 | 138.312 | 146.592 | 154.888
2 | 163.2 | 171.528 | 179.872 | 188.232 | 196.608 | 205 | 213.408 | 221.832 | 230.272 | 238.728
3 | 247.2 | 255.688 | 264.192 | 272.712 | 281.248 | 289.8 | 298.368 | 306.952 | 315.552 | 324.168
4 | 332.8 | 341.448 | 350.112 | 358.792 | 367.488 | 376.2 | 384.928 | 393.672 | 402.432 | 411.208
5 | 420 | 428.808 | 437.632 | 446.472 | 455.328 | 464.2 | 473.088 | 481.992 | 490.912 | 499.848
6 | 508.8 | 517.768 | 526.752 | 535.752 | 544.768 | 553.8 | 562.848 | 571.912 | 580.992 | 590.088
7 | 599.2 | 608.328 | 617.472 | 626.632 | 635.808 | 645 | 654.208 | 663.432 | 672.672 | 681.928
8 | 691.2 | 700.488 | 709.792 | 719.112 | 728.448 | 737.8 | 747.168 | 756.552 | 765.952 | 775.368
9 | 784.8 | 794.248 | 803.712 | 813.192 | 822.688 | 832.2 | 841.728 | 851.2719999999999 | 860.832 | 870.408
10 | 880 | 889.608 | 899.232 | 908.8720000000001 | 918.528 | 928.2 | 937.888 | 947.592 | 957.312 | 967.048
11 | 976.8 | 986.568 | 996.352 | 1006.152 | 1015.968 | 1025.8 | 1035.648 | 1045.512 | 1055.392 | 1065.288
12 | 1075.2 | 1085.128 | 1095.072 | 1105.032 | 1115.008 | 1125 | 1135.008 | 1145.032 | 1155.072 | 1165.128
13 | 1175.2 | 1185.288 | 1195.392 | 1205.512 | 1215.648 | 1225.8 | 1235.968 | 1246.152 | 1256.352 | 1266.568
14 | 1276.8 | 1287.048 | 1297.312 | 1307.592 | 1317.888 | 1328.2 | 1338.528 | 1348.872 | 1359.232 | 1369.608
15 | 1380 | 1390.408 | 1400.832 | 1411.272 | 1421.728 | 1432.2 | 1442.688 | 1453.192 | 1463.712 | 1474.248
Spreadsheet: chris_germany__2576__VNG Pipeline Setup-Oct-00
Sheet: 10-3

2000-10-03 00:00:00 |  |  | VNG Daily Setup |  |  |  |  | 2000-10-02 00:00:00
 |  |  |  | DTH
 |  |  | 2000-10-02 00:00:00 |  | 2000-10-03 00:00:00 |  | 2000-10-04 00:00:00 |  | 2000-10-05 00:00:00
 |  |  | Monday |  | Tuesday |  | Wednesday |  | Thursday
Heating Degree Days
Forecasted Demand |  |  | 45000 |  | 45000 |  | 45000 |  | 45000
INTERRUPTIBLE STATUS |  |  | ON / ON |  | ON / ON |  | ON / ON |  | ON / ON
SUPPLY: | AVAILABLE
TRANSCO
FS  Swing | 15930 |  | 15930 |  | 15930 |  | 15930 |  | 15930
FT | 14400 |  | 20556 |  | 20556 |  | 20556 |  | 20556
WSS - W/D  (3,386) | 8524 |  | -3300 |  | -3300 |  | -3300 |  | -3300
GSS-INJ (575) | 2070 |  | -484 |  | -484 |  | -484 |  | -484
WSS  W/D Capacity | 0
TOTAL Emporia | 38000
TOTAL City Gate | 37620 |  | 31825 |  | 31825 |  | 31825 |  | 31825
FT-WSS-INJ (3,386)
COLUMBIA
+  SST - Spot | 0 |  | 0 |  | 0 |  | 0 |  | 0
+  FTS - System Supply | 57970 |  | 16198 |  | 11198 |  | 11198 |  | 11198
=  Subtotal FT Sys. Supply | 57970 |  |  | * |  | * |  | * |  | *
SST - FSS         (9837) | 31827.5 |  | -9837 |  | -5076 |  | -5076 |  | -5076
EndUser |  |  | 2000 |  | 2000 |  | 2000 |  | 2000
Cove Point LNG |  |  | 0 |  | 0 |  | 0 |  | 0
LNG (3,244) | 52090 |  | -6081 |  | -6081 |  | -6081 |  | -6081
TOTAL | 141887.5
 |  |  | * LNG Chesapeake injection nominated directly to the facility, citygate deliveries are net the injection quantity.
CNGT
FTNN | 46075 |  | 16558 |  | 16558 |  | 16558 |  | 16558
GSS            (16,599) | 53648 |  | -16599 |  | -16599 |  | -16599 |  | -16599
Subtotal Cannot exceed 46,075 Apr - Oct
EndUser |  |  | 11175 |  | 11175 |  | 11175 |  | 11175
[NAME] | 9975
TOTAL Quantico | 93604
TOTAL City Gate | 93369.99
VNG
PROPANE
NORTHERN | 17275 |  | 0 |  | 0 |  | 0 |  | 0
SOUTHERN | 34450 |  | 0 |  | 0 |  | 0 |  | 0
TOTAL | 324602.49
 | Projected  Storage  Summary
 |  |  | [NAME]. |  | [NAME]
 | FSS |  | 9837 |  | 63655
 | GSS |  | 484 |  | 2070
 | WSS |  | 3386 |  | 8524
 | CNG GSS |  | 16599 |  | 53648
 | LNG |  | 3244 |  | 52090
 | Propane |  | 12,000 gal/day |  | 51825
High Burn Contingenies |  |  |  |  |  |  |  | Low Burn Contingenies
1) Reduce Columbia FSS Injection to 0 |  |  |  |  |  |  | 1) Increase Columbia FSS injection to 9,837
2) Reduce CNG GSS Injection to 0 |  |  |  |  |  |  | 2) Notify ENA  contact for instructions if there is excess supply
3) Notify ENA  contact for instructions if additional supply is needed
Spreadsheet: 99500d1298112613-time-sheet-conversion-timesheet_conversion
Sheet: Sheet1

Date | Project A | Project B | Project C
1 |  | 3 | 5
2 | 6 | 2
3
4
5 | 4 | 4 | 2
6 | 5 | 2 | 1
7 | 6 |  | 2
Spreadsheet: 673051d1587136625-vlookup-to-use-multiple-search-terms-to-populate-a-different-tab-test-folder-johnporter85-
Sheet: Data

Works Order | Object Description |  | Directive | Works Order
40776956 | 10 Mnt Rush | 2020-01-01 00:00:00 | [NAME] systems | 40776956
40776969 | 62-70 Gt Road | 2020-01-01 00:00:00 | [NAME] systems | 40776969
40776957 | 10 Mnt Rush | 2020-02-01 00:00:00 | [NAME] systems | 40776957
40776970 | 62-70 Gt Road | 2020-02-01 00:00:00 | [NAME] systems | 40776970
40776958 | 10 Mnt Rush | 2020-03-01 00:00:00 | [NAME] systems | 40776958
40776971 | 62-70 Gt Road | 2020-03-01 00:00:00 | [NAME] systems | 40776971
40776959 | 10 Mnt Rush | 2020-04-01 00:00:00 | [NAME] systems | 40776959
40776972 | 62-70 Gt Road | 2020-04-01 00:00:00 | [NAME] systems | 40776972
40776960 | 10 Mnt Rush | 2020-05-01 00:00:00 | [NAME] systems | 40776960
40776974 | 62-70 Gt Road | 2020-05-01 00:00:00 | [NAME] systems | 40776974
40776961 | 10 Mnt Rush | 2020-06-01 00:00:00 | [NAME] systems | 40776961
40776965 | 62-70 Gt Road | 2020-06-01 00:00:00 | [NAME] systems | 40776965
40776962 | 10 Mnt Rush | 2020-07-01 00:00:00 | [NAME] systems | 40776962
40776967 | 62-70 Gt Road | 2020-07-01 00:00:00 | [NAME] systems | 40776967
40776964 | 10 Mnt Rush | 2020-08-01 00:00:00 | [NAME] systems | 40776964
40776966 | 62-70 Gt Road | 2020-08-01 00:00:00 | [NAME] systems | 40776966
40776968 | 62-70 Gt Road | 2020-09-01 00:00:00 | [NAME] systems | 40776968
Spreadsheet: 3957035d-ebd8-4a34-8b21-64ca41262de9
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2013-11-08 09:45:47.800000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.875 | 102.5 | 102.375 | 102.25 | 101.875 |  | and are added to price quote
4.75 | 102.251 | 102.126 | 102.001 | 101.626
4.625 | 102.045 | 101.92 | 101.795 | 101.42 |  | Note: | Refer To Price [NAME]
4.5 | 101.172 | 101.047 | 100.922 | 100.547 |  |  | For all Price Adjs
4.375 | 100.238 | 100.113 | 99.988 | 99.363
4.25 | 99.464 | 99.339 | 99.214 | 98.589
4.125 | 98.673 | 98.548 | 98.423 | 97.798
4 | 97.685 | 97.56 | 97.435 | 96.81
3.875 | 96.659 | 96.534 | 96.409 | 95.784 |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.875 | 102.472 | 102.347 | 102.222 | 101.847
3.75 | 101.957 | 101.832 | 101.707 | 101.332
3.625 | 101.575 | 101.45 | 101.325 | 100.95
3.5 | 101.021 | 100.896 | 100.771 | 100.396
3.375 | 100.3 | 100.175 | 100.05 | 99.425
3.25 | 99.543 | 99.418 | 99.293 | 98.668
3.125 | 98.52 | 98.395 | 98.27 | 97.645 |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2013-11-22 09:45:47.800000
30 DAY | 2013-12-07 09:45:47.800000
45 DAY | 2013-12-22 09:45:47.800000
60 DAY | 2014-01-06 09:45:47.800000
90 DAY | 2014-02-05 09:45:47.800000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 77721d1278156062-collate-and-index-info-example2-adeassessor4
Sheet: Main

Entry | Unit 1 Criteria 1 | Unit 1 Criteria 2 | Unit 1 Criteria 3 | Unit 1 Criteria 4 | Unit 1 Criteria 5 | Unit 1 Criteria TRIM | Unit 2 Criteria 1 | Unit 2 Criteria 2 | Unit 2 Criteria 3 | Unit 2 Criteria 4 | Unit 2 Criteria 5 | Unit 2 Criteria TRIM
Entry 1 | Y |  | Y |  | Y |  |  | 2 | 3 | 4
Entry 2 |  |  |  |  |  |  | 1 | 2
Entry 3 |  |  |  | Y | Y |  |  |  |  |  | 5
Spreadsheet: 136844d1326841704-chart-adm-and-vst-chart_pt_jpr73
Sheet: PT

 |  |  |  |  |  |  |  |  | Chart
 | Valeurs
Items | visits | admits
[NAME] | 1267 | 96
Burns | 750 | 151
Carroll | 902 | 62
[NAME] | 666 | 7
Croce | 1445 | 97
[NAME] | 1380 | 105
Digiovan | 1230 | 84
[NAME] | 568 | 103
[NAME] | 141 | 3
Kouagheu | 908 | 48
[NAME] | 259 | 16
Sargent | 333 | 5
Shiho | 790 | 1
Total général | 10639 | 778
 | Valeurs
Items | visits | admits
[NAME] | 0.1190901400507566 | 0.1233933161953727
Burns | 0.07049534730707774 | 0.1940874035989717
Carroll | 0.08478240436131215 | 0.07969151670951156
[NAME] | 0.06259986840868503 | 0.008997429305912597
Croce | 0.1358210358116364 | 0.1246786632390745
[NAME] | 0.129711439045023 | 0.1349614395886889
Digiovan | 0.1156123695836075 | 0.1079691516709512
[NAME] | 0.0533884763605602 | 0.1323907455012854
[NAME] | 0.01325312529373061 | 0.003856041131105398
Kouagheu | 0.08534636713976877 | 0.06169665809768637
[NAME] | 0.02434439327004418 | 0.02056555269922879
Sargent | 0.03129993420434252 | 0.006426735218508998
Shiho | 0.07425509916345521 | 0.001285347043701799
Total général | 1 | 1
Spreadsheet: darrell_schoolcraft__7805__imbalsumm0108
Sheet: SidR

 | [NAME]
 | POI 1190 - Keystone Plant Outlet
Day | Measured | Scheduled
1 | 49839 | 42521
2 | 58661 | 61095
3 | 57956 | 59505
4 | 62170 | 61574
5 | 63269 | 58996
6 | 62745 | 62359
7 | 66886 | 73126
8 | 66326 | 65213
9 | 63811 | 63118
10 | 60111 | 59591
11 | 64319 | 64464
12 | 64945 | 63665
13 | 64939 | 64464
14 | 63062 | 63411
15 | 56053 | 59448
16 | 62374 | 63447
17 | 61677 | 61277
18 | 60811 | 60711
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-07-31 00:00:00 |  |  | 167936
2001-08-18 00:00:00
CBS Volume
 |  |  | 71406
Spreadsheet: 829329d1684147184-index-match-picking-up-wrong-duplicate-value-when-using-with-excel-table-ms-office-2021-temp-2
Sheet: Credit Note

THE KOMBO TEAM |  |  |  |  |  |  |  |  |  |  | LOFTEX LIMITED
NTN No. 5329154-2 |  |  |  |  |  |  |  |  |  |  | NTN# 4111664-0
STRN: 32-77-8761-969-90 |  |  |  |  |  |  |  |  |  |  | STRN# 03-00-4111-664-14
65-KM, Multan Road, [NAME], Kasur. |  |  |  |  |  |  |  |  |  |  | 1/2-KM Defence Road, Off Bhobhatian, Near UOL Lahore PK.
CREDIT NOTE |  |  |  |  |  |  |  |  |  |  | DEDIT NOTE
TO: LOFTEX LIMITED |  |  |  |  |  |  |  |  |  |  | TO: THE KOMBO TEAM
NTN# 4111664-0 |  |  |  |  |  | Credit Note No. |  | TKT/27/23 |  |  | NTN No. 5329154-2 |  |  |  |  |  | Credit Note No.
STRN# 03-00-4111-664-14 |  |  |  |  |  | Date: |  |  |  |  | STRN: 32-77-8761-969-90 |  |  |  |  |  | Date:
1/2-KM Defence Road, Off Bhobhatian, Near UOL Lahore PK. |  |  |  |  |  |  |  |  |  |  | 65-KM, Multan Road, [NAME], Kasur.
Inv. No. | Date | Description | Style No. | QTY | Rate | Ex. Value | GST | Inc Value |  |  | Inv. No. | Date | Description | Style No. | QTY | Rate | Ex. Value | GST | Inc Value
TOTAL |  |  |  |  | - |  |  |  |  |  | TOTAL |  |  |  |  | -
 |  |  |  |  |  |  | Approved By: |  |  |  |  |  |  |  |  |  |  | Approved By:
Spreadsheet: 144800d1331141511-vlookup-not-returning-the-correct-value-in-cell-paycheck-calculator-b
Sheet: Paybands

 | Level 4 | Level 5 | Level 6 | Level 7 | Level 8 | Level 9 | Level 10 | Level 11 | Level 12
CPC | 48205 | 54712 | 60458 | 66807 | 73822 | 81572 | 93808 | 98731 | 103669
Dev3 | N/A | 50302 | 54611 | 59373 | 64634 | 70447 | 79624 | 83316 | 87019
Dev2 | N/A | N/A | 48764 | 51939 | 55446 | 59321 | 65439 | 67901 | 70370
Dev1 | N/A | N/A | N/A | 44504 | 46258 | 48196 | 51255 | 52485 | 53720
51939 | 0.1416 | 59294
Spreadsheet: 740840d1626622550-formulas-to-automate-list-linked-to-the-databsae-rawmat-usage
Sheet: Sheet1

DATABASE
FG Code | FG Description | [NAME] | Y01EN | Y01PH-723 | Y01PH-923GS | Y01PL | Y02HN | Y03HD
GTE9010 | Expanded Graphite Packing | 0 | 5 | 0 | 0 | 0 | 0 | 0
GTE9011 | Expanded Graphite Wire Packing | 5 | 0 | 0 | 0 | 0 | 0 | 0
GTE9019YZH | [NAME] | 0 | 0 | 0 | 4.5 | 0 | 0 | 0.5
GTE9020D | [NAME] PTFE Packing ( Dry ) | 0 | 0 | 0 | 4 | 0 | 0.5 | 0.5
GTE9020L | [NAME] PTFE Packing | 0 | 0 | 0 | 3 | 0 | 0 | 2
GTE9021 | [NAME] Packing | 0 | 1 | 0 | 0 | 0 | 4 | 0
GTE9022 | [NAME] | 0 | 1 | 0 | 0 | 0 | 4 | 0
GTE9043 | Pure PTFE Packing ( Dry ) | 0 | 0 | 0 | 0 | 0 | 0 | 5
Column1.FG Code | Column1.FG Description | Mat1 | Mat2 | Mat3 | Val1 | Val2 | Val3
GTE9010 | Expanded Graphite Packing | Y01EN |  |  | 5
GTE9011 | Expanded Graphite Wire Packing | [NAME] |  |  | 5
GTE9019YZH | [NAME] | Y01PH-923GS | Y03HD |  | 4.5 | 0.5
GTE9020D | [NAME] PTFE Packing ( Dry ) | Y01PH-923GS | Y02HN | Y03HD | 4 | 0.5 | 0.5
GTE9020L | [NAME] PTFE Packing | Y01PH-923GS | Y03HD |  | 3 | 2
GTE9021 | [NAME] Packing | Y01EN | Y02HN |  | 1 | 4
GTE9022 | [NAME] | Y01EN | Y02HN |  | 1 | 4
GTE9043 | Pure PTFE Packing ( Dry ) | Y03HD |  |  | 5
Spreadsheet: 857193d1706223075-overtime-if-not-at-40-pay
Sheet: WK 0-1

 |  |  | TIME AND MONEY |  |  |  |  |  |  |  |  |  |  | TIME AND MONEY | TIME AND MONEY
 | CURRENT WAGES
 | FEDERAL TAXES | FEDERAL TAXES
 | [NAME] PAY | 28
 | REGULAR HOURS | 8
 |  |  |  | 2023
 |  |  |  | NOVEMBER
 |  | DAYS EMPLOYED |  | N/A | N/A | N/A | N/A | N/A | N/A | N/A |  | N/A | N/A | 1 | 2 | 3 | 4 | 5
 |  | TIME LOG |  |  |  |  |  |  |  |  |  |  |  | BEGUN WORK
 |  |  |  |  |  |  |  |  |  |  |  |  |  | WEEK 1
 |  |  |  | MON | TUE | WED | THU | FRI | SAT | SUN |  | MON | TUE | WED | THU | FRI | SAT | SUN
 |  | DATE |  | 6 | 7 | 8 | 9 | 10 | 11 | 12 | WEEK 1 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | WEEK 2
 |  | OCCASION |  |  |  |  |  |  |  |  | TOTALS |  |  |  |  |  |  |  | TOTALS
 |  | CLOCK IN |  |  |  |  |  |  |  |  |  | 07:54:00 | 07:54:00 | 07:54:00 | 08:00:00 | 07:54:00
 |  | LUNCH OUT |  |  |  |  |  |  |  |  |  | 11:30:00 | 11:30:00 | 11:30:00 | 11:30:00 | 11:30:00
 |  | FIRST PART TOTAL
 |  | LUNCH IN |  |  |  |  |  |  |  |  |  | 11:30:00 | 11:30:00 | 11:30:00 | 11:30:00 | 11:30:00
 |  | CLOCK OUT |  |  |  |  |  |  |  |  |  | 16:00:00 | 16:00:00 | 16:00:00 | 16:00:00 | 16:00:00
 |  | SECOND PART TOTAL
 |  | REGULAR HOURS WORKED
 |  | OT HOURS WORKED
 |  | TOTAL HOURS WORKED
 |  | REGULAR MONEY MADE
 |  | OT MONEY MADE
 |  | GROSS PAY
 |  | FEDERAL WITHHOLDING
 |  | MEDICARE
 |  | SOCIAL SECURITY
 |  | TOTAL TAXES TAKEN
 |  | NET PAY
 |  |  |  |  |  | REGULAR TIME |  |  |  | OVERTIME
 |  |  |  |  | PAY | 1 DAY | 1 WEEK | 2 WEEKS |  | 1 DAY (2 HRS) | 1 WEEK (10 HRS) | 2 WEEKS (20 HRS)
 |  |  |  | ARMOROCK | 28 |  |  |  |  |  |  |  |  | 08:06:00
 |  |  |  | NV ENERGY | 47 |  |  |  |  |  |  |  |  | 08:06:00
 |  |  |  | DIFFERENCE
Spreadsheet: 23965d1213880612-vlookup-problem-diesel-backup
Sheet: Day1

 |  |  |  | Net Costs Available
 |  |  | Date: | 2008-06-07 00:00:00
Town 1 | P1 | P2 | P3 | P4 | P5 | P6
Company 1 | 0.99 | 1.98 | 2.97 | 3.96 | 4.95 | 5.94
Company 2 | 0 | 0 | 0 | 0 | 0 | 0
Company 3 | 0 | 0 | 0 | 0 | 0 | 0
Company 4 | 0 | 0 | 0 | 0 | 0 | 0
Company 5 | 0 | 0 | 0 | 0 | 0 | 0
Company 6 | 0 | 0 | 0 | 0 | 0 | 0
Company 7 | 0 | 0 | 0 | 0 | 0 | 0
Company 8 | 0 | 0 | 0 | 0 | 0 | 0
Company 9 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 845667d1697080830-how-to-calculate-penalty-time-if-work-finishes-after-midnight-early-late-penalty-calculator
Sheet: Early-Late Penalty Calculator

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DOUBLE CHECK TO MAKE SURE NO PENALTY ON SAT OR SUN
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | this is wrong ..does not calculate hours bewteen 8 at night and 7 in the morning
 |  | LATE/EARLY PENALTY RATE HOURS |  |  |  |  |  |  | LATE/EARLY PENALTY RATE HOURS |  |  |  |  |  |  | LATE/EARLY PENALTY RATE HOURS
 |  | 1st. HALF |  |  |  |  |  |  | 2nd. HALF
 |  | Start | End | Total | Normal | Penalty | ROUNDED |  | Start | End | Total | Normal | Penalty | ROUNDED |  | Start | End | Total | Normal | Penalty | ROUNDED
WEEK 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WEEK 1
 |  | 00:00:00 | 00:00:00 |  |  |  |  |  | 00:00:00 | 00:00:00 |  |  |  |  |  |  |  |  | 0
 |  | 00:00:00 | 00:00:00 |  |  |  |  |  | 00:00:00 | 00:00:00
 |  |  |  |  | Week 1 - 1st. Half Total : |  |  |  |  |  |  | Week 1 - 2nd. Half Total :
WEEK 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WEEK 2
 |  | 00:00:00 | 00:00:00 |  |  |  |  |  | 00:00:00 | 00:00:00 |  |  |  |  |  |  |  |  | 0
 |  | 00:00:00 | 00:00:00 |  |  |  |  |  | 00:00:00 | 00:00:00
 |  |  |  |  | Week 2 - 1st. Half Total : |  |  |  |  |  |  | Week 2 - 2nd. Half Total :
Spreadsheet: 153174d1335791121-hours-worked-after-certain-time-excel-forum-p2
Sheet: Sheet1

Start time | End Time | Expected result (no of hours worked after 8.00 p.m) |  |  |  | Formulaic Result
2012-04-23 23:00:00 | 2012-04-24 05:00:00 | 06:00:00
2012-04-23 15:00:00 | 2012-04-23 21:00:00 | 01:00:00
2012-04-23 04:00:00 | 2012-04-24 03:00:00 | 07:00:00
2012-04-23 14:00:00 | 2012-04-23 19:00:00 | 00:00:00
2012-04-23 01:00:00 | 2012-04-23 09:00:00 | 08:00:00
Spreadsheet: 163962d1340573924-formatting-a-list-by-using-contains-contains-v4
Sheet: Rent Roll

[NAME] | Tenant | Formatted Tenant Name | Format #2
Loan 1 | Reebok |  |  | How do I expand on formula in column L, or make it more dynamic
Loan 1 | Reebok | formula above drags down
Loan 1 | Reebok
Loan 1 | Reebok
Loan 1 | Reebok
Loan 1 | Reebok
Loan 1 | Reebok
Loan 1 | Reebok
Loan 1 | JC Penney
Loan 1 | JC Penney
Loan 1 | JC Penney
Loan 1 | JC Penney
Loan 1 | JC Penney
Loan 1 | JC Penney
Loan 1 | JC Penney
Loan 1 | JCPenney
Loan 1 | JCPenney
Loan 1 | JCPenney
Loan 1 | JCPenney
Loan 1 | JCPenney
Loan 1 | JCPenney
Loan 1 | JCPenney
Loan 1 | JCPenney
Loan 1 | JCPenney
Loan 1 | Wal-Mart
Loan 1 | Wal-Mart
Loan 1 | Wal-Mart
Loan 1 | Wal-Mart
Loan 1 | Wal-Mart
Loan 1 | Wal-Mart
Loan 1 | Wal-Mart
Loan 1 | Wal-Mart
Loan 1 | Wal-Mart
Loan 1 | Wal-Mart
Loan 1 | Wal-Mart
Loan 1 | Walmart
Loan 1 | Walmart
Loan 1 | Walmart
Loan 1 | Walmart
Loan 1 | Walmart
Loan 1 | Walmart
Loan 1 | Walmart
Loan 1 | Walmart
Loan 1 | Walmart
Loan 1 | Walmart
Loan 1 | Walmart
Loan 1 | Walmart
Loan 1 | Walmart
Loan 1 | Walmart
Loan 1 | Walmart
Loan 1 | Walmart
Loan 1 | Walmart
Loan 1 | Walmart
Loan 1 | Foot Locker
Loan 1 | Kid's Foot Locker
Loan 1 | Women's Foot Locker
Loan 1 | Gap Kids
Loan 1 | The Gap
Loan 1 | Gap for Children
Loan 1 | Vacant
Loan 1 | Vacant
Spreadsheet: 154458d1336437510-sumif-on-multiple-matching-rows-timesheets_test
Sheet: Sheet1

Project | Week Beginning Monday May 7 | Mon | Tue | We | Thu | Fri | Sat | Sun |  |  | Project Code | Actual Hours
103771 | Platform  Code |  |  |  |  |  |  |  |  |  | 103771 | Summed project totals to go here
DAMS | [NAME] |  |  |  |  |  |  |  |  |  | DAMS | Summed project totals to go here
IS | 893104-Identity |  |  |  |  |  |  |  |  |  | IS | Summed project totals to go here
RP | M-1004 Reply Paid Richard |  |  |  |  |  |  |  |  |  | RP | Summed project totals to go here
EIS | R-10072-C EIS  project |  |  |  |  |  |  |  |  |  | EIS | Summed project totals to go here
ISR | L-1003 (ISR) Ari | 8 |  |  |  |  |  |  |  |  | ISR | Summed project totals to go here
SF | C-10058 Sales Phase 2 |  |  |  |  |  |  |  |  |  | SF | Summed project totals to go here
 | Leave |  |  |  |  |  |  |  |  |  | Leave | Summed project totals to go here
 | Totals
 | Week Beginning Monday Apr 30 | Mon | Tue | We | Thu | Fri | Sat | Sun
103771 | Platform  Code
DAMS | [NAME]
IS | 893104-Identity
RP | M-1004 Reply Paid Richard | 8
EIS | R-10072-C EIS  project
ISR | L-1003 (ISR) Ari |  | 2 |  | 4 | 8
SF | C-10058 Sales Phase 2 |  | 6 | 8 | 4
 | Leave
 | Totals
 | Week Beginning Monday Apr 23 | Mon | Tue | We | Thu | Fri | Sat | Sun
103771 | Platform  Code | 5 | 4
IS | [NAME]
RP | 893104-Identity |  | 2
EIS | M-1004 Reply Paid Richard | 3
ISR | R-10072-C EIS  project
SF | L-1003 (ISR) Ari |  | 2 |  | 8 | 8
 | Leave |  |  | 8
 | Totals
 | Week Beginning Monday Apr 16 | Mon | Tue | We | Thu | Fri | Sat | Sun
103771 | Platform  Code | 8 | 8 | 6 | 7 | 7
IS | [NAME] |  |  | 1
RP | 893104-Identity |  |  | 1 | 1 | 1
 | M-1004 Reply Paid Richard
 | R-10072-C EIS  project
 | Leave
 | Totals
Spreadsheet: 477671d1472461504-please-help-conditional-formatting-and-counting-based-on-cell-color-excel-exercise-bsb-
Sheet: Condition

DATA
Color explanation |  | Sold |  |  | Deposit |  |  | Agency |  |  | Empty |  |  | Not Available
Apartment number | 01 | 02 | 03 | 04 | 05 | 06 | 07 | 08 | 09 | 10 | 11 | 12 |  | Statistics
1st floor |  |  |  |  |  |  |  |  |  |  |  |  |  | Sold
2nd floor |  |  |  |  |  |  |  |  |  |  |  |  |  | Deposit
3rd floor |  |  |  |  |  |  |  |  |  |  |  |  |  | Agency
4th floor |  |  |  |  |  |  |  |  |  |  |  |  |  | Empty
5th floor | 5.01 | 5.02 | 5.03 | 5.04 | 5.05 | 5.06 | 5.07 | 5.08 | 5.09 | 5.1 | 5.11 | 5.12 |  | Total
6th floor | 6.01 | 6.02 | 6.03 | 6.04 | 6.05 | 6.06 | 6.07 | 6.08 | 6.09 | 6.1 | 6.11 | 6.12