We have a quick project for a Google Sheets / Excel Expert We have a Google Sheet that we need to filter and match customer names up to a sales rep. Essentially it needs to work like this: - Master customer data will go in sheet 1. This contains a list of customer names in column 1, and the corresponding sales rep in column 2. - Each week, we create a new sheet with payment data. - The payment data contains the payment and customer name. - we need the filter to match the customer name in the new sheet with the rep and insert the sales rep name in a new column. This will probably need to be done with a scrip - we need a proficient and experienced person to do this. If you have the experience, please message and I'll give you a loom video explain...
I'm in search for a professional well-versed in Google Sheets, specifically with the capability to execute and manipulate custom complex functions. You will be dealing with a medium sized dataset of 100-1000 rows. Key tasks include: - Implementing advanced formulas and calculations to an existing google sheet - Analyzing and providing visual representation of data in real time The ideal candidate should be proficient in data analysis, has excellent skills working with sizable datasets, and is a master of working with custom functions within Google Sheets. Your ability to interpret data and present in a user-friendly format will be essential.
I am urgently in need of an expert to assist me with a set of complex electrical circuit problems. Your task would be to: - Solve higher order ODE circuit problems - Assist with convolution problems - Tackle Laplace transfer issues The successful accomplishment of this project will result in: - Finding the transfer function - Analyzing the frequency response - S...Analyzing the frequency response - Solving for the circuit variables This project requires a great understanding of electrical engineering principles, particularly, higher order ODE, convolution problems, and Laplace transfer. Proficiency in complex problem-solving under limited time conditions is an added advantage. I need this job completed ASAP. If this sounds like the kind of project that you'd excel at, pleas...
I am in need of a skilled Bookkeeper with a sound understanding of quotes, POs, and invoices. I require 2 hours of these services everyday to maintain and organize my financial records. I currently manage my accounts using Excel, so ability to work with it effectively is key. Key Tasks: - Maintain financial transactions - Manage and update financial records Ideal Skills: - Proven track record in bookkeeping - Familiarity with technology sector taxes - Proficient in Excel - Great attention to detail and accuracy. Experience working in a similar role within the technology sector would be highly beneficial. If you have the necessary skills and experience, I look forward to receiving your proposal.
Se dedesa crear una pagina front + backend para asistente interno. En el front end se cargaran diferentes archivos (TXT, PDF, WORD, EXCEL en lo posible) con lo que llamaremos BASES DE CONOCIMIENTO pueden ser listas de precios, condiciones comerciales, etc con los que CHATGPT se puede conectar y consutlar via API y responder a los usuarios. Se aceptan sugerencias para este desarrollo o similar. Si tienen algo parecido para testear con gusto lo haremos. Se debe poder replicar en otras webs para armar diferentes chats con bases de conocimiento especificos.
...Upload daily order files - EXCEL/CSV. 2. Update daily orders , quanity, status (avaiable/not avaiable, when avaiable with dates) etc. 3- Genarate procurement orders sheet to market 4- Genarate adress sheet to feed into shipping software 5- Upload shipping software sheet into system. 6- generate order sheet with tracking number to feed into external system. 7- Should be able to view pending, fullfillment orders on any dates, date range. 8- create monthly or year to date, cutom range date report for all orders etc. 9- Able to upload supplier inventory sheet in to system on daily basis to check the delta of supplier inventory specially prices and quantity check from back date of data or new inventory. We should be able to track the changes in dail...
Consolidated Sales Calendar report put in excel spread sheet.
More details: Small Business Beauty Salon excel program required Inventory management: Track products in stock, Set reorder points for products, Generate purchase orders Point of Sale (POS): Cash, Credit/Debit cards, Mobile payments for Retail products [GST&PST] and services Daily Reports: Sales report, Inventory report, Employee productivity report Client management: History records or services done with client details and specification Employee management: Information; Timesheets; Vacation Payroll: Run semi-monthly payroll with hourly rate vs commission rate [Canadian payroll information] Salon supplies: Calculate and track supplies used during services to add to POS on checkout Schedule: Appointment schedule for clients with ability to send reminders.
...skilled professional to create an Excel workbook that provides user-specific access control. Unfortunately, I am unable to provide specifics about the type of access control, so flexibility and adaptability will be crucial for this project. Freelancers interested in this project should: - Demonstrate proven experience in Excel, particularly working with workbook-level protections and user access controls. - Have a strong background in data analysis, as this will be a key function of the workbook. Primary responsibilities will include: - Developing a user-friendly Excel workbook with user-specific access. - Incorporating data analysis functions into the workbook to streamline and enhance my workflow. Please remember to include your relevant experience in Excel...
*** PLEASE DO NOT ASK "WHAT IS YOUR BUDGET" YOUR BID AMOUNT SHOULD BE THE AMOUNT YOU INTEND TO DO ... PO Details to return a single row of data for each Invoice Detail record that matches the LATEST po line item within the same ITEM and SHIP TO CITY. The current SQL is generating duplicate records because it is matching against multiple PO details instead of the LATEST (newest) PO detail for that Item/Ship To City match. FILES INCLUDED: SQL File For Table/Data Query File for SELECT Statement Excel spreadsheet showing duplicate entries highlighted Key Tasks: - Correct SQL query to eliminate duplicate entries Seeking someone proficient in MySQL database design and query optimization. Previous experience with troubleshooting and resolving similar query issues would be a si...
I'm looking for an experienced Forex Expert Advisor (EA) developer who can help me modify and optimize my existing trading bots. Key Tasks 1. Modify Existing Strategies: - Improve entry conditions to be more aggressive. I am searching for a contributor who has experience and an understanding of forex trading conditions to help achieve this. 2. Adjust Risk Management Parameters: - Impeccably adjust stop loss and take profit levels, proving the ability to balance risk and reward effectively. - Implement a trailing stop feature to further protect the account from unnecessary losses. 3. Additional Modifications: - Beyond the listed points, I also have other specific alterations in mind that will be shared with the selected freelancer. Requiremen...
I'm in need of an expert in data visualization to assist me with setting up PowerBI and creating a dashboard for my business. Key Responsibilities: - Setting up PowerBI with a focus on data visualization - Integrating databases and Excel/CSV files as data sources - Creating a dashboard that presents Sales data, Website traffic and Product inventory in an easy to understand visual format Ideal Skills and Experience: - Extensive experience with PowerBI - Strong background in data visualization - Proficient in integrating databases and Excel/CSV files - Previous experience in creating comprehensive business intelligence dashboards - Ability to understand and visualize complex data sets This project is suitable for someone who enjoys working with data, has a keen ...
I need a GUI designed from scratch based on an existing Excel sheet. The GUI will primarily handle textual data. The key features the GUI must have are: - Data visualization: Show data in a user-friendly, visually appealing format. - Data filtering: Allow users to filter data based on certain criteria. The main purpose of the GUI is to present data, providing clear, easy-to-understand visuals of complex datasets. Ideal freelancers for this project should have experience in GUI design, particularly in relation to data visualization and filtering. Knowledge and experience with textual data handling is also a plus.
I am currently in need of an expert who can combine two separate Google Sheet leads lists into a single, consistent 'Master List'. Moreover, the project also necessitates the segregation of full names into separate 'First Name' and 'Last Name' columns. There are about 3000 rows that need to be combined. Ideal skills & experience: - Proficiency in Google Sheets - Experience with data management and organization - Past work quality and efficiency Key tasks: - Combine two Google Sheet leads lists into a 'Master List' - Merge and/or remove duplicate content - Separate each full name into 'First Name' and 'Last Name' columns - Ensure preservation of original data such as Addresses, Phone Numbers, Email Addresses, ...
Need someone who can analize data from a excel and contact customer with missing data
I'm looking for a digital artist with experience in creating digital signatures, initials, and email signatures. I aim to enhance the efficiency of my document workflows,...signatures. I aim to enhance the efficiency of my document workflows, particularly for my legal contracts. I also intend to use these digital assets for signing documents on platforms like DocuSign. Whilst you won't be required to arrange the storage solution for these assets, if you have suggestions based on previous projects, I'd appreciate your input. Additionally, I would love to get a practice sheet with my new signature and initials to see if I can teach myself how to sign my name like that on paper and pen as well. Familiarity with creating convincing, professional, and unique digital signat...
I'm in need of a dynamic Excel sheet that automatically updates with real-time stock prices for the S&P 500 companies from the New York Stock Exchange (NYSE). This needs to be updated every minute. The main focus will be on delivering accurate, up-to-date, and reliable data. Key Features Required: - Real-time NYSE stock prices; - Ability to track up to 500 stocks from S&P 500; - Automatic updates every minute. Ideal Skills and Experience: - Proficient in Microsoft Excel; - Experience with real-time data tracking; - Knowledge or experience within the stock market realm; - Familiar with NYSE workings. Given the technical nature of this project, the successful freelancer should have adequate experience working with real-time data in Excel and hav...
I'm looking for a professional with proficiency in Excel to carry out a data entry task involving text and images. The text data is currently formatted in an Excel spreadsheet and I would like to maintain that format for the entered data. Key tasks include: - Transcribing text data from Excel sheets - Efficiently importing and categorizing images Ideal candidates should have: - Previous experience in Excel-based data entry - Excellent attention to detail - Efficiency in handling images in Excel - Ability to maintain and replicate existing file structure Please note, the final output should also be in Excel spreadsheet format.
(Apply only if you can start ASAP and be able to draft the Gantt Chart in a few hours) I'm seeking a freelancer to make a Gantt chart using MS Project. The timetable for this project is stringent, so prompt delivery is paramount. I will provide all the details in Excel , you just need to put into MS Project and make a Gantt chart Key Features of the Project: - Focus on both subtasks and milestones when creating the Gantt chart. - The freelancer needs to be proficient in MS Project since it's the required software for this job. Ideal Candidate - Proven experience in creating/extensive knowledge about Gantt chart. - Prior usage of MS Project 2016. - Effective time management skills. Your prompt response will be greatly appreciated.
Hi Rachbauer L., you helped me create an instruction sheet for anchors on our swing sets. I now need something published that I can upload to our new website for the swings
I have a sheet that collects check-in/out times, project names and employee names. The sheet is updated by a google form. Names and projects on the form can change. I need this sheets data to be used to determine if a project is currently occupied and to generate a weekly time report by project and employee. - Determine project occupancy: The solution should utilize the check-in/out times to determine whether a project is currently occupied or not. -Occupancy: Displayed on a Google sheet as text (OCCUPIED/CLEAR) next to the project name or change color (red/green) of project name. - Weekly time report: The time report can be in Google Sheets format. - Technology/Platform: You are free to choose the best technology or platform to automate this process. Ideal...
More details: We have an internal excel worksheet that has currently not been put into production, we would like this converted to an editable PDF document that only selected boxes are editable and once finished we can then fill and sign to use on an Ipad, Iphone or Desktop if amendments were needed to be made. We would need a slightly bigger signature box at the bottom to allow our engineers to the click on the box and sign with either their finger or an Apple Pencil.
am seeking a competent data entry specialist with excellent attention to detail and proficiency in Tally. The assignment entails adding around 300 entries from an excel file to tally data (i.e. update company Tally Books ). Each entry in excel has comments that specifies the heading & vendor name for the data entry. Once the data is entered the same will be verified by us for correctness. Key Responsibilities: - Organizing extensive financial data within Tally with accuracy and precision - Ensuring the data is properly categorized and easy to understand - Verifying the accuracy of the financial data, correcting any errors, and handling any discrepancies. Ideal Skills and Experience: The ideal candidate should be precise, meticulous, incredibly organized, and possess th...
As per requirement, I will deliver the required district's School details in Excel format
...force behind this project, I am searching for a developer well-versed in calculator creation, who can transform my vision of a conveyancing quote calculator into a digital reality. Feature Requirement: • The core purpose of the project is to develop a Legal Fee Calculator, that is, a digital tool that computes legal fees in real-time. Key Factors: • Essentially, the calculator must take the purchase price into account while making calculations. Formula for Calculation: • The unique selling point of the calculator will be its ability to compute the legal fees on a sliding scale based on the purchase price. Desired Skills and Experience: • A strong background in financial computing or relevant experience in calculator bu...
I'm looking for a skilled statistician who can calculate the winning probability and the probability of a specific number appearing in ...number appearing in a number game I'm working on. The winning probability should be calculated under specific conditions that I will provide. I want the calculations to be presented in a clear and concise Excel sheet. The Excel sheet should be basic, focusing on essential calculations. Role Requirements: - Proficiency in statistical analysis and probability calculations - Advanced Excel skills for creating clear and concise spreadsheets - Ability to follow specific instructions for conditional probability calculations Ideal Skills: - Statistical analysis - Probability calculations - Excel - Data pr...
...analysis feature - The app should automate data import/export and manipulation tasks The application should also be capable of seamlessly integrating with various software tools. While Microsoft Excel and Access are a given, the ability to integrate with other tools is also vital. Having experience working with a variety of software packages is a considerable advantage. Skills and Experience Required: - Proven experience in VBA development, particularly applications for data analysis - Familiarity with automation of tasks using VBA - Proficiency in integrating VBA apps with different software like MS Excel and Access - Flexibility in working with other unspecified software tools This project is ideal for innovative developers who understand the importance of streamlinin...
I need a talented and experienced designer who can help me execute an extensive redesign of my Canva project. Ideally, you should have excellent skills in working with Canva and a keen eye for aesthetics. Specifically, the project will involve: - Text modifications: The font style will have to be changed while al...- Image replacements: Replace existing images with those I will provide. Skills and Experience: - Proven experience in managing Canva design projects - Excellent eye for detail - Strong graphic design skills - Good understanding of fonts, colors and layouts - Excellent communication skills to understand and translate my vision into the project design If this sounds like a project you can excel at, I invite you to place your bid. I look forward to seeing your ama...
I'm looking for a skilled professional who can create a VBA solution in Excel that can interact with a MySQL database. The system should be able to perform the following CRUD operations: Insert, Select, Update, and Delete. This will be a continuous requirement. Key requirements: - Proficiency in MySQL and Excel VBA - Strong understanding of SQL ODBC connections from Excel VBA - Ability to deliver the project within timelines. Your main task would be to create a reliable, easy-to-use, and efficient system to automate the specified database operations from Excel. In addition, the final solution should be well-documented for future reference. If you have experience in similar projects and can commit to the timeline, I'd love to hear from you.
I have less than 10 columns of text and numbers data, currently in scanned documents that need to be accurately typed into an Excel sheet. I am looking for someone highly detail-oriented with: - Proven experience in data entry or similar roles - Excellent typing speed and accuracy - Proficient in using Excel - Experience in digitizing scanned documents is a plus Responsibilities include: - Typing text and numbers data from scanned documents into Excel accurately - Ensuring no data is missed or misrepresented - Completing project within the agreed deadline. Looking forward to working with a diligent and efficient freelancer.
I'm looking for a skilled statistician or data analyst to interpret raw survey data that I have in Exel Sheet format. Since the data is already digitized, your key focus will be analysis and interpretation. Data: 1- Exel Sheet contains only (56 responses) 2- Variables are Y = (Age, Gender, Work years, Academic degree, Ques 1, and Ques 2) along with X (1,2,3,4,5) = (11 columns * 56 rows) 3- Further, a straightforward rule for variable X will be given. 4—Please mention the version of the Statistical Package for Social Sciences (SPSS) or other programs you used for analysis. 5- Validation of your results, Please. 6- ASAP Key tasks include: - Conducting robust statistical analysis - Interpreting patterns and trends - Providing comprehensive written findings and ...
Bookkeeper with excellent Quick Books knowledge is needed to maintain accounting and billing system, Responsibilities will include: *Invoice clients on a bi-weekly basis *Send reminders for past due invoices *Accounts receivable *Monthly bank reconciliation *Produce monthly reports including Profit and Loss, Balance Sheet , Cash Flows and open invoices Must have: *Strong attention to details *Excellent written and verbal communication skills *Excellent collaborative and teamwork skills *Excellent problem solving skills *Some availability during 9-5 to work with operations manager.
hi , i need someone to create facebook page with nice attractive stuff for forex trading instagram account i have just link them together do ads targeted ads to receive a lot of whatsapp messages through my audience
I'm searching for a skilled developer to automate my social media documents for Facebook and Instagram. This includes social media reports and social media post documents. This is the process I am looking for; 1. Scrape Trello, Ads Manager and Business Manager for metrics. 2. Put Metrics into a Google Sheet and process the data. 3. Put the data into a predesigned Google Docs/Slides template (editable) that can be saved as a PDF. Skills & Experience: - Proficient in API usage for Trello, Ads Manager, Business Manager and Google Suite - Proficiency in web scraping and data mining - Detailed knowledge of process automation - Knowledge of database management and integration - Experience in creating reporting tools I emphasize that I'm interested in quantitative data fro...
please see the sheet and what can be done for best reporting format using this data
In the continuity of the mission 'Finalization and uploading of a free 3D anatomy webviewer -- 3', the following functions would be added. 'Use arrows to go select within the proposition of the searchbar': -To work like any navigator only when a search is going on (keep rotation with arrows otherwise) 'Keep H/P shortcut and click things to hide': -Instead of onl...(with a dark version of the pictures in case of need). 'Add the bonus collections in the searchbar options' -Although they are not game objects, the user could see the bonus collection appear within the propositions of the searchbar, select them, and it would select the visible stucture belonging to this 'bonus collection'. See in the Unity project for the bonus collections as ...
I need assistance to convert an Excel file into the RES2DINV software for the purpose of visualizing and interpreting my data. The Excel file's content type isn't specified but it may contain geophysical measurements, soil resistivity, or survey data. This turnaround for this task needs to be as soon as possible. Ideal skills and experience: - Proficiency in utilizing RES2DINV software - Strong understanding of geophysical data interpretation - Experience in data conversion from Excel to RES2DINV - Ability to work on tight timelines.
I am in need of an Excel expert who can create a formula that will allow for real-time updating across multiple sheets. This formula should automatically transfer all inputs from sheet one to both sheet 2 and sheet 3. Key requirements: - Expertise in Excel and formula creation - Experience with real-time data updating in Excel - Ability to automate data transfer across multiple sheets The assignments from sheet 1 should appear as the words written and not "assignment" in the weekly and monthly calendars.
I'm in need of an expert web scraping developer who can extract textual data from specific Wikipedia pages. This should be a one-off task as there is no requirement for handling updates or changes to these particular pages. Key specifications: - Targeted content: Textual data - Pages to scrape: Specific, to be provided Ideal skill...one-off task as there is no requirement for handling updates or changes to these particular pages. Key specifications: - Targeted content: Textual data - Pages to scrape: Specific, to be provided Ideal skills and experience: - Proven expertise in web scraping - Previous experience with Wikipedia or similar tasks preferred - Ability to deliver accurate data in a structured format such as CSV, Excel, etc. Please avoid any unnecessary or redunda...
I am in need of a personal assistant to professionally handle phone calls, answer emails, and meticulously track rental payments and expenses for 6-10 rental propertie...some responsibilities of a bookkeeper; hence, an understanding of and experience in basic to intermediate accounting is highly preferred. Key duties will involve: - Efficient management of rental properties - Timely tracking and recording of rental payments - Accurate accounting of expenses - Handling telephone and email communications A candidate with skills and experience in these areas will excel at this role: - Bookkeeping - Accounting (Intermediate level) - Property Management - Communication. For my peace of mind and the smooth operation of the rental properties, a meticulous, detail-oriented individual ...
I need someone to do ads for me, i am creating forex signals group and i need to do tiktok ads and instagram ads. need to boost it, need someone to explain what we offer in a video, and keep updating it on a daily basis + need good ads strategy to get lots of clients
I'm looking for an Excel expert who can modify the pricing formula and user interface of my existing price calculator. It is a very basic lookup, with quite rudimentary discounts that need to be applied, and we have a working example to share which you can backsolve how to build/update as needed. Here are the specifics: 1. Update the lookup to a new pricebook tab (Both current, working example, and new example with the new price book will be shared) 2. Introduce new add-ons tick list on the calculator (basic calculations (percentage of total, and fixed price) 3. Build out a visual display of a basic discount matrix (10%, 20% etc - this will be supplied) $. User Interface Improvement: - The updated calculator should still be user-friendly and intuiti...
I'm in the market to have a unique calculator with a quote feature integrated into my WordPress website, mirroring the functionality of my competitor's site. My firm operates in the financial services sector, so the design should reflect this and blend seamlessly with my website's current theme. Key Features: • Basic & Advanced Mathematical Operations: The calculator should perform basic functions and also support complex operations. • Customizable Themes & Skins: Variety is key to standing out! I want different themes and skins to choose from and adapt to my website’s aesthetic. Ideal Skills: The ideal developer will have - • Proven experience with WordPress website development. • Proficiency in PHP and JavaScript for c...
I am seeking an expert in Excel to conduct comprehensive analysis on collected customer feedback, aiming to evaluate customer satisfaction. The raw data is currently stored in Excel spreadsheets and it essentially contains the comments and feedback from our customers. Key Responsibilities: - Deeply analyze the comments and feedback - Identify patterns, trends and vital points from the feedback - Importantly, provide a detailed report on these findings to aid further business decisions Ideal candidate must have: - Proficiency in Excel data analysis tools - Past experience in feedback analysis - Understanding of consumer behavior - Excellent reporting skills.
...new clips are created to give the channel a distinctive visual brand identity. - Collaborating with our team to ensure the final edited videos meet our expectations and objectives. - Creating Reels/Short content from existing footage to be posted on social media to drive traffic to the YouTube channel. - Re-uploading of the edited videos following instructions given on a collaborative Google Sheet. Qualifications: - Demonstrated experience in video editing and production, with proficiency in adding cutaways and B-roll clips to enhance storytelling. - Strong creative skills to convey effectively our key messages and ensure strong visual brand identity. - Attention to detail and a commitment to producing high-quality professional-looking new content. - Ability to work collabor...
