tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 541075d1507111449-conditional-formatting-with-returns-sample-workbook-for-conditional-formatting-1-
Sheet: Sheet1

All Ratio | All Ratio 1 |  | Growth Ratio | Growth Ratio 1 |  | Activity Ratio | Activity Ratio 1 |  | Profitability Ratio | Profitability Ratio 1 |  | Liquidity Ratio | Liquidity Ratio 1 |  | [NAME] | [NAME]
Sales Growth | -0.2023 |  | Sales Growth | -0.202255616867641 |  | Receivable Turnover | 0.2411030825318958 |  | Profit Margin | 0.9944758270683529 |  | Current Ratio | 3.514816205342137 |  | Debt to Total Assets | 0.2477887971738819
Income Growth | 0.2149290178086301 |  | Income Growth | 0.2149290178086301 |  | Inventory Turnover | 0 |  | Return On Assets | 0.148555299709115 |  | [NAME] | 3.353314924824457
Asset Growth | 6.322026464530071 |  | Asset Growth | 6.322026464530071 |  | Fixed Asset Turnover | 2.280800185572854 |  | Return On Equity | 0.3492352778984828
Receivable Turnover | 0.2411030825318958
Inventory Turnover | 0
Fixed Asset Turnover | 2.280800185572854
Profit Margin | 0.9944758270683529
Return On Assets | 0.148555299709115
Return On Equity | 0.3492352778984828
Current Ratio | 3.514816205342137
[NAME] | 3.353314924824457
Debt to Total Assets | 0.2477887971738819
 |  |  |  |  |  |  |  |  | Expected Results
 |  |  |  | Ratio | Ratio_1 | Count | Ratio | Ratio_1
1 | All Ratio | All Ratio |  |  |  |  |  |  | -0.2023 | 3
2 | Growth Ratio |  |  |  |  |  |  |  | 0.2149290178086301 | 4
3 | Activity Ratio |  |  |  |  |  |  |  | 6.322026464530071 | 5
4 | Profitability Ratio |  |  |  |  |  |  |  | 0.2411030825318958 | 6
5 | Liquidity Ratio |  |  |  |  |  |  |  | 0 | 7
6 | [NAME] |  |  |  |  |  |  |  | 2.280800185572854 | 8
 |  |  |  |  |  |  |  |  | 0.9944758270683529 | 9
 |  |  |  |  |  |  |  |  | 0.148555299709115 | 10
 |  |  |  |  |  |  |  |  | 0.3492352778984828 | 11
 |  |  |  |  |  |  |  |  | 3.514816205342137 | 12
 |  |  |  |  |  |  |  |  | 3.353314924824457 | 13
 |  |  |  |  |  |  |  |  | 0.2477887971738819 | 14
Spreadsheet: 539864d1506412103-sum-using-multipul-vookup-mz-sales-budget-plan-2018-working
Sheet: 62400

AM Multan | Plan FY | Actual YTD | [NAME] | 4Q OL | [NAME] | [NAME]
[PHONE] STAFF MEETINGS,ENTT | 13000 | 0
[PHONE] OTH-REPAIRS/MAINT | 3000 | 0
[PHONE] PRINTING/STATIONERY | 4000 | 0
[PHONE] BOOKS PERIODICALS | 2000 | 0
[PHONE] COMPUTER MAINT | 4000 | 2800
[PHONE] REPRODUCTION CHG | 2000 | 200
[PHONE] TELEPHONES CHG | 30000 | 16087
[PHONE] INTERNET USAG CHG | 20000 | 19949
[PHONE] LOCAL-BUSS TRAVEL | 62000 | 67971
[PHONE] REGIS & TAXES | 3000 | 2240
[PHONE] POL & SERVICES | 156000 | 175487.3
[PHONE] REP  PARTS & ACCESS | 9000 | 22850
[PHONE] PRIVATR MILEAGE | -24000 | -52748
[PHONE] OTH-VEH-TRAV EXP | 0 | 0
[PHONE] OTHERS-GR/PR EXP. | 31000 | 0
[PHONE] BUS. MEETING & ENT. | 32000 | 16308
[PHONE] TAXES STAMPS & LICS | 0 | 4640
Spreadsheet: 888407d1738884301-create-summary-by-month-for-data-on-multiple-monthly-sheets-mobsync-cust-info
Sheet: Current

