June 14, 2016

Free Attendance Tracking System- Consumerfed Deepa Accounts manager


Online Attendance Monitoring System IT Section


          Created a robust G suite application for consumerfed regional office kozhikode (attendance monitoring system), which helps multiple users can mark their attendance simultaneously through a google form. The form is linked with a google spreadsheet where all the responses are saved which can be viewed in real time. The google spreadsheet is designed in such a way that the monitoring users can only view present day report. The attendance is mailed daily both as html and pdf format. Once in every month the google script will automatically back up the spreadsheet in google drive.

         The Google form and spreadsheet works only on javascript enabled web browsers.

         Maximum number of rows allowed is approximately 4 lakhs and the 250 sheets on google spreadsheet. Maximum of 15GB space is allowed in google drive.

contact number : 8281 8080 29, mail us




History

The project was initially developed in 2015 November for Regional office kozhikode Regional Manager then new features was added in 2016 September and application was very much active during that period, New features like consolidation, tracking, automatic error tracking etc were included.

Consumerfed I T Section

Google Form


A Google Form is a tool from google that allow you to collect the information in an easy way to a google spreadsheet

Tutorial

Google Form - UI through which end users enter the data

link to google form


Google Spreadsheet


Each and every information entered by employees is kept in spreadsheet , but the view is restricted to that day. Downloading the sheet helps you view all the data from starting

Tutorial


GOOGLE SPREADSHEETS
link to google spreadsheet


Google Script - Script Editor


GOOGLE SCRIPT CODE

How script Editor works


Go To Tools >> Script Editor in google spread sheet.

Select any function then click on run command. For example if you want to send an email with pdf, go to script editor, choose the function mailLeaveDetails() from the combo box, then click on run command. An email will be send to the mail described in the controller spreadsheet

SCRIPT EDITOR

Google script failure alert



E mail while script error

Google controller Spreadsheet


Google controller spread sheet act as a property value sheet where the admin can control all the attendance works like e mail address to which the mail should be send, the subject of the email, the footer etc. He can also stop the mail sending by giving property value as NO.

CONTROLLER SPREADSHEET
link to controller spreadsheet



Flow chart (context level)




DATA FLOW

Backup in google drive


Backup of spreadsheet is done automatically on first day of the month in office google drive.


BACKUP IN GOOGLE DRIVE

Emailing attendance information directly on google form submit


E-mail template for attendance


Smart monitoring of Cfed Attendance


Monitoring the attendance application using a third party smart apps let us know when the server is down and how long the server being down. Help us to identify the fake complaints

Cfed Attendance

Email information regarding the up and down time of attendance application


E mail while attendance apps is down

Google Spreadsheet attendance tracking system



Attendance Reporting google sheet

link to sheet


Automatic consolidation spreadsheet

         
           Google consolidation sheet will consolidate the entered attendance details automatically

Consolidation sheet

Link to google spreadsheet


Sample consolidation excel sheet


Automatic deletion of duplicate entries

         There is a script running on the background of the sheet that will track the duplicate entries on the particular day and automatically delete the first entered value. A separate sheet 'INFORMATIONS' is kept , where all details regarding such automatic operation summaries is kept.


Google script sample

Graphical representation of Attendance Status


Pie chart showing attendance percentage in our region

Pie chart showing branch attendance status


Pie chart showing employees attendance status



Download file here





Message Me Here


E-mail templates

List of employees who fails to mark attendance on the day


E mail to IT head informing the employees who fails to mark the attendances on that day

Employee list who forget to mark attendances

Daily consolidation E mail


Sending attendance status daily consolidated email to IT Head

email template
E mail Template


Direct Email


E mail directly to office mail who mark attendance after noon

E mail templates
Automatic update details

Attendance consolidation for salary 


sample consolidation report
link to video



Email Report to users





Attendance form created by Regional Office Kozhikode IT Section. +Consumerfed IT Division



☺☺☺☺☺☺☺☺☺☺☺☺☺☺☺

CONSUMERFED KOZHIKODE WEBSITE

Issues and solutions



Download documentation

Kerala State Rule Leave Details

Thanks to +rasmi pramod , +Shimjith Kumar , +Vipin Cp for their valuable supports

Thanks to IT section Head office for Assigning this project

Today's Attendance Status





Google App Script Complete Tutorial

http://javabelazy.blogspot.in/

How to sum up table into one in excel

Consolidate in Excel

Description : Excel Consolidate helps you to consolidate your sheets/worksheets into one worksheet.
 Here we are going to consolidate 3 sheets unit1 , unit2 and unit3 to one sheet. the three sheets are shown below. Excel tips and tricks by +belazy .

Date : Jun 14

How to sum up all the data in separates sheet into one



Receipts and Disbursement
Receipts and Disbursement

Receipts and Disbursement of a single unit

Receipts and Disbursement
Receipts and Disbursement




Receipts and Disbursement
Receipts and Disbursement

Now click on the consolidate icon, it will be available in Data tab in excel 2010.



 A window will be open now, choose function as Sum (here we are going to sum up all the sheets)


click on the reference, choose the data table in sheets ancd click on add





check Top row & Left Column.


Consolidate Sheet

Consolidated excel sheet


To view the video tutorial : click here







To Know more about Cash Receipts and Cash Disbursement method in accountancy click here


Where to use : 



Author : +belazy

Thanks to +deepajayaprakash payyanakkal , +Shimjith , +bithesh, +Vipin Cp   for their supports






http://javabelazy.blogspot.in/

June 13, 2016

CONSUMERFED TRIVENI REGIONAL OFFICE KOZHIKODE

CONSUMERFED IT-ACCOUNTS SECTION KOZHIKODE


Attendance Working Demo 




Loading and unloading spreadsheet



Sales entering spreadsheet apps for accounts section


Attendance monitoring system - editing




Preparing budget  - accounts section kozhikode





Excel consolidation for R & D preparation  - accounts section kozhikode






For salary consolidation   - administration section consumerfed kozhikode




Employee Management System   - information technology section consumerfed kozhikode




Foreign Liquor Shop Attendance Marking System Consumerfed Kozhikode




Visit our channel

Thanks to Regional Manager, deepa, jisha, rasmi, remya. shimjith, ashref, jerin , vipin and all triveni employees for their supports


http://javabelazy.blogspot.in/

June 07, 2016

Hotel Management System - Travel Port

https://www.youtube.com/watch?v=QnQvC8UOTWE



https://www.youtube.com/channel/UC9KIf2hU7ROZQQtHdnzPBDQ



Adding to cart scenerios

scenerio 1

subtracting add to cart from inventory

if there are 10 items in stock,

5 persons added 2 each to cart then 6 th person could see out of stock issue...

scenerio 2

if not subtracted

1 items left, one person A add it to cart and the second one B purchased it,

A will get out of stock error while purchasing it

One solution

1. The customer puts a product in her cart.
2. Event is fired and the plugin stores the WC_Cart id (which holds the products) with a timestamp in a table.
3. Stock is then temporarily reduced by the plugin.
4. A cronjob (registered via. wp_cron) checks the table with carts and timestamps and resets the stock for old carts and removes the row from the table.




https://github.com/woocommerce/woocommerce/issues/5966


apply
minimum option to skip check
and
holding time

discussion : https://github.com/woocommerce/woocommerce/issues/5966

is there any procedure after add to cart like adding user details ?


https://www.datascience.com/resources/notebooks/dynamically-pricing-hotel-rooms-with-data-science

http://www.amadeus.com/blog/26/09/dynamic-pricing-way-forward-maximise-airline-revenue/




Facebook comments