I use google sheet tables in which I fill in multiple "databases". I use data from databases to structure them with a google sheet and use them for reports. The existing formula I use to get my data out is: = if ($ B $ 1 = "Payment"; query (D! $ A $ 2: $ T; "select I, A, D, K, L where C = '" & $ A $ 1 & "'and B =' Output invoice 'order by'" & $ F $ 1 & "'"; 0); query (D! $ A $ 2: $ T; "select I, A, D, K, L where C = '"& $ A $ 1 &"' and (B = 'Construction site - situation / invoice' or B = 'Invoice' or B = 'Offer / proforma invoice') order by '"& $ F $ 1 &"' "; 0)).
it needs to be refined to automatically summarize projects by summing up an individual project and providing data according to a formula. An example is in the task file. Eg. it is necessary to summarize the "Daruvarske toplice" project and the "Lipik specijalna bolnica" project. Picture "tablica e" is current state, and picture "tablica e new" is future state. Formula must be in quary form as current.
Hi there,
You want to have the Query formula modified? You need a new group "New Project" and the sum of each groups added in the Query formula?
Please message me if this is any of what you need. I'll be standing by to help.
-Ige
Hi, Greetings! ✅checked your project details.
I can build google sheet query.
I Have 4 years of experience with Data entry, Data analysis, and MIS Management.
I have Power BI and Excel/google sheet skills and am able to provide solutions to most Excel/google sheet problems, including VBA programming.
If you work with me you will get good value for your money and a flexible approach to carrying out your work. I am great with deadlines and I will keep you updated throughout the process and the quality of my work is high.
Please Ping me the chat box for further discussion
Thank You
Hi,
I am ready to start right now.
I can help you with your project according to your requirements. I am interested in your project.
I ensure I will complete the task successfully and within the specified time.
I love the perfection of work. You can see an example of one of those project in my portfolio here: https://www.freelancer.com/u/Monirulop
If you are interested to work with me message me, waiting for your message.
Thanks! and be safe,
Monirul
Hello,
I can help you with this project. From what I understand you want the query to show summaries of multiple projects. I'm pretty sure I can do this job for you. I have created many google sheet files and excel files both using formulas and scripts, so I'm the correct person for this job.
Let's talk more in detail, and if possible can you share the google sheet files, so I can analyze it further to ensure it is according to your needs.
Thanks and Kind Regards.
I'm a Data Analyst, Who can work on Excel with full knowledge and i'm a certified Microsoft Excel Expert which can help you in cutting down the project timing and i can help you with implementing easier technique to simplify it.
Hi there,
I am expert in Web search, Research, Market Research, Lead Generation, Web Scraping and Data Entry.
Lets have a quick chat on this project to clear further details.
I will deliver your project in time and there will not be delay in my work. I assure that you will like my work. I am here for long term work relationship so will give 101% best output from my end so that you consider me for future projects also.
Hello,
I have fully understood your requirement and went into details of your input and required output file.
I have several years of experience in working with excel and am a established programmer.
I am new to freelancer and will really want to start my journey by providing you high quality and error free user friendly work,
Thanks and hope to work with you on the project.
Hello dear client,
Thanks for posting the job. I went through your job carefully and wish to inform you that I'm very much glad to accept this job which matches with my potential.
Please find below my skills and standard of the expected service....
●Undergraduate UGC of Sri Lanka
●Years of IT related experience
●High quality servise guaranteed
●Charging very reasonable rates for you jobs
●Extra fast delivers
●Consistent work long hours for urgent jobs
●24×7 availability
●Client will be updated throughout the job done
●Make your right choose and get your job done with the expertise professional.....
Cheers
♡♡♡♡
Menik
WhatsApp
+94715685575