tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 35607d1233189649-excel-2007-can-excel-take-a-word-and-convert-it-to-a-number-qc-sheet-master
Sheet: Weekly Review

 |  |  |  |  |  |  |  | Weekly QC Report
 |  |  |  |  |  |  |  |  |  |  | 2009-01-26 00:00:00 | Thru
 |  |  |  |  |  |  |  | System: | Scranton
 | Technician |  |  |  | Days off | Jobs Routed | [NAME] | Jobs Not Completed | Work Completion % | QC % of Completed Work | Total QC Completed | QC % Break Down by [NAME] | Pass | Fail | QC Failure % By [NAME]
 | 1 | 1
 | 2 | 2
 | 3 | 3
 | 4 | 4
 | 5 | 5
 | 6 | 6
 | 7 | 7
 | 8 | 8
 | 9 | 9
 | 10 | 10
 | 11 | 11
 | 12 | 12
 | 13 | 13
 | 14 | 14
 | 15 | 15
 | 16 | 16
 | 17 | 17
 | 18 | 18
 | 19 | 19
 | 20 | 20
 | 21 | 21
 | 22 | 22
 | 23 | 23
 | 24 | 24
 | 25 | 25
 | Totals |  |  |  |  | Total Jobs | Completed | Not Completed | Total Comp % | Work QC'd Total | Total QC's Completed |  | Pass | Fail | QC Failure % Average
Spreadsheet: 60943d1261515640-how-to-copy-cells-based-upon-criteria-mastersheet-1
Sheet: Sheet1

 |  |  | P | M | C | S
 |  |  | iVillage.com: The Womens Network | 1BABY.COM
 |  |  | iVillage.com: The Womens Network | 1STBABY.COM
 |  |  | iVillage.com: The Womens Network | 800BABYGIFTS.COM
 |  |  | iVillage.com: The Womens Network | 888BABYGIFT.COM
 |  |  | iVillage.com: The Womens Network | 888BABYGIFTS.COM
 |  |  | iVillage.com: The Womens Network | ADVANCESINNEUROLOGY.COM
 |  |  | iVillage.com: The Womens Network | ADVANCESINONCOLOGY.COM
 |  |  | iVillage.com: The Womens Network | ALLWOMENSHEALTH.COM
 |  |  | iVillage.com: The Womens Network | ALZHEIMERS.COM | *.ALZHEIMERS.COM | *.ALZHEIMERS.COM
 |  |  | iVillage.com: The Womens Network | ALZHEIMERSNOW.COM
 |  |  | iVillage.com: The Womens Network | [NAME] | AMAZINGPREGNANCY.COM
Spreadsheet: 09809130-ac0d-450c-a95e-6b5ed2749279
Sheet: FACULTY INFORMATION FORM

