tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 710194d1608761891-how-to-calculate-the-number-of-days-not-worked-exclusion-count-example
Sheet: Sheet1

Days Not Worked | 1 | 1 | 2 | 0 |  | Weekdays
 | [NAME] | [NAME] | Gertrude | Zach |  | Monday
Week 1 |  |  |  |  |  | Tuesday
2020-10-26 00:00:00 |  |  |  |  |  | Wednesday
Monday | 8 | 8 | 6 | 8 |  | Thursday
2020-10-27 00:00:00 |  |  |  |  |  | Friday
Tuesday | 8 |  | 6 | 8
2020-10-28 00:00:00
Wednesday | 8 | 8 |  | 8
2020-10-29 00:00:00
Thursday | 8 | 8 | 6 | 8
2020-10-30 00:00:00
Friday | 8 | 8 | 6 | 8
2020-10-31 00:00:00
Saturday |  | 8 |  | 8
Week 2
2020-11-02 00:00:00
Monday | 8 | 8 | 6 | 8
2020-11-03 00:00:00
Tuesday | 8 | 8 | 6 | 8
2020-11-04 00:00:00
Wednesday | 8 | 8 |  | 8
2020-11-05 00:00:00
Thursday |  | 8 | 6 | 8
2020-11-06 00:00:00
Friday | 8 | 8 | 6 | 8
Spreadsheet: 340ca52d-a472-4f8a-b80a-b00db1792c7a
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Atlantic-Elektra | 75596291828 | Blindside | About A Burning Fire | 2004-02-24 | Compact Disc | Rock | 11.99 | N | To Be Retired
Spreadsheet: 740319d1626277377-first-contact-resolution-calculation-fcr-calc-call-data-example-1
Sheet: Sheet1

 | Call Back Window: |  |  | 3 | Days
 | Call Date | Agent ID | Name | ANI | Resolved
 | 2021-07-01 00:00:00 | 123456 | Scott | fa | 0 |  |  |  |  |  |  |  |  |  |  | FCR Score By Agent
 | 2021-07-01 00:00:00 | 123456 | Scott | 2222 | 1 |  |  |  |  |  |  |  |  |  |  | Agent Name | Calls | Resolved Calls | % Repeat Call Rate
 | 2021-07-02 00:00:00 | 123457 | [NAME] | 3333 | 1 |  |  |  |  |  |  |  |  |  |  | Scott
 | 2021-07-02 00:00:00 | 123457 | [NAME] | 1111 | 1 |  |  |  |  |  |  |  |  |  |  | [NAME]
 | 2021-07-03 00:00:00 | 123458 | Jennie | 5555 | 0 |  |  |  |  |  |  |  |  |  |  | Jennie
 | 2021-07-03 00:00:00 | 123460 | [NAME] | 5555 | 1 |  |  |  |  |  |  |  |  |  |  | [NAME]
 | 2021-07-04 00:00:00 | 123456 | Scott | 6666 | 1 |  |  |  |  |  |  |  |  |  |  | [NAME]
 | 2021-07-04 00:00:00 | 123459 | [NAME] | 7777 | 0
 | 2021-07-05 00:00:00 | 123459 | [NAME] | 1111 | 1
 | 2021-07-06 00:00:00 | 123457 | [NAME] | 7777 | 1
 | 2021-07-07 00:00:00 | 123458 | Jennie | 8888 | 1
 | 2021-07-08 00:00:00 | 123459 | [NAME] | 2222 | 1
 | 2021-07-09 00:00:00 | 123458 | Jennie | 1111 | 1
Spreadsheet: 716845d1612378192-combining-columns-into-a-single-column-geomarketing-development-playground
Sheet: Backstage

