tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 839304d1691810597-excel-formula-to-calculate-stock-transaction-sample
Sheet: Sheet1

Date | Type | Stock | Transacted Units | Transacted Price (per unit) | Comm | Cls Fee | Tdg Fee | Buying Fee | SGX SI Fee | GST Fee | Fees | Stock [NAME] | Previous Units | Cumulative Units | Transacted Value | Previous Cost | Cost of Transaction | Avg Stock Price | Cumulative Cost | Gains/Losses from Sale | [NAME]  %
2023-05-03 00:00:00 | Buy | ABC | 300 | 32.44 | 27.25 | 3.16 | 0.73 | 0 | 0.35 | 2.52 |  | 1
2023-05-22 00:00:00 | Div | ABC | 300 | 0.42 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
2023-11-08 00:00:00 | Div | ABC | 300 | 0.48 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
2023-08-12 00:00:00 | Buy | ABC | 400 | 32.44 | 27.25 | 3.16 | 0.73 | 0 | 0.35 | 2.52 | 34.01000000000001 | 1
2023-08-15 00:00:00 | Buy | ABC | 500 | 32.44 | 27.25 | 3.16 | 0.73 | 0 | 0.35 | 2.52 | 34.01000000000001 | 1
 |  |  |  |  |  |  |  |  |  |  | Expected Result |  | 700 | 1200 | 16254.01 | 22776.02 |  |  | 39030.03
Spreadsheet: 844079d1695892886-daily-average-needed-to-reach-a-monthly-goal-sales-update
Sheet: Sample 2

 | Store
 | Month
 | [NAME] |  | 156361.3
 | Target Level 1 |  | 171997
 | Date | Sales Achieved | Total Transaction | Sales Per Receipt (SPR) | Required Sales Per Day | Daily Sales Target | [NAME] | Days Left
 |  | 4971.85 | 224 |  |  |  |  | 30
 |  | 6565.8 | 290 |  |  |  |  | 29
 |  | 6478.95 | 284 |  |  |  |  | 28
 |  | 4506.3 | 185 |  |  |  |  | 27
 |  | 5410.65 | 197 |  |  |  |  | 26
 |  | 4858.55 | 217 |  |  |  |  | 25
 |  | 4766.75 | 220 |  |  |  |  | 24
 |  | 5632.17 | 230 |  |  |  |  | 23
 |  | 6728.85 | 266 |  |  |  |  | 22
 |  | 7767.35 | 312 |  |  |  |  | 21
 |  | 3801.15 | 188 |  |  |  |  | 20
 |  | 4357.55 | 211 |  |  |  |  | 19
 |  | 3801.9 | 191 |  |  |  |  | 18
 |  | 3720.65 | 205 |  |  |  |  | 17
 |  | 4840.7 | 217 |  |  |  |  | 16
 |  | 6525.75 | 285 |  |  |  |  | 15
 |  | 6262.45 | 265 |  |  |  |  | 14
 |  | 4207.2 | 173 |  |  |  |  | 13
 |  | 4335.35 | 188 |  |  |  |  | 12
 |  |  |  |  |  |  |  | 11
 |  |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  | 1
 | Total Sales
 | Balance to Hit Base
 | Balance to Hit Level 1
 | Total Transaction
Spreadsheet: jeff_dasovich__14164__m010508g
Sheet: Core & Non-core

 |  |  |  |  |  |  | Toggle switch | 0 | 1=83,000 mw
 | 2001 |  |  |  |  |  | Total Vol |  | 0=93,000 mw
 | PGE | SCE | SDGE |  |  |  | Toggle switch | 0 | 1=dwr for spot (104)
 |  |  |  |  |  |  | Prices |  | 0=dwr/hen for spot (82.75)
Under 500kW (core) CPUC
Over (non core) CPUC |  |  |  |  |  |  | Toggle switch | 1 | 1=All nc
Total CPUC (demand) |  |  |  |  |  |  | Past Utility |  | 0=Core and NC
[NAME] (supply)* |  |  |  |  |  |  | Toggle switch | 0 | 1=Over 500kW
 |  |  |  |  |  |  | 20kW/500kW |  | 0=Over 20kW
[NAME] |  |  |  |  |  |  | *Past Utility - PG&E, SCE only
Open long (short)
Core / Open Long / (short) position |  |  |  |  |  |  | Under 20kW
 |  |  |  |  |  |  | PGE | SCE
 |  |  |  |  |  | Under 20kW Core
