Call sql stored procedure excel vba 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.
hii! sir aisa bhi gussa muje block he krdeya call bhi pick nhi krte
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.
Meillä on kaksi yritystä järjestelmässä, joilla on omat varastokirjanpidot ja osto-&myyntitilauksensa. Lokaalina serverinä toimii Windows 7 ympäristössä, visma Nova pro 9 (Windows sql server). Mikäli työn suoritus vaatii jonkin tietyn ympäristön niin kysele. Haluaisimme ajoitettuina tehtävinä ajaa allamainitut skriptit jotka muodostavat CSV tiedostot jotka on tarkoitus lähettää sähköpostina eteenpäin. Skriptin asetusten muokkaus skriptin alussa. Muuttujat ja funktiot kommentoituna. Lisätyönä voi tarjota näiden tiedostojen automaattista lähettämistä (Tiedosto liitteenä + leipätekstissä luettavasti muotoltuna). --------------...
Webservicen luominen sql tietokannalle. Perus toiminnot webservicelle ja kehitys ympäristön pystytys. Tarkempi speksi on saatavilla NDA:n kirjoituksen jälkeen. Kehitys mielellään Eclipse ympäristössä.
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.
Excel Add-In joka hakee ja tallentaa taulukkomuodossa olevaa dataa Azure SQL-kannasta/-taan. Lisäksi ohjelmallista Excel muokkausta ja hallintaa C#-koodilla. Osaan Excel muokkauksista valmis VBA-script, joka muutettava C#-kielelle. Visual Studio 2015 alkukoodi, SQL Azure tietokanta ja kyselyt valmiina.
Java, J2EE, JDBC, SQL, java Threading,GWT,Html,CSS
2200 kuvausta, excel. referenssitiedosto sekä kuvia ja englanninkielinen käännös käytössä. paljon toistoa. laadukas käännös.
Moro, Mulla olisi sulle työtarjous! Jos voisit tehdä mulle simppelin tietokannan ~5 taululla, ja kerrot vähän perusjuttuja sql serverin toiminnoista jne, niin ota yhteyttä ja jutellaan tarkemmin. Arvioisin, että tässä ei montaa tuntia menisi. Riippuen toki kuinka hyvin nuo sql perusjutut osaat ;)
Moi! Osaatko kuinka hyvin sql:n perusasiat? Onnistuuko asentaa tietokannan hallintajärjestelmä, luoda ja hallinnoida tietokantoja sekä käyttäjätilejä ,seurata ja optimoida tietokannan toimintaa. Jos perusasiat hoidossa niin ota yhteyttä :)
Moro, Mulla olisi sulle työtarjous! Jos voisit tehdä mulle simppelin tietokannan ~5 taululla, ja kerrot vähän perusjuttuja sql serverin toiminnoista jne, niin ota yhteyttä ja jutellaan tarkemmin. Arvioisin, että tässä ei montaa tuntia menisi. Riippuen toki kuinka hyvin nuo sql perusjutut osaat ;)
I'm in need of a skilled designer to create a professional A4/3 size real estate flyer. This flyer will be divided into 3 equal parts for easy printing, where each part carries the same design. The focus of the flyer will be on promoting MY REAL ESTATE SERVICES , ASKING PEOPLE TO SCAN THE QR CODE OR GOTO WEBSITE AND CALL ME FOR FREE PROPERTY APPRAISAL, and including my contact information and a provided QR code. Key Requirements: - Design a professional real estate flyer with a clear and visually appealing layout. - Incorporate a QR code and my contact information in a seamless and effective manner. - Include an image of me in the design. The deliverable for this project is a PDF file of the final design. Ideal Skills and Experience: - Proven experience in designing real es...
I'm seeking an experienced and knowledgeable data scraping professional to collect specific information from three major platforms - RERA websites (specifically Maharas...(Maharashtra, Telangana, Haryana, Delhi) - Google (DSA and Loan Agents data) - Justdial (DSA and Loan Agents data) The ideal freelancer for this job will be highly experienced in data scraping and will be able to deliver the results in an organized manner. Proficiency in scraping from Google, RERA websites, and Justdial is particularly important. Delivery Format: - The data should be delivered in an excel file format. If you have the required skills and this project fits your area of expertise, I encourage you to bid. Your understanding of the project could make a real difference. Let's discuss how w...
I need an Excel expert to help me organize and document my financial data. - The project involves documenting financial data, primarily focused on weekly updates. - There are no specific calculations or analyses required at this stage. - The ideal freelancer should have a good handle on Excel and experience working with financial data. Looking forward to receiving your bids.
Emulate Uniswap v3 quotter in a JS. I need a code that works same as Uni V3 Quotter contract, but just requesting pool info once and doing all calculations in pure JS: Requirements: -calcOutput(amountIn, tokenIn, fee,tick, liqudity, ticksBitmap.....) that outputs amount out -Test code - testCalc(poolAddress, amountIn, tokenIn) function: -read required pool data from chain -call calcOutput function -call Quotter with same params on chain. -Difference should be less than 0.001% -Pure JS, zero dependencies(if you need UniV3 SDK function - copy it right into code), JS float numbers prefered(rounding accepted in case it gives 0.001% accuracy), BigInt as worst case. Deadline - 24 hours.
I'm in need of a detail-oriented specialist to perform data entry on textual content that's already well-organized. Key Tasks: - Accurate entry of textual data into Excel format - Pace of work should be efficient without compromising the quality - Ensure a smooth transition of data, maintaining its organization Ideal Skills and Experience: - Previous experience in data entry jobs would be beneficial - Proficiency in Excel - Excellent attention to detail - Ability to handle data in an organized manner - Good command of English language to understand textual data.
Hello I am looking for a python code to scrape a large number pages and save them as html. In order to get to the page to save, you must click a radio button, submit, and then enter a string of numbers, then submit and...enter a string of numbers, then submit and then save the html. If the string entered provides an error then you must skip to the next iteration. There is no human verification. I already have a version I made myself that works with Selenium, however I need to increase the speed, so I am looking for someone to see if its possible to do this without even opening a browser and possibly using direct call methods (get, request, cURL, response, JSON?). It should be a simply project for someone who knows how to do this. Please enter the result of 3+2 for your message to be...
The project is about writing a program that will be a solution to the problem of feasting philosophers I prefer to call them monks because it seems more logical. So the monks sit in a circle and eat rice, but not all of them have two chopsticks on the table in front of them that can be lifted (monks always use two chopsticks to eat rice. An image from Wikipedia is helpful in illustrating this. For a monk to eat, he needs two chopsticks, so after they finish eating, they put them on the table, then the person sitting next to him, either on the right or on the left, can pick up the chopstick (everyone eats for the same amount of time, at the end everyone must be full equally). After eating, monks put their chopsticks on the
I'm experiencing problems with the functionality of a small few paged website, that has recently been migrated to a new server. The form used to use a 3rd party validation and it just needs removing to allow the form to post propertly. Code is stored in bitbucket - setup with a pipeline.
I need an expert to take on a data documentation project. It involves converting data from Excel sheets into word documents. The skillset required includes, but is not limited to: - Proficiency in Microsoft Excel and Word - Attention to detail, since the data to be converted is a mix of numerical and textual information - Excellent data organization skills The intended outcome is to have data that was originally in Excel converted and reorganized into a Word document. Please bid if you're sure you have the right skills for this task.
I have a 3.5-page handwritten sign-in sheet that I need transcribed into an Excel spreadsheet. The main purpose of this task is to make it easier for me to search through the records. The final document should be a straightforward, clean and well-organized spreadsheet, reflecting the original sign-in sheet's content as accurately as possible. Skills and experience necessary: - Proficiency in transcription, especially from handwritten documents - Strong knowledge of Excel or Google Sheets for high-quality spreadsheet creation - Attention to detail to ensure accuracy and completeness of the transcription The ideal freelancer should be reliable, with good communication skills to ensure smooth and efficient completion of the project. Color-coding or highlighting of spec...
I'm seeking a specialist with expertise in detailed financial data entry. You'll be tasked with entering intricate numbers and figures for our financial reports. Skills and Experience Required: - Proficient in Microsoft Excel. - Experience with financial report data entry. - Detail-oriented with ability to handle complex numerical data. Main Tasks: - Inputting detailed financial data into our Excel-based financial reports. - Ensuring accuracy of data. - Completing tasks within given deadlines. Please share relevant previous experience and examples of your work when bidding.
I'm in need of a skilled .NET developer to create...additional integrations may be required in the future. Experience with integrating external systems and APIs would be beneficial. - User Roles and Permissions: The application may need to support multiple user roles and permissions. While this is currently marked as 'unsure', the ability to handle this efficiently would be a plus. Ideal Skills: - Proficiency in .NET development - Strong knowledge of SQL databases and data management - Experience in user authentication and registration systems - Previous work involving user role and permission management - Flexible to adapt and integrate external systems when required If you're a skilled .NET developer with a track record of creating user-centric web applicatio...
I'm looking for a talented C/Linux developer to create a desktop application. You will develop the project in C/Linux. Project will be tested in Ubuntu 22.04 Linux 64-bit. You will develop a program to access and modify a FAT32 disk image (FAT32 volume). The disk image will be stored as a regular Linux file, which will simulate a disk formatted with the FAT32 file system. Your program will open the Linux file using the standard open() system call and access it directly in raw mode, utilizing the read() and write() system calls, without mounting the FAT32 file system. The program will be named fatmod. Through various options, it will in- teract with a file system image, enabling reading and writing of files. Detailed explanations of the specific supported operations wil...
I'm in search of a seasoned Excel-savvy bookkeeper to assist with the following tasks: - Accounts Payable: Tracking and managing all outgoing payments in a clear and organized manner. - Accounts Receivable: Overseeing and monitoring all incoming payments, ensuring timeliness and accuracy. - Bank Reconciliation: Regularly reconciling bank statements with our financial records to ensure accuracy. You don't necessarily need to be an expert in accounting software, but you should be fluent in Excel. This project doesn't involve learning new software, but rather meticulously managing and organizing financial data in Excel. I prefer to receive updates and reports via email, so clear and concise communication skills are a must. Experience in bookkeeping or a...
I'm in need of an experienced ...who can create a new EC2 instance identical to the current one. Here are some detail regarding the project: - Task involves creating a new EC2 instance from scratch, identical to my current one. - You will not need to make any connections to any other AWS services since I did not answer this requirement previously. - Your role involves providing a solution to my SSH key file loss, which might call for EC2 instance recreation. The ideal candidate should have considerable experience working with Amazon Web Services, specifically in the field of EC2 instances creation and management. Having dealt with SSH key file issues will be a major plus. Please state your experience and approach to the task at hand in your bid. Looking forward to a fruitful...
I need an Excel expert to help me document my financial data in a specific text-based format. Key Requirements: - Organizing and documenting financial data in Excel - Following a specific text-based format provided by me Ideal Skills and Experience: - Proven experience in working with financial data - Proficiency in Excel, including advanced functions for data organization - Excellent attention to detail and ability to follow specific instructions accurately and efficiently.
I need a seasoned developer with deep experience in elementor and modal popup creation. The main functionality desired is for modal data to be captured and stored in a MySQL database. Key Functions & Skills: - Creation of a modal popup that will collect user preferences for content. - Experience in designing customizable Elementor modal pop-ups. - Proficiency in MySQL database to store the collected data. - Knowledge of various trigger options for the popup. - Previous experience integrating modal popups with email marketing platforms will be a plus. This project offers an opportunity to showcase creativity and technical prowess in popup design and implementing complex functions. Your expertise will play a crucial role in enhancing user interaction on our platform.
helps how to convert excel sheets into a document
Looking for someone who is highly knowledgeable in Excel functions, formulas, and formatting. The ideal freelancer will have experience performing the following tasks in Excel spreadsheets in portuguese - Implementing a variety of Excel formulas and functions - Applying diverse formatting techniques Unfortunately, I have not specified the exact functions, formulas, or formatting needed, meaning the freelancer must employ a broad range of knowledge and expertise in these areas. Experience with Excel in Portuguese is a definitive plus. The project requires an adaptable and meticulous individual able to meet changing demands efficiently.
Please only bid if you're comfortable with screen sharing, allowing me to share my screen with you to provide detailed explanations of the tasks. 1. Copy all current website's important functions and paste to my other same website just .ca instead. 2. Make sure all current functions work on my cleaned up theme 3. Make sure everything is responsive...current functions work on my cleaned up theme 3. Make sure everything is responsive on all devices -Posses an excellent understanding of WordPress and Redux framework to ensure a successful build. -Proficient at modifying WordPress themes, primarily CSS, to suit my needs. -Can deftly update Redux options, refactor Redux code, and customize existing Redux fields. Contact me for a Share Screen call to understand more...
I am looking for a Twilio expert to assist with the implementation of Voice Activity Detection (VAD) in a Twilio Call and integrate with TTS, STT, and LLM - except VAD, everything is already in place, just need someone to complete VAD and make documentation Looking for local developer with little AI knowledge. Can hire full time if work is good.
I am looki...will NOT a typical chatbot in which questions and answers are pre-defined. Key requirements include: - Development specifically for the Android and IOS platform. - Integration of AI technology to facilitate interactive video call. - Implementation of an AI agent for real-time interaction. Ideal skills for this project include: - Proficiency in Artificial Intelligence and Deep Learning - Experience in developing chatbots - Ability to integrate the chatbot seamlessly into a website - Strong communication skills to ensure the chatbot is engaging and effective in a video call setting. The successful completion of this project will require a developer who can deliver a high-quality and seamless user experience, and who is able to effectively integrate AI capabilit...
Hi there We looking for skilled and reliable Developer who have goos skills in MongoDB and Laravel and RestFul API to build APi "Call and Request API for our ChatSystem. U have to work with 2 Developer in our team, ur task will be basicyl only our Admindashboard and API - Side only. What we have ready - Our Dashboard is ready has some issue u have to fix them first - Our MongoDB is ready we will provide u the access for that What is ur Work; U will clean up our iTheme and do some optimzation in our Dashboard like remove some Module and fe by following our Documentation in the Attachment. U have to create the API what our App developer need and also u will request the Data form that Developer about ur need to do ur work. U have to deliver clean work and deliver the API d...
I need a talented designer to create a minimalist logo for my company. Here are my requirements: - The primary color scheme should be based on black and white (grey if useful). - The design should be minimalist, with clean and straightforward lines. - Incorporation of the company name is not obligator...should be based on black and white (grey if useful). - The design should be minimalist, with clean and straightforward lines. - Incorporation of the company name is not obligatory. Skillful use of it, contingent on how it fits into the design and overall aesthetics, is appreciated. Ideal candidates should possess past experience in minimalist logo design and a keen eye for balancing colors. If you excel in creating attention-grabbing logos with subtle details, then this project i...
I'm looking for an experienced freelancer who can convert my Excel sheets into Word documents. The documents need to be in text only and follow a specific format, for which I'll need help in creating a template. Ideal Skills: - Proficiency in Excel and Word to ensure accurate conversion. - Experience in template creation and design to help structure the documents appropriately. - Attention to detail to ensure the final Word documents are error-free and cohesive.
I'm in need of an experienced developer to bring my SQL codes with the triggers to life with a well-designed Apex Oracle application. The app is expected to have the following features: - Implementing data entry forms that are intuitive and user-friendly. - Developing robust data analysis reports that provide valuable insights in an easy-to-understand format. - Setting up a comprehensive user authentication and security system. - Creating a visual design that aligns with my company's corporate branding while also being colorful and vibrant. - Ensuring the application is responsive and works seamlessly on both desktop and mobile devices. - Implementing an efficient navigation and information architecture to enhance user experience. The ideal candidate for this project sho...
I'm in need of a skilled web developer highly experienced in both Angular and Javascript. The primary objective for this project is to create a website with a responsive design that aligns with my provided brand guidelines. Key Qualifications: - Proficient in Angular and Javascript - Extensive experience in responsive design - Extensive experience in .Net Core and SQL Responsibilities: - Adhere to design and branding guidelines during web development - Create a website that is user-friendly on all devices. Please ensure to provide examples of past work with responsive web design during your application.
... Debugging The application connects to a remote Mongo Atlas database correctly if the code is run outside the container. I’ve developed a simple Mongo connection js file which tests this. The output is shown here - Also, here is a screenshot of a sample GET call to the API endpoint using Postman. This call works when the Mongo library is commented out in the file. I’ve also checked the Mongo library is present within the running Docker container. This has been done by looking at the file system of the Node app within Docker Desktop. NOTE - I have
...applications, with the aim to identify and eradicate any potential vulnerabilities. Key Tasks: - Perform Open Source Intelligence (OSINT) - Port scanning - Man-in-the-middle (MiTM) attack simulation - Focus intensively on injection attacks (SQL, XSS) - Authentication and session management puncturing - Cross-Site Scripting (XSS) evaluation The ideal freelancer will have: - Strong experience in cybersecurity and penetration testing - Excellent knowledge and experience with Linux-based systems - Proven experience in web application security testing - Firm understanding of SQL, XSS and authentication vulnerabilities Your final deliverable will be a complete penetration testing report, detailing vulnerabilities found, their potential impact, and recommended remediation step...
Hola, María, necesitaría el trabajo de este excel: https://docs.google.com/spreadsheets/d/1tnP73xrnE0SGNuynpLpnl1r7mThhi4liPCQCYjTRdvE/edit#gid=1193400678 Gracias,
I'm looking for a freelancer who can create a custom Excel sheet to track the daily attendance of my employees. The sheet should: - Be user-friendly and easy to navigate - Allow for automated calculation of total attendance - Be able to handle multiple employees at once - Have the capacity to expand for future growth I'm not looking for anything too complex, just a simple, efficient tracker that can help me keep tabs on my employees' attendance on a daily basis. Ideal Skills: - Proficiency in Excel, including advanced formulas and functions - Experience in developing user-friendly, automated spreadsheets - Strong organizational and communication skills to ensure the tracker meets my needs and is easy to understand and use.
As a client, I'm seeking a seasoned data analyst with expertise in data science who can thoroughly clean, preprocess, and visualize a dataset sourced from CSV files. The chosen candidate: - Should first start with cleaning and preprocessing the data to create a reliable foundation for analysis. - Should then interpret and present that same...end-product of this project is not just predictive analytics but insight and data-driven recommendations that will inform future decision-making. Proficient use of Python or R for these tasks is essential, as is familiarity with data cleaning and visualization libraries and tools. To thrive in this role, you must be a highly analytical thinker with the ability to separate noise from signal in dataset and excel at drawing clarity out of com...
I'm in need of an individual proficient in Excel to streamline data analysis for my sales numbers. The main objective will be to dissect revenue trends within the data, so particular attention to this metric is essential. Ideal qualities include: - Great attention to detail - Previous experience in data analysis - Proficiency in Excel - Understanding of sales and revenue benchmarks This role will require you to receive raw data and translate it into an easy-to-understand format, highlighting pivotal information. Your focus will be on creating complex formulas to identify revenue trends, which will help inform our future sales strategies.
I'm looking to automate my trading processes using the Zerodha Excel API. As I'm unsure of the API's development, I need a freelancer who is experienced in API integrations and has a good understanding of automated trading systems. Key Elements: - Automation: The primary goal is to automate trades based on predefined criteria. This involves developing a system that can analyze market conditions and execute trades automatically. - Zerodha Excel API: As I am unsure about the development of this API, you should have a good understanding of it or be able to quickly grasp its functionalities. - Trading Experience: It would be beneficial if you have prior experience in developing automated trading systems. - Predefined criteria: The system should be able to automati...