tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 2a1eb375-0ee4-43a9-8e4a-28bbb93b2c5e
Sheet: 4.2(AG) Major Group Enroll-Grad

Institution
Indicator 4: Student Enrollment and Graduation by Major Group
Table 4.2(AG): Major Group Fall Enrollment, Graduation & Post-Graduate / AY 20010-11
 | Major Group | AG - Agriculture and Farming
 | Please enter the number of students enrolled in this major group for the fall semester.
 |  |  |  |  | Fall 2011 (October 15, 2011)
 | Fall Enrollment (Snapshot) |  | American Indian |  | Non-Indian
 |  |  | M | F | M | F | Total
 |  | Full Time | na | na | na | na
 |  | Part Time | na | na | na | na
 |  | Total
 | Please enter the number of diploma, certificates, and degrees earned in this major group.  Also enter the number of students who were admitted to a 4 year (Associate degree graduates), or graduate school (Bachelor's degree graduates).  Lastly, enter the number of all graduating students(certificate or degree) who secured gainful employment after graduation.
 |  |  |  |  | July 1, 2011- June 30, 2012
 | Graduation |  | American Indian |  | Non-Indian
 |  |  | M | F | M | F | Total
Apprenticeship/Occupational Program |  |  | na | na | na | na
 | App. graduates admitted to a college program |  | na | na | na | na
Diploma |  |  | na | na | na | na
 | [NAME]. graduates admitted to a college program |  | na | na | na | na
Certificate |  |  | na | na | na | na
 | Cert. graduates admitted to a college program |  | na | na | na | na
Associate Degree |  |  | na | na | na | na
 | Assoc. graduates admitted to four-year program |  | na | na | na | na
Bachelor's Degree |  |  | na | na | na | na
 | [NAME]. graduates admitted to graduate school |  | na | na | na | na
Master's Degree |  |  | na | na | na | na
Gainfully Employed after graduation |  |  | na | na | na | na
Graduates who completed remedial courses during their time at the TCU |  |  | na | na | na | na
Graduates who received A*CF support at some point during their coursework |  |  | na | na | na | na
Notes:
Spreadsheet: 0d983f71-35ef-49d7-8c0f-856124e1cc27
Sheet: Sheet1

CERTIFICATION TEST PASS RATES*  ([NAME] and Updated 11/7/11)
 | COMPLETION YEAR 2005 |  |  |  |  |  | COMPLETION YEAR 2006 |  |  |  |  |  | COMPLETION YEAR 2007 |  |  |  |  |  | COMPLETION YEAR 2008 |  |  |  |  |  | COMPLETION YEAR 2009 |  |  |  |  |  | COMPLETION YEAR 2010 |  |  | COMPLETION YEAR 2011
 | INITIAL |  |  | FINAL |  |  | INITIAL |  |  | FINAL |  |  | INITIAL |  |  | FINAL |  |  | INITIAL |  |  | FINAL |  |  | INITIAL |  |  | FINAL |  |  | FINAL |  |  | FINAL
Name of Test | Tests Taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate
[NAME] EC-4 | 119 | 117 |  | 119 | 117 |  | 89 | 88 |  | 89 | 88 |  | 92 | 86 |  | 93 | 88 |  | 88 | 88 |  | 89 | 89 | 1 | 89 | 88 | 0.989 | 89 | 88 | 0.989 | 44 | 43 | 0.977 | - | - | -
[NAME] EC-6 (New 2009) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28 | 26 | 0.929 | 73 | 65 | 0.89
*Data obtained from Texas Education Agency's Accountability System for Educator Preparation (ASEP) report on pass rates sorted by Test.
*2010 Texas Education Agency starting using one yearly pass rate.
Spreadsheet: 190985d1351869615-match-names-between-two-sheets-september
Sheet: vendordetail

 | Client |  | Vendor |  |  |  | Billing Period |  |  | Prepared
 | XYZ |  | Kaiser HSA |  |  |  | September 2012 Final Invoice |  |  | 09/14/2012
 |  |  |  |  | 366310.09
 | Employee | Location | Plan | Tier | Eff Date | Term Date | Count | Coverage | Premium | Retro Month | Retro Type | Retro Change
 | ACEBU, ZENAIDA D | CA | 1 | EMP | 07/01/2012 |  | 1 | 0 | 394.8
 | ADAME, ERNESTO Z | CA | 1 | EMP | 07/01/2012 | 08/31/2012 | -1 | 0 | -394.8 | September 2012 Final Invoice | ADJ-CREDIT
 | AGBAYANI, SAMSON DALERE | CA | 1 | ECH | 07/01/2012 |  | 1 | 0 | 781.69
 | AHARON, [NAME] | CA | 1 | ESP | 07/01/2012 |  | 1 | 0 | 821.17
 | ALAPAN, LEO ALTERADO | CA | 1 | ESP | 07/01/2012 |  | 1 | 0 | 821.17
 | ALCAIN, IGNACIO R | CA | 1 | ESP | 07/01/2012 |  | 1 | 0 | 821.17
 | ALONZO, ERNIE | CA | 1 | EMP | 07/01/2012 |  | 1 | 0 | 394.8
 | ALTAMIRANO, LUIS ADOLFO | CA | 1 | ESP | 07/01/2012 |  | 1 | 0 | 821.17
 | AMANCIO, RAMONITO P | CA | 1 | EMP | 07/01/2012 |  | 1 | 0 | 394.8
 | ANGUS, PEDRO  JR. | CA | 1 | EMP | 07/01/2012 |  | 1 | 0 | 394.8
 | ANWIYA, DINKHA I | CA | 1 | ESP | 07/01/2012 |  | 1 | 0 | 821.17
 | TOTAL |  |  |  |  |  |  |  | 6071.940000000001
Spreadsheet: 36587d1234457625-excel-order-form-warehouse-supplies1
Sheet: Sheet1

 |  |  | [NAME]
 |  |  | Supervisor: |  |  | 2009-02-12 00:00:00
Description |  |  | PRODUCT CODE |  | On Hand Inventory | Inventory | Qty to Order
SPRAY GLUE (BOXES) |  |  |  |  |  | 2 | 0 | [NAME]
DHL SECURITY TAPE (BOXES) |  |  |  |  |  | 25 | 0 | Alain Alfonso
DHL INTEL SECURITY RED TAPE (BOXES) |  |  |  |  |  | 5 | 0 | [NAME]
DHL INTEL SECURITY BLUE TAPE (BOXES) |  |  |  |  |  | 5 | 0 | Inoir Ortiz
DHL INTEL SECURITY GREEN TAPE (BOXES) |  |  |  |  |  | 5 | 0 | [NAME]
2" CLEAR TAPE (BOXES) |  |  |  |  |  | 25 | 0 | [NAME]
1/2" METAL STRAPS (ROLLS) |  |  |  |  |  | 10 | 0 | [NAME]
1/2" PLASTIC STRAPS (ROLLS) |  |  |  |  |  | 5 | 0
STEEL STRAP CLIPS (BOXES) |  |  |  |  |  | 3 | 0
PLASTIC STRAP CLIPS (BOXES) |  |  |  |  |  | 3 | 0
MACHINE SHRINK WRAP CLEAR (SKIDS) |  |  |  |  |  | 2 | 0
MACHINE SHRINK WRAP BLACK (SKIDS) |  |  |  |  |  | 1 | 0
18" BLACK SHRINK WRAP (BOXES) |  |  |  |  |  | 10 | 0
18" CLEAR SHRINK WRAP (BOXES) |  |  |  |  |  | 25 | 0
D-CONTAINERS |  |  |  |  |  | 100 | 0
D-CONTAINER S W/PALLET |  |  |  |  |  | 0 | 0
D-CONTAINER PALLETS |  |  |  |  |  | 0 | 0
E-CONTAINERS (SINGLE UNITS) |  |  |  |  |  | 100 | 0
EH-CONTAINERS (SINGLE UNITS) |  |  |  |  |  | 100 | 0
CTNS - 24 X 24 X 24 (SINGLE UNITS) |  |  |  |  |  | 100 | 0
STAPLES - C 3/4 20mm 16025033 |  |  |  |  |  | 0 | 0
DC8 PALLET COVER CLEAR (ROLLS) |  |  |  |  |  | 30 | 0
747 PALLET COVER CLEAR (ROLLS) |  |  |  |  |  | 25 | 0
ROPE (BOXES) |  |  |  |  |  | 5 | 0
CARDBOARD SLIP SHEETS |  |  |  |  |  | 2 | 0
EDGE PROTECTOR (CORNER) (SKIDS) |  |  |  |  |  | 2 | 0
[NAME] (REGULAR) ROLLS |  |  |  |  |  | 15 | 0
BUBBLE WRAP |  |  |  |  |  | 25 | 0
PLASTIC PALLETS |  |  |  |  |  | 200 | 0
PALLETS (48 X 40) |  |  |  |  |  | 200 | 0
PALLETS (24 X 24) |  |  |  |  |  | 0 | 0
PALLETS (48 X 24) |  |  |  |  |  | 0 | 0
FUMIGATED PALLETS |  |  |  |  |  | 100 | 0
CONTAINER [NAME] (YELLOW) |  |  |  |  |  | 1 | 0
TOPP CLIPS |  |  |  |  |  | 1 | 0
ABSORBING POWDER (BOXES) |  |  |  |  |  | 2 | 0
THERMAL LABELS (BOXES) |  |  |  |  |  | 5 | 0
THERMAL LABEL INK ROLLS (TINTA) |  |  |  |  |  | 5 | 0
[NAME] (CARDINAL) |  |  |  |  |  | 0 | 0
TRANSFER MANIFEST |  |  |  |  |  | 2 | 0
[NAME] |  |  |  |  |  | 2 | 0
COUNTRY LABELS:
ARGENTINA (SHEETS) |  |  |  |  |  | 1000 | 0
BELIZE (SHEETS) |  |  |  |  |  | 1000 | 0
[NAME] (SHEETS) |  |  |  |  |  | 1000 | 0
BRAZIL (SHEETS) |  |  |  |  |  | 1000 | 0
CHILE (SHEETS) |  |  |  |  |  | 1000 | 0
COLOMBIA (SHEETS) |  |  |  |  |  | 1000 | 0
ECUDOR (SHEETS) |  |  |  |  |  | 1000 | 0
HONDURAS (SHEETS) |  |  |  |  |  | 1000 | 0
JAMAICA (SHEETS) |  |  |  |  |  | 1000 | 0
MEXICO (SHEETS) |  |  |  |  |  | 1000 | 0
PANAMA (SHEETS) |  |  |  |  |  | 1000 | 0
PARAGUAY (SHEETS) |  |  |  |  |  | 1000 | 0
[NAME] (SHEETS) |  |  |  |  |  | 1000 | 0
PUERTO RICO (SHEETS) |  |  |  |  |  | 1000 | 0
DOMINICAN REPULIC (SHEETS) |  |  |  |  |  | 1000 | 0
TRINIDAD (SHEETS) |  |  |  |  |  | 1000 | 0
Spreadsheet: joe_parks__14610__POSTIONTRAX_NOV
Sheet: KATY_PHYS

 | SELL |  |  |  | BUY
BEGINNING |  |  |  |  |  |  |  |  |  |  | MTM
 |  |  |  |  |  |  |  |  |  |  | ROLLOFF VAULE
 |  |  |  |  |  |  |  |  |  |  | NEW DEALS
 |  |  |  |  |  |  |  |  |  |  | TOTAL  P&L
 |  |  |  |  |  |  |  |  |  |  | POSTION
 |  |  |  |  |  |  |  |  |  |  | ROLL OFF
 |  |  |  |  |  |  |  |  |  |  | NET POSTION
 |  |  |  |  |  |  |  |  |  |  | 3 DAY ROLL
 |  |  | ROLL VALUE
 |  |  | <- Current MTM
 |  |  |  |  |  |  | <- Realized PL
 |  |  |  |  |  |  | <- MTM PL w/o Real PL
 |  |  |  |  |  |  | <- MTM PL with Real PL
 |  |  |  |  |  |  | <- Total Pl
Spreadsheet: 11a4bdff-c53a-47ba-9edd-6cd98408953f
Sheet: Sheet1

Table 2--World cotton supply and use estimates | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 |  |  |  |  | 2013/14
Item | 2011/12 |  | 2012/13 |  | May |  | June
 | Million 480-lb. [NAME]
Supply:
Beginning stocks--
World | 49.44 |  | 71.22 |  | 84.78 |  | 84.93
Foreign | 46.84 |  | 67.87 |  | 80.78 |  | 81.33
Production--
World | 125.14 |  | 120.97 |  | 117.82 |  | 117.16
Foreign | 109.57 |  | 103.66 |  | 103.82 |  | 103.66
Imports--
World | 45.07 |  | 46.92 |  | 39.5 |  | 38.42
Foreign | 45.05 |  | 46.91 |  | 39.5 |  | 38.41
Use:
[NAME] use--
World | 103.31 |  | 108.1 |  | 110.43 |  | 110.17
Foreign | 100.01 |  | 104.65 |  | 106.93 |  | 106.67
Exports--
World | 45.88 |  | 46.64 |  | 39.5 |  | 38.43
Foreign | 34.16 |  | 33.04 |  | 28 |  | 27.43
Ending stocks--
World | 71.22 |  | 84.93 |  | 92.74 |  | 92.49
Foreign | 67.87 |  | 81.33 |  | 89.74 |  | 89.89
 | Percent
Stocks-to-use ratio:
World | 68.9 |  | 78.6 |  | 84 |  | 84
Foreign | 67.9 |  | 77.7 |  | 83.9 |  | 84.3
 | 3
Source: USDA, World Agricultural Outlook Board, World Agricultural
Supply and Demand Estimates.
Last update: 06/14/13.
Spreadsheet: 028523e1-0ff7-42e5-b07c-98e09e19aa0a
Sheet: 1011

CONTRACT # | Goals | DBE WBE CERT. %
01-380504 | 5 | 0.4
01-449404 | 3 | 3.9
01-464304 | 4 | 4.2
02-0E6104 | 4 | 4.2
02-0E6504 | 4 | 2.4
02-1E3204 | 6 | 0.2
02-1E9804 | 5 | 8.6
02-2C50U4 | 4 | 4.1
02-373104 | 5 | 5
02-4C5804 | 7 | 7.7
02-4C94U4 | 7 | 10.1
02-4C9504 | 7 | 8.9
03-0C2814 | 5 | 5.3
03-1A4324 | 3 | 0.9
03-1A8414 | 5 | 5
03-1E0304 | 5 | 0.2
03-1E14U4 | 4 | 6.7
03-2A6904 | 4 | 4.1
03-366904 | 5 | 0.42
03-3C8804 | 4 | 4.3
03-3M2004 | 8 | 1
03-3M6204 | 4 | 2.7
03-4C0304 | 4 | 14.1
03-4C0904 | 5 | 1.5
04-150344 | 10 | 12.5
04-150474 | 4 | 4.5
04-151304 | 9 | 14
04-153404 | 9 | 10.4
04-163744 | 5 | 6.4
04-177904 | 4 | 0.3
04-1A9804 | 6 | 6.5
04-1E2204 | 4 | 4
04-1E3204 | 4 | 4.3
04-1E3804 | 5 | 9.1
04-1E3904 | 4 | 7.8
04-272024 | 7 | 0.8
04-294914 | 3 | 2.9
04-294924 | 4 | 4.2
04-294934 | 4 | 36.1
04-4C15U4 | 6 | 1.22
05-0E4704 | 4 | 4.1
05-0F7104 | 6 | 0.6
05-0G0304 | 6 | 6
05-0L8004 | 5 | 1.9
05-0P9104 | 6 | 6.2
05-0S2104 | 5 | 5
05-0S2204 | 3 | 26.4
06-0A4904 | 5 | 5
06-0A9704 | 1 | 2.4
06-0C8004 | 4 | 4
06-0K7204 | 4 | 6.2
06-0K7404 | 4 | 9.7
06-0K8904 | 4 | 0
06-0K9104 | 4 | 16
06-342514 | 7 | 7.2
06-416104 | 4 | 7.3
06-430104 | 4 | 0.17
06-432104 | 4 | 4.8
07-1218V4 | 4 | 4.3
07-1219U4 | 6 | 6.85
07-226514 | 12 | 0
07-226524 | 13 | 13.3
07-226534 | 13 | 0.08
07-226544 | 11 | 36.9
07-252104 | 6 | 6.1
07-252504 | 5 | 11
07-252714 | 7 | 7.5
07-266704 | 6 | 9.1
07-269004 | 4 | 0
07-2Y6304 | 4 | 5.7
07-3Y7904 | 3 | 3
07-3Y8104 | 4 | 22.3
08-0A6414 | 4 | 5.2
08-0F1004 | 3 | 6.4
08-0K6204 | 6 | 0
08-0K8004 | 4 | 4.1
08-0L2804 | 4 | 4.3
08-0L6804 | 9 | 4
08-0L7304 | 4 | 0
08-0L7504 | 9 | 0
08-394704 | 6 | 1
08-422204 | 7 | 7.6
08-434304 | 5 | 3.4
08-456004 | 8 | 1.2
09-327104 | 5 | 5.1
09-333804 | 4 | 0
09-339204 | 4 | 0
09-339604 | 4 | 4.4
09-345104 | 6 | 5.8
10-0G7704 | 7 | 8.3
10-0H04U4 | 6 | 6
10-0K0204 | 5 | 0.2
10-0L5704 | 7 | 7.1
10-0L5904 | 5 | 0.8
10-0S4404 | 6 | 6.2
10-0S4504 | 4 | 4
10-0S4604 | 4 | 4
10-0S4704 | 4 | 5.4
10-0U7004 | 3 | 3
10-279804 | 5
11-080104 | 10 | 0.95
11-081644 | 7 | 5
11-091834 | 6 | 6.2
11-288804 | 6 | 0.38
11-2T0404 | 5 | 5.3
12-071624 | 5 | 5.7
12-085104 | 6 | 6
12-0G0304 | 6 | 6
12-0G0404 | 6 | 0.5
12-0G7304 | 10 | 2.9
12-0J0904 | 9 | 9.4
12-0J7004 | 8 | 8.6
12-0K2004 | 5 | 6.1
C02-0E6104
C02-0E6504
C02-1E3204
C02-1E9804
C07-1218V4 | 4 | 4.7
C08-0L2804
C08-0L6804
C08-0L7304
R07-1218V4 | 4 | 4.7
R11-2T0404 | 5 | 4.6
Spreadsheet: 827195d1682533176-ignore-blanks-in-a-list-is-not-working-attendance-tracker-4-26-23-sample
Sheet: Master Roster

ID# | Employee ID | Associate Name | Department | Supervisor | DOH | Active (Y/N) | FT/PT | WLB Hours
111114 | 765 | Albon, Alex | Alliance A Pick | Siharath, Anand | 2022-07-13 00:00:00 | Y | FT
999999 | 98 | [NAME], [NAME] | Alliance B Pick | [NAME], Charles | 2022-01-09 00:00:00 | Y | FT
111111 | 123 | Bottas, Valtteri | Alliance A Pick | Siharath, Anand | 2022-01-01 00:00:00 | Y | FT
888888 | 890 | DeVries, [NAME] | Alliance B Pick | Zurkirchen, [NAME] | 2019-09-17 00:00:00 | Y | PT
111121 | 357 | Gasly, [NAME] | Alliance PackOut | Grammer-Barns, A. | 2022-01-19 00:00:00 | Y | FT
333333 | 345 | [NAME], [NAME] | Alliance PackOut | Grammer-Barns, A. | 2020-04-15 00:00:00 | Y | FT
111116 | 543 | Hulkenberg, Nico | Alliance A Pick | [NAME], [NAME] | 2022-01-14 00:00:00 | Y | FT
111117 | 423 | LeClerc, [NAME] | Alliance PackOut | [NAME], [NAME] | 2022-01-15 00:00:00 | Y | FT
111115 | 654 | Magnussen, [NAME] | Alliance PackOut | Grammer-Barns, A. | 2022-12-04 00:00:00 | Y | FT
555555 | 567 | Norris, Lando | Alliance PackOut | Grammer-Barns, A. | 2022-10-05 00:00:00 | Y | FT
111122 | 468 | Ocon, Esteban | Alliance B Pick | [NAME], Charles | 2023-03-01 00:00:00 | Y | FT
111120 | 246 | Perez, Sergio | Alliance Replenishment | Grammer-Barns, A. | 2022-01-18 00:00:00 | Y | FT
666666 | 678 | [NAME], [NAME] | Alliance PackOut | [NAME], [NAME] | 2022-01-06 00:00:00 | Y | PT
444444 | 456 | Russel, George | Alliance A Pick | [NAME], [NAME] | 2022-01-04 00:00:00 | Y | FT
111118 | 321 | Sainz, [NAME] | Alliance A Pick | Siharath, Anand | 2016-09-25 00:00:00 | Y | FT
111113 | 867 | Sargeant, Logan | Alliance PackOut | Grammer-Barns, A. | 2023-02-15 00:00:00 | Y | PT
555333 | 858 | Smith, [NAME] | Alliance A Pick | [NAME], [NAME] | 2022-01-04 00:00:00 | Y | FT
111112 | 978 | Stroll, Lance | Alliance PackOut | Grammer-Barns, A. | 2022-01-10 00:00:00 | Y | FT
777777 | 789 | Tsunoda, [NAME] | Alliance B Pick | Zurkirchen, [NAME] | 2022-01-07 00:00:00 | Y | FT
111123 | 579 | Valdes, Mario | Supply Chain | [NAME], [NAME] | 2009-06-29 00:00:00 | Y | FT
111119 | 135 | Verstappen, [NAME] | Alliance A Pick | [NAME], [NAME] | 2023-02-01 00:00:00 | Y | FT
222222 | 234 | [NAME], [NAME] | Alliance A Pick | [NAME], [NAME] | 2022-01-02 00:00:00 | Y | FT
Spreadsheet: 822631d1679459968-need-formula-to-find-duplicates-beyond-repts-vlaue-of-b-and-d-expected_reuls
Sheet: Sheet1

[NAME] | ORDER ID | Product | Cattle | Type | Animal | Expected Result |  | formula result
 | X1001 | [NAME] | FARM | CHICKEN | BIRD | 1
 | X1001 | HEN_COUNTRY_100KG | FARM | CHICKEN | BIRD | 1 | This Combined value come under multiple Order id
 | X1001 | TURTLE_COUNTRY_88KG | FARM | CHICKEN | BIRD | 1
 | X2001 | HEN_COUNTRY_100KG | FARM | CHICKEN | BIRD | 1 | This is single [NAME] come Under one Order Id
 | X3001 | HEN_COUNTRY_100KG | FARM | CHICKEN | BIRD | 2 | This is single [NAME] come Under one Order Id but different order ID
 | X1002 | [NAME] | FARM | CHICKEN | BIRD | 2
 | X1002 | HEN_COUNTRY_100KG | FARM | CHICKEN | BIRD | 2 | This Combined value come under different multiple Order id second time
 | X1002 | TURTLE_COUNTRY_88KG | FARM | CHICKEN | BIRD | 2
 | X3008 | GOAT_COUNTRY_73KG | AGRI | GOAT | ANIMAL | 1 | This [NAME] come under single Order ID
Spreadsheet: 108618d1305648201-conditional-formatting-of-red-cells-only-examplesheet
Sheet: JCK-LV

SHOW NAME: | [NAME]
FACILITY: | Mandalay Bay
BOOTH COUNT: | 6000
DRAPE COLOR:
Show Dates: | 5/23-6/9
ITEM | QTY. | ITEM | QTY. |  | PROJECTED | ACTUAL | DIFF |  | PROJECTED | ACTUAL | DIFF
 | 50 |  | 26 |  | 48 | 50 |  |  | 20 | 26
 | 40 |  | 3 |  | 220 | 40 |  |  | 20 | 3
 |  |  | 9 |  |  |  |  |  | 44 | 9
 | 4 |  | 1 |  | 8 | 4 |  |  |  | 1
 |  |  | 2 |  |  |  |  |  | 2 | 2
 | 2 |  | 21 |  | 4 | 2 |  |  | 50 | 21
 | 4 |  | 21 |  | 8 | 4 |  |  | 5 | 21
 | 14 |  | 44 |  | 180 | 14 |  |  | 22 | 44
 | 60 |  | 3 |  | 105 | 60 |  |  | 10 | 3
 | 47 |  | 3 |  | 46 | 47 |  |  | 2 | 3
 | 15 |  | 7 |  | 12 | 15 |  |  | 20 | 7
 | 2 |  | 7 |  | 26 | 2 |  |  | 23 | 7
 | 645 |  | 34 |  | 600 | 681 |  |  | 50 | 34
 | 3000 |  | 1 |  | 2455 | 3135 |  |  | 4 | 1
 | 239 |  | 5 |  | 810 | 379 |  |  | 4 | 5
 | 9 |  | 3 |  | 40 | 9 |  |  | 6 | 3
 | 10 |  | 23 |  |  | 10 |  |  | 12 | 23
 | 9 |  |  |  | 32 | 9
 | 10 |  |  |  | 38 | 10
 | 8 |  |  |  | 8 | 8
 | 4 |  |  |  | 4 | 4
 | 4 |  |  |  | 16 | 4
 | 5 |  |  |  | 20 | 5
 |  |  |  |  | 20
 | 6 |  |  |  | 4 | 6
 | 7 |  |  |  | 40 | 7
 | 3 |  |  |  | 6 | 3
 |  |  |  |  | 6
 | 2 |  |  |  | 4 | 2
 | 3 |  |  |  | 4 | 3
 | 2 |  |  |  | 12 | 2
 | 3 |  |  |  | 4 | 3
 | 3 |  |  |  | 38 | 3
 | 10 |  |  |  | 26 | 10
 | 10 |  |  |  | 26 | 10
 | 3 |  |  |  | 16 | 3
 | 3 |  |  |  | 16 | 3
 | 1 |  |  |  |  | 1
 | 6 |  |  |  | 14 | 6
 | 8 |  |  |  | 32 | 8
 | 12 |  |  |  | 24 | 12
 | 3 |  |  |  | 5 | 3
 | 134 |  |  |  | 150 | 159
 | 286 |  |  |  | 400 | 324
 | 35 |  |  |  | 100 | 60
 | 9 |  |  |  | 40 | 9
 | 9 |  |  |  | 37 | 9
 | 2 |  |  |  | 50 | 2
 | 4 |  |  |  | 1 | 4
 | 29 |  |  |  | 30 | 29
Spreadsheet: 693659d1599075637-mmult-with-non-adjacent-discontinuous-columns-sample-dataset
Sheet: Sheet1

 |  | Asset allocation
 |  | Product 1 | Product 2 | Product 3 | Product 4
 | Stock 1 | 0.5 | 0.05 | 0.15 | 0.1
 | Stock 2 | 0.1 | 0.2 | 0.15 | 0.1
 | Stock 3 | 0.1 | 0.15 | 0.15 | 0.1
 | Stock 4 | 0.2 | 0.1 | 0.15 | 0.1
 | Stock 5 | 0.1 | 0 | 0.05 | 0.1
 | Stock 6 | 0 | 0 | 0.05 | 0.1
 | Stock 7 | 0 | 0 | 0.05 | 0.1
 | Stock 8 | 0 | 0.05 | 0.05 | 0.1
 | Stock 9 | 0 | 0.1 | 0.1 | 0.1
 | Stock 10 | 0 | 0.35 | 0.1 | 0.1
 |  | Investor A's portfolio |  |  |  |  | Asset allocation
 |  | Product 1 | Product 3 | Product 4 |  |  | Product 1 | Product 2 | Product 3 | Product 4
 |  | 0.25 | 0.5 | 0.25
 |  |  |  |  |  |  |  |  |  | <== Correct result, because it includes all products
 |  | 0.225 | <-- Correct result
Spreadsheet: 456286d1460731529-vlookup-formula-not-returning-a-value-storm-june-2015-2-
Sheet: Parts

Inventory Materials |  |  | Equipment # | Rates
Water Main | Value |  | 206 | 29.75
Hot Mix | 70.82 |  | 208 | 29.75
Cold Mix | 115 |  | 209 | 29.75
CRS2 Oil | 2.55 |  | 211 | 29.75
Crack Seal Oil | 13.2 |  | 219 | 29.75
[NAME] | 0.1 |  | 221 | 29.75
Salt | 82.98 |  | 227 | 29.75
Geo-Melt | 1.28 |  | 229 | 75
1 - 1¼" | 14.45 |  | 231 | 29.75
1½" | 11.2 |  | 232 | 29.75
Type 5 Base | 15.1 |  | 233 | 29.75
3/8" | 64 |  | 234 | 29.75
3" | 14.85 |  | 235 | 56.5
6" | 17.05 |  | 238 | 72.25
[NAME] | 13.8 |  | 240 | 56.5
ADS Pipe | Value |  | 241 | 30
8" ADS | 2.38 |  | 242 | 56.5
10" ADS | 3.3 |  | 243 | 29.75
12" ADS | 4.82 |  | 245 | 29.75
15" ADS | 6.33 |  | 246 | 29.75
18" ADS | 8.55 |  | 247 | 29.75
24" ADS | 13.7 |  | 248 | 29.75
30" ADS | 20.1 |  | 249 | 56.5
36"ADS | 17.3 |  | 250 | 29.75
48" ADS | 29.16 |  | 251 | 56.5
Bands | Value |  | 252 | 29.75
8" Band | 3.91 |  | 253 | 77.25
10" Band |  |  | 254 | 56.5
12" Band | 8.12 |  | 256 | 29.75
15" Band | 10.07 |  | 257 | 56.5
18" Band | 16.12 |  | 258 | 56.5
PVC Pipe | Value |  | 263 | 77.25
6" PVC | 2.07 |  | 270 | 25
8" PVC | 3.72 |  | 272 | 56.5
10" PVC | 4.17 |  | 273 | 72.25
12" PVC | 8.23 |  | 276 | 77.25
15" PVC | 5.8 |  | 277 | 29.75
Galvanized Pipe & Bands | Value |  | 278 | 77.25
8" Galvanized | 5.8 |  | 283 | 77.25
8" Metal Band | 11.61 |  | 290 | 56.5
10" Galvanized | 7.44 |  | 306 | 47.3
10" Metal Band | 14.9 |  | 308 | 35
12" Galvanized | 5.9 |  | 309 | 58
12" Metal Band | 6.5 |  | 310 | 117.93
15" Galvanized | 7.25 |  | 314 | 37.5
15" Metal Band | 8.4 |  | 316 | 39
18" Galvanized | 6.45 |  | 319 | 39
18" Metal Band | 9.7 |  | 321 | 47
24" Galvanized | 8.5 |  | 327 | 26.5
24" Metal Band | 12.75 |  | 328 | 26.5
30" Galvanized | 10.65 |  | 330 | 37.5
30" Metal Band | 16 |  | 331 | 39
Dual Wall Storm Pipe | Value |  | 332 | 39
4" Dual Wall | 1.05 |  | 333 | 33
10" Dual Wall | 3.11 |  | 334 | 37.5
12" Dual Wall | 14.58 |  | 334B | 31.25
15" Dual Wall | 5.28 |  | 338 | 8
18" Dual Wall | 8.65 |  | 341 | 47
24" Dual Wall | 12.04 |  | 342 | 26.5
Storm Sewer / Flared Ends | Value |  | 345D | 24.08
8" Flared End | 67.09 |  | 347 | 43.75
10" Flared End | 69.35 |  | 348 | 43.75
12" Flared End | 116.56 |  | 354 | 75
15" Flared End | 116.56 |  | 357 | 26.5
18" Flared End | 156.58 |  | 400 | 75
24" Flared End | 200.96 |  | 403 | 20
Frame & Grate | 475 |  | 405 | 16.5
18" Drain Basin | 755 |  | 415 | 97.63
24" Drain Basin | 1274.5 |  | 418 | 16.5
30" Drain Basin | 1879.5 |  | 420 | 16.5
12" [NAME] | 7.39 |  | 421 | 16.5
15" [NAME] | 12.31 |  | 423 | 16.5
18" Tee | 243.75 |  | 426 | 16.5
18" [NAME] | 20.98 |  | 427 | 16.5
24" [NAME] | 29.59 |  | 433 | 16.5
 |  |  | 435S | 9
 |  |  | 435W | 9
 |  |  | 440 | 16.5
 |  |  | 444 | 16.5
 |  |  | 473 | 47
Spreadsheet: darrell_schoolcraft__7801__imbalsumm0108
Sheet: williams

 | Milagro |  | La Maquina |  | [NAME] |  | [NAME]
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 320046 | 326630 | 68213 | 62006 | 60282 | 67308 | 134575 | 120400
2 | 322443 | 342258 | 80613 | 62006 | 65523 | 61458 | 114858 | 123670
3 | 339003 | 356730 | 65345 | 62006 | 62518 | 57038 | 133408 | 135294
4 | 330189 | 334992 | 71515 | 62006 | 68003 | 60854 | 121528 | 122443
5 | 325423 | 357543 | 76506 | 45334 | 60101 | 61458 | 122124 | 116046
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-07-31 00:00:00 |  |  |  |  |  |  |  |  | 310272
2001-08-05 00:00:00
CBS Dollars
 |  |  | 1379279
 |  |  | 300359.04
 |  |  | -250735.54
 |  |  | 44931.54
 |  |  | 2153062.32
 |  |  | 0.0238
 |  |  | 0.0153
Spreadsheet: 755471d1636893882-help-me-with-formula-to-correctly-calculate-unsocial-hours-worked-sample-timesheet
Sheet: Sheet1

Date | Duty Periods |  |  |  | Total Hours | Details of Duties/Comments
 | From |  | To
Monday | 07:30:00 |  | 13:00:00
Tuesday | 21:30:00 |  | 22:30:00
Wednesday
Thursday
Friday
Saturday
Sunday
 |  |  |  |  |  | Total Hours Worked
 |  |  |  |  |  | Carried  Forward |  |  | Basic Rate
 |  |  |  |  |  | Hours Taken |  |  | Unsocial
 |  |  |  |  |  | Hours Due |  |  | Initialed
Spreadsheet: 798010d1664272486-gantt-chart-depending-on-repeatable-values-grid-create-etaf
Sheet: Sheet1

 | 2022-01-01 00:00:00 | 2022-01-02 00:00:00 | 2022-01-03 00:00:00 | 2022-01-04 00:00:00 | 2022-01-05 00:00:00 | 2022-01-06 00:00:00 | 2022-01-07 00:00:00 | 2022-01-08 00:00:00 | 2022-01-09 00:00:00 | 2022-01-10 00:00:00
1 |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2022-01-01 00:00:00
2 |  |  |  |  |  |  |  |  |  |  |  |  | A | 2022-01-01 00:00:00
3 |  |  |  |  |  |  |  |  |  |  |  |  | b | 2022-01-02 00:00:00
4 |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2022-01-02 00:00:00
5 |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2022-01-02 00:00:00
6 |  |  |  |  |  |  |  |  |  |  |  |  | A | 2022-01-03 00:00:00
7 |  |  |  |  |  |  |  |  |  |  |  |  | b | 2022-01-04 00:00:00
8 |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 2022-01-05 00:00:00
9 |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 2022-01-06 00:00:00
10 |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2022-01-07 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | A | 2022-01-08 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | b | 2022-01-04 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2022-01-05 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 2022-01-06 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | A | 2022-01-07 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | b | 2022-01-08 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 2022-01-02 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 2022-01-02 00:00:00
Spreadsheet: 549384d1511643902-color-formatting-based-on-completion-and-date-conditionalformatting
Sheet: Pivot

 | Max of Percentage Complete |  |  |  | Due Date
 | Status | Risk Level | Responsible | Color | 2017-11-30 00:00:00 | 2017-12-31 00:00:00 | 2018-01-31 00:00:00 | 2018-02-28 00:00:00 | 2018-03-31 00:00:00 | 2018-04-30 00:00:00
 | Open | High | Team 1 | Green |  | 0.7
 |  |  | Team 3 | Green |  |  |  |  |  | 0.8
 |  | Low | Team 1 | Green |  |  |  |  |  | 0.75
 |  |  | Team 3 | Green |  |  |  |  | 0.6
 |  | Medium | Team 1 | Yellow | 0.7
 |  |  | Team 2 | Green |  |  |  | 0.9
 |  |  | Team 3 | Yellow |  |  | 0.5