tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 885307d1734794835-error-in-weighted-average-formula-book1-wavg-error
Sheet: Sheet1

Date | FY | Shares | Buy | Sell | Rate | [NAME]. | Net Qty. | Amt | Differential cost
2021-04-07 00:00:00 | 2021-22 | HF | 1303657.99 |  | 38.3517 | 1303657.99 | 1303657.99 | 49997500.135083 | 50000000.015083
2021-10-13 00:00:00 | 2021-22 | HF | 1769442.728 |  | 39.5585 | 3073100.718 | 1769442.728 | 69996500.155588 | 70000000.155588 | Correct Ans
2024-12-11 00:00:00 | 2024-25 | HF |  | 1400217.034 | 48.5639 | 1672883.684 | -1400217.034 | -68000000.0174726 | -153812232.8734419
 |  |  |  |  |  |  |  |  |  | SUM(J4:J5)/G5 x E6
Spreadsheet: 472442d1469601777-how-to-search-filter-data-by-various-basis-from-other-sheets-syllabus-book-with-sample-result-
Sheet: EEE DEPT

FILTER TITLE | FILTER VALUE | COURSE CONTENTS
Department | EEE | JJJ
Level | 1
Term | 1
Subject | Physics
Subject Code | Phy 121
[NAME] | Structure of Matter
Credit Hour | 3
Contact Hour | 3
Department | EEE | KKK
Level | 1
Term | 1
Subject | Chemistry
Subject Code | Chem 123
[NAME] | Inorganic Quantitative Analysis
Credit Hour | 2
Contact Hour | 2 |  |  |  | Waves and oscillations: differential equation of a simple harmonic oscillator, total energy and average energy, combination of simple harmonic oscillations, Lissajous figures, spring-mass system, calculation of time period of torsional pendulum, damped oscillation, determination of damping co-efficient; forced oscillation, resonance, two-body oscillations, reduced mass, differential equation of a progressive wave, power and intensity of wave motion, stationary wave, group velocity and phase velocity, architectural acoustics, reverberation and Sabine's formula.
Department | EEE | LLL
Level | 1
Term | 2
Subject | Accounting
Subject Code | Acc 125
[NAME] | Principles of Accounting
Credit Hour | 3
Contact Hour | 3
Department | EEE | MMM
Level | 1
Term | 2
Subject | Economics
Subject Code | Eco 127
[NAME] | Engineering Economics
Credit Hour | 2
Contact Hour | 2
Spreadsheet: 34345d1231512902-define-list-in-workbook-states-not-a-valid-name-dependent_drop_down_v1
Sheet: Report

 |  | DEPENDENT DROP DOWN LISTS
 |  | [NAME]
 |  | [NAME]
 | FIRST LETTER OF INGREDIENT | INGREDIENT | INFO / NOTES | SERV SIZE | MEASURE | AMOUNT IN RECIPE | cal / serv | total calories | fat/serv | total fat | carb/serv | total carbs | fiber/serv | total fiber | sugar/serv | total sugar | protein/serv | total protein
 | [NAME] | 8th soy milk - lite vanilla (ounces) |  | 8 | ounces | 16 | 60 | 120 | 2 | 4 | 5 | 10 | 0 | 0 | 5 | 10 | 6 | 12
 | [NAME] | 8th soy milk - lite original (cup) |  | 1 | cup | 1.5 | 50 | 75 | 2 | 3
 | C | Cabbage, green, fresh, raw (1/2 cup = 35 grams)  Cup |  | 0.5 | cup | 2 | 8 | 32 | 0.1 | 0.4
 | S
 | [NAME]
 |  | total calories | 227
 |  | servings per recipe
 |  | calories per serving
 |  | fat per serving
 |  | carbs per serving
 |  | fiber per serving
 |  | sugar per serving
 |  | protein per serving
Spreadsheet: 103467d1301218377-fill-function-down-8-rows-then-over-4-columns-769631_cbrown8131
Sheet: Sheet1

TBL A |  |  |  |  | TBL B
TBL C |  |  |  |  | TBL D
Spreadsheet: darrell_schoolcraft__7335__imball0203
Sheet: Amoco

 | Florida Plant
