tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 213473d1360533530-formula-to-return-an-offset-value-depending-on-a-condition-report
Sheet: Sheet3

 |  |  | 1
 |  | Level
 |  | Target
 |  | Level
 |  | Target
 |  | Level
 |  | Target
 |  | Level
 |  | Target
 |  | Level
 |  | Target
 |  | Level
 |  | Target
 |  | Level
 |  | Target
 |  | Level
 |  | Target
 |  | Level
 |  | Target
 |  | Level
 |  | Target
 |  | Level
 |  | Target
 |  | Level
 |  | Target
 |  | Level
 |  | Target
 |  | Level
 |  | Target
 |  | Level
 |  | Target
 |  | Level
 |  | Target
 |  | Level
 |  | Target
 |  | Level
 |  | Target
 |  | Level
 |  | Target
 |  | Level
 |  | Target
 |  | Level
 |  | Target
 |  | Level
 |  | Target
 |  | Level
 |  | Target
 |  | Level
 |  | Target
 |  | Level
 |  | Target
 |  | Level
 |  | Target
 |  | Level
 |  | Target
 |  | Level
 |  | Target
 |  | Level
 |  | Target
 |  | Level
 |  | Target
 |  | Level
 |  | Target
 |  | Level
 |  | Target
 |  | Level
 |  | Target
 |  | Do Not Remove |  |  | Do Not Remove
 |  |  |  |  | Wc | 1
 |  |  |  |  | Wb | 2
 |  |  |  |  | Wa | 3
 |  | 1a | 1.66 |  | 1c | 4 | In level order to work out level difference
 | LOOKUP TABLE | 1b | 1.33 |  |  | 5 | from start to current position
 |  | 1c | 1 |  | 1a | 6
 |  | 2a | 2.66 |  | 2c | 7
 |  | 2b | 2.33 |  |  | 8
 |  | 2c | 2 |  | 2a | 9
 |  | 3a | 3.66 |  | 3c | 10
 |  | 3b | 3.33 |  |  | 11
 |  | 3c | 3 |  | 3a | 12
 |  | 4a | 4.66 |  | 4c | 13
 |  | 4b | 4.33 |  |  | 14
 |  | 4c | 4 |  | 4a | 15
 |  | 5a | 5.66 |  | 5c | 16
 |  | 5b | 5.33 |  |  | 17
 |  | 5c | 5 |  | 5a | 18
 | Absent = 0 | A | 0
 | Spare | Wa | 0.66
 | Spare | Wb | 0.33
 | Spare | Wc | 0
 | Spare
Spreadsheet: 700369d1603166412-need-help-to-have-formula-to-ignore-cells-with-no-dates-multiple-cells-in-a-row-playing-with-timeline
Sheet: SFR Conv & FHA (tbd) No App

Subject | Start Date | All day event | Reminder on/off | Meeting Organizer | Categories | Description | Location
Sign Disclosures |  | True | False | Team Rosa | Sign Disclosures
[NAME] |  | True | False | Team Rosa | [NAME]
Processing Review |  | True | False | Team Rosa | Processing Review
Submit Conditions |  | True | False | Team Rosa | Submit Conditions
CD |  | True | False | Team Rosa | CD
Final Approval |  | True | False | Team Rosa | Final Approval
[NAME] CD |  | True | False | Team Rosa | [NAME] CD
Docs Out |  | True | False | Team Rosa | Docs Out
Signing |  | True | False | Team Rosa | Signing
Close Date |  | True | False | Team Rosa | Close Date
KOT Resubmit |  | True | False | Team Rosa | KOT Resubmit
Spreadsheet: 155938d1337109447-is-there-a-way-to-link-horizontal-cells-in-book1-to-vertical-cells-in-book2-p6pmassignments_dynamicrangeexample
Sheet: Refugio Assignment

 |  |  |  |  | Date:
 |  | Week 1
 |  | WO Number | WO Type | Comp ID & Description |  | Est. Hours | Done
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  | Total Hours
 |  | Comments:
 |  | Date Completed: |  |  | Signature:
 |  |  |  |  | Date:
 |  | Week 2
 |  | WO Number | WO Type | Comp ID & Description |  | Est. Hours | Done
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  | Total Hours
 |  | Comments:
 |  | Date Completed: |  |  | Signature:
 |  |  |  |  | Date:
 |  | Week 3
 |  | WO Number | WO Type | Comp ID & Description |  | Est. Hours | Done
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  | Total Hours
 |  | Comments:
 |  | Date Completed: |  |  | Signature:
 |  |  |  |  | Date:
 |  | Week 4
 |  | WO Number | WO Type | Comp ID & Description |  | Est. Hours | Done
 |  |  | PM | 135-005 - BULK FEED - BULK LONG GOODS
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  |  | PM
 |  | Total Hours
 |  | Comments:
 |  | Date Completed: |  |  | Signature:
