tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 787dadf9-d115-4ce4-82d3-28d83672c8ed
Sheet: Sheet1

Adresseliste fra www.proff.no | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
[NAME]:Møbeltapetserere
FIRMANAVN | ADRESSE | POSTNR. | POSTSTED | TELEFON | TELEFAKS
Wiels Møbeltapetsererverksted |  | 1954 | [NAME] | 928 94 433
Porsanger Arbeidssamvirke AS | Laatasv. | 9700 | [NAME] | 78 46 15 22 | 78 46 18 51
Bjørno's Møbeltapetsering | Brusetsvingen 27 | 1395 | Hvalstad | 66 84 84 20
[NAME] | Normannsgata 43 | 0655 | Oslo | 22 68 10 00
Sørensen salmaker | Ålefjærveien 371 | 4634 | Kristiansand | 38 19 80 20
Interiørservice | Hvalsmoen 146 | 3514 | Hønefoss | 991 56 780
[NAME] | Blektjernveien 11A | 3046 | Drammen | 32 83 50 14
Bergen Håndtverkssenter AS | [NAME] | 5179 | Godvik | 55 94 13 20 | 55 26 44 00
Walløe & Nilsen AS | Nattlandsveien 155 | 5094 | Bergen | 55 90 11 40
Os [NAME] | Borgavegen 12 | 5211 | Os | 940 38 811
[NAME] | Finsalvegen 92 | 2322 | Ridabu | 934 39 877
Sara søm og møbeltapetsering | Prinsessegata 1 | 3724 | Skien | 35 52 58 03 | 35 52 58 03
[NAME] | Kongshavns gata 1A | 3970 | Langesund | 905 16 738
[NAME] | [NAME] | 3095 | Eidsfoss | 33 05 72 40
[NAME] | Hagen | 1827 | [NAME] | 69 92 43 50 | 69 92 43 51
[NAME] | Tvetenveien 32B | 0666 | Oslo | 22 65 06 80
Nadine Møbeltapetserverksted | Nordstrandveien 56C | 1163 | Oslo | 958 88 588
Sidsels Tapetserverksted | Sandsbrauta 2 | 4230 | Sand | 959 47 018
Øvre Hove Møbeltapetsering | Hove | 6893 | [NAME] | 950 55 584
Bergmanns Møbelverksted H | A J Horgens vei 9 | 3055 | [NAME] | 902 07 465
Fagsøm AS | Industriveien 9 | 9360 | Bardu | 77 18 28 88 | 77 18 28 89
[NAME] | [NAME] gate 30 | 0472 | Oslo | 958 79 270
[NAME] | [NAME] 21 | 3138 | Skallestad | 33 32 01 00
Stopp hos meg [NAME] | Strandgata 1 | 4950 | [NAME] | 37 15 33 62
[NAME] avd Trondheim | Borgosen | 7370 | Brekkebygd | 72 41 31 42
Trenger du oppdaterte adresselister til DM /TM? [NAME] (www.forvalt.no) tilbyr ett segmenterings- og uttekksverktøy hvor du [NAME] frem til din målgruppe og eksportere lister til Excel. Du kan gjøre oppslag så ofte du vil, med en begrensning på 3500 selskap per søk. Våre telefonnummere er hentet fra Telefonkatalogen og [NAME].  Med segmenteringsverktøy kan du: - Hente ut adresseliste før en DM utsendelse - Lage ringelister - Hente ut bransjestatistikker - Oppdatere din kundedatabase  Se http://forvalt.no/segmenteringsverktoy/
Spreadsheet: craig_dean__4366__1-05act
Sheet: Economics

 | Commodity Revenue (Cost) | Demand Charge | Total | Total Volume | $/Mwhr Commodity Cost | $/Mwhr Total Cost
