tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: tracy_geaccone__40401__GPM 101021  101073 Recalculation
Sheet: July 2001

KN Processing |  | GPM Agency Agreement |  |  | Prepared by [NAME]
Bushton Plant |  | TFDV Volume & Dollar Calculation
 |  | For
 |  | 2001-07-01 00:00:00
Contract #101021 |  |  | NNG Numbers |  |  | Oneok Numbers |  |  | Difference
 | Total Deliveries |  |  | 4640565 |  |  | 3479050
 |  | Deliveries to Inlet | 4440454 |  |  | 3337210
 |  | Deliveries to PVR
 |  | Non-Fuel Deliveries
 |  | Fuel Retention
 | Total Receipts |  | 4625468 |  |  | 3479649
 |  | [NAME] | 0.0445 |  |  | 0.0445
 |  | Less Fuel Retained
Transport Revenue [NAME]
Contract #101073
 | Total Deliveries |  |  | 1232050 |  |  | 1330289
 |  | Deliveries to Inlet | 0
 |  | Deliveries to PVR | 1178325 |  |  | 1273566
 |  | Non-Fuel Deliveries
 |  | Fuel Retention
 | Total Receipts |  | 1181662 |  |  | 1319413
 |  | [NAME] | 0.0445 |  |  | 0.0445
 |  | Less Fuel Retained
Transport Revenue [NAME]
 |  | Total Both Contracts
 |  | Index |  | 2.899
 |  | Total Revenue Due
Total Revenue Billed |  | 101021 |  | 44166.76
 |  | 101073 |  | 11248.2
 |  |  |  |  |  |  | 45596.23
 |  | Amount Due NNG (GPM)
Charge given by NNG on prior reconciliation
 |  | Amount Due NNG (GPM)
Spreadsheet: andy_zipper__266__Broker detail 5-29-01
Sheet: FAILED DEALS SUMMARY

Failed Transactions:
LIFE TO DATE
FAILED TRANSACTION COUNT |  | Commodity
Broker | Failed Reason | Natural Gas | Power | Grand Total
APB Energy, Inc. | FAILURE: counterparty exceeded credit limit | 1 |  | 1
 | [NAME]: counterparty has no bid access to product | 1 | 8 | 9
 | [NAME]: counterparty has no offer access to product |  | 2 | 2
 | FAILURE: Limit price violated |  | 12 | 12
 | [NAME]: traded-for counterparty has a collateralized GTC and brokered | 6 |  | 6
 | FAILURE: Volume not available for base product of hedge | 1 |  | 1
 | FAILURE: Order pended due to limit price violation | 14 | 2 | 16
APB Energy, Inc. Total |  | 23 | 24 | 47
Natsource LLC | FAILURE: counterparty exceeded credit limit | 2 | 5 | 7
 | [NAME]: counterparty has no bid access to product | 1 | 3 | 4
 | [NAME]: counterparty has no offer access to product |  | 5 | 5
 | FAILURE: Limit price violated | 1 | 13 | 14
 | [NAME]: product violates counterparty term limit |  | 3 | 3
 | [NAME]: traded-for counterparty has a collateralized GTC and brokered | 1 | 9 | 10
 | FAILURE: Base product not active for hedge | 1 |  | 1
Natsource LLC Total |  | 6 | 38 | 44
Power Merchants Group, LLC | FAILURE: counterparty exceeded credit limit | 1 |  | 1
 | [NAME]: counterparty has no offer access to product | 2 |  | 2
 | FAILURE: Limit price violated | 10 |  | 10
 | [NAME]: product violates counterparty term limit | 1 |  | 1
 | [NAME]: traded-for counterparty has a collateralized GTC and brokered | 3 |  | 3
 | FAILURE: Order pended due to limit price violation | 3 |  | 3
Power Merchants Group, LLC Total |  | 20 |  | 20
Amerex Natural Gas I, Ltd. | FAILURE: Limit price violated | 2 |  | 2
 | [NAME]: traded-for counterparty has a collateralized GTC and brokered | 4 |  | 4
