tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 06aa9c88-bf3a-4763-852a-f4c9f4542ad8
Sheet: Sheet1

Undergraduate Majors | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Faculty of Business (BACC and BBA)
 |  | 2003-04 | 2004-05 | 2005-06 | 2006-07 | 2007-08
 | Single | 570 | 657 | 625 | 651 | 648
 | Combined | 2 | 0 | 1 | 0 | 1
Year I | Sub-Total: | 572 | 657 | 626 | 651 | 649
 | Gen/Integ Studies | 0 | 0 | 0 | 0 | 0
 | Total: | 572 | 657 | 626 | 651 | 649
 | Single | 430 | 605 | 564 | 540 | 534
 | Combined | 5 | 5 | 2 | 4 | 1
Year II | Sub-Total: | 435 | 610 | 566 | 544 | 535
 | Gen/Integ Studies | 0 | 0 | 0 | 0 | 0
 | Total: | 435 | 610 | 566 | 544 | 535
 | Single | 420 | 502 | 660 | 623 | 580
 | Combined | 3 | 2 | 4 | 2 | 4
Year III | Sub-Total: | 423 | 504 | 664 | 625 | 584
 | Gen/Integ Studies | 3 | 1 | 0 | 0 | 0
 | Total: | 426 | 505 | 664 | 625 | 584
 | Single | 519 | 343 | 364 | 472 | 462
 | Combined | 4 | 3 | 2 | 8 | 6
Year IV | Sub-Total: | 523 | 346 | 366 | 480 | 468
 | Gen/Integ Studies | 2 | 0 | 1 | 1 | 0
 | Total: | 525 | 346 | 367 | 481 | 468
 | Single | 1939 | 2107 | 2213 | 2286 | 2224
 | Combined | 14 | 10 | 9 | 14 | 12
TOTAL: | Sub-Total: | 1953 | 2117 | 2222 | 2300 | 2236
 | Gen/Integ Studies | 5 | 1 | 1 | 1 | 0
 | Total: | 1958 | 2118 | 2223 | 2301 | 2236
Male |  | 1102 | 1214 | 1323 | 1385 | 1395
Female |  | 856 | 904 | 900 | 916 | 841
Full-Time |  | 1465 | 1604 | 1647 | 1669 | 1601
Part-Time |  | 493 | 514 | 576 | 632 | 635
Codes: | BACC -- ACCC, ACCN, ACSP; BBA -- FNCE, COMP, QUAN, FNHR,  MKTG, INBU, MGMT, MKGM, INMK, MKFN, ENTR, HMRS, HMMK, PADM, ADMI, ADMN. ADSN, ADSP, GASS, ACTG, ACIN
Spreadsheet: 144033d1330693150-excel-2007-import-data-from-a-worksheet-into-another-and-group-data-into-sections-matrix
Sheet: Overall Build Status

 |  | Totals |  |  |  |  |  | P1 |  |  |  |  |  | New Features |  |  |  |  |  | TotalsP2
 |  | Pass | Fail | To Do | Deferred | Blocked |  | Pass | Fail | To Do | Deferred | Blocked |  | Pass | Fail | To Do | Deferred | Blocked |  | Pass | Fail | To Do | Deferred | Blocked
 | VFBR 0001 Login
 | VFBR 0002 Handy & Tariff Flow
 | VFBR 0002 SIM & Credit Voucher
 | VFBR 0002 SIM & Delayed Sub
 | VFBR 0002 SIM Only Buy Flow
 | VFBR 0002 Handy & Accessory
 | VFBR 0003 Prolongation Credit Voucher
 | VFBR 0003 Prolongation Delayed Subsidy
 | VFBR 0003 Prolongation Handy Tariff
 | VFBR 0003 Prolongation Hardware Only
 | VFBR 0004 Create Edit Shop
 | VFBR 0005 Create Edit User
 | VFBR 0006 Search Order
 | VFBR 0007 Transaction Processing
 | VFBR 0008 Document Management
 | VFBR 0009 Reporting
 | VFBR 0010 Subcriber Transaction
 | VFBR 0011 Contract
 | VFBR 0012 Uploads
 | VFBR 0013 SIM Inventory
 | VFBR 0014 Content
 | VFBR 0015 XML Fallout
 | VFBR QA System Pricing - Buyflow
 | VFBR QA System Pricing - Prolongation
 | VFBR QA System Pricing - Create Shop
 | Total # Test Cases less Deferred
 | Completed
Spreadsheet: 114353d1310103697-countif-and-answer-not-greater-than-3-question
Sheet: Sheet1