Spreadsheet: 833165d1686823077-overtime-for-sunday-only-after-a-certain-number-of-hours-worked-query-on-formula
Sheet: Hours 

[NAME]
2023-05-01 00:00:00 | Employee Code | Employee Name |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hours worked | Required Hours | Overtime 1.5/ Short Time | Sunday
 | 1 | EMPLOYEE 1 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 5 | 0 | 0 | 0 | 0 | 9 |  | 117
 | 2 | EMPLOYEE 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 3 | EMPLOYEE 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: 757308d1638186297-sorting-all-barcodes-that-contain-dashes-and-without-dashes-excelforum29-11
Sheet: took original to print 

 |  |  |  | Perferred display of barcode
Barcode | Location | H1 | H2 | Barcode | Location
10007-01 | D1 |  |  | 10007-01 | D1
10007-02 | D1 |  |  | 10007-02 | D1
10007-03 | D1 |  |  | 10007-03 | D1
10007-04 | D1 |  |  | 10007-04 | D1
10007-05 | D1 |  |  | 10007-05 | D1
10007-14 | D1 |  |  | 10007-14 | D1
10007-20 | D1 |  |  | 10007-20 | D1
10007-21 | D1 |  |  | 10007-21 | D1
10007-142 | D1 |  |  | 10007-142 | D1
10007-143 | D1 |  |  | 10007-143 | D1
10012-01 | D9 |  |  | 10012-01 | D9
10012-05 | D9 |  |  | 10012-05 | D9
10012-11 | D9 |  |  | 10012-11 | D9
10030 | C9 |  |  | 10030 | C9
10032 | C9 |  |  | 10032 | C9
10041 | C9 |  |  | 10041 | C9
10049 | C9 |  |  | 10049 | C9
10052 | C9 |  |  | 10052 | C9
11256-01 | A1 |  |  | 11256-01 | A1
11256-02 | A1 |  |  | 11256-02 | A1
Spreadsheet: 852826d1702797465-conditional-formatting-problem-new_rppf-cs-dissolution-calculation-sheet-for-s1-s2-and-s3-aligw
Sheet: Dissolution Average

% Result of Dissolution (S1 + S2 +S3)
Vessel no. | Result | Limit
1 | 90
2 | 91
3 | 92
4 | 93
5 | 94
6 | 95
7 | 96
8 | 81
9 | 98
10 | 99
11 | 100 | Not more than 2 units are less than
12 | 101
13 | 70
14 | 64
15 | 64 | %
16 | 64
17 | 69 | and
18 | 95
19 | 96 | No unit is less than
20 | 97
21 | 98 | %
22 | 99
23 | 100
24 | 101
Average
Minimum
Maximum
SD
%RSD
The amount of dissolved active ingredient |  |  | Q | = | 80 | %
Spreadsheet: 217006d1361963255-which-function-to-find-a-words-in-word-string-and-return-them-extract_list_word_etaf
Sheet: Sheet1

 | What I need | My function | Correct function??
blue car | blue
sport car yellow | yellow
motocycle big |  |  |  |  |  |  |  |  |  |  |  | list of words
green bicycle | green |  |  |  |  |  |  |  |  |  |  | blue
red car | red |  |  |  |  |  |  |  |  |  |  | yellow
[NAME] | white |  |  |  |  |  |  |  |  |  |  | green
sport car |  |  |  |  |  |  |  |  |  |  |  | red
ice cream truck |  |  |  |  |  |  |  |  |  |  |  | white
green car | green |  |  |  |  |  |  |  |  |  |  | etc
etc |  |  |  |  |  |  |  |  |  |  |  | etc
etc |  |  |  |  |  |  |  |  |  |  |  | etc
etc |  |  |  |  |  |  |  |  |  |  |  | etc
etc |  |  |  |  |  |  |  |  |  |  |  | 3000 + rows
etc
3000 + rows
Spreadsheet: 741269d1626944597-formula-to-look-into-sheet-named-here-and-extract-values-into-columns-in-sheet-named-output-extract-values-into-desired-columns-ans-3
Sheet: Here

S/N | Name + Unique # | Name | Sales # | Sales Code | Sales #-1 | Sales #-2 |  |  | Condition | Helper 1 | Helper 2
15 | Desk, Vest - 15 | Desk, Vest | 1234567 | BPC | 1 | 1 |  |  | TNT
1 | Dentist, Coming - 1 | Dentist, Coming | 9999999 | ABB | 1 | 2 |  |  | YTN
1 | Dentist, Coming - 1 | Dentist, Coming | 9999999 | BPC | 1 | 1 |  |  | PNT
1 | Dentist, Coming - 1 | Dentist, Coming | 9999999 | YTN | 2 | 2
2 | Difee, Leopard - 2 | Difee, Leopard | 8888888 | BPC | 1 | 1
4 | [NAME], Mikel - 4 | [NAME], Mikel | 7777777 | BPC | 1 | 1
4 | [NAME], Mikel - 4 | [NAME], Mikel | 7777777 | TNT | 1 | 1
Spreadsheet: 244f593f-77c1-49a1-84c2-4d4cd5ffb001
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
 | Proposal Budget Detailed Summary
 | Project Year ____
 | (Develop a separate summary for each year of the project period.)
A. | PERSONNEL  (Berry employees only) |  | % | % |  | DOLLAR AMOUNT REQUESTED (Omit cents)
 | NAME / ROLE ON PROJECT | TYPE APPT (Months) | ACADEMIC YEAR RELEASE | SUMMER EFFORT | BASE SALARY | AMOUNT REQUESTED | COST SHARE | TOTALS
 |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  | 0 |  | 0
 |  | TOTAL PERSONNEL |  |  |  | 0 | 0 | 0
B. | FRINGE BENEFITS
 | NAME |  | SALARY REQUEST | [NAME] | FRINGE BENEFIT RATE | AMOUNT REQUESTED | COST SHARE | TOTALS
 |  |  | 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
 |  | TOTAL FRINGE BENEFITS |  |  |  | 0 | 0 | 0
C. | TRAVEL
 | Local (describe briefly) |  |  |  |  |  | 0
 | Domestic (describe briefly)
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0 | 0
D. | PRINTING/DUPLICATING |  |  |  |  |  | 0 | 0
E. | COMMUNICATION (Itemize)
 | Phone / fax installation and fees |  |  |  |  |  | 0
 | Long distance phone / fax |  |  |  |  |  | 0
 | Mail / Delivery expenses |  |  |  |  |  | 0 | 0
F. | MAINTENANCE & REPAIRS |  |  |  |  |  | 0 | 0
G. | SUPPLIES (Itemize by category)
 |  |  | 0 |  |  |  | 0
 |  |  | 0 |  |  |  | 0
 |  |  | 0 |  |  |  | 0 | 0
H. | EQUIPMENT (Generally refers only to items over $5,000--Itemize)
 |  |  | 0 |  |  |  | 0
 |  |  | 0 |  |  |  | 0
 |  |  | 0 |  |  |  | 0 | 0
I. | CONSULTANTS / CONTRACTS (Itemize--Specify flat-rate, etc.)
 |  |  | 0 |  |  |  | 0
 |  |  | 0 |  |  |  | 0 | 0
J. | OTHER EXPENSES (Itemize by category)
 |  |  | 0 |  |  |  | 0
 |  |  | 0 |  |  |  | 0 | 0
K. |  | TOTAL DIRECT COSTS (B thru K) |  |  |  |  |  | 0
L. | INDIRECT COSTS/F & A (Specify rate) CHECK WITH FRASP FOR CURRENT INDIRECT COST RATE!
 |  |  | Rate |  | BASE | 0
 |  | TOTAL INDIRECT COSTS/F & A |  |  |  |  |  | 0
