tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 852794d1702740323-help-with-vstack-function-digital-operator-production-log
Sheet: Micah S.

Client | Job # | Lettercode/Part | Remake # | Printer | Speed | Scheduled  Time | Start Time | Stop Time | Actual Time | [NAME] | Sheets Printed | Material | [NAME] | Height | # Up | Column1 | Column2 | Square Feet | Sq. Feet / Hr
Client 1 | 243222 | 1 | N | Tauro-1 | 4 Pass | 1 | 15:00:00 | 16:00:00 |  |  | 25 | ART-3111 | 25 | 25
Client 2 | 243333 | 1 | N | Tauro-1 | 4 Pass | 1.88 | 15:00:00 | 17:00:00 |  |  | 33 | ART-3112 | 30 | 40
Client 3 | 243545 | 1 | N | Tauro-1 | 6 Pass | 2.88 | 15:00:00 | 17:30:00 |  |  | 67 | ART-3113 | 50 | 60
Client 4 | 243145 | 1 | N | Tauro-2 | 4 Pass | 3.88 | 15:00:00 | 18:50:00 |  |  | 56 | ART-3114 | 56 | 77
Client 5 | 243676 | 1 | N | 3R-1 | 4 Pass | 0.99 | 15:00:00 | 16:00:00 |  |  | 32 | ART-3115 | 54 | 77
Client 6 | 243000 | 1 | N | 3R-2 | 4 Pass | 0.25 | 15:00:00 | 15:15:00 |  |  | 1 | ART-5445 | 22 | 22
Total
 |  |  |  |  |  |  |  | Press Summary
 |  |  |  |  |  |  |  | Press | Hrs | Sq. Ft | % SchHrs | % of SqFt | Run Time | SqFt/Hr
 |  |  |  |  |  |  |  | GS3250
 |  |  |  |  |  |  |  | HS125
 |  |  |  |  |  |  |  | Tauro-1
 |  |  |  |  |  |  |  | Tauro-2
 |  |  |  |  |  |  |  | 3R-1
 |  |  |  |  |  |  |  | 3R-2
Spreadsheet: 1cd11b2c-12a7-4b11-ae84-d5354438c094
Sheet: 16a

Product |  | TOTAL
Single - Name* | Corporate
 | Loans
 | Municipal
 | Recovery
 | Sovereign
Index Tranche | Asia
 | Europe
 | North America
Index | Asia
 | Europe
 | North America
TOTAL |  | N/A**
Estimated swap dollar volumes, week ending November 16, by product type (total value of trades in millions of USD), all participant types, tenors and currencies. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade. This table will be expanded to reflect participant type and cleared status as more complete data becomes available.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown.
*See Data Dictionary for product descriptions.
**N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 801052d1666051627-generate-list-based-on-multiple-criteria-list-active-projects-by-engineer-list-active-projects-by-engineer-eamono
Sheet: Sheet1

 | Status |  |  |  | Internal Code | customer name | project name | engineers assigned |  | List of what projects [NAME] is working on
 | Design |  |  |  | PLS2209166 | customer a | project name a | [NAME], TJ, [NAME] |  | [NAME]
 | TBA |  |  |  | PLS2209167 | customer b | project name b | [NAME], [NAME]
 | Lost |  |  |  | PLS2209168 | customer c | project name c | [NAME]
 | Feasibility |  |  |  | [NAME] | [NAME] | project name d | [NAME]
 | Quoting |  |  |  | PLS2209170 | customer e | project name e | [NAME],bill,[NAME]
 | Post Design |  |  |  | PLS2209171 |  |  | [NAME]
 | Post Design |  |  |  | [NAME] |  |  | [NAME]
 | Post Design |  |  |  | PLS2209173 |  |  | bill
 |  | List of ACTIVE projects [NAME] is working on |  |  |  |  | Thank you in advance!
 |  | [NAME]
 |  | CONCATENATE(Internal Code b, project name b)
 |  | CONCATENATE(Internal Code d, project name d) |  |  |  | End Goal: list of active projects [NAME] works on. From Column B (status), any of "Design","Quoting","Feasibility","Post Design" are considered active
 |  | etc… |  |  |  | I've figured out how to get a list of internal codes for projects [NAME] works on. However, AND() doesn't return an array like IF() does, so it doesn't fit in my formula
 |  |  |  |  |  | I want to say IF cell[X,I] contains "[NAME]" AND cell[X,B] is one of "Design","Quoting","Feasibility","Post Design" then return true, RETURN AN ARRAY
 |  |  |  |  |  | Where I'm at now:
 |  |  |  |  |  | Current: | Expected: | infuriating, because hardcoding it works as expected:
 |  |  |  |  |  |  | False
 |  |  |  |  |  | True | True
 |  |  |  |  |  | True | False
 |  |  |  |  |  | False | False
 |  |  |  |  |  | True | True
 |  |  |  |  |  | True | False
