Stats

  • Locked Locked
  • Replies 4
  • Subscribers 65
  • Views 8084
  • Members are here 0
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Errors Using Data Files in AWR MWO

kkeefe80

Hi all,

I have been having what seems to be an abnormal amount of trouble using vectors obtained from data files in AWR Microwave Office (v16.03r).
I'm attempting to plot the impedance of a transformer I measured using measurements taken from output equations, but I'm getting the error "Equation Error: Data file not found" as pictured here:


I've dug through the User Guide and formatted the text in the data file (namely column headers) to match the suggestions there. Here it is:

Fullscreen WEX.txt Download 
Freq(,Hz),Zmag(Mag,ohms),Zphs(Phs,deg)
1000000,71.1708145141602,-87.3818817138672
1035142.16667934,66.6900405883789,-87.3720779418945
1071519.30523761,62.721363067627,-87.3351058959961
1109174.8152624,59.2031021118164,-87.2867126464844
1148153.62149688,56.040943145752,-87.2367553710938
1188502.22743702,53.1951713562012,-87.1715774536133
1230268.77081238,50.5946350097656,-87.1112060546875
1273503.08101666,48.224479675293,-87.0419158935547
1318256.73855641,46.0440826416016,-86.9566421508789
1364583.13658892,43.7204284667969,-86.8692016601563
1412537.54462275,41.2826843261719,-86.7542037963867
1462177.17445672,39.0714950561523,-86.6213150024414
1513561.24843621,37.0477676391602,-86.490608215332
1566751.07010815,35.181209564209,-86.3337249755859
1621810.09735893,33.4615020751953,-86.1584548950195
1678804.01812256,31.8684043884277,-85.9879760742188
1737800.82874938,30.3758544921875,-85.8071517944336
1798870.91512879,28.789342880249,-85.5737915039063
1862087.13666287,27.0966796875,-85.3056030273438
1927524.91319094,25.5306262969971,-84.9917221069336
1995262.31496888,24.0732746124268,-84.6587295532227
2065380.15581053,22.7164497375488,-84.3026275634766
2137962.08950223,21.4338035583496,-83.910026550293
2213094.70960564,20.2456130981445,-83.4519729614258
2290867.65276777,19.1198787689209,-82.9762802124023
2371373.70566165,17.9051532745361,-82.3821716308594
2454708.91568503,16.5655975341797,-81.5995864868164
2540972.7055493,15.3138151168823,-80.7260284423828
2630267.99189538,14.1368312835693,-79.7175369262695
2722701.30807791,13.0261631011963,-78.5517425537109
2818382.93126445,11.977879524231,-77.2188873291016
2917427.01400117,10.9824638366699,-75.6857604980469
3019951.72040202,10.0430946350098,-73.8691482543945
3126079.36712395,9.15162372589111,-71.7425308227539
3235936.56929628,8.17215538024902,-68.7189407348633
3349654.39157827,7.12682819366455,-64.3525238037109
3467368.50452532,6.17771625518799,-58.6378784179688
3589219.34645005,5.34810972213745,-51.1115226745605
3715352.29097173,4.66660594940186,-41.2613868713379
3845917.82045353,4.19317531585693,-28.6398010253906
3981071.70553498,3.98108506202698,-13.9528102874756
4120975.1909733,4.06558179855347,1.04524445533752
4265795.18801593,4.50467491149902,16.1942939758301
4415704.47353313,5.34818840026855,29.3308753967285
4570881.89614875,6.44545412063599,38.291374206543
4731512.58961481,7.72425889968872,44.2823295593262
4897788.19368446,9.14593982696533,48.2090187072754
5069907.08274704,10.707781791687,50.6599540710449
5248074.60249773,12.403377532959,51.9282913208008
5432503.31492433,14.2124738693237,52.1436958312988
5623413.25190349,16.3176326751709,51.4332733154297
5821032.17770871,18.7685089111328,50.233772277832
6025595.86074358,21.5092449188232,49.1121559143066
6237348.35482419,24.8794956207275,47.2826957702637
6456542.29034656,28.9709510803223,44.0370941162109
6683439.17568615,33.7608451843262,38.9032669067383
6918309.70918937,39.0345458984375,31.4690113067627
7161434.10212902,44.0975379943848,21.3614673614502
7413102.41300917,47.5165252685547,8.76053619384766
7673614.89361819,47.4193153381348,-7.38850259780884
7943282.34724281,42.0918273925781,-24.0835247039795
8222426.49947072,34.6984634399414,-36.2441444396973
8511380.38202376,27.9060897827148,-44.059455871582
8810488.73008015,22.3682918548584,-48.6569175720215
9120108.39355909,17.9749431610107,-50.9088134765625
9440608.76285924,14.4701862335205,-51.2577171325684
9772372.2095581,11.6337099075317,-49.8366775512695
10115794.542599,9.02089977264404,-45.8521194458008
10471285.480509,6.70264530181885,-37.0905418395996
10839269.140212,5.09313869476318,-22.1109256744385
11220184.5430196,4.28810739517212,-0.357880055904388
11614486.1384034,4.33613014221191,22.9009990692139
12022644.3461741,5.00118207931519,40.7090492248535
12445146.1177139,5.97514820098877,52.266658782959
12882495.5169313,7.07845020294189,59.6689147949219
13335214.3216332,8.38761806488037,65.0975341796875
13803842.6460288,9.93875503540039,69.0955429077148
14288939.585111,11.4866209030151,71.636100769043
14791083.8816821,13.0275049209595,73.2680358886719
15310874.6168203,14.5811004638672,74.2704086303711
15848931.9246111,16.1565399169922,74.7629776000977
16405897.7319954,17.7772045135498,74.8006439208984
16982436.5246175,19.457426071167,74.3343353271484
17579236.1395869,21.1945838928223,73.2869644165039
18197008.5860998,23.2538795471191,71.0779724121094
18836490.894898,25.4280948638916,66.5614013671875
19498445.9975805,26.2155666351318,59.304615020752
20183663.6368156,23.8199329376221,53.2140922546387
20892961.3085404,20.5869369506836,55.7472534179688
21627185.2372702,19.6823692321777,63.8126220703125
22387211.3856834,20.5860290527344,70.643684387207
23173946.4996848,22.1616134643555,74.9708786010742
23988329.1901949,24.157299041748,77.9191436767578
24831331.0529557,26.4406051635742,79.8902816772461
25703957.8276886,28.6624794006348,81.0637359619141
26607250.5979881,30.8499145507813,81.8187484741211
27542287.0333817,32.9892387390137,82.306282043457
28510182.6750391,35.1159439086914,82.6431579589844
29512092.2666639,37.2695236206055,82.8899154663086
30549211.1321551,39.4577903747559,83.0471115112305
31622776.6016838,41.9895401000977,83.1179122924805
32734069.4878838,45.0475158691406,83.0830383300781
33884415.6139203,48.2706298828125,82.8872375488281
35075187.3952568,51.6675796508789,82.4884262084961
36307805.4770101,55.2444915771484,81.7523574829102
37583740.4288444,58.8656539916992,80.4859771728516
38904514.4994281,62.066650390625,78.4270324707031
40271703.4325459,63.491153717041,75.9283599853516
41686938.3470335,62.6572189331055,75.2765121459961
43151907.6827765,63.2035980224609,77.9169921875
44668359.2150963,67.615852355957,80.8688049316406
46238102.139926,73.6164627075195,82.3531036376953
47863009.2322639,80.1733016967773,83.0142288208008
49545019.080479,87.1886596679688,83.2731857299805
51286138.3991365,94.7917251586914,83.2786331176758
53088444.4230988,103.119766235352,83.1113433837891
54954087.3857624,112.291893005371,82.6923446655273
56885293.0843841,123.508941650391,81.9040756225586
58884365.5355589,137.333724975586,81.3640670776367
60953689.7240169,155.320755004883,81.0081253051758
63095734.4480193,177.591369628906,80.0773773193359
65313055.2647472,204.446090698242,78.9877624511719
67608297.5391982,240.599273681641,78.0933609008789
69984199.6002273,293.733856201172,76.5670013427734
72443596.007499,374.617218017578,73.6470108032227
74989420.9332456,535.149658203125,67.0564422607422
77624711.6628692,957.489562988281,46.2744255065918
80352612.2185617,1309.24072265625,-14.7202568054199
83176377.1102671,738.347412109375,-55.6204490661621
86099375.2184601,454.685211181641,-69.0577774047852
89125093.8133746,321.000213623047,-74.2373199462891
92257142.7154763,249.286178588867,-76.9172439575195
95499258.6021436,202.518356323242,-79.2940063476563
98855309.4656939,167.800140380859,-80.9299240112305
102329299.228075,137.916320800781,-81.8435897827148
105925372.517729,112.838066101074,-81.8860855102539
109647819.614319,94.8493270874023,-80.8907623291016
113501081.567232,82.1459045410156,-80.0810699462891
117489755.493953,71.1364974975586,-79.1569137573242
121618600.064637,63.4030952453613,-77.6486129760742
125892541.179417,56.7914428710938,-78.429817199707
130316677.84523,49.0072135925293,-79.3742523193359
134896288.259165,40.4025192260742,-78.9920501708984
139636836.105594,31.6991729736328,-76.4815063476563
144543977.074593,24.558801651001,-71.1567916870117
149623565.609443,18.7562561035156,-64.2286529541016
154881661.891248,13.1825408935547,-51.1505813598633
160324539.069004,9.786301612854,-23.8335189819336
165958690.743756,9.91116142272949,14.2414598464966
171790838.715759,14.6098775863647,39.1999816894531
177827941.003892,21.818904876709,45.6220512390137
184077200.146896,25.7088775634766,48.3594360351563
190546071.796325,32.0223159790039,58.9323272705078
197242273.611485,41.2049331665039,62.9379730224609
204173794.466953,50.4726486206055,67.8146133422852
211348903.983665,66.7589569091797,72.2107772827148
218776162.394955,91.0789031982422,72.7668991088867
226464430.759306,127.504753112793,70.7384719848633
234422881.531992,193.72705078125,65.1696472167969
242661009.508242,381.902954101563,41.8556938171387
251188643.150958,399.700744628906,-39.545051574707
260015956.316527,172.801864624023,-66.0991363525391
269153480.392692,95.5079193115234,-69.5103988647461
278612116.862977,56.042423248291,-64.1605911254883
288403150.312661,32.1641044616699,-40.0548934936523
298538261.891796,35.6988716125488,13.3884477615356
309029543.251359,77.639289855957,25.4630184173584
319889510.96914,130.081039428711,-1.6982170343399
331131121.482591,122.707336425781,-35.8906936645508
342767786.54645,89.5835800170898,-50.7476806640625
354813389.233575,67.7306900024414,-60.8447380065918
367282300.498085,45.9758262634277,-63.1593933105469
380189396.320561,32.2991943359375,-57.7256050109863
393550075.455777,21.4364166259766,-46.8885231018066
407380277.804113,14.2685699462891,-15.0130262374878
421696503.428582,18.8584537506104,37.7326011657715
436515832.240166,40.8988037109375,56.0510635375977
451855944.374922,81.967170715332,51.0118141174316
467735141.287198,163.140594482422,12.8448133468628
484172367.584099,94.5256118774414,-44.8860054016113
501187233.627272,38.221134185791,-44.9083442687988
518800038.928961,22.0185832977295,8.59653377532959
537031796.370253,43.4509429931641,48.3808212280273
555904257.270404,92.0226135253906,48.4280738830566
575439937.337157,171.26823425293,3.07752585411072
595662143.529011,109.837745666504,-26.6238327026367
616595001.861482,77.4579620361328,-52.2632255554199
638263486.190549,45.2398490905762,-45.6320190429688
660693448.007596,36.9952011108398,-35.7036476135254
683911647.281429,26.43479347229,-28.4679622650146
707945784.384138,18.610860824585,4.82215261459351
732824533.138904,25.6438732147217,42.1618156433105
758577575.029184,45.4791526794434,58.6564445495605
785235634.610072,91.7439956665039,48.6563491821289
812830516.164099,81.5353851318359,37.2267265319824
841395141.645195,187.219604492188,36.8353652954102
870963589.956081,203.520294189453,-33.0203666687012
901571137.605957,96.431999206543,-50.5185470581055
933254300.796991,61.3614463806152,-42.7328948974609
966050878.989813,45.6491355895996,-37.2531471252441
1000000000,28.4652900695801,-12.1855096817017