Cust_# | Name | Qty | Total | Maj
9097 | Central | 4 | 340 | YO
9097 | Central | 4 | 380 | YO
9097 | Central | 4 | 457.88 | HK
9097 | Central | 4 | 232.92 | AB
709 | 49 CENTER | 4 | 973.76 | YO
709 | 49 CENTER | 1 | 111.56 | YO
709 | 49 CENTER | 1 | 105.98 | AB
709 | 49 CENTER | 2 | 198 | HK
709 | 49 CENTER | 4 | 581 | HK
Spreadsheet: 838569d1691144296-countif-multiple-variations-of-products-sample-data
Sheet: Sheet2

 | Product 1 | Product 2 | Product 3 | Product 4 | Product 5 | Product 6 | Product 7
Customer 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0
Customer 2 | 0 | 1 | 1 | 1 | 0 | 1 | 0
Customer 3 | 0 | 1 | 1 | 0 | 0 | 1 | 0
Customer 4 | 1 | 1 | 1 | 0 | 0 | 1 | 0
Customer 5 | 0 | 1 | 1 | 0 | 0 | 0 | 0
Customer 6 | 1 | 0 | 1 | 0 | 0 | 0 | 0
Customer 7 | 0 | 1 | 1 | 0 | 0 | 0 | 0
Customer 8 | 1 | 0 | 1 | 0 | 0 | 0 | 0
Customer 9 | 0 | 0 | 0 | 0 | 0 | 0 | 1
Customer 10 | 1 | 0 | 0 | 1 | 0 | 0 | 0
Customer 11 | 0 | 0 | 1 | 0 | 0 | 0 | 0
Customer 12 | 1 | 0 | 0 | 0 | 1 | 0 | 0
Spreadsheet: 66422d1267085747-excel-2007-pivot-table-help-dynpivot
Sheet: Pivot

Row Labels | Sum of Prod1 | Sum of Prod2 | Sum of Prod3
2 | 11 | 22 | 1
3 | 90 | 0 | 9
4 | 16 | 56 | 9
5 | 22 | 10 | 9
6 | 42 | 61 | 51
Grand Total | 181 | 149 | 79
Spreadsheet: 08d6ce26-2819-4ac2-8f2d-ae864951e6d1
Sheet: Transfer-STEM-AP

[NAME] | Principle | Approach | Key Players | MC Assignment | Timeline | Progress to Date
Transfer-STEM-AP | Increase transfer, science and high school general education opportunities | Stackable certificates that lead to AA/AS and to transfer degrees
 |  | Transfer way-finding for current students
 |  | Transfer way-finding for potential students
 |  | Transfer messaging to high school, community, four year universities
 |  | Four year review of transfer degrees appropriate to community/regional/state/national needs
 | Increase 4 year connections in transfer
 | Increase marketing of transfer, STEM and AP | Develop Science, Technology, Engineering and  Math cohorts for students
 |  | Develop STEM internships
 |  | Develop STEM grants
 |  | Develop STEM articulation with four year  university
 |  | Create STEM high school student enrollment  opportunities
 |  | Integrate MESA into STEM initiatives
 |  | Create STEM / Business/ 4 year partnerships
 |  | High school outreach / high school AP on  site
 |  | High School articulation plans: assessment,  college level readiness, program for  success (MESA)
 |  | Develop Honors Program and market to  high school
 | Increase high school to four year seamless student application and achievement
 | Increase partnerships with business in STEM
Spreadsheet: 750414d1633443988-automating-color-coding-and-trend-help-needed-jlausier-data-color-coding-request
Sheet: 10-7-2016

 | ServiceNow Data Accuracy
 | Computers
 |  | Assigned to | Asset Function | [NAME] | Model | Acquisition Method | Computers not reporting Inventory | Cost
 | Total Records | 49398 | 49398 | 49398 | 49398 | 49398 | 49398 | 49398
 | Missing Records | 823 | 0 | 4071 | 528 | 1100 | 1350 | 1000
 | Percentage of Missing Data
 | Server-(storage, Disk, Server)
 |  | Serial Number | State | [NAME] | Model | Acquisition Method | Cost
 | Total Records | 2101 | 2101 | 2101 | 2101 | 2101 | 2101
 | Missing Records | 0 | 0 | 1611 | 29 | 897 | 2065
 | Percentage of Missing Data
 | Network Gear
 |  | Serial Number | State | [NAME] | Model | Acquisition Method | Cost
 | Total Records | 7112 | 7112 | 7112 | 7112 | 7112 | 7112
 | Missing Records | 188 | 100 | 6859 | 7 | 4677 | 7269
 | Percentage of Missing Data
 | US Cycle Count 9-23-2016
 | State | In transit available | In stock available | In stock used | Pending repair | Data Retention
 | Total Records | 328 | 282 | 1067 | 52 | 284
 | Matching Records | 328 | 282 | 1067 | 52 | 284
 | [NAME]
 | Asset Reconciliation 2016 |  | Remediated Records
 | 30+ Day Audits/Site Asset Reconciliation |  | 7104
 | VMware |  | 3422
 | Network Gear |  | 2711
 | WebServer, AppServer, Disk, ETC |  | 5812
 | Total Infrastructure Asset Record Clean up
 | Duplicates based on Serial Number | 2016-06-22 00:00:00 | 2016-10-07 00:00:00
 | Computers | 187 | 0
 | Servers | 7225 | 212
 | Network Gear | 600 | 161
