tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 44012d1242684914-condtional-removal-of-symbols-signs-bom_symbols
Sheet: Sheet1

 |  |  | jOB # |  | CHARTWELL AVIATION
 |  |  |  | 211 | STEARMAN DR.
 |  |  | Qty
 |  |  | 175'
 |  |  | 3
 |  |  | 2
 |  |  | 4
 |  |  | 2
 |  |  | 18
 |  |  | 12
 |  |  | 18
 |  |  | 5
 |  |  | 1
 |  |  | 1
 |  |  | 12
 |  |  | 10
 |  |  | 3
 |  |  | 9
 |  |  | 2
 |  |  | 3
 |  |  | 4
 |  |  | 4
 |  |  | 4
 |  |  | 2
 |  |  | 3
 |  |  | 3 each
 |  |  | 1
 |  |  | 24
 |  |  | 18
 |  |  | 44
 |  |  | 120 ea
 |  |  | 1
 |  |  | 1
 |  |  | 50
 |  |  | 200#
 |  |  | 3
 |  |  | 40'
 |  |  | 40
 |  |  | 19
 |  |  | 18
 |  |  | 15
 |  |  | 1
 |  |  | 4
 |  |  | 5
 |  |  | 1
 |  |  | 2
 |  |  | 20
 |  |  | 4
 |  |  | 6
 |  |  | 12
 |  |  | 1
 |  |  | 3
 |  |  | 3
Spreadsheet: 719427d1613661045-sumifs-formula-not-valid-value-hh_job_-template_2021
Sheet: Final

Feedlot:
Date: | 2021 Final Report
Tractors & Loaders | Hrs. | $$/Hr. | Rate Total | Fuel |  |  |  | Invoiced Rate | Invoiced Rate/Hr. | Invoiced Rate/Bu. | Tractors & Loaders | Employee | Bonus Hours
 |  |  |  | Gallons | $$/Gallon | Total | Gal/Hr.
Total
Total
Grand Total |  |  |  |  |  |  |  |  | Rate Total
 |  |  |  |  |  |  |  |  | 'Gross Income' less 'Rate Total'
 |  |  |  |  |  |  |  |  | Percent Gain or Loss
 |  |  |  |  | Total W/Fuel:
Spreadsheet: 246434d1372411702-drop-down-list-payroll-sample
Sheet: MON

DRIVERS |  | TRUCK 1 |  |  | Truck 2 |  |  | TRUCK 3
[NAME] |  | DRIVER | HELPER |  | DRIVER | HELPER |  | DRIVER | HELPER
CURLY
MOE
 |  | ITEM 1 |  |  | ITEM 1 |  |  | ITEM 1
HELPERS |  | ITEM 2 |  |  | ITEM 2 |  |  | ITEM 2
HOMER |  | ITEM 3 |  |  | ITEM 3 |  |  | ITEM 3
BART |  | ITEM 4 |  |  | ITEM 4 |  |  | ITEM 4
KRUSTY |  | ITEM 5 |  |  | ITEM 5 |  |  | ITEM 5
 |  | TOTAL |  |  | TOTAL |  |  | TOTAL
Spreadsheet: 845861d1697187603-adding-a-1-25-to-an-iferror-formula-result-leavedata-1-_edited-13-oct-2023
Sheet: Sheet1

