纯技术

一个技术性的小格子

投稿

订阅

订阅数

获赞数

44

阅读数

25.4万

%7B%22cid%22%3A%5B38%5D%2C%22mcid%22%3A%5B%5D%2C%22columnId%22%3A100013%2C%22columnPostId%22%3A294%2C%22type%22%3A%22thread%22%2C%22article%22%3A%7B%22_id%22%3A%225df5aff393db34200c50153d%22%2C%22pid%22%3A%22867443%22%2C%22iplm%22%3A%225fc9f0d8f866372984f759ea%22%2C%22tid%22%3A%2284897%22%2C%22uid%22%3A%2275856%22%2C%22uidlm%22%3A%2275856%22%2C%22type%22%3A%22thread%22%2C%22cover%22%3A%225f1ea7748eb06c19e45247ea%22%2C%22surveyId%22%3Anull%2C%22anonymous%22%3Afalse%2C%22reviewed%22%3Atrue%2C%22originState%22%3A%220%22%2C%22authorInfos%22%3A%5B%7B%22contractObj%22%3A%7B%22contractCode%22%3A%22%22%2C%22contractAdd%22%3A%22%22%2C%22contractTel%22%3A%22%22%2C%22contractEmail%22%3A%22%22%7D%2C%22isContract%22%3Afalse%2C%22agencyAdd%22%3A%22%22%2C%22agencyCountry%22%3A%22%22%2C%22agency%22%3A%22%22%2C%22kcid%22%3A%22%22%2C%22name%22%3A%22LS%22%7D%5D%2C%22keyWordsEn%22%3A%5B%22Excel%22%5D%2C%22keyWordsCn%22%3A%5B%22%E5%A1%9E%E5%BC%8F%E5%96%B7%E7%AE%A1%22%2C%22%E8%AE%BE%E8%AE%A1%22%2C%22%E8%AE%A1%E7%AE%97%E5%B7%A5%E5%85%B7%22%5D%2C%22abstractEn%22%3A%22%22%2C%22abstractCn%22%3A%22%E4%B8%80%E6%AC%BE%E5%A1%9E%E5%BC%8F%E5%96%B7%E7%AE%A1%E5%9E%8B%E9%9D%A2%E8%AE%A1%E7%AE%97%E5%B7%A5%E5%85%B7%22%2C%22voteDown%22%3A0%2C%22voteUp%22%3A9%2C%22digestTime%22%3A%222019-12-17T15%3A52%3A03.841Z%22%2C%22digest%22%3Atrue%2C%22hideHistories%22%3Afalse%2C%22hasImage%22%3Afalse%2C%22tlm%22%3A%222019-12-15T04%3A00%3A51.083Z%22%2C%22toc%22%3A%222019-12-15T04%3A00%3A51.083Z%22%2C%22customForumsId%22%3A%5B%5D%2C%22minorForumsId%22%3A%5B%5D%2C%22mainForumsId%22%3A%5B%2289%22%5D%2C%22t%22%3A%22%E5%A1%9E%E5%BC%8F%E5%96%B7%E7%AE%A1%E8%AE%BE%E8%AE%A1%E5%B7%A5%E5%85%B7%E5%8F%91%E5%B8%83%2B%E4%BD%BF%E7%94%A8%E8%AF%B4%E6%98%8E%22%2C%22postCount%22%3A0%2C%22parentPostId%22%3A%22%22%2C%22parentPostsId%22%3A%5B%5D%2C%22rpid%22%3A%5B%5D%2C%22recUsers%22%3A%5B%5D%2C%22l%22%3A%22html%22%2C%22ipoc%22%3A%225fc9f0d8f866372984f759ea%22%2C%22toDraft%22%3Anull%2C%22disabled%22%3Afalse%2C%22credits%22%3A%5B%5D%2C%22c%22%3A%22%3Cp%3E%E5%A1%9E%E5%BC%8F%E5%96%B7%E7%AE%A1%E7%9A%84%E7%A1%AE%E6%80%A7%E8%83%BD%E4%BC%98%E8%89%AF%EF%BC%8C%E4%BD%86%E6%98%AF%E5%85%B6%E8%AE%BE%E8%AE%A1%E5%A4%8D%E6%9D%82%EF%BC%8C%E5%AF%B9%E4%BA%8E%E7%88%B1%E5%A5%BD%E8%80%85%E6%9D%A5%E8%AF%B4%E6%98%AF%E4%B8%AA%E6%AF%94%E8%BE%83%E5%A4%A7%E7%9A%84%E9%97%AE%E9%A2%98%E3%80%82%E6%9C%AC%E5%B7%A5%E5%85%B7%E6%97%A8%E5%9C%A8%E4%B8%BA%E7%88%B1%E5%A5%BD%E8%80%85%E6%8F%90%E4%BE%9B%E4%B8%80%E4%B8%AA%E6%88%90%E7%86%9F%E7%9A%84%E8%AE%A1%E7%AE%97%E5%B9%B3%E5%8F%B0%E4%BB%A5%E5%8F%8A%E8%AE%A1%E7%AE%97%E5%B7%A5%E5%85%B7%EF%BC%8C%E4%B8%BA%E7%88%B1%E5%A5%BD%E8%80%85%E6%8F%90%E4%BE%9B%E6%96%B9%E4%BE%BF%E3%80%82%3C%2Fp%3E%3Cp%3E%E8%AE%A1%E7%AE%97%E5%B7%A5%E5%85%B7%E4%BB%A5Microsoft%20Excel%E4%B8%BA%E6%9E%B6%E6%9E%84%EF%BC%8C%E5%85%B7%E4%BD%93%E8%AE%A1%E7%AE%97%E6%96%B9%E6%B3%95%E5%8F%82%E8%A7%81%E6%88%91%E7%9A%84%E5%8F%A6%E4%B8%80%E5%B8%96%E5%AD%90%EF%BC%8C%E9%93%BE%E6%8E%A5%E5%A6%82%E4%B8%8B%E3%80%82%3C%2Fp%3E%3Cp%3E%3Ca%20href%3Dhttps%3A%2F%2Fwww.kechuang.org%2Ft%2F84892%3Ehttps%3A%2F%2Fwww.kechuang.org%2Ft%2F84892%3C%2Fa%3E%3C%2Fp%3E%3Cp%3E%E8%BD%AF%E4%BB%B6%E7%95%8C%E9%9D%A2%3C%2Fp%3E%3Cp%3E%3Cimg%20data-tag%3D%5C%22nkcsource%5C%22%20data-type%3D%5C%22picture%5C%22%20data-id%3D%5C%22305825%5C%22%20src%3D%5C%22%2Fr%2F305825%5C%22%3E%3C%2Fp%3E%3Chr%3E%3Cp%3E%E4%BD%BF%E7%94%A8%E8%AF%B4%E6%98%8E%EF%BC%9A%E6%89%93%E5%BC%80%E8%BD%AF%E4%BB%B6%EF%BC%8C%E5%B7%A6%E5%8D%8A%E9%83%A8%E5%88%86%E6%98%AF%E6%95%B0%E6%8D%AE%E8%BE%93%E5%85%A5%E5%8C%BA%E3%80%82%E5%9C%A8%E8%BE%93%E5%85%A5%E7%87%83%E6%96%99%E6%95%B0%E6%8D%AE%E5%92%8C%E5%8F%91%E5%8A%A8%E6%9C%BA%E6%95%B0%E6%8D%AE%E4%B9%8B%E5%90%8E%EF%BC%8C%E6%91%81%E4%B8%8B%E5%9B%9E%E8%BD%A6%E6%8C%89%E9%92%AE%EF%BC%8C%E5%8D%B3%E5%8F%AF%E8%87%AA%E5%8A%A8%E5%BC%80%E5%A7%8B%E8%AE%A1%E7%AE%97%E3%80%82%3C%2Fp%3E%3Cp%3E%E7%AC%94%E8%80%85%E4%BB%A5%E8%AE%BE%E8%AE%A1%E6%8E%A8%E5%8A%9B200N%EF%BC%8C%E5%AE%A4%E5%8E%8B10MPa%EF%BC%8C%E5%87%BA%E5%8F%A3%E5%8E%8B%E5%8A%9B0.1MPa%E8%BF%9B%E8%A1%8C%E8%AE%BE%E8%AE%A1%E3%80%82%E6%91%81%E4%B8%8B%E5%9B%9E%E8%BD%A6%E9%94%AE%E5%90%8E%EF%BC%8C%E5%9C%A8%E4%B8%8B%E6%96%B9%E5%87%BA%E7%8E%B0%E8%B4%A8%E9%87%8F%E6%B5%81%E9%87%8F%E3%80%81%E5%87%BA%E5%8F%A3%E9%A9%AC%E8%B5%AB%E6%95%B0%E3%80%81%E6%89%A9%E5%BC%A0%E6%AF%94%E7%AD%89%E5%BF%85%E8%A6%81%E7%9A%84%E6%95%B0%E6%8D%AE%EF%BC%8C%E5%9C%A8%E8%AE%BE%E8%AE%A1%E6%97%B6%E5%8F%82%E8%80%83%E3%80%82%3C%2Fp%3E%3Cp%3E%3Cimg%20data-tag%3D%5C%22nkcsource%5C%22%20data-type%3D%5C%22picture%5C%22%20data-id%3D%5C%22305823%5C%22%20src%3D%5C%22%2Fr%2F305823%5C%22%3E%3C%2Fp%3E%3Cp%3E%E5%8F%B3%E5%8D%8A%E9%83%A8%E5%88%86%E4%B8%BA%E5%A1%9E%E5%BC%8F%E5%96%B7%E7%AE%A1%E5%9E%8B%E9%9D%A2%E7%9A%84%E6%95%B0%E6%8D%AE%E8%BE%93%E5%87%BA%E9%83%A8%E5%88%86%E3%80%82%3Cbr%3E%3C%2Fp%3E%3Cp%3E%3Cimg%20data-tag%3D%5C%22nkcsource%5C%22%20data-type%3D%5C%22picture%5C%22%20data-id%3D%5C%22305826%5C%22%20src%3D%5C%22%2Fr%2F305826%5C%22%3E%3C%2Fp%3E%3Cp%3E%E8%BF%99%E4%B8%80%E4%B8%B2%E6%95%B0%E6%8D%AE%E5%92%8C%E4%B8%8A%E9%9D%A2%E7%9A%84%E6%95%B0%E6%8D%AE%E5%AF%B9%E5%BA%94%E5%8E%9F%E5%B8%96%E4%B8%AD%E7%9A%848%E4%B8%AA%E5%85%AC%E5%BC%8F%E3%80%82%E5%9C%A8%E8%AE%A1%E7%AE%97L%EF%BC%88%E8%86%A8%E8%83%80%E6%B3%A2%E9%95%BF%E5%BA%A6%EF%BC%89%E6%97%B6%E9%87%87%E7%94%A8%E5%88%86%E6%AE%B5%E8%AE%A1%E7%AE%97%E7%9A%84%E6%96%B9%E6%B3%95%E3%80%82%3Cbr%3E%3C%2Fp%3E%3Cp%3E%3Cimg%20data-tag%3D%5C%22nkcsource%5C%22%20data-type%3D%5C%22picture%5C%22%20data-id%3D%5C%22305827%5C%22%20src%3D%5C%22%2Fr%2F305827%5C%22%3E%3C%2Fp%3E%3Cp%3E%E5%A6%82%E5%9B%BE%EF%BC%8C%E8%B7%91%E5%87%BA%E6%9D%A5%E7%9A%84%E6%98%AF%E4%B8%80%E9%95%BF%E4%B8%B2%E7%9A%84%E6%95%B0%E6%8D%AE%EF%BC%8C%E5%9C%A8%E5%AE%9E%E9%99%85%E4%BD%BF%E7%94%A8%E6%97%B6%E5%8F%AA%E9%9C%80%E8%A6%81%E7%9C%8B3%E8%A1%8C%E7%94%A8%E5%BD%A9%E8%89%B2%E5%AD%97%E4%BD%93%E6%A0%87%E5%87%BA%E7%9A%84%E6%95%B0%E6%8D%AE%E5%8D%B3%E5%8F%AF%EF%BC%8C%E5%85%B6%E4%BD%99%E6%95%B0%E6%8D%AE%E5%8F%AA%E6%98%AF%E4%B8%BA%E4%BA%86%E6%96%B9%E4%BE%BF%E8%AE%A1%E7%AE%97%EF%BC%8C%E5%8F%AF%E4%BB%A5%E5%BF%BD%E7%95%A5%E3%80%82%E5%90%8E%E9%9D%A2%E7%9A%843%E5%88%97%E9%87%8D%E5%A4%8D%E6%95%B0%E6%8D%AE%E6%98%AF%E8%AE%A1%E7%AE%97%E6%9C%BA%E5%88%B6%E4%BA%A7%E7%94%9F%E7%9A%84%E6%AD%A3%E5%B8%B8%E7%8E%B0%E8%B1%A1%EF%BC%8C%E4%B8%8D%E5%BD%B1%E5%93%8D%E6%AD%A3%E5%B8%B8%E4%BD%BF%E7%94%A8%EF%BC%8C%E5%9C%A8%E5%AE%9E%E9%99%85%E5%BB%BA%E6%A8%A1%E6%97%B6%E5%8F%AA%E7%94%A8%E7%9C%8B%E5%85%B6%E4%B8%AD%E7%9A%84%E4%B8%80%E4%B8%AA%E6%95%B0%E6%8D%AE%E5%8D%B3%E5%8F%AF%E3%80%82%3C%2Fp%3E%3Chr%3E%3Cp%3E%E4%B8%8B%E9%9D%A2%E6%98%AF%E8%BD%AF%E4%BB%B6%EF%BC%8C%E8%AF%B7%E5%A4%A7%E5%AE%B6%E8%87%AA%E8%A1%8C%E4%B8%8B%E8%BD%BD%E4%BD%BF%E7%94%A8%E3%80%82%3C%2Fp%3E%3Cp%3E%3Ca%20data-tag%3D%5C%22nkcsource%5C%22%20data-type%3D%5C%22attachment%5C%22%20data-id%3D%5C%22305824%5C%22%20href%3D%2Fr%2F305824%3E%E5%A1%9E%E5%BC%8F%E8%AE%A1%E7%AE%97%E5%B7%A5%E5%85%B7.xls%3C%2Fa%3E%3C%2Fp%3E%3Cp%3E%3Cbr%3E%3C%2Fp%3E%22%2C%22atUsers%22%3A%5B%5D%2C%22__v%22%3A0%2C%22hide%22%3A%22null%22%2C%22cv%22%3A1%2C%22quote%22%3Anull%2C%22flowControl%22%3Afalse%2C%22threadPostCount%22%3A22%2C%22voteDownTotal%22%3A1%2C%22voteUpTotal%22%3A17%2C%22comment%22%3A%22rw%22%2C%22tcId%22%3A%5B%5D%2C%22addr%22%3A%22%E5%B9%BF%E4%B8%9C%22%2C%22id%22%3A%225df5aff393db34200c50153d%22%7D%2C%22collectedCount%22%3A25%2C%22collected%22%3Afalse%2C%22isLastPage%22%3Atrue%7D

