tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 787095d1657632518-seperate-large-data-set-across-multiple-tabs-sample-doc
Sheet: Master

Name | ACTUAL+FORECAST | CBS Code | Status (Complete) | Current ACCRUAL (inc withheld/under assessment) | ACTUAL to end Oct21 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00
Core Suppliers
A | 25312.625 | 220300 | Complete | 0 | 0 | 25312.625 | 0 | 0 | 0 | 0 | 0 | 0 | 0
b | 230749.8375 | 430100 | Complete | 0 | 218376.075 | 12373.7625 | 0 | 0 | 0 | 0 | 0 | 0 | 0
A | 21424.7125 | 220300 | Complete | 0 | 21424.7125 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
d | 2540448.85 | 220300 |  | 385375.5625 | 1646570.05 | 124869.675 | 64597.2 | 104238.3 | 109210.5625 | 105587.5 | 0 | 0 | 0
A | 192334.1 | 710100 |  | 32871.4375 | 67493.225 | 34671.8125 | 10106.0125 | 21523.75 | 13089.7375 | 12578.125 | 0 | 0 | 0
f | 192470.2 | 430100 |  | 0 | 52521.075 | 29817.25 | 0 | 25662.5 | 33611.875 | 32757.5 | 18100 | 0 | 0
g | 10371.8625 | 430100 | Complete | 0 | 5184.825 | 0 | 5187.0375 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: e3d43809-547d-4aa9-abf4-3cdf6a2d89f1
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7471 | 57791 | Shingo | Kamiya | JPN | 0 | 00:15:18 | 00:01:43 | [NAME] | 00:02:19 | 00:58:08 | 1 | [NAME]
Spreadsheet: 004e70a9-546b-41ab-9c75-8c6e483daabb
Sheet: Soph Rotations 6-8-10

Bioengineering Co-op Schedule Form
Student Name: |  | Concentration :
 |  | Company :
Anticipated  Start Date: | Year / Semester
 | (Junior Year)
AP/Tr Credits
 | Fall | Spring | Summer
Freshman | CHEM 0960 | CHEM 0970
 | ENGR 0011 | [NAME] 0012
 | MATH 0220 | MATH 0230
 | PHYS 0174 | PHYS 0175
 | H/SS Elective | H/SS Elective
Sophomore | BIOENG 1070 | BIOENG 1071 | Co-op
 | BIOENG 1085 | BIOENG 1085
 | BIOSC 0050 | BIOENG 1210
 | ENGR 0135 | BIOENG 1310
 | MATH 0240 | BIOENG 1630
 | MATH 0290 | ENGR 0020
 | [NAME]
Junior | BIOENG 1085 | Co-op
 | BIOENG 1220
 | BIOENG 1320
 | BIOSC 1250
 | MATH 0280
 | H/SS Elective
Pre-Senior | Co-op | BIOENG 1085 | lab experience
 |  | BIOENG 1150
 |  | BIOENG 1255
 |  | [NAME]
 |  | [NAME]
 |  | BIOENG 1241
Senior | BIOENG 1002 | BIOENG 1085
 | BIOENG 1085 | BIOENG 1161
 | BIOENG 1160 | [NAME]
 | IMAGING COURSE | [NAME]
 | [NAME] | Engr/Sci Elective
 | Engr/Sci Elective | H/SS Elective
 | H/SS Elective
Spreadsheet: phillip_allen__28811__Westgate Proforma-Phillip Allen
Sheet: Project Summary

PROJECT PROFORMA
 | Total | Per Unit | Per SF | % Sales
Total # of Units
Total Sq.[NAME]
Sales Revenues
Gross Sales Revenue
Cost of Sales
Commissions
Closing Costs
Total Costs of Sales
Net Sales Revenues
Development Costs
Land Acquisition
Lot Improvement Costs
Building Construction Cost
Total Development Costs
Interim Construction Loan Fee
Interim Interest
Total Interim Financing Expense
Total Direct Costs
Projected Profit
Investment | 700000
Return - 50% Share
Total Project ROI (Return/Investment)
Annualized ROI (Total/36 x 12)
LOAN AND EQUITY ANALYSIS
 | TOTALS | Per Unit/Lot