Amerex Natural Gas I, Ltd. Total |  | 6 |  | 6
Amerex Power, Ltd. | [NAME]: counterparty has no bid access to product |  | 4 | 4
 | FAILURE: Limit price violated |  | 1 | 1
 | [NAME]: product violates counterparty term limit |  | 2 | 2
 | [NAME]: counterparty has no access to product |  | 1 | 1
Amerex Power, Ltd. Total |  |  | 8 | 8
Grand Total |  | 55 | 70 | 125
Spreadsheet: 683103d1592489244-need-help-on-sumifs-for-horizontal-and-vertical-criteria-from-2-different-tabs-test2-jackson_hollon-
Sheet: Sheet1

 | Column1 | Column2 | Q1 | Q2 | Q3 | Q4 | Total |  | What I need |  |  |  |  |  | Name | Column1 | Column2 | Attribute | Value
 | CNN | ALABEL_CONT | 315480.24210288 | 1135165.754609993 | 1071306.625136332 | 667796.802792415 |  |  | Sheet1 | CNN | ALABEL_CONT | Q1 | 315480.24210288 |  | Sheet1 | CNN | ALABEL_CONT | Q1 | 315480.24210288
 | CNN | COGS_CC | 55207.44856978 | 160759.3861043007 | 93302.44596697259 | 88920.7411886433 |  |  | Sheet1 | CNN | ALABEL_CONT | Q2 | 1135165.754609993 |  | Sheet1 | CNN | ALABEL_CONT | Q2 | 1135165.754609993
 |  |  |  |  |  |  |  |  | Sheet1 | CNN | ALABEL_CONT | Q3 | 1071306.625136332 |  | Sheet1 | CNN | ALABEL_CONT | Q3 | 1071306.625136332
 |  |  |  |  |  |  |  |  | Sheet1 | CNN | ALABEL_CONT | Q4 | 667796.802792415 |  | Sheet1 | CNN | ALABEL_CONT | Q4 | 667796.802792415
 |  |  |  |  |  |  |  |  | Sheet1 | CNN | COGS_CC | Q1 | 55207.44856978 |  | Sheet1 | CNN | COGS_CC | Q1 | 55207.44856978
 |  |  |  |  |  |  |  |  | Sheet1 | CNN | COGS_CC | Q2 | 160759.3861043007 |  | Sheet1 | CNN | COGS_CC | Q2 | 160759.3861043007
 |  |  |  |  |  |  |  |  | Sheet1 | CNN | COGS_CC | Q3 | 93302.44596697259 |  | Sheet1 | CNN | COGS_CC | Q3 | 93302.44596697259
 |  |  |  |  |  |  |  |  | Sheet1 | CNN | COGS_CC | Q4 | 88920.7411886433 |  | Sheet1 | CNN | COGS_CC | Q4 | 88920.7411886433
 |  |  |  |  |  |  |  |  | Sheet2 | FP&A | BLABEL_CONT | Q1 | 0.3648460706249971 |  | Sheet2 | FP&A | BLABEL_CONT | Q1 | 0.3648460706249971
 |  |  |  |  |  |  |  |  | Sheet2 | FP&A | BLABEL_CONT | Q2 | 0.3648460706249971 |  | Sheet2 | FP&A | BLABEL_CONT | Q2 | 0.3648460706249971
 |  |  |  |  |  |  |  |  | Sheet2 | FP&A | BLABEL_CONT | Q3 | 0.3980660706250019 |  | Sheet2 | FP&A | BLABEL_CONT | Q3 | 0.3980660706250019
 |  |  |  |  |  |  |  |  | Sheet2 | FP&A | BLABEL_CONT | Q4 | 0.401199710625 |  | Sheet2 | FP&A | BLABEL_CONT | Q4 | 0.401199710625
 |  |  |  |  |  |  |  |  | Sheet2 | FP&A | COGS_CC | Q1 | 1.459384282499988 |  | Sheet2 | FP&A | COGS_CC | Q1 | 1.459384282499988
 |  |  |  |  |  |  |  |  | Sheet2 | FP&A | COGS_CC | Q2 | 1.459384282499988 |  | Sheet2 | FP&A | COGS_CC | Q2 | 1.459384282499988
 |  |  |  |  |  |  |  |  | Sheet2 | FP&A | COGS_CC | Q3 | 1.592264282500008 |  | Sheet2 | FP&A | COGS_CC | Q3 | 1.592264282500008
 |  |  |  |  |  |  |  |  | Sheet2 | FP&A | COGS_CC | Q4 | 1.6047988425 |  | Sheet2 | FP&A | COGS_CC | Q4 | 1.6047988425
