tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 15a3ae78-6fe3-4233-b44f-e25199e3f8cb
Sheet: Sheet1

Title | Creator/Author | Publication Date | OSTI Identifier | Report Number(s) | DOE Contract Number | Other Number(s) | Resource Type | Specific Type | Resource Relation | Research Org. | Sponsoring Org. | Subject | Related Subject | Description/Abstract | Contributor Organizations | Host Website | Format | Availability | DOI | Full Text
Image Bank from Interactions.org |  |  | 1077276 |  |  |  | Collection | Still Images or Photos |  | OSTI | USDOE - Office of Science (SC); National Research Council of Canada (NRC); NSERC, National Science and Engineering Research Council (NSERC, Canada); National Science Foundation of China; Ministry of Science and Technology of China; CNRS, France; IN2P3, France; Federal Ministry for Education and Research, Germany; Department of Science and Health (BWG) of the City of Hamburg; Ministry for Science, Research and Culture (MWFK) of the State of Brandenburg; INFN, Italy; MONKASHO (Japan); FOM (The Netherlands); PPARC (UK); Office of Science and Technology (UK); Dept. of Trade and Industry (UK); NSF; NASA | 43 - PARTICLE ACCELERATORS; 72 - PHYSICS OF ELEMENTARY PARTICLES AND FIELDS | Accelerators; Linacs, Synchrotrons, Storage rings; Detectors; [NAME]; Particle collisions; Event displays; Superconductivity; Cosmic physics | Interactions.org is designed to serve as a central resource for communicators of particle physics. The site is updated daily with news, information, images and links from the world of particle physics.  It provides links to current particle physics news from the world&#x27;s press, links to education and outreach programs; information about science policy and funding; links to universities; a glossary; and a conference calendar. The Image Bank provides high-resolution photos and graphics from the particle physics laboratories of the world, including Argonne National Laboratory (ANL), Brookhaven National Laboratory (BNL); Fermi National Accelerator Laboratory (FNAL), Lawrence Berkeley National Laboratory (LBNL), and Stanford Linear Accelerator Center (SLAC).  The Interactions.org website was developed and is jointly maintained by the InterAction collaboration, whose members represent the world&#x27;s particle physics laboratories in Europe, North America and Asia, with funding provided by science funding agencies of many nations.  See also the videos and animations available at this site. | InterAction Collaboration; Argonne National Laboratory (ANL); Brookhaven National Laboratory (BNL); Fermi National Accelerator Center (FNAL); Lawrence Berkeley National Laboratory (LBNL); Stanford Linear Accelerator Center (SLAC) | Interactions.org |  | Specialized interface available |  | http://www.osti.gov/dataexplorer/servlets/purl/1077276
Spreadsheet: 288826d1389308938-multi-sheet-workbook-with-summary-page-quote-log-2
Sheet: Sheet3

Date | Product | Quote | PO | Client | Comments
2014-01-10 00:00:00 | spoons | 9000 | 9500 | m
2014-01-10 00:00:00 | forks | 8000 | 8800 | mn
2014-01-10 00:00:00 | knives | 7000 | 8000 | mn
Spreadsheet: 113099d1309034750-attempting-to-create-a-formula-code-to-have-excel-automatically-move-a-column-over-scratchers-20form_after-1-
Sheet: Sales

LOTTERY SALES
BOX | PREVIOUS DAY | TODAY | # [NAME] | $ [NAME]
1 |  |  |  |  | 1
2 |  |  |  |  | 1
3 |  |  |  |  | 1
4 |  |  |  |  | 1
5 |  |  |  |  | 2
6 |  |  |  |  | 2
7 |  |  |  |  | 2
8 |  |  |  |  | 2
9 |  |  |  |  | 3
10 |  |  |  |  | 3
11 |  |  |  |  | 3
12 |  |  |  |  | 3
13 |  |  |  |  | 5
14 |  |  |  |  | 5
15 |  |  |  |  | 5
16 |  |  |  |  | 5
 |  | Scratcher Sales = |  | 0
 |  | Lottery Sales = |  | 340
 |  | Actual Sales = |  | 340
 |  | Report Sales = |  | 450
 |  | Over/Short = |  | 110
