tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: b8de4bfd-ca3d-4f88-b2ea-a5f22b3dea68
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
PUPY | Test | PUPY | Purine and Pyrimidine Panel, [NAME] | Purine and Pyrimidine Panel, U | Liquid Chromatography-Tandem Mass Spectrometry (LC-MS/MS) | [NAME]: Urine |  |  | 3 | mL | Container/Tube: Plastic, 10-mL urine tube (Supply T068) [NAME]: 3 mL Collection Instructions: Collect a random urine specimen. Additional Information: Patient's age is required. Forms: 1.    1. New York Clients-Informed consent is required. Please document on the request form or electronic order that a copy is on file. An Informed Consent for Genetic Testing (Supply T576) is available in Special Instructions. 2.    2. If not ordering electronically, submit a Biochemical Genetics Request Form (Supply T439) with the specimen. | 1 mL | Hemolysis	NA Thawing	Warm reject; Cold OK Lipemia	NA Icterus	NA Other	NA | URACIL 0-2 years: < or =31 mmol/mol creatinine 3-5 years: < or =30 mmol/mol creatinine 6-11 years: < or =28 mmol/mol creatinine 12-17 years: < or =26 mmol/mol creatinine > or =18 years: < or =35 mmol/mol creatinine  URIC ACID 0-2 years: < or =2,249 mmol/mol creatinine 3-5 years: < or =1,900 mmol/mol creatinine 6-11 years: < or =1,398 mmol/mol creatinine 12-17 years: < or =698 mmol/mol creatinine > or =18 years: < or =669 mmol/mol creatinine  HYPOXANTHINE 0-2 years: <53 mmol/mol creatinine 3-5 years: <49 mmol/mol creatinine 6-11 years: <43 mmol/[NAME] 12-17 years: <36 mmol/mol creatinine > or =18 years: <40 mmol/[NAME]  XANTHINE 0-2 years: <49 mmol/mol creatinine 3-5 years: <41 mmol/mol creatinine 6-11 years: <30 mmol/[NAME] 12-17 years: <16 mmol/mol creatinine > or =18 years: <51 mmol/mol creatinine | Tuesday; 8 a.m. | 7 days | 14 days | 1 | 83789 |  |  |  |  | Rochester
PUPY | [NAME] | URINE | [NAME] |  |  |  | Frozen | 7 days
PUPY | Result | 81420 | Uracil | Uracil | Numeric |  |  |  |  | mmol/mol Cr |  |  |  |  |  |  |  |  |  | 25140-5 | Uracil/Creatinine:SRto:Pt:[NAME]:Qn:
PUPY | Result | 6813 | Uric Acid | Uric Acid | Numeric |  |  |  |  | mmol/mol Cr |  |  |  |  |  |  |  |  |  | 34385-5 | Urate/Creatinine:SRto:Pt:[NAME]:Qn:
PUPY | Result | 6814 | Hypoxanthine | Hypoxanthine | Numeric |  |  |  |  | mmol/mol Cr |  |  |  |  |  |  |  |  |  | 38366-1 | Hypoxanthine/Creatinine:SRto:Pt:[NAME]:Qn:
PUPY | Result | 6815 | Xanthine | Xanthine | Numeric |  |  |  |  | mmol/mol Cr |  |  |  |  |  |  |  |  |  | 38371-1 | Xanthine/Creatinine:SRto:Pt:[NAME]:Qn:
PUPY | Result | 6816 | Comment | Comment | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 48767-8 | Annotation comment:Imp:Pt:{system}:Nar:
Spreadsheet: 781223d1653065898-using-multiple-columns-to-match-against-a-list-then-multiply-toppingsexcelcostdiff
Sheet: Topping Sales

 |  |  |  |  |  |  |  | Column1 | Column2 | Column3 | <----Difference for total
 |  |  |  |  |  |  |  | Pepperoni | Pizza | 0.09819622811551414
 |  |  |  |  |  |  |  | Soft | Tacos | 0.05595066264269842
 |  |  |  |  |  |  |  | Supreme | Pizza | 0.08367919345821992
 |  |  |  |  |  |  |  | Hard | Tacos | 0.1160930131018405
 |  |  |  |  |  |  |  | Cheese | Pizza | 0.02433348940819248
 |  |  |  |  |  |  |  | Three Cheese | Pizza | 0.02438444082033359
 |  |  |  |  |  |  |  | Soft | Tacos | 0.1642494294338514 |  |  | Goal (Sample)
