tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 778542d1651148352-format-cells-if-conditions-are-met-from-a-range-of-cells-cf-find-in-range-aligw
Sheet: Sheet1

 |  | Range to be Highlighted any colour |  |  |  |  | if |  | Condition | If value is within this range
 |  | 314 |  | ISERROR(VLOOKUP(C5,$J$5:$J$22,1,0))=FALSE |  |  |  |  | 222 |  | Condition is range of cells from J5 to J22
 |  | 869 |  |  |  |  |  |  | 225
 |  | 182 |  |  |  |  |  |  | 252
 |  | 295 |  |  |  |  |  |  | 555
 |  | 425 |  |  |  |  |  |  | 552
 |  | 647 |  |  |  |  |  |  | 525
 |  | 758 |  |  |  |  |  |  | 955 |  |  | How to write conditional formula if the condition is not a single cell but
 |  | 959 |  |  |  |  |  |  | 995 |  |  | a range of cells containing values
 |  | 536 |  |  |  |  |  |  | 959 |  |  | J5 to J22
 |  | 374 |  |  |  |  |  |  | 599
 |  | 839 |  |  |  |  |  |  | 595 |  |  | IF C5 to C22 is any of J5 to J22 then highlight the cell in range C5 to C22
 |  | 225 |  |  |  |  |  |  | 255
 |  | 263 |  |  |  |  |  |  | 295
 |  | 485 |  |  |  |  |  |  | 259
 |  | 617 |  |  |  |  |  |  | 925
 |  | 222 |  |  |  |  |  |  | 952
 |  | 941 |  |  |  |  |  |  | 529
 |  | 596 |  |  |  |  |  |  | 592
 |  | If formula works the following cells in column C will be highlighted
 |  | C8,  C12,  C16  &  C20
Spreadsheet: 740163d1626204769-countif-not-working-with-true-criterion-rush-detailed-cs-schedule-sample
Sheet: Agent work weeks

CountIf Formula Issue
Phones | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |  |  | Agent | Shift |  | [NAME] | Lunch End | Break 1 | Break 2
 |  |  |  |  |  |  |  |  |  |  | 8:00a | 4:30p
 |  |  |  |  |  |  |  |  |  |  | 8:00a | 4:30p
 |  |  |  |  |  |  |  |  |  |  | 8:30a | 5:00p
 |  |  |  |  |  |  |  |  |  |  | 8:30a | 5:00p
 |  |  |  |  |  |  |  |  |  |  | 9:00a | 5:30p
 |  |  |  |  |  |  |  |  |  |  | 9:00a | 5:30p
 |  |  |  |  |  |  |  |  |  |  | 9:30a | 6:00p
 |  |  |  |  |  |  |  |  |  |  | 9:30a | 6:00p
 |  |  |  |  |  |  |  |  |  |  | 1:30p | 10:00p
 |  |  |  |  |  |  |  |  |  |  | 1:30p | 10:00p
 |  |  |  |  |  |  |  |  |  |  | 1:30p | 10:00p
 |  |  |  |  |  |  |  |  |  |  | 8:00a | 4:30p
 |  |  |  |  |  |  |  |  |  |  | 1:30p | 10:00p
 |  |  |  |  |  |  |  |  |  |  | 8:00a | 4:30p
 |  |  |  |  |  |  |  |  |  |  | 1:30p | 10:00p
# of agents staffed |  |  |  |  |  |  |  |  | # of FTE agents
# of hours worked
Spreadsheet: 217176d1361998383-find-add-and-return-values-from-multiple-worksheets-time-spent-on-course
Sheet: Sheet2