[NAME] | Code | Item
327911 | 32791 | 1
327912 | 32791 | 2
327912 | 32791 | 2
327971 | 32797 | 1
327973 | 32797 | 3
327973 | 32797 | 3
327973 | 32797 | 3
328201 | 32820 | 1
328202 | 32820 | 2
328202 | 32820 | 2
328202 | 32820 | 2
328211 | 32821 | 1
328212 | 32821 | 2
328212 | 32821 | 2
 |  |  |  |  | IF(B20="Salary",IF(COUNTIF( $A$2:$A$15,A20&2) > 3, "Pay",COUNTIF($A$2:$A$15,A20&2)), "")
Question : Item = 2 for calculate
Code | Description |  | [NAME] | Remarks
32791 | Salary |  | 2 | Wrong. Answer : Pay
32797 | Housing |  |  | Correct : "Blank"
32820 | Salary |  | 3 | Correct : 3
Spreadsheet: 855271d1704899110-excel-calendar-display-to-do-item-across-calendar-dates-test-calendar-v1
Sheet: November

 |  |  | NOVEMBER
 |  |  | SUNDAY |  | MONDAY |  | TUESDAY |  | WEDNESDAY |  | THURSDAY |  | FRIDAY |  | SATURDAY
11
9
2
Spreadsheet: 2b9f6c10-2b36-405f-b770-99f6b689026b
Sheet: Sheet1

Table 2--World cotton supply and use estimates | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 |  |  |  |  | 2012/13
Item | 2011/12 |  | Jan. |  | Feb. |  | Mar.
 | Million 480-lb. [NAME]
Supply:
Beginning stocks--
World | 49 |  | 68.85 |  | 69.03 |  | 68.98
Foreign | 46.4 |  | 65.5 |  | 65.68 |  | 65.63
Production--
World | 124.13 |  | 118.83 |  | 118.95 |  | 119.87
Foreign | 108.56 |  | 101.82 |  | 101.94 |  | 102.86
Imports--
World | 44.75 |  | 38.87 |  | 40.44 |  | 41.86
Foreign | 44.73 |  | 38.87 |  | 40.43 |  | 41.86
Use:
[NAME] use--
World | 103.19 |  | 106.06 |  | 106.24 |  | 107.11
Foreign | 99.89 |  | 102.66 |  | 102.84 |  | 103.71
Exports--
World | 45.96 |  | 38.89 |  | 40.43 |  | 41.92
Foreign | 34.24 |  | 26.69 |  | 27.93 |  | 29.17
Ending stocks--
World | 68.98 |  | 81.72 |  | 81.86 |  | 81.74
Foreign | 65.63 |  | 76.92 |  | 77.36 |  | 77.54
 | Percent
Stocks-to-use ratio:
World | 66.8 |  | 77.1 |  | 77.1 |  | 76.3
Foreign | 65.7 |  | 74.9 |  | 75.2 |  | 74.8
 | 3
Source: USDA, World Agricultural Outlook Board.
Last update: 03/12/13.
Spreadsheet: 749520d1632850198-iferror-formula-with-if-and-vlookup-statements-excel-iferror-with-mulitple-conditions
Sheet: Sheet1

Position ID | Target Hire Date | Hiring Duration Remaining | Expected Approval
P-106824 | 2021-09-01 00:00:00 | 120 | 14
P-106825 | 2021-11-11 00:00:00 | 10 | 14
P-106826 | 2021-11-10 00:00:00 | 30 | 14
P-106828 | 2022-02-09 00:00:00 | 30 | 14
Position ID | Status
P-106824
P-106825
P-106826
P-106827
Spreadsheet: 174213d1344962160-data-validation-combobox-on-worksheet-issue-please-help-datavalcomboclickdepend
Sheet: Lists

 | Amber |  | Aardvark |  | A
 | [NAME] |  | Cat |  | B
 | Black |  | Cockrel |  | C
 | Blue |  | Dog |  | D
 | [NAME] |  | Fox |  | E
 | Green |  | Frog |  | F
 | Grey |  | Horse |  | G
 | Ivory |  | Jaguar |  | H
 | Magenta |  | Monkey |  | I
 | Mustard |  | [NAME] |  | J
 | Olive |  | Rabbit |  | K
 | Pink |  | Rat |  | L
 | Puce |  | Tiger |  | M
 | Purple |  | Toad |  | N
 | Red |  | Zebra |  | O
 | Ruby |  |  |  | P
 | Stone |  |  |  | Q
 | Taupe |  |  |  | R
 | Umber |  |  |  | S
 | White |  |  |  | T
 | Yellow |  |  |  | U
 |  |  |  |  | V
 |  |  |  |  | W
 |  |  |  |  | X
 |  |  |  |  | Y
 |  |  |  |  | Z