Type | Topping | Cost | Diff | Newtotal |  |  |  | Chicken | Pizza | 0.03819555353306163 |  |  | Type | Topping | Cost | Diff | Newtotal
Pizza | Pepperoni | 20 |  |  |  |  |  |  |  |  |  |  | Pizza | Pepperoni | 20
Tacos | Soft | 15 |  |  |  |  |  |  |  |  |  |  | Tacos | Soft | 15
Pizza | Supreme | 33 |  |  |  |  |  | Type | Topping | Cost | NewCost |  | Pizza | Supreme | 33
Tacos | Hard | 65 |  |  |  |  |  | Pizza | Cheese | 77 | 78.9 |  | Tacos | Hard | 65
Pizza | Cheese | 77 |  |  |  |  |  | Pizza | Chicken | 120 | 124.6 |  | Pizza | Cheese | 77
Pizza | Three Cheese | 80 |  |  |  |  |  | Pizza | Pepperoni | 20 | 22 |  | Pizza | Three Cheese | 80
Tacos | Soft | 95 |  |  |  |  |  | Pizza | Supreme | 33 | 35.8 |  | Tacos | Soft | 95
Pizza | Chicken | 120 |  |  |  |  |  | Pizza | Three Cheese | 80 | 82 |  | Pizza | Chicken | 120
 |  |  |  |  |  |  |  | Tacos | Hard | 65 | 72.5
 |  |  |  |  |  |  |  | Tacos | Soft | 95 | 110.6
 |  |  |  |  |  |  |  | Tacos | Soft | 15 | 15.8
 |  |  |  |  |  |  |  | Tacos | Soft | 15 | 17.5
 |  |  |  |  |  |  |  | Tacos | Soft | 95 | 100.3
Spreadsheet: gerald_nemec__11391__CostEstimateCarbonBlack
Sheet: Contact List

ENA TECHNICAL SERVICES
PROJECT COST ESTIMATE
 | CUSTOMER COMPANY NAME:
 | PROJECT NAME:
 | W.O. NUMBER:
 | PROJECT ENGINEER: |  |  | FILE NAME:
 | REVISION NUMBER:
 | PLANNER / MARKETER:
PROJECT CONTACT LIST
 | Name | Title | Office | Pager | Mobile
 | [NAME] | ENA Project Engineer | (713)853-5470 | (877)326-0099 | (713)569-0969
 | [NAME] | ENA Construction Manager | (713)853-5581 | (281)490-6549 | (713)818-4075
 | [NAME] | ENA Special Project Team Leader | (713)853-2245 | (800)632-5193 | (713)705-6654
 | T.A. Mills | HMS Foreman | (281)652-2562 | (409)755-9433 | (409)656-4467
 | [NAME] | HMS Division Measurement Engineer | (281)652-2004 | (281)490-1790 | (713)805-0181
 | [NAME] | EOC Lumberton Team Member | (281)652-2559 | (409)755-5975 pin 083-4295 | (409)781-8590
 | [NAME] | EOC Environment | (281)652-2003 | [PHONE] | (713)907-5075
 | [NAME] | ENA Designer | (713)853-4834 | 2812629163
 | [NAME] | EOC Tech Ops Director | (281)652-2102 | 7136081022 | 7138188314
 | [NAME] | EOC Lumberton Team Advisor | 2814901484 | 7137050473 | 7137050473
 | [NAME] | ENA Facility Planner | (713)853-7813 | 8007055829
 | [NAME] | ENA Gas Control Director | (713)853-6448 | 8007167133 | 7132027839
 | [NAME] | ENA Engineering & Constr. Director | (713)853-9319 | (800)980-6628 pin 0968634 | 2813810990
 | [NAME] | ENA Deal Maker | (713)853-7513
 | [NAME] | Midcon Operations Coordinator | (409)843-4223 ext.225 | 4097265906 | 4097811404
