EXPLORE

Software Architecture

Visual Basic for Apps

5.0

(137 reviews)

Chrysoula K.

@chriskerpini

5.0

137

7.9

7.9

99%

VBA | Excel | MS Office | Perl | Shell Scripting | Linux/UNIX | Translations (Greek,English)

$20 USD / Hour

・

Greece (5:51 AM)

・

Joined on May 7, 2011

・

7 Recommendations

$20 USD / Hour

・

Professional translations English -> Greek, technical topics, hardware, software, websites Certified in Linux (LPI) and UNIX (HP CSA) - certified HP instructor with 16+ years experience eBay, Amazon, Playtrade experience (4+ years), using many different e-commerce tools and environments MS Office - VBA scripting (mainly Excel) Perl and shell scripting (trainer, advanced levels)

Verifications

On time

98%

On budget

100%

Accept rate

98%

Repeat hire rate

21%

See all Excel Experts in Greece

Portfolio

Portfolio

This is a combination of perl code and VBA code, with the results shown in Excel.
The program searches on eBay, Amazon and/or Play for the specified keywords and/or barcode number, in all marketplaces' categories or under certain categories, and returns the basic data for each, grouped by marketplace: Link to the listing, lowest price, # of sellers, ranking and a small image for identification purposes.
This tool has a second "screen", where you can define some pricing data (VAT, purchase price, desirable profit) and it calculates the min price for a product in each marketplace, showing at the same time how this price is compared to the competitors.

Getting item's data from eBay, Amazon & Play

This is a combination of perl code and VBA code, with the results shown in Excel.
The program searches on eBay, Amazon and/or Play for the specified keywords and/or barcode number, in all marketplaces' categories or under certain categories, and returns the basic data for each, grouped by marketplace: Link to the listing, lowest price, # of sellers, ranking and a small image for identification purposes.
This tool has a second "screen", where you can define some pricing data (VAT, purchase price, desirable profit) and it calculates the min price for a product in each marketplace, showing at the same time how this price is compared to the competitors.

Getting item's data from eBay, Amazon & Play

Some of the translated into Greek websites...

Websites translations

Some of the translated into Greek websites...

Websites translations

Some of the approx. 80 books translated into Greek...

Books translation

Some of the approx. 80 books translated into Greek...

Books translation

This Excel add-in imports eBay orders from the csv file that eBay provides. Allows the user to edit the imported records, merges orders with the same recipient, and creates the invoices for all or selected orders, based on a predefined template, as well as shipping labels, picking lists and checklists. Invoices can be printed out, saved as PDFs and/or sent via email to the customers.
It also keeps a searchable "history" database, allowing to create reports, like "Recurring customers", best seller items, summaries for the # of customers per city or area, etc.

eBay Orders, Invoices, Labels

This Excel-VBA program has many capabilities:
1. It keeps an database for a catering, including menus, items used for each plate, equipment, suppliers, and customers, allowing to add/modify/delete any record or field.
2. It includes a booking system, with a functional calendar. The user has simply to find the desired date to see if something has been booked for this date, or to add a new event of function. Double-clicking on this date's cell, a dialog allows her/him to add the details for this event, addresses, time, billing details, all ordered menus and items.
3. The program can create checklists for the functions and orders, in a weekly basis. It can calculate the needed items and quantities for the next week, send via email orders to the suppliers, and print order's details and checklists.
4. It also creates reports: Best sellers, recurring customers, revenue reports.

Booking and Tracking Orders, as well as Items Needed

This VBA macro (Excel add-in) allows the user to select multiple CSV files, related each other using a "glue" field and combine them into one CSV or Excel file, in any order: the user can select which columns will be used from each input file, in which order.

Combine multiple CSV files in one

This is a combination of perl code and VBA code, with the results shown in Excel.
The program searches on eBay, Amazon and/or Play for the specified keywords and/or barcode number, in all marketplaces' categories or under certain categories, and returns the basic data for each, grouped by marketplace: Link to the listing, lowest price, # of sellers, ranking and a small image for identification purposes.
This tool has a second "screen", where you can define some pricing data (VAT, purchase price, desirable profit) and it calculates the min price for a product in each marketplace, showing at the same time how this price is compared to the competitors.

