tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 26898d1219535990-running-balance-payment-formula-money
Sheet: Sheet1

Where's My Money?
Bills Paid |  |  |  |  |  |  |  |  |  | Bills Owed
 |  | Date |  | Name |  | What | Amount | Notes |  |  | Name | What | Total Amount | Minimum Payment | Interest | Due Date | Pay off Date | Pay off Amount | Notes
Pawns |  | 2008-08-23 00:00:00 |  | [NAME] |  | Taurus 9mm | 30 |  |  | Pawns | [NAME] | Taurus 9mm | 150 | 30 | 240 | 2008-09-26 00:00:00 |  | 180
 |  |  |  |  |  | S&W 40 Cal | 30 |  |  |  |  | S&W 40 Cal | 150 | 30 | 240 | 2008-09-26 00:00:00 |  | 180
 |  | 2008-08-23 00:00:00 |  | Meridian Coin and Pawn |  | Engfield 30-30 | 10 |  |  |  | Meridian Coin and Pawn | Engfield 30-30 |  |  |  |  |  | 110
 |  |  |  |  |  | Camera | 16 |  |  |  |  | Camera |  |  |  | 2008-09-15 00:00:00 |  | 48
Loans |  | 2008-08-23 00:00:00 |  | Northwest Title Loans |  | Saturn | 30 |  |  | Loans | Northwest Title Loans | Saturn |  |  |  | 2008-09-26 00:00:00
 |  |  |  | Continental Loans |  | Loan | 0 |  |  |  | Continental Loans | Loan | 150 | 45 |  | 2008-09-12 00:00:00
 |  |  |  |  |  |  |  |  |  |  | Money Tree | Loan
 |  |  |  |  |  |  |  |  |  |  | Crow | Bail Money | 500 | 50 |  |  |  | 500
 |  |  |  |  |  |  |  |  |  |  | Roel |  | 200 |  |  |  |  | 200
 |  | Date
Home & Utilities |  |  |  |  |  |  |  |  |  | Home & Utilities | Rent
Spreadsheet: 231672d1367181822-filter-list-results-dependent-on-another-filter-list-form-test-1
Sheet: Form

 | Course Required (TNA / Computer Skills) Which Version of Microsoft Office is used 2003/2007/2010 | Forename | Surname | Job Title | Division | Service | Specialism | Team
 | SELECT |  |  |  | Specialised Service
 | What should happen now is that having selected an option in F2; G2, H2 and I2 should only display the following filter options from the full lists shown on the Data sheet:
 |  |  |  |  | Specilised Service | Specialised Community Services | Support Services | Woodlands
 |  |  |  |  |  | Local Community Teams | SCS Community | Building Costs
 |  |  |  |  |  | Community Management | SCS Dental | C & A Community - Ame
 |  |  |  |  |  |  | OCTC | HV Central
 |  |  |  |  |  |  | OCS Management | OCTC
 | Another example is as shown below.  Under the Specialism heading N/A should display because Community Services has been selected and there is no Specialism for this group:
 |  |  |  |  | Community Services | Community CAMHS | N/A | Wenric House
 |  |  |  |  |  | Urgent Care Management |  | Thames House
 |  |  |  |  |  |  |  | FASS
 |  |  |  |  |  |  |  | Cotswold House
 |  |  |  |  |  |  |  | Highfield
Spreadsheet: 57186d1257339213-comparing-grades-text-to-give-a-numerical-score-andy_27-2
Sheet: Data