cc: | [NAME]
 | [NAME]
 | T.A. Mills
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
Spreadsheet: 761947d1641310185-vlook-up-with-indirect-not-working-book1
Sheet: JANUARY 2021

 | [NAME] |  | Local Start/ Vac | QLIK % of Vacancies Filled EXCL. Withdrawn & Removed
SITE
[NAME] | 0.4736842105263158 |  | 1 | 1
Ealing | 1 |  | 1 | 1
Fulham | 0.95 |  | 0.95 | 0.95
Harlesden | 0.2631578947368421 |  | 1 | 1
[NAME] | 0.2962962962962963 |  | 1.6 | 1.6
[NAME] | 0 |  | 0 | 0
Hounslow | 1 |  | 1 | 1
Kingston | 0.75 |  | 0.9230769230769231 | 0.9230769230769231
[NAME] | 0 |  | 0 | 0
[NAME] | 0.6538461538461539 |  | 0.85 | 0.9444444444444444
Uxbridge | 0.75 |  | 1 | 1
WANDSWORTH | 0.6153846153846154 |  | 1.142857142857143 | 1.142857142857143
Wembley | 0.9393939393939394 |  | 0.96875 | 0.96875
Spreadsheet: 103297d1301054175-how-to-calculate-a-per-diem-between-dates-finances
Sheet: Sheet1

 | 2011-04-01 00:00:00 | 2011-04-02 00:00:00 | 2011-04-03 00:00:00 | 2011-04-04 00:00:00 | 2011-04-05 00:00:00 | 2011-04-06 00:00:00 | 2011-04-07 00:00:00 | 2011-04-08 00:00:00 | 2011-04-09 00:00:00 | 2011-04-10 00:00:00 | 2011-04-11 00:00:00 | 2011-04-12 00:00:00 | 2011-04-13 00:00:00 | 2011-04-14 00:00:00 | 2011-04-15 00:00:00 | 2011-04-16 00:00:00 | 2011-04-17 00:00:00 | 2011-04-18 00:00:00 | 2011-04-19 00:00:00 | 2011-04-20 00:00:00 | 2011-04-21 00:00:00 | 2011-04-22 00:00:00 | 2011-04-23 00:00:00 | 2011-04-24 00:00:00 | 2011-04-25 00:00:00 | 2011-04-26 00:00:00 | 2011-04-27 00:00:00 | 2011-04-28 00:00:00 | 2011-04-29 00:00:00 | 2011-04-30 00:00:00 | 2011-05-01 00:00:00 | 2011-05-02 00:00:00 | 2011-05-03 00:00:00 | 2011-05-04 00:00:00 | 2011-05-05 00:00:00 | 2011-05-06 00:00:00 | 2011-05-07 00:00:00 | 2011-05-08 00:00:00 | 2011-05-09 00:00:00 | 2011-05-10 00:00:00 | 2011-05-11 00:00:00 | 2011-05-12 00:00:00 | 2011-05-13 00:00:00 | 2011-05-14 00:00:00 | 2011-05-15 00:00:00 | 2011-05-16 00:00:00 | 2011-05-17 00:00:00 | 2011-05-18 00:00:00 | 2011-05-19 00:00:00 | 2011-05-20 00:00:00 | 2011-05-21 00:00:00 | 2011-05-22 00:00:00 | 2011-05-23 00:00:00 | 2011-05-24 00:00:00 | 2011-05-25 00:00:00 | 2011-05-26 00:00:00 | 2011-05-27 00:00:00 | 2011-05-28 00:00:00 | 2011-05-29 00:00:00 | 2011-05-30 00:00:00 | 2011-05-31 00:00:00 | 2011-06-01 00:00:00 | 2011-06-02 00:00:00 | 2011-06-03 00:00:00 | 2011-06-04 00:00:00 | 2011-06-05 00:00:00 | 2011-06-06 00:00:00 | 2011-06-07 00:00:00 | 2011-06-08 00:00:00 | 2011-06-09 00:00:00 | 2011-06-10 00:00:00 | 2011-06-11 00:00:00 | 2011-06-12 00:00:00 | 2011-06-13 00:00:00 | 2011-06-14 00:00:00 | 2011-06-15 00:00:00 | 2011-06-16 00:00:00 | 2011-06-17 00:00:00 | 2011-06-18 00:00:00 | 2011-06-19 00:00:00 | 2011-06-20 00:00:00 | 2011-06-21 00:00:00 | 2011-06-22 00:00:00 | 2011-06-23 00:00:00 | 2011-06-24 00:00:00 | 2011-06-25 00:00:00 | 2011-06-26 00:00:00 | 2011-06-27 00:00:00 | 2011-06-28 00:00:00 | 2011-06-29 00:00:00 | 2011-06-30 00:00:00 | 2011-07-01 00:00:00 | 2011-07-02 00:00:00 | 2011-07-03 00:00:00 | 2011-07-04 00:00:00 | 2011-07-05 00:00:00 | 2011-07-06 00:00:00 | 2011-07-07 00:00:00
