Input trail on data entry
A system may include reception, from a planning application, of a spreadsheet including a plurality of values, presentation of the plurality of values, reception of a first instruction to change a first value of the plurality of values to a second value, presentation, in response to the instruction, of a visual indication in association with the second value, the visual indication indicating that the second value is a fixed value, reception of a second instruction to refresh the spreadsheet, and in response to the second instruction, determination of one or more of the plurality of values of the spreadsheet, each of the determined one or more of the plurality of values presented in association with a visual indication indicating that the value is a fixed value, and transmission of the determined one or more of the plurality of values and a request to refresh the spreadsheet to the planning application.
1. A method implemented by a computing system in response to execution of program code by a processor of the computing system, the method comprising:
receiving, from a planning application, a spreadsheet including a plurality of values;
presenting the plurality of values;
receiving a first instruction to change a first value of the plurality of values to a second value;
in response to the first instruction, presenting a first visual indication in association with the second value, the first visual indication indicating that the second value will be fixed in a next recalculation of the spreadsheet;
receiving a second instruction to fix a third value of the first plurality of values in the next recalculation of the spreadsheet;
in response to the second instruction, presenting a second visual indication in association with the third value, the second visual indication indicating that the third value will be fixed in the next recalculation of the spreadsheet;
receiving a third instruction to refresh the spreadsheet; and
in response to the third instruction,
transmitting, to the planning application, a request to recalculate the spreadsheet with the second value and the third value being fixed.
2. A method according to claim 1 , further comprising:
receiving a fourth instruction to change a fourth value of the plurality of values to a fifth value;
in response to the fourth instruction, presenting a third visual indication indicating that the fifth value will be fixed in the next recalculation of the spreadsheet,
wherein the request comprises a request to recalculate the spreadsheet with the second value, the third value and the fifth value being fixed.
3. A method according to claim 2 , further comprising:
receiving, from the planning application and in response to the request, a second spreadsheet including a second plurality of values,
wherein the second plurality of values comprise the second value, the third value and the fifth value, and
wherein at least one of the second plurality of values is different from a respective one of the plurality of values.
4. A method according to claim 1 , further comprising:
receiving a fourth instruction to change a fourth value of the plurality of values to a fifth value;
in response to the fourth instruction, presenting a third visual indication indicating that the fifth value will be fixed in the next recalculation of the spreadsheet; and
receiving a fifth instruction to remove the third visual indication indicating that the fifth value will be fixed in the next recalculation of the spreadsheet,
wherein the request does not comprise a request to recalculate the spreadsheet with the fifth value being fixed.
5. A method according to claim 1 , further comprising:
receiving, from the planning application and in response to the request, a second spreadsheet including a second plurality of values,
wherein the second plurality of values comprise the second value and the third value, and
wherein at least one of the second plurality of values is different from a respective one of the plurality of values.
6. A non-transitory medium storing processor-executable program code, the program code executable by a device to:
receive, from a planning application, a spreadsheet including a plurality of values;
present the plurality of values;
receive a first instruction to change a first value of the plurality of values to a second value;
in response to the first instruction, present a first visual indication in association with the second value, the first visual indication indicating that the second value will be fixed in a next recalculation of the spreadsheet;
receive a second instruction to fix a third value of the plurality of values in the next recalculation of the spreadsheet;
in response to the second instruction, present a second visual indication in association with the third value, the second visual indication indicating that the third value will be fixed in the next recalculation of the spreadsheet;
receive a third instruction to refresh the spreadsheet; and
in response to the third instruction:
transmit, to the planning application, request to recalculate the spreadsheet with the second value and the third value being fixed.
7. A medium according to claim 6 , the program code further executable by a device to:
receive a fourth instruction to change a fourth value of the plurality of values to a fifth value; and
present, in response to the fourth instruction, a third visual indication indicating that the fifth value will be fixed in the next recalculation of the spreadsheet,
wherein the request comprises a request to recalculate the spreadsheet with the second value, the third value and the fifth value being fixed.
8. A medium according to claim 7 , the program code further executable by a device to:
receive, from the planning application and in response to the request, a second spreadsheet including a second plurality of values,
wherein the second plurality of values comprise the second value, the third value and the fifth value, and
wherein at least one of the second plurality of values is different from a respective one of the plurality of values.
9. A medium according to claim 6 , the program code further executable by a device to:
receive a fourth instruction to change a fourth value of the plurality of values to a fifth value;
present, in response to the fourth instruction, a third visual indication indicating that the fifth value will be fixed in the next recalculation of the spreadsheet; and
receive a fifth instruction to remove the third visual indication indicating that the fifth value will be fixed in the next recalculation of the spreadsheet,
wherein the request does not comprise a request to recalculate the spreadsheet with the fifth value being fixed .
10. A medium according to claim 6 , the program code further executable by a device to:
receive, from the planning application and in response to the request, a second spreadsheet including a second plurality of values,
wherein the second plurality of values comprise the second value and he third value, and
wherein at least one of the second plurality of values is different from a respective one of the plurality of values.
11. A system comprising:
a computing device comprising:
a memory storing processor-executable program code; and
a processor to execute the processor-executable program code in order to cause the computing device to:
receive, from a planning application, a spreadsheet including a plurality of values;
present the plurality of values;
receive a first instruction to change a first value of the plurality of values to a second value;
in response to the first instruction, present a first visual indication in association with the second value, the first visual indication indicating that the second value will be fixed in a next recalculation of the spreadsheet;
receive a second instruction to fix a third value of the plurality of values in the next recalculation of the spreadsheet;
in response to the second instruction, present a second visual indication in association with the third value, the second visual indication indicating that the third value will be fixed in the next recalculation of the spreadsheet;
receive a third instruction to refresh the spreadsheet; and
in response to the third instruction,
transmit, to the planning application, a request to recalculate the spreadsheet with the second value and the third value being fixed.
12. A system according to claim 11 , the processor to further execute the processor-executable program code in order to cause the computing device to:
receive a fourth instruction to change a fourth value of the plurality of values to a fifth value;
present, in response to the fourth instruction, a third visual indication indicating that the fifth value will be fixed in the next recalculation of the spreadsheet,
wherein the request comprises a request to recalculate the spreadsheet with the second value, the third value and the fifth value being fixed.
13. A system according to claim 12 , the processor to further execute the processor-executable program code in order to cause the computing device to:
receive, from the planning application and in response to the request, a second spreadsheet including a second plurality of values,
wherein the second plurality of values comprise the second value, the third value and the fifth value, and
wherein at least one of the second plurality of values is different from a respective one of the plurality of values.
14. A system according to claim 11 , the processor to further execute the processor-executable program code in order to cause the computing device to:
receive a fourth instruction to change a fourth value of the plurality of values to a fifth value;
present, in response to the fourth instruction, a third visual indication indicating that the fifth value will be fixed in the next recalculation of the spreadsheet; and
receive a fifth instruction to remove the third visual indication indicating that the fifth value will be fixed in the next recalculation of the spreadsheet,
wherein the request does not comprise a request to recalculate the spreadsheet with the fifth value being fixed.
15. A system according to claim 11 , the processor to further execute the processor-executable program code in order to cause the computing device to:
receive, from the planning application and in response to the request, a second spreadsheet including a second plurality of values,
wherein the second plurality of values comprise the second value and the third value, and
wherein at least one of the second plurality of values is different from a respective one of the plurality of values.