tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 818360d1676765147-excel-formula-client-profiles-copy-tms
Sheet: Client Profile (Before)

Client: | Client 3 |  | Business Description:
Location:
Key People: |  | Shareholder | 81
 | [NAME] | Shareholder | 19
 | Mark | General Manager
Spreadsheet: 202164d1356372351-automatic-copy-cell-to-another-sheet-if-populated-rehospitalization-tracking-1-
Sheet: November 2012

Client | Facility | Date | Meeting Attendance | Was follow-up appointment made/kept per standard? | Was [NAME] used per standard? | Was follow-up phone call made per standard? | Audit Tool Used | Readmit Avoidable? | If avoidable, did non-compliance with standards contribute? | Action Items | Notes:
ab | HC | 2012-11-20 00:00:00 | yes | yes | no | n/a | yes | no
bc | PH | 2012-11-20 00:00:00 | yes | yes | yes | yes | yes | no
gh | Sanctuary | 2012-11-20 00:00:00 | yes | no | no | no | no | yes
kf | PH | 2012-11-20 00:00:00 | yes | yes | yes | yes | yes | no
ot | PM | 2012-11-20 00:00:00 | yes | yes | yes | yes | yes | no
Spreadsheet: 55182d1255353070-how-to-automatically-alter-formula-when-filters-are-applied-malchemist-2
Sheet: 31523

Date of Order | Date of Order | Year Of Order | Month Of Order | Item No. | Description | Quantity | [NAME] value £ | Order Number | Contract
20080319 | 2008-03-19 | 2008 | 3 | 228673 | Cordless rotary hammer TE 6-A | 1 | 185.93 | 124538 | 31523
20080319 | 2008-03-19 | 2008 | 3 | 272444 | Battery charger C 4/36-ACS Li TPS 230V | 1 | 77.5499999999999 | 124538 | 31523
20080319 | 2008-03-19 | 2008 | 3 | 272471 | Battery pack B 36 2.4 Li-Ion | 1 | 130.59 | 124538 | 31523
20080319 | 2008-03-19 | 2008 | 3 | 272471 | Battery pack B 36 2.4 Li-Ion | 1 | 130.59 | 124538 | 31523
Spreadsheet: 845431d1696954405-excel-2016-list-first-and-second-monday-of-each-month-list1st-and-2ndmondayeachmonth
Sheet: Sheet1

1st Day Of Year: |  |  | Holidays |  | First and second Monday of each month excluding Holidays
2023-01-01 00:00:00 |  |  | 2023-01-02 00:00:00
 |  |  | 2023-01-16 00:00:00 |  | 2023-01-23 00:00:00
 |  |  | 2023-05-29 00:00:00 |  | 2023-02-06 00:00:00
 |  |  | 2023-06-19 00:00:00 |  | 2023-02-13 00:00:00
 |  |  | 2023-07-04 00:00:00 |  | 2023-03-06 00:00:00
 |  |  | 2023-09-04 00:00:00 |  | 2023-03-13 00:00:00
 |  |  | 2023-11-23 00:00:00 |  | 2023-04-03 00:00:00
 |  |  | 2023-11-24 00:00:00 |  | 2023-04-10 00:00:00
 |  |  | 2023-12-25 00:00:00 |  | 2023-05-01 00:00:00
 |  |  | 2023-12-26 00:00:00 |  | 2023-05-08 00:00:00
 |  |  | 2023-12-27 00:00:00 |  | 2023-06-05 00:00:00
 |  |  | 2023-12-28 00:00:00 |  | 2023-06-12 00:00:00
 |  |  | 2023-12-29 00:00:00 |  | 2023-07-03 00:00:00
 |  |  |  |  | 2023-07-10 00:00:00
 |  |  |  |  | 2023-08-07 00:00:00
 |  |  |  |  | 2023-08-14 00:00:00
 |  |  |  |  | 2023-09-11 00:00:00
 |  |  |  |  | 2023-09-18 00:00:00
 |  |  |  |  | 2023-10-02 00:00:00
 |  |  |  |  | 2023-10-09 00:00:00
 |  |  |  |  | 2023-11-06 00:00:00
 |  |  |  |  | 2023-11-13 00:00:00
 |  |  |  |  | 2023-12-04 00:00:00
 |  |  |  |  | 2023-12-11 00:00:00
Spreadsheet: 814715d1674561961-find-values-according-to-order-find-values-according-to-order
Sheet: Folha1

