tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 820542d1678156324-need-formula-to-return-balance-based-on-todays-date-sample16
Sheet: Sheet1

 |  |  | Todays Date | 2023-02-01 00:00:00
 |  |  | Balance
 |  |  | Month | Balance
 |  |  | Jan | 25000
 |  |  | Feb | 20000
 |  |  | Mar | 21000
 |  |  | Apr | 30000
 |  |  | May | 32000
 |  |  | Jun | 40000
 |  |  | Jul
 |  |  | Aug
 |  |  | Sep
 |  |  | Oct
 |  |  | Nov
 |  |  | Dec
Spreadsheet: d17ce3b6-84dc-432e-b0c4-4d5f869d06d2
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
GIAR | Test | GIAR | [NAME], Feces | Giardia Ag, F | Enzyme-Linked Immunosorbent Assay (ELISA) | Stool Container: Stool |  |  | 10 | g | Forms: If not ordering electronically, submit a Microbiology Request Form (Supply T244) with the specimen.  Submit only 1 of the following specimens:   Specimen Type: Preserved stool Container/Tube:  Preferred: Stool container with 10% buffered formalin preservative (Supply T466) Acceptable: SAF or MF [NAME]: 5 g Specimen Stability Information: Ambient (preferred)/Refrigerated   Specimen Type: Unpreserved stool Container/Tube: Stool container (Supply T288) [NAME]: 5 g Collection Instructions: See Stool Collection Information Sheet in Special Instructions. Specimen Stability Information: Frozen | 2 g | Hemolysis	NA Thawing	Warm reject; Cold OK-note to lab Lipemia	NA Icterus	NA Other	Duodenal, duodenal aspirate, or small bowel aspirate (this test is not U.S. FDA approved for these types of sources); grossly bloody stool (containing no visible stool), or | Negative | Monday through Friday; 1 p.m. | Same day/1 day | 4 days | 1 | 87329 |  |  |  |  | Rochester
GIAR | [NAME] | FECAL | Fecal |  |  |  | See instructions
GIAR | Result | 24085 | Giardia Ag, F | Giardia Ag, F | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6412-1 | Giardia lamblia Ag:ACnc:Pt:Stool:Ord:EIA
Spreadsheet: 796465d1663291030-if-multiple-query-firstnonemptycell
Sheet: Sheet1

Outcome | A | B | C | D | E | F
 | x |  |  | s
 |  |  |  | v
 |  | z
 |  |  | t
 |  |  |  |  | u
 |  | 2022-12-06 00:00:00 |  | 55
 |  |  |  |  |  | k
 |  |  | m
 |  |  |  | s
 | r
Spreadsheet: cfc3b47a-8e19-4712-9087-c330283509fa
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 | Název laboratoře:
 |  |  |  |  |  |  |  | IČ:
 | [NAME] laboratoře:
 | Protokol o zkoušce o analytickém rozboru vína č.
 | Firma:
 | [NAME], příjmení, titul: |  |  |  |  |  |  | IČ:
 | Ulice a číslo:
 | Obec a PSČ:
 | Druh vína: |  |  | Ročník: |  |  | Číslo šarže:
 | Datum přijetí vzorku: |  |  |  |  |  | Velikost šarže v l:
 | Výsledky rozborů:
 |  |  |  | Výsledek |  | [NAME] | Opakovatelnost |  | A/N | Metoda/kód
 | Skutečný obsah alkoholu |  |  |  |  | obj%
 | Celkový obsah alkoholu |  |  |  |  | obj%
 | [NAME] bezcukerného extraktu |  |  |  |  | g/l
 | [NAME] těkavých kyselin |  |  |  |  | meq/l
 | [NAME] |  |  |  |  | mg/l
 | Celkový obsah SO2 |  |  |  |  | mg/l
 | Redukující látky |  |  |  |  | g/l
 | Cukr (fruktóza+glukóza) |  |  |  |  | g/l
 | Celkový obsah kyselin |  |  |  |  | g/l
 | Sacharóza |  |  |  |  | g/l
 | Hustota relativní
 | [NAME] |  |  |  |  | MPa
 | Cukr (fruktóza+glukóza+sacharóza) |  |  |  |  | g/l
 | Protokol verze 2.5M     aktualizace 1.12.2010 |  | Ve sloupci A/N znamená A=metoda akreditovaná, N=[NAME]
 | Datum vystavení: |  |  | [NAME] pracovník:
 |  |  |  | (razítko, podpis)
 | 4
