tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 786374d1657139533-formula-to-substract-cell-multiple-cells-from-another-one-on-a-specific-date-urlaubs-bersicht-2022
Sheet: Tabelle1

Urlaubsübersicht |  |  |  | 2022 | [NAME]
Pers. |  |  | Rest | Anspruch
Nr. | Mitarbeiter | Eintritt | Vorjahr | neu | Jan. | Feb. | März | April | Mai | Juni | [NAME] | Aug. | Sept. | Okt. | Nov. | Dez. | Rest | derzeit
18 | Ahchiev | 2022-01-07 00:00:00 | 0 | 26 |  |  |  |  |  | 13 | 1 |  |  | 11 |  |  | 1 | 13
10 | Basic | 2021-10-13 00:00:00 | 4 | 26 |  |  |  | 6 |  |  |  | 8 | 7 | 2 |  |  | 7 | 24
128 | Baubinas | 2021-10-01 00:00:00 | 6 | 16 |  |  |  |  |  |  | 15 |  | 7 |  |  |  | 0 | 22
15 | Djekic | 2021-10-07 00:00:00 | 4 | 26 | 1 |  |  |  |  |  | 2 | 10 | 10 | 6 |  |  | 1 | 29
14 | Ilic | 2017-02-17 00:00:00 | 2 | 26 |  | 1 | 4 | 2 | 5 |  |  | 13 | 2 |  |  |  | 1 | 16
91 | Ivic | 2019-10-01 00:00:00 | 18 | 26 |  | 1 |  |  | 10 |  | 10 |  |  |  |  |  | 22 | 33
26 | [NAME] | 2017-09-01 00:00:00 | 3 | 26 |  |  |  | 3 |  |  |  | 15 |  | 1 | 9 |  | 1 | 26
68 | Lusic- Ilic | 2018-12-01 00:00:00 | 0 | 0 |  |  |  |  |  |  |  | 5 |  |  |  |  | 0
17 | Lintl | 2021-01-01 00:00:00 | 0 | 18 |  |  |  |  | 7 |  |  |  | 15 |  |  |  | -4 | 11
2 | Mirosavljevic | 2021-04-09 00:00:00 | 5 | 26 |  |  |  | 7 |  |  |  | 10 |  |  | 9 |  | 5 | 24
9 | Mitic | 2021-09-16 00:00:00 | 5 | 26 | 5 |  |  |  | 3 | 3 |  | 11 | 5 | 4 |  |  | 0 | 20
3 | Orlovac | 2016-10-15 00:00:00 | 0 | 28 |  |  |  |  | 4 |  | 15 |  |  | 5 |  |  | 4 | 24
126 | Peric | 2020-11-01 00:00:00 | 0 | 5 |  |  |  |  |  |  |  |  |  |  |  |  | 5
114 | [NAME] | 2020-07-01 00:00:00 | 2 | 26 |  |  | 8 |  |  | 9 | 1 |  | 10 |  |  |  | 0 | 11
74 | Schwenk | 2019-03-01 00:00:00 | 7 | 5 |  |  |  |  |  |  |  |  |  |  |  |  | 12 | 12
19 | Stumm | 2022-01-19 00:00:00 | 0 | 25 |  |  | 8 |  |  |  | 10 |  |  | 4 | 4 |  | -1 | 17
50 | Tupkusic | 2018-04-01 00:00:00 | 0 | 26 |  |  |  | 9 |  |  |  |  | 15 |  |  |  | 2 | 17
 | Vidic | 2022-06-01 00:00:00 | 0
 | [NAME] | 2022-06-15 00:00:00 | 0
 | [NAME] | 2022-06-20 00:00:00 | 0
Spreadsheet: 852311d1702392918-dependable-drop-down-list-based-on-cell-value-book1
Sheet: Sheet1

Naam | Ploeg
aa | 1
bb | 1
cc | 1
dd | 1
ee | 1
ff | 1
gg | 2
hh | 2
ii | 2
jj | 2
kk | 2
ll | 2
[NAME] | 2
nn | 3
oo | 3
pp | 3
qq | 3
rr | 3
ss | 3
tt | 4
uu | 4
vv | 4
ww | 4
xx | 4
yy | 4
zz | 5
ab | 5
bc | 5
cd | 5
de | 5
ef | 5
Spreadsheet: 737197d1624277239-index-and-match-with-3-creteria-2-text-and-1-number-column-match-and-index
Sheet: Sheet1

