tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 838406d1690984207-pairing-variables-and-coding-the-output-sample-dataset-v4-hansdouwe-solution-corrected
Sheet: Sheet02

Transaction No | Customer ID | Date (DD/MM/YYYY) | Apple | Pepper | [NAME] | Blueberry | [NAME] | [NAME] | Peach | Grape
1 | 111181 | 2021-08-20 00:00:00
2 | 111182 | 2021-08-20 00:00:00
3 | 111203 | 2021-08-23 00:00:00
4 | 111111 | 2021-08-16 00:00:00
5 | 111143 | 2021-08-13 00:00:00 |  |  |  |  |  |  |  |  |  |  | Data Legend
6 | 111112 | 2021-08-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | Label | Coding
7 | 111151 | 2021-08-16 00:00:00 |  |  |  |  |  |  |  |  |  |  | [NAME] | 1
8 | 111192 | 2021-08-22 00:00:00 |  |  |  |  |  |  |  |  |  |  | Red Apple | 20
9 | 111158 | 2021-08-17 00:00:00 |  |  |  |  |  |  |  |  |  |  | Green Pepper | 30
10 | 111111 | 2021-08-09 00:00:00 |  |  |  |  |  |  |  |  |  |  | Red Pepper | 4
11 | 111116 | 2021-08-02 00:00:00 |  |  |  |  |  |  |  |  |  |  | Orange Pepper | 5
12 | 111112 | 2021-08-17 00:00:00 |  |  |  |  |  |  |  |  |  |  | [NAME] | 6
13 | 111122 | 2021-08-07 00:00:00 |  |  |  |  |  |  |  |  |  |  | [NAME] | 7
14 | 111128 | 2021-08-10 00:00:00 |  |  |  |  |  |  |  |  |  |  | Blueberry | 8
15 | 111181 | 2021-08-21 00:00:00 |  |  |  |  |  |  |  |  |  |  | [NAME] | 9
16 | 111136 | 2021-08-11 00:00:00 |  |  |  |  |  |  |  |  |  |  | [NAME] | 10
17 | 111133 | 2021-08-20 00:00:00 |  |  |  |  |  |  |  |  |  |  | Peach | 11
18 | 111177 | 2021-08-19 00:00:00 |  |  |  |  |  |  |  |  |  |  | Grape | 13
19 | 111209 | 2021-08-28 00:00:00
20 | 111191 | 2021-08-23 00:00:00
21 | 111119 | 2021-08-05 00:00:00
22 | 111111 | 2021-08-01 00:00:00
23 | 111133 | 2021-08-11 00:00:00
24 | 111112 | 2021-08-16 00:00:00
25 | 111114 | 2021-08-02 00:00:00
26 | 111209 | 2021-08-29 00:00:00
27 | 111136 | 2021-08-11 00:00:00
28 | 111187 | 2021-08-20 00:00:00
29 | 111171 | 2021-08-19 00:00:00
30 | 111209 | 2021-08-30 00:00:00
31 | 111204 | 2021-08-23 00:00:00
32 | 111206 | 2021-08-24 00:00:00
33 | 111197 | 2021-08-22 00:00:00
34 | 111194 | 2021-08-22 00:00:00
35 | 111162 | 2021-08-18 00:00:00
36 | 111167 | 2021-08-18 00:00:00
37 | 111155 | 2021-08-17 00:00:00
38 | 111165 | 2021-08-18 00:00:00
39 | 111173 | 2021-08-19 00:00:00
40 | 111203 | 2021-08-23 00:00:00
Spreadsheet: 756546d1637622626-using-substitute-with-concatenate-together-in-one-formula-substitute-or-vlookup-with-concatenate-1-
Sheet: Planilha1

Blue | Bike | ,
Red | Pin | ,
Yellow | Sun | ,
Orange | Orange | ,
Purple | Flower | ,
Green | Grass | ,
[NAME] | Leaf
Spreadsheet: d1dc4f14-b309-4b3b-bd01-08746a418323
Sheet: Vendor 1

