tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 232743d1367516103-corrupted-file-ascent-groundwork-boq
Sheet: Site 21

 |  | 33 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 39 |  | 0 | 0
 |  | 4 |  | 0 | 0
 |  | 104 |  | 0 | 0
 |  | 113 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 73 |  | 0 | 0
 |  | 11 |  | 0 | 0
 |  | 137 |  | 0 | 0
 |  | 137 |  | 0 | 0
 |  | 64 |  | 0 | 0
 |  |  |  |  | 2579.24
 |  | 14 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 39 |  | 0 | 0
 |  | 5 |  | 0 | 0
 |  | 13 |  | 0 | 0
 |  | 12 |  | 0 | 0
 |  |  |  |  | 7003.17
 |  | 112 |  | 0 | 0
 |  |  |  |  | 0
 |  | 112 |  | 0 | 0
 |  | 77 |  | 0 | 0
 |  |  |  |  | 0
 |  | 1 |  | 0 | 0
 |  | 4 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 4 |  | 0 | 0
 |  | 4 |  | 0 | 0
 |  | 16 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 4 |  | 0 | 0
 |  |  |  |  | 1499.12
 |  | 33 |  | 0 | 0
 |  |  |  |  | 473.55
 |  | 949 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 688 |  | 0 | 0
 |  | 20 |  | 0 | 0
 |  |  |  |  | 3093
 |  | 62 |  | 0 | 0
 |  | 39 |  | 0 | 0
 |  | 46 |  | 0 | 0
 |  | 36 |  | 0 | 0
 |  | 32 |  | 0 | 0
 |  | 71 |  | 0 | 0
 |  | 12 |  | 0 | 0
 |  | 7 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 298 |  | 0 | 0
 |  |  |  |  | 5916
 |  | 3 |  | 0 | 0
 |  | 2 |  | 0 | 0
 |  | 3 |  | 0 | 0
 |  | 24 |  | 0 | 0
 |  | 4 |  | 0 | 0
 |  | 21 |  | 0 | 0
 |  | 24 |  | 0 | 0
 |  | 16 |  | 0 | 0
 |  | 6 |  | 0 | 0
 |  |  |  |  | 2703.14
 |  | 25 |  | 0 | 0
 |  | 69 |  | 0 | 0
 |  | 2 |  | 0 | 0
 |  | 28 |  | 0 | 0
 |  | 67 |  | 0 | 0
 |  | 22 |  | 0 | 0
 |  | 81 |  | 0 | 0
 |  | 71 |  | 0 | 0
 |  | 62 |  | 0 | 0
 |  |  |  |  | 7137.97
 |  | 39 |  | 0 | 0
 |  | 68 |  | 0 | 0
 |  |  |  |  | 2547.67
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  |  |  |  | 412.29
 |  | 44 |  | 0 | 0
 |  | 3 |  | 0 | 0
 |  | 29 |  | 0 | 0
 |  | 2 |  | 0 | 0
 |  | 14 |  | 0 | 0
 |  | 4 |  | 0 | 0
 |  | 2 |  | 0 | 0
 |  | 5 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 11 |  | 0 | 0
 |  | 2 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  |  |  |  | 0
 |  | 1 |  | 0 | 0
 |  | 2 |  | 0 | 0
 |  | 0 |  | 0 | 0
 |  | 0 |  | 0 | 0
 |  | 0 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 9 |  | 0 | 0
 |  |  |  |  | 0
 |  | 9 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 26 |  | 0 | 0
 |  | 5 |  | 0 | 0
 |  | 2 |  | 0 | 0
 |  | 5 |  | 0 | 0
 |  | 2 |  | 0 | 0
 |  | 2 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  |  |  |  | 0
 |  | 1 |  | 0 | 0
 |  | 5 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  |  |  |  | 0
Spreadsheet: 46964d1245873499-create-custom-list-from-pivot-table-drop
Sheet: Sheet1

