tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 855476d1705027822-find-the-average-value-only-for-cells-that-have-a-value-production-personal-performance-plan_fy2023-worker
Sheet: Guidline

 | FY2023
# | Category | Items | Scores | Comment 1 | Comment 2
1 | Leave data | Sick >12 days | - | In-consistent/Unsatisfactory
2 | Leave data | Sick (ML) >3 months (~552hrs) | - | In-consistent/Unsatisfactory
2 | Leave data | 1 month <Sick (ML) <3 months (~552hrs) | - | Not exceed
3 | Leave data | Unpaid >6 days | - | In-consistent/Unsatisfactory
4 | Violation | Verbal Warning | >=1 case | not Exceed
4 | Violation | Verbal Warning | >=3 cases | In-consistent/Unsatisfactory | Production record, >=3 cases raise to HR
5 | Violation | Written Warning | >=1 case | In-consistent/Unsatisfactory | HR record
6 | Violation | Other Reminder/other team feedback | N/A | Supervisor decision/Direct Report decision
6 | Safety | LTI | 0 | Personal
7 | Safety | LTI | 0.4 | Area (Line)
8 | Safety | LTI | 0.7 | Department
9 | Safety | Non-LTI >=1 case | 0.5 | Personal
10 | Safety | Non-LTI >=1 case | 0.7 | Area (Line)
11 | Safety | Non-LTI >=1 case | 0.8 | Department
12 | Safety | Near Miss  >=2 cases | 0.5 | Personal
13 | Safety | Near Miss  >=2 cases | 0.7 | Area (Line)
14 | Safety | Near Miss  >=2 cases | 0.8 | Department
15 | Safety | Others |  | Compliance
16 | Safety | Early Report | 0.9 | Personal
17 | Quality/Output/Yield/Scrap: | Customer Complaint due to human >=1 case | 0.5 | Personal
18 | Quality | Customer Complaint due to human >=1 case | 0.7 | Area (Line)
19 | Quality | Customer Complaint due to human >=1 case | 0.8 | Department
20 | Quality | CAPA due to human >=1 case | 0.5 | Personal
21 | Quality | CAPA due to human >=1 case | 0.6 | Area (Line)
22 | Quality | CAPA due to human >=1 case | 0.7 | Department
23 | Quality | NC due to human >=1 case |  | Personal
24 | Quality | NC due to human >=1 case |  | Area (Line)
25 | Quality | NC due to human >=1 case |  | Department
26 | Quality | Incident due to human >=3 case |  | Personal
27 | Quality | Incident due to human >=3 case |  | Area (Line)
28 | Quality | Incident due to human >=3 case |  | Department
29 | Quality | >=2 ideas with implementation/6 months | 0.9 | Personal
30 | Delivery | Meet Build plan (Based on forecast FY19) 4.2M/6 months | 1 | Provide data
31 | Delivery | Meet Build plan (weekly, actual)
32 | Delivery | Capacity improvement (Machine + human skill)
33 | Delivery | Meet run rate
34 | Delivery | ideas & implement to improve capacity
35 | Yield/Scrap | Area Yield | 0.9 | full 6 months meet target
36 | Yield/Scrap | Overall Yield | 0.9 | full 6 months meet target
37 | Yield/Scrap |  |  | Justification based on data
38 | Yield/Scrap |  |  | Justification based on data
39 | Training | Overdue | 0
40 | Training | Assign class but not attend without informing | 0.1
41 | Training | Remind to learn | 0~70% | <3 days
42 | Training | Meet requirement | 0.8
43 | Training | Leanr more skills, beyond | 0.9 | depending Manager assesment +5%,…
 | Notes: Special cases review with Functional Managers
Spreadsheet: 135231d1325875196-countif-with-certain-criteria-no-duplicates-copy_portfolio-management-report
Sheet: Summary

