tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 763186d1642024943-formula-for-dollar-amount-expiration-tracking-based-on-2-year-date-range-example
Sheet: 2022-2023

ID |  | Forwarded | Jan 2022 | Feb 2022 | Mar 2022 | Apr 2022 | May 2022 | Jun 2022 | Jul 2022 | Aug 2022 | Sept 2022 | Oct 2022 | Nov 2022 | Dec 2022 | Jan 2023 | Feb 2023 | Mar 2023 | Apr 2023 | May 2023 | Jun 2023 | Jul 2023 | Aug 2023 | Sept 2023 | Oct 2023 | Nov 2023 | Dec 2023 | Totals
10419309 | PIP Hrs |  | 12
 | $ Spent
 | $ Total | 222.39
Spreadsheet: 62829d1263836345-is-this-type-of-copy-even-possible-test4-1-
Sheet: FSV

Sub | SOP Name | Identifier | Responsible | Due Date | Authored | Approved | Submitted
DATA139 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA140 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA141 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA142 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA143 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA144 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA145 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA146 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
[NAME] | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA148 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA149 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA150 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA151 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA152 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA153 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA154 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA155 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
[NAME] | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA157 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA158 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA159 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA160 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA161 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA162 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA163 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA164 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA165 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA166 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA167 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA168 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA169 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
[NAME] | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA171 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA172 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA173 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
Spreadsheet: 752949d1635133574-retrieve-multiple-results-by-vlookup-possible-vlookup
Sheet: data

Company name | Name | Surname | [NAME] | Score
AAA | AA | BB | [EMAIL] | 1
BBB | AB | BC | [EMAIL] | 2
CCC | AC | BD | [EMAIL] | 3
AAA | AA | BB | [EMAIL] | 4
BBB | AB | BC | [EMAIL] | 5
CCC | AC | BD | [EMAIL] | 6
DDD | DD | EE | [EMAIL] | 1
EEE | EE | FF | [EMAIL] | 1
FFF | FF | GG | [EMAIL] | 5
GGG | GG | HH | [EMAIL] | 3
Spreadsheet: 833625d1687153721-auto-filling-information-actual-workbook-aligw
Sheet: Sheet2

 |  | [NAME] | AGASKILL
 |  |  | AHASSAN
 |  | [NAME] | AHILL
 |  | [NAME] | AHOBSON
 |  |  | AKEDZIOR
 |  |  | AKIRKHAM
 |  |  | ALOMAS
 |  |  | AMANGNALL
 |  |  | AMCONNELL
 |  | [NAME] | ANEWELL
 |  |  | APAJAK
 |  | [NAME] | AROBINSON
 |  |  | ASAVINS
 |  | [NAME] | ASHARPE
 |  |  | ASMIT
 |  | [NAME] | ASMITH1
 |  |  | ASOBOLEWSKI
 |  |  | AZAKRZEWSKI
 |  |  | [NAME]
 |  |  | BHASLAM
 |  |  | BRAFFERTY
 |  |  | CALLEN
 |  |  | CCHAN
 |  |  | CLAMB1
 |  |  | CRAY
 |  |  | CROBINSON
 |  |  | CSHUN
 |  |  | CWAN
 |  |  | DBOOTH
 |  |  | DBRADFORD
 |  |  | DCHANTALA
Spreadsheet: 1b25b2ed-7cff-4243-8917-6139f1a16798
Sheet: Annuity, A-PV

Discount Factor Table for Annuity
Annuity (A) --> Prenset Value (PV) |  |  |  |  |  |  |  |  | Column: discount rate (r%), Row: Year (n)
 |  |  |  |  |  |  |  |  | [NAME]: ((1+r)^n-1)/(r(1+r)^n)
 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15
0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
Spreadsheet: 47218875-2e83-401b-a64c-46df5a996720
Sheet: Page 1

Permit No.: |  |  | WQ0000795 |  |  | Facility Name: |  | Surf City WWTF |  |  |  |  |  | County: | Pender |  | Month: |  |  | Year:
Did infiltration occur at this facility? |  |  |  |  |  | Site Name: |  | IB-1 |  | Site Name: |  |  |  | Site Name: |  |  |  | Site Name:
 |  |  |  |  |  | Area (acres): |  | 3.09 |  | Area (acres): |  |  |  | Area (acres): |  |  |  | Area (acres):
 |  |  |  |  |  | Rate (GPD/ft2): |  | 0.744 |  | Rate (GPD/ft2): |  |  |  | Rate (GPD/ft2): |  |  |  | Rate (GPD/ft2):
