tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 7af1aebb-de05-4c0a-b920-4415cc11dd60
Sheet: BAd 413

COURSE ASSESSMENT MATRIX
COURSE:  BAd 413 Reservation Entrepreneurial Operations
Objective | Assessment Method | Desired Result | Corrective Action
Formulate knowledge of Land Status issues on the reservation | Quizzes                                        Weekly Assignments                                                             Exams | 90 % students pass quizzes                                   80% students pass exams                                              Pass weekly assignments | revise quizzes                    revise exams                         revise weekly assignments
Formulate knowledge of business financing as it relates to the reservation | Quizzes                                        Weekly Assignments                                                             Exams | 90 % students pass quizzes                                   80% students pass exams                                              Pass weekly assignments | revise quizzes                    revise exams                         revise weekly assignments
Appraise Tribal Tax Laws | Quizzes                                        Weekly Assignments                                                             Exams | 90 % students pass quizzes                                   80% students pass exams                                              Pass weekly assignments | revise quizzes                    revise exams                         revise weekly assignments
Appriase the Tribal Uniform Commercial Code | Quizzes                                        Weekly Assignments                                                             Exams | 90 % students pass quizzes                                   80% students pass exams                                              Pass weekly assignments | revise quizzes                    revise exams                         revise weekly assignments
Apply the Business Licensing process on the reservation | Quizzes                                        Weekly Assignments                                                             Exams | 90 % students pass quizzes                                   80% students pass exams                                              Pass weekly assignments | revise quizzes                    revise exams                         revise weekly assignments
Spreadsheet: 810227d1671626178-value-error-upload
Sheet: Sheet1

 |  |  | AL | PH |  |  | Name
 | CF |  |  |  |  |  | Dept.
 | Leave entitlement |  |  |  |  |  | Base
 | Total
 | Leave used |  |  |  |  |  | Year
 | Leave remaining
 | ANNUAL LEAVE
 | Month | 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 | AL
 | April
 | May
 | June
 | July
 | August
 | September
 | October
 | November
 | December
 | January
 | February
 | March
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Totals
 | PUBLIC HOLIDAYS
 | Month | 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 | PH
 | April
 | May
 | June
 | July
 | August
 | September
 | October
 | November
 | December
 | January
 | February
 | March
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Totals
 | AL | Annual leave |  |  |  |  |  | NOTES
 | PH | Public holiday
 | SC | Sick leave (Certificated)
 | SU | Sick leave (UN-certificated)
 | ST | Study leave
 | C | Compassionate leave
 | M | Maternity leave
 | UL | Unpaid leave
 |  | Special leave
Spreadsheet: 153739d1336035721-networkdays-formula-complete-ps-2012
Sheet: May 2012