Item | Profit Margin | Profit Margin Value | >40 |  |  | Count of Profit Margin
widget a | Profit Margin | 0.25 | 1 |  |  | Item | >40 | Total
widget b | Profit Margin | 0.3 | 1 |  |  | widget a | 1 | 1
widget c | Profit Margin | 0.35 | 1 |  |  | widget b | 1 | 1
widget d | Profit Margin | 0.4 | 1 |  |  | widget c | 1 | 1
widget e | Profit Margin | 0.5 | 0 |  |  | widget d | 1 | 1
Sum of Profit Margin Value | Profit Margin
Item | Profit Margin | Grand Total
widget a | 0.25 | 0.25
widget b | 0.3 | 0.3
widget c | 0.35 | 0.35
widget d | 0.4 | 0.4
widget e | 0.5 | 0.5
Grand Total | 1.8 | 1.8
Drop Down Menu Here
I want the drop down selections to only provide option of items with a profit margin below 40%.
Spreadsheet: 704551d1605620502-if-isnumber-search-and-or-with-extra-criteria-erf-log-projects-web-post
Sheet: Kickoff

EQUALS FORMULA | Site [NAME] | Date (Estimate Complete) | SORT ALL FROM HERE Date  (Outage Start) | Notes | SN# or PO# or  WBS# | SO# (ZM02, ZM03) OR MHPS Standard Order |  |  |  |  |  |  |  |  | Kickoff
Spreadsheet: 885091d1734520360-contitional-formatting-lowest-number-but-ingore-if-cell-blank-book2-etaf
Sheet: Sheet1

 |  |  |  |  |  | CURRENT CONDITIONAL FORMATTING |  |  |  |  |  | RESULT WANTED
 |  |  |  |  |  | 123 | 200 |  |  |  |  | 123 | 200
 |  |  |  |  |  | 693 | 594 |  |  |  |  | 693 | 594
 |  |  |  |  |  | 406 | 101 |  |  |  |  | 406 | 101
 |  |  |  |  |  | 3192 |  |  |  |  |  | 3192
 |  |  |  |  |  | 27 |  |  |  |  |  | 27
 |  |  |  |  |  | 31 |  |  |  |  |  | 31
 |  |  |  |  |  | 13 | 200 |  |  |  |  | 13 | 200
 |  |  |  |  |  | 1244 | 380 |  |  |  |  | 1244 | 380
 |  |  |  |  |  | 288 |  |  |  |  |  | 288
 |  |  |  |  |  | 1244 |  |  |  |  |  | 1244
 |  |  |  |  |  | 160 | 150 |  |  |  |  | 160 | 150
 |  |  |  |  |  | 34152 | 20520 |  |  |  |  | 34152 | 20520
 |  |  |  |  |  | 2385 |  |  |  |  |  | 2385
 |  |  |  |  |  | 41 |  |  |  |  |  | 41
 |  |  |  |  |  | 380 |  |  |  |  |  | 380
 |  |  |  |  |  | 694 | 54 |  |  |  |  | 694 | 54
Spreadsheet: 542504d1507896187-two-columns-to-one-to-and-from-example
Sheet: Sheet1

What I have |  |  |  |  | What I want to have
1 | 1 | A |  |  | 1 | A
2 | 4 | B |  |  | 2 | B
5 | 10 | C |  |  | 3 | B
11 | 11 | D |  |  | 4 | B
12 | 12 | E |  |  | 5 | C
 |  |  |  |  | 6 | C
 |  |  |  |  | 7 | C
 |  |  |  |  | 8 | C
 |  |  |  |  | 9 | C
 |  |  |  |  | 10 | C
 |  |  |  |  | 11 | D
 |  |  |  |  | 12 | E
Spreadsheet: 119220d1314276347-excel-2007-sumifs-problem-samplestrength
Sheet: Sheet3

17th SB | 362nd OD | [NAME] | 150TH OD | 221ST CAV | CO B CAV | CO C CAV | PAX  - 5 | 137 MP | 72 MP |  | selected from dropdown
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |  | MTOE
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |  | AGR
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |  | ADMIN
Spreadsheet: darrell_schoolcraft__7819__imbalsumm0109
Sheet: summary