Name and Surname | Type of Leave | Leave Balance | Number of Days Approved | New Leave Balance | Start Date | End Date
User 1 |  |  |  | 15 | 2022-12-21 00:00:00
User 2 |  |  |  | 18.75 | 2022-12-08 00:00:00
User 3 |  |  |  | 16.25 | 2023-02-02 00:00:00
User 4 |  |  |  | 15.25 | 2023-03-28 00:00:00
User 5 |  |  |  | 15 | 2023-01-03 00:00:00
User 1 | Annual Leave |  | 1 |  | 2022-12-22 00:00:00 | 2022-12-22 00:00:00
User 1 | Annual Leave |  | 1 |  | 2023-01-05 00:00:00 | 2023-01-05 00:00:00
User 2 | Annual Leave |  | 3 |  | 2023-01-07 00:00:00 | 2023-01-09 00:00:00
User 3 | Annual Leave |  | 5 |  | 2023-02-03 00:00:00 | 2023-02-07 00:00:00
User 4 | Annual Leave |  | 5 |  | 2023-04-01 00:00:00 | 2023-04-05 00:00:00
User 5 | Annual Leave |  | 2 |  | 2023-01-08 00:00:00 | 2023-01-10 00:00:00
User 1 | Annual Leave |  | 3 |  | 2023-02-07 00:00:00 | 2023-02-09 00:00:00
User 4 | Annual Leave |  | 5 |  | 2023-06-06 00:00:00 | 2023-06-10 00:00:00
User 2 | Annual Leave |  | 4 |  | 2023-01-11 00:00:00 | 2023-01-14 00:00:00
User 3 | Annual Leave |  | 6 |  | 2023-03-08 00:00:00 | 2023-03-13 00:00:00
User 5 | Annual Leave |  | 3 |  | 2023-09-19 00:00:00 | 2023-09-21 00:00:00
User 5 | Annual Leave |  | 8 |  | 2023-10-01 00:00:00 | 2023-10-08 00:00:00
User 1 | Annual Leave |  | 1 |  | 2023-04-02 00:00:00 | 2023-04-02 00:00:00
User 3 | Annual Leave |  | 2 |  | 2023-05-18 00:00:00 | 2023-05-20 00:00:00
User 2 | Annual Leave |  | 4 |  | 2023-11-01 00:00:00 | 2023-11-04 00:00:00
User 4 | Annual Leave |  | 4 |  | 2023-07-08 00:00:00 | 2023-07-11 00:00:00
Spreadsheet: 141084d1329079873-excel-2007-how-to-grab-information-from-other-sheets-and-place-it-in-the-main-sheet-fulllist
Sheet: Swimming

 |  |  | Swimming
Special Instructions for Swimming…
1. Maximum four(4) events per person, including relays |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Accounts (see 'EventList' Worksheet for Entry Fees)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Insert $ pd in appropriate
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pymt Method
Event & Age Group (use dropdown list) | Team Name (if applicable) | Level of Play | First Name | Last Name | Capt(*) | Sex | Date of Birth | Address | Suburb | State(abbr) | Postcode | Phone # | [NAME] | [NAME] | Golf Club | Squash Grade | Tenpin Average | Bowling Centre | Preferred Day | Time | Rego/Soc | Business Unit | Employee# | T-Shirt Size | Cheque | Cash | Direct Deb | Total |  | Notes
Spreadsheet: 489158d1479134741-mileage-reimbursement-formulas-not-working-mileage-form-issue
Sheet: Ref-DropDowns

List_Yes_No |  | List of Locations
Yes |  | Amityville |  | <--Anytime you ADD new columns to the mileage or minutes table, click in here then hit refresh
No |  | Bay Shore 180
 |  | Bay Shore 375
 |  | Brentwood
 |  | Deer Park
 |  | Garden City
 |  | Hauppauge (LIVM / Middle Country Management)
 |  | Hauppauge 110 Marcus Blvd
 |  | Hempstead
 |  | Holbrook
 |  | Huntington 148 E Main
 |  | [NAME] 281 Main
 |  | Huntington Park Ave
 |  | Little Neck
 |  | Manhattan E. 27th Street
 |  | Other (Please explain thoroughly in the next column)
 |  | Patchogue
 |  | Port Jefferson
 |  | Riverhead
 |  | Rockville Centre
 |  | Sayville
 |  | Smithtown
 |  | Southampton
 |  | Southold
 |  | West Islip
Spreadsheet: darrell_schoolcraft__7792__imbalsumm0107
Sheet: Citizens-Griffith

 | Citizens-Griffith
 | POI 78069 - Citizens Griffith
Day | Measured | Scheduled
1 | 0 | 0
2 | 0 | 0
3 | 0 | 0
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18 | -349
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-06-30 00:00:00 |  |  | -216141.13
2001-07-18 00:00:00
Spreadsheet: 188406d1350877867-consolidate-rows-with-duplicate-id-number-into-one-row-consolidation-example
Sheet: Sheet2

