tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 48212d1247478819-n-a-formula-check-consumables-stored-in-am-rack
Sheet: Contact details

Supplier Details & Process
Supplier | Contact 1 | Contact 2 | Address | Lead Times | Process
Network Packaging | [NAME] | [NAME] | Unit 5 [NAME] | 2-3 days for stock items - can do nextday if urgent | Raise iforce PO and email to contacts. Recharge to SSL at cost
 | 07971 560333 |  | Spring Road Ind Est
 | 01902 407263 | 01902 407263 | Ettingshall
 | [EMAIL] |  | Wolverhampton
 |  |  | WV4 6AU
Europackaging |  |  |  | TBC | Raise PO on SSL system
Forms Plus | Vicky / Liz | Elwyn | Water ma trout ind est | variable - check first | Raise iforce PO and email to contacts. Recharge to SSL at cost
 | 01326 564331 |  | Helston
 |  |  | Cornwall
 | [EMAIL] |  | TR13 0LW
 | [EMAIL]
Earlsmere | [NAME] |  | Earlsmere house | variable - check first | Raise iforce PO and email to contacts. Recharge to SSL at cost
 | 01226 750111 |  | Earlsmere drive
 |  |  | Ardsley
 | [EMAIL] |  | Barnsley
 |  |  | S71 5EH
Office Depot | [NAME] | via call centre | Greenwich Way | variable - check first | Raise iforce PO and order online. Recharge to SSL at cost
 | 07786 337376 | [PHONE] | Andover
 | can order online |  | Hampshire
 | [EMAIL] |  | SP10 4JZ
Laserlife | [NAME] |  | 15 tennis street | variable - check first | Raise iforce PO and email to contacts. Recharge to SSL at cost
 | [PHONE] |  | Southwark
 |  |  | London
 | [EMAIL] |  | SE1 1YD
Spreadsheet: 86857d1286817557-downcount-of-days-left-in-one-month-networkdays
Sheet: Sheet2

1st Day Of Month | Start Date | Today | WorkDays Left
2010-10-01 00:00:00 | 2010-10-31 00:00:00
2010-11-01 00:00:00
Spreadsheet: 800277d1665576698-need-help-extracting-data-from-a-table-using-a-name-table-search
Sheet: Sheet1

Text To Find : | [NAME] |  |  | Table :
Results |  |  |  | Registration No. | Name | Registration No. | Name | Registration No. | Name | Registration No. | Name
List of Found Names : |  |  |  | 1 | [NAME] | 6 | [NAME] | 11 | [NAME] | 16 | [NAME]
 | Name | Registration Number |  | 2 | [NAME] | 7 | [NAME] | 12 | [NAME] | 17 | [NAME]
1 | [NAME] | 1 |  | 3 | [NAME] | 8 | [NAME] | 13 | [NAME] | 18 | [NAME]
2 | [NAME] | 8 |  | 4 | [NAME] | 9 | [NAME] | 14 | [NAME] | 19 | [NAME]
3 | [NAME] | 15 |  | 5 | [NAME] | 10 | [NAME] | 15 | [NAME] | 20 | [NAME]
4 | [NAME] | 17
Spreadsheet: 71790d1272503620-how-to-count-entries-if-sheet1-cell-sheet2-title-entries-count
Sheet: summary