Spreadsheet: 882949d1731426349-filter-lists-using-check-boxes-to-show-where-jobs-are-per-steps-bullseyethor-tick-box-testing-manual-results-spill-365-aligw
Sheet: Sheet1

Name | Address | Postcode | Step 1 | Step 2 | Step 3 |  |  | Step 1 |  |  |  | Step 2 |  |  |  | Step 3
NAME 1 | ADDRESS 1 | POSTCODE 1 | True | False | False |  |  | NAME 1 | ADDRESS 1 | POSTCODE 1 |  | NAME 4 | ADDRESS 4 | POSTCODE 4 |  | [NAME] 8 | ADDRESS 8 | POSTCODE 8
[NAME] 2 | ADDRESS 2 | POSTCODE 2 | True | False | False |  |  | [NAME] 2 | ADDRESS 2 | POSTCODE 2 |  | NAME 5 | ADDRESS 5 | POSTCODE 5 |  | NAME 9 | ADDRESS 9 | POSTCODE 9
NAME 3 | ADDRESS 3 | POSTCODE 3 | True | False | False |  |  | NAME 3 | ADDRESS 3 | POSTCODE 3 |  | NAME 6 | ADDRESS 6 | POSTCODE 6
NAME 4 | ADDRESS 4 | POSTCODE 4 | True | True | False |  |  | NAME 7 | ADDRESS 7 | POSTCODE 7
NAME 5 | ADDRESS 5 | POSTCODE 5 | True | True | False
NAME 6 | ADDRESS 6 | POSTCODE 6 | True | True | False |  |  |  | ADDRESS 1 | POSTCODE 1 |  |  | ADDRESS 4 | POSTCODE 4 |  |  | ADDRESS 8 | POSTCODE 8
NAME 7 | ADDRESS 7 | POSTCODE 7 | True | False | False |  |  | [NAME] 2 | ADDRESS 2 | POSTCODE 2 |  | NAME 5 | ADDRESS 5 | POSTCODE 5 |  | NAME 9 | ADDRESS 9 | POSTCODE 9
[NAME] 8 | ADDRESS 8 | POSTCODE 8 | True | True | True |  |  | NAME 3 | ADDRESS 3 | POSTCODE 3 |  | NAME 6 | ADDRESS 6 | POSTCODE 6
NAME 9 | ADDRESS 9 | POSTCODE 9 | True | True | True |  |  | NAME 7 | ADDRESS 7 | POSTCODE 7
NAME 10 | ADDRESS 10 | POSTCODE 10 | False | False | False
NAME 11 | ADDRESS 11 | POSTCODE 11 | False | False | False
Spreadsheet: joe_parks__14715__POSTION05_02
Sheet: FOM

katy index | [NAME]_ fixed | HSC index | HH_fix | hsc_fix | [NAME] | aug futs | sep fut | n-v | x-h
64000 |  | -20000
10000 |  | 20000 |  |  |  |  |  | -7.75
 |  |  |  |  |  |  |  | -46
75000 | hsc basis
 |  |  |  |  | 3.182 | 3.286
 |  |  |  |  | 0.05
 |  |  |  |  |  | 2.235
Spreadsheet: 673532d1587427575-counting-runs-of-two-consecutive-days-sample
Sheet: sample

Year | Month | Day | SnowD | Quality | B | Runs (d)
1904 | 12 | 26 | 0.01 | G | 1
1904 | 12 | 27 | 0.01 | G | 1 | 1
1904 | 12 | 28 | 0.01 | G | 1 | 0
1904 | 12 | 29 | 0.12 | G | 1 | 1
1904 | 12 | 30 | 0.12 | G | 1 | 0
1904 | 12 | 31 | 0.15 | G | 1 | 1
1906 | 12 | 17 | 0.07 | G | 1 | 0
1906 | 12 | 18 | 0.05 | G | 1 | 1
1906 | 12 | 19 | 0.05 | G | 1 | 0
1906 | 12 | 20 | 0.04 | G | 1 | 1
1906 | 12 | 25 | 0.07 | G | 1 | 0
1906 | 12 | 26 | 0.08 | G | 1 | 1
1906 | 12 | 27 | 0.08 | G | 1 | 0
1906 | 12 | 28 | 0.08 | G | 1 | 1
1906 | 12 | 29 | 0.06 | G | 1 | 0
1906 | 12 | 30 | 0.06 | G | 1 | 1
1906 | 12 | 31 | 0.07 | G | 1 | 0
1907 | 12 | 17 | 0.03 | G | 1 | 1
1907 | 12 | 18 | 0.10 | G | 1 | 0
1907 | 12 | 19 | 0.17 | G | 1 | 1
1907 | 12 | 20 | 0.17 | G | 1 | 0
Spreadsheet: 725615d1616768728-formula-to-show-data-from-previous-dynamic-row-number-retrieve-parent-for-each-child-ans
Sheet: Sheet1