Spreadsheet: 546414d1510044248-limit-calculated-value-to-18-000-if-age-50-then-26-000-if-50-401-k-savings-calculator
Sheet: 401(k) Calculator

401(k) Savings Calculator
Variables |  |  |  |  |  |  | Summary & Results
Enter your current age: |  |  |  | 43 |  |  | Years to your retirement:
Enter your retirement age: |  |  |  | 65
Salary |  |  |  |  |  |  | Future Value
Enter your current annual salary: |  |  |  | 100000
Enter you annual salary increase: |  |  |  | 0.015
Your current savings or 401K balance: |  |  |  | 100000
Contributions |  |  |  |  |  |  | Total Contributions
Contributions To-Date: |  |  |  | 5000
Employer contributions To-Date: |  |  |  | 1500
Contribution as a % of your salary: |  |  |  | 0.2 |  |  | Your contributions:
Enter your annual contribution: |  |  |  | 2400 |  |  | Employer contributions:
Increase contribution each year by: |  |  |  | 0.05 |  |  | Total contributed:
Employer match (% of contribution): |  |  |  | 0
Employer maximum (% of salary): |  |  |  | 0
Current annual limit of contributions |  |  |  | 18000
Contributions made: |  |  |  | Bi-weekly |  |  | Number of contributions per year:
Return Rate (Interest) |  |  |  |  |  |  | Variable Return Rate
Estimated annual rate of return: |  |  |  | 0.06 |  |  | Average Rate:
Interest Rate: |  |  |  | Fixed |  |  | Minimum Rate: |  |  |  |  | 0.01
 |  |  |  |  |  |  | Maximum Rate: |  |  |  |  | 0.09
 |  |  |  | Press F9 to recalculate
Desired Retirement Income |  |  |  |  |  |  | Estimated Income (Based on Desired Income & Current Salary)
Estimate the rate of inflation: |  |  |  | 0.02 |  |  | Your desired monthly income will start at:
Desired monthly income: |  |  |  | 4300 |  |  | At retirement you will need:
Desired monthly income as a % of salary: |  |  |  | 0.75
Number of years to live on your savings: |  |  |  | 20
Savings Projection Chart
Spreadsheet: 141058d1329062700-vlookup-with-two-tables-ciao
Sheet: Sheet1

