Total number of elements required to build Phobos

<%@ LANGUAGE="VBScript" %> <% Set Connection = Server.CreateObject("ADODB.Connection") Connection.Mode = adModeRead Connection.Open phdb_rd SQLStmt1 = "select sensor_type st,install_arm1 ia1,spare_arm1 sa1,install_arm2 ia2,spare_arm2 sa2 from sitester.sensor_required order by sensor_type" Set RS1 = Connection.Execute(SQLStmt1) SQLStmt2 = "select asm_hybrid_type ht,install_arm1 ia1,spare_arm1 sa1,install_arm2 ia2,spare_arm2 sa2 from assembly.hybrid_required order by asm_hybrid_type" Set RS2 = Connection.Execute(SQLStmt2) SQLStmt3 = "select mod_type mt,install_arm1 ia1,spare_arm1 sa1,install_arm2 ia2,spare_arm2 sa2 from assembly.module_required order by mod_type" Set RS3 = Connection.Execute(SQLStmt3) %> Total number of elements required to build Phobos

Number of elements required to build Phobos

Note: these are preliminary numbers, I expect the subsystem managers to update these numbers asap !

Follow this link for updated details on the spectrometer components and readout chips for ONE and TWO ARMS

The numbers printed on this page are taken from Oracle Tables where I enter by hand the numbers of installed and spare elements. I would like to use these tables to prepare status summaries, plots etc. I already use these numbers in the display of silicon batches.

The calculations assume two possible scenarios:

Phobos has only one spectrometer arm (this is the goal for November 1, 1999)
Phobos has two spectrometer arms

The number of installed elements is double for spectrometer elements and it is the same for multiplicity and vertex detectors. The number of spares is calculated by the sybsystem managers according to some algorithm which is clearly not linear.

Silicon Sensors:

<% Do While Not RS1.EOF %> <% RS1.Movenext Loop %>

	One Arm Phobos			Two Arm Phobos
Sensor Type	Installed	Spare	Total	Installed	Spare	Total
<%=Sensor_Name(RS1("st"),2)%>	<%=RS1("ia1")%>	<%=RS1("sa1")%>	<%=Cint(RS1("ia1"))+Cint(RS1("sa1"))%>	<%=RS1("ia2")%>	<%=RS1("sa2")%>	<%=Cint(RS1("ia2"))+Cint(RS1("sa2"))%>

Hybrids:

<% Do While Not RS2.EOF %> <% RS2.Movenext Loop %>

	One Arm Phobos			Two Arm Phobos
Hybrid Type	Installed	Spare	Total	Installed	Spare	Total
<%=RS2("ht")%>	<%=RS2("ia1")%>	<%=RS2("sa1")%>	<%=Cint(RS2("ia1"))+Cint(RS2("sa1"))%>	<%=RS2("ia2")%>	<%=RS2("sa2")%>	<%=Cint(RS2("ia2"))+Cint(RS2("sa2"))%>

Modules:

<% Do While Not RS3.EOF %> <% RS3.Movenext Loop %>

	One Arm Phobos			Two Arm Phobos
Hybrid Type	Installed	Spare	Total	Installed	Spare	Total
<%=RS3("mt")%>	<%=RS3("ia1")%>	<%=RS3("sa1")%>	<%=Cint(RS3("ia1"))+Cint(RS3("sa1"))%>	<%=RS3("ia2")%>	<%=RS3("sa2")%>	<%=Cint(RS3("ia2"))+Cint(RS3("sa2"))%>

<% Connection.Close %>