Spreadsheet: diana_scholtes__8541__trani_1999_2000
Sheet: 1999-2000

Counterparty |  | 1999 |  |  |  | 2000
 |  | Network | Intertie | Path |  | Network | Intertie | Path
Benton County PUD |  | 109491.5 |  |  |  | 199620.25
[NAME] |  | 10230.99 | 1119 | NOB |  | 164753.64 | 1282398.5 | NOB
 |  |  |  |  |  |  | 255407.78 | COB N/S
 |  |  |  |  |  |  | 64561.91 | COB S/N
Richland PUD |  | 10632.5 |  |  |  | 4070
Franklin PUD |  | 14490 |  |  |  | 7221.25
Montana |  | 6444.14 |  |  |  | 34365.92
Pacificorp |  |  |  |  |  | 75791.35 | 2684.98 | COB
 |  |  |  |  |  |  | 40293 | Cascade
Puget Sound Energy |  | 0 | 400 | COB |  | 0
Gray Harbor PUD |  | 9065 |  |  |  | 95660
Snohomish PUD |  | 201392.92 |  |  |  | 58572.92
Seattle City Light |  | 134004.55 |  |  |  | 6654
Sub Total
Portland General |  | 0 | 1347970 | COB |  | 0 | 1528578.39 | COB
Grand Total
Spreadsheet: d112f8f2-fc03-40a4-a277-185ba7f77317
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
3340 | 17090 | Stephan | Scrase | RSA | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1 | 01:13:14
3340 | 17091 | Barend | Harmse | RSA | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2 | 01:25:16
Spreadsheet: 08309c3a-e586-405e-bb2d-a80c26a2801e
Sheet: 5Yearly O&M Costs 11-20

Table 5.2.48. Present Value of Operations and [NAME] (Years 11-20)
 |  |  |  |  |  |  |  |  |  |  |  | EPA Discount Rate:
 |  |  |  | Present Value of O&M Costs for Year:
Component | Unit Cost | Unit | Quantity | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
 |  |  | Total Present Value of Yearly O&M Expenses (Years 11-20):
 |  |  |  |  |  |  |  |  |  |  |  | Total Present Value of Annual O&M Costs (Life of Project):
i= | 0.04875
Spreadsheet: 538840d1505842843-pivot-table-displaying-old-data-s666-newpts-53rd-street-cost-schedule-4
Sheet: Draw 11 - 09.17.17

