tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 42294d1240899459-monthly-deposits-681398_penumbra547
Sheet: PT

Sum of Transaction Detail Amount | Years | Transaction Date
 | 2007 |  |  |  |  |  |  |  |  | 2008 |  |  |  |  | Grand Total
ID | Feb | Mar | Apr | May | Jun | Jul | Aug | Nov | Dec | Jan | Feb | Aug | Sep | Oct
518500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 329 | 1010 | 10 | 0 | 0 | 0 | 0 | 1349
518518 | 1000 | 500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1500
518523 | 0 | 222 | 223 | 223 | 223 | 223 | 223 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1337
518526 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 100 | 100 | 600 | 600 | 0 | 0 | 0 | 1400
518534 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 875 | 375 | 375 | 375 | 20 | 20 | 40 | 2080
518538 | 0 | 0 | 0 | 0 | 1236.08 | 200 | 170 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1606.08
Grand Total | 1000 | 722 | 223 | 223 | 1459.08 | 423 | 393 | 1304 | 1485 | 985 | 975 | 20 | 20 | 40 | 9272.08
Spreadsheet: 1d585b1e-c743-4ae9-87a6-aa4dcbfffbac
Sheet: Sheet1

Release: BEA Regions Employment and Unemployment | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=138
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2014-08-01 11:14 AM [NAME]
 | Real-Time | Period
Name: | Start | End
BEA Regions Employment and Unemployment | 2007-07-20 00:00:00 | Current
Source:
Federal Reserve Bank of St. Louis | 2007-07-20 00:00:00 | Current
Release Dates Notes:
Release dates are determined by the following process:
When available, the actual release date as provided by the source is
entered into the ALFRED database.  If a release date is not available
from the source, the release date given by our data providers is used.
If a release date cannot be determined either from the source or from
our data providers, the date that the series was first available in
the St. Louis Fed's FRED database is used.
The release date list contains the dates when any series from this
release was revised.  Note that all series from a release do not
necessarily revise on every release date.
Release Dates:
2007-07-20 00:00:00
2007-08-17 00:00:00
2007-09-25 00:00:00
2007-10-19 00:00:00
2007-11-28 00:00:00
2007-12-21 00:00:00
2008-01-18 00:00:00
2008-03-11 00:00:00
2008-03-28 00:00:00
2008-04-18 00:00:00
2008-05-16 00:00:00
2008-06-20 00:00:00
2008-07-18 00:00:00
2008-08-15 00:00:00
2008-09-19 00:00:00
2008-10-21 00:00:00
2008-11-21 00:00:00
2008-12-19 00:00:00
2009-01-27 00:00:00
2009-02-27 00:00:00
2009-03-11 00:00:00
2009-03-27 00:00:00
2009-04-17 00:00:00
2009-05-22 00:00:00
2009-06-19 00:00:00
2009-07-17 00:00:00
2009-08-21 00:00:00
2009-09-18 00:00:00
2009-10-21 00:00:00
2009-11-20 00:00:00
2009-12-18 00:00:00
2010-01-22 00:00:00
2010-03-10 00:00:00
2010-03-26 00:00:00
2010-04-16 00:00:00
2010-05-21 00:00:00
2010-06-18 00:00:00
2010-07-20 00:00:00
2010-08-20 00:00:00
2010-09-21 00:00:00
2010-10-22 00:00:00
2010-11-23 00:00:00
2010-12-17 00:00:00
2011-01-25 00:00:00
2011-03-10 00:00:00
2011-03-25 00:00:00
2011-04-19 00:00:00
2011-05-20 00:00:00
2011-06-17 00:00:00
2011-07-22 00:00:00
2011-08-19 00:00:00
2011-09-16 00:00:00
2011-10-21 00:00:00
2011-11-22 00:00:00
2011-12-20 00:00:00
2012-01-24 00:00:00
2012-03-13 00:00:00
2012-03-30 00:00:00
2012-04-20 00:00:00
2012-05-18 00:00:00
2012-06-15 00:00:00
2012-07-20 00:00:00
2012-08-17 00:00:00
2012-09-21 00:00:00
2012-10-19 00:00:00
2012-11-20 00:00:00
2012-12-21 00:00:00
2013-01-18 00:00:00
2013-03-18 00:00:00
2013-03-29 00:00:00
2013-04-19 00:00:00
2013-05-16 00:00:00
2013-05-17 00:00:00
2013-06-20 00:00:00
2013-06-21 00:00:00
2013-07-19 00:00:00
2013-08-19 00:00:00
2013-09-20 00:00:00
2013-11-22 00:00:00
2013-12-20 00:00:00
2014-01-28 00:00:00
2014-03-17 00:00:00
2014-03-28 00:00:00
2014-04-18 00:00:00
2014-05-16 00:00:00
2014-06-20 00:00:00
2014-07-18 00:00:00
Spreadsheet: 81257d1281497129-organizing-data-by-time-on-a-different-sheet-tournament-software-template
Sheet: Alpha List Jr.