Backstage
Welcome to the Backstage Page for the Geomarketing Campaign. This is the final sheet to this document.
This page contains all the behind-the-scenes wizardry that makes this spreasheet function, so be incredibly careful where you step! You may add, rename, or remove lines from the three tables below to expand out the options available in any given dropdown, but maybe save a backup before doing so -- the first version of this document was lost to some mistakes made in the tables below. Use caution. Any other lists on the page, especially those to the right, should be left unedited.
RegionTable |  | StoreTable |  | ContentTable
Northeast |  | [NAME] |  | Copy | Copy
Mid-Atlantic |  | Boutique |  | Media | Media
Southern Coast |  | [NAME] |  | [NAME] | [NAME]
Upper Midwest |  | [NAME] |  | Aesthetic Trend | Aesthetic Trend
Lower Midwest |  | Farm & Feed |  | Product of Interest | Product of Interest
Central South |  | [NAME] |  | Color or Style Note | Color or Style Note
Mountain |  | Online
Southwest |  | Pet Daycare
Pacific Northwest |  | Veterinarian
Pacific Coastal |  | Resort & Casino
National | National | Any Retail | Any Retail
For Region x  Store Copy
Region x Store | < K | National x Store | < L | Region x All Stores | < M | National x All Stores | < N
Spreadsheet: 50805d1250280142-formula-with-muliple-outputs-detention-tracking
Sheet: Sheet4

[NAME]
ID | Last Name | First Name | Grade | Team | Date | Code | Demerits
125486 | Egbert | G | 8 | R | 2009-09-07 00:00:00 | T
125486 | Egbert | G | 8 | R | 2009-09-08 00:00:00 | T
125478 | Flowers | C | 7 | L | 2009-09-08 00:00:00 | ST | 2
541236 | Hill | D | 8 | Q | 2009-09-07 00:00:00 | T
541236 | Hill | D | 8 | Q | 2009-09-08 00:00:00 | T | 2
123456 | [NAME] | A | 6 | G | 2009-09-08 00:00:00 | Ref | 2
456789 | [NAME] | S | 6 | K | 2009-09-07 00:00:00 | T
456789 | [NAME] | S | 6 | K | 2009-09-08 00:00:00 | T | 2
235689 | Truss | E | 7 | L | 2009-09-07 00:00:00 | T
235689 | Truss | E | 7 | L | 2009-09-08 00:00:00 | T | 2
Spreadsheet: 863909d1711304857-index-aggregate-vlookup-across-tables-issue-order-entry-issues
Sheet: Products

Product List
Item # | Description | UPC/GTIN | GCW | TiHi | CPFP | Class | Order List Lookup Values
123456 | Item 1 | 1234567891011 | 25.5 | 11x7 | 77 | Sauce | 01] 12-3456 | Item 1 | 01234567891011
123457 | Item 2 | 1234567891012 | 25.5 | 11x7 | 77 | Sauce | 02] 12-3457 | Item 2 | 01234567891012
123458 | Item 3 | 1234567891013 | 25.5 | 11x7 | 77 | Sauce | 03] 12-3458 | Item 3 | 01234567891013
123459 | Item 4 | 1234567891014 | 25.5 | 11x7 | 77 | Sauce | 04] 12-3459 | Item 4 | 01234567891014
123460 | Item 5 | 1234567891015 | 25.5 | 11x7 | 77 | Sauce | 05] 12-3460 | Item 4 | 01234567891015
123461 | Item 6 | 1234567891016 | 25.5 | 11x7 | 77 | Sauce | 06] 12-3461 | Item 5 | 01234567891016
123462 | Item 7 | 1234567891017 | 25.5 | 11x7 | 77 | Sauce | 07] 12-3462 | Item 6 | 01234567891017
123463 | Item 8 | 1234567891018 | 25.5 | 11x7 | 77 | Sauce | 08] 12-3463 | Item 7 | 01234567891018
123464 | Item 9 | 1234567891019 | 25.5 | 11x7 | 77 | Sauce | 09] 12-3464 | Item 8 | 01234567891019
123465 | Item 10 | 1234567891020 | 25.5 | 11x7 | 77 | Sauce | 10] 12-3465 | Item 9 | 01234567891020
The reason Column H has a preceding number followed by a bracket is because this is the only way I could get a "sort in place" to work.  More on that elsewhere.
Spreadsheet: 866499d1713432241-converting-a-time-extracted-from-data-as-hh-mm-problem-demo11
Sheet: Table 1

