tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 805353d1668632664-index-and-match-help-test
Sheet: Sheet3

Type 4 | Name | Weight |  | Type | Meat 1 | Meat 2 | Meat 3 | Meat 4 | Meat 5 | Cheese 1 | Cheese 2 |  | Sub | Meat | Weight - OZ | Cheese
Meat 1 |  | 2.4 |  | Type 1 | Bacon |  |  |  |  |  |  |  | Type 1 | Bacon |  | Yes
Meat 2 |  | 0.75 |  | Type 2 | Ham |  |  |  |  |  |  |  | Type 2 | Ham | 2.95 | Yes
Meat 3 |  |  |  | Type 3 |  |  |  |  |  |  |  |  | Type 2 | Cappacuolo | 0.75 | Yes
Meat 4 |  |  |  | Type 4 | Prosciuttini | Cappacuolo |  |  |  | Provolone |  |  | Type 3 | Ham | 3.55 | Yes
Meat 5 |  |  |  | Type 5 |  |  |  |  |  |  |  |  | Type 4 | Prosciuttini | 2.4 | Yes
Cheese 1 |  |  |  | Type 6 |  |  |  |  |  |  |  |  | Type 4 | Cappacuolo | 0.75 | Yes
Cheese 2 |  |  |  | Type 7 | Turkey |  |  |  |  | Provolone |  |  | Type 5 | Ham | 1.8 | Yes
 |  |  |  | Type 8 |  |  |  |  |  |  |  |  | Type 5 | Prosciuttini | 1.6 | Yes
 |  |  |  | Type 9 |  |  |  |  |  |  |  |  | Type 5 | Cappacuolo | 0.75 | Yes
 |  |  |  | Type 10 |  |  |  |  |  |  |  |  | Type 6 | Roast Beef | 4.1 | Yes
 |  |  |  | Type 11 |  |  |  |  |  |  |  |  | Type 7 | Turkey | 4.3 | Yes
 |  |  |  | Type 12
 |  |  |  | Type 13
 |  |  |  | Type 14
 |  |  |  | Type 15
 |  |  |  | Type 16
 |  |  |  | Type 17
 |  |  |  | Type 18
 |  |  |  | Type 19
 |  |  |  | Type 20
 |  |  |  | Type 21
 |  |  |  | Type 22
 |  |  |  | Type 23
Spreadsheet: 826978d1682417738-compliance-check-using-two-columns-test-data
Sheet: Sheet1

[NAME] | Call Number | User Status | Compliant
2 | 1 | FNSH | Compliant
2 | 2 | FNSH | Compliant
2 | 3 | CANC | Non-Compliant
2 | 4 | FNSH | Compliant
3 | 1 | FNSH | Non-Compliant
3 | 2 | FNSH | Compliant
3 | 3 | FNSH | Compliant
3 | 4 | FNSH | Non-Compliant
5 | 1 | CANC | Non-Compliant
5 | 2 | CANC | Non-Compliant
5 | 3 | FNSH | Compliant
6 | 1 | CANC | Non-Compliant
6 | 2 | CANC | Non-Compliant
6 | 3 | FNSH | Non-Compliant
9 | 1 | FNSH | Non-Compliant
9 | 2 | FNSH | Non-Compliant
9 | 3 | FNSH | Compliant
10 | 1 | FNSH | Non-Compliant
10 | 2 | CANC | Non-Compliant
10 | 3 | CANC | Non-Compliant
10 | 4 | FNSH | Compliant
11 | 1 | FNSH | Non-Compliant
11 | 2 | FNSH | Compliant
11 | 3 | FNSH | Compliant
11 | 4 | FNSH | Non-Compliant
12 | 1 | FNSH | Non-Compliant
12 | 2 | FNSH | Compliant
12 | 3 | CANC | Non-Compliant
12 | 4 | FNSH | Compliant
Spreadsheet: 5f0c6689-f8a3-4e33-a213-c77fc5567dfc
Sheet: Page 1