Vendor | Category | Price Upto | Margin % |  | Vendor | Category | Purchase Price | Margin % | Expected Value
Vendor A | Clothes | 500 | 30 |  | Vendor A | Clothes | 1300 |  | 10
Vendor A | Clothes | 1000 | 20 |  | Vendor A | Shoes | 800 |  | 40
Vendor A | Clothes | 1500 | 10 |  | Vendor A | Watches | 550 |  | 15
Vendor A | Shoes | 1000 | 40 |  | Vendor B | Clothes | 1800 |  | 13
Vendor A | Shoes | 2000 | 30 |  | Vendor B | Shoes | 1500 |  | 35
Vendor A | Shoes | 3000 | 20 |  | Vendor B | Watches | 1100 |  | 12
Vendor A | Watches | 200 | 25
Vendor A | Watches | 600 | 15 |  | Note
Vendor A | Watches | 800 | 5 |  | 1 | I am a retailer, I am purchase products from Different Vendors/WholeSalers in different categories for reselling purpose
Vendor B | Clothes | 700 | 33 |  | 2 | I want charge different margin on products from different vendors for different categories
Vendor B | Clothes | 1200 | 23 |  | 3 | And i also want to consider different price range for charging margin for a given vendor in a given category
Vendor B | Clothes | 1800 | 13
Vendor B | Shoes | 1800 | 35
Vendor B | Shoes | 2800 | 25
Vendor B | Shoes | 3800 | 15
Vendor B | Watches | 550 | 23
Vendor B | Watches | 1050 | 28
Vendor B | Watches | 1550 | 12
Spreadsheet: 473911d1470491492-how-to-return-a-blank-cell-until-condition-is-met-workbook1
Sheet: Sheet1

PETTY CASH
DATE | IN | OUT | RECEIPT NO | [NAME] | BALANCE
2016-08-01 00:00:00 |  |  |  | Bal B/F | -20
2016-08-02 00:00:00 | 150
2016-08-03 00:00:00 |  | 5
2016-08-04 00:00:00 |  | 2.75
2016-08-05 00:00:00 |  | 16.45
2016-08-06 00:00:00 |  | 45
2016-08-07 00:00:00 |  | 2.99
2016-08-08 00:00:00 |  | 60
2016-08-09 00:00:00 | 150
2016-08-10 00:00:00 |  | 2.25
2016-08-11 00:00:00 |  | 1.16
2016-08-12 00:00:00 |  | 15.99
2016-08-13 00:00:00 |  | 25
2016-08-14 00:00:00 |  | 14.3
2016-08-15 00:00:00 |  | 28
2016-08-16 00:00:00 |  | 19.99
2016-08-17 00:00:00 |  | 74
2016-08-18 00:00:00 | 150
2016-08-19 00:00:00 |  | 16
2016-08-20 00:00:00 |  | 25
2016-08-21 00:00:00 |  | 35
2016-08-22 00:00:00 |  | 1.5
2016-08-23 00:00:00 |  | 25
2016-08-24 00:00:00 |  | 10
2016-08-25 00:00:00 |  | 2.5
Spreadsheet: 48797d1248103819-need-to-delete-gaps-in-cells-postcodes-radio-stations
Sheet: TFM