Parent & Child | Parent | [NAME] to show parents name | Manual Expected Result |  |  |  |  |  |  | Parent & Child | Parent | [NAME] to show parents name | Manual Expected Result
[NAME] | Yes |  |  |  |  |  |  |  |  | [NAME] | Yes | ??
Ash | No |  | [NAME] |  |  |  |  |  |  | Ash | No | ?? | [NAME]
[NAME] | No |  | [NAME] |  |  |  |  |  |  | [NAME] | No | ?? | [NAME]
[NAME] | No |  | [NAME] |  |  |  |  |  |  | [NAME] | No | ?? | [NAME]
[NAME] | No |  | [NAME] |  |  |  |  |  |  | [NAME] | No | ?? | [NAME]
[NAME] | Yes |  |  |  |  |  |  |  |  | [NAME] | Yes | ??
Ami | No |  | [NAME] |  |  |  |  |  |  | Ami | No | ?? | [NAME]
Eva | No |  | [NAME] |  |  |  |  |  |  | Eva | No | ?? | [NAME]
[NAME] | Yes |  |  |  |  |  |  |  |  | [NAME] | Yes | ??
[NAME] | No |  | [NAME] |  |  |  |  |  |  | [NAME] | No | ?? | [NAME]
[NAME] | Yes |  |  |  |  |  |  |  |  | [NAME] | Yes | ??
[NAME] | No |  | [NAME] |  |  |  |  |  |  | [NAME] | No | ?? | [NAME]
[NAME] | No |  | [NAME] |  |  |  |  |  |  | [NAME] | No | ?? | [NAME]
[NAME] | No |  | [NAME] |  |  |  |  |  |  | [NAME] | No | ?? | [NAME]
[NAME] | Yes |  |  |  |  |  |  |  |  | [NAME] | Yes | ??
Polly | Yes |  |  |  |  |  |  |  |  | Polly | Yes | ??
Hugh | No |  | Polly |  |  |  |  |  |  | Hugh | No | ?? | Polly
Spreadsheet: 549612d1511821424-display-text-from-range-without-losing-value-custom-conditional-data-bars-271117-projects-dashboard
Sheet: Resumen

Resumen Proyectos
[NAME] (6 meses)
Basically instead of # it should display project name!!
Diagnóstico General
Project |  | Programación | Presupuesto | [NAME] | Calidad | Alcance | Riesgos | Problemas | Control Cambios | [NAME] | Prioridad
Rebuild techno-pm |  | ⚠️ | ⚠️ | ⚠️ |  | ✅ | ⚠️ | ⚠️
Rules Engine |  | ⚠️ | ⚠️ | ⚠️ |  | ✅ | ⚠️ | ⚠️
eProjectCheck |  | ⚠️ | ⚠️ | ⚠️ |  | ✅ | ⚠️ | ⚠️
eProjectDashbord.com |  | ⚠️ | ⚠️ | ⚠️ |  | ✅ | ⚠️ | ⚠️
ClaimsSmart |  | ⚠️ | ⚠️ | ⚠️ |  | ✅ | ⚠️ | ⚠️
Diagnóstico por Área |  | ⚠️ | ⚠️ | ⚠️ |  | ✅ | ⚠️ | ⚠️
Diagnóstico Tareas
Project |  | Tareas | Inicio | Fin | A tiempo | Contingentes | Atrasadas | [NAME] | Progreso | [NAME] | [NAME]
Rebuild techno-pm |  |  |  |  |  |  |  |  | 20
Rules Engine |  |  |  | 2017-12-04 00:00:00 |  |  |  |  | 30
eProjectCheck |  |  |  | 2018-01-06 00:00:00 |  |  |  |  | 50
eProjectDashbord.com |  |  |  | 2018-01-10 00:00:00 |  |  |  |  | 60
ClaimsSmart |  |  |  | 2018-02-22 00:00:00 |  |  |  |  | 80
Total Tareas
Spreadsheet: 37251d1235189954-switch-pivot-data-with-dynamic-ranges-and-a-defined-name-change_data
Sheet: Sheet1

