tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 883646d1732284635-merging-in-out-with-absent-dates-into-a-single-pivot-table-formula-power-query-sample-emp-waqas-gul-
Sheet: Sheet1

First Table |  |  |  |  |  |  | Second Table
Employee | Date | Time | Status | Column1 |  |  | Employee | 1/1/2024 | 1/2/2024 | 1/3/2024
1 | 2024-01-01 00:00:00 | 08:13:00 | IN |  |  |  | 1 |  |  | A |  |  |  | below is the table like what I love to extract from the 2 data tables (Excel or Power Query)
1 | 2024-01-01 00:00:00 | 18:19:00 | OUT |  |  |  | 2 |  | CL
1 | 2024-01-02 00:00:00 | 08:05:00 | IN |  |  |  | 3 | AL |  |  |  |  |  |  | 2024-01-01 00:00:00 |  | 2024-01-02 00:00:00 |  | 2024-01-03 00:00:00
1 | 2024-01-02 00:00:00 | 17:10:00 | OUT |  |  |  |  |  |  |  |  |  |  | Employee Emp | IN | OUT | IN | OUT | IN | OUT
2 | 2024-01-01 00:00:00 | 08:00:00 | IN |  |  |  |  |  |  |  |  |  |  | 1 | 08:00:00 | 17:00:00 | 08:00:00 | 17:00:00 | AL | AL
2 | 2024-01-01 00:00:00 | 17:00:00 | OUT |  |  |  |  |  |  |  |  |  |  | 2 | 08:00:00 | 17:00:00 | CL | CL | 08:00:00 | 17:00:00
2 | 2024-01-03 00:00:00 | 08:00:00 | IN |  |  |  |  |  |  |  |  |  |  | 3 | A | A | 08:00:00 | 17:00:00 | 08:00:00 | 17:00:00
2 | 2024-01-03 00:00:00 | 08:12:00 | IN
2 | 2024-01-03 00:00:00 | 17:00:00 | OUT |  |  |  | Time Text | Date | Status
3 | 2024-01-02 00:00:00 | 08:00:00 | IN |  |  |  |  | 2024-01-01 00:00:00 |  | 2024-01-02 00:00:00 |  | 2024-01-03 00:00:00 |  | 2024-02-01 00:00:00 |  | 2024-02-02 00:00:00 |  | 2024-02-03 00:00:00 |  | 2024-03-02 00:00:00
3 | 2024-01-02 00:00:00 | 17:00:00 | OUT |  |  |  | Employee | IN | OUT | IN | OUT | IN | OUT | IN | OUT | IN | OUT | IN | OUT | IN
3 | 2024-01-02 00:00:00 | 18:22:00 | OUT |  |  |  | 1 | 08:13 AM | 06:19 PM | 08:05 AM | 05:10 PM | A |  | 08:00 AM | 05:00 PM |  | 05:00 PM |  |  | 08:00 AM
3 | 2024-01-03 00:00:00 | 08:00:00 | IN |  |  |  | 2 | 08:00 AM | 05:00 PM | CL |  | 08:00 AM, 08:11 AM | 05:00 PM | 08:00 AM | 05:00 PM |  |  | 08:00 AM | 05:00 PM
3 | 2024-01-03 00:00:00 | 17:00:00 | OUT |  |  |  | 3 | AL |  | 08:00 AM | 05:00 PM, 06:22 PM | 08:00 AM | 05:00 PM |  |  | 08:00 AM | 05:00 PM | 08:00 AM | 05:00 PM
1 | 2024-02-01 00:00:00 | 08:00:00 | IN |  |  |  |  |  |  |  | 6:22 PM be here | 8:11 AM here
1 | 2024-02-01 00:00:00 | 17:00:00 | OUT
1 | 2024-03-02 00:00:00 | 08:00:00 | IN
1 | 2024-02-02 00:00:00 | 17:00:00 | OUT
2 | 2024-02-01 00:00:00 | 08:00:00 | IN
2 | 2024-02-01 00:00:00 | 17:00:00 | OUT
2 | 2024-02-03 00:00:00 | 08:00:00 | IN
2 | 2024-02-03 00:00:00 | 17:00:00 | OUT
3 | 2024-02-02 00:00:00 | 08:00:00 | IN
3 | 2024-02-02 00:00:00 | 17:00:00 | OUT
3 | 2024-02-03 00:00:00 | 08:00:00 | IN
3 | 2024-02-03 00:00:00 | 17:00:00 | OUT
Spreadsheet: 782348d1653998520-showing-icon-base-on-minimum-values-from-current-values-available-in-column-conditional-formating-for-min-value-icon-set-formula-aligw
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  | 112 |  | 112
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 100 |  | 100
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 200 |  | 200
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 400 |  | 400
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 500 |  | 500
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 100 |  | 100
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 109 |  | 109
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 104 |  | 104
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 660 |  | 660
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 99 |  | 99
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 876 |  | 876
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 98 |  | 98
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 654 |  | 654
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 89 |  | 89
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 90 |  | 90
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 112 |  | 112
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 100 |  | 100
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 200 |  | 200
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 400 |  | 400
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 500 |  | 500
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 100 |  | 100
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 109 |  | 109
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 104 |  | 104
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 660 |  | 660
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 99 |  | 99
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 876 |  | 876
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 98 |  | 98
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 654 |  | 654
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 89 |  | 89
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 90 |  | 90
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
Spreadsheet: jeff_dasovich__14098__Residential implicit commodity charge
Sheet: Sheet1

