I am the owner/director of a small Architectural Visualisation studio operating for 10 years in South Australia, we will be subcontracting current and ongoing commisions. Projects will require both exterior and interior pre-visualisation and occasionally 2D furnished/colour floorplan, home designs will be small scale domestic construction up to 15 unit groups. This project (BEACONSFIELD) w...
The project involves statistical data analysis for large data sets using R. The person need to know statistics and how statistical tech...statistical data analysis for large data sets using R. The person need to know statistics and how statistical techniques are implemented with R. Also need to know how to use external packages in R (ex. Bioconductor)
Hi guys, I have attached one excel file includes two tabs. About the first tab -> these tables represents two different items. Sales price (A2) is the first item sales price we sell. Then in the first table, it shows the vendors that we can source the first item. Same story for the second table. I want it to create me all the combinations of the
Hi, I need an Excel VBA guru to take the following columns as inputs and conduct web data scraping. Inputs in Excel: - Company Name - Location (e.g. NSW) VBA Process & Outputs in Excel: Google Search: 1. Google Search the Company Name 2. Extract information from First Search result (Header, URL, Description) 3. Copy Each into a separate
Before explaining, we want to be very clear that we're a Web Agency and we're looking for long term providers that are affordable and also very experienced with lots of years working on hosting environments / very experts in WooCommerce in this case. Very honest people, if you do this fine we will give you more tasks of other projects, since we're an agency and have multiple clients...
Hi freelancers, in the attached file I want a VBA code to do the following: Check all cells from W37 to the "last row" in the sheet. If any cell in that range contain date less than 1-1-2018 , the next two cells in the same row must be protected. For example cell W40 in the attachment has the date 22-Sep-2017, then cells Y40 and AA40 must has the format
...locations that I specify. The XML feed needs to be simple to use and basic, I'm not after anything complicated yet. This is not an RSS feed, it's an XML file from an external http:// source My requirement is to be able to: 1. Bring this XML feed into a (PHP/WordPress) website 2. Limit the number of jobs in the feed and paginate the rest
Refer to attached zip file. The [url removed, login to view] file links to 2 Excel files, 1 Access file and 1 SQL Server database. The SQL database can be restored from the [url removed, login to view] file, then linked using ODBC, DSN name = 'Calendar' The [url removed, login to view] file has a local table (called 'Connection') which can be used to determine the pat...
...8. MVC and WEB API 9. responsive web applications 10. SSRS 11. MySql 12. business analysis 13. Silverlight 14. mobile applications 15. Magento 16. MSACCESS / VBA 17. visual studio team services Being available every day between Monday to Friday and the first 5 skills are critical to have, the remaining are a plus. Most of the
I have developed more than 200 automations, using different platforms supported by VBA, Automation such as Excel to Excel, Excel to Access, Excel to Powerpoint, Web clawring, Excel to Mainframe. Key projects I have developed are enumerated below: 1. Quality Report for Finance, where data is taken from 5 different files, into a single consolidated
NOTE: This is to help us prepare a library for Students who need guidance in EXCEL and VBA. Since this involves no assignment currently due by any recognised University or Institute this is not [url removed, login to view] are small part of ongoing work for a Rural Placement Training Cell, to help students prepare for Job skills. If you are not an expert, please
...necessary (Screenshots etc.). ❶ Vba Case study 2 is about 3 csv files that need to be connected to Excel 64 bit using excel drivers. Then after doing the stated computations (eg. Join/ Merge etc), fetch the solution, load the data ❷ Second is Sql. Again need to solve this in Full. ❸ Please do this only if you are sure that VBA assignment does not need
I have an excel spreadsheet where we need to have our sales people update a specific field every week. I would like to have a notification sent out to the user to remind him that a field is required to be filed base on a date that would be found in another column. Once the sales rep has entered the info, a time stamp of the information would be found
Hello I need a VBA code to import data from Word into a Excel in a certain format to upload it into my app. Each Word file has a variable number of question with multiple choice, always from A) throw E) and the word file has text, equations and some images. If the answer of the choice is zero, in the excel must show " '0 " otherwise the app don't recognize