tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 94359d1294195832-auto-fill-consecutive-row-after-processing-from-different-sheet-__inputoutput-snb
Sheet: Buy

Date | Coupon | From | Type | [NAME] | Price | Weight | Box | Net | Others | Total
2010-02-20 00:00:00 | 102 | [NAME] | bowl |  | 13500 | 7520 | 2005 | 5515 | 200000 | 74652500
2010-03-26 00:00:00 | 102 | [NAME] | triangle |  | 12500 | 5620 | 2004 | 3616 |  | 45200000
2010-03-26 00:00:00 | 102 | [NAME] | oval |  | 11000 | 4320 | 2040 | 2280 |  | 25080000
2010-03-27 00:00:00 | 102 | [NAME] | broken |  | 8000 | 7111 | 2056 | 5055 |  | 40440000
2010-03-28 00:00:00 | 107 | [NAME] | bowl |  | 13400 | 3025 | 798 | 2227 |  | 29841800
2011-03-28 00:00:00 | 107 | [NAME] | triangle |  | 12400 | 5004 | 2035 | 2969 |  | 36815600
2011-03-29 00:00:00 | 108 | [NAME] | bowl |  | 13400 | 6002 | 2015 | 3987 |  | 53425800
 |  |  |  |  |  |  |  | 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 Pembelian / bulan |  | 305455700
Spreadsheet: 08f8befe-b461-4c72-ae2f-0b8b1822212e
Sheet: T6

الجدول 6: السكان في العراق بحسب [NAME] تعداد 1987
Table 6: Population of Iraq by age groups, 1987 census
 | Nationals | المواطنون | Non-nationals | [NAME] | Urban | حضر | Rural | ريف | Total |  | المجموع
[NAME] | ذكور | إناث | ذكور | إناث | ذكور | إناث | ذكور | إناث | ذكور | إناث | [NAME]
Age group | Male | Female | Male | Female | Male | Female | Male | Female | Male | Female | Both sexes
0-4 | … | … | … | … | 942152 | 901738 | 473924 | 447019 | 1416076 | 1348757 | 2764833
5-9 | … | … | … | … | 849732 | 816617 | 410102 | 391799 | 1259834 | 1208416 | 2468250
10-14 | … | … | … | … | 757781 | 719771 | 344475 | 326382 | 1102256 | 1046153 | 2148409
15-19 | … | … | … | … | 692777 | 636128 | 304010 | 276196 | 996787 | 912324 | 1909111
20-24 | … | … | … | … | 610758 | 510354 | 195354 | 197556 | 806112 | 707910 | 1514022
25-29 | … | … | … | … | 438268 | 364154 | 92971 | 122988 | 531239 | 487142 | 1018381
30-34 | … | … | … | … | 399508 | 348959 | 131602 | 138619 | 531110 | 487578 | 1018688
35-39 | … | … | … | … | 276002 | 257569 | 96295 | 111461 | 372297 | 369030 | 741327
40-44 | … | … | … | … | 223758 | 189656 | 73305 | 74096 | 297063 | 263752 | 560815
45-49 | … | … | … | … | 185678 | 155255 | 60290 | 55966 | 245968 | 211221 | 457189
50-54 | … | … | … | … | 124782 | 122564 | 42891 | 46977 | 167673 | 169541 | 337214
55-59 | … | … | … | … | 126161 | 127725 | 49926 | 52156 | 176087 | 179881 | 355968
60-64 | … | … | … | … | 81830 | 100557 | 38650 | 46509 | 120480 | 147066 | 267546
65-69 | … | … | … | … | 57009 | 65488 | 32266 | 32717 | 89275 | 98205 | 187480
70-74 | … | … | … | … | 48946 | 53784 | 28313 | 26272 | 77259 | 80056 | 157315
75+ | … | … | … | … | 65814 | 79192 | 37482 | 39374 | 103296 | 118566 | 221862
غير محدد    Not stated | … | … | … | … | 70447 | 68055 | 32630 | 35657 | 103077 | 103712 | 206789
المجموع    Total | … | … | … | … | 5951403 | 5517566 | 2444486 | 2421744 | 8395889 | 7939310 | 16335199
Spreadsheet: 849208d1699731792-formulas-are-turning-to-text-if-i-try-to-edit-them-in-any-way-ch-calc_v3
Sheet: Wireline

 | line size (in) | Radius (in) | Radius ([NAME]) | πr2 (m) | displ/100m (l) | m | b | Supplier | Type | BScable(lb) | BSao(lb) | Wca(lb/1000m) | Conductors
 | 7/32 |  |  |  |  | 0.0376 | 20 | Camesa | 1K22 | 5600 | 272 |  | 1
 | 9/32 | 0.144 |  |  |  | 0.061 | 20 | Camesa | 1N29-EHS | 10300 | 398 |  | 1
 | 5/16 |  |  |  |  | 0.0776 | 20 | Camesa | 1N32 | 11400 | 420 |  | 1
 | 3/8 -3 cond | 0.1875 |  |  |  | 0.1105 | 60 | Rochester | 3-H-375A | 14900 | 500 |  | 3
 | 3/8 -7 cond |  |  |  |  | 0.1105 | 60 | Camesa | 7Q38RAZB-HS | 13100 | 494 |  | 7
 | 15/32 | 0.234375 |  |  |  | 0.1725 | 60 | Camesa | 7J46RP | 18000 | 575 |  | 7
