tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 125694d1319175287-finding-year-end-applicable-for-each-quarter-query
Sheet: Sheet1

Years do not always end in March .. May change
Quarters also may change
 |  |  |  | Desired output
Quarters | Years |  |  | Quarters | Year ending
200203 | 200203 |  |  | 200203 | 200203
200206 | 200303 |  |  | 200206 | 200203
200209 | 200403 |  |  | 200209 | 200203
200212 | 200503 |  |  | 200212 | 200203
200303 | 200603 |  |  | 200303 | 200303
200306 | 200703 |  |  | 200306 | 200303
200309 | 200803 |  |  | 200309 | 200303
200312 | 200903 |  |  | 200312 | 200303
200403 |  |  |  | 200403 | 200403
200406 |  |  |  | 200406 | 200403
200409 |  |  |  | 200409 | 200403
200412 |  |  |  | 200412 | 200403
200503 |  |  |  | 200503 | 200503
200506 |  |  |  | 200506 | 200503
200509 |  |  |  | 200509 | 200503
Spreadsheet: 148799d1333557837-is-there-a-formula-that-can-copy-a-cell-by-defining-what-the-cell-beside-is-says-forum_example
Sheet: Sheet1

 | I.D. | Value
 | Quality | 132.3
 | sample | 135.5
 | sample | 213
 | sample | 2435
 | sample | 232.2
 | sample | 232.2
 | sample | 232.2
 | sample | 232.2
 | sample dup | 236.3
 | Quality | 1563.2
 | sample | 24.5
 | sample | 24.5
 | sample | 24.5
 | sample | 24.5
 | sample | 24.5
 | sample | 24.5
 | sample | 24.5
 | sample | 24.5
 | sample spike | 126.3
 | Quality | 32.36
 |  |  |  |  | Sample value immediately above Sample dup
 |  |  |  | Quality values | Sample dup value
Spreadsheet: 8ab1268c-c218-4277-909e-959feb76339f
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
82091 | Test | 82091 | Amyloid Protein Identification, Paraffin, LC MS/MS | Amyloid Protein ID, Par, LC-MS/MS | Liquid Chromatography-Tandem Mass Spectrometry (LC-MS/MS) Includes pathology consultation and Congo Red stain charged separately. |  |  |  |  |  | This test is not an orderable test. Order 5439 Surgical Pathology Consultation. The consultant will determine the need for special stains.    [NAME] Type: A formalin-fixed or B5-fixed, paraffin-embedded tissue block   Container/Tube: Surgical Pathology Packaging Kit (Supply T554) Collection Instructions: 1. Do not send fixed tissue slides. Testing can only be done on paraffin-embedded tissue blocks. 2. Attach the green pathology address label included in the kit to the outside of the transport container.  Additional Information:  1. Preliminary pathology report and history are required. 2. A brief explanatory note or consultative letter is also recommended. |  | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	Fixed tissue slides | This request will be processed as a consultation. An interpretive report will be provided. | Monday through Friday | 7 to 15 days | 15 days |  | Profile |  |  |  |  | Rochester
82091 | [NAME] | TISSUE | Tissue |  |  |  | Ambient
82091 | Result | 82091 | Amyloid Protein ID, Par, LC-MS/MS | Amyloid Protein ID, Par, LC-MS/MS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
82091 | Billing Component | 82091 |  | MASS SPECTROMETRY QUAL |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 83788
82091 | Billing Component | 82091 |  | Mass and tandem mass spectrometry |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 88380
82091 | [NAME] | 89054 | Congo Red, Stain | Congo Red, Stain | Includes pathology consultation charged separately. |  |  |  |  |  | This test is not an orderable test. Order #5434 "Hematopathology Consultation" or #5439 "Surgical Pathology Consultation." The Consultant will determine the need for special stains. |  | Specimens other than	Paraffin-embedded tissue block fixed in formalin or B5 Anticoagulants other than	NA Hemolysis	NA Thawing	NA Lipemia	NA Icteric	NA | This request will be processed as a consultation. An interpretive report will be provided. | Monday through Friday | 10 days |  | 1 | 88313 |  |  | Yes | No
89054 | [NAME] | VARIES | Varies |  |  |  | Ambient
89054 | Result | 89054 | Congo Red, Stain | Congo Red, Stain |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10782-1
Spreadsheet: 100758d1299011300-how-to-create-an-automized-price-calculation-based-on-different-locations-categories-product-price-calculation-example
Sheet: Sheet1

