{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["ورودی ها","مشخصات فنی","محاسبات  ریل","محاسبات  سیم بکسل","محاسبات دیگر ","Omega","برگه نهايي","برگه نهايي 81","ریلهای راهنما","مساحت کابین & Neq(t)","فلکه هرزگرد","سيم بکسلها","InsCo","Hidden data","Sheet1"],"not_rendered":{"charts":1,"images":57,"macros":1,"external_links":0,"defined_names":220,"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":"ورودی ها","index":0,"n_rows":84,"n_cols":9,"rows_kept":84,"cut":false,"hidden":false,"merged":[[78,0,82,0],[23,2,23,3],[55,2,55,3],[71,1,71,4],[70,0,76,0],[23,0,37,0],[6,0,21,0],[55,0,68,0],[4,2,4,4],[3,2,3,4],[1,2,1,4],[1,0,4,0],[2,2,2,4],[39,0,53,0]]}
[null,null,null,null,null,null,"1A3"]
["مشخصات پروژه","شماره پرونده","223",null,null,null,"223"]
[null,"شناسه ملی آسانسور","9089",null,null,null,"9089"]
[null,"نام شرکت بازرسی","پیام گستر پارس مهر"]
[null,"آدرس و مشخصات پروژه","تهران، خیابان ایران"]
[null,"شرح","واحد","مقدار","پارامتر "]
["مشخصات آسانسور و کابین","کاربری آسانسور","-","مسافری","Lift Type ="]
[null,"تعداد ایستگاه (توقف)","توقف",10,"Stops ="]
[null," طول (ارتفاع) مسیر حرکت","m",28.8,"H ="]
[null,"ظرفیت تعداد مسافر","نفر",10,"Persons =",{"$f":"IF(Passengers_No.=1,\"حداقل بار نامی برای 1 نفر= 100 کیلوگرم \",IF(Passengers_No.=2,\"حداقل بار نامی برای 2 نفر= 180 کیلوگرم \",\"حداقل بار نامی برای \"&Passengers_No.&\" نفر = \"&Passengers_No.*75&\" کیلوگرم \"))","v":"حداقل بار نامی برای 10 نفر = 750 کیلوگرم "},null,{"$f":"IF(AND(Passengers_No.=1,Q<100),1,IF(AND(Passengers_No.=2,Q<180),1,IF(Passengers_No.*75>Q,1,0)))","v":0}]
[null,"ظرفیت بار نامی","Kg",800,"Q ="]
[null,"جرم کابین خالی و اجزای متصل به آن","Kg",800,"P ="]
[null,"عمق کابین","mm",1350,"DX =",1]
[null,"عرض کابین","mm",1400,"DY ="]
[null,"جمع مساحت مفید داخل کابین ","m2",{"$f":"A1.+A2.+A3.","v":1.964},{"$f":"IF(Amin>Atotal,\"Amin > Atotal =\",IF(Amax<Atotal,\"Amax < Atotal =\",\"Atotal =\"))","v":"Atotal ="},null,false]
[null,"سرعت نامی کابین آسانسور","m/s",1.6,"VCar ="]
[null,"عرض بازشو در کابین","mm",750,"DW =",1]
[null,"نوع در کابین","-","اتوبوسی",{"$f":"IF(Door_Type=\"تلسکوپی 2 لنگه\",\"C2R/L\",IF(Door_Type=\"تلسکوپی 3 لنگه\",\"C3R/L\",IF(Door_Type=\"سانترال 2 لنگه\",\"C2C\",IF(Door_Type=\"سانترال 4 لنگه\",\"C4C\",\"C6C\"))))","v":"C6C"},{"$f":"IF(F17=0,\"هیچ دری در نظر گرفته نشده است\",\"تعداد \"&F17&\" در منظور شده است\")","v":"تعداد 1 در منظور شده است"}]
[null,"عمق آستانه جلوی در کابین","mm",60,"DD ="]
[null,"اورهد (ارتفاع بالاسری)","mm",3700,"OH ="]
[null,"عمق چاهك","mm",1400,"Pit ="]
[null,"نوع کفشک های راهنما","-","لغزشی با روغن","Guide Shoe Type ="]
[]
["مشحصات موتور و فلکه کشش","نام سازنده/ نوع موتور آسانسور","Wittur/SG8",null,"Motor Type ="]
[null,"توان نامی خروجی موتور","kw",11,"Wout ="]
[null,"حداکثر بار استاتیکی مجاز روی فلکه کشش","Kg",5000,"CSmax ="]
[null,"جرم سیستم محرکه (موتور) و متعلقات (پایه موتور و..)","Kg",600,"Mgb ="]
[null,"قطر فلكه کششی موتور","mm",400,"Dt =",{"$f":"IF(Dt/dsr<40,\"<-Not Ok-> قطر پولی باید حداقل 40 برابر قطر سیم بکسل باشد\",\"<-OK->\")","v":"<-OK->"},null,null,{"$f":"IF(ISNUMBER(SEARCH(\"Not Ok\",$F28)),1,0)","v":0}]
[null,"قطر فلكه فاصله انداز (تکی مطابق شکل روبرو)","mm",400,"Dp =",{"$f":"IF(G38=TRUE,\"\",IF(dDP/dsr<40,\"<-Not Ok-> قطر پولی باید حداقل 40 برابر قطر سیم بکسل باشد\",\"<-OK->\"))","v":""},null,null,{"$f":"IF(ISNUMBER(SEARCH(\"<-Not Ok->\",$F29)),1,0)","v":0}]
[null,"زاویه شیار فلکه کشش","درجه",25,"γ =",{"$f":"IF(AND(OR(Groove_Type=\"V\",Groove_Type=\"V hardened\"),γ<35),\"<-Error-> برای شیار V شکل، γ باید بیش از 35 باشد\",(IF(AND(Groove_Type=\"V\",Beta=0),\"<-Error-> شیار وی شکل یدون زیر برش باید سخت کاری شده باشد\",\"<-Ok->\")))","v":"<-Ok->"},null,{"$f":"IF(ISNUMBER(SEARCH(\"Error\",$F30)),1,0)","v":0}]
[null,"نوع شیار فلکه کشش",null,"U"]
[null,"سخت کاری شیار",null,true]
[null,"زاویه زیر برش فلکه کشش","درجه",97.2,"β ="]
[null,"راندمان گیربكس","-",1,"ηG ="]
[null,"فاصله افقی بکسلهای کابین و وزنه (شکل روبرو)","mm",700,"RDB ="]
[null,"فاصله عمودی مرکز فلکه کشش تا مرکز فلکه هرزگرد","mm",800,"hP =",null,{"$f":"180+ROUND(2*DEGREES(ATAN((Dt-dDP)/SQRT(lp^2+hP^2))),0)","v":180}]
[null,"تعداد پیچش طناب ها روی فلکه کشش","دور",1,{"$f":"IF(Wr=1, \"پیچش تکی\", \"پیچش دوبل\")","v":"پیچش تکی"},null,{"$f":"IF(hP=\"\",180,ROUND(DEGREES(PI()-ASIN(((lp*(lp^2+hP^2-(Dt/2-dDP/2)^2)^0.5)-hP*(Dt/2-dDP/2))/(lp^2+hP^2))),0))","v":159}]
[null,"زاویه پیچش طنابها روی فلکه کشش","درجه",180,{"$f":"IF(Wr=1,\"α =\",\"α = α1+α2 =\")","v":"α ="},null,true]
[]
["مشحصات ریل، وزنه تعادل و فواصل مرکز جرمها","نوع ریل راهنما",null,"T89/A-B",{"$f":"INDEX(Guide_Rail_Table,Guide_Rail_Type,2)","v":"89-62-16"},null,{"$f":"MATCH(D40,'ریلهای راهنما'!B4:B16,0)","v":6}]
[null,"نوع ترمز ایمنی",null,"تدریجی","Safety gear Type =",{"$f":"IF(AND(VCar>0.63,Safety_gear_Type=\"لحظه ای\"),\"<-Error-> با این سرعت نمیتوان از پاراشوت لحظه‌ای استفاده نمود\",(IF(AND(VCar>1,Safety_gear_Type=\"غلطکی\"),\"<-Error-> با این سرعت نمیتوان از پاراشوت غلطکی استفاده نمود\",\"<-OK->\")))","v":"<-OK->"},null,{"$f":"IF(ISNUMBER(SEARCH(\"Error\",$F41)),1,0)","v":0}]
[null,"بیشترین فاصله بین دو براکت","mm",1800,"l ="]
[null,"فاصله عمودی بین کفشکهای بالا و پایین کابین","mm",3200,"h ="]
[null,"تعداد ریل","ستون",2,"n ="]
[null,"ضریب تعادل وزنه (بالانس)","-",0.42,"q ="]
[null,"نیرو در ریل ناشی از بار تجهیزات جانبی","N",0,"Maux ="]
[null,"فاصله مرکز کابین از ریل راهنما در جهت X","mm",-50,"XC ="]
[null,"فاصله مرکز کابین از ریل راهنما در جهت Y","mm",0,"YC ="]
[null,"فاصله مرکز جرم کاببن از ریل راهنما در جهت X","mm",40,"XP ="]
[null,"فاصله مرکز جرم کابین از ریل راهنما در جهت Y","mm",40,"YP ="]
[null,"فاصله مرکز آویز از ریل راهنما در جهت X","mm",0,"XS ="]
[null,"فاصله مرکزآویز از ریل راهنما در جهت Y","mm",0,"YS ="]
[null,"فاصله در کابین از ریل راهنما در جهت X","mm",1145,"Xi ="]
[null,"فاصله در کابین از ریل راهنما در جهت Y","mm",50,"Yi ="]
[]
["سیم بکسل، کابل و زنجیر جبران","نوع سیم بكسل","G-Wolf F819 W-FE",null,{"$f":"INDEX(Rope_Type_Table,Rope_Type,2)","v":"گوستاو ولف"},{"$f":"INDEX(Rope_Type_Table,Rope_Type,3)","v":"8x19 وارینگتون با مغز کنفی"},{"$f":"MATCH(C56,'سيم بکسلها'!B23:B33,0)","v":2}]
[null,"قطر سیم بكسل","mm",10,"dr =",{"$f":"IF(AND(dsr<8,NOT(Rope_Type=5),NOT(Rope_Type=9),NOT(Rope_Type=11)),\"<-Error-> برای قطر 6 و 6.5 فقط نوع مغز  فولادی مجاز است\",IF(dsr<8,\"<-Not Ok-> قطر سیم بکسل کمتر از 8 میباشد\",\"<-OK->\"))","v":"<-OK->"},null,{"$f":"IF(ISNUMBER(SEARCH(\"Error\",$F57)),1,0)","v":0},{"$f":"IF(ISNUMBER(SEARCH(\"<-Not Ok->\",$F57)),1,0)","v":0}]
[null,"تعداد طناب های تعلیق (سیم بکسل ها)","عدد",4,"ns ="]
[null,"ضریب طناب بندی (سیستم تعلیق)",{"$f":"IF(r.=1,\"1:1\",IF(r.=2,\"2:1\",\"4:1\"))","v":"2:1"},2,"r ="]
[null,"تعداد کابل متحرک (تراول کابل)","عدد",1,"nt ="]
[null,"جرم واحد طول کابل متحرک (تراول کابل)","kg/m",0.45,"MT ="]
[null,"تعداد طناب/ زنجیر جبران ","عدد",0,"nc ="]
[null,"طناب/ زنجیر جبران","-",{"$f":"IF(nc<1,\"ندارد\",\"دارد\")","v":"ندارد"},"Comp",{"$f":"ROUND(nc*mcr/(msr*nS*r.)*100,1)&\"%\"","v":"0%"},0.9]
[null,"جرم واحد طول هر طناب/ زنجیر جبران","kg/m",3.6270000000000002,"mCR =",{"$f":"IF(AND(EN81_=\"1old\",mcr*nc/r.>msr*nS),\"<-Error->در محاسبات قدیم جبران بیش از 100% مجاز نیست \",IF(mcr*nc/r.>msr*nS,\"<-Warning-> وزن زنجیر جبران(ها) بیش از وزن سیم بکسلها است\",\" <-OK-> \"))","v":" <-OK-> "},null,{"$f":"IF(ISNUMBER(SEARCH(\"Error\",$F64)),1,0)","v":0}]
[null,"جرم کاهش‌یافته فلکه‌ی کشش طناب جبران ","kg",0,"mPTD = JPTD/R2 ="]
[null,"جرم وسیله تأمین کشش شامل جرم فلکه‌ها","kg",0,"MComp ="]
[null,"نیروی اصطکاک در چاه سمت کابین","N",200,"FRCar =",{"$f":"IF(FRCar>(1-ηs)*(1-q.)*Q*0.6*9.8,\"<-Error->نیروی اصطکاک سمت کابین بیش ازحد است \",\" <-OK-> \")","v":" <-OK-> "},null,{"$f":"IF(ISNUMBER(SEARCH(\"Error\",$F67)),1,0)","v":0}]
[null,"نیروی اصطکاک در چاه سمت وزنه تعادل","N",100,"FRCwt =",{"$f":"IF(FRCwt>(1-ηs)*(1-q.)*Q*0.3*9.8,\"<-Error->نیروی اصطکاک سمت وزنه بیش ازحد است \",\" <-OK-> \")","v":" <-OK-> "},null,{"$f":"IF(ISNUMBER(SEARCH(\"Error\",$F68)),1,0)","v":0}]
[null,"شتاب ناشی از توقف اضطراری کابین","m/s2",0.5,"a ="]
[]
["مشخصات فلکه‌های هرزگرد","تعداد فلکه‌های با خم معکوس","عدد",0,"Npr =",{"$f":"IF(Npr>(iDPcar+iDPcwt),\"<-Error->  تعداد خم معکوس نمیتواند از تعداد کل پولی های هرزگرد بیشتر باشد\",IF(AND(Wr=2,Npr>0),\"<-Error->   پیچش دوبل نمیتواند خم معکوس داشته باشد\",\"<-OK->\"))","v":"<-OK->"},null,{"$f":"IF(ISNUMBER(SEARCH(\"Error\",$F71)),1,0)","v":0}]
[null,"مشخصات فلکه های هرزگرد"]
[null,"محل قرارگیری فلکه","تعداد","قطر فلکه mm","جنس فلکه "]
[null,"فلکه فاصله انداز سمت کابین (ثابت)",1,400,"پلیمری",{"$f":"IF(AND(iDPcar+iDPcwt<>1,$G$38=FALSE),\"<-Error-> جمعاً یک پولی ثابت باید داشته باشد\",IF(AND(dDPcar/dsr<40,iDPcar>0),\"<-Not Ok-> قطر پولی باید حداقل 40 برابر قطر سیم بکسل باشد\",\"<-OK->\"))","v":"<-OK->"},null,{"$f":"IF(ISNUMBER(SEARCH(\"Error\",$F74)),1,0)","v":0},{"$f":"IF(ISNUMBER(SEARCH(\"<-Not Ok->\",$F74)),1,0)","v":0}]
[null,"فلکه فاصله انداز سمت وزنه تعادل (ثابت)",0,400,"چدنی",{"$f":"IF(AND(iDPcar+iDPcwt<>1,$G$38=FALSE),\"<-Error-> جمعاً یک پولی ثابت باید داشته باشد\",IF(AND(dDPcwt/dsr<40,iDPcwt>0),\"<-Not Ok-> قطر پولی باید حداقل 40 برابر قطر سیم بکسل باشد\",\"<-OK->\"))","v":"<-OK->"},null,0,{"$f":"IF(ISNUMBER(SEARCH(\"<-Not Ok->\",$F75)),1,0)","v":0}]
[null,"فلکه هرزگرد متصل به کابین (متحرک)",2,400,"پلیمری",{"$f":"IF(AND(r.>1,iPcar<1),\"<-Error->  درسیستم 2:1حداقل باید یک پولی داشته باشد\",IF(AND(dPcar/dsr<40,iPcar>0),\"<-Not Ok-> قطر پولی باید حداقل 40 برابر قطر سیم بکسل باشد\",\"<-OK->\"))","v":"<-OK->"},null,0,0]
[null,"فلکه هرزگرد روی وزنه تعادل (متحرک)",1,440,"پلیمری",{"$f":"IF(AND(r.>1,iPcwt<1),\"<-Error->  درسیستم 2:1حداقل باید یک پولی داشته باشد\",IF(AND(dPcwt/dsr<40,iPcwt>0),\"<-Not Ok-> قطر پولی باید حداقل 40 برابر قطر سیم بکسل باشد\",\"<-OK->\"))","v":"<-OK->"},null,0,0]
[]
["درهای کابین","درهای کابین محسوب شده در مساحت مفید","عرض","نوع در کابین","عمق آستانه جلوی در"]
[null,"در اول (جلو)",900,"تلسکوپی 2 لنگه",60,{"$f":"IF(AND(EN81_<>\"1Old\",DoorNo.=0),\"<-Error->در محاسبات جدید حداقل باید یک در منظور شود. \",\" <-OK-> \")","v":" <-OK-> "},null,{"$f":"IF(ISNUMBER(SEARCH(\"Error\",$F80)),1,0)","v":0}]
[null,"در دوم (راست)",800,"تلسکوپی 2 لنگه",60]
[null,"در سوم (عقب)",800,"تلسکوپی 2 لنگه",60]
[null,"در چهارم (چپ)",800,"تلسکوپی 2 لنگه",60]
[null,null,null,null,null,null,null,{"$f":"SUM(H6:H83)","v":0},{"$f":"SUM(I6:I83)","v":0}]

{"sheet":"مشخصات فنی","index":1,"n_rows":45,"n_cols":12,"rows_kept":45,"cut":false,"hidden":false,"merged":[[1,10,1,11],[15,7,15,8],[8,10,8,11],[24,10,24,11],[9,4,9,5],[15,4,15,5],[1,1,1,2],[1,4,1,5],[39,1,39,2],[24,7,24,8],[8,7,8,8],[9,7,9,8],[1,7,1,8],[30,1,30,2],[8,4,8,5],[33,4,33,8],[34,5,34,8],[35,5,35,8],[36,5,36,8],[24,4,24,5],[8,1,8,2],[9,1,9,2],[39,4,39,5],[39,6,39,8],[37,6,37,7],[38,6,38,7],[21,1,21,2]]}
[]
[null,"مشخصات آسانسور",null,null,"درب طبقات",null,null,"سیستم تابلو فرمان",null,null,"تراولینگ کابل"]
[null,"طول حرکت:",{"$f":"H.","v":28.8},null,"نوع درب:",null,null,"نوع سیستم:",null,null,"تولید کننده:"]
[null,"سرعت کند (m/s):",null,null,"پهنای درب (cm):",{"$f":"DW1./10","v":90},null,"نوع تابلو فرمان:",null,null,"نوع :"]
[null,"سرعت تند (نامی) (m/s):",{"$f":"VCar","v":1.6},null,"ارتفاع مفید درب(cm):",null,null,"شماره سریال تابلو فرمان:",null,null,"تعداد رشته ها:"]
[null,null,null,null,"قفل مکانیکی درب:",null,null,"علامت تجاری:",null,null,"اندازه رشته ها:"]
[null,null,null,null,null,null,null,"تولید کننده:"]
[]
[null,"فلکه ها",null,null,"کفشک های راهنما",null,null,"ضربه گیرهای ته چاه",null,null,"سیستم محرکه"]
[null,"کشش",null,null,"کابین",null,null,"ضربه گیر کابین",null,null,"تولیدکننده موتور/گیربکس (درصورت وجود):",{"$f":"Motor_type","v":"Wittur/SG8"}]
[null,"جنس:","چدنی",null,"نوع:",{"$f":"Guide_Shoe_Type","v":"لغزشی با روغن"},null,"نام تولید کننده یا علامت تجاری:",null,null,"شماره سریال:"]
[null,"قطر(cm):",{"$f":"Dt/10","v":40},null,"سازنده:",null,null,"نوع:",null,null,"نوع:"]
[null,"تعداد شیار:",null,null,"جنس کفشک:",null,null,"تعداد:",null,null,"علامت تجاری:"]
[null,"نوع شیار:",{"$f":"Groove_Type","v":"U"},null,"جنس لنت:",null,null,"ظرفیت (kg):",null,null,"استارت در ساعت:"]
[null,"زیر برش:",{"$f":"IF(Beta=0,\"ندارد\",\"دارد\")","v":"دارد"},null,"طول لنت:",null,null,"شماره های سریال:",null,null,"توان نامی:"]
[null,":α (زاویه پیچش طناب فولادی)",{"$f":"Alpha.","v":180},null,"وزنه ",null,null,"ضربه گیر وزنه",null,null,"ولتاژ نامی (V):"]
[null,":β (زاویه شیار)",{"$f":"Beta","v":97.2},null,"نوع:",null,null,"نام تولید کننده یا علامت تجاری:",null,null,"جریان نامی (A):"]
[null,":γ (زاویه شیار)",{"$f":"Gamma","v":25},null,"سازنده:",null,null,"نوع:",null,null,"سرعت دور تند موتور (rpm):"]
[null,"تولید کننده:",null,null,"جنس کفشک:",null,null,"تعداد:",null,null,"سرعت دور کند موتور (rpm):"]
[null,"علامت تجاری:",null,null,"جنس لنت:",null,null,"ظرفیت (kg):",null,null,"نوع گیربکس (درصورت وجود):"]
[null,"شماره سریال:",null,null,"طول لنت:",null,null,"شماره های سریال:",null,null,"سازنده گیربکس (درصورت وجود):"]
[null,"هرزگرد",null,null,null,null,null,null,null,null,"نسبت تبدیل گیربکس (درصورت وجود):"]
[null,"جنس:",{"$f":"'ورودی ها'!E74","v":"پلیمری"},null,null,null,null,null,null,null,"نوع ترمز:"]
[null,"قطر(cm):",{"$f":"dDPcar/10","v":40}]
[null,"تعداد :",{"$f":"SUM('ورودی ها'!C74:C77)","v":4},null," کابین(اتاقک) ",null,null," ترمز ایمنی(پاراشوت) ",null,null,"طنابهای فولادی"]
[null,"توضیحات (در صورتیکه قطر فلکه ها یکسان نیست)",null,null,"عرض(cm):",{"$f":"DY/10","v":140},null,"نام تولید کننده:",null,null,"تولیدکننده:",{"$f":"Rope_Brand","v":"گوستاو ولف"}]
[null,"تولیدکننده:",null,null,"عمق(cm):",{"$f":"DX/10","v":135},null,"علامت تجاری:",null,null,"تعداد:",{"$f":"nS","v":4}]
[null,"علامت تجاری:",null,null,"ارتفاع(cm):",null,null,"نوع پاراشوت:",{"$f":"Safety_gear_Type","v":"تدریجی"},null,"قطر(mm):",{"$f":"dsr","v":10}]
[null,"شماره سریال:",null,null,"وزن تقریبی(kg):",{"$f":"P","v":800},null,"ظرفیت (kg)(P+Q):",null,null,"بافت:",{"$f":"Rope","v":"8x19 وارینگتون با مغز کنفی"}]
[null,null,null,null,"نوع درب کابین:",{"$f":"DT1.","v":"تلسکوپی 2 لنگه"},null,"سرعت درگیری (m/s):",null,null,"وزن(gr/m):",{"$f":"msr*1000","v":350}]
[null,"وزنه تعادل",null,null,"پهنای مفید درب کابین(cm):",{"$f":"DW1./10","v":90},null,"شماره سریال:"]
[null,"ابعاد قاب وزنه(ارتفاع×طول)(cm) ",null,null,"ارتفاع مفید درب کابین(cm):",null,null,"موقعیت نصب در کابین :"]
[null,"اندازه ناودانی:"]
[null,"تعداد وزنه:",null,null,"ریل های راهنما"]
[null,"ابعاد وزنه:",null,null,"تولید کننده:"]
[null,"وزن هر عدد(kg):",null,null,"نوع(روش ساخت):"]
[null,"وزن قاب وزنه(kg):",null,null,"نوع روغنکاری:"]
[null,"وزن کل (قاب وزنه و وزنه ها)(kg):",null,null,"اندازه ریل راهنمای کابین mm:",{"$f":"'ورودی ها'!E40","v":"89-62-16"}," ضخامت تیغه mm:"]
[null,null,null,null,"اندازه ریل راهنمای وزنه mm:",null,"ضخامت تیغه mm:"]
[null,"گاورنر سرعت",null,null,"حداکثر فاصله بین تکیه گاههای ریل(براکت)کابین(cm):",null,{"$f":"'ورودی ها'!D42/10","v":180}]
[null,"نام تولید کننده:"]
[null,"علامت تجاری:"]
[null,"نام تولید کننده:"]
[null,"شماره سریال:"]
[null,"سرعت عملکرد مکانیکی (m/s):"]

{"sheet":"محاسبات  ریل","index":2,"n_rows":128,"n_cols":5,"rows_kept":128,"cut":false,"hidden":false,"merged":[[112,0,112,3],[0,0,0,3],[37,0,37,3],[77,0,77,3]]}
["محاسبات ریل‏های هادی کابین"]
["شرح","واحد","مقدار","پارامتر "]
["داده ها"]
["جرم کابین خالی و اجزای متصل به آن","Kg",{"$f":"P","v":800},"P ="]
["بار نامی","Kg",{"$f":"Q","v":800},"Q ="]
["عمق کابین","mm",{"$f":"DX","v":1350},"DX ="]
["عرض کابین","mm",{"$f":"DY","v":1400},"DY ="]
["بیشترین فاصله بین دو براکت ","mm",{"$f":"L","v":1800},"l ="]
["فاصله بین کفشکهای کابین","mm",{"$f":"h","v":3200},"h ="]
["تعداد ریل","ستون",{"$f":"n","v":2},"n ="]
["نیرو در ریل ناشی از بار تجهیزات جانبی","N",{"$f":"Maux","v":0},"Maux ="]
["فاصله مرکز کابین نسبت به ریل راهنما در جهت X","mm",{"$f":"XC","v":-50},"XC ="]
["فاصله مرکز کابین نسبت به ریل راهنما در جهت Y","mm",{"$f":"YC","v":0},"YC ="]
["فاصله مرکز جرم کاببن  از ریل راهنما در جهت X","mm",{"$f":"XP","v":40},"XP ="]
["فاصله مرکز جرم کابین  از ریل راهنما در جهت Y","mm",{"$f":"YP","v":40},"YP ="]
["فاصله مرکز آویز نسبت به ریل راهنما در جهت X","mm",{"$f":"XS","v":0},"XS ="]
["فاصله مرکز آویز  نسبت به ریل راهنما در جهت Y","mm",{"$f":"YS","v":0},"YS ="]
["فاصله در کابین سبت به ریل راهنما در جهت X","mm",{"$f":"Xi","v":1145},"Xi ="]
["فاصله در کابین سبت به ریل راهنما در جهت Y","mm",{"$f":"Yi","v":50},"Yi ="]
["ضریب ضربه در هنگام پاراشوت","-",{"$f":"IF(Safety_gear_Type=\"تدریجی\", 2,IF(Safety_gear_Type=\"غلطکی\",3,5))","v":2},"K1 ="]
["ضریب ضربه در حالت حرکت","-",1.2,"K2 ="]
["ضریب ضربه قطعات کمکی","-",2,"K3 ="]
["مدول کشسانی","N/mm2",210000,"E ="]
["نیروی روی درگاه","N ",{"$f":"IF(Q<2500,0.4*gn*Q,IF(Lift_Type=\"مسافری\",0.6*gn*Q,0.85*gn*Q))","v":3139.2000000000003},"Fs ="]
["شتاب جاذبه زمین","m/s2",{"$f":"gn","v":9.81},"gn ="]
["نوع ریل راهنمای کابین","mm",{"$f":"INDEX(Guide_Rail_Table,Guide_Rail_Type,2)","v":"89-62-16"},{"$f":"INDEX(Guide_Rail_Table,Guide_Rail_Type,1)","v":"T89/A-B"}]
["سطح مقطع یک ریل کابین","mm2",{"$f":"INDEX(Guide_Rail_Table,Guide_Rail_Type,3)*100","v":1570},"A ="]
["وزن واحد طول ریل کابین","Kg/m",{"$f":"INDEX(Guide_Rail_Table,Guide_Rail_Type,4)","v":12.3},"mg ="]
["عرض قسمت اتصال دهنده پایه به تیغه ریل","mm",{"$f":"INDEX(Guide_Rail_Table,Guide_Rail_Type,5)","v":10},"c ="]
["ممان دوم اینرسی","mm4",{"$f":"INDEX(Guide_Rail_Table,Guide_Rail_Type,6)*10000","v":595200},"Ix ="]
["ممان دوم اینرسی","mm4",{"$f":"INDEX(Guide_Rail_Table,Guide_Rail_Type,9)*10000","v":524000},"Iy ="]
["مدول سطح مقطع عرضی","mm3",{"$f":"INDEX(Guide_Rail_Table,Guide_Rail_Type,7)*1000","v":14250},"Wx ="]
["مدول سطح مقطع عرضی","mm3",{"$f":"INDEX(Guide_Rail_Table,Guide_Rail_Type,10)*1000","v":11800},"Wy ="]
["حداقل شعاع ژیراسیون","mm",{"$f":"INDEX(Guide_Rail_Table,Guide_Rail_Type,12)*10","v":18.3},"i ="]
["ضریب لاغری","-",{"$f":"L/i","v":98.360655737704917},"λ = l/i ="]
["ضریب کمانش","-",{"$f":"VLOOKUP(λ,Omega!$A$3:$L$25,2+INT(λ-INT(λ/10)*10))+(VLOOKUP(INT(λ)+1,Omega!$A$3:$L$25,2+INT(λ+1-INT((λ+1)/10)*10))-VLOOKUP(λ,Omega!$A$3:$L$25,2+INT(λ-INT(λ/10)*10)))*(λ-INT(λ))","v":1.8672131147540985}," (از جدول) ω ="]
[]
["حالت اول: عملکرد ترمز ایمنی (پاراشوت)"]
["کمانش"]
["نیروی کمانش","N",{"$f":"K1.*gn*(Q+P)/n","v":15696},"Fk = k1*gn*(Q+P)/n ="]
["تنش کمانشی","N/mm2",{"$f":"(Fk+(K3.*Maux))*ω/A","v":18.667373916675366},"σk = (Fk+K3.M)*ω/A ="]
["توریع بار در جهت محور X (جلو یا عقب کابین)"]
["تنش خمشی"]
["`","N",{"$f":"IF(E44>E45,E44,E45)","v":438.38437499999998},"Fx = K1*gn*(|Q*(Xc±Dx/8)+p*Xp|)/(n*h) =",{"$f":"K1.*gn*ABS(Q*(XC+DX/8)+P*XP)/(n*h)","v":389.33437500000002}]
[null,"N.mm",{"$f":"3*C44*L/16","v":147954.72656249997},"My = 3Fx*L/16 =",{"$f":"K1.*gn*ABS(Q*(XC-DX/8)+P*XP)/(n*h)","v":438.38437499999998}]
[null,"N/mm2",{"$f":"C45/Wy","v":12.538536149364404},"σy = My/Wy ="]
[null,"N",{"$f":"K1.*gn*ABS(Q*YC+P*YP)/(n/2*h)","v":196.2},"Fy = K1*gn*(|Q*Yc+p*Yp|)/(n/2*h) ="]
[null,"N.mm",{"$f":"3*C47*L/16","v":66217.499999999985},"Mx = 3Fy*l/16 ="]
[null,"N/mm2",{"$f":"C48/Wx","v":4.6468421052631568},"σx = Mx/Wx ="]
["تنش مرکب"]
[{"$f":"205-C51","v":187.81462174537245},"N/mm2",{"$f":"C49+C46","v":17.185378254627562},"σm = σx+σy ="]
[{"$f":"205-C52","v":177.81716951607308},"N/mm2",{"$f":"C51+(Fk+(K3.*Maux))/A","v":27.182830483926924},"σ = σm+(Fk+K3*Maux)/A ="]
[{"$f":"205-C53","v":170.86578565415982},"N/mm2",{"$f":"(C51*0.9)+σk","v":34.134214345840171},"σc = σk+0.9σm ="]
["خمش فلانچ"]
[{"$f":"205-C55","v":196.8898890625},"N/mm2",{"$f":"1.85*C44/c.^2","v":8.1101109375},"σF = 1.85*Fx/c^2 ="]
["خیز ها"]
[{"$f":"5-C57","v":4.6611723819179387},"mm",{"$f":"0.7*C44*L^3/(48*E*Iy)","v":0.33882761808206108},"δx = 0.7*Fx*L^3/(48*E*Iy) ="]
[{"$f":"5-C58","v":4.8664969758064514},"mm",{"$f":"0.7*C47*L^3/(48*E*Ix)","v":0.13350302419354837},"δy = 0.7*FyL^3/(48*E*Ix) ="]
[]
["توریع بار در جهت محور Y (چپ یا راست کابین)",null,null,"`"]
["تنش خمشی"]
[null,"N",{"$f":"K1.*gn*ABS(Q*XC+P*XP)/(n*h)","v":24.524999999999999},"Fx = K1*gn*(|Q*Xc+p*Xp|)/(n*h) ="]
[null,"N.mm",{"$f":"3*C62*L/16","v":8277.1874999999982},"My = 3Fx*L/16 ="]
[null,"N/mm2",{"$f":"C63/Wy","v":0.70145656779661003},"σy = My/Wy ="]
[null,"N",{"$f":"IF(E65>E66,E65,E66)","v":1054.575},"Fy = K1*gn*(|Q*(Yc±Dy/8)+p*Yp|)/(n/2*h) =",{"$f":"K1.*gn*ABS(Q*(YC+DY/8)+P*YP)/(n/2*h)","v":1054.575}]
[null,"N.mm",{"$f":"3*C65*L/16","v":355919.06250000006},"Mx = 3Fy*l/16 =",{"$f":"K1.*gn*ABS(Q*(YC-DY/8)+P*YP)/(n/2*h)","v":662.17499999999995}]
[null,"N/mm2",{"$f":"C66/Wx","v":24.976776315789479},"σx = Mx/Wx ="]
["تنش مرکب"]
[{"$f":"205-C69","v":179.32176711641392},"N/mm2",{"$f":"C67+C64","v":25.678232883586091},"σm = σx+σy ="]
[{"$f":"205-C70","v":169.32431488711455},"N/mm2",{"$f":"C69+(Fk+(K3.*Maux))/A","v":35.675685112885454},"σ = σm+(Fk+K3*Maux)/A ="]
[{"$f":"205-C71","v":163.22221648809716},"N/mm2",{"$f":"(C69*0.9)+σk","v":41.777783511902854},"σc = σk+0.9*σm ="]
["خمش فلانچ"]
[{"$f":"205-C73","v":204.54628750000001},"N/mm2",{"$f":"1.85*C62/c.^2","v":0.45371249999999996},"σF = 1.85*Fx/c^2 ="]
["خیز ها"]
[{"$f":"5-C75","v":4.9810446087786255},"mm",{"$f":"0.7*C62*L^3/(48*E*Iy)","v":1.8955391221374043E-2},"δx = 0.7*Fx*L^3/(48*E*Iy) ="]
[{"$f":"5-C76","v":4.2824212449596777},"mm",{"$f":"0.7*C65*L^3/(48*E*Ix)","v":0.71757875504032254},"δy = 0.7*FyL^3/(48*E*Ix) ="]
[]
["حالت دوم: استفاده عادی، در حالت حرکت "]
["توریع بار در جهت محور X (جلو یا عقب کابین)"]
["تنش خمشی"]
[null,"N",{"$f":"IF(E81>E82,E81,E82)","v":263.03062499999999},"Fx = K2*gn*(|Q*(Xc±Dx/8-Xs)+P*(Xp-Xs)|)/(n*h) =",{"$f":"K2.*gn*ABS(Q*(XC+DX/8-XS)+P*(XP-XS))/(n*h)","v":233.60062500000001}]
[null,"N.mm",{"$f":"3*C81*L/16","v":88772.8359375},"My = 3Fx*L/16 =",{"$f":"K2.*gn*ABS(Q*(XC-DX/8-XS)+P*(XP-XS))/(n*h)","v":263.03062499999999}]
[null,"N/mm2",{"$f":"C82/Wy","v":7.5231216896186437},"σy = My/Wy ="]
[null,"N",{"$f":"K2.*gn*ABS(Q*(YC-YS)+P*(YP-YS))/(n/2*h)","v":117.72},"Fy = K2*gn*(|Q*(Yc-Ys)+P*(Yp-Ys)|)/(n/2*h) ="]
[null,"N.mm",{"$f":"3*C84*L/16","v":39730.5},"Mx = 3Fy*l/16 ="]
[null,"N/mm2",{"$f":"C85/Wx","v":2.7881052631578949},"σx = Mx/Wx ="]
["تنش مرکب"]
[{"$f":"165-C88","v":154.68877304722346},"N/mm2",{"$f":"C86+C83","v":10.311226952776538},"σm = σx+σy ="]
[{"$f":"165-C89","v":154.68877304722346},"N/mm2",{"$f":"C88+(K3.*Maux)/A","v":10.311226952776538},"σ = σm+(K3*Maux)/A ="]
["خمش فلانچ"]
[{"$f":"165-C91","v":160.13393343749999},"N/mm2",{"$f":"1.85*C81/c.^2","v":4.8660665625000004},"σF = 1.85*Fx/c^2 ="]
["خیز ها"]
[{"$f":"5-C93","v":4.7967034291507638},"mm",{"$f":"0.7*C81*L^3/(48*E*Iy)","v":0.20329657084923661},"δx = 0.7*Fx*L^3/(48*E*Iy) ="]
[{"$f":"5-C94","v":4.9198981854838708},"mm",{"$f":"0.7*C84*L^3/(48*E*Ix)","v":8.0101814516129036E-2},"δy = 0.7*FyL^3/(48*E*Ix) ="]
[]
["توریع بار در جهت محور Y (چپ یا راست کابین)"]
["تنش خمشی"]
[null,"N",{"$f":"K2.*gn*ABS(Q*(XC-XS)+P*(XP-XS))/(n*h)","v":14.715},"Fx = K2*gn*(|Q*(Xc-Xs)+P*(Xp-Xs)|)/(n*h) ="]
[null,"N.mm",{"$f":"3*C98*L/16","v":4966.3125},"My = 3Fx*L/16 ="]
[null,"N/mm2",{"$f":"C99/Wy","v":0.42087394067796607},"σy = My/Wy ="]
[null,"N",{"$f":"IF(E101>E102,E101,E102)","v":632.745},"Fy = K2*gn*(|Q*(Yc±Dy/8-Ys)+P*(Yp-Ys)|)/(n/2*h) =",{"$f":"K2.*gn*ABS(Q*(YC+DY/8-YS)+P*(YP-YS))/(n/2*h)","v":632.745}]
[null,"N.mm",{"$f":"3*C101*L/16","v":213551.4375},"Mx = 3Fy*l/16 =",{"$f":"K2.*gn*ABS(Q*(YC-DY/8-YS)+P*(YP-YS))/(n/2*h)","v":397.30500000000001}]
[null,"N/mm2",{"$f":"C102/Wx","v":14.986065789473685},"σx = Mx/Wx ="]
["تنش مرکب"]
[{"$f":"165-C105","v":149.59306026984834},"N/mm2",{"$f":"C103+C100","v":15.406939730151651},"σm = σx+σy ="]
[{"$f":"165-C106","v":149.59306026984834},"N/mm2",{"$f":"C105+(K3.*Maux)/A","v":15.406939730151651},"σ = σm+(K3*Maux)/A ="]
["خمش فلانچ"]
[{"$f":"165-C108","v":164.72777249999999},"N/mm2",{"$f":"1.85*C98/c.^2","v":0.27222750000000001},"σF = 1.85*Fx/c^2 ="]
["خیز ها"]
[{"$f":"5-C110","v":4.9886267652671759},"mm",{"$f":"0.7*C98*L^3/(48*E*Iy)","v":1.1373234732824427E-2},"δx = 0.7*Fx*L^3/(48*E*Iy) ="]
[{"$f":"5-C111","v":4.5694527469758066},"mm",{"$f":"0.7*C101*L^3/(48*E*Ix)","v":0.43054725302419355},"δy = 0.7*FyL^3/(48*E*Ix) ="]
[]
["حالت سوم: استفاده عادی در حال بارگیری"]
["تنش خمشی"]
[null,"N",{"$f":"ABS(P*gn*(XP-XS)+Fs*(Xi-XS))/(n*h)","v":610.67250000000013},"Fx=(|P*gn*(Xp-Xs)+Fs*(Xi-Xs)|)/(n*h) ="]
[null,"N.mm",{"$f":"3*C115*L/16","v":206101.96875000003},"My = 3Fx*L/16 ="]
[null,"N/mm2",{"$f":"C116/Wy","v":17.466268538135594},"σy = My/Wy ="]
[null,"N",{"$f":"ABS(P*gn*(YP-YS)+Fs*(Yi-YS))/((C10/2)*C9)","v":147.15},"Fy=(|P*gn*(Yp-Ys)+Fs*(Yi-Ys)|)/(n/2*h) ="]
[null,"N.mm",{"$f":"3*C118*L/16","v":49663.125000000007},"Mx = 3Fy*l/16 ="]
[null,"N/mm2",{"$f":"C119/Wx","v":3.4851315789473691},"σx = Mx/Wx ="]
["تنش مرکب"]
[{"$f":"165-C122","v":144.04859988291705},"N/mm2",{"$f":"C120+C117","v":20.951400117082962},"σm = σx+σy ="]
[{"$f":"165-C123","v":144.04859988291705},"N/mm2",{"$f":"C122+(K3.*Maux)/A","v":20.951400117082962},"σ = σm+(K3*Maux)/A ="]
["خمش فلانچ"]
[{"$f":"165-C125","v":153.70255875000001},"N/mm2",{"$f":"1.85*C115/c.^2","v":11.297441250000004},"σF = 1.85*Fx/c^2 ="]
["خیز ها"]
[{"$f":"5-C127","v":4.5280107585877865},"mm",{"$f":"0.7*C115*L^3/(48*E*Iy)","v":0.47198924141221382},"δx = 0.7*Fx*L^3/(48*E*Iy) ="]
[{"$f":"5-C128","v":4.8998727318548383},"mm",{"$f":"0.7*C118*L^3/(48*E*Ix)","v":0.10012726814516129},"δy = 0.7*FyL^3/(48*E*Ix) ="]

{"sheet":"محاسبات  سیم بکسل","index":3,"n_rows":119,"n_cols":4,"rows_kept":119,"cut":false,"hidden":false,"merged":[[114,0,114,3],[99,0,99,3],[98,0,98,3],[0,0,0,3],[18,0,18,3],[52,0,52,3],[67,0,67,3],[36,0,36,3],[51,0,51,3],[68,0,68,3],[84,0,84,3],[85,0,85,3],[61,0,61,1],[55,0,55,1],[71,0,71,1],[77,0,77,1]]}
["محاسبات کشش سیم بکسل‌ها"]
["شرح","واحد","مقدار","پارامتر "]
["داده ها"]
["جرم واحد طول طناب/ زنجیر جبران","kg/m",{"$f":"IF(nc=0,0,mcr)","v":0},"mCR ="]
["جرم واحد طول طناب تعلیق (سیم بکسل)","kg/m",{"$f":"IF(Rope_Brand=\"انواع دیگر\",VLOOKUP(dsr,Rope_Data_Table,2),VLOOKUP(dsr,Rope_Data_Table,Rope_Type*2))","v":0.35},"mSR ="]
["حداقل بار گسیختگی طناب تعلیق (سیم بکسل)","KN",{"$f":"IF(Rope_Brand=\"انواع دیگر\",VLOOKUP(dsr,Rope_Data_Table,3)*0.97,VLOOKUP(dsr,Rope_Data_Table,Rope_Type*2+1))","v":50},"FSR_min ="]
["سرعت سیم بکسل","m/s",{"$f":"Vsr","v":3.2},"Vsr ="]
["جرم کاهش‌یافته فلکه(های) فاصله انداز (سمت کابین)","kg",{"$f":"IF('ورودی ها'!E74=\"پلیمری\",HLOOKUP(dDPcar,PulleyReducedMass,(nS-1),TRUE)*iDPcar*Wr/5,HLOOKUP(dDPcar,PulleyReducedMass,(nS-1),TRUE)*iDPcar*Wr)","v":3.2},"mDPcar = (JDP/R2)*iDPcar ="]
["جرم کاهش‌یافته فلکه(های) فاصله انداز (سمت طبقه)","kg",{"$f":"IF('ورودی ها'!E75=\"پلیمری\",HLOOKUP(dDPcwt,PulleyReducedMass,(nS-1),TRUE)*iDPcwt*Wr/5,HLOOKUP(dDPcwt,PulleyReducedMass,(nS-1),TRUE)*iDPcwt*Wr)","v":0},"mDPcwt = (JDP/R2)*iDPcwt ="]
["مجموع جرم کاهش‌یافته فلکه(های) متصل به کابین","kg",{"$f":"IF('ورودی ها'!E76=\"پلیمری\",HLOOKUP(dPcar,PulleyReducedMass,nS-1,TRUE)*iPcar/5,HLOOKUP(dPcar,PulleyReducedMass,nS-1,TRUE)*iPcar)","v":6.4},"mPcar*iPcar = (JPcar/R2)*iPcar ="]
["مجموع جرم کاهش‌یافته فلکه(های) روی وزنه تعادلی","kg",{"$f":"IF('ورودی ها'!E77=\"پلیمری\",HLOOKUP(dPcwt,PulleyReducedMass,nS-1,TRUE)*iPcwt/5,HLOOKUP(dPcwt,PulleyReducedMass,nS-1,TRUE)*iPcwt)","v":5},"mPcwt *iPcwt= (JPcwt/R2) *iPcwt="]
["جرم کاهش‌یافته فلکه(های) کشش طناب جبران ","kg",{"$f":"IF(Comp=\"ندارد\",0,mPTD)","v":0},"mPTD = JPTD/R2 ="]
["جرم وسیله تأمین کشش شامل جرم فلکه‌ها","kg",{"$f":"IF(Comp=\"ندارد\",0,MComp)","v":0},"MComp ="]
["جرم موثر طناب های تعلیق در یک سمت ","kg",{"$f":"H.*nS*msr","v":40.32},"MSR = H*nS*mSR ="]
["جرم موثر طناب/ زنجیر جبران در یک سمت","kg",{"$f":"H.*nc*mcr","v":0},"MCR = H*nC*mCR ="]
["جرم موثر کابل متحرک (تراول کابل)","kg",{"$f":"0.5*H.*mt*nt","v":6.48},"MTrav = 0.5*H*nt*mTr ="]
["جرم وزنه تعادلی-کششی شامل جرم فلکه‌ها ","kg",{"$f":"P+q.*Q+MTrav/2","v":1139.24},"MCwt = P+q.Q+MTrav/2 ="]
[]
["محاسبه زاویه پیچش و اصطکاک ها"]
["نوع شیار فلکه کشش",null,{"$f":"Groove_Type","v":"U"},"شکل"]
["زیر برش ",null,{"$f":"IF(β.=0,\"ندارد\", \"دارد\")","v":"دارد"}]
["سخت کاری",null,{"$f":"IF(Groove_Type=\"V hardened\",\"سخت شده\",IF(Groove_Type=\"V\",\"سخت نشده\",\"-\"))","v":"-"}]
["فاصله افقی مرکز فلکه کششی تا مرکز پولی هرزگرد","mm",{"$f":"IF(hP=\"\",\"\",RDB-(Dt+dDP)/2)","v":300},"lp ="]
["فاصله عمودی مرکز فلکه کششی تا مرکز فلکه هرزگرد","mm",{"$f":"IF(hP=\"\",\"\",hP)","v":800},"hP ="]
["زاویه پیچش طناب ها بر روی فلکه کششی","رادیان",{"$f":"RADIANS(α.)","v":3.1415926535897931},{"$f":"IF(iDPcar+iDPcwt>1,\" برای بیش از یک فلکه فاصله انداز، زاویه آلفا باید بصورت دستی وارد شود\",IF(hP=\"\",\"به صورت دستی α =\",IF(AND(Wr=2,iDPcar+iDPcwt=1),\"α =2π-SIN-1(((lp*(lp^2+hP^2-(Dt/2-Ddp/2)^2)^0.5)-hP*(Dt/2-Ddp/2))/(lp^2+hP^2)) =\",IF(AND(Wr=1,iDPcar+iDPcwt=1),\"α =π-SIN-1(((lp*(lp^2+hP^2-(Dt/2-Ddp/2)^2)^0.5)-hP*(Dt/2-Ddp/2))/(lp^2+hP^2)) =\",\"نیم دور کامل روی فلکه کشش\"))))","v":"α =π-SIN-1(((lp*(lp^2+hP^2-(Dt/2-Ddp/2)^2)^0.5)-hP*(Dt/2-Ddp/2))/(lp^2+hP^2)) ="}]
["زاویه پیچش طناب ها بر روی فلکه کششی","درجه",{"$f":"α.","v":180},"α ="]
["زاویه شیار","رادیان",{"$f":"RADIANS(γ)","v":0.43633231299858238},"γ ="]
["مقدار زاویه زیر برش ","رادیان",{"$f":"RADIANS(β)","v":1.6964600329384885},"β ="]
["سرعت سیم بکسل در سرعت نامی کابین","m/s",{"$f":"VCar*r.","v":3.2},"VSR ="]
["ضریب اصطکاک در حالت بارگذاری با 125% باز","-",0.1,"µ1 ="]
["ضریب اصطکاک در حالت توقف اضطراری","-",{"$f":"0.1/(1+Vsr/10)","v":7.575757575757576E-2},"µ2 = 0.1/(1+VSR/10) ="]
["ضریب اصطکاک در حالت کابین گیر کرده","-",0.2,"µ3 ="]
["عامل اصطکاک در حالت بارگذاری با 125% بار","-",{"$f":"IF(Groove_Type=\"U\",µ1*4*(COS(γ./2)-SIN(β./2))/(PI()-β.-γ.-SIN(β.)+SIN(γ.)),IF(Hardened=FALSE,µ1*4*(1-SIN(β./2))/(PI()-β.-SIN(β.)),µ1/SIN(γ./2)))","v":0.20594850528275138},{"$f":"IF(Groove_Type=\"U\",\"f1 =μ1*4*(Cos(γ/2)-Sin(β/2))/(π-β-γ-Sin(β)+Sin(γ)) =\",IF(Hardened=TRUE,\"f1 = μ1/Sin(γ/2)) =\",\"f1 =μ1*4*(1-Sin(β/2))/(π-β-Sin(β)) =\"))","v":"f1 =μ1*4*(Cos(γ/2)-Sin(β/2))/(π-β-γ-Sin(β)+Sin(γ)) ="}]
["عامل اصطکاک در حالت توقف اضطراری","-",{"$f":"IF(Groove_Type=\"U\",µ2*4*(COS(γ./2)-SIN(β./2))/(PI()-β.-γ.-SIN(β.)+SIN(γ.)),IF(Hardened=FALSE,µ2*4*(1-SIN(β./2))/(PI()-β.-SIN(β.)),µ2/SIN(γ./2)))","v":0.15602159491117529},{"$f":"IF(Groove_Type=\"U\",\"f2 =μ2*4*(Cos(γ/2)-Sin(β/2))/(π-β-γ-Sin(β)+Sin(γ)) =\",IF(Hardened=TRUE,\"f2 = μ2/Sin(γ/2)) =\",\"f2 = μ2*4*(1-Sin(β/2))/(π-β-Sin(β)) =\"))","v":"f2 =μ2*4*(Cos(γ/2)-Sin(β/2))/(π-β-γ-Sin(β)+Sin(γ)) ="}]
["عامل اصطکاک در حالت کابین گیر کرده ","-",{"$f":"IF(Groove_Type=\"U\",µ3*4*(COS(γ./2)-SIN(β./2))/(PI()-β.-γ.-SIN(β.)+SIN(γ.)),µ3/SIN(γ./2))","v":0.41189701056550276},{"$f":"IF(Groove_Type=\"U\",\"f3 =μ3*4*(Cos(γ/2)-Sin(β/2))/(π-β-γ-Sin(β)+Sin(γ)) =\",\"f3 = μ3/Sin(γ/2)) =\")","v":"f3 =μ3*4*(Cos(γ/2)-Sin(β/2))/(π-β-γ-Sin(β)+Sin(γ)) ="}]
[]
["حالت اول: بارگیری کابین با 125% بار نامی"]
["شتاب کابین","m/s2",0,"a ="]
["بار داخل کابین","kg",{"$f":"1.25*Q","v":1000},"Q1 =1.25*Q ="]
["در پایین ترین طبقه"]
["موقعیت کابین از نیمه مسیر","m",{"$f":"-H./2","v":-14.4},"y1 ="]
["T1","N",{"$f":"(P+Q1.)*gn/r.+MComp*gn/(2*r.)+MSR.*gn-FRCar/r.","v":9124.5391999999993},"T1=(P+1.25*Q).gn/r+MComp.gn/(2.r) +MSR.gn-FRcar/r ="]
["T2","N",{"$f":"(Mcwt+MCR.)*gn/r.+MComp*gn/(2*r.)+FRCwt/r.","v":5637.9722000000002},"T2=(Mcwt+MCR).gn/r+MComp.gn/(2.r)+FRcwt/r ="]
[null,null,{"$f":"EXP(f1.*α)","v":1.9098148710596015},"e^(f1.α) ="]
[{"$f":"C44-C45","v":0.29140689097059025},null,{"$f":"C42/C43","v":1.6184079800890112},"T1/T2 ="]
["در بالا ترین طبقه"]
["موقعیت کابین از نیمه مسیر","m",{"$f":"H./2","v":14.4},"y2 ="]
["T1","N",{"$f":"(P+Q1.+MCR.+MTrav)*gn/r.+MComp*gn/(2*r.)-FRCar/r.","v":8760.7844000000005},"T1=(P+1.25*Q+MCR+MTrav).gn/r+MComp.gn/(2.r)-FRcar/r ="]
["T2","N",{"$f":"Mcwt*gn/r.+MComp*gn/(2*r.)+MSR.*gn+FRCwt/r.","v":6033.5114000000003},"T2=Mcwt.gn/r+MComp.gn/(2.r)+MSR.gn+FRcwt/r ="]
[null,null,{"$f":"EXP(f1.*α)","v":1.9098148710596015},"e^(f1.α) ="]
[{"$f":"C50-C51","v":0.45779401302326783},null,{"$f":"C48/C49","v":1.4520208580363336},"T1/T2 ="]
[]
["حالت دوم: توقف اضطراری کابین بدون بار (خالی)"]
["شتاب کابین","m/s2",{"$f":"a.","v":0.5},"a ="]
["بار داخل کابین","kg",{"$f":"0*Q","v":0},"Q2 =0.0*Q ="]
["توقف کابین خالی هنگام حرکت به سمت بالا در پایین ترین طبقه"]
["موقعیت کابین از نیمه مسیر","m",{"$f":"y1.","v":-14.4},"y1 ="]
["T1","N",{"$f":"(Mcwt+MCR.)*(gn+a.)/r.+MComp*gn/(2*r.)+(mPTD*a./r.)+(mDPcwt*r.*a.)+mPcwt*a.-FRCwt/r.","v":5825.2822000000006},"T1=(Mcwt+MCR).(gn+a)/r+MComp.gn/(2.r)+(mPTD.a/r)+(mDPcwt.r.a)+(mPcwt.iPcwt.a)-FRcwt/r ="]
["T2","N",{"$f":"P*(gn-a.)/r.+MComp*gn/(2*r.)+MSR.*(gn-r.*a.)-(mPTD*a./r.)-(mDPcar*r.*a.)-mPcar*a.+FRCar/r.","v":4172.8191999999999},"T2=P.(gn-a)/r+MComp.gn/(2.r)+MSR.(gn-r.a)-(mPTD.a/r)-(mDPcar.r.a)-(mPcar.iPcar.a)+FRcar/r ="]
[null,null,{"$f":"EXP(f2.*α)","v":1.6325713650008902},"e^(f2.α) ="]
[{"$f":"C60-C61","v":0.2365649911805241},null,{"$f":"C58/C59","v":1.3960063738203661},"T1/T2 ="]
["توقف کابین خالی هنگام حرکت به سمت بالا در بالاترین طبقه"]
["موقعیت کابین از نیمه مسیر","m",{"$f":"y2.","v":14.4},"y2 ="]
["T1","N",{"$f":"(Mcwt)*(gn+a.)/r.+MComp*gn/(2*r.)+(mPTD*a./r.)+MSR.*(gn+r.*a.)+(mDPcwt*r.*a.)+mPcwt*a.-FRCwt/r.","v":6261.1414000000004},"T1=Mcwt.(gn+a)/r+MComp.gn/(2.r)+(mPTD.a/r)+MSR.(gn+r.a)+(mDPcwt.r.a)+(mPcwt.iPcwt.a)-FRcwt/r ="]
["T2","N",{"$f":"(P+Q2.+MCR.+MTrav)*(gn-a.)/r.+MComp*gn/(2*r.)-(mPTD.*a./r.)-(mDPcar*r.*a.)-mPcar*a.+FRCar/r.","v":3847.7644000000005},"T2=(P+MCR+MTrav).(gn-a)/r+MComp.gn/(2.r)-(mPTD.a/r)-(mDPcar.r.a)-(mPcar.iPcar.a)+FRcar/r ="]
[null,null,{"$f":"EXP(f2.*α)","v":1.6325713650008902},"e^(f2.α) ="]
[{"$f":"C66-C67","v":5.355987676852525E-3},null,{"$f":"C64/C65","v":1.6272153773240376},"T1/T2 ="]
[]
["حالت سوم: توقف اضطراری کابین با 100% بار نامی"]
["شتاب کابین","m/s2",{"$f":"a.","v":0.5},"a ="]
["بار داخل کابین","kg",{"$f":"1*Q","v":800},"Q3 =1*Q ="]
["توقف کابین پر هنگام حرکت به سمت پایین در پایین ترین طبقه"]
["موقعیت کابین از نیمه مسیر","m",{"$f":"y1.","v":-14.4},"y1 ="]
["T1","N",{"$f":"(P+Q)*(gn+a.)/r.+MComp*gn/(2*r.)+MSR.*(gn+r.*a.)+(mPTD*a./r.)+(mDPcar*r.*a.)+mPcar*a.-FRCar/r.","v":8590.2592000000022},"T1=(P+Q).(gn+a)/r+MComp.gn/(2.r)+MSR.(gn+r.a)+(mPTD.a/r)+(mDPcar.r.a)+(mPcar.iPcar.a)-FRcar/r ="]
["T2","N",{"$f":"(Mcwt+MCR.)*(gn-a.)/r.+MComp*gn/(2*r.)-(mPTD*a./r.)-(mDPcwt*r.*a.)-mPcwt*a.+FRCwt/r.","v":5350.6622000000007},"T2=(Mcwt+MCRcwt).(gn-a)/r+MComp.gn/(2.r)-(mPTD.a/r)-(mDPcwt.r.a)-(mPcwt.iPcwt.a)+FRcwt/r ="]
[null,null,{"$f":"EXP(f2.*α)","v":1.6325713650008902},"e^(f2.α) ="]
[{"$f":"C76-C77","v":2.7114156358565289E-2},null,{"$f":"C74/C75","v":1.6054572086423249},"T1/T2 ="]
["توقف کابین پر هنگام حرکت به سمت پایین در بالا ترین طبقه"]
["موقعیت کابین از نیمه مسیر","m",{"$f":"y2.","v":14.4},"y2 ="]
["جرم واقعی کابل متحرک (تراول کابل)","kg",{"$f":"(0.25*H.+0.5*y2.)*mt*nt","v":6.48},"MTrav ="]
["T1","N",{"$f":"(P+Q+MCR.+MTrav)*(gn+a.)/r.+MComp*gn/(2*r.)+(mPTD.*a./r.)+(mDPcar*r.*a.)+mPcar*a.-FRCar/r.","v":8187.8044000000027},"T1=(P+Q+MCRcar+MTrav).(gn+a)/r+MComp.gn/(2.r)+(mPTD.a/r)+(mDPcar.r.a)+(mPcar.iPcar.a)-FRcar/r ="]
["T2","N",{"$f":"Mcwt*(gn-a.)/r.+MComp*gn/(2*r.)-(mPTD*a./r.)+MSR.*(gn-r.*a.)-(mDPcwt*r.*a.)-mPcwt*a.+FRCwt/r.","v":5705.8814000000002},"T2=Mcwt.(gn-a)/r+MComp.gn/(2.r)+(mPTD.a/r)+MSR .(gn-r.a)-(mDPcwt.r.a)-(mPcwt.iPcwt.a)+FRcwt/r ="]
[null,null,{"$f":"EXP(f2.*α)","v":1.6325713650008902},"e^(f2.α) ="]
[{"$f":"C83-C84","v":0.19759509647908002},null,{"$f":"C81/C82","v":1.4349762685218101},"T1/T2 ="]
[]
["حالت چهارم:  کابین یا وزنه متوقف شده "]
["نشستن وزنه روی بافر، کابین بدون بار در بالا ترین طبقه"]
["موقعیت کابین از نیمه مسیر","m",{"$f":"H./2","v":14.4},"y2 ="]
["T1","N",{"$f":"(P+MCR.+MTrav)*gn/r.+MComp*gn/(2*r.)+FRCar/r.","v":4055.7844000000005},"T1=(P+MCR+MTrav).gn/r+Mcomp.gn/(2.r)+FRcar/r ="]
["T2","N",{"$f":"MSR.*gn","v":395.53920000000005},"T2 = MSR.gn ="]
[null,null,{"$f":"EXP(f3.*α)","v":3.6473928417204022},"e^(f3.α) ="]
[{"$f":"C92-C91","v":6.6064186641935496},null,{"$f":"C89/C90","v":10.253811505913951},"T1/T2 ="]
["نشستن کابین روی بافر، وزنه در بالا"]
["موقعیت کابین از نیمه مسیر","m",{"$f":"-H./2","v":-14.4},"y2 ="]
["T1","N",{"$f":"(Mcwt+MCR.)*gn/r.+MComp*gn/(2*r.)+FRCwt/r.","v":5637.9722000000002},"T1=(MCwt+MCR).gn/r+Mcomp.gn/(2.r)+FRcwt/r ="]
["T2","N",{"$f":"MSR.*gn","v":395.53920000000005},"T2 = MSR.gn ="]
[null,null,{"$f":"EXP(f3.*α)","v":3.6473928417204022},"e^(f3.α) ="]
[{"$f":"C98-C97","v":10.6064970382207},null,{"$f":"C95/C96","v":14.253889879941102},"T1/T2 ="]
[]
["محاسبات ضریب اطمینان سیم بکسل ها"]
["نوع شیار فلکه کشش",null,{"$f":"Groove_Type","v":"U"},"شکل"]
["زاویه شیار","درجه",{"$f":"γ","v":25},"γ ="]
["زاویه زیر برش","درجه",{"$f":"β","v":97.2},"β ="]
["زیر برش ",null,{"$f":"IF(β=0,\"ندارد\", \"دارد\")","v":"دارد"}]
["تعداد فلکه ها با خم معکوس","عدد",{"$f":"Npr","v":0},"Npr ="]
["تعداد فلکه ها با خم ساده","عدد",{"$f":"IF(iPcwt<=iPcar,iDPcar*Wr+iDPcwt*Wr+iPcar-Npr,iDPcar*Wr+iDPcwt*Wr+iPcwt-Npr)","v":3},"Nps ="]
["میانگین قطر همه فلکه های هرز گرد","mm",{"$f":"IF(Npr+Nps=0,\"-\",IF(iPcar>iPcwt,(iDPcar*dDPcar+iDPcwt*dDPcwt+iPcar*dPcar)/(iDPcar+iDPcwt+iPcar),(iDPcar*dDPcar+iDPcwt*dDPcwt+iPcwt*dPcwt)/(iDPcar+iDPcwt+iPcwt)))","v":400},"Dp ="]
["ضریب نسبت بین قطر فلکه کششی و سایر فلکه‌ها","-",{"$f":"IF(Npr+Nps=0,0,(Dt/Dp)^4)","v":1},"Kp=( Dt / Dp )4 ="]
["عدد معادل فلکه‌ی کششی ","-",{"$f":"IF(Groove_Type=\"V hardened\",IF(EN81_=\"20\",Wr*Neqtv50,Wr*Neqtv),Wr*Neqtu)","v":8.2266666666666683},"Nequiv(t) ="]
["عدد معادل فلکه‌های انحرافی","-",{"$f":"Kp*(Nps+4*Npr)","v":3},"Nequiv(p) = Kp × (Nps + 4 × Npr) ="]
["عدد معادل فلکه‌ها","-",{"$f":"Neqt+Neqp","v":11.226666666666668},"Nequiv = Nequiv(t)+Nequiv(p) ="]
["حداقل ضریب اطمینان  مورد نیاز برای سیم بکسل ها","-",{"$f":"IF(10^(2.6834-LOG10(695.85*10^6*Neq/(Dt/dsr)^8.567)/LOG10(77.09*(Dt/dsr)^(-2.895)))<12,12,10^(2.6834-LOG10(695.85*10^6*Neq/(Dt/dsr)^8.567)/LOG10(77.09*(Dt/dsr)^(-2.895))))","v":19.516635745597661},"Sf_min=10^(2.6834-(LOG10(695.85*10^6*Nequiv/ (Dt/dr)^8.567))/(LOG10(77.09*Dt/dr)^(-2.895))) ="]
["نیروی وارد بر هر سیم بکسل","N",{"$f":"((P+Q3.)*gn/r.+MComp*gn/(2*r.)+MSR.*gn)/nS","v":2060.8847999999998}]
["ضریب اطمینان فعلی سیم بکسل ها","-",{"$f":"Fsr_min*1000/C113","v":24.261424025253621},{"$f":"Sf_cur-Sf_min","v":4.7447882796559604}]
[{"$f":"IF(Groove_Type=\"V\",\"کنترل مجدد ضریب اطمینان سیم بکسل، فقط برای شیار V زیر برش دار (بدون سحتکاری) قبل از خورده و تبدیل شدن به شیار U\",\"\")","v":""}]
[{"$f":"IF(Groove_Type=\"V\",\"عدد معادل فلکه‌ی کششی\",\"\")","v":""},null,{"$f":"IF(Groove_Type=\"V\",IF(OR(Groove_Type=\"V hardened\",Groove_Type=\"V\"),IF(EN81_=TRUE,Wr*Neqtv50,Wr*Neqtv),Wr*Neqtu),\"\")","v":""},{"$f":"IF(Groove_Type=\"V\",\"Nequiv(t) =\",\"\")","v":""}]
[{"$f":"IF(Groove_Type=\"V\",\"عدد معادل فلکه‌ها\",\"\")","v":""},null,{"$f":"IF(Groove_Type=\"V\",C116+Neqp,\"\")","v":""},{"$f":"IF(Groove_Type=\"V\",\"Nequiv = Nequiv(t)+Nequiv(p) =\",\"\")","v":""}]
[{"$f":"IF(Groove_Type=\"V\",\"حداقل ضریب اطمینان  مورد نیاز برای سیم بکسل ها\",\"\")","v":""},null,{"$f":"IF(Groove_Type=\"V\",IF(10^(2.6834-LOG10(695.85*10^6*C117/(Dt/dsr)^8.567)/LOG10(77.09*(Dt/dsr)^(-2.895)))<12,12,10^(2.6834-LOG10(695.85*10^6*C117/(Dt/dsr)^8.567)/LOG10(77.09*(Dt/dsr)^(-2.895)))),\"\")","v":""},{"$f":"IF(Groove_Type=\"V\",\"Sf_min=10^(2.6834-(LOG10(695.85*10^6*Nequiv/ (Dt/dr)^8.567))/(LOG10(77.09*Dt/dr)^(-2.895))) =\",\"\")","v":""}]
[{"$f":"IF(Groove_Type=\"V\",\"ضریب اطمینان فعلی سیم بکسل ها\",\"\")","v":""},null,{"$f":"IF(Groove_Type=\"V\",Sf_cur,\"\")","v":""},{"$f":"IF(Groove_Type=\"V\",Sf_cur-C118,\"\")","v":""}]

{"sheet":"محاسبات دیگر ","index":4,"n_rows":41,"n_cols":5,"rows_kept":41,"cut":false,"hidden":false,"merged":[[10,0,10,3],[18,0,18,3],[34,0,34,3]]}
["شرح","واحد","مقدار","پارامتر "]
["داده ها"]
["جرم کابین خالی و اجزای متصل به آن","Kg",{"$f":"P","v":800},"P ="]
["بار نامی","Kg",{"$f":"Q","v":800},"Q ="]
["ظرفیت مسافر","نفر",{"$f":" Passengers_No.","v":10},"Passenger No. ="]
["عمق کابین","mm",{"$f":"DX","v":1350},"DX ="]
["عرض کابین","mm",{"$f":"DY","v":1400},"DY ="]
["تعداد طبقات",null,{"$f":"Stops","v":10},"stops ="]
["شتاب جاذبه زمین","m/s2",9.81,"gn ="]
[]
["محاسبه نیروهای وارد بر کف و سقف چاه"]
["نیروی وارد بر کف چاهک، زیر تکیه‌گاه ضربه‌گیر کابین","N",{"$f":"4*gn*(P+Q)","v":62784},"F1 = 4*gn(P+Q) ="]
["نیروی وارد بر کف چاهک، زیر تکیه‌گاه ضربه‌گیر وزنه","N",{"$f":"4*gn*(P+q.*Q)","v":44576.639999999999},"F2 = 4*gn(P+q.Q) ="]
["وزن قابل تحمل توسط قلاب سقف موتورخانه","Kg",1500,"N ="]
["وزن سیستم محرکه و متعلقات","Kg",{"$f":"Mgb","v":600},"Mgb ="]
["نیروی وارد بر سقف چاه (دال بتونی زیر موتور)","N",{"$f":"((P+Q+Mcwt+MCR.+MComp+r.*MSR.)*K2.+Mgb)*gn","v":39081.627359999999},"F3 = ((P+Q+MCwt+MCR+Mcomp+r.MSR)*K2+Mgb).gn ="]
["نیروی وارد بر کف چاهک، زیر هر ریل کابین","N",{"$f":"H.*gn*mg+Fk+K3.*Maux","v":19171.094400000002},"F4 = H*mg*gn+Fk+k3*Maux="]
[]
["محاسبات موتور و گیربکس"]
["راندمان چاه","-",{"$f":"VLOOKUP(Guide_Shoe_Type,Guide_Shoe_Table,2,FALSE)","v":0.9},"ηS ="]
["راندمان پولی ها","-",{"$f":"1-(iDPcar+iDPcwt+iPcar+iPcwt)*1%","v":0.96},"ηP ="]
["توان خروجی موتور","Kw",{"$f":"Wout","v":11},"Wout ="]
["جرم وزنه تعادل","Kg",{"$f":"Mcwt","v":1139.24},"MCwt = (P+q.Q+MTrav/2) ="]
["حداکثر بار استاتیکی وارد بر محور پولی کشش","Kg",{"$f":"Wr*((P+Q+Mcwt+MCR.+MComp)/r.+MSR.)","v":1409.9399999999998},"Cs  = Wr*((P+Q+MCwt+MCR+Mcomp)/r+MSR )="]
[null,null,null,{"$f":"IF(C24>CsMAX,\"<-Error-> Cs > Csmax\",\"<-OK-> Cs ≤ Csmax\" )","v":"<-OK-> Cs ≤ Csmax"}]
["بار نامتعادل روی موتور، کابین با ظرفیت پر در پایین ","Kg",{"$f":"((P+Q-Mcwt-MCR.)/r.+MSR.)/ηP","v":281.97916666666669},"qm1 = [(P+Q-MCR-MCwt)/r+MSR]/ηP =",{"$f":"MAX(C26:C29)","v":281.97916666666669}]
["بار نامتعادل روی موتور، کابین با ظرفیت پر در بالا ","Kg",{"$f":"((P+Q+MTrav-Mcwt+MCR.)/r.-MSR.)/ηP","v":201.35416666666669},"qm2 = [(P+Q+MTrav+MCR-MCwt)/r-MSR]/ηP ="]
["بار نامتعادل روی موتور، کابین خالی در پایین ","Kg",{"$f":"(-(P-Mcwt-MCR.)/r.-MSR.)/ηP","v":134.68750000000003},"qm3 = [(-P+MCR+MCwt)/r-MSR]/ηP ="]
["بار نامتعادل روی موتور، کابین خالی در بالا ","Kg",{"$f":"(-(P+MTrav-Mcwt+MCR.)/r.+MSR.)/ηP","v":215.3125},"qm4 = [(-P-MTrav-MCR+MCwt)/r+MSR]/ηP ="]
["توان مورد نیاز موتور، کابین پر در میانه مسیر ","Kw",{"$f":"(Q/2+ABS(Q/2-q.*Q))*VCar*gn/1000/ηG/ηs/ηP","v":8.4293333333333358},"Wmid =Q(1+|1-2q|)*Vcar*gn/[2*ηg*ηS*ηP] ="]
[null,null,null,{"$f":"IF(C30>Wout,\"<-Error-> Wmid > Wout\",\"<-OK-> Wmid ≤ Wout\" )","v":"<-OK-> Wmid ≤ Wout"}]
["حداکثر توان مورد نیاز موتور","Kw",{"$f":"(qm*Vsr*gn/1000/ηG/ηs)","v":9.8354333333333344},"Wmax = (qm(max)*VSr*gn)/[ηg*ηS] ="]
[null,null,null,{"$f":"IF(C32>1.2*Wout,\"<-Error-> Wmax > 1.2*Wout\",\"<-OK-> Wmax ≤ 1.2*Wout\" )","v":"<-OK-> Wmax ≤ 1.2*Wout"}]
[]
["محاسبات مساحت داخل کابین"]
["مساحت آستانه جلوی در کابین","m2",{"$f":"A1.","v":5.3999999999999999E-2},"A1 ="]
["مساحت بین لنگه های در کابین","m2",{"$f":"A2.","v":0.02},"A2 ="]
["مساحت داخل کابین","m2",{"$f":"ROUND(DX*DY/1000000,3)","v":1.89},"A3 ="]
["جمع مساحت مفید داخل کابین","m2",{"$f":"Atotal","v":1.964},"Atotal = A1+A2+A3 ="]
["حداقل مساحت مجاز داخل کابین","m2",{"$f":"IF(Passengers_No.>20,3.13+(Passengers_No.-20)*0.115,VLOOKUP(Passengers_No.,Min_Car_Area,2))","v":1.73},{"$f":"Atotal-Amin","v":0.23399999999999999}]
["حداکثر مساحت مجاز داخل کابین","m2",{"$f":"IF(Q>2500, 5+(Q-2500)/100*0.16,VLOOKUP(Q,Max_Car_Area,2)+(VLOOKUP(INDEX(loads,MATCH(Q,loads,1)+1),Max_Car_Area,2)-VLOOKUP(Q,Max_Car_Area,2))*(Q-INDEX(loads,MATCH(Q,loads,1)))/(INDEX(loads,MATCH(Q,loads,1)+1)-INDEX(loads,MATCH(Q,loads,1))))","v":2},{"$f":"Amax-Atotal","v":3.6000000000000032E-2}]

{"sheet":"Omega","index":5,"n_rows":37,"n_cols":25,"rows_kept":37,"cut":false,"hidden":true,"merged":[[0,0,0,11],[0,13,0,24]]}
["“Omega”-value ω related to λ for steel with tensile stress of 370 N/mm2",null,null,null,null,null,null,null,null,null,null,null,null,"“Omega”-value ω related to λ for steel with tensile stress of 520 N/mm2"]
["λ",0,1,2,3,4,5,6,7,8,9,"λ",null,"λ",0,1,2,3,4,5,6,7,8,9,"λ"]
[20,1.04,1.04,1.04,1.05,1.05,1.06,1.06,1.07,1.07,1.08,20,null,20,1.06,1.06,1.07,1.07,1.08,1.08,1.0900000000000001,1.0900000000000001,1.1000000000000001,1.1100000000000001,20]
[30,1.08,1.0900000000000001,1.0900000000000001,1.1000000000000001,1.1000000000000001,1.1100000000000001,1.1100000000000001,1.1200000000000001,1.1299999999999999,1.1299999999999999,30,null,30,1.1100000000000001,1.1200000000000001,1.1200000000000001,1.1299999999999999,1.1399999999999999,1.1499999999999999,1.1499999999999999,1.1599999999999999,1.17,1.18,30]
[40,1.1399999999999999,1.1399999999999999,1.1499999999999999,1.1599999999999999,1.1599999999999999,1.17,1.18,1.19,1.19,1.2,40,null,40,1.19,1.19,1.2,1.21,1.22,1.23,1.24,1.25,1.26,1.27,40]
[50,1.21,1.22,1.23,1.23,1.24,1.25,1.26,1.27,1.28,1.29,50,null,50,1.28,1.3,1.31,1.32,1.33,1.35,1.36,1.37,1.39,1.4,50]
[60,1.3,1.31,1.32,1.33,1.34,1.35,1.36,1.37,1.39,1.4,60,null,60,1.41,1.43,1.44,1.46,1.48,1.49,1.51,1.53,1.54,1.56,60]
[70,1.41,1.42,1.44,1.45,1.46,1.48,1.49,1.5,1.52,1.53,70,null,70,1.58,1.6,1.62,1.64,1.66,1.68,1.7,1.72,1.74,1.77,70]
[80,1.55,1.56,1.58,1.59,1.61,1.62,1.64,1.66,1.68,1.69,80,null,80,1.79,1.81,1.83,1.86,1.88,1.91,1.93,1.95,1.98,2.0099999999999998,80]
[90,1.71,1.73,1.74,1.76,1.78,1.8,1.82,1.84,1.86,1.88,90,null,90,2.0499999999999998,2.1,2.1,2.19,2.2400000000000002,2.29,2.33,2.38,2.4300000000000002,2.48,90]
[100,1.9,1.92,1.94,1.96,1.98,2,2.02,2.0499999999999998,2.0699999999999998,2.09,100,null,100,2.5299999999999998,2.58,2.64,2.69,2.74,2.79,2.85,2.9,2.95,3.01,100]
[110,2.11,2.14,2.16,2.1800000000000002,2.21,2.23,2.27,2.31,2.35,2.39,110,null,110,3.06,3.12,3.18,3.23,3.29,3.35,3.41,3.47,3.53,3.59,110]
[120,2.4300000000000002,2.4700000000000002,2.5099999999999998,2.5499999999999998,2.6,2.64,2.68,2.72,2.77,2.81,120,null,120,3.65,3.71,3.77,3.83,3.89,3.96,4.0199999999999996,4.09,4.1500000000000004,4.22,120]
[130,2.85,2.9,2.94,2.99,3.03,3.08,3.12,3.17,3.22,3.26,130,null,130,4.28,4.3499999999999996,4.41,4.4800000000000004,4.55,4.62,4.6900000000000004,4.75,4.82,4.8899999999999997,130]
[140,3.31,3.36,3.41,3.45,3.5,3.55,3.6,3.65,3.7,3.75,140,null,140,4.96,5.04,5.1100000000000003,5.18,5.25,5.33,5.4,5.47,5.55,5.62,140]
[150,3.8,3.85,3.9,3.95,4,4.0599999999999996,4.1100000000000003,4.16,4.22,4.2699999999999996,150,null,150,5.7,5.78,5.85,5.93,6.01,6.09,6.16,6.24,6.32,6.4,150]
[160,4.32,4.38,4.43,4.49,4.54,4.5999999999999996,4.6500000000000004,4.71,4.7699999999999996,4.82,160,null,160,6.48,6.57,6.65,6.73,6.81,6.9,6.98,7.06,7.15,7.23,160]
[170,4.88,4.9400000000000004,5,5.05,5.1100000000000003,5.17,5.23,5.29,5.35,5.41,170,null,170,7.32,7.41,7.49,7.58,7.67,7.76,7.85,7.94,8.0299999999999994,8.1199999999999992,170]
[180,5.47,5.53,5.59,5.66,5.72,5.78,5.84,5.91,5.97,6.03,180,null,180,8.2100000000000009,8.3000000000000007,8.39,8.48,8.58,8.67,8.76,8.86,8.9499999999999993,9.0500000000000007,180]
[190,6.1,6.16,6.23,6.29,6.36,6.42,6.49,6.55,6.62,6.69,190,null,190,9.14,9.24,9.34,9.44,9.5299999999999994,9.6300000000000008,9.73,9.83,9.93,10.029999999999999,190]
[200,6.75,6.82,6.89,6.96,7.03,7.1,7.17,7.24,7.31,7.38,200,null,200,10.130000000000001,10.23,10.34,10.44,10.54,10.65,10.75,10.85,10.96,11.06,200]
[210,7.45,7.52,7.59,7.66,7.73,7.81,7.88,7.95,8.0299999999999994,8.1,210,null,210,11.17,11.28,11.38,11.49,11.6,11.71,11.82,11.93,12.04,12.15,210]
[220,8.17,8.25,8.32,8.4,8.4700000000000006,8.5500000000000007,8.6300000000000008,8.6999999999999993,8.7799999999999994,8.86,220,null,220,12.26,12.37,12.48,12.6,12.71,12.82,12.94,13.05,13.17,13.28,220]
[230,8.93,9.01,9.09,9.17,9.25,9.33,9.41,9.49,9.57,9.65,230,null,230,13.4,13.52,13.63,13.75,13.87,13.99,14.11,14.23,14.35,14.47,230]
[240,9.73,9.81,9.89,9.9700000000000006,10.050000000000001,10.14,10.220000000000001,10.3,10.39,10.47,240,null,240,14.59,14.71,14.83,14.96,15.08,15.2,15.33,15.45,15.58,15.71,240]
[250,10.55,null,null,null,null,null,null,null,null,null,null,null,250,15.83]
[]
[0.1]
[0.2]
[0.3]
[0.4]
[0.5]
[0.6]
[0.7]
[0.8]
[0.9]
[1]

{"sheet":"برگه نهايي","index":6,"n_rows":70,"n_cols":13,"rows_kept":70,"cut":false,"hidden":false,"merged":[[69,0,69,4],[69,6,69,10],[58,10,64,10],[65,10,68,10],[2,10,11,10],[12,10,30,10],[31,10,44,10],[45,10,51,10],[52,10,57,10],[65,6,65,9],[49,6,49,9],[3,2,3,4],[4,2,4,4],[40,6,40,7],[39,6,39,7],[37,6,37,7],[38,6,38,7],[41,6,41,7],[43,6,43,7],[45,2,45,3],[17,2,17,3],[6,0,16,0],[30,0,44,0],[64,0,68,0],[0,6,0,10],[42,6,42,7],[44,6,44,7],[0,0,0,4],[1,0,4,0],[1,2,1,4],[2,2,2,4],[12,6,12,9],[20,6,20,9],[25,6,25,9],[58,0,63,0],[17,0,29,0],[45,0,57,0]]}
["ورودی ها",null,null,null,null,null,"خروجی ها و محاسبات",null,null,null,null,"Error","Sum Error"]
["پروژه","شماره پرونده",{"$f":"File_ID","v":"223"},null,null,null,null,"واحد","مقدار","پارامتر یا فرمول"]
[null,"شناسه ملی آسانسور",{"$f":"Lift_ID","v":"9089"},null,null,null,"سطح مقطع یک ریل کابین","mm2",{"$f":"A","v":1570},"A =","مشخصات ریل‌های هادی کابین"]
[null,"نام شرکت بازرسی",{"$f":"'ورودی ها'!C4","v":"پیام گستر پارس مهر"},null,null,null,"وزن واحد طول ریل کابین","Kg/m",{"$f":"mg","v":12.3},"W ="]
[null,"آدرس پروژه",{"$f":"'ورودی ها'!C5","v":"تهران، خیابان ایران"},null,null,null,"عرض اتصال دهنده بال به تیغه ریل","mm",{"$f":"c.","v":10},"c ="]
[null,"شرح","واحد","مقدار","پارامتر ",null,"مدول کشسانی","N/cm2",2100,"E ="]
["مشخصات آسانسور و کابین","کاربری آسانسور","-",{"$f":"Lift_Type","v":"مسافری"},"Lift Type =",null,"ممان دوم اینرسی","cm4",{"$f":"Ix/10000","v":59.52},"Ix ="]
[null,"تعداد توقف (ایستگاه)","توقف",{"$f":"Stops","v":10},"Stops =",null,"ممان دوم اینرسی","cm4",{"$f":"Iy/10000","v":52.4},"Iy ="]
[null,"ارتفاع حرکت (طول مسیر)","m",{"$f":"H.","v":28.8},"H =",null,"مدول سطح مقطع عرضی","cm3",{"$f":"Wx/1000","v":14.25},"Wx ="]
[null,"تعداد مسافر","نفر",{"$f":"Passengers_No.","v":10},"Persons =",null,"مدول سطح مقطع عرضی","cm3",{"$f":"Wy/1000","v":11.8},"Wy ="]
[null,"ظرفیت بار نامی","Kg",{"$f":"Q","v":800},"Q =",null,"ضریب لاغری","-",{"$f":"L/i","v":98.360655737704917},"λ = l/i ="]
[null,"جرم کابین خالی و اجزای متصل به آن","Kg",{"$f":"P","v":800},"P =",null,"ضریب کمانش","-",{"$f":"ω","v":1.8672131147540985}," (از جدول) ω ="]
[null,"عمق کابین","mm",{"$f":"DX","v":1350},"DX =",null,"حالت اول: عملکرد ترمز ایمنی (پاراشوت)",null,null,null,"محاسبات ریل‌های هادی کابین"]
[null,"عرض کابین","mm",{"$f":"DY","v":1400},"DY =",null,"نیروی کمانش","N",{"$f":"Fk","v":15696},"Fk = k1*gn*(Q+P)/n ="]
[null,{"$f":"IF('ورودی ها'!G15=TRUE,\"جمع مساحت مفید داخل کابین       (دستی)\",\"جمع مساحت مفید داخل کابین     (اتوماتیک)\")","v":"جمع مساحت مفید داخل کابین     (اتوماتیک)"},"m2",{"$f":"Atotal","v":1.964},"Atotal =",null,"تنش کمانشی","N/mm2",{"$f":"σk","v":18.667373916675366},"σk = (Fk+K3.m)*ω/A ="]
[null,"سرعت نامی کابین آسانسور","m/s",{"$f":"VCar","v":1.6},"VCar =",null,{"$f":"205-I16","v":169.32431488711455},"N/mm2",{"$f":"IF('محاسبات  ریل'!C52>'محاسبات  ریل'!C70,'محاسبات  ریل'!C52,'محاسبات  ریل'!C70)","v":35.675685112885454},"σ = σm+(Fk+K3*M)/A =",null,{"$f":"IF(G16<0,1,0)","v":0}]
[null,"نوع کفشک های راهنما","-",{"$f":"Guide_Shoe_Type","v":"لغزشی با روغن"},"Guide Shoe =",null,{"$f":"205-I17","v":163.22221648809716},"N/mm2",{"$f":"IF('محاسبات  ریل'!C53>'محاسبات  ریل'!C71,'محاسبات  ریل'!C53,'محاسبات  ریل'!C71)","v":41.777783511902854},"σc = σk+0.9σm =",null,0]
["مشحصات موتور و فلکه کشش","نام سازنده/ نوع موتور آسانسور",{"$f":"Motor_type","v":"Wittur/SG8"},null,"Motor =",null,{"$f":"205-I18","v":196.8898890625},"N/mm2",{"$f":"IF('محاسبات  ریل'!C55>'محاسبات  ریل'!C73,'محاسبات  ریل'!C55,'محاسبات  ریل'!C73)","v":8.1101109375},"σF = 1.85*Fx/c^2 =",null,0]
[null,"توان خروجی موتور","kw",{"$f":"Wout","v":11},"Wout =",null,{"$f":"5-I19","v":4.6611723819179387},"mm",{"$f":"IF('محاسبات  ریل'!C57>'محاسبات  ریل'!C75,'محاسبات  ریل'!C57,'محاسبات  ریل'!C75)","v":0.33882761808206108},"δx = 0.7*Fx*L3/(48*E*Iy) =",null,{"$f":"IF(G19<0,1,0)","v":0}]
[null,"حداکثر بار استاتیکی مجاز روی شافت موتور","Kg",{"$f":"CsMAX","v":5000},"CsMAX =",null,{"$f":"5-I20","v":4.2824212449596777},"mm",{"$f":"IF('محاسبات  ریل'!C58>'محاسبات  ریل'!C76,'محاسبات  ریل'!C58,'محاسبات  ریل'!C76)","v":0.71757875504032254},"δy = 0.7*FyL3/(48*E*Ix) =",null,{"$f":"IF(G20<0,1,0)","v":0}]
[null,"جرم سیستم محرکه (موتور) و متعلقات (پایه)","Kg",{"$f":"Mgb","v":600},"Mgb =",null,"حالت دوم: استفاده عادی، در حالت حرکت "]
[null,"قطر فلكه کششی موتور","mm",{"$f":"Dt","v":400},"Dt =",null,{"$f":"165-I22","v":149.59306026984834},"N/mm2",{"$f":"IF('محاسبات  ریل'!C89>'محاسبات  ریل'!C106,'محاسبات  ریل'!C89,'محاسبات  ریل'!C106)","v":15.406939730151651},"σ = σm+(K3*M)/A =",null,{"$f":"IF(G22<0,1,0)","v":0}]
[null,"زاویه شیار","درجه",{"$f":"γ","v":25},"γ =",null,{"$f":"165-I23","v":160.13393343749999},"N/mm2",{"$f":"IF('محاسبات  ریل'!C91>'محاسبات  ریل'!C108,'محاسبات  ریل'!C91,'محاسبات  ریل'!C108)","v":4.8660665625000004},"σF = 1.85*Fx/c2 =",null,0]
[null,"نوع شیار فلکه کشش",null,{"$f":"Groove_Type","v":"U"},{"$f":"IF(Groove_Type=\"V hardened\",\"سخت شده\",IF(Groove_Type=\"V\",\"سخت نشده\",\"-\"))","v":"-"},null,{"$f":"5-I24","v":4.7967034291507638},"mm",{"$f":"IF('محاسبات  ریل'!C93>'محاسبات  ریل'!C110,'محاسبات  ریل'!C93,'محاسبات  ریل'!C110)","v":0.20329657084923661},"δx = 0.7*Fx*L3/(48*E*Iy) =",null,0]
[null,"زاویه زیر برش ","درجه",{"$f":"IF(OR(β=0,Groove_Type=\"V hardened\"),\"N/A\",β)","v":97.2},"β =",null,{"$f":"5-I25","v":4.5694527469758066},"mm",{"$f":"IF('محاسبات  ریل'!C94>'محاسبات  ریل'!C111,'محاسبات  ریل'!C94,'محاسبات  ریل'!C111)","v":0.43054725302419355},"δy = 0.7*FyL3/(48*E*Ix) =",null,0]
[null,"راندمان گیربكس","-",{"$f":"IF(ηG=1,\"N/A\",ηG)","v":"N/A"},"ηG =",null,"حالت سوم: استفاده عادی، در حال بارگیری"]
[null,"تعداد پیچش طناب ها روی فلکه کششی","دور",{"$f":"Wr","v":1},{"$f":"IF(Wr=1, \"پیچش تکی\", \"پیچش دوبل\")","v":"پیچش تکی"},null,"نیروی روی آستانه در کابین","N ",{"$f":"Fs","v":3139.2000000000003},"Fs ="]
[null,"فاصله افقی بکسل های کابین و وزنه تعادل","mm",{"$f":"IF('ورودی ها'!G38=FALSE,RDB,\"-\")","v":"-"},"RDB =",null,{"$f":"165-I28","v":144.04859988291705},"N/mm2",{"$f":"'محاسبات  ریل'!C123","v":20.951400117082962},"σ = σm+(K3*M)/A =",null,{"$f":"IF(G28<0,1,0)","v":0}]
[null,"فاصله عمودی مراکز فلکه کشش تا هرزگرد","mm",{"$f":"IF('ورودی ها'!G38=FALSE,hP,\"-\")","v":"-"},"hP =",null,{"$f":"165-I29","v":153.70255875000001},"N/mm2",{"$f":"'محاسبات  ریل'!C125","v":11.297441250000004},"σF = 1.85*Fx/c2 =",null,0]
[null,{"$f":"IF('ورودی ها'!G38=TRUE,\"زاویه پیچش روی فلکه کششی      (دستی)\",\"زاویه پیچش روی فلکه کششی    (اتوماتیک)\")","v":"زاویه پیچش روی فلکه کششی      (دستی)"},"درجه",{"$f":"α.","v":180},"α =",null,{"$f":"5-I30","v":4.5280107585877865},"mm",{"$f":"'محاسبات  ریل'!C127","v":0.47198924141221382},"δx = 0.7*Fx*L3/(48*E*Iy) =",null,0]
["مشخصات ریل، وزنه تعادل و فواصل مرکز جرم ها","نوع ریل راهنما","mm",{"$f":"'ورودی ها'!D40","v":"T89/A-B"},{"$f":"INDEX(Guide_Rail_Table,Guide_Rail_Type,2)","v":"89-62-16"},null,{"$f":"5-I31","v":4.8998727318548383},"mm",{"$f":"'محاسبات  ریل'!C128","v":0.10012726814516129},"δy = 0.7*FyL3/(48*E*Ix) =",null,{"$f":"IF(G31<0,1,0)","v":0},{"$f":"SUM(L16:L31)","v":0}]
[null,"نوع ترمز ایمنی","-",{"$f":"Safety_gear_Type","v":"تدریجی"},"Safety gear =",null,"جرم وزنه تعادلی-کششی و متعلقات","kg",{"$f":"Mcwt","v":1139.24},"Mcwt = P+q.Q+MTrav/2 =","محاسبات کشش سیم بکسل‌ها"]
[null,"بیشترین فاصله بین دو براکت ","mm",{"$f":"L","v":1800},"l =",null,"سرعت سیم بکسل روی پولی کشش","m/s",{"$f":"Vsr","v":3.2},"Vsr ="]
[null,"فاصله عمودی بین کفشکهای بالا و پایین کابین","mm",{"$f":"h","v":3200},"h =",null,"جرم واحد طول سیم بکسل","kg/m",{"$f":"msr","v":0.35},"mSR ="]
[null,"تعداد ریل","ستون",{"$f":"n","v":2},"n =",null,"حداقل بار گسیختگی سیم بکسل","KN",{"$f":"Fsr_min","v":50},"FSR_min ="]
[null,"ضریب تعادل وزنه (بالانس)","-",{"$f":"q.","v":0.42},"q =",null,"جرم موثر طناب های تعلیق","kg",{"$f":"MSR.","v":40.32},"MSR = H*nS*mSR ="]
[null,"نیرو در ریل دراثر بار تجهیزات جانبی","N",{"$f":"Maux","v":0},"Maux =",null,"جرم موثر طناب/ زنجیر جبران ","kg",{"$f":"MCR.","v":0},"MCR = H*nC*mCR ="]
[null,"فاصله مرکز کابین تا ریل کابین در جهت X","mm",{"$f":"XC","v":-50},"XC =",null,"حالت اول: بارگیری با 125% بار نامی",null,{"$f":"EXP(f1.*α)","v":1.9098148710596015},"e^(f1*α) ="]
[null,"فاصله مرکز کابین تا ریل کابین در جهت Y","mm",{"$f":"YC","v":0},"YC =",null,{"$f":"I38-I39","v":0.29140689097059025},null,{"$f":"IF('محاسبات  سیم بکسل'!C45>'محاسبات  سیم بکسل'!C51,'محاسبات  سیم بکسل'!C45,'محاسبات  سیم بکسل'!C51)","v":1.6184079800890112},"T1/T2 =",null,{"$f":"IF(G39<0,1,0)","v":0}]
[null,"فاصله مرکز جرم کاببن تا ریل کابین در جهت X","mm",{"$f":"XP","v":40},"XP =",null,"حالت دوم: توقف اضطراری بدون بار",null,{"$f":"EXP(f2.*α)","v":1.6325713650008902},"e^(f2*α) ="]
[null,"فاصله مرکز جرم کابین تا ریل کابین در جهت Y","mm",{"$f":"YP","v":40},"YP =",null,{"$f":"I40-I41","v":5.355987676852525E-3},null,{"$f":"IF('محاسبات  سیم بکسل'!C61>'محاسبات  سیم بکسل'!C67,'محاسبات  سیم بکسل'!C61,'محاسبات  سیم بکسل'!C67)","v":1.6272153773240376},"T1/T2 =",null,{"$f":"IF(G41<0,1,0)","v":0}]
[null,"فاصله مرکز آویز تا ریل کابین در جهت X","mm",{"$f":"XS","v":0},"XS =",null,"حالت سوم: توقف اضطراری با 100% بار",null,{"$f":"EXP(f2.*α)","v":1.6325713650008902},"e^(f2*α) ="]
[null,"فاصله مرکز آویز تا ریل کابین در جهت Y","mm",{"$f":"YS","v":0},"YS =",null,{"$f":"I42-I43","v":2.7114156358565289E-2},null,{"$f":"IF('محاسبات  سیم بکسل'!C77>'محاسبات  سیم بکسل'!C84,'محاسبات  سیم بکسل'!C77,'محاسبات  سیم بکسل'!C84)","v":1.6054572086423249},"T1/T2 =",null,{"$f":"IF(G43<0,1,0)","v":0}]
[null,"فاصله مرکز در کابین تا ریل کابین در جهت X","mm",{"$f":"Xi","v":1145},"Xi =",null,"حالت چهارم:  وزنه یا کابین گیر کرده",null,{"$f":"EXP(f3.*α)","v":3.6473928417204022},"e^(f3*α) ="]
[null,"فاصله مرکز در کابین تا ریل کابین در جهت Y","mm",{"$f":"Yi","v":50},"Yi =",null,{"$f":"I45-I44","v":6.6064186641935496},null,{"$f":"'محاسبات  سیم بکسل'!C92","v":10.253811505913951},"T1/T2 =",null,{"$f":"IF(G45<0,1,0)","v":0}]
["سیم بکسل، کابل متحرک و زنجیر جبران","نام سازنده و نوع سیم بكسل",{"$f":"'ورودی ها'!C56","v":"G-Wolf F819 W-FE"},null,{"$f":"INDEX(Rope_Type_Table,Rope_Type,2)","v":"گوستاو ولف"},null,"عدد معادل فلکه‌ی کششی","-",{"$f":"Neqt","v":8.2266666666666683},"Nequiv(t) ="," ضریب اطمینان طناب‌ها"]
[null,"قطرسیم بكسل","mm",{"$f":"dsr","v":10},"dr =",null,"عدد معادل فلکه‌های انحرافی","-",{"$f":"Kp*(Nps+4*Npr)","v":3},"Nequiv(p) = Kp * (Nps+4*Npr) ="]
[null,"تعداد طناب های تعلیق (سیم بکسل ها)","عدد",{"$f":"nS","v":4},"ns =",null,"ضریب اطمینان فعلی سیم بکسلها","-",{"$f":"Sf_cur","v":24.261424025253621},"Sf_cur ="]
[null,"ضریب طناب بندی (سیستم تعلیق)",{"$f":"'ورودی ها'!C59","v":"2:1"},{"$f":"r.","v":2},"r =",null,"حداقل ضریب اطمینان مورد نیاز","-",{"$f":"Sf_min","v":19.516635745597661},{"$f":"Sf_cur-Sf_min","v":4.7447882796559604},null,{"$f":"IF(J49<0,1,0)","v":0}]
[null,"تعداد کابل متحرک (تراول کابل)","عدد",{"$f":"nt","v":1},"nt =",null,{"$f":"IF(Groove_Type=\"V\",\"چک مجدد شیار v زیر برش دار و سخت نشده (قبل از خورده شدن و تبدیل شدن به U)\",\"\")","v":""}]
[null,"جرم واحد طول کابل متحرک (تراول کابل)","kg/m",{"$f":"mt","v":0.45},"MT =",null,{"$f":"IF(Groove_Type=\"V\",\"عدد معادل فلکه‌ی کششی\",\"\")","v":""},{"$f":"IF(Groove_Type=\"V\",\"-\",\"\")","v":""},{"$f":"IF(Groove_Type=\"V\",'محاسبات  سیم بکسل'!C116,\"\")","v":""},{"$f":"IF(Groove_Type=\"V\",\"Nequiv(t) =\",\"\")","v":""}]
[null,"تعداد طناب/ زنجیر جبران ","عدد",{"$f":"nc","v":0},"nc =",null,{"$f":"IF(Groove_Type=\"V\",\"حداقل ضریب اطمینان مورد نیاز\",\"\")","v":""},{"$f":"IF(Groove_Type=\"V\",\"-\",\"\")","v":""},{"$f":"IF(Groove_Type=\"V\",'محاسبات  سیم بکسل'!C118,\"\")","v":""},{"$f":"IF(Groove_Type=\"V\",IF(I52>$I$48,\"<-Warning-> Sf_cur < Sf_min =\",\"<-OK->  Sf_cur > Sf_min =\"),\"\")","v":""},null,null,{"$f":"SUM(L36:L52)","v":0}]
[null,"جرم واحد طول طناب/ زنجیر جبران","kg/m",{"$f":"IF(nc=0,\"N/A\",mcr)","v":"N/A"},"mCR =",null,"نیروی وارد بر کف چاهک، زیر ضربه‌گیر کابین","N",{"$f":"4*gn*(P+Q)","v":62784},"F1 = 4*gn(P+Q) =","نیروهای وارده  "]
[null,"جرم کاهش‌یافته فلکه ی کشش طناب جبران ","kg",{"$f":"IF(nc=0,\"N/A\",mPTD)","v":"N/A"},"mPTD = ",null,"نیروی وارد بر کف چاهک، زیر ضربه‌گیر وزنه","N",{"$f":"4*gn*(P+q.*Q)","v":44576.639999999999},"F2 = 4*gn(P+q.Q) ="]
[null,"جرم وسیله تأمین کشش شامل جرم فلکه‌ها","kg",{"$f":"IF(nc=0,\"N/A\",MComp)","v":"N/A"},"MComp =",null,"وزن قابل تحمل توسط قلاب سقف","Kg",1500,"N ="]
[null,"نیروی اصطکاک در چاه سمت کابین","N",{"$f":"FRCar","v":200},"FRCar =",null,"وزن سیستم محرکه و متعلقات","Kg",{"$f":"Mgb","v":600},"Mgb ="]
[null,"نیروی اصطکاک در چاه سمت وزنه تعادل","N",{"$f":"FRCwt","v":100},"FRCwt =",null,"نیروی وارد بر سقف چاه دال بتونی","N",{"$f":"'محاسبات دیگر '!C16","v":39081.627359999999},"F3 = "]
[null,"شتاب ناشی از توقف اضطراری کابین","m/s2",{"$f":"a.","v":0.5},"a =",null,"نیروی وارد بر کف چاهک، زیر هر ریل کابین","N",{"$f":"H.*gn*mg+Fk","v":19171.094400000002},"F4 = H*W*gn+Fk ="]
["فلکه‌های هرزگرد","تعداد فلکه‌های هرزگرد با خم معکوس","عدد",{"$f":"Npr","v":0},"Npr =",null,"راندمان چاه","-",{"$f":"ηs","v":0.9},"ηS =","محاسبات موتور آسانسور"]
[null,"محل قرارگیری فلکه‏های هرزگرد","تعداد","قطر فلکه (mm)","جنس فلکه ",null,"راندمان پولی ها","Kg",{"$f":"1-(iDPcar+iDPcwt+iPcar+iPcwt)*1%","v":0.96},"ηP ="]
[null,"فلکه فاصله انداز سمت کابین (ثابت)",{"$f":"iDPcar","v":1},{"$f":"IF(iDPcar=0,\"N/A\",dDPcar)","v":400},{"$f":"IF(iDPcar=0,\"N/A\",'ورودی ها'!E74)","v":"پلیمری"},null,"توان خروجی موتور","Kw",{"$f":"Wout","v":11},"Wout ="]
[null,"فلکه فاصله انداز سمت وزنه تعادل (ثابت)",{"$f":"iDPcwt","v":0},{"$f":"IF(iDPcwt=0, \"N/A\",dDPcwt)","v":"N/A"},{"$f":"IF(iDPcwt=0,\"N/A\",'ورودی ها'!E75)","v":"N/A"},null,"بار استاتیکی بر محور پولی کشش","Kg",{"$f":"Cs","v":1409.9399999999998},{"$f":"IF(I62>CsMAX,\"<-Error->  Csmax ≤ Cs =\",\"<-OK->   Csmax > Cs =\")","v":"<-OK->   Csmax > Cs ="},null,{"$f":"IF(I62>CsMAX,1,0)","v":0}]
[null,"فلکه هرزگرد متصل به کابین (متحرک)",{"$f":"iPcar","v":2},{"$f":"IF(iPcar=0,\"N/A\",dPcar)","v":400},{"$f":"IF(iPcar=0,\"N/A\",'ورودی ها'!E76)","v":"پلیمری"},null,"حداکثر بار غیر متعادل روی موتور","Kg",{"$f":"qm","v":281.97916666666669},"qm(max)="]
[null,"فلکه هرزگرد روی وزنه تعادل (متحرک)",{"$f":"iPcwt","v":1},{"$f":"IF(iPcwt=0,\"N/A\",dPcwt)","v":440},{"$f":"IF(iPcwt=0,\"N/A\",'ورودی ها'!E77)","v":"پلیمری"},null,"توان مورد نیاز در میانه مسیر ","Kw",{"$f":"Wmid","v":8.4293333333333358},"Wmid =Q(1+|1-2q|).Vcar.gn/[2.ηg.ηS.ηP] =",null,{"$f":"IF(Wmid>Wout,1,0)","v":0}]
["درهای کابین","درهای کابین محسوب شده در مساحت مفید","عرض","نوع در کابین","عمق آستانه",null,"حداکثر توان مورد نیاز موتور","Kw",{"$f":"Wmax","v":9.8354333333333344},"Wmax = (qm(max)*VSr*gn)/[ηg*ηS] =",null,{"$f":"IF(Wmax>1.2*Wout,1,0)","v":0}]
[null,"در اول (جلو)",{"$f":"IF(En_D1=TRUE,DW1.,\"N/A\")","v":900},{"$f":"IF(En_D1=TRUE,DT1.,\"N/A\")","v":"تلسکوپی 2 لنگه"},{"$f":"IF(En_D1=TRUE,DD1.,\"N/A\")","v":60},null,"محاسبات مساحت داخل کابین"]
[null,"در دوم (راست)",{"$f":"IF(En_D2=TRUE,DW2.,\"N/A\")","v":"N/A"},{"$f":"IF(En_D2=TRUE,DT2.,\"N/A\")","v":"N/A"},{"$f":"IF(En_D2=TRUE,DD2.,\"N/A\")","v":"N/A"},null,"جمع مساحت مفید داخل کابین","m2",{"$f":"Atotal","v":1.964},"Atotal ="]
[null,"در سوم (عقب)",{"$f":"IF(En_D3=TRUE,DW3.,\"N/A\")","v":"N/A"},{"$f":"IF(En_D3=TRUE,DT3.,\"N/A\")","v":"N/A"},{"$f":"IF(En_D3=TRUE,DD3.,\"N/A\")","v":"N/A"},null,"حداقل مساحت مجاز داخل کابین","m2",{"$f":"IF(Passengers_No.>20,3.13+(Passengers_No.-20)*0.115,VLOOKUP(Passengers_No.,Min_Car_Area,2))","v":1.73},{"$f":"Atotal-Amin","v":0.23399999999999999},null,{"$f":"IF(J68<0,1,0)","v":0}]
[null,"در چهار (چپ)",{"$f":"IF(En_D4=TRUE,DW4.,\"N/A\")","v":"N/A"},{"$f":"IF(En_D4=TRUE,DT4.,\"N/A\")","v":"N/A"},{"$f":"IF(En_D4=TRUE,DD4.,\"N/A\")","v":"N/A"},null,"حداکثر مساحت مجاز داخل کابین","m2",{"$f":"IF(Q>2500, 5+(Q-2500)/100*0.16,VLOOKUP(Q,Max_Car_Area,2)+(VLOOKUP(INDEX(loads,MATCH(Q,loads,1)+1),Max_Car_Area,2)-VLOOKUP(Q,Max_Car_Area,2))*(Q-INDEX(loads,MATCH(Q,loads,1)))/(INDEX(loads,MATCH(Q,loads,1)+1)-INDEX(loads,MATCH(Q,loads,1))))","v":2},{"$f":"Amax-Atotal","v":3.6000000000000032E-2},null,{"$f":"IF(J69<0,1,0)","v":0},{"$f":"SUM(L59:L70)","v":0}]
[{"$f":"IF(D2d<>0,\"به علت عدم تطابق ورودی‌ها با استاندارد ملی، در کمیته فنی بررسی شود\", IF(InputErr<>0, \"داده های ورودی مغایرت دارد\",IF(AND(Guide_Rail_Type=13,OR(Rope_Type=10,Rope_Type=11)),\"مستندات و مدارک فنی مربوط به سیم بکسل و ریل ارائه شود\",IF(Guide_Rail_Type=13,\"مستندات و مدارک فنی مربوط به ریل‌ ارائه شود\",IF(OR(Rope_Type=10,Rope_Type=11),\"مستندات و مدارک فنی مربوط به سیم بکسل ارائه شود\",\"\")))))","v":""},null,null,null,null,null,{"$f":" IF(SumErr<>0, \"محاسبات مطابق با استاندارد 1393: 1-6303 تجدید نظر اول مردود است\",\"محاسبات مطابق با استاندارد 1393: 1-6303  تایید است تجدید نظر اول \")","v":"محاسبات مطابق با استاندارد 1393: 1-6303  تایید است تجدید نظر اول "},null,null,null,null,null,{"$f":"SUM(M16:M69)","v":0}]

{"sheet":"برگه نهايي 81","index":7,"n_rows":53,"n_cols":12,"rows_kept":53,"cut":false,"hidden":true,"merged":[[0,0,0,4],[0,6,0,10],[1,2,1,4],[2,2,2,4],[3,2,3,4],[2,10,14,10],[8,0,18,0],[1,0,6,0],[4,1,6,1],[4,2,6,4],[15,10,32,10],[25,6,25,7],[26,6,26,7],[27,6,27,7],[33,10,38,10],[19,0,32,0],[19,2,19,3],[33,0,38,0],[54,3,54,4],[52,0,52,4],[52,6,52,10],[39,10,47,10],[48,10,51,10],[47,0,51,0],[39,2,39,3],[39,0,46,0],[48,6,48,9],[24,6,24,7]]}
["ورودی ها",null,null,null,null,null,"خروجی ها و محاسبات",null,null,null,null,"ErrorSum"]
["پروژه","شماره پرونده",{"$f":"File_ID","v":"223"},null,null,null,"شرح","واحد","مقدار","پارامتر یا فرمول"]
[null,"شناسه ملی آسانسور",{"$f":"Lift_ID","v":"9089"},null,null,null,"سطح مقطع یک ریل کابین","mm2",{"$f":"A","v":1570},"A =","محاسبات ریل‌های هادی کابین"]
[null,"نام شرکت بازرسی",{"$f":"'ورودی ها'!C4","v":"پیام گستر پارس مهر"},null,null,null,"وزن واحد طول ریل کابین","Kg/m",{"$f":"mg","v":12.3},"W ="]
[null,"آدرس پروژه",{"$f":"'ورودی ها'!C5","v":"تهران، خیابان ایران"},null,null,null,"عرض اتصال دهنده بال به تیغه ریل","mm",{"$f":"c.","v":10},"c ="]
[null,null,null,null,null,null,"ضریب ضربه در حالت ترمز ایمنی","-",{"$f":"K1.","v":2},"K1 ="]
[null,null,null,null,null,null,"مدول کشسانی","N/cm2",2100,"E ="]
[null,"شرح","واحد","مقدار","پارامتر ",null,"ممان دوم اینرسی","cm4",{"$f":"Ix/10000","v":59.52},"Ix ="]
["مشخصات آسانسور و کابین","کاربری آسانسور","-",{"$f":"Lift_Type","v":"مسافری"},"Lift Type =",null,"ممان دوم اینرسی","cm4",{"$f":"Iy/10000","v":52.4},"Iy ="]
[null,"تعداد توقف (ایستگاه)","توقف",{"$f":"Stops","v":10},"Stops =",null,"مدول سطح مقطع عرضی","cm3",{"$f":"Wx/1000","v":14.25},"Wx ="]
[null,"ارتفاع حرکت (طول مسیر)","m",{"$f":"H.","v":28.8},"H =",null,"مدول سطح مقطع عرضی","cm3",{"$f":"Wy/1000","v":11.8},"Wy ="]
[null,"تعداد مسافر","نفر",{"$f":"Passengers_No.","v":10},"Persons =",null,"ضریب لاغری","-",{"$f":"L/i","v":98.360655737704917},"λ = l/i ="]
[null,"ظرفیت بار نامی","Kg",{"$f":"Q","v":800},"Q =",null,"ضریب کمانش","-",{"$f":"ω","v":1.8672131147540985}," (از جدول) ω ="]
[null,"جرم کابین خالی و اجزای متصل به آن","Kg",{"$f":"P","v":800},"P =",null,"نیرو و تنش کمانشی","N",{"$f":"Fk","v":15696},"Fk = k1*gn*(Q+P)/n ="]
[null,"عمق کابین","mm",{"$f":"DX","v":1350},"DX =",null,{"$f":"140-I15","v":121.33262608332464},"N/mm2",{"$f":" Fk*ω/A","v":18.667373916675366},"σk = Fk*ω/A =",null,{"$f":"IF(G15<0,1,0)","v":0}]
[null,"عرض کابین","mm",{"$f":"DY","v":1400},"DY =",null,"جرم وزنه تعادل و متعلقات","kg",{"$f":"Mcwt","v":1139.24},"Mcwt = P+q.Q+MTrav/2 =","محاسبات کشش، فشار مخصوص و ضریب اطمینان طناب‏ها"]
[null,{"$f":"IF('ورودی ها'!G15=TRUE,\"جمع مساحت مفید داخل کابین       (دستی)\",\"جمع مساحت مفید داخل کابین     (اتوماتیک)\")","v":"جمع مساحت مفید داخل کابین     (اتوماتیک)"},"m2",{"$f":"Atotal","v":1.964},"Atotal =",null,"سرعت سیم بکسل","m/s",{"$f":"Vsr","v":3.2},"Vsr ="]
[null,"سرعت نامی کابین آسانسور","m/s",{"$f":"VCar","v":1.6},"VCar =",null,"جرم واحد طول سیم بکسل","kg/m",{"$f":"msr","v":0.35},"mSR ="]
[null,"نوع کفشک های راهنما","-",{"$f":"Guide_Shoe_Type","v":"لغزشی با روغن"},"Guide Shoe =",null,"حداقل بار گسیختگی سیم بکسل","KN",{"$f":"Fsr_min","v":50},"FSR_min ="]
["مشحصات موتور و فلکه کشش","نام سازنده/ نوع موتور آسانسور",{"$f":"Motor_type","v":"Wittur/SG8"},null,"Motor =",null,"جرم موثر طناب های تعلیق","kg",{"$f":"MSR.","v":40.32},"MSR = H*nS*mSR ="]
[null,"توان خروجی موتور","kw",{"$f":"Wout","v":11},"Wout =",null,"جرم موثر طناب/ زنجیر جبران ","kg",{"$f":"MCR.","v":0},"MCR = H*nC*mCR ="]
[null,"حداکثر بار استاتیکی مجاز روی شافت موتور","Kg",{"$f":"CsMAX","v":5000},"CsMAX =",null,"ضریب شتاب",null,{"$f":"IF(VCar>2.5,1.3,IF(VCar>1.6,1.25,IF(VCar>1,1.2,IF(VCar>0.63,1.15,1.1))))","v":1.2},"C1 ="]
[null,"جرم سیستم محرکه (موتور) و متعلقات (پایه)","Kg",{"$f":"Mgb","v":600},"Mgb =",null,"ضریب شکل شیار",null,{"$f":"IF( Groove_Type=\"V hardened\",1.2,1)","v":1},"C2 ="]
[null,"قطر فلكه کششی موتور","mm",{"$f":"Dt","v":400},"Dt =",null,"عامل اصطکاک ","-",{"$f":"IF(Groove_Type=\"V hardened\",0.09/SIN(γ./2),0.09*4*(1-SIN(β./2))/(PI()-β.-SIN(β.)))","v":0.19857937422150329},{"$f":"IF(Groove_Type=\"V hardened\",\"f = μ/Sin(γ/2) =\",\"f =μ*4*(1-Sin(β/2))/(π-β-Sinβ) =\")","v":"f =μ*4*(1-Sin(β/2))/(π-β-Sinβ) ="}]
[null,"زاویه شیار","درجه",{"$f":"γ","v":25},"γ =",null,"حالت اول: کابین پایینترین توقف با 125% بار ",null,{"$f":"EXP(f*α)","v":1.8661089790443619},"e^(f*α) ="]
[null,"نوع شیار فلکه کشش",null,{"$f":"Groove_Type","v":"U"},{"$f":"IF(Groove_Type=\"V hardened\",\"سخت شده\",IF(Groove_Type=\"V\",\"سخت نشده\",\"-\"))","v":"-"},null,{"$f":"I25-I26","v":-0.11483270137416257},null,{"$f":"((P+Q1.)*gn/r.+MSR.*gn)/((Mcwt+MCR.)*gn/r.)*C1.*C2.","v":1.9809416804185245},"T1/T2 *C1 *C2=",null,{"$f":"IF(G26<0,1,0)","v":1}]
[null,"زاویه زیر برش ","درجه",{"$f":"IF(OR(β=0,Groove_Type=\"V hardened\"),\"N/A\",β)","v":97.2},"β =",null,"حالت دوم: کابین بالاترین توقف بدون بار",null,{"$f":"EXP(f*α)","v":1.8661089790443619},"e^(f*α) ="]
[null,"راندمان گیربكس","-",{"$f":"ηG","v":1},"ηG =",null,{"$f":"I27-I28","v":5.0991431182046965E-2},null,{"$f":"(Mcwt*gn/r.+MSR.*gn)/((P+MCR.+MTrav)*gn/r.)*C1.*C2.","v":1.8151175478623149},"T1/T2 *C1 *C2=",null,{"$f":"IF(G28<0,1,0)","v":0}]
[null,"تعداد پیچش طناب ها روی فلکه کششی","دور",{"$f":"Wr","v":1},{"$f":"IF(Wr=1, \"پیچش تکی\", \"پیچش دوبل\")","v":"پیچش تکی"},null,"فشار مخصوص فعلی","N/mm2",{"$f":"IF(Groove_Type=\"V hardened\",((P+Q)*gn/r.+MSR.*gn)/(nS*Dt*dsr)*4.5/SIN(γ./2),((P+Q)*gn/r.+MSR.*gn)/(nS*Dt*dsr)*8*COS(β./2)/(PI()-β.-SIN(β.)))","v":6.0169256584829691},{"$f":"IF(Groove_Type=\"V hardened\",\"P = T/(n*D*d)*4.5/SIN(γ/2) =\",\"P=T/(n*D*d)*8*COS(β/2)/(π-β-SINβ)\")","v":"P=T/(n*D*d)*8*COS(β/2)/(π-β-SINβ)"}]
[null,"فاصله افقی بکسل های کابین و وزنه تعادل","mm",{"$f":"IF('ورودی ها'!G38=FALSE,RDB,\"-\")","v":"-"},"RDB =",null,"فشار مخصوص ماکزیمم","N/mm2",{"$f":"(12.5+4*Vsr)/(1+Vsr)","v":6.0238095238095237},"Pmax = (12.5+4*Vc)/(1+Vc) =",null,{"$f":"IF(I30<I29,1,0)","v":0}]
[null,"فاصله عمودی مراکز فلکه کشش تا هرزگرد","mm",{"$f":"IF('ورودی ها'!G38=FALSE,hP,\"-\")","v":"-"},"hP =",null,"مقایسه فشار مخصوص",null,null,{"$f":"I30-I29","v":6.8838653265546057E-3}]
[null,{"$f":"IF('ورودی ها'!G38=TRUE,\"زاویه پیچش روی فلکه کششی      (دستی)\",\"زاویه پیچش روی فلکه کششی    (اتوماتیک)\")","v":"زاویه پیچش روی فلکه کششی      (دستی)"},"درجه",{"$f":"α.","v":180},"α =",null,"ضریب اطمینان فعلی سیم بکسلها","-",{"$f":"Fsr_min*1000*nS/((P+Q)*gn/r.+MSR.*gn)","v":24.261424025253621},"Sf_cur ="]
[null,null,null,null,null,null,"حداقل ضریب اطمینان مورد نیاز","-",{"$f":"IF(nS=2,16,12)","v":12},{"$f":"I32-I33","v":12.261424025253621}]
["مشخصات ریل و وزنه","نوع ریل راهنما","mm",{"$f":"'ورودی ها'!D40","v":"T89/A-B"},{"$f":"INDEX(Guide_Rail_Table,Guide_Rail_Type,2)","v":"89-62-16"},null,"نیروی وارده بر زیر ضربه گیر کابین","N",{"$f":"4*gn*(P+Q)","v":62784},"F1 = 4*gn(P+Q) =","نیروهای وارده  "]
[null,"نوع ترمز ایمنی","-",{"$f":"Safety_gear_Type","v":"تدریجی"},"Safety gear =",null,"نیروی وارده بر زیر ضربه گیر وزنه","N",{"$f":"4*gn*(P+q.*Q)","v":44576.639999999999},"F2 = 4*gn(P+q.Q) ="]
[null,"بیشترین فاصله بین دو براکت ","mm",{"$f":"L","v":1800},"l =",null,"وزن قابل تحمل توسط قلاب سقف","Kg",1500,"N ="]
[null,"فاصله عمودی کفشکهای بالا و پایین کابین","mm",{"$f":"h","v":3200},"h =",null,"وزن سیستم محرکه و متعلقات","Kg",{"$f":"Mgb","v":600},"Mgb ="]
[null,"تعداد ریل","ستون",{"$f":"n","v":2},"n =",null,"نیروی وارد بر سقف چاه دال بتونی","N",{"$f":"'محاسبات دیگر '!C16","v":39081.627359999999},"F3 = "]
[null,"ضریب تعادل وزنه (بالانس)","-",{"$f":"q.","v":0.42},"q =",null,"نیروی وارد بر کف زیر ریلهای کابین","N",{"$f":"H.*gn*mg+Fk","v":19171.094400000002},"F4 = H*W*gn+Fk ="]
["سیم بکسل، زنجیر جبران و...","نام سازنده و نوع سیم بكسل",{"$f":"'ورودی ها'!C56","v":"G-Wolf F819 W-FE"},null,{"$f":"INDEX(Rope_Type_Table,Rope_Type,2)","v":"گوستاو ولف"},null,"راندمان گیربكس","-",{"$f":"ηG","v":1},"ηG =","محاسبات موتور آسانسور"]
[null,"قطرسیم بكسل","mm",{"$f":"dsr","v":10},"dr =",null,"راندمان چاه","-",{"$f":"ηs","v":0.9},"ηS ="]
[null,"تعداد طناب های تعلیق (سیم بکسل ها)","عدد",{"$f":"nS","v":4},"ns =",null,"راندمان پولی ها","-",{"$f":"ηP","v":0.96},"ηP =",null,{"$f":"IF(I45>CsMAX,1,0 )","v":0}]
[null,"ضریب طناب بندی (سیستم تعلیق)",{"$f":"'ورودی ها'!C59","v":"2:1"},{"$f":"r.","v":2},"r =",null,"توان خروجی موتور","Kw",{"$f":"Wout","v":11},"Wout ="]
[null,"تعداد کابل متحرک (تراول کابل)","عدد",{"$f":"nt","v":1},"nt =",null,"جرم وزنه تعادل","Kg",{"$f":"Mcwt","v":1139.24},"MCwt = P+q*Q+MTrav/2 =",null,{"$f":"IF(Wmid>Wout,1,0)","v":0}]
[null,"جرم واحد طول کابل متحرک (تراول کابل)","kg/m",{"$f":"mt","v":0.45},"MT =",null,"بار استاتیکی بر محور پولی کشش","Kg",{"$f":"Cs","v":1409.9399999999998},{"$f":"IF(I45>CsMAX,\"<-Error->  Csmax ≤ Cs =\",\"<-OK->   Csmax > Cs =\")","v":"<-OK->   Csmax > Cs ="},null,{"$f":"IF(Wmax>1.2*Wout,1,0)","v":0}]
[null,"تعداد طناب/ زنجیر جبران ","عدد",{"$f":"nc","v":0},"nc =",null,"حداکثر بار غیر متعادل روی موتور","Kg",{"$f":"qm","v":281.97916666666669},"qm(max)="]
[null,"جرم واحد طول طناب/ زنجیر جبران","kg/m",{"$f":"IF(nc=0,\"N/A\",mcr)","v":"N/A"},"MCR =",null,"توان مورد نیاز در میانه مسیر ","Kw",{"$f":"Wmid","v":8.4293333333333358},"Wmid =Q(1+|1-2q|).Vcar.gn/[2.ηg.ηS.ηP] ="]
["درهای کابین","درهای کابین محسوب شده در مساحت مفید","عرض","نوع در کابین","عمق آستانه",null,"حداکثر توان مورد نیاز موتور","Kw",{"$f":"Wmax","v":9.8354333333333344},"Wmax = (qm(max).VSr.gn)/[ηg.ηSP] ="]
[null,"در اول (جلو)",{"$f":"IF(En_D1=TRUE,DW1.,\"N/A\")","v":900},{"$f":"IF(En_D1=TRUE,DT1.,\"N/A\")","v":"تلسکوپی 2 لنگه"},{"$f":"IF(En_D1=TRUE,DD1.,\"N/A\")","v":60},null,"محاسبات مساحت داخل کابین"]
[null,"در دوم (راست)",{"$f":"IF(En_D2=TRUE,DW2.,\"N/A\")","v":"N/A"},{"$f":"IF(En_D2=TRUE,DT2.,\"N/A\")","v":"N/A"},{"$f":"IF(En_D2=TRUE,DD2.,\"N/A\")","v":"N/A"},null,"جمع مساحت مفید داخل کابین","m2",{"$f":"Atotal","v":1.964},"Atotal =",null,{"$f":"IF(J51<0,1,0)","v":0}]
[null,"در سوم (عقب)",{"$f":"IF(En_D3=TRUE,DW3.,\"N/A\")","v":"N/A"},{"$f":"IF(En_D3=TRUE,DT3.,\"N/A\")","v":"N/A"},{"$f":"IF(En_D3=TRUE,DD3.,\"N/A\")","v":"N/A"},null,"حداقل مساحت مجاز داخل کابین","m2",{"$f":"IF(Passengers_No.>20,3.13+(Passengers_No.-20)*0.115,VLOOKUP(Passengers_No.,Min_Car_Area,2))","v":1.73},{"$f":"Atotal-Amin","v":0.23399999999999999},null,{"$f":"IF(J52<0,1,0)","v":0}]
[null,"در چهار (چپ)",{"$f":"IF(En_D4=TRUE,DW4.,\"N/A\")","v":"N/A"},{"$f":"IF(En_D4=TRUE,DT4.,\"N/A\")","v":"N/A"},{"$f":"IF(En_D4=TRUE,DD4.,\"N/A\")","v":"N/A"},null,"حداکثر مساحت مجاز داخل کابین","m2",{"$f":"IF(Q>2500, 5+(Q-2500)/100*0.16,VLOOKUP(Q,Max_Car_Area,2)+(VLOOKUP(INDEX(loads,MATCH(Q,loads,1)+1),Max_Car_Area,2)-VLOOKUP(Q,Max_Car_Area,2))*(Q-INDEX(loads,MATCH(Q,loads,1)))/(INDEX(loads,MATCH(Q,loads,1)+1)-INDEX(loads,MATCH(Q,loads,1))))","v":2},{"$f":"Amax-Atotal","v":3.6000000000000032E-2},null,{"$f":"SUM(L14:L51)","v":1}]
[{"$f":"IF(D2d<>0,\"به علت عدم تطابق ورودی‌ها با استاندارد ملی، در کمیته فنی بررسی شود\", IF(InputErr<>0, \"داده های ورودی مغایرت دارد\",IF(AND(Guide_Rail_Type=13,OR(Rope_Type=10,Rope_Type=11)),\"مستندات و مدارک فنی مربوط به سیم بکسل و ریل ارائه شود\",IF(Guide_Rail_Type=13,\"مستندات و مدارک فنی مربوط به ریل‌ ارائه شود\",IF(OR(Rope_Type=10,Rope_Type=11),\"مستندات و مدارک فنی مربوط به سیم بکسل ارائه شود\",\"\")))))","v":""},null,null,null,null,null,{"$f":" IF(SumOld<>0, \"محاسبات مطابق با استاندارد 1381: 1-6303 مردود است\",\"محاسبات مطابق با استاندارد 1381: 1-6303  تایید است\")","v":"محاسبات مطابق با استاندارد 1381: 1-6303 مردود است"}]

{"sheet":"ریلهای راهنما","index":8,"n_rows":18,"n_cols":16,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,1,0,12],[17,1,17,12],[0,0,2,0]]}
["ردیف","GUIDE RAIL TECHNICAL CHARACTERISTICS"]
[null,"Type","Dimension","Section","Weight","c","Ixx","Wxx","ixx","Iyy","Wyy","iyy","imin"]
[null,null,"mm","cm2","Kg/m","mm","cm4","cm3","cm","cm4","cm3","cm","cm"]
[1,"T45/A ","45-45-5",4.25,3.34,5,8.08,2.5299999999999998,1.38,3.84,1.71,0.95,{"$f":"IF(L4<I4,L4,I4)","v":0.95}]
[2,"T50/A","50-50-5",4.75,3.73,5,11.24,3.15,1.54,5.25,2.1,1.05,{"$f":"IF(L5<I5,L5,I5)","v":1.05}]
[3,"T70-1/A","70-65-9",9.51,7.47,6,41.3,9.24,2.09,18.649999999999999,5.35,1.4,{"$f":"IF(L6<I6,L6,I6)","v":1.4}]
[4,"T70-70-9/A","70-70-9",11.25,8.83,7.9,52.81,10.79,2.16,24.62,7.02,1.48,{"$f":"IF(L7<I7,L7,I7)","v":1.48}]
[5,"T82/A-B","82-68-9",10.9,8.5500000000000007,7.5,49.4,10.199999999999999,2.13,30.5,7.4,1.67,{"$f":"IF(L8<I8,L8,I8)","v":1.67}]
[6,"T89/A-B","89-62-16",15.7,12.3,10,59.52,14.25,1.95,52.4,11.8,1.83,{"$f":"IF(L9<I9,L9,I9)","v":1.83}]
[7,"T90/A-B","90-75-16",17.25,13.55,10,102,20.87,2.4300000000000002,52.6,11.8,1.75,1.75,null,null,"`"]
[8,"T114/B","114-89-16",20.85,16.37,9.5,179,29.7,2.93,109,19.100000000000001,2.29,2.29]
[9,"T125/B","125-82-16",22.83,17.899999999999999,10,151,26.2,2.57,159,25.4,2.64,2.57]
[10,"T140-1/B","140-108-19",35.200000000000003,27.6,12.7,404,53.4,3.39,310,44.3,2.97,2.97]
[11,"T127-1/B","127-89-16",22.64,17.77,10,186.2,30.4,2.87,148,23.4,2.56,2.56]
[12,"T127-2/B","127-89-16",28.63,22.48,10,198.4,30.9,2.63,230,36.200000000000003,2.83,2.63]
[13,"TXX/X","XX-XX-XX",43.22,33.92,17.5,457,68,3.25,358,51.2,2.88,2.88]
[null,1,2,3,4,5,6,7,8,9,10,11,12]
[null,"راهنمایی: در صورتیکه ریل مورد نظر در این جدول وجود ندارد میتوان با وارد کردن مشخصات ریل خاص مورد نظر در ردیف آخر (13)، در ورودی ها از آن استفاده نمود. در اینصورت ارایه مدارک مربوطه الزامی است."]