Permit No.: |  | WQ0034367 |  | Facility Name: |  | NW Regional Water Reclamation Facility |  |  |  |  | County: | Onslow |  | Month: |  |  | Year:
PPI: |  | 001 | Flow Measuring Point: |  |  |  |  |  |  | Parameter Monitoring Point:
Parameter Code |  |  | 50050 | 00310 | 00940 | 31616 | 00610 | 00620 | 00600 | 00400 | 00665 | 70300 | 00530 | 00076
Day | ORC Arrival Time | ORC Time On Site | Flow
 | 24-hr | hrs | GPD
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
Average:
Daily Maximum:
Daily Minimum:
Sampling Type: |  |  | Recorder | Composite | Composite | Grab | Composite | Composite | Composite | Grab | Composite | Composite | Composite | Recorder
Monthly Limit: |  |  | 1000000 | 10 |  | 14 | 4 | 10 | 4 |  | 2 |  | 5
Daily Limit: |  |  |  | 15 |  | 25 | 6 |  |  | 6-9 |  |  | 10 | 10
Sample Frequency: |  |  | [NAME] | 3 x Week | 3 x Year | 3 x Week | 3 x Week | 3 x Week | 3 x Week | 5 x Week | 3 x Week | 3 x Year | 3 x Week | [NAME]
Spreadsheet: 886894d1736997500-compare-and-highlight-data-from-two-reports-test1
Sheet: Sheet1

Employee Identifier | First Name | Last Name | Position | Location | Job | Manager | Legal Entity
200 | Test1 | Test | Project Delivery - Project Manager | Remote - Project Delivery | Project Manager | Test 20 | Test Co
201 | Test2 | Test | Project Delivery - Senior Platform Engineer | Remote - Project Delivery | Senior Platform Engineer | Test 21 | Test Co
203 | Test3 | Test | Facility Operations - Director, Operations North America | Remote - Facility Operations | Director, Operations North America | Test 22 | Test Co
204 | Test4 | Test | Facility Operations - Physical Security Program Manager | Remote - Facility Operations | Physical Security Program Manager | Test 23 | Test Co
205 | Test5 | Test | Project Delivery - Project Manager | Remote - Project Delivery | Project Manager | Test 24 | Test Co
207 | Test6 | Test | Investment and Capital Mkts - Director of Investments | Remote - Investment and Capital Mkts | Director of Investments | Test 25 | Test Co
208 | [NAME] | Test | Executive - Chief Investment Officer | Remote - Executive | Chief Investment Officer | Test 26 | Test Co
210 | Test8 | Test | Project Delivery - Regional Project Manager (West) | Remote - Project Delivery | Regional Project Manager (West) | Test 27 | Test Co
211 | Test9 | Test | Investment and Capital Mkts - Associate of Investments | Remote - Investment and Capital Mkts | Associate of Investments | Test 28 | Test Co
Spreadsheet: fee0c670-fc47-459e-998b-415d0ab42d26
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Big Idea | 820413120399 | Veggietales | Little [NAME], The | 2011-10-01 | DVD | Children | 14.99 | Y | Available
Warner Home Video | 883929355716 | Various | Snoopy'S Holiday Collection | 2013-11-08 | DVD | Children | 19.98 | Y | Available
Big Idea | 820413114596 | Veggietales | [NAME]: A Story Of Joyful Giving | 2009-10-03 | DVD | Children | 14.99 | Y | Available
Warner Home Video | 883929006472 | Peanuts | [NAME] Christmas, A | 2009-10-06 | DVD | Children | 19.98 | Y | Available
Big Idea | 820413117597 | Veggietales | It'S A Meaningful Life | 2010-10-02 | DVD | Children | 14.99 | Y | Available
Big Idea | 80689519796 | Veggietales | Toy That Saved Christmas, The | 2002-10-12 | DVD | Children | 9.99 | Y | Available
House Lights Media | 855332003119 | Various | Little Baby Disciples: Vol 3: The Lord Is My Savior | 2013-11-12 | DVD | Children | 12.99 | Y | Available
Warner Home Video | 883929084579 | Peanuts | [NAME] Christmas Tales | 2010-10-05 | DVD | Children | 14.97 | Y | Available
Warner Home Video | 883929006489 | Peanuts | [NAME] Thanksgiving, A | 2010-10-05 | DVD | Children | 19.97 | Y | Available
Warner Home Video | 883929081974 | Peanuts | I Want A Dog For Christmas [NAME] | 2010-10-05 | DVD | Children | 19.97 | Y | Available
Big Idea | 820413100094 | Veggietales | Star Of Christmas, The | 2002-10-12 | DVD | Children | 9.99 | Y | Available
Big Idea | 820413140892 | Veggietales | Christmas Df It'S A Meaningful Life + Christmas Sing A Long Song | 2014-10-11 | DVD | Children | 9.99 | Y | Available
Big Idea | 820413140793 | Veggietales | Christmas Df Little [NAME] Of Christmas | 2014-10-11 | DVD | Children | 9.99 | Y | Available
Big Idea | 820413140694 | Veggietales | Christmas Df St. Nick + Toy That Saved Christmas | 2014-10-11 | DVD | Children | 9.99 | Y | Available
Image Entertainment | 14381610628 | Various | Magical Christmas Collection | 2010-10-05 | DVD | Children | 14.98 | Y | Available
Spreadsheet: 90405d1290120885-excel-2007-vlookup-in-multiple-sheets-vlookupproblem-1
Sheet: B

