tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 740727d1626505821-populate-across-columns-formula-containing-indirect-refernce-book1
Sheet: Sheet1

 | 11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 13
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 16
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 17
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 18
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 20
Spreadsheet: 0bab40b4-0293-4b4c-9119-d98edc5e0873
Sheet: Sheet1

TRAVEL EXPENSE REPORT | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
IMPORTANT INFORMATION IS LISTED ON THE NEXT PAGE
NAME |  |  |  | DEPARTMENT |  |  |  | DATE
[NAME] |  |  |  | TELEPHONE |  |  |  | MAIL CODE
PURPOSE OF TRAVEL
DATE |  |  |  |  |  |  |  |  | TOTALS
REQUIRED: 1st Day Start Time & Last Day End Time; AM/PM
CITY
(1)  Air/Train Fees |  |  |  |  |  |  |  |  | 0
(2)  Breakfast |  |  |  |  |  |  |  |  | 0
(3)  Lunch |  |  |  |  |  |  |  |  | 0
(4)  Dinner |  |  |  |  |  |  |  |  | 0
(5)  Hotel/Lodging |  |  |  |  |  |  |  |  | 0
(6)  Ground Transportation |  |  |  |  |  |  |  |  | 0
(7)  Personal Auto Reimb. |  |  |  |  |  |  |  |  | 0
(8)  Parking |  |  |  |  |  |  |  |  | 0
(9)  Registration |  |  |  |  |  |  |  |  | 0
(10)  Telephone/Internet |  |  |  |  |  |  |  |  | 0
(11)  Other; Explain on back |  |  |  |  |  |  |  |  | 0
(12) TOTAL EXPENSES |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  | Less Travel Advance Req#
MAILING ADDRESS: |  |  |  |  |  | Less Pcard Amount:
(REQUIRED) |  |  |  |  |  | (13) Net Due to [NAME]: |  |  | 0
 |  |  |  |  |  | OR
 |  |  |  |  |  | (14) Net Due to LMU: |  |  | 0
 |  |  |  |  |  | NOTE: ATTACH CHECK PAYABLE TO LMU