Spreadsheet: 868441d1715175527-sort-function-broken-keep-dreaming-league-standings
Sheet: LEADERBOARD

 |  |  |  | THE KEEP DREAMING LEAGUE
 |  |  | "KEEPING THE DREAM ALIVE, ONE TOURNAMENT AT A TIME"
 |  |  | RANK | PLAYER | W | L | BIG DOG | LITTLE DOG | PTS | W PCT | PF | PA | P +/- | AVG W | AVG L | AVG PF | AVG PA
 |  |  |  | WAYNE
 |  |  |  | [NAME]
 |  |  |  | JASON
 |  |  |  | [NAME] MOUNTNEY
 |  |  |  | [NAME]
 |  |  |  | MIKE
 |  |  |  | [NAME]
 |  |  |  | PAUL
 |  |  |  |  | STANDINGS AFTER TOURNAMENT #6 - MAY 7, 2024
 |  |  |  |  |  | [NAME]:
 |  |  |  |  |  | If in the event that two (2) or more players are tied in points then the following tie breaks apply:
 |  |  |  |  |  | 1. The player with the most wins
 |  |  |  |  |  | 2. The player with the greater P +/-
 |  |  |  |  |  | 3. The player with the greater Average Wins
 |  |  |  |  |  | 4. The player with the fewest Average Losses
 |  |  |  |  |  | 5. The player with the greater Average Points Forward (AVG PF)
 |  |  |  |  |  | 6. The player with the fewest Average Points Against (AVG PA)
Spreadsheet: tracy_geaccone__40255__C0366-111727
Sheet: Dept_100182

ENRON PROPERTY & SERVICES CORP
1400 Smith Street
Houston, Texas   77251 - 1188
MONTHLY INVOICE DETAIL
BUILDING SERVICES - Dept. 100182
May, 2001
0366  EOC - Executive
Date | Ticket Number | Work Order | Service Name | Service Description | # [NAME] | Unit Cost | UOM | Service | Ticket
 |  |  |  |  |  |  |  | Total | Total
 |  |  | R/C 111727
2001-05-29 00:00:00 | BSV100182-2001-05-0366-111727 |  | Building Services | Sq. Ft. Occupied | 1619 | 0.03 | /EACH | 48.57
 |  |  |  |  |  |  | Ticket Total |  | 48.57
 |  |  |  |  |  |  | Total for R/C: 111727 |  | 48.57
 |  |  |  |  |  |  | Total for Dept_100182 |  | 48.57
Spreadsheet: 81765d1281942150-moving-values-from-rows-to-columns-741645_session13
Sheet: original

C1 | C2 | [NAME] | C4 | C5 | C6 | C7 | C8
c | c | c | c | c | 1 | [NAME] | V2.1
c | c | c | c | c | 2 | V1.2 | V2.2
c | c | c | c | c | 3 | V1.3 | V2.3
c | c | c | c | c | 4 | V1.4 | V2.4
c | c | c | c | c | 5 | V1.5 | V2.5
c | c | c | c | c | 6 | V1.6 | V2.6
c | c | c | c | c | 7 | V1.7 | V2.7
c | c | c | c | c | 8 | V1.8 | V2.8
c | c | c | c | c | 9 | V1.9 | V2.9
c | c | c | c | c | 10 | V1.10 | [NAME]
c | c | c | c | c | 11 | V1.11 | V2.11
c | c | c | c | c | 12 | V1.12 | V2.12
d | d | d | d | d | 1 | V1.13 | V2.13
d | d | d | d | d | 2 | V1.14 | V2.14
d | d | d | d | d | 3 | V1.15 | [NAME]
Spreadsheet: 146653d1332281679-help-with-chart-copy-of-profit-chart
Sheet: 2010

Profit Sharing % | 0.04776078160480889 | 0
Bonus % | 0.06174513845869693
Stockholders Investment | 50000
Adjusted Profits | 17904.08 | 30247.78000000001 | 57982.91 | 97715.98999999998 | 67778.52 | 104010.76 | 44000.90999999999 | 22571.87 | 48486.85999999999 | 63309.75 | 22348.21000000001 | 78889.09999999999 | 87963.65000000001 | 20788.45 | 95364.24999999999 | 17381.5 | 111738.52 | 34934.65999999999 | 237538.93 | 70281.28 | 98207.1 | 31942.73000000001 | 8001.570000000116 | -48631.84999999998
 | Jan |  | Feb |  | Mar |  | Apr |  | May |  | Jun |  | Jul |  | Aug |  | Sept |  | Oct |  | Nov |  | Dec
 | 2010 | 2009 | 2010 | 2009 | 2010 | 2009 | 2010 | 2009 | 2010 | 2009 | 2010 | 2009 | 2010 | 2009 | 2010 | 2009 | 2010 | 2009 | 2010 | 2009 | 2010 | 2009 | 2010 | 2009
