tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 483e6827-0679-4ffe-8dae-14b92c4c3f1c
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
6851 | 40952 | [NAME] | Egan | GBR | 81 | 00:15:10 | 00:01:26 | 01:12:03 | 00:01:15 | 00:18:10 | 1 | 01:48:03
6851 | 47821 | [NAME] | [NAME] | GBR | 82 | 00:14:46 | [NAME] | 01:15:56 | 00:01:25 | 00:21:09 | 2 | 01:55:01
Spreadsheet: 734967d1622624680-data-validation-across-multiple-sheets-convalida_dati
Sheet: foglio_1

123456789 | abcde1
123456790 | abcde2 |  |  |  | =CONTA.SE($A:$A; A2)=1
123456791 | abcde3
123456792 | abcde4 |  |  |  | =COUNTIF($A:$A, A2)=1
123456793 | abcde5
123456794 | abcde6
123456795 | abcde7
123456796 | [NAME]
123456797 | abcde9
123456798 | abcde10
123456799 | abcde11
123456800 | abcde12
123456801 | abcde13
123456802 | abcde14
123456803 | abcde15
123456804 | abcde16
123456805 | abcde17
123456806 | abcde18
123456807 | abcde19
123456808 | abcde20
Spreadsheet: 293552d1391019437-need-a-way-to-find-ip-addresses-from-a-spreadsheet-that-contains-hostnames-in-column-a-excelforumfindipaddresseswithtracertorping-2014-01-29-13-15
Sheet: Main

ExcelForumFindIPAddressesWithTracertOrPing.xls
This uses the Windows (MS-DOS)  'TRACERT.EXE' command or 'PING.EXE' command or 'OTHER' command to obtain IP Addresses from Host Names.
The results of the command are written into text file 'Scratch00.txt' and then imported into 'Sheet2'.
Files 'Scratch00.bat' and 'Scratch01.txt' are also used (and automatically deleted into the 'Recycle Bin' when no longer needed).
Program execution can be stopped by pressing the 'ESC' key.
 |  |  |  | Items in 'Light Green' Can be Changed by the User