PRODUCTS | QTY | PIECES | PRICE | SELECTED QTY | FINAL PIECES
B1 | 2 | 30.25
B2 | 3 | 26.25
B3 | 4 | 17
B4 | 5 | 11
B5 | 6 | 1
B6 | 7 | 7
B7 | 8 | 10
B8 | 9 | 12
B9 | 10 | 35.25
B10 | 11 | 16
Spreadsheet: 58469d1258708045-vlookup-copy-of-grade
Sheet: Test

NAME | S1 | S2 | S3 | [NAME] | S5 | Avg. Marks | Grade |  | Marks | Grade
[NAME] | 75 | 85 | 45 | 55 | 260 | 65 | D |  | 50-55 | G |  | 50 | G
[NAME] | 44 | 91 | 83 | 59 | 277 | 69.25 | D |  | 55-60 | F |  | 55 | F
[NAME] | 99 | 89 | 79 | 77 | 344 | 86 | AA |  | 60-65 | E |  | 60 | E
[NAME] | 98 | 97 | 91 | 96 | 382 | 95.5 | AAAA |  | 65-70 | D |  | 65 | D
Moe | 73 | 40 | 40 | 79 | 232 | 58 | F |  | 70-75 | C |  | 70 | C
[NAME] | 99 | 99 | 75 | 75 | 348 | 87 | AA |  | 75-80 | B |  | 75 | B
Bret | 51 | 59 | 53 | 60 | 223 | 55.75 | F |  | 80-85 | A |  | 80 | A
 |  |  |  |  |  |  |  |  | 85-90 | AA |  | 85 | AA
Note: | All marks are out of 100. |  |  |  |  |  |  |  | 90-95 | AAA |  | 90 | AAA
Question: | Using VLOOKUP function please find the grade in which the avg. marks of each student fall. |  |  |  |  |  |  |  | 95-100 | AAAA |  | 95 | AAAA
Spreadsheet: 705099d1605878414-list-of-items-from-table-excluding-hidden-rows-sampledata
Sheet: Sheet1

Name | Ref | Form | Year | Gender | Filter1 | Filter2 | Filter3 | Filter4 | Metric1 | Metric2
[NAME] | H123456789012 | MA | 7 | M | Y | N | Y | Y | 0.348297684581409 | 7.830918643847764
[NAME] | G234567890123 | MA | 7 | F | N | N | Y | Y | 4.812623662305705 | 8.020903454848607
[NAME] | T547896321504 | KA | 9 | M | Y | Y | N | Y | 4.648544472264806 | 5.676814724284537
[NAME] | Y854631805973 | KA | 9 | F | N | Y | Y | Y | 6.51683521664178 | 2.130896853695559
[NAME] | W244285739501 | JA | 10 | M | Y | N | N | Y | 3.256771646008456 | 0.4119553388014452
[NAME] | A458901358037 | JA | 10 | F | N | N | N | N | 1.436412726113624 | 6.872435515996878
[NAME] | Q475201020365 | LE | 8 | M | Y | Y | N | N | 0.0931838421725617 | 2.280419117933787
[NAME] | V102498760215 | LE | 8 | F | N | Y | Y | N | 2.203014525441755 | 6.189095435806497
[NAME] | E478914010258 | MT | 7 | M | Y | N | Y | N | 8.532815887453335 | 8.432962460516864
[NAME] | P390545486595 | MT | 7 | F | Y | N | N | N | 1.964116013963961 | 5.123062287228355
Spreadsheet: 829800d1684448823-matching-info-from-tab-2-to-tab-1-with-one-common-cell-identifier-s666-pq-matching-info-from-tab-2-to-tab-1-with-one-common-cell-identifier
Sheet: DepInfo

