App that creates an income statment from a google doc or excel spreadsheet

I have a spreadsheet that has a number of columns with information about class rosters, payments and students.

I need a macro that will take that spreadsheet and create payment rosters for each of the classes with the class name, date, total owed to the instructor and a detail of the class . The application can run on Google docs or excel--I'd like to discuss the options. The data is manually pulled from a third party event registration tool, the total tuition summed and the instructors portion (a simple %) calculated. The output is a document or email (again open to discussion) that contains the class date, name of the class, class instructor, total revenue, total due instructor, some boiler plate on terms, and a listing of the the student names the amount each paid.

In discussin with one developer it is clear that I did not make it clear that the sheet has data from mutliple events. I have uploaded a new sheet with data from mulitple events. Each event needs its own statement.

added a better template

After talking to two very helpful people, its become clear this really must be a google app that creates the statement from a google spreadsheet. I know the examples I have provided are excel, but that is because it is what we have to use now. The input is the CSV file named report-11072013-1041.csv and I would like the output to look as close to the Statement template.xlsx as the limited formatting in Google allows.

thank all of you for your input and comments!

Habilidades: Contabilidade, Processamento de dados, Excel, Google App Engine

Veja mais: google. docs, google google docs, google excel spreadsheet, google excel docs, google docs is, excel google docs,, google doc, boiler, student payment excel, create google spreadsheet, email due date google spreadsheet, event spreadsheet, simple registration app, simple email macro, excel number students, excel 2013 macro, google doc spreadsheet macro, create application excel, google doc spreadsheet, app excel spreadsheet, excel create macro, macro create spreadsheet excel, app spreadsheet, simple income spreadsheet

Acerca do Empregador:
( 1 comentário ) san francisco, United States

ID do Projeto: #5104330

Concedido a:


Hi..I haved looked at details and am looking forward to work with you...I am expert in developing macros for both Excel and Google Docs..So which suits you most, I am ready....The output I will provide is in Excel form Mais

$252 USD em 3 dias
(110 Comentários)

8 freelancers are bidding on average $302 for this job


Hi Leslie, I have gone through the recently updated template and the project description. Shall provide an Excel macro based solution which will take the Excel spreadsheet (csv format) as Input and generate State Mais

$300 USD in 3 dias
(83 Comentários)

REVISED BID BASED ON ADDITIONAL INFO. Hi! The choice of the software (Google docs or excel) will depend on the use of the document. If the document is going to be used at only one location and multiple persons need Mais

$250 USD in 15 dias
(36 Comentários)

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at my feedback to know more about me and my work. Waiting for more details along with posi Mais

$444 USD in 10 dias
(20 Comentários)

hey lesliedow, we are interested. Please reply - we can discuss further. Our choice - Excel over Google DOC, Please do share the excel sheet that you are using right now. Please reply i will be back in 10 minutes. than Mais

$250 USD in 3 dias
(44 Comentários)

Hello...Would you can just click on discuss button and start chat with me..Would you like,Discuss project with [url removed, login to view] can negotiate about price,time and work. ... Let me do it......I am software engineer....Thank you..

$526 USD in 5 dias
(10 Comentários)

Hi, I am a chartered accountant and an advanced Excel expert. Consider me pls for a dianamic expert excel based system. Thank you

$250 USD in 3 dias
(18 Comentários)

***BID REVISED*** read the updated information. thanks ***I read both word report file and csv data file, and I really wish to do this job as I like automation work on excel personally.*** Respected Sir, It wo Mais

$250 USD in 2 dias
(21 Comentários)

Working with VBA excel is my passion. there is 4 years i work with it. I have automate many process in my institution here.

$421 USD in 5 dias
(2 Comentários)