Please use capital letters & no punctuation | EXAMPLE | class 1 info | class 2 info | class 3 info | class 4 info | class 5 info | class 6 info
Last Name | LOGAN
First Name | SARAH
MI | M
Printed Course Prefix (e.g. [NAME], ECH, RDG, EPSY, SPED) and Number | PSY3303
Printed Date/Time (e.g. MW 08:00 AM, TR 12:30 PM or MWF 18:00 PM) | TR 18:00 PM
Bubbled in Meeting Days (MTWRFSN) NO [NAME] or Spaces | TR
In the Classroom Survey = Face  OR  Online Survey = Online | Face
Eight Week Course = Y (yes) or N (no).    If YES… 1 for first eight weeks or 2 for second eight weeks | Y-2
For On-line courses ONLY - Print course title. In addition, please provide a class roster with [NAME] "username@angelo .edu" with your FIF.  Dropped students can be withdrawn later. | Learning  and Cognition
Objectives:  (Scale - M = Minor or No Importance,  I = Important,                              E = Essential) | M, I, E | M, I, E | M, I, E | M, I, E | M, I, E | M, I, E | M, I, E
1.  Gaining factual knowledge (terminology, classifications, methods,       trends) | E
2.  Learning fundamental principles, generalizations, or theories | E
3.  Learning to apply course material (to improve thinking, problem       solving,  and decisions) | E
4.  Developing specific skills, competencies, and points of view needed       by professionals in the field most closely related to this course | I
5.  Acquiring skills in working with others as a member of a team | I
6.  Developing creative capacities (writing, inventing, designing,       performing in art, music, drama, etc.) | M
7.  Gaining a broader understanding and appreciation of       intellectual/cultural activity (music, science, literature, etc.) | M
8.  Developing skill in expressing oneself orally or in writing | M
9.  Learning how to find and use resources for answering questions or       solving problems | M
10.  Developing a clearer understanding of, and commitment to, personal         values | M
11.  Learning to analyze and critically evaluate ideas, arguments,         and points of view | M
12.  Acquiring an interest in learning more by asking questions and         seeking answers | M
[NAME] (e.g.[NAME], ECH, RDG, EPSY, SPED) | PSY
Discipline codes:  EDU = 1300                                         (4 digits) | 4200 | 1300 | 1300 | 1300 | 1300 | 1300 | 1300
[NAME] (e.g. 800, 1230, or 1800) | 800
Bubbled Course Number                                                       (4 digits) | 3303
Enrollment | 23
Local Code for ED 2323 = 0200     or    Honors = 0201       (4 digits)
Long (L) or Short (S) Forms | L
Number of Additional Questions to be answered on the Survey  ([NAME]. number of Additional questions that can be asked for Long form = 19 & Short form = 10) | 12
Is this class [NAME]?   Y or N | N
Spreadsheet: 668309d1584729112-interactive-scenarios-based-on-available-funds-excel-scenarios
Sheet: Sheet1

 |  |  |  | Scenarios
 | # | Priority Completion | Cost | $1,000,000.00 | $1,500,000.00 | $2,000,000.00 | $2,500,000.00 | $3,000,000.00 | $3,500,000.00 | $4,000,000.00
 | 1 | Project A | 550000
 | 2 | Project B | 410000
 | 3 | Project C | 1000000
 | 4 | Project d | 600000
 | 5 | Project e | 150000
 | 6 | Project f | 200000
 | 7 | Project g | 300000
 | 8 | Project h | 125000
 | 9 | Project i | 250000
 | 10 | Project j | 400000
 | Almat Attempt:
 |  | Priority Completion | Cost | $1,000,000 | $1,500,000.00 | $2,000,000.00 | $2,500,000.00
 | ü | Project A | 550000
 |  | Project B | 410000 | ü | ü | ü | ü
 |  | Project C | 1000000 |  | ü | ü | ü
 |  | Project d | 600000 |  |  |  | ü
 |  | Project e | 150000 | ü |  | ü | ü
 |  | Project f | 200000
 |  | Project g | 300000 | ü | ü | ü | ü
 |  | Project h | 125000 | ü |  | ü
 |  | Project i | 250000
 |  | Project j | 400000
 |  | Total
Spreadsheet: 208141d1358727687-auto-populate-field-based-on-drop-down-box-selection-forum-example-autopopulate-dropdown-list
Sheet: Sheet2

Machine | size | noise level
 |  | [NAME] | L90 | L10
Bored Piling Rig | Unknown | 76 | 69 | 70
Excavator | 10T | 75
Hi-Rail excavator | Unknown | 83 | 63 | 75
Hi Rail with Tamping & Kango jacks | Unknown | 76 | 67 | 71
hi rail hiab
[NAME] | 25T | 82
Roller | 10T | 75
Crane | Unknown | 88
Backhoe | Unknown | 83
bobcat
NDD Trucks | Unknown | 97 | 94
Tipper/Dumper | 10 yard | 78
Water cart
Pipe welding kit
Loader
Concrete truck | Unknown | 85
Generator | Unknown | 77
Saw cutter |  | 80
Grader | Unknown | 85
[NAME] |  | 99 | 95
Geotech drilling rig | 205
Jackhammers |  | 100-120
Light Tower |  | 83
Spreadsheet: joe_parks__14577__Nymex Mar 18
Sheet: Positions-EES