Entry Date |  |  | 29/02/24 12:27 |  | Required Completion Date | 11/03/24 00:00
Completion Date |  |  | 17/04/24 17:46
Site
Assignees
User |  |  |  | Job Start Time | Job Stop Time |  |  | Time
User1 |  |  |  | 11 Mar 2024 08:02 | 11 Mar 2024 18:45 |  |  | 10h 42m
 |  |  |  | 12 Mar 2024 07:42 | 12 Mar 2024 16:01 |  |  | 8h 18m
 |  |  |  | 13 Mar 2024 07:25 | 13 Mar 2024 16:01 |  |  | 8h 36m
 |  |  |  | 14 Mar 2024 07:29 | 14 Mar 2024 16:37 |  |  | 9h 8m
 |  |  |  | 15 Mar 2024 07:29 | 15 Mar 2024 16:08 |  |  | 8h 39m
Time on Job |  |  |  |  |  |  |  | 1d 21h 24m
User2 |  |  |  | 11 Mar 2024 08:02 | 11 Mar 2024 17:06 |  |  | 9h 3m
 |  |  |  | 12 Mar 2024 07:42 | 12 Mar 2024 16:01 |  |  | 8h 18m
 |  |  |  | 13 Mar 2024 07:25 | 13 Mar 2024 16:01 |  |  | 8h 36m
 |  |  |  | 14 Mar 2024 07:29 | 14 Mar 2024 16:13 |  |  | 8h 44m
 |  |  |  | 15 Mar 2024 07:29 | 15 Mar 2024 16:07 |  |  | 8h 38m
 |  |  |  | 15 Mar 2024 17:05 | 15 Mar 2024 18:14 |  |  | 1h 8m
 |  |  |  | 18 Mar 2024 07:32 | 18 Mar 2024 16:00 |  |  | 8h 27m
 |  |  |  | 19 Mar 2024 07:38 | 19 Mar 2024 16:01 |  |  | 8h 23m
 |  |  |  | 19 Mar 2024 17:02 | 19 Mar 2024 17:23 |  |  | 20m
 |  |  |  | 20 Mar 2024 07:29 | 20 Mar 2024 15:48 |  |  | 8h 19m
 |  |  |  | 20 Mar 2024 17:16 | 20 Mar 2024 17:26 |  |  | 9m
 |  |  |  | 21 Mar 2024 06:40 | 21 Mar 2024 14:47 |  |  | 8h 7m
 |  |  |  | 22 Mar 2024 07:28 | 22 Mar 2024 12:59 |  |  | 5h 30m
 |  |  |  | 22 Mar 2024 14:13 | 22 Mar 2024 16:15 |  |  | 2h 2m
 |  |  |  | 26 Mar 2024 07:04 | 26 Mar 2024 15:44 |  |  | 8h 39m
 |  |  |  | 26 Mar 2024 16:50 | 26 Mar 2024 17:04 |  |  | 13m
 |  |  |  | 27 Mar 2024 07:18 | 27 Mar 2024 13:06 |  |  | 5h 47m
 |  |  |  | 27 Mar 2024 14:28 | 27 Mar 2024 15:54 |  |  | 1h 26m
 |  |  |  | 28 Mar 2024 07:02 | 28 Mar 2024 15:38 |  |  | 8h 36m
 |  |  |  | 02 Apr 2024 07:40 | 02 Apr 2024 16:11 |  |  | 8h 31m
Time on Job |  |  |  |  |  |  |  | 4d 23h 6m
User3 |  |  |  | 18 Mar 2024 07:30 | 18 Mar 2024 16:01 |  |  | 8h 31m
 |  |  |  | 19 Mar 2024 07:43 | 19 Mar 2024 16:00 |  |  | 8h 16m
 |  |  |  | 20 Mar 2024 07:49 | 20 Mar 2024 16:00 |  |  | 8h 10m
 |  |  |  | 21 Mar 2024 06:57 | 21 Mar 2024 15:54 |  |  | 8h 56m
 |  |  |  | 22 Mar 2024 07:28 | 22 Mar 2024 16:00 |  |  | 8h 31m
 |  |  |  | 25 Mar 2024 08:20 | 25 Mar 2024 17:31 |  |  | 9h 11m