Day | Weather |  |  | Freeboard |  | Site Infiltrated? |  |  |  | Site Infiltrated? |  |  |  | Site Infiltrated? |  |  |  | Site Infiltrated?
 | Weather Code | Temperature | Precipitation | Storage           (if applicable) | 5-Day Upset       (if applicable) | Volume Applied | Time   Infiltrated | Daily   Loading | [NAME] (Basins Only) | Volume Applied | Time    Infiltrated | Daily   Loading | [NAME] (Basins Only) | Volume Applied | Time   Infiltrated | Daily   Loading | [NAME] (Basins Only) | Volume Applied | Time    Infiltrated | Daily   Loading | [NAME] (Basins Only)
 |  | ºF | in | ft | ft | gal | min | GPD/ft2 | ft | gal | min | GPD/ft2 | ft | gal | min | GPD/ft2 | ft | gal | min | GPD/ft2 | ft
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Monthly Loading (GPD/ft2):
Year to Date Loading (GPD/ft2):
Spreadsheet: 0c1f4102-6b35-44f4-852b-428f6e0a9765
Sheet: E670SAL

DISTRIBUTIVE SCHOOL ACCOUNT - DECISION E-670 SALARY
 | POS | POS | $ | POS | $ | POS | $
WEIGHTED ENROLLMENT
AVG STARTING TEACHER SALARY
[NAME] (COLA)
INSTRUCTIONAL PERSONNEL
LICENSED
STUDENT RATIO
2%ROLL-UP
INSTRUCTIONAL PERSONNEL
NON-LICENSED
STUDENT RATIO
2%ROLL-UP
INSTRUCTION SUPPORT PERSONNEL
LICENSED
STUDENT RATIO
2%ROLL-UP
NON-LICENSED
STUDENT RATIO
2%ROLL-UP
ADMINISTRATIVE SUPPORT PERSONNEL
LICENSED
STUDENT RATIO
2%ROLL-UP
NON-LICENSED
STUDENT RATIO
2%ROLL-UP
OTHER LICENSED & NON-LICENSED
STUDENT RATIO
2%ROLL-UP
TOTAL SALARIES
PERS Rate Change (23.75%-21.5%*.50)
TOTAL SALARIES LESS PERS RATE CHANGE
SUBSTITUTE SALARIES
FRINGE BENEFITS
[NAME]
SIIS
UNEMP INS
MEDICARE
MEDICAL INS
OTHER
TOTAL POSITIONS/SALARIES
AND FRINGE BENEFITS
BENEFIT/SALARY RATIO
 |  |  | Net |  |  | Net
Summary | M300 | E670 | Diff | M300 | E670 | Diff
Salaries
Substitute Salaries
Extra Duty, Misc Salaries
Retirement
SIIS
Unemp Comp
Medicare
Medical
Other
Total Salaries and Fringe Benefits
Spreadsheet: 194f64dd-5d55-4b02-b65b-2b5118b721ab
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7371 | 41159 | Charlotte | Ellis | GBR | 1 | 00:12:07 | 00:01:35 | 00:33:43 | 00:00:00 | 00:24:54 | 1 | 01:12:22
7371 | 50580 | [NAME] | [NAME] | GBR | 2 | 00:11:49 | 00:01:19 | 00:33:22 | 00:00:00 | 00:26:06 | 2 | 01:12:39
Spreadsheet: 143160d1330243743-excel-2007-excel-2007-help-regarding-if-and-list-if-list2
Sheet: Sheet1

 | F2 | TT | F1 | B1 | T1
 | B1 | BB | F2 | B2 | T2
 | T1 | TT | F3 | B3 | T3
Spreadsheet: 73543d1274199336-excel-2007-matrixed-data-gathering-with-report-example-data-gathering-and-report
Sheet: Completed Data Gathering

Module Name:  Module 1
 |  | Role 1 | Role 2 | Role 3 | Role 4
Tracking
 | Tracking Task 1 | x | x | x
 | Tracking Task 2 |  |  | x | x
 | Tracking Task 3 |  | x
 | Tracking Task 4 |  |  | x | x
 | Tracking Task 5 |  | x