Surname Forename | Registration Group | Gender | Predicted [NAME] 1 | Actual Grade Subject 1 | Subject Points | Predicted Grade Subject 2 | Actual Grade Subject 2 | Subject Points | Predicted Grade Subject 2 | Actual Grade Subject 2 | Subject Points | Predicted Grade Subject 3 | Actual Grade Subject 3 | Subject Points | Predicted Grade Subject 3 | Actual Grade Subject 3 | Subject Points | Predicted [NAME] 4 | Actual [NAME] 4 | Subject Points | Predicted [NAME] 4 | Actual [NAME] 4 | Subject Points | Predicted Grade Subject 5 | Actual Grade Subject 5 | Subject Points | Predicted Grade Subject 5 | Actual Grade Subject 5 | Subject Points | Predicted [NAME] 6 | Actual [NAME] 6 | Subject Points | Predicted [NAME] 6 | Actual [NAME] 6 | Subject Points | Predicted [NAME] 7 | Actual [NAME] 7 | Subject Points | Predicted [NAME] 7 | Actual [NAME] 7 | Subject Points | Predicted Grade Subject 8 | Actual Grade Subject 8 | Subject Points | Predicted Grade Subject 8 | Actual Grade Subject 8 | Subject Points | Predicted [NAME] 9 | Actual [NAME] 9 | Subject Points | Predicted [NAME] 9 | Actual [NAME] 9 | Subject Points | Predicted [NAME] 10 | Actual [NAME] 10 | Subject Points | Predicted [NAME] 10 | Actual [NAME] 10 | Subject Points | Predicted [NAME] 11 | Actual [NAME] 11 | Subject Points | Predicted [NAME] 11 | Actual [NAME] 11 | Subject Points | Predicted [NAME] 12 | Actual [NAME] 12 | Subject Points | Predicted [NAME] 12 | Actual [NAME] 12 | Subject Points | Predicted [NAME] 13 | Actual [NAME] 13 | Subject Points | Predicted [NAME] 13 | Actual [NAME] 13 | Subject Points | Total Points
Pupil 1 |  |  | D | C |  | D | C |  | D | D |  | D | D |  |  |  |  |  |  |  | D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E | D |  | D | C |  |  |  |  | E | C |  |  |  |  |  |  |  | C
Pupil 2 |  |  | D | D |  | D | U |  | D | E |  | D | D |  |  |  |  |  |  |  | D |  |  |  |  |  |  |  |  | D | E |  |  |  |  |  |  |  |  |  |  | D | C |  | D |  |  | E | D |  |  |  |  |  |  |  |  |  |  | D
Spreadsheet: 487526d1478117492-select-random-product-stock-ids-copy-of-product_list-1
Sheet: Sheet1

Category | Product | Product ID | Sum of Amount | Sum of Rand |  | Random Rank |  |  | Rank | Category | Product | Product ID | Sum of Amount
Beverages | Product D | DD00287 | 133 | 0.2004606091002095 |  |  |  |  | 1
Beverages | Product D | DD00288 | 134 | 0.8680032796176117 |  |  |  |  | 2
Beverages | Product E | DD00306 | 152 | 0.1753158636128634 |  |  |  |  | 3
Beverages | Product E | DD00307 | 153 | 0.7342669592530858 |  |  |  |  | 4
Beverages | Product F | DD00350 | 196 | 0.3904124174578431 |  |  |  |  | 5
Beverages | Product F | DD00351 | 197 | 0.7123596114376893
[NAME] | Product A | DD00159 | 55 | 0.3119563110901007
[NAME] | Product A | DD00164 | 10 | 0.6686392086802285
[NAME] | Product B | DD00242 | 88 | 0.06684176421360821
[NAME] | Product B | DD00243 | 89 | 0.08926209342134428
[NAME] | Product C | DD00254 | 100 | 0.2791756106739161
[NAME] | Product C | DD00255 | 101 | 0.09040321680898489
Grand Total |  |  | 1408 | 4.587096945367485
Spreadsheet: 529593d1500911940-linking-one-slicer-to-multiple-tables-not-pivot-tables-in-excel-2016-slicer-for-2-tables
Sheet: Sheet1

Name |  | Name
Name4 |  | Name4
Name3 |  | [NAME]
[NAME] |  | [NAME]
[NAME] |  | Name4
Name1 |  | [NAME]
Name3 |  | Name3
Name1 |  | [NAME]
Name5 |  | [NAME]
Name5 |  | Name5
[NAME] |  | Name3
Name1 |  | Name3
Name3 |  | [NAME]
Name1 |  | [NAME]
Name1 |  | Name3
Name4 |  | Name3
Name3 |  | Name3
Name5 |  | Name3
Name3 |  | [NAME]
Name3 |  | Name5
[NAME] |  | Name5
Spreadsheet: a1a7af5c-f8fa-4ccb-9fc1-7aec389ef510
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
 | [NAME]
 |  |  |  | Giancla | Davide |  | Delta | Delta %
 | INSERIRE UNA FORMULA
 |  | spazi inclusi |  | 4171 | 6120 |  | 1949 | 0.4672740350035963
 |  | spazi esclusi |  | 3543 | 5217 |  | 1674 | 0.4724809483488569
 |  | Pagine |  | 1 | 1.5
 | SOMMA.SE()
 |  | spazi inclusi |  | 5590 | 6529 |  | 939 | 0.1679785330948122
 |  | spazi esclusi |  | 4741 | 5532 |  | 791 | 0.1668424383041552
 |  | Pagine |  | 1,5 | 2