Time on Job |  |  |  |  |  |  |  | 2d 3h 37m
Total Job Time |  |  |  |  |  |  |  | 1w 2d 0h 8m
Spreadsheet: 857624d1706602598-find-alfanumeric-values-and-make-a-sum-sum-from-e-xxx
Sheet: Blad1

 | qty | value | value
349220243 | 4 | 10 | 1 |  |  |  |  | Sort out the values and net with items
981734143 | 5 | 20 | 2 |  |  |  |  | that start with an "E" to accumulated sum
473367462 | 6 | 30 | 3 |  |  |  |  | C-column | D-column | C-column | D-column
756295285 | 5 | 40 | 4 |  |  |  |  | EXXXX item | Exxxx item net | All other items with numbers
E1234567 | 9 | 1 | 2
E2345678 | 2 | 2 | 4
E3219876 | 2 | 3 | 5 |  |  |  |  |  | 17 | 100 | 10
E2187239 | 7 | 4 | 6
 |  | 1000 | 1000 |  |  |  |  | Values with no numbers or E-xxxx should not be calculated
Spreadsheet: db3d9e90-43dd-4e29-beef-80d5479de791
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
VMA | Test | VMA | Vanillylmandelic Acid (VMA), 24 Hour, [NAME] | Vanillylmandelic Acid, 24 Hr, U | Liquid Chromatography-Tandem Mass Spectrometry (LC-MS/MS) | [NAME], 24-hour graduated: 24Urine |  |  | 5 | mL | Container/Tube: Plastic, 10-mL urine tube (Supply T068) [NAME]: 5.2 mL Collection Instructions:  1. Collect a 24-hour urine specimen. 2. Add 25 mL of 50% acetic acid as preservative at the start of collection. If specimen is refrigerated during collection, preservative may be added up to 4 hours after collection. Use 15 mL of 50% acetic acid for children <5 years old. This preservative is intended to achieve a pH of between approximately 1 and 5. If necessary, adjust urine pH to 1 to 5 with 50% acetic or HCl acid. Additional Information:  1. Patient's age and 24-hour volume are required. 2. Administration of L-dopa may falsely increase vanillylmandelic acid results; it should be discontinued 24 hours prior to and during collection of specimen. 3. See [NAME] in Special Instructions for multiple collections.   Urine Preservative Collection Options Ambient	No Refrigerated	No Frozen	No 6N HCl	Yes 50% Acetic Acid	Preferred Na2CO3	No Toluene	No 6N HNO3	Yes Boric Acid	Yes* (pH must be <5) Thymol	No *If boric acid is used, note on specimen container. Also, verify that pH is in desired range (pH=1-5). If pH is outside of desired range, adjust pH with a stronger acid (acetic acid is preferred but other acids listed above could be used if available) in a dropwise fashion to bring pH into desired range. | 3.5 mL | Hemolysis	NA Thawing	Warm reject; Cold OK Lipemia	NA Icterus	NA Other	NA | <1 year: <27.0 mg/g creatinine 1 year: <18.0 mg/g creatinine 2-4 years: <13.0 mg/g creatinine 5-9 years: <8.5 mg/g creatinine 10-14 years: <7.0 mg/g creatinine > or =15 years (adults): <8.0 mg/24 hours | Monday through Saturday; 8 a.m. | 2 days (not reported on Sunday) | 4 days | 1 | 84585 |  |  |  |  | Rochester
VMA | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 7 days
VMA | Order Question | TM41 | Collection Duration |  | Plain Text
VMA | Order Question | VL39 | [NAME] |  | Plain Text
VMA | Result | 3580 | VMA, [NAME] | VMA, [NAME] | Numeric |  |  |  |  | mg/24 h |  |  |  |  |  |  |  |  |  | 3122-9
VMA | Result | 3581 | VMA, [NAME] (<15yr) | VMA, [NAME] (<15yr) | Numeric |  |  |  |  | mg/g Cr |  |  |  |  |  |  |  |  |  | 30571-4
VMA | Result | TM41 | Collection Duration | Collection Duration | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13362-9
VMA | Result | VL39 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3167-4
Spreadsheet: chris_germany__1884__tp2_ticketsJun2001
Sheet: Net 284

 |  | 1216 | 1200
 | 12181 | 1695 | 1673
 |  | 67 | 66
 |  | 507 | 500
 |  | 253 | 250
 |  | 28 | 28
 |  | 30 | 30
 | 20871 | 1896 | 1871
 |  | 478 | 472
 |  | 728 | 718
 |  | 590 | 582
 |  | 1308 | 1291