Spreadsheet: 484323d1476213696-how-to-track-this-by-hours-and-not-days-employee-attendance-orginal-_-as
Sheet: Calendar View

 | EMPLOYEE ATTENDANCE RECORD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Select an Employee: |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Select a Year: |  |  |  |  |  |  |  |  | 2016
 |  |  |  |  |  |  | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S
 |  |  |  |  |  |  |  |  |  |  | PTO hours |  |  |  |  |  |  |  | PTO days |  |  |  |  |  |  | CME days |  |  |  |  |  |  |  | CME hours
Spreadsheet: 885141d1734556879-add-or-remove-rows-to-only-part-of-the-columns-of-a-table-add-or-embedd-a-row-into-columns-of-an-existing-table-example
Sheet: BookRefTeamA

Team A
Surname | First name | Number | [NAME] | Task A | Part of Task A completed | Blind column, just to filter for "TR" task A | Next part of Task A | x1 | Task B | Part of Task B completed | Blind column, just to filter for "TR" task B | Next part of Task B | x2 | Task C | Part of Task C completed | Blind column, just to filter for "TR" task C | Next part of Task C | [NAME] | Task D | Part of Task D completed | Blind column, just to filter for "TR" task D | Next part of Task D
 |  |  |  | M06 | ADV |  |  |  | M25 | ADV |  |  |  | M16 | BSC-SF |  |  |  | M11 | BSC-TR2
 |  |  |  | M07 | ADV |  |  |  | M16 | ADV
 |  |  |  | M15 | X |  |  |  | M05 | X |  |  |  | M04 | X
 |  |  |  | M22 | BSC-SF |  |  |  | M05 | X |  |  |  | M45 | X
 |  |  |  | M15 | BSC |  |  |  | M05 | X |  |  |  | M09 | BSC-SF
Spreadsheet: 152894d1335569473-nested-if-function-to-determine-a-winner-s-and-losers-e08m1minigolf
Sheet: Game2

Round | Jon | [NAME] | [NAME] | Midge
1 | 3 | 3 | 3 | 2
2 | 5 | 2 | 4 | 3
3 | 3 | 3 | 3 | 2
4 | 4 | 3 | 2 | 2
5 | 3 | 1 | 4 | 2
6 | 2 | 2 | 3 | 1
7 | 1 | 2 | 2 | 2
8 | 1 | 1 | 1 | 3
9 | 2 | 2 | 3 | 3
10 | 2 | 2 | 4 | 2
11 | 3 | 3 | 4 | 4
12 | 2 | 1 | 5 | 4
13 | 1 | 2 | 5 | 2
14 | 3 | 4 | 3 | 1
15 | 3 | 2 | 4 | 2
16 | 4 | 4 | 5 | 3
17 | 2 | 2 | 4 | 2
18 | 2 | 2 | 4 | 1
Game Total
Winner=1
Spreadsheet: 677594d1589410909-start-login-hour-of-agent-report-alexxl-
Sheet: Help

 | Start Hour |  | [NAME]
