tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 885165d1734599291-find-related-order-no-in-ascending-order-through-excel-formula-tap_mc-series
Sheet: tap_mc_order

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Machine | Order Nos |  | Machine  Dynamic daywise change | Need to find related [NAME] no related to machine in ascending order |  |  |  |  | related Order no related to machine in ascending order |  |  | Mc no only numerical | Mc no in series | concat mc
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MC-9 | 256 |  | MC-2 |  |  |  |  | [NAME] | 253
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MC-9 | 257 |  | MC-2 |  |  |  |  | [NAME] | 255
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MC-9 | 251 |  | MC-5 |  |  |  |  | MC- 5 | 251
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MC-8 | 254 |  | MC-8 |  |  |  |  | MC- 8 | 254
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MC-11 | 252 |  | MC-9 |  |  |  |  | MC- 9 | 251
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MC-10 | 255 |  | MC-9 |  |  |  |  | MC- 9 | 256
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MC-12 | 255 |  | MC-9 |  |  |  |  | MC- 9 | 257
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MC-2 | 255 |  | MC-10 |  |  |  |  | MC-10 | 255
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MC-2 | 253 |  | MC-11 |  |  |  |  | MC-11 | 252
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MC-9 | 251 |  | MC-12 |  |  |  |  | MC-12 | 255
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MC-8 | 254
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MC-11 | 252 |  |  |  |  |  |  | Figures to match - This is required FINALLY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MC-10 | 255
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MC-12 | 255
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MC-5 | 251
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MC-8 | 254
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MC-9 | 251
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MC-10 | 255
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MC-11 | 252
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MC-12 | 255
Spreadsheet: 798698d1664650957-formula-to-calculate-how-many-people-attended-2-named-events-from-a-single-list-test-sheet
Sheet: Sheet1

My Data |  |  | What I want to show:
Name | Event |  |  | No of shared attendees
[NAME] | A |  | Event 1 | Event 2 | No of Attendees | notes: |  |  | version with SUMPRODUCT prepared before I discovered John_with_trailing_space in A11
[NAME] | B |  | A | B | 2 | [NAME] and [NAME]
[NAME] | C |  | A | C | 0 | 1 - John!
[NAME] | A |  | A | D | 1 | [NAME]
[NAME] | B |  | B | C | 0 | 1 - John!
[NAME] | D |  | B | D | 0 | 1 - John!
[NAME] | B |  | C | D | 0 | 1 - John!
Spreadsheet: 189764d1351330199-spotting-differences-between-2-columns-book1
Sheet: Sheet1

2012-10-10 00:00:00 | 27/10/2012 | Added | Removed
[NAME] | [NAME] | [NAME] | [NAME]
Adam | Adam | [NAME] | Ashely
[NAME] | [NAME]
[NAME] | [NAME]
Ashely | [NAME]
[NAME] | [NAME]
Spreadsheet: 487140d1477934212-array-small-and-or-function-extract-data-for-given-date-match-function
Sheet: all

 |  |  |  |  |  |  | vacation 1-st part |  |  |  |  | vacation 2-nd part |  |  |  |  | vacation 3-rd |  |  |  |  | vacation 4-th part
р.бр. | name | section | religious holiday | whole vacation | vacation left |  | no of days | beginning | без славе | end |  | days | beginning | без славе | end |  | days | beginning | без славе | end |  | days | beginning | без славе | end
1 | employe 1 | 1 | 2016-11-21 00:00:00 | 25 |  |  | 10 | 2016-11-18 00:00:00 |  |  |  | 5 | 2016-12-26 00:00:00
 | employe 2 | 2 | 2016-11-22 00:00:00 | 25 |  |  | 15 | 2016-08-12 00:00:00
 | employe 3 | 1 | 2016-11-23 00:00:00 | 25 |  |  | 15 | 2016-07-25 00:00:00
 | employe 4 | 3 | 2016-11-24 00:00:00 | 25 |  |  | 10 | 2016-09-15 00:00:00 |  |  |  | 10 | 2016-07-25 00:00:00
 | employe 5 | 1 | 2016-11-25 00:00:00 | 25 |  |  | 10 | 2016-07-01 00:00:00
 | employe 6 | 4 | 2016-11-26 00:00:00 | 25 |  |  | 10 | 2016-07-15 00:00:00 |  |  |  | 5 | 2016-09-15 00:00:00
 |  |  |  |  |  |  | I can make it to work between I and K columns but I don't know how to add other ranges and how to exclude #num values from list belowe
 | for a date:
 | 2016-07-26 00:00:00
