tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 234c871e-e14d-49fe-8658-7086159a11c7
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
ETHO | Test | ETHO | Ethotoin (Peganoner) | Ethotoin (Peganone) | Gas Chromatography/Flame Ionization Detection (GC-FID) | 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] is not acceptable.)  [NAME] down and send 2 mL sodium heparin plasma refrigerated.   Note:		1. Indicate plasma on request form. 		2. Label specimen appropriately (plasma).                 	3. Trough levels are most reproducible.   Serum Draw in a plain, red-top tube(s). (Serum gel tube is not  acceptable.) Spin down and send 2 mL of serum  refrigerated. Note:		1. Indicate serum on request form. 		2. Label specimen appropriately (serum).                  	3. Trough levels are most reproducible. | 0.2 mL NOTE: Submission of the m | Specimens other than	Plasma, serum Anticoagulants other than	Sodium heparin, EDTA, plain red-top Hemolysis	NA Thawing	NA Lipemia	NA Icteric	NA | Reference Range: 8.0-20.0 ug/mL   Please note: The therapeutic range for ethotoin is not well established. Many patients respond well to ethotoin concentrations up to 60 ug/mL.   Test Performed By: Medtox Laboratories, Inc. 402 W. County Road D St. Paul, MN 55112 | Monday through Sunday | 2 days | 4 - 6 days | 1 | 82491 |  |  |  |  | Medtox Laboratories, Inc
ETHO | Result | Z1119 | Ethotoin | Ethotoin | Numeric |  |  |  |  | ug/mL |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 335733d1406689341-countif-involving-criteria-from-2-different-columns-bethsweddingguestlist
Sheet: RSVP Shower

 |  |  | [NAME] List
WEDDING DATE
 |  |  | Guest Name | Sent | [NAME] | Party | Address | City | State | Zip | [NAME] | Thank You Card?
 |  |  | [NAME] | No |  |  | 4555 Some Road | Someplace | KS | 55555
DAYS REMAINING |  |  | Guest 2 | No
 |  |  | Guest 3 | No
 |  |  | Guest 4 | No
INVITES SENT |  |  | Guest 5 | No
 |  |  | Guest 6 | No
 |  |  | Guest 7 | No
ATTENDING |  |  | Guest 8 | No
 |  |  | Guest 9 | No
 |  |  | Guest  10 | No
TOTAL IN PARTY |  |  | Guest 11 | No
 |  |  |  | No
NOT ATTENDING
[NAME]
Spreadsheet: 3fdfe860-45f0-47e6-a0f8-0c641dcf4625
Sheet: ELED

Old course number | New course number
ELED-301 | ELED-3301
ELED-302 | ELED-3302
ELED-303 | ELED-3303
ELED-401 | ELED-4401
ELED-410 | ELED-4420
ELED-430 | ELED-4430
ELED-450 | ELED-4450
ELED-460 | ELED-4460
ELED-463 | ELED-4463
ELED-466 | ELED-4466
ELED-499 | ELED-4999
ELED-500 | ELED-5500
Spreadsheet: 61451afe-38b2-4907-bcb3-35f90731f565
Sheet: Ex. 10 - Repl. Unit Analysis

Exhibit 10: Residential Deplacement and Replacement Unit Analysis
[Project Name]
2014-15 Housing Development NOFA
This worksheet must be completed if any of the current site use is residential, even if all existing units are currently vacant.  Complete chart according to the current uses, not your proposal.  Each unit must be on a separate line.  Add lines if necessary.
Proposal Includes Substantial Renovation: |  |  | No/Yes
Proposal Includes Demolition and New Construction: |  |  |  | No/Yes
Current Configuration of Site
Number of Residential Buildings:
Total Number of Units:
Unit Number | Number of Bedrooms | Monthly Gross Rent | [NAME] | Household Income | Check one |  |  |  | Is Unit Currently Occupied? | Is Unit Accessible?
 |  |  |  |  | Under 30% AMI | Under 50% AMI | Under 80% AMI | Market Rate
Summary
 |  | # units with annual rents ≤ 30% of 30% AMI
 |  | # units with annual rents ≤ 30% of 50% AMI
 |  | # units with annual rents ≤ 30% of 80% AMI
 |  | # units with annual rents ≤ 30% of 120% AMI
 |  | # market rate units
