Spreadsheets

6K

Solutions

24

Articles & Videos

5K

Contributors

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.

Share tech news, updates, or what's on your mind.

Sign up to Post

hi,

I sometimes use google sheets as a simple database, and would like the option to edit in form view.

I expect a crude setup is possible using google scripts, but I have not yet delved into this as I'm new to google scripting.  I would like to get some tips on getting this up & running. There maybe a few steps involved in which case I'll post aside questions if needed.

Here is a template which I'll aim to get working so if successful this could be the answer:

short url: bit.do/googlesheetformedit
redirects to: https://docs.google.com/spreadsheets/d/1vyC3yaB1cKegdRHeXeNvgr8N06S7OzUw2EPnY3fEOVE

2 main stages:
1. generate the query output
2. create a trigger to edit source data when the column "value" is changed

There may already be a google app that does this.

Thanks
0
Free Tool: Path Explorer
LVL 8
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

I have a spreadsheet with data.  In column C I have sporting houses (Brown, Green, Blue, Red) and in column F I have the points.  I want to be able to have a running total of the points by house in four cells next to the data.  How would I do this?
0
I have already make a "XML Maps" Mapping list under the XML Sources.
It works file when I do the XML import to the Excel sheet.

However, I would like to add the file name of the XML which imported to the excel.
Can anyone help me on this?

Enclosed with the Excel sheet with the mapping list included
https://drive.google.com/open?id=0B-cvVcO00sRvVldicS1kWFhGSGs
0
Hey everyone,

Asked this question recently and got an answer that worked but I have a new problem that requires a new solution.

Example File Attached.

Basically the Attainment percentage will yield a % Payout Factor, not every value is listed in the attainment/payout factor chart so the formula has to produce a % Payout Factor that's aligned with the chart giving a result that makes sense when the Attainment doesn't appear directly on the chart.

Example, if Goal Attainment Chart has a 100% attainment which results in 100% payout factor, and 105% attainment that gives a 141.7% payout, if the employee achieves 101% attainment their payout factor should be between 100-141.7% but not just an average, it has to be closer to the 100%'s payout factor, maybe around 110%?

If anyone has a solution, it'd be greatly appreciated.

Thank you,

- Rick
Example.xlsx
0
When shipping our work week is considered Tuesday through Saturday due to packages moving via parcel which only deliver during these days.    We are attempting to calculate the number of days from release until the package is delivered to our customers so for an example:    The package left our site on 3/16/2017 and based upon notification from our parcel carrier it was delivered to our customer on 3/17/2017 which is 1 day.......BUT we have this situation where the package left our site on 3/17/2017 and it was delivered on 3/18/2017 but the calculated date was 0 days since Saturday was a "non work day" when using the networkdays option within Excel.       Is there a way that we can define, within a formula, a workweek of Tuesday through Saturday and if necessary exclude holidays?

Thank you
Rosemary
0
Hello Experts,

i have a three worksheet like (alpha,bravo,charlie) each worksheet i have chart and pivot data. i need to display all the chart in one worksheet (sheet name : all chart in one) by selecting the Drop Down list.

i want to animate the chart like when ever i want to run the chart start and stop button data of entire date of year .

i tried so much days but i am failure to solve this problems. Please help me it will be great appreciated!

please find the attachment and  you change your best idea to impress to display chart in better ways.

please if you want any other details regarding to this file i try to explain it more for your clarification. Thanks in advance.

other two excel sheet file has sample example of how i need to display the chart.
ALL-CHART-IN-ONE.xlsm
Graphic-animation--1-.xlsm
Expand-Chart-Selection.xlsb
0
I have an extract list of orders, with an "open date" a "closed date".  I need to show, during any given month, total $ in "open" orders.  Thinking a Pivot -- can also use Access query -- or Excel?  

Ideal output (looking for overall totals) would show me the following, as an example:

Order 1 - opened in Jan, closed in June -$50
Order 2 - opened in Jan, closed in Feb - $25
Order 3 - opened in Feb, closed in Apr - $100