Profit Sharing | 855.1128547150267 | 1444.657614610306 | 2769.309101321289 | 4666.992057687688 | 3237.155091217172 | 4967.635192910192 | 2101.517852922851 | 1078.050153482138 | 2315.770331162943 | 3023.723143205049 | 1067.367977068406 | 3767.805076099928 | 4201.212676811848 | 992.8726203524894 | 4554.671117156395 | 830.1540254639856 | 5336.719050564569 | 1668.506666698252 | 11345.04495836998 | 3356.688864986423 | 4690.447855141627 | 1525.609751391378 | 382.1612372655962 | -2322.695166887824
Bonus | 1105.489898575586 | 1867.653364168204 | 3580.162806188163 | 6033.487332178643 | 4184.994101925559 | 6422.158777394296 | 2716.842280258662 | 1393.703238421708 | 2993.827884127453 | 3909.069279535488 | 1379.893320754036 | 4871.018402381987 | 5431.327748582356 | 1283.585723591698 | 5888.278820259788 | 1073.223124119841 | 6899.310388569875 | 2157.045418707501 | 14666.87412218071 | 4339.527364654447 | 6063.810987127095 | 1972.308286598773 | 494.0580475369627 | -3002.780311752579
TOTAL | 1960.602753290613 | 3312.310978778511 | 6349.471907509453 | 10700.47938986633 | 7422.149193142731 | 11389.79397030449 | 4818.360133181513 | 2471.753391903845 | 5309.598215290396 | 6932.792422740536 | 2447.261297822442 | 8638.823478481916 | 9632.540425394203 | 2276.458343944188 | 10442.94993741618 | 1903.377149583826 | 12236.02943913444 | 3825.552085405753 | 26011.9190805507 | 7696.21622964087 | 10754.25884226872 | 3497.91803799015 | 876.2192848025588 | -5325.475478640403
 | 2010 | 2009
 | Total | Total
Profit Sharing | 42856.4901037177 | 25000
Bonus | 55404.87040608625 | 32320
Spreadsheet: 106453d1303745665-sumifs-across-sheets-copy-of-central-office-2010-2011-w-formulas
Sheet: IDD TOL

FIRST NAME | PRE-WORK | INITIAL VISIT | 5 DAY TRAINING COMPLETED | 4 WEEK VISIT | 8 WEEK VISIT | 14 WEEK BOOSTER | 20 WEEK VISIT | 24 WEEK SELF-ASSESSMENT | 27 WEEK CLOSURE | COMMENTS
 | 2 | 1 | 30 | 2 | 2 | 3 | 2 | 2 | 1
Jeanette |  |  |  |  |  |  |  |  |  |  |  | 424683
Antania |  |  |  |  |  |  |  |  |  |  |  | 646058
[NAME] |  |  |  |  |  |  |  |  |  |  |  | 495042
[NAME] |  |  |  |  |  |  |  |  |  |  |  | 71949
[NAME] |  |  |  |  |  |  |  |  |  |  |  | 439185
[NAME] |  |  |  |  |  |  |  |  |  |  |  | 608039
[NAME] |  |  |  |  |  |  |  |  |  |  |  | 462816
Arleathia |  |  |  |  |  |  |  |  |  |  |  | 25374
[NAME] |  |  |  |  |  |  |  |  |  |  |  | 72385
Meri |  |  |  |  |  |  |  |  |  |  |  | 544272
[NAME] |  |  |  |  |  |  |  |  |  |  |  | 647210
[NAME] |  |  |  |  |  |  |  |  |  |  |  | 608513
[NAME] |  |  |  |  |  |  |  |  |  |  |  | 438766
[NAME] |  |  |  |  |  |  |  |  |  |  |  | 494815
[NAME] |  |  |  |  |  |  |  |  |  |  |  | 71810
[NAME] |  |  |  |  |  |  |  |  |  |  |  | 525136
[NAME] |  |  |  |  |  |  |  |  |  |  |  | 45967
[NAME] |  |  |  |  |  |  |  |  |  |  |  | 56717
Daryl |  |  |  |  |  |  |  |  |  |  |  | 515249
Michelle |  |  |  |  |  |  |  |  |  |  |  | 49776
George |  |  |  |  |  |  |  |  |  |  |  | 489089
Avery |  |  |  |  |  |  |  |  |  |  |  | 628970
[NAME] |  |  |  |  |  |  |  |  |  |  |  | 432011
[NAME] |  |  |  |  |  |  |  |  |  |  |  | 392020
Becky |  |  |  |  |  |  |  |  |  |  |  | 620673
[NAME] |  |  |  |  |  |  |  |  |  |  |  | 87575
[NAME] |  |  |  |  |  |  |  |  |  |  |  | 194488
[NAME] |  |  |  |  |  |  |  |  |  |  |  | 35716
[NAME] |  |  |  |  |  |  |  |  |  |  |  | 679339
[NAME] |  |  |  |  |  |  |  |  |  |  |  | 515575
[NAME] |  |  |  |  |  |  |  |  |  |  |  | 455242
Spreadsheet: 146114d1331904951-extract-from-1-sheet-to-many-sum-total-not-working-extract-from-1-sheet-to-many-sheets
Sheet: GARY THORN