Important information regarding travel expenses and required explanations are listed on the back |  | OFFICE     USE ONLY | Budget Account # |  |  |  |  | Amount
RECEIPTS ARE REQUIRED FOR ALL ITEMS EXCEPT TIPS.  EXPLANATION REQUIRED FOR ITEM 11 (on reverse side)
I hereby certify that the expenses reported above are, to my knowledge, true and correct and were incurred by me in the performance of University business.  I have reviewed the Travel Policies and I am in compliance.
Employee Signature: ______________________________________________ |  |  |  |  |  |  | Date: | ___________________
Chair Approval:___________________________________________________ |  |  |  |  |  |  | Date: | ___________________
[NAME]: __________________________________________________ |  |  |  |  |  |  | Date: | ___________________
TRAVEL EXPENSE REPORT- CONTINUED
PROVIDE EXPLANATIONS HERE IF NEEDED.
ITEM# | DATE | AMOUNT |  | EXPLANATIONS (Required for item # 11)
TRAVEL EXPENSE REPORT INFORMATION
A. | Original receipts and/or other substantiation must accompany the expense report to obtain reimbursement.  Please note that documentation requirements are for your benefit, to insure the IRS does not attribute taxable income to you personally.
B. | As of Jul. 2011, the IRS allows for personal vehicles used on University business, mileage reimbursed at the rate of .555 cents per business mile.
C. | Meals will be reimbursed at the actual cost up to: $12.00 breakfast, $18.00 lunch and $30.00 dinner.  Meals will be allowed on average of $60 per day per trip (including gratuities).  Please see Travel Policy.
D. | All totals must be completed.
E. | The report must be signed by both the employee, chair and the BCLA Dean.
F. | Any report not meeting the above criteria will be returned.
FOR OFFICIAL USE ONLY
COMMENTS:
Spreadsheet: 067dbc86-9b3e-448f-9fcc-aadb5297f848
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | column | notes | flat file position | (number) formatting
A | SSN | need actual SSN | 1 thru 9 | nine zeroes under "custom"= 000000000
B | EDIT | E for edit | 10 | must be upper case E
C | ADD OR CHANGE | A for add; C for change | 11 | must be upper case A or C
- | space |  | 12 thru 14
D | NAME | LASTNAME  FIRSTNAME | 15 thru 34 | upper case only, no comma, 2 spaces b/n surname and given
E | DEPENDENCY STATUS |  | 35
F | YEAR IN SCHOOL | 0,1,2,3,4,5,6,8 | 36 | year in school
G | MARITAL STATUS |  | 37
H | [NAME] |  | 38 thru 39
I | space |  | 40
J | PARENTAL CONTRIBUTION | 0 | 41 thru 45
K | space |  | 46
L | EFC | 0 | 47 thru 51
M | space |  | 52
N | STUDENT CONTRIBUTION | 0 | 43 thru 47
O | space |  | 58
P | PRORATION PERCENTAGE | TG only - 50 and 75% valid | 59 thru 61
Q | space |  | 62
R | X CODE | X to zero award, V to remove X and calculate, V does not remain on record | 63
S | space |  | 64
T | SEMESTER CODE | semester with the award being over-ridden | 65
U | space |  | 66
V | NEW AWARD |  | 67 thru 71
W | space |  | 72
X | TUITION LEVEL | TG only - for schools w/multiple tuitions | 73
Y | space |  | 74
Z | SCHOOL USE P CODE |  | 75
AA | spaces | 2 spaces | 76 thru 77
AB | SCHOOL CODE | HEAB assigned 3 digit code | 78 thru 80
AC | space |  | 81
AD | OVER-RIDE DEPENDENCY STATUS |  | 82
AE | space |  | 83
AF | OVER-RIDE EFC |  | 84 thru 88
AG | spaces |  | 89-99
Spreadsheet: 693061d1598726536-how-do-i-add-data-to-a-sheet-without-messing-up-the-formatting-for-the-whole-workbook-problems-2
Sheet: Problem

 |  | A | A | B | B | A | A | B | B | Hrs | Beg | End
Last | First | 1 | 2 | 15 | 16 | 22 | 23 | 29 | 30 | Com. | Hrs | Hrs
Adams | [NAME] |  | 10 |  |  |  |  |  | 12
[NAME] | Daryl | 8 |  |  |  | 8
[NAME] | [NAME]
Credence | [NAME] |  |  |  | 4
[NAME] | Daryl
Edwards | [NAME] |  | 10 | 8 |  |  | 8
[NAME] | Anne
Gonzales | George | 8 | 10 |  |  | 8
[NAME] | George |  |  |  |  |  | 8 |  | 12 |  | 64
Smith | [NAME] | 8 | 10 | 8 |  |  | 8 | 8 | 12
 | Total Workers
Spreadsheet: 078e161d-6007-4cd7-b369-66379c89b00b
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | 2012/2013 SEASON | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13
 |  |  |  |  |  |  | AGE MATRIX
