Create formulas in Google Sheets
You need help in developing a table for managing personal finance.
Input of expenses in the table A1:D10,
1) they must automatically move to the F1:I5 table.
2) also need to determine if I go within the budget for each category J1:L4 (Actual - the amount of expenditure for that category for that number, Budget - the planned amount for the whole month. Forecast is the amount, by the end of the month if you continue to spend at the same rate. For example, from 1 to 26 the number spent 260 ue, which means that the cost of the 30 number is likely to be "=260/26*30=300", you need to make an automatic calculation of the expenditure on yesterday's date and paint the color if "95%/95-105/105+").
-
3668 107 0 I make such a table both using the formula and using the automatically launched macro.
Look at the examples here:
HTTPS://freelancehunt.com/showcase/work/eksel-calkulyator/1400163.html
HTTPS://freelancehunt.com/showcase/work/eksel-calkulyator/1400166.html
Go to turn!
-
345 22 0 Hello to you. Ready to perform the task. Fast and quality. Go to turn. I will be happy to cooperate
-
1208 39 0 1 She counted the ration, carried out an automatic analysis of the indicators of the reproductive capacity of the CRS and pigs. Selection assessment (indices) using interconnected formulas in Excel, so I will check this task in an hour or two.
-
421 13 0 Welcome to!
I work with Excel and Google tables.
Ready to help with a formula or macro (scripts).
I will be happy to cooperate.
-
3621 113 7 1 Good day
I can do now.
There is experience, look at the reviews. Write in Personal
-
Алексей, добрый день.
Точно ли хотите в правую табличку переносить абсолютно все дни месяца? Там же получится в среднем 30 столбиков и пролистывать к интересующим нам данным актуальных затрат/бюджета будет не очень удобно.
Решения вижу два:
1) Перенести три крайние столбца в левую часть табл.2
2) Убрать часть с детализацией расходов по дням в табл2. Подсчётам это не помешает, а визуально будет более опрятно и удобно. -
Current freelance projects in the category Databases & SQL
Development of the web service "Interactive Veterinary Dental Map"Project essence: a web application where doctors can maintain interactive dental charts for patients (cats and dogs) The interface design and all jaw elements are already fully prepared in Figma (vector SVG with separation by individual teeth) Required functionality:… Databases & SQL, Web Programming ∙ 12 hours 18 minutes back ∙ 51 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 ∙ 14 hours 20 minutes back ∙ 13 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 ∙ 2 days 18 hours back ∙ 55 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 ∙ 2 days 18 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 ∙ 3 days 7 hours back ∙ 10 proposals |