So, monthly totals would look like this:
Jan = $75
Feb = $175
Mar & Apr = $150
May & June = $50
0
Right now the formula =SUM(SalesD!BJF10:BKI10) ... And I would like to copy the column below and it changes it to =SUM(SalesD!BJF11:BKI11) how can I do that automatically?  But right now when I drag and drop it just keeps it the same like this instead of what I want it to do.. =SUM(SalesD!BJF10:BKI10) which increases it to one more from 10 on ward.
0
I will be entering data, moving around a spreadsheet with the arrow keys.  Then the keyboard will go completely unresponsive.  I can change cells with the mouse, but still not enter any data.  This "spell" can only be broken by hitting one of the Enter keys, which pulls up a spreadsheet (none in particular) that had been minimized.  From there, i can go back to the previous spreadsheet and continue working as normal.  
I have not noticed any pattern to this.  There do not seem to be any favorite spreadsheets.
0
Just started a few weeks ago...while working in a spreadsheet, the program starts acting independently, moving from cell to cell...was I am typing formulas, half of the formula will be in the original call and the rest of it will be deposited in a random cell...it's like watching a video game...there is so much activity on the spreadsheet not being controlled by me...any suggestions?...I have run 2 full scans with Defender and they both came up clean...
0
Free Tool: Site Down Detector
LVL 8
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

I have an Excel (2013) table that contains a number of records which I need to generate a chart from and each record has its own date and time in the first column - easy enough.

In the cart the horizontal access represents the date / time from column one

When I create a line graph of the data all the records for one date are combined into a single entry on the horizontal access

I have checked in the series config for the chart and there are defiantly separate data points for the same date on the horizontal access.

The result is the graph is rather confusing since rather than just have a single point for each entry on the horizontal access (that will be joined to another series' data point by a horizontal line) one of these 'combined' dates shows a vertical line with the horizontal line connecting it to another series point projecting from somewhere on it's vertical length

I have never come across this before - how can I prevent the summation of data points ?
0
This is in reference to a previous question:
https://www.experts-exchange.com/questions/29009094/Opening-Multiple-IQY-Files-for-full-page-queries-saving-one-cell.html?notificationFollowed=186018718

What I would like to have happen is if I could run a macro, and it would delete everything except the specific data in a cell whose location changes. This cell contains the text "( Displaying ### of ### )" and I would like to automatically delete every cell in the workbook except this cell. The location of this cell varies from workbook to workbook, so I cannot simply use a named-cell macro. I have hundreds of excel documents in this format, and in the end, I need one excel document that has the searched cell data from each sheet compiled into one workbook.

The Workbooks follow an identical format. I'd need a script as mentioned above, to delete everything but the necessary data and then save the sheet, then a second script that would take every Excel file in a folder and turn it into one excel file, with the title of the excel file being in Column A, and then the data from the searched cell (which would now be the only cell in these workbooks) in Column B.
0
I had this question after viewing Win7 x64 Host + Winxp guest + DOS Application Full Screen mode?.

I admit to being a dinosaur that actually misses MS DOS 6.2 and loved Windows XP. The reason being that all my financial records are on Lotus 1-2-3 spreadsheets (dating to 1984) and I am not going to try a transition all of that to Excel.  Lotus 1-2-3 ran beautifully full screen on my old XP machine but with MS refusing to keep XP alive I have transitioned to Win 7. The Lotus program will run in the XP mode of Win 7 but the screen is about postage stamp size regardless of how the  Window options are configured in the shortcut.  VMware is a bit better by allowing me to get to a 10" X 6" 20 line screen that is readable but I am still looking for a real "full screen" option.

"Aciddo" indicated that DOS programs ran full screen in Ver 7 of workstation after tweaking the options feature but I am using a 30 day evaluation version of Ver 12.5 and have had no success with the Ver 7 fix.  I have tried adjusting the screen resolutions in both host and guest to lesser values but that totally scrambles the desktop icons causing consternation upon exit from the DOS programs.   I have even tried DOSBOX but even though the screen goes to full the Lotus 1-2-3 program still is about 3" X 5" within the full screen.

There may be no viable fix for this problem but if anyone has ideas they will be welcome.
0
Background

  • I have a workbook which has a simple table of all numeric data (except for the axis' labels of course) and a basic line chart based on that data.
  • This chart is embedded in the worksheet where its data is located.
  • I am using Excel 2013
  • Unfortunately I can't upload the actual sheet where I have the issue as it is confidential client data. I also can't recreate the issue.

Question

Normally when you click a line in the chart Excel will automatically select / highlight the source data for that series. In one chart however, although it shows the correct graph / values when you click on the series nothing is highlighted.

If I create a new graph of exactly the same type based on the exactly the same data (i.e. using the same series) then clicking in a series line highlights the data as expected.

Has anyone come across this before or have an idea what could cause this ?
0

Spreadsheets

6K

Solutions

24

Articles & Videos

5K

Contributors

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.