TRANSWESTERN  PIPELINE -   SUMMARY OF OBA BALANCES |  |  |  |  |  | index
 |  |  |  |  |  | SJ
Positive=due [NAME] |  | Negative = due operator |  |  |  | AVG
 |  |  |  |  |  | NTXPH
Operator | Dollars | Volume | Date | Imbal Type | MS rep | Comments
NNG |  |  |  | Dollar Valued | [NAME]
EPFS / PG&E TX |  |  |  | Dollar Valued | [NAME]
[NAME] |  |  |  | Dollar Valued | [NAME]
Conoco |  |  |  | Dollar Valued | [NAME] | [NAME] and Maljamar
[NAME] |  |  |  | Volumetric | [NAME]
Amoco Abo |  |  |  | Dollar Valued | [NAME]
CIG |  |  |  | Dollar Valued | [NAME] | if changed to volumetric the volume would be 61,000 mmbtus
SoCal |  |  |  | Volumetric | [NAME]
Mewborne |  |  |  | Dollar Valued | [NAME]
NGPL |  |  |  | Volumetric | [NAME]
Mojave Pipeline |  |  |  | Volumetric | [NAME]
Red Cedar |  |  |  | Volumetric | [NAME]
Agave |  |  |  | Dollar Valued | [NAME]
Lonestar |  |  |  | Volumetric | [NAME]
PNM |  |  |  | Dollar Valued | [NAME]
Amoco |  |  |  | Volumetric | [NAME]
Northwest |  |  |  | Volumetric | [NAME]
Panhandle Eastern |  |  |  | Volumetric | [NAME] | Hansford
Oasis |  |  |  | Volumetric | [NAME]
PG&E Topock |  |  |  | Volumetric | [NAME]
Calpine |  |  |  | Dollar Valued | [NAME]
EOG |  |  |  | Dollar Valued | [NAME]
[NAME] |  |  |  | Dollar Valued | [NAME] | cashed out monthly
TransColorado |  |  |  | Dollar Valued | [NAME]
Burlington |  |  |  | Dollar Valued | [NAME] | balance is cashed out monthly
Continental |  |  |  | Dollar Valued | [NAME]
Receivable imbalances
Operator | Dollars | Volume | Date | Imbal Type | MS rep | Comments
Citizens Communications |  |  |  | Dollar Valued | [NAME]
North Star Steel |  |  |  | Dollar Valued | [NAME]
Citizens-Griffith |  |  |  | Dollar Valued | [NAME]
El Paso Field Services |  |  |  | Dollar Valued | [NAME]
Duke/GPM |  |  |  | Dollar Valued | [NAME] | Crawford, Pecos Diamond, [NAME], Linam Ranch, Artesia
El Paso |  |  |  | Volumetric | [NAME] | Blanco and Window Rock
Payable imbalances
Net imbals
Note -  This report does not represent the total population of imbalances on Transwestern.
Spreadsheet: 867853d1714640018-formula-to-zero-tables-within-kpi-spreadsheet-new-hs-kpi-updated-max-percentage-100
Sheet: H&S West DS

 |  |  |  |  | Friday to Thursday
 | Safety | Points avaliable | Month score | Total | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Monthly Target | Annual Target | % | Clancy Target | % Against Target
 | Major injury | -50 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Lost time injury | -25 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Non-lost time injury | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Service Strike (HV) | -20 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Service Strike (LV) | -15 |  |  | 0 | 0 | 0 | 0 | 0 | Less than 3 | Less than 36 |  | <6
 | Service Strike (Gas) | -10 |  |  | 0 | 0 | 0 | 0 | 0 |  |  |  | <33
 | Service Strike (Other) | -5 |  |  | 0 | 0 | 0 | 0 | 0 |  |  |  | <33
 | Manager [NAME] | 0.1 |  |  | 0 | 0 | 0 | 0 | 0 | 4
 | Safety observations | 0.01 |  |  | 0 | 0 | 0 | 0 | 0 | 25
 | H&S advisor visits | 0.2 |  |  | 0 | 0 | 0 | 0 | 0 | 6
 | Manager/Supervisor Safety Visits | 0.01 |  |  | 0 | 0 | 0 | 0 | 0 | 13
 | [NAME] | 0.01 |  |  | 0 | 0 | 0 | 0 | 0 | 50
 | ABC Tours | 0.01 |  |  | 0 | 0 | 0 | 0 | 0 | 2
 | HAVS |  |  |  | 0 | 0 | 0 | 0 | 0
 | Total