Spreadsheet: 740486d1626356511-multiple-dates-entries-in-a-gantt-chart-in-a-single-row-scheduler-3a-with-new-tab-1-ans
Sheet: Bed & Clinic Visits

Date | Clinic Visits | Bed Availability | Notes
2021-01-01 00:00:00 | 14 | 14
2021-01-02 00:00:00 | 15 | 15
2021-01-03 00:00:00 | 16 | 16
2021-01-04 00:00:00 | 17 | 17
2021-01-05 00:00:00 | 18 | 18
2021-01-06 00:00:00 | 19 | 19
2021-01-07 00:00:00 | 20 | 20
2021-01-08 00:00:00 | 21 | 21
2021-01-09 00:00:00 | 22 | 22
2021-01-10 00:00:00 | 23 | 23
2021-01-11 00:00:00 | 24 | 24
2021-01-12 00:00:00 | 25 | 25
2021-01-13 00:00:00 | 26 | 26
2021-01-14 00:00:00 | 27 | 27
2021-01-15 00:00:00 | 28 | 28
2021-01-16 00:00:00 | 29 | 29
2021-01-17 00:00:00 | 30 | 30
2021-01-18 00:00:00 | 31 | 31
2021-01-19 00:00:00 | 32 | 32
2021-01-20 00:00:00 | 33 | 33
2021-01-21 00:00:00 | 34 | 34
2021-01-22 00:00:00 | 35 | 35
2021-01-23 00:00:00 | 36 | 36
2021-01-24 00:00:00 | 37 | 37
2021-01-25 00:00:00 | 38 | 38
2021-01-26 00:00:00 | 39 | 39
2021-01-27 00:00:00 | 40 | 40
2021-01-28 00:00:00 | 41 | 41
2021-01-29 00:00:00 | 41 | 41
2021-02-01 00:00:00 | 42 | 42
Spreadsheet: 456677d1460991290-long-list-show-top-5-oeldere-rank-with-tie-456667d1460987719-long-list-show-top-5-example
Sheet: Sheet1

name | value | sum | rank
[NAME] | 10
Scott | 9
[NAME] | 8
[NAME] | 5
[NAME] | 4
[NAME] | 3
[NAME] | 2
Rich | 1
[NAME] | 4
Cleavland | 5
Spreadsheet: 210932d1359606247-selecting-rows-in-a-table-based-on-another-list-sample-1
Sheet: Sheet1

Sheet1
no. | name | age | salary (k) | id
1 | [NAME] | 34 | 5 | 4975
2 | [NAME] | 23 | 8 | 5656
3 | [NAME] | 67 | 3 | 8888
4 | [NAME] | 43 | 7 | 7654
5 | [NAME] | 22 | 8 | 2343
6 | [NAME] | 44 | 2 | 6567
7 | romeo | 77 | 11 | 5786
8 | bridget | 44 | 14 | 5342
9 | lindsay | 22 | 5 | 4535
10 | henry | 66 | 7 | 7890
.
.
.
.
Spreadsheet: 757565d1638341121-using-countifs-to-count-sales-countif
Sheet: Sheet1