93 | J | F | M | A | M | J | J | A | S | O | N | D | U19
94 | J | F | M | A | M | J | J | A | S | O | N | D
95 | J | F | M | A | M | J | J | A | S | O | N | D
96 | J | F | M | A | M | J | J | A | S | O | N | D | U16
97 | J | F | M | A | M | J | J | A | S | O | N | D
98 | J | F | M | A | M | J | J | A | S | O | N | D | U14
99 | J | F | M | A | M | J | J | A | S | O | N | D
0 | J | F | M | A | M | J | J | A | S | O | N | D | U12
1 | J | F | M | A | M | J | J | A | S | O | N | D
2 | J | F | M | A | M | J | J | A | S | O | N | D | U10
3 | J | F | M | A | M | J | J | A | S | O | N | D
4 | J | F | M | A | M | J | J | A | S | O | N | D | U08
5 | J | F | M | A | M | J | J | A | S | O | N | D
6 | J | F | M | A | M | J | J | A | S | O | N | D | U06
7 | J | F | M | A | M | J | J | A | S | O | N | D
Spreadsheet: 3e6a944c-c890-4cef-80eb-41d8c7f9cecb
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
BUSA-UPC EIGHT-BALL POOL HOME NATIONS CHAMPIONSHIP 2006-2007
GROUP PHASE
English Universities | v | Scottish Universities | 11 | 8 |  | Final Table | W | L | RF | RA | Diff
Scottish Universities | v | Welsh Universities | 9 | 11 |  | 1. Welsh Universities | 3 | 1 | 36 | 35 | +1
Welsh Universities | v | English Universities | 3 | 11 |  | 2. English Universities | 2 | 2 | 37 | 33 | +4
Scottish Universities | v | English Universities | 11 | 10 |  | 3. Scottish Universities | 1 | 3 | 38 | 43 | -5
Welsh Universities | v | Scottish Universities | 11 | 10
English Universities | v | Welsh Universities | 5 | 11
Most valuable player: [NAME] (ENG) 81.8% (9/11)
CHAMPIONSHIP FINAL
Welsh Universities | v | English Universities | 2 | 8
[NAME] | v | [NAME] | L | W
[NAME] | v | [NAME] | L | W
[NAME] | v | [NAME] | L | W
[NAME] | v | [NAME] | L | W
[NAME] | v | [NAME] | L | W
[NAME] | v | Anesh [NAME] | W | L
Rhys Davies | v | [NAME] | L | W
[NAME] | v | Anesh [NAME] | L | W
[NAME] | v | [NAME] | W | L
[NAME] | v | [NAME] | L | W
[NAME] | v | [NAME]
[NAME] | v | [NAME]
[NAME] | v | [NAME]
[NAME] | v | [NAME]
Rhys Davies | v | [NAME]
Spreadsheet: 129852d1321933370-automatically-format-only-those-month-cells-that-are-3-months-ahead-of-chosen-month-111122-example-conditional-formatting-month
Sheet: Sheet1

Launch month | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast
 | January | February | March | April | May | June | July | August | September | October | November | December
April
I want to make it look like this if one picks April as a launch month
Launch month | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast
 | January | February | March | April | May | June | July | August | September | October | November | December
April
I want to make it look like this if one picks November  as a launch month
Launch month | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast
 | January | February | March | April | May | June | July | August | September | October | November | December
November
Spreadsheet: 718268d1613064317-conditional-time-subtraction-sample-1-
Sheet: Sheet1

 | FLY1 | 1111 | AAA | AAA | 2021-01-03 06:05:00 | 1:35:00 | 2021-01-03 06:08:00 | 2021-01-03 08:00:00
 | FLY | 2222 | BBB | BBB |  | 1:30:00 | 2021-01-03 08:45:00 | 2021-01-03 10:34:00
 | FLY | 3333 | CCC | CCC |  | 0:55:00 | 2021-01-03 14:36:00 | 2021-01-03 12:47:00
 | FLY | 4444 | DDD | DDD |  | 1:00:00 | 2021-01-03 13:35:00 | 2021-01-03 14:36:00
Spreadsheet: 3bb78c88-07be-4112-a19e-3f5a16676857
Sheet: Sheet1

