If I enter the formula I get the correct value. I got this formula from calculater soup that does what I need. Just to give some insight into where I'm going with this: I'd like to use a spreadsheet as an analysis 'dashboard' where users could run analysis with different parameters - what would proximity around parks (grocery stores, etc.) be at 1/2 mi vs 1/4 mi.then another sheet in the spreadsheet would have a breakdown of the demographics within that proximity. I’d like to know if there’s a standard calc function that’ll give me the difference between two cells. you can color it red or anything you want or you can make its font large to view what is wrong. By sharing a spreadsheet, other users can easily add their data to the spreadsheet. Multiple users support - Encourage collaborative work on spreadsheets. If there was then a way to trigger the script from the spreadsheet by way of a button, that would be the next step (then the next step would be to have a map control inside the spreadsheet to see the updated results!) input to cell C1 'A1-B1' and then copy that formula in cell C1 and paste it below (C2, C3, C4, C5 and so on) and after that you can use the conditional formatting in each cell to know what is the valid values for each. Calc’s solver component allows solving optimization problems where the optimum value of a particular spreadsheet cell has to be calculated based on constraints provided in other cells. Can python read the value of a cell in a spreadsheet?įrom a mapping/GIS/analysis standpoint: the simplest example would be a script that ran a buffer (proximity) tool on a given shapefile (GIS dataset).įor the buffer distance parameter, instead of just using a number like '1000' feet, the script would point to a value in a cell of a spreadsheet (libre or open office preferred).