tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 264634d1378924689-top-10-list-of-students-from-separate-worksheets-grade-6-marks-solved
Sheet: Grade 6.1

 | Last | First |  |  |  |  | Total | Level
1 | Karissa | [NAME] | 28 | 16 | 10 | 20
2 | [NAME] | [NAME] | 19 | 21 | 8 | 20
3 | Agnus | Chelsie | 23 | 22 | 10 | 20
4 | Andria | [NAME] | 16 | 10 | 8 | 20
5 | Annis | Magdalene | 31 | 15 | 10 | 18
6 | Takisha | [NAME] | 18 | 21 | 8 | 20
7 | [NAME] | [NAME] | 33 | 23 | 8 | 20
8 | Dillon | Tami | 24 | 20 | 8 | 20
9 | Jacquie | Charlena | 21 | 15 | 10 | 20
10 | Virgen | Saundra | 25 | 19 | 8 | 16
11 | Holley | [NAME] | 30 | 10 | 10 | 20
12 | Clarence | Wenona | 19 | 12 | 8 | 20
13 | Ema | Judson | 32 | 21 | 8 | 20
14 | Chassidy | [NAME] | 39 | 25 | 8 | 20
15 | Edra | [NAME] | 22 | 20 | 10 | 20
16 | [NAME] | [NAME] | 28 | 21 | 8 | 20
17 | [NAME] | Allene | 28 | 14 | 10 | 20
18 | Shira | Travis | 27 | 18 | 8 | 20
19 | Kristen | Nola | 26 | 21 | 9 | 20
20 | Danyel | [NAME] | 32 | 30 | 8 | 20
21 | Wm | Scarlet | 20 | 15 | 8 | 20
22 | Bebe | Nikita | 17 | 14 | 10 | 18
23 | [NAME] | [NAME] | 13 | 12 | 8 | 20
24 | Kimberlee | Bree | 16 | 16 | 8 | 20
25 | [NAME] | Casie | 24 | 15 | 10 | 20
26 | Jayme | Joetta | 21 | 18 | 10 | 20
27 | Anja | Anette | 20 | 20 | 10 | 20
28 | [NAME] | Lynelle | 31 | 27 | 8 | 20
29 | Edyth | [NAME] | 12 | 16 | 8 | 20
30 | Elodia | Candance | 14 | 18 | 8 | 20
31 | [NAME] | [NAME] | 15 | 15 | 8 | 20
32 | [NAME] | Crystal | 20 | 13 | 8 | 20
33 | Minnie | Danelle | 23 | 13 | 8 | 20
34 | Cristal | [NAME] | 19 | 16 | 8 | 20
35 | [NAME] | [NAME] | 21 | 18 | 8 | 20
36 | [NAME] | [NAME] | 24 | 16 | 8 | 20
37 | Mazie | [NAME] | 22 | 13 | 8 | 20
38 | Judson | Jayme | 29 | 21 | 8 | 20
Spreadsheet: 376375d1423584492-if-less-than-zero-report-in-different-column-new-dr-cr-formula
Sheet: Template

 |  |  |  | Balance Control
 |  |  |  | Debits
 |  |  |  | Credits
 |  |  |  | Control Total
Line Item Data
Company Code | G/L Account | Cost Centre | Profit Centre | WBS Element | Internal Order No. | Assignment | Line Item Text | Debit Amount | Credit Amount | Compliance Code | Journal Analysis Code
S101 | 700020 |  | 1010926
S101 | 700020 |  | 1010926
S101 | 700020 |  | 1010926
S101 | 700020 |  | 1010926
Should be the following
Line Item Data
Company Code | G/L Account | Cost Centre | Profit Centre | WBS Element | Internal Order No. | Assignment | Line Item Text | Debit Amount | Credit Amount | Compliance Code | Journal Analysis Code
S101 | 700020 |  | 1010926 | I.005000.14 |  |  | SRC Recharge Network 1 |  | 5000
S101 | 700020 |  | 1010926 | 1001 |  |  | SRC Recharge Network 1 | 5000
S101 | 700020 |  | 1010926 | I.005001.25 |  |  | SRC Recharge Network 2 | 1000
S101 | 700020 |  | 1010926 | 1002 |  |  | SRC Recharge Network 2 |  | 1000
Spreadsheet: 680813d1591200819-sortin-alphanumeric-data-books-sold-box-numbers-1
Sheet: Sheet2

