Randomizing numbers with output in csv format.
There are initial numbers, for example:
ABC USA Inc
- Construction
Annual Sales - 123,465
Expenses:
Subcontracts - 321,756
Cost of materials - 22,228
Meals and entertainment - 1,391
Telephone - 3,745.xx
Advertising - 2,756
Professional fees - 1,340
Management - 59,875
Legal fees - 6,191
Equipment rental - 33,768
Real estate rental - 74,550
The output should be a .csv file with columns Date, Transaction Name, Deposit, Withdrawal, and the document name should be in this case ABC USA Inc (entered by the user).
The program should distribute the data as follows:
1. Categories Annual Sales, Subcontracts, Cost of materials, Equipment rental
- Amounts are randomized
- Distribute one transaction per month
- Transaction day in the month is always random and does not coincide with other categories
- In December, February, January, the amounts are 35-45% lower than the rest
- In total, all amounts equal the number specified by the user
- Amounts should differ by 1-10k where appropriate (i.e., December 9.21 and January 9.79 are not suitable, it should be figuratively 7.21 and 12.79)
2. Categories Telephone, Advertising, Management, Legal Fees, Real Estate Rental
- Amounts are clearly divided without randomization
- Distribute one transaction per month
- Transaction day in the month is always the SAME for one category and does not coincide with others
3. Category Meals and Entertainment
- Amounts are randomized
- Distribute one transaction per each working day of the year
- Slightly differ not just 20.72, 20.83, 20.32, but on some days 6.89, on some 8.32, on some 30
Additional information:
- In the Excel table itself, the number format is monetary, no 9.7999938291, only 9.79
- No indication of time in the Excel table, only date
Applications 1
-
3 days68 USD
4774 219 4 3 days68 USD
I will write an application for Windows.
The user launches the application, enters data into the form, and clicks OK.
Receives an excel/csv/txt file with specified logic.
The application is documented.
-
3 days68 USD
3356 70 1 3 days68 USD
Good day.
I will write a script for the tasks described in the project.
We can discuss in more detail.
-
3 days68 USD
2703 53 0 1 3 days68 USD
Extensive experience in developing similar programs.
I will be able to provide an accurate timeline and cost after discussing all the details.
-
3 days68 USD
497 29 1 1 3 days68 USD
Good day. Ready to do. Desktop application, language c#
-
1 day90 USD
562 14 0 1 1 day90 USD
I am ready to start. I will do it on the node js platform.
Where does the user enter this data?
Approximately 2 days are needed.
My working conditions are 1 day - $100.
Current freelance projects in the category Desktop Apps
Development of custom software (Android application + CMS) for SUNMI K2 self-service kiosks (Fast food)
23 USD
We are looking for an experienced team or a Middle/Senior Android developer (possibly with Full-stack skills) to create proprietary software for self-service kiosks for a fast food retail chain. Currently, our terminals operate on a ready-made cloud integrator, but we are… Content Management Systems, Desktop Apps ∙ 4 days 17 hours back ∙ 20 proposals |
It is necessary to migrate the current working program from FoxPro to C#.Hello everyone! We have a program in FoxPro (it has several modules, it's an accounting program), we have the source code of the program, and if necessary, we can consult with people who support the current program. What needs to be done: 1. Analyze how everything works,… C#, Desktop Apps ∙ 10 days 1 hour back ∙ 19 proposals |
About the Master Program "KONSTRUCTOR"
4182 USD
We are looking for a very experienced C++ developer to modernize existing software (master program). The program is responsible for creating derivative software representing audio-visual sessions of psychological correction. The current version is written in pure WinAPI (Visual… C & C++, Desktop Apps ∙ 12 days 14 hours back ∙ 20 proposals |
ODOO Enterprise setup for construction
Необхідно побудувати картки та налаштувати зручний імпорт, інтеграцію з ЕДО і загалом Workflow ODOO Компанія займається системною інтеграцією: маємо поставки обладнання В2В або з прямою маржинальністю, або з рібейтами в подальшому. Крім того, ведемо будівельні роботи на об'єктах… Enterprise Resource Planning (ERP), Desktop Apps ∙ 12 days 23 hours back ∙ 7 proposals |
Kharkiv