tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 841199d1693418787-multiple-conditional-formula-depending-on-options-team-examples-engineer445-
Sheet: Rules

Variable 1 | Variable 2 | Variable 3 | Variable 4
TeamRed | TeamRedDate1 | TeamRedDate2 | Option1
TeamWhite | TeamWhiteDate1 | TeamWhiteDate2 | Option2
 |  |  | Option3
Rule 1 | Option3 is only available if the following conditions are met: TeamRed is selected AND TeamRedDate2 >= 04/01/2024 TeamWhite is selected AND TeamWhiteDate2 >= 04/01/2024
Rule 2 | TeamRed's output will always be X number of days from the later date of TeamRedDate1 and TeamRedDate2
Rule 3 | TeamWhite's output will always be X number of days from the TeamWhiteDate2
Rule 4 | IF TeamRed AND TeamRedDate1 >= TeamRedDate2 AND Option3 THEN Do TeamRedDate1 + 40 days
Rule 5 | IF TeamRed AND TeamRedDate1 < TeamRedDate2 AND Option3 THEN Do TeamRedDate2 + 40 days
Rule 6 | IF TeamWhite AND Option3 THEN Do TeamWhiteDate1 + 40 days
Rule 7 | IF TeamWhite AND TeamWhiteDate2 >= 04/01/2024 AND Option1 or Option2 THEN Do TeamWhiteDate2 + 60 days
Rule 8 | IF TeamWhite AND TeamWhiteDate2 < 04/01/2024 AND Option1 or Option2 THEN Do TeamWhiteDate2 + 30 days
Rule 9 | If [NAME] AND TeamRedDate1 >= 04/01/2024 AND TeamRedDate1 >= TeamRedDate2 AND Option1 or Option2 THEN Do TeamRedDate1 + 60 days
Rule 10 | If [NAME] AND TeamRedDate1 >= 04/01/2024 AND TeamRedDate1 < TeamRedDate2 AND Option1 or Option2 THEN Do TeamRedDate2 + 60 days
Rule 11 | If TeamRed AND TeamRedDate1 < 04/01/2024 AND TeamRedDate1 >= TeamRedDate2 AND Option1 or Option2 THEN Do TeamRedDate1 + 30 days
Rule 12 | If TeamRed AND TeamRedDate1 < 04/01/2024 AND TeamRedDate1 < TeamRedDate2 AND Option1 or Option2 THEN Do TeamRedDate2 + 30 days
Spreadsheet: mary_fischer__25621__77N
Sheet: E5.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 077N
COMPANY NAME    Marlin Electrical, Inc
ANALYSIS OF GOODWILL
FOR THE 6 MONTHS ENDED 6-30-2001
 |  |  |  |  |  |  |  |  |  |  |  |  |  | E-5
 |  |  |  | 12-31-2000 Balance
 |  |  |  | BEGINNING |  |  |  |  |  |  |  |  |  | 12-31-2001
[NAME] OR ENTITY |  | AMORTIZATION |  | BALANCE |  |  |  |  |  | OTHER |  |  |  | BALANCE
 |  | PERIOD (Yrs.) |  | DR. (CR.) |  | ADDITIONS |  | AMORTIZATION** |  | AMOUNT |  | (DESCRIBE) |  | DR. (CR.)
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Total Goodwill* |  |  |  |  |  |  |  |  | ** |  |  |  |  |  | *
* MUST TIE TO HYPERION ACCOUNT 0344 | Same signs as Hyperion
**MUST TIE TO HYPERION ACCOUNT 1418 | Reverse signs from Hyperion
Spreadsheet: 133687d1324545480-automatically-copy-an-entire-row-test
Sheet: Accounts