Date Received | CLIENT NAME | Emailed | Called | Rep | Date Completed |  |  |  | DB | DC | JS | AS
2021-11-01 00:00:00 | [NAME] | X | X | DC | 2021-11-01 00:00:00
2021-11-01 00:00:00 | [NAME] | X |  | DC | 2021-11-02 00:00:00
2021-11-02 00:00:00 | [NAME] | X |  | DB | 2021-11-02 00:00:00
2021-11-03 00:00:00 | [NAME] | X | X | JS | 2021-11-03 00:00:00
2021-11-03 00:00:00 | [NAME] | X |  | AS | 2021-11-03 00:00:00
2021-11-03 00:00:00 | [NAME] |  |  | DC | 2021-11-04 00:00:00
2021-11-03 00:00:00 | [NAME] |  |  | DB | 2021-11-05 00:00:00
2021-11-04 00:00:00 | [NAME] |  |  | JS | 2021-11-05 00:00:00
Spreadsheet: 681661d1591690796-shelf-life-problem-check-customer-shelf-life-requirements-with-shelf-life-on-inventory-shelf-life-case-1-
Sheet: Sheet1

Sales order | Loading Date | Material | Delivery quantity | Sales unit | Customer ID | expiration after | Available quantity
444497681 | 2020-06-09 00:00:00 | 67120 | 2772 | TRA | 1518629
444557849 | 2020-06-12 00:00:00 | 17343 | 1881 | TRA | 1518629
Spreadsheet: 741126d1626850009-formula-to-extract-year-and-month-from-two-columns-if-missing-ticket
Sheet: Data

Ticketno | Country | Assigndate | Releasedate | Year | Month | Qtr
123 | Japan | 2020-01-03 00:00:00
212 | UK | 2018-06-08 00:00:00 | 2020-08-01 00:00:00
21345 | Japan | 2020-10-09 00:00:00 | 2020-11-01 00:00:00
34521 | UK | 2017-02-21 00:00:00
7777 | USA | 2021-07-21 00:00:00 | 2021-07-01 00:00:00
8888 | Japan | 2021-06-12 00:00:00
Expected Output
Ticketno | Country | Assigndate | Releasedate | Year | Month | Qtr
123 | Japan | 2020-01-03 00:00:00 |  | 2020 | Jan | Q1
212 | UK | 2018-06-08 00:00:00 | 2020-08-01 00:00:00 | 2020 | Aug | Q3
21345 | Japan | 2020-10-09 00:00:00 | 2020-11-01 00:00:00 | 2020 | Nov | Q4
34521 | UK | 2017-02-21 00:00:00 |  | 2017 | Feb | Q1
7777 | USA | 2021-07-21 00:00:00 | 2021-07-01 00:00:00 | 2021 | Jul | Q3
8888 | Japan | 2021-06-12 00:00:00 |  | 2021 | Jun | Q2
Spreadsheet: 818956d1677143984-index-lookup-but-need-the-column-lookup-to-change-example-1-
Sheet: Sheet6

AB
1
2
3
4
5
6
7
 |  | Column 1
Spreadsheet: 785791d1656690049-formula-to-rearranging-inputs-with-required-output-jimsenthil
Sheet: Output

 | Required Output
 | User | Test_Name
Spreadsheet: 865787d1712767998-can-i-use-exact-or-isnumber-search-to-look-for-more-than-one-thing-filter-based-on-search-etaf
Sheet: Sheet2

 | B1 |  | D1 | E1 |  |  |  | lighr blue | D4 | E4 | 0
 | B2 | red | D2 | E2 |  |  | B5 | dark blue | D5 | E5 | 0
 | B3 |  | D3 | E3
 | B4 | lighr blue | D4 | E4
 | B5 | dark blue | D5 | E5
 | B6 |  | D6 | E6
 | B7 | green | D7 | E7
 | B8 |  | D8 | E8
 | B9 |  | D9 | E9
Spreadsheet: 778852d1651398534-formula-to-calculate-change-percentage-change
Sheet: Sheet1