Income | 2230
Daily Expense
Total
Per Diem
Spreadsheet: 735129d1622712520-random-number-generator-unique-number-generator
Sheet: Sheet1

Odds |  |  | Probability |  |  |  | # | Race 1 |  |  | Random Event Outcome |  |  |  |  | Random Event Outcome
# | event 1 |  | # | event 1 | Accum |  | 1 |  |  |  | Race 1 |  |  |  |  | Race 1
1 | 5.5 |  | 1 |  |  |  |  |  |  | Simulation # | 1st | 2nd | 3rd |  | Simulation # | 1st | 2nd | 3rd
 | 13
 | 11
 | 51
 | 18
 | 1.8
 | 3.2
% |  |  | Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NEED TO SIMULATE 1ST, THEN TAKE IT OUT AND READJUST % AND SIMULATE 2ND THEN 3RD.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HENCE DO NOT WANT ANY DOUBLE UP OF NUMBERS ABOVE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | After a unique set of 3 numbers generated having simulated say 10000 times
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Numbers generated are to be simulated say 10000 times
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Numbers generated are reflective of their probability. So theoretically #7 has 43 % drawn first.
Spreadsheet: 802208d1666705148-sumproduct-not-working-across-separate-workbooks-ref-issue-dashboard-example
Sheet: Sheet1

Daily | 2022-09-12 00:00:00 |  | Week Commencing | 2022-04-11 00:00:00 |  | Monthly | 2022-10-01 00:00:00 |  |  | YTD
INBOUND CALLS RECEIVED NWH'S |  |  | INBOUND CALLS RECEIVED NWH'S |  |  | INBOUND CALLS RECEIVED NWH'S |  |  |  | INBOUND CALLS RECEIVED NWH'S
INBOUND CALLS ANSWERED NWH's |  |  | INBOUND CALLS ANSWERED NWH's |  |  | INBOUND CALLS ANSWERED NWH's |  |  |  | INBOUND CALLS ANSWERED NWH's
AVERAGE CALL DURATION |  |  | AVERAGE CALL DURATION NWH's |  |  | AVERAGE CALL DURATION NWH's |  |  |  | AVERAGE CALL DURATION NWH's
% CALLS ANSWERED NWH's |  |  | % CALLS ANSWERED NWH's |  |  | % CALLS ANSWERED NWH's |  |  |  | % CALLS ANSWERED NWH's
% CALLS ABANDONED NWH's |  |  | % CALLS ABANDONED NWH's |  |  | % CALLS ABANDONED NWH's |  |  |  | % CALLS ABANDONED NWH's
INBOUND CALLS RECEIVED OOH'S |  |  | INBOUND CALLS RECEIVED OOH'S |  |  | INBOUND CALLS RECEIVED OOH'S |  |  |  | INBOUND CALLS RECEIVED OOH'S
INBOUND CALLS ANSWERED OOH's |  |  | INBOUND CALLS ANSWERED OOH's |  |  | INBOUND CALLS ANSWERED OOH's |  |  |  | INBOUND CALLS ANSWERED OOH's
AVERAGE CALL DURATION OOH's |  |  | AVERAGE CALL DURATION OOH's |  |  | AVERAGE CALL DURATION OOH's |  |  |  | AVERAGE CALL DURATION OOH's
% CALLS ANSWERED OOH's |  |  | % CALLS ANSWERED OOH's |  |  | % CALLS ANSWERED OOH's |  |  |  | % CALLS ANSWERED OOH's
% CALLS ABANDONED OOH's |  |  | % CALLS ABANDONED OOH's |  |  | % CALLS ABANDONED OOH's |  |  |  | % CALLS ABANDONED OOH's
TOTAL INBOUND CALLS RECEIVED |  |  | TOTAL INBOUND CALLS RECEIVED |  |  | TOTAL INBOUND CALLS RECEIVED |  |  |  | TOTAL INBOUND CALLS RECEIVED
TOTAL INBOUND CALLS ANWERED |  |  | TOTAL INBOUND CALLS ANWERED |  |  | TOTAL INBOUND CALLS ANWERED |  |  |  | TOTAL INBOUND CALLS ANWERED
TOTAL % CALLS ANSWERED |  |  | TOTAL % CALLS ANSWERED |  |  | TOTAL % CALLS ANSWERED |  |  |  | TOTAL % CALLS ANSWERED
TOTAL % CALLS ABANDONED |  |  | TOTAL % CALLS ABANDONED |  |  | TOTAL % CALLS ABANDONED |  |  |  | TOTAL % CALLS ABANDONED
Spreadsheet: 87902d1287761947-calculating-raise-example2
Sheet: Sheet4

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
 |  |  |  |  | Working Days | 21 | 22 | 21 | 21 | 20 | 21 | 21 | 20 | 23 | 21 | 21 | 22
 |  |  |  |  | Number for Month Raise | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 |  |  |  |  | Holidays | 1 |  | 1 |  | 2 | 2 |  |  |  |  | 1
 |  |  |  |  | Total Salary for Month