Date | Move Option | FROM DC | TO DC |  | Linux | Solaris | Windows | MDS | MSSQL | Oracle | Sybase | SAN | Comments
2010-05-08 00:00:00 | [NAME] and Shift | Flat 1 | house 3 | Lift and ShiftFlat 1house 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2010-05-08 00:00:00 | Cat 5 to Cat 6 Network Port Migrations | house 3 | House 3 | Cat 5 to Cat 6 Network Port Migrationshouse 3House 3 | 1 | 2 | 1 | 0 | 0 | 0 | 0 | 0
2010-05-08 00:00:00 | [NAME] and Shift | house 1 | house 2 | [NAME] and Shifthouse 1house 2 | 9 | 12 | 17 | 0 | 0 | 0 | 0 | 0
2010-05-08 00:00:00 | [NAME] and Shift | house 2 | House 2 | [NAME] and Shifthouse 2House 2 | 8 | 2 | 0 | 0 | 0 | 0 | 0 | 0
2010-05-08 00:00:00 | SAN Remediation | House 1 | House 2 | SAN RemediationHouse 1House 2 | 1 | 1 | 2 | 0 | 0 | 0 | 0 | 0
2010-05-15 00:00:00 | [NAME] and Shift | Flat 1 | house 3 | Lift and ShiftFlat 1house 3 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0
2010-05-15 00:00:00 | Cat 5 to Cat 6 Network Port Migrations | house 3 | House 3 | Cat 5 to Cat 6 Network Port Migrationshouse 3House 3 | 1 | 2 | 1 | 0 | 0 | 0 | 0 | 0
2010-05-15 00:00:00 | [NAME] and Shift | house 1 | house 2 | [NAME] and Shifthouse 1house 2 | 9 | 12 | 17 | 0 | 0 | 0 | 0 | 0
2010-05-15 00:00:00 | [NAME] and Shift | house 2 | House 2 | [NAME] and Shifthouse 2House 2 | 8 | 2 | 0 | 0 | 0 | 0 | 0 | 0
2010-05-15 00:00:00 | SAN Remediation | House 1 | House 2 | SAN RemediationHouse 1House 2 | 1 | 1 | 2 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 811957d1672888609-formula-to-show-the-reporting-month-instead-of-the-actual-month-based-on-week-number-reportingmonthsample2
Sheet: Sheet1

Created By | Actual Month | Reporting Month | Week#
2022-11-28 00:00:00 |  | November
2022-12-01 00:00:00 |  | November
2023-12-05 00:00:00 |  | December
2023-01-30 00:00:00 |  | January
2023-02-01 00:00:00 |  | January
2023-03-01 00:00:00 |  | February
2023-05-29 00:00:00 |  | May
2023-06-02 00:00:00 |  | May
2023-07-31 00:00:00 |  | July
2023-08-03 00:00:00 |  | July
2023-09-01 00:00:00 |  | August
2023-10-31 00:00:00 |  | October
2023-11-03 00:00:00 |  | October
2023-12-01 00:00:00 |  | November
Spreadsheet: 718412d1613136458-3-way-match-excel-forum-question
Sheet: CBtrans

company | cashbook | doc-id | docnumber | yearno | period | docdate | account | baseval | currency | xchar
5180 | 1 | CP01 | 7484 | 2019 | 11 | 2021-01-20 00:00:00 | [NAME] | -6408.95 | GBP | -6408.95
5176 | 1 | CP01 | 8281 | 2019 | 11 | 2021-01-20 00:00:00 | [NAME] | -6404.61 | GBP | -6404.61
5278 | 1 | CP01 | 7898 | 2020 | 11 | 2021-01-20 00:00:00 | Martyn | -5654.35 | GBP | -5654.35
5323 | 1 | CP01 | 7268 | 2019 | 11 | 2021-01-20 00:00:00 | Mark | -5212.59 | GBP | -5212.59
5014 | 1 | CP01 | 7201 | 2020 | 11 | 2021-01-20 00:00:00 | Stuart | -5164.92 | GBP | -5164.92
5023 | 1 | CP01 | 8673 | 2020 | 11 | 2021-01-20 00:00:00 | [NAME] | -5157.91 | GBP | -5157.91
Spreadsheet: 121647d1316215411-calculating-interest-with-late-fees-loansinterest
Sheet: Sheet2

Month | Balance | Pmt Amt | Interest | Principal | Late Charge | New Balance |  | 30000 | Loan Amt
1 |  |  |  |  | 35 |  |  | 0.065 | Annual Rate
2 |  |  |  |  | 0 |  |  | 450 | Monthly Pmt
3 |  |  |  |  | 0
4 |  |  |  |  | 35 |  |  |  | Change the yellow cells to see what happens
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
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
Spreadsheet: 117574d1312890773-excel-2007-remove-series-total-data-markers-on-charts-warehouse-damages
Sheet: Data

 | MAIN | MID-AM | EXTERNAL