100000 |  |  | 100000 |  |  | 100000 |  |  | 100000 |  |  | 100000 |  |  | 100000 |  |  | 100000
50000 |  |  | 50000 |  |  | 50000 |  |  | 50000 |  |  | 50000 |  |  | 50000 |  |  | 50000
20000 |  |  | 20000 |  |  | 20000 |  |  | 20000 |  |  | 20000 |  |  | 20000 |  |  | 20000
10000 |  |  | 10000 |  |  | 10000 |  |  | 10000 |  |  | 10000 |  |  | 10000 |  |  | 10000
5000 |  |  | 5000 |  |  | 5000 |  |  | 5000 |  |  | 5000 |  |  | 5000 |  |  | 5000
1000 |  |  | 1000 |  |  | 1000 |  |  | 1000 |  |  | 1000 |  |  | 1000 |  |  | 1000
Coin |  |  | Coin |  |  | Coin |  |  | Coin |  |  | Coin |  |  | Coin |  |  | Coin
cash |  |  | cash |  |  | cash tarek |  |  | cash |  |  | cash |  |  | cash |  |  | cash
[NAME] |  |  | [NAME] |  |  | [NAME] |  |  | [NAME] |  |  | [NAME] |  |  | [NAME] |  |  | [NAME]
$ |  |  | $ |  |  | $ |  |  | $ |  |  | $ |  |  | $ |  |  | $
100 |  |  | 100 |  |  | 100 |  |  | 100 |  |  | 100 |  |  | 100 |  |  | 100
50 |  |  | 50 |  |  | 50 |  |  | 50 |  |  | 50 |  |  | 50 |  |  | 50
20 |  |  | 20 |  |  | 20 |  |  | 20 |  |  | 20 |  |  | 20 |  |  | 20
10 |  |  | 10 |  |  | 10 |  |  | 10 |  |  | 10 |  |  | 10 |  |  | 10
5 |  |  | 5 |  |  | 5 |  |  | 5 |  |  | 5 |  |  | 5 |  |  | 5
1 |  |  | 1 |  |  | 1 |  |  | 1 |  |  | 1 |  |  | 1 |  |  | 1
Chek $ |  |  | Chek $ |  |  | Chek $ |  |  | Chek $ |  |  | Chek $ |  |  | Chek $ |  |  | Chek $
 |  |  |  | 100000 |  |  | 100000
 |  |  |  | 50000 |  |  | 50000
 |  |  |  | 20000 |  |  | 20000
 |  |  |  | 10000 |  |  | 10000
 |  |  |  | 5000 |  |  | 5000
 |  |  |  | 1000 |  |  | 1000
 |  |  |  | Coin |  |  | Coin
 |  |  |  | cash |  |  | cash
 |  |  |  | [NAME] |  |  | [NAME]
 |  |  |  | $ |  |  | $
 |  |  |  | 100 |  |  | 100
 |  |  |  | 50 |  |  | 50
 |  |  |  | 20 |  |  | 20
 |  |  |  | 10 |  |  | 10
 |  |  |  | 5 |  |  | 5
 |  |  |  | 1 |  |  | 1
 |  |  |  | Chek $ |  |  | Chek $
 |  |  |  |  | 10 |  | 15.5
 |  |  |  |  | 10 |  | 33
 |  |  |  |  | 10 |  | 10
 |  |  |  |  | 10 |  | 15
 |  |  |  |  | 10 |  | 30
 |  |  |  |  | 10 |  | 25
 |  |  |  |  | 10 |  | 15
 |  |  |  |  | 10 |  | 15
 |  |  |  |  | 10 |  | 10
 |  |  |  |  | 10 |  | 10
 |  |  |  |  | 10 |  | 15
 |  |  |  |  | 10 |  | 10
 |  |  |  |  | 10 |  | 20
 |  |  |  |  | 10 |  | 10
 |  |  |  |  | 10 |  | 30
 |  |  |  |  | 10 |  | 10
 |  |  |  |  | 10 |  | 10
 |  |  |  |  | 10 |  | 25
 |  |  |  |  | 10 |  | 70
 |  |  |  |  | 10 |  | 10
 |  |  |  |  | 10 |  | 10
 |  |  |  |  | 10 |  | 15
 |  |  |  |  | 10 |  | 100
 |  |  |  |  | 10 |  | 20
 |  |  |  |  | 10 |  | 10
 |  |  |  |  | 10 |  | 15
 |  |  |  |  | 25 |  | 30
 |  |  |  |  | 15 |  | 10
 |  |  |  |  | 15 |  | 30
 |  |  |  |  | 15 |  | 15
 |  |  |  |  | 15 |  | 15
 |  |  |  |  | 15 |  | 15
 |  |  |  |  | 15 |  | 25
 |  |  |  |  | 15 |  | 10
 |  |  |  |  | 20 |  | 10
 |  |  |  |  | 20 |  | 10
 |  |  |  |  | 25 |  | 25
 |  |  |  |  | 30 |  | 35
 |  |  |  |  | 40 |  | 20
 |  |  |  |  | 40 |  | 10
 |  |  |  |  | 45 |  | 15
 |  |  |  |  | 45 |  | 10
 |  |  |  |  | 50 |  | 10
 |  |  |  |  | 50 |  | 15
 |  |  |  |  | 50 |  | 10
 |  |  |  |  | 55 |  | 10
 |  |  |  |  | 75
 |  |  |  |  | 19