Spreadsheet: 802719d1666986105-can-some-one-help-with-a-multi-criteria-index-match-excel-simple-array-logic-please
Sheet: Calender

Calender Start Date | Timeline Dates | Year Day 1
2022-01-01 00:00:00
Spreadsheet: 789723d1659320936-excel-counting-and-removing-duplicates-count-daf-summary-data-aligw
Sheet: Sheet1

U | A |  | U | C
1-1 | X |  |  | 3 |  | Count
1-1 | X |  | 1-2 | 2
1-1 | X |  | 1-3 | 1
1-2 | X |  | 2-1 | 1
1-2 | X |  | 2-2 | 0
1-3 | X |  | 2-3 | 0
2-1 | X
2-2
2-3
Spreadsheet: 49629d1248978857-attendance-tracking-with-thresholds-attendance-tracking
Sheet: Sheet1

ID | DATE | SICK | CODE | MONTH
1000 | 2009-08-03 00:00:00 | 1 | X | 2009-08-01 00:00:00
1000 | 2009-08-04 00:00:00 | 1 | X | 2009-08-01 00:00:00
1000 | 2009-08-05 00:00:00 | 1 | X | 2009-08-01 00:00:00
1000 | 2009-08-07 00:00:00 | 1 | X | 2009-08-01 00:00:00
1000 | 2009-08-08 00:00:00 | 1 | X | 2009-08-01 00:00:00
1000 | 2009-08-09 00:00:00 | 1 | X | 2009-08-01 00:00:00
1000 | 2009-08-14 00:00:00 | 1 | X | 2009-08-01 00:00:00
1000 | 2009-08-15 00:00:00 | 1 | X | 2009-08-01 00:00:00
1000 | 2009-08-20 00:00:00 | 1 | C | 2009-08-01 00:00:00
1000 | 2009-08-23 00:00:00 | 1 | C | 2009-08-01 00:00:00
1001 | 2009-08-01 00:00:00 | 1 | X | 2009-08-01 00:00:00
1001 | 2009-08-02 00:00:00 | 0.3333333333333333 | X | 2009-08-01 00:00:00
1001 | 2009-08-05 00:00:00 | 1 | X | 2009-08-01 00:00:00
1001 | 2009-08-09 00:00:00 | 1 | X | 2009-08-01 00:00:00
1001 | 2009-08-11 00:00:00 | 1 | X | 2009-08-01 00:00:00
1001 | 2009-08-13 00:00:00 | 1 | X | 2009-08-01 00:00:00
1001 | 2009-08-18 00:00:00 | 1 | C | 2009-08-01 00:00:00
1001 | 2009-08-19 00:00:00 | 1 | C | 2009-08-01 00:00:00
1002 | 2009-08-01 00:00:00 | 1 | C | 2009-08-01 00:00:00
1002 | 2009-08-06 00:00:00 | 1 | X | 2009-08-01 00:00:00
1002 | 2009-08-11 00:00:00 | 1 | X | 2009-08-01 00:00:00
1002 | 2009-08-15 00:00:00 | 0.5 | X | 2009-08-01 00:00:00
1002 | 2009-08-20 00:00:00 | 0.5 | X | 2009-08-01 00:00:00
1002 | 2009-08-25 00:00:00 | 1 | X | 2009-08-01 00:00:00
1000 | 2009-09-01 00:00:00 | 1 | X | 2009-09-01 00:00:00
1000 | 2009-09-04 00:00:00 | 1 | X | 2009-09-01 00:00:00
1004 | 2009-09-01 00:00:00 | 1 | X | 2009-09-01 00:00:00
1004 | 2009-09-14 00:00:00 | 1 | X | 2009-09-01 00:00:00
1006 | 2009-09-02 00:00:00 | 1 | X | 2009-09-01 00:00:00
1006 | 2009-09-06 00:00:00 | 1 | X | 2009-09-01 00:00:00
1006 | 2009-09-09 00:00:00 | 1 | C | 2009-09-01 00:00:00
1006 | 2009-09-21 00:00:00 | 1 | X | 2009-09-01 00:00:00
1006 | 2009-09-26 00:00:00 | 1 | X | 2009-09-01 00:00:00
1006 | 2009-09-28 00:00:00 | 1 | X | 2009-09-01 00:00:00
1007 | 2009-10-01 00:00:00 | 1 | X | 2009-10-01 00:00:00
1007 | 2009-10-08 00:00:00 | 1 | X | 2009-10-01 00:00:00
1007 | 2009-10-18 00:00:00 | 1 | X | 2009-10-01 00:00:00
1007 | 2009-10-26 00:00:00 | 1 | X | 2009-10-01 00:00:00
1001 | 2009-10-02 00:00:00 | 1 | X | 2009-10-01 00:00:00
1001 | 2009-10-06 00:00:00 | 1 | X | 2009-10-01 00:00:00
1001 | 2009-10-14 00:00:00 | 1 | X | 2009-10-01 00:00:00
1001 | 2009-10-21 00:00:00 | 1 | X | 2009-10-01 00:00:00
1003 | 2009-10-01 00:00:00 | 1 | X | 2009-10-01 00:00:00
1003 | 2009-10-10 00:00:00 | 1 | X | 2009-10-01 00:00:00
1003 | 2009-10-18 00:00:00 | 1 | X | 2009-10-01 00:00:00
1003 | 2009-10-30 00:00:00 | 1 | X | 2009-10-01 00:00:00
Spreadsheet: 525245d1498636513-formula-to-transfer-data-from-one-range-of-cells-to-another-based-on-conditions-working-2
Sheet: Summary