Spreadsheet: 472913d1469837367-import-specific-cells-in-multiple-sheets-from-hundreds-of-identical-workbooks-imp_ds_templatefordb
Sheet: 12-Dents, Mechanical Damage

Section 12.0 - Indications of Mechanical Damage
The zero (0) foot axial reference is located at Station Number/Mile Post:
Footage increasing toward downstream side.
Are there any indications of mechanical damage? |  |  |  |  |  |  |  | Yes |  | P | No
# | Defect Type (Dent, gouge, scrape, other) | Party Damage (1, 2, 3) | Distance Along Excavation (ft.-in.) | Clock Position 3/6/9/12 | Defect Length (axial) (inches) | Defect [NAME] (radial) (inches) |  |  | Defect Depth ([NAME])
1 | gouge | 3 | 3 | 12 | 19 | 34 |  |  | 8.25
2
3
4
5
6
7
8
9
10
11
12
13
14
15
Detailed defect descriptions/general comments:
No mechanical damage found.
* Data Required
Spreadsheet: 842446d1694524082-get-all-id-values-for-looking-up-a-value-in-a-range-excel-2016-excelforum_vulturie
Sheet: Munka1

ID | Values | Looking for | Function | Expected
1 | 215-535-7, 287-477-0 | 287-477-0 |  | 1,8,10
2 | 64-17-5, 78-93-3, 67-63-0
3 | 64-17-5
4 | 1333-86-4
5 | 13463-67-7
6 | 13463-67-7
7 | 110-54-3, 108-88-3, 71-43-2
8 | 287-477-0, 200-857-2, 204-065-8, 200-827-9, 904-153-2
9 | 68478-92-2
10 | 691-647-3, 287-477-0, 204-065-8, 200-857-2, 200-827-9, 807-935-0
Spreadsheet: 00752664-b1c6-49b7-84fe-c7166580f51a
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FMDMC | Test | FMDMC | Complete DMD Evaluation-Males | Complete DMD Evaluation-Males | DMD Deletion/duplication: Dosage analysis of all exons on the DMD gene | EDTA (lavender-top) tube: EDTA |  |  | 20 | mL | 20 mL whole blood collected in a lavender top (EDTA) tube(s). Send whole blood at ambient temperature. | 10 mL | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA | A final report will be attached in MayoAccess.   Test Performed by Athena Diagnostics                                       377 Plantation Street                                       Four Biotech Park                                       Worcester, MA 01605 | Monday, Thursday | 6-8 weeks | 6-8 weeks |  | Profile |  |  |  |  | Athena Diagnostics
FMDMC | [NAME] | WBEDTA | [NAME] EDTA |  |  |  | Ambient
FMDMC | Component | Z0089 | Partial DMD Del/Dup | Partial DMD Del/Dup | DMD Deletion/duplication Dosage analysis of all exons on the DMD gene Only orderable as part of profile FMDMC "Complete DMD Evaluation-Males" |  |  |  |  |  | Only orderable as part of a profile. For further information see FMDMC "Complete DMD Evaluation-Males" |  |  | Only orderable as part of a profile. For further information see FMDMC "Complete DMD Evaluation-Males" |  |  |  | 1 | 81161 |  |  | Yes | No
Z0089 | [NAME] | WBEDTA | [NAME] EDTA |  |  |  | Ambient
Z0089 | Result | Z0089 | Partial DMD Del/Dup | Partial DMD Del/Dup | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FMDMC | Component | Z0090 | Partial DMD Sequencing | Partial DMD Sequencing | Only orderable as part of profile FMDMC "Complete DMD Evaluation-Males" |  |  |  |  |  | Only orderable as part of profile FMDMC "Complete DMD Evaluation-Males" |  |  | Only orderable as part of profile FMDMC "Complete DMD Evaluation-Males" |  |  |  | 1 | 81408 |  |  | No | No
Z0090 | [NAME] | WBEDTA | [NAME] EDTA |  |  |  | Ambient
Z0090 | Result | Z0090 | Partial DMD Sequencing | Partial DMD Sequencing | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 276cf87c-a2a2-4a84-b1f5-124a99af70f4
Sheet: Sheet1