Antigen | Cell Type | Treatment | [NAME] | [NAME]
TMEV capsid |  | Ethanol or Acetone | Rabbit hyperimmune serum, 1:2000 | Cy3 coupled anti-rabbit IgG (Amersham)
NeuN | Neuron | Acetone | Mouse anti-NeuN, 1:50 (Chemicon) | Alexa488 coupled anti-mouse IgG ([NAME])
CNPase | [NAME] | Ethanol | Mouse anti-CNPase, 1:100 (Sigma) | Alexa488 or Alexa350 coupled anti-mouse IgG ([NAME])
Olig2 | [NAME] | Ethanol | Rabbit anti-Olig2, 1:500 (Chemicon) | Cy3 coupled anti-rabbit IgG (Amersham)
PLP | [NAME] | Ethanol | Rat anti-PLP, 1:10 (gift of C. Lubetzki) | Cy3 coupled anti-rat IgG (Jackson Immunoresearch)
GFAP | [NAME] | Ethanol | Mouse anti-GFAP, 1:100 (Chemicon) | Alexa488 coupled anti-mouse IgG ([NAME])
GFAP | [NAME] | Ethanol | Rabbit anti-GFAP, 1:100 (Dako) | Cy3 coupled anti-rabbit IgG (Amersham)
CD11b | Macrophage/Microglia | Ethanol | Rat anti-CD11b, 1:100 (Pharmingen) | Cy3 coupled anti-rat IgG (Jackson Immunoresearch)
Spreadsheet: 64544d1265371733-entering-data-into-a-certain-cell-if-another-cell-contains-a-certain-field-color-swatches
Sheet: Sheet1

SKU | URL |  | Available Colors | URLs
RS35_BLK_123XYZ | http://URL_for_BLK |  | BLK | http://URL_for_BLK
RS35_FOR_123XYZ | http://URL_for_FOR |  | FOR | http://URL_for_FOR
RS35_NAV_123XYZ | http://URL_for_NAV |  | NAV | http://URL_for_NAV
RS35_RED_123XYZ | http://URL_for_RED |  | RED | http://URL_for_RED
RS35_RED_123XYZ | http://URL_for_RED
RS35_RED_123XYZ | http://URL_for_RED
Spreadsheet: andy_zipper__267__Broker detail 5-30-01
Sheet: BROKER DEAL SUMMARY

EnronOnline Broker Detail for 5/30/2001
Completed Transactions:
TODAY
Date | 2001-05-30 00:00:00
 | Data | Commodity
 | DEAL COUNT |  | BROKER SAVING |  | Total DEAL COUNT | Total BROKER SAVING
Broker | Natural Gas | Power | Natural Gas | Power
APB Energy, Inc. | 6 | 17 | 1102.5 | 1590.2 | 23 | 2692.7
Natsource LLC | 2 | 8 | 90 | 772 | 10 | 862
Amerex Power, Ltd. |  | 9 |  | 1212 | 9 | 1212
Grand Total | 8 | 34 | 1192.5 | 3574.2 | 42 | 4766.7
LIFE TO DATE (First Trade March 28, 2001)
 | Data | Commodity
 | DEAL COUNT |  | BROKER SAVING |  | Total DEAL COUNT | Total BROKER SAVING
Broker | Natural Gas | Power | Natural Gas | Power
APB Energy, Inc. | 80 | 195 | 20693.75 | 14361.24 | 275 | 35054.99
Natsource LLC | 35 | 236 | 5113.5 | 20141 | 271 | 25254.5
Power Merchants Group, LLC | 12 |  | 1546.83 |  | 12 | 1546.83
Amerex Natural Gas I, Ltd. | 52 | 1 | 6887.6875 | 4 | 53 | 6891.6875
Amerex Power, Ltd. |  | 27 |  | 3448 | 27 | 3448
Prebon Energy, Inc. |  | 1 |  | 120 | 1 | 120
Grand Total | 179 | 460 | 34241.7675 | 38074.24 | 639 | 72316.0075
Failed Transactions:
TODAY
Date | 2001-05-30 00:00:00
FAILED TRANSACTION COUNT | Commodity
Broker | Natural Gas | Power | Grand Total
APB Energy, Inc. | 8 | 2 | 10
Amerex Power, Ltd. |  | 1 | 1
Prebon Energy, Inc. | 1 |  | 1
Grand Total | 9 | 3 | 12
LIFE TO DATE (First Trade March 28, 2001)
FAILED TRANSACTION COUNT | Commodity
Broker | Natural Gas | Power | Grand Total
APB Energy, Inc. | 31 | 26 | 57
Natsource LLC | 6 | 38 | 44
Power Merchants Group, LLC | 20 |  | 20
Amerex Power, Ltd. |  | 9 | 9
Amerex Natural Gas I, Ltd. | 6 |  | 6
Prebon Energy, Inc. | 1 |  | 1
Grand Total | 64 | 73 | 137
Spreadsheet: 825936d1681662707-sort-formula-sort-by
Sheet: Sheet1