SDG&E Residential Rates for Consumption of 500 kWh or Less
SDG&E
Advice Letter |  | 1205-E |  | 1237-E |  | 1205-E |  | 1235-E |  | 1235-E
Effective Begin Date |  | 2000-06-01 00:00:00 |  | 2000-08-01 00:00:00 |  | 2000-10-01 00:00:00 |  | 2000-11-01 00:00:00 |  | 2001-02-01 00:00:00
[NAME] | 0.54 | 5.85 |  | 2.04 |  |  |  | 6.77 |  | 6.77
[NAME] | 0.46 | 7.86 |  | 4.05 |  |  |  | 8.77 |  | 8.77
[NAME]
[NAME]
Implicit Commodity *
Residential Rate Schedule | DR | DRLI | DM | DS | DS LI | DT | [NAME] | Total Res
Tier 1 | 2845 | 386 | 47 | 12 | 2 | 92 | 17
[NAME] | 2673 | 158 | 36 | 1 | 0 | 34 | 6
Total
Tier 1
[NAME]
* The implicit commodity includes all energy and procurement costs ( all PX charges, ancillary services, and utility procurement costs)
Spreadsheet: 129468d1321627384-removing-everything-from-a-column-excluding-numbers-book1
Sheet: Sheet1

 | ref no. | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 | 6574893028
 | 5941029549
 | 5461092539
 | 6549267891
 | 5430981235
 | [PHONE]/hghd
 | [PHONE]-hgjt
 | [PHONE]-jglo
 | [PHONE]/rwtq
 | [PHONE]/oypt
 | [PHONE]/ppty
 | [PHONE]-thfj
 | [PHONE]/yghf
 | 8864734501
 | 7761209843
 | 6541098234
 | 8100294392
 | [PHONE]-rehl
 | [PHONE]/klsa
 | [PHONE]/wwqo
 | werd-[PHONE]
Spreadsheet: 766488d1643904997-vba-compare-copy-and-delete-list-text-from-different-sheets-bendt-skov-
Sheet: Total

Company A | Street | PO | City | Country | Phone | Mail | www | Text
Company B | Street | PO | City | Country | Phone | Mail | www | Text
Company C | Street | PO | City | Country | Phone | Mail | www | Text
Company D | Street | PO | City | Country | Phone | Mail | www | Text
Company E | Street | PO | City | Country | Phone | Mail | www | Text
Company F | Street | PO | City | Country | Phone | Mail | www | Text
Company G | Street | PO | City | Country | Phone | Mail | www | Text
Company H | Street | PO | City | Country | Phone | Mail | www | Text
Company I | Street | PO | City | Country | Phone | Mail | www | Text
Company J | Street | PO | City | Country | Phone | Mail | www | Text
Company P | Street | PO | City | Country | Phone | Mail | www | Text
Company Q | Street | PO | City | Country | Phone | Mail | www | Text
Company R | Street | PO | City | Country | Phone | Mail | www | Text
Company S | Street | PO | City | Country | Phone | Mail | www | Text
Company T | Street | PO | City | Country | Phone | Mail | www | Text
Spreadsheet: 1c238db8-173c-498c-9563-f4eb6bbf25d2
Sheet: 9a