Day | Measured | Scheduled | Imbal
1 | 152938 | 152909
2 | 163609 | 164724
3 | 163015 | 164724
4 | 165365 | 164724
5 | 155694 | 155505
6 | 155015 | 157679
7 | 148756 | 146528
8 | 153262 | 151937
9 | 154348 | 152961
10 | 155472 | 152961
11 | 154573 | 152961
12 | 157016 | 156215
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2002-02-28 00:00:00
2002-03-12 00:00:00
CBS Dollars
 |  |  | 336911
Spreadsheet: michael_maggi__26456__NYMEXWEEKLY
Sheet: cl

Week Ending: | 2001-11-16 00:00:00
 | Futures Settlement Prices
 | CRUDE OIL |  |  |  |  | Contract Symbol:  CL
 | Contract | Monday | Tuesday | Wednesday | Thursday | Friday | Open
 | Month | 2001-11-12 00:00:00 | 2001-11-13 00:00:00 | 2001-11-14 00:00:00 | 2001-11-15 00:00:00 | 2001-11-16 00:00:00 | Interest
 | 2001-12-01 00:00:00 | 21.23 | 21.67 | 19.74 | 17.45 | 18.03 | 52446
 | 2002-01-01 00:00:00 | 21.53 | 21.9 | 20.01 | 17.84 | 18.37 | 120732
 | 2002-02-01 00:00:00 | 21.64 | 21.97 | 20.15 | 18.06 | 18.59 | 48136
 | 2002-03-01 00:00:00 | 21.66 | 21.97 | 20.22 | 18.27 | 18.79 | 27473
 | 2002-04-01 00:00:00 | 21.64 | 21.93 | 20.27 | 18.44 | 18.96 | 21443
 | 2002-05-01 00:00:00 | 21.61 | 21.88 | 20.3 | 18.6 | 19.12 | 14072
 | 2002-06-01 00:00:00 | 21.58 | 21.83 | 20.32 | 18.76 | 19.28 | 28114
 | 2002-07-01 00:00:00 | 21.55 | 21.78 | 20.34 | 18.91 | 19.42 | 12733
 | 2002-08-01 00:00:00 | 21.53 | 21.74 | 20.36 | 19.04 | 19.53 | 12063
 | 2002-09-01 00:00:00 | 21.52 | 21.71 | 20.38 | 19.17 | 19.64 | 12419
 | 2002-10-01 00:00:00 | 21.52 | 21.69 | 20.41 | 19.28 | 19.75 | 8179
 | 2002-11-01 00:00:00 | 21.52 | 21.67 | 20.44 | 19.36 | 19.83 | 7409
 | Total Weekly Volume
 |  |  |  |  | Total Open Interest |  | 452978
 |  |  |  | *Weekly volume and open interest reflects all traded months.
 | Historical Volatility-Spot Month Futures
 |  |  |  | Crude Oil
 | 5 Day Hist. Vol. |  |  | 1.2738
 | 20 Day Hist. Vol. |  |  | 0.7041
 | Implied Volatility-Options
 |  |  |  | Crude Oil
 | At the Money Call & Put
 |  |  |  | 0.6518
Volume | MON | TUE | WED | THUR | FRI | Total
 | 161934 | 183768 | 258434 | 262771 | 225201
Spreadsheet: 779882d1652171366-index-match-w-or-condition-countif-test
Sheet: Sheet2

 | PRIMARY | Value | OR | Value |  |  | Animals | Vegetables |  | Animals | Vegetables
 | Fruits | Apple | Fruits | <> |  | Apple | Dog | <>
 | Animals | Dog | Animals | Cat |  |  |  |  |  | Cat | <>
 | Vegetables | <> | Vegetables | <>
 | # of Results
 |  | <---- | As of now the formula looks for the number of times the values appear in the Primary column only.
 |  |  | I want to make changes to the formula to look for the vlaues in [NAME] column but also in the OR column if one is added.
 |  |  | So the result now is "2" but if the formula looks for Apple and Dog or Cat it should be "5".
Spreadsheet: 935efe9d-d07b-4f4d-97d3-d0dc3e033442
Sheet: Sheet1