Name | Course A | Time spent | Course B | Time spent | Course C | Time spent | Course D | Time spent | Course E | Time spent | Course F | Time spent
Adam | English | 1 | Maths | 3 | Science | 4
Eve | Maths | 2 | Geography | 1 | Science | 2
[NAME] | Maths | 3 | Geography | 1 | History | 2
Spreadsheet: 585907d1534070864-time-vlookup-error-rad
Sheet: Sheet2

 | Radio pharmaceutical |  | Radio Nuclide |  | Staff
 | Tc99m HDP |  | Tc99m |  | Zblank
 | Tc99m MAA |  | Kr81 Rb81 Rb82 |  | Zblank
 | Tc99m [NAME] |  |  |  | Zblank
 | Tc99m [NAME] |  |  |  | Zblank
 | Tc99m Nanoscan |  |  |  | Zblank
 | Tc99m DMSA |  |  |  | Zblank
 | Kr81 Gas Generator |  |  |  | Zblank
 | Tc99m [NAME] |  |  |  | Zblank
 |  |  |  |  | Zblank
 |  |  |  |  | Zblank
 |  |  |  |  | Zblank
 |  |  |  |  | Zblank
 |  |  |  |  | Zblank
 |  |  |  |  | Zblank
 |  |  |  |  | Zblank
 |  |  |  |  | Zblank
 |  |  |  |  | Zblank
 |  |  |  |  | Zblank
 |  |  |  |  | Zblank
 |  |  |  |  | Zblank
 |  |  |  |  | Zblank
 |  |  |  |  | Zblank
 |  |  |  |  | Zblank
 |  |  |  |  | Zblank
 |  |  |  |  | Zblank
 |  |  |  |  | Zblank
 |  |  |  |  | Zblank
 |  |  |  |  | Zblank
 |  |  |  |  | Zblank
 |  |  |  |  | Zblank
 |  |  |  |  | Zblank
 |  |  |  |  | Zblank
 |  |  |  |  | Zblank
 |  |  |  |  | Zblank
 |  |  |  |  | Zblank
 |  |  |  |  | Zblank
 |  |  |  |  | Zblank
 |  |  |  |  | Zblank
 |  |  |  |  | Zblank
 |  |  |  |  | Zblank
 |  |  |  |  | Zblank
 |  |  |  |  | Zblank
 |  |  |  |  | Zblank
Spreadsheet: 469203d1467817429-3-worksheets-input-into-1-worksheet-change-log-1
Sheet: RS (2)

DESIGNER | PROJECT | DATE RECEIVED | DATE RESPONSE REQUIRED | [NAME]
Spreadsheet: 74433d1274943601-matching-numbers-color-text-copy-of-example
Sheet: Sheet1

Raw Data |  |  |  |  | What I'm looking for
Truck | [NAME] |  | [NAME] |  | Truck | [NAME] |  | [NAME]
1111 | 6666 |  | 2222 |  | 1111 | 6666 |  | 2222
 |  |  | 6666 |  |  |  |  | 6666
2222 |  |  | 7777 |  | 2222 |  |  | 7777
3333 |  |  |  |  | 3333
4444 |  |  |  |  | 4444
5555 |  |  |  |  | 5555
So in the "What I'm looking for section". I need I4 to look F4:[NAME] and if it finds that exact number and there is no data in the cell directly to the right then text the number red. I need some sort of notification to let me know the truck is there without an alternate truck because it is broken. I also need it to look at G4:G10 and color the text in I4 red if that same truck is anywhere in what column. Basically we type in a truck number when it is broken in the broken truck column. I need the sheet to make sure if that same truck is in the truck columnn then it must have an alt truck (Any number) so we know it is being switched out. I also need it to look at the Alt truck column to make sure we haven't used the [NAME] truck for the Alt truck. I hope this explains it. If you can't get the text to change color then I would need some sort of notification saying there is an issue with the broken truck number entered in the broken truck column.
Spreadsheet: 839339d1691851496-calendar-with-recurring-weekly-events-demand-gen-enterprise-campaign-calendar_test-yogabbagabba-
Sheet: Calendar

Demand Gen Enterprise Campaign Calendar
Month: | 2023-02-01 00:00:00
Spreadsheet: 697449d1601368609-need-forumula-to-get-dept-total-test-data
Sheet: DEPT