BUCATARU.MADALINA1 | 07:20-07:30
CEAPA.BIANCA1 | 11:20-11:30
FARCAS.ALINA1 | 10:00-10:10
GROSU.IONUT1 | 0
GROZDEA.MIHAELA1 | 0
IACOB.GEORGIANA1 | 10:50-11:00
LUCA.MANUEL1 | 08:20-08:30
LUNGU.IULIAN1 | 08:40-08:50
[NAME] | 09:20-09:30
MOIZE.ROBERT1 | 10:20-10:30
OPREA.ANDREEA1 | 10:00-10:10
PUSCUTA.BOGDANN1 | 08:50-09:00
SANDU.ADRIAN1 | 09:10-09:20
[NAME] | 09:50-10:00
Spreadsheet: 784528d1655812696-mmult-function-in-365-77
Sheet: 00

 | Table 1 |  |  |  |  |  | Array 1: |  | 0 | 0 | 0
 | A | B | C | D
A1 |  | 4 | 1
A2 |  | 5 | 1 |  |  |  |  |  |  | result:
A3 | 3 |  |  |  |  |  | Array 2:
A4 |  |  | 2 |  |  |  |  | 0
A5 | 2 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 | Table 2
 | 1 | 2 | 3 | 4 | 5
A | 2 |  |  |  | 4
B | 3 |  | 5 | 3
C | 1 | 2 | 5 |  | 2
D |  | 2 |  |  | 3
 | Expeted results
 | 1 | 2 | 3 | 4 | 5
A1 |  |  |  |  |  |  |  |  |  | 2 | 25 | 12 | 2
A2 |  |  |  |  |  |  |  |  | 16 | 2 | 30 | 15 | 2
A3 |  |  |  |  |  |  |  |  | 6 | 0 | 0 | 0 | 12
A4 |  |  |  |  |  |  |  |  | 2 | 4 | 10 | 0 | 4
A5 |  |  |  |  |  |  |  |  | 4 | 0 | 0 | 0 | 8
Spreadsheet: darrell_schoolcraft__7901__011025Da
Sheet: LetterSizeRegionLoc 

ETS Planned And Unplanned Outages - May 1, 2001 Through May 31, 2002
Dakota Region Only - Sorted By Region/Location
The information provided is tentative and may be changed without further notice.  Northern Natural Gas, [NAME] and Florida Gas Transmission are not responsible for any reliance on this information.
Data Extracted October 25, 2001 |  |  |  |  |  |  |  |  |  |  | Est. Flow | Est. Vol. |  |  | Act. | Act. | Act. | Act.
No. | ID# | Location | Units | Title | EstStart | EstComp | Duration | Line | Proj. Mgr | W.O. # | Affected | Affected | DescOfWork | DescOfWork2 | Start | Compl. | [NAME]. | Throughput | P/U | Pub | Ver
 |  |  |  |  |  |  |  |  |  |  | (Mmcfd) |  |  |  |  |  | mmcf/d | Affect
1 | 16073 | SO SIOUX | WAYNE CREEK | [NAME] | 2001-10-29 08:00:00 | 2001-10-29 16:00:00 | 0.3 | NEB57001 | 453 | C.014559 | 0 | 0 | Replace and lower approximately 900 feet of the 4" [NAME] at the Logan Creek crossing. |  |  |  | 0 |  | P | N | N
Spreadsheet: 841017d1693268145-display-tables-based-on-drop-down-pull-history-and-highlight-from-conditional-format-dontation-list
Sheet: 300 (ELECTRONICS)