433 | 18
433 | 30b
341 | 30b
30b | 38
137a | 56
140a | 68a
287 | 71
56 | 85
392 | 94
94 | 95
325 | 111
RED BOX | 137a
249 | 140a
390 | 142
284 | 146
228 | 217
18 | 228
71 | 232a
30b | 232a
111 | 236
343 | 249
217 | 263
95 | 281
232A | 284
85 | 285
236 | 287
294 | 289
427 | 294
296 | 296
281 | 325
232A | 341
38 | 343
263 | 390
394 | 392
285 | 394
FILL UP | 411
68A | 420
411 | 427
146 | 433
142 | 433
RED BOX | Fill Up
420 | Red box
289 | Red box
Spreadsheet: 219908d1363011609-auto-reapply-autofilter-test
Sheet: Honing

Detail No. | Quantity | [NAME] | Set Up Mandrels | Inspection | Jig Bore Honing | Other | Total Time (hours) | NOTES
 | 0 |  |  |  |  |  | 0
 | 0 |  |  |  |  |  | 0
 | 0 |  |  |  |  |  | 0
 | 0 |  |  |  |  |  | 0
 | 0 |  |  |  |  |  | 0
 | 0 |  |  |  |  |  | 0
 | 0 |  |  |  |  |  | 0
 | 0 |  |  |  |  |  | 0
 | 0 |  |  |  |  |  | 0
 | 0 |  |  |  |  |  | 0
 | 0 |  |  |  |  |  | 0
 | 0 |  |  |  |  |  | 0
 | 0 |  |  |  |  |  | 0
 | 0 |  |  |  |  |  | 0
 | 0 |  |  |  |  |  | 0
 | 0 |  |  |  |  |  | 0
 | 0 |  |  |  |  |  | 0
 | 0 |  |  |  |  |  | 0
 | 0 |  |  |  |  |  | 0
 | 0 |  |  |  |  |  | 0
. |  |  |  |  | Grand Total |  | 0
Spreadsheet: 725829d1616917317-help-on-adjusting-excel-formula-to-calculate-more-date-sales-ledger-7
Sheet: Customers statement

Current solution calculate 100 record on the sheets. I want it to calculate at least 5000 record on the sheets.
I have tried to adjust the formula but I have failed. Please help me.
 | ST 001
Date | Receipt Number | Invoice Number | Debit | Credit | Cumulative Balance |  |  | Sheet | Row
Desired Outcome
 | ST 001
Date | Receipt Number | Invoice Number | Debit | Credit | Cumulative Balance
2020-01-01 00:00:00 |  | C001 | 400
2020-01-10 00:00:00 |  | 1 | 2000
2020-01-12 00:00:00 | R010 | C001 |  | 300
2020-01-14 00:00:00 | R012 | 3 |  | 1000
2020-05-12 00:00:00 |  | 5 | 2300
2020-09-09 00:00:00 |  | 9 | 2500
Spreadsheet: 8d6bb4ba-8f68-4906-8f1f-79ed3ce8b7ea
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
CAR | Test | CAR | Carbamazepine, Total, Serum | Carbamazepine, Total, S | Immunoassay | Plain, Red-Top Tube: Red |  |  | 1 | mL | Container/Tube: Red top [NAME]: 1 mL | 0.4 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	Plasma or serum gel tube | Therapeutic concentration: 4.0-12.0 mcg/mL Toxic concentration: > or =15.0 mcg/mL | Monday through Sunday; Varies | Same day/1 day | 1 day | 1 | 80156 |  |  |  |  | Rochester
CAR | [NAME] | SRED | Serum Red |  |  |  | Refrigerated | 14 days
CAR | Result | 8654 | Carbamazepine, Total, S | Carbamazepine, Total, S | Numeric |  |  |  |  | mcg/mL |  |  |  |  |  |  |  |  |  | 3432-2
Spreadsheet: daren_farmer__6612__P&L0307
Sheet: Consolidated

HPLC CONSOLIDATED TRADING P&L AND POSITIONS
2000-03-07 00:00:00
 |  | DAILY P&L | MONTH TO DATE P&L | QUARTER TO DATE P&L | QUARTER BUDGET | OVER/(UNDER) BUDGET |  | YEAR TO DATE P&L | ANNUAL BUDGET | OVER/(UNDER) BUDGET
