How to perform certain calculations in Google Sheets?

I'm just trying to create a simple sheet to track my weight loss. Here is a link to my sheet so far so you can see what I'm talking about. Weight loss sheet

So far I have achieved the do column working properly. Now I just need help with re Y my.

1 in re (I have added examples) I would like you to calculate the difference between the current and previous weight input with a formula that can be completed automatically (taking into account that the entries are usually separated by sporadic empty cells). So each number in do minus the entrance above it.

2: Next in my I would like to show the average every 7 days that will change depending on my loss rate of re. He added some manually calculated numbers as an example. Quite sure that I have miscalculated it though. Arg! I should have stayed at school 🙂

This is the first time I use sheets, so I am an absolute beginner. I did not even use Excel. I tried to find a solution on Google, but I could not find anything. I think the problem is that I do not know exactly what to look for.

Let me know if you need more information.

Set associative cache calculations

I found the following problem:

Given the following specifications for an external cache memory: four-way associative set; line size of two 16-bit words; capable of accommodating a total of 4K 32-bit words from main memory; used with a 16-bit processor that emits 24-bit addresses. Design the cache structure with all the relevant information and show how it interprets the processor addresses.

I tried to solve it in the following way:

  • 4 lines per game
  • Word size of main memory: $ 32 $ bits $ = 2 ^ 4 $
  • Word size of the cache: $ 16 $ bits $ = 2 ^ 2 $
  • Size of main memory: $ 4 times 2 ^ {10} = 2 ^ {12} $ words of $ 32 $ bits $ = 2 ^ {13} $ words of $ 16 $ bits
  • The cache must adapt to the main memory. So the size of the cache = size of the main memory $ = 2 ^ {13} $ words of $ 16 $ bits
  • Line size $ = $ two 16-bit words $ rightarrow $ Word displacement $ = 1 $ bits
  • Associative set of four directions. $ rightarrow 4 = 2 ^ 2 $ lines per set
  • Set size $ = 2 ^ 2 text {lines} times 2 text {words per line} = 2 ^ 3 $ words of 16 bits in size
  • Number of sets $ = 2 ^ {13} / 2 ^ 3 = 2 ^ {10} $
  • Set the index size $ = 10 $ bits
  • Label size = Size of the address of 24 bits $ – $ 10 bit set index $ – $ 1 bit word shift = 13 bit


  1. I am surprised how it is said that the 16-bit processor generates 24-bit addresses. it's possible? I never encountered such problem.
  2. How can the cache and main memory have different word sizes? Here, the word size of the cache is 16 bits and the word size of the main memory is 32 bits.
  3. Taking into account the unusual scenarios (assumptions I made) explained in points 1 and 2 above, am I correct with the previous calculations?
  4. The answer only gives a diagram (without explanation) that says 1 bit per word, 1 bit per byte address and 12 bits per label. So, am I wrong?

    enter the description of the image here

Linear algebra – Problem with many calculations.

This is my first post here. I have problems expanding my function to the expanded form. I was wondering if there is any easy way to do it using WolframAplha or anything else. Here is the problem.

We have operations such as:

  • $ a vee b = a + b – a cdot b $
  • $ a wedge b = a cdot b $

Then, using those operations we need to note the expanded form of the given function.

Example:$ phi (x) = x_1 wedge (((x_2 vee x_3) wedge x_4) vee (x_5 wedge x_2)) = x_1 x_2 x_4 + x_1 x_3 x_4 – x_1 x_2 x_3 x_4 x_2 x_2 x_5 x_5 x_4 x_4 x_2 x_4 x_5 $

$ phi (x) = x_1 wedge (x_3 vee x_7 vee (x_2 wedge (x_5 vee x_6 vee x_4))) $