Acquisition & Development Loan
Appraised Value Per Improved Lot |  | 20000
Improvement Loan - 75% LTV
Lot Improvement Cost
Equity Required For Improvement Loan
Equity or Collateral for EST. COA Fiscals
Lot Release Price - 120% of Loan/Lot
Construction Loans
Units Built on Spec
Number of Specs |  | 10
Appraised Value
Loan Amount -Loan to Value 70%
Less: Lot Release Price
Financing Cost Per Unit
Equity Per Unit
Units [NAME]
Number of Pre-Sold Starts In Cycle |  | 20
Loan Amount -Loan to Value 80%
Less: Lot Release Price
Financing Cost Per Unit
Equity Required Per Unit
Spreadsheet: lindy_donoho__21978__tw_priority_rate
Sheet: 9811- 9812

Transwestern Pipeline Company
Contracts Under the Global Settlement
Priority Rates (Reservation and Demand Surcharges)
Contract | Shipper | Receipt to Delivery | Reservation | Shared Cost | TCR II No. 1 | TCR II No. 2 | GRI Demand | Total |  | Commodity
Number | Name | Area | Rate | Surcharge | Surcharge | Surcharge | Surcharge | Rate |  | Rate
8255 | Southern California Gas Company | East of Thoreau to California (W. of Thoreau) | 0.3105 |  | 0.0052 | 0.0007 | 0.0085 |  |  | 0.0228
20834 | Citizens Utilities Company | San Juan Lateral to Thoreau/San Juan Pt. | 0.101 | - | - | - | -
20835 | Conoco Inc. | San Juan Lateral to Thoreau/San Juan Pt. | 0.101 | - | - | - | -
21175 | Pacific Gas & Electric Company(Gas) | San Juan Lateral to Thoreau/San Juan Pt. | 0.101 | - | - | - | -
21172 | Pacific Gas & Electric Company(UEG) | San Juan Lateral to Thoreau/San Juan Pt. | 0.101 | - | - | - | -
26371 | Duke Energy Trading and Marketing. LLC | San Juan Lateral to Thoreau/San Juan Pt. | 0.101 | - | - | - | -
25923 | Texaco Natural Gas Inc. | San Juan Lateral to Thoreau/San Juan Pt. | 0.101 | - | - | - | -
20715 | Southern California Gas Company | San Juan Lateral to Thoreau/San Juan Pt. | 0.101 | - | - | - | -
20747 | Conoco Inc. | Thoreau/San Juan Pt. to California (W. of Thoreau) | 0.2503 | 0.0369 | 0.006 | 0.0008 | 0.0085 |  |  | 0.0156
20748 | Conoco Inc. | Thoreau/San Juan Pt. to California (W. of Thoreau) | 0.2503 | 0.0369 | 0.006 | 0.0008 | 0.0053 |  |  | 0.0156
21165 | Pacific Gas & Electric Company(Gas) | Thoreau/San Juan Pt. to California (W. of Thoreau) | 0.2503 | 0.0443 | 0.0046 | 0.0006 | 0.0053 |  |  | 0.0156
21162 | Pacific Gas & Electric Company(UEG) | Thoreau/San Juan Pt. to California (W. of Thoreau) | 0.2503 | 0.0443 | 0.0051 | 0.0007 | 0.0085 |  |  | 0.0156
26372 | Duke Energy Trading and Marketing. LLC | Thoreau/San Juan Pt. to California (W. of Thoreau) | 0.2503 | 0.0443 | 0.0051 | 0.0007 | 0.0085 |  |  | 0.0156
25924 | Texaco Natural Gas Inc. | Thoreau/San Juan Pt. to California (W. of Thoreau) | 0.2503 | 0.0443 | 0.0055 | 0.0007 | - |  |  | 0.0156
20822 | Citizens Utilities Company | Thoreau/San Juan Pt. to East of California (W. of Thoreau) | 0.1614 | 0.0369 | 0.0031 | 0.0004 | 0.0053 |  |  | 0.0156
NOTE --- | Per CBS Negotiated Rate System, the termination date for the rates listed above are as follows:
 | Reservation | 1999-10-31 00:00:00
 | SCS | 2001-10-31 00:00:00
 | TCR II No. 1 | 2005-10-31 00:00:00
 | TCR II No. 1 | 2006-10-31 00:00:00
 | GRI Demand | N/A **
 | ** Calculation made every year to determine which contracts are High Load vs. Low Load