Area: Radio Station - TFM
Postcode
DH 6 2
DH 6 3
DH 7 8
DL 1 1
DL 1 2
DL 1 3
DL 1 4
DL 1 5
DL 2 1
DL 2 2
DL 2 3
DL 3 0
DL 3 6
DL 3 7
DL 3 8
DL 3 9
DL 4 1
DL 4 2
DL 5 4
DL 5 5
DL 5 6
DL 5 7
DL 6 1
DL 6 2
DL 6 3
DL 7 0
DL 7 8
DL 7 9
DL 8 1
DL 8 2
DL 8 4
DL 8 5
DL 9 3
DL 9 4
DL 10 4
DL 10 5
DL 10 6
DL 10 7
DL 11 7
DL 12 8
DL 13 5
DL 14 0
DL 14 6
DL 14 7
DL 14 8
DL 14 9
DL 15 0
DL 15 8
DL 15 9
DL 16 6
DL 16 7
DL 17 0
DL 17 8
DL 17 9
SR 8 1
SR 8 2
SR 8 3
SR 8 4
SR 8 5
TS 1 1
TS 1 2
TS 1 3
TS 1 4
TS 1 5
TS 2 1
TS 3 0
TS 3 6
TS 3 7
TS 3 8
TS 3 9
TS 4 2
TS 4 3
TS 5 4
TS 5 5
TS 5 6
TS 5 7
TS 5 8
TS 6 0
TS 6 6
TS 6 7
TS 6 8
TS 6 9
TS 7 0
TS 7 8
TS 7 9
TS 8 0
TS 8 9
TS 9 5
TS 9 6
TS 9 7
TS 10 1
TS 10 2
TS 10 3
TS 10 4
TS 10 5
TS 11 6
TS 11 7
TS 11 8
TS 12 1
TS 12 2
TS 12 3
TS 13 4
TS 13 5
TS 14 6
TS 14 7
TS 14 8
TS 15 0
TS 15 9
TS 16 0
TS 16 9
TS 17 0
TS 17 5
TS 17 6
TS 17 7
TS 17 8
TS 17 9
TS 18 1
TS 18 2
TS 18 3
TS 18 4
TS 18 5
TS 19 0
TS 19 7
TS 19 8
TS 19 9
TS 20 1
TS 20 2
TS 21 1
TS 21 2
TS 21 3
TS 21 4
TS 22 5
TS 23 1
TS 23 2
TS 23 3
TS 23 4
TS 24 0
TS 24 7
TS 24 8
TS 24 9
TS 25 1
TS 25 2
TS 25 3
TS 25 4
TS 25 5
TS 26 0
TS 26 8
TS 26 9
TS 27 3
TS 27 4
TS 28 5
TS 29 6
Households & Population: 2001 Census, Small Area Statistics (Crown Copyright)
Spreadsheet: 872315d1718703429-countifs-but-ignoring-duplicates-in-1-column-testdata-clientcount
Sheet: Data

Client | Team | Review Completed |  |  |  | April | May | June | July |  | 4 | 5 | 6 | 7
1 | ICT | 2024-04-15 00:00:00 |  |  | ICT |  |  |  |  |  |  |  |  |  | 0
2 | ICT | 2024-04-15 00:00:00 |  |  | BAU
3 | BAU | 2024-04-15 00:00:00 |  |  | Review
4 | Review | 2024-04-15 00:00:00
5 | ICT | 2024-04-15 00:00:00
6 | Review | 2024-04-15 00:00:00
6 | Review | 2024-04-15 00:00:00
7 | Review | 2024-04-15 00:00:00
8 | BAU | 2024-04-15 00:00:00
9 | BAU | 2024-05-15 00:00:00
10 | ICT | 2025-05-15 00:00:00
10 | ICT | 2024-05-15 00:00:00
11 | ICT | 2024-05-15 00:00:00
12 | BAU | 2024-05-15 00:00:00
12 | BAU | 2024-05-15 00:00:00
13 | BAU | 2025-05-15 00:00:00
14 | BAU | 2024-05-15 00:00:00
Spreadsheet: 0e3abf68-cba3-4594-9bd6-2c83f1983b27
Sheet: Sheet1