M. |  | TOTAL BUDGET (L + M) |  |  |  |  |  | 0
Spreadsheet: 111434d1307802634-add-every-nth-row-summod5
Sheet: Sheet1

Numbers | Row# | Row mod 5
 |  |  |  | << Your answer - Add all col A numbers where Row # mod 5 = 0
Spreadsheet: 52640d1252500532-summary-for-the-next-sheet-dummy1
Sheet: basic

date | item | comments | returned date
2008-11-02 00:00:00 | shoes | good condition
2008-11-03 00:00:00 | bags | good condition
2008-11-04 00:00:00 | shoes | not available
2008-11-05 00:00:00 | shoes | not available
2008-11-06 00:00:00 | shoes | not available
2008-11-07 00:00:00 | bags | not available
2008-11-08 00:00:00 | shirt | bad condition | 2009-01-05 00:00:00
2008-11-09 00:00:00 | bags | not available
2008-11-10 00:00:00 | shirt | not available
Spreadsheet: 819027d1677180933-formula-to-calculate-number-of-cars-in-city-example
Sheet: Status

Miasto/Segment | B | B AUT | C | C AUT | D | D AUT | SUV | VAN 7 os. | E | P+ | MINI LCV | LCV | VAN 9 os. | Mazda | Hyundai | Nissan |  |  | Klasa | [NAME]
Białystok | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | C | BIAŁYSTOK
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | C AUT | POZNAŃ
Gdańsk | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | B | POZNAŃ
Gdynia | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | B AUT | WARSZAWA
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | B | POZNAŃ
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | C | WARSZAWA
Katowice | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | C | GDAŃSK
Kielce | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | C AUT | WARSZAWA
Koszalin | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | D | [NAME]
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | D | POZNAŃ
Legnica | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | D AUT | [NAME]
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | C | BIAŁYSTOK
Łódź | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | C AUT | WARSZAWA
Olsztyn | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | B | KATOWICE
Piotrków [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | C | BIAŁYSTOK
Płock | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | D | WARSZAWA
Poznań | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | C | POZNAŃ
Rzeszów | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | B | BIAŁYSTOK
Siedlce | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | B AUT | WARSZAWA
Szczecin | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Toruń | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Wałbrzych | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Warszawa | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Wrocław | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 683690d1592901711-extract-parentheses-or-extract-word-witout-parentheses-and-three-ip-ranges-sample
Sheet: Sheet1

Attacker Description | check parentheiss and two ranges | check three ranges but igonred ()
10.169.21.37
Multiple (82)
10.179.14.60
::1 (EXECUTIONSCHEDU)
10.179.5.171 (Teslaable-dms-ns)
10.179.6.152 (DMX-D42WDS.org.gov.local)
10.161.0.13
10.179.6.152 (DMX-D42WDS.org.gov.local)
10.169.3.122 (RPG-DC3-A1P-E5W32)
10.179.26.103
10.179.26.103
10.179.26.250
10.179.27.33
10.179.14.60
10.169.2.166 (RPG-ADC-AP-NJ211)
10.161.3.225 (10.161.3.225)
::1 (EXECUTIONSCHEDU1)
10.179.6.152 (DMX-D42WDS.moj.gov.local)
10.179.26.164
10.179.14.60
10.179.27.7
10.169.21.37
10.179.26.111
10.179.26.164
10.179.26.211
10.179.26.120
10.179.26.69 (Fortinet VPN)
10.179.26.43
10.179.26.189
Multiple (2)
10.179.26.31
10.179.28.81
10.179.28.82
10.179.28.83
10.179.28.84
Multiple (7)
Multiple (8)
Multiple (20)
Spreadsheet: sally_beck__33770__NA GAS AND POWER-REGION BREAKOUT 09-06-00 EM
Sheet: US POWER CHARTS

ENRON - POWER
AVERAGE EOL AND NON-EOL TRANSACTIONS PER DAY
REGION BREAKOUT
As of September 6, 2000
 |  | AVERAGE DEALS PER DAY
MONTH | DAYS | EOL | NON-EOL | TOTAL
1999-12-01 00:00:00 | 21 | 7 | 164 | 171
2000-01-01 00:00:00 | 20 | 58 | 422 | 480
2000-02-01 00:00:00 | 20 | 87 | 421 | 509
2000-03-01 00:00:00 | 23 | 108 | 460 | 568
2000-04-01 00:00:00 | 19 | 128 | 492 | 620
2000-05-01 00:00:00 | 22 | 93 | 442 | 534
2000-06-01 00:00:00 | 22 | 96 | 407 | 503
2000-07-01 00:00:00 | 19 | 152 | 473 | 626
2000-08-01 00:00:00 | 23 | 189 | 513 | 702
2000-09-01 00:00:00 | 3 | 179 | 438 | 618
TOTAL AVERAGE | 192 | 104 | 422 | 526
REGION BREAKOUT (Region breakout based on deal locations)
Spreadsheet: 134830d1325664256-solved-if-indirect-v-and-h-lookup-multi-condition-validation-list-index
Sheet: Sheet1

Padding |  | Category | Group A | Group B | Group C | Group D | Group E | Group F | Group G
H47 |  | Group A | APRO 1 | BPRO 1 | CPRO A | D PRO 1 | AB PRO | F 1 | GG1
H57 |  | Group B | APRO 2 | BPRO 2 | CPRO B | D PRO 2 | BC PRO | F 2 | GG2
 |  | Group C | APRO 3 | BPRO 3 | CPRO C | D PRO 3 | CD PRO | F 3 | GG3
 |  | Group D | APRO 4 |  | CPRO D | D PRO 4 | DE PRO | F 4
 |  | Group E | APRO 5 |  | CPRO E | D PRO 5 | EF PRO | F 5
 |  | Group F | APRO 6 |  | CPRO F | D PRO 6
 |  | Group G |  |  | CPRO G | D PRO 7
 |  | End | End | End | End | End | End | End | End
 |  | Padding
 |  | H47
 |  | APRO 1 | APRO 2 | APRO 3 | BPRO 1 | … | … | F 4 | F 5 | GG1 | GG2 | GG3
 |  | Black | Black | Red | Pruple |  |  | Red | Blue | Blue | Red | Black
 |  | White | White | Orange | Yellow |  |  |  | Navy | Red | Orange | red
 |  |  | [NAME] | Blue | Green |  |  |  | Red | White | Yellow
 |  |  |  | White | White |  |  |  |  | Yellow | Blue
 |  |  |  |  | Pink |  |  |  |  | Green | Navy
 |  |  |  |  |  |  |  |  |  |  | Purp
 |  |  |  |  |  |  |  |  |  |  | white
 |  | End | End | End | End | End | End | End | End | End | End | End
 |  | Padding
 |  | H57
 |  | APRO 2 | APRO 3 | BPRO 1 | … | … | F 4 | F 5 | GG1 | GG2 | GG3 | GG3
 |  | Red | Black | Red |  |  | Pruple | Blue | Red | Blue | Blue
 |  | Orange | White |  |  |  | Yellow | Navy | Orange | Red | Navy
 |  | Blue |  |  |  |  | Green | Red | Yellow | White | Red
 |  | White |  |  |  |  | White |  | Blue | Yellow
 |  |  |  |  |  |  | Pink |  | Navy | Green
 |  |  |  |  |  |  |  |  | Purp
 |  |  |  |  |  |  |  |  | white
 |  | End | End | End | End | End | End | End | End | End | End | End
Spreadsheet: 96765d1296060514-using-rand-to-simulate-dealing-cards-blackjack-ace-values
Sheet: Sheet1

 | Card 1 | Card 2 | Card 3 | Card 4 | Card 5 |  |  |  | Card Faces | Card Values
Face: | Ace | Two | Five | King |  |  |  |  | Ace | 11
Value: | 1 | 2 | 5 | 10 |  |  |  |  | King | 10
 |  |  |  |  |  |  |  |  | Queen | 10
Hand Total: | 18 |  |  |  |  |  |  |  | [NAME] | 10
 |  |  |  |  |  |  |  |  | Ten | 10
 |  |  |  |  |  |  |  |  | Nine | 9
 |  |  |  |  |  |  |  |  | Eight | 8
 |  |  |  |  |  |  |  |  | Seven | 7
 |  |  |  |  |  |  |  |  | Six | 6
 |  |  |  |  |  |  |  |  | Five | 5
 |  |  |  |  |  |  |  |  | Four | 4
 |  |  |  |  |  |  |  |  | Three | 3
 |  |  |  |  |  |  |  |  | Two | 2
 |  |  |  |  |  |  |  |  | One | 1
Spreadsheet: 183948d1349100436-need-help-with-conditional-formatting-problem-please-help-tf-performance-2-latest-q3
Sheet: Total ops per client - BAR

Year | 2011
Month | (All) |  |  |  |  |  |  |  |  |  |  | Date | (Multiple Items)
Row Labels | Count of Nominated Cargo Quantity (MT) |  |  |  |  |  |  |  |  |  |  | Row Labels | Sum of Invoiced Ammount ($)
Glencore | 100 |  |  |  |  |  |  |  |  |  |  | Addax | 112971.4219443983
Vitol | 96 |  |  |  |  |  |  |  |  |  |  | Glencore | 252071.2569443327
Nimex | 51 |  |  |  |  |  |  |  |  |  |  | [NAME] | 144193.3333333582
Mercuria | 47 |  |  |  |  |  |  |  |  |  |  | Honeywell | 38763.61111108417
[NAME] | 44 |  |  |  |  |  |  |  |  |  |  | Matrix | 17200.62500002459
Addax | 35 |  |  |  |  |  |  |  |  |  |  | Mercuria | 140153.5866665542
Petrocam SA | 31 |  |  |  |  |  |  |  |  |  |  | Nimex | 95698.33333328643
Trafigura | 29 |  |  |  |  |  |  |  |  |  |  | Trafigura | 42476.2500000561
Energy Culture | 13 |  |  |  |  |  |  |  |  |  |  | Vitol | 240149.8732222516
Noble | 13 |  |  |  |  |  |  |  |  |  |  | Grand Total | 1083678.291555346
Grand Total | 459
 |  | Client | (All)
 |  | Row Labels | Average of Total Fendering Time
 |  | October | 01:04:53
 |  | November | 00:50:26.207000
 |  | December | 00:54:12.258000
 |  | Grand Total | 00:55:30.500000 |  |  | Date | (All)
 |  |  |  |  |  | Year | 2011
 |  |  |  |  |  | Row Labels | Count of Mooring Master
 |  |  |  |  |  | [NAME] | 31
 |  |  |  |  |  | Moses Edege | 28
 |  |  |  |  |  | Young Ogori | 28
 |  |  |  |  |  | [NAME] | 28
 |  |  |  |  |  | Goodness [NAME] | 25
 |  |  |  |  |  | [NAME] | 25
 |  |  |  |  |  | [NAME] | 24
 |  |  |  |  |  | Briseimo Benedict | 21
 |  |  |  |  |  | Alfred E Para | 21
 |  |  |  |  |  | [NAME] | 17
 |  |  |  |  |  | Constain Okain | 16
 |  |  |  |  |  | [NAME] | 15
 |  |  |  |  |  | [NAME] | 15
 |  |  |  |  |  | Philly Okanre | 11
 |  |  |  |  |  | [NAME] | 8
 |  |  |  |  |  | Opuowubo [NAME] | 7
 |  |  |  |  |  | [NAME] | 6
 |  |  |  |  |  | [NAME] | 5
Year | 2011 |  |  |  |  | [NAME] | 3
 |  |  |  |  |  | [NAME] 1 | 3
Row Labels | Average of Total Fendering Time |  |  |  |  | Eurofender | 2
January | 01:04:45.818000 |  |  |  |  | Jamina | 2
February | 01:17:14.634000 |  |  |  |  | Udubor | 1
March | 01:20:00 |  |  |  |  | Dele | 1
April | 01:12:23.478000 |  |  |  |  | [NAME] | 1
May | 01:06:18 |  |  |  |  | Easter Gbokos | 1
June | 01:14:27.342000 |  |  |  |  | [NAME] | 1
July | 01:09:10.526000 |  |  |  |  | Grand Total | 346
August | 01:14:28.571000
September | 01:00:38.667000
October | 01:07:03.750000
November | 00:53:31.154000
December | 00:50:32.381000
Grand Total | 01:07:20.151000
Spreadsheet: 828301d1683372336-calculate-normal-and-after-hours-from-start-and-finish-time-example-time-calculation-take-2
Sheet: Hours

 |  |  |  |  |  |  |  | Function used
 | Start Time: | Finish Time: | STD Time | After Hours | TTL Hours: |  |  | Time | Fractions
 | 23:00:00 | 08:00:00
 |  |  | 7:30-16:30 | 16:30-7:30
 |  | This uses from 16:30 - 7:30 for after hours
topic | https://www.excelforum.com/newreply.php?do=postreply&t=1404939
Spreadsheet: 30084d1225384202-transferring-data-from-a-price-list-to-a-bill-of-materials-ses-grid-tie-dc-power-worksheet-10-24-08
Sheet: PO Vendor 1

7960 - B Soquel Dr. #140 |  |  |  | PO Number
Aptos, Ca. 95003 |  |  |  | PO Date:
Tel: [PHONE] |  |  |  | Shipping Method |  | Best way
Fax: [PHONE] |  |  |  | Shipping Terms |  | Prepay and add
email:  [EMAIL] |  |  |  | Payment Terms |  | Net 30
VENDOR | Attn:  Order entry |  | SHIP TO
 | DC Power Systems
 | 103 West North Street
 | Healdsburg, CA 95448
 | [PHONE] phone
Item |  |  |  |  | Unit Cost | Total Cost
No. | Code | Part # | Description | Quantity | US | US
1 |  |  |  |  |  | 0
2 |  |  |  |  |  | 0
3 |  |  |  |  |  | 0
4 |  |  |  |  |  | 0
5 |  |  |  |  |  | 0
6 |  |  |  |  |  | 0
7 |  |  |  |  |  | 0
8 |  |  |  |  |  | 0
9 |  |  |  |  |  | 0
10 |  |  |  |  |  | 0
11 |  |  |  |  |  | 0
12 |  |  |  |  |  | 0
13 |  |  |  |  |  | 0
14 |  |  |  |  |  | 0
15 |  |  |  |  |  | 0
16 |  |  |  |  |  | 0
17 |  |  |  |  |  | 0
18 |  |  |  |  |  | 0
19 |  |  |  |  |  | 0
20 |  |  |  |  |  | 0
21 |  |  |  |  |  | 0
22 |  |  |  |  |  | 0
23 |  |  |  |  |  | 0
24 |  |  |  |  |  | 0
25 |  |  |  |  |  | 0
 |  |  | Freight Quote By: |  | Freight
 |  |  | Freight Quote Date: |  | Total | 0
Special Instructions
1.  Please send order confirmation with expected ship dates ASAP.
2.  Enter this order in accordance with the prices, terms, delivery method, and specifications listed above.
3.  Notify us immediately of any pricing discrepancies.
Special Shiping Instructions:
1.  Direct shipment to our customer must include copy of Solar Electric Supply Packing List
For questions about this Purchase Order:
[NAME]
[PHONE]     [EMAIL]
Spreadsheet: 583038d1532190028-index-match-with-indirect-book1
Sheet: Sheet4

Branch | Group | Center | Sales | Cost | Expenses | Net
East | GroupA | CenterA
East | GroupA | CenterA
East | GroupA | CenterA
East | GroupA | CenterB
West | GroupB | CenterB
West | GroupB | CenterB
West | GroupB | CenterC
North | GroupB | CenterC
South | GroupB | CenterC
Spreadsheet: 006eae21-26af-4e2f-8d9c-6207e3a57cb9
Sheet: Back to Back

 |  | Month | [NAME] | Min Temp | Min Temp
 |  | Jan | 26 |  | 14
 |  | Feb | 26 |  | 14
 |  | Mar | 24 |  | 13
 |  | Apr | 20 |  | 11
 |  | May | 17 |  | 8
 |  | Jun | 14 |  | 7
 |  | Jul | 13 |  | 6
 |  | Aug | 15 |  | 6
 |  | Sep | 17 |  | 8
 |  | Oct | 20 |  | 9
 |  | Nov | 22 |  | 11
 |  | Dec | 24 |  | 13