Spreadsheet: 843465d1695290062-calculate-amounts-depending-on-working-days-sample
Sheet: Sheet1

 | NAME | 2023-10-01 00:00:00 | 2023-10-02 00:00:00 | 2023-10-03 00:00:00 | 2023-10-04 00:00:00 | 2023-10-05 00:00:00 | 2023-10-06 00:00:00 | 2023-10-07 00:00:00 |  | NAME | [NAME]
Department 1 | TEST1 | 1 | 1 | 1 | 1 |  | 1 | 1 |  | TEST1 | 4500
 | TEST2 | 1 |  |  | 1 |  |  |  |  | TEST2 | 4500
 | TEST3 | 1 | 1 | 1 | 1 | 1 |  |  |  | TEST3 | 4350
Department 2 | TEST4 | 1 | 1 | 1 | 1 | 1 |  | 1 |  | TEST4 | 3800
 | TEST5 | 1 | 1 | 1 |  | 1 |  | 1 |  | TEST5 | 5620
 | TEST6 | 1 | 1 |  | 1 |  | 1 |  |  | TEST6 | 4380
Depatrtment 3 | TEST7 | 1 |  | 1 | 1 | 1 |  | 1 |  | TEST7 | 2287
 | TEST8 | 1 | 1 |  | 1 |  |  | 1 |  | TEST8 | 9684
 | TEST9 | 1 | 1 | 1 | 1 |  | 1 |  |  | TEST9 | 3987
 | TEST10 | 1 |  | 1 | 1 | 1 | 1 | 1 |  | TEST10 | 6842
Spreadsheet: chris_germany__1970__ENA-Reliant Prepay
Sheet: May 2002

ENA Purchases from Reliant - April 2002
For deliveries on FGT Zone 2 & 3
[NAME] |  | [NAME][PHONE]     [EMAIL]
Backup ENA Trader |  | [NAME]  [PHONE]  [EMAIL]
[NAME] |  | [NAME]  [EMAIL]
City of Tallahassee |  | Pam McCullers [PHONE]
[NAME] |  | [NAME][PHONE]  [EMAIL]
[NAME] |  | [NAME]  [PHONE]  [EMAIL]
Reliant Contracts |  | [NAME]  [PHONE]  [EMAIL]
Reliant Contracts |  | [NAME]  [PHONE]  [EMAIL]
Reliant Settlements |  | [NAME]  [PHONE]  [EMAIL]
Reliant RES Cash Group |  | [NAME]  [PHONE]  [EMAIL]
Reliant RES Cash Group |  | [NAME]  [PHONE]  [EMAIL]
 | Date | Volume | Location | Price [NAME] | GD Post | Price | Total |  | Prepayments | Balance
 |  |  |  |  |  |  |  |  | Balance from April 2002
Wed | 2002-05-01 00:00:00 | 0 |  | [NAME]* | 0 |  |  |  | 0
Thu |  |  |  | [NAME]* | 0 |  |  |  | 0
Fri |  |  |  | [NAME]* | 0 |  |  |  | 0
Sat |  |  |  | [NAME]* | 0 |  |  |  | 0
Sun |  |  |  | [NAME]* | 0 |  |  |  | 0
Mon |  |  |  | [NAME]* | 0 |  |  |  | 0
Tue |  |  |  | [NAME]* | 0 |  |  |  | 0
Wed |  |  |  | [NAME]* | 0 |  |  |  | 0
Thu |  |  |  | [NAME]* | 0 |  |  |  | 0
Fri |  |  |  | [NAME]* | 0 |  |  |  | 0
Sat |  |  |  | [NAME]* | 0 |  |  |  | 0
Sun |  |  |  | [NAME]* | 0 |  |  |  | 0
Mon |  |  |  | [NAME]* | 0 |  |  |  | 0
Tue |  |  |  | [NAME]* | 0 |  |  |  | 0
Wed |  |  |  | [NAME]* | 0 |  |  |  | 0
Thu |  |  |  | [NAME]* | 0 |  |  |  | 0
Fri |  |  |  | [NAME]* | 0 |  |  |  | 0
Sat |  |  |  | [NAME]* | 0 |  |  |  | 0
Sun |  |  |  | [NAME]* | 0 |  |  |  | 0
Mon |  |  |  | [NAME]* | 0 |  |  |  | 0
Tue |  |  |  | [NAME]* | 0 |  |  |  | 0
Wed |  |  |  | [NAME]* | 0 |  |  |  | 0
Thu |  |  |  | [NAME]* | 0 |  |  |  | 0
Fri |  |  |  | [NAME]* | 0 |  |  |  | 0
Sat |  |  |  | [NAME]* | 0 |  |  |  | 0
Sun |  |  |  | [NAME]* | 0 |  |  |  | 0
Mon |  |  |  | [NAME]* | 0 |  |  |  | 0
Tue |  |  |  | [NAME]* | 0 |  |  |  | 0
Wed |  |  |  | [NAME]* | 0 |  |  |  | 0
Thu |  |  |  | [NAME]* | 0 |  |  |  | 0
Fri |  |  |  | [NAME]* | 0 |  |  |  | 0
 |  |  |  | Sitara deal #1203186
 | **  Estimated Gas Daily Midpoint used for flow date indicated.