Budget Cost Estimating Worksheet | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
DATE:
PROJECT NAME:
COMPLETED BY:
SUMMARY OF COSTS  (from Labor, Materials and Equipment Worksheets)
Scope of Work Task Number | Total Labor Cost | Total Material Cost | Total Equipment Cost | Total Misc Cost | NOTES
TOTALS | 0 | 0 | 0 | 0
Total Project Cost | 0
Spreadsheet: 729070d1618900566-rept-value-by-count-x-in-rows-daboho
Sheet: Sheet1

item | 1 | 2 | 3 | 4
a | x | x
b |  |  | x | x
a |  |  |  | x
a |  |  |  | x
result
Spreadsheet: 693694d1599093981-aggregate-with-a-countif-internetexamplev2
Sheet: Result

 | Sizing Calculations
 |  | vInfoABC
 | Count
 | Virtual Machine Sizing Data
 |  | vInfoABC # | Count of data excluding Hidden Rows
 | 1
 | 0.95
 | 0.9
 | 0.85
 | 0.2
Spreadsheet: 787650d1657903982-list-required-fields-in-column-based-on-drop-down-value-list-required-fields
Sheet: Master

Table | Field | TABLE/FIELD | Description | Data Type | HALB | [NAME] | HAW | ERSA | CFG | FER | HAWA | DIEN | VAL
MARA | MBRSH |  | Industry sector | Basic Data | X | X | X | X | X | X | X | X
MARA | MTART |  | Material Type | Basic Data | X | X | X | X | X | X | X | X
MARA | MAKTX |  | Material Description | Basic Data | X | X | X | X | X | X | X | X
MARA | [NAME] |  | Base Unit | Basic Data | X | X | X | X | X | X | X | X
MARA | MATKL |  | Material Group | Basic Data | X | X | X | X | X |  | X | X
MARA | SPART |  | Division | Basic Data | X | X | X | X | X |  | X | X
MARA | MTPOS_MARA |  | GenItemCatGroup | Basic Data | X | X | X | X | X |  | X | X
MARA | BRGEW |  | Gross Weight | Basic Data | X
MARA | GEWEI |  | Weight Unit | Basic Data | X
MARC | WERKS |  | Plant | Generic | X | X | X |  | X |  | X | X
MVKE | VKORG |  | Sales Org. | [NAME] | X | X | X |  | X |  | X | X
MVKE | VTWEG |  | Distr.Channel | [NAME] | X | X | X |  | X |  | X | X
MVKE | DWERK |  | Deliver.Plant | [NAME] | X | X | X |  |  |  | X | X
MVKE | KTGRM |  | Acct asgnmt grp | [NAME] | X | X | X |  |  |  | X | X
MVKE | MTPOS |  | Item cat.group | [NAME] | X | X | X |  |  |  | X | X
MVKE | MVGR1 |  | Brand | [NAME] | X | X | X |  | X |  | X
MARC | MTVFP |  | Availability Check | Sales View / MRP | X | X | X |  |  |  | X
MARA | TRAGR |  | Trans. Group | [NAME] | X | X | X |  | X |  | X | X
MARC | LADGR |  | Loading Group | [NAME] | X | X | X |  | X |  | X | X
MARC | PRCTR |  | Profit Center | [NAME] | X | X | X |  | X |  | X | X
MARC | MTVER |  | Export/Import group | Foreign trade | X | X | X |  |  |  | X | X
MARC | DISMM |  | MRP Type | MRP | x | X | X | X | X |  | X | X
MARC | [NAME] |  | MRP controller | MRP | x | X | X | X | X |  | X | X
MARC | DISLS |  | Lot size | MRP | x | X | X | X | X |  | X | X
MARC | FHORI |  | SchedMargin key | MRP | x | X | X | X | X |  | X | X
PROP | PRMOD |  | Forecast model | Forecasting | x | X | X |  | X |  | X
MARC | FEVOR |  | Prodn Superv. | Work scheduling | x | X |  |  |  |  | X
CRFH | PLANV |  | Usage | Prod.resources/tools |  |  |  |  | X
MBEW | BKLAS |  | Valuation Class | Accounting | x | X | X |  |  |  | X | X
MBEW | STPRS |  | Standard price | Accounting | x | X | X |  |  |  | X
MBEW | HKMAT |  | Material origin | Costing | x | X | X |  |  |  | X
Spreadsheet: 875049d1721616394-identifying-the-row-value-of-the-top-5-items-based-on-a-list-excelhelp_sort
Sheet: Sheet1

 | Item | Score
 | A | 10
 | B | 10 |  |  | Output
 | C | 9 |  | Rank 1 | H
 | D | 9 |  | Rank 2 | M
 | E | 10 |  | Rank 3 | A
 | F | 8 |  | Rank 4 | B
 | G | 6 |  | Rank 5 | E
 | H | 12
 | I | 8
 | J | 6
 | K | 7
 | L | 10
 | M | 11
 | N | 7
 | O | 5
 | P | 6
 | Q | 7
 | R | 7
 | S | 5
 | T | 6
 | U | 10
 | V | 2
 | W | 10
 | X | 4
 | Y | 10