ST Trading (Martin) |  | 751.0703065774869 | 654289.8314620722 | 5941465.831462072 | 3125000 | 2816465.831462072 |  | 5941465.831462072 | 12500000 | -6558534.168537928
Firm Trading (McClendon) |  | -209446.5973 | -455691.4454999999 | 310099.5545000001 | 1250000 | -939900.4454999999 |  | 310099.5545000001 | 5000000 | -4689900.445499999
Gas Daily Trading (Metz) |  | 123666.3237 | 626907.9731999999 | 1187634.9732 | 0 | 1187634.9732 |  | 1187634.9732 | 0 | 1187634.9732
Storage (Schwieger) |  | 52323.51180000008 | 1924360.200000008 | 7347294.200000009 | 1807000 | 5540294.200000009 |  | 7347294.200000009 | 7500000 | -152705.7999999914
Trading Overview |  |  |  |  | 1250000 |  |  |  | 5000000
TOTAL TRADING |  | -32705.69149342245 | 2749866.55916208 | 14786494.55916208 | 7432000 | 8604494.55916208 |  | 14786494.55916208 | 30000000 | -10213505.44083792
Transport (Gottlob) |  | 0 | 1902000 | 5981000 | 4626966 | 1354034 |  | 5981000 | 18836000 | -12855000
Spreadsheet: 35123d1232638375-search-for-hidden-data-league-table
Sheet: TABLE

GEGEVENS
[NAME] |  | PL | W | D | L | F | A | TEAM | W | D | L | F | A | [NAME] | PTS |  | GF
 |  |  |  |  |  |  |  | AFC BOURNEMOUTH
 |  |  |  |  |  |  |  | BRIGHTON AND HOVE ALBION
 |  |  |  |  |  |  |  | BRISTOL ROVERS
 |  |  |  |  |  |  |  | CARLISLE UNITED
 |  |  |  |  |  |  |  | CHELTENHAM TOWN
 |  |  |  |  |  |  |  | CREWE ALEXANDRA
 |  |  |  |  |  |  |  | DONCASTER ROVERS
 |  |  |  |  |  |  |  | GILLINGHAM
 |  |  |  |  |  |  |  | HARTLEPOOL UNITED
 |  |  |  |  |  |  |  | HUDDERSFIELD TOWN
 |  |  |  |  |  |  |  | LEEDS UNITED
 |  |  |  |  |  |  |  | LEYTON ORIENT
 |  |  |  |  |  |  |  | LUTON TOWN
 |  |  |  |  |  |  |  | MILLWALL
 |  |  |  |  |  |  |  | NORTHAMPTON TOWN
 |  |  |  |  |  |  |  | NOTTINGHAM FOREST
 |  |  |  |  |  |  |  | OLDHAM ATHLETIC
 |  |  |  |  |  |  |  | PORT VALE
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | SWINDON TOWN
 |  |  |  |  |  |  |  | TRANMERE ROVERS
 |  |  |  |  |  |  |  | WALSALL
 |  |  |  |  |  |  |  | YEOVIL TOWN
GESORTEERD | LEAGUE DIVISION 2        (2007/8)
[NAME] | POST | PL | W | D | L | F | A | TEAM | W | D | L | F | A | [NAME] | PTS |  | GF
 | 1st
 | 2nd
 | 3rd
 | 4th
 | 5th
 | 6th
 | 7th
 | 8th
 | 9th
 | 10th
 | 11th
 | 12th
 | 13th
 | 14th
 | 15th
 | 16th
 | 17th
 | 18th
 | 19th
 | 20th
 | 21st
 | 22nd
 | 23rd
 | 24th
Spreadsheet: 879688d1727262919-employee-tardiness-formula-requested-tardiness-formula-request-sample-2
Sheet: Sheet1

Agent ID | Logged On DateTime
Carroll, [NAME] | 8/2/24 8:13:27 AM
 | 8/5/24 8:21:35 AM
 | 8/5/24 3:31:24 PM |  |  |  |  |  |  | Needing formula to return "Late" if first time for the date in Column B is greater than 8:05:00 AM
 | 8/6/24 8:24:21 AM
 | 8/7/24 8:13:55 AM
 | 8/8/24 10:56:22 AM
 | 8/9/24 8:17:54 AM
 | 8/12/24 8:03:35 AM
 | 8/13/24 8:17:37 AM
 | 8/14/24 8:13:07 AM
 | 8/15/24 8:19:18 AM
 | 8/16/24 7:59:05 AM
 | 8/19/24 7:33:44 AM
 | 8/19/24 9:55:00 AM
 | 8/20/24 8:14:05 AM
 | 8/21/24 8:08:57 AM
 | 8/22/24 7:43:24 AM
