tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 777930d1650678058-sumproduct-for-qtrly-data-sumproduct-along-multiple-columns-3
Sheet: Data

 | Target | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual
 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 |  |  |  |  | Select month | 10 | Month in Qtr | 1
 |  | 4 | 4 | 4 | 3 | 3 | 3 | 2 | 2 | 2 | 1 | 1 | 1 |  |  |  |  | Whats the qtr |  | For qtr | 10 | 10
KPI # | Target | 2022-03-01 00:00:00 | 2022-02-01 00:00:00 | 2022-01-01 00:00:00 | 2021-12-01 00:00:00 | 2021-11-01 00:00:00 | 2021-10-01 00:00:00 | 2021-09-01 00:00:00 | 2021-08-01 00:00:00 | 2021-07-01 00:00:00 | 2021-06-01 00:00:00 | 2021-05-01 00:00:00 | 2021-04-01 00:00:00 |  |  |  |  | Target Col | 7 | for YTD | 10 | 19
1a | 0.98 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
2 | 0.98 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  | Monthly cal | # of KPI
3a | 0.98 | 0.97 | 1 | 1 | 0.9856115107913669 | 0.9976649153531816 | 1 | 1 | 0.9960063897763578 | 0.999219968798752 | 1 | 1 | 1 |  |  |  | Monthly cal | Achieved
4a | 0.99 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
4b | 0.985 | 0.9981 | 0.9969 | 0.9968 | 0.9989642672190575 | 0.9994172494172494 | 0.9984472049689441 | 1 | 0.9990892531876139 | 0.9981710105166895 | 0.9989310529128808 | 0.9988864142538976 | 0.9982030548068284
5a | 0.98 | 0.983 | 0.9822 | 0.9739 | 0.9831154684095861 | 0.9899777282850779 | 0.9891219891219891 | 0.9932126696832579 | 0.9840396257567419 | 0.9872241579558653 | 1 | 0.9901685393258427 | 0.9919163100332857 |  |  |  | qtrly cal | # of KPI |  | not very elegant but cant seem to count with array over several columns?
6 | 0.98 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0.9982030548068284 |  |  |  | qtrly cal | Achieved
7 | 0.98 | 0.9943 | 0.9903 | 0.9933 | 0.9972766884531591 | 0.9944444444444445 | 0.9953416149068323 | 0.996629213483146 | 0.9968123861566485 | 0.997624703087886 | 0.9978621058257616 | 0.9927868852459016 | 0.9927868852459016
1a | 0.98 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
2 | 0.98 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  | YTD | # of KPI |  | not very elegant but cant seem to count with array over several columns?
3a | 0.98 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  | YTD | Achieved
4a | 0.99 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
4b | 0.985 | 1 | 0.99 | 0.99 | 0.99 | 0.99 | 0.99 | 0.99 | 1 | 0.99 | 1 | 1 | 1
5a | 0.98 | 0.995 | 1 | 1 | 0.9924242424242424 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
7 | 0.98 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0.9937888198757764 | 0.9937888198757764
1a | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0.5789473684210527 | 0.9666666666666667 | 1 | 1 | 1 | 1
Spreadsheet: kim_ward__20781__Post Feb Structure
Sheet: Sheet1

Option One
 |  | Term 1 | Term 2
 |  | [NAME] | Aug 01-Feb 02
 | Deal 1 | Index +.03 | All gas flows under Deal 2
 | Deal 2 | 4.25 | Index -.12 |  | Volume Doubles in Term 2
 |  |  |  |  | We can make these anything we want (but it will affect the discount in Term 2)
Option Two
 |  | Term 1 | Term 2
 |  | [NAME] | Aug 01-Feb 02
 | Deal 1 | Index +.03 | Index +.03 |  | This can be fixed if a market opportunity emerges
 | Deal 2 | 4.18 | Index -.21
 |  | Existing Deal
 |  | Extension Deal
 |  | Terminated Deal
Spreadsheet: 0a805602-a27a-4620-9383-c5440c47562a
Sheet: 13d

 | Swap Dealers/MSPs5 |  |  | Others