Jan.11 | 0 | 218.44 | 7.59
Feb.11 | 587.36 | 0 | 375.68
Mar.11 | 312.51 | 228.2 | 0
Apr.11 | 265.91 | 84.61 | 37.31
May.11 | 180.81 | 132.59 | 0
Jun.11 | 176.14 | 32 | 0
Jul.11 | 1150.47 | 198.91 | 0
Aug.11
Sep.11
Oct.11
Nov.11
Dec.11
2011 Total | 2673.2 | 894.75 | 420.58
Spreadsheet: 136862d1326852721-how-to-calculate-unknown-x-values-dnacalculate
Sheet: List ; Plates 1 - 1

Plate | Repeat | Well | Type | Time | 485/535exc/emYui (Counts) |  |  |  | Standard curve | ng/ul (x) | Absorbance (y) |  | Atenuis | Absorbance (y) |  | P damicornis | Absorbance (y)
1 | 1 | A01 | M | 00:00:15.810000 | 1620 |  |  |  | A01 | 0 | 1620 |  | A02 | 9859 |  | A03 | 30848
1 | 1 | A02 | M | 00:00:17.080000 | 9859 |  |  |  | B01 | 0.0001 | 1869 |  | B02 | 13634 |  | B03 | 47621
1 | 1 | A03 | M | 00:00:18.360000 | 30848 |  |  |  | C01 | 0.001 | 1927 |  | C02 | 5995 |  | C03 | 9205
1 | 1 | B01 | M | 00:00:21.280000 | 1869 |  |  |  | D01 | 0.01 | 3226 |  | D02 | 3715 |  | D03 | 4594
1 | 1 | B02 | M | 00:00:22.550000 | 13634 |  |  |  | E01 | 0.1 | 16146 |  | E02 | 3574 |  | E03 | 3306
1 | 1 | B03 | M | 00:00:23.820000 | 47621 |  |  |  | F01 | 1 | 112921
1 | 1 | C01 | M | 00:00:26.750000 | 1927 |  |  |  | G01 | 10 | 1097635
1 | 1 | C02 | M | 00:00:28.020000 | 5995
1 | 1 | C03 | M | 00:00:29.290000 | 9205
1 | 1 | D01 | M | 00:00:32.210000 | 3226
1 | 1 | D02 | M | 00:00:33.480000 | 3715
1 | 1 | D03 | M | 00:00:34.760000 | 4594
1 | 1 | E01 | M | 00:00:37.680000 | 16146
1 | 1 | E02 | M | 00:00:38.950000 | 3574
1 | 1 | E03 | M | 00:00:40.220000 | 3306
1 | 1 | F01 | M | 00:00:43.150000 | 112921
1 | 1 | G01 | M | 00:00:44.420000 | 1097635
Please note: Cells O2:O6 and R2:R6 are the known y-values from which I need to calculate
the unknown x-values using the standard curve on this graph
Spreadsheet: 5fdbbeb9-8d27-4aba-b70d-6c4713fb76c6
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
VLTU | Test | VLTU | Volatile Screen, [NAME] | [NAME], U | Headspace Gas Chromatography-Flame Ionization Detector (HSGC-FID) Includes methanol, ethanol, isopropanol, and acetone. | [NAME]: Urine |  |  | 10 | mL | Container/Tube: Plastic, 10-mL urine tube (Supply T068) [NAME]: 10 mL Collection Instructions:  1. Collect a random urine specimen. 2. No preservative. | 1 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | METHANOL Not detected (Positive results are quantitated.) [NAME] concentration: 10 mg/dL Toxic concentration: > or =10 mg/dL   ETHANOL Not detected (Positive results are quantitated.) [NAME] concentration: 10 mg/dL   ISOPROPANOL Not detected (Positive results are quantitated.) [NAME] concentration: 10 mg/dL Toxic concentration: > or =10 mg/dL   ACETONE Not detected (Positive results are quantitated.) [NAME] concentration: 10 mg/dL Toxic concentration: > or =10 mg/dL | Monday through Sunday; Varies | Same day/1 day | 2 days | 1 | 84600 |  |  |  |  | Rochester
VLTU | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 72 hours
VLTU | Result | 8826 | [NAME], U | [NAME], U | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12983-3
VLTU | Result | 30904 | Methanol, U | Methanol, U | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 5695-2
VLTU | Result | 30905 | Ethanol, U | Ethanol, U | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 5645-7
VLTU | Result | 30906 | Acetone, U | Acetone, U | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 5570-7
VLTU | Result | 30907 | Isopropanol, U | Isopropanol, U | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 9434-2
VLTU | Result | 34378 | Chain of Custody | Chain of Custody | Numeric
Spreadsheet: 675735d1588443673-use-data-in-multiple-cells-to-return-result-example
Sheet: Feb - Inv

 | Month | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AM
 | Year | 2021 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PM
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | All Day
Child's Name | Parent's Name | Address
 |  |  | 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