* From 2001 estimated (page 27 MOU slides) |  |  |  |  |  | Over 20kW - Non-core
 |  |  |  |  |  |  | Under 20kW 25%/75% Scenario
 |  |  |  |  |  |  | PGE | SCE
 | PGE | SCE | SDGE |  |  | Under 20kW Core
 |  |  |  |  |  | Over 20kW - Non-core
Past DWR |  | 400
Future DWR |  | 2700 |  |  |  |  | Under 20kW 50%/50% Scenario
Past Utility with 15 year amortization assumption |  | 300 |  |  |  |  | PGE | SCE
Future Utility |  | 3900 |  |  |  | Under 20kW Core
 |  |  |  |  |  | Over 20kW - Non-core
Total Gen
 |  |  |  |  |  |  | Toggle switch | 1 | 1=25% of Under 20kW - Non-Core/75% of Under 20kW - Core
Other T&D |  |  |  |  |  |  | Under 20kW |  | 0=50% of Under 20kW - Non-Core/50% of Under 20kW - Core
 |  |  |  |  |  |  | *Past Utility - PG&E, SCE only
Total Revenue
Other T&D per Ghw (cents) | 3.91 | 4.2 | 6.23
T&D per CPUC | 3.95 | 4.02
Core Cost: |  |  |  |  | Cents per kw:
Share of past DWR
Cost of short
Value of long
Cost of generation + QF
Share of Past Utility with 20 year amortization |  |  | 0
Total Gen
Other T&D (at~200% of non-core rate)
Total
Total Core Load
Cost to Core
Cost to Core per proposed CPUC
Non-Core Cost: |  |  |  |  | Cents per kw:
Share of past DWR
Cost of short
Share of Past Utility with 20 year amortization
Total Gen
Other T&D
Total
Total Non-Core Load
Cost to Non-Core
Cost to Non-Core per proposed CPUC
 | PGE | SCE | SDGE
Core Rate T&D (cents) |  |  | 6.379
Non Core T&D (cents)
All T&D  (cents)
Total dollars T&D
Core T&D/non core T&D
Core T&D/ All T&D
Per 12/31/00 10-K (kwh) | 81923 | 83436 | 19322
Electric revenue | 6854 | 7870 | 2184
Electric Revenue per kwh
Generating portion per MOU | 5.5 | 6.3 | 5.5
T&D and other costs
T&D and other costs
Spreadsheet: tracy_geaccone__40248__C0366-111726
Sheet: Dept_100182

ENRON PROPERTY & SERVICES CORP
1400 Smith Street
Houston, Texas   77251 - 1188
MONTHLY INVOICE DETAIL
BUILDING SERVICES - Dept. 100182
January, 2001
0366  EOC - Executive
Date | Ticket Number | Work Order | Requisitioner Name | Service Description | # [NAME] | Unit Cost | UOM | Service | Ticket
 |  |  |  |  |  |  |  | Total | Total
 |  |  | R/C 111726
2001-01-24 00:00:00 | BSV100182-2001-01-0366-111726 |  | Building Services | Sq. Ft. Occupied | 1097 | 0.03 | /EACH | 32.91
 |  |  |  |  |  |  | Ticket Total |  | 32.91
 |  |  |  |  |  |  | Total for R/C: 111726 |  | 32.91
 |  |  |  |  |  |  | Total for Dept_100182 |  | 32.91
Spreadsheet: 71048d1271790420-match-function-match-example
Sheet: Sheet1

 | 1 | 2 | 3 | 4 | 5 |  | Column | Row | Letter
1 | D | D | D | C | C |  | 1 | 4 | 3
2 | D | D | D | C | C
3 | C | C | C | B | B
4 | C | C | C | B | B
5 | C | C | C | B | B
6 | B | B | B | B | B
7 | B | B | B | B | B
8 | B | B | A | A | A
9 | B | B | B | A | A
10 | A | A | A | A | A
Spreadsheet: 700803d1603352569-match-and-index-test-sales
Sheet: Sheet1