Tracert.exe command string: |  |  |  | [NAME] 1 |  | Original value: 'tracert -d -h 1'  (where -d = do not resolve host name and -h 1 = maximum of one hop)
Ping.exe command string: |  |  |  | ping -n 1 -a |  | Original value: 'ping -n 1  -a' (where 'n 1' = one echo request and -a = resolve addresses)
Other program command string: |  |  |  | nslookup -type=a
Program Selected: |  |  |  | [NAME]
[NAME]: |  |  |  | ping -n 1 -a
Folder for Scratch Files: |  |  |  | C:\tmp\
Scratch File Names: |  |  |  | Scratch00.bat |  | Scratch00.txt |  | Scratch01.txt
Data Folder For This Workbook: |  |  |  | C:\Users\Owner\Documents\Lew\WindowsBatchFiles\ExcelAndVba\
Delete File Scratch00.txt on Completion: |  |  |  | Yes
Clear Scratch Sheet (Sheet2) on Completion: |  |  |  | No | (When the  Program [NAME] is 'Other', the Scratch Sheet is NEVER Cleared on Completion.
Maximum Wait (seconds) for 'dir' completion: |  |  |  | 30 | (default 120.0 seconds)
Source Data Workbook Path: |  |  |  | C:\Users\Owner\Documents\Lew\WindowsBatchFiles\ExcelAndVba\
Source Data Workbook Name: |  |  |  | ExcelForumFindIPAddressesWithTracertOrPing.xls
Source Data Worksheet Name: |  |  |  | SheetN
Source Data Range 1st cell: |  |  |  | B4
Destination Column: |  |  |  | K
Reference: | http://www.excelforum.com/excel-programming-vba-macros/984383-need-a-way-to-find-the-ip-address-from-a-hostname-in-excel.html
[NAME]: | http://www.excelforum.com/excel-general/984724-need-a-way-to-find-ip-addresses-from-a-spreadsheet-that-contains-hostnames-in-column-a.html
Program Selected: |  | [NAME]
[NAME]: |  | ping -n 1 -a
Elapsed time: 2.06 Seconds---Program completed (using [NAME]ping -n 1 -a')
Spreadsheet: 703620d1605087175-copy-different-and-changing-length-lists-from-multiple-sheets-dept-summary-for-questions-ans
Sheet: Example

TYPE 1 |  |  |  |  | TYPE 2 |  |  |  |  | TYPE 3 |  |  |  |  | TYPE 4 |  |  |  |  | TYPE 5 |  |  |  |  | TYPE 2
LAST NAME | FIRST NAME | DIVISION | START | STOP | LAST NAME | FIRST NAME | DIVISION | START | STOP | LAST NAME | FIRST NAME | DIVISION | START | STOP | LAST NAME | FIRST NAME | DIVISION | START | STOP | LAST NAME | FIRST NAME | DIVISION | START | STOP | LAST NAME | FIRST NAME | DIVISION | START | STOP
 |  | Similarly for division tabs also.
Spreadsheet: 819627d1677603563-conditional-formatting-not-operating-correctly-when-comparing-an-if-statement-in-a-cell-book1
Sheet: INVENTORY

ACTUAL QTY IN YOUR VAN | QUANTITY / SERIAL NUMBER | ITEM CODE | [NAME] | AVAILABILITY | STATUS | INVENTORY VALUE | Total items
2 | 2 | 1000155 | ( OBSOLETE ) CISCO - USB / SERIAL CISCO SWITCH CONFIGURATION CBL | On Hand | Good | 12.7
0 | 3 | 7310420 | ( OBSOLETE )TT - MINUTE CLINIC 2019 Refresh Kiosk Thumb Drive 16GB | On Hand | Good | 0
4 | 4 | 7310973 | 128T -  Silicom Router AT&T SIMM Card 6378B | On Hand | Good | 0
5 | 5 | 7310818 | 128T - Lanner NCA-1515B Router - DDR 8G SODIMM 128 SSD LTE 7455 Kit | On Hand | Good | 555
1 | LR8764847659 | 7310818 | 128T - Lanner NCA-1515B Router - DDR 8G SODIMM 128 SSD LTE 7455 Kit | On Hand | Good | 555
7 | 7 | 7310628 | 128T - Silicom Madrid Router  90500-0151-G61( GEN1 ) - W/ Modem,  W/2 external antenna ports | On Hand | Good | 492
1 | 869896590875 | 7310628 | 128T - Silicom Madrid Router  90500-0151-G61( GEN1 ) - W/ Modem,  W/2 external antenna ports | On Hand | Good | 492
3 | 3 | 682559 | 25 FOOT EXTENSION CORD | On Hand | Good | 21.13
5 | 4 | 680116 | 3FT STANDARD POWER CORD - IEC C13 TYPE | On Hand | Good | 0
5 | 5 | 7310629 | Aruba 2530 Retail Switch | On Hand | Good | 410
1 | TW675879OG3 | 7310629 | Aruba 2530 Retail Switch | On Hand | Good | 410
Spreadsheet: 226098d1365246018-dependant-lists-20130406-three-tier-list-rjg_universal_dd_dependent
Sheet: Data Entry

Region | Country | Area | City
APAC | India
APAC | China
Europe | UK | Wales | Cardiff
Americas | US | Washington | Seattle
Europe | UK | England | Southampton
MEA | South Africa
Americas | Canada | Ontario | Toronto
Europe | UK | England | Birmingham
Americas | Canada | Ontario | [NAME]
 |  |  |  |  |  | Implementation Notes
 |  |  |  |  |  | 1 | The sheet called Lists contains all of the data for the validation lists
Source: =Master |  |  |  |  |  | 2 | There are only 4 named ranges for the dropdown lists named ValData, [NAME], UseList and Master
 |  | Validation Formula using RELATIVE reference |  |  |  | 3 | The [NAME] called ValData has been set as =Lists!$A$2:INDEX(Lists!$1:$100,100,COUNTA(Lists!$1:$1))
 |  | Source: |  |  |  |  | The choice of 100 for the number of rows is arbitrary. It can be whatever length you like as long as it
 |  |  |  |  |  |  | exceeds the likely number of values you will have in any one Data Validation list.
 |  |  |  |  |  | 4 | All the cells in the Yellow shaded area use the Named range Master
 |  |  |  |  |  |  | Master   =Lists!$A$2:INDEX(Lists!$A:$A,COUNTA(Lists!$A:$A))
 |  |  |  |  |  | 5 | For the next 2 ranges, it is essential to place your cursor in Row 2 of Data Entry when creating.
 |  |  |  |  |  | 6 | Counter has the formula    =COUNTA(INDEX(ValData,,MATCH('Data Entry'!A2,Lists!$1:$1,0)))
 |  |  |  |  |  |  | Place cursor in cell B2 of Sheet data Entry when creating
 |  |  |  |  |  |  | This means it will change relative to the column being used, making the dropdowns of the appropriate length.
 |  |  |  |  |  | 7 | All cells in the Blue shaded area have the same validation formula, as shown at left - UseList
 |  |  |  |  |  |  | UseList has the formula
 |  |  |  |  |  |  | Place cursor in cell B2 of Sheet data Entry when creating
 |  |  |  |  |  |  | It is a dynamic range that matches the column with the entry in the cell to the left.
 |  |  |  |  |  |  | When viewed in cell C4 it would therefore take the form
 |  |  |  |  |  | 8 | Any number of entries can be added to the validation lists on sheet Lists and they will automatically be included.
 |  |  |  |  |  | 9 | Any future columns can be added to Lists without having to set up any further names. Just apply DV to the relevant column
 |  |  |  |  |  |  | on Data Entry by using Copy>Paste Special>Validation from any other DV area.
Spreadsheet: 64908d1265730313-look-up-and-match-several-values-to-include-entry-solution
Sheet: Sheet1

Company | Quarter | Year | Industry | Lookup
Company B | Q1 | 2009 | Administration | not_ok
Company D | Q2 | 2009 | Transportation and logistics | not_ok
Company C | Q3 | 2009 | Production | not_ok
Company A | Q1 | 2009 | Administration | ok
Company A | Q2 | 2009 | Administration | ok
Company A | Q3 | 2009 | Administration | ok
Company A | Q4 | 2009 | Administration | ok
Company B | Q2 | 2010 | Construction | not_ok
Company C | Q4 | 2010 | Health | not_ok
Only valid entries in the above list are: |  |  |  |  | _validation_string
Company A | Q1 | 2009 | Administration | OK | Company A:Q1:2009:Administration
Company A | Q2 | 2009 | Administration | OK | Company A:Q2:2009:Administration
Company A | Q3 | 2009 | Administration | OK | Company A:Q3:2009:Administration
Company A | Q4 | 2009 | Administration | OK | Company A:Q4:2009:Administration
Spreadsheet: 730876d1620014392-categorize-items-based-on-free-text-counting-matching-terms-amohannadi-
Sheet: FreeText

 |  |  |  |  | PC | PC | PC | PC | PC | PC | PC | Playstation | Playstation | Playstation | Playstation | Playstation | Playstation | Headset | Headset | Headset | Printer | Printer | PC | Playstation | Headset | Printer
 |  | FreeText | Category | [NAME] should be | [NAME] | Keyboard | Windows | Monitor | Update | Bluescreen | PC | Update | Disk | Game | Monitor | Lag | [NAME] | Voice | Mic | Noice | Color | Ink
 |  | My pc monitor has some issues, I think it is require an update |  | PC
 |  | I think I need to update my machine as the disk is not working |  | Playstation
 |  | printing is not prining the color why |  | Printer
 |  | how to update my pc? |  | PC
 | Tricky | I cannot update my machine |  | PC to the fact that most most records with one category work catecorized with PC
Spreadsheet: 749160d1632547485-display-list-of-new-or-updated-rows-in-a-list-update
Sheet: Result

Title | PartID | Location | Price | Image [image] | Image2 [image2] | Image3 [image3] | Description | Quantity | Category
Spreadsheet: 831444d1685634418-date-what-is-the-5th-tuesday-from-a-date-s666-pq-date-what-is-the-5th-tuesday-from-a-date
Sheet: TicketOfWorks (1)

Submitted to QC | RCTI | Date RCTI Generated | First Tuesday  28 days after C2 | Ticket Reference No | STOW ID | STOW Status | Suburb | Region Name | Design $ Value | Approved $ [NAME] | Completed $ Value | Invoice $ Value
2023-04-26 00:00:00 | N2PRCTI118376 | 2023-05-15 00:00:00 | 2023-06-13 00:00:00 | 4TQA-26-01-CIVILS_04 | 51869587 | RCTI_GENERATED | Hervey Bay | N2P-QLD Regional North |  |  |  | 61900
2023-05-10 00:00:00 | N2PRCTI118376 | 2023-05-15 00:00:00 | 2023-06-13 00:00:00 | 4TQA-26-01-CIVILS_05 | 51889431 | RCTI_GENERATED | Hervey Bay | N2P-QLD Regional North |  |  |  | 22018
2023-05-22 00:00:00 | N2PRCTI119123 | 2023-05-26 00:00:00 | 2023-06-27 00:00:00 | 4TQA-26-03-CIVILS_04 | 51887137 | RCTI_GENERATED | Hervey Bay | N2P-QLD Regional North | 17611.2 | 45930 | 45930 | 45930
2023-05-22 00:00:00 | N2PRCTI119123 | 2023-05-26 00:00:00 | 2023-06-27 00:00:00 | 4BBE-01-10-CIVILS_01 | 51942458 | RCTI_GENERATED | Bundaberg | N2P-QLD Regional North | 8092.8 | 8092.8 | 21150 | 21150
2023-05-22 00:00:00 | N2PRCTI119123 | 2023-05-26 00:00:00 | 2023-06-27 00:00:00 | 4BBE-01-12-CIVILS_01 | 51942462 | RCTI_GENERATED | Bundaberg | N2P-QLD Regional North | 20455.2 | 20455.2 | 32670 | 32422
2023-05-22 00:00:00 | N2PRCTI119123 | 2023-05-26 00:00:00 | 2023-06-27 00:00:00 | 4BBE-01-01-CIVILS | 51941893 | RCTI_GENERATED | Bundaberg | N2P-QLD Regional North | 7963.2 | 7963.2 | 6000 | 6000
2023-05-22 00:00:00 | N2PRCTI119123 | 2023-05-26 00:00:00 | 2023-06-27 00:00:00 | A-4TQA-20-19-CIVILS | 51959386 | RCTI_GENERATED | Hervey Bay | N2P-QLD Regional North | 13824 | 13824 | 6240 | 6240
2023-05-22 00:00:00 | N2PRCTI119123 | 2023-05-26 00:00:00 | 2023-06-27 00:00:00 | 4TQA-26-03-CIVILS_06 | 51962958 | RCTI_GENERATED | Hervey Bay | N2P-QLD Regional North | 6300 | 6300 | 17445 | 17445
2023-05-11 00:00:00 | N2PRCTI119124 | 2023-05-26 00:00:00 | 2023-06-27 00:00:00 | 4TQA-26-03-MOB_01 | 51946744 | RCTI_GENERATED | Hervey Bay | N2P-QLD Regional North | 4000 | 4000 | 4000 | 4000
2023-05-22 00:00:00 | N2PRCTI119124 | 2023-05-26 00:00:00 | 2023-06-27 00:00:00 | 4BBE-01 - Mob and LAFHA (Ausconnect) | 51976047 | RCTI_GENERATED | Bundaberg | N2P-QLD Regional North | 5120 | 5120 | 5120 | 5120
2023-05-31 00:00:00 |  |  |  | A-4TQA-20-19-CIVILS_02 | 52013781 | Submittd for QC | Hervey Bay | N2P-QLD Regional North | 2664 | 2664 | 4560
 |  |  |  | A-4TQA-20-18-CIVILS | 51959478 | Work Order In Progress | Hervey Bay | N2P-QLD Regional North | 48202.8 | 48202.8
 |  |  |  | A-4TQA-20-04-CIVILS | 51979633 | Work Order In Progress | Hervey Bay | N2P-QLD Regional North | 44625.6 | 44625.6
Spreadsheet: 51509d1251181385-multiple-ifs-test1
Sheet: Sheet1

Nr. crt. | Nume | Prenume | Ore lucrate | Ore suplimentare | Total ore | Observatii
1 | vbmh | Adrian |  | 00:12:00 | 00:00:00 |  |  |  |  |  |  |  |  |  |  | Adrian, Costan | 10:45:00 | 00:12:00
2 |  | Alexandru |  | 00:00:00 | 00:00:00 |  |  |  |  |  |  |  |  |  |  | Alexandru, [NAME] | 01:35:00 | 00:03:00
3 |  | Bogdan |  | 00:00:00 | 00:00:00 |  |  |  |  |  |  |  |  |  |  | [NAME], Matei | 08:12:00
4 |  | Constantin |  | 00:00:00 | 00:00:00 |  |  |  |  |  |  |  |  |  |  | Constantin, Gheorghe | 08:28:00
5 | bnjk | Cornel Iosif |  | 00:06:00 | 00:06:00 |  |  |  |  |  |  |  |  |  |  | Cornel Iosif, Gabor | 09:00:00 | 00:06:00
Spreadsheet: 788725d1658667012-what-is-the-error-in-the-formula-of-cell-a5-of-the-attached-file-book2error
Sheet: Sheet1

 | 2
الأول | 1
الثاني | 2
[NAME] | 3
الرابع | 4
الخامس | 5
السادس | 6
السابع | 7
[NAME] | 8
التاسع | 9
[NAME] | 10
الحادي عشر | 11
الثاني عشر | 12
[NAME] عشر | 13
الرابع عشر | 14
الخامس عشر | 15
السادس عشر | 16
السابع عشر | 17
[NAME] | 18
التاسع عشر | 19
العشرون | 20
الحادي والعشرون | 21
الثاني والعشرون | 22
[NAME] والعشرون | 23
[NAME] والعشرون | 24
الخامس والعشرون | 25
السادس والعشرون | 26
السابع والعشرون | 27
[NAME] والعشرون | 28
التاسع والعشرون | 29
الثلاثون | 30
الحادي والثلاثون | 31
الثاني والثلاثون | 32
[NAME] والثلاثون | 33
[NAME] | 34
الخامس والثلاثون | 35
السادس والثلاثون | 36
السابع والثلاثون | 37
[NAME] | 38
التاسع والثلاثون | 39
الاربعون | 40
الحادي والاربعون | 41
الثاني والاربعون | 42
الثالث والاربعون | 43
الرابع والاربعون | 44
الخامس والاربعون | 45
السادس والاربعون | 46
السابع والاربعون | 47
[NAME] والاربعون | 48
التاسع والاربعون | 49
الخمسون | 50
الحادي والخمسون | 51
الثاني والخمسون | 52
[NAME] والخمسون | 53
الرابع والخمسون | 54
الخامس والخمسون | 55
السادس والخمسون | 56
السابع والخمسون | 57
[NAME] والخمسون | 58
التاسع والخمسون | 59
الستون | 60
الحادي والستون | 61
الثاني والستون | 62
الثالث والستون | 63
الرابع والستون | 64
الخامس والستون | 65
السادس والستون | 66
السابع والستون | 67
[NAME] والستون | 68
التاسع والستون | 69
السبعون | 70
Spreadsheet: 836935d1689738394-calculate-formula-from-pivot-table-formula-pivot
Sheet: Sheet5

This table is from Pivot Table
Sum of GP | Accounting Month2 | Accounting Month
Company name | Previous 6 month | Current 6 month | Status |  |  |  |  | Previous 6 month | Current 6 month
AA |  | 156 |  |  | result need show |  | New | blank | have number both + and -
BBB | 78 | 156 |  |  |  |  |  | 0 | have number both + and -
CCC | 78 | 156 |  |  |  |  | Existing | have number both + and - | have number both + and -
DDD | 512 | 156 |  |  |  |  |  | have number both + and - | 0
aaa |  |  |  |  |  |  |  | have number both + and - | blank
[NAME] | 512 |  |  | should be Existing |  |  | other show "-" | 0 | 0
[NAME] | 512 | 0 |  | should be Existing |  |  |  | 0 | blank
[NAME] | 0 | 0 |  |  |  |  |  | blank | 0
[NAME] | 0 | 222 |  | should be New |  |  |  | blank | blank
[NAME] | -100 | -200
[NAME] | -100 |  |  | should be Existing
[NAME] | -200 | 0 |  | should be Existing
Grand Total | 668 | 624
Spreadsheet: jeffrey_a_shankman__14004__Stranded Cost Analysis Structuring Confidential
Sheet: Gas Deals

Mark to Market - CDWR tolling contracts based on 7/19/01 ENE Curves
(Compares Capacity Payments * Demand Charge Divisors)
 | GWF | NP 15
 | Original Contract | 529795465
 | Current Premium | 97456275
 | Out of Money | 432339191
 | Calpine
 | Original Contract | 137602623.626285
 | Current Premium | 31003636.6694445
 | Out of Money | 106598986.95684
 | Dynegy
 | Original Contract | 585585796.565842
 | Current Premium | 114468479.503952
 | Out of Money | 471117317.061889
 | Coral
 | Original Contract | 1136814326.84415
 | Current Premium | 304003361.073894
 | Out of Money | 832810965.770252
 | Sunrise
 | Original Contract | 704385817.689348
 | Current Premium | 152491409.613443
 | Out of Money | 551894408.075905
 | Total Gas Contracts (PV Dollars)
 | Original Contract
 | Current Premium
 | Out of Money
Spreadsheet: 867857d1714643260-formula-to-distribute-inventory-to-stores-distribution-example
Sheet: Sheet1

Example A
Distribution Qty | Send multiple |  | Store A | Store B | Store C | Store D | Store E | Store F | Store H | Store I | Store J | Store K
6 | 1
Example B
Distribution Qty | Send multiple |  | Store A | Store B | Store C | Store D | Store E | Store F | Store H | Store I | Store J | Store K
15 | 3
Spreadsheet: 01e4b84c-97e3-4113-ae6f-5472be7e2298
Sheet: Subject TOTALS

FTES = Full Time Equiv. Student (525 contact hrs.) | FTES (1)
 | MSJC MVC Total
Academic Year | AY07-08 |  |  | AY08-09 |  |  | [NAME] |  |  | AY10-11 |  |  | AY11-12 |  |  | AY12-13
Credit
Non Credit
Total
% Chg. vs. [NAME]. Ago
Terms | SU07 | FA07 | SP08 | SU08 | FA08 | SP09 | SU09 | FA09 | SP10 | SU10 | FA10 | SP11 | SU11 | FA11 | SP12 | SU12 | FA12 | SP13
Credit
Non Credit
Total
% Chg. vs. [NAME]. Ago
(1) Non-Residence FTES is not included in calculation.
FTES = Full Time Equiv. Student (525 contact hrs.) | CREDIT FTES (1)
 | MSJC MVC Total by Subject
[To view course data click on Subject Name below] | AY07-08 |  |  | AY08-09 |  |  | [NAME] |  |  | AY10-11 |  |  | AY11-12
Subject | SU07 | FA07 | SP08 | SU08 | FA08 | SP09 | SU09 | FA09 | SP10 | SU10 | FA10 | SP11 | SU11 | FA11 | SP12 | SU12 | FA12 | SP13
Accounting
Alcohol/Drug Studies
Allied Health
Administration of Justice
Anatomy & Physiology
Anthropology
Art
American Sign Language
Astronomy
Audio Technology
Automotive/Transportation
Business Administration
Biology
Computer Applications
Childhood Development & Education
Chemistry
Communication
Corrections
Computer Science/Informations Systems
Dance
Diagnostic Medical Sonography
Economics
Education/Teacher Preparation
English
Engineering
Environment Science
Earth Science
English as a Second Language
Fire Technology
French
Geography
Geology
Gerontology
Guidance
Honors Enrichment Program
History
Horticulture
Health Science
Humanities
LEAD
Legal Assistant
[NAME]
[NAME]
Mathematics
Management/Supervision
Multimedia
Music
Networking
Nursing
Nutrition
Occupational Internship
Office Technology
Physical Education
PEIC
Philosophy
Photography
Physics
Portuguese
Political Science
Psychology
Real Estate
Reading
Sustainable Energy Management
Sociology
Spanish
Teaching Assistant
Theater Arts
Viticulture and Enology
Water Technology
(1)  excludes dual enrollment or non-resident data
FTES = Full Time Equiv. Student (525 contact hrs.) | NON-CREDIT FTES
 | MSJC MVC Total by Subject
 | AY07-08 |  |  | AY08-09 |  |  | [NAME] |  |  | AY10-11 |  |  | AY11-12
Subject | SU07 | FA07 | SP08 | SU08 | FA08 | SP09 | SU09 | FA09 | SP10 | SU10 | FA10 | SP11 | SU11 | FA11 | SP12 | SU12 | FA12 | SP13
NON-CREDIT COURSES
% Chg. vs. [NAME]. Ago |  |  |  |  |  |  |  |  |  | - |  |  | - |  |  | -
Note: district totals exclude dual enrollment data
(1) Non-Residence FTES is not included in calculation.
Spreadsheet: a58f7092-fc6f-4025-b6d2-fdcac8a1bae1
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SNOWSHOE | T1 | SKATE | T2 | SKI | POSITION | TOTAL TIME
8779 | 55465 | Fabio | Barsi | ITA | 141 | 00:16:40 | 00:00:47 | [NAME] | 00:01:21 | 00:19:40 | 1 | 01:02:37
8779 | 69383 | Simone | Ripamonti | ITA | 142 | 00:17:53 | 00:00:28 | 00:32:59 | 00:01:26 | [NAME] | 2 | 01:11:01
Spreadsheet: 85858d1285874675-identifiying-dup-values-in-column-and-retrieve-oldest-date-in-dup-values-row-xr_254
Sheet: Sheet6

[NAME] as needed
 | Currency Type: AUD
 | Date : 29/09/10 AUD
 | UBS AG LDN 103310IL JL046
 | FX OPTION TFSEC_020340
 | UBS AG LDN 103311IL JL028
 | FX OPTION TFSEC_020340
 | UBS AG LDN 103312IL JL024
 | FX OPTION TFSEC_020340
 | UBS AG LDN 103313IL JL033
 | FX OPTION TFSEC_020340
 | UBS AG LDN 103314IL JL037
 | FX OPTION TFSEC_020340
Spreadsheet: 84956d1285055765-sum-with-counta-and-countif-with-many-matching-criteria-example
Sheet: Sheet1

 |  | Actual | Capacity | Actual | Capacity
 |  | Doc |  | Happy
Week 35 | 2010-08-30 00:00:00 | 0.95 | 0.7 | 0.88 | 0.6
 | 2010-08-31 00:00:00 | 0.92 | 0.65 | 0.67 | 0.5
 | 2010-09-01 00:00:00 | 0.87 | 0.75 | 0.72 | 0.59
 | 2010-09-02 00:00:00 | 0.98 | 0.8 | 0.62 | 0.48
 | 2010-09-03 00:00:00 | 0.99 | 0.82 | 0.8 | 0.78
 | 2010-09-04 00:00:00 | N/A | 0 | N/A | 0
 | 2010-09-05 00:00:00 | N/A | 0 | N/A | 0
Week 36 | 2010-09-06 00:00:00 | 0.85 | 0.71 | 0.8 | 0.72
 | 2010-09-07 00:00:00 | 0.87 | 0.65 | 0.85 | 0.75
 | 2010-09-08 00:00:00 | 0.95 | 0.8 | 0.89 | 0.78
 | 2010-09-09 00:00:00 | 0.93 | 0.82 | 0.9 | 0.79
 | 2010-09-10 00:00:00 | 0.89 | 0.69 | 0.95 | 0.82
 | 2010-09-11 00:00:00 | N/A | 0 | 0.95 | 0.88
 | 2010-09-12 00:00:00 | N/A | 0 | N/A | 0
 |  |  |  |  |  | Based on sum all percentages devided by sum(counta all cells within a week minus countif all N/A within a week) in Actual column
Actual | Week 35 | Week 36
Doc | 0.942 | 0.898 |  |  |  | based on sum all percentages within a week but Monday to Friday devided by 5 in capacity column
Happy | 0.7380000000000001 | 0.89
5 Days
Doc | 0.744 | 0.734 |  |  |  | Based on sum all percentages within a week but Monday to Sunday devided by 7 in capacity column
Happy | 0.5900000000000001 | 0.772
7 Days
Doc | 0.5314285714285715 | 0.5242857142857142
Happy | 0.4214285714285714 | 0.6771428571428572
Spreadsheet: 138619d1327768574-excel-2007-performing-calculations-in-cells-2012-income
Sheet: last sept

2011-09-26 00:00:00
0 |  | yes | Amount | Taxable Merch | Shipping Taxable | Sales Tax Payable | Non- taxable Merch | Shipping Non-Taxable | Income Tax Income | MiscellaneousNon- Taxable | Owner Loan
Received From | Check No | Invoices Paid | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: a40aff3d-4d5b-40c9-9e41-c4f7cde9dc3c
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
2. | CUSTOS COM PESSOAL
 | PERSONNEL EXPENDITURE
2.1 | Salário directo | 47264 | 1412551
 | Direct salary
2.1.1 | Salário base | 37815 | 1193223
 | Basic salary
2.1.2 | Subsídios e prémios regulares | 9449 | 219328
 | Regular subsidies and bonuses
2.2 | Subsídios e prémios irregulares | 6747 | 258635
 | Occasional subsidies and bonuses
2.3 | Pagamentos em géneros | 0 | 0
 | Payment in kind
2.4 | Encargos legais, convencionais e facultativos a cargo da entidade empregadora | 1026 | 253792
 | Legal, contractual and optional charges borne by the employer
2.5 | Outros custos de carácter social | 0 | 3360
 | Regular subsidies and bonuses
2.6 | Custos com a formação profissional | 1799 | 100101
 | Personnel training expenditure
2.7 | [NAME] custos com pessoal | 1424 | 95960
 | Other personnel expenditure
2.8 | Total | 58260 | 2124399
 |  |  | Valor em Contos
 |  |  | In PTE 1.000
 |  |  |  |  |  |  | 5.02
 |  |  |  |  |  |  | 2.57