tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 714317d1611169395-formula-link-between-2-sheets-in-attesa
Sheet: ordina_mail_manuale

POS. | ARTICOLO | DESCRIZIONE | U.M. | Q.TA'  DISP. | Q.TA'  MIN | Q.TA'  DA ORD | COSTO UNIT. € | FORNITORE | ORDINATO MAIL | ORDINATO MANUALE | DATA  ORDINE
K-02 | 123-AA-123ZZ | AAAABBB1 | NR | 0 | 9 | 9 | 3 | AAA105 | si |  | 2021-01-19 00:00:00
K-79 | 9900014380 | AAAABBB2 | NR | 2 | 5 | 8 | 2 | AAA118 | NO | si | 2021-01-19 00:00:00
M-98 | 9900015811 | AAAABBB3 | NR | 0 | 9 | 9 | 7 | AAA130 | NO
L-12 | 609462030 | AAAABBB4 | NR | 0 | 8 | 9 | 5 | AAA64 | si |  | 2021-01-19 00:00:00
S-01 | 609462032 | AAAABBB5 | NR | 0 | 8 | 99 | 5 | AAA66 | si |  | 2021-01-19 00:00:00
S-51 | 9900013338 | AAAABBB6 | NR | 1 | 8 | 8 | 4 | AAA30 | si |  | 2021-01-19 00:00:00
W-03 | 9900016028 | AAAABBB7 | NR | 1 | 8 | 9 | 2 | AAA141 | NO | si | 2021-01-19 00:00:00
Y-02 | 9900015589 | AAAABBB8 | NR | 5 | 8 | 8 | 8 | AAA13 | NO | si | 2021-01-19 00:00:00
Z-02 | 609462145 | AAAABBB9 | NR | 1 | 9 | 99 | 5 | AAA69 | NO | si | 2021-01-19 00:00:00
Z-06 | 609400238 | AAAABBB10 | NR | 2 | 9 | 9 | 5 | AAA73 | SI |  | 2021-01-19 00:00:00
Q-02 | 9900014461 | AAAABBB11 | NR | 1 | 8 | 8 | 8 | AAA6 | NO | si | 2021-01-20 00:00:00
N-18 | 609400234 | AAAABBB12 | NR | 1 | 9 | 99 | 5 | AAA74 | NO
Q-01 | 9900014460 | AAAABBB13 | NR | 1 | 8 | 8 | 8 | AAA5 | NO
P-01 | 9900015789 | AAAABBB14 | NR | 1 | 9 | 8 | 6 | AAA127 | NO | si | 2021-01-20 00:00:00
P-02 | 9900015779 | AAAABBB15 | NR | 0 | 9 | 9 | 9 | AAA128 | SI |  | 2021-01-20 00:00:00
R-100 | 517874240 | AAAABBB16 | NR | 1 | 4 | 8 | 3 | AAA44 | NO | si | 2021-01-20 00:00:00
W-57 | 609440283 | AAAABBB17 | NR | 1 | 9 | 9 | 4 | AAA91 | NO | SI | 2021-01-20 00:00:00
N-48 | 609440500 | AAAABBB18 | NR | 0 | 9 | 9 | 3 | AAA98 | NO | SI | 2021-01-20 00:00:00
X-25 | 9900014673 | AAAABBB19 | NR | 2 | 5 | 8 | 2 | AAA121 | NO
Spreadsheet: 708808d1608036456-extract-and-sum-numerical-values-using-string-matching-from-single-multi-value-cell-submission
Sheet: Sheet4 (2)

 |  |  |  |  |  | Case 1: 2 people 2 different tasks