SUMMARY
TOTAL UPSETS BY YR. |  | TOTAL UPSETS BY SEED RANKING PER YR. |  |  |  |  |  |  |  | TOTAL SEED RANKING UPSET % PER YR. |  |  |  |  |  |  |  |  |  | TOTAL PROBABILITY COMPARISON
Year | Upsets | Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10 | Column11 | Column12 | Column13 | Column14 | Column15 | Column16 | Column17 |  | [NAME] | Mean | Stdev. | Upset Prob. | Upset Prob. % | Projected Upsets | Actual Upsets | Difference | Avg. [NAME]. Upset
1985
1986
1987
1988
1989
1990
1991
1992
1993
1994 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BASIC |  |  | QUICK DROP DOWN SUMMARY
1995 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Tourneys |  |  | DROP DOWN LIST 1
1996 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Games/Yr |  |  | Team Name | General [NAME] | Answer
1997
1998
1999
2000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DROP DOWN LIST 2
2001 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Team Name | Seed Stats | Category | Answer
2002
2003
2004
2005 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DROP DOWN LIST 3
2006 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Team Name | Conference Stats | Category | Answer
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
Spreadsheet: 81556d1281696535-building-a-stock-system-formsheetedit
Sheet: LookupLists

PartDesc | Price |  | Location
Door | 75 |  | Warehouse
Spring | 1 |  | Shop
Lens | 15 |  | Store1
Blank cap | 5 |  | [NAME]
Eject knob | 7
Lock lever | 12
Insulator | 4
Screw caps | 3
This is the data I need to use
Item | Item Code | Stock in hand as @ 13.08.2010 | Current Balance
Ammonium Nitrate | LCH-001 | 1256 | 1630 |  | I need the current balance to automatically come when an entry is made in the partsdata sheet
Potassium Nitrate | [NAME] | Stock in hand will be enterd manually
Magnesium Sulphate | LCH-003
 | LCH-004
 | LCH-005
 | LCH-006
 | LCH-007
 | LCH-008
 | LCH-009
 | LCH-010
 | LCH-011
 | LCH-012
 | LCH-013
 | [NAME]
 | LCH-015
 | LCH-016
 | LCH-017
 | LCH-018
 | LCH-019
 | LCH-020
 | LCH-021
 | LCH-022
 | LCH-023
 | LCH-024
 | LCH-025
 | LCH-026
 | LCH-027
 | LCH-028
 | LCH-029
 | LCH-030
 | LCH-031
 | LCH-032
 | LCH-033
 | LCH-034
 | LCH-035
 | LCH-036
 | LCH-037
 | LCH-038
 | LCH-039
 | LCH-040
 | LCH-041
 | LCH-042
 | LCH-043
 | LCH-044
 | LCH-045
 | LCH-046
 | LCH-047
 | LCH-048
 | LCH-049
 | LCH-050
 | LCH-051
 | [NAME]
 | LCH-053
 | LCH-054
 | LCH-055
 | [NAME]
 | LCH-057
 | LCH-058
 | LCH-059
 | LCH-060
 | LCH-061
 | LCH-062
 | LCH-063
 | LCH-064
 | [NAME]
 | LCH-066
 | LCH-067
 | LCH-068
 | LCH-069
 | LCH-070
 | [NAME]
 | LCH-072
 | LCH-073
 | LCH-074
 | LCH-075
 | LCH-076
 | [NAME]
 | LCH-078
 | [NAME]
 | [NAME]
 | LCH-081
 | LCH-082
 | LCH-083
 | LCH-084
 | LCH-085
 | LCH-086
 | LCH-087
 | LCH-088
 | LCH-089
 | LCH-090
 | LCH-091
 | LCH-092
 | LCH-093
 | LCH-094
 | LCH-095
 | LCH-096
 | [NAME]
 | LCH-098
 | LCH-099
 | LCH-100
 | LCH-101
 | LCH-102
 | LCH-103
 | LCH-104
 | [NAME]
 | LCH-106
 | [NAME]
 | [NAME]
 | LCH-109
 | LCH-110
 | LCH-111
 | LCH-112
 | LCH-113
 | LCH-114
 | LCH-115
 | LCH-116
 | LCH-117
 | LCH-118
 | LCH-119
 | LCH-120
 | LCH-121
 | LCH-122
 | LCH-123
 | [NAME]
 | LCH-125
 | LCH-126
 | [NAME]
 | LCH-128
 | LCH-129
 | LCH-130
 | [NAME]
 | LCH-132
 | LCH-133
 | LCH-134
 | LCH-135
 | LCH-136
 | LCH-137
 | [NAME]
 | LCH-139
 | LCH-140
 | LCH-141
 | LCH-142
 | LCH-143
 | LCH-144
 | LCH-145
 | LCH-146
 | [NAME]
 | LCH-148
 | LCH-149
 | LCH-150