Cód. 0 | Cód. 1 | Cód. 5 | Cód. 5M | Cód. 51 | Cód. 51M | Cód. 6 | Cód. 6M | Cód. 61 | Cód. 61M | Cód. 63 | Cód. 64 | Cód. 64M | Cód. 8 | Cód. 8M | Cód. 81 | Cód. 82 | Cód. 1M | Cód. 2M | Cód. 01T | Cód. 2 | Cód. 1E | Cód. 2E | Cód. 22E | Cód. 82E | Cód. 81E | Cód. 31E | Cód. 65E | Sem Código | Sem Código
BRANCO | PRETO | AZUL P.288 | AZUL P.288 MATE | ICE BLUE | ICE BLUE MATE | VERMELHO P.485 | VERMELHO P.485 MATE | MAGENTA | MAGENTA MATE | VERMELHO METÁLICO | ROSA GOLD | ROSA GOLD MATE | LARANJA P.021 | LARANJA P.021 MATE | OURO P.871 | OURO METÁLICO | PRETO MATE | METALIZADO MATE | TRANSLUCIDO | METALIZADO | PRETO EMBOSSED | PRATA EMBOSSED CHINÊS | PRATA EMBOSSED NOSSO | OURO EMBOSSED NOSSO PINTADO | OURO EMBOSSED CHINÊS | VERDE EMBOSSED | ROSA EMBOSSED | [NAME] | Qtd. Total
124 | 1000 |  | 53753 | 12412 | 6 |  | 1563 | 7537 | 5754 | 75537 |  | 7537 |  |  |  |  |  |  |  |  |  |  |  |  | 7537 |  |  |  |  | (quantidade em unidades)
WHAT IS NEEDED |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | different formula
COR DO PRODUTO |  | 1st color found with qty |  | 2nd color found with qty |  |  |  | 3rd color found with qty |  |  | 4th color found with qty |  |  | 5th color found with qty |  |  | 6th color found with qty |  | 7th color found with qty |  |  |  |  |  | 8th color found with qty |  |  | 9th color found with qty |  | 10th color found with qty |  |  | 11th color found with qty
QUANTIDADE PEDIDA |  | 1000 |  | 124 |  |  |  | 12412 |  |  | 1563 |  |  | 6 |  |  | 7537 |  | 5754 |  |  |  |  |  | 75537 |  |  | 7537 |  | 53753 |  |  | 7537
RESULT:
COR DO PRODUTO |  | PRETO |  | BRANCO |  |  |  | ICE BLUE |  |  | VERMELHO P.485 MATE |  |  | ICE BLUE MATE |  |  | MAGENTA |  | MAGENTA MATE |  |  |  |  |  | VERMELHO METÁLICO |  |  | ROSA GOLD MATE |  | AZUL P.288 MATE |  |  | OURO EMBOSSED CHINÊS
QUANTIDADE PEDIDA |  | 1000 |  | 124 |  |  |  | 12412 |  |  | 1563 |  |  | 6 |  |  | 7537 |  | 5754 |  |  |  |  |  | 75537 |  |  | 7537 |  | 53753 |  |  | 7537
Spreadsheet: 82006d1282078943-show-all-occurrences-list-of-courses
Sheet: Course Offerings