Fastställda seniorserier [NAME] | Unnamed: 1
[NAME]. 2 Herrar VSV | Serieform
HK S-hof | 12 lag dubbelmöte
HP Alingsås | 22 omgångar
Halmstads HP IF
Mölndals HF
Team Drott
[NAME]
HP Tibro
[NAME]
[NAME]
KFUM Trollhättan
[NAME]
IK Nord
[NAME]. 3 Herrar VSN | Serieform
HK Lidköping | 12 lag dubbelmöte
KFUM Ulricehamn | 22 omggångar
Lysekils HK
IFK Hammarö
HP Skövde 90
HK Guldkroken
IF Hellton
IFK Karlsborg
[NAME]
IFK Kristinehamn
IF HV Tidaholm
[NAME]
[NAME]. 4 Herrar VG | Serieform
Borås HF | 12 lag dubbelmöte
Falköpings AIK HK | 22 omgångar
Byttorps IF
HK Country U
HK [NAME]
HP Tibro U (HP Hyveln)
HP Skövde 90 U
KFUM Trollhättan U
Nossebro IF
[NAME]
Vårgårda IK
Kropps 10
[NAME]. 5 Herrar VG | Serieform
[NAME] | 8 lag dubbelmöte
HK Guldkroken C | 14 omgångar
HK Lidköping U
HP Tibro C
IF HV [NAME]
KFUM Ulricehamn U
Mariestads AIF
[NAME]
[NAME]. 2 Damer VSN | Serieform
KFUM Trollhättan | 11 lag dubbelmöte
Tibro HK | 22 omgångar
HK Lidköping U
Karlskoga HF
[NAME]
IF [NAME]
IFK Hammarö
Team 172
Lysekils HK
[NAME]
[NAME]
[NAME]. 3 Damer VG | Serieform
Borås HF | 10 lag dubbelmöte
Falköpings AIK HK | 18 omgångar
[NAME]
HK Country
HK Guldkroken/IFK Karlsborg
HK Lidköping B
KFUM Trollhättan U
Nossebro IF/Vårgårda IK
[NAME]
[NAME]
Spreadsheet: 83348d1283342420-deriving-a-function-formula-from-a-complete-and-an-incomplete-set-of-data-example2
Sheet: Tabelle1

 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