Pivot1
 | Sum of Amount
 | Name | Total
 | Ally | 1
 | [NAME] | 2
 | Creg | 3
 | [NAME] | 4
 | [NAME] | 5
 | Fred | 6
 | Greg | 7
 | Hany | 8
 | Igge | 9
 | [NAME] | 10
 | [NAME] | 11
 | [NAME] | 12
 | Niel | 13
 | Oret | 14
 | Grand Total | 105
Spreadsheet: 697412d1601344995-using-index-and-match-but-omitting-some-results-report-help
Sheet: Report

Network | Contact | Sign Stat | [NAME] stat | Path stat | Address | Rate | Sign | PATH | DROP
 | Want to achieve below
Network | Contact | Sign Stat | [NAME] stat | Path stat | Address | Rate | Sign | PATH | DROP
2233412 | xxx-xxxx-xxxx | complete | canceled | complete | 123 Address | 2 | [NAME]
2233412 | xxx-xxxx-xxxx | complete | pending | - | 12 can place | 2 |  | [NAME]
2233412 | xxx-xxxx-xxxx | pending | pending | pending | 1 False st | 3 | [NAME] | [NAME] | [NAME]
2233412 | xxx-xxxx-xxxx | canceled | pending | complete | 19 fake St | 4 | [NAME]
2233412 | xxx-xxxx-xxxx | canceled | complete | - | 22 fake St | 2 | [NAME]
2233412 | xxx-xxxx-xxxx | complete | canceled | - | 23 fake St | 3 | - | [NAME]
Spreadsheet: 843663d1695454216-copying-over-date-in-separate-sheet-with-new-rows-test-book
Sheet: Sheet3

 | Which Person | Product | Number of Product 1 | Product 2 | Number of Product 2 | Staff [NAME] | Reorder? | Other Info
2023-09-20 00:00:00 | Person 4 | Shoes | 10 | Sandals | 20 | [NAME] | Yes
2023-09-20 00:00:00 | Person 5 | Shirts | 20 | Sweaters | 30 | [NAME] | No
2023-09-20 00:00:00 | Person 11 | Gloves | 17 |  |  | [NAME] | Yes
2023-09-21 00:00:00 | Person 10 | Candles | 16 |  |  | [NAME] | No
Spreadsheet: 045f84cd-8b79-4277-aacb-bb3d4bca689f
Sheet: Sheet1

Glendale Community College | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | REQUEST FOR INSTRUCTIONAL MATERIALS | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20
Business Services |  |  |  |  |  |  |  |  |  | Duplicating:  Located in the  Sierra Nevada Building, South End
Submit completed form to Purchasing for approval.
If copyrighted material, please complete the Certification below.
Name: |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Div/Dept
[NAME]: |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ph/Ext.
Course: |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Room #
Date Submitted |  |  |  |  |  |  |  |  |  |  |  | Date Needed
To be sold through the Bookstore? |  |  |  |  |  |  |  |  | DISTRICT ACCOUNT NUMBER
 |  |  |  |  |  |  |  |  | Fund (2) |  | Program (4) |  |  | Sub-Prog.(1) |  |  | TOPS ( 6) |  |  | Object (4)
Yes |  |  |  | No
COURSE AND NUMBER (i.e Eng 101):
 |  |  |  |  |  |  |  |  | Funding approved by:
Rates: |  | .03 per sheet (white) |  |  |  |  |  |  |  |  |  |  |  | Signature
 |  | .04 per sheet (colored)
 |  | .50 each for spiral binding |  |  |  |  |  |  |  |  |  |  |  | Print Name
STOCK |  |  |  |  | COLOR |  |  |  |  | TYPE |  |  |  |  |  |  |  |  | BINDING
81/2 X 11 |  |  |  |  | White |  |  |  |  | Regular |  |  |  | Cover |  |  |  |  | Stapled
81/2 X 14 |  |  |  |  |  |  |  |  |  | Punched |  |  |  | Cover color: |  |  |  |  | Plastic
 |  |  |  |  |  |  |  |  |  | Collated |  |  |  |  |  |  |  |  | Color