C R I T E R I A | Total Possible Score | Committee Member Name | Committee Member Name | Committee Member Name | Committee Member Name | Committee Member Name | Committee Member Name | Committee Member Name | Committee Member Name | Committee Member Name | Committee Member Name | Average
Qualification Requirements
Understanding the Problem |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Professional Personnel |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Soundness of Approach |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Terms and Conditions |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Available Facilities |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Value Added Services |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Evaluation of Costs
Cost Rating
Total Qualification & Cost Requirements
Oral Presentation |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Score
Spreadsheet: 154033d1336155132-multiple-conditional-formatting-forum-example-conditioning
Sheet: ORIGINAL (2)

Yes or No Only | Fortnightly Pattern |  |  |  | Instruction
 | Week 1 |  | Week 2
 | Days on | Days off | Days On | Days Off
No |  |  |  |  |  |  | I need cells B to E to be coloured in BLACK when the answer in A = "no"
No
No |  |  |  |  |  |  | I've tried using this….
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No |  |  |  |  |  |  | but as you can see it's only colouring in the B cell and not B through E
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
Spreadsheet: craig_dean__4376__Proposed New Shift Schedule for 2001
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | 24 HOUR SCHEDULE
 |  |  |  |  |  |  |  |  |  |  |  |  | MONTH
NAME | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI
Version #1 | 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
[NAME] | D | D | D | D |  |  |  |  | N | N | N | N |  |  |  |  | D | D | D | D |  |  |  |  | N | N | N | N |  |  |  | 16
[NAME] | N | N | N | N |  |  |  |  | D | D | D | D |  |  |  |  | N | N | N | N |  |  |  |  | D | D | D | D |  |  |  | 16
[NAME] |  |  |  |  | D | D | D | D |  |  |  |  | N | N | N | N |  |  |  |  | D | D | D | D |  |  |  |  | N | N | N | 15
[NAME] |  |  |  |  | N | N | N | N |  |  |  |  | D | D | D | D |  |  |  |  | N | N | N | N |  |  |  |  | D | D | D | 15
Version #2
[NAME] | D | D |  |  |  | N | N | N |  |  | D | D |  |  |  | N | N |  |  |  | D | D |  |  | N | N | N |  |  | D | D | 16
[NAME] | N | N |  |  |  | D | D | D |  |  | N | N |  |  |  | D | D |  |  |  | N | N |  |  | D | D | D |  |  | N | N | 16
[NAME] |  |  | D | D | D |  |  |  | N | N |  |  | D | D | D |  |  | N | N | N |  |  | D | D |  |  |  | N | N |  |  | 15
[NAME] |  |  | N | N | N |  |  |  | D | D |  |  | N | N | N |  |  | D | D | D |  |  | N | N |  |  |  | D | D |  |  | 15
[NAME] | x | x |  |  |  | x | x | x | x | x |  |  | x | x | x | x | x |  |  | x | x | x | x | x |  |  | x | x | x | x | x
Version #3
[NAME] | D | D | D |  |  |  | N | N | N |  |  |  | D | D | D |  |  |  | N | N | N |  |  |  | D | D | D |  |  |  | N | 16
[NAME] | N | N | N |  |  |  | D | D | D |  |  |  | N | N | N |  |  |  | D | D | D |  |  |  | N | N | N |  |  |  | D | 16
[NAME] |  |  |  | D | D | D |  |  |  | N | N | N |  |  |  | D | D | D |  |  |  | N | N | N |  |  |  | D | D | D |  | 15
[NAME] |  |  |  | N | N | N |  |  |  | D | D | D |  |  |  | N | N | N |  |  |  | D | D | D |  |  |  | N | N | N |  | 15
Version #4
[NAME] | D | D | D | D | D |  |  |  |  |  | N | N | N | N | N |  |  |  |  |  | D | D | D | D | D |  |  |  |  |  | N | 16
[NAME] | N | N | N | N | N |  |  |  |  |  | D | D | D | D | D |  |  |  |  |  | N | N | N | N | N |  |  |  |  |  | D | 16
[NAME] |  |  |  |  |  | D | D | D | D | D |  |  |  |  |  | N | N | N | N | N |  |  |  |  |  | D | D | D | D | D |  | 15
[NAME] |  |  |  |  |  | N | N | N | N | N |  |  |  |  |  | D | D | D | D | D |  |  |  |  |  | N | N | N | N | N |  | 15
Spreadsheet: 72603d1273286151-change-currency-formatting-based-on-value-of-another-cell-macro-start
Sheet: SUMMARY