{"sheet":"مساحت کابین & Neq(t)","index":9,"n_rows":34,"n_cols":36,"rows_kept":34,"cut":false,"hidden":true,"merged":[[0,26,0,32],[0,11,0,22],[23,4,25,5],[31,1,32,2],[33,1,34,2],[1,7,2,7],[4,7,5,7],[4,23,5,23],[1,23,2,23]]}
[null,"Rated load,","Maximum ",null,"Number of","Minimum",null,null,null,null,null,"Nequiv(t) EN81-1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nequiv(t) EN81-50"]
[null,"mass","available car ",null,"passengers","available car",null,"V- grooves","V- angle (γ)",25,30,35,36,38,40,42,45,50,55,60,null,null,null,"V- grooves","V- angle (γ)",25,30,35,36,38,40,42,45,50,55,60]
[null,"(kg)","area (m2)",null,null,"area (m2)",null,null,"Nequiv(t)","--","--",18.5,15.2,10.5,7.1,5.6,4,3.1,2.7,2.5,null,null,null,null,"Nequiv(t)","--","--",18.5,16,12,10,8,6.5,5,4.5,4.2]
[null,100,0.37,null,1,0.28000000000000003]
[null,180,0.57999999999999996,null,2,0.49,null,"U- Undercut groove","U- angle (β)",0,75,80,85,90,95,96,97,100,102,105,106,null,null,"U- Undercut grooves","U- angle (β)",75,80,85,90,95,100,105]
[null,225,0.7,null,3,0.6,null,null,"Nequiv(t)",1,2.5,3,3.8,5,6.7,7.4,8.1,10,12.1,15.2,20.9,null,null,null,"Nequiv(t)",2.5,3,3.8,5,6.7,10,15.2]
[null,300,0.9,null,4,0.79]
[null,375,1.1000000000000001,null,5,0.98,null,{"$f":"IF(γ=AJ2,AJ3,HLOOKUP(γ,V_Neqt50,2)+(INDEX(V_Neqt50,2,MATCH(γ,V_angles,1)+1)-HLOOKUP(γ,V_Neqt50,2))*(γ-HLOOKUP(γ,V_Neqt50,1))/(INDEX(V_Neqt50,1,MATCH(γ,V_angles,1)+1)-HLOOKUP(γ,V_Neqt50,1)))","v":{"$error":"#VALUE!"}}]
[null,400,1.17,null,6,1.17,null,{"$f":"IF(γ=T2,T3,HLOOKUP(γ,V_Neqt,2)+(INDEX(V_Neqt,2,MATCH(γ,V_angles,1)+1)-HLOOKUP(γ,V_Neqt,2))*(γ-HLOOKUP(γ,V_Neqt,1))/(INDEX(V_Neqt,1,MATCH(γ,V_angles,1)+1)-HLOOKUP(γ,V_Neqt,1)))","v":{"$error":"#VALUE!"}}]
[null,450,1.3,null,7,1.31,null,{"$f":"IF(β=U5,U6,HLOOKUP(β,U_Neqt,2)+(INDEX(U_Neqt,2,MATCH(β,U_angles,1)+1)-HLOOKUP(β,U_Neqt,2))*(β-HLOOKUP(β,U_Neqt,1))/(INDEX(U_Neqt,1,MATCH(β,U_angles,1)+1)-HLOOKUP(β,U_Neqt,1)))","v":8.2266666666666683},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"`"]
[null,525,1.45,null,8,1.45]
[null,600,1.6,null,9,1.59]
[null,630,1.66,null,10,1.73]
[null,675,1.75,null,11,1.87]
[null,750,1.9,null,12,2.0099999999999998]
[null,800,2,null,13,2.15]
[null,825,2.0499999999999998,null,14,2.29]
[null,900,2.2000000000000002,null,15,2.4300000000000002]
[null,975,2.35,null,16,2.57]
[null,1000,2.4,null,17,2.71]
[null,1050,2.5,null,18,2.85]
[null,1125,2.65,null,19,2.99,null,null,{"$f":"VLOOKUP(Q,Max_Car_Area,2)+(VLOOKUP(INDEX(loads,MATCH(Q,loads,1)+1),Max_Car_Area,2)-VLOOKUP(Q,Max_Car_Area,2))*(Q-INDEX(loads,MATCH(Q,loads,1)))/(INDEX(loads,MATCH(Q,loads,1)+1)-INDEX(loads,MATCH(Q,loads,1)))","v":2}]
[null,1200,2.8,null,20,3.13]
[null,1250,2.9,null,"Beyond 20 passengers add 0,115 m2 for each extra passenger",null,null,"`"]
[null,1275,2.95]
[null,1350,3.1]
[null,1425,3.25]
[null,1500,3.4]
[null,1600,3.56]
[null,2000,4.2]
[null,2500,5]
[null,"Beyond 2500 kg add 0,16 m2 for each extra 100 kg"]
[]
[null,"For intermediate loads the area is determined by linear interpolation"]

