...see file timesheet report_2018-0805_thru... That file is that copied on to file Construction Tsheets-CRM Transformation and we press CTRL->L for a built in macro to transform into file After Macro Construction Tsheets-CRM Transformation. We need to have the original file timesheet report first mentioned..... have a daily over 8 hours overtime calculation
...wanting to build a budget based app that helps me track my practise,the information and produce built must remain Intellectual Property (IP) Agreement ,i have built a excel macro as a prototype their are a number of macros ,but would like some help CC+ Software or program into a live app ,or iPhone, Mobile App Development, iPad, Objective C, Android
I need to write script for below sample, the query I need to execute is select m.user_id, m.first_name,m.last_name,m.email_id,m.CREATED_DATE, m.updated_date, v.CREATED_DATE, v.updated_date, listagg(v.vendor_number, ', ') within group (order by v.user_id) as vendornumber from USER_MASTER_INFO m left outer join USER_VENDOR_INFO v on m.user_id = v.user_id --and v.vendor_name in ('st...
need a macro that selects only cells with number format (including cells that display as text but actually have a number format e.g. cells with "n.p" ) and copies all number format cells from the input tab to the output tab. Have tried using the goto special function but it won't select the "n.p" cells or cell with a minus figure. plus goto special
The site is: https://pubchem.ncbi.nlm.nih.gov/compound/Triasulfuron#section=Top Input will be a list of chemicals. You need to search for that chemical and extract the data in the attached format. Note that the download tab contains a list of files that need to be downloaded for each chemical. Out of this only the patents file needs to be downloaded
Hi, I need help with database import and datapump. I need someone who can start urgently. I will share details shortly. Regards
Combining several files with certain layout (the data will keep adding every month until 1 full year ) do data processing by macro , presenting summary using pivot and chart
Process daily store sale summary report from text file format into excel database. Based on the excel database stored data, able to search data to analyze sales data by each category by day, by week, by month and generate report and charts. Report need to be intelligent to show where the sales are good and weak. Need report for ordering item based
I need to loop through each row and for any cells that meet the "if" condition, then the cell value 6 columns to the left is displayed....to the left is displayed. I already have the entire code written that can email me the cell values, just needs small modification. Should only take 5 minutes for experienced VBA programmer. Need this done in 1 hour.
...some data has been exported to a .SIM file from an Energy Modeling program. I need to have the .SIM file parsed and *some* of that data exported in a format that can easily be imported to a MySQL database table. I have sample .SIM files, an Excel spreadsheet with a macro that currently parses the .SIM file to populate cells in itself, and a macro to pull
i want to add some logging to powerpoint which logs the slides presented in a powerpoint show adding information to a log for a later review of the contents displayed. Especially should the logging respect the navigation with sections. -- Initially i want to start with a discussion of the ideas and then code samples as needed. -- i expect in the end a simple working code sample i can build on...
We are searching for a experienced developer who has knowledge in both MS Access VBA and one other language such as Python/Rails/PHP. The goal of this process is to achieve the same functionality as before. Please don´t write a long list of accomplishments in your application but rather give me a short explanation how you would handle that problemset
The site is: https://pubchem.ncbi.nlm.nih.gov/compound/Triasulfuron#section=Top Input will be a list of chemicals. You need to search for that chemical and extract the data in the attached format. Note that the download tab contains a list of files that need to be downloaded for each chemical Please bid only after you have gone through the attachment
Need to scrape a webpage that is internally hosted by my company. The data scraping is straight forward. This is the only workaround so please read carefully...I am budgeting for one day's worth of effort. We will need screenshare. I will need for you to give me the VBA script based upon the review of the website. I will enter into excel and get the
...3) ensure that data imported from source CSV's is fully loaded before running excel functions 4) provide notes so I can then make minor adjustments in the future if the base files change What the scripts need to do: A) import data from 2 CSV files. Must be stable for up to 100,000 rows of data and up to 20 columns of data. The CSV data is basic inventor...
Needing a quick macro developed that will use one source of data and compare it to an Excel workbook with multiple sheets. It will identify matches within these sheets and change the matching text in GREEN and the non-matching text in RED. Must be able to accept uploaded information, not cut and paste.
Hello i need to Make integration Between Oracle Rightnow and Avaya (CTI)
I need to automatically download data from the following site: [login to view URL] I need two things to happen: 1. Grab the data on a scheduled basis 2. Be able to download the file in CSV format and save to a folder on a scheduled basis 3. Automatically
The project is: Install a Oracle 11g database in a fresh CentOS 7 server (ssh only and database files should be located on home folder) Configure backup in other folder Run a backup in other Oracle 11g running on AWS Restore the backup on the new server Test and simulate 500 users on this system Resuming: install Oracle 11g and migrate a old installation
I am working on Oracle ICS Integration. I have 2 SaaS Cloud Instance and need to migrate data from one instance to another using ERP/Sales cloud adaptor. I have already established the connection and activated the Instance however ICS Instance is not getting triggered when I create an Item in Source Instance (I am using Business event to Trigger Import
...those graphs are taking the information from the same file with all the data by day included in the same sheet. I need to have a button that says "Weekly" and move all the information of the graphs from Daily to Weekly, of curse summarizing and combining the daily data into weekly data. another button with "Monthly" another with "Quarterly" and...
I have a VBA Macro for scraping data off of a website. The issue is that it comes with duplicates in the excel sheet. I have tried to adjust wait time but this is on and off - works/doesn't work. Need a permanent solution for this so that the VBA just gets the data without duplicates. State your approach to this task and I will hire you.
Using graylog v2.4.6, we require a java plugin. A graylog input (SYSLOG, GELF, etc, over TCP/IP) is configured to use SSL/TLS certificates and to require/optional client certificates. When a message arrives on that input, the plugin should lookup the client certificate Subject field and extract the subject. If present, the plugin should store it in a message field named gl2_remote_tls. If not pre...
Hi, I would like to sort some files according to age, size, length and weight, etc. The drop down functions should indicated ranges which i will provide. Also after completion, i should know how to add and delete those ranges. It should be a fairly simple project.
...the following files: - Current stock (CSV) -Sales of the last 14 days (CSV) -Article Database (EXCEL) The first two CSV files I read about the query function in Excel. I then made a little "program", if you want to call it that, tinkered. I also worked a bit with VBA. However, the tool is very limited. The queried files must always have the same file
I have a VBA Macro for scraping data off of a website. The issue is that it comes with duplicates in the excel sheet. I have tried to adjust wait time but this is on and off - works/doesn't work. Need a permanent solution for this so that the VBA just gets the data without duplicates.
Hi, I have oracle database 11gR2 installed on my windows PC. I like help in doing import of dump and doing some important Parametrization . Work requires you to fire import command and solve issue if anything comes. Regards, Sangam
click each link and indicate in column 'i' with an 'x' if link is leads to photo. If error occurs and link cannot be followed then leave column 'i' blank. Link is in column 'h' EXAMPLE in file: row numbers 228,645 & 228,644
create a simple excel macro that looks up a stock ticker online and place a current price value in an adjacent cell. to have a refresh button on the excel sheet that allows for multiple refresh of multiple cells with one click.
We will provide a set of input files in a folder. Each of the input files need to be read from the folder and based on logic, needs to be converted into another format (excel sheets)