COPY THE EXACT FORMULA TO GENERATE OVER \$10,000/month in AFFILIATE COMMISSIONS!

You will have everything you need, you will learn everything there is to know about affiliate marketing. These courses don't just cover one affiliate method, it covers them all.

## How to sum a range columns from another google sheet

I get this daily data consumption spreadsheet report from a vendor that looks like this

``````userid    feb1    feb2    feb3     .    feb29
u1        100     34      23       .     4
u2        0       24      21             62
u3        300     25      5              1
u4        50      5       6
.
.
un        23      52      3        .     42
``````

where `n` is my total number of users.

What I care about is simply tracking the daily consumption of all users.. so my final sheet should look like this

``````date        daily consumption
feb1        14,971
feb2        6,898
feb3        10,666
.
.

feb29        10,543
``````

Currently I’m doing this by writing this in each line in my final sheet, for example to get the `14,971` for `feb1` I’m putting

``````=sum(importrange("<sheet_ref>","<sheet_name>!I2:I"))
``````

Naturally this is very manual and slow work. I want to know how to do this using a single formula or pivot table etc. I tried using array formulas, queries, pivot tables but I keep on getting stuck. Any suggestions?

## shell – How I can rename txt files according to first line of text file?

I have multiple .txt files and I want to rename them as first line text they contains.

First line in every text file is some number and text Example
ParagraphL23
I want my text file to be renamed as ParagraphL23.txt

And I want to do this on all my files, 30 of them.

## networking – Cannot connect to localhost port 80 in GCP Compute Engine VM

I have setup a `Windows Server 2019 with Containers` Compute Engine VM in Google Cloud. I have installed IIS. I want to go to the following URL on the local server in a browser, or via wget: `http://localhost`. However, I am getting back a connection refused. I tried on the Private IP and Public IP from the machine, both failed. Also fails from outside the VM using public IP.

I check with `netstat` and port 80 is open, and IIS is running. I ran Test-NetConnection and got the following result:

``````Test-NetConnection -Port 80 -ComputerName 127.0.0.1 -InformationLevel Detailed

ComputerName            : 127.0.0.1
RemotePort              : 80
NameResolutionResults   : 127.0.0.1
MatchingIPsecRules      :
NetworkIsolationContext : Loopback
InterfaceAlias          : Loopback Pseudo-Interface 1
NetRoute (NextHop)      : 0.0.0.0
TcpTestSucceeded        : True
``````

So apparently the port is open but I just can’t retrieve data from it.

This is super weird because it is on localhost. I also went into the VPC Network and added an HTTP Ingress (port 80) rule for `0.0.0.0/0`.

I really can’t figure this out. Why would I not be able to connect to a running port 80 web server on my own machine? Is there some extra firewall in this GCP image somewhere?

Any help would be greatly appreciated.

## calculus – On powers of Trigonometric functions using Complex numbers

For a Calculus course i am taking, we are going through successive differentiation($$n^{th}$$-derivatives if you will). I came across this technique, given below, for successive derivatives of functions of the form $$cos^px,sin^px ,sin^pxcos^qx$$:

1. First,| we let z=cosx+isinx $$implies z^{-1}$$=cosx-isinx | so we have that $$z+z^{-1}=2cosx,and z-z^{-1}=2i*sinx….(1)$$
Further, we have: $$z^r+z^{-r}=2cos(rx),z^r-z^{-r}=2i*sin(rx)$$……(2)

this first step was okay to understand. But then they did something i didnt quite understand:

1. let $$y=cos^px implies 2^p*y=(2cosx)^p$$ $$=(z+z^{-1})^p=(z^p+z^{-p})+C^p_1(z^{p-2}+z^{-(p-2)})+C^p_2(z^{p-4}+z^{-(p-4)})+cdots$$ then by using (1)&(2) we will go on to evaluate the successive derivatives.

My question is, how did they expand out the $$y=cos^px implies 2^p*y=(2cosx)^p$$ term into a seemingly binomial theorem-esque expansion?. What theorem(s) did they employ to write it out like that? I haven’t taken a complex analysis course yet and what i do know about complex numbers is from Intro. ODE courses for my major requirement. so any further resources from which i could learn more about this would be appreciated.