Well | Unnamed: 1 | gene | C(T) | average | dCT | powerdCT | ddCT | powerddCT
Patient 1+ | case | HK gene | 34.19 | 33.915
Patient 1+ | case | HK gene | 33.64
Patient 1+ | case | GOI | 48 | 48 | 14.085 | 5.754300145985346e-05 | -3.914999999999999 | 15.08455257469182
Patient 1+ | case | GOI | 48
Patient 1- stimulated | case | HK gene | 28.01 | 28.075
Patient 1- stimulated | case | HK gene | 28.14
Patient 1- stimulated | case | GOI | 33.25 | 33.665 | 5.589999999999996 | 0.02076071584525805 | -12.41 | 5442.297094539324
Patient 1- stimulated | case | GOI | 34.08
Patient 1+ stimulated | case | HK gene | 29.62 | 29.605
Patient 1+ stimulated | case | HK gene | 29.59
Patient 1+ stimulated | case | GOI | 30.33 | 30.325 | 0.7199999999999989 | 0.6070974421975239 | -17.28 | 159146.9518874276
Patient 1+ stimulated | case | GOI | 30.32
Patient 1- | control | HK gene | 29.94 | 30
Patient 1- | control | HK gene | 30.06
Patient 1- | control | GOI | 48 | 48 | 18 | 3.814697265625e-06 | 0 | 1
Patient 1- | control | GOI | 48
In this example, GOI patient 1+ and GOI patient 1- have not amplified.  Therefore I have entered the total number of cycles as the CT value
Spreadsheet: 685647d1594125028-finding-data-across-multiple-sheets-excelforum__help_file
Sheet: Calc

 | CS_Jan
 | CZ_Jan
 | JA_Jan
 | ML_Jan
 | AH_Jan
 | JE_Jan | 1 | white | green | orange |  | desired result |  | 1 |  |  |  |  | Solution here
 |  | 2 | blue | yellow | white |  |  |  | 2
 |  | 3 | [NAME] | purple | red |  |  |  | 3
 |  | 4 | orange | yellow | blue |  |  |  | 4
 |  | 5 | red | white | green |  |  |  | 5
 |  | 6 |  |  |  |  |  |  | 6
 |  | 7 |  |  |  |  |  |  | 7
 |  | 8 |  |  |  |  |  |  | 8
 |  | 9 |  |  |  |  |  |  | 9
 |  | 10 |  |  |  |  |  |  | 10
 |  | 11 |  |  |  |  |  |  | 11
 |  | 12 |  |  |  |  |  |  | 12
 |  | 13 |  |  |  |  |  |  | 13
 |  | 14 |  |  |  |  |  |  | 14
 |  | 15 |  |  |  |  |  |  | 15
 |  | 16 |  |  |  |  |  |  | 16
 |  | 17 |  |  |  |  |  |  | 17
 |  | 18 |  |  |  |  |  |  | 18
 |  | 19 |  |  |  |  |  |  | 19
 |  | 20 |  |  |  |  |  |  | 20
 |  | 21 |  |  |  |  |  |  | 21
 |  | 22 |  |  |  |  |  |  | 22
 |  | 23 |  |  |  |  |  |  | 23
 |  | 24 |  |  |  |  |  |  | 24
 |  | 25 |  |  |  |  |  |  | 25
 |  | 26 |  |  |  |  |  |  | 26
 |  | 27 |  |  |  |  |  |  | 27
 |  | 28 |  |  |  |  |  |  | 28
 |  | 29 |  |  |  |  |  |  | 29
 |  | 30 |  |  |  |  |  |  | 30
 |  | 31 |  |  |  |  |  |  | 31
Spreadsheet: 594971d1540157507-numbering-sequence-code-numbering-sequence-code
Sheet: Sheet1

S01
 |  | S1002 | S01
TITLE
Spreadsheet: 760629d1640348233-unique-values-from-array-then-average-adjacent-column-values-book2
Sheet: Scores

 | PRODUCT |  | Taster 1 |  | Taster 2 |  | Taster 3 |  | Taster 4 |  | Taster 5 |  |  |  | PRODUCT
 | Good Beer |  | Term No. | Weight | Term No. | Weight | Term No. | Weight | Term No. | Weight | Term No. | Weight |  |  | Avg. Score
 | Gyle |  | 1477 | 1 | 0631 | 1 | 1477 | 1 | 0820 | 3 |  |  |  | Term
 | Keg001 |  | 0179 | 2 | 0222 | 1 |  |  | 0132 | 2
 |  |  | 0620 | 1 | 0620 | 2 |  |  | 0640 | 1
 |  |  |  |  | 1340 | 1
 | Score |  | 6 |  | 7 |  | 9 |  | 7
 | PRODUCT |  | Taster 1 |  | Taster 2 |  | Taster 3 |  | Taster 4 |  | Taster 5
 | Not as Good Beer |  | Term No. | Weight | Term No. | Weight | Term No. | Weight | Term No. | Weight | Term No. | Weight
 | Gyle |  | 1478 | 2 | 0140 | 1 | 1477 | 1 | 0820 | 1 | 0820 | 1
 | Keg002 |  |  |  | 0222 | 1 |  | 2 | 0132 | 2 | 0132 | 2
 |  |  |  |  |  |  |  |  | 0700 | 1 | 0700 | 1
 | Score |  | 6 |  | 5 |  | 8 |  | 5 |  | 5
Spreadsheet: 723236d1615569960-extract-list-based-on-criteria-test
Sheet: Sheet1

