Remote Data Mining And Management Job In Data Science And Analytics

Excel Scripting and data visualization

Find more Data Mining And Management remote jobs posted recently Worldwide

I have a requirement here. I have created an Excel sheet which works on some good amount of Data.. Now the Excel is ready and working.. My requirement is as below now:

1) There are too many repeated formulas being used in the Excel and hence I want to use VB Scripts to consolidate those formulas at one place.

2) That excel needs to be completely password Protected.. No One Should be able to View or copy any of the VB Scripts..

3) The password needs to have an Expiry Set when we protect the Excel.. Lets assume that I set a password for the Excel which should expire in 30 days or 60 days.. After that the user would not be able to open the Excel further.. Remember user cannot change the password also..

4) Excel will connected to external source for Data Feeds into the Excel at real time.

Now please understand that this is a self work and is completely my own Intellectual Property hence I wont be able to share the Excel sheet but I will share a small sample excel sheet which you will have to help me create the above things then then rest of the things I will do on my own.

I want to be very clear that this is not going to be a HUGE work as you can understand that you will only be working on the sample sheet hence I want some quick work here. This is urgent and hence needs to be delivered within no time.
About the recuiter
Member since Sep 4, 2017
Leroy W.
from Alpes-Maritimes, France

Skills & Expertise Required

Excel VBA JSON VBA 

Open for hiringApply before - Sep 21, 2024

Work from Anywhere

40 hrs / week

Hourly Type

Remote Job

$26.77

Cost

Offer to work on this project closes in 59 days!
Are you interested in this Opportunity?

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions

Similar Projects

Link data in Excel

I need someone to link 2 sets of data into 1 pivot or slicer excel spreadsheet has 3 tabs: BPD, Data Object Summary and Attributes. It is the Data Object Summary and Attributes tab that need work. In Data Object Summary tab, I would like to link it t...read more

SolidWorks API Developer to export data to file

Currently we use SolidWorks to design implants for joint replacement surgery. The need is to write code as a plugin to SolidWorks to export data (points) into a text file.

Raspberry Pi Help, need help configuring DNS level ad blocker and Homebridge with Nest Products

Raspberry Pi Specialist needed for programming home devices.
Need to be able to control Nest devices via Homebridge, and install a DNS level ad blocker via Router
Must be located in the Los Angeles area and be able to commute
Must be able...read more

Security Engineering

The assessment will include:
-Architecture overview of the system (Description of the architecture, Graphical Diagram)
-Code Analysis (Automated code analysis using a tool, manual code review)
-Security problems and possible/suggested fix...read more

Simple data analysis based on Excel VBA

Hi,

I am looking for an experienced VBA developer, who will support our project in specific tasks.

In this first task, he will have to apply simple data analysis techniques to our data (like Mean, Median, Std. Deviation) and extrac...read more