## plugins – Switch post type in frontend by post author

I have a website that registered user can publish posts in frontend. I use wp user frontend plugin for post submisson. I have two custom post type “problems” and “solved problems“. so everything works fine, user can publish CPT “problems” without any problem. and can edit this when they want. Now I want user can change post type from “problems” to “solved problems” and reverse when they want. They can do it in wordpress dashboard with the help of post type switcher plugin but I want them to use WP user frontend plugin for this action. problem is that my code cant not override post_type value of wp_posts table. when I save changes post type still is unchanged . even I gave all admin privilege to author but not any affect

``````<?php
// Post type Class
class WPUF_Form_Field_Post_type extends WPUF_Field_Contract {

public function __construct() {
\$this->name       = __( 'Post type', 'wp-user-frontend' );
\$this->input_type = 'post_type';
\$this->icon       = 'compress';
}

/**
* Render the Post type field
*
* @param array  \$field_settings
* @param int    \$form_id
* @param string \$type
* @param int    \$post_id
*
* @return void
*/
public function render( \$field_settings, \$form_id, \$type = 'post', \$post_id = null ) {

// \$req_class   = ( \$field_settings('required') == 'yes' ) ? 'required' : 'rich-editor';
// \$value       = \$field_settings('default');
// \$textarea_id = \$field_settings('name') ? \$field_settings('name') . '_' . \$form_id : 'textarea_';

if ( isset( \$post_id ) ) {
\$value = get_post_field( \$field_settings('name'), \$post_id );
} else {
\$value       = \$field_settings('default');
}

\$req_class   = ( \$field_settings('required') == 'yes' ) ? 'required' : 'rich-editor';
\$textarea_id = \$field_settings('name') ? \$field_settings('name') . '_' . \$form_id : 'textarea_'; ?>
<li <?php \$this->print_list_attributes( \$field_settings ); ?>>
<?php \$this->print_label( \$field_settings, \$form_id ); ?>

<?php if ( in_array( \$field_settings('rich'), ( 'yes', 'teeny' ) ) ) { ?>
<div class="wpuf-fields wpuf-rich-validation <?php printf( 'wpuf_%s_%s', esc_attr( \$field_settings('name') ), esc_attr( \$form_id ) ); ?>" data-type="rich" data-required="<?php echo esc_attr( \$field_settings('required') ); ?>" data-id="<?php echo esc_attr( \$field_settings('name') ) . '_' . esc_attr( \$form_id ); ?>" data-name="<?php echo esc_attr( \$field_settings('name') ); ?>">
<?php } else { ?>
<div class="wpuf-fields">
<?php } ?>

<?php

if ( \$field_settings('rich') == 'yes' ) {
\$editor_settings = (
// 'textarea_rows' => \$field_settings('rows'),
'quicktags'     => false,
'media_buttons' => false,
'editor_class'  => \$req_class,
'textarea_name' => \$field_settings('name'),
);

\$editor_settings = apply_filters( 'wpuf_textarea_editor_args', \$editor_settings );
wp_editor( \$value, \$textarea_id, \$editor_settings );
} elseif ( \$field_settings('rich') == 'teeny' ) {
\$editor_settings = (
'textarea_rows' => \$field_settings('rows'),
'quicktags'     => false,
'media_buttons' => false,
'teeny'         => true,
'editor_class'  => \$req_class,
'textarea_name' => \$field_settings('name'),
);

\$editor_settings = apply_filters( 'wpuf_textarea_editor_args', \$editor_settings );
wp_editor( \$value, \$textarea_id, \$editor_settings );
} else {
?>
<textarea
class="textareafield <?php echo esc_attr( ' wpuf_' . \$field_settings('name') . '_' . \$form_id ); ?>"
id="<?php echo esc_attr( \$field_settings('name') . '_' . \$form_id ); ?>"
name="<?php echo esc_attr( \$field_settings('name') ); ?>"
data-required="<?php echo esc_attr( \$field_settings('required') ); ?>"
data-type="textarea"
placeholder="<?php echo esc_attr( \$field_settings('placeholder') ); ?>"
rows="<?php echo esc_attr( \$field_settings('rows') ); ?>"
cols="<?php echo esc_attr( \$field_settings('cols') ); ?>"
><?php echo esc_textarea( \$value ); ?></textarea>
<span class="wpuf-wordlimit-message wpuf-help"></span>

<?php
} ?>

<?php
\$this->help_text( \$field_settings );

if ( isset( \$field_settings('content_restriction') ) && \$field_settings('content_restriction') ) {
\$this->check_content_restriction_func(
\$field_settings('content_restriction'),
\$field_settings('rich'),
\$field_settings('name') . '_' . \$form_id,
\$field_settings('restriction_type')
);
} ?>
</li>
<?php
}

/**
* Get field options setting
*
* @return array
*/
public function get_options_settings() {
\$default_options      = \$this->get_default_option_settings( false, ('dynamic') );
\$default_text_options = \$this->get_default_textarea_option_settings();

return array_merge( \$default_options, \$default_text_options );
}

/**
* Get the field props
*
* @return array
*/
public function get_field_props() {
\$defaults = \$this->default_attributes();

\$props    = (
'input_type'       => 'textarea',
'is_meta'          => 'no',
'name'             => 'post_type',
'rows'             => 5,
'cols'             => 25,
'rich'             => 'no',
'id'               => 0,
'is_new'           => true,
'restriction_type' => 'character',
);

return array_merge( \$defaults, \$props );
}

/**
* Prepare entry
*
* @param \$field
*
* @return mixed
*/
public function prepare_entry( \$field ) {

\$field = isset( \$_POST(\$field('name')) ) ? sanitize_text_field( wp_unslash( \$_POST(\$field('name')) ) ) : '';

return wp_kses_post( \$field );
}
}
``````