ID # | A | B | C | A' | B' | C'
1 | x | y | z
2 | x | y | z
3 | x | y | z | x | y | z
4 | x | y | z
5 | x | y | z | x | y | z
6 | x | y | z
Spreadsheet: 857056d1706139423-lookup-4000-lines-to-40-columns-nolook
Sheet: codes no header

[SCAN] |  |  | CodeGroup | CodeType | Description | Field1 | LineColour | LineForce | LineLayer | LineLTScale | LineStyle | LineThick | PointColour | PointLayer | PointModel | PointSize | [NAME] | TextAlign | TextColour | TextLayer | TextString | TextStyle | Transfer
Description=GPR Scan |  | [SCAN] |  | 0x0000000b | GPR Scan | I1,"Scan No.",2, | 122 |  | FPS-UG-GPR_SCAN | 0.1 | GPR Scan | 0.09 | 122 | FPS-UG-GPR_SCAN | 0 | 6.0 | Dot | 4 | 122 | FPS-UG-GPR_SCAN | %I1%\n%REM% | Feature Text
Transfer= |  | [PFRL] |  | 0x00000009 | Flat Roof Level |  |  |  |  |  |  |  |  | FPS-BUILDING | 0 | 2.0 | Plus |  | 7 | FPS-LEVELS | Flat Roof\n%.2PZ% | Feature Text
CodeGroup= |  | [AGP] |  | 0x0000000b | AG-PIPEWORK |  | 8 | 0 | FPS-AG-UNKNOWN | 0.1 | Centre Half | 0.09 | 8 | FPS-AG-UNKNOWN | 0 | 2.0 | Dot | 4 | 8 | FPS-AG-UNKNOWN-TEXT | Above Ground Pipework | Feature Text
[NAME]
PointLayer=FPS-UG-GPR_SCAN
PointStyle=Dot
PointColour=122
PointSize=6.0
PointModel=0
LineLayer=FPS-UG-GPR_SCAN
LineStyle=GPR Scan
LineColour=122
LineThick=0.09
LineLTScale=0.1
TextLayer=FPS-UG-GPR_SCAN
TextStyle=Feature Text
TextColour=122
TextAlign=4
TextString=%I1%\n%REM%
Field1=I1,"Scan No.",2,
[PFRL]
Description=Flat Roof Level
Transfer=
CodeGroup=
CodeType=0x00000009
PointLayer=FPS-BUILDING
PointStyle=Plus
PointSize=2.0
PointModel=0
TextLayer=FPS-LEVELS
TextStyle=Feature Text
TextColour=7
TextString=Flat Roof\n%.2PZ%
[AGP]
Description=AG-PIPEWORK
Transfer=
CodeGroup=
[NAME]
PointLayer=FPS-AG-UNKNOWN
PointStyle=Dot
PointColour=8
PointSize=2.0
PointModel=0
LineLayer=FPS-AG-UNKNOWN
LineStyle=Centre Half
[NAME]
LineForce=0
LineThick=0.09
LineLTScale=0.1
TextLayer=FPS-AG-UNKNOWN-TEXT
TextStyle=Feature Text
TextColour=8
TextAlign=4
TextString=Above Ground Pipework
Spreadsheet: 1e3e8792-3e34-4baa-b65e-54005fd6ab3f
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Name | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 |  |  |  | Learner ID
 |  |  |  | School/College/University
Agriculture, Food and Natural Resources: Agribusiness Systems
Career Pathway Plan of Study for ►Learners ►Parents ►Counselors ►Teachers/Faculty
This Career Pathway Plan of Study (based on the Agribusiness Systems Pathway of the Agriculture, Food and Natural Resources Career Cluster) can serve as a guide, along with other career planning materials, as learners continue on a career path. Courses listed within this plan are only recommended coursework and should be individualized to meet each learner’s educational and career goals. *This Plan of Study, used for learners at an educational institution, should be customized with course titles and appropriate high school graduation requirements as well as college entrance requirements.
EDUCATION | LEVELS | GRADE | [NAME] | Math | Science | Social Studies/ Sciences | Other Required Courses Other Electives Recommended       Electives                         Learner Activities | *Career and Technical Courses                    and/ or Degree Major Courses for               Agribusiness Systems Pathway | SAMPLE                                   Occupations Relating                            to This Pathway
 |  | Interest Inventory Administered and Plan of Study Initiated for all Learners
