tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 1b602279-db7c-4207-8653-983a601433a6
Sheet: FACULTY INFORMATION FORM

Please use capital letters & no punctuation | EXAMPLE | class 1 info | class 2 info | class 3 info | class 4 info | class 5 info | class 6 info
Last Name | LOGAN
First Name | SARAH
MI | M
Printed Course Prefix (e.g. [NAME]) and Number | PSY3303
Printed Date/Time (e.g. MW 08:00 AM, TR 12:30 PM or MWF 18:00 PM) | TR 18:00 PM
Bubbled in Meeting Days (MTWRFSN) NO [NAME] or Spaces | TR
In the Classroom = Face  OR  Online Course = Online | Face
Eight Week Course = Y (yes) or N (no).    If YES… 1 for first eight weeks or 2 for second eight weeks | Y-2
For On-line courses ONLY - Print course title. In addition, please provide a class roster with [NAME] "username@angelo .edu" with your FIF.  Dropped students can be withdrawn later. | Learning  and Cognition
Objectives:  (Scale - M = Minor or No Importance,  I = Important,                              E = Essential) | M, I, E | M, I, E | M, I, E | M, I, E | M, I, E | M, I, E | M, I, E
1.  Gaining factual knowledge (terminology, classifications, methods,       trends) | E
2.  Learning fundamental principles, generalizations, or theories | E
3.  Learning to apply course material (to improve thinking, problem       solving,  and decisions) | E
4.  Developing specific skills, competencies, and points of view needed       by professionals in the field most closely related to this course | I
5.  Acquiring skills in working with others as a member of a team | I
6.  Developing creative capacities (writing, inventing, designing,       performing in art, music, drama, etc.) | M
7.  Gaining a broader understanding and appreciation of       intellectual/cultural activity (music, science, literature, etc.) | M
8.  Developing skill in expressing oneself orally or in writing | M
9.  Learning how to find and use resources for answering questions or       solving problems | M
10.  Developing a clearer understanding of, and commitment to, personal         values | M
11.  Learning to analyze and critically evaluate ideas, arguments,         and points of view | M
12.  Acquiring an interest in learning more by asking questions and         seeking answers | M
[NAME] (e.g. [NAME]) | PSY
Discipline codes:  HONR = 3000      (4 digits) | 4200
[NAME] (e.g. 800, 1230, or 1800) | 800
Bubbled Course Number                                                 (4 digits) | 3303
Enrollment | 23
Local Code  None                                   (4 digits)
Long (L) or Short (S) Forms | L
Number of Additional Questions to be answered on the Survey  ([NAME]. number of Additional questions that can be asked for Long form = 19 & Short form = 10) | 12
Is this class [NAME]?   Y or N | N
Spreadsheet: 821854d1678948904-calculate-number-of-workdays-from-total-hours-workdays-per-task
Sheet: Sheet1

TASK | MINUTES TO COMPLETE | TOTAL MINUTES
PART 1 (STAFF MEMBER 1) | 25
PART 2 (STAFF MEMBER 2) | 15
PART 3 (STAFF MEMBER 3) | 5
PART 4 (STAFF MEMBER 4) | 15
TOTAL TIME TO COMPLETE TASK
NUMBER TIMES TO REPEAT | 3780
TOTAL TIME
TOTAL NUMBER OF WORKDAYS TO [NAME] (1 WORKDAY = 7:24)
TOTAL NUMBER OF WORKDAYS TO COMPLETE PART 1 (1 WORKDAY = 7:24)
TOTAL NUMBER OF WORKDAYS TO COMPLETE PART 2 (1 WORKDAY = 7:24)
TOTAL NUMBER OF WORKDAYS TO COMPLETE PART 3 (1 WORKDAY = 7:24)
TOTAL NUMBER OF WORKDAYS TO COMPLETE PART 4 (1 WORKDAY = 7:24)
HOW MANY STAFF REQUIRED TO COMPLETE IN 8 WORKING WEEKS (40 WORKDAYS)
HOW MANY STAFF REQUIRED TO COMPLETE PART 1 IN 8 WORKING WEEKS (40 WORKDAYS)
HOW MANY STAFF REQUIRED TO COMPLETE PART 2 IN 8 WORKING WEEKS (40 WORKDAYS)
HOW MANY STAFF REQUIRED TO COMPLETE PART 3 IN 8 WORKING WEEKS (40 WORKDAYS)
HOW MANY STAFF REQUIRED TO COMPLETE PART 4 IN 8 WORKING WEEKS (40 WORKDAYS)
Spreadsheet: 7152b448-2320-420f-a9cc-ea2bd909b506
Sheet: Sheet1