Product1 | HY6 | IG | Other | HY | IG | Other
Index Tranche
Europe | - | - | 780389 | - | - | 123859
North America/Asia | 70195 | 803970 | 7496 | 16528 | 81104 | 4399
Other | - | - | - | - | - | -
Index
Asia | - | - | 170716 | - | - | 37957
Europe | - | - | 4970043 | - | - | 1256789
North America | 892352 | 3990081 | 167401 | 350965 | 1216578 | 48817
Other | - | - | 396285 | - | - | 57541
OTHER* | - | - | 793700 | - | - | 371913
TOTAL
*OTHER variable includes exotic credit products, swaptions, and total return swaps.
Spreadsheet: 73d7f53a-80da-462c-a1ad-e7f678a32384
Sheet: Sheet1

[NAME]--Strategic Conservation Planning Work Group | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 | NAME |  | AFFILIATION | [NAME]
1 | [NAME] | Demers | Maine Natural Areas Program | Augusta, ME
2 | [NAME] | Dempsey | The Nature Conservancy | Brunswick, ME
3 | [NAME] | Drummond | [NAME] | Yarmouth, ME
4 | Rich | Knox | Maine Coast Heritage Trust | Topsham, ME
5 | [NAME] | Owsley | Land Trust Alliance | Topsham, ME
 | [NAME] | Paly | Cross Current Productions | Portsmouth, NH
6 | [NAME] | Platt | Island Institute | Rockland, ME
7 | [NAME] | Rekow | NOAA Coastal Services Center | Charleston, SC
8 | [NAME] | Shore | Maine Coast Heritage Trust | Topsham, ME
9 | [NAME] | Winter | US Fish and Wildlife Service, Gulf of Maine Program | Falmouth, ME
Spreadsheet: 0e1d5b64-9597-4e27-8273-56891e06a895
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 | Ima Goodworker
 | 000-00-0000
 | Pay Period:  07/01/2011 to 07/15/2011
 |  |  |  |  |  |  |  | Deductions | Year to Date
 |  |  |  |  |  |  | Federal Tax | 132 | 1716
 |  |  |  |  |  |  | Vermont State Tax | 34.32 | 446.16
 |  |  |  |  |  |  | Soc Sec Tax | 50.40000000000001 | 705.6
Description |  | Hours | Earnings | Year to Date |  |  | Medicare Tax | 17.4 | 243.6
Regular Earnings |  | 72 | 1080 | 16320 |  |  | Medical Insurance | 30 | 390
 |  |  |  |  |  |  | Dental Insurance | 5 | 65
Holiday Earnings |  | 8 | 120 | 480 |  |  | 401(K) | 50 | 650
Gross Earnings |  | 80 | 1200 | 16800 |  |  | Auto Savings | 25 | 325
 |  |  |  |  |  |  | Checking ACH | 855.88 | 12583.64
Pay Period | Earnings | Taxes | Deductions |  | Check Amount
07/01/11 to 07/15/11 | 1200 | 234.12 | 344.12 |  | 855.88
Year to Date | 16800 | 3111.36 | 4216.36 |  | 12583.64
 |  | Earned | Used | Total
PTO Accrual: Hours |  | 5 | 0 | 65
Spreadsheet: 119801d1314757224-how-to-sum-data-sourced-through-indirect-and-match-workbook
Sheet: Rec

Date | Position | AUD | BRL | CAD | CHF | CZK | DKK | EUR | GBP | HKD | HUF | ILS | [NAME] | KRW | NOK | NZD | SEK | SGD | THB | TRY | USD | ZAR
30Aug2011 | Initial | 2360085.93 | 35629.58 | 126589.53 | 0 | 6538 | 0 | 0 | 0 | 0 | 0 | 0 | 135629865 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6016.5 | 0
 | Trade | 542560.08 | <- this cell should sum all of the AUD currency values sourced from sheet 30Aug2011