Name | 2022-01-31 00:00:00 | 2022-02-28 00:00:00 | 2022-03-31 00:00:00 | 2022-04-30 00:00:00 | 2022-05-31 00:00:00 | 2022-06-30 00:00:00 | 2022-07-31 00:00:00 | 2022-08-31 00:00:00 | 2022-09-30 00:00:00 | 2022-10-31 00:00:00 | 2022-11-30 00:00:00 | 2022-12-31 00:00:00
Michelle | 3890 | 3529 | 2803 | 3534 | 2668 | 4608 | 2882 | 4901 | 1536 | 3952 | 4578 | 2009
[NAME] | 3672 | 2442 | 1993 | 4427 | 2861 | 1298 | 1364 | 2953 | 4149 | 1614 | 4918 | 1970
Addy | 3791 | 4463 | 1324 | 3798 | 3278 | 1253 | 2443 | 4154 | 2794 | 4801 | 1543 | 4876
[NAME] | 1138 | 1050 | 3527 | 3936 | 1512 | 3500 | 2494 | 1890 | 3558 | 4902 | 3075 | 4280
 | Sort By Name |  | Sort By Month |  | How do I get the Name of the Person and Sort it by biggest to smallest?
 | 33661 |  | 11484 |  | How do I get the Date and Sort it by biggest to smallest?
 | 38518 |  | 9647
 | 34862 |  | 15695
 |  |  | 10319
 |  |  | 10659
 |  |  | 9183
 |  |  | 13898
 |  |  | 12037
 |  |  | 15269
 |  |  | 14114
 |  |  | 13135
Spreadsheet: c867e0b2-222b-46a4-b5c0-9e3e6b06e287
Sheet: Sheet1

Unnamed: 0 | CITRIX SYSTEMS, INC. | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 | REVENUES BY PRODUCT MIX
 | (In thousands)
 |  |  | Three Months |  | Three Months |  | Three Months |  | Three Months
 |  |  | Ended |  | Ended |  | Ended |  | Ended
 |  |  | March 31, |  | June 30, |  | September 30, |  | December 31,
 |  |  | 2009 |  | 2009 |  | 2009 |  | 2009
 | Revenues:
 | Product licenses |  | 111900 |  | 129692 |  | 129060 |  | 168323
 | License updates |  | 148198 |  | 149334 |  | 151041 |  | 156395
 | Online services |  | 71980 |  | 75350 |  | 78878 |  | 81969
 | Technical services |  | 36980 |  | 38452 |  | 42063 |  | 44473
 | Total net revenues |  | 369058 |  | 392828 |  | 401042 |  | 451160
 | Note:  This document should be read in conjunction with the Company's SEC Filings.
Spreadsheet: 715350d1611671938-sumifs-not-working-when-using-cell-references-instead-of-dates-month_example
Sheet: Lloyds

 | Date |  | Item | Credit | Debit