Purchases
[NAME]. Cost Est. |  |  |  |  | 20 | 0
Incremental Purchases
[NAME]
4C Balancing
4C Realtime
[NAME]
PV Balancing
PV Realtime
SPS Pre
Artesia Balancing
Artesia Realtime
Sales
Incremental Sales
[NAME]
4C Balancing
4C Realtime
[NAME]
PV Balancing
PV Realtime
[NAME]
Artesia Balancing
Artesia Realtime
 |  |  |  |  |  |  | Heat | Fuel
Generation |  |  |  |  |  |  | Rate | Cost
4 Corners Unit 4 |  |  |  |  |  |  | 10.0576 | 1.3
4 Corners Unit 5 |  |  |  |  |  |  | 10.0576 | 1.3
PV Unit 1 |  |  |  |  |  |  | 10.16 | 0.6
PV Unit 2 |  |  |  |  |  |  | 10.16 | 0.6
PV Unit 3 |  |  |  |  |  |  | 10.16 | 0.6
Newman 1
Newman 2 |  |  |  |  |  |  |  | 1.96
Newman 3
GT 1
GT 2
GT1+ST1
GT2+ST1
Newman 4 |  |  |  |  |  |  |  | 1.96
Copper
Rio Grande 6
Rio Grande 7
Rio Grande 8
Total
Spreadsheet: 726871d1617557987-sequentially-number-in-column-using-formula-book10
Sheet: Sheet1

 |  |  | A | B | C | D | E | F | G | H | I | J | K | L | M
 |  |  | 5 | 5 | 5 | 5 | 5 | 1 | 2 | 3 | 5 | 5 | 3 | 2 | 2
 |  |  | 5 | 5 | 5 | 3 | 3 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 3
Spreadsheet: rick_buy__32663__Rac allocations budget pack 29 Nov
Sheet: Alloc out by CC (HC)

 | Adaytum
 | Risk Assessment & Control | TOTAL G&A
Plan 2001 |  | HC Allocations Received | HC Allocations Received (People Costs only) | Imputed Average Headcount | % of Total Heads
 | UK | 0 | 0 | 8.27 | 0.162156862745098
 | Teesside | 0 | 0 | 1.65 | 0.03235294117647058
 | Metals | 0 | 0 | 12.92 | 0.2533333333333333
 | Credit Markets Group | 0 | 0 | 0.58 | 0.01137254901960784
 | Spain/Portugal | 0 | 0 | 1.59 | 0.0311764705882353
 | Scandinavia | 0 | 0 | 4.16 | 0.08156862745098041
 | German Speaking | 0 | 0 | 1.87 | 0.03666666666666666
 | Central Europe | 0 | 0 | 1.06 | 0.02078431372549019
 | Continental Power | 0 | 0 | 2.58 | 0.05058823529411764
 | Continental Gas | 0 | 0 | 0 | 0
 | Italy | 0 | 0 | 1.24 | 0.02431372549019607
 | Benelux/France | 0 | 0 | 1.02 | 0.02
 | Poland | 0 | 0 | 1.2 | 0.02352941176470588
 | FSU | 0 | 0 | 0.18 | 0.003529411764705881
 | EES (50%) | 0 | 0 | 1.6 | 0.03137254901960784
 | IT Origination | 0 | 0 | 0.4 | 0.007843137254901957
 | Corporate Finance Origination | 0 | 0 | 0 | 0
 | Japan | 0 | 0 | 0 | 0
 | Australia | 0 | 0 | 0 | 0
 | Non Region Specific | 0 | 0 | 0 | 0
 | Indirect Support | 0 | 0 | 0 | 0
 | RECHARGE | 0 | 0 | 2.56 | 0.05019607843137255
 | Enron Corp | 0 | 0 | 0 | 0
 | India/APACHI/CALME | 0 | 0 | 0 | 0
 | EES (50%) - non-EEL | 0 | 0 | 1.6 | 0.03137254901960784
 | Global Markets | 0 | 0 | 2.4 | 0.04705882352941177
 | EBS | 0 | 0 | 4.12 | 0.08078431372549018
 | Total