SAMPLE CYCLE TEST RUNS
[NAME] | TECHNICIAN | CYCLE A |  | CYCLE B |  | CYCLE C |  | CYCLE D |  | CYCLE E |  | CYCLE F
 |  | P | Chart | P | Chart | P | Chart | P | Chart | P | Chart | P | Chart
RUN 4 | [NAME] THORN | 7 | 16.A | 40 | 9.A | 27 | 4.DA | 29 | 11.AC |  | 7.ZB | 26 | 12.AE
RUN 9 | [NAME] THORN | 17 | 17.BB | 90 | 11.CB | 52 | 9.RR | 54 | 11.DB | 56 | 9.ZH |  | 16.DD
RUN 13 | [NAME] THORN | 25 | 12.A | 130 | 13.BB | 72 | 11.AH | 74 | 13.DF | 76 | 11.DX | 44 | 18.PO
RUN 14 | [NAME] THORN | 27 | 12.A | 140 | 15.DD | 77 | 11.AH | 79 | 13.DF | 81 | 11.DX | 46 | 18.PO
TOTALS |  | 76 |  | 400 |  | 228 |  | 236 |  | 213 |  | 116
Spreadsheet: 868029d1714735460-mapping-formula-help-test1
Sheet: YTD24

Test
Profit & Loss Account
 |  |  |  |  |  |  |  | YTD |  | YTD |  | YTD- 23 |  | Projected | Budget | Full year | Rolling 12m
 |  | Actual |  | Budget |  | Actual |  | Actual |  | Budget |  | Actual |  | Y/E 2024 | 2024 | 2023 | Actual
Turnover
Management & Supervision |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TUR001
Forest Planning & FSC Certification |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TUR002
Restock Planting |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TUR003
New Planting |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TUR004
Establishment, Maintenance & Protection |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TUR005
Cost+ Tender Contracts |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TUR006
Commission on Sales |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TUR007
Tree Safety & Consultancy |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TUR008
Mileage |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TUR009
Roads & New Fencing |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TUR010
Additional Turnover |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TUR011
Cost of Sales
Purchases |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | COS001
Restocking |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | COS002
New Planting |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | COS003
Establishment, Maintenance & Protection |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | COS004
Cost+ Tender Contracts |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | COS005
Roads & New Fencing |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | COS006
Additional COS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | COS007
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.3755219280242284
Spreadsheet: 437788d1451509746-delete-all-numbers-lower-than-a-certain-value-and-pull-data-to-the-left-book2
Sheet: Sheet1

1 | 1 | 1 | 1 | 1 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16
2 | 2 | 2 | 2 | 2 | 2 | 15 | 15 | 15 | 15 | 15 | 15 | 15
3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 12 | 12 | 12 | 12 | 12
16 | 16 | 16 | 16 | 16 | 16 | 16 | 16
15 | 15 | 15 | 15 | 15 | 15 | 15
12 | 12 | 12 | 12 | 12
Spreadsheet: 1acbc5b5-eba7-43ce-aba6-394b78c6d600
Sheet: ANAT

 | PROGRAM LEVEL | # | SLOs | # | ASSESSMENT METHOD DEFINED | # | ASSESSED COURSE | # | DISCUSSION/ IMPROVEMENT | #
 | Program | 1 | X | 1
 | TOTAL
 | PERCENTAGE
 | COURSE
