Do some Excel Work

Cerrado Publicado Feb 25, 2016 Pagado a la entrega
Cerrado Pagado a la entrega

I am collecting payment data from bank accounts (both credit and debit) in Google Spreadsheets containing datetime of transaction, ammount of transaction, and actual balance after transaction. I use it to visualise the actual balance looking for maximum in datetime for each account. From time to time happens, that some payments are realised with the same datetime and the data is not processed chronologically (the order of payments is not real). I need to run a script on my spreadsheet which will identify the last payment analysing the ammounts, balances, and type (credit/debit) and will delete the balance data from preceding payments.

Logic(attachment): If count of entries with the same value in "own_account_number" and "transaction_datetime" > 1, then compare "transaction_value", "balance" and "Type" to find the last transaction.

(Note that "processed_datetime" is not in the same order as the transactions increased the balance of that particular account)

Entrada de datos Procesamiento de datos Motor de Google App

Nº del proyecto: #9759308

Sobre el proyecto

32 propuestas Proyecto remoto Activo Apr 6, 2016

32 freelancers están ofertando un promedio de €63 por este trabajo

Viqtor

Hi, maybe can help. To find the last transaction you need compare "processed_datetime" or "transaction_datetime" within the same "own_account_number". However as it seen from sample two transactions (row 6 and 7) ca Más

€20 EUR en 1 día
(31 comentarios)
5.6
thuyduongrands

Dear Mardam or sir, You need an accountant . I am the one you need . I have great experience working as an Accounting throughout my career. I have over 10 years of experience and knowledge of accounting and good skil Más

€34 EUR en 1 día
(6 comentarios)
3.5
Guruchandar

we Have team of highly qualified and experienced Data Entry Professionals who can handle any kind of Data entry work we make sure we deliver Quality and satisfactory work on Give time frame we are very Flexible Más

€29 EUR en 5 días
(14 comentarios)
3.6
bashir786wmc

You pay me after checking the work Hi I have read out all the details given in your project and I am fully capable to deliver you this project with 100% accuracy. I have completed many projects related to this in th Más

€23 EUR en 1 día
(2 comentarios)
1.8
sanaakram161

I am a hardworking, dedicated and driven young female who ensures that all tasks are accomplished in a timely and acceptable manner.

€23 EUR en 1 día
(7 comentarios)
1.5
BALWINDERsing

I have 2 year experience.

€23 EUR en 1 día
(0 comentarios)
0.0
anilvaishnav4

BECHLOR OF COMERCE WITH 13+ YEARS OF PARTICLE EXPERIENCE IN ACCOUNTS , TAXATION & FINANCE IN THE FIELD OF HYDRO PROJECTS / CONSTRUCTION & REAL ESTATE

€14 EUR en 1 día
(0 comentarios)
0.0
AlexDante

Hello, I am a former Economy student and well versed with Excel sheets and Python programming for Excel manipulation. I can write you a script in Python doing what you require.

€8 EUR en 1 día
(0 comentarios)
0.0
gosavig

Quality accuracy &time efficient is the motto of my working skill sets Analysing & understanding the project requirement is the key of our successful completed projects Will use the most advanced techniques & technolo Más

€12 EUR en 1 día
(0 comentarios)
0.0
zahra7

A proposal has not yet been provided

€19 EUR en 3 días
(0 comentarios)
0.0
zkchaudhry1980

I am a professional with the passion to excel in whatever I take up, with a desire to learn new concepts & technologies, I believe in the ‘Open-system’ Architecture that is sharing of information, ideas & experiences w Más

€18 EUR en 1 día
(0 comentarios)
0.0
Raghuvavila

Hi, I have checked your requirements. I have a company data entry and telemarketing. 30 employees are working in my company. i think i will be the right person for you. thanks.

€23 EUR en 1 día
(0 comentarios)
0.0
annelydia92

A proposal has not yet been provided

€24 EUR en 2 días
(0 comentarios)
0.0
umeshindave

A proposal has not yet been provided

€22 EUR en 4 días
(0 comentarios)
0.0
Padmaja70

I am bidding on this kind of a project for the first time. I just would like to state that I will do the job to the best of my capabilities. I

€23 EUR en 1 día
(0 comentarios)
0.0
dezix

Easy project, but you need to pay proper money. I'm pretty sure your earnings are not in the £20 category

€1333 EUR en 3 días
(0 comentarios)
0.0
Nealbie24

I can do your looking for because I have a experience bookkeeper. And I can share my knowledge to your company and I will also learn from your company also..

€23 EUR en 1 día
(0 comentarios)
0.0
xalera4

A proposal has not yet been provided

€55 EUR en 3 días
(0 comentarios)
0.0
osagieobasohan

I will guarantee 100% satisfaction and on-time delivery. I am also skilled in Data Entry, Data Processing, Microsoft Excel, Word and Powerpoint. I have 4+ years experience using and training individuals and companies o Más

€23 EUR en 1 día
(0 comentarios)
0.0
Maheshk499

Typing with Speed and Accuracy and complete the given work in time. I have time to work only on the given work and can work 6 hours a day.

€24 EUR en 5 días
(0 comentarios)
0.0