TOTAL DAYS | 1900-01-31 00:00:00
TODAY | 1900-01-21 00:00:00
REMAINING |  | Shop | Shop | Shop | Shop | Shop | Shop | Shop | Shop | Shop
DATE | DAY | 036 | 037 | 007 | 108 | 120 | 019 | 005 | 020 | 035
2020-10-01 00:00:00 | Thursday
2020-10-02 00:00:00 | Friday
2020-10-03 00:00:00 | Saturday
2020-10-04 00:00:00 | Sunday
2020-10-05 00:00:00 | Monday
2020-10-06 00:00:00 | Tuesday
2020-10-07 00:00:00 | Wednesday
2020-10-08 00:00:00 | Thursday
2020-10-09 00:00:00 | Friday
2020-10-10 00:00:00 | Saturday
2020-10-11 00:00:00 | Sunday
2020-10-12 00:00:00 | Monday
2020-10-13 00:00:00 | Tuesday
2020-10-14 00:00:00 | Wednesday
2020-10-15 00:00:00 | Thursday
2020-10-16 00:00:00 | Friday
2020-10-17 00:00:00 | Saturday
2020-10-18 00:00:00 | Sunday
2020-10-19 00:00:00 | Monday
2020-10-20 00:00:00 | Tuesday
2020-10-21 00:00:00 | Wednesday
2020-10-22 00:00:00 | Thursday | 21000 | 2000
2020-10-23 00:00:00 | Friday
2020-10-24 00:00:00 | Saturday
2020-10-25 00:00:00 | Sunday
2020-10-26 00:00:00 | Monday
2020-10-27 00:00:00 | Tuesday
2020-10-28 00:00:00 | Wednesday
2020-10-29 00:00:00 | Thursday
2020-10-30 00:00:00 | Friday
2020-10-31 00:00:00 | Saturday
Total
Spreadsheet: 137542d1327208773-calculate-display-percentage-in-a-pivot-table-based-on-an-alternate-total-percentage-of-custom-total
Sheet: Sheet1

ID | score
a | 13 |  |  |  |  | 300
b | 22
c | 11 |  |  |  | Row Labels | Sum of score
d | 35 |  |  |  | a | 13
e | 7 |  |  |  | b | 22
f | 13 |  |  |  | c | 11
g | 16 |  |  |  | d | 35
h | 25 |  |  |  | e | 7
i | 30 |  |  |  | f | 13
j | 28 |  |  |  | g | 16
 |  |  |  |  | h | 25
 |  |  |  |  | i | 30
 |  |  |  |  | j | 28
 |  |  |  |  | Grand Total | 200
Spreadsheet: 108069d1305163053-using-dropdown-to-copy-rows-of-data-from-other-sheets-example-skills-matrix
Sheet: Tech Skills

Technician | TECH I SKILLS | Ability to mash potatoes | Ability to walk and chew gum at the same time | Ability to sit in the same room as your mother-in-law for more than an hour | Ability to change a diaper | Ability to change a lightbulb | Able to drive a car blindfolded | Able to fix my Excel problems | Able to leap tall buildings in a single bound | Ability to get your work done on time | Ability to make me laugh
[NAME], [NAME]
Jetson, George
Tyson, [NAME]
[NAME], [NAME] |  | 0 | 5 | 3 | 2 | 4 | 4 | 2 | 0 | 3 | 3
Cronkite, [NAME]
Beam, [NAME]
Walker, [NAME]
Cuervo, [NAME]
Daniels, [NAME] |  | 4 | 5 | 0 | 1 | 3 | 5 | 5 | 1 | 3 | 5
Spreadsheet: 814047d1674128446-if-and-x-has-a-value-book1
Sheet: Sheet1

BIL | Nama | BOOK | CRAYON | PENCIL | TOTAL
1 | AVE | / | X
2 | AYSHA | / | /
3 | AZIM | X | /
4 | CASIDY | / | /
5 | EFFA | / | X
 | TOTAL
Spreadsheet: 746948d1631125479-count-distinct-values-and-return-required-group-categories-new_count-distinct-values
Sheet: Sheet1