Spreadsheet: 274498d1383135326-recognise-two-different-employee-id-numbers-in-one-cell-example-2-
Sheet: Sheet3

1-3 | 1 | 3 | 1
1-4 | 1 | 4 | 1
2-5 | 2 | 5 | 3
5-2 | 5 | 2 | 3
6-1 | 6 | 1 | 1
7-3 | 7 | 3 | 1
2-5 | 2 | 5 | 3
9-4 | 9 | 4 | 1
9-5 | 9 | 5 | 1
9-6 | 9 | 6 | 1
Spreadsheet: 289740d1389671354-trying-make-a-sheet-to-track-daily-changes-cycles-counts-rev1
Sheet: cycle counts

 | Cycle Counts
 | Total cycles recorded: |  | 8
 | Date | Time | [NAME]
 | 2014-01-09 00:00:00 | 18:19:00 | 100
 | 2014-01-10 00:00:00 | 18:19:00 | 101
 | 2014-01-11 00:00:00 | 18:19:00 | 102
 | 2014-01-12 00:00:00 | 18:19:00 | 103
 | 2014-01-13 00:00:00 | 18:19:00 | 104
 | 2014-01-14 00:00:00 | 18:19:00 | 105
 | 2014-01-15 00:00:00 | 18:19:00 | 106
 | 2014-01-16 00:00:00 | 18:19:00 | 107
 | 2014-01-17 00:00:00 | 18:19:00 | 108
Spreadsheet: joe_parks__14752__ITM 02 Positions
Sheet: R12

R12!$A$4:$A$9 | R12!$D$4:$D$9 | Sum =
 | Ref |  | Net
[NAME] | Period | Curve Code | Qty
 | 2001-07-01 00:00:00 | IF-ELPO/PERMIAN
 | 2001-07-01 00:00:00 | IF-ELPO/SJ
 | 2001-07-01 00:00:00 | IF-EPSJ(BONDAD)
 | 2001-07-01 00:00:00 | IF-NWPL_ROCKY_M
 | 2001-07-01 00:00:00 | IM-TW/SJ
 | 2001-07-01 00:00:00 | WAHA KCBT
Spreadsheet: 157514d1337778288-returning-a-unique-kth-small-k-value-example
Sheet: Sheet2

 |  |  |  |  | item | *row
 |  | 2 |  |  |  | 2 |  |  |  |  | {0;0;0;0;0;0;0;0;0;0;0}
 |  | 5 |  |  | 1 | 5 |  |  |  |  | {1;-1;0;0;0;0;0;0;0;0;0}
 |  | 8 |  |  | 1 | 8 |  |  |  |  | {1;0;-1;0;0;0;0;0;0;0;0}
 |  | 11 |  |  | 2 | 9 |  |  |  |  | {0;0;0;0;0;0;0;0;0;0;0}
 |  | 12 |  |  | 1 | 11 |  |  |  |  | {1;0;0;-1;0;0;0;0;0;0;0}
 |  | 19 |  |  | 1 | 12 |  |  |  |  | {1;0;0;0;-1;0;0;0;0;0;0}
 |  | 21 |  |  | 1
 |  | 32 |  |  | 1
 |  | 45 |  |  | 1
 |  | 48 |  |  | 1