Spreadsheet: 218100d1362347231-employee-vacation-calendar-help-vacation-bid-results
Sheet: Calendar

 |  |  | Vacation Calendar
 | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
1 |  |  |  |  |  |  |  |  | Month | 1
2 |  |  |  |  |  |  |  |  | Year | 2013
3
4
5
6
7
8
9
10
11
12
1
2
3
4
5
6
7
8
9
10
11
12
1
2
3
4
5
6
7
8
9
10
11
12
1
2
3
4
5
6
7
8
9
10
11
12
1
2
3
4
5
6
7
8
9
10
11
12
Spreadsheet: 112205d1308318250-simplify-a-complex-formula-sample1
Sheet: July

July Numbers as of /Date
Name | # | W1 | [NAME] | U1 | U2 | EMS | Com. | Total
name | 7
name | 8
name | 9
name | 10
name | 13
name | 16
name | 20
name | 23
name | 24
---------------------------------------------------------------------------------
name | 21
name | 22
 |  |  |  |  | W Total
 |  |  |  |  | U, EMS, & Com Total
 |  |  |  |  | TOTAL
Spreadsheet: 64888d1265725015-generating-a-2nd-list-based-off-a-1st-list-help
Sheet: Overall View

 |  | Values
 | Row Labels | P Score | Q Score | Running Occurences | AvgProdHours
 | ACH | 75.12530000000001 | 81.51260504201662 | 3 | 3.858902971715002
 | Manager 4 | 75.12530000000001 | 81.51260504201662 | 3 | 3.858902971715002
 | Doe, Jane 5 | 64.26927500000001 | 63.23529411764695 | 2 | 3.100521929824561
 | Doe, [NAME] 9 | 89.60000000000001 | 105.8823529411762 | 3 | 4.870077694235589
 | Debit | 110.4701909090909 | 108.9936801166745 | 4 | 5.937653280348323
 | Manager 1 | 112.7848823529412 | 112.283737024221 | 2 | 6.444557222645662
 | Doe, Jane 1 | 129.7607692307692 | 115.8371040723978 | 0 | 6.415891788227028
 | Doe, [NAME] 10 | 101.6574375 | 108.8235294117644 | 2 | 6.569175406896688
 | Doe, [NAME] 11 | 102.6566538461538 | 110.859728506787 | 0 | 6.396534543679052
 | Manager 2 | 104.2388846153846 | 111.990950226244 | 2 | 6.379920158045616
 | Doe, Jane 2 | 101.1716076923077 | 115.384615384615 | 2 | 6.415981224496329
 | Doe, [NAME] | 107.3061615384615 | 108.597285067873 | 0 | 6.343859091594904
 | Manager 3 | 121.8375967741935 | 109.6774193548384 | 4 | 6.300349689488927
 | Doe, [NAME] 3 | 147.6514615384615 | 114.9321266968322 | 0 | 7.859542302091501
 | Doe, Jane 7 | 118.2734 | 117.647058823529 | 0 | 4.755651553637057
 | Doe, [NAME] 8 | 84.34531249999999 | 91.17647058823516 | 4 | 5.697534363824581
 | Manager 4 | 100.7069117647059 | 100.692041522491 | 3 | 5.443887869406136
 | Doe, Jane 5 | 116.5296666666667 | 107.8431372549016 | 0 | 5.589431499202552
 | Doe, Jane 7 | 115.6423333333333 | 113.725490196078 | 0 | 4.579123524720893
 | Doe, [NAME] 8 | 99.381 | 99.99999999999982 | 0 | 6.687283205741626
 | Doe, [NAME] 9 | 56.33583333333333 | 74.50980392156833 | 3 | 3.945239393939394
 | Manager 5 | 102.5394692307692 | 103.6199095022622 | 2 | 3.508172545303666
 | Doe, [NAME] 6 | 102.5394692307692 | 103.6199095022622 | 2 | 3.508172545303666
 | Grand Total | 108.5372671875 | 107.4908088235292 | 4 | 5.823971622844939