Kid | [NAME]? |  | List of Kids Who Get Candy
[NAME] | Yes |  | [NAME]
May | No |  | Amit
Amit | Yes |  | [NAME]
[NAME] | Yes |  | [NAME]
Alexa | No |  | Samson
[NAME] | Yes |  | Jasper
[NAME] | No
Samson | Yes
Jasper | Yes
Spreadsheet: 741182d1626878917-date-calculation-based-on-criteria-days-in-country-analysis
Sheet: Sheet1

 | Country | Region | [NAME] | Departure Date | Days |  |  |  |  | Initial Arrival | Total Period End
 | France |  | 2021-01-02 00:00:00 | 2021-07-02 00:00:00 |  |  | 180
 | Germany |  | 2021-01-06 00:00:00 | 2021-01-06 00:00:00 |  |  | 1
 | Italy |  | 2021-03-01 00:00:00 | 2021-03-04 00:00:00 |  |  | 4
 | Spain |  | 2021-06-29 00:00:00 | 2021-07-02 00:00:00 |  |  | 3
 | Spain |  | 2020-12-20 00:00:00 | 2021-01-06 00:00:00 |  |  | 5
Spreadsheet: 63152d1264095542-excel-formula-help-for-finding-and-extracting-data-forumhelp
Sheet: Sheet1

a | b | c | d
[NAME] | hinge | [NAME] | n-6
[NAME] | latch | pull | a-1
hinge | catch | roller | [NAME]
catch | pull | catch | n-1
hinge | pull | [NAME] | n-4
hinge | [NAME] | pull | f-7
[NAME] | hinge | [NAME] | n-6
catch | pull | catch | n-1
hinge | pull | [NAME] | n-4
Spreadsheet: sally_beck__35758__MgmtSum-Q1-0313
Sheet: Upside Downside

Upside / Downside Analysis
 |  |  | Estimate |  | Plan |  | [NAME]
Actual Margin
Deals Identified
Forecast Items:
 | Trading Margin Required Meet Expectations
 | Drift (IR & F/X)
 | Sycamore Forecast (Equity Trading)
 | Insurance Group
 | ECOGAS Credits
 | Credit Release (Treasury)
 | ComEd (Genco)
Less Expenses:
 | Commercial & Group Expenses
 | Interest & Interest Related Charges
Identified Earnings
Potential Upsides:
 | Upstream Transactions
 | Generation Investments Transactions
 | East Midstream Transactions
 | West Midstream Transactions
 | Principal Investing (Byers Locate?)
 | Pulp & Paper Forecast
 | Assets (No support)
Potential Downsides:
Portfolio Valuation Issues:
Earnings Before Tax
Spreadsheet: 236925d1369061541-report-a-value-based-on-multiple-drop-down-results-paper-prices
Sheet: Sheet1

Paper Weights | [NAME] | [NAME] | Silk Uncoated | Silk Coated |  | Paper Weight | Matt/Silk Coated/Uncoated | Price
80 | 0.01 | 0.011 | 0.012 | 0.013 |  | 100 | Silk Coated | ??
90 | 0.011 | 0.012 | 0.013 | 0.014
100 | 0.012 | 0.013 | 0.014 | 0.015
120 | 0.014 | 0.015 | 0.015 | 0.016
130 | 0.015 | 0.016 | 0.017 | 0.018
150 | 0.017 | 0.018 | 0.02 | 0.022
200 | 0.02 | 0.022 | 0.024 | 0.026
250 | 0.025 | 0.027 | 0.029 | 0.031
300 | 0.03 | 0.032 | 0.034 | 0.036
Spreadsheet: 673829d1587560546-match-positive-and-negative-amount-to-get-zero-balance-excel-matchning-zero-balance
Sheet: Pivot

 |  |  |  |  | Document type