CAT.# | NAME | ADDRESS | CONTACT | PHONE NUMBER | [NAME]
 | Mercy House Community Center | Tia Mica’s Closet & Pantry | 1249 S 111th Ave Cashion, Az 85329 | Mercy Arredondo | [PHONE] | [EMAIL]
 | Glendale Community Action Team | 6261 N 83rd Ave Glendale, AZ 85303 | Aimee Tibbits | [PHONE] | [EMAIL]
 | Boys & Girls Clubs of the Valley | 6420 W Maryland Ave Glendale, AZ 85301 | [NAME] | [PHONE] | [EMAIL]
 | [NAME] Charities | 501 E Roanoke Ave Phoenix, AZ 85004 | [NAME] | [PHONE] | [EMAIL]
 | Marvin's Mission |  | Lucinda | [PHONE]
 | Veterans against sex trafficking |  |  | [PHONE]
 | Sun City FD | 18602 N 99th Ave Sun City AZ 85373 |  | [PHONE]
 | MCSO Dist. 3 | 13063 W. Bell Road surprise, AZ 85374 |  | [PHONE]
 | 4 [NAME] youngtown | 11129 W Michigan Ave | Tanua Donaldson | [PHONE]
 | Halfway Home Rescue |  | [NAME] | [PHONE] | [EMAIL]
 | [NAME]'s Place |  | [NAME] | [PHONE]
 | Mom's Pantry | 13440 N Cave Creek Rd Phoenix, AZ 85022 | [NAME] | [PHONE] | [EMAIL]
 | MCSO Sheriff's Posse | 10861 W Sunland Dr Sun City, AZ | Capt. [NAME] | [PHONE]
Spreadsheet: 794963d1662444565-returning-data-based-on-furthest-right-cell-greater-than-zero-example-6-hd
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | Problem
 | 1 | 10 | 10 | 10 | 0 | 10 | 10 | 10 | 0 | 10 | 10 | 10
 | 2 |  |  |  | 0 |  |  |  | 0
 | 3 |  |  |  | 0 |  |  |  | 0
 | 4 |  |  |  | 1 |  |  |  | 0
 | 5 |  |  |  | 2 |  |  |  | 0
 | 6 |  |  |  | 3 |  |  |  | 0
 | 7 |  | 5 |  | 4 |  | 2 |  | 0
 | 8 |  |  |  | 5 |  |  |  | 1
 | 9 |  |  |  | 6 |  |  |  | 2
 | 10 |  |  |  | 7 |  |  |  | 3
Spreadsheet: 700686d1603290263-furmula-to-reduce-3-columns-to-2-test26-r2
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  | COPIED
 |  |  |  | 0.4 | 0.6 |  | 0.48 | 0.52 |  | 0.4 | 0.6 |  | 0.4 | 0.6 |  | 0.4 | 0.6 |  | 0.4 | 0.6
 |  |  | GEN | TAP | LAB | GEN | TAP | LAB | GEN | TAP | LAB | GEN | TAP | LAB | GEN | TAP | LAB | GEN | TAP | LAB
 |  |  | 100 | 167 | 210 | 68 | 120 | 198 | 97 | 180 | 213 | 100 | 167 | 210 | 100 | 167 | 210 | 100 | 167 | 210
 |  |  | 104 | 173 | 200 | 79 | 128 | 204 | 111 | 200 | 220 | 104 | 173 | 200 | 104 | 173 | 200 | 104 | 173 | 200
 |  |  |  | TAP | LAB |  | TAP | LAB |  | TAP | LAB |  | TAP | LAB |  | TAP | LAB |  | TAP | LAB
 |  |  |  | Nos in Row 5 are the fraction of GEN to be added to TAP and LAB
 |  |  |  | so a table with columns grouped in threes becomes a table with columns grouped in twos
 |  |  |  | I have achieved this by entering formulas by hand but there are over 100 groups so I would like a formula inO8 which could be copied across.
 |  |  | Highlight/ Select cells D11:F13
 |  |  | Cntl C to copy that range to the RIGHT by multiples of 3 cells long (aka 3 Columns long)
 |  |  | Example: | Highlight/ Select cells D11:F13
 |  |  |  |  |  | 1 | 2 | 3 | 1 | 2 | 3 | 1 | 2 | 3 | 1 | 2 | 3 | 1 | 2 | 3
 |  |  | Then copy it in Blocks of 3 Columns to the right
Spreadsheet: 700280d1603112166-searching-for-a-value-with-multiple-criterias-problem3
Sheet: What I have