Spreadsheet: 862554d1710251382-dynamic-range-within-table-or-equivalent-for-forum
Sheet: PoC Monitor

 | R1 | Revised as per Regulations
 | R2 | Initials of Director
 | R3 | Reviewed with RN Responsible for Client and Note any Changes to Plan of Care
 | R4 | Reviewed with parent/guardian and note any changes to Plan of Care
 | R5 | Faxed the MD caring for client and note any changes
 | R6 | Sent to Medical Director and note any changes
 | R7 | Set in place as acceptable Plan of Care for the month
 |  |  | January |  |  |  |  |  |  | February
 | Surname | Forename | J R1 | J R2 | J R3 | J R4 | J R5 | J R6 | J R7 | F R1 | F R2 | F R3 | F R4 | F R5 | F R6 | F R7
 |  | [NAME] | X | X
 | Smith | [NAME]
 | Jones | [NAME]
Spreadsheet: 239623d1369962647-macro-or-formula-testmacro
Sheet: Advantage

 | Static data |  |  | Variables/Input
 | Policies / Location | 240 |  | Claim Rate: | 0.38 | (Enter any % from 1 to 100)
 | Price / Policy | 80 |  | % of All Types | 0.75 | (Enter any % from 1 to 100; ttl of three types has to = 100%)
 | Admin Fee | 90
 | Cost / Claim | 300
 | Year | # of Locations | Ttl Policies Sold | Advantage Policies Sold | Revenue | [NAME] |  |  | Total Revenue | Claim Cost | Gross Profit
 | 2013 | 300
 | 2014 | 600
 | 2015 | 900
 | 2016 | 1200
 | 2017 | 1500
 | 2018 | 1800
 | 2019 | 2100
 | 2020 | 2400
Spreadsheet: 884442d1733586299-adding-additional-sort-in-filter-sortby-sample
Sheet: Sheet2

Answer:
City | Sales | Classification | Grade
NY | 7 | VS | A+ |  |  | 5 | VS | A+ |  |  | 7 | VS | A+ |  |  | 7 | VS | A+ |  |  | 7 | VS | A+
NY | 5 | VS | A+ |  | NY | 7 | VS | A+ |  | NY | 5 | VS | A+ |  | NY | 5 | VS | A+ |  | NY | 5 | VS | A+
London | 1.5 | VS | A+ |  | London | 1.5 | VS | A+ |  | London | 1.5 | VS | A+ |  | London | 1.5 | VS | A+ |  | London | 1.5 | VS | A+
Berlin | 4.5 | VS | A |  | Berlin | 4.5 | VS | A |  | Berlin | 4.5 | VS | A |  | Berlin | 4.5 | VS | A |  | Berlin | 4.5 | VS | A
Hong Kong | 0.5 | VS | C |  | Hong Kong | 0.5 | VS | C |  | Hong Kong | 0.5 | VS | C |  | Hong Kong | 0.5 | VS | C |  | Hong Kong | 0.5 | VS | C
Seattle | 0.3 | VB | A |  | Seattle | 0.3 | VB | A |  | Seattle | 0.3 | VB | A |  | Seattle | 0.3 | VB | A |  | Seattle | 0.3 | VB | A
LA | 3 | VB | A- |  | LA | 3 | VB | A- |  | LA | 3 | VB | A- |  | LA | 3 | VB | A- |  | LA | 3 | VB | A-
Paris | 1.2 | VB | B |  | Paris | 1.2 | VB | B |  | Paris | 1.2 | VB | B |  | Paris | 1.2 | VB | B |  | Paris | 1.2 | VB | B
Milan | 1 | VB | B |  | Milan | 1 | VB | B |  | Milan | 1 | VB | B |  | Milan | 1 | VB | B |  | Milan | 1 | VB | B
Toronto | 0.7 | VB | B- |  | Toronto | 0.7 | VB | B- |  | Toronto | 0.7 | VB | B- |  | Toronto | 0.7 | VB | B- |  | Toronto | 0.7 | VB | B-
Madrid | 2 | VB | C |  | Madrid | 2 | VB | C |  | Madrid | 2 | VB | C |  | Madrid | 2 | VB | C |  | Madrid | 2 | VB | C
Spreadsheet: 025f689c-36bc-4a02-b352-3633394410cc
Sheet: $$ Support Staff

[NAME] vs. [NAME]
Salaries & Wages Support Staff
 | FY 2006 | FY 2007 | FY 2008 | FY 2009 | FY 2010 | % Change