Spreadsheet: sally_beck__33906__GlobalMgmtSum-Q101-0111
Sheet: Expense Weekly Change

ENRON GLOBAL MARKETS
1st QUARTER 2001 EXPENSES - WEEKLY CHANGE
 |  | Direct Expenses
Business Team |  | Forecast | Plan | [NAME] |  | [NAME]
Liquids
Coal
Emissions
Weather
Global Risk Markets
Financial Trading
Transportation
Office of the Chairman
Subtotal
LNG
Middle East
Puerto Rico
Subtotal Commercial
Total
Group
Other Interest Related Charges
Total
 |  | Operating Expenses
Business Team |  | Forecast | Plan | [NAME] |  | [NAME]
Spreadsheet: 270024d1381347153-how-to-convert-rows-in-to-column-by-using-formula-post
Sheet: Sheet 1

Country | Month | Accounts Payable | Accounts RA | Accounts PR |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
United States | 8 | 200 | 241 | 123 |  |  |  | Accounts Payable |  |  |  |  | 100 | 150 | 170 | 200 | 130 | 125
United States | 5 | 100 | 201 | 133 |  |  |  | Accounts RA |  |  |  |  | 201 | 198 | 167 | 241 | 180 | 150
United States | 6 | 150 | 198 | 144 |  |  |  | Accounts PR |  |  |  |  | 133 | 144 | 155 | 123 | 166 | 177
United States | 7 | 170 | 167 | 155
United States | 9 | 130 | 180 | 166
United States | 10 | 125 | 150 | 177
Country | Month | Type | Value |  |  |  |  | Sum of Value | Month
United States | 8 | Accounts Payable | 200 |  |  |  |  | Type | 5 | 6 | 7 | 8 | 9 | 10 | Grand Total
United States | 5 | Accounts Payable | 100 |  |  |  |  | Accounts Payable | 100 | 150 | 170 | 200 | 130 | 125 | 875
United States | 6 | Accounts Payable | 150 |  |  |  |  | Accounts PR | 133 | 144 | 155 | 123 | 166 | 177 | 898
United States | 7 | Accounts Payable | 170 |  |  |  |  | Accounts RA | 201 | 198 | 167 | 241 | 180 | 150 | 1137
United States | 9 | Accounts Payable | 130 |  |  |  |  | Grand Total | 434 | 492 | 492 | 564 | 476 | 452 | 2910
United States | 10 | Accounts Payable | 125
United States | 8 | Accounts RA | 241
United States | 5 | Accounts RA | 201
United States | 6 | Accounts RA | 198
United States | 7 | Accounts RA | 167
United States | 9 | Accounts RA | 180
United States | 10 | Accounts RA | 150
United States | 8 | Accounts PR | 123
United States | 5 | Accounts PR | 133
United States | 6 | Accounts PR | 144
United States | 7 | Accounts PR | 155
United States | 9 | Accounts PR | 166
United States | 10 | Accounts PR | 177
Spreadsheet: 479696d1473508113-sum-if-assistance-to-calculate-total-sales-profit-according-to-a-supplier-column-sales-and-profit-sum
Sheet: Sheet1