Name | Year | Alternative year | Pay | Days at work
A | 2017 | 17/18 | 1 | 150 |  |  |  |  |  | 2017 | 17/18
B | 2017 | 17/18 | 2 | 300 |  |  |  |  |  | 2018 | 18/19
C | 2017 | 17/18 | 3 | 254 |  |  |  |  |  | 2019 | 19/20
D | 2017 | 17/18 | 4 | 50
E | 2017 | 17/18 | 5 | 150
F | 2017 | 17/18 | 6 | 194
A | 2018 | 18/19 | 9 | 165
Z | 2018 | 18/19 | 7 | 184
F | 2018 | 18/19 | 8 | 123
B | 2018 | 18/19 | 3 | 122
Z | 2017 | n/a | 8 | 165
V | 2019 | N/A | 9 | 187
Spreadsheet: 454829d1459985150-simplify-calculation-remove-steps-from-existing-sheet-disc-1
Sheet: Sheet2

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ground
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3_Day_Select
500 |  |  |  | Service |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2nd_Day_Air |  |  |  |  |  | Sell | Cost
 |  |  |  | Next_Day_Air |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Next_Day_Saver
 |  |  |  | Next_Day_Saver |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Next_Day_Air
 |  |  |  | 2nd_Day_Air
 |  |  |  | 3_Day_Select
 |  |  |  | GND 1-5
 |  |  |  | GND 6-10
 |  |  |  | GND 11-30
 |  |  |  | GND 31+
 |  |  |  |  |  |  |  |  | Weight |  | Next_Day_Air
 |  |  |  |  |  |  |  |  | 15
Spreadsheet: 797885d1664202744-fqdn-name-strip-with-formula-exmaple-of-results
Sheet: Sheet1

Hostname | [NAME]'s Results | [NAME] expected result (scenario 1) | [NAME] expected result (scenario 2)
10.10.10.10 |  | 10.10.10.10 | 10.10.10.10
hostname1-P.test.com |  | hostname1-P | hostname1-P
hostname2.test.edu |  | hostname2 | hostname2
hostname1.rc.test.org |  | hostname1.rc | hostname1
Fred |  | Fred | Fred
Spreadsheet: 214930d1361198840-sumif-problem-staff-requirements
Sheet: Machine 5

 | Staff [NAME] by Job
Machine: | 5 - KIEFEL
Start Date:
End Date:
Tool | Staff Required | Start Date | End Date
Spreadsheet: 809631d1671189569-finding-a-row-and-column-match-with-a-list-and-return-a-specific-value-attendanceregister
Sheet: Feuil1

 |  | Classes | Mr. [NAME] | Ms. [NAME] | Ms. [NAME] | Mr. [NAME] |  | Exemptions
First name | Last name |  | English | History | Arts | Geography |  | First name | Last name | Classes
 |  | Dates | 2022-10-01 00:00:00 | 2022-11-03 00:00:00 | 2022-11-04 00:00:00 | 2022-12-16 00:00:00 |  | [NAME] | Smith | English
[NAME] | Edwards |  | Present | Present | Present |  |  | [NAME] | Linsey | History
[NAME] | Smith |  | Exempted | Present | Present |  |  | Damian | Milly | Arts
[NAME] | Lamar |  | Present | Present | Present |  |  | Damian | Milly | English
Adele | Otto |  | Absent | Present | Present |  |  | George | Brinley | Geography
[NAME] | Linsey |  | Present | Exempted | Present |  |  | [NAME] | [NAME] | Geography
Genette | Delroy |  | Present | Present | Present
Damian | Milly |  | Exempted | Present | Exempted
George | Brinley |  | Present | Present | Present
[NAME] | [NAME] |  | Present | Present | Present
Spreadsheet: a70a448d-2216-4ede-b8af-c4e05094778c
Sheet: Page 2