Spreadsheet: 47173d1246058672-lookup-and-result-on-condition-tek-lookupreferencestest
Sheet: Data

Supplier | Account | Month | Code | Date | Jef1 | Jef2 | Amount | Key
Dabs | 11010 | 1 | 20811 | 2008-07-31 00:00:00 | JE: S/J  2008091 | Monthly charge | -119.49 | 0
Dabs | 11010 | 1 | 22525 | 2008-07-31 00:00:00 | JE: S/J  2008091 | Monthly charge | -119.49 | 0
Dabs | 11010 | 1 | 22898 | 2008-07-31 00:00:00 | JE: S/J  2008091 | Monthly charge | -119.49 | 0
Dabs | 11010 | 7 | 23393 | 2008-07-31 00:00:00 | JE: S/J  2008091 | Monthly charge | -119.49 | 0
Dabs | 11010 | 8 | 23931 | 2008-07-31 00:00:00 | JE: S/J  2008091 | Monthly charge | -119.49 | 0
Dabs | 11010 | 9 | 24429 | 2009-03-31 00:00:00 | JE: S/J  2008091 | Monthly charge | -119.49 | 0
Dabs | 11010 | 10 | 25025 | 2009-04-30 00:00:00 | JE: S/J  2008091 | Monthly charge | -119.49 | 1
Currys | 13020 | 9 | 20811 | 2009-03-31 00:00:00 | JE: S/J  2008091 | Monthly charge | -6.71 | 1
Currys | 13020 | 10 | 25025 | 2009-04-30 00:00:00 | JE: S/J  2008091 | Monthly charge | -6.71 | 2
Dell | 13021 | 10 | 25025 | 2009-04-30 00:00:00 | JE: S/J  2008091 | RB Adjustment | -39.77 | 3
Dell | 13021 | 10 | 25028 | 2009-04-30 00:00:00 | JE:m/a journal | RB adjust P1-9 | 196.33 | 3
GB | 14010 | 1 | 23477 | 2009-01-01 00:00:00 | JE:m/a journal |  | 6099.43 | 3
GB | 14010 | 8 | 23478 | 2009-01-01 00:00:00 | JE: S/J  2008091 | Monthly charge | -659.94 | 3
GB | 14010 | 9 | 23479 | 2009-01-01 00:00:00 | JE: S/J  2008091 | Monthly charge | -659.94 | 3
GB | 14010 | 10 | 23480 | 2009-01-01 00:00:00 | JE: S/J  2008091 | Monthly charge | -659.94 | 3
Total | 14011 | 6 | 23089 | 2009-01-01 00:00:00 | JE:m/a journal |  | -3415.54 | 3
Total | 14011 | 7 | 23090 | 2009-01-01 00:00:00 | JE: S/J  2008091 | RB adjustment | 152.44 | 3
Total | 14011 | 7 | 23091 | 2009-01-01 00:00:00 | JE:m/a journal |  | -2591.15 | 3
Tech | 22010 | 1 | 23090 | 2008-07-01 00:00:00 | JE:INVOICING -OR |  | -192.72 | 3
Spreadsheet: 850135d1700515137-wrong-sum-up-values-from-a-range-with-xlookup-and-index-match-formula-overtime-blank-format-2017-2-
Sheet: AUTHORIZATION (11)