Querying
 | Querying Task 1 |  | x
 | Querying Task 2 | x | x | x | x
 | Querying Task 3 |  | x | x | x
 | Querying Task 4 | x |  | x
Managing
 | Managing Task 1 | x |  | x
 | Managing Task 2 |  | x |  | x
 | Managing Task 3 |  | x | x
 | Managing Task 4 | x | x | x | x
Spreadsheet: 197002d1354184737-can-dropdownlist-be-used-to-give-info-on-other-dropdownlist-netbackup-11-2012
Sheet: error_code

1 | The requested operation was partially successful
2 | None of the requested files were backed up
6 | The backup failed to back up the requested files
23 | Socket read failed
24 | Socket write failed
25 | Cannot connect on socket
28 | Failed trying to fork a process
40 | Network connection broken
48 | Client hostname could not be found
50 | Client process aborted
58 | Can't connect to client
59 | Access to the client was not allowed
71 | None of the files in the file list exist
89 | Problems encountered during setup of shared memory
96 | Unable to allocate new media for backup, storage unit has none available
129 | Disk storage unit is full
150 | Termination requested by administrator
155 | Disk is full
191 | No images were successfully processed
196 | Client backup was not attempted because backup window closed
229 | Events out of sequence - image inconsistency
233 | Premature eof encountered
811 | Failed to communicate with resource requester
Spreadsheet: 15bedb96-f022-4e34-8421-e8dab628c758
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FAPLG | Test | FAPLG | [NAME] | [NAME] | Enzyme Immunoassay (FEIA) | Plain, Red-Top Tube: Red |  |  |  |  | Draw blood in a plain red-top tube(s), serum gel tube(s) is acceptable. Spin down and send 0.5 mL of serum refrigerated in a plastic vial. | 0.5 mL | Hemolysis:	NA Thawing:	Warm OK; Cold OK Lipemia:	NA Icterus:	NA Other:	NA | <2 mcg/mL   The reference range listed on the report is the lower limit of quantitation for the assay. The clinical utility of food-specific IgG tests has not been established. These tests can be used in special clinical situations to select foods for evaluation by diet elimination and challenge in patients who have food-related complaints. It should be recognized that the presence of food-specific IgG alone cannot be taken as evidence of food allergy and only indicates immunologic sensitization by the food allergen in question. This test should only be ordered by physicians who recognize the limitations of the test.   Test Performed by:	Viracor-IBT Laboratories 			1001 NW Technology Dr.  			Lee's Summit, MO 64086 | Monday through Friday | 3 days | 5 - 7 days | 1 | 86001 |  |  |  |  | Viracor-IBT Laboratories
FAPLG | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 28 days
FAPLG | Result | FAPLG | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 95298d1294920393-modify-sumproduct-and-sumif-formulas-testing
Sheet: Supplier Bids

Category | Location | Part Number | Family Part Number | Supplier | [NAME]
Fitting | Alabama | 1 | Code1 | Supplier 1 | 50000
Fitting | Alabama | 2 | Code2 | Supplier 1 | 2000
Fitting | Alabama | 3 | Code2 | Supplier 2 | 1000
Spreadsheet: 7a89a20f-54a5-44fb-88ff-3bdee3373213
Sheet: Sheet1

Population Estimates by Age (5-Year Age Group) and Sex | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 |  |  | Apr. 1, 2012  (Provisional estimates) |  |  |  | Nov. 1, 2011  (Final estimates)
Age groups |  |  | Total  population |  |  |  | Total  population |  |  | Japanese  population
 |  |  | Both sexes | Male | Female |  | Both sexes | Male | Female | Both sexes | Male | Female
 |  |  | Population (Ten thousand persons) |  |  |  |  | Population   (Thousand persons)
