Group Abstract Group Abstract

Message Boards Message Boards

Substitute two variable ranges in Table format?

Mirza Farrukh Baig
Posted 4 years ago
Attachments:
Mathmatica files.nb
POSTED BY: Mirza Farrukh Baig
5 Replies
Sort By:

Thanks for your help. Actually, this was the requirement of the assignment to make it on excel.
POSTED BY: Mirza Farrukh Baig
Rohit Namjoshi
Rohit Namjoshi
Posted 4 years ago

This works fine for me. I have attached the output.

result = Table[<|"t" -> t, "k" -> k, "result" -> First@{(Nu/Nuc)/(fRe/fRec)}|>, 
          {t, 0, 1, 0.01}, {k, 0.001, 1, 0.01}] // Flatten // Dataset

Export["results.xlsx", results]

Why do you need to use Excel for plotting? Why not plot in Mathematica?

Attachments:
results.xlsx
POSTED BY: Rohit Namjoshi

Is this what you are looking for?

OP = Table[(Nu/Nuc)/(fRe/fRec), {t, 0, 1, 0.01}, {k, 0.001, 1, 0.01}];
Export["filename.xls", OP]
POSTED BY: Gianluca Gorni

Yes, I am looking for this but I need to export the data in excel sheet and then plot. When I export it does not have any data. Do you have any idea how to get this?
POSTED BY: Mirza Farrukh Baig
Rohit Namjoshi
Rohit Namjoshi
Posted 4 years ago

Hi Mirza,

Is this what you are looking for?

Table[<|"t" -> t, "k" -> k, "result" -> First@{(Nu/Nuc)/(fRe/fRec)}|>, {t, 0, 1, 0.01},
 {k, 0.001, 1, 0.01}] // Flatten // Dataset
POSTED BY: Rohit Namjoshi
Reply to this discussion
Community posts can be styled and formatted using the Markdown syntax.
Tag limit exceeded
Note: Only the first five people you tag will receive an email notification; the other tagged names will appear as links to their profiles.
Reply Preview
Attachments
Remove
or Discard