# | Item | Description | Quantity | Sales Amount | Gross Profit | % | Supplier
1 | part-1 | p1 descr | 1 | 1000 | 100 |  | SDOR001
2 | part-2 | [NAME] | 2 | 1000 | 220 |  | SBAB001
3 | part-3 | p3 descr | 2 | 1000 | 300 |  | SBAB001
4 | [NAME] | p4 descr | 1 | 1200 | 300 |  | SFES001
5 | part-5 | p5 [NAME] | 5 | 2500 | 500 |  | SDOR001
 | Desired Results - sum of all Sales amounts for each supplier and sum of all Gross Profit amounts
 | Supplier | Total Sales Amount | Total Gross Profit | %
 | SDOR001 | 3500 | 600
 | SBAB001 | 2000 | 520
 | SFES001 | 1200 | 300
 | Supplier | Total Sales Amount | Total Gross Profit | %
 | SDOR001
 | SBAB001
 | SFES001
Spreadsheet: 103153d1300959015-4-way-lookup-shift-work-book
Sheet: FirstDayOfMonth

59床 |  |  |  |  |  | 担送
 |  |  |  |  |  |  |  |  |  | 名 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  | 護送
ICU |  | （ |  |  | ） |  |  |  |  | 名 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 名
当直医師 |  |  |  |  |  | 事務当直 |  |  |  |  | 外　泊
 |  |  |  |  | Ｄｒ