1 | PO Name | Document Date | Document Number | Posting Key | SH | XN | ZT |  | resault
 | ALAMANDA - COUNTER | 2019-11-06 00:00:00 | [PHONE] | 50 |  |  | -1924.25 |  | no match
 | ALAMANDA - COUNTER | 2019-11-06 00:00:00 | [PHONE] | 40 |  | 1902.45 |  |  | no match
 | ALAMANDA - COUNTER | 2019-11-10 00:00:00 | [PHONE] | 50 |  |  | -4949.08 |  | no match
 | ALAMANDA - COUNTER | 2019-11-10 00:00:00 | [PHONE] | 40 |  | 4949 |  |  | no match
 | ALAMANDA - COUNTER | 2020-02-10 00:00:00 | [PHONE] | 40 |  | 3520.15 |  |  | match
 | ALAMANDA - COUNTER | 2020-02-11 00:00:00 | [PHONE] | 50 |  |  | -5037.95 |  | match
 | ALAMANDA - COUNTER | 2020-02-11 00:00:00 | [PHONE] | 40 |  | 1517.8 |  |  | match
 | AMPANG-COUNTER | 2020-03-19 00:00:00 | [PHONE] | 40 |  | 259.3 |  |  | match
 | AMPANG-COUNTER | 2020-04-15 00:00:00 | [PHONE] | 50 |  |  | -1045.6 |  | match
 | AMPANG-COUNTER | 2020-04-15 00:00:00 | [PHONE] | 40 |  | 786.3 |  |  | match
 | AMPANG-COUNTER | 2020-04-17 00:00:00 | [PHONE] | 40 |  | 326.7 |  |  | match
 | AMPANG-COUNTER | 2020-04-18 00:00:00 | [PHONE] | 50 |  |  | -376.1 |  | match
 | AMPANG-COUNTER | 2020-04-18 00:00:00 | [PHONE] | 40 |  | 49.4 |  |  | match
 | AMPANG-COUNTER | 2020-04-20 00:00:00 | [PHONE] | 40 |  | 63.45 |  |  | no match
 | B.BARU AYER ITAM-COUNTER | 2018-10-31 00:00:00 | [PHONE] | 40 |  | 1151.95 |  |  | no match
 | B.BARU AYER ITAM-COUNTER | 2020-04-20 00:00:00 | [PHONE] | 40 |  | 261.05 |  |  | no match
 | BAGAN SERAI-COUNTER | 2020-04-20 00:00:00 | [PHONE] | 40 |  | 1060.7 |  |  | no match
 | BALAKONG-COUNTER | 2020-01-24 00:00:00 | [PHONE] | 40 |  | 292.5 |  |  | match
 | BALAKONG-COUNTER | 2020-01-28 00:00:00 | [PHONE] | 50 |  |  | -2044.55 |  | match
 | BALAKONG-COUNTER | 2020-01-28 00:00:00 | [PHONE] | 40 |  | 1752.05 |  |  | match
 | BALAKONG-COUNTER | 2020-04-20 00:00:00 | [PHONE] | 40 |  | 1469.6 |  |  | no match
 | BALIK PULAU-COUNTER | 2020-04-20 00:00:00 | [PHONE] | 40 |  | 727.85 |  |  | no match
 | [NAME] | 2020-02-05 00:00:00 | [PHONE] | 50 |  |  | -1033.4 |  | no match
 | [NAME] | 2020-02-05 00:00:00 | [PHONE] | 40 |  | 1033.6 |  |  | no match
 | [NAME] | 2020-03-09 00:00:00 | [PHONE] | 50 |  |  | -1296.3 |  | match
 | [NAME] | 2020-03-09 00:00:00 | [PHONE] | 40 |  | 1201.4 |  |  | match
 | [NAME] | 2020-03-16 00:00:00 | [PHONE] | 40 |  |  | 1743.45 |  | match
 | [NAME] | 2020-03-17 00:00:00 | [PHONE] | 50 | -1648.55 |  |  |  | match
 | [NAME] | 2020-04-20 00:00:00 | [PHONE] | 40 |  | 946.6 |  |  | no match
Spreadsheet: c09d1b81-4415-4327-a77c-4641d9a99c6a
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | SKI | POSITION | TOTAL TIME
2819 | 15473 | Heike | Bartenbach | GER
2819 | 15474 | [NAME] | [NAME] | GER
Spreadsheet: 90221d1289970154-combining-conditional-formatting-rules-sample-97-03
Sheet: Main

Name
Day Color | Red | pick color from list
Pay Period starting on | 2010-04-10 00:00:00 | pick period starting day
 | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday
 | 2010-04-10 00:00:00 | 2010-04-11 00:00:00 | 2010-04-12 00:00:00 | 2010-04-13 00:00:00 | 2010-04-14 00:00:00 | 2010-04-15 00:00:00 | 2010-04-16 00:00:00
 | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday
 | 2010-04-17 00:00:00 | 2010-04-18 00:00:00 | 2010-04-19 00:00:00 | 2010-04-20 00:00:00 | 2010-04-21 00:00:00 | 2010-04-22 00:00:00 | 2010-04-23 00:00:00
Spreadsheet: 690781d1597296097-date-match-demo
Sheet: Total

 | DAYS OF MONTH
