Good Evening!
I am doing a calculations template.
Calculation involves 2 values, FAT and Solid Non-FAT (SNF). Each FAT-SNF pair has an amount assigned to it. The values of FAT and SNF will be input from a Milk-Analyzer. Once the values of FAT and SNF are input into their respective textboxes, the amount corresponding to the FAT-SNF Pair needs to be displayed in another textbox and readied for calculation.
I have attached an for understanding the the amount estimation of each FAT-SNF pair.
I am trying to figure out two things:
1. How to import
The file attached so that the data can be accessed for FAT-SNF pairs like:
What I cannot understand is that, for example: Value in column A3 (FAT) can be paired with B3 to T3. So what editables should be created for importing and storing the FAT-SNF pairs? I had thought of having cloned pages for each pair, but for csv import I go ____________ (blank )
2. Once the data is available in Couch back-end I could use AJAX to query the data and update the amount field. Then I get caught in the vicious-circle of how to import (i.e. back to #1 above). Also, every time a query is fired, using AJAX, it will take time to return the value, leading to a slow system. So can we have the entire data of FAT-SNF pairs and their Amount readily accessible, for faster processing. (faster processing s needed because in a span of 4 hours an approx of 20,000 ltr of milk needs to be collected from 67 collection centers, as on date, but to increase by month end to 165 collection centers)
Another concern that is at hand is that collection centers are in remote locations (villages), where internet connectivity will be available only through mobile network with working speeds between EDGE and 3G. Hence also, I was wondering if data can be made available. Every time a form is filled and submitted the page reloads, but the data of FAT-SNF and Amount should remain intact. Data can be fetched every time the user logs in and purged when a user logs out. If the data changes it is only after the collection shift ends.
One more thing to mention there are different CSV's for Cow and Buffalo FAT-SNF pairs, around 600+ entries for each cattalo.
All possible inputs are appreciated.
Regards,
Aashish
I am doing a calculations template.
Calculation involves 2 values, FAT and Solid Non-FAT (SNF). Each FAT-SNF pair has an amount assigned to it. The values of FAT and SNF will be input from a Milk-Analyzer. Once the values of FAT and SNF are input into their respective textboxes, the amount corresponding to the FAT-SNF Pair needs to be displayed in another textbox and readied for calculation.
I have attached an for understanding the the amount estimation of each FAT-SNF pair.
I am trying to figure out two things:
1. How to import
The file attached so that the data can be accessed for FAT-SNF pairs like:
FAT - SNF = Amount
2.1 - 7.0 = 24.3
2.6 - 7.8 = 26.5
What I cannot understand is that, for example: Value in column A3 (FAT) can be paired with B3 to T3. So what editables should be created for importing and storing the FAT-SNF pairs? I had thought of having cloned pages for each pair, but for csv import I go ____________ (blank )
2. Once the data is available in Couch back-end I could use AJAX to query the data and update the amount field. Then I get caught in the vicious-circle of how to import (i.e. back to #1 above). Also, every time a query is fired, using AJAX, it will take time to return the value, leading to a slow system. So can we have the entire data of FAT-SNF pairs and their Amount readily accessible, for faster processing. (faster processing s needed because in a span of 4 hours an approx of 20,000 ltr of milk needs to be collected from 67 collection centers, as on date, but to increase by month end to 165 collection centers)
Another concern that is at hand is that collection centers are in remote locations (villages), where internet connectivity will be available only through mobile network with working speeds between EDGE and 3G. Hence also, I was wondering if data can be made available. Every time a form is filled and submitted the page reloads, but the data of FAT-SNF and Amount should remain intact. Data can be fetched every time the user logs in and purged when a user logs out. If the data changes it is only after the collection shift ends.
One more thing to mention there are different CSV's for Cow and Buffalo FAT-SNF pairs, around 600+ entries for each cattalo.
All possible inputs are appreciated.
Regards,
Aashish