本館対照患者
担・護送者 | (担送） |  |  |  |  |  |  |  |  |  |  |  |  |  | (護送)
日勤者看 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 日勤者準 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 夜勤者
入　院　患　者 | 部屋 |  | 主治医 |  | 患者名 |  |  |  |  |  | [NAME] |  |  |  |  |  |  | 入　院　患　者 | 部　屋 |  | 主治医 |  | 患　者　名 |  |  |  | 年齢 |  | 病　　　　名 |  |  |  |  |  |  | 退　院　患　者 | 部　屋 |  | 患　者　名 |  |  |  |  | 転帰
転入 |  |  | ～ |  |  | ： |  |  |  |  |  | ～ |  |  | ： |  |  |  |  |  | ～ |  |  | ： |  |  |  |  |  | ～ |  |  | ： |  |  |  |  |  | ～ |  |  | ：
 |  |  | ～ |  |  | ： |  |  |  |  |  | ～ |  |  | ： |  |  |  |  |  | ～ |  |  | ： |  |  |  |  |  | ～ |  |  | ： |  |  |  |  |  | ～ |  |  | ：
転棟 |  |  | ～ |  |  | ： |  |  |  |  |  | ～ |  |  | ： |  |  |  |  |  | ～ |  |  | ： |  |  |  |  |  | ～ |  |  | ： |  |  |  |  |  | ～ |  |  | ：
転室 |  |  | ～ |  |  | ： |  |  |  |  |  | ～ |  |  | ： |  |  |  |  |  | ～ |  |  | ： |  |  |  |  |  | ～ |  |  | ： |  |  |  |  |  | ～ |  |  | ：
特殊検査及び手術患者 | 部　屋 |  |  | 患者名 |  |  |  | 麻酔 |  | 検査内容・術式 |  |  |  |  |  |  |  |  |  |  | ＩＶＨ挿入 | 部屋 |  |  | 患者名 |  |  |  |  | 部屋 |  |  | 患者名 |  |  |  |  | 部屋 |  |  | 患者名
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
有 熱 者 | 部　屋 |  |  | 患者名 |  |  |  |  |  | 部　屋 |  |  | 患者名 |  |  |  |  |  | 有　熱　者 | 部　屋 |  |  | 患者名 |  |  |  |  |  | 部　屋 |  |  | 患者名 |  |  |  |  |  | 四検患者 | 部屋 |  | 患者名
（日勤） |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | （夜勤）
重症及び要観察記録 | 部屋 |  |  | 氏　　名 |  |  |  |  |  | 病　　名 |  |  |  |  |  |  |  |  | 経　　　過　　　記　　　録
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 夜勤
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 夜勤
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 夜勤
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 夜勤
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
特記事項
Spreadsheet: 858902d1707400707-help-sumif-multiple-tabs-example2
Sheet: July

Name | NHS | 1st | 2nd | 3rd | Seen | Comments |  |  | Month Summary
Name 79
Name 80
Name 81 |  |  |  |  |  |  |  |  | Done Totals
Name 82 |  |  |  |  |  |  |  |  | Outstanding Totals
Name 83
Name 84
Name 85
Name 86 |  |  |  |  | dd
Name 87
Name 88
Name 89
Name 90
Spreadsheet: 0a8791de-84e4-4eb4-bfac-22483612972b
Sheet: Carpentry Certs 3

CONSTRUCTION TECHNOLOGY
Certificates - Carpentry
Student Name:
ID #
Suggest General Education Electives | Semester | Grade
___ TEC 200 (3) Technical Communications
___ COM 181 (3) Basic Public Speaking
___ COM 252 (3) Introduction to Interpersonal Communcation
___ MAT 105 (3) Business Mathematics
___ MAT 110 (3) Applied Mathematics
___ MAT 116 (3) Technical Mathematics
___ PHX 150 (3) Introductory Physics
___ EFM 100 (3) Personal Financial Management
___ WPP 200 (3) Workplace Principles
Note: TEC 200, PHX 150, EFM 100, and WPP 200 may be used to fill diploma [NAME] requirements only.
Rough Carpenter
___ BRX 220 (3) Blueprint Reading for Construction
___ CAR 126 (3) Introduction to Construction AND ___ CAR 127 (1) Introduction to Construction Lab
___ CAR 140 (3) Surveying & Foundations AND ___ CAR 141 (2) Surveying & Foundations Lab
___ CAR 190 (3) Light Frame Construction I - Floors and Walls
___ CAR 191 (2) Light Frame Construction I - Floors and Walls Lab
___ CAR 196 (3) Light Fram Construction II - Ceilings and Roofs
___ CAR 197 (2) Light Frame Construction II - Ceilings and Roofs Lab
Basic Carpenter
___ CAR 126 (3) Introduction to Construction AND ___ CAR 127 (1) Introduction to Construction Lab
___ Electives (5) Any 5 additional credits; program or otherwise.
Accoustical Carpenter
___ INF 205 (3) Introduction to Accoustical Carpentry
___ INF 211 (2) Advanced Accoustical Carpentry
___ Technical Electives (6)
[NAME]
___ INF 125 (3) Introduction to Drywall
___ INF 131 (2) Advanced Drywall
___ Technical Electives (4)
Painter, Interior Finish
___ INF 105 (2) Introduction to Painting
___ INF 111 (2) Advanced Painting
___ Technical Elecitve (2)
Painter, [NAME]
___ INF 105 (2) Introduction to Painting
___ INF 111 (2) Advanced Painting
___ INF 115 (2) Introduction to Wallcovering
___ INF 121 (2) Advanced Wallcovering
Southeast Kentucky Community & Technical College | Updated Spring 2013
Spreadsheet: 733133d1621414863-excel-data-transpose-for-adding-slicers-sample-skill
Sheet: Sheet1

 | Category | Project Control | Project Control | Project Control | Project Control | Project Control | Project Control | Project Schedule | Project Schedule | Project Schedule | Project Schedule | Project Schedule | Project Schedule
 | Sub Category | Project Data Analysis (Financial Utilisation, WIP) | Management Information System | Project Scheduling | Project Monitoring | Earned Value Management | Change Management | Cost Control | Project Closure | Risk Management | Project Budgeting | Estimate at Completion | Document Control
 | Name
 | Employee-A | 4 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Employee-B | 5 | 5 | 5 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
 | Employee-C | 2 | 1 | 4 | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 4 | 4
 | Employee-D | 4 | 4 | 4 | 3 | 3 | 5 | 5 | 5 | 4 | 4 | 5 | 3
Spreadsheet: 711829d1609933477-repeat-a-row-multiple-times-sample-file
Sheet: Expected result

[NAME] | Name | UserId | Department | Role | Region | DBM Code | State | S Code | Dealership Location | Vertical
36971 | Deependra Kumar | 34882 | Aftermarket | ASM | WEST | 8400 | MAHARASHTRA | 1S3054 | Satara | BUS
36972 | Deependra Kumar | 34883 | Aftermarket | ASM | WEST | 8401 | MAHARASHTRA | 1S3055 | Satara | Common
36973 | Deependra Kumar | 34884 | Aftermarket | ASM | WEST | 8402 | MAHARASHTRA | 1S3056 | Satara | HD
36974 | Deependra Kumar | 34885 | Aftermarket | ASM | WEST | 8403 | MAHARASHTRA | 1S3057 | Satara | HD PRO 6000
36975 | Deependra Kumar | 34886 | Aftermarket | ASM | WEST | 8404 | MAHARASHTRA | 1S3058 | Satara | LMD
36976 | Deependra Kumar | 34887 | Aftermarket | ASM | WEST | 8405 | MAHARASHTRA | 1S3059 | Satara | Parts
36977 | Deependra Kumar | 34888 | Aftermarket | ASM | WEST | 8406 | MAHARASHTRA | 1S3060 | Satara | Sub 5T
36971 | Deependra Kumar | 34882 | Aftermarket | ASM | WEST | 8401 | MAHARASHTRA | 1S3323 | Karad | BUS
36972 | Deependra Kumar | 34883 | Aftermarket | ASM | WEST | 8402 | MAHARASHTRA | 1S3324 | Karad | Common
36973 | Deependra Kumar | 34884 | Aftermarket | ASM | WEST | 8403 | MAHARASHTRA | 1S3325 | Karad | HD
36974 | Deependra Kumar | 34885 | Aftermarket | ASM | WEST | 8404 | MAHARASHTRA | 1S3326 | Karad | HD PRO 6000
36975 | Deependra Kumar | 34886 | Aftermarket | ASM | WEST | 8405 | MAHARASHTRA | 1S3327 | Karad | LMD
36976 | Deependra Kumar | 34887 | Aftermarket | ASM | WEST | 8406 | MAHARASHTRA | 1S3328 | Karad | Parts
36977 | Deependra Kumar | 34888 | Aftermarket | ASM | WEST | 8407 | MAHARASHTRA | 1S3329 | Karad | Sub 5T
37018 | [NAME] | 34940 | Aftermarket | CSM | WEST | 8400 | MAHARASHTRA | 1S3054 | Satara | BUS
37019 | [NAME] | 34941 | Aftermarket | CSM | WEST | 8401 | MAHARASHTRA | 1S3055 | Satara | Common
37020 | [NAME] | 34942 | Aftermarket | CSM | WEST | 8402 | MAHARASHTRA | 1S3056 | Satara | HD
37021 | [NAME] | 34943 | Aftermarket | CSM | WEST | 8403 | MAHARASHTRA | 1S3057 | Satara | HD PRO 6000
37022 | [NAME] | 34944 | Aftermarket | CSM | WEST | 8404 | MAHARASHTRA | 1S3058 | Satara | LMD
37023 | [NAME] | 34945 | Aftermarket | CSM | WEST | 8405 | MAHARASHTRA | 1S3059 | Satara | Parts
37024 | [NAME] | 34946 | Aftermarket | CSM | WEST | 8406 | MAHARASHTRA | 1S3060 | Satara | Sub 5T
37018 | [NAME] | 34940 | Aftermarket | CSM | WEST | 8401 | MAHARASHTRA | 1S3323 | Karad | BUS
37019 | [NAME] | 34941 | Aftermarket | CSM | WEST | 8402 | MAHARASHTRA | 1S3324 | Karad | Common
37020 | [NAME] | 34942 | Aftermarket | CSM | WEST | 8403 | MAHARASHTRA | 1S3325 | Karad | HD
37021 | [NAME] | 34943 | Aftermarket | CSM | WEST | 8404 | MAHARASHTRA | 1S3326 | Karad | HD PRO 6000
37022 | [NAME] | 34944 | Aftermarket | CSM | WEST | 8405 | MAHARASHTRA | 1S3327 | Karad | LMD
37023 | [NAME] | 34945 | Aftermarket | CSM | WEST | 8406 | MAHARASHTRA | 1S3328 | Karad | Parts
37024 | [NAME] | 34946 | Aftermarket | CSM | WEST | 8407 | MAHARASHTRA | 1S3329 | Karad | Sub 5T