Spreadsheet: 61986d1262895018-dependent-drop-lists-dependent-degressive-drop-lists
Sheet: MySolution

Degressive DropDown
 | Name |  | [NAME] |  | Source | Dynamic Sorce
 | Nickleback |  | [NAME] |  |  | [NAME]
 | [NAME] |  | AC/DC |  | [NAME] | [NAME]
 | [NAME] |  | Seether |  | [NAME] | Linkin Park
 | Linkin Park |  | Nickleback |  | Linkin Park | Green Day
 | Seether |  |  |  |  | Smashing Pumpkins
 | Green Day |  |  |  | Green Day | Placebo
 | Smashing Pumpkins |  |  |  | Smashing Pumpkins | [NAME]
 | AC/DC |  |  |  |  | [NAME]
 | Placebo |  |  |  | Placebo
 | [NAME] |  |  |  | [NAME]
 | [NAME]
 | [NAME] |  |  |  | [NAME]
 | Named [NAME]
 | DynamicSource
 | Name
 |  | {=LOOKUP(REPT("z",255),CHOOSE({1,2},"",INDEX($F$3:$F$35,SMALL(IF($F$3:$F$35<>"",ROW(INDIRECT("1:"&ROWS($F$3:$F$35))),""),ROW(A1)))))}
 |  | {=LOOKUP(REPT("z",255),CHOOSE({1,2},"",INDEX($B$3:$B$35,IF(OR(B3=$D$3:$D$35),"",ROW(A1)))))}
 | Named Range
 | Source
Spreadsheet: 778819d1651339164-automatically-update-time-left-in-cell-f2-based-on-horizontal-entries-through-column-h-sample-workbook-1
Sheet: Sheet1

Name |  |  | Amount funded | [NAME] | Balance Owed |  | Frequency |  | FORMULA STILL INCONCLUSIVE (Automatically update time left based on horizontal entries through L2: onwards) | TIME LEFT (Months) | 2021-06-21 00:00:00 | 2021-07-21 00:00:00 | 2021-08-21 00:00:00 | 2021-09-21 00:00:00 | 2021-10-21 00:00:00 | 2021-11-21 00:00:00 | 2021-12-21 00:00:00 | 2022-01-21 00:00:00 | 2022-02-21 00:00:00 | 2022-03-21 00:00:00 | 2022-04-21 00:00:00 | 2022-05-21 00:00:00 | 2022-06-21 00:00:00 | 2022-07-21 00:00:00 | 2022-08-21 00:00:00 | 2022-09-21 00:00:00 | 2022-10-21 00:00:00 | 2022-11-21 00:00:00 | 2022-12-21 00:00:00 | 2023-01-21 00:00:00 | 2023-02-21 00:00:00 | 2023-03-21 00:00:00 | 2023-04-21 00:00:00 | 2023-05-21 00:00:00 | 2023-06-21 00:00:00 | 2023-07-21 00:00:00 | 2023-08-21 00:00:00 | 2023-09-21 00:00:00 | 2023-10-21 00:00:00 | 2023-11-21 00:00:00 | 2023-12-21 00:00:00 | 2024-01-21 00:00:00 | 2024-02-21 00:00:00 | 2024-03-21 00:00:00 | 2024-04-21 00:00:00 | 2024-05-21 00:00:00 | 2024-06-21 00:00:00 | 2024-07-21 00:00:00 | 2024-08-21 00:00:00 | 2024-09-21 00:00:00 | 2024-10-21 00:00:00 | 2024-11-21 00:00:00 | 2024-12-21 00:00:00 | 2025-01-21 00:00:00 | 2025-02-21 00:00:00 | 2025-03-21 00:00:00 | 2025-04-21 00:00:00 | 2025-05-21 00:00:00 | 2025-06-21 00:00:00 | 2025-07-21 00:00:00 | 2025-08-21 00:00:00 | 2025-09-21 00:00:00 | 2025-10-21 00:00:00 | 2025-11-21 00:00:00 | 2025-12-21 00:00:00 | 2026-01-21 00:00:00 | 2026-02-21 00:00:00 | 2026-03-21 00:00:00
[NAME] |  |  | 2500 | 104.17 |  |  | Monthly |  |  | 24 | 104.17 | 104.17 | 0 | 104.17 | 0
[NAME] |  |  | 2000 | 83.33 |  |  |  |  |  | 24 | 0 | 83.33 | 83.33 | 83.33 | 83.33
[NAME] |  |  | 1500 | 62.5 |  |  |  |  |  | 24 | 62.5 | 62.5 | 62.5 | 62.5 | 62.5
[NAME] |  |  | 2400 | 100 |  |  |  |  |  | 24 | 0 | 0 | 100 | 0 | 100
Spreadsheet: 676689d1588936894-linking-two-cells-to-return-values-in-columns-2312-daily-production-report
Sheet: 2nd Shift