Total |  |  | 12765 | 6210 | 6556 |  | 127800 | 62179 | 65621 | 126167 | 61442 | 64724
0 - 4 | years old |  | 529 | 271 | 258 |  | 5301 | 2714 | 2587 | 5252 | 2689 | 2563
5 - 9 |  |  | 545 | 279 | 266 |  | 5480 | 2806 | 2674 | 5436 | 2783 | 2653
10 - 14 |  |  | 590 | 302 | 288 |  | 5910 | 3027 | 2883 | 5863 | 3003 | 2860
15 - 19 |  |  | 606 | 311 | 295 |  | 6075 | 3117 | 2958 | 6007 | 3084 | 2923
20 - 24 |  |  | 632 | 323 | 309 |  | 6366 | 3252 | 3114 | 6160 | 3156 | 3004
25 - 29 |  |  | 715 | 364 | 351 |  | 7210 | 3668 | 3542 | 6993 | 3564 | 3429
30 - 34 |  |  | 797 | 404 | 393 |  | 8076 | 4097 | 3979 | 7878 | 4008 | 3870
35 - 39 |  |  | 956 | 485 | 471 |  | 9694 | 4916 | 4778 | 9526 | 4845 | 4682
40 - 44 |  |  | 940 | 475 | 465 |  | 9367 | 4730 | 4636 | 9206 | 4666 | 4540
45 - 49 |  |  | 804 | 404 | 400 |  | 7955 | 3998 | 3957 | 7826 | 3944 | 3882
50 - 54 |  |  | 764 | 382 | 382 |  | 7633 | 3815 | 3818 | 7540 | 3775 | 3765
55 - 59 |  |  | 811 | 402 | 408 |  | 8299 | 4118 | 4182 | 8225 | 4084 | 4141
60 - 64 |  |  | 1050 | 515 | 535 |  | 10610 | 5207 | 5403 | 10550 | 5178 | 5372
65 - 69 |  |  | 793 | 380 | 413 |  | 7870 | 3763 | 4107 | 7828 | 3743 | 4085
70 - 74 |  |  | 731 | 340 | 391 |  | 7212 | 3349 | 3863 | 7180 | 3334 | 3846
75 - 79 |  |  | 620 | 271 | 349 |  | 6150 | 2682 | 3467 | 6128 | 2673 | 3455
80 - 84 |  |  | 455 | 179 | 276 |  | 4500 | 1766 | 2734 | 4487 | 1761 | 2726
85 | and over |  | 425 | 121 | 304 |  | 4093 | 1155 | 2938 | 4081 | 1151 | 2931
Regrouped
0 - 14 | years old |  | 1665 | 852 | 812 |  | 16691 | 8547 | 8144 | 16551 | 8475 | 8076
15 - 64 |  |  | 8075 | 4066 | 4010 |  | 81284 | 40918 | 40367 | 79911 | 40305 | 39607
65 | and over |  | 3025 | 1292 | 1734 |  | 29825 | 12714 | 17110 | 29704 | 12662 | 17042
75 | and over |  | 1501 | 572 | 929 |  | 14742 | 5603 | 9140 | 14696 | 5585 | 9112
 |  |  |  |  | Percentage distribution  (%)
0 - 14 | years old |  | 13 | 13.7 | 12.4 |  | 13.1 | 13.7 | 12.4 | 13.1 | 13.8 | 12.5
15 - 64 |  |  | 63.3 | 65.5 | 61.2 |  | 63.6 | 65.8 | 61.5 | 63.3 | 65.6 | 61.2
65 | and over |  | 23.7 | 20.8 | 26.4 |  | 23.3 | 20.4 | 26.1 | 23.5 | 20.6 | 26.3
75 | and over |  | 11.8 | 9.2 | 14.2 |  | 11.5 | 9 | 13.9 | 11.6 | 9.1 | 14.1
Notes) | * | Figures may not add up to the totals because of rounding.
 | * | Based on the 2010 Population Census.
 | * | Final estimates for this month's population will be computed 5 months later using updated sources.
Spreadsheet: 0adeaf6a-d8a0-4aa7-b41b-e1206e38b0b5
Sheet: Sheet1

TECHNICAL SERVICES DEPARTMENT | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13
SERIAL STATISTICS - 2004/2005
 | JUL | AUG | SEP | OCT | NOV | DEC | JAN | FEB | MAR | APR | MAY | JUN | YTD