Jake |  |  |  |  |  | 2675_Mechanism Drive_Guard Bottom_Fit _02
Liam |  |  |  |  |  | 2675_Mechanism Drive_Guard Bottom_Weld_04, 2675_Mechanism Drive_Guard Bottom_Fit _04
[NAME] |  |  |  |  |  | 2675_Mechanism Drive_Guard Bottom_Fit _05
1 | 2675 | Term | lenghth
1.1 | Mechanism Drive |  |  |  |  | With Index, [NAME] (doesn’t work) | With If
1.1.1 | Guard Bottom |  |  | Fit | Weld |  | if | if search
1.1.1.1 | Fit
1.1.1.2 | Weld
1.1.2 | Guard Top
1.1.2.1 | Fit
1.1.2.2 | Weld
 |  |  |  |  |  | do the index with match or if | This doesn’t work, need to sub if (string = string) to a search if (string = search string)
 |  | From Internet
 |  |  |  |  |  | Return Position of Matching Item
 |  | THIS WILL WORK WITH OLD METHOD WITH MANY SEARCH FINDS |  |  |  | Matching Item Len-2
1.1 | Mechanism Drive
1.1.1 | Guard Bottom
1.1.1.1 | Jake
1.1.1.2 | [NAME]
1.1.1.3 | [NAME]
1.1.2 | Guard Top
1.1.3.1 | Jake |  |  |  |  | weird shit
1.1.3.2 | [NAME]
1.1.3.3 | [NAME]
Spreadsheet: mary_fischer__25621__77N
Sheet: E20.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 077N
COMPANY NAME    Marlin Electrical, Inc
ANALYSIS OF OTHER INCOME AND DEDUCTIONS
FOR THE 6 MONTHS ENDED 6-30-2001
 |  |  |  |  |  |  |  |  |  | E-20
[NAME] |  | 1ST QTR |  | 2ND QTR |  | 3RD QTR |  | 4TH QTR |  | YEAR TO DATE
OTHER INCOME - OTHER
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
GAIN/SALE F/A MARLIN |  |  |  | 5734
Total Other Income - Other
(MUST TIE TO HYPERION ACCOUNT 1690)
Income Accts:  DR/(CR)
Reverse signs from Hyperion
[NAME] |  | 1ST QTR |  | 2ND QTR |  | 3RD QTR |  | 4TH QTR |  | YEAR TO DATE
OTHER DEDUCTIONS - OTHER
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Total Other Deductions - Other
(MUST TIE TO HYPERION ACCOUNT 1775)
Asset/Expense Accts:  DR/(CR)
Same signs as Hyperion
 |  |  |  |  |  |  |  |  |  | E-20
Spreadsheet: 775570d1649183633-conditional-formatting-turn-off-or-on-with-checkbox-but-ignore-dashes-excel-test-formatting-v2
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | False
 |  |  |  | MOST STRINGENT CRITERIA FOR LAND USE AND SOIL TYPE
 |  |  |  | Benzene | Toluene | Ethylbenzene | Xylenes | PHC F1 | PHC F2 | PHC F3 | PHC F4
 |  |  | YES | - | 640 | 1700 | 480 | 12000 | 6800 | 15000 | 21000
 |  |  | YES | - | 2100 | 1000 | 280 | 710 | 3600 | - | -
 |  |  | YES | - | 1900 | 930 | 250 | 610 | 3100 | - | -
 |  |  | NO | - | 0.52 | 0.073 | 0.99 | 1100 | 1500 | - | -
 |  |  | YES | - | 9200 | 24000 | 6900 | 30000 | 30000 | 30000 | 300000
 |  |  | YES | - | 110 | 120 | 65 | 210 | 150 | 1300 | 5600
 |  |  | YES | - | - | - | - | - | - | - | -
 |  |  | YES | - | - | - | - | - | - | - | -
 |  |  | YES | - | - | - | - | - | - | - | -
 |  |  | NO | - | 63000 | - | - | 30000 | 30000 | - | -
 |  |  | NO | - | - | - | - | - | - | - | -
 |  |  | NO | - | - | - | - | - | - | - | - |  | CF: | =AND(NOT($P$1),E29=E$49)
 |  |  | NO | - | - | - | - | - | - | - | -
 |  |  | YES | - | 1100 | 790 | 930 | 3000 | 2100 | 4300 | 30000
 |  |  | YES | - | - | - | - | 800 | 1000 | 3500 | 10000
 |  |  |  | Benzene | Toluene | Ethylbenzene | Xylenes | PHC F1 | PHC F2 | PHC F3 | PHC F4
 |  |  |  | - | 110 | 120 | 65 | 210 | 150 | 1300 | 5600
 |  |  |  | <0.010 | <0.080 | <0.010 | <0.100 | - | - | - | -
 |  |  |  | <0.04 | <0.10 | <0.10 | <0.1 | - | - | - | -
 |  |  |  | <0.0050 | <0.020 | <0.010 | <0.040 | <12 | <10 | <50 | <50
 |  |  |  | <0.0050 | <0.020 | <0.010 | <0.040 | <12 | 45 | 170 | 160
 |  |  |  | <0.0050 | <0.020 | <0.010 | 0.12 | <12 | 39 | <50 | <50
 |  |  |  | 0.045 | 0.24 | 8.1 | 98 | 1100 | 2600 | <50 | <50
