Abstract: In some embodiments, technical problems relating to maintaining programmed behavior in tabular data cells are overcome by automatically generating and inserting formulas in interrelated cells. This may be done by reference to declarations of formulas (as by example in a formula table overlay on the sheet design or template, or in a formula editor using defined cell and column locations or defined variables), along with rules defining the order of precedence for assertion in reference to available cell data. In some embodiments, evaluation sequences or priorities may be automatically determined, and/or may be configurable by establishing precedence rules in a master row or hidden row. Some embodiments can determine, in some systems of formulas, where user entries in cells do not match the expected values for the cell, and explain why another result is correct or what is the expected type of entry or value for the cell.

Abstract: Systems and methods for managing a collaborative environment are provided. A plurality of sheets is stored in a collaboration system. The collaboration system tracks user interactions with the plurality of sheets and generates a collaboration graph based on the interactions. The collaboration graph is analyzed to determine similarities between the sheets and/or the users. One or more visualizations are generated based on the collaboration graph and the determined similarities. In some embodiments, the collaboration system is able to provide project management information even for dynamic workflows that are not explicitly defined.

Abstract: Systems and methods for managing a collaborative environment are provided. A plurality of sheets is stored in a collaboration system. The collaboration system tracks user interactions with the plurality of sheets and generates a collaboration graph based on the interactions. The collaboration graph is analyzed to determine similarities between the sheets and/or the users. One or more visualizations are generated based on the collaboration graph and the determined similarities. In some embodiments, the collaboration system is able to provide project management information even for dynamic workflows that are not explicitly defined.

Abstract: In some embodiments, if a Master Row is associated with tabular data, a formatting operation replicates formatting from the Master Row in any new row created at the same level of hierarchy in the tabular data. In some embodiments, the tabular data editor allows users to specify whether formatting set by a user edit in a cell before application of a Master Row results in a merger or override. In some embodiments, formatting set by a user edit after a Master Row is applied is treated as custom edit to that cell or row, and is not again changed to match the Master Row (unless the hierarchy of the row changes, and another Master Row is applied).

Abstract: In some embodiments, a computer-implemented spreadsheet management method is provided that automatically copies formatting and formulas from appropriate peer rows to an updated row. In some embodiments, the method automatically determines which peer rows, if any, should be used as the source of copied formatting and formulas. In some embodiments, the method automatically fixes formulas that are affected by the updated row in order to maintain consistency throughout the spreadsheet.

Abstract: A visual environment implements technical solutions to permit rapid, contextual display of status information for scheduled items. The visual environment includes interactive charts (e.g., interactive Gantt charts) with dynamic progress monitoring (e.g., in the form of dynamic progress views with specialized, multi-function burn-down graphs, trend lines, or the like). Automated notifications and modifications can be generated based on inputs to or outputs from the visual environment and/or a related back-end computer system. Contextual presentation of possible or actual changes to the scheduled items can be provided by the visual environment (e.g., in the form of updates to a dynamic progress view). Real-time data inputs by users can be tracked by the back-end computer system, which can make updates to the visual environment, such as updating a trend line in a dynamic progress view.

Abstract: Online communications are susceptible to high levels of fraud or other unauthorized communications. Online sources of information about goods, including business-to-business resources, marketplace web sites, custom retail web sites, and the like may knowingly or unknowingly transmit communications representing counterfeit goods as genuine, communications regarding overstock goods at low prices without production and commission costs, and solicit customers anonymously. In some embodiments of the present disclosure, electronic information sources are monitored using data metrics to track electronic retailer activities, monitor distribution volumes by source, and monitor pricing. Analysis of such communications may be used to detect potentially fraudulent activity, and, based on manufacturer policy and threshold settings, may automatically report, notify, or take action against such illicit communications.

Abstract: In some embodiments, a computer-implemented spreadsheet management method is provided that automatically copies formatting and formulas from appropriate peer rows to an updated row. In some embodiments, the method automatically determines which peer rows, if any, should be used as the source of copied formatting and formulas. In some embodiments, the method automatically fixes formulas that are affected by the updated row in order to maintain consistency throughout the spreadsheet.

Abstract: In one aspect, a computing device with a touchscreen (e.g., a tablet computer, smart phone, etc.) renders an initial interactive chart view (e.g., a Gantt chart view) having a time axis and a task axis, receives user input (e.g., a pinch gesture) associated with a zoom operation, determines whether the zoom operation is one-dimensional or multi-dimensional, and renders a zoom-adjusted interactive chart view (e.g., zooming in or out on the time axis, the task axis, or both). In another aspect, a computing device renders a chart view comprising a time axis and a task row having a task name label with a directional indicator, renders the directional indicator such that it points in the direction of a task bar, receives user input associated with a change in the current position of the task bar, and adjusts the directional indicator based on the change in the current position.

Abstract: In one aspect, a computing device with a touchscreen (e.g., a tablet computer, smart phone, etc.) renders an initial interactive chart view (e.g., a Gantt chart view) having a time axis and a task axis, receives user input (e.g., a pinch gesture) associated with a zoom operation, determines whether the zoom operation is one-dimensional or multi-dimensional, and renders a zoom-adjusted interactive chart view (e.g., zooming in or out on the time axis, the task axis, or both). In another aspect, a computing device renders a chart view comprising a time axis and a task row having a task name label with a directional indicator, renders the directional indicator such that it points in the direction of a task bar, receives user input associated with a change in the current position of the task bar, and adjusts the directional indicator based on the change in the current position.

Abstract: Online commercial activities are susceptible to high levels of fraud. Online sources of goods, including business-to-business resources, marketplace web sites, custom retail web sites, and the like may knowingly or unknowingly pass off counterfeit goods as genuine, sell overstock goods at low prices without production and commission costs, and solicit customers anonymously. In some embodiments of the present disclosure, electronic commerce sites are monitored using data metrics to track electronic retailer activities, monitor distribution volumes by source, and monitor pricing. Analysis of such items may be used to detect potentially fraudulent activity, and, based on manufacturer policy and threshold settings, may automatically report, notify, or take action against such illicit product sources.

Abstract: The present invention is directed to a system and method enabling the tracking of users, content and actions in respect to online content; assigning topics to online content; providing such information for analysis at a central systems; and providing an overview of users, content and actions in the aggregate. The processing of online interactions permits tracking users, identifying influential content and users, identifying the type of interactions that users prefer with respect to specific content, and so forth. As such, the system permits targeted and informed interactions with users and content sites, which recommendations are of value to, among others, online publishers, advertisers, search engines and users.

Abstract: A phone network in a wireless environment that does not perform CNAM queries when a number is already stored in the receiving handsets' caller directory. CNAM query fees are charged only to obtain caller information on a new caller. The network does not make CNAM queries when the caller information is already available, whether in the contact information stored on the receiver's handset or through some other reliable source.