Line item | 2020-07-01 00:00:00 | 2021-07-01 00:00:00 | % Change
8400/000 STD BANK 270466274 | 0 | 0 | 0
8410/000 Petty Cash | 0 | 0 | 0
Receipts from Customers | 1262299.59 | 1493487.59 | 0.1831
Rebates Received | 19841.16 | 5762.17 | -70,96%
Rental Office Equipment | 10043.75 | 7975.25 | -20,59%
STANDARD BANK LOAN ACCOUNT | 0 | 0 | 0
Sundry Customers | 0 | 0 | 0
Sundry Income | 0 | 0 | 0
STD BANK 270466274 | 0 | 100000
Petty Cash | 0 | 200000
Standard Bank - Savings Acc -  374575568 | 0 | 200000
Deferred - Standard Bank - Tata | 0 | 0
Sars - Income Tax | 0 | 1499249.76
TOTAL RECEIPTS | 2153096.14 | 1499249.76
Payments to Suppliers | 868684.2 | 1305769.94
Accounting Fees | 10250 | 11850
Bank Charges | 1992.49 | 2013.41
Cleaning | 801 | 840
Computer Expenses | 4957.5 | 0
Consulting Fees | 0 | 1650
Courier & Postage | 0 | 0
CELL PHONE EXPENSES | 0 | 0
Donations | 17000 | 0
Directors Fees / Members Remuneration | 17000 | 0
Entertainment Expenses | 0 | 0
General Expenses | 6000 | 6000
General Expenses      - Gifts | 0 | 6000
General Expenses - Fines | 0 | 0
Interest Paid - Bank | 10370.69 | 0
Insurance | 10370.69 | 9639.2
Leasing Charges | 892.4 | 972.72
Motor Vehicle Expenses | 800 | 0
Motor Vehicle Expenses  - Parking | 0 | 0
Motor Vehicle - Petrol & Oil | 0 | 600
Motor Vehicle - Repairs & Maint. | 1377.7 | 487
Printing & Stationery | 1377.7 | 1378.46
Repairs & Maintenance | 1154.7 | 142
Repairs and Maintenance - Office | 0 | 142
Salaries & Wages | 0 | 1747.72
Salaries & Wages - Casual Wages | 458.99 | 1747.72
Security Costs | 458.99 | 504.89
Staff [NAME] | 0 | 5184.88
Staff Training | 0 | 2629
Staff Welfare | 87.94 | 2629
Subscriptions | 161 | 2195.61
Staff Loans | 2584.52 | 0
Telephone & Fax | 2584.52 | 4691.48
Standard Bank - Mini Countryman | 0 | 6615.05
STANDARD BANK- KIA2020-CAA127242 | 0 | 3929.94
STANDARD BANK-KIA 2020-CAA127248 | 0 | 3929.94
STANDARD BANK-FORD RANGER-CAA82115 | 0 | 5849.89
Computer Software | 0 | 0
Loan Account - I Wilcox | 0 | 0
Standard Bank Credit Card Acc | 40460.96 | 96597.05
Standard Bank - Salaries account | 200000 | 150000
Salary & Wages Control | 31379.93 | 0
Sundry Creditors | 0 | 0
Vat / Tax Control Account | 0 | 0
TOTAL PAYMENTS | 1209457.77 | 2039265.09
NET CASH MOVEMENT | 943638.37 | -540015.33
JOURNAL ENTRIES PROCESSED | 789964.95 | 100000
TOTAL CLOSING BANK BALANCE | 0 | -58264.83
Spreadsheet: 107459d1304620566-remove-text-from-string-extract-example
Sheet: Sheet1

11.2.B.9 XXXXXXXXXX |  |  | 11
 |  |  | 2
 |  |  | B
 |  |  | 9
 | Position |  |  | Length
