Increment column macro jobs
...cleaner, more professional look with improved user-friendliness. The primary focus is on making the UI responsive and ensuring seamless API integration for enhanced user experience. Scope of Work: Frontend UI Enhancement: Improve the design of List page with a datatable layout, including features such as Search Sorting Filters Grouping Show/hide columns Column Adjustment Horizontal, Vertical Scroll Create Sub Task from List view Column wise field edit Task reordering Task & Sub Task Expand collapse function Multiselect option Enhance the detail page design with inline edit functions Responsiveness: Ensure that the frontend UI is responsive across various devices and screen sizes for optimal user experience. API Integration: Integrate APIs seamlessly into the f...
I need an expert to create a system where a rest hours sheet is integrated with a database within the same workbook in Microsoft Excel. Key requirements: - The integration should be made using VBA Macro or simple cell reference. - The database should store information about individuals, leaving out any date, hour or minute details. - The database requires no regular updates triggered by specific events. Ideal skills and experience: - Proficiency in Microsoft Excel - Experience in working with VBA Macros - Understanding of data management in Excel
I have a macro that has been put on my desktop from another computer and I need to get it uploaded to word
...functionalities do you need in your E-commerce website? Product listing and categorization, Need help configuring Lumise Plugin What platform do you want to build your E-commerce website on? WordPress We are looking for a freelancer to refine our Website through WordPress. We are using the Lumise plugin product designer and would like a couple of things fixed on the that page. 1. Remove the price column in the upper right corner 2. Add Clipart, Layouts, Backgrounds for designers to add to their product 3. Change/remove "Add to Cart" replace/add "Start Campaign" button Allow this to generate an email or order for us to verify we have all details needed then we will place it as a product to our product page. 4. Generate automated text with next step...
I am seeking assistance in crafting the design for a marathon T-shirt. The final product will be printed, primarily requiring placement and alignment of sponsor logos and names, with minimal graphic work involved. Key Project Details: - The T-shirt's color scheme will be a red shirt with white font. - Sponsors' logos and names should be arranged vertically and horizontally in a row and column format. - The font style for the sponsors' names should be Gotham regular. Ideal Skills and Experience: The work file has been created illustrator - Proficiency in graphic design software - Experience in T-shirt or apparel design is a plus - Ability to adhere to specified color schemes and font styles - Attention to detail is paramount, ensuring correct placement and alig...
I'm looking for a skilled JavaScript developer to create a function that can replace an existing Excel macro using Goalseek to calculate equipment rental fees. - Objective: The main goal of this task is to automate the calculation of the monthly rental fee for equipment. The JavaScript function you develop should be able to replace the existing Excel macro that uses Goalseek. - Data Handling: The function should be designed to receive input data manually from the user. This means that the function should be able to take in data directly from the user, process it, and return the calculated rental fee. - Complexity: The current formula used in the Excel macro for calculating the rental fee is moderately complex. It involves elements such as interest rates and amo...
Seeking a seasoned FullCalendar expert to execute some specific tweaks to the timegrid column in resource view. My requirements are as follows: - Modify column width , look at the picture . I need to custom the width of the column ( Any Tech ) to 40% and the rest -60% with divide evenly the total column left ( maybe 3,,5,8,...... ) fullcalendar plugin V3.1
I'm in need of a highly professional JavaScript and CSS expert to design and implement a data table with a broad range of functionalities. These include: - Sorting - Filtering - Pagination - Column resizing - Grouping - Column rearranging - Column hiding/showing Moreover, the table must also include extra features like dynamic totals calculation in the footer. Additionally, the data table should support dynamic cell data visualization. This feature should cover color coding, icon representation, and progress bars depending on the data type, which is to be detected when the data is assigned to the table element along with all the columns and their names. If the columns are resized, reordered, hidden or shown during runtime, these view details should be saved ...
...portal should accept XLSX files and validate them against having correct column headings in A, B and C. Key Features: - File Upload: The portal should be able to handle XLSX files for data upload. - Validation: The portal should check if the uploaded file has the correct column headers in A, B and C. If the spreadsheet fails this validation, it should provide an error message with guidance on how to correct the issue. - Accessibility: The portal should be accessible to anyone, without the need for user accounts. Ideal Skills: - Proficiency in web development with experience in building portals and handling file uploads. - Strong understanding of Excel file structures and the ability to programmatically validate column headers. - Knowledge of front-end de...
I need a reliable system that automates a process, doing a couple of specific tasks: 1. Reading specific data captured in Excel files. 2. Automatically sending texts via SMS when there's a data match in a particular column of the Excel file. This task will require programming skills, particularly with Excel and automation tools API. Experience with SMS gateway integration is a huge plus. You will be required to advise on appropriate SMS gateways if you have prior experience. The matching data column in the Excel file should be the trigger initiating the text sending automation. The target of this automation is to streamline and expedite our communication process, reducing manual effort involved in sending periodic SMS updates. If you have past experience automating...
Modify existing condition after button clicked. Add a column to the table to store upload and API
I need an expert in Excel macros to develop a tool for me that would allow me to automate some specific tasks as I work in Excel. Key Specifications: - The tool needs...allow me to delete specific columns based on the value in a particular cell. Ideal Skills: - Proficiency in Excel macros/VBA - Prior experience in customizing Excel files - Good communication to understand my needs and implement them accurately I have an excel sheet with production data, the file has extra data that i do not need, so i need Macros to delete certain columns, change column widths, change column names, wrap text if needed, add several text boxes that will appear on the output file if filled in, have print preset done as well. i will provide actual files and examples if you're interested ...
...format, Scale is 1/4 inch = 1 foot +++ 1. CREATE TWO (2) NEW Foundation Plan with STRUCTURAL CALCULATIONS plus Elevations (in relation to land contour/slope), Section and Roof Plan with STRUCTURAL CALCULATIONS for 2(TWO) Buildings :: EACH drawing should have a Comprehensive Details Page, for example Foundation Plan should show STRUCTURAL CALCULATIONS on the Foundation Details page which shows Column, Footing, Beam schedule :: Elevation Plan will NOT BE COMPLETE unless both building drawings show placement according to land slope/contour A. BUILDING A - 55' x 58' on a Steeply slope lot - SEE ATTACHMENT :: FLOOR PLAN IS COMPLETE but Window sizes not decided, once decided, modify on floor plan :: I will share youtube render video and we can decide window sizes togethe...
...comprehensive fitness sheets. These should contain detailed information in four key areas: 1. Exercise Descriptions: Detailed information about strength training exercises, including diagrams or images, written instructions, and any necessary safety advisories. 2. Diet Plans: Nutrition recommendations and daily diet plans tailored to support strength training. These may include recommended meals, macro or calorie counts, and advice on supplements if necessary. 3. Progress Trackers: A system for tracking training progress, such as weight lifts, cardio fitness levels, and body measurements. A visually appealing, easy-to-understand format is important. 4. Daily Macros/Calories Checks: A straightforward way for clients to track their calorie intake and macronutrient ratios, which...
I'm looking to enhance my Microsoft Excel skills, focusing on data analysis, pivot tables, and macros, to efficiently manage project construction data and create insightful reports. Key Responsibilities: - Advanced Data Analysis: Interpret project construction data effectively. - Pivot Tables Mastery: Create complex reports with dynamic pivot tables. - Macro Proficiency: Automate repetitive data analysis and report generation tasks, boosting efficiency. Ideal Skills: - Proven expertise in Excel, particularly in data analysis, pivot tables, and macros. - Experience with project construction data, financial data or similar. - Strong analytical and problem-solving abilities. - Excellent attention to detail to ensure high-quality, accurate reports. - Graphical representation whe...
I need an expert in Excel VBA to help automate complex, repetitive tasks within my large sets of Excel data. Key Responsibilities: - Developing a VBA script to automate repetitive tasks in Microsoft Excel - ...in Microsoft Excel - Implementing PivotTables, Macros, and other advanced functions - Ensuring the automation is efficient, reliable, and error-free Ideal skills for this project include: - Advanced knowledge of Microsoft Excel - Extensive experience in VBA scripting, particularly with automation of complex tasks - Proficiency in creating and working with PivotTables - Strong understanding of Macro creation and modification Please bid on this project if you have the necessary experience, skillset, and can ensure the automation meets the required standards of efficiency and...
...database tables for fresh development). we can use it MongoDB Designs minor works - on ( Website need Dynamic) (i). "Home Page ( Before and After Login), Category Page,CART." (ii). Need to create Vendor Page (same as Category Page with minor changes). (iii).Need to create Slide CART,Check out Page and Tracking Page,Invoice, Couries Invoice (same as Invoice with minor additional one column) Module Minor works on Design - (i).Registration - Adding "Eye Coloumn" to Password & Confirm Password (ii).Sign In - Adding "Eye Coloumn" to Password & Google Recaptcha (iii).Dashboard - Removing the existing User Top Layer and Adding Profile Image with Referral Link, Notification icon, Language dropdown icon. (iv). Order P...
Looking to rank keywords in 1st position of Google Search for the website Requirement: 1) Required High quality Do-follow backlinks from the law related websites. 2) Weekly and monthly backlinks and keywords ranking report required. 3) In the report 3 column must be added, 1) Trust Flow of backlinks, 2) Spam Score of backlinks and 3) backlinks are Do-follow or not. Note: Maximum Budgest is INR 2000/-.
...to the attached images but with the differences listed below. - Final design can commence after initial layout is provided, and approved. - Overall size is 48’x52’ - 24’x48’ center studio structure is to be heated space. - Clear span truss length is 24’ out to out of frame columns and to be a king post style. - Lean too on each side of barn is 14’ clear between barn wall and lean too posts. - Column spacing will be provided. - studio space is heated space is founded on existing concrete perimeter wall that sticks out of the ground 12 inches. - leantoo posts founded on sonotube / 24” cylindrical foundations that are 48” deep. - sil will have insulation foam break between soil and foundation. Treated sil plate will extend past found...
...conditions such as due dates and task status. Auto-Extension: Automatically add extensions to task deadlines when conditions are met, providing flexibility for users. Error Handling and Logging: Ensure robust handling of date parsing and add logging for tracking script execution and diagnosing issues Key Components Google Sheet Structure: The spreadsheet contains task-related data, including (Column Names): Task Name (fixed data coming from a third party form) Notes (fixed data coming from a third party form) Due Date ("Fixed Date coming in Text Format" from a third party form) 1st Extension (To be Activated & Input using script as per logic) 2nd Extension (To be Activated & Input using script as per logic) 3rd Extension (To be Activated & Input using scri...
I have given Start time, Interval, End time in excel When i give start time(Ex:9:15), when that time reached E col data automatically copied in into G col, Next Interval is 10 Mins, When 9:25 reached E col data automatically copied in into H col, When 9:35 reached E col data automatically copied in into I col,When 9:45 reached E col data automatically copied in into J col, When 9:55 reached E col data automatically copied in into K col, When 10:05 reached E col data automatically copied in into L col, When 10:15 reached E col data automatically copied in into M col.(H col vale > G col, that cell is green, H col vale < G col, that cell is red, same process for all col) 9:15-9:25 is 1 10Mins during that time, how many time(count) E col value>G col value( Ascending not decending) ...
I need a word document translated from English to Japanese as soon as possible. The file has 800 words. Need high quality human translation only. Google/AI or a...word document translated from English to Japanese as soon as possible. The file has 800 words. Need high quality human translation only. Google/AI or automatic software works are not allowed and will be rejected. Need the translation back in word document format maintaining the formatting and layout of the source file. I would also need an excel sheet prepared, with source texts in column A and translation column B. Need this to be done within 5-6 hours of awarding the project. Bid only if you are available to do it now. Price: 12 CAD fixed. Deadline: 5-6 hours max Don't bid if you don't agree the pri...
I need a word document translated from English to Turkish as soon as possible. The file has 800 words. Need high quality human translation only. Google/AI or aut...word document translated from English to Turkish as soon as possible. The file has 800 words. Need high quality human translation only. Google/AI or automatic software works are not allowed and will be rejected. Need the translation back in word document format maintaining the formatting and layout of the source file. I would also need an excel sheet prepared, with source texts in column A and translation column B. Need this to be done within 5-6 hours of awarding the project. Bid only if you are available to do it now. Price: 12 CAD fixed. Deadline: 5-6 hours max Don't bid if you don't agree the pri...
I need a word document translated from English to Spanish as soon as possible. The file has 800 words. Need high quality human translation only. Google/AI or aut...word document translated from English to Spanish as soon as possible. The file has 800 words. Need high quality human translation only. Google/AI or automatic software works are not allowed and will be rejected. Need the translation back in word document format maintaining the formatting and layout of the source file. I would also need an excel sheet prepared, with source texts in column A and translation column B. Need this to be done within 5-6 hours of awarding the project. Bid only if you are available to do it now. Price: 12 CAD fixed. Deadline: 5-6 hours max Don't bid if you don't agree the pri...
...candidate will be able to seamlessly navigate and offer insights on Marketing, Sales, and Operational strategies. Key Requirements: - A solid track record of success in business consulting, particularly in the areas of marketing, sales, and operations. - Strong understanding of strategic planning and tactical execution. - Ability to synthesize and present information effectively, with both a macro (general overview) and micro (detailed, step-by-step) view. - Proven experience in delivering high-quality, actionable insights that drive business growth. You should be comfortable offering a blend of strategic and tactical advice, as my needs will encompass both. Your role will be to provide guidance that is both broad-reaching and detailed, combining a strategic bird's-eye v...
I am looking for an Excel VBA script coder to assist me with a project for generating tags for e-commerce products from the description. Products are car spare parts. Need to tag the products with names of make, model, variant. Specific requirements: - - Generate tags for e-commerce products in a excel sheet. The product description is saved in Column A and the tags should be generated by referring to the list of available tags. Please see the excel sheet attached here. _ One product can have multiple tags associated with it from the tags list, The VBA script should run and generate tags while referring to the data in other sheets for tag names. Please see the excel sheet attached. Ideal skills and experience: - Proficiency in Excel VBA script coding - Strong understanding of dat...
...years old content writing service provider company with a team of 12 writers. We are looking for 4-5 reliable, responsible and full-time content writers to join our team. The rate will be INR 150 per 500 words, Also, if you are an outstanding writer then we can hire you as our permanent content writer and will provide you a fixed salary per Month. The increment will stop/decrease if you degrade the quality of the articles after the increment. Articles must be informative and interesting. You have to write at least 1000 words per day. Mention the word "Writer" in your bid proposal so that we know that you read the project. The articles must be 100% original and grammatically correct and without spelling mistakes. Must be free from plagiarism Must Pass Copyscape....
I am in the market for a professional freelancer who can create a Word to Outlook email template for my newsletter. This isn't a run-of-the-mill template; I'm looking for something that can replicate a multiple column layout as per a provided Word document. Skills and Experience Required: - Experience in creating email templates, particularly for Outlook - Familiarity with Word’s formatting and layout tools - Detail orientation and creative eye These are specific features of the newsletter: - The template should be fitted for news and updates. - It must accommodate a multi-column layout. If you have the expertise to deliver this project, showcasing a harmonised blend of functionality and aesthetic appeal, then I’d love to hear from you.
I need help populating an Excel sheet with 378 company websites. - The task involves searching the internet for the website of each company and entering it into the Excel sheet. - If a company doesn't have a website, please mark it as 'No Website'. - All URLs should be inserted in a new column in the existing Excel file. I would prefer the URLs to be in the format '' or ''. Ideal Skills: - Proficiency in Excel and web research. - Attention to detail to accurately populate the data. - Strong communication to flag issues or ask questions during the process.
...hours for each stage/ elapsed time. - Exclude Weekends (Friday & Saturday). - Sum up the total of elapsed times Do you have a solution that I can use the as tool either by creating excel Macro or Power BI, etc that I can use by uploading or copy paste exercise? Note // please I’m not looking for a one-time report or fixing the uploaded files Excell File attached 3 sheets (1- the exact report exported 2- report exported with expected results explained 3-Highlights) The ideal candidate should have a proven track record of working with similar projects, possess advanced skills in Power BI and Excel Macro, and be able to deliver a streamlined solution that not only automates the duration process but also can easily be understood and utilized by others....
I'm looking for a proficient Abaqus modeler to develop a model of a slender column based on specific design specifications provided in the job sheet. The task will involve: - Modeling a slender column using Abaqus - Incorporating specific material properties and geometry specifications - Applying boundary conditions for combined loads of axial load and bending moment Ideal skills for this job would include extensive experience in modeling structures with Abaqus, understanding of boundary conditions, and experience in analyzing structures under combined loads. Familiarity with structural dynamics will be a major plus.
I need a seasoned Excel Macro developer to help me create a macro to automate repetitive tasks and generate daily reports. Key Requirements: - The macro needs to be compatible with Excel 2016, as this is the primary version I'm working with. - I'll need to run the macro daily, so it has to be stable and reliable for consistent use.
I'm looking for an architect or drafter with substantial experience in trad...interior and exterior walls 4.2 The type of each room 4.3 Material specifications 4.4 Stairs and their direction 5. Elevation drawings 6. Section drawings 6.1 The insides of walls or floors 6.2 The foundation of the building 6.3 Beams 6.4 Columns 6.5 Lintels, or support structures above doors and windows 7. Detail drawings. 7.1 Door frames 7.2 Staircases 7.3 Material connections, such as where a 7.4 column meets the foundation 7.5 Cornices, or decorative features near the top of a wall 7.6Window frames 8. Mechanical and electrical drawings. 8.1 Load calculations 8.2 Switch locations 8.3 Wiring paths 8.4 Connections to outdoor power grid The land area is 1000 sqm while the construction area is almost ...
...including the creation of simple macros to automate certain repetitive tasks. Key Requirements: - Proficiency in Excel: I need an expert who is well-versed in Excel and can help me set up basic formulas for tasks like addition, subtraction, multiplication, and division. - Macro Creation: I'm looking for assistance in creating simple macros that will help automate some of the repetitive tasks in my worksheet. Ideal Skills: - Proficient in Excel: The freelancer should be comfortable with Excel's advanced features. - Experienced in Macro Creation: The ideal candidate should have experience in creating simple yet effective macros for automation in Excel. - Excellent attention to detail: Accuracy is crucial, so the freelancer must be detail-oriented to avoid errors ...
I'm looking for a freelancer who can create a simple, yet effective, VBA macro to combine a set of between 10 to 50 small CSV files. These files all share the same column headers, and the macro should merge the data in these CSVs while maintaining the column sequence as provided. This task is straightforward and should not take much time for an experienced freelancer. A successful completion of this task will certainly result in a 10-star rating from me. See the uploaded document that details what needs to be done. I will provide the coder that I choose with several sample small csv files to combine.
I am in need of a real-time Excel sheet where 135 workers across 9 different squads can sign up for their work days by selecting their 3 top choices for the week to work overtime. Last column should be used to pick one day OUT OF THE MONTH where they would like to NOT be used for overtime. Key features include: - The ability for workers to select their workdays from a calendar interface. - The sheet should be able to automatically update in real time if they all can access the excel sheet. The information for each worker to be captured in the sign-up sheet should include: - Worker's name (We will input that information) 15 slots - Top 3 choices to work overtime for their respective week (calendar is provided to go by) Ideal skills and experience: - Proficiency in Excel, sp...
I'm seeking an Excel Macro specialist to automate several repetitive tasks specific to engineering. The qualified individual needs to have: - Proven experience in creating efficient and complex macros - A solid grasp of engineering needs in relation to Excel functions - An ability to work with dense datasets and create tailored reports Tasks include, but are not limited to: - Automating repetitive engineering report creation - Streamlining data organization This project requires both expertise in Excel and understanding of engineering principles, hence any experience in the field can be a significant bonus. High efficiency and attention to details are of prime importance. Macro will need to be in word file and will change depending of the test - test A to J. Each r...
I'm in need of a skilled SQL developer to assist with the creation of 2 stored procedures in MySQL. These procedures are essential for managing calibration data in our system and compare new data with the calibra...StandardDeviation. These columns are critical for our system's calibration functionality. Score Table - This table will check the difference from new data to calibration data Ideal Candidate: - Proficient in MySQL and SQL programming - Experience in developing stored procedures - Strong understanding of database architecture and data management - Attention to detail to accurately implement the table's column structure This project is crucial for our system's functionality and data accuracy. A successful completion will result in a seamless calibrat...
I'm in need of a PHP developer who can create a MySQL database from a small CSV file with less than 1000 rows of data. The structure of the new database should replicate that of the CSV file. Rest assured, the file contains no sensitive information. Key skills needed...that of the CSV file. Rest assured, the file contains no sensitive information. Key skills needed for this job include PHP, SQL, and database design. The successful freelancer will have experience with both CSV file manipulation and MySQL database creation. Client uploads av csv file, then open a website, then, automatic creation of mysql database on a button click First row in csv file is the column names Table name should be the csv file name truncated to the last 16 numbers in the csv file. UTF-8 Varchar 255 ...
I'm in need of an experienced data entry professional with a keen eye for detail, Tasks that are part of the project are: - Collate 313 distinct spreadsheets of contacts into a unified spreadsheet. - Assign each original spreadsheet's name to a newly added column to keep track of the originating source. - Cleanse the data for consistency before merging them into the sole spreadsheet. The following data cleaning requirements are needed: - Splitting of the Full Name field into Forename and Surname fields - Creation of a new Column containing the original filename where this contact was. - Normalization of text-case. Proficiency in Excel or a similar spreadsheet software is highly necessary.
...a good library, but no longer supported and my team has no real ReactJS skills or time to learn. As such I'm in need of a proficient ReactJS Developer who can make some specific modifications to the library, including nice and automatic resizing of rows and columns based on the data contained, as well as handling dynamic resizing of column width by the user.. Your responsibility will primarily be: - Updating the Pivot grid library to include a column resizing feature - Updating to automatically wrap / detect content sizing between data cells and row cells - Ensuring compatibility with the latest version of ReactJS as we wish to keep our resources contemporarily adept. Your experience and skills should ideally include: - Proficiency with ReactJS development, ...
I am in urgent need of an expert Excel Macro developer who can generate a multidimensional tool for a restaurant setting. Key Responsibilities: - Design, build, and test a multifunctional Excel Macro that's compatible with Windows. - The macro should be able to generate sales reports, calculate inventory, and analyze customer data. Ideal Candidate: A successful candidate should have exceptional Excel Macro development skills, with an advanced understanding of restaurant operations. The candidate should be able to handle complex functionalities in Excel. This project is not suitable for beginners or intermediates; instead, an expert developer with proven experience in creating Excel Macros is required. Please provide evidence of similar past work when...
I'm looking for an experienced analyst proficient in R to conduct a thorough investigation on how macroeconomic variables affect house prices in India. We have some reference articles we want to use and replicate some of the results, in addition to adding something new. We have a dataset for the given variables ready and an R code that need adjustments in order to run properly and fix some bugs. Key Project Details: - **Scope:** Your task will involve examining the impact of the following macroeconomic variables on Indian house prices (HPI): GDP growth rate, CPI, Interest rates, FDI, and REER. - **Time Period:** The analysis should cover both short-term and long-term trends, typically an ARDL model. We also would like to separate out the Covid years in order to see these effects. ...
I'm looking for a detail-oriented Excel expert to help with data entry. Your main task will be to enter text and dates into an Excel spreadsheet. Key Requirements: - You'll be working on a single column in the spreadsheet. - There are 1500 entries in total. - Prior experience in Excel data entry is highly preferred. - Attention to detail and accuracy is a must. The data needs to be entered following a specific format or template. I'll provide you with this guidance. If you're a skilled Excel user who can work efficiently and accurately, I'd like to hear from you.
I have an Excel file where the preventive and corrective maintenance services of some equipment are r...equipment are registered. It is divided by team in Excel sheets, in the example there are 2 teams BU-001 and BU-002. By pressing the finish button at the top of the sheet, the macro must copy the existing data from the selected sheet to the BDD sheet table, and also delete the elements found in the BDD sheet table. sheet in progress (BU-001 in the example), in addition to setting the "MAN HOURS IN CURRENT MAINTENANCE" and "DAYS OUT OF SERVICE" fields to 0's. It is necessary that the macro works on the selected sheet, since the sheet will be duplicated to have one sheet per team, and when the sheet is duplicated, the macro does not lose func...
I need an Excel macro to move records between two sheets in the same workbook. Here's the challenging part: records should be relocated based upon logical condition within a certain range of values in designated columns. Time isn't a constraint but proficiency in scripting Excel macros and strong grasp of logical functions is mandatory. Clean and efficient code is valuable. Understanding of data management in Excel is also desirable. Patience needed to iterate and perfect the code. Please apply if you meet these criteria.
I have given Start time, Interval, End time in excel When i give start time(Ex:9:15), when that time reached E col data automatically copied in into G col, Next Interval is 10 Mins, When 9:25 reached E col data automatically copied in into H col, When 9:35 reached E col data automatically copied in into I col,When 9:45 reached E col data automatically copied in into J col, When 9:55 reached E col data automatically copied in into K col, When 10:05 reached E col data automatically copied in into L col, When 10:15 reached E col data automatically copied in into M col.(H col vale > G col, that cell is green, H col vale < G col, that cell is red, same process for all col) 9:15-9:25 is 1 10Mins during that time, how many time(count) E col value>G col value( Ascending not decending) ...
We are on the hunt for an Google App Script developer who can create and deploy one simple google sheet custom function. Utilizing your skills in scripting, your main task will be to develop a feature that enables an action when a user clicks on a cell within a specific column. To make this a success, you should: Task: "When ever user clicks on a cell in column C, for popup (yes/no) to show up, and if clicked on yes, for that cell to be populated with today's date. If clicked on no, not to perform this function for 15 seconds." Our estimated time for development is 10-15 min. + additional 5-10 min call to confirm deployment on machine, let us know what is your expert estimate.
...program should scan the option chain for ticker we set it up for, focusing particularly on contracts with the lowest number of days until expiration, including 0-day contracts. Identifies and Buys Call Options: The program will identify call options within this chain that have an "open column" value of $0.85 or less. Once identified, it will purchase one of these call contracts at the market price. Identifies and Buys Put Options: Similarly, the program will identify put options within the same criteria (open column value of $0.85 or less) and purchase one of these put contracts at market price. Sells Based on Unrealized P&L: After both the call and put contracts have been purchased, the program will continuously monitor the total positions. Once the unrea...