Enron Energy Services - Retail Gas Desk
Open NYMEX positions of NESCO portfolios by forward strip
Value as of March 8,2002
 |  |  |  |  | Non-Member Customer |  |  | Clearing Member
 |  |  | Equivalent NYMEX |  | Margin | Initial |  | Margin | Initial
 | TOTAL NESCO |  | Contracts |  | Rate | Margin |  | Rate | Margin
Month
2002-04-01 00:00:00 | -2322903.677199 |  |  |  | 3375 |  |  | 2500
2002-05-01 00:00:00 | -1596298.03646 |  |  |  | 3375 |  |  | 2500
2002-06-01 00:00:00 | -1052730.722144 |  |  |  | 2700 |  |  | 2000
2002-07-01 00:00:00 | -898532.6701880001 |  |  |  | 2700 |  |  | 2000
2002-08-01 00:00:00 | -858066.4351560001 |  |  |  | 2700 |  |  | 2000
2002-09-01 00:00:00 | -873319.979079 |  |  |  | 2700 |  |  | 2000
2002-10-01 00:00:00 | -1147403.898929 |  |  |  | 2025 |  |  | 1500
2002-11-01 00:00:00 | -1423660.592502 |  |  |  | 2025 |  |  | 1500
2002-12-01 00:00:00 | -1726245.053556 |  |  |  | 2025 |  |  | 1500
2002
2003-01-01 00:00:00
2003-02-01 00:00:00
2003-03-01 00:00:00
2003-04-01 00:00:00
2003-05-01 00:00:00
2003-06-01 00:00:00
2003-07-01 00:00:00
2003-08-01 00:00:00
2003-09-01 00:00:00
2003-10-01 00:00:00
2003-11-01 00:00:00
2003-12-01 00:00:00
2003 | -10769915.769668 |  |  |  | 2025 |  |  | 1500
2004-2016 | -13958438.84838 |  |  |  | 2025 |  |  | 1500
TOTAL
Spreadsheet: 868357d1715091107-return-total-value-dependent-on-date-selected-andyd1234-book-2
Sheet: Sheet1

 | 2024-06-01 00:00:00
Month: | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | Total
value | 50 | 60 | 70 | 80 | 90 | 100 | 110 | 120 | 130 | 140 | 150
Month | 2024-08-01 00:00:00
 | Month: | value
 | 2024-04-01 00:00:00 | 50 |  |  | Row Labels | Sum of value |  | Row Labels | Sum of value
 | 2024-05-01 00:00:00 | 60 |  |  | 2024-04-01 00:00:00 | 50 |  | 2024-08-01 00:00:00 | 90
 | 2024-06-01 00:00:00 | 70 |  |  | 2024-05-01 00:00:00 | 60 |  | 2024-09-01 00:00:00 | 100
 | 2024-07-01 00:00:00 | 80 |  |  | 2024-06-01 00:00:00 | 70 |  | 2024-10-01 00:00:00 | 110
 | 2024-08-01 00:00:00 | 90 |  |  | 2024-07-01 00:00:00 | 80 |  | 2024-11-01 00:00:00 | 120
 | 2024-09-01 00:00:00 | 100 |  |  | 2024-08-01 00:00:00 | 90 |  | 2024-12-01 00:00:00 | 130
 | 2024-10-01 00:00:00 | 110 |  |  | Grand Total | 350 |  | 2025-01-01 00:00:00 | 140
 | 2024-11-01 00:00:00 | 120 |  |  |  |  |  | 2025-02-01 00:00:00 | 150
 | 2024-12-01 00:00:00 | 130 |  |  |  |  |  | Grand Total | 840
 | 2025-01-01 00:00:00 | 140
 | 2025-02-01 00:00:00 | 150
Spreadsheet: 826711d1682186054-nested-if-to-pull-most-recent-dates-attendance-tracker-4-22-23-sample
Sheet: Master Roster

