Exceldela

Obdelava podatkov, izdelkov različnih proizvajalcev iz različnih virov z Query-ji, lepljenje po ID-ju ipd ipd Trenutno imamo 1 projekt za nekaj ur dela. Po podobni logiki so v pripravi novi projekti..

Rad bi izdelal kviz ki bi obsegal razlicna podrocja, za zacetek na primer vprasanja iz racunalnistva, excel-a, podjetnistva,.. V kolikor pa bolje spoznate na kaksno drugo podrocje in se vam zdi da bi bila vprasanja uporabna tudi za ostale, se lahko zmenimo tudi za kaksno drugo podrocje vprsanj. Poleg vprasanja bi bili ponujeni 3-je mozni odgovori, med katerimi bi bil en pravilen. Za vsako podrocje bi imeli vprasanja razlicnih tezavnostnih stopenj, na primer Lahka, Srednje in Tezka. Bonus tocke za: -Vprasanja niso predolga, da ne zahtevajo ravno predolgega branja -Nekaj vprasanj lahko vsebujejo tudi kaksen smesen ali pa nenavaden ponujeno odgovor

need help with spreadsheet formula

I would like an app for phones to control inventory. The idea is each SKU will have an indepedent QR code. The employees would scan QR code then enter amount of movement in/out. The app will keep track of inventory both visually in the app but also able to send excel file to email. We would have 3 warehouses, 3 users, 20 fininished products and about 100 raw materials.

We are looking for someone to do product research. There’s a particular website that offers bidding on items we would need you to go through the products that are for sale and make an Excel spreadsheet of the items for us to purchase. You would not be doing any of the purchasing you would just let us know which items we would be able to make a profit on. This job will take 20 to 30 hours per week. Our budget is 2 to 3 dollars per hour

I'm trying to match two columns of names. Some name does not have a match due to an additional letter, names, hyphens, accent, etc. I'm trying to create a macro that can match these names using 70-90% similarity, rather than exact match. All names in the tab DART should have a match.

Please help me create dropbox link URL for each SKU

I need to take a pdf list of activities and transfer them into an editable excel; spreadsheet that i can use as a checklist

I have an excel file that pulls information from Yahoo finance with the click of a button. Something in their programming has changed and my sheet no longer pulls the information. I need it fixed.

I need some help in one thing that I am working on. This is a financial case that I need to calculate several things on Excel and pull out some data from Yahoo Finance. Please read the attached requirements CAREFULLY. The company that I am analyzing is General Electric. I need it done in 6hrs, which is more than enough if you have financial knowledge and skils

...Necesitamos desarrollar website SaaS de pago por suscripción. Perfilamento de usuarios en 6 diferentes perfiles y cálculos internos. Proyecto basado en libro de excel de 25 hojas con un full time de tiempo promedio de desarrollo de 2 meses. Requerimientos específicos serán discutidos posteriores al NDA. Se debe trazar un periodo de pruebas de seguridad y estabilidad. El trabajo de debe entregar full code y contrato de cesión de derechos de autor. --------------------------------- English We need to develop a subscription-based SaaS website. User profile in 6 different profiles and internal calculations. Project based on an excel book of 25 sheets with a complete average development time of 2 months. Specific requirements will be dis...

Thank you for reviewing the job post. The task at hand is quite simple and straight forward, I would like google sheets calculator shown in the pdf attached, replicated and functioning with interchangeable figures. This will require minor adjustments at the beginning. Please provide your price and timeframe to complete the initial project, and hourly rate moving forward.

Around 1.5 hours on a daily basis +2 hours end of each week + 4 hours at the end of the month. Please Mention the expected price and skills in data entry, analysis and excel.

Tenemos una herramienta en excel desarrollada en Power Pivot que se encarga de generar los reportes de ingresos y gastos mensuales e históricos de la empresa incluidos Dashboards y KPi's El objetivo desarrollar esta misma herramienta bajo Power Bi

Modify a VBA so the OneDrive path is working as well. See atached, folder "", when "" file open, it kicks a macro and pick up data from CSV. This work fine when run locally. However, we have migrated to OneDrive and the path of the active workbook (with https) is not working anymore

Hello, I just need someone to go through the code with me and explain line by line what the code means and how it works. I need to make modifications to the code so I need to understand the VBA perfectly. See attached excel file "Oil Compliance report data"

I'm needing to produce an excel spreadsheet that shows dates and count downs to those dates and then have that information feed to a master spreadsheet that will ascend by date due. So I know there will be a contract start date and finish date. But each contract has items that have a deliverable due by date and a submitted date. I'm kinda know formulas not to the extent of that. I only know basic stuff.

Grab the table contents from the excel file put it in the email body and create automated emails with the self time script in python

I work in Accounts Receivable and Cash application. We have a lot of small customers that send us in Excel files to a group mailbox with remittance information that lines up to an ACH/electronic payment we receive. Right now we manually need monitor a group mailbox then manually save a file to a SharePoint site, then if on a certain list we need to format that info with a macro to a certain format, then we need to go into SAP and use a t-code to "marry the payment we got from the bank with the properly formatted data that matches to it so that our system can offset the cash and items in the ar. I think powerAutomate can do all of that. If it can then we would want this to be easily expandable. Right now the scope is only for using spreadsheets submitted by the customer bu...