Spreadsheet: 161632d1339584449-lookup-repeated-text-and-show-data-ef106_book1
Sheet: Sheet2

 | Name | Stocks | Quantity
 | Ramy | Coka | 1000
 | Ramy | PNP | 1200
 | Ramy | D-O | 350
 | Romio | OT | 14000
 | Romio | Coka | 5000
 | [NAME] | PNP | 4100
 | [NAME] | OCI | 6300
 | [NAME] | PF | 5402
 | [NAME] | DSS | 540
Spreadsheet: 108883d1305823394-if-function-divided-by-number-of-cell-entries-example
Sheet: Job C

 |  | January
 | Job C | 1900-01-01 00:00:00 | 1900-01-02 00:00:00 | 1900-01-03 00:00:00 | 1900-01-04 00:00:00 | 1900-01-05 00:00:00 | 1900-01-06 00:00:00 | 1900-01-07 00:00:00 | 1900-01-08 00:00:00 | 1900-01-09 00:00:00 | 1900-01-10 00:00:00 | 1900-01-11 00:00:00 | 1900-01-12 00:00:00 | 1900-01-13 00:00:00 | 1900-01-14 00:00:00 | 1900-01-15 00:00:00 | 1900-01-16 00:00:00 | 1900-01-17 00:00:00 | 1900-01-18 00:00:00 | 1900-01-19 00:00:00 | 1900-01-20 00:00:00 | 1900-01-21 00:00:00 | 1900-01-22 00:00:00
 | [NAME]
 | [NAME] |  | 0.5
 | [NAME] |  |  | 1 |  |  |  | 0.5
 | Job worked on?
Spreadsheet: 722999d1615475211-count-duplicate-values-in-the-same-cell-and-in-a-range-example-1-
Sheet: Sheet1

 | INVOICE DATE | SITE | PLOT(S)
 | 2021-02-26 00:00:00 | Gipping [NAME] | 123, 124, 125, 126
 | 2021-03-04 00:00:00 | Gipping [NAME] | 108, 110
 | 2021-03-05 00:00:00 | Gipping [NAME] | 108, 987
 | 2021-03-02 00:00:00 | Gipping [NAME] | 108
 | 2021-02-03 00:00:00 | Gipping [NAME] | 109
 | 2021-02-01 00:00:00 | Gipping [NAME] | 123, 124
 | 2021-02-26 00:00:00 | Gipping [NAME] | 82, 83
 | 2021-02-25 00:00:00 | Gipping [NAME] | 110, 112
 | 2021-02-24 00:00:00 | Gipping [NAME] | 123, 124, 125, 126, 127
 | 2021-02-20 00:00:00 | Gipping [NAME] | 123, 124, 125
 | 2021-02-19 00:00:00 | Gipping [NAME] | 124, 125, 126
 | 2021-02-18 00:00:00 | Gipping [NAME] | 123
 | 2021-02-17 00:00:00 | Gipping [NAME] | 124
 | 2021-02-15 00:00:00 | Gipping [NAME] | 126, 127
 | 2021-02-16 00:00:00 | Gipping [NAME] | 127
Spreadsheet: 32958e4c-9472-4879-8b0d-38fe084d7d86
Sheet: Sheet1

wafer | 16 | 18 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | Unnamed: 16 | 31slow
 | 6 passes @ 10 uL/s |  |  |  |  | 12 passes @ 5 uL/s |  |  |  |  | 10 passes @ 6 uL/s |  |  |  |  |  | 50 RPM