ID# | Employee ID | Associate Name | Department | Supervisor | DOH | Active (Y/N) | FT/PT | WLB Hours
111114 | 765 | Albon, Alex | Alliance A Pick | Siharath, Anand | 2022-07-13 00:00:00 | Y | FT
999999 | 98 | [NAME], [NAME] | Alliance B Pick | [NAME], Charles | 2022-01-09 00:00:00 | Y | FT
111111 | 123 | Bottas, Valtteri | Alliance A Pick | Siharath, Anand | 2022-01-01 00:00:00 | Y | FT
888888 | 890 | DeVries, [NAME] | Alliance B Pick | Zurkirchen, [NAME] | 2019-09-17 00:00:00 | Y | PT
111121 | 357 | Gasly, [NAME] | Alliance PackOut | Grammer-Barns, A. | 2022-01-19 00:00:00 | Y | FT
333333 | 345 | [NAME], [NAME] | Alliance PackOut | Grammer-Barns, A. | 2020-04-15 00:00:00 | Y | FT
111116 | 543 | Hulkenberg, Nico | Alliance A Pick | [NAME], [NAME] | 2022-01-14 00:00:00 | Y | FT
111117 | 423 | LeClerc, [NAME] | Alliance PackOut | [NAME], [NAME] | 2022-01-15 00:00:00 | Y | FT
111115 | 654 | Magnussen, [NAME] | Alliance PackOut | Grammer-Barns, A. | 2022-12-04 00:00:00 | Y | FT
555555 | 567 | Norris, Lando | Alliance PackOut | Grammer-Barns, A. | 2022-10-05 00:00:00 | Y | FT
111122 | 468 | Ocon, Esteban | Alliance B Pick | [NAME], Charles | 2023-03-01 00:00:00 | Y | FT
111120 | 246 | Perez, Sergio | Alliance Replenishment | Grammer-Barns, A. | 2022-01-18 00:00:00 | Y | FT
666666 | 678 | [NAME], [NAME] | Alliance PackOut | [NAME], [NAME] | 2022-01-06 00:00:00 | Y | PT
444444 | 456 | Russel, George | Alliance A Pick | [NAME], [NAME] | 2022-01-04 00:00:00 | Y | FT
111118 | 321 | Sainz, [NAME] | Alliance A Pick | Siharath, Anand | 2016-09-25 00:00:00 | Y | FT
111113 | 867 | Sargeant, Logan | Alliance PackOut | Grammer-Barns, A. | 2023-02-15 00:00:00 | Y | PT
111112 | 978 | Stroll, Lance | Alliance PackOut | Grammer-Barns, A. | 2022-01-10 00:00:00 | Y | FT
777777 | 789 | Tsunoda, [NAME] | Alliance B Pick | Zurkirchen, [NAME] | 2022-01-07 00:00:00 | Y | FT
111123 | 579 | Valdes, Mario | Supply Chain | [NAME], [NAME] | 2009-06-29 00:00:00 | Y | FT
111119 | 135 | Verstappen, [NAME] | Alliance A Pick | [NAME], [NAME] | 2023-02-01 00:00:00 | Y | FT
222222 | 234 | [NAME], [NAME] | Alliance A Pick | [NAME], [NAME] | 2022-01-02 00:00:00 | Y | FT
Spreadsheet: 791106d1660153983-sliding-scale-formula-correction-sample
Sheet: Commissions Example

 | Commission Table
 | Sales Tiers | [NAME] | [NAME]
 | $0-$50,000 | 0 | 0.05
 |  | 50001 | 0.07
 |  | 100001 | 0.1
 |  | 150001 | 0.15
 |  | Sales Amount | [NAME]
 | Lookup Value-> | 55000
Spreadsheet: 872077d1718435428-unable-to-place-sum-at-the-end-of-dynamically-filtered-data-test
Sheet: Salary

