tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 127975d1320711306-using-begins-with-to-obtain-result-my-book
Sheet: Sheet1

Empty column | Varying data commencing with
If B2 starts with GL place GL | GL-andvariousdata
 | and inbetween these is a lot of important data
 | and inbetween these is a lot of important data
 | and inbetween these is a lot of important data
 | and inbetween these is a lot of important data
If B7 starts with WD place WD | WD-andvariousdata
 | and inbetween these is a lot of important data
 | and inbetween these is a lot of important data
If B10 starts with SR place SR | SR-andvariousdata
 | and inbetween these is a lot of important data
 | and inbetween these is a lot of important data
 | and inbetween these is a lot of important data
 | and inbetween these is a lot of important data
etc | TRGL-andvariousdata
 | and inbetween these is a lot of important data
 | and inbetween these is a lot of important data
 | and inbetween these is a lot of important data
 | and inbetween these is a lot of important data
 | and inbetween these is a lot of important data
 | and inbetween these is a lot of important data
etc | TRWD-andvariousdata
 | and inbetween these is a lot of important data
etc | TRSR-andvariousdata
 | and inbetween these is a lot of important data
 | and inbetween these is a lot of important data
Spreadsheet: 858212d1706953837-re-arranging-columns-to-rows-and-then-offsetting-the-result-and-repeating-the-process-transposing-problem
Sheet: Sheet1

 |  | Title of Book | Publishing Dates
 |  | Title of Book 1 | 2024-03-05 00:00:00 | not-confirmed | 2024-03-05 00:00:00 | 2024-03-05 00:00:00 | 2024-03-05 00:00:00 | 2024-03-05 00:00:00 | 2024-03-05 00:00:00 | 2024-03-05 00:00:00 | 2024-09-03 00:00:00 | 2024-10-04 00:00:00 | 2024-11-05 00:00:00 | 2024-12-11 00:00:00
 |  | Title of Book 2 | ---- | 2024-02-02 00:00:00 | 2024-03-08 00:00:00 | 2024-04-05 00:00:00 | 2024-05-03 00:00:00 | 2024-06-07 00:00:00 | 2024-07-05 00:00:00 | ---- | 2024-09-03 00:00:00 | ---- | ---- | 2024-12-11 00:00:00
 |  | Title of Book 3 | 2024-03-05 00:00:00 | not-confirmed | 2024-03-05 00:00:00 | 2024-03-05 00:00:00 | 2024-03-05 00:00:00 | 2024-03-05 00:00:00 | 2024-03-05 00:00:00 | 2024-03-05 00:00:00 | 2024-09-03 00:00:00 | 2024-10-04 00:00:00 | 2024-11-05 00:00:00 | 2024-12-11 00:00:00
 |  | Expected Output
 |  | Title | Publishing Dates
 |  | Title of Book 1 | 2024-03-05 00:00:00
 |  | Title of Book 1 | not-confirmed
 |  | Title of Book 1 | 2024-03-05 00:00:00
 |  | Title of Book 1 | 2024-03-05 00:00:00
 |  | Title of Book 1 | 2024-03-05 00:00:00
 |  | Title of Book 1 | 2024-03-05 00:00:00
 |  | Title of Book 1 | 2024-03-05 00:00:00
 |  | Title of Book 1 | 2024-03-05 00:00:00
 |  | Title of Book 1 | 2024-09-03 00:00:00
 |  | Title of Book 1 | 2024-10-04 00:00:00
 |  | Title of Book 1 | 2024-11-05 00:00:00
 |  | Title of Book 1 | 2024-12-11 00:00:00
 |  | I would like the add a row after the first book and date and then start with the second book.
 |  | Expected Output
 |  | Title | Publishing Dates
 |  | Title of Book 2 | ----
 |  | Title of Book 2 | 2024-02-02 00:00:00
 |  | Title of Book 2 | 2024-03-08 00:00:00
 |  | Title of Book 2 | 2024-04-05 00:00:00
 |  | Title of Book 2 | 2024-05-03 00:00:00
 |  | Title of Book 2 | 2024-06-07 00:00:00
 |  | Title of Book 2 | 2024-07-05 00:00:00
 |  | Title of Book 2 | ----
 |  | Title of Book 2 | 2024-09-03 00:00:00
 |  | Title of Book 2 | ----
 |  | Title of Book 2 | ----
 |  | Title of Book 2 | 2024-12-11 00:00:00
 |  | I would like the add a row after the second book and date and then start with the third book. (So on and so forth)
 |  | Expected Output
 |  | Title | Publishing Dates
 |  | Title of Book 3 | etc.
 |  | Title of Book 3 | etc.
 |  | Title of Book 3 | etc.
 |  | Title of Book 3 | etc.
 |  | Title of Book 3 | etc.
 |  | Title of Book 3 | etc.
 |  | Title of Book 3 | etc.
 |  | Title of Book 3 | etc.
Spreadsheet: 865854d1712835886-formula-stop-a-calculation-running-once-it-has-reached-a-defined-criteria-excel-example-data-set
Sheet: Summary

[NAME] |  |  |  |  |  |  |  |  | SHEETNAME
 |  |  |  |  |  |  |  |  | Data Set 1
 |  |  |  |  |  |  |  |  | Data Set 2
[NAME] of returns Possible | Coded to Date | Cost to Date | AVK |  |  |  |  |  | Data Set 3
1 | A0001
2 | A0002
3 | A0003
4 | A0004
5 | A0005
6 | A0006
7 | A0007
8 | A0008
9 | A0009
10 | A0010
11 | A0011
12 | A0012
13 | A0013
14 | B001
15 | B002
16 | B003
17 | B004
18 | B005
19 | B006
20 | B007
21 | B008
22 | C001
23 | C002
24 | C003
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Spreadsheet: 725310d1616612722-formula-on-worksheet-that-changes-column-if-copied-on-new-worksheet-cocktail-box-stock-sheet
Sheet: Jan Stock

 | Wet Product |  |  |  |  |  | Dry Product
 | Product | QTY initial | QTY in | QTY out | QTY holding |  | Product | QTY initial | QTY in | QTY out | QTY holding
 | [NAME] (50ml) |  |  |  |  |  | Feather
 | [NAME] (50ml) |  |  |  |  |  | Lime dehydrated
 | [NAME] (50ml) |  |  |  |  |  | Pineapple freeze dried
 | [NAME] (50ml) |  |  |  |  |  | Plum freeze dried
 | [NAME] (50ml) |  |  |  |  |  | [NAME] cake
 | Chivas Regal 12yrs (700ml) |  |  |  |  |  | Rose buds
 | Olmeca Blanco Tequila (700ml) |  |  |  |  |  | White tea (100g)
 | Campari (700ml) |  |  |  |  |  | Mini pegs
 | Cointreau (700ml) |  |  |  |  |  | Maple leaf
 | El Bandarra Rose (1000ml) |  |  |  |  |  | Grapefruit dehydrated
 | [NAME] (330ml) |  |  |  |  |  | Plastic bottle & cap
 | Miraculous foamer (118ml) |  |  |  |  |  | Blueberries freeze dried
 | Fever tree soda (200ml) |  |  |  |  |  | Raspberries freeze dried
 | Prosecco & pineapple cordial (700ml) |  |  |  |  |  | Orange dehydrated
 | [NAME] (700ml) |  |  |  |  |  | Lemon dehydrated
 | Peach & honey shrub (700ml) |  |  |  |  |  | [NAME] bottle (200ml)
 | Plum & sage cordial (700ml) |  |  |  |  |  | Garnish bag
 | Sherry & vanilla reduction (700ml) |  |  |  |  |  | Envelopes
 | Passion fruit puree (1000ml)
 | Grepefruit & vanilla falernum (700ml)
 | Chamomile & thyme cordial (700ml)
 | Maple and citrus syrup (700ml)
 | Clementine shrub (700ml)
 | Apple Juice (1000ml)
 | Fever tree lemonade (200ml)
 | El Bandarra Red (1000ml)
 | Angostura bitters (200ml)
 | Sugar (1000g)
 | Elderflower cordial (500ml)
 | Prosecco (200ml)
 | Orgeat (1000ml)
 | Maraschino liqueur (700ml)
 | [NAME] (50 per jar)
 | Chocolate bitters (200ml)
 | Lime Cordial (700ml)