Spreadsheet: vkaminski__40831__SRMReport-3-31-01
Sheet: Summary

 |  | DRAFT
 |  |  |  |  |  |  |  |  |  | SRM REPORT
 |  |  |  |  |  |  |  |  | As of
 |  | Notional Position |  | Benchmark Position |  | Mark-to-Market Value |  |  | Value at Risk
 |  | long / (short) |  | long / (short) |  | $ millions |  |  | 1-Day, 95% ($ millions) | Liquidity Adjusted
Enron Americas
SITHE Independence
UNITED STATES
CANADA
Sithe Gas Supply Agreement
Physical Gas |  |  | Bcf
Financial Power |  |  | TWh
MTM Tracking Acct.
Financial Gas |  |  | Bcf
Financial Power |  |  | TWh
Tracking Account Detail
Discounted Accrued Balance
MTM Tracking Acct.
Compounded Interest MTM
Sithe Plant FMV
Interest Rate Sensitivity |  |  | $/Bps
UNITED STATES
CANADA
Enrici Power Marketing
Gas |  |  | Bcf
Power |  |  | TWh
Interest Rate Sensitivity |  |  | $/Bps
FX Position
J Block CRTA
Gas Capacity |  |  | Bcf
Interest Rate Sensitivity |  |  | $/Bps
FX Position |  |  | GBP millions
Enron Global Assets
Elektro
Equity Investment at Carrying Value |  |  | BRL millions
FX Position |  |  | BRL millions
SK-Enron
Equity Investment at Carrying Value |  |  | KRW millions
FX Position |  |  | KRW millions
MSEB/Dahbol
Gas
Power
Interest Rate Sensitivity
FX Position (Dabhol I & Dabhol II) |  |  | INR millions
Capital Portfolio
Raptor - Credit Capacity Foregone
Active Power |  |  | Shares
AVCI |  |  | Shares
Hanover Compressor |  |  | Shares
Enron Stock Option Plans
ENE Exercisable Options |  |  | Shares Equiv.
Interest Rate Sensitivity |  |  | $/Bps
Spreadsheet: 175464d1345546263-nested-if-sums-examplenestedifs
Sheet: Sheet1

 | Free Stock | On Order
Product | 10 | 5
Car | 7 | 5
Train | 5 | 10
Doll | 0 | 2
Rocking Horse | 2 | 4
[NAME] | 1 | 2
Spinning Top | 0 | 5
Marbles | 9 | 3
Spreadsheet: 750207d1633343238-count-unique-values-with-a-criteria-excel-2016-copy-of-excelforum
Sheet: Sheet1

