tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 880635d1728468110-formula-seems-to-not-be-including-values-test-data
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | 2024-04-08 00:00:00 | 2024-04-15 00:00:00 | 2024-04-22 00:00:00 | 2024-04-29 00:00:00 | 2024-05-06 00:00:00 | 2024-05-13 00:00:00 | 2024-05-20 00:00:00 | 2024-05-27 00:00:00 | 2024-06-03 00:00:00 | 2024-06-10 00:00:00 | 2024-06-17 00:00:00 | 2024-06-24 00:00:00 | 2024-07-01 00:00:00 | 2024-07-08 00:00:00 | 2024-07-15 00:00:00 | 2024-07-22 00:00:00 | 2024-07-29 00:00:00 | 2024-08-05 00:00:00 | 2024-08-12 00:00:00 | 2024-08-19 00:00:00 | 2024-08-26 00:00:00 | 2024-09-02 00:00:00 | 2024-09-09 00:00:00 | 2024-09-16 00:00:00 | 2024-09-23 00:00:00 | 2024-09-30 00:00:00 | 2024-10-07 00:00:00 | 2024-10-14 00:00:00 | 2024-10-21 00:00:00 | 2024-10-28 00:00:00 | 2024-11-04 00:00:00 | 2024-11-11 00:00:00 | 2024-11-18 00:00:00 | 2024-11-25 00:00:00 | 2024-12-02 00:00:00 | 2024-12-09 00:00:00 | 2024-12-16 00:00:00 | 2024-12-23 00:00:00 | 2024-12-30 00:00:00 | 2025-01-06 00:00:00 | 2025-01-13 00:00:00 | 2025-01-20 00:00:00 | 2025-01-27 00:00:00 | 2025-02-03 00:00:00 | 2025-02-10 00:00:00 | 2025-02-17 00:00:00 | 2025-02-24 00:00:00 | 2025-03-03 00:00:00 | 2025-03-10 00:00:00 | 2025-03-17 00:00:00 | 2025-03-24 00:00:00 | 2025-03-31 00:00:00 | 2025-04-07 00:00:00 | 2025-04-14 00:00:00 | 2025-04-21 00:00:00 | 2025-04-28 00:00:00 | 2025-05-05 00:00:00 | 2025-05-12 00:00:00 | 2025-05-19 00:00:00 | 2025-05-26 00:00:00 | 2025-06-02 00:00:00 | 2025-06-09 00:00:00 | 2025-06-16 00:00:00 | 2025-06-23 00:00:00 | 2025-06-30 00:00:00
 |  |  |  | Start | End
 |  |  |  | 2024-04-01 00:00:00 | 2025-07-04 00:00:00
Spreadsheet: 716070d1612008221-tiered-payments-with-multiple-variables-sample-workbook
Sheet: Sheet1

 |  |  |  |  | Payment calculation between start and end (Updated formula) | Xlent's Formula in G2
 |  |  |  |  |  |  |  |  | Condition 1 | Condition 2
Start | End |  |  |  |  |  |  |  | H | nV
2020-05-28 00:00:00 | 2021-12-22 00:00:00 |  | Start | End | Status 1 | Status 2
 |  |  | 0 | 3 | H | nV | 317
 |  |  | 3 | 6 | H | nV | 208
 |  |  | 6 | 12 | H | nV | 202
 |  |  | 12 | 24 | H | nV | 141
 |  |  | 24 | 999999 | H | nV | 102
 |  |  | 0 | 3 | H | V | 327
 |  |  | 3 | 6 | H | V | 257
 |  |  | 6 | 12 | H | V | 229
 |  |  | 12 | 24 | H | V | 149
 |  |  | 24 | 999999 | H | V | 127
 |  |  | 0 | 3 | nH | nV | 339
 |  |  | 3 | 6 | nH | nV | 277
 |  |  | 6 | 12 | nH | nV | 246
 |  |  | 12 | 24 | nH | nV | 198
 |  |  | 24 | 999999 | nH | nV | 171
 |  |  | 0 | 3 | nH | V | 486
 |  |  | 3 | 6 | nH | V | 339
 |  |  | 6 | 12 | nH | V | 312
 |  |  | 12 | 24 | nH | V | 257
 |  |  | 24 | 999999 | nH | V | 211
