tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: bc228119-c133-4ede-bda9-645cd4cc9ad9
Sheet: EPR Adj OpInc

 | Quarters Ended |  |  |  | Six Months Ended
 | March 31, |  |  |  | March 31,
 | 2012 |  | 2011 |  | 2012 |  | 2011
Adjusted Operating Income and Margin
GAAP operating income | 118 |  | 128.1 |  | 217.9 |  | 248.3
Amortization of acquired intangibles in cost of gaming operations | 2.3 |  | 0 |  | 2.3 |  | 0
Total adjustments to operating expenses (below) | 23.9 |  | 3.2 |  | 23.7 |  | 3.7
Adjusted operating income | 144.2 |  | 131.3 |  | 243.9 |  | 252
Adjusted operating margin | 0.2664449371766444 |  | 0.2752620545073375 |  | 0.2471625456019457 |  | 0.2714932126696832
Adjusted Operating Expenses
GAAP operating expenses | 195.6 |  | 154.5 |  | 347.7 |  | 303.7
Acquisition related charges:
Contingent costs | -11.7 |  | 0 |  | -11.7 |  | 0
Amortization of intangibles | -3.9 |  | 0 |  | -3.9 |  | 0
Professional fees | -4.5 |  | 0 |  | -5.7 |  | 0
Severance | -1.2 |  | 0 |  | -1.2 |  | 0
Distributor settlement | -3.1 |  | 0 |  | -3.1 |  | 0
Bad debt provision | 0.5 |  | -3.2 |  | 1.9 |  | -3.7
Total adjustments | -23.9 |  | -3.2 |  | -23.7 |  | -3.7
Adjusted operating expenses | 171.7 |  | 151.3 |  | 324 |  | 300
% of revenue | 0.3172579453067257 |  | 0.3171907756813417 |  | 0.3283340089177139 |  | 0.3232062055591467
Adjusted operating income, Adjusted operating margin, and Adjusted operating expenses are supplemental non-GAAP financial measures commonly used by management and industry analysts to evaluate our financial and operating performance.  Adjusted operating margin is a measure of adjusted operating income as a percentage of total revenues. Adjusted operating income, adjusted operating margin, and adjusted operating expenses, should not be construed as alternatives to operating income, operating margin, and operating expenses, respectively, as indicators of operating performance determined in accordance with GAAP (generally accepted accounting principles).  All companies do not calculate adjusted operating income, adjusted operating margin, and adjusted operating expenses in the same manner and IGT's presentation may not be comparable to that of other companies.
Spreadsheet: 752964d1635154726-move-start-of-week-to-new-tab-week-example-pr1
Sheet: March

 | Week
 | 1
 |  | day | date
 |  | Sunday
 |  | Monday
 |  | Tuesday
 |  | Wednesday
 |  | Thursday
 |  | Friday
 |  | Saturday
 | Week
 | 2 | commencing date:
 |  | day | date
 |  | Sunday
 |  | Monday
 |  | Tuesday
 |  | Wednesday
 |  | Thursday
 |  | Friday
 |  | Saturday
 | Week
 | 3 | commencing date:
 |  | day | date
 |  | Sunday
 |  | Monday
 |  | Tuesday
 |  | Wednesday
 |  | Thursday
 |  | Friday
 |  | Saturday
 | Week
 | 4 | commencing date:
 |  | day | date
 |  | Sunday
 |  | Monday
 |  | Tuesday
 |  | Wednesday
 |  | Thursday
 |  | Friday
 |  | Saturday
 | Week
 | 5 | commencing date:
 |  | day | date
 |  | Sunday
 |  | Monday
 |  | Tuesday
 |  | Wednesday
 |  | Thursday
 |  | Friday
 |  | Saturday