文号867443

58683

22

收藏(25)

塞式喷管设计工具发布+使用说明

LS

LS2019/12/15 12:00:51纯技术

中文摘要

一款塞式喷管型面计算工具

关键词

塞式喷管设计计算工具

Excel

塞式喷管的确性能优良，但是其设计复杂，对于爱好者来说是个比较大的问题。本工具旨在为爱好者提供一个成熟的计算平台以及计算工具，为爱好者提供方便。

计算工具以Microsoft Excel为架构，具体计算方法参见我的另一帖子，链接如下。

XXXXXXXXXXXXXXXXXXXXXXXX/t/84892

软件界面

使用说明：打开软件，左半部分是数据输入区。在输入燃料数据和发动机数据之后，摁下回车按钮，即可自动开始计算。

笔者以设计推力200N，室压10MPa，出口压力0.1MPa进行设计。摁下回车键后，在下方出现质量流量、出口马赫数、扩张比等必要的数据，在设计时参考。

右半部分为塞式喷管型面的数据输出部分。

这一串数据和上面的数据对应原帖中的8个公式。在计算L（膨胀波长度）时采用分段计算的方法。

如图，跑出来的是一长串的数据，在实际使用时只需要看3行用彩色字体标出的数据即可，其余数据只是为了方便计算，可以忽略。后面的3列重复数据是计算机制产生的正常现象，不影响正常使用，在实际建模时只用看其中的一个数据即可。

