tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 690406d1597083073-using-sum-and-count-function-in-a-pivot-table-summary-consolidated-sheet
Sheet: 10082020

 |  | [NAME] | [NAME] | JO/20/197 HRS | JO/20/197 OT | JO/20/188 HRS | JO/20/188 OT | [NAME] | JO/20/204 OT | JO/20/144 HRS | JO/20/144 OT | JO/20/219 HRS | JO/20/219 OT | [NAME] | [NAME] | JO/20/202 HRS | JO/20/202 OT | JO/20/193 HRS | JO/20/193 OT | JO/20/218 HRS | JO/20/218 [NAME] | JO/20/083 HRS | JO/20/083 OT | [NAME] | [NAME] | CPC HRS | CPC OT | YARD1 CLEANING HRS | YARD1 CLEANING OT | YARD2 CLEANING  HRS | [NAME] | ADMIN WORKS  HRS | ADMIN WORKS  OT | Maintainance / Other works  HRS | Maintainance / Other works  OT
1 | MATHEW |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
2 | KESHVAN |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
3 | SIVADAS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
4 | ANSARI |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
5 | RAGESH | 8
6 | MUKUNDA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
7 | ABBASI |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
8 | UPENDRA
9 | MARTIN
22 | SAMUEL |  |  | 8
10 | FELIX |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 |  |  |  |  |  |  |  | 3
11 | DIPAK |  |  | 2 |  |  |  |  |  | 2 |  |  |  |  |  |  |  | 4
12 | SATHYA
13 | RAJEEV | 8
16 | [NAME] | 8
 | [NAME] |  |  |  |  |  |  | 8
17 | FLORENCIO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
14 | VINOTH |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
15 | RAJA
19 | [NAME]
24 | SON |  |  |  |  |  |  |  |  | 5 |  |  |  |  |  |  |  | 3
 | MANSA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 |  |  |  |  |  |  |  | 3
25 | SIMHA
18 | MALIK | 2 |  |  |  |  |  | 2 |  |  |  | 2 |  | 2
20 | SIVA | 2 |  |  |  |  |  |  |  |  |  | 1 |  | 2 |  | 3
 | GEORGE | 2 |  |  |  |  |  |  |  |  |  | 1 |  | 2 |  | 3
21 | SUDHI |  |  |  |  |  |  |  |  | 5 |  |  |  |  |  |  |  | 3
23 | RAVI |  |  |  |  | 6 |  |  |  |  |  | 2
 | HEMA |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
35
COMMENTS :
Spreadsheet: darrell_schoolcraft__7335__imball0203
Sheet: EPFS

 | El Paso/TW Eddy Rec
 | 78093
Day | Measured | Scheduled
1 | 39085 | 35000
2 | 38663 | 35000
3 | 38140 | 35000
4 | 37343 | 35000
5 | 26604 | 35000
6 | 39621 | 35000
7 | 31916 | 35000
8 | 39638 | 35000
9 | 30611 | 32672
10 | 32135 | 32539
11 | 34655 | 33600
12 | 33469 | 32949
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2002-02-28 00:00:00 |  |  | 166939.17
2002-03-12 00:00:00
CBS Volume
 |  |  | 93375
Spreadsheet: 129447d1321619081-compare-columns-and-detect-changes-videobeispiel
Sheet: itemlist2

BMK | Page
-WD5007 | 172
-WD5012 | 180
-WD5013 | 180
-WD5014 | 180
-WD5015 | 180
[NAME] | 180
-WDz5036 | 170
-Wz3031 | 170
-Wz3031 | 170
Spreadsheet: 714040d1611068043-comparing-text-and-numbers-to-output-a-text-test-spreadsheet-etaf
Sheet: Matrix

