Solving a transfer function in excel to find SS error for an assignment (MATLAB is not allowed to be...
How could Tony Stark make this in Endgame?
What language was spoken in East Asia before Proto-Turkic?
Is there any limitation with Arduino Nano serial communication distance?
How do I reattach a shelf to the wall when it ripped out of the wall?
How can I place the product on a social media post better?
A Note on N!
Seemingly unused edef prior to an ifx mysteriously affects the outcome of the ifx. Why?
A Strange Latex Symbol
Examples of subgroups where it's nontrivial to show closure under multiplication?
Controversial area of mathematics
What is the most expensive material in the world that could be used to create Pun-Pun's lute?
With a Canadian student visa, can I spend a night at Vancouver before continuing to Toronto?
Do I have to worry about players making “bad” choices on level up?
Reducing vertical space in stackrel
What does the "ep" capability mean?
Critique of timeline aesthetic
How to stop co-workers from teasing me because I know Russian?
Was there a shared-world project before "Thieves World"?
Why was Germany not as successful as other Europeans in establishing overseas colonies?
Don’t seats that recline flat defeat the purpose of having seatbelts?
Document starts having heaps of errors in the middle, but the code doesn't have any problems in it
What route did the Hindenburg take when traveling from Germany to the U.S.?
Mac Pro install disk keeps ejecting itself
How come there are so many candidates for the 2020 Democratic party presidential nomination?
Solving a transfer function in excel to find SS error for an assignment (MATLAB is not allowed to be used)
Pass values instead of range to VBA FunctionMerge Excel rows from two sheetsString compatible equivalent of Excel Small()/ Large()/ Rank()Validate that a combination of cells are unique in a row in ExcelHow to display unique numerical values from different columns into a single cell (separated by commas)vba/excel analysis of large data setHow can I do a two dimensional lookup where the column and row headers are ranges?Is it diagnostic for an Excel function wizard to work but not manual entry?How do I keep an Excel formula from changing the sheet it refers to?Excel SUMIF criteria reference
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
I would like to know how to create a spreadsheet in excel to solve a transfer function to find steady state error. An example is shown in the pictures. Im required to use excel as part of the assignment, MATLAB is not allowed. The attached pictures show an example and needed equations to find the error. The assignment requires to allow the user to input a function (like the example), and then the user gets the error values. All I know in excel is the basic formula operation (= + - * /). My attempt involved entering the Zeros (e.g. 500*2*5) and Poles (e.g 8*10*12) manually in a separate cell. I want to know which functions to use or any other method for entering just the transfer function and then get all the error values.
equations
example
attempt in excel
microsoft-excel steadystate
asked yesterday
JamesJames
11
New contributor
James is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I would like to know how to create a spreadsheet in excel to solve a transfer function to find steady state error. An example is shown in the pictures. Im required to use excel as part of the assignment, MATLAB is not allowed. The attached pictures show an example and needed equations to find the error. The assignment requires to allow the user to input a function (like the example), and then the user gets the error values. All I know in excel is the basic formula operation (= + - * /). My attempt involved entering the Zeros (e.g. 500*2*5) and Poles (e.g 8*10*12) manually in a separate cell. I want to know which functions to use or any other method for entering just the transfer function and then get all the error values.
equations
example
attempt in excel
microsoft-excel steadystate
asked yesterday
JamesJames
11
New contributor
James is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Hello James, we are not here to do your homework for you. Please edit your question to show what you have tried - preferably with sample data, and exactly what issues you are facing and you should get the help you need to solve your issues.
– Kevin Anthony Oppegaard Rose
yesterday
Done. I added my attempt.
– James
yesterday
What formula are you using? Also, instead of posting your data in an image, it would help us help you a little better if you can post in a table.
– BruceWayne
yesterday
how can I post it in a table? Im simply using the "=C3*C5" for example. All cells are connected to each other, once I manually change "Zeros", "Poles", and "Gain", I get the errors. @BruceWayne
– James
yesterday
add a comment |
I would like to know how to create a spreadsheet in excel to solve a transfer function to find steady state error. An example is shown in the pictures. Im required to use excel as part of the assignment, MATLAB is not allowed. The attached pictures show an example and needed equations to find the error. The assignment requires to allow the user to input a function (like the example), and then the user gets the error values. All I know in excel is the basic formula operation (= + - * /). My attempt involved entering the Zeros (e.g. 500*2*5) and Poles (e.g 8*10*12) manually in a separate cell. I want to know which functions to use or any other method for entering just the transfer function and then get all the error values.
equations
example
attempt in excel
microsoft-excel steadystate
asked yesterday
JamesJames
11
New contributor
James is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I would like to know how to create a spreadsheet in excel to solve a transfer function to find steady state error. An example is shown in the pictures. Im required to use excel as part of the assignment, MATLAB is not allowed. The attached pictures show an example and needed equations to find the error. The assignment requires to allow the user to input a function (like the example), and then the user gets the error values. All I know in excel is the basic formula operation (= + - * /). My attempt involved entering the Zeros (e.g. 500*2*5) and Poles (e.g 8*10*12) manually in a separate cell. I want to know which functions to use or any other method for entering just the transfer function and then get all the error values.
equations
example
attempt in excel
microsoft-excel steadystate
microsoft-excel steadystate
asked yesterday
JamesJames
11
New contributor
James is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked yesterday
JamesJames
11
New contributor
James is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited yesterday
James
asked yesterday
JamesJames
11
New contributor
James is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked yesterday
JamesJames
11
asked yesterday
JamesJames
11
11
New contributor
James is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
James is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
James is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Hello James, we are not here to do your homework for you. Please edit your question to show what you have tried - preferably with sample data, and exactly what issues you are facing and you should get the help you need to solve your issues.
– Kevin Anthony Oppegaard Rose
yesterday
Done. I added my attempt.
– James
yesterday
What formula are you using? Also, instead of posting your data in an image, it would help us help you a little better if you can post in a table.
– BruceWayne
yesterday
how can I post it in a table? Im simply using the "=C3*C5" for example. All cells are connected to each other, once I manually change "Zeros", "Poles", and "Gain", I get the errors. @BruceWayne
– James
yesterday
add a comment |
Hello James, we are not here to do your homework for you. Please edit your question to show what you have tried - preferably with sample data, and exactly what issues you are facing and you should get the help you need to solve your issues.
– Kevin Anthony Oppegaard Rose
yesterday
Done. I added my attempt.
– James
yesterday
What formula are you using? Also, instead of posting your data in an image, it would help us help you a little better if you can post in a table.
– BruceWayne
yesterday
how can I post it in a table? Im simply using the "=C3*C5" for example. All cells are connected to each other, once I manually change "Zeros", "Poles", and "Gain", I get the errors. @BruceWayne
– James
yesterday
Hello James, we are not here to do your homework for you. Please edit your question to show what you have tried - preferably with sample data, and exactly what issues you are facing and you should get the help you need to solve your issues.
– Kevin Anthony Oppegaard Rose
yesterday
Hello James, we are not here to do your homework for you. Please edit your question to show what you have tried - preferably with sample data, and exactly what issues you are facing and you should get the help you need to solve your issues.
– Kevin Anthony Oppegaard Rose
yesterday
Done. I added my attempt.
– James
yesterday
Done. I added my attempt.
– James
yesterday
What formula are you using? Also, instead of posting your data in an image, it would help us help you a little better if you can post in a table.
– BruceWayne
yesterday
What formula are you using? Also, instead of posting your data in an image, it would help us help you a little better if you can post in a table.
– BruceWayne
yesterday
how can I post it in a table? Im simply using the "=C3*C5" for example. All cells are connected to each other, once I manually change "Zeros", "Poles", and "Gain", I get the errors. @BruceWayne
– James
yesterday
how can I post it in a table? Im simply using the "=C3*C5" for example. All cells are connected to each other, once I manually change "Zeros", "Poles", and "Gain", I get the errors. @BruceWayne
– James
yesterday
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
James is a new contributor. Be nice, and check out our Code of Conduct.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1429899%2fsolving-a-transfer-function-in-excel-to-find-ss-error-for-an-assignment-matlab%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
James is a new contributor. Be nice, and check out our Code of Conduct.
James is a new contributor. Be nice, and check out our Code of Conduct.
James is a new contributor. Be nice, and check out our Code of Conduct.
James is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1429899%2fsolving-a-transfer-function-in-excel-to-find-ss-error-for-an-assignment-matlab%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Hello James, we are not here to do your homework for you. Please edit your question to show what you have tried - preferably with sample data, and exactly what issues you are facing and you should get the help you need to solve your issues.
– Kevin Anthony Oppegaard Rose
yesterday
Done. I added my attempt.
– James
yesterday
What formula are you using? Also, instead of posting your data in an image, it would help us help you a little better if you can post in a table.
– BruceWayne
yesterday
how can I post it in a table? Im simply using the "=C3*C5" for example. All cells are connected to each other, once I manually change "Zeros", "Poles", and "Gain", I get the errors. @BruceWayne
– James
yesterday