[NAME] | 1 | 2 | 17 | 3 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 9 | 34
Titles added | 4 | 8 | 8 | 1 | 6 | 6 | 1 | 4 | 3 | 3 | 0 | 15 | 59
[NAME] added | 819 | 236 | 481 | 411 | 381 | 215 | 306 | 322 | 678 | 523 | 352 | 327 | 5051
-Subscriptions | 75 | 55 | 76 | 142 | 80 | 80 | 101 | 121 | 101 | 49 | 42 |  | 922
-Binding | 744 | 181 | 405 | 269 | 301 | 135 | 205 | 201 | 577 | 474 | 310 | 327 | 4129
[NAME] processed | 727 | 956 | 1627 | 1395 | 1248 | 290 | 785 | 1789 | 1613 | 1237 | 525 | 1558 | 13750
[NAME] temp bound | 2 | 18 | 12 | 9 | 4 | 52 | 0 | 0 | 2 | 58 | 13 | 62 | 232
[NAME] mended | 37 | 0 | 3 | 56 | 16 | 4 | 0 | 6 | 27 | 3 | 0 | 153 | 305
Mform pieces added | 1298 | 1410 | 12 | 20 | 9 | 30 | 16 | 50 | 21 | 14 | 15 | 21 | 2916
-Film | 9 | 17 | 7 | 20 | 9 | 30 | 16 | 11 | 21 | 14 | 15 | 21 | 190
-Fiche | 1289 | 1393 | 5 | 0 | 0 | 0 | 0 | 39 |  | 0 | 0 | 0 | 2726
Claims sent | 168 | 109 | 1271 | 701 | 83 | 200 | 366 | 408 | 725 | 260 | 353 | 305 | 4949
Pieces checked in |  |  |  | 1865 | 1739 | 2009 | 1431 | 2088 | 1824 | 1778 | 1903 | 2293 | 16930
Spreadsheet: 748772d1632332918-create-a-daily-rolling-schedules-from-multiple-worksheets-daily-work-schedule
Sheet: Mayers

Mayers
 | Priority |  |  |  |  |  | Status / Issues
7&8-UNIT WIRELESS SENSORS | A | IP | IP | IP |  |  | 7 & 8 units' / coal-yard Maint shop are complete.
8-UNIT FGD INSTALL NEW 110/PLUG /BREAKER & WIRING | B | START | IP | IP
camera for [NAME] license plate reader | A |  | START | IP
Spare GSU | A | WMAT |  |  |  |  | MOVE LIGHT POLE & CABLE ([NAME])
GAS TURBINE SITE | A | WMAT |  |  |  |  | Outside turbine room elevator, next to I-beam T23
7 & 8 UNIT TELEDYNE PM & REPAIRS | A | WMAT
8-UNIT LIME | A | WMAT
8-UNIT FGD | B | WMAT
NEXT WEEK |  |  |  |  |  |  | Status
McCormick- [NAME] |  |  |  |  |  |  | Backlog
Spreadsheet: 878684d1725944523-user-must-choose-from-a-dropdown-when-they-choose-certain-information-in-another-cell-sonniehoots-fy25-cmpa-financial-tracker-test-dv-spill-365-aligw
Sheet: DO NOT DELETE

Status | Submitter | User 1 | User2 | Department | Fund | Source Code | Function | Purpose Code | Project | Activity | Purchased for USER1 | Form Type |  |  |  |  | User 1
Reconciled |  | CPADM |  |  |  |  |  |  |  |  | CPADM
Partial |  | COMCS |  |  |  |  |  | 20001 |  |  | COMCS |  |  |  |  |  | COMCS
Duplicate |  | COMED |  |  |  |  |  | 20002 |  |  | COMED |  |  |  |  |  | COMED
Cancelled |  | DGEDU |  |  |  |  |  | 20003 |  |  | DGEDU |  |  |  |  |  | DGEDU
Has Issue |  | DGORG |  |  |  |  |  | 20004 |  |  | DGORG |  |  |  |  |  | DGORG
 |  | DGTAL |  |  |  |  |  | 20005 |  |  | DGTAL |  |  |  |  |  | DGTAL
 |  | MKTNG |  |  |  |  |  | 20006 |  |  | MKTNG |  |  |  |  |  | MKTNG
 |  | SMKTG |  |  |  |  |  | 20007 |  |  | SMKTG |  |  |  |  |  | SMKTG
 |  |  |  |  |  |  |  | 20008
 |  |  |  |  |  |  |  | 20009
 |  |  |  |  |  |  |  | 20010
 |  |  |  |  |  |  |  | 20011
 |  |  |  |  |  |  |  | 20012
 |  |  |  |  |  |  |  | 20013
 |  |  |  |  |  |  |  | 20014
 |  |  |  |  |  |  |  | 20015
 |  |  |  |  |  |  |  | 20016
 |  |  |  |  |  |  |  | 20017
 |  |  |  |  |  |  |  | 20018
 |  |  |  |  |  |  |  | 20019
 |  |  |  |  |  |  |  | 20020
 |  |  |  |  |  |  |  | 20021
 |  |  |  |  |  |  |  | 20022
 |  |  |  |  |  |  |  | 20023
 |  |  |  |  |  |  |  | 20024
 |  |  |  |  |  |  |  | 20025
 |  |  |  |  |  |  |  | 20026
 |  |  |  |  |  |  |  | 20027
 |  |  |  |  |  |  |  | 20028
 |  |  |  |  |  |  |  | 20029
 |  |  |  |  |  |  |  | 20030