Spreadsheet: 775450d1649110173-unique-count-and-output-total-count-for-ids-that-meet-condition-test15
Sheet: Sheet1

Serial number |  | Status | ID | Expected | [NAME]
8304013772222700 |  | ISSUED | 568154112108 | 2
8304013772222700 |  | ISSUED | 568154112108 | 2
8336013926733800 |  | ISSUED | 568154112108 | 2
8336013926733800 |  | ISSUED | 568154112108 | 2
3130002954967539 |  | RENEWED | 561448899106 | 1
3130002954967539 |  | RENEWED | 561448899106 | 1
5121000063401700 |  | ISSUED | 559371321100 | 1
8328014380747500 |  | ISSUED | 578954125102 | 3
9192018767647000 |  | ISSUED | 578954125102 | 3
9192018767627000 |  | ISSUED | 578954125102 | 3
0344024411523300 |  | ISSUED | 578923232107 | 1
0344024410593300 |  | ISSUED | 578871123104 | 1
9182018896990400 |  | ISSUED | 579497650100 | 1
0338025304809400 |  | ISSUED | 578899478102 | 1
5121000040271700 |  | REMOTE CANCELLED | 560567694101 | 1
6011003631952200 |  | EXPIRED | 560567694101 | 1
9192018578757000 |  | REMOTE CANCELLED | 560567694101 | 1
9192018578717000 |  | ISSUED | 560567694101 | 1
9192018579187000 |  | REMOTE CANCELLED | 560567694101 | 1
9192018578737000 |  | ASSIGNED | 560567694101 | 1
9192018578727000 |  | ASSIGNED | 560567694101 | 1
2015015612958124 |  | ISSUED | 561874035104 | 1
2015018321958125 |  | RENEWED | 558862935103 | 1
8328014621737500 |  | ISSUED | 578721906104 | 1
8328014621737500 |  | ISSUED | 578721906104 | 1
Spreadsheet: 846630d1697775504-how-to-insert-blank-rows-but-by-using-formulas-rows-1-
Sheet: Sheet1

Table 1 |  |  |  |  | Table 1
Order ID | Customer name | Product | Total price |  | Order ID | Customer name | Product | Total price |  |  | Customer name | Product | Total price
20191111 | [NAME] | [NAME] burger | 60 |  | 20191111 | [NAME] | [NAME] burger | 60 |  |  | [NAME] | [NAME] burger | 60
20191102 | [NAME] | Steak sandwich | 60
20191107 | [NAME] | Steak sandwich | 36
20191113 | [NAME] | Steak sandwich | 12 |  | 20191102 | [NAME] | Steak sandwich | 60 |  |  | [NAME] | Steak sandwich | 60
20191117 | [NAME] | Steak sandwich | 48
20191101 | [NAME] | Sausage sandwich | 108
 |  |  |  |  | 20191107 | [NAME] | Steak sandwich | 36 |  |  | [NAME] | Steak sandwich | 36
 |  |  |  |  | 20191113 | [NAME] | Steak sandwich | 12 |  |  | [NAME] | Steak sandwich | 12
 |  |  |  |  | 20191117 | [NAME] | Steak sandwich | 48 |  |  | [NAME] | Steak sandwich | 48
 |  |  |  |  | 20191101 | [NAME] | Sausage sandwich | 108 |  |  | [NAME] | Sausage sandwich | 108