Spreadsheet: 265850d1379424312-conditional-formatting-data-sample
Sheet: Sheet1

Grade 7 | Questions |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Results
DCMT | #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 | #32 | #33 | #34 | #35 | #36 | #37 | #38 | #39 | #40 | #41 | #42 | #43 | #44 | #45 | #46 | #47 | #48 | #49 | #50 | #51 | #52 | #53 | #54 | #55 | #56 | #57 | #58 | #59 | #60 | #71 | #72 | #73 | #74 | #75 |  | Score | Range
Student 1 | x | x |  | x |  |  |  | x | x |  |  |  | x | x | x | x | x |  |  | x |  |  |  |  | x | x | x | x | x |  |  |  | x |  | x |  |  | x |  |  |  | x |  |  |  |  |  | x | x |  | x | x | x | x | x |  | x |  |  |  | x |  | x | x | x
Student 2 |  | x |  |  |  |  |  | x | x | x | x |  | x | x | x | x |  |  | x | x |  |  |  | x |  |  | x |  | x | x |  |  |  | x |  |  | x |  |  | x | x |  | x | x |  |  |  |  |  | x | x |  | x | x | x |  | x |  |  | x | x
Student 3 | x | x |  |  | x | x |  |  |  | x |  |  | x | x | x | x | x | x |  | x | x |  |  | x |  | x | x | x |  |  | x | x |  |  | x | x | x |  |  | x | x | x |  | x |  | x |  |  |  |  | x |  | x | x | x | x | x | x | x | x | x | x |  | x | x
Spreadsheet: 649061d1573457921-run-time-error-in-macro-time-series-upper-aquifer-qw-spreadsheet
Sheet: C Well 8

Well | Date | pH | EC | Ca | [NAME] | Na | Alk as CaCO3 | HCO3  as  CaCO3 | CO3  as  CaCO3 | SO4 | Cl | TDS | SAR | SARadj | B | NO3-N | Cu | Fe | Mn | Zn | L.I. |  | Sum cat | [NAME] | % Dif
 | Sampled | unit | dS/m | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | mg/L |  |  | mg/L | mg/L | mg/L | mg/L | mg/L | mg/L | Calc
C8 | 2017-08-08 00:00:00 |  | 1.07 |  |  |  |  |  |  |  |  | 605 |  |  |  | 3.77
C8 | 2018-08-15 00:00:00 |  | 0.79 | 61.6 | 16.8 | 75 |  | 148 | <1 | 37.7 | 176 | 493 |  |  |  | 2.9
Spreadsheet: 818008d1676549090-multiple-dependent-drop-down-lists-case-log-test-1
Sheet: Summary 

 |  |  | Formal Process
Formal CASE BY MONTH |  |  | Case type by Area | LTS | STS | Conduct | Grievance | Probation | Cpbability
 | LOGGED CASES
2023-01-01 00:00:00
2023-02-01 00:00:00
2023-03-01 00:00:00
2023-04-01 00:00:00
2023-05-01 00:00:00
2023-06-01 00:00:00
2023-07-01 00:00:00
2023-08-01 00:00:00
2023-09-01 00:00:00
2023-10-01 00:00:00
2023-11-01 00:00:00
2023-12-01 00:00:00
YEAR TO DATE
 |  |  | Informal, Advice, Guidance or Referral
INFormal CASE BY MONTH |  |  | Case type by Area | Sickness Absence | Performance | Flexible Working | Hybred Working | Health and Wellbeing
 | LOGGED CASES
JANUARY
FEBRUARY
[NAME]
APRIL
MAY
[NAME]
JULY
AUGUST
SEPTEMBER
OCTOBER
NOVEMBER
DECEMBER
YEAR TO DATE
CASE BY POLICY |  |  | Legal | Acas | ET
Grievance
Probation
Absence
Advice
Bullying/Harassment
Occ Health
Stess Risk Assessment
Capbility
Managament Instruction
Flexible Working
Other
PIP
ACAS
ET
DSAR
Spreadsheet: eric_saibi__9948__110601R
Sheet: Comanche 01-2 CT

