Sub calculateCDF()
'
' caculateCDF Macro
'
'
Range("M2").Select
Selection.EntireRow.Delete
Do While Range("M2").Value < 1 And Not IsEmpty(Range("M2"))
Range("M2").Select
Selection.EntireRow.Delete
Loop
If IsEmpty(Range("M2")) Then
Exit Sub
End If
Dim row As Integer
row = Range("M2").End(xlDown).row
Do While Cells(row, 13).Value < 1 And Not IsEmpty(Cells(row, 13)) And row > 2
Cells(row, 13).Select
Selection.EntireRow.Delete
Loop
Range("O1").Select
ActiveCell.FormulaR1C1 = "Range to plot from"
Range("O2").Select
ActiveCell.FormulaR1C1 = "Number of bins"
Range("O3").Select
ActiveCell.FormulaR1C1 = "Max of Range"
Range("O4").Select
ActiveCell.FormulaR1C1 = "Min of Range"
Range("O5").Select
ActiveCell.FormulaR1C1 = "Bin size"
Range("O7").Select
ActiveCell.FormulaR1C1 = "Average"
Range("O8").Select
ActiveCell.FormulaR1C1 = "Variance"
Range("O9").Select
ActiveCell.FormulaR1C1 = "Standard deviation"
Range("Q1").Select
ActiveCell.FormulaR1C1 = "wkB/s"
Range("R1").Select
ActiveCell.FormulaR1C1 = "SR Disk BW CDF"
Range("P1").Select
ActiveCell.FormulaR1C1 = "H2:H1502"
Range("P2").Select
ActiveCell.FormulaR1C1 = "50"
Range("P3").Select
ActiveCell.FormulaR1C1 = "=Max(INDIRECT(R[-2]C))"
Range("P4").Select
ActiveCell.FormulaR1C1 = "=MIN(INDIRECT(R[-3]C))"
Range("P5").Select
ActiveCell.FormulaR1C1 = "=(R[-2]C-R[-1]C)/R[-3]C"
Range("P7").Select
ActiveCell.FormulaR1C1 = "=AVERAGE(INDIRECT(R[-6]C))"
Range("P8").Select
ActiveCell.FormulaR1C1 = "=VAR(INDIRECT(R[-7]C))"
Range("P9").Select
ActiveCell.FormulaR1C1 = "=STDEV(INDIRECT(R[-8]C))"
Range("Q2").Select
ActiveCell.FormulaR1C1 = "=R[2]C[-1]"
Range("Q3").Select
ActiveCell.FormulaR1C1 = "=R[-1]C+R5C16"
Range("Q3").Select
Selection.AutoFill Destination:=Range("Q3:Q52"), Type:=xlFillDefault
Range("R2").Select
ActiveCell.FormulaR1C1 = _
"=IF(RC[-1]>=R3C16,1,PERCENTRANK(INDIRECT(R1C16),RC[-1]))"
Range("R2").Select
Selection.AutoFill Destination:=Range("R2:R52"), Type:=xlFillDefault
ActiveSheet.Shapes.AddChart.Select
ActiveChart.SetSourceData Source:=ActiveSheet.Range("$O$1:$R$52")
ActiveChart.ChartType = xlLine
ActiveChart.SeriesCollection(2).Delete
ActiveChart.SeriesCollection(1).Delete
ActiveChart.SeriesCollection(1).Delete
ActiveChart.SeriesCollection(1).XValues = "='sr151_sdc'!$Q$2:$Q$52"
ActiveChart.Legend.Select
Selection.Delete
ActiveChart.SetElement (msoElementPrimaryCategoryAxisTitleAdjacentToAxis)
ActiveChart.ChartTitle.Characters.Text = "SSD SR Disk BW (" & ActiveSheet.Name & ")"
ActiveChart.Axes(xlCategory).AxisTitle.Select
ActiveChart.Axes(xlCategory).AxisTitle.Characters.Text = "wkB/s"
End Sub
Sub DrawDiskCDF()
For Each persheet In ActiveWorkbook.Sheets
sheetname = persheet.Name
If sheetname <> "Config" And sheetname <> "requests" And sheetname <> "utilization" And sheetname <> "throughput" Then
persheet.Select
persheet.Activate
calculateCDF
End If
Next
分享到:
相关推荐
CSW_PLOT_GRAPH_PYTHON 使用PyCharm 2021.1(社区版)构建运行时版本:11.0.10 + 9-b1341.35 amd64 Python 3.9
plot 教程plot 教程plot 教程plot 教程plot 教程plot 教程plot 教程plot 教程plot 教程
graph plot in mat lab for the training data set.
这是如何在 MATLAB:registered: 中创建图形的... 阅读 MATLAB 文档中的“graph”函数。 此功能在 R2015b 或更新版本中可用。 有关更多示例,请转到 MATLAB 绘图库 - http://www.mathworks.com/discovery/gallery.html
plot 例子plot 例子plot 例子plot 例子plot 例子plot 例子plot 例子
本代码主要利用MATLAB工具实现MATLAB——plot绘图,简单明了,易于理解
grPlot - draw the plot of the graph (digraph); grShortPath - solve the shortest path problem for the digraph; grShortVerPath - for digraph with weighted vertexes solve the problem about the path ...
matlab开发-SampleEntropy。这是一个用于计算样本熵的.c文件。你得把它弄好。
1. plot(x,y); %x y 为相应点集 2.plot(x,y1,x,y2); % 在一个窗口下绘制多条曲线之方法一 3.hold on %在一个窗口下绘制多条曲线之方法二 plot(x,y1); plot(x,y2); hold off 4.plot后 xlabel('x_axis_name...
plot函数的各种调用方法 ① plot(Y) :若Y 为实向量,则以该向量元素的下标为横坐标,以Y 的各元素值为纵 坐标,绘制二维曲线; >> A=0:0.05:5; >> plot(A); 运行结果: ② plot(X,Y) :若X 、Y 为长度相等的向量...
详细的介绍了MATlab中的plot函数的用法,非常仔细,全面
在matlab中,使用plot画图实例,能熟练掌握使用plot进行画图
Opencv中似于plot的函数 iplimage类型plot 类
matlab_plot函数用法 matlab_plot函数用法 matlab_plot函数用法 matlab_plot函数用法 matlab_plot函数用法 matlab_plot函数用法
MathWorks Plot Gallery Team 推出的公开绘图示例代码,基本涵盖了主要的图形表现手段
电子书,maple里关于plot函数包的介绍
MATLAB中plot函数中文帮助,文档对plot函数做了详细的说明,包含了plot函数的各种用法
CorePlot 1.0 饼图 demo
包括关于plot函数的text title legend
本代码主要利用MATLAB工具实现MATLAB——semilogx函数和plot函数指令对比,简单明了,易于理解