Date | Person | Project |  |  |  | Projects | Count persons
2021-10-01 00:00:00 | [NAME] | Gucci |  |  |  | Dior
2021-10-02 00:00:00 | Luigi | Dior |  |  |  | Gucci
2021-10-04 00:00:00 | Marcel | Ellie Saab |  |  |  | Ellie Saab
2021-10-04 00:00:00 | [NAME] | Gucci
2021-10-06 00:00:00 | [NAME] | Dior
2021-10-07 00:00:00 | [NAME] | Ellie Saab
2021-10-09 00:00:00 | [NAME] | Dior
2021-10-11 00:00:00 | Marcel | Ellie Saab
Spreadsheet: kate_symes__18550__Palo
Sheet: DJ Palo Verde Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-01-31 00:00:00 |  | 258.52 | 12800 | 158.13 | 5192
 | 2001-01-30 00:00:00 |  | 244.66 | 12560 | 140.9 | 5400 | 178.19 | 3125 | 120.98 | 1446
 | 2001-01-29 00:00:00 |  | 252.84 | 13440 | 177.78 | 5400 | 183 | 4553 | 122.38 | 2433
 | 2001-01-28 00:00:00 |  | 207.5 | 800 | 185 | 200 | 150.26 | 3312 | 132.26 | 2111 |  | 177.78 | 16200
 | 2001-01-27 00:00:00 |  | 225.83 | 13200 | 141.8 | 2840 | 152.11 | 781 | 114.82 | 728
 | 2001-01-26 00:00:00 |  | 225.83 | 13200 | 141.75 | 2800 | 223.17 | 1850 | 161.11 | 180
 | 2001-01-25 00:00:00 |  | 231.78 | 13440 | 144.28 | 3040 | 153.9 | 2315 | 108.66 | 1079
 | 2001-01-24 00:00:00 |  | 222.84 | 13360 | 131.11 | 2880 | 136.45 | 2624 | 93.82 | 933
 | 2001-01-23 00:00:00 |  | 254.26 | 9200 | 143.99 | 4256 | 148.73 | 2079 | 105.08 | 1209
 | 2001-01-22 00:00:00 |  | 324.8 | 9200 | 164 | 2000 | 172.56 | 2925 | 139.79 | 2097
 | 2001-01-21 00:00:00 |  | 177.5 | 2400 | 124.55 | 2200 | 152.69 | 3900 | 141.53 | 2132 |  | 168.33 | 1800
 | 2001-01-20 00:00:00 |  | 452.36 | 4400 | 226.5 | 2000 | 232.31 | 2573 | 148.33 | 1359
 | 2001-01-19 00:00:00 |  | 452.36 | 4400 | 226.5 | 2000 | 273.28 | 6682 | 128.74 | 2093
 | 2001-01-18 00:00:00 |  | 379.51 | 8960 | 214.86 | 2800 | 279.1 | 6115 | 157.96 | 2108
 | 2001-01-17 00:00:00 |  | 220.81 | 12080 | 122 | 3800 | 232.88 | 4018 | 186.65 | 824
 | 2001-01-16 00:00:00 |  | 173.04 | 18112 | 105.14 | 4120 | 231.33 | 632 | 127.03 | 579
 | 2001-01-15 00:00:00 |  | 173.04 | 18112 | 104.82 | 3960 | 169.46 | 718 | 107.24 | 593
 | 2001-01-14 00:00:00 |  | 152.5 | 0 | 103 | 0 | 130.52 | 713 | 116.11 | 446 |  | 107.23 | 13560
 | 2001-01-13 00:00:00 |  | 152.77 | 14160 | 107.23 | 4520 | 138.98 | 1547 | 120.82 | 1165
 | 2001-01-12 00:00:00 |  | 159.03 | 18032 | 90.92 | 3800 | 160.71 | 727 | 98 | 450
 | 2001-01-11 00:00:00 |  | 160.31 | 19472 | 90.92 | 3800 | 153.64 | 1669 | 94.86 | 1106
 | 2001-01-10 00:00:00 |  | 143.16 | 18208 | 84.37 | 3352 | 129.46 | 2981 | 93.14 | 1118
 | 2001-01-09 00:00:00 |  | 132.19 | 14400 | 75.61 | 4552 | 145.14 | 850 | 87.82 | 1753
 | 2001-01-08 00:00:00 |  | 127.4 | 15728 | 68.15 | 5768 | 140.11 | 1652 | 87.68 | 460
 | 2001-01-07 00:00:00 |  | 121.67 | 2400 | 65 | 800 | 84.12 | 1047 | 58.43 | 682 |  | 69.34 | 16944
 | 2001-01-06 00:00:00 |  | 121.11 | 22672 | 71.97 | 5784 | 90.26 | 442 | 59.63 | 622
 | 2001-01-05 00:00:00 |  | 121.35 | 23072 | 72.24 | 5984 | 105.21 | 932 | 98.02 | 734
 | 2001-01-04 00:00:00 |  | 131.61 | 14064 | 79.75 | 6272 | 120.52 | 512 | 71.21 | 514
 | 2001-01-03 00:00:00 |  | 143.06 | 13168 | 85.45 | 3584 | 129.29 | 613 | 75.14 | 791
 | 2001-01-02 00:00:00 |  | 149.82 | 10992 | 93.38 | 2840 | 124.91 | 1327 | 56.75 | 526
 | 2001-01-01 00:00:00 |  | 145 | 0 | 100 | 0 | 70.68 | 2284 | 50.55 | 1025 |  | 93.52 | 7320