Spreadsheet: 839738d1692191183-how-to-concatenate-and-show-ranking-formulas-160823
Sheet: Sheet1

Name 1 | [NAME] | Address | Phone No | Visits
Elvis | Presley | 2 West Street | 55987 | 23 |  |  |  |  |  |  | RANK | NAME | VISITS
[NAME] | [NAME] | 15 West Street | 16579 | 18 |  |  | Rank 2 = [NAME] |  |  |  | 1 | [NAME] | 77
Clint | Eastwood | 2 North Row | 78945 | 4 |  |  | Rank 3 = [NAME] 55 |  |  |  | 2 | [NAME] | 66
[NAME] | Wayne | 54 East Avenue | 22265 | 66 |  |  | Rank 4 = [NAME] 23 |  |  |  | 3 | [NAME] | 55
Elvis | Presley | 2 West Street | 55987 | 15 |  |  | Rank 5 = [NAME] 18 |  |  |  | 4 | [NAME] | 23
[NAME] | [NAME] | 15 West Street | 16579 | 9 |  |  | Rank 6 = [NAME] 15 |  |  |  | 5 | [NAME] | 18
Clint | Eastwood | 2 North Row | 78945 | 1 |  |  | Rank 7 = [NAME] 13
[NAME] | Wayne | 54 East Avenue | 22265 | 77 |  |  | Rank 8 = Elton John 9
Elvis | Presley | 2 West Street | 55987 | 8 |  |  | Rank 9 = Elvis  Presley 8
[NAME] | [NAME] | 15 West Street | 16579 | 1 |  |  | Rank 10 = [NAME]
Clint | Eastwood | 2 North Row | 78945 | 13 |  |  | Rank 11 = [NAME]
[NAME] | Wayne | 54 East Avenue | 22265 | 55 |  |  | Rank 11 = [NAME] John 1
Spreadsheet: 124880d1318680345-excel-2007-hlookup-returning-na-hlookup
Sheet: Sheet2

Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
2011-10-17 00:00:00
The red cells are the result I am looking for
Spreadsheet: 0dca4700-a95c-48e7-8853-96d62f7dc103
Sheet: Overview pointwise

 | Introduction
 | Foreward | Sabhapati
 |  | Block Development Officer & Executive Officer
 | Block Profile |  | List of BDOs
 |  |  | List  of Sabhapatis
 | Administrative Structure | Block Seup
 |  | Panchayat Samity  Setup
 |  | [NAME]
 | MGNREGS
 | Election
 | MDM
 | Important Schemes
 |  | IAY
 |  | NSAP Pension | IGNOAPS
 |  |  | IGNWPS
 |  |  | IGNDPS
 |  | NFBS
 |  | [NAME]
 |  | AABY
 |  | SGSY
 |  | BSKP
 |  | WBSSP
 |  | SBM
 | Health & Sanitation
 | CHCMI
 | Departmental Activities | BDMO
 |  | BCW
 |  | IDO
 |  | EOME
 |  | BWO
 |  | MWI
 |  | CI
 |  | [NAME]
 | Other Line Department
 |  | ADA
 |  | BL&LRO
 |  | SI of Schools | Sadar Central Circle
 |  |  | Sadar West Circle
 |  | [NAME]
 |  | BMOH
 |  | BLDO
 |  | BYO
 | RTI
 | [NAME]
 | Importanat  Contact No.
 | Notice Board
 | News
 | Dowload Section | Form Download | [NAME]
 |  | Tender Form | RHS/ BPL List
 |  | Election Form | IAY Permanent wait list
 |  | BCW  Form | NSAP Pension List
 |  | Residential/ Income/Life  Certificate Form | Social Welfare Pension List
 |  | Widow Pension Form
 |  | Disable Pension Form
 |  | Minority Scholarship Form
 |  | Minority  Loan Form
 |  | BSKP Loan Form
 |  | WBSSP Report Form
 |  | [NAME]
 | Archaive | Govt. Order
 |  | Block/PS Office Order
 | Places of Interest | Patharchapri ( Nagari GP)
 |  | Bhandirbon  ( Khatanga GP)
 |  | BhuinphoreTala ( [NAME])
 |  | Tilpara Water Reservoir  ( Tilpara GP)
 | Success Stories
 | [NAME]
 | Important Hyperlink | http://www.birbhum.nic.in
 |  | http://www.wbmdfc.org
 |  | http://www.wbprd.gov.in
 |  | http://www.wbprd.org/rhs
 |  | http://www.wbfin.nic.in
 |  | http://www.wbsrdagpms.org