So far I have this, but my program in RStudio suggests that it is not correct
$ phi (x) = x_1 wedge (x_3 vee x_7 vee (x_2 wedge (x_5 vee x_6 vee x_4))) = x_1 x_3 + x_1 x_7 x_7 – x_1 x_3 x_7 + x_1 x_5 xx + x_1 x_2 x_4 – x_1 x_2 x_4 x_6-x_1 x_2 x_2 x_5 x_6 x_1 x_2 x_4 x_4 x x x x x x x x x x x x x x x x x x x x x x x x x xx x x x x x x x x x x x x x x x x x x x x xx xx xx of the person on the street x_7 – x_1 x_2 x_3 x_5 – x_1 x_2 x_3 x_6 + x_1 x_2 x_5 x_6 x_6 – x_1 x_2 x_7 + x_1 x_2 x 1 x 1 x 1 x 1 x 1 x 1 x 1 x 1 x 1 x 1 x 1 x 1 x 1 x 1 x 1 x 1 x 1 x 1 x 1 x_6 x_7 $

Mobile application V / S Mobile website

Are you still hesitating and trying to discover which is better, the mobile application or the mobile website? So, this is certainly the best place to solve your problem.

Certainly, organizations these days are becoming aware of the fact, for a successful business, it is important to have a mobile strategy. More than 65% of the population of the Earth has a mobile phone, which will probably reach 5,070 million by the end of 2019.

However, what is the correct method to use mobile strategies, a mobile application or a mobile website, is still a subject to reflect on. Many entrepreneurs claim that they do not need a mobile application when they have a mobile website. On the other hand, a large number of people consider that mobile applications have several benefits compared to mobile websites. Many mobile application development companies develop a mobile application, as well as a mobile website.

Therefore, before choosing any of them for your business, multiple factors must be considered. It sounds easy? No, it is not as easy as it seems, therefore, to know more about it, read the next section.

Mobile website: Pros and Cons

● Immediate: A mobile website is immediately available to users through a browser on a variety of devices, ie iPhone, BlackBerry, etc. No matter where you are, you can check the website in the blink of an eye.

● Compatibility: It is very easy to reach users all over the world, using different types of mobile phones with the help of a single website. In addition, the URL of a mobile website can be combined with other mobile technologies such as QR codes, SMS and near field communication (NFC).

● Update capacity: Another benefit of a mobile website is that it is dynamic compared to an application in terms of flexibility, to update the content. In case you want to adopt the design or content of a website, you can simply publish the edited and all the modifications are visible instantly.

● Searchability: It is much easier for users to discover a mobile website because its pages can be displayed in search results and listed in industry-specific directories, resulting in a simpler technique to find it. In addition, visitors to your website can be sent to your mobile site spontaneously when they are on a handheld.

● Compartibilidad: It is all the more difficult to share the URLs of a portable site between users through a connection. Distributors can redirect users to the versatile site from a site or blog. Therefore, versatile sites make it easy to obtain users quickly.

● Time and cost: A mobile website is always accessible to customers and is economical and economical, especially if you need proximity in many stages. In this line, indirectly build the income of an association.


● Convenience: Unlike an application, a mobile website can not productively use all the highlights of cell phones. GPS, cameras, telephone dialing, etc., incorporated in mobile devices are not constantly intended for mobile websites, despite the fact that APIs, and also libraries, are designed to determine these problems.

● Screen size: Without uncertainty, transport capacity is the fundamental factor by which customers have a tendency to choose smaller devices in a hurry, however, mobile devices show much less substance in contrast to the work area or the screen. the work station. Both a mobile website and a receptive website are not completely open to all the substance present in the work area.

● Offline access: Not related to the fact that you design a website for mobile devices is the most useful and lightweight, it can still work in an offline mode with some limited functionality using cached pages.

Mobile Apps: Pros and Cons

● Interactivity or game: For collaborative games, such as Angry Birds, an application will always be your best option, no matter what, at least for a predictable future.

● Personalization: In case your target audience is going to use the custom designed application frequently, like Evernote, then an application will surely give you a way to do it and facilitate the whole task.

● Reports or complex calculations: If you need something, that will take data and help you manipulate it with calculations, reports or complicated graphics, a mobile application will help you achieve it efficiently.

