En cours

Data Formatting and Minor Calculations

Programming Excel and CSV, macro and scripting. We have a CSV file generated from one program and need to upload it into another program with some minor modifications. The file attached here is a typical CSV file that is generated first. It contains a list of tenants and individual current charges that are on their accounts, plus any payments that had been made. We need to keep these individual charges listed, so we need to keep the multiple lines per tenant when applicable. We need an additional column added on the end labeled "Total Amount Due" where it contains the sum of these charges. There should be one Total Amount Due figure for each tenant.

Compétences : Programmation

Voir plus : excel 2016 pivot date format, what is the difference between integer and real data type, boolean data type definition, rename row labels in pivot table, integer data type definition, real data type example, change default pivot table settings, change field names in pivot table source data, excel data programming, data programming, core data programming guide, computer programming current events, big data programming languages, big data programming, big data programming language

Concernant l'employeur :
( 1 commentaire ) Farmington, United States

N° du projet : #14830398

Décerné à :

49 $ USD en 1 jour
(18 Commentaires)
3.8

21 freelance ont fait une offre moyenne de 97 $ pour ce travail

TexToFit

hi there i am interested in yours project, I have some questions about your final program where i will run CSV. Relevant Skills and Experience i am skilled web developer working on web development solution and web ap Plus

55 $ USD en 3 jours
(4 Commentaires)
3.6
cgullapalli

Hi, I am good at Excel and vba. I just checked the description and would be a pleasure to assist you on your project. Looking forward to discuss in the chat. -Chandra Relevant Skills and Experience Excel vba, advanced Plus

50 $ USD en 1 jour
(2 Commentaires)
3.6
dpune

Format data in CSV file using VBA script Relevant Skills and Experience Excel/VBA/CSV Proposed Milestones $100 USD - Completed macro Hello, I Have more than 14 years of exp. Completed 320+ projects. Look at my feedb Plus

100 $ USD en 3 jours
(1 Commentaire)
2.4
insidenetsoft

Hi, Importing all the files from a location and process them based on some configurable parameters was a similar tool that I developed with success and helped me create a friendly relationship with recurrent tasks. I Plus

30 $ USD en 1 jour
(5 Commentaires)
1.2
155 $ USD en 3 jours
(0 Commentaires)
0.0
40 $ USD en 1 jour
(0 Commentaires)
0.0
jasonclement0

You want a total amount due column added that is just a sum of the total for each individual tenant. Relevant Skills and Experience Programming in Excel for 18 years. Proposed Milestones $35 USD - Project Completed Plus

35 $ USD en 1 jour
(0 Commentaires)
0.0
srinichal

I am an expert in delivering custom scripts and softwares Relevant Skills and Experience proven track record on this site Proposed Milestones $222 USD - milestone

222 $ USD en 5 jours
(0 Commentaires)
0.0
40 $ USD en 2 jours
(0 Commentaires)
0.0
wasifmustafa

Hi. I have completed a quick draft for your review [url removed, login to view] Relevant Skills and Experience Over 16 years of excel formulas and vba/macros. Right now it puts total d Plus

75 $ USD en 3 jours
(0 Commentaires)
0.0
155 $ USD en 3 jours
(0 Commentaires)
0.0
lkhelladi

hello, i'd be glad to program the desired csv processing software using python. looking forward to chat with you soon for more details. best regards, Relevant Skills and Experience python, CSV Proposed Milestone Plus

155 $ USD en 3 jours
(0 Commentaires)
0.0
danielaistrop

Professionally experienced parsing large *.csv files into Excel spreadsheets containing substance and chemical data from GM data sources through Visual Basic subs and functions. Relevant Skills and Experience Visua Plus

200 $ USD en 1 jour
(0 Commentaires)
0.0
kashivw

Veteran (25+ years) IT developer Done several CSV/XML/JSON type projects here and on Upwork No gas, no tall talk - simple working code delivery Relevant Skills and Experience 15+ years with several databases (SQL Serv Plus

100 $ USD en 1 jour
(0 Commentaires)
0.0
111 $ USD en 3 jours
(0 Commentaires)
0.0
ctate

I can do one of two things. 1. Provide the macro which requires you to open Excel to perform the conversion. 2. Make a windows application to perform the conversion with a file selector. Relevant Skills and Experience Plus

70 $ USD en 3 jours
(0 Commentaires)
0.0
50 $ USD en 3 jours
(0 Commentaires)
0.0
steve26larson

Generate what is needed for the csv file Relevant Skills and Experience Have generated many csv files in the past using PHP Proposed Milestones $30 USD - generate new csv file

30 $ USD en 2 jours
(0 Commentaires)
0.0
virals2583

Hello, I am from Maven Infotech ([url removed, login to view]). I have more than 12 years of experience in PHP, C#/VB .Net Web Applications. & have 70+ reviews. I have read your requirement to work on Excel, macros an Plus

222 $ USD en 5 jours
(0 Commentaires)
0.0
narsim3128

With respect to this project I would like to present myself as a candidate for your consideration. I have more than 8 years of IT experience. I have successfully completed few projects for US clients Relevant Skills a Plus

100 $ USD en 3 jours
(0 Commentaires)
0.0