Product1 | Cleared2 | Uncleared | TOTAL
Fixed-Float | 2063324 | 217953 | 2281277
FRA | 814987 | 31294 | 846281
OIS | 252345 | 142157 | 394502
OTHER* | 90011 | 236490 | 326502
TOTAL
*OTHER variable includes the following products: Basis, Cap/Floor, Debt Option, Exotic, Fixed-Fixed, Inflation, and Swaption.
Spreadsheet: 220216d1363100190-conditonal-formatting-question-survival-kit-list-sample
Sheet: Kit Inventory

 | KIT # |  | 001A |  | 002A |  | 003A |  | 004A |  | 005A |  | 006A |  | 007A |  | 008A |  | 009A |  | 010A |  |  | TOTALS
 | DATE LAST CHECKED/INVENTORIED |  | 2012-03-01 00:00:00 | Expiration Dates (Dates occuring this month shown in red. Next month shown in yellow |  | Expiration Dates |  | Expiration Dates |  | Expiration Dates |  | Expiration Dates |  | Expiration Dates |  | Expiration Dates |  | Expiration Dates |  | Expiration Dates |  | Expiration Dates
 | 1 | Backpack | 1 | [NAME]/dd/yyyy | 1 | [NAME]/dd/yyyy | 1 | [NAME]/dd/yyyy | 1 | [NAME]/dd/yyyy |  | [NAME]/dd/yyyy |  | [NAME]/dd/yyyy |  | [NAME]/dd/yyyy |  | [NAME]/dd/yyyy |  | [NAME]/dd/yyyy | 1 | [NAME]/dd/yyyy
 | First Aid & Prevention:
 | 1 | [NAME] (Adventure Medical) |  |  | 1 |  | 1 |  | 1
 | 1 | [NAME] |  |  | 1 |  | 1 |  | 2
 | 1 | Sunscreen |  |  | 1 |  | 0 |  | 0
 | 1 | 100% [NAME] or Other Insect Repellant |  |  | 1 |  | 1 |  | 2
 | Shelter:
 | 2 | Emergency Blankets |  |  | 2 |  | 2 |  | 2
 | 1 | Roll of Parachute [NAME] (550 [NAME]) or Other Rope |  |  | 1 |  | 1 |  | 1
 | 2 | Ponchos |  |  | 2 |  | 2 |  | 1
 | 1 | Tube Tent |  |  | 1 |  | 0 |  | 0
 | 2 | Pairs of Gloves |  |  | 2 |  | 2 |  | 2
 | 1 | Bandana |  |  | 1 |  | 1 |  | 1
 | Fire, Heat, & Light:
 | 1 | Led Flashlight |  |  | 1 |  | 0 |  | 0
 | 1 | Flint Fire Starter (with [NAME]) |  |  | 1 |  | 1 |  | 1
 | 1 | Waterproof Drum for Matches |  |  | 1 |  | 1 |  | 1
 | 1 | Box of Waterproof Matches |  |  | 1 |  | 1 |  | 1
 | 2 | Candles |  |  | 2 |  | 2 |  | 1
 | 1 | Lighter |  |  | 1 |  | 1 |  | 1
 | 4 | [NAME] (in plastic bag with expiration date noted) |  |  | 4 |  | 0 |  | 0
 | 2 | [NAME] |  |  | 2 |  | 0 |  | 0
 | 5 | Tinder-Quik Tabs or Other Fire-Starting Aid |  |  | 5 |  | 4 |  | 5
 | Food & Water:
 | 2 | Cans of Sterno Fuel |  |  | 2 |  | 2 |  | 2
 | 1 | Pack of Potable Aqua Tabs |  |  | 1 |  | 0 |  | 1
 | 2 | Nalgene Wide Mouthed Polycarb Bottles 32oz |  |  | 2 |  | 0 |  | 2
 | 2 | Sets of Stainless Steel Utensils |  |  | 2 |  | 0 |  | 1
 | 1 | Fresh-water [NAME] |  |  | 1 |  | 1 |  | 1
 | 2 | Bottles of Water or 12 Water Rations |  |  | 2 |  | 0 |  | 1 | 2013-10-22 00:00:00
 | 2 | Food Rations |  |  | 2 |  | 0 |  | 0
 | 1 | Fold-A-Stove or Stainless Steel Canteen Cup |  |  | 1 |  | 1 |  | 1
 | Signaling:
 | 1 | Signal Mirror |  |  | 1 |  | 1 |  | 1
 | 1 | Emergency Whistle |  |  | 1 |  | 1 |  | 1
 | 1 | Large Sheet of Aluminum Foil |  |  | 1 |  | 0 |  | 1
 | 3 | Flares |  |  | 3 |  | 3 |  | 3
 | Tool & Utility:
 | 1 | Multi-tool |  |  | 1 |  | 0 |  | 1
 | 1 | K-Bar Knife or Gerber Prodigy Survival Knife |  |  | 1 |  | 1 |  | 1
 | 1 | Toilet Paper Roll (or 2 Camping Toilet Paper Rolls) |  |  | 1 |  | 1 |  | 1
 | 1 | Survival Manual |  |  | 1 |  | 1 |  | 1
 | 1 | Roll Duct Tape 2" |  |  | 1 |  | 0 |  | 0
 | 1 | Hatchet, Folding Shovel, or Machette |  |  | 1 |  | 1 |  | 1
 | 1 | Roll of Small Gauge Wire |  |  | 1 |  | 1 |  | 1
 | 1 | Compass |  |  | 1 |  | 1 |  | 1
 | 1 | Permant [NAME] |  |  | 1 |  | 1 |  | 1
Spreadsheet: 784441d1655736255-how-to-add-month-by-month-to-get-ytd-using-getpivotdata-in-google-sheet-how-to-sum-vlookup
Sheet: Unit volumns 

 | Current formalar
 | IFERROR((GETPIVOTDATA($AI$7,$V$7,$V$7,B6))/(VLOOKUP to price list
 | Product name | SUM of April | SUM of May | SUM of June | SUM of July | SUM of Aug | SUM of Sept | SUM of Oct | SUM of Nov | SUM of Dec | SUM of Jan | SUM of Feb | SUM of March | SUM of TOTAL |  |  |  | Row Labels | Sum of SUM of April | Sum of SUM of May | Sum of SUM of June | Sum of SUM of July | Sum of SUM of Aug | Sum of SUM of Sept | Sum of SUM of Oct | Sum of SUM of Nov | Sum of SUM of Dec | Sum of SUM of Jan | Sum of SUM of Feb | Sum of SUM of March
 | Product 1 | 12998 | 10097 | 12213 | 11233 | 10702 | 11302 | 10528 | 9578 | 11747 | 13097 | 13315 | 12638 |  |  |  |  | Product 1 | 84840 | 59800 | 149720 | 154700 | 163480 | 201180 | 240900 | 271920 | 251520 | 233640 | 432660 | 491140
 | Product 2 | 12212 | 11940 | 11459 | 12390 | 13108 | 9590 | 12611 | 10480 | 11558 | 10421 | 11989 | 13107 |  |  |  |  | Product 2 | 83380 | 69680 | 319220 | 530460 | 610780 | 687040 | 740580 | 790860 | 701240 | 797440 | 945660 | 1079580
 | Product 3 | 10642 | 9546 | 9851 | 10453 | 9593 | 11153 | 13128 | 12034 | 10333 | 9719 | 11039 | 10206 |  |  |  |  | Product 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total | 168220 | 129480 | 468940 | 685160 | 774260 | 888220 | 981480 | 1062780 | 952760 | 1031080 | 1378320 | 1570720
 | Requirement please
 | How can I wrap sum into getpivitdata to add April and May so I have amy Ytd costs
 | How to find Unit sales
 |  | Unit sales
 | Product 1 |  | manual approach-assuming I have to do this from June to March 23, I'll be adding every month
 | Product 2 |  | How can I wrap sum into getpivotdata so I'll be expanding the range each month
 | Product 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | $AI$7, = | SUM of TOTAL on the original file
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | $V$7,$V$7= | Product name on the original file
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Assuming price list is
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Product 1 | 800
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Product 2 | 950
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Product 3 | 850
Spreadsheet: 3bc9f645-2241-4077-a721-150ba2469620
Sheet: Sheet1

electronica 2010 - List of exhibitors | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Search by product and service index (3 Entries):
 | 14 Wireless 14.3 Wireless applications 14.3.7 TV tuners
No. | Company | Country | City | [NAME] | Hall/Booth
1 | COMPOTRON GMBH | Germany | München | 80335 | A4.W01
2 | Samsung Electro-Mechanics GmbH | Germany | Schwalbach | 65824 | B6.173
3 | Seltech | France | ORLY | 94310 | A5.210
Spreadsheet: 170436d1343276019-macro-for-row-height-sample
Sheet: abc

ABC Corporation
BEGINNING BALANCE
May 1, 2011 |  |  |  | 425
INCOME |  |  |  |  |  |  | lincon gain |  | 11053.65
 |  |  |  |  |  |  | great gain |  | 10331.92
Total Sell |  | 10447.45
 |  |  |  | 10447.45
EXPENSES
Transportation Expense |  | 1524
 |  |  |  | 1524 |  |  | -384752.15 | -2878.98 | -387631.13 | #N/A
TOTAL |  |  |  |  |  |  | -384752.15 |  | 386619.32
 |  |  |  |  |  |  |  |  | -1011.809999999998 | #N/A
 |  |  |  | 12396.45
 |  |  |  |  |  |  | 130.32
 |  | TOTAL ASSET |  |  |  |  | 130.32
Cash at Hand |  |  |  | 8140.45
Employee Loan |  |  |  | 1002
Dues |  |  |  | 3254
GROSS TOTAL |  |  |  | 12396.45
Spreadsheet: 145719d1331722683-solved-extract-distinct-cells-and-sum-values-next-to-test
Sheet: Sheet1

Nick | 1 |  | Nick
George | 2 |  | George | 10
[NAME] | 3 |  | [NAME] | 15
Brooke | 4 |  | Brooke | 20
Nick | 1
George | 2
[NAME] | 3
Brooke | 4
Nick | 1
George | 2
[NAME] | 3
Brooke | 4
Nick | 1
George | 2
[NAME] | 3
Brooke | 4
Nick | 1
George | 2
[NAME] | 3
Brooke | 4
 | Data
 | Result
Spreadsheet: 718895d1613407526-descriptive-statistics-updated-results-1-
Sheet: Data

Participant Number | Gender | Age | PSS | Category of Stress | Reaction Time |  | Total Median PSS |  | High or Low Stress | Reaction time for high stress | Reaction time for low stress
1 | male | 40 | 25 |  | 0.6586 |  |  |  |  | 0.6586 | 0.2272
2 | female | 48 | 36 |  | 0.6462 |  |  |  |  | 0.6462 | 0.6288
3 | male | 41 | 9 |  | 0.2272 |  |  |  |  | 0.3894 | 0.3994
4 | female | 43 | 35 |  | 0.3894 |  |  |  |  | 0.3748 | 0.3748
5 | female | 33 | 29 |  | 0.3748 |  |  |  |  | 2.8548
6 | male | 44 | 21 |  | 0.6288 |  |  |  |  | 0.5524
7 | female | 49 | 5 |  | 0.3994
8 | male | 25 | 20 |  | 0.3748
9 | male | 65 | 25 |  | 2.8548
10 | male | 27 | 30 |  | 0.5524
Spreadsheet: 475681d1471414825-login-id-change-during-the-day-login-id-change-test
Sheet: Sheet1

Date | transaction time | Login id | Expected result
2016.06.01 | 07:27:00 | 604 | 2
2016.06.01 | 08:24:00 | 604 | 2
2016.06.01 | 09:44:00 | 604 | 2
2016.06.01 | 11:28:00 | 604 | 2
2016.06.01 | 12:36:00 | 604 | 2
2016.06.01 | 14:12:00 | 602 | 2
2016.06.01 | 14:57:00 | 602 | 2
2016.06.01 | 15:08:00 | 602 | 2
2016.06.01 | 15:16:00 | 602 | 2
2016.06.01 | 15:58:00 | 602 | 2
2016.06.01 | 16:02:00 | 602 | 2
2016.06.01 | 16:16:00 | 602 | 2
2016.06.01 | 17:17:00 | 602 | 2
2016.06.01 | 17:55:00 | 602 | 2
2016.06.01 | 20:21:00 | 602 | 2
2016.06.01 | 20:25:00 | 602 | 2
2016.06.02 | 07:21:00 | 604 | 2
2016.06.02 | 07:50:00 | 604 | 2
2016.06.02 | 07:59:00 | 604 | 2
2016.06.02 | 08:53:00 | 604 | 2
2016.06.02 | 09:57:00 | 604 | 2
2016.06.02 | 10:34:00 | 604 | 2
2016.06.02 | 10:42:00 | 604 | 2
2016.06.02 | 11:10:00 | 604 | 2
2016.06.02 | 11:19:00 | 604 | 2
2016.06.02 | 11:35:00 | 604 | 2
2016.06.02 | 13:22:00 | 604 | 2
2016.06.02 | 13:53:00 | 606 | 2
2016.06.02 | 13:54:00 | 606 | 2
2016.06.02 | 14:24:00 | 606 | 2
2016.06.02 | 15:14:00 | 606 | 2
2016.06.02 | 15:33:00 | 606 | 2
2016.06.02 | 16:04:00 | 606 | 2
2016.06.02 | 16:14:00 | 606 | 2
2016.06.02 | 17:08:00 | 606 | 2
2016.06.02 | 18:55:00 | 606 | 2
2016.06.02 | 19:20:00 | 606 | 2
2016.06.02 | 19:47:00 | 606 | 2
2016.06.02 | 21:11:00 | 606 | 2
2016.06.02 | 21:28:00 | 606 | 2
2016.06.03 | 06:19:00 | 602 | 1
2016.06.03 | 07:30:00 | 602 | 1
2016.06.03 | 08:22:00 | 602 | 1
2016.06.03 | 08:27:00 | 602 | 1
2016.06.03 | 08:28:00 | 602 | 1
2016.06.03 | 08:53:00 | 602 | 1
2016.06.03 | 08:58:00 | 602 | 1
2016.06.03 | 09:08:00 | 602 | 1
2016.06.03 | 11:13:00 | 602 | 1
2016.06.03 | 11:17:00 | 602 | 1
2016.06.03 | 12:12:00 | 602 | 1
2016.06.03 | 12:25:00 | 602 | 1
2016.06.03 | 12:29:00 | 602 | 1
2016.06.03 | 13:11:00 | 602 | 1
2016.06.03 | 13:15:00 | 602 | 1
2016.06.03 | 13:48:00 | 602 | 1
2016.06.03 | 14:02:00 | 602 | 1
2016.06.03 | 14:14:00 | 602 | 1
2016.06.03 | 14:49:00 | 602 | 1
2016.06.03 | 16:06:00 | 602 | 1
2016.06.03 | 16:51:00 | 602 | 1
2016.06.03 | 16:53:00 | 602 | 1
2016.06.03 | 17:05:00 | 602 | 1
2016.06.03 | 17:31:00 | 602 | 1
2016.06.03 | 17:44:00 | 602 | 1
2016.06.03 | 17:47:00 | 602 | 1
2016.06.03 | 18:21:00 | 602 | 1
2016.06.03 | 18:31:00 | 602 | 1
2016.06.03 | 18:49:00 | 602 | 1
2016.06.03 | 18:52:00 | 602 | 1
2016.06.03 | 18:55:00 | 602 | 1
2016.06.03 | 19:01:00 | 602 | 1
2016.06.03 | 19:32:00 | 602 | 1
2016.06.03 | 20:05:00 | 602 | 1
2016.06.03 | 20:05:00 | 602 | 1
2016.06.03 | 20:21:00 | 602 | 1
2016.06.03 | 20:47:00 | 602 | 1
Spreadsheet: 0e165fa2-6653-41cd-a198-de44ead50091
Sheet: Summary

Undergraduates Academic Program | # of Graduates | # Status Known | KR %* | Total # All Emp, Serv & Mil Serv | Total % All Emp, Serv & Mil Serv | Total # Emp FT | Total % Emp FT | Total # Emp PT | Total % Emp PT | Total # Serv | Total % Serv | Total # [NAME] | Total % Mil Serv | # [NAME] (CE) | % [NAME] (CE) | # Seeking Emp | % Seeking Emp | # Seeking CE | % Seeking CE | # Not Seek | % Not Seek | # No Info | % No Info | Career Outcomes %
Associate
Program A
Program B
Program C
Baccalaureate
Program A
Program B
Program C
Grand Totals
Spreadsheet: dbcfef8e-d91c-4f3e-bcd8-1685ee775e99
Sheet: Sheet1

Campus | Last Name | First Name | [NAME] | Phone Number | Fax Number | Street | Street2 | City | State | Zip
Appalachian State University | Peacock | [NAME] | [EMAIL] | [PHONE] | [PHONE] | Academy Drive |  | Boone | NC | 28608
East Carolina University | Ballard | Dr. [NAME] | [EMAIL] | [PHONE] |  | East Fifth Street |  | Greenville | NC | 27858
Elizabeth City State University | Gilchrist | Willie | [EMAIL] | [PHONE] | [PHONE] | 1704 Weeksville Road |  | Elizabeth City | NC | 27909
Fayetteville State University | [NAME] | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 1200 Murchison Road |  | Fayetteville | NC | 28301
NC Agricultural and Technical State University | Martin | Harold | [EMAIL] | [PHONE] | [PHONE] | 1601 East Market Street |  | Greensboro | NC | 27411
North Carolina Central University | Becton | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 1801 Fayetteville Street |  | [NAME] | NC | 27707
NC State University | Woodson | [NAME] | [EMAIL] | [PHONE] | [PHONE] |  |  | Raleigh | NC | 27695
UNC Asheville | Ponder | Anne | [EMAIL] | [PHONE] | [PHONE] | 1 University Heights |  | Asheville | NC | 28804
UNC-Chapel Hill | Thorp | Holden | [EMAIL] | [PHONE] | [PHONE] |  |  | Chapel Hill | NC | 27599
UNC Charlotte | Dubois | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 9201 University City Boulevard |  | Charlotte | NC | 28223
UNC Greensboro | [NAME] | [NAME] | [EMAIL] | [PHONE] | [PHONE] | Post Office Box 26170 |  | Greensboro | NC | 27402
UNC Pembroke | [NAME] | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 1 University Drive |  | Pembroke | NC | 28372
[NAME] | [NAME] | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 601 South College Road |  | [NAME] | NC | 28403
UNC School of the Arts | [NAME] | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 1533 South Main St. |  | Winston-Salem | NC | 27127
Western Carolina University | Belcher | [NAME] | [EMAIL] | [PHONE] | [PHONE] |  |  | Cullowhee | NC | 28723
Winston-Salem State University | Reaves | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 601 [NAME], Jr. Drive |  | Winston-Salem | NC | 27110
North Carolina School of Science and Mathematics | [NAME] | J. | [EMAIL] | [PHONE] | [PHONE] | 1219 Broad Street |  | [NAME] | NC | 27705
Spreadsheet: 731848d1620644335-get-remarks-value-base-on-the-right-code-no-forasking-ans-2
Sheet: Sheet2

Expected Result |  |  | [NAME]
CODE NO. | MARKS |  | CODE NO. | MARKS
111-221 | x |  | 111-221
111-222 | x |  | 111-222
111-223 | x |  | 111-223
111-224 | o |  | 111-224
111-225 | o |  | 111-225
111-225 | o |  | 111-225
111-225 | o |  | 111-225
111-226 | o |  | 111-226
111-226 | o |  | 111-226
111-227 | x |  | 111-227
111-227 | x |  | 111-227
111-227 | x |  | 111-227
111-227 | x |  | 111-227
111-227 | x |  | 111-227
111-227 | x |  | 111-227
111-228 | o |  | 111-228
111-228 | o |  | 111-228
111-228 | o |  | 111-228
Spreadsheet: 707159d1607076628-count-cells-with-a-condition-sample
Sheet: Sheet1

Data |  |  | 2020-10-10 00:00:00 |  | 2020-10-15 00:00:00
2020-10-10 00:00:00 | Yes |  | Yes | No | Yes | No
2020-10-10 00:00:00 | Yes
2020-10-10 00:00:00 | Yes
2020-10-10 00:00:00 | No
2020-10-10 00:00:00 | No
2020-10-15 00:00:00 | Yes
2020-10-15 00:00:00 | No
2020-10-15 00:00:00 | No
2020-10-15 00:00:00 | Yes
2020-10-15 00:00:00 | No