Spreadsheet: 844517d1696297179-formula-trying-to-lookup-a-value-in-a-matrix-pbrebate
Sheet: Sheet1

 |  | Business Line |  |  |  |  |  |  |  | *color coded manually to show
 | customer | 1 | 2 | 3 |  |  | customer | [NAME] | rebate | Correct answer
 | Ford | 0.02 | 0.03 | 0.04 |  |  | Ford | 1
 | Ford | 0.34 | 0.05 | 0.64 |  |  | Ford | 2
 | Chevy | 0.03 | 0.46 | 0.07 |  |  | Chevy | 1
 | Chevy | 0.06 | 0.67 | 0.04 |  |  | Chevy | 3
 | Toyota | 0.07 | 0.06 | 0.03 |  |  | Toyota | 1
 | Toyota | 0.08 | 0.09 | 0 |  |  | Toyota | 2
Spreadsheet: 752690d1634905091-deleting-certain-values-book2
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 6 | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 7 |  |  | 7 | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 9 |  |  | 9 | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2 |  | 2 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 3 |  | 3 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 7 |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 1 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 2 | 2 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 6 |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 8 |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 9
Spreadsheet: 03dbe0c4-a774-485a-b7a8-661fb6dc16e9
Sheet: 2012 math grade 7

[NAME] |  | Total Number | [NAME]
Grade 7 |  |  | Inconclusive | Exploring | Emerging | Developing | Novice | No Score
2010 | All Students | 570 | 14 | 17 | 25 | 22 | 14 | 7
2011 |  | 597 | 10 | 19 | 24 | 24 | 17 | 6
2012 | All Students | 554 | 13 | 19 | 22 | 21 | 18 | 6
 | Black or African American | 42 | 7 | 19 | 24 | 14 | 31 | 5
 | Hispanic or Latino | 183 | 12 | 19 | 27 | 22 | 13 | 7
 | White | 300 | 15 | 18 | 20 | 22 | 20 | 6
 | Minority | 254 | 11 | 20 | 25 | 20 | 16 | 7
 | English Learners | 81 | 9 | 15 | 28 | 28 | 12 | 7
 | Free/Reduced Lunch | 292 | 10 | 18 | 25 | 24 | 18 | 4
 | Female | 205 | 14 | 22 | 20 | 23 | 15 | 6
 | Male | 349 | 13 | 17 | 23 | 20 | 20 | 6
Spreadsheet: 689247d1596214265-summing-cells-with-the-highest-priority-first-book1-18-
Sheet: Sorted

 | Budget >> | 4000 | 20000 | 23000 | 41000 | 50000 | 50000 | 2000