range 1 |  |  | range 2
shoes | 80 |  | jeans | 70
skirt | 30 |  | t-shirt | 10
socks | 5 |  | sneakers | 100
item to lookup: | shoes
number: | 3
price: | 80
Spreadsheet: craig_dean__4359__12-15act
Sheet: EPEData

 | 37333.13333333333
 | NEWMAN 1 ,UNAV, -0  , 75  , 39  , 83  ,  0  ,1
 | NEWMAN 2 ,ECON, 36  , 77  , 34  , 83  , 42  ,1
 | NEWMAN 3 ,ECON, 36  ,100  , 35  ,103  , 40  ,1
 | NEWMN/GT1,MANL, 21  , 60  , 18  , 60  ,  0  ,1
 | NEWMN/GT2,MANL, 20  , 60  , 18  , 60  ,  0  ,1
 | NM/GT1+ST,UNAV,  0  ,100  , 61  ,107  ,  0  ,1
 | NM/GT2+ST,UNAV,  0  ,100  , 66  ,107  ,  0  ,1
 | NEWMAN 4 ,UNAV,  0  ,215  , 86  ,214  ,  0  ,1
 | NEWMAN   ,, 113 ,  297,  105, 306 ,  82 ,
 | COPPER   ,[NAME], -0  , 69  , 15  , 69  ,  0  ,1
 | RIOGRAN 6,MANL, 27  , 47  , 29  , 48  ,  0  ,1
 | RIOGRAN 7,AVAL,  0  , 38  , 32  , 49  ,  0  ,1
 | RIOGRAN 8,UNAV,  0  ,121  , 36  ,151  ,  0  ,1
 | RIOGRANDE,,  27 ,   47,   29,  48 ,   0 ,
 | PALOVERDE,MANL,605  ,599  ,599  ,600  ,  0  ,1
 | FOURCRNRS,MANL, 89  , 89  , 89  ,104  ,  0  ,1
 | LAMBDA, 27.01,  773,  771,  184,   15,    0,11194,36
 | APS     ,STRT    ,FC,  ,   1,   1
 | IID     ,EXCS    ,FC,  ,  50,  50
 | IID     ,FIRM    ,PV,  , 100, 100
 | LDWP    ,ECON    ,PV,  ,  80,  80
 | PGT     ,LOSS    ,PV,  ,  -1,  -1
 | PNM     ,CNTG    ,LC,  ,  11,  11
 | PNM     ,LOSS    ,LC,  ,   2,   2
 | SPS     ,FIRM    ,WM,  ,-103,-103
 | SRP     ,FIRM    ,ED,  ,  25,  25
 | SRP     ,LOSS    ,PV,  ,   1,   1
 | TNP     ,FIRM    ,PV,  ,  25,  25
 | TNP     ,LOSS    ,PV,  ,  -5,  -5
 | WAPA    ,PASS    ,WM,HO,  -1,  -1
Spreadsheet: 43536d1242179333-more-advanced-ebay-spreadsheet-ebay-calc
Sheet: Inventory

 |  |  | CATEGORY |  | PRODUCT |  | PACKAGE TYPE |  | SHIPPING COST |  | NET COST | EBAY FEES |  | ADDON FEES | PAYPAL FEES | TOTAL COST |  | LISTING PRICE |  | LISTING S&H | TOTAL INFLOW |  | PROFIT
Spreadsheet: 771781d1646844676-in-a-table-how-can-i-select-to-display-only-certain-columns-and-not-others-how-to-display-only-certain-columns
Sheet: Sheet1

Original Data
Name | Surname | Apples sold | Pears sold | Oranges sold | Bananas sold | A | B | C | D | E | F | G | H | I | J | K | L
[NAME] | Smith | 122 | 2 | 585 | 74 | 122 | 2 | 585 | 74 | 122 | 2 | 585 | 74 | 122 | 2 | 585 | 74
[NAME] | Jones | 669 | 441 | 455 | 88 | 669 | 441 | 455 | 88 | 669 | 441 | 455 | 88 | 669 | 441 | 455 | 88
[NAME] | Doe | 589 | 47 | 556 | 445 | 589 | 47 | 556 | 445 | 589 | 47 | 556 | 445 | 589 | 47 | 556 | 445
[NAME] | Jones | 59 | 478 | 88 | 445 | 59 | 478 | 88 | 445 | 59 | 478 | 88 | 445 | 59 | 478 | 88 | 445
[NAME] | Lopez | 58 | 5465 | 1 | 445 | 58 | 5465 | 1 | 445 | 58 | 5465 | 1 | 445 | 58 | 5465 | 1 | 445
 |  |  |  |  |  |  | (Columns H,I,J,K, and L are hidden)
Columns to display |  |  |  |  |  |  | Desired Outcome (Hiding non needed columns)
Name | Yes |  |  |  |  |  | Name | Surname | Apples sold | Pears sold | Oranges sold | Bananas sold
Surname | No |  |  |  |  |  | [NAME] | Smith | 122 | 2 | 585 | 74
Apples sold | No |  |  |  |  |  | [NAME] | Jones | 669 | 441 | 455 | 88
Pears sold | No |  |  |  |  |  | [NAME] | Doe | 589 | 47 | 556 | 445
Oranges sold | No |  |  |  |  |  | [NAME] | Jones | 59 | 478 | 88 | 445
Bananas sold | Yes |  |  |  |  |  | [NAME] | Lopez | 58 | 5465 | 1 | 445
Spreadsheet: 104878d1302296274-updating-budgets-without-skewing-previous-data-otter-repair-shop
Sheet: Summary