Course Name | Location | Start Date
Generic Course 100 | Charlotte | 2010-08-18 00:00:00
Generic Course 100 | New York | 2010-06-06 00:00:00
Generic Course 100 | New York | 2010-01-05 00:00:00
Generic Course 101 | Charlotte | 2010-10-06 00:00:00
Generic Course 101 | Chicago | 2010-05-03 00:00:00
Generic Course 102 | Boston | 2010-10-28 00:00:00
Generic Course 102 | San Francisco | 2010-07-08 00:00:00
Generic Course 102 | Chicago | 2010-04-21 00:00:00
Generic Course 102 | Boston | 2010-03-09 00:00:00
Generic Course 103 | Charlotte | 2010-04-07 00:00:00
Generic Course 103 | New York | 2010-03-20 00:00:00
Generic Course 104 | Los Angeles | 2010-11-25 00:00:00
Generic Course 104 | Los Angeles | 2010-09-24 00:00:00
Generic Course 104 | Chicago | 2010-08-26 00:00:00
Generic Course 104 | San Francisco | 2010-07-15 00:00:00
Generic Course 104 | Chicago | 2010-07-14 00:00:00
Generic Course 104 | San Francisco | 2010-04-15 00:00:00
Generic Course 104 | New York | 2010-01-01 00:00:00
Generic Course 105 | Chicago | 2010-11-01 00:00:00
Generic Course 105 | San Francisco | 2010-09-25 00:00:00
Generic Course 105 | New York | 2010-08-20 00:00:00
Generic Course 105 | Charlotte | 2010-05-16 00:00:00
Generic Course 106 | Chicago | 2010-12-06 00:00:00
Generic Course 107 | San Francisco | 2010-09-10 00:00:00
Generic Course 107 | Los Angeles | 2010-05-07 00:00:00
Generic Course 107 | Boston | 2010-02-19 00:00:00
Generic Course 107 | New York | 2010-02-09 00:00:00
Generic Course 107 | Boston | 2010-01-10 00:00:00
Generic Course 107 | Chicago | 2010-01-07 00:00:00
Generic Course 108 | Charlotte | 2010-02-16 00:00:00
Generic Course 109 | Charlotte | 2010-12-23 00:00:00
Generic Course 109 | Charlotte | 2010-10-11 00:00:00
Generic Course 110 | San Francisco | 2010-10-22 00:00:00
Generic Course 110 | Charlotte | 2010-08-25 00:00:00
Generic Course 111 | New York | 2010-05-26 00:00:00
Generic Course 111 | Boston | 2010-01-21 00:00:00
Generic Course 112 | Los Angeles | 2010-11-04 00:00:00
Generic Course 113 | San Francisco | 2010-07-22 00:00:00
Generic Course 113 | Charlotte | 2010-04-13 00:00:00
Generic Course 114 | Los Angeles | 2010-12-14 00:00:00
Generic Course 114 | San Francisco | 2010-07-20 00:00:00
Generic Course 114 | Los Angeles | 2010-04-28 00:00:00
Generic Course 114 | New York | 2010-04-22 00:00:00
Generic Course 114 | San Francisco | 2010-04-12 00:00:00
Generic Course 115 | Charlotte | 2010-08-27 00:00:00
Generic Course 115 | Los Angeles | 2010-05-20 00:00:00
Generic Course 115 | New York | 2010-05-15 00:00:00
Generic Course 115 | Chicago | 2010-04-01 00:00:00
Generic Course 115 | New York | 2010-03-22 00:00:00
Spreadsheet: 886372d1736410371-populating-a-cell-based-on-multiple-possibilities-employee-training-plan-template
Sheet: 30 Day Training Plan (Training)

Employee Training Plan
Employee Name |  | Team |  | Hire Date
Training Topic/Task | Training Type | Training Hours | Expected Completion Date | Start Date | Actual Completion Date | Status | What this should say | Notes
[NAME] | CBT | 4 | 2025-01-15 00:00:00 | 2024-12-22 00:00:00 | 2024-12-30 00:00:00 |  | Completed |  |  |  |  |  | Completed
[NAME] | Hybrid | 12 | 2025-01-15 00:00:00 | 2024-12-24 00:00:00 |  |  | In Progress |  |  |  |  |  | In Progress
Org History | CBT | 1 | 2025-01-15 00:00:00 |  |  |  | Not Started |  |  |  |  |  | Not Started
PowerPoint for Beginners | CBT | 4 | 2024-11-30 00:00:00 |  |  |  | Not Started-Past Due |  |  |  |  |  | Not Started - PAST DUE
Benefits Overview | In Person | 1 | 2024-11-30 00:00:00 | 2024-12-10 00:00:00 |  |  | In Progress-past due |  |  |  |  |  | In Progress - PAST DUE
Payroll Training | In Person | 1 | 2024-11-30 00:00:00 | 2024-12-31 00:00:00 | 2024-12-31 00:00:00 |  | Completed-past due |  |  |  |  |  | Completed - PAST DUE
Spreadsheet: 30756e73-8437-48ce-bb7d-f90401ea469c
Sheet: Turfgrass InfoCtr

Turfgrass Information Center
2007-2008
 | 2007-07-01 00:00:00 | 2007-08-01 00:00:00 | 2007-09-01 00:00:00 | 2007-10-01 00:00:00 | 2007-11-01 00:00:00 | 2007-12-01 00:00:00 | 2008-01-01 00:00:00 | 2008-02-01 00:00:00 | 2008-03-01 00:00:00 | 2008-04-01 00:00:00 | 2008-05-01 00:00:00 | 2008-06-01 00:00:00 | Total | 2007-2008 Price | Price per search