Description | Line Item | Line Item # | Date | Amount | Payee | Notes |  | Line Item | Sum of Line Item # | Sum of Amount
Construction Change | Entitlements/Permits | 102 | 2017-09-05 00:00:00 | 406 | City of San Diego | Construction change permit fees |  | Block/Retaining Walls | 2760 | 7417.440000000001
Construction BMP | Erosion Control | 211 | 2017-09-11 00:00:00 | 120 | Art's Trench Plate | Stabilized construction entrance |  | Entitlements/Permits | 102 | 406
Retaining Wall Materials | Block/Retaining Walls | 345 | 2017-09-08 00:00:00 | 290.44 | Home Depot | Retaining wall materials |  | Erosion Control | 211 | 120
Retaining Wall Materials | Block/Retaining Walls | 345 | 2017-09-12 00:00:00 | 84.85 | Home Depot | Retaining wall materials |  | Grand Total | 3073 | 7943.440000000001
Retaining Wall Materials | Block/Retaining Walls | 345 | 2017-09-11 00:00:00 | 499.79 | RCP Block and [NAME] | Retaining wall materials
Retaining Wall Labor | Block/Retaining Walls | 345 | 2017-09-15 00:00:00 | 2500 | [NAME] | Retaining wall labor
Retaining Wall Materials | Block/Retaining Walls | 345 | 2017-09-15 00:00:00 | 3300 | EH Concrete | Retaining wall materials
Retaining Wall Labor | Block/Retaining Walls | 345 | 2017-09-15 00:00:00 | 570 | [NAME] | Retaining wall labor
Retaining Wall Materials | Block/Retaining Walls | 345 | 2017-09-11 00:00:00 | 86.18 | Thompson's Building Supply | Retaining wall materials
Retaining Wall Materials | Block/Retaining Walls | 345 | 2017-09-11 00:00:00 | 86.18 | Thompson's Building Supply | Retaining wall materials
Spreadsheet: kate_symes__18862__SP 15 pages
Sheet: DJ SP15

 |  |  | Firm | Volume | Firm | Volume | Sun & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | 24 HOUR | [NAME]
 | 2001-03-15 00:00:00 |  | 184.07 | 20192 | 129.29 | 6440
 | 2001-03-14 00:00:00 |  | 169.24 | 16576 | 110.08 | 7280
 | 2001-03-13 00:00:00 |  | 170.67 | 19648 | 104.69 | 3840
 | 2001-03-12 00:00:00 |  | 183.93 | 23040 | 107.19 | 6880
 | 2001-03-11 00:00:00 |  |  |  |  |  | 107.67 | 17640
 | 2001-03-10 00:00:00 |  | 156.73 | 17840 | 98.45 | 6040
 | 2001-03-09 00:00:00 |  | 157.31 | 16960 | 98.45 | 6040
 | 2001-03-08 00:00:00 |  | 213.95 | 22880 | 131.78 | 6600
 | 2001-03-07 00:00:00 |  | 313.92 | 24048 | 201.19 | 6080
 | 2001-03-06 00:00:00 |  | 339.12 | 29856 | 231.76 | 7080
 | 2001-03-05 00:00:00 |  | 299.82 | 13200 | 217.92 | 3080
 | 2001-03-04 00:00:00 |  |  |  |  |  | 217.92 | 9240
 | 2001-03-03 00:00:00 |  | 248.15 | 15920 | 165.24 | 2720
 | 2001-03-02 00:00:00 |  | 248.24 | 16400 | 165.07 | 3320
 | 2001-03-01 00:00:00 |  | 264.44 | 17648 | 164.24 | 7520
 | 2001-02-28 00:00:00 |  | 181.23 | 21200 | 120.65 | 4728
 | 2001-02-27 00:00:00 |  | 185.42 | 15344 | 116.58 | 2800
 | 2001-02-26 00:00:00 |  | 193.48 | 13840 | 132.88 | 4800
 | 2001-02-25 00:00:00 |  |  |  |  |  | 132.88 | 14400
 | 2001-02-24 00:00:00 |  | 177.7 | 16000 | 131.62 | 11200
 | 2001-02-23 00:00:00 |  | 179.36 | 17040 | 131.62 | 11200
 | 2001-02-22 00:00:00 |  | 229.75 | 23200 | 149.39 | 6448
 | 2001-02-21 00:00:00 |  | 236.72 | 25840 | 160.28 | 7840
 | 2001-02-20 00:00:00 |  | 262.61 | 9200 | 190 | 5200
 | 2001-02-19 00:00:00 |  | 262.12 | 13200 | 190.74 | 5400
 | 2001-02-18 00:00:00 |  |  |  |  |  | 261.52 | 23280
 | 2001-02-17 00:00:00 |  | 323.71 | 16720 | 264.62 | 8840
 | 2001-02-16 00:00:00 |  | 431.67 | 19680 | 296.75 | 12600
 | 2001-02-15 00:00:00 |  | 431.67 | 19680 | 296.75 | 12600
 | 2001-02-14 00:00:00 |  | 267.18 | 20320 | 202.45 | 6200
 | 2001-02-13 00:00:00 |  | 233.43 | 13520 | 159.16 | 7400
Spreadsheet: 087a2d28-245b-4292-8f58-bbd6696722d9
Sheet: Sheet1

Unnamed: 0 | The University of Louisiana at Monroe | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | 04 | Unnamed: 8
 | 04 STUDENT WORKER TIME SHEET
Complete in Ink or Type…failure to complete correctly will slow the processing of this voucher.
CWID: |  |  |  | Name:
 | (No Social Security Numbers)