Name | Amount |  |  |  |  |  | Name | Asid
Asid | 21437
Pradeep | 10010 |  |  |  |  |  |  | 10076
[NAME] | 22589 |  |  |  |  |  |  | 21247
Ajay | 12437 |  |  |  |  |  |  | 17065
Ravi | 16626 |  |  |  |  |  |  | 23027
[NAME] | 14859 |  |  |  |  |  |  | 24094
Vayu | 18354 |  |  |  |  |  |  | 10272
Asid | 10076 |  |  |  |  |  |  | 21670
Asid | 21247 |  |  |  |  |  |  | 13338
Asid | 17065 |  |  |  |  |  |  | 15831
Asid | 23027
Asid | 24094
Asid | 10272
Asid | 21670
Asid | 13338
Vayu | 21313
Naveen | 16958
Kashi | 17607
[NAME] | 17907
Vayu | 14026
Naveen | 15526
Kashi | 23717
Asid | 15831
Pradeep | 12149
[NAME] | 23232
Ravi | 14018
[NAME] | 14558
Vayu | 14064
Naveen | 11145
Kashi | 22844
[NAME] | 10894
Vayu | 20262
Naveen | 20309
Spreadsheet: 764311d1642687222-large-function-does-not-appear-in-power-pivot-measures-slicer-question
Sheet: Original

Sites | Overdues | Period
Perth | 1 | Q1
Sydney | 5 | Q1
Barcelona | 7 | Q1
Madrid | 2 | Q1
[NAME] | 3 | Q1
Cartago | 4 | Q1
Nettetal | 8 | Q1
[NAME] | 9 | Q1
Perth | 2 | Q2
Sydney | 5 | Q2
Barcelona | 7 | Q2
Madrid | 9 | Q2
[NAME] | 8 | Q2
Cartago | 4 | Q2
Nettetal | 1 | Q2
[NAME] | 3 | Q2
Spreadsheet: 751807d1634328248-calculating-and-average-considering-a-less-than-parameter-on-a-different-column-example
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | B2C
 |  |  | CLIENT | COUNTRY | SALES REGION | AE | CHANNEL | TICKET | DISCOUNT% |  | COUNTRY | DISCOUNT
 |  |  | A | ARGENTINA | ARGENTINA | AE1 | B2C | 75 | -0.1830866807610994 |  | ARGENTINA
 |  |  | B | COLOMBIA | COLOMBIA | AE2 | MKP B2B | 400 | -0.2747152619589977 |  | CHILE
 |  |  | C | CHILE | CHILE | AE3 | B2C | 60 |  |  | PERU
 |  |  | D | ARGENTINA | ARGENTINA | AE4 | B2C | 400 | -0.2311977715877437 |  | COLOMBIA
 |  |  | E | COLOMBIA | COLOMBIA | AE5 | B2B | 0 | -0.7111713030746706 |  | MEXICO
 |  |  | F | PERU | PERU | AE6 | B2C | 550 | -0.6586054721977053
 |  |  | G | URUGUAY | ARGENTINA | AE7 | B2C | 200
 |  |  | H | COLOMBIA | COLOMBIA | AE8 | B2C | 120 | -0.07390862944162437
 |  |  | I | ARGENTINA | ARGENTINA | AE9 | B2C | 120
Spreadsheet: 3d0847c9-9bf4-4824-abe1-d0f0517aa012
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
ARBI | Test | ARBI | Acetylcholine Receptor ([NAME]) [NAME], Serum | ACh Receptor ([NAME]) Binding Ab | Radioimmunoassay (RIA) | Serum Gel Tube: SGT |  |  | 2 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 2 mL Forms: If not ordering electronically, submit a General Request Form (Supply T239) with the specimen. | 0.4 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	NA | < or =0.02 nmol/L | Monday through Thursday; 6 p.m., Saturday; 10 a.m. | 3 days | 6 days | 1 | 83519 |  |  |  |  | Rochester
ARBI | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
ARBI | Result | 8338 | ACh Receptor ([NAME]) Binding Ab | ACh Receptor ([NAME]) Binding Ab | Numeric |  |  |  |  | nmol/L |  |  |  |  |  |  |  |  |  | 11034-6 | Acetylcholine receptor binding Ab:SCnc:Pt:Ser:Qn:
Spreadsheet: 330402d1404739728-add-criteria-to-existing-formula-and-skip-blanks-if-criteria-not-met-and-move-to-next-cell-formula
Sheet: mASTER