4980 | 2020-12-31 00:00:00
 | 2020-12-31 00:00:00 | xx | xxxxxxxx
 | 2020-12-31 00:00:00 | xx | xxxxxxxx
 | 2020-12-31 00:00:00 | xx | xxxxxxxx
 | 2020-12-31 00:00:00 | xx | xxxxxxxx
 | 2021-01-02 00:00:00 | xx | xxxxxxxx
 | 2021-01-03 00:00:00 | xx | xxxxxxxx
 | 2021-01-04 00:00:00 | xx | xxxxxxxx | 3.62
 | 2021-01-05 00:00:00 | xx | xxxxxxxx |  | 52.99
 | 2021-01-07 00:00:00 | xx | xxxxxxxx
 | 2021-01-09 00:00:00 | xx | xxxxxxxx |  | 2.71
 | 2021-01-15 00:00:00 | xx | xxxxxxxx |  | 596.08
 | 2021-01-20 00:00:00 | xx | xxxxxxxx |  | 700
 | 2021-01-21 00:00:00 | xx | xxxxxxxx |  | 26.64
 | 2021-01-23 00:00:00 | xx | xxxxxxxx |  | 8.67
 | 2021-01-25 00:00:00 | xx | xxxxxxxx | 4865
 | 2021-01-25 00:00:00 | xx | xxxxxxxx |  | 9000
 | 2021-01-28 00:00:00 | xx | xxxxxxxx | 1846.96
 | 2021-02-02 00:00:00 | xx | xxxxxxxx
 | 2021-02-03 00:00:00 | xx | xxxxxxxx
 | 2021-02-05 00:00:00 | xx | xxxxxxxx |  | 60
 | 2021-02-15 00:00:00 | xx | xxxxxxxx | 700
 | 2021-02-16 00:00:00 | xx | xxxxxxxx |  | 700
 | 2021-02-20 00:00:00 | xx | xxxxxxxx |  | 700
 | 2021-02-21 00:00:00 | xx | xxxxxxxx |  | 26.64
 | 2021-02-23 00:00:00 | xx | xxxxxxxx |  | 8.67
Spreadsheet: 811961d1672891865-autofill-with-if-formula-if-formula
Sheet: Sheet1

 |  |  | [NAME] | Grade | BC | Ket |  |  | SOURCE  IF | TEXT
THE RESULT I WANT (AUTO FILL) |  |  | MPS FARM 2 |  |  | FARM 2 |  |  | FARM 1 | MPS FARM 1
 |  |  |  |  |  |  |  |  | FARM 2 | MPS FARM 2
 |  |  | "+IF() |  |  |  |  |  | BOTH | MIX MPS FARM 1 AND FARM 2
 |  |  |  |  |  |  |  | I ENTER THE TEXT HERE FROM D4:D12
 |  |  | [NAME] | Grade | BC | Ket |  |  | [NAME] | Grade | BC | Ket
THE RESULT I WANT |  |  | MPS FARM 1 |  |  | FARM 1 |  | THE RESULT I WANT | MIX MPS FARM 1 AND FARM 2 |  |  | FARM 2
 |  |  |  |  |  |  |  |  |  |  |  | FARM 2
 |  |  |  |  |  |  |  |  |  |  |  | FARM 1
Spreadsheet: 130061d1322051420-names-into-teams-players
Sheet: Sheet1

player 4 | team 1 |  |  |  |  | player 1 | team 1
 |  |  |  |  |  | player 2 | team 1
 |  |  |  |  |  | player 3 | team 1
 |  |  |  |  |  | player 4 | team 1
 |  |  |  |  |  | player 5 | team 1
 |  |  |  |  |  | player 6 | team 1
 |  |  |  |  |  | player 7 | team 1
 |  |  |  |  |  | player 8 | team 1
 |  |  |  |  |  | player 9 | team 1
 |  |  |  |  |  | player 10 | team 1
 |  |  |  |  |  | player 11 | team 1
 |  |  |  |  |  | player 12 | team 2
 |  |  |  |  |  | player 13 | team 2
 |  |  |  |  |  | player 14 | team 2
 |  |  |  |  |  | player 15 | team 2
 |  |  |  |  |  | player 16 | team 2
 |  |  |  |  |  | player 17 | team 2
 |  |  |  |  |  | player 18 | team 2
 |  |  |  |  |  | player 19 | team 2
 |  |  |  |  |  | player 20 | team 2
 |  |  |  |  |  | player 21 | team 2
 |  |  |  |  |  | player 22 | team 2