{"sheet":"فلکه هرزگرد","index":10,"n_rows":18,"n_cols":15,"rows_kept":18,"cut":false,"hidden":true,"merged":[[0,0,0,14],[1,2,1,14],[13,0,13,4]]}
["جرم کاهش یافته (تقریبی) فلکه ها بر اساس  تعداد شیار و قطر فلکه به کیلوگرم"]
[null,null,"قطر فلکه هرزگرد - میلی متر"]
[null,"تعداد شیار",0,240,320,330,400,410,440,480,520,540,560,580,600]
[1,3,0,6.2,9,{"$f":"E4+(G4-E4)*(F$3^2-E$3^2)/(G$3^2-E$3^2)","v":9.4513888888888893},13,{"$f":"G4+(I4-G4)*(H$3^2-G$3^2)/(I$3^2-G$3^2)","v":15.049107142857142},21.5,28,{"$f":"J4+(J4-I4)*(K$3^2-J$3^2)/(J$3^2-I$3^2)","v":35.065217391304344},{"$f":"J4+(J4-I4)*(L$3^2-J$3^2)/(J$3^2-I$3^2)","v":38.809782608695656},{"$f":"L4+(L4-J4)*(M$3^2-L$3^2)/(L$3^2-J$3^2)","v":42.695652173913047},{"$f":"M4+(M4-L4)*(N$3^2-M$3^2)/(M$3^2-L$3^2)","v":46.722826086956523},{"$f":"N4+(N4-M4)*(O$3^2-N$3^2)/(N$3^2-M$3^2)","v":50.891304347826086}]
[2,4,0,7,11,{"$f":"E5+(G5-E5)*(F$3^2-E$3^2)/(G$3^2-E$3^2)","v":11.564236111111111},16,18.169642857142858,25,32,{"$f":"J5+(J5-I5)*(K$3^2-J$3^2)/(J$3^2-I$3^2)","v":39.608695652173914},43.641304347826086,47.826086956521735,{"$f":"M5+(M5-L5)*(N$3^2-M$3^2)/(M$3^2-L$3^2)","v":52.16304347826086},{"$f":"N5+(N5-M5)*(O$3^2-N$3^2)/(N$3^2-M$3^2)","v":56.652173913043463}]
[3,5,0,7.8,12.5,13.233506944444445,19,21.290178571428573,28.5,36,44.152173913043477,48.472826086956523,52.956521739130437,57.603260869565219,62.413043478260867]
[4,6,0,8.1999999999999993,13,13.789930555555555,20,22.290178571428573,29.5,37.5,46.195652173913047,50.804347826086953,55.586956521739125,60.543478260869556,65.673913043478251]
[5,7,0,9,14.5,15.346354166666666,22,24.651785714285715,33,42,51.782608695652172,56.967391304347828,62.347826086956523,67.923913043478265,73.695652173913047]
[6,8,0,10,16,16.902777777777779,24,26.892857142857142,36,46,56.869565217391305,62.630434782608695,68.608695652173907,74.804347826086939,81.2173913043478]
[7,9,0,11,17.5,18.459201388888889,26,29.133928571428573,39,50,61.956521739130437,68.293478260869563,74.869565217391298,81.684782608695642,88.739130434782595]
[8,10,0,12,19,20.015625,28,31.375,42,54,67.043478260869563,73.956521739130437,81.130434782608702,88.565217391304358,96.260869565217405]
[9,11,0,13,20.5,21.572048611111111,30,33.616071428571431,45,58,72.130434782608688,79.619565217391312,87.391304347826093,95.445652173913047,103.78260869565217]
[10,12,0,14,22,23.128472222222221,32,35.857142857142854,48,62,77.217391304347828,85.282608695652172,93.65217391304347,102.32608695652172,111.30434782608693]
["جدول راندمان چاه بر اساس نوع کفشک"]
[null,"نوع کفشک","راندمان چاه","Guide shoe Type"]
[1,"لغزشی بی روغن",0.85,"Sliding"]
[2,"لغزشی با روغن",0.9,"Sliding with oil"]
[3,"غلطکی",0.95,"Roller"]