Spreadsheet: 68145d1268692746-reports-in-excel-tracking-data
Sheet: TRACKING DATA

 | Tracking
 | Pass
 | P1 | P2 | P3 | P4
[NAME] 1 | P | P
[NAME] 2 | P | P
[NAME] 3 |  | P | P | P
[NAME] 4 | P |  | P | P
[NAME] 5 | P | P |  | P
[NAME] 6 | P |  | P | P
[NAME] 7 | P |  | P
[NAME] 8 | P | P | P
Spreadsheet: 95897d1295421700-how-to-make-a-formula-to-take-value-in-database-to-store-as-history-make-history-record
Sheet: Sheet1

No | Name | Status | Month
1 | [NAME] | New
2 | Bani |  |  |  | How to show those value with status New to Sheet2 (view sheet 2 for example value that I want)
3 | Cech
4 | Danold | New |  |  | And now the month is January, when it is february, all the status of New are deleted (manually) because they are not New anymore
5 | Eagle |  |  |  | But, in sheet2 still wanna show those New with month in January as a history (so we have record showing this person is new in January)
6 | Foxes |  |  |  | Currently the entry has 10 value. When it is February, there are new entry entered below it (manually), so the entry will always increase
7 | Gray | New |  |  | Then if there are entry with status "New" in february, sheet2 will grab it to show who are new in february without delete those january record
8 | Hayward |  |  |  | So sheet2 entry will always increase based on New in each month.
9 | Irwans | New
10 | Jenova |  |  |  | Question is how to make those process automatically by using [NAME]?
Spreadsheet: 468835d1467624285-problem-with-combining-two-criteria-in-either-solver-macro-pivot-test-kopie
Sheet: 32

Delivery | Lines | Article | Volume
32129563 | 1 | 80-140264-004 | 0.028
32129563 | 2 | 80-150604-004 | 0.018
32129563 | 3 | 80-165604-004 | 0.012
32129563 | 4 | 80-166104-004 | 0.04
32129563 | 5 | 80-183904-004 | 0.012
32129563 | 6 | 80-184704-004 | 0.012
32129563 | 7 | 80-186104-004 | 0.048
32129563 | 8 | 80-187804-004 | 0.006
32129563 | 9 | 80-188404-004 | 0.006
32129563 | 10 | 80-188504-004 | 0.006
32129563 | 11 | 80-188704-004 | 0.006
32129563 | 12 | 80-274504-004 | 0.006
32129662 | 1 | 80-166854-004 | 0.008
32129663 | 1 | 80-166854-004 | 0.008
32129664 | 1 | 80-166854-004 | 0.008
32129665 | 1 | 80-166854-004 | 0.008
32129666 | 1 | 80-166854-004 | 0.008
32129667 | 1 | 80-166854-004 | 0.008
32129668 | 1 | 80-166854-004 | 0.008
32129669 | 1 | 80-166854-004 | 0.008
32129670 | 1 | 80-166854-004 | 0.008
32129671 | 1 | 80-166854-004 | 0.008
32129672 | 1 | 80-166854-004 | 0.008
32129673 | 1 | 80-166854-004 | 0.008
32129674 | 1 | 80-166854-004 | 0.008
32129675 | 1 | 80-166854-004 | 0.008
32129676 | 1 | 80-166854-004 | 0.008
32129677 | 1 | 80-166854-004 | 0.008
32129678 | 1 | 80-166854-004 | 0.008
32129679 | 1 | 80-166854-004 | 0.008
32129680 | 1 | 80-166854-004 | 0.008
32129681 | 1 | 80-166854-004 | 0.008
32129682 | 1 | 80-166854-004 | 0.008
32129683 | 1 | 80-166854-004 | 0.008
32129684 | 1 | 80-166854-004 | 0.008
32129685 | 1 | 80-166854-004 | 0.008
32129686 | 1 | 80-166854-004 | 0.008
32129687 | 1 | 80-166854-004 | 0.008
32129688 | 1 | 80-166854-004 | 0.008
32129689 | 1 | 80-166854-004 | 0.008
32129690 | 1 | 80-166854-004 | 0.008
Spreadsheet: 06ed5143-de80-4fb2-ad32-98b0162f1fee
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2
 | 2009-08-06기준
 | 읍면동 | 상품권가맹점
 | 계 | 2377
 | 선산읍 | 265
 | 고아읍 | 241
 | 무을면 | 20
 | 옥성면 | 13
 | 도개면 | 26
 | 해평면 | 32
 | 산동면 | 34
 | 장천면 | 32
 | 송정동 | 60
 | 원평1동 | 63
 | 원평2동 | 212
 | 지산동 | 82
 | 도량동 | 120
 | 선주원남동 | 165
 | [NAME] | 72
 | [NAME] | 56
 | 신평1동 | 188
 | 신평2동 | 38
 | [NAME] | 52
 | [NAME] | 17
 | 공단2동 | 57
 | 광평동 | 44
 | [NAME] | 120
 | 임오동 | 64
 | 인동동 | 141
 | 진미동 | 72
 | 양포동 | 91
