tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: stacey_white__38795__terminated cp with deals entered into in december
Sheet: West

Deal ID | Enron Entity | Deal Date | Counterparty | Instrument | Deal Status | Deal Comment | Nature | Termination Date | Long Counterparty Name
884431.1 | EPMI-LT-NW | 2001-12-09 13:24:04 | MORGAN | FORWARD | D | Assigned from MEGA originally 196614 for all deliveries Nov1 and forward.  [NAME] originally Natsource.Duplicate deal. See deal 435164 that was moved to bankruptcy. | P | 2001-12-07 00:00:00 | Morgan Stanley Capital Group Inc.
893767.1 | EPMI-ST-CA | 2001-12-18 09:23:23 | AETS | FORWARD | D | Pre pay | P | 2001-12-03 00:00:00 | Allegheny Energy Supply Company, LLC
893768.1 | EPMI-ST-CA | 2001-12-18 09:23:47 | AETS | FORWARD | D | Prepay | P | 2001-12-03 00:00:00 | Allegheny Energy Supply Company, LLC
893766.1 | EPMI-ST-CA | 2001-12-18 09:22:24 | MIRANT | FORWARD | D | Pre pay | P | 2001-12-05 00:00:00 | Mirant Americas Energy Marketing, LP
893764.1 | EPMI-ST-CA | 2001-12-18 09:20:41 | RESI | FORWARD | D |  | P | 2001-12-06 00:00:00 | Reliant Energy Services, Inc.
893765.1 | EPMI-ST-CA | 2001-12-18 09:21:14 | RESI | FORWARD | D |  | P | 2001-12-06 00:00:00 | Reliant Energy Services, Inc.
884122.1 | EPMI-ST-WHOURLY | 2001-12-05 12:55:00 | PWX | FORWARD | D |  | P | 2001-12-03 00:00:00 | Powerex Corp.
884128.1 | EPMI-ST-WHOURLY | 2001-12-05 15:35:00 | SNO | FORWARD | D |  | P | 2001-11-28 00:00:00 | Public Utility District No.1 of Snohomish County
884348.2 | EPMI-WEST-BANK | 2001-12-08 16:25:04 | AVISTA | ANNUITY | D | On 10/27, Avista exercised thier option to enter into 5 swaptions, see leg 1 | P | 2001-12-02 00:00:00 | Avista Energy, Inc.
884348.3 | EPMI-WEST-BANK | 2001-12-08 16:25:05 | AVISTA | FORWARD | D | Option exercised and forward booked | P | 2001-12-02 00:00:00 | Avista Energy, Inc.
884348.4 | EPMI-WEST-BANK | 2001-12-08 16:25:05 | AVISTA | FORWARD | D |  | P | 2001-12-02 00:00:00 | Avista Energy, Inc.
884348.5 | EPMI-WEST-BANK | 2001-12-08 16:25:05 | AVISTA | FORWARD | D |  | P | 2001-12-02 00:00:00 | Avista Energy, Inc.
891957.1 | EPMI-WEST-BANK | 2001-12-09 13:32:00 | MORGAN | FORWARD | D | Assigned from MEGA originally 196614 for all deliveries Nov1 and forward.  [NAME] originally Natsource. Deal terminated on 12/7 due to bankruptcy. see deal 884431.1 | P | 2001-12-07 00:00:00 | Morgan Stanley Capital Group Inc.
Spreadsheet: 789908d1659436552-how-to-auto-calculate-available-frequency-and-non-availability-hours-test
Sheet: Office

