Python/Access/ Excel
Required skills: Access DB, Excel, Python
Gday
I am currently building my own horse racing database.
I want to extract data from this webpage (example here http://www.racingvictoria.net.au/Racing/horse.aspx?horse_code=404457) through a function, into an Excel format I can provide, so I can manipulate the data. I then want to store the Excel data in an Access DB or similar.
Each horse would have its own individual record in the database, similar to how it is represented on the page on the website e.g weight, time, class etc. It doesn't have to look pretty, as long as it works.
I want to be able to see each horses individual record, as per the link but with my ratings included as 3 lines of text. I also want to extract data according to the variables. For example, all horses trained by a particular trainer in the last 12 months, all Group races etc.
The successful bidder would also be able hopefully to help me create an Excel Macro or similar that I will use to set betting markets, so there will be more work for you in future if you have the right skills.
Thank you.
similar
I am currently building my own horse racing database.
I want to extract data from this webpage (example here http://www.racingvictoria.net.au/Racing/horse.aspx?horse_code=404457) through a function, into an Excel format I can provide, so I can manipulate the data. I then want to store the Excel data in an Access DB or similar.
Each horse would have its own individual record in the database, similar to how it is represented on the page on the website e.g weight, time, class etc. It doesn't have to look pretty, as long as it works.
I want to be able to see each horses individual record, as per the link but with my ratings included as 3 lines of text. I also want to extract data according to the variables. For example, all horses trained by a particular trainer in the last 12 months, all Group races etc.
The successful bidder would also be able hopefully to help me create an Excel Macro or similar that I will use to set betting markets, so there will be more work for you in future if you have the right skills.
Thank you.
similar
Posted In:PythonExcelAccess DB |
Related projects:
Excel file Get physical address
ess listed as follows:
Name-company x (provided by me )
Nieuwezijds voorburgwal 112 (you must find)
1012TG Amsterdam (you must find)
Need someone to find the street address of each business and put it in a second column in excel
Please only bid if you are sure you can do this within the given budget and time frame
PM me for the file
Must be done within 48 hours of awarding project
Cheers
Name-company x (provided by me )
Nieuwezijds voorburgwal 112 (you must find)
1012TG Amsterdam (you must find)
Need someone to find the street address of each business and put it in a second column in excel
Please only bid if you are sure you can do this within the given budget and time frame
PM me for the file
Must be done within 48 hours of awarding project
Cheers
Copy from web paste to excel.
Hi all,
I am looking for someone to expand my database so I need simple copy from web and paste to excel sheet.
end result will be 30 000 lines in excel sheet. no skills special need it, just copy paste.
it is just copy model of laptop paste to excel then clik on same model copy description of that model and paste it to excel sheet then sort it by size. that is one line
I am looking for someone to expand my database so I need simple copy from web and paste to excel sheet.
end result will be 30 000 lines in excel sheet. no skills special need it, just copy paste.
it is just copy model of laptop paste to excel then clik on same model copy description of that model and paste it to excel sheet then sort it by size. that is one line
Excel to Access
pread sheet with about 8,000 lines of data and I need it converted (copied over) to Access and tweaked so it looks nice for a report. I know how to work in Excel and I have all the data entered,
I just don't know how to work in Access. The client I am doing the work for wants the final results in Access.
I am looking for someone who is highly proficient in Access that can do this work. If this is you please reply
Thank You
I just don't know how to work in Access. The client I am doing the work for wants the final results in Access.
I am looking for someone who is highly proficient in Access that can do this work. If this is you please reply
Thank You
MS Excel Data Entry
I repeatedly visit clients and gather survey data in the form of questions answered with a 1 to 5 rating. I'm currently creating graphs from this data in a very manual fashion because I'm not an Excel expert. I want someone to create a spreadsheet that automatically creates a graph for each code after I enter the data. I also want this graph to update in a corresponding MS Powerpoint file for each code.
fix excel sheet + macros
e count my inventory in several locations. The various locations just have columns that we edit. Someone helped me build some macro buttons that add and subtract to the various sheet counts. I just need to add 4-5 sheets to the spreadsheet (add additional locations with the same functionality as the original ones). Also, I just need to make some minor alterations to the macro buttons (size / what they say on them), etc. That's it!
Data Entry in Microsoft Excel
ick name, go back, click new name, go back …).
See screenshot 1 how the addresses appear.
See screenshot 2 how we need it in Excel format.
We need NAME, CITY, PHONE, EMAIL, WEBSITE and CONTACT in an Excel file.
Important: sometimes a few information are missing on the website. In this case, leave it blank. It's important it always remains 1 row. For example, all "Email" addresses are in 1 row (in our example E5)
See screenshot 1 how the addresses appear.
See screenshot 2 how we need it in Excel format.
We need NAME, CITY, PHONE, EMAIL, WEBSITE and CONTACT in an Excel file.
Important: sometimes a few information are missing on the website. In this case, leave it blank. It's important it always remains 1 row. For example, all "Email" addresses are in 1 row (in our example E5)
C# Data Extraction from Excel to XML
ma for the output file for the transformation process, and you must provide the final C# code and your output results. You may not use the Microsoft interop libraries or any other library that has licensing restrictions associated with it. Freeware and open source libraries are acceptable.
We have hundreds of other different types of input files that will need to be processed once we build a relationship with a strong developer.
We have hundreds of other different types of input files that will need to be processed once we build a relationship with a strong developer.
Convert PDF to Excel
I have some bank statements that need to be input from a PDF into an excel spreadsheet. There are approximately 90 pages worth of data. This is a very easy, straight forward task. Need the date, description, and the amount for each entry.
Excel Data Extraction ASAP
I have data on excel and need a function (program) to extract data from each line into different cells. Attached is a sample file. Some data have 5 or six lines so I would need to have 5 or six cells.
MS Excel Data Entry
I repeatedly visit clients and gather survey data in the form of questions answered with a 1 to 5 rating. I'm currently creating graphs from this data in a very manual fashion because I'm not an Excel expert. I want someone to create a spreadsheet that automatically creates a graph for each code after I enter the data. I also want this graph to update in a corresponding MS Powerpoint file for each code.
Convert PDF to Excel
I have some bank statements that need to be input from a PDF into an excel spreadsheet. There are approximately 90 pages worth of data. This is a very easy, straight forward task. Need the date, description, and the amount for each entry.
PDF To Excel Data Entry
Project Description:
Looking for someone who take Portable Document Format (data/Text) conversion it to an excel spreadsheet Format.
You just type the PDF text in to Excel Format.
I will send you the PDF File.
This work is so easy. So please don't be afraid feel free for applying the job.
Looking for someone who take Portable Document Format (data/Text) conversion it to an excel spreadsheet Format.
You just type the PDF text in to Excel Format.
I will send you the PDF File.
This work is so easy. So please don't be afraid feel free for applying the job.
Word Information into Excel
, Company e-mail, website
Order info: Order person's contact name, e-mail, website
For each both the company info and the order info, I would need someone to go and find the physical addresses for both. Sometimes--a lot of time--this information will be the same, other times it will not be. Additionally, I need the information marked in such a way where I can see that the Company info and Order info are two separate entities.
Order info: Order person's contact name, e-mail, website
For each both the company info and the order info, I would need someone to go and find the physical addresses for both. Sometimes--a lot of time--this information will be the same, other times it will not be. Additionally, I need the information marked in such a way where I can see that the Company info and Order info are two separate entities.
PDF To Excel Data Entry
Project Description:
Looking for someone who take Portable Document Format (data/Text) conversion it to an excel spreadsheet Format.
You just type the PDF text in to Excel Format.
I will send you the PDF File.
This work is so easy. So please don't be afraid feel free for applying the job.
Looking for someone who take Portable Document Format (data/Text) conversion it to an excel spreadsheet Format.
You just type the PDF text in to Excel Format.
I will send you the PDF File.
This work is so easy. So please don't be afraid feel free for applying the job.
eBay Listings by Excel
f products on our ebay account using Bulk listings by Excel file.
You will basically copy all of the products from my website onto the Excel file with prices, descriptions, and photos from the website.
You must have some ebay experience listing in Bulk by Excel spreadsheet
I will give you the website to copy, and the excel spreadsheet and you just need to copy all the date from each product page onto the excel file
You will basically copy all of the products from my website onto the Excel file with prices, descriptions, and photos from the website.
You must have some ebay experience listing in Bulk by Excel spreadsheet
I will give you the website to copy, and the excel spreadsheet and you just need to copy all the date from each product page onto the excel file
Data Entry into Excel file ( Homebased )
fic data, and enter the data into an Excel file. You will be looking for publicly available information, using search online and then crop/paste into Excel file. Accuracy is important.
This job does not require any programming skills. A reliable internet connection, data entry skills are a must. If your work is accurate and your rate is good, then there could be many more similar projects, so it has potential for long term work.
This job does not require any programming skills. A reliable internet connection, data entry skills are a must. If your work is accurate and your rate is good, then there could be many more similar projects, so it has potential for long term work.
PDF to Excel macro, script
name. For each CC statement found within the PDF, a new Excel file will be created.
There are multiple credit cards per page, in 2-column format. See attachment.
Once you can give it to us in separate file, we will handle what we need (bringing that into Access to convert it into IIF for Quickbooks).
** Please explain your expertise, and how you intend to do this. I'm a programmer, so you can talk technical.
There are multiple credit cards per page, in 2-column format. See attachment.
Once you can give it to us in separate file, we will handle what we need (bringing that into Access to convert it into IIF for Quickbooks).
** Please explain your expertise, and how you intend to do this. I'm a programmer, so you can talk technical.
Get Data/data Entry In Excel
hich lists all Jauch parts in column A. Then in the next columns I need the cross for the competitors. This means you need to enter all the ILSI first and from there make sure you enter the next manufacturer from the drop down menu. You need to make sure that you put the right competitor part with the right Jauch part. In case there is no cross, leave it blank.
Please make the list look nice (add a Jauch logo etc.) and easy to navigate in.
Let me know if you have any questions.
Please make the list look nice (add a Jauch logo etc.) and easy to navigate in.
Let me know if you have any questions.
Turn Excel File Into Application For Pc
r>
You can quickly determine how much traffic you need to make X amount of sales based conversion %
You can determine clickbank affiliate commissions
You can determine cost of lead...
Plus a couple more
I would like to turn this into an application that looks professional and easy to use.
These are simple calculations and should fairly easy for the right person.
Will provide excel file for the project.
Look forward to hearing from you.
You can determine clickbank affiliate commissions
You can determine cost of lead...
Plus a couple more
I would like to turn this into an application that looks professional and easy to use.
These are simple calculations and should fairly easy for the right person.
Will provide excel file for the project.
Look forward to hearing from you.
Data Entry in Microsoft Excel
ick name, go back, click new name, go back …).
See screenshot 1 how the addresses appear.
See screenshot 2 how we need it in Excel format.
We need NAME, CITY, PHONE, EMAIL, WEBSITE and CONTACT in an Excel file.
Important: sometimes a few information are missing on the website. In this case, leave it blank. It's important it always remains 1 row. For example, all "Email" addresses are in 1 row (in our example E5)
See screenshot 1 how the addresses appear.
See screenshot 2 how we need it in Excel format.
We need NAME, CITY, PHONE, EMAIL, WEBSITE and CONTACT in an Excel file.
Important: sometimes a few information are missing on the website. In this case, leave it blank. It's important it always remains 1 row. For example, all "Email" addresses are in 1 row (in our example E5)
