# Writing Load Value from Excel Sheet to Load Parameter **URL:** \ **Category:** Revit\ **Tags:** excel, dynamo\ **Created:** [May 12, 2021, 4:02pm UTC](https://forum.dynamobim.com/t/writing-load-value-from-excel-sheet-to-load-parameter/63879 "2021-05-12T16:02:07Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![corey.coleman](https://avatars.discourse-cdn.com/v4/letter/c/9de053/32.png) [@corey.coleman](https://forum.dynamobim.com/u/corey.coleman)\ **Post date:** [May 12, 2021, 4:02pm UTC](https://forum.dynamobim.com/t/writing-load-value-from-excel-sheet-to-load-parameter/63879/1 "2021-05-12T16:02:07Z")
Hey everyone, I’ve been using dynamo occasionally for a few years now, and run into a problem I can’t seem to find a solution for, or has a forum post. I have a large amount of electrical equipment in an excel sheet, that has an associated electrical load. I am able to import the data, isolate the elements that correspond, but can’t figure out how to write the load parameter for the element. Attached is a screencap of what I have so far. I think the main issue is the units of the load parameter being VA, not just a standard number. ![Equipment ID - Load_2021-05-12_12-00-49](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/4/6/46ccdd2d455413e1a457d254b2f8dc98005225dd.png) ---
**Author:** ![Nick\_Boyts](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/nick_boyts/32/76313_2.png) [@Nick\_Boyts](https://forum.dynamobim.com/u/Nick_Boyts)\ **Post date:** [May 12, 2021, 6:45pm UTC](https://forum.dynamobim.com/t/writing-load-value-from-excel-sheet-to-load-parameter/63879/2 "2021-05-12T18:45:34Z")
I’d start by using the OotB node (so you can see the errors) and fixing your list structure so that the values and elements are the same. ---
**Author:** ![corey.coleman](https://avatars.discourse-cdn.com/v4/letter/c/9de053/32.png) [@corey.coleman](https://forum.dynamobim.com/u/corey.coleman)\ **Post date:** [May 13, 2021, 4:10pm UTC](https://forum.dynamobim.com/t/writing-load-value-from-excel-sheet-to-load-parameter/63879/3 "2021-05-13T16:10:04Z")
Thanks for the advice Nick, I couldn’t find the OotB node you mentioned. Is there a specific package its under? The list part matches the correct elements, the main issue I’m having is I cannot write the numerical load value into the “Electrical Load” parameter. The “Electrical Load” parameter is stored as VA, and I’m assuming I cant overwrite the load values with numerical values is due to the units, or type of parameter. Is there a way to convert my excel load information into Revit’s “apparent load” type of parameter. ![Capture](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/7/d/7d4b9d0f9bfcdc4dd36c65f822bd545c31fe73a3.jpeg) ---
**Author:** ![Nick\_Boyts](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/nick_boyts/32/76313_2.png) [@Nick\_Boyts](https://forum.dynamobim.com/u/Nick_Boyts)\ **Post date:** [May 13, 2021, 4:26pm UTC](https://forum.dynamobim.com/t/writing-load-value-from-excel-sheet-to-load-parameter/63879/4 "2021-05-13T16:26:57Z")
`SetParameterByName` is the node. OotB (out of the box) just means that the node is part of the standard installation of Dynamo, not from a package. I pointed out your list _structure_ because your elements seem to be in a list of lists (@L3) while your values are a flattened list (@L2). This could be causing some lacing issues (though likely not). Apparent Power is still represented by a number. Your object type is fine. ---
**Author:** ![corey.coleman](https://avatars.discourse-cdn.com/v4/letter/c/9de053/32.png) [@corey.coleman](https://forum.dynamobim.com/u/corey.coleman)\ **Post date:** [May 13, 2021, 7:23pm UTC](https://forum.dynamobim.com/t/writing-load-value-from-excel-sheet-to-load-parameter/63879/5 "2021-05-13T19:23:29Z")
Hey Nick, It was the “set parameter” node. The OotB one did the trick. Thanks for the help! and lingo explanation.