Spreadsheet: chris_germany__3792__Transco
Sheet: Back

General Updates -- Transco
Contraints
Market Area IT Availability | Tier I and Tier II | OPEN
 | South Virginia Lateral Compressor Station 167 | 144 Mdt/day
 | [NAME] | OPEN
 | [NAME] at Centerville Regulator Station | OPEN
 | Linden Regulator Station | OPEN
 | Mobile Bay Lateral | 162 Mdt/day
Maintenance | NONE
Outages | NONE
Upcoming Changes | Motion rates filed Sept 1, 2001
Spreadsheet: daren_farmer__5057__HPLN0502
Sheet: Sheet1

HPLN0502.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  LIZ BELLAMY / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC)
SUBJECT:  TXU FUELS NOMINATION - May 2, 2001
 |  |  |  |  |  | **Wednesday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2001-05-02 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
 |  | Firm Summary
Enron (S) |  | Oasis Turbine |  | Enron | 10 | 10
Enron (S) |  | Sandhills |  | Enron | 8 | 8
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 215903d1361535402-sum-function-with-match-months-and-add-columns-book1-50-
Sheet: Sheet1

 | Table 1
 | # of months to add | 2013-02-01 00:00:00 | 2013-03-01 00:00:00 | 2013-04-01 00:00:00 | 2013-05-01 00:00:00 | 2013-06-01 00:00:00 | 2013-07-01 00:00:00 | 2013-08-01 00:00:00 |  | 2013-02-01 00:00:00 | 2013-03-01 00:00:00 | 2013-04-01 00:00:00
 | 3 | 170 | 60 | 50 | 105 | 75 | 60 | 190
 | 2 | 80 | 60 | 40 | 220 | 70 | 70 | 190
 | 3 | 90 | 10 | 20 | 100 | 20 | 20 | 100
 | 3 | 110 | 20 | 40 | 100 | 50 | 30 | 190
 | 3 | 16150 | 10800 | 12050 | 30100 | 40800 | 23375 | 14475
 | 2 | 140150 | 76050 | 47450 | 141150 | 120500 | 115450 | 42550
 | 4 | 908 | 715 | 954 | 1332 | 1600 | 2273 | 2299
 | 5 | 454 | 877 | 560 | 726 | 1100 | 1735 | 5418
 | 2 | 156 | 235 | 200 | 330 | 560 | 900 | 2550
Spreadsheet: 875544d1722142516-calculating-per-diem-meals-on-multiple-variables-per-diems-example
Sheet: Per Diems

 | Example
 | Departure Date | Start Time |  | Return Date | End Time
 | 2024-07-30 00:00:00 | 07:00:00 |  | 2024-08-03 00:00:00 | 17:00:00 |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Breakfast | Lunch | Dinner
 |  |  |  |  |  |  |  |  |  | 2024-07-30 00:00:00 | 0 | 1 | 1
 | Number of Nights |  |  |  |  |  |  |  |  | 2024-07-31 00:00:00 | 1 | 1 | 1
 |  |  |  |  |  |  |  |  |  | 2024-08-01 00:00:00 | 1 | 1 | 1
 | Meals entitlement - calculated from trip dates |  |  | Breakfast | Lunch | Dinner |  |  |  | 2024-08-02 00:00:00 | 1 | 1 | 1
 |  |  |  |  |  |  |  |  |  | 2024-08-03 00:00:00 | 1 | 1 | 0
 | Departure |  |  |  | Return
 | Meal | Before |  |  | Meal | After
 | Breakfast | 07:00:00 |  |  | Breakfast | 08:00:00
 | Lunch | 11:00:00 |  |  | Lunch | 14:00:00
 | Dinner | 17:00:00 |  |  | Dinner | 19:00:00
 | Question 1
 | How do I calculate the number of meals based on multiple variables:
 | 1 | Departure date and start time
 | 2 | Return date and end time
 | 3 | Departure before time for breakfast, lunch and dinner
 | 4 | Return after time for breakfast, lunch and dinner
 | Answer should populate the following:
 | 4 | in cell E14 Breakfast
 | 5 | in cell F14 Lunch
 | 4 | in cell E14 Dinner
 | Question 2
 | I want the time displayed as 24 hour time. But when you enter you must put the colon in. Is there any way to alter the way the time is entered to display as 24 hour time without having to put a colon in?
 | For example if I have formatted the cell to display 24 hour time:
 | But when I enter the time as "0700" without a colon
 | It will display like this 0:00
Spreadsheet: 732587d1621024870-possible-vlookup-function-trying-to-search-through-multiple-sheets-summary-v3
Sheet: Summary

PROJECT NUMBER | Crew mumbers | Crew Sup Days | Crew Sup OT HOURS | Camp Sup Days | Camp Sup OT Hours | CCV DAYS (C01) | CCV Miles (C01) | Support Vehicle DAYS | Support Vehicle Miles | Additional Saws | Chipper Days | FUEL REDUCTION ACRES | [NAME] | [NAME] | [NAME]
011
235
089A
11
Spreadsheet: 696230d1600709761-weekly-attendance-log-for-school-attendance-log
Sheet: Sheet1

Classroom:
Month: |  | This is where the month will go
 |  |  |  |  |  |  | Mon | Tue | Wed | Thur | Fri | Mon | Tue | Wed | Thur | Fri | Mon | Tue | Wed | Thur | Fri | Mon | Tue | Wed | Thur | Fri | Mon | Tue | Wed | Thur | Fri
 |  |  |  |  |  |  | Date to change in these boxes>>>>>>
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
Spreadsheet: 47865d1247036883-sorting-non-unique-rows-of-data-into-another-worksheet-example
Sheet: 220

Account | ID# | Src | Date | Memo/Payee | Debit | Credit | Code | Job No. | Job Name
01 | ID-2 | GJ | 1/2/2009 |  | 2342 |  | 220
01 | ID-2 | GJ | 1/2/2009 |  | 352 |  | 220
01 | ID-2 | GJ | 1/2/2009 |  | 234 |  | 220
Spreadsheet: mary_fischer__25624__31X
Sheet: E21.XLS 

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 031X
COMPANY NAME     Harper Investment Company
LEASE EXPENSE & FUTURE LEASE COMMITMENTS
FOR THE 6 MONTHS ENDED 6-30-2001
PREPARED BY:
EXTENSION: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-21
+++++INCLUDE all rentals (building, equipment, etc.) regardless of whether it is charged to "rent expense".
+++++EXCLUDE rent allocations from Corporate or other subsidiaries.
Lease Description |  |  |  | Year to Date |  |  |  |  |  | FUTURE LEASE COMMITMENT ( net of sublease , if applicable) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Residual
Property Leased, Term, Lessor |  | *(C) |  | Gross |  | Less: |  | Net Rental |  | 1 Year Ended |  |  |  |  |  |  |  |  |  | 5 Years Ended |  |  |  |  |  | Total Remaining |  | Total |  | Value
*Indicate Capital (C) or Operating (O) Lease |  | or (O) |  | Rentals |  | Subrentals |  | Expense |  | 12-31-2002 |  | 12-31-2003 |  | 12-31-2004 |  | 12-31-2005 |  | 12-31-2006 |  | 12-31-2011 |  | 12-31-2016 |  | 12-31-2021 |  | after 12-31-2021 |  | Commitment |  | Guarantee
Individually list leases w/ an annual rent expense over $1 million.
 |  |  |  | 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 |  | 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
Other Leases under $1million per year |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-21
Spreadsheet: 06242661-3f02-47b8-b19c-8e03e0b49916
Sheet: Blue JV (CR05)

[NAME]
Grant Accounting (Close Account Allotment)
White Journal Voucher (BD02)
Seq No. | Journal Type | Chart Code | Index Code | Fund Code | Org Code | Acct Code | Prog Code | Amount | + Incr - Decr +/- | Description | Period
1
 |  |  |  |  | Document Total/Hash Total:
 | Description for Document:
Prepared By: |  |  |  |  |  |  |  | Approved By:
Spreadsheet: 220041d1363038816-lookup-with-sumif-problem-lookup-problem
Sheet: Data

KIT NAME | TYPE | PART NAME 1 | PART TYPE 1 | PART QTY 1 | PART COST 1 | PART NAME 2 | PART TYPE 2 | PART QTY 2 | PART COST 2
Pickles | MFG | [NAME] | MFG | 1 | 10 | Pickle Juice | BUY | 1 | 15
Oranges | MFG | [NAME] | MFG | 1 | 20 | Orange Juice | BUY | 1 | 30
Strawberries | MFG | [NAME] | MFG | 1 | 40 | [NAME] | BUY | 1 | 60
Apples | MFG | [NAME] | MFG | 1 | 80 | Apple Juice | BUY | 1 | 120
Spreadsheet: 873079d1719503992-index-value-when-row-and-column-must-be-find-from-the-position-on-the-table-index-value-with-unknow-row-and-column
Sheet: Hárok1