Appropriation Year | Overall Priority | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 | 2025
2019 | 38 | 2000
2019 | 45 | 4574 |  |  |  |  |  |  |  | Sorted by Year, then Priority
2019 | 51 | 5847
2020 | 6 |  | 7714
2020 | 8 |  | 9232
2020 | 9 |  | 3000
2020 | 12 |  | 2530
2020 | 13 |  | 5136
2020 | 22 |  | 6856
2020 | 24 |  | 6866
2020 | 27 |  | 9877
2020 | 28 |  | 9965
2020 | 29 |  | 6118
2020 | 30 |  | 4763
2020 | 31 |  | 2158
2020 | 32 |  | 6064
2020 | 35 |  | 3618
2020 | 48 |  | 7222
2021 | 2 |  |  | 5511
2021 | 3 |  |  | 4888
2021 | 4 |  |  | 9121
2021 | 10 |  |  | 1127
2021 | 11 |  |  | 1383
2021 | 14 |  |  | 8231
2021 | 16 |  |  | 9737
2021 | 17 |  |  | 8358
2021 | 18 |  |  | 3078
2021 | 19 |  |  | 7771
2021 | 21 |  |  | 2305
2021 | 23 |  |  | 1852
2021 | 25 |  |  | 3567
2021 | 26 |  |  | 1108
2021 | 33 |  |  | 8501
2021 | 34 |  |  | 2194
2021 | 36 |  |  | 3789
2021 | 37 |  |  | 8390
2021 | 39 |  |  | 1612
2021 | 43 |  |  | 2671
2021 | 49 |  |  | 3147
2021 | 52 |  |  | 1423
2021 | 53 |  |  | 2489
2021 | 55 |  |  | 4133
2021 | 56 |  |  | 7022
2021 | 57 |  |  | 8685
2021 | 58 |  |  | 4793
2021 | 59 |  |  | 5427
2021 | 60 |  |  | 6394
2021 | 88 |  |  | 5017
2021 | 95 |  |  | 1659
2021 | 96 |  |  | 4869
2022 | 15 |  |  |  | 8131
2022 | 20 |  |  |  | 9550
2022 | 40 |  |  |  | 9478
2022 | 41 |  |  |  | 4896
2022 | 42 |  |  |  | 8070
2022 | 65 |  |  |  | 3869
2022 | 70 |  |  |  | 9597
2022 | 72 |  |  |  | 2217
2022 | 73 |  |  |  | 1433
2022 | 75 |  |  |  | 2484
2022 | 83 |  |  |  | 6377
2022 | 92 |  |  |  | 6661
2023 | 44 |  |  |  |  | 7549
2023 | 46 |  |  |  |  | 5893
2023 | 54 |  |  |  |  | 5871
2023 | 62 |  |  |  |  | 3266
2023 | 63 |  |  |  |  | 6310
2023 | 64 |  |  |  |  | 9130
2023 | 66 |  |  |  |  | 1731
2023 | 67 |  |  |  |  | 1619
2023 | 68 |  |  |  |  | 8429
2023 | 69 |  |  |  |  | 1656
2023 | 71 |  |  |  |  | 2756
2023 | 74 |  |  |  |  | 1802
2023 | 76 |  |  |  |  | 4509
2023 | 82 |  |  |  |  | 5135
2023 | 94 |  |  |  |  | 1630
2024 | 77 |  |  |  |  |  | 7351
2024 | 78 |  |  |  |  |  | 2527
2024 | 79 |  |  |  |  |  | 4334
2024 | 80 |  |  |  |  |  | 5257
2024 | 81 |  |  |  |  |  | 2098
2024 | 84 |  |  |  |  |  | 2806
2024 | 85 |  |  |  |  |  | 1538
2024 | 87 |  |  |  |  |  | 7525
2024 | 89 |  |  |  |  |  | 9805
2024 | 90 |  |  |  |  |  | 3081
2024 | 91 |  |  |  |  |  | 7681
2024 | 93 |  |  |  |  |  | 6727
2024 | 97 |  |  |  |  |  | 7938
2024 | 98 |  |  |  |  |  | 6667
2024 | 99 |  |  |  |  |  | 7586
2024 | 100 |  |  |  |  |  | 8846
2025 | 47 |  |  |  |  |  |  | 5072
Spreadsheet: 871699d1718116677-in-need-of-formulas-to-combine-the-data-from-3-sheets-into-1-sheet-overall-list-overall-list
Sheet: Overall List