PRINTING: |  |  |  | One Side |  |  |  | Both Sides |  |  |  |  | Head to Head |  |  |  |  | Head to Foot
No. of Masters |  | X | No. of Impressions |  |  | = | Impressions |  |  | X | Rate |  | + | Binding |  | + | Plates |  | = | TOTAL
 |  | X |  |  |  | = | 0 |  |  | X |  |  | + |  |  | + |  |  | =
 |  | X |  |  |  | = | 0 |  |  | X |  |  | + |  |  | + |  |  | =
 |  | X |  |  |  | = | 0 |  |  | X |  |  | + |  |  | + |  |  | =
 |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL COST:
BOOKSTORE ACTION: |  |  |  |  | DUPLICATE |  |  |  |  |  | COPIES FOR SALE IN THE BOOKSTORE.
BOOKSTORE CODE: |  |  |  |  |  |  |  |  |  |  |  | Initials
PROJECT COMPLETED BY DUPLICATING: |  |  |  |  |  |  |  |  |  | Date |  |  |  |  |  | Initials
Spreadsheet: andy_zipper__174__DYNEGY-ICE VOL Apr20
Sheet: E-Mail

 | 2001-04-20 00:00:00
 | Intercontinental Exchange |  |  | Enron's Activity on ICE
 | Commodity | Volume |  | Enron Entity | Commodity | Deals | Volume
 | TOTAL POWER (MWH) |  |  | EPM | POWER
 | TOTAL GAS (MMBTU) |  |  | ENA | GAS
 | >ICE PHYSICAL GAS |  |  | ENA | CRUDE
 | >ICE FINANCIAL GAS |  |  | ECC
 |  |  |  | Enron's Activity on Dynegy Direct
 |  |  |  | Enron Entity | Commodity | Deals | Volume
 |  |  |  | EPM | POWER
 |  |  |  | ENA | POWER
 |  |  |  | ENA | US NATURAL GAS
 |  |  |  | ENA | COAL
 |  |  |  | EGL | NATURAL GAS LIQUIDS
Spreadsheet: 844620d1696382265-dynamic-dropdown-based-on-criteria-dynamic-dropdown-test
Sheet: RiskScore

No. | Product | API | Potency (mg) | API  Solubility in Water (mg/ml) | Solubility Score | TD (mg) | MDD (mg) | Potency Score | Cleanability | Cleanability Score | ADE (µg/day) | ADE Score | Risk Score
 | A 1mg Tablets | API A | 1 |  | 8 | 1 | 240 |  | Difficult |  | 5
 | A 2mg Capsules | API A | 2 |  | 8 | 1 | 240 |  | Difficult |  | 5
 | A 3mg Capsules | API A | 3 |  | 8 | 1 | 240 |  | Difficult |  | 5
 | A 4mg Capsules | API A | 4 |  | 8 | 1 | 240 |  | Difficult |  | 5
 | F 75mg F.C Tablets | API F | 75 |  | 8 | 75 | 450 |  | Difficult |  | 5
 | F 75mg Capsules | API F | 75 |  | 8 | 75 | 450 |  | Difficult |  | 5
 | H 14mg F.C Tablets | API H | 14 |  | 7 | 14 | 150 |  | Difficult |  | 5
 | B 10mg Capsules | API B | 10 |  | 5 | 5 | 300 |  | Medium |  | 10
 | B 15mg Capsules | API B | 15 |  | 5 | 5 | 300 |  | Medium |  | 10
 | B 20mg Capsules | API B | 20 |  | 5 | 5 | 300 |  | Medium |  | 10
 | B 25mg Capsules | API B | 25 |  | 5 | 5 | 300 |  | Medium |  | 10
 | K 250mg F.C. Tablets | API K | 250 |  | 8 | 250 | 2860 |  | Medium |  | 80
Spreadsheet: 160289d1339030203-count-of-style-in-a-range-of-sale-contribution-sale-contribution
Sheet: Reports

 | Total Sales
 | 3147815
 | % | 0.2 | 0.25 | 0.5 | 0.75 | 0.9 | 1
 | Row Position | 12 | 17 | 54 | 131 | 243 | 631
 | SALES | 0%-20% | 21%-25% | 26%-50% | 51%-75% | 76%-90% | 91%-100% | TOTAL
 | Styles | 12 | 5 | 37 | 77 | 112 | 388 | 631
 | Sales $ | 609570 | 155302 | 798332 | 794653 | 474494 | 315464 | 3147815
 | Sales $ / style | 50797.5 | 31060.4 | 21576.54054054054 | 10320.16883116883 | 4236.553571428572 | 813.0515463917526 | 4988.613312202852
 | Sales Units | 32003 | 7555 | 32748 | 29810 | 21628 | 24520 | 148264
 | EOH Units | 269446 | 56306 | 269651 | 270516 | 233512 | 376593 | 1476024
 | AVG WOS | 8.419398181420492 | 7.452812706816678 | 8.234121167704899 | 9.074672928547468 | 10.79674496023673 | 15.35860522022839 | 9.9553768952679
 | Styles under AVG WOS | 190 | 142 | 179 | 209 | 292 | 433 | 1445
 | Styles over AVG WOS | 441 | 489 | 452 | 422 | 339 | 198 | 2341