round1
c | 35598 | 37601 | 35373 | 29698 | 18630 | 36547 | 37203 |  | 24067 |  | 34290 |  |  | 27360 | 17109 |  | 24851
3c/4 | 29030 | 32294 | 34448 | 27158 | 20944 | 30288 | 31291 |  | 22650 |  | 27920 |  |  | 19481 | 12559 |  | 23209
c/2 | 21095 | 28492 | 25868 | 22067 | 18475 | 22568 | 25321 |  | 23916 |  | 19144 |  |  | 21221 | 15340 |  | 17525
c/4 | 14960 | 13470 | 17179 | 12965 | 19032 | 20358 | 17304 |  | 14539 |  | 21967 |  |  | 15134 | 12345 |  | 18868
e | 16467 | 20457 | 16677 | 16264 | 15799 | 17619 | 17151 |  | 15723 |  | 13264 |  |  | 12149 | 12625 |  | 16168
round2
c | 33946 | 34595 | 40340 | 28663 | 16668 | 30014 | 41908 |  | 23267 |  | 30894 |  |  | 24910 | 22231 |  | 27061
3c/4 | 31533 | 34018 | 29997 | 23759 | 19496 | 25866 | 33782 |  | 21149 |  | 29421 |  |  | 19718 | 18710 |  | 20075
c/2 | 28439 | 27017 | 31227 | 19552 | 21124 | 21298 | 26223 |  | 19119 |  | 24914 |  |  | 25129 | 16084 |  | 20314
c/4 | 16227 | 28299 | 22745 | 21422 | 12513 | 15056 | 16208 |  | 17519 |  | 20182 |  |  | 19895 | 13195 |  | 16116
e | 16175 | 18565 | 16381 | 12532 | 14491 | 19909 | 16275 |  | 14547 |  | 16374 |  |  | 14297 | 11448 |  | 14129
round1
mean | 23430 | 26462.8 | 25909 | 21630.4 | 18576 | 25476 | 25654 |  | 20179 |  | 23317 |  |  | 19069 | 13995.6 |  | 20124.2
stdev | 8733.509002686149 | 9579.438015875465 | 8998.975247215652 | 7066.090807511601 | 1839.850945049626 | 7779.865390866348 | 8764.838389839257 |  | 4659.750261548359 |  | 8091.56313699646 |  |  | 5850.47335691737 | 2131.16841192807 |  | 3736.443054564058
round2
mean | 25264 | 28498.8 | 28138 | 21185.6 | 16858.4 | 22428.6 | 26879.2 |  | 19120.2 |  | 24357 |  |  | 20789.8 | 16333.6 |  | 19539
stdev | 8500.520572294381 | 6491.172020521413 | 9071.908619469225 | 5919.105194199538 | 3524.046438400041 | 5730.093437283545 | 11183.33182463974 |  | 3346.265859133131 |  | 6120.572440548352 |  |  | 4469.635857651051 | 4307.226520627863 |  | 4961.1851910607
overall
mean | 24347 | 27480.8 | 27023.5 | 21408 | 17717.2 | 23952.3 | 26266.6 |  | 19649.6 |  | 23837 |  |  | 19929.4 | 15164.6 |  | 19831.6
stdev | 8182.236912292927 | 7788.645778738863 | 8599.389051296352 | 6149.583545068542 | 2800.618852245972 | 6638.755925121316 | 9494.501323280636 |  | 3865.024283379229 |  | 6785.959393401119 |  |  | 4991.388299416863 | 3432.555355222502 |  | 4152.022377374939
 | 400 mTorr |  | 800 mTorr |  | 600 mTorr |  | 1200 mTorr |  | 1600 mTorr
Spreadsheet: 2a19ade2-1440-4550-9ffc-034a0d5ae409
Sheet: Część III

