- z= erst kontur, x = .45% and y = 12 layers
- z = erst kontur x =.35% and y = 1 layer
Connect points of specific height that is a string
1 visualizzazione (ultimi 30 giorni)
Mostra commenti meno recenti
Hello!
I want to connect the points x and z of an excel table to a specific height which is a string
%% Import data from spreadsheet
% Script for importing data from the following spreadsheet:
%
% Workbook: C:\Users\Ambi\Desktop\Dokumente\UNI\Fachhochschule\Semester 7\Bachelorarbeit\Excel\3D Bearbeitung BorderInfill InsideOut Stand 19.7.22 .xlsx
% Worksheet: Blatt 1 - Tabelle 1
%
% Auto-generated by MATLAB on 22-Jul-2022 12:31:15
%% Set up the Import Options and import the data
opts = spreadsheetImportOptions("NumVariables", 36);
% Specify sheet and range
opts.Sheet = "Blatt 1 - Tabelle 1";
opts.DataRange = "A4:AJ8";
% Specify column names and types
opts.VariableNames = ["Datum", "Probenummer", "AnzahlLagen", "AnzahlSpuren", "Kperform", "InfillStrategie", "KonturStrategie", "Spurbreitemm", "Spurhhemm", "Overlap", "OffsetInfillmm", "OffsetKonturmm", "Leistung", "Bearbeitungsrichtung", "SpurabstandEingepasst", "StartpunkteVerteiltVersatzInMm", "AnzahlAchsen", "MindestlhneLngemm", "GewichtgVorher", "GewichtgNachher", "Tellerdrehzahlmin1", "MittlereFrderrategtn", "Strahldurchmessermm", "Manuell", "Startpunkte", "EinUndberlaufmm", "Spurversatz", "Leistungsreduzierung", "Material", "Notizen", "VorschubInMmmin", "SchleifenAnScharfenEcken", "Radius", "Spuversatz", "ZeitExcls8SekAmAnfangInSek", "Wartezeit"];
opts.VariableTypes = ["datetime", "string", "double", "string", "categorical", "categorical", "categorical", "double", "string", "double", "string", "double", "double", "categorical", "categorical", "double", "double", "string", "double", "double", "double", "double", "double", "categorical", "categorical", "categorical", "double", "string", "categorical", "string", "double", "categorical", "double", "double", "double", "double"];
% Specify variable properties
opts = setvaropts(opts, ["Probenummer", "AnzahlSpuren", "Spurhhemm", "OffsetInfillmm", "MindestlhneLngemm", "Leistungsreduzierung", "Notizen"], "WhitespaceRule", "preserve");
opts = setvaropts(opts, ["Probenummer", "AnzahlSpuren", "Kperform", "InfillStrategie", "KonturStrategie", "Spurhhemm", "OffsetInfillmm", "Bearbeitungsrichtung", "SpurabstandEingepasst", "MindestlhneLngemm", "Manuell", "Startpunkte", "EinUndberlaufmm", "Leistungsreduzierung", "Material", "Notizen", "SchleifenAnScharfenEcken"], "EmptyFieldRule", "auto");
opts = setvaropts(opts, "Datum", "InputFormat", "");
% Import the data
DBearbeitungBorderInfillInsideOutStand19S1 = readtable("C:\Users\Ambi\Desktop\Dokumente\UNI\Fachhochschule\Semester 7\Bachelorarbeit\Excel\3D Bearbeitung BorderInfill InsideOut Stand 19.7.22 .xlsx", opts, "UseExcel", false);
%% Clear temporary variables
clear opts
DBearbeitungBorderInfillInsideOutStand19S1.Pulvergefoerdert = (DBearbeitungBorderInfillInsideOutStand19S1.ZeitExcls8SekAmAnfangInSek +8)/60 ...
.* DBearbeitungBorderInfillInsideOutStand19S1.MittlereFrderrategtn .* ...
DBearbeitungBorderInfillInsideOutStand19S1.Tellerdrehzahlmin1;
DBearbeitungBorderInfillInsideOutStand19S1.Massendifferenz = DBearbeitungBorderInfillInsideOutStand19S1.GewichtgNachher - DBearbeitungBorderInfillInsideOutStand19S1.GewichtgVorher;
DBearbeitungBorderInfillInsideOutStand19S1.Nutzungsgrad = DBearbeitungBorderInfillInsideOutStand19S1.Massendifferenz ./ DBearbeitungBorderInfillInsideOutStand19S1.Pulvergefoerdert
x = [DBearbeitungBorderInfillInsideOutStand19S1.Nutzungsgrad];
z = [DBearbeitungBorderInfillInsideOutStand19S1.KonturStrategie];
y = [DBearbeitungBorderInfillInsideOutStand19S1.AnzahlLagen];
plot3(y,x,z,'s--')
grid on
The result is almost right, the only thing that i dont want is the connection between the z heights.
Some background info for a better understanding: I want to compare the powderefficiency (x) per layer(y) (1 to 12) of 2 strategies (z)
i am still barely new to matlab - i hope you can help me!
Pascal
1 Commento
Star Strider
il 22 Lug 2022
The Comment by @Pascal to my now deleted answer (since I still do not understand what the result should be) —
Sorry if you misunderstood - english is not my first language :) its pretty hard to formulate this question in english
Z is more of a separator.
As of right now i only have 2 possible z strings :
1. "Erst Kontur"
2. "Nur Fläche"
Those are 2 Deposition Strategies i use in my lab.
x is now the powderefficiency and y the number of layers.
For example i have done 2 specimen with the following parameters:
now i have done an additional 2 but with the following parameters:
1. z = Nur fläche, x = .45% and y = 12 layer
2. z = Nur fläche , x = .35% and y = 1 layer
I now want to plot all points but only connect the points where z is equal. That means 2 Lines that are separate from each other. I guess you can say they are kind of like 2 height lines
If you look at the picture i attached in the original post you can see that there is a line connecting the 2 Z values, thats the only thing i want gone.
is that making it clearer?
Risposta accettata
Voss
il 22 Lug 2022
load InsideOutTable.mat
DBearbeitungBorderInfillInsideOutStand19S1.Pulvergefoerdert = (DBearbeitungBorderInfillInsideOutStand19S1.ZeitExcls8SekAmAnfangInSek +8)/60 ...
.* DBearbeitungBorderInfillInsideOutStand19S1.MittlereFrderrategtn .* ...
DBearbeitungBorderInfillInsideOutStand19S1.Tellerdrehzahlmin1;
DBearbeitungBorderInfillInsideOutStand19S1.Massendifferenz = DBearbeitungBorderInfillInsideOutStand19S1.GewichtgNachher - DBearbeitungBorderInfillInsideOutStand19S1.GewichtgVorher;
DBearbeitungBorderInfillInsideOutStand19S1.Nutzungsgrad = DBearbeitungBorderInfillInsideOutStand19S1.Massendifferenz ./ DBearbeitungBorderInfillInsideOutStand19S1.Pulvergefoerdert
x = [DBearbeitungBorderInfillInsideOutStand19S1.Nutzungsgrad];
z = [DBearbeitungBorderInfillInsideOutStand19S1.KonturStrategie];
y = [DBearbeitungBorderInfillInsideOutStand19S1.AnzahlLagen];
grid on
hold on
[uz,~,jj] = unique(z);
for ii = 1:numel(uz)
idx = jj == ii;
plot3(y(idx),x(idx),z(idx),'bs--')
end
view(3)
3 Commenti
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Spreadsheets in Help Center e File Exchange
Prodotti
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!