Price list (Product (P) and Service (S))
Item | Classification | Price | Location
A | P1 | 0.5 | 1
X | P2 | 0.7 | 1
W | S1 | 0.5 | 1
Z | S2 | 0.7 | 1
B | P1 | 3 | 2
B | P2 | 3 | 2
B | S1 | 3 | 2
B | S2 | 3 | 2
CCC | P1 | 1 | 3-5
CCC | P2 | 2 | 3-5
CCC | S1 | 1 | 3-5
CCC | S2 | 1 | 3-5
CCD | P1 | 1.5 | 3-5
CCD | P2 | 1.5 | 3-5
CCD | S1 | 1.5 | 3-5
CCD | S2 | 1.5 | 3-5
E | P1 | 2 | 6
E | P2 | 2 | 6
E | S1 | 2 | 6
E | S2 | 2 | 6
GH | P1 | 10 | 7-8
GH | P2 | 10 | 7-8
GH | S1 | 10 | 7-8
GH | S2 | 10 | 7-8
GI | P1 | 10 | 7-8
GI | P2 | 10 | 7-8
GI | S1 | 10 | 7-8
GI | S2 | 10 | 7-8
2 | P1 | 0.8 | 9
2 | P2 | 0.8 | 9
2 | S1 | 1.2 | 9
2 | S2 | 1.2 | 9
Example part number for P1:  [NAME]
Example part number for P2:  XBCCCEGI2
Example part number for S1:  WBCCDEGI3
Example part number for S2:  ZBCCDEGI4
The first letter of the part number indicates if it is a P1, [NAME], [NAME] or S2 part (E.g. X for P2 or W for S1).  The price calculation bases then on the summary of prices for all 6 locations and considering the classification (that has been indicated in the first letter of the part number).
Calculation example for [NAME]
Item | Classification | Price | Location
A | P1 | 0.5 | 1
X | P2 | 0.7 | 1
W | S1 | 0.5 | 1
Z | S2 | 0.7 | 1
B | P1 | 3 | 2
B | P2 | 3 | 2
B | S1 | 3 | 2
B | S2 | 3 | 2
CCC | P1 | 1 | 3-5
CCC | P2 | 2 | 3-5
CCC | S1 | 1 | 3-5
CCC | S2 | 1 | 3-5
CCD | P1 | 1.5 | 3-5
CCD | P2 | 1.5 | 3-5
CCD | S1 | 1.5 | 3-5
CCD | S2 | 1.5 | 3-5
E | P1 | 2 | 6
E | P2 | 2 | 6
E | S1 | 2 | 6
E | S2 | 2 | 6
GH | P1 | 10 | 7-8
GH | P2 | 10 | 7-8
GH | S1 | 10 | 7-8
GH | S2 | 10 | 7-8
GI | P1 | 10 | 7-8
GI | P2 | 10 | 7-8
GI | S1 | 10 | 7-8
GI | S2 | 10 | 7-8
2 | P1 | 0.8 | 9
2 | P2 | 0.8 | 9
2 | S1 | 1.2 | 9
2 | S2 | 1.2 | 9
Price for [NAME]
Goal:  To have a field, where you can enter the part number and a total price for that part number will be calculated.
Ultimate goal:  A window pops up where the part number can be entered and after entereing the part number the calculated price will appear.
Spreadsheet: darrell_schoolcraft__7760__imbalsumm0105
Sheet: williams

 | Milagro |  | La Maquina |  | [NAME] |  | [NAME]
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 4652 |  | 28288 | 50798 | 79025 | 76749 | 132385 | 140756
2 | -1 |  | 53826 | 60396 | 78689 | 85692 | 130343 | 126423
3 | 197315 | 313424 | 62495 | 33205 | 77186 | 58206 | 125773 | 57088
4 | 308805 | 338667 | 45825 | 29306 | 71210 | 60175 | 58408 | 53799
5 | 323081 | 361761 | 56768 | 28626 | 74446 | 72010 | 56003 | 50231
6 | 252940 | 366062 | 76241 | 27943 | 73394 | 76372 | 81292 | 54526
7 | 305923 | 368573 | 66604 | 31346 | 73724 | 72666 | 47776 | 43779
8 | 221328 | 265324 | 45319 | 64954 | 69302 | 79288 | 130760 | 111396
9 | 252735 | 296907 | 70250 | 34878 | 73090 | 86109 | 125832 | 108701
10 | 188758 | 202635 | 44489 | 37249 | 66377 | 51517 | 58469 | 58589
11 | 247605 | 286527 | 69784 | 37849 | 73261 | 55374 | 75486 | 89393
12 | 282187 | 274222 | 31078 | 38984 | 65029 | 63250 | 68804 | 71913
13 | 338951 | 354319 | 49769 | 45963 | 83305 | 85499 | 72011 | 66573
14 | 354197 | 365904 | 36694 | 34138 | 76310 | 62170 | 81824 | 76268
15 | 337580 | 385340 | 71773 | 40868 | 73127 | 75316 | 75607 | 81412
16 | 317974 | 371627 | 98213 | 39255 | 79545 | 61945 | 93931 | 94217
17 | 336508 | 393239 | 91999 | 39492 | 79712 | 78276 | 91584 | 84564
18 | 353040 | 356711 | 50054 | 38659 | 80874 | 87077 | 93427 | 93798
19 | 328744 | 347351 | 64022 | 28274 | 70066 | 70465 | 72841 | 85956
20 | 318636 | 341618 | 77135 | 27571 | 74747 | 71666 | 60071 | 86173
21 | 321868 | 371772 | 89058 | 36668 | 76975 | 71296 | 61514 | 85398
22 | 366585 | 371289 | 76764 | 38757 | 73031 | 89581 | 74806 | 83101
23 | 377764 | 400000 | 67400 | 32380 | 78531 | 82465 | 77649 | 81288
24 | 383537 | 391061 | 41311 | 28694 | 82184 | 80629 | 78044 | 81660
25 | 371542 | 379613 | 35195 | 35052 | 85799 | 86073 | 81997 | 81905
26 | 386701 | 400000 | 30477 | 29168 | 88394 | 87088 | 78280 | 79413
27 | 350647 | 374798 | 55625 | 46218 | 88239 | 86310 | 83229 | 76145
28 | 364520 | 372660 | 62941 | 39039 | 86836 | 86095 | 74549 | 82736
29 | 394445 | 385365 | 56617 | 50225 | 87532 | 91074 | 90488 | 98155
30 | 359437 | 384757 | 47823 | 37338 | 87580 | 76965 | 79708 | 78183
31 | 380403 | 387946 | 42953 | 38650 | 84790 | 82281 | 74590 | 77388
2001-04-30 00:00:00 |  |  |  |  |  |  |  |  | 121749
2001-05-31 00:00:00
 |  |  | 300359.04
 |  |  | -250735.54
 |  |  | 44931.54
 |  |  | 2153062.32
 |  |  | 0.0238
 |  |  | 0.0153