Załącznik nr 5 do SIWZ | - część III
Lp. | Opis [NAME] | Parametry techniczne | Nazwa producenta/nazwa produktu/[NAME] ([NAME]) | [NAME] miary | Ilość opakowań | Cena [NAME] [PLN] | Wartość całkowita brutto [PLN]
1. | Probówki 0,2 ml [NAME] do reakcji PCR i real time PCR | sterylne, wolne od nukleaz |  | 250 szt/op. | 1
2. | Probówki 1,5 ml typu eppendorf do izolacji RNA | wolne od nukleaz z nakrętką na łańcuszku |  | 500 szt/op. | 2
3. | Końcówki bezbarwne 20 µl z filtrem | końcówki pasujące do pipety typu Finnpipette F2 o [NAME] ul, wolne od [NAME], w statywach |  | 96 szt/op. | 5
4. | Końcówki bezbarwne 200 µl z filtrem | końcówki pasujące do pipety  typu Finnpipette F2 o zakresie 20-200ul, wolne od [NAME], w statywach |  | 1000 szt/op. | 1
5. | Końcówki bezbarwne 1000 µl z filtrem | końcówki pasujące do pipety [NAME] o zakresie 200-1000ul, wolne od [NAME], w statywach |  | 1000 szt/op. | 1
6. | Kuweta UV do pomiarów stężenia RNA | wolne od endonukleaz, w styropianowym statywie |  | 100 szt/op. | 1
7. | Płytka 96-dołkowa do qPCR | płytka do przeprowadzania PCR w czasie rzeczywistym, [NAME] 5  (Bio-Rad)będącego w posiadaniu [NAME], płytki z perforacja co 3 kolumny |  | 25 szt/op. | 4
8. | Taśma adhezyjna do płytek qPCR | taśma do zamykania płytek do PCR w czasie rzeczywistym |  | 100 szt/op. | 1
SUMA:
 | podpis Wykonawcy…………………………………
Spreadsheet: 846870d1698019319-complete-table-s-based-off-data-collection-23-october
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | Sit Yes |  | Sit No
[NAME] | [NAME] | Under 48 Hours | [NAME] | Partner | Solar | [NAME] 400 | Sit |  |  | Think Renewable
[NAME] | [NAME] | Yes | Yes | Yes | No | Yes | Yes
[NAME] | [NAME] | No | No | Yes | No | Yes | Yes |  |  | Under 48 Hours + [NAME] |  | 1
[NAME] | Christine | No | No | No | No | No | Yes |  |  | Under 48 Hours + No Bill Seen
[NAME] | [NAME] | No | Yes | Yes | No | No | No
[NAME] | [NAME] | No | No | Yes | No | Yes | No |  |  | Over 48 Hours + [NAME]
[NAME] | [NAME] | No | No | Yes | Yes | No | No |  |  | Over 48 Hours + No Bill Seen |  | 1
[NAME] | Veronica | Yes | No | Yes | Yes | No | Yes
Alfie | [NAME] | Yes | No | Yes | No | No | No |  |  | Under 48 Hours + Bill 400+ |  | 1
[NAME] | Kylie | No | No | Yes | No | Yes | No |  |  | Under 48 Hours + Bill 400-
[NAME] | CC | No | No | Yes | No | No | No
[NAME] | [NAME] | Yes | No | No | No | Yes | No |  |  | Over 48 hours + Bill 400+ |  | 1
 |  |  |  |  |  |  |  |  |  | Over 48 hours + Bill 400-
 |  |  |  |  |  |  |  |  |  | [NAME] 400+ |  | 1
 |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | No Bill Seen + 400+ |  | 1
 |  |  |  |  |  |  |  |  |  | No Bill Seen + 400-
Spreadsheet: 48785d1248098747-vacation-balance-formula-help-with-revising-formula-vacation-tracker-calculator-2
Sheet: Commercial Calculator

COMMERCIAL VACATION CALCULATOR
[NAME]:
Contractor Employee ID#:
Start Date: | 2007-03-27 00:00:00
Current Month: | 2008-09-24 12:00:00
VACATION ACCRUAL
PREVIOUS 18 MONTHS | Hours Worked |  | Hours Taken
 | Straight Time | Overtime |  | Total Hours