SUMMARY
 | MC | MAL |  | Origin Energy | Remarks
Quoting Currency | [NAME] |  | Australian Dollars
 | ¥ |  | $A
Delivery Terms | CIF | [NAME] | Origin Energy Mt. Stuart
Insurance (Cost / Responsibility) | √ |  |  |  | Insurance will be covered to site.
Cartage / Carriage (Cost / Responsibility) Port to site |  | √
Customs Duties (Cost / Responsibility) |  | √
Associated Import Charges ie THC, agency fee, doc fee etc. (Cost / Responsibility) |  | √
Documentation (Shipping) | √
FOB Lead Time |  |  | 1 |  | Air and Ocean
Ownership transfer to goods / risk (ie at; port / site / over ships rail) | FOB Japan |  | After receipt of payment | Ships rail Japan Port
Price: | 0 |  | 0
 |  |  | 0 |  | (Air Price)
Profit (FOB) | 0 | 0 |  | 0 | (Air Price)
Terms of payment ie no. days / TTR | 30 days after B/L date |  | 30 days after invoicing
Invoicing | Upon completion of delivery at FOB | B/L date | Upon completion of delivery at site.
Tradeline | 0
Checked by     __________________________ |  |  | Approved by           __________________________
Spreadsheet: 769142d1645347558-index-match-solution-required-for-multiple-criteria-with-merged-cell-index-match-for-merged-cell
Sheet: Summary

Device | Working Ratio | 2022-02-01 00:00:00 | 2022-02-02 00:00:00 | 2022-02-03 00:00:00 | 2022-02-04 00:00:00 | 2022-02-05 00:00:00
Water Meter | [NAME] | 100 | 100 | 100 | 100 | 100
 | Consumption Ratio | 96 | 0 | 0 | 90 | 80.4
Air meter | [NAME] | 100 | 100 | 100 | 100 | 100
 | Consumption Ratio | 96 | 0 | 0 | 90 | 80.4
Oil meter | [NAME] | 92 | -100 | -100 | 80 | 60.8
 | Consumption Ratio | 88 | -200 | -200 | 70 | 41.2 |  |  |  | Required Result
 |  |  |  |  |  |  |  |  |  | 2022-02-01 00:00:00
 |  |  |  |  |  |  |  |  |  | Consumption Ratio
 |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 704345d1605518391-formula-to-find-the-non-zero-values-with-conditions-example1
Sheet: Sheet1

Criteria 1 | [NAME] | Criteria 3
X | PL | 20
X | PL | 0
X | MT | 20
X | MT | 30
Y | PL | 0
Y | MT | 0
Z | PL | 5
Z | MT | 5
B | PL | 2
B | MT | 2
A | PL | 20
A | MT | 20
Z | PL | 0
Z | MT | 0
Z | PL | 2
Z | MT | 2
D | PL | 0
D | MT | 0
D | PL | 30
D | MT | 30
 | Result | 5 | it should give me the count
Requirement is |  | [NAME] which is not equal to zero
 |  | [NAME] which is equal to PL
 |  | Criteria eliminate the duplicaes if the above two coniditions matched
Spreadsheet: 838335d1690925049-why-is-my-xlookup-with-a-nested-maxif-unable-to-give-me-a-blank-result-formulaexample
Sheet: Sheet4

CAMP | Phone Number | Employee Number | Payment Date | Payment Amount |  |  | phone_number |  | rep
MOL | 4255555666 | 3608 | 2022-07-27 00:00:00 | 3000 |  |  | 4255555666
EFP | 4255555666 | 3608
BHS | 4255555666 | 1156 | 2009-05-22 00:00:00 | 3000
BHS | 4255555666 | 1156 | 2007-02-03 00:00:00 | 3000
Spreadsheet: 455837d1460531651-subtotal-in-if-function-book1
Sheet: Sheet1

