tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 126074d1319509197-i-need-help-compiling-a-total-in-excel-from-multiple-worksheets-in-the-same-workbook-goodwill
Sheet: 9-30-2011

[NAME] |  |  | 2011-09-30 00:00:00
 | Item | Quan. | Net  Value | Gross Value
 | 2000 Venture Headlamp | 1 | 65
 | Black Leather Computer Chair | 1 | 40
 | Kids Castle Set | 1 | 30
 | Kids Play Foam Squares  Rug | 1 | 20
 | Hockey Sticks | 3 | 25
 | Kitchen Clock | 1 | 15
 | Large [NAME] | 1 | 20
 | 100 Ft Extention Cord | 1 | 20
 | 50 Ft Extention Cord | 1 | 15
 | 25 Ft Extention Cord | 2 | 10
 | Pants | 1 | 7
 | Shirt | 7 | 5
 | Leather Boots | 1 | 15
 | Cordless Telephone | 1 | 35
 | Swivel Picture Frame | 1 | 10
 | Shower Curtain Rings | 1 | 4
 | Shoe Trees (pair) | 4 | 4
 | Complete Sets of Sheets | 2 | 15
 | New MP4 Player | 1 | 75
 | Towels | 2 | 3
 | New Candle | 1 | 3
 | [NAME] | 1 | 2
 | Miscelaneous Kitchen Items | 10 | 2
 | New Adidas Tennis Shoes | 1 | 30
 | Book | 2 | 4
 | Tie | 10 | 2
 | Laptop Computer IBM With Dock | 1 | 75
 | Infant Dishwasher Basket | 1 | 3
 | [NAME] Shoes | 1 | 10
 | Faux Leather Boots | 1 | 10
 | Sweater | 1 | 5
 | Thumb Nailer | 1 | 200
 | Irrigation Slip Connector (Sprinkler) | 1 | 20
Spreadsheet: 877898d1724837612-search-for-partial-matches-in-a-list-nunez100-example-tms
Sheet: Sheet1

 | Sample edited to cause issue identified