Spreadsheet: 703367d1604957233-function-help-if-statement-for-forecasting-excel-example-2-
Sheet: 1A) Profit share calc

 |  | 2021 |  | 2022 |  | 2023 |  | 2024 |  | 2025 |  | 2026 |  | 2027 |  | 2028 |  | 2029 |  | 2030 |  | 2031 |  | 2032
 | Total Net Sales ($M) | 10.6116859485 |  | 292.24583102169 |  | 614.9634763888984 |  | 652.224350667335 |  | 704.3787510431094 |  | 752.3709729632611 |  | 803.0873934843956 |  | 856.6696393260531 |  | 913.2663279776643 |  | 1260.06390295129 |  | 1032.650832326679 |  | 1076.855255232985
 | Net Sales FMC
 | Net Sales Non-FMC
 | [NAME] | 0.2334570908669999 | 0.155638060578 | 6.622290530951495 | 4.414860353967664 | 13.93507237497244 | 9.290048249981625 | 16.62682925938703 | 11.08455283959136 | 17.95637531096646 | 11.97091687397764 | 19.17981702826593 | 12.78654468551062 | 20.47270537840095 | 13.6484702522673 | 21.83865078051941 | 14.55910052034627 | 23.2814418659706 | 15.5209612439804 | 32.12217904598576 | 21.41478603065718 | 26.32485134308787 | 17.54990089539191 | 27.45173259402687 | 18.30115506268458
 | [NAME]
 | Distribution fee
 | Product contribution
 | share
 | Total profit
 | Milestone
 | % of total net sales
Spreadsheet: 106897d1304029856-effect-if-statement-pressureadjustments
Sheet: Blood Pressures and medications

id | SYS | DIA | Med1 | Med2 | SYS0D | SYS1D | DIA0D | [NAME] | SYSAdj | DIAAdj | NewSYS | NewDIA
19002 | 145 | 90 | pd | ld
19003 | 150 | 92 | b | ara+td
19004 | 160 | 97 | ace | b
Spreadsheet: phillip_allen__28920__MAPTTRA
Sheet: Stabilized

Sagewood M/F
Stabilized Pro Forma
 |  |  |  |  | Bank's |  |  | Borrower's
Unit Type | Units | % Total | Unit [NAME] | Size | Unit Rent | Rent | Rent/BR | Unit Rent | Rent | Rent/BR
2 BR/2.5 BA | 73 |  | 1016 |  | 950 |  |  | 1150
3 BR/3.5 BA | 61 |  | 1213 |  | 1250 |  |  | 1530
TOTAL
PRO FORMA:
 | Bank |  |  |  | Borrower
Assumptions:
Stabilized Vacancy\Collection: | 0.05 |  |  |  | 0.05
Average monthly rental rates:
REVENUE | Amount | % Total | Per Unit | psf | Amount | % Total | Per Unit | psf
Rental Income
Other Income | 33168 |  |  |  | 33168
PGI
Less: Vacancy/Collection
EGI
EXPENSES
Real Estate Taxes | 234500 |  |  |  | 234500
Insurnce | 33500 |  |  |  | 33500
Management Fees | 46900 |  |  |  | 46900
Administration | 116580 |  |  |  | 116580
Utilities | 43550 |  |  |  | 43550
Maintenance/Repairs | 93800 |  |  |  | 93800
[NAME]. | 670 |  |  |  | 670
Reserves @ $350/unit
Total Expenses
NOI
Loan Amount
[NAME] | 0.086 |  |  |  | 0.086
Amortization | 300 |  |  |  | 300
DS
Surplus
DCR |  | x |  |  |  | x
Constant Coverage
Spreadsheet: darrell_schoolcraft__7824__imbalsumm0110
Sheet: Agave

Agave imbalance
 | Measured | Scheduled | Imbalance