Permit No.: |  |  | WQ0002708 |  |  | Facility Name: |  | [NAME] |  |  |  |  |  | County: | Wake |  | Month: |  |  | Year:
Did irrigation occur    at this facility? |  |  |  |  |  | Field Name: |  | 03A |  | Field Name: |  | 03B |  | Field Name: |  | 04A |  | Field Name: |  | 04B
 |  |  |  |  |  | Area (acres): |  | 23.38 |  | Area (acres): |  | 16.71 |  | Area (acres): |  | 21.87 |  | Area (acres): |  | 15.4
 |  |  |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop:
 |  |  |  |  |  | [NAME] (in): |  | 0.16 |  | [NAME] (in): |  | 0.17 |  | [NAME] (in): |  | 0.16 |  | [NAME] (in): |  | 0.18
 |  |  |  |  |  | Annual Rate (in): |  | 42.3 |  | Annual Rate (in): |  | 44.1 |  | Annual Rate (in): |  | 41.4 |  | Annual Rate (in): |  | 40.9
Day | Weather |  |  | Freeboard |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Storage | 5-Day Upset (if applicable) | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading
 |  | ºF | in | ft | ft | gal | min | in | in | gal | min | in | in | gal | min | in | in | gal | min | in | in
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Monthly Loading:
12 Month Floating Total (in):
Spreadsheet: darrell_schoolcraft__7830__shipsummary
Sheet: Sheet4

TRANSWESTERN  PIPELINE
Shipper imbalances
 | 2001-08-31 00:00:00 | 9/2001 | 9/2001 | 2001-09-30 00:00:00 | 2001-10-18 00:00:00 | 10/2001 | 10/2001
Shipper | Balance | activity | payments | Balance | activity | payments | Balance | comments
BP Energy Company |  |  |  | 362637.31 | 0 |  |  | has agreed to payback volumes of 125,856
Duke Energy Trading & Marketing |  |  |  |  |  |  |  | invoiced 8/31/01
Williams Energy Marketing |  |  | -46764.71 | 3821.28
Mirant Americas |  |  |  | 2803.88
Enserco Energy | 16048.18 |  |  |  |  |  |  | invoiced 8/31/01
USGT | 26251 |  |  | 26251.25 |  | -26251 |  | invoiced 8/31/01 - they asked for index backup on 10/8/01
Phillips Petroleum | 7264 |  |  |  |  |  |  | has agreed to 960 mmbtus but wants to see pricing language in tariff
Red Cedar Gathering | 6732 |  |  |  |  |  |  | invoiced 8/31/01- vol equiv pymt in Oct 2001
Aurora Natural Gas | 2362.1 |  |  | 2362.1
PGE Electric | 3412 |  |  |  |  |  |  | invoiced 8/31/01
ENA |  |  |  | 4268.02
Utilicorp | 113
Astra Power | -5.54 |  |  | 246.38
Richardson Products | -180
EES |  |  |  | -1910.98
SMUD | -608 | -158
Tenaska Marketing Ventures | -3718
El Paso Energy Marketing | -8120
PGE Energy Trading
SoCal |  |  |  | -25290.62
Enserch Gas | -29760
Sempra Energy Trading |  |  |  | -92551.75
TXU Energy Trading | 0 | -346
Texaco Natural Gas, Inc |  |  |  |  |  | -134233 |  | invoiced 8/31/01- has agreed to pay
Arizona Public Service | 1610.08 |  | -1610
Dynegy Gas Transportation |  |  |  |  |  | -6531 |  | invoiced 8/31/01- verbal promise to pay on 10/5/01
Burlington Resources Trading |  |  | -125393
Reliant Energy Services |  |  | -73576
Spreadsheet: 676489d1588839100-how-to-conditional-format-a-symbol-trading-dashboard
Sheet: Trading Log

