tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: benjamin_rogers__1066__NewCo-7-15-00
Sheet: FPLE_IS

FPLE GenCo INCOME STATEMENT
('000 $) |  | 2001 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | Check
EBITDA from Projects
Revenue to FPLE (Fees & Interests)
 | FPLE Ownership
[NAME] | 1
Maine Thermal | 1
Lamar | 0.99
Marcus Hook 50 | 1
Doswell | 1
Doswell CT | 1
Wind | 1
SegsVIII | 0.5
[NAME] | 0.5
Bellingham&Sayreville | 0.5
Cherokee | 0.5
Depreciation & Amortization
EBIT
[NAME] | 1
Maine Thermal | 1
Lamar | 0.99
Marcus Hook 50 | 1
Doswell | 1
Doswell CT | 1
Wind | 1
SegsVIII | 0.5
[NAME] | 0.5
Bellingham&Sayreville | 0.5
Cherokee | 0.5
Project Interest Expense
Corporate Interest Expense
EBT
Book State Tax Benefit / (Expense)
Shareholder Fed. Tax Benefit / (Expense) | 0.35
Wind Portfolio PTC
Net Income
Book State Tax after Allocation of Corporate [NAME] and Interest Income
EBT before Corporate [NAME]
Corporate G&A Allocation
EBT
Book State Tax Benefit / (Expense)
Spreadsheet: 38658d1236796832-return-multiple-rows-in-an-array-with-the-same-value-lookup
Sheet: Sorting data

[NAME] |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | Grade 5
Grade | School Name | Group |  | Grade | School Name | Group |  | Grade | School Name | Group |  | Grade | School Name | Group
I NEED THE ABOVE TABLE TO LOOKUP THE GRADE FROM THE FIRST SHEET
TO AUTO ENTER THIS:
 | [NAME] |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | Grade 5
Grade | School Name | Group |  | Grade | School Name | Group |  | Grade | School Name | Group |  | Grade | School Name | Group
2 | MacKenzie | A |  | 3 | Gladys | A |  | 4 | Gladys | B |  | 5 | MacKenzie | A
2 | MacKenzie | B |  | 3 | Gladys | C |  | 4 | Hawthorne | A |  | 5 | [NAME] | A
2 | St. Matthew's | A |  | 3 | MacKenzie | A |  | 4 | Hawthorne | B |  | 5 | [NAME] | B
2 | St. Matthew's | B |  | 3 | MacKenzie | B |  | 4 | Hawthorne | C |  | 5 | [NAME] | C
2 | St. Matthew's | C |  | 3 | [NAME] | A |  | 4 | Hawthorne | D |  | 5 | [NAME] | A
2 | St. Matthew's | D |  | 3 | [NAME] | B |  | 4 | [NAME] | A |  | 5 | [NAME] | B
DO YOU KNOW THE FORMULAS?
DO THE TABLES NEED TO BE REARRANGED?
Spreadsheet: 0c6f3014-193a-4346-bed5-84e740af6e7b
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | City of Tempe | Unnamed: 8
 |  |  |  |  |  |  | P.O. Box 5002
 |  |  |  |  |  |  | 31 East Fifth Street
 |  |  |  |  |  |  | Tempe, AZ  85280
 |  |  |  |  |  |  | Public Works/Engineering Division
 |  |  |  |  |  |  | [PHONE] (phone)
 |  |  |  |  |  |  | [PHONE] (fax)
Project Name:
Project No: |  |  | City of Tempe Project Manager:
Consultant Name: |  |  |  |  |  |  | Phone:
Address:
Billing Period: |  |  |  | to |  |  | Date Sumitted:
Completion to Date: |  |  | Total Time Elapsed: |  |  | Contract Completion Date:
Pay Period Activity (revise pay items to match contract):
Pay Items |  | Total Budget |  | Completed to Date |  | [NAME] |  | Due this Period
Design Services |  | 0 |  | 0 |  | 0 |  | 0
Post-Design Serv. |  | 0 |  | 0 |  | 0 |  | 0
Reimbursables |  | 0 |  | 0 |  | 0 |  | 0
Allowance |  | 0 |  | 0 |  | 0 |  | 0
 |  | 0 |  | 0 |  | 0 |  | 0
 |  | 0 |  | 0 |  | 0 |  | 0
 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0
Contract Summary: |  |  |  |  |  | Encumbrance No:
Original Contract Amount: |  |  | 0
 |  |  |  |  |  | CITY USE ONLY
[NAME] to Date: |  |  | 0
 |  |  |  |  |  | Approved:
Current Contract Amount: |  |  | 0 |  |  |  | Project Manager
 |  |  |  |  |  | Date:
Total Previously Invoiced: |  |  | 0
 |  |  |  |  |  | Approved:
Contract Balance: |  |  | 0 |  |  |  | City Engineer
 |  |  |  |  |  | Date:
Revised: 2/10/12
Spreadsheet: 8bbcb4d1-6e7c-4412-86e2-cd1aa1b5460d
Sheet: General

GENERAL
Ordinance Fact Sheet |  |  |  |  |  |  | Ordinance Number
 | Brief Title |  | Approval Deadline |  | Reason
Details |  |  |  |  | Positions/Recommendations
 | Reason for Legislation |  |  |  | Sponsor |  |  |  | _________ Department
 |  |  |  |  | Programs,
 |  |  |  |  | Departments, |  |  |  | _________ Department
 |  |  |  |  | or Groups
 |  |  |  |  | Affected
 |  |  |  |  | Applicants / |  | Applicant
 |  |  |  |  | Proponents
 |  |  |  |  |  |  |  |  | _________ Department
 |  |  |  |  |  |  | City Department
 |  |  |  |  |  |  |  |  | _________ Department
 |  |  |  |  |  |  |  |  | _________ Department
 |  |  |  |  |  |  | Other
 |  |  |  |  | Opponents |  | Groups or Individuals
 |  |  |  |  |  |  |  |  | None Known
 |  |  |  |  |  |  | Basis of opposition
 |  |  |  |  | Staff
 |  |  |  |  | Recommendation |  | X |  | For
 |  |  |  |  |  |  |  |  | Against
 |  |  |  |  |  |  | Reason Against
 |  |  |  |  | Board or
 |  |  |  |  | Commission |  | By
 |  |  |  |  | Recommendation
 |  |  |  |  |  |  |  |  | For |  |  |  | Against |  | No action taken
 |  |  |  |  |  |  |  |  | For, with revisions or conditions
 |  |  |  |  |  |  |  |  | (see details column for conditions)
 |  |  |  |  | Council
 |  |  |  |  | Committee |  |  |  | Do pass
 |  |  |  |  | Actions
 |  |  |  |  |  |  |  |  | Do pass (as amended)
 |  |  |  |  |  |  |  |  | Committee Sub.
 |  |  |  |  |  |  |  |  | Without Recommendation
 |  |  |  |  |  |  |  |  | Hold
 |  |  |  |  |  |  |  |  | Do not pass
 |  |  |  |  |  |  |  |  |  |  |  | (Continued on reverse side)
Details |  |  |  |  | Policy/Program Impact
 |  |  |  |  | Policy or Program
 |  |  |  |  | Change |  | X |  | No |  |  |  | Yes
 |  |  |  |  | Operational
 |  |  |  |  | Impact
 |  |  |  |  | Assessment
 |  |  |  |  | Finances
 |  |  |  |  | Cost & Revenue
 |  |  |  |  | Projections --
 |  |  |  |  | Including Indirect
 |  |  |  |  | Costs
 |  |  |  |  | Financial Impact
 |  |  |  |  | Fund Source (s) |  | 19__ Budget, Page ___
 |  |  |  |  | and Appropriation |  | Unbudgeted, Appropriation
 |  |  |  |  | Account Codes |  | ________________ Fund
 |  |  |  |  |  |  | 00-000-00-0000-A0000
 |  |  |  |  | (Use this space for further discussion, if necessary)
Applicable Dates:
Fact Sheet Prepared by:
 | Name |  | Date
 | Title
Reviewed by:
 | Name |  | Date
 | Title
Reference Numbers
Spreadsheet: 65518d1266246459-excel-2007-find-and-copy-data-using-if-condition-sample-clips
Sheet: Sheet1

Crime, Horror, Mystery, Thriller
Animation
Biography, Drama
Comedy, Fantasy, Romance
Horror
Adventure, Comedy, Drama
Comedy, Drama
Action, Sci-Fi, Thriller
Drama, Music, Romance
Action, Adventure, Fantasy, Sci-Fi
Action, Adventure, Thriller
Crime, [NAME], Romance
Horror, Romance, Western
Comedy, Fantasy
[NAME], Romance
Action, Adventure, Comedy, Fantasy, Romance
Action, Comedy, Crime, Thriller
Fantasy, [NAME]
Horror
Action, Adventure, Comedy, Fantasy, Sci-Fi
Animation, Family
Comedy
Crime
Fantasy
Spreadsheet: 74006d1274617384-statistics-sample1
Sheet: FEBUARY 2009

2009-02-01 00:00:00
Client | Calls
Client 1 | 4456
Client 2 | 234
Client 3 | 25
Client 4 | 0
Client 5 | 1
Client 6 | 1222
Client 7 | 89
Client 8 | 222
Client 9 | 33
Client 10 | 3234
Client 11 | 456
Client 12 | 23
Client 13 | 12
Client 14 | 56
Client 15 | 34
Client 16 | 67
Client 17 | 45
Client 18 | 35
Client 19 | 25
Client 20 | 30
Client 21 | 30
Client 22 | 30
Client 23 | 222
Client 24 | 33
Client 25 | 3234
Client 26 | 456
Client 27 | 23
Client 28 | 12
Client 29 | 56
Client 30 | 34
Client 31 | 67
Client 32 | 45
Client 33 | 35
Client 34 | 25
Client 35 | 30
Client 36 | 34
Client 37 | 67
Client 38 | 45
Client 39 | 35
Client 40 | 25
Client 41 | 30
Client 42 | 30
Client 43 | 30
Client 44 | 222
Client 45 | 33
Client 46 | 3234
Client 47 | 456
Different amount of clients for each month
Spreadsheet: 878283d1725356817-calculating-the-time-difference-between-two-dates-working-hours-mode-delivery-delay3
Sheet: Sheet1

Deadline | Finished | [NAME], Working Hours | Delivery Delay (24h mode) |  |  |  | WORKING DAY STARTS: | 09:00:00 | WORKING DAY ENDS: | 17:30:00
2024-03-20 14:15:00 | 2024-07-30 12:05:00
2024-05-07 11:15:00 | 2024-07-30 11:40:00
2024-01-03 13:00:00 | 2024-02-01 16:52:00
2024-03-08 15:30:00 | 2024-03-22 16:03:00
2024-06-18 12:15:00 | 2024-06-28 10:38:00
2024-04-16 14:15:00 | 2024-04-23 15:38:00
2024-07-03 09:00:00 | 2024-07-08 11:37:00
2024-05-03 10:00:00 | 2024-05-07 17:16:00
2024-03-22 15:45:00 | 2024-03-26 08:34:00
2024-08-14 14:45:00 | 2024-08-15 18:04:00
2024-04-30 14:45:00 | 2024-05-01 14:11:00
2024-03-19 11:15:00 | 2024-03-20 09:46:00
2024-02-01 16:00:00 | 2024-02-02 09:26:00
2024-06-17 17:00:00 | 2024-06-18 09:54:00
2024-03-11 17:30:00 | 2024-03-12 08:51:00
2024-05-14 18:15:00 | 2024-05-15 08:27:00
2024-06-27 11:45:00 | 2024-06-27 17:20:00 | 5.583333333197515
2024-02-14 11:00:00 | 2024-02-14 16:15:00 | 5.25
2024-03-28 14:00:00 | 2024-03-28 17:15:00 | 3.249999999941792
2024-06-27 14:15:00 | 2024-06-27 17:06:00 | 2.850000000034925
2024-04-15 11:00:00 | 2024-04-15 12:50:00 | 1.833333333197515
2024-03-26 15:00:00 | 2024-03-26 16:37:00 | 1.616666666697711
2024-05-22 09:45:00 | 2024-05-22 11:08:00 | 1.383333333302289
2024-04-22 11:00:00 | 2024-04-22 12:23:00 | 1.383333333302289
2024-06-17 14:15:00 | 2024-06-17 15:24:00 | 1.150000000081491
2024-06-13 16:45:00 | 2024-06-13 17:51:00
2024-04-30 15:00:00 | 2024-04-30 16:02:00 | 1.03333333338378
2024-02-12 14:45:00 | 2024-02-12 15:25:00 | 0.6666666665696539
2024-07-09 16:00:00 | 2024-07-09 16:35:00 | 0.5833333333139308
2024-03-07 15:15:00 | 2024-03-07 15:33:00 | 0.3000000001047738
2024-06-11 09:00:00 | 2024-06-11 09:06:00 | 0.09999999997671694
2024-02-05 13:45:00 | 2024-02-05 13:49:00 | 0.06666666670935228
2024-06-06 09:00:00 | 2024-06-06 09:03:00 | 0.04999999998835847
2024-07-09 15:30:00 | 2024-07-09 15:33:00 | 0.04999999998835847
2024-01-15 10:00:00 | 2024-01-15 10:02:00 | 0.03333333344198763
Spreadsheet: 75934d1276537306-how-to-transfer-infos-from-1-spreadsheet-to-the-other-finalwork
Sheet: Local sales generated (Jan)

Dopular
Local Sales Generated in the month of January
Location | Product | Cost ($) | Quantity | Total
Bedok | Children Books | 50 | 2500
 | Art and Craft | 20 | 5000
 | Puzzles and Games | 80 | 1000
 | Furnitures | 500 | 800
 | Classroom Supplies | 40 | 8000
 | [NAME] | 2500 | 400
 | Block Play | 80 | 7000
 | CD-ROMS | 70 | 6000
 |  |  | TOTAL
[NAME] | Children Books | 50 | 2000
 | Art and Craft | 20 | 4000
 | Puzzles and Games | 80 | 800
 | Furnitures | 500 | 500
 | Classroom Supplies | 40 | 5000
 | [NAME] | 2500 | 600
 | Block Play | 80 | 5000
 | CD-ROMS | 70 | 5000
 |  |  | TOTAL
Woodlands | Children Books | 50 | 2200
 | Art and Craft | 20 | 4500
 | Puzzles and Games | 80 | 700
 | Furnitures | 500 | 800
 | Classroom Supplies | 40 | 7000
 | [NAME] | 2500 | 500
 | Block Play | 80 | 4000
 | CD-ROMS | 70 | 4500
 |  |  | TOTAL
Orchard | Children Books | 50 | 3000
 | Art and Craft | 20 | 5500
 | Puzzles and Games | 80 | 1500
 | Furnitures | 500 | 900
 | Classroom Supplies | 40 | 8000
 | [NAME] | 2500 | 700
 | Block Play | 80 | 8000
 | CD-ROMS | 70 | 7000
 |  |  | TOTAL
Kallang | Children Books | 50 | 2500
 | Art and Craft | 20 | 5000
 | Puzzles and Games | 80 | 1200
 | Furnitures | 500 | 850
 | Classroom Supplies | 40 | 7500
 | [NAME] | 2500 | 600
 | Block Play | 80 | 7000
 | CD-ROMS | 70 | 7000
 |  |  | TOTAL
Spreadsheet: 701262d1603664652-calendar-for-multi-day-recurring-events-recurring-events-multi-day
Sheet: Setup

 |  | Calendar: |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Event Types & Categories:
 |  |  |  | Year: | 2020 |  |  |  |  |  |  |  |  |  |  |  | Types of Events: |  |  |  |  |  | Categories:
 |  |  |  | Week Start: | Monday |  |  |  |  |  |  |  |  |  |  |  | Cultural (Yearly):
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | People (Yearly):
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Activities: |  |  |  |  |  | Category 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Category 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Category 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Category 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Category 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Category 6
Spreadsheet: 680241d1590872431-how-to-copy-every-10-rows-from-multiple-sheets-to-one-sheet-rezaworksheet
Sheet: sheet1

12
14
23
11
65
23
87
95
43
12
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
Spreadsheet: 1e53e35b-dc49-4cdc-8a45-0e3ca0fc690e
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1
 | Version 2.0
 | Revised 4/08/2009
AP1520 Mesh Range Calculation Utility
For  Cisco Aironet Systems
[NAME]: | [NAME] 1520 Series
Directions for use.
 | 1. Select proper sheet (at the bottom) for the 5Ghz backhaul radio or the 2.4GHz client access radio
 | 2. Select devices being used for both sides of the link.
 | 3. Select datarate being used
 | 4. Select antenna used on each side . If using something other than Cisco/Aironet antennas, enter the gain factor in dBi.
 | 5. Enter antenna heights in meters for both sides
 | 6. Enter the carrier frequency in GHz
 | 7. Select transmit power levels for both sides of the link
 | 8. Select cables being used on each side. If using something other than Aironet cable, select other, then enter the loss/100 ft and the length of cable
 | 9. Select one model that is best suited for your environmental conditions
 | 10. REMEMBER These are THEORETICAL calculations.
Note: | This calculation utility has been edited to stay within limitations for TX power, and EIRP under the listed regulatory domains. There may be cases where it exceeds the limitations, and it is the responsibility of the installing parties to verify the installation is within the laws of the location in which it is being installed.
 | When using this utility, available power levels will changed based upon the regulatory domain, the  antenna (or [NAME] gain) selected, the modulation mode, which is based on the datarate selected (OFDM requires a lower power level in some domains). Verify all parameters after making any parameter changes.
Spreadsheet: 839741d1692192253-need-formula-to-find-count-of-shift-shift_formula
Sheet: dASHBOARD

 |  |  |  |  |  |  |  |  |  |  |  |  | Morning Shift | MS |  | Names
 |  |  |  |  |  |  |  |  |  |  |  |  | Night Shift | NS |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | AS |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | Evening Shift | ES |  | [NAME]
Customer Name | Shifts | Mon | Tue | Wed | Thu | Fri | Sat | Sun |  |  |  |  | Holiday | HD |  | [NAME]
[NAME] | Morning Shift |  |  |  |  |  |  |  |  |  |  |  | Comp Off | C |  | [NAME]
[NAME] | Night Shift | I want formula to calculate shift on Monday for the person |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
[NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
[NAME] | Evening Shift
[NAME] | Holiday
[NAME] | Comp Off
Spreadsheet: 716922d1612425341-combining-columns-into-a-single-column-geomarketing-development-playground
Sheet: Backstage

Backstage
Welcome to the Backstage Page for the Geomarketing Campaign. This is the final sheet to this document. |  |  |  |  |  |  |  |  |  | [NAME] blah
This page contains all the behind-the-scenes wizardry that makes this spreasheet function, so be incredibly careful where you step! You may add, rename, or remove lines from the three tables below to expand out the options available in any given dropdown, but maybe save a backup before doing so -- the first version of this document was lost to some mistakes made in the tables below. Use caution. Any other lists on the page, especially those to the right, should be left unedited. |  |  |  |  |  |  |  |  |  | Waffle
 |  |  |  |  |  |  |  |  |  | [NAME]
RegionTable |  | StoreTable |  | ContentTable
Northeast |  | [NAME] |  | Copy | Copy
Mid-Atlantic |  | Boutique |  | Media | Media
Southern Coast |  | [NAME] |  | [NAME] | [NAME]
Upper Midwest |  | [NAME] |  | Aesthetic Trend | Aesthetic Trend
Lower Midwest |  | Farm & Feed |  | Product of Interest | Product of Interest
Central South |  | [NAME] |  | Color or Style Note | Color or Style Note
Mountain |  | Online
Southwest |  | Pet Daycare
Pacific Northwest |  | Veterinarian
Pacific Coastal |  | Resort & Casino
National | National | Any Retail | Any Retail
For Region x  Store Copy
Region x Store | < K | National x Store | < L | Region x All Stores | < M | National x All Stores | < N
[NAME] blah
Waffle
[NAME]
Spreadsheet: 864525d1711653229-count-instances-or-frequency-multiple-sheets-counting-position-appearances-in-baseball-excel-help-forum-roster-template-2024-03-22-mattg-
Sheet: Game 1

Date: |  | 2024-05-01 00:00:00 |  |  | Field: |  |  | Start Time: |  | 18:00:00
Home: |  |  |  |  | 3rd | Set Up
Visitors: |  |  |  |  | 1st | Clean Up
 |  |  |  |  | Inning
 |  | Player |  |  | Coach Pitch |  |  |  |  |  | Innings on Bench | Innings in Infield | Inninings in Outfield |  |  |  | [NAME]
Order | Column1 | First | Last | # | 1 | 2 | 3 | 4 | 5 | 6
1 | 12 | [NAME] |  |  | 1B (3) | 1B (3) | 1B (3) | LF (7) | LF (7) | LF (7) |  |  |  |  | P (1)
2 | 11 | Ty |  |  | 2B (4) | 2B (4) | 2B (4) | RF (9) | RF (9) | RF (9) |  |  |  |  | C (2)
3 | 1 | [NAME] |  |  | 3B (5) | 3B (5) | 3B (5) | LCF () | LCF () | LCF () |  |  |  |  | 1B (3)
4 | 2 | [NAME] |  |  | LF (7) | LF (7) | LF (7) | 1B (3) | 1B (3) | 1B (3) |  |  |  |  | 2B (4)
5 | 4 | [NAME] |  |  | P (1) | P (1) | P (1) | [NAME] () | [NAME] () | [NAME] () |  |  |  |  | 3B (5)
6 | 5 | Willie |  |  | X | RF (9) | RF (9) | 3B (5) | 3B (5) | 3B (5) |  |  |  |  | SS (6)
7 | 10 | [NAME] |  |  | RF (9) | X | SS (6) | SS (6) | C (2) | C (2) |  |  |  |  | LF (7)
8 | 9 | [NAME] |  |  | SS (6) | SS (6) | X | 2B (4) | 2B (4) | 2B (4) |  |  |  |  | CF (8)
9 | 6 | Babe |  |  | LCF () | LCF () | LCF () | X | SS (6) | SS (6) |  |  |  |  | RF (9)
10 | 7 | [NAME] |  |  | C (2) | C (2) | [NAME] () | P (1) | X | P (1) |  |  |  |  | SF (10)
11 | 8 | [NAME] |  |  | [NAME] () | [NAME] () | C (2) | C (2) | P (1) | X |  |  |  |  | EH ()
12 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  | LCF ()
13 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] ()
Out |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Roster pulled from list on roster tab
 | 9
 | 9
Notes:
 |  |  |  | Players on [NAME]
 |  | Only pull a players first name from the drop down
Spreadsheet: 84588d1284638042-calculate-discount-for-full-column-book1
Sheet: Sheet1

 |  |  |  |  |  | Or with total Discount: | 0.1
Item | Price | Qty | Discount | Total
pen | 1 | 100 | 0.1 | 10 |  |  | 10
airplane | 1000000 | 1 | 0.3 | 300000 |  |  | 100000
chair | 50 | 10 | 0.15 | 75 |  |  | 50
Spreadsheet: 691045d1597426418-excel-ranking-and-sorting-the-data-in-alphabetical-order-and-multiply-conditions-excel-issue-spreadsheet
Sheet: Sheet1

Store | Unique ID | Criteria | Ranking
A | 1 | Yes
A | 2 | Yes
A | 3 | No
F | 150 | No
F | 151 | Yes
F | 152 | Yes
F | 153 | Yes
C | 260 | No
C | 261 | No
C | 262 | Yes
C | 263 | Yes
C | 264 | No
C | 265 | Yes
Notes:
* Ranking to be done in alphabetical order for the Store Name then Unique ID number but only if criteria is met (cell in column C)
So at the end of it I should have data showing as per following:
Store | Unique ID | Criteria | Ranking
A | 1 | Yes | 1
A | 2 | Yes | 2
A | 3 | No | --
F | 150 | No | --
F | 151 | Yes | 6
F | 152 | Yes | 7
F | 153 | Yes | 8
C | 260 | No | --
C | 261 | No | --
C | 262 | Yes | 3
C | 263 | Yes | 4
C | 264 | No | --
C | 265 | Yes | 5
Spreadsheet: 72748d1273487947-finding-a-column-name-iut-1vjezba-nova-web
Sheet: Sheet2

 | Turoperator |  |  |  | 0.487 | 6 | Continent | Sjeverna i  Srednja  Dalmacija
 | [NAME] |  |  |  | 0.38 | 6 | Continent
 | [NAME] upit |  |  |  | 0.303 | 6 | Continent
 | Vlastiti rezervacijski sustav |  |  |  | 0.096 | 6 | Continent
 | Vlastita web stranica |  |  |  | 0.127 | 6 | Continent
 | Globalni rezervacijski sustav |  |  |  | 0.088 | 6 | Continent
 | Ostale internet stranice |  |  |  | 0.045 | 6
 | [NAME]
 | Nezavisni rezervacijski sustav
 | [NAME] poduzeće
1 | Croatia
2 | Istria
3 | Kvarner
4 | Northern and Central Dalmatia
5 | Southern  Dalmatia
6 | Continent
7 | Zagreb
Spreadsheet: 67200d1267794289-vlookup-dates-vlookup-dates-v3
Sheet: SOURCE

 |  |  | If you change any figure here, it should automatically change in Sheet 1 the Mob/Demob dates.
BADGE# | Name | Position | 2010-01-31 00:00:00 | 2010-02-28 00:00:00 | 2010-03-31 00:00:00 | 2010-04-30 00:00:00 | 2010-05-31 00:00:00 | 2010-06-30 00:00:00 | 2010-07-31 00:00:00 | 2010-08-31 00:00:00 | 2010-09-30 00:00:00 | 2010-10-31 00:00:00 | 2010-11-30 00:00:00 | 2010-12-31 00:00:00 | 2011-01-31 00:00:00 | 2011-02-28 00:00:00 | 2011-03-31 00:00:00 | 2011-04-30 00:00:00 | 2011-05-31 00:00:00 | 2011-06-30 00:00:00 | 2011-07-31 00:00:00 | 2011-08-31 00:00:00 | 2011-09-30 00:00:00 | 2011-10-31 00:00:00 | 2011-11-30 00:00:00 | 2011-12-31 00:00:00
VIS0424 |  | PROJECT MANAGER |  |  |  | 0.5 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0.5
15918 |  | CONSTRUCTION MANAGER |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
TBA 2A |  | DEPUTY CONSTRUCTION MGR. |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
TBA 3 |  | H.S.E. MANAGER |  |  |  |  |  | 0.5 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
TBA 30 |  | PROJECT CONTROL MGR. |  |  |  | 0.5 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0.5
TBA 8 | TBA | QUALITY MANAGER |  |  |  |  | 0.5 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
TBA 9 | TBA | FIELD ENGINEER |  |  |  |  | 0.5 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
TBA 10 | TBA | DOCTOR |  |  |  |  |  | 0.5 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
TBA 11 | TBA | SECURITY COORDINATOR | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
TBA 13 | TBA | LOGISTIC MANAGER |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
TBA 14 | TBA | PRECOMM/COMMISSIONING MGR. |  |  |  |  |  |  |  |  |  |  |  |  | 0.5 | 1 | 1 | 1 | 1 | 1 | 1
TBA 15 | TBA | SITE PREP SUPERINTENDENT | 0.5 | 1 | 1 | 0.5
TBA 16 | TBA | MECHANICAL SUPERINTENDENT |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  | PROJECT MANAGER |  |  |  | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16
Spreadsheet: 758821d1639080456-sum-cells-based-on-contents-of-cell-directly-above-material-sum
Sheet: Sheet1

Machine 1
Material | Labor | Cost | Margin |  |  |  |  | Sell Price
10000 | 8000 |  | 0.3
Machine 2
Length, ft | Material/ft | Electrical Material | Material | Labor,% | Labor | Cost | Margin | Sell Price
10 | 1250 | 3000 |  | 0.27 |  |  | 0.22
Machine 3
Material | Labor | Cost | Margin |  |  |  |  | Sell Price
5000 | 8000 |  | 0.3
 |  |  |  |  |  |  |  | Grand Total
 | Material Total Cost