Total | Supplier payment terms (Days from the date of Receipt of PO) | Days | Result (Min Payment should received from client)
650 | 60 | 1 | 0
150 | 60 | 2 | 0
850 | 30 | 3 | 0
250 | 30 | 4 | 0
3150 | 60 | 5 | 0
578.5 | 60 | 6 | 0
882.9 | 60 | 7 | 0
572.4 | 60 | 8 | 10000
572.4 | 60 | 9 | 10000
211.68 | 60 | 10 | 10000
10500 | 60 | 11 | 10000
572.4 | 60 | 12 | 10000
10500 | 60 | 13 | 10000
133.25 | 60 | 14 | 10000
133.25 | 60 | 15 | 10000
276.25 | 60 | 16 | 10000
450 | 60 | 17 | 10000
615 | 60 | 18 | 10000
410 | 60 | 19 | 10000
4125 | 60 | 20 | 10000
114473.75 | 60 | 21 | 10000
170.95 | 60 | 22 | 10000
442 | 60 | 23 | 10000
180.7 | 60 | 24 | 10000
263.25 | 60 | 25 | 10000
263.25 | 60 | 26 | 10000
434103 | 60 | 27 | 10000
20500 | 60 | 28 | 10000
42000 | 60 | 29 | 10000
63825.3 | 60 | 30 | 85930
3500 | 60 | 31 | 85930
1050 | 30 | 32 | 85930
500 | 60 | 33 | 85930
650 | 60 | 34 | 85930
150 | 60 | 35 | 85930
1350 | 60 | 36 | 85930
10000 | 30 | 37 | 85930
2312 | 60 | 38 | 85930
6001 | 60 | 39 | 85930
21539 | 60 | 40 | 85930
30000 | 30 | 41 | 85930
10000 | 8 | 42 | 85930
1785 | 60 | 43 | 85930
5525 | 60 | 44 | 85930
6500 | 60 | 45 | 85930
26780 | 30 | 46 | 85930
7000 | 30 | 47 | 85930
 |  | 48 | 85930
 |  | 49 | 85930
 |  | 50 | 85930
 |  | 51 | 85930
 |  | 52 | 85930
 |  | 53 | 85930
 |  | 54 | 85930
 |  | 55 | 85930
 |  | 56 | 85930
 |  | 57 | 85930
 |  | 58 | 85930
 |  | 59 | 85930
 |  | 60 | 846447.2
Spreadsheet: 886500d1736521025-count-how-many-items-each-person-has-example-counting
Sheet: Sheet2

ID | Colour
10124 | Pencil
10125 | Pen
10126 | Pen
10127 | Pencil
10128 | Pencil
10129 | Rubber
10130 | Pencil
10131 | Pencil
10132 | Pencil
10124 | Rubber
10125 | Rubber
10126 | Rubber
10128 | Rubber
10129 | Rubber
10131 | Rubber
10132 | Rubber
10125 | Pen
10126 | Pen
10128 | Pen
10129 | Pen
10131 | Rubber
10132 | Rubber
Spreadsheet: 42405d1240989657-matrix-help-risk-assesment-matrix
Sheet: RISK Analysis

 |  |  |  | Risk before controls |  |  |  | Risk after controls
 | Sequence | [NAME] | What can go wrong? | Severity | Likelyhood | Risk | Control / Barriers | Severity 2 | Likelyhood2 | Risk2
 | 1 | [NAME] cant get Excel to work | Loose job | Very Serious | Rare | MEDIUM | Ask for help
 | 2 | [NAME] power lead | Electrocution | Major | Likely | HIGH | Fix lead | Very Serious | Rare | LOW |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Major | Rare |  |  | HIGH
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Very Serious | Unlikely |  |  | MEDIUM
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Serious | Possible |  |  | LOW
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Significant | Likely
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Slight | Almost Certain
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No Impact
Spreadsheet: 806136d1669123408-loop-function-to-stack-selective-data-excel_loop
Sheet: Consolidate

Identiifer | Acc
24143 | 1.23
15255 | 1a34
3764 | r32r
2534647 | etr
236456 | dvdrg
2645745 | erge
48756 | erge
67896 | e8io
Identiifer | NAMW
376 | dfdd
4874 | fg
27474 | srt
37446 | ser
236234576 | sg
497 | st
Identiifer | AWM
15255 | gr
25636 | tyuit
236456 | 567
2645745 | e4
67896 | ery
Spreadsheet: 684512d1593422283-pair-up-values-in-one-range-area-with-values-in-other-range-area-book1-result
Sheet: Sheet1