SG Market (Online only)
Minimum commission |  |  |  | 25
SGD | 50000 | and below |  | 0.0028
Above SGD | 50000 | to | 100000 | 0.0022
SGD above | 100000 |  |  | 0.0018
Clearing fee |  |  |  | 0.000325
SGX trading fee |  |  |  | 7.5e-05
US Market (Online only)
Minimum commission |  | 25 | or | 0.0018
SEC Charge |  | 2.21e-05 | (for sale transaction only)
GST for ALL markets |  | 0.07
Trade Date | Counter | Market | Action | No. of Shares | Initial Price | Fees | Cost (USD) | Cost (SGD) | Average Cost | Fx
2020-04-28 00:00:00 | BNO | US | Buy | 2900 | 6 |  |  |  |  | 1.4297
2020-05-01 00:00:00 | BNO | US | Sell | 2900 | 7.0001 |  |  |  |  | 1.4
2020-05-01 00:00:00 | BNO | US | Buy | 2550 | 6.9 |  |  |  |  | 1.42
2020-05-05 00:00:00 | BNO | US | Sell | 550 | 8.06 |  |  |  |  | 1.4048
2020-05-06 00:00:00 | BNO | US | Sell | 2000 | 8.02 |  |  |  |  | 1.4048
2020-05-06 00:00:00 | SDOW | US | Buy | 530 | 33.5963 |  |  |  |  | 1.42
2020-05-07 00:00:00 | SDOW | US | Sell | 530 | 34.48 |  |  |  |  | 1.4048
Spreadsheet: 605717d1547226556-applying-multiple-formulas-to-multiple-columns-ot-version-1
Sheet: Sheet1

Version 1
Position: | 2018-12-30 00:00:00 | Reason: | Code |  | Reason: | Code |  | Reason: | Code |  | Reason: | Code |  | Reason: | Code |  | Reason: | Code |  | Reason: | Code
#1 |  |  | ADDI
#2
#3
#4
#5
Weekly Total:
Position: |  | Reason: | Code |  | Reason: | Code |  | Reason: | Code |  | Reason: | Code |  | Reason: | Code |  | Reason: | Code |  | Reason: | Code
#1
#2
#3
#4
#5
Weekly Total:
Position: |  | Reason: | Code |  | Reason: | Code |  | Reason: | Code |  | Reason: | Code |  | Reason: | Code |  | Reason: | Code |  | Reason: | Code
#1
#2
#3
#4
#5
Weekly Total:
Position: |  | Reason: | Code |  | Reason: | Code |  | Reason: | Code |  | Reason: | Code |  | Reason: | Code |  | Reason: | Code |  | Reason: | Code
#1
#2
#3
#4
#5
Weekly Total:
Position: |  | Reason: | Code |  | Reason: | Code |  | Reason: | Code |  | Reason: | Code |  | Reason: | Code |  | Reason: | Code |  | Reason: | Code
#1 |  |  | ABCDEFGHIJKLM |  |  | ABCDEFGHIJKLM |  |  | ABCDEFGHIJKLM |  |  | ABCDEFGHIJKLM
#2
#3
#4
#5
Weekly Total:
OT by reason % : |  | Shutdown
 |  | Start Up
 |  | Cores
 |  | Clean Broke
 |  | Replace Vacation
 |  | Two Hour Call
 |  | Four hour call
 |  | Foam Floors
 |  | Six hour call (Felt Change)
 |  | Seven hour call
 |  | Water Bottles
 |  | Felt Guiding
 |  | Unknown
Spreadsheet: 287686d1388941450-creating-a-specific-list-from-large-data-set-collections-proposal-ndm
Sheet: Main

 |  | Customer | DATE PAYMENT RCVD | Payment # | LATE FEE ASSESSED?? | LATE FEE | CC FEE | REGULAR MO PAYMENT | ADDITIONAL PAYMENT | TOTAL PAYMENT RCVD | PAYMENT SHORTAGE | Balance Due