Peer Average
Peer Median
University of Rhode Island | 1095332 | 1818401 | 1237998 | 946693 | 702628
[NAME] University | 1236222 | 1245393 | 1403579 | 2070387 | 2236541
Montana State University - Bozeman | 769668 | 794138 | 886801 | U/A | 886801
North Dakota State University - Main Campus | 607193 | 616202 | 630907 | 700646 | U/A | U/A
University of Maine | 866511 | 968158 | 935919 | 981486 | 902468
University of New Hampshire - Main Campus | 1744212 | 1109109 | 1111621 | 1289756 | 1934106
University of Vermont and State Ag. Coll. | U/A | 1278459 | 1191871 | 1442874 | 1234150 | U/A
University of Wyoming | 698128 | 664465 | 635070 | 618567 | 675285
Source: ACRLMetrics
Revised: October 24, 2011, ajr
Spreadsheet: 90333d1290082131-attempting-scatter-diagram-excel
Sheet: Stage 2

A score is between 1-5 (please note that in some instances the score has been multiplied)
Company Name | 2nd Stage (Technology Fit) | Potential | Commercialisation | Life-cycle Stage | Competitors (location and application) | Total
 |  | Multiplied by 2 | Multiplied by 1.5
OCS Checkweighers |  | 4 | 6 | 4
Linkam |  | 10 | 0 | 0
Logitech Limited |  | 8 | 0 | 2
Medisafe International |  | 6 | 1.5 | 0
[NAME] |  | 8 | 4.5 | 3
Dreampact |  | 10 | 0 | 1
Laser Quantum |  | 10 | 4.5 | 3
Megger |  | 6 | 0 | 0
Elecrox |  | 6 | 3 | 3
Edinburgh Instruments |  | 8 | 3 | 1
Applied Photophysics |  | 8 | 6 | 2
Fischer Instrumentation |  | 6 | 1.5 | 1
OKW Enclosures Ltd |  | 4 | 4.5 | 1
SPI Lasers |  | 8 | 6 | 4
Cascade |  | 4 | 7 | 5
Teraview |  | 10 | 4.5 | 2
[NAME] |  | 6 | 1.5 | 1
Peratech |  | 6 | 1.5 | 4
Spreadsheet: 153234d1335814914-need-help-consolidating-data-across-multiple-sheets-warehouse-store-order-list-4-30-12
Sheet: Salsa

Ordered | Item | Description | Retail | Heat Level | Category
 | R126 | Atlantic Blue Crab Salsa, 12 oz. | 8.95 | 1 | Salsa
 | R212 | Black Bean & Corn Salsa - Sweet Mild, 16 oz. | 6.95 | 1 | Salsa
 | R314 | Black Bean & Corn Salsa -Sweet Hot, 16 oz. | 6.95 | 5 | Salsa
 | R38 | [NAME], 12 oz | 7.95 | 6 | Salsa
 | Q110 | Death By Salsa, 16 oz. | 8.95 | 10+ | Salsa
 | R316 | Gourmet Ghost Pepper (Jolokia) Salsa, 16 oz | 7.95 | 10 | Salsa
 | R24 | Gourmet Roasted Garlic & Olive Salsa, 16 oz. | 6.95 | 2 | Salsa
 | R26 | Gourmet Roasted Garlic Salsa, 16 oz. | 6.95 | 2 | Salsa
 | R218 | Gourmet Salsa - Hot, 16 oz. | 6.95 | 5 | Salsa
 | R322 | Gourmet Salsa - Med, 16 oz. | 6.95 | 3 | Salsa
 | R320 | Gourmet Salsa - Mild, 16 oz. | 6.95 | 1 | Salsa
 | R34 | Gourmet Salsa - X- Hot, 16 oz. | 6.95 | 8 | Salsa
 | R36 | Key Lime Salsa, 16 oz. | 6.95 | 3 | Salsa
 | R32 | Mango Salsa, 16 oz. | 6.95 | 1 | Salsa
 | R216 | Mesquite Smoked Jalapeno Salsa, 16 oz. | 6.95 | 6 | Salsa
 | R124 | Not Sweet Black Bean & Corn - Med,  12 oz. | 6.95 | 5 | Salsa
 | NN200 | Not Sweet Five Pepper Fire Roasted Pepper Salsa, 16 oz. | 9.95 | 8 | Salsa
 | NN205 | Not [NAME], 16 oz. | 7.95 | 7 | Salsa
 | R118 | Not Sweet Green Jalapeno Salsa, 16 oz. | 6.95 | 8 | Salsa
 | R120 | Not Sweet Salsa - Hot, 16 oz. | 6.95 | 6 | Salsa
 | R122 | Not [NAME], 16 oz. | 6.95 | 2 | Salsa
 | R116 | Not [NAME], 16 oz | 6.95 | 10 | Salsa
 | P2195 | Not [NAME] Salsa, 16 oz. | 7.95 | 1 | Salsa
 | N1005 | Not Sweet X-Hot Garlic Salsa, 16 oz. | 7.95 | 8 | Salsa
 | R220 | Peach Salsa, 16 oz. | 6.95 | 1 | Salsa
 | Q196 | Pepper Palace Gourmet [NAME], 16oz. | 6.95 | 1 | Salsa
 | R22 | Pineapple Salsa, 16 oz. | 6.95 | 1 | Salsa
 | R318 | [NAME], 16 oz. | 6.95 | 1 | Salsa
 | [NAME] | [NAME], 4.4 | 6.95 | Variable | Salsa
 | R214 | Smoky Palace Salsa, 16 oz. | 6.95 | 6 | Salsa
