Excel dde mysqlроботи
Front: Vuejs3 (routing, vuetify) Back-API: flask( SQLAlchemy, flask-restful, uwsgi), jwt, mysql Нужно реализовать SPA. Два типа пользователей (юзер, админ), доступ к SPA только после авторизации (пара логин/пароль). Для юзера: (страница №1) - реализовать поиск по базе данных, поиск по всех полях (отдельно по дате, фио, заказу), предусмотреть последующую фильтрацию результатов пользователем (фильтрация: пользователь вводит текстовую строку и если она может быть включением любой ячейки своей колонки результата поиска то отображается, остальные прячем), предусмотреть пагинацию. (страница №2) - как и страницы №1, но база другая, поля базы совпадают. Для админа: добавление новых юзеров админом, и доступ к функционалу описанному у юзера. База данных: ФИО (текстовое), ДатаРожд...
Створити таблицю Excel та внести в неї данні з касових чеків. Розбити по періодам та групам.
Для нашого онлайн ...найсучасніших веб-технологій для різних пристроїв (мобільних, планшетів) Профіль: • Хороші знання з програмного забезпечення (об'єктно-орієнтований дизайн, шаблони проектування, тестування) • самостійна робота та вирішення проблем • високий рівень мотивації • Досвід роботи з PHP, Symfony, Laravel або Zend, є перевагою • Вільне володіння німецькою чи англійською мовами • Дуже хороші знання PHP, MySQL та JavaScript • Добре знання HTML (5) та CSS (3)
Будь ласка, вкажіть 1-3 проекти, де Ви працювали із таксономіями (WordPress) та як Ви їх застосовували, де робили кастомну адмінку PHP+MySQL. Очікую на оцінку вартості та термінів, або уточнювальних запитань. Посилання на ТЗ:
Потрібно розгорнути на віртуальному сервері 1. веб сервер (apache/nginx/ +PHP) 2. СУБД (mysql/postgresql) 3. сам сайт
1) Є портали відкритих даних. наприклад 2) Потрібно розробити засоби завантаження відкритих наборів даних. вимоги: 1) Веб рішення (далі сервіс). на базі наприклад PostgreSQL / MySQL 2) конфігурація процесу завантаження конкретного набору даних: - даємо посилання на набір даних - Сервіс парсить структуру - на підставі парсинга конфігуруємо таблицю БД, куди будемо завантажувати дані - вказуємо періодичність завантаження даних - зберігаємо конфігурацію. 3) Сервіс повинен виконувати завантаження за розкладом. 4) Сервіс веде лог завантаження 5) Перегляд інформації повинен мати: графік та лог завантаження, таблицю з даними, конфігурацію процесу(тобто url, тип файлу)
Потрібно написати модуль (скрипт) для оновлення цін в інтернет магазині. Періодично висилають нові прайси, з яких потрібно підтягувати нові ціни. Вибірку робити по артикулу товару. На сайті поле артикула містить також назву фірми (для прикладу Nowodvorski 65441), а у прайсі просто 65441. Прайси приходять у Excel. Інтернет магазин створений на базі CMS Drupal 7.
Потрібно зробити легкі лабораторні роботи, терміново! Файли прикріпив, за потребою скину методичку.
Ввод информации в базу, возможно Excel либо другой редактор, могу работать непосредственно с онлайн информацией
Вносити дані до таблиці Excel. Це э дуже непогана робота яку можна виконувати дуже швидко, а головне чітко і без помилок.
Привіт chnazar, бачив твоє резюме на рахунок пошуку роботи якщо тебі цікавий довготривалий проект (PHP,JS,HTML,CSS,MySQL) можемо обговорити деталі
I am starting a business offering Excel and typing services and require a freelancer's expertise to assist with setting up my business structure and developing a strategy to acquire clients. The ideal candidate should have: - Experience in business consultancy, particularly in setting up new businesses. - Knowledge of legal and financial business structure requirements. - Proven strategies for client acquisition and marketing, especially for freelance or B2B services. - Ability to provide personalized advice for a startup in the data processing domain. The project will involve: - Assessing the best business structure for my services (Sole Proprietorship, LLC, etc.). - Guiding through the necessary legal and financial setup procedures. - Developing a clear and actionable clie...
I'm seeking a proficient freelancer to assist in a straightforward yet critical task. The project involves: - Data Entry: You will be required to input simple text or numbers into an Excel sheet. - Data Collection: Sourcing of data forms part of the project. This encompasses the need to gather the necessary information for the task. The ideal candidate for this role should have: - Strong Excel Skills: Proficiency in Excel is a must. You should be comfortable with data entry and basic functions. - Attention to Detail: Accuracy is paramount in this task. - Research Skills: The ability to efficiently source and collect the required data. Candidates with a track record of completing similar tasks efficiently and effectively will be highly regarded.
I am an emerging freelancer specialized in Excel, offering services in data analysis and routine work automation. With academic experience in handling complex Excel functions, I am poised to help clients streamline their operations and uncover valuable insights from their data. Key services include: - Crafting custom Excel spreadsheets for data analysis - Automating repetitive Excel tasks to save time and reduce errors - Analyzing datasets to provide actionable business insights - Creating visually appealing reports and dashboards for easy data interpretation Ideal Project Collaboration: - Clients seeking to improve data management and efficiency through Excel - Projects requiring the transformation of raw data into meaningful analysis - Opportunities t...
I'm currently in need of a talented Java backend developer who has a strong understanding of databases, particularly MySQL and PostgreSQL. Key Responsibilities: - API Development: The primary focus of the project is on developing APIs that are efficient, secure, and capable of handling high traffic. - Code Modification: The project requires some modification of existing code to ensure seamless integration of the APIs. - Reporting: The backend developer should be able to generate insightful reports based on the data stored in the databases. Ideal Skills: - Proficiency in Java: Excellent understanding of Java is a must. - Strong Database Skills: Prior experience with MySQL and PostgreSQL is necessary. - API Development: A proven track record in creating high-performance ...
I'm looking for a freelancer proficient in Excel for a simple data entry task. The work involves straightforward copytyping of numeric information into an excel sheet. Key requirements include: - Accurate data entry skills - Proficiency in Excel - Attention to detail The project doesn't involve any complex formulas or advanced functions. It's a relatively straightforward task that requires precision and focus. Your role will be to ensure all data is accurately entered into the spreadsheet in a timely and efficient manner. A keen eye for detail and a methodical approach will be crucial for successfully completing this project. Please note that the data entry will be in the form of standard tables, so experience with this type of formatting is an...
Create a PDF and Excel exporter download for both tabs Specifications and Questions (8hours) (160 USD) Layout for the mains page (4 hours) (80 USD) Documentations (1 hour) (20 USD) Plugins (16 USD Excel) you will buy directly from Bubble in your account Plugin (100 USD PDF) there is al alternative plugin (20 USD)you will buy directly from Bubble in your account
I have an edited Excel spreadsheet that needs some final touches. I have a macro that needs to be created to hide and unhide rows in the sheet. Key tasks include: - Creating a macro that enables the user to hide and unhide specific rows using a button Ideal Skills: - Expertise in Excel macro creation - Proficient in data manipulation and Excel functions - Experience in creating user-friendly interfaces - Attention to detail to ensure the macro functions correctly and efficiently This project is straightforward and should be quick for an experienced Excel user.
I need an Excel expert to enter a set of numbers and dates into an Excel sheet, and perform some basic calculations. - Data Typing: You'll need to be comfortable working with both numbers and dates, as these will be the primary data types that need to be entered into the sheet. - Calculations: There are two specific calculations that need to be performed on the numbers: - Summation: You will need to calculate the total of all the numbers. - Average Calculation: You will also need to find the average of all the numbers. - Date Formatting: The dates I will provide need to be formatted in both date and time format. This means you should be adept at formatting cells in Excel to ensure the correct display of dates and times. Ideal Candidate: - Proficient in ...
...Cards Against Humanity game that needs some adjustments and updates. Key Tasks: - Fixing Errors: The current project has some bugs that need to be addressed. The app is crashing on startup and experiencing database retrieval issues. Your task would be to resolve these errors and make the application functional again. - Database Update: You'll need to shift from the current WebSQL database to MySQL and ensure smooth data storage and retrieval. New Features to Add: - User Authentication System: Incorporate a new authentication system to enhance user privacy and security. - Game Timer: Implement a game timer to bring an additional level of challenge and excitement to the gameplay. - Animations & Interactivity: Enhance user experience with engaging animations and interact...
...specific improvements to my existing PHP application and enhance its integration with QuickBooks Online. CURRENT: We have a QuickBooks Online application that syncs invoices from QuickBooks Online to two MySQL database tables (order headers and order lines). This application works correctly but we want to add a condition to the INSERT statement in this program so only invoices that have a custom field populated will get synced to these tables. The custom field name to check is "Online Order Number". Requirements: - Modify functionality of existing program to only INSERT records to MySQL table when invoice record contains a value in custom field "Online Order Number" The ideal freelancer for this project should have: - Proven experience working with ...
I am looking to automate certain repetitive tasks that are currently performed in Excel using Power Automate. - Main Objective: The chief goal of this project is to automate data comparison tasks. This will greatly improve productivity and minimize errors that may come with manual comparison. - Ideal Experience: The ideal freelancer for this task should have extensive experience in Excel and Power Automate and should have successfully completed similar jobs in the past. A strong understanding of data comparison techniques and working with excel spreadsheets will be highly beneficial. - Skill Set: Key skills required include Excel, Power Automate, and a good understanding of data processing and workflow automation.
I am starting a business offering Excel and typing services and require a freelancer's expertise to assist with setting up my business structure and developing a strategy to acquire clients. The ideal candidate should have: - Experience in business consultancy, particularly in setting up new businesses. - Knowledge of legal and financial business structure requirements. - Proven strategies for client acquisition and marketing, especially for freelance or B2B services. - Ability to provide personalized advice for a startup in the data processing domain. The project will involve: - Assessing the best business structure for my services (Sole Proprietorship, LLC, etc.). - Guiding through the necessary legal and financial setup procedures. - Developing a clear and actionable clie...
I am in need of an Excel expert who can create a dynamic and well-structured line graph based on data from a questionnaire that automated itself using text and numeric data. This project requires knowledge and practical experience with: - Excel data manipulation - Advanced graphing techniques - High attention to detail. The project specifically involves working with three or more different data sets and multiple excel books. The right candidate should have a track record of creating visually stunning and effective Excel graphs that allow for easy interpretation and extraction of meaningful insights from text data. The line graph should allow for a comprehensive overview of all data sets at once. It should make it easy to identify trends and changes over time...
I'm seeking a professional web developer, extremely proficient in PHP and MySQL who can upgrade sales and users modules in our POS system. - Abilities: You should have substantial experience and demonstrated proficiency in building complex, user-friendly websites. Your PHP and MySQL skills must be exemplary. - Preferred Framework: I don't have a particular PHP framework preference. You can use the one you're comfortable with.
I'm looking for a professional to create a monthly income statement in Excel spreadsheet format. Key Requirements: - The task is to generate an income statement. - The data must be accurate and well-organized. - I would like to have the report in Excel spreadsheet. - The report should be delivered on a monthly basis. Ideal Skills: - Proficiency in financial reporting and analysis. - Advanced Excel skills. - Attention to detail. - Experience in creating income statements. - Timely delivery.
business profit loss reporting excel(Jan, Feb & March)
-The Excel workbook should comprise multiple worksheets showing the models, the regression analysis summary, the comparison of model performance, the decision tree, and the calculations you used to answer the task questions that require you to complete in Excel USING SOLVER. -report should be mainly for the economic order quantity (EOQ) analysis and the answers to the qualitative questions. No introduction -1900 word report -There should be at least FOUR worksheets in the Excel workbook. Two of them should show the following two demand forecasting methods that you are required to use to forecast the demand of 5 kg ice bags at Caltex, a petrol station in Melbourne. 1. Moving average 2. Static method. for the other two: summary of the regression analysis for the static...
Olá, tenho um sistema simples de gestão feito em PHP com BD em MySQL, gostaria de converter esse BD para trabalhar de forma Multi Tenant (varias empresas no mesmo banco de dados em uma unica instalação), e tambem criar um painel administrativo para ativar e desativar essas empresas.
I’m seeking a skilled developer to convert my existing PortVB Desktop App into an iOS/Mac Desktop App. It a small tool that runs on a Windows PC and reads some flat XML files and inserts/updates a mySQL database. We need the same program to be able run on a iOS/Mac desktop. I have all the VB Project files/ Source code. - Skills in app development for iOS/Mac, ideally with previous experience in app conversion - Knowledge of data syncing, user authentication, and offline access, in case these features need to be incorporated - Familiarity with contacts management, communication, scheduling, calendar integration, and file/document management functionalities for potential focus areas - Creative design skills to potentially revamp the user interface and overall design of t...
...causing any conflicts. - Need to add additional search filter "Industry" before other search criteria and for this to match jobs or candidates in that particular industry. There are a total of 9 industries on this job board. - Need additional search fields for both Company / Employer, Candidate, Job Search and Filter, Post Job. - I would like to know if it's possible to upload job titles from excel into the job fields for search criteria. - I would also like a place for employers to add job title if it's not in the list. Most is setup in templates, just needing a few additions and changes. Would like additional blank fields that I can fill in later as additional requests are made. - Possibly style search and output pages. I'm open to input from previo...
...messaging services to handle asynchronous communications, ensuring efficient and reliable data exchange across system components. SDK Development - Develop and maintain an SDK that provides third-party developers with the tools needed to integrate their AI bots or other services with our platform, including comprehensive documentation and support. Database Management - Manage and optimize MySQL database interactions within the WordPress environment, ensuring efficient data retrieval and storage. System Integration and Testing - Oversee the integration of all system components, employing best practices in continuous integration and deployment to maintain system integrity and performance. Documentation and Support - Produce detailed documentation and user guides...
As a small commercial general contractor, I'm seeking professional assistance to improve my Excel workbook used for estimates and bids. The ideal candidate for this task should have: - Top-notch Excel skills, specifically understanding VLOOKUP functions and formulas for summing totals. - Experience in creating automatic calculations to streamline my estimation process. - A knack for designing and customizing Excel templates. - A solid understanding of construction or a similar industry would be a huge plus. Specific tasks include: - Building automated calculations for summing totals and utilizing VLOOKUP functions. - Customizing Excel templates, specifically for the cover sheet, project details sheet, and bid summary sheet. Approach this task with a ...
I'm in need of an experienced Linux and Server Admin who can help me with the following tasks: - Linux and Server Administration: Proficient in CentOS, you'll be managing my server and ensuring its optimal performance. - Web and App Installation: You'll be responsible for installing and configuring various websites - coded in PHP, Node.js, and Rea...administration, and web/app installation. Proficiency in PHP, Flutter, and React Native is required. ------------------------------------------------------------------------------------------ Should have experience in linux VPS, setting up sites apps email dns firewall NO CPANEL. All work to be done using command line Sites are in php wordpress Node React Apps are in React Native Flutter Database: Mysql/mongo Amt pos...
I am actively seeking 50 dedicated women to assist with part-time digital marketing on Facebook and Instagram. Ideal candidates are those with: -No skills required - 10th pass can also apply - work from home opportunity - Training and guidance will be provided This is an exclusive opportunity for women only. If you're looking to excel in a digital marketing role, please place your bid.
I am making a GANTT chart and need to make it highlighted. the chart is created using highlight formula instead of using basic insert chart option. I need help to do a part of it. Video explanation of the problem: Excel file I am working on is attached: The ideal chart should look like the attached image: Looking for the cheapest service as this is almost done.
I need a small application prototype with the following features: Multi-Employer Job Portal/Admin app (Role Based access) User/applicant App (for Multiple applications to different employers) User Profile Document Upload (Save documents to Db and attachments to Blob Storage ) Send Emails to Employers and applicants back and forth 2 Apps in total ie. admin app and applicant app. job application requirements will be provided. Nodejs, angular, My SQL, ORM, Data Seeding, Migrations should be used.
I'm looking for an experienced professional who can create a custom Microsoft Excel spreadsheet for me. This spreadsheet will be designed to generate GUIDs (Globally Unique Identifiers) in a random fashion. The GUIDs will be used for database record identification. Key Requirements: - Development of a custom Microsoft Excel spreadsheet. - Implementation of a random GUID generation mechanism. - Ensuring the functionality for database record identification. Ideal Skills & Experience: - Proficiency in Microsoft Excel, particularly in custom formula creation. - Strong understanding of GUIDs and their usage in database systems. - Previous experience in developing similar solutions. I'm looking for someone who can deliver a well-functioning and efficient sol...
I'm seeking an experienced Excel professional to assist with a small data entry project. Key Responsibilities: - Data entry with formulas: You should be proficient in Excel and comfortable working with spreadsheets that require formulas. - Handling digital data: You will be provided with data in a digital format, likely an Excel or CSV file. Ideal Skills: - Advanced Excel skills: You should be well-versed in Excel, particularly in data entry and formulas. - Attention to detail: Precise data entry is crucial for this project. - Efficient and organized: I'm looking for a freelancer who can manage their time and workload effectively. Please note that this is a straightforward project with no requirement for data analysis or visualization. A h...
I am seeking an experienced Excel expert to help resolve an issue with a percentage calculation in my Excel spreadsheet. Despite following standard procedures, the result is incorrect, and I need assistance to identify and correct the problem. Details: I am working with the following data in my spreadsheet: Total Costs for the Job (Cell V14): $241,779.50 Total Collected (Cell V17): $289,844.00 Profit (Cell V15): Calculated as =V17 - V14, resulting in $48,064.50 I need to calculate the profit as a percentage of the total costs, and this should be displayed in cell V16. The formula I am using is: = ( ? 15 / ? 14 ) ∗ 100 =(V15/V14)∗100 Given the values: = ( 48 , 064.50 / 241 , 779.50 ) ∗ 100 = 19.88 % =(48,064.50/241,779.50)∗100=19.88% However, i...
I need to make updates to userform so that empty dates do not affect filter on table. Right now leaving date field empty hides all the rows of table. Few more updates needed and more details will be shared with selected freelancer.
I'm looking for a data scraping specialist proficient in leveraging social media platforms, business directories and website scraping. The goal is to create an Excel sheet with approximately 500 entries for market research purposes. Skills & Requirements: - Proficient in data scraping from multiple sources - Capable of filtering and sorting data - Able to extract and compile the following data fields: zip codes, locations, contact information, business name and industry. The successful candidate should demonstrate experience in similar projects, showcasing their ability to find and compile information efficiently and accurately for market research purposes.
This is my website link I have used "Classima – Classified Ads WordPress Theme" theme. I want to upload date from xls sheet. Excel attached for your reference. Raduus Theme is not providing support and they only provides category and location import options. Can you help me to import data
I need a bash script that can import and export data from my database to CSV files. Ideal candidate should be able to: - Create a bash script that can effectively import and export data - Have experience working with database management systems such as MySQL, PostgreSQL, or MongoDB - Ensure that the script securely creates user accounts and manages their access to the database. The script will be used for daily database management tasks, so it needs to be reliable, secure, and efficient.
I've got a list of company names on an Excel sheet that I need you to help me with. Here's how you can assist: - **Scraping from Multiple Platforms**: I need you to scrape email addresses, phone numbers, and any available social media accounts of these companies. You'll need to do this across Yelp, Google Maps, and TripAdvisor. - **Social Media Scraping**: In addition to the primary two platforms (Instagram and Twitter), I'll also need you to scrape Facebook accounts if available. Ideal candidates for this project should have: - **Web Scraping Experience**: A good knowledge of web scraping techniques and tools, which will ensure you can obtain accurate and reliable data. - **Data Mining Knowledge**: The ability to identify and extract the necessary data points...
I am in need of a skilled Java developer to create a comprehensive CRUDS (Create, Read, Update, Delete, Search) functionality for a ticket tracker application. The application should be backed by a MySQL database.
See attached detailed description of project. Ideal Skills: - Proficient in pHp 8 - Extensive experience in database integration, particularly with MySQL® - Strong problem-solving skills - Attention to detail and thorough testing - Previous experience with file processing in pHp I'm looking for a professional who can work efficiently and deliver high-quality results. If you believe you possess the necessary skills and experience for this project, I look forward to reviewing your bid.
I have an protected password .mpz format that I need to have the program can unlocked and converted into a readable format, preferably Excel or CSV. - The file contains both textual and numerical data, so I need the converted file to maintain this integrity. - I intend to use the data primarily for reporting purposes, so it is essential that the conversion is accurate and all data is preserved. I'm seeking a skilled professional with experience in file format conversion and data handling. The ideal freelancer should be proficient in Excel and adept at handling mixed data formats. This project is crucial and I'm looking for someone who can deliver a high-quality and precise conversion.