Owner Name |  | AEP - Public Service Company of Oklahoma
Station Name |  | Comanche Power Station
Unit Name |  | Unit 01-2 CT/HRSG
NERC Region |  | SPP
State |  | OK
Fuel Type |  | Natural Gas / Fuel Oil
Capacity |  | 85 MW
Start Date |  | 2001-09-28 00:00:00
End Date |  | 2001-11-08 00:00:00
Prv. Start Date |  | 2001-11-07 00:00:00
Prv. End Date |  | 2001-11-10 00:00:00
Comments |  | Inspection
SIC |  | 4911
Plant ID |  | 1009084
Unit ID |  | 1007259
Outage ID |  | 18676
Spreadsheet: 200300d1355490687-average-time-per-combination-help-combination-formula
Sheet: Sheet1

first group |  | second group |  | test
name 1 |  | name 11 |  | test 1
name 2 |  | name 12 |  | test 2
name 3 |  | name 13 |  | test 3
name 4 |  | name 14 |  | test 4
name 5 |  | name 15 |  | test 5
name 6 |  | name 16 |  | test 6
name 7 |  | name 17 |  | test 7
name 8 |  | name 18 |  | test 8
name 9 |  | name 19 |  | test 9
name 10 |  | name 20 |  | test 10
Data
person 1 | person 2 |  | test |  | time took
name 1 | name 12 |  | test 1 |  | 02:20:00
name 1 | name 5 |  | test 1 |  | 01:50:00
name 4 | name 5 |  | test 2 |  | 01:08:00
name 7 | name 12 |  | test 2 |  | 03:10:00
name 1 | name 5 |  | test 1 |  | 01:43:00
name 1 | name 5 |  | test 2 |  | 02:26:00
Average time took per combination
name 1 | and | name 13 | for | test 1 | is
 | Drop Down Menus |  |  |  |  |  | Answer
Spreadsheet: sally_beck__33824__global standards daily reporting
Sheet: D 01

Quantitative Standards
Daily Exception Reports
Reports Supporting Quantitative Standards C
Report D 01:
Purpose: | To capture how many corrections there had to be when reconciling invoices to contracts.
Trade Date | Deal # | Commodity | Counterparty | Description of deal | Description of reconciling item | P&L impact to GL gain / (loss) state currency | Key contact
2000-10-25 00:00:00 | Sample | Gas | Coral Energy LP | Sale of Henry Hub gas | Per contract $4 per mmbtu, per invoice $4.25.  Amendment to contract not captured in risk mgmt system.  Not caught until invoicing. |  | [NAME]
Spreadsheet: kevin_presto__20238__EIA411 Reporting Forms Revised 01 30 02
Sheet: Master LR Monthly

2002 | SERC |  | U |  | MDA
 |  |  |  |  | MDF
 |  |  |  |  | MDS
 |  |  |  |  | MNLA
 |  |  |  |  | MNLF
 |  |  |  |  | MNLS
Spreadsheet: 049cbbb0-359d-4c28-a62d-b92426cf2cf2
Sheet: Budget Adjustment

BUDGET ADJUSTMENT
Ordinance Fact Sheet |  |  |  |  |  |  | Ordinance Number
Brief Title |  | Approval Deadline |  |  | Reason
Details |  |  |  |  | Department, Program, or Accounts Affected
Reason for Adjustment |  |  |  |  | Sponsor
 |  |  |  |  | From/Transferor(s) or Fund Title(s)
 |  |  |  |  | To/Transferee(s) or [NAME])
 |  |  |  |  | Policy / Program Impact
 |  |  |  |  | Policy or Program | No | Yes
 |  |  |  |  | Emphasis Change
 |  |  |  |  | Operational
 |  |  |  |  | Impact
 |  |  |  |  | Assessment
 |  |  |  |  | Council Committee Actions
 |  |  |  |  | Do Pass |  | Hold
 |  |  |  |  | Do Pass (as amended) |  | w/o Recommendation
 |  |  |  |  | Committee Sub. |  | Do Not Pass
 |  |  |  |  | Fact Sheet prepared by: |  | Date
 |  |  |  |  | Fact Sheet reviewed by: |  | Date
 |  |  |  |  | Reference Numbers