FEDERAL WORK STUDY
Time sheet below must be completed and returned to the Payroll Office by last working day of the month.
 | Month: |  |  | Year:
 | Date | Start | End | Start | End | Start | End | Totals
 | 1 |  |  |  |  |  |  | 0
 | 2 |  |  |  |  |  |  | 0
 | 3 |  |  |  |  |  |  | 0
 | 4 |  |  |  |  |  |  | 0
 | 5 |  |  |  |  |  |  | 0
 | 6 |  |  |  |  |  |  | 0
 | 7 |  |  |  |  |  |  | 0
 | 8 |  |  |  |  |  |  | 0
 | 9 |  |  |  |  |  |  | 0
 | 10 |  |  |  |  |  |  | 0
 | 11 |  |  |  |  |  |  | 0
 | 12 |  |  |  |  |  |  | 0
 | 13 |  |  |  |  |  |  | 0
 | 14 |  |  |  |  |  |  | 0
 | 15 |  |  |  |  |  |  | 0
 | 16 |  |  |  |  |  |  | 0
 | 17 |  |  |  |  |  |  | 0
 | 18 |  |  |  |  |  |  | 0
 | 19 |  |  |  |  |  |  | 0
 | 20 |  |  |  |  |  |  | 0
 | 21 |  |  |  |  |  |  | 0
 | 22 |  |  |  |  |  |  | 0
 | 23 |  |  |  |  |  |  | 0
 | 24 |  |  |  |  |  |  | 0
 | 25 |  |  |  |  |  |  | 0
 | 26 |  |  |  |  |  |  | 0
 | 27 |  |  |  |  |  |  | 0
 | 28 |  |  |  |  |  |  | 0
 | 29 |  |  |  |  |  |  | 0
 | 30 |  |  |  |  |  |  | 0
 | 31 |  |  |  |  |  |  | 0
 |  |  |  |  | Total Hours Worked |  |  | 0
Rev. 8/2/2011 |  |  |  |  | Hourly Wage |  | 7.25 | 0
 |  |  |  |  | SUPERVISOR
 |  |  |  |  | Printed Name:
STUDENT SIGNATURE |  |  | Date
 |  |  |  |  | Department:
SUPERVISOR SIGNATURE |  |  | Date |  | Phone #:
Instructions:  Enter start and end times you worked - indicate am or pm - do not use periods - the spreadsheet will compute the hours for you.                                     Example:
October |  | Start | End | Start | End | Start | End | Totals
3 | Monday | 08:20:00 | 13:15:00 | 15:00:00 | 16:25:00 |  |  | 6.333333333333333
4 | Tuesday | 11:00:00 | 12:00:00 |  |  |  |  | 1
 |  |  |  |  | Total Hours Worked |  |  | 7.333333333333334
 |  |  |  |  | Hourly Wage |  | 7.25 | 53.16666666666667
Spreadsheet: 1a658463-0197-46aa-891a-79775ea6c43f
Sheet: Sheet1

2015-2016 Class Schedule | 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 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | You may select up to three classroom attributes.  Select only course requirements, as the number of available classrooms will be reduced with each attribute selected. | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23
Administrative Licensure
Fall 2015
Subject | Course and Title | Subtitle/Alternate Title | Section | [NAME] | Part of Term | Dates | Days | Times | Credits | Instructor(s) | Instructor ID | FT or Adj | Contract Code | Percentage | Registration Approval | [NAME] | Blackboard Y/N | Campus: [NAME], [NAME], Online, Blended |  |  |  | Cross list?   SUBJ CRSE SEC | Comments
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Classroom Attribute A | Classroom Attribute B | Classroom Attribute C
Spreadsheet: 184624d1349331836-how-to-merge-two-data-sets-to-create-a-single-large-data-set-october-3-2012-help-file
Sheet: Sheet1

Step 1 | Step 2 |  | Names | Data
Name 1 | Data1
Name 2 | Data2
Name 3 | Data3
Spreadsheet: 220242d1363105883-returns-the-header-label-if-the-condition-is-met-buyers
Sheet: Sheet2

 | Last Purchase | Jan 11 | Feb 11 | [NAME] 11 | Apr 11 | May 11 | Jun 11 | Jul 11 | Aug 11 | Sep 11 | Oct 11 | Nov 11 | Dec 11 | Jan 12 | Feb 12 | [NAME] 12 | Apr 12 | May 12 | Jun 12 | Jul 12 | Aug 12 | Sep 12 | Oct 12 | Nov 12 | Dec 12