# | ID | Account No: | MANAGER | TEST1 | DEPT TOTAL
4 | Q8CLCH | PSS38 | COMPANY-1 | DEPT1 | 400
4 | Q8CLCH | PSS38 | COMPANY-1 | DEPT2 | 500
4 | Q8CLCH | PSS38 | COMPANY-1 | DEPT3 | 700
5 | Q8MANU | PSS76 | COMPANY-2 | DEPT1 | 234
5 | Q8MANU | PSS76 | COMPANY-2 | DEPT2 | 500
5 | Q8MANU | PSS76 | COMPANY-2 | DEPT3 | 450
7 | Q8TCW | PSS83 | COMPANY-3 | DEPT1 | 567
7 | Q8TCW | PSS83 | COMPANY-3 | DEPT2 | 678
7 | Q8TCW | PSS83 | COMPANY-3 | DEPT3 | 987
Spreadsheet: 103260d1301014108-list-to-table-test
Sheet: Sheet1

U22 |  |  |  |  |  |  | U22 | F04 | U21 | T01 | P25 | S06 | A85 | U24 | U11 | [NAME] | W01 | X15
F04 |  |  |  |  |  | U22 |  |  |  | 1 |  |  |  |  | 1
U21 | U24 |  |  |  |  | F04 |  | 1
T01 |  |  |  |  |  | U21 |  |  | 3 | 1 |  |  |  | 1 |  |  | 1
P25 |  |  |  |  |  | T01 |  |  |  | 3 |  |  |  |  | 1 |  | 1
S06 |  |  |  |  |  | P25 |  |  |  |  | 1
T01 | U21 | W01 |  |  |  | S06 |  |  |  |  |  | 1
U21 |  |  |  |  |  | A85 |  |  |  |  |  |  | 1 |  | 1 | 1 |  | 1
T01 | U11 | U22 |  |  |  | U24 |  |  |  |  |  |  |  | 1
A85 | [NAME] | U11 | X15 |  |  | U11 |  |  |  |  |  |  |  |  | 2 | 1 |  | 1
 |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | 1 |  | 1
 |  |  |  |  |  | W01 |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  | X15 |  |  |  |  |  |  |  |  |  |  |  | 1
Spreadsheet: 136374d1326582144-how-to-update-formula-to-include-end_date-mem_pay_test
Sheet: Sheet1

 |  |  |  |  | Starting | 2012-01-07 00:00:00
 |  |  |  |  | Ending
 |  |  |  |  | $/Week | 2
 |  |  |  |  | As At
Name | Membership No | Owing | Paid | 7-Jan-12 | 14-Jan-12 | 21-Jan-12 | 28-Jan-12 | 4-Feb-12 | 11-Feb-12 | 18-Feb-12 | 25-Feb-12 | 3-Mar-12 | 10-Mar-12 | 17-Mar-12 | 24-Mar-12 | 31-Mar-12 | 7-Apr-12 | 14-Apr-12 | 21-Apr-12 | 28-Apr-12 | 5-May-12 | 12-May-12 | 19-May-12 | 26-May-12 | 2-Jun-12 | 9-Jun-12 | 16-Jun-12 | 23-Jun-12 | 30-Jun-12 | 7-Jul-12 | 14-Jul-12 | 21-Jul-12 | 28-Jul-12 | 4-Aug-12 | 11-Aug-12 | 18-Aug-12 | 25-Aug-12 | 1-Sep-12 | 8-Sep-12 | 15-Sep-12 | 22-Sep-12 | 29-Sep-12 | 6-Oct-12 | 13-Oct-12 | 20-Oct-12 | 27-Oct-12 | 3-Nov-12 | 10-Nov-12 | 17-Nov-12 | 24-Nov-12 | 1-Dec-12 | 8-Dec-12 | 15-Dec-12 | 22-Dec-12 | 29-Dec-12
[NAME] | 101 |  |  | 2
[NAME] | 102
[NAME] | 103
[NAME] | 104 |  |  |  |  | 2
 | 105
Spreadsheet: 124776d1318604571-help-on-formulas-to-refer-to-previous-sheet-when-i-copy-it-example
Sheet: Day 3

 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
MORNING REPORT
COMPLETION / WORKOVER/ WELL SERVICE
Field |  |  | PERFORATIONS |  |  |  | WELL NAME:
CTY / ST |  |  | _________________________ |  |  |  | AFE
TD |  |  | _________________________
PBTD |  |  | _________________________
RIG |  |  | _________________________
 |  |  |  |  |  | REPORT BY |  |  |  | DATE
