tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 36589d1234457893-how-to-do-two-logical-tests-for-a-conditional-statement-roi-with-energy-calculator
Sheet: Mt. Morris Rm. 3

 | ECOlighting Solutions |  | Telephone: [PHONE]
 | 2000 Commerce Pkwy |  | Fax: [PHONE]
 | Lancaster, NY 14086 |  | E-Mail: [EMAIL]
Base information
Customer | [NAME]
Project Name | Mt. Morris |  |  | [NAME]. | 021009A
Address |  |  |  | Type of Old Technology | 400 W Mercury
Contact | [NAME] |  | ` | Type of LED | LED Retro
Phone |  |  |  | Voltage | 240
Technical Information | 400 W Mercury | LED Retro
Old Technology / LED, lifetime in hours | 5000 | 120000 |  | Qty Lights / Daily usage | 18 | 17
Old Technology/ LED, lifetime in years | 0.8058017727639001 | 19.3392425463336 |  | Usage in / day's per month / day's per year | 30 | 360
Install. costs for the first installation | 400 W Mercury | LED Retro |  |  | 400 W Mercury | LED Retro
Costs each (Entire Fixture) | 400 | 960
Install Costs (Per Fixture) | 20 | 20
 |  |  | Cost for the Lights |  | 17280
Lifetime Maintenance Cost (After Installation) | 400 W Mercury | LED Retro
Lifetime changes | 23 |  |  |  | 400 W Mercury | LED Retro
Bulb Cost | 30 | 0 | Bulb Savings (Lifetime) |  | 0 | 12420
Labor Rate | 16 | 0 | [NAME] (Lifetime) |  | 0 | 6624
Service cost including; Labor, and bulb | 46 | 0 | Bulb and [NAME] (lifetime) |  | 0 | 19044
Power consumption costs | 400 W Mercury | LED Retro |  |  | 400 W Mercury | LED Retro
Bulb consumption (wattage) | 400 | 120 | Total power consumption in watts per day |  | 177480 | 36720
Ballast consumption (wattage) | 180 | 0 | Power cost per day |  | 21.2976 | 4.4064
Consumption total (wattage) | 580 | 120 | Power cost per month |  | 638.928 | 132.192
Cost's per kWh | 0.12 | 0.12 | Power cost per year |  | 7667.136 | 1586.304
Project [NAME] (sq. ft.) |  |  |  | Annual Power Savings | 6080.831999999999
 |  |  |  | Lifetime Power Savings | 117598.6849315068
Results
 |  |  |  | Results
 |  |  |  | Bulb Cost (Lifetime) |  | 12420
 |  |  |  | Lifetime Power Savings |  | 117598.6849315068
 |  |  |  | Combined Lifetime savings (bulb and power) |  | 130018.6849315068
 |  |  |  | Combined Annual savings (bulb and power) |  | 6620.831999999999
 |  |  |  | Break even after (Years) |  | 2.609943886206447
 |  |  |  | Potential Federal Incentives |  | 0
 |  |  |  | Potential NYSERDA Incentives |  | 6080.831999999999
 |  |  |  | Break Even After Incentives (Years) |  | 1.360451669954425
Energy Calculations
 |  |  |  |  | Old Technology | New Technology
 |  |  |  | Total Annual Coal Consumption (lbs.) | 51945.36585365854 | 10747.31707317073
 |  |  |  | Total Annual CO2 emissions (lbs.) | 143694.9072 | 29729.9808
 |  |  |  | Total Annual SO2 emissions (lbs) | 830.6063999999999 | 171.8496
 |  |  |  | Total Acres of Trees needed to fix this much CO2 (acres) | 19.59565078412655 | 4.054272576026182
 |  |  |  | Total annual energy consumption in kWh (lbs.) | 63892.8 | 13219.2
 |  |  |  | *Figures based on electricity coming from coal burning
Spreadsheet: larry_campbell__20986__Topock Pigging Program
Sheet: Page 5 

Revised |  | 2001-02-15 00:00:00 |  |  |  |  |  | Liquid
Date |  | Location | Type of Pig | Solvent | Solvent | Lateral | Sample I.D. | Volume | Analytical | Units | Comments
 |  | of Sample |  | Injected | Volume | Volume |  | Collected | Result
2000-10-30 00:00:00 |  | PG&E M/S | Poly | Dry | 0 | 295 mmcf |  | 0 |  |  | No liquid received with pig 97
2000-11-14 00:00:00 |  | PG&E M/S | Poly | Dry | 0 | 217 mmcf |  | 0 |  |  | No liquid received with pig 98
2000-11-27 00:00:00 |  | PG&E M/S | Poly | Dry | 0 | 261 mmcf |  | 0 |  |  | No liquid received with pig 99
2000-12-11 00:00:00 |  | PG&E M/S | Poly | Dry | 0 | 278 mmcf |  | 0 |  |  | No liquid received with pig 100
2001-01-02 00:00:00 |  | PG&E M/S | Poly | Dry | 0 | 292 mmcf |  | 0 |  |  | No liquid received with pig 101
2001-01-18 00:00:00 |  | PG&E M/S | Poly | Dry | 0 | 278 mmcf |  | 0 |  |  | No liquid received with pig 102
2001-01-29 00:00:00 |  | PG&E M/S | Poly | Dry | 0 | 312 mmcf |  | 0 |  |  | No liquid received with pig 103
2001-02-12 00:00:00 |  | PG&E M/S | Poly | Dry | 0 | 290 mmcf |  | 0 |  |  | No liquid received with pig 104
Spreadsheet: 825852d1681577692-using-mod-and-if-to-find-cell-value-vs-reference-and-show-if-divisible-but-i-have-an-issue-sample_ceepeebee
Sheet: OriginalFvF

Biggest [NAME]
WEIGHTLOSS COMPETITION |  |  |  | Set Competition Start Date: |  |  | 2017-07-15 00:00:00
 |  |  | Set Weight Measured Interval [DAYS]: |  |  |  | 15
Name | Starting Weight [lb] | Weight Loss -1 [lb] | Result | Weight Loss -2 [lb] | Result | Weight Loss -3 [lb] | FINAL Weight Loss [%]
Stephan | 230 | 212 |  | 198 |  | 165
Maria | 232 | 210 |  | 167 |  | 145
Angelina | 220 | 212 |  | 200 |  | 124
[NAME] | 205 | 195 |  | 160 |  | 143
[NAME] is:
Spreadsheet: 88910d1288720975-conditional-formatting-with-multiple-and-or-criteria-air_surface
Sheet: Sheet2

 |  |  | Air |  |  | Surface
 |  | No [NAME] | Alert | Action | No [NAME] | Alert | Action
CR1, 2, 3 | Hood | 0 | 0.03 | 0.09 | 0 | 1 | 3 | Presence of mold=alert for all surface and air samples
 | Room | 0 | 0.25 | 0.5 | N/A | N/A | N/A
 | Bins | N/A | N/A | N/A | 0 | 5 | 7
 | Floors | N/A | N/A | N/A | 0 | 5 | 10
 | Pass-Thrus | N/A | N/A | N/A | 0 | 5 | 7
 | Tables | N/A | N/A | N/A | 0 | 3 | 5
 | Walls | N/A | N/A | N/A | 0 | 3 | 5
 |  |  | Air |  |  | Surface
 |  | No [NAME] | Alert | Action | No [NAME] | Alert | Action
MR1, 2 | Room | 0 | 1.25 | 2.5 | N/A | N/A | N/A | Presence of mold=alert for all C=MR surface and air samples
 | Floors | N/A | N/A | N/A | 0 | 10 | 20
 | Vault | N/A | N/A | N/A | 0 | 5 | 10
 | Walls | N/A | N/A | N/A | 0 | 5 | 10
 |  |  | Air |  |  | Surface
 |  | No [NAME] | Alert | Action | No [NAME] | Alert | Action
PR1, 2, 3 | Room | 0 | 6.25 | 12.5 | N/A | N/A | N/A
 | Door | N/A | N/A | N/A | 0 | 10 | 20 | [NAME] does not elicit an alert in the PR
 | Floors | N/A | N/A | N/A | 0 | 20 | 40
 | Walls | N/A | N/A | N/A | 0 | 10 | 20
Spreadsheet: 804391d1668037293-formula-for-printing-all-sheets-xcvbtr10
Sheet: 211

 |  | [NAME])  YA MSHIRIKA T.A.G HERMON REVIVAL CHURCH |  |  |  |  |  |  |  |  | MWAKA
 |  | JINA KAMILI | WEEKS | JAN | FEB | [NAME] | APRIL | MAY | [NAME] | JULY | AUGU | SEPT | OKT | NOV | DEC | JUMLA
 |  |  | 1 | 0 | 1000 |  | 400 |  |  |  |  |  |  | 4000 | 100
 |  |  | 2 | 200 | 1000 |  | 400 |  |  |  |  |  | 111111 | 4000 | 100
 |  |  | 3 | 300 | 1000 |  | 400 |  |  |  |  |  |  | 4000 | 100
 |  |  | 4 | 400 | 1000 |  | 400 |  |  |  |  |  |  | 4000 | 100
 |  |  | 5 | 500 | 1000 |  | 400 |  |  |  |  |  |  | 4000 | 100
 |  |  | JUMLA
Spreadsheet: 270402d1381472271-conditional-value-in-a-particular-cell-dependent-on-value-in-another-cell-sample-xl
Sheet: Sheet1

Tenure in years | 1 | 1 | 100 | Ist Year Interest | 100
 |  | 2 | 100 | 2nd Year Interest | 200
 |  | 3 | 100 | 3rd Year Interest | 300
 |  | 4 | 100 | 4th Year Interest | 400
 |  | 5 | 100 | 5th Year Interest | 500
Result
Spreadsheet: 838479d1691045627-textsplit-function-is-it-possible-to-spill-an-empty-cell-with-zero-txtsplit-aligw-2-
Sheet: Sheet1

 | # Name |  | E1 | E2/ LP | Speed |  | E1 | E2 | LP | Speed
 | 1 Smoke Wagon |  | 86 | 85/ 73 | 67 |  |  |  | 73 |  |  |  |  |  |  |  |  | 85 | 73 | 67
 | 2 Global Hysteria |  | No Starts Available |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0
 | 3 I Strong |  | 86 | [NAME] 75 * | 71* |  |  |  | 75 |  |  |  |  |  |  |  | 86 | 86 | 75 | 71
 | 4 Maluma |  | No Starts Available |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0
 | 5 Warrior's Cause |  | 93 | 91/ 65 | 66 |  |  |  | 65 |  |  |  |  |  |  |  | 93 | 91 | 65 | 66
 | 6 Exclusive Entry |  | No Starts Available |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0
 | 7 Bundaburg |  | No Starts Available |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0
 | 8 Imposter Syndrome |  | 85 | 87/ 75 | 72 |  |  |  | 75 |  |  |  |  |  |  |  | 85 | 87 | 75 | 72
 | # Name |  | E1 | E2/ LP | Speed |  | E1 | E2 | LP | Speed
 | 3 Protectthewitness |  | No Starts Available |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 | 2 R Girl Faith |  | 79 | 73/ 61 * | 63* |  |  |  | 61 |  |  |  | 73 | 61 | 63
 | 5 Vaccina |  | 88 | 81/ 55 * | 63* |  |  |  | 55 |  |  |  | 81 | 55 | 63
 | 1 Phancy Philly |  | 79 | 67/ 51 * | 54* |  |  |  | 51 |  |  |  | 67 | 51 | 54
 | 4 Sailor's Salute |  | 82 | 71/ 50 * | 53* |  |  |  | 50 |  |  |  | 71 | 50 | 53
 | 6 Calvary Kat |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
Spreadsheet: 270439d1381486060-sumif-problem-sumifsforum
Sheet: VAT

 | Input VAT |  |  |  | Output VAT (Sales) |  | VAT
 | Overheads | Sub-contractors | Suppliers | TOTAL | Sales | TOTAL | Liability
Aug |  |  |  |  | [NAME] in this cell
Sep
Oct
Nov
Dec
Jan
Feb
Mar
Apr
May
Jun
Jul
Quarterly  return Period | Input VAT | Output VAT | VAT Liability | NET Input | NET Output | Return Sent | Return Paid
Aug, Sep, Oct |  |  |  |  |  | No | Unpaid | DUE END OF NOV
Nov, Dec, Jan |  |  |  |  |  | No | Unpaid | DUE END OF FEB
Feb, [NAME], Apr |  |  |  |  |  | Yes | Paid | DUE END OF MAY
May, Jun, Jul |  |  |  |  |  | Yes | Paid | DUE END OF AUG
Spreadsheet: 125586d1319116498-excel-2007-user-defined-search-and-calculate-copy-of-example
Sheet: Sheet1

UNIT COMPLIANCE | record 1 | record 2 | record 3 | record 4 | record 5 | record 6 | record 7 | record 8 | record 9 | record 10
Item Code Present | Y | N | Y | Y | Y | Y | Y | Y | Y | N
Date present | Y | Y | Y | N | Y | N | Y | Y | Y | Y
Signature present | Y | N | Y | Y | Y | Y | Y | Y | Y | N
Time present | N | Y | N | N | Y | Y | Y | Y | N | Y
Staff Member responsible | JP | PT | PT | HG | JP | JP | WT | WT | WT | HG
Staff member | Recordnr
pt | 2
Spreadsheet: darrell_schoolcraft__7322__imball0202
Sheet: PGETX

 |  |  |  |  | 12283
 | [NAME] |  | Pecos Del |  | Gunpoint #2 |  |  |  |  |  | [NAME] |  | Pecos Del |  |  |  | Imbalance
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled |  |  |  | Month | Measured | Scheduled | Measured | Scheduled | Imbalance | Index | Amount
1 | -39508 | 217 |  | -39867 |  |  |  |  |  | 2001-01-01 00:00:00 | -715680 | -355592 | 0 | -350072 |  | 8.26
2 | -28824 | 217 |  | -29867 |  |  |  |  |  | 2001-02-01 00:00:00 | -609189 | -341536 | -52379 | -306771 |  | 5.62
3 | -29526 | 217 |  | -29867 |  |  |  |  |  | 2001-03-01 00:00:00 | -1830618 | -794902 | -918 | -1033307 |  | 5.03
4 | -30161 | 217 |  | -15867 |  |  |  |  |  | 2001-04-01 00:00:00 | -3230259 | -1322613 |  | -2164184 |  | 4.99
5 | -37240 | 217 |  | -50976 |  |  |  |  |  | 2001-05-01 00:00:00 | -3482702 | -2020658 | -252797 | -1732396 |  | 4.01
6 | -28035 | -1757 |  | -26019 |  |  |  |  |  | 2001-06-01 00:00:00 | -3938526 | -3382042 |  | -1643833 |  | 3.51
7 | -41922 | -5885 |  | -34934 |  |  |  |  |  | 2001-07-01 00:00:00 | -3894744 | -2543771 | -671221 | -1981645 |  | 2.94
8 | -54425 | 217 |  | -54667 |  |  |  |  |  | 2001-08-01 00:00:00 | -4170940 | -3265860 | -1648101 | -2554228 |  | 2.85
9 | -59844 | -9648 |  | -49867 |  |  |  |  |  | 2001-09-01 00:00:00 | -3023464 | -2576525 | -92729 | -544473 |  | 1.96
10 | -59937 | -9648 |  | -49867 |  |  |  |  |  | 2001-10-01 00:00:00 | -2576641 | -1740603 | -37750 | -877765 |  | 2.15
11 | -60137 | -9648 |  | -49867 |  |  |  |  |  | 2001-11-01 00:00:00 | -2598109 | -1780898 | -233298 | -1038459 |  | 2.07
12 | -64767 | -33560 |  | -29867 |  |  |  |  |  | 2001-12-01 00:00:00 | -1166081 | -133483 |  | -1006789 |  | 2.26
13 | -84784 | -54883 |  | -29867 |  |  |  |  |  | 2002-01-01 00:00:00
14 | -66968 | -37416 |  | -29867
15 | -34062 | -4718 |  | -29867
16 | -44107 | -6327 |  | -37867
17 | -44107 | -6327 |  | -37867
18 | -44293 | -6327 |  | -37867 |  |  |  |  |  |  |  |  |  |  |  |  | -591014.35
19
20
21
22
23
24
25
26
27
28
29
30
31
 |  |  |  | 2002-01-31 00:00:00 |  |  | 9867
 |  |  |  | 2002-02-18 00:00:00
 | CBS Volume
 |  |  |  | 32476
 |  |  |  |  |  |  | 179468
 |  |  |  |  |  |  | 82546
Spreadsheet: robin_rodrigue__33265__CAN$1100
Sheet: TollExpl

SUMMARY OF TOLLS
AS OF
[NAME] | Description of Toll | Fuel % | Position | Curve | Currency/UOM | Comments
TOLL:ABC/KING | ANG tolls from ABC to [NAME] | 1.15 | yes | 0.08 | Cad/GJ
TOLL:AECO/ABC | Nova tolls from Aeco to ABC | N/A | yes | 0.12 | Cad/GJ | The curve is marked at $.12 for 31 day months and $.124 for 30 day months
TOLL:AECO/EMP | Nova tolls from Aeco to Empress | N/A | yes | 0.12 | Cad/GJ | The curve is marked at $.12 for 31 day months and $.124 for 30 day months
TOLL:AECO/MCNEIL | Nova tolls from Aeco to McNeil | N/A | yes | 0.12 | Cad/GJ | The curve is marked at $.12 for 31 day months and $.124 for 30 day months
TOLL:EMER/ST.CL | Great Lakes tolls from Emerson to St.Clair | 4.58 | no | 0.368 | Usd/MM
TOLL:EMP/EAST.Z | TCPL tolls from Empress to East Zone | 7.68 | yes | 0.89 | Cad/GJ | The curve is marked at $.936 till Oct 99; $[NAME] thereafter
TOLL:EMP/EMER | TCPL tolls from Empress to Emerson | 2.63 | no | 0.3398 | Cad/GJ
TOLL:EMP/WADD | TCPL tolls from Empress to Waddington | 9.1 | yes | 0.955 | Cad/GJ | The curve is marked at $.992 till Oct 99; $.995 thereafter
TOLL:KING/MALIN | PGT tolls from Kingsgate to Malin | 2.67 | yes | 0.347 | Usd/MM | We are aware of a scheduled decrease in tolls by $.05 for the year 2000 and thereafter but this is not reflected in the curve
TOLL:MCNEIL/MON | Foothills tolls from McNeil to Monchy | 1.3 | yes | 0.078 | Cad/GJ
TOLL:MONCH/CHI | [NAME] tolls from Monchy to Chicago | 4.6 | yes | 0.45 | Usd/MM
TOLL:MONCH/VEN | [NAME] tolls from Monchy to Ventura | 2.8 | no | 0.308 | Usd/MM
TOLL:SUMAS/STN2 | Westcoast tolls from [NAME] to Stn2 | 2.25 | yes | 0.225 | Cad/GJ
TOLL:WADD/BOS | IGT & TGP tolls from Waddington to Boston Citygate |  | no | 0.4 | Usd/MM
Note:  The above curves were based on published rate schedules from the pipelines, and include all firm transportation charges.  [NAME] maintains a binder which supports how the
curves were arrived at. For the most part the curves are based on current toll rates and are not adjusted for any anticipated rate changes.  The toll curves therefore
need to continually monitored for any material changes.
Spreadsheet: 5de023d7-d7a1-436c-ad4b-ac87be00c336
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
FPSAU | Test | FPSAU | Prostate-Specific Antigen, Ultrasensitive | PSA, Ultrasensitive | Electrochemiluminescence immunoassay (ECLIA) | Plain, Red-Top or serum gel tube: Red |  |  | 0.8 | mL | Draw blood in a red-top tube or serum gel tube. Spin down and send 0.8 mL of serum in plastic screw-capped tube, shipped frozen. | 0.3 mL | Specimens other than	Serum Anticoagulants other than	NA Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icteric	NA | 0.0 00 - 4.000 ng/mL   Roche ECLIA methodology   According to the American Urological Association, [NAME] should decrease and remain at undetectable levels after radical prostatectomy. The AUA defines biochemical recurrence as an initial PSA value 0.200 ng/mL or greater followed by a subsequent confirmatory PSA value 0.200 ng/mL or greater.  Values obtained with different assay methods or kits cannot be used interchangeably. Results cannot be interpreted as absolute evidence of the presence or absence of malignant disease.    Test Performed by: LabCorp Burlington                              1447 York Court                              Burlington, NC 27215 | Monday through Friday | 3 days | 5 - 7 days | 1 | 84153 |  |  |  |  | LabCorp Burlington
FPSAU | [NAME] | SERUM | Serum |  |  |  | Frozen | 14 days
FPSAU | Result | Z0983 | PSA, Ultrasensitive | PSA, Ultrasensitive | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 35741-8
Spreadsheet: 820414d1678099927-match-person-project-and-charge-help_match_project_person_charge
Sheet: Sheet2

[NAME] | [NAME] |  | [NAME] | Index Match | If Index | Filter
 |  | Test1
 |  | Test3 |  |  |  | 0.1
 |  | Test4 |  |  |  | 0.02
 | René
 |  | Test1
 | Michel
 | [NAME]
Spreadsheet: 86498d1286463552-excel-2007-finding-the-difference-in-time-sample_timedifference
Sheet: Sheet1

Original Data Set
End date Range |  | Start Date
1/11/2009 01:00 - 02:00 |  | 2009-10-07 14:35:49
Step 1:
End Date Range | End Date instance | Start Date
1/11/2009 01:00 - 02:00 |  | 2009-10-07 14:35:49
Step 2:
End Date Range | End Date instance | Start Date | Time Window
1/11/2009 01:00 - 02:00 |  | 2009-10-07 14:35:49
Possible Solution:
End date Range | End Date Instance | Start Date | Time Window
1/11/2009 01:00 - 02:00 |  | 2009-10-07 14:35:49
New Issue:
13/11/2009 12:00 - 13:00 |  | 2009-11-03 08:34:20
Spreadsheet: 162929d1340120720-search-multiple-spreadsheets-d-report-log-2012
Sheet: SEARCH

 | [NAME]: |  | Black
NHSP-W DISCIPLINARY REPORT LOG
D-Report Number | Date | Inmate | Reporting Staff | Violation(s) |  |  |  |  | Date of Disposition | Date of Hearings | Outcome | Sanctions (in days) |  |  |  |  |  |  |  |  |  |  |  | Notes
 |  |  |  |  |  |  |  |  |  |  | PG, FWOP, BS, Inc, FG, FNG | P/S | [NAME] | XD | Lost Cant | Lost Rec | Lost Radio | Lost TV | Lost Phone | Lost Radio | Good Time | Lost Visit | Restitution
02-03 | 2012-02-05 00:00:00 | Black | 333 | 8 | 0 | 0 | 0 | 0 | 2012-02-08 00:00:00 | 1900-01-01 00:00:00 | FNG | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | February 2012
03-02 | 2012-03-06 00:00:00 | Black | 222 | 2 | 57 | 0 | 0 | 0 | 2012-03-10 00:00:00 | 1900-01-01 00:00:00 | PG | 0 | 0 | 100 | 0 | 0 | 5 | 0 | 0 | 0 | 0 | 100 | 0 | 0 | 2 | March 2012 |  | 0 | 0 | January 2012
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | February 2012
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2 | March 2012
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | April 2012
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | May 2012
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | June 2012
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | July 2012
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | August 2012
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | September 2012
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | October 2012
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | November 2012
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | December 2012
Spreadsheet: 73612d1274262616-change-a-number-looking-vs-date-interst-system
Sheet: Sheet1

 | current date |  | loan | % late | % on time | weeks behind payment | Money Owed | extra cost | Total repayable
 | 16.5.10 |  |  |  |  | 1 |  | 0
 | end date |  | 200 | 25 | 20
 | 10.5.10
 |  |  | Interest rate based on loan
 |  |  |  | week delay | iterest owed | total inc int.
 |  |  | base interest | 1
 |  |  |  | 2
 |  |  |  | 3
 |  |  |  | 4
 |  |  |  | 5
Spreadsheet: 708234d1607684825-non-consecutive-count-sample-workbook
Sheet: Interruption

Number of interruptions |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No of hours lost
 | STATUS | MAX LOAD | AVG LOAD | EF | BF | RF | DC | IMB | OC | EMG | LS | SG | LSG | NS | SS | TOTAL | EF | BF | RF | DC | IMB | OC | EMG | LS | S.G | LSG | TX LIMT | SS | TOTAL
ALUU | ACTIVE | 7 | 2.3 |  |  |  |  |  |  |  |  |  |  | 1 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 18 | 0
CHOBA | ACTIVE | 9 | 2.383333333333333 |  |  |  |  |  |  |  |  |  |  | 1 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 18 | 0
RUMUEKINI | ACTIVE | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
SARS ROAD |  |  |  |  |  |  |  |  |  |  | 2 |  |  | 1 | 1 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 0 | 0 | 8 | 5
ADP | ACTIVE | 38 | 3.6 |  |  |  |  |  |  |  | 3 |  |  | 1 | 1 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 0 | 0 | 8 | 5
MARKET ROAD | ACTIVE | 32 | 4.199999999999999 |  |  |  |  |  |  |  | 2 |  |  | 1 | 1 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 0 | 0 | 8 | 5
OPM | ACTIVE | 39 | 2.528571428571428 |  |  |  |  |  |  |  | 2 |  |  | 1 | 1 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 0 | 0 | 8 | 1
SHELL ESTATE | ACTIVE | 83 | 0.4466666666666666 |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 1
PIPE LINE | ACTIVE | 47 | 2.722222222222222 | 1 |  |  |  |  |  |  | 1 |  |  | 1 | 1 |  | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 0 | 8 | 1
AIRPORTCOMPLEX | ACTIVE | 91 | 0.9608695652173914 |  |  |  |  |  |  |  |  |  |  | 1 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0
IGWURUTA | INACTIVE
IGWURUTA ROAD | ACTIVE | 21 | 4.74 |  |  |  |  |  |  |  | 1 |  |  | 2 | 1 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 11 | 6
ELIMGBU | ACTIVE | 19 | 4.45 |  |  |  |  |  |  |  | 3 |  |  | 2 | 1 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 0 | 11 | 6
TOTAL |  |  |  | ignore this yellow bit as well as no of hours lost.
MBAK | ACTIVE | 38 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 24 | 0
IDORO ROAD | ACTIVE | 37 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 24 | 0
AKA ROAD | ACTIVE | 43 | 4.75 | 1 |  |  |  |  |  |  | 2 |  |  |  |  |  | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 12 | 0 | 0 | 0 | 4
IBB AVENUE | ACTIVE | 38 | 3.933333333333334 | 1 |  |  |  |  |  |  | 2 |  |  | 1 | 1 |  | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 0 | 0 | 1 | 5
INDONGESIT NKANGA | ACTIVE | 114 | 0.2055555555555556 |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 5
SIR UDO UDOMA | ACTIVE | 46 | 2.5 |  |  |  |  |  |  |  | 2 |  |  | 1 | 1 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 0 | 0 | 1 | 5
Spreadsheet: 769649d1645628627-populate-an-excel-calendar-with-information-from-sheet-in-same-workbook-ef1567_opi-job-track-calendar
Sheet: Calendar

 |  | 2022-02-01 00:00:00
 |  | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
 |  |  |  |  |  |  |  |  |  | Key:
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 |  | 2022-03-01 00:00:00
 |  | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
 |  | 2022-04-01 00:00:00
 |  | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday