tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 725607d1616764550-staff-attendance-data-copy-of-attendance-ans-2
Sheet: Report_20210315T112801 (2)

Raw data |  |  |  | Raw data |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
Date |  |  |  | User |  |  |  | id | date | id+date | time | date |  |  |  | Staff | Date | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
2021-03-01 11:01:13 |  |  |  | X05024(Maria) |  |  |  |  |  |  |  |  |  |  |  | X05024(Maria) | 2021-03-01 00:00:00
2021-03-01 12:12:05 |  |  |  | X05024(Maria) |  |  |  |  |  |  |  |  |  |  |  | X05024(Maria) | 2021-03-02 00:00:00
2021-03-01 15:02:08 |  |  |  | X05024(Maria) |  |  |  |  |  |  |  |  |  |  |  | R09999(Peter) | 2021-03-01 00:00:00
2021-03-01 17:42:24 |  |  |  | X05024(Maria) |  |  |  |  |  |  |  |  |  |  |  | R09999(Peter) | 2021-03-02 00:00:00
2021-03-01 19:06:32 |  |  |  | X05024(Maria)
2021-03-02 10:22:25 |  |  |  | X05024(Maria) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | time highlighted in green wrongly capture next day data
2021-03-02 10:23:02 |  |  |  | X05024(Maria)
2021-03-02 10:33:56 |  |  |  | X05024(Maria)
2021-03-02 10:46:16 |  |  |  | X05024(Maria)
2021-03-02 15:24:37 |  |  |  | X05024(Maria)
2021-03-02 15:31:59 |  |  |  | X05024(Maria)
2021-03-02 17:52:44 |  |  |  | X05024(Maria)
2021-03-02 18:36:15 |  |  |  | X05024(Maria)
2021-03-01 08:30:56 |  |  |  | R09999(Peter)
2021-03-01 08:32:58 |  |  |  | R09999(Peter)
2021-03-01 09:18:06 |  |  |  | R09999(Peter)
2021-03-01 13:49:43 |  |  |  | R09999(Peter)
2021-03-01 16:57:45 |  |  |  | R09999(Peter)
2021-03-01 17:47:28 |  |  |  | R09999(Peter)
2021-03-01 17:48:15 |  |  |  | R09999(Peter)
2021-03-01 18:08:42 |  |  |  | R09999(Peter)
2021-03-02 08:31:02 |  |  |  | R09999(Peter)
2021-03-02 08:33:08 |  |  |  | R09999(Peter)
2021-03-02 08:49:53 |  |  |  | R09999(Peter)
2021-03-02 09:23:00 |  |  |  | R09999(Peter)
2021-03-02 09:26:43 |  |  |  | R09999(Peter)
2021-03-02 09:57:08 |  |  |  | R09999(Peter)
2021-03-02 09:57:56 |  |  |  | R09999(Peter)
2021-03-02 10:06:15 |  |  |  | R09999(Peter)
2021-03-02 10:12:43 |  |  |  | R09999(Peter)
2021-03-02 14:27:29 |  |  |  | R09999(Peter)
2021-03-02 18:09:59 |  |  |  | R09999(Peter)
Spreadsheet: 52990d1252919021-one-sheet-feeds-another-depending-on-data-entered-issues
Sheet: User2

Heading 1 | Heading 2 | Heading 3 | Heading 4 | Heading 5 | [NAME]
Data | Data | Data | Data | Data | R
Data | Data | Data | Data | Data | A
Data | Data | Data | Data | Data | R
Data | Data | Data | Data | Data | R
Data | Data | Data | Data | Data | R
Data | Data | Data | Data | Data | G
Data | Data | Data | Data | Data | G
Data | Data | Data | Data | Data | G
Spreadsheet: 885094d1734522258-need-help-with-my-excel-attendance-sheet-working-days-rekod-cuti-staff-oriental
Sheet: Cuti Umum Syarikat

 |  |  | CUTI UMUM SYARIKAT
 | 2025 |  | TARIKH | HARI | CUTI UMUM
 |  |  |  | [NAME] | TAHUN BARU CINA
 |  |  |  | ISNIN | HARI RAYA ADILFITRI 1
 |  |  |  | SELASA | HARI RAYA AIDILFITRI 2
 |  |  |  | KHAMIS | HARI PEKERJA
 |  |  |  | ISNIN | HARI KEPUTERAAN AGONG
 |  |  |  | SABTU | HARI RAYA HAJI
 |  |  |  | [NAME] | AWAL MUHARRAM
 |  |  |  | AHAD | HARI KEBANGSAAN
 |  |  |  | SELASA | HARI MALAYSIA
 |  |  |  | ISNIN | HARI DEEPAVALI
 |  |  |  | KHAMIS | HARI KEPUTERAAN SULTAN SELANGOR
Spreadsheet: 878369d1725447187-exclude-names-with-bold-formatting-from-randomizer-randomizer
Sheet: Blad1

[NAME] |  | [NAME] for randomized names
dion
[NAME]
dirceo
jowan
Artur
Marian
Mohamed
Marek
Rafal
Elroy
[NAME]
Houcine
[NAME]
Maarten
Stef
[NAME]
Martien
[NAME]
Spreadsheet: 861977d1709782895-tiered-pay-plan-payplan-example
Sheet: Sheet1

Pay Plan
Manager | SHOW | 100 | 111 | 121 | 131 | 141 | 151 | 160
[NAME] |  | 15 | 20 | 25 | 30 | 35 | 40 | 45
 | SOLD | 0 | 46 | 51 | 56 | 61 | 66 | 71
 |  | 20 | 25 | 30 | 35 | 40 | 45 | 50
 |  |  |  | Chevy | Show | Sold | Total Show $ | Total Sold $ | Total $
 |  |  |  |  | 136 | 67
 |  |  |  | Subaru
 |  |  |  |  | 200 | 6
Spreadsheet: 823737d1680117551-if-statements-multiple-parameters-tipsheet-wip-2-
Sheet: Master

 | HT Totals | HT am | HT pm
Total Sales:
Total CC Tips |  |  |  |  | Pool $$ | Bartender | Backserver |  |  |  |  | Kickfin Count | Servers | Bartenders | Barbacks | Backservers | Full | Mid | FR
Total Cash Tips |  |  |  |  | HT am |  |  |  |  |  |  | HT am
Gross Total Tips: |  |  |  |  | HT pm |  |  |  |  |  |  | HT pm
Server Net
Bartender Net
Support Net
TOTAL STAFF TIPS:
SERVERS | Alcohol Sales | Total Sales | Shift | Credit Tips | Cash Sales | Total Cash Collected | Cash Tips | Gross Total Tips | Tip-out to Bartenders | Tip-out to Backservers | Net Total Tips | Kickfin
 | 0 | 0 |  | 0 | 0 | 0
SERVER 1 | 400 | 500 | HT pm | 500 | 1000 | 2000
SERVER 2 | 900 | 1000 | HT am | 1000 | 1000 | 999
 | 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 | 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 | 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 |  | 0 | 0 | 0
 | 0 | 0 |  | 0 | 0 | 0
 | 0 | 0 |  | 0 | 0 | 0
 | 0 | 0 |  | 0 | 0 | 0
BARTENDERS | Food Sales | Total Sales | Shift | Credit Tips | Cash Sales | Total Cash Collected | Cash Tips | Gross Total Tips | Tip-out to Backservers | Pool Share | Net Total Tips | Kickfin | Hours Worked
 | 0 |  |  | 0 | 0 | 0 |  |  |  |  |  |  | 0
 | 0 |  |  | 0 | 0 | 0 |  |  |  |  |  |  | 0
BARTENDER 1 | 500 | 500 | HT am | 500 | 500 | 550 |  |  |  |  |  |  | 1
BARTENDER 2 | 500 | 500 | HT pm | 500 | 400 | 500 |  |  |  |  |  |  | 1
 | 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 |  |  |  |  |  |  | 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 | 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
BACKSERVERS | Shift | Hours Worked | Kickfin
BCKSVR 1
BCKSVR 2 | HT am | 0.25
BCKSVR 3 | HT am | 0.5
BCKSVR 4 | HT pm | 1
BCKSVR 5 | HT pm | 0.5
BCKSVR 6 | HT pm | 0.25
BARBACKS | Shift | Hours Worked | Kickfin
BARBACK 1 | HT am | 1
BARBACK 2 | HT pm | 1
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
Spreadsheet: 328721d1404044245-self-populating-columns-with-information-fromother-cells-sra-template-temp-format
Sheet: Sheet3

 |  |  | CONSEQUENCE
 |  |  | 1 |  | 2 |  | 3 |  | 4 |  | 5
 | LIKELIHOOD | 5 | H-11 |  | H-16 |  | E-20 |  | E-23 |  | E-25
 |  | 4 | M-7 |  | H-12 |  | H-17 |  | E-21 |  | E-24
 |  | 3 | L-4 |  | [NAME] |  | H-13 |  | E-18 |  | E-22
 |  | 2 | L-2 |  | [NAME] |  | M-9 |  | H-14 |  | E-19
 |  | 1 | L-1 |  | [NAME] |  | M-6 |  | H-10 |  | H-15
 | E= | Extreme risk: Detailed research and management planning required
 | H= | High risk: Senior management attention needed
 | M= | Medium risk: Management responsibility must be specified
 | L= | Low risk: Managed by routine procedures
 |  |  |  | Consequences
 |  |  |  | 1 | 2 | 3 | 4 | 5
 | Likelihood |  | 5 | H-11 | H-16 | E-20 | E-23 | E-25
 |  |  | 4 | M-7 | H-12 | H-17 | E-21 | E-24
 |  |  | 3 | L-4 | [NAME] | H-13 | E-18 | E-22
 |  |  | 2 | L-2 | [NAME] | M-9 | H-14 | E-19
 |  |  | 1 | L-1 | [NAME] | M-6 | H-10 | H-15
Likelihood (%)
Min | [NAME]
0.01 | 0.05 | E | 1 | Rare |  |  | 0.06
0.06 | 0.29 | D | 2 | Unlikely
0.3 | 0.59 | C | 3 | Moderate
0.6 | 0.89 | B | 4 | Likely
0.9 | 1 | A | 5 | Almost Certain
Consequence
Insignificant | 1
Minor | 2
Moderate | 3
Major | 4
Catastrophic | 5
Spreadsheet: 683564d1592830381-consolidating-sheets-text-not-consolidating-consolidation
Sheet: Sheet 1

Ref | Description | Quantity | Units | Rate | Value
2/2/ |  | 0 |  | 0 | 0
 | Text 1
 | Text 2
 | Text 3
2/2/1 | Text 4 | 20 | m3 | 5
2/2/ | Text 5 | 0 |  | 0
2/2/2 | Text 6 | 1200 | m3 | 12
2/2/ | Text 7 | 0 |  | 0
 | Text 8
2/2/2A | Text 9 | 0 | m3 | 0
2/2/ | Text 10 | 0 |  | 0
2/2/2B | Text 11 | 0 | m3 | 0
2/2/ | Text 12 | 0 |  | 0
 | Text 13
2/2/2E | Text 14 | 365 | m3 | 2.11
2/2/ | Text 15 | 0 |  | 0
2/2/2F | Text 16 | 950 | m3 | 3.56
2/2/ | Text 17 | 0 |  | 0
 | Text 18
2/2/2C | Text 19 | 10111 | m3 | 4.21
2/2/ | Text 20 | 0 |  | 0
2/2/2D | Text 21 | 12569 | m3 | 3.2
2/2/ | Text 22 | 0 |  | 0
 | Text 23
2/2/2E | Text 24 | 2503 | m3 | 9.8
2/2/ | Text 25 | 98 | m3 | 9.8
2/2/2F | Text 26 | 4 | m3 | 4.2
Spreadsheet: 317925d1399986688-gathering-values-based-off-critieria-and-in-turn-forming-a-list-auto-list
Sheet: Sheet1

 |  |  |  |  |  | There is another page in the real excel file that is using a vlook of column B with the Historical data on the other sheet. If the historical data can't find whats in column B. it will say "error". Which tells me we haven't purchased that [NAME] before and its new and needs to be entered in.
List # | Identifier | Discription | Amount |  |  |  |  |  |  |  |  | Error List
1 | q234r456 | green | 20 | error |  |  | The list to auto populate |  |  | ----> | 1 | q234r456 | green | 20 | error
2 | w234e345 | red | 30 |  |  |  |  |  |  |  | 2 | ssehbfuef | white | 90 | error
3 | g5678w12 | yellow | 40 |  |  |  |  |  |  |  | 3 | 387ghrd23 | orange | 110 | error
4 | j8907ki42 | black | 35 |  |  |  |  |  |  |  | 4 | 30r0j30fef | hazel | 51 | error
5 | ssehbfuef | white | 90 | error
6 | 2387bv36 | purple | 120
7 | 387ghrd23 | orange | 110 | error
8 | e3rf7983 | blue | 65 |  |  |  |  | There are a lots of tabs with direct formulas off this page, so sorting the data would be easy but would throw off all these formulas.
9 | 98ashfw3 | teal | 70
10 | fo3h993f | violet | 83
11 | 30r03pq2p | gray | 47
50000 | 30r0j30fef | hazel | 51 | error
Spreadsheet: 58727d1258996784-if-formula-combination-excel-help
Sheet: Sheet1

VND |  | NSF |  | Growth |  | PREV
month | averade yr | month | average yr | month | average yr
a | b | c | d | e | f | VND*NSF*Growth
if a="" then it reads b
if b="" then it doesn't return any result ("no data")
if c="" then it reads d
if d="" assumes the value 1
if e="" then it reads f |  |  |  |  |  | VND |  | NSF |  | Growth
if f="" assumes the value 1
 |  |  |  |  |  | a |  | c |  | e
 |  |  |  |  |  | b |  | d |  | f
 |  |  |  |  |  | no data |  | 1 |  | 1
 |  |  | What can be calculated: |  |  | [NAME] | b*c*e | no data
 |  |  |  |  |  | a*c*f | b*c*f
 |  |  |  |  |  | a*c*1 | b*c*1
 |  |  |  |  |  | a*d*e | b*d*e
 |  |  |  |  |  | a*d*f | b*d*f
 |  |  |  |  |  | a*d*1 | [NAME]
 |  |  |  |  |  | a*1*e | b*1*e
 |  |  |  |  |  | a*1*f | b*1*f
 |  |  |  |  |  | a*1*1 | b*1*1
Spreadsheet: phillip_m_love__30143__9911_OA
Sheet: WE-GL 

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM)
REGION:  WEST
 |  |  | Total |  | Reclasses |  | November |  | December |  | January |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  | September
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -1 | -2.89
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2.89
14 |  | Cash Out |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -5996
15 |  | Cash In |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5996
16 |  | Synthetic Storage |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -148615.94
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2.89
 | Transport Expense:
24 |  | Commodity |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -312850 |  |  |  | 6646 | -442.94
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
Spreadsheet: 774172d1648262489-matching-cells-and-displaying-adjacent-data-first-10-character-lookup
Sheet: Data

PT Account ID | Parent | Sub-Account Name
[PHONE] | Affinity Federal Credit Union | AlaskaUSA FCU - CloudVirga
[PHONE] | Affinity Plus Federal Credit Union | ALCOVA Mortgage - CloudVirga
[PHONE] | Affordable Lending Group LLC | Aldridge Pite LLP
[PHONE] | AFI Mortgage Company | Alerus Financial
[PHONE] | AgFirst Farm Credit Bank | Alerus Financial
[PHONE] | Agility Resources Group LLC | All Air Climate
[PHONE] | Agoura Hills Financial | All Western Mortgage
[PHONE] | AgStar Financial Services | All Western Mortgage, Inc
[PHONE] | Ah Mortgage Servicer Advance Revolving Trust 1 | Allant Group
[PHONE] | AimBank | Allegacy Credit Union
[PHONE] | AimLoan | ALLEGACY FEDERAL CREDIT UNION - CloudVirga
[PHONE] | AK Capital LLC | [NAME]
[PHONE] | Alabama One Credit Union | Alliance Bank
[PHONE] | Alameda Mortgage Corporation | Alliance Financial Resources
[PHONE] | Alaska Housing Finance | Alliance Home Loans
[PHONE] | Alaska USA Mortgage Company LLC | Alliant Credit Union
[PHONE] | Albeca Financial | Allied Bancorp Mission Viejo
[PHONE] | Alchymist Holdings | Allied First Bank
[PHONE] | ALCOVA Mortgage LLC | Allied Mortgage Group Inc - CloudVirga
[PHONE] | Alder Creek Properties | Allstate Ins - Matthew Nestler Hercules
[PHONE] | Alerus Financial Corporation | Ally Bank
[PHONE] | [NAME] LLC | Ally Bank - CloudVirga
[PHONE] | Aliant Bank | Alma Bank
[PHONE] | Align Credit Union | Altabank
[PHONE] | Allanach Mortgage Group Corporation | Alterra Home Loans
[PHONE] | All Credit Considered Mortgage Inc | Alterra Home Loans - CloudVirga
[PHONE] | Allegacy Federal Credit Union | Altisource - CloudVirga
[PHONE] | [NAME], LLC | Altisource Portfolio Solutions, Inc.
[PHONE] | [NAME] | Altos Research
[PHONE] | All Home Lending Inc
[PHONE] | Alliance Bank
[PHONE] | Alliance Bank , N.A.
Spreadsheet: 164441d1340770559-help-combine-if-and-vlookup-forumlas-or-another-way-of-getting-the-solution-tester-template
Sheet: WKSHT#1

 | Exhibit B
 | worksheet #1
 | Merchant Name:
 | NAICS Code: |  |  |  |  |  | 238290
 | NAICS Description:
 | Annual Bankcard Sales: |  |  |  |  |  | 0
 | Minimum annual growth (10% or higher per HUB's projections) |  |  |  |  |  | 0.1
 | Total Projected sales
 | % of deferred delivery sales |  |  |  |  |  | 0
 | Average number of days of non-delivery risk: |  |  |  |  |  | 0
 | [NAME]. Non-Delivery Risk if merchant goes out-of-business:
 | Normal chargeback and credit return annual risk per NAICS:
 | Discount risk based on an average discount of 2.0%:
 | Gross Merchant Risk
 | less Reserve Amount
 | less Collateral Amount
 | Net Merchant Risk
 | Guaranty (s) required: Yes/No |  |  |  | Conforming Business: Yes/No
 |  |  |  |  | Conforming sales method: Yes/No
 | Collateral required: Yes/No
 | Reserve required: Yes/No
 | ACH Settlement delay:
 | Additional Conditions:
Spreadsheet: 0719a30f-9575-49dd-a05d-e606cf378899
Sheet: Sheet1

1995 - 39th Coupe Aéronautique [NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Starting Point: | Wil/Fürstenland, Germany |  |  |  |  | 1995-09-09 00:00:00
 |  | Pilots Name |  | Co-Pilots Name
Rank | Country | Last | First | Last | First | BalloonName | LandingPlace | Distance km | Time
1 | GER | Eimers | Wilhelm | Landsmann | Bernd | D-OCOL Columbus II | Ludzasraj/Latvia | 1628.1 | 1900-01-03 20:11:00
2 | USA | [NAME] | [NAME] | Brielmann | [NAME] | N1636S Spirit of Sprinfield | [NAME] | 1403 | 1900-01-02 21:23:00
3 | AUT | Fürstner | [NAME] | Stürzlinger | [NAME] | D-OSTZ [NAME] | Lucincik/Ukraine | 1395.4 | 80:78
4 | USA | [NAME] | [NAME] | [NAME] | Mark | N69RW Aspen | Zelva/Volkovysk Belarus | 1280 | 1900-01-02 17:25:00
5 | AVI | Fraenckel | [NAME] | [NAME] | [NAME] | D-Caribbean | Bereza/Belarus | 1267.2 | 1900-01-02 14:32:00
6 | GER | [NAME] | Heinz | [NAME] | Dr. [NAME] | D-Columbus | Greve/Denmark | 930.9 | 1900-01-02 00:00:00
7 | GER | Höhl | [NAME] | [NAME] | Florian | D-Queen | Gerbno/Koszalin Poland | 906.2 | 1900-01-01 23:57:00
8 | AUT | Wagner | [NAME] | Lewetz | [NAME] | OE-ZZI | Kolobrzeg/Poland | 871.7 | 1900-01-01 11:25:00
9 | SUI | Najer | [NAME] | Fröhlin | Hansjörg | D-OCFT | Rudki/Walcz/Poland | 839.3 | 1900-01-01 18:38:00
10 | NET | [NAME] | Rien | Houten | [NAME] | PH-KTS Festo | Jaglice/Czlopa Poland | 804.9 | 44:75
11 | SUI | Imstepf | [NAME] | [NAME] | Kurt | HB-BVZ  [NAME] | Karprika/Jelenia-Gora/Poland | 625.3 | 1900-01-02 07:50:00
12 | AUT | Starkbaum | [NAME] | Starkbaum | Roland | OE-PZS Polarstern | St.Pölten/Austria | 498.9 | 22:42:00
13 | POL | Makne | [NAME] | Halas | Pjotr | SP-BZO Polonez | Unterbergen/Austria | 494.6 | 1900-01-01 02:43:00
14 | SUI | Stoll | Christian | Spenger | [NAME] | HB-BZH  Stadt Will | Bad Feilnbach Germany | 220.5 | [NAME]
15 | USA | Abruzzo | [NAME] | [NAME] | [NAME] | HB-BJS Motor Columbus | Denkingen/Germany | 52.3 | 07:43:00
Spreadsheet: 779667d1651971397-average-formula-problem-using-lists-ef1577_test-cohort-tracking-2
Sheet: Tracking

 |  |  |  |  |  |  |  |  | Group | Year | Subject
 |  |  |  |  |  |  |  |  | 1 | 2011-2012 | Subject 1
 |  |  |  |  |  |  |  |  | 2 | 2012-2013 | Subject 2
 |  |  |  |  |  |  |  |  | 3 | 2013-2014 | Subject 3
 |  |  |  |  |  |  |  |  | 4 | 2014-2015 | Subject 4
 |  |  |  |  |  |  |  |  | 5 | 2015-2016 | Subject 5
 |  |  |  |  |  |  |  |  | 6 | 2016-2017 | Subject 6
 |  |  |  |  |  |  |  |  |  | 2017-2018 | Subject 7
 |  |  |  |  |  |  |  |  |  | 2018-2019 | Subject 8
 |  |  |  |  |  |  |  |  |  | 2019-2020
 |  |  |  |  |  |  |  |  |  | 2020-2021
 |  |  |  |  |  |  |  |  |  | 2021-2022
 |  | Group | Year | Subject | Average
 |  | 1 | 2011-2012 | Subject 1
 |  | 2 | 2012-2013 | Subject 2
 |  | 3 | 2013-2014 | Subject 3
 |  | 4 | 2014-2015 | Subject 4
 |  | 5 | 2015-2016 | Subject 5
 |  | 6 | 2016-2017 | Subject 6
 |  | 3 | 2017-2018 | Subject 7
 |  | 5 | 2018-2019 | Subject 8
Spreadsheet: 879805d1727356441-choosecols-function-to-incorporate-manual-column-no-value-sheet1
Sheet: Expected Result

Lookup 1 | [NAME] |  | to be arrange alphabetically |  | this col.to be added in formula
Sun | Sheet1
Day | Application No | Code | Solar System | Exam | Base | Fee | Charge
Sun | AP-1 | 65363 | Venus | 1991.05.04 | MS | 2063 | 25
Sun | DJ-986 |  | Venus | 2099.65.30 | MS | 320
Sun | AS-5 | 6316 | Earth | 1010.03.02 | MS | 1500 | 6
Sun | LST-3 | 9843 | Mars | 1011.04.02 | MS | 500 | 65
Grand Total
Spreadsheet: 708079d1607610150-85th-percentile-speed-survey-thorns-road-data-set-example-1-
Sheet: SB

Date | Time Period | All vehc | <5 | <10 | <15 | <20 | <25 | <30 | <35 | <40 | <45 | <50 | <55 | <60 | <65 | <70
Thursday 19/06/2014 | 12:00-12:15 | 208 | 2 | 0 | 2 | 40 | 102 | 44 | 13 | 5 | 0 | 0 | 0 | 0 | 0 | 0
Thursday 19/06/2014 | 12:00-12:15 | 208 | 2 | 0 | 2 | 40 | 102 | 44 | 13 | 5 | 0 | 0 | 0 | 0 | 0 | 0
Thursday 19/06/2014 | 12:15-12:30 | 203 | 0 | 4 | 14 | 47 | 70 | 63 | 4 | 1 | 0 | 0 | 0 | 0 | 0 | 0
Thursday 19/06/2014 | 12:30-12:45 | 211 | 0 | 0 | 3 | 44 | 98 | 57 | 6 | 2 | 1 | 0 | 0 | 0 | 0 | 0
Thursday 19/06/2014 | 12:45-13:00 | 192 | 0 | 1 | 1 | 29 | 110 | 42 | 8 | 1 | 0 | 0 | 0 | 0 | 0 | 0
Thursday 19/06/2014 | 13:00-13:15 | 233 | 4 | 2 | 5 | 37 | 102 | 68 | 12 | 2 | 0 | 1 | 0 | 0 | 0 | 0
Thursday 19/06/2014 | 13:15-13:30 | 198 | 3 | 0 | 8 | 28 | 92 | 60 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Thursday 19/06/2014 | 13:30-13:45 | 219 | 0 | 0 | 18 | 39 | 91 | 59 | 11 | 1 | 0 | 0 | 0 | 0 | 0 | 0
Thursday 19/06/2014 | 13:45-14:00 | 176 | 2 | 3 | 9 | 39 | 77 | 40 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Thursday 19/06/2014 | 14:00-14:15 | 208 | 7 | 2 | 9 | 58 | 65 | 54 | 12 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0.009727626459143969 | 0.01556420233463035 | 0.05009727626459144 | 0.245136186770428 | 0.6872568093385214 | 0.9455252918287937 | 0.9902723735408561 | 0.9990272373540856 | 0.9995136186770428 | 1 | 1 | 1 | 1 | 1
Spreadsheet: john_lavorato__16588__West Positions_Report_112001 EES Richter
Sheet: Monthly_Breakout

EWS Positions
 |  | January |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  | September |  | October |  | November |  | December |  | Total pvMWH ON | Total pvMWH OFF
FYEAR |  | pvMWH ON | pvMWH OFF | pvMWH ON | pvMWH OFF | pvMWH ON | pvMWH OFF | pvMWH ON | pvMWH OFF | pvMWH ON | pvMWH OFF | pvMWH ON | pvMWH OFF | pvMWH ON | pvMWH OFF | pvMWH ON | pvMWH OFF | pvMWH ON | pvMWH OFF | pvMWH ON | pvMWH OFF | pvMWH ON | pvMWH OFF | pvMWH ON | pvMWH OFF
2001 | Retail Generation
 | Ancillary Services
 | Distibution Losses
 | Wholesale Hedge
 | Total
2002 | Retail Generation
 | Ancillary Services
 | Distibution Losses
 | Wholesale Hedge
 | Total
2003 | Retail Generation
 | Ancillary Services
 | Distibution Losses
 | Wholesale Hedge
 | Total
2004-2012 | Retail Generation
 | Ancillary Services
 | Distibution Losses
 | Wholesale Hedge
 | Total
Total | Retail Generation
 | Ancillary Services
 | Distibution Losses
 | Wholesale Hedge
 | Grand Total
 |  | January |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  | September |  | October |  | November |  | December |  | Total pvMWH ON | Total pvMWH OFF
FYEAR |  | pvMWH ON | pvMWH OFF | pvMWH ON | pvMWH OFF | pvMWH ON | pvMWH OFF | pvMWH ON | pvMWH OFF | pvMWH ON | pvMWH OFF | pvMWH ON | pvMWH OFF | pvMWH ON | pvMWH OFF | pvMWH ON | pvMWH OFF | pvMWH ON | pvMWH OFF | pvMWH ON | pvMWH OFF | pvMWH ON | pvMWH OFF | pvMWH ON | pvMWH OFF
2001 | Energy
 | Ancillary/Losses
2002 | Energy
 | Ancillary/Losses
2003 | Energy
 | Ancillary/Losses
2004-2012 | Energy
 | Ancillary/Losses
Total | Energy
 | Ancillary/Losses
 | Grand Total
Spreadsheet: 85345d1285353167-sum-calculations-for-university-datah2
Sheet: T5

Ikä | Miehet | Naiset | Yhteensä
0–4 | 147143 | 140984 | 288127
5–9 | 147656 | 141563 | 289219
10–14 | 165156 | 158679 | 323835
15–19 | 166143 | 159204 | 325347
20–24 | 169860 | 162144 | 332004
25–29 | 169194 | 161773 | 330967
30–34 | 162205 | 153383 | 315588
35–39 | 171224 | 165214 | 336438
40–44 | 190918 | 185085 | 376003
45–49 | 189147 | 186172 | 375319
50–54 | 196272 | 196010 | 392282
55–59 | 204428 | 205649 | 410077
60–64 | 153214 | 159818 | 313032
65–69 | 121620 | 137477 | 259097
70–74 | 91351 | 114577 | 205928
75–79 | 72900 | 109787 | 182687
80–84 | 42275 | 84986 | 127261
85–89 | 17038 | 47628 | 64666
90– | 5998 | 23080 | 29078
Yhteensä | 2583742 | 2693213 | 5276955