Rep Name | Total Accounts | Total Worked ( at least 1 attempt to) | % Worked | Total Penetrated (min 5 attempts) | % Penetrated | POD Touch #1 - Complete (Presentation) | % Completed 1st call | POD Touch #2 - Complete (Pres) | % Completed 2nd Call | POD Touch #3 - Complete (Pres) | % Completed 3rd Call | Accts w/ 4+ POD Touch - Complete (Pres) | % of Accts w/ 4+ Completed | Do Not Call Request | % DNC | [NAME] | % Merchant Refused/ Disconnect | [NAME] | % [NAME] | Left Voicemail | Scheduled Callback | Unreachable (fax/modem, wrong #)
Rep 1
Rep 2
Rep 3
Rep 4
Rep 5
Total
Spreadsheet: 88288d1288158223-filter-worksheet-data-as-per-the-value-selected-in-validation-listbox-filterdatainuserform
Sheet: Sheet1

Country |  |  |  |  |  |  |  |  |  |  |  | Country
Nepal | <- Select a country |  |  |  |  |  |  |  |  |  |  | Nepal
Country | aa | bb | cc
India | 34 | 56 | 78
Nepal | 45 | 67 | 86
US | 34 | 44 | 45 |  |  |  |  |  |  |  | India
India | 23 | 33 | 34 |  |  |  |  |  |  |  | Nepal
Nepal | 44 | 56 | 66 |  |  |  |  |  |  |  | US
US | 77 | 77 | 88
India | 65 | 56 | 77
Nepal | 33 | 34 | 45
India | 88 | 87 | 77
Nepal | 33 | 57 | 78
 | Above lists should get filtered as per selection made in the above list box.
Spreadsheet: 480723d1474034966-formula-for-see-data-a-k-excel-formula
Sheet: Data

Names | Location | Grade | Level | Date |  |  | Month
Ajay | A Road | A | 1 | 2016-06-16 00:00:00
Atul | B Road | B | 1 | 2016-06-16 00:00:00
Dany | C Road | C | 1 | 2016-07-15 00:00:00
[NAME] | D Road | D | 1 | 2016-07-15 00:00:00
Ajay | A Road | D | 1 | 2016-08-10 00:00:00
Atul | B Road | B | 2 | 2016-08-10 00:00:00
Dany | C Road | C | 2 | 2016-09-20 00:00:00
[NAME] | D Road | D | 2 | 2016-09-20 00:00:00
Atul | B Road | B | 2 | 2016-09-20 00:00:00
Spreadsheet: 699278d1602517476-countif-unless-value-of-cell-is-to-text-test-countif
Sheet: Test

 |  |  | Ω 1kft | Ω 1ft
FACP 1-1 | [NAME] | 12
Device ID | SRL15 | SRL15 | P2RL15 | SRL15 | P2RL15 | P2RL110 | SRL110 | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | FACP 1-1 Counts
Wire Length | 35 | 20 | 35 | 42 | 30 | 10 | 110 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | SRL15 | P2RL15 | P2RL110 | SRL110 | N/A | N/A
Device Amps
Resistance Ω
Totals |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  | WIRE   LENGTH | Amps | Volts  Drop | Ohms Ω |  |  |  |  |  |  |  |  |  | Starting Volts |  | 20.4 | EOL VOLTS
Spreadsheet: 731156d1620213241-novelty-golf-scoring-excelhelp-copy
Sheet: Sheet1

 | Round 1 |  |  |  |  |  | Round 2 |  |  |  |  |  |  | Round 3 |  |  |  |  |  |  | Round 4 |  |  |  |  |  |  | Round 5 |  |  |  |  |  |  | Round 6 |  |  |  |  |  |  | Round 7 |  |  |  |  |  |  | Round 8 |  |  |  |  |  |  | Round 9 |  |  |  |  |  |  |  |  | Round 10
 | Points | Hcp | Pars +1 | Birdies +2 | Chip Ins +3 | [NAME] | Points | Hcp | Pars +1 | Birdies +2 | Chip Ins +3 | [NAME] | Total Coins | Points | Hcp | Pars +1 | Birdies +2 | Chip Ins +3 | [NAME] | Total Coins | Points | Hcp | Pars +1 | Birdies +2 | Chip Ins +3 | [NAME] | Total Coins | Points | Hcp | Pars +1 | Birdies +2 | Chip Ins +3 | [NAME] | Total Coins | Points | Hcp | Pars +1 | Birdies +2 | Chip Ins +3 | [NAME] | Total Coins | Points | Hcp | Pars +1 | Birdies +2 | Chip Ins +3 | [NAME] | Total Coins | Points | Hcp | Pars +1 | Birdies +2 | Chip Ins +3 | [NAME] | Total Coins | Points | Hcp | Pars +1 | Birdies +2 | Chip Ins +3 | [NAME] | Total Coins | [NAME] | T2 2nd Best | Hcp | Points | Total | Rank