# | Emp. # | Employee Name |  |  | 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 | Total | Employee Signature
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | الإجمالى | توقيع الموظف |  | 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
1 | 4192 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:00:00
2 | 8574
3 | 15242
4 | 13947
5 | 15889
6 | 12639
7 | 18162
8
9
10
11
12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Overtime Hour
Spreadsheet: 11d3be53-a70b-4cfc-a4df-e15dc30ed672
Sheet: Voornaamste uitrusting

Sportage Easy
[NAME]
Manuele airconditioning
Cruise control
Radio-cd-mp3 + AUX & USB met
audiobediening op het stuurwiel
Bluetooth
17’’ aluminium velgen
Mistlampen vooraan
Elektrisch regelbare en
verwarmbare buitenspiegels
Elektrisch bediende ruiten
voor- en achteraan
Centrale deurvergrendeling
met afstandsbediening
Dakrails
Met leder bekleed stuurwiel
en versnellingspook
Ruitenwissers vooraan met
regensensor
Sportage FIFA World CupTM Edition
Alle voornaamste uitrusting [NAME]
+
Automatische airconditioning
Geïntegreerd navigatiesysteem met achteruitrijcamera
Parkeersensoren voor- en achteraan
LED-achterlichten
Premium audiosysteem met radio-cd-mp3 + AUX
& USB met audiobediening op het stuurwiel
Flex steer
Privacy ruiten achteraan
Spreadsheet: b9fbeb14-d37b-4163-bdc0-38bbf5e13854
Sheet: Player Scoreboard

No | Sheet Name | Player Name | Total Point | Correct Prediction |  | Group Stages |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Quarter Final |  |  |  | Semifinal |  | FINAL
 |  |  |  |  |  | 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
 |  |  |  |  | [NAME] >>
 |  |  |  |  | Match >>
 |  |  |  |  | Result >>
 | Player
 | Player (2)
 | Player (3)
 | Player (4)
 | Player (5)
 | Player (6)
 | Player (7)
 | Player (8)
 | Player (9)
 | Player (10)
 | Player (11)
 | Player (12)
 | Player (13)
 | Player (14)
 | Player (15)
 | Player (16)
 | Player (17)
 | Player (18)
 | Player (19)
 | Player (20)
 | Player (21)
 | Player (22)
 | Player (23)
 | Player (24)
 | Player (25)
Spreadsheet: 780855d1652818513-xlookup-in-a-table-xlookup-in-a-table
Sheet: Sheet2

 |  |  | Name | Test | Test2 | Test3 | Test4
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | Debby
Spreadsheet: 771840d1646869825-using-of-formula-to-calculate-fruit-counter
Sheet: Sheet1

 | Apples | Pear | Oranges | Lemon | Bananas | Fruits
Box 1 | N | Y | Y | N | Y |  |  |  |  | Row Labels | Count of Fruits
[NAME] | Y | Y | N | Y | Y |  |  |  |  | 1 | 1
Box 3 | Y | Y | N | Y | Y |  |  |  |  | 2 | 3
[NAME] | Y | Y | Y | Y | Y |  |  |  |  | 3 | 1
Box 5 | Y | N | Y | Y | Y |  |  |  |  | 4 | 11
Box 6 | Y | Y | Y | Y | Y |  |  |  |  | 5 | 4
Box 7 | Y | N | N | Y | N |  |  |  |  | (blank)
Box 8 | Y | Y | N | Y | Y |  |  |  |  | Grand Total | 20
Box 9 | N | Y | N | Y | N
Box 10 | Y | N | N | N | N
Box 11 | Y | Y | N | Y | Y
Box 12 | Y | Y | Y | Y | Y
Box 13 | Y | Y | N | Y | Y
Box 14 | Y | Y | Y | N | Y
Box 15 | Y | Y | N | Y | Y
Box 16 | Y | Y | Y | Y | Y
Box 17 | Y | Y | N | Y | Y
Box 18 | Y | Y | N | Y | Y
Box 19 | Y | Y | N | Y | Y
Box 20 | Y | Y | N | N | N
Spreadsheet: 769240d1645431203-conditional-composition-of-cells-16
Sheet: Sheet1