Group One | A | B | C | D | E |  |  | A | B | C | D | E
 | 5 | 3 | 7 | 6 | 4
Group Two | I | II | III | IV | V
 | 2 | 4 | 7 | 6 | 5
Rules
1. If value of a cell in group-1 is more than 5 (--> 6 and 7), it's paired up with value of cell in group-2 which is more than 4 (--> 5, 6 and 7)
2. If value of a cell in group-1 is between 3 and 6 (--> 4 and 5), it's paired up with value of cell in group-2 which is more than 5 (-->  6 and 7)
3. Those pairs will be put in yellow area
Spreadsheet: 766842d1644086751-excel-spreadsheet-tracking-yearly-accounting-metadata-formulas-accounting-spreadsheet-sample
Sheet: Sheet1

MC TR DT: | MC BK DT: | MC ST DT: | BK DT: | INV/REC DT: | CHQ DT: | INV/REC #: | CHQ #: | CUSTOMER/SUPPLIER NAME: | PRODUCT/DESCRIPTION: | CATEGORY: | QTY: | PPU$: | SUB$: | S&H$: | EBFEE$: | GST$: | HST$: | PST$: | PPFEE$: | TOTAL$: | CURR: | GST%: | HST%: | PST%: | BK ACCT: | Balance
N/A | N/A | N/A | 2021-10-29 00:00:00 | N/A | EMT | N/A | EMT | CUSTOMER #1 | N/A | SALES | N/A | N/A | 50 | N/A | N/A | 2.5 | N/A | N/A | N/A | 52.5 | CAD |  | N/A | N/A | BANK #1 | $BALANCE
N/A | N/A | N/A | N/A | 2021-10-29 00:00:00 | N/A | 215625 | N/A | CUSTOMER #1 | PRODUCT #1 | SALES | 5 | 10 | -50 | N/A | N/A | -2.5 | N/A | N/A | N/A | -52.5 | CAD |  | N/A | N/A | RECEIVABLE | $BALANCE
N/A | N/A | N/A | 2021-11-16 00:00:00 | N/A | 2021-10-28 00:00:00 | N/A | 30378 | SUPPLIER #1 | N/A | EXP-INVENTORY | N/A | N/A | -25 | N/A | N/A | N/A | -3.25 | N/A | N/A | -28.25 | CAD | N/A |  | N/A | BANK #1 | $BALANCE
N/A | N/A | N/A | N/A | 2021-09-28 00:00:00 | N/A | 89U04756MB088832F | N/A | SUPPLIER #1 | PRODUCT #1 | EXP-INVENTORY | 5 | 5 | 25 | N/A | N/A | N/A | 3.25 | N/A | N/A | 28.25 | CAD | N/A |  | N/A | PAYABLE | $BALANCE
N/A | N/A | N/A | 2021-10-29 00:00:00 | N/A | 2021-09-29 00:00:00 | N/A | 142 | CUSTOMER #2 | N/A | SALES | N/A | N/A | 100 | N/A | N/A | N/A | 13 | N/A | N/A | 52.5 | USD | N/A |  | N/A | BANK #2 | $BALANCE
N/A | N/A | N/A | N/A | 2021-09-25 00:00:00 | N/A | 215618 | N/A | CUSTOMER #2 | PRODUCT #2 | SALES | 5 | 20 | -100 | N/A | N/A | N/A | -13 | N/A | N/A | -52.5 | USD | N/A |  | N/A | RECEIVABLE | $BALANCE
N/A | N/A | N/A | 2021-11-16 00:00:00 | N/A | 2021-11-01 00:00:00 | N/A | 2555 | SUPPLIER #2 | N/A | EXP-INVENTORY | N/A | N/A | -75 | N/A | N/A | N/A | -9.75 | N/A | N/A | -84.75 | USD | N/A |  | N/A | BANK #2 | $BALANCE
N/A | N/A | N/A | N/A | 2021-10-13 00:00:00 | N/A | 89U04756MB088832F | N/A | SUPPLIER #2 | PRODUCT #2 | EXP-INVENTORY | 5 | 15 | 75 | N/A | N/A | N/A | 9.75 | N/A | N/A | 84.75 | USD | N/A |  | N/A | PAYABLE | $BALANCE
2020-09-15 00:00:00 | 2020-09-16 00:00:00 | 2021-09-27 00:00:00 | M/C | 2021-08-31 00:00:00 | M/C | 10523 | M/C | SUPPLIER #3 | PRODUCT #3 | EXP-VEHICLE |  |  | 147 | N/A | N/A | N/A | 19.11 | N/A | N/A | 166.11 | CAD | N/A |  | N/A | PAYABLE | $BALANCE
N/A | N/A | 2021-09-27 00:00:00 | 2021-10-23 00:00:00 | N/A | PA | N/A | PA | SUPPLIER #3 | N/A | EXP-VEHICLE | N/A | N/A | -147 | N/A | N/A | N/A | -19.11 | N/A | N/A | -166.11 | CAD | N/A |  | N/A | BANK #1 | $BALANCE
Spreadsheet: darrell_schoolcraft__7316__imball0202
Sheet: Devon

 | Devon SFS Operating
 | POI 36289 - Bilbrey 28 Fed 1 C/P