That's data for a Wurth Electronik 750315839 measured using an old HP 4291A impedance analyzer for those interested.

I'm fairly certain that microwave office recognizes that I'm pointing to this file, which is clearly there under "Data Files" in my project view, given that I can rename it with "Synchronize" checked and the data file name will change accordingly in the very output equations I'm trying to use it in. I've gotten this kind of thing to work before using Ls and Q measurements from the same analyzer as parameters in the INDQP model after some similar formatting and identical usage of datafilecol, but it's painful every single time and I've been unable to get it to work in this instance.

I'd love to have a bit more insight into why the error I'm seeing is appearing, since I kind of doubt that MWO is actually unable to find the data file. It could be something as simple as trying to graph the data in the wrong way - I have no idea.

Thanks in advance,
Kyle

  • Hi Kyle,

    This solution should work so that you can get up and running quickly.

    You can use the function test_data:PlotCol(1,1) and test_data:PlotCol(1,2) to be able to access the columns in the datafile.

    With this setup in the output equations, I was able to create the plot you wanted.

    Let me know if this helps.

    Note that I had to change your datafile heading. Per the users guide, the heading must be separated by one or more spaces, or also a tab character.

    Snippet of users guide:

    Thanks,

    David

  • in reply to David Webster

    Hi David,

    Thanks a bunch! Your workaround, at first glance, feels more like a solution given that I'm even able to use the vectors returned by PlotCol for math in other equations. Thanks for the tip on the formatting; I double checked instances where I'd gotten datafilecol to behave and found that that was indeed how I'd formatted the file - guess my reading comprehension is better on some days than others!

    Just for fun:

    My calculated results don't seem very pretty, but it works!

    Thanks again,
    Kyle

  • in reply to David Webster

    Hi Dave,

    Which document did you pull this screenshot from?

    I'm new to scripting with AWR and I'm trying to get some reference material.

    Best,

    Tom

  • in reply to TomekJ

    Hi Tom,

    I pulled the "Column Headings" from Chapter 3 of the Users Guide.

    We also have scripting specific information and examples in both VBA and Python. My recommendation would be to use Python as it offers greater capability with vast array of online resources and open source libraries, but both Python and VBA are widely used by customers.

    For more information, I would head over to: https://kb.awr.com/

    From that link, you can go to Docs to get the Users Guide. You might also be interested in the API guide for scripting.

    To get more scripting examples in both Python and VBA, head to the same link and click Scripting. On the left, you will see options to help get you scripting.

    Hope that helps Slight smile

    David Webster

Community Guidelines

The Cadence Design Communities support Cadence users and technologists interacting to exchange ideas, news, technical information, and best practices to solve problems and get the most from Cadence technology. The community is open to everyone, and to provide the most value, we require participants to follow our Community Guidelines that facilitate a quality exchange of ideas and information. By accessing, contributing, using or downloading any materials from the site, you agree to be bound by the full Community Guidelines.