2nd Shift
Department | Machine | Issues | Action | Downtime | Date | Week
2312 | [NAME] | Spindle | Maintenance working on issue | 36 | 2020-04-22 00:00:00
2312 | [NAME] | Spindle | Maintenance working on issue | 18 | 2020-04-23 00:00:00
2312 | [NAME] | Spindle | Maintenance working on issue | 18 | 2020-04-25 00:00:00
Spreadsheet: richard_ring__31662__GSA Renewables for FY 2001
Sheet: Sheet2

 | kWh |  |  |  | Price
 | Tier 1 | [NAME] | Totals |  | Tier 1 | [NAME] | Totals
Month |  |  |  |  | 0.055 | 0.0525
October | 100000 | 300000
November | 100000 | 300000
December | 100000 | 300000
January | 175000 | 225000
February | 175000 | 225000
March | 175000 | 225000
April | 175000 | 225000
May | 175000 | 225000
June | 175000 | 225000
July | 175000 | 225000
August | 175000 | 225000
September | 175000 | 225000
Totals:
Spreadsheet: 883304d1731899455-formula-to-find-the-total-of-stock-according-to-date-stock-control
Sheet: Tom

Date | Stock | Quantity | Price | Total
2024-11-07 00:00:00 | Coffee | 2
2024-11-08 00:00:00 | Sugar | 6
2024-11-14 00:00:00 | Milk | 1
Spreadsheet: 886181d1736211045-sum-from-multiple-sheets-with-multiple-names-on-totals-sheet-based-on-name-and-column-sample-loans-spreadsheet-for-excel-forum
Sheet: Sample Oct 24

2024-10-01 00:00:00
CUSTOMER NAME | DATE CLOSED | LOAN AMOUNT | NEW MONEY | LOAN FEE | EVAL FEE | FEE ACTUALLY COLLECTED | LOAN OFFICER
 | 2024-10-01 00:00:00 | 10000 | 10000 | 75 |  | 75 | NAME FOUR
 | 2024-10-01 00:00:00 | 2500 | 2500 | 75 |  | 75 | NAME FOUR
 | 2024-10-04 00:00:00 | 15000 | 15000 | 75 |  | 75 | NAME THREE
 | 2024-10-09 00:00:00 | 35000 | 35000 | 150 | 50 | 150 | NAME TWO
 | 2024-10-16 00:00:00 | 5000 | 5000 | 50 |  | 50 | NAME ONE
Total Monthly Loans
Year to Date | 5
 |  |  |  | EM
Spreadsheet: 732949d1621334883-highlight-duplicate-text-in-multiple-columns-p_tracker
Sheet: DSP_Natural_Resources___New_Ene

Tata Steel Ltd
Jindal Steel & Power Ltd
Hindalco Industries Ltd Shs Dematerialised
Hindustan Zinc Ltd
Steel Authority Of India Ltd Shs Dematerialised
Reliance Industries Ltd Shs Dematerialised
JSW Steel Ltd
Petronet LNG Ltd
Gujarat State Petronet Ltd Shs Dematerialised
NMDC Ltd
[NAME] (India) Ltd
Bharat Petroleum Corp Ltd
Indian Oil Corp Ltd
Hindustan Petroleum Corp Ltd
National Aluminium Co Ltd
Indraprastha Gas Ltd
Oil & Natural Gas Corp Ltd
Triveni Engineering & Industries Ltd
Gujarat Gas Ltd
Reliance Industries Limited - Partly Paid Shares
Spreadsheet: 81444d1281620078-sumif-need-update-formula-pivot-table-revised-first-solution
Sheet: Hárok1