Player 1 | 12 | 3.5 | 2 | 1 | 0 | 4 | 19 | 5.5 | 7 | 0 | 0 | 11 |  |  | 5.5
Player 2 | 21 | 5.5 | 4 | 2 | 0 | 14 |  | 5 |  |  |  |  |  |  | 5
Player 3 | 21 | 27 | 0 | 0 | 0 | 6 |  | 26.5 |  |  |  |  |  |  | 26.5
Player 4 | 13 | 9.5 | 1 | 0 | 0 | 1 |  | 11 |  |  |  |  |  |  | 11
Player 5 | 20 | 6.5 | 5 | 0 | 0 | 9 |  | 6.5 |  |  |  |  |  |  | 6.5
Player 6 | 19 | 10 | 2 | 0 | 0 | 4 |  | 10 |  |  |  |  |  |  | 10
Player 7 | 15 | 9 | 2 | 0 | 0 | 2 |  | 9.5 |  |  |  |  |  |  | 9.5
 | I would like the formula in G3 to represent the breakdown in the post. Eg IF 16<B3<20 +2 OR IF B3<16 -2 OR IF B3>20 + 4) + D3*1 + E3*2 +F3*3 |  |  |  |  |  |  | If possible, column I requires changes dependant on column B, as per the post ie. +0.5 per score below 16, -0.5 per score above 20 eg if 'Points' is 22 and Hcp is 10, the following weeks handicap would be 10 - 2*0.5
Spreadsheet: 198748d1354887419-match-and-vlookup-matchlookup-problem
Sheet: Personnel Details

Employee ID | FirstName | KnownAs | Surname | Status | JobTitle | Department | Address1 | Address2 | Address3 | Address4 | Address5 | PostCode
Here we go…
I want to be able to add an employees Job Title to F2 using some sort of lookup. The data in the other two sheets contains imported information from a piece of software, which I will then use to populate this sheet.
I need a formula that will look at cell [NAME], recognise it as employee ID "8", then look into the "t_Employee_UDF_data" sheet to match the ID's. Then it needs to recognise that we are looking for
employee ID "8"'s job title which is displayed in column D (UDF Sheet). Catch being, column D contains other information so we need to look at column "I" for the "01 - Current Job Title" row, then display column D of that specific row
Little bit complicated, and I was having trouble even describing that. The general gist is display the job title of column D (UDF Sheet) in F9 (Above) but make sure its for the relevant employee and make sure its not data refering to for instance "06 - Contracted Hours"
Sorry I can't be more descriptive than this.
Spreadsheet: 740182d1626213536-countif-not-working-with-true-criterion-functional-detailed-cs-schedule-sample
Sheet: Thursday

 | 07:00:00 |  |  |  | 08:00:00 |  |  |  | 09:00:00 |  |  |  | 10:00:00 |  |  |  | 11:00:00 |  |  |  | 12:00:00 |  |  |  | 13:00:00 |  |  |  | 14:00:00 |  |  |  | 15:00:00 |  |  |  | 16:00:00 |  |  |  | 17:00:00 |  |  |  | 18:00:00 |  |  |  |  | Attendance
 | 7:00a | 7:15a | 7:30a | 7:45a | 8:00a | 8:15a | 8:30a | 8:45a | 9:00a | 9:15a | 9:30a | 9:45a | 10:00a | 10:15a | 10:30a | 10:45a | 11:00a | 11:15a | 11:30a | 11:45a | 12:00p | 12:15p | 12:30p | 12:45p | 1:00p | 1:15p | 1:30p | 1:45p | 2:00p | 2:15p | 2:30p | 2:45p | 3:00p | 3:15p | 3:30p | 3:45p | 4:00p | 4:15p | 4:30p | 4:45p | 5:00p | 5:15p | 5:30p | 5:45p | 6:00p | 6:15p | 6:30p | 6:45p | NA | A | UA | T