Displayed result sets (i.e. searches) | 96 | 4 | 4 | 50 | 43 | 44 | 7 | 0 | 17 | 14 | 0 | 0 |  | 0 | N/A
COUNTER-Compliant?: | No
Spreadsheet: 808455d1670478832-two-running-balance-columns-with-conditions-running-balance-ans
Sheet: Sheet1

SSIS workgroup# | Name | Date | Amount | Description | Cash | [NAME]
 |  | 2022-12-01 00:00:00 | 0 |  | 30000 | 5000
10000567 | Spock | 2022-12-02 00:00:00 | 105.75 | Books
 | Chewbacca | 2022-12-17 00:00:00 | 175 | Transportation
 | Iron Man | 2022-12-21 00:00:00 | 25 | Books
 | [NAME] | 2022-12-22 00:00:00 | 60 | Phone
 | Thumbalina | 2022-12-23 00:00:00 | 500 | Transportation
 | [NAME] | 2022-12-05 00:00:00 | 10 | [NAME]
 | Merlin | 2022-12-05 00:00:00 | 100 | Clothing
 | Tinkerbell | 2022-12-05 00:00:00 | 50 | [NAME]
Spreadsheet: 214697d1361059227-automatically-convert-number-to-percentage-testing-workbook
Sheet: Sheet1

Rating: 1=poor – 5=excellent |  |  |  |  | 1 | 2 | 3 | 4 | 5 | No of Students
The training has given me new knowledge, understanding and/or skills |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 25 |  | all I am after is to be able to enter a number in any highlighted cell and the number be converted into a Percentage relevant to the total no of students  So if I enter 12.5 in cell H3 it automatically shows 50%  Thanks for any help
The training covered everything I had expected it to |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 25
The training has improved my transferable skills |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 25
(Maths, English, Communication, Confidence) |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 25
I will use the new learning, skills, ideas and knowledge |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 25
I believe that the new learning, skills and knowledge I have will improve my performance at work or help me with finding employment |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 25
I feel that the course was conducted well (e.g. engaging form of training delivery, length of course, professionalism of trainers, good venue) |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 25
Spreadsheet: 866744d1713631398-formula-for-preparing-rotating-roster-rota
Sheet: Mac

Date | Shift 1 | Shift 2 | Shift 3
2024-01-01 00:00:00 | [EMAIL] [EMAIL] [EMAIL] [EMAIL] | [EMAIL] [EMAIL] [EMAIL] [EMAIL] [EMAIL] [EMAIL] [EMAIL] [EMAIL] [EMAIL] | [EMAIL] [EMAIL]
2024-01-02 00:00:00
2024-01-03 00:00:00
2024-01-04 00:00:00
2024-01-05 00:00:00
2024-01-06 00:00:00
2024-01-07 00:00:00
2024-01-08 00:00:00
2024-01-09 00:00:00
2024-01-10 00:00:00
2024-01-11 00:00:00
2024-01-12 00:00:00
2024-01-13 00:00:00
2024-01-14 00:00:00
2024-01-15 00:00:00
2024-01-16 00:00:00
2024-01-17 00:00:00
2024-01-18 00:00:00
2024-01-19 00:00:00
2024-01-20 00:00:00
2024-01-21 00:00:00
2024-01-22 00:00:00
2024-01-23 00:00:00
2024-01-24 00:00:00
2024-01-25 00:00:00
2024-01-26 00:00:00
2024-01-27 00:00:00
2024-01-28 00:00:00
2024-01-29 00:00:00
2024-01-30 00:00:00
2024-01-31 00:00:00
Spreadsheet: 857848d1706719451-sum-hours-based-on-date-range-and-id-and-then-summarize-on-a-separate-tab-eot-sample-v2
Sheet: Stipends