Spreadsheet: 850726d1701113797-add-data-from-multiple-sheets-sample-workbook
Sheet: SHEET5

 | Company Logo |  | Company Name Address City, State Zip (123) 456-7890 https://website.com
 | Name |  | Period |  | Vehicle |  |  | License Plate# |  |  | Reimbursement Rate
 | XXXXXX |  | 9/20/2023-11/2/2023 |  | XXXXXXXXXXXX |  |  | XXXXXX |  |  | 0.655
 | Date | Business Purpose |  | From |  | To |  | Odometer ([NAME]) |  | Mileage |  | Remarks
 |  |  |  |  |  |  |  | Start | End
 |  | Reason for travel (text) |  | City, State |  | City, State
 |  | Reason for travel (text) |  | City, State |  | City, State
 |  | Reason for travel (text) |  | City, State |  | City, State
 |  | Reason for travel (text) |  | City, State |  | City, State
 |  | Reason for travel (text) |  | City, State |  | City, State
 |  | Reason for travel (text) |  | City, State |  | City, State
 |  | Reason for travel (text) |  | City, State |  | City, State
 |  | Reason for travel (text) |  | City, State |  | City, State
 |  | Reason for travel (text) |  | City, State |  | City, State
 |  | Reason for travel (text) |  | City, State |  | City, State
 |  | Reason for travel (text) |  | City, State |  | City, State
 |  | Reason for travel (text) |  | City, State |  | City, State
 |  | Reason for travel (text) |  | City, State |  | City, State
 |  | Reason for travel (text) |  | City, State |  | City, State
 |  | Reason for travel (text) |  | City, State |  | City, State
 |  | Reason for travel (text) |  | City, State |  | City, State
 |  | Reason for travel (text) |  | City, State |  | City, State
 |  | Period Reimbursement Total |  |  |  |  |  |  | Total Miles
Spreadsheet: 122170d1316637046-using-vlookup-of-gm-to-calculate-a-price-pricing
Sheet: update

