tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 233844d1367939144-making-calendar-oskar
Sheet: Mar

Date
2013-03-01 00:00:00
2013-03-02 00:00:00
2013-03-03 00:00:00
2013-03-04 00:00:00
2013-03-05 00:00:00
2013-03-06 00:00:00
2013-03-07 00:00:00
2013-03-08 00:00:00
2013-03-09 00:00:00
2013-03-10 00:00:00
2013-03-11 00:00:00
2013-03-12 00:00:00
2013-03-13 00:00:00
2013-03-14 00:00:00
2013-03-15 00:00:00
2013-03-16 00:00:00
2013-03-17 00:00:00
2013-03-18 00:00:00
2013-03-19 00:00:00
2013-03-20 00:00:00
2013-03-21 00:00:00
2013-03-22 00:00:00
2013-03-23 00:00:00
2013-03-24 00:00:00
2013-03-25 00:00:00
2013-03-26 00:00:00
2013-03-27 00:00:00
2013-03-28 00:00:00
2013-03-29 00:00:00
2013-03-30 00:00:00
2013-03-31 00:00:00
Spreadsheet: ffab5255-7613-4321-82cb-0219ecead059
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
FGAMS | Test | FGAMS | [NAME] (FGA) Gene, Full Gene Analysis | [NAME], Full Gene Analysis | Polymerase Chain Reaction (PCR) Followed by DNA Sequence Analysis (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | VACUTAINER: VAC |  |  | 3 | mL | [NAME] must arrive within 96 hours of draw.   [NAME] blood Container/Tube: Preferred: Lavender top (EDTA) or yellow top (ACD) Acceptable: Any anticoagulant [NAME]: 3 mL Collection Instructions: 1. Invert several times to mix blood. 2. Send specimen in original tube. Forms: 1. Molecular Genetics-Congenital Inherited Diseases Patient Information Sheet (Supply T521) in Special Instructions 2. 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.5 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	Plasma or serum | An interpretive report will be provided. | Friday, 10 am | 14 days | 20 days | 1 | 81479 |  |  |  |  | Rochester
FGAMS | [NAME] | VARIES | Varies |  |  |  | Ambient
FGAMS | Result | 33470 | [NAME] | [NAME] | Alphanumeric
FGAMS | Result | 33471 | [NAME] | [NAME] | Alphanumeric
FGAMS | Result | 33472 | Source | Source | Alphanumeric
FGAMS | Result | 33473 | Order Date | Order Date | Alphanumeric
FGAMS | Result | 33474 | Reason for Referral | Reason for Referral | Alphanumeric
FGAMS | Result | 33475 | Method | Method | Alphanumeric
FGAMS | Result | 33476 | Result | Result | Alphanumeric
FGAMS | Result | 33477 | Interpretation | Interpretation | Alphanumeric
FGAMS | Result | 33478 | Amendment | Amendment | Alphanumeric
FGAMS | Result | 33479 | Reviewed By | Reviewed By | Alphanumeric
FGAMS | Result | 33480 | Release Date | Release Date | Alphanumeric
Spreadsheet: 721282d1614623435-excel-index-match-retrieving-multiple-columns-of-data-excel-question-00237440xc6a08-
Sheet: By Company- DF

DentFirst Yield Worksheet (Closed) |  |  |  |  |  |  | Total Weighted Average Investor Yield =
Investor | Investment | Date | Status | Principal Payment Amount | Total Payment Amount | IRR | Weight Factor | Total Weight Factor
Total
2020
2019
2018
2017
Spreadsheet: 080bec70-b34c-42b7-9ada-aa07906c7155
Sheet: Schulen

Archiv -Nr. | Titel der Sammlung | Titel der Komposition | Anmerkung | Komponist | Arrangeur | [NAME] | Besetzung | Anmerkung
Sch/001 | Stief Bd.9 | Die Jagdhornbläsergruppe |  | Stief Reinhold |  | Hubertus-Produktion
Sch/002 |  | Alphornschule |  | Studer u.a. |  | [NAME] |  | Alphornschule
Sch/003 |  | Das Naturhorn |  | Freund Robert |  | Doblinger |  | Waldhornschule
Sch/004 |  | [NAME] |  | Fensterer Manfred |  | BLV - Verlag |  | [NAME]
Sch/005 |  | Naturhornschule |  | [NAME] v. |  | [NAME] |  | 160 Übungen f. Naturhorn
Sch/006 |  | Naturhornschule Es |  | Huber Richard |  | WWV |  | Naturhornschule
Sch/007 |  | Fürst Pleß-Horn Schule |  | Huber Richard |  | Österr, [NAME]-u.Fischerei-V.
Sch/008 | Es/491 | 20 Übungen f.Tiefes Pfh. |  | Huber Richard |  | Eigenverlag Huber
Sch/009 | Es/492 | 25 Stimmübungen f.Tiefes Pf. |  | Huber Richard |  | Eigenverlag Huber
Sch/010 |  | Große [NAME] u. Waldhorn |  | ?? |  | ??
Sch/011 |  | Methode complete de T.d.Ch. |  | [NAME] |  |  |  | Theorie
Sch/012 |  | Die deutschen Jagdsignale |  |  |  |  |  | Studierhilfe v. [NAME]
Sch/013 |  | [NAME]. Jh. |  | [NAME] |  | Zimmermann -Frankfurt
Sch/014 | LESNICA (Slowakei) | Schule u.einfache Spielst.
Spreadsheet: 606f30fa-082d-4f1a-af2c-f6bac7782438
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | SDO Reimbursement Identification: | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 |  |  |  |  | Business Unit Name |  |  |  |  |  | Business Unit Number
 |  |  |  |  | Local Purchase Number |  |  |  |  |  | Date Prepared (month, day, year)
Vendor ID Number |  |  | Bank Name | Invoice Number | Invoice Line Number | Date Paid | Fund | [NAME] | Program | Project | Payment Amount | Encompass Voucher ID
[NAME] |  |  | Bank Acct # | Invoice Date | Line Description | Check Number | Account | Department | Line Amount | Activity
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
I certify that the above claim of the vendors named hereon are just and legal charges against the State of Indiana; that the articles and services named thereon were contracted for in accordance with the authority granted in the above-numbered Authority for local Purchases; and that the said articles and services have been settled in full from the moneys advanced to me as a Special Disbursing Officer under said Authority for Local Purchases. |  |  |  |  |  |  |  |  | Grand Total |  | 0
Special Disbursing Officer Vendor Identification |  |  |  | Special Disbursing Officer Name |  | Signature of Special Disbursing Officer |  |  |  |  | Date Signed (month, day, year)
Spreadsheet: 750208d1633343460-count-number-of-series-ytd
Sheet: Times

Level | 00:00 | 01:00 | 02:00 | 03:00 | 04:00 | 05:00 | 06:00 | 07:00 | 08:00 | 09:00 | 10:00 | 11:00 | 12:00 | 13:00 | 14:00 | 15:00 | 16:00 | 17:00 | 18:00 | 19:00 | 20:00 | 21:00 | 22:00 | 23:00
0
1
2
3
4
Total
Spreadsheet: 69977d1270641718-excel-2007-sorting-data-that-is-split-with-merged-cells-tenantlist-1-
Sheet: Sheet1

Name & Contact Numbers | Beds | Baths | Other | Points To Remember | [NAME] | Occupation | Areas | Date Contacted
Fifi | 2 | 1 | 1 lounge | Interested in Bloubosrand unit | 14000 | Immediate | Johannesburg | 2010-03-31 00:00:00
076 *** 8888 |  |  | 1 dining | 137 Bridgetown, [NAME] |  |  | Sunninghill
fifi@****.com |  |  | 1 study
Fifi | 2 | 1 | 1 lounge | Interested in Bloubosrand unit | 14000 | Immediate | Johannesburg | 2010-03-31 00:00:00
076 *** 8888 |  |  | 1 dining | 137 Bridgetown, [NAME] |  |  | Sunninghill
fifi@****.com |  |  | 1 study
Spreadsheet: 762544d1641628853-vlookup-for-multiple-criteria-vlookup
Sheet: Sheet1

 |  |  |  |  |  |  |  | Expected Results
MUD ID | Name | Category | DM Closed | Request | Incident |  |  | DM Closed | Request | Incident
[NAME] | A | Training |  |  |  |  |  | 1 | 0 | 0
cb832551 | B | Training |  |  |  |  |  | 0 | 0 | 0
dvr95541 | C | Training |  |  |  |  |  | 0 | 0 | 1
gg336016 | D | Training |  |  |  |  |  | 1 | 0 | 0
md891090 | E | Training |  |  |  |  |  | 0 | 0 | 1
mg104360 | F | Training |  |  |  |  |  | 0 | 1 | 0
nm846496 | G | Training |  |  |  |  |  | 0 | 1 | 0
Spreadsheet: 106176fd-52fc-4e78-bb3e-3b252449e8a6
Sheet: Sheet1

Unnamed: 0 | id | Alunni | Media | Italiano | Inglese | Francese | Storia, [NAME] | Geografia | Matematica | Scienze | Tecnologia | Musica | Arte e Immagine | Educazione Fisica | Comportamento | Religione
 | 5853 | [NAME] | 6.98 |  | 6.7 | 8.3 | 7.4 | 7.1 | 6.2 | 7.5 | 6.8 | 6.3 | 7.5 | 6
 | 5854 | BOGLIONI ALESSANDRO MARIO | 9.02 |  | 9.2 | 9.7 | 9.4 | 9.5 | 9.1 | 9.2 | 9.3 | 8.6 | 9 | 7.2 |  | Distinto
 | 5855 | BOSCARO MASSIMO | 7.58 |  | 7.8 | 8.3 | 8.2 | 7.8 | 7.9 | 8.2 | 5.7 | 7 | 8.2 | 6.7 |  | Discreto
 | 5856 | CAPUTO ALESSANDRO | 7.18 |  | 6.4 | 7 | 7.4 | 7.4 | 7 | 6.2 | 6.6 | 7.8 | 8 | 8 |  | Buono
 | 5857 | CORSARO ILARIA | 7.04 |  | 6.8 | 8.2 | 6.8 | 7.5 | 7.2 | 5.8 | 6.2 | 6.6 | 8.3 | 7 |  | Sufficiente
 | 5858 | DALE' NICLA | 5.84 |  | 5.8 | 6.8 | 5.6 | 4.7 | 4.8 | 5.8 | 5.8 | 5.8 | 6.5 | 6.8
 | 5859 | DE VECCHI ALESSANDRO | 9.26 |  | 9.4 | 9.9 | 9.6 | 9.8 | 9.2 | 9.2 | 8.8 | 9.9 | 9.8 | 7 |  | Ottimo
 | 5860 | FAWZY YOUAKIM VALENTINA | 7.56 |  | 8.1 | 8.6 | 7.8 | 7.8 | 7 | 7.3 | 6.2 | 7.5 | 8 | 7.3 |  | Buono
 | 5862 | [NAME]' MARICA | 8.41 |  | 9.6 | 9.2 | 8.2 | 8.2 | 7.5 | 8 | 6.6 | 8.8 | 10 | 8 |  | Distinto
 | 5863 | GARIBOLDI FILIPPO | 7.3 |  | 8.3 | 8.2 | 7.9 | 6.5 | 7 | 7.2 | 5.9 | 8.2 | 7.8 | 6 |  | Buono
 | 5864 | [NAME] | 7.87 |  | 7.4 | 8.7 | 8.2 | 8.4 | 7.8 | 7.2 | 7.1 | 7.2 | 9 | 7.7 |  | Buono
 | 5865 | GREMI OSMEN | 6.68 |  | 6.8 | 6 | 7.5 | 6.5 | 6.5 | 7.2 | 6.1 | 6.9 | 6.3 | 7
 | 5866 | JOVANOVIC DUSKO | 5.16 |  | 6 | 7.1 | 5.4 | 4 | 4 | 6 | 4.4 | 4 |  | 5.5 |  | Discreto
 | 6435 | LIN RIXIN | 6.44 |  | 6.4 | 5.9 | 5.7 | 5 | 6.6 | 7 | 6.8 | 6.9 |  | 7.7
 | 5867 | MESSINA GIULIA | 7.07 |  | 7.6 | 8.6 | 7.9 | 7.3 | 6.6 | 5.8 | 5.2 | 8.2 | 6.8 | 6.7 |  | Discreto
 | 5868 | METUSHI ISAURA | 6.41 |  | 6.5 | 6.8 | 5.6 | 5.3 | 5.9 | 6.2 | 5.6 | 7.5 | 8 | 6.7 |  | Non sufficiente
 | 5869 | OSNAGHI RICCARDO | 8.26 |  | 7 | 9 | 8.7 | 9.1 | 8.6 | 7.8 | 7.7 | 8.4 | 8.8 | 7.5 |  | Distinto
 | 5870 | PAONE FEDERICO | 7.89 |  | 7.4 | 9.1 | 8.5 | 9.4 | 7.4 | 7.2 | 5.8 | 8.6 | 8 | 7.5 |  | Buono
 | 5871 | PARINI ALESSIO | 8.78 |  | 8.8 | 9.8 | 9.5 | 9.6 | 9.2 | 9.2 | 7.5 | 9.1 | 7.9 | 7.2 |  | Distinto
 | 5872 | RANZANI MATTEO | 8.05 |  | 7.9 | 9.4 | 8.7 | 9.4 | 7.6 | 8.2 | 6.8 | 8.8 | 7.2 | 6.5 |  | Distinto
 | 5873 | RIZZI SERENA | 7.07 |  | 7.2 | 8 | 8 | 7.6 | 6.8 | 6.5 | 5.7 | 7.1 | 7 | 6.8 |  | Discreto
 | 5874 | TODIROI ALINA | 5.79 |  | 5.6 | 7.2 | 6 | 4.8 | 4.6 | 5.7 | 4.8 | 6.1 | 6.8 | 6.3
 | 5875 | TREZZI [NAME] | 7.24 |  | 8.1 | 7.8 | 8.3 | 7.2 | 7.4 | 7.2 | 4.9 | 7.2 | 7.8 | 6.5 |  | Sufficiente
 | 5876 | VALENTI KELIS | 7.75 |  | 8 | 9.3 | 8.6 | 7.6 | 7.9 | 7 | 6.3 | 8.5 | 7.5 | 6.8 |  | Sufficiente
Spreadsheet: 772452d1647279473-freeze-cells-scrolling-sommarsemester-2022-anonymiserad
Sheet: Önskemål

 | INFORMATION | Önskemål semester sommaren 2022
 | Fyll i senast 31 mars 2022 | Juni |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Augusti
 | S = Semester | V. 23 |  |  |  |  | V. 24 |  |  |  |  | V. 25 |  |  |  |  | V. 26 |  |  |  |  | V. 27 |  |  |  |  | V. 28 |  |  |  |  | V. 29 |  |  |  |  | V. 30 |  |  |  |  | V. 31 |  |  |  |  | V. 32 |  |  |  |  | V. 33 |  |  |  |  | V. 34
 | FL = Föräldraledig | 6 | 7 | 8 | 9 | 10 | 13 | 14 | 15 | 16 | 17 | 20 | 21 | 22 | 23 | 24 | 27 | 28 | 29 | 30 | 1 | 4 | 5 | 6 | 7 | 8 | 4 | 5 | 6 | 7 | 8 | 11 | 12 | 13 | 14 | 15 | 18 | 19 | 20 | 21 | 22 | 1 | 2 | 3 | 4 | 5 | 8 | 9 | 10 | 11 | 12 | 15 | 16 | 17 | 18 | 19 | 22 | 23 | 24 | 25 | 26
 |  | M | T | O | T | F | M | T | O | T | F | M | T | O | T | F | M | T | O | T | F | M | T | O | T | F | M | T | O | T | F | M | T | O | T | F | M | T | O | T | F | M | T | O | T | F | M | T | O | T | F | M | T | O | T | F | M | T | O | T | F
 | NAME
 | xxxx
 | xxxx
 | xxxx
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S | S | S
Spreadsheet: 739681d1625854089-counting-unique-values-within-a-date-range-count-unique-sample
Sheet: CALC

Commission Event
 | Amount Paid | Appointments | Unique Contractors | Start Month | End Month
2020-10-01 00:00:00 | 150 | 2 | 2 | 2020-10-01 00:00:00 | 2020-10-31 00:00:00
2020-11-01 00:00:00 | 750 | 13 | 7 | 2020-11-01 00:00:00 | 2020-11-30 00:00:00
 | [NAME] for above
 | =SUMIFS(DATA!$I$2:$I$16,DATA!$A$2:$A$16,">="&E3,DATA!$A$2:$A$16,"<="&F3) | =COUNTIFS(DATA!$A$2:$A$16,">="&E3,DATA!$A$2:$A$16,"<="&F3) | FORMULA NEEDED
 | =SUMIFS(DATA!$I$2:$I$16,DATA!$A$2:$A$16,">="&E4,DATA!$A$2:$A$16,"<="&F4) | =COUNTIFS(DATA!$A$2:$A$16,">="&E4,DATA!$A$2:$A$16,"<="&F4) | FORMULA NEEDED
Spreadsheet: 825290d1681226751-help-with-formula-to-return-top-5-from-raid-log-filter-function-20230411_dynamic-raid_v2
Sheet: RAID Dashboard

 | Directorate |  | No. Risks & Issues |  | Impact
 |  |  |  |  | 1 - Very Low | 2 - Low | 3 - Moderate | 4 - High | 5 - Very High |  |  |  |  |  | Issue for Directorate A, Programme A2 | 2021-03-10 00:00:00 | 0-3 Months | 25
 |  |  | Likelihood | 1 - Rare |  |  |  |  |  |  |  |  |  | 11412 | Issue for Directorate D, Programme D9 | 2019-04-01 00:00:00 | 0-3 Months | 20
 | Programme |  |  | 2 - Unlikely |  |  |  |  |  |  |  |  |  | 10954 | Issue for Directorate A, Programme A2 | 2021-03-10 00:00:00 | 0-3 Months | 20
 |  |  |  | 3 - Possible |  |  |  |  |  |  |  |  |  | 10851 | Risk for Directorate C, Programme C1 | 2020-09-02 00:00:00 | 0-3 Months | 16
 |  |  |  | 4 - Likely |  |  |  |  |  |  |  |  |  | 10741 | Risk for Directorate B, Programme B1 | 2021-01-14 00:00:00 | 6-9 Months | 16
 | Status |  |  | 5 - Very Likely
 |  |  |  | Total
 |  |  | Top 5 Risks / Issues
 |  |  | ID |  | Risk Description |  | Date Raised | Current Proximity | Current Score
 |  | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
Spreadsheet: 756088d1637267170-derive-closed-form-expression-for-interest-series-example
Sheet: Sheet1

 | End Investment |  | 15000
 | Number of Periods |  | 2
 | Interest Rate p.a. |  | 0.05
 | Case 1: | PV
 | Case 2: | NPV |  |  |  |  |  |  |  | or: |  | 0 |  |  | Check
 |  |  |  |  |  |  |  |  |  |  |  | 2021-12-31 00:00:00 | 2022-12-31 00:00:00 | 2023-12-31 00:00:00
 | Case 3: | XNPV |  |  |  |  |  |  |  | or: |  |  | 0
 | 2021-11-30 00:00:00
 |  | 2021-12-31 00:00:00 | 2022-01-31 00:00:00 | 2022-02-28 00:00:00 | 2022-03-31 00:00:00 | 2022-04-30 00:00:00 | 2022-05-31 00:00:00 | 2022-06-30 00:00:00 | 2022-07-31 00:00:00 | 2022-08-31 00:00:00 | 2022-09-30 00:00:00 | 2022-10-31 00:00:00 | 2022-11-30 00:00:00 | 2022-12-31 00:00:00 | 2023-01-31 00:00:00 | 2023-02-28 00:00:00 | 2023-03-31 00:00:00 | 2023-04-30 00:00:00
Spreadsheet: 190641d1351725576-sumproduct-for-two-conditions-in-columns-and-rows-array
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | [NAME] | Sara | Gemma | Nick
 |  | Date | Person | Hours |  |  | 2012-01-01 00:00:00
 | 1 | 2012-01-03 00:00:00 | [NAME] | 5
 | 2 | 2012-01-05 00:00:00 | Sara | 3
 | 3 | 2012-03-15 00:00:00 | [NAME] | 4
 | 4 | 2012-03-19 00:00:00 | Gemma | 5
 | 5 | 2012-02-15 00:00:00 | Nick | 6
 | 6 | 2012-02-05 00:00:00 | Nick | 7
 | 7 | 2012-02-05 00:00:00 | Gemma | 4
Spreadsheet: 857544d1706547335-listing-column-headings-based-on-cell-values-mosom-9-ifna
Sheet: Sheet1

 | Role 1 | Role 2 | Role 3 | Role 4 | Role 5 |  |  | Drop down list of Permissions: | Permission 2 |  |  |  | Office Titles | Roles
Permission 1 | y |  | y |  | y |  |  |  |  |  |  |  | Office Title 1 | Role 1 | Role 2 |  |  | Role 5
Permission 2 |  | y |  | y |  |  |  |  |  |  |  |  | Office Title 2 | Role 1 |  | Role 3
Permission 3 | y |  | y |  | y |  |  | What I want to appear: | Role 1 |  |  |  | Office Title 3 | Role 1 |  | Role 3 | Role 4 | Role 5
Permission 4 |  |  |  |  |  |  |  |  | Role 3 |  |  |  | Office Title 4 | Role 1 | Role 2
Permission 5 | y | y |  | y | y |  |  |  | Role 5 |  |  |  | Office Title 5 | Role 1 |  |  | Role 4
 |  |  |  |  |  |  |  |  |  |  |  |  | Office Title 6 | Role 1 | Role 2 | Role 3
 |  |  |  |  |  |  |  |  |  |  |  |  | NEW REQUEST
 |  |  |  |  |  |  |  | Winning Formula:
 |  |  |  |  |  |  |  |  | Role 4 |  |  |  | When J1 is populated with a permission, J11 is populated with the different Roles
 |  |  |  |  |  |  |  |  |  |  |  |  | I would also like a new cell, say N17, to list the unique Office Titles that contain the Roles that contain the permission
 |  |  |  |  |  |  |  |  |  |  |  |  | Unique list:
 |  |  |  |  |  |  |  |  |  |  | Role 2
 |  |  |  |  |  |  |  |  |  |  | Role 4 |  | Office Title 3
 |  |  |  |  |  |  |  |  |  |  |  |  | Office Title 4
 |  |  |  |  |  |  |  |  |  |  |  |  | Office Title 5
 |  |  |  |  |  |  |  |  |  |  |  |  | Office Title 6
Spreadsheet: 56958d1257159803-pivot-count-query-unique-entry-thing-with-extra-stuff
Sheet: Sheet1

Count of Name
Name | A or B | Total
Chock | A | 1
Clem | A | 1
[NAME] | A | 1
Giff | A | 2
Glock | A | 1
[NAME] | A | 1
[NAME] | A | 1
[NAME] | A | 2
[NAME] | B | 3
[NAME] | B | 2
Grand Total |  | 15
8
Spreadsheet: 691699d1597835075-calculating-the-average-value-based-on-certain-criteria-book-1
Sheet: Sheet1

Payment value | 3000000
Number of days payment occurs over | 3
Payment per day
Closing balance at end of the month | 0
Number of days per month | 31
Average value
Day per month | Opening Balance | Transfers in | Transfers out | Closing Balance | Average
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Spreadsheet: 716633d1612289590-index-match-combination-issues-supplylistef-dexter2-
Sheet: Special

Name of Tenant | Invoice | Item | Manufacturer
Spreadsheet: 14be70c5-f034-4d1a-889f-117cd56ddeed
Sheet: Sheet1

AGCO CORP /DE | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
10-Q
08/08/2014
Balance Sheet
 |  |  | Page
 |  |  | Numbers
PART I. FINANCIAL INFORMATION:
Item 1. | Financial Statements (unaudited)
 |  | Condensed Consolidated Balance Sheets | 3
 |  | as of
 |  | June 30, 2014 and December 31, 2013
 |  | Condensed Consolidated Statements of | 4
 |  | Operations for the
 |  | Three Months Ended June 30, 2014 and 2013
 |  | Condensed Consolidated Statements of | 5
 |  | Operations for the
 |  | Six Months Ended June 30, 2014 and 2013
 |  | Condensed Consolidated Statements of | 6
 |  | Comprehensive Income for the
 |  | Three and Six Months Ended June 30, 2014
 |  | and 2013
 |  | Condensed Consolidated Statements of | 7
 |  | Cash Flows for the
 |  | Six Months Ended June 30, 2014 and 2013
 | Notes to Condensed Consolidated Financial |  | 8
 | Statements
Item 2. | Management s Discussion and Analysis of |  | 26
 | Financial Condition and Results of Operations
Item 3. | Quantitative and Qualitative Disclosures |  | 35
 | about Market Risk
Item 4. | Controls and Procedures |  | 36
PART II. OTHER INFORMATION:
Item 1. | Legal Proceedings |  | 37
Item 6. | Exhibits |  | 38
SIGNATURES |  |  | 39
EX-10.1
EX-31.1
EX-31.2
EX-32.1
EX-101 [NAME]
EX-101 SCHEMA DOCUMENT
EX-101 [NAME]
EX-101 [NAME]
EX-101 [NAME]
EX-101 PRESENTATION LINKBASE DOCUMENT
____________________________
Created by Morningstar Document Research.
http://documentresearch.morningstar.com/
Spreadsheet: 889812d1740740678-running-balance-using-power-query-pq-customers-ledger
Sheet: Transactions

 | Date | Bank | Name | I.D Number | Account | Account Number | Group Code | Group | Description | Invoice | Reference | ZWL VAT | USD VAT | [NAME] | [NAME] | USD Debit | USD Credit | Debit | Credit | Sub group | Column1 | Exchange rate | DR | CR | Sales ledger
 | 2025-01-01 00:00:00 |  | BADAR DON | CT 408 | Balance B/D | 3500 | R1 | Accounts receivable |  |  | Balance B/D | First Term | Customer | 100 |  |  |  | 100 | 0 | 0 |  | 28.4086 | 495.1752787067682 | 0 | No
 | 2025-01-01 00:00:00 |  | [NAME] | CT 372 | Balance B/D | 3500 | R1 | Accounts receivable |  |  | Balance B/D | First Term | Customer |  | 14214.98903936907 |  |  | 0 | 14214.98903936907 | 0 |  | 28.4086 | 0 | 500.376260687576 | No
 | 2025-01-01 00:00:00 |  | AMBER MEARES | CT 420 | Balance B/D | 3500 | R1 | Accounts receivable |  |  | Balance B/D | First Term | Customer | 6167.525832670934 |  |  |  | 6167.525832670934 | 0 | 0 |  | 28.4086 | 217.1006608094356 | 0 | No
 | 2025-01-05 00:00:00 |  | BADAR DON | CT 408 | Accounts receivable | 300 | R1 | Accounts receivable |  | First Term 001 |  | First Term | Customer | 11361.944 |  | 400 |  | 11361.944 | 0 | Trade and other receivables |  | 28.40486 | 400 | 0 | Sales ledger
 | 2025-01-05 00:00:00 |  | [NAME] | CT 372 | Accounts receivable | 300 | R1 | Accounts receivable |  | First Term 003 |  | First Term | Customer | 11361.944 |  | 400 |  | 11361.944 | 0 | Trade and other receivables |  | 28.40486 | 400 | 0 | Sales ledger
 | 2025-01-05 00:00:00 |  | AMBER MEARES | CT 420 | Accounts receivable | 300 | R1 | Accounts receivable |  | First Term 004 |  | First Term | Customer | 11361.944 |  | 400 |  | 11361.944 | 0 | Trade and other receivables |  | 28.40486 | 400 | 0 | Sales ledger
 | 2025-01-06 00:00:00 | Cash - US$ | BADAR DON | CT 408 | Fees | 2000 | C1 | Cash receipts from customers |  |  | 17431 | First Term | Customer |  |  |  | 300 | 0 | 8525.484 | Cash |  | 28.41828 | 0 | 300 | No
 | 2025-01-06 00:00:00 | Cash - US$ | [NAME] | CT 498 | Fees | 2000 | C1 | Cash receipts from customers |  |  | 17432 | First Term | Customer |  |  |  | 100 | 0 | 2841.828 | Cash |  | 28.41828 | 0 | 100 | No
 | 2025-01-07 00:00:00 | Cash - US$ | AMBER MEARES | CT 420 | Fees | 2000 | C1 | Cash receipts from customers |  |  | 17433 | First Term | Customer |  |  |  | 300 | 0 | 8534.592 | Cash |  | 28.44864 | 0 | 299.9999999999999 | No
 | 2025-01-08 00:00:00 | Cash - US$ | BADAR DON | CT 408 | Fees | 2000 | C1 | Cash receipts from customers |  |  | 17436 | First Term | Customer |  |  |  | 200 | 0 | 5694.304 | Cash |  | 28.47152 | 0 | 200 | No
 | 2025-01-08 00:00:00 | Cash - US$ | [NAME] | CT 372 | Fees | 2000 | C1 | Cash receipts from customers |  |  | 17437 | First Term | Customer |  |  |  | 300 | 0 | 8541.456 | Cash |  | 28.47152 | 0 | 300 | No
 | 2025-01-08 00:00:00 | Cash - US$ | AMBER MEARES | CT 420 | Fees | 2000 | C1 | Cash receipts from customers |  |  | 17438 | First Term | Customer |  |  |  | 300 | 0 | 8541.456 | Cash |  | 28.47152 | 0 | 300 | No
Spreadsheet: 850610d1701009293-vlookup-formulas-with-3-criterias-kev56-example
Sheet: Sheet1

doc # | Country ID | Product Name | quantity sold |  |  |  | doc # | Country ID | Product Name | quantity sold
IN000496 | BE | Flowers |  |  |  |  | IN000496 | BE | Flowers | 16
IN000496 | HR | Flowers |  |  |  |  | IN000496 | PT | Flowers | 9
IN000496 | CZ | Flowers |  |  |  |  | IN000496 | CZ | Flowers | 6
IN000496 | PT | Flowers |  |  |  |  | IN000496 | ES | [NAME] | 5
IN000496 | IE | Flowers |  |  |  |  | IN000496 | IE | Flowers | 10
IN000496 | ES | [NAME] |  |  |  |  | IN000496 | HR | Flowers | 24
Spreadsheet: 134889d1325689864-excel-2007-conditional-formatting-cf040112
Sheet: Sheet1

ORDER NUMBER | CUSTOMER | CTY | FROM | INCO | PORT OF DESTINATION | MODE OF TRANSPORT | PGI | LD | ETD | ETA | BL | DOC REQ | RECEIVED | Forwarder | Comments | PO NUMBER | Data
 |  | BRAZIL | HV | CPT | SANTOS | air | 2011-12-12 00:00:00 | 2012-01-05 00:00:00 |  |  |  |  |  | CLEVE |  |  | SEA
 |  |  |  |  |  | Sea |  |  |  |  |  |  |  |  |  |  | AIR
 |  |  |  |  |  | AIR |  | 2012-01-05 00:00:00 |  |  |  |  |  |  |  |  | ROAD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PICK-UP
 | [NAME] BEFORE DOC REQUESTS
 | BRAZIL ORDERS: DRAFT BL IS REQUESTED PLEASE REMIND FORWARDERS
 | 0
 |  |  |  |  |  |  |  | Missing |  |  |  |  |  |  | Answer
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | You don't need the IF in the condition - lets say we are talking about Cells C2 and D2 being empty - then the condition would be
 |  |  |  |  |  |  | Sea
 |  |  |  |  |  |  | Air
 |  |  |  |  |  |  | Road |  |  |  |  |  |  |  | IF both C2 and D2 are blank, the condition is true, so the conditional formatting kicks in.
 |  |  |  |  |  |  | Pickup