Spreadsheet: 841662d1693838985-sum-without-certain-values-04_09_excelhelp
Sheet: RB Flore

 |  | Placette 1
 |  | Espèce | Recouvrement | Abondance relative | Type bio | Trophie | humidité | Déterminante  ZH | EEE | INDICES
 |  |  |  |  |  |  |  |  |  |  | HUMIDITÉ (H) | Indice humidité |  |  |  | 12
 |  | Agrostis gigantea [NAME], 1788 | 2 |  | [NAME]. | 6 | 7 | Oui
 |  | Cirsium palustre (L.) Scop., 1772 | 2 |  | [NAME]. | 6 | 7 | Oui
 |  | Epilobium tetragonum [NAME], 1753 | 1 |  | [NAME]. | 6 | 6
 |  | Filipendula ulmaria ([NAME]) Maxim., 1879 | 3 |  | [NAME]. | 6 | 7 | Oui |  |  |  |  | Espèces | Indice |  | Recouvrement
 |  | Galium mollugo [NAME], 1753 | 2 |  | [NAME]. | 6 | 5 |  |  |  |  | [NAME] à mésoxérophiles
 |  | Holcus lanatus [NAME], 1753 | 1 |  | [NAME]. | 6 | 5 |  |  |  |  | Mésophiles
 |  | Holcus x hybridus Wein, 1913 | 1 |  |  | 0 | 0 |  |  |  |  | Hygrophiles
 |  | Juncus acutiflorus Ehrh. ex Hoffm., 1791 | 2 |  | Geo. | 3 | 8 | Oui |  |  |  | Hélophytes
 |  | [NAME] effusus L., 1753 | 4 |  | Geo. | 4 | 7 | Oui |  |  |  | Aquatiques
 |  | [NAME], 1753 [nom. et typ. cons.] | 1 |  | [NAME]. | 6 | 5
 |  |  |  |  |  |  |  |  |  |  | TROPHIE (T) | Indice trophie |  |  |  | 9
 |  |  |  |  |  |  |  |  |  |  |  |  | Espèces | Indice |  | Recouvrement
 |  |  |  |  |  |  |  |  |  |  |  | Oligotrophes
 |  |  |  |  |  |  |  |  |  |  |  | Mésotrophes
 |  |  |  |  |  |  |  |  |  |  |  | Eutrophes
 |  |  |  |  |  |  |  |  |  |  |  | Hypereutrophes
 |  |  |  |  |  |  |  |  |  |  | TYPE  BIOLOGIQUE (TB) | Recouvrement des ligneux |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | Espèces | Indice |  | Recouvrement
 |  |  |  |  |  |  |  |  |  |  |  | Phanérophytes
 |  |  |  |  |  |  |  |  |  |  |  | Chaméphytes
 |  |  |  |  |  |  |  |  |  |  |  | Hémicryptophytes
 |  |  |  |  |  |  |  |  |  |  |  | Géophytes
 |  |  |  |  |  |  |  |  |  |  |  | Thérophytes
 |  |  |  |  |  |  |  |  |  |  |  | FIABILITÉ DES INDICES H, T et TB :
 |  |  |  |  |  |  |  |  |  |  | EEE | Recouvrement des EEE |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | Espèces |  |  | Recouvrement
 |  |  |  |  |  |  |  |  |  |  |  | Invasives avérées
 |  |  |  |  |  |  |  |  |  |  |  | Invasives potentielles
 |  |  |  |  |  |  |  |  |  |  |  | À surveiller
 |  |  |  |  |  |  |  |  |  |  | Déterminantes ZH
 |  |  |  |  |  |  |  |  |  |  |  | Emprise de P. aquilinum
 |  |  |  |  |  |  |  |  |  |  |  | Indice de diversité de Simpson :
