# Formula from Excel-Sheet with variables

**URL:** https://forum.dynamobim.com/t/formula-from-excel-sheet-with-variables/40110
**Category:** Lists-Logic
**Created:** [August 30, 2019, 9:44am UTC](https://forum.dynamobim.com/t/formula-from-excel-sheet-with-variables/40110 "2019-08-30T09:44:05Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![thore.nei](https://avatars.discourse-cdn.com/v4/letter/t/ecb155/32.png) [@thore.nei](https://forum.dynamobim.com/u/thore.nei)
#### Post date: [August 30, 2019, 9:44am UTC](https://forum.dynamobim.com/t/formula-from-excel-sheet-with-variables/40110/1 "2019-08-30T09:44:05Z")

</div>

Hey,

i would like to import a formula from a Excel-Sheet with two variables:

 ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/e/e/ee1392cfd0a1da3af383d90cfb6775fb299b566f.png)

I try to do somethin like this:

 ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/5/0/50fae068df4ba715452568f39f2a25e3b3d92efe.png)

Further, I want to use a other excel-sheet to assign specific values to the variables v and K1. The problem is that I can not assign values directly to the variables through Data.ImportExcel. Is there a special order for this?

best regards

---

<div class="post-metadata">

### Author: ![Kulkul](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/kulkul/32/49801_2.png) [@Kulkul](https://forum.dynamobim.com/u/Kulkul)
#### Post date: [August 30, 2019, 12:42pm UTC](https://forum.dynamobim.com/t/formula-from-excel-sheet-with-variables/40110/2 "2019-08-30T12:42:06Z")

</div>

Hi @thore.nei

Are you sure you need Dynamo for this?  
Can’t you just select Entire Column “B”, Find/Replace in Excel?

---

<div class="post-metadata">

### Author: ![thore.nei](https://avatars.discourse-cdn.com/v4/letter/t/ecb155/32.png) [@thore.nei](https://forum.dynamobim.com/u/thore.nei)
#### Post date: [August 30, 2019, 1:20pm UTC](https://forum.dynamobim.com/t/formula-from-excel-sheet-with-variables/40110/3 "2019-08-30T13:20:35Z")

</div>

Hi @Kulkul ,

the excel-sheet should actually remain unchanged. Therefore, I wanted to change the variable only after reading in Dynamo… is it not possible to read a formula with variables in Dynamo?

---

<div class="post-metadata">

### Author: ![Kulkul](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/kulkul/32/49801_2.png) [@Kulkul](https://forum.dynamobim.com/u/Kulkul)
#### Post date: [August 30, 2019, 5:24pm UTC](https://forum.dynamobim.com/t/formula-from-excel-sheet-with-variables/40110/4 "2019-08-30T17:24:15Z")

</div>

> [@thore.nei](#):
>
> is it not possible to read a formula with variables in Dynamo?

Could you drop here excel file?

---

<div class="post-metadata">

### Author: ![thore.nei](https://avatars.discourse-cdn.com/v4/letter/t/ecb155/32.png) [@thore.nei](https://forum.dynamobim.com/u/thore.nei)
#### Post date: [September 1, 2019, 7:48am UTC](https://forum.dynamobim.com/t/formula-from-excel-sheet-with-variables/40110/5 "2019-09-01T07:48:05Z")

</div>

Although this Excel-Sheet is unspectacular, but I would especially like to know how to read in these variables in Dynamo

[DIN 18218.xlsx](https://forum.dynamobim.com/uploads/short-url/2DP1PTksbm0mRoyDUoyFyai4Wzh.xlsx) (9.7 KB)