NONE | CIM-16.5X21.5 |  |  | 30.47169811320754 | 0 | 16.15
 | CIM-16.5X21.5X1 |  |  | 165.8196721311475 |  | 101.15
 | CIM-[PHONE] |  |  | 26.47540983606557 |  | 16.15
 | CIM-[PHONE] |  |  | 26.47540983606557 |  | 16.15
 | CIM-[PHONE] |  |  | 26.47540983606557 |  | 16.15
 | CIM-[PHONE] |  |  | 26.47540983606557 |  | 16.15
 | CIM-[PHONE] |  |  | 26.47540983606557 |  | 16.15
 | CIM-[PHONE] |  |  | 26.47540983606557 |  | 16.15
 | CIM-[PHONE] |  |  | 26.47540983606557 |  | 16.15
 | CIM-[PHONE] |  |  | 26.47540983606557 |  | 16.15
 | CIM-[PHONE] |  |  | 26.47540983606557 |  | 16.15
 | CIM-[PHONE] |  |  | 165.8196721311475 |  | 101.15
 | CIM-[PHONE] |  |  | 165.8196721311475 |  | 101.15
 | CIM-[PHONE] |  |  | 165.8196721311475 |  | 101.15
 | CIM-[PHONE] |  |  | 165.8196721311475 |  | 101.15
 | CIM-[PHONE] |  |  | 165.8196721311475 |  | 101.15
 | [NAME] |  |  | 165.8196721311475 |  | 101.15
 | Column1 | Column2 |  | Below $.50 then use 70% GP
 | 0 | 0.7 |  | if the cost is > 0.50 then use 65%
 | 0.5 | 0.65 |  | if the cost is > 1.00 then use 60%
 | 1 | 0.6 |  | if the cost is > 5.00 then use 55%
 | 5 | 0.55 |  | if the cost is > 10.00 then use 50%
 | 10 | 0.5 |  | if the cost is > 25.00 then use 47%
 | 25 | 0.47 |  | if the cost is > 50.00 THEN USE 45% GP
 | 50 | 0.45 |  | if the cost is > 100.00 then use 35% GP
 | 100 | 0.35 |  | if cost is > 200.00 then use 30% GP
 | 200 | 0.3 |  | if the cost is > 500.00 then use 27% GP
 | 500 | 0.27
Spreadsheet: 99039d1297810730-if-and-vlookup-in-12-sheets-99
Sheet: Mai

Product | Description | Stock | Price
Tennisschläger | rot | 20 | 85
Tennisschläger | schwarz | 15 | 85
Fussball | schwarz | 10 | 45
Fussball | weiss | 35 | 45
[NAME] | weiss | 85 | 8
Handtuch | schwarz | 10 | 11
Badetuch | gestreift | 10 | 18
Spreadsheet: 3586d0dd-fdcb-4d54-80ab-2c0999758287
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
ANIDE | Test | ANIDE | Organism Referred for Identification, Anaerobic Bacteria | Organism Ref for ID, Anaerobic Bact | Dependent on organism submitted, 1 or more of the following methods will be used: conventional biochemical testing, gas-liquid chromatography (GLC), and 16S RNA sequencing. | Anaerobic transport tubes (BBL Port-A-Cul Tubes-Supply T588) |  |  |  |  | [NAME] culture of organism from a source not normally colonized by anaerobes Acceptable Sources: Abscesses, percutaneous transtracheal aspirates, sterile body fluids, suprapubic aspirations, or wounds Container/Tube: Anaerobic transport tube (BBL Port-A-Cul Tube) (Supply T588), thioglycollate broth, or any other suitable anaerobic transport system Collection Instructions: Label specimen as an etiologic agent. Additional Information: 1. Specimen source is required. 2. Isolate description is required: Gram stain reaction, morphology, tests performed. 3. If susceptibility testing is needed; order MMLSA Antimicrobial Susceptibility, [NAME], MIC also. If susceptibilities are not appropriate, MMLSA will be canceled at report time.  4. See Infectious Specimen Shipping Guidelines in Special Instructions for shipping information. Forms: If not ordering electronically, submit a Microbiology Request Form (Supply T244) with the specimen. |  | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	Agar plate | Identification of organism | Monday through Sunday; Varies | 6 days/3-6 days | 14 days | 1 | 87076 |  |  |  |  | Rochester
ANIDE | [NAME] | VARIES | Varies |  |  |  | Ambient
ANIDE | Order Question | Q00M0004 | [NAME]) and Isolate Description-Gram reaction, morphology, tests performed (Required) |  | Plain Text
ANIDE | Result | ANIDE | Organism Ref for ID, Anaerobic Bact | Organism Ref for ID, Anaerobic Bact | Alphanumeric |  |  |  |  | mL |  |  |  |  |  |  |  |  |  | 20878-5 | Bacteria identified:Prid:Pt:Isolate:Nom:Anaerobic culture
ANIDE | [NAME] | ANAID | Anaerobe Ident | Anaerobe Ident |  |  |  |  |  |  | This test is for Billing Purposes Only.  This is not an orderable test. |  |  |  |  |  |  | 1 | 87076 |  |  | No | No ([NAME] Only)
ANAID | [NAME] | VARIES | Varies |  |  |  | See instructions
ANIDE | [NAME] | ISAN | Anaerobe Ident by Sequencing | Anaerobe Ident by Sequencing |  |  |  |  |  |  | This test is for billing purposes only. This is not an orderable test. |  |  | This test is for billing purposes only. This is not an orderable test. |  |  |  | 1 | 87153 |  |  | No | No ([NAME] Only)
ISAN | [NAME] | VARIES | Varies |  |  |  | See instructions
Spreadsheet: 690641d1597218284-multiple-outputs-on-xlookup-test-001
Sheet: DAILY RECON