Spreadsheet: a96f2541-0b1f-4708-b42d-4b835cc15c17
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
FFTHO | Test | FFTHO | Thiosulfate, [NAME] | Thiosulfate, U | Colorimetry (C), Ion Chromatography (IC) | [NAME]: Urine |  |  | 6 | mL | Send 6 mL from a random urine collection. Send specimen refrigerated in a plastic urine container. | 2.8 mL | Hemolysis	NA Thawing	Warm reject; Cold OK Lipemia	NA Icterus	NA Other	NA | Reporting limit determined each analysis   Creatinine (mg/L)     U.S. Population (10th - 90th percentiles, median)   All participants:   	335 - 2370 mg/L, median:  1180 (n=22,245)   Males:	 	495 - 2540 mg/L, median: 1370 (n=10,610)   Females: 	273 - 2170 mg/L, median 994 (n=11,635)   [NAME]  (mcg/mL)   Normal range:  approximately 2.9+/-2.5 mcg/mL (based on an average creatinine concentration of 1 g/L)                                   [NAME] (Creatinine corrected) (mg/g Creat)   [NAME] was detected in urine from 29 controls at 2.9 +/- 2.5 mg/g creatinine.   Exposure to 1240 nmol/L (30 ppm) for 45 minutes resulted in a urinary thiosulfate concentration of 60 mg/g creatinine.   Specific Gravity Confirmation   Physiologic range:  1.010-1.030.                                                     Test Performed by: NMS Labs                              3701 Welsh Road                              P.O. Box 433A                              [NAME], PA 19090-0437 | Varies, Monday through Sunday | 7 days | 9 - 11 days |  | Profile |  |  |  |  | NMS Labs
FFTHO | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 7 days
FFTHO | Result | Z1452 | Creatinine | Creatinine | Alphanumeric |  |  |  |  | mg/L |  |  |  |  |  |  |  |  |  | 2161-8
FFTHO | Result | Z1338 | Reporting Limit | Reporting Limit | Alphanumeric |  |  |  |  | mg/L |  |  |  |  |  |  |  |  |  | In Process
FFTHO | Result | [NAME] | Thiosulfate | Thiosulfate | Alphanumeric |  |  |  |  | mcg/mL |  |  |  |  |  |  |  |  |  | 12420-6
FFTHO | Result | Z1313 | Reporting Limit | Reporting Limit | Alphanumeric |  |  |  |  | mcg/mL |  |  |  |  |  |  |  |  |  | In Process
FFTHO | Result | Z1473 | [NAME] (Creatinine corrected) | [NAME] (Creatinine corrected) | Alphanumeric |  |  |  |  | mg/g creat |  |  |  |  |  |  |  |  |  | 12421-4
FFTHO | Result | Z1314 | Reporting Limit | Reporting Limit | Alphanumeric |  |  |  |  | mg/g creat |  |  |  |  |  |  |  |  |  | In Process
FFTHO | Result | Z2499 | Specific Gravity Confirmation | Specific Gravity Confirmation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FFTHO | Billing Component | FFTHO |  | Chromatography, quant |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 82491
FFTHO | Billing Component | FFTHO |  | Other Source |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 82570
Spreadsheet: 824398d1680542029-comparing-two-lists-with-multiple-columns-lists
Sheet: Sheet7

17 | 13 | Laplante | [NAME] | v
 | 13 | Angers-Trottier | Anne-Marie | v
17 | 13 | Belvedere | Calista | v
17 | 13 | Belvedere | [NAME] | v
17 | 13 | Hudon | Sandra | v
17 | 13 | [NAME] | Sylvie | v
17 | 13 | [NAME] | Alain | v
 | 13 | Charbonneau | [NAME] | v
17 | 13 | Lafleur | [NAME]
17 | 13 | Lafleur | [NAME]
 |  | Amal | Diabi
17 |  | Dupont | [NAME]
 |  | George | hebert
Spreadsheet: 165453d1341237199-highlight-when-a-duplicate-exists-within-7-days-example
Sheet: Sheet1

NHS Number | Date | Day | Arrival  A & E (24hr clock) | Referral Time (24hr clock) | Time Elapsed | Assessed (Yes / No) | Assessment Time (24hr clock) | [NAME] (24hr clock) | Total time | DSH as primary attendance | Offered follow up | Attended follow up | Attended within last 7 days | Breach Details | Staff Member(s) | Comments
1234567890 | 2012-03-12 00:00:00
2345678901 | 2012-03-13 00:00:00
1234657890 | 2012-03-11 00:00:00
1234567890 | 2012-03-14 00:00:00
1234567890 | 2012-03-25 00:00:00
Spreadsheet: 832012d1686061247-map-values-dynamic-arrays-color
Sheet: Feuil1

color (ignore) |  | color (ignore) | abbreviation (ignore) |  |  | color | abbreviation |  | color |  | abbreviation (expected result, as spilling array)
black white |  | black | B |  |  |  |  |  |  |  | BW
yellow |  | yellow | Y |  |  | yellow | Y |  | yellow |  | Y | Y
yellow blue |  | white | W |  |  | white | W |  | yellow blue |  | YB | YB
 |  | blue | B |  |  | blue | B