S.N. | Identity No. | Category | Discipline | Document Type | Document No. | Rev. No. | Document Title | Created Date | Submitted Date | Created By | Status
1 | Q2-1 | Hydrostatic Test Package | Piping | Test Package | U862-FW-001 | 00 | U862-FW-001_Hydro Test | 2023-07-18 00:00:00 | 2023-07-22 00:00:00 | AHMADOS | Closed
2 | Q2-2 | Hydrostatic Test Package | Piping | Test Package | U861-FW-013 | 00A | U861-FW-013_Hydro Test | 2023-08-27 00:00:00 | 2023-08-27 00:00:00 | SYEDASOF | Open
3 | Q2-3 | Hydrostatic Test Package | RTR | Test Package | U861-FW-034 | 00D | U861-FW-034_Hydro Test | 2023-09-06 00:00:00 | 2023-09-06 00:00:00 | JAYAKUMB | Closed
4 | A1-1 | Quality Audit Schedule | QA | Report | PM-PD-6000 | 00 | Internal Quality Audit Schedule-1 | 2022-11-24 00:00:00 | 2022-11-27 00:00:00 | SK817811 | Closed
5 | A1-2 | Quality Audit Schedule | QA | Report | PM-PD-6004 | 00A | Internal Quality Audit Schedule-2 | 2023-06-05 00:00:00 | 2023-06-20 00:00:00 | JC752585 | Closed
6 | A1-3 | Quality Audit Schedule | QA | Report | PM-PD-6007 | 01 | Internal Quality Audit Schedule-3 | 2024-01-29 00:00:00 | 2024-01-29 00:00:00 | AR419672 | Open
7 | A1-4 | Quality Audit Schedule | QA | Report | PM-PD-6008 | A4 | Internal Quality Audit Schedule-4 | 2024-05-11 00:00:00 | 2024-05-11 00:00:00 | AU034083 | Open
8 | Q1-1 | Special Process Procedures & Personnel | Civil | Quality Test Report | CV-TEST-039 | NA | Quality Test Report_16 to 31 October 2023 | 2024-02-03 00:00:00 | 2024-02-04 00:00:00 | JJ654274 | Open
9 | Q1-2 | Special Process Procedures & Personnel | Piping | Procedure | PI-PD-7017 | A3 | Lay-Up Procedure for Piping | 2023-10-29 00:00:00 | 2023-11-05 00:00:00 | AR419672 | Closed
10 | Q1-3 | Special Process Procedures & Personnel | Mechanical | [NAME] | ME-PD-7814 | A2 | Method Statement for Vacuum Box Testing Field | 2023-12-11 00:00:00 | 2023-12-12 00:00:00 | NA340127 | Closed
11 | Q1-4 | Special Process Procedures & Personnel | Civil | Laboratory Approval | LAB-ACES-003 | R1 | Request for Approval of ACES Lab | 2024-04-29 00:00:00 | 2024-04-29 00:00:00 | AU034083 | Open
12 | Q1-5 | Special Process Procedures & Personnel | Piping | JCC for Pipe Work | JFGP3-DA-W-143 | NA | JCC for Welder_LOUIE DIGNOS_GTAW | 2024-06-08 00:00:00 | 2024-06-08 00:00:00 | AR419672 | Closed
13 | Q1-6 | Special Process Procedures & Personnel | Electrical | ITP | PM-PD-6222 | 00 | HDTIP-E-005_for Galvanic Cathodic Protection - Pin Brazing | 2024-05-30 00:00:00 | 2024-06-05 00:00:00 | AU034083 | Closed
 | In RED colour fonts are the EXPECTED RESULTS which came from [NAME], Q1 and Q2
Spreadsheet: 1de2ef0e-999d-40eb-863d-cf023a8ab332
Sheet: R

Course color corresponds with term of offering.  ORANGE for Fall semester, PURPLE for J-term, GREEN for both Fall and J-term.
 | AOK Designation | CAR Designation | Comment