Spreadsheet: 850444d1700768070-formula-to-count-the-instances-of-a-type-of-number-in-cells-example1
Sheet: Sheet1

 |  | 10 | 1 | 2 | 2 | 3 - (3-1) | 1 | 1. Count the number of times the number in D2:F2 are below/lower than the number in C2
 |  | 7 | 3 | 11 | 6 | (3-1)-3 | -1 | 2. If any of those numbers are either underlined or bold, it is to be counted twice.
 |  |  |  |  |  |  |  | 3. in D2:F2, numbers that are above the figure in C2 get a minus count of 1
 |  |  |  |  |  |  |  | MINUS
 |  |  |  |  |  |  |  | 4 Count the number of times the number in D3:F3 are below/lower than the number in C2
 |  |  |  |  |  |  |  | 5. If any of those numbers are either underlined or bold, it is to be counted twice.
 |  |  |  |  |  |  |  | 6. in D3:F3, numbers that are above the figure in C2 get a minus count of 1
 |  |  |  |  |  |  |  | This has to repeated for the number in C2 too
 |  |  |  |  |  |  |  | Need help with writing a formula to achieve this
Spreadsheet: 767821d1644663259-what-if-analysis-to-calculate-the-effect-of-new-pricing-example-calculation
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | Product 1 |  | Product 2 |  | Product 3 |  | Product 4 |  | Sum of Quantity | Sum of Amount
Org. | Product 1 | Product 2 | Product 3 | Product 4 | Last Order # | Last Order Date | # Orders 2021 | Account | Quantity | Amount | Quantity | Amount | Quantity | Amount | Quantity | Amount |  |  | Average Price
Reseller 1 | 18.95 |  | 26.95 |  | 10 | 2021-12-01 00:00:00 |  | AAA | 10 |  |  |  | 10
Reseller 2 |  |  |  | 28.95 | 20 | 2021-04-30 00:00:00 |  | BBB | 20 |  |  |  |  |  | 15
Reseller 3 | 24.95 |  |  |  | 100 | 04/05/2021 |  | CCC | 949
Distributor 1 | 24.95 | 26.95 | 29 |  | 1500 | 07/09/2021 | 1500 | DDD | 29000 |  | 9600 |  | 45000
Distributor 2 |  | 26.95 |  | 30 | 10 | 2021-08-03 00:00:00 |  | EEE | 0 |  | 10 |  |  |  | 5
Distributor 3 | 24.95 |  |  |  | 12 | 10/19/2021 |  | FFF | 28 |  |  |  | 24
Spreadsheet: bab170e1-fd7d-4de3-89c9-638e19473889
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
FUNID | Test | FUNID | Culture Referred for Identification, Fungus | Culture Referred for ID, Fungus | Nucleic Acid Probe/Conventional Identification Methods Nucleic acid probes used for identification, when applicable, include those for Histoplasma capsulatum and Blastomyces dermatitidis. Real-time PCR used for identification, when applicable, for Coccidioides species. D2 DNA sequencing used for identification, when applicable, for dermatophytes and nonsporulating fungi. | Sabouraud dextrose agar slant: SaDex |  |  |  |  | [NAME]: Preferred: Sabouraud dextrose agar slant Acceptable: Inhibitory mold agar slant [NAME] Isolated mold or yeast Collection Instructions: 1. Organism must be in pure culture, actively growing. 2. Place specimen in a large infectious container (Supply T146) and label as an etiologic agent, if appropriate. Additional Information:  1. Specimen source is required. 2. Isolate description is required: Gram stain reaction, morphology, tests performed 3. See Infectious Specimen Shipping Guidelines in Special Instructions for shipping information. Forms: If not ordering electronically, submit a Microbiology Request Form (Supply T244) with the specimen. |  | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	Agar plate | Not applicable | Monday through Saturday; Varies | 2-35 days: If organism is received in mixed culture or is contaminated,  report | 35 days |  |  |  |  |  |  | Rochester
FUNID | [NAME] | VARIES | Varies |  |  |  | Ambient
FUNID | Order Question | Q00M0024 | [NAME]) and Isolate Description-Stain reaction, morphology, tests performed (Required) |  | Plain Text
FUNID | Result | FUNID | Culture Referred for ID, Fungus | Culture Referred for ID, Fungus | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: phillip_allen__28874__payout
Sheet: Sheet1

 | (000's) |  |  | Inflows |  | Outflows
 | Original Loan |  |  | 1500
 | Permanent Mortgage |  |  | 12000
 | Land |  |  |  |  | 1100
 | Improvements |  |  |  |  | 600
 | Common Amenities |  |  |  |  | 700
 | Carrying Costs |  |  |  |  | 900
 | Unit Costs |  |  |  |  | 7600
 | Repay Loan |  |  |  |  | 1500
 | Builders Profit |  |  |  |  | 1100
 |  | Total
 | Builders profit should be recouped including interest in the first year (assuming $400,000 of cash flow)
Spreadsheet: 882771d1731235834-transpose-data-into-multiple-columns-based-on-numbers-book1-2-
Sheet: Sheet1

1 | MEMBER ID: 1234
1 | Organization Name: ABC Corp
1 | Mobile Number: [PHONE]
1 | Representative Name: [NAME]
2 | MEMBER ID: 5678
2 | Organization Name: XYZ Ltd
2 | Mobile Number: [PHONE]
2 | Representative Name: [NAME]
Spreadsheet: 163421d1340295466-send-unique-duplicates-and-3x-duplicates-to-a-seperate-sheet-cut-sort-list
Sheet: Syteline

Gage ID | Description | Asset value |  | Location | list
QE-001508 | QE, OBS,  POKEYOKE, | 1 |  | QEOBS | Syteline
QE-001509 | QE, POKEYOKE, | 1 |  | QEOBS | Syteline
QE-001510 | QE, OBS, POKEYOKE, | 1 |  | QEOBS | Syteline
QE-001511 | QE,  OBS | 1 |  | QEOBS | Syteline
QE-001512 | QE, HUE | 1 |  | QELAB | Syteline
QE-001513 | QE,OBS,  6 INCH DIAL CALIPER | 1 |  | QEOBS | Syteline
QE-001514 | QE, 6 INCH DIGITAL CALIPER | 1 |  | QEETOOLING | Syteline
QE-001515 | QE, PROFILE,  LH ASPH | 1 |  | QEA200 | Syteline
QE-001516 | QE, PROFILE,  [NAME] | 1 |  | QEA200 | Syteline
QE-001517 | QE, PROFILE,   OEC | 1 |  | QE300 | Syteline
QE-001518 | QE, PROFILE,  FLAT | 1 |  | QEA100 | Syteline
QE-001519 | QE, PROFILE, BEZEL   RH FLAT | 1 |  | QENEW | Syteline
QE-001520 | QE, THREAD GAGE,  OBS | 1 |  | QEOBS | Syteline
QE-001521 | QE, MATING PART,  OBS | 1 |  | QE400 | Syteline
Spreadsheet: louise_kitchen__24044__Natural Gas Consolidated
Sheet: Central Trading

 |  | 2001-09-01 00:00:00 |  | 2001-09-01 00:00:00 |  | %
 |  | YTD Actual |  | Annualized |  | of Total
ENACOMP | Compensation
 | Special Pays | 174000
ENABENTX | Benefits & Payroll Taxes
 | Analyst & Associates | 29600
ENAEMPEX | Employee Expense
ENAT&EEX | Travel & Entertainment Expense
ENAOUTSV | Outside Services
ENASUPP | Supplies Expense
ENAMKTEX | Marketing
ENACONTR | Charitable Contributions
ENARENT | Rent
ENATECH | Technology
ENATRANS | Transportation
ENAOTHEX | Other Expenses
ENATAXES | Taxes Other than Income
ENATOTDR | Total Direct Expenses
 | Headcount |  |  | 18
 | Analyst & Associate Headcount |  |  | 1
 | Total Headcount
ENAOUTLG | Outside Legal
ENAOUTTX | Outside Tax
ENAINSUR | Insurance
ENASYSDV | System Development
ENACORIT | Controllable Infrastructure
ENACORRN | Corporate Rent
ENAOTHAL | Other Allocated Direct  Expenses
ENADEPR | Depreciation & Amortization
Spreadsheet: 273738d1382891078-difference-of-values-based-on-date-and-criteria-question
Sheet: Sheet1

 |  |  | ID | Item | date | Return
 |  |  | a | 46 | 2013-10-03 00:00:00 | 46
 |  |  | a | 16 | 2013-10-04 00:00:00 | 30
 |  |  | b | 12 | 2013-10-07 00:00:00 | look for number with an ID "b" if none 12
 |  |  | a | n/a | 2013-10-08 00:00:00 | 16
 |  |  | a | 36 | 2013-10-09 00:00:00 | 20
 |  |  |  |  |  |  | text in red should be the answer.
Spreadsheet: 112035d1308225490-help-with-conditional-formatting-targets
Sheet: June 2011

Days | Calls |  |  |  |  | GSR |  |  |  |  | Surveys
 | Session I | Session II | Session III | Session IV |  | Session I | Session II | Session III | Session IV |  | Session I | Session II | Session III | Session IV
 | 49.99999999999998 | 49.99999999999999 | 25.00000000000004 | 25 |  | 1 | 1 | 1 | 1 |  | 1 | 1 | 1 | 1 |  | Calculations |  | Difference |  | #N/A | #N/A
Day 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Start | 07:00:00 | 149.9999999999999 |  | #N/A | #N/A
Day 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Break 1 | 09:30:00 | 150 |  | #N/A | #N/A
Day 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Lunch | 12:15:00 | 75.00000000000011 |  | #N/A | #N/A
Day 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Break 2 | 14:00:00 | 75 |  | #N/A | 1
Day 5 |  | 1 |  |  |  |  |  |  |  |  |  |  | -2 |  |  | Stop | 15:30:00 | 7.5 |  | #N/A | #N/A
Day 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
Day 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
Day 8 |  |  |  |  |  |  |  |  |  |  |  |  | 5 |  |  |  |  |  |  | #N/A | 0.5
Day 9 |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
Day 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
Day 11 |  |  |  |  |  |  |  |  |  |  |  |  | 0.3 |  |  |  |  |  |  | #N/A | #N/A
Day 12 |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
Day 13 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | #N/A | #N/A
Day 14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.5 | #N/A
Day 15 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
Day 16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
Day 17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
Day 18 |  | a |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  | #N/A | #N/A
Day 19 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
Day 20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | 2
Day 21 |  | 0.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
Day 22 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
Spreadsheet: 109149d1306082577-if-contains-mx-basic-example
Sheet: Totals

Market Name | Total Flights | % of Flights | X Flights | X MS | Total Rev | X Rev | X Rev %
North America- North America | 0 | #N/A | 0 | #N/A | 0 | 0 | #N/A
, MX | 0 | #N/A | 0 | #N/A | 0 | 0 | #N/A
Latin America-NorthAmerica | 0 | #N/A | 0 | #N/A | 0 | 0 | #N/A
Total | 0 |  | 0 | #N/A | 0 | 0
Spreadsheet: 700295d1603119184-want-to-count-information-in-visable-rows-after-sorting-sample_v2-joseph
Sheet: Sheet2

Date | ID#
2020-01-02 00:00:00 | 19
2020-01-02 00:00:00 | 114
2020-01-03 00:00:00 | 67
2020-01-03 00:00:00 | 81
2020-01-03 00:00:00 | 93
2020-01-03 00:00:00 | 105
2020-01-03 00:00:00 | 126
2020-01-03 00:00:00 | 144
2020-01-03 00:00:00 | 154
2020-01-03 00:00:00 | 166
2020-01-03 00:00:00 | 195
2020-01-03 00:00:00 | 243
2020-01-03 00:00:00 | 266
2020-01-03 00:00:00 | 327
2020-01-03 00:00:00 | 337
2020-01-03 00:00:00 | 366
2020-01-06 00:00:00 | 120
2020-01-06 00:00:00 | 126
2020-01-06 00:00:00 | 133
2020-01-06 00:00:00 | 161
2020-01-06 00:00:00 | 180
2020-01-06 00:00:00 | 201
2020-01-06 00:00:00 | 208
2020-01-06 00:00:00 | 243
2020-01-06 00:00:00 | 268
2020-01-06 00:00:00 | 328
2020-01-06 00:00:00 | 337
2020-01-06 00:00:00 | 349
2020-01-07 00:00:00 | 14
 |  |  | Summary | Results
 |  |  | 2020-01-02 00:00:00
 |  |  | 2020-01-03 00:00:00
 |  |  | 2020-01-06 00:00:00
 |  |  | 2020-01-07 00:00:00
Spreadsheet: 73473d1274138316-threshold-largest-only-revert-to-original-threshold-test
Sheet: Sheet1

 |  | Amt. over [NAME] | [NAME]. over [NAME] | What I want it to show
Year | Loss |  |  |  |  |  | Total Losses
2010 | 45241 | 0 | 45241 | 45241 |  | 2010 | 79241
2009 | 100000 | 45600 | 54400 | 54400 |  | 2009 | 100000
2008 | 25896 | 0 | 25896 | 25896 |  | 2008 | 25896
2007 | 79501 | 25101 | 54400 | 79501 |  | 2007 | 242992
2006 | 12345 | 0 | 12345 | 12345 |  | 2006 | 12345
2010 | 34000 | 0 | 34000 | 34000
2007 | 96854 | 42454 | 54400 | 54400 |  | Turnover | 8000000
2007 | 66637 | 12237 | 54400 | 66637 |  | Rate | 0.34
 |  |  |  |  |  | EP | 27200
 |  |  |  |  |  | Threshold | 54400
Spreadsheet: 419075d1442292239-avoiding-duplicate-values-when-using-index-match-book1
Sheet: Sheet3

Station | Value |  |  | Top 10 | staotpm | value
A | 29
B | 20
C | 20
D | 49
E | 20
F | 50
G | 20
H | 41
I | 20
J | 46
Station | Value | Value*** |  | Top 10 | staotpm | value
A | 29
B | 20
C | 20
D | 49
E | 20
F | 50
G | 20
H | 41
I | 20
J | 46
Spreadsheet: 860256d1708427471-conditional-formatting-turn-blank-cell-yellow-and-when-text-entered-blank-on-conditional-formatting-cells-turn-blank-when-text-entered-updated3
Sheet: Sheet1

NAME | SURNAME | ADDRESS | CONTACT NO | YES/NO
PETER
PAUL |  | 2 SMITH STREET
JULIA | SMITH | 22 CHURCH STREET
ANDREW | MC [NAME] |  |  | Yes
With Conditional Formatting applied
Nico | dfg | 5 Kerkstraat
 | Smuts |  | 12345
Pieter | [NAME] |  |  | Yes
CONDITIONAL FORMATTING   (1)  When information is typed in Column A -         - All the cells of the table have a border         - and turn yellow  (2)  When data is entered in the cells it turns blank  (3)  Empty cells in Column A remains blank until text are entered
Spreadsheet: 759542d1639588646-month-to-date-over-prior-and-week-to-date-over-prior-automation-week-over-week-month-over-month-change
Sheet: Sheet1

Weekday | Date | Orders | Returns | Week | Month |  |  | Week to Date | Prior week to date | % change | Month to Date | Prior Month to date | % change
 | 2021-11-01 00:00:00 | 1991 | 147 |  |  |  | Units Ordered
 | 2021-11-02 00:00:00 | 2332 | 105 |  |  |  | Units Returned
 | 2021-11-03 00:00:00 | 2038 | 111 |  |  |  | Return Rate
 | 2021-11-04 00:00:00 | 1843 | 103
 | 2021-11-05 00:00:00 | 1729 | 123
 | 2021-11-08 00:00:00 | 1862 | 120
 | 2021-11-09 00:00:00 | 2020 | 66
 | 2021-11-10 00:00:00 | 1861 | 162
 | 2021-11-12 00:00:00 | 1546 | 125
 | 2021-11-15 00:00:00 | 1773 | 78
 | 2021-11-16 00:00:00 | 1942 | 68
 | 2021-11-17 00:00:00 | 1772 | 136
 | 2021-11-18 00:00:00 | 1948 | 188
 | 2021-11-19 00:00:00 | 1645 | 115
 | 2021-11-22 00:00:00 | 1744 | 75
 | 2021-11-23 00:00:00 | 1841 | 165
 | 2021-11-24 00:00:00 | 1485 | 92
 | 2021-11-26 00:00:00 | 743 | 0
 | 2021-11-29 00:00:00 | 1636 | 104
 | 2021-11-30 00:00:00 | 1968 | 132
 | 2021-12-01 00:00:00 | 1903 | 155
 | 2021-12-02 00:00:00 | 1753 | 144
 | 2021-12-03 00:00:00 | 1602 | 135
 | 2021-12-06 00:00:00 | 1937 | 108
 | 2021-12-07 00:00:00 | 1805 | 123
 | 2021-12-08 00:00:00 | 1958 | 146
 | 2021-12-09 00:00:00 | 1887 | 143
 | 2021-12-10 00:00:00 | 1696 | 140
 | 2021-12-13 00:00:00 | 1779 | 127
 | 2021-12-14 00:00:00 | 1850 | 141
Spreadsheet: 165737d1341330250-comparing-format_coversion_issue
Sheet: Sheet1

10050 | 57.0 | 09 MAR 2012 |  | GroupA-Formatted A
10050 | 58.0 | 27 APR 2012 |  | GroupA-Formatted A
10050 | 57 | 2012-03-09 00:00:00 |  | GroupB-Formatted B
10050 | 58 | 2012-04-27 00:00:00 |  | GroupB-Formatted B
Spreadsheet: john_griffith__15674__Book1
Sheet: Sheet1

 |  |  | Natural Gas Straddles
 | Month | Strike | Bid | Offer | Mid-Pt. Vol | Net Change
 | M | 4.25 | 0.345 | 0.35 | 0.50555 | -0.01094999999999879
 | N | 4.35 | 0.63 | 0.66 | 0.522 | -0.001499999999999835
 | Q | 4.4 | 0.83 | 0.855 | 0.5290000000000006 | 0.003149999999999653
 | U | 4.45 | 1 | 1.02 | 0.5284000000000013 | -0.01049999999999884
 | V | 4.45 | 1.16 | 1.18 | 0.5484000000000008 | 0.0008999999999999009
 | X | 4.65 | 1.33 | 1.36 | 0.5487000000000011 | -0.004799999999999471
 | Z | 4.8 | 1.53 | 1.545 | 0.5614000000000011 | -0.005099999999999438
 | F | 4.85 | 1.68 | 1.72 | 0.5747000000000002 | -0.003599999999999604
 | G | 4.75 | 1.72 | 1.77 | 0.5702 | -0.002099999999999769
 | H | 4.55 | 1.58 | 1.63 | 0.5185999999999997 | -0.008399999999999075
 | J | 4.25 | 1.17 | 1.27 | 0.4028000000000002 | -0.002099999999999769
 | K | 4.15 | 1.11 | 1.22 | 0.3820999999999994 | 0.001199999999999868
 |  |  | 2001-05-11 15:17:00.670000
Spreadsheet: 142901d1330081325-show-sumif-data-within-other-file-without-opening-it-picking-list-template-2
Sheet: Sheet4

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Qty Requested
120526 | R.Sthal
120526 | R.Sthal
120526 | R.Sthal
120539 | Cleveland | 1 |  | 2 |  | 32mm E1FW gland + shroud + hardware (Pack of 2) |  |  |  |  |  |  |  | 20.11 | 40.22 |  | 40.22
120539 | Cleveland | 2 |  | 100 |  | 2x2x24/0.2 PT2 TY1, O/SCR black BS5308 |  |  |  |  |  |  |  | 0.55 | 55.00000000000001 |  | 55.00000000000001
120531 | Euro | 1 |  | 200 |  | LNGF106.4/06.4PP |  |  |  |  |  |  |  | 0.69 | 138 | 0 | 138
120531 | Euro | 2 |  | 50 |  | LN209.5PP |  |  |  |  |  |  |  | 0.36 | 18 | 0 | 18
Spreadsheet: 770441d1646068931-data-entry-to-defined-cells-in-a-table-from-a-seperate-user-input-selection-section-time-and-attendance-calendar
Sheet: Data Entry

 |  |  |  |  |  |  | This will be the user input section. I use data validation tool to specify what values the user can enter.
 | Name | [NAME] |  |  |  | Column | this name will be used to select the relevant column on the calendar sheet
 | Date | 2nd | Mar |  | ?? | Row Number | This date will select the relevant row on the [NAME] sheet. Not sure on the best way to define this part…
 | Reason for change to normal hours | Overtime (hours) |  |  |  | short code
 | Hours / days | 2.5 |  |  |  | combined short code | From C6 and C7 it will create a short code in E7 that will move into the location on the table in Calendar tab defined by the name and date above…
 |  |  |  |  |  |  | I have no idea how to move this into the relevant cell…
Spreadsheet: 795230d1662565793-i-want-to-understand-how-the-option-search-last-to-first-in-xlookup-works-search-with-xlookup-hd-aligw
Sheet: Sheet1

 |  |  |  | [NAME] |  |  |  |  | Expectation |  |  |  |  | Formula in first row |  | Description
 | Position | Number |  | 1 | 2 | 3 | 4 |  | 1 | 2 | 3 | 4 |  | 1 |  | Looking for position of 7, search array: current row to last row, exact match, search first to last
 | 1 | 3 |  |  |  |  |  |  | 4 | 8 | #N/A | #N/A |  | 2 |  | Looking for position of 7, search array: current row to last row, exact match, search last to first
 | 2 | 5 |  |  |  |  |  |  | 4 | 8 | #N/A | #N/A |  | 3 |  | Looking for position of 7, search array: first row to current row, exact match, search first to last
 | 3 | 4 |  |  |  |  |  |  | 4 | 8 | #N/A | #N/A |  | 4 |  | Looking for position of 7, search array: first row to current row, exact match, search last to first
 | 4 | 7 |  |  |  |  |  |  | 4 | 8 | 4 | 4
 | 5 | 4 |  |  |  |  |  |  | 8 | 8 | 4 | 4
 | 6 | 6 |  |  |  |  |  |  | 8 | 8 | 4 | 4
 | 7 | 9 |  |  |  |  |  |  | 8 | 8 | 4 | 4
 | 8 | 7 |  |  |  |  |  |  | 8 | 8 | 4 | 8
 | 9 | 2 |  |  |  |  |  |  | #N/A | #N/A | 4 | 8
 | 10 | 2 |  |  |  |  |  |  | #N/A | #N/A | 4 | 8
 | Running in MS Office 365 there are some results of the formula not in line with  my expectation:
 | * [NAME] returns 4 in cell H10. I expected an 8.
 | * [NAME] returns #N/A in cell H8. I expected a 4.
 | * [NAME] return #N/As in cells F6, F7, F10 and H11. I expected eights.
 | What mistake am I making?
 | Can you declare this result of the formula?