Spreadsheet: 205802d1357907649-date-calculation-challenge-date-calc-problem
Sheet: Sheet3

 |  |  | 2013-01-01 00:00:00 |  |  | 2013-02-01 00:00:00 |  |  | 2013-03-01 00:00:00
Date | Payment | Out | Balance |  | Out | Balance |  | Out | Balance
2 | Loans | 708 | -508 |  | 708 | -508 |  | 708 | -508
2 | Rent | 0 | -508 |  | 0 | -508 |  | 0 | -508
3 | Car Insurance | 76.84 | -584.84 |  | 76.84 | -584.84 |  | 76.84 | -584.84
3 | Food Shopping | 100 | -684.84 |  | 100 | -684.84 |  | 100 | -684.84
10 | Lease Car Repayment | 100 | -784.84 |  | 100 | -784.84 |  | 100 | -784.84
15 | Gym | 35 | -819.84 |  | 35 | -819.84 |  | 35 | -819.84
17 | Bowling Club | 100 | -919.84 |  | 100 | -919.84 |  | 100 | -919.84
22 | [NAME] | 50 | -969.84 |  | 50 | -969.84 |  | 50 | -969.84
24 | Charity Contribution | 140 | -1109.84 |  | 140 | -1109.84 |  | 140 | -1109.84
24 | To Another Account | 100 | -1209.84 |  | 100 | -1209.84 |  | 100 | -1209.84
27 | Wine Club Membership | 14.99 | -1224.83 |  | 14.99 | -1224.83 |  | 14.99 | -1224.83
28 | From Another Account | 1900 | 675.1699999999998 |  | 1900 | 675.1699999999998 |  | 1900 | 675.1699999999998
N/A | Other In | 5 | 680.1699999999998 |  | 5 | 680.1699999999998 |  | 5 | 680.1699999999998
N/A | Other Out | 64 | 616.1699999999998 |  | 64 | 616.1699999999998 |  | 64 | 616.1699999999998
 | Today | 2013-03-15 00:00:00
 | What is my balance today? |  |  |  | It's the 11th of Jan so that answer should be -784.84