Current Salary/Year | 1st Raise % | 2nd Raise % | Month Hired | Month 1st raise is due | Month 2nd raise is due |  |  |  |  |  |  |  |  |  |  |  |  | Total |  | Raise %
 |  | 0 | 1
 |  |  | 1
 |  |  | 1
33000 | 0.1 |  | 1 | 6
30000 | 0.05 |  | 2
 |  |  | 1 | 1
 |  |  | 1
 |  |  | 1
42012 | 0 |  | 4 | 6
Spreadsheet: 127036d1320142086-count-uniquecountwithtwocriteria
Sheet: Sheet2

RMA Creation Date | Create Month
81618427 | 2007-01-03 00:00:00 | 2007-01-01 00:00:00 |  | 2007-01-01 00:00:00 | 2
81627046 | 2007-01-09 00:00:00 | 2007-01-01 00:00:00 |  | 2007-02-01 00:00:00 | 2
81627046 | 2007-01-09 00:00:00 | 2007-01-01 00:00:00 |  | 2007-03-01 00:00:00 | 1
81678586 | 2007-02-15 00:00:00 | 2007-02-01 00:00:00
81687626 | 2007-02-22 00:00:00 | 2007-02-01 00:00:00
81712509 | 2007-03-13 00:00:00 | 2007-03-01 00:00:00
81712509 | 2007-03-13 00:00:00 | 2007-03-01 00:00:00
Spreadsheet: 145875d1331790808-transfer-data-from-one-sheet-to-another-when-specific-value-entered-in-first-sheet-example_2012_file
Sheet: 2012

Invoiced | Jan | Feb | Mar | Apr | May | June | July | Aug | Sept | Oct | Nov | Dec | 2012 Total | Monthly Average
Jeanne
[NAME]
Karisa
[NAME]
[NAME]
Income
Received | Jan | Feb | Mar | Apr | May | June | July | Aug | Sept | Oct | Nov | Dec | 2012 Total | Monthly Average
Jeanne
[NAME]
Karisa
[NAME]
[NAME]
Income
Tithing
Paid
Due
Spreadsheet: 2451a68f-040d-4b2a-a364-e08539d2c632
Sheet: Sheet1