Day | Measured | Scheduled
1 | 1125 | 180
2 | 1804 | 180
3 | 1335 | 180
4 | 1743 | 180
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
2002-01-31 00:00:00 |  |  | 146608
2002-02-04 00:00:00
CBS Volume
 |  |  | 26945
Spreadsheet: 836036d1689062334-extract-data-based-on-two-dates-sample
Sheet: CT

start | 2023-01-01 00:00:00
end | 2023-12-31 00:00:00
S/N | Customer | Name | Due date
Spreadsheet: 866173d1713147187-in-spec-out-of-spec-formula-blank-grade-form
Sheet: Fault Trending 2022

 |  |  | Year | 2021
 |  |  | Good | Satisfactory | Unacceptable | Good (%) | Satisfactory (%) | Unacceptable (%)
 |  | Length
 |  | Diameter
 |  | Density
 |  | Moisture
 |  | Dust
 |  | Coating
 |  | Cross Contamination
 |  | Appearance
 |  | Odour |  |  |  |  |  |  | Month Number;
 |  |  |  |  |  |  |  |  | 12
 |  |  | 2022 (Total) |  |  |  |  |  | 1900-01-05 00:00:00 |  |  |  |  |  |  |  |  | Length |  |  | Diameter |  |  | Density |  |  | Moisture |  |  | Dust |  |  | Coating |  |  | Cross Contamination |  |  | Appearance |  |  | Odour
 |  |  | Good | Satisfactory | Unacceptable | Good (%) | Satisfactory (%) | Unacceptable (%) | Good | Satisfactory | Unacceptable | Good (%) | Satisfactory (%) | Unacceptable (%) |  |  |  | Good | Satisfactory | Unacceptable | Good | Satisfactory | Unacceptable | Good | Satisfactory | Unacceptable | Good | Satisfactory | Unacceptable | Good | Satisfactory | Unacceptable | Good | Satisfactory | Unacceptable | Good | Satisfactory | Unacceptable | Good | Satisfactory | Unacceptable | Good | Satisfactory | Unacceptable
 |  | Length |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | Jan
 |  | Diameter |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | Feb
 |  | Density |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | Mar
 |  | Moisture |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | Apr
 |  | Dust |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | May
 |  | Coating |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | Jun
 |  | Cross Contamination |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | Jul
 |  | Appearance |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | Aug
 |  | Odour |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | Sep
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | Oct
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 | Nov
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | Dec
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Length |  |  | Diameter |  |  | Density |  |  | Moisture |  |  | Dust |  |  | Coating |  |  | Cross Contamination |  |  | Appearance |  |  | Odour
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Good | Satisfactory | Unacceptable | Good | Satisfactory | Unacceptable | Good | Satisfactory | Unacceptable | Good | Satisfactory | Unacceptable | Good | Satisfactory | Unacceptable | Good | Satisfactory | Unacceptable | Good | Satisfactory | Unacceptable | Good | Satisfactory | Unacceptable | Good | Satisfactory | Unacceptable
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jan
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Feb
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mar
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Apr
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | May
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jun
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jul
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Aug
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sep
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Oct
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nov
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dec
Spreadsheet: 743172d1628266937-extract-text-extract-text-in-between
Sheet: Sheet1

 | Desired result