Spreadsheet: 112641d1308697139-index-match-multiple-criteria-multiple-sheets-basic-timing-compare
Sheet: Compare

 |  | ID | Phasing Data | Patt | S1/CL | S2/CL | S3/CL | S4/CL | S5/CL | S6/CL | S7/CL | S8/CL
 |  | 1 | MinGreen | AM | 7 | 20 | 7 | 10 | 7 | 20
 |  | 2 | AllRed | MD |  | 2.5 |  | 4 | 2.5 | 3 |  | 6
 |  | 3 | Yellow | PM |  | 4 | 3 | 3 |  | 4
 |  | 4 | Walk | PO |  | 10 |  | 10 |  | 10 |  | 10
 |  | 5 | DontWalk | WA |  | 14 |  | 22 |  | 13 |  | 23
Spreadsheet: 774123d1648221267-identify-records-with-specific-condition-test11-etaf
Sheet: Sheet2

ID | Never Logged In? | [NAME]
253071690049
566369030103
566369030103
566369030103
560122395105
560122395105
560122395105
560122395105
558415928107 | Never
579036465109
579036465109
766862153562 | Never
Spreadsheet: 164140d1340656182-need-formula-that-will-return-a-sum-of-values-in-a-table-that-match-two-criteria-book3
Sheet: Timesheet