Buyer 1 |  | 120 | 120 | 120 | 0 | 0 | 120 | 120 | 0 | 60 | 120 | 0 | 120 | 0 | 120 | 120 | 0 | 120 | 120 | 120 | 0 | 120 | 120 | 120 | 0
Buyer 2 |  | 0 | 0 | 106 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Buyer 3 |  | 48 | 0 | 48 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Buyer 4 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 194 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 3e7d8c7d-0de7-4135-a2a7-50173407a2fc
Sheet: Gilroy

REGIONAL DIRECTORY 2014/2015
GILROY UNIFIED SCHOOL DISTRICT
Dr. [NAME], [NAME] | Kimberly Mason, Supervisor Fiscal Service | [NAME], MEP Administrator
7810 Arroyo Circle | 7810 Arroyo Circle | 7810 Arroyo Circle
Gilroy, CA 95020 | Gilroy, CA 95020 | Gilroy, CA 95020
O: 408-847-2700x 7262 | O: [PHONE] | O: [PHONE]
F: [PHONE] | F: [PHONE] | F: [PHONE]
[NAME] | [EMAIL] | [NAME]
[NAME], [NAME] Secretary | TBD, [NAME] | [NAME], [NAME]
7810 Arroyo Circle | 7810 Arroyo Circle | 7810 Arroyo Circle
Gilroy, CA 95020 | Gilroy, Ca 95020 | Gilroy, CA 95020
O: [PHONE] | O: [PHONE] | O: [PHONE]
F: [PHONE] | C: [PHONE] | C: [PHONE]
[EMAIL] | F: [PHONE] | F: [PHONE]
 |  | [NAME]
Lydia Cano, Prek Paraprofessional | TBD, Prek Teacher | [NAME], CHS PASS
7810 Arroyo Circle | 7810 Arroyo Circle | 7810 Arroyo Circle
Gilroy, CA 95020 | Gilroy, CA 95020 | Gilroy, CA 95020
O: [PHONE] | O: [PHONE], Ext. 3528 | O: [PHONE], Ext. 2614
C: [PHONE] | F: 408- 847-1219 | F: 408- 847-1219
F: [PHONE] |  | [NAME]
[EMAIL]
[NAME], GHS PASS
7810 Arroyo Circle
Gilroy, CA 95020
O: [PHONE], Ext. 7504
F: 408- 847-1219
[NAME]
Spreadsheet: 81029d1281309128-excel-2007-problem-sorting-numbers-as-text-string-numberstotextformatprob
Sheet: Sheet1

ID
14627
14629
14632
14633
14634
15004
15017
15026
15030
15036
15043
15047
03531 | <- Chanage cell so it is Text Like ones above so sorting will be correct.
03536
03702
03703
03703
06588
06801
06809
06819
06858
06863
Spreadsheet: 756229d1637341902-if-text1-and-text-2-are-equal-to-text-3-then-return-value-catalogue-issue
Sheet: Sheet1

 | Order Code | PP,OS,NH | PP | NH | Code Insert | Value | Code Price
 | 1433 | NH | 28.5 | 20 | CDG
 | ABA | NH | 70.24 | 68 | [NAME] |  |  |  | Follow the steps in the comments
 | [NAME] | NH | 109.94 | 68 | XSTA |  |  |  | It doesn’t follow the steps I need but I would like it work so that whatever code I place in the column "code insert",  it should return the price value into the cell to the right with the price according to the acronymn in the "PP,OS,NH". As in if [NAME] is entered and the cell to the right of [NAME] in the order code column states its PP then £47.53 IS returned.
 | ACCR | NH | 25.45 | 20 | CLDH
 | AZ1 | PP | 132 | 145 | CSFG
 | CSFA | NH | 110 | 110 | GAB1
 | XSTA | PP | 55 | 55 | [NAME]
 | Triage | NH | 85 | 59 | NMAG
 | CDG | pp | 53.95 | 50 | AZ1
 | CFER | NH | 10.18 | 5 | CGAD
 | CIGM | PP | 10 | 6 | NEUR
 | CLDH | PP | 12 | 8 | CSFL
 | CNFL | PP | 45 | 40 | DPPX
 | CSFG | NH | 12.22 | 10 | GAD
 | CSFL | PP | 25.45 | 20 | CSFG
 | DPPX | NH | 50 | 50 | VEGF
 | GAB1 | PP | 47.85 | 40 | OCB
 | GAB2 | NH | 32.58 | 20 | CNEU
 | [NAME] | PP | 47.85 | 40 | PLAC
 | GAD | NH | 30 | 30 | NMDA
 |  |  | 30 | 30 | NMOD
 | CGAD | NH | 30 | 30 | NCYK
 | NABS | PP | 53.95 | 90 | PLAC
 | NCYK | NH | 0.01 | 0.01
 | NEUR | PP | 54.97 | 40
 | CNEU | NH | 54.97 | 40
 | NIAT | PP | 35 | 35
 | PLAC | NH | 8.14 | 5.09
 | NLAC | PP | 8.14 | 5
 | NMAG | NH | 30 | 30
 | CNMD | PP | 50 | 40
 | NMDA | NH | 50.9 | 40
 | CMOD | PP | 45 | 40
 | NMOD | NH | 45 | 40
 |  |  | 5 | 5
 | OCB | PP | 47.85 | 45
 | [NAME] | NH | 55 | 55
 | S100 | PP | 70 | 40
 | VEGF | NH | 59.04 | 55
 | CVKC | PP | 100 | 75
 | VKCA | NH | 100 | 75
 | XANT |  | 98.75 | 58