TRANSACTION TYPE | DATE | [NAME] | ISSUE TO EQUIPMENT/DC | BELL SYN ATF ULTRA - 20 LITRES | CUMMINS ES COMPLEAT CONCENTRATE - 208 LITRES | ECOSAFE - FR46 - 200 LITRES | ECOSAFE V200 - 200 LITRES | ENGEN AGRIFLUID - 210 LITRES | ENGEN ANTIFREEZE & SUMMER CONCENTRATE - 210 LITRES | ENGEN ANTIFREEZE & SUMMER CONCENTRATE - ALREADY MIXED | ENGEN ATF 22D - 210 LITRES | ENGEN ATF III - 210 LITRES | ENGEN DIESEL LUBE 510 SAE 10W-20 - 210 LITRES | ENGEN DIESEL LUBE 700 SUPER SAE 15W-40 - 210 LITRES | ENGEN GEAR LUBE EP 90-LS - 210 LITRES | ENGEN GEARLUBE EP 85W-140 - 210 LITRES | ENGEN GEARLUBE HP 80W-90 - 210 LITRES | ENGEN HYDROKIN ESF 46 - 210 LITRES | ENGEN RESISTA SULFONATE GREASE - 180 KG | ENGEN SUPER BRAKE FLUID DOT 4+ - 20 LITRES | ENGEN TEKPROL - 200 LITRES | ENGEN TQH 20/68 - 210 LITRES | ENGEN TRANSFLUID TO-4 SAE 30 - 210 LITRES | ENGEN TRANSFLUID TO-4 SAE 50 - 210 LITRES | HITACHI HIGH GEAR OIL - 200 LITRES | PETRONAS URANIA 3000E/OPTIMO 10W-40 - 210 LITRES | [NAME] | VOLVO ANTI FREEZE - 20 LITRES | VOLVO AUTOMATIC TRANSMISSION FLUID AT102 - 208 LITRES | VOLVO WB102 - SUPER WET BRAKE TRANSAXLE OIL - 208 LITRES
OPEN STOCK | 2020-08-01 00:00:00 | MAIN STORE
 |  | MAIN WORKSHOP
OPEN STOCK |  | TOTAL
DELIVERIES |  | MAIN STORE
 |  | MAIN WORKSHOP
DELIVERIES |  | TOTAL
ISSUES FROM DC'S |  | B151
 | 2020-08-01 00:00:00 | B151
ISSUES FROM DC'S |  | TOTAL
CLOSE STOCK |  | MAIN STORE
 |  | MAIN WORKSHOP