Month | 1 | 2 | 3 | 4 | 5 | 6 | 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 | TOTAL
APRIL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
MAY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
JULY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
AUGUST | 150 | 300 | 450 | 720 | 810 | 680 | 725 | 325 | 985 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5145
SEPTEMBER |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
OCTOBER |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
NOVEMBER |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
DECEMBER |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
JANUARY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
FEBRUARY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5145
Spreadsheet: 0a8bce26-c259-4370-9454-3553150f3fae
Sheet: Biol

 |  |  | 11-12 |  |  |  | 12-13 |  |  |  | 13-14
Major | [NAME] | CrseNum | No. Students | Average GPA | Min GPA | [NAME] | No. Students | Average GPA | Min GPA | [NAME] | No. Students | Average GPA | Min GPA | [NAME]
 |  |  | 11-12 |  |  |  | 12-13 |  |  |  | 13-14
Major | [NAME] | CrseNum | No. Students | Average GPA | Min GPA | [NAME] | No. Students | Average GPA | Min GPA | [NAME] | No. Students | Average GPA | Min GPA | [NAME]
Biology Education-Grades 6-12 | BIOL | 102 | 2 | 3 | 3 | 3 | 1 | 4 | 4 | 4 | 2 | 3 | 2 | 4
 |  | 102L | 2 | 2.5 | 2 | 3 | 1 | 4 | 4 | 4 | 2 | 2.5 | 2 | 3
 |  | 211 | 3 | 3 | 2 | 4 | 1 | 4 | 4 | 4 | 2 | 3 | 2 | 4
 |  | 250 | 1 | 0 | 0 | 0 | 1 | 2 | 2 | 2
 |  | 315 | 3 | 3 | 2 | 4 | 1 | 3 | 3 | 3 | 2 | 2 | 2 | 2
 |  | 321 |  |  |  |  | 1 | 3 | 3 | 3
 |  | 339 | 3 | 3 | 2 | 4 | 1 | 4 | 4 | 4 | 3 | 1.666666666666667 | 1 | 2
 |  | 404 | 3 | 4 | 4 | 4 | 1 | 4 | 4 | 4 | 2 | 4 | 4 | 4
 |  | 410 | 3 | 2.666666666666667 | 2 | 4 | 1 | 4 | 4 | 4 | 2 | 2 | 2 | 2
 | CHEM | 101 | 3 | 1.666666666666667 | 0 | 3 | 1 | 4 | 4 | 4 | 2 | 1.5 | 1 | 2
 |  | 102 | 2 | 2 | 2 | 2 | 1 | 2 | 2 | 2 | 3 | 2.333333333333333 | 1 | 4
Spreadsheet: 830266d1684836112-split-data-which-uses-from-1-cell-to-multiple-row-s666-pq-split-data-which-uses-semicolon-from-1-cell-to-multiple-row
Sheet: Sheet1

DATA looks like this
Column1 | Column2 | Column3 | Column4 | Column5
ABC | any | 10.124.123.10;10.12.1.68;10.127.160.2 | any | TCP-121;TCP-13
XYZ | any | 10.12.161.100;10.12.169.149;10.12.209.111 | any | TCP-15;TCP-19;TCP-545;UDP-145-123;UDP-45;UDP-125
AAA | any | 10.128.123.2;10.128.169.128;10.128.178.22;10.2.142.9;10.121.9.13 | any | TCP-6382
CCC | any | 10.11.19.14;10.18.15.17;10.13.19.3 | any | application-default
DDD | any | 10.85.45.4
RESULT: Would like to split the IP address in each row with data repeated.
ABC | any | 10.124.123.10 | any | TCP-121;TCP-13
ABC | any | 10.12.1.68 | any | TCP-121;TCP-13
ABC | any | 10.127.160.2 | any | TCP-121;TCP-13
XYZ | any | 10.12.161.100 | any | TCP-15;TCP-19;TCP-545;UDP-145-123;UDP-45;UDP-125
XYZ | any | 10.12.169.149 | any | TCP-15;TCP-19;TCP-545;UDP-145-123;UDP-45;UDP-125
XYZ | any | 10.12.209.111 | any | TCP-15;TCP-19;TCP-545;UDP-145-123;UDP-45;UDP-125
AAA | any | 10.128.123.2 | any | TCP-6382
AAA | any | 10.128.169.128 | any | TCP-6382
AAA | any | 10.128.178.22 | any | TCP-6382
AAA | any | 10.2.142.9 | any | TCP-6382
AAA | any | 10.121.9.13 | any | TCP-6382
CCC | any | 10.11.19.14 | any | application-default
CCC | any | 10.18.15.17 | any | application-default
CCC | any | 10.13.19.3 | any | application-default
DDD | any | 10.85.45.4 | any | application-default
Spreadsheet: 119785d1314738435-conditional-formatting-wastecopies
Sheet: Sheet2

 | Variable -> | 4-8 | 10-14 | 16-20 | 22-24