Certificate # | Dependent First name | Dependent Last Name | DOB | Gender | Dependent Status
1000000 | [NAME] | Smith | 1969-04-09 00:00:00 | Female | Spouse
1000000 | [NAME] | Smith | 2000-02-23 00:00:00 | Female | Child
1000001 | [NAME] | Jones | 1976-06-10 00:00:00 | Female | Spouse
1000001 | April | Doe | 2001-07-13 00:00:00 | Female | Child
1000001 | [NAME] | Doe | 2005-03-23 00:00:00 | Female | Child
1000001 | [NAME] | [NAME] | 2008-07-03 00:00:00 | Male | Child
1000001 | Peach | Jones | 2006-03-11 00:00:00 | Male | Child
1000001 | [NAME] | Doe | 2013-04-08 00:00:00 | Male | Child
Spreadsheet: 8c69b6a5-a781-4098-b18e-4519dfed1e19
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | SKI | POSITION | TOTAL TIME
7555 | 11086 | Marko | Törmänen | FIN | 122 | 00:16:25 | 00:00:41 | 00:18:31 | 00:01:04 | 00:16:07 | 1 | 00:52:52
7555 | 25301 | [NAME] | [NAME] | RUS | 123 | 00:15:35 | 00:00:36 | 00:18:27 | 00:00:49 | [NAME] | 2 | 00:53:08
7555 | 47067 | Marko | Myllymaki | FIN | 119 | [NAME] | [NAME] | 00:22:40 | 00:01:16 | 00:17:50 | 3 | 00:59:45
7555 | 13266 | [NAME] | Savolainen | FIN | 121 | 00:16:43 | 00:00:36 | 00:23:04 | 00:01:25 | [NAME] | 4 | 01:00:27
7555 | 56047 | Toni | Niiranen | FIN | 120 | 00:17:22 | 00:01:31 | 00:25:11 | 00:02:20 | [NAME] | 5 | 01:06:21
Spreadsheet: 114621d1310386508-find-number-in-a-range-example
Sheet: Sheet1