[NAME] |  | 9 |  |  |  |  |  |  | Occupations Requiring Postsecondary Education ►Agricultural Chemical Dealer ►Agricultural Products Buyer -           .   Distributor ►Bank/Loan Office ►Dairy Herd Supervisor ►Entrepreneur ►Farm Manager ►Farmer-Rancher-Feedlot                    .   Operator ►Feed-Supply Store Manager ►Field Representatives for Bank,            .    Insurance Company or                      .   Government Program ►Livestock Manager  ►Sales Manager ►Salesperson                                                    .                                                      Occupations Requiring Baccalaureate Degree ►Agricultural Commodity Broker ►Agricultural Economist ►Agricultural Educator ►Agricultural Lender ►Banker/Loan Officer ►Farm Investment Manager ►Produce Commission Manager
 |  | 10
 |  | 11
 |  | College Placement Assessments-Academic/Career Advisement Provided
 |  | 12
 |  | Articulation/Dual Credit Transcripted-Postsecondary courses may be taken/moved to the secondary level for articulation/dual credit purposes.
POSTSECONDARY |  | Year 13
 |  | Year14
 |  | Year 15
 |  | Year 16
 |  |  |  |  |  | Project funded by the U.S. Department of Education (VO51B020001)
Spreadsheet: 275275d1383428403-vlookup-on-multiple-column-data-test
Sheet: Before

[NAME] |  |  | D&B # - AIMS (via SFDC) | D&B # | D&B # - SFDC | Name
1234232 |  |  | 124213123 | 123123 | 156192481 | xxllc
243574188 |  |  | 1232321313 | 243574188 | 243574188 | xxllc
248175676 |  |  | 2142141 | 12321321 | 248175676 | xxllc
248134236 |  |  | 322132 | 23213123 | 248134236 | xxllc
42324124 |  |  | 213213 | 2321321 | 12123213 | xxllc
12314521421 |  |  | 12321311 | 243113938 | 123213 | xxllc
123213 |  |  | 113213 | 123213 | 1232131 | xxllc
124214 |  |  | 1232124 | 2321 | 1232132 | xxllc
12321 |  |  | 1223213 | 23213 | 252004577 | xxllc
123213 |  |  | 1213213 | 12321 | 200521102 | xxllc
257432823 |  |  | 142321 | 123221 | 257432823 | xxllc
123213 |  |  | 1213213 | 243967259 | 12321312 | xxllc
Spreadsheet: 672791d1587005494-fetch-data-for-todays-date-daily-report-example
Sheet: WIL

[NAME] |  |  | Nightly Report
Shop: | Wilsonville
Week Ended: | 2020-04-19 00:00:00
THIS WEEKS BUDGET NUMBERS |  | LY Sales
Budgeted Sales Increase | 0.05
Budgeted Catering Sales Increase | 0.05
Budgeted Guest Count Increase | 0.02
[NAME] | 12.24
Budgeted Labor % | 0.17
Budgeted Labor Hours Variance | 5
Budgeted Food Variance | 0.005
[NAME] | 50
Gross Sales-Budget
Net Sales-Budget
Catering Sales-Budget
Guest Count-Budget
 | 3