Spreadsheet: 138748d1327878556-if-and-lookup-copy_bid-sheet-to-po
Sheet: Sheet1

3.a.
Item | Description | Unit | Village Produce | City Produce | Country Produce | Best Bid $ | Best Company Quote | Last Price Paid
Avocados | 48 ct. | Case | 61.8 | 60.3 | 59.46 |  |  | 57.94
Cauliflower | 12 ct. | Case | 12.8 | 12.9 | 13.27 |  |  | 13.26
Cucumbers | Medium | Case | 11.1 | 11.52 | 10.91 |  |  | 11.34
Grapes | Red Seedless | [NAME] | 19.32 | 19.5 | 19.14 |  |  | 18.72
Lettuce | [NAME], 24 ct. | Case | 9.53 | 9.84 | 10.27 |  |  | 10.02
Lettuce | Romaine, 24 ct. | Case | 17.75 | 17.82 | 18.22 |  |  | 18.1
Pears | D'Anjou | Case | 20.82 | 20.58 | 20.64 |  |  | 20.62
Peppers | [NAME], Med. | Case | 8.3 | 8.38 | 9.28 |  |  | 9.02
Pineapples | 7 ct. | Case | 10.5 | 10.38 | 10.68 |  |  | 10.08
Potatoes | B Reds | 50# [NAME] | 15.06 | 14.82 | 14.88 |  |  | 14.98
Potatoes | Peeled, Large | 25# [NAME] | 17.52 | 17.22 | 17.28 |  |  | 17.18
Squash | Yellow #2 | 30# Case | 8.55 | 8.71 | 8.98 |  |  | 9.1
Strawberries | Driscoll | Flat | 18.29 | 18.06 | 17.1 |  |  | 18.3
3.b.
Item | Description | Unit | Par Value | On Hand | Special Order | Order Amount
Avocados | 48 ct. | Case | 6 | 2 | 3
Cauliflower | 12 ct. | Case | 5 | 1
Cucumbers | Medium | Case | 3 | 0
Grapes | Red Seedless | [NAME] | 4 | 1
Lettuce | [NAME], 24 ct. | Case | 5 | 2 | 4
Lettuce | Romaine, 24 ct. | Case | 3 | 0.5
Pears | D'Anjou | Case | 3 | 1
Peppers | [NAME], Med. | Case | 7 | 2 | 5
Pineapples | 7 ct. | Case | 4 | 0
Potatoes | B Reds | 50# [NAME] | 3 | 0.5
Potatoes | Peeled, Large | 25# [NAME] | 4 | 1 | 4
Squash | Yellow #2 | 30# Case | 5 | 2 | 2
Strawberries | Driscoll | Flat | 3 | 1.5
3.c.
 |  | [NAME]
Supplier |  |  |  | [NAME]
Company Name: | Village Produce |  |  | P.O. Number | 456
Street Address: | 123 Somewhere |  |  | Order Date: | 2000-01-01 00:00:00
City, State, Zip: | Village, CA 12345 |  |  | Delivery Date: | 2000-01-02 00:00:00
Phone Number: | 555-5555 |  |  | Phone Number: | 555-5557
Fax Number: | 555-5556 |  |  | Fax Number: | 555-5558
E-Mail: | [EMAIL] |  |  | E-Mail: | [EMAIL]
Contact: | Mr. [NAME] |  |  | Buyer: | Ms. [NAME]
Item | Description | Unit | Quantity | Unit Price $ | Extension
Total
Spreadsheet: 803992d1667834522-cf-for-reorder-level-not-working-correctly-cf-for-reorder-level-incorrect
Sheet: Sheet1