﻿ | ﻿ | ﻿ | ﻿ | ﻿ | ﻿
My task (technical description) I need a function that would look at a number and point out a corresponding range of numbers to which this number belongs. For example: look up (453) in a table with intervals broken down by 100 (1-100, 101-200, 201-300, 301-400, 401-500), and point at the interval 401-500. The intervals are defined as two columns (min) and ([NAME]). | ﻿ | ﻿ | ﻿ | ﻿ | ﻿ | ﻿
﻿ | ﻿ | ﻿ | ﻿ | ﻿ | ﻿ | ﻿
My task (from the practical view) | ﻿ | ﻿ | I need to make up a table that will assign a product category to the specific customer based on the order number that comes with the person's name | ﻿ | ﻿ | ﻿
I know that [NAME] has the order number 456, I can look at the second table and find that her order number belongs between 300 and 500, thus the product category for this order was ([NAME]) - ID4 | ﻿ | ﻿ | ﻿ | ﻿ | ﻿ | ﻿
Technically. I do not need to point out the range, I can just point out the MAXimun of the range, and then utilize HLOOKUP for finding the category, once I know the range, but how do I find the range? | ﻿ | ﻿ | ﻿ | ﻿ | ﻿ | ﻿
﻿ | ﻿ | ﻿ | ﻿ | ﻿ | ﻿ | ﻿
TABLE 1 | Customer name/personal ID (from 1 to 100) | order number | Need alternative for this!! -->> | Find corresponding MAX from TABLE 2 - Nested (IF) functions - Very UGLY | Corresponding category (V LOOKUP in TABLE 2) | ﻿
﻿ | [NAME] (ID 1) | 453 | ﻿ | 500 | (Clothes) ID 4 | ﻿
﻿ | ﻿ | ﻿ | ﻿ | 301-500 | ﻿ | ﻿
TABLE 2 | Product category ID (from 1 to 10) | Range of order numbers | ﻿ | ﻿ | ﻿ | ﻿
﻿ | ﻿ | Min | [NAME] | ﻿ | ﻿ | ﻿
﻿ | (Household equipment) ID 1 | 0 | 100 | ﻿ | ﻿ | ﻿
﻿ | (books) ID 2 | 101 | 200 | ﻿ | ﻿ | ﻿
﻿ | (Food) ID 3 | 200 | 300 | ﻿ | ﻿ | ﻿
﻿ | (Clothes) ID 4 | 301 | 500 | ﻿ | ﻿ | ﻿
﻿ | ﻿ | ﻿ | ﻿ | ﻿ | ﻿ | ﻿
﻿ | ﻿ | ﻿ | ﻿ | ﻿ | ﻿ | ﻿
﻿ | ﻿ | ﻿ | ﻿ | ﻿ | ﻿ | ﻿
﻿ | ﻿ | ﻿ | ﻿ | ﻿ | ﻿ | ﻿
﻿ | ﻿ | ﻿ | ﻿ | ﻿ | ﻿ | ﻿
﻿ | ﻿ | ﻿ | ﻿ | ﻿
Spreadsheet: 686079d1594351749-linear-interpolation-depth-vs-reading
Sheet: Sheet1

Depth(mm) | Reading |  | Depth (mm) | Interpolated Reading
-0.5 | 52.89 |  | 0
1 | 57.51 |  | 1
2.2 | 65.87 |  | 2
3.4 | 76.26 |  | 3
4.6 | 84.45 |  | 4
5.8 | 90.25 |  | 5
7.1 | 93.66 |  | 6
8.3 | 96 |  | 7
9.4 | 97.65 |  | 8
10.7 | 98.68 |  | 9
11.9 | 99.94 |  | 10
13.1 | 100 |  | 11
14.3 | 99.91 |  | 12
15.5 | 99.94 |  | 13
16.7 | 99.57 |  | 14
18 | 99.41 |  | 15
19.2 | 98.78 |  | 16
20.3 | 98.31 |  | 17
21.6 | 97.9 |  | 18
 |  |  | 19
 |  |  | 20
Spreadsheet: 117119d1312464660-custom-error-bars-not-showing-problem-error-bars-chart
Sheet: Sheet1

0.3643021402390001 | 0.408248290463863 | 0.4120110270608701 | 0.408248290463863 | 0.2421610524189263 | 0.32394177193585 | 0.4444444444444444 | 0.408248290463863 | 0.3513641844631533 | 0.3093202423794457 | 0.5299662230094142 | 0.364302140239 | 0.5 | 0.5099322152968283
0.8642559957684546 | 0.808948318661365 | 0.3520495677546833 | 0.6070516099843662 | 0.5408288080795733 | 0.3635952301209088 | 0.3769835582875961 | 0.4044741593306825 | 0.3252094603380125 | 0.365860642880264 | 0.4945429799606417 | 0.4145623460671261 | 0.5632793084074932 | 0.3936033824744449
Spreadsheet: 716256d1612123466-have-a-text-value-with-sumifs-forum-excel-31-jan-2021
Sheet: Épargnes Inv.

 |  |  | Compte |  | Profit /perte | Solde fermeture
 | Solde des comptes (relevé le + récent, solde de fermeture): |  |  | Chèque
 |  |  |  | FTQ (REER)
 |  | + |  | Placement québec (CÉLI)