5 | ANAT 101 | 1 | X | 1 | X | 1 | X | 1 | X | 1
5 | ANAT 150 | 1 | X | 1 | X | 1 | X | 1 | X | 1
5 | ANAT 151 | 1 | X | 1 | X | 1 | X | 1 | X | 1
5 | ANAT 159X4 | 1 | X | 1 | X | 1 | X | 1 | X | 1
 | TOTAL
 | PERCENTAGE
Spreadsheet: 3111ccc7-246f-4d12-a14d-fdae81dd413d
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5609.0 Housing Finance, Australia
 | TABLE 15. HOUSING FINANCE SEASONAL FACTORS, BY STATE
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
New South Wales ;  Number of Commitments ; |  |  | Original | A2433086W | 1975-10-01 00:00:00 | 2011-05-01 00:00:00 | 428 | Number | FACTOR | Month | 1
New South Wales ;  Value of Commitments ; |  |  | Original | A2433087X | 1975-10-01 00:00:00 | 2011-05-01 00:00:00 | 428 | Number | FACTOR | Month | 1
Victoria ;  Number of Commitments ; |  |  | Original | A2433088A | 1975-10-01 00:00:00 | 2011-05-01 00:00:00 | 428 | Number | FACTOR | Month | 1
Victoria ;  Value of Commitments ; |  |  | Original | A2433089C | 1975-10-01 00:00:00 | 2011-05-01 00:00:00 | 428 | Number | FACTOR | Month | 1
Queensland ;  Number of Commitments ; |  |  | Original | A2433090L | 1975-10-01 00:00:00 | 2011-05-01 00:00:00 | 428 | Number | FACTOR | Month | 1
Queensland ;  Value of Commitments ; |  |  | Original | A2433091R | 1975-10-01 00:00:00 | 2011-05-01 00:00:00 | 428 | Number | FACTOR | Month | 1
South Australia ;  Number of Commitments ; |  |  | Original | A2433092T | 1975-10-01 00:00:00 | 2011-05-01 00:00:00 | 428 | Number | FACTOR | Month | 1
South Australia ;  Value of Commitments ; |  |  | Original | A2433093V | 1975-10-01 00:00:00 | 2011-05-01 00:00:00 | 428 | Number | FACTOR | Month | 1
Western Australia ;  Number of Commitments ; |  |  | Original | A2433094W | 1975-10-01 00:00:00 | 2011-05-01 00:00:00 | 428 | Number | FACTOR | Month | 1
Western Australia ;  Value of Commitments ; |  |  | Original | A2433095X | 1975-10-01 00:00:00 | 2011-05-01 00:00:00 | 428 | Number | FACTOR | Month | 1
Tasmania ;  Number of Commitments ; |  |  | Original | A2433096A | 1975-10-01 00:00:00 | 2011-05-01 00:00:00 | 428 | Number | FACTOR | Month | 1
Tasmania ;  Value of Commitments ; |  |  | Original | A2433097C | 1975-10-01 00:00:00 | 2011-05-01 00:00:00 | 428 | Number | FACTOR | Month | 1
Northern Territory ;  Number of Commitments ; |  |  | Original | A2433098F | 1975-10-01 00:00:00 | 2011-05-01 00:00:00 | 428 | Number | FACTOR | Month | 1
Northern Territory ;  Value of Commitments ; |  |  | Original | A2433099J | 1975-10-01 00:00:00 | 2011-05-01 00:00:00 | 428 | Number | FACTOR | Month | 1
Australian Capital Territory ;  Number of Commitments ; |  |  | Original | A2433100F | 1975-10-01 00:00:00 | 2011-05-01 00:00:00 | 428 | Number | FACTOR | Month | 1
Australian Capital Territory ;  Value of Commitments ; |  |  | Original | A2433101J | 1975-10-01 00:00:00 | 2011-05-01 00:00:00 | 428 | Number | FACTOR | Month | 1
© Commonwealth of Australia  2010
Spreadsheet: 708867d1608051318-sum-of-selective-cells-by-logic-in-a-row-test6
Sheet: Test

 | Code-10 | Code-20 | Name | Code | Length | Name | Code | Length | Name | Code | Length | Name | Code | Length | Name | Code | Length
 | 700 | 300 | ABC | 10 | 100 | ABC | 10 | 200 | BCA | 20 | 250 | ABC | 10 | 400 | BCA | 20 | 50
 | SUM of cells before the code ABC=300+100+250 =650