Tenemos desarrollada una herramienta en excel baio Power Pivot y necesitamos un experto en la misma que nos de soporte para resolver posibles incidencias y y desarrollar nuevas utilidades

We would like to hire good teacher/teachers to prepare Multiple Choice Questions ( MCQs) along with solutions for class 4 for CBSE Board. The MCQs will be in Mathematics. We need around 2000 questions (40 questions each on 54 subtopics) of varying difficulty levels (easy and hard). Some of the questions should be pictorial. MCQs must be genuine and not copied from different sources. Excel format in which this question bank needs to be created is provided. For the questions with pictures, the picture name should contain the question number it is associated to. All the pictures should be in one separate folder.

excel example file in normal work

Looking for an Excel specialist to match data between a couple of big datasets: - CSV file with 250k records - 11 txt files sized 300MB - 18GB What needs to be done: - Grab data from 3 columns in the CSV file - Match it with the data in any of the 11 txt files (4 data points) - Add the matching data back to the CSV file

Hola, Necesitamos normalizar un conjunto de direcciones postales. Tenemos unas serie de excels compuestos por +100.000 filas todo son direcciones postales. La tesis del trabajo consiste en generar u...Tenemos unas serie de excels compuestos por +100.000 filas todo son direcciones postales. La tesis del trabajo consiste en generar un script que de forma automática busque la dirección de la columna "A" de nuestro excel en: - Google Maps - Catastro () Extraer la direccion de estos dos sitios web y copiarlos en dos nueva columna B y C Los campos pueden estar repetidos pero se deben copiar igualmente en la columna. Objetivo claro: las direcciones siempre deben estar en la misma ciudad. Adjunto un ejemplo del excel base

1. Change an excel program 2. only use excel formulas 3. NO MACRO

...Requirements and Qualifications • Minimum 2+ years of previous experience in a sales • USA and Canada geography knowledge preferred • Must have high speed internet connection • Must have telephone headset or desktop phone (service is provided) • Excellent communication and presentation skills • Must be an energetic, flexible, highly organized individual with a self-starter personality • Ability to excel in a fast-paced and dynamic environment • Working efficiently and multitasking as required in a sometimes stressful environment • Proven experience in freight brokerage sales, with a desire to grow professionally • Ability to attract, bring on, close and deliver new business • Passion for sales, work ethic and a drive to succ...

Hi I have a machine that is in german, and I need it translating to English. I have it in an excel file. I have more to translate after this. see attached. Please state Guten Tag at the end of your message if you are interested as auto bids will not be accepted.

Excel spread sheet for a cabinet manufacturing shop. We will be using this spread sheet to track all components as they travel through the production process. We will enter all parts on a spread sheet for each individual job. There will be separate areas for each type of item that is part of the job. Some items will have more check off boxes than others as they will have more steps to check them through. We will need the pages to print with the appropriate title on each page.

Need copy pasting and data entry need a person with basic knowledge of accounting and excel

Issue: Having trouble getting my Profit and Loss statements exported to Excel Each item of expense needs to be on a "separate" line in Excel. See attached. I have tried printing to Adobe and exporting to Excel and the same issues arise.

Objective: Optimize the work of project/managers. Objective: Make handy excels with calculators to keep track of developer hours.

Assunto: Integração PHP - Excel (PHPExcel) Olá, Estamos com um problema para fazer a integração de dados através da biblioteca PHPExcel. Já temos alguns modelos aplicados de integração que funcionam normalmente, mas para esta planilha estamos tendo problemas. Achamos que falta algum detalhe dentro do script para ajustar o processo. Obrigado!

Crear un power point con la formación PDF de Office 365, didáctico y funcional. También un archivo Word bien estructurado. Haciendo énfasis en Teams, Sharepoint, Word, excel y PowerPoint online. El resto de herramientas/aplicaciones sólo lo básico. El material debe ser creado en español.

I am looking for a simple web app to be created which will allow a user to upload an excel, select and name the cells they would like to use (including series of columns and rows within a worksheet) and transform this into a dataset that can be exported as a CSV for ingesting into a database. There must also be functionality to save the cell selection as a template so that it can be re-used, and functionality to bulk import multiple files. Therefore user accounts/logins will also be required. The functionality is already fairly simple in Python, so I think the main work will be on the UI. I have attached a requirements document for more information and can provide examples for reviewing.

I want to export the checked column only... in EXCEL, PDF, etc

This project is to retrieve data from a client scheduling website and import it into Excel. The website provides us with a calendar interface where we can show one day of appointments with our various staff members. We would like to pull from this page the client name, staff member name, appointment time, appointment type, and resource, and export this data to Excel.