Plasmid | Characteristics | Source/Reference
pUC19 | High copy number E. coli plasmid cloning vector Apr | [9]
pACYC184 | Cloning vector containing the p15A origin of replication Cmr, Tcr | [10]
pWH1012gfp+ | pBR322 derivative containing gfp+ gene | [11]
pDS132 | Derived from pCVD442, without IS1 sequences, bla gene replaced by the cat gene | [12]
pBADlred | Plasmid expressing the phage lambda genes exo, bet and gam | [13]
pAJG300 | PCR product of SL1344 ydgA,malX genes cloned as an EcoRI-BamHI fragment into similarly digested pUC19, Apr | This study
pAJG301 | PCR product of SL1344 rpsM promoter cloned as an BamHI-XbaI fragment into similarly digested pAJG300, Apr | This study
pAJG303 | gfp+ from pWH1012gfp+ cloned as an NheI-PstI fragment into similarly digested pAJG301, Apr | This study
[NAME] | PCR product of SL1344 malY,add genes cloned as an PstI-SphI fragment into similarly digested pAJG303, Apr | This study
pAJG315 | ydgA,malX,rpsM,[NAME],add genes from [NAME] cloned into pDS132 as an XbaI fragment, Cmr | This study
Spreadsheet: 869850d1716394131-auto-calculate-daily-income-from-a-list-example-7-
Sheet: Sheet2

 |  |  |  |  |  |  |  |  |  |  |  |  | Week Number | Week beginning Date | Weekly Total | Daily
 |  | Income |  |  |  |  | Expenses |  |  |  |  |  | Week 21 | 2024-05-20 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | Week 22
 |  | Date | Amount | What For? | Payment Method |  | Date | Amount | What For? | Payment Method |  |  | Week 23
 |  | 2024-05-20 00:00:00 | 85 |  | Cash |  | 2024-05-21 00:00:00 | 80 |  | Cash |  |  | Week 24
 |  | 2024-05-21 00:00:00 | 146 |  | Bank Transfer |  | 2024-05-21 00:00:00 | 171.83 |  | Bank Transfer |  |  | Week 25
 |  | 2024-05-21 00:00:00 | 35 |  | Cash |  | 2024-05-22 00:00:00 | 30 |  | Cash |  |  | Week 26
 |  | 2024-05-22 00:00:00 | 160 |  | Card |  | 2024-05-22 00:00:00 | 70 |  | Cash |  |  | Week 27
 |  | 2024-05-22 00:00:00 | 92 |  | Cash |  | 2024-05-22 00:00:00 | 17 |  | Bank Transfer |  |  | Week 28
 |  | 2024-05-22 00:00:00 | 65 |  | Cash |  | 2024-05-22 00:00:00 | 14.39 |  | Bank Transfer |  |  | Week 29
 |  | 2024-05-22 00:00:00 | 124.7 |  | Bank Transfer |  |  |  |  |  |  |  | Week 30
 |  | 2024-05-27 00:00:00 | 199 |  | Card |  |  |  |  |  |  |  | Week 31
 |  | 2024-05-28 00:00:00 | 20 |  | Card |  |  |  |  |  |  |  | Week 32
 |  | 2024-05-29 00:00:00 | 200 |  | Card |  |  |  |  |  |  |  | Week 33
 |  |  |  |  |  |  |  |  |  |  |  |  | Week 34
 |  |  |  |  |  |  |  |  |  |  |  |  | Week 35
 |  |  |  |  |  |  |  |  |  |  |  |  | Week 36
 |  |  |  |  |  |  |  |  |  |  |  |  | Week 37
 |  |  |  |  |  |  |  |  |  |  |  |  | Week 38
 |  |  |  |  |  |  |  |  |  |  |  |  | Week 39
 |  |  |  |  |  |  |  |  |  |  |  |  | Week 40
 |  |  |  |  |  |  |  |  |  |  |  |  | Week 41
 |  |  |  |  |  |  |  |  |  |  |  |  | Week 42
 |  |  |  |  |  |  |  |  |  |  |  |  | Week 43
 |  |  |  |  |  |  |  |  |  |  |  |  | Week 44
 |  |  |  |  |  |  |  |  |  |  |  |  | Week 45
 |  |  |  |  |  |  |  |  |  |  |  |  | Week 46
 |  |  |  |  |  |  |  |  |  |  |  |  | Week 47
 |  |  |  |  |  |  |  |  |  |  |  |  | Week 48
 |  |  |  |  |  |  |  |  |  |  |  |  | Week 49
 |  |  |  |  |  |  |  |  |  |  |  |  | Week 50
 |  |  |  |  |  |  |  |  |  |  |  |  | Week 51
 |  |  |  |  |  |  |  |  |  |  |  |  | Week 52
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
 |  | Total |  |  |  |  | Total
 |  |  |  |  | Running Total