No | Year | Month | Product Name | In Time | Out Time
1 | 2022 | January | SPLENDOR | 2021-12-29 05:18:00 | 2021-12-30 14:21:00
2 | 2022 | January | RIDGE | 2021-12-31 06:48:00 | 2021-12-31 20:04:00
3 | 2022 | January | SUN | 2022-01-02 09:36:00 | 2022-01-02 17:00:00
4 | 2022 | January | SIRIUS | 2022-01-02 06:12:00 | 2022-01-04 17:42:00
5 | 2022 | January | SPLENDOR | 2022-01-04 01:18:00 | 2022-01-06 03:45:00 |  |  |  | Available Frequency
6 | 2022 | January | EAGLE | 2022-01-04 18:48:00 | 2022-01-07 23:18:00 |  | Year | Month | 0 Product Hrs | 1 Product | 1 Prod hrs | 2 Product | 2 Prod Hrs | 3 Product | 3 Prod Hrs
7 | 2022 | January | GRANDE | 2022-01-05 01:15:00 | 2022-01-06 22:24:00 |  | 2022 | January |  | 2 |  | 2 |  | 1
8 | 2022 | January | HOEGH | 2022-01-06 06:42:00 | 2022-01-07 17:44:00
9 | 2022 | January | [NAME] | 2022-01-11 01:54:00 | 2022-01-11 09:34:00
10 | 2022 | January | UNITY | 2022-01-10 13:42:00 | 2022-01-15 09:40:00
 |  |  |  |  |  |  | Suppose month starts at 01st 00:00 hrs and ends on the last day at 23:59 , Can I calculate data in to the summary  ?
 |  |  |  |  |  |  | Year =  identify the year/s of the selected data set
 |  |  |  |  |  |  | Month =  identify the month/s of the selected data set
 |  |  |  |  |  |  | 0 Product hrs =  Calculate how many hours in the particular year/month had no(Zero) product is available.
 |  |  |  |  |  |  | 1 Product = Calculate how many times (count )only one product is available in the selected data set
 |  |  |  |  |  |  | 1 Prod hrs = Calculate how many hours only one product is available in the selected data set
 |  |  |  |  |  |  | 2 Product = Calculate how many times (count )only two products are available in the selected data set
 |  |  |  |  |  |  | 2 Prod hrs= Calculate how many hours only two products are available in the selected data set
 |  |  |  |  |  |  | 3 Product = Calculate how many times (count )only three products are available in the selected data set
 |  |  |  |  |  |  | 3 Prod hrs= Calculate how many hours only three products are available in the selected data set
Spreadsheet: 698033d1601686957-if-formula-actionlist-booking-yas-2-
Sheet: Yasmani

credit to Pascale |  | 1000
Insurrance home | 23 | 23 |  |  | computer | 2000
Insurrance truck | 100 | 100 |  |  | RBQ | 5000 |  |  | Loaned | 8000
Insurrance Mustang | 175 | 175 |  |  | Trip | 2500 |  |  | Now | 24000 |  | Expenses Nov to March  and [NAME]
 |  |  |  |  | Phamplets | 1000 |  |  | Hugo | 8000
Rent | 725 | 725 |  |  | Truck | 16000 |  |  | To come | 15000
Hydro | 115 | 115 |  |  | Trailor | 3500 |  |  | Total
Cie Taxes | 500 | 500 |  |  | Total
Money to MOm | 150 | 150 |  |  | Actual spent
Thiago | 200 | 200
Pension to Tessa | 300 | 300 |  |  | Other project
Garderie | 400 | 400 |  |  | [NAME] | 50000 | ( From May 2021 to 2022 need to put aside 4200$ a month during one year  for this project)
Going Out | 300 | 500
Gaz | 900 | 200
Food | 600 | 600
Total Summer
Total Winter
Need Nov to April
Expenses Nov to April  and Purchases
Spreadsheet: 83627d1283610745-selecting-the-smallest-negative-number-book2
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | 97.37861020227916 | 92.46613969198718 | 23.57701393742488 | 64.53462621750394
 |  |  |  | Specified number | 87 |  |  |  |  | 94.89306448824406 | 98.23617499595309 | 30.68813704854718 | 41.17106184537178
 |  |  |  |  |  |  |  |  |  | 69.00508848528197 | 86.9451 | 60.05631765630242 | 10.67647958933762
 |  |  |  | Output |  |  |  |  |  | 81.201836858339 | 88.57370035944223 | 29.29352650946164 | 26.63421981794658
 |  |  |  |  |  |  |  |  |  | 43.28040978023316 | 43.2257119823013 | 18.15782816733553 | 89.21584995150388
 |  |  |  |  |  |  |  |  |  | 26.03078710065805 | 12.99273221321382 | 3.911954804140083 | 36.73928497561341
 |  |  |  |  |  |  |  |  |  | 75.25025815581384 | 48.05532482981248 | 53.5525448851234 | 1.332962803085458