We will give you a file of data or access to our data system and you will need to verify certain entries and find further information on companies house. We need someone to send out letters through our mailing house. The letter is already written and ready to go you will just need to go through the process of sending it through one of the providers. Financial & excel knowledge is needed. We need someone who is a self starter with good english & communication skills.

Input Sales and Expense in Excel. Super basic, just don't have time to do it.

I need some public data ( lists of people/things of different categories ) collected that are available on internet. It's simple, all you need to find and put them in a excel/google sheet. IF YOU BID, ADD A MESSAGE WITH YOUR ASKING PRICE FOR EACH 1000 ENTRIES. Repost as I need more people to work

Tenemos desarrollada una herramienta en excel bajo Power Pivot y necesitamos un experto en la misma que nos de soporte para resolver posibles incidencias y y desarrollar nuevas utilidades

Please also tell me if this functionality can be performed is it possible or not? Also, bid freely if you really know how these can be performed you have to join a meeting and discuss with us at zoom. Following functionalities: Recognition of person with his writing Train this model on adding the data of new user. Image to Text Converter and converted data can be downloaded into wo...possible or not? Also, bid freely if you really know how these can be performed you have to join a meeting and discuss with us at zoom. Following functionalities: Recognition of person with his writing Train this model on adding the data of new user. Image to Text Converter and converted data can be downloaded into word or pdf format Image to table Converter and converted data can be downloaded into excel...

Tenemos una herramienta en excel desarrollada en Power Pivot que se encarga de generar los reportes de ingresos y gastos mensuales e históricos de la empresa incluidos Dashboards y KPi's El objetivo desarrollar esta misma herramienta bajo Power Bi

Some one can help me to develop the excel dashboard

1) Need to get more than 5 X MS 365 Excel work sheets with data analysis(dynamic), multiple comparison for presentation and provide ongoing data for analysis for the next 1 to 2 months. presentations will require Dynmamic reporting /graphs/analysis/ dynamic charts 2) People with excellent working knowledge of MS 365 Excel ,a able to apply advanced formulas / pivots etc etc only to respond and must provide examples 3)Assist me to create small documents ,proof read and minor data entry for next 2 to 3 months 4) Thank you

...create lists of contacts at leading companies that are relevant for our business. Within Animal Health and Nutrition we have identified lists of the top brands and companies. We will provide you with the raw information in the form of online sites and lists and your job will be to help us populate an excel workbook with company information and with contacts at each of the companies. This will be a combination of web scraping, research, excel and data entry. There will be 2 worksheets in the excel workbook 1 - List of companies with basic information and primary contacts - You will fill this out 2 - List of contacts at each of these companies with key information such as Name, Title, location, email, Linkedin... A template is attached for your review. We are a...

You have to develop Restorants app. People can find where are Restorants, they can get information , using firebase, and using google maps to find. App show only Restorants which signed up in our app. It means it will have 3 parts. 1 for people. Second for restaurants. And 3 is for me admin panel. People can chat book place in Restorant...develop Restorants app. People can find where are Restorants, they can get information , using firebase, and using google maps to find. App show only Restorants which signed up in our app. It means it will have 3 parts. 1 for people. Second for restaurants. And 3 is for me admin panel. People can chat book place in Restorants. Okay but I don't have api so, only Firebase or google sheets or Google Excel file you write gson files. This app for o...

...Developer will do all development work on our test server which we will provide, Once done and approved his work - he have to migrate all code to the live server. - Content will be provided - Have to post at least 30-50 products and different categories as sample and explain the know how - Products reports and inventory management via Excel - Products & Categories to be required to upload using Excel as well. - All reports should be available to export in Excel. - Social Media Integration - One page link is required to 3rd party Kundali Software - Only Hyper Link which will open the Kundali Interface - One form will be required to connect with 3rd party app Kundli software - It will ask basic details like Name , Age, Date Of Birth, Place and send this data to 3r...

Service Reporting of vehicles is being captured daily

Looking for Excel invoice generator -Invoice generator -All invoice should be store in database -Automatic invoice numbering -Separate GST and year to date quarterly GST, Income and Expense report -Bar chart and Trend line should represent trend -User friendly and easy to operate -One click to store, generate PDF and send to Email option -Invoice should have High graphics with LOGO and water mark - LOGO will be provided -Easy to enter Monthly expense and categorised expense -Total invoice generator should be auto add to total revenue -Invoice should have due date and auto reminder -Automatic one click invoice status change i.e. Due, overdue and paid -Record for 1 year and every year should easy to change date and year -Constant maintain brand format - Text type and colour code will...

...are doing migration of the data from MS Dynamics to Other CRM tool. In this, we have successfully migrated all the Contacts, Accounts, and Opportunities to Other CRM tool. But while migrating the activities we are facing some difficulties in exporting the activity data such as emails, notes and etc. We need someone to help us in exporting all the activities from MS Dynamics into a MYSQL databases/excel files. For this migration, we require all the activities exported with all the possible data fields. We need the details of contacts, accounts, and opportunities associated with an activity to identify the relationship between an activity and contact/account/opportunity. It would be really helpful if you could kindly provide the required data in the form of a spreadsheet or you cou...