Jose Luis R. Profile

EXPLORE

5.0

(12 reviews)

You're now following

Error following user.

This user does not allow users to follow them.

You are already following this user.

Your membership plan only allows 0 follows. Upgrade here.

Successfully unfollowed

Error unfollowing user.

You have successfully recommended

Error recommending user.

Something went wrong. Please refresh the page and try again.

Email successfully verified.

$10 USD / hour

mostoles,

spain

$10 USD / hour

It's currently 8:20 AM here

Joined September 23, 2020

0 Recommendations

Jose Luis R.

@jlrbcel

5.0

(12 reviews)

3.2

93%

$10 USD / hour

mostoles,

spain

$10 USD / hour

100%

Jobs Completed

97%

On Budget

95%

On Time

12%

Repeat Hire Rate

Ing. Electrónico e Informático

Excel expert: VBA programming, data processing, MegaFormulas, Pivot Tables, External connections to databases, Beautiful graphics and Dashboards. Automatic document processing. I can also program and compile YOUR **specific Excel function ** (using .NET and Visual Studio) that will be installed as an AddIn, so it'll be available like any other regular excel function, but doing specifically what you require, AND your sheet will NOT REQUIRE MACROS enabled.

See all Excel Experts in Spain

Contact Jose Luis R. about your job

Portfolio

Only standard Excel's functions & formulas were used to solve this challenge!

Solved ONLY with FORMULAS

Just 2ble click on any space to assign a new appointment, (or modify an existing one). Hovering the mouse over the appointment will automagically bring an image with some patient's details: Phone numbers, Medical warning conditions, picture, etc.
Complete Dental System, Data repository within MS ACCESS database, User Interfase: Excel + VBA. Connected via ADO using SQL sentences

Dental System: DAYLY AGENDA Module

It allows multiple and powerful search and filtering options, most recent data appears on top, old data at the bottom. All data is obtained from an ADOx connection EXCEL to MS-ACCESS data base, using SQL statements.

Dental System: INCOME (PAYMENTS) Module

It allows to show each patient's RXs, classified by several categories, most recent first. Allows some image manipulation, like rotation, negative (color inversion), cropping, zooming, etc.

Dental System: IMAGING Module

It randomizes selected players from the Master List, in groups of 3, 4 or 5 (User configurable) to prepare them for the field tournaments, it allows manual overrides of several parameters, including re-location of players with each group, to finnally process and update the results back to the Master List.

GOLF CLUB players Organizer Tool

It allows to easily include products to orders, then it automagically creates and generates purchase orders for each suplier

RESTAURANT Ordering System

Solved ONLY with FORMULAS

Dental System: DAYLY AGENDA Module

Dental System: INCOME (PAYMENTS) Module

Dental System: IMAGING Module

GOLF CLUB players Organizer Tool

RESTAURANT Ordering System

Reviews

Changes saved

Showing 1 - 5 out of 12 reviews

Filter reviews by:

5.0

$21.00 AUD

Excel work require

الحمداللہ Very Nice. Mr jose done a quick task very quickly.Thank you

Muzammal Hussain

@hussainmuzammal4

•

3 years ago

5.0

€15.00 EUR

Terminar macro excel (sumar horas y dejar listo para imprimir)

Resolutivo, encuentra la manera de consiguir lo propuesto

CtresI

@CtresI

•

3 years ago

5.0

$80.00 USD

Project for Jose Luis R.

Jose is thorough, incredibly knowledgable, and a pleasure to work with. We have conferenced several times and his positive attitude and personality are a pleasure to work with. We will definitely be working again shortly, when I can steal him away from other clients!

+1 more

Peter F.

@peteralbin

•

3 years ago

5.0

$20.00 USD

Excel Formula Required - Possibly a modification to FILTER formula?

Delivered the project as expected and on time. No issues whatsoever! Thank you very much for your time

Data Processing

Excel

Ash T.

@vw481209vw

•

3 years ago

5.0

$20.00 USD

Excel guru needed for long-term E-commerce and Shopify product formatting

I had the privilege of conferencing with Jose, while we worked together. I addition to doing great work, he had a great personality and went above and beyond to help me map out a complex macros to automate my work processing tens of thousands of products and hundreds of thousands of records. Looking forward to conferencing with him again when he is available again. Skol Jose!

Peter F.

@peteralbin

•

3 years ago

Experience

DENTAL CLINIC

May 2012 - Apr 2018 (5 years, 11 months)

Development & Support of propietary Dentist Management System (complete), including these modules: Appointments, Payments, Administration, Imaging, etc. TOOLS: MS Access SQL, Excel VBA, XLL AddIns (.NET VB Visual Studio)

Wonderware of Venezuela, Inc.

Nov 2003 - Nov 2005 (2 years)

Regional Director of all Sales and Services operations for the following countries: Venezuela, Colombia, Ecuador, Peru & Caribbean Islands. TOOLS: - SalesForce.com, MS Outlook, MS Excel, MS PowerPoint, MS Word, MS Access, all Wonderware Software for Demoing

Wonderware of Venezuela, Inc.

Jan 2000 - Nov 2003 (3 years, 10 months)

Services Manager of all Tech Support and Training operations for the following countries: Venezuela, Colombia, Ecuador, Peru & Caribbean Islands. TOOLS: - In Touch Basic. In Touch Advanced. In Batch. Industry SQL Server. In Track Foundation & Modeling. Industrial Application Server. MS Server 2000. (Office): Outlook, Excel, PowerPoint.