Spreadsheet: 885697d1735518571-add-or-remove-rows-to-only-part-of-the-columns-of-a-table-add-or-embedd-a-row-into-columns-of-an-existing-table-r2
Sheet: BooKRef Team M

M-Team
Surname | First name | Number | [NAME] | Task A | Part of Task A completed | Next part of Task A | x1 | Task B | Part of Task B completed | Next part of Task B | x2 | Task C | Part of Task C completed | Next part of Task C | [NAME] | Task D | Part of Task D completed | Next part of Task D
 | Wayne | 80111210 |  | M03
F | G | 89000001
[NAME] | [NAME] | 80111005 |  | M03
[NAME] | Johnson Onuche | 80110907 |  | M18 | X | BSC |  | M25 IME | X | BSC
Jordan | Mick | 80111179 |  | M03 | BSC-SF | BSC-TR1 |  | M04 | BSC-SF | BSC-TR1
Moses | Mark | 80110911 |  | M07 | ADV-TR2 | [NAME] |  | M22 | ADV | ADV-TR1
Spreadsheet: 837619d1690294009-matching-two-lists-of-postcodes-example-2-1-
Sheet: Sheet1

 |  |  | Addresses | Location |  |  |  | City Centre | Suburbs | Town Centre | Outskirts
 |  |  | M3 1AA |  |  |  |  | M30 0BF | M3 1AA | M28 1AD | M7 0ED
 |  |  | M30 0BF |  |  |  |  | M30 0ES | M3 5BY | M28 1DD | M7 1AJ
 |  |  | M28 1DD |  |  |  |  | M30 0FB | M3 5EH | M28 1EB | M7 1AX
 |  |  | M28 1EB |  |  |  |  | M30 0FP | M3 5FE | M28 1ET | M7 1BF
 |  |  | M27 5WY |  |  |  |  | M30 0FW | M3 5FW | M28 1FG | M7 1BQ
 |  |  | M70ED |  |  |  |  | M30 0GD | M3 5GQ | M28 1FT | M7 1GY
 |  |  | M3 5FW
 |  |  | M44 6FE