First full stop |  | =FIND(".",A1) |  |  | =FIND(".",A1)-1
Second full stop |  | =FIND(".",A1,FIND(".",A1)+1) |  |  | =FIND(".",A1,FIND(".",A1)+1)-FIND(".",A1)-1
Third full stop |  | =FIND(".",A1,FIND(".",A1,FIND(".",A1)+1)+1) |  |  | =FIND(".",A1,FIND(".",A1,FIND(".",A1)+1)+1)-FIND(".",A1,FIND(".",A1)+1)-1
Space |  | =FIND(" ",[NAME]) |  |  | =FIND(" ",[NAME]) - FIND(".",A1,FIND(".",A1,FIND(".",A1)+1)+1) - 1
Spreadsheet: 71158d1271866034-subtract-if-subtarct-if
Sheet: Sheet1

Branch [NAME] | Cust_Name | Extended Sales | Fiscal Year
60624561 | 110 TECHNOLOGY LLC | 118994.65 | 2008
60624561 | 110 TECHNOLOGY LLC | 140743.79 | 2009 | 21749.14000000001
20263146 | 1TSS LLC | 453.04 | 2009
60918851 | 3 CEES CORP | 65.28 | 2008
10078686 | 318 INC | 547 | 2008
30915571 | 3D AUDIO VISUAL COMMUNICATIONS INC | 13417.59 | 2008
Spreadsheet: 747649d1631627424-using-sumifs-combined-with-vlookup-help-book1
Sheet: Sheet1

Stock Location and Amount
TOKEN | TOTAL | Shop1 | Shop2 | Shop3 | Shop4 | Shop5 | Bank
Apples |  | 10 | 1 | 1 | 2 | 5
Pears |  | 5 | 1 | 1 | 2 | 2
Bananas |  | 4 | 1 | 11 | 2 | 2
Oranges |  | 2 | 1 | 1 | 2 | 2
Bank |  |  |  |  |  |  | 1000
September Stock Movement
September Stock Movement
Date | Buy/Sell/Transfer | Item | Amount | Venue (from) | Venue (To)
2021-09-14 00:00:00 | Transfer | Pears | 1 | Shop4 | Shop1
2021-09-14 00:00:00 | Transfer | Apples | 4 | Shop5 | Shop4
2021-09-14 00:00:00 | Transfer | Oranges | 2 | Shop2 | Shop3
2021-09-14 00:00:00 | Transfer | Bananas | 1 | Shop1 | Shop2
2021-09-14 00:00:00 | Buy | Apples | 20 | Bank | Shop1
2021-09-14 00:00:00 | Sell | Bananas | 5 | Shop3 | Bank
Value of Item
Apples | 1
Pears | 2
Bananas | 3
Oranges | 4
Spreadsheet: 805595d1668784671-cannot-get-averageif-f7-f55-0-to-work-heart-log
Sheet: Sheet1

[NAME] |  | DOB | 1949-10-06 00:00:00 |  |  | HEIGHT | 6' 2"
Date | Time | Sys | [NAME] | Pulse | Glucose | Weight | Notes
 |  |  |  |  |  |  | doubled diltiazem
2022-10-05 00:00:00 | 900 | 110 | 83 | 60 | 86
2022-10-06 00:00:00 | 900 | 116 | 80 | 61 | 121
2022-10-07 00:00:00 | 900 | 131 | 79 | 72
2022-10-08 00:00:00 | 1000 | 118 | 86 | 67
2022-10-09 00:00:00 | 1100 | 136 | 97 | 66
 | 1105 | 133 | 91 | 64
2022-10-10 00:00:00 | 830 | 140 | 78 | 70
2022-10-11 00:00:00 | 930 | 145 | 74 | 65
2022-10-12 00:00:00 | 900 | 130 | 86 | 74
2022-10-13 00:00:00 | 1030 | 122 | 75 | 66
2022-10-14 00:00:00 | 900 | 125 | 75 | 59
2022-10-15 00:00:00 | 700 | 145 | 90 | 68
 | 730 | 111 | 70 | 74
2022-10-16 00:00:00 | 1030 | 126 | 77 | 64 | 130
2022-10-17 00:00:00 | 930 | 120 | 86 | 64 | 118
2022-10-18 00:00:00 | 900 | 123 | 85 | 68 | 121
2022-10-19 00:00:00 | 930 | 137 | 86 | 59 | 118
2022-10-20 00:00:00 | 1000 | 106 | 81 | 76 | 163
 | 1005 | 123 | 90 | 61 | 171
 | 1600 | 120 | 86 | 61 | 131