Result | Input Data |  |  |  | Return Values | Search Term
[NAME] | BANK GIRO CREDIT REF Parson |  |  |  | [NAME] | Parson
Nikita Smith | Transfer fia faster payment to Smith 465 |  | Nikita Smith |  | Nikita Smith | Smith
[NAME] | BANK GIRO CREDIT REF Henry 143 |  | [NAME] |  | [NAME] | [NAME]
Nikita Smith | BANK GIRO CREDIT REF Smith |  | Nikita Smith |  | [NAME] | [NAME]
[NAME] | Transfer via faster payment to [NAME] |  | [NAME] |  | Jacinta [NAME] | [NAME]
[NAME] | BANK GIRO CREDIT REF [NAME] |  | *** check *** |  | [NAME] | [NAME]
Jacinta [NAME] | BANK GIRO CREDIT REF Uppham 29 |  | Jacinta [NAME] |  | [NAME] | [NAME]
[NAME] | BANK GIRO CREDIT REF Maguire 463 |  | [NAME] |  | [NAME] | Maguire
[NAME] | Direct Debit Payment to Perry 453 |  | [NAME]
[NAME] | BANK GIRO CREDIT REF Howie 309654 |  | [NAME]
[NAME] | BANK GIRO CREDIT REF Howie 309654 |  | [NAME]
[NAME] | Direct Debit Payment to Parson |  | [NAME]
[NAME] | BANK GIRO CREDIT REF Maguire 463 |  | [NAME]
[NAME] | Transfer via faster payment to [NAME] |  | [NAME]
Jacinta [NAME] | BANK GIRO CREDIT REF Uppham 29 |  | Jacinta [NAME]
[NAME] | Direct Debit Payment to Maguire 463 |  | [NAME]
[NAME] | BANK GIRO CREDIT REF [NAME] |  | [NAME]
 |  |  | Original formula:
 |  |  | Nikita Smith
 |  |  | [NAME]
 |  |  | Nikita Smith
 |  |  | [NAME]
 |  |  | [NAME],[NAME]
 |  |  | Jacinta [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | Jacinta [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
Spreadsheet: 108053d1305153442-if-formula-help-auto-populate-a-bonus-based-on-return-on-sales-model-bonus-structure2
Sheet: Bonus '10 Q3 Metrics  (2)

Salaried Manager Bonus Structure
 | [NAME] | ROS $ | ROS %
Period 1 | 100000 | 10000 | 0.1
Period 2 | 100000 | 15000 | 0.15
Period 3 | 100000 | 20000 | 0.2
Total | 300000 | 45000 | 0.15
 |  | RM | GM
Avg. Weekly Guest Count Growth (Target -55)
Guest Count Growth |  | 0 | 0
Performance Earnings Growth
Performance Earning Groth |  | 0 | 0
Performance Earnings ROS%
0-5% | 15000 | 52.49999999999999 | 112.5
5.01-12% | 630000000 | 9450000 | 29925000
12.01-100% | 0 | 0 | 0
 | 630015000
Simply Great Incentive
Steritech Score of 92% or better | Yes
Secret Shopper Score 100% | Yes
TUAU Top Box - 65% or better | Yes
Food Quality Score of 80% of Better | Yes
Overall Cleanliness Score of 90% of better | Yes
Speed of Service Score of 70% or Better | Yes
If 1=150, 2=300, 3=455, 4=605, 5=760, 6=915 | 6 | $380 | $915
Gross Total |  | 9450432.5 | 29926027.5
Less Tax | 0.3726 | 3521231.1495 | 11150437.8465
Net Total |  | 5929201.350500001 | 18775589.6535
Spreadsheet: 149926d1334195761-formula-index-function-index_example
Sheet: Sheet1

MMR_1 | MMR_2 | MMR_3 | MMR_4 | MMR | UPH1 | UPH2 | UPH3 | UPH4 | UPH5 | UPH6 | UPH7 | UPH8 | UPH9 | UPH10 | UPH11 | UPH
#N/A | #N/A | #N/A | 2 | 2 | #N/A | #N/A | #N/A | 155 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  | ???
Spreadsheet: 601f41e4-4379-4510-8806-8d1131ff15fb
Sheet: Indianpolis 2012-13 (2)

Date/Day | Title
Saturday, August 11, 2012 | Orientation and Overview of Leadership Project
Sunday, August 12, 2012 | Core Course:  MLD 503 Leadership Identity
 | Focus Area: Organizational Leadership 554 Information Technology
 | Focus Area: Not-for-Profit 552 Working with Stakeholders
Saturday October 13, 2012 | Ending seminars for August term
Sunday October 14, 2012 | Core Course:  MLD 501 The Individual in Context
 | Focus Area: Organizational Leadership 551 People and Change
 | Focus Area:  Not-For-Profit 553 Informational Technology
Saturday December 8 2012 | Ending seminars for October term
Sunday December 9, 2012 | Core Course: MLD 505 Critical Analysis of Research
 | Focus Area:  Organizational Leadership 552 Balancing Customer and Organizational  Needs
 | Focus Area:  Not-for-Profit 554 Financial Management for Not-for-Profits
Saturday February 9, 2013 | Ending seminars for December term
Sunday February 10, 2013 | Core Course:  MLD 504 Ethical Decision Making
 | Focus Area:  Organizational Leadership 553 - Financial Management
 | Focus Area:  Not-for-Profit 555 Vision and Strategic Planning
Saturday April 13, 2013 | Ending seminars for February term
Sunday April 14, 2013 | Core Course:  MLD 502 Culture, Creativity and Leadership
 | Focus Area:  Organizational Leadership 555 Vision and Strategic Planning
 | Focus Area: Not-For-Profit 551 Proposal and [NAME]
Saturday June 8, 2013 | Ending seminars for [NAME]
Sunday June 9, 2013 | Focus Area:  Organizational Leadership 599 Capstone/Thesis Project
 | Focus Area:  Not-for-Profit Leadership 599 Capstone/Thesis Project
Saturday August 24, 2013 | Thesis Presentation at Saint Mary-of-the-Woods College Campus
Spreadsheet: 04689a3e-22a5-4ccc-93ea-49fd264fb2cd
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
 | Time Series Workbook
 | 6427.0 Producer Price Indexes, Australia
 | Table 20. Output of the Accommodation and food services industries, group index numbers
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Index Numbers ;  440 Accommodation ; |  |  | Original | A4406608F | 2001-09-01 00:00:00 | 2012-09-01 00:00:00 | 45 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  451 Cafes, restaurants and takeaway food services ; |  |  | Original | A4406633J | 2001-09-01 00:00:00 | 2012-09-01 00:00:00 | 45 | Index Numbers | INDEX | Quarter | 3
© Commonwealth of Australia  2012
Spreadsheet: 141335d1329223647-conditional-formatting-with-two-conditions-example-27-
Sheet: Sheet1

 | Type | Version |  |  |  |  | Type | Current
Name | 4.1 |  |  |  |  |  | 4.1 | 203
Name | 5 |  |  |  |  |  | 5 | 90.1
Name | 4.1
Name | 5
Spreadsheet: 796500d1663318350-how-to-get-the-column-d-correct-birthday-date-with-a-formula-forum09-16-aligw
Sheet: Sheet1

 | date of birth |  | correct date | AliGW
 | 2008-12-19 00:00:00 |  | 2022-12-19 00:00:00
 | 2011-01-14 00:00:00 |  | 2022-01-14 00:00:00
 | 2016-02-29 00:00:00 |  | 2022-02-28 00:00:00
 | 2007-04-04 00:00:00 |  | 2022-04-04 00:00:00
 | 1998-11-08 00:00:00 |  | 2022-11-08 00:00:00
 | 2016-02-28 00:00:00 |  | 2022-02-28 00:00:00
 | 2000-07-09 00:00:00 |  | 2022-07-09 00:00:00
 | 2000-02-29 00:00:00 |  | 2022-02-28 00:00:00
 | 1988-04-24 00:00:00 |  | 2022-04-24 00:00:00
Spreadsheet: 107963d1305089141-excel-2007-sumif-error-when-using-data-from-drop-down-list-excel-issue-with-sumif
Sheet: Regions

 | Sales
Auckland Region
Bay Of Plenty Region
Canterbury Region
Gisborne Region
[NAME]'s Bay Region
Manawatu-Wanganui Region
Marlborough Region
[NAME]
Northland Region
Otago Region
Southland Region
Taranaki Region
Tasman Region
Waikato Region
Wellington Region
West Coast Region
Other
Spreadsheet: mary_fischer__25611__32E-2001
Sheet: E11.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 032E
COMPANY NAME    Enron Building Services, Invest Co
ANALYSIS OF OTHER CURRENT LIABILITIES
FOR THE 6 MONTHS ENDED 6-30-2001
PREPARED BY:[NAME]
EXTENSION:[PHONE] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-11
 |  | 12-31-2000 Balance
 |  | BEGINNING |  | OTHER |  | 03-31-2001 |  | OTHER |  | 06-30-2001 |  | OTHER |  | 09-30-2001 |  | OTHER |  | 12-31-2001
[NAME] |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE
 |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.)
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Total Other Current Liabilities
(must tie to Hyperion account 655) | * |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *
Income Accts:  DR/(CR)
Reverse signs from Hyperion
Spreadsheet: 64033d1264894340-i-have-daily-data-i-want-to-turn-into-monthly-by-adding-excel_help_71606
Sheet: Sheet1

Date | Sales |  | 2010-01-01 00:00:00 | 2010-02-28 00:00:00 | 2010-03-31 00:00:00
2010-01-01 00:00:00 | 5000 |  | 155000 | 140000 | 5000
2010-01-02 00:00:00 | 5000
2010-01-03 00:00:00 | 5000
2010-01-04 00:00:00 | 5000
2010-01-05 00:00:00 | 5000
2010-01-06 00:00:00 | 5000
2010-01-07 00:00:00 | 5000
2010-01-08 00:00:00 | 5000
2010-01-09 00:00:00 | 5000
2010-01-10 00:00:00 | 5000
2010-01-11 00:00:00 | 5000
2010-01-12 00:00:00 | 5000
2010-01-13 00:00:00 | 5000
2010-01-14 00:00:00 | 5000
2010-01-15 00:00:00 | 5000
2010-01-16 00:00:00 | 5000
2010-01-17 00:00:00 | 5000
2010-01-18 00:00:00 | 5000
2010-01-19 00:00:00 | 5000
2010-01-20 00:00:00 | 5000
2010-01-21 00:00:00 | 5000
2010-01-22 00:00:00 | 5000
2010-01-23 00:00:00 | 5000
2010-01-24 00:00:00 | 5000
2010-01-25 00:00:00 | 5000
2010-01-26 00:00:00 | 5000
2010-01-27 00:00:00 | 5000
2010-01-28 00:00:00 | 5000
2010-01-29 00:00:00 | 5000
2010-01-30 00:00:00 | 5000
2010-01-31 00:00:00 | 5000
2010-02-01 00:00:00 | 5000
2010-02-02 00:00:00 | 5000
2010-02-03 00:00:00 | 5000
2010-02-04 00:00:00 | 5000
2010-02-05 00:00:00 | 5000
2010-02-06 00:00:00 | 5000
2010-02-07 00:00:00 | 5000
2010-02-08 00:00:00 | 5000
2010-02-09 00:00:00 | 5000
2010-02-10 00:00:00 | 5000
2010-02-11 00:00:00 | 5000
2010-02-12 00:00:00 | 5000
2010-02-13 00:00:00 | 5000
2010-02-14 00:00:00 | 5000
2010-02-15 00:00:00 | 5000
2010-02-16 00:00:00 | 5000
2010-02-17 00:00:00 | 5000
2010-02-18 00:00:00 | 5000
2010-02-19 00:00:00 | 5000
2010-02-20 00:00:00 | 5000
2010-02-21 00:00:00 | 5000
2010-02-22 00:00:00 | 5000
2010-02-23 00:00:00 | 5000
2010-02-24 00:00:00 | 5000
2010-02-25 00:00:00 | 5000
2010-02-26 00:00:00 | 5000
2010-02-27 00:00:00 | 5000
2010-02-28 00:00:00 | 5000
2010-03-01 00:00:00 | 5000
Spreadsheet: 148441d1333403385-alternative-for-pivot-table-row-data-example-alternative-pivot
Sheet: Sheet1

ColumnA | ColumnB |  |  |  | ColumnB | 100 |  |  |  | Parameter | 100
A _ F | 100
A _ F | 100 |  |  |  | Row Labels |  |  |  |  | Result
B _ F | 200 |  |  | Pivot | A _ F |  |  |  |  | A _ F
B _ F | 200 |  |  |  | A _ G |  |  |  |  | A _ G
B _ F | 200 |  |  |  | E _ G |  |  |  |  | E _ G
B _ F | 200 |  |  |  | Grand Total
B _ F | 200
B _ F | 200
B _ F | 200 |  | Source
B _ F | 200
B _ F | 200
A _ G | 100
C _ G | 300
A _ G | 100
A _ G | 100
A _ G | 100
D _ G | 300
E _ G | 100
Spreadsheet: 64280d1265147706-backlog-priority-formulas-whiteboard
Sheet: Distribution

Distribution
GROUPs | R | T | S | M | Total
Days x Total | 210936 | 127832 | 97774 | 48 | 436542
Days old | 68 | 76 | 62 | 4 | 76
Total files | 3102 | 1682 | 1577 | 12 | 6361
Volume percentage | 0.4876591730859928 | 0.2644238327307027 | 0.2479169941833045 | 0.001886495833988367 | 1
Average/day | 45.61764705882353 | 22.13157894736842 | 25.43548387096774 | 3 | 83.69736842105263
Percentage | 0.4831974930247261 | 0.2928286396268858 | 0.223973867348388 | 0.0001099550558709128 | 1
GROUPs | R | T | S | M | Enter number of checks requested
 | 4.831974930247261 | 2.928286396268858 | 2.23973867348388 | 0.001099550558709128 | 10
10 | 5 | 3 | 2 | 0
Distribute | 5 | 3 | 2 | 0 | 10
Spreadsheet: 107610d1304720884-vlookup-function-grocery
Sheet: Categories

SKU | Category
10635 | Personal Care
10954 | Dairy
12771 | Drinks
13909 | Vegetables
14002 | Vegetables
14236 | Staples
14392 | Bulk Foods
15368 | Dairy
16100 | Dairy
18748 | Miscellaneous
19595 | Staples
20010 | Miscellaneous
20974 | Miscellaneous
21982 | Staples
22995 | Vegetables
23913 | Fruits
24156 | Vegetables
24273 | Personal Care
24814 | Staples
26541 | Miscellaneous
26543 | Miscellaneous
27661 | Fruits
28765 | Miscellaneous
28794 | Miscellaneous
29923 | Miscellaneous
31542 | Meat
32307 | Vegetables
32533 | Bulk Foods
32599 | Personal Care
32906 | Fruits
33380 | Meat
33775 | Miscellaneous
34619 | Vegetables
37459 | Miscellaneous
37765 | Miscellaneous
37856 | Vegetables
38396 | Vegetables
38765 | Vegetables
39387 | Dairy
43256 | Miscellaneous
44258 | Meat
44546 | Bulk Foods
44765 | Vegetables
44841 | Meat
44991 | Miscellaneous
45505 | Miscellaneous
45637 | Miscellaneous
47026 | Bulk Foods
47698 | Personal Care
49328 | Dairy
49887 | Miscellaneous
50223 | Miscellaneous
51437 | Staples
52157 | Vegetables
52417 | Bulk Foods
53426 | Miscellaneous
53459 | Meat
53767 | Personal Care
53933 | Dairy
54595 | Fruits
55118 | Bulk Foods
56848 | Drinks
56894 | Vegetables
57310 | Staples
57939 | Bulk Foods
58572 | Meat
60074 | Miscellaneous
60252 | Bulk Foods
61597 | Bulk Foods
61779 | Bulk Foods
61869 | Personal Care
64147 | Staples
65274 | Miscellaneous
65364 | Bulk Foods
65432 | Miscellaneous
65472 | Vegetables
65898 | Fruits
66074 | Personal Care
66537 | Staples
66878 | Drinks
67127 | Meat
67330 | Drinks
70645 | Miscellaneous
71084 | Fruits
71363 | Meat
71511 | Vegetables
72979 | Dairy
73547 | Bulk Foods
73834 | Vegetables
73943 | Personal Care
74411 | Bulk Foods
74587 | Personal Care
74769 | Fruits
75682 | Vegetables
75932 | Vegetables
76548 | Miscellaneous
76754 | Personal Care
78407 | Staples
78765 | Miscellaneous
78776 | Dairy
79849 | Drinks
79853 | Fruits
80500 | Dairy
81654 | Personal Care
81828 | Fruits
83789 | Personal Care
84419 | Miscellaneous
85907 | Dairy
87004 | Fruits
87073 | Drinks
87564 | Miscellaneous
87653 | Miscellaneous
87740 | Fruits
89908 | Staples
90148 | Vegetables
90781 | Fruits
90946 | Personal Care
91502 | Fruits
91619 | Vegetables
91837 | Personal Care
92763 | Miscellaneous
92866 | Bulk Foods
95530 | Personal Care
95971 | Fruits
98123 | Miscellaneous
98364 | Miscellaneous
98625 | Dairy
98765 | Miscellaneous
98799 | Miscellaneous
98934 | Miscellaneous
99015 | Vegetables
99093 | Personal Care
99248 | Vegetables
Spreadsheet: 267140d1379966867-ranking-formula-index-match-tutorial
Sheet: Tutorial 2

 |  | Ok, we got down the basics. Let's complicate things!
 |  | System ID | Callout Date | Callout Time | [NAME] |  | Unique Rank Maker
 |  | black | 2013-07-01 00:00:00 | 09:30:00 | 2013-07-01 00:00:00
 |  | white | 2013-07-07 00:00:00 | 11:15:00 | 2013-07-07 00:00:00
 |  | black | 2013-07-11 00:00:00 | 08:15:00 | 2013-07-11 00:00:00
 |  | white | 2013-07-16 00:00:00 | 09:45:00 | 2013-07-16 00:00:00
 |  | black | 2013-08-01 00:00:00 | 08:00:00 | 2013-08-01 00:00:00
 |  | white | 2013-08-06 00:00:00 | 09:30:00 | 2013-08-07 00:00:00
 |  | pink | 2013-08-13 00:00:00 | 09:15:00 | 2013-08-13 00:00:00
 |  | pink | 2013-08-17 00:00:00 | 09:30:00 | 2013-08-17 00:00:00
 |  | Black
 | rank | System ID | Callout Date | Callout Time | [NAME]
 |  | White
 |  | System ID | Callout Date | Callout Time | [NAME]
 |  | System ID | Callout Date | Callout Time | [NAME]
Spreadsheet: 41831d1240356998-only-need-first-instance-of-sumif-in-a-column-example-sumif-too-many
Sheet: Example Book Sumif

RECIPE    # | MENU  ITEMS | COOKING PROCESS
 |  |  | REIM-BURSED
 | Group I |  |  |  | SUMIF
500 | CHOW FUN  K-6TH | SD | 347 |  | 526
569 | CHIPS, PRETZEL, TINY TWISTS | NC | 1920 |  | 2312
246 | FRUIT, JUICE, ASSORTED | NC | 846 |  | 846
500 | CHIPS, TORTILLA,  BULK | NC | 145 |  | 526
569 | CHIPS, PRETZEL, TINY TWISTS | NC | 100 |  | 2312
557 | BURRITO, BEAN & CHEESE | SD | 139 |  | 249
553 | HAMBURGER ON BUN | SD | 190 |  | 484
758 | TRANSPORT EGG ROLL W/RICE | SD | 117 |  | 187
500 | CHOW FUN  K-6TH | SD | 34 |  | 526
569 | CHIPS, PRETZEL, TINY TWISTS | NC | 292 |  | 2312
557 | BURRITO, BEAN & CHEESE | SD | 110 |  | 249
758 | SPAGHETTI W/MEAT & CHEESE  K-6TH | SD | 41 |  | 187
553 | HAMBURGER ON BUN | SD | 294 |  | 484
758 | TRANSPORT EGG ROLL W/RICE | SD | 29 |  | 187
Spreadsheet: 150679d1334659351-changing-times-into-easier-data-to-section-attacks-in-football-attack-types
Sheet: Edit list...

start time | end time | category | Time of Attacks
00:00:17:62 | 00:00:18:69 | combinative attack
00:00:21:95 | 00:00:22:78 | direct attack |  |  |  |  | combinative attacks | direct attacks
00:00:24:38 | 00:00:25:19 | combinative attack |  |  |  | 0-5 mins
00:00:27:24 | 00:00:29:06 | combinative attack |  |  |  | 6-10 mins
00:05:22:79 | 00:05:23:48 | combinative attack |  |  |  | 11-15mins
00:05:25:32 | 00:05:25:98 | combinative attack
00:05:26:49 | 00:05:27:06 | combinative attack
00:05:27:51 | 00:05:28:14 | combinative attack
00:05:28:66 | 00:05:29:20 | combinative attack
00:05:30:04 | 00:05:30:53 | direct attack
00:05:31:33 | 00:05:31:74 | combinative attack
00:05:32:05 | 00:05:32:69 | combinative attack
00:05:33:16 | 00:05:33:83 | combinative attack
00:05:34:31 | 00:05:34:92 | combinative attack
00:05:35:67 | 00:05:36:13 | direct attack
00:05:36:60 | 00:05:37:04 | direct attack
00:10:51:52 | 00:10:52:69 | combinative attack
[NAME] | 00:10:53:94 | direct attack
00:10:54:65 | 00:10:55:51 | direct attack
00:10:56:42 | 00:10:57:28 | direct attack
00:10:58:10 | 00:10:59:09 | direct attack
00:10:59:80 | 00:11:00:54 | direct attack
00:11:01:26 | 00:11:01:99 | direct attack
00:11:02:63 | 00:11:03:34 | direct attack
00:11:03:95 | 00:11:04:71 | direct attack
Spreadsheet: 376744d1423690892-problem-calculating-fractions-oeldere-376740d1423690324-problem-calculating-fractions-2-15
Sheet: Letter

 |  |  |  | .
Project No. | Specialist | [NAME] | Activity | Gross Amt | Expenses | Net Amount
1 |  | Smith | Sale | 10 | -3.333 | 6.66 | The Net Amount is off by one cent |  |  |  |  |  | 10 | 3.333333333333333 | 6.666666666666667
2 |  | Jones | Sale | 15 | -4.999 | 10 |  |  |  |  |  |  | 15 | 5 | 10
3 |  | [NAME] | Sale | 20 | -6.666 | 13.33 |  |  |  |  |  |  | 20 | 6.666666666666666 | 13.33333333333333
4 |  | [NAME] | Sale | 25 | -8.332 | 16.66 | The Net Amount is off by one cent |  |  |  |  |  | 25 | 8.333333333333332 | 16.66666666666667
5 |  | [NAME] | Sale | 50 | -16.665 | 33.33 |  |  |  |  |  |  | 50 | 16.66666666666666 | 33.33333333333334
6 |  | Fox | Sale | 75 | -24.997 | 50 |  |  |  |  |  |  | 75 | 25 | 50
7 |  | Piazza | Sale | 100 | -33.33 | 66.67 |  |  |  |  |  |  | 100 | 33.33333333333333 | 66.66666666666667
8 |  | Kilgore | Sale | 200 | -66.66 | 133.34 |  |  |  |  |  |  | 200 | 66.66666666666666 | 133.3333333333333
 |  |  |  | 495 | -164.982 | 330.018 |  |  |  |  |  |  |  | 165 | 330
Total Remit |  |  |  |  |  | 329.99 | This number is also off because of the values of G3:G10
Spreadsheet: 759561d1639592445-error-trapping-if-and-multiple-cells-must-all-have-error-sample-12-1-
Sheet: Sheet1

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |  | CHECK | CHECK | CHECK | CHECK | CHECK | CHECK | CHECK | CHECK
5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 |  |  |  |  |  |  |  |  |  |  | if statement here to check J through Q; if all are #N/A then write "error" otherwise stay blank
5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 |  |  |  |  |  |  |  |  |  |  | if statement here to check J through Q; if all are #N/A then write "error" otherwise stay blank
 |  |  |  |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  | if statement here to check J through Q; if all are #N/A then write "error" otherwise stay blank
5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 |  |  |  |  |  |  |  |  |  |  | if statement here to check J through Q; if all are #N/A then write "error" otherwise stay blank
Spreadsheet: 889506d1740348112-sequential-numbering-of-cells-based-on-date-sample-transfer-entry
Sheet: Upload Template

tranId | subsidiary | tranDate | Name | journalItemLine_memo | journalItemLine_debitAmount | journalItemLine_creditAmount | Memo
 | Organization | 2025-02-10 00:00:00 |  | Transfer from Account 3755 | 20235.77 |  | Transfer
 | Organization | 2025-02-10 00:00:00 |  | Transfer to Account 3730 |  | 20235.77 | Transfer
 | Organization | 2025-02-10 00:00:00 |  | Transfer to Account 7507 |  | 7305.13 | Transfer
 | Organization | 2025-02-10 00:00:00 |  | Transfer from Account 3755 | 7305.13 |  | Transfer
 | Organization | 2025-02-11 00:00:00 |  | Transfer from Account 3755 | 5594.44 |  | Transfer
 | Organization | 2025-02-11 00:00:00 |  | Transfer to Account 7507 |  | 11200 | Transfer
 | Organization | 2025-02-11 00:00:00 |  | Transfer to Account 3730 |  | 5594.44 | Transfer
 | Organization | 2025-02-11 00:00:00 |  | Transfer from Account 3755 | 11200 |  | Transfer
 | Organization | 2025-02-12 00:00:00 |  | Transfer to Account 3755 |  | 275 | Transfer
 | Organization | 2025-02-12 00:00:00 |  | Transfer from Account 3755 | 817.2 |  | Transfer
 | Organization | 2025-02-12 00:00:00 |  | Transfer from Account 3105 | 275 |  | Transfer
 | Organization | 2025-02-12 00:00:00 |  | Transfer to Account 7507 |  | 10912.05 | Transfer
 | Organization | 2025-02-12 00:00:00 |  | Transfer to Account 3730 |  | 817.2 | Transfer
 | Organization | 2025-02-12 00:00:00 |  | Transfer from Account 3755 | 10912.05 |  | Transfer
 | Organization | 2025-02-13 00:00:00 |  | Transfer from Account 3755 | 979069.34 |  | Transfer
 | Organization | 2025-02-13 00:00:00 |  | Transfer to Account 3730 |  | 979069.34 | Transfer
 | Organization | 2025-02-13 00:00:00 |  | Transfer to Account 7507 |  | 250 | Transfer
 | Organization | 2025-02-13 00:00:00 |  | Transfer from Account 3755 | 250 |  | Transfer
 | Organization | 2025-02-14 00:00:00 |  | Transfer from Account 3755 | 138491.75 |  | Transfer
 | Organization | 2025-02-14 00:00:00 |  | Transfer to Account 3730 |  | 138491.75 | Transfer
 | Organization | 2025-02-14 00:00:00 |  | Transfer to Account 7507 |  | 15688.27 | Transfer
 | Organization | 2025-02-14 00:00:00 |  | Transfer from Account 3755 | 15688.27 |  | Transfer
Spreadsheet: 884555d1733793177-roi-formula-2024-tos-trades-test-1-
Sheet: Sheet1

DATE | [NAME] | ACTION | SIZE | EQ | SERIES | INSTRUMENT | STOP | SPREAD | POINTS | COST/CREDIT | NET P/L | ROI |  |  |  |  | Combined Formula
 |  |  |  |  |  |  |  |  |  |  |  |  |  | SB | S | B | S | B
2024.12.04 | ~12:15 | STO | 3 | ROKU | 2024.12.06 | PUT Vertical 81/78 | 79 | .46/.13 | 0.33 | 0.99 | 95.03
2024.12.06 | 11:45:00 | STO | 2 | COST | 2024.12.06 | PUT Vertical 990/985 | 991 | 1.01/.31 | 0.69 | 1.38 | 137.34
2024.12.06 | 11:45:00 | STC | 2 | COST | 2024.12.06 | PUT Vertical 990/985 |  | 1.05/.295 | -0.75 | -1.5 | -153.65
2024.12.06 | 12:32:00 | STO | 2 | COST | 2024.12.06 | PUT Vertical 990/985 | 991 | 1.20/.32 | 0.88 | 1.76 | 173.34
2024.12.06 | 15:51:00 | STC | 2 | COST | 2024.12.06 | PUT  990 |  | 0.17 | 0.17 | -3.5 | -35.32