Data |  |  |  | Expected result
Product | Color |  | Product | Color
Book | colror1 |  | Book
pen | colror2 |  | pen
Pencel | [NAME] |  | Pencel
Book | [NAME] |  | Erase
Erase | colror5
pen | colror6
Book | colror7
Pencel | colror8 |  |  | Please, without VBA & helper column
Erase | colror9 |  |  | please, with formoul
Pencel | colror10
Spreadsheet: 5626ea80-5f0b-4592-b52e-b88d9ee8aaca
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
NSE | Test | NSE | Neuron-Specific Enolase (NSE), Serum | Neuron Specific Enolase, S | Homogeneous Time-Resolved Fluorescence | Plain, Red-Top Tube: Red |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL | 0.3 mL | Hemolysis	Mild reject; Gross reject Thawing	NA Lipemia	Mild OK; [NAME] OK Icterus	Mild reject; Gross reject Other	NA | < or =15 ng/mL Serum markers are not specific for malignancy, and values may vary by method. | Monday through Saturday; 2:30 p.m. | 1 day | 4 days | 1 | 83520 |  |  |  |  | Rochester
NSE | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
NSE | Result | NSE | Neuron Specific Enolase, S | Neuron Specific Enolase, S | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 15060-7 | Enolase.neuron specific:MCnc:Pt:Ser/Plas:Qn:
Spreadsheet: 201705d1356084740-issues-with-a-weekly-clock-card-report-cranwick-help
Sheet: Weekly Timesheet

PRESTIGE: WEEKLY TIMESHEET
Cranswick Convenience Foods - Sutton Fields
 | Week Ending: | 8th Dec 2012
 | Week Number: | 36
 |  |  |  | Daily Totals |  |  |  |  |  |  | Weekly Totals
 |  |  |  | Sun | Mon | [NAME] | Wed | Thurs | Fri | Sat | Total Hours | Hours + 40