2008-09-24 12:00:00 | 104 |  |  | 104
2008-08-24 12:00:00 | 96 |  |  | 96
2008-07-24 12:00:00 | 132 |  |  | 132
2008-06-23 12:00:00 | 139.5 | 18.5 |  | 158
2008-05-23 12:00:00 | 125.5 |  |  | 125.5
2008-04-22 12:00:00 | 97 |  |  | 97
2008-03-22 12:00:00 | 109 |  |  | 109
2008-02-20 12:00:00 | 101 |  |  | 101
2008-01-20 12:00:00 | 96 |  |  | 96
2007-12-20 12:00:00 | 110 |  |  | 110
2007-11-19 12:00:00 | 124.5 |  |  | 124.5
2007-10-19 12:00:00 | 111 |  |  | 111
2007-09-18 12:00:00 | 124.5 |  |  | 124.5
2007-08-18 12:00:00 | 150.5 | 9 |  | 159.5
2007-07-18 12:00:00 | 116.5 |  |  | 116.5
2007-06-17 12:00:00 | 119 |  |  | 119
2007-05-17 12:00:00 | 163 |  |  | 163
2007-04-16 12:00:00 | 117 |  |  | 117
2007-03-16 12:00:00 |  |  |  | 0
Total Hours Worked | 2163.5
Vacation Days Available | 5.40875
Hours Needed for Additional 5 days of Vacation | 1836.5
vacation days earned | vacation days taken | difference between two cells
Spreadsheet: 156712d1337420594-conditional-formatting-general-prob-and-how-to-change-colour-of-a-cell-if-text-is-in-it-0ls
Sheet: dropdown order

System List
Ballast_Controllers
Relay_Controllers
Ecolinx_LCM
Multipurpose_Cont
LeadTrail_Edge_Cont
DR2PE_Scene_Plates
DPNE_Scene_Plates
DPWE_Scene_Plates
DLPE_Scene_Plates
Touchscreens
Timeclocks
Sensors
Standalone_Sensors
System_Integration
Network_Acessories
Software
Desktops_Servers
Remote_Controls
Fixture_Couplers
Leads_Plugs
Occuswitch
To_Be_Touched
Light_Master_Modular
LMM_Scene_Setting
LMM_Panels_Additional_Products
General_Purpose
Colour_Chaser_DMX_Controls
LMM_Leads_Plugs
Trios
Spreadsheet: 04267118-320f-462a-99ee-3ec38b80fb54
Sheet: Sheet1

Risultati Prova scritta modulo A del 22.5.12 - A.A. 2011-2012 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
COGNOME | NOME
 |  |  | Modulo A |  | Modulo B
 |  | No. Matricola | COMPRENSIONE | GRAMMATICA | TRADUZIONE | GRAMMATICA
Carlucci | Stefano Tomaso Maria | 49962 |  | insuff.
Daumenova | Aigul | 52079 |  |  | // | 19/30
Enescu | [NAME] | 56420 | insuff. | insuff. | insuff. | insuff.
Fratini | Giulia | 55920 |  |  | 27/30 | 27/30
Grasselli | Sonia | 58249 |  |  | 26/30 | 26/30
Maggiori | Cristina | 48030 |  |  | 18/30 | //
Minnozzi | Francesca | 56168 |  |  | 28/30 | 27/30
Palazzetti Romualdi | [NAME] | 21980 | insuff. | insuff. | // | insuff.
Palmucci | Sara | 56147 |  |  | 27/30 | 21/30
Persico | [NAME] | 52643 |  | insuff. | insuff. | insuff.
[NAME] | Christian | 38677 | insuff. | insuff.
Pracucci | Giulia | 56788 | insuff. | insuff.
Quintavalle | Gaia | 56645 |  |  | insuff. | 23/30
[NAME] | [NAME] | 57409 |  |  | 28/30 | 27/30
Shchegoleva | Kristina | 56340 | insuff. | insuff.
Simonetti | Lorenzo | 55703 |  |  | 25/30 | 25/30
Turonova | Pavla | 52213 |  |  | 19/30 | //
Zuffati | Serena | 56171 |  |  | 24/30 | 21/30
Si sconsiglia vivamente la ripetizione dell'esame scritto nella sessione estiva a chi non l'ha superato [NAME] appello.
Spreadsheet: 769825d1645704389-group-related-fields-together-sample-73-
Sheet: Tabelle1

Name | City | living in the same City
Hans | München
[NAME] | Berlin
[NAME] | Hamburg
Nadine | Hamburg
[NAME] | Berlin
[NAME] | Berlin
Spreadsheet: 753225d1635319795-formula-or-function-to-search-and-join-several-returned-value-together-sample
Sheet: Sheet1