Spreadsheet: 177900d1346509072-date-format-problem-copy-of-format-cells_2
Sheet: Sheet1

[NAME] | [NAME]  OK/NOT OK | [NAME] | [NAME]  OK/NOT OK
15/02/2012 | NOT OK | 15/02/2012 | NOT OK
2012-02-15 00:00:00 | OK | 2012-02-15 00:00:00 | OK | Column A has been formatted: CTRL + 1 > Number > Custom > d.mm.yyyy
2012-12-31 00:00:00 | OK | 2012-12-31 00:00:00 | OK | I just enter my date as 2/12/2012 & enter.
31/12/2012 | NOT OK | 31/12/2012 | NOT OK
2012-01-02 00:00:00 |  | 2012-01-02 00:00:00
Spreadsheet: 128214d1320857504-sumproduct-problems-excel-help
Sheet: Summary

 | [NAME] |  | Skills Link |  | Phase |  | Targets | Actual | Varience
Province | IWE | Project | IWE | Project | I* | II*
AB | 6 | 13 | 1 | 94 | 40 | 74 | 2047 | 1057 | -990 | 0
BC | 25 | 26 | 15 | 132 | 28 | 170 | 4248 | 4054 | -194
MB | 4 | 6 | 7 | 101 | 14 | 104 | 2791 | 1116 | -1675
NB |  |  |  |  |  |  |  |  | 0
NL |  |  |  |  |  |  |  |  | 0
NS |  |  |  |  |  |  |  |  | 0
NT |  |  |  |  |  |  |  |  | 0
NU |  |  |  |  |  |  |  |  | 0
ON |  |  |  |  |  |  |  |  | 0
PE |  |  |  |  |  |  |  |  | 0
QC |  |  |  |  |  |  |  |  | 0
SK |  |  |  |  |  |  |  |  | 0
YT |  |  |  |  |  |  |  |  | 0
Total | 35 | 45 | 23 | 327 | 82 | 348 | 9086 | 6227 | -2859
1*- Assessment       Recommendation and Approval      Commit      Agreement Set-up      Amendment |  |  |  | 2*- Agreement      Agreement Management      Post-closure      Close-out
Spreadsheet: 111218d1307641892-capturing-data-and-if-formula-nested-kookai-_sample-sheet-noc-
Sheet: request

 | TSD NOC REFERENCE NO. | RECEIVED DATE | [NAME] | ORIGINATOR'S REFERENCE NO. | ORIGINATOR | DEPARTMENT | [NAME] | STATUS | REPLY TO ORGINATOR | ESR REF. NO. | RESPONSE FROM ORIGINATOR | DATE RECEIVED | [NAME] | REMARKS | UOP NOC REFERENCE NO. | Validity Date after 90 Days from Issued Date
 | TSD-NOC-1-001 | 2010-03-16 00:00:00 | [NAME] |  |  |  | RP | Awaiting Response | 2010-04-30 00:00:00
 | TSD-NOC-1-002 | 2010-05-23 00:00:00 | NOC2 |  |  |  | RP | Cancelled | 2010-05-23 00:00:00 |  |  |  | Cancelled
 | TSD-NOC-1-003 | 2010-05-18 00:00:00 | NOC3 |  |  |  | RP | Complete | 2010-05-18 00:00:00 |  |  |  | Released
 | TSD-NOC-1-004 | 2010-08-10 00:00:00 | NOC4 |  |  |  | RD | Awaiting Response
 | TSD-NOC-1-005 | 2010-11-29 00:00:00 | [NAME] |  |  |  | RD | Complete | 2010-11-29 00:00:00 |  |  |  | Released
 | TSD-NOC-1-006 | 2010-12-16 00:00:00 | [NAME] |  |  |  | AF | Complete | 2011-02-15 00:00:00 |  |  |  | Released
 | TSD-NOC-1-007 | 2010-12-23 00:00:00 | [NAME] |  |  |  | AF | Complete | 2011-02-15 00:00:00 |  |  |  | Released
 | TSD-NOC-1-008 | 2010-12-27 00:00:00 | NOC8 |  |  |  | AF | Under Study | 2011-01-03 00:00:00
 | TSD-NOC-1-009 | 2010-12-27 00:00:00 | NOC9 |  |  |  | AF | Complete | 2011-01-03 00:00:00 |  |  |  | Released
 | TSD-NOC-1-010 | 2010-12-27 00:00:00 | NOC10 |  |  |  | AF | Awaiting Response
 | TSD-NOC-1-011 | 2010-12-27 00:00:00 | NOC11 |  |  |  | AF | Awaiting Response
 | TSD-NOC-1-012 | 2010-12-28 00:00:00 | NOC12 |  |  |  | AF | Complete | 2011-01-03 00:00:00 |  |  |  | Released
 | TSD-NOC-1-013 | 2010-12-30 00:00:00 | NOC13 |  |  |  | AF | Cancelled | 2011-01-03 00:00:00 |  |  |  | Cancelled
 | TSD-NOC-1-014 | 2011-06-01 00:00:00 | NOC14 |  |  |  | AF | Pending
 | TSD-NOC-1-015
 | TSD-NOC-1-016
 | TSD-NOC-1-017