2012-05-01 00:00:00
Date Submitted | Job No | Site | Customer | Project Engineer / Manager | Scope of work | Min People | Actual People | Budget Hours | Actual Hours | Field of work | Start Date | Finish Date | Comments / Additional Information | Special Tools |  |  | Match | Monthly Hours | May | June
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Man Hours | Available Hrs
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Electrical |  | 1000 |  |  | Hours | 09:00:00 | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mechanical |  | 250 |  |  |  | 17:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Site Electrical |  | 400
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Site Mechanical |  | 400
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Site Supervisor |  | 750
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-06-04 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-06-05 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-08-27 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-12-25 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-12-26 00:00:00
Spreadsheet: 0152e851-70b9-4427-b60a-8620d3ca2bc3
Sheet: CPI Data

 | HR&A Advisors, Inc.
 | Inner Loop East Reconstruction Project
 | Inflation Calculation
 | Year | Price Level | Inflation to 2013
 | 2013
 | 2012
 | 2010
 | * Price levels are for the month of April, given the lack of full-year data for 2013
 | Consumer Price Index - All Urban Consumers
 | Original Data Value
 | Series Id: | CUUR0000SA0
 | Not Seasonally Adjusted
 | Area: | U.S. city average
 | Item: | All items
 | Base Period: | 1982-84=100
 | Years: | 2003 to 2013
 | Year | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Annual | HALF1 | HALF2
 | 2003 | 181.7 | 183.1 | 184.2 | 183.8 | 183.5 | 183.7 | 183.9 | 184.6 | 185.2 | 185 | 184.5 | 184.3 | 184 | 183.3 | 184.6
 | 2004 | 185.2 | 186.2 | 187.4 | 188 | 189.1 | 189.7 | 189.4 | 189.5 | 189.9 | 190.9 | 191 | 190.3 | 188.9 | 187.6 | 190.2
 | 2005 | 190.7 | 191.8 | 193.3 | 194.6 | 194.4 | 194.5 | 195.4 | 196.4 | 198.8 | 199.2 | 197.6 | 196.8 | 195.3 | 193.2 | 197.4
 | 2006 | 198.3 | 198.7 | 199.8 | 201.5 | 202.5 | 202.9 | 203.5 | 203.9 | 202.9 | 201.8 | 201.5 | 201.8 | 201.6 | 200.6 | 202.6
 | 2007 | 202.416 | 203.499 | 205.352 | 206.686 | 207.949 | 208.352 | 208.299 | 207.917 | 208.49 | 208.936 | 210.177 | 210.036 | 207.342 | 205.709 | 208.976
 | 2008 | 211.08 | 211.693 | 213.528 | 214.823 | 216.632 | 218.815 | 219.964 | 219.086 | 218.783 | 216.573 | 212.425 | 210.228 | 215.303 | 214.429 | 216.177
 | 2009 | 211.143 | 212.193 | 212.709 | 213.24 | 213.856 | 215.693 | 215.351 | 215.834 | 215.969 | 216.177 | 216.33 | 215.949 | 214.537 | 213.139 | 215.935
 | 2010 | 216.687 | 216.741 | 217.631 | 218.009 | 218.178 | 217.965 | 218.011 | 218.312 | 218.439 | 218.711 | 218.803 | 219.179 | 218.056 | 217.535 | 218.576
 | 2011 | 220.223 | 221.309 | 223.467 | 224.906 | 225.964 | 225.722 | 225.922 | 226.545 | 226.889 | 226.421 | 226.23 | 225.672 | 224.939 | 223.598 | 226.28
 | 2012 | 226.665 | 227.663 | 229.392 | 230.085 | 229.815 | 229.478 | 229.104 | 230.379 | 231.407 | 231.317 | 230.221 | 229.601 | 229.594 | 228.85 | 230.338
 | 2013 | 230.28 | 232.166 | 232.773 | 232.531