NAME | DATE | POINTS(OWN) | POINTS(SHARED) | ACTUAL FROM ONE | TeamMate | Solution
[NAME] | 2010-01-21 00:00:00 |  |  | 10294 | [NAME]
[NAME] | 2009-11-09 00:00:00 |  |  | 1934
[NAME] | 2010-01-01 00:00:00 |  |  | 3934
[NAME] | 2010-01-21 00:00:00 |  |  | 29323 | [NAME]
[NAME] | 2010-11-03 00:00:00 |  |  | 2492
[NAME] | 2009-12-15 00:00:00 |  |  | 2944
TeamMate | (All)
 | Values
Row Labels | Sum of POINTS(OWN) | Sum of POINTS(SHARED) | Sum of ACTUAL FROM ONE | Sum of Solution
2009-11-09 00:00:00 | 1934 | 15730 | 1934 | 1934
2009-12-15 00:00:00 | 15730 | 29323 | 2944 | 45053
2010-01-01 00:00:00 | 3934 | 0 | 3934 | 3934
2010-01-21 00:00:00 | 45053 | 29323 | 39617 | 74376
2010-11-03 00:00:00 | 15730 | 29323 | 2492 | 45053
Grand Total | 82381 | 103699 | 50921 | 170350
Spreadsheet: 109692d1306479854-finding-the-minimum-value-findminimum
Sheet: Sheet1

 |  |  |  |  |  | formula at the end of count row
 | Count | Price |  | Find Minimum value for each "count"
 | 1 | 244.4
 | 1 | 251
 | 1 | 252.2
 | 1 | 248
 | 1 | 250 |  | 244.4
 | 2 | 251
 | 2 | 247
 | 2 | 249.2
 | 2 | 249.8 |  | 247
 | 3 | 251.8
 | 3 | 253
 | 3 | 251.6 |  | 251.6 |  | MIN(INDEX($c$4:$c82,MATCH(MAX($b$4:$b82),$b$4:$b82,0)))
Spreadsheet: 202539d1356625009-totaling-quatnities-with-drop-down-list-cable-group
Sheet: Sheet1

Monday |  |  |  |  |  | Tuesday |  |  |  |  |  | Wednesday |  |  |  |  |  |  | Thursday |  |  |  |  |  | Friday |  |  |  |  |  | 2012-12-31 00:00:00 | 4 sensor 10' | 4 sensor 15' | 4 sensor 20' | 4 sensor 25' | 4 sensor 30' | 4 sensor 40' | 4 sensor 50' | Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 Sensor | 3'
2012-12-31 00:00:00 | Cable Type | Length | Qty | Notes |  | 2013-01-01 00:00:00 | Cable Type | Length | Qty | Notes |  | 2013-01-02 00:00:00 | Cable Type | Length | Qty | Notes |  |  | 2013-01-03 00:00:00 | Cable Type | Length | Qty | Notes |  | 2013-01-04 00:00:00 | Cable Type | Length | Qty | Notes |  | [NAME] |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 Sensor | 5'
[NAME] | 4 Sensor | 15' | 10 |  |  | [NAME] | 5 DIN | 25' | 10 |  |  | [NAME] | 13 DIN | 20' | 20 |  |  |  | [NAME] | 8 Sensor | 10' | 30 |  |  | [NAME] | 4 Sensor | 30' | 10 |  |  |  | 8 sensor 10' | 8 sensor 15' | 8 sensor 20' | 8 sensor 25' | 8 sensor 30' | 8 sensor 40' | 8 sensor 50' | Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 DIN | 10'
 | 4 Sensor | 20' | 10 |  |  |  | 8 DIN | 25' | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 DIN | 15'
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 din 10' | 5 din 15' | 5 din 20' | 5 din 25' | 5 din 30' | 5 din 40' | 5 din 50' | Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13 DIN | 20'
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25'
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 din 10' | 8 din 15' | 8 din 20' | 8 din 25' | 8 din 30' | 8 din 40' | 8 din 50' | Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30'
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40'
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13 din 10' | 13 din 15' | 13 din 20' | 13 din 25' | 13 din 30' | 13 din 40' | 13 din 50' | Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50'
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: 709026d1608134118-collating-data-in-a-table-into-smaller-groups-example-spreadsheet-with-fake-headings-and-data
Sheet: Sheet1