Religious Studies
RELS 112 | Civilizations-Philosophy & Religious Studies
RELS 205 | Civilizations-Philosophy & Religious Studies
RELS 210 | Civilizations-Philosophy & Religious Studies
RELS 211 | Civilizations-Philosophy & Religious Studies
RELS 212 | Civilizations-Philosophy & Religious Studies
RELS 215 | Civilizations-Philosophy & Religious Studies
RELS 217 | Civilizations-Philosophy & Religious Studies
RELS 221 | Civilizations-Philosophy & Religious Studies | Non-Western
RELS 222 | Civilizations-Philosophy & Religious Studies
RELS 223 | Civilizations-Philosophy & Religious Studies | Non-Western
RELS 225 | Civilizations-Philosophy & Religious Studies | Non-Western
RELS 227 | Civilizations-Philosophy & Religious Studies
RELS 228 | Civilizations-Philosophy & Religious Studies
RELS 229 | Civilizations-Philosophy & Religious Studies | Non-Western
RELS 230 | Civilizations-Philosophy & Religious Studies
RELS 231 | Civilizations-Philosophy & Religious Studies
RELS 235 | Civilizations-Philosophy & Religious Studies
RELS 237 | Civilizations-Philosophy & Religious Studies
RELS 240 | Civilizations-Philosophy & Religious Studies | Experiential-Travel
RELS 243 | Civilizations-Philosophy & Religious Studies | Experiential-Travel
RELS 245 | Civilizations-Philosophy & Religious Studies | Experiential-Travel; Non-Western
RELS 247 | Civilizations-Philosophy & Religious Studies | Experiential-Travel | J-Term 2012
RELS 248 | Civilizations-Philosophy & Religious Studies | Experiential-Travel; Non-Western
RELS 251 | Civilizations-Philosophy & Religious Studies
RELS 260 | Civilizations-Philosophy & Religious Studies | Non-Western
RELS 262 | Civilizations-Philosophy & Religious Studies
RELS 271 | Civilizations-Philosophy & Religious Studies
RELS 273 | Civilizations-Philosophy & Religious Studies
RELS 274 | Civilizations-Philosophy & Religious Studies
RELS 275 | Civilizations-Philosophy & Religious Studies
RELS 311 | Civilizations-Philosophy & Religious Studies
RELS 312 | Civilizations-Philosophy & Religious Studies
RELS 323 | Civilizations-Philosophy & Religious Studies
RELS 335 | Civilizations-Philosophy & Religious Studies
RELS 336 | Civilizations-Philosophy & Religious Studies
RELS 343 | Civilizations-Philosophy & Religious Studies
RELS 352 | Civilizations-Philosophy & Religious Studies
RELS 375 | Civilizations-Philosophy & Religious Studies
RELS 381 | Civilizations-Philosophy & Religious Studies | Experiential-Travel | J-Term 2014 (Early Christianity)
RELS 384 | Civilizations-Philosophy & Religious Studies
RELS 401 |  | Capstone
RELS 487-488 |  | Experiential-Research
RELS 491-492 |  | Experiential-Research
RELS 496-498 |  | Experiential-Research
Spreadsheet: 168744d1342555539-transpose-rows-of-various-lengths-excelexample
Sheet: Start

[NAME] | User Name | Applications
Machine #1 | User #1 | Application #1
Machine #1 | User #1 | Application #2
Machine #1 | User #1 | Application #3
Machine #1 | User #1 | Application #4
Machine #2 | User #2 | Application #11
Machine #2 | User #2 | Application #12
Machine #2 | User #2 | Application #13
Machine #3 | User #3 | Application #1
Machine #3 | User #3 | Application #12
Machine #3 | User #3 | Application #3
Machine #3 | User #3 | Application #14
Machine #3 | User #3 | Application #5
Machine #4 | User #4 | Application #21
Machine #4 | User #4 | Application #2
Machine #5 | User #5 | Application #1
Machine #5 | User #5 | Application #22
Machine #5 | User #5 | Application #31
Machine #5 | User #5 | Application #4
Machine #6 | User #6 | Application #1
Machine #6 | User #6 | Application #32
Machine #7 | User #7 | Application #1
Machine #7 | User #7 | Application #23
Machine #8 | User #8 | Application #13
Machine #8 | User #8 | Application #12
Machine #8 | User #8 | Application #13
Machine #8 | User #8 | Application #42
Machine #9 | User #9 | Application #10
Machine #9 | User #9 | Application #22
Machine #9 | User #9 | Application #33
Machine #10 | User #10 | Application #15
Machine #10 | User #10 | Application #25
Machine #10 | User #10 | Application #13
Spreadsheet: 1acbc5b5-eba7-43ce-aba6-394b78c6d600
Sheet: CIS

 | PROGRAM LEVEL | # | SLOs | # | ASSESSMENT METHOD DEFINED | # | ASSESSED  COURSE | # | DISCUSSION/ IMPROVEMENT | #
 | A.S. Degree Computer Information Science | 1 | X | 1
 | 3D Computer Animation Certificate | 1 | X | 1
 | Computer Assisted Graphic Design Certificate | 1 | X | 1
 | Cisco Certified Network Associate Certificate | 1 | X | 1 | X | 1 | X | 1 | X | 1
 | Computer Hardware  Technician Certificate | 1 | X | 1
 | Computer Information Systems Certificate | 1 | X | 1
 | Programming Certificate | 1 | X | 1
 | Web Design Certificate | 1 | X | 1
 | Webmaster I Certificate | 1 | X | 1
 | TOTAL
 | PERCENTAGE
 | COURSE