OBJECTIVE |  |  | NUM. OF DAYS |  | 3
TIME LOG |  | DETAILS OF OPERATIONS
FROM | TO
DAILY COST RECORD
VENDOR |  |  | ITEM/GL CODE |  | Daily Cost |  | CUM COST | REMARKS
#N/A |  |  | 00120 |  |  |  | 65
0 |  |  | 0 |  |  |  | 0
0 |  |  | 0 |  |  |  | 0
0 |  |  | 0 |  |  |  | 0
0 |  |  | 0 |  |  |  | 0
0 |  |  | 0 |  |  |  | 0
0 |  |  | 0 |  |  |  | 0
0 |  |  | 0 |  |  |  | 0
0 |  |  | 0 |  |  |  | 0
0 |  |  | 0 |  |  |  | 0
0 |  |  | 0 |  |  |  | 0
0 |  |  | 0 |  |  |  | 0
0 |  |  | 0 |  |  |  | 0
0 |  |  | 0 |  |  |  | 0
0 |  |  | 0 |  |  |  | 0
0 |  |  | 0 |  |  |  | 0
0 |  |  | 0 |  |  |  | 0
Total Daily Cost |  |  |  |  | 0
Previous Day Total |  |  |  |  | 65
Total Cumulative Cost |  |  |  |  | 65 |  | 65
Spreadsheet: 747037d1631195009-automatically-generate-number-code_sequence
Sheet: Sheet3

Austria | AT
Belgium | BE
Bulgaria | BG
Croatia | HR
Cyprus | CY
Czechia | CZ
Denmark | DK
Estonia | EE
Finland | FI
France | FR
Germany | DE
Greece | EL
Hungary | [NAME]
Ireland | IE
Italy | IT
Latvia | LV
Lithuania | LT
Luxembourg | LU
Malta | MT
Netherlands | NL
Poland | PL
Portugal | PT
Romania | RO
Slovakia | SK
Slovenia | SI
Spain | ES
Sweden | SE
Spreadsheet: 09ae7a7e-fc8e-4eba-b5c4-1e2036a9c697
Sheet: 4 - Travel Time Savings

ATTACHMENT 4:  Travel Time Savings
Level of Service Analysis
Source: Highway Capacity Manual 2000, Transportation Research Board
 | Percent Time-Spent-Following (%) | Level of Service | Average Travel Speed (mph) | Level of Service | Travel Time during the peak 15-minute period (veh-hr)
Without Project | 84.18 | E | 49.1 | C | 24.2
With Project | 81.28 | E | 49.8 | C | 23.9
Decrease/Increase |  | - |  | -
 |  |  | Travel Time Savings (veh-hr)