Original |  |  |  |  |  | Desired
How often do you buy video games
 |  | Frequency | Percent | [NAME] |  |  |  | Frequency
Valid | Daily: once per day | 4 | 0 | 0 |  | Valid | Daily | 9
 | Daily: twice per day | 5 | 0 | 0 |  |  | Monhtly | 12
 | Less than monthly | 1 | 0 | 0 |  |  | Weekly | 5
 | Monthly: four times a month or more often | 2 | 0 | 0 |  |  | Seldom | 3
 | Monthly: once a month | 4 | 0 | 27.82608695652174
 | Monthly: three times a month | 2 | 0 | 0
 | Monthly: twice a month | 4 | 0 | 0
 | Seldom or not at all | 2 | 0 | 0
 | Weekly: once per week | 1 | 0 | 0
 | Weekly: three times per week | 3 | 0 | 0
 | Weekly: twice per week | 1 | 0 | 0
 | Total |  | 0 | 0
Missing |  | 0 | 0
Total |  | 0 | 0
Spreadsheet: 90375d1290109793-if-and-vlookup-book1_n1
Sheet: Sheet2

Works No | Name | Monday | Tuesday | Wednesday | Thursday | Friday
668 | [NAME] | 07:00:04 | 07:00:04
832 | [NAME] | 07:27:33 | 07:27:33
838 | [NAME] | 10:58:58 | 10:58:58 | 11:58:58 | 12:58:58 | 13:58:58
350 | [NAME] |  | 10:59:57
351 | [NAME] |  | 14:53:55
352 | [NAME] |  | 10:00:19
Spreadsheet: dan_hyvl__4727__South Jersey Resources Master Phys 04022001
Sheet: AMASTPSA 

MASTER FIRM PURCHASE/SALE AGREEMENT INFORMATION SHEET
ENA Entity: | ENA | ATTORNEY:
DATE: | 2001-04-02 00:00:00 | ENA CONTACT:
COUNTERPARTY: | South Jersey Resources Group, LLC | CONTACT:
ADDRESS: | 1 South Jersey Plaza | TITLE:
 | Folsom, New Jersey 08037 | PHONE: | (609) 561-9000
 |  | FAX:
INCORPORATION STATE: |  | S&P RATING:
STRUCTURE | COUNTERPARTY | ENA ENTITY
COLLATERAL
THRESHOLD  in $ | 6000000 | 25000000
COMMITTED VOLUMES
THRESHOLD in $[NAME] | N/A | N/A
COLLATERAL REQUIRED FOR:
ALL TRADES
OTHER | N/A | N/A
COLLATERAL TYPE
Letter of Credit | OK | OK
Cash | OK | OK
COLLATERAL  MULTIPLE | 250000 | 250000
GUARANTOR (RATING) | South Jersey Industries, Inc. | Enron Corp. (BBB+)
LIMIT in $[NAME] | 7000000 | 30000000
Incorporation State: | NJ | OR
MATERIAL ADVERSE CHANGE TRIGGERS  APPLY TO:
-Counterparty
-Guarantor | X | X
Debt Ratings Change |  | X
-Below = |  | BBB- | Standard & Poor's
Financial Covenants | X
-Funded Debt/Net Worth | > 2:1
-Minimum Net worth
-EBITDA/Interest | < 3:1
-Current Ratio
Non-Specific
-Unilateral
Ownership Change
-Less than 51% owned by:
Non-Standard Definitions
-Funded Debt
-Net Worth
-Cash Flow
EVENTS OF DEFAULT
3rd party debt | X | X
-Counterparty | 5000000
-Guarantor ($[NAME]) |  | 100000000
FIN'L STATEMENTS
-Standard | X | X | Upon request
CREDIT DECISION: | APPROVED:  X | DECLINED:
OUTSTANDING PHYSICAL TRADES: |  | YES:    X | NO:
ALL TRADES TO ROLL UP UNDER NEW MASTER: |  | YES:    X | NO:
OTHER COMMENTS | 1.  Execution of Master agreement subject to increase in, and extension of, current guaranty from
 | South Jersey Industries, Inc.  Current guaranty of $5 MM expires 11/30/01.