Spreadsheet: 846124d1697438685-countifs-with-wildcards-tempcountifs-2-aligw
Sheet: Data

DATA |  |  |  |  |  | Summary
Date | Character | Lessons_Abs | Code |  |  | Date | Code | Character | Count | AliGW
2023-02-20 00:00:00 | 4 | 1 | RAD |  |  | 2023-02-20 00:00:00 | RAD | H
2023-02-20 00:00:00 | 6 | 1 | RAD |  |  | 2023-02-20 00:00:00 | RAD | 1
2023-02-20 00:00:00 | H 1 2 | 2.2 | RAD |  |  | 2023-02-20 00:00:00 | LAL | 2
2023-02-20 00:00:00 | H 1 2 3 4 5 6 | 6.2 | RAD |  |  | 2023-02-20 00:00:00 | RAD | 3
2023-02-20 00:00:00 | H 1 2 3 4 5 6 | 6.2 | RAD |  |  | 2023-02-20 00:00:00 | RAD | 4
2023-02-20 00:00:00 | H 1 2 3 4 5 6 | 6.2 | RAD |  |  | 2023-02-20 00:00:00 | LAL | 5
2023-06-15 00:00:00 | H 1 2 3 4 5 6 | 6.2 | RAD |  |  | 2023-02-20 00:00:00 | RAD | 6
2023-06-15 00:00:00 | H 1 2 3 4 5 6 | 6.2 | RAD
2023-06-15 00:00:00 | H 1 2 3 4 5 6 | 0 | RAD
2023-02-08 00:00:00 | 5 6 | 2 | LAL
2023-03-09 00:00:00 | H 1 2 3 4 5 6 | 6.2 | LAL
Spreadsheet: craig_dean__4379__Frontera Heat Rate Charts FB
Sheet: Inputs

 |  | Input
 |  | 85 | Ambient Temp [DefF]
 |  | 0.75 | Relative Humidity [%]
 |  | 0.045 | AFI ('Derate')
 | 10 | 9 | 8 | 7 | 6 | 5 | 4 | 3 | 2 | 1
 | 7000 | 8000 | 9500 | 9510 | 9520 | 9530 | 9540 | 9550 | 9600 | 9650
 | 255
 |  | Ambient Temperature [DegF] |  |  | Range = 40-110 (by 10's)
 |  | Relative Humidity [%] |  |  | Range = 20 -100 (by 20's)
Spreadsheet: 872054d1718404930-fetching-data-from-list-example-stefanocps-
Sheet: MIL

Name 1 | code | Attention of | E-Mail
Spreadsheet: geir_solberg__11288__12-30act
Sheet: EPEData

 | 37351.31666666667
 | NEWMAN 1 ,UNAV, -0  , 75  , 39  , 83  ,  0  ,1
 | NEWMAN 2 ,MANL, 31  , 77  , 34  , 83  ,  0  ,1
 | NEWMAN 3 ,MANL, 89  ,100  , 35  ,103  ,  0  ,1
 | NEWMN/GT1,MANL, 30  , 60  , 18  , 60  ,  0  ,1
 | NEWMN/GT2,MANL, 30  , 60  , 18  , 60  ,  0  ,1
 | NM/GT1+ST,UNAV,  0  ,100  , 61  ,107  ,  0  ,1
 | NM/GT2+ST,UNAV,  0  ,100  , 66  ,107  ,  0  ,1
 | NEWMAN 4 ,UNAV,  0  ,215  , 86  ,214  ,  0  ,1
 | NEWMAN   ,, 180 ,  297,  105, 306 ,   0 ,
 | COPPER   ,[NAME], -0  , 69  , 15  , 69  ,  0  ,1
 | RIOGRAN 6,AVAL,  0  , 47  , 29  , 48  ,  0  ,1
 | RIOGRAN 7,AVAL,  0  , 38  , 32  , 49  ,  0  ,1
 | RIOGRAN 8,UNAV,  0  ,121  , 36  ,151  ,  0  ,1
 | RIOGRANDE,,   0 ,    0,    0,   0 ,   0 ,
 | PALOVERDE,MANL,604  ,600  ,600  ,600  ,  0  ,1
 | FOURCRNRS,MANL, 91  , 91  , 91  ,104  ,  0  ,1
 | LAMBDA, 38.69,  624,  626,  120,   10,    0,13220,0
 | APS     ,STRT    ,FC,  ,   1,   1
 | IID     ,EXCS    ,FC,  ,  50,  50
 | IID     ,FIRM    ,PV,  , 100, 100
 | LDWP    ,ECON    ,PV,  ,  80,  80
 | PGT     ,LOSS    ,PV,  ,  -1,  -1
 | PNM     ,CNTG    ,LC,  ,  11,  11
 | PNM     ,LOSS    ,LC,  ,   2,   2
 | SPS     ,FIRM    ,WM,  ,-103,-103
 | SRP     ,FIRM    ,ED,  ,  25,  25
 | SRP     ,LOSS    ,PV,  ,   1,   1
 | TNP     ,FIRM    ,PV,  ,  25,  25
 | TNP     ,LOSS    ,PV,  ,  -5,  -5
 | WAPA    ,PASS    ,WM,HO,  -1,  -1
Spreadsheet: 832133d1686140082-formula-to-sort-two-columns-within-a-range-excel-help-sort
Sheet: Sheet1

Product | Units Sold | Revenue | Views | CR
White Top | 9 | 2840 | 537 | 0.01675977653631285
Black Jumpsuit | 15 | 6385 | 502 | 0.0298804780876494
Sunset Dress | 5 | 2475 | 499 | 0.01002004008016032
White Dress | 9 | 5820 | 497 | 0.01810865191146881
White Jumpsuit | 2 | 780 | 494 | 0.004048582995951417
Gold Jumpsuit | 8 | 3515 | 486 | 0.01646090534979424
Gold Dress | 12 | 4780 | 470 | 0.02553191489361702
Purple Dress | 5 | 2175 | 429 | 0.01165501165501166
White Jumpsuit | 3 | 2035 | 416 | 0.007211538461538462
White Jumpsuit | 2 | 1060 | 390 | 0.005128205128205128
White Dress | 7 | 3485 | 389 | 0.01799485861182519
Gold Dress | 2 | 755 | 376 | 0.005319148936170213
White Jumpsuit | 2 | 510 | 357 | 0.005602240896358543
Blush Dress | 4 | 1460 | 344 | 0.01162790697674419
Pink Jumpsuit | 3 | 1650 | 342 | 0.008771929824561403
White Dress | 7 | 3085 | 327 | 0.02140672782874618
Blue Dress | 4 | 1555 | 325 | 0.01230769230769231
Red Jumpsuit | 1 | 315 | 299 | 0.003344481605351171
White Dress | 2 | 990 | 275 | 0.007272727272727273
Purple Jumpsuit | 11 | 5430 | 259 | 0.04247104247104247
Spreadsheet: 182497d1348504190-help-need-with-calculating-data-based-off-drop-down-list-test_scorecard_1
Sheet: Saturday

Dell@ Daily Tracker/Dashboard
Store: | Sale |  |  |  |  |  |  |  |  |  |  |  |  | DPA |  |  | Quotes |  |  |  | Business Leads
 |  |  |  |  |  |  |  |  |  |  | Goal 2.0 |  |  | Goal 50% |  |  | Goal is 25 per day, with 60% emailed.
Associates Name | Customer | DPID | Dell.com | Inventory | Lost Sale | What Reason | Total | Revenue | System | Model | SnP | Warranty | [NAME] | Enroll     No | [NAME] | [NAME] Declined | [NAME] | [NAME] | Other Quote | Total Quote | Business Name | System total | Rep Assisting
[NAME] | [NAME] | 20000000000000 | 1 |  |  |  |  | 2000 | XPS | 8500 | 2 | 1yr | 50 | 1
Totals
Spreadsheet: 151921d1335188106-how-to-visually-separate-rows-with-same-data-example_reply-2-
Sheet: Sheet1

No | Description | Value 1
16054-2 | Lot 2 Guitar.. | 22
16054-2 | Lot 2 Guitar.. | 22
17169-EDM | New Deluxe [NAME]… | 12
17169-EDM | New Deluxe [NAME]… | 12
17169-EDM | New Deluxe [NAME]… | 12
18013-EDM | Sporting Binoculars… | 11
18013-EDM | Sporting Binoculars… | 11
18013-EDM | Sporting Binoculars… | 11
23041-TAISO752 | [NAME] | 13
23041-TAISO752 | [NAME] | 13
23041-TAISO752 | [NAME] | 13
23139 | [NAME]… | 16
23139 | [NAME]… | 16
23139 | [NAME]… | 16
16086 | New Cymbal… | 55
16086 | New Cymbal… | 55
16086 | New Cymbal… | 55
18065 | New Dart Board… | 65
18065 | New Dart Board… | 65
18065 | New Dart Board… | 65
18065 | New Dart Board… | 65
18065 | New Dart Board… | 65
23044-BMC | New Deluxe 40 Piece… | 78
23044-BMC | New Deluxe 40 Piece… | 78
23044-BMC | New Deluxe 40 Piece… | 78
Spreadsheet: 120151d1315014626-pivot-tables-help-pivothelp
Sheet: Data

Input | Output | Mark
DI1 | DO1 | SD
DI1 | DO2 | CL
DI1 | DO3 | I
DI1 | DO4 | I
DI1 | DO5 | I
DI1 | DO6 | I
DI1 | DO7 | I
DI1 | DO8 | x
DI1 | DO9 | I
DI1 | DO10 | I
DI2 | DO4 | I
DI2 | DO6 | I
DI2 | DO9 | I
DI2 | DO10 | I
DI3 | DO6 | I
DI3 | DO7 | I
DI3 | DO8 | I
DI3 | DO9 | I
DI3 | DO10 | I
[NAME] | DO7 | I
[NAME] | DO8 | I
[NAME] | DO9 | x
[NAME] | DO10 | I
[NAME] | DO11 | I
[NAME] | DO12 | I
[NAME] | DO13 | I
[NAME] | DO14 | I
[NAME] | DO15 | I
[NAME] | DO16 | I
[NAME] | DO17 | I
[NAME] | DO18 | I
[NAME] | DO19 | q
[NAME] | DO20 | I
[NAME] | [NAME] | I
[NAME] | DO22 | I
Spreadsheet: louise_kitchen__24114__KO_Netco Grp _ EEs on 12-19
Sheet: Acctg

Accounting
GISID | EMPLOYEE_NAME | [NAME] | JOBGROUP
90005554 | [NAME], STACEY A | Mgr Acctg | MGR-CS
90005580 | BELTRI, ANGELES O | Mgr Acctg | MGR-CS
90011317 | BRANNEN, [NAME] | [NAME] | SPECSR-CS
90005549 | BROWN, SARAH | Mgr Acctg | MGR-CS
90010049 | COLWELL, [NAME] | [NAME] Acctg | MD-CS
90012266 | DAY, MISTI LYNN | Spec Acctg | SPEC-CS
90154730 | EASTWOOD, ANNE M | [NAME] | SPECSR-CS
90123812 | ELLIS, KELLY J | [NAME] | ASST-CS
90143060 | FELLERS, [NAME] | [NAME] | SPECSR-CS
90005495 | GREENE, TRACY A | [NAME] | SPECSR-CS
90005421 | GRUESEN, [NAME] | Mgr Acctg | MGR-CS
90006183 | GUERRA, RICARDO J | Spec Acctg | SPEC-CS
90134647 | GUILLIAMS, LISA | Spec Acctg | SPEC-CS
90005557 | HARDY, [NAME] | [NAME] | SPECSR-CS
90005577 | HARDY, STACY | [NAME] | SPECSR-CS
90129378 | HARRIS, KIMBERLY DAWN | Mgr Acctg | MGR-CS
90005488 | HARRIS, PAULA J | Mgr Acctg | MGR-CS
90128202 | HERNANDEZ, ANAMARIA C | Analyst - Rotation 2 | ANL-C
90011544 | HODGES, GEORGANNE M | Vice President Accounting | VP-CS
90006497 | INGRAM, RENEE H | [NAME] | ASSTSR-CS
90005492 | IRVIN, TRACY E | Mgr Acctg | MGR-CS
90142609 | [NAME], NIKOLE | Staff Acctg | SPECJR-CS
90006267 | KACAL, LYNNA M | Spec Acctg | SPEC-CS
90005494 | KILLEN, FAITH L | [NAME] | DIR-CS
90005848 | LESCHBER, EDITH G | Mgr Acctg | MGR-CS
90131076 | LO, CONNIE | Spec Acctg | SPEC-CS
90006499 | LONGORIA, JENNIFER | SR CLERK | ADMSR-CS
90134898 | MAYEUX, CASSANDRA | Spec Acctg | SPEC-CS
90005505 | MCPEARSON, SHANNON N | [NAME] | SPECSR-CS
90005559 | MOORE, [NAME] | Specialist Graphics | SPEC-CS
90125788 | PATRICK, [NAME] | VP Trans Suppt | VP-ST
90128759 | PEARCE, BARRY J | VP Comm Trading Supt | VP-CS
90130421 | PRICE, JON C | Staff Acctg | SPECJR-CS
90011410 | SCHIELD, ELAINE P | Sr Director Accounting | DIRSR-CS
90128227 | SCHULTZ, AMANDA J | Analyst - Rotation 2 | ANL-C
90005845 | SHEPPERD, TAMMY R | [NAME] | DIR-CS
90011525 | SHERMAN, RICHARD C | VP Trans Suppt | VP-ST
90005555 | SIMPER, KEITH A | [NAME] | SPECSR-CS
90152792 | SMITH, JENNIFER L | [NAME] | SPECSR-CS
90006608 | TIJERINA, SHIRLEY D | [NAME] | COORD-CS
90040618 | [NAME], [NAME] | [NAME] | SPECSR-CS
90005578 | VARGAS, ESPERANZA | [NAME] | DIR-CS
90005501 | WARWICK, TODD C | Mgr Acctg | MGR-CS
90005746 | WHITING, GREGORY A | [NAME] | DIR-CS
90005558 | WOLFE, STEPHEN D | [NAME] | SPECSR-CS
 |  | Employees
Spreadsheet: 272916d1382546419-array-formula-required-to-get-the-employee-details-employee-detail-zouraiz-231013
Sheet: Output

Select Employee Id from the List | 2001
Employee Performance Details
Month | Branch | Branch Target | Contribution
Spreadsheet: 0da26467-4efd-418f-b933-9d57b26eb1ad
Sheet: Electron - Quark

 |  |  |  | mu/X | 17221.97322 |  |  | Electron mass | 510.998928 | d Electrons | 0.000853222136
 |  |  |  | X |  |  |  | Muon mass | 105658.36668 | d Quarks
 |  |  |  | mu |  | Kev/c2 |  | Tauon mass | 1776840
Particle | P | N | K | NP | R | R + kd | Volume | Calculated ratio | Measured ratio | Difference | Calculated Mass
Electron | 2 | 2 | 2 |  |  |  |  |  | - | - | -
Muon | 5 | 5 | 3
Tauon | 9 | 9 | 5
 |  |  |  |  |  |  |  |  |  | Quarks mass ranges, measured
Particle | P | N | K | NP | R | R + kd | Volume | Calculated Ratio | Calculated Mass | Min | [NAME] | Med
Up | 2 | 3 | -6 |  |  |  |  |  |  | 1.7 | 3.3
Down | 2 | 4 | -6 |  |  |  |  |  |  | 4.1 | 5.8
Charm | 3 | 14 | -6 |  |  |  |  |  |  | 1180 | 1340
Strange | 3 | 7 | -6 |  |  |  |  |  |  | 80 | 130
Top | 3 | 38 | -6 |  |  |  |  |  |  | 171700 | 173300
Bottom | 3 | 19 | -6 |  |  |  |  |  |  | 4130 | 4370
 |  |  | R |  |  | Radius before correction (1/NP)
 |  |  | R + kd |  |  | Radius after correction (1/NP + kd)
 |  |  | Volume |  |  | Volume (R+kd)**3
 |  |  | Calculated Ratio |  |  | Ratio = (1/Volume + mu/X) / (1/Electron.volume + mu/X)
 |  |  | Calculated Mass |  |  | Particle calculated mass ([NAME]/c2) = Electron mass * ratio
 |  |  | Note: For the Up quark, NP = 7 will work too.
Spreadsheet: 75192d1275722749-concatenating-sample
Sheet: Sheet1

0203237 | J000018918 | BPO-10911
0203237 | J000018918 | 2001
0203237 | J000018919 | BPO-10831
0203237 | J000018919 | PERIODIC SUPPLY OF GAS COMPRESSOR SPARE PARTS
0203237 | J000018919 | 2001
0203237 | J000018920 | BPO-10144
0203237 | J000018920 | INSTRUMENTATION ITEMS
0203237 | J000018920 | 2000
0203237 | J000018921 | BPO-001/01-A
0203237 | J000018921 | CASING,TUBING&ACCESSORIES
0203237 | J000018921 | 2001
0203237 | [NAME] | BPO-10108    SPK/SC23/M00
0203237 | [NAME] | INSTRUMENTATION ITEMS
0203237 | [NAME] | 2000
0203237 | J000018923 | BPO-002/01
0203237 | J000018923 | LINE PIPES
0203237 | J000018923 | 2002
0203237 | J000018924 | BPO-10084   SPK/SC21/M00
0203237 | J000018924 | FITTING&VALVES
0203237 | J000018924 | 2000
0203237 | J000018925 | BPO-10081  SPK/SC22/M00
0203237 | J000018925 | FITTING&VALVES
0203237 | J000018925 | 2000
0203237 | J000018926 | SPK/SC43/MP00/PG/SC11/MP00
0203237 | J000018926 | SUPPLY OF PIPING MATERIALS
0203237 | J000018926 | 2000
0203237 | J000018927 | BPO-10089  SPK/SC25/M00
0203237 | J000018927 | INSTRUMENTATION ITEMS
0203237 | J000018927 | 2000
0203237 | J000018928 | BPO-9799    SPK-168-A
0203237 | J000018928 | LUBRICATION OIL
0203237 | J000018928 | 2000
0203237 | J000018929 | BPO-9864   SPK/SC44/M00
0203237 | J000018929 | ELECTRICAL ITEMS
0203237 | J000018929 | 2000
0203237 | J000018930 | BPO-9873    SPK/-193
0203237 | J000018930 | PERIODIC SUPPLY OF FIRE&SAFETY ITEMS
0203237 | J000018930 | 2000
0203237 | J000018931 | BPO-9880   [NAME]
0203237 | J000018931 | PERIODIC SUPPLY OF AIR COMPRESSOR SPARE PARTS
0203237 | J000018931 | 2000
0203237 | J000018932 | [NAME]   [NAME]
0203237 | J000018932 | PERIODIC SUPPLY OF SPARE PARTS MILITON ROY,NIJHUIS
0203237 | J000018932 | FOOTE SPKNES  AURORA,DEMING,GOULDS,PEERLESS,SEW
0203237 | J000018932 | DURODRIVE,UNION&WORTHNGTON PUMPS
0203237 | J000018932 | 2000
0203237 | J000018933 | BPO-9996   SPK/SC15/M00
0203237 | J000018933 | PERIODIC SUPPLY OF ELECTRICAL ITEMS
0203237 | J000018933 | 2000
0203237 | J000018934 | [NAME]
0203237 | J000018934 | PERIODIC SUPPLY OF SPARE PARTS
0203237 | J000018934 | 2000
0203237 | J000018935 | BPO-9956   SPK/SC37/M00
0203237 | J000018935 | PERIODIC SUPPLY OF PUMPS SPARE PARTS
0203237 | J000018935 | 2000
0203237 | J000018936 | BPO-9953   SPK-195
0203237 | J000018936 | PERIODIC SUPPLY OF WELDING MATERIALS &TOOLS
0203237 | J000018936 | 2000
0203237 | [NAME] | BPO-9942    SPK-191
0203237 | [NAME] | PERIODIC SUPPLY OF HOSE &FITTINGS
0203237 | [NAME] | 2000
0203238 | J000018938 | SPK/SC03/S00SUPPLY OF MANPOWER FOR CLEANING&
0203238 | J000018938 | ASSOCIATED SERVICES
0203238 | J000018938 | 2000
0203238 | J000018939 | SPK/SC01/D98
0203238 | J000018939 | EXPLORATORY AND DEVELOPMENT DRILLING AND RELATED
0203238 | J000018939 | SERVICES
0203238 | J000018939 | 2000
0203238 | J000018940 | SPK/SC46/MM00
0203238 | J000018940 | HIRE OF NON-CORE HEAVY EQUIPMENT
0203238 | J000018940 | 2001
0203238 | J000018941 | [NAME]
0203238 | J000018941 | MACHINE SHOP SERVICES
0203238 | J000018941 | 1999
Spreadsheet: 62778d1263775663-reference-previous-weekday-to-exclude-holidays-holidays
Sheet: Sheet 1

2009-12-07 00:00:00 | Mon | 4.5 | 4.5 |  |  |  |  |  | Mon | Tue | Wed | Thu | Fri | Week Day
2009-12-08 00:00:00 | Tue | 4.5 |  | 4.5
2009-12-09 00:00:00 | Wed | 4.35 |  |  | 4.35 |  |  | Previous Week | 4.1 | 4.35 | 4.1 | 4.3
2009-12-10 00:00:00 | Thu | 4.35 |  |  |  | 4.35 |  | Current Week | 4.3 | 4.25 | 4.25 | 4.7 | 4.3
2009-12-11 00:00:00 | Fri | 4.4 |  |  |  |  | 4.4 | Change | 0.2000000000000002 | -0.09999999999999964 | 0.1500000000000004 | 0.4000000000000004 | #N/A
2009-12-14 00:00:00 | Mon | 4.4 | 4.4 |  |  |  |  |  | 0.04651162790697679 | -0.0235294117647058 | 0.03529411764705891 | 0.08510638297872347 | #N/A
2009-12-15 00:00:00 | Tue | 4.01 |  | 4.01
2009-12-16 00:00:00 | Wed | 4.15 |  |  | 4.15
2009-12-17 00:00:00 | Thu | 4.15 |  |  |  | 4.15
2009-12-18 00:00:00 | Fri | 4.15 |  |  |  |  | 4.15
2009-12-21 00:00:00 | Mon | 4.25 | 4.25
2009-12-22 00:00:00 | Tue | 4.25 |  | 4.25
2009-12-23 00:00:00 | Wed | 4.25 |  |  | 4.25
2009-12-24 00:00:00 | Thu | 4.25 |  |  |  | 4.25
2009-12-28 00:00:00 | Mon | 4.2 | 4.2
2009-12-29 00:00:00 | Tue | 4.15 |  | 4.15
2009-12-30 00:00:00 | Wed | 4.1 |  |  | 4.1
2009-12-31 00:00:00 | Thu | 4.58 |  |  |  | 4.58
2010-01-04 00:00:00 | Mon | 4.1 | 4.1
2010-01-05 00:00:00 | Tue | 4.35 |  | 4.35
2010-01-06 00:00:00 | Wed | 4.1 |  |  | 4.1
2010-01-07 00:00:00 | Thu | 4.3 |  |  |  | 4.3 |  |  |  |  | compare
2010-01-08 00:00:00 | Fri | 4.3 |  |  |  |  | 4.3
2010-01-11 00:00:00 | Mon | 4.3 | 4.3
2010-01-12 00:00:00 | Tue | 4.25 |  | 4.25
2010-01-13 00:00:00 | Wed | 4.25 |  |  | 4.25
2010-01-14 00:00:00 | Thu | 4.7 |  |  |  | 4.7
Spreadsheet: 0a518fe4-c9e0-426f-af78-fb30667885ac
Sheet: Summary

Lane Number 1 |  |  |  |  |  |  |  |  |  | Lane Number 2
Parameter | Spec | Measured  Value | Pass/Fail | Margin | Margin % | Test  Equipment |  |  |  | Parameter | Spec | Measured  Value | Pass/Fail | Margin | Margin % | Test  Equipment
 |  |  |  |  |  | VNA |  |  |  |  |  |  |  |  |  | VNA
 |  |  |  |  |  | VNA |  |  |  |  |  |  |  |  |  | VNA
 |  |  |  |  |  | VNA |  |  |  |  |  |  |  |  |  | VNA
 |  |  |  |  |  | VNA |  |  |  |  |  |  |  |  |  | VNA
 |  |  |  |  |  | VNA |  |  |  |  |  |  |  |  |  | VNA
 |  |  |  |  |  | VNA |  |  |  |  |  |  |  |  |  | VNA
 |  |  |  |  |  | BERTScope |  |  |  |  |  |  |  |  |  | BERTScope
 |  |  |  |  |  | BERTScope |  |  |  |  |  |  |  |  |  | BERTScope
 |  |  |  |  |  | BERTScope |  |  |  |  |  |  |  |  |  | BERTScope
 |  |  |  |  |  | BERTScope |  |  |  |  |  |  |  |  |  | BERTScope
 |  |  |  |  |  | BERTScope |  |  |  |  |  |  |  |  |  | BERTScope
 |  |  |  |  |  | Sampling Scope |  |  |  |  |  |  |  |  |  | Sampling Scope
 |  |  |  |  |  | Sampling Scope |  |  |  |  |  |  |  |  |  | Sampling Scope
 |  |  |  |  |  | Sampling Scope |  |  |  |  |  |  |  |  |  | Sampling Scope
 |  |  |  |  |  | Sampling Scope |  |  |  |  |  |  |  |  |  | Sampling Scope
 |  |  |  |  |  | Sampling Scope |  |  |  |  |  |  |  |  |  | Sampling Scope
 |  |  |  |  |  | Sampling Scope |  |  |  |  |  |  |  |  |  | Sampling Scope
Please paste screen shot from BERTScope testing here |  |  |  |  |  |  |  |  |  | Please paste screen shot from BERTScope testing here
Lane Number 3 |  |  |  |  |  |  |  |  |  | Lane Number 4
Parameter | Spec | Measured  Value | Pass/Fail | Margin | Margin % | Test  Equipment |  |  |  | Parameter | Spec | Measured  Value | Pass/Fail | Margin | Margin % | Test  Equipment
 |  |  |  |  |  | VNA |  |  |  |  |  |  |  |  |  | VNA
 |  |  |  |  |  | VNA |  |  |  |  |  |  |  |  |  | VNA
 |  |  |  |  |  | VNA |  |  |  |  |  |  |  |  |  | VNA
 |  |  |  |  |  | VNA |  |  |  |  |  |  |  |  |  | VNA
 |  |  |  |  |  | VNA |  |  |  |  |  |  |  |  |  | VNA
 |  |  |  |  |  | VNA |  |  |  |  |  |  |  |  |  | VNA
 |  |  |  |  |  | BERTScope |  |  |  |  |  |  |  |  |  | BERTScope
 |  |  |  |  |  | BERTScope |  |  |  |  |  |  |  |  |  | BERTScope
 |  |  |  |  |  | BERTScope |  |  |  |  |  |  |  |  |  | BERTScope
 |  |  |  |  |  | BERTScope |  |  |  |  |  |  |  |  |  | BERTScope
 |  |  |  |  |  | BERTScope |  |  |  |  |  |  |  |  |  | BERTScope
 |  |  |  |  |  | Sampling Scope |  |  |  |  |  |  |  |  |  | Sampling Scope
 |  |  |  |  |  | Sampling Scope |  |  |  |  |  |  |  |  |  | Sampling Scope
 |  |  |  |  |  | Sampling Scope |  |  |  |  |  |  |  |  |  | Sampling Scope
 |  |  |  |  |  | Sampling Scope |  |  |  |  |  |  |  |  |  | Sampling Scope
 |  |  |  |  |  | Sampling Scope |  |  |  |  |  |  |  |  |  | Sampling Scope
 |  |  |  |  |  | Sampling Scope |  |  |  |  |  |  |  |  |  | Sampling Scope
Please paste screen shot from BERTScope testing here |  |  |  |  |  |  |  |  |  | Please paste screen shot from BERTScope testing here