Spreadsheet: 129044d1321424079-how-to-validate-the-two-sheets-report-sales-check
Sheet: Agent 

2011-11-16 00:00:00
 | Electronics | Books | Fruits | Vegetables
A01 | 10000 | 23636 | 43536 | 966626
B02 | 78596 | 63582 | 324893 | 2123646
A02 | 1245698 | 4458723 | 212246497 | 23213586
Total Sales
B03 | 23636 | 63582 | 4458723 | 2123646
A03 | 10000 | 23636 | 43536 | 10000
B04 | 23636 | 4458723 | 212246497 | 23636
Total Sales
A04 | 43536 | 43536 | 966626 | 43536
B05 | 966626 | 4458723 | 212246497 | 966626
A05 | 10000 | 78596 | 1245698 | 23636
B06 | 10000 | 23636 | 43536 | 966626
Total Sales
Spreadsheet: 678151d1589739418-and-or-functions-to-auto-fill-rates-depending-the-date-given-2020-05-17-oeldere2-andalex-678115d1589723109-and-or-functions-to-auto-fill-rates-depending-t
Sheet: Rates

Check in | 2020-05-12 00:00:00 |  | Check Out | 2020-06-02 00:00:00 |  | Nights |  |  | HAPPY ROOM |  | CONTRACT RATE
 |  |  |  |  |  |  |  |  |  |  | ROOM TYPE | LOW SEASON |  | MIDDLE SEASON |  | HIGH SEASON |  | PEAK SEASON
 |  |  |  |  |  | discount | 0.2 |  |  |  |  | 2020-05-11 00:00:00 | 2020-05-31 00:00:00 | 2020-06-01 00:00:00 | 2020-06-14 00:00:00 | 2020-06-15 00:00:00 | 2020-07-05 00:00:00 | 2020-07-06 00:00:00 | 2020-08-25 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | 2020-09-28 00:00:00 | 2020-10-11 00:00:00 | 2020-09-14 00:00:00 | 2020-09-27 00:00:00 | 2020-08-26 00:00:00 | 2020-09-13 00:00:00 | 2020-07-06 00:00:00 | 2020-08-25 00:00:00
 |  |  |  |  |  |  |  |  |  |  | HAPPY ROOM | 95 |  | 130 |  | 165 |  | 240
 |  |  |  |  |  |  |  |  |  |  | STANDARD DBL | 105 |  | 145 |  | 185 |  | 285
 |  |  |  |  |  |  |  |  |  |  | SUPERIOR | 115 |  | 160 |  | 200 |  | 340
 |  |  |  |  |  |  |  |  |  |  | JUNIOR SUITE | 135 |  | 190 |  | 230 |  | 410
 |  |  |  |  |  |  |  |  |  |  | DELUXE | 150 |  | 220 |  | 260 |  | 475
 |  |  |  |  |  |  |  |  |  |  | FAMILY | 170 |  | 240 |  | 310 |  | 520
 |  |  |  |  |  |  |  |  |  |  | SUPERIOR SUITE | 250 |  | 340 |  | 410 |  | 690
 |  |  |  |  |  |  |  |  |  |  | MASTER SUITE | 280 |  | 410 |  | 500 |  | 790
 |  |  |  |  |  |  |  |  |  |  | Room | 2020-05-11 00:00:00 | 2020-06-01 00:00:00 | 2020-06-15 00:00:00 | 2020-07-06 00:00:00 | 2020-08-26 00:00:00 | 2020-09-14 00:00:00 | 2020-09-28 00:00:00 | 2020-10-11 00:00:00
 |  |  |  |  |  |  |  |  |  |  | HAPPY ROOM | 95 | 130 | 165 | 240 | 165 | 130 | 95
 |  |  |  |  |  |  |  |  |  |  | STANDARD DBL | 105 | 145 | 185 | 285 | 185 | 145 | 105
 |  |  |  |  |  |  |  |  |  |  | SUPERIOR | 115 | 160 | 200 | 340 | 200 | 160 | 115
 |  |  |  |  |  |  |  |  |  |  | JUNIOR SUITE | 135 | 190 | 230 | 410 | 230 | 190 | 135
 |  |  |  |  |  |  |  |  |  |  | DELUXE | 150 | 220 | 260 | 475 | 260 | 220 | 150
 |  |  |  |  |  |  |  |  |  |  | FAMILY | 170 | 240 | 310 | 520 | 310 | 240 | 170
 |  |  |  |  |  |  |  |  |  |  | SUPERIOR SUITE | 250 | 340 | 410 | 690 | 410 | 340 | 250
 |  |  |  |  |  |  |  |  |  |  | MASTER SUITE | 280 | 410 | 500 | 790 | 500 | 410 | 280
 |  |  |  |  |  |  | Dear Oeldere,
 |  |  |  |  |  |  | Thank you veryyyy much, thats perfect.
 |  |  |  |  |  |  | If is possible i need few answers,
 |  |  |  |  |  |  | 1) if i put check box and click the one that says "10%" can the auto filled rates in D4 till D25 auto replaced with a 10% discount?.
 |  |  |  |  |  |  | 2) If the dates are not filled, then it return "#N/A" can this be blank?
 |  |  |  |  |  |  | 3) When typing the check in date in B1 and the check out date in E1, can this auto splitted in cells A4 to A25?
 |  |  |  |  |  |  | If is too much there is no problem, you helped me a lot and i appreciate it my friend.
 |  |  |  |  |  |  | Thank you in advance for everything.