Talk Agents
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | False | False | False
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | False | False | False
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | False | False | False
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | True | False | False
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | False | False | False
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | False | False | False
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | False | True | False
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | False | False | False
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | False | False | False
Total staffed | 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
Staff needed
Number of Calls
Spreadsheet: 3cde4186-9c8d-4381-b84b-b59b7f4e8535
Sheet: Sheet1

2004 Year-End Tax Reporting | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25
Affordable Residential Communities Inc
Form 2004 Report Date: | 2005-01-10 00:00:00
Please list Securities in [NAME] (Skip Rows Between Entries)
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
 |  |  |  |  |  |  |  |  | Year Included in Shareholders' Income |  |  |  |  | Box 6 | Box 1a Total | Box 1b Total | Box 2a | Box 2b | Box 2c | Box 2d | Box 3 | Box 6 | Box 8 | Box 9
Security |  |  |  |  |  |  |  | Total | [NAME]. [NAME]. (852(b)(7)) |  |  |  |  | Foreign |  |  |  | Unrecap |  |  |  | Foreign | Cash | Noncash | Exempt
Description |  | Ticker | Estimated | Reclass | Corrected | Record | Payable | Distribution | 2003 | 2005 | 2004 | Income | Short-term | Tax | Ordinary | Qualified | Total Capital | Sec. 1250 | Section 1202 | Collectibles | Nontaxable | Tax | Liquidation | Liquidation | Interest
(Fund Name) | CUSIP | Symbol | (E) | (R) | (C) | Date | Date | Per Share | (Prior Year) | (Next Year) | (Current Year) | Dividends | Capital  Gain | Paid | Dividends | Dividends | [NAME]. | Gain | Gain | (28%) Gain | Distributions | Paid | Distr | Distr | Dividends
 |  |  |  |  |  |  |  | (10+11+12) |  |  |  |  |  | [NAME]. 23 | (13+14) |  |  |  |  |  |  | [NAME]. 15
ARC common | 8273104 | ARC |  |  |  | 2004-03-31 00:00:00 | 2004-04-15 00:00:00 | 0.1493 |  |  | 0.1493 |  |  |  |  |  |  |  |  |  | 0.1493
ARC common | 8273104 | ARC |  |  |  | 2004-06-30 00:00:00 | 2004-07-15 00:00:00 | 0.3125 |  |  | 0.3125 |  |  |  |  |  |  |  |  |  | 0.3125
ARC common | 8273104 | ARC |  |  |  | 2004-09-30 00:00:00 | 2004-10-15 00:00:00 | 0.3125 |  |  | 0.3125 |  |  |  |  |  |  |  |  |  | 0.3125
ARC common | 8273104 | ARC |  |  |  | 2004-12-31 00:00:00 | 2004-01-14 00:00:00 | 0.3125 |  |  | 0.3125 |  |  |  |  |  |  |  |  |  | 0.3125
TOTALS |  |  |  |  |  |  |  |  |  |  | 1.0868 |  |  |  |  |  |  |  |  |  | 1.0868
ARC Preferred A | 8273203 | ARCpA |  |  |  | 2004-04-15 00:00:00 | 2004-04-30 00:00:00 | 0.4182 |  |  | 0.4182 |  |  |  |  |  |  |  |  |  | 0.4182
ARC Preferred A | 8273203 | ARCpA |  |  |  | 2004-07-15 00:00:00 | 2004-07-30 00:00:00 | 0.5156 |  |  | 0.5156 |  |  |  |  |  |  |  |  |  | 0.5156
ARC Preferred A | 8273203 | ARCpA |  |  |  | 2004-10-15 00:00:00 | 2004-10-30 00:00:00 | 0.5156 |  |  | 0.5156 |  |  |  |  |  |  |  |  |  | 0.5156
ARC Preferred A | 8273203 | ARCpA |  |  |  | 2005-01-15 00:00:00 | 2005-01-31 00:00:00 |  |  | 0.5156
TOTALS |  |  |  |  |  |  |  |  |  | 0.5156 | 1.4494 |  |  |  |  |  |  |  |  |  | 1.4494
Spreadsheet: 99033d1297808550-if-and-vlookup-in-12-sheets-question_2
Sheet: Februar