Site | aa | bb | cc | dd | ee | ff | gg | User | hh | ii | jj | kk | ll | Output | Formula 1 | Formula 2
Boston |  |  |  |  |  |  |  | A1 |  |  |  |  |  | Medium
Boston |  |  |  |  |  |  |  | A1 |  |  |  |  |  | Medium
Boston |  |  |  |  |  |  |  | A2 |  |  |  |  |  | Medium
Boston |  |  |  |  |  |  |  | A3 |  |  |  |  |  | Medium
Chicago |  |  |  |  |  |  |  | B1 |  |  |  |  |  | Small
Chicago |  |  |  |  |  |  |  | B1 |  |  |  |  |  | Small
Chicago |  |  |  |  |  |  |  | B1 |  |  |  |  |  | Small
Chicago |  |  |  |  |  |  |  | B1 |  |  |  |  |  | Small
Chicago |  |  |  |  |  |  |  | B2 |  |  |  |  |  | Small
LA |  |  |  |  |  |  |  | C1 |  |  |  |  |  | Small
LA |  |  |  |  |  |  |  | C1 |  |  |  |  |  | Small
LA |  |  |  |  |  |  |  | C2 |  |  |  |  |  | Small
Denver |  |  |  |  |  |  |  | D1 |  |  |  |  |  | Large
Denver |  |  |  |  |  |  |  | D2 |  |  |  |  |  | Large
Denver |  |  |  |  |  |  |  | D3 |  |  |  |  |  | Large
Denver |  |  |  |  |  |  |  | D4 |  |  |  |  |  | Large
Denver |  |  |  |  |  |  |  | D5 |  |  |  |  |  | Large
Spreadsheet: richard_shapiro__32601__Accomplishment-june5th2001-Masteredit
Sheet: Japan

No. | Accomplishments | Customer | Value | Area |  |  |  |  | Methodology
 | (description) | (B. Unit) | ($) | Deal Support | Origination | Risk Management | [NAME] | Other
1 | · Accelerated deregulation process in Japan.
2 | · Facilitated commercial transactions in Japan. 20 new business referrals from Enron Japan website
3 | · Facilitated broadband trading and content provision in Asia Pacific.
4 | · Facilitated renewable energy trading in Australia. Initiated and lead effort to trade renewable energy certificates in Australia
5 | · Successfully broadcast Enron Japan’s message in Japan. website visitors at an average of 1000 visitors per week
(5), (6), (7), (8) and (9)  Likely area of impact
-10 | Methodology used to arrive at dollar impact in 4.
Spreadsheet: 137369d1327079372-how-to-filter-this-data-correctly-ef13_audit-template
Sheet: Audit Template

Company Name: |  |  |  |  |  |  | Site:
Audit reference: |  |  |  |  |  |  | Date:
Assessment of: |  |  |  |  |  |  | Auditee(s):
Distribution: | Name |  |  |  |  |  | Name
Click here to return to audit programme |  |  |  |  | Audit Programme
Objective
To audit in accordance with the requirements of BS EN ISO 9001, BS EN ISO 14001, IMS Manual and Procedures.  To report the results of the audit and to ensure that the follow-up activities are carried out promptly to eliminate non-conformances and their causes.  To identify and report on improvement activities and progress against performance monitors.
Audit trails and sources of evidence
Description |  |  | [NAME] sources (eg document reference numbers or titles)
Process, function or area assessed:
Evaluations and Conclusions |  |  |  |  |  |  |  |  |  | Outcome |  | Deficiency Ref |  | Owner
Process, function or area assessed:
Evaluations and Conclusions |  |  |  |  |  |  |  |  |  | Outcome |  | Deficiency Ref |  | Owner
Process, function or area assessed:
Evaluations and Conclusions |  |  |  |  |  |  |  |  |  | Outcome |  | Deficiency Ref |  | Owner
Spreadsheet: 884927d1734309015-transpose-the-data-from-single-column-to-multiple-transpose-the-data-from-single-column-to-multiple
Sheet: Sheet1

1 | Company Name: Startech Innovations | 1 | Company Name: Startech Innovations | [NAME]: [EMAIL]
1 | [NAME]: [EMAIL] | 2 | Company Name: Oceanic Designs | Owner Name: [NAME]
3 | Company Name: Greenleaf Solutions | 3 | Company Name: Greenleaf Solutions | Owner Name: [NAME] | [NAME]: [EMAIL]
3 | Owner Name: [NAME] | 4 | Company Name: Apex Ventures | Owner Name: Emily Vargas | [NAME]: [EMAIL] | ADDRESS: ABC ROAD | BUSINESS : FOOD
3 | [NAME]: [EMAIL]
4 | Company Name: Apex Ventures
4 | Owner Name: Emily Vargas
4 | [NAME]: [EMAIL]
4 | ADDRESS: ABC ROAD
4 | BUSINESS : FOOD
2 | Company Name: Oceanic Designs
2 | Owner Name: [NAME]
Spreadsheet: 273513d1382732042-average-age-in-sports-team-average-age-in-sports-team
Sheet: Sheet1

 | Age | Start time | End time