{"sheet":"سيم بکسلها","index":11,"n_rows":33,"n_cols":23,"rows_kept":33,"cut":false,"hidden":false,"merged":[[21,19,26,22],[0,1,0,5],[0,6,0,10],[0,11,0,14],[0,15,0,18],[0,21,0,22],[0,19,0,20],[1,9,1,10],[3,9,3,10],[2,1,2,2],[2,3,2,4],[2,5,2,6],[2,7,2,8],[2,9,2,10],[1,1,1,2],[1,3,1,4],[1,5,1,6],[1,7,1,8],[3,1,3,2],[3,3,3,4],[3,5,3,6],[3,7,3,8],[1,11,1,12],[1,13,1,14],[1,15,1,16],[1,17,1,18],[3,11,3,12],[3,13,3,14],[3,15,3,16],[3,17,3,18],[2,11,2,12],[2,13,2,14],[2,15,2,16],[2,17,2,18],[3,19,3,20],[3,21,3,22],[2,19,2,20],[2,21,2,22],[1,19,1,20],[1,21,1,22]]}
["سازنده","گوستاو ولف ",null,null,null,null,"Gustav Wolf",null,null,null,null,"فایفر دراکو",null,null,null,"PFEIFER DRAKO",null,null,null,"انواع دیگر",null,"Other"]
["مدل","F819 S-FC",null,"F819 W-FC",null,"PAWO F3",null,"PAWO F7",null,"PAWO F7 S",null,"DRAKO 8x19 S- FC",null,"DRAKO 8x19 W- FC",null,"DRAKO 210 TF",null,"DRAKO 250 T",null,"8x19S-NFC",null,"8x19S-PWRC"]
["ساختار","8x19 S - NFC 1570",null,"8x19 W - NFC 1570",null,"8x19 S - IWRC 1570",null,"8x19 W - IWRC 1570",null,"8x19 W- IWRC 1570",null,"8x19 S - NFC 1570",null,"8x19 W - NFC 1570",null,"8x19 W - IWRC 1570",null,"8x19 W - IWRC 1570",null,"8x19 S - NFC 1570",null,"8x19S- PWRC 1370/1770"]
["شرح","8x19 سیل با مغز کنفی",null,"8x19 وارینگتون با مغز کنفی",null,"سیل با مغز نیمه فولادی",null,"وارینگتون با مغز نیمه فولادی",null,"وارینگتون با مغز فولادی",null,"8x19 سیل با مغز کنفی",null,"8x19 وارینگتون با مغز کنفی",null,"وارینگتون با مغز نیمه فولادی",null,"وارینگتون با مغز فولادی",null,"8x19 سیل با مغز کنفی",null,"8x19 سیل با مغز فولادی"]
["Rope Dia","calculated mass","Minimum breaking strength","calculated mass","Minimum breaking strength","calculated mass","Minimum breaking strength","calculated mass","Minimum breaking strength","calculated mass","Minimum breaking strength","calculated mass","Minimum breaking strength","calculated mass","Minimum breaking strength","calculated mass","Minimum breaking strength","calculated mass","Minimum breaking strength","calculated mass","Minimum breaking strength","calculated mass","Minimum breaking strength"]
["mm","kg/m","kN","kg/m","kN","kg/m","kN","kg/m","kN","kg/m","kN","kg/m","kN","kg/m","kN","kg/m","kN","kg/m","kN","kg/m","kN","kg/m","kN"]
[6,null,null,null,null,null,null,null,null,0.153,25.9,null,null,null,null,null,null,0.16400000000000001,26.8,null,null,0.153,25.9]
[6.5,null,null,null,null,null,null,null,null,0.17,31.5,null,null,null,null,null,null,0.17899999999999999,31.5,null,null,0.17,31.5]
[8,0.215,30.5,0.23,32,0.24299999999999999,38,0.25800000000000001,40.6,0.28000000000000003,44.6,0.215,30.4,0.222,31.6,0.25,40,0.27300000000000002,43.3,0.217,30.5,0.26200000000000001,40.4]
[9,0.27,38.4,0.28999999999999998,40.700000000000003,0.307,48.3,0.32900000000000001,51.8,0.35599999999999998,56,0.27,38.4,0.32900000000000001,51.8,0.27,38.4,0.35599999999999998,56,0.27,38.4,0.35599999999999998,56]
[10,0.34,48.2,0.35,50,0.38500000000000001,60.5,0.40300000000000002,63.4,0.436,69.5,0.33700000000000002,47.4,0.34699999999999998,49.4,0.39,61.3,0.42299999999999999,67.7,0.33600000000000002,47.2,0.41100000000000003,63.4]
[11,0.41099999999999998,58.4,0.42,60.2,0.46500000000000002,73.400000000000006,0.48499999999999999,76.8,0.52300000000000002,83.1,0.41,57.4,0.42,59.7,0.47,76.099999999999994,0.51200000000000001,81.900000000000006,0.41600000000000004,58.6,0.504,77.400000000000006]
[12,0.48799999999999999,69.2,0.5,71.3,0.54600000000000004,86.8,0.56899999999999995,90.7,0.61899999999999999,98.9,0.48499999999999999,68.3,0.5,71.099999999999994,0.57999999999999996,88.3,0.61,97.4,0.50600000000000001,71,0.60899999999999999,93.4]
[13,0.57899999999999996,80.7,0.57999999999999996,82.5,0.65,103.1,0.67100000000000004,105,0.72699999999999998,116,0.56899999999999995,80.2,0.58599999999999997,83.4,0.66,106,0.71499999999999997,114,0.58200000000000007,81.900000000000006,0.70599999999999996,108.9]
[16,0.871,121,0.89,126.1,0.98099999999999998,154.80000000000001,1.016,160.4,1.1000000000000001,176.1,0.86099999999999999,121,0.88800000000000001,126,1,156,1.083,173,0.872,122.5,1.0649999999999999,163.6]
[]
[]
[]
[]
[]
[]
["ردیف","Type","Brand","Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"راهنمایی: در صورتیکه سیم بکسل مورد نظر در این جدول وجود ندارد میتوان با وارد کردن مشخصات سیم بکسل خاص مورد نظر در چهار ستون آخر (13)، در ورودی ها از آنها استفاده نمود. در اینصورت ارایه مستندات و مدارک مربوطه الزامی است."]
[1,"G-Wolf F819 S-FE","گوستاو ولف","8x19 سیل با مغز کنفی"]
[2,"G-Wolf F819 W-FE","گوستاو ولف","8x19 وارینگتون با مغز کنفی"]
[3,"G-Wolf PAWO F3","گوستاو ولف","8x19 سیل با مغز نیمه فولادی"]
[4,"G-Wolf PAWO F7","گوستاو ولف","8x19 وارینگتون با مغز نیمه فولادی"]
[5,"G-Wolf PAWO F7 S","گوستاو ولف","8x19 وارینگتون با مغز فولادی"]
[6,"DRAKO 8x19 S- FC","فایفر دراکو","8x19 سیل با مغز کنفی"]
[7,"DRAKO 8x19 W- FC","فایفر دراکو","8x19 وارینگتون با مغز کنفی"]
[8,"DRAKO 210 TF","فایفر دراکو","8x19 وارینگتون با مغز نیمه فولادی"]
[9,"DRAKO 250 T","فایفر دراکو","8x19 وارینگتون با مغز فولادی"]
[10,{"$f":"V1&\" \"&T2","v":"Other 8x19S-NFC"},{"$f":"T1","v":"انواع دیگر"},{"$f":"T4","v":"8x19 سیل با مغز کنفی"}]
[11,{"$f":"V1&\" \"&V2","v":"Other 8x19S-PWRC"},{"$f":"T1","v":"انواع دیگر"},{"$f":"V4","v":"8x19 سیل با مغز فولادی"}]

{"sheet":"InsCo","index":12,"n_rows":51,"n_cols":5,"rows_kept":51,"cut":false,"hidden":true,"merged":[]}
[]
[null,"نام شرکت","نشانی شرکت و تلفن","تاریخ صدور اولیه","تاریخ اعتبار گواهینامه"]
[null,"ارتقا گستر پویا","تهران","",""]
[null,"اس جی اس ایران لیمیتد","تهران ","","1399/10/10"]
[null,"اینترتک قشم","تهران","",""]
[null,"آترین طرح آزما","سنندج","1395/10/08","1398/03/30"]
[null,"آذرستاویز","تبریز","",""]
[null,"آریا فولاد قرن","اهواز","",""]
[null,"آساره پرداز پاسارگاد","بروجرد","",""]
[null,"بازرسی فنی بین المللی بازآفرینان صنعت جنوب","تهران","1394/07/14","1397/07/14"]
[null,"بازرسی فنی و کنترل بین الملل وانا خاورمیانه","کرج","1395/03/19","1398/03/19"]
[null,"بازرسی فنی و کنترل خوردگی تکین کو","تهران","",""]
[null,"بازرسی کالای تجاری IGI","تهران","1395/08/24","1398/08/24"]
[null,"بازرسی کیفیت و استاندارد ایران (ISQI)","تهران","",""]
[null,"بازرسی مهندسی ایران IEI","تهران","",""]
[null,"بازرسی مهندسی آراد پایا کیفیت آریا","تبریز","1394/07/14","1397/07/14"]
[null,"بهداد صنعت آریان خراسان","مشهد","1390/09/22","1399/07/04"]
[null,"بهینه سازان اعتماد صنعت ایرانیان","تبریز","",""]
[null,"پارس سامان طوس","مشهد","",""]
[null,"پرشین نگین اطلس"," اراک ","1394/07/14","1397/07/14"]
[null,"پویا پرتو تبریز","تبریز","",""]
[null,"پیام گستر پارس مهر","قزوین ","1396/07/24","1399/07/24"]
[null,"تعاونی خدمات فنی مهندسی مکانیک ","مشهد","1392/07/22","1398/03/19"]
[null,"خدمات بازرسی بین المللی بخرد","تهران","",""]
[null,"دیدبان سنجش امیرکبیر","اراک ","","1399/10/03"]
[null,"رهاورد صنعت البرز","تهران (واحد 2)","",""]
[null,"رهاورد صنعت البرز","قزوین"]
[null,"روشا اندیش","تهران ","","1398/03/30"]
[null,"روشاک پایا کنترل","تهران","",""]
[null,"زاگرس تطبیق کالا","تهران","(تصویر گواهینامه)","(تصویر گواهینامه)"]
[null,"ساسان صنعت پیشگام آتیه","مراغه","1395/12/22","1398/12/22"]
[null,"سروش ناظران ارم","شیراز","1395/12/22","1398/12/22"]
[null,"سورینا صنعت فردا","تبریز ","1396/10/10","1399/10/10"]
[null,"شاخه زیتون لیان","بوشهر","",""]
[null,"شالوده سنج آسیا","گرگان","1396/08/14","1399/08/14"]
[null,"صعود افروز آپادانا","شهرکرد","1396/08/14","1399/08/14"]
[null,"صعود آزمای نوین ارگ","شیراز","1395/03/19","1398/03/19"]
[null,"کاوش اندیشه رستگار","تهران","1394/07/14","1397/07/14"]
[null,"کنترل اندیش پاسارگاد","رشت","1395/03/19","1398/03/19"]
[null,"کیان رایان کیفیت گستر","تهران","1396/09/12","1399/09/12"]
[null,"کیفیت آفرینان زاگرس","یاسوج","1396/10/10","1399/10/10"]
[null,"گستر فراز","مشهد","1395/12/22","1398/12/22"]
[null,"معیار صنعت تبریز","تبریز","1394/09/07","1397/09/07"]
[null,"معیار گستر صدر","تهران","1394/08/26","1397/08/26"]
[null,"مهرگان کومش","ساری","1396/08/14","1399/08/14"]
[null,"مهندسی – صنعتی فهامه","تهران ","",""]
[null,"مهندسی اندیشه","تهران ","1393/11/27","1399/12/20"]
[null,"مهندسی اندیشه فاخر شهرکرد","شهرکرد","1394/11/10","1397/11/10"]
[null,"نظارت بر ضوابط بهداشت انسانی و استاندارد قشم","قشم ","",""]
[null,"نوآوران کیفیت پارس","تهران","","1399/07/24"]
[null,"نوین معیار آزما آپادانا","همدان ","","1399/10/24"]

{"sheet":"Hidden data","index":13,"n_rows":60,"n_cols":11,"rows_kept":60,"cut":false,"hidden":true,"merged":[[1,6,2,6],[1,7,2,7]]}
[]
[null,"Type","leaf","Rate","Factor",null,"شماره درب","موجود؟","A1","A2"]
[null,"سانترال 2 لنگه",{"$f":"45","v":45},{"$f":"0","v":0},{"$f":"Tbl_door[[#This Row],[Rate]]*Tbl_door[[#This Row],[leaf]]","v":0},null,null,null,"m2","m2"]
[null,"اتوبوسی",{"$f":"45","v":45},{"$f":"0","v":0},{"$f":"Tbl_door[[#This Row],[Rate]]*Tbl_door[[#This Row],[leaf]]","v":0},null,"درب 1",true,{"$f":"IF(H4,DD1.*DW1./1000000,0)","v":5.3999999999999999E-2},{"$f":"IF(H4,VLOOKUP(DT1.,Tbl_door[],4,0)*DW1./1000000,0)","v":2.0250000000000001E-2}]
[null,"تلسکوپی 2 لنگه",{"$f":"45","v":45},{"$f":"0.5","v":0.5},{"$f":"Tbl_door[[#This Row],[Rate]]*Tbl_door[[#This Row],[leaf]]","v":22.5},null,"درب 2",false,{"$f":"IF(H5,DD2.*DW2./1000000,0)","v":0},{"$f":"IF(H5,VLOOKUP(DT2.,Tbl_door[],4,0)*DW2./1000000,0)","v":0}]
[null,"سانترال 4 لنگه",{"$f":"45","v":45},{"$f":"0.5","v":0.5},{"$f":"Tbl_door[[#This Row],[Rate]]*Tbl_door[[#This Row],[leaf]]","v":22.5},null,"درب 3",false,{"$f":"IF(H6,DD3.*DW3./1000000,0)","v":0},{"$f":"IF(H6,VLOOKUP(DT3.,Tbl_door[],4,0)*DW3./1000000,0)","v":0}]
[null,"تلسکوپی 3 لنگه",{"$f":"45","v":45},{"$f":"(1/3+2/3)","v":1},{"$f":"Tbl_door[[#This Row],[Rate]]*Tbl_door[[#This Row],[leaf]]","v":45},null,"درب 4",false,{"$f":"IF(H7,DD4.*DW4./1000000,0)","v":0},{"$f":"IF(H7,VLOOKUP(DT4.,Tbl_door[],4,0)*DW4./1000000,0)","v":0}]
[null,"سانترال 6 لنگه",{"$f":"45","v":45},{"$f":"(2/3+1/3)","v":1},{"$f":"Tbl_door[[#This Row],[Rate]]*Tbl_door[[#This Row],[leaf]]","v":45},null,null,{"$f":"ABS(En_D1+En_D2+En_D3+En_D4)","v":1},{"$f":"ROUND(SUM(I4:I7),3)","v":5.3999999999999999E-2},{"$f":"ROUND(SUM(J4:J7),3)","v":0.02},"Sum"]
[null,"سانترال 8 لنگه",{"$f":"45","v":45},{"$f":"(3/4+2/4+1/4)","v":1.5},{"$f":"Tbl_door[[#This Row],[Rate]]*Tbl_door[[#This Row],[leaf]]","v":67.5},null,null,"Amax","ATotal","Amin"]
[null,null,null,null,null,null,null,{"$f":"Amax","v":2},{"$f":"Atotal","v":1.964},{"$f":"Amin","v":1.73}]
[null,"ِDoor_Width"]
[null,600]
[null,650]
[null,700]
[null,750]
[null,800]
[null,850]
[null,900]
[null,950]
[null,1000]
[null,1050]
[null,1100]
[null,1150]
[null,1200]
[null,1250]
[null,1300]
[null,1350]
[null,1400]
[null,1450]
[null,1500]
[null,1550]
[null,1600]
[null,1650]
[null,1700]
[null,1750]
[null,1800]
[null,1850]
[null,1900]
[null,1950]
[null,2000]
[null,2050]
[null,2100]
[null,2150]
[null,2200]
[null,2250]
[null,2300]
[null,2350]
[null,2400]
[null,2450]
[null,2500]
[null,2550]
[null,2600]
[null,2650]
[null,2700]
[null,2750]
[null,2800]
[null,2850]
[null,2900]
[null,2950]
[null,3000]

{"sheet":"Sheet1","index":14,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
[{"$f":"P+Q","v":1600}]