Skip to content

Instantly share code, notes, and snippets.

@Opiprog
Opiprog / Kivy_HelloWorld.py
Created November 25, 2017 23:31
Kivy - Hello World
import kivy
from kivy.app import App
from kivy.uix.label import Label
class MyApp(App):
def build(self):
return Label(text='Hello world')
@Opiprog
Opiprog / gist:8bb6f491578d4f23540ccd98e85288c3
Created December 6, 2016 12:45
Convert xls to xlsx using Windows cmd
# Open a command prompt in windows and type the following
# This open the excelcnv.exe from the Office15 folder and converts MyFile.xls (from the in folder) to MyFile.xlsx (to the out folder)
"C:\Program Files (x86)\Microsoft Office\Office15\excelcnv.exe" -oice "C:\in\MyFile.xls" "C:\out\MyFile.xlsx”
Index Axial Load FE AA IE
0 70 25 3 -10
1 195.9902 24.97371961 3.235454367 -9.992665938
2 400.7797 24.89494269 3.470092195 -9.97068168
3 773.9403 24.76386181 3.703099776 -9.934100971
4 1254.5773 24.58079744 3.933669057 -9.88301324
5 1760.8765 24.34619711 4.161000441 -9.81754338
6 2173.2502 24.06063434 4.384305557 -9.737851445
7 2404.0408 23.72480725 4.602809999 -9.644132256
8 2537.4333 23.33953682 4.815756011 -9.536614927
Sub CopyData()
Dim i As Long
Dim j As Long
i = 0
j = 1
Header = Range("A" & (1 + (258 * i)))
@Opiprog
Opiprog / UpdateCycleNum
Last active January 1, 2016 17:09
Excel VB Macro - Updating cycle numbers
Sub UpdateCycleNum()
Dim CellSelect As Long
Dim CycAdd As Long
Dim rng As Range
CellSelect = 1000
CycAdd = 67000
'Set the range in column A you want to loop through
@Opiprog
Opiprog / gist:6039573
Created July 19, 2013 14:38
Solving ODE in Python
from scipy.integrate import odeint
from pylab import * # for plotting commands
def deriv(y,t): # return derivatives of the array y
a = -2.0
b = -0.1
return array([ y[1], a*y[0]+b*y[1] ])
time = linspace(0.0,10.0,1000)
yinit = array([0.0005,0.2]) # initial values
@Opiprog
Opiprog / gist:5685296
Last active December 17, 2015 22:49
Useful LaTex codes
%%%%%%% (1) ADDING HQ IMAGES TO LatexPDF %%%%%%
% The best ways I have found are through PDF or EPS formats (i.e. vector formats)
% Avoid bitmaps.
% NEVER WORK IN MS POWERPOINT! Can't export .EPS formats, only horrible bitmaps. Use OPEN OFFICE instead.
\usepackage{epstopdf}
%%%%%%% (2) SUBSCRIPT AND SUPERSCRIPT TOGETHER %%%%%%%
@Opiprog
Opiprog / gist:5649126
Created May 25, 2013 13:55
Latex Reference Problem
@article{AliMao,
author = "M. Ali and K. Mao",
title = "Modelling of hip resurfacing device contact under central and edge loading conditions",
journal = "Lecture Notes in Engineering and Computer Science: Proceedings of The World Congress on Engineering",
year = "2012",
key = "key",
volume = "Volume 20, Issue 4",
number = "number",
pages = "2054-2059",
month = "July",
@Opiprog
Opiprog / gist:5607808
Created May 19, 2013 14:26
Managing cells in LaTex tables
\documentclass[10pt,compsoc]{IEEEtran}
\usepackage{fixltx2e}
\begin{center}
\begin {table}
\caption{ABC}
\begin{tabular}{|c|c|c|c|c|}
@Opiprog
Opiprog / gist:5518060
Last active December 17, 2015 00:00
Math in Iptyhon
L = 500
Xi = [0,0.1,0.2,0.3,0.4,0.5,0.6,0.7,0.75,0.8,0.85,0.9,0.92,0.94,0.96,0.98,0.99]
ai = [1,1.07,1.15,1.242,1.351,1.486,1.661,1.905,2.072,2.292,2.6,3.093,3.396,3.824,4.508,5.937,7.774]
bi = [1,0.936,0.878,0.822,0.769,0.717,0.664,0.608,0.578,0.544,0.507,0.461,0.438,0.412,0.378,0.328,0.287]
li = [0.75,0.748,0.743,0.734,0.721,0.703,0.678,0.644,0.622,0.594,0.559,0.51,0.484,0.452,0.41,0.345,0.288]
X = np.array(Xi)
a = np.array(ai)
b = np.array(bi)