DATE
DAY | Mon | Tue | Wed | Thu | Fri | Sat | Sun | WTD Total
MANAGER
BUDGETED SALES PER DAY % | 0.1425 | 0.1425 | 0.1425 | 0.1425 | 0.1425 | 0.1425 | 0.1425
BUDGETED SALES PER DAY
[NAME] | 2683.81 | 2802.96 | 2834 | 3538.9 | 2665.5 | 3507.7 | 1663.65
[NAME] | 0 | 600 | 270 | 540 | 0 | 691
LY ONLINE SALES PER DAY | 58.8 | 26.4 | 194.35 | 220.8 | 67.7 | 42 | 69.3
LY DELIVERY SALES PER DAY | 81.84 | 19.56 | 19.27 | 56.7 | 59.89 | 88.65 | 26.94
LY NET SALES PER DAY | 2145.97 | 2569.29 | 2604.07 | 3278.72 | 2476.12 | 3260.02 | 1550.04
CATERING SALES | 450 | 0
CATERING AS % GROSS SALES
CATERING SALES Y-Y
ONLINE SALES | 242.7 | 431.15
ONLINE SALES AS % GROSS SALES
ONLINE SALES Y-Y
DELIVERY SALES | 206.45 | 208.8
DELIVERY SALES AS A % GROSS SALES
DELIVERY SALES Y-Y
TOTAL GROSS STORE SALES | 1775.7 | 1419.6
GROSS SALES Y-Y
GROSS SALES VARIANCE TO BUDGET
PROMO | 97.2 | 35.63
PROMO %
VOIDS | 0
NET TOTAL $ | 1667.07 | 1383.97
Spreadsheet: mary_hain__25859__IOU04
Sheet: New Load Forecasts

 |  |  | Using Rate Case Market Estimate |  |  | Using 42$/MWh |  | Using $42 and 400 million CRAC
 |  | Load | Price | Market | Benefit in Millions | Market | Benefit in Millions | Price w/CRAC | Market | Benefit in Millions | m/kwh Incr
IOU
 | Exchange | 900
 | RL | 1000 | 19.25 | 28.1 |  | 42
Public
 | PF | 5575 | 19.25 | 28.1
 | FPS I&S | 125 | 14.25 | 28.1
DSI
 | IPTAC | 1490 | 23 | 28.1
 |  |  |  | Revenue Subject to CRAC: |  |  |  | million | Benefits
 |  |  |  |  | Rate multiplier
 |  |  |  |  |  | CRAC $ | 400
Spreadsheet: 673971d1587614751-if-formula-for-counting-if-function
Sheet: Sheet1

SOP buffersize calculation |  |  |  |  |  |  | Main production line decreasing parts |  |  |  |  |  |  |  | Time-line adding parts
Part | Needed QTY | Time per part [min] |  | QTY Shifts | SOP QTY |  | min. 0 | min. 150 | min. 300 | min. 450 | min. 600 | min. 750 | min. 900 |  | Start moment assembling #1 | Start moment assembling #2 | Assembling QTY #1 | Assembling QTY #2 | Finished moment assembling #1 | Finished moment assembling #2 |  | Buffer at 0 minutes | Buffer at 150 minutes | Buffer at 300 minutes | Buffer at 450 minutes | Buffer at 600 minutes | Buffer at 750 minutes | Buffer at 900 minutes
Kleinteile | 6 | 150 |  | N.A. | 3 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1
Supply Spisto | 6 | 10 |  | 1 | 3 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  | 0 |  | 6
Lüfter | 6 | 30 |  | 1 | 3 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  | 60 |  | 6 |  | 240
Rucksack | 6 | 20 |  | 1 | 3 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  | 240 |  | 6 |  | 360
Auslegearm | 6 | 15 |  | 1 | 3 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  | 360 |  | 6 |  | 450
Schaltschrank | 6 | 360 |  | 2 | 3 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  | 0 |  | 1 |  | 360
Fluidbox | 6 | 240 |  | 2 | 3 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  | 0 |  | 6 |  | 360
Külhaggregat + Abt. BFA | 6 | 20 |  | 1 | 3 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  | 0 | 300 | 3 | 3 | 60 | 360
Motorspindle | 6 | 60 |  | 1 | 3 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  | 30 |  | 6 |  | 390
Engines (per set) | 6 | 90 |  | 1 | 3 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  | 0 | 70 | 3 | 3 | 60 | 130
Schwenkrundtisch | 6 | 10 |  | 1 | 3 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  | 0 | 390 | 3
Werkzeugmagazine | 6 | 105 |  | 2 | 3 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  | 0 |  | 6
Kabine | 6 | 360 |  | 2 | 3 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  | 0 |  | 6
Öl-Nebelabschreider | 6 | 90 |  | 2 | 3 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  | 0 |  | 6
Min. buffersize | 2
[NAME]. buffersize | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Situation 1 | value colum P and T both under 150
Buffer minutes parameters | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Situation 2 | ONE of the value of colum P or T is lower than 150 AND(!) bigger than 0
 | 150 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Situation 3 | Both values colum P and T are above the value of 150
 | 300 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Situation 4 | Value P and T is between 0 and 450 AND value Q and T are NOT between 0-450
 | 450
 | 600 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Situation 1 formula |  | [NAME] moet [NAME] [NAME] -->
 | 750 |  |  |  |  |  |  |  |  |  |  |  |  |  | TEST
 | 900 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Situation 2 formula |  | [NAME] moet [NAME] [NAME] -->
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Situation 3 formula |  | [NAME] moet [NAME] [NAME] -->
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Situation 4 formula |  | [NAME] moet [NAME] [NAME] -->
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Situation 5 formula
Spreadsheet: 376286d1423549112-how-to-automatically-update-info-based-on-blank-cell-payslipeg
Sheet: Capture sheet