Cost center | Location | Job # | Description |  |  |  |  | Mon. | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Week 1 | Week 2
AA0000 | YY | 100 | X |  |  |  |  | 2 | 1 | 1.25 | 1 | 2 |  |  | 2 |  | 4 | 1 | 1 |  |  | 9.25 | 8
AB0000 | YY | 400 | X |  |  |  |  | 6.25 | 4 |  |  |  |  |  |  |  | 3 | 2 |  |  |  | 10.25 | 5
AA0000 | YY | 400 | X |  |  |  |  |  | 6.75 | 8.75 | 4 |  |  |  |  |  |  |  |  |  |  | 19.5 | 0
AB1000 | YY | 400 | X |  |  |  |  |  |  |  | 3.5 |  |  |  |  |  |  |  |  |  |  | 3.5 | 0
AA1010 | YY | 400 | X |  |  |  |  |  |  |  |  | 4.5 |  |  | 7.5 |  |  |  |  |  |  | 4.5 | 7.5
AB1010 | YY | 400 | X |  |  |  |  |  |  |  |  |  |  |  | 0.5 | 10.5 | 4 |  |  |  |  | 0 | 15
AA1020 | YY | 400 | X |  |  |  |  |  |  |  |  |  |  |  |  |  | 2.5 | 6 |  |  |  | 0 | 8.5
AB1020 | YY | 400 | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 2 |  |  | 0 | 6
Spreadsheet: 88f8f17b-c446-4b00-adb1-150e6b1b38df
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
FFLUR | Test | FFLUR | Flurazepam (Dalmane) and Desalkylflurazepam | Flurazepam (Dalmane) | Liquid Chromatography/Tandem Mass Spectrometry (LC/MS/MS) | Green-Top Tube (Sodium Heparin): GrnNaHp OR Plain, Red-Top Tube: Red OR |  |  | 2 | mL | Submit only 1 of the following specimens:   Plasma Draw blood in a green-top (sodium heparin) tube(s). ([NAME] tube is not acceptable.)  [NAME] down and send 2 mL sodium heparin plasma frozen in plastic vial. Note: 	1. Indicate plasma on request form. 2. Label specimen appropriately (plasma).    Serum Draw blood in a plain, red-top tube(s). (Serum gel tube is not acceptable.)  [NAME] down and send 2 mL of serum frozen in plastic vial. Note:	1. Indicate serum on request form. 	2. Label specimen appropriately (serum). | 0.3 mL NOTE: Submission of the m | Hemolysis	NA Thawing	Warm reject; Cold reject Lipemia	NA Icterus	NA Other	NA | Flurazepam: Reference Range:  0-30 ng/mL   Desalkylflurazepam:  Reference Range: 30-150 ng/mL   Flurazepam and Desalkyflurazepam:  Reference Range:  30-180 ng/mL    Test Performed By: Medtox Laboratories, Inc. 402 W. County Road D St. Paul, MN  55112 | Monday through Sunday | 5 days | 7 - 9 days | 1 | 82742 |  |  |  |  | Medtox Laboratories, Inc
FFLUR | Result | [NAME] | Flurazepam | Flurazepam | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | In Process
FFLUR | Result | Z1160 | Desalkylflurazepam | Desalkylflurazepam | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | In Process
FFLUR | Result | Z1161 | Flurazepam + Desalkylflurazepam | Flurazepam + Desalkylflurazepam | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 104078d1301696658-excel-2007-moving-only-non-blank-data-from-one-sheet-to-another-equip-mob-example
Sheet: Sheet2

Name | UOM | Qty
example 1 | Each | 1
example 2 | Each | 2
example 3 | Each | 3
example 4 | Each | 4
example 5 | Each | 5
example 6 | Each | 6
example 7 | Per Line | 7
example 8 | Per Line | 8
example 9 | Per Line | 9
example 10 | Per Line |  |  |  |  |  | 55 rows of data total
example 11 | Per Line
example 12 | Per Line
example 13 | Per Line
example 14 | Per Line
example 15 | Per Line
example 16 | Per Line | 1
example 17 | Per Line | 1
example 18 | Per Line | 1
example 19 | Per Line | 1
example 20 | Each | 1
example 21 | Each | 1
example 22 | Each | 1
example 23 | Each | 1
example 24 | Each | 1
example 25 | Each | 1
example 26 | Each | 1
example 27 | Each | 1
example 28 | Each | 1
example 29 | Each | 1
example 30 | Each | 1
example 31 | Each | 1
example 32 | Each | 1
example 33 | Each | 1
example 34 | Each | 1
example 35 | Each | 1
example 36 | Per Bin | 1
example 37 | Per Bin | 1
example 38 | Per Bin
example 39 | Per Bin
example 40 | Per Bin
example 41 | Per Bin
example 42 | Per Bin
example 43 | Per Bin
example 44 | Per Bin
example 45 | Per Bin
example 46 | Per Bin | 1
example 47 | Per Bin | 1
example 48 | Each | 1
example 49 | Each | 1
example 50 | Each | 1
example 51 | Each | 1
example 52 | Each | 1
example 53 | Each | 1
example 54 | Each | 1
example 55 | Each | 1
Spreadsheet: 679687d1590583669-match-a-number-to-the-left-of-a-name-across-multiple-arrays-example-list
Sheet: Development