Spreadsheet: 804491d1668099831-i-need-a-formula-for-an-avg-of-a-data-set-found-on-multiple-sheets-but-must-exclude-zeroes-dans-driver-list
Sheet: 930

First | Last | 4 week Score Avg | 4 week Incident per [NAME] | Week 41 Score | Week 41 Incidents Per Mile | Week 42 Score | Week 42 Incidents Per Mile | Week 43 Score | Week 43 Incidents Per Mile | Week 44 Score | Week 44 Incidents Per Mile
[NAME] | [NAME] |  |  | n/a | n/a | n/a | n/a | 91 | 0.83 | 98 | 0.33
[NAME] | Degner |  |  | n/a | n/a | 88 | 1.13 | 88 | 1.47 | n/a | n/a
[NAME] | [NAME] |  |  | n/a | n/a | n/a | n/a | n/a | n/a | 79 | 1.98
[NAME] | Luth |  |  | 93 | 0.85 | 94 | 0.74 | 95 | 0.65 | 94 | 0.76
Nathan | Maly |  |  | 90 | 1.16 | 86 | 1.49 | 87 | 1.41 | 88 | 1.47
[NAME] | [NAME] |  |  | 88 | 0.82 | 86 | 0.9 | 87 | 1.06 | 92 | 0.99
Stevi | [NAME] |  |  | n/a | n/a | 95 | 0.58 | n/a | n/a | n/a | n/a
[NAME] | [NAME] |  |  | 92 | 0.75 | 90 | 1.48 | 92 | 1.18 | 90 | 1.23
Vera | Wildeman |  |  | 98 | 0.2 | 96 | 0.41 | 95 | 0.49 | 95 | 0.45
 | Store Average
Spreadsheet: 775188d1648894552-help-with-bring-the-value-of-whichever-cell-has-value-example
Sheet: Sheet1

B.USD | B.EUR | B.STR | B.
15 |  |  | only one cell has value always - this cell needs to have the value of whichevr cell is full
 | 4521
 |  | 252
 |  | 300
 |  | 210
 | 7000
23
50
12
 | 3200
 |  | 152
 |  | 721
 | 2300
 | 2500
 | 1500
50
30
45
Spreadsheet: 51538d1251201642-extracting-information-based-on-drop-down-selection-drop_down_sol
Sheet: Grid

Campaigns | Marketing | Advertising | Sales Promotion | Events | Training
Campaign 1 | 100 |  |  |  | 567
Campaign 2 |  | 150
Campaign 3 |  |  | 134 | 123
Campaign 4 | 290 |  |  |  | 600
Campaign 5 |  |  |  | 234
Campaign 6 | 238 | 245 |  |  | 900
Campaign 7 | 300
Spreadsheet: 153458d1335918305-excel-dragging-formulas-to-report-totals-from-every-9th-column-on-a-different-sheet-bifm-example
Sheet: REPORTS

 | Total Deposit | Application Fees | Late Application Fees | Weekly Booth Fees | No-Show Fees | Farm Sales | Processor Sales | Craft Sales | Concession Sales | Other Sales | Music Donations | Musician Costs | Total Bag Sale | Net Profit Bag Fund-Raiser | Weather | Temp