Spreadsheet: 9109a424-3242-4a81-85cc-5bfa633fa4c1
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
OAU | Test | OAU | Organic Acids Screen, [NAME] | Organic Acids Scrn, U | Gas Chromatography/Mass Spectrometry (GC/MS) | [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. Additional Information: 1. Patient's age is required. 2. Include family history, clinical condition (asymptomatic or acute episode), diet, and drug therapy information. Forms: If not ordering electronically, submit a Biochemical Genetics Request Form (Supply T439) with the specimen. | 4 mL | Hemolysis	NA Thawing	Warm reject; Cold OK - note to lab Lipemia	NA Icterus	NA Other	NA | An interpretive report will be provided. | Monday through Friday; 7:30 a.m./Continuously | 3 days (not reported on Saturday or Sunday) | 6 days | 1 | 83919 |  |  |  |  | Rochester
OAU | [NAME] | URINE | [NAME] |  |  |  | Frozen | 90 days
OAU | Result | 80619 | Organic Acids Scrn, U | Organic Acids Scrn, U | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2676-5
Spreadsheet: 102485d1300405622-sumif-over-multiple-ranges-pvtsumif
Sheet: Sheet1

Worker | Task | Amt
Emp1
Emp2 |  |  |  |  | Sum of Amt | Column Labels
Emp3 |  |  |  |  | Row Labels | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | Grand Total
Emp4 |  |  |  |  | Emp1 | 16 | 3 |  |  | 21 | 20 | 12 | 18 |  |  | 90
Emp5 |  |  |  |  | Emp2 |  |  | 15 | 4 |  |  | 13 |  | 22 |  | 54
Emp6 |  |  |  |  | Emp3 |  |  |  |  | 13 | 29 |  |  |  | 26 | 68
Emp7 |  |  |  |  | Emp4 |  |  | 2 |  |  | 21 |  | 18 | 6 |  | 47
Emp1 |  |  |  |  | Emp5 |  |  |  |  | 18 | 31 | 6 |  |  | 21 | 76
Emp2 |  |  |  |  | Emp6 | 19 |  | 35 |  |  |  |  |  | 5 | 7 | 66
Emp3 |  |  |  |  | Emp7 | 20 |  |  |  | 10 |  | 9 | 22 |  | 3 | 64
Emp4 |  |  |  |  | Grand Total | 55 | 3 | 52 | 4 | 62 | 101 | 40 | 58 | 33 | 57 | 465
Emp5
Emp6
Emp7
Emp1
Emp2
Emp3
Emp4
Emp5
Emp6
Emp7
Emp1
Emp2
Emp3
Emp4
Emp5
Emp6
Emp7
Emp1
Emp2
Emp3
Emp4
Emp5
Emp6
Emp7
Emp1
Emp2
Emp3
Emp4
Emp5
Emp6
Emp7
Spreadsheet: 866630d1713534910-if-value-text-duplicate-then-return-value-text-1-2-3-id-count-formula
Sheet: Sheet1

ENTRY NR | ID | BUSINESS FUNCTION
1 | BUS-1 | BUS
2 | BUS-2 | BUS
3 | BUS-3 | BUS
4 | STE-1 | STE
5 | [NAME] | FIN
6 | [NAME] | BUS
7 | STE-2 | STE
8 | FIN-2 | FIN
9 | BUS-5 | BUS
10 | [NAME] | FIN
11
12
13
14
15
16
17
18
19
20
21
22
23
24
Spreadsheet: 774491d1648500269-help-on-large-and-matching-multiple-columns-sample
Sheet: Sheet1

 | Weeks
EMP | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 |  | week | 12
a |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | o | 28
b |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | m | 6
c |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | a | 4
d |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | w | 4
e
f
g
h
i
j
k
l
m
n
o
p
q
r
s
t
u
v
w
x
Spreadsheet: 390289d1429587968-please-help-me-formula-for-sum-for-text-and-number-in-same-cells-new-microsoft-excel-worksheet
Sheet: Sheet1

 | DINNER MENU 2015 FOR  ROYAL FAMILY |  | HH.SH.MOHAMED | HH.SH RASID |  | HH.SH.HAMDAN | HH.SH. [NAME] | HH.SH [NAME] | HH.SH.AHAMED | HH.SH.SAEED | HH.SH.SAEED | HH.SH.MAJID | HH.SH.MANSOOR | HH.SH.MANSOOR | SHK.HESSA | SHK. MAITHA | UMMU | H.H. SHK.AHMED | MAMA SHIEKHA | ZAABEEL | MRM GUEST |  | MAMA SHIEKHA |  |  |  |  |  | BOWLS | 17000 KUB | 8000 KUB | 7500 HP | 5000 HP | 3500 HP | 2500 HP | FULL CD | 1/2 CD | 1/4 CD | 45CM PLATE | EXTRA SET
 | MONDAY  SWEETS |  | MARMOOM | [NAME] |  | NADAL SHEBA CLUB | BAHRSHA 1 | NEW VILLA ZAABEEL | AL WASAL VILA 24 | NADAL SHEBA | NADAL SHEBA | NAD AL SHEBA | NADAL SHEBA | BARSHA | SHK.HIND SIST |  | KHALID | MAJLIS | HOUSE | MAJLISCD | VILLA 45 |  | HOUSE |  |  |  |  | DINNER MENU 2015 FOR VVIP
 | CODE NUMBER |  | 1001 | 6002 |  | 4001 | 5002 | 5001 | 7001 | 8001 | 8001 | 8202 | 8101 | 8102 | 2038 | 9001 | 2049 | 7003 | 2037 | 9000 | 1005 |  | 2037
1 | MAHALLA |  |  | 2 3500HP |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | MAHALLA
2 | [NAME] | MRM+ROYAL | 2 1/2CD | 1 3500HP |  |  |  |  |  | 1 3500HP | 1/2CD 1 | 1 3500HP |  |  |  | 1/2CD 1 |  |  |  |  |  |  |  |  |  |  | 2 | [NAME]
3 | ASEEDA BOBAR WITH OUT SUGAR | MRM | 5 BOWLS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | ASEEDA BOBAR WITH OUT SUGAR
4 | SHEIRA | MRM | 5 BOWLS +1 HP |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | SHEIRA
5 | KHABEESA | MRM | 1/4CD 2  +5 BOWLS | 1 5000HP |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | KHABEESA
6 | SAGO | MRM | 5 BOWLS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | SAGO
7 | GARASH MAFROUK | MRM | 1/4CD 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | GARASH MAFROUK
Spreadsheet: 18ea3d94-45e5-4414-be39-06c985d4e826
Sheet: November

November |  | Cut and paste data from monthly classroom results in these columns
 | average
 | rate
 | school
 | 0 min
 | 1-5 min
 | 6-10 min
 | 11-15 min
 | 16-20 min
 | 21-25 min
 | 26-30 min
 | 31+ min
 | grade
 | number
 | grade
 | number
 | grade
 | number
School Totals |  |  |  | School DPA Summary for
average
rate
school
0 min
1-5 min
6-10 min
11-15 min
16-20 min
21-25 min
26-30 min
31+ min
Spreadsheet: 581429d1531298856-compare-2-sheets-and-show-balance-bbsn
Sheet: ENTRY

CODE | YumNak | Customer Name | Address | DATE | MONTH | YEAR | Date of Keeping | Serial Number | Item Name | Gross Weight | Net Weight | Amount | Remarks | Column1 | Column2 | Column3 | Column4
AS1 | kh | Ranjana | Khabam | 9 | 3 | 2018 |  | 1 | [NAME] | 3 san | 2 san | 10000 | recievedd 200
AS2 | L | [NAME] | mantripukri | 9 | 3 | 2015 |  | 2 | lei |  | 1 san | 20000
AS3 |  |  |  | 9 | 3 | 2018
AS4
as5
Spreadsheet: 807224d1669810067-transfer-of-data-from-a-master-sheet-to-other-sheets-major-last
Sheet: Cash in hand

Helper |  | Date | Description | Debit | Credit
 |  |  |  |  |  | Cash in Hand
Spreadsheet: 0b1108ae-47ca-4498-8397-43ac006f4ab4
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
8281 | 21281 | Gabi | Weiler | GER | 0 | 00:37:01 | 00:03:30 | 03:03:04 | 00:02:01 | 01:50:36 | 1 | 05:36:12
8281 | 60560 | Felicitas | Kuld | GER | 0 | 00:42:44 | 00:03:01 | [NAME] | 00:02:54 | 02:04:30 | 2 | 05:53:04
8281 | 60561 | Elinor | Klaschka-Lill | GER | 0 | 00:39:39 | 00:04:56 | 03:32:29 | 00:02:55 | 02:27:55 | 3 | 06:47:52
Spreadsheet: 150654d1334652224-hi-newbie-here-if-function-confusion-test
Sheet: Sheet1

Total Care Gold 12 | 2511 | 3138.75
Total Care Gold 24 (2 yrs) | 3749 | 4686.25
Total Care Gold 36 (3 yrs) | 4987 | 6233.75
Total Care Gold 48 (4 yrs) | 6002 | 7502.5
Total Care Gold 60 (5 yrs) | 6494 | 8117.5
Total Care Gold Lite 12 | 1338 | 1672.5
Total Care Gold Lite 24 (2 yrs) | 2676 | 3345
Total Care Silver 12 | 1761 | 2201.25
Total Care Silver 24 (2 yrs) | 2999 | 3748.75
Total Care Silver 36 (3 yrs) | 3937 | 4921.25
Total Care Silver Lite 12 | 1238 | 1547.5
Spreadsheet: 196840d1354120908-spreadsheet-to-show-the-results-of-golf-competitions-golf-league-table-including-reults
Sheet: STOKE

 |  | THE CROWN GOLF SOCIETY ANSTEY LEICESTER
 |  |  | RESULT STOKE ALBANY G.C 2012
 | PLAYER | HANDICAP | POINTS SCORED | LEADERBOARD POINTS
1ST | [NAME] |  |  | 30
2ND | DAN |  |  | 29
3RD | MICK |  |  | 28
4TH | MALC |  |  | 27
5TH | MICK R |  |  | 26
6TH |  |  |  | 25
7TH |  |  |  | 24
8TH |  |  |  | 23
9TH |  |  |  | 22
10TH |  |  |  | 21
11TH |  |  |  | 20
12TH |  |  |  | 19
13TH |  |  |  | 18
14TH |  |  |  | 17
15TH |  |  |  | 16
16TH |  |  |  | 15
17TH |  |  |  | 14
18TH |  |  |  | 13
19TH |  |  |  | 12
20TH |  |  |  | 11
21ST |  |  |  | 10
22ND |  |  |  | 9
23RD |  |  |  | 8
24TH |  |  |  | 7
25TH |  |  |  | 6
26TH |  |  |  | 5
27TH |  |  |  | 4
28TH |  |  |  | 3
29TH |  |  |  | 2
30TH |  |  |  | 1
31st |  |  |  | 0
32nd |  |  |  | 0
33rd |  |  |  | 0
34th |  |  |  | 0
35th |  |  |  | 0
36th |  |  |  | 0
37th |  |  |  | 0
38th |  |  |  | 0
39th |  |  |  | 0
40th |  |  |  | 0
41st |  |  |  | 0
42nd |  |  |  | 0
43rd |  |  |  | 0
44th |  |  |  | 0
45th |  |  |  | 0
46th |  |  |  | 0
47th |  |  |  | 0
48th |  |  |  | 0
49th |  |  |  | 0
50th |  |  |  | 0
 | LONGEST DRIVE |  |  | 28TH APRIL 2012
 | NEAREST PIN
Spreadsheet: 44454d1243225340-color-cells-which-do-not-match-criteria-new-microsoft-excel-worksheet
Sheet: Sheet1

S.NO | Book_Category | [NAME]
1 | Computers | C1011 |  | All Computers books should start with Code C…
2 | Accounts | A2011 |  | Like wise Every Subject Category should start with The Subject Alphabet
3 | Engineering | E3001 |  | I need to Find the Wrong Code with the respective Book Category
4 | Accounts | A2012 |  | All Wrongly entered Codes should be marked with [NAME]
5 | Engineering | E3002
6 | Computers | A2012
7 | Computers | A2013
8 | Engineering | E3002
9 | Engineering | E3003
10 | Engineering | E3004
jj
Spreadsheet: 117176d1312484852-how-do-i-run-a-monte-carlo-on-stock-probabilities-txn-simulation
Sheet: Table

Number | Date | Adj. Close* | % Change
1 | 2005-12-01 00:00:00 | 32.01
2 | 2005-11-01 00:00:00 | 32.42
3 | 2005-10-03 00:00:00 | 28.5
4 | 2005-09-01 00:00:00 | 33.8
5 | 2005-08-01 00:00:00 | 32.58
6 | 2005-07-01 00:00:00 | 31.67
7 | 2005-06-01 00:00:00 | 27.99
8 | 2005-05-02 00:00:00 | 27.56
9 | 2005-04-01 00:00:00 | 24.89
10 | 2005-03-01 00:00:00 | 25.39
11 | 2005-02-01 00:00:00 | 26.37
12 | 2005-01-03 00:00:00 | 23.12
13 | 2004-12-01 00:00:00 | 24.5
14 | 2004-11-01 00:00:00 | 24.06
15 | 2004-10-01 00:00:00 | 24.33
16 | 2004-09-01 00:00:00 | 21.15
17 | 2004-08-02 00:00:00 | 19.42
18 | 2004-07-01 00:00:00 | 21.2
19 | 2004-06-01 00:00:00 | 24.01
20 | 2004-05-03 00:00:00 | 25.92
21 | 2004-04-01 00:00:00 | 24.92
22 | 2004-03-01 00:00:00 | 28.99
23 | 2004-02-02 00:00:00 | 30.41
24 | 2004-01-02 00:00:00 | 31.1
25 | 2003-12-01 00:00:00 | 29.13
26 | 2003-11-03 00:00:00 | 29.5
27 | 2003-10-01 00:00:00 | 28.67
28 | 2003-09-02 00:00:00 | 22.59
29 | 2003-08-01 00:00:00 | 23.63
30 | 2003-07-01 00:00:00 | 18.69
31 | 2003-06-02 00:00:00 | 17.42
32 | 2003-05-01 00:00:00 | 20.29
33 | 2003-04-01 00:00:00 | 18.3
34 | 2003-03-03 00:00:00 | 16.18
35 | 2003-02-03 00:00:00 | 16.55
36 | 2003-01-02 00:00:00 | 15.71
37 | 2002-12-02 00:00:00 | 14.82
38 | 2002-11-01 00:00:00 | 19.75
39 | 2002-10-01 00:00:00 | 15.65
40 | 2002-09-03 00:00:00 | 14.56
41 | 2002-08-01 00:00:00 | 19.42
42 | 2002-07-01 00:00:00 | 22.82
43 | 2002-06-03 00:00:00 | 23.34
44 | 2002-05-01 00:00:00 | 28.23
45 | 2002-04-01 00:00:00 | 30.46
46 | 2002-03-01 00:00:00 | 32.57
47 | 2002-02-04 00:00:00 | 28.88
48 | 2002-01-02 00:00:00 | 30.71
49 | 2001-12-03 00:00:00 | 27.53
50 | 2001-11-01 00:00:00 | 31.52
51 | 2001-10-01 00:00:00 | 27.52
52 | 2001-09-04 00:00:00 | 24.55
53 | 2001-08-01 00:00:00 | 32.53
54 | 2001-07-02 00:00:00 | 33.9
55 | 2001-06-01 00:00:00 | 31.32
56 | 2001-05-01 00:00:00 | 33.5
57 | 2001-04-02 00:00:00 | 38
58 | 2001-03-01 00:00:00 | 30.4
59 | 2001-02-01 00:00:00 | 29
60 | 2001-01-02 00:00:00 | 42.98
61 | 2000-12-01 00:00:00 | 46.47
Spreadsheet: 181424d1348040882-compare-tables-in-excel-0a1_f_discounts-3-
Sheet: New Discounts

Number | Discount
[PHONE] | 56027
[PHONE] | 53457
[PHONE] | 56014
[PHONE] | 3686
[PHONE] | 56003
[PHONE] | 56009
[PHONE] | 56027
[PHONE] | 53457
[PHONE] | 56014
[PHONE] | 3686 |  |  | [PHONE] | 56027
[PHONE] | 56005 |  |  | [PHONE] | 53457
[PHONE] | 56013 |  |  | [PHONE] | 56014
[PHONE] | 56027 |  |  | [PHONE] | 3686
[PHONE] | 53457 |  |  | [PHONE] | 56003
[PHONE] | 56014 |  |  | [PHONE] | 56009
[PHONE] | 3686
[PHONE] | 56003
[PHONE] | 56009
[PHONE] | 56027
[PHONE] | 53457
[PHONE] | 56014
[PHONE] | 3686
[PHONE] | 56005
[PHONE] | 56013
[PHONE] | 56027
[PHONE] | 53457
[PHONE] | 56014
[PHONE] | 3686
[PHONE] | 56003
[PHONE] | 56009
[PHONE] | 56027
[PHONE] | 53457
[PHONE] | 56014
[PHONE] | 3686
[PHONE] | 56005
[PHONE] | 56013
[PHONE] | 56027
[PHONE] | 53457
[PHONE] | 56014
[PHONE] | 3686
[PHONE] | 56003
[PHONE] | 56009
[PHONE] | 56027
[PHONE] | 53457
[PHONE] | 56014
[PHONE] | 3686
[PHONE] | 56005
[PHONE] | 56013
[PHONE] | 56027
[PHONE] | 53457
[PHONE] | 56014
[PHONE] | 3686
[PHONE] | 56005
[PHONE] | 56013
[PHONE] | 56027
[PHONE] | 53457
[PHONE] | 56014
[PHONE] | 3686
[PHONE] | 56003
[PHONE] | 56009
[PHONE] | 56027
[PHONE] | 53457
[PHONE] | 56014
[PHONE] | 3686
[PHONE] | 56005
[PHONE] | 56013
[PHONE] | 56027
[PHONE] | 53457
[PHONE] | 56014
[PHONE] | 3686
[PHONE] | 56005
[PHONE] | 56013
[PHONE] | 56027
[PHONE] | 53457
[PHONE] | 56014
[PHONE] | 3686
[PHONE] | 56005
[PHONE] | 56013
[PHONE] | 56027
[PHONE] | 53457
[PHONE] | 56014
[PHONE] | 3686
Spreadsheet: 774342d1648406692-sumifs-with-sums-from-mulitple-columns-based-on-its-names-file
Sheet: Arkusz1

customer | product | sub-product | volume Jan | revenue Jan | costs Jan | volume Feb | revenue Feb | costs Feb | volume  March | revenue  March | costs  March | volume April | revenue April | costs April | SUM VOLUME
www | [NAME] | wer | 180 | 65 | 23 | 230 | 155 | 202 | 200 | 123 | 56 | 163 | 89 | 153
eee | [NAME] | sdf | 80 | 35 | 21 | 16 | 90 | 149 | 131 | 2 | 59 | 199 | 112 | 205
rrr | wsx | xcv | 77 | 207 | 199 | 69 | 67 | 55 | 105 | 219 | 109 | 84 | 33 | 49
ttt | [NAME] | wer | 227 | 118 | 138 | 44 | 231 | 14 | 116 | 45 | 37 | 78 | 113 | 142
eee | wsx | sdf | 137 | 93 | 100 | 191 | 231 | 4 | 49 | 143 | 68 | 16 | 156 | 22
rrr | [NAME] | xcv | 82 | 223 | 231 | 170 | 207 | 98 | 24 | 77 | 112 | 116 | 222 | 2
ttt | wsx | wer | 45 | 14 | 85 | 16 | 175 | 35 | 8 | 175 | 87 | 179 | 147 | 133
www | [NAME] | sdf | 7 | 217 | 194 | 101 | 74 | 88 | 50 | 93 | 125 | 98 | 80 | 4
www | [NAME] | wer | 135 | 40 | 216 | 114 | 102 | 14 | 126 | 155 | 64 | 206 | 38 | 48
eee | [NAME] | sdf | 79 | 126 | 172 | 194 | 123 | 11 | 36 | 211 | 15 | 153 | 46 | 84
rrr | wsx | xcv | 126 | 94 | 231 | 35 | 218 | 85 | 182 | 141 | 129 | 152 | 81 | 36
ttt | [NAME] | wer | 53 | 59 | 233 | 194 | 120 | 25 | 78 | 191 | 226 | 52 | 82 | 87
eee | wsx | sdf | 225 | 44 | 132 | 96 | 99 | 171 | 216 | 171 | 125 | 36 | 213 | 171
rrr | [NAME] | xcv | 197 | 223 | 82 | 133 | 18 | 169 | 211 | 223 | 34 | 73 | 107 | 153
ttt | wsx | wer | 200 | 80 | 125 | 74 | 176 | 93 | 21 | 120 | 4 | 168 | 43 | 109
www | [NAME] | sdf | 213 | 196 | 190 | 43 | 168 | 11 | 204 | 130 | 171 | 162 | 77 | 213
www | [NAME] | wer | 38 | 113 | 73 | 181 | 161 | 164 | 183 | 117 | 171 | 14 | 18 | 112
eee | [NAME] | sdf | 133 | 168 | 83 | 114 | 23 | 215 | 230 | 200 | 225 | 204 | 49 | 123
rrr | wsx | xcv | 23 | 22 | 47 | 41 | 133 | 226 | 95 | 67 | 76 | 124 | 110 | 173
ttt | [NAME] | wer | 119 | 142 | 126 | 189 | 105 | 225 | 130 | 26 | 216 | 9 | 123 | 203
eee | wsx | sdf | 134 | 88 | 150 | 38 | 223 | 188 | 102 | 0 | 199 | 69 | 159 | 25
Spreadsheet: 814738d1674570915-how-to-convert-a-range-to-non-blank-row-torow
Sheet: Sheet1

This range originated from an array formula (e.g filter function)
0 | 0 | 0 | 4/CT | 0 | 0 | 0 | 0
0 | 0 | 0 | 4/CMT | 0 | 0 | 0 | 0
0 | 0 | 0 | 4/MT | 4/PT | 4/ENT | 0 | 0
0 | 0 | 0 | 4/EMT | 0 | 0 | 0 | 0
1/CT | 1/CMT | 1/MT | 1/EMT | 1/PT | 1/ENT | 1/ET | 1/CT
My requirement as below
4/CT | 4/CMT | 4/MT | 4/PT | 4/ENT | 4/EMT | 1/CT | 1/CMT | 1/MT | 1/EMT | 1/PT | 1/ENT | 1/ET | 1/CT
Spreadsheet: 789296d1659028492-formulas-required-total-based-on-multiple-criteria-excel-help-280722
Sheet: Summary

 |  | No. of Sites | List Price | No. of Sites | List Price | No. of Sites | List Price | No. of Sites | List Price | No. of Sites | List Price
 |  | HOS0000503 | HOS0000503 | PHA0000501 | PHA0000501 | PSC0000504 | PSC0000504 | PSC0001004 | PSC0001004 | BRO0000507 | BRO0000507
U_BillToID | [NAME]
HQ000001 | x |  |  |  |  |  |  |  |  |  |  | need formula here in yellow that looks at the raw data tab
HQ000002 | xx
HQ000006 | xxx
HQ000007 | xxxx
HQ000008 | xxxxx
HQ000009 | xxxxxx
HQ000010 | xxxxxxx
 | xxxxxxxx
Spreadsheet: 716296d1612165029-dynamic-indirect-substitutes-all-default-to-errors-nv-quinary-dd-with-duplicates
Sheet: DDs

Primary | Secondary | Tertiary | Quaternary | Quinary
Airplane | Airbus | A319 | Air France | BBB
Car | Saab | Safe Car | 2500 cc | Indigo
Airplane | Saab | Big Plane | Air France | BBB