Spreadsheet: 104259d1301916997-simple-sumproduct-help-i-think-sumpr_help
Sheet: Lookup

 | TEST1 |  |  | TST1 |  |  | TEST2 |  |  | TST2 |  |  | TEST3 |  |  | TST3 |  |  | TEST4 |  |  | TST4
 | + | D | PM | - | BAL |  | + | D | PM | - | BAL |  | + | D | PM | - | BAL |  | + | D | PM | - | BAL
2010-10-31 00:00:00 | 92943 |  |  |  |  |  | 1938 |  |  |  |  |  | 0 |  |  |  |  |  | 39611
 |  |  |  | 2624 |  |  |  |  |  | 323 |  |  |  |  |  |  |  |  |  |  |  | 8812
 |  |  |  | 2432 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7577
 |  |  |  | 9308 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4657
 |  |  |  | 2044 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2971
 |  |  |  | 4594 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1328
 |  |  |  | 9473 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2725
 |  |  |  | 1544 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 269
 |  |  |  | 9953 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1365
 |  |  |  | 10089 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 821
 |  |  |  | 5154 |  |  |  |  |  |  |  |  | 95295 | 2.43 | 2010-11-01 00:00:00 |  |  |  |  |  |  | 637
 |  |  |  | 1955 |  |  |  |  |  |  |  |  |  |  |  | 7605 |  |  |  |  |  | 366
 |  |  |  | 1194 |  |  |  |  |  |  |  |  |  |  |  | 3374 |  |  |  |  |  | 859
 |  |  |  | 3180 |  |  |  |  |  |  |  |  |  |  |  | 11614 |  |  |  |  |  | 176
 |  |  |  | 3141 |  |  |  |  |  |  |  |  |  |  |  | 1104 |  |  |  |  |  | 192
 |  |  |  | 691 |  |  |  |  |  |  |  |  |  |  |  | 2887 |  |  |  |  |  | 702
 |  |  |  |  |  |  | 52151 | 1.34 | 2010-12-01 00:00:00 |  |  |  |  |  |  | 9972 |  |  |  |  |  | 2189
 |  |  |  | 187 |  |  |  |  |  | 4302 |  |  |  |  |  | 1677 |  |  |  |  |  | 513
 |  |  |  | 73 |  |  |  |  |  | 1666 |  |  |  |  |  | 9960 |  |  |  |  |  | 2242
 |  |  |  | 170 |  |  |  |  |  | 3914 |  |  |  |  |  | 483 |  |  |  |  |  | 238
 |  |  |  | 6460 |  |  |  |  |  | 695 |  |  |  |  |  | 2345 |  |  |  |  |  | 42
 |  |  |  | 3634 |  |  |  |  |  | 3613 |  |  | 4934 | 2.3 | 2010-12-01 00:00:00 | 1667 |  |  |  |  |  | 219
 |  |  |  |  |  |  |  |  |  |  |  |  | 89708 | 2.3 | 2010-12-01 00:00:00
 |  |  |  | 1516 |  |  |  |  |  | 2234 |  |  |  |  |  | 8243 |  |  |  |  |  | 135
 |  |  |  | 827 |  |  |  |  |  | 4067 |  |  |  |  |  | 4055 |  |  |  |  |  | 246
 |  |  |  | 1665 |  |  |  |  |  | 236 |  |  |  |  |  | 11680 |  |  |  |  |  | 14
 |  |  |  | 180 |  |  |  |  |  | 3306 |  |  |  |  |  | 503 |  |  |  |  |  | 200
 |  |  |  | 53 |  |  |  |  |  | 1654 |  |  |  |  |  | 1453 |  |  |  |  |  | 168
 |  |  |  | 4410 |  |  |  |  |  | 279 |  |  |  |  |  | 9486 |  |  |  |  |  | 45
 |  |  |  |  |  |  |  |  |  | 1076 |  |  |  |  |  | 2054 |  |  |  |  |  | 173
 |  |  |  | 1168 |  |  |  |  |  | 845 |  |  |  |  |  | 4865 |  |  |  |  |  | 136