Date | Product | OP Stock | Sales | Closing Stock | Reorder |  | Col E s/be |  | If Reorder added,Opening Stock S/be | If Reorder added,Closing Stock S/be |  | Product | [NAME] | Av. Daily Sales | [NAME] | Av. Leadtime | Safety Stock | Lead Time Demand | Reorder Point
2022-01-01 00:00:00 | Product 1 | 1000 |  |  |  |  |  |  | 1000 |  |  | Product 1 |  |  | 5 | 3
2022-01-01 00:00:00 | Product 2 | 1000 |  |  |  |  |  |  | 1000 |  |  | Product 2 |  |  | 6 | 2
2022-01-01 00:00:00 | Product 3 | 1000 |  |  |  |  |  |  | 1000 |  |  | Product 3 |  |  | 8 | 5
2022-01-01 00:00:00 | Product 4 | 500 |  |  |  |  |  |  | 500 |  |  | Product 4 |  |  | 4 | 4
2022-01-02 00:00:00 | Product 1 |  | 23 |  |  |  |  |  | 1000
2022-01-04 00:00:00 | Product 1 |  | 81 |  |  |  |  |  | 977
2022-01-05 00:00:00 | Product 3 |  | 88 |  |  |  |  |  | 1000
2022-01-14 00:00:00 | Product 1 |  | 85 |  |  |  |  |  | 896
2022-01-14 00:00:00 | Product 3 |  | 94 |  |  |  |  |  | 912
2022-01-14 00:00:00 | Product 1 |  | 24 |  |  |  |  |  | 811 |  |  | 1. Incorrect CF for Low Stock:
2022-01-16 00:00:00 | Product 1 |  | 72 |  |  |  |  |  | 787 |  |  | CF Formula: "=E2<=INDEX($T$2:$T$5,MATCH($B2,$M$2:$,$5,0))"
2022-01-16 00:00:00 | Product 1 |  | 60 |  |  |  |  |  | 715 |  |  | Applied to "=$[NAME]"
2022-01-20 00:00:00 | Product 3 |  | 8 |  |  |  |  |  | 818
2022-01-22 00:00:00 | Product 1 |  | 54 |  |  |  |  |  | 655 |  |  | 2. Need [NAME] to add Reorder stock to Col C IF the PREVIOUS entry for that Product had anything in Col G.
2022-01-24 00:00:00 | Product 3 |  | 81 |  |  |  |  |  | 810 |  |  | Problem is the formula below adds the LAST reorder for the Product, even if it has been added to Col C  already.
2022-01-26 00:00:00 | Product 1 |  | 91 |  |  |  |  |  | 601 |  |  | =INDEX($E$2:$E5,MATCH(2,1/(B$2:B5=B6)))+INDEX($F$2:$F5,MATCH(2,1/(B$2:B5=B6)))
2022-01-26 00:00:00 | Product 4 |  | 64 |  |  |  |  |  | 500
2022-01-27 00:00:00 | Product 3 |  | 10
2022-01-31 00:00:00 | Product 2 |  | 11 |  |  |  |  |  | 1000
2022-01-31 00:00:00 | Product 3 |  | 50
2022-02-07 00:00:00 | Product 1 |  | 47 |  |  |  |  |  | 510
2022-02-08 00:00:00 | Product 4 |  | 54 |  |  |  |  |  | 386
2022-02-08 00:00:00 | Product 2 |  | 51 |  |  |  |  |  | 989
2022-02-08 00:00:00 | Product 1 |  | 73 |  |  |  |  |  | 463
2022-02-09 00:00:00 | Product 2 |  | 84 |  |  |  |  |  | 938
2022-02-11 00:00:00 | Product 2 |  | 33 |  |  |  |  |  | 854
2022-02-11 00:00:00 | Product 2 |  | 78 |  |  |  |  |  | 821
2022-02-14 00:00:00 | Product 4 |  | 61 |  |  |  |  |  | 332
2022-02-17 00:00:00 | Product 1 |  | 92
2022-02-22 00:00:00 | Product 3 |  | 25