Spreadsheet: 14800e0a-7931-4a79-b769-0bfc1792fe4d
Sheet: Sheet1

Table 6--U.S. textile imports, by fiber | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 | Feb. | Mar. | Apr. | Apr.
Item | 2013 | 2013 | 2013 | 2012
 | 1,000 pounds 1/
[NAME], thread, and fabric: | 233182.734 | 223908.162 | 242510.476 | 257007.501
Cotton | 49718.474 | 44205.009 | 52162.75 | 57811.868
Linen | 17408.625 | 19196.402 | 17881.456 | 19569.314
Wool | 3126.851 | 3246.618 | 3877.146 | 4281.361
Silk | 429.056 | 485.868 | 539.357 | 617.086
Manmade | 162499.728 | 156774.265 | 168049.767 | 174727.872
Apparel: | 875083.9299999999 | 743937.651 | 792607.52 | 766288.216
Cotton | 499440.142 | 438624.647 | 452678.547 | 430643.195
Linen | 10397.966 | 8142.328 | 9804.771 | 10937.316
Wool | 17178.492 | 14323.305 | 16487.02 | 17084.64
Silk | 10301.503 | 7625.13 | 9278.679 | 9899.293
Manmade | 337765.827 | 275222.241 | 304358.503 | 297723.772
Home furnishings: | 213658.218 | 176400.957 | 212011.943 | 187706.328
Cotton | 123263.348 | 113890.352 | 129903.651 | 111389.632
Linen | 864.426 | 639.003 | 957.307 | 772.843
Wool | 315.166 | 308.52 | 342.468 | 226.753
Silk | 174.805 | 137.927 | 159.561 | 202.512
Manmade | 89040.473 | 61425.155 | 80648.956 | 75114.588
Floor coverings: | 56210.929 | 58000.931 | 62052.041 | 56208.163
Cotton | 6695.796 | 7231.482 | 7376.425 | 6025.162
Linen | 15384.178 | 15354.919 | 16443.409 | 14290.639
Wool | 7792.537 | 9210.195 | 9574.531 | 8448.146
Silk | 1205.358 | 1754.796 | 1696.917 | 1491.392
Manmade | 25133.06 | 24449.539 | 26960.759 | 25952.824
Total imports: 2/ | 1378474.213 | 1202603.274 | 1309534.534 | 1267631.108
Cotton | 679320.418 | 604190.911 | 642358.058 | 606140.921
Linen | 44055.195 | 43332.652 | 45086.943 | 45570.112
Wool | 28420.061 | 27104.647 | 30288.013 | 30049.913
Silk | 12110.723 | 10003.721 | 11674.513 | 12210.283
Manmade | 614567.816 | 517971.343 | 580127.007 | 573659.879
1/ Raw-fiber equivalent.  2/ Includes headgear.
Sources: USDA, Economic Research Service; and
U.S. Dept. of Commerce, U.S. Census Bureau.
Last update: 06/14/13.
Spreadsheet: 728071d1618294850-arrange-top-5-items-from-a-list-in-decreasing-order-book2
Sheet: Risk Register

 |  | Estimated cost of residual risk