Name | Outcome | Date | Percentage | Result
Mr [NAME] | Open | 01.02.14 | 70
Mr [NAME] | Disqualified | 01.02.14 | 70
Mr [NAME] | Qualified | 01.02.14 | 70
Mr Barnes | Disqualified | 01.02.14 | 70
Mr [NAME] | Open | 02.02.14 | 70
Mr [NAME] | Open | 02.02.14 | 90
Mr [NAME] | Qualified | 02.02.14 | 90
Mr [NAME] | Qualified | 04.02.14 | 50
Mr [NAME] | Disqualified | 04.02.14 | 30
Mr [NAME] | Qualified | 04.02.14 | 100
Mr [NAME] | Open | 06.02.14 | 100
Mr Barnes | Qualified | 06.02.14 | 70
Spreadsheet: 2433a614-7591-4279-941a-31b5f8cbe4d3
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
COCR | Test | COCR | Cockroach, IgE | Cockroach, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
COCR | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
COCR | Result | COCR | Cockroach, IgE | Cockroach, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 30170-5 | Periplaneta americana Ab.IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: 29913d1225160988-linking-to-external-workbooks-base
Sheet: Sheet1

 | 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
JANUARY | 24
FEBRUARY
[NAME]
APRIL
MAY
[NAME]
JULY
AUGUST
SEPTEMBER
OCTOBER
NOVEMBER
DECEMBER
Spreadsheet: 850525d1700870371-rearrange-according-to-sequencing-number-from-1-to-10-as-per-per-duration-categories-excel1
Sheet: Sheet2

Run | Duration | units | AEP | N | Rain(mm) | ARF | Hyd001 | Hyd002 | Hyd003 | Hyd004 | Hyd005 | Hyd006 | Hyd007
0 | 120 | min | BGD_ ae.10 | 1 | 0 | 1 | 374.712 | 89.1491 | 57.2639 | 160.739 | 5.6393 | 474.972 | 608.884
0 | 120 | min | BGD_ ae.10 | 10 | 0 | 1 | 186.39 | 60.3644 | 39.1271 | 91.6151 | 3.9085 | 211.58 | 306.782
0 | 120 | min | BGD_ ae.10 | 2 | 0 | 1 | 174.307 | 55.0453 | 33.6704 | 83.5808 | 3.3124 | 215.241 | 290.186
0 | 120 | min | BGD_ ae.10 | 3 | 0 | 1 | 105.199 | 32.1072 | 20.9159 | 43.8994 | 2.1087 | 34.2253 | 164.636
0 | 120 | min | BGD_ ae.10 | 4 | 0 | 1 | 201.421 | 51.1992 | 28.85 | 84.3565 | 2.8399 | 237.529 | 324.716
0 | 120 | min | BGD_ ae.10 | 5 | 0 | 1 | 351.898 | 90.8701 | 62.6863 | 152.496 | 6.1722 | 431.805 | 571.834
0 | 120 | min | BGD_ ae.10 | 6 | 0 | 1 | 233.652 | 45.1109 | 26.7565 | 78.5553 | 2.6736 | 318.056 | 356.334
0 | 120 | min | BGD_ ae.10 | 7 | 0 | 1 | 403.177 | 93.3632 | 58.5728 | 176.01 | 5.674 | 491.414 | 656.929
0 | 120 | min | BGD_ ae.10 | 8 | 0 | 1 | 179.223 | 43.361 | 24.9768 | 75.4071 | 2.5162 | 148.598 | 286.379
0 | 120 | min | BGD_ ae.10 | 9 | 0 | 1 | 189.52 | 60.4215 | 43.5109 | 86.5315 | 4.3484 | 237.979 | 287.386
0 | 144 | min | BGD_ ae.10 | 1 | 0 | 1 | 376.509 | 85.4405 | 49.4749 | 155.83 | 4.7738 | 475.02 | 607.098
0 | 144 | min | BGD_ ae.10 | 10 | 0 | 1 | 146.58 | 56.3474 | 40.4491 | 72.0733 | 4.0216 | 172.637 | 239.866
0 | 144 | min | BGD_ ae.10 | 2 | 0 | 1 | 160.896 | 41.0979 | 23.16 | 65.3909 | 2.2483 | 121.839 | 258.472
0 | 144 | min | BGD_ ae.10 | 3 | 0 | 1 | 103.378 | 29.1203 | 19.1372 | 44.2519 | 2.0125 | 31.8417 | 157.574
0 | 144 | min | BGD_ ae.10 | 4 | 0 | 1 | 196.263 | 49.8837 | 32.0543 | 84.957 | 3.2439 | 263.791 | 318.65
0 | 144 | min | BGD_ ae.10 | 5 | 0 | 1 | 334.263 | 78.9703 | 51.5975 | 137.606 | 5.1701 | 406.111 | 537.508
0 | 144 | min | BGD_ ae.10 | 6 | 0 | 1 | 399.872 | 90.5062 | 55.9197 | 171.2 | 5.4442 | 485.464 | 649.596
0 | 144 | min | BGD_ ae.10 | 7 | 0 | 1 | 365.109 | 121.168 | 76.3383 | 182.365 | 7.5868 | 455.305 | 614.146
0 | 144 | min | BGD_ ae.10 | 8 | 0 | 1 | 343.836 | 74.2129 | 51.965 | 122.588 | 5.1893 | 441.494 | 533.523
0 | 144 | min | BGD_ ae.10 | 9 | 0 | 1 | 239.544 | 53.641 | 30.6007 | 95.8651 | 2.9711 | 301.584 | 382.182
Spreadsheet: 133926d1324830382-conditional-formatting-book1_jaydeep-2-
Sheet: Sheet1