Spreadsheet: 854065d1704030358-choose-col-with-with-filter-choose-cols-filter-with-remove-number-from-brackets-aligw
Sheet: Sheet3

 | CHOOSECOLS(FILTER(Sheet1!A6:[NAME]:[NAME]:B10<>"x")),2,3,4,11,17,18)
 | Your expected results:
 | 1 | 75 | The  American Insurance Company Limited. | 3 | 52 | 41
 |  | 3 | Tractors Service Pvt Ltd,Dysneyland |  | 30 | 25
 | 5 | 8 | Carnivalsepal Weight Services Pvt Ltd | 0 | 0 | 3
 | 7 | 9 | [NAME] ([NAME] ( (Main)) | 6 | 45 | 40
 | My formula:
 |  | 75 | The American Insurance Company Limited. | 3 | 52 | 41
 |  | 3 | Tractors Service Pvt Ltd,Dysneyland |  | 30 | 25
 | 5 | 8 | Carnivalsepal Weight Services Pvt Ltd | 0 | 0 | 3
 | 7 | 9 | [NAME] ([NAME] (Main)) | 6 | 45 | 40
Spreadsheet: 78433d1278781898-filter-on-multiple-columns-without-excluding-any-relevant-data-student-report
Sheet: data

Surname | Forename | subj 1 | exam1 | result | subj2 | exam2 | [NAME] | subj3 | exam3 | result3 | Subj 4 | exam4 | result 4 | subj 5 | exam5 | result 5 | Pupil #
[NAME] | Martin | Math | 76 | above | sicence | 37 | below | french | 60 | inline |  |  |  |  |  |  | 1231
[NAME] | Sara | Math | 40 | below | Sicence | 90 | above | spanish | 60 | inline |  |  |  |  |  |  | 1232
Whittaker | Scott | Math | 99 | Above | Sicence | 99 | Above | Engilsh | 10 | Below | Spanglish | 99 | Above | French | 20 | below | 9999
Spreadsheet: 104623d1302161380-searching-data-through-out-the-worksheet-stock-statement-on-7-4-2011
Sheet: LOCAL ITEMS

S.No | [NAME] | MODEL | SL No | QTY
1 | HP Laptop | 210 | CNF04543H7 | 1
2 | Biamp Digital Processor (black) | [NAME] | 0 1670917/01670933 | 2
3 | Exide Power safe battery | EP7-12( 12V-7 AH) | 500819/18/504964/65/ | 4
 | BACK
Spreadsheet: 16363b9b-99c9-4b20-8dbe-a6941d00efe1
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Word Records | 80689421624 | [NAME] | Mercy Said No | 2004-03-05 | Studio Series 3-Key CD Trax | Na | 9.99 | Y | Available
Word Records | 80689423628 | [NAME] | [NAME] | 2004-03-05 | Studio Series 3-Key CD Trax | Na | 9.99 | N | To Be Retired
Word Records | 80689419621 | [NAME] | Heart Like Yours, A | 2004-03-05 | Studio Series 3-Key CD Trax | Na | 9.99 | N | To Be Retired
Spreadsheet: 0409e3a3-a117-47e9-92a9-5b296f00e118
Sheet: Budget Details

Category | List Price | Installation | Discount | [NAME] | Sale Price | $/sf | % of Total
Spreadsheet: 857399d1706429484-how-to-arrange-according-to-rules-cg
Sheet: Sheet1

Class | Name | Model | Quantity |  |  |  |  |  | Class | Name | Model | Quantity
balance | A | 1 | 100 |  |  |  |  |  | balance | A | 1 | 100
balance | B | 1 | 100 |  |  |  |  |  | inbound | A | 1 | 100
inbound | A | 1 | 100 |  |  |  |  |  | inbound | A | 1 | 200
inbound | A | 1 | 100 |  |  |  |  |  | balance | A | 2 | 100
inbound | B | 1 | 100 |  |  |  |  |  | outbound | A | 2 | 100
balance | A | 2 | 100 |  |  |  |  |  | balance | B | 1 | 100
outbound | A | 2 | 100 |  |  |  |  |  | inbound | B | 1 | 100
outbound | C | 1 | 100 |  |  |  |  |  | outbound | C | 1 | 100
 |  |  |  |  |  |  |  |  |  | A | 1 | 100
 |  |  |  |  |  |  |  |  | inbound | A | 1 | 100
 |  |  |  |  |  |  |  |  | inbound | A | 1 | 200
 |  |  |  |  |  |  |  |  | balance | A | 2 | 100
 |  |  |  |  |  |  |  |  | outbound | A | 2 | 100
 |  |  |  |  |  |  |  |  | balance | B | 1 | 100
 |  |  |  |  |  |  |  |  | inbound | B | 1 | 100
 |  |  |  |  |  |  |  |  | outbound | C | 1 | 100
Spreadsheet: 598789d1542720364-help-with-sumif-or-if-book8
Sheet: Sheet1

94 | 94 | 2
4 | 1 | 2
13 | 2 | 2
98 | 3 | 2 | 2
99 | 4 | 2 | 2
42 | 5 | 2
3 | 6 | 2
38 | 7 | 2 | 2
94 | 8 | 2
7 | 9 | 2
15 | 10 | 2
65 | 11 | 2
12 | 12 | 2 | 2
78 | 13 | 2 | 2
96 | 14 | 2
94 | 15 | 2 | 2
22 | 16 | 2
25 | 17 | 2
 | 18 | 2
 | 19 | 2
 | 20 | 2
 | 21 | 2
 | 22 | 2 | 2
 | 23 | 2
 | 24 | 2
 | 25 | 2 | 2
 | 26 | 2
Spreadsheet: 810096d1671545392-cant-find-correct-formula-to-find-of-volume-that-can-be-produced-in-certain-hour-example-capacity-vs-volume-v1
Sheet: Sheet1

Hour | Production Capacity per hour | Production volume available | Over capacity | Over volume | % of volume from hour that can be produced | Comment
5 | 0 | 7.952782137991804 |  |  | 1 | 100% because the 8 items can be produced in future hours that have production capacity left
6 | 0 | 36.20041896572922 |  |  | 1 | 100% because the 36 items can be produced in future hours that have production capacity left
7 | 0 | 396.4436599035777 |  |  | 1 | 100% because the 396 items can be produced in future hours that have production capacity left
8 | 600 | 609.267709709173 |  |  | 1 | 100% because the 9 items can be produced in future hours that have production capacity left
9 | 600 | 432.3394532962715 |  |  | 1 | 100% because all productionvolume generated in this hour can be produced (+ 168 extra from the over volume we build up above)
10 | 600 | 344.0775876991064 |  |  | 1 | 100% because all productionvolume generated in this hour can be produced (+ 256 extra from the over volume we build up above)
11 | 600 | 418.9859619927965 |  |  | 1 | 100% because all productionvolume generated in this hour can be produced (+ 26 extra from the over volume we build up above)
12 | 600 | 262.8015993439625 |  |  | 1 | 100% because all productionvolume generated in this hour can be produced
13 | 600 | 406.2904464414213 |  |  | 1 | 100% because all productionvolume generated in this hour can be produced
14 | 600 | 447.0132260567641 |  |  | 1 | 100% because all productionvolume generated in this hour can be produced
15 | 600 | 426.4408991195646 |  |  | 1 | 100% because all productionvolume generated in this hour can be produced
16 | 600 | 863.4898522992775 |  |  | 1 | 100% because all the 263 items over-volume can be processed in future hours (20+413=433 is enough to process these 263 items)
17 | 600 | 860.1854615467483 |  |  | 0.65 | 65% because from the 260 items over-volume only a part can be produced (20+413=433. 433-263=170. 170/260=65%)
18 | 600 | 579.8056877258844 |  |  | 1 | 100% because all productionvolume generated in this hour can be produced
19 | 600 | 878.9928908119233 |  |  | 0.6825993773917576 | 68% because there is no capacity left in future hours to process any extra so 600/879
20 | 600 | 667.7133293606018 |  |  | 0.8985892202789426 | 90% because there is no capacity left in future hours to process any extra so 600/879
21 | 600 | 799.2510120329042 |  |  | 0.7507028342371354 | 75% because there is no capacity left in future hours to process any extra so 600/879
22 | 600 | 692.2458650551082 |  |  | 0.8667440721400846 | 87% because there is no capacity left in future hours to process any extra so 600/879
23 | 600 | 791.5078766584953 |  |  | 0.758046783479928 | 76% because there is no capacity left in future hours to process any extra so 600/879
0 | 600 | 186.5791819043462 |  |  | 1 | 100% because all productionvolume generated in this hour can be produced