Reference | Cause, trigger or issue | Minimum $ | Most Likely $ | Maximum $
3 | 1. Delay to REF determination which is required prior to AHIP application to [NAME] 2. Excessive review timeframes from [NAME] | 60000 | 120000 | 300000 |  |  | Top 5 risk items | Most Likely Values
4 | Residential noise treatments required not previously identified by pre-construciton noise modelling | 50000 | 100000 | 150000 |  | 1
5 | 1. Poor exisiting pavement may trigger addional costs for insitu stabilisation. | 100000 | 145000 | 480000
10 | Clearing of EECs and habitat for threatened species. Triggered by vegetation clearing. | 100000 | 200000 | 600000
16 | Encountering legacy contamination during construction including:  1. Coal tar (in pavement) 2. Asbestos  3. Other | 24000 | 48000 | 96000
26 | 1. Potential seasonal restrictions to road closures, lane configurations (e.g. school holidays, [NAME]) 2. Not willing to provide comment on likely ROL conditions until actual ROL submitted by contractor- uncertainty remains | 100000 | 200000 | 400000
27 | 1. Competition with large pipeline of work currently in NSW | 250000 | 625000 | 1250000
28 | 1. Lack of appropriately skilled contractors available  2. Competition with large pipeline of work | 78000 | 156000 | 312000
35 | 1. Limited ancillary site locations are available.  2. Sites identified wihtin REF have various contraints (overhead power lines etc) 3. Preferred site not yet secured, pending agreement from Ausgrid | 40000 | 60000 | 100000
37 | 1. Existing tree roots preventing installation of temporary sheet piling. | 5000 | 72500 | 195000
46 | 1. PSC specifications ambiguous 2. Work by others impacts on deliverables 3. Additional / unanticipated investogation required | 50000 | 100000 | 150000
47 | Aboriginal find during construction | 10000 | 20000 | 250000
52 | Unforeseen / unknown utilities at time of preparing concept design | 40000 | 100000 | 500000
54 | Bushfire in the surrounding areas (National Parks, [NAME]) | 60000 | 100000 | 200000
71 | Unanticipated construction conctract claims above and beyond the allowances made within this RA. | 125000 | 312500 | 625000
73 | Excavation for pavement foundations and/or retaining wall foundations encourter unanticipated (poor) ground conditions | 3600 | 14300 | 31500
Spreadsheet: 684180d1593185409-conditional-formatting-if-formula-receiving-aligw
Sheet: ETA's