2011-10-09 00:00:00 | Jainsons International | 9360.7
2011-10-03 00:00:00 | Bajj Auto Finance inc. | 13059.3
2011-10-14 00:00:00 | Kirloskar Bro Ltd. | 5032.1
2011-10-09 00:00:00 | Carer Launcher inc | 14679.7
2011-10-01 00:00:00 | State Bank of Pat | 13995.4
2011-10-08 00:00:00 | Kon int Pvt Ltd | 5746.5
2011-10-23 00:00:00 | Century Aluminium works inc | 2856.7
2011-10-16 00:00:00 | Access & Sniper | 3662.4
2011-10-09 00:00:00 | Favourite love Investments Ltd. | 2978.1
2011-10-19 00:00:00 | LA Maionics | 2041.9
2011-10-19 00:00:00 | Link viscom inc | 4763.1
2011-10-01 00:00:00 | Apple Electrnics Pvt. Ltd. | 8377.4
2011-10-09 00:00:00 | Mail SaNav inc | 8164.7
Spreadsheet: 847003d1698113174-return-previous-friday-date-of-a-week-in-the-future-book1
Sheet: Sheet1

2023-11-06 00:00:00
Spreadsheet: 738873d1625307402-req-formula-for-vlookup-with-multiple-if-condition-vlookup_with_if
Sheet: Report

 | Ticktet No. | Created on | Closed (Expected Result)
 | AP512385 | 2021-06-01 00:00:00 | 2021-06-10 00:00:00 | [NAME] should check the result from Data Sheet in Column F, Column D & Column E Check the values first in Column F, if not found then in Column D and if not found then in Column E. If no values found in Column F, D & E, then blank
 | AP525664 | 2021-06-02 00:00:00 | 2021-06-05 00:00:00
 | AP533558 | 2021-06-02 00:00:00 | 2021-06-06 00:00:00
 | AP534652 | 2021-06-04 00:00:00 | 2021-06-11 00:00:00
 | AP545555 | 2021-06-10 00:00:00 | 2021-06-12 00:00:00
 | AP545586 | 2021-06-15 00:00:00