Employee Name | [NAME]
ID number | 22300998766
Employer address | 12 Smith street, area, city
Date engaged | 2014-09-01 00:00:00
UIF | 123456/45
Date of pay | 05/01/2015 - 30/01/2015
 | 2014 |  |  |  | 2015
 | Sept | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
Basic Pay | 1900 | 2300
Public holidays paid | 100 | 0
Travel allowance | 250 | 250
Overtime | 0 | 150
Sundays/public holidays worked | 0 | 0
Other | 0 | 200
Bonus | 0 | 0
Total income
TAX | 0 | 0
UIF Employee | 0 | 0
UIF Employer
Leave taken
Annual | 0 | 0
Sick | 0 | 0
FR | 0 | 0
Days worked
Payslip info
Total income cumulative
Total tax
Total UIF employer
Total UIF employee
Total transport allowance
Total days worked cumulative
Annual leave
Annual leave taken
Sick leave
Sick leave taken
FR leave | 5
FR taken
Spreadsheet: 796742d1663496677-i-want-to-put-ok-if-the-match-with-conditions-between-tables-are-filled-recherche-etaf
Sheet: Feuil1

Code legacy | Libellé site | Code cible
12 | test | 13
13 | test23 | 10
14 | test18 | 100 |  | Nom1 | Nom2 | Nom3 | Nom4
15 | test1 | 101 |  | A3RR | 45 | 12 | 26 | [NAME]
 |  |  |  | 13 | test23 | 10 | 12 | ok
 |  |  |  | 14 | test18 | 100 | 1 | ok
 |  |  |  | GFGHFGJ | 0 | 0 | 0 | [NAME]
Spreadsheet: 453983d1459549999-unique-list-of-data-sample-archimaitreya
Sheet: Sheet1

 |  |  |  |  |  |  | Condition 1 | AA
 |  |  |  |  |  |  | Condition 2 | 1
 |  |  | Client Name | Name | Amount | Type |  | Name | Amount
 |  |  | ABC | AA | 10 | 1
 |  |  | ABC | AA | 20 | 1
 |  |  | PQR | AA | 20 | 1
 |  |  | LMO | BBB | 10 | 2
 |  |  | FACE | BBB | 40 | 1
 |  |  | KEEP | DD | 40 | 2
 |  |  | SMOOTH | DD | 50 | 1
 |  |  | LIKE | EEE | 60 | 1
 |  |  | DEM | FFF | 100 | 1
Spreadsheet: jeffrey_a_shankman__13954__MgmtSum-Q401-Global-112301
Sheet: QTD Mgmt Summary

Enron Global Markets |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PRIVATE & CONFIDENTIAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4th QTR 2001 EARNINGS ESTIMATE
 |  | Margin |  |  |  | Expenses (1) |  |  |  | EBIT |  |  |  | Change - Fav / (Unfav)