Spreadsheet: 885053d1734462595-how-to-filter-datas-from-different-columns-within-the-same-filter-sample
Sheet: Sheet1

 |  |  |  |  |  |  |  | Category
 |  |  |  |  |  |  |  | C
 |  |  |  |  |  |  |  | # Project | Category1 | Category2 | Category3 | Category4
 |  |  |  |  |  |  |  | Project 1 | A | B | C | D
 |  |  |  |  |  |  |  | Project 3 |  |  | C | D
 |  |  |  | Project 1 | A, B, C, D
 |  |  |  | Project 2 | A
 |  |  |  | Project 3 | C, D
 |  |  |  | Project 4 | B
 |  |  |  | # Project | Category | Column1 | Column2 | Column3
 |  |  |  | Project 1 | A | B | C | D
 |  |  |  | Project 2 | A
 |  |  |  | Project 3 |  |  | C | D
 |  |  |  | Project 4 |  | B
Spreadsheet: 09a57772-f360-4cda-9c29-ba057ee53d72
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
 | 5671.0 Lending Finance, Australia
 | TABLE 35. LEASE FINANCE COMMITMENTS, By Purpose: State (WA), Original (Number, $000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
1 . . . [NAME] ; |  |  | Original | A2413911L | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | A2413912R | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413913T | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413914V | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | A2413915W | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles  ; |  |  | Original | A2413916X | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
1.3.1a . . . . . . - new trucks ; |  |  | Original | A2413917A | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
. . . . . . . . . . . . [new trucks (no.)] ; |  |  | Original | A2413918C | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | Number | FLOW | Month | 1
1.3.3 a. . . . . . - used trucks ; |  |  | Original | A2413919F | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
. . . . . . . . . . . . [used trucks (no.)] ; |  |  | Original | A2413920R | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | Number | FLOW | Month | 1
1.3.5 . . . . . . . - trailers, buses, coaches, other MVs ; |  |  | Original | A2413921T | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
2 . . . Other Transport Equipment ; |  |  | Original | A2413922V | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
3 . . . Agricultural, Construction & Manufacturing Equipment ; |  |  | Original | A2413923W | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
4 . . . Office Equipment ; |  |  | Original | A2413924X | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
5 . . . Other ; |  |  | Original | A2413925A | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
TOTAL LEASE FINANCE ; |  |  | Original | A2413926C | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2010
Spreadsheet: 34287d1231445274-same-name-but-different-data-book9_jan8
Sheet: Sheet1

Tiger | Dog | Cat | [NAME] | Rat.... |  |  | Very Favourite
ABC | 1 |  |  |  |  |  | Tiger | Dog | Cat | [NAME] | Rat....
CDF |  | 6 |  | 8 |  |  | 10 | 0 | 0 | 0
DEG | 2 |  |  |  |  |  | 0 | 0 | 6 | 0
LFG |  |  |  |  |  |  | 0 | 0 | 0 | 0
EDV |  |  |  |  |  |  | 15 | 0 | 0 | 0
 |  |  |  |  |  |  | 13 | 0 | 0 | 0
Tiger | Dog | Cat | [NAME] | Rat....
ABC | 12
CDF |  | 4 |  | 4
DEG
LFG
EDV | 13
Tiger | Dog | Cat | [NAME] | Rat....
ABC | 10
CDF |  |  | 6
DEG
LFG | 15
EDV | 13
Spreadsheet: 763350d1642116153-how-to-auto-populate-values-based-on-multiple-criteria-sample
Sheet: Mitigation Strategy (2)

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | Risk Assessment |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Program 1
 |  | This report is used to capture identified risks and the initial mitigation that have been implemented to identify the residual risk rating. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Program 2
 |  | AIDS & Hepatitis C Programs
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OPERATIONAL |  |  |  |  |  |  |  |  |  |  |  | STRATEGIC |  |  |  | External Environmental
 |  | Program | Transfer Payment Recipient | Lead TP | 2019/20 Funding $ | Risk Category | Risk Sub Category | Risk Rating | Risk Category | Risk Sub Category | Risk Rating | Risk Category | Risk Sub Category | Risk Rating | Risk Category | Risk Sub Category | Risk Rating | Risk Category | Risk Sub Category | Risk Rating | Risk Category | Risk Sub Category | Risk Rating | Human Resources | Finance | I&IT | Program Delivery | Policy | Project/Initiative | Legal | Regulatory | Emergency Management | Infrastructure | Physical Security | Other | Cultural | Governance | Regulational | Other |  | Identify Mitigation strategy, and timeline/targets for all "Medium" and "High" Risks | Target Date (dd-mm-yy)
Spreadsheet: 824367d1680527813-how-to-start-with-a-balance-then-run-a-cumulative-total-forum-question-2
Sheet: Sheet3

DATE | COMMENT | DEBIT | CREDIT | BALANCE
 | OPENING BALANCE |  |  | 8359.67
2018-06-01 00:00:00 | ELAVON MRCH SVC MSP |  | 800.07 | 9159.74
2019-06-01 00:00:00 | E-TRANSFER CAb8TEr7 |  | 2000 | 11159.74
2018-06-01 00:00:00 | NORTHERN LEASIN MSP | 44.15 |  | 11115.59
2018-06-01 00:00:00 | ELAVON MRCH SVC MSP | 1020.04 |  | 10095.55
2018-06-01 00:00:00 | TAX PYT FEE | 6 |  | 10089.55
2018-06-01 00:00:00 | CHQ#04432-[PHONE] | 160.8 |  | 9928.75
Spreadsheet: a9a97e3b-0f43-4729-95d3-e53dd8627feb
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
43222041 | 2014-09-19 11:49:04 | ALLIES | 0 | 4 | 6 | 331242 | AdairC | 7669 | pacific | 1941-12-23 | 1941-12-23 | Wake Island | Ile de Wake
Spreadsheet: 18016723-1ad0-47b0-b573-2b9dce0dbc53
Sheet: Free Rent Input

Free Rent Input
Input Value for Each Year(partial year)
 | Months | Shell | Op Cost | TI | Security | Structured | Surface | Value of | Value of
Year | Free | (Y or N) | (Y or N) | (Y or N) | (Y or N) | (Y or N) | (Y or N) | Free Rent | Free Shell
1 | 12 | y | n | n | Y | n | n
 | 12 | y | n | n | Y | n | n
 | 12 | y |  |  | Y
 | 12 | y |  |  | Y
 | 12 | y |  |  | Y
 | 12 | y |  |  | Y
 | 12 | y |  |  | Y
 | 12 | y |  |  | Y
 | 7 | y |  |  | Y
 | 3 |  |  |  | Y
Spreadsheet: 39935d1238169546-looking-up-a-range-of-cells-with-criterias-attached-forum-example
Sheet: Handlers

Agent | Band | Rate | Value
[NAME] | ROI PI | 0.21 | #N/A
[NAME] | IRL NB | 0.2 | #N/A
[NAME] | All-In-One | 0.35 | 1.4
[NAME] | IRL NB | 0.125 | 0.8
Zak | PEN | 0.12 | 0.8
Spreadsheet: 457058d1461180527-value-lookups-from-a-table-rccs-refi
Sheet: Conventional AHFC

 | Your actual rate, payment, and costs could be higher. Get an official [NAME] before choosing a loan.
 |  |  |  |  |  | NMLS:
 |  |  |  |  |  | Office:
 |  |  |  |  |  | Cell:
 |  |  |  |  |  | Fax:
 |  |  |  |  |  | [NAME]:
 | Loan Program: Conventional AHFC
 | Loan Details |  |  |  |  | Monthly Payment Information
 | Estimated Value |  |  |  |  | Principal and Interest |  |  |  |  |  | [NAME]
 |  |  |  |  |  | Property Taxes |  |  |  |  |  | [NAME] | 0.45
 | Total Loan Amount |  |  |  |  | Estimated Homeowners Insurance |  |  |  |  |  | [NAME]
 |  |  |  |  |  | Mortgage Insurance |  | 0.85 |  |  |  | PMI Percentage
 |  |  |  |  |  | Homeowners Association Dues |  |  | 0 |  |  | [NAME]
 | Interest Rate |  |  | 0.03875 |  |  |  |  |  |  |  | [NAME]
 | [NAME] |  |  | 30
 | AHFC Commitment Fee |  |  | 0.0025
 | Number of Units |  |  | 1 |  | Total Monthly Payment
 | Cash to Close Amounts
 | Closing Costs
 | Prepaid Costs
 |  | Total
 | Closing Costs |  |  |  |  | Prepaid Expenses
 | [NAME] fee |  |  |  |  | Interest | 15 | days
 | AHFC Commitment Fee |  |  |  |  | Taxes | 7 | months
 | Credit Report fee |  |  | 0 |  | Homeowners Insurance | 14 | months
 | Wire fee |  |  | 40 |  | Homeowners Dues | 0 | months
 | [NAME] fee |  |  | 290 |  |  |  |  | 0
 | Tax registration fee |  |  | 92
 | Flood Certification |  |  | 11 |  | Total
 | Title Closing fees |  |  | 250 |  | Income Ratios
 | Title Insurance - ALTA
 | Recording Fees |  |  | 100 |  | Income
 |  |  |  | 0 |  | Monthly debts
 |  |  |  | 0 |  | Housing Ratio
 | Total |  |  |  |  | [NAME]
Spreadsheet: 777782d1650615954-sum-of-values-in-column-based-on-unique-ids-in-another-column-test24v2
Sheet: Sheet1

ID |  |  |  |  |  |  |  |  |  | Total Tokens |  |  |  |  | Team |  |  |  | Unique ID's with more than 1 token - Combined Total | 7
141508273044 |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  | 3 unique ID's where K > 1 and P = yes
144375885015 |  |  |  |  |  |  |  |  |  | 1
144375885015 |  |  |  |  |  |  |  |  |  | 1
147890650046 |  |  |  |  |  |  |  |  |  | 1
147890650046 |  |  |  |  |  |  |  |  |  | 1
159777699038 |  |  |  |  |  |  |  |  |  | 1
159777699038 |  |  |  |  |  |  |  |  |  | 1
162153917032 |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  | Yes
168131196045 |  |  |  |  |  |  |  |  |  | 1
168131196045 |  |  |  |  |  |  |  |  |  | 1
168539305040 |  |  |  |  |  |  |  |  |  | 1
168615082562 |  |  |  |  |  |  |  |  |  | 1
172888341044 |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  | Yes
172888341044 |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  | Yes
175149526048 |  |  |  |  |  |  |  |  |  | 1
175149526048 |  |  |  |  |  |  |  |  |  | 1
177907246041 |  |  |  |  |  |  |  |  |  | 1
181653732014 |  |  |  |  |  |  |  |  |  | 1
186048215567 |  |  |  |  |  |  |  |  |  | 2
186048215567 |  |  |  |  |  |  |  |  |  | 2
188146635563 |  |  |  |  |  |  |  |  |  | 3 |  |  |  |  | Yes
188437741567 |  |  |  |  |  |  |  |  |  | 1
Spreadsheet: 693596d1599052433-sumifs-not-working-pulling-zero-monthly-example
Sheet: People

 |  |  |  | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | Total
 |  |  | Me
 |  |  | Mom
 |  |  | Sis
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | Lil
 |  |  | total
Spreadsheet: 880557d1728350905-reducing-buy-average-trading
Sheet: Sheet2

Date | Qty | Buy Price |  | Date | Qty | Buy Price
2024-01-01 00:00:00 | 1 | 100 |  | 2024-01-01 00:00:00 | 1 | 100 |  |  | incorrect formula
2024-01-04 00:00:00 | 1 | 99.5 |  | 2024-01-04 00:00:00 | 1 | 99.5 |  |  | correct formula
2024-01-07 00:00:00 | 1 | 99.2 |  | 2024-01-07 00:00:00 | 1 | 99.2 |  |  | using [NAME]
 |  |  |  | Now | 88525.06000063788 | 80
Average |  |  |  | Average
Current Price |  | 80 |  | Current Price |  | 80 |  | Using Algebra
 |  |  |  |  |  |  |  | (qty*80+1*100+1*99.5+1*99.2)/total qty = 80
Average |  |  |  |  |  |  |  | => (qty*80+(100+99.5+99.2))/(qty+3) = 80
 |  |  |  |  |  |  |  | => (qty*80+298.7)/(qty+3) = 80
 |  |  |  |  |  |  |  | => qty*80+298.7 = 80*(qty+3)
Total buying price |  |  |  |  |  |  |  | => qty*80+298.7 = 80*qty+240
Total Qty |  |  |  |  |  |  |  | => 298.7-240 = 80*qty-qty*80
Average price |  |  |  |  |  |  |  | => 58.7 = 0?
 |  |  |  |  |  |  |  | => not possible for average price to be exactly 80