Employee ID | Surname | First Name | Payroll No.
8 | LEUTY | Loraine | PY/00003 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
9 | [NAME] | [NAME] | PY/00012 | 1900-01-01 00:00:00
10 | Boxall | [NAME] | PY/00016
13 | Watson | Christine | PY/00026
19 | Jones | Nathan | PY/00061
Here is the issue I am having. This is a weekly clock card report I am designing. It draws information directly out of my companies software and puts it into various sheets (In this case, t_Personnel_data and t_Attendance_data). The attendance sheet draws out all 7 days of the week, and then
displays the total (Daily and Period). My issue is getting the Daily totals (Which are in order, Sunday being the first Daily) to fill down, as if you fill down E10:K10 to the next row it will be using an incorrect fomula (Employee 9 if filled down from 8 will be displaying employee 8's monday times)
I am still a relative newcomer in terms of excel but I understand some sort of lookup could be used in this case, but I have really no clue where to start. Any help on this matter would be greatly appreciated!
Spreadsheet: 81351d1281557501-excel-2007-sum-replace-if-formula-trouble-online-post
Sheet: I

# | Last Name | First Name | Driver's License |  |  | Date of Birth |  |  | Address 1 | Address 2 | City | Prov. | P/C |  | Amount |  | PIF | EXT | LR
1 | Smith | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 153.75 |  | PIF
2 | Smith | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 131.75 |  |  |  | LR
3 | Smith | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 137.5 |  |  |  | LR
4 | Smith | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 208.75 |  | PIF
5 | Smith | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 128.75 |  |  | EXT
6 | Smith | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 66.25 |  |  | EXT
7 | Smith | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 88.75 |  |  |  | LR
8 | Smith | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 88.75 |  | PIF
9 | Smith | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 92.5 |  | PIF
10 | Smith | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 235 |  |  |  | LR
11 | Smith | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 92.5 |  |  |  | LR
12 | Smith | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 88.75 |  | PIF
13 | Smith | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 152.5 |  | PIF
14 | Smith | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 88.75 |  |  | EXT
15 | Smith | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 88.75 |  |  |  | LR
16 | Smith | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 88.75 |  |  |  | LR
17 | Smith | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 148.75 |  |  |  | LR
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2080.5 |  | 6 | 3 | 8
 |  |  |  |  |  |  |  |  |  |  |  | I want to total the amount of cash that came in via PIF
 |  |  |  |  |  |  |  |  |  |  |  | and also the number of money that wont come in due to LR (letter returned)
 |  |  |  |  |  |  |  |  |  |  |  | Hopefully this can all be done without adding another column
 |  |  |  |  |  |  |  |  |  |  |  | this is a severely pared down version of the actual one I am using
Spreadsheet: 176679d1346068574-how-to-calculate-sales-total-for-a-month-from-the-dates-more-than-5-years-data-example
Sheet: Sheet1

DATE | VALUE |  | 2008-10-01 00:00:00 | ? |  | 0
2008-11-10 00:00:00 | 90.27920821635098
2008-12-11 00:00:00 | 15.91497641499917
2008-07-12 00:00:00 | 43.86869294026974
2008-10-13 00:00:00 | 24.50560468913299
2008-10-14 00:00:00 | 47.19578434096026
2008-05-15 00:00:00 | 2.089713451692443
2008-10-16 00:00:00 | 5.001950605526595
2008-10-17 00:00:00 | 44.92976363639838
2008-03-18 00:00:00 | 76.08439360299334
IS THERE INY FORMULA TO CALCULATE SALES TOTAL FOR A MONTH FROM THE DATES
IF I PUT MONTH AND YEAR IN CELL D1 ( Ex-Oct-08) so in cell E1 total -122 should come
Spreadsheet: 014331b9-1bca-409e-af66-b7049712fa17
Sheet: Sheet1

Applicant/Provider: | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
RFP No.:
Contract No. (As Applicable):
B U D G E T |  | Budget
C A T E G O R I E S |  | Request
 |  | (a) | (b) | (c) | (d)
A. | PERSONNEL COST
 | 1.  Salaries
 | 2.  Payroll Taxes & Assessments
 | 3.  [NAME]
 | TOTAL PERSONNEL COST
B. | OTHER CURRENT EXPENSES
 | 1.  Airfare, Inter-Island
 | 2.  Airfare, Out-of-State
 | 3.  Audit Services
 | 4.  Contractual Services - Administrative
 | 5.  Contractual Services - Subcontracts
 | 6.  Insurance
 | 7.  Lease/Rental of Equipment
 | 8.  Lease/Rental of Motor Vehicle
 | 9.  Lease/Rental of Space
 | 10.  Mileage
 | 11.  Postage, Freight & Delivery
 | 12.  Publication & Printing
 | 13.  Repair & Maintenance
 | 14.  Staff Training
 | 15.  Substance/Per Diem
 | 16.  Supplies
 | 17.  Telecommunication
 | 18.  Transportation
 | 19.  Utilities
 | 20
 | 21.
 | 22.
 | 23.
 | TOTAL OTHER CURRENT EXPENSES
C. | EQUIPMENT PURCHASES
D. | MOTOR VEHICLE PURCHASES
TOTAL  (A+B+C+D)
 |  |  | Budget Prepared By:
SOURCES OF FUNDING
 | (a)  Budget Request |  | Name (Please type or print) |  | Phone
 | (b)
 | (c) |  | Signature of Authorized Official |  | Date
 | (d) |  | Name and Title (Please type or print)
 |  |  | For State Agency Use Only
TOTAL REVENUE
 |  |  | Signature of Reviewer |  | Date