Note: LOS Criteria for Two-Lane Highways in Class I per Exhibit 20-2, Highway Capacity Manual 2000
Average travel time saved calculated for peak 15-minute period per Chapter 20 - Two lane Highways, Highway Capacity Manual 2000.  Assuming a base free flow speed of 65 miles per hour and using vehicular traffic counts taken by the Contra Costa County Public Works Department on Vasco Road - 1 mile South of Camino Diablo on August 5, 2009.
Spreadsheet: 472726d1469717006-employee-attendance-tracker-viewing-all-together-on-a-year-calendar-copy-of-employee-attendance-tracker1
Sheet: Employee Leave Tracker

 | Employee Name | Start Date | End Date | Type of Leave | Days | Month | Year
 | Employee 1 | 2030-01-03 00:00:00 | 2031-01-03 00:00:00 | [NAME]
 | Employee 2 | 2012-01-17 00:00:00 | 2012-01-18 00:00:00 | Other
 | Employee 1 | 2012-01-18 00:00:00 | 2012-01-21 00:00:00 | Other
 | Employee 3 | 2011-12-10 00:00:00 | 2011-12-16 00:00:00 | Bereavement
 | Employee 4 | 2011-12-01 00:00:00 | 2011-12-02 00:00:00 | [NAME]
 | Employee 1 | 2011-11-14 00:00:00 | 2011-11-18 00:00:00 | Vacation
 | Employee 4 | 2012-01-31 00:00:00 | 2012-02-04 00:00:00 | [NAME]
 | Employee 4 | 2011-12-01 00:00:00 | 2011-12-06 00:00:00 | Other
 | Employee 4 | 2011-12-10 00:00:00 | 2011-12-16 00:00:00 | Other
 | Employee 2 | 2012-01-13 00:00:00 | 2012-01-15 00:00:00 | [NAME]
 | Employee 5 | 2016-01-15 00:00:00 | 2016-01-20 00:00:00 | Study/Workshop
 | Employee 2 | 2012-06-13 00:00:00 | 2012-06-15 00:00:00 | Bereavement
 | Employee 5 | 2012-01-27 00:00:00 | 2012-02-03 00:00:00 | Bereavement
 | Employee 3 | 2012-01-17 00:00:00 | 2012-01-18 00:00:00 | Vacation
 | Employee 3 | 2011-12-12 00:00:00 | 2011-12-17 00:00:00 | Bereavement
 | Employee 1 | 2011-12-21 00:00:00 | 2011-12-22 00:00:00 | Other
 | Employee 1 | 2011-12-14 00:00:00 | 2011-12-16 00:00:00 | Vacation
 | Employee 2 | 2011-11-29 00:00:00 | 2011-12-06 00:00:00 | Bereavement
 | Employee 5 | 2011-12-03 00:00:00 | 2011-12-07 00:00:00 | Vacation
 | Employee 1 | 2012-01-31 00:00:00 | 2012-02-02 00:00:00 | Bereavement
 | Employee 1 | 2011-11-24 00:00:00 | 2011-11-29 00:00:00 | [NAME]
 | Employee 2 | 2012-12-05 00:00:00 | 2012-12-09 00:00:00 | Vacation
 | Employee 5 | 2012-04-11 00:00:00 | 2012-04-19 00:00:00 | Vacation
Spreadsheet: 31433d1227266659-multiple-results-in-sheet-1-one-complex-formula-in-sheet-2-example2
Sheet: Sheet1

 | Dataset1 | Dataset2 | Dataset3 | Dataset4 | Dataset5
Variable 1 | 123 | 456 | 789 | 234 | 567
Variable 2 | 234 | 567 | 890 | 345 | 678
Variable 3 | 345 | 678 | 901 | 456 | 789
 | Do some calculations based on Dataset1's variables 1,2,3 in Sheet2, and display result: | Still, sheet2 is referring to B2:B4, so the same result is printed here. This is not what I want: | Alternative solution, is to have a second copy of sheet2, which refers to [NAME]'s variables. This works, but then I would need one sheet for every dataset, and I have  900 of them..
Result | 30334.52569225068 | 30334.52569225068 | 260104.525646728 | 30334.52569225068 | 30334.52569225068
Spreadsheet: e812b4b8-87a6-4e31-952c-905dc2e955fc
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
EXHB | Test | EXHB | [NAME], DNA/RNA Extract and Hold, Blood | DNA and RNA, Extract and Hold, [NAME] | Nucleic Acid Extraction | Lavender-top (EDTA) Tube: EDTA |  |  | 4 | mL | [NAME] must arrive within 72 hours of draw.  Collection Container/Tube: Preferred: Lavender top (EDTA) Acceptable: ACD [NAME]: 4 mL Collection Instructions: 1. Invert several times to mix blood. 2. Send specimen in original tube. Additional Information: Date of draw is required. |  | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold reject Lipemia	NA Icterus	NA Other	Paraffin-embedded material | Not applicable | Monday through Friday Specimens received Saturday or Sunday will be processed on Monday. | 2 days | 5 days |  |  |  |  |  |  | Rochester
EXHB | [NAME] | BLOOD | Whole blood |  |  |  | Ambient | 72 hours
EXHB | Result | 60562 | DNA and RNA Extraction | DNA and RNA Extraction | Alphanumeric
Spreadsheet: 801877d1666448625-paye-tax-tax-calculations-working-
Sheet: Tax Calculations