Spreadsheet: 0806ecb6-49d3-4f3a-8326-7d2fa42c4b96
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
HLA57 | Test | HLA57 | HLA-B 5701 Genotype, Abacavir Hypersensitivity, Blood | HLA-B 5701 Genotype, [NAME], B | [NAME] (PCR)  (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | Lavender-top (EDTA) Tube: EDTA |  |  | 3 | mL | Multiple whole blood EDTA genotype tests can be performed on a single specimen. See Multiple Whole Blood EDTA Genotype Tests in Special Instructions for a list of tests that can be ordered together.   Container/Tube: Lavender top (EDTA) [NAME]: 3 mL Collection Instructions: Send specimen in original tube. Additional Information: Patients who had a heterologous blood transfusion within the preceding 45 days (6 weeks), or who have received an allogeneic bone marrow transplant, can have false genetic test results as human DNA present in the blood may be a mixture of patient and donor DNA. For these patients, a saliva specimen (rather than blood) should be submitted (HL57O/60347 HLA-B 5701 Genotype, Abacavir Hypersensitivity, [NAME]). Forms: New York Clients-Informed consent is required. Please document on the request form or electronic order that a copy is on file. An Informed Consent for Genetic Testing (Supply T576) is available in Special Instructions. | 0.3 mL | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA | An interpretive report will be provided. | Tuesday, Friday | 1 day | 5 days | 1 | 81381 |  |  |  |  | Rochester
HLA57 | [NAME] | WBEDTA | [NAME] EDTA |  |  |  | Ambient
HLA57 | Result | 89346 | HLA-B 5701 Result | HLA-B 5701 Result | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42358-2
HLA57 | Result | 29315 | HLA-B 5701 Interpretation | HLA-B 5701 Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69047-9
HLA57 | Result | 29316 | HLA-B 5701 Reviewed by | HLA-B 5701 Reviewed by | Numeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69047-9
Spreadsheet: darrell_schoolcraft__7310__imball0201
Sheet: EOG

 | 500249 |  | 500260 |  | 500646 |  | 500598
 | Pronghorn |  | Pitchfork Ranch |  | Tristi Draw |  | EOG/TW Eddy
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 10708 | 11500 | 8161 | 8800 |  | 7800
2 | 10744 | 11500 | 7789 | 8800 | 70 | 7800
3 | 10863 | 11500 | 7744 | 8800 | 3645 | 7800
4 | 10242 | 11500 | 8002 | 8800 | 5612 | 7800
5 | 10778 | 10500 | 8365 | 7800 | 7669 | 7800
6 | 10431 | 10500 | 8128 | 7800 | 7973 | 7800
7 | 10424 | 10500 | 8598 | 7800 | 7892 | 7800
8 | 10274 | 10500 | 7816 | 7800 | 7851 | 7800
9 | 10910 | 10500 | 8098 | 7800 | 7846 | 7800
10 | 10835 | 10414 | 8179 | 7800 | 7955 | 7800
11 | 10923 | 10500 | 8046 | 7800 | 7285 | 7800
12 | 10260 | 10500 | 8250 | 7800 | 7013 | 7800
13 | 10150 | 10500 | 8185 | 7800 | 6965 | 7800
14 | 9670 | 10500 | 7899 | 7800 | 7876 | 7800
15 | 9743 | 10500 | 8341 | 7800 | 4873 | 7800
16 | 9410 | 9350 | 8114 | 7517 | 7114 | 6967
17 | 10064 | 9700 | 7780 | 7900 | 8219 | 7400
18 | 9644 | 9700 | 7586 | 7900 | 8311 | 6400
19 | 9194 | 9000 | 8104 | 8000 | 7883 | 7000
20 | 9281 | 9000 | 8051 | 8000 | 12314 | 7000
21 | 8979 | 8927 | 7845 | 7935 | 7404 | 6943
22 | 5948 | 9000 | 7914 | 8000 | 8924 | 7000
23 | 7675 | 9000 | 8105 | 8000 | 8281 | 7000
24 | 8104 | 8500 | 8906 | 7500 | 8896 | 7000
25 | 8466 | 8500 | 8859 | 7500 | 11916 | 7000
26 | 8368 | 8499 | 8428 | 7500 | 7368 | 7000
27
28
29
30
31
2001-12-31 00:00:00 |  |  |  |  |  |  |  |  | 4536.21
2002-01-26 00:00:00
CBS Volume
 |  |  | -125538
Spreadsheet: 111279d1307677536-counting-items-using-criteria-from-3-columns-sample-worksheet
Sheet: Sheet1

Department | Country | Open Reqs | Future Reqs |  |  |  | Open Reqs | Future Reqs
Engineering | US | A86 |  |  |  | Engineering
Engineering | US | 105.037055431028 |  |  |  | Operations
Engineering | US | 157.232204169128 |  |  |  | HR
Engineering | US | 235.404678426319
Engineering | US |  | waiting
Operations | US | A8
Operations | US | 496.213287551663
Operations | US | 337.342655411413
Operations | US |  | waiting
HR | US | 233.890425576593
HR | US | 208.634574603139
HR | US |  | waiting
Operations | CAN | 438.729018716289
Operations | CAN | 184.82540102381
Operations | CAN |  | waiting
HR | CAN | 367.135884969108
HR | CAN | 338.039694210675
Engineering | CN | 478.861573313535
Engineering | CN | 197.966896630393
Engineering | CN |  | hold
Operations | CN | 191.721049436141
Operations | CN | 214.91768810977
HR | CN | 293.768804270039
HR | CN | 413.246892628152
HR | CN |  | hold
Spreadsheet: d114fc10-cf81-4257-9865-03fdf1712b1b
Sheet: Sheet1

 |  |  |  |  |  | DISCOUNT PROPOSAL SPREADSHEET
This document must be completed and submitted with your offer.
Choose the applicable spreadsheet(s) templates below for your offerings.
Products
SIN | MANUFACTURER NAME | MFR PART NO | DEALER PART NUMBER (if applicable) | PRODUCT NAME | PRODUCT DESCRIPTION | UOI | GREEN CERTIFICATION (ENERGY STAR, FEMP, or BIOPREFERRED) (as applicable to schedules 51V, 56 and 73) | RECYCLED AND/OR POST-CONSUMER MATERIAL CONTENT % (Schedule 75 only) | COMMERCIAL LIST PRICE | MOST FAVORED CUSTOMER (MFC) | DISCOUNT OFFERED TO MFC (%) | MFC PRICE | GSA (%) DISCOUNT (exclusive of the .75% IFF) | GSA OFFER PRICE (exclusive of the .75% IFF) | GSA OFFER PRICE (inclusive of the .75% IFF) | QUANTITY/VOLUME DISCOUNT | COO
Most Favored Customer’s Discount or Discount Range (MFC) __________.
GSA’s Discount or Discount Range W/O IFF __________.
Labor Categories (not applicable to [NAME], 67 or 75)
SIN(s) PROPOSED | SERVICE PROPOSED (e.g. Job Title/Task) | MINIMUM EDUCATION/ CERTIFICATION LEVEL |  |  | MINIMUM YEARS OF EXPERIENCE | COMMERCIAL LIST PRICE (CPL)   OR MARKET  PRICES |  | UNIT OF ISSUE (e.g. Hour, Task, Sq ft) | MOST FAVORED CUSTOMER (MFC) | DISCOUNT OFFERED TO MFC (%) | MFC PRICE | GSA(%) DISCOUNT (exclusive of the .75% IFF) | PRICE OFFERED TO GSA (excluding IFF) | PRICE OFFERED TO GSA (including IFF) | QUANTITY/VOLUME DISCOUNT
Courses (not applicable to [NAME], 67 or 75)
SIN(s) PROPOSED | Course Title | Course Length |  |  | Minimum Participants | Maximum Participants |  | COMMERCIAL PRICE (CPL) | Price Per Course or Per Person | MOST FAVORED CUSTOMER (MFC) | DISCOUNT OFFERED TO MFC (%) | MFC PRICE | GSA(%) DISCOUNT (exclusive of the .75% IFF) | PRICE OFFERED TO GSA (excluding IFF) | PRICE OFFERED TO GSA (including IFF) | QUANTITY/VOLUME DISCOUNT
Acronyms
UOI:  Unit of Issue
COO:  Country of Origin
SIN:  Special Item Number
[NAME]:  Most Favored Customer
IFF:  Industrial Funding Fee (Clause 552.238-74): Fee is 0.75% (less than 1%)
 | IFF Calculation Example: List Price = $100.00 |  | List Price: $100.00
 |  |  | GSA % Discount: 10%
 |  |  | GSA Price excluding IFF: $90.00
 |  |  | GSA Price including IFF: $90.00/0.9925 = $90.68
Re:  Recycled and/or Postconsumer Material Content Column – Refer to the Basic Proposal Checklist under EPA Comprehensive Procurement Guidelines (CPG) for instructions.
Spreadsheet: 291016d1390103508-if-there-is-yes-in-the-cell-then-automatically-copy-that-to-another-sheet-vaccine-list
Sheet: Vaccine Shedule 

 |  |  |  | Request From
[NAME] |  |  |  | R. No; | Mother's Name | Child Name | Adress | Age in Months | [NAME] to be given
At Birth |  |  |  | 2013/10 | N/A | [NAME] | Naares | 9 | Measles, Vit A 1st
BCG | OPV 1st | [NAME] |  | 2013/11 | N/A | Razeen Yazeedh | Fahivaa | 9 | Measles, Vit A 1st
02 months |  |  |  | 2013/12 | N/A | Nooraa Binth Fahumee | Sabnameege | 9 | Measles, Vit A 1st
Panta 1st | OPV 2nd |  |  |  |  |  |  |  | All the [NAME] name sholud come here if there is yes in master [NAME] " Vaccine list 2014"
04 months |  |  |  | If there is "-" meas it should not come here in this table . Only " Yes" has to come here. And All the date in this table has to fill Automaically when there is " yes" in master [NAME].
Panta 2nd | OPV 3rd |  |  | .
06 moths
Panta 3rd | OPV 4th
09 months
Measles | Vit  A 1st
18 months
MMR | Vit  A 2nd
Spreadsheet: 161468d1339525815-data-sorter-example
Sheet: Sheet1

 |  |  |  |  | Q1 |  | Q2 |  | D1 |  | D2 |  | M1 |  | M2
 | [NAME] |  | 0 | 0
 | [NAME] |  | 25 | 5
 | [NAME] |  | 25 | 5
 | Autopsy Q1 |  | 52 | 4
 | Autopsy Q1 |  | 52 | 4
 | [NAME] Q2 |  | 0 | 0
 | Autopsy M2 |  | 28 | 1.7
 | Autopsy M2 |  | 28 | 2
 | Autopsy M1 |  | 22 | 25
Spreadsheet: d3b2dcf5-2a06-475d-8396-274118d2ea26
Sheet: Sheet1

School | Sport | Season | Head Coach | email | Phone
 | Cross Country - Boys | Fall
 | Cross Country - Girls | Fall
 | Football | Fall
 | Golf | Fall
 | Soccer - Boys | Fall
 | Soccer - Girls | Fall
 | Volleyball | Fall
 | Cheering | Fall
 | Basketball - Boys | Winter
 | Basketball - Girls | Winter
 | Ice Hockey | Winter
 | Wrestling | Winter
 | Cheering | Winter
 | Baseball | Spring
 | Lacrosse | Spring
 | Softball | Spring
 | Tennis - Boys | Spring
 | Tennis - Girls | Spring
 | Track - Boys | Spring
 | Track- Girls | Spring
School | Athletic Director | email | Office Phone | Extension | Cell Phone
Spreadsheet: 166217d1341500835-calculating-the-highest-six-values-into-lbs-and-oz-metric-fishstory
Sheet: Improved

POS | First | Last | Series | D1 | D2 | D3 | D4 | D5 | D6 | D7 | D8 | D9 | D10 | D11 | D12 | D13 | D14
1 | Nick | [NAME] | 207 |  |  | 3.04 | 32.08 | 15.11 | 54.05 | 16.12 | 22.15 | 17.14 | 19.11 | 16.13 | 9.06 | 4.09 | 26.02
 |  |  |  |  |  |  | 32 |  | 54 |  | 22 | 17 | 19 |  |  |  | 26
 |  |  |  |  |  |  | 8 |  | 5 |  | 15 | 14 | 11 |  |  |  | 2
Spreadsheet: 72539d1273230497-lookup-values-in-2-different-workbooks-workbook-1
Sheet: Earring 1

Barcode | Code | Price | Category | Supplier
101971600001 | ER97-1 | 350 | 1 | 97
101970920002 | ER97-2 | 225 | 1 | 97
101971000003 | ER97-3 | 225 | 1 | 97
101971920004 | ER97-4 | 495 | 1 | 97
101971840005 | ER97-5 | 495 | 1 | 97
101971280006 | ER97-6 | 350 | 1 | 97
101970960007 | ER97-7 | 295 | 1 | 97
101971600008 | ER97-8 | 450 | 1 | 97
101971280009 | ER97-9 | 395 | 1 | 97
101971440010 | ER97-10 | 450 | 1 | 97
Spreadsheet: a7c4897f-1cb4-4fa1-9786-0ecff1c56216
Sheet: Statements of Cash Flows

TEXAS INSTRUMENTS INCORPORATED AND SUBSIDIARIES
Consolidated Statements of Cash Flows
(Millions of dollars)
For Three Months Ended
 |  | Sept. 30, |  | Sept. 30, |  | June 30,
 |  | 2012 |  | 2011 |  | 2012
Cash flows from operating activities:
Net income | $ | 784 | $ | 601 | $ | 446
Adjustments to net income:
Depreciation |  | 241 |  | 213 |  | 241
Stock-based compensation |  | 66 |  | 92 |  | 64
Amortization of acquisition-related intangibles |  | 86 |  | 12 |  | 86
Gains on sales of assets |  | -- |  | -5 |  | --
Deferred income taxes |  | 119 |  | 6 |  | 21
Gain on transfer of Japan substitutional pension |  | -144 |  | -- |  | --
Increase (decrease) from changes in:
Accounts receivable |  | 18 |  | 22 |  | -151
Inventories |  | 37 |  | 22 |  | -32
Prepaid expenses and other current assets |  | 25 |  | 1 |  | 50
Accounts payable and accrued expenses |  | -9 |  | 95 |  | -77
Accrued compensation |  | 95 |  | 59 |  | 75
Income taxes payable |  | -141 |  | 14 |  | -103
Other |  | 24 |  | 8 |  | 55
Cash flows from operating activities |  | 1201 |  | 1140 |  | 675
Cash flows from investing activities:
Additions to property, plant and equipment |  | -149 |  | -193 |  | -146
Proceeds from asset sales and insurance recovery |  | -- |  | 14 |  | --
Purchases of short-term investments |  | -1484 |  | -775 |  | -415
Proceeds from short-term investments |  | 173 |  | 1638 |  | 853
Purchases of long-term investments |  | -- |  | -1 |  | --
Proceeds from long-term investments |  | 20 |  | 11 |  | 29
Business acquisitions, net of cash acquired |  | -- |  | -5390 |  | --
Cash flows from investing activities |  | -1440 |  | -4696 |  | 321
Cash flows from financing activities:
Proceeds from issuance of debt |  | 1492 |  | 1200 |  | --
Issuance costs for long-term debt |  | -7 |  | -- |  | --
Repayment of debt and commercial paper borrowings |  | -500 |  | -- |  | -575
Dividends paid |  | -194 |  | -148 |  | -195
Proceeds from common stock transactions |  | 63 |  | 33 |  | 68
Excess tax benefit from share-based payments |  | 3 |  | 1 |  | 5
Stock repurchases |  | -600 |  | -450 |  | -300
Cash flows from financing activities |  | 257 |  | 636 |  | -997
Net change in cash and cash equivalents |  | 18 |  | -2920 |  | -1
Cash and cash equivalents, beginning of period |  | 1192 |  | 4501 |  | 1193
Cash and cash equivalents, end of period | $ | 1210 | $ | 1581 | $ | 1192
Spreadsheet: 487605d1478164170-settling-products-in-custom-form-receipt
Sheet: IN-OUT

 |  | Can this sheet be designed to be more handy?
 |  | Here i write when (the doc number is= I-1/1-1-2016 = IN-first transaction/date of transaction), what (according to the column of the product) and how many products i receipt
 | in
 | ID | SELLER | DOCUMENT NUMBER | PRODUCT 1 | PRODUCT 2 | PRODUCT 3 | PRODUCT 4 | PRODUCT 5 | PRODUCT 6 | PRODUCT 7 | PRODUCT 8 | PRODUCT 9 | PRODUCT 10 | PRODUCT 11 | PRODUCT 12 | PRODUCT 13 | PRODUCT 14 | PRODUCT 15 | PRODUCT 16 | PRODUCT 17 | PRODUCT 18 | PRODUCT 19 | PRODUCT 20 | PRODUCT 21 | PRODUCT 22 | PRODUCT 23 | PRODUCT 24 | PRODUCT 25 | PRODUCT 26 | PRODUCT 27 | PRODUCT 28 | PRODUCT 29 | PRODUCT 30 | PRODUCT 31 | PRODUCT 32 | PRODUCT 33 | PRODUCT 34 | PRODUCT 35 | PRODUCT 36 | PRODUCT 37 | PRODUCT 38 | PRODUCT 39 | PRODUCT 40
 | 1 | AB SELLER | I-1/1-1-2017 | 10 |  |  | 5 |  |  |  | 50
 | 2 | AB SELLER | I-2/18-1-2017 | 20 |  | 25
 | 3 | AB SELLER | I-2/14-2-2017 |  | 20
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | total
 |  | Here i write when (the doc number is= I-1/1-1-2016 = IN-first transaction/date of transaction), what (according to the column of the product) and how many products i give
 | out
 | ID | SELLER | DOCUMENT NUMBER | PRODUCT 1 | PRODUCT 2 | PRODUCT 3 | PRODUCT 4 | PRODUCT 5 | PRODUCT 6 | PRODUCT 7 | PRODUCT 8 | PRODUCT 9 | PRODUCT 10 | PRODUCT 11 | PRODUCT 12 | PRODUCT 13 | PRODUCT 14 | PRODUCT 15 | PRODUCT 16 | PRODUCT 17 | PRODUCT 18 | PRODUCT 19 | PRODUCT 20 | PRODUCT 21 | PRODUCT 22 | PRODUCT 23 | PRODUCT 24 | PRODUCT 25 | PRODUCT 26 | PRODUCT 27 | PRODUCT 28 | PRODUCT 29 | PRODUCT 30 | PRODUCT 31 | PRODUCT 32 | PRODUCT 33 | PRODUCT 34 | PRODUCT 35 | PRODUCT 36 | PRODUCT 37 | PRODUCT 38 | PRODUCT 39 | PRODUCT 40
 | 1 | AB SELLER | O-1/7-1-2017 |  |  | 35 |  |  |  |  | 15
 | 2 | AB SELLER | O-2/8-1-2017 |  |  |  |  |  |  | 80
 | 3 | AB SELLER | O-3/11-1-2017 |  |  |  |  |  |  |  |  |  | 100
 | 4 | AB SELLER | O-4/13-1-2017 | 40
 | 5 | AB SELLER | O-5/14-1-2017 |  |  |  |  |  | 155
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 20
 | 1 | AB SELLER | KKESL
 | 2 | AB SELLER | KKGDO
 | 3 | AB SELLER | [NAME]
 | 4 | AB SELLER | KKGKEM
 | total
 |  | (Cells with red font are standard and not affect anything)
 |  | Now, both of areas are only for 15 days. How can it be to have for all the year?
 |  | The design of two areas do not care how it is at the end.
Spreadsheet: 537748d1505239651-how-to-assign-an-array-name-to-a-number-value-to-use-in-hlookup-hlookup-with-multiple-tables
Sheet: Tables

 | 89MS |  |  |  |  |  |  |  |  |  | 89MNS
 |  | Starting Age |  |  |  |  |  |  |  |  |  | Starting Age
Attained Age | 0 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |  | 0 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 | 1 | 24 | 24 | 18 | 24 | 24 | 24 | 24 | 24 |  | 1 | 24 | 24 | 18 | 24 | 24 | 24 | 24 | 24
 | 2 | 24 | 24 | 26 | 24 | 24 | 24 | 24 | 24 |  | 2 | 24 | 24 | 26 | 24 | 24 | 24 | 24 | 24
 | 3 | 24 | 24 | 98 | 24 | 24 | 24 | 24 | 24 |  | 3 | 24 | 24 | 98 | 24 | 24 | 24 | 24 | 24
 | 4 | 24 | 24 | 85 | 24 | 24 | 24 | 24 | 24 |  | 4 | 24 | 24 | 85 | 24 | 24 | 24 | 24 | 24
 | 5 | 24 | 24 | 84 | 24 | 24 | 24 | 24 | 24 |  | 5 | 24 | 24 | 84 | 24 | 24 | 24 | 24 | 24
 | 6 | 24 | 24 | 86 | 24 | 24 | 24 | 24 | 24 |  | 6 | 24 | 24 | 86 | 24 | 24 | 24 | 24 | 24
 | 7 | 24 | 24 | 76 | 24 | 24 | 24 | 24 | 24 |  | 7 | 24 | 24 | 76 | 24 | 24 | 24 | 24 | 24
 | 8 | 24 | 24 | 62 | 24 | 24 | 24 | 24 | 24 |  | 8 | 24 | 24 | 62 | 24 | 24 | 24 | 24 | 24
Spreadsheet: 701982d1604027149-creating-a-new-list-with-multiple-options-sample2
Sheet: Sheet1

 |  | table a |  |  |  | table b |  |  | table b |  |  | table d
 |  | who | what | when |  | type1 |  |  | [NAME] |  |  | 4 types (type1,type6,type4,type8)
 |  | company 1 | Type1 | 1
 |  | company 2 | Type2 | 1 |  |  |  |  |  |  |  | company 3
 |  | company 3 | Type6 | 2 |  |  |  |  |  |  |  | company 7
 |  | company 4 | [NAME] | 2 |  |  |  |  |  |  |  | company 8
 |  | company 5 | Type2 | 3 |  |  |  |  |  |  |  | company 10
 |  | company 6 | Type7 | 6
 |  | company 7 | Type1 | 6
 |  | company 8 | Type4 | 7
 |  | company 9 | Type5 | 7
 |  | company 10 | Type8 | 10
Spreadsheet: 720535d1614184251-conditional-formatting-directional-arrows-seems-crazy-sample
Sheet: 30+ OverDue

WE Date | 2021-01-03 00:00:00 | 2021-01-10 00:00:00 | 2021-01-17 00:00:00 | 2021-01-24 00:00:00 | 2021-01-31 00:00:00 | 2021-02-07 00:00:00 | 2021-02-14 00:00:00 | 2021-02-21 00:00:00 | 2021-02-28 00:00:00 | 2021-03-07 00:00:00
Account Manager | 791384.5199999998 | 766934.2599999997 | 749770.4199999997 | 730484.6099999998 | 758513.2699999998
User2 | 274731.29 | 275228.08 | 253444.74 | 248419.0799999999 | 256929.9499999999
User3 | 36758.99 | 36758.99 | 36758.99 | 36758.99 | 36758.99
User4 | 343685.7599999998 | 342100.0499999998 | 336495.4499999997 | 328906.5699999998 | 337180.5299999998
[NAME] | 136208.48 | 112847.14 | 123071.24 | 116399.97 | 127643.8