%~dp0
resolves to the full path of the folder in which the batch script resides.
Excel Expanding Reference or Expanding Range
=SUM($C$4:C4) // D4 =SUM($C$4:C5) // D5 =SUM($C$4:C6) // D6
References
https://exceljet.net/glossary/expanding-reference
=SUM($C$4:C4) // D4 =SUM($C$4:C5) // D5 =SUM($C$4:C6) // D6
References
https://exceljet.net/glossary/expanding-reference
from bokeh.sampledata.glucose import data from bokeh.plotting import figure, show, output_file from bokeh.models import BoxAnnotation output_file("box_annotation.html", title="box_annotation.py example") TOOLS = "pan,wheel_zoom,box_zoom,reset,save" #reduce data size data = data.loc['2010-10-06':'2010-10-13'] p = figure(x_axis_type="datetime", tools=TOOLS) p.line(data.index.to_series(), data['glucose'], line_color="gray", line_width=1, legend_label="glucose") low_box = BoxAnnotation(top=80, fill_alpha=0.1, fill_color='red') mid_box = BoxAnnotation(bottom=80, top=180, fill_alpha=0.1, fill_color='green') high_box = BoxAnnotation(bottom=180, fill_alpha=0.1, fill_color='red') p.add_layout(low_box) p.add_layout(mid_box) p.add_layout(high_box) p.title.text = "Glucose Range" p.xgrid[0].grid_line_color=None p.ygrid[0].grid_line_alpha=0.5 p.xaxis.axis_label = 'Time' p.yaxis.axis_label = 'Value' show(p)
References
https://docs.bokeh.org/en/latest/docs/user_guide/annotations.html#box-annotations
from datetime import datetime as dt import time from bokeh.sampledata.daylight import daylight_warsaw_2013 from bokeh.plotting import figure, show, output_file from bokeh.models import Span output_file("span.html", title="span.py example") p = figure(x_axis_type="datetime", y_axis_type="datetime") p.line(daylight_warsaw_2013.Date, daylight_warsaw_2013.Sunset, line_dash='solid', line_width=2, legend_label="Sunset") p.line(daylight_warsaw_2013.Date, daylight_warsaw_2013.Sunrise, line_dash='dotted', line_width=2, legend_label="Sunrise") start_date = time.mktime(dt(2013, 3, 31, 2, 0, 0).timetuple())*1000 daylight_savings_start = Span(location=start_date, dimension='height', line_color='green', line_dash='dashed', line_width=3) p.add_layout(daylight_savings_start) end_date = time.mktime(dt(2013, 10, 27, 3, 0, 0).timetuple())*1000 daylight_savings_end = Span(location=end_date, dimension='height', line_color='red', line_dash='dashed', line_width=3) p.add_layout(daylight_savings_end) p.title.text = "2013 Sunrise and Sunset times in Warsaw" p.yaxis.axis_label = 'Time of Day' show(p)
References
http://docs.bokeh.org/en/latest/docs/user_guide/annotations.html#spans
https://stackoverflow.com/questions/39426976/how-to-add-horizontal-line-span-to-the-box-plot-in-bokeh
https://stackoverflow.com/questions/28797330/infinite-horizontal-line-in-bokeh
from datetime import datetime now = datetime.now() # current date and time year = now.strftime("%Y") print("year:", year) month = now.strftime("%m") print("month:", month) day = now.strftime("%d") print("day:", day) time = now.strftime("%H:%M:%S") print("time:", time) date_time = now.strftime("%m/%d/%Y, %H:%M:%S") print("date and time:",date_time)
References
https://www.programiz.com/python-programming/datetime/strftime
p.toolbar.logo = None p.toolbar_location = None
References
https://stackoverflow.com/questions/32158939/python-bokeh-remove-toolbar-from-chart
nano /etc/apache2/apache2.conf
Change the AllowOverride
None
to AllowOverride
All
.
References
https://stackoverflow.com/questions/13149418/the-requested-url-about-was-not-found-on-this-server
worksheet.sheet_view.rightToLeft = True
References
https://stackoverflow.com/questions/25106897/python-openpyxl-display-left-to-right
%~dp0\bin\Iris.exe
%~dp0
resolves to the full path of the folder in which the batch script resides.
Or
venv\Scripts\python.exe main.py
References
https://stackoverflow.com/questions/14936625/relative-path-in-bat-script/14942944
SUMIF(range, criteria, [sum_range])
range Required. The range of cells that you want evaluated by criteria. Cells in each range must be numbers or names, arrays, or references that contain numbers. Blank and text values are ignored. The selected range may contain dates in standard Excel format (examples below).
criteria Required. The criteria in the form of a number, expression, a cell reference, text, or a function that defines which cells will be added.
sum_range Optional. The actual cells to add, if you want to add cells other than those specified in the range argument. If the sum_range argument is omitted, Excel adds the cells that are specified in the range argument (the same cells to which the criteria is applied).
References
SUMIF function
Excel SUMIF Function
How to use SUMIF in Excel – formula examples to conditionally sum cells
Method 1 : Create Name Range using Name Box
Delete Name Range using Name Manager
Method 2 : Create Name Range using Name Manager
Method 3 : Create Name Range using Define Name
Edit Name Range using Name Manager
References
https://support.office.com/en-us/article/define-and-use-names-in-formulas-4d0f13ac-53b7-422e-afd2-abd7ff379c64
https://exceljet.net/glossary/named-range
https://www.ablebits.com/office-addins-blog/2017/07/11/excel-name-named-range-define-use/