Graphics, Figures & Tables ⇒ Adding numbers in Last column for expense calculator

[mayankmi]

I am making a expense calculator which keeps record of expenses. However i want it to add automatically in total row in the end of table.

Code: Select all

\documentclass{article} % Use the custom invoice class (invoice.cls)
\usepackage{booktabs}
\usepackage{calc}
\usepackage{eurosym}
\usepackage{amstext}
\usepackage{xcolor,colortbl}

\newcommand{\mc}[2]{\multicolumn{#1}{c}{#2}}
\definecolor{Gray}{gray}{0.85}
\definecolor{LightCyan}{rgb}{0.88,1,1}
\definecolor{march}{rgb}{0.3,0.6,0.5}
\newcolumntype{a}{>{\columncolor{Gray}}c}
\newcolumntype{b}{>{\columncolor{white}}c}




\usepackage[a4paper,margin=20mm]{geometry}
\usepackage{eso-pic,xcolor,lipsum,calc}

\newlength\myborder
\myborder=20pt%please adjust the border width :-)


\pagecolor{Gray}%please change it back to black :-)

\AddToShipoutPictureBG
{%
    \AtPageLowerLeft
    {%
        \color{white}%
    \hspace{\myborder}%
    \rule[\myborder]{\paperwidth-2\myborder}{\paperheight-2\myborder}%
  }%
}





\begin{document}

%----------------------------------------------------------------------------------------
%	HEADING SECTION
%----------------------------------------------------------------------------------------

\hfil{\Huge\bf Expense Tracker}\hfil % Company providing the invoice
\bigskip\break % Whitespace
\hrule % Horizontal line
\vspace{5mm}


\begin{tabular}{p{1.5in} p{3in} a}
\toprule 
DAY   & TYPE OF EXPENSE & PRICE (\euro) \\
\midrule 
MONDAY     & ITEM xx    & 1.05      \\\midrule
TUESDAY     & ITEM xy   & 0.45      \\\midrule
WEDNESDAY      &  ITEM wx    & 0.45      \\
WEDNESDAY      &  ITEM xqx   & 0.80      \\\midrule
Thrusday      &  ITEM xex & 0.50      \\\midrule 
& Total      & 8.54 (xx.yy \euro /day )      \\\bottomrule\bottomrule
\end{tabular}



\end{document}

[alainremillard]

Have a look at the spreadtab package.

[mayankmi]

Thanks ...