Player A | 31 | 0 | 93
Player B | 34 | 0 | 70
Player C | 27 | 0 | 56
Player D | 25 | 0 | 93
Player E | 24 | 0 | 93
Player F | 18 | 70 | 93
Spreadsheet: 211055d1359645221-creating-a-dependent-validation-list-sample
Sheet: Report

Expense Report
Name
End Date |  | Paycheck Date
Total
Date | Description | Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Total
Total
Spreadsheet: 24022d1213972429-if-command-that-copys-cells-to-new-sheet-tzares
Sheet: Sheet1

Month | type | done
Feb | 2 | done
Mar | 3 | Not done
Apr | 4 | Not done
May | 5 | Not done
Jun | 6 | Not done
Jul | 7 | done
Aug | 8 | done
Sep | 9 | done
Oct | 10 | done
Nov | 11 | Not done
Dec | 12 | Not done
Jan | 13 | Not done
Feb | 14 | Not done
Mar | 15 | Not done
Apr | 16 | Not done
May | 17 | Not done
Jun | 18 | Not done
Jul | 19 | Not done
Aug | 20 | Not done
Sep | 21 | done
Oct | 22 | done
Nov | 23 | done
Dec | 24 | done
Spreadsheet: 95309d1294928563-excel-calculated-field-example
Sheet: Sheet4

 |  |  |  |  | Data
Company | Quarter | Month | Opportunity Title | Forecast % | Forecasted £ | Sum of New Field
Company 1 | Quarter 3 | January | Opportunity Title 10 | 50 | 1300 | 0
 |  |  | Opportunity Title 11 | 0 | 5000 | 0
 |  |  | Opportunity Title 12 | 25 | 1500 | 0
 |  |  | Opportunity Title 13 | 0 | 1000 | 0
 |  |  | Opportunity Title 14 | 75 | 1800 | 1800
 |  |  | Opportunity Title 8 | 75 | 9600 | 9600
 |  |  | Opportunity Title 9 | 75 | 56610 | 56610
 |  | January Total |  |  | 76810 | 0
 |  | December | Opportunity Title 1 | 100 | 0 | 0
 |  |  | Opportunity Title 2 | 100 | 0 | 0
 |  |  | Opportunity Title 3 | 100 | 0 | 0
 |  |  | Opportunity Title 4 | 100 | 0 | 0
 |  |  | Opportunity Title 5 | 100 | 0 | 0
 |  |  | Opportunity Title 6 | 100 | 0 | 0
 |  |  | Opportunity Title 7 | 100 | 0 | 0
 |  | December Total |  |  | 0 | 0
 | Quarter 3 Total |  |  |  | 76810 | 0
 | Quarter 4 | February | Opportunity Title 15 | 25 | 2000 | 0
 |  |  | Opportunity Title 16 | 50 | 1300 | 0
 |  |  | Opportunity Title 17 | 50 | 2000 | 0
 |  |  | Opportunity Title 18 | 0 | 10000 | 0
 |  |  | Opportunity Title 19 | 0 | 2000 | 0
 |  |  | Opportunity Title 20 | 25 | 2500 | 0
 |  | February Total |  |  | 19800 | 0
 |  | March | Opportunity Title 21 | 0 | 15000 | 0
 |  |  | Opportunity Title 22 | 75 | 1300 | 1300
 |  |  | Opportunity Title 23 | 50 | 2000 | 0
 |  |  | Opportunity Title 24 | 0 | 2000 | 0
 |  |  | Opportunity Title 25 | 50 | 44140 | 0
 |  |  | Opportunity Title 26 | 25 | 10000 | 0
 |  |  | Opportunity Title 27 | 0 | 3000 | 0
 |  | March Total |  |  | 77440 | 0
 |  | April | Opportunity Title 28 | 25 | 2000 | 0
 |  |  | Opportunity Title 29 | 75 | 1300 | 1300
 |  |  | Opportunity Title 30 | 50 | 2000 | 0
 |  | April Total |  |  | 5300 | 0
 | Quarter 4 Total |  |  |  | 102540 | 0
 | (blank) | (blank) | (blank) | (blank) | 179350 | 0
 |  | (blank) Total |  |  | 179350 | 0
 | (blank) Total |  |  |  | 179350 | 0