Spreadsheet: e4924fa0-8860-4a02-94f2-bcbd19ab6774
Sheet: ER - Schedule 3 QTD

Kraft Foods Inc. and Subsidiaries
Operating Income by Reportable Segments
For the Three Months Ended June 30,
($ in millions)  ([NAME])
 |  |  | 2010 Impacts |  |  |  |  |  |  |  | 2011 Impacts
 | 2010 Operating Income -   As Reported (GAAP) |  | Acquisition-Related Costs (1) |  | Integration Program Costs (2) |  | Impact of [NAME] (3) |  | Impact of Accounting Calendar Changes |  | Integration Program Costs (2) |  | Impact of Accounting Calendar Changes |  | Impact of Currency |  | Operations |  | 2011 Operating Income -     As Reported (GAAP) |  | % Change
Segment Operating Income:
U.S. Beverages | 178 |  | 0 |  | 0 |  | -36 |  | 0 |  | 0 |  | 0 |  | 0 |  | -4 |  | 138 |  | -0.225
U.S. Cheese | 136 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 7 |  | 143 |  | 0.051
U.S. Convenient Meals | 101 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -2 |  | 99 |  | -0.02
U.S. Grocery | 357 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 22 |  | 379 |  | 0.062
U.S. Snacks | 240 |  | 0 |  | 5 |  | 0 |  | 0 |  | -8 |  | 0 |  | 0 |  | -45 |  | 192 |  | -0.2
Canada & N.A. Foodservice | 175 |  | 0 |  | 2 |  | -1 |  | 0 |  | -6 |  | 0 |  | 11 |  | 7 |  | 188 |  | 0.074
Kraft Foods North America | 1187 |  | 0 |  | 7 |  | -37 |  | 0 |  | -14 |  | 0 |  | 11 |  | -15 |  | 1139 |  | -0.04
Kraft Foods Europe | 335 |  | 0 |  | 33 |  | 0 |  | -8 |  | -58 |  | 34 |  | 46 |  | 33 |  | 415 |  | 0.239
Kraft Foods Developing Markets | 429 |  | -2 |  | 32 |  | -2 |  | -2 |  | -55 |  | 10 |  | 79 |  | 29 |  | 518 |  | 0.207
Unrealized G/(L) on Hedging Activities | 22 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -122 |  | -100
HQ Pension | -25 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -19 |  | -44
General Corporate Expenses | -187 |  | 12 |  | 77 |  | 0 |  | 0 |  | -9 |  | 0 |  | -3 |  | 45 |  | -65
Amortization of Intangibles | -60 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -6 |  | 9 |  | -57
Kraft Foods | 1701 |  | 10 |  | 149 |  | -39 |  | -10 |  | -136 |  | 44 |  | 127 |  | -40 |  | 1806 |  | 0.062
(1)  Acquisition-related costs include transaction advisory fees, U.K. stamp taxes and the impact of the Cadbury inventory revaluation.
(2)  Integration Program costs are defined as the costs associated with combining the Kraft Foods and Cadbury businesses, and are separate from those costs associated with the acquisition.
(3)  Impact of divestitures includes Starbucks CPG business.
Spreadsheet: 704942d1605813094-offset-formulas-counter
Sheet: Sheet1

 |  | 2020-11-16 00:00:00
 |  | Job | Hrs | Job | Hrs | Job | Hrs | Job | Hrs | Job | Hrs | Job | Hrs
 | [NAME] | Despatch | 2 | Delivery | 5
 | Jon |  |  |  |  | [NAME] | 8
 | [NAME] |  |  |  |  | Despatch | 7 | Delivery | 1
 | [NAME] | Inbound | 5 | Delivery | 2
 | [NAME] |  |  |  |  |  |  |  |  | Delivery | 7 | [NAME] | 1
 | [NAME] | Delivery | 6 | [NAME] | 4
 |  |  |  | 2020-11-16 00:00:00 | 2020-11-17 00:00:00
 |  |  | [NAME] | 7 |  |  | like to be able to quanity the total hours worked on a day.
 |  |  | Jon |  |  |  | [NAME] is the example he's worked a total of 7hrs on 16/11
 |  |  | [NAME] |  |  |  | This is only a very small example of the sheet, the data set lasts for a number of months at any given time
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
Spreadsheet: 855605d1705119459-get-data-from-1-sheet-to-other-sheets-depending-on-drop-down-list-christmas-comp-trial-for-extra-species
Sheet: MysteryWeight

MYSTERY    LENGTH   WINNERS
Bream | [NAME] (mm) | Closest Length (mm) | difference | Age Group | Angler # | [NAME] |  | LOW | HIGH | RANDOM NUMBER GENRATOR
Flathead | [NAME] (mm) | Closest Length (mm) | difference | Age Group | Angler # | [NAME] |  | LOW | HIGH | RANDOM NUMBER GENRATOR
OVERALL BIGGEST FISH WINNERS
Bream |  | Length | Angler # | Name |  |  |  | Press F9 to complete Calculations Check for TIE's!
 | Small Fry
 | Junior
 | High School
Flathead |  | Length | Angler # | Name
 | Small Fry
 | Junior
 | High School
Spreadsheet: darrell_schoolcraft__7816__imbalsumm0109
Sheet: Lonestar

 | 57245 |  | 500154
 | [NAME] |  | Pecos Del
Day | Measured | Scheduled | Measured | Scheduled
1 | -18474 | -500 |  | -17302
2 | -17798 | -500 |  | -17302
3 | -17797 | -500 |  | -17302
4 | -18510 | -500 |  | -17302
5 | -28067 |  |  | -27302
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
 | 2001-08-31 00:00:00 |  |  |  | 73003
 | 2001-09-05 00:00:00
CBS Dollars
 |  |  | 71591
Spreadsheet: 37643d1235675339-grouping-duplicates-example-25
Sheet: Sheet1

 | frad
car | 1
bus | 2
[NAME] | 3
tram | 4
car | 5
bus | 6
[NAME] | 7
tram | 8
car | 9
bus | 10
[NAME] | 11
 |  | Page1 | Item2
 |  | Count of Value | Column
 |  | Row | frad | mick | Grand Total
 |  | bus | 4 | 4 | 8
 |  | car | 4 | 4 | 8
 |  | [NAME] | 3 | 3 | 6
 |  | Grand Total | 11 | 11 | 22
Spreadsheet: 61595d1262537005-sum-formatting-problem-example1
Sheet: 130052

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 130052
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LOG NO:
PIC: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Return Date:
SIC: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dept Date:
F/A: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Days:
IRP: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RON's:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Previous  Log Closed:
[NAME] |  |  |  |  |  |  | CLA TIME |  |  |  | CURRENCY |  |  |  |  | FUEL |  |  |  | PER DIEM |  |  |  |  | ZULU
LEG | DATE | B/P/C | PF | FROM | TO |  | T.O. | FLIGHT | LDG |  | NIGHT | D/N | P/N/V | HOLD |  | OUT | IN | TOTAL |  | HOURS |  | RATE | $ |  | T.O. | LDG
1 | 2009-11-22 00:00:00 | C | MG | VNY | BFI | 15:32:00 | 10:18:00 | 02:18:00 |  |  | 00:00:00 | D | P | 0 |  | 21800 | 13650 |  |  |  |  | 2.25
2 | 2009-11-22 00:00:00 | C | SV |  | VNY |  | 23:22:00 | 01:50:00 |  |  | 00:00:00 | N | V | 0 |  |  | 6000 |  |  |  |  | 2.25
3 |  |  |  |  | 0 |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 |  |  |  |  |  | 0 |  |  |  |  | 0
4 |  |  |  | 0 | 0 |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 |  |  |  |  |  | 0 |  |  |  |  | 0
5 |  |  |  |  | 0 |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 |  |  |  |  |  | 0 |  |  |  |  | 0
6 |  |  |  |  | 0 |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 |  |  |  |  |  | 0 |  |  |  |  | 0
7 |  |  |  |  | 0 |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 |  |  |  |  |  | 0 |  |  |  |  | 0
8 |  |  |  |  | 0 |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 |  |  |  |  |  | 0 |  |  |  |  | 0
9 |  |  |  |  | 0 | 3 | 00:00:00 | 00:00:00 |  |  | 00:00:00 |  |  |  |  |  | 0 |  |  |  |  | 0
 | PST | 8:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Closed
 | DST | 7:00:00
 | Today |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Per Diem Add - Fwd from previous [NAME]. Log only |  |  |  |  |  | 0
 |  |  |  |  | HOURS |  |  | CYCLES |  |  |  |  |  |  |  |  |  |  |  | Per Diem Add |  | 0
 | ACTT Forwarded
 | Total this Log |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Adjusted Total
 | Totals to Date
Spreadsheet: 075900ed-e4e3-4bcc-91bf-39f06b433412
Sheet: Sheet1

Parsons APT 2010-2011 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Last Name | First Name | School | Rank | Title | Employment Category
[NAME] | [NAME] | AMT | Associate Professor | of Photography | Tenured
Cho | Erin | SDS | Associate Professor | of Design Management | Tenured
[NAME] | [NAME] | ADHT | Associate Professor | of Art and Design History and Theory | Tenured
Dilnot | Clive | ADHT | Professor | of Design Studies | Tenured
[NAME] | Simone | AMT | Associate Professor | of Photography | Tenured
Fry | [NAME] | SDS | Associate Professor | of Studio Methods | Extended Employment
Judge | [NAME] | SDS | Associate Professor | of Studio Methods | Extended Employment
Katchor | [NAME] | AMT | Associate Professor | of Illustration | Tenured
Kirkbride | [NAME] | SCE | Associate Professor | of Product Design | Tenured
Krug | [NAME] | AMT | Associate Professor | of Illustration | Tenured
[NAME] | [NAME] | ADHT | Associate Professor | of Design History | Extended Employment
Lewis | [NAME] | SCE | Associate Professor | of Architecture | Tenured
Matthews | Lydia | Deans'  Office | Professor | of Visual Culture | Extended Employment
McGrath | [NAME] | SCE | Associate Professor | of Urban Design | Tenured
[NAME] | Miodrag | SDS | Associate Professor | of Design Studies | Tenured
Morrish | [NAME] | SCE | Professor | of Architecture | Tenured
Ramer | [NAME] | AMT | Associate Professor | of Photography | Extended Employment
Salen | [NAME] | AMT | Professor | of Media Design | Tenured
[NAME] | [NAME] | SDS | Associate Professor | of Design and Management | Extended Employment
[NAME]* | Jilly | ADHT | Associate Professor | of Spatial Design Studies | Tenured
Travis | Sven | AMT | Associate Professor | of Media Design | Extended Employment
* [NAME] is the only member of the current APT who completed the PPR prior promotion.
Parsons Successful PPR candidates
Auricchio | [NAME] | ADHT | Assistant Professor | of [NAME] | Re-appointed (for PPR) on tenure track
[NAME] | [NAME] | SCE | Assistant Professor | of Architectural Design | Re-appointed (for PPR) on tenure track
Brody | [NAME] | ADHT | Assistant Professor | of Design Studies | Re-appointed (for PPR) on tenure track
Gatzen | Pascale | SDS | Assistant Professor | of Fashion Design | Re-appointed (for PPR) on tenure track
[NAME] | Heike | ADHT | Associate Professor | Art and Design History | Re-appointed (for PPR) on tenure track
Kraynak | [NAME] | ADHT | Assistant Professor | of Fashion Studies | Re-appointed (for PPR) on tenure track
[NAME] | [NAME] | SDS | Assistant Professor | of Integrated Design | Re-appointed (for PPR) on EE track
Merwood-Salisbury | [NAME] | SCE | Assistant Professor | of Architectural History and Theory | Re-appointed (for PPR) on tenure track
Porter | Derek | SCE | Assistant Professor | of Lighting Design | Re-appointed (for PPR) on tenure track