RAMB ADJ-NOV
Spreadsheet: 867367d1714196829-automatisation-of-the-consolidation-data-consolidation
Sheet: Sheet1

TTT333391100020 | 0 |  | TTT333391100020 | 0
TTT333391100020 | 0 |  | TTT333305201161 | 1
TTT333391100020 | 0 |  | TTT333356301413 | 5
TTT333305201161 | 0 |  | TTT333356401666 | 0
TTT333305201161 | 0 |  | TTT320509101666 | 0
TTT333305201161 | 1 |  | TTT333356201678 | 3
TTT333305201161 | 0
TTT333305201161 | 0
TTT333305201161 | 0
TTT333305201161 | 0
TTT333305201161 | 0
TTT333305201161 | 0
TTT333305201161 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 1
TTT333356301413 | 1
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 1
TTT333356301413 | 1
TTT333356301413 | 1
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT320509101666 | 0
TTT333356401666 | 0
TTT320509101666 | 0
TTT333356401666 | 0
TTT320509101666 | 0
TTT333356201678 | 1
TTT333356201678 | 1
TTT333356201678 | 1
TTT333356201678 | 0
TTT333356201678 | 0
TTT333356201678 | 0
TTT333356201678 | 0
TTT333356201678 | 0
TTT333356201678 | 0
TTT333356201678 | 0
TTT333356201678 | 0
TTT333356201678 | 0
TTT333356201678 | 0
Spreadsheet: 270140d1381398968-combining-two-excel-formulas-sample
Sheet: Sheet1

Formula A
[NAME]
Date | Project e.g. HFI | Task Number | CR/INFRA number | Task Description | CR Client | Assigned to | [NAME] (QA) | Expected Delivery from Dev to QA (i.e. [NAME] plus 1 day) | QA Target Completion Date (from Dev Plan QA Finish Date) to meet planned delivery deadline PRIORITY | "R" Ready for Testing | Task Status
2009-09-29 00:00:00 | IF Only |  | CR1954 |  |  |  |  |  |  | R | P
2009-04-13 00:00:00 |  |  | INT006 |  |  |  |  |  |  | R | ON HOLD
2010-02-01 00:00:00 | IF Only |  | INT016 |  |  |  |  |  |  |  | P
2010-02-01 00:00:00 | IF only |  | INT019 |  |  |  |  |  |  | R | ON HOLD
 | IF |  | INT062 |  |  |  |  |  |  |  | P
2010-06-22 00:00:00 | WS |  | INT062 |  |  |  |  |  |  | R | P
2011-01-10 00:00:00 | BO |  | INT062 |  |  |  |  |  |  | R | P
2010-10-04 00:00:00 | BO/IF |  | INT062 |  |  |  |  |  |  |  | P
2009-10-13 00:00:00 | ENC | Encore | ENC0013 |  |  |  |  |  |  | R
2009-11-12 00:00:00 | ENC | Encore | ENC0010 |  |  |  |  |  |  |  | P
2009-11-12 00:00:00 | ENC |  | ENC0012 |  |  |  |  |  |  | ? See comments
2011-08-01 00:00:00 | BO/IF |  | R172233 |  |  |  |  |  |  | R | P
2011-10-13 00:00:00 | WS |  | LSR-INT-030 |  |  |  |  |  |  |  | P
2012-01-17 00:00:00 |  |  | CR160 |  |  |  |  |  |  |  | P
2012-02-08 00:00:00 | IF |  | CR160 |  |  |  |  |  |  |  | P
2012-03-16 00:00:00 |  |  | CR160 |  |  |  |  |  |  |  | P