233.6 | 0.8 | 0.794737 | 0.789473 | 0.784211 | 0.778947 | 0.773684 | 0.768421 | 0.763158 | 0.757895 | 0.752632 | 0.747368 | 0.742105 | 0.736842 | 0.731579 | 0.726316 | 0.721053 | 0.715789 | 0.710526 | 0.705263 | 0.7
232.7
231.8
230.9
230
229.1
228.2
227.3
226.4
225.5
224.6
223.7
222.8
221.9
221
220.1
219.2
218.3
217.4
216.5
215.6
214.8 | 1.00416662 | 0.99736684
213.9 |  |  | 1.00014588
213 |  |  |  | 1.002778413 | 0.9958333200000005
212.1 |  |  |  |  |  | 0.9982460000000006
211.2 |  |  |  |  |  |  | 1.000512249999999
210.3 |  |  |  |  |  |  |  | 1.00263243
209.4 |  |  |  |  |  |  |  |  | 1.00460637491 | 0.9973681000000006
208.5 |  |  |  |  |  |  |  |  |  |  | 0.9991233639999992
207.6 |  |  |  |  |  |  |  |  |  |  |  | 1.00073222
206.7 |  |  |  |  |  |  |  |  |  |  |  |  | 1.002194399999998
205.8 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.00351038
204.9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.004680415999999 | 0.9970783120000016
204 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.9980283639999988
203.1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.9988327740000018
202.2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.9994909549999982
201.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.999999880000001
200.4
199.5
198.6
197.7
196.8
195.9
195
194.1
193.2
192.3
191.4
190.5
189.6
188.7
187.8
186.9
186
185.1
184.2
183.3
182.4
181.5
180.6
179.7
178.8
177.9
177.1
176.2
175.3
174.4
173.5
172.6
171.7
170.8
169.9
169 | 1.49999984 | 1.48946788 | 1.47894788 | 1.468422032000005 | 1.457895479999996 | 1.447370000000002 | 1.436843799999998 | 1.426317959999996 | 1.415791999759996 | 1.405261599999997 | 1.394738935999998 | 1.38421396 | 1.373687759999996 | 1.363161559999996 | 1.352635936000002 | 1.342109952000003 | 1.331583976000002 | 1.321057992000004 | 1.310531935999996 | 1.299999759999998
Spreadsheet: larry_campbell__21410__2002 ETS OM 03 Budget
Sheet: North - Ron Biedelman

NORTH AREA TEAM
[NAME]
 |  |  |  | 52505500 |  |  |  | 52508000 |  |  | 52509000
Company | State | Facility | Status | Title V Fee | Other Permit Fee | EIQ Fee | Testing | Title V Prep/Renewal | [NAME]. | Other Permit Prep/Renewal | Environmental Expense
0172
0179 | MN | CARLTON COMPRESSOR STATION | Active |  |  | 481 |  |  | 0
 | MN | WRENSHALL LNG PLANT | Active |  |  | 611 |  |  | 0
 | MN | FARMINGTON COMPRESSOR STATION | Active |  |  | 8458 |  |  | 0
 | MN | NORTH BRANCH COMPRESSOR STATION | Active |  |  | 589 |  |  | 0
 | MN | OWATONNA TURBIN PLANT | Active |  |  | 2166 |  |  | 0
 | MN | FARIBAULT COMPRESSOR STATION | Active |  |  | 657 |  |  | 0
 | MN | HUGO COMPRESSOR STATION | Active |  |  | 25 |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 | IA | VENTURA COMPRESSOR STATION | Active |  |  | 399 |  |  | 0
 | IA | GARNER LNG PLANT | Active |  |  | 63 |  |  | 0
 | IA | PAULLINA COMPRESSOR STATION | Active
 | ND | FT BUFORD COMPRESSOR STATION | Active |  |  | 0 |  |  | 0
 | MT | BLAINE COUNTY #1 COMPRESSOR STATION | SOLD
 | MT | BLAINE COUNTY #3 COMPRESSOR STATION | SOLD
 | MT | HILL COUNTY #1 COMPRESSOR STATION | SOLD
 | CO | MESA COUNTY #1 COMPRESSOR STATION | SOLD
 | CO | MESA COUNTY #3 COMPRESSOR STATION | SOLD
 | CO | RIO BLANCO #1 COMPRESSOR STATION | SOLD
 | CO | ROUTT COUNTY #1 COMPRESSOR STATION | SOLD
 | MI | WAKE FILED COMPRESSOR STATION | Abandoned
Spreadsheet: 372649d1422124510-parse-text-string-based-on-unique-input-parse-exercise-expected-results
Sheet: Sheet1

 | Name | Address | Postcode | Town
[NAME]. 38 45242 Camus | [NAME] | Streetnumber. 38 | 45242 | Camus
[NAME]. 30 45153 Shortview | [NAME] | Streetname.30 | 45153 | Shortview
[NAME]. 1 45352 Dudvile | [NAME] | [NAME]. 1 | 14352 | Dudvile
Copel-Minx Antonia Beech Hextown. 23 45646 [NAME] | Copel-Minx Antonia Beech | Hextown.23 | 45646 | Kruger
Spreadsheet: 884494d1733710962-rept-to-column-base-on-cell-value-paste-1-
Sheet: Sheet1