DONE | ETA DATE | PO (SEARCH) | CUSTOMER | TRUCK | LOT #      (¬) | CODE      (¬) | # CASES | #          ICED | WEIGHT | OTHER
X | 2020-06-25 00:00:00 | 333 | [NAME] | Them | 5555 | 101 | 5 | 1 | 500
 | 2020-06-26 00:00:00 | 444 | Smith | Those | 6060 | 202 | 10 | 2 | 1000
X | 2020-06-26 00:00:00 | 555 | Jones | This | 7777 | 3030 | 5 | 3 | 550
 | 2020-06-27 00:00:00 | 666 | Doe | That | 8080 | 404 | 15 | 4 | 1500
Spreadsheet: 884031d1732914252-automate-scoring-relon-scoresheet-voor-forum_2
Sheet: Blad1

 | Round 1 | Competition | Round 2 | Competition | Round 3 | Competition | Round 4 | Competition | Round 5 | Competition | Round 6 | Competition | Round 7 | Competition | Round 8 | Competition | Round 9 | Competition | Round 10 | Competition
Contestant 1 | 30 |  | 27 |  | 22 |  | 25 |  | 30 |  | 27 |  | 20 |  | 23 |  | 19 |  | 54
[NAME] | 30 |  | 21 |  | 28 |  | 27 |  | 26 |  | 23 |  | 26 |  | 26 |  | 26 |  | 49
Contestant 3 | 26 |  | 22 |  | 26 |  | 28 |  | 25 |  | 22 |  | 24 |  | 22 |  | 20 |  | 51
[NAME] | 19 |  | 24 |  | 26 |  | 29 |  | 24 |  | 23 |  | 25 |  | 26 |  | 29 |  | 56
Contestant 5 | 12 |  | 18 |  | 16 |  | 28 |  | 20 |  | 24 |  | 20 |  | 11 |  | 22 |  | 43
Contestant 6 | 19 |  | 19 |  | 19 |  | 22 |  | 25 |  | 19 |  | 15 |  | 21 |  | 21 |  | 53
Contestant 7 | 19 |  | 24 |  | 22 |  | 21 |  | 27 |  | 16 |  | 16 |  | 21 |  | 21 |  | 46
Contestant 8 | 15 |  | 22 |  | 17 |  | 23 |  | 16 |  | 18 |  | 16 |  | 18 |  | 20 |  | 36
Contestant 9 | 25 |  | 21 |  | 19 |  | 22 |  | 15 |  | 23 |  | 16 |  | 21 |  | 28 |  | 50
Contestant 10 | 13 |  | 13 |  | 12 |  | 23 |  | 5 |  | 10 |  | 16 |  | 28 |  | 23 |  | 25
 |  | expected results for C2:C11
Contestant 1 |  | 12
[NAME] |  | 12
Contestant 3 |  | 10
[NAME] |  | 8
Contestant 5 |  | 5
Contestant 6 |  | 8
Contestant 7 |  | 8
Contestant 8 |  | 7
Contestant 9 |  | 9
Contestant 10 |  | 6
 |  | 12
 |  | 10
 |  | 9
 |  | 8
 |  | 7
 |  | 6
 |  | 5
 |  | 4
 |  | 3
 |  | 2