Order # | Name | Count Blank
 | Adam
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | George
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Mark
 | Nathan
 | Ozzie
 | [NAME]
 | Quinn
 | Rodger
 | [NAME]
 | [NAME]
 | Umberto
 | Victor
 | Walter
 | Xander
Spreadsheet: e1c3e54e-9eaf-47ec-be66-95ec3d2a5534
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2
 |  | U.S. Census Bureau
 |  | Source: Quarterly Financial Report
 |  | All Manufacturing: U.S. Total
 |  | Not Seasonally Adjusted Net Sales, Receipts, and Operating Revenues [Millions of Dollars]
 |  | Period: 2000 to 2013
 |  | Data Extracted on: September 20, 2014 (8:22 am)
Period | Value
Q1-2000
Q2-2000
Q3-2000
Q4-2000 | 1128790
Q1-2001 | 1082233
Q2-2001 | 1116597
Q3-2001 | 1062443
Q4-2001 | 1033734
Q1-2002 | 994073
Q2-2002 | 1071574
Q3-2002 | 1068667
Q4-2002 | 1082128
Q1-2003 | 1072017
Q2-2003 | 1096910
Q3-2003 | 1109436
Q4-2003 | 1118800
Q1-2004 | 1145872
Q2-2004 | 1248717
Q3-2004 | 1250976
Q4-2004 | 1288495
Q1-2005 | 1258442
Q2-2005 | 1352179
Q3-2005 | 1384246
Q4-2005 | 1416600
Q1-2006 | 1397414
Q2-2006 | 1485624
Q3-2006 | 1467143
Q4-2006 | 1432485
Q1-2007 | 1405836
Q2-2007 | 1526484
Q3-2007 | 1539399
Q4-2007 | 1588312
Q1-2008 | 1566418
Q2-2008 | 1724172
Q3-2008 | 1682270
Q4-2008 | 1401261
Q1-2009 | 1196693
Q2-2009 | 1253821
Q3-2009 | 1305867
Q4-2009 | 1353446
Q1-2010 | 1349210
Q2-2010 | 1461717
Q3-2010 | 1463507
Q4-2010 | 1481530
Q1-2011 | 1532484
Q2-2011 | 1657405
Q3-2011 | 1650561
Q4-2011 | 1645072
Q1-2012 | 1648177
Q2-2012 | 1689523
Q3-2012 | 1656755
Q4-2012 | 1673633
Q1-2013 | 1626424
Q2-2013 | 1703610
Q3-2013 | 1703748
Q4-2013 | 1707827
Spreadsheet: 704253d1605464169-changing-a-single-point-of-data-into-a-row-of-data-merging-identical-items-into-total-index-small-if-kalamari-
Sheet: Working out sheet

Part code | Production line | Full Part Number | Pallet [NAME] contents |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 |  | TOTAL |  |  |  |  | pallets | per pallet | part pallet1 | part pallet2 | part pallet3 | part pallet4 | part pallet5
6000 | 32 | MpXX34-222222XC | 340 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MpXX34-222222XC
6000L | 32 | MpWE23-343434XC | 165 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MpWE23-343434XC
2001 | 32 | MpQW23-343421CR | 200 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MpQW23-343421CR
2016 | 32 | PPP8P4-343422DR | 500 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PPP8P4-343422DR
This clm filled via [NAME] from linked sheet |  | This clm filled via [NAME] from linked sheet | This clm filled via [NAME] from linked sheet |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MpXX34-222222XC
 |  |  |  |  |  |  |  | Could be over 70 pallets for each part in several locations (22 put here for brevity) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | The part highlighted is a dupe of the first line, I need to include this in the first line data but cannot get [NAME] to return data from two lines in the stock check….
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I will grab the part no above from the matching line in clm C then Vlookup the other figures from my stock check sheet
 |  | Could be 300+ rows below these each with different parts