Code | 3 | How to I generate a formula that can copy A2:A6 n paste number of times base on B1
HTL- J891 |  | Is it possible to have AAABBBCCCDDDEEEFFF and also ABCDEAABCDEABCDEABCDEABCDE |  |  |  | [NAME] Q6767$JKY- Q6767$JKY- Q6767$ |  | HTL- J891
[NAME] |  |  |  |  |  | PPY- U7666$PPY- U7666$PPY- U7666$ |  | HTL- J891
PPY- U7666 |  | Formula 1 | Formula 2 |  |  | HOL- [NAME] HDD$HOL- HDD$
HOL- HDD |  | HTL-J891 | HTL- J891 |  |  | KL- HDD$KL- HDD$KL- HDD$
KL- HDD |  | JKY-Q6767 | HTL- J891 | [NAME] | HTL- J891
 |  | PPY-U7666 | HTL- J891 | PPY- U7666 | HTL- J891
 |  | HOL-HDD | [NAME] | HOL- HDD | [NAME]
 |  | KL-HDD | [NAME] | KL- HDD | [NAME]
 |  | HTL-J891 | [NAME] | HTL- J891 | [NAME] | My failed attempt (ignore)
 |  | JKY-Q6767 | PPY- U7666 | [NAME] | PPY- U7666
 |  | PPY-U7666 | PPY- U7666 | PPY- U7666 | PPY- U7666
 |  | HOL-HDD | PPY- U7666 | HOL- HDD | PPY- U7666
 |  | KL-HDD | HOL- HDD | KL- HDD | HOL- HDD
 |  | HTL-J891 | HOL- HDD | HTL- J891 | HOL- HDD
 |  | JKY-Q6767 | HOL- HDD | [NAME] | HOL- HDD
 |  | PPY-U7666 | KL- HDD | PPY- U7666 | KL- HDD
 |  | HOL-HDD | KL- HDD | HOL- HDD | KL- HDD
 |  | KL-HDD | KL- HDD | KL- HDD | KL- HDD
Spreadsheet: 804479d1668097496-sumifs-until-a-new-date-is-found-exampleworkbookrepair
Sheet: Sheet1

Year | 2021
Month | Expected Salary Value Totals | Attempted Formula | Comment on [NAME] | Comment for [NAME] requirement
2021-01-01 00:00:00 |  |  | As expected | Summing up all values for employees where effective date is before end of January |  | Lookup Table
2021-02-01 00:00:00 |  |  | As expected | Summing up all values for employees where effective date is before end of February (still taking January values) |  | Employee | Effective Date | [NAME]
2021-03-01 00:00:00 |  |  | As expected | Summing up all values for employees where effective date is before end of March (still taking January values) |  | Employee 1 | 2021-01-01 00:00:00 | 30000
2021-04-01 00:00:00 |  |  | As expected | Summing up all values for employees where effective date is before end of April (still taking January values) |  | Employee 1 | 2021-07-01 00:00:00 | 35000 |  |  |  | Employee 2
2021-05-01 00:00:00 |  |  | As expected | Summing up all values for employees where effective date is before end of May (still taking January values) |  | Employee 2 | 2021-01-01 00:00:00 | 40000 |  |  |  | Employee 3
2021-06-01 00:00:00 |  |  | As expected | Summing up all values for employees where effective date is before end of June (still taking January values) |  | Employee 2 | 2021-07-01 00:00:00 | 50000
2021-07-01 00:00:00 |  |  | Doubles up to include the values prior to July (January + July) | Summing up all values for employees where effective date is before end of July (now taking new July values) |  | Employee 2 | 2021-09-01 00:00:00 | 60000
2021-08-01 00:00:00 |  |  | Doubles up to include the values prior to August (January + July) | Summing up all values for employees where effective date is before end of August (now taking new July values) |  | Employee 3 | 2021-01-01 00:00:00 | 60000
2021-09-01 00:00:00 |  |  | Doubles up to include the values prior to September (January + July + September) | Summing up all values for employees where effective date is before end of September (now taking new July values for Employee 1 and 3 and new September value for Employee 2) |  | Employee 3 | 2021-07-01 00:00:00 | 63000
2021-10-01 00:00:00 |  |  | Doubles up to include the values prior to October (January + July + September) | Summing up all values for employees where effective date is before end of October (now taking new July values for Employee 1 and 3 and September value for Employee 2)
2021-11-01 00:00:00 |  |  | Doubles up to include the values prior to November (January + July + September) | Summing up all values for employees where effective date is before end of November (now taking new July values for Employee 1 and 3 and September value for Employee 2)
2021-12-01 00:00:00 |  |  | Doubles up to include the values prior to December (January + July + September) | Summing up all values for employees where effective date is before end of December (now taking new July values for Employee 1 and 3 and September value for Employee 2)
Spreadsheet: 541296d1507211946-need-something-to-find-duplicates-across-sheets-inventory-accuracy-template
Sheet: Exempt - Closed

