Excel conditional array formulasJobs
...produktfeed-import til Excel via Make Projektbeskrivelse: Vi er på udkig efter en dygtig freelancer med erfaring i automatisering og databehandling, som kan hjælpe os med at automatisere importen af forskellige produktfeeds fra flere leverandører direkte ind i et Excel-ark ved brug af automatiseringstjenesten Make (tidligere Integromat). Opgaver: Opsætning i Make: Opsætte automatiserede workflows i Make, der importerer produkter baseret på specifikke EAN numre fra en liste, vi har tilgængelig i en særskilt fane i Excel-arket. Dataselektion: Sikre, at kun produkter, der matcher EAN-numrene på vores liste, bliver importeret. Dataimport: Automatisk import af følgende produktdetaljer til Excel: ...
I have a script in a Google Sheet where I'm getting an exception ..."")); (projectId) var projectFile = null; try{ projectFile = (projectId); }catch(e){} //var projectFile = (projectId) if(projectFile != null){ (projectFile) //(projectFile) var formulas = (j,1,1,9).getFormulasR1C1(); (archiveCurrRow,1,1,9).setFormulasR1C1(formulas); (archiveCurrRow,10).setValue(rowValue[9]) (j,11).clearContent() (j,10).clearContent() archiveCurrRow = archiveCurrRow +1; } } j += 1; } (5) }
Hej, Jeg har behov for en Expert, som kan udvikle en kalender for mig. Jeg har et rengøringsselskab, hvor vi få udleveret et kalender fra vores kunder. Alle kunder har forskellige fridag, men de fleste har helligedage som lukkede også er der enkelte der har ekstra feriedage, så de skal også indtastes. Herudover vil jeg indtaste, hvor menge timer medarbejderne har enkelte dage, så jeg kan beregne hvor timer der skal udbetales. Eksempelsvis har en kunde 20 arbejdsdage, hvor medarbejderen arbejder dagligt 10 timer, så i alt skal der udbetales 200timers løn.
I have an invoice template, i need to add a second page to it that have instead of the columns Beskrivning Antal Enhet à pris Moms Moms kr Belopp should have 10 columns. I have attached the invoice template. So i need a second description page to this template.
Design or formulate the financial analysis for a self storage project in order to ascertain its viability.
Jeg har brug for en ny hjemmeside Bare bygge den Internetbutik Skal sælge gavekort på min webshop på shopify og have betalingsmodul fra pensopay på samt 4 API opkoplinger diverse social media integration samt adwords og trustpilot, Excel fil fra bestilling skal sendes til produktionssted
Jeg skal ha lavet et database program hvor jeg kan indføre forskellige data hver dag. Skal helst kunne køre som app på både android og ios, ios i første omgang Jeg skal selv kunne skrive og lave nye data der skal indføres. Der skal være et pænt layout og væ...køre som app på både android og ios, ios i første omgang Jeg skal selv kunne skrive og lave nye data der skal indføres. Der skal være et pænt layout og være meget nemt at gå til Der skal være en backend, hvor man selv kan tilføje og rette i de ting der skal indtastes. Der skal ikke være begrænsninger for hvor mange indtastninger man kan lave Alt skal kunne konverteres og udskrives i pdf ...
Skal have lavet en opgave i Regnskab. Skal laves på excel.
På side 1. (ark – ’kontobevægelser’) er der i kolonne D indsat beløb (kr.), - pkt. C Værdien i pkt. C (side 1) ønskes overført til pkt. C (side 2) - arket ’2017’. Der skal indsættes en formel i pkt. C, arket ’2017’ (side 2) som overfører værdien fra pkt. C (side 1) til pkt. C (side 2). Dette gøres ved: • Det aktuelle ark som værdien i pkt. C (side 1) skal overføres til findes ud fra datoen i pkt. B (side 1). Værdier fra kalenderår 2017 overføres til arket ’2017’. Værdier fra øvrige kalenderår eksporteres til de respektive ark/kalenderår. Dvs. værdier for kalenderåret 2016 indsættes i ark &r...
Vi har brug for hjælp til at opbygge i MS Excel rapport, som via Jetreport henter debitor / salgs data fra Microsoft Dynamics NAV 2009 R2 - SQL database.
Hej, Jeg leder efter nogen til at løse et par matematikopgaver. Opgaverne er vedhæftet og mit budget fremgår af dette projekt. Opgaverne skal løses i et regneark (gerne Microsoft Excel). Deadline er 5 dage efter projektet er uddelt. Se nedenstående vedhæftninger.
Hej, jeg søger en som kan lave et design til et træningsprogram. Jeg har et design som I kan gå udfra, når I kontakter mig på mail. Håber i kan hjælpe. Mvh. Martin Nielsen
Vi ønsker at få en pris på at få oversat den engelske LOD manual inkl. excel workbook til dansk.
Vi ønsker at få en pris på at få oversat den engelske LOD manual inkl. excel workbook til dansk.
project for dangersystem dangersystem dangersystem
Jeg har vedblivende arbejde relateret til vores tidligere projekt 'Application that can upload excel sheet to sql table'
Solve excel problem using excel solver
Jeg skal lave en prissammenligningsside. Jeg har samlet alle priser hos en forhandler og skal nu have fundet de samme produkter hos andre forhandlere. Jeg har lavet et excel ark hvor jeg liste alle URLs til den primære forhandler. Det er så jeres opgave at gå ind og finde det tilsvarende produkt hos de andre forhandlere og indsætte links i Excel arket. For at produkterne er de samme skal I tjekke at billedet er ens. Hvis I ikke kan finde det pågældende produkt skal der bare skrives 0 i cellen. Se vedhæftede fil for hvordan templaten ser ud. Det drejer sig cirka om 1000 produkter og 10 forhandlere, der skal tjekkes
Jeg har vedvarende arbejde relateret til vores tidligere projekt ' Looking for a user-interface for Excel'
Take excel spreadsheet & upload via talend to REST service. Might have to work via multiple sheets. Rory to pass on details.
...product description, Product Category, Product Condition, location and product price range, Product Availability, Product Label / Keywords can be separated by commas, SKU Only We Can See. After inputting, you can automatically select a location, especially for the Indonesian region. - Can upload autoposts to Facebook Marketplace using multiple browsers at once - Can Autopost Facebook Marketplace with Excel Import Format - Autopost Facebook Marketplace Duplicate Product Preventer - Autopost Facebook Marketplace Settings to Prevent Banned Accounts - Auto Post Facebook Marketplace Bulk Edit Facebook Marketplace that has been input - The input Facebook Marketplace Autopost Report & Status can be exported - You can search for Facebook groups based on keywords with the selected sta...
...This comprehensive investigation can be based on specific equations, data, and parameters that will be provided from a relevant paper. Duties and Responsibilities: - Understand the Base Model: Analyze the experimental study to grasp foundational models and calculations. - Industrial Sensitivity Analysis: Utilize any effective method to scale up these findings to industrial levels. - Use MATLAB, Excel, or any other tool to conduct a detailed sensitivity analysis based on the equations given - Document each step of the analysis clearly, ensuring that any reader can follow the process and results seamlessly. Ideal Skills and Experience: - Proven experience in sensitivity analysis. - Strong understanding of Pressure Swing Adsorption processes. - Ability to interpret and implement ...
Excel Automation of my project and data visualization
I'm in need of an Excel expert who can assist me with data analysis, formulas, and data visualization. The project involves working with a dataset of medium size, specifically, between 1,000 - 10,000 rows. Key requirements for this role include: - Strong understanding of data analysis: The ideal candidate should have a proven track record of analyzing data, preferably in a business context. - Proficient in formulas and calculations: You should be very comfortable with advanced Excel formulas and calculations. - Data visualization skills: The ability to present data in an easily understandable and visually appealing way is crucial for this project. Specific functionalities and tools that need to be utilized include: - Pivot Tables: You will be requ...
I need assistance with a one-time data entry task into Microsoft Excel. The volume is less than 100 entries. Ideal Skills: - Proficient in Microsoft Excel - Attention to detail - Strong data entry skills Please note that the data needs to be accurately entered and organized in the Excel sheet. The project shouldn't take more than a few hours for someone with good data entry experience.
...The successful candidate will be responsible for developing a complete solution that includes trend analysis, automated prompt generation, integration with image generation APIs (such as DALL-E, Stable diffusion and MidJourney), backend infrastructure setup, and frontend design. Responsibilities: Trend Analysis: Implement a system to analyze and extract trends from Google searches stored in an Excel file. Prompt Generation: Develop an automated system to convert trend data into creative prompts suitable for image generation APIs. API Integration: Connect with external APIs like DALL-E or MidJourney to generate images based on the automated prompts. Backend Development: Build and maintain a backend system to handle API calls, manage image and data storage, and ensure efficient da...
I'm looking for a data expert to merge two sets of data from Excel spreadsheets. The combination should be based on a unique ID field that is generated using fields common in both datasets. Here are the key details: - Data Type: Both data sets are in Excel format. - Merging Output: The final result should be a new Excel spreadsheet. - Matching Fields: There are common fields present in the two datasets that should be used to generate a unique ID for matching. -Filter: There are records that will not be used, but they are easily identified by a unique, consistent value The ideal freelancer for this project should: - Be proficient in Excel and capable of handling small datasets. - Have experience in data merging, particularly based on generated unique iden...
...should be many-to-many, so we probably need a middle table that contains their combinations CarTypeId - ProductSKU The above is just a suggestion and additional columns or different implementations can be used. The plugin should implement the following: DATA Import: A way to import data from Excel file (example file attached). The import file might contain data for many SKUs and should overwrite the data of every specific SKU. As a result all the matching of Cars to SKUs is actually done in the Excel file. Products Filtering: Ability to filter the products that are matched to cars according to the cars (sample image attached). To make things easier, the filtering of the products could be enabled only for specific categories of products and be presented only on pages of t...
I'm searching for a professional well versed in Excel to help with lookup functions. I'm struggling with finding matching values and retrieving data from different worksheets in a text-based file. Key parts of this project: - Locating matching values across two worksheets - Retrieving needed text data from another worksheet The ideal candidate will have: - Strong proficiency in Excel lookup functions - Experience dealing with data across multiple worksheets - Understanding of text-based data within Excel
Tasks : 1. Construct a queueing model that replicates a week of collecting and processing DNA samples. a. First develop a flow diagram of how the process works, from the reporting of a crime, to the eventual match/no match on the DNA database. b. Identify any conditional aspects of the process, for example if there are any stages of the process where resources only become available once the previous sample has been processed. c. Second, write out the relevant equations associated with each step of the process, and construct a formula for the overall time in system. d. Use relevant notation and write out equations using Equation Editor in Word. e. Note – the rule of thumb is that any reader can pick up your report and replicate your results by following the methods. 2. Use me...
I'm looking for a detail-oriented Excel expert to amend certain elements on my existing spreadsheet. Key tasks include: Data Entry Corrections: - Correcting inaccuracies in data entries. - Rectifying data location errors. Data Reorientation: - Shifting the format from a vertical to a horizontal layout specifically for data values. It would be ideal if you possess a keen eye for detail, advanced Excel skills including formulas, and a proven track record of spreadsheet data management. Experience in handling large copy-paste tasks will also be of great advantage. Due to the nature of this task, a meticulous and systematic approach will be required.
As part of my project, I need an expert in Excel to type data from various digital files into a spreadsheet, ensuring accuracy and efficiency. This data will be utilized for basic data analysis purposes, so it's important that the freelancer is comfortable with working on this type of data. Key Requirements: - Converting data from various digital files (PDF, Word, etc.) into an Excel sheet. - Proficient in using basic Excel formulas and functions to manipulate data for analysis. - Attention to detail and accuracy are critical for this task. Ideal Skills and Experience: - Proficiency in Excel - should be able to work with basic formulas and functions. - Prior experience in data entry or data analysis is a plus. - Strong attention to detail to...
I'm looking for a skilled developer to create a custom procurement spend analysis dashboard. This tool will help our procurement managers to efficiently track and manage our expenses. Key Data Sources: - Your primary task will be integrating data from Excel spreadsheets and purchasing data from our suppliers. This will provide a comprehensive view of our spending patterns. Key Metrics: - The dashboard should enable real-time tracking of our total spend by category. This will allow our procurement managers to identify areas where costs are higher than expected, enabling them to take immediate action. Primary Users: - The dashboard will be primarily used by our procurement managers. It should be user-friendly and intuitive, allowing for quick and easy analysis of the data. Id...
Productcatalog for technical parts and for automobile car/truck parts (lighting) Do you have experience in technical parts product catalogs? Than let us know and send us via message a reference catalog from you and the price for the layout, optional add the price for automatic eding via a productlist from excel with photos to create the catalog. Send us a message with a reference catalog, maybe german language catalog or for europe with technical parts products.
Here's what I need in a potential candidate for the job: - Experience in data entry involving Text, Numbers, and Images. Adeptness in managing a wide array of data types is crucial for this project. - Proficiency in Excel. This project requires all data to be entered into a specific Excel template that I will provide. - Detail-oriented skills and accuracy are essential. The data entered should be free of errors and align with the format that I will provide. Please ensure your bid reflects your experience and capabilities in these areas. Looking forward to a fruitful collaboration!
I have an Excel sheet full of text data that I need typed up. The data is currently in a PDF file, so you'll have to extract it from there. Once the data is in the Excel sheet, it needs to be organized into tables. Key Requirements: - Data entry of text from a PDF into Excel - Organizing text data into tables in Excel Ideal Skills: - Proficiency in Excel - Fast and accurate typing - Attention to detail - Experience with data formatting in Excel Looking for someone who can complete this task in a timely and error-free manner.
Do you want to convert any PDF, JPG, PNG, or image files Are you looking for any kind of document conversion or need editing in your documents, You are on the right gig. MY SERVICES: ✅ Data Entry ✅ Web research ✅ Data Conversion ✅ Copy Paste Work ✅ Excel Data Entry ✅ JPEG to Excel or Word ✅ PDF to Excel or Word ✅ Real Estate Data Entry ✅ Language Translator ✅ Microsoft Excel ✅ Microsoft Word ✅ Lead Generation If you still have any questions or want to discuss prices for a custom project, don't hesitate to contact me. WHY ORDER FROM ME?? Fast Delivery, Never Late ✔ Message me if you're unsure or have project-specific questions Thank you
I'm seeking an Excel expert to help me with data analysis, formulas, and pivot tables. I work with Excel 2019. Key Responsibilities: - I want to see the mode of payment according to date wise in report sheet according to datewise Ideal skills and experience: - Proficient in Excel 2019. - Expertise in data analysis, formulas, and pivot tables. - Experience in creating automated reports or dashboards (desirable but not mandatory). - Excellent communication and problem-solving skills.