Getting item's data from eBay, Amazon & Play

This is a combination of perl code and VBA code, with the results shown in Excel.
The program searches on eBay, Amazon and/or Play for the specified keywords and/or barcode number, in all marketplaces' categories or under certain categories, and returns the basic data for each, grouped by marketplace: Link to the listing, lowest price, # of sellers, ranking and a small image for identification purposes.
This tool has a second "screen", where you can define some pricing data (VAT, purchase price, desirable profit) and it calculates the min price for a product in each marketplace, showing at the same time how this price is compared to the competitors.

Getting item's data from eBay, Amazon & Play

Some of the translated into Greek websites...

Websites translations

Some of the translated into Greek websites...

Websites translations

Some of the approx. 80 books translated into Greek...

Books translation

Some of the approx. 80 books translated into Greek...

Books translation

This Excel add-in imports eBay orders from the csv file that eBay provides. Allows the user to edit the imported records, merges orders with the same recipient, and creates the invoices for all or selected orders, based on a predefined template, as well as shipping labels, picking lists and checklists. Invoices can be printed out, saved as PDFs and/or sent via email to the customers.
It also keeps a searchable "history" database, allowing to create reports, like "Recurring customers", best seller items, summaries for the # of customers per city or area, etc.

eBay Orders, Invoices, Labels

This Excel-VBA program has many capabilities:
1. It keeps an database for a catering, including menus, items used for each plate, equipment, suppliers, and customers, allowing to add/modify/delete any record or field.
2. It includes a booking system, with a functional calendar. The user has simply to find the desired date to see if something has been booked for this date, or to add a new event of function. Double-clicking on this date's cell, a dialog allows her/him to add the details for this event, addresses, time, billing details, all ordered menus and items.
3. The program can create checklists for the functions and orders, in a weekly basis. It can calculate the needed items and quantities for the next week, send via email orders to the suppliers, and print order's details and checklists.
4. It also creates reports: Best sellers, recurring customers, revenue reports.

Booking and Tracking Orders, as well as Items Needed

This VBA macro (Excel add-in) allows the user to select multiple CSV files, related each other using a "glue" field and combine them into one CSV or Excel file, in any order: the user can select which columns will be used from each input file, in which order.

Combine multiple CSV files in one

5.0 · 137 Reviews

137 Reviews

Quote for translation

high-quality translation & smooth communication

Software Architecture

+1 more

Share

Project for chriskerpini -- 2

Great Freelancer, Thank you Chrysoula K. @chriskerpini

Software Architecture

+1 more

Share

Project for Chrysoula K. -- 5

You're great as always thank you

Software Architecture

+1 more

Share

Project for Chrysoula K. -- 4

Thanks again, i'll set-up the next milestone for the next project once you reconfirm the amount

Software Architecture

+1 more

Share

Project for Chrysoula K. -- 3

Amazing fast work as always

Software Architecture

+1 more

Share

Instructor

Jul, 1998 - Mar, 2014

•

15 years, 8 months

HP

Jul, 1998 - Mar, 2014

•

15 years, 8 months

Certified Instructor Unix, Linux, shell scripting, Perl

Jul, 1998 - Mar, 2014

•

15 years, 8 months

Instructor

Jan, 2006 - Jul, 2013

•

7 years, 6 months

ICTC

Jan, 2006 - Jul, 2013

•

7 years, 6 months

Office, VBA, Linux courses

Jan, 2006 - Jul, 2013

•

7 years, 6 months

Translator

Feb, 1989 - Dec, 2012

•

23 years, 10 months

M. Giourdas

Feb, 1989 - Dec, 2012

•

23 years, 10 months

Over 80 book titles translated from English into Greek. Fields: Computer software, technologies, programming languages and other technical issues.

Feb, 1989 - Dec, 2012

•

23 years, 10 months

Panepistimion Patron

1982 - 1987

•

5 years

Master

Greece

1982 - 1987

•

5 years

HP CSA

2011

HP

HP-UX System & network administrator

2011

Linux LPI-1

2014

LPI

Linux system & network administration

2014

HP CSA

HP

HP-UX System & network administrator

Linux Kernel Programming

Unix

Basic Numeracy

US English

Shell Scripting

VB6 Programming

F

Foundation vWorker Member