Name | Hole |  | Name | Hole |  | Name | Hole
Name | Hole
Spreadsheet: 881889d1730116002-get-value-from-different-workbook-based-on-multiple-criteria-and-based-on-the-latest-date-input-workbook-example
Sheet: Input workbook

 |  | Machine | ID number | Blank | Blank | Cyceltime | Blank | Update "date"
 |  | Example1 | 12345 |  |  | 70 |  | 2024-10-18 00:00:00
 |  | Example1 | 12345 |  |  | 85 |  | 2024-10-19 00:00:00
 |  | Example1 | 12345 |  |  | 90 |  | 2024-10-20 00:00:00
 |  | Example2 | 67891 |  |  | 40 |  | 2024-10-25 00:00:00
 |  | Example2 | 67891 |  |  | 50 |  | 2024-10-28 00:00:00
 |  | Example3 | 65743 |  |  | 60 |  | 2024-10-28 00:00:00
 |  | Example4 | 97745 |  |  | 80 |  | 2024-10-28 00:00:00
 |  | From the source workbook I need a formula that checks.
 |  | If there is a match between Machine and ID number in this workbook and in the source workbook.
 |  | If there is a match. Updates the cyceltime to the one with the latest date in this workbook. Into the source workbook
Spreadsheet: 130683d1322515477-lookup-lookup-issue-among-sheets
Sheet: Sheet1

A |  |  |  |  | expected outcome
1 |  |  |  |  |  | D1
2 |  |  |  |  |  | 6
3 |  |  |  |  |  | 14
4 |  |  |  |  |  | 18
5 |  |  |  |  |  | These numbers are not in B1 of Sheet2
6 |  |  |  |  |  | Also I want to put the vlaues of C1 of sheet 2 in front of the match in sheet1, e.g row20.
7
8
9
10
11
12
13
14
15
16
17
18
19 |  | N
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
Spreadsheet: 847111d1698192230-supressing-error-value-0-work-order-review-entry-template
Sheet: WORK ORDER-REVIEW

WO: |  |  |  |  | OVER | DATE | TIME |  | CURRENT WO COMPARED TO AVERAGE OF LAST:
ITEM CODE: |  |  |  |  | UNDER
QTY: |  |  |  |  | ± 10% |  |  |  | X
STEP | WC | [NAME] | Routing | Actual | Eff % | STATUS | AVG/EA |  | Routing | Actual | Eff %
0
10
20
30
40
50
60
70
80
90
100
10
20
30
40
50
60
70
80
90
100
NOTES: |  | Totals
 |  |  |  |  |  |  |  |  | UPDATED ROUTER:
Spreadsheet: 768085d1644835541-how-to-calculate-accessories-left-with-formula-stock
Sheet: Sheet1

IN STOCK |  |  |  | GIVEN TO USERS
Date | Item | Qty |  | Given Date | User | Item | Qty | Left in stock | Expected Result | Returned
2022-02-01 00:00:00 | Earpods | 30 |  | 2022-01-01 00:00:00 | [NAME] | Earpods | 2
2022-02-01 00:00:00 | HDMI Cable | 50 |  | 2022-01-02 00:00:00 | [NAME] | HDMI Cable | 4
 |  |  |  | 2022-02-01 00:00:00 | User | Earpods | 1
 |  |  |  | 2022-02-05 00:00:00 | User | HDMI Cable | 5
 |  |  |  | 2022-02-06 00:00:00 | User | Earpods | 20
 |  |  |  | 2022-02-06 00:00:00 | User | Earpods | 1 |  | 9 | Yes
 |  |  |  | 2022-02-07 00:00:00 | User | Earpods | 1 |  | 8