PSID | Rcd | Name | CMS | TRN | Description | Fund | Dept | S/C | Acct | Amount
11111 | 0 | BERGMAN | PC8 | 8ST8 | Adv Post | 90000 | 43425 | 0 | 601934 | 450
11111 | 0 | BERGMAN | SX | 8ST9 | CRU | 90000 | 43425 | 0 | 601937 | 100
11111 | 0 | BERGMAN | SX | 8ST9 | Motor | 90000 | 43425 | 0 | 601937 | 200
11111 | 0 | BERGMAN | SX | 8ST9 | Range Master | 90000 | 43425 | 0 | 601937 | 100
33333 | 0 | CASILLAS | PC0 | 8ST0 | Post | 90000 | 43425 | 0 | 601934 | 200
33333 | 0 | CASILLAS | SX | 8ST9 | Crime Prevention | 90000 | 43425 | 0 | 601937 | 100
44444 | 0 | CEBALLOS | PC8 | 8ST8 | Adv Post | 90000 | 43425 | 0 | 601934 | 450
44444 | 0 | CEBALLOS | SX | 8ST9 | Community Relations | 90000 | 43425 | 0 | 601937 | 100
44444 | 0 | CEBALLOS | SX | 8ST9 | Detective | 90000 | 43425 | 0 | 601937 | 200
55555 | 0 | CORNELL | PC8 | 8ST8 | Adv Post | 90000 | 43425 | 0 | 601934 | 450
55555 | 0 | CORNELL | SX | 8ST9 | Crime Prevention | 90000 | 43425 | 0 | 601937 | 100
66666 | 0 | COSTA | PC8 | 8ST8 | Adv Post | 90000 | 43425 | 0 | 601934 | 450
66666 | 0 | COSTA | SX | 8ST9 | Community Relations | 90000 | 43425 | 0 | 601937 | 100
77777 | 0 | COUTO | PC8 | 8ST8 | Adv Post | 90000 | 43425 | 0 | 601934 | 450
77777 | 0 | COUTO | SX | 8ST9 | Range Master | 90000 | 43425 | 0 | 601937 | 100
88888 | 0 | EGGER | PC8 | 8ST8 | Adv Post | 90000 | 43425 | 0 | 601934 | 450
88888 | 0 | EGGER | SX | 8ST9 | Detective | 90000 | 43425 | 0 | 601937 | 200
99999 | 0 | FRAUSTO | PC8 | 8ST8 | Adv Post | 90000 | 43425 | 0 | 601934 | 450
Spreadsheet: 113378d1309295616-auto-populate-a-cell-when-3-options-are-selected-all-skus
Sheet: Shams - 1698

Product | P-Code | Size | S-Code | Color | C-Code |  | SKU
Shams & Decorative Pillows | 1698 | Euro | 7 | Ivory | 20 |  | 16980720
Shams & Decorative Pillows | 1698 | Euro | 7 | White | 21 |  | 16980721
Shams & Decorative Pillows | 1698 | Euro | 7 | Sage | 22 |  | 16980722
Shams & Decorative Pillows | 1698 | Euro | 7 | Blue | 30 |  | 16980730
Shams & Decorative Pillows | 1698 | Euro | 7 | [NAME] | 31 |  | 16980731
Shams & Decorative Pillows | 1698 | Euro | 7 | Plum | 32 |  | 16980732
Shams & Decorative Pillows | 1698 | Standard | 8 | Ivory | 20 |  | 16980820
Shams & Decorative Pillows | 1698 | Standard | 8 | White | 21 |  | 16980821
Shams & Decorative Pillows | 1698 | Standard | 8 | Sage | 22 |  | 16980822
Shams & Decorative Pillows | 1698 | Standard | 8 | Blue | 30 |  | 16980830
Shams & Decorative Pillows | 1698 | Standard | 8 | [NAME] | 31 |  | 16980831
Shams & Decorative Pillows | 1698 | Standard | 8 | Plum | 32 |  | 16980832
Shams & Decorative Pillows | 1698 | Decorative Pillows | 9 | Ivory | 20 |  | 16980920
Shams & Decorative Pillows | 1698 | Decorative Pillows | 9 | White | 21 |  | 16980921
Shams & Decorative Pillows | 1698 | Decorative Pillows | 9 | Sage | 22 |  | 16980922
Shams & Decorative Pillows | 1698 | Decorative Pillows | 9 | Blue | 30 |  | 16980930
Shams & Decorative Pillows | 1698 | Decorative Pillows | 9 | [NAME] | 31 |  | 16980931
Shams & Decorative Pillows | 1698 | Decorative Pillows | 9 | Plum | 32 |  | 16980932
Spreadsheet: 793379d1661437388-new-rolling-total-for-points-scored-in-last-3-games-rolling-total-for-points-gk-alternative
Sheet: Totals