下面是软件，请大家自行下载使用。

塞式计算工具.xls 39.50KB XLS 335次下载

[修改于 5 年前 - 2019/12/15 12:00:51]

22

已屏蔽原因：{{ notice.reason }}已屏蔽

屏蔽解除屏蔽编辑详情

{{notice.noticeContent}}

~~空空如也

置顶回复

LS

百炼成钢

作者

5年0个月前 IP:广东

867771

18楼

补充：亲测，使用手机WPS软件，完美打开使用。

百炼成钢

作者

5年1个月前 IP:广东

867444

1楼

大家可以把软件使用时出现的问题回复在下面，我会加以改进。

主体信息

主体类型：个人

所属领域：无

认证方式：手机号

IP归属地：广东

文章分类

内容统计

2021年

3 篇

2020年

2 篇

2019年

3 篇

ID: {{user.uid}}

{{user.username}}

用户已注销

{{user.info.certsName}}

{{user.description}}

{{format("YYYY/MM/DD", user.toc)}}注册，{{fromNow(user.tlv)}}活动

{{user.threadCount - user.disabledThreadsCount}}

{{user.postCount - user.disabledPostsCount}}

学术分

{{user.xsf}}

投诉或举报

加载中...

{{tip}}

请选择违规类型：

{{reason.type}}

空空如也

提交成功！

加载中...

回复

设为精选取消精选

评学术分

鼓励

通过审核

移动文章

加入收藏取消收藏

退修或删除

违规记录

投诉或举报

加入黑名单移除黑名单

查看IP

{{format('YYYY/MM/DD HH:mm:ss', toc)}}

回复

加入收藏取消收藏