CREDIT REVIEW  PREPARED BY: |  | [NAME] | Ext. 53923
Spreadsheet: 118310d1313598803-matching-test
Sheet: CY11 Q3

Date | Last Name | Location
2011-07-18 00:00:00 | [NAME] | Alaska
2011-07-18 00:00:00 | [NAME] | Georgia
2011-07-18 00:00:00 | KHAMSOUK ARAHATE | Colorado
2011-07-18 00:00:00 | MONTGOMERY ANDRE | Colorado
2011-07-18 00:00:00 | SCOTT CARLTON | New York
2011-07-18 00:00:00 | [NAME] | California
2011-07-18 00:00:00 | [NAME] | Florida
2011-07-19 00:00:00 | [NAME] | New Mexico
2011-07-19 00:00:00 | BRANDON HILL | California
2011-07-20 00:00:00 | MONTGOMERY ANDRE | Missouri
2011-07-20 00:00:00 | [NAME] | Alaska
2011-07-20 00:00:00 | [NAME]
2011-07-20 00:00:00 | JUSTIN SPENCER
2011-07-20 00:00:00 | [NAME]
2011-07-20 00:00:00 | [NAME]
2011-08-10 00:00:00 | LYNCH JAMES
2011-07-25 00:00:00 | MARKWOOD CHRISTOPHER M
2011-07-25 00:00:00 | BRENNAN STEPHANIE A
2011-07-25 00:00:00 | BRANDON HILL | California
2011-07-25 00:00:00 | FITZPATRICK [NAME]
2011-07-25 00:00:00 | SCHULTZ ERIC E
2011-07-25 00:00:00 | MCCARTY STEPHEN
2011-07-25 00:00:00 | TYRONE LOVETTE
2011-07-25 00:00:00 | TROY DELACY
2011-07-25 00:00:00 | RYAN EDWIN
2011-07-26 00:00:00 | JUSTIN RYAN
2011-07-26 00:00:00 | JUSTIN RYAN
2011-07-26 00:00:00 | JEREMY [NAME]
2011-07-26 00:00:00 | MCCARTY STEPHEN
2011-07-27 00:00:00 | TYRONE LOVETTE
2011-07-27 00:00:00 | BRITTANNY NOELLE
2011-07-27 00:00:00 | BRITTANNY NOELLE
2011-07-27 00:00:00 | BRITTANNY NOELLE
2011-08-04 00:00:00 | MEEHAN LYNN
2011-08-04 00:00:00 | [NAME]
2011-08-08 00:00:00 | JUSTIN SPENCER
2011-08-08 00:00:00 | [NAME]
2011-08-08 00:00:00 | [NAME]
2011-08-08 00:00:00 | FITZPATRICK [NAME]
2011-08-08 00:00:00 | SCHULTZ ERIC E
2011-08-08 00:00:00 | MCCARTY STEPHEN
2011-08-09 00:00:00 | TYRONE LOVETTE
2011-08-09 00:00:00 | TROY DELACY
Spreadsheet: 148669d1333498771-sumproduct-formula-issue-sumproduct-formula-issue
Sheet: Sheet1

 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 |  | Week 1 | Week 2 | Week 3 | Week 4 | Week 5