Spreadsheet: 885631d1735424855-issues-with-pivotby-function-pivotby
Sheet: Sheet1

 | Date | Type | Description | Amount | Month | Mth |  | Expense
 | 2024-07-25 00:00:00 | Expense | test | 10000 |  |  |  |  | Aug | Jul | Oct | Sep | Total
 | 2024-08-01 00:00:00 | Expense | Office Supplies | 150 |  |  |  | Marketing | 400 |  | 291 | 400 | 1091
 | 2024-08-03 00:00:00 | Revenue | Product Sales | 1200 |  |  |  | Office Supplies | 150 |  | 230 | 150 | 530
 | 2024-08-05 00:00:00 | Expense | Travel | 300 |  |  |  | Rent | 1000 |  | 598 | 1000 | 2598
 | 2024-08-07 00:00:00 | Revenue | Service Fees | 800 |  |  |  | test |  | 10000 |  |  | 10000
 | 2024-08-10 00:00:00 | Expense | Utilities | 200 |  |  |  | Travel | 300 |  | 1200 | 300 | 1800
 | 2024-08-12 00:00:00 | Revenue | Consulting | 1500 |  |  |  | Utilities | 200 |  | 800 | 200 | 1200
 | 2024-08-15 00:00:00 | Expense | Marketing | 400 |  |  |  | Total | 2050 | 10000 | 3119 | 2050 | 17219
 | 2024-08-18 00:00:00 | Revenue | Subscription Fees | 700
 | 2024-08-20 00:00:00 | Expense | Rent | 1000
 | 2024-08-22 00:00:00 | Revenue | Sponsorship | 900
 | 2024-09-01 00:00:00 | Expense | Office Supplies | 150
 | 2024-09-03 00:00:00 | Revenue | Product Sales | 1200
 | 2024-09-05 00:00:00 | Expense | Travel | 300 |  |  |  | Revenue
 | 2024-09-07 00:00:00 | Revenue | Service Fees | 800 |  |  |  |  | Aug | Oct | Sep | Total
 | 2024-09-10 00:00:00 | Expense | Utilities | 200 |  |  |  | Consulting | 1500 | 490 | 1500 | 3490
 | 2024-09-12 00:00:00 | Revenue | Consulting | 1500 |  |  |  | Product Sales | 1200 | 352 | 1200 | 2752
 | 2024-09-15 00:00:00 | Expense | Marketing | 400 |  |  |  | Service Fees | 800 | 275 | 800 | 1875
 | 2024-09-18 00:00:00 | Revenue | Subscription Fees | 700 |  |  |  | Sponsorship | 900 | 300 | 900 | 2100
 | 2024-09-20 00:00:00 | Expense | Rent | 1000 |  |  |  | Subscription Fees | 700 | 457 | 700 | 1857
 | 2024-09-22 00:00:00 | Revenue | Sponsorship | 900 |  |  |  | Total | 5100 | 1874 | 5100 | 12074
 | 2024-10-01 00:00:00 | Expense | Office Supplies | 230
 | 2024-10-03 00:00:00 | Revenue | Product Sales | 352
 | 2024-10-05 00:00:00 | Expense | Travel | 1200
 | 2024-10-07 00:00:00 | Revenue | Service Fees | 275
 | 2024-10-10 00:00:00 | Expense | Utilities | 800
 | 2024-10-12 00:00:00 | Revenue | Consulting | 490
 | 2024-10-15 00:00:00 | Expense | Marketing | 291
 | 2024-10-18 00:00:00 | Revenue | Subscription Fees | 457
 | 2024-10-20 00:00:00 | Expense | Rent | 598
 | 2024-10-22 00:00:00 | Revenue | Sponsorship | 300
Spreadsheet: 704677d1605694739-sum-hlookup-with-cell-references-instead-of-values-for-col_indexes-sample-book-sumhlookup
Sheet: Sheet1

November |  | 2020
 |  |  |  |  |  |  | January | 1
 |  |  |  |  |  |  | February | 2
 |  |  |  |  |  |  | March | 3
Date |  | Data (random for example) |  |  |  |  | April | 4
 |  |  |  |  |  |  | May | 5
 |  |  |  |  |  |  | June | 6
1 |  |  |  |  |  |  | July | 7
 |  |  |  |  |  |  | August | 8
 |  |  |  |  |  |  | September | 9
 |  |  |  |  |  |  | October | 10
 |  |  |  |  |  |  | November | 11
 |  |  |  |  |  |  | December | 12
 |  |  |  |  |  |  |  | First of month
 |  |  |  |  |  |  |  | First Monday of month
 |  |  |  |  |  |  |  | row ref first monday
Totals | Month
Spreadsheet: sally_beck__35352__Metrics
Sheet: Sheet1

FACT Metrics
 | Week Ending
 | 2001-10-26 00:00:00
Active User Accounts | 4
Total Record Count
New Deals | 36
Revised Deals | 232
[NAME] | 64
Sent to Counterparty | 35
Executed | 25
% Uptime | 1
Unplanned Downtime (HH:MM) | 0
Spreadsheet: 09f98a9a-01c6-4fae-8b49-992d2d94c9fd
Sheet: Page 1

