Hot answers tagged spreadsheet
Google Docs Upload your existing files. Google Docs accepts most popular file formats, including DOC, XLS, ODT, ODS, RTF, CSV, PPT, etc. So go ahead and upload your existing files. Familiar desktop feel makes editing a breeze. Just click the toolbar buttons to bold, underline, indent, change font or number format, change cell background color ...
Google Sheets allows you to protect specific cell ranges so only certain users can edit them.
Select ColumnJ. Data > Pivot table report..., Rows - Add field Tent#, Values - Add field Tent#. Click on down arrow next to "Summarise by: SUM" and select COUNT. Select the PT, Ctrl+c, got to K2(?) in your data sheet and Ctrl+v.
I've shared a sheet for you to play with here. There is a fourth sheet to help write the second solution The simple solution (with only numeric ids) is quite straightforward: =MAX(Sheet1!A2:A,Sheet2!A2:A, Sheet3!A2:A) (This assumes each column has a title) The situation with a prefix works like this: ="R" & MAX( ...
A Google-Docs spreadsheet treats dates as 1 for every day past Dec 31, 1899. Today happens to be 41,973. Time is always a decimal portion of the day. Today at noon is 41,973.5. If you have a time value (a decimal) you can turn an number with 1 representing an hour by multiplying by 24 (number of hours in a day. The formula in D2 is (<end ...
I have been building an online database application over Google App Engine for such use-cases. It is called iFreeTools Creator. Supports multiple data-types for fields including single-line text, multi-line text, numbers, images, geo-location and more. Forms and views are automatically generated for users based on their authorization profiles. Users ...
With the new Google Spreadsheet, you are able to add more than 256 columns. To test this, I added this formula in A1: =TRANSPOSE(REPT("A,", 367)) and continued with this formula in A2 =SPLIT(A1, ",") It will raise an error, telling you to add more columns (it will add 300 as a standard): Once added, the split result will expand and show all the data ...
So as I was saying... I couldn't find anything that would let me do this that didn't involve installing a full spreadsheet app so I created a simple CSV transposition tool on app engine: CSV Transposer Tool
As Gmail doesn't preserve formatting, your options may be to: Copy the file to Google Drive and reference that using the "Insert files using Drive" option Insert a screenshot of the relevant portion of the sheet within the email, if you're particular about formatting and the data isn't a lot
You might look at Docs.com, which is Microsoft's free online service. You won't have to do any kind of conversion with the existing spreadsheet documents.
Only top voted, non community-wiki answers of a minimum length are eligible