Area | Region | Location Number | Location Name | Country | Ending Inventory | Total $ Counted | Value Difference | Inventory $ [NAME] | Number Of Parts Counted | Number Of Parts Counted With Errors | Count Error Rate | Book Quantity | Counted Quantity | Piece Count Error Rate | Operational Error Rate | Operational Count Delta | Status | Location Type | Last Wall To Wall | Notes
 |  |  | US TOTAL
Area | Region | Location Number | Location Name | Country | Ending Inventory | Total $ Counted | Value Difference | Inventory $ [NAME] | Number Of Parts Counted | Number Of Parts Counted With Errors | Count Error Rate | Book Quantity | Counted Quantity | Piece Count Error Rate | Operational Error Rate | Operational Count Delta | Status | Location Type | Last Wall To Wall
 |  |  | CAN TOTAL
Spreadsheet: 717885d1612889343-search-intervall-and-find-suitable-value-grades
Sheet: Grades

Name | Average Grade | Norm Grade
[NAME] | 1.9 | 2
Lydia | 1.4 | 1.3
Maxime | 2.3 | 2.3
[NAME] | 3.6 | 3.7
[NAME] | 2.7 | 2.7
Spreadsheet: 843586d1695376651-divide-multiple-sums-of-cells-based-on-days-comasate-as-weeks-enel-distributie-excel
Sheet: Sheet1

Week end | Week start | week | Month | Area | Service | KPI Type | KPI | KPI ID | Weekly | Monthly |  | 2023-08-31 00:00:00
 |  |  |  | Enel | Distriutie | Contractual | LOS | 6
 |  |  |  | Enel | Distriutie | Contractual | LOS | 6
 |  |  |  | Enel | Distriutie | Contractual | LOS | 6
 |  |  |  | Enel | Distriutie | Contractual | LOS | 6
 |  |  |  | Enel | Distriutie | Contractual | LOS | 6 |  |  | 64 | 7363 | 13652
 |  |  |  | Enel | Distriutie | Contractual | LOS | 6
 |  |  |  | Enel | Distriutie | Contractual | LOS | 6
 |  |  |  | Enel | Distriutie | Contractual | LOS | 6
 |  |  |  | Enel | Distriutie | Contractual | LOS | 6
 |  |  |  | Enel | Distriutie | Contractual | LOS | 6
 |  |  |  | Enel | Distriutie | Contractual | LOS | 6
 |  |  |  | Enel | Distriutie | Contractual | LOS | 6
 |  |  |  | Enel | Distriutie | Contractual | LOS | 6
 |  |  |  | Enel | Distriutie | Contractual | LOS | 6
 |  |  |  | Enel | Distriutie | Contractual | LOS | 6
 |  |  |  | Enel | Distriutie | Contractual | LOS | 6