● Native functionality: With the advance of technology, mobile web browsers are becoming functional every day to recover certain specific functions of mobile devices such as SMS, GPS, etc. However, if you need to access a processing power or the user's camera, an application will still work. That much more powerfully.

● No Internet Dependency: You can use a mobile application without an Internet connection and can offer offline access to content or perform functions.


● Compatibility: One of the main disadvantages of a mobile application is that it must comply with all the requirements of the operating systems iOSrder to work properly. This means that each platform, whether it's iOS and Windows, needs a different application version. Even the multi-platform solution does not offer full support for all the functions and modules of each operating system.

● Support and maintenance: At the moment when an application is destined to several stages, more money is needed and, in addition, time. It has to give the redesigns, and also solve the similarity problems for each type of gadget, or, in other words, the process. In addition to this, you must inform your customers about these updates and instruct them to download the most recent version of the application that requires serious effort and energy.


From all the previous exchange, you can decipher very well without effort that the construction of a mobile website or a mobile application, largely based on your business objectives and objectives. In the event that you need to offer an intuitive substance to the customer to a wide variety of customers, at that time you are likely to need a mobile website. However, if you want to collaborate, attract and talk with your customers, a mobile application is the best decision for you.
Today, the custom software development company began to build a mobile application as the development of applications for phones.


Javascript Loops – have problems with calculations

import java.util.Scanner;
import javax.swing.JOptionPane;
public class homework four
Scanner static scan = new scanner (;
// declaring variables
Private static string name, jOptionInput;
private static int menuChoice, quantity, totalQuantity = 0;
static double private price = 0, saleTax = 0, total amount;

Empty main static public (String[] args) {
javax.swing.SwingUtilities.invokeLater (new Runnable () {
public vacuum execution () {

// entering name
System.out.print ("Please enter your name:");
name = scan.nextLine ();

System.out.println ("");

// Printing the menu
System.out.println ("MENU");
System.out.println ("1. Face painting $ 50");
System.out.println ("2. Globe spinning $ 45");
System.out.println ("3. Puppet shows $ 55");
System.out.println ("4. Stilt walkers $ 60");
System.out.println ("5. Bounce house $ 80");
System.out.println ("6. Rock wall $ 70");
System.out.println ("7. Petting zoo $ 65");
System.out.println ("10. Exit");

System.out.println ("");

// using the loop to read the selected menu and the quantity and exit when the ten are entered
while (true)
System.out.print ("Please select your options:");
menuChoice = scan.nextInt ();
if (menuChoice == 10) {break;}
jOptionInput = JOptionPane.showInputDialog (null, "How many hours do you want?", "Number of hours", JOptionPane.INFORMATION_MESSAGE);
quantity = Integer.parseInt (jOptionInput);
// calculoCost call method to calculate the cost
totalQuantity = totalQuantity + quantity;
calculateCost (menuElection, quantity);
// obtaining the sales tax and the total amount
saleTax = price * (0.065);
totalAmount = price + saleTax;

// printing the screens a receipt of this information
System.out.println ();
System.out.println ("Thank you for placing an order with Fantasy Entertainment," + name);
System.out.println ("Total ordered items:" + totalQuantity);
System.out.println ("Price of ordered food: $" + price);
System.out.println ("Sales tax: $" + saleTax);
System.out.println ("Total amount due: $" + totalAmount);
System.out.println ("You saved: $" +);

public static void calculaCost (int menu, int quantity) {
// calculating the cost of sale
switch (menu)
Case 1:
price = price + (quantity * 50);
Case 2:
price = price + (quantity * 45);
Case 3:
price = price + (quantity * 55);
Case 4:
price = price + (quantity * 60);
Case 5:
price = price + (quantity * 80);
Case 6:
price = price + (quantity * 70);
Case 7:
price = price + (quantity * 65);



I went differently with that. I need to do the following for the last exit, which is "You have saved: $"

There are two promotions that are:

  1. If you select facial paint and balloons -> $ 10 discount
  2. If you select all options -> $ 80 discount