Excel vb convert array dictionary työt
FIN... Excel-tiedosto sisältää satoja rivejä eri tuotteita, joista on esimerkiksi seuraavat tuotetiedot: positio, tuotepyyntö, tuotevaatimus, tuotenimi, tuotenumero, tuotekuvaus, hinta ja kuvakuvalinkki. Näistä tiedoista pitäisi saada atomatisoitua tuotekortteja. Tuotekortti on käytännössä A4-kokoinen PDF-dokumentti, jonka yksi sivu on yhden tuotteen tuotekortti. Mainitsen tässä InDesignin, koska sitä osaan käyttää ja ajattelin, että jos voin määrittää InDesigniin kenttien paikat, niin olisiko mahdollista, että Excel-tiedot tippuisivat jonkin scriptin avulla näihin kenttiin ja ikään kuin visuaalinen ulkoasu pysyisi koko ajan omissa hyppysiss&a...
Usealla isolla yrityksellä on käytössään Suomessa eräänlainen heidän alansa ERP-paketti, joka on koodattu Visual Basicillä. Tarvitsisimme VB-osaajaa ylläpitämään ohjelmistossa mahdollisesti tehtäviä muutostöitä. Tekniikka lyhyesti: • Visual Basic -koodia noin 280-290 000 riviä • Integraatio taloushallintoon ja palkan maksuun • raporttipuolella n. 50 000 riviä • Crystal Reports • Microsoftin SQL Server -kanta Työmäärät vaihtelee, mutta keskimäärin 1-2 päivää/viikko. Välillä hiljaista.
Hei, Olen tuore asfalttialan yrittäjä (yrityksessä neljä henkilöä) ja tarvitsen seuraavia palveluita: myyntilaskujen luominen työkirjanpidosta (kilometrien laskeminen, eri työkohteiden erittely ja eri työtyyppien erittely). Osaat käyttää sujuvasti exceliä ja muita perustoimisto-ohjelmistoja. Laskut kootaan viikon loppupuolella, kun viikon työt on tehty. Mahdollisesti muuta toimistotyötä tarjolla myöhemmin, jos osaava henkilö löytyy.
Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies the Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is available and the Project needs to be done using Visual Studio. Azure SQL database management and required SQL queries are not in the scope of the Project.
Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies andthe Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is avaiable and the Project needs to be done using Visual Studio. Azure SQL database and required SQL queries are and database management is not in the scope of the Project.
Toimitamme tuotetietokannat excel-tiedostoina, tuotteiden valokuvat ja tuotteiden avainsanat yms. ja ne syötetään csv-tiedoston avulla hakukoneystävällisesti (esim. Woothemes Product CSV Import Suite + Yoast Woocommerce) wordpress-sivustolle, jolle on jo asennettu woocommerce ja jossa on jo tuotteita. Tuotteita tulisi lisää noin 200-400. Woocommercea käytetään Catalogue-modessa, eli sivusto ei ole varsinaisesti automatisoitu verkkokauppa.
2200 kuvausta, excel. referenssitiedosto sekä kuvia ja englanninkielinen käännös käytössä. paljon toistoa. laadukas käännös.
I'm in need of an Excel macro expert who can help me with a data arrangement task. The task involves transferring sequences of cells data from one grouped workbook to multiple original workbooks and worksheets. The data transfer should be based on specific criteria. Key Requirements: - Data transfer based on a specific criteria: The macro should transfer data based on a specific criteria. This involves arranging the data from the grouped workbook into different cells in a column in the original workbooks based on predefined conditions. - Conditional Logic: The macro should include conditional logic. This means that the data transfer should not just be a simple copy-paste operation, but should involve logical conditions for accurate and efficient data arrangement. - Potential...
I have identified the specific CPP code that needs to be converted to Java. The CPP code interacts with external systems and the Java code should maintain a similar code structure as the CPP code. Key Requirements: - Convert CPP code to Java: You should be experienced in both languages and possess a strong understanding of how to translate complex code structures. - Maintain a Similar Code Structure: The Java code should be as close as possible to the original CPP code in terms of its structure. I'm looking for a developer that can efficiently convert the code and ensure that it maintains the same ability to interact with external systems. Ideal Skills: - Proficient in C++ and Java. - Experience in translating code from one language to another. - Knowledge of working...
Provide: 1. French and 2. German translations for the static strings used on a website. I've compiled a list of all the static strings on a website. A native French speaker and a native German speaker are needed to update the Excel file attached with the translations from: 1. English to French and 2. English to German Thank you!
I'm in need of a Verilog expert proficient with Quartus Prime Toolchain. Key Requirements: - Professional with Verilog: Need someone experienced in designing digital circuits and implementing specific functionalities using Verilog. - Proficiency with Quartus Prime: Familiarity with the Quartus P...implementing specific functionalities using Verilog. - Proficiency with Quartus Prime: Familiarity with the Quartus Prime Toolchain is a must. I need to design, simulate, implement and test a digital circuit using the Quartus Prime toolchain as per the specifications I will provide and demonstrate the workflow when using the Verilog HDL to construct a design for a physical Field Programmable Gate Array (FPGA) target. Please apply if you have the required expertise. No teams or co...
I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.
I'm seeking an experienced social media manager to enhance my TikTok account. I primarily post promotional product videos and I'm looking to convert these views into purchases. Key tasks includes: - Integrating a link to my online store in my account. Proven experience in seamlessly linking social media accounts to web stores is necessary. - Implementing strategies to better use user-generated content to promote my products. Experience in leveraging user-generated content for promotion is a must. Your expertise should lead to an increase in the conversion of clicks into buying clients. If you are knowledgeable in TikTok's algorithm, and have a proven record in growing audience and conversion rates through engaging content, apply. Thank you. TIKTOK ACCOUNT: @wonde...
I'm looking for a skilled professional who can successfully convert 2D images to 3D. The specifics are: - The images I provide will be in JPEG format. - The 3D conversion should be in STL format. - The final 3D result will be used for designing human images. Ideally, you should have proficient knowledge and solid experience in 3D modeling and image processing. A good hand in tools like 3D Studio Max, Blender or similar is needed. Experience in designing human figures in 3D is a massive plus.
I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.
...request to courier confirmation. *** Current Process *** (The current process excel files will be given aswell as the detailed process) Request Submission: Teams within the company fill out an Excel file with transport details, including pickup location, destination, size, and weight of the shipment. Courier Selection: The logistician identifies 3 or 4 potential couriers from a database based on the transport's distance, size, and location. The logistician contacts these couriers via Outlook to inquire about availability and pricing. Selection and Confirmation: Upon receiving responses, the logistician selects the best courier based on price and availability. The logistician fills out an order form in Excel, converts it to PDF, and sends it to the chosen co...
I need a seasoned developer to convert my existing Swiftic app into a freestanding app that can be listed on the App Store, Google Play, and Amazon. The app is currently accessible via www.ecosmartecloud.com. Skills and Experience: - Proficiency in Swift programming language - Experience in converting existing apps to standalone apps for multiple platforms - Familiarity with submitting apps to App Store, Google Play, and Amazon - Knowledge of push notifications and user login/authentication systems The main purpose of this app is to provide a platform for communication. Key features I'd like to retain after the conversion are push notifications and user login/authentication. Please let me know your prior experience with similar projects, as well as any ideas or suggestions ...
...customers specifically from the hotel industry. Your prior experience in sales in this sector is essential in understanding the nuances of this market and effectively generating leads. - Lead Conversion: While generating leads is important, converting them into actual sales is equally crucial. You should be proficient in sales techniques and understand the hotel industry well enough to effectively convert leads into customers. Ideal Candidate: - Prior Experience: A strong background in sales, particularly in the hotel industry, is a must. You should have a proven track record of generating leads and converting them into sales. - Understanding of Hotel Industry: An in-depth understanding of the hotel industry is essential. This will aid in identifying potential leads, understand...
...Target Audience: Your efforts will be focused on reaching out to: - Residential Homeowners - Commercial Businesses - Both Residential and Commercial Sectors Preferred Communication Channels: - Phone Calls: You'll be expected to make outreach calls to potential customers, explaining our services and generating interest. - Email Marketing: Crafting engaging emails to showcase our offerings and convert leads. - Digital Advertising: Leveraging online platforms to run targeted campaigns and boost our brand's presence. Ideal Skills and Experience: We are looking for a proactive and results-driven candidate with a strong background in sales and marketing. In addition, the following skills will be essential for this role: - Proven track record in lead generation and sales - E...
I'm in search of a skilled social media marketer who can use their expertise and experience to help generate leads for my business. Key Responsibilities: - Strategize, develop, and execute social media campaigns across Facebook, Instagram, and Twitter - Drive engagement with our target audience - Implement lead generation techniques to convert followers into potential leads - Track and measure the effectiveness of the campaigns to ensure they align with our lead generation goals Ideal Candidate: - Proven track record of lead generation through social media - Proficiency in Facebook, Instagram, and Twitter marketing - Understanding of various social media analytics tools - Strong communication and interpersonal skills - Creative thinker with the ability to develop innovative ...
Hi Rahul - I have an excel sheet that we currently use to calculate fees based off different calculations. I would like this form to be simpler, and easier to use.
I'm looking for an experienced Power BI specialist to create a dashboard for me. The data that I would like to be integrated into this system is in an Excel spreadsheet. Key project requirements include: - Creation of a detailed and interactive Power BI dashboard - Integration of Excel data sources into the dashboard - Configuration of the system to ensure real-time data updates Ideal Skills/Experience: - Proficiency in Power BI, particularly in creating dashboards - Experience in integrating data from Excel spreadsheets - Understanding of how to configure real-time data updates in Power BI.
We're a dynamic agency specializing in helping businesses stand out on YouTube. We're currently on the lookout for a YouTube SEO specialist to boost the visibility and ranking of our high-quality content on the platform. Key Responsibilities: - Implement advanced SEO techniq...techniques specific to YouTube. - Proficiency in utilizing analytics tools to drive decisions and enhance content performance. - Strong creative skills for developing eye-catching thumbnails and titles. - Passionate about the YouTube platform and staying up-to-date with the latest trends and algorithm changes. If you're ready to join a results-driven team and help businesses across various industries excel on YouTube, we'd love to hear from you. A perfect opportunity to apply your SEO exp...
I am seeking an experienced developer to convert my existing web application into a Progressive Web App. The end goal is to have the PWA published on both the Google Play Store and Apple Store. Key requirements for this project: - Proven experience of converting web applications to PWAs - Able to prepare and guide the process of publishing the developed app on appropriate platforms
Beginner level freealancer to create an mcq list for moodle quiz website in Aiken formatting. Aiken format I am following is Frusemide tablets 40mg tablets are in stock. How many would you give for a dose of 120mg? A) 3 tabs B) 2 tabs C) 4 tab...Question and Answer pdf is given, In the format mentioned above, just add another 3 options in Google sheet, and write the answer in Aiken formatting. Note: The question should be in one line (cell). After Each "ANSWER: X" is marked, the next line/row will be blank. Can you do a sample for the first 3 mcq? Can you do this for a 5-star review and lowest price? Do the sample in the attached Excel file by referring to the PDF attached. For sample, do the 3rd, 4th and 5th question as example in google sheet online and share th...
I'm looking for an illustrator to vectorize a few png images (and convert them to SVG) Quick task
Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.
...will be responsible for inputting and maintaining various financial data into spreadsheets and databases. - Accuracy and Attention to Detail: Ensuring the provided data is accurately entered, including cross-referencing and validation. - Data Quality: Assisting in maintaining the quality of the data and suggesting improvements where necessary. Skills and Experience: - Proficiency in Microsoft Excel is a must as this will be the primary tool used. - Previous experience in finance-related data entry is advantageous but not mandatory. - Strong attention to detail and accuracy are highly valued. - Understanding of basic financial jargon will be beneficial. This role requires someone who is organized, reliable and able to work independently. The workload will be part-time with flex...
Necesito crear ficheros XML para ser importados a un ERP (software contable y de producción basica), generados en base a: 1. Una tabla de Excel con información a ser importada. 2. Una estructura XML predeterminada para la creación de ordenes de producción 3. Unas condiciones que hay que cumplir para que se pueda generar correctamente el fichero XML Probablemente una vez realizado el proyecto, se podría se necesitar realizar algunos ajustes o cambios puntuales, que en todo caso serán pagados. El diseño tiene que ser modificable en Visual Basic Busco seriedad, profesionalidad y mucha rapidez.
Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.
...relevant answers from PDF files content. Experience and Skills: - Strong understanding of natural language processing - Previous experience with developing chatbots - Familiarity with sentiment analysis - Ability to create personalized recommendations for users - Skilled in extracting and understanding content from PDF files - Strong problem-solving skills and attention to detail Details - Upload Excel file containing Expediente Codes - Use automation and OpenCV to solve Captcha and download files - Upload files to s3 bucket - Integration with existing system - use google to authenticate to the system (maybe change to office 365) Requirements: - REMOTE SERVER: Existing server - Access to S3 Bucket - Access to chatgpt api - Access mysql aws instance We need acc...
I need a freelancer to search for the "Business Directory" URL on 342 websites. The websites are in the following sheet (I have added business directory URLs for the first four entries, as a sample): You will search for the business directory URL on each website, then enter the URL in the "Business Directory" column of that Google Sheet. (Note: some websites don't use the exact term "business directory". What I'm looking for is the web page on each site that contains the list of businesses in each city, so the business directory could be called something else, for example "business listings".) The task is a one-time search. My budget is $20. This is an excellent project for a new freelancer who is looking for a 5-star review.
I have a PDF membership directory that was emailed to me. I need someone skilled in data extraction to help convert it into an easily readable CSV file. The ideal candidate should possess: - Proficiency in working with both PDF and CSV file formats. - Strong data extraction skills. - Attention to detail for data accuracy. Each member listed per row with the perinate contact information separated into its own cells ie: entity/last name/first name/address/ste#/city/state/zip/office ph/email/cell ph The task should be completed by 5/23/24.
Being a business owner, I am in the market for a professional web designer who can ...in the market for a professional web designer who can craft a website for business promotion. The principal objective of this website is to generate leads. The ideal candidate for this job must have: - Expertise in designing user-friendly websites that boost engagement and demonstrate a clear lead-generation focus. - Proven success in incorporating effective "contact us" forms that capture and convert potential leads. - Proficient in modern design tools and web technologies. - Strong understanding of best design practices to maximise user engagement and conversions. This project is your opportunity to showcase your skills in responsive design and lead generation. I am excited to see w...
Buscamos una persona española que ayude a limpiar los datos de un CRM nuevo, subir datos de excel, validarlos o buscar nuevos con herramientas de Marketing.
I need a WordPress website developed from my Figma design. The design is complete and I need the site to be an exact match. Key requirements: - Convert Figma design to a fully functional WordPress website. - Ensure that the website design is pixel-perfect. - Adhere to provided color scheme and branding guidelines. Ideal Skills and Experience: - Proficiency in both Figma and WordPress is a must. - Experience with Cpanel hosting. - Strong understanding of responsive design for different devices. - Attention to detail to ensure the design is exactly matched. PLS NOTE: This is an urgent project to he started today and delivered by Sunday. I cant accept any bid that does not comment on figma to wp experience.
We are developing a spreadsheet-based database of the most popular English quotations (or English translations), and are looking for a researcher with native English language skills who can identify and collate (into Excel or Google Sheets) the following requirements, providing the quotation, the author, and the source document (if available): - 1,000 most popular quotations from literature (prose and poetry), excluding Bible quotations and the works of William Shakespeare - 500 additional most popular English language quotations in addition to the above (from non-literary sources - 200 of William Shakespeare’s most popular quotations Maximum length of each quotation is 55 words. Extensive source material is available online, and we encourage the use of existing source mate...
I have a large set of handwritten notes that need to be accurately transcribed into digital format. I need someone who is meticulous and has a keen eye for detail, as the work needs to be done with no errors. Key Requirements: - Type ...keen eye for detail, as the work needs to be done with no errors. Key Requirements: - Type of Job: Data Entry - Data Format: Handwritten notes - Level of Accuracy: Very High (no errors acceptable) Ideal Skills: - Proficient in typing - Detail-oriented - Experience in data entry, particularly with handwritten notes - Ability to follow instructions accurately and efficiently Your task is to convert these notes into a digital format, ensuring every detail is captured accurately. Your attention to detail and commitment to producing error-free work i...
I need an experienced data entry freelancer who can assist with a high priority task. The project involves inputting data into an Excel spreadsheet and carrying out online data entry tasks. The ideal candidate will be proactive, detail-oriented, and able to work efficiently with minimal supervision.
As discussed, this includes the following - 1. Automated trading functionality in excel using the TWS API 2. Customization of entry and any other rules post discussion 3. Python codes 4. Deployment support and 2-weeks support for smooth operation
I'm seeking a skilled professional translator to convert a 10-30 minutes English video into Spanish subtitles. The video is entertainment content and must be translated accurately, with attention to detail to maintain context and humor. Key Requirements: - Fluency in English and Spanish - Proven experience in video subtitling - Background in entertainment translation preferable - Ability to match subtitles with audio cues - Proficient in relevant software for both embedding and providing subtitles as separate SRT files The output should be provided as both embedded into the video and as a separate SRT file. It’s important that the video maintains its original tone and humor, so experience in translating entertainment content is highly desirable. If you have a backgroun...
I am in need of someone adept in Excel and knowledgeable in medicine, especially in dosages and weight-based calculations. The challenging aspect of this project is to modify an existing locked Excel spreadsheet which is used to calculate dosages once a patient's weight is entered. Tasks involve: - Updating the dosages of specific medications based on the guidelines I have on hand. - Modifying the weight-based formula in alignment to these dosage updates. Skills and experience: - Proficient in Excel and worksheet protection - Comprehensive understanding of medical dosages - Experience or understanding of weight related dosages calculations. I will provide the necessary medication and dosage guidelines to the successful bidder for reference. The idea...
Experienced UX/UI designer with a strong background in Figma and current design trends wanted to work on a web app project. KEY RESPONSIBILITIES: - Design up to 20 standalone desktop screens or 30 mobile screens monthly - Convert sketches and wireframes into finished mockups - Create visually stunning and intuitive interfaces that enhance user experience - Collaborate with the team to brainstorm ideas then turn concepts into user-friendly interfaces - Redesign desktop screens for mobile responsiveness - Proactively provide creative solutions and improvements to existing designs and user flows - Please include the key word 'Lavender' in your bid to indicate you actually read the brief CANDIDATE REQUIREMENTS: The candidate should... - Be creative - Have strong Figma ski...
We need an experienced, creative graphic designer to design our flyer. The flyer size should be 1x1. Once we have finalised and accept your flyer, you will be required to convert it to a banner for our website. We also require the psd or ai files at the end of the project. See all the information for the flyer and examples on the link below:
I need an expert in Optical Character Recognition (OCR) technology to convert text from high-resolution, clear photographs to editable text. Key Project Details: - **Purpose**: The primary objective of this task is to extract data from various documents. - **Image Type**: The text extraction will specifically be from photographs of text. - **Image Quality**: All photographs are high resolution and clear. Ideal Skills and Experience: - Proficient in Optical Character Recognition (OCR) technology - Prior experience in extracting data from images - Excellent attention to detail to ensure accurate transcription - Ability to work efficiently with high-resolution images
I’m looking for a skilled copyrighter to create blog articles for our website. Here I'm interested in three articles 800-1000 words each - feel free to make more engaging titles: 1. "Technologies and Frameworks Used in Online Banking Software" 2. "Benefits of building custom virtual wallet solutions into your product" - here to speak about features of virtual wallets, flexibility to convert credits in exchange for additional services, etc. 3. "Compliances and certifications that might be needed for a financial services startup" - explore main compliances for the US and European countries a fintech software startup should know about. The main goal of these articles is to educate our audience. Therefore, the content should be informative, ...
I'm looking for a Google Ads expert to help me increase leads for my car rental business, specifically targeting local customers. Key Requirements: - Pr...- Proven experience in running successful lead generation campaigns on Google Ads - Strong understanding of local SEO and how to target customers in my area - Experience in the car rental or automotive industry would be a plus Your main task will be to create and optimize Google ads that will drive potential customers to our website, where they can learn more about our services and hopefully convert into leads. Your expertise will be crucial in ensuring we're reaching the right audience with the right message. In your bid, please outline your previous experience with similar campaigns and how you plan to approach th...