Name 22 |  |  |  | 3
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Bethany
[NAME]
[NAME]
Nicki
Name 21
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Bethany
[NAME]
[NAME]
Nicki
Spreadsheet: 76558d1277117448-excel-2007-conditional-formating-other-ways-more-conditions-payroll-timetable-academic-1
Sheet: HOLIDAY FORMULA

BANK HOLIDAY CALULATIONS | DATE |  |  |  |  |  | OPERATORS
 |  |  |  |  |  |  | i2 | 9
CHRISTMAS DAY | 2010-12-27 00:00:00 |  |  |  |  |  | date | 2010-06-16 00:00:00
BOXING DAY | 2010-12-28 00:00:00 |  |  |  |  |  | year | 2010
NEW YEARS DAY | 2011-01-03 00:00:00
QUEENS DIAMOND JUBILEE | 2012-06-05 00:00:00 |  |  |  |  | month | day | date | eomonth
GOOD FRIDAY | 2010-04-02 00:00:00
EASTER SUNDAY |  | 2010-04-04 00:00:00
EASTER MONDAY | 2010-04-05 00:00:00 |  |  |  | april | 4 | 1 | 2010-04-01 00:00:00 | 2010-04-30 00:00:00
EARLY MAY B/H | 2010-05-03 00:00:00
SPRING B/H | 2010-05-31 00:00:00
SUMMER B/H | 2010-08-30 00:00:00 | 2010-08-30 00:00:00 |  |  | may | 5 | 1 | 2010-05-01 00:00:00 | 2010-05-31 00:00:00
 |  |  |  |  | june | 6 | 1 | 2010-06-01 00:00:00 | 2010-06-30 00:00:00
 |  |  |  |  | july | 7 | 1 | 2010-07-01 00:00:00 | 2010-07-31 00:00:00
 |  |  |  |  | aug | 8 | 1 | 2010-08-01 00:00:00 | 2010-08-31 00:00:00
 |  |  |  |  | sept | 9 | 1 | 2010-09-01 00:00:00 | 2010-09-30 00:00:00
 |  |  |  |  | oct | 10 | 1 | 2010-10-01 00:00:00 | 2010-10-31 00:00:00
 |  |  |  |  | nov | 11 | 1 | 2010-11-01 00:00:00 | 2010-11-30 00:00:00
 |  |  |  |  | dec | 12 | 1 | 2010-12-01 00:00:00 | 2010-12-31 00:00:00
 |  |  |  |  | jan | 1 | 1 | 2011-01-01 00:00:00 | 2011-01-31 00:00:00
 |  |  |  |  | feb | 2 | 1 | 2011-02-01 00:00:00 | 2011-02-28 00:00:00
 |  |  |  |  | [NAME] | 3 | 1 | 2011-03-01 00:00:00 | 2011-03-31 00:00:00
 |  |  |  |  | apr | 4 | 1 | 2011-04-01 00:00:00 | 2011-04-30 00:00:00
 |  |  |  |  | may | 5 | 1 | 2011-05-01 00:00:00 | 2011-05-31 00:00:00
 |  |  |  |  | jun | 6 | 1 | 2011-06-01 00:00:00 | 2011-06-30 00:00:00
 |  |  |  |  | jul | 7 | 1 | 2011-07-01 00:00:00 | 2011-07-31 00:00:00
 |  |  |  |  | aug | 8 | 1 | 2011-08-01 00:00:00 | 2011-08-31 00:00:00
Spreadsheet: 732658d1621113937-substitute-times-in-a-race-to-positions-substituting-times-to-positions
Sheet: Sheet1

Line Up |  |  |  |  |  |  | Final positions
Lane 1 | [NAME] | Lane 3 | [NAME] | Lane 5 | Lane 6 |  | Lane 1 | [NAME] | Lane 3 | [NAME] | Lane 5 | Lane 6
10.21 | 10.15 | 10.26 | 10.07 | 10.19 | 10.84 |  | 4th | 2nd | 5th | 1st | 3rd | 6th |  | How do I substitute the times in cells A3;F3 to the positions in H3:M3?
Spreadsheet: tracy_geaccone__40143__sharris0201wk4
Sheet: Estimate Vs. Plan

Transwestern Pipeline Company
($[NAME])
 |  | February, 2001
 |  | Plan | Estimate | [NAME] |  | Comments
West Demand Revenues |  |  |  |  |  | Sempra( 4.441)& Richardson(1.481) Short Term Firm Contracts(Total 5.922);
 |  |  |  |  |  | Tenaska K @ Max Rates