Spreadsheet: 117693d1312971656-finding-a-ratio-by-shift-variation_calc
Sheet: Raw Parts

Average Parts Per Shift |  |  |  |  |  |  |  |  |  | Average Parts Per Shift
 | (Monday) |  |  |  |  |  |  |  |  |  | (Monday)
Shift | Line |  |  |  |  |  |  |  |  | Shift | Line
1 | IEC109-1 | IEC109-2 | IEC109-3 | IEC109-4 |  |  |  |  |  | 1 | IEC110-1 | IEC110-2 | IEC110-3 | IEC110-4
Shift | Line |  |  |  |  |  |  |  |  | Shift | Line
2 | IEC109-1 | IEC109-2 | IEC109-3 | IEC109-4 |  |  |  |  |  | 2 | IEC110-1 | IEC110-2 | IEC110-3 | IEC110-4
Shift | Line |  |  |  |  |  |  |  |  | Shift | Line
3 | IEC109-1 | IEC109-2 | IEC109-3 | IEC109-4 |  |  |  |  |  | 3 | IEC110-1 | IEC110-2 | IEC110-3 | IEC110-4
 | Shifts: |  | #REF!
 | Time:
 | Current Time: |  |  |  | 109-1 | 109-2 | 109-3 | 109-4 |  |  |  |  |  |  | 110-1 | 110-2 | 110-3 | 110-4
 | End Time |  | 06:00:00
 | Difference:
 | Coefficient
Spreadsheet: 877292d1724079080-count-available-employees-in-employee-break-schedule-based-on-color-copy-of-breaks
Sheet: 05-17-24 Staffing List

Position | Emp# | Employee | Time | Cause | From | To
 |  |  | Code | Code
DSP-SUPD | 3635 | Wilson, [NAME] T | OV | OPEN | 07:00:00 | 19:00:00
[NAME] | 5077 | [NAME], [NAME] | OV | OTHER | 19:00:00 | 07:00:00
DSP-1D | 7092 | [NAME], [NAME] |  |  | 07:00:00 | 19:00:00
DSP-2D | 7132 | Webb, Samantha J |  |  | 07:00:00 | 19:00:00
DSP-3D | 6869 | Miller, Amanda ([NAME]) | OVC | SP | 07:00:00 | 19:00:00
DSP-3TD | 7977 | Thompson, Nathan |  |  | 07:00:00 | 19:00:00
DSP-4D | 5851 | Doval, [NAME] | XW |  | 07:00:00 | 19:00:00
DSP-5D | 7728 | Mojica, Zyali |  |  | 07:00:00 | 19:00:00
DSP-6D | 7263 | Koop, [NAME] |  |  | 07:00:00 | 19:00:00
DSP-7D | 7134 | [NAME], [NAME] |  |  | 07:00:00 | 19:00:00
DSP-7TD | 7963 | [NAME], [NAME] |  |  | 07:00:00 | 19:00:00
DSP-8D | 7971 | Medina, [NAME] | OV | OPEN | 07:00:00 | 19:00:00
DSP-9D | 6868 | [NAME], [NAME] P | OV | OPEN | 07:00:00 | 19:00:00
NIGHTS
DSP-SUPN | 3635 | Wilson, [NAME] T |  |  | 19:00:00 | 07:00:00
DSP-1N | 7266 | Cherness, [NAME] D |  |  | 19:00:00 | 07:00:00
[NAME] | 6869 | Miller, Amanda ([NAME]) | OFC | OTHER | 19:00:00 | 07:00:00
DSP-3N | 7134 | [NAME], [NAME] | OF | VT | 19:00:00 | 07:00:00
[NAME] | 7728 | Mojica, Zyali | OFC | SP | 19:00:00 | 07:00:00
DSP-5N | 7961 | [NAME], [NAME] |  |  | 19:00:00 | 07:00:00
[NAME] | 7132 | Webb, Samantha J | OF | OPEN | 19:00:00 | 07:00:00
DSP-7N | 7263 | Koop, [NAME] | OF | OPEN | 19:00:00 | 07:00:00
DSP-8N | 7963 | [NAME], [NAME] | OFE | OPEN | 19:00:00 | 07:00:00
DSP-9N | 7971 | Medina, [NAME] | OV | OTHER | 19:00:00 | 07:00:00
[NAME] | 5077 | [NAME], [NAME] | OV | OTHER | 19:00:00 | 07:00:00
Spreadsheet: 885398d1734943112-pivot-table-issue-resend-log-copyv3
Sheet: Sheet3

