I gang

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.

Færdigheder: Programming

Se mere: 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

Om arbejdsgiveren:
( 1 bedømmelse ) Farmington, United States

Projekt-ID: #14830398

Tildelt til:

$49 USD på 1 dag
(18 bedømmelser)
3.8

21 freelancere byder i gennemsnit $97 for dette job

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 Mere

$55 USD in 3 dage
(4 bedømmelser)
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 Mere

$50 USD på 1 dag
(2 bedømmelser)
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 Mere

$100 USD in 3 dage
(1 bedømmelse)
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 Mere

$30 USD på 1 dag
(5 bedømmelser)
1.2
$155 USD in 3 dage
(0 bedømmelser)
0.0
$40 USD på 1 dag
(0 bedømmelser)
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 Mere

$35 USD på 1 dag
(0 bedømmelser)
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 in 5 dage
(0 bedømmelser)
0.0
$40 USD in 2 dage
(0 bedømmelser)
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 Mere

$75 USD in 3 dage
(0 bedømmelser)
0.0
$155 USD in 3 dage
(0 bedømmelser)
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 Mere

$155 USD in 3 dage
(0 bedømmelser)
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 Mere

$200 USD på 1 dag
(0 bedømmelser)
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 Mere

$100 USD på 1 dag
(0 bedømmelser)
0.0
$111 USD in 3 dage
(0 bedømmelser)
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 Mere

$70 USD in 3 dage
(0 bedømmelser)
0.0
$50 USD in 3 dage
(0 bedømmelser)
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 in 2 dage
(0 bedømmelser)
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 Mere

$222 USD in 5 dage
(0 bedømmelser)
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 Mere

$100 USD in 3 dage
(0 bedømmelser)
0.0