Spreadsheet: 840624d1692872923-matrix-lookup-probably-as-simple-as-my-previous-question-test-example2
Sheet: Riskregister

Threat | Lowest probability | Highest probability | Most likely probabilty | Calculated probability | Probabilty level | Lowest consequense | Highest consequense | Most likely consequense | Calculated consequense | Consequense level | Risk level
Something goes wrong | 0.5 | 3 | 1 |  |  | 500 | 1500 | 1100
Spreadsheet: 834158d1687494159-need-help-to-find-out-code-wise-rate-calculation-code-wise-rate-calculation-individual-2
Sheet: IND

Example | Code | From Date | To Date | Days | Connected Load | Load | Rate/Month | Calculation method used for reference | Remarks
1 | IND | 2022-04-01 00:00:00 |  | 30 |  | 38 |  | (90*G2*E2)/30 | Here 90 is the rate as per sheet INDR for the load upto 40
2 | IND | 2022-04-01 00:00:00 |  | 30 |  | 54 |  | ((40*90*E3)+(130*E3*(G3-40)))/30 | Here 40 is the load and 90 is rate, 130 is rate from load 41 to 60 as per sheet INDR
3 | IND | 2022-04-01 00:00:00 |  | 30 |  | 88 |  | ((40*90*E4)+(130*E4*(60-40))+(195*E4*(G4-60)))/30 | Here 40 is the load and 90 is rate, 130 is rate from load 41 to 60, 195 is rate for 61 to 100 load  as per sheet INDR
4 | IND | 2022-04-01 00:00:00 |  | 30 | 96 | 74 |  | ((40*90*E5)+(130*E5*(60-40))+(195*E5*(G5-60))+(265*E5*(F5-G5)))/30 | Here 40 is the load and 90 is rate, 130 is rate from load 41 to 60, 195 is rate for 61 to 100 load. And 265 is the rate which applicable only if connected load (column F) is greater than load (column G)  as per sheet INDR
Spreadsheet: f6b537d4-f4e1-4ce8-82e0-bfc86767602c
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
FMYEL | Test | FMYEL | [NAME], IFA | [NAME], IFA | Immunofluorescence Assay (IFA) | Plain, Red-Top Tube: Red |  |  | 1 | mL | Draw blood in a plain, red-top tube(s). Spin down and separate. Ship 1 mL of serum refrigerate.  NOTE: Serum gel tube is acceptable, but must pour off into plastic vial. | 0.2 mL | Hemolysis	NA Thawing	Cold OK; Warm OK Lipemia	NA Icteric	NA Other	NA | Reference Range:  Negative   Interpretive Criteria: Negative:  Antibody not detected Positive:  Antibody detected   IgG antibodies recognizing [NAME] may be found in multiple sclerosis, amyotrophic lateral sclerosis, and other neurological diseases. A positive result is of questionable diagnostic value, however, since [NAME] antibodies are detected in approximately 5-10% of apparently healthy individuals.     Test Performed by: Focus Diagnostics, Inc                              5785 Corporate Avenue                              Cypress, CA   90630-4750 | Tuesday and Friday | 2 - 5 days | 4 - 7 days | 1 | 86255 |  |  |  |  | Focus Diagnositics, Inc.
FMYEL | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
FMYEL | Result | Z0616 | [NAME], IFA | [NAME], IFA | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 788348d1658413694-index-match-from-dropdown-test_data
Sheet: bill

 |  |  |  |  | distribution
 |  |  |  |  | Order No | July-2-2022 |  | Order
 |  |  |  |  | Sr.No | Vegetable/Fruit |  |  | Rate | Order | Amount
 |  |  |  |  | 1
 |  |  |  | `
Spreadsheet: 838748d1691347332-xlookup-returns-n-a-example-xlookup
Sheet: Tab 1

 |  | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 |  | 2019-01-31 00:00:00
Client 1 | Client 1
1 | 1
 |  | #N/A
 | 5150 - PORK - ASIAN GOLD
 | 7101 - OTHER
 | 6101 - PORK - OTHER
 | 4210-SAU OTHER -DH AG
 | 4301 - SAUSAGE - PRI LAB
 | Total Costco $ Sales
Spreadsheet: 223380d1364192973-help-with-comparing-2-tables-list-compare
Sheet: clear

Code | CostByBuyUnitEx | Description
0610029-S | 1483 | SCREEN TECHNICS ELECTRIC CINEMA MOTORISED SCREEN 100' 1245H X 2215W
0613029-L | 1859 | SCREEN TECHNICS ELECTRICINEMA 130"" 16:9 MOTORISED  SCREEN
70060000 | 131.27 | OXFORD USB BLUETOOTH KEY PAPERSHOW 256MB USB 2.0 (ASA11)
18001 | 4.84 | NOBO CHROME MECH POINTER 260CM EXPAND
304704 | 193 | NOBO QUANTUM 2511 OVERHEAD PROJECTOR
304707 | 220 | NOBO  QUANTUM 2521 OVERHEAD PROJECTOR 250WT 2 SINGLE LENS
304714 | 525 | NOBO 304714  QUANTUM 2523 OVERHEAD PROJECTOR
320029100 | 22.28 | AVERY LABELS LASER VINYL NAME BADGE L7418K 80 X 50MM 10/SHEET
325022600 | 6.99 | REXEL NAME PLATE 90037 LARGE
325022700 | 6.99 | REXEL NAME PLATE 90038 EXTRA LARGE
33734535 | 24.4 | NOBO PROJECTOR LAMP 36V 400W EVD
34433685 | 20 | NOBO 100 LASER POINTER
365007 | 9.7 | POST-IT 558 MEMO BOARD CHARCOAL457X584MM
Spreadsheet: 5bbc8107-e81b-43d5-be92-d42281f92f6c
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
RPRT | Test | RPRT | Rapid [NAME] (RPR), Response to Therapy, Serum | RPR, Response to Therapy, S | Flocculation | Plain, Red-Top Tube: Red |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL | 0.3 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	NA Other	NA | Negative | Monday through Saturday; 9 a.m. | Same day/1 day | 4 days | 1 | 86592 |  |  |  |  | Rochester
RPRT | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
RPRT | Result | 31696 | RPR, Response to Therapy, S | RPR, Response to Therapy, S | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20507-0
Spreadsheet: 329421d1404308059-colours-with-multiple-look-up-variables-se-s3000
Sheet: Colours

White
Blue - Light
Blue - Mid
Blue - Dark
Red - Light
Red - Mid
Red - Dark
Green - Light
Green - Mid
Green - Dark
Yellow - Light
Yellow - Mid
Yellow - Dark
Brown - Light
Brown - Mid
Brown - Dark
Purple - Light
Purple - Mid
Purple - Dark
Pink - Light
Pink - Mid
Pink - Dark
Orange - Light
Orange - Mid
Orange - Dark
Spreadsheet: 697305d1601303476-sumif-across-several-columns-trial4
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  | SumIF($E:$E,"a",F:F) | SumIF($E:$E,"a",g;g) | SumIF($E:$E,"a",h;h) | SumIF($E:$E,"a",I;I) | SumIF($E:$E,"a",J;J) | [NAME]) | SumIF($E:$E,"a",L;L) | SUM(o8:u8)
 |  |  |  | a | 123 | 124 | 125 | 126 | 127 | 128 | 129
 |  |  |  | a | 345 | 346 | 347 | 348 | 349 | 350 | 351
 |  |  |  | b | 3 | 4 | 5 | 6 | 7 | 8 | 9
 |  |  |  | b | 128 | 129 | 130 | 131 | 132 | 133 | 134
 |  |  |  | b | 97 | 98 | 99 | 100 | 101 | 102 | 103
 |  |  |  | a | 86 | 87 | 88 | 89 | 90 | 91 | 92
 |  |  |  | b | 45 | 46 | 47 | 48 | 49 | 50 | 51
 |  |  |  | a | 33 | 34 | 35 | 36 | 37 | 38 | 39
Spreadsheet: daren_farmer__5086__EEXBid
Sheet: HPL Bids

HPL
EEX Production Bids
Field | Vol | Notes | Bid Point
Dinn | 3300 | Tville area, Mtr 9721.  Currently purced at IFHSC-.28. Effective May 2001, price changes to97.5% IFHSC-.28
[NAME] | 1200 | Big Cowboy, Mtr 9699. Currently buying at 91.5% IFHSC
[NAME] | 8000 | Big Cowboy, Mtr 599.  Currently priced at IFHSC-.11
[NAME] | 2000 | King Ranch.  Currenlty being sold to Duke.
Guerra Field | 1800 | Tville area.Mtr 6500.Currently priced at 95.5% IFHSC.
Garwood/Buck Snag | 100 | Currently no volume flowing. On Edna line. Mtr 6510?
[NAME] Hughes | 120 | South Texas line.
Spreadsheet: sally_beck__33884__consolidated for 12 20
Sheet: S Cone info

Note regarding YPF gas purchase.
The deal is booked as a fixed price gas purchase.  Weekly, we use a model to update the fixed prices by downloading the WTI,
Gas Oil, and PPI forward curves and settle prices.  The crude oil and gas oil exposure is not reported.  Currently, because of high
crude and gas oil forward prices, all pricing periods except the final two (May 2003 & Oct 2003) are at the ceiling price.  We reviewed
methods of quantifying the WTI & Gas Oil positions but are not sure how to handle the fact that the cap & floor prices do not
contain WTI and [NAME] in price components.
 | MTM value as of 12/4/2000
 | Term: | 4/1/1999 - 3/31/2004
 | Volume: | 70,000 acm/day take or pay firm volume  (70% of 100,000 acm/day)
 | Base Price: | Winter (May - Sept)  1.05 / mmbtu    (convert @ 27.0963 to .0388 / acm)
 |  | Summer (Oct - April)  1.00 / mmbtu    (convert @ 27.093 to .0369 /  acm)
 | Price Esc: | Adjustment Factor = .5 x GO/GOb  + .5 x WTI / WTIb
 |  | GOb = .49 each [NAME] | WTIb = 19.052 / bbl
 |  | GO = Semi-annual average, for the Semi-annual Period Prior to the Adjustment month, of the
 |  | average of the daily closing prices corresponding to Heating-Oil #2.  Source: Platt's Oilgram
 |  | Market price Report - U.S. Gulf Coast - LS No.2.
 |  | WTI = Semi-annual average, for the Semi-annual Period Prior to the Adjustment Month, of the
 |  | average of the daily closing prices corresponding to WTI.  Source:  Platt's Oilgram Market
 |  | Price Report - U.S. WTI, first line.
 |  | Semi-annual Period Prior to the Adj Month:
 |  | Winter Period:  Sept 1 of immediately previous calendar year and Feb 28 or 29 of same calendar year.
 |  | Summer Period:  March 1 and Aug 31 both of the same calendar year.
 | Ceiling Price: | PTn = PT x PPI/PPIb
 |  | PT = Seasonal Base Price increased by 20%
 |  | PPI = Producer Price Index, Industrial Commodities, published by the Bureau of Labor Statistics for
 |  | July (if summer pricing period) or Feb (if winter pricing period).
 |  | PPIb = 125.1   PPI, Industrial Commodities, July 1998
 | [NAME]: | PPn = PP x PPI/PPIb
 |  | PP = Base seasonal Price reduced by 6%
 |  | PPI = Producer Price Index, Industrial Commodities, published by the Bureau of Labor Statistics for
 |  | July (if summer pricing period) or Feb (if winter pricing period).
 |  | PPIb = 125.1   PPI, Industrial Commodities, July 1998
Spreadsheet: 741685d1627277145-how-to-countif-formulas-with-time-example
Sheet: Dropdown

1 | Saturday |  | Start | End
2 | Sunday |  | Before External Doors | Post Door
3 | Monday |  | Before Doors (both internal and external) | Post Show
4 | Tuesday |  | Before Ticketed Start Time | Post Shift Start
5 | Wednesday
6 | Thursday
7 | Friday
8 | Public Holiday
Spreadsheet: 538811d1505838094-finding-a-point-on-a-grid-armour-trips
Sheet: Bathurst

Allardville, NB | 11
Atholville, NB | 72
Balmoral, NB | 58
Belledune, NB | 25
Caraquet, NB | 43
Chatham, NB | 47
[NAME], NB | 55
Dartmouth, NS | 280
Duguayville, NB | 39
Eel River Crossing, NB | 55
Fredericton, NB | 164
Grande Anse, NB | 28
Inkerman, NB | 48
Kentville, NS | 334
Lameque, NB | 66
Maisonnette, NB | 38
Miramichi, NB | 47
[NAME], NB | 140
New Glasgow, NS | 261
New Richmond, QC | 121
Newcastle, NB | 49
Newport, QC | 186
[NAME], NB | 170
Richibucto, NB | 87
[NAME], NB | 229
Scoudouc, NB | 127
Shippagan, NB | 61
[NAME], NB | 126
Tracadie, NB | 43
Truro, NS | 230
Spreadsheet: 220051d1363040803-counting-of-rows-in-a-range-with-2-conditions-counting
Sheet: Sheet1

 |  | Dropped | Processed
 | 1 | X | X
 | 2 | X | X
 | 3 | X
 | 4
 | 5 |  | X
 | 6 | X | X
 | 7
 | 8
 | 9 | X | X
 | 10
 | 11 |  | X
 | 12 | X
 | 13
 |  | How Can I count rows in range c5:d17 for which X is present in row 5 , column C and D
 |  | the result should be for this range: |  |  | 4
Spreadsheet: 468436d1467295489-how-to-filter-three-or-more-tables-on-one-field-and-value-jobcard_forum
Sheet: R_Jobcard

 |  | BCMS: Job Card |  |  |  |  |  |  |  |  |  | JC_no
 |  | Job card no: | 1 |  |  | Machine no. |  |  | S  /  B |  |  | 1
Call out: |  | Date | Time |  | Reported by: |  | Reported to: |  |  |  |  | JC_no | M_no | S_B | Callout | Report_by | Report_to | Mstop | Mstart | Downtime | Supervisor | S_date
 |  | __/__/2016 | ____:____ |  |  |  |  |  |  |  |  | 1 | BCMS 204 | s | 2016-05-16 08:15:00 | [NAME] | [NAME] | 2016-05-16 11:00:00 | 2016-05-17 08:00:00 | 21 | JJ [NAME] | 2016-05-17 00:00:00
 |  | Machine stopped: |  |  | Machine started: |  |  | Standing time: |  |  |  | 2 | BCMS 470 | b | 2016-05-18 11:15:00 | [NAME] | [NAME] | 2016-05-18 11:15:00 | 2016-05-18 12:00:00 | 0.75 | JJ [NAME] | 2016-05-18 00:00:00
 |  | Date | Time |  | Date | Time | Hours | Min |  |  |  | Total |  |  |  |  |  |  |  | 21.75
 |  | __/__/2016 | ____:____ |  | __/__/2016 | ____:____
Actions: |  | Description |  |  | Mechanic |  | Time(min) | Special Equipment
 | 1 |  |  |  |  |  |  |  |  |  |  | A_no | JC_no | JC_Apos | Mstop_date | A_descr | Mechanic | Time | Mec_Cost | SpecE | SE_cost
 | 2 |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 2016-05-16 00:00:00 | [NAME] | S Swanepoel | 300 | 900 | Forklift | 450
 | 3 |  |  |  |  |  |  |  |  |  |  | 2 | 1 | 2 | 2016-05-16 00:00:00 | Service 250 hours | M 2 | 120 | 300 | None | 0
 | 4 |  |  |  |  |  |  |  |  |  |  | 3 | 1 | 3 | 2016-05-16 00:00:00 | Inspection Prestart | M 2 | 15 | 37.5 | None | 0
 | 5 |  |  |  |  |  |  |  |  |  |  | 4 | 2 | 1 | 2016-05-18 00:00:00 | Repair Performance | S Swanepoel | 45 | 135 | None | 0
 | 6 |  |  |  |  |  |  |  |  |  |  | 5 | 2 | 2 | 2016-05-18 00:00:00 | Inspection Prestart | M 2 | 15 | 37.5 | None | 0
 | 7 |  |  |  |  |  |  |  |  |  |  | Total |  |  |  |  |  | 495 | 1410 |  | 450
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
Material and Spares: |  | Description |  |  | Quantity | Part no. | Order no. | Reorder
 | 1 |  |  |  |  |  |  | Y  /  N |  |  |  | M_no | JC_no | JC_Mpos | Mstop_date | M_descr | Quantity | Part_no | Order_no | Reorder | M_Ucost | M_cost
 | 2 |  |  |  |  |  |  | Y  /  N |  |  |  | 1 | 1 | 1 | 2016-05-16 00:00:00 | Water pump [NAME] | 1 | 123 | 1 | n
 | 3 |  |  |  |  |  |  | Y  /  N |  |  |  | 2 | 1 | 2 | 2016-05-16 00:00:00 | Waiste | 1 |  | 2 | y
 | 4 |  |  |  |  |  |  | Y  /  N |  |  |  | 3 | 2 | 1 | 2016-05-18 00:00:00 | Waiste | 1 |  | 2 | y
 | 5 |  |  |  |  |  |  | Y  /  N
 | 6 |  |  |  |  |  |  | Y  /  N
 | 7 |  |  |  |  |  |  | Y  /  N
 | 8 |  |  |  |  |  |  | Y  /  N
 | 9 |  |  |  |  |  |  | Y  /  N
 | 10 |  |  |  |  |  |  | Y  /  N
 | 11 |  |  |  |  |  |  | Y  /  N
 | 12 |  |  |  |  |  |  | Y  /  N
 | 13 |  |  |  |  |  |  | Y  /  N
 | 14 |  |  |  |  |  |  | Y  /  N
 | 15 |  |  |  |  |  |  | Y  /  N
 |  | Supervisor:
 |  | Signature |  | Date
 |  |  |  | ____/____/2016
Spreadsheet: 95036d1294748702-eliminate-repetitive-data-in-dropdown-book3
Sheet: Sheet1

Group |  |  |  |  | Input
Environment
Environment
Environment
Environment
Environment
Environment
Environment
Environment
Environment
Process
Process
Process
Process
Process
Process
Process
Process
Process
Process
Process
Process
Process
Process
Financial
Financial
Financial
Liquidity
Liquidity
Liquidity
Human Resource
Human Resource
Human Resource
Human Resource
Human Resource
Human Resource
Human Resource
Information Technology
Information Technology
Information Technology
Information Technology
Information Technology
Information Technology
Strategic
Strategic
Strategic
Strategic