Welcome Guest! To enable all features please Login. New Registrations are disabled.

Notification

Icon
Error

Login


Options
Go to last post Go to first unread
Offline Davide Carpi  
#1 Posted : 30 March 2018 13:40:43(UTC)
Davide Carpi


Rank: Advanced Member

Groups: Registered, Advanced Member
Joined: 13/01/2012(UTC)
Posts: 2,654
Man
Italy
Location: Italy

Was thanked: 1340 time(s) in 879 post(s)
Hello numan Offline

The images are not visible (Request forbidden by administrative rules on that server), you can attach them directly using the attachment button

how to attach wrote:
  1. 2018-02-24 19_32_16-Edit post.png

  2. 2018-02-24 19_32_34-Edit post.png

  3. 2018-02-24 19_32_44-Nessun file selezionato..png

  4. 2018-02-24 19_33_24-Edit post.png


However there are the combobox and ComboBoxList plugins that might help you in your task

Edited by user 30 March 2018 13:49:35(UTC)  | Reason: Not specified

If you like my plugins consider to support SMath Studio buying a plan; to offer me a coffee: paypal.me/dcprojects

Wanna join the discussion?! Login to your SMath Studio Forum forum account. New Registrations are disabled.

Offline numan  
#2 Posted : 30 March 2018 16:43:57(UTC)
numan

Rank: Newbie

Groups: Registered
Joined: 30/03/2018(UTC)
Posts: 1
Turkey

Originally Posted by: Davide Carpi Go to Quoted Post
Hello numan Offline

The images are not visible (Request forbidden by administrative rules on that server), you can attach them directly using the attachment button

how to attach wrote:
  1. 2018-02-24 19_32_16-Edit post.png

  2. 2018-02-24 19_32_34-Edit post.png

  3. 2018-02-24 19_32_44-Nessun file selezionato..png

  4. 2018-02-24 19_33_24-Edit post.png


However there are the combobox and ComboBoxList plugins that might help you in your task


thank you very much i found solution from https://en.smath.info/fo...-and-Link-to-Excel.aspx.
but i need now one more question.
i need to get directly output which is inside of matrix could you help me about it ?

smathforum_ques3.png

i wrote in there first cor1 and second cor2, but writing cannot apply in there because writing is in matrix
Offline Davide Carpi  
#3 Posted : 30 March 2018 20:25:59(UTC)
Davide Carpi


Rank: Advanced Member

Groups: Registered, Advanced Member
Joined: 13/01/2012(UTC)
Posts: 2,654
Man
Italy
Location: Italy

Was thanked: 1340 time(s) in 879 post(s)
use el(cor1,1) and el(cor2,1) - you can type cor1 [ 1 and cor2 [ 1

However your approach with lookups seems slow, my suggestion is to create a matrix with the possible entries and ranges

2018-03-30 19_22_55-SMath Studio - [XLSX example.sm].png

XLSX example.sm (16kb) downloaded 45 time(s).
Sections_and_Merchant_Bars-ArcelorMittal_V2018-1.xlsx (3,643kb) downloaded 35 time(s).


P.S. please don't remove posts which were answered, this will make the thread hard to understand for who comes here looking for the same arguments... ty
If you like my plugins consider to support SMath Studio buying a plan; to offer me a coffee: paypal.me/dcprojects
Users browsing this topic
Guest
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.