1 | XXX0001 | CUST0001 | 2013-08-26 00:00:00 |  |  |  |  | 80.72 |  | 80.72
2 | XXX0002 | CUST0002 | 2013-08-10 00:00:00 |  |  |  |  | 103.31 |  | 103.31
3 | XXX0003 | CUST0003 | 2013-09-05 00:00:00 |  |  |  |  | 85.63 |  | 85.63
4 | XXX0004 | CUST0004 | 2013-09-16 00:00:00 |  |  |  |  | 232.86 |  | 232.86
5 | XXX0005 | CUST0005 | 2013-10-03 00:00:00 |  |  |  |  | 95.7 |  | 95.7
 |  | CUST0001 | 2013-09-13 00:00:00 |  |  |  |  | 80.72 | 19.28 | 100
 |  | CUST0002 | 2013-09-05 00:00:00 |  |  |  |  | 103.31 |  | 103.31
 |  | CUST0003 | 2013-10-16 00:00:00 |  |  |  | 5 | 85.63 |  | 90.63
 |  | CUST0004 | 2013-10-12 00:00:00 |  |  |  |  | 232.86 | 67.14 | 300
 |  | CUST0005 | 2013-11-01 00:00:00 |  |  |  |  | 95.7 |  | 95.7
 |  | CUST0001 | 2013-10-02 00:00:00 |  |  |  |  | 80.72 | 0.28 | 81
 |  | CUST0002 | 2013-10-14 00:00:00 |  | Y | 15 |  | 103.31 |  | 118.31
 |  | CUST0003 | 2013-11-01 00:00:00 |  |  |  | 5 | 85.63 |  | 90.63
 |  | CUST0004 | 2013-11-22 00:00:00 |  |  |  |  | 232.86 | 67.14 | 300
 |  | CUST0005 | 2013-12-10 00:00:00 |  |  |  |  | 95.7 |  | 95.7
 |  | CUST0001 | 2013-11-05 00:00:00 |  |  |  |  |  |  | 100
 |  | CUST0002 | 2013-11-16 00:00:00 |  |  |  |  |  |  | 128
 |  | CUST0004 | 2013-12-11 00:00:00 |  |  |  |  |  |  | 75
 |  | CUST0001 | 2013-12-06 00:00:00 |  |  |  |  |  |  | 81
 |  |  |  |  | out of
 |  |  |  |  | active accts |  |  | shortage
Spreadsheet: 704418d1605540427-calculate-total-s-to-display-2-different-sums-with-excess-of-the-second-to-add-to-first-cmf
Sheet: Sheet1

CMF Order Form
Item Name | [NAME] | Annex Packs | Back Boxes | Back Packs | Booth Boxes | Booth Packs | Total | Total2
Item One | 3 | 15 | 1 | 25 | 4 | 5
Item Two | 7 | 20 | 5 | 17 | 5 | 27
Spreadsheet: 157459d1337753767-automatically-sort-the-data-and-ranking-based-on-the-sorted-data-schedule-calculator
Sheet: Annual Average

 | Employee ID | Name | Annual Average
 | A2733 | [NAME]
 | A978 | Nasrin Warsi
 | A1128 | Rajeev [NAME]
 | A942 | [NAME]
 | A2559 | Sandeep Jain D
 | A378 | [NAME]
 | A3784 | [NAME]
 | RTCS
 | Employee ID | Name | 2012-01-11 00:00:00 | 2012-02-12 00:00:00 | 2012-03-12 00:00:00 | 2012-04-12 00:00:00 | 2012-05-12 00:00:00 | 2012-06-12 00:00:00 | 2012-07-12 00:00:00 | 2012-08-12 00:00:00 | 2012-09-12 00:00:00 | 2012-10-12 00:00:00 | 2012-11-12 00:00:00 | 2012-12-12 00:00:00 | Annual Average
 | A2733 | [NAME] | 0.9943202614379087 | 0.9940694874441004 | 0.9961957813428403
 | A978 | Nasrin Warsi | 0.9960522875816995 | 0.9986728395061727 | 0.9985294117647062
 | A1128 | Rajeev [NAME] | 0.99684789067142 | 0.9955415499533147 | 0.9933853238265001
 | A942 | [NAME] | 0.9957679738562089 | 0.9983954248366016 | 0.9965950824774352
 | A2559 | Sandeep Jain D | 0.9956601307189543 | 0.9967475879240583 | 0.9957747020376779
 | A378 | [NAME] | 0.97918954248366 | 0.9734967320261437 | 0.9742385620915035
 | A3784 | [NAME] | 0.9954621848739494 | 0.9981248054777465 | 0.9984090127278983