Product | Description | Stock | Price
Tennisschläger | rot | 40 | 85
Tennisschläger | schwarz | 15 | 85
Fussball | schwarz | 10 | 45
Fussball | weiss | 20 | 45
Spreadsheet: 077c11c6-edad-4513-90ee-ec17154b4272
Sheet: Sheet1

Table 4--Cottonseed:  U.S. supply and disappearance | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 | Supply |  |  |  |  | Disappearance
Year beginning | Beginning |  |  |  |  |  |  |  |  | Ending
August 1 | stocks | Production | Imports | Total |  | Crush | Exports | Other | Total | stocks
 | 1,000 short tons
2010/11 | 341.601 | 0 | 6098.1 | 6439.701 |  | 2562.55107 | 275.111 | 2984.47593 | 5822.138 | 617.563
2011/121 | 617.563 | 71.601 | 5370 | 6059.164 |  | 2400 | 132.58 | 3096.584 | 5629.164 | 430
2012/132 | 430 | 100 | 5759 | 6289 |  | 2500 | 250 | 3047 | 5797 | 492
1 Estimated.  2 Forecast.
Sources: USDA, National Agricultural Statistics Service, Crop Production and U.S. Department of Commerce,
U.S. Census Bureau, Foreign Trade Statistics.
Last update: | 2013-03-12 10:57:27.460000
Spreadsheet: 548036d1510846440-holiday-accrual-change-each-year-staff-holidays
Sheet: Sheet1

Name | Start  Date | Date Printed | Length of Employment | Accrual Rate per MONTH (Days) | Annual leave  earned to Date (A) | Statutory Holidays earned to [NAME] (B) | TOTAL S/H & A/L since start date (A+B) | Total A/L & S/H taken to Date | No. of days available as of date of print
EMPLOYEE 1 | 2011-12-12 00:00:00 |  |  | 1.17 |  | 68 |  | 126
EMPLOYEE 2 | 2011-10-01 00:00:00 |  |  | 1.17 |  | 72 |  | 128
EMPLOYEE 3 | 2015-03-09 00:00:00 |  |  | 1.17 |  | 30 |  | 46
EMPLOYEE 4 | 2013-10-01 00:00:00 |  |  | 0.84 |  | 48 |  | 66 |  | This employee's holiday entitlement changed in October 2015 to 1.17 days per month accured
EMPLOYEE 5 | 2013-11-22 00:00:00 |  |  | 0.84 |  | 44 |  | 65 |  |  | How do I change an employees accural each year
EMPLOYEE 6 | 2016-05-28 00:00:00 |  |  | 0.84 |  | 15 |  | 13 |  |  |  | Thank you
EMPLOYEE 7 | 2017-03-26 00:00:00 |  |  | 0.84 |  | 4 |  | 3
EMPLOYEE 8 | 2017-02-20 00:00:00 |  |  | 0.84 |  | 5 |  | 10
EMPLOYEE 9 | 2014-08-01 00:00:00 |  |  | 0.84 |  | 37 |  | 50
EMPLOYEE 10 | 2014-04-30 00:00:00 |  |  | 0.84 |  | 40 |  | 60
EMPLOYEE 11 | 2013-07-09 00:00:00 |  |  | 0.84 |  | 51 |  | 80
EMPLOYEE 12 | 2014-09-24 00:00:00 |  |  | 0.84 |  | 37 |  | 40
EMPLOYEE 13 | 2014-04-19 00:00:00 |  |  | 0.84 |  | 40 |  | 71
EMPLOYEE 14 | 2017-06-03 00:00:00 |  |  | 0.84 |  | 3 |  | 0
EMPLOYEE 15 | 2016-11-01 00:00:00 |  |  | 0.84 |  | 9 |  | 10
EMPLOYEE 16 | 2017-09-01 00:00:00 |  |  | 0.84 |  | 0 |  | 0
EMPLOYEE 17 | 2012-11-01 00:00:00 |  |  | 0.84 |  | 59 |  | 74
EMPLOYEE 18 | 2016-11-09 00:00:00 |  |  | 0.84 |  | 7 |  | 0
EMPLOYEE 19 | 2017-09-11 00:00:00 |  |  | 0.84 |  | 0 |  | 0
EMPLOYEE 20 | 2011-10-18 00:00:00 |  |  | 0.84 |  | 71 |  | 120
EMPLOYEE 21 | 2015-11-14 00:00:00 |  |  | 0.84 |  | 19 |  | 24
Spreadsheet: 735263d1622801797-lookup-data-based-on-tab-cross-reference-example
Sheet: 3