Spreadsheet: 823262d1679859861-how-to-track-inventory-when-clearing-worksheet-excel-tracker
Sheet: Asphalt

 |  |  |  |  | [NAME]
 | Supplier : Beacon / ABC / ___________ |  |  |  | Job# | Date: __ /__ / __
 | Description |  |  | Qty | Unit price | Total price
 | Tri-Built Self adhering Ice & Water (2 sq) |  |  | 0 | 66.77
 | Tri-Built Galvanized steel roll valley - (20''x50') |  |  | 0 | 93.2
 | Tri-Built Lo-Omni roll ridge vent - Nailable (30') |  |  | 0 | 81.78
 | Tri-Built Starter |  |  | 0 | 39.93
 | Tri-Built Synthetic roofing underlayment (10 sq) |  |  | 0 | 65.89
 | Tri-Built Coil nails - 1 1/4'' (7200) |  |  |  | 50
 | Notes: |  |  |  | Subtotal
 |  |  |  |  | Adjustments
Spreadsheet: 102222d1300211897-how-much-can-i-invoice-per-quarter-myexample
Sheet: Sheet1

 | Unit Price | Next Billing event (1) | Date Expected | Amount to be Invoiced (event 1) | Subsequent event (2) | Date Expected | Amount to be invoiced (event 2) | Subsequent event (3) | Date Expected (3) | Amount to be invoiced (3) | Subsequent event (4) | Date Expected (4) | Amount to be invoiced ([NAME]) | Q1 | Q2 | Q3 | Q4
Job A - Planned | 200000 | Paint house | 2011-02-01 00:00:00 | 0.25 | Fix windows | 2011-05-01 00:00:00 | 0.25 | Fix roof | 2011-08-01 00:00:00 | 0.25 | Fix garden | 2011-12-01 00:00:00 | 0.25 | 50000 | 50000 | 50000 | 50000
Job B - Planned | 15000 | Finish chassis | 2011-07-01 00:00:00 | 0.1 | Buy wheels | 2011-09-01 00:00:00 | 0.2 | Fit interior | 2011-12-01 00:00:00 | 0.3 | Win race | 2011-12-20 00:00:00 | 0.4 | 0 | 0 | 4500 | 10500
Job A - Updated | 200000 | Paint house | 2011-07-01 00:00:00 | 0.25 | Fix windows | 2011-08-01 00:00:00 | 0.25 | Fix roof | 2011-08-10 00:00:00 | 0.25 | Fix garden | 2011-12-01 00:00:00 | 0.25 | 0 | 0 | 100000 | 100000
Job B - Updated | 15000 | Finish chassis | 2011-10-10 00:00:00 | 0.1 | Buy wheels | 2011-12-01 00:00:00 | 0.2 | Fit interior | 2011-12-05 00:00:00 | 0.3 | Win race | 2012-01-10 00:00:00 | 0.4 | 0 | 0 | 0 | 9000
 | Q1 | Q2 | Q3 | Q4
 | 2011-01-01 00:00:00 | 2011-04-01 00:00:00 | 2011-07-01 00:00:00 | 2011-10-01 00:00:00
 | 2011-03-31 00:00:00 | 2011-06-30 00:00:00 | 2011-09-30 00:00:00 | 2011-12-31 00:00:00
Spreadsheet: 29194d1224036543-how-can-i-get-a-sum-total-of-total-dulplicates-for-each-item-in-a-row-pivot-table-sample
Sheet: Sheet1

Item |  |  | Count of Item
[PHONE] |  |  | Item | Total
[PHONE] |  |  | [PHONE] | 2
[PHONE] |  |  | [PHONE] | 7
[PHONE] |  |  | [PHONE] | 1
[PHONE] |  |  | Grand Total | 10
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
Spreadsheet: 752441d1634754619-averageifs-with-condition-not-to-include-cells-with-letter-2021-10-20c-culling-analysis-test-not-contain-x
Sheet: Male

088w | 2017 |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q | Lars
930y | 2019 |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R | Roarke
[NAME] | 2020 |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16.01.10.05 | Taranis
[NAME] | 2020 |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 02.10.09
032o | 2020 |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22.11 ?
033o | 2020 |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07.02.05.02.06 | Thor
034o | 2020 |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07.02.11.04
035o | 2020 |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15.06.07.03 ?
Spreadsheet: 92311d1291911416-count-based-on-mutiple-text-criteria-examples
Sheet: Sheet1

Team | Min | Player | Event | Outcome
c | 1 | gmc | att | gl
c | 1 | [NAME] | att | pt
o | 1 | opp | oatt | ogl
o | 2 | opp | oatt | opt
o | 2 | opp | oatt | opt
c | 3 | [NAME] | att | pt
c | 4 | [NAME] | att | gl
c | 5 | gmc | att | gl
Total the number of 'gls' in Outcome column when corresponding Team column = 'c'
 |  |  | COUNTIF
 |  |  | 0