5 | CIS 062 | 1
4 | CIS 091 | 1 | X | 1
2 | CIS 101 | 1 | X | 1 | X | 1 | X | 1 | X | 1
5 | CIS 104 | 1 | X | 1 | X | 1
5 | CIS 105 | 1 | X | 1 | X | 1
4 | CIS 111 | 1 | X | 1 | X | 1 | X | 1 | X | 1
4 | CIS 113 | 1 | X | 1 | X | 1 | X | 1 | X | 1
3 | CIS 114 | 1 | X | 1 | X | 1 | X | 1 | X | 1
3 | CIS 116 | 1 | X | 1 | X | 1
5 | CIS 117 | 1
5 | CIS 118 | 1
4 | CIS 125 | 1 | X | 1 | X | 1
4 | CIS 130 | 1 | X | 1 | X | 1
4 | CIS 140X2 | 1 | X | 1 | X | 1 | X | 1 | X | 1
4 | CIS 141X2 | 1 | X | 1 | X | 1 | X | 1 | X | 1
4 | CIS 142X2 | 1 | X | 1 | X | 1 | X | 1 | X | 1
4 | CIS 143X2 | 1 | X | 1 | X | 1 | X | 1 | X | 1
5 | CIS 152 | 1
5 | CIS 160 | 1
5 | CIS 161 | 1 | X | 1 | X | 1 | X | 1 | X | 1
5 | CIS 162 | 1 | X | 1 | X | 1 | X | 1 | X | 1
4 | CIS 163 | 1 | X | 1 | X | 1 | X | 1 | X | 1
4 | CIS 165X3 | 1 | X | 1 | X | 1 | X | 1 | X | 1
4 | CIS 166 | 1 | X | 1 | X | 1 | X | 1 | X | 1
5 | CIS 168 | 1
5 | CIS 171 | 1
5 | CIS 175 | 1
5 | CIS 180 | 1 | X | 1 | X | 1 | X | 1 | X | 1
5 | CIS 184 | 1
5 | CIS 190A | 1 | X | 1 | X | 1 | X | 1 | X | 1
5 | CIS 190B | 1 | X | 1 | X | 1 | X | 1 | X | 1
5 | CIS 190C | 1 | X | 1 | X | 1 | X | 1 | X | 1
5 | CIS 195A-Z | 1
5 | CIS 198 | 1
5 | CIS 203 | 1
4 | CIS 211 | 1 | X | 1 | X | 1 | X | 1 | X | 1
4 | CIS 900X4 | 1 | X | 1
 | TOTAL
 | PERCENTAGE
Spreadsheet: 742244d1627620360-trying-to-interpolate-a-table-aviation-help-please-aligw
Sheet: Sheet1

Altitude (1,000ft) | Weight (tonnes)
 | 85 | 80 | 75 | 70 | 65 | 60 | 55 | 50 | 45 | 40