Tax Calculations
I am trying to breakdown my payslip so I can manually calculate how much I will get paid from work every 4 weeks.  I work shifts so my income isn't fixed.  The calculation below is based on £1,828.10 this pay day, but in 4 weeks times, this amount will be £1,276.04.  The formula will need to calculate what I earn based on Hours Worked x Hourly Rate and then the relevant Pension, Tax and N.I deductions to give actual pay every 4 weeks.
Personal Allowance |  | 12639 |  | Reference The Salary Calculator |  |  |  | Yearly |  | Four Weekly |  | Daily
Tax Code |  | 1263L |  |  |  | Gross Income |  | 23765.3 |  | 1828.1 |  | 91.41
 |  |  |  |  |  | Pension Deductions |  | 1188.27 |  | 91.41 |  | 4.57
[NAME] |  | 10.1 |  |  |  | Taxable Income |  | 9947.03 |  | 765.16 |  | 38.26
Hours Worked |  | 181 |  |  |  | Tax |  | 1989.41 |  | 153.03 |  | 7.65
 |  |  |  |  |  | National Insurance |  | 1483.38 |  | 114.11 |  | 5.71
Name | Amount | [NAME] |  |  | Result |  | Notes
Income | 1828.1 |  |  |  |  | Income is [NAME] (181) x Hourly Rate (£10.10) = £1,828.10
Allowance | 972.24 |  |  |  |  | Allowance is Personal Allowance (£12,639) / 13 = £972.24
Pension | 91.41 |  |  |  |  | Pension is 5% of Income (£1,828.10) = £91.41
Taxable | 765.16
Tax | 153.03 |  |  |  |  | Tax is 20% of the Taxable amount (£765.16)
N.I | 113.96 |  |  |  |  | N.I is 0% of Income up to £968, and then 13.25% from £968 £1,828.10 (Income) - £968 (0%) = £860.10.  13.25% of £860.10 = £113.96.
Pay | 1469.55 |  |  |  |  | Pay is Income (£1,828.10) - Pension (£91.41) - Tax (£153.03) - N.I (£113.96) = £1,469.70
Spreadsheet: 791731d1660569396-pay-as-you-earn-calculation-paye-calculator-hansdouwe-3-
Sheet: Sheet1