LOOKUP TABLE
S6 | P6 | W6
1 | Automated | ? |  |  | What I am trying to get [NAME] to do is a condition check of the Consequence number S6 (0-5)and the urgency P6 (Automated,Immediate,Prompt, Soon or [NAME]" to show "Event", "Low", "Medium" or "High" based on the matrix on the original post
1 | Immediate
1 | Prompt
1 | Soon
1 | Event
2 | Automated
2 | Immediate
2 | Prompt
2 | Soon
2 | Event
3 | Automated
3 | Immediate
3 | Prompt
3 | Soon
3 | Event
4 | Automated
4 | Immediate
4 | Prompt
4 | Soon
4 | Event
5 | Automated
5 | Immediate
5 | Prompt
5 | Soon
5 | Event
Spreadsheet: 271731d1382029868-accounts-payable-trying-to-get-daily-updates-payables1
Sheet: G de. Desp

Company | Item | Guia | Date | Amount
Dimacofi | Passport Covers | 46326 | 2013-09-24 00:00:00 | 98244
Dimacofi | Kids flyers | 46164 | 2013-08-20 00:00:00 | 238656
Dimacofi |  | 46201 | 2013-08-26 00:00:00 | 9428
Option | Pendones | 3639
Spreadsheet: 539280d1506023424-formula-help-summing-a-crosstable-with-multiple-criteria-sumproduct-sumif
Sheet: Sheet1

 | Data Set |  |  |  |  |  | Summary
 |  | Month 1 | Month 1 | Month 2 | Month 2 |  |  | Month 1 | Month 1 | Month 2 | Month 2
 |  | Revenue | Units | Revenue | Units |  |  | Revenue | Units | Revenue | Units
 | Customer 1 |  | 34 | 62297 | 95 |  | Customer 1
 | Customer 1 |  | 26 | 52024 | 40 |  | Customer 2
 | Customer 2 |  | 14 | 34405 | 70
 | Customer 2 |  | 66 | 38577 | 24
Spreadsheet: 754868d1636549596-sort-without-zeros-sort-and-zeros
Sheet: sort

a | 1 |  |  | 6 |  |  | a | 1
b | 2 |  | 0 | 7 |  |  | b | 2
0 | 6 |  | 0 | 8 |  |  | c | 3
c | 3 | --> | 0 | 9 |  | i want | d | 4
d | 4 |  | a | 1 |  |  | e | 5
0 | 7 |  | b | 2
0 | 8 |  | c | 3
0 | 9 |  | d | 4
e | 5 |  | e | 5
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | formula
 |  |  | SORT(A1:B11;1;1)
Spreadsheet: 327665d1403638149-concatenate-variable-ranges-of-character-strings-tasasupd_0529upd-ans2
Sheet: Sheet1

ACC_SET |  | NUM_REC | CASE_TYPE | OCCUPANT_KILLED_AMT | OCCUPANT_INJURED_AMT | [NAME]
3471063 | ? | 2 | 1 | 0 | 0 | IF (ACC_SET) (has?) 2 REC with VAL = >0 [NAME] (CHOOSE/CHOICE) (1st or 2nd) REC
3471063 | ? |  |  | 0 | 0
3473103 | ? | 3 | 2 | 0 | 0 | IF (ACC_SET) (has?) > 2 REC with VAL = >=0(??) [NAME] (CHOOSE/CHOICE) () REC
3473103 | ? |  |  | 0 | 0
3473103 | ? |  |  | 0 | 0
3471058 | ? | 2 | 3 | 0 | 0 | IF (ACC_SET) = 2 and (EITHER/OR) (OCC_I) (OCC_K) AMT >= 1 THEN DEL ACC_NUM WITH REC = 0
3471058 | ? |  |  | 0 | 1
3495769 | ? | 3 | 4 | 0 | 0 | IF (ACC_SET) > 2 and 1 VAL  AMT >= 1 THEN DEL ALL ACC_NUM WITH REC = 0
3495769 | ? |  |  | 0 | 3
3495769 | ? |  |  | 0 | 0
3538007 | ? | 2 | 5 | 0 | 2 | IF ACC_NUM SET (HAS) 2 REC >= 1 THEN DEL (CHOOSE?/CHOICE) REC WITH SMALLEST VAL/< FIRST VAL
3538007 | ? |  |  | 0 | 1
3619196 | ? | 4 | 6 | 0 | 0 | IF (ACC_SET) (has? )> 2 REC with ID VAL = >0 [NAME] (CHOOSE/CHOICE) (?) REC
3619196 | ? |  |  | 0 | 0
3619376 | ? |  |  | 0 | 0
3619376 | ? |  |  | 0 | 0
3619196 | ? | 4 | 6 | 0 | 0 | IF (ACC_SET) (has? )> 2 REC with ID VAL = >0 [NAME] (CHOOSE/CHOICE) (?) REC
3619196 | ? |  |  | 0 | 0
3619376 | ? |  |  | 0 | 0
3619376 | ? |  |  | 0 | 0
Spreadsheet: 113796d1309648718-using-a-cels-value-in-the-formula-dynamicchart
Sheet: calculator

 |  |  |  |  |  |  |  | martin | stuff
 |  |  |  |  |  |  |  | [NAME] | 10
 |  |  |  |  |  |  |  | [NAME] | 3
 |  |  |  |  |  |  |  | [NAME] | 7
 |  |  |  |  |  |  |  | [NAME] | 3
 |  |  |  |  |  |  |  | [NAME] | 5
 |  |  |  |  |  |  |  | [NAME] 6 | 3
 |  |  |  |  |  |  |  | [NAME] | 4
 |  |  |  |  |  |  |  | [NAME] | 5
 |  |  |  |  |  |  |  | [NAME] | 6
 |  |  |  |  |  |  |  | [NAME] 10 | 2
 |  |  |  |  |  |  |  | [NAME] | 4
 |  |  |  |  |  |  |  | [NAME] 12 | 6
 |  |  |  |  |  |  |  | [NAME] 13 | 3
 |  |  |  |  |  |  |  | [NAME] 14 | 2
 |  |  |  |  |  |  |  | [NAME] 15 | 6
 |  |  |  |  |  |  |  | [NAME] 16 | 7
 |  |  |  |  |  |  |  | [NAME] 17 | 3
 |  |  |  |  |  |  |  | [NAME] 18 | 5
 |  |  |  |  |  |  |  | [NAME] 19 | 6
Spreadsheet: 750455d1633459002-auto-populate-table-columns-matching-criteria-wip-ef-hr-recruitment-tracker
Sheet: Settings

 | Locations |  | Department |  | Phase | Order |  | LA | Offered | Hired | Target
 | LA |  | Driver |  | Offered | 1 |  | Driver |  |  | 10
 | SF |  | Warehouse |  | Pending - Background Check | 2 |  | Warehouse |  |  | 20
 |  |  | Merch |  | Pending - Drug Test | 3 |  | Merch |  |  | 30
 |  |  |  |  | Scheduled for Orientation | 4
 |  |  |  |  | Hired | 5
 |  |  |  |  | Failed Pre-Employment Screening | 6 |  | SF | Offered | Hired | Target
 |  |  |  |  |  |  |  | Driver | *** | *** | 10
 |  |  |  |  |  |  |  | Warehouse | *** | *** | 20
 |  |  |  |  |  |  |  | Merch | *** | *** | 30
Spreadsheet: 58a4c2c0-9ba9-48da-af6d-ae8517f3ee82
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2011-06-13 12:52:42.270000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.75 | 101.739 | 101.614 | 101.489 | 101.114 |  | and are added to price quote
4.625 | 100.797 | 100.672 | 100.547 | 100.172
4.5 | 100.326 | 100.201 | 100.076 | 99.701 |  | Note: | Refer To Price [NAME]
4.375 | 99.716 | 99.591 | 99.466 | 99.091 |  |  | For all Price Adjs
4.25 | 98.623 | 98.498 | 98.373
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4.125 | 101.798 | 101.673 | 101.548 | 101.173
4 | 101.478 | 101.353 | 101.228 | 100.853
3.875 | 101.085 | 100.96 | 100.835 | 100.46
3.75 | 100.514 | 100.389 | 100.264 | 99.889
3.625 | 99.417 | 99.292 | 99.167
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2011-06-27 12:52:42.270000
30 DAY | 2011-07-12 12:52:42.270000
45 DAY | 2011-07-27 12:52:42.270000
60 DAY | 2011-08-11 12:52:42.270000
90 DAY | 2011-09-10 12:52:42.270000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: darrell_schoolcraft__7283__saledoc03_13TW
Sheet: Sheet1

Transwestern Pipeline Company
GAS [NAME]
 | GAS SALE INFORMATION |  |  |  |  | PURCHASE PARTY
Account Manager |  |  | [NAME] |  |  | Company: |  | Richardson Products
Deal Date: |  |  | 2002-03-12 00:00:00 |  |  | Contact Name: |  | [NAME]
Gas Sale Date (s) |  |  | 3/13/2002 |  |  | FAX Number:
Total Quantity |  |  | 32740 | MMBtu |  | Address: |  | Phone: [PHONE]
Gas Sale Price |  | 16350 | 2.77
 |  | 16350 | [NAME]
GAS SALE TERMS
 |  | Contract Quantity (MMBtu)
SALE DATES |  |  |  | Daily
Start | End | Monthly |  | Min |  | [NAME] |  | Other
3/13/2002 | 2002-03-13 00:00:00 | 32740 |  | 32740 |  | 32740
RELATED SCHEDULING AND TRANSPORTATION REQUIREMENTS
Tranwestern Receipt/Delivery Point |  |  |  |  |  |  | DOWNSTREAM |  | TW UPSTREAM
Name |  |  | POI # |  | Daily Volume |  | Contract # |  | Contract Number
West Texas Pool |  |  | 58649 |  | 32740 |  |  |  | 22948
 |  |  | BILLING BY THIRD PARTY |  |  |  |  | Please direct all invoices to:
 |  |  | Month [NAME] Rec'd |  | Expected [NAME] |  |  | Debbie Mosely
 |  |  |  |  | To be determined |  |  | Transwestern Pipeline Company
 |  |  |  |  |  |  |  | P.O. Box 1188
 |  |  |  |  |  |  |  | Houston, TX  77251-1188
Comments:
Buyer: Please acknlowledge confirmation of the above deal by signing below and faxing this confirmation to:
[NAME] [PHONE]   Phone [PHONE]
Gas Buyer Signature |  |  |  |  |  |  | Date:
TW Acct Manager Signature |  |  |  |  |  |  | Date:
Spreadsheet: 89216e77-4ded-434c-b442-1095565ba839
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
RASE | Test | RASE | Rape Seed, IgE | Rape Seed, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top	 Acceptable: Serum gel	 [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
RASE | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
RASE | Result | RASE | Rape Seed, IgE | Rape Seed, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 11195-5 | [NAME] rapa Ab.IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: 708027d1607591411-how-to-report-the-top-20-and-bottom-20-of-a-data-table-report-with-2-conditions-dashboard
Sheet: ITALY

Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Top 5  lowest price | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Top 5  highest price | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Antenna cable | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | [NAME] | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Charger | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Recheargable battery | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Full swim kit | AB | MedEL | Cochlear | OM | Custom label
Spreadsheet: f2f19137-7f04-44f6-abfb-602ee86a1678
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
BMNA | Test | BMNA | Breast Milk Nutritional Analysis | Breast Milk Nutritional Analysis | Thin-Layer Chromatography (TLC)/Colorimetry/Spectrophotometry (SP)/Other Methodologies as Appropriate | Plastic container: PlCont |  |  | 5 | mL | Container/Tube: Tightly-sealed, plastic container [NAME]: 5 mL Collection Instructions: 1. Specimen must be labeled with the mother's name (not the baby's). 2. Indicate mother's age. | 4 mL | Hemolysis	NA Thawing	Warm reject; Cold reject Lipemia	NA Icterus	NA Other	NA | Post-Partum Day 1	Post-Partum Day 36 Glucose	15-40 mg/dL	15-40 mg/dL Lactose	2,100-6,000 mg/dL	2,700-8,000 mg/dL Triglycerides	420-3,900 mg/dL	1,600-6,400 mg/dL Proteins	1,200-4,700 mg/dL	880-1,920 mg/dL | Monday through Friday; Continuously | 4 days | 7 days |  | Profile |  |  |  |  | Rochester
BMNA | [NAME] | BRSTMLK | Breast Milk |  |  |  | Frozen | 150 days
BMNA | Result | GLBMA | Glucose | Glucose | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 2344-0 | Glucose:MCnc:Pt:Body fld:Qn:
BMNA | Result | LACT | Lactose | Lactose | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | In Process
BMNA | Result | TGBMA | Triglycerides | Triglycerides | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 12228-3 | Triglyceride:MCnc:Pt:Body fld:Qn:
BMNA | Result | PTBMA | Proteins | Proteins | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 2881-1 | Protein:MCnc:Pt:Body fld:Qn:
BMNA | Billing Component | BMNA |  | Protein, Total |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 84157
BMNA | Billing Component | BMNA |  | Glucose, Quantitative |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 82945
BMNA | Billing Component | BMNA |  | Triglycerides |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 84478
Spreadsheet: 158847d1338407191-basic-countif-function-01f
Sheet: Sheet1

Date |  | week num
2011-01-01 00:00:00 |  | 1 | 1 2011
2011-01-02 00:00:00 |  | 2 | 2 2011
2011-01-03 00:00:00 |  | 2 | 2 2011
2011-05-19 00:00:00 |  | 21 | 21 2011
2012-05-19 00:00:00 |  | 20 | 20 2012
2012-04-01 00:00:00 |  | 14 2012
2011-04-01 00:00:00 |  | 14th week of 2011
2013-05-05 00:00:00 |  | 19th week of 2013
2013-05-06 00:00:00 |  | 19th week of 2013
2013-05-07 00:00:00 |  | 19th week of 2013 |  |  |  |  |  | 0
2013-05-08 00:00:00 |  | 19th week of 2013 |  |  |  |  |  | 3
2013-05-09 00:00:00 |  | 19th week of 2013
2013-05-10 00:00:00 |  | 19th week of 2013
Spreadsheet: vkaminski__40781__book summary
Sheet: fob deals

 |  |  |  | HG - QATAR TO ELBA |  |  | NEW - ALGERIA TO ELBA |  |  | NEW - VENEZUELA TO ELBA
 | BOOK TOTAL |  |  | Interbook -HG (Qatar) |  |  | Interbook - new (Algeria) |  |  | Interbook - new (Ven)
DEAL # |  |  |  | 1 |  |  | 5 |  |  | 5
DEAL DATE |  |  |  | 2000-06-07 00:00:00 |  |  | 2000-06-07 00:00:00 |  |  | 2000-06-07 00:00:00
COUNTERPARTY |  |  |  | CIF BOOK |  |  | CIF BOOK |  |  | CIF BOOK
START |  |  |  | 2002-04-01 00:00:00 |  |  | 2003-01-01 00:00:00 |  |  | 2004-01-01 00:00:00
END |  |  |  | 2003-12-01 00:00:00 |  |  | 2003-12-01 00:00:00 |  |  | 2025-12-01 00:00:00
VOLUME |  |  |  | -1297972 |  |  | -3720184.28571429 |  |  | -5016515.625
PRICE |  |  |  | 1 |  |  | 1 |  |  | 2.3
 | POS | P&L |  | POS | P&L |  | POS | P&L |  | POS | P&L
Total
Spreadsheet: 844779d1696457361-sorting-by-groups-of-cells-sortbygroup
Sheet: Sheet1

 | Main Group | Purchase Description | Purchase Cost | Running Total
 | AAA | PARTS FOR A | 20
 | AAA | PARTS FOR A | 20
 | BBB | PARTS FOR B | 10
 | BBB | PARTS FOR B | 10
Spreadsheet: 167834d1342115478-autopopulating-with-headings-and-spaces-vlookup-to-combine-cells-example-1
Sheet: Sheet1

5700 - 2000 | Office Supplies - Program 1 |  |  |  |  |  |  | 0 | Dr
5700 - 2000 | Office Supplies - Program 1 | 2011-04-11 00:00:00 | Computers | 11111 | J123 | 100 | 0 |  | Dr
5700 - 2000 | Office Supplies - Program 1 | 2011-04-28 00:00:00 | Computers | 11111 | J123 | 105 | 0 |  | Dr
5700 - 2000 | Office Supplies - Program 1 | 2011-08-05 00:00:00 | Computers | 11111 | J123 | 110 | 0 |  | Dr
5700 - 2000 | Office Supplies - Program 1 | 2011-10-19 00:00:00 | Computers | 11111 | J123 | 115 | 0 |  | Dr
5700 - 2000 | Office Supplies - Program 1 | 2012-02-06 00:00:00 | Computers | 11111 | J123 | 120 | 0 |  | Dr
5700 - 2000 | Office Supplies - Program 1 | 2012-01-31 00:00:00 | Computers | 11111 | J123 | 125 | 0 |  | Dr
5700 - 2000 | Office Supplies - Program 1 | 2012-01-31 00:00:00 | Computers | 11111 | J123 | 130 | 0 |  | Dr
5700 - 2100 | Office Supplies - Program 2 |  |  |  |  |  |  | 0 | Dr
 |  | 2011-04-01 00:00:00 | Computers | 11111 | J123 | 200 | 0 |  | Dr
 |  | 2011-05-02 00:00:00 | Computers | 11111 | J123 | 205 | 0 |  | Dr
 |  | 2011-05-24 00:00:00 | Computers | 11111 | J123 | 210 | 0 |  | Dr
 |  | 2011-04-01 00:00:00 | Computers | 11111 | J123 | 215 | 0 |  | Dr
 |  | 2012-03-08 00:00:00 | Computers | 11111 | J123 | 220 | 0 |  | Dr
 |  | 2012-03-31 00:00:00 | Computers | 11111 | J123 | 225 | 0 |  | Dr
5700 - 2200 | Office Supplies - Program 3 |  |  |  |  |  |  | 0 | Dr
 |  | 2011-04-01 00:00:00 | Computers | 11111 | J123 | 300 | 0 |  | Dr
 |  | 2011-05-02 00:00:00 | Computers | 11111 | J123 | 305 | 0 |  | Dr
 |  | 2011-05-24 00:00:00 | Computers | 11111 | J123 | 310 | 0 |  | Dr
 |  | 2011-04-01 00:00:00 | Computers | 11111 | J123 | 315 | 0 |  | Dr
 |  | 2012-03-08 00:00:00 | Computers | 11111 | J123 | 320 | 0 |  | Dr
 |  | 2012-03-31 00:00:00 | Computers | 11111 | J123 | 325 | 0 |  | Dr
Spreadsheet: 851215d1701439883-mixing-lines-that-get-a-reference-colum-2-posatl-only
Sheet: Feuil1

 | 10300 SAINTE-SAVINE | Internet, téléphonie fixes, mobiles & communication unifiée | Les équipes de Christophe BARDON s’engagent au quotidien pour vous apporter qualité et satisfaction. |  | example: |  | Internet, téléphonie fixes, mobiles & communication unifiée Dématérialisation des documents, archivage et GED Multifonctions, photocopieurs, imprimantes et traceurs Sécurité et protection de votre réseau informatique | Les équipes de Christophe BARDON s’engagent au quotidien pour vous apporter qualité et satisfaction.
 | 10300 SAINTE-SAVINE | Dématérialisation des documents, archivage et GED | Les équipes de Christophe BARDON s’engagent au quotidien pour vous apporter qualité et satisfaction. |  |  | 10410 | Internet, téléphonie fixes, mobiles & communication unifiée Dématérialisation des documents, archivage et GED Multifonctions, photocopieurs, imprimantes et traceurs Sécurité et protection de votre réseau informatique | Les équipes de Christophe BARDON s’engagent au quotidien pour vous apporter qualité et satisfaction.
 | 10300 SAINTE-SAVINE | Multifonctions, photocopieurs, imprimantes et traceurs | Les équipes de Christophe BARDON s’engagent au quotidien pour vous apporter qualité et satisfaction.
 | 10300 SAINTE-SAVINE | Sécurité et protection de votre réseau informatique | Les équipes de Christophe BARDON s’engagent au quotidien pour vous apporter qualité et satisfaction.
 | 10410 SAINT-PARRES-AUX-TERTRES | Internet, téléphonie fixes, mobiles & communication unifiée | Les équipes de Christophe BARDON s’engagent au quotidien pour vous apporter qualité et satisfaction.
 | 10410 SAINT-PARRES-AUX-TERTRES | Dématérialisation des documents, archivage et GED | Les équipes de Christophe BARDON s’engagent au quotidien pour vous apporter qualité et satisfaction.
 | 10410 SAINT-PARRES-AUX-TERTRES | Multifonctions, photocopieurs, imprimantes et traceurs | Les équipes de Christophe BARDON s’engagent au quotidien pour vous apporter qualité et satisfaction.
 | 10410 SAINT-PARRES-AUX-TERTRES | Sécurité et protection de votre réseau informatique | Les équipes de Christophe BARDON s’engagent au quotidien pour vous apporter qualité et satisfaction.
Spreadsheet: 677398d1589335898-averageifs-with-multiple-criteria-sample1234ab
Sheet: Sheet1

Type of Material | Quantities | Sales for 2018 | Sales for 2019
Silk | 20 | 456090 | 366322
Silk/Deim | 50 | 326555 | 890000
Cotton/Silk | 80 | 672222
Polyester | 30
Wool | 20 |  | 652300
Cotton/Wool | 60 | 35690