2022-10-21 00:00:00 | 1200 | 117 | 91 | 69 | 120
2022-10-22 00:00:00 | 930 | 122 | 78 | 59 | 105
2022-10-23 00:00:00 | 1300 | 130 | 76 | 71 | 120
2022-10-24 00:00:00 | 930 | 143 | 79 | 65
 | 1435 | 122 | 84 | 63
2022-10-25 00:00:00 | 1000 | 126 | 87 | 75 | 125
2022-10-26 00:00:00 | 700 | 123 | 77 | 61
2022-10-27 00:00:00 | 930 | 134 | 81 | 86 | 92
2022-10-28 00:00:00 | 1130 | 151 | 86 | 54
 | 1135 | 116 | 97 | 62 | 118
2022-10-29 00:00:00 | 800 | 115 | 88 | 72 | 115
2022-10-30 00:00:00 | 1000 | 124 | 84 | 61 | 98
2022-10-31 00:00:00 | 1000 | 124 | 86 | 69 | 134 | 229
2022-11-01 00:00:00 | 530 | 132 | 86 | 80 | 97
2022-11-02 00:00:00 | 1130 | 128 | 85 | 76 | 105
2022-11-04 00:00:00 | 830 | 112 | 82 | 67 | 94 | 228
2022-11-06 00:00:00 | 800 | 118 | 81 | 64 | 87
2022-11-08 00:00:00 | 900 | 102 | 71 | 79 | 129
2022-11-09 00:00:00 | 800 | 117 | 72 | 40
2022-11-10 00:00:00 | 800 | 117 | 83 | 71 | 118
 | 805 | 134 | 67 | 75 | 119
2022-11-11 00:00:00 | 800 | 194 | 88 | 81
 | 810 | 130 | 90 | 69 | 100
2022-11-12 00:00:00 | 800 | 112 | 74 | 77 | 129
2022-11-14 00:00:00 | 830 | 116 | 71 | 68 | 111
2022-11-16 00:00:00 | 800 | 110 | 82 | 138 | 183
 | 810 | 128 | 81 | 84 | 186
2022-11-17 00:00:00 | 1000 | 146 | 82 | 68 | 116 | 240
 | 1005 | 132 | 72 | 88
2022-11-18 00:00:00 | 100 | 138 | 75 | 70 | 122
Average |  | 126.6 | 81.82 | 69.62 | 121.2903225806452 | 232.3333333333333
Spreadsheet: 09472477-4d33-4bf9-869e-c5815b450515
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | SKI | POSITION | TOTAL TIME
1882 | 5990 | [NAME] | Antonioli | ITA | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1 | 01:13:12
1882 | 5991 | Manfred | [NAME] | LIE | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2 | 01:16:20
1882 | 5992 | [NAME] | [NAME] | ITA | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 3 | 01:18:07
1882 | 5993 | [NAME] | [NAME] | SVK | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 4 | 01:18:59
1882 | 5994 | Jan Hove | Pedersen | NOR | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 5 | 01:20:19
1882 | 6997 | Pavel | [NAME] | SVK | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 6 | 01:21:56
1882 | 5996 | [NAME] | Marcen | ESP | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 7 | 01:24:42
1882 | 5997 | Pavol | Gabor | SVK | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 8 | 01:29:28
Spreadsheet: 769703d1645643730-return-a-match-when-a-tyre-size-is-inputed-tyre-sizes-book
Sheet: Sheet1