GERMANY-500-OBERMAIN-C-15_10 | 15
BRAZIL-5000-SAMBA-C-M_2 | M |  | M
ITALY-5000-LAZIO-C-XL_2 | XL |  | XL
FRANCE-2500-PSG-C-2125_2 | 21/25 |  | 21/25
AUSTRALIA-1300-SYDNEY-L-2630_6 | 26/30 |  | 26/30
ENGLAND-500-BECKHAM-L-15_10 | 15 |  | 15
I want to extract text in between "-C-" (somestimes also can be "-L-", example in cell A7 and A8) and "_"
For those result that have 4 characters, stroke "/" will insert in the middle of the text. Example please refer in cell [NAME] and B7
Spreadsheet: 300995d1393622834-converting-a-database-to-an-xml-table-in-excel-sample
Sheet: Final

Name | [NAME] | LVL | Dur | Con | Qual | Modele | DPSAF | SPDABS | Main | DT | OT | IT | Poind | Bon | Bon1 | bonus | Bon2 | bonus2 | Bon3 | bonus3 | Bon4 | [NAME] | Bon5 | bonus5 | Bon6 | bonus6 | Bon7 | bonus7 | [NAME] | bonus8 | Bon9 | bonus9 | Bon10 | bonus10 | EBon | bonus11 | Charge | [NAME] | Charge2 | Max12 | Sort | Sort_Description | Sort_FrDescription | Sort_Target | Sort_Range | Sort_Damage | Sort_DamageType | Sort_Duration | Sort_Frequency | Sort_Pulse | Sort_PulsePower | Sort_ResurrectHealth | Sort_ResurrectMana | Sort_Value | Sort_LifeDrainReturn | Sort_AmnesiaChance | Sort2 | ProcSort | [NAME] | Royaume | PourClasses | UtilTTLes | LVLReq | Chance | Nom13 | FrNom14 | Lvl15 | Localisation | ProcSort_Description | ProcSort_FrDescription | ProcSort_Target | ProcSort_Range | ProcSort_Damage | ProcSort_DamageType | ProcSort_Duration | ProcSort_Frequency | ProcSort_Pulse | ProcSort_PulsePower | ProcSort_ResurrectHealth | ProcSort_ResurrectMana | ProcSort_Value | ProcSort_LifeDrainReturn | ProcSort_AmnesiaChance | Charges2 | Max16 | MinLVLOtd
[NAME] | [NAME] | 50 | 100 | 100 | 95 | 112 | 0 | 0 | 0 | 153 | 525 | 572 | 10 | 35 | 960 | 888 | 550 | 198 | 469 | 48 | 954 | 756 | 866 | 55 | 421 | 753 | 344 | 795 | 758 | 15 | 825 | 86 | 648 | 79 | 477 | 457 | 10 | 10 | 0 | 0 | 2653 | Target regenerates health faster for the duration of the spell | La cible régénére sa vie plus vite pendant la durée du sort. | Self | 0 | 0 | 153 | 600 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 0 | 824 | 824 | 824 | 3 | yFISNeaFK2c= | 0 | 0 | R | Orin le Blafard | Orin le Blafard | 61 | Sheeroe Hills
A Burnt Ember | A Burnt Ember | 16 | 100 | 100 | 89 | 118 | 0 | 0 | 0 | 153 | 525 | 572 | 0 | 5 | 959 | 846 | 555 | 168 | 425 | 38 | 954 | 756 | 866 | 55 | 421 | 753 | 344 | 795 | 758 | 15 | 825 | 86 | 648 | 79 | 477 | 457 | 0 | 0 | 0 | 0 | 824 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 824 | 824 | 824 | 3 | yFISNeaFK2c= | 0 | 0 | R