first name | last name | phone | joint list
CAROLYNE | DIAZ | [PHONE] | JACK, JESUS, CAMILA, AND CONNOR
JACK | DIAZ | [PHONE] | CAROLYNE, JESUS, CAMILA, AND CONNOR
JESUS | DIAZ | [PHONE] | CAROLYNE, JACK, CAMILA, AND CONNOR
CAMILA | ROBB | [PHONE] | CAROLYNE, JACK, JESUS, AND CONNOR
FLORENCE | CHAN | [PHONE] | [NAME], [NAME], AND DANTE
[NAME] | MEDINA | [PHONE] | FLORENCE, MONICA, AND DANTE
[NAME] | VARGAS | [PHONE] | FLORENCE, [NAME], AND DANTE
PATRICIA | [NAME] | [PHONE] | FANNY AND GISELLE
FANNY | [NAME] | [PHONE] | PATRICIA AND GISELLE
CONNOR | ROBB | [PHONE] | CAROLYNE, JACK, JESUS, AND CAMILA
DANTE | VARGAS | [PHONE] | FLORENCE, [NAME], AND [NAME]
GISELLE | KELLY | [PHONE] | PATRICIA AND FANNY
TIGER | FOX | [PHONE]
TAMARA | SANCHEZ | [PHONE]
TYLER | BOND | [PHONE] | ALEXIS
ALEXIS | BOND | [PHONE] | TYLER
CARLOS | WASHINGTON | [PHONE]
MANA | DIAZ | [PHONE]
Spreadsheet: michelle_lokay__26792__imball0203
Sheet: SWGasTrans

 | SW Gas Transmission Co - contr27380
 | POI 78003 - TW/SGTC Mojave Del
Day | Measured | Scheduled
1 | -14215 | -14000
2 | -14170 | -14000
3 | -14559 | -14000
4 | -13643 | -14000
5 | -29174 | -29194
6 | -29132 | -28461
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2002-02-28 00:00:00 |  |  | -11774
2002-03-06 00:00:00
CBS Volume
 |  |  | 7289
Spreadsheet: 454693d1459949602-split-numbers-sample
Sheet: Sheet1

High/Low | High | Low
5.2 / - | 5.2 | 1.01
- / 3.5 | 1000 | 3.5
- / 15.5 | 1000 | 15.5
- / 2.18 | 1000 | 2.18
- / 3.1 | 1000 | 3.1
- / 8.6 | 1000 | 8.6
- / 6.6 | 1000 | 6.6
- / 17.5 | 1000 | 17.5
- / 8.4 | 1000 | 8.4
- / 28 | 1000 | 28
2.78 / - | 2.78 | 1.01
- / 1.62 | 1000 | 1.62
- / 3.15 | 1000 | 3.15
9.6 / - | 9.6 | 1.01
- / 1.88 | 1000 | 1.88
- / 1.55 | 1000 | 1.55
Spreadsheet: 710642d1609166324-find-and-return-values-based-off-of-multiple-conditions-test-1-my-solution
Sheet: STOCK