Count | 0 - 25000 | 300 | 400 | 450 | 650
 | 26 - 75000 | 350 | 450 | 500 | 700
 | 76- 125000 | 450 | 600 | 700 | 900
 | 126 - 150000 | 700 | 900 | 1200 | 1500
 | 151- 200000 | 1000 | 1300 | 1750 | 2200
 | 200 - 250000 | 1400 | 2000 | 2500 | 2800
 | COUNT | Variable | Target
 | 45000 | 8 | 300
Spreadsheet: 792630d1661017829-highlighted-cells-with-green-and-red-cells-ryans-league-1-
Sheet: Weekly

 | Team | Name | Points |  | Week 1 | Week 2 | Week 3 | Week 4 | Week 5
 | Earth, Mings & Fire | [NAME] | 154 |  | 2 | 1
 | Prizeguy fc | [NAME] | 154 |  | 8 | 1
 | Scalers FC | [NAME] | 151 |  | 8 | 3
 | Neves say never | [NAME] | 149 |  | 20 | 4
 | Hughes are ya | [NAME] | 147 |  | 6 | 5
 | gangsters allardyce | [NAME] | 146 |  | 12 | 6
 | MM FC | [NAME] | 145 |  | 5 | 7
 | Man of the Matts | [NAME] | 141 |  | 3 | 8
 | Scaleblazers FC | [NAME] | 139 |  | 16 | 9
 | [NAME] | [NAME] | 138 |  | 11 | 10
 | Fred Up Already | [NAME] | 134 |  | 20 | 11
 | [NAME] | [NAME] | 131 |  | 16 | 12
 | Exeter Gently | [NAME] | 131 |  | 4 | 12
 | It's [NAME], [NAME] | Owain Beggs | 131 |  | 7 | 12
 | [NAME] | Cristian Briers | 130 |  | 12 | 15
 | Back of the Neto | [NAME] | 130 |  | 14 | 15
 | Jock | [NAME] | 129 |  | 14 | 17
 | Los Lobos | [NAME] | 129 |  | 19 | 17
 | fozzie fc | [NAME] | 127 |  | 1 | 19
 | Pain in Dias | [NAME] | 125 |  | 19 | 20
 | Warriload FC | [NAME] | 123 |  | 8 | 21
 | WBA will b okay | [NAME] | 115 |  | 31 | 22
 | Matts Money Makers | [NAME] | 114 |  | 25 | 23
 | Boggies Baggies | [NAME] | 114 |  | 16 | 24
 | jaggers whatevers | [NAME] nicholls | 113 |  | 23 | 24
 | St Domingo FC | Callum Davies | 113 |  | 23 | 24
 | thedamnedunited | [NAME] | 107 |  | 28 | 27
 | Big Stonks  FC | Cai Jones | 106 |  | 30 | 28
 | [NAME] | [NAME] | 106 |  | 27 | 28
 | ilovethisgame | [NAME] | 97 |  | 32 | 30
 | Alfasud Untied | [NAME] | 94 |  | 28 | 31
 | 5 O Clock Heroes | [NAME] | 91 |  | 26 | 32
Spreadsheet: 698685d1602121164-vlookup-with-multiple-search-results-tender-register-spreadsheet
Sheet: Tenders

 | Tenders
No. | Project Name: | Closing Date: | Builders /Clients: | Contact Name: | Contact Email: | Contact Phone: | Quoted Price (excl GST): | [NAME] | Builder Awarded: | [NAME] | Awarded Amount: | Notes | Builder Search
87 | Wyndham Christian College |  |  |  |  |  |  |  |  |  |  |  | Magellan\Amber Robillard | Invalid input
 |  |  |  |  |  |  |  |  |  |  |  |  | Spence Constructions\Mark Bongiovanni
 |  |  |  |  |  |  |  |  |  |  |  |  | Ayjay Construction\leanne Cordova
88 | Baimbridge College [NAME] |  |  |  |  |  |  |  |  |  |  |  | Allmore [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] Constructions\Warwick [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | Searle Bros\Brittany Wade