Profit/perte sur période de 12 mois (selon l'année financière): |  |  |  | Argent métal
 |  |  |  | Urgence
Date | Description | Compte | Solde relevé
2020-01-31 00:00:00 | Solde de fermeture
2020-02-29 00:00:00 | Solde de fermeture
2020-03-31 00:00:00 | Solde de fermeture
2020-04-30 00:00:00 | Solde de fermeture
2020-05-31 00:00:00 | Solde de fermeture
2020-06-30 00:00:00 | Solde de fermeture
2020-07-31 00:00:00 | Solde de fermeture
2020-08-31 00:00:00 | Solde de fermeture
2020-09-30 00:00:00 | Solde de fermeture
2020-10-31 00:00:00 | Solde de fermeture
2020-11-30 00:00:00 | Solde de fermeture
2020-12-31 00:00:00 | Solde de fermeture
Date | Description | Compte | Solde relevé | Montant | Profit /perte | Solde fermeture
2020-01-10 00:00:00 | Deposit | AR |  | 200
2020-01-21 00:00:00 | Deposit | AR |  | 200
2020-01-30 00:00:00 | Deposit | AR |  | 200
2020-03-01 00:00:00 | Deposit | FT |  | 300
2020-03-01 00:00:00 | Deposit | AR |  | 25
2020-03-05 00:00:00 | Withdrawal | AR |  | -30
2020-03-11 00:00:00 | Withdrawal | FT |  | -45
2020-03-13 00:00:00 | Withdrawal | AR |  | 20
2020-03-01 00:00:00 | Deposit | PL |  | 60
2020-03-01 00:00:00 | Deposit | UR |  | 80
2020-05-01 00:00:00 | Annual report (balance now at 230$) | AR | 230
2020-05-01 00:00:00 | Annual report (balance now at 280$) | PL | 320
2020-05-01 00:00:00 | Annual report (balance now at 55$) | PL | 55
2020-05-01 00:00:00 | Annual report (balance now at 77$) | UR | 77
Spreadsheet: 859445d1707832766-how-to-populate-daily-sales-dynamically-based-on-the-week-ending-dates-and-daily-breakdo-daily-splits-tbc
Sheet: Daily Flow Plan

 | 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 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 60 | 61 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70 | 71 | 72 | 73 | 74 | 75 | 76 | 77 | 78 | 79 | 80 | 81 | 82 | 83 | 84 | 85 | 86 | 87 | 88 | 89 | 90 | 91 | 92 | 93 | 94 | 95 | 96 | 97 | 98 | 99 | 100 | 101 | 102 | 103 | 104 | 105 | 106 | 107 | 108 | 109 | 110 | 111 | 112 | 113 | 114 | 115 | 116 | 117 | 118 | 119 | 120 | 121 | 122 | 123 | 124 | 125 | 126 | 127 | 128 | 129 | 130 | 131 | 132 | 133 | 134 | 135 | 136 | 137 | 138 | 139 | 140 | 141 | 142 | 143 | 144 | 145 | 146 | 147 | 148 | 149 | 150 | 151 | 152 | 153 | 154 | 155 | 156 | 157 | 158 | 159 | 160 | 161 | 162 | 163 | 164 | 165 | 166 | 167 | 168 | 169 | 170 | 171 | 172 | 173 | 174 | 175 | 176 | 177 | 178 | 179 | 180 | 181 | 182 | 183 | 184 | 185 | 186 | 187 | 188 | 189 | 190 | 191 | 192 | 193 | 194 | 195 | 196 | 197 | 198 | 199 | 200 | 201 | 202 | 203 | 204 | 205 | 206 | 207 | 208 | 209 | 210 | 211 | 212 | 213 | 214 | 215 | 216 | 217 | 218 | 219 | 220 | 221 | 222 | 223 | 224 | 225 | 226 | 227 | 228 | 229 | 230 | 231 | 232 | 233 | 234 | 235 | 236 | 237 | 238
Days Operating | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7
Day
Date | 2024-08-04 00:00:00
Sales
Spreadsheet: 770410d1646055327-lookup-value-across-multiple-sheets-and-count-number-of-matching-occurrences-vlookupcount_sample
Sheet: Sheet2

[NAME] | On time
[NAME] | Available from 8.02
Mark | On time
[NAME] | On time
[NAME] | On time
Stephen | On time
[NAME] | On time
[NAME] | Available from 8.04
[NAME] | On time
Mark | On time
[NAME] | Available from 8.01
Spreadsheet: 150163d1334318271-chart-with-multipe-axis-copy-of-book2
Sheet: Sheet11

Ticket price |  |  |  |  |  |  | Cost/revenue
160 |  |  |  |  |  |  | 5000
150 |  |  |  |  |  |  | 4500
140 |  | Indirect  costs |  |  |  |  | 4000
130 |  |  |  |  |  |  | 3500
120 |  |  |  |  |  |  | 3000
110 |  |  |  |  |  |  | 2500
100 |  |  |  |  |  |  | 2000
90 |  |  | Direct costs |  |  |  | 1500
80 |  |  |  |  |  |  | 1000
70 |  |  |  |  |  |  | 500
60
50
 | 29 | 30 | 31 | 32 | 33 | 34
 | 29 | 30 | 31 | 32 | 33 | 34 | direct cost | Indirect cost
160 | 4092480 | 4233600 | 4374720 | 4515840 | 4656960 | 4798080 | 2742036.242134375 | 1827250.092943544
150 | 3836700 | 3969000 | 4101300 | 4233600 | 4365900 | 4498200 | 2742036.242134375 | 1827250.092943544
140 | 3580920 | 3704400 | 3827880 | 3951360 | 4074840 | 4198320 | 2742036.242134375 | 1827250.092943544
130 | 3325140 | 3439800 | 3554460 | 3669120 | 3783780 | 3898440 | 2742036.242134375 | 1827250.092943544
120 | 3069360 | 3175200 | 3281040 | 3386880 | 3492720 | 3598560 | 2742036.242134375 | 1827250.092943544
110 | 2813580 | 2910600 | 3007620 | 3104640 | 3201660 | 3298680 | 2742036.242134375 | 1827250.092943544
100 | 2557800 | 2646000 | 2734200 | 2822400 | 2910600 | 2998800 | 2742036.242134375 | 1827250.092943544
90 | 2302020 | 2381400 | 2460780 | 2540160 | 2619540 | 2698920 | 2742036.242134375 | 1827250.092943544
80 | 2046240 | 2116800 | 2187360 | 2257920 | 2328480 | 2399040 | 2742036.242134375 | 1827250.092943544
70 | 1790460 | 1852200 | 1913940 | 1975680 | 2037420 | 2099160 | 2742036.242134375 | 1827250.092943544
60 | 1534680 | 1587600 | 1640520 | 1693440 | 1746360 | 1799280 | 2742036.242134375 | 1827250.092943544
50 | 1278900 | 1323000 | 1367100 | 1411200 | 1455300 | 1499400 | 2742036.242134375 | 1827250.092943544
Spreadsheet: 838209d1690819526-how-do-i-change-specific-text-color-within-a-formula-sample-worksheet
Sheet: Sheet1

Automatic Monthly Deposits |  |  |  | 2023-09-01 00:00:00 |  | September 2023 Deposits & Withdrawals
Date |  |  |  | Deposit |  | Expense |  | Date & Description of Additional Debits and/or Credits | Balance
 |  |  | Discretionary Savings Account - flexible
Desired result below
Automatic Monthly Deposits |  |  |  | 2023-09-01 00:00:00 |  | September 2023 Deposits & Withdrawals
Date |  |  |  | Deposit |  | Expense |  | Date & Description of Additional Debits and/or Credits | Balance
 |  |  | Discretionary Savings Account - flexible |  |  |  |  | (Sep-1 > $100 Discretionary Deposit) - (Sep-1 > $50 Miscellaneous Cleaning)
Spreadsheet: 672764d1586991212-group-cells-on-the-same-line-ecxel-forum
Sheet: Folha1

1 |  | XCHO |  |  |  |  | 530500855 |  | 906 |  |  |  |  | 212-31 |  |  |  |  |  | REWMACH |  |  |  |  |  |  | 1
2 | ABDC |  |  |  | 593501279 |  |  |  | 349 |  |  |  | 33W13N |  |  |  |  |  |  | VERTRICAL |  |  |  |  |  |  |  | 1
83 |  | UTRS |  |  |  | 590500534 |  |  |  |  | 349 |  |  |  |  | J2321FS |  |  |  |  |  | R,FIXILM |  |  |  |  |  |  |  |  |  |  |  | 1
84 |  | CADE |  |  |  | 590501133 |  |  |  |  | 349 |  |  | 1471FS |  |  |  |  |  |  |  | STOR,FIXED,F |  |  |  |  |  |  |  |  | 1
7 | MYRE |  |  | 591000113 |  |  |  |  | 349 |  |  |  | M39014/02-1360 |  |  |  |  |  |  |  | TOR,FIXED,CE |  |  |  |  |  |  |  | 1
8 | CUTO |  |  |  | 591001217 |  |  |  |  | 349 |  |  | 421/01-4051S |  |  |  |  |  |  |  | CITOR,FIXED,ME |  |  |  |  |  |  |  |  | 2
4 |  | SOPE | 531000933 |  |  |  |  | 906 |  |  | 338-138 |  |  |  |  |  | SHER |  |  |  |  |  |  |  |  | 6
5 | VRYI |  | 531000781 |  |  |  |  | 205 |  |  | 20C10L |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  | 6
 |  | I WOLD LIKE TO JOIN THE CELLS ABOVE NEXT TO EACHT OTHER LIKE THIS BOARD BELOW
1 | XCHO | 530500855 | 906 | 212-31 | REWMACH | 1
2 | ABDC | 593501279 | 349 | 33W13N | VERTRICAL | 1
83 | UTRS | 590500534 | 349 | J2321FS | R,FIXILM | 1
84 | CADE | 590501133 | 349 | 1471FS | STOR,FIXED,F | 1
7 | MYRE | 591000113 | 349 | M39014/02-1360 | TOR,FIXED,CE | 1
8 | CUTO | 591001217 | 349 | 421/01-4051S | CITOR,FIXED,ME | 2
4 | SOPE | 531000933 | 906 | 338-138 | SHER | 6
5 | VRYI | 531000781 | 205 | 20C10L | [NAME] | 6
Spreadsheet: 799833d1665339817-index-formula-to-retrieve-data-workbook
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | Store1 | [NAME] | Store3 | Store4 | Store5
 |  |  |  |  |  |  |  | [NAME] |  | 2020-1st Qtr | 10000
 |  |  |  |  |  |  |  |  |  | 2020-2ndQtr | 20000
 |  |  |  |  |  |  |  |  |  | 2020-3rdQtr | 10400
 |  |  |  |  |  |  |  |  |  | 2020-4thQtr | 9988
 |  |  |  |  |  |  |  |  |  | Gross Pay
 |  |  |  |  |  |  |  |  |  | 2020-Owners Pay | 9000
Store Name |  |  |  |  |  |  |  |  |  | 2020-PPP | 10000
2020-1st Qtr |  |  |  |  |  |  |  |  |  | 2020 Credit
2020-2ndQtr
2020-3rdQtr |  |  |  |  |  |  |  |  |  | 2021-1stQtr | 12999
2020-4thQtr |  |  |  |  |  |  |  |  |  | 2021-2ndQtr | 29888
Gross Pay |  |  |  |  |  |  |  |  |  | 2021-3rdQtr | 309999
2020-Owners Pay
2020-PPP |  |  |  |  |  |  |  |  |  | 2021-Owners Pay | 240000
 |  |  |  |  |  |  |  |  |  | 2021-PPP
2020 Credit
 |  |  |  |  |  |  |  |  |  | 2021 Credit
2021-1stQtr
2021-2ndQtr |  |  |  |  |  |  |  |  |  | Total Credit
2021-3rdQtr
2021-Owners Pay
2021-PPP
2021 Credit
Total Credit
Spreadsheet: 837838d1690458737-array-formula-division-help-needed-array_formula
Sheet: Sheet1

Building | Capacity | Headcount
A | 1 | 1
A | 2 | 2
A | 3 | 3
A | 4 | 4
A | 5 | 5
B | 6 | 6
B | 7 | 7
B | 8 | 8
B | 9 | 9
B | 10 | 10