JAN | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -4810 | -24050 | -21645 | -7215 | 0 | 0 | 0 | 0 | 0 | -2405 | -4810 | -14430 | 0 | 0 | 0 | 0 |  | 0 | 0 | -57720 | -21645 | 0
FEB |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0
MAR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0
APR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0
MAY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0
JULY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0
AUG |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0
SEP |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0
OCT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0
NOV |  |  | Manual Entry |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0
DEC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0
FJW
Total Pieces Ordered | 8696 | 7000 | 6000 | 5000 | 4000 | 3000 | 2000 | 1000 | 0 | -1000 | -2000 | -3000 | -4000 | -5000 | -6000 | -7000 | -8000 | -9000 | -10000 | -11000 | -12000 | -13000 | -14000 | -15000 | -16000 | -17000 | -18000 | -19000 | -20000 | -21000 | -22000
Total Pieces W/Errors | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -4810 | -24050 | -21645 | -7215 | 0 | 0 | 0 | 0 | 0 | -2405 | -4810 | -14430 | 0 | 0 | 0 | 0
Picking Accuracy | 1
Spreadsheet: 722751d1615392892-formula-fails-to-copy-correctly-colleen-boys-example
Sheet: Weekly

Name | 2021-01-01 00:00:00
Spreadsheet: 864671d1711753822-question-on-date-range-based-cell-populating-food-safety-walk
Sheet: Market

 |  |  |  |  | Department: | Market Grille/Mia Italian
 |  |  |  |  | Walk Date:
 |  |  |  |  | Auditor:
 |  |  |  |  | Auditor Role:
Market Guard
Question 1: | What is the Market Guard Completion for the Previous Day?
Question 2: | What is the MTD Completion for the Store?
General |  |  |  |  |  |  | Results
1 | Are there any products with missing labels? If so, note quantity. |  |  |  |  |  | P
 | Notes:
2 | Are there any products with incomplete labels? If so, note quantity. |  |  |  |  |  | P
 | Notes:
3 | Are there any expired items? |  |  |  |  |  | P
 | Notes:
4 | Are items stored in the cooler/freezer according to the storage hierarchy? |  |  |  |  |  | F
 | Notes:
5 | Is there any evidence of food/drink usage in the department? |  |  |  |  |  | P
 | Notes:
Cleaning |  |  |  |  |  |  | Results
6 | Do the customer facing displays have aged food debris? |  |  |  |  |  | P
 | Notes:
7 | Are the display door tracks clean? |  |  |  |  |  | P
 | Notes:
8 | Are the hand washing sinks blocked? |  |  |  |  |  | F
 | Notes:
9 | Is there any evidence of the hand washing sinks being used for anything other than hand washing? |  |  |  |  |  | P
 | Notes:
10 | Are the appliance control panels and handles clean? |  |  |  |  |  | P
 | Notes:
11 | Are the cooler/freezer door handles clean? |  |  |  |  |  | P
 | Notes:
12 | Are the hood grates clean? |  |  |  |  |  | F
 | Notes:
13 | Are the walls clean of built up food splatter? |  |  |  |  |  | P
 | Notes:
14 | Are the floors around coolers/equipment clean? |  |  |  |  |  | N
 | Notes:
Supplies/Chemicals |  |  |  |  |  |  | Results
15 | Are there any unauthorized chemicals? |  |  |  |  |  | F
 | Notes:
16 | Are the chemicals mixed correctly?  IE, too dark or light? |  |  |  |  |  | F
 | Notes:
17 | Are the sanitizer strips expired? |  |  |  |  |  | F
 | Notes:
18 | Is the paper towel dispenser stocked and functional at each hand washing sink? |  |  |  |  |  | F
 | Notes:
19 | Are gloves stocked and easily accessible? |  |  |  |  |  | F
 | Notes:
Misc Notes
Spreadsheet: 143768d1330553151-excel-2007-help-combining-vlookup-match-indirect-etc-vlookup-example
Sheet: Allocation

Sales # | Customer | Location | Description | Manager | Division | Alloc | Date Added
111 | x | y | z | [NAME] | East | 0.2 | 2012-01-01 00:00:00
111 | x | y | z | [NAME] | West | 0.3 | 2012-01-01 00:00:00
111 | x | y | z | [NAME] | North | 0.5 | 2012-01-01 00:00:00
222 | a | b | c | [NAME] | East | 1
333 | d | e | f | [NAME] | East | 0.5
333 | d | e | f | [NAME] | West | 0.5
111 | x | y | z | [NAME] | East | 0.4 | 2012-03-01 00:00:00
111 | x | y | z | [NAME] | West | 0.6 | 2012-03-01 00:00:00