Who can write me a special basic calc spreadsheet?

[Leotje]

Sirs,

I never used a spreadsheet like Exell, but for a new activity,
I would like to use a spreadsheet system like the libre office Calc system (or alike)

In my new concept there will be 1 or more ‘organisors’ per country,
who will find local ‘influencers’
‘influencers’ will find ‘clients’
‘clients’ may bring new extra ‘clients’

If I understood well the L.O. Calc system,
for each of these groups I would need 1 sheet.

As each sheet can contain more as a million rows (f.ex. clients)
we could add more as a million clients on 1 sheet
and per sheet max 1024 columns

• needed for information related to that client
  ( f. ex.name or address or the code of his Godfather in our system (maybe an influencer)
• • 1 extra column per month, to note the amounts
    that I receive per client in that month a.s.o.

An ‘organisor’ would have 20% on his ‘influencers’
an ‘influencer’ would have 20 % on the clients that he brought in.
aso.

I don’t need interconnnnectability between sheets.

BECAUSE I also visited some helpdesk sites of L.O. CALC
and I saw that almost all of the participants seem to be programmers,
And because I understand that a program like Calc has to
prescribe exactly how to enter coordinates in the rows and columns
(with the inherent limitations)
I am afraid that it not only might take me ‘years’ to acquire
the basic skills to use Calc,
but also afraid that the ultimate result might not be clear and simple to use.

What I like in Calc is that it offers a large number of columns
(specifications and results that I need)
and a huge number of rows (my clients) per sheet.

For these reasons, I wonder if you could connect me to a
programmer, who can prepare me a spreadsheet system,
‘adapted’ to my limited needs,

We only need to be able to enter :

• whatever text without limitations, letters and numbers as header (title) of a column

• whatever text without limitations in every cell a a row

• that we can enlarge or limit a row’s possible number of elements (letters, figures)

• simplicity of creating extra colums and new rows

Thanks
Leo

[JohnSUN]

Hello Leo, welcome!
It seems to me that you already understand quite well what data and in what quantity you will receive in the coming months. But judging by your description, you still do not know what you want to get from this data - now you only see the need to accumulate an avalanche of data and not lose anything at the same time.
I’m not ready to help you with this project. But I can give the first important advice - do not use spreadsheets for this task. Many, many have tried to use this tool and have failed in the end. Not because LibreOffice Calc is bad, just because it is designed to solve other problems. And databases are used to collect, store, edit and search for information. Don’t be scared, the term “databases” just sounds scary. In fact, it’s even a little easier than electronic tables, it’s just that they didn’t talk much about it.
Yes, you will need the help of someone who knows how to create and modify databases. But if you’re lucky, it will be easy and simple for those in all four (or more) countries to supply you with data who will use what he does.

[Leotje]

Hi Vladyslav,

Thanks a lot for your reply.

1 question for now

Can everyone read the answers and questions that I am writing here ?

[JohnSUN]

Yes, I think that everyone (and even those who are not registered here, but came from a link after searching the Internet). Of course, they will read and take part in the discussion if the topic seems interesting.
If you’re asking if you can privately discuss specific issues with someone here, then yes, you can: click on the nickname and select Message - this will allow you to send a private message to a specific user.

[Leotje]

Thanks a lot Vladyslav,

for your advize to use BASE for that project.

I think I can do that myself,
and start studying Base today.

Success to you in whatever your heart desires.

Leo

[JohnSUN]

@Leotje

and start studying Base today

Tell me, @Leotje , are you going to do it with a written manual? Something like this or this? Yes, this is a good, traditional way to learn. But it seems to me that seeing and hearing is better than reading. Try to watch this. I understand that a lot here depends on personal preference, but I should have mentioned it.