Excel power query import multiple text files 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...
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 the process of developing a new power electronics product for industrial use. The current stage of development is in the prototype phase. For this project, I need a skilled professional who can help me with the following: - PCB Prototyping: I require assistance with the creation of the PCB for this new product. This includes the manufacturing of the board itself. - Creation of Test Plans: I need an expert who can help me create comprehensive test plans for this new product. This includes both hardware and software testing. Experience in creating test plans for electronics, would be highly beneficial. - Final Testing & Validation: Once the PCBs are produced and the test plans are in place, I would need a professional who can assist me in the final testing and val...
I'm in need of a professional who has extensive experience with SharePoint, Power Apps, Power Automate, and secondary Power BI . I need support for my consultant indian time 8:30 pm to 11:30 pm Monday to Friday. 12$/hourly.. payment every saturday vai peayplea. I already have other indian guys who are working with me since 2019 to present. This support will be on zoom meeting. Which we will provide u and u will connect with my consultant for support.
I need an experienced Linux admin who can help me set up a CentOS server to function as a web, database, and file server. The ideal candidate will be familiar with CentOS and have experience configuring a server with multiple services. Key Requirements: - Install and configure CentOS on a server - Set up Nginx as the web server - Configure the server to also function as a database and file server - Ensure the server is secure and optimized for performance - Provide documentation of the setup and configuration for future reference.
Please note that this is not for a particular role, this for representation. We work...not for a particular role, this for representation. We work with all Casting Directors in Australia on all productions. We are seeking talented individuals to play varying roles. We receive briefs for Film, TV, and Commercials. We left the project duration field blank, this means there are opportunities for both short-term and long-term collaboration. Most jobs are between 4-8 hours or can be multiple days on larger productions. As experience is needed for some productions, inexperience actors are also welcome as there are allot of roles you don't need experience for as long as you feel comfortable in front of the camera. Please contact me if you have any questions. Regards Brad Walks Ta...
I need a freelance PMP certified project management trainer for deliveri...delivering a 5 days' project management courses and vast in PMI-ACP (PMI Agile Certified Practitioner). Course duration : 5 days. Material to be covered : PMI-ACP (PMI Agile Certified Practitioner) Location: Orlando, United States Frequency : Multiple Classes Fees : 5 x US$ 700.- per training day = US$ 3500 Candidates should provide me with their resume including detail qualification, career path, experience in project management and experience in conducting project management training. Aside this urgent time sensitive class, there will be multiple trainings in several locations in USA, Canada, UK, Europe and Africa so applicants from various locations are encouraged to apply so they can be con...
I'm in need of a skilled video editor to create a cinematic 1.30 minute video capturing "a day in my city". I have a collection of 150 video c...the overall cinematic effect. - Inspirational message: The primary emotion I want this video to convey is 'Inspiration'. Therefore, the editing should reflect this tone and help to deliver the message effectively. Ideal Skills and Experience: - Proficiency in video editing software (e.g., Adobe Premiere Pro, Final Cut Pro) - Experience in creating cinematic-style videos - An understanding of the power of music in video editing, and the ability to select and integrate music effectively - Strong portfolio of previous work, particularly in creating inspirational video content - Familiarity with creating dynamic transi...
...an innovative and unique logo that clearly represents our company's vision and services. 2. Icon Only: The logo should be an icon only, without any text or letters from the company name, as it will be used with both the English and Arabic names of the company. 3. Versatility: The logo should be versatile and suitable for use across various media and platforms. 4. Originality: The logo must be original and not copied or similar to logos of other companies in the same field. 5. Presentation: Designers must provide a mockup showing how the logo icon will appear next to the company name. Deliverables: • The final logo should be delivered in multiple formats to ensure flexibility in use. Required formats include: • AI (Adobe Illustrator file) • PDF • P...
We are looking for freelancer for technological catalogues redesign and build in adobe indesign. Freelancer should be expert in adobe indesign, photoshop, ilustrator. We provide example project templates in adobe indesign, source data in pdf and excel. Based on source data our catalogue should be created and redesigned as template project. Project should be done in adobe indesign for printing and web
I am an exporter in need of a proactive sourcing agent to help me establish connections with potential buyers in the United States, European Union, and UAE. My focus lies in the exportation of: - Basmati rice (11...procurement of potential buyers - Market research regarding the demand for these products - Effective communication with buyers regarding product specifications and negotiation of pricing The ideal candidate should have: - Prior experience in sourcing and exporting goods, ideally within the specified regions. - Excellent communication and negotiation skills - An extensive network of contacts in the import industry - Knowledge about Basmati rice (1121) and guar gum powder will be a clear advantage If you have the necessary skills and experience, I would love to connect...
I have a PDF file with over 50 pages of data in mixed formats - text, numbers, and tables. The task is to accurately transfer this data into an Excel spreadsheet in a tabular format. Key requirements: - Data entry from a PDF file into an Excel spreadsheet - The data is of moderate complexity, so a good understanding of Excel is needed - The output should be a well-organized and clean Excel spreadsheet Ideal skills for this job: - Proficiency in data entry and working with large data sets - Advanced Excel skills, including the ability to work with mixed data formats - Attention to detail and accuracy to ensure the data is correctly captured - Experience with PDF to Excel data conversions would be a plus Please note that while the task is ...
I am in need of a skilled professional who can assis...system to enable the creation of goods and service invoices in USD. - Implement moderate customization to the invoice templates, focusing on layout changes and adding custom fields. - Import all of my product information from an Excel sheet. This includes product names and their respective cost prices (which are in INR). - Enable and Teach me to Use Odd's OCR feature to fetch pdf data from invoice to transfer it to software Ideal Candidate: - Proficient in working with Odoo Books and setting up invoicing processes. - Experience with customizing invoice templates within Odoo. - Skilled in data import from Excel sheets to Odoo. I look forward to working with a professional who can deliver these requi...
--- ### Job Title: Excel Sheet Creation for Job Tracking and Payment Calculation **Description:** I need a custom Excel sheet to help me track jobs completed by my installers, including details about each job, such as dates, customer information, and payments. The sheet should be able to automatically calculate the total number of jobs done and the total payment owed to each installer. **Requirements:** 1. **Job Tracking:** - Columns for the date each job was completed. - Columns for the job details including customer address and account number. - Columns for the installer assigned to the job. 2. **Payment Calculation:** - Ability to input the payment rate per job. - Automatic calculation of the total number of jobs completed by each installer. - Automat...
I need specialized assistance on visualizing my completed data analysis, encompassing sales data, financial data and customer data. To make this happen, I'm seeking a seasoned Power BI dashboard designer. Expertise required: - Proficient in creating Bar charts, Pie charts, and Line charts in Power BI - Has experience working with diverse datasets especially sales, financial and customer data - Can deliver the project urgently If you can create a comprehensive and visually appealing dashboard to delineate and amplify my data's context, your experience and skills will be indispensable to this project. Let's connect ASAP and bring this to life.
Just a quick bit of help needed in excel macro writing. See attached before and after showing a piece of the original data. and what i neeed the macro to achieve. WHAT IM ASKING If two adjacent cells in column b are equal, then add cells adjacent column c cells, put the result in the first column c cell and remove the duplicate row. AEE ATTACHED png. I need a tailored solution for a data manipulation task within Excel. Specifically, I am looking for an Excel macro that can accurately merge cells based on their adjacency. Essential skills and experience should include: - Expert knowledge of Excel and its macro functionality - Prior experience with data manipulation tasks such as merging cells - Understanding the rules or criteria for merging specificall...
I am looking for an expert who can as...expert who can assess and modify an existing Excel macro for compatibility with Excel for Mac 2019 or later. The current macro mainly handles formatting tasks within the Excel file. Key Requirements: - Assess the current macro's compatibility with macOS - Modify the macro to ensure compatibility with Excel for Mac 2019 or later I don't have a strict deadline for this project, so you can work on it at your own pace. However, I am looking for someone who can get this done efficiently and effectively. Feel free to ask any questions for more information. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Knowledge ...
I'm in need of an individual who can transcribe intermediate level sheet music to MusicXML format. The work will involve a small ensemble, consisting of 2-5 instruments. Key Requirements: - Experience with transcribing intermediate level sheet music -... consisting of 2-5 instruments. Key Requirements: - Experience with transcribing intermediate level sheet music - Proficiency in MusicXML format - Familiarity with transcribing small ensembles - Strong music theory knowledge The ideal candidate will have a keen ear for music and the ability to accurately transcribe notes and dynamics from sheet music. You should be comfortable working with multiple instruments in an ensemble setting. Experience in music transcription and a solid understanding of music theory is essential fo...
I'm in need of a talented developer or team who can create a comprehensive platform across website, Android and iOS. Here's what I'm looking for: - **Primary Purpose**: The main foc...Preferences**: The aesthetic for this platform should be colorful and vibrant. It's important that the design is eye-catching and engaging, as this will be a key factor in user experience. Please provide examples of your previous colourful and vibrant work. The ideal freelancer for this project should have experience in developing e-commerce platforms, service booking systems, and integrating multiple payment gateways. Creativity and a keen eye for design are also crucial in this project. If you think you have the skills and experience to bring this multi-functional platform to li...
I am in need of a skilled AppSheet developer to create a custom app for my small warehouse inventory business. Key Features: - Inventory Tra...in need of a skilled AppSheet developer to create a custom app for my small warehouse inventory business. Key Features: - Inventory Tracking: I require a system that will consistently track and update inventory in real-time to ensure accuracy. Other Details: - Products: As a small warehouse, I have less than 50 different types of products. - User Access: The app will not need to support multiple users accessing and updating the inventory simultaneously. Ideal Skills: - Proficient in AppSheet development - Experience in building inventory tracking systems Please respond with your relevant experience and sample work for further cons...
I'm in need of a skilled professional to help me create a data mining script. The task involves mining emails, data from a certain website and delivering the data in a raw text file format. Key Requirements: - Develop a data miner script that can effectively scrape email data from websites. - Ensure the script can handle multiple sources and is scalable for future needs. - Deliver the mined data in a raw text file format. Ideal Skills: - Proficiency in web scraping and data mining techniques. - Experience with developing scripts for text data mining. - Strong knowledge of scripting languages suitable for scraping like Python/BeautifulSoup, R, etc. Please provide samples of your previous similar projects or portfolio that demonstrate your ability in thi...
I am seeking an experienced LT Spice expert to assist with the design and simulation of a half-bridge circuit to drive an ultrasonic cleaner load, 60W, 39kHz, and 10R impedance. I have an LT spice model that needs to be updated to meet the requirement. The floating side needs to show a sq...pulse to the gate driver is UCC28086D, and the isolated gate driver UCC21550BQDWRQ1. It would be good to use parameters from these components where applicable for a representative test. For example, changing the MOSFET to the one with low Rds On - Drain-Source Resistance will give square output at the section labeled square wave. I have also attached the type of transformer Skills: - LT Spice - Power electronics - Simulation - Troubleshooting Delivery time is within 20th May evening (IST) Kin...
...potential customers. We want it to be visually inspiring, easy to understand, and aligned with modern architecture aesthetics. Responsibilities: -Refine the existing Keynote presentation. -Add depth and detail to the organization of information. -Enhance branding and style. -Ensure clear communication throughout the slides. Requirements: -Experience in Graphic Design -Experience in designing multiple-page documents -Experience with Keynote, Canva or Illustrator Bonus Skills: -Photoshop -Pitch Deck Design -Architectural Design -Product Design -Rendering Budget: We’re budgeting approximately $120-$200 for the entire project. Application Process: Express your interest in the job by replying to this posting. Send a quick message to introduce yourself. If interested, p...
I am in need of a skilled professional with solid experience in Electronic Payment Gateway Systems. The main purpose will be securing online transactions with efforts mainly aimed at: - Implementing and managing payment processing tools. - Facilitating secure transa...background in: - E-commerce platforms and tools. - Cybersecurity - Managing credit/debit card transactions and bank transfers through payment gateway systems. - Setting up streamlined and hassle-free payment processes. Unfortunately, the type of transactions my system will primarily support hasn't been decided yet, so flexibility and advice in this regard will be appreciated. Experience with multiple types of transactions, including eCommerce, subscription payments, or peer-to-peer transfers will be a strong...
I am seeking a unique and elegant logo for my business, Aiken IV Hydration Therapy. Located in a Southern town with a large equestrian community, the logo should reflect the upscale nature of our services and appeal to our target demographic. Key Requirements: - Incorporate element...scheme should be primarily black and gold. - The overall style of the logo should be elegant and sophisticated, in line with our brand image. Ideal Skills: - Logo design experience, particularly in the health and wellness sector. - Strong understanding of color theory and the ability to create visually appealing designs in black and gold. - Creative thinker with the ability to seamlessly integrate multiple elements into a cohesive design. - Portfolio showcasing previous work in elegant and sophisticat...
Hello! We are an Audio Visual company looking for a skilled Power Apps & SharePoint professional to create an app to help manage AV technician tasks (jobs). The main focus here is a user-friendly and highly functional app and site that can streamline our internal processes and improve data management. This work entails: 1. Creation of a PowerApp to facilitate on-site job documentation workflow. That includes: job list, documentation, photo, text, equipment, barcode, time tracking, costs, notes, client's sign-off, task history, attachments, etc. 2. SharePoint data repository 3. SharePoint site to create projects, assign and manage tasks, monitor progress, manage permissions (many clients, many projects, many locations, many technitians scenario) 4. Automation for m...
I am seeking a unique and elegant logo for my business, Aiken IV Hydration Therapy. Located in a Southern town with a large equestrian community, the logo should reflect the upscale nature of our services and appeal to our target demographic. Key Requirements: - Incorporate element...scheme should be primarily black and gold. - The overall style of the logo should be elegant and sophisticated, in line with our brand image. Ideal Skills: - Logo design experience, particularly in the health and wellness sector. - Strong understanding of color theory and the ability to create visually appealing designs in black and gold. - Creative thinker with the ability to seamlessly integrate multiple elements into a cohesive design. - Portfolio showcasing previous work in elegant and sophisticat...
I need assistance to accomplish two specific tasks for my impending project that involves a deep-dive into financial econometrics using R: 1. Regression Analysis: Applying my real-world data, there's a need to execute an efficient regression analysis. The aim isn't to predict future values but to identify significant variables inherent in th...regression analysis, your expertise will be needed for a thorough model evaluation, ensuring the accuracy of the identified variables and assessing the overall performance of the model. Ideal applicants should possess robust experience in R, financial econometrics, regression analysis, and model evaluation. Familiarity with real-world finance data would be an added advantage. The goal is to unlock the power of data in understanding...
Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.
...Users should be able to translate live any page on their phone. - AI Assistant: The AI assistant should have the ability to provide information on various topics and should excel in language understanding, helping users with translation in real-time conversations with others. - Live Translation: The app should provide a smooth live translation experience for conversations. Ideal Skills: - Proficiency in React Native for cross-platform development. - Experience in building apps with live translation capabilities. - Strong background in AI development, specifically in language understanding. - Familiarity with integrating text-to-speech features for the AI assistant would be a plus. I'm looking for a professional who can deliver a high-quality, user-friendly app tha...
I have encountered a sudden loss of bookmarks in my Google Chrome browser, two days ago. Being a macOS user and having multiple accounts on my browser, I have not tried any troubleshooting steps so far. Fortunately, I maintain a full system backup, which could be utilized for restoration. Key Points: - The disappearance of the bookmarks was sudden and unexplained, so this may require more advanced recovery methods. - Expertise in macOS is crucial, as the recovery should be compatible with this operating system. - The presence of multiple accounts on Chrome might complicate the recovery process, so understanding how to navigate this is essential. - Your deep understanding of Google Chrome's architecture is required to successfully retrieve the lost bookmarks from my full...
I have a YOLO v5 detection Python script, and I'm looking to turn it into an API-based web program with FastAPI. The API must support user inputs for 4 Twilio contact numbers and 4 RTSP addresses, and it should display the four video streams in a grid on a single page. Key requirements: - Convert the existing YOLO v5 detection Python script into a FastAPI...web program. - Implement user input functionality for 4 Twilio contact numbers and 4 RTSP addresses. - Display the video streams in a grid layout on a single webpage. Ideal skills and experience: - Proficiency in Python and experience with YOLO v5 detection. - Strong knowledge of FastAPI for building web APIs. - Previous experience integrating Twilio for messaging. - Familiarity with displaying multiple video streams on a ...
I have a database containing over 600 serial numbers. Email serial number has an associated email address. Instead of listing the same email address multiple times, I would like a script to place all serial numbers by one email address. This will enable me to email the customer once with ALL of their serial numbers in one email. Example: Hannah Walker appears in the database 5 times, the script should remove the four duplicates of Hannah Walker and put all 5 serial numbers by her name.
I am in need of a freelancer who can accurately convert my PDF files into Excel. The materials consist mainly of printed, electronically generated text. Given the nature of the work, the ideal candidate should: - Be proficient in both PDF and Excel formats - Have an eye for detail to ensure accuracy - Have experience dealing with extensive text documents - Possess strong typing and data entry skills Please bid if you fully understand the tasks and feel capable to deliver high-quality results. Your attention to detail and commitment to accurately completing tasks would make you an ideal candidate for this project.
I'm seeking an experienced and skilled engineer, data scientist to assist in optimizing the cooling power of a new metamaterial. The project involves algorithm development to achieve our cooling optimization goals. I will forward you a report where they've used Genetic Algorithm method to optimize parameters. She has used four flux theory to predict optical properties for different particle parameters. you should not optimize the reflectance... in your work, you should optimize the cooling power Requirements: Proficiency in MATLAB Strong background in optics, material science, or related fields. Experience with genetic algorithms and parameter optimization techniques. Excellent communication skills and ability to work independently. Nice to have:...
I need a skilled data entry professional to help me with a project. I have a large volume of text-based data that I need input from physical documents. The task involves organizing this data in a document. Key Responsibilities: - Transcribing text-based data from physical documents accurately - Ensuring the data is organized as required in the document Ideal Skills and Experience: - Proven experience in data entry - Strong attention to detail - Proficiency in handling text-based data - Familiarity with transcribing from physical documents - Ability to maintain confidentiality of sensitive information The successful candidate will be reliable, efficient, and able to deliver accurate work within the agreed timeframe.
...well-versed in Lua and experienced with IceSL. The task involves: - Developing a custom Lua script that can generate a 3D model. - The 3D model in question is a gear coupling. - The gear coupling is designed to be used for power transmission in a larger system. Skills and Experience Required: Mechanical Engineer - Proficient in Lua scripting language. - Experience with IceSL for 3D modeling. - Understanding of mechanical components - specifically gear coupling design and its function in power transmission. - Ability to generate an accurate and efficacious model for power transmission requirements. This task requires an understanding of code as well as a foundational knowledge of mechanical engineering principles. If you possess these skills and experience, I...
...Subcategories for different model types (e.g. cars, interior, nature, food, furniture, electronics, appliances, weapons, clothing, jewelry) Each texture and model thumbnail should display a preview image and name Texture and Model Functionality Textures should be draggable and droppable onto objects in the 3D viewport to apply the texture Models should be draggable and droppable into the 3D viewport to import the model directly into the scene For each texture and model, there should be an option to select the resolution (8K, 4K, 2K, 1K) Other Requirements The addon should be well-organized, easy to navigate, and load quickly without slowing down Blender The textures and models should be high-quality and professionally created The addon should be regularly updated with new content...
...The primary task is to ensure that new columns added to the database are correctly displayed in the Excel report generated by the application also fix some minor areas that will discuss in detail Key Responsibilities: - Troubleshoot and fix the issue of new columns not being displayed in the Excel report - Ensure that all relevant data is correctly fetched from the SQL Server 2019 database - Implement a seamless solution that does not affect the overall functionality of the application Ideal Skills and Experience: - Strong proficiency in C# programming language - Expert knowledge of SQL Server 2019, including stored procedures and functions - Prior experience with similar tasks involving Excel report generation from SQL data - Excellent problem-solving skills and ...
...improve the user experience and provide a coherent flow throughout the website. Your role will be to ensure a smooth and efficient configuration of the Pods plugin, allowing for seamless integration of parent and child posts. This setup will enhance the utility of my website and provide a consistent user experience. Example of what I need to do: I have a parent post called 'baptismo' from where multiple 'parente' child post are created. this posts are linked through relationship fields in both Pods. Parent Pod 'baptismo' Field name: 'pessoas_relacionadas_com_o_baptizado' Field type: Relationship Related Type : Baptismos (baptismo) Bi-directional Field : 'pessoas_com_quem_se_relaciona' [Pod: parente] Child Pod 'parente...