Summary | 2011 | Jan QTR 1 | Feb QTR 1 | Mar QTR 1
Otter Parts | Budget | 0.5 | 0.5 | 0.5
 | Expenditures | 0.6 | #N/A | #N/A
Otter Repair | Budget | 16.3 | 16.3 | 16.3
 | Expenditures | 18.5 | #N/A | #N/A
Summary | TOTAL Budgeted | 16.8 | 16.8 | 16.8
 | TOTAL Expenditures | 19.1 | #N/A | #N/A
 | Actual | -2.300000000000001 | #N/A | #N/A
Spreadsheet: 867596d1714426095-distribute-amount-in-column-according-to-date-and-duration-test
Sheet: Data

Column1 | Current address | End of current OA | Square-meters occupation | Premises | Current occupants (FTE or workstations) | Destination | Target Occupants | Delivery Date | Type of Development | Cost of Works | Duration of Works (in years) | Start Date of Works | Estimated Cost of Works by Type of Development | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030
client 1 | Address 1 | 2027-10-31 00:00:00 | 1000 | Office | 327 | Address 1 | 209 | 2028-04-01 00:00:00 | Complete Development (BB + Office) | 3000 | 3
client 1 | Address 1 | 2027-10-31 00:00:00 | 250 | PUP | 0 | Address 1 | 0 | 2028-04-01 00:00:00 | Complete Development (BB + Office) | 3000 | 3
client 1 | Address 1 | 2027-10-31 00:00:00 | 365 | Office | 25 | Address 1 | 16 | 2030-04-01 00:00:00 | Complete Development (BB + Office) | 3000 | 3
client 2 | Address 5 | 2026-03-31 00:00:00 | 280 | Office | 12 | Address 2 | 8 | 2027-04-01 00:00:00 | Office Only | 1500 | 1
client 3 | Address 3 | 2029-03-31 00:00:00 | 355 | Office | 16 | Address 2 | 10 | 2029-04-01 00:00:00 | Full | 3000 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I need a formula to distribute the amounts according to the following information and get the same result as the rows above :
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | The date in column I (i) and the duration of work, column L
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 Years | 0.2 | 0.3 | 0.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 Years | 0.3 | 0.7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 Year | 1
Spreadsheet: 66499d1267133483-show-status-calculate-based-on-today-system-date-criteria-avk-temp
Sheet: Sheet1

code | name | city | category | date | Status | status | In F column : Required formula
AK0001 | ABCD | PARIS | IND | 2009-02-15 00:00:00 | PW | PW | if column D= IND & date (column E) is before one year then status is "PW" calculate with today system date
AK0002 | BCDE | LUSANGEL | G | 2008-12-12 00:00:00 | W | W | if column D= G & date (column E) is within two year then status is "W" calculate with today system date
AK0003 | CDEF | PARTH | G | 2007-12-12 00:00:00 | PW | PW | if column D= G & date (column E) is before two year then status is "PW" calculate with today system date
AK0004 | DEFG | SYDENY | IND | 2010-01-10 00:00:00 | W | W | if column D= IND & date (column E) is within one year then status is "W" calculate with today system date
AK0005 | EFGH | COLOMBO | G | 2008-03-11 00:00:00 | W | W | if column D= G & date (column E) is within two year then status is "W" calculate with today system date
AK0006
AK0007
AK0008
AK0009 |  |  |  |  |  |  | in f column "pw" or "w" automatic show by formula
AK0010
AK0011
AK0012
AK0013
AK0014
AK0015
AK0016
AK0017
AK0018
AK0019
AK0020
AK0021
AK0022
AK0023
AK0024
AK0025
AK0026
AK0027
AK0028
AK0029
AK0030
AK0031
AK0032
AK0033
AK0034
AK0035
AK0036
AK0037
AK0038
AK0039
AK0040
AK0041
AK0042
AK0043
AK0044
AK0045
AK0046
AK0047
AK0048
AK0049
AK0050
AK0051
AK0052
AK0053
AK0054
AK0055
AK0056
AK0057
AK0058
AK0059
AK0060
AK0061
AK0062
AK0063
AK0064
AK0065
AK0066
AK0067
AK0068
AK0069
AK0070
AK0071
AK0072
AK0073
AK0074
AK0075
AK0076
AK0077
AK0078
AK0079
AK0080
AK0081
AK0082
AK0083
AK0084
AK0085
AK0086
AK0087
AK0088
AK0089
AK0090
AK0091
AK0092
AK0093
AK0094
AK0095
AK0096
AK0097
AK0098
AK0099
AK0100
AK0101
AK0102
AK0103
AK0104
AK0105
AK0106
Spreadsheet: 2b11c850-ce10-477c-8b36-1c2f5fdf89b0
Sheet: D