15 inch | 16 inch | 17 inch | 18 inch | 19 inch | 20 inch
205/70/15 | 165/70/16 | 145/70/17 | 175/50/18 | 165/55/19 | 205/35/20 |  | 165/65/19
195/70/15 | 175/70/16 | 155/70/17 | 185/50/18 | 165/50/19 | 215/35/20
185/70/15 | 175/65/16 | 165/70/17 | 195/50/18 | 175/50/19 | 225/35/20
215/65/15 | 185/65/16 | 155/65/17 | 205/50/17 | 185/50/19 | 205/30/20
205/65/15 | 195/65/16 | 165/65/17 | 195/45/18 | 205/45/19 | 215/30/20
195/65/15 | 185/60/16 | 175/65/17 | 205/45/18 | 185/40/19 | 225/30/20
235/60/15 | 195/60/16 | 165/60/17 | 215/45/18 | 195/40/19 | 235/30/20
225/60/15 | 205/60/16 | 175/60/17 | 225/45/18 | 205/40/19 | 245/30/20
215/60/15 | 215/60/16 | 185/60/17 | 235/45/18 | 215/40/19 | 255/30/20
205/60/15 | 205/55/16 | 195/60/17 | 215/40/18 | 225/40/19 | 265/30/20
 | 215/55/16 | 185/55/17 | 225/40/18 | 215/35/19
 | 225/55/16 | 195/55/17 | 235/40/18 | 225/35/19
 | 235/55/16 | 205/55/17 | 245/40/18 | 235/35/19
 | 225/50/16 | 215/55/17 | 255/40/18 | 245/35/19
 | 235/50/16 | 195/50/17 | 265/40/18 | 225/35/19
 | 245/50/16 | 205/50/17 | 245/35/18 | 265/35/19
 | 245/45/16 | 215/50/17 | 255/35/18 | 245/30/19
 | 255/45/16 | 225/50/17 | 265/35/18 | 255/30/19
 | 265/45/16 | 235/50/17 | 275/35/18 | 265/30/19
 | 275/40/16 | 225/45/17 | 285/35/18 | 275/30/19
 |  | 235/45/17 | 295/35/18 | 285/30/19
 |  | 245/45/17 | 285/30/18 | 295/30/19
 |  | 255/45/17 | 295/30/18 | 305/30/19
 |  | 245/40/17
 |  | 255/40/17
 |  | 265/40/17
 |  | 275/40/17
 |  | 285/40/17
 |  | 295/40/17
 |  | 285/35/17
 |  | 295/35/17
 |  | 305/35/17
Spreadsheet: 817202d1676048129-stock-allocation-tool-need-formula-with-2-conditions-cartel1
Sheet: Foglio2

question | weight | response | revised
1 | 4
2 | 1 | n/a
3 | 4
4 | 1
5 | 2 | n/a
6 | 4
7 | 3
8 | 3
9 | 1
10 | 3
total | 20 |  | 20
Spreadsheet: 475496d1471341129-how-best-to-compare-2-tabs-of-information-compare
Sheet: test

tab supply
Projects | Project Role | 18 | 19 | 20 | 21 | 22 |  | 23 | 24 | 25 | 26
proj 1 | Architect | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 |  | 0.5 | 0.5 | 0.5 | 0.5
 | Business Analyst | 1 | 1 | 1 | 1 | 1 |  | 1 | 1 | 1 | 1
 | PM | 1 | 1 | 1 | 1 | 1 |  | 1 | 1 | 1 | 1
 | Scrum Master | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
 | Engineer | 2 | 2 | 4 | 4 | 4 |  | 4 | 4 | 4 | 4
 | TPM | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
tab demand
Projects | Project Role | 18 | 19 | 20 | 21 | 22 |  | 23 | 24 | 25 | 26
proj 1 | Architect | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 |  | 0.5 | 0.5 | 0.5 | 0.5
 | Business Analyst | 1 | 1 | 1 | 1 | 1 |  | 1 | 1 | 1 | 1
 | PM | 1 | 1 | 1 | 1 | 1 |  | 1 | 1 | 1 | 1
 | Scrum Master | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
 | Engineer | 2 | 2 | 4 | 4 | 4 |  | 4 | 4 | 4 | 4
 | TPM | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
Spreadsheet: 587188d1534883500-finding-unique-not-duplicates-values-using-index-and-multiple-criteria-mock-calcs
Sheet: Captain America

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Biweekly Time Sheet
 | Please Input Job # for each week in Red Boxes to calculate hours and LOA: |  |  |  |  |  |  |  |  | Pay period start date:
 |  |  |  |  |  |  |  |  |  | Pay period end date:
 | Employee: |  | Captain America
 | WEEK 1 | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Sunday |  | Total | Total | Total
 | Job # | REG | OT | REG | OT | REG | OT | REG | OT | REG | OT | REG | OT | REG | OT | REG | OT | Hours
 | LOA |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total LOA
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Weekly Totals
 | WEEK 2 | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Sunday |  | Total | Total | Total
 |  | 2018-08-20 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 26-Aug-18
 | Job # | REG | OT | REG | OT | REG | OT | REG | OT | REG | OT | REG | OT | REG | OT | REG | OT | Hours
 | LOA |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total LOA
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Weekly Totals
 |  |  |  |  |  |  |  |  |  |  |  |  |  | NET Hours
 |  |  |  |  |  |  |  |  |  |  |  |  |  | NET LOA