West Commodity Revenues |  |  |  |  |  | Higher IT volumes than in plan
East Demand Revenues
East Commodity Revenues |  |  |  |  |  | Higher Rates
[NAME] |  |  |  |  |  | Higher Rates
[NAME] Revenues |  |  |  |  |  | Higher IT volumes than in plan
Revenue Variance
Fuel Price [NAME] |  |  |  |  | (1.87*157) | MTD index price of $5.62 vs. Plan index price of $3.75
 |  |  |  |  |  | Unhedged Plan volume (717-560)  157
Fuel Volume Variance-Unhedged |  |  |  |  | (5.62*129) | Higher retained volumes than Plan volumes(846-717=129)
 |  |  |  |  |  | @ MTD index price of $5.62
Sales Margin Variance on Unhedged |  |  |  | 0.572
Hedging Adjustment |  |  |  |  |  | Add'l price on physical sales of HEDGED volumes
 |  |  |  |  |  | ($.005 on 10,000/day, $.02 on 10,000/day)
Unaccounted for Variance
Fuel Variance
MONTH-TO-DATE VARIANCE
2001 Stretch |  | 0.85 | 0
ADJUSTED MONTH-TO-DATE VARIANCE
 | ------------- | ------------- | ------------- | -------------
Spreadsheet: 888979d1739629362-simplifing-multiple-formulas-to-one-formula-example
Sheet: Sheet1

1 | 5
text | text
12 | 1
text | texterre
2 | 7
text | text
 | Total:
Spreadsheet: 16c0646d-9f7b-4557-b1f0-b5748af1739e
Sheet: 32

شركت ساختماني گسترش و نوسازي صنايع ايرانیان مانا(سهامي خاص)
يادداشتهاي [NAME] مالي
دوره مالي شش ماهه منتهي به 31 خرداد ماه 1390
16- پيش دريافتها
[NAME] پيش دريافتها به شرح زير تفكيك مي گردد:
 |  | يادداشت |  | 1390/03/31 |  | 1389/09/30
 |  |  |  | ريال |  | ريال
ساير اشخاص(كارفرمايان) |  | 16-1
سایر پیش دریافتها |  |  |  | 7926952000 |  | 0
1- 16 - پیش دریافتهای کارفرمایان بشرح زیر میباشد : |  |  |  | 1390/03/31 |  | 1389/09/30
 |  |  |  | ريال |  | ريال
شرکت توسعه اماکن ورزشی - شیراز |  |  |  | 6714320833 |  | 6714320833
پروژه ساختمان میدان شهدای مشهد |  |  |  | 3191905329 |  | 3191905329
شرکت سرمایه گذاری [NAME] |  |  |  | 0 |  | 135458819
ساختمان آند رادینگ اراک |  |  |  | 599581485 |  | 1582267761
فولاد زرند ایرانیان |  |  |  | 79023181158 |  | 79215074982
موننکو |  |  |  | 2010700631 |  | 2010700631
کارخانه کنسانتره آهن زرند |  |  |  | 8100949390 |  | 8100949390
کارخانه کنسانتره آهن سیرجان |  |  |  | 10015237140 |  | 10015237140
شرکت سرمایه گذاری نیرو (نیاوران) |  |  |  | 303990489 |  | 514803086
[NAME] طرح و اجرای [NAME] ایران |  |  |  | 1685000791 |  | 886246681
شرکت توسعه اماکن ورزشی - استادیوم 50هزار نفری شیراز |  |  |  | 17366429804 |  | 10697795382
پیمان مدیریت - شرکت موننکو |  |  |  | 220724800 |  | 450936015
[NAME] فارس |  |  |  | 2500000000 |  | 2500000000
شرکت آب منطقه ای خراسان رضوی _ آب شرب |  |  |  | 7434009566 |  | 5934503701
[NAME] غربی |  |  |  | 2744893328 |  | 3878844949
شرکت فرآوران ذغال سنگ پابدانا |  |  |  | 5303589787 |  | 1000000000
سازمان پارکها وفضای سبز شهرداری تهران |  |  |  | 2713778333 |  | 0
[NAME]
Spreadsheet: 801673d1666291860-duplicate-totals-help-pt-id-instance-test
Sheet: Sheet1