41 |  |  |  |  | 30 | 7 | 0 | 4 | 16 | 33
 |  |  |  | 22 | 4 | 0 | 4 | 15 | 30 | 45
 |  | 37 | 14 | 2 | 0 | 5 | 15 | 28 | 43 | 56
 | 23 | 7 | 0 | 0 | 6 | 16 | 28 | 41 | 54 | 64
 | 2 | 0 | 2 | 8 | 18 | 29 | 41 | 53 | 62 | 68
 | 0 | 4 | 11 | 21 | 31 | 42 | 52 | 61 | 67 | 70
 | 7 | 15 | 24 | 34 | 43 | 53 | 61 | 67 | 70 | 70
 | 19 | 27 | 36 | 45 | 54 | 61 | 66 | 70 | 70 | 68
 | 31 | 40 | 48 | 55 | 62 | 67 | 70 | 70 | 69 | 64
 | Question
 | What value is obtained from the table for a aircraft weight of 58 tonnes at a altitude of 32,000ft?
 | Manual caluclation
 | - Interpolate between 60 & 55 tonnes for both 33,000 and 31,000ft.
 | - copying data from the table and interpolating for 58 tonnes on the x axis
 |  |  |  |  |  |  |  | How do I build a formula for these input fields
 | - now interpolating the 58 tonne data in the Y axis |  |  |  |  |  |  |  | Weight = | 58
 |  |  |  |  |  |  |  |  | Altitude = | 32
 |  |  |  |  |  |  |  |  | Answer =
 | - Answer is 42.1
 | Now how do I build a workbook such that I can have input fields for weight and altitude and a forumla calculates the correct output
Spreadsheet: 136520d1326706372-excel-2007-using-countif-to-calculate-values-for-a-4th-cell-tcas-1-
Sheet: Sheet1

A/1 | B | C | D | E | F | G | H | I | J |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Location |  | MM |  | Clean
2 | Date | Location | MM | Unit 1 | Unit 2 | Unit 3 | Coaches | Clean | Rating |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GLD |  | WAH |  | Standard
3 | 13.01.12 | GLD | WAH | 150034 |  |  |  | Turn Around | 0.735 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BM |  | RO |  | Turn Around
4 | 13.01.12 | BM | ATB | 144202 | 150132 |  |  | Standard | 0.66 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FNH |  | ATB
5 | 13.01.12 | BM | ATB | 150008 | 150034 | 150323 |  | Standard | 0.568 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WOK |  | RB
6 | 13.01.12 | FNH | RO | 445708 | 445292 |  |  | Standard | 0.99
7 | 14.01.12 | WOK | RB | 144087 | 144034 |  |  | Turn Around | 0.55
8 | 14.01.12 | FNH | WAH | 150123 | 150067 |  |  | Standard | 0.556
9 | 14.01.12 | WOK | RB | 158008 | 158028 |  |  | Standard | 0.44
Spreadsheet: 466767d1466439802-what-is-the-best-formula-for-a-lottery-worksheet-tpp-lottery-bsb-
Sheet: Sheet1

Draw Numbers | 26 | 32 | 31 | 18 | 5 | 47
 |  |  |  |  |  |  | # of Matches
Player 1
Player 2
Player 3
Player 4
Player 5
Player 6
Player 7
Player 8
Player 9
Player 10
 |  |  | Press F9 to randomly generate player picks.
Spreadsheet: 454782d1459969758-index-match-formula-issue-comparing-dates-in-4-columns-to-return-a-value-index
Sheet: Result

 |  |  |  | Standard Start Dates | Standard End Dates | S# |  | Start date | End Date | Which Session?
 |  |  |  | 2016-05-16 00:00:00 | 2016-08-09 00:00:00 | S1 |  | 2016-05-16 00:00:00 | 2016-08-09 00:00:00 | S1
 |  |  |  | 2016-05-16 00:00:00 | 2016-06-27 00:00:00 | S2 |  | 2016-05-16 00:00:00 | 2016-06-27 00:00:00 | S2
 |  |  |  | 2016-06-28 00:00:00 | 2016-08-09 00:00:00 | S3 |  | 2016-05-16 00:00:00 | 2016-08-09 00:00:00 | S1
 |  |  |  | 2016-06-13 00:00:00 | 2016-08-09 00:00:00 | [NAME] |  | 2016-06-13 00:00:00 | 2016-08-09 00:00:00 | [NAME]
 |  |  |  |  |  |  |  | 2016-05-16 00:00:00 | 2016-08-09 00:00:00 | S1
