I am looking for a freelancer who can clean and format a small data set of less than 1000 rows in Excel. The specific cleaning task that needs to be done is turning text into numbers. I need your help to clean column W and just give me a number in column X please Ideal Skills and Experience: - Proficiency in Excel and data cleaning - Strong attention to detail - Experience with turning text into numbers in Excel
i got a problem able export data and display in payslip but i need help on getting this payslip saved in pdf and send email based on email column in database ER_EMPLOYEE_DB.EMAIL_ADDRESS. Software - VB.NET and Database is MSSQL
we manually input what is going on in our community centre in column c i require contents of column C to be entered into the dates in coumn E, G, I AND K based on what column a date is and Column c says (match column C with the dates) F, J H, L = C contents reflecting dates which match This should not take you more than 15 mins. Meaning that every date in column A matches everything in colums E, G , I AND K - when those columns match you enter the content of colum C with the date in colummn A to the date in columns E, G, I AND K and then enter column C into F, H, J and L
I need to massively reset all URLs of my products on the Prestashop store.
I am looking for a freelancer who is experienced in Laravel and to implement a date and column filter in PHP. Functionality: - Filter based on specific criteria, such as date range, type, etc Additional Features: - No additional features or functionalities required, only the column filter Deadline: - Today Ideal Skills and Experience: - Strong proficiency in Laravel and - Experience in implementing column filters in PHP - Ability to work efficiently and meet tight deadlines - can work via anydesk as I will not provide access. needs to truely know about the subject.
...following: - Able to apply DIFFERENT discounts on VARIANT PRODUCTS; discounts should be able to change specific variant's price instead of just changing the parent product's price as a whole. - Able to make a table with the following: PRODUCT CODE COLUMN (must be able to use it to search specific products/variants), PRODUCT NAME COLUMN, SELLING PRICE COLUMN and both a PERCENTAGE and FIXED PRICE/CURRENCY DISCOUNT VALUE COLUMN - Said table should have a built-in CALCULATOR on the % and $ DISCOUNT COLUMNS where different values can be input in either column, and the value follows one another. Will explain in-depth through a meeting - Many more functions that we'll explain on a meeting and WE WILL ATTACH MOCKUP/LAYOUT of the plugin we want ...
We have a file that has approximately 9,39...396 lines of cities its really about 4000 or so cities that need to be looked up and then that city population added for all the other lines that are the same city and state. The section you will work with is tab 2, column AB, every one of those rows of cities, the 9396 first rows, those cities all need a population added in column AB. The city and state appear in column AC and AD, It appears there would be a way to do a secondary sort after the AB column to stack the duplicate cities so when the population for each is added you then add to any of the same cities and state right below it. This can be looked up using or wikipedia or any site that gives recent population for cities in the United states. This pro...
I am looking for a skilled PHP developer who can help me resolve an error on my Prestashop 1.7.6.5 website. The site is down eating up CPU to 99-100% and I need someone who can fix this issue as soon as possible. Example error: PHP Warning: Error while sending QUERY packet. PID=4129959 in /db/ on line 156 Skills and experience required: - Proficiency in PHP and Prestashop - Knowledge of troubleshooting and debugging techniques - Experience in resolving website errors and getting sites back up and running - Familiarity with Prestashop 1.7.6.5 and its error handling mechanisms In this project, the main goal is to fix the existing error and restore the functionality of the website. The ideal candidate should be able to quickly identify the cause of the error and imp...
I have 4 diffferent workbooks in first tab titled worksheet, we need to compare to 2nd sheet titled file, and look at column 1 and 2, if applicable, then highlight barcode in yellow in workbook if we find a match secondly, we need the opposite with the file tab. if we have a number in column a or b that does not match barcode in worksheet barcode tab, we need to highlight red
Use population data in file 1 as the ledger, in file 2, for every city and state matching in file two, in column AC and AD, formula will check file 1 and if that city/ state is there in B and C column, then the formula will add the population from file 1, in column D, to file two, in column AB. There will be many duplicate city states in File 2, thats ok, the population still needs to be added for all of them found. For the cities/state that aren't found in file one that are in file 2, the formula or script can just put in those cells for population: "NOT FOUND in Top 1900 city file" This will be a $30 project.
We are looking for a excel expert which can sort data in an document. We need the data to be in same line as before, but all "identical product info, but be in the same column. So Height xxx should be in A, withd should be in B, fabric should be in C ect. So we can map the data correct info our CMS system. If you think you could solve it, I will send exsamble of document
...45,400 Cameo users from This info is publicly available. I need to find the Instagram profile associated with that user. The approach that would make the most sense is the following: Google Search: (Name from Column 1) @(the Cameo Profile name from Column J) site: For example: Column 1: Name - Mick Foley Column J: Cameo URL - Googlesearch: (Mick Foley) @(mickfoley) site: I need the Insta @, the number of followers, the number following, and the number of posts all added to a column on the attached Excel Document. It is fine if a match can't be found. I'd much prefer that the match is accurate. All of this info must be publicly available (i.e., from Google) so as to not violate any terms of service from Instagram
I am looking for a Prestashop expert to help me solve a site performance issue within a week. I am open to suggestions for alternative solutions. I updated my global php on my server and now my webshop is offline. I think because I used an older version of prestashop which is not compatible with the new php version. I need somebody to help me get the webshop back online. Requirements: - Strong experience with Prestashop and troubleshooting site performance issues - Knowledge of best practices for optimizing Prestashop websites - Ability to identify and resolve performance bottlenecks - Familiarity with server configuration and optimization - Excellent problem-solving skills and attention to detail Skills and experience: - Proficiency in PHP, MySQL, and CSS ...
Project Description: I am looking for a skilled freelancer to find and implement the right payment solution for my multi-vendor website. The primary goal is to streamline the payment process and provide a seamless experience for customers. Requirements: - Experience in implementing payment solutions for multi-vendor websites - Familiarity with digital products and their specific payment requirements - Ability to research and recommend the most cost-effective payment gateway for the website - Knowledge of different payment gateways and their features - Strong problem-solving skills to address any payment-related issues that may arise Ideal Skills and Experience: - Experience with integrating payment gateways such as PayPal, Stripe, or Braintree - Knowledge of APIs and their int...
Hello, I'm looking for some help setting up an online shop for drop shipping. I'm planning to use the Shopify platform and I'm open to suggestions with regards to the product line that I should be selling. I'm looking for a partner who can help me set up the shop and oversee the day-to-day operations of it, while still allowing me some involvement in the process. This could include identifying products to sell, setting up payment and shipping processes, managing customer inquiries, and executing marketing strategies. Ideally, the setup process should have me ready to start selling within a few weeks. If you have the necessary experience and are up for this challenge, I look forward to hearing from you. Thanks!
Need someone to help me to split a big CSV file : - File size 280Mb / 2.794.000 lines - Not OK to load in excel - Need to filter 1 column, based of 1st digit : "start by 1" + "start by 4" .. ... - Load results in excel
...VARCHAR(256), PRIORITY VARCHAR(50), REDIRECT_NUMBER VARCHAR(15), TREATMENT VARCHAR(256), RULE_ID NUMBER(19,0), BUSINESS_HIERARCHY_TABLE NUMBER(19,0), ERROR_MESSAGE VARCHAR(256) ) CREATE OR REPLACE PROCEDURE SCHEMA.ROUTE_REQUEST (parameters IN ROUTING_KPV_TABLE, route_response OUT ROUTE_RESPONSE); I used SQLData mapping for the classes, but I am not sure how to nest this call, or if I am using the right structures to simulate how the SQL/PL is doing the same as follows: var v_output varchar2(100); var v_queue varchar2(256); var v_redirect_number(100); var v_treatment number; var v_rule_id number; var v_hierarchy number; var v_priority varchar2(256); DECLARE P SCHEMA.ROUTING_KPV_TABLE; ROUTE_RESPONSE SCHEMA.ROUTE_RESPONSE; BEGIN P:= SCHEMA.ROUTING_KPV_TABLE ( SCHEMA.ROUTING...
I have a DevExpress grid control with cell selection. User can click to select different cells. When copied and pasted in Excel, I need the cells selected to have the values and format/layout the same. It can be any configuration the user selects. It needs to be fast. (meaning if there are gaps, etc.). It also needs to include the column headings. For example, in screenshots. It needs to be in VB.NET 4.7+ Winforms. If you need to install devexpress, they have trial you can use. I am looking for a working solution, fully tested, with clean code. Please submit your bid with the answer to: 6 X 8. (to screen out fake bot bids, which is extremely annoying). Max bid: 20
I am in need of professional development right away, and am looking to improve my communication skills through ongoing development. My preferred method for learning is online courses, which will give me the ability to work at my own pace and review the materials as much as I need. If you have the knowledge and experience to help me improve in this area, I would greatly appreciate your help and look forward to working with need the developer builder please inbox me for more details on nancykim580 at gmai l c om
I am looking for a VB Script expert who can create a program for me to automatically assign meeting rooms...who can create a program for me to automatically assign meeting rooms based off a fixed number of meeting pods and depending on the duration of the meeting. The fixed location for the meeting rooms is in Meeting Pods and they can range from 30min to 1hr, or however long I assign. There are 30 meeting rooms available for assignment. The data to feed this script would be in excel i.e column A - Customer Name, Column B - Meeting Time and fixed number of meeting rooms to assign from. Example if meeting 1 is from 9 - 9:30am a meeting pod is assigned and the meeting room is available after that for further auto assignment. The objective here is to avoid assigning the meetin...
I'm in need of an Excel spreadsheet that allows me to input the completion time for a specific task into a designated column (e.g., 5:22 PM). I'm seeking Excel to automatically create a countdown lasting 24 hours from that moment and, during this countdown, highlight the entire row in a subtle red color. Once the 24-hour period concludes, I'd like the entire row associated with that task to transition to a green color. To illustrate my request, I've uploaded an example Excel sheet where Column G represents the "last time played," which is where I'd like the countdown to be implemented. However, I'm open to any alternative suggestions you might have. My budget for this project is limited, so please provide the most cost-effective quote ...
Project Title: JIRA Developer Needed for Creating Multiple Workflows and Configuring Permissions I am looking for a skilled JIRA developer who can assist me in creating multiple workflows in JIRA and configuring permissions based on a technical design document. The desired outcome of this project is to improve task tracking and accountability within our organization. Specific requirements include: - Creating multiple workflows in JIRA to streamline project management - Configuring permissions to enhance collaboration and communication - Assisting with defining specific permissions and roles, as they are not currently fully defined - Discussing and creating permissions for more than 50 users who will be using JIRA Ideal skills and experience: - Strong knowledge and experience with JIRA d...
Project Title: SEOs, increase website visibility (website not visible right now) Description: - My website is currently not visible at all and I am looking for an experienced SEO specialist to improve its visibility. (I already added it to my Google search engine) - The main focus is on improving visibility in search engines, specifically targeting local audience. - The ideal candidate should have proven experience in SEO strategies and techniques to optimize website visibility. - Knowledge of local SEO is a must, as the target audience is local. - Familiarity with search engine algorithms and best practices is required. - The SEO specialist should have a track record of successfully increasing visibility for websites with similar goals. - Strong analytical and problem-solving skil...
Busco un freelance que pueda ayudarme con mi proyecto Prestashop. Necesito específicamente ayuda con la actualización y configuración de la tienda. Diseño y tema: - Tengo algunas ideas para el diseño y la temática, pero estoy abierto a sugerencias. Listado de productos: - Inicialmente, planeo incluir menos de 20 productos en mi tienda. Habilidades y experiencia ideales: - Dominio de Prestashop y experiencia en instalación y configuración de tiendas. - Capacidad para trabajar con clientes para personalizar temas e implementar ideas de diseño. - Conocimientos de listado y gestión de productos en Prestashop. - Gran atención al detalle y capacidad para garantizar una experiencia de tienda en l&...
I am seeking a skilled and experienced Prestashop developer to help me create a new website to replace existing bespoke website. I do not have designs ready, so I will need help with that aspect of the project as well. My timeline is flexible, so I am not under any pressure to complete the project within a specific amount of time. The desired features and functionalities of the website include home page design and 1 product, Stripe product and subscription payment gateway integration. Webhooks for creation of new orders, automated emails, switch on and off service automatically. The product is a VPN router with monthly subscription. Integration of existing customers and Stipe subscriptions. Work with our network engineer to link website to VPN server SQL databases. If you hav...
I am looking for a developer with experience in Prestashop to help me fix a bug in my website's cart functionality. Project Details: - Version of Prestashop being used: 1.7 - Bug description: The bug occurs consistently, although I am not sure what the exact error message is that is being displayed. - Ideal skills and experience: - Proficient in Prestashop development - Experience in troubleshooting and fixing bugs - Ability to work with intermittent issues and identify the root cause - Strong problem-solving skills - Attention to detail to ensure a thorough fix Display error message in console : Frontcontroller::init - Cart cannot be loaded or an order has already been placed using this cart When I added product on a single page :
I am looking for an experienced freelancer to automate transferring both text and number data in an Excel file to MS Access in a table format, on an hourly basis with timestamps. he data in excel will be updated in cell (no new row or column) but data in access to create new row or column to reflect new data with time stamps (so that we have historty or all values). so its not just about going to access and choosing excel as source The freelancer must have experience in working with both Excel and MS Access in order to successfully form the connection and ensure that the system works quickly and reliably.
Objective : to import data from multiple excel files (source file) located in a folder (Source Folder). Each file contains one sheet and the contents of the sheet must be copy/pasted to a specific sheet in another excel file...sheet), paste it to specific sheet in the Destination File. The name of specific sheet in the Destination File is mentioned in the cell D6 of source file. Step 2: Copy the Source File and paste it to a Backup folder with a new file name. The file name is the text mentioned in cell D6 of same source file. Afterwards delete the source file. Step 3: Write to a specific location (next empty cell below column A) in Destination File "processed <text from cell D6>" Step 4: Repeat the above steps till all files from Source Folder is processed Step5...
Please see the URL below for sample files for thi... Assume that there are 2x Input files. The first file is a Microsoft Excel XLS or XLSX file. The Excel file has a list of items in a first language in Column B. The Excel file has the associated translations in second language in Column C. The second file is a Microsoft Word DOC or DOCX file that contains text in both the first language and the second language. We need a script that replaces the words in the Word document that match Excel Column C with the associated translation in Excel Column B. The replaced words should be indicated by {{replacedText}}. Candidates should state which language (such as Python) they plan to use for this project. Thank you
I need a Formula or script to look up each city, and State in column AD and AE from Freelancer File 2, look up each city in Freelancer File 1, column E and put the population in column AC of File 2. Another way to say this is for every city in file 1, column D, add the population of that city to column AC of file 2 for every matching city. Many cities appear multiple times in file 2 so this might be an easier way to understand the need, but the result should be: Every city in File 2 in column AD should have the population added next to it in column AC, even if the same city appears many times in the list, it still needs the population added. This project will pay $40 dollars.
Cerco esperto di web analytics per impostazione dati, tracciamenti e pixel lato server.
...total) you will start by looking at a vacation balance total number listed on one Excel file. -On another report you will identify if this staff member should have 3, 4 or more weeks of vacation -Using the total number from report 1 you will subtract either 30 hours, 40 hours or more based on vacation allocation. -the final number will be entered into the Vacation balance column of the master document. -Another column shows sick time balance. If a balance exists, 20 hours should be removed from the total and transferred to the master Excel file under the appropriate employee Skills and Experience: - Proficiency in Excel and data analysis - Experience working with Excel files - Attention to detail and accuracy in compiling reports Timing - Please respond if you have ...
I am looking for a skilled developer who can help me optimize the mobile version of my Prestashop website to improve its loading time. The current loading time is more than 5 seconds, which is not acceptable. The main focus of the speed optimization should be on improving the general browsing experience. The end goal of this project is to achieve both a better user experience and a higher Google Page Speed Score. The ideal candidate should be able to analyze the current website performance, identify areas of improvement, and implement effective speed optimization techniques. www Air Gun pl Prestashop 1.7.6 theme "classic-rocket" If my theme is too outdated to get good results I am open to buying a new one and implementing it. Please price quotes for the e...
On a LEMP VM running Prestashop, we're looking for someone who can make adjustments to improve performance. We need to install a Varnish cache, which could improve performance without being the only thing to do. The mission is to fine-tune the LEMP server to ensure Prestashop efficient operation. Prestashop should expect performance of 90 on PageSpeed Insights and Gtmatrix.
...important: 1. the website contains 4 drop downs namely District, Tehsil, RI and Village. 2. for each district there are various tehsils, for each tehsil various RIs and for each RI various villages. 3. when you select a particular village, it will show its map on the right. When you zoom in you see different plots. 4. when clicked on a particular plot, it will (in most cases) show its details on the left hand panel. These details will include: type of land, area, plot no., name, father's name and address. 5. i require these 6 details column-wise in an excel file for each village listed on the website. 6. i need the data in 3 to 4 days to be worked upon for a time bound project. Please let me know if anyone having good know-how of Python or other suitable languages c...
Hi Vishal You did an excel project for me before. Can you please help me to add a two column look up to my spreadsheet?
...obtain what I want. More specifically, a single table contains columns including but not limited to: date, name, employee, hours, rate, costs, payments, description. The purpose of the report is to generate a service ledger that shows the calculation of (Hours * Rate - Costs + Payments) for each row in a virtual column, and then total of the column in the footer. The report does not need to be generated automatically on a regular basis, but only as needed. Ideal skills and experience for this job include: - Proficiency in MySQL, WordPress, WPDataAccess, JSON, Javascript, - Experience in creating reports and working with databases - Strong attention to detail to ensure accurate calculations in the report.
Hi Krishnamurthy K., I wish to get your services again to help add a column to our Transfer Order report in Dynamics NAV 2015. We wish to add "Search Description" to the report.
I am looking for a skilled Photoshop editor who can seamlessly swap the head of the guy in the selfie onto the guy on the right, making it look realistic. Requirements: - Proficiency in Photoshop and experience with photo editing - Attention to detail to ensure a seamless and realistic head swap - Ability to work within a tight deadline and deliver the final edited image within 24 hours Additional Information: - No additional edits or adjustments are required, only the head swap is needed - The desired outcome is a realistic-looking image - The deadline for the project is within 24 hours
I am looking for an artist to create a drawing of Jesus playing pickleball with a pickleball paddle in his right hand about to hit a pickleball that was just hit to him. I would like the drawing to be a cartoon style, rendered digitally in a medium such as Adobe Illustrator or Photoshop. Once finished, the drawing will be used commercially. If this description fits your skillset, I invite you to submit a bid for this project. Thank you!
Data insertion for Maps I am looking for a freelancer to help me with inserting data into GMaps and BingMaps for mapping purposes. The ideal candidate should have experience in data entry and be familiar with working with maps. how it works: - CHECK THE ATTACHED EXCEL FILE - Column "Add Website", get that URL and insert to the "Map URL" link in google maps. Try to not do from the beginning, most of the freelancers are going by the order.. so it make no sense for you to get approved by google. Better to find locals not known from the list. I will reward the individual who achieves the highest number of approved link insertions on Google Maps. Based on the number of your link submissions that are successfully accepted and published by Google Maps.
Necesitamos migrar la base de datos de clientes y los pedidos de un prestashop a otro. El Prestashop origen es 1.7 mientras que el de destino es 8.1. Necesitamos que los clientes migren con contraseña para que puedan acceder a sus cuentas en la nueva web.
1) for the choices that end up in the “Hams” column, there is now only one options to pull from: now choose your ham stamp (photos are at the bottom of this page): Otherwise this should stay the same. 2) in the previous version, we had entries with the same name in SHIPPING NAME twice or more in a row get put into the blue section. I’d like to do put these in the green section instead. 3) There are two new types of products in “Product Name”: a) Anytime something in “Product Name” contains the words “ham tents - series”, color the row pink and move it to the bottom of the sheet (beneath the blue section) Also create a new tab named TENTS that contain these rows b) Anytime something in “Product Name” contains th...
I am looking for a skilled developer who can create a correct module for Prestashop 8.1 with specific functionality and features. The ideal candidate should have experience with payment gateways and customization services. am looking for a person to repair the Prestashop 8.1 module It doesn't work with version 8.1 because there is an Ajax error No auto refresh basket
Ive got a sheet where we log faults on machines. The person logs the machine number, what fault it was, and then the Time booked in, and time booked out. I need the time in and time out, for the person to select it very easy, and then it should automatically calculate the downtimein the last column. When the person press Finish it should export this to a excell file. The machine number, Fault, Time in, Time Out and Total Downtime
...VARCHAR(256), PRIORITY VARCHAR(50), REDIRECT_NUMBER VARCHAR(15), TREATMENT VARCHAR(256), RULE_ID NUMBER(19,0), BUSINESS_HIERARCHY_TABLE NUMBER(19,0), ERROR_MESSAGE VARCHAR(256) ) CREATE OR REPLACE PROCEDURE SCHEMA.ROUTE_REQUEST (parameters IN ROUTING_KPV_TABLE, route_response OUT ROUTE_RESPONSE); I used SQLData mapping for the classes, but I am not sure how to nest this call, or if I am using the right structures to simulate how the SQL/PL is doing the same as follows: var v_output varchar2(100); var v_queue varchar2(256); var v_redirect_number(100); var v_treatment number; var v_rule_id number; var v_hierarchy number; var v_priority varchar2(256); DECLARE P SCHEMA.ROUTING_KPV_TABLE; ROUTE_RESPONSE SCHEMA.ROUTE_RESPONSE; BEGIN P:= SCHEMA.ROUTING_KPV_TABLE ( SCHE...
Create an account in SSRN.com. (To enhance author privacy, SSRN uses software to prevent mechanical harvesting of email addresses. Anonymous users are allowed 3 email address requests each day.) Sign-in and go to: Browse / by JE...privacy, SSRN uses software to prevent mechanical harvesting of email addresses. Anonymous users are allowed 3 email address requests each day.) Sign-in and go to: Browse / by JEL code They have 20 Subject areas from A to Z Opennig each Subject area, there will be several subareas It will open a list of several papers From it, get and save: JEL code, Title; Posted date and author's name (one name by column) Then click authors names / Contact / email. Then save the email. Some numbers to scrap: Full Text Papers:1,122,723 Authors:1,389,1...
I am looking for a designer who can create 2 event posters for a carnival. The posters need to be available immediately. Poster must be created on Canva and then shared with me. Have a clear base example of the design need completed. Needs to be completed immediately (within 1 hour)
I am looking for an experienced freelancer to help me with a project involving V-Lookup and Excel spreadsheets. The task is to add mailing addresses from one spreadsheet to a second Excel spreadsheet. Here are the specific requirements for the project: Format of the mailing addresses: Separated fields (street, city, state, zip) Column/order for adding addresses: No specific order, any order is fine Additional data fields: No additional fields, just the addresses Skills and experience required for this project include: - Proficiency in Excel and V-Lookup - Strong attention to detail to ensure accurate data transfer - Ability to work efficiently and meet deadlines If you have the necessary skills and experience, please submit a proposal. Thank you.