Company 1 Total |  |  |  |  | 358700 | 0
Grand Total |  |  |  |  | 358700 | 0
Spreadsheet: 57195d1257344456-merging-data-from-two-sheets-smaillist
Sheet: Sheet1

Country | [State] | [Area] | combined | [Pcode]
Australia | ACT | [NAME] |  | 2617
Australia | ACT | Canberra |  | 2601
Australia | NSW | Bilambil |  | 2486
Australia | NSW | Brookvale |  | 2100
Australia | NSW | Caringbah |  | 2229
Australia | NSW | Copacabana |  | 2251
Australia | NSW | EmuPlains |  | 2750
Spreadsheet: 875257d1721838285-golf-leaderboard-help-gapster-southport-scoringv1-for-365-aligw
Sheet: Individuals Scoring

 |  |  | Date: |  |  |  |  |  |  | Results Day 1 |  |  |  |  |  |  | Old Links Southport |  | Date: |  | 14th Sep 24 |  |  |  |  | Results Day 2 |  |  |  |  |  | Overall Results
 | Name |  | Score |  | [NAME] |  | [NAME] | Rank |  | Rank |  | Name |  | Points |  |  | Name |  | Score |  | [NAME] |  | [NAME] |  |  | Rank |  | Name |  | Points |  | Rank |  | Name |  | Points
 |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | [NAME] |  | 175
 |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  | 2 |  | [NAME] |  | 140
 |  |  |  |  |  |  |  |  |  | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  |  |  |  |  | 3 |  | Billy |  | 140
 |  |  |  |  |  |  |  |  |  | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 |  |  |  |  |  | 4 |  | [NAME] |  | 131
 |  |  |  |  |  |  |  |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 |  |  |  |  |  | 5 |  | [NAME] |  | 127
 |  |  |  |  |  |  |  |  |  | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  |  |  |  |  | 6 |  | Martyn |  | 127
 |  |  |  |  |  |  |  |  |  | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 |  |  |  |  |  | 7 |  | [NAME] |  | 123
 |  |  |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  |  |  |  |  | 8 |  | [NAME] |  | 118
 |  |  |  |  |  |  |  |  |  | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 |  |  |  |  |  | 9 |  | [NAME] |  | 103
 |  |  |  |  |  |  |  |  |  | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 |  |  |  |  |  | 10 |  | Trevor |  | 101
 |  |  |  |  |  |  |  |  |  | 11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 |  |  |  |  |  | 11 |  | [NAME] |  | 65
 |  |  | Date: |  |  |  |  |  |  |  |  |  |  |  |  |  | Old Links Southport |  | Date: |  | 14th Sep 2024
 | Team |  | Score |  | [NAME] |  | [NAME] |  |  |  |  |  |  |  |  |  | Team |  | Score |  | [NAME] |  | [NAME] |  |  | I need to combine the ranks, names & points totals from Columns K,M,O & AA,AC,AE into the table under Columns AG,AI& AK to give me an overall rank,Name & Points
 | Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
 | Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
 | Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
Spreadsheet: 148821d1333565006-if-column-value-then-another-column-checked-example
Sheet: Sheet3

 |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18