PRODUCT | TAG | QTY | 40887501820 | 54 | TAG | QTY
39573004420 | 2.73129817022021e+17 | 55
39573004420 | 2.73129817022021e+17 | 40
39573004420 | 2.7312981702198e+17 | 52
39573004420 | 2.7312981702198e+17 | 53
39573004420 | 2.7312981702202e+17 | 30
39573004420 | 2.7312981702202e+17 | 35
39573004420 | 2.73129817021973e+17 | 50
39573004420 | 2.73129817021973e+17 | 50
39573004420 | 2.73129817021976e+17 | 52
39573004420 | 2.73129817021981e+17 | 53
39573004420 | 2.73129817021992e+17 | 55
39573004420 | 2.73129817021995e+17 | 55
39573004420 | 1.7321730397559e+17 | 40
39573004420 | 1.7321730397559e+17 | 45
39573004420 | 1.7321730397559e+17 | 55
39573004420 | 1.73217304018652e+17 | 28
40887501820 | 2.73129817021979e+17 | 50
40887501820 | 1.73217304070303e+17 | 100
40887501820 | 2.73129817021979e+17 | 50
40887501820 | 2.73129817021979e+17 | 53
40887501820 | 1.73217304070303e+17 | 105
40887501820 | 2.73129817021981e+17 | 55
40887501820 | 2.73129817022022e+17 | 48
40887501820 | 2.7312981702202e+17 | 30
40887501820 | 2.73129817022022e+17 | 47
40887501820 | 2.73129817021981e+17 | 50
40887501820 | 2.73129817021972e+17 | 50
40887501820 | 2.73129817021981e+17 | 52
40887501820 | 2.7312981702198e+17 | 35
40887501820 | 2.7312981702198e+17 | 53
40887501820 | 2.73129817021981e+17 | 52
40887501820 | 1.73217304070303e+17 | 110
40887501820 | 2.73129817021992e+17 | 55
40887501820 | 2.73129817021995e+17 | 55
40887501820 | 1.7321730397559e+17 | 45
40887501820 | 2.73129817022015e+17 | 15
40887501820 | 1.7321730397559e+17 | 50
40887501820 | 1.73217304018652e+17 | 32
40887501820 | 2.73129807166142e+17 | 16
40887501820 | 1.73217304031263e+17 | 8
43341404020 | 2.73129817021979e+17 | 52
43341404020 | 2.73129817021981e+17 | 55
43341404020 | 2.73129817021981e+17 | 50
43341404020 | 2.7312981702198e+17 | 35
43341404020 | 2.73129817021973e+17 | 55
43341404020 | 2.73129817021973e+17 | 55
43341404020 | 2.73129817022015e+17 | 16
43341404020 | 2.73129817020341e+17 | 20
Spreadsheet: 784031d1655372879-interpolation-aproximation-of-unknow-values-by-trend-line-16062022
Sheet: Dane - pompa

Dane pompy |  | m
Omnigena | JY 1000 | 100
 |  | 95
 |  | 90
 |  | 85
 |  | 80
 |  | 75
 |  | 70
 |  | 65
 |  | 60
 |  | 55
 |  | 50
 |  | 45
 |  | 40
 |  | 35
 |  | 30
 |  | 25
 |  | 20
 |  | 15
 |  | 10
 |  | 5
 |  | 0 | 2 | 4 | 6 | 8 | 10 | 12 | 14 | 16 | 18 | 20 | 22 | 24 | 26 | 28 | 30 | 32 | 34 | 36 | 38 | 40 | 42 | 44 | 46 | 48 | 50 | 52 | 54 | 56 | 58 | 60 | 62 | 64 | 66 | 68 | 70 | 72 | 74 | 76 | 78 | 80 | 82 | 84 | 86 | 88 | 90 | 92 | 94 | 96 | 98 | 100
 |  | Wydajność [l/min]
 |  | 50 |  |  | 49 |  |  | 47 |  |  | 44 |  |  | 42 |  |  | 38 |  |  | 35 |  |  | 30 |  |  | 24 |  |  | 15 |  |  | 0
 |  | Excel 365 - FILTER
 |  |  | 0.01524864024864025 | -0.5457135457135458 | 50.92307692307692
 |  | Excel 2019
Hello guys,  I've got a problem which i am not sure how to handle.  I have few values from very low quality chart, and i want excel to fill all other gaps - it might not be as accurate as the real one. The easiest way is to do that by trend line, but as far as I know excel only displays the formula for the trend line and i cannot "acquire" it in any cell. I know i can do that by hand but i want to have this process automated to do something like shown in attachment.  I have in attachment one sheet working as catalog of pumps (inlcuding inside one picutre of pump, one picture of chart, model, company and values which are read from chart (y) scalled to the range of x 0 to 100 (step by 2)) In the second sheet (row 2, column B) we have list to choose which pump we want from our catalog - along with changing these two pictures I want excel to get these written down by hand values copied to row 24 columns C:BA.  And after all that preparations, how can i make excel to fill the gaps in my values? Or give me trend line formula? Would be awesome if that could be done without VBA because i certainly do not know how to use. I've tried a lot with REGLIW, and other like that but i do not quiet understand how it works.   The main goal of it is to after some diffrent calculations I could go and check exact value of that pump in desired spot.  Or maybe u have diffrent idea how can i make it work.  I hope guys you will help me with that  ASDG