## How to disable multi-user in android 8.1.1 without root using adb or anything else

How to disable multi-user in android 8.1.1 without root using adb or anything else

** Android 8.1.1 (Galaxy Tab A (2016)) **

## 2d – Design an object for a unity game?

I’m new to game development, I recently started a new game project. I use the unity engine for game development. Now, what is the best program for object (vehicles, plant, etc) designing? It should be easy to learn and not too complicated. I read about Blender but in my opinion, it’s too complicated.

PS: I only have 2 weeks to learn design. It’s a school project.

## seo – Replacing the public home page with member specific content for logged in users

Context: I am designing a web application that’s geared toward members-only features. There’s no site features that would be useful to non-members, so most of the website will only be available to authenticated users. Thus, the only public pages will be things like an About Us page (with contact options), a Features/Comparisons page (promote the service relative to competitors), and of course a Home Page.

Problem: My initial thought was that the homepage `index.php` file, located at the website root, should load the public content for non-authenticated visitors, but should load the main application landing page for authenticated users. My main reason was for members’ ease-of-access — automatic serving of the content they’re actually trying to get to if they’re already logged in, and no need to type / remember / bookmark a more complicated address than `example.com`. But this got me thinking whether that would work best in the long run for issues like SEO and maintainability.

Approaches: I can think of three:

1. All files are hosted under `example.com`, with no subdomains. When a visitor requests `example.com/index.php`, it checks for authentication, and serves up the correct HTML depending. (This is the approach I mentioned above.)
2. Public files are hosted under `www.example.com`, while member-only pages are hosted under a subdomain like `members.example.com`. When an authenticated user attempts to access the public `www.example.com/index.php`, they’ll be automatically redirected to `members.example.com/index.php`.
3. The same as option 2, but instead of being automatically redirected, the user will stay on the public homepage, and will need to navigate to their application landing page via the main nav. (This approach seems best if some of the public pages actually have usefulness to authenticated users, which they won’t on my site, so I’m thinking this option doesn’t make sense?)

Which of these approaches would be best in terms of SEO, being easy to code, and easy to maintain?

## Why do some countries require a proof of accommodation post-quarantine in their visa application?

I am applying for a visa for a country that has a mandatory quarantine in designated quarantine facilities. The visa application requires a proof of fully-paid accommodation post-quarantine.

I understand the usefulness of a proof of accommodation if:

1. It was challenging to find accommodation. However, the country in question has a plethora of near-empty hotels desperate to find customers
2. The visa applicant was impecunious. However, the visa application also requires a proof of funds via bank statements.

In that context, why do some countries require a proof of accommodation post-quarantine in their visa application?