{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Performance","NHTModel","TemperatureProfile"],"not_rendered":{"charts":3,"images":3,"macros":1,"external_links":0,"defined_names":23,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Performance","index":0,"n_rows":65,"n_cols":16,"rows_kept":65,"cut":false,"hidden":false,"merged":[[35,4,35,6],[36,4,36,6],[38,4,38,6],[16,4,16,6],[17,4,17,6],[19,4,19,6]]}
["Model of Mechanically Compliant Thermoelectric Energy Harvester",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"by Matthew Zabawa  |  matthewzabawa@gmail.com"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Using Micropelt D602"]
[null,null,"Temp [C]","Thermal Resistance","k [W/mK]","Area [m^2]","Length [m]"]
[null,"Air",20]
[1,"Heat Sink",{"$f":"C16-D17*$D$25","v":-2.125163988994295},20,"N25-25B"]
[2,"Joint    .",-3.1907854564725664,{"$f":"NHTModel!B13","v":0.96326650325244367},"From NHTModel"]
[3,"Grease  .",-4.3707942025522621,{"$f":"G19/E19/F19","v":1.0666666666666669},5,{"$f":"0.0025*0.00375","v":9.3749999999999992E-6},5.0000000000000002E-5]
[4,"TEG   .",-17.645892595948837,12,"Micropelt D602"]
[5,"Grease  .",-19.41590571506838,{"$f":"G21/E21/F21","v":1.6},5,{"$f":"0.0025*0.0025","v":6.2500000000000003E-6},5.0000000000000002E-5]
[6,"Structure",-19.999999999999996,{"$f":"G22/E22/F22","v":0.52799092040372009},167,{"$f":"PI()*0.0095^2/4","v":7.0882184246619701E-5},6.2500000000000003E-3]
[7,"Skin",-20]
[null,"Total Resistance [W/K]= ",null,{"$f":"SUM(D17:D22)","v":36.15792409032283}]
[null,null,"q [W]= ",{"$f":"(C16-C23)/D24","v":1.1062581994497147}]
[null,"del T across TEG [C]=",null,{"$f":"C19-C20","v":13.275098393396576}]
["Est. Open Circuit Voltage [V]",null,null,{"$f":"D26*I54","v":1.3275098393396576}]
["Est. Max Power [mW]",null,null,{"$f":"(D27/2)^2/J54*1000","v":2.2028529669295045}]
[]
[null,"note: Temperature represents the interface "]
[null,null,"between n-1 and n"]
[]
["Using Micropelt D751"]
[null,null,"Temp [C]","Thermal Resistance","k [W/mK]","Area [m^2]","Length [m]"]
[null,"Air",20]
[1,"Heat Sink",{"$f":"C35-D36*$D$44","v":1.3030271292173374},13.06,"N25-25B"]
[2,"Joint    .",-7.6005617998942787E-2,{"$f":"NHTModel!B13","v":0.96326650325244367},"From NHTModel"]
[3,"Grease  .",-0.63986155403744827,{"$f":"G38/E38/F38","v":0.39385833073386828},8.89,{"$f":"0.00425*0.00336","v":1.4280000000000002E-5},5.0000000000000002E-5]
[4,"TEG   .",-18.53512655287231,12.5,"Micropelt D751"]
[5,"Grease  .",-19.244117004991733,{"$f":"G40/E40/F40","v":0.49523606675116577},8.89,{"$f":"0.00338*0.00336","v":1.1356800000000001E-5},5.0000000000000002E-5]
[6,"Structure",-19.999999999999996,{"$f":"G41/E41/F41","v":0.52799092040372009},167,{"$f":"PI()*0.0095^2/4","v":7.0882184246619701E-5},6.2500000000000003E-3]
[7,"Skin",-20]
[null,"Total Resistance [W/K]= ",null,{"$f":"SUM(D36:D41)","v":27.940351821141199}]
[null,null,"q [W]= ",{"$f":"(C35-C42)/D43","v":1.4316211999067889}]
[null,"del T across TEG [C]=",null,{"$f":"C38-C39","v":17.895264998834861}]
["Est. Open Circuit Voltage [V]",null,null,{"$f":"D45*I55","v":2.5053370998368809}]
["Est. Max Power [mW]",null,null,{"$f":"(D46/2)^2/J55*1000","v":5.2305949865158938}]
[]
[]
[]
["Heat Sinks",null,null,null,null,null,null,"Thermoelectric Generators"]
["Free Convection Thermal Resistance [C/W] ",null,null,null,null,null,null,null,"Net Seebeck Coeff.[V/K]","Electrical Resistance [W]"]
[null,"Height [mm]",null,null,null,null,null,"Product"]
["Size",10,15,20,25,null,null,"D602",0.1,200]
["19x19",21.8,19.100000000000001,17,15.2,null,null,"D751",0.14000000000000001,300]
["25x25",18.600000000000001,15.9,14,12.9]
["30x30",15,12.3,10.4,9.1]
["35x35",12.7,10.5,9.1,7.9]
["40x40",10.6,8.4,7.2,6.4]
["45x45",9.1999999999999993,7.3,6.3,5.5]
["50x50",8.1,6.3,5.2,4.5]
["http://www.micforg.co.jp/en/c_n50e.html"]
["Hex Pin 2.2mm"]
["8-10mm spacing"]
["Pure Aluminum with Black Anodize"]

{"sheet":"NHTModel","index":1,"n_rows":18,"n_cols":13,"rows_kept":18,"cut":false,"hidden":false,"merged":[[2,2,9,2],[0,2,0,7]]}
["Plug Radius (Rp) [mm] (must be < Ro)",6.789834511970275,"This is the Control Variable in the Design.  To find the optimal value click the Optimize button. (note: Solver must be added in)"]
[]
["Clearance (Cl) [microns]",50,"Input"]
["Lp [mm]",8.25]
["L [mm]",15]
["Gap (G) [mm]",4]
["Ls [mm]",3]
["Outside Radius (Ro) [mm]",9.5]
["Metal conductivity (Kal) [W/mK]",167]
["Grease Conductivity (Kg) [W/mK]",3]
[]
[]
["Total Joint Thermal Resistance (Rtot) [K/W]",{"$f":"ThermR(B1,B3,B4,B5,B6,B7,B8,B9,B10)","v":0.96326650325244367},null,null,null,null,null,null,null,null,null,"Plug Radius [m]",6.789834511970275E-3]
[null,null,null,null,null,null,null,null,null,null,null,"Thermal Resistance in Plug (Rplg) [K/W]",0.34109018800694896]
[null,null,null,null,null,null,null,null,null,null,null,"Thermal Resistance in Joint (Rjnt) [K/W]",0.5588174047246206]
[null,null,null,null,null,null,null,null,null,null,null,"Thermal Resistance in Stem (Rstm) [K/W]",6.3358910520844511E-2]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Total Joint Thermal Resistance (Rtot)[K/W]",0.96326650325241414]

{"sheet":"TemperatureProfile","index":2,"n_rows":26,"n_cols":21,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[1,300,300,300,300,300,300,300,300,300,300,300,300,300,295.98725257970386,295.31089201020393,294.92452462972682,294.72856287660113,294.68748455364027,1,1]
[1,298.91388381929181,298.90840063473257,298.899003626563,298.88554389299435,298.86745833223011,298.84371730453205,298.81261559361479,298.77133824547502,298.71509659375033,298.63535315142263,298.51599273765635,298.32462783033355,297.99185599412959,295.60673498748451,295.11614755261201,294.79264182266519,294.61468412352616,294.56169215379424,1,1]
[1,297.84034710698387,297.83006259010227,297.81251485456272,297.78756714962009,297.75441929073241,297.71160775435425,297.65682141082283,297.58654128806251,297.49545402024188,297.37557677800288,297.21513748127416,296.99779500846427,296.70484216373126,295.05964371659803,294.70945738692507,294.46215721127606,294.31885278565221,294.27338647255112,1,1]
[1,296.79030332627423,296.77630949840682,296.75257603281329,296.71916732790783,296.67541587095235,296.62003466664407,296.55107180160184,296.46579097242875,296.36053480724581,296.23067547752703,296.07089434015688,295.87630966942515,295.64537955143533,294.4368460989179,294.1789243297618,293.99230699709392,293.88157394358473,293.84581406892323,1,1]
[1,295.77226302685739,295.75570421903797,295.72780322742807,295.68894070700463,295.63880688581662,295.57661583336193,295.5011801478658,295.41095899402563,295.30415142891638,295.17892027525568,295.0338662627309,294.86889420247871,294.68653122613819,293.76183425912853,293.56522056851566,293.42220982512924,293.33667412612846,293.30895188613005,1,1]
[1,294.79221101409064,294.77400796080497,294.74352714191218,294.70149102474466,294.64801137451593,294.58286676161646,294.50564090182417,294.41583746509463,294.31302801391683,294.19707552561187,294.06846594404868,293.92874969585313,293.78101579789239,293.04566144680257,292.89006292592865,292.77709819623152,292.70949188779724,292.6876290031463,1,1]
[1,293.85408532498946,293.83480001481666,293.80268129109385,293.75876262695277,293.70354205196156,293.63728962162293,293.56020684043699,293.47254990327144,293.37475965851138,293.26761728165275,293.15242760766256,293.03120875514975,292.90683290149269,292.29537694630164,292.16658757652402,292.07346183918384,292.0178537174948,291.9999516138144,1,1]
[1,292.96055248136736,292.94036980785376,292.90689913348638,292.86143618278635,292.80479375541427,292.73762195273082,292.66056878329363,292.57439105107784,292.4800518613003,292.37881563281383,292.27233728556638,292.16272991137095,292.05258410006934,291.51572742125308,291.40307659878249,291.32194848549386,291.27364232566731,291.25816311471709,1,1]
[1,292.11382522310947,292.09260191971015,292.05750733965948,292.010056829875,291.95130705955023,291.88218632652075,291.80365267369615,291.71679161739394,291.62288835689685,291.52348404115344,291.42041433686387,291.31582206384138,291.21213256094438,290.70961110917625,290.6044409200469,290.52893557547037,290.48408142586021,290.46975475012113,1,1]
[1,291.31637626577663,291.29371699630542,291.25630403120175,291.20584385600904,291.14357915951445,291.07063637701503,290.98818663117896,290.8975378787689,290.80019448735612,290.69789457117434,290.59262525509104,290.48661179519536,290.38227578005132,289.87822133869764,289.77286891311871,289.69737308136939,289.65258305254997,289.63828951774144,1,1]
[1,290.57148869340176,290.54682847109757,290.50611929057385,290.45124108220421,290.38357467549031,290.3043794133597,290.21496663551233,290.11679706651574,290.01154140011545,289.90111541381378,289.78769028565142,289.67367469654124,289.56166504564828,289.02106496990166,288.90808695998589,288.82718395343596,288.7792017179051,288.76386695443443,1,1]
[1,289.88362882693048,289.85631740184851,289.81118907048136,289.75028043102714,289.67506130706488,289.58685772851146,289.48704946734949,289.3771849916871,289.25905782895074,289.13475660007055,289.00668804883884,288.87756650230949,288.75036190489817,288.13588192821942,288.00736957756408,287.91534644498955,287.86075932622117,287.84326143625316,1,1]
[1,289.25863691872871,289.22803103035312,289.1773650161997,289.10880341645128,289.0238401889531,288.92378160933282,288.80997875940358,288.68397268793723,288.54760353870927,288.40309772341129,288.25312968641123,288.10084361930376,287.94981400338878,287.21844010445005,287.06531803405142,286.9556981361572,286.89068344942052,286.86977514294944,1,1]
[1,288.70371826861754,288.66929216170752,288.61215404430669,288.5345426699655,288.4378824502823,288.32333537168239,288.19207430702346,288.04546773427921,287.88523949079126,287.7136238280313,287.53351171210198,287.34856140242908,287.1632219287323,286.26212497424007,286.07334113224135,285.93844414629285,285.85858681814739,285.83285086587131,1,1]
[1,288.22719481784691,288.18868000111314,288.12454625690322,288.03701735046349,287.92732118199831,287.79630567215685,287.64474453254462,287.47355756074938,287.28402974554893,287.07806790182616,286.85850602212878,286.62943140104346,286.39643355033616,285.25710399305194,285.01862867008941,284.84929491880013,284.74964193424137,284.71754730462771,1,1]
[1,287.83795345622349,287.7955227302827,287.72456174791154,287.62714949050894,287.50417622929018,287.35598482182132,287.18267078332264,286.98430150746145,286.76116509256173,286.5141270086109,286.24516879745761,285.95815989639306,285.65979614296327,284.18841173049242,283.88206092940118,283.6680973427417,283.54394694369159,283.50418731380722,1,1]
[1,287.54449466145712,287.4990531407816,287.42245590277463,287.31648440808749,287.18161509109285,287.01756437146116,286.82350539424749,286.59820126310353,286.34016564238146,286.04797070418311,285.72090457568567,285.36033215681556,284.97227042883407,283.03075997820673,282.6336124752259,282.36685823143443,282.21654064881591,282.16905004552621,1,1]
[1,287.35334900260176,287.30730878533666,287.22764368720766,287.11594969439454,286.97252273425028,286.79658674620953,286.5863965298343,286.33920608074357,286.05113145318182,285.71696781603987,285.33014986246718,284.88349872113895,284.37286652890697,281.73134655712744,281.22187826772949,280.90789280149323,280.73999355394471,280.68819573284981,1,1]
[1,287.26581200877678,287.22663526242394,287.14778399020446,287.03426812060167,286.88727338878289,286.70604529952334,286.48838934792622,286.23060574619899,285.92700464506913,285.56883922434986,285.14211386611214,284.62289034565356,283.9665696060647,280.13809068077984,279.55382276404885,279.24794354300559,279.09432276418056,279.04822911832531,1,1]
[1,0,0,0,0,0,0,0,0,0,0,0,0,0,277.7221416613778,277.59231569005777,277.45477699582455,277.36681781335579,277.33791038946629,1,1]
[1,0,0,0,0,0,0,0,0,0,0,0,0,0,275.69288499300643,275.65775581101121,275.60249714332531,275.56059431629063,275.54582520130884,1,1]
[1,0,0,0,0,0,0,0,0,0,0,0,0,0,273.76920899806669,273.75813670107016,273.73669337314129,273.71866589853431,273.71202969004463,1,1]
[1,0,0,0,0,0,0,0,0,0,0,0,0,0,271.87929273725422,271.87584495246608,271.86849095122074,271.86196359684448,271.85950672532613,1,1]
[1,1,1,1,1,1,1,1,1,1,1,1,1,1,270,270,270,270,270,1,1]
[1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]