Help with Google tables (possibly via macros)
The situation. On a constant basis from the program 1c, the number of formats is inserted into the table.
44 543 809,52
Accordingly, when you make an elementary formula (This number is any other normal number), there is a error Function MINUS parameter 2 expects number values.
This occurs because there are gap in the number and it is a point instead of a back.
The option with the use of "find and replace" disappears because every time it is extremely uncomfortable to do it. You can write a macro under this action. Or any other option.
I look forward to your bets.
Client's review of cooperation with Ihor L.
Help with Google tables (possibly via macros)I liked the slogan of the game - you can solve any task. I decided right, thank you.
Freelancer's review of cooperation with Vadim Struzhihin
Help with Google tables (possibly via macros)Everything is great. Call me again!!The !
-
421 13 0 Hello to you!
I work with Excel and Google tables.
Ready to help with the formula or macro (scripts).
I will be happy to cooperate.
Current freelance projects in the category Databases & SQL
CRM system for Railway LogisticsCreation of a CRM system for a logistics company mainly focused on rail and road transport, 1) Financial reporting 2) Processing applications 3) Contractors 4) Automatic issuance of invoices and acts upon closure, it is possible to create a simplified system based on 1C below… Databases & SQL, Client Management & CRM ∙ 7 hours 47 minutes back ∙ 25 proposals |
Eliminate the issue of incomplete data import from Excel files of Nova Poshta specifications into 1C:
45 USD
Goal: There is a processing in 1C for uploading the specifications of Nova Poshta. For unclear reasons, it has stopped loading some tabular data. We need to find the reason and eliminate the problem of incomplete data import from Excel files of Nova Poshta specifications into… System & Network Administration, Databases & SQL ∙ 3 days 2 hours back ∙ 16 proposals |
Accounting, planning, and sales system for a mushroom farm
601 USD
Here is the complete, final text of the Technical Assignment (TA). It combines all your requirements: 16 chambers, 20 contractors, a schedule by days, accounting for containers, profitability calculation, and a mandatory division into three grades of mushrooms. You can fully… Databases & SQL, Client Management & CRM ∙ 5 days 6 hours back ∙ 56 proposals |
External report 1C 8.3 — forecast of goods balances
22 USD
An external report (.erf) is needed for 1C:Enterprise 8.3 (configuration to be specified). What it should do: Extract product balances from the database Analyze sales history for the last 30 days Calculate the average sales rate for each product Determine how many days until the… Databases & SQL, Client Management & CRM ∙ 5 days 7 hours back ∙ 13 proposals |
Web Application & Database Security Audit for Custom CRM — BaaS / Database-as-API Specialist (PenetrProject Overview We operate a custom-built customer relationship management (CRM) platform that runs two service businesses on a single system. It is a modern JavaScript web application backed by a backend-as-a-service (BaaS) database and deployed on a serverless hosting… Databases & SQL, Testing & QA ∙ 5 days 19 hours back ∙ 10 proposals |