Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenMon, 23 Apr 2018 20:34:53 +0200Sum values by date numberhttps://ask.libreoffice.org/en/question/152753/sum-values-by-date-number/ I have some financial data I'd like to process and graph. I have the transaction dates formatted as numbers, such that the first day in Quarter 2 is '1' and the last day will be '91'. The values for the transactions are in adjacent columns, and there are multiple accounts with databases formatted as such on the same sheet.
I have for each account a running balance, such that there are multiple values for the balance of the account in a day if multiple transactions occurred. I have learned how to graph these running balances, but I am having difficulty creating a formula using functions to create the most important curve in my graph, which is Net Worth (Acc. 1 + Acc. 2 - Acc. 3... and so on).
How do I create a function to render the data for graphing Net Worth?
![image description](/upfiles/15241914605498097.jpg)
Here is an illustration of my planned graph, the entire purpose of the spreadsheets.
I could easily do it on paper, but that is wasteful and time-consuming to manually calculate and sum all of the values, and then plot them on paper of digitize the values and plot it with Calc thereafter.
In the end, when a TODAY function is called, I want it to check if a an earned, but unpaid/unreceived asset should have liquidated (pay-day) and to see if an unearned, scheduled, potential asset (a future workday) has passed (becoming a virtual or gaseous asset, rather than a nebulous one in my terms).
This will allow me to see the sum total of my finances at a glance, historically and in the near future for the purposes of large bill payments and savings deposits, as well as make projections for when I can expect larger lump sums if my budget is followed and discretionary expenses eliminated.
Any help is appreciated,
Thanks in advance!Fri, 20 Apr 2018 04:38:38 +0200https://ask.libreoffice.org/en/question/152753/sum-values-by-date-number/Comment by Cyberxine for <p>I have some financial data I'd like to process and graph. I have the transaction dates formatted as numbers, such that the first day in Quarter 2 is '1' and the last day will be '91'. The values for the transactions are in adjacent columns, and there are multiple accounts with databases formatted as such on the same sheet.</p>
<p>I have for each account a running balance, such that there are multiple values for the balance of the account in a day if multiple transactions occurred. I have learned how to graph these running balances, but I am having difficulty creating a formula using functions to create the most important curve in my graph, which is Net Worth (Acc. 1 + Acc. 2 - Acc. 3... and so on).</p>
<p>How do I create a function to render the data for graphing Net Worth?</p>
<p><img alt="image description" src="/upfiles/15241914605498097.jpg"></p>
<p>Here is an illustration of my planned graph, the entire purpose of the spreadsheets.</p>
<p>I could easily do it on paper, but that is wasteful and time-consuming to manually calculate and sum all of the values, and then plot them on paper of digitize the values and plot it with Calc thereafter.</p>
<p>In the end, when a TODAY function is called, I want it to check if a an earned, but unpaid/unreceived asset should have liquidated (pay-day) and to see if an unearned, scheduled, potential asset (a future workday) has passed (becoming a virtual or gaseous asset, rather than a nebulous one in my terms).</p>
<p>This will allow me to see the sum total of my finances at a glance, historically and in the near future for the purposes of large bill payments and savings deposits, as well as make projections for when I can expect larger lump sums if my budget is followed and discretionary expenses eliminated.</p>
<p>Any help is appreciated,
Thanks in advance!</p>
https://ask.libreoffice.org/en/question/152753/sum-values-by-date-number/?comment=152980#post-id-152980Does anyone know how I can generate the list of values needed for the Net Worth line? Even if I must use end-of-day numbers, without the transactions and balances throughout a day, that is fine.Mon, 23 Apr 2018 04:35:48 +0200https://ask.libreoffice.org/en/question/152753/sum-values-by-date-number/?comment=152980#post-id-152980Comment by Lupp for <p>I have some financial data I'd like to process and graph. I have the transaction dates formatted as numbers, such that the first day in Quarter 2 is '1' and the last day will be '91'. The values for the transactions are in adjacent columns, and there are multiple accounts with databases formatted as such on the same sheet.</p>
<p>I have for each account a running balance, such that there are multiple values for the balance of the account in a day if multiple transactions occurred. I have learned how to graph these running balances, but I am having difficulty creating a formula using functions to create the most important curve in my graph, which is Net Worth (Acc. 1 + Acc. 2 - Acc. 3... and so on).</p>
<p>How do I create a function to render the data for graphing Net Worth?</p>
<p><img alt="image description" src="/upfiles/15241914605498097.jpg"></p>
<p>Here is an illustration of my planned graph, the entire purpose of the spreadsheets.</p>
<p>I could easily do it on paper, but that is wasteful and time-consuming to manually calculate and sum all of the values, and then plot them on paper of digitize the values and plot it with Calc thereafter.</p>
<p>In the end, when a TODAY function is called, I want it to check if a an earned, but unpaid/unreceived asset should have liquidated (pay-day) and to see if an unearned, scheduled, potential asset (a future workday) has passed (becoming a virtual or gaseous asset, rather than a nebulous one in my terms).</p>
<p>This will allow me to see the sum total of my finances at a glance, historically and in the near future for the purposes of large bill payments and savings deposits, as well as make projections for when I can expect larger lump sums if my budget is followed and discretionary expenses eliminated.</p>
<p>Any help is appreciated,
Thanks in advance!</p>
https://ask.libreoffice.org/en/question/152753/sum-values-by-date-number/?comment=152765#post-id-152765How to represent dates by numbers is standardised. TODAY() and NOW() comply with the standard. Apply standards first.Fri, 20 Apr 2018 10:22:57 +0200https://ask.libreoffice.org/en/question/152753/sum-values-by-date-number/?comment=152765#post-id-152765Comment by Cyberxine for <p>I have some financial data I'd like to process and graph. I have the transaction dates formatted as numbers, such that the first day in Quarter 2 is '1' and the last day will be '91'. The values for the transactions are in adjacent columns, and there are multiple accounts with databases formatted as such on the same sheet.</p>
<p>I have for each account a running balance, such that there are multiple values for the balance of the account in a day if multiple transactions occurred. I have learned how to graph these running balances, but I am having difficulty creating a formula using functions to create the most important curve in my graph, which is Net Worth (Acc. 1 + Acc. 2 - Acc. 3... and so on).</p>
<p>How do I create a function to render the data for graphing Net Worth?</p>
<p><img alt="image description" src="/upfiles/15241914605498097.jpg"></p>
<p>Here is an illustration of my planned graph, the entire purpose of the spreadsheets.</p>
<p>I could easily do it on paper, but that is wasteful and time-consuming to manually calculate and sum all of the values, and then plot them on paper of digitize the values and plot it with Calc thereafter.</p>
<p>In the end, when a TODAY function is called, I want it to check if a an earned, but unpaid/unreceived asset should have liquidated (pay-day) and to see if an unearned, scheduled, potential asset (a future workday) has passed (becoming a virtual or gaseous asset, rather than a nebulous one in my terms).</p>
<p>This will allow me to see the sum total of my finances at a glance, historically and in the near future for the purposes of large bill payments and savings deposits, as well as make projections for when I can expect larger lump sums if my budget is followed and discretionary expenses eliminated.</p>
<p>Any help is appreciated,
Thanks in advance!</p>
https://ask.libreoffice.org/en/question/152753/sum-values-by-date-number/?comment=152803#post-id-152803Thanks, I'll reformat the dates to conform with those functions so they can be implemented later.Fri, 20 Apr 2018 18:36:32 +0200https://ask.libreoffice.org/en/question/152753/sum-values-by-date-number/?comment=152803#post-id-152803Comment by Lupp for <p>I have some financial data I'd like to process and graph. I have the transaction dates formatted as numbers, such that the first day in Quarter 2 is '1' and the last day will be '91'. The values for the transactions are in adjacent columns, and there are multiple accounts with databases formatted as such on the same sheet.</p>
<p>I have for each account a running balance, such that there are multiple values for the balance of the account in a day if multiple transactions occurred. I have learned how to graph these running balances, but I am having difficulty creating a formula using functions to create the most important curve in my graph, which is Net Worth (Acc. 1 + Acc. 2 - Acc. 3... and so on).</p>
<p>How do I create a function to render the data for graphing Net Worth?</p>
<p><img alt="image description" src="/upfiles/15241914605498097.jpg"></p>
<p>Here is an illustration of my planned graph, the entire purpose of the spreadsheets.</p>
<p>I could easily do it on paper, but that is wasteful and time-consuming to manually calculate and sum all of the values, and then plot them on paper of digitize the values and plot it with Calc thereafter.</p>
<p>In the end, when a TODAY function is called, I want it to check if a an earned, but unpaid/unreceived asset should have liquidated (pay-day) and to see if an unearned, scheduled, potential asset (a future workday) has passed (becoming a virtual or gaseous asset, rather than a nebulous one in my terms).</p>
<p>This will allow me to see the sum total of my finances at a glance, historically and in the near future for the purposes of large bill payments and savings deposits, as well as make projections for when I can expect larger lump sums if my budget is followed and discretionary expenses eliminated.</p>
<p>Any help is appreciated,
Thanks in advance!</p>
https://ask.libreoffice.org/en/question/152753/sum-values-by-date-number/?comment=152996#post-id-152996I made an attempt to suggest a solution, but I simply did not understand the question sufficiently.
What are "...multiple accounts with databases formatted as such on the same sheet."?
In what way should the "Net Worth" be determined?
How would you treat "...such that there are multiple values for the balance of the account in a day..."?
I'm afraid you will need another gambler understanding your intentions, and at the same time capable of designing a solution.Mon, 23 Apr 2018 12:30:31 +0200https://ask.libreoffice.org/en/question/152753/sum-values-by-date-number/?comment=152996#post-id-152996Comment by Cyberxine for <p>I have some financial data I'd like to process and graph. I have the transaction dates formatted as numbers, such that the first day in Quarter 2 is '1' and the last day will be '91'. The values for the transactions are in adjacent columns, and there are multiple accounts with databases formatted as such on the same sheet.</p>
<p>I have for each account a running balance, such that there are multiple values for the balance of the account in a day if multiple transactions occurred. I have learned how to graph these running balances, but I am having difficulty creating a formula using functions to create the most important curve in my graph, which is Net Worth (Acc. 1 + Acc. 2 - Acc. 3... and so on).</p>
<p>How do I create a function to render the data for graphing Net Worth?</p>
<p><img alt="image description" src="/upfiles/15241914605498097.jpg"></p>
<p>Here is an illustration of my planned graph, the entire purpose of the spreadsheets.</p>
<p>I could easily do it on paper, but that is wasteful and time-consuming to manually calculate and sum all of the values, and then plot them on paper of digitize the values and plot it with Calc thereafter.</p>
<p>In the end, when a TODAY function is called, I want it to check if a an earned, but unpaid/unreceived asset should have liquidated (pay-day) and to see if an unearned, scheduled, potential asset (a future workday) has passed (becoming a virtual or gaseous asset, rather than a nebulous one in my terms).</p>
<p>This will allow me to see the sum total of my finances at a glance, historically and in the near future for the purposes of large bill payments and savings deposits, as well as make projections for when I can expect larger lump sums if my budget is followed and discretionary expenses eliminated.</p>
<p>Any help is appreciated,
Thanks in advance!</p>
https://ask.libreoffice.org/en/question/152753/sum-values-by-date-number/?comment=153027#post-id-153027I'll provide some more information tomorrow when I have time. I'll include sanitized data and screenshots so commenters can understand my intentions better.
Thanks for attempting a solution.Mon, 23 Apr 2018 19:33:27 +0200https://ask.libreoffice.org/en/question/152753/sum-values-by-date-number/?comment=153027#post-id-153027Comment by Lupp for <p>I have some financial data I'd like to process and graph. I have the transaction dates formatted as numbers, such that the first day in Quarter 2 is '1' and the last day will be '91'. The values for the transactions are in adjacent columns, and there are multiple accounts with databases formatted as such on the same sheet.</p>
<p>I have for each account a running balance, such that there are multiple values for the balance of the account in a day if multiple transactions occurred. I have learned how to graph these running balances, but I am having difficulty creating a formula using functions to create the most important curve in my graph, which is Net Worth (Acc. 1 + Acc. 2 - Acc. 3... and so on).</p>
<p>How do I create a function to render the data for graphing Net Worth?</p>
<p><img alt="image description" src="/upfiles/15241914605498097.jpg"></p>
<p>Here is an illustration of my planned graph, the entire purpose of the spreadsheets.</p>
<p>I could easily do it on paper, but that is wasteful and time-consuming to manually calculate and sum all of the values, and then plot them on paper of digitize the values and plot it with Calc thereafter.</p>
<p>In the end, when a TODAY function is called, I want it to check if a an earned, but unpaid/unreceived asset should have liquidated (pay-day) and to see if an unearned, scheduled, potential asset (a future workday) has passed (becoming a virtual or gaseous asset, rather than a nebulous one in my terms).</p>
<p>This will allow me to see the sum total of my finances at a glance, historically and in the near future for the purposes of large bill payments and savings deposits, as well as make projections for when I can expect larger lump sums if my budget is followed and discretionary expenses eliminated.</p>
<p>Any help is appreciated,
Thanks in advance!</p>
https://ask.libreoffice.org/en/question/152753/sum-values-by-date-number/?comment=153031#post-id-153031Please provide
-1- clear explanations
-2- real spreadsheets containinjg examples
-3- screenshots **only** if there is a specific question about the rendering, the view, or about prints.
I cannot work on such things in an exclusively abstract way, and to create real examples based on screenshots is an excessive waste of time.Mon, 23 Apr 2018 20:34:53 +0200https://ask.libreoffice.org/en/question/152753/sum-values-by-date-number/?comment=153031#post-id-153031