2 Excel Spreadsheets that will manipulate imported data
Required skills: Excel
I currently need 2 excel spreadsheets to do some number crunching, automatic field population, highlighting etc.
Need someone who is a whiz at exel, knows how to build formulas, lock certain parts down, create report/sorting in excel that is locked down, and has experience in making excel accept data from outside, and manipulate it to a certain outcome. I've speced out what needs to be done below (obviously once the project is accepted I'll be able to provide the raw data and expand further) - if you can do it, please bid - need it done quickly.
Reason:
The spreadsheets will be used to give contractor trainers a list of students they will need to manage and create checkpoints of next contact dates, as well as consolidate data pasted into it, to create summary information and alerts if a student hasn't logged in for a while
Spreadsheet 1:
The basic columns are already there, and they contact student information such as Name, number, email course enrolled.
The requirement is to create:
1. one extra column that asks if an induction call has been made (default is no, can be changed to yes)
2. another column that requests date of when call was made: format: dd/mm/yyyy
3. another 4 column that will automatically put in a date +30 days, +60 day, +90 days , +120 days from date of when initial call was made.
4. after each date column, it is requested from a trainer to input comments from their conversation
5. a column at the very end that captures: " Qualification Completed" -yes/no
The only data that can be modified by a trainer is the "induction call made", "date call made", and "comments"
Since this spreadsheet is going to be a few hundred lines of students, and is going to be a 'live' spreadsheets. More students will be added it it weekly.
Something needs to be built into it that allows a trainer query the information weekly and find out who whey need to contact in a given timeframe (i.e they might only run it once a week and look for all people they need to contact in that week, or they need to find all students that yet have not have not yet had an induction call made.
Spreadsheet 2:
A raw report from our student management system needs to be dropped into this spreadsheet so that it 'does its thing'.
The raw data has 6 columns: Student Full Name, Unit Studying, Trainer, Type, Unit Completion % and Last Logged in date (this is what is shown in the last column as one of the results: Thu Jun 09 16:52:39 UTC 2011)
A student doing a qualification with 4 units, will appear as 4 separate lines, and the number of units a student can be doing varies from 1 to 13 (see example below:)
Student Full Name | Unit Studying | Trainer | Type | Unit Completion % | Last Logged in date
John Doe BSBHRM406A Bob Smith Full 13% Thu Jun 09 16:52:39 UTC 2011
John Doe BSBBSB408A Bob Smith Full 0% Thu Jun 09 16:52:39 UTC 2011
John Doe BSBHRM409A Bob Smith Full 2% Thu Jun 09 16:52:39 UTC 2011
John Doe BSBHRM404A Bob Smith Full 6% Thu Jun 09 16:52:39 UTC 2011
What the spreadsheet does with this data is as follows:
1. sort all students so that they are grouped together, then sorted by trainer.
2. once all data is sorted properly, to minimize the multiple student rows into one row, and give an average of current student completion as a percentage.
3. if last login date is greater than 30 days and/or the unit completion average =0%, it needs to be flagged somehow in red
4. all red flagged need to be sorted together
5. extra column created to capture contact date with student + capture comment in another column- changing color status
Posted In:Excel |
Related projects:
program that will basically pull data from several different
I need a program that will basically pull data from several different spreadsheets into one. The common denominator on each spreadsheet will be Social Security Numbers and Plan ID's
Please let me know your thoughts on how we can accomplish this.. The final output file is what it should contain and I can use that same format for various carriers.
Please let me know your thoughts on how we can accomplish this.. The final output file is what it should contain and I can use that same format for various carriers.
MS Excel spreadsheets
br>
*PLEASE BID ON 10 JOBS""""
(For example, if you are bidding $ 10 per job x 10, then $ 100 is your BID)
Please tell me your experience, qualifications and SAMPLES of your work
Please tell me your AVAILABILITY, how I can contact you (Skype, Email etc) and how many hours per day you are available- lots of these jobs I MUST BE ABLE TO CONTACT YOU IMMEDIATELY IF NECESSARY
Thankyou
*PLEASE BID ON 10 JOBS""""
(For example, if you are bidding $ 10 per job x 10, then $ 100 is your BID)
Please tell me your experience, qualifications and SAMPLES of your work
Please tell me your AVAILABILITY, how I can contact you (Skype, Email etc) and how many hours per day you are available- lots of these jobs I MUST BE ABLE TO CONTACT YOU IMMEDIATELY IF NECESSARY
Thankyou
MS Excel spreadsheets
rrect accounts
*PLEASE BID ON 10 JOBS""""
(For example, if you are bidding $ 10 per job x 10, then $ 100 is your BID)
Please tell me your experience, qualifications and SAMPLES of your work
Please tell me your AVAILABILITY, how I can contact you (Skype, Email etc) and how many hours per day you are available- lots of these jobs I MUST BE ABLE TO CONTACT YOU IMMEDIATELY IF NECESSARY
Thankyou
*PLEASE BID ON 10 JOBS""""
(For example, if you are bidding $ 10 per job x 10, then $ 100 is your BID)
Please tell me your experience, qualifications and SAMPLES of your work
Please tell me your AVAILABILITY, how I can contact you (Skype, Email etc) and how many hours per day you are available- lots of these jobs I MUST BE ABLE TO CONTACT YOU IMMEDIATELY IF NECESSARY
Thankyou
MS Excel spreadsheets
br>
*PLEASE BID ON 10 JOBS""""
(For example, if you are bidding $ 10 per job x 10, then $ 100 is your BID)
Please tell me your experience, qualifications and SAMPLES of your work
Please tell me your AVAILABILITY, how I can contact you (Skype, Email etc) and how many hours per day you are available- lots of these jobs I MUST BE ABLE TO CONTACT YOU IMMEDIATELY IF NECESSARY
Thankyou
*PLEASE BID ON 10 JOBS""""
(For example, if you are bidding $ 10 per job x 10, then $ 100 is your BID)
Please tell me your experience, qualifications and SAMPLES of your work
Please tell me your AVAILABILITY, how I can contact you (Skype, Email etc) and how many hours per day you are available- lots of these jobs I MUST BE ABLE TO CONTACT YOU IMMEDIATELY IF NECESSARY
Thankyou
MS Excel spreadsheets
rrect accounts
*PLEASE BID ON 10 JOBS""""
(For example, if you are bidding $ 10 per job x 10, then $ 100 is your BID)
Please tell me your experience, qualifications and SAMPLES of your work
Please tell me your AVAILABILITY, how I can contact you (Skype, Email etc) and how many hours per day you are available- lots of these jobs I MUST BE ABLE TO CONTACT YOU IMMEDIATELY IF NECESSARY
Thankyou
*PLEASE BID ON 10 JOBS""""
(For example, if you are bidding $ 10 per job x 10, then $ 100 is your BID)
Please tell me your experience, qualifications and SAMPLES of your work
Please tell me your AVAILABILITY, how I can contact you (Skype, Email etc) and how many hours per day you are available- lots of these jobs I MUST BE ABLE TO CONTACT YOU IMMEDIATELY IF NECESSARY
Thankyou
MS Excel spreadsheets
rrect accounts
*PLEASE BID ON 10 JOBS""""
(For example, if you are bidding $ 10 per job x 10, then $ 100 is your BID)
Please tell me your experience, qualifications and SAMPLES of your work
Please tell me your AVAILABILITY, how I can contact you (Skype, Email etc) and how many hours per day you are available- lots of these jobs I MUST BE ABLE TO CONTACT YOU IMMEDIATELY IF NECESSARY
Thankyou
*PLEASE BID ON 10 JOBS""""
(For example, if you are bidding $ 10 per job x 10, then $ 100 is your BID)
Please tell me your experience, qualifications and SAMPLES of your work
Please tell me your AVAILABILITY, how I can contact you (Skype, Email etc) and how many hours per day you are available- lots of these jobs I MUST BE ABLE TO CONTACT YOU IMMEDIATELY IF NECESSARY
Thankyou
Ms Excel Spreadsheets
em and record them to the correct accounts
*PLEASE BID ON 10 JOBS""""
(For example, if you are bidding $ 10 per job x 10, then $ 100 is your BID)
Please tell me your experience, qualifications and SAMPLES of your work
Please tell me your AVAILABILITY, how I can contact you (Skype, Email etc) and how many hours per day you are available- lots of these jobs I MUST BE ABLE TO CONTACT YOU IMMEDIATELY IF NECESSARY
Thankyou
*PLEASE BID ON 10 JOBS""""
(For example, if you are bidding $ 10 per job x 10, then $ 100 is your BID)
Please tell me your experience, qualifications and SAMPLES of your work
Please tell me your AVAILABILITY, how I can contact you (Skype, Email etc) and how many hours per day you are available- lots of these jobs I MUST BE ABLE TO CONTACT YOU IMMEDIATELY IF NECESSARY
Thankyou
Simple Excel Script - Reformat Data
We need someone to write an Excel Macro, that will reformat some data into another given format. I have attached a sample of the raw data and an sample of what the data should look like once formatted. Also there will be a few additional features that need to be implemented, such as matching part numbers and inserting prices based on part numbers.
Our max Budget is 40$ .
Thank you
Our max Budget is 40$ .
Thank you
2500+ Static HTML to Excel to SQL database
se/scrape an item code from each page and place it in a column.
2. Parse/scrape the body html code out and place it in a column matching the item code on that page.
Alternative Solution
1. Parse/Scrape item code and body html out to a table that can be imported to SQL easily (.CSV ?)
2. Parse/scrape the body html code out and place it in a column matching the item code on that page.
Alternative Solution
1. Parse/Scrape item code and body html out to a table that can be imported to SQL easily (.CSV ?)
Create 2 excel spreadsheets (formulas)
act?
How many contacts do I need to reach to get a search assignment?
How many search assignments do I need to make a placement?
How many candidate calls do I need to make to set up an interview?
How many interviews do I need to make a placement?
What is my average placement fee?
Number of placements needed to reach my yearly income goal?
How many contacts do I need to reach to get a search assignment?
How many search assignments do I need to make a placement?
How many candidate calls do I need to make to set up an interview?
How many interviews do I need to make a placement?
What is my average placement fee?
Number of placements needed to reach my yearly income goal?
Excel macro that extracts page meta data from Google
e, meta keywords and meta description for that URL. The results are sent to a worksheet.
Detail:
Input worksheet
Category,search term,number of results
Output Worksheet
Category,search terms,URL,meta title,meta description,meta leywords
Processing:
Error checking needed – timeouts to stop script hanging. Ability to redo a set of inputs but only for those they have not been processed
I hope that’s clear enough.
Detail:
Input worksheet
Category,search term,number of results
Output Worksheet
Category,search terms,URL,meta title,meta description,meta leywords
Processing:
Error checking needed – timeouts to stop script hanging. Ability to redo a set of inputs but only for those they have not been processed
I hope that’s clear enough.
Create a custom plugin that will send email notification on
should send me the plugin as a zip file which I will install on test site. When the plugin is working properly, I will install it on a live site.
The work should be done in 24 hours after being awarded the project. Freelancer should allow 7 days for testing after he finishes his work, before getting paid.
Freelancer applying for the job are advised to attach a screenshot of the requested posts filter by date admin area .
The work should be done in 24 hours after being awarded the project. Freelancer should allow 7 days for testing after he finishes his work, before getting paid.
Freelancer applying for the job are advised to attach a screenshot of the requested posts filter by date admin area .
Create A Custom Plugin That Will Send Email Notification On
need a custom plugin built. The freelancer should send me the plugin as a zip file which I will install on test site. When the plugin is working properly, I will install it on a live site.
The work should be done in 24 hours after being awarded the project. Freelancer should allow 7 days for testing after he finishes his work, before getting paid.
Freelancer applying for the job are advised to attach a screenshot of the requested posts filter by date admin area .
The work should be done in 24 hours after being awarded the project. Freelancer should allow 7 days for testing after he finishes his work, before getting paid.
Freelancer applying for the job are advised to attach a screenshot of the requested posts filter by date admin area .
Flash File that parses CSV File
day in all locations.
File 2:The data will need to be displayed based on current date and room name/number
A sample CSV file will be provided. Both of these files will then be part of a larger flash file used for Interactive Digital Signage that is not in the scope of this project. Graphic Design is not needed, only the data query functionality. Resulting data should be placed in an easy to read table for inclusion into the final file.
File 2:The data will need to be displayed based on current date and room name/number
A sample CSV file will be provided. Both of these files will then be part of a larger flash file used for Interactive Digital Signage that is not in the scope of this project. Graphic Design is not needed, only the data query functionality. Resulting data should be placed in an easy to read table for inclusion into the final file.
excel excel guru to manipulate cvs data by leongreig
erent columns
2: If a price = 0 or products on hand = 0 the macron/program will need to return a value of inactive (otherwise active)in another column
3: combine various colums to produce other colums
4: have a way of adding a markup percentage for product values between $ 0-$ 1000 $ 1000-$ 2000 $ 3000 +, also being able to set a minimum markup of eg $ 10 for all
5: the macron/program will need to compare two excel cvs files and create a new file of the changes
2: If a price = 0 or products on hand = 0 the macron/program will need to return a value of inactive (otherwise active)in another column
3: combine various colums to produce other colums
4: have a way of adding a markup percentage for product values between $ 0-$ 1000 $ 1000-$ 2000 $ 3000 +, also being able to set a minimum markup of eg $ 10 for all
5: the macron/program will need to compare two excel cvs files and create a new file of the changes
Information Scraping / Web search and enter into Excel - 2
s).
I can provide links to get started, but some web search will be required.
The other will have the contact information (agency name/ Address/City/State/Zip /county/email) for all short line and regional railroads in the United States.
Our budget $ 10 for 1500 data.
Only bid who have ability to collect 1000 per-day.
I select a freelancer within very short time .
you must have Skype.
Thanks
I can provide links to get started, but some web search will be required.
The other will have the contact information (agency name/ Address/City/State/Zip /county/email) for all short line and regional railroads in the United States.
Our budget $ 10 for 1500 data.
Only bid who have ability to collect 1000 per-day.
I select a freelancer within very short time .
you must have Skype.
Thanks
Extract Data and Images from Online PDF Catalog #2
length (if any) listed after part number in certain items
8. Price of Each item (red text)
We will be considering both time and cost when looking at bids. We need this work done quickly. Payment will be made in full on acceptance of the work to our exact specifications only. Please, before bidding, view the catalog and understand the full requirements. If you bid a certain number of days we will expect completion on that day.
8. Price of Each item (red text)
We will be considering both time and cost when looking at bids. We need this work done quickly. Payment will be made in full on acceptance of the work to our exact specifications only. Please, before bidding, view the catalog and understand the full requirements. If you bid a certain number of days we will expect completion on that day.
Excel data entry 2-3 day turnaround
I am looking for a data entry person, to fill excel spreadsheets.
I will provide training on what needs to be done. Initial training i will call by skype or phone call.
You may be required sometime to log into my computer using VPN to complete the work.
I will provide training on what needs to be done. Initial training i will call by skype or phone call.
You may be required sometime to log into my computer using VPN to complete the work.
Excel Data Entry 98 Products
for all products.
productcode productname hideproduct stockstatus productdescriptionshort productdescription productweight productprice productmanufacturer categoryids
2nd excel file will only be used for products with multiple sizes and/or colors and will have these fields.
optioncatid optionsdesc applytoproductcodes pricediff
Site addresses and template files (with a couple lines completed as sample) will be provided to bidder.
productcode productname hideproduct stockstatus productdescriptionshort productdescription productweight productprice productmanufacturer categoryids
2nd excel file will only be used for products with multiple sizes and/or colors and will have these fields.
optioncatid optionsdesc applytoproductcodes pricediff
Site addresses and template files (with a couple lines completed as sample) will be provided to bidder.
Excel Data Entry 135 Products
for all products.
productcode productname hideproduct stockstatus productdescriptionshort productdescription productweight productprice productmanufacturer categoryids
2nd excel file will only be used for products with multiple sizes and/or colors and will have these fields.
optioncatid optionsdesc applytoproductcodes pricediff
Site addresses and template files (with a couple lines completed as sample) will be provided to bidder.
productcode productname hideproduct stockstatus productdescriptionshort productdescription productweight productprice productmanufacturer categoryids
2nd excel file will only be used for products with multiple sizes and/or colors and will have these fields.
optioncatid optionsdesc applytoproductcodes pricediff
Site addresses and template files (with a couple lines completed as sample) will be provided to bidder.