Pre-Opening |  | 2360 | 25
2012-04-14 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sunny | 55
2012-04-21 00:00:00 |  | 5 | 25 |  |  |  |  |  |  |  |  |  |  |  | sunny | 65
2012-04-28 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | partial sun | 55
2012-05-05 00:00:00
2012-05-12 00:00:00
2012-05-19 00:00:00
2012-05-26 00:00:00
2012-06-02 00:00:00
2012-06-09 00:00:00
2012-06-16 00:00:00
2012-06-23 00:00:00
2012-06-30 00:00:00
2012-07-07 00:00:00
2012-07-14 00:00:00
2012-07-21 00:00:00
2012-07-28 00:00:00
2012-08-04 00:00:00
2012-08-11 00:00:00
2012-08-18 00:00:00
2012-08-25 00:00:00
2012-09-01 00:00:00
2012-09-08 00:00:00
2012-09-15 00:00:00
2012-09-22 00:00:00
2012-09-29 00:00:00
2012-10-06 00:00:00
2012-10-13 00:00:00
2012-10-20 00:00:00
2012-10-27 00:00:00
Spreadsheet: 127161d1320189394-how-to-calculate-date-of-the-next-dayofweek-after-given-date-dow2
Sheet: Sheet1

2011-10-01 00:00:00 | sunday | monday |  | monday
2011-10-02 00:00:00 | 1 | 2 |  | tuesday
2011-10-03 00:00:00 |  |  |  | wednesday
2011-10-09 00:00:00 |  |  |  | thursday
2011-10-10 00:00:00 |  |  |  | friday
2011-10-16 00:00:00 |  |  |  | saturday
2011-10-17 00:00:00 |  |  |  | sunday
2011-10-23 00:00:00
2011-10-24 00:00:00
2011-10-30 00:00:00 | <<<<<formula uses eomonth function requires you activate the analysis tool pack
2011-10-31 00:00:00 | <<<<<<
Spreadsheet: 187709d1350564782-complicated-look-up-without-making-changes-to-the-values-in-the-table-complicated-look-result2-up
Sheet: Sheet1

Type A | Type B | Result |  | Correct Result
CustomVue Key Cards | 1 Procedure | CUSTOM VUE |  | [NAME]
 | 10 Procedures | CUSTOM VUE |  | [NAME]
Standard Key Cards | 10 Procedures | STANDARD LASIK |  | [NAME]
[NAME] | ZCT100 | [NAME] |  | [NAME]
 | ZCT150 | [NAME] |  | [NAME]
 | ZCT225 | [NAME] |  | [NAME]
 | ZCT300 | [NAME] |  | [NAME] |  | Type A | Type B | RESULT
 | ZCT400 | [NAME] |  | [NAME] |  | Standard Key Cards | 10 Procedures | STANDARD LASIK
[NAME] | ZMA00 | TECNIS MF 3PC (ACR) |  | TECNIS MF 3PC (ACR) |  | CustomVue Key Cards | 1 Procedure | CUSTOM VUE
 | [NAME] | TECNIS MF 1 PC (ACR) |  | TECNIS MF 1 PC (ACR) |  | CustomVue Key Cards | 10 Procedures | CUSTOM VUE
 |  |  |  |  |  | [NAME] | ZCT100 | [NAME]
 |  |  |  |  |  | [NAME] | ZCT150 | [NAME]
 |  |  |  |  |  | [NAME] | ZCT225 | [NAME]
 |  |  |  |  |  | [NAME] | ZCT300 | [NAME]
 |  |  |  |  |  | [NAME] | ZCT400 | [NAME]
 |  |  |  |  |  | [NAME] | ZMA00 | TECNIS MF 3PC (ACR)
 |  |  |  |  |  | [NAME] | [NAME] | TECNIS MF 1 PC (ACR)
 |  | [NAME] to look up values in column A and B
 |  | from look Table column G & H and derive result from
 |  | column I.
 |  | Please note, no change to be made to the structure of
 |  | column A. Blan cells should remain as it is.