Spreadsheet: 80073d1280303563-excel-2007-sort-error-excel-07-pivot-tables-help-needed-new-pivot-table-issue
Sheet: Data

Year | Customer | Sales
2009 | Customer A | 100000
2009 | Customer B | 40000
2009 | Customer C | 25000
2010 | Customer A | 95000
2010 | Customer B | 60000
2010 | Customer C | 40000
Spreadsheet: 288100d1389096951-need-help-cross-matching-data-kdee69
Sheet: Sheet1

 |  |  |  | one way | another
_pc_bi_ctbi001 | Business | _pc_bi_ctbi003 |  |  |  | business
_pc_bi_ctbi001 | Business | _pc_bi_fabi003 |  |  |  | desktop
_pc_bi_ctbi002 | Business | _pc_bi_fabi004 |  |  |  | IT course
_pc_bi_ctbi003 | Business | _pc_bi_hrbi001
_pc_bi_ctbi004 | Business | _pc_bi_hrbi006
_pc_bi_ctbi001 | desktop | _pc_bi_ctbi003
_pc_bi_ctbi001 | desktop | _pc_bi_fabi003
_pc_bi_ctbi002 | desktop | _pc_bi_fabi004
_pc_bi_ctbi003 | desktop | _pc_bi_hrbi001
_pc_bi_ctbi004 | desktop | _pc_bi_hrbi006
_pc_bi_ctbi001 | IT course | _pc_bi_ctbi003
_pc_bi_ctbi001 | IT course | _pc_bi_fabi003
_pc_bi_ctbi002 | IT course | _pc_bi_fabi004
_pc_bi_ctbi003 | IT course | _pc_bi_hrbi001
_pc_bi_ctbi004 | IT course | _pc_bi_hrbi006
Spreadsheet: 728698d1618581534-i-need-help-to-generate-attendance-sheet-by-using-excel-19-excel-help
Sheet: ATT_SHEET

[NAME]
Employee Name & ID: | 2021-04-15 00:00:00 |  |  | 2021-04-16 00:00:00
 | Time In | Time Out | Total Hour | Time In | Time Out | Total Hour |  | Dear, This formula is works fine in computer, But In Google Sheet, it is not working. If you again help me to fix this problem then it will be great help for me and also it will save my time.  Thanks in Advance.  Link: https://drive.google.com/file/d/1ymu0-BQaQmblihKrUSyal_L9yC113ZOy/view?usp=sharing
[NAME] (3450)
[NAME] (9202)
Md. Rashadul Hoque (8967)
[NAME] (9617)
Md. [NAME] (7793)
Md. Johir Uddin (5044)
[NAME] (5099)
Md. [NAME] (5100)
[NAME] (5162)
Md. Mozammel Hoque (4642)
[NAME] (9636)
Kamal Uddin Chowdhary (7814)
[NAME] (5220)
Md Tafsirul Hoque (3735)
[NAME] (8043)
[NAME] (5384)
Shamal Rudra (5136)
Mr. [NAME] (8975)
Omme Hafsa [NAME] (5414)
[NAME] (0000)
[NAME] (8968)
Md. Tarek Aziz Tipu (8971)
[NAME] (7818)
[NAME] (5137)
Khurshida Akter (5145)
[NAME] (9640)
[NAME] (5367)
Farjana Akter (5366)
[NAME] (5132)
Md. [NAME] (7819)
[NAME] (7820)
Md. [NAME] (5138)
[NAME] (5203)
Popy Das (9639)
[NAME] (5231)
[NAME] (8037)
[NAME] Das (5200)
Parvin Akter Bina (5105)
[NAME] (7812)
[NAME] (4698)
Raziya Akther (5233)
[NAME] (8976)
Md. [NAME] (8969)
Raja Mea (5104)
Md. [NAME] (0001)
Md. Shahidul [NAME] (0002)
Alauddin (0003)