Course color corresponds with term of offering.  RED for fall semester, PURPLE for J-term, GREEN for both fall and J-term.
 | AOK Designation | CAR Designation | Comment
Drama
DRAM 111 | Arts & Literature-Arts
DRAM 211 | Arts & Literature-Arts
DRAM 215 | Arts & Literature-Arts
DRAM 310 | Arts & Literature-Arts (3 times at 1 hour)
DRAM 320 | Arts & Literature-Arts
 | OR Arts & Literature-Literature
DRAM 330 | Arts & Literature-Arts
DRAM 331 | Arts & Literature-Arts | Computing
DRAM 332 | Arts & Literature-Arts
DRAM 333 | Arts & Literature-Arts
DRAM 334 | Arts & Literature-Arts
DRAM 341 | Arts & Literature-Arts
DRAM 342 | Arts & Literature-Arts
DRAM 381 |  | Experiential-Research
DRAM 381 | Arts & Literature-Arts |  | J-term 2013 (Black American Theater)
DRAM 381 | Arts & Literature-Arts |  | J-term 2013 (Playmaking: The Playwright's Process)
DRAM 382 |  | Experiential-Research
DRAM 422 |  | Experiential-Research; Capstone
Spreadsheet: 718655d1613259244-forecast-function-and-drop-down-iferror-and-double-reciprocal-of-sumproduct-jceurovision-
Sheet: Sheet2

Select state: |  | Alabama
YEAR | MARGIN | FORECAST
1900
1904
1908
1912
1916
1920
1924
1928
1932
1936
1940
1944
1948
1952
1956
1960
1964
1968
1972
1976
1980
1984
1988
1992
1996
2000
2004
2008
2012
2016
2020
2024
2028
2032
2036
2040
Spreadsheet: 723771d1615886843-help-consolidate-data-1615886507823_example
Sheet: report

6 months or over |  |  | within six month period |  |  | current or older
item code | date | qty | item code | date | qty | item code | date | qty
4810 | 2022-03-01 00:00:00 | 2 | 4810 | 2021-05-01 00:00:00 | 3 | 4810 | 2021-03-01 00:00:00 | 4
 | 2022-05-02 00:00:00 | 4 |  |  |  | 4811 | 2021-03-02 00:00:00 | 10
 | 2022-01-01 00:00:00 | 3
Spreadsheet: 739781d1625927753-sort-formula-problem-from-high-to-low-according-to-two-conditions-rank
Sheet: PAGE1

 |  |  | Plan Target |  | completion rate |  | Rank Result
 |  |  | 38 |  | 0.2105263157894737 |  | 1
 |  |  | 186 |  | 0.2096774193548387 |  | 2
 |  |  | 43 |  | 0.1627906976744186 |  | 3
 |  |  | 84 |  | 0.1547619047619048 |  | 4
 |  |  | 73 |  | 0.1506849315068493 |  | 5
 |  |  | 68 |  | 0.1470588235294118 |  | 6
 |  |  | 110 |  | 0.1363636363636364 |  | 7
 |  |  | 146 |  | 0.1301369863013699 |  | 8
 |  |  | 35 |  | 0.1142857142857143 |  | 9
 |  |  | 103 |  | 0.1067961165048544 |  | 10
 |  |  | 160 |  | 0.1 |  | 11
 |  |  | 162 |  | 0.09259259259259259 |  | 12
 |  |  | 87 |  | 0.09195402298850575 |  | 13
 |  |  | 104 |  | 0.08653846153846154 |  | 14
 |  |  | 97 |  | 0.08247422680412371 |  | 15
 |  |  | 64 |  | 0.078125 |  | 16
 |  |  | 79 |  | 0.0759493670886076 |  | 17
 |  |  | 41 |  | 0.07317073170731707 |  | 18
 |  |  | 130 |  | 0.06153846153846154 |  | 19
 |  |  | 135 |  | 0.05925925925925926 |  | 20
 |  |  | 93 |  | 0.05376344086021505 |  | 21
 |  |  | 114 |  | 0.05263157894736842 |  | 22
 |  |  | 61 |  | 0.04918032786885246 |  | 23
 |  |  | 82 |  | 0.04878048780487805 |  | 24
 |  |  | 86 |  | 0.04651162790697674 |  | 25
 |  |  | 108 |  | 0.04629629629629629 |  | 26
 |  |  | 183 |  | 0.04371584699453552 |  | 27
 |  |  | 92 |  | 0.04347826086956522 |  | 28
 |  |  | 115 |  | 0.04347826086956522 |  | 29
 |  |  | 50 |  | 0.04 |  | 30
 |  |  | 50 |  | 0.04 |  | 31
 |  |  | 50 |  | 0.04 |  | 32
 |  |  | 52 |  | 0.03846153846153846 |  | 33
 |  |  | 79 |  | 0.0379746835443038 |  | 34
 |  |  | 120 |  | 0.03333333333333333 |  | 35
 |  |  | 121 |  | 0.03305785123966942 |  | 36
 |  |  | 61 |  | 0.03278688524590164 |  | 37
 |  |  | 95 |  | 0.03157894736842105 |  | 38
 |  |  | 32 |  | 0.03125 |  | 39
 |  |  | 38 |  | 0.02631578947368421 |  | 40
 |  |  | 86 |  | 0.02325581395348837 |  | 41
 |  |  | 89 |  | 0.02247191011235955 |  | 42
 |  |  | 94 |  | 0.02127659574468085 |  | 43
 |  |  | 54 |  | 0.01851851851851852 |  | 44
 |  |  | 13 |  | 0 |  | 45
 |  |  | 19 |  | 0 |  | 46
 |  |  | 24 |  | 0 |  | 47
 |  |  | 45 |  | 0 |  | 48
 |  |  | 45 |  | 0 |  | 49
 |  |  | 59 |  | 0 |  | 50
 |  |  | 66 |  | 0 |  | 51
 |  |  | 77 |  | 0 |  | 52
Spreadsheet: 862221d1709956751-counting-dates-and-times-ooh-sample-dj
Sheet: Sheet1

 | 17:00:00 | 18:00:00 | 19:00:00 | 20:00:00 | 21:00:00 | 22:00:00 | 23:00:00 | 00:00:00 | 01:00:00 | 02:00:00 | 03:00:00 | 04:00:00 | 05:00:00 | 06:00:00 | 07:00:00
 | 18:00:00 | 19:00:00 | 20:00:00 | 21:00:00 | 22:00:00 | 23:00:00 | 1900-01-01 00:00:00 | 01:00:00 | 02:00:00 | 03:00:00 | 04:00:00 | 05:00:00 | 06:00:00 | 07:00:00 | 08:00:00
2023-02-01 00:00:00 |  | 2 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2023-02-02 00:00:00 | 1 | 3 | 1 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 7
2023-02-03 00:00:00 | 0 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 4
2023-02-04 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 |  |  | 5
2023-02-05 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 |  |  | 3
2023-02-06 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0
2023-02-07 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0
2023-02-08 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0
2023-02-09 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0
2023-02-10 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0
2023-02-11 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0
2023-02-12 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0
2023-02-13 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0
2023-02-14 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0
2023-02-15 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0
2023-02-16 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0
2023-02-17 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0
2023-02-18 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0
2023-02-19 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0
2023-02-20 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0
2023-02-21 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0
2023-02-22 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0
2023-02-23 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0
2023-02-24 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0
2023-02-25 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0
2023-02-26 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0
2023-02-27 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0
2023-02-28 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0
Spreadsheet: 145211d1331379885-data-lookup-and-print-the-values-example-2
Sheet: Final Sheet

COST OF Spares
Machine | Part Number | Cost Per Part | used in position | requirement??
Machine GFDH | YGSNTAB90150X |  | front axis | very urgent
Machine GGFH | YINKNLLY000BX |  | level axix | not urgent
Machine YYUT | YTEKAMRW000BX |  | leveller | breakdome\
Machine JJHG | YTEKNWDP000AX |  | bookmark | very urgent
Machine HHHH | YTEMTAP12550X |  | front axis | not urgent
Machine PPYT | YUVNLLK0000BX |  | back | breakdome\
Machine UYTF | YUVNLLM0000BX |  | kkdt | very urgent
 | YUVNLLY0000BX |  | mmnnd | not urgent
 | They yellow box it should automatically take the values from database sheet.