Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Splitting a Maple code in Excel 1

Status
Not open for further replies.

Engineer32

Programmer
Jul 14, 2008
3
ES
Does anybody know if it’s possible breaking a maple code in two or more excel cells?
The point is I want to insert a very long formula within excel using maple (Excel-Maple Add-in), but Excel only accepts a very short string length for the formulas I’m trying to insert. I’ve already try to concatenate two cells in another one but splitting the maple code is not possible (or if it is I haven’t found how).
The code I'm talking about is:

=Maple("fsolve(&1/&2*(1/&3*&4^(1/2)*(2*&5)^(-1)*(1/2)^(2/3))*y^(8/3)+(&3*&4^(-1/2)*(&5^(-1)*((1/&3*&4 ^(1/2)*(2*&5)^(-1) *(1/2)^(2/3))*y^(8/3)* &3*(2*&5)*&4^(-1/2)*(1/2)^(-2/3))^(3/8))^(2/3))^(3/5)*((1/&3*&4^(1/2)*(2*&5)^(-1)*(1/2)^(2/3))*y^(8/3))^(0.6)-&1/&2*(1/&3*&4^(1/2)*(2*&5)^(-1)*(1/2)^(2/3))*(&6)^(8/3)-(&3*&4 ^(-1/2)*(&5^(-1)*((1/&3*&4 ^(1/2)*(2*&5)^(-1)*(1/2)^(2/3))*y^(8/3)*&3*(2*&5)* &4^(-1/2)*(1/2)^(-2/3))^(3/8))^(2/3))^(3/5)*((1/&3*&4^(1/2)*(2*&5)^(-1)*(1/2)^(2/3))*( &7)^(8/3))^(0.6)-(&8+&9)*&1,y,avoid={y=0});";$B$6;$B$5;$B$3;$B$4;$D$5;G13;H12;$D13;$E13)

Thank you everybody for trying
 
How about if you break the string argument up and put it into other cells.

For example
A1 has = "fsolve(&1/&2*(1/&3*&4^(1/2)*(2*&5)^(-1)*(1/2)^(2/3))*y^(8/3)+(&3*&4^(-1/2)*(&5^(-1)*((1/&3*&4 ^(1/2)*(2*&5)^(-1) *(1/2)^(2/3))*y^(8/3)* &3*(2*&5)*&4^(-1/2)*(1/2)^(-2/3))^(3/8))^(2/3))^(3/5)*((1/&3*&4^(1/2)*(2*&5)^(-1)*(1/2)^(2/3))*y^(8/3))^(0.6)-&1/&2*(1/&3*&4^(1/2)*("

A2 has =")*(2*&5)^(-1)*(1/2)^(2/3))*(&6)^(8/3)-(&3*&4 ^(-1/2)*(&5^(-1)*((1/&3*&4 ^(1/2)*(2*&5)^(-1)*(1/2)^(2/3))*y^(8/3)*&3*(2*&5)* &4^(-1/2)*(1/2)^(-2/3))^(3/8))^(2/3))^(3/5)*((1/&3*&4^(1/2)*(2*&5)^(-1)*(1/2)^(2/3))*( &7)^(8/3))^(0.6)-(&8+&9)*&1,y,avoid={y=0});"

Your formula is
= Maple (A1 & A2, $B$6;$B$5;$B$3;$B$4;$D$5;G13;H12;$D13;$E13)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top