City | Population
Virginia Beach | 450201
Norfolk | 244601
Chesapeake | 239982
Arlington | 233464
Richmond | 226622
Newport News | 179673
[NAME] | 157613
Hampton | 135041
Roanoke | 99229
Portsmouth | 95097
Suffolk | 90093
Lynchburg | 80569
Centreville | 74125
Dale City | 72627
Reston | 61147
Spreadsheet: 104926d1302376395-looking-up-value-and-filling-cells-forum-example
Sheet: Sheet1

TRI Unique Parent Company Name | Parent Company DB Number | [NAME] | SIC conversion | Sum CC Total releases Wtd | Sum CC Total releases | PSIC | CUSIP | GVKEY | Compustat Name | Public (P) Private (PR) Foreign (F)
21ST CENTURY CO INC | 798222980 | 332913 | 3432 | 114.8538 | 13023 | 343 | #N/A
A & E INC | 6425631 | 332212 | 3421 | 0.084 | 0.84 | .
A TEICHERT & SON INC. | 006911135 | . | n/a | 29 | 29 | 144
A&A READY MIX. INC | 945088227 | 327320 | 3273 | 0.003 | 30
[NAME]. | 003154010 | 322214 | 2655 | 6.473000000000001 | 14925 | 265
[NAME] | 006085815 | 335228 | 3639 | 2570.378 | 782474 | 363 | 831865209 | 9771 | SMITH (A O) CORP | p
[NAME] | 117531954 | 335312 | 3621 | 293.9758 | 70724 | 362
[NAME]. | 006504005 | 327125 | 3297 | 0 | 0 | 329
A. SCHULMAN INC | 006998413 | 325991 | 3087 | 0.5194 | 4898 | 308
Spreadsheet: 686282d1594473507-lookup-matchdata-from-another-different-format-table-book1-ricky82-
Sheet: Agent2

Full Name | 2020-06-01 00:00:00 |  |  |  | 2020-06-02 00:00:00 |  |  |  | 2020-06-03 00:00:00 |  |  |  | 2020-06-04 00:00:00 |  |  |  | 2020-06-05 00:00:00 |  |  |  | 2020-06-06 00:00:00 |  |  |  | 2020-06-07 00:00:00
 | Monday |  |  |  | Tuesday |  |  |  | Wednesday |  |  |  | Thursday |  |  |  | Friday |  |  |  | Saturday |  |  |  | Sunday
 | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-In | Sch-Out | Act-Login | Act-Logout