Sending Facility | Patient Name | DOB | Patient ID | PCP | Intk. Date | Intk. Time
Banner Thunderbird Medical  Center:HL7 | SMITH, BOB | 1969-01-11 00:00:00 | HF381010515 | [NAME]
[NAME]:HL7 | CORELLA, HARRY | 2015-05-19 00:00:00 | HF374884745 | SANDHYA S RAVI |  |  |  |  |  | =LET(a, A2:INDEX(A:A, COUNTA(A:A)), u, [NAME]), uc, COUNTIF(a, UNIQUE(a)), HSTACK(u, uc))
[NAME]:HL7 | JONES, [NAME] | 2015-05-19 00:00:00 | HF374884742 | SANDHYA S RAVI
Phoenix Children's:HL7 | OLIVARES, [NAME] | 2017-07-23 00:00:00 | HF372845291 | N/A
HonorHealth North Mountain Hospital:HL7 | LANHAM, LARRY | 1963-02-01 00:00:00 | HF368700514 | RODD AKING
Banner Thunderbird Medical  Center:HL7 | SMITH, BOB | 1969-01-11 00:00:00 | HF381010515 | [NAME]
[NAME]:HL7 | CORELLA, HARRY | 2015-05-19 00:00:00 | HF374884745 | SANDHYA S RAVI
[NAME]:HL7 | JONES, [NAME] | 2015-05-19 00:00:00 | HF374884742 | SANDHYA S RAVI |  |  |  |  |  | =LET(a, B2:INDEX(B:B, COUNTA(B:B)), u, [NAME]), uc, COUNTIF(a, UNIQUE(a)), HSTACK(u, uc))
Phoenix Children's:HL7 | OLIVARES, [NAME] | 2017-07-23 00:00:00 | HF372845291 | N/A
HonorHealth North Mountain Hospital:HL7 | LANHAM, LARRY | 1963-02-01 00:00:00 | HF368700514 | RODD AKING
Banner Thunderbird Medical  Center:HL7 | SMITH, BOB | 1969-01-11 00:00:00 | HF381010515 | [NAME]
[NAME]:HL7 | CORELLA, HARRY | 2015-05-19 00:00:00 | HF374884745 | SANDHYA S RAVI
[NAME]:HL7 | JONES, [NAME] | 2015-05-19 00:00:00 | HF374884742 | SANDHYA S RAVI
Phoenix Children's:HL7 | OLIVARES, [NAME] | 2017-07-23 00:00:00 | HF372845291 | N/A
HonorHealth North Mountain Hospital:HL7 | LANHAM, LARRY | 1963-02-01 00:00:00 | HF368700514 | RODD AKING |  |  |  |  |  | =LET(col, A:A, rng, INDEX(col, 2):INDEX(col, COUNTA(col)), u, UNIQUE(rng), uc, COUNTIF(rng, UNIQUE(rng)), HSTACK(u, uc))
Banner Thunderbird Medical  Center:HL7 | SMITH, BOB | 1969-01-11 00:00:00 | HF381010515 | [NAME]
[NAME]:HL7 | CORELLA, HARRY | 2015-05-19 00:00:00 | HF374884745 | SANDHYA S RAVI
[NAME]:HL7 | JONES, [NAME] | 2015-05-19 00:00:00 | HF374884742 | SANDHYA S RAVI
Phoenix Children's:HL7 | OLIVARES, [NAME] | 2017-07-23 00:00:00 | HF372845291 | N/A
HonorHealth North Mountain Hospital:HL7 | LANHAM, LARRY | 1963-02-01 00:00:00 | HF368700514 | RODD AKING
Banner Thunderbird Medical  Center:HL7 | SMITH, BOB | 1969-01-11 00:00:00 | HF381010515 | [NAME] |  |  |  |  |  | =LET(col, B:B, rng, INDEX(col, 2):INDEX(col, COUNTA(col)), u, UNIQUE(rng), uc, COUNTIF(rng, UNIQUE(rng)), HSTACK(u, uc))
[NAME]:HL7 | CORELLA, HARRY | 2015-05-19 00:00:00 | HF374884745 | SANDHYA S RAVI
[NAME]:HL7 | JONES, [NAME] | 2015-05-19 00:00:00 | HF374884742 | SANDHYA S RAVI
Phoenix Children's:HL7 | OLIVARES, [NAME] | 2017-07-23 00:00:00 | HF372845291 | N/A
HonorHealth North Mountain Hospital:HL7 | LANHAM, LARRY | 1963-02-01 00:00:00 | HF368700514 | RODD AKING