11 | 2 | 16 |  |  | 1 |  |  |  |  |  |  |  |  | 1 |  |  |  |  | 1
3 | 7 | 14 |  |  |  | 1 |  |  |  | 1 |  |  |  |  |  |  | 1
3 | 12 | 13 |  |  |  | 1 |  |  |  |  |  |  |  |  | 1 | 1
7 | 11 | 17 |  |  |  |  |  |  |  | 1 |  |  |  | 1 |  |  |  |  |  | 1
2 | 4 | 16 |  |  | 1 |  | 1 |  |  |  |  |  |  |  |  |  |  |  | 1
Spreadsheet: 1d68fd4b-4ca9-4c6c-b21d-aee8eb47068d
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 34. LEASE FINANCE COMMITMENTS, By Purpose: State (SA), Original (Number, $000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
1 . . . [NAME] ; |  |  | Original | A2413927F | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | [NAME] | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413929K | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413930V | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | A2413931W | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles  ; |  |  | Original | A2413932X | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
1.3.1a . . . . . . - new trucks ; |  |  | Original | A2413933A | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
. . . . . . . . . . . . [new trucks (no.)] ; |  |  | Original | A2413934C | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | Number | FLOW | Month | 1
1.3.3 a. . . . . . - used trucks ; |  |  | Original | A2413935F | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
. . . . . . . . . . . . [used trucks (no.)] ; |  |  | Original | A2413936J | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | Number | FLOW | Month | 1
1.3.5 . . . . . . . - trailers, buses, coaches, other MVs ; |  |  | Original | [NAME] | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
2 . . . Other Transport Equipment ; |  |  | Original | A2413938L | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
3 . . . Agricultural, Construction & Manufacturing Equipment ; |  |  | Original | A2413939R | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
4 . . . Office Equipment ; |  |  | Original | A2413940X | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
5 . . . Other ; |  |  | Original | A2413941A | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
TOTAL LEASE FINANCE ; |  |  | Original | A2413942C | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2011
Spreadsheet: 758943d1639163477-formula-required-for-late-in-early-out-on-time-in_out-times
Sheet: Sheet1

 |  | Time In | Time  Out |  |  |  |  |  | Remarks
 |  |  |  |  |  |  |  |  |  |  | actual duty Time_IN is: 08:30 (cell C8)
 |  |  |  |  |  |  |  |  |  |  | actual duty Time_OUT is: 17:30 (cell D8)
 |  |  |  |  |  |  |  |  |  |  | remarks column: (cell [NAME])
 |  | 08:15:00 | 17:45:00 |  |  |  |  |  |  |  | f a person comes before or actual time in and gone after actual time out that is "ON TIME"
 |  | 08:15:00 | 17:15:00 |  |  |  |  |  |  |  | If a person comes before or actual time in but gone before time out that is "EARLY OUT"
 |  | 08:45:00 | 18:15:00 |  |  |  |  |  |  |  | If a person comes after actual time in and gone after time out that is "LATE ARRIVAL"
 |  | 08:45:00 | 17:15:00 |  |  |  |  |  |  |  | If a person denies both conditions that is "LATE ARRIVAL/EARLY OUT"
Spreadsheet: 846265d1697538190-vlookup-with-multiple-conditions-example-issue
Sheet: Sections

Size | Material | Length ([NAME]) | Weight (kg)
100x100x10 | RSA | 1000
100x100x10 | RSA | 1000
100x100x10 | RSA | 1000
100x100x10 | SHS | 1000
100x100x10 | SHS | 1000
Spreadsheet: 32286d1228385381-if-formula-excelforum_2003_upload
Sheet: SPA_041208_100834

[NAME]: | Sheet6'!$H$6
[NAME]:
Result: | 15
Delimiter(s): | ,*;
Component Part(s): | "--(COUNTIF(A1:F6,"A")>H1:H3)" | "COUNTIF(A1:F6,"A")-H1:H3" | "I1:I3"
Array Row(s): | 3 | 3 | 3
[NAME]): | 1 | 1 | 1
Calculation: | Result(s) | Result(s) | Result(s) | Total(s)
1 | 1 | 11 | 0 | 0
2 | 1 | 6 | 2 | 12
3 | 1 | 1 | 3 | 3
Spreadsheet: john_lavorato__16438__Wab Summary
Sheet: Sheet1

 | [NAME]
 | Dollar Values in $[NAME] CAD
 | Swap Values in $CAD/MWh
 | Bid Includes Fixed and Variable Charges
 | Discounted @ LIBOR
 | 2000-07-21 00:00:00
 | Characteristics
 | Fuel | Coal
 | Capacity | 548
 | [NAME] | 2003
 | [NAME] (Vol) - MM MWh | 10
 | Mid Curve Swap | 61.45
 | Implied Minimum Opening Bid | 40.85
 |  | Bid = $X CAD/MWh
 |  | 35 | 40 | 45 | 50 | 55
 | Capital Outlay
 | Minimum Opening Bid | 25 | 25 | 25 | 25 | 25
 | If We Bid $X | -26 | 17 | 60 | 103 | 146
 | If We Bid $X (Constrained by MOB)
 | Potential Value
 | Marked Against Mid Assuming MOB
 | Marked Against Mid Assuming $X Bid
 | Value @ Mid | 202 | 202 | 202 | 202 | 202