Agent 2
 | 2020-06-08 00:00:00 |  |  |  | 2020-06-09 00:00:00 |  |  |  | 2020-06-10 00:00:00 |  |  |  | 2020-06-11 00:00:00 |  |  |  | 2020-06-12 00:00:00 |  |  |  | 2020-06-13 00:00:00 |  |  |  | 2020-06-14 00:00:00
 | Monday |  |  |  | Tuesday |  |  |  | Wednesday |  |  |  | Thursday |  |  |  | Friday |  |  |  | Saturday |  |  |  | Sunday
 | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-Hours | Act- Hours | Act-Login | Act-Logout | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-In | Sch-Out | Act-Login | Act-Logout
 | 2020-06-15 00:00:00 |  |  |  | 2020-06-16 00:00:00 |  |  |  | 2020-06-17 00:00:00 |  |  |  | 2020-06-18 00:00:00 |  |  |  | 2020-06-19 00:00:00 |  |  |  | 2020-06-20 00:00:00 |  |  |  | 2020-06-21 00:00:00
 | Monday |  |  |  | Tuesday |  |  |  | Wednesday |  |  |  | Thursday |  |  |  | Friday |  |  |  | Saturday |  |  |  | Sunday
 | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-In | Sch-Out | Act-Login | Act-Logout
 | 2020-06-22 00:00:00 |  |  |  | 2020-06-23 00:00:00 |  |  |  | 2020-06-24 00:00:00 |  |  |  | 2020-06-25 00:00:00 |  |  |  | 2020-06-26 00:00:00 |  |  |  | 2020-06-27 00:00:00 |  |  |  | 2020-06-28 00:00:00
 | Monday |  |  |  | Tuesday |  |  |  | Wednesday |  |  |  | Thursday |  |  |  | Friday |  |  |  | Saturday |  |  |  | Sunday
 | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-In | Sch-Out | Act-Login | Act-Logout
 | 2020-06-29 00:00:00 |  |  |  | 2020-06-30 00:00:00
 | Monday |  |  |  | Tuesday
 | Sch-In | Sch-Out | Act-Login | Act-Logout | Sch-In | Sch-Out | Act-Login | Act-Logout
 | Total Days AM Shift
 | Total Days PM Shift
Spreadsheet: chris_germany__2056__MCV Invoice Analysis 4-29-02
Sheet: Invoice Rec

 |  |  |  | Model Values |  |  |  |  |  |  |  |  |  | System Values |  | System - Model
MCV I |  | VOLUME |  | FIXED |  |  |  |  |  | SALE PRICE |  | TOTAL |  | INVOICED |  | DIFFERENCE
IF-TRUNKL/TX |  | 210800 |  | 4.23
 |  |  |  |  |  |  |  |  |  | MCV I Subtotal
MCV II |  |  |  | Fixed |  | IF-HEHUB |  | IF-FOM |  | SALE PRICE |  | TOTAL
IF-PAN/TX/OK |  | 155000 |  | 2.55 |  | 2.39 |  | 2.3 |  |  |  |  |  | 26143.85
IF-ANR/LA |  | 124000 |  | 2.55 |  | 2.39 |  | 2.33
IF-TRUNKL/LA |  | 93000 |  | 2.55 |  | 2.39 |  | 2.32
IF-TRUNKL/TX |  | 93000 |  | 2.55 |  | 2.39 |  | 2.27
 |  |  |  |  |  |  |  |  |  | MCV II Subtotal
 |  |  |  |  |  |  |  |  |  | MCV I and II
 |  |  |  |  |  |  |  |  |  | MCV PAID ON 4/26/02 |  |  |  | 1272099
 |  |  |  |  |  |  |  |  |  | NET SHORT
Spreadsheet: 774119d1648220341-identify-records-with-specific-condition-test11
Sheet: Sheet1

ID | Code | Status | Logins | Expected | [NAME]
253071690049 | Blue | Active | 2
566369030103 | Green | Active | 0
566369030103 | Blue | Active | 0
566369030103 | Orange | Inactive | 0
566369030103 | Purple | Active | 16
560122395105 | Blue | Active | 0
560122395105 | Green | Active | 0
560122395105 | Purple | Active | 7
560122395105 | Orange | Active | 2
558415928107 | Pink | Active | 0 | Never
558415928107 | Turquoise | Active | 0 | Never
558415928107 | Bergundy | Active | 0 | Never
558415928107 | Red | Active | 0 | Never
558415928107 | None | Active | 0 | Never
558415928107 | White | Active | 0 | Never
558415928107 | Blue | Active | 0 | Never
558415928107 | Black | Active | 0 | Never
558415928107 | Grey | Active | 0 | Never
579036465109 | Duck | Active | 1
579036465109 | Red | Active | 334
766862153562 | Green | Active | 0 | Never