Permit No.: |  | WQ0002838 |  | Facility Name: |  | Deerhurst Mobile Home Park |  |  |  |  | County: | Wake |  | Month: |  |  | Year:
PPI: |  | 001 | Flow Measuring Point: |  |  |  |  |  |  | Parameter Monitoring Point:
Parameter Code |  |  | 50050 | 00310 | 50060 | 31616 | 00610 | 00625 | 00620 | 00400 | 00530
Day | ORC Arrival Time | ORC Time On Site | Flow
 | 24-hr | hrs | GPD
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
Average:
Daily Maximum:
Daily Minimum:
Sampling Type: |  |  | Recorder | Grab | Grab | Grab | Grab | Grab | Grab | Grab | Grab
Monthly Limit: |  |  | 19229
Daily Limit:
Sample Frequency: |  |  | [NAME] | 4 x Year | 4 x Year | 4 x Year | 4 x Year | 4 x Year | 4 x Year | 4 x Year | 4 x Year
Spreadsheet: michelle_lokay__26705__On Call Schedule
Sheet: Sheet1

TW On-Call Schedule 2002
[PHONE]
Code 184262#
Weekend | On-Call
Jan 5-6 | [NAME]
Jan 12-13 | Y'Barbo
Jan 19-20-21 MLK Holiday | Watson
Jan 26-27 | [NAME]
Feb 2-3 | [NAME]
Feb 9-10 | Lokay
Feb 16-17-18 President's Day | [NAME]
Feb 23-24 | Y'Barbo
[NAME] | Watson
[NAME] | [NAME]
[NAME] | [NAME]
Mar 23-24 | Lokay
[NAME] | [NAME]
Apr 6-7 | Y'Barbo
Apr 13-14 | Watson
Apr 20-21 | [NAME]
Apr 27-28 | [NAME]
May 4-5 | Lokay
May 11-12 | [NAME]
May 18-19 | Y'Barbo
May 25-26-27 Memorial Day | Lokay
[NAME] | [NAME]
[NAME] | [NAME]
Jun 15-16 | Lokay
Jun 22-23 | [NAME]
Jun 29-30 | Y'Barbo
[NAME], 6-7 | [NAME]
Jul 13-14 | Watson
Jul 20-21 | [NAME]
Jul 27-28 | Lokay
Aug 3-4 | [NAME]
Aug 10-11 | Y'Barbo
Aug 17-18 | Watson
Aug 24-25 | [NAME]
Aug 31 - Sept 1 - 2 Labor Day | [NAME]
Sept 7-8 | Lokay
Sept 14-15 | [NAME]
Sept 21-22 | Y'Barbo
Sept 28-29 | Watson
Oct 5-6 | [NAME]
Oct 12-13 | [NAME]
Oct 19-20 | Lokay
Oct 26-27 | [NAME]
Nov 2-3 | Y'Barbo
Nov 9-10 | Watson
Nov 16-17 | [NAME]
Nov 23-24 | [NAME]
Nov 28, 29, 30 - Dec 1 | [NAME]
Dec 7-8 | Lokay
Dec 14-15 | Watson
Dec 21-22,24,25 | Y'Barbo
Dec 28-29, Jan 1 | [NAME]
Jan 4-5 | [NAME]
Spreadsheet: 0038822a-7dce-48ba-8c64-7ead9514b93a
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 44. OPERATING LEASE FINANCE COMMITMENTS: By Purpose: State (QLD), 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 | A2413781A | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | A2413782C | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413783F | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413784J | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | A2413785K | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles ; |  |  | Original | A2413786L | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
2. . . Other Transport Equipment ; |  |  | Original | A2413787R | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
3. . . Agricultural, Construction & Manufacturing equipment ; |  |  | Original | A2413788T | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
4. . . Office Equipment  ; |  |  | Original | A2413789V | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
5. . . Other ; |  |  | Original | A2413790C | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
TOTAL OPERATING LEASE FINANCE ; |  |  | Original | A2413791F | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2011
Spreadsheet: 838026d1690628569-identify-unique-rows-with-conditions-deletion-with-conditions-problem
Sheet: Target Data