Spreadsheet: 92507d1292058007-how-to-increase-all-the-numbers-in-a-range-unevenly-book1
Sheet: Sheet1

 |  | increase 10%
 | 1 | 1.1 | 1.1
 | 2 | 1.1 | 2.2
 | 3 | 1.1 | 3.3
 | 4 | 1.1 | 4.4
 | 5 | 1.1 | 5.5
total | 15 | 1.1 | 16.5
 |  | increase
 | 1 | 1.05 | 1.05
 | 2 | 1.08 | 2.16
 | 3 | 1.03 | 3.09
 | 4 | 1.15 | 4.6
 | 5 | 1.12 | 5.600000000000001
total | 15 | 1.1 | 16.5
Spreadsheet: 47769d1246953302-how-to-sum-based-on-a-range-sumif-on-range
Sheet: Sheet1

ID | Qty
1 | 2
2 | 2
3 | 2
4 | 2
5 | 2
6 | 2
7 | 2
8 | 2
9 | 2
10 | 2
Spreadsheet: 88535d1288340889-tricky-if-and-sumif-combination-test
Sheet: Summary

 | Canada | Croatia | France | Italy | South Africa | Japan | Poland | Germany
2009-01-01 00:00:00
2009-02-01 00:00:00
2009-03-01 00:00:00
2009-04-01 00:00:00
2009-05-01 00:00:00
2009-06-01 00:00:00
2009-07-01 00:00:00
2009-08-01 00:00:00
2009-09-01 00:00:00
2009-10-01 00:00:00
2009-11-01 00:00:00
2009-12-01 00:00:00
2010-01-01 00:00:00
2010-02-01 00:00:00
2010-03-01 00:00:00
2010-04-01 00:00:00
2010-05-01 00:00:00
2010-06-01 00:00:00
2010-07-01 00:00:00
2010-08-01 00:00:00
2010-09-01 00:00:00
Spreadsheet: 866988d1713892870-generating-a-list-of-all-possible-variants-ef1639_combinations
Sheet: Sheet1

 |  | No. of options |  |  |  |  |  |  |  |  | Total no. of options
 |  |  | Material | [NAME] ([NAME]) | [NAME] (mm) | Thickness ([NAME]) | Thickness Tolerance (mm) | Length (M) | Length Tolerance (mm) |  | See below
 |  |  | Solid Flat | ≤ 35 | ± 0.5 | ≤ 10 | ± 0.4 | 4 - 7 | + 50 / - 0
 |  |  |  | >35 -75 | ± 0.8 | >10 - 20 | ± 0.5
 |  |  |  | >75 - 100 | ± 1 | >20 - 40 | ± 0.6
 |  |  |  | >100 - 125 | ± 1.3
 |  |  |  | >125 - 150 | ± 1.5
 |  |  | Table of choices
 |  |  | Material | [NAME] ([NAME]) | [NAME] (mm) | Thickness ([NAME]) | Thickness Tolerance (mm) | Length (M) | Length Tolerance (mm)
 |  |  |  |  |  |  |  |  |  |  | <== Copy formulae in D16:J16 down sufficiently far, according to the number in cell [NAME]
Spreadsheet: 9591845c-3b0f-437b-abb5-c08737c75216
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
RMALF | Test | RMALF | ID MALDI-TOF Mass Spec Fungi | Id MALDI-TOF Mass Spec Fungi |  |  |  |  |  | Varies | **For billing purposes only |  |  |  |  |  |  | 1 | 87107 |  |  |  |  | Rochester
RMALF | [NAME] | VARIES | Varies |  |  |  | See instructions