Business Team |  | Actual | Plan | [NAME] |  | Forecast | Plan | [NAME] |  | Forecast | Plan | [NAME] |  | Margin | Expenses (1) | Total
Crude & Products
Coal / Emissions
Vessel Trading
Emissions
Weather
Insurance Risk Markets
Financial Trading
Freight
LNG
Puerto Rico
Japan
Drift
Finance and Structuring
Office of the Chairman
Overview
Subtotal Commercial
Credit Reserve |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0
Financing Related |  |  | 0 |  |  |  | 0
Group Cost |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 0
Support Cost Allocated to Teams |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 0
Other Interest Related Charges |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Capital Charge Offset |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Global Markets EBIT
Interest Expense/(Income) |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Global Markets Pre-tax Income
(1) Includes direct and allocated expenses
Spreadsheet: 766563d1643941584-reverse-vlookup-index-match-combo-unsure-how-to-proceed-excel-help-file
Sheet: Sheet1

 | LaneSet | [NAME] | Store |  | [NAME] | Associate | Lanes
 | 0 | 1 | a |  | 1 | 123 | 2 | 3 | 4 | 0 | 0
 | 1 | 2 | b |  | 2 | 3456 | 5 | 6 | 7 | 0 | 0
 | 1 | 3 | c |  | 3 | 765 | 8 | 9 | 10 | 11 | 0
 | 1 | 4 | d |  | 4 | 231 | 12 | 13 | 0 | 0 | 0
 | 2 | 5 | e |  | 5 | 9854 | 14 | 15 | 16 | 0 | 0
 | 2 | 6 | f |  | 6 | 962 | 17 | 18 | 19 |  | 0
 | 2 | 7 | g
 | 3 | 8 | h
 | 3 | 9 | i
 | 3 | 10 | j
 | 3 | 11 | k
 | 4 | 12 | l
 | 4 | 13 | m
 | 5 | 14 | n
 | 5 | 15 | o
 | 5 | 16 | p
 | 6 | 17 | q
 | 6 | 18 | r
 | 6 | 18 | s
 | 6 | 19 | t
Spreadsheet: 85609d1285690054-tracking-monthly-revenue-when-a-job-rolls-over-into-next-month-test1
Sheet: Sheet2

REVENUE - August
Date | Customer |  | Well Name | Start Date | W/R | End Date | MFC |  | G1/G10 | TS | FUEL |  | GB |  | RC |  | DELV |  | RU | Damages | RD | Total Days | Revenue
2010-08-02 00:00:00 | EOG |  | BECHAM 10, 11H | 2010-08-02 00:00:00 | WORKING | 2010-08-11 00:00:00 | 400 |  |  |  |  |  |  |  |  |  |  |  | 630 |  | 210
2010-08-01 00:00:00 | [NAME] |  | BOB SMITH 1H | 2010-07-01 00:00:00 | WORKING | 2010-09-25 00:00:00 | 35
2010-08-15 00:00:00 | EOG |  | BONE RANCH | 2010-08-15 00:00:00 | WORKING | 2010-09-12 00:00:00 |  |  |  |  |  |  | 150 |  |  |  | 180
Spreadsheet: 07f073ba-3617-4bc6-99ec-4b3b299a3154
Sheet: PCH_O

To be completed EVERY TIME Petty Cash/Cash Floats change custodianship
UNIVERSITY OF SOUTHERN QUEENSLAND
HAND OVER / TAKE OVER RECONCILIATION
 |  |  |  |  |  |  | Version 2.1
 |  |  |  |  |  |  | Mar 2012
 |  | DEPARTMENT NAME: |  | (enter Department name here)
 |  | DEPT ID: |  | (Dept ID here) | DATE: |  | (Date of hand over here)
 |  | HAND OVER CUSTODIAN: |  | (Name of employee handing over custodianship)
 |  | TAKE OVER CUSTODIAN: |  | (Name of employee taking over custodianship)
 |  |  |  |  | On Hand |  | [NAME]
 |  |  | Petty Cash
 |  |  | Consisting of:
 |  |  | Cash on Hand
 |  |  | Vouchers to be Reimbursed
 |  |  | Cash Registers
 |  |  | Register 1
 |  |  | Register 2
 |  |  | Register 3
 |  |  | Change Float
 |  |  | Collections Not Banked
 |  |  | Other Cash Floats
 |  |  | Cashier
 |  |  | Relief Cashier
 |  |  | Emergency Loans
 |  |  | English Language Cultural Program
 |  |  | Tickets – Artsworx
 |  |  | [NAME] – Artsworx
 |  |  | Programs – Artsworx
 |  |  | TOTAL