Sku / Product Items | (All)
Month | (Multiple Items)
Row Labels | Sum of Value of resent products £ | Count of orders
Carrier Damaged | 60219.42000000004 | 265
[NAME] | 19028.24 | 30
Incorrect Item Received | 25559.147 | 132
[NAME] from Order | 11812.86999999998 | 92
Lost in Transit | 21852.58999999999 | 70
Order processed but not shipped | 29144.56000000001 | 94
Other (please add to comments) | 8968.68 | 25
Product Issue - Colour Match | 8827.059999999994 | 43
Product Issue - Damaged | 4666.469999999998 | 39
Product Issue - Fault | 5091.069999999999 | 24
was not sent out | 287.96 | 1
Customer Service Issue | 365.98 | 2
Customer Error | 2427.72 | 7
Damage | 179.98 | 1
Grand Total | 198431.747 | 825
Sku / Product Items | (All)
Reason for Resend | (All)
Row Labels | Sum of Value of resent products £ | Count of Orders
January | 9344.046999999995 | 41
February | 3841.169999999998 | 29
March | 10983.31 | 59
April | 14259.09999999998 | 73
June | 20991.21000000001 | 49
August | 16679.46999999999 | 67
September | 25107.81000000002 | 114
October | 36844.57000000001 | 142
November | 17587.15999999999 | 82
December | 15455.05999999999 | 44
May | 12861.06 | 65
July | 13015.04 | 51
November | 149.98 | 2
October | 1312.76 | 7
Grand Total | 198431.7469999998 | 825
Sku / Product Items | (All)
Week | 28
Reason for Resend | Sum of Value of resent products £ | Count of Orders
Carrier Damaged | 1901.3 | 11
Incorrect Item Received | 421.97 | 3
[NAME] from Order | 787.8700000000001 | 6
Order processed but not shipped | 485.95 | 2
Other (please add to comments) | 497.96 | 2
Product Issue - Colour Match | 1152.88 | 6
Product Issue - Damaged | 715.91 | 5
Customer Error | 332.96 | 2
Grand Total | 6296.799999999997 | 37
Sku / Product Items | (All)
Reason for Resend | [NAME] from Order
Row Labels | Sum of Value of resent products £ | Count of Orders
March | 1206.89 | 8
April | 199.96 | 3
May | 944.26 | 9
June | 291.79 | 1
August | 482.43 | 6
September | 1625.81 | 17
October | 3481.88 | 21
July | 198.96 | 4
October | 2.99 | 1
November | 1891.67 | 13
December | 1064.85 | 3
January | 301.45 | 3
February | 69.94 | 2
Grand Total | 11762.87999999998 | 91
Row Labels | Sum of Value of resent products £
[NAME] | 31205.64
DHL | 0
Royal Mail | 21.94
UPS | 39.98
(blank) | 121050.5870000003
Parcel Force | 6690.229999999997
Parcel Force | 189.98
Royal Mail | 2.99
Grand Total | 159201.3470000003
Spreadsheet: 770177d1645869836-sums-of-dynamic-unique-values-with-multiple-criteria-sample-tests
Sheet: Calculation

 | Selected Information (Form Controls) |  |  |  |  |  |  |  |  |  |  | Calculation for scrolling table
 |  | Selected Type | 1
 |  | Selected Year | 1 |  |  |  |  |  |  |  |  |  | Bug
 |  | Selected Bug | 2
 |  |  |  |  |  |  |  |  |  |  |  |  | Type
 |  |  |  |  |  |  |  |  |  |  |  |  | Year
 | For Drop_down selections |  | 7 |  |  | Types data |  |  |  |  |  |  |  |  |  |  | difference from  previous year
 | Year | Type | Values |  |  |  | gram_positive |  |  |  |  | Nr. | Type | isolates_tested | isolates_susceptible | %susceptibility | Δ% susceptibility
 | 2018 | gram_negative | isolates_tested |  |  | Amikacin-Citrobacter freundii | Ampicillin-Enterococcus spp.
 | 2019 | gram_positive | isolates_susceptible |  |  | Amikacin-Klebsiella pneumoniae | Group A Strep-Penicillin
 | 2020 |  | %susceptibility |  |  | Amikacin-Proteus mirabilis | Group B Strep-Penicillin
 |  |  |  |  |  | [NAME] cloacae complex | Linezolid-MRSA
 |  |  |  |  |  | [NAME] morganii | Penicillin-Staphylococcus aureus
 |  |  |  |  |  | [NAME] coli | Linezolid-MSSA
 |  |  |  |  |  | Ertapenem-Acinetobacter baumannii | Penicillin-MRSA
 |  |  |  |  |  | Ertapenem-E. coli | Penicillin-MSSA
 |  |  |  |  |  | Tobramycin-Klebsiella aerogenes
 |  |  |  |  |  | Imipenem-Citrobacter freundii
 |  |  |  |  |  | Meripenem-Citrobacter freundii
 |  |  |  |  |  | Amikacin-E. coli
 |  |  |  |  |  |  |  |  |  |  |  |  | Calculations for headers
 |  |  |  |  |  |  |  |  |  |  |  |  | Hospital Numbers
 |  |  |  |  |  |  |  |  |  |  |  |  | isolate_hospital_n | `=sum of unique values  for each "type",  "year" and "bug" | *** one result from the data is that the isolates_hospital_n  sum for Citrobacter Freundii bug is 13 and not 39. and for MSSA is 66 and not 132.
 |  |  |  |  |  |  |  |  |  |  |  |  |  | *** This should be 160. Different hospitals have exact  test numbers for the same bug and year. Check the blue cells in the data sheet.
Spreadsheet: 737325d1624356112-get-multiple-heder-names-in-one-cell-based-on-filling-the-data-sample-2-
Sheet: Sheet1

Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10 | Column11 | Comments
Test 1 |  | ABC |  | 123 |  | 456 | [NAME] |  |  |  | Column8
 | XYZ |  | Mark |  | 225 | Stephen |  | 963 |  |  | Column4; Column7
 | [NAME] | 4859 |  | 6666 | mark |  | Polo |  |  |  | Column2; Column6; Column8
Spreadsheet: cfe75cde-5b37-4610-bd68-f6f5001b6508
Sheet: Sheet1

Release: Harmonized Indices of Consumer Prices (HICP) | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=251
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2013-05-18 1:32 PM CDT
 | Real-Time | Period
Name: | Start | End
Harmonized Indices of Consumer Prices (HICP) | 2012-06-15 00:00:00 | Current
Link:
http://epp.eurostat.ec.europa.eu/portal/page/portal/hicp/data/main_tables | 2012-06-15 00:00:00 | Current
Source:
Eurostat | 2012-06-15 00:00:00 | Current
Release Dates Notes:
Release dates are determined by the following process:
When available, the actual release date as provided by the source is
entered into the ALFRED database.  If a release date is not available
from the source, the release date given by our data providers is used.
If a release date cannot be determined either from the source or from
our data providers, the date that the series was first available in
the St. Louis Fed's FRED database is used.
The release date list contains the dates when any series from this
release was revised.  Note that all series from a release do not
necessarily revise on every release date.
Release Dates:
2012-06-15 00:00:00
2012-07-15 00:00:00
2012-08-16 00:00:00
2012-09-14 00:00:00
2012-10-16 00:00:00
2012-11-15 00:00:00
2012-12-14 00:00:00
2013-01-16 00:00:00
2013-02-28 00:00:00
2013-03-15 00:00:00
2013-04-16 00:00:00
2013-05-16 00:00:00