Spreadsheet: 547403d1510542483-invoice-queue-sequence-copy-of-invoice-sequence-group-delta729-
Sheet: Sheet1

Date | Invoice | Queue |  | Queue | column E is hard coded for what I'm trying to make the formula in column C to have
2017-01-05 00:00:00 | 1234 |  |  | 1234-1
2017-01-06 00:00:00 | 1234 |  |  | 1234-1
2017-01-07 00:00:00 | 1234 |  |  | 1234-1
2017-01-08 00:00:00 | 1234 |  |  | 1234-1
2017-01-05 00:00:00 | 1235 |  |  | 1235-1
2017-01-06 00:00:00 | 1235 |  |  | 1235-1
2017-01-11 00:00:00 | 1235 |  |  | 1235-2
2017-01-21 00:00:00 | 1235 |  |  | 1235-3
2017-01-22 00:00:00 | 1235 |  |  | 1235-3
2017-01-06 00:00:00 | 1456 |  |  | 1456-1
2017-01-07 00:00:00 | 1456 |  |  | 1456-1
Spreadsheet: eric_saibi__9769__012502R
Sheet: Encina 03

Owner Name |  | Cabrillo Power LLC
Station Name |  | Encina Power Station
Unit Name |  | Encina 03
NERC Region |  | WSCC
State |  | CA
Fuel Type |  | Natural Gas
Capacity |  | 110 MW
Start Date |  | 2002-01-04 00:00:00
End Date |  | 2002-01-28 00:00:00
Prv. Start Date |  | 2002-01-04 00:00:00
Prv. End Date |  | 2002-01-23 00:00:00
Comments |  | Asbestos removal and Inspection
SIC |  | 4931
Plant ID |  | 1014846
Unit ID |  | 1006366
Outage ID |  | 19378
Spreadsheet: 845884d1697200451-merge-columns-in-power-query-merge-columns-in-power-query_sample
Sheet: Expected Result

Employee | Emp ID | Work order Number | Work order Description | Week Number | Days | Oct-2023 | Nov-2023 | Dec-2023 | Jan-2024 | Feb-2024 | Mar-2024
Jererome | UKJMA003 | 70009391-222
Jererome | UKJMA003 | 70087403-E20
Jererome | UKJMA003 | 70107938-BPG
Jererome | UKJMA003 | 70108172-211
Jererome | UKJMA003 | 99900014-001
Jererome | UKJMA003 | 70110010-211
Jererome | UKJMA003 | 70046361-2WL
Jererome | UKJMA003 | 70090296-251
Spreadsheet: 877965d1724911412-if-formula-ifsample
Sheet: Sheet1

Start_Date | Date Convert | Week | [NAME] | Start Time | End Time | Not Ready Time | Not Ready Reason
2024-06-30 19:50:29 | 2024-07-01 00:00:00 | 27 |  |  | 2024-07-01 08:09:59 |  | Break 2
2024-06-30 20:13:48 | 2024-07-01 00:00:00 | 27 |  |  | 2024-07-01 08:28:40 |  | Break 1
Spreadsheet: 89260d1288999608-conditional-linked-formatting-phhl-conditional-formatting-example
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Score
67.3 | 74.38222222222217 | 81.4644444444444 | 88.54666666666662 | 95.62888888888885 | 102.7111111111111 | 109.7933333333333 | 116.8755555555555 | 123.9577777777778 | 131.04
10 | 9 | 8 | 7 | 6 | 5 | 4 | 3 | 2 | 1 | 5
 |  |  |  |  |  |  |  |  |  |  |  | 83
 |  |  |  |  |  |  |  |  |  | Score