No. | Family code | Individual number | Mutations | Sampled at | Sex
1 | MHU-2619 | 11 | control | 34 years old | Female
2 | MHU-2371 | 100 | control | 52 years old | Female
3 | MHU-2723 | 14 | control | 62 years old | Female
4 | FSP-083 | 4 | KIAA0415 [this study] | 66 years old | Female
5 | FSP-708 | 22 | SPG15 (p.E414X/p.R2329RfsX2337, [ref #50]) | 31 years old | Female
Spreadsheet: jane_tholt__13125__Baseload GISB form
Sheet: Baseload

 |  |  | TRANSACTION CONFIRMATION |  |  |  |  |  | EXHIBIT A
 |  |  |  | FOR IMMEDIATE DELIVERY
 |  |  |  | BASELOAD
 |  |  |  |  |  | Date:
 |  |  |  |  |  | Transaction Confirmation #:
 | This Transaction Confirmation is subject to the Base Contract between [NAME] and [NAME]
 | dated |  |  | The terms of this Transaction Confirmation are binding unless
 | disputed in writing within 2 Business Days of receipt unless otherwise specified in the Base Contract.
 | SELLER: |  |  |  |  | BUYER:
 |  |  |  |  |  | PNM Gas Services
 |  |  |  |  |  | Alvarado Square
 |  |  |  |  |  | Albuquerque, New Mexico  87158-2610
 | Attn: |  |  |  |  | Attn: Contract Administration
 | Phone: |  |  |  |  | Phone: [PHONE]
 | Fax: |  |  |  |  | Fax: [PHONE]
 | Base Contract No. |  |  |  |  | Base Contract No.
 | Transporter: |  |  |  |  | Transporter:
 | Transporter Contract Number: |  |  |  |  | Transporter Contract Number:
 | Contract Price        $ |  |  | /MMBtu or
 | Delivery Period
 | (NOTE:  BID EACH MONTH SEPARATELY, AS PNM GAS SERVICES HAS THE RIGHT TO
 | SELECT ANY OR ALL MONTHS)
 | Performance Obligation and Firm Baseload Contract Quantity:
 | MMBtu/d October |  |  |  |  | MMBtu/d November
 | MMBtu/d December |  |  |  |  | MMBtu/d January
 | MMBtu/d February |  |  |  |  | MMBtu/d March
 | MMBtu/d April
 | Delivery Point(s):
 | El Paso Pipeline
 | [NAME]
 | Transwesten Pipeline
 | (If a pooling point is used, list a specific geographic and pipeline location)
 |  | 1
 | Copyright © 1996–1999 Gas Industry Standards Board, Inc. |  |  |  |  |  |  | GISB Standard 6.3.1
 | All rights reserved. |  |  |  |  |  |  | 1996-05-13 00:00:00
 | Special Provision:
 | ELECTRONIC DOCUMENTATION:  Each of the parties acknowledge and agree that either Party may
 | maintain this executed Base Contract and any executed Transaction Confirmation as 'imaged
 | documents' in an electronic format, and that, so long as the imaged document bears the signature of
 | the Party against whom enforcement is sought, neither Party will object to the introduction and
 | acceptance to such imaged documents as evidence in any proceeding between the Parties before
 | any court, arbitration panel, regulatory commission or similar body on the basis that such imaged
 | documents are not original documents or do not comply with the best evidence rule.
 | BY EXECUTION BELOW, THE EXECUTING PARTY(S) REPRESENT, WARRANT AND BIND THE
 | RESPECTIVE COMPANY(S) TO PERFORM UNDER THE TERMS AND CONDITIONS OF THE
 | CONTRACT.
 | [NAME]: |  |  |  | Buyer: | PNM Gas Services, an unincorporated
 |  |  |  |  | division of Public Service Company of New Mexico
 | By: |  |  |  | By:
 |  |  |  |  |  | [NAME]
 | Title: |  |  |  | Title: | Vice President, Operations & Engineering
 | Date: |  |  |  | Date:
 |  | 2
 | Copyright © 1996–1999 Gas Industry Standards Board, Inc. |  |  |  |  |  |  | GISB Standard 6.3.1
 | All rights reserved. |  |  |  |  |  |  | 1996-05-13 00:00:00
Spreadsheet: 145245d1331411251-auto-fill-data-from-multiple-sheets-shift-1
Sheet: Supervision

 | Lead |  | Support |  | Support
2012-03-07 00:00:00 | [NAME] |  | Keegan
2012-03-08 00:00:00 | [NAME] |  | Keegan
2012-03-09 00:00:00 | [NAME] |  | Keegan
2012-03-10 00:00:00 | [NAME] |  | Keegan
2012-03-11 00:00:00 | [NAME] |  | Keegan
2012-03-12 00:00:00 | [NAME] |  | Keegan
2012-03-13 00:00:00 | [NAME]
2012-03-14 00:00:00 | [NAME]
2012-03-15 00:00:00 | [NAME]
2012-03-16 00:00:00 | [NAME]
2012-03-17 00:00:00 | [NAME]
2012-03-18 00:00:00 | [NAME]
2012-03-19 00:00:00 |  |  | Keegan
2012-03-20 00:00:00 |  |  | Keegan
2012-03-21 00:00:00 |  |  | Keegan
2012-03-22 00:00:00 |  |  | Keegan
2012-03-23 00:00:00 |  |  | Keegan
2012-03-24 00:00:00 |  |  | Keegan
2012-03-25 00:00:00 |  |  | Keegan
2012-03-26 00:00:00 |  |  | Keegan
2012-03-27 00:00:00 |  |  | Keegan
2012-03-28 00:00:00 |  |  | Keegan
2012-03-29 00:00:00 |  |  | Keegan
2012-03-30 00:00:00 |  |  | Keegan
2012-03-31 00:00:00 |  |  | Keegan
2012-04-01 00:00:00 |  |  | Keegan
2012-04-02 00:00:00 |  |  | Keegan
2012-04-03 00:00:00 |  |  | Keegan
2012-04-04 00:00:00 |  |  | Keegan
2012-04-05 00:00:00 |  |  | Keegan
2012-04-06 00:00:00 |  |  | Keegan
2012-04-07 00:00:00 |  |  | Keegan
2012-04-08 00:00:00
2012-04-09 00:00:00
2012-04-10 00:00:00
2012-04-11 00:00:00
Spreadsheet: 471686d1469132271-creating-test-scenarios-from-requirements-final-testing-scenarios
Sheet: Master

 |  |  |  |  |  |  | <-Count of Options |  | Segment 1 | Responsibility Centre | Approval Limit | Currency | Project | Funds | Delgation
Segment 1 | Responsibility Centre | Approval Limit | Currency | Project | Funds | Delgation
Entity 10 | RC 1 | Approver $250 | CDN | PMO Project Only | Fund Advisor | Delegated
Entity 20 | RC 2 | Approver $5000 | USD | Non PMO |  | Not Delegated
Entity 30 | RC 3 | Approver $10,000 |  | PMO
 | RC 4 | Approver $50,000
 | RC 5 | Approver $100,000
 |  | Approver $250,000
 |  | Approver $500,000
 |  | Approver $1,000,000
Spreadsheet: 863185d1710773879-creating-live-list-of-names-referencing-seperate-data-sheet-name-listing-research
Sheet: Pasted Data From Query

Name | Weekending | Hours Worked | Rate/hr | Revenue
Couples,Fred | 2024-03-02 00:00:00 | 20 | 40
Couples,Fred | 2024-03-02 00:00:00 | 10 | 40
Woods,Tiger | 2024-03-02 00:00:00 | 40 | 20
[NAME],Wyndham | 2024-03-02 00:00:00 | 4 | 30
[NAME],Wyndham | 2024-03-02 00:00:00 | 16 | 30
Scheffler,[NAME] | 2024-03-02 00:00:00 | 8 | 45
[NAME],[NAME] | 2024-03-02 00:00:00 | 10 | 45
[NAME],Will | 2024-03-02 00:00:00 | 45 | 42
Day,[NAME] | 2024-03-02 00:00:00 | 18 | 40
Spreadsheet: 672696d1586965229-building-summary-report-find-multiple-matches-in-a-table-04-15-20-cattle-close-out-report-excel-forum
Sheet: Closeout Rpt

Lot: | [NAME]
Head Days
 |  |  | Qty | [NAME] | %%
 | Total Head Purchased
 | Total Deaths
 | Total Realizers
 | Total Sold
 |  |  | Total | P/H | P/Lb
 | Total Puchase Cost
 | Total Realizer Income
 | Total Sales
Total Dry Matter Intake |  |  |  | Total Wt Gain (Dead's In)
Avg Per Head DMI |  |  |  | Total Wt Gain (Dead's Out)
DM Conv Rate - Deads In |  |  |  | Cost of Gain (Dead's In)
DM Conv Rate - Deads Out |  |  |  | Cost of Gain (Dead's Out)
 |  | ADG (Dead's In)
 |  | ADG (Dead's Out)
 | Total Sales
 | Total cattle Purchase Cost
 | Total Feed Cost
 | Total Med & Vet & Rendering
 | Total Supplemental Feed
 | Total Expense
 | Total Profit / (Loss)
 | Total Profit / (Loss) P/H
Purchase
 | Date | CMS | Qty | [NAME] | Per Per Lb | Amount | Note
 |  |  |  |  |  |  |  |  | <=Looking for this note from the Dataset
Spreadsheet: 852667d1702625921-formula-for-daily-deduction-of-customer-account-with-daily-limit-dynamic-deduction
Sheet: Outstanding

Cust_Code | Inv | Amount | Bank_Ref |  | Bank_Ref | Limit/Day
M1201 | #1 | 577 | B1 |  | B1 | 500
M1203 | #2 | 611 | B1 |  | B2 | 600
M1515 | #3 | 300 | B2 |  | B3 | 1000
[NAME] | #4 | 478 | B3 |  | B4 | No Limit
M1619 | #5 | 353 | B2
M1700 | #6 | -565 | B4
Bank_Ref | Outstanding | Limit | Day1 | Day2 | Day3 | Day4
 |  |  | 500 | 500 | 188
B2 | 653 | 600 | 600 | 53
B3 | 478 | 1000 | 478
B4 | -565 | No Limit
 |  |  | * is there a way to make the blue portion dynamic?
 |  |  | * How do I exclude in my list in which the outstanding is negative, eg, B4?
Spreadsheet: 867370d1714199558-automatisation-of-the-consolidation-data-consolidation-aligw
Sheet: Sheet1

Title | Count
TTT333391100020 | 0 |  | TTT333391100020 | 0 |  |  | 0
TTT333391100020 | 0 |  | TTT333305201161 | 1 |  | TTT333305201161 | 1
TTT333391100020 | 0 |  | TTT333356301413 | 5 |  | TTT333356201678 | 3
TTT333305201161 | 0 |  | TTT333356401666 | 0 |  | TTT333356301413 | 5
TTT333305201161 | 0 |  | TTT320509101666 | 0 |  | TTT333356401666 | 0
TTT333305201161 | 1 |  | TTT333356201678 | 3 |  | TTT333391100020 | 0
TTT333305201161 | 0
TTT333305201161 | 0
TTT333305201161 | 0
TTT333305201161 | 0
TTT333305201161 | 0
TTT333305201161 | 0
TTT333305201161 | 0
TTT333356301413 | 0
0 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 1
TTT333356301413 | 1
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 1
TTT333356301413 | 1
TTT333356301413 | 1
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT320509101666 | 0
TTT333356401666 | 0
TTT320509101666 | 0
TTT333356401666 | 0
TTT320509101666 | 0
TTT333356201678 | 1
TTT333356201678 | 1
TTT333356201678 | 1
TTT333356201678 | 0
TTT333356201678 | 0
TTT333356201678 | 0
TTT333356201678 | 0
TTT333356201678 | 0
TTT333356201678 | 0
TTT333356201678 | 0
TTT333356201678 | 0
TTT333356201678 | 0
TTT333356201678 | 0
Spreadsheet: 868237d1714985056-tier-incentive-will-be-automatically-calculated-based-on-tier-hani-calculation-
Sheet: Dr. Bandar Al Aithan

 | Contract Terms (*)
 |  |  | Description | Commission
 |  |  | Consultation after deducting 5% Admin | 0.5
 |  |  | Referral after deducting 5% Admin | 0.1
 |  |  | Procedure in Clinics after deducting consumables and 5% Admin | 0.5
 |  |  | OR in Clinics from gross (40% & 80%)
 |  |  | OR outside Clinics after hospital expenses and 5% Admin | 0.7
 | Doctor Calculation
 |  |  | Gross Revenue
 |  |  | Consultation Revenue | 23940
 |  |  | OHE 5%
 |  |  | Net Revenue
 |  |  | Amount to be paid
 |  |  | Referral Revenue | 0
 |  |  | Amount to be paid
 |  |  | LAB Revenue | 0
 |  |  | [NAME] (65%)
 |  |  | Clinics Share (35%)
 |  |  | Amount to be Paid
 |  |  | Procedure in the Clinics Revenue | 29745.57
 |  |  | Consumables | 12649.48
 |  |  | OHE 5%
 |  |  | Net Revenue
 |  |  | Amount to be paid
 |  |  | OR in the Clinics Revenue 40% | 728900.4
 |  |  | Consumables (Implants)
 |  |  | Net Revenue
 |  |  | Doctor [NAME] (40%)
 |  |  | OR in the Clinics Revenue | 603419.6000000001
 |  |  | Doctor [NAME] (80%) |  | 0.8
 |  |  | Amount to be paid
 |  |  | OR outside the Clinics Revenue
 |  |  | Hospital Fees
 |  |  | OHE 5%
 |  |  | Net Revenue
 |  |  | Amount to be paid
 |  |  | Total Amount to be Paid
 |  |  | Less: Overtime Over Night | 0
 |  |  | Less OR Fees (61267, 73428, 76862, 72591, 52385,73413)
 |  |  | Total Amount to be Paid
 | Prepared By …................. |  |  | CFO:….....................
Spreadsheet: monika_causholli__28265__Pulp Producers
Sheet: SEM

Semichemical Market Pulp Capacity
(Thousands of Metric Tonnes per Year)
Country | Company | [NAME] | Ownership | Grade | 1972 | 1973 | 1974 | 1975 | 1976 | 1977 | 1978 | 1979 | 1980 | 1981 | 1982 | 1983 | 1984 | 1985 | 1986 | 1987 | 1988 | 1989 | 1990 | 1991 | 1992 | 1993 | 1994 | 1995 | 1996 | 1997 | 1998 | 1999 | 2000 | 2001 | 2002 | 2003 | 2004
Autralia | Australian Paper Mills | Port Huon | Paperlinx | SEM | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 30 | 50 | 60 | 30 | 50 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
Denmark | Junckers Industrier | [NAME] | Junckers Industrier | SEM | 90 | 90 | 90 | 90 | 65 | 65 | 65 | 65 | 65 | 65 | 65 | 65 | 65 | 65 | 65 | 65 | 65 | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 50 | 30 | 30 | 30 | 30 | 30 | 30
Denmark | Junckers Industrier | Assens | Junckers Industrier | SEM | 35 | 35 | 35 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Italy | [NAME] | Crotone | [NAME] | SEM | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 40 | 40 | 40 | 30 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Italy | Chimica del Friuli | Udine | Chimica Del Fruili | SEM | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 25 | 30 | 35 | 40 | 40 | 40 | 40 | 40 | 50 | 60 | 45 | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Japan | [NAME] | [NAME] | [NAME] | SEM | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 80 | 60 | 40 | 30 | 25 | 20 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 10 | 10 | 10 | 10 | 10 | 5 | 5 | 5 | 5 | 5 | 5
Norway | Lagen Industries | Larvik | Lagen Industries | SEM | 35 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 0 | 30 | 30 | 30 | 30 | 30
Sweden | [NAME] | Broby | [NAME] | SEM | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | World Total |  | 330 | 325 | 325 | 300 | 265 | 265 | 265 | 265 | 270 | 255 | 240 | 225 | 215 | 210 | 205 | 230 | 260 | 285 | 230 | 225 | 155 | 145 | 110 | 110 | 110 | 110 | 90 | 35 | 65 | 65 | 65 | 65 | 65
Spreadsheet: 147992d1333066340-excel-financial-problem-need-assistance-thanks-help-excel
Sheet: Feuil1

Rate | Total Cost | 2011-12-30 00:00:00 | 2012-01-06 00:00:00 | 2012-01-13 00:00:00 | 2012-01-20 00:00:00
100 | 212000 | 1 | 1 | 1 | 1
133 | 0
85 | 0
149 | 0
85 | 0
167 | 0
129 | 0
85 | 0
113 | 0
85 | 0
69 | 0
113 | 0
113 | 0
100 | 0
85 | 0
85 | 0
85 | 0
Cost per Week |  | ?? | ?? | ?? | ??
Spreadsheet: 225769d1365103672-creating-a-contact-list-with-dropdowns-lookups-for-multiple-offices-contact-module2
Sheet: Processes

 |  |  |  |  |  |  |  |  | Select | Select
 |  | Market Area Contact List |  |  |  |  |  |  | 1 | Customer Service
 |  |  |  |  |  |  |  |  | 2 | Sales
 |  |  |  | Market Area |  | Select |  |  | 3 | Operations
 |  |  |  |  |  |  |  |  | 4 | Billing
 |  |  |  | Department |  | Select |  |  | 5 | Other
 |  | Contact List
 |  |  |  | Name |  | Position |  |  | Phone # |  | [NAME] |  | Notes
Spreadsheet: 1a8df8cc-c966-4336-b182-46910768cad5
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
43035791 | 2014-09-05 23:48:45 | AXIS | 0 | 3 | 5 | 859507 | banza¡ | 12499 | western | 1944-06-13 | 1944-06-13 | Carentan | Carentan
43035941 | 2014-09-06 00:04:04 | ALLIES | 0 | 3 | 5 | 859507 | banza¡ | 12499 | western | 1944-06-13 | 1944-06-13 | Carentan | Carentan
43062143 | 2014-09-07 19:26:09 | ALLIES | 0 | 3 | 4 | 1507591 | darckjester | 6159 | western | 1944-06-06 | 1944-06-06 | Sainte-Mère-Eglise | Sainte-Mère-Eglise
43062367 | 2014-09-07 19:39:19 | AXIS | 1 | 4 | 2 | 1507591 | darckjester | 6159 | western | 1944-06-06 | 1944-06-06 | Sainte-Mère-Eglise | Sainte-Mère-Eglise
43066309 | 2014-09-07 23:59:41 | ALLIES | 0 | 0 | 5 | 506159 | Hurletout | 6157 | western | 1944-11-19 | 1944-11-23 | Saverne Gap | [NAME]
43066443 | 2014-09-08 00:17:37 | AXIS | 1 | 5 | 3 | 506159 | Hurletout | 6157 | western | 1944-11-19 | 1944-11-23 | Saverne Gap | [NAME]
43093488 | 2014-09-10 00:25:10 | AXIS | 0 | 3 | 6 | 569334 | Breakmate | 7664 | pacific | 1944-07-25 | 1944-07-25 | Japanese Counterattack | Contre-attaque japonaise
Spreadsheet: 772060d1646989897-vba-how-to-automatically-update-data-range-in-a-chart-automatically-update-range-tms
Sheet: Sheet1

 | Base year | 2015 | <<< Use this as the base year for the data
 | Start year | 2016 | <<< This is the start of the charted data
 | End year | 2020 | <<< this is the end of the charted data
=C1 |  |  |  |  |  |  |  |  | =H5+1
sales | 250 | 220 | 300 | 220 | 340 | 250 | 220 | 200
cost
profits
dnrYears | =INDEX($B$5:$I$5,MATCH($C$2,$B$5:$I$5,0)):INDEX($B$5:$I$5,MATCH($C$3,$B$5:$I$5,0))
dnrSales | =INDEX($B$6:$I$6,MATCH($C$2,$B$5:$I$5,0)):INDEX($B$6:$I$6,MATCH($C$3,$B$5:$I$5,0))
dnrCosts | =INDEX($B$7:$I$7,MATCH($C$2,$B$5:$I$5,0)):INDEX($B$7:$I$7,MATCH($C$3,$B$5:$I$5,0))
dnrProfits | =INDEX($B$8:$I$8,MATCH($C$2,$B$5:$I$5,0)):INDEX($B$8:$I$8,MATCH($C$3,$B$5:$I$5,0))
Use Data Validation
in cells C2 and C3 to
select the start and end years
Spreadsheet: 47916d1247086539-merge-worksheets-into-one-within-same-workbook-test
Sheet: Sheet3

MPD ITEM NUMBER | MRB ITEM NUMBER | CARD NUMBER | RELATED TASK | TASK | [NAME] BY MPD - CARDTITLE
12-13-03-3A |  | 24-015-02-2 |  | SERVICE | ENGINE 2 IDG OIL LEVEL
12-13-03-3A | 24-015 | 24-015-03-1 |  | SERVICE | ENGINE 1 IDG OIL LEVEL
12-13-03-3A | 24-015 | 24-015-03-2 |  | SERVICE | ENGINE 2 IDG OIL LEVEL
12-13-03-3B |  | 24-017-01-1 | W-24-016-01-1 | REPLACE | ENGINE 1 IDG OIL CHANGE
12-13-03-3B |  | 24-017-01-2 | W-24-016-01-2 | REPLACE | ENGINE 2 IDG OIL CHANGE
12-13-03-3B |  | 24-017-03-1 | W-24-016-02-1 | REPLACE | ENGINE 1 IDG OIL CHANGE
12-13-03-3B |  | 24-017-03-2 | W-24-016-02-2 | REPLACE | ENGINE 2 IDG OIL CHANGE
12-13-03-3B |  | 24-017-06-1 | W-24-016-03-1 | SERVICE | ENGINE 1 IDG OIL CHANGE
12-13-03-3B |  | 24-017-06-2 | W-24-016-03-2 | SERVICE | ENGINE 2 IDG OIL CHANGE
12-13-03-3B |  | 24-017-07-1 | W-24-016-C1-1 | SERVICE | ENGINE 1 IDG OIL CHANGE
12-13-03-3B |  | 24-017-07-2 | W-24-016-C1-2 | SERVICE | ENGINE 2 IDG OIL CHANGE
12-13-03-3B |  | 24-017-08-1 | W-24-016-C2-1 | REPLACE | ENGINE 1 IDG OIL CHANGE
12-13-03-3B |  | 24-017-08-2 | W-24-016-C2-2 | REPLACE | ENGINE 2 IDG OIL CHANGE
12-13-03-3C | 24-001 | 24-001-02-1 |  | CHECK/INSP | IDG SCAVENGE FILTER DIFF PRESS INDIC
12-13-03-3C | 24-001 | 24-001-02-2 |  | CHECK/INSP | IDG SCAVENGE FILTER DIFF PRESS INDIC
12-13-03-3C | 24-001 | 24-001-10-1 |  | CHECK/INSP | IDG SCAVENGE FILTER DIFF PRESS INDIC
12-13-03-3C | 24-001 | 24-001-10-2 |  | CHECK/INSP | IDG SCAVENGE FILTER DIFF PRESS INDIC
12-13-03-3C |  | 24-016-10-1 |  | CHECK/INSP | IDG SCAVENGE FILTER DIFF PRESS INDIC
12-13-03-3C |  | 24-016-10-2 |  | CHECK/INSP | IDG SCAVENGE FILTER DIFF PRESS INDIC
12-13-03-3C |  | 24-016-11-1 |  | CHECK/INSP | IDG SCAVENGE FILTER DIFF PRESS INDIC
12-13-03-3C |  | 24-016-11-2 |  | CHECK/INSP | IDG SCAVENGE FILTER DIFF PRESS INDIC
12-13-03-3C | 24-016 | 24-016-12-1 |  | CHECK/INSP | IDG SCAVENGE FILTER DIFF PRESS INDIC
12-13-03-3C | 24-016 | 24-016-12-2 |  | CHECK/INSP | IDG SCAVENGE FILTER DIFF PRESS INDIC
12-13-04-3A | 49-021 | 49-021-01 |  | SERVICE | APU OIL LEVEL
12-13-04-3A |  |  | G-49-021-02 | SERVICE | APU OIL LEVEL
12-13-04-3A |  |  | G-49-021-03 | SERVICE | APU OIL LEVEL
Spreadsheet: 78351d1278703091-vlookup-multiple-results-test-3-
Sheet: Data

Company name | Company number
General Motors | 1 | 0
General Audi | 2 | 1
Toyota Dublin | 3 | 1
Toyota Cork | 4 | 1
Toyota | 5 | 1
International Fiat | 6 | 1
Fiat | 7 | 1
Spreadsheet: ed92dab9-11f8-474a-a279-a883df0e5251
Sheet: Rev

 |  | REQUEST FOR SUPPLEMENTAL REVENUE
 |  | CITY  OF  KANSAS  CITY,  MISSOURI
 |  |  | DEPARTMENT: |  |  | Public Works
BUSINESS UNIT: |  |  |  | KCMBU |  | DATE: |  |  |  | JOURNAL ID:
LEDGER GROUP: |  |  |  |  | REVENUE
 |  | FUND |  | DEPT ID |  | ACCOUNT |  | PROJECT |  | AMOUNT
 |  | 3090 |  | 890001 |  | 474630 |  | 89020070 |  | 411039.87
 |  |  |  |  |  |  |  |  |  |  |  | TOTAL
[NAME]:
APPROVED BY: |  |  |  |  |  | DATE |  | APPROVED BY:  DEPARTMENT HEAD |  |  |  |  |  | DATE
Spreadsheet: f02eac0a-b139-407a-a5f2-fd99c4b4969b
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
42407892 | 2014-07-22 16:27:28 | AXIS | 1 | 8 | 1 | 26778 | gheintze | 14853 | western | 1944-08-07 |  | Mortain(online)
42467907 | 2014-07-27 01:02:50 | AXIS | 1 | 9 | 5 | 679790 | Hermann | 9523 | western | 1944-08-17 | 1944-08-20 | The Falaise Pocket
42473705 | 2014-07-27 13:19:41 | AXIS | 1 | 9 | 6 | 679790 | Hermann | 9523 | western | 1944-08-17 | 1944-08-20 | The Falaise Pocket