Reference | Questionnaire
ABB0090002 | 1 - Sent & not returned
ACF0010001 | 3 - Sent & returned complete
ACO0030001 | 3 - Sent & returned complete
ACT0010001 | 3 - Sent & returned complete
[NAME]
ADA0120001 | 3 - Sent & returned complete
ADA0120002
ADA0120003 | 3 - Sent & returned complete
ADA0120004 | 3 - Sent & returned complete
ADA0120005 | 3 - Sent & returned complete
ADD0040002
AEG0010001 | 1 - Sent & not returned
[NAME] | 1 - Sent & not returned
ALB0010010 | 3 - Sent & returned complete
[NAME] | 3 - Sent & returned complete
ALI0300001 | 1 - Sent & not returned
ALP0010001 | 1 - Sent & not returned
AME0010001 | 1 - Sent & not returned
AME0010002 | 1 - Sent & not returned
AND0180001 | 1 - Sent & not returned
AND0180002 | 1 - Sent & not returned
ANG0020006 | 3 - Sent & returned complete
APE0010003 | 1 - Sent & not returned
APE0010004 | 1 - Sent & not returned
APL0010001 | 3 - Sent & returned complete
ARC0070004 | 1 - Sent & not returned
ARD0010003 | 3 - Sent & returned complete
ARU0010006
ARU0010007 | 3 - Sent & returned complete
ARU0040002
ARU0040003
ASH0030007
ASH0030008
ASH0030009
ASH0090003 | 3 - Sent & returned complete
ASH0090004 | 3 - Sent & returned complete
ASH0220001 | 3 - Sent & returned complete
ASP0040002 | 1 - Sent & not returned
[NAME] | 1 - Sent & not returned
ATR0010003
AUC0010004 | 1 - Sent & not returned
AVE0030002 | 3 - Sent & returned complete
AVE0060005
AVE0060007
AVO0010002
AVO0010003 | 3 - Sent & returned complete
Spreadsheet: 60596d1261098635-form-development-help-adding-rows-sample-worksheet
Sheet: Reporting Form

The second sheet is my form that is the end product.  It links to the data from the first sheet, but has a LOT of standard language clauses to go with it.
For question 1, this is the kind of operation I need:
 |  | <----I would have an if-then statement of some sort here.  If the linked cell (F5 from the first tab in this case) is a Y then the a row is inserted along with the corresponding wording.   If the answer is N, then no row is added.
For question 2, this is the kind of operation I need:
Standard language for this part of the form is already inserted here.
 | Creditor | Collateral | Value | Claim | Int. Rate | Monthly Payment
 |  |  |  |  |  |  | <----spread sheet would insert enough rows here based on the number of creditors entered on D10 on the first tab and link to the corresponding cells on the first tab.
Standard language for this part of the form is already inserted here.
 | Creditor | Collateral | Value | Claim | Int. Rate | Monthly Payment
 |  |  |  |  |  |  | <----spread sheet would insert enough rows here based on the number of creditors entered on D14 on the first tab and link to the corresponding cells on the first tab.
For question 3, this is the kind of operation I need:
 | Plan Payment: |  |  | <----An entry could be added/changed here and the cell would be linked with cells on other tabs.  A change to ANY of the cells would update the cells on the other tabs.  I could change it here or on the quick summary or on the data entry tab.
Spreadsheet: 24176af2-ea6e-4fe2-8277-c20eea2c2c8b
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
DATE INITIATED |  | SEMESTER
NAME |  | BANNER ID |  | LOCAL TELEPHONE NUMBER
MAJOR |  | MINOR  OR CONCENTRATION |  | Student Signature
1.
REASON(s) FOR REQUEST:
CRN                                                 SUBJECT                        COURSE NUMBER                       SECTION                                                    COURSE TITLE                                                              COURSE CREDIT HOURS
2.
REASON(s) FOR REQUEST:
CRN                                                 SUBJECT                        COURSE NUMBER                       SECTION                                                    COURSE TITLE                                                              COURSE CREDIT HOURS
3.
REASON(s) FOR REQUEST:
CRN                                                 SUBJECT                        COURSE NUMBER                       SECTION                                                    COURSE TITLE                                                              COURSE CREDIT HOURS
ACADEMIC ADVISOR (please print) |  | ACADEMIC ADVISOR SIGNATURE |  | DATE:
DEPARTMENT CHAIRPERSON (please print) |  | DEPARTMENT CHAIRPERSON SIGNATURE |  | DATE:
Office of the Registrar     March 2009