Date of Birth | 1963-12-02 00:00:00 | 1942-04-08 00:00:00
Tax start period | 2021-07-01 00:00:00 | 2021-07-01 00:00:00
Tax end period | 2022-06-30 00:00:00 | 2022-06-30 00:00:00
Gross earnings | 123000 | 345000
Pension fund (Tax Deductible | 1755 | 1755
Taxable pay
Annual Tax rebate (not more than 60 years of ages | 8200 | 8200
Annual Tax rebate (more than 60 years of ages | 10900 | 10900
The rates of Income Tax applicable are as follows:
RATES OF NORMAL TAX FOR INDIVIDUALS
Exceeds | Does not exceed
Taxable Income |  |  |  | Rates |  |  |  |  |  |  |  | 121245 | 343245
 |  |  |  |  |  |  |  |  | Band Start | Rate
0 | 100000 | 0 | 0.2 | E0           +  20% of the excess of E0 00 |  |  |  |  | 0 | 0
100000 | 150000 | 20000 | 0.25 | E20 000 + 25% of the excess of E100 000 |  |  |  |  | 50000
150000 | 200000 | 32500 | 0.3 | E32 500 + 30% of the excess of E150 000 |  |  |  |  | 100000
200000 |  | 47500 | 0.33 | E47 500 + 33% of the excess of E200 000 |  |  |  |  | 150000
 |  |  |  |  |  |  |  |  | 200000
Manual Calculation
 | taxable pay | 121245 | 121245
Between 10000 and 15000 |  | 20000 | 20000
 | 0.25
 |  | 8200 | 10900
Tax Payable
Spreadsheet: 707515d1607331307-using-a-list-to-reduce-worksheets-midshires-master
Sheet: DG

 |  |  |  | ADJUSTED HANDICAP |  |  |  |  |  | OFFICIAL HANDICAP |  |  |  |  | HANDICAPPING ALTERATIONS
hole | par | S/I | SHOTS | CALC | points | PAR 3 | SI/1 | SI/2 | S1/3 | SI/1 | S1/2 | S1/3 | CALC | points | EXACT | catagory | BUFFER | css | Nett | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAP |  | ZONE |  | Differential
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out |  |  |  |  |  | TOTAL
total
Spreadsheet: 33535d1229992834-pivot-table-question-sample
Sheet: Pivot Table

[NAME] | (All)
Agent | Date | Count of Skill Set | Average
[NAME] |  | 24 | 24
 | 2008-11-05 00:00:00 | 20 | 20
 | 2008-11-06 00:00:00 | 4 | 4
[NAME] |  | 33 | 33
 | 2008-11-02 00:00:00 | 3 | 3
 | 2008-11-03 00:00:00 | 11 | 11
 | 2008-11-04 00:00:00 | 11 | 11
 | 2008-11-05 00:00:00 | 8 | 8
[NAME] |  | 13 | 13
 | 2008-11-03 00:00:00 | 3 | 3
 | 2008-11-05 00:00:00 | 2 | 2
 | 2008-11-06 00:00:00 | 8 | 8
[NAME] |  | 28 | 28
 | 2008-11-01 00:00:00 | 25 | 25
 | 2008-11-02 00:00:00 | 3 | 3
Grand Total |  | 98 | 98
Spreadsheet: f4d60877-0376-4cc0-a44c-1843e4ef7b43
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
VRID2 | Test | VRID2 | Culture Referred for Identification, Virus | Culture Referred for ID, Virus | Shell Vial Assay for Appropriate Virus and/or Tube Cell Culture | Infectious Container-Large (Supply T146) |  |  |  |  | [NAME]: Cell (viral) culture medium Specimen Volume: Isolate Collection Instructions: 1. Organism must be in pure culture, actively growing. 2. Place specimen in a large infectious container (Supply T146) and label as an etiologic agent. Additional Information: 1. Specimen source is required. 2. Isolate description is required: morphology, tests performed. 3. See Infectious Specimen Shipping Guidelines in Special Instructions for shipping information. |  | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	Agar plate | Not applicable | Monday through Sunday; Varies | 14 days/Positives are reported when detected | 14 days |  |  |  |  |  |  | Rochester
VRID2 | [NAME] | VARIES | Varies |  |  |  | Ambient
VRID2 | Order Question | Q00M0066 | [NAME]) and Isolate Description-Morphology, tests performed (Required) |  | Plain Text
VRID2 | Result | VRID2 | Culture Referred for ID, Virus | Culture Referred for ID, Virus | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6584-7 | Virus identified:Prid:Pt:[NAME]:Nom:Culture
Spreadsheet: 140059d1328612830-leading-space-in-a-cell-not-getting-removed-with-trim-function-north-east_report
Sheet: Sheet1

Sum of PO Line Amount Balance
Indent Item | Total
AN005001 | 0
AN005005 | 0
BS071102 | 0
BT031020 | 0
BT031021 | 0
BT032008 | 0
BT032009 | 0
BT036002 | 0
BT041009 | 0
BT041034 | 0
BT042009 | 0
BT042016 | 0
BT061012 | 0
BT062006 | 0
IF006001 | 0
IF006083 | 0
IF006335 | 0
IF006358 | 0
IF007016 | 0
IF007077 | 0
IF007324 | 0
IF007326 | 0
IF007329 | 0
IF007330 | 0
IF008342 | 0
MS013105 | 0
MS024202 | 0
MS041201 | 0
MW011086 | 0
MW011114 | 0
MW011115 | 0
MW015020 | 0
MW015021 | 0
MW015022 | 0
MW021073 | 0
MW021074 | 0
MW077037 | 0
NM021201 | 0
TE731026 | 0
Grand Total | 0
Spreadsheet: 723445d1615704962-list-of-products-for-selected-company-list-of-products-ans
Sheet: Sheet1

S.NO. | COMPANY NAME | PRODUCT | AVAILABILITY | PRODUCT | AVAILABILITY | PRODUCT | AVAILABILITY | PRODUCT | AVAILABILITY | PRODUCT | AVAILABILITY |  | PRODUCT | F
1 | A | HMS | YES | PNS | YES | STEEL SCRAP | NO | HBI | YES | REBAR | YES
2 | B |  |  |  |  | STEEL SCRAP | NO |  |  |  |  |  |  | LIST OF PRODUCTS
3 | C | HMS | YES |  |  |  |  |  |  | REBAR | YES
4 | D |  |  |  |  | STEEL SCRAP | NO
5 | E |  |  |  |  |  |  |  |  | REBAR | YES
6 | F | HMS | NO | PNS | YES
7 | G | HMS | NO |  |  | STEEL SCRAP | NO
8 | H |  |  | PNS | YES
9 | I |  |  |  |  |  |  |  |  | REBAR | YES
10 | J | HMS | YES | PNS | NO | STEEL SCRAP | YES
Spreadsheet: 878963d1726340811-formula-for-identifying-different-number-levels-wip-data-for-program-levels
Sheet: Sheet1

 | PRICE | Ext | [NAME] | Delta | Discount | Program? Example
 | 80.71 | 80.71 | 595 |  |  | Review |  | 0 | No Program | Column F >>>> | =IF(E2=0,"",CEILING.MATH(E2/D2,0.001))
 | 80.71 | 161.42 | 895 |  |  | Review |  | 0.025 | Silver Program
 | 100 | 500 | 300 |  |  | Review |  | 0.05 | Gold Program
 | 179.5 | 179.5 | 359 |  |  | Review |  | 0.1 | Platinum Program
 | 297.5 | 892.5 | 595 |  |  | Review |  | 0.15 | Review
 | 297.5 | 892.5 | 595 |  |  | Review
 | 312.38 | 1561.9 | 595 |  |  | Review
 | 355.5 | 711 | 359 |  |  | No Program
 | 397.5 | 397.5 | 895 |  |  | Review
 | 512.1 | 512.1 | 503 |  |  | No Program
 | 535.5 | 2142 | 595 |  |  | Platinum Program
 | 548.03125 | -548.03125 | 895 |  |  | Review
 | 565 | 3390 | 595 |  |  | Gold Program
 | 580.13 | 4060.91 | 595 |  |  | Silver Program
 | 580.13 | 6381.43 | 595 |  |  | Silver Program
 | 587.27 | 3523.62 | 595 |  |  | No Program
 | 590.6 | 590.6 | 503 |  |  | No Program
 | 593.51 | 5341.59 | 595 |  |  | No Program
 | 597.5 | 597.5 | 1295 |  |  | Review
 | 599 | -599 | 359 |  |  | No Program
 | 695 | 695 | 795 |  |  | Platinum Program
 | 715.5 | 5724 | 895 |  |  | Review
 | 715.5 | 28620 | 895 |  |  | Review
 | 755.25 | 3776.25 | 895 |  |  | Review
 | 795 | 1590 | 695 |  |  | No Program
 | 795 | 1590 | 895 |  |  | Platinum Program
 | 805.5 | 1611 | 895 |  |  | Platinum Program
 | 850.25 | 1700.5 | 795 |  |  | No Program
 | 850.25 | -850.25 | 995 |  |  | Platinum Program
 | 875 | 875 | 975 |  |  | Platinum Program
 | 877.5 | 5265 | 1075 |  |  | Review
 | 895 | 895 | 995 |  |  | Platinum Program
 | 901.88 | 7215.04 | 1075 |  |  | Review
 | 945.25 | -2835.75 | 975 |  |  | Silver Program
 | 1000 | -1000 | 595 |  |  | No Program
 | 1023.75 | 1023.75 | 1075 |  |  | Silver Program
 | 1090 | 2180 | 1095 |  |  | No Program
 | 1138 | 1138 | 991 |  |  | No Program
 | 1433.7 | 1433.7 | 1437 |  |  | No Program
 | 1513.35 | 1513.35 | 1437 |  |  | No Program
 | 1593 | 1593 | 1437 |  |  | No Program
 | 2144.15 | 4288.3 | 2257 |  |  | Gold Program
 | 2144.15 | 4288.3 | 2257 |  |  | Gold Program
 | 3052.8 | 3052.8 | 2610 |  |  | No Program
 | 3145.5 | 3145.5 | 3495 |  |  | Platinum Program