56339 | 69116 | 73740
500232 |  |  |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
500238 | 10688 | 12671 |  |  |  |  |  |  |  |  | lunch | 7.6
500239 | 12425 | 10930
500293 | 11091 | 38973
500302 |  | 652
500303 | 6382 | 9748
500305 | 64049 | 84750
500307 | 331 | 1701
500313
500314
500655 | 39924
500657 | 464
INDEX
2001-09-30 00:00:00 |  |  | 44777.43
2001-10-02 00:00:00
CBS Volume
 |  |  | -10485
Spreadsheet: 47324d1246365742-conditional-formating-office-2007-service-advisors-performance-1
Sheet: Sheet1

Today is day number | 5
 |  |  |  |  |  | Month Target | Daily Targets (Per CA) |  |  | Work Split
Working days in month inc Sat |  | 25 |  |  | Tyres
 |  |  |  |  |  |  |  |  |  | Retail = 80%
Tech Days off (hol & training) |  | 10 |  |  | Spruce |  |  |  |  | Warranty = 10%
 |  |  |  |  |  |  |  |  |  | Internal = 10%
Available hours for month |  |  |  |  | P Both
 |  |  |  |  |  |  |  |  |  | 5 techs @ 8 hrs per day each = 40.00 Hrs
25% of this is upsell |  |  |  |  | [NAME] |  |  |  |  | 80% of 40.00 hrs is 32.00 hrs
 |  |  |  |  |  |  |  |  |  | 75% of 32.00 hrs is = 24.00 hrs
Each CA has to sell (per month) |  |  |  |  | Up Sell |  |  |  |  | Leaving 8 hrs miminum a day to be upsold
 | Yesterdays Sales
 | Up Sold | Tyres | Spruce | P Both | [NAME] |  | Overall Status of CA
[NAME] | 3.07 | 0 | 3 | 2 | 3
[NAME] | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 0 | 0
 | Month to Date Sales
 | Up Sold | Tyres | Spruce | P Both | [NAME]
[NAME] | 15.55 | 5 | 5 | 10 | 15
[NAME] | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 0 | 0
Spreadsheet: 169586d1342969424-how-to-apply-countif-formula-when-data-are-on-different-sheets-book1
Sheet: Leave Details

 |  |  |  | [NAME]
S.no | Employee Name | SID | Process | Madatory leave | planned leave | Comp off | Sick leave | Future planned leave | Comments
1 | Akash [NAME] | I358001 | Verify/STP
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
Leave details
S.no | Leave Type | Number of days
1 | Mandatory leave | 10
2 | Planned leave | 10
3 | Comp off | 10
4 | Sick leave | 12
Spreadsheet: 151171d1334821241-excel-2007-grouping-in-pivot-tables-pivot_grouping_example
Sheet: Pivot

 | Column Labels
 | Sum of BillAmount |  |  |  | Sum of PayAmount
Row Labels | A | B | C | D | A | B | C | D
[NAME] | 130 | 39 | 78 | 104 | 100 | 30 | 60 | 80
[NAME] | 112 | 140 | 42 | 84 | 80 | 100 | 30 | 60
[NAME] | 72 | 36 | 96 | 120 | 60 | 30 | 80 | 100
Grand Total | 314 | 215 | 216 | 308 | 240 | 160 | 170 | 240
Spreadsheet: 34160d1231304733-trend-between-two-points-book1
Sheet: Sheet1

 |  | RAW SCORE | PERCENTILE RANK
 |  | 106 | 19.51392277700907 |  | This is a TREND of the two columns but this is NOT the correct estimated percentile rank for a raw score of 106
 |  | 106 | 15.27999999999999 |  | This is the correct estimated percentile rank for a raw score of 106, but how do I make a formula to do this for any number from 1 to 200
 |  |  |  |  | How can I create a formula that will give me the correct percentile rank (Looking at just two rows) for any number from 1 to 200
 |  | RAW SCORE | PERCENTILE RANK
 |  | 1 | 0
 |  | 105 | 14
 |  | 110 | 20.4
 |  | 111 | 21.8
 |  | 117 | 29.5
 |  | 118 | 33
 |  | 123 | 42.5
 |  | 124 | 44.5
 |  | 129 | 54.4
 |  | 130 | 56.5
 |  | 135 | 66.5
 |  | 136 | 68.3
 |  | 142 | 77.2
 |  | 143 | 80.4
 |  | 148 | 87.5
 |  | 149 | 88
 |  | 154 | 93.7
 |  | 155 | 94.5
 |  | 160 | 97.5
 |  | 161 | 97
 |  | 166 | 99.2
 |  | 167 | 99.3
 |  | 173 | 99.8
 |  | 200 | 100