GitHunt
SO

soobinrho/python-absconbest-payroll

An open-source spreadsheet compatible with both Excel and Calc; and functions for the time/payroll management.

==========================================================
Absconbest Payroll/Time Management |pyversion| |spacemacs|

Summer, 2022 This was my high school computer science project. A lot of things here do not make any sense. What does a 'time/payroll management' mean anyways? So, please beware that this project does not make a lot of sense.

Spring, 2017 An open source time/payroll management system including a spreadsheet working perfectly with both Excel and Calc; and Python functions like generating a graph and report; tested in Ubuntu 16.04 and Windows 10:

.. image:: pics/demo.gif

Installation

Ubuntu/Linux

This program requires Python and its building tools which can be installed with a terminal:

sudo apt update
sudo apt install python-dev python-pip
sudo -H pip install -U pip wheel setuptools

Finally, install our package:

sudo -H pip install absconbest-payroll

.. pip install .. --user does not install the command

Windows

Install Python here <https://www.python.org/downloads/>_. The latest version is recommended.
Python 2 requires an additional step: Open a file explorer and double click:

C:\python27\tools\scripts\win_add2path.py

Type:

[ctrl] and [x]

[a]

Now, install Python's building tools:

python -m pip install -U pip wheel setuptools

Then, install our package:

python -m pip install absconbest-payroll

Function Examples

The Python function generates a graph and report. In Ubuntu, open a terminal and type the following command:

absconbest

In Windows, run the exe file. By the way, we can move this into any folder -- e.g. Desktop.

For Python 2

C:\python27\tools\Scripts\absconbest.exe

For Python 3

C:\users\AppData\local\Programs\Python\Python3*\tools\Scripts\absconbest.exe

This function is built on the API's of Plotly (GitHub <https://github.com/plotly/plotly.py>) and
PyLatex. (GitHub <https://github.com/JelteF/PyLaTeX>
)

.. image:: pics/plotly.png
:target: https://plot.ly

Generating a report does not work without installing texLive, which is here <https://www.tug.org/texlive/acquire-iso.html>_.

.. image:: pics/pylatex.png
:target: https://github.com/JelteF/PyLaTeX

The graph and report are saved in:

~/Desktop/absconbest_payroll/output/

Moreover, the absconbest_payroll folder in Desktop has absconbest_payroll.xlsx which works well with both Microsoft Excel and Libreoffice Calc. In Ubuntu, we can open it with:

libreoffice ~/Desktop/absconbest_payroll/absconbest_payroll.xlsx

.. image:: pics/xlsx.png
:target: http://pandas.pydata.org/pandas-docs/stable/generated/pandas.read_excel.html

Contribution

Use and extend our package freely. All the Python functions and the spreadsheet are in:

.../this repository/absconbest_payroll/

Also, the Projects <https://github.com/soorho/absconbest-payroll/projects> page has the TODO list.

Developing may become easier - for developers in Linux - by using the bash script make, which is in the repository's root. It builds the source code with setuptools, installs this built package with pip, and cleans up .pyc files, .egg-info folder, and other auto-generated auxiliaries.

.../this repository/make

Ask me any question:

soobinrho@gmail.com

Uninstallation

Windows

Type:

[ctrl] and [x]

[a]

Then, on the cmd:

python -m pip uninstall absconbest-payroll -y

Finally, delete the absconbest_payroll folder in Desktop.

Ubuntu

sudo -H pip uninstall absconbest-payroll -y
rm -rf ~/Desktop/absconbest-payroll/

.. |spacemacs| image:: https://cdn.rawgit.com/syl20bnr/spacemacs/442d025779da2f62fc86c2082703697714db6514/assets/spacemacs-badge.svg
:target: http://spacemacs.org

.. |license| image:: https://img.shields.io/github/license/soorho/absconbest-payroll.svg
:target: https://github.com/soorho/absconbest-payroll/blob/master/license.txt

.. |pyversion| image:: https://img.shields.io/badge/python-2%2C%203-green.svg
:target: https://www.python.org/downloads/

|
|
|