CLOSE STOCK |  | TOTAL
[NAME] |  | TOTAL
Comments
TRANSACTION TYPE | DATE | [NAME] | ISSUE TO EQUIPMENT/DC | BELL SYN ATF ULTRA - 20 LITRES | CUMMINS ES COMPLEAT CONCENTRATE - 208 LITRES | ECOSAFE - FR46 - 200 LITRES | ECOSAFE V200 - 200 LITRES | ENGEN AGRIFLUID - 210 LITRES | ENGEN ANTIFREEZE & SUMMER CONCENTRATE - 210 LITRES | ENGEN ANTIFREEZE & SUMMER CONCENTRATE - ALREADY MIXED | ENGEN ATF 22D - 210 LITRES | ENGEN ATF III - 210 LITRES | ENGEN DIESEL LUBE 510 SAE 10W-20 - 210 LITRES | ENGEN DIESEL LUBE 700 SUPER SAE 15W-40 - 210 LITRES | ENGEN GEAR LUBE EP 90-LS - 210 LITRES | ENGEN GEARLUBE EP 85W-140 - 210 LITRES | ENGEN GEARLUBE HP 80W-90 - 210 LITRES | ENGEN HYDROKIN ESF 46 - 210 LITRES | ENGEN RESISTA SULFONATE GREASE - 180 KG | ENGEN SUPER BRAKE FLUID DOT 4+ - 20 LITRES | ENGEN TEKPROL - 200 LITRES | ENGEN TQH 20/68 - 210 LITRES | ENGEN TRANSFLUID TO-4 SAE 30 - 210 LITRES | ENGEN TRANSFLUID TO-4 SAE 50 - 210 LITRES | HITACHI HIGH GEAR OIL - 200 LITRES | PETRONAS URANIA 3000E/OPTIMO 10W-40 - 210 LITRES | [NAME] | VOLVO ANTI FREEZE - 20 LITRES | VOLVO AUTOMATIC TRANSMISSION FLUID AT102 - 208 LITRES | VOLVO WB102 - SUPER WET BRAKE TRANSAXLE OIL - 208 LITRES
OPEN STOCK | 2020-08-02 00:00:00 | MAIN STORE
 |  | MAIN WORKSHOP
OPEN STOCK |  | TOTAL
Spreadsheet: 675519d1588340260-combination-of-two-iterative-formula-expected-check-simple-
Sheet: Sheet1

 |  | ARRAY 1 |  |  |  |  |  |  |  | 3 | 1
3 | 1 | [NAME] | STEPHEN | JOANNE |  |  |  |  |  | 4 | 2
4 | 2 | TREVOR | THOMAS | FRED | [NAME] |  |  |  |  | 2 | 3
2 | 3 | STEPHEN | ANDREW |  |  |  |  |  |  | 3 | 4
3 | 4 | CRAIG | TREVOR | THOMAS |  |  |  |  |  | 7 | 5
7 | 5 | JOANNE | FRED | TREVOR | THOMAS | [NAME] | [NAME] | [NAME]
ARRAY2 | DESIRED |  | ARRAY2 | DESIRED |  | ARRAY2 | DESIRED |  | ARRAY2 | DESIRED |  | ARRAY2 | DESIRED
[NAME] |  |  | TREVOR | [NAME] |  | CRAIG | [NAME] |  | TREVOR | [NAME] |  | STEPHEN
STEPHEN | TREVOR |  | THOMAS | FRED |  | THOMAS | TREVOR |  | JOANNE | FRED |  | ANDREW
 | ANDREW |  |  | STEPHEN |  |  | STEPHEN |  | CRAIG | STEPHEN
 | CRAIG |  |  | CRAIG |  |  |  |  |  | THOMAS
 | JOANNE |  |  | JOANNE |  |  | JOANNE |  |  | [NAME]
Spreadsheet: 161120d1339422610-time-calcualtions-and-value-example-time-sheet
Sheet: Sheet3

Month | Date |  |  | Vacation Hrs | Holiday Hrs | Sick Hrs | Start Time | End  Time | [NAME] |  | Comment
 | 2013-01-05 00:00:00 |  |  |  |  |  | 07:00:00 | 15:00:00 | 08:00:00 |  |  |  | WEEK 2
 | 2013-01-06 00:00:00 |  |  |  |  |  | 07:00:00 | 15:00:00 | 08:00:00
 | 2013-01-07 00:00:00 |  |  |  |  |  | 07:00:00 | 15:00:00 | 08:00:00
 | 2013-01-08 00:00:00 |  |  |  |  |  | 19:00:00 | 05:00:00 | 10:00:00
 | 2013-01-09 00:00:00 |  |  |  |  |  | 19:00:00 | 07:00:00 | 12:00:00
 | 2013-01-10 00:00:00 |  |  |  |  |  | 19:00:00 | 07:00:00 | 12:00:00
 | 2013-01-11 00:00:00 |  |  |  |  |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
 |  | Weekly Totals |  | 0 | 0 | 0 |  |  | 58.00000000000001
 |  |  |  |  |  |  | Weekly Utilization |  | 1.45