RANK | VOLVO | VW | AUDI | Lookup value | RANK
1 | V70 | Passat | A3 | Golf | 2 |  | V70
2 | XC90 | Golf | Q8 | lookup value | RANK |  | XC90
3 | V70 XC | POLO | Q4 | Passat | index(table[RANK], MATCH(E4,…........ ?) |  | V70 XC
 |  |  |  |  |  |  | Passat
 |  |  |  |  |  |  | Golf
 |  |  |  |  |  |  | POLO
 |  |  |  |  |  |  | A3
 |  |  |  |  |  |  | Q8
 |  |  |  |  |  |  | Q4
Spreadsheet: 68468d1269005485-sum-with-conditions-sample-take-off-sheet
Sheet: Totals

Project Quantity Takeoff
Hospital Phase 1
Main Line Water
Length of Pipe (ft) | Size of Pipe | Type Replacing | Main Valves | [NAME] | Air Release
 | 6 | AC | 0 | 0 | 0
 | 8 | AC | 0 | 0 | 0
 | 12 | AC | 0 | 0 | 0
 | 3 | Other | 0 | 0 | 0
 | 4 | Other | 0 | 0 | 0
 | 6 | Other | 0 | 0 | 0
 | 12 | Other | 0 | 0 | 0
 |  |  |  | 0 | 0
Services
Quantity | Service [NAME] | Total Length (ft) | Type Replacing | [NAME]
1 | 1.25 | 0 | Other | 1
1 | 1.5 | 5.5 | Other | 1
4 | 2 | 104.6 | Other | 2
1 | 2.5 | 146 | Other | 1
3 | 3 | 30.3 | Other | 3
2 | 4 | 75 | Other | 2
1 | 12 | 6 | Other | 1
13 |  | 367.4 |  | 11
Hydrants
Quantity | Size | Total Length (ft) | Type Replacing | [NAME]
2 | 6 | 18 | AC | 2
2 |  | 18 |  | 2
2 | 1.5 | 12.4 | Other | 1
1 | 3 | 12.8 | Other | 1
9 | 6 | 140.1 | Other | 1
1 | 12 | 2.8 | Other | 0
13 |  | 168.1 |  | 3
Spreadsheet: 862505d1710213688-sumproduct-property-tax-calculations-property-tax-calculator
Sheet: Sheet1

Stamp Duty Calculations
Purchase Price | 1100000 | Property purchase price
Breakdown
Band start | Band end | 1st home rate | 2nd home rate |  | Amount in band | 1st home stamp duty | 2nd home stamp duty
0 | 145000 | 0 | 0.06
145000 | 250000 | 0.02 | 0.08
250000 | 325000 | 0.05 | 0.11
325000 | 750000 | 0.1 | 0.16
750000 |  | 0.12 | 0.18
Total Stamp Duty
Single cell formula
 | 1st home | 2nd home
Total Stamp Duty
[NAME] version
Spreadsheet: 454472d1459854723-converting-google-sheets-formula-to-excel-kopia-example-1
Sheet: Sheet1

Date | Buy/Sell | Stock | Units | Previous Units | Cumulative Units
2016-01-01 00:00:00 | Buy | AAPL | 1000 |  | 1000
2016-01-02 00:00:00 | Buy | GOOG | 300 |  | 300
2016-01-03 00:00:00 | Sell | AAPL | 200 |  | 800
2016-01-04 00:00:00 | Buy | GOOG | 200 |  | 500
2016-01-05 00:00:00 | Sell | GOOG | 100 |  | 400
2016-01-06 00:00:00 | Buy | AAPL | 500
2016-01-07 00:00:00 | Buy | GOOG | 200
2016-01-08 00:00:00 | Sell | GOOG | 300
2016-01-09 00:00:00 | Sell | GOOG | 100 |  | 200
Spreadsheet: 14ed6be2-1180-4ebf-b46b-27dfdd091d04
Sheet: Sheet1

 |  | Form for claiming funds as a result of extra costs associated with paying a higher stipend to a veterinary graduate or a student on an agreed Policy Placement
 | In order for BBSRC to consider whether additional funding can be agreed please complete all relevant details as indicated on the template
 | Research Organisation:-
 | Grant reference No:-
 | Amount awarded :-
 | Income from other sources used towards student support:- |  |  |  |  | (please give details)
 | Names of Student(s) supported on award |  |  |  | From | To | Veterinary Student | POP Student | Total stipend | Total Fees | Total Research Training Grant |  |  | Total other eg Fieldwork & Conference support |  |  |  |  | Total by student
 |  |  |  |  |  |  | Y/N | Y/N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total
 | Please detail any other circumstances you feel the Council should be made aware of :-
 | This is particularly so when claiming addition accommodation costs as a result of a Policy Placement away from the RO or where extra travel costs and / or stipend have been incurred.
Spreadsheet: 2fa7f7c0-8478-4e34-a372-dc7035b0acae
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
4958 | 13025 | [NAME] | Mulder | NED | 398 | 00:26:15 | 00:01:39 | 02:38:10 | 00:01:44 | 00:57:43 | 1 | 04:05:30
Spreadsheet: 133940d1324849403-extract-by-desending-order-copy_123-tvbn
Sheet: Hidden

Bname |  | Shift & Code |  |  | Fish Item |  | Category
S |  | Gopal | A01 |  | Sardin |  | Below 100 | -9e+300
 |  | Praveen | B01 |  | Chalt |  | 101-120
 |  |  |  |  | Head |  | 121-150
 |  |  |  |  | Mix |  | Above 150 |  | 9e+300
 |  |  |  |  | Thonde
 |  |  |  |  | Others
Spreadsheet: 726216d1617110525-how-to-copy-value-against-similar-description-test
Sheet: Sheet2

[NAME] | Description | QTY
121-0743MN001-1 | 121-0743MN001-1-NAVY BLUE-S
121-0743MN001-1 | 121-0743MN001-1-NAVY BLUE-M
121-0743MN001-1 | 121-0743MN001-1-NAVY BLUE-L
121-0743MN001-1 | 121-0743MN001-1-NAVY BLUE-XL
121-0743MN001-1 | 121-0743MN001-1-NAVY BLUE-XXL
121-0743MN002-1 | 121-0743MN002-1-MINT-S
121-0743MN002-1 | 121-0743MN002-1-MINT-M
121-0743MN002-1 | 121-0743MN002-1-MINT-L
121-0743MN002-1 | 121-0743MN002-1-MINT-XL
121-0743MN002-1 | 121-0743MN002-1-MINT-XXL
121-0743MN003-1 | 121-0743MN003-1-WHITE-S
121-0743MN003-1 | 121-0743MN003-1-WHITE-M
121-0743MN003-1 | 121-0743MN003-1-WHITE-L
121-0743MN003-1 | 121-0743MN003-1-WHITE-XL
121-0743MN003-1 | 121-0743MN003-1-WHITE-XXL
121-0743MN004-1 | 121-0743MN004-1-NAVY BLUE-S
121-0743MN004-1 | 121-0743MN004-1-NAVY BLUE-M
121-0743MN004-1 | 121-0743MN004-1-NAVY BLUE-L
121-0743MN004-1 | 121-0743MN004-1-NAVY BLUE-XL
121-0743MN004-1 | 121-0743MN004-1-NAVY BLUE-XXL
121-0743MN005-1 | 121-0743MN005-1-MUSTARD-S
121-0743MN005-1 | 121-0743MN005-1-MUSTARD-M
121-0743MN005-1 | 121-0743MN005-1-MUSTARD-L
121-0743MN005-1 | 121-0743MN005-1-MUSTARD-XL
121-0743MN005-1 | 121-0743MN005-1-MUSTARD-XXL
121-0743MN006-1 | 121-0743MN006-1-BLACK-S
121-0743MN006-1 | 121-0743MN006-1-BLACK-M
121-0743MN006-1 | 121-0743MN006-1-BLACK-L
121-0743MN006-1 | 121-0743MN006-1-BLACK-XL
121-0743MN006-1 | 121-0743MN006-1-BLACK-XXL
Spreadsheet: e6523c8e-3595-452a-a1f5-1f02561b0c63
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Word Records | 80688716721 | [NAME] | Give Me Amazing Grace | 2007-04-17 | Studio Series 3-Key CD Trax | Rock | 9.99 | N | To Be Retired
Spreadsheet: 297677d1392510087-converting-data-table-into-summary-for-sales-performance-excel-help-please
Sheet: Salesperson Summary

Salesperson | Deals Submitted | Funded | Currently Approved | Declined | In Review | Refused | Total Approvals | $ Funded | Approved % | Closeing %
Jake |  | 0 | 1 | 1 | 0 | 0 |  | 0
[NAME] |  | 1 | 0 | 0 | 1 | 0 |  | 250
[NAME] |  | 1 | 0 | 0 | 0 | 0 |  | 390
[NAME] |  | 0 | 1 | 1 | 0 | 0 |  | 0
[NAME] |  | 0 | 1 | 0 | 0 | 1 |  | 0
Spreadsheet: 776095d1649497659-elaborate-the-else-condition-in-the-if-function-test
Sheet: CLIENTS

CID | DENOMINATION | PHONE | VAT | FIRST NAME | LAST NAME | ADDRESS | POST | CITY | COUNTRY | [NAME] | WEBSITE | STATUS | LAST BILLED
9
8
7
6
5
4
3
2
1
Spreadsheet: 94801d1294574795-correct-x-axis-in-graph-cw-final
Sheet: Agriculture

 |  | Agriculture and Forestry
 | Year/Quarter | Investment Y | 4 Quarter MT (Moving Total) | 4 Quarter [NAME] (Moving Average) | Centered Moving Average (Trend) | Seasonal Factor | Adjusted SF | Predicted sales | Error | Absolute Error | Squared Error
 | 2006             Q3 | 702
 | Q4 | 705
 | 2007             Q1 | 805
 | Q2 | 775
 | Q3 | 794
 | Q4 | 761
 | 2008             Q1 | 988
 | Q2 | 900
 | Q3 | 960
 | Q4 | 774
 | 2009             Q1 | 763
 | Q2 | 762
 | Q3 | 769
 | Q4 | 777
 | 2010             Q1 | 802 |  |  |  |  |  |  | Sum =
 | Q2 | 799 |  |  |  |  |  |  | Mean
 | Quarter | 1 |  | 2 | 3 | 4
 | 2006
 | 2007
 | 2008
 | 2009
 | 2010 |  |  |  |  |  | Sum | Correction Factor Divide 4 By Sum
 | Average
 | Adjusted