67.3 | 74.38222222222217 | 81.4644444444444 | 88.54666666666662 | 95.62888888888885 | 102.7111111111111 | 109.7933333333333 | 116.8755555555555 | 123.9577777777778 | 131.04
10 | 9 | 8 | 7 | 6 | 5 | 4 | 3 | 2 | 1
 |  |  |  |  |  |  |  |  |  |  |  | 83
 |  |  |  |  |  |  |  |  |  | Score
67.3 | 74.38222222222217 | 81.4644444444444 | 88.54666666666662 | 95.62888888888885 | 102.7111111111111 | 109.7933333333333 | 116.8755555555555 | 123.9577777777778 | 131.04
Spreadsheet: 273118d1382618324-hiding-columns-with-formulas-from-clients-invoice-spreadsheet
Sheet: PACKAGES

PACKAGES
Name | Dates | Number of Nights | Required Single Rooms |  | Single cost | Required Twin Rooms |  | Twin Cost | Required Double Rooms |  | Double Cost | Required Triple Rooms |  | Triple Cost | Required Family Rooms |  | Family Cost | Totals
DUNIA | 7/11 - 10/11 | 3 |  | 357.22 | 0 | 1 | 292.22 | 584.44 |  | 292.22 | 0 |  | 268.64 | 0 |  | 268.64 | 0 | 584.44 | 7225.200000000001
DUNIA | 7/11 - 10/11 | 3 | 1 | 357.22 | 357.22 |  | 292.22 | 0 |  | 292.22 | 0 |  | 268.64 | 0 |  | 268.64 | 0 | 357.22
ELIN | 7/11 - 10/11 | 3 |  | 357.22 | 0 | 1 | 292.22 | 584.44 |  | 292.22 | 0 |  | 268.64 | 0 |  | 268.64 | 0 | 584.44
ELIN | 7/11 - 10/11 | 3 | 1 | 357.22 | 357.22 |  | 292.22 | 0 |  | 292.22 | 0 |  | 268.64 | 0 |  | 268.64 | 0 | 357.22
JIMMY | 8/11 - 11/11 | 3 |  | 357.22 | 0 | 2 | 292.22 | 1168.88 |  | 292.22 | 0 |  | 268.64 | 0 |  | 268.64 | 0 | 1168.88
BO | 7/11 - 10/11 | 3 |  | 357.22 | 0 |  | 292.22 | 0 |  | 292.22 | 0 | 3 | 268.64 | 805.92 |  | 268.64 | 0 | 805.92
CARL | 8/11 - 10/11 | 2 |  | 310.28 | 0 | 2 | 245.28 | 981.12 |  | 245.28 | 0 |  | 234.14 | 0 |  | 234.14 | 0 | 981.12
[NAME] | 8/11 - 10/11 | 2 |  | 310.28 | 0 |  | 245.28 | 0 |  | 245.28 | 0 | 3 | 234.14 | 702.42 |  | 234.14 | 0 | 702.42
MARGARETA | 8/11 - 10/11 | 2 |  | 310.28 | 0 | 2 | 245.28 | 981.12 |  | 245.28 | 0 |  | 234.14 | 0 |  | 234.14 | 0 | 981.12
STEFAN | 8/11 - 10/11 | 2 |  | 310.28 | 0 |  | 245.28 | 0 |  | 245.28 | 0 | 3 | 234.14 | 702.42 |  | 234.14 | 0 | 702.42
 |  |  |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 | 0
 |  |  |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 | 0
 |  |  |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 | 0
 |  |  |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 | 0
 |  |  |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 | 0
 |  |  |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 | 0
 |  |  |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 | 0
 |  |  |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 | 0
 |  |  |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 | 0