Spreadsheet: 02ce90ad-ebe0-4867-b01b-e3fe85ea482a
Sheet: Sheet1

Table 5--USDA-calculated world market rice prices (rough basis) 1/ | 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
 | 2011/12 |  |  | 2010/11 |  |  | 2009/10
 |  | Medium/ |  |  | Medium/ |  |  | Medium/
Month | Long | short |  | Long | short |  | Long | short
 | $/cwt
August | 14.08 | 14.4 |  | 9.58 | 9.68 |  | 11.33 | 11.42
September | 15.09 | 15.44 |  | 10.51 | 10.62 |  | 11.25 | 11.35
October | 15.63 | 15.99 |  | 12.15 | 12.29 |  | 11.02 | 11.11
November | 14.93 | 15.28 |  | 13.4 | 13.58 |  | 11.4 | 11.5
December | 13.9 | 14.21 |  | 14.5 | 14.67 |  | 13.03 | 13.15
January | 12.61 | 12.88 |  | 13.98 | 14.15 |  | 13.03 | 13.14
February | 11.81 | 12.2 |  | 12.68 | 13.35 |  | 12.74 | 12.99
March | 11.52 | 11.92 |  | 12.13 | 12.76 |  | 11.21 | 11.42
April | 11.15 | 11.54 |  | 11.76 | 12.36 |  | 10.53 | 10.72
May | 11.42 | 11.82 |  | 11.58 | 12.17 |  | 9.92 | 10.1
June | 11.93 | 12.35 |  | 11.78 | 12.39 |  | 9.41 | 9.57
July 2/ | 12.02 | 12.45 |  | 12.49 | 13.14 |  | 9.42 | 9.58
Market-year
average 1/ | 13.0075 | 13.37333333333333 |  | 12.21166666666667 | 12.59666666666666 |  | 11.19083333333333 | 11.3375
1/ Simple average of the U.S. Department of Agriculture's weekly adjusted world market price.  2/  Preliminary.
Source: [NAME] and Rice Weekly Prices (ftp://ftp.fsa.usda.gov/public/cotton/default.htm), Farm Service Agency, USDA.
Last updated July 11, 2012.
Spreadsheet: 750408d1633441827-automating-color-coding-and-trend-help-needed-data-color-coding-request
Sheet: 6-22-2016

 | ServiceNow Data Accuracy
 | Computers
 |  | Assigned to | Asset Function | [NAME] | Model | Acquisition Method | Computers not reporting Inventory | Cost
 | Total Records | 50690 | 50690 | 50690 | 50690 | 50690 | 50690 | 50690
 | Missing Data Records | 1500 | 0 | 5897 | 407 | 1000 | 1978 | 2451
 | Percentage of Missing Data
 | Server-(storage, Disk, Server)
 |  | Serial Number | State | [NAME] | Model | Acquisition Method | Cost
 | Total Records | 9349 | 9349 | 9349 | 9349 | 9349 | 9349
 | Missing Records | 7190 | 1581 | 6408 | 4063 | 4780 | 6893
 | Percentage of Missing Data
 | Network Gear
 |  | Serial Number | State | [NAME] | Model | Acquisition Method | Cost
 | Total Records | 7175 | 7175 | 7175 | 7175 | 7175 | 7175
 | Missing Records | 212 | 677 | 6795 | 217 | 6889 | 7156
 | Percentage of Missing Data
 | US Cycle Count 3-18-2016
 | State | In transit available | In stock available | In stock used | Pending repair | Data Retention
 | Total Records | 325 | 145 | 868 | 13 | 89
 | Missing Records | 325 | 145 | 868 | 13 | 89
 | [NAME] |  | 1 | 1 | 1 | 1
 | Asset Reconciliation | Remediated Records
 | 30+ Day Audits | 4857
 | Site Asset Reconciliation | 3738
 | Duplicates In ServiceNow-Based on Serial Number
 | Comptuers
 | Duplicates | 0
 | Servers
 | Duplicates | 7225
 | Network Gear
 | Duplicates | 414
Spreadsheet: 159626d1338789201-how-to-look-up-two-values-then-display-an-output-independent_datavalidation_vlookup
Sheet: Sheet1

Brand | Model | Color | Price
Sony | Xperia P | Green | 0 | [NAME] ctrl + shift + enter
 |  |  | Samsung |  |  |  | Sony
 |  |  | Model | Color | Price |  | Model | Color | Price
 |  |  | [NAME] | White | 450 |  | Xperia S | White | 400
 |  |  | Galaxy S3 | [NAME] | 500 |  | Xperia P | Black | 380
 |  |  | Galaxy S4 | Black |  |  | Xperia P | Pink
 |  |  |  |  |  |  | Xperia P | Green
 |  |  | SWAP color and price makes it easier to vlookup
 |  |  | then use your named ranges
Spreadsheet: 118283d1313588259-splitting-out-lists-based-on-values-copy-of-book2-2
Sheet: Sheet1

Surname | First Name | TOTAL | Cardiff | Edinburgh | [NAME] | Birmingham | [NAME] | Liverpool | Coventry
Ackroyd | [NAME] | 28.77 | 5.37 | 4.6 | 8.44 | 2.67 | 7.63 | 0.06
[NAME] | Doreen | 31.45999999999999 | 5.43 | 5.27 | 5.1 | 5.93 | 9.65 | 0.08
[NAME] | [NAME] | 17.9 | 1.22 | 2.71 | 3.84 | 2.84 | 1.39 | 5.9
Blake | Caroline | 39.11 | 7.33 | 7.67 | 8.5 | 9.73 | 4.65 | 1.23
Brett | Delta | 36.71 | 5.22 | 3.54 | 8.6 | 4.44 | 7.83 | 7.08
Buckle | Sophie | 14.12 | 1.18 | 0.43 | 9.94 | 0.86 | 1.55 | 0.16
Craft | Rachel | 31.98 | 6.99 | 8.6 | 8.98 | 0.77 | 0.46 | 6.18
Davison | Eloise | 47.29 | 8.88 | 9.17 | 6.95 | 9.42 | 9.32 | 3.55
[NAME] | Harriet | 35.5 | 2.18 | 9.72 | 5.96 | 3 | 9.77 | 4.87
Hall | Isobel | 17.92 | 4.47 | 2.18 | 0.29 | 4.28 | 3.15 | 3.55
Hewitt | [NAME] | 35.16999999999999 | 6.42 | 3.73 | 9.17 | 6.52 | 7.53 | 1.8
Jenkins | Emily | 33.98999999999999 | 4.52 | 8.97 | 2.7 | 5.6 | 7.65 | 4.55
Kelly | [NAME] | 29.55 | 4.27 | 4.04 | 9.96 | 0.57 | 9.55 | 1.16
Lovitt | Anne-Marie | 37.25 | 5.09 | 6.06 | 8.45 | 6.92 | 5.16 | 5.57
Mason | Ruby | 40.34 | 8.59 | 7.43 | 9.81 | 9.35 | 2.32 | 2.84
Noble | Olivia | 25.46 | 7.32 | 0.2 | 6.83 | 1.83 | 6.63 | 2.65
[NAME] | [NAME] | 28.65 | 5.42 | 4.38 | 6.29 | 5.79 | 3.06 | 3.71
[NAME] | Ursula | 30.75 | 7.59 | 4.52 | 0.66 | 9.66 | 4.34 | 3.98
Peacock | Victoria | 37.2 | 8.15 | 0.74 | 4.2 | 8.75 | 6.71 | 8.65
Price | Faye | 30.73 | 1.5 | 8.07 | 5.57 | 2.95 | 4.97 | 7.67
Rowell | [NAME] | 34.98 | 4.44 | 1.42 | 4.25 | 9.26 | 9.84 | 5.77
[NAME] | Emma | 33.95 | 6.99 | 3.33 | 3.49 | 7.99 | 7.61 | 4.54
[NAME] | Beatrice | 31.64 | 9.81 | 4.9 | 6.84 | 4.33 | 4.24 | 1.52
Thompson | Petra | 24.04 | 6.55 | 1.89 | 0.13 | 9.72 | 4.8 | 0.95
Verity | Georgina | 35.75000000000001 | 4.72 | 4.45 | 9.61 | 8.13 | 8.5 | 0.34
Wilkinson | Helen | 38.09 | 5.9 | 6.4 | 6.89 | 8.12 | 7.32 | 3.46
Yeoman | [NAME] | 31.25 | 8.78 | 1.17 | 2.38 | 7.13 | 6.87 | 4.92
Zouche | Adele | 39.64 | 9.27 | 9.59 | 7.32 | 0.44 | 5.36 | 7.66
Spreadsheet: 766120d1643755693-find-primary-supplier-for-each-product-max-supplier-question-example
Sheet: Situation #1

Pizza Joint
 | Product Value |  |  |  | Supplier A | Supplier B | Supplier C
 | 4 Shop | 4 Supplier |  | Inv Percent | 0.213 | 0.481 | 0.306
Tomato | 5 | 3
Cheese | 4 | 1
Dough | 2 | 3
Green Peppers | 3 | 2
Spreadsheet: 848703d1699368605-highlight-duplicate-celle-from-a-range-new-microsoft-excel-worksheet-1-
Sheet: Sheet1

Topic |  | Name 1 | Name 2 | Name 3 |  |  | [NAME] is having Topics and Coloumn C, D , E are having Nmaes
A |  | 1 | 3 | 7 |  |  | I want to highlight the cells if any topic is having repeated names in diffrent rows.
B |  | 2 | 3 | 9 |  |  | I want to [NAME], C2, E2 and A4, D4, E4 because duplicate name with Same topic.
A |  | 4 | 1 | 7
B |  |  |  |  |  |  | Need Last Help - Topics in Coloum A must get highlightd only and only if Names in C:E coloumn will get repeated.
 |  |  |  |  |  |  | For [NAME] is having topic B which got highlighted because of [NAME] is also having [NAME]But A6 should highlight only if C6:E6 will have repeated number from above C2:E4
Spreadsheet: 801822d1666388520-consolidation-of-data-from-multiple-sheets-with-different-headers-s666-pq-test-excel-sample
Sheet: Project 3

DEVELOPMENT PROFORMA
Offset Reference | 10
Period | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10 | Year 11 | Year 12 | Year 13 | Year 14 |  | 1
Date |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 01/01/2024 | 01/02/2024 | 01/03/2024 | 01/04/2024 | 01/05/2024 | 01/06/2024 | 01/07/2024 | 01/08/2024 | 01/09/2024 | 01/10/2024 | 01/11/2024 | 01/12/2024 | 01/01/2025 | 01/02/2025 | 01/03/2025 | [NAME] | 01/05/2025 | 01/06/2025 | 01/07/2025 | 01/08/2025 | 01/09/2025 | 01/10/2025 | 01/11/2025 | 01/12/2025 | 01/01/2026 | 01/02/2026 | 01/03/2026 | 01/04/2026 | 01/05/2026 | 01/06/2026 | 01/07/2026 | 01/08/2026 | 01/09/2026 | 01/10/2026 | 01/11/2026 | 01/12/2026 | 01/01/2027 | 01/02/2027 | 01/03/2027 | 01/04/2027 | 01/05/2027 | 01/06/2027 | 01/07/2027 | 01/08/2027 | 01/09/2027 | 01/10/2027 | 01/11/2027 | 01/12/2027 | 01/01/2028 | 01/02/2028 | 01/03/2028 | [NAME] | 01/05/2028 | 01/06/2028 | 01/07/2028 | 01/08/2028 | 01/09/2028 | 01/10/2028 | 01/11/2028 | 01/12/2028 | 01/01/2029 | 01/02/2029 | 01/03/2029 | 01/04/2029 | 01/05/2029 | 01/06/2029 | 01/07/2029 | 01/08/2029 | 01/09/2029 | 01/10/2029 | 01/11/2029 | 01/12/2029 | 01/01/2030 | 01/02/2030 | [NAME] | 01/04/2030 | [NAME] | [NAME] | [NAME] | 01/08/2030 | 01/09/2030 | 01/10/2030 | 01/11/2030 | [NAME] | 01/01/2031 | [NAME] | 01/03/2031 | 01/04/2031 | 01/05/2031 | 01/06/2031 | 01/07/2031 | 01/08/2031 | 01/09/2031 | 01/10/2031 | 01/11/2031 | 01/12/2031 | 01/01/2032 | 01/02/2032 | 01/03/2032 | 01/04/2032 | 01/05/2032 | 01/06/2032 | 01/07/2032 | 01/08/2032 | 01/09/2032 | 01/10/2032 | 01/11/2032 | 01/12/2032 | 01/01/2033 | 01/02/2033 | 01/03/2033 | 01/04/2033 | 01/05/2033 | 01/06/2033 | 01/07/2033 | 01/08/2033 | 01/09/2033 | 01/10/2033 | 01/11/2033 | 01/12/2033 | 01/01/2034 | 01/02/2034 | 01/03/2034 | 01/04/2034 | 01/05/2034 | 01/06/2034 | 01/07/2034 | 01/08/2034 | 01/09/2034 | 01/10/2034 | 01/11/2034 | 01/12/2034 | 01/01/2035 | 01/02/2035 | [NAME] | 01/04/2035 | 01/05/2035 | 01/06/2035 | 01/07/2035 | 01/08/2035 | 01/09/2035 | 01/10/2035 | 01/11/2035 | 01/12/2035 | 01/01/2036 | 01/02/2036 | 01/03/2036 | 01/04/2036 | 01/05/2036 | 01/06/2036 | 01/07/2036 | 01/08/2036 | 01/09/2036 | 01/10/2036 | 01/11/2036 | 01/12/2036 | [NAME] | 01/02/2037 | 01/03/2037 | [NAME] | 01/05/2037 | [NAME] | 01/07/2037 | 01/08/2037 | 01/09/2037 | 01/10/2037 | 01/11/2037 | 01/12/2037 | 01/01/2038
Year | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Spreadsheet: 888749d1739317970-vlookup-is-returning-garbage-from-no-telling-where-timsch-test2-1-tms
Sheet: 2004 frequency

Frequency | Number | Name | current
159 | 282 | I'm Going Home
156 | 146 | Hallelujah
146 | 155 | Northfield
142 | 300 | Calvary
138 | 45t | New Britain
138 | 480 | Redemption
136 | 384 | Panting For Heaven
129 | 59 | [NAME]
128 | 99 | [NAME]
128 | 276 | Bridgewater
125 | 63 | Coronation
124 | 475 | A thankful Heart
123 | 171 | Exhortation (first)
123 | 335 | Return Again
122 | 142 | Stratfield
122 | 270 | Confidence
121 | 40 | Lenox
121 | 47b | Idumea
117 | 318 | Present Joys
115 | 143 | Pleyel's Hymn (first)
112 | 503 | Lloyd
110 | 32t | Corinth
110 | 358 | Murillo's [NAME]
108 | 454 | The Better Land
107 | 68b | Ortonville
107 | 178 | Africa
106 | 569b | [NAME]
104 | 36b | Ninety-Fifth
102 | 84 | Amsterdam
102 | 112 | The Last Words Of Copernicus
101 | 34b | St. Thomas
100 | 217 | Ballstown
99 | 299 | New Jerusalem
97 | 159 | Wondrous Love
96 | 101t | Canaan's Land
95 | 31t | Ninety-Third Psalm
93 | 274t | The Golden Harp
90 | 168 | Cowper
90 | 192 | Schenectady
Spreadsheet: 890002d1741113804-help-with-conditional-formatting-for-inspection-rp_iprprev01
Sheet: Cover_Sketch

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SKETCH
Customer Name:
Part Name:
Customer Part#:
Revision:
Tool#
Material
 |  |  |  |  |  |  | Min | [NAME] |  | bottom 10% | top 10%
Item | Material Lot# |  |  | Enter Lot Information
Visual 1 | Cosmetic |  |  | Visual P/F |  |  | P | P
Visual 2 | Color |  |  | Visual P/F |  |  | P | P
Visual 4 | Gate ±.010 |  |  | Visual P/F |  |  | P | P
Visual 5 | Flash < 0.005 |  |  | Visual P/F |  |  | P | P
Dim. 1 | 2.5 ± 0.5 |  |  | Caliper |  |  | 2 | 3
Dim. 2 | 2.5 ± 0.5 |  |  | Caliper |  |  | 2 | 3
Dim. 3 | 2.5 ± 0.5 |  |  | Caliper |  |  | 2 | 3
Spreadsheet: 89578d1289364811-dropping-lowest-grade-remove-appropriate-test-maxima
Sheet: Sheet1

SCORES | TEST MAX
6 | 10
1 | 10
10 | 20
8 | 10
7 | 10
5 | 20
4 | 10
17 | 20
17 | 20
5 | 10
4 | 10
4 | 10
7 | 20
10 | 20
14 | 20
1 | 20
9 | 20
129 | 260 | <-All Scores
123 | 220 | <-Sans 3 Smallest
Spreadsheet: 751511d1634147632-formula-for-glide-path-test-file
Sheet: Sheet1

Agent | Team | Tenure in Days | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
Agent 1 | Team 1 | 30 |  |  |  |  |  |  |  |  | 50 |  |  |  |  | Agent
Agent 2 | Team 2 | 60 |  |  |  |  |  |  |  | -80 | 100 |  |  |  |  | Agent 2
Agent 3 | Team 3 | 90 | 20 | 50 | 10 | 100 | 80 | 90 | 30 | 25 | 60
Agent 4 | Team 1 | 90 | 10 | 100 | 80 | 90 | 30 | -100 | -50 | -40 | -30 |  |  |  |  | Team
Agent 5 | Team 2 | 30 |  |  |  |  |  |  |  |  | 80 |  |  |  |  | Team  2
Agent 6 | Team 3 | 90 | 90 | 30 | 50 | 40 | 30 | 10 | 100 | 80 | 20
Agent 7 | Team 1 | 60 |  |  |  |  |  |  |  | 40 | 100 |  |  |  |  | Tenure
Agent 8 | Team 2 | 30 |  |  |  |  |  |  |  |  | 100 |  |  |  |  | 60
Agent 9 | Team 3 | 60 |  |  |  |  |  |  |  | -100 | -100
Agent 10 | Team 1 | 90 | 60 | 70 | 80 | 90 | 20 | 90 | 30 | 10 | 100 |  |  |  |  | Glidepath End Date
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Aug
 | Target | 58
 | Tenure in Days | 30
 |  | 60
 |  | 90
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Agent | Team | Tenure in Days | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Agent 2 | Team 2 | 60 |  |  |  |  | -50 | 30 | 40 | -80 | 100
 |  |  |  |  |  |  |  |  |  |  |  |  | EXAMPLE: | Forecast | Agent 2 | Team 2 | 60 |  |  |  |  |  |  |  |  |  | 23 | 23 | 22 | 21 | 20 | 19 | 18 | 17 | 16 | 15
 |  |  |  |  |  |  |  |  |  |  |  |  | EXAMPLE: | Glide path | Agent 2 | Team 2 | 60 |  |  |  |  |  |  |  |  | -100 | -50 | 20 | 58
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Glidepath |  |  |  |  |  |  |  |  |  |  |  | Forecast
Agent | Team | Tenure in Days | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
Agent 1 | Team 1 | 30 |  |  |  |  |  |  |  |  | 50
Agent 2 | Team 2 | 60 |  |  |  |  |  |  |  | -80 | 100
Agent 3 | Team 3 | 90 | 20 | 50 | 10 | 100 | 80 | 90 | 30 | 25 | 60
Agent 4 | Team 1 | 90 | 10 | 100 | 80 | 90 | 30 | -100 | -50 | -40 | -30
Agent 5 | Team 2 | 30 |  |  |  |  |  |  |  |  | 80
Agent 6 | Team 3 | 90 | 90 | 30 | 50 | 40 | 30 | 10 | 100 | 80 | 20
Agent 7 | Team 1 | 60 |  |  |  |  |  |  |  | 40 | 100
Agent 8 | Team 2 | 30 |  |  |  |  |  |  |  |  | 100
Agent 9 | Team 3 | 60 |  |  |  |  |  |  |  | -100 | -100
Agent 10 | Team 1 | 90 | 60 | 70 | 80 | 90 | 20 | 90 | 30 | 10 | 100
Spreadsheet: 103306d1301056676-car-show-1st-2nd-3rd-carshow
Sheet: Sheet2

 | Owner ID | Class 1 Votes | Owner ID | Class 2 Votes | Owner ID | Class 3 Votes | Owner ID | Class 4 Votes | Owner ID | Class 6 Votes
 | 123 | 10
 | 133 | 15
 | 234 | 16
 | 456 | 2
 | 456 | 13
 | 345 | 45
 | 3565 | 34
 | 664 | 553
 | 466 | 55
1st Place
2nd Place
3rd Place
 | Owner ID | Class 7 Votes | Owner ID | Class 8 Votes | Owner ID | Class 9 Votes | Owner ID | Class 10 Votes | Owner ID | Class 11 Votes
 | Owner ID | Class 12 Votes | Owner ID | Class 13 Votes | Owner ID | Class 14 Votes | Owner ID | Class 15 Votes | Owner ID | Class 16 Votes
Spreadsheet: 771365d1646645356-select-conditional-data-from-a-table-select-conditional-data-from-a-table-rev-001
Sheet: Sheet1

 |  |  | SerialNumber | Remark | [NAME] | MoreInfo
 |  |  | 643 | Orange | Spanish | Bright color
 |  |  | 654 | Apple | Fruit | Also brand
 |  |  | 645 | Burger | Good | Meat
 |  |  | 166 | Pizza | Good | Round
 |  |  | 285 | Candy | Sweet | No food
Spreadsheet: 813406d1673724593-ranking-error-copy-of-sample-ranking-2
Sheet: Sheet1

Value | Rank
25.7 |  |  | 1
16.2
23.4
23.2
13.9
13.6
16.8
17
17.6
10.6
16.2
17.4
20.9
11.7
18.9
15.8
13.7
10.9
10.8
27.3
12.8
27
13.2
17.9
34.1
18
22.2
16.5
15.3
17.2
19.5
25.5
Spreadsheet: 868483d1715202786-i-have-recently-gone-back-to-work-and-i-am-rusty-chase-credit-card-rec
Sheet: May 2024

Card | Tran Date | Description | Amount | GL Account | Job | Notes
 |  |  |  |  |  |  |  |  | 14110 | Employee Loan
 |  |  |  |  |  |  |  |  | 50200 | New Cont Material
 |  |  |  |  |  |  |  |  | 60000 | Advertising / Promotion
 |  |  |  |  |  |  |  |  | 61000 | Auto Fuel / Repairs
 |  |  |  |  |  |  |  |  | 61010 | Auto Service
 |  |  |  |  |  |  |  |  | 70500 | Meals - Deductible
 |  |  |  |  |  |  |  |  | 70700 | Entertainment - Not Dedutible
 |  |  |  |  |  |  |  |  | 71000 | Office Supplies
 |  |  |  |  |  |  |  |  | 73500 | Postage
 |  |  |  |  |  |  |  |  | 75200 | Security Service
 |  |  |  |  |  |  |  |  | 75500 | [NAME]
 |  |  |  |  |  |  |  |  | 76110 | Mobile Phones ATT
 |  |  |  |  |  |  |  |  | 77000 | Utilities
 |  |  |  |  |  |  |  |  | 77650 | [NAME]
 |  |  |  |  |  |  |  |  | 78000 | Tolls
 |  |  |  |  |  |  |  |  | Cards
 |  |  |  |  |  |  |  |  | 1562 -Edd
 |  |  |  |  |  |  |  |  | 3575-Joann
 |  |  |  |  |  |  |  |  | 4997-Tomas
 |  |  |  |  |  |  |  |  | 7324-Larry
 |  |  |  |  |  |  |  |  | 3029-Jason
 |  |  |  |  |  |  |  |  | 4989-Juan
 |  |  |  |  |  |  |  |  | 2622-Michael
 |  |  |  |  |  |  |  |  | 7486-Andrew
 |  | Total
Spreadsheet: 152366d1335364476-list-all-matching-values-in-a-row-chizz0320
Sheet: A

Original Column | Matching Values from B
XX1234 | AA1234
 | BB1234
YY4321 | BB4321
XY5678 | CC5678
YX8765
ZZ1111 | DD1111
 | FF1111
ZY2222
YZ3333 | DD3333
Spreadsheet: 838936d1691524490-concatenate-multiple-matches-against-different-ranges-concatenate-multiple-matches-against-different-ranges
Sheet: Sheet1

 |  |  | Area | Work | Region | Error Check |  |  |  | Area List | Work List | Region List
 |  |  | A3 | Carpentry | 3 | Error in Area, Region |  |  |  | A1 | Carpentry | 1
 |  |  |  |  |  |  |  |  |  | B1 | Concrete | 2
 |  |  |  |  |  |  |  |  |  | A2 | Masonry | 4
 |  |  |  |  |  |  |  |  |  | C2 | Tiling
 |  |  |  |  |  |  |  |  |  | [NAME]