I hereby certify that the above petty cash advances are in existence and that cash together with the authorised vouchers are held in accordance with the approved procedures.  For details on the approved procedures refer to the Petty Cash Policy
 |  |  |  | [NAME]
 |  |  | Hand Over Officer |  | Take Over Officer
Signature:
Position: |  |  | (type details here) |  | (type details here)
 | Completed form to be forwarded to Assistant Accountant (Financial Reporting & Analysis) - Financial & Business Services
Spreadsheet: 180156d1347492044-combo-box-not-working-time
Sheet: Sheet3

Time | 00:01:15
Adjustment | 1900-01-11 00:00:00
New Time
 |  |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  |  | 00:00:00.100000
 |  |  |  |  |  |  |  |  | 00:00:00.200000
 |  |  |  |  |  |  |  |  | 00:00:00.300000
 |  |  |  |  |  |  |  |  | 00:00:00.400000
 |  |  |  |  |  |  |  |  | 00:00:00.500000
 |  |  |  |  |  |  |  |  | 00:00:00.600000
 |  |  |  |  |  |  |  |  | 00:00:00.700000
 |  |  |  |  |  |  |  |  | 00:00:00.800000
 |  |  |  |  |  |  |  |  | 00:00:00.900000
 |  |  |  |  |  |  |  |  | 00:00:01
 |  |  |  |  |  |  |  |  | 00:00:01.100000
 |  |  |  |  |  |  |  |  | 00:00:01.200000
 |  |  |  |  |  |  |  |  | 00:00:01.300000
 |  |  |  |  |  |  |  |  | 00:00:01.400000
 |  |  |  |  |  |  |  |  | 00:00:01.500000
 |  |  |  |  |  |  |  |  | 00:00:01.600000
 |  |  |  |  |  |  |  |  | 00:00:01.700000
 |  |  |  |  |  |  |  |  | 00:00:01.800000
 |  |  |  |  |  |  |  |  | 00:00:01.900000
 |  |  |  |  |  |  |  |  | 00:00:02
 |  |  |  |  |  |  |  |  | 00:00:02.100000
 |  |  |  |  |  |  |  |  | 00:00:02.200000
 |  |  |  |  |  |  |  |  | 00:00:02.300000
 |  |  |  |  |  |  |  |  | 00:00:02.400000
 |  |  |  |  |  |  |  |  | 00:00:02.500000
 |  |  |  |  |  |  |  |  | 00:00:02.600000
 |  |  |  |  |  |  |  |  | 00:00:02.700000
 |  |  |  |  |  |  |  |  | 00:00:02.800000
 |  |  |  |  |  |  |  |  | 00:00:02.900000
 |  |  |  |  |  |  |  |  | 00:00:03
Spreadsheet: 82168d1282184122-sum-finite-number-of-cells-based-on-status-of-other-cells-example-rev1-
Sheet: Sheet1

X |  | 4
X |  | 8
X |  | 4
Y |  | 6
Y |  | 3
X |  | 2
X |  | 4
Y |  | 5
Y |  | 7 |  |  |  |  | Your original data
X |  | 4
X |  | 2
Y |  | 6
X |  | 4
Y |  | 3
X |  | 6
X |  | 4
X |  | 7
Y |  | 8
X |  | 5
So I am looking to sum the B column values from rows 1,2,3,6,7,10,11,13,15 and 16, and then disregard all data past row 17.
Desired result=