Spreadsheet: 39139d1237333541-linking-cells-on-one-page-to-cells-on-another-page-sample
Sheet: UNIT COSTS

 | UNIT COST MATRIX | PREPARED BY:
 |  | LA
 |  | Quantity | Unit | Unit Price
 | SITE PREPARATION
 | MISC CLEARING | 2469 | SF | 0.5
 | FINE GRADING | 2469 | SF | 0.3
 | SOIL AMENDMENTS | 12 | CY | 32
 | IRRIGATION SYSTEM
 | SOD LAWN |  | LF | 0.75
 | 15 GALLON TREE |  | EA | 225
 | 5 GALLON SHRUB (.111xsf) |  | EA | 100
 | 3" N.P.W. SERVICE & METER |  | EA | 8000
 | HYDRANT RELOCATION |  | LS | 2250
 | 1 GALLON VINE/GROUNDCOVER |  | EA | 30
 | 2" WATER SERVICE & METER |  | EA | 3000
 | INSTALL SCH40 MAINLINE |  | LF | 30
 | INSTALL [NAME] LINE |  | LF | 30
 | POP UP SPRINKLERS (.05xsf) |  | EA | 70
 | HYDRANT, BURY, AND GATE VALVE |  | EA | 3000
 | 1" HOUSE/BUSINESS SERVICE |  | EA | 1500
 | 1" WATER SERVICE & METER |  | EA | 2000
 | 6" N.P.W. PVC PIPE (C900) |  | LF | 70
 | REMOTE CONTROL VALVE |  | EA | 750
 | BRONZE SHUT OFF VALVE |  | EA | 750
 | BACKFLOW PREVENTOR WITH STRONGBOX |  | EA | 5000
 | 8 STATION IRRIGATION CONTROLLER |  | EA | 2500
 |  |  |  | .
Spreadsheet: 803085d1667240804-check-if-there-is-duplicated-records-in-date-range-duplicated-in-date-range-_-etaf-3-
Sheet: Sheet1

 | Main |  |  |  |  |  | Second
 | # | Code | Date | Excepted result | [NAME] |  | # | Code | Date
 | 1 | 22 | 2022-10-25 00:00:00 | Yes |  |  | 1 | 22 | 2022-11-11 00:00:00
 | 2 | 33 | 2022-09-10 00:00:00 | Yes |  |  | 2 | 33 | 2022-11-11 00:00:00
 | 3 | 33 | 2022-09-11 00:00:00 | Yes |  |  | 3 | 33 | 2022-11-11 00:00:00
 | 4 | 11 | 2022-01-01 00:00:00 | Yes |  |  | 4 | 11 | 2022-01-02 00:00:00
 | 5 | 22 | 2022-10-27 00:00:00 | Yes |  |  | 5 | 22 | 2022-11-11 00:00:00
 | 6 | 77 | 2022-01-01 00:00:00 | No |  |  | 6 | 77 | 2022-11-11 00:00:00
 | 7 | 99 | 2022-01-01 00:00:00 | No |  |  | 7 | 99 | 2022-11-11 00:00:00
 | 8 | 66 | 2022-01-01 00:00:00 | No |  |  | 8 | 66 | 2022-11-11 00:00:00
 | 9 | 22 | 2022-10-20 00:00:00 | No |  |  | 9 | 22 